{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Summary Sheet","A-Preliminaries","B-Work Done","C-Variation","D1-Advance Payment","D4-Previous Cert.","D5-Backcharges","D6-Material at Site"],"not_rendered":{"defined_names":17},"read":"whole","date_system":"1900"}

{"sheet":"Summary Sheet","index":0,"n_rows":47,"n_cols":42,"rows_kept":47,"merged":[[0,0,0,3],[0,4,0,17],[0,18,1,35],[0,41,14,58],[1,0,1,3],[1,4,1,17],[2,0,2,3],[2,4,2,17],[2,18,2,21],[2,22,2,26],[2,27,2,30],[2,31,2,35],[3,0,3,3],[3,4,3,17],[3,18,3,21],[3,22,3,26],[3,27,3,30],[3,31,3,35],[4,0,4,3],[4,4,4,17],[4,18,5,21],[4,22,5,35],[5,0,5,3],[5,4,5,17],[6,0,7,35],[8,0,8,3],[8,4,8,35],[9,0,9,3],[9,4,9,17],[9,18,9,21],[9,22,9,35],[10,0,10,3],[10,4,10,17],[10,18,10,21],[10,22,10,35],[11,0,11,3],[11,4,11,17],[11,18,11,21],[11,22,11,35],[12,0,12,3],[12,4,12,17],[12,18,12,21],[12,22,12,26],[12,27,12,35],[13,0,13,3],[13,4,13,17],[13,18,13,21],[13,22,13,35],[14,0,14,3],[14,4,14,17],[14,18,14,21],[14,22,14,35],[15,0,16,21],[15,22,16,35],[17,0,17,1],[17,2,17,17],[17,18,17,21],[17,22,17,32],[17,33,17,35],[17,41,28,58],[18,0,18,1],[18,2,18,17],[18,18,18,21],[18,22,18,32],[18,33,18,35],[19,0,19,1],[19,2,19,17],[19,18,19,21],[19,22,19,32],[19,33,19,35],[20,0,20,35],[21,0,21,1],[21,2,21,17],[21,18,21,21],[21,22,21,32],[21,33,21,35],[22,0,22,1],[22,2,22,3],[22,4,22,17],[22,18,22,21],[22,22,22,32],[22,33,22,35],[23,0,23,1],[23,2,23,3],[23,4,23,17],[23,18,23,21],[23,22,23,32],[23,33,23,35],[24,0,24,1],[24,2,24,3],[24,4,24,17],[24,18,24,21],[24,22,24,32],[24,33,24,35],[25,0,25,1],[25,2,25,3],[25,4,25,17],[25,18,25,21],[25,22,25,32],[25,33,25,35],[26,0,26,1],[26,2,26,3],[26,4,26,17],[26,18,26,21],[26,22,26,32],[26,33,26,35],[27,0,27,1],[27,2,27,3],[27,4,27,17],[27,18,27,21],[27,22,27,32],[27,33,27,35],[28,0,28,1],[28,2,28,17],[28,18,28,21],[28,22,28,32],[28,33,28,35],[46,0,46,35]]}
["Project",{"$nulls":3},"[Project Name]",{"$nulls":13},"Progress Payment Application (PPA)",{"$nulls":22},"Update this part before anything else"]
["Phase",{"$nulls":3},"[Project Phase]"]
["Client",{"$nulls":3},"[Client]",{"$nulls":13},"Proj. Mngr.",{"$nulls":3},"[Project Mngr.]",{"$nulls":4},"Date",{"$nulls":3},"2016-01-01"]
["Client's Repres.",{"$nulls":3},"[Client's Representative]",{"$nulls":22},"PPC No.",{"$nulls":3},8]
["Contractor",{"$nulls":3},"[Contractor]",{"$nulls":13},"Ref. No.",{"$nulls":3},"XYZ-123-PPC-009-00 - December"]
["Sub-Contractor",{"$nulls":3},"[Sub-Contractor]"]
["1. Contract Details"]
[]
["Contract Title",{"$nulls":3},"[Contract Title]"]
["Contract No.",{"$nulls":3},"[Contract Number]",{"$nulls":13},"Contr. Sum",{"$nulls":3},{"v":7500000,"d":"7,500,000.00"}]
["Contract Period",{"$nulls":3},"[Contract Duration]",{"$nulls":13},"Adjusted Sum"]
["Contract Start",{"$nulls":3},"2015-05-01",{"$nulls":13},"Advance Payment",{"$nulls":3},{"v":750000,"d":"750,000.00"}]
["Contract End",{"$nulls":3},"2015-04-30",{"$nulls":13},"Repaym. Period",{"$nulls":3},"month",{"$nulls":4},6]
["Duration (month)",{"$nulls":3},12,{"$nulls":13},"Retention (%)",{"$nulls":3},{"v":0.05,"d":"5%"}]
["Contr. Currency",{"$nulls":3},"USD",{"$nulls":13},"Performance (%)",{"$nulls":3},{"v":0.05,"d":"5%"}]
["2. Summary",{"$nulls":21},"Amount Certified (USD)\n(refer attached detail)"]
[]
["A)",null,"Preliminaries",{"$nulls":19},{"$f":"'A-Preliminaries'!AG32","v":{"v":91353,"d":"91,353.00"}},{"$nulls":10},{"$f":"E15","v":"USD"},{"$nulls":7},"Nothing to fill here, everything updates automatically"]
["B)",null,"Work Done",{"$nulls":19},{"$f":"'B-Work Done'!AG111","v":{"v":5633797.5,"d":"5,633,797.50"}},{"$nulls":10},{"$f":"AH18","v":"USD"}]
["C)",null,"Variation works (+/-)",{"$nulls":19},{"$f":"'C-Variation'!AG26","v":{"v":3567,"d":"3,567.00"}},{"$nulls":10},{"$f":"AH19","v":"USD"}]
[]
["D)",null,"Total Work Done",{"$nulls":15},"A+B+C",{"$nulls":3},{"$f":"SUM(W18:AG20)","v":{"v":5728717.5,"d":"5,728,717.50"}},{"$nulls":10},{"$f":"AH19","v":"USD"}]
[null,null,"1)",null,"Less Adv. Payment Amortization",{"$nulls":17},{"$f":"'D1-Advance Payment'!AG26","v":{"v":-749999.9999999994,"d":"-750,000.00 "}},{"$nulls":10},{"$f":"AH22","v":"USD"}]
[null,null,"2)",null,"Less Retention",{"$nulls":17},{"$f":"ROUND(W22*W14,2)*-1","v":{"v":-286435.88,"d":"-286,435.88 "}},{"$nulls":10},{"$f":"AH23","v":"USD"}]
[null,null,"3)",null,"Less Performance",{"$nulls":17},{"$f":"ROUND(W22*W15,2)*-1","v":{"v":-286435.88,"d":"-286,435.88 "}},{"$nulls":10},"USD"]
[null,null,"4)",null,"Less Previous Certified Amount",{"$nulls":17},{"$f":"VLOOKUP(AF4-1,'D4-Previous Cert.'!A10:AJ24,31,FALSE)*-1","v":{"v":-1530000,"d":"-1,530,000.00 "}},{"$nulls":10},"USD"]
[null,null,"5)",null,"Less Backcharges",{"$nulls":17},{"$f":"'D5-Backcharges'!AE25","v":{"v":-37500,"d":"-37,500.00 "}},{"$nulls":10},"USD"]
[null,null,"6)",null,"Plus Material at Site",{"$nulls":17},{"$f":"'D6-Material at Site'!AE25","v":{"v":227500,"d":"227,500.00"}},{"$nulls":10},{"$f":"AH27","v":"USD"}]
["E)",null,"Payable Amount this Month",{"$nulls":15},"D+1+2+3+4+5+6",{"$nulls":3},{"$f":"SUM(W22:AG28)","v":{"v":3065845.740000001,"d":"3,065,845.74"}},{"$nulls":10},{"$f":"AH27","v":"USD"}]
{"$rows_empty":17}
[{"$f":"\"All amounts in \"&E15&\".\"","v":"All amounts in USD."}]

{"sheet":"A-Preliminaries","index":1,"n_rows":49,"n_cols":42,"rows_kept":49,"merged":[[0,0,0,3],[0,4,0,17],[0,18,1,35],[0,41,5,58],[1,0,1,3],[1,4,1,17],[2,0,2,3],[2,4,2,17],[2,18,2,21],[2,22,2,26],[2,27,2,30],[2,31,2,35],[3,0,3,3],[3,4,3,17],[3,18,3,21],[3,22,3,26],[3,27,3,30],[3,31,3,35],[4,0,4,3],[4,4,4,17],[4,18,5,21],[4,22,5,35],[5,0,5,3],[5,4,5,17],[6,0,7,35],[8,0,9,1],[8,2,9,11],[8,12,9,14],[8,15,9,16],[8,17,9,19],[8,20,9,23],[8,24,8,35],[9,24,9,27],[9,28,9,31],[9,32,9,35],[10,0,10,1],[10,2,10,11],[10,12,10,14],[10,15,10,16],[10,17,10,19],[10,20,10,23],[10,24,10,27],[10,28,10,31],[10,32,10,35],[10,41,24,58],[11,0,11,1],[11,2,11,11],[11,12,11,14],[11,15,11,16],[11,17,11,19],[11,20,11,23],[11,24,11,27],[11,28,11,31],[11,32,11,35],[12,0,12,1],[12,2,12,11],[12,12,12,14],[12,15,12,16],[12,17,12,19],[12,20,12,23],[12,24,12,27],[12,28,12,31],[12,32,12,35],[13,0,13,1],[13,2,13,11],[13,12,13,14],[13,15,13,16],[13,17,13,19],[13,20,13,23],[13,24,13,27],[13,28,13,31],[13,32,13,35],[14,0,14,1],[14,2,14,11],[14,12,14,14],[14,15,14,16],[14,17,14,19],[14,20,14,23],[14,24,14,27],[14,28,14,31],[14,32,14,35],[15,0,15,1],[15,2,15,11],[15,12,15,14],[15,15,15,16],[15,17,15,19],[15,20,15,23],[15,24,15,27],[15,28,15,31],[15,32,15,35],[16,0,16,1],[16,2,16,11],[16,12,16,14],[16,15,16,16],[16,17,16,19],[16,20,16,23],[16,24,16,27],[16,28,16,31],[16,32,16,35],[17,0,17,1],[17,2,17,11],[17,12,17,14],[17,15,17,16],[17,17,17,19],[17,20,17,23],[17,24,17,27],[17,28,17,31],[17,32,17,35],[18,0,18,1],[18,2,18,11],[18,12,18,14],[18,15,18,16],[18,17,18,19],[18,20,18,23],[18,24,18,27],[18,28,18,31],[18,32,18,35],[19,0,19,1],[19,2,19,11],[19,12,19,14],[19,15,19,16],[19,17,19,19],[19,20,19,23],[19,24,19,27],[19,28,19,31],[19,32,19,35],[20,0,20,1],[20,2,20,11],[20,12,20,14],[20,15,20,16],[20,17,20,19],[20,20,20,23],[20,24,20,27],[20,28,20,31],[20,32,20,35],[21,0,21,1],[21,2,21,11],[21,12,21,14],[21,15,21,16],[21,17,21,19],[21,20,21,23],[21,24,21,27],[21,28,21,31],[21,32,21,35],[22,0,22,1],[22,2,22,11],[22,12,22,14],[22,15,22,16],[22,17,22,19],[22,20,22,23],[22,24,22,27],[22,28,22,31],[22,32,22,35],[23,0,23,1],[23,2,23,11],[23,12,23,14],[23,15,23,16],[23,17,23,19],[23,20,23,23],[23,24,23,27],[23,28,23,31],[23,32,23,35],[24,0,24,1],[24,2,24,11],[24,12,24,14],[24,15,24,16],[24,17,24,19],[24,20,24,23],[24,24,24,27],[24,28,24,31],[24,32,24,35],[25,0,25,19],[25,20,25,23],[25,24,25,27],[25,28,25,31],[25,32,25,35],[28,25,28,31],[28,32,28,35],[29,25,29,28],[29,29,29,31],[29,32,29,35],[30,25,30,31],[30,32,30,35],[31,25,31,31],[31,32,31,35],[48,0,48,35]]}
["Project",{"$nulls":3},{"$f":"'Summary Sheet'!E1","v":"[Project Name]"},{"$nulls":13},{"$f":"'Summary Sheet'!S1:AJ2","v":"Progress Payment Application (PPA)"},{"$nulls":22},"Updates Automatically from Summary Sheet"]
["Phase",{"$nulls":3},{"$f":"'Summary Sheet'!E2","v":"[Project Phase]"}]
["Client",{"$nulls":3},{"$f":"'Summary Sheet'!E3","v":"[Client]"},{"$nulls":13},"Proj. Mngr.",{"$nulls":3},{"$f":"'Summary Sheet'!W3","v":"[Project Mngr.]"},{"$nulls":4},"Month",{"$nulls":3},{"$f":"'Summary Sheet'!AF3","v":"2016-01-01"}]
["Client's Repres.",{"$nulls":3},{"$f":"'Summary Sheet'!E4","v":"[Client's Representative]"},{"$nulls":22},"PPC No.",{"$nulls":3},{"$f":"'Summary Sheet'!AF4","v":8}]
["Contractor",{"$nulls":3},{"$f":"'Summary Sheet'!E5","v":"[Contractor]"},{"$nulls":13},"Ref. No.",{"$nulls":3},{"$f":"'Summary Sheet'!W5","v":"XYZ-123-PPC-009-00 - December"}]
["Sub-Contractor",{"$nulls":3},{"$f":"'Summary Sheet'!E6","v":"[Sub-Contractor]"}]
["A) Preliminaries Summary"]
[]
["Item",null,"Description",{"$nulls":9},"QTY",null,null,"UOM",null,"Rate",null,null,"Amount",{"$nulls":3},"Contract Provision"]
[{"$nulls":24},"Initial",{"$nulls":3},"Recurring",{"$nulls":3},"Ending"]
[{"v":1,"d":"01"},null,"Mobilization",{"$nulls":9},1,null,null,"item",null,{"v":12345,"d":"12,345.00"},null,null,{"$f":"M11*R11","v":{"v":12345,"d":"12,345.00"}},{"$nulls":3},{"$f":"U11","v":{"v":12345,"d":"12,345.00"}},{"$nulls":16},"Update this part when preparing first payment claim"]
[{"v":2,"d":"02"},null,"Safety …",{"$nulls":9},{"$f":"'Summary Sheet'!E14","v":12},null,null,"item",null,{"v":9876,"d":"9,876.00"},null,null,{"$f":"M12*R12","v":{"v":118512,"d":"118,512.00"}},{"$nulls":7},{"$f":"U12","v":{"v":118512,"d":"118,512.00"}}]
[{"v":3,"d":"03"},null,"Demobilization",{"$nulls":9},1,null,null,"item",null,{"v":67584,"d":"67,584.00"},null,null,{"$f":"M13*R13","v":{"v":67584,"d":"67,584.00"}},{"$nulls":11},{"$f":"U13","v":{"v":67584,"d":"67,584.00"}}]
{"$rows_empty":12}
["Total:",{"$nulls":19},{"$f":"SUM(U11:X25)","v":{"v":198441,"d":"198,441.00"}},{"$nulls":3},{"$f":"SUM(Y11:AB25)","v":{"v":12345,"d":"12,345.00"}},{"$nulls":3},{"$f":"SUM(AC11:AF25)","v":{"v":118512,"d":"118,512.00"}},{"$nulls":3},{"$f":"SUM(AG11:AJ25)","v":{"v":67584,"d":"67,584.00"}}]
[]
[]
[{"$nulls":25},"Initial",{"$nulls":6},{"$f":"Y26","v":{"v":12345,"d":"12,345.00"}}]
[{"$nulls":25},"Recurring",{"$nulls":3},{"$f":"IF('Summary Sheet'!AF4<'Summary Sheet'!E14,'Summary Sheet'!AF4/'Summary Sheet'!E14,100%)","v":{"v":0.6666666666666666,"d":"66.67%"}},null,null,{"$f":"AC26*AD30","v":{"v":79008,"d":"79,008.00"}}]
[{"$nulls":25},"Ending",{"$nulls":6},{"$f":"IF('Summary Sheet'!AB13='Summary Sheet'!AF4,AG26,0)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":25},"Total Preliminaries",{"$nulls":6},{"$f":"SUM(AG29:AJ31)","v":{"v":91353,"d":"91,353.00"}}]
{"$rows_empty":16}
[{"$f":"\"All amounts in \"&'Summary Sheet'!$E$15&\".\"","v":"All amounts in USD."}]

{"sheet":"B-Work Done","index":2,"n_rows":134,"n_cols":42,"rows_kept":134,"merged":[[0,0,0,3],[0,4,0,17],[0,18,1,35],[0,41,5,58],[1,0,1,3],[1,4,1,17],[2,0,2,3],[2,4,2,17],[2,18,2,21],[2,22,2,26],[2,27,2,30],[2,31,2,35],[3,0,3,3],[3,4,3,17],[3,18,3,21],[3,22,3,26],[3,27,3,30],[3,31,3,35],[4,0,4,3],[4,4,4,17],[4,18,5,21],[4,22,5,35],[5,0,5,3],[5,4,5,17],[6,0,7,35],[8,0,9,1],[8,2,9,9],[8,18,8,23],[8,24,8,29],[8,30,8,35],[9,18,9,19],[9,20,9,23],[9,24,9,25],[9,26,9,29],[9,30,9,31],[9,32,9,35],[10,0,10,1],[10,2,10,9],[10,10,10,12],[10,13,10,14],[10,15,10,17],[10,18,10,19],[10,20,10,23],[10,24,10,25],[10,26,10,29],[10,30,10,31],[10,32,10,35],[10,41,109,58],[11,0,11,1],[11,2,11,9],[11,10,11,12],[11,13,11,14],[11,15,11,17],[11,18,11,19],[11,20,11,23],[11,24,11,25],[11,26,11,29],[11,30,11,31],[11,32,11,35],[12,0,12,1],[12,2,12,9],[12,10,12,12],[12,13,12,14],[12,15,12,17],[12,18,12,19],[12,20,12,23],[12,24,12,25],[12,26,12,29],[12,30,12,31],[12,32,12,35],[13,0,13,1],[13,2,13,9],[13,10,13,12],[13,13,13,14],[13,15,13,17],[13,18,13,19],[13,20,13,23],[13,24,13,25],[13,26,13,29],[13,30,13,31],[13,32,13,35],[14,0,14,1],[14,2,14,9],[14,10,14,12],[14,13,14,14],[14,15,14,17],[14,18,14,19],[14,20,14,23],[14,24,14,25],[14,26,14,29],[14,30,14,31],[14,32,14,35],[15,0,15,1],[15,2,15,9],[15,10,15,12],[15,13,15,14],[15,15,15,17],[15,18,15,19],[15,20,15,23],[15,24,15,25],[15,26,15,29],[15,30,15,31],[15,32,15,35],[16,0,16,1],[16,2,16,9],[16,10,16,12],[16,13,16,14],[16,15,16,17],[16,18,16,19],[16,20,16,23],[16,24,16,25],[16,26,16,29],[16,30,16,31],[16,32,16,35],[17,0,17,1],[17,2,17,9],[17,10,17,12],[17,13,17,14],[17,15,17,17],[17,18,17,19],[17,20,17,23],[17,24,17,25],[17,26,17,29],[17,30,17,31],[17,32,17,35],[18,0,18,1],[18,2,18,9],[18,10,18,12],[18,13,18,14],[18,15,18,17],[18,18,18,19],[18,20,18,23],[18,24,18,25],[18,26,18,29],[18,30,18,31],[18,32,18,35],[19,0,19,1],[19,2,19,9],[19,10,19,12],[19,13,19,14],[19,15,19,17],[19,18,19,19],[19,20,19,23],[19,24,19,25],[19,26,19,29],[19,30,19,31],[19,32,19,35],[20,0,20,1],[20,2,20,9],[20,10,20,12],[20,13,20,14],[20,15,20,17],[20,18,20,19],[20,20,20,23],[20,24,20,25],[20,26,20,29],[20,30,20,31],[20,32,20,35],[21,0,21,1],[21,2,21,9],[21,10,21,12],[21,13,21,14],[21,15,21,17],[21,18,21,19],[21,20,21,23],[21,24,21,25],[21,26,21,29],[21,30,21,31],[21,32,21,35],[22,0,22,1],[22,2,22,9],[22,10,22,12],[22,13,22,14],[22,15,22,17],[22,18,22,19],[22,20,22,23],[22,24,22,25],[22,26,22,29],[22,30,22,31],[22,32,22,35],[23,0,23,1],[23,2,23,9],[23,10,23,12],[23,13,23,14],[23,15,23,17],[23,18,23,19],[23,20,23,23],[23,24,23,25],[23,26,23,29],[23,30,23,31],[23,32,23,35],[24,0,24,1],[24,2,24,9],[24,10,24,12],[24,13,24,14],[24,15,24,17],[24,18,24,19],[24,20,24,23],[24,24,24,25],[24,26,24,29],[24,30,24,31],[24,32,24,35],[25,0,25,1],[25,2,25,9],[25,10,25,12],[25,13,25,14],[25,15,25,17],[25,18,25,19],[25,20,25,23],[25,24,25,25],[25,26,25,29],[25,30,25,31],[25,32,25,35],[26,0,26,1],[26,2,26,9],[26,10,26,12],[26,13,26,14],[26,15,26,17],[26,18,26,19],[26,20,26,23],[26,24,26,25],[26,26,26,29],[26,30,26,31],[26,32,26,35],[27,0,27,1],[27,2,27,9],[27,10,27,12],[27,13,27,14],[27,15,27,17],[27,18,27,19],[27,20,27,23],[27,24,27,25],[27,26,27,29],[27,30,27,31],[27,32,27,35],[28,0,28,1],[28,2,28,9],[28,10,28,12],[28,13,28,14],[28,15,28,17],[28,18,28,19],[28,20,28,23],[28,24,28,25],[28,26,28,29],[28,30,28,31],[28,32,28,35],[29,0,29,1],[29,2,29,9],[29,10,29,12],[29,13,29,14],[29,15,29,17],[29,18,29,19],[29,20,29,23],[29,24,29,25],[29,26,29,29],[29,30,29,31],[29,32,29,35],[30,0,30,1],[30,2,30,9],[30,10,30,12],[30,13,30,14],[30,15,30,17],[30,18,30,19],[30,20,30,23],[30,24,30,25],[30,26,30,29],[30,30,30,31],[30,32,30,35],[31,0,31,1],[31,2,31,9],[31,10,31,12],[31,13,31,14],[31,15,31,17],[31,18,31,19],[31,20,31,23],[31,24,31,25],[31,26,31,29],[31,30,31,31],[31,32,31,35],[32,0,32,1],[32,2,32,9],[32,10,32,12],[32,13,32,14],[32,15,32,17],[32,18,32,19],[32,20,32,23],[32,24,32,25],[32,26,32,29],[32,30,32,31],[32,32,32,35],[33,0,33,1],[33,2,33,9],[33,10,33,12],[33,13,33,14],[33,15,33,17],[33,18,33,19],[33,20,33,23],[33,24,33,25],[33,26,33,29],[33,30,33,31],[33,32,33,35],[34,0,34,1],[34,2,34,9],[34,10,34,12],[34,13,34,14],[34,15,34,17],[34,18,34,19],[34,20,34,23],[34,24,34,25],[34,26,34,29],[34,30,34,31],[34,32,34,35],[35,0,35,1],[35,2,35,9],[35,10,35,12],[35,13,35,14],[35,15,35,17],[35,18,35,19],[35,20,35,23],[35,24,35,25],[35,26,35,29],[35,30,35,31],[35,32,35,35],[36,0,36,1],[36,2,36,9],[36,10,36,12],[36,13,36,14],[36,15,36,17],[36,18,36,19],[36,20,36,23],[36,24,36,25],[36,26,36,29],[36,30,36,31],[36,32,36,35],[37,0,37,1],[37,2,37,9],[37,10,37,12],[37,13,37,14],[37,15,37,17],[37,18,37,19],[37,20,37,23],[37,24,37,25],[37,26,37,29],[37,30,37,31],[37,32,37,35],[38,0,38,1],[38,2,38,9],[38,10,38,12],[38,13,38,14],[38,15,38,17],[38,18,38,19],[38,20,38,23],[38,24,38,25],[38,26,38,29],[38,30,38,31],[38,32,38,35],[39,0,39,1],[39,2,39,9],[39,10,39,12],[39,13,39,14],[39,15,39,17],[39,18,39,19],[39,20,39,23],[39,24,39,25],[39,26,39,29],[39,30,39,31],[39,32,39,35],[40,0,40,1],[40,2,40,9],[40,10,40,12],[40,13,40,14],[40,15,40,17],[40,18,40,19],[40,20,40,23],[40,24,40,25],[40,26,40,29],[40,30,40,31],[40,32,40,35],[41,0,41,1],[41,2,41,9],[41,10,41,12],[41,13,41,14],[41,15,41,17],[41,18,41,19],[41,20,41,23],[41,24,41,25],[41,26,41,29],[41,30,41,31],[41,32,41,35],[42,0,42,1],[42,2,42,9],[42,10,42,12],[42,13,42,14],[42,15,42,17],[42,18,42,19],[42,20,42,23],[42,24,42,25],[42,26,42,29],[42,30,42,31],[42,32,42,35],[43,0,43,1],[43,2,43,9],[43,10,43,12],[43,13,43,14],[43,15,43,17],[43,18,43,19],[43,20,43,23],[43,24,43,25],[43,26,43,29],[43,30,43,31],[43,32,43,35],[44,0,44,1],[44,2,44,9],[44,10,44,12],[44,13,44,14],[44,15,44,17],[44,18,44,19],[44,20,44,23],[44,24,44,25],[44,26,44,29],[44,30,44,31],[44,32,44,35],[45,0,45,1],[45,2,45,9],[45,10,45,12],[45,13,45,14],[45,15,45,17],[45,18,45,19],[45,20,45,23],[45,24,45,25],[45,26,45,29],[45,30,45,31],[45,32,45,35],[46,0,46,1],[46,2,46,9],[46,10,46,12],[46,13,46,14],[46,15,46,17],[46,18,46,19],[46,20,46,23],[46,24,46,25],[46,26,46,29],[46,30,46,31],[46,32,46,35],[47,0,47,1],[47,2,47,9],[47,10,47,12],[47,13,47,14],[47,15,47,17],[47,18,47,19],[47,20,47,23],[47,24,47,25],[47,26,47,29],[47,30,47,31],[47,32,47,35],[48,0,48,1],[48,2,48,9],[48,10,48,12],[48,13,48,14],[48,15,48,17],[48,18,48,19],[48,20,48,23],[48,24,48,25],[48,26,48,29],[48,30,48,31],[48,32,48,35],[49,0,49,1],[49,2,49,9],[49,10,49,12],[49,13,49,14],[49,15,49,17],[49,18,49,19],[49,20,49,23],[49,24,49,25],[49,26,49,29],[49,30,49,31],[49,32,49,35],[50,0,50,1],[50,2,50,9],[50,10,50,12],[50,13,50,14],[50,15,50,17],[50,18,50,19],[50,20,50,23],[50,24,50,25],[50,26,50,29],[50,30,50,31],[50,32,50,35],[51,0,51,1],[51,2,51,9],[51,10,51,12],[51,13,51,14],[51,15,51,17],[51,18,51,19],[51,20,51,23],[51,24,51,25],[51,26,51,29],[51,30,51,31],[51,32,51,35],[52,0,52,1],[52,2,52,9],[52,10,52,12],[52,13,52,14],[52,15,52,17],[52,18,52,19],[52,20,52,23],[52,24,52,25],[52,26,52,29],[52,30,52,31],[52,32,52,35],[53,0,53,1],[53,2,53,9],[53,10,53,12],[53,13,53,14],[53,15,53,17],[53,18,53,19],[53,20,53,23],[53,24,53,25],[53,26,53,29],[53,30,53,31],[53,32,53,35],[54,0,54,1],[54,2,54,9],[54,10,54,12],[54,13,54,14],[54,15,54,17],[54,18,54,19],[54,20,54,23],[54,24,54,25],[54,26,54,29],[54,30,54,31],[54,32,54,35],[55,0,55,1],[55,2,55,9],[55,10,55,12],[55,13,55,14],[55,15,55,17],[55,18,55,19],[55,20,55,23],[55,24,55,25],[55,26,55,29],[55,30,55,31],[55,32,55,35],[56,0,56,1],[56,2,56,9],[56,10,56,12],[56,13,56,14],[56,15,56,17],[56,18,56,19],[56,20,56,23],[56,24,56,25],[56,26,56,29],[56,30,56,31],[56,32,56,35],[57,0,57,1],[57,2,57,9],[57,10,57,12],[57,13,57,14],[57,15,57,17],[57,18,57,19],[57,20,57,23],[57,24,57,25],[57,26,57,29],[57,30,57,31],[57,32,57,35],[58,0,58,1],[58,2,58,9],[58,10,58,12],[58,13,58,14],[58,15,58,17],[58,18,58,19],[58,20,58,23],[58,24,58,25],[58,26,58,29],[58,30,58,31],[58,32,58,35],[59,0,59,1],[59,2,59,9],[59,10,59,12],[59,13,59,14],[59,15,59,17],[59,18,59,19],[59,20,59,23],[59,24,59,25],[59,26,59,29],[59,30,59,31],[59,32,59,35],[60,0,60,1],[60,2,60,9],[60,10,60,12],[60,13,60,14],[60,15,60,17],[60,18,60,19],[60,20,60,23],[60,24,60,25],[60,26,60,29],[60,30,60,31],[60,32,60,35],[61,0,61,1],[61,2,61,9],[61,10,61,12],[61,13,61,14],[61,15,61,17],[61,18,61,19],[61,20,61,23],[61,24,61,25],[61,26,61,29],[61,30,61,31],[61,32,61,35],[62,0,62,1],[62,2,62,9],[62,10,62,12],[62,13,62,14],[62,15,62,17],[62,18,62,19],[62,20,62,23],[62,24,62,25],[62,26,62,29],[62,30,62,31],[62,32,62,35],[63,0,63,1],[63,2,63,9],[63,10,63,12],[63,13,63,14],[63,15,63,17],[63,18,63,19],[63,20,63,23],[63,24,63,25],[63,26,63,29],[63,30,63,31],[63,32,63,35],[64,0,64,1],[64,2,64,9],[64,10,64,12],[64,13,64,14],[64,15,64,17],[64,18,64,19],[64,20,64,23],[64,24,64,25],[64,26,64,29],[64,30,64,31],[64,32,64,35],[65,0,65,1],[65,2,65,9],[65,10,65,12],[65,13,65,14],[65,15,65,17],[65,18,65,19],[65,20,65,23],[65,24,65,25],[65,26,65,29],[65,30,65,31],[65,32,65,35],[66,0,66,1],[66,2,66,9],[66,10,66,12],[66,13,66,14],[66,15,66,17],[66,18,66,19],[66,20,66,23],[66,24,66,25],[66,26,66,29],[66,30,66,31],[66,32,66,35],[67,0,67,1],[67,2,67,9],[67,10,67,12],[67,13,67,14],[67,15,67,17],[67,18,67,19],[67,20,67,23],[67,24,67,25],[67,26,67,29],[67,30,67,31],[67,32,67,35],[68,0,68,1],[68,2,68,9],[68,10,68,12],[68,13,68,14],[68,15,68,17],[68,18,68,19],[68,20,68,23],[68,24,68,25],[68,26,68,29],[68,30,68,31],[68,32,68,35],[69,0,69,1],[69,2,69,9],[69,10,69,12],[69,13,69,14],[69,15,69,17],[69,18,69,19],[69,20,69,23],[69,24,69,25],[69,26,69,29],[69,30,69,31],[69,32,69,35],[70,0,70,1],[70,2,70,9],[70,10,70,12],[70,13,70,14],[70,15,70,17],[70,18,70,19],[70,20,70,23],[70,24,70,25],[70,26,70,29],[70,30,70,31],[70,32,70,35],[71,0,71,1],[71,2,71,9],[71,10,71,12],[71,13,71,14],[71,15,71,17],[71,18,71,19],[71,20,71,23],[71,24,71,25],[71,26,71,29],[71,30,71,31],[71,32,71,35],[72,0,72,1],[72,2,72,9],[72,10,72,12],[72,13,72,14],[72,15,72,17],[72,18,72,19],[72,20,72,23],[72,24,72,25],[72,26,72,29],[72,30,72,31],[72,32,72,35],[73,0,73,1],[73,2,73,9],[73,10,73,12],[73,13,73,14],[73,15,73,17],[73,18,73,19],[73,20,73,23],[73,24,73,25],[73,26,73,29],[73,30,73,31],[73,32,73,35],[74,0,74,1],[74,2,74,9],[74,10,74,12],[74,13,74,14],[74,15,74,17],[74,18,74,19],[74,20,74,23],[74,24,74,25],[74,26,74,29],[74,30,74,31],[74,32,74,35],[75,0,75,1],[75,2,75,9],[75,10,75,12],[75,13,75,14],[75,15,75,17],[75,18,75,19],[75,20,75,23],[75,24,75,25],[75,26,75,29],[75,30,75,31],[75,32,75,35],[76,0,76,1],[76,2,76,9],[76,10,76,12],[76,13,76,14],[76,15,76,17],[76,18,76,19],[76,20,76,23],[76,24,76,25],[76,26,76,29],[76,30,76,31],[76,32,76,35],[77,0,77,1],[77,2,77,9],[77,10,77,12],[77,13,77,14],[77,15,77,17],[77,18,77,19],[77,20,77,23],[77,24,77,25],[77,26,77,29],[77,30,77,31],[77,32,77,35],[78,0,78,1],[78,2,78,9],[78,10,78,12],[78,13,78,14],[78,15,78,17],[78,18,78,19],[78,20,78,23],[78,24,78,25],[78,26,78,29],[78,30,78,31],[78,32,78,35],[79,0,79,1],[79,2,79,9],[79,10,79,12],[79,13,79,14],[79,15,79,17],[79,18,79,19],[79,20,79,23],[79,24,79,25],[79,26,79,29],[79,30,79,31],[79,32,79,35],[80,0,80,1],[80,2,80,9],[80,10,80,12],[80,13,80,14],[80,15,80,17],[80,18,80,19],[80,20,80,23],[80,24,80,25],[80,26,80,29],[80,30,80,31],[80,32,80,35],[81,0,81,1],[81,2,81,9],[81,10,81,12],[81,13,81,14],[81,15,81,17],[81,18,81,19],[81,20,81,23],[81,24,81,25],[81,26,81,29],[81,30,81,31],[81,32,81,35],[82,0,82,1],[82,2,82,9],[82,10,82,12],[82,13,82,14],[82,15,82,17],[82,18,82,19],[82,20,82,23],[82,24,82,25],[82,26,82,29],[82,30,82,31],[82,32,82,35],[83,0,83,1],[83,2,83,9],[83,10,83,12],[83,13,83,14],[83,15,83,17],[83,18,83,19],[83,20,83,23],[83,24,83,25],[83,26,83,29],[83,30,83,31],[83,32,83,35],[84,0,84,1],[84,2,84,9],[84,10,84,12],[84,13,84,14],[84,15,84,17],[84,18,84,19],[84,20,84,23],[84,24,84,25],[84,26,84,29],[84,30,84,31],[84,32,84,35],[85,0,85,1],[85,2,85,9],[85,10,85,12],[85,13,85,14],[85,15,85,17],[85,18,85,19],[85,20,85,23],[85,24,85,25],[85,26,85,29],[85,30,85,31],[85,32,85,35],[86,0,86,1],[86,2,86,9],[86,10,86,12],[86,13,86,14],[86,15,86,17],[86,18,86,19],[86,20,86,23],[86,24,86,25],[86,26,86,29],[86,30,86,31],[86,32,86,35],[87,0,87,1],[87,2,87,9],[87,10,87,12],[87,13,87,14],[87,15,87,17],[87,18,87,19],[87,20,87,23],[87,24,87,25],[87,26,87,29],[87,30,87,31],[87,32,87,35],[88,0,88,1],[88,2,88,9],[88,10,88,12],[88,13,88,14],[88,15,88,17],[88,18,88,19],[88,20,88,23],[88,24,88,25],[88,26,88,29],[88,30,88,31],[88,32,88,35],[89,0,89,1],[89,2,89,9],[89,10,89,12],[89,13,89,14],[89,15,89,17],[89,18,89,19],[89,20,89,23],[89,24,89,25],[89,26,89,29],[89,30,89,31],[89,32,89,35],[90,0,90,1],[90,2,90,9],[90,10,90,12],[90,13,90,14],[90,15,90,17],[90,18,90,19],[90,20,90,23],[90,24,90,25],[90,26,90,29],[90,30,90,31],[90,32,90,35],[91,0,91,1],[91,2,91,9],[91,10,91,12],[91,13,91,14],[91,15,91,17],[91,18,91,19],[91,20,91,23],[91,24,91,25],[91,26,91,29],[91,30,91,31],[91,32,91,35],[92,0,92,1],[92,2,92,9],[92,10,92,12],[92,13,92,14],[92,15,92,17],[92,18,92,19],[92,20,92,23],[92,24,92,25],[92,26,92,29],[92,30,92,31],[92,32,92,35],[93,0,93,1],[93,2,93,9],[93,10,93,12],[93,13,93,14],[93,15,93,17],[93,18,93,19],[93,20,93,23],[93,24,93,25],[93,26,93,29],[93,30,93,31],[93,32,93,35],[94,0,94,1],[94,2,94,9],[94,10,94,12],[94,13,94,14],[94,15,94,17],[94,18,94,19],[94,20,94,23],[94,24,94,25],[94,26,94,29],[94,30,94,31],[94,32,94,35],[95,0,95,1],[95,2,95,9],[95,10,95,12],[95,13,95,14],[95,15,95,17],[95,18,95,19],[95,20,95,23],[95,24,95,25],[95,26,95,29],[95,30,95,31],[95,32,95,35],[96,0,96,1],[96,2,96,9],[96,10,96,12],[96,13,96,14],[96,15,96,17],[96,18,96,19],[96,20,96,23],[96,24,96,25],[96,26,96,29],[96,30,96,31],[96,32,96,35],[98,18,98,19],[98,20,98,23],[98,24,98,25],[110,0,110,31],[110,32,110,35],[133,0,133,35]],"merged_total":1144,"flags":["merged_cut"]}
["Project",{"$nulls":3},{"$f":"'Summary Sheet'!E1","v":"[Project Name]"},{"$nulls":13},{"$f":"'Summary Sheet'!S1:AJ2","v":"Progress Payment Application (PPA)"},{"$nulls":22},"Updates Automatically from Summary Sheet"]
["Phase",{"$nulls":3},{"$f":"'Summary Sheet'!E2","v":"[Project Phase]"}]
["Client",{"$nulls":3},{"$f":"'Summary Sheet'!E3","v":"[Client]"},{"$nulls":13},"Proj. Mngr.",{"$nulls":3},{"$f":"'Summary Sheet'!W3","v":"[Project Mngr.]"},{"$nulls":4},"Month",{"$nulls":3},{"$f":"'Summary Sheet'!AF3","v":"2016-01-01"}]
["Client's Repres.",{"$nulls":3},{"$f":"'Summary Sheet'!E4","v":"[Client's Representative]"},{"$nulls":22},"PPC No.",{"$nulls":3},{"$f":"'Summary Sheet'!AF4","v":8}]
["Contractor",{"$nulls":3},{"$f":"'Summary Sheet'!E5","v":"[Contractor]"},{"$nulls":13},"Ref. No.",{"$nulls":3},{"$f":"'Summary Sheet'!W5","v":"XYZ-123-PPC-009-00 - December"}]
["Sub-Contractor",{"$nulls":3},{"$f":"'Summary Sheet'!E6","v":"[Sub-Contractor]"}]
["B) Work Done"]
[]
["Item",null,"Description",{"$nulls":7},"BOQ",{"$nulls":7},"Current Month",{"$nulls":5},"Previous Month(s)",{"$nulls":5},"Total Work Done"]
[{"$nulls":10},"QTY",null,null,"UOM",null,"Rate",null,null,"QTY",null,"Amount",{"$nulls":3},"QTY",null,"Amount",{"$nulls":3},"QTY",null,"Amount"]
[{"v":1,"d":"01"},null,"ABC",{"$nulls":7},{"v":12000,"d":"12,000"},null,null,"m3",null,{"v":118,"d":"118.00"},null,null,{"v":3400,"d":"3,400"},null,{"$f":"S11*P11","v":{"v":401200,"d":"401,200.00"}},{"$nulls":3},{"v":3600,"d":"3,600"},null,{"$f":"Y11*P11","v":{"v":424800,"d":"424,800.00"}},{"$nulls":3},{"$f":"S11+Y11","v":{"v":7000,"d":"7,000"}},null,{"$f":"AE11*P11","v":{"v":826000,"d":"826,000.00"}},{"$nulls":8},"Update this part every month."]
[{"v":2,"d":"02"},null,"DEF",{"$nulls":7},260,null,null,"ton",null,{"v":1110,"d":"1,110.00"},null,null,15,null,{"$f":"S12*P12","v":{"v":16650,"d":"16,650.00"}},{"$nulls":3},112,null,{"$f":"Y12*P12","v":{"v":124320,"d":"124,320.00"}},{"$nulls":3},{"$f":"S12+Y12","v":127},null,{"$f":"AE12*P12","v":{"v":140970,"d":"140,970.00"}}]
[{"v":3,"d":"03"},null,"GHI",{"$nulls":7},{"v":120000,"d":"120,000"},null,null,"m2",null,{"v":354.5,"d":"354.50"},null,null,{"v":8971,"d":"8,971"},null,{"$f":"S13*P13","v":{"v":3180219.5,"d":"3,180,219.50"}},{"$nulls":3},0,null,{"$f":"Y13*P13","v":{"v":0,"d":"0.00"}},{"$nulls":3},{"$f":"S13+Y13","v":{"v":8971,"d":"8,971"}},null,{"$f":"AE13*P13","v":{"v":3180219.5,"d":"3,180,219.50"}}]
[{"v":4,"d":"04"},null,"JKL",{"$nulls":7},{"v":120000,"d":"120,000"},null,null,"m2",null,{"v":170.6,"d":"170.60"},null,null,{"v":1200,"d":"1,200"},null,{"v":204720,"d":"204,720.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"},{"$nulls":3},{"v":1200,"d":"1,200"},null,{"v":204720,"d":"204,720.00"}]
[{"v":5,"d":"05"},null,"MNO",{"$nulls":7},117,null,null,"pcs.",null,{"v":384,"d":"384.00"},null,null,57,null,{"v":21888,"d":"21,888.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"},{"$nulls":3},57,null,{"v":21888,"d":"21,888.00"}]
[{"v":6,"d":"06"},null,"PQR",{"$nulls":7},2,null,null,"set",null,{"v":380000,"d":"380,000.00"},null,null,0,null,{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[{"v":7,"d":"07"},null,"STU",{"$nulls":7},{"v":36000,"d":"36,000"},null,null,"m",null,{"v":70,"d":"70.00"},null,null,{"v":17000,"d":"17,000"},null,{"v":1190000,"d":"1,190,000.00"},{"$nulls":3},{"v":1000,"d":"1,000"},null,{"v":70000,"d":"70,000.00"},{"$nulls":3},{"v":18000,"d":"18,000"},null,{"v":1260000,"d":"1,260,000.00"}]
[{"v":8,"d":"08"},{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[{"v":9,"d":"09"},{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[10,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[11,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[12,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[13,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[14,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[15,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[16,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[17,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[18,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[19,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[20,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[21,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[22,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[23,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[24,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[25,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[26,{"$nulls":19},{"$f":"S36*P36","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"Y36*P36","v":{"v":0,"d":"0.00"}},{"$nulls":3},{"$f":"S36+Y36","v":0},null,{"$f":"AE36*P36","v":{"v":0,"d":"0.00"}}]
[27,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[28,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[29,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[30,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[31,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[32,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[33,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[34,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[35,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[36,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[37,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[38,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[39,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[40,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[41,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[42,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[43,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[44,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[45,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[46,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[47,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[48,{"$nulls":19},{"$f":"S58*P58","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"Y58*P58","v":{"v":0,"d":"0.00"}},{"$nulls":3},{"$f":"S58+Y58","v":0},null,{"$f":"AE58*P58","v":{"v":0,"d":"0.00"}}]
[49,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[50,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[51,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[52,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[53,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[54,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[55,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[56,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[57,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[58,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[59,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[60,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[61,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[62,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[63,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[64,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[65,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[66,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[67,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[68,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[69,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[70,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[71,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[72,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[73,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[74,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[75,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[76,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[77,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[78,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[79,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[80,{"$nulls":19},{"$f":"S90*P90","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"Y90*P90","v":{"v":0,"d":"0.00"}},{"$nulls":3},{"$f":"S90+Y90","v":0},null,{"$f":"AE90*P90","v":{"v":0,"d":"0.00"}}]
[81,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[82,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[83,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[84,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[85,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[86,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[87,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[88,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[89,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[90,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[91,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[92,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[93,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[94,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[95,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[96,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[97,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[98,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[99,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
[100,{"$nulls":19},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":3},0,null,{"v":0,"d":"0.00"}]
["Total:",{"$nulls":31},{"$f":"SUM(AG11:AJ110)","v":{"v":5633797.5,"d":"5,633,797.50"}}]
{"$rows_empty":22}
[{"$f":"\"All amounts in \"&'Summary Sheet'!$E$15&\".\"","v":"All amounts in USD."}]

{"sheet":"C-Variation","index":3,"n_rows":49,"n_cols":42,"rows_kept":49,"merged":[[0,0,0,3],[0,4,0,17],[0,18,1,35],[0,41,5,58],[1,0,1,3],[1,4,1,17],[2,0,2,3],[2,4,2,17],[2,18,2,21],[2,22,2,26],[2,27,2,30],[2,31,2,35],[3,0,3,3],[3,4,3,17],[3,18,3,21],[3,22,3,26],[3,27,3,30],[3,31,3,35],[4,0,4,3],[4,4,4,17],[4,18,5,21],[4,22,5,35],[5,0,5,3],[5,4,5,17],[6,0,7,35],[8,0,9,1],[8,2,9,9],[8,10,8,17],[8,18,8,23],[8,24,8,29],[8,30,8,35],[9,10,9,12],[9,13,9,14],[9,15,9,17],[9,18,9,19],[9,20,9,23],[9,24,9,25],[9,26,9,29],[9,30,9,31],[9,32,9,35],[10,0,10,1],[10,2,10,9],[10,10,10,12],[10,13,10,14],[10,15,10,17],[10,18,10,19],[10,20,10,23],[10,24,10,25],[10,26,10,29],[10,30,10,31],[10,32,10,35],[10,41,24,58],[11,0,11,1],[11,2,11,9],[11,10,11,12],[11,13,11,14],[11,15,11,17],[11,18,11,19],[11,20,11,23],[11,24,11,25],[11,26,11,29],[11,30,11,31],[11,32,11,35],[12,0,12,1],[12,2,12,9],[12,10,12,12],[12,13,12,14],[12,15,12,17],[12,18,12,19],[12,20,12,23],[12,24,12,25],[12,26,12,29],[12,30,12,31],[12,32,12,35],[13,0,13,1],[13,2,13,9],[13,10,13,12],[13,13,13,14],[13,15,13,17],[13,18,13,19],[13,20,13,23],[13,24,13,25],[13,26,13,29],[13,30,13,31],[13,32,13,35],[14,0,14,1],[14,2,14,9],[14,10,14,12],[14,13,14,14],[14,15,14,17],[14,18,14,19],[14,20,14,23],[14,24,14,25],[14,26,14,29],[14,30,14,31],[14,32,14,35],[15,0,15,1],[15,2,15,9],[15,10,15,12],[15,13,15,14],[15,15,15,17],[15,18,15,19],[15,20,15,23],[15,24,15,25],[15,26,15,29],[15,30,15,31],[15,32,15,35],[16,0,16,1],[16,2,16,9],[16,10,16,12],[16,13,16,14],[16,15,16,17],[16,18,16,19],[16,20,16,23],[16,24,16,25],[16,26,16,29],[16,30,16,31],[16,32,16,35],[17,0,17,1],[17,2,17,9],[17,10,17,12],[17,13,17,14],[17,15,17,17],[17,18,17,19],[17,20,17,23],[17,24,17,25],[17,26,17,29],[17,30,17,31],[17,32,17,35],[18,0,18,1],[18,2,18,9],[18,10,18,12],[18,13,18,14],[18,15,18,17],[18,18,18,19],[18,20,18,23],[18,24,18,25],[18,26,18,29],[18,30,18,31],[18,32,18,35],[19,0,19,1],[19,2,19,9],[19,10,19,12],[19,13,19,14],[19,15,19,17],[19,18,19,19],[19,20,19,23],[19,24,19,25],[19,26,19,29],[19,30,19,31],[19,32,19,35],[20,0,20,1],[20,2,20,9],[20,10,20,12],[20,13,20,14],[20,15,20,17],[20,18,20,19],[20,20,20,23],[20,24,20,25],[20,26,20,29],[20,30,20,31],[20,32,20,35],[21,0,21,1],[21,2,21,9],[21,10,21,12],[21,13,21,14],[21,15,21,17],[21,18,21,19],[21,20,21,23],[21,24,21,25],[21,26,21,29],[21,30,21,31],[21,32,21,35],[22,0,22,1],[22,2,22,9],[22,10,22,12],[22,13,22,14],[22,15,22,17],[22,18,22,19],[22,20,22,23],[22,24,22,25],[22,26,22,29],[22,30,22,31],[22,32,22,35],[23,0,23,1],[23,2,23,9],[23,10,23,12],[23,13,23,14],[23,15,23,17],[23,18,23,19],[23,20,23,23],[23,24,23,25],[23,26,23,29],[23,30,23,31],[23,32,23,35],[24,0,24,1],[24,2,24,9],[24,10,24,12],[24,13,24,14],[24,15,24,17],[24,18,24,19],[24,20,24,23],[24,24,24,25],[24,26,24,29],[24,30,24,31],[24,32,24,35],[25,0,25,31],[25,32,25,35],[48,0,48,35]]}
["Project",{"$nulls":3},{"$f":"'Summary Sheet'!E1","v":"[Project Name]"},{"$nulls":13},{"$f":"'Summary Sheet'!S1:AJ2","v":"Progress Payment Application (PPA)"},{"$nulls":22},"Updates Automatically from Summary Sheet"]
["Phase",{"$nulls":3},{"$f":"'Summary Sheet'!E2","v":"[Project Phase]"}]
["Client",{"$nulls":3},{"$f":"'Summary Sheet'!E3","v":"[Client]"},{"$nulls":13},"Proj. Mngr.",{"$nulls":3},{"$f":"'Summary Sheet'!W3","v":"[Project Mngr.]"},{"$nulls":4},"Month",{"$nulls":3},{"$f":"'Summary Sheet'!AF3","v":"2016-01-01"}]
["Client's Repres.",{"$nulls":3},{"$f":"'Summary Sheet'!E4","v":"[Client's Representative]"},{"$nulls":22},"PPC No.",{"$nulls":3},{"$f":"'Summary Sheet'!AF4","v":8}]
["Contractor",{"$nulls":3},{"$f":"'Summary Sheet'!E5","v":"[Contractor]"},{"$nulls":13},"Ref. No.",{"$nulls":3},{"$f":"'Summary Sheet'!W5","v":"XYZ-123-PPC-009-00 - December"}]
["Sub-Contractor",{"$nulls":3},{"$f":"'Summary Sheet'!E6","v":"[Sub-Contractor]"}]
["C) Variation(s) Summary"]
[]
["Item",null,"Description",{"$nulls":15},"Current Month",{"$nulls":5},"Previous Month",{"$nulls":5},"Total Var. Work Done"]
[{"$nulls":10},"QTY",null,null,"UOM",null,"Rate",null,null,"QTY",null,"Amount",{"$nulls":3},"QTY",null,"Amount",{"$nulls":3},"QTY",null,"Amount"]
[{"v":1,"d":"01"},null,"XYZ",{"$nulls":7},365,null,null,"lm",null,{"v":123,"d":"123.00"},null,null,17,null,{"$f":"S11*P11","v":{"v":2091,"d":"2,091.00"}},{"$nulls":3},12,null,{"$f":"Y11*P11","v":{"v":1476,"d":"1,476.00"}},{"$nulls":3},{"$f":"S11+Y11","v":29},null,{"$f":"AE11*P11","v":{"v":3567,"d":"3,567.00"}},{"$nulls":8},"Update this part"]
[{"v":2,"d":"02"}]
[{"v":3,"d":"03"}]
[{"v":4,"d":"04"}]
[{"v":5,"d":"05"}]
[{"v":6,"d":"06"}]
[{"v":7,"d":"07"}]
[{"v":8,"d":"08"}]
[{"v":9,"d":"09"}]
[10]
[11]
[12]
[13]
[14]
[15]
["Total:",{"$nulls":31},{"$f":"SUM(AG11:AJ25)","v":{"v":3567,"d":"3,567.00"}}]
{"$rows_empty":22}
[{"$f":"\"All amounts in \"&'Summary Sheet'!$E$15&\".\"","v":"All amounts in USD."}]

{"sheet":"D1-Advance Payment","index":4,"n_rows":49,"n_cols":42,"rows_kept":49,"merged":[[0,0,0,3],[0,4,0,17],[0,18,1,35],[0,41,5,58],[1,0,1,3],[1,4,1,17],[2,0,2,3],[2,4,2,17],[2,18,2,21],[2,22,2,26],[2,27,2,30],[2,31,2,35],[3,0,3,3],[3,4,3,17],[3,18,3,21],[3,22,3,26],[3,27,3,30],[3,31,3,35],[4,0,4,3],[4,4,4,17],[4,18,5,21],[4,22,5,35],[5,0,5,3],[5,4,5,17],[6,0,7,35],[8,0,9,20],[8,21,9,23],[8,24,9,27],[8,28,8,35],[8,41,25,58],[9,28,9,31],[9,32,9,35],[10,0,10,15],[10,16,10,20],[10,21,10,23],[10,24,10,27],[10,28,10,31],[10,32,10,35],[11,0,24,20],[11,21,11,23],[11,24,11,27],[11,28,11,31],[11,32,11,35],[12,21,12,23],[12,24,12,27],[12,28,12,31],[12,32,12,35],[13,21,13,23],[13,24,13,27],[13,28,13,31],[13,32,13,35],[14,21,14,23],[14,24,14,27],[14,28,14,31],[14,32,14,35],[15,21,15,23],[15,24,15,27],[15,28,15,31],[15,32,15,35],[16,21,16,23],[16,24,16,27],[16,28,16,31],[16,32,16,35],[17,21,17,23],[17,24,17,27],[17,28,17,31],[17,32,17,35],[18,21,18,23],[18,24,18,27],[18,28,18,31],[18,32,18,35],[19,21,19,23],[19,24,19,27],[19,28,19,31],[19,32,19,35],[20,21,20,23],[20,24,20,27],[20,28,20,31],[20,32,20,35],[21,21,21,23],[21,24,21,27],[21,28,21,31],[21,32,21,35],[22,21,22,23],[22,24,22,27],[22,28,22,31],[22,32,22,35],[23,21,23,23],[23,24,23,27],[23,28,23,31],[23,32,23,35],[24,21,24,23],[24,24,24,27],[24,28,24,31],[24,32,24,35],[25,0,25,31],[25,32,25,35],[48,0,48,35]]}
["Project",{"$nulls":3},{"$f":"'Summary Sheet'!E1","v":"[Project Name]"},{"$nulls":13},{"$f":"'Summary Sheet'!S1:AJ2","v":"Progress Payment Application (PPA)"},{"$nulls":22},"Updates Automatically from Summary Sheet"]
["Phase",{"$nulls":3},{"$f":"'Summary Sheet'!E2","v":"[Project Phase]"}]
["Client",{"$nulls":3},{"$f":"'Summary Sheet'!E3","v":"[Client]"},{"$nulls":13},"Proj. Mngr.",{"$nulls":3},{"$f":"'Summary Sheet'!W3","v":"[Project Mngr.]"},{"$nulls":4},"Month",{"$nulls":3},{"$f":"'Summary Sheet'!AF3","v":"2016-01-01"}]
["Client's Repres.",{"$nulls":3},{"$f":"'Summary Sheet'!E4","v":"[Client's Representative]"},{"$nulls":22},"PPC No.",{"$nulls":3},{"$f":"'Summary Sheet'!AF4","v":8}]
["Contractor",{"$nulls":3},{"$f":"'Summary Sheet'!E5","v":"[Contractor]"},{"$nulls":13},"Ref. No.",{"$nulls":3},{"$f":"'Summary Sheet'!W5","v":"XYZ-123-PPC-009-00 - December"}]
["Sub-Contractor",{"$nulls":3},{"$f":"'Summary Sheet'!E6","v":"[Sub-Contractor]"}]
["D.1) Advance Payment Amortization"]
[]
["Advance Amount",{"$nulls":20},"Amortiz.\nPeriod",null,null,"Progress Payment Claim",{"$nulls":3},"Adv. Payment Amortization",{"$nulls":12},"Nothing to fill here, everything updates automatically"]
[{"$nulls":28},"Rate",{"$nulls":3},"Amount"]
[{"$nulls":16},{"$f":"'Summary Sheet'!W12","v":{"v":750000,"d":"750,000.00"}},{"$nulls":4},{"$f":"'Summary Sheet'!AB13","v":6},null,null,1,{"$nulls":3},{"$f":"Y11/$V$11","v":{"v":0.16666666666666666,"d":"16.67%"}},{"$nulls":3},{"$f":"IF(Y11=\"\",\"\",IF(Y11<=$AF$4,$Q$11*AC11,\"\")*-1)","v":{"v":-125000,"d":"-125,000.00 "}}]
[{"$nulls":24},2,{"$nulls":3},{"$f":"IF(ISERROR((Y12/$V$11)-(Y11*AC11)),\"\",(Y12/$V$11)-(Y11*AC11))","v":{"v":0.16666666666666666,"d":"16.67%"}},{"$nulls":3},{"v":-125000,"d":"-125,000.00 "}]
[{"$nulls":24},{"$f":"IF(ISERROR(IF(Y12=$V$11,\"\",Y12+1)),\"\",IF(Y12=$AF$4,\"\",Y12+1))","v":3},{"$nulls":3},{"v":0.16666666666666669,"d":"16.67%"},{"$nulls":3},{"v":-125000.00000000001,"d":"-125,000.00 "}]
[{"$nulls":24},4,{"$nulls":3},{"v":0.16666666666666663,"d":"16.67%"},{"$nulls":3},{"v":-124999.99999999997,"d":"-125,000.00 "}]
[{"$nulls":24},5,{"$nulls":3},{"v":0.16666666666666685,"d":"16.67%"},{"$nulls":3},{"$f":"IF(Y15=\"\",\"\",IF(Y15<=$AF$4,$Q$11*AC15,\"\")*-1)","v":{"v":-125000.00000000015,"d":"-125,000.00 "}}]
[{"$nulls":24},6,{"$nulls":3},{"v":0.16666666666666574,"d":"16.67%"},{"$nulls":3},{"$f":"IF(Y16=\"\",\"\",IF(Y16<=$AF$4,$Q$11*AC16,\"\")*-1)","v":{"v":-124999.9999999993,"d":"-125,000.00 "}}]
{"$rows_empty":9}
["Total",{"$nulls":31},{"$f":"SUM(AG11:AJ25)","v":{"v":-749999.9999999994,"d":"-750,000.00 "}}]
{"$rows_empty":22}
[{"$f":"\"All amounts in \"&'Summary Sheet'!$E$15&\".\"","v":"All amounts in USD."}]

{"sheet":"D4-Previous Cert.","index":5,"n_rows":47,"n_cols":42,"rows_kept":47,"merged":[[0,0,0,3],[0,4,0,17],[0,18,1,35],[0,41,5,58],[1,0,1,3],[1,4,1,17],[2,0,2,3],[2,4,2,17],[2,18,2,21],[2,22,2,26],[2,27,2,30],[2,31,2,35],[3,0,3,3],[3,4,3,17],[3,18,3,21],[3,22,3,26],[3,27,3,30],[3,31,3,35],[4,0,4,3],[4,4,4,17],[4,18,5,21],[4,22,5,35],[5,0,5,3],[5,4,5,17],[6,0,7,35],[8,0,8,1],[8,2,8,29],[8,30,8,35],[9,0,9,1],[9,2,9,29],[9,30,9,35],[9,41,23,58],[10,0,10,1],[10,2,10,29],[10,30,10,35],[11,0,11,1],[11,2,11,29],[11,30,11,35],[12,0,12,1],[12,2,12,29],[12,30,12,35],[13,0,13,1],[13,2,13,29],[13,30,13,35],[14,0,14,1],[14,2,14,29],[14,30,14,35],[15,0,15,1],[15,2,15,29],[15,30,15,35],[16,0,16,1],[16,2,16,29],[16,30,16,35],[17,0,17,1],[17,2,17,29],[17,30,17,35],[18,0,18,1],[18,2,18,29],[18,30,18,35],[19,0,19,1],[19,2,19,29],[19,30,19,35],[20,0,20,1],[20,2,20,29],[20,30,20,35],[21,0,21,1],[21,2,21,29],[21,30,21,35],[22,0,22,1],[22,2,22,29],[22,30,22,35],[23,0,23,1],[23,2,23,29],[23,30,23,35],[46,0,46,35]]}
["Project",{"$nulls":3},{"$f":"'Summary Sheet'!E1","v":"[Project Name]"},{"$nulls":13},{"$f":"'Summary Sheet'!S1:AJ2","v":"Progress Payment Application (PPA)"},{"$nulls":22},"Updates Automatically from Summary Sheet"]
["Phase",{"$nulls":3},{"$f":"'Summary Sheet'!E2","v":"[Project Phase]"}]
["Client",{"$nulls":3},{"$f":"'Summary Sheet'!E3","v":"[Client]"},{"$nulls":13},"Proj. Mngr.",{"$nulls":3},{"$f":"'Summary Sheet'!W3","v":"[Project Mngr.]"},{"$nulls":4},"Month",{"$nulls":3},{"$f":"'Summary Sheet'!AF3","v":"2016-01-01"}]
["Client's Repres.",{"$nulls":3},{"$f":"'Summary Sheet'!E4","v":"[Client's Representative]"},{"$nulls":22},"PPC No.",{"$nulls":3},{"$f":"'Summary Sheet'!AF4","v":8}]
["Contractor",{"$nulls":3},{"$f":"'Summary Sheet'!E5","v":"[Contractor]"},{"$nulls":13},"Ref. No.",{"$nulls":3},{"$f":"'Summary Sheet'!W5","v":"XYZ-123-PPC-009-00 - December"}]
["Sub-Contractor",{"$nulls":3},{"$f":"'Summary Sheet'!E6","v":"[Sub-Contractor]"}]
["D.4) Previous Certified Amount"]
[]
["Item",null,"Progress Payment Claim",{"$nulls":27},"Previous Certified Amount"]
[1,null,"XYZ-123-PPC-001-00 - May",{"$nulls":27},{"v":100000,"d":"100,000.00"},{"$nulls":10},"Update this part"]
[2,null,"XYZ-123-PPC-002-00 - June",{"$nulls":27},{"v":210000,"d":"210,000.00"}]
[3,null,"XYZ-123-PPC-003-00 July",{"$nulls":27},{"v":280000,"d":"280,000.00"}]
[4,null,"XYZ-123-PPC-004-00 August",{"$nulls":27},{"v":590000,"d":"590,000.00"}]
[5,null,"XYZ-123-PPC-005-01 September",{"$nulls":27},{"v":890000,"d":"890,000.00"}]
[6,null,"XYZ-123-PPC-006-02 October",{"$nulls":27},{"v":1210000,"d":"1,210,000.00"}]
[7,null,"XYZ-123-PPC-007-00 November",{"$nulls":27},{"v":1530000,"d":"1,530,000.00"}]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
{"$rows_empty":22}
[{"$f":"\"All amounts in \"&'Summary Sheet'!$E$15&\".\"","v":"All amounts in USD."}]

{"sheet":"D5-Backcharges","index":6,"n_rows":47,"n_cols":42,"rows_kept":47,"merged":[[0,0,0,3],[0,4,0,17],[0,18,1,35],[0,41,5,58],[1,0,1,3],[1,4,1,17],[2,0,2,3],[2,4,2,17],[2,18,2,21],[2,22,2,26],[2,27,2,30],[2,31,2,35],[3,0,3,3],[3,4,3,17],[3,18,3,21],[3,22,3,26],[3,27,3,30],[3,31,3,35],[4,0,4,3],[4,4,4,17],[4,18,5,21],[4,22,5,35],[5,0,5,3],[5,4,5,17],[6,0,7,35],[8,0,8,1],[8,2,8,29],[8,30,8,35],[9,0,9,1],[9,2,9,29],[9,30,9,35],[9,41,23,58],[10,0,10,1],[10,2,10,29],[10,30,10,35],[11,0,11,1],[11,2,11,29],[11,30,11,35],[12,0,12,1],[12,2,12,29],[12,30,12,35],[13,0,13,1],[13,2,13,29],[13,30,13,35],[14,0,14,1],[14,2,14,29],[14,30,14,35],[15,0,15,1],[15,2,15,29],[15,30,15,35],[16,0,16,1],[16,2,16,29],[16,30,16,35],[17,0,17,1],[17,2,17,29],[17,30,17,35],[18,0,18,1],[18,2,18,29],[18,30,18,35],[19,0,19,1],[19,2,19,29],[19,30,19,35],[20,0,20,1],[20,2,20,29],[20,30,20,35],[21,0,21,1],[21,2,21,29],[21,30,21,35],[22,0,22,1],[22,2,22,29],[22,30,22,35],[23,0,23,1],[23,2,23,29],[23,30,23,35],[24,0,24,29],[24,30,24,35],[46,0,46,35]]}
["Project",{"$nulls":3},{"$f":"'Summary Sheet'!E1","v":"[Project Name]"},{"$nulls":13},{"$f":"'Summary Sheet'!S1:AJ2","v":"Progress Payment Application (PPA)"},{"$nulls":22},"Updates Automatically from Summary Sheet"]
["Phase",{"$nulls":3},{"$f":"'Summary Sheet'!E2","v":"[Project Phase]"}]
["Client",{"$nulls":3},{"$f":"'Summary Sheet'!E3","v":"[Client]"},{"$nulls":13},"Proj. Mngr.",{"$nulls":3},{"$f":"'Summary Sheet'!W3","v":"[Project Mngr.]"},{"$nulls":4},"Month",{"$nulls":3},{"$f":"'Summary Sheet'!AF3","v":"2016-01-01"}]
["Client's Repres.",{"$nulls":3},{"$f":"'Summary Sheet'!E4","v":"[Client's Representative]"},{"$nulls":22},"PPC No.",{"$nulls":3},{"$f":"'Summary Sheet'!AF4","v":8}]
["Contractor",{"$nulls":3},{"$f":"'Summary Sheet'!E5","v":"[Contractor]"},{"$nulls":13},"Ref. No.",{"$nulls":3},{"$f":"'Summary Sheet'!W5","v":"XYZ-123-PPC-009-00 - December"}]
["Sub-Contractor",{"$nulls":3},{"$f":"'Summary Sheet'!E6","v":"[Sub-Contractor]"}]
["D.5) Backcharges"]
[]
["Item",null,"Progress Payment Claim",{"$nulls":27},"Backcharges"]
[1,null,"Ref.-No. XYZ123 - Material Supply by Client",{"$nulls":27},{"v":-27500,"d":"-27,500.00 "},{"$nulls":10},"Fill Only this part"]
[2,null,"Ref.-No. XYZ456 - Service provided by Client",{"$nulls":27},{"v":-10000,"d":"-10,000.00 "}]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
["Total:",{"$nulls":29},{"$f":"SUM(AE10:AJ24)","v":{"v":-37500,"d":"-37,500.00 "}}]
{"$rows_empty":21}
[{"$f":"\"All amounts in \"&'Summary Sheet'!$E$15&\".\"","v":"All amounts in USD."}]

{"sheet":"D6-Material at Site","index":7,"n_rows":47,"n_cols":42,"rows_kept":47,"merged":[[0,0,0,3],[0,4,0,17],[0,18,1,35],[0,41,5,58],[1,0,1,3],[1,4,1,17],[2,0,2,3],[2,4,2,17],[2,18,2,21],[2,22,2,26],[2,27,2,30],[2,31,2,35],[3,0,3,3],[3,4,3,17],[3,18,3,21],[3,22,3,26],[3,27,3,30],[3,31,3,35],[4,0,4,3],[4,4,4,17],[4,18,5,21],[4,22,5,35],[5,0,5,3],[5,4,5,17],[6,0,7,35],[8,0,8,1],[8,2,8,29],[8,30,8,35],[9,0,9,1],[9,2,9,29],[9,30,9,35],[9,41,23,58],[10,0,10,1],[10,2,10,29],[10,30,10,35],[11,0,11,1],[11,2,11,29],[11,30,11,35],[12,0,12,1],[12,2,12,29],[12,30,12,35],[13,0,13,1],[13,2,13,29],[13,30,13,35],[14,0,14,1],[14,2,14,29],[14,30,14,35],[15,0,15,1],[15,2,15,29],[15,30,15,35],[16,0,16,1],[16,2,16,29],[16,30,16,35],[17,0,17,1],[17,2,17,29],[17,30,17,35],[18,0,18,1],[18,2,18,29],[18,30,18,35],[19,0,19,1],[19,2,19,29],[19,30,19,35],[20,0,20,1],[20,2,20,29],[20,30,20,35],[21,0,21,1],[21,2,21,29],[21,30,21,35],[22,0,22,1],[22,2,22,29],[22,30,22,35],[23,0,23,1],[23,2,23,29],[23,30,23,35],[24,0,24,29],[24,30,24,35],[46,0,46,35]]}
["Project",{"$nulls":3},{"$f":"'Summary Sheet'!E1","v":"[Project Name]"},{"$nulls":13},{"$f":"'Summary Sheet'!S1:AJ2","v":"Progress Payment Application (PPA)"},{"$nulls":22},"Updates Automatically from Summary Sheet"]
["Phase",{"$nulls":3},{"$f":"'Summary Sheet'!E2","v":"[Project Phase]"}]
["Client",{"$nulls":3},{"$f":"'Summary Sheet'!E3","v":"[Client]"},{"$nulls":13},"Proj. Mngr.",{"$nulls":3},{"$f":"'Summary Sheet'!W3","v":"[Project Mngr.]"},{"$nulls":4},"Month",{"$nulls":3},{"$f":"'Summary Sheet'!AF3","v":"2016-01-01"}]
["Client's Repres.",{"$nulls":3},{"$f":"'Summary Sheet'!E4","v":"[Client's Representative]"},{"$nulls":22},"PPC No.",{"$nulls":3},{"$f":"'Summary Sheet'!AF4","v":8}]
["Contractor",{"$nulls":3},{"$f":"'Summary Sheet'!E5","v":"[Contractor]"},{"$nulls":13},"Ref. No.",{"$nulls":3},{"$f":"'Summary Sheet'!W5","v":"XYZ-123-PPC-009-00 - December"}]
["Sub-Contractor",{"$nulls":3},{"$f":"'Summary Sheet'!E6","v":"[Sub-Contractor]"}]
["D.6) Material at Site"]
[]
["Item",null,"Progress Payment Claim",{"$nulls":27},"Value"]
[1,null,"ABC Material delivered at Site",{"$nulls":27},{"v":227500,"d":"227,500.00"},{"$nulls":10},"Update this part"]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
["Total:",{"$nulls":29},{"$f":"SUM(AE10:AJ24)","v":{"v":227500,"d":"227,500.00"}}]
{"$rows_empty":21}
[{"$f":"\"All amounts in \"&'Summary Sheet'!$E$15&\".\"","v":"All amounts in USD."}]