jscriptexpense.js

function getValue(r1c1, r1c2, r1c3, r1c4, r1c5, r1c6, r1c7) {
  a = document.getElementById("r1c1").value;
  b = document.getElementById("r1c2").value;
  c = document.getElementById("r1c3").value;
  d = document.getElementById("r1c4").value;
  e = document.getElementById("r1c5").value;
  f = document.getElementById("r1c6").value;
  g = document.getElementById("r1c7").value;
}
function calculate() {
  getValue();
  sum =
    Number(a) +
    Number(b) +
    Number(c) +
    Number(d) +
    Number(e) +
    Number(f) +
    Number(g);
  sum1 = document.getElementById("result").innerHTML = sum;
}

function getValue2(r2c1, r2c2, r2c3, r2c4, r2c5, r2c6, r2c7) {
  a = document.getElementById("r2c1").value;
  b = document.getElementById("r2c2").value;
  c = document.getElementById("r2c3").value;
  d = document.getElementById("r2c4").value;
  e = document.getElementById("r2c5").value;
  f = document.getElementById("r2c6").value;
  g = document.getElementById("r2c7").value;
}
function calculate2() {
  getValue2();
  sum =
    Number(a) +
    Number(b) +
    Number(c) +
    Number(d) +
    Number(e) +
    Number(f) +
    Number(g);
  document.getElementById("result2").innerHTML = sum;
}

function getValue3(r3c1, r3c2, r3c3, r3c4, r3c5, r3c6, r3c7) {
  a = document.getElementById("r3c1").value;
  b = document.getElementById("r3c2").value;
  c = document.getElementById("r3c3").value;
  d = document.getElementById("r3c4").value;
  e = document.getElementById("r3c5").value;
  f = document.getElementById("r3c6").value;
  g = document.getElementById("r3c7").value;
}
function calculate3() {
  getValue3();
  sum =
    Number(a) +
    Number(b) +
    Number(c) +
    Number(d) +
    Number(e) +
    Number(f) +
    Number(g);
  document.getElementById("result3").innerHTML = sum;
}

function getValue4(r4c1, r4c2, r4c3, r4c4, r4c5, r4c6, r4c7) {
  a = document.getElementById("r4c1").value;
  b = document.getElementById("r4c2").value;
  c = document.getElementById("r4c3").value;
  d = document.getElementById("r4c4").value;
  e = document.getElementById("r4c5").value;
  f = document.getElementById("r4c6").value;
  g = document.getElementById("r4c7").value;
}
function calculate4() {
  getValue4();
  sum =
    Number(a) +
    Number(b) +
    Number(c) +
    Number(d) +
    Number(e) +
    Number(f) +
    Number(g);
  sum4 = document.getElementById("result4").innerHTML = sum;
}

function getValue5(r5c1, r5c2, r5c3, r5c4, r5c5, r5c6, r5c7) {
  a = document.getElementById("r5c1").value;
  b = document.getElementById("r5c2").value;
  c = document.getElementById("r5c3").value;
  d = document.getElementById("r5c4").value;
  e = document.getElementById("r5c5").value;
  f = document.getElementById("r5c6").value;
  g = document.getElementById("r5c7").value;
}
function calculate5() {
  getValue5();
  sum =
    Number(a) +
    Number(b) +
    Number(c) +
    Number(d) +
    Number(e) +
    Number(f) +
    Number(g);
  sum5 = document.getElementById("result5").innerHTML = sum;
}

function getValue6(r6c1, r6c2, r6c3, r6c4, r6c5, r6c6, r6c7) {
  a = document.getElementById("r6c1").value;
  b = document.getElementById("r6c2").value;
  c = document.getElementById("r6c3").value;
  d = document.getElementById("r6c4").value;
  e = document.getElementById("r6c5").value;
  f = document.getElementById("r6c6").value;
  g = document.getElementById("r6c7").value;
}
function calculate6() {
  getValue6();
  sum =
    Number(a) +
    Number(b) +
    Number(c) +
    Number(d) +
    Number(e) +
    Number(f) +
    Number(g);
  sum6 = document.getElementById("result6").innerHTML = sum;
}

