{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Control","Hire Purchase","Journal Worksheet","Sheet1"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":10,"comments":1,"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":"Control","index":0,"n_rows":108,"n_cols":13,"rows_kept":108,"cut":false,"hidden":true,"merged":[[0,9,0,12]]}
[null,null,null,null,null,null,null,null,null,"NO ROLLING FORWARD REQUIRED"]
[]
[null,null,null,null,null,null,null,null,null,"Borrowing Expenses for Write-Off",null,null,100]
[null,null,null,null,null,null,null,null,null,"Borrowing Expenses Max Period",null,null,60]
["Version 1 Update",null,null,null,null,null,null,null,null,"Month commenced",null,{"$f":"MONTH('Hire Purchase'!$I$10)","v":1}]
[null,null,null,null,null,null,null,null,null,"End of First Year",null,{"$f":"IF($L$5<=6,6-$L$5+1,6+12-$L$5+1)","v":6}]
["There was an update to this first version in Financial Calcs",null,null,null,null,null,null,null,null,"End of Second Year",null,{"$f":"L6+12","v":18}]
["It fixed an error in picking up bals for the Journal sheet",null,null,null,null,null,null,null,null,"End of Third Year",null,30]
["It was done one day after worksheet published.",null,null,null,null,null,null,null,null,"End of Fourth Year",null,42]
["So didn't create a new version number",null,null,null,null,null,null,null,null,"End of Fifth Year",null,54]
[null,null,null,null,null,null,null,null,null,"End of Sixth Year",null,66]
[null,null,null,null,null,null,null,null,null,"End of Seventh Year",null,78]
["Version 2 Update",null,null,null,null,null,null,null,null,"End of Eighth Year",null,90]
["Added email button and hyperlinks"]
[null,null,null,null,null,null,null,null,null,"Year commence (for journals)",null,null,{"$f":"EOMONTH(IF(MONTH(DateCommence) < 6, DATE(YEAR(DateCommence), 6, 1), DATE(YEAR(DateCommence) + 1, 6, 1)), 0)","v":"1900-06-30"}]
[]
[null,null,null,null,null,null,null,null,null,"Payment No","Borrowing Expenses","Cumulative Borr Xps"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!F18>0,1,0)","v":0},{"$f":"IF(AND(J18=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J18>0,'Hire Purchase'!$I$9>$M$3,J18<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},{"$f":"K18","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J18>0,J18+1,IF('Hire Purchase'!F19>0,1,0))","v":0},{"$f":"IF(AND(J19=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J19>0,'Hire Purchase'!$I$9>$M$3,J19<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},{"$f":"L18+K19","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J19>0,J19+1,IF('Hire Purchase'!F20>0,1,0))","v":0},{"$f":"IF(AND(J20=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J20>0,'Hire Purchase'!$I$9>$M$3,J20<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J20+1,0)","v":0},{"$f":"IF(AND(J21=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J21>0,'Hire Purchase'!$I$9>$M$3,J21<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J21+1,0)","v":0},{"$f":"IF(AND(J22=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J22>0,'Hire Purchase'!$I$9>$M$3,J22<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J22+1,0)","v":0},{"$f":"IF(AND(J23=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J23>0,'Hire Purchase'!$I$9>$M$3,J23<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J23+1,0)","v":0},{"$f":"IF(AND(J24=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J24>0,'Hire Purchase'!$I$9>$M$3,J24<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J24+1,0)","v":0},{"$f":"IF(AND(J25=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J25>0,'Hire Purchase'!$I$9>$M$3,J25<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J25+1,0)","v":0},{"$f":"IF(AND(J26=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J26>0,'Hire Purchase'!$I$9>$M$3,J26<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J26+1,0)","v":0},{"$f":"IF(AND(J27=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J27>0,'Hire Purchase'!$I$9>$M$3,J27<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J27+1,0)","v":0},{"$f":"IF(AND(J28=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J28>0,'Hire Purchase'!$I$9>$M$3,J28<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J28+1,0)","v":0},{"$f":"IF(AND(J29=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J29>0,'Hire Purchase'!$I$9>$M$3,J29<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J29+1,0)","v":0},{"$f":"IF(AND(J30=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J30>0,'Hire Purchase'!$I$9>$M$3,J30<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J30+1,0)","v":0},{"$f":"IF(AND(J31=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J31>0,'Hire Purchase'!$I$9>$M$3,J31<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J31+1,0)","v":0},{"$f":"IF(AND(J32=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J32>0,'Hire Purchase'!$I$9>$M$3,J32<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J32+1,0)","v":0},{"$f":"IF(AND(J33=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J33>0,'Hire Purchase'!$I$9>$M$3,J33<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J33+1,0)","v":0},{"$f":"IF(AND(J34=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J34>0,'Hire Purchase'!$I$9>$M$3,J34<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J34+1,0)","v":0},{"$f":"IF(AND(J35=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J35>0,'Hire Purchase'!$I$9>$M$3,J35<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J35+1,0)","v":0},{"$f":"IF(AND(J36=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J36>0,'Hire Purchase'!$I$9>$M$3,J36<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J36+1,0)","v":0},{"$f":"IF(AND(J37=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J37>0,'Hire Purchase'!$I$9>$M$3,J37<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J37+1,0)","v":0},{"$f":"IF(AND(J38=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J38>0,'Hire Purchase'!$I$9>$M$3,J38<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J38+1,0)","v":0},{"$f":"IF(AND(J39=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J39>0,'Hire Purchase'!$I$9>$M$3,J39<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J39+1,0)","v":0},{"$f":"IF(AND(J40=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J40>0,'Hire Purchase'!$I$9>$M$3,J40<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J40+1,0)","v":0},{"$f":"IF(AND(J41=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J41>0,'Hire Purchase'!$I$9>$M$3,J41<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J41+1,0)","v":0},{"$f":"IF(AND(J42=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J42>0,'Hire Purchase'!$I$9>$M$3,J42<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J42+1,0)","v":0},{"$f":"IF(AND(J43=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J43>0,'Hire Purchase'!$I$9>$M$3,J43<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J43+1,0)","v":0},{"$f":"IF(AND(J44=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J44>0,'Hire Purchase'!$I$9>$M$3,J44<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J44+1,0)","v":0},{"$f":"IF(AND(J45=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J45>0,'Hire Purchase'!$I$9>$M$3,J45<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J45+1,0)","v":0},{"$f":"IF(AND(J46=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J46>0,'Hire Purchase'!$I$9>$M$3,J46<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J46+1,0)","v":0},{"$f":"IF(AND(J47=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J47>0,'Hire Purchase'!$I$9>$M$3,J47<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J47+1,0)","v":0},{"$f":"IF(AND(J48=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J48>0,'Hire Purchase'!$I$9>$M$3,J48<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J48+1,0)","v":0},{"$f":"IF(AND(J49=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J49>0,'Hire Purchase'!$I$9>$M$3,J49<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J49+1,0)","v":0},{"$f":"IF(AND(J50=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J50>0,'Hire Purchase'!$I$9>$M$3,J50<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J50+1,0)","v":0},{"$f":"IF(AND(J51=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J51>0,'Hire Purchase'!$I$9>$M$3,J51<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},{"$f":"L50+K51","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J51+1,0)","v":0},{"$f":"IF(AND(J52=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J52>0,'Hire Purchase'!$I$9>$M$3,J52<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J52+1,0)","v":0},{"$f":"IF(AND(J53=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J53>0,'Hire Purchase'!$I$9>$M$3,J53<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J53+1,0)","v":0},{"$f":"IF(AND(J54=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J54>0,'Hire Purchase'!$I$9>$M$3,J54<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J54+1,0)","v":0},{"$f":"IF(AND(J55=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J55>0,'Hire Purchase'!$I$9>$M$3,J55<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J55+1,0)","v":0},{"$f":"IF(AND(J56=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J56>0,'Hire Purchase'!$I$9>$M$3,J56<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J56+1,0)","v":0},{"$f":"IF(AND(J57=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J57>0,'Hire Purchase'!$I$9>$M$3,J57<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J57+1,0)","v":0},{"$f":"IF(AND(J58=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J58>0,'Hire Purchase'!$I$9>$M$3,J58<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J58+1,0)","v":0},{"$f":"IF(AND(J59=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J59>0,'Hire Purchase'!$I$9>$M$3,J59<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J59+1,0)","v":0},{"$f":"IF(AND(J60=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J60>0,'Hire Purchase'!$I$9>$M$3,J60<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J60+1,0)","v":0},{"$f":"IF(AND(J61=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J61>0,'Hire Purchase'!$I$9>$M$3,J61<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J61+1,0)","v":0},{"$f":"IF(AND(J62=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J62>0,'Hire Purchase'!$I$9>$M$3,J62<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J62+1,0)","v":0},{"$f":"IF(AND(J63=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J63>0,'Hire Purchase'!$I$9>$M$3,J63<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J63+1,0)","v":0},{"$f":"IF(AND(J64=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J64>0,'Hire Purchase'!$I$9>$M$3,J64<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J64+1,0)","v":0},{"$f":"IF(AND(J65=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J65>0,'Hire Purchase'!$I$9>$M$3,J65<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J65+1,0)","v":0},{"$f":"IF(AND(J66=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J66>0,'Hire Purchase'!$I$9>$M$3,J66<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J66+1,0)","v":0},{"$f":"IF(AND(J67=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J67>0,'Hire Purchase'!$I$9>$M$3,J67<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J67+1,0)","v":0},{"$f":"IF(AND(J68=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J68>0,'Hire Purchase'!$I$9>$M$3,J68<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J68+1,0)","v":0},{"$f":"IF(AND(J69=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J69>0,'Hire Purchase'!$I$9>$M$3,J69<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J69+1,0)","v":0},{"$f":"IF(AND(J70=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J70>0,'Hire Purchase'!$I$9>$M$3,J70<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J70+1,0)","v":0},{"$f":"IF(AND(J71=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J71>0,'Hire Purchase'!$I$9>$M$3,J71<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J71+1,0)","v":0},{"$f":"IF(AND(J72=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J72>0,'Hire Purchase'!$I$9>$M$3,J72<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J72+1,0)","v":0},{"$f":"IF(AND(J73=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J73>0,'Hire Purchase'!$I$9>$M$3,J73<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J73+1,0)","v":0},{"$f":"IF(AND(J74=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J74>0,'Hire Purchase'!$I$9>$M$3,J74<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J74+1,0)","v":0},{"$f":"IF(AND(J75=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J75>0,'Hire Purchase'!$I$9>$M$3,J75<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J75+1,0)","v":0},{"$f":"IF(AND(J76=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J76>0,'Hire Purchase'!$I$9>$M$3,J76<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J76+1,0)","v":0},{"$f":"IF(AND(J77=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J77>0,'Hire Purchase'!$I$9>$M$3,J77<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J77+1,0)","v":0},{"$f":"IF(AND(J78=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J78>0,'Hire Purchase'!$I$9>$M$3,J78<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J78+1,0)","v":0},{"$f":"IF(AND(J79=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J79>0,'Hire Purchase'!$I$9>$M$3,J79<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J79+1,0)","v":0},{"$f":"IF(AND(J80=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J80>0,'Hire Purchase'!$I$9>$M$3,J80<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J80+1,0)","v":0},{"$f":"IF(AND(J81=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J81>0,'Hire Purchase'!$I$9>$M$3,J81<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J81+1,0)","v":0},{"$f":"IF(AND(J82=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J82>0,'Hire Purchase'!$I$9>$M$3,J82<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J82+1,0)","v":0},{"$f":"IF(AND(J83=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J83>0,'Hire Purchase'!$I$9>$M$3,J83<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},{"$f":"L82+K83","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J83+1,0)","v":0},{"$f":"IF(AND(J84=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J84>0,'Hire Purchase'!$I$9>$M$3,J84<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J84+1,0)","v":0},{"$f":"IF(AND(J85=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J85>0,'Hire Purchase'!$I$9>$M$3,J85<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J85+1,0)","v":0},{"$f":"IF(AND(J86=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J86>0,'Hire Purchase'!$I$9>$M$3,J86<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J86+1,0)","v":0},{"$f":"IF(AND(J87=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J87>0,'Hire Purchase'!$I$9>$M$3,J87<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J87+1,0)","v":0},{"$f":"IF(AND(J88=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J88>0,'Hire Purchase'!$I$9>$M$3,J88<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J88+1,0)","v":0},{"$f":"IF(AND(J89=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J89>0,'Hire Purchase'!$I$9>$M$3,J89<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J89+1,0)","v":0},{"$f":"IF(AND(J90=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J90>0,'Hire Purchase'!$I$9>$M$3,J90<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J90+1,0)","v":0},{"$f":"IF(AND(J91=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J91>0,'Hire Purchase'!$I$9>$M$3,J91<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J91+1,0)","v":0},{"$f":"IF(AND(J92=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J92>0,'Hire Purchase'!$I$9>$M$3,J92<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J92+1,0)","v":0},{"$f":"IF(AND(J93=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J93>0,'Hire Purchase'!$I$9>$M$3,J93<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J93+1,0)","v":0},{"$f":"IF(AND(J94=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J94>0,'Hire Purchase'!$I$9>$M$3,J94<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J94+1,0)","v":0},{"$f":"IF(AND(J95=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J95>0,'Hire Purchase'!$I$9>$M$3,J95<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J95+1,0)","v":0},{"$f":"IF(AND(J96=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J96>0,'Hire Purchase'!$I$9>$M$3,J96<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J96+1,0)","v":0},{"$f":"IF(AND(J97=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J97>0,'Hire Purchase'!$I$9>$M$3,J97<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J97+1,0)","v":0},{"$f":"IF(AND(J98=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J98>0,'Hire Purchase'!$I$9>$M$3,J98<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J98+1,0)","v":0},{"$f":"IF(AND(J99=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J99>0,'Hire Purchase'!$I$9>$M$3,J99<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J99+1,0)","v":0},{"$f":"IF(AND(J100=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J100>0,'Hire Purchase'!$I$9>$M$3,J100<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J100+1,0)","v":0},{"$f":"IF(AND(J101=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J101>0,'Hire Purchase'!$I$9>$M$3,J101<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J101+1,0)","v":0},{"$f":"IF(AND(J102=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J102>0,'Hire Purchase'!$I$9>$M$3,J102<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J102+1,0)","v":0},{"$f":"IF(AND(J103=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J103>0,'Hire Purchase'!$I$9>$M$3,J103<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J103+1,0)","v":0},{"$f":"IF(AND(J104=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J104>0,'Hire Purchase'!$I$9>$M$3,J104<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J104+1,0)","v":0},{"$f":"IF(AND(J105=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J105>0,'Hire Purchase'!$I$9>$M$3,J105<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J105+1,0)","v":0},{"$f":"IF(AND(J106=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J106>0,'Hire Purchase'!$I$9>$M$3,J106<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Hire Purchase'!$I$10>0,J106+1,0)","v":0},{"$f":"IF(AND(J107=1,'Hire Purchase'!$I$9<=$M$3),'Hire Purchase'!$I$9,IF(AND(J107>0,'Hire Purchase'!$I$9>$M$3,J107<=MIN('Hire Purchase'!$I$7,$M$4)),'Hire Purchase'!$I$9/MIN('Hire Purchase'!$I$7,$M$4),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J18:J107)","v":0},{"$f":"SUM(K18:K107)","v":0}]

{"sheet":"Hire Purchase","index":1,"n_rows":109,"n_cols":15,"rows_kept":109,"cut":false,"hidden":false,"merged":[[0,10,0,12],[1,10,1,12],[4,2,4,4],[3,2,3,4],[11,6,13,8],[7,6,7,7],[9,2,9,4],[8,6,8,7],[9,6,9,7],[7,2,7,4],[10,2,10,4],[4,6,4,7],[3,6,3,8],[15,7,15,9],[15,2,15,6],[5,6,5,7],[6,2,6,4],[12,2,12,3],[6,6,6,7],[3,14,3,16],[14,14,14,16],[15,10,15,11],[4,14,7,16],[3,10,3,12],[9,14,9,16],[10,14,12,16],[15,14,16,16]]}
[null,"ℹ","Hire Purchase Schedule",null,null,null,null,null,null,null,"Client Name"]
[null,null,"Regular Monthly Repayments",null,null,null,null,null,null,null,"Preparer Name"]
[]
[null,null,"Lender",null,null,null,"Loan Details",null,null,null,"Annual Summary",null,null,null,"Journal Worksheet"]
[null,null,null,null,null,null,"Amount Borrowed",null,null,null,"Year","Interest","Borrowing",null,"Use the Journal Worksheet to quickly calculate the journals required to update your general ledger with the acquisition and EOFY balances each year."]
[null,null,null,null,null,null,"Monthly Repayments",null,null,null,{"$f":"IF(I10>0,IF(MONTH(I10)<=6,YEAR(I10),YEAR(I10)+1),0)","v":0},{"$f":"IF($I$10>0,SUMIF(Control!$J$18:$J$107,\"<=\" & IF($C$11=\"On Commencement\",Control!L6,Control!L6-1),$E$18:$E$107),0)","v":0},{"$f":"IF(Control!J108>0,VLOOKUP(Control!L6,Control!J18:L107,3,FALSE),0)","v":0}]
[null,null,"Asset Acquired",null,null,null,"Term (months)",null,null,null,{"$f":"IF(L7>1,K6+1,0)","v":0},{"$f":"IF($I$10>0,SUMIF(Control!$J$18:$J$107,\"<=\" & IF($C$11=\"On Commencement\",Control!L7,Control!L7-1),$E$18:$E$107)-L6,0)","v":0},{"$f":"IF(Control!J108>0,VLOOKUP(Control!L7,Control!J19:L108,3,FALSE)-M6,0)","v":0}]
[null,null,null,null,null,null,"Residual",null,null,null,0,{"$f":"IF($I$10>0,SUMIF(Control!$J$18:$J$107,\"<=\" & IF($C$11=\"On Commencement\",Control!L8,Control!L8-1),$E$18:$E$107)-SUM(L6:L7),0)","v":0},{"$f":"IF(Control!J108>0,VLOOKUP(Control!L8,Control!J20:L109,3,FALSE)-SUM(M6:M7),0)","v":0}]
[null,null,null,null,null,null,"Borrowing Costs",null,null,null,0,{"$f":"IF($I$10>0,SUMIF(Control!$J$18:$J$107,\"<=\" & IF($C$11=\"On Commencement\",Control!L9,Control!L9-1),$E$18:$E$107)-SUM(L6:L8),0)","v":0},{"$f":"IF(Control!J108>0,VLOOKUP(Control!L9,Control!J21:L110,3,FALSE)-SUM(M6:M8),0)","v":0}]
[null,null,"First Payment",null,null,null,"Date Commenced",null,null,null,0,{"$f":"IF($I$10>0,SUMIF(Control!$J$18:$J$107,\"<=\" & IF($C$11=\"On Commencement\",Control!L10,Control!L10-1),$E$18:$E$107)-SUM(L6:L9),0)","v":0},{"$f":"IF(Control!J108>0,VLOOKUP(Control!L10,Control!J22:L111,3,FALSE)-SUM(M6:M9),0)","v":0},null,"Help or Feedback"]
[null,null,"Please Select",null,null,null,null,null,null,null,0,{"$f":"IF($I$10>0,SUMIF(Control!$J$18:$J$107,\"<=\" & IF($C$11=\"On Commencement\",Control!L11,Control!L11-1),$E$18:$E$107)-SUM(L6:L10),0)","v":0},{"$f":"IF(Control!J108>0,VLOOKUP(Control!L11,Control!J23:L112,3,FALSE)-SUM(M6:M10),0)","v":0},null,"Click on the mail button above to send us an email to get help on using this spreadsheet or to provide feedback."]
[null,null,null,null,null,null,{"$f":"IF(AND(I5>0,I6>0,I7>0),IF((I6*I7)+I8<=I5,\"There is no interest to calculate because monthly repayments plus any residual do not exceed the original amount borrowed\",\"\"),\"\")","v":""},null,null,null,0,{"$f":"IF($I$10>0,SUMIF(Control!$J$18:$J$107,\"<=\" & IF($C$11=\"On Commencement\",Control!L12,Control!L12-1),$E$18:$E$107)-SUM(L6:L11),0)","v":0}]
[null,null,"Interest Rate/Month",null,{"$f":"IF(AND(I5>0,(I6*I7)+I8>I5),RATE(I7,I6,-I5,I8,IF(C11=\"On Commencement\",1,0)),0)","v":0},null,null,null,null,null,0,{"$f":"IF($I$10>0,SUMIF(Control!$J$18:$J$107,\"<=\" & IF($C$11=\"On Commencement\",Control!L13,Control!L13-1),$E$18:$E$107)-SUM(L6:L12),0)","v":0}]
[null,null,"Effective Annual Rate",null,{"$f":"IF(E13>0,EFFECT(E13*12,12),0)","v":0},null,null,null,null,null,"Totals",{"$f":"SUM(L6:L13)","v":0},{"$f":"SUM(M6:M13)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Warning - Drag & Drop"]
[null,null,"Amortisation",null,null,null,null,"Liability",null,null,"Unexpired Interest",null,"Borrowing",null,"Dragging and dropping one or more cells to any cell that is referenced in a formula will produce a formula error."]
[null,null,"Month","Opening\nBalance","Add\nInterest","Less\nRepayments","Closing\nBalance","Account\nBalance","Current\nLiability","Non-Current\nLiability","Current\nUnexpired Int","Non-Current\nUnexpired Int","Borrowing\nCosts"]
[null,null,{"$f":"IF($I$10>0,IF(MONTH($I$10)=1,EOMONTH($I$10,0),0)+IF(MONTH($I$10)=4,EOMONTH($I$10,0),0)+IF(MONTH($I$10)=7,EOMONTH($I$10,0),0)+IF(MONTH($I$10)=10,EOMONTH($I$10,0),0),0)","v":"00:00:00"},{"$f":"IF(C18>0,I5,0)","v":0},null,{"$f":"IF(AND(C18>0,$C$11=\"On Commencement\"),$I$6,0)","v":0},{"$f":"IF(C18>0,ROUND(D18+E18-F18,8),0)","v":0},{"$f":"IF(C18>0,($I$6*$I$7)+$I$8-F18,0)","v":0},{"$f":"IF(H18>0,SUM(F19:F30),0)","v":0},{"$f":"IF(H18>I18,H18-I18,0)","v":0},{"$f":"IF(H18>0,SUM(E19:E30),0)","v":0},{"$f":"IF(H18>0,SUM(E31:$E$107),0)","v":0},{"$f":"Control!K18","v":0}]
[null,null,{"$f":"IF(AND(I10>0,C18>0),EOMONTH(C18,1),IF(MONTH($I$10)=2,EOMONTH($I$10,0),0)+IF(MONTH($I$10)=5,EOMONTH($I$10,0),0)+IF(MONTH($I$10)=8,EOMONTH($I$10,0),0)+IF(MONTH($I$10)=11,EOMONTH($I$10,0),0))","v":"00:00:00"},{"$f":"IF(G18>0,G18,IF(C19>0,I5,0))","v":0},{"$f":"IF(AND(D19>0,D18>0),D19*$E$13,0)","v":0},{"$f":"IF(AND(C18>0,C19>0),$I$6,IF(AND(C19>0,C11=\"On Commencement\"),$I$6,0))","v":0},0,{"$f":"IF(H18>0,H18-F19,IF(C19>0,(I6*I7)+I8-F19,0))","v":0},0,0,{"$f":"IF(H19>0,SUM(E20:E31),0)","v":0},{"$f":"IF(H19>0,SUM(E32:$E$107),0)","v":0},{"$f":"Control!K19","v":0}]
[null,null,{"$f":"IF(AND(I10>0,C19>0),EOMONTH(C19,1),IF(MONTH($I$10)=3,EOMONTH($I$10,0),0)+IF(MONTH($I$10)=6,EOMONTH($I$10,0),0)+IF(MONTH($I$10)=9,EOMONTH($I$10,0),0)+IF(MONTH($I$10)=12,EOMONTH($I$10,0),0))","v":"00:00:00"},{"$f":"IF(G19>0,G19,IF(C20>0,$I$5,0))","v":0},{"$f":"IF(AND(D20>0,D19>0),D20*$E$13,0)","v":0},{"$f":"IF(C19>0,$I$6,IF(AND(C20>0,$C$11=\"On Commencement\"),$I$6,0))","v":0},0,{"$f":"IF(I10>0,IF(H19>0,H19-F20,(I6*I7)+I8-F20),0)","v":0},0,0,{"$f":"SUM(E21:E32)","v":0},{"$f":"IF(H20>0,SUM(E33:$E$107),0)","v":0},{"$f":"Control!K20","v":0}]
[{"$f":"IF(C21<>0,0,\"blank\")","v":"blank"},null,{"$f":"IF($I$10>0,IF(Control!J21<=$I$7+IF($I$8>0,1,0),EOMONTH(C20,1),0),0)","v":"00:00:00"},{"$f":"IF(AND(G20>0,C21>0),G20,0)","v":0},{"$f":"IF(AND(D21>0,Control!J21<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D21*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J21<=$I$7,$I$6,0)+IF(Control!J21=$I$7+1,$I$8,0),0)","v":0},0,{"$f":"ROUND(H20-F21,2)","v":0},0,0,0,{"$f":"IF(H21>0,SUM(E34:$E$107),0)","v":0},{"$f":"Control!K21","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J22<=$I$7+IF($I$8>0,1,0),EOMONTH(C21,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D22>0,Control!J22<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D22*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J22<=$I$7,$I$6,0)+IF(Control!J22=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H22>0,SUM(E35:$E$107),0)","v":0},{"$f":"Control!K22","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J23<=$I$7+IF($I$8>0,1,0),EOMONTH(C22,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D23>0,Control!J23<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D23*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J23<=$I$7,$I$6,0)+IF(Control!J23=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H23>0,SUM(E36:$E$107),0)","v":0},{"$f":"Control!K23","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J24<=$I$7+IF($I$8>0,1,0),EOMONTH(C23,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D24>0,Control!J24<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D24*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J24<=$I$7,$I$6,0)+IF(Control!J24=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H24>0,SUM(E37:$E$107),0)","v":0},{"$f":"Control!K24","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J25<=$I$7+IF($I$8>0,1,0),EOMONTH(C24,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D25>0,Control!J25<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D25*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J25<=$I$7,$I$6,0)+IF(Control!J25=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H25>0,SUM(E38:$E$107),0)","v":0},{"$f":"Control!K25","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J26<=$I$7+IF($I$8>0,1,0),EOMONTH(C25,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D26>0,Control!J26<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D26*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J26<=$I$7,$I$6,0)+IF(Control!J26=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H26>0,SUM(E39:$E$107),0)","v":0},{"$f":"Control!K26","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J27<=$I$7+IF($I$8>0,1,0),EOMONTH(C26,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D27>0,Control!J27<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D27*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J27<=$I$7,$I$6,0)+IF(Control!J27=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H27>0,SUM(E40:$E$107),0)","v":0},{"$f":"Control!K27","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J28<=$I$7+IF($I$8>0,1,0),EOMONTH(C27,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D28>0,Control!J28<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D28*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J28<=$I$7,$I$6,0)+IF(Control!J28=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H28>0,SUM(E41:$E$107),0)","v":0},{"$f":"Control!K28","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J29<=$I$7+IF($I$8>0,1,0),EOMONTH(C28,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D29>0,Control!J29<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D29*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J29<=$I$7,$I$6,0)+IF(Control!J29=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H29>0,SUM(E42:$E$107),0)","v":0},{"$f":"Control!K29","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J30<=$I$7+IF($I$8>0,1,0),EOMONTH(C29,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D30>0,Control!J30<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D30*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J30<=$I$7,$I$6,0)+IF(Control!J30=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H30>0,SUM(E43:$E$107),0)","v":0},{"$f":"Control!K30","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J31<=$I$7+IF($I$8>0,1,0),EOMONTH(C30,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D31>0,Control!J31<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D31*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J31<=$I$7,$I$6,0)+IF(Control!J31=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H31>0,SUM(E44:$E$107),0)","v":0},{"$f":"Control!K31","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J32<=$I$7+IF($I$8>0,1,0),EOMONTH(C31,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D32>0,Control!J32<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D32*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J32<=$I$7,$I$6,0)+IF(Control!J32=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H32>0,SUM(E45:$E$107),0)","v":0},{"$f":"Control!K32","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J33<=$I$7+IF($I$8>0,1,0),EOMONTH(C32,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D33>0,Control!J33<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D33*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J33<=$I$7,$I$6,0)+IF(Control!J33=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H33>0,SUM(E46:$E$107),0)","v":0},{"$f":"Control!K33","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J34<=$I$7+IF($I$8>0,1,0),EOMONTH(C33,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D34>0,Control!J34<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D34*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J34<=$I$7,$I$6,0)+IF(Control!J34=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H34>0,SUM(E47:$E$107),0)","v":0},{"$f":"Control!K34","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J35<=$I$7+IF($I$8>0,1,0),EOMONTH(C34,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D35>0,Control!J35<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D35*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J35<=$I$7,$I$6,0)+IF(Control!J35=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H35>0,SUM(E48:$E$107),0)","v":0},{"$f":"Control!K35","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J36<=$I$7+IF($I$8>0,1,0),EOMONTH(C35,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D36>0,Control!J36<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D36*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J36<=$I$7,$I$6,0)+IF(Control!J36=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H36>0,SUM(E49:$E$107),0)","v":0},{"$f":"Control!K36","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J37<=$I$7+IF($I$8>0,1,0),EOMONTH(C36,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D37>0,Control!J37<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D37*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J37<=$I$7,$I$6,0)+IF(Control!J37=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H37>0,SUM(E50:$E$107),0)","v":0},{"$f":"Control!K37","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J38<=$I$7+IF($I$8>0,1,0),EOMONTH(C37,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D38>0,Control!J38<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D38*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J38<=$I$7,$I$6,0)+IF(Control!J38=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H38>0,SUM(E51:$E$107),0)","v":0},{"$f":"Control!K38","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J39<=$I$7+IF($I$8>0,1,0),EOMONTH(C38,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D39>0,Control!J39<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D39*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J39<=$I$7,$I$6,0)+IF(Control!J39=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H39>0,SUM(E52:$E$107),0)","v":0},{"$f":"Control!K39","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J40<=$I$7+IF($I$8>0,1,0),EOMONTH(C39,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D40>0,Control!J40<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D40*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J40<=$I$7,$I$6,0)+IF(Control!J40=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H40>0,SUM(E53:$E$107),0)","v":0},{"$f":"Control!K40","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J41<=$I$7+IF($I$8>0,1,0),EOMONTH(C40,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D41>0,Control!J41<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D41*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J41<=$I$7,$I$6,0)+IF(Control!J41=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H41>0,SUM(E54:$E$107),0)","v":0},{"$f":"Control!K41","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J42<=$I$7+IF($I$8>0,1,0),EOMONTH(C41,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D42>0,Control!J42<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D42*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J42<=$I$7,$I$6,0)+IF(Control!J42=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H42>0,SUM(E55:$E$107),0)","v":0},{"$f":"Control!K42","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J43<=$I$7+IF($I$8>0,1,0),EOMONTH(C42,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D43>0,Control!J43<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D43*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J43<=$I$7,$I$6,0)+IF(Control!J43=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H43>0,SUM(E56:$E$107),0)","v":0},{"$f":"Control!K43","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J44<=$I$7+IF($I$8>0,1,0),EOMONTH(C43,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D44>0,Control!J44<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D44*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J44<=$I$7,$I$6,0)+IF(Control!J44=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H44>0,SUM(E57:$E$107),0)","v":0},{"$f":"Control!K44","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J45<=$I$7+IF($I$8>0,1,0),EOMONTH(C44,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D45>0,Control!J45<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D45*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J45<=$I$7,$I$6,0)+IF(Control!J45=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H45>0,SUM(E58:$E$107),0)","v":0},{"$f":"Control!K45","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J46<=$I$7+IF($I$8>0,1,0),EOMONTH(C45,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D46>0,Control!J46<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D46*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J46<=$I$7,$I$6,0)+IF(Control!J46=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H46>0,SUM(E59:$E$107),0)","v":0},{"$f":"Control!K46","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J47<=$I$7+IF($I$8>0,1,0),EOMONTH(C46,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D47>0,Control!J47<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D47*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J47<=$I$7,$I$6,0)+IF(Control!J47=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H47>0,SUM(E60:$E$107),0)","v":0},{"$f":"Control!K47","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J48<=$I$7+IF($I$8>0,1,0),EOMONTH(C47,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D48>0,Control!J48<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D48*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J48<=$I$7,$I$6,0)+IF(Control!J48=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H48>0,SUM(E61:$E$107),0)","v":0},{"$f":"Control!K48","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J49<=$I$7+IF($I$8>0,1,0),EOMONTH(C48,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D49>0,Control!J49<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D49*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J49<=$I$7,$I$6,0)+IF(Control!J49=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H49>0,SUM(E62:$E$107),0)","v":0},{"$f":"Control!K49","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J50<=$I$7+IF($I$8>0,1,0),EOMONTH(C49,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D50>0,Control!J50<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D50*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J50<=$I$7,$I$6,0)+IF(Control!J50=$I$7+1,$I$8,0),0)","v":0},{"$f":"IF(C50>0,ROUND(D50+E50-F50,8),0)","v":0},0,{"$f":"IF(H50>0,SUM(F51:F62),0)","v":0},{"$f":"IF(H50>I50,H50-I50,0)","v":0},0,{"$f":"IF(H50>0,SUM(E63:$E$107),0)","v":0},{"$f":"Control!K50","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J51<=$I$7+IF($I$8>0,1,0),EOMONTH(C50,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D51>0,Control!J51<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D51*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J51<=$I$7,$I$6,0)+IF(Control!J51=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H51>0,SUM(E64:$E$107),0)","v":0},{"$f":"Control!K51","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J52<=$I$7+IF($I$8>0,1,0),EOMONTH(C51,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D52>0,Control!J52<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D52*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J52<=$I$7,$I$6,0)+IF(Control!J52=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,{"$f":"SUM(E53:E64)","v":0},{"$f":"IF(H52>0,SUM(E65:$E$107),0)","v":0},{"$f":"Control!K52","v":0}]
[{"$f":"IF(C53<>0,0,\"blank\")","v":"blank"},null,{"$f":"IF($I$10>0,IF(Control!J53<=$I$7+IF($I$8>0,1,0),EOMONTH(C52,1),0),0)","v":"00:00:00"},{"$f":"IF(AND(G52>0,C53>0),G52,0)","v":0},{"$f":"IF(AND(D53>0,Control!J53<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D53*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J53<=$I$7,$I$6,0)+IF(Control!J53=$I$7+1,$I$8,0),0)","v":0},0,{"$f":"ROUND(H52-F53,2)","v":0},0,0,0,{"$f":"IF(H53>0,SUM(E66:$E$107),0)","v":0},{"$f":"Control!K53","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J54<=$I$7+IF($I$8>0,1,0),EOMONTH(C53,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D54>0,Control!J54<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D54*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J54<=$I$7,$I$6,0)+IF(Control!J54=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H54>0,SUM(E67:$E$107),0)","v":0},{"$f":"Control!K54","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J55<=$I$7+IF($I$8>0,1,0),EOMONTH(C54,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D55>0,Control!J55<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D55*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J55<=$I$7,$I$6,0)+IF(Control!J55=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H55>0,SUM(E68:$E$107),0)","v":0},{"$f":"Control!K55","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J56<=$I$7+IF($I$8>0,1,0),EOMONTH(C55,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D56>0,Control!J56<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D56*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J56<=$I$7,$I$6,0)+IF(Control!J56=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H56>0,SUM(E69:$E$107),0)","v":0},{"$f":"Control!K56","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J57<=$I$7+IF($I$8>0,1,0),EOMONTH(C56,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D57>0,Control!J57<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D57*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J57<=$I$7,$I$6,0)+IF(Control!J57=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H57>0,SUM(E70:$E$107),0)","v":0},{"$f":"Control!K57","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J58<=$I$7+IF($I$8>0,1,0),EOMONTH(C57,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D58>0,Control!J58<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D58*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J58<=$I$7,$I$6,0)+IF(Control!J58=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H58>0,SUM(E71:$E$107),0)","v":0},{"$f":"Control!K58","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J59<=$I$7+IF($I$8>0,1,0),EOMONTH(C58,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D59>0,Control!J59<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D59*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J59<=$I$7,$I$6,0)+IF(Control!J59=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H59>0,SUM(E72:$E$107),0)","v":0},{"$f":"Control!K59","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J60<=$I$7+IF($I$8>0,1,0),EOMONTH(C59,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D60>0,Control!J60<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D60*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J60<=$I$7,$I$6,0)+IF(Control!J60=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H60>0,SUM(E73:$E$107),0)","v":0},{"$f":"Control!K60","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J61<=$I$7+IF($I$8>0,1,0),EOMONTH(C60,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D61>0,Control!J61<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D61*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J61<=$I$7,$I$6,0)+IF(Control!J61=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H61>0,SUM(E74:$E$107),0)","v":0},{"$f":"Control!K61","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J62<=$I$7+IF($I$8>0,1,0),EOMONTH(C61,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D62>0,Control!J62<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D62*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J62<=$I$7,$I$6,0)+IF(Control!J62=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H62>0,SUM(E75:$E$107),0)","v":0},{"$f":"Control!K62","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J63<=$I$7+IF($I$8>0,1,0),EOMONTH(C62,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D63>0,Control!J63<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D63*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J63<=$I$7,$I$6,0)+IF(Control!J63=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H63>0,SUM(E76:$E$107),0)","v":0},{"$f":"Control!K63","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J64<=$I$7+IF($I$8>0,1,0),EOMONTH(C63,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D64>0,Control!J64<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D64*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J64<=$I$7,$I$6,0)+IF(Control!J64=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H64>0,SUM(E77:$E$107),0)","v":0},{"$f":"Control!K64","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J65<=$I$7+IF($I$8>0,1,0),EOMONTH(C64,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D65>0,Control!J65<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D65*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J65<=$I$7,$I$6,0)+IF(Control!J65=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H65>0,SUM(E78:$E$107),0)","v":0},{"$f":"Control!K65","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J66<=$I$7+IF($I$8>0,1,0),EOMONTH(C65,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D66>0,Control!J66<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D66*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J66<=$I$7,$I$6,0)+IF(Control!J66=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H66>0,SUM(E79:$E$107),0)","v":0},{"$f":"Control!K66","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J67<=$I$7+IF($I$8>0,1,0),EOMONTH(C66,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D67>0,Control!J67<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D67*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J67<=$I$7,$I$6,0)+IF(Control!J67=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H67>0,SUM(E80:$E$107),0)","v":0},{"$f":"Control!K67","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J68<=$I$7+IF($I$8>0,1,0),EOMONTH(C67,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D68>0,Control!J68<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D68*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J68<=$I$7,$I$6,0)+IF(Control!J68=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H68>0,SUM(E81:$E$107),0)","v":0},{"$f":"Control!K68","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J69<=$I$7+IF($I$8>0,1,0),EOMONTH(C68,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D69>0,Control!J69<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D69*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J69<=$I$7,$I$6,0)+IF(Control!J69=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H69>0,SUM(E82:$E$107),0)","v":0},{"$f":"Control!K69","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J70<=$I$7+IF($I$8>0,1,0),EOMONTH(C69,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D70>0,Control!J70<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D70*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J70<=$I$7,$I$6,0)+IF(Control!J70=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H70>0,SUM(E83:$E$107),0)","v":0},{"$f":"Control!K70","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J71<=$I$7+IF($I$8>0,1,0),EOMONTH(C70,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D71>0,Control!J71<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D71*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J71<=$I$7,$I$6,0)+IF(Control!J71=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H71>0,SUM(E84:$E$107),0)","v":0},{"$f":"Control!K71","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J72<=$I$7+IF($I$8>0,1,0),EOMONTH(C71,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D72>0,Control!J72<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D72*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J72<=$I$7,$I$6,0)+IF(Control!J72=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H72>0,SUM(E85:$E$107),0)","v":0},{"$f":"Control!K72","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J73<=$I$7+IF($I$8>0,1,0),EOMONTH(C72,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D73>0,Control!J73<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D73*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J73<=$I$7,$I$6,0)+IF(Control!J73=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H73>0,SUM(E86:$E$107),0)","v":0},{"$f":"Control!K73","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J74<=$I$7+IF($I$8>0,1,0),EOMONTH(C73,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D74>0,Control!J74<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D74*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J74<=$I$7,$I$6,0)+IF(Control!J74=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H74>0,SUM(E87:$E$107),0)","v":0},{"$f":"Control!K74","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J75<=$I$7+IF($I$8>0,1,0),EOMONTH(C74,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D75>0,Control!J75<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D75*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J75<=$I$7,$I$6,0)+IF(Control!J75=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H75>0,SUM(E88:$E$107),0)","v":0},{"$f":"Control!K75","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J76<=$I$7+IF($I$8>0,1,0),EOMONTH(C75,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D76>0,Control!J76<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D76*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J76<=$I$7,$I$6,0)+IF(Control!J76=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H76>0,SUM(E89:$E$107),0)","v":0},{"$f":"Control!K76","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J77<=$I$7+IF($I$8>0,1,0),EOMONTH(C76,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D77>0,Control!J77<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D77*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J77<=$I$7,$I$6,0)+IF(Control!J77=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H77>0,SUM(E90:$E$107),0)","v":0},{"$f":"Control!K77","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J78<=$I$7+IF($I$8>0,1,0),EOMONTH(C77,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D78>0,Control!J78<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D78*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J78<=$I$7,$I$6,0)+IF(Control!J78=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H78>0,SUM(E91:$E$107),0)","v":0},{"$f":"Control!K78","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J79<=$I$7+IF($I$8>0,1,0),EOMONTH(C78,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D79>0,Control!J79<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D79*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J79<=$I$7,$I$6,0)+IF(Control!J79=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H79>0,SUM(E92:$E$107),0)","v":0},{"$f":"Control!K79","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J80<=$I$7+IF($I$8>0,1,0),EOMONTH(C79,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D80>0,Control!J80<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D80*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J80<=$I$7,$I$6,0)+IF(Control!J80=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H80>0,SUM(E93:$E$107),0)","v":0},{"$f":"Control!K80","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J81<=$I$7+IF($I$8>0,1,0),EOMONTH(C80,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D81>0,Control!J81<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D81*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J81<=$I$7,$I$6,0)+IF(Control!J81=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H81>0,SUM(E94:$E$107),0)","v":0},{"$f":"Control!K81","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J82<=$I$7+IF($I$8>0,1,0),EOMONTH(C81,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D82>0,Control!J82<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D82*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J82<=$I$7,$I$6,0)+IF(Control!J82=$I$7+1,$I$8,0),0)","v":0},{"$f":"IF(C82>0,ROUND(D82+E82-F82,8),0)","v":0},0,{"$f":"IF(H82>0,SUM(F83:F94),0)","v":0},{"$f":"IF(H82>I82,H82-I82,0)","v":0},0,{"$f":"IF(H82>0,SUM(E95:$E$107),0)","v":0},{"$f":"Control!K82","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J83<=$I$7+IF($I$8>0,1,0),EOMONTH(C82,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D83>0,Control!J83<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D83*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J83<=$I$7,$I$6,0)+IF(Control!J83=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H83>0,SUM(E96:$E$107),0)","v":0},{"$f":"Control!K83","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J84<=$I$7+IF($I$8>0,1,0),EOMONTH(C83,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D84>0,Control!J84<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D84*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J84<=$I$7,$I$6,0)+IF(Control!J84=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,{"$f":"SUM(E85:E96)","v":0},{"$f":"IF(H84>0,SUM(E97:$E$107),0)","v":0},{"$f":"Control!K84","v":0}]
[{"$f":"IF(C85<>0,0,\"blank\")","v":"blank"},null,{"$f":"IF($I$10>0,IF(Control!J85<=$I$7+IF($I$8>0,1,0),EOMONTH(C84,1),0),0)","v":"00:00:00"},{"$f":"IF(AND(G84>0,C85>0),G84,0)","v":0},{"$f":"IF(AND(D85>0,Control!J85<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D85*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J85<=$I$7,$I$6,0)+IF(Control!J85=$I$7+1,$I$8,0),0)","v":0},0,{"$f":"ROUND(H84-F85,2)","v":0},0,0,0,{"$f":"IF(H85>0,SUM(E98:$E$107),0)","v":0},{"$f":"Control!K85","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J86<=$I$7+IF($I$8>0,1,0),EOMONTH(C85,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D86>0,Control!J86<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D86*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J86<=$I$7,$I$6,0)+IF(Control!J86=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H86>0,SUM(E99:$E$107),0)","v":0},{"$f":"Control!K86","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J87<=$I$7+IF($I$8>0,1,0),EOMONTH(C86,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D87>0,Control!J87<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D87*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J87<=$I$7,$I$6,0)+IF(Control!J87=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H87>0,SUM(E100:$E$107),0)","v":0},{"$f":"Control!K87","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J88<=$I$7+IF($I$8>0,1,0),EOMONTH(C87,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D88>0,Control!J88<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D88*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J88<=$I$7,$I$6,0)+IF(Control!J88=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H88>0,SUM(E101:$E$107),0)","v":0},{"$f":"Control!K88","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J89<=$I$7+IF($I$8>0,1,0),EOMONTH(C88,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D89>0,Control!J89<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D89*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J89<=$I$7,$I$6,0)+IF(Control!J89=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H89>0,SUM(E102:$E$107),0)","v":0},{"$f":"Control!K89","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J90<=$I$7+IF($I$8>0,1,0),EOMONTH(C89,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D90>0,Control!J90<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D90*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J90<=$I$7,$I$6,0)+IF(Control!J90=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H90>0,SUM(E103:$E$107),0)","v":0},{"$f":"Control!K90","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J91<=$I$7+IF($I$8>0,1,0),EOMONTH(C90,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D91>0,Control!J91<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D91*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J91<=$I$7,$I$6,0)+IF(Control!J91=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H91>0,SUM(E104:$E$107),0)","v":0},{"$f":"Control!K91","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J92<=$I$7+IF($I$8>0,1,0),EOMONTH(C91,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D92>0,Control!J92<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D92*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J92<=$I$7,$I$6,0)+IF(Control!J92=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H92>0,SUM(E105:$E$107),0)","v":0},{"$f":"Control!K92","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J93<=$I$7+IF($I$8>0,1,0),EOMONTH(C92,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D93>0,Control!J93<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D93*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J93<=$I$7,$I$6,0)+IF(Control!J93=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H93>0,SUM(E106:$E$107),0)","v":0},{"$f":"Control!K93","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J94<=$I$7+IF($I$8>0,1,0),EOMONTH(C93,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D94>0,Control!J94<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D94*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J94<=$I$7,$I$6,0)+IF(Control!J94=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,{"$f":"IF(H94>0,SUM(E107:$E$107),0)","v":0},{"$f":"Control!K94","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J95<=$I$7+IF($I$8>0,1,0),EOMONTH(C94,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D95>0,Control!J95<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D95*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J95<=$I$7,$I$6,0)+IF(Control!J95=$I$7+1,$I$8,0),0)","v":0},0,0,0,0,0,null,{"$f":"Control!K95","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J96<=$I$7+IF($I$8>0,1,0),EOMONTH(C95,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D96>0,Control!J96<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D96*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J96<=$I$7,$I$6,0)+IF(Control!J96=$I$7+1,$I$8,0),0)","v":0},0,0,{"$f":"IF(H96>0,SUM(F97:F107),0)","v":0},0,{"$f":"SUM(E97:E107)","v":0},null,{"$f":"Control!K96","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J97<=$I$7+IF($I$8>0,1,0),EOMONTH(C96,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D97>0,Control!J97<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D97*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J97<=$I$7,$I$6,0)+IF(Control!J97=$I$7+1,$I$8,0),0)","v":0},0,0,{"$f":"IF(H97>0,SUM(F98:F107),0)","v":0},0,{"$f":"SUM(E98:E107)","v":0},null,{"$f":"Control!K97","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J98<=$I$7+IF($I$8>0,1,0),EOMONTH(C97,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D98>0,Control!J98<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D98*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J98<=$I$7,$I$6,0)+IF(Control!J98=$I$7+1,$I$8,0),0)","v":0},0,0,{"$f":"IF(H98>0,SUM(F99:F107),0)","v":0},0,{"$f":"SUM(E99:E107)","v":0},null,{"$f":"Control!K98","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J99<=$I$7+IF($I$8>0,1,0),EOMONTH(C98,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D99>0,Control!J99<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D99*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J99<=$I$7,$I$6,0)+IF(Control!J99=$I$7+1,$I$8,0),0)","v":0},0,0,{"$f":"IF(H99>0,SUM(F100:F107),0)","v":0},0,{"$f":"SUM(E100:E107)","v":0},null,{"$f":"Control!K99","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J100<=$I$7+IF($I$8>0,1,0),EOMONTH(C99,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D100>0,Control!J100<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D100*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J100<=$I$7,$I$6,0)+IF(Control!J100=$I$7+1,$I$8,0),0)","v":0},0,0,{"$f":"IF(H100>0,SUM(F101:F107),0)","v":0},0,{"$f":"SUM(E101:E107)","v":0},null,{"$f":"Control!K100","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J101<=$I$7+IF($I$8>0,1,0),EOMONTH(C100,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D101>0,Control!J101<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D101*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J101<=$I$7,$I$6,0)+IF(Control!J101=$I$7+1,$I$8,0),0)","v":0},0,0,{"$f":"IF(H101>0,SUM(F102:F107),0)","v":0},0,{"$f":"SUM(E102:E107)","v":0},null,{"$f":"Control!K101","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J102<=$I$7+IF($I$8>0,1,0),EOMONTH(C101,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D102>0,Control!J102<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D102*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J102<=$I$7,$I$6,0)+IF(Control!J102=$I$7+1,$I$8,0),0)","v":0},0,0,{"$f":"IF(H102>0,SUM(F103:F107),0)","v":0},0,{"$f":"SUM(E103:E107)","v":0},null,{"$f":"Control!K102","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J103<=$I$7+IF($I$8>0,1,0),EOMONTH(C102,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D103>0,Control!J103<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D103*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J103<=$I$7,$I$6,0)+IF(Control!J103=$I$7+1,$I$8,0),0)","v":0},0,0,{"$f":"IF(H103>0,SUM(F104:F107),0)","v":0},0,{"$f":"SUM(E104:E107)","v":0},null,{"$f":"Control!K103","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J104<=$I$7+IF($I$8>0,1,0),EOMONTH(C103,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D104>0,Control!J104<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D104*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J104<=$I$7,$I$6,0)+IF(Control!J104=$I$7+1,$I$8,0),0)","v":0},0,0,{"$f":"IF(H104>0,SUM(F105:F107),0)","v":0},0,{"$f":"SUM(E105:E107)","v":0},null,{"$f":"Control!K104","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J105<=$I$7+IF($I$8>0,1,0),EOMONTH(C104,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D105>0,Control!J105<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D105*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J105<=$I$7,$I$6,0)+IF(Control!J105=$I$7+1,$I$8,0),0)","v":0},0,0,{"$f":"IF(H105>0,SUM(F106:F107),0)","v":0},0,{"$f":"SUM(E106:E107)","v":0},null,{"$f":"Control!K105","v":0}]
["blank",null,{"$f":"IF($I$10>0,IF(Control!J106<=$I$7+IF($I$8>0,1,0),EOMONTH(C105,1),0),0)","v":"00:00:00"},0,{"$f":"IF(AND(D106>0,Control!J106<=$I$7+IF(AND($I$8>0,$C$11=\"On Commencement\"),1,0)),D106*$E$13,0)","v":0},{"$f":"IF($I$10>0,IF(Control!J106<=$I$7,$I$6,0)+IF(Control!J106=$I$7+1,$I$8,0),0)","v":0},0,0,{"$f":"IF(H106>0,SUM(F107:F107),0)","v":0},0,{"$f":"SUM(E107:E107)","v":0},null,{"$f":"Control!K106","v":0}]
["blank",null,null,null,null,null,null,0]
[null,null,"TOTALS",{"$f":"I5","v":0},{"$f":"SUM(E18:E107)","v":0},{"$f":"SUM(F18:F107)","v":0},{"$f":"\"0 \"","v":"0 "},null,null,null,null,null,{"$f":"SUM(M18:M107)","v":0}]
[{"$f":"\"blank\"","v":"blank"}]

{"sheet":"Journal Worksheet","index":2,"n_rows":47,"n_cols":15,"rows_kept":47,"cut":false,"hidden":false,"merged":[[40,1,40,3],[5,1,5,2],[27,1,27,3],[6,1,6,2],[13,11,13,13],[27,11,27,13],[40,11,40,13],[40,6,40,8],[13,6,13,8],[27,6,27,8],[11,1,11,2],[12,1,12,2]]}
[]
[null,"Hire Purchase Journal Worksheet",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Hire Purchase'!K1","v":"Client Name"}]
[null,{"$f":"'Hire Purchase'!C2","v":"Regular Monthly Repayments"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Prepared by \",'Hire Purchase'!K2)","v":"Prepared by Preparer Name"}]
[]
[null,{"$f":"CONCATENATE(\"Acquisition Dated \",IF('Hire Purchase'!I10>0,TEXT('Hire Purchase'!I10,\"dd/mm/yyyy\"),\"\"))","v":"Acquisition Dated "},null,"Dr","Cr",null,{"$f":"IF('Hire Purchase'!I10<>\"\",CONCATENATE(\"Year Ended 30 June \",IF(MONTH('Hire Purchase'!I10)<=6,YEAR('Hire Purchase'!I10),YEAR('Hire Purchase'!I10)+1)),\"\")","v":""},"Schedule","Ledger","Journal",null,{"$f":"IF('Hire Purchase'!I10<>\"\",CONCATENATE(\"Year Ended 30 June \",IF(MONTH('Hire Purchase'!I10)<=6,YEAR('Hire Purchase'!I10)+1,YEAR('Hire Purchase'!I10)+2)),\"\")","v":""},"Schedule","Ledger","Journal"]
[null,{"$f":"CONCATENATE(\"Cost - \",'Hire Purchase'!C8)","v":"Cost - "},null,null,null,null,"Hire purchase charges amortised",{"$f":"'Hire Purchase'!L6","v":0},null,{"$f":"H6-I6","v":0},null,"Hire purchase charges amortised",{"$f":"'Hire Purchase'!L7","v":0},null,{"$f":"M6-N6","v":0}]
[null,"Deposit amount and source   (if applicable)",null,null,null,null,"Current liability",{"$f":"IFERROR(-VLOOKUP(EOMONTH(YearEnd,0),HpSchedule,7,FALSE),0)","v":0},null,{"$f":"H7-I7","v":0},null,"Current liability",{"$f":"IFERROR(-VLOOKUP(EOMONTH(YearEnd,12),HpSchedule,7,FALSE),0)","v":0},null,{"$f":"M7-N7","v":0}]
[null,"Liability","Current",null,{"$f":"IF('Hire Purchase'!I10>0,INDEX('Hire Purchase'!I18:I1048576, MATCH(TRUE, INDEX('Hire Purchase'!I18:I1048576<>0, 0), 0)),0)","v":0},null,"Unexpired current interest",{"$f":"IFERROR(VLOOKUP(EOMONTH(YearEnd,0),HpSchedule,9,FALSE),0)","v":0},null,{"$f":"H8-I8","v":0},null,"Unexpired current interest",{"$f":"IFERROR(VLOOKUP(EOMONTH(YearEnd,12),HpSchedule,9,FALSE),0)","v":0},null,{"$f":"M8-N8","v":0}]
[null,null,"Non-current",null,{"$f":"IF('Hire Purchase'!I10>0,INDEX('Hire Purchase'!J18:J1048576, MATCH(TRUE, INDEX('Hire Purchase'!J18:J1048576<>0, 0), 0)),0)+IF('Hire Purchase'!C11=\"On Commencement\",'Hire Purchase'!I6,0)","v":0},null,"Non-current liability",{"$f":"IFERROR(-VLOOKUP(EOMONTH(YearEnd,0),HpSchedule,8,FALSE),0)","v":0},null,0,null,"Non-current liability",{"$f":"IFERROR(-VLOOKUP(EOMONTH(YearEnd,12),HpSchedule,8,FALSE),0)","v":0},null,0]
[null,"Unexpired interest","Current",{"$f":"IF('Hire Purchase'!I10>0,INDEX('Hire Purchase'!K18:K1048576, MATCH(TRUE, INDEX('Hire Purchase'!K18:K1048576<>0, 0), 0)),0)","v":0},null,null,"Unexpired non-current interest",{"$f":"IFERROR(VLOOKUP(EOMONTH(YearEnd,0),HpSchedule,10,FALSE),0)","v":0},null,0,null,"Unexpired non-current interest",{"$f":"IFERROR(VLOOKUP(EOMONTH(YearEnd,12),HpSchedule,10,FALSE),0)","v":0},null,0]
[null,null,"Non-current",{"$f":"IF('Hire Purchase'!I10>0,INDEX('Hire Purchase'!L18:L1048576, MATCH(TRUE, INDEX('Hire Purchase'!L18:L1048576<>0, 0), 0)),0)","v":0},null,null,"Borrowing costs amortised",{"$f":"'Hire Purchase'!M6","v":0},null,0,null,"Borrowing costs amortised",{"$f":"'Hire Purchase'!M7","v":0},null,0]
[null,"Borrowing costs",null,null,{"$f":"'Hire Purchase'!M14","v":0},null,"Borrowing costs ",{"$f":"'Hire Purchase'!$I$9","v":0},null,0,null,"Borrowing costs ",{"$f":"'Hire Purchase'!$I$9","v":0},null,0]
[null,"Unexpired borrowing costs",null,{"$f":"E12","v":0},null,null,"Borrowing costs written off",{"$f":"-H11","v":0},null,0,null,"Borrowing costs written off",{"$f":"H13-M11","v":0},null,0]
[null,null,null,{"$f":"ROUND(SUM(D6:D13),2)","v":0},{"$f":"ROUND(SUM(E6:E13),2)","v":0},null,"Describe where to post any unreconciled balance",null,null,{"$f":"SUM(J6:J13)","v":0},null,"Describe where to post any unreconciled balance",null,null,{"$f":"SUM(O6:O13)","v":0}]
[null,null,null,{"$f":"IF(D14<>E14,\"Out of balance\",\"\")","v":""},{"$f":"IF(D14<>E14,D14-E14,\"\")","v":""}]
[]
[]
[]
[null,{"$f":"IF('Hire Purchase'!I10<>\"\",CONCATENATE(\"Year Ended 30 June \",IF(MONTH('Hire Purchase'!I10)<=6,YEAR('Hire Purchase'!I10)+2,YEAR('Hire Purchase'!I10)+3)),\"\")","v":""},"Schedule","Ledger","Journal",null,{"$f":"IF('Hire Purchase'!I10<>\"\",CONCATENATE(\"Year Ended 30 June \",IF(MONTH('Hire Purchase'!I10)<=6,YEAR('Hire Purchase'!I10)+3,YEAR('Hire Purchase'!I10)+4)),\"\")","v":""},"Schedule","Ledger","Journal",null,{"$f":"IF('Hire Purchase'!I10<>\"\",CONCATENATE(\"Year Ended 30 June \",IF(MONTH('Hire Purchase'!I10)<=6,YEAR('Hire Purchase'!I10)+4,YEAR('Hire Purchase'!I10)+5)),\"\")","v":""},"Schedule","Ledger","Journal"]
[null,"Hire purchase charges amortised",{"$f":"'Hire Purchase'!L8","v":0},null,{"$f":"C20-D20","v":0},null,"Hire purchase charges amortised",{"$f":"'Hire Purchase'!L9","v":0},null,{"$f":"H20-I20","v":0},null,"Hire purchase charges amortised",{"$f":"'Hire Purchase'!L10","v":0},null,{"$f":"M20-N20","v":0}]
[null,"Current liability",{"$f":"IFERROR(-VLOOKUP(EOMONTH(YearEnd,24),HpSchedule,7,FALSE),0)","v":0},null,{"$f":"C21-D21","v":0},null,"Current liability",{"$f":"IFERROR(-VLOOKUP(EOMONTH(YearEnd,36),HpSchedule,7,FALSE),0)","v":0},null,{"$f":"H21-I21","v":0},null,"Current liability",{"$f":"IFERROR(-VLOOKUP(EOMONTH(YearEnd,48),HpSchedule,7,FALSE),0)","v":0},null,{"$f":"M21-N21","v":0}]
[null,"Unexpired current interest",{"$f":"IFERROR(VLOOKUP(EOMONTH(YearEnd,24),HpSchedule,9,FALSE),0)","v":0},null,{"$f":"C22-D22","v":0},null,"Unexpired current interest",{"$f":"IFERROR(VLOOKUP(EOMONTH(YearEnd,36),HpSchedule,9,FALSE),0)","v":0},null,{"$f":"H22-I22","v":0},null,"Unexpired current interest",{"$f":"IFERROR(VLOOKUP(EOMONTH(YearEnd,48),HpSchedule,9,FALSE),0)","v":0},null,{"$f":"M22-N22","v":0}]
[null,"Non-current liability",{"$f":"IFERROR(-VLOOKUP(EOMONTH(YearEnd,24),HpSchedule,8,FALSE),0)","v":0},null,0,null,"Non-current liability",{"$f":"IFERROR(-VLOOKUP(EOMONTH(YearEnd,36),HpSchedule,8,FALSE),0)","v":0},null,0,null,"Non-current liability",{"$f":"IFERROR(-VLOOKUP(EOMONTH(YearEnd,48),HpSchedule,8,FALSE),0)","v":0},null,0]
[null,"Unexpired non-current interest",{"$f":"IFERROR(VLOOKUP(EOMONTH(YearEnd,24),HpSchedule,10,FALSE),0)","v":0},null,0,null,"Unexpired non-current interest",{"$f":"IFERROR(VLOOKUP(EOMONTH(YearEnd,36),HpSchedule,10,FALSE),0)","v":0},null,0,null,"Unexpired non-current interest",{"$f":"IFERROR(VLOOKUP(EOMONTH(YearEnd,48),HpSchedule,10,FALSE),0)","v":0},null,0]
[null,"Borrowing costs amortised",{"$f":"'Hire Purchase'!M8","v":0},null,0,null,"Borrowing costs amortised",{"$f":"'Hire Purchase'!M9","v":0},null,0,null,"Borrowing costs amortised",{"$f":"'Hire Purchase'!M10","v":0},null,0]
[null,"Borrowing costs ",{"$f":"'Hire Purchase'!$I$9","v":0},null,0,null,"Borrowing costs ",{"$f":"'Hire Purchase'!$I$9","v":0},null,0,null,"Borrowing costs ",{"$f":"'Hire Purchase'!$I$9","v":0},null,0]
[null,"Borrowing costs written off",{"$f":"M13-C25","v":0},null,0,null,"Borrowing costs written off",{"$f":"C27-H25","v":0},null,0,null,"Borrowing costs written off",{"$f":"H27-M25","v":0},null,0]
[null,"Describe where to post any unreconciled balance",null,null,{"$f":"SUM(E20:E27)","v":0},null,"Describe where to post any unreconciled balance",null,null,{"$f":"SUM(J20:J27)","v":0},null,"Describe where to post any unreconciled balance",null,null,{"$f":"SUM(O20:O27)","v":0}]
[]
[]
[]
[null,{"$f":"IF('Hire Purchase'!I10<>\"\",CONCATENATE(\"Year Ended 30 June \",IF(MONTH('Hire Purchase'!I10)<=6,YEAR('Hire Purchase'!I10)+5,YEAR('Hire Purchase'!I10)+6)),\"\")","v":""},"Schedule","Ledger","Journal",null,{"$f":"IF('Hire Purchase'!I10<>\"\",CONCATENATE(\"Year Ended 30 June \",IF(MONTH('Hire Purchase'!I10)<=6,YEAR('Hire Purchase'!I10)+6,YEAR('Hire Purchase'!I10)+7)),\"\")","v":""},"Schedule","Ledger","Journal",null,{"$f":"IF('Hire Purchase'!I10<>\"\",CONCATENATE(\"Year Ended 30 June \",IF(MONTH('Hire Purchase'!I10)<=6,YEAR('Hire Purchase'!I10)+7,YEAR('Hire Purchase'!I10)+8)),\"\")","v":""},"Schedule","Ledger","Journal"]
[null,"Hire purchase charges amortised",{"$f":"'Hire Purchase'!L11","v":0},null,{"$f":"C33-D33","v":0},null,"Hire purchase charges amortised",{"$f":"'Hire Purchase'!L12","v":0},null,{"$f":"H33-I33","v":0},null,"Hire purchase charges amortised",{"$f":"'Hire Purchase'!L13","v":0},null,{"$f":"M33-N33","v":0}]
[null,"Current liability",{"$f":"IFERROR(-VLOOKUP(EOMONTH(YearEnd,60),HpSchedule,7,FALSE),0)","v":0},null,{"$f":"C34-D34","v":0},null,"Current liability",{"$f":"IFERROR(-VLOOKUP(EOMONTH(YearEnd,72),HpSchedule,7,FALSE),0)","v":0},null,{"$f":"H34-I34","v":0},null,"Current liability",{"$f":"IFERROR(-VLOOKUP(EOMONTH(YearEnd,84),HpSchedule,7,FALSE),0)","v":0},null,{"$f":"M34-N34","v":0}]
[null,"Unexpired current interest",{"$f":"IFERROR(VLOOKUP(EOMONTH(YearEnd,60),HpSchedule,9,FALSE),0)","v":0},null,{"$f":"C35-D35","v":0},null,"Unexpired current interest",{"$f":"IFERROR(VLOOKUP(EOMONTH(YearEnd,72),HpSchedule,9,FALSE),0)","v":0},null,{"$f":"H35-I35","v":0},null,"Unexpired current interest",{"$f":"IFERROR(VLOOKUP(EOMONTH(YearEnd,84),HpSchedule,9,FALSE),0)","v":0},null,{"$f":"M35-N35","v":0}]
[null,"Non-current liability",{"$f":"IFERROR(-VLOOKUP(EOMONTH(YearEnd,60),HpSchedule,8,FALSE),0)","v":0},null,0,null,"Non-current liability",{"$f":"IFERROR(-VLOOKUP(EOMONTH(YearEnd,72),HpSchedule,8,FALSE),0)","v":0},null,0,null,"Non-current liability",{"$f":"IFERROR(-VLOOKUP(EOMONTH(YearEnd,84),HpSchedule,8,FALSE),0)","v":0},null,0]
[null,"Unexpired non-current interest",{"$f":"IFERROR(VLOOKUP(EOMONTH(YearEnd,60),HpSchedule,10,FALSE),0)","v":0},null,0,null,"Unexpired non-current interest",{"$f":"IFERROR(VLOOKUP(EOMONTH(YearEnd,72),HpSchedule,10,FALSE),0)","v":0},null,0,null,"Unexpired non-current interest",{"$f":"IFERROR(VLOOKUP(EOMONTH(YearEnd,84),HpSchedule,10,FALSE),0)","v":0},null,0]
[null,"Borrowing costs amortised",{"$f":"'Hire Purchase'!M11","v":0},null,0,null,"Borrowing costs amortised",{"$f":"'Hire Purchase'!M12","v":0},null,0,null,"Borrowing costs amortised",{"$f":"'Hire Purchase'!M13","v":0},null,0]
[null,"Borrowing costs ",{"$f":"'Hire Purchase'!$I$9","v":0},null,0,null,"Borrowing costs ",{"$f":"'Hire Purchase'!$I$9","v":0},null,0,null,"Borrowing costs ",{"$f":"'Hire Purchase'!$I$9","v":0},null,0]
[null,"Borrowing costs written off",{"$f":"M27-C38","v":0},null,0,null,"Borrowing costs written off",{"$f":"C40-H38","v":0},null,0,null,"Borrowing costs written off",{"$f":"H40-M38","v":0},null,0]
[null,"Describe where to post any unreconciled balance",null,null,{"$f":"SUM(E33:E40)","v":0},null,"Describe where to post any unreconciled balance",null,null,{"$f":"SUM(J33:J40)","v":0},null,"Describe where to post any unreconciled balance",null,null,{"$f":"SUM(O33:O40)","v":0}]
[]
[]
[]
[null,"Full Reconciliation  (all years)","Schedule","Journals","Variance"]
[null,"Hire purchase charges",{"$f":"'Hire Purchase'!E108","v":0},{"$f":"H6+M6+C20+H20+M20+C33+H33+M33","v":0},{"$f":"C46-D46","v":0}]
[null,"Borrowing costs",{"$f":"'Hire Purchase'!M108","v":0},{"$f":"H11+M11+C25+H25+M25+C38+H38+M38","v":0},{"$f":"C47-D47","v":0}]

{"sheet":"Sheet1","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}