{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Summary","SP1","SP2","SP3","SP4","SP5","SP6","SP7","SP8","SP9","SP10"],"not_rendered":{"charts":0,"images":31,"macros":1,"external_links":0,"defined_names":11,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":87,"n_cols":10,"rows_kept":87,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,"Test Secondary College"]
[null,null,null,null,null,"Tracked Balances Summary Report"]
[]
[null,null,null,null,null,2014]
[]
[null,null,null,"Opening Balance",null,"Revenue",null,"Expenditure",null,"Balance"]
[]
[null,{"$f":"IF('SP1'!$D$4<>\"\",'SP1'!$D$4,\"\")","v":""},null,{"$f":"IF('SP1'!$D$4<>\"\",'SP1'!$D$34,\"\")","v":""},null,{"$f":"IF('SP1'!$D$4<>\"\",'SP1'!$F$34,\"\")","v":""},null,{"$f":"IF('SP1'!$D$4<>\"\",'SP1'!$H$34,\"\")","v":""},null,{"$f":"IF('SP1'!$D$4<>\"\",'SP1'!$J$34,\"\")","v":""}]
[]
[null,{"$f":"IF('SP2'!$D$4<>\"\",'SP2'!$D$4,\"\")","v":""},null,{"$f":"IF('SP2'!$D$4<>\"\",'SP2'!$D$34,\"\")","v":""},null,{"$f":"IF('SP2'!$D$4<>\"\",'SP2'!$F$34,\"\")","v":""},null,{"$f":"IF('SP2'!$D$4<>\"\",'SP2'!$H$34,\"\")","v":""},null,{"$f":"IF('SP2'!$D$4<>\"\",'SP2'!$J$34,\"\")","v":""}]
[]
[null,{"$f":"IF('SP3'!$D$4<>\"\",'SP3'!$D$4,\"\")","v":""},null,{"$f":"IF('SP3'!$D$4<>\"\",'SP3'!$D$34,\"\")","v":""},null,{"$f":"IF('SP3'!$D$4<>\"\",'SP3'!$F$34,\"\")","v":""},null,{"$f":"IF('SP3'!$D$4<>\"\",'SP3'!$H$34,\"\")","v":""},null,{"$f":"IF('SP3'!$D$4<>\"\",'SP3'!$J$34,\"\")","v":""}]
[]
[null,{"$f":"IF('SP4'!$D$4<>\"\",'SP4'!$D$4,\"\")","v":""},null,{"$f":"IF('SP4'!$D$4<>\"\",'SP4'!$D$34,\"\")","v":""},null,{"$f":"IF('SP4'!$D$4<>\"\",'SP4'!$F$34,\"\")","v":""},null,{"$f":"IF('SP4'!$D$4<>\"\",'SP4'!$H$34,\"\")","v":""},null,{"$f":"IF('SP4'!$D$4<>\"\",'SP4'!$J$34,\"\")","v":""}]
[]
[null,{"$f":"IF('SP5'!$D$4<>\"\",'SP5'!$D$4,\"\")","v":""},null,{"$f":"IF('SP5'!$D$4<>\"\",'SP5'!$D$34,\"\")","v":""},null,{"$f":"IF('SP5'!$D$4<>\"\",'SP5'!$F$34,\"\")","v":""},null,{"$f":"IF('SP5'!$D$4<>\"\",'SP5'!$H$34,\"\")","v":""},null,{"$f":"IF('SP5'!$D$4<>\"\",'SP5'!$J$34,\"\")","v":""}]
[]
[null,{"$f":"IF('SP6'!$D$4<>\"\",'SP6'!$D$4,\"\")","v":""},null,{"$f":"IF('SP6'!$D$4<>\"\",'SP6'!$D$34,\"\")","v":""},null,{"$f":"IF('SP6'!$D$4<>\"\",'SP6'!$F$34,\"\")","v":""},null,{"$f":"IF('SP6'!$D$4<>\"\",'SP6'!$H$34,\"\")","v":""},null,{"$f":"IF('SP6'!$D$4<>\"\",'SP6'!$J$34,\"\")","v":""}]
[]
[null,{"$f":"IF('SP7'!$D$4<>\"\",'SP7'!$D$4,\"\")","v":""},null,{"$f":"IF('SP7'!$D$4<>\"\",'SP7'!$D$34,\"\")","v":""},null,{"$f":"IF('SP7'!$D$4<>\"\",'SP7'!$F$34,\"\")","v":""},null,{"$f":"IF('SP7'!$D$4<>\"\",'SP7'!$H$34,\"\")","v":""},null,{"$f":"IF('SP7'!$D$4<>\"\",'SP7'!$J$34,\"\")","v":""}]
[]
[null,{"$f":"IF('SP8'!$D$4<>\"\",'SP8'!$D$4,\"\")","v":""},null,{"$f":"IF('SP8'!$D$4<>\"\",'SP8'!$D$34,\"\")","v":""},null,{"$f":"IF('SP8'!$D$4<>\"\",'SP8'!$F$34,\"\")","v":""},null,{"$f":"IF('SP8'!$D$4<>\"\",'SP8'!$H$34,\"\")","v":""},null,{"$f":"IF('SP8'!$D$4<>\"\",'SP8'!$J$34,\"\")","v":""}]
[]
[null,{"$f":"IF('SP9'!$D$4<>\"\",'SP9'!$D$4,\"\")","v":""},null,{"$f":"IF('SP9'!$D$4<>\"\",'SP9'!$D$34,\"\")","v":""},null,{"$f":"IF('SP9'!$D$4<>\"\",'SP9'!$F$34,\"\")","v":""},null,{"$f":"IF('SP9'!$D$4<>\"\",'SP9'!$H$34,\"\")","v":""},null,{"$f":"IF('SP9'!$D$4<>\"\",'SP9'!$J$34,\"\")","v":""}]
[]
[null,{"$f":"IF('SP10'!$D$4<>\"\",'SP10'!$D$4,\"\")","v":""},null,{"$f":"IF('SP10'!$D$4<>\"\",'SP10'!$D$34,\"\")","v":""},null,{"$f":"IF('SP10'!$D$4<>\"\",'SP10'!$F$34,\"\")","v":""},null,{"$f":"IF('SP10'!$D$4<>\"\",'SP10'!$H$34,\"\")","v":""},null,{"$f":"IF('SP10'!$D$4<>\"\",'SP10'!$J$34,\"\")","v":""}]
[]
[]
[null,"Totals",null,{"$f":"SUM(D9:D28)","v":0},null,{"$f":"SUM(F9:F28)","v":0},null,{"$f":"SUM(H9:H28)","v":0},null,{"$f":"SUM(J9:J28)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"F2","v":"Test Secondary College"}]
[null,null,null,null,null,"Tracked Balances Summary Report"]
[]
[null,null,null,null,null,{"$f":"F5","v":2014}]
[]
[null,null,null,"Opening Balance",null,"Revenue",null,"Expenditure",null,"Balance"]
[]
[null,{"$f":"B9","v":""},null,{"$f":"D9","v":""},null,{"$f":"F9","v":""},null,{"$f":"H9","v":""},null,{"$f":"J9","v":""}]
[]
[null,{"$f":"B11","v":""},null,{"$f":"D11","v":""},null,{"$f":"F11","v":""},null,{"$f":"H11","v":""},null,{"$f":"J11","v":""}]
[]
[null,{"$f":"B13","v":""},null,{"$f":"D13","v":""},null,{"$f":"F13","v":""},null,{"$f":"H13","v":""},null,{"$f":"J13","v":""}]
[]
[null,{"$f":"B15","v":""},null,{"$f":"D15","v":""},null,{"$f":"F15","v":""},null,{"$f":"H15","v":""},null,{"$f":"J15","v":""}]
[]
[null,{"$f":"B17","v":""},null,{"$f":"D17","v":""},null,{"$f":"F17","v":""},null,{"$f":"H17","v":""},null,{"$f":"J17","v":""}]
[]
[null,{"$f":"B19","v":""},null,{"$f":"D19","v":""},null,{"$f":"F19","v":""},null,{"$f":"H19","v":""},null,{"$f":"J19","v":""}]
[]
[null,{"$f":"B21","v":""},null,{"$f":"D21","v":""},null,{"$f":"F21","v":""},null,{"$f":"H21","v":""},null,{"$f":"J21","v":""}]
[]
[null,{"$f":"B23","v":""},null,{"$f":"D23","v":""},null,{"$f":"F23","v":""},null,{"$f":"H23","v":""},null,{"$f":"J23","v":""}]
[]
[null,{"$f":"B25","v":""},null,{"$f":"D25","v":""},null,{"$f":"F25","v":""},null,{"$f":"H25","v":""},null,{"$f":"J25","v":""}]
[]
[null,{"$f":"B27","v":""},null,{"$f":"D27","v":""},null,{"$f":"F27","v":""},null,{"$f":"H27","v":""},null,{"$f":"J27","v":""}]
[]
[]
[null,"Totals",null,{"$f":"SUM(D64:D83)","v":0},null,{"$f":"SUM(F64:F83)","v":0},null,{"$f":"SUM(H64:H83)","v":0},null,{"$f":"SUM(J64:J83)","v":0}]
[]
[null,"Signed:",null,null,null,null,null,"Date:",null,{"$f":"TODAY()","v":"2020-08-09"}]

{"sheet":"SP1","index":1,"n_rows":104,"n_cols":13,"rows_kept":104,"cut":false,"hidden":false,"merged":[[3,3,3,5]]}
[null,null,null,null,null,{"$f":"Summary!F2","v":"Test Secondary College"}]
[null,null,null,null,null,"Tracked Balances Report"]
[]
[null,"Subprogram",null,null,null,null,null,"Year",null,{"$f":"Summary!F5","v":2014}]
[]
[null,"Opening Bal",null,null,null,"Starting Month"]
[]
[null,null,null,"Opening Balance",null,"Revenue",null,"Expenditure",null,"Balance"]
[]
[null,"January",null,{"$f":"IF($H$6=B10,$D$6,\"\")","v":""},null,null,null,null,null,{"$f":"IF(AND(F10<>\"\",H10<>\"\"),D10+F10-H10,\"\")","v":""}]
[]
[null,"February",null,{"$f":"IF($H$6=B12,$D$6,IF(J10=\"\",\"\",J10))","v":""},null,null,null,null,null,{"$f":"IF(AND(F12<>\"\",H12<>\"\"),D12+F12-H12,\"\")","v":""}]
[]
[null,"March",null,{"$f":"IF($H$6=B14,$D$6,IF(J12=\"\",\"\",J12))","v":""},null,null,null,null,null,{"$f":"IF(AND(F14<>\"\",H14<>\"\"),D14+F14-H14,\"\")","v":""}]
[]
[null,"April",null,{"$f":"IF($H$6=B16,$D$6,IF(J14=\"\",\"\",J14))","v":""},null,null,null,null,null,{"$f":"IF(AND(F16<>\"\",H16<>\"\"),D16+F16-H16,\"\")","v":""}]
[]
[null,"May",null,{"$f":"IF($H$6=B18,$D$6,IF(J16=\"\",\"\",J16))","v":""},null,null,null,null,null,{"$f":"IF(AND(F18<>\"\",H18<>\"\"),D18+F18-H18,\"\")","v":""}]
[]
[null,"June",null,{"$f":"IF($H$6=B20,$D$6,IF(J18=\"\",\"\",J18))","v":""},null,null,null,null,null,{"$f":"IF(AND(F20<>\"\",H20<>\"\"),D20+F20-H20,\"\")","v":""}]
[]
[null,"July",null,{"$f":"IF($H$6=B22,$D$6,IF(J20=\"\",\"\",J20))","v":""},null,null,null,null,null,{"$f":"IF(AND(F22<>\"\",H22<>\"\"),D22+F22-H22,\"\")","v":""}]
[]
[null,"August",null,{"$f":"IF($H$6=B24,$D$6,IF(J22=\"\",\"\",J22))","v":""},null,null,null,null,null,{"$f":"IF(AND(F24<>\"\",H24<>\"\"),D24+F24-H24,\"\")","v":""}]
[]
[null,"September",null,{"$f":"IF($H$6=B26,$D$6,IF(J24=\"\",\"\",J24))","v":""},null,null,null,null,null,{"$f":"IF(AND(F26<>\"\",H26<>\"\"),D26+F26-H26,\"\")","v":""}]
[]
[null,"October",null,{"$f":"IF($H$6=B28,$D$6,IF(J26=\"\",\"\",J26))","v":""},null,null,null,null,null,{"$f":"IF(AND(F28<>\"\",H28<>\"\"),D28+F28-H28,\"\")","v":""}]
[]
[null,"November",null,{"$f":"IF($H$6=B30,$D$6,IF(J28=\"\",\"\",J28))","v":""},null,null,null,null,null,{"$f":"IF(AND(F30<>\"\",H30<>\"\"),D30+F30-H30,\"\")","v":""}]
[]
[null,"December",null,{"$f":"IF($H$6=B32,$D$6,IF(J30=\"\",\"\",J30))","v":""},null,null,null,null,null,{"$f":"IF(AND(F32<>\"\",H32<>\"\"),D32+F32-H32,\"\")","v":""}]
[]
[null,"Year to Date",null,{"$f":"D6","v":0},null,{"$f":"SUM(F10:F32)","v":0},null,{"$f":"SUM(H10:H32)","v":0},null,{"$f":"D34+F34-H34","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"January"]
[null,null,null,null,null,null,null,null,null,null,null,null,"February"]
[null,null,null,null,null,null,null,null,null,null,null,null,"March"]
[null,null,null,null,null,null,null,null,null,null,null,null,"April"]
[null,null,null,null,null,null,null,null,null,null,null,null,"May"]
[null,null,null,null,null,null,null,null,null,null,null,null,"June"]
[null,null,null,null,null,null,null,null,null,null,null,null,"July"]
[null,null,null,null,null,null,null,null,null,null,null,null,"August"]
[null,null,null,null,null,null,null,null,null,null,null,null,"September"]
[null,null,null,null,null,null,null,null,null,null,null,null,"October"]
[null,null,null,"Printed Report ",null,null,null,null,null,null,null,null,"November"]
[null,null,null,null,null,null,null,null,null,null,null,null,"December"]
[null,null,null,null,null,{"$f":"F1","v":"Test Secondary College"}]
[null,null,null,null,null,"Tracked Balances Report"]
[]
[null,"Subprogram",null,{"$f":"D4","v":0},null,null,null,"Year",null,{"$f":"J4","v":2014}]
[]
[null,"Opening Bal",null,{"$f":"D6","v":0},null,"Starting Month",null,{"$f":"H6","v":0}]
[]
[null,null,null,"Opening Balance",null,"Revenue",null,"Expenditure",null,"Balance"]
[]
[null,"January",null,{"$f":"D10","v":""},null,{"$f":"IF(F10<>\"\",F10,\"\")","v":""},null,{"$f":"IF(H10<>\"\",H10,\"\")","v":""},null,{"$f":"J10","v":""}]
[]
[null,"February",null,{"$f":"D12","v":""},null,{"$f":"IF(F12<>\"\",F12,\"\")","v":""},null,{"$f":"IF(H12<>\"\",H12,\"\")","v":""},null,{"$f":"J12","v":""}]
[]
[null,"March",null,{"$f":"D14","v":""},null,{"$f":"IF(F14<>\"\",F14,\"\")","v":""},null,{"$f":"IF(H14<>\"\",H14,\"\")","v":""},null,{"$f":"J14","v":""}]
[]
[null,"April",null,{"$f":"D16","v":""},null,{"$f":"IF(F16<>\"\",F16,\"\")","v":""},null,{"$f":"IF(H16<>\"\",H16,\"\")","v":""},null,{"$f":"J16","v":""}]
[]
[null,"May",null,{"$f":"D18","v":""},null,{"$f":"IF(F18<>\"\",F18,\"\")","v":""},null,{"$f":"IF(H18<>\"\",H18,\"\")","v":""},null,{"$f":"J18","v":""}]
[]
[null,"June",null,{"$f":"D20","v":""},null,{"$f":"IF(F20<>\"\",F20,\"\")","v":""},null,{"$f":"IF(H20<>\"\",H20,\"\")","v":""},null,{"$f":"J20","v":""}]
[]
[null,"July",null,{"$f":"D22","v":""},null,{"$f":"IF(F22<>\"\",F22,\"\")","v":""},null,{"$f":"IF(H22<>\"\",H22,\"\")","v":""},null,{"$f":"J22","v":""}]
[]
[null,"August",null,{"$f":"D24","v":""},null,{"$f":"IF(F24<>\"\",F24,\"\")","v":""},null,{"$f":"IF(H24<>\"\",H24,\"\")","v":""},null,{"$f":"J24","v":""}]
[]
[null,"September",null,{"$f":"D26","v":""},null,{"$f":"IF(F26<>\"\",F26,\"\")","v":""},null,{"$f":"IF(H26<>\"\",H26,\"\")","v":""},null,{"$f":"J26","v":""}]
[]
[null,"October",null,{"$f":"D28","v":""},null,{"$f":"IF(F28<>\"\",F28,\"\")","v":""},null,{"$f":"IF(H28<>\"\",H28,\"\")","v":""},null,{"$f":"J28","v":""}]
[]
[null,"November",null,{"$f":"D30","v":""},null,{"$f":"IF(F30<>\"\",F30,\"\")","v":""},null,{"$f":"IF(H30<>\"\",H30,\"\")","v":""},null,{"$f":"J30","v":""}]
[]
[null,"December",null,{"$f":"D32","v":""},null,{"$f":"IF(F32<>\"\",F32,\"\")","v":""},null,{"$f":"IF(H32<>\"\",H32,\"\")","v":""},null,{"$f":"J32","v":""}]
[]
[null,"Year to Date",null,{"$f":"D34","v":0},null,{"$f":"F34","v":0},null,{"$f":"H34","v":0},null,{"$f":"J34","v":0}]
[]
[]
[null,"Signed:",null,null,null,null,null,"Date:",null,{"$f":"TODAY()","v":"2020-08-09"}]

{"sheet":"SP2","index":2,"n_rows":104,"n_cols":13,"rows_kept":104,"cut":false,"hidden":false,"merged":[[3,3,3,5]]}
[null,null,null,null,null,{"$f":"Summary!F2","v":"Test Secondary College"}]
[null,null,null,null,null,"Tracked Balances Report"]
[]
[null,"Subprogram",null,null,null,null,null,"Year",null,{"$f":"Summary!F5","v":2014}]
[]
[null,"Opening Bal",null,null,null,"Starting Month"]
[]
[null,null,null,"Opening Balance",null,"Revenue",null,"Expenditure",null,"Balance"]
[]
[null,"January",null,{"$f":"IF($H$6=B10,$D$6,\"\")","v":""},null,null,null,null,null,{"$f":"IF(AND(F10<>\"\",H10<>\"\"),D10+F10-H10,\"\")","v":""}]
[]
[null,"February",null,{"$f":"IF($H$6=B12,$D$6,IF(J10=\"\",\"\",J10))","v":""},null,null,null,null,null,{"$f":"IF(AND(F12<>\"\",H12<>\"\"),D12+F12-H12,\"\")","v":""}]
[]
[null,"March",null,{"$f":"IF($H$6=B14,$D$6,IF(J12=\"\",\"\",J12))","v":""},null,null,null,null,null,{"$f":"IF(AND(F14<>\"\",H14<>\"\"),D14+F14-H14,\"\")","v":""}]
[]
[null,"April",null,{"$f":"IF($H$6=B16,$D$6,IF(J14=\"\",\"\",J14))","v":""},null,null,null,null,null,{"$f":"IF(AND(F16<>\"\",H16<>\"\"),D16+F16-H16,\"\")","v":""}]
[]
[null,"May",null,{"$f":"IF($H$6=B18,$D$6,IF(J16=\"\",\"\",J16))","v":""},null,null,null,null,null,{"$f":"IF(AND(F18<>\"\",H18<>\"\"),D18+F18-H18,\"\")","v":""}]
[]
[null,"June",null,{"$f":"IF($H$6=B20,$D$6,IF(J18=\"\",\"\",J18))","v":""},null,null,null,null,null,{"$f":"IF(AND(F20<>\"\",H20<>\"\"),D20+F20-H20,\"\")","v":""}]
[]
[null,"July",null,{"$f":"IF($H$6=B22,$D$6,IF(J20=\"\",\"\",J20))","v":""},null,null,null,null,null,{"$f":"IF(AND(F22<>\"\",H22<>\"\"),D22+F22-H22,\"\")","v":""}]
[]
[null,"August",null,{"$f":"IF($H$6=B24,$D$6,IF(J22=\"\",\"\",J22))","v":""},null,null,null,null,null,{"$f":"IF(AND(F24<>\"\",H24<>\"\"),D24+F24-H24,\"\")","v":""}]
[]
[null,"September",null,{"$f":"IF($H$6=B26,$D$6,IF(J24=\"\",\"\",J24))","v":""},null,null,null,null,null,{"$f":"IF(AND(F26<>\"\",H26<>\"\"),D26+F26-H26,\"\")","v":""}]
[]
[null,"October",null,{"$f":"IF($H$6=B28,$D$6,IF(J26=\"\",\"\",J26))","v":""},null,null,null,null,null,{"$f":"IF(AND(F28<>\"\",H28<>\"\"),D28+F28-H28,\"\")","v":""}]
[]
[null,"November",null,{"$f":"IF($H$6=B30,$D$6,IF(J28=\"\",\"\",J28))","v":""},null,null,null,null,null,{"$f":"IF(AND(F30<>\"\",H30<>\"\"),D30+F30-H30,\"\")","v":""}]
[]
[null,"December",null,{"$f":"IF($H$6=B32,$D$6,IF(J30=\"\",\"\",J30))","v":""},null,null,null,null,null,{"$f":"IF(AND(F32<>\"\",H32<>\"\"),D32+F32-H32,\"\")","v":""}]
[]
[null,"Year to Date",null,{"$f":"D6","v":0},null,{"$f":"SUM(F10:F32)","v":0},null,{"$f":"SUM(H10:H32)","v":0},null,{"$f":"D34+F34-H34","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"January"]
[null,null,null,null,null,null,null,null,null,null,null,null,"February"]
[null,null,null,null,null,null,null,null,null,null,null,null,"March"]
[null,null,null,null,null,null,null,null,null,null,null,null,"April"]
[null,null,null,null,null,null,null,null,null,null,null,null,"May"]
[null,null,null,null,null,null,null,null,null,null,null,null,"June"]
[null,null,null,null,null,null,null,null,null,null,null,null,"July"]
[null,null,null,null,null,null,null,null,null,null,null,null,"August"]
[null,null,null,null,null,null,null,null,null,null,null,null,"September"]
[null,null,null,null,null,null,null,null,null,null,null,null,"October"]
[null,null,null,"Printed Report ",null,null,null,null,null,null,null,null,"November"]
[null,null,null,null,null,null,null,null,null,null,null,null,"December"]
[null,null,null,null,null,{"$f":"F1","v":"Test Secondary College"}]
[null,null,null,null,null,"Tracked Balances Report"]
[]
[null,"Subprogram",null,{"$f":"D4","v":0},null,null,null,"Year",null,{"$f":"J4","v":2014}]
[]
[null,"Opening Bal",null,{"$f":"D6","v":0},null,"Starting Month",null,{"$f":"H6","v":0}]
[]
[null,null,null,"Opening Balance",null,"Revenue",null,"Expenditure",null,"Balance"]
[]
[null,"January",null,{"$f":"D10","v":""},null,{"$f":"IF(F10<>\"\",F10,\"\")","v":""},null,{"$f":"IF(H10<>\"\",H10,\"\")","v":""},null,{"$f":"J10","v":""}]
[]
[null,"February",null,{"$f":"D12","v":""},null,{"$f":"IF(F12<>\"\",F12,\"\")","v":""},null,{"$f":"IF(H12<>\"\",H12,\"\")","v":""},null,{"$f":"J12","v":""}]
[]
[null,"March",null,{"$f":"D14","v":""},null,{"$f":"IF(F14<>\"\",F14,\"\")","v":""},null,{"$f":"IF(H14<>\"\",H14,\"\")","v":""},null,{"$f":"J14","v":""}]
[]
[null,"April",null,{"$f":"D16","v":""},null,{"$f":"IF(F16<>\"\",F16,\"\")","v":""},null,{"$f":"IF(H16<>\"\",H16,\"\")","v":""},null,{"$f":"J16","v":""}]
[]
[null,"May",null,{"$f":"D18","v":""},null,{"$f":"IF(F18<>\"\",F18,\"\")","v":""},null,{"$f":"IF(H18<>\"\",H18,\"\")","v":""},null,{"$f":"J18","v":""}]
[]
[null,"June",null,{"$f":"D20","v":""},null,{"$f":"IF(F20<>\"\",F20,\"\")","v":""},null,{"$f":"IF(H20<>\"\",H20,\"\")","v":""},null,{"$f":"J20","v":""}]
[]
[null,"July",null,{"$f":"D22","v":""},null,{"$f":"IF(F22<>\"\",F22,\"\")","v":""},null,{"$f":"IF(H22<>\"\",H22,\"\")","v":""},null,{"$f":"J22","v":""}]
[]
[null,"August",null,{"$f":"D24","v":""},null,{"$f":"IF(F24<>\"\",F24,\"\")","v":""},null,{"$f":"IF(H24<>\"\",H24,\"\")","v":""},null,{"$f":"J24","v":""}]
[]
[null,"September",null,{"$f":"D26","v":""},null,{"$f":"IF(F26<>\"\",F26,\"\")","v":""},null,{"$f":"IF(H26<>\"\",H26,\"\")","v":""},null,{"$f":"J26","v":""}]
[]
[null,"October",null,{"$f":"D28","v":""},null,{"$f":"IF(F28<>\"\",F28,\"\")","v":""},null,{"$f":"IF(H28<>\"\",H28,\"\")","v":""},null,{"$f":"J28","v":""}]
[]
[null,"November",null,{"$f":"D30","v":""},null,{"$f":"IF(F30<>\"\",F30,\"\")","v":""},null,{"$f":"IF(H30<>\"\",H30,\"\")","v":""},null,{"$f":"J30","v":""}]
[]
[null,"December",null,{"$f":"D32","v":""},null,{"$f":"IF(F32<>\"\",F32,\"\")","v":""},null,{"$f":"IF(H32<>\"\",H32,\"\")","v":""},null,{"$f":"J32","v":""}]
[]
[null,"Year to Date",null,{"$f":"D34","v":0},null,{"$f":"F34","v":0},null,{"$f":"H34","v":0},null,{"$f":"J34","v":0}]
[]
[]
[null,"Signed:",null,null,null,null,null,"Date:",null,{"$f":"TODAY()","v":"2020-08-09"}]

{"sheet":"SP3","index":3,"n_rows":104,"n_cols":13,"rows_kept":104,"cut":false,"hidden":false,"merged":[[3,3,3,5]]}
[null,null,null,null,null,{"$f":"Summary!F2","v":"Test Secondary College"}]
[null,null,null,null,null,"Tracked Balances Report"]
[]
[null,"Subprogram",null,null,null,null,null,"Year",null,{"$f":"Summary!F5","v":2014}]
[]
[null,"Opening Bal",null,null,null,"Starting Month"]
[]
[null,null,null,"Opening Balance",null,"Revenue",null,"Expenditure",null,"Balance"]
[]
[null,"January",null,{"$f":"IF($H$6=B10,$D$6,\"\")","v":""},null,null,null,null,null,{"$f":"IF(AND(F10<>\"\",H10<>\"\"),D10+F10-H10,\"\")","v":""}]
[]
[null,"February",null,{"$f":"IF($H$6=B12,$D$6,IF(J10=\"\",\"\",J10))","v":""},null,null,null,null,null,{"$f":"IF(AND(F12<>\"\",H12<>\"\"),D12+F12-H12,\"\")","v":""}]
[]
[null,"March",null,{"$f":"IF($H$6=B14,$D$6,IF(J12=\"\",\"\",J12))","v":""},null,null,null,null,null,{"$f":"IF(AND(F14<>\"\",H14<>\"\"),D14+F14-H14,\"\")","v":""}]
[]
[null,"April",null,{"$f":"IF($H$6=B16,$D$6,IF(J14=\"\",\"\",J14))","v":""},null,null,null,null,null,{"$f":"IF(AND(F16<>\"\",H16<>\"\"),D16+F16-H16,\"\")","v":""}]
[]
[null,"May",null,{"$f":"IF($H$6=B18,$D$6,IF(J16=\"\",\"\",J16))","v":""},null,null,null,null,null,{"$f":"IF(AND(F18<>\"\",H18<>\"\"),D18+F18-H18,\"\")","v":""}]
[]
[null,"June",null,{"$f":"IF($H$6=B20,$D$6,IF(J18=\"\",\"\",J18))","v":""},null,null,null,null,null,{"$f":"IF(AND(F20<>\"\",H20<>\"\"),D20+F20-H20,\"\")","v":""}]
[]
[null,"July",null,{"$f":"IF($H$6=B22,$D$6,IF(J20=\"\",\"\",J20))","v":""},null,null,null,null,null,{"$f":"IF(AND(F22<>\"\",H22<>\"\"),D22+F22-H22,\"\")","v":""}]
[]
[null,"August",null,{"$f":"IF($H$6=B24,$D$6,IF(J22=\"\",\"\",J22))","v":""},null,null,null,null,null,{"$f":"IF(AND(F24<>\"\",H24<>\"\"),D24+F24-H24,\"\")","v":""}]
[]
[null,"September",null,{"$f":"IF($H$6=B26,$D$6,IF(J24=\"\",\"\",J24))","v":""},null,null,null,null,null,{"$f":"IF(AND(F26<>\"\",H26<>\"\"),D26+F26-H26,\"\")","v":""}]
[]
[null,"October",null,{"$f":"IF($H$6=B28,$D$6,IF(J26=\"\",\"\",J26))","v":""},null,null,null,null,null,{"$f":"IF(AND(F28<>\"\",H28<>\"\"),D28+F28-H28,\"\")","v":""}]
[]
[null,"November",null,{"$f":"IF($H$6=B30,$D$6,IF(J28=\"\",\"\",J28))","v":""},null,null,null,null,null,{"$f":"IF(AND(F30<>\"\",H30<>\"\"),D30+F30-H30,\"\")","v":""}]
[]
[null,"December",null,{"$f":"IF($H$6=B32,$D$6,IF(J30=\"\",\"\",J30))","v":""},null,null,null,null,null,{"$f":"IF(AND(F32<>\"\",H32<>\"\"),D32+F32-H32,\"\")","v":""}]
[]
[null,"Year to Date",null,{"$f":"D6","v":0},null,{"$f":"SUM(F10:F32)","v":0},null,{"$f":"SUM(H10:H32)","v":0},null,{"$f":"D34+F34-H34","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"January"]
[null,null,null,null,null,null,null,null,null,null,null,null,"February"]
[null,null,null,null,null,null,null,null,null,null,null,null,"March"]
[null,null,null,null,null,null,null,null,null,null,null,null,"April"]
[null,null,null,null,null,null,null,null,null,null,null,null,"May"]
[null,null,null,null,null,null,null,null,null,null,null,null,"June"]
[null,null,null,null,null,null,null,null,null,null,null,null,"July"]
[null,null,null,null,null,null,null,null,null,null,null,null,"August"]
[null,null,null,null,null,null,null,null,null,null,null,null,"September"]
[null,null,null,null,null,null,null,null,null,null,null,null,"October"]
[null,null,null,"Printed Report ",null,null,null,null,null,null,null,null,"November"]
[null,null,null,null,null,null,null,null,null,null,null,null,"December"]
[null,null,null,null,null,{"$f":"F1","v":"Test Secondary College"}]
[null,null,null,null,null,"Tracked Balances Report"]
[]
[null,"Subprogram",null,{"$f":"D4","v":0},null,null,null,"Year",null,{"$f":"J4","v":2014}]
[]
[null,"Opening Bal",null,{"$f":"D6","v":0},null,"Starting Month",null,{"$f":"H6","v":0}]
[]
[null,null,null,"Opening Balance",null,"Revenue",null,"Expenditure",null,"Balance"]
[]
[null,"January",null,{"$f":"D10","v":""},null,{"$f":"IF(F10<>\"\",F10,\"\")","v":""},null,{"$f":"IF(H10<>\"\",H10,\"\")","v":""},null,{"$f":"J10","v":""}]
[]
[null,"February",null,{"$f":"D12","v":""},null,{"$f":"IF(F12<>\"\",F12,\"\")","v":""},null,{"$f":"IF(H12<>\"\",H12,\"\")","v":""},null,{"$f":"J12","v":""}]
[]
[null,"March",null,{"$f":"D14","v":""},null,{"$f":"IF(F14<>\"\",F14,\"\")","v":""},null,{"$f":"IF(H14<>\"\",H14,\"\")","v":""},null,{"$f":"J14","v":""}]
[]
[null,"April",null,{"$f":"D16","v":""},null,{"$f":"IF(F16<>\"\",F16,\"\")","v":""},null,{"$f":"IF(H16<>\"\",H16,\"\")","v":""},null,{"$f":"J16","v":""}]
[]
[null,"May",null,{"$f":"D18","v":""},null,{"$f":"IF(F18<>\"\",F18,\"\")","v":""},null,{"$f":"IF(H18<>\"\",H18,\"\")","v":""},null,{"$f":"J18","v":""}]
[]
[null,"June",null,{"$f":"D20","v":""},null,{"$f":"IF(F20<>\"\",F20,\"\")","v":""},null,{"$f":"IF(H20<>\"\",H20,\"\")","v":""},null,{"$f":"J20","v":""}]
[]
[null,"July",null,{"$f":"D22","v":""},null,{"$f":"IF(F22<>\"\",F22,\"\")","v":""},null,{"$f":"IF(H22<>\"\",H22,\"\")","v":""},null,{"$f":"J22","v":""}]
[]
[null,"August",null,{"$f":"D24","v":""},null,{"$f":"IF(F24<>\"\",F24,\"\")","v":""},null,{"$f":"IF(H24<>\"\",H24,\"\")","v":""},null,{"$f":"J24","v":""}]
[]
[null,"September",null,{"$f":"D26","v":""},null,{"$f":"IF(F26<>\"\",F26,\"\")","v":""},null,{"$f":"IF(H26<>\"\",H26,\"\")","v":""},null,{"$f":"J26","v":""}]
[]
[null,"October",null,{"$f":"D28","v":""},null,{"$f":"IF(F28<>\"\",F28,\"\")","v":""},null,{"$f":"IF(H28<>\"\",H28,\"\")","v":""},null,{"$f":"J28","v":""}]
[]
[null,"November",null,{"$f":"D30","v":""},null,{"$f":"IF(F30<>\"\",F30,\"\")","v":""},null,{"$f":"IF(H30<>\"\",H30,\"\")","v":""},null,{"$f":"J30","v":""}]
[]
[null,"December",null,{"$f":"D32","v":""},null,{"$f":"IF(F32<>\"\",F32,\"\")","v":""},null,{"$f":"IF(H32<>\"\",H32,\"\")","v":""},null,{"$f":"J32","v":""}]
[]
[null,"Year to Date",null,{"$f":"D34","v":0},null,{"$f":"F34","v":0},null,{"$f":"H34","v":0},null,{"$f":"J34","v":0}]
[]
[]
[null,"Signed:",null,null,null,null,null,"Date:",null,{"$f":"TODAY()","v":"2020-08-09"}]

{"sheet":"SP4","index":4,"n_rows":104,"n_cols":13,"rows_kept":104,"cut":false,"hidden":false,"merged":[[3,3,3,5]]}
[null,null,null,null,null,{"$f":"Summary!F2","v":"Test Secondary College"}]
[null,null,null,null,null,"Tracked Balances Report"]
[]
[null,"Subprogram",null,null,null,null,null,"Year",null,{"$f":"Summary!F5","v":2014}]
[]
[null,"Opening Bal",null,null,null,"Starting Month"]
[]
[null,null,null,"Opening Balance",null,"Revenue",null,"Expenditure",null,"Balance"]
[]
[null,"January",null,{"$f":"IF($H$6=B10,$D$6,\"\")","v":""},null,null,null,null,null,{"$f":"IF(AND(F10<>\"\",H10<>\"\"),D10+F10-H10,\"\")","v":""}]
[]
[null,"February",null,{"$f":"IF($H$6=B12,$D$6,IF(J10=\"\",\"\",J10))","v":""},null,null,null,null,null,{"$f":"IF(AND(F12<>\"\",H12<>\"\"),D12+F12-H12,\"\")","v":""}]
[]
[null,"March",null,{"$f":"IF($H$6=B14,$D$6,IF(J12=\"\",\"\",J12))","v":""},null,null,null,null,null,{"$f":"IF(AND(F14<>\"\",H14<>\"\"),D14+F14-H14,\"\")","v":""}]
[]
[null,"April",null,{"$f":"IF($H$6=B16,$D$6,IF(J14=\"\",\"\",J14))","v":""},null,null,null,null,null,{"$f":"IF(AND(F16<>\"\",H16<>\"\"),D16+F16-H16,\"\")","v":""}]
[]
[null,"May",null,{"$f":"IF($H$6=B18,$D$6,IF(J16=\"\",\"\",J16))","v":""},null,null,null,null,null,{"$f":"IF(AND(F18<>\"\",H18<>\"\"),D18+F18-H18,\"\")","v":""}]
[]
[null,"June",null,{"$f":"IF($H$6=B20,$D$6,IF(J18=\"\",\"\",J18))","v":""},null,null,null,null,null,{"$f":"IF(AND(F20<>\"\",H20<>\"\"),D20+F20-H20,\"\")","v":""}]
[]
[null,"July",null,{"$f":"IF($H$6=B22,$D$6,IF(J20=\"\",\"\",J20))","v":""},null,null,null,null,null,{"$f":"IF(AND(F22<>\"\",H22<>\"\"),D22+F22-H22,\"\")","v":""}]
[]
[null,"August",null,{"$f":"IF($H$6=B24,$D$6,IF(J22=\"\",\"\",J22))","v":""},null,null,null,null,null,{"$f":"IF(AND(F24<>\"\",H24<>\"\"),D24+F24-H24,\"\")","v":""}]
[]
[null,"September",null,{"$f":"IF($H$6=B26,$D$6,IF(J24=\"\",\"\",J24))","v":""},null,null,null,null,null,{"$f":"IF(AND(F26<>\"\",H26<>\"\"),D26+F26-H26,\"\")","v":""}]
[]
[null,"October",null,{"$f":"IF($H$6=B28,$D$6,IF(J26=\"\",\"\",J26))","v":""},null,null,null,null,null,{"$f":"IF(AND(F28<>\"\",H28<>\"\"),D28+F28-H28,\"\")","v":""}]
[]
[null,"November",null,{"$f":"IF($H$6=B30,$D$6,IF(J28=\"\",\"\",J28))","v":""},null,null,null,null,null,{"$f":"IF(AND(F30<>\"\",H30<>\"\"),D30+F30-H30,\"\")","v":""}]
[]
[null,"December",null,{"$f":"IF($H$6=B32,$D$6,IF(J30=\"\",\"\",J30))","v":""},null,null,null,null,null,{"$f":"IF(AND(F32<>\"\",H32<>\"\"),D32+F32-H32,\"\")","v":""}]
[]
[null,"Year to Date",null,{"$f":"D6","v":0},null,{"$f":"SUM(F10:F32)","v":0},null,{"$f":"SUM(H10:H32)","v":0},null,{"$f":"D34+F34-H34","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"January"]
[null,null,null,null,null,null,null,null,null,null,null,null,"February"]
[null,null,null,null,null,null,null,null,null,null,null,null,"March"]
[null,null,null,null,null,null,null,null,null,null,null,null,"April"]
[null,null,null,null,null,null,null,null,null,null,null,null,"May"]
[null,null,null,null,null,null,null,null,null,null,null,null,"June"]
[null,null,null,null,null,null,null,null,null,null,null,null,"July"]
[null,null,null,null,null,null,null,null,null,null,null,null,"August"]
[null,null,null,null,null,null,null,null,null,null,null,null,"September"]
[null,null,null,null,null,null,null,null,null,null,null,null,"October"]
[null,null,null,"Printed Report ",null,null,null,null,null,null,null,null,"November"]
[null,null,null,null,null,null,null,null,null,null,null,null,"December"]
[null,null,null,null,null,{"$f":"F1","v":"Test Secondary College"}]
[null,null,null,null,null,"Tracked Balances Report"]
[]
[null,"Subprogram",null,{"$f":"D4","v":0},null,null,null,"Year",null,{"$f":"J4","v":2014}]
[]
[null,"Opening Bal",null,{"$f":"D6","v":0},null,"Starting Month",null,{"$f":"H6","v":0}]
[]
[null,null,null,"Opening Balance",null,"Revenue",null,"Expenditure",null,"Balance"]
[]
[null,"January",null,{"$f":"D10","v":""},null,{"$f":"IF(F10<>\"\",F10,\"\")","v":""},null,{"$f":"IF(H10<>\"\",H10,\"\")","v":""},null,{"$f":"J10","v":""}]
[]
[null,"February",null,{"$f":"D12","v":""},null,{"$f":"IF(F12<>\"\",F12,\"\")","v":""},null,{"$f":"IF(H12<>\"\",H12,\"\")","v":""},null,{"$f":"J12","v":""}]
[]
[null,"March",null,{"$f":"D14","v":""},null,{"$f":"IF(F14<>\"\",F14,\"\")","v":""},null,{"$f":"IF(H14<>\"\",H14,\"\")","v":""},null,{"$f":"J14","v":""}]
[]
[null,"April",null,{"$f":"D16","v":""},null,{"$f":"IF(F16<>\"\",F16,\"\")","v":""},null,{"$f":"IF(H16<>\"\",H16,\"\")","v":""},null,{"$f":"J16","v":""}]
[]
[null,"May",null,{"$f":"D18","v":""},null,{"$f":"IF(F18<>\"\",F18,\"\")","v":""},null,{"$f":"IF(H18<>\"\",H18,\"\")","v":""},null,{"$f":"J18","v":""}]
[]
[null,"June",null,{"$f":"D20","v":""},null,{"$f":"IF(F20<>\"\",F20,\"\")","v":""},null,{"$f":"IF(H20<>\"\",H20,\"\")","v":""},null,{"$f":"J20","v":""}]
[]
[null,"July",null,{"$f":"D22","v":""},null,{"$f":"IF(F22<>\"\",F22,\"\")","v":""},null,{"$f":"IF(H22<>\"\",H22,\"\")","v":""},null,{"$f":"J22","v":""}]
[]
[null,"August",null,{"$f":"D24","v":""},null,{"$f":"IF(F24<>\"\",F24,\"\")","v":""},null,{"$f":"IF(H24<>\"\",H24,\"\")","v":""},null,{"$f":"J24","v":""}]
[]
[null,"September",null,{"$f":"D26","v":""},null,{"$f":"IF(F26<>\"\",F26,\"\")","v":""},null,{"$f":"IF(H26<>\"\",H26,\"\")","v":""},null,{"$f":"J26","v":""}]
[]
[null,"October",null,{"$f":"D28","v":""},null,{"$f":"IF(F28<>\"\",F28,\"\")","v":""},null,{"$f":"IF(H28<>\"\",H28,\"\")","v":""},null,{"$f":"J28","v":""}]
[]
[null,"November",null,{"$f":"D30","v":""},null,{"$f":"IF(F30<>\"\",F30,\"\")","v":""},null,{"$f":"IF(H30<>\"\",H30,\"\")","v":""},null,{"$f":"J30","v":""}]
[]
[null,"December",null,{"$f":"D32","v":""},null,{"$f":"IF(F32<>\"\",F32,\"\")","v":""},null,{"$f":"IF(H32<>\"\",H32,\"\")","v":""},null,{"$f":"J32","v":""}]
[]
[null,"Year to Date",null,{"$f":"D34","v":0},null,{"$f":"F34","v":0},null,{"$f":"H34","v":0},null,{"$f":"J34","v":0}]
[]
[]
[null,"Signed:",null,null,null,null,null,"Date:",null,{"$f":"TODAY()","v":"2020-08-09"}]

{"sheet":"SP5","index":5,"n_rows":104,"n_cols":13,"rows_kept":104,"cut":false,"hidden":false,"merged":[[3,3,3,5]]}
[null,null,null,null,null,{"$f":"Summary!F2","v":"Test Secondary College"}]
[null,null,null,null,null,"Tracked Balances Report"]
[]
[null,"Subprogram",null,null,null,null,null,"Year",null,{"$f":"Summary!F5","v":2014}]
[]
[null,"Opening Bal",null,null,null,"Starting Month"]
[]
[null,null,null,"Opening Balance",null,"Revenue",null,"Expenditure",null,"Balance"]
[]
[null,"January",null,{"$f":"IF($H$6=B10,$D$6,\"\")","v":""},null,null,null,null,null,{"$f":"IF(AND(F10<>\"\",H10<>\"\"),D10+F10-H10,\"\")","v":""}]
[]
[null,"February",null,{"$f":"IF($H$6=B12,$D$6,IF(J10=\"\",\"\",J10))","v":""},null,null,null,null,null,{"$f":"IF(AND(F12<>\"\",H12<>\"\"),D12+F12-H12,\"\")","v":""}]
[]
[null,"March",null,{"$f":"IF($H$6=B14,$D$6,IF(J12=\"\",\"\",J12))","v":""},null,null,null,null,null,{"$f":"IF(AND(F14<>\"\",H14<>\"\"),D14+F14-H14,\"\")","v":""}]
[]
[null,"April",null,{"$f":"IF($H$6=B16,$D$6,IF(J14=\"\",\"\",J14))","v":""},null,null,null,null,null,{"$f":"IF(AND(F16<>\"\",H16<>\"\"),D16+F16-H16,\"\")","v":""}]
[]
[null,"May",null,{"$f":"IF($H$6=B18,$D$6,IF(J16=\"\",\"\",J16))","v":""},null,null,null,null,null,{"$f":"IF(AND(F18<>\"\",H18<>\"\"),D18+F18-H18,\"\")","v":""}]
[]
[null,"June",null,{"$f":"IF($H$6=B20,$D$6,IF(J18=\"\",\"\",J18))","v":""},null,null,null,null,null,{"$f":"IF(AND(F20<>\"\",H20<>\"\"),D20+F20-H20,\"\")","v":""}]
[]
[null,"July",null,{"$f":"IF($H$6=B22,$D$6,IF(J20=\"\",\"\",J20))","v":""},null,null,null,null,null,{"$f":"IF(AND(F22<>\"\",H22<>\"\"),D22+F22-H22,\"\")","v":""}]
[]
[null,"August",null,{"$f":"IF($H$6=B24,$D$6,IF(J22=\"\",\"\",J22))","v":""},null,null,null,null,null,{"$f":"IF(AND(F24<>\"\",H24<>\"\"),D24+F24-H24,\"\")","v":""}]
[]
[null,"September",null,{"$f":"IF($H$6=B26,$D$6,IF(J24=\"\",\"\",J24))","v":""},null,null,null,null,null,{"$f":"IF(AND(F26<>\"\",H26<>\"\"),D26+F26-H26,\"\")","v":""}]
[]
[null,"October",null,{"$f":"IF($H$6=B28,$D$6,IF(J26=\"\",\"\",J26))","v":""},null,null,null,null,null,{"$f":"IF(AND(F28<>\"\",H28<>\"\"),D28+F28-H28,\"\")","v":""}]
[]
[null,"November",null,{"$f":"IF($H$6=B30,$D$6,IF(J28=\"\",\"\",J28))","v":""},null,null,null,null,null,{"$f":"IF(AND(F30<>\"\",H30<>\"\"),D30+F30-H30,\"\")","v":""}]
[]
[null,"December",null,{"$f":"IF($H$6=B32,$D$6,IF(J30=\"\",\"\",J30))","v":""},null,null,null,null,null,{"$f":"IF(AND(F32<>\"\",H32<>\"\"),D32+F32-H32,\"\")","v":""}]
[]
[null,"Year to Date",null,{"$f":"D6","v":0},null,{"$f":"SUM(F10:F32)","v":0},null,{"$f":"SUM(H10:H32)","v":0},null,{"$f":"D34+F34-H34","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"January"]
[null,null,null,null,null,null,null,null,null,null,null,null,"February"]
[null,null,null,null,null,null,null,null,null,null,null,null,"March"]
[null,null,null,null,null,null,null,null,null,null,null,null,"April"]
[null,null,null,null,null,null,null,null,null,null,null,null,"May"]
[null,null,null,null,null,null,null,null,null,null,null,null,"June"]
[null,null,null,null,null,null,null,null,null,null,null,null,"July"]
[null,null,null,null,null,null,null,null,null,null,null,null,"August"]
[null,null,null,null,null,null,null,null,null,null,null,null,"September"]
[null,null,null,null,null,null,null,null,null,null,null,null,"October"]
[null,null,null,"Printed Report ",null,null,null,null,null,null,null,null,"November"]
[null,null,null,null,null,null,null,null,null,null,null,null,"December"]
[null,null,null,null,null,{"$f":"F1","v":"Test Secondary College"}]
[null,null,null,null,null,"Tracked Balances Report"]
[]
[null,"Subprogram",null,{"$f":"D4","v":0},null,null,null,"Year",null,{"$f":"J4","v":2014}]
[]
[null,"Opening Bal",null,{"$f":"D6","v":0},null,"Starting Month",null,{"$f":"H6","v":0}]
[]
[null,null,null,"Opening Balance",null,"Revenue",null,"Expenditure",null,"Balance"]
[]
[null,"January",null,{"$f":"D10","v":""},null,{"$f":"IF(F10<>\"\",F10,\"\")","v":""},null,{"$f":"IF(H10<>\"\",H10,\"\")","v":""},null,{"$f":"J10","v":""}]
[]
[null,"February",null,{"$f":"D12","v":""},null,{"$f":"IF(F12<>\"\",F12,\"\")","v":""},null,{"$f":"IF(H12<>\"\",H12,\"\")","v":""},null,{"$f":"J12","v":""}]
[]
[null,"March",null,{"$f":"D14","v":""},null,{"$f":"IF(F14<>\"\",F14,\"\")","v":""},null,{"$f":"IF(H14<>\"\",H14,\"\")","v":""},null,{"$f":"J14","v":""}]
[]
[null,"April",null,{"$f":"D16","v":""},null,{"$f":"IF(F16<>\"\",F16,\"\")","v":""},null,{"$f":"IF(H16<>\"\",H16,\"\")","v":""},null,{"$f":"J16","v":""}]
[]
[null,"May",null,{"$f":"D18","v":""},null,{"$f":"IF(F18<>\"\",F18,\"\")","v":""},null,{"$f":"IF(H18<>\"\",H18,\"\")","v":""},null,{"$f":"J18","v":""}]
[]
[null,"June",null,{"$f":"D20","v":""},null,{"$f":"IF(F20<>\"\",F20,\"\")","v":""},null,{"$f":"IF(H20<>\"\",H20,\"\")","v":""},null,{"$f":"J20","v":""}]
[]
[null,"July",null,{"$f":"D22","v":""},null,{"$f":"IF(F22<>\"\",F22,\"\")","v":""},null,{"$f":"IF(H22<>\"\",H22,\"\")","v":""},null,{"$f":"J22","v":""}]
[]
[null,"August",null,{"$f":"D24","v":""},null,{"$f":"IF(F24<>\"\",F24,\"\")","v":""},null,{"$f":"IF(H24<>\"\",H24,\"\")","v":""},null,{"$f":"J24","v":""}]
[]
[null,"September",null,{"$f":"D26","v":""},null,{"$f":"IF(F26<>\"\",F26,\"\")","v":""},null,{"$f":"IF(H26<>\"\",H26,\"\")","v":""},null,{"$f":"J26","v":""}]
[]
[null,"October",null,{"$f":"D28","v":""},null,{"$f":"IF(F28<>\"\",F28,\"\")","v":""},null,{"$f":"IF(H28<>\"\",H28,\"\")","v":""},null,{"$f":"J28","v":""}]
[]
[null,"November",null,{"$f":"D30","v":""},null,{"$f":"IF(F30<>\"\",F30,\"\")","v":""},null,{"$f":"IF(H30<>\"\",H30,\"\")","v":""},null,{"$f":"J30","v":""}]
[]
[null,"December",null,{"$f":"D32","v":""},null,{"$f":"IF(F32<>\"\",F32,\"\")","v":""},null,{"$f":"IF(H32<>\"\",H32,\"\")","v":""},null,{"$f":"J32","v":""}]
[]
[null,"Year to Date",null,{"$f":"D34","v":0},null,{"$f":"F34","v":0},null,{"$f":"H34","v":0},null,{"$f":"J34","v":0}]
[]
[]
[null,"Signed:",null,null,null,null,null,"Date:",null,{"$f":"TODAY()","v":"2020-08-09"}]

{"sheet":"SP6","index":6,"n_rows":104,"n_cols":13,"rows_kept":104,"cut":false,"hidden":false,"merged":[[3,3,3,5]]}
[null,null,null,null,null,{"$f":"Summary!F2","v":"Test Secondary College"}]
[null,null,null,null,null,"Tracked Balances Report"]
[]
[null,"Subprogram",null,null,null,null,null,"Year",null,{"$f":"Summary!F5","v":2014}]
[]
[null,"Opening Bal",null,null,null,"Starting Month"]
[]
[null,null,null,"Opening Balance",null,"Revenue",null,"Expenditure",null,"Balance"]
[]
[null,"January",null,{"$f":"IF($H$6=B10,$D$6,\"\")","v":""},null,null,null,null,null,{"$f":"IF(AND(F10<>\"\",H10<>\"\"),D10+F10-H10,\"\")","v":""}]
[]
[null,"February",null,{"$f":"IF($H$6=B12,$D$6,IF(J10=\"\",\"\",J10))","v":""},null,null,null,null,null,{"$f":"IF(AND(F12<>\"\",H12<>\"\"),D12+F12-H12,\"\")","v":""}]
[]
[null,"March",null,{"$f":"IF($H$6=B14,$D$6,IF(J12=\"\",\"\",J12))","v":""},null,null,null,null,null,{"$f":"IF(AND(F14<>\"\",H14<>\"\"),D14+F14-H14,\"\")","v":""}]
[]
[null,"April",null,{"$f":"IF($H$6=B16,$D$6,IF(J14=\"\",\"\",J14))","v":""},null,null,null,null,null,{"$f":"IF(AND(F16<>\"\",H16<>\"\"),D16+F16-H16,\"\")","v":""}]
[]
[null,"May",null,{"$f":"IF($H$6=B18,$D$6,IF(J16=\"\",\"\",J16))","v":""},null,null,null,null,null,{"$f":"IF(AND(F18<>\"\",H18<>\"\"),D18+F18-H18,\"\")","v":""}]
[]
[null,"June",null,{"$f":"IF($H$6=B20,$D$6,IF(J18=\"\",\"\",J18))","v":""},null,null,null,null,null,{"$f":"IF(AND(F20<>\"\",H20<>\"\"),D20+F20-H20,\"\")","v":""}]
[]
[null,"July",null,{"$f":"IF($H$6=B22,$D$6,IF(J20=\"\",\"\",J20))","v":""},null,null,null,null,null,{"$f":"IF(AND(F22<>\"\",H22<>\"\"),D22+F22-H22,\"\")","v":""}]
[]
[null,"August",null,{"$f":"IF($H$6=B24,$D$6,IF(J22=\"\",\"\",J22))","v":""},null,null,null,null,null,{"$f":"IF(AND(F24<>\"\",H24<>\"\"),D24+F24-H24,\"\")","v":""}]
[]
[null,"September",null,{"$f":"IF($H$6=B26,$D$6,IF(J24=\"\",\"\",J24))","v":""},null,null,null,null,null,{"$f":"IF(AND(F26<>\"\",H26<>\"\"),D26+F26-H26,\"\")","v":""}]
[]
[null,"October",null,{"$f":"IF($H$6=B28,$D$6,IF(J26=\"\",\"\",J26))","v":""},null,null,null,null,null,{"$f":"IF(AND(F28<>\"\",H28<>\"\"),D28+F28-H28,\"\")","v":""}]
[]
[null,"November",null,{"$f":"IF($H$6=B30,$D$6,IF(J28=\"\",\"\",J28))","v":""},null,null,null,null,null,{"$f":"IF(AND(F30<>\"\",H30<>\"\"),D30+F30-H30,\"\")","v":""}]
[]
[null,"December",null,{"$f":"IF($H$6=B32,$D$6,IF(J30=\"\",\"\",J30))","v":""},null,null,null,null,null,{"$f":"IF(AND(F32<>\"\",H32<>\"\"),D32+F32-H32,\"\")","v":""}]
[]
[null,"Year to Date",null,{"$f":"D6","v":0},null,{"$f":"SUM(F10:F32)","v":0},null,{"$f":"SUM(H10:H32)","v":0},null,{"$f":"D34+F34-H34","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"January"]
[null,null,null,null,null,null,null,null,null,null,null,null,"February"]
[null,null,null,null,null,null,null,null,null,null,null,null,"March"]
[null,null,null,null,null,null,null,null,null,null,null,null,"April"]
[null,null,null,null,null,null,null,null,null,null,null,null,"May"]
[null,null,null,null,null,null,null,null,null,null,null,null,"June"]
[null,null,null,null,null,null,null,null,null,null,null,null,"July"]
[null,null,null,null,null,null,null,null,null,null,null,null,"August"]
[null,null,null,null,null,null,null,null,null,null,null,null,"September"]
[null,null,null,null,null,null,null,null,null,null,null,null,"October"]
[null,null,null,"Printed Report ",null,null,null,null,null,null,null,null,"November"]
[null,null,null,null,null,null,null,null,null,null,null,null,"December"]
[null,null,null,null,null,{"$f":"F1","v":"Test Secondary College"}]
[null,null,null,null,null,"Tracked Balances Report"]
[]
[null,"Subprogram",null,{"$f":"D4","v":0},null,null,null,"Year",null,{"$f":"J4","v":2014}]
[]
[null,"Opening Bal",null,{"$f":"D6","v":0},null,"Starting Month",null,{"$f":"H6","v":0}]
[]
[null,null,null,"Opening Balance",null,"Revenue",null,"Expenditure",null,"Balance"]
[]
[null,"January",null,{"$f":"D10","v":""},null,{"$f":"IF(F10<>\"\",F10,\"\")","v":""},null,{"$f":"IF(H10<>\"\",H10,\"\")","v":""},null,{"$f":"J10","v":""}]
[]
[null,"February",null,{"$f":"D12","v":""},null,{"$f":"IF(F12<>\"\",F12,\"\")","v":""},null,{"$f":"IF(H12<>\"\",H12,\"\")","v":""},null,{"$f":"J12","v":""}]
[]
[null,"March",null,{"$f":"D14","v":""},null,{"$f":"IF(F14<>\"\",F14,\"\")","v":""},null,{"$f":"IF(H14<>\"\",H14,\"\")","v":""},null,{"$f":"J14","v":""}]
[]
[null,"April",null,{"$f":"D16","v":""},null,{"$f":"IF(F16<>\"\",F16,\"\")","v":""},null,{"$f":"IF(H16<>\"\",H16,\"\")","v":""},null,{"$f":"J16","v":""}]
[]
[null,"May",null,{"$f":"D18","v":""},null,{"$f":"IF(F18<>\"\",F18,\"\")","v":""},null,{"$f":"IF(H18<>\"\",H18,\"\")","v":""},null,{"$f":"J18","v":""}]
[]
[null,"June",null,{"$f":"D20","v":""},null,{"$f":"IF(F20<>\"\",F20,\"\")","v":""},null,{"$f":"IF(H20<>\"\",H20,\"\")","v":""},null,{"$f":"J20","v":""}]
[]
[null,"July",null,{"$f":"D22","v":""},null,{"$f":"IF(F22<>\"\",F22,\"\")","v":""},null,{"$f":"IF(H22<>\"\",H22,\"\")","v":""},null,{"$f":"J22","v":""}]
[]
[null,"August",null,{"$f":"D24","v":""},null,{"$f":"IF(F24<>\"\",F24,\"\")","v":""},null,{"$f":"IF(H24<>\"\",H24,\"\")","v":""},null,{"$f":"J24","v":""}]
[]
[null,"September",null,{"$f":"D26","v":""},null,{"$f":"IF(F26<>\"\",F26,\"\")","v":""},null,{"$f":"IF(H26<>\"\",H26,\"\")","v":""},null,{"$f":"J26","v":""}]
[]
[null,"October",null,{"$f":"D28","v":""},null,{"$f":"IF(F28<>\"\",F28,\"\")","v":""},null,{"$f":"IF(H28<>\"\",H28,\"\")","v":""},null,{"$f":"J28","v":""}]
[]
[null,"November",null,{"$f":"D30","v":""},null,{"$f":"IF(F30<>\"\",F30,\"\")","v":""},null,{"$f":"IF(H30<>\"\",H30,\"\")","v":""},null,{"$f":"J30","v":""}]
[]
[null,"December",null,{"$f":"D32","v":""},null,{"$f":"IF(F32<>\"\",F32,\"\")","v":""},null,{"$f":"IF(H32<>\"\",H32,\"\")","v":""},null,{"$f":"J32","v":""}]
[]
[null,"Year to Date",null,{"$f":"D34","v":0},null,{"$f":"F34","v":0},null,{"$f":"H34","v":0},null,{"$f":"J34","v":0}]
[]
[]
[null,"Signed:",null,null,null,null,null,"Date:",null,{"$f":"TODAY()","v":"2020-08-09"}]

{"sheet":"SP7","index":7,"n_rows":104,"n_cols":13,"rows_kept":104,"cut":false,"hidden":false,"merged":[[3,3,3,5]]}
[null,null,null,null,null,{"$f":"Summary!F2","v":"Test Secondary College"}]
[null,null,null,null,null,"Tracked Balances Report"]
[]
[null,"Subprogram",null,null,null,null,null,"Year",null,{"$f":"Summary!F5","v":2014}]
[]
[null,"Opening Bal",null,null,null,"Starting Month",null,"January"]
[]
[null,null,null,"Opening Balance",null,"Revenue",null,"Expenditure",null,"Balance"]
[]
[null,"January",null,{"$f":"IF($H$6=B10,$D$6,\"\")","v":0},null,null,null,null,null,{"$f":"IF(AND(F10<>\"\",H10<>\"\"),D10+F10-H10,\"\")","v":""}]
[]
[null,"February",null,{"$f":"IF($H$6=B12,$D$6,IF(J10=\"\",\"\",J10))","v":""},null,null,null,null,null,{"$f":"IF(AND(F12<>\"\",H12<>\"\"),D12+F12-H12,\"\")","v":""}]
[]
[null,"March",null,{"$f":"IF($H$6=B14,$D$6,IF(J12=\"\",\"\",J12))","v":""},null,null,null,null,null,{"$f":"IF(AND(F14<>\"\",H14<>\"\"),D14+F14-H14,\"\")","v":""}]
[]
[null,"April",null,{"$f":"IF($H$6=B16,$D$6,IF(J14=\"\",\"\",J14))","v":""},null,null,null,null,null,{"$f":"IF(AND(F16<>\"\",H16<>\"\"),D16+F16-H16,\"\")","v":""}]
[]
[null,"May",null,{"$f":"IF($H$6=B18,$D$6,IF(J16=\"\",\"\",J16))","v":""},null,null,null,null,null,{"$f":"IF(AND(F18<>\"\",H18<>\"\"),D18+F18-H18,\"\")","v":""}]
[]
[null,"June",null,{"$f":"IF($H$6=B20,$D$6,IF(J18=\"\",\"\",J18))","v":""},null,null,null,null,null,{"$f":"IF(AND(F20<>\"\",H20<>\"\"),D20+F20-H20,\"\")","v":""}]
[]
[null,"July",null,{"$f":"IF($H$6=B22,$D$6,IF(J20=\"\",\"\",J20))","v":""},null,null,null,null,null,{"$f":"IF(AND(F22<>\"\",H22<>\"\"),D22+F22-H22,\"\")","v":""}]
[]
[null,"August",null,{"$f":"IF($H$6=B24,$D$6,IF(J22=\"\",\"\",J22))","v":""},null,null,null,null,null,{"$f":"IF(AND(F24<>\"\",H24<>\"\"),D24+F24-H24,\"\")","v":""}]
[]
[null,"September",null,{"$f":"IF($H$6=B26,$D$6,IF(J24=\"\",\"\",J24))","v":""},null,null,null,null,null,{"$f":"IF(AND(F26<>\"\",H26<>\"\"),D26+F26-H26,\"\")","v":""}]
[]
[null,"October",null,{"$f":"IF($H$6=B28,$D$6,IF(J26=\"\",\"\",J26))","v":""},null,null,null,null,null,{"$f":"IF(AND(F28<>\"\",H28<>\"\"),D28+F28-H28,\"\")","v":""}]
[]
[null,"November",null,{"$f":"IF($H$6=B30,$D$6,IF(J28=\"\",\"\",J28))","v":""},null,null,null,null,null,{"$f":"IF(AND(F30<>\"\",H30<>\"\"),D30+F30-H30,\"\")","v":""}]
[]
[null,"December",null,{"$f":"IF($H$6=B32,$D$6,IF(J30=\"\",\"\",J30))","v":""},null,null,null,null,null,{"$f":"IF(AND(F32<>\"\",H32<>\"\"),D32+F32-H32,\"\")","v":""}]
[]
[null,"Year to Date",null,{"$f":"D6","v":0},null,{"$f":"SUM(F10:F32)","v":0},null,{"$f":"SUM(H10:H32)","v":0},null,{"$f":"D34+F34-H34","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"January"]
[null,null,null,null,null,null,null,null,null,null,null,null,"February"]
[null,null,null,null,null,null,null,null,null,null,null,null,"March"]
[null,null,null,null,null,null,null,null,null,null,null,null,"April"]
[null,null,null,null,null,null,null,null,null,null,null,null,"May"]
[null,null,null,null,null,null,null,null,null,null,null,null,"June"]
[null,null,null,null,null,null,null,null,null,null,null,null,"July"]
[null,null,null,null,null,null,null,null,null,null,null,null,"August"]
[null,null,null,null,null,null,null,null,null,null,null,null,"September"]
[null,null,null,null,null,null,null,null,null,null,null,null,"October"]
[null,null,null,"Printed Report ",null,null,null,null,null,null,null,null,"November"]
[null,null,null,null,null,null,null,null,null,null,null,null,"December"]
[null,null,null,null,null,{"$f":"F1","v":"Test Secondary College"}]
[null,null,null,null,null,"Tracked Balances Report"]
[]
[null,"Subprogram",null,{"$f":"D4","v":0},null,null,null,"Year",null,{"$f":"J4","v":2014}]
[]
[null,"Opening Bal",null,{"$f":"D6","v":0},null,"Starting Month",null,{"$f":"H6","v":"January"}]
[]
[null,null,null,"Opening Balance",null,"Revenue",null,"Expenditure",null,"Balance"]
[]
[null,"January",null,{"$f":"D10","v":0},null,{"$f":"IF(F10<>\"\",F10,\"\")","v":""},null,{"$f":"IF(H10<>\"\",H10,\"\")","v":""},null,{"$f":"J10","v":""}]
[]
[null,"February",null,{"$f":"D12","v":""},null,{"$f":"IF(F12<>\"\",F12,\"\")","v":""},null,{"$f":"IF(H12<>\"\",H12,\"\")","v":""},null,{"$f":"J12","v":""}]
[]
[null,"March",null,{"$f":"D14","v":""},null,{"$f":"IF(F14<>\"\",F14,\"\")","v":""},null,{"$f":"IF(H14<>\"\",H14,\"\")","v":""},null,{"$f":"J14","v":""}]
[]
[null,"April",null,{"$f":"D16","v":""},null,{"$f":"IF(F16<>\"\",F16,\"\")","v":""},null,{"$f":"IF(H16<>\"\",H16,\"\")","v":""},null,{"$f":"J16","v":""}]
[]
[null,"May",null,{"$f":"D18","v":""},null,{"$f":"IF(F18<>\"\",F18,\"\")","v":""},null,{"$f":"IF(H18<>\"\",H18,\"\")","v":""},null,{"$f":"J18","v":""}]
[]
[null,"June",null,{"$f":"D20","v":""},null,{"$f":"IF(F20<>\"\",F20,\"\")","v":""},null,{"$f":"IF(H20<>\"\",H20,\"\")","v":""},null,{"$f":"J20","v":""}]
[]
[null,"July",null,{"$f":"D22","v":""},null,{"$f":"IF(F22<>\"\",F22,\"\")","v":""},null,{"$f":"IF(H22<>\"\",H22,\"\")","v":""},null,{"$f":"J22","v":""}]
[]
[null,"August",null,{"$f":"D24","v":""},null,{"$f":"IF(F24<>\"\",F24,\"\")","v":""},null,{"$f":"IF(H24<>\"\",H24,\"\")","v":""},null,{"$f":"J24","v":""}]
[]
[null,"September",null,{"$f":"D26","v":""},null,{"$f":"IF(F26<>\"\",F26,\"\")","v":""},null,{"$f":"IF(H26<>\"\",H26,\"\")","v":""},null,{"$f":"J26","v":""}]
[]
[null,"October",null,{"$f":"D28","v":""},null,{"$f":"IF(F28<>\"\",F28,\"\")","v":""},null,{"$f":"IF(H28<>\"\",H28,\"\")","v":""},null,{"$f":"J28","v":""}]
[]
[null,"November",null,{"$f":"D30","v":""},null,{"$f":"IF(F30<>\"\",F30,\"\")","v":""},null,{"$f":"IF(H30<>\"\",H30,\"\")","v":""},null,{"$f":"J30","v":""}]
[]
[null,"December",null,{"$f":"D32","v":""},null,{"$f":"IF(F32<>\"\",F32,\"\")","v":""},null,{"$f":"IF(H32<>\"\",H32,\"\")","v":""},null,{"$f":"J32","v":""}]
[]
[null,"Year to Date",null,{"$f":"D34","v":0},null,{"$f":"F34","v":0},null,{"$f":"H34","v":0},null,{"$f":"J34","v":0}]
[]
[]
[null,"Signed:",null,null,null,null,null,"Date:",null,{"$f":"TODAY()","v":"2020-08-09"}]

{"sheet":"SP8","index":8,"n_rows":104,"n_cols":13,"rows_kept":104,"cut":false,"hidden":false,"merged":[[3,3,3,5]]}
[null,null,null,null,null,{"$f":"Summary!F2","v":"Test Secondary College"}]
[null,null,null,null,null,"Tracked Balances Report"]
[]
[null,"Subprogram",null,null,null,null,null,"Year",null,{"$f":"Summary!F5","v":2014}]
[]
[null,"Opening Bal",null,0,null,"Starting Month",null,"January"]
[]
[null,null,null,"Opening Balance",null,"Revenue",null,"Expenditure",null,"Balance"]
[]
[null,"January",null,{"$f":"IF($H$6=B10,$D$6,\"\")","v":0},null,null,null,null,null,{"$f":"IF(AND(F10<>\"\",H10<>\"\"),D10+F10-H10,\"\")","v":""}]
[]
[null,"February",null,{"$f":"IF($H$6=B12,$D$6,IF(J10=\"\",\"\",J10))","v":""},null,null,null,null,null,{"$f":"IF(AND(F12<>\"\",H12<>\"\"),D12+F12-H12,\"\")","v":""}]
[]
[null,"March",null,{"$f":"IF($H$6=B14,$D$6,IF(J12=\"\",\"\",J12))","v":""},null,null,null,null,null,{"$f":"IF(AND(F14<>\"\",H14<>\"\"),D14+F14-H14,\"\")","v":""}]
[]
[null,"April",null,{"$f":"IF($H$6=B16,$D$6,IF(J14=\"\",\"\",J14))","v":""},null,null,null,null,null,{"$f":"IF(AND(F16<>\"\",H16<>\"\"),D16+F16-H16,\"\")","v":""}]
[]
[null,"May",null,{"$f":"IF($H$6=B18,$D$6,IF(J16=\"\",\"\",J16))","v":""},null,null,null,null,null,{"$f":"IF(AND(F18<>\"\",H18<>\"\"),D18+F18-H18,\"\")","v":""}]
[]
[null,"June",null,{"$f":"IF($H$6=B20,$D$6,IF(J18=\"\",\"\",J18))","v":""},null,null,null,null,null,{"$f":"IF(AND(F20<>\"\",H20<>\"\"),D20+F20-H20,\"\")","v":""}]
[]
[null,"July",null,{"$f":"IF($H$6=B22,$D$6,IF(J20=\"\",\"\",J20))","v":""},null,null,null,null,null,{"$f":"IF(AND(F22<>\"\",H22<>\"\"),D22+F22-H22,\"\")","v":""}]
[]
[null,"August",null,{"$f":"IF($H$6=B24,$D$6,IF(J22=\"\",\"\",J22))","v":""},null,null,null,null,null,{"$f":"IF(AND(F24<>\"\",H24<>\"\"),D24+F24-H24,\"\")","v":""}]
[]
[null,"September",null,{"$f":"IF($H$6=B26,$D$6,IF(J24=\"\",\"\",J24))","v":""},null,null,null,null,null,{"$f":"IF(AND(F26<>\"\",H26<>\"\"),D26+F26-H26,\"\")","v":""}]
[]
[null,"October",null,{"$f":"IF($H$6=B28,$D$6,IF(J26=\"\",\"\",J26))","v":""},null,null,null,null,null,{"$f":"IF(AND(F28<>\"\",H28<>\"\"),D28+F28-H28,\"\")","v":""}]
[]
[null,"November",null,{"$f":"IF($H$6=B30,$D$6,IF(J28=\"\",\"\",J28))","v":""},null,null,null,null,null,{"$f":"IF(AND(F30<>\"\",H30<>\"\"),D30+F30-H30,\"\")","v":""}]
[]
[null,"December",null,{"$f":"IF($H$6=B32,$D$6,IF(J30=\"\",\"\",J30))","v":""},null,null,null,null,null,{"$f":"IF(AND(F32<>\"\",H32<>\"\"),D32+F32-H32,\"\")","v":""}]
[]
[null,"Year to Date",null,{"$f":"D6","v":0},null,{"$f":"SUM(F10:F32)","v":0},null,{"$f":"SUM(H10:H32)","v":0},null,{"$f":"D34+F34-H34","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"January"]
[null,null,null,null,null,null,null,null,null,null,null,null,"February"]
[null,null,null,null,null,null,null,null,null,null,null,null,"March"]
[null,null,null,null,null,null,null,null,null,null,null,null,"April"]
[null,null,null,null,null,null,null,null,null,null,null,null,"May"]
[null,null,null,null,null,null,null,null,null,null,null,null,"June"]
[null,null,null,null,null,null,null,null,null,null,null,null,"July"]
[null,null,null,null,null,null,null,null,null,null,null,null,"August"]
[null,null,null,null,null,null,null,null,null,null,null,null,"September"]
[null,null,null,null,null,null,null,null,null,null,null,null,"October"]
[null,null,null,"Printed Report ",null,null,null,null,null,null,null,null,"November"]
[null,null,null,null,null,null,null,null,null,null,null,null,"December"]
[null,null,null,null,null,{"$f":"F1","v":"Test Secondary College"}]
[null,null,null,null,null,"Tracked Balances Report"]
[]
[null,"Subprogram",null,{"$f":"D4","v":0},null,null,null,"Year",null,{"$f":"J4","v":2014}]
[]
[null,"Opening Bal",null,{"$f":"D6","v":0},null,"Starting Month",null,{"$f":"H6","v":"January"}]
[]
[null,null,null,"Opening Balance",null,"Revenue",null,"Expenditure",null,"Balance"]
[]
[null,"January",null,{"$f":"D10","v":0},null,{"$f":"IF(F10<>\"\",F10,\"\")","v":""},null,{"$f":"IF(H10<>\"\",H10,\"\")","v":""},null,{"$f":"J10","v":""}]
[]
[null,"February",null,{"$f":"D12","v":""},null,{"$f":"IF(F12<>\"\",F12,\"\")","v":""},null,{"$f":"IF(H12<>\"\",H12,\"\")","v":""},null,{"$f":"J12","v":""}]
[]
[null,"March",null,{"$f":"D14","v":""},null,{"$f":"IF(F14<>\"\",F14,\"\")","v":""},null,{"$f":"IF(H14<>\"\",H14,\"\")","v":""},null,{"$f":"J14","v":""}]
[]
[null,"April",null,{"$f":"D16","v":""},null,{"$f":"IF(F16<>\"\",F16,\"\")","v":""},null,{"$f":"IF(H16<>\"\",H16,\"\")","v":""},null,{"$f":"J16","v":""}]
[]
[null,"May",null,{"$f":"D18","v":""},null,{"$f":"IF(F18<>\"\",F18,\"\")","v":""},null,{"$f":"IF(H18<>\"\",H18,\"\")","v":""},null,{"$f":"J18","v":""}]
[]
[null,"June",null,{"$f":"D20","v":""},null,{"$f":"IF(F20<>\"\",F20,\"\")","v":""},null,{"$f":"IF(H20<>\"\",H20,\"\")","v":""},null,{"$f":"J20","v":""}]
[]
[null,"July",null,{"$f":"D22","v":""},null,{"$f":"IF(F22<>\"\",F22,\"\")","v":""},null,{"$f":"IF(H22<>\"\",H22,\"\")","v":""},null,{"$f":"J22","v":""}]
[]
[null,"August",null,{"$f":"D24","v":""},null,{"$f":"IF(F24<>\"\",F24,\"\")","v":""},null,{"$f":"IF(H24<>\"\",H24,\"\")","v":""},null,{"$f":"J24","v":""}]
[]
[null,"September",null,{"$f":"D26","v":""},null,{"$f":"IF(F26<>\"\",F26,\"\")","v":""},null,{"$f":"IF(H26<>\"\",H26,\"\")","v":""},null,{"$f":"J26","v":""}]
[]
[null,"October",null,{"$f":"D28","v":""},null,{"$f":"IF(F28<>\"\",F28,\"\")","v":""},null,{"$f":"IF(H28<>\"\",H28,\"\")","v":""},null,{"$f":"J28","v":""}]
[]
[null,"November",null,{"$f":"D30","v":""},null,{"$f":"IF(F30<>\"\",F30,\"\")","v":""},null,{"$f":"IF(H30<>\"\",H30,\"\")","v":""},null,{"$f":"J30","v":""}]
[]
[null,"December",null,{"$f":"D32","v":""},null,{"$f":"IF(F32<>\"\",F32,\"\")","v":""},null,{"$f":"IF(H32<>\"\",H32,\"\")","v":""},null,{"$f":"J32","v":""}]
[]
[null,"Year to Date",null,{"$f":"D34","v":0},null,{"$f":"F34","v":0},null,{"$f":"H34","v":0},null,{"$f":"J34","v":0}]
[]
[]
[null,"Signed:",null,null,null,null,null,"Date:",null,{"$f":"TODAY()","v":"2020-08-09"}]

{"sheet":"SP9","index":9,"n_rows":104,"n_cols":13,"rows_kept":104,"cut":false,"hidden":false,"merged":[[3,3,3,5]]}
[null,null,null,null,null,{"$f":"Summary!F2","v":"Test Secondary College"}]
[null,null,null,null,null,"Tracked Balances Report"]
[]
[null,"Subprogram",null,null,null,null,null,"Year",null,{"$f":"Summary!F5","v":2014}]
[]
[null,"Opening Bal",null,null,null,"Starting Month",null,"January"]
[]
[null,null,null,"Opening Balance",null,"Revenue",null,"Expenditure",null,"Balance"]
[]
[null,"January",null,{"$f":"IF($H$6=B10,$D$6,\"\")","v":0},null,null,null,null,null,{"$f":"IF(AND(F10<>\"\",H10<>\"\"),D10+F10-H10,\"\")","v":""}]
[]
[null,"February",null,{"$f":"IF($H$6=B12,$D$6,IF(J10=\"\",\"\",J10))","v":""},null,null,null,null,null,{"$f":"IF(AND(F12<>\"\",H12<>\"\"),D12+F12-H12,\"\")","v":""}]
[]
[null,"March",null,{"$f":"IF($H$6=B14,$D$6,IF(J12=\"\",\"\",J12))","v":""},null,null,null,null,null,{"$f":"IF(AND(F14<>\"\",H14<>\"\"),D14+F14-H14,\"\")","v":""}]
[]
[null,"April",null,{"$f":"IF($H$6=B16,$D$6,IF(J14=\"\",\"\",J14))","v":""},null,null,null,null,null,{"$f":"IF(AND(F16<>\"\",H16<>\"\"),D16+F16-H16,\"\")","v":""}]
[]
[null,"May",null,{"$f":"IF($H$6=B18,$D$6,IF(J16=\"\",\"\",J16))","v":""},null,null,null,null,null,{"$f":"IF(AND(F18<>\"\",H18<>\"\"),D18+F18-H18,\"\")","v":""}]
[]
[null,"June",null,{"$f":"IF($H$6=B20,$D$6,IF(J18=\"\",\"\",J18))","v":""},null,null,null,null,null,{"$f":"IF(AND(F20<>\"\",H20<>\"\"),D20+F20-H20,\"\")","v":""}]
[]
[null,"July",null,{"$f":"IF($H$6=B22,$D$6,IF(J20=\"\",\"\",J20))","v":""},null,null,null,null,null,{"$f":"IF(AND(F22<>\"\",H22<>\"\"),D22+F22-H22,\"\")","v":""}]
[]
[null,"August",null,{"$f":"IF($H$6=B24,$D$6,IF(J22=\"\",\"\",J22))","v":""},null,null,null,null,null,{"$f":"IF(AND(F24<>\"\",H24<>\"\"),D24+F24-H24,\"\")","v":""}]
[]
[null,"September",null,{"$f":"IF($H$6=B26,$D$6,IF(J24=\"\",\"\",J24))","v":""},null,null,null,null,null,{"$f":"IF(AND(F26<>\"\",H26<>\"\"),D26+F26-H26,\"\")","v":""}]
[]
[null,"October",null,{"$f":"IF($H$6=B28,$D$6,IF(J26=\"\",\"\",J26))","v":""},null,null,null,null,null,{"$f":"IF(AND(F28<>\"\",H28<>\"\"),D28+F28-H28,\"\")","v":""}]
[]
[null,"November",null,{"$f":"IF($H$6=B30,$D$6,IF(J28=\"\",\"\",J28))","v":""},null,null,null,null,null,{"$f":"IF(AND(F30<>\"\",H30<>\"\"),D30+F30-H30,\"\")","v":""}]
[]
[null,"December",null,{"$f":"IF($H$6=B32,$D$6,IF(J30=\"\",\"\",J30))","v":""},null,null,null,null,null,{"$f":"IF(AND(F32<>\"\",H32<>\"\"),D32+F32-H32,\"\")","v":""}]
[]
[null,"Year to Date",null,{"$f":"D6","v":0},null,{"$f":"SUM(F10:F32)","v":0},null,{"$f":"SUM(H10:H32)","v":0},null,{"$f":"D34+F34-H34","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"January"]
[null,null,null,null,null,null,null,null,null,null,null,null,"February"]
[null,null,null,null,null,null,null,null,null,null,null,null,"March"]
[null,null,null,null,null,null,null,null,null,null,null,null,"April"]
[null,null,null,null,null,null,null,null,null,null,null,null,"May"]
[null,null,null,null,null,null,null,null,null,null,null,null,"June"]
[null,null,null,null,null,null,null,null,null,null,null,null,"July"]
[null,null,null,null,null,null,null,null,null,null,null,null,"August"]
[null,null,null,null,null,null,null,null,null,null,null,null,"September"]
[null,null,null,null,null,null,null,null,null,null,null,null,"October"]
[null,null,null,"Printed Report ",null,null,null,null,null,null,null,null,"November"]
[null,null,null,null,null,null,null,null,null,null,null,null,"December"]
[null,null,null,null,null,{"$f":"F1","v":"Test Secondary College"}]
[null,null,null,null,null,"Tracked Balances Report"]
[]
[null,"Subprogram",null,{"$f":"D4","v":0},null,null,null,"Year",null,{"$f":"J4","v":2014}]
[]
[null,"Opening Bal",null,{"$f":"D6","v":0},null,"Starting Month",null,{"$f":"H6","v":"January"}]
[]
[null,null,null,"Opening Balance",null,"Revenue",null,"Expenditure",null,"Balance"]
[]
[null,"January",null,{"$f":"D10","v":0},null,{"$f":"IF(F10<>\"\",F10,\"\")","v":""},null,{"$f":"IF(H10<>\"\",H10,\"\")","v":""},null,{"$f":"J10","v":""}]
[]
[null,"February",null,{"$f":"D12","v":""},null,{"$f":"IF(F12<>\"\",F12,\"\")","v":""},null,{"$f":"IF(H12<>\"\",H12,\"\")","v":""},null,{"$f":"J12","v":""}]
[]
[null,"March",null,{"$f":"D14","v":""},null,{"$f":"IF(F14<>\"\",F14,\"\")","v":""},null,{"$f":"IF(H14<>\"\",H14,\"\")","v":""},null,{"$f":"J14","v":""}]
[]
[null,"April",null,{"$f":"D16","v":""},null,{"$f":"IF(F16<>\"\",F16,\"\")","v":""},null,{"$f":"IF(H16<>\"\",H16,\"\")","v":""},null,{"$f":"J16","v":""}]
[]
[null,"May",null,{"$f":"D18","v":""},null,{"$f":"IF(F18<>\"\",F18,\"\")","v":""},null,{"$f":"IF(H18<>\"\",H18,\"\")","v":""},null,{"$f":"J18","v":""}]
[]
[null,"June",null,{"$f":"D20","v":""},null,{"$f":"IF(F20<>\"\",F20,\"\")","v":""},null,{"$f":"IF(H20<>\"\",H20,\"\")","v":""},null,{"$f":"J20","v":""}]
[]
[null,"July",null,{"$f":"D22","v":""},null,{"$f":"IF(F22<>\"\",F22,\"\")","v":""},null,{"$f":"IF(H22<>\"\",H22,\"\")","v":""},null,{"$f":"J22","v":""}]
[]
[null,"August",null,{"$f":"D24","v":""},null,{"$f":"IF(F24<>\"\",F24,\"\")","v":""},null,{"$f":"IF(H24<>\"\",H24,\"\")","v":""},null,{"$f":"J24","v":""}]
[]
[null,"September",null,{"$f":"D26","v":""},null,{"$f":"IF(F26<>\"\",F26,\"\")","v":""},null,{"$f":"IF(H26<>\"\",H26,\"\")","v":""},null,{"$f":"J26","v":""}]
[]
[null,"October",null,{"$f":"D28","v":""},null,{"$f":"IF(F28<>\"\",F28,\"\")","v":""},null,{"$f":"IF(H28<>\"\",H28,\"\")","v":""},null,{"$f":"J28","v":""}]
[]
[null,"November",null,{"$f":"D30","v":""},null,{"$f":"IF(F30<>\"\",F30,\"\")","v":""},null,{"$f":"IF(H30<>\"\",H30,\"\")","v":""},null,{"$f":"J30","v":""}]
[]
[null,"December",null,{"$f":"D32","v":""},null,{"$f":"IF(F32<>\"\",F32,\"\")","v":""},null,{"$f":"IF(H32<>\"\",H32,\"\")","v":""},null,{"$f":"J32","v":""}]
[]
[null,"Year to Date",null,{"$f":"D34","v":0},null,{"$f":"F34","v":0},null,{"$f":"H34","v":0},null,{"$f":"J34","v":0}]
[]
[]
[null,"Signed:",null,null,null,null,null,"Date:",null,{"$f":"TODAY()","v":"2020-08-09"}]

{"sheet":"SP10","index":10,"n_rows":104,"n_cols":13,"rows_kept":104,"cut":false,"hidden":false,"merged":[[3,3,3,5]]}
[null,null,null,null,null,{"$f":"Summary!F2","v":"Test Secondary College"}]
[null,null,null,null,null,"Tracked Balances Report"]
[]
[null,"Subprogram",null,null,null,null,null,"Year",null,{"$f":"Summary!F5","v":2014}]
[]
[null,"Opening Bal",null,null,null,"Starting Month",null,"January"]
[]
[null,null,null,"Opening Balance",null,"Revenue",null,"Expenditure",null,"Balance"]
[]
[null,"January",null,{"$f":"IF($H$6=B10,$D$6,\"\")","v":0},null,null,null,null,null,{"$f":"IF(AND(F10<>\"\",H10<>\"\"),D10+F10-H10,\"\")","v":""}]
[]
[null,"February",null,{"$f":"IF($H$6=B12,$D$6,IF(J10=\"\",\"\",J10))","v":""},null,null,null,null,null,{"$f":"IF(AND(F12<>\"\",H12<>\"\"),D12+F12-H12,\"\")","v":""}]
[]
[null,"March",null,{"$f":"IF($H$6=B14,$D$6,IF(J12=\"\",\"\",J12))","v":""},null,null,null,null,null,{"$f":"IF(AND(F14<>\"\",H14<>\"\"),D14+F14-H14,\"\")","v":""}]
[]
[null,"April",null,{"$f":"IF($H$6=B16,$D$6,IF(J14=\"\",\"\",J14))","v":""},null,null,null,null,null,{"$f":"IF(AND(F16<>\"\",H16<>\"\"),D16+F16-H16,\"\")","v":""}]
[]
[null,"May",null,{"$f":"IF($H$6=B18,$D$6,IF(J16=\"\",\"\",J16))","v":""},null,null,null,null,null,{"$f":"IF(AND(F18<>\"\",H18<>\"\"),D18+F18-H18,\"\")","v":""}]
[]
[null,"June",null,{"$f":"IF($H$6=B20,$D$6,IF(J18=\"\",\"\",J18))","v":""},null,null,null,null,null,{"$f":"IF(AND(F20<>\"\",H20<>\"\"),D20+F20-H20,\"\")","v":""}]
[]
[null,"July",null,{"$f":"IF($H$6=B22,$D$6,IF(J20=\"\",\"\",J20))","v":""},null,null,null,null,null,{"$f":"IF(AND(F22<>\"\",H22<>\"\"),D22+F22-H22,\"\")","v":""}]
[]
[null,"August",null,{"$f":"IF($H$6=B24,$D$6,IF(J22=\"\",\"\",J22))","v":""},null,null,null,null,null,{"$f":"IF(AND(F24<>\"\",H24<>\"\"),D24+F24-H24,\"\")","v":""}]
[]
[null,"September",null,{"$f":"IF($H$6=B26,$D$6,IF(J24=\"\",\"\",J24))","v":""},null,null,null,null,null,{"$f":"IF(AND(F26<>\"\",H26<>\"\"),D26+F26-H26,\"\")","v":""}]
[]
[null,"October",null,{"$f":"IF($H$6=B28,$D$6,IF(J26=\"\",\"\",J26))","v":""},null,null,null,null,null,{"$f":"IF(AND(F28<>\"\",H28<>\"\"),D28+F28-H28,\"\")","v":""}]
[]
[null,"November",null,{"$f":"IF($H$6=B30,$D$6,IF(J28=\"\",\"\",J28))","v":""},null,null,null,null,null,{"$f":"IF(AND(F30<>\"\",H30<>\"\"),D30+F30-H30,\"\")","v":""}]
[]
[null,"December",null,{"$f":"IF($H$6=B32,$D$6,IF(J30=\"\",\"\",J30))","v":""},null,null,null,null,null,{"$f":"IF(AND(F32<>\"\",H32<>\"\"),D32+F32-H32,\"\")","v":""}]
[]
[null,"Year to Date",null,{"$f":"D6","v":0},null,{"$f":"SUM(F10:F32)","v":0},null,{"$f":"SUM(H10:H32)","v":0},null,{"$f":"D34+F34-H34","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"January"]
[null,null,null,null,null,null,null,null,null,null,null,null,"February"]
[null,null,null,null,null,null,null,null,null,null,null,null,"March"]
[null,null,null,null,null,null,null,null,null,null,null,null,"April"]
[null,null,null,null,null,null,null,null,null,null,null,null,"May"]
[null,null,null,null,null,null,null,null,null,null,null,null,"June"]
[null,null,null,null,null,null,null,null,null,null,null,null,"July"]
[null,null,null,null,null,null,null,null,null,null,null,null,"August"]
[null,null,null,null,null,null,null,null,null,null,null,null,"September"]
[null,null,null,null,null,null,null,null,null,null,null,null,"October"]
[null,null,null,"Printed Report ",null,null,null,null,null,null,null,null,"November"]
[null,null,null,null,null,null,null,null,null,null,null,null,"December"]
[null,null,null,null,null,{"$f":"F1","v":"Test Secondary College"}]
[null,null,null,null,null,"Tracked Balances Report"]
[]
[null,"Subprogram",null,{"$f":"D4","v":0},null,null,null,"Year",null,{"$f":"J4","v":2014}]
[]
[null,"Opening Bal",null,{"$f":"D6","v":0},null,"Starting Month",null,{"$f":"H6","v":"January"}]
[]
[null,null,null,"Opening Balance",null,"Revenue",null,"Expenditure",null,"Balance"]
[]
[null,"January",null,{"$f":"D10","v":0},null,{"$f":"IF(F10<>\"\",F10,\"\")","v":""},null,{"$f":"IF(H10<>\"\",H10,\"\")","v":""},null,{"$f":"J10","v":""}]
[]
[null,"February",null,{"$f":"D12","v":""},null,{"$f":"IF(F12<>\"\",F12,\"\")","v":""},null,{"$f":"IF(H12<>\"\",H12,\"\")","v":""},null,{"$f":"J12","v":""}]
[]
[null,"March",null,{"$f":"D14","v":""},null,{"$f":"IF(F14<>\"\",F14,\"\")","v":""},null,{"$f":"IF(H14<>\"\",H14,\"\")","v":""},null,{"$f":"J14","v":""}]
[]
[null,"April",null,{"$f":"D16","v":""},null,{"$f":"IF(F16<>\"\",F16,\"\")","v":""},null,{"$f":"IF(H16<>\"\",H16,\"\")","v":""},null,{"$f":"J16","v":""}]
[]
[null,"May",null,{"$f":"D18","v":""},null,{"$f":"IF(F18<>\"\",F18,\"\")","v":""},null,{"$f":"IF(H18<>\"\",H18,\"\")","v":""},null,{"$f":"J18","v":""}]
[]
[null,"June",null,{"$f":"D20","v":""},null,{"$f":"IF(F20<>\"\",F20,\"\")","v":""},null,{"$f":"IF(H20<>\"\",H20,\"\")","v":""},null,{"$f":"J20","v":""}]
[]
[null,"July",null,{"$f":"D22","v":""},null,{"$f":"IF(F22<>\"\",F22,\"\")","v":""},null,{"$f":"IF(H22<>\"\",H22,\"\")","v":""},null,{"$f":"J22","v":""}]
[]
[null,"August",null,{"$f":"D24","v":""},null,{"$f":"IF(F24<>\"\",F24,\"\")","v":""},null,{"$f":"IF(H24<>\"\",H24,\"\")","v":""},null,{"$f":"J24","v":""}]
[]
[null,"September",null,{"$f":"D26","v":""},null,{"$f":"IF(F26<>\"\",F26,\"\")","v":""},null,{"$f":"IF(H26<>\"\",H26,\"\")","v":""},null,{"$f":"J26","v":""}]
[]
[null,"October",null,{"$f":"D28","v":""},null,{"$f":"IF(F28<>\"\",F28,\"\")","v":""},null,{"$f":"IF(H28<>\"\",H28,\"\")","v":""},null,{"$f":"J28","v":""}]
[]
[null,"November",null,{"$f":"D30","v":""},null,{"$f":"IF(F30<>\"\",F30,\"\")","v":""},null,{"$f":"IF(H30<>\"\",H30,\"\")","v":""},null,{"$f":"J30","v":""}]
[]
[null,"December",null,{"$f":"D32","v":""},null,{"$f":"IF(F32<>\"\",F32,\"\")","v":""},null,{"$f":"IF(H32<>\"\",H32,\"\")","v":""},null,{"$f":"J32","v":""}]
[]
[null,"Year to Date",null,{"$f":"D34","v":0},null,{"$f":"F34","v":0},null,{"$f":"H34","v":0},null,{"$f":"J34","v":0}]
[]
[]
[null,"Signed:",null,null,null,null,null,"Date:",null,{"$f":"TODAY()","v":"2020-08-09"}]