function getValue7(r7c1, r7c2, r7c3, r7c4, r7c5, r7c6, r7c7) {
  a = document.getElementById("r7c1").value;
  b = document.getElementById("r7c2").value;
  c = document.getElementById("r7c3").value;
  d = document.getElementById("r7c4").value;
  e = document.getElementById("r7c5").value;
  f = document.getElementById("r7c6").value;
  g = document.getElementById("r7c7").value;
}
function calculate7() {
  getValue7();
  sum =
    Number(a) +
    Number(b) +
    Number(c) +
    Number(d) +
    Number(e) +
    Number(f) +
    Number(g);
  sum7 = document.getElementById("result7").innerHTML = sum;
}

function getTotal(
  r1c1,
  r1c2,
  r1c3,
  r1c4,
  r1c5,
  r1c6,
  r1c7,
  r2c1,
  r2c2,
  r2c3,
  r2c4,
  r2c5,
  r2c6,
  r2c7,
  r3c1,
  r3c2,
  r3c3,
  r3c4,
  r3c5,
  r3c6,
  r3c7,
  r4c1,
  r4c2,
  r4c3,
  r4c4,
  r4c5,
  r4c6,
  r4c7,
  r5c1,
  r5c2,
  r5c3,
  r5c4,
  r5c5,
  r5c6,
  r5c7,
  r6c1,
  r6c2,
  r6c3,
  r6c4,
  r6c5,
  r6c6,
  r6c7,
  r7c1,
  r7c2,
  r7c3,
  r7c4,
  r7c5,
  r7c6,
  r7c7
) {
  a = document.getElementById("r1c1").value;
  b = document.getElementById("r1c2").value;
  c = document.getElementById("r1c3").value;
  d = document.getElementById("r1c4").value;
  e = document.getElementById("r1c5").value;
  f = document.getElementById("r1c6").value;
  g = document.getElementById("r1c7").value;

  h = document.getElementById("r2c1").value;
  i = document.getElementById("r2c2").value;
  j = document.getElementById("r2c3").value;
  k = document.getElementById("r2c4").value;
  l = document.getElementById("r2c5").value;
  m = document.getElementById("r2c6").value;
  n = document.getElementById("r2c7").value;
  o = document.getElementById("r3c1").value;
  p = document.getElementById("r3c2").value;
  q = document.getElementById("r3c3").value;
  r = document.getElementById("r3c4").value;
  s = document.getElementById("r3c5").value;
  t = document.getElementById("r3c6").value;
  u = document.getElementById("r3c7").value;
  v = document.getElementById("r4c1").value;
  w = document.getElementById("r4c2").value;
  x = document.getElementById("r4c3").value;
  y = document.getElementById("r4c4").value;
  z = document.getElementById("r4c5").value;
  z1 = document.getElementById("r4c6").value;
  z2 = document.getElementById("r4c7").value;
  z3 = document.getElementById("r5c1").value;
  z4 = document.getElementById("r5c2").value;
  z5 = document.getElementById("r5c3").value;
  z6 = document.getElementById("r5c4").value;
  z7 = document.getElementById("r5c5").value;
  z8 = document.getElementById("r5c6").value;
  z9 = document.getElementById("r5c7").value;
  z10 = document.getElementById("r6c1").value;
  z11 = document.getElementById("r6c2").value;
  z12 = document.getElementById("r6c3").value;
  z13 = document.getElementById("r6c4").value;
  z14 = document.getElementById("r6c5").value;
  z15 = document.getElementById("r6c6").value;
  z16 = document.getElementById("r6c7").value;
  z17 = document.getElementById("r7c1").value;
  z18 = document.getElementById("r7c2").value;
  z19 = document.getElementById("r7c3").value;
  z20 = document.getElementById("r7c4").value;
  z21 = document.getElementById("r7c5").value;
  z22 = document.getElementById("r7c6").value;
  z23 = document.getElementById("r7c7").value;
}
function calculateTotal() {
  getTotal();
  finalsum =
    Number(a) +
    Number(b) +
    Number(c) +
    Number(d) +
    Number(e) +
    Number(f) +
    Number(g) +
    Number(h) +
    Number(i) +
    Number(j) +
    Number(k) +
    Number(l) +
    Number(m) +
    Number(n) +
    Number(o) +
    Number(p) +
    Number(q) +
    Number(r) +
    Number(s) +
    Number(t) +
    Number(u) +
    Number(v) +
    Number(w) +
    Number(x) +
    Number(y) +
    Number(z) +
    Number(z1) +
    Number(z2) +
    Number(z3) +
    Number(z4) +
    Number(z5) +
    Number(z6) +
    Number(z7) +
    Number(z8) +
    Number(z9) +
    Number(z10) +
    Number(z11) +
    Number(z12) +
    Number(z13) +
    Number(z14) +
    Number(z15) +
    Number(z16) +
    Number(z17) +
    Number(z18) +
    Number(z19) +
    Number(z20) +
    Number(z21) +
    Number(z22) +
    Number(z23);
  document.getElementById("resultFinal").innerHTML = finalsum;
  co = document.getElementById("resultFinal").value = finalsum;
  alert("This weeks final sum is Rs. " + co);
}

