{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Hire Purchase"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":15,"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":"Hire Purchase","index":0,"n_rows":205,"n_cols":26,"rows_kept":205,"cut":false,"hidden":false,"merged":[[0,16,1,25],[2,19,3,19],[6,7,6,8],[10,7,10,8],[8,7,8,8],[9,7,9,8],[5,21,5,22],[6,3,6,5],[5,3,5,5],[7,3,7,5],[0,11,0,13],[1,11,1,13],[4,11,5,13],[17,11,17,12],[17,8,17,10],[17,3,17,7],[16,7,16,10],[7,7,7,8],[10,3,10,5],[13,3,13,4],[12,3,12,4],[8,3,8,5],[9,3,9,5],[13,7,14,9],[11,7,11,8]]}
[null,null,null,"Hire Purchase Schedule - Standard Repayments - Fortnightly",null,null,null,null,null,null,null,"Client Name",null,null,null,null,"HIDE"]
[null,null,null,"Loan Commencing During the Year Ended 30 June 2016",null,null,null,null,null,null,null,"Preparer Name"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Financial Year Summary",null,null,null,null,"Borrowing Expenses for Write-Off",null,null,100,null,null,null,null,1,5]
[null,null,null,"Lender",null,null,null,null,null,null,null,null,null,null,null,null,"Borrowing Expenses Max Period",null,null,{"$f":"26*5","v":130},null,"Actual Month",null,{"$f":"MONTH(J12)","v":1},2,4]
[null,null,null,null,null,null,null,"Amount Borrowed",null,null,null,"Year","Interest","Borrowing",null,null,"Maximum Years for Write-Off",null,null,{"$f":"MIN(J9/26,5)","v":0},null,"Year","From","To",3,3]
[null,null,null,"Asset Acquired",null,null,null,"Fortnightly Repayments",null,null,null,{"$f":"IF(J12>0,IF(MONTH(J12)<=6,YEAR(J12),YEAR(J12)+1),0)","v":0},{"$f":"ROUND(SUMIF(Dates,\"<\"&W9,Interest),8)","v":0},{"$f":"ROUND(SUMIF(Dates,\"<\"&W9,BorrowingExpenses),8)","v":0},null,null,"End of First Year",null,{"$f":"IF($S$7<=6,6-$S$7+1,6+12-$S$7+1)","v":7},null,null,{"$f":"L8","v":0},{"$f":"J12","v":"00:00:00"},{"$f":"EOMONTH(J12,VLOOKUP(X6,Y5:Z16,2,FALSE))","v":"1900-06-30"},4,2]
[null,null,null,null,null,null,null,"Term (fortnights)",null,null,null,{"$f":"IF(M9>1,L8+1,0)","v":0},{"$f":"ROUND(SUMIF(Dates,\"<\"&W10,Interest)-M8,8)","v":0},{"$f":"ROUND(SUMIFS(BorrowingExpenses,Dates,\">\"&Year1,Dates,\"<\"&W10),8)","v":0},null,null,"End of Second Year",null,{"$f":"S8+12","v":19},null,null,0,{"$f":"X8+1","v":"1900-07-01"},{"$f":"EOMONTH(W9,11)","v":"1901-06-30"},5,1]
[null,null,null,"First Payment",null,null,null,"Residual",null,null,null,0,{"$f":"ROUND(SUMIF(Dates,\"<\"&W11,Interest)-M9-M8,8)","v":0},{"$f":"ROUND(SUMIFS(BorrowingExpenses,Dates,\">\"&Year2,Dates,\"<\"&W11),8)","v":0},null,null,"End of Third Year",null,31,null,null,0,{"$f":"X9+1","v":"1901-07-01"},{"$f":"EOMONTH(W10,11)","v":"1902-06-30"},6,0]
[null,null,null,"Please Select",null,null,null,"Borrowing Expenses",null,null,null,0,{"$f":"ROUND(SUMIF(Dates,\"<\"&W12,Interest)-M8-M9-M10,8)","v":0},{"$f":"ROUND(SUMIFS(BorrowingExpenses,Dates,\">\"&Year3,Dates,\"<\"&W12),8)","v":0},null,null,"End of Fourth Year",null,43,null,null,0,"1902-07-01","1903-06-30",7,11]
[null,null,null,null,null,null,null,"Date Commenced",null,null,null,0,{"$f":"ROUND(SUMIF(Dates,\"<\"&W13,Interest)-M8-M9-M10-M11,8)","v":0},{"$f":"ROUND(SUMIFS(BorrowingExpenses,Dates,\">\"&Year4,Dates,\"<\"&W13),8)","v":0},null,null,"End of Fifth Year",null,55,null,null,0,"1903-07-01","1904-06-30",8,10]
[null,null,null,"Interest Rate/Fortnight",null,{"$f":"IF(AND(J7>0,(J8*J9)+J10>J7),RATE(J9,J8,-J7,J10,IF(D11=\"On Commencement\",1,0)),0)","v":0},null,null,null,null,null,0,{"$f":"ROUND(SUMIF(Dates,\"<\"&W14,Interest)-M8-M9-M10-M11-M12,8)","v":0},{"$f":"ROUND(SUMIFS(BorrowingExpenses,Dates,\">\"&Year5,Dates,\"<\"&W14),8)","v":0},null,null,"End of Sixth Year",null,67,null,null,0,"1904-07-01","1905-06-30",9,9]
[null,null,null,"Effective Annual Rate",null,{"$f":"IF(F13>0,EFFECT(F13*26,26),0)","v":0},null,{"$f":"IF(AND(J7>0,J8>0,J9>0),IF((J8*J9)+J10<=J7,\"ERROR:   Monthly repayments plus any residual are less than or equal to the amount borrowed\",\"\"),\"\")","v":""},null,null,null,0,{"$f":"ROUND(SUMIF(Dates,\"<\"&W15,Interest)-M8-M9-M10-M11-M12-M13,8)","v":0},{"$f":"ROUND(SUMIFS(BorrowingExpenses,Dates,\">\"&Year6,Dates,\"<\"&W15),8)","v":0},null,null,"End of Seventh Year",null,79,null,null,0,"1905-07-01","1906-06-30",10,8]
[null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"ROUND(SUMIF(Dates,\"<\"&W16,Interest)-M8-M9-M10-M11-M12-M13-M14,8)","v":0},{"$f":"ROUND(SUMIFS(BorrowingExpenses,Dates,\">\"&Year7,Dates,\"<\"&W16),8)","v":0},null,null,"End of Eighth Year",null,91,null,null,0,"1906-07-01","1907-06-30",11,7]
[null,null,null,null,null,null,null,null,null,null,null,"Totals",{"$f":"SUM(M8:M15)","v":0},{"$f":"SUM(N8:N15)","v":0},null,null,"Total no of",null,null,null,null,null,{"$f":"X15+1","v":"1907-07-01"},"1908-06-30",12,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Payments"]
[null,null,null,"Amortisation",null,null,null,null,"Liability",null,null,"Unexpired Interest",null,"Borrowing",null,null,{"$f":"IF(J10>0,J9+1,J9)","v":0}]
[null,null,null,"Date","Opening Balance","Add\nInterest","Less Repaymts","Closing Balance","Account Balance","Current","Non\nCurrent","Current","Non\nCurrent","Fortnightly",null,null,"Payment No"]
[null,null,null,{"$f":"IF(J12>0,J12,0)","v":"00:00:00"},{"$f":"IF(J12>0,J7,0)","v":0},null,{"$f":"IF(AND(D20>0,$D$11=\"On Commencement\"),$J$8,0)","v":0},{"$f":"IF(D20>0,ROUND(E20+F20-G20,8),0)","v":0},{"$f":"IF(D20>0,($J$8*$J$9)+$J$10-G20,0)","v":0},{"$f":"IF(I20>0,SUM(G21:G46),0)","v":0},{"$f":"IF(I20>J20,I20-J20,0)","v":0},{"$f":"IF(I20>0,SUM(F21:F46),0)","v":0},{"$f":"IF(I20>0,MAX(SUM(F21:$F$203)-L20,0),0)","v":0},{"$f":"IF(AND(G20>0,J11<=100),J11,IF(G20>0,J11/MIN(J9,T6),0))","v":0},null,null,{"$f":"IF(G20>0,1,0)","v":0}]
[null,null,null,{"$f":"IF(AND($J$12>0,Q21<=$Q$18),D20+14,0)","v":"00:00:00"},{"$f":"IF(D21>0,H20,0)","v":0},{"$f":"IF(AND(E21>0,Q21<=$J$9+IF(AND($J$10>0,$D$11=\"On Commencement\"),1,0)),E21*$F$13,0)","v":0},{"$f":"IF(AND(D20>0,D21>0),$J$8,IF(AND(D21>0,D11=\"On Commencement\"),$J$8,0))","v":0},{"$f":"IF(D21>0,ROUND(E21+F21-G21,8),0)","v":0},{"$f":"IF(I20>0,I20-G21,IF(D21>0,(J8*J9)+J10-G21,0))","v":0},{"$f":"IF(I21>0,SUM(G22:G47),0)","v":0},{"$f":"IF(I21>J21,I21-J21,0)","v":0},{"$f":"IF(I21>0,SUM(F22:F47),0)","v":0},{"$f":"IF(I21>0,MAX(SUM(F22:$F$203)-L21,0),0)","v":0},{"$f":"IF(AND(D11=\"One Month From Commencement\",J11<=100),J11,IF(J11>N20,$J$11/MIN($J$9,$T$6),0))","v":0},null,null,{"$f":"Q20+1","v":1}]
[null,null,null,"00:00:00",{"$f":"IF(D22>0,H21,0)","v":0},0,{"$f":"IF(D21>0,$J$8,IF(AND(D22>0,$D$11=\"On Commencement\"),$J$8,0))","v":0},0,{"$f":"IF(J12>0,IF(I21>0,I21-G22,(J8*J9)+J10-G22),0)","v":0},0,0,0,{"$f":"IF(I22>0,MAX(SUM(F23:$F$203)-L22,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N21),$J$11/MIN($J$9,$T$6))","v":0},null,null,{"$f":"Q21+1","v":2}]
[null,null,null,"00:00:00",0,0,{"$f":"IF($J$12>0,IF(Q23<=$J$9,$J$8,0)+IF(Q23=$J$9+1,$J$10,0),0)","v":0},0,{"$f":"I22-G23","v":0},0,0,0,{"$f":"IF(I23>0,MAX(SUM(F24:$F$203)-L23,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N22),$J$11/MIN($J$9,$T$6))","v":0},null,null,3,null,null,null,{"$f":"IF(OR(D23<>0,E23<>0,F23<>0,G23<>0,H23<>0,I23<>0,J23<>0,K23<>0,L23<>0,M23<>0,N23<>0),0,\"blank\")","v":"blank"}]
[null,null,null,"00:00:00",0,0,0,0,{"$f":"I23-G24","v":0},0,0,0,{"$f":"IF(I24>0,MAX(SUM(F25:$F$203)-L24,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N23),$J$11/MIN($J$9,$T$6))","v":0},null,null,4,null,null,null,{"$f":"IF(OR(D24<>0,E24<>0,F24<>0,G24<>0,H24<>0,I24<>0,J24<>0,K24<>0,L24<>0,M24<>0,N24<>0),0,\"blank\")","v":"blank"}]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I25>0,MAX(SUM(F26:$F$203)-L25,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N24),$J$11/MIN($J$9,$T$6))","v":0},null,null,5,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I26>0,MAX(SUM(F27:$F$203)-L26,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N25),$J$11/MIN($J$9,$T$6))","v":0},null,null,6,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I27>0,MAX(SUM(F28:$F$203)-L27,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N26),$J$11/MIN($J$9,$T$6))","v":0},null,null,7,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I28>0,MAX(SUM(F29:$F$203)-L28,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N27),$J$11/MIN($J$9,$T$6))","v":0},null,null,8,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I29>0,MAX(SUM(F30:$F$203)-L29,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N28),$J$11/MIN($J$9,$T$6))","v":0},null,null,9,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I30>0,MAX(SUM(F31:$F$203)-L30,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N29),$J$11/MIN($J$9,$T$6))","v":0},null,null,10,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I31>0,MAX(SUM(F32:$F$203)-L31,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N30),$J$11/MIN($J$9,$T$6))","v":0},null,null,11,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I32>0,MAX(SUM(F33:$F$203)-L32,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N31),$J$11/MIN($J$9,$T$6))","v":0},null,null,12,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I33>0,MAX(SUM(F34:$F$203)-L33,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N32),$J$11/MIN($J$9,$T$6))","v":0},null,null,13,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I34>0,MAX(SUM(F35:$F$203)-L34,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N33),$J$11/MIN($J$9,$T$6))","v":0},null,null,14,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I35>0,MAX(SUM(F36:$F$203)-L35,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N34),$J$11/MIN($J$9,$T$6))","v":0},null,null,15,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I36>0,MAX(SUM(F37:$F$203)-L36,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N35),$J$11/MIN($J$9,$T$6))","v":0},null,null,16,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I37>0,MAX(SUM(F38:$F$203)-L37,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N36),$J$11/MIN($J$9,$T$6))","v":0},null,null,17,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I38>0,MAX(SUM(F39:$F$203)-L38,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N37),$J$11/MIN($J$9,$T$6))","v":0},null,null,18,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I39>0,MAX(SUM(F40:$F$203)-L39,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N38),$J$11/MIN($J$9,$T$6))","v":0},null,null,19,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I40>0,MAX(SUM(F41:$F$203)-L40,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N39),$J$11/MIN($J$9,$T$6))","v":0},null,null,20,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I41>0,MAX(SUM(F42:$F$203)-L41,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N40),$J$11/MIN($J$9,$T$6))","v":0},null,null,21,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I42>0,MAX(SUM(F43:$F$203)-L42,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N41),$J$11/MIN($J$9,$T$6))","v":0},null,null,22,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I43>0,MAX(SUM(F44:$F$203)-L43,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N42),$J$11/MIN($J$9,$T$6))","v":0},null,null,23,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I44>0,MAX(SUM(F45:$F$203)-L44,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N43),$J$11/MIN($J$9,$T$6))","v":0},null,null,24,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I45>0,MAX(SUM(F46:$F$203)-L45,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N44),$J$11/MIN($J$9,$T$6))","v":0},null,null,25,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I46>0,MAX(SUM(F47:$F$203)-L46,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N45),$J$11/MIN($J$9,$T$6))","v":0},null,null,26,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I47>0,MAX(SUM(F48:$F$203)-L47,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N46),$J$11/MIN($J$9,$T$6))","v":0},null,null,27,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I48>0,MAX(SUM(F49:$F$203)-L48,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N47),$J$11/MIN($J$9,$T$6))","v":0},null,null,28,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I49>0,MAX(SUM(F50:$F$203)-L49,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N48),$J$11/MIN($J$9,$T$6))","v":0},null,null,29,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I50>0,MAX(SUM(F51:$F$203)-L50,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N49),$J$11/MIN($J$9,$T$6))","v":0},null,null,30,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I51>0,MAX(SUM(F52:$F$203)-L51,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N50),$J$11/MIN($J$9,$T$6))","v":0},null,null,31,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I52>0,MAX(SUM(F53:$F$203)-L52,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N51),$J$11/MIN($J$9,$T$6))","v":0},null,null,32,null,null,null,"blank"]
[null,null,null,{"$f":"IF(AND($J$12>0,Q53<=$Q$18),D52+14,0)","v":"00:00:00"},0,{"$f":"IF(AND(E53>0,Q53<=$J$9+IF(AND($J$10>0,$D$11=\"On Commencement\"),1,0)),E53*$F$13,0)","v":0},0,0,0,0,0,0,{"$f":"IF(I53>0,MAX(SUM(F54:$F$203)-L53,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N52),$J$11/MIN($J$9,$T$6))","v":0},null,null,33,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I54>0,MAX(SUM(F55:$F$203)-L54,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N53),$J$11/MIN($J$9,$T$6))","v":0},null,null,34,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,{"$f":"IF($J$12>0,IF(Q55<=$J$9,$J$8,0)+IF(Q55=$J$9+1,$J$10,0),0)","v":0},0,0,0,0,0,{"$f":"IF(I55>0,MAX(SUM(F56:$F$203)-L55,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N54),$J$11/MIN($J$9,$T$6))","v":0},null,null,35,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I56>0,MAX(SUM(F57:$F$203)-L56,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N55),$J$11/MIN($J$9,$T$6))","v":0},null,null,36,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I57>0,MAX(SUM(F58:$F$203)-L57,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N56),$J$11/MIN($J$9,$T$6))","v":0},null,null,37,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I58>0,MAX(SUM(F59:$F$203)-L58,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N57),$J$11/MIN($J$9,$T$6))","v":0},null,null,38,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I59>0,MAX(SUM(F60:$F$203)-L59,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N58),$J$11/MIN($J$9,$T$6))","v":0},null,null,39,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I60>0,MAX(SUM(F61:$F$203)-L60,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N59),$J$11/MIN($J$9,$T$6))","v":0},null,null,40,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I61>0,MAX(SUM(F62:$F$203)-L61,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N60),$J$11/MIN($J$9,$T$6))","v":0},null,null,41,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I62>0,MAX(SUM(F63:$F$203)-L62,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N61),$J$11/MIN($J$9,$T$6))","v":0},null,null,42,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I63>0,MAX(SUM(F64:$F$203)-L63,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N62),$J$11/MIN($J$9,$T$6))","v":0},null,null,43,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I64>0,MAX(SUM(F65:$F$203)-L64,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N63),$J$11/MIN($J$9,$T$6))","v":0},null,null,44,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I65>0,MAX(SUM(F66:$F$203)-L65,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N64),$J$11/MIN($J$9,$T$6))","v":0},null,null,45,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I66>0,MAX(SUM(F67:$F$203)-L66,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N65),$J$11/MIN($J$9,$T$6))","v":0},null,null,46,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I67>0,MAX(SUM(F68:$F$203)-L67,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N66),$J$11/MIN($J$9,$T$6))","v":0},null,null,47,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I68>0,MAX(SUM(F69:$F$203)-L68,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N67),$J$11/MIN($J$9,$T$6))","v":0},null,null,48,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I69>0,MAX(SUM(F70:$F$203)-L69,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N68),$J$11/MIN($J$9,$T$6))","v":0},null,null,49,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I70>0,MAX(SUM(F71:$F$203)-L70,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N69),$J$11/MIN($J$9,$T$6))","v":0},null,null,50,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I71>0,MAX(SUM(F72:$F$203)-L71,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N70),$J$11/MIN($J$9,$T$6))","v":0},null,null,51,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I72>0,MAX(SUM(F73:$F$203)-L72,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N71),$J$11/MIN($J$9,$T$6))","v":0},null,null,52,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I73>0,MAX(SUM(F74:$F$203)-L73,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N72),$J$11/MIN($J$9,$T$6))","v":0},null,null,53,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I74>0,MAX(SUM(F75:$F$203)-L74,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N73),$J$11/MIN($J$9,$T$6))","v":0},null,null,54,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I75>0,MAX(SUM(F76:$F$203)-L75,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N74),$J$11/MIN($J$9,$T$6))","v":0},null,null,55,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I76>0,MAX(SUM(F77:$F$203)-L76,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N75),$J$11/MIN($J$9,$T$6))","v":0},null,null,56,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I77>0,MAX(SUM(F78:$F$203)-L77,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N76),$J$11/MIN($J$9,$T$6))","v":0},null,null,57,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I78>0,MAX(SUM(F79:$F$203)-L78,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N77),$J$11/MIN($J$9,$T$6))","v":0},null,null,58,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I79>0,MAX(SUM(F80:$F$203)-L79,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N78),$J$11/MIN($J$9,$T$6))","v":0},null,null,59,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I80>0,MAX(SUM(F81:$F$203)-L80,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N79),$J$11/MIN($J$9,$T$6))","v":0},null,null,60,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I81>0,MAX(SUM(F82:$F$203)-L81,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N80),$J$11/MIN($J$9,$T$6))","v":0},null,null,61,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I82>0,MAX(SUM(F83:$F$203)-L82,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N81),$J$11/MIN($J$9,$T$6))","v":0},null,null,62,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I83>0,MAX(SUM(F84:$F$203)-L83,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N82),$J$11/MIN($J$9,$T$6))","v":0},null,null,63,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I84>0,MAX(SUM(F85:$F$203)-L84,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N83),$J$11/MIN($J$9,$T$6))","v":0},null,null,64,null,null,null,"blank"]
[null,null,null,{"$f":"IF(AND($J$12>0,Q85<=$Q$18),D84+14,0)","v":"00:00:00"},0,{"$f":"IF(AND(E85>0,Q85<=$J$9+IF(AND($J$10>0,$D$11=\"On Commencement\"),1,0)),E85*$F$13,0)","v":0},0,{"$f":"IF(D85>0,ROUND(E85+F85-G85,8),0)","v":0},0,{"$f":"IF(I85>0,SUM(G86:G111),0)","v":0},0,{"$f":"IF(I85>0,SUM(F86:F111),0)","v":0},{"$f":"IF(I85>0,MAX(SUM(F86:$F$203)-L85,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N84),$J$11/MIN($J$9,$T$6))","v":0},null,null,65,null,null,null,"blank"]
[null,null,null,"00:00:00",{"$f":"IF(D86>0,H85,0)","v":0},0,0,0,{"$f":"I85-G86","v":0},0,{"$f":"IF(I86>J86,I86-J86,0)","v":0},0,{"$f":"IF(I86>0,MAX(SUM(F87:$F$203)-L86,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N85),$J$11/MIN($J$9,$T$6))","v":0},null,null,{"$f":"Q85+1","v":66},null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,{"$f":"IF($J$12>0,IF(Q87<=$J$9,$J$8,0)+IF(Q87=$J$9+1,$J$10,0),0)","v":0},0,0,0,0,0,{"$f":"IF(I87>0,MAX(SUM(F88:$F$203)-L87,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N86),$J$11/MIN($J$9,$T$6))","v":0},null,null,67,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I88>0,MAX(SUM(F89:$F$203)-L88,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N87),$J$11/MIN($J$9,$T$6))","v":0},null,null,68,null,null,null,{"$f":"IF(OR(D88<>0,E88<>0,F88<>0,G88<>0,H88<>0,I88<>0,J88<>0,K88<>0,L88<>0,M88<>0,N88<>0),0,\"blank\")","v":"blank"}]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I89>0,MAX(SUM(F90:$F$203)-L89,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N88),$J$11/MIN($J$9,$T$6))","v":0},null,null,69,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I90>0,MAX(SUM(F91:$F$203)-L90,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N89),$J$11/MIN($J$9,$T$6))","v":0},null,null,70,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I91>0,MAX(SUM(F92:$F$203)-L91,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N90),$J$11/MIN($J$9,$T$6))","v":0},null,null,71,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I92>0,MAX(SUM(F93:$F$203)-L92,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N91),$J$11/MIN($J$9,$T$6))","v":0},null,null,72,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I93>0,MAX(SUM(F94:$F$203)-L93,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N92),$J$11/MIN($J$9,$T$6))","v":0},null,null,73,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I94>0,MAX(SUM(F95:$F$203)-L94,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N93),$J$11/MIN($J$9,$T$6))","v":0},null,null,74,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I95>0,MAX(SUM(F96:$F$203)-L95,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N94),$J$11/MIN($J$9,$T$6))","v":0},null,null,75,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I96>0,MAX(SUM(F97:$F$203)-L96,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N95),$J$11/MIN($J$9,$T$6))","v":0},null,null,76,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I97>0,MAX(SUM(F98:$F$203)-L97,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N96),$J$11/MIN($J$9,$T$6))","v":0},null,null,77,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I98>0,MAX(SUM(F99:$F$203)-L98,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N97),$J$11/MIN($J$9,$T$6))","v":0},null,null,78,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,{"$f":"I98-G99","v":0},0,0,0,{"$f":"IF(I99>0,MAX(SUM(F100:$F$203)-L99,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N98),$J$11/MIN($J$9,$T$6))","v":0},null,null,79,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I100>0,MAX(SUM(F101:$F$203)-L100,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N99),$J$11/MIN($J$9,$T$6))","v":0},null,null,80,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I101>0,MAX(SUM(F102:$F$203)-L101,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N100),$J$11/MIN($J$9,$T$6))","v":0},null,null,81,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I102>0,MAX(SUM(F103:$F$203)-L102,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N101),$J$11/MIN($J$9,$T$6))","v":0},null,null,82,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I103>0,MAX(SUM(F104:$F$203)-L103,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N102),$J$11/MIN($J$9,$T$6))","v":0},null,null,83,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I104>0,MAX(SUM(F105:$F$203)-L104,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N103),$J$11/MIN($J$9,$T$6))","v":0},null,null,84,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I105>0,MAX(SUM(F106:$F$203)-L105,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N104),$J$11/MIN($J$9,$T$6))","v":0},null,null,85,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I106>0,MAX(SUM(F107:$F$203)-L106,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N105),$J$11/MIN($J$9,$T$6))","v":0},null,null,86,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I107>0,MAX(SUM(F108:$F$203)-L107,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N106),$J$11/MIN($J$9,$T$6))","v":0},null,null,87,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I108>0,MAX(SUM(F109:$F$203)-L108,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N107),$J$11/MIN($J$9,$T$6))","v":0},null,null,88,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I109>0,MAX(SUM(F110:$F$203)-L109,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N108),$J$11/MIN($J$9,$T$6))","v":0},null,null,{"$f":"Q108+1","v":89},null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I110>0,MAX(SUM(F111:$F$203)-L110,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N109),$J$11/MIN($J$9,$T$6))","v":0},null,null,{"$f":"Q109+1","v":90},null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I111>0,MAX(SUM(F112:$F$203)-L111,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N110),$J$11/MIN($J$9,$T$6))","v":0},null,null,91,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I112>0,MAX(SUM(F113:$F$203)-L112,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N111),$J$11/MIN($J$9,$T$6))","v":0},null,null,92,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I113>0,MAX(SUM(F114:$F$203)-L113,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N112),$J$11/MIN($J$9,$T$6))","v":0},null,null,93,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I114>0,MAX(SUM(F115:$F$203)-L114,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N113),$J$11/MIN($J$9,$T$6))","v":0},null,null,94,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I115>0,MAX(SUM(F116:$F$203)-L115,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N114),$J$11/MIN($J$9,$T$6))","v":0},null,null,95,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I116>0,MAX(SUM(F117:$F$203)-L116,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N115),$J$11/MIN($J$9,$T$6))","v":0},null,null,96,null,null,null,"blank"]
[null,null,null,{"$f":"IF(AND($J$12>0,Q117<=$Q$18),D116+14,0)","v":"00:00:00"},0,{"$f":"IF(AND(E117>0,Q117<=$J$9+IF(AND($J$10>0,$D$11=\"On Commencement\"),1,0)),E117*$F$13,0)","v":0},0,0,0,0,0,0,{"$f":"IF(I117>0,MAX(SUM(F118:$F$203)-L117,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N116),$J$11/MIN($J$9,$T$6))","v":0},null,null,97,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I118>0,MAX(SUM(F119:$F$203)-L118,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N117),$J$11/MIN($J$9,$T$6))","v":0},null,null,98,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,{"$f":"IF($J$12>0,IF(Q119<=$J$9,$J$8,0)+IF(Q119=$J$9+1,$J$10,0),0)","v":0},0,0,0,0,0,{"$f":"IF(I119>0,MAX(SUM(F120:$F$203)-L119,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N118),$J$11/MIN($J$9,$T$6))","v":0},null,null,99,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I120>0,MAX(SUM(F121:$F$203)-L120,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N119),$J$11/MIN($J$9,$T$6))","v":0},null,null,100,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I121>0,MAX(SUM(F122:$F$203)-L121,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N120),$J$11/MIN($J$9,$T$6))","v":0},null,null,101,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I122>0,MAX(SUM(F123:$F$203)-L122,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N121),$J$11/MIN($J$9,$T$6))","v":0},null,null,102,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I123>0,MAX(SUM(F124:$F$203)-L123,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N122),$J$11/MIN($J$9,$T$6))","v":0},null,null,103,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I124>0,MAX(SUM(F125:$F$203)-L124,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N123),$J$11/MIN($J$9,$T$6))","v":0},null,null,104,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I125>0,MAX(SUM(F126:$F$203)-L125,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N124),$J$11/MIN($J$9,$T$6))","v":0},null,null,105,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I126>0,MAX(SUM(F127:$F$203)-L126,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N125),$J$11/MIN($J$9,$T$6))","v":0},null,null,106,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I127>0,MAX(SUM(F128:$F$203)-L127,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N126),$J$11/MIN($J$9,$T$6))","v":0},null,null,107,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I128>0,MAX(SUM(F129:$F$203)-L128,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N127),$J$11/MIN($J$9,$T$6))","v":0},null,null,108,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I129>0,MAX(SUM(F130:$F$203)-L129,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N128),$J$11/MIN($J$9,$T$6))","v":0},null,null,109,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I130>0,MAX(SUM(F131:$F$203)-L130,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N129),$J$11/MIN($J$9,$T$6))","v":0},null,null,110,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I131>0,MAX(SUM(F132:$F$203)-L131,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N130),$J$11/MIN($J$9,$T$6))","v":0},null,null,111,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I132>0,MAX(SUM(F133:$F$203)-L132,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N131),$J$11/MIN($J$9,$T$6))","v":0},null,null,112,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I133>0,MAX(SUM(F134:$F$203)-L133,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N132),$J$11/MIN($J$9,$T$6))","v":0},null,null,113,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I134>0,MAX(SUM(F135:$F$203)-L134,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N133),$J$11/MIN($J$9,$T$6))","v":0},null,null,114,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I135>0,MAX(SUM(F136:$F$203)-L135,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N134),$J$11/MIN($J$9,$T$6))","v":0},null,null,115,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I136>0,MAX(SUM(F137:$F$203)-L136,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N135),$J$11/MIN($J$9,$T$6))","v":0},null,null,116,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I137>0,MAX(SUM(F138:$F$203)-L137,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N136),$J$11/MIN($J$9,$T$6))","v":0},null,null,117,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I138>0,MAX(SUM(F139:$F$203)-L138,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N137),$J$11/MIN($J$9,$T$6))","v":0},null,null,118,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I139>0,MAX(SUM(F140:$F$203)-L139,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N138),$J$11/MIN($J$9,$T$6))","v":0},null,null,119,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I140>0,MAX(SUM(F141:$F$203)-L140,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N139),$J$11/MIN($J$9,$T$6))","v":0},null,null,120,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I141>0,MAX(SUM(F142:$F$203)-L141,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N140),$J$11/MIN($J$9,$T$6))","v":0},null,null,121,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I142>0,MAX(SUM(F143:$F$203)-L142,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N141),$J$11/MIN($J$9,$T$6))","v":0},null,null,122,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I143>0,MAX(SUM(F144:$F$203)-L143,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N142),$J$11/MIN($J$9,$T$6))","v":0},null,null,123,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I144>0,MAX(SUM(F145:$F$203)-L144,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N143),$J$11/MIN($J$9,$T$6))","v":0},null,null,124,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I145>0,MAX(SUM(F146:$F$203)-L145,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N144),$J$11/MIN($J$9,$T$6))","v":0},null,null,125,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I146>0,MAX(SUM(F147:$F$203)-L146,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N145),$J$11/MIN($J$9,$T$6))","v":0},null,null,126,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I147>0,MAX(SUM(F148:$F$203)-L147,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N146),$J$11/MIN($J$9,$T$6))","v":0},null,null,127,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I148>0,MAX(SUM(F149:$F$203)-L148,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N147),$J$11/MIN($J$9,$T$6))","v":0},null,null,128,null,null,null,"blank"]
[null,null,null,{"$f":"IF(AND($J$12>0,Q149<=$Q$18),D148+14,0)","v":"00:00:00"},0,{"$f":"IF(AND(E149>0,Q149<=$J$9+IF(AND($J$10>0,$D$11=\"On Commencement\"),1,0)),E149*$F$13,0)","v":0},0,{"$f":"IF(D149>0,ROUND(E149+F149-G149,8),0)","v":0},0,{"$f":"IF(I149>0,SUM(G150:G175),0)","v":0},0,{"$f":"IF(I149>0,SUM(F150:F175),0)","v":0},{"$f":"IF(I149>0,MAX(SUM(F150:$F$203)-L149,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N148),$J$11/MIN($J$9,$T$6))","v":0},null,null,129,null,null,null,"blank"]
[null,null,null,"00:00:00",{"$f":"IF(D150>0,H149,0)","v":0},0,0,0,{"$f":"I149-G150","v":0},0,{"$f":"IF(I150>J150,I150-J150,0)","v":0},0,{"$f":"IF(I150>0,MAX(SUM(F151:$F$203)-L150,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N149),$J$11/MIN($J$9,$T$6))","v":0},null,null,130,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,{"$f":"IF($J$12>0,IF(Q151<=$J$9,$J$8,0)+IF(Q151=$J$9+1,$J$10,0),0)","v":0},0,0,0,0,0,{"$f":"IF(I151>0,MAX(SUM(F152:$F$203)-L151,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N150),$J$11/MIN($J$9,$T$6))","v":0},null,null,131,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I152>0,MAX(SUM(F153:$F$203)-L152,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N151),$J$11/MIN($J$9,$T$6))","v":0},null,null,132,null,null,null,{"$f":"IF(OR(D152<>0,E152<>0,F152<>0,G152<>0,H152<>0,I152<>0,J152<>0,K152<>0,L152<>0,M152<>0,N152<>0),0,\"blank\")","v":"blank"}]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I153>0,MAX(SUM(F154:$F$203)-L153,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N152),$J$11/MIN($J$9,$T$6))","v":0},null,null,133,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I154>0,MAX(SUM(F155:$F$203)-L154,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N153),$J$11/MIN($J$9,$T$6))","v":0},null,null,134,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I155>0,MAX(SUM(F156:$F$203)-L155,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N154),$J$11/MIN($J$9,$T$6))","v":0},null,null,135,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I156>0,MAX(SUM(F157:$F$203)-L156,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N155),$J$11/MIN($J$9,$T$6))","v":0},null,null,136,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I157>0,MAX(SUM(F158:$F$203)-L157,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N156),$J$11/MIN($J$9,$T$6))","v":0},null,null,137,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I158>0,MAX(SUM(F159:$F$203)-L158,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N157),$J$11/MIN($J$9,$T$6))","v":0},null,null,138,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I159>0,MAX(SUM(F160:$F$203)-L159,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N158),$J$11/MIN($J$9,$T$6))","v":0},null,null,139,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I160>0,MAX(SUM(F161:$F$203)-L160,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N159),$J$11/MIN($J$9,$T$6))","v":0},null,null,140,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I161>0,MAX(SUM(F162:$F$203)-L161,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N160),$J$11/MIN($J$9,$T$6))","v":0},null,null,141,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I162>0,MAX(SUM(F163:$F$203)-L162,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N161),$J$11/MIN($J$9,$T$6))","v":0},null,null,142,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I163>0,MAX(SUM(F164:$F$203)-L163,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N162),$J$11/MIN($J$9,$T$6))","v":0},null,null,143,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I164>0,MAX(SUM(F165:$F$203)-L164,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N163),$J$11/MIN($J$9,$T$6))","v":0},null,null,144,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I165>0,MAX(SUM(F166:$F$203)-L165,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N164),$J$11/MIN($J$9,$T$6))","v":0},null,null,145,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I166>0,MAX(SUM(F167:$F$203)-L166,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N165),$J$11/MIN($J$9,$T$6))","v":0},null,null,146,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I167>0,MAX(SUM(F168:$F$203)-L167,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N166),$J$11/MIN($J$9,$T$6))","v":0},null,null,147,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I168>0,MAX(SUM(F169:$F$203)-L168,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N167),$J$11/MIN($J$9,$T$6))","v":0},null,null,148,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I169>0,MAX(SUM(F170:$F$203)-L169,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N168),$J$11/MIN($J$9,$T$6))","v":0},null,null,149,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I170>0,MAX(SUM(F171:$F$203)-L170,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N169),$J$11/MIN($J$9,$T$6))","v":0},null,null,150,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I171>0,MAX(SUM(F172:$F$203)-L171,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N170),$J$11/MIN($J$9,$T$6))","v":0},null,null,151,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I172>0,MAX(SUM(F173:$F$203)-L172,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N171),$J$11/MIN($J$9,$T$6))","v":0},null,null,152,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I173>0,MAX(SUM(F174:$F$203)-L173,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N172),$J$11/MIN($J$9,$T$6))","v":0},null,null,153,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I174>0,MAX(SUM(F175:$F$203)-L174,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N173),$J$11/MIN($J$9,$T$6))","v":0},null,null,{"$f":"Q173+1","v":154},null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I175>0,MAX(SUM(F176:$F$203)-L175,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N174),$J$11/MIN($J$9,$T$6))","v":0},null,null,155,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I176>0,MAX(SUM(F177:$F$203)-L176,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N175),$J$11/MIN($J$9,$T$6))","v":0},null,null,156,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,0,0,0,{"$f":"IF(I177>0,MAX(SUM(F178:$F$203)-L177,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N176),$J$11/MIN($J$9,$T$6))","v":0},null,null,157,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I178>0,SUM(G179:G203),0)","v":0},0,{"$f":"IF(I178>0,SUM(F179:F203),0)","v":0},{"$f":"IF(I178>0,MAX(SUM(F179:$F$203)-L178,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N177),$J$11/MIN($J$9,$T$6))","v":0},null,null,158,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I179>0,SUM(G180:G203),0)","v":0},0,{"$f":"IF(I179>0,SUM(F180:F203),0)","v":0},{"$f":"IF(I179>0,MAX(SUM(F180:$F$203)-L179,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N178),$J$11/MIN($J$9,$T$6))","v":0},null,null,159,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I180>0,SUM(G181:G203),0)","v":0},0,{"$f":"IF(I180>0,SUM(F181:F203),0)","v":0},{"$f":"IF(I180>0,MAX(SUM(F181:$F$203)-L180,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N179),$J$11/MIN($J$9,$T$6))","v":0},null,null,160,null,null,null,"blank"]
[null,null,null,{"$f":"IF(AND($J$12>0,Q181<=$Q$18),D180+14,0)","v":"00:00:00"},0,{"$f":"IF(AND(E181>0,Q181<=$J$9+IF(AND($J$10>0,$D$11=\"On Commencement\"),1,0)),E181*$F$13,0)","v":0},0,0,0,{"$f":"IF(I181>0,SUM(G182:G203),0)","v":0},0,{"$f":"IF(I181>0,SUM(F182:F203),0)","v":0},{"$f":"IF(I181>0,MAX(SUM(F182:$F$203)-L181,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N180),$J$11/MIN($J$9,$T$6))","v":0},null,null,161,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I182>0,SUM(G183:G203),0)","v":0},0,{"$f":"IF(I182>0,SUM(F183:F203),0)","v":0},{"$f":"IF(I182>0,MAX(SUM(F183:$F$203)-L182,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N181),$J$11/MIN($J$9,$T$6))","v":0},null,null,162,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,{"$f":"IF($J$12>0,IF(Q183<=$J$9,$J$8,0)+IF(Q183=$J$9+1,$J$10,0),0)","v":0},0,0,{"$f":"IF(I183>0,SUM(G184:G203),0)","v":0},0,{"$f":"IF(I183>0,SUM(F184:F203),0)","v":0},{"$f":"IF(I183>0,MAX(SUM(F184:$F$203)-L183,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N182),$J$11/MIN($J$9,$T$6))","v":0},null,null,163,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I184>0,SUM(G185:G203),0)","v":0},0,{"$f":"IF(I184>0,SUM(F185:F203),0)","v":0},{"$f":"IF(I184>0,MAX(SUM(F185:$F$203)-L184,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N183),$J$11/MIN($J$9,$T$6))","v":0},null,null,164,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I185>0,SUM(G186:G203),0)","v":0},0,{"$f":"IF(I185>0,SUM(F186:F203),0)","v":0},{"$f":"IF(I185>0,MAX(SUM(F186:$F$203)-L185,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N184),$J$11/MIN($J$9,$T$6))","v":0},null,null,165,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I186>0,SUM(G187:G203),0)","v":0},0,{"$f":"IF(I186>0,SUM(F187:F203),0)","v":0},{"$f":"IF(I186>0,MAX(SUM(F187:$F$203)-L186,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N185),$J$11/MIN($J$9,$T$6))","v":0},null,null,166,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I187>0,SUM(G188:G203),0)","v":0},0,{"$f":"IF(I187>0,SUM(F188:F203),0)","v":0},{"$f":"IF(I187>0,MAX(SUM(F188:$F$203)-L187,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N186),$J$11/MIN($J$9,$T$6))","v":0},null,null,167,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I188>0,SUM(G189:G203),0)","v":0},0,{"$f":"IF(I188>0,SUM(F189:F203),0)","v":0},{"$f":"IF(I188>0,MAX(SUM(F189:$F$203)-L188,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N187),$J$11/MIN($J$9,$T$6))","v":0},null,null,168,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I189>0,SUM(G190:G203),0)","v":0},0,{"$f":"IF(I189>0,SUM(F190:F203),0)","v":0},{"$f":"IF(I189>0,MAX(SUM(F190:$F$203)-L189,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N188),$J$11/MIN($J$9,$T$6))","v":0},null,null,169,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I190>0,SUM(G191:G203),0)","v":0},0,{"$f":"IF(I190>0,SUM(F191:F203),0)","v":0},{"$f":"IF(I190>0,MAX(SUM(F191:$F$203)-L190,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N189),$J$11/MIN($J$9,$T$6))","v":0},null,null,170,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I191>0,SUM(G192:G203),0)","v":0},0,{"$f":"IF(I191>0,SUM(F192:F203),0)","v":0},{"$f":"IF(I191>0,MAX(SUM(F192:$F$203)-L191,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N190),$J$11/MIN($J$9,$T$6))","v":0},null,null,171,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I192>0,SUM(G193:G203),0)","v":0},0,{"$f":"IF(I192>0,SUM(F193:F203),0)","v":0},{"$f":"IF(I192>0,MAX(SUM(F193:$F$203)-L192,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N191),$J$11/MIN($J$9,$T$6))","v":0},null,null,172,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I193>0,SUM(G194:G203),0)","v":0},0,{"$f":"IF(I193>0,SUM(F194:F203),0)","v":0},{"$f":"IF(I193>0,MAX(SUM(F194:$F$203)-L193,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N192),$J$11/MIN($J$9,$T$6))","v":0},null,null,173,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I194>0,SUM(G195:G203),0)","v":0},0,{"$f":"IF(I194>0,SUM(F195:F203),0)","v":0},{"$f":"IF(I194>0,MAX(SUM(F195:$F$203)-L194,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N193),$J$11/MIN($J$9,$T$6))","v":0},null,null,174,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I195>0,SUM(G196:G203),0)","v":0},0,{"$f":"IF(I195>0,SUM(F196:F203),0)","v":0},{"$f":"IF(I195>0,MAX(SUM(F196:$F$203)-L195,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N194),$J$11/MIN($J$9,$T$6))","v":0},null,null,175,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I196>0,SUM(G197:G203),0)","v":0},0,{"$f":"IF(I196>0,SUM(F197:F203),0)","v":0},{"$f":"IF(I196>0,MAX(SUM(F197:$F$203)-L196,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N195),$J$11/MIN($J$9,$T$6))","v":0},null,null,176,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I197>0,SUM(G198:G203),0)","v":0},0,{"$f":"IF(I197>0,SUM(F198:F203),0)","v":0},{"$f":"IF(I197>0,MAX(SUM(F198:$F$203)-L197,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N196),$J$11/MIN($J$9,$T$6))","v":0},null,null,177,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I198>0,SUM(G199:G203),0)","v":0},0,{"$f":"IF(I198>0,SUM(F199:F203),0)","v":0},{"$f":"IF(I198>0,MAX(SUM(F199:$F$203)-L198,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N197),$J$11/MIN($J$9,$T$6))","v":0},null,null,178,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I199>0,SUM(G200:G203),0)","v":0},0,{"$f":"IF(I199>0,SUM(F200:F203),0)","v":0},{"$f":"IF(I199>0,MAX(SUM(F200:$F$203)-L199,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N198),$J$11/MIN($J$9,$T$6))","v":0},null,null,179,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I200>0,SUM(G201:G203),0)","v":0},0,{"$f":"IF(I200>0,SUM(F201:F203),0)","v":0},{"$f":"IF(I200>0,MAX(SUM(F201:$F$203)-L200,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N199),$J$11/MIN($J$9,$T$6))","v":0},null,null,180,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I201>0,SUM(G202:G203),0)","v":0},0,{"$f":"IF(I201>0,SUM(F202:F203),0)","v":0},{"$f":"IF(I201>0,MAX(SUM(F202:$F$203)-L201,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N200),$J$11/MIN($J$9,$T$6))","v":0},null,null,181,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,0,{"$f":"IF(I202>0,SUM(G203:G203),0)","v":0},0,{"$f":"IF(I202>0,SUM(F203:F203),0)","v":0},{"$f":"IF(I202>0,MAX(SUM(F203:$F$203)-L202,0),0)","v":0},{"$f":"MIN($J$11-SUM($N$20:N201),$J$11/MIN($J$9,$T$6))","v":0},null,null,182,null,null,null,"blank"]
[null,null,null,"00:00:00",0,0,0,0,null,null,null,null,null,{"$f":"MIN($J$11-SUM($N$20:N202),$J$11/MIN($J$9,$T$6))","v":0},null,null,183]
[null,null,null,"TOTALS",{"$f":"IF(J12>0,J7,0)","v":0},{"$f":"ROUND(SUM(F20:F203),8)","v":0},{"$f":"SUM(G20:G203)","v":0},{"$f":"\"0 \"","v":"0 "},null,null,null,null,null,{"$f":"SUM(N20:N203)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"blank\"","v":"blank"}]