function getTotal2(
  r1c1,
  r1c2,
  r1c3,
  r1c4,
  r1c5,
  r1c6,
  r1c7,
  r2c1,
  r2c2,
  r2c3,
  r2c4,
  r2c5,
  r2c6,
  r2c7,
  r3c1,
  r3c2,
  r3c3,
  r3c4,
  r3c5,
  r3c6,
  r3c7,
  r4c1,
  r4c2,
  r4c3,
  r4c4,
  r4c5,
  r4c6,
  r4c7,
  r5c1,
  r5c2,
  r5c3,
  r5c4,
  r5c5,
  r5c6,
  r5c7,
  r6c1,
  r6c2,
  r6c3,
  r6c4,
  r6c5,
  r6c6,
  r6c7,
  r7c1,
  r7c2,
  r7c3,
  r7c4,
  r7c5,
  r7c6,
  r7c7
) {
  a = document.getElementById("r1c1").value;
  b = document.getElementById("r1c2").value;
  c = document.getElementById("r1c3").value;
  d = document.getElementById("r1c4").value;
  e = document.getElementById("r1c5").value;
  f = document.getElementById("r1c6").value;
  g = document.getElementById("r1c7").value;

  h = document.getElementById("r2c1").value;
  i = document.getElementById("r2c2").value;
  j = document.getElementById("r2c3").value;
  k = document.getElementById("r2c4").value;
  l = document.getElementById("r2c5").value;
  m = document.getElementById("r2c6").value;
  n = document.getElementById("r2c7").value;
  o = document.getElementById("r3c1").value;
  p = document.getElementById("r3c2").value;
  q = document.getElementById("r3c3").value;
  r = document.getElementById("r3c4").value;
  s = document.getElementById("r3c5").value;
  t = document.getElementById("r3c6").value;
  u = document.getElementById("r3c7").value;
  v = document.getElementById("r4c1").value;
  w = document.getElementById("r4c2").value;
  x = document.getElementById("r4c3").value;
  y = document.getElementById("r4c4").value;
  z = document.getElementById("r4c5").value;
  z1 = document.getElementById("r4c6").value;
  z2 = document.getElementById("r4c7").value;
  z3 = document.getElementById("r5c1").value;
  z4 = document.getElementById("r5c2").value;
  z5 = document.getElementById("r5c3").value;
  z6 = document.getElementById("r5c4").value;
  z7 = document.getElementById("r5c5").value;
  z8 = document.getElementById("r5c6").value;
  z9 = document.getElementById("r5c7").value;
  z10 = document.getElementById("r6c1").value;
  z11 = document.getElementById("r6c2").value;
  z12 = document.getElementById("r6c3").value;
  z13 = document.getElementById("r6c4").value;
  z14 = document.getElementById("r6c5").value;
  z15 = document.getElementById("r6c6").value;
  z16 = document.getElementById("r6c7").value;
  z17 = document.getElementById("r7c1").value;
  z18 = document.getElementById("r7c2").value;
  z19 = document.getElementById("r7c3").value;
  z20 = document.getElementById("r7c4").value;
  z21 = document.getElementById("r7c5").value;
  z22 = document.getElementById("r7c6").value;
  z23 = document.getElementById("r7c7").value;
}
function calculateTotal2() {
  getTotal2();
  finalsum =
    Number(a) +
    Number(b) +
    Number(c) +
    Number(d) +
    Number(e) +
    Number(f) +
    Number(g) +
    Number(h) +
    Number(i) +
    Number(j) +
    Number(k) +
    Number(l) +
    Number(m) +
    Number(n) +
    Number(o) +
    Number(p) +
    Number(q) +
    Number(r) +
    Number(s) +
    Number(t) +
    Number(u) +
    Number(v) +
    Number(w) +
    Number(x) +
    Number(y) +
    Number(z) +
    Number(z1) +
    Number(z2) +
    Number(z3) +
    Number(z4) +
    Number(z5) +
    Number(z6) +
    Number(z7) +
    Number(z8) +
    Number(z9) +
    Number(z10) +
    Number(z11) +
    Number(z12) +
    Number(z13) +
    Number(z14) +
    Number(z15) +
    Number(z16) +
    Number(z17) +
    Number(z18) +
    Number(z19) +
    Number(z20) +
    Number(z21) +
    Number(z22) +
    Number(z23);
  document.getElementById("resultFinal2").innerHTML = finalsum;
  co = document.getElementById("resultFinal2").value = finalsum;
  alert("This weeks final sum is Rs. " + co);
}

function getTotal3(
  r1c1,
  r1c2,
  r1c3,
  r1c4,
  r1c5,
  r1c6,
  r1c7,
  r2c1,
  r2c2,
  r2c3,
  r2c4,
  r2c5,
  r2c6,
  r2c7,
  r3c1,
  r3c2,
  r3c3,
  r3c4,
  r3c5,
  r3c6,
  r3c7,
  r4c1,
  r4c2,
  r4c3,
  r4c4,
  r4c5,
  r4c6,
  r4c7,
  r5c1,
  r5c2,
  r5c3,
  r5c4,
  r5c5,
  r5c6,
  r5c7,
  r6c1,
  r6c2,
  r6c3,
  r6c4,
  r6c5,
  r6c6,
  r6c7,
  r7c1,
  r7c2,
  r7c3,
  r7c4,
  r7c5,
  r7c6,
  r7c7
) {
  a = document.getElementById("r1c1").value;
  b = document.getElementById("r1c2").value;
  c = document.getElementById("r1c3").value;
  d = document.getElementById("r1c4").value;
  e = document.getElementById("r1c5").value;
  f = document.getElementById("r1c6").value;
  g = document.getElementById("r1c7").value;

  h = document.getElementById("r2c1").value;
  i = document.getElementById("r2c2").value;
  j = document.getElementById("r2c3").value;
  k = document.getElementById("r2c4").value;
  l = document.getElementById("r2c5").value;
  m = document.getElementById("r2c6").value;
  n = document.getElementById("r2c7").value;
  o = document.getElementById("r3c1").value;
  p = document.getElementById("r3c2").value;
  q = document.getElementById("r3c3").value;
  r = document.getElementById("r3c4").value;
  s = document.getElementById("r3c5").value;
  t = document.getElementById("r3c6").value;
  u = document.getElementById("r3c7").value;
  v = document.getElementById("r4c1").value;
  w = document.getElementById("r4c2").value;
  x = document.getElementById("r4c3").value;
  y = document.getElementById("r4c4").value;
  z = document.getElementById("r4c5").value;
  z1 = document.getElementById("r4c6").value;
  z2 = document.getElementById("r4c7").value;
  z3 = document.getElementById("r5c1").value;
  z4 = document.getElementById("r5c2").value;
  z5 = document.getElementById("r5c3").value;
  z6 = document.getElementById("r5c4").value;
  z7 = document.getElementById("r5c5").value;
  z8 = document.getElementById("r5c6").value;
  z9 = document.getElementById("r5c7").value;
  z10 = document.getElementById("r6c1").value;
  z11 = document.getElementById("r6c2").value;
  z12 = document.getElementById("r6c3").value;
  z13 = document.getElementById("r6c4").value;
  z14 = document.getElementById("r6c5").value;
  z15 = document.getElementById("r6c6").value;
  z16 = document.getElementById("r6c7").value;
  z17 = document.getElementById("r7c1").value;
  z18 = document.getElementById("r7c2").value;
  z19 = document.getElementById("r7c3").value;
  z20 = document.getElementById("r7c4").value;
  z21 = document.getElementById("r7c5").value;
  z22 = document.getElementById("r7c6").value;
  z23 = document.getElementById("r7c7").value;
}
function calculateTotal3() {
  getTotal3();
  finalsum =
    Number(a) +
    Number(b) +
    Number(c) +
    Number(d) +
    Number(e) +
    Number(f) +
    Number(g) +
    Number(h) +
    Number(i) +
    Number(j) +
    Number(k) +
    Number(l) +
    Number(m) +
    Number(n) +
    Number(o) +
    Number(p) +
    Number(q) +
    Number(r) +
    Number(s) +
    Number(t) +
    Number(u) +
    Number(v) +
    Number(w) +
    Number(x) +
    Number(y) +
    Number(z) +
    Number(z1) +
    Number(z2) +
    Number(z3) +
    Number(z4) +
    Number(z5) +
    Number(z6) +
    Number(z7) +
    Number(z8) +
    Number(z9) +
    Number(z10) +
    Number(z11) +
    Number(z12) +
    Number(z13) +
    Number(z14) +
    Number(z15) +
    Number(z16) +
    Number(z17) +
    Number(z18) +
    Number(z19) +
    Number(z20) +
    Number(z21) +
    Number(z22) +
    Number(z23);
  document.getElementById("resultFinal3").innerHTML = finalsum;
  co = document.getElementById("resultFinal3").value = finalsum;
  alert("This weeks final sum is Rs. " + co);
}

function getTotal4(
  r1c1,
  r1c2,
  r1c3,
  r1c4,
  r1c5,
  r1c6,
  r1c7,
  r2c1,
  r2c2,
  r2c3,
  r2c4,
  r2c5,
  r2c6,
  r2c7,
  r3c1,
  r3c2,
  r3c3,
  r3c4,
  r3c5,
  r3c6,
  r3c7,
  r4c1,
  r4c2,
  r4c3,
  r4c4,
  r4c5,
  r4c6,
  r4c7,
  r5c1,
  r5c2,
  r5c3,
  r5c4,
  r5c5,
  r5c6,
  r5c7,
  r6c1,
  r6c2,
  r6c3,
  r6c4,
  r6c5,
  r6c6,
  r6c7,
  r7c1,
  r7c2,
  r7c3,
  r7c4,
  r7c5,
  r7c6,
  r7c7
) {
  a = document.getElementById("r1c1").value;
  b = document.getElementById("r1c2").value;
  c = document.getElementById("r1c3").value;
  d = document.getElementById("r1c4").value;
  e = document.getElementById("r1c5").value;
  f = document.getElementById("r1c6").value;
  g = document.getElementById("r1c7").value;

  h = document.getElementById("r2c1").value;
  i = document.getElementById("r2c2").value;
  j = document.getElementById("r2c3").value;
  k = document.getElementById("r2c4").value;
  l = document.getElementById("r2c5").value;
  m = document.getElementById("r2c6").value;
  n = document.getElementById("r2c7").value;
  o = document.getElementById("r3c1").value;
  p = document.getElementById("r3c2").value;
  q = document.getElementById("r3c3").value;
  r = document.getElementById("r3c4").value;
  s = document.getElementById("r3c5").value;
  t = document.getElementById("r3c6").value;
  u = document.getElementById("r3c7").value;
  v = document.getElementById("r4c1").value;
  w = document.getElementById("r4c2").value;
  x = document.getElementById("r4c3").value;
  y = document.getElementById("r4c4").value;
  z = document.getElementById("r4c5").value;
  z1 = document.getElementById("r4c6").value;
  z2 = document.getElementById("r4c7").value;
  z3 = document.getElementById("r5c1").value;
  z4 = document.getElementById("r5c2").value;
  z5 = document.getElementById("r5c3").value;
  z6 = document.getElementById("r5c4").value;
  z7 = document.getElementById("r5c5").value;
  z8 = document.getElementById("r5c6").value;
  z9 = document.getElementById("r5c7").value;
  z10 = document.getElementById("r6c1").value;
  z11 = document.getElementById("r6c2").value;
  z12 = document.getElementById("r6c3").value;
  z13 = document.getElementById("r6c4").value;
  z14 = document.getElementById("r6c5").value;
  z15 = document.getElementById("r6c6").value;
  z16 = document.getElementById("r6c7").value;
  z17 = document.getElementById("r7c1").value;
  z18 = document.getElementById("r7c2").value;
  z19 = document.getElementById("r7c3").value;
  z20 = document.getElementById("r7c4").value;
  z21 = document.getElementById("r7c5").value;
  z22 = document.getElementById("r7c6").value;
  z23 = document.getElementById("r7c7").value;
}
function calculateTotal4() {
  getTotal4();
  finalsum =
    Number(a) +
    Number(b) +
    Number(c) +
    Number(d) +
    Number(e) +
    Number(f) +
    Number(g) +
    Number(h) +
    Number(i) +
    Number(j) +
    Number(k) +
    Number(l) +
    Number(m) +
    Number(n) +
    Number(o) +
    Number(p) +
    Number(q) +
    Number(r) +
    Number(s) +
    Number(t) +
    Number(u) +
    Number(v) +
    Number(w) +
    Number(x) +
    Number(y) +
    Number(z) +
    Number(z1) +
    Number(z2) +
    Number(z3) +
    Number(z4) +
    Number(z5) +
    Number(z6) +
    Number(z7) +
    Number(z8) +
    Number(z9) +
    Number(z10) +
    Number(z11) +
    Number(z12) +
    Number(z13) +
    Number(z14) +
    Number(z15) +
    Number(z16) +
    Number(z17) +
    Number(z18) +
    Number(z19) +
    Number(z20) +
    Number(z21) +
    Number(z22) +
    Number(z23);
  document.getElementById("resultFinal4").innerHTML = finalsum;
  co = document.getElementById("resultFinal4").value = finalsum;
  alert("This weeks final sum is Rs. " + co);
}

function getTotalM(resultFinal, resultFinal2, resultFinal3, resultFinal4) {
  a = document.getElementById("resultFinal").value;
  b = document.getElementById("resultFinal2").value;
  c = document.getElementById("resultFinal3").value;
  d = document.getElementById("resultFinal4").value;
}
function calculateTotalM() {
  getTotalM();
  finalsum = Number(a) + Number(b) + Number(c) + Number(d);
  document.getElementById("resultFinalM").innerHTML = finalsum;
  co = document.getElementById("resultFinalM").value = finalsum;
  alert("This Months final sum is Rs. " + co);
}

function getTotalSavings(resultFinalSalary, resultFinalM) {
  a = document.getElementById("resultFinalSalary").value;
  b = document.getElementById("resultFinalM").value;
}
function calculateTotalSavings() {
  getTotalSavings();
  finalsum = Number(a) - Number(b);
  document.getElementById("resultFinalSavings").innerHTML = finalsum;
  co = document.getElementById("resultFinalSavings").value = finalsum;
  alert("This Months final savings is Rs. " + co);
}