{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["read me","Dashboard","Summary","Prevention","Appraisal","Internal","External"],"not_rendered":{"charts":5,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"read me","index":0,"n_rows":20,"n_cols":1,"rows_kept":20,"merged":[[0,0,4,10],[8,0,9,10],[12,0,12,10],[15,0,16,10],[19,0,19,10]]}
["Read Me"]
[]
[]
[]
[]
[]
[]
["1)"]
["Dear User, thank you for using my template. Please remove sample entries from the sheets \"Prevention\", \"Appraisal\", \"Internal\" and \"External\"."]
[]
[]
["2)"]
["Enter the start date of your project in field \"D8\" on the \"Summary\". Other sheets will update automatically."]
[]
["3)"]
["Make your entries on the sheets \"Prevention\", \"Appraisal\", \"Internal\" and \"External\" only. The \"Summary\" and \"Dashboard\" will update from their."]
[]
[]
["4)"]
["Verify that all formulas are working as expected."]

{"sheet":"Dashboard","index":1,"n_rows":49,"n_cols":11,"rows_kept":49,"merged":[[0,10,10,11],[12,10,22,11],[24,10,34,11],[36,10,46,11],[48,10,58,11]]}
[{"$nulls":10},"The total Cost of Quality (CoQ) is the sum of below individual cost."]
{"$rows_empty":11}
[{"$nulls":10},{"$f":"Prevention!E1","v":"These are cost related to all activities to prevent defects from occurring and to keep appraisal and failure to a minimum."}]
{"$rows_empty":11}
[{"$nulls":10},{"$f":"Appraisal!E1","v":"These are costs incurred while monitoring and controlling. They include execution inspections, result control, field monitoring, supplier surveillance, material receipt inspection, and other planned activities to assure compliance with a certain requirement."}]
{"$rows_empty":11}
[{"$nulls":10},{"$f":"Internal!E1","v":"These are costs that would disappear if no defects existed prior to selivery to the client.\nThese costs include rework, scrap, re-check or re-inspection, corrective action, re-design, vendor defects, and other like defects.\n"}]
{"$rows_empty":11}
[{"$nulls":10},{"$f":"External!E1","v":"These are costs that would disappear if no defects existed in the product after delivery to the client.\nThese costs include warranty and repair costs, product liability, and product recall.\n\n"}]

{"sheet":"Summary","index":2,"n_rows":32,"n_cols":40,"rows_kept":32,"merged":[[1,0,5,0],[1,1,2,1],[3,1,4,1],[7,0,7,2],[9,0,13,0],[9,1,10,1],[11,1,12,1],[15,0,19,0],[15,1,16,1],[17,1,18,1],[21,0,25,0],[21,1,22,1],[23,1,24,1],[27,0,31,0],[27,1,28,1],[29,1,30,1]]}
[]
["Total","Budget","Month",{"$f":"D10+D16+D22+D28","v":{"v":2100,"d":"2,100"}},{"$f":"E10+E16+E22+E28","v":{"v":4100,"d":"4,100"}},{"v":4750,"d":"4,750"},{"v":5000,"d":"5,000"},{"v":5200,"d":"5,200"},{"v":5200,"d":"5,200"},{"v":5200,"d":"5,200"},{"v":4950,"d":"4,950"},{"v":4950,"d":"4,950"},{"v":4950,"d":"4,950"},{"v":4750,"d":"4,750"},{"v":4750,"d":"4,750"},{"v":4500,"d":"4,500"},{"v":4500,"d":"4,500"},{"v":4500,"d":"4,500"},{"v":4500,"d":"4,500"},{"v":4500,"d":"4,500"},{"v":4500,"d":"4,500"},{"v":4500,"d":"4,500"},{"v":4500,"d":"4,500"},{"v":4500,"d":"4,500"},{"v":4500,"d":"4,500"},{"v":4500,"d":"4,500"},{"v":4500,"d":"4,500"},{"v":4500,"d":"4,500"},{"v":4500,"d":"4,500"},{"v":4500,"d":"4,500"},{"v":4500,"d":"4,500"},{"v":4500,"d":"4,500"},{"v":4500,"d":"4,500"},{"v":4500,"d":"4,500"},{"v":2100,"d":"2,100"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"}]
[null,null,"Cum.",{"$f":"D2","v":{"v":2100,"d":"2,100"}},{"$f":"D3+E2","v":{"v":6200,"d":"6,200"}},{"$f":"E3+F2","v":{"v":10950,"d":"10,950"}},{"v":15950,"d":"15,950"},{"v":21150,"d":"21,150"},{"v":26350,"d":"26,350"},{"v":31550,"d":"31,550"},{"v":36500,"d":"36,500"},{"v":41450,"d":"41,450"},{"v":46400,"d":"46,400"},{"v":51150,"d":"51,150"},{"v":55900,"d":"55,900"},{"v":60400,"d":"60,400"},{"v":64900,"d":"64,900"},{"v":69400,"d":"69,400"},{"v":73900,"d":"73,900"},{"v":78400,"d":"78,400"},{"v":82900,"d":"82,900"},{"v":87400,"d":"87,400"},{"v":91900,"d":"91,900"},{"v":96400,"d":"96,400"},{"v":100900,"d":"100,900"},{"v":105400,"d":"105,400"},{"v":109900,"d":"109,900"},{"v":114400,"d":"114,400"},{"v":118900,"d":"118,900"},{"v":123400,"d":"123,400"},{"v":127900,"d":"127,900"},{"v":132400,"d":"132,400"},{"v":136900,"d":"136,900"},{"v":141400,"d":"141,400"},{"v":143500,"d":"143,500"},{"v":144500,"d":"144,500"},{"v":145500,"d":"145,500"},{"v":146500,"d":"146,500"},{"v":147500,"d":"147,500"},{"v":148500,"d":"148,500"}]
[null,"Actual Cost","Month",{"$f":"SUM(D12+D18+D24+D30)","v":{"v":1690,"d":"1,690"}},{"$f":"SUM(E12+E18+E24+E30)","v":{"v":3529,"d":"3,529"}},{"v":4710,"d":"4,710"},{"v":4305,"d":"4,305"},{"v":2630,"d":"2,630"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Cum.",{"$f":"D4","v":{"v":1690,"d":"1,690"}},{"$f":"D5+E4","v":{"v":5219,"d":"5,219"}},{"$f":"E5+F4","v":{"v":9929,"d":"9,929"}},{"v":14234,"d":"14,234"},{"v":16864,"d":"16,864"},{"v":16864,"d":"16,864"},{"v":16864,"d":"16,864"},{"v":16864,"d":"16,864"},{"v":16864,"d":"16,864"},{"v":16864,"d":"16,864"},{"v":16864,"d":"16,864"},{"v":16864,"d":"16,864"},{"v":16864,"d":"16,864"},{"v":16864,"d":"16,864"},{"v":16864,"d":"16,864"},{"v":16864,"d":"16,864"},{"v":16864,"d":"16,864"},{"v":16864,"d":"16,864"},{"v":16864,"d":"16,864"},{"v":16864,"d":"16,864"},{"v":16864,"d":"16,864"},{"v":16864,"d":"16,864"},{"v":16864,"d":"16,864"},{"v":16864,"d":"16,864"},{"v":16864,"d":"16,864"},{"v":16864,"d":"16,864"},{"v":16864,"d":"16,864"},{"v":16864,"d":"16,864"},{"v":16864,"d":"16,864"},{"v":16864,"d":"16,864"},{"v":16864,"d":"16,864"},{"v":16864,"d":"16,864"},{"v":16864,"d":"16,864"},{"v":16864,"d":"16,864"},{"v":16864,"d":"16,864"},{"v":16864,"d":"16,864"},{"v":16864,"d":"16,864"}]
[null,null,"Avail.",{"$f":"D3-D5","v":410},{"$f":"E3-E5","v":981},{"v":1021,"d":"1,021"},{"v":1716,"d":"1,716"},{"v":4286,"d":"4,286"},{"v":9486,"d":"9,486"},{"v":14686,"d":"14,686"},{"v":19636,"d":"19,636"},{"v":24586,"d":"24,586"},{"v":29536,"d":"29,536"},{"v":34286,"d":"34,286"},{"v":39036,"d":"39,036"},{"v":43536,"d":"43,536"},{"v":48036,"d":"48,036"},{"v":52536,"d":"52,536"},{"v":57036,"d":"57,036"},{"v":61536,"d":"61,536"},{"v":66036,"d":"66,036"},{"v":70536,"d":"70,536"},{"v":75036,"d":"75,036"},{"v":79536,"d":"79,536"},{"v":84036,"d":"84,036"},{"v":88536,"d":"88,536"},{"v":93036,"d":"93,036"},{"v":97536,"d":"97,536"},{"v":102036,"d":"102,036"},{"v":106536,"d":"106,536"},{"v":111036,"d":"111,036"},{"v":115536,"d":"115,536"},{"v":120036,"d":"120,036"},{"v":124536,"d":"124,536"},{"v":126636,"d":"126,636"},{"v":127636,"d":"127,636"},{"v":128636,"d":"128,636"},{"v":129636,"d":"129,636"},{"v":130636,"d":"130,636"},{"v":131636,"d":"131,636"}]
[]
[{"$nulls":3},"2014-07-01",{"$f":"DATE(YEAR(D8),MONTH(D8)+1,DAY(D8))","v":"2014-08-01"},{"$f":"EDATE(E8,1)","v":"2014-09-01"},"2014-10-01","2014-11-01","2014-12-01","2015-01-01","2015-02-01","2015-03-01","2015-04-01","2015-05-01","2015-06-01","2015-07-01","2015-08-01","2015-09-01","2015-10-01","2015-11-01","2015-12-01","2016-01-01","2016-02-01","2016-03-01","2016-04-01","2016-05-01","2016-06-01","2016-07-01","2016-08-01","2016-09-01","2016-10-01","2016-11-01","2016-12-01","2017-01-01","2017-02-01","2017-03-01","2017-04-01","2017-05-01","2017-06-01","2017-07-01"]
[]
["Prevention","Budget","Month",{"$f":"Prevention!E6","v":100},{"$f":"Prevention!F6","v":100},{"$f":"Prevention!G6","v":250},{"$f":"Prevention!H6","v":500},{"$f":"Prevention!I6","v":700},{"$f":"Prevention!J6","v":700},{"$f":"Prevention!K6","v":700},{"$f":"Prevention!L6","v":700},{"$f":"Prevention!M6","v":700},{"$f":"Prevention!N6","v":700},{"$f":"Prevention!O6","v":500},{"$f":"Prevention!P6","v":500},{"$f":"Prevention!Q6","v":500},{"$f":"Prevention!R6","v":500},{"$f":"Prevention!S6","v":500},{"$f":"Prevention!T6","v":500},{"$f":"Prevention!U6","v":500},{"$f":"Prevention!V6","v":500},{"$f":"Prevention!W6","v":500},{"$f":"Prevention!X6","v":500},{"$f":"Prevention!Y6","v":500},{"$f":"Prevention!Z6","v":500},{"$f":"Prevention!AA6","v":500},{"$f":"Prevention!AB6","v":500},{"$f":"Prevention!AC6","v":500},{"$f":"Prevention!AD6","v":500},{"$f":"Prevention!AE6","v":500},{"$f":"Prevention!AF6","v":500},{"$f":"Prevention!AG6","v":500},{"$f":"Prevention!AH6","v":500},{"$f":"Prevention!AI6","v":500},{"$f":"Prevention!AJ6","v":100},{"$f":"Prevention!AK6","v":0},{"$f":"Prevention!AL6","v":0},{"$f":"Prevention!AM6","v":0},{"$f":"Prevention!AN6","v":0},{"$f":"Prevention!AO6","v":0}]
[null,null,"Cum.",{"$f":"D10","v":100},{"$f":"D11+E10","v":200},{"$f":"E11+F10","v":450},950,{"v":1650,"d":"1,650"},{"v":2350,"d":"2,350"},{"v":3050,"d":"3,050"},{"v":3750,"d":"3,750"},{"v":4450,"d":"4,450"},{"v":5150,"d":"5,150"},{"v":5650,"d":"5,650"},{"v":6150,"d":"6,150"},{"v":6650,"d":"6,650"},{"v":7150,"d":"7,150"},{"v":7650,"d":"7,650"},{"v":8150,"d":"8,150"},{"v":8650,"d":"8,650"},{"v":9150,"d":"9,150"},{"v":9650,"d":"9,650"},{"v":10150,"d":"10,150"},{"v":10650,"d":"10,650"},{"v":11150,"d":"11,150"},{"v":11650,"d":"11,650"},{"v":12150,"d":"12,150"},{"v":12650,"d":"12,650"},{"v":13150,"d":"13,150"},{"v":13650,"d":"13,650"},{"v":14150,"d":"14,150"},{"v":14650,"d":"14,650"},{"v":15150,"d":"15,150"},{"v":15650,"d":"15,650"},{"v":15750,"d":"15,750"},{"v":15750,"d":"15,750"},{"v":15750,"d":"15,750"},{"v":15750,"d":"15,750"},{"v":15750,"d":"15,750"},{"v":15750,"d":"15,750"}]
[null,"Actual Cost","Month",{"$f":"Prevention!E7","v":90},{"$f":"Prevention!F7","v":89},{"$f":"Prevention!G7","v":210},{"$f":"Prevention!H7","v":455},{"$f":"Prevention!I7","v":640},{"$f":"Prevention!J7","v":0},{"$f":"Prevention!K7","v":0},{"$f":"Prevention!L7","v":0},{"$f":"Prevention!M7","v":0},{"$f":"Prevention!N7","v":0},{"$f":"Prevention!O7","v":0},{"$f":"Prevention!P7","v":0},{"$f":"Prevention!Q7","v":0},{"$f":"Prevention!R7","v":0},{"$f":"Prevention!S7","v":0},{"$f":"Prevention!T7","v":0},{"$f":"Prevention!U7","v":0},{"$f":"Prevention!V7","v":0},{"$f":"Prevention!W7","v":0},{"$f":"Prevention!X7","v":0},{"$f":"Prevention!Y7","v":0},{"$f":"Prevention!Z7","v":0},{"$f":"Prevention!AA7","v":0},{"$f":"Prevention!AB7","v":0},{"$f":"Prevention!AC7","v":0},{"$f":"Prevention!AD7","v":0},{"$f":"Prevention!AE7","v":0},{"$f":"Prevention!AF7","v":0},{"$f":"Prevention!AG7","v":0},{"$f":"Prevention!AH7","v":0},{"$f":"Prevention!AI7","v":0},{"$f":"Prevention!AJ7","v":0},{"$f":"Prevention!AK7","v":0},{"$f":"Prevention!AL7","v":0},{"$f":"Prevention!AM7","v":0},{"$f":"Prevention!AN7","v":0},{"$f":"Prevention!AO7","v":0}]
[null,null,"Cum.",{"$f":"D12","v":90},{"$f":"D13+E12","v":179},{"$f":"E13+F12","v":389},844,{"v":1484,"d":"1,484"},{"v":1484,"d":"1,484"},{"v":1484,"d":"1,484"},{"v":1484,"d":"1,484"},{"v":1484,"d":"1,484"},{"v":1484,"d":"1,484"},{"v":1484,"d":"1,484"},{"v":1484,"d":"1,484"},{"v":1484,"d":"1,484"},{"v":1484,"d":"1,484"},{"v":1484,"d":"1,484"},{"v":1484,"d":"1,484"},{"v":1484,"d":"1,484"},{"v":1484,"d":"1,484"},{"v":1484,"d":"1,484"},{"v":1484,"d":"1,484"},{"v":1484,"d":"1,484"},{"v":1484,"d":"1,484"},{"v":1484,"d":"1,484"},{"v":1484,"d":"1,484"},{"v":1484,"d":"1,484"},{"v":1484,"d":"1,484"},{"v":1484,"d":"1,484"},{"v":1484,"d":"1,484"},{"v":1484,"d":"1,484"},{"v":1484,"d":"1,484"},{"v":1484,"d":"1,484"},{"v":1484,"d":"1,484"},{"v":1484,"d":"1,484"},{"v":1484,"d":"1,484"},{"v":1484,"d":"1,484"},{"v":1484,"d":"1,484"},{"v":1484,"d":"1,484"}]
[null,null,"Avail.",{"$f":"D11-D13","v":10},{"$f":"E11-E13","v":21},{"$f":"F11-F13","v":61},106,166,866,{"v":1566,"d":"1,566"},{"v":2266,"d":"2,266"},{"v":2966,"d":"2,966"},{"v":3666,"d":"3,666"},{"v":4166,"d":"4,166"},{"v":4666,"d":"4,666"},{"v":5166,"d":"5,166"},{"v":5666,"d":"5,666"},{"v":6166,"d":"6,166"},{"v":6666,"d":"6,666"},{"v":7166,"d":"7,166"},{"v":7666,"d":"7,666"},{"v":8166,"d":"8,166"},{"v":8666,"d":"8,666"},{"v":9166,"d":"9,166"},{"v":9666,"d":"9,666"},{"v":10166,"d":"10,166"},{"v":10666,"d":"10,666"},{"v":11166,"d":"11,166"},{"v":11666,"d":"11,666"},{"v":12166,"d":"12,166"},{"v":12666,"d":"12,666"},{"v":13166,"d":"13,166"},{"v":13666,"d":"13,666"},{"v":14166,"d":"14,166"},{"v":14266,"d":"14,266"},{"v":14266,"d":"14,266"},{"v":14266,"d":"14,266"},{"v":14266,"d":"14,266"},{"v":14266,"d":"14,266"},{"v":14266,"d":"14,266"}]
[]
["Appraisal","Budget","Month",{"$f":"Appraisal!E6","v":{"v":1000,"d":"1,000"}},{"$f":"Appraisal!F6","v":{"v":3000,"d":"3,000"}},{"$f":"Appraisal!G6","v":{"v":3000,"d":"3,000"}},{"$f":"Appraisal!H6","v":{"v":3000,"d":"3,000"}},{"$f":"Appraisal!I6","v":{"v":3000,"d":"3,000"}},{"$f":"Appraisal!J6","v":{"v":3000,"d":"3,000"}},{"$f":"Appraisal!K6","v":{"v":3000,"d":"3,000"}},{"$f":"Appraisal!L6","v":{"v":3000,"d":"3,000"}},{"$f":"Appraisal!M6","v":{"v":3000,"d":"3,000"}},{"$f":"Appraisal!N6","v":{"v":3000,"d":"3,000"}},{"$f":"Appraisal!O6","v":{"v":3000,"d":"3,000"}},{"$f":"Appraisal!P6","v":{"v":3000,"d":"3,000"}},{"$f":"Appraisal!Q6","v":{"v":3000,"d":"3,000"}},{"$f":"Appraisal!R6","v":{"v":3000,"d":"3,000"}},{"$f":"Appraisal!S6","v":{"v":3000,"d":"3,000"}},{"$f":"Appraisal!T6","v":{"v":3000,"d":"3,000"}},{"$f":"Appraisal!U6","v":{"v":3000,"d":"3,000"}},{"$f":"Appraisal!V6","v":{"v":3000,"d":"3,000"}},{"$f":"Appraisal!W6","v":{"v":3000,"d":"3,000"}},{"$f":"Appraisal!X6","v":{"v":3000,"d":"3,000"}},{"$f":"Appraisal!Y6","v":{"v":3000,"d":"3,000"}},{"$f":"Appraisal!Z6","v":{"v":3000,"d":"3,000"}},{"$f":"Appraisal!AA6","v":{"v":3000,"d":"3,000"}},{"$f":"Appraisal!AB6","v":{"v":3000,"d":"3,000"}},{"$f":"Appraisal!AC6","v":{"v":3000,"d":"3,000"}},{"$f":"Appraisal!AD6","v":{"v":3000,"d":"3,000"}},{"$f":"Appraisal!AE6","v":{"v":3000,"d":"3,000"}},{"$f":"Appraisal!AF6","v":{"v":3000,"d":"3,000"}},{"$f":"Appraisal!AG6","v":{"v":3000,"d":"3,000"}},{"$f":"Appraisal!AH6","v":{"v":3000,"d":"3,000"}},{"$f":"Appraisal!AI6","v":{"v":3000,"d":"3,000"}},{"$f":"Appraisal!AJ6","v":{"v":1000,"d":"1,000"}},{"$f":"Appraisal!AK6","v":0},{"$f":"Appraisal!AL6","v":0},{"$f":"Appraisal!AM6","v":0},{"$f":"Appraisal!AN6","v":0},{"$f":"Appraisal!AO6","v":0}]
[null,null,"Cum.",{"$f":"D16","v":{"v":1000,"d":"1,000"}},{"$f":"D17+E16","v":{"v":4000,"d":"4,000"}},{"$f":"E17+F16","v":{"v":7000,"d":"7,000"}},{"v":10000,"d":"10,000"},{"v":13000,"d":"13,000"},{"v":16000,"d":"16,000"},{"v":19000,"d":"19,000"},{"v":22000,"d":"22,000"},{"v":25000,"d":"25,000"},{"v":28000,"d":"28,000"},{"v":31000,"d":"31,000"},{"v":34000,"d":"34,000"},{"v":37000,"d":"37,000"},{"v":40000,"d":"40,000"},{"v":43000,"d":"43,000"},{"v":46000,"d":"46,000"},{"v":49000,"d":"49,000"},{"v":52000,"d":"52,000"},{"v":55000,"d":"55,000"},{"v":58000,"d":"58,000"},{"v":61000,"d":"61,000"},{"v":64000,"d":"64,000"},{"v":67000,"d":"67,000"},{"v":70000,"d":"70,000"},{"v":73000,"d":"73,000"},{"v":76000,"d":"76,000"},{"v":79000,"d":"79,000"},{"v":82000,"d":"82,000"},{"v":85000,"d":"85,000"},{"v":88000,"d":"88,000"},{"v":91000,"d":"91,000"},{"v":92000,"d":"92,000"},{"v":92000,"d":"92,000"},{"v":92000,"d":"92,000"},{"v":92000,"d":"92,000"},{"v":92000,"d":"92,000"},{"v":92000,"d":"92,000"}]
[null,"Actual Cost","Month",{"$f":"Appraisal!E7","v":900},{"$f":"Appraisal!F7","v":{"v":2790,"d":"2,790"}},{"$f":"Appraisal!G7","v":{"v":3100,"d":"3,100"}},{"$f":"Appraisal!H7","v":{"v":2950,"d":"2,950"}},{"$f":"Appraisal!I7","v":{"v":1990,"d":"1,990"}},{"$f":"Appraisal!J7","v":0},{"$f":"Appraisal!K7","v":0},{"$f":"Appraisal!L7","v":0},{"$f":"Appraisal!M7","v":0},{"$f":"Appraisal!N7","v":0},{"$f":"Appraisal!O7","v":0},{"$f":"Appraisal!P7","v":0},{"$f":"Appraisal!Q7","v":0},{"$f":"Appraisal!R7","v":0},{"$f":"Appraisal!S7","v":0},{"$f":"Appraisal!T7","v":0},{"$f":"Appraisal!U7","v":0},{"$f":"Appraisal!V7","v":0},{"$f":"Appraisal!W7","v":0},{"$f":"Appraisal!X7","v":0},{"$f":"Appraisal!Y7","v":0},{"$f":"Appraisal!Z7","v":0},{"$f":"Appraisal!AA7","v":0},{"$f":"Appraisal!AB7","v":0},{"$f":"Appraisal!AC7","v":0},{"$f":"Appraisal!AD7","v":0},{"$f":"Appraisal!AE7","v":0},{"$f":"Appraisal!AF7","v":0},{"$f":"Appraisal!AG7","v":0},{"$f":"Appraisal!AH7","v":0},{"$f":"Appraisal!AI7","v":0},{"$f":"Appraisal!AJ7","v":0},{"$f":"Appraisal!AK7","v":0},{"$f":"Appraisal!AL7","v":0},{"$f":"Appraisal!AM7","v":0},{"$f":"Appraisal!AN7","v":0},{"$f":"Appraisal!AO7","v":0}]
[null,null,"Cum.",{"$f":"D18","v":900},{"$f":"D19+E18","v":{"v":3690,"d":"3,690"}},{"$f":"E19+F18","v":{"v":6790,"d":"6,790"}},{"v":9740,"d":"9,740"},{"v":11730,"d":"11,730"},{"v":11730,"d":"11,730"},{"v":11730,"d":"11,730"},{"v":11730,"d":"11,730"},{"v":11730,"d":"11,730"},{"v":11730,"d":"11,730"},{"v":11730,"d":"11,730"},{"v":11730,"d":"11,730"},{"v":11730,"d":"11,730"},{"v":11730,"d":"11,730"},{"v":11730,"d":"11,730"},{"v":11730,"d":"11,730"},{"v":11730,"d":"11,730"},{"v":11730,"d":"11,730"},{"v":11730,"d":"11,730"},{"v":11730,"d":"11,730"},{"v":11730,"d":"11,730"},{"v":11730,"d":"11,730"},{"v":11730,"d":"11,730"},{"v":11730,"d":"11,730"},{"v":11730,"d":"11,730"},{"v":11730,"d":"11,730"},{"v":11730,"d":"11,730"},{"v":11730,"d":"11,730"},{"v":11730,"d":"11,730"},{"v":11730,"d":"11,730"},{"v":11730,"d":"11,730"},{"v":11730,"d":"11,730"},{"v":11730,"d":"11,730"},{"v":11730,"d":"11,730"},{"v":11730,"d":"11,730"},{"v":11730,"d":"11,730"},{"$f":"AM19+AN18","v":{"v":11730,"d":"11,730"}}]
[null,null,"Avail.",{"$f":"D16-D18","v":100},{"$f":"E16-E18","v":210},{"v":-100,"d":"-100 "},50,{"v":1010,"d":"1,010"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":1000,"d":"1,000"},0,0,0,0,0]
[]
["Internal","Budget","Month",{"$f":"Internal!E6","v":{"v":1000,"d":"1,000"}},{"$f":"Internal!F6","v":{"v":1000,"d":"1,000"}},{"$f":"Internal!G6","v":{"v":1500,"d":"1,500"}},{"$f":"Internal!H6","v":{"v":1500,"d":"1,500"}},{"$f":"Internal!I6","v":{"v":1500,"d":"1,500"}},{"$f":"Internal!J6","v":{"v":1500,"d":"1,500"}},{"$f":"Internal!K6","v":{"v":1500,"d":"1,500"}},{"$f":"Internal!L6","v":{"v":1250,"d":"1,250"}},{"$f":"Internal!M6","v":{"v":1250,"d":"1,250"}},{"$f":"Internal!N6","v":{"v":1250,"d":"1,250"}},{"$f":"Internal!O6","v":{"v":1250,"d":"1,250"}},{"$f":"Internal!P6","v":{"v":1250,"d":"1,250"}},{"$f":"Internal!Q6","v":{"v":1000,"d":"1,000"}},{"$f":"Internal!R6","v":{"v":1000,"d":"1,000"}},{"$f":"Internal!S6","v":{"v":1000,"d":"1,000"}},{"$f":"Internal!T6","v":{"v":1000,"d":"1,000"}},{"$f":"Internal!U6","v":{"v":1000,"d":"1,000"}},{"$f":"Internal!V6","v":{"v":1000,"d":"1,000"}},{"$f":"Internal!W6","v":{"v":1000,"d":"1,000"}},{"$f":"Internal!X6","v":{"v":1000,"d":"1,000"}},{"$f":"Internal!Y6","v":{"v":1000,"d":"1,000"}},{"$f":"Internal!Z6","v":{"v":1000,"d":"1,000"}},{"$f":"Internal!AA6","v":{"v":1000,"d":"1,000"}},{"$f":"Internal!AB6","v":{"v":1000,"d":"1,000"}},{"$f":"Internal!AC6","v":{"v":1000,"d":"1,000"}},{"$f":"Internal!AD6","v":{"v":1000,"d":"1,000"}},{"$f":"Internal!AE6","v":{"v":1000,"d":"1,000"}},{"$f":"Internal!AF6","v":{"v":1000,"d":"1,000"}},{"$f":"Internal!AG6","v":{"v":1000,"d":"1,000"}},{"$f":"Internal!AH6","v":{"v":1000,"d":"1,000"}},{"$f":"Internal!AI6","v":{"v":1000,"d":"1,000"}},{"$f":"Internal!AJ6","v":{"v":1000,"d":"1,000"}},{"$f":"Internal!AK6","v":{"v":1000,"d":"1,000"}},{"$f":"Internal!AL6","v":{"v":1000,"d":"1,000"}},{"$f":"Internal!AM6","v":{"v":1000,"d":"1,000"}},{"$f":"Internal!AN6","v":{"v":1000,"d":"1,000"}},{"$f":"Internal!AO6","v":{"v":1000,"d":"1,000"}}]
[null,null,"Cum.",{"$f":"D22","v":{"v":1000,"d":"1,000"}},{"$f":"D23+E22","v":{"v":2000,"d":"2,000"}},{"$f":"E23+F22","v":{"v":3500,"d":"3,500"}},{"v":5000,"d":"5,000"},{"v":6500,"d":"6,500"},{"v":8000,"d":"8,000"},{"v":9500,"d":"9,500"},{"v":10750,"d":"10,750"},{"v":12000,"d":"12,000"},{"v":13250,"d":"13,250"},{"v":14500,"d":"14,500"},{"v":15750,"d":"15,750"},{"v":16750,"d":"16,750"},{"v":17750,"d":"17,750"},{"v":18750,"d":"18,750"},{"v":19750,"d":"19,750"},{"v":20750,"d":"20,750"},{"v":21750,"d":"21,750"},{"v":22750,"d":"22,750"},{"v":23750,"d":"23,750"},{"v":24750,"d":"24,750"},{"v":25750,"d":"25,750"},{"v":26750,"d":"26,750"},{"v":27750,"d":"27,750"},{"v":28750,"d":"28,750"},{"v":29750,"d":"29,750"},{"v":30750,"d":"30,750"},{"v":31750,"d":"31,750"},{"v":32750,"d":"32,750"},{"v":33750,"d":"33,750"},{"v":34750,"d":"34,750"},{"v":35750,"d":"35,750"},{"v":36750,"d":"36,750"},{"v":37750,"d":"37,750"},{"v":38750,"d":"38,750"},{"v":39750,"d":"39,750"},{"$f":"AM23+AN22","v":{"v":40750,"d":"40,750"}}]
[null,"Actual Cost","Month",{"$f":"Internal!E7","v":700},{"$f":"Internal!F7","v":650},{"$f":"Internal!G7","v":{"v":1400,"d":"1,400"}},{"$f":"Internal!H7","v":900},{"$f":"Internal!I7","v":0},{"$f":"Internal!J7","v":0},{"$f":"Internal!K7","v":0},{"$f":"Internal!L7","v":0},{"$f":"Internal!M7","v":0},{"$f":"Internal!N7","v":0},{"$f":"Internal!O7","v":0},{"$f":"Internal!P7","v":0},{"$f":"Internal!Q7","v":0},{"$f":"Internal!R7","v":0},{"$f":"Internal!S7","v":0},{"$f":"Internal!T7","v":0},{"$f":"Internal!U7","v":0},{"$f":"Internal!V7","v":0},{"$f":"Internal!W7","v":0},{"$f":"Internal!X7","v":0},{"$f":"Internal!Y7","v":0},{"$f":"Internal!Z7","v":0},{"$f":"Internal!AA7","v":0},{"$f":"Internal!AB7","v":0},{"$f":"Internal!AC7","v":0},{"$f":"Internal!AD7","v":0},{"$f":"Internal!AE7","v":0},{"$f":"Internal!AF7","v":0},{"$f":"Internal!AG7","v":0},{"$f":"Internal!AH7","v":0},{"$f":"Internal!AI7","v":0},{"$f":"Internal!AJ7","v":0},{"$f":"Internal!AK7","v":0},{"$f":"Internal!AL7","v":0},{"$f":"Internal!AM7","v":0},{"$f":"Internal!AN7","v":0},{"$f":"Internal!AO7","v":0}]
[null,null,"Cum.",{"$f":"D24","v":700},{"$f":"D25+E24","v":{"v":1350,"d":"1,350"}},{"$f":"E25+F24","v":{"v":2750,"d":"2,750"}},{"v":3650,"d":"3,650"},{"v":3650,"d":"3,650"},{"v":3650,"d":"3,650"},{"v":3650,"d":"3,650"},{"v":3650,"d":"3,650"},{"v":3650,"d":"3,650"},{"v":3650,"d":"3,650"},{"v":3650,"d":"3,650"},{"v":3650,"d":"3,650"},{"v":3650,"d":"3,650"},{"v":3650,"d":"3,650"},{"v":3650,"d":"3,650"},{"v":3650,"d":"3,650"},{"v":3650,"d":"3,650"},{"v":3650,"d":"3,650"},{"v":3650,"d":"3,650"},{"v":3650,"d":"3,650"},{"v":3650,"d":"3,650"},{"v":3650,"d":"3,650"},{"v":3650,"d":"3,650"},{"v":3650,"d":"3,650"},{"v":3650,"d":"3,650"},{"v":3650,"d":"3,650"},{"v":3650,"d":"3,650"},{"v":3650,"d":"3,650"},{"v":3650,"d":"3,650"},{"v":3650,"d":"3,650"},{"v":3650,"d":"3,650"},{"v":3650,"d":"3,650"},{"v":3650,"d":"3,650"},{"v":3650,"d":"3,650"},{"v":3650,"d":"3,650"},{"v":3650,"d":"3,650"},{"$f":"AM25+AN24","v":{"v":3650,"d":"3,650"}}]
[null,null,"Avail.",{"$f":"D22-D24","v":300},{"$f":"E22-E24","v":350},{"$f":"F22-F24","v":100},{"$f":"G22-G24","v":600},{"$f":"H22-H24","v":{"v":1500,"d":"1,500"}},{"$f":"I22-I24","v":{"v":1500,"d":"1,500"}},{"$f":"J22-J24","v":{"v":1500,"d":"1,500"}},{"$f":"K22-K24","v":{"v":1250,"d":"1,250"}},{"$f":"L22-L24","v":{"v":1250,"d":"1,250"}},{"$f":"M22-M24","v":{"v":1250,"d":"1,250"}},{"$f":"N22-N24","v":{"v":1250,"d":"1,250"}},{"$f":"O22-O24","v":{"v":1250,"d":"1,250"}},{"$f":"P22-P24","v":{"v":1000,"d":"1,000"}},{"$f":"Q22-Q24","v":{"v":1000,"d":"1,000"}},{"$f":"R22-R24","v":{"v":1000,"d":"1,000"}},{"$f":"S22-S24","v":{"v":1000,"d":"1,000"}},{"$f":"T22-T24","v":{"v":1000,"d":"1,000"}},{"$f":"U22-U24","v":{"v":1000,"d":"1,000"}},{"$f":"V22-V24","v":{"v":1000,"d":"1,000"}},{"$f":"W22-W24","v":{"v":1000,"d":"1,000"}},{"$f":"X22-X24","v":{"v":1000,"d":"1,000"}},{"$f":"Y22-Y24","v":{"v":1000,"d":"1,000"}},{"$f":"Z22-Z24","v":{"v":1000,"d":"1,000"}},{"$f":"AA22-AA24","v":{"v":1000,"d":"1,000"}},{"$f":"AB22-AB24","v":{"v":1000,"d":"1,000"}},{"$f":"AC22-AC24","v":{"v":1000,"d":"1,000"}},{"$f":"AD22-AD24","v":{"v":1000,"d":"1,000"}},{"$f":"AE22-AE24","v":{"v":1000,"d":"1,000"}},{"$f":"AF22-AF24","v":{"v":1000,"d":"1,000"}},{"$f":"AG22-AG24","v":{"v":1000,"d":"1,000"}},{"$f":"AH22-AH24","v":{"v":1000,"d":"1,000"}},{"$f":"AI22-AI24","v":{"v":1000,"d":"1,000"}},{"$f":"AJ22-AJ24","v":{"v":1000,"d":"1,000"}},{"$f":"AK22-AK24","v":{"v":1000,"d":"1,000"}},{"$f":"AL22-AL24","v":{"v":1000,"d":"1,000"}},{"$f":"AM22-AM24","v":{"v":1000,"d":"1,000"}},{"$f":"AN22-AN24","v":{"v":1000,"d":"1,000"}}]
[]
["External","Budget","Month",{"$f":"External!E6","v":0},{"$f":"External!F6","v":0},{"$f":"External!G6","v":0},{"$f":"External!H6","v":0},{"$f":"External!I6","v":0},{"$f":"External!J6","v":0},{"$f":"External!K6","v":0},{"$f":"External!L6","v":0},{"$f":"External!M6","v":0},{"$f":"External!N6","v":0},{"$f":"External!O6","v":0},{"$f":"External!P6","v":0},{"$f":"External!Q6","v":0},{"$f":"External!R6","v":0},{"$f":"External!S6","v":0},{"$f":"External!T6","v":0},{"$f":"External!U6","v":0},{"$f":"External!V6","v":0},{"$f":"External!W6","v":0},{"$f":"External!X6","v":0},{"$f":"External!Y6","v":0},{"$f":"External!Z6","v":0},{"$f":"External!AA6","v":0},{"$f":"External!AB6","v":0},{"$f":"External!AC6","v":0},{"$f":"External!AD6","v":0},{"$f":"External!AE6","v":0},{"$f":"External!AF6","v":0},{"$f":"External!AG6","v":0},{"$f":"External!AH6","v":0},{"$f":"External!AI6","v":0},{"$f":"External!AJ6","v":0},{"$f":"External!AK6","v":0},{"$f":"External!AL6","v":0},{"$f":"External!AM6","v":0},{"$f":"External!AN6","v":0},{"$f":"External!AO6","v":0}]
[null,null,"Cum.",{"$f":"D28","v":0},{"$f":"D29+E28","v":0},{"$f":"E29+F28","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AM29+AN28","v":0}]
[null,"Actual Cost","Month",{"$f":"External!E7","v":0},{"$f":"External!F7","v":0},{"$f":"External!G7","v":0},{"$f":"External!H7","v":0},{"$f":"External!I7","v":0},{"$f":"External!J7","v":0},{"$f":"External!K7","v":0},{"$f":"External!L7","v":0},{"$f":"External!M7","v":0},{"$f":"External!N7","v":0},{"$f":"External!O7","v":0},{"$f":"External!P7","v":0},{"$f":"External!Q7","v":0},{"$f":"External!R7","v":0},{"$f":"External!S7","v":0},{"$f":"External!T7","v":0},{"$f":"External!U7","v":0},{"$f":"External!V7","v":0},{"$f":"External!W7","v":0},{"$f":"External!X7","v":0},{"$f":"External!Y7","v":0},{"$f":"External!Z7","v":0},{"$f":"External!AA7","v":0},{"$f":"External!AB7","v":0},{"$f":"External!AC7","v":0},{"$f":"External!AD7","v":0},{"$f":"External!AE7","v":0},{"$f":"External!AF7","v":0},{"$f":"External!AG7","v":0},{"$f":"External!AH7","v":0},{"$f":"External!AI7","v":0},{"$f":"External!AJ7","v":0},{"$f":"External!AK7","v":0},{"$f":"External!AL7","v":0},{"$f":"External!AM7","v":0},{"$f":"External!AN7","v":0},{"$f":"External!AO7","v":0}]
[null,null,"Cum.",{"$f":"D30","v":0},{"$f":"D31+E30","v":0},{"$f":"E31+F30","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AM31+AN30","v":0}]
[null,null,"Avail.",{"$f":"D28-D30","v":0},{"$f":"E28-E30","v":0},{"$f":"F28-F30","v":0},{"$f":"G28-G30","v":0},{"$f":"H28-H30","v":0},{"$f":"I28-I30","v":0},{"$f":"J28-J30","v":0},{"$f":"K28-K30","v":0},{"$f":"L28-L30","v":0},{"$f":"M28-M30","v":0},{"$f":"N28-N30","v":0},{"$f":"O28-O30","v":0},{"$f":"P28-P30","v":0},{"$f":"Q28-Q30","v":0},{"$f":"R28-R30","v":0},{"$f":"S28-S30","v":0},{"$f":"T28-T30","v":0},{"$f":"U28-U30","v":0},{"$f":"V28-V30","v":0},{"$f":"W28-W30","v":0},{"$f":"X28-X30","v":0},{"$f":"Y28-Y30","v":0},{"$f":"Z28-Z30","v":0},{"$f":"AA28-AA30","v":0},{"$f":"AB28-AB30","v":0},{"$f":"AC28-AC30","v":0},{"$f":"AD28-AD30","v":0},{"$f":"AE28-AE30","v":0},{"$f":"AF28-AF30","v":0},{"$f":"AG28-AG30","v":0},{"$f":"AH28-AH30","v":0},{"$f":"AI28-AI30","v":0},{"$f":"AJ28-AJ30","v":0},{"$f":"AK28-AK30","v":0},{"$f":"AL28-AL30","v":0},{"$f":"AM28-AM30","v":0},{"$f":"AN28-AN30","v":0}]

{"sheet":"Prevention","index":3,"n_rows":30,"n_cols":41,"rows_kept":30,"merged":[[0,0,4,3],[0,4,4,40]]}
["Prevention Cost",{"$nulls":3},"These are cost related to all activities to prevent defects from occurring and to keep appraisal and failure to a minimum."]
[]
[]
[]
[]
["Total","Budget",{"$f":"SUM(E6:AO6)","v":{"v":15750,"d":"15,750"}},null,{"$f":"SUM(E10+E13+E16+E19+E22+E25+E28)","v":100},{"$f":"SUM(F10+F13+F16+F19+F22+F25+F28)","v":100},250,500,700,700,700,700,700,700,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,100,0,0,0,0,0]
[null,"Actual",{"$f":"SUM(E7:AO7)","v":{"v":1484,"d":"1,484"}},null,{"$f":"SUM(E11+E14+E17+E20+E23+E26+E29)","v":90},89,210,455,640,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C6-C7","v":{"v":14266,"d":"14,266"}},{"$f":"D6-D7","v":0},{"$f":"E6-E7","v":10},{"$f":"F6-F7","v":11},40,45,60,700,700,700,700,700,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,100,0,0,0,0,0]
[{"$nulls":3},"Duration",{"$f":"Summary!D8","v":"2014-07-01"},{"$f":"Summary!E8","v":"2014-08-01"},{"$f":"Summary!F8","v":"2014-09-01"},{"$f":"Summary!G8","v":"2014-10-01"},{"$f":"Summary!H8","v":"2014-11-01"},{"$f":"Summary!I8","v":"2014-12-01"},{"$f":"Summary!J8","v":"2015-01-01"},{"$f":"Summary!K8","v":"2015-02-01"},{"$f":"Summary!L8","v":"2015-03-01"},{"$f":"Summary!M8","v":"2015-04-01"},{"$f":"Summary!N8","v":"2015-05-01"},{"$f":"Summary!O8","v":"2015-06-01"},{"$f":"Summary!P8","v":"2015-07-01"},{"$f":"Summary!Q8","v":"2015-08-01"},{"$f":"Summary!R8","v":"2015-09-01"},{"$f":"Summary!S8","v":"2015-10-01"},{"$f":"Summary!T8","v":"2015-11-01"},{"$f":"Summary!U8","v":"2015-12-01"},{"$f":"Summary!V8","v":"2016-01-01"},{"$f":"Summary!W8","v":"2016-02-01"},{"$f":"Summary!X8","v":"2016-03-01"},{"$f":"Summary!Y8","v":"2016-04-01"},{"$f":"Summary!Z8","v":"2016-05-01"},{"$f":"Summary!AA8","v":"2016-06-01"},{"$f":"Summary!AB8","v":"2016-07-01"},{"$f":"Summary!AC8","v":"2016-08-01"},{"$f":"Summary!AD8","v":"2016-09-01"},{"$f":"Summary!AE8","v":"2016-10-01"},{"$f":"Summary!AF8","v":"2016-11-01"},{"$f":"Summary!AG8","v":"2016-12-01"},{"$f":"Summary!AH8","v":"2017-01-01"},{"$f":"Summary!AI8","v":"2017-02-01"},{"$f":"Summary!AJ8","v":"2017-03-01"},{"$f":"Summary!AK8","v":"2017-04-01"},{"$f":"Summary!AL8","v":"2017-05-01"},{"$f":"Summary!AM8","v":"2017-06-01"},{"$f":"Summary!AN8","v":"2017-07-01"}]
["Please remove example","Budget",{"$f":"SUM(E10:AO10)","v":{"v":3200,"d":"3,200"}},32,100,{"$f":"E10","v":100},{"$f":"F10","v":100},{"$f":"G10","v":100},100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,0,0,{"$f":"AL10","v":0},{"$f":"AM10","v":0},{"$f":"AN10","v":0}]
["entries","Actual",{"$f":"SUM(E11:AO11)","v":474},{"$f":"COUNT(E11:AI11)","v":5},90,89,110,95,90]
[null,null,{"$f":"C10-C11","v":{"v":2726,"d":"2,726"}},{"$f":"D10-D11","v":27},{"$f":"E10-E11","v":10},{"$f":"F10-F11","v":11},{"v":-10,"d":"-10 "},5,10,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,0,0,0,0,0]
["Please remove example","Budget",{"$f":"SUM(E13:AO13)","v":{"v":11150,"d":"11,150"}},29,0,{"$f":"E13","v":0},150,200,400,{"$f":"I13","v":400},{"$f":"J13","v":400},400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,0,0,0,0,0,0]
["entries","Actual",{"$f":"SUM(E14:AO14)","v":610},{"$f":"COUNT(E14:AI14)","v":3},null,null,100,160,350]
[null,null,{"$f":"C13-C14","v":{"v":10540,"d":"10,540"}},{"$f":"D13-D14","v":26},{"$f":"E13-E14","v":0},{"$f":"F13-F14","v":0},50,40,50,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,0,0,0,0,0,0]
["Please remove example","Budget",{"$f":"SUM(E16:AO16)","v":{"v":1400,"d":"1,400"}},7,0,{"$f":"E16","v":0},{"$f":"F16","v":0},200,200,200,200,200,200,200,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI16","v":0},{"$f":"AJ16","v":0},{"$f":"AK16","v":0},{"$f":"AL16","v":0},{"$f":"AM16","v":0},{"$f":"AN16","v":0}]
["entries","Actual",{"$f":"SUM(E17:AO17)","v":400},{"$f":"COUNT(E17:AI17)","v":2},{"$nulls":3},200,200]
[null,null,{"$f":"C16-C17","v":{"v":1000,"d":"1,000"}},{"$f":"D16-D17","v":5},{"$f":"E16-E17","v":0},{"$f":"F16-F17","v":0},0,0,0,200,200,200,200,200,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Budget",{"$f":"SUM(E19:AO19)","v":0},null,0,{"$f":"E19","v":0},{"$f":"F19","v":0},0,0,{"$f":"I19","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AK19","v":0},{"$f":"AL19","v":0},{"$f":"AM19","v":0},{"$f":"AN19","v":0}]
[null,"Actual",{"$f":"SUM(E20:AO20)","v":0},0]
[null,null,{"$f":"C19-C20","v":0},{"$f":"D19-D20","v":0},{"$f":"E19-E20","v":0},{"$f":"F19-F20","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Budget",{"$f":"SUM(E22:AO22)","v":0},null,0,{"$f":"E22","v":0},{"$f":"F22","v":0},{"$f":"G22","v":0},{"$f":"H22","v":0},{"$f":"I22","v":0},{"$f":"J22","v":0},{"$f":"K22","v":0},{"$f":"L22","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI22","v":0},{"$f":"AJ22","v":0},{"$f":"AK22","v":0},{"$f":"AL22","v":0},{"$f":"AM22","v":0},{"$f":"AN22","v":0}]
[null,"Actual",{"$f":"SUM(E23:AO23)","v":0},0]
[null,null,{"$f":"C22-C23","v":0},{"$f":"D22-D23","v":0},{"$f":"E22-E23","v":0},{"$f":"F22-F23","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Budget",{"$f":"SUM(E25:AO25)","v":0},null,0,{"$f":"E25","v":0},{"$f":"F25","v":0},{"$f":"G25","v":0},{"$f":"H25","v":0},{"$f":"I25","v":0},{"$f":"J25","v":0},{"$f":"K25","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AM25","v":0},{"$f":"AN25","v":0}]
[null,"Actual",{"$f":"SUM(E26:AO26)","v":0},{"$f":"COUNT(E26:AI26)","v":0}]
[null,null,{"$f":"C25-C26","v":0},{"$f":"D25-D26","v":0},{"$f":"E25-E26","v":0},{"$f":"F25-F26","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Budget",{"$f":"SUM(E28:AO28)","v":0},null,0,{"$f":"E28","v":0},{"$f":"F28","v":0},{"$f":"G28","v":0},{"$f":"H28","v":0},{"$f":"I28","v":0},{"$f":"J28","v":0},{"$f":"K28","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AN28","v":0}]
[null,"Actual",{"$f":"SUM(E29:AO29)","v":0},{"$f":"COUNT(E29:AI29)","v":0}]
[null,null,{"$f":"C28-C29","v":0},{"$f":"D28-D29","v":0},{"$f":"E28-E29","v":0},{"$f":"F28-F29","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Appraisal","index":4,"n_rows":36,"n_cols":41,"rows_kept":36,"merged":[[0,0,4,3],[0,4,4,40]]}
["Appraisal Cost",{"$nulls":3},"These are costs incurred while monitoring and controlling. They include execution inspections, result control, field monitoring, supplier surveillance, material receipt inspection, and other planned activities to assure compliance with a certain requirement."]
[]
[]
[]
[]
["Total","Budget",{"$f":"SUM(E6:AO6)","v":{"v":92000,"d":"92,000"}},31,{"$f":"SUM(E10+E13+E16+E19+E22+E25+E28+E31+E34)","v":{"v":1000,"d":"1,000"}},{"$f":"SUM(F10+F13+F16+F19+F22+F25+F28+F31+F34)","v":{"v":3000,"d":"3,000"}},{"$f":"SUM(G10+G13+G16+G19+G22+G25+G28+G31+G34)","v":{"v":3000,"d":"3,000"}},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":1000,"d":"1,000"},0,0,0,0,{"$f":"SUM(AO10+AO13+AO16+AO19+AO22+AO25+AO28+AO31+AO34)","v":0}]
[null,"Actual",{"$f":"SUM(E7:AO7)","v":{"v":11730,"d":"11,730"}},{"$f":"COUNT(E7:AI7)","v":31},{"$f":"SUM(E11+E14+E17+E20+E23)","v":900},{"$f":"SUM(F11+F14+F17+F20+F23)","v":{"v":2790,"d":"2,790"}},{"v":3100,"d":"3,100"},{"v":2950,"d":"2,950"},{"v":1990,"d":"1,990"},0,0,0,0,{"$f":"SUM(N11+N14+N17+N20+N23+N26+N29+N32+N35)","v":0},{"$f":"SUM(O11+O14+O17+O20+O23+O26+O29+O32+O35)","v":0},{"$f":"SUM(P11+P14+P17+P20+P23+P26+P29+P32+P35)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AO11+AO14+AO17+AO20+AO23+AO26+AO29+AO32+AO35)","v":0}]
[null,null,{"$f":"C6-C7","v":{"v":80270,"d":"80,270"}},{"$f":"D6-D7","v":0},{"$f":"E6-E7","v":100},{"$f":"F6-F7","v":210},{"$f":"G6-G7","v":{"v":-100,"d":"-100 "}},{"$f":"H6-H7","v":50},{"$f":"I6-I7","v":{"v":1010,"d":"1,010"}},{"$f":"J6-J7","v":{"v":3000,"d":"3,000"}},{"$f":"K6-K7","v":{"v":3000,"d":"3,000"}},{"$f":"L6-L7","v":{"v":3000,"d":"3,000"}},{"$f":"M6-M7","v":{"v":3000,"d":"3,000"}},{"$f":"N6-N7","v":{"v":3000,"d":"3,000"}},{"$f":"O6-O7","v":{"v":3000,"d":"3,000"}},{"$f":"P6-P7","v":{"v":3000,"d":"3,000"}},{"$f":"Q6-Q7","v":{"v":3000,"d":"3,000"}},{"$f":"R6-R7","v":{"v":3000,"d":"3,000"}},{"$f":"S6-S7","v":{"v":3000,"d":"3,000"}},{"$f":"T6-T7","v":{"v":3000,"d":"3,000"}},{"$f":"U6-U7","v":{"v":3000,"d":"3,000"}},{"$f":"V6-V7","v":{"v":3000,"d":"3,000"}},{"$f":"W6-W7","v":{"v":3000,"d":"3,000"}},{"$f":"X6-X7","v":{"v":3000,"d":"3,000"}},{"$f":"Y6-Y7","v":{"v":3000,"d":"3,000"}},{"$f":"Z6-Z7","v":{"v":3000,"d":"3,000"}},{"$f":"AA6-AA7","v":{"v":3000,"d":"3,000"}},{"$f":"AB6-AB7","v":{"v":3000,"d":"3,000"}},{"$f":"AC6-AC7","v":{"v":3000,"d":"3,000"}},{"$f":"AD6-AD7","v":{"v":3000,"d":"3,000"}},{"$f":"AE6-AE7","v":{"v":3000,"d":"3,000"}},{"$f":"AF6-AF7","v":{"v":3000,"d":"3,000"}},{"$f":"AG6-AG7","v":{"v":3000,"d":"3,000"}},{"$f":"AH6-AH7","v":{"v":3000,"d":"3,000"}},{"$f":"AI6-AI7","v":{"v":3000,"d":"3,000"}},{"$f":"AJ6-AJ7","v":{"v":1000,"d":"1,000"}},{"$f":"AK6-AK7","v":0},{"$f":"AL6-AL7","v":0},{"$f":"AM6-AM7","v":0},{"$f":"AN6-AN7","v":0},{"$f":"AO6-AO7","v":0}]
[{"$nulls":3},"Duration",{"$f":"Summary!D8","v":"2014-07-01"},{"$f":"Summary!E8","v":"2014-08-01"},{"$f":"Summary!F8","v":"2014-09-01"},{"$f":"Summary!G8","v":"2014-10-01"},{"$f":"Summary!H8","v":"2014-11-01"},{"$f":"Summary!I8","v":"2014-12-01"},{"$f":"Summary!J8","v":"2015-01-01"},{"$f":"Summary!K8","v":"2015-02-01"},{"$f":"Summary!L8","v":"2015-03-01"},{"$f":"Summary!M8","v":"2015-04-01"},{"$f":"Summary!N8","v":"2015-05-01"},{"$f":"Summary!O8","v":"2015-06-01"},{"$f":"Summary!P8","v":"2015-07-01"},{"$f":"Summary!Q8","v":"2015-08-01"},{"$f":"Summary!R8","v":"2015-09-01"},{"$f":"Summary!S8","v":"2015-10-01"},{"$f":"Summary!T8","v":"2015-11-01"},{"$f":"Summary!U8","v":"2015-12-01"},{"$f":"Summary!V8","v":"2016-01-01"},{"$f":"Summary!W8","v":"2016-02-01"},{"$f":"Summary!X8","v":"2016-03-01"},{"$f":"Summary!Y8","v":"2016-04-01"},{"$f":"Summary!Z8","v":"2016-05-01"},{"$f":"Summary!AA8","v":"2016-06-01"},{"$f":"Summary!AB8","v":"2016-07-01"},{"$f":"Summary!AC8","v":"2016-08-01"},{"$f":"Summary!AD8","v":"2016-09-01"},{"$f":"Summary!AE8","v":"2016-10-01"},{"$f":"Summary!AF8","v":"2016-11-01"},{"$f":"Summary!AG8","v":"2016-12-01"},{"$f":"Summary!AH8","v":"2017-01-01"},{"$f":"Summary!AI8","v":"2017-02-01"},{"$f":"Summary!AJ8","v":"2017-03-01"},{"$f":"Summary!AK8","v":"2017-04-01"},{"$f":"Summary!AL8","v":"2017-05-01"},{"$f":"Summary!AM8","v":"2017-06-01"},{"$f":"Summary!AN8","v":"2017-07-01"}]
["Please remove example","Budget",{"$f":"SUM(E10:AO10)","v":{"v":32000,"d":"32,000"}},32,{"v":1000,"d":"1,000"},{"$f":"E10","v":{"v":1000,"d":"1,000"}},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},0,0,{"$f":"AL10","v":0},{"$f":"AM10","v":0},{"$f":"AN10","v":0}]
["entries","Actual",{"$f":"SUM(E11:AO11)","v":{"v":3930,"d":"3,930"}},{"$f":"COUNT(E11:AI11)","v":31},900,890,{"v":1100,"d":"1,100"},950,90,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C10-C11","v":{"v":28070,"d":"28,070"}},{"$f":"D10-D11","v":1},{"$f":"E10-E11","v":100},{"$f":"F10-F11","v":110},{"v":-100,"d":"-100 "},50,910,{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},0,0,0,0,0]
["Please remove example","Budget",{"$f":"SUM(E13:AO13)","v":{"v":60000,"d":"60,000"}},30,0,{"v":2000,"d":"2,000"},{"$f":"F13","v":{"v":2000,"d":"2,000"}},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},0,0,0,0,0,0]
["entries","Actual",{"$f":"SUM(E14:AO14)","v":{"v":7800,"d":"7,800"}},{"$f":"COUNT(E14:AI14)","v":4},null,{"v":1900,"d":"1,900"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":1900,"d":"1,900"}]
[null,null,{"$f":"C13-C14","v":{"v":52200,"d":"52,200"}},{"$f":"D13-D14","v":26},{"$f":"E13-E14","v":0},{"$f":"F13-F14","v":100},0,0,100,{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},0,0,0,0,0,0]
[null,"Budget",{"$f":"SUM(E16:AO16)","v":0},null,0,{"$f":"E16","v":0},{"$f":"F16","v":0},0,0,0,{"$f":"J16","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ16","v":0},{"$f":"AK16","v":0},0,0,{"$f":"AN16","v":0}]
[null,"Actual",{"$f":"SUM(E17:AO17)","v":0},{"$f":"COUNT(E17:AI17)","v":0}]
[null,null,{"$f":"C16-C17","v":0},{"$f":"D16-D17","v":0},{"$f":"E16-E17","v":0},{"$f":"F16-F17","v":0},{"$f":"G16-G17","v":0},{"$f":"H16-H17","v":0},{"$f":"I16-I17","v":0},{"$f":"J16-J17","v":0},{"$f":"K16-K17","v":0},{"$f":"L16-L17","v":0},{"$f":"M16-M17","v":0},{"$f":"N16-N17","v":0},{"$f":"O16-O17","v":0},{"$f":"P16-P17","v":0},{"$f":"Q16-Q17","v":0},{"$f":"R16-R17","v":0},{"$f":"S16-S17","v":0},{"$f":"T16-T17","v":0},{"$f":"U16-U17","v":0},{"$f":"V16-V17","v":0},{"$f":"W16-W17","v":0},{"$f":"X16-X17","v":0},{"$f":"Y16-Y17","v":0},{"$f":"Z16-Z17","v":0},{"$f":"AA16-AA17","v":0},{"$f":"AB16-AB17","v":0},{"$f":"AC16-AC17","v":0},{"$f":"AD16-AD17","v":0},{"$f":"AE16-AE17","v":0},{"$f":"AF16-AF17","v":0},{"$f":"AG16-AG17","v":0},{"$f":"AH16-AH17","v":0},{"$f":"AI16-AI17","v":0},{"$f":"AJ16-AJ17","v":0},{"$f":"AK16-AK17","v":0},{"$f":"AL16-AL17","v":0},{"$f":"AM16-AM17","v":0},{"$f":"AN16-AN17","v":0},{"$f":"AO16-AO17","v":0}]
[null,"Budget",{"$f":"SUM(E19:AO19)","v":0},null,0,{"$f":"E19","v":0},{"$f":"F19","v":0},0,0,0,{"$f":"J19","v":0},{"$f":"K19","v":0},{"$f":"L19","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AN19","v":0}]
[null,"Actual",{"$f":"SUM(E20:AO20)","v":0},{"$f":"COUNT(E20:AI20)","v":0}]
[null,null,{"$f":"C19-C20","v":0},{"$f":"D19-D20","v":0},{"$f":"E19-E20","v":0},{"$f":"F19-F20","v":0},{"$f":"G19-G20","v":0},{"$f":"H19-H20","v":0},{"$f":"I19-I20","v":0},{"$f":"J19-J20","v":0},{"$f":"K19-K20","v":0},{"$f":"L19-L20","v":0},{"$f":"M19-M20","v":0},{"$f":"N19-N20","v":0},{"$f":"O19-O20","v":0},{"$f":"P19-P20","v":0},{"$f":"Q19-Q20","v":0},{"$f":"R19-R20","v":0},{"$f":"S19-S20","v":0},{"$f":"T19-T20","v":0},{"$f":"U19-U20","v":0},{"$f":"V19-V20","v":0},{"$f":"W19-W20","v":0},{"$f":"X19-X20","v":0},{"$f":"Y19-Y20","v":0},{"$f":"Z19-Z20","v":0},{"$f":"AA19-AA20","v":0},{"$f":"AB19-AB20","v":0},{"$f":"AC19-AC20","v":0},{"$f":"AD19-AD20","v":0},{"$f":"AE19-AE20","v":0},{"$f":"AF19-AF20","v":0},{"$f":"AG19-AG20","v":0},{"$f":"AH19-AH20","v":0},{"$f":"AI19-AI20","v":0},{"$f":"AJ19-AJ20","v":0},{"$f":"AK19-AK20","v":0},{"$f":"AL19-AL20","v":0},{"$f":"AM19-AM20","v":0},{"$f":"AN19-AN20","v":0},{"$f":"AO19-AO20","v":0}]
[null,"Budget",{"$f":"SUM(E22:AO22)","v":0},null,0,{"$f":"E22","v":0},{"$f":"F22","v":0},0,0,0,{"$f":"J22","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AN22","v":0}]
[null,"Actual",{"$f":"SUM(E23:AO23)","v":0},{"$f":"COUNT(E23:AI23)","v":0}]
[null,null,{"$f":"C22-C23","v":0},{"$f":"D22-D23","v":0},{"$f":"E22-E23","v":0},{"$f":"F22-F23","v":0},{"$f":"G22-G23","v":0},{"$f":"H22-H23","v":0},{"$f":"I22-I23","v":0},{"$f":"J22-J23","v":0},{"$f":"K22-K23","v":0},{"$f":"L22-L23","v":0},{"$f":"M22-M23","v":0},{"$f":"N22-N23","v":0},{"$f":"O22-O23","v":0},{"$f":"P22-P23","v":0},{"$f":"Q22-Q23","v":0},{"$f":"R22-R23","v":0},{"$f":"S22-S23","v":0},{"$f":"T22-T23","v":0},{"$f":"U22-U23","v":0},{"$f":"V22-V23","v":0},{"$f":"W22-W23","v":0},{"$f":"X22-X23","v":0},{"$f":"Y22-Y23","v":0},{"$f":"Z22-Z23","v":0},{"$f":"AA22-AA23","v":0},{"$f":"AB22-AB23","v":0},{"$f":"AC22-AC23","v":0},{"$f":"AD22-AD23","v":0},{"$f":"AE22-AE23","v":0},{"$f":"AF22-AF23","v":0},{"$f":"AG22-AG23","v":0},{"$f":"AH22-AH23","v":0},{"$f":"AI22-AI23","v":0},{"$f":"AJ22-AJ23","v":0},{"$f":"AK22-AK23","v":0},{"$f":"AL22-AL23","v":0},{"$f":"AM22-AM23","v":0},{"$f":"AN22-AN23","v":0},{"$f":"AO22-AO23","v":0}]
[null,"Budget",{"$f":"SUM(E25:AO25)","v":0},null,0,0,{"$f":"F25","v":0},0,0,0,0,{"$f":"K25","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AN25","v":0}]
[null,"Actual",{"$f":"SUM(E26:AO26)","v":0},{"$f":"COUNT(E26:AI26)","v":6},0,0,0,0,0,null,0]
[null,null,{"$f":"C25-C26","v":0},{"$f":"D25-D26","v":-6},{"$f":"E25-E26","v":0},{"$f":"F25-F26","v":0},{"$f":"G25-G26","v":0},{"$f":"H25-H26","v":0},{"$f":"I25-I26","v":0},{"$f":"J25-J26","v":0},{"$f":"K25-K26","v":0},{"$f":"L25-L26","v":0},{"$f":"M25-M26","v":0},{"$f":"N25-N26","v":0},{"$f":"O25-O26","v":0},{"$f":"P25-P26","v":0},{"$f":"Q25-Q26","v":0},{"$f":"R25-R26","v":0},{"$f":"S25-S26","v":0},{"$f":"T25-T26","v":0},{"$f":"U25-U26","v":0},{"$f":"V25-V26","v":0},{"$f":"W25-W26","v":0},{"$f":"X25-X26","v":0},{"$f":"Y25-Y26","v":0},{"$f":"Z25-Z26","v":0},{"$f":"AA25-AA26","v":0},{"$f":"AB25-AB26","v":0},{"$f":"AC25-AC26","v":0},{"$f":"AD25-AD26","v":0},{"$f":"AE25-AE26","v":0},{"$f":"AF25-AF26","v":0},{"$f":"AG25-AG26","v":0},{"$f":"AH25-AH26","v":0},{"$f":"AI25-AI26","v":0},{"$f":"AJ25-AJ26","v":0},{"$f":"AK25-AK26","v":0},{"$f":"AL25-AL26","v":0},{"$f":"AM25-AM26","v":0},{"$f":"AN25-AN26","v":0},{"$f":"AO25-AO26","v":0}]
[null,"Budget",{"$f":"SUM(E28:AO28)","v":0},null,0,{"$f":"E28","v":0},{"$f":"F28","v":0},0,0,0,0,{"$f":"K28","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AN28","v":0}]
[null,"Actual",{"$f":"SUM(E29:AO29)","v":0},{"$f":"COUNT(E29:AI29)","v":0}]
[null,null,{"$f":"C28-C29","v":0},{"$f":"D28-D29","v":0},{"$f":"E28-E29","v":0},{"$f":"F28-F29","v":0},{"$f":"G28-G29","v":0},{"$f":"H28-H29","v":0},{"$f":"I28-I29","v":0},{"$f":"J28-J29","v":0},{"$f":"K28-K29","v":0},{"$f":"L28-L29","v":0},{"$f":"M28-M29","v":0},{"$f":"N28-N29","v":0},{"$f":"O28-O29","v":0},{"$f":"P28-P29","v":0},{"$f":"Q28-Q29","v":0},{"$f":"R28-R29","v":0},{"$f":"S28-S29","v":0},{"$f":"T28-T29","v":0},{"$f":"U28-U29","v":0},{"$f":"V28-V29","v":0},{"$f":"W28-W29","v":0},{"$f":"X28-X29","v":0},{"$f":"Y28-Y29","v":0},{"$f":"Z28-Z29","v":0},{"$f":"AA28-AA29","v":0},{"$f":"AB28-AB29","v":0},{"$f":"AC28-AC29","v":0},{"$f":"AD28-AD29","v":0},{"$f":"AE28-AE29","v":0},{"$f":"AF28-AF29","v":0},{"$f":"AG28-AG29","v":0},{"$f":"AH28-AH29","v":0},{"$f":"AI28-AI29","v":0},{"$f":"AJ28-AJ29","v":0},{"$f":"AK28-AK29","v":0},{"$f":"AL28-AL29","v":0},{"$f":"AM28-AM29","v":0},{"$f":"AN28-AN29","v":0},{"$f":"AO28-AO29","v":0}]
[null,"Budget",{"$f":"SUM(E31:AO31)","v":0},null,0,{"$f":"E31","v":0},{"$f":"F31","v":0},0,0,0,0,{"$f":"K31","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AN31","v":0}]
[null,"Actual",{"$f":"SUM(E32:AO32)","v":0},{"$f":"COUNT(E32:AI32)","v":0}]
[null,null,{"$f":"C31-C32","v":0},{"$f":"D31-D32","v":0},{"$f":"E31-E32","v":0},{"$f":"F31-F32","v":0},{"$f":"G31-G32","v":0},{"$f":"H31-H32","v":0},{"$f":"I31-I32","v":0},{"$f":"J31-J32","v":0},{"$f":"K31-K32","v":0},{"$f":"L31-L32","v":0},{"$f":"M31-M32","v":0},{"$f":"N31-N32","v":0},{"$f":"O31-O32","v":0},{"$f":"P31-P32","v":0},{"$f":"Q31-Q32","v":0},{"$f":"R31-R32","v":0},{"$f":"S31-S32","v":0},{"$f":"T31-T32","v":0},{"$f":"U31-U32","v":0},{"$f":"V31-V32","v":0},{"$f":"W31-W32","v":0},{"$f":"X31-X32","v":0},{"$f":"Y31-Y32","v":0},{"$f":"Z31-Z32","v":0},{"$f":"AA31-AA32","v":0},{"$f":"AB31-AB32","v":0},{"$f":"AC31-AC32","v":0},{"$f":"AD31-AD32","v":0},{"$f":"AE31-AE32","v":0},{"$f":"AF31-AF32","v":0},{"$f":"AG31-AG32","v":0},{"$f":"AH31-AH32","v":0},{"$f":"AI31-AI32","v":0},{"$f":"AJ31-AJ32","v":0},{"$f":"AK31-AK32","v":0},{"$f":"AL31-AL32","v":0},{"$f":"AM31-AM32","v":0},{"$f":"AN31-AN32","v":0},{"$f":"AO31-AO32","v":0}]
[null,"Budget",{"$f":"SUM(E34:AO34)","v":0},null,0,{"$f":"E34","v":0},{"$f":"F34","v":0},0,0,0,0,{"$f":"K34","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AM34","v":0},{"$f":"AN34","v":0}]
[null,"Actual",{"$f":"SUM(E35:AO35)","v":0},{"$f":"COUNT(E35:AI35)","v":0}]
[null,null,{"$f":"C34-C35","v":0},{"$f":"D34-D35","v":0},{"$f":"E34-E35","v":0},{"$f":"F34-F35","v":0},{"$f":"G34-G35","v":0},{"$f":"H34-H35","v":0},{"$f":"I34-I35","v":0},{"$f":"J34-J35","v":0},{"$f":"K34-K35","v":0},{"$f":"L34-L35","v":0},{"$f":"M34-M35","v":0},{"$f":"N34-N35","v":0},{"$f":"O34-O35","v":0},{"$f":"P34-P35","v":0},{"$f":"Q34-Q35","v":0},{"$f":"R34-R35","v":0},{"$f":"S34-S35","v":0},{"$f":"T34-T35","v":0},{"$f":"U34-U35","v":0},{"$f":"V34-V35","v":0},{"$f":"W34-W35","v":0},{"$f":"X34-X35","v":0},{"$f":"Y34-Y35","v":0},{"$f":"Z34-Z35","v":0},{"$f":"AA34-AA35","v":0},{"$f":"AB34-AB35","v":0},{"$f":"AC34-AC35","v":0},{"$f":"AD34-AD35","v":0},{"$f":"AE34-AE35","v":0},{"$f":"AF34-AF35","v":0},{"$f":"AG34-AG35","v":0},{"$f":"AH34-AH35","v":0},{"$f":"AI34-AI35","v":0},{"$f":"AJ34-AJ35","v":0},{"$f":"AK34-AK35","v":0},{"$f":"AL34-AL35","v":0},{"$f":"AM34-AM35","v":0},{"$f":"AN34-AN35","v":0},{"$f":"AO34-AO35","v":0}]

{"sheet":"Internal","index":5,"n_rows":36,"n_cols":41,"rows_kept":36,"merged":[[0,0,4,3],[0,4,4,40]]}
["Internal Failure Cost",{"$nulls":3},"These are costs that would disappear if no defects existed prior to selivery to the client.\nThese costs include rework, scrap, re-check or re-inspection, corrective action, re-design, vendor defects, and other like defects.\n"]
[]
[]
[]
[]
["Total","Budget",{"$f":"SUM(E6:AO6)","v":{"v":40750,"d":"40,750"}},null,{"$f":"SUM(E10+E13+E16+E19+E22)","v":{"v":1000,"d":"1,000"}},{"$f":"SUM(F10+F13+F16+F19+F22)","v":{"v":1000,"d":"1,000"}},{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"v":1250,"d":"1,250"},{"v":1250,"d":"1,250"},{"v":1250,"d":"1,250"},{"v":1250,"d":"1,250"},{"v":1250,"d":"1,250"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"}]
[null,"Actual",{"$f":"SUM(E7:AO7)","v":{"v":3650,"d":"3,650"}},null,{"$f":"SUM(E11+E14+E17+E20+E23)","v":700},650,{"v":1400,"d":"1,400"},900,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C6-C7","v":{"v":37100,"d":"37,100"}},null,{"$f":"E6-E7","v":300},{"$f":"F6-F7","v":350},100,600,{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"v":1250,"d":"1,250"},{"v":1250,"d":"1,250"},{"v":1250,"d":"1,250"},{"v":1250,"d":"1,250"},{"v":1250,"d":"1,250"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"}]
[{"$nulls":3},"Duration",{"$f":"Summary!D8","v":"2014-07-01"},{"$f":"Summary!E8","v":"2014-08-01"},{"$f":"Summary!F8","v":"2014-09-01"},{"$f":"Summary!G8","v":"2014-10-01"},{"$f":"Summary!H8","v":"2014-11-01"},{"$f":"Summary!I8","v":"2014-12-01"},{"$f":"Summary!J8","v":"2015-01-01"},{"$f":"Summary!K8","v":"2015-02-01"},{"$f":"Summary!L8","v":"2015-03-01"},{"$f":"Summary!M8","v":"2015-04-01"},{"$f":"Summary!N8","v":"2015-05-01"},{"$f":"Summary!O8","v":"2015-06-01"},{"$f":"Summary!P8","v":"2015-07-01"},{"$f":"Summary!Q8","v":"2015-08-01"},{"$f":"Summary!R8","v":"2015-09-01"},{"$f":"Summary!S8","v":"2015-10-01"},{"$f":"Summary!T8","v":"2015-11-01"},{"$f":"Summary!U8","v":"2015-12-01"},{"$f":"Summary!V8","v":"2016-01-01"},{"$f":"Summary!W8","v":"2016-02-01"},{"$f":"Summary!X8","v":"2016-03-01"},{"$f":"Summary!Y8","v":"2016-04-01"},{"$f":"Summary!Z8","v":"2016-05-01"},{"$f":"Summary!AA8","v":"2016-06-01"},{"$f":"Summary!AB8","v":"2016-07-01"},{"$f":"Summary!AC8","v":"2016-08-01"},{"$f":"Summary!AD8","v":"2016-09-01"},{"$f":"Summary!AE8","v":"2016-10-01"},{"$f":"Summary!AF8","v":"2016-11-01"},{"$f":"Summary!AG8","v":"2016-12-01"},{"$f":"Summary!AH8","v":"2017-01-01"},{"$f":"Summary!AI8","v":"2017-02-01"},{"$f":"Summary!AJ8","v":"2017-03-01"},{"$f":"Summary!AK8","v":"2017-04-01"},{"$f":"Summary!AL8","v":"2017-05-01"},{"$f":"Summary!AM8","v":"2017-06-01"},{"$f":"Summary!AN8","v":"2017-07-01"}]
["Failure ABC","Budget",{"$f":"SUM(E10:AO10)","v":{"v":37000,"d":"37,000"}},null,{"v":1000,"d":"1,000"},{"$f":"E10","v":{"v":1000,"d":"1,000"}},{"$f":"F10","v":{"v":1000,"d":"1,000"}},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"$f":"AN10","v":{"v":1000,"d":"1,000"}}]
[null,"Actual",{"$f":"SUM(E11:AO11)","v":{"v":2550,"d":"2,550"}},null,700,650,600,600]
[null,null,{"$f":"C10-C11","v":{"v":34450,"d":"34,450"}},null,{"$f":"E10-E11","v":300},{"$f":"F10-F11","v":350},400,400,{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"}]
["Failure XYZ","Budget",{"$f":"SUM(E13:AO13)","v":{"v":3750,"d":"3,750"}},null,0,0,500,{"$f":"G13","v":500},{"$f":"H13","v":500},500,500,250,250,250,250,250,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AN13","v":0}]
[null,"Actual",{"$f":"SUM(E14:AO14)","v":500},{"$nulls":3},200,300]
[null,null,{"$f":"C13-C14","v":{"v":3250,"d":"3,250"}},null,{"$f":"E13-E14","v":0},{"$f":"F13-F14","v":0},300,200,500,500,500,250,250,250,250,250,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Failure 123","Budget",{"$f":"SUM(E16:AO16)","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Actual",{"$f":"SUM(E17:AO17)","v":600},{"$nulls":3},600]
[null,null,{"$f":"C16-C17","v":{"v":-600,"d":"-600 "}},null,{"$f":"E16-E17","v":0},{"$f":"F16-F17","v":0},{"$f":"G16-G17","v":{"v":-600,"d":"-600 "}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Budget",{"$f":"SUM(E19:AO19)","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Actual",{"$f":"SUM(E20:AO20)","v":0}]
[null,null,{"$f":"C19-C20","v":0},null,{"$f":"E19-E20","v":0},{"$f":"F19-F20","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Budget",{"$f":"SUM(E22:AO22)","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Actual",{"$f":"SUM(E23:AO23)","v":0}]
[null,null,{"$f":"C22-C23","v":0},null,{"$f":"E22-E23","v":0},{"$f":"F22-F23","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Budget",{"$f":"SUM(E25:AO25)","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Actual",{"$f":"SUM(E26:AO26)","v":0}]
[null,null,{"$f":"C25-C26","v":0},null,{"$f":"E25-E26","v":0},{"$f":"F25-F26","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Budget",{"$f":"SUM(E28:AO28)","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Actual",{"$f":"SUM(E29:AO29)","v":0}]
[null,null,{"$f":"C28-C29","v":0},null,{"$f":"E28-E29","v":0},{"$f":"F28-F29","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Budget",{"$f":"SUM(E31:AO31)","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Actual",{"$f":"SUM(E32:AO32)","v":0}]
[null,null,{"$f":"C31-C32","v":0},null,{"$f":"E31-E32","v":0},{"$f":"F31-F32","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AN31-AN32","v":0},0]
[null,"Budget",{"$f":"SUM(E34:AO34)","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Actual",{"$f":"SUM(E35:AO35)","v":0}]
[null,null,{"$f":"C34-C35","v":0},null,{"$f":"E34-E35","v":0},{"$f":"F34-F35","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AN34-AN35","v":0},0]

{"sheet":"External","index":6,"n_rows":36,"n_cols":41,"rows_kept":36,"merged":[[0,0,4,3],[0,4,4,40]]}
["External Failure Cost",{"$nulls":3},"These are costs that would disappear if no defects existed in the product after delivery to the client.\nThese costs include warranty and repair costs, product liability, and product recall.\n\n"]
[]
[]
[]
[]
["Total","Budget",{"$f":"SUM(E6:AO6)","v":0},null,{"$f":"SUM(E10+E13+E16+E19+E22)","v":0},{"$f":"SUM(F10+F13+F16+F19+F22)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(O10+O13+O16+O19+O22+O25+O28+O31+O34)","v":0},{"$f":"SUM(P10+P13+P16+P19+P22+P25+P28+P31+P34)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AO10+AO13+AO16+AO19+AO22+AO25+AO28+AO31+AO34)","v":0}]
[null,"Actual",{"$f":"SUM(E7:AO7)","v":0},null,{"$f":"SUM(E11+E14+E17+E20+E23+E25+E28+E31+E34)","v":0},{"$f":"SUM(F11+F14+F17+F20+F23+F25+F28+F31+F34)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AO11+AO14+AO17+AO20+AO23+AO26+AO29+AO32+AO35)","v":0}]
[null,null,{"$f":"C6-C7","v":0},null,{"$f":"E6-E7","v":0},{"$f":"F6-F7","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},"Duration",{"$f":"Summary!D8","v":"2014-07-01"},{"$f":"Summary!E8","v":"2014-08-01"},{"$f":"Summary!F8","v":"2014-09-01"},{"$f":"Summary!G8","v":"2014-10-01"},{"$f":"Summary!H8","v":"2014-11-01"},{"$f":"Summary!I8","v":"2014-12-01"},{"$f":"Summary!J8","v":"2015-01-01"},{"$f":"Summary!K8","v":"2015-02-01"},{"$f":"Summary!L8","v":"2015-03-01"},{"$f":"Summary!M8","v":"2015-04-01"},{"$f":"Summary!N8","v":"2015-05-01"},{"$f":"Summary!O8","v":"2015-06-01"},{"$f":"Summary!P8","v":"2015-07-01"},{"$f":"Summary!Q8","v":"2015-08-01"},{"$f":"Summary!R8","v":"2015-09-01"},{"$f":"Summary!S8","v":"2015-10-01"},{"$f":"Summary!T8","v":"2015-11-01"},{"$f":"Summary!U8","v":"2015-12-01"},{"$f":"Summary!V8","v":"2016-01-01"},{"$f":"Summary!W8","v":"2016-02-01"},{"$f":"Summary!X8","v":"2016-03-01"},{"$f":"Summary!Y8","v":"2016-04-01"},{"$f":"Summary!Z8","v":"2016-05-01"},{"$f":"Summary!AA8","v":"2016-06-01"},{"$f":"Summary!AB8","v":"2016-07-01"},{"$f":"Summary!AC8","v":"2016-08-01"},{"$f":"Summary!AD8","v":"2016-09-01"},{"$f":"Summary!AE8","v":"2016-10-01"},{"$f":"Summary!AF8","v":"2016-11-01"},{"$f":"Summary!AG8","v":"2016-12-01"},{"$f":"Summary!AH8","v":"2017-01-01"},{"$f":"Summary!AI8","v":"2017-02-01"},{"$f":"Summary!AJ8","v":"2017-03-01"},{"$f":"Summary!AK8","v":"2017-04-01"},{"$f":"Summary!AL8","v":"2017-05-01"},{"$f":"Summary!AM8","v":"2017-06-01"},{"$f":"Summary!AN8","v":"2017-07-01"}]
[null,"Budget",{"$f":"SUM(E10:AO10)","v":0},null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Actual",{"$f":"SUM(E11:AO11)","v":0}]
[null,null,{"$f":"C10-C11","v":0},null,{"$f":"E10-E11","v":0},{"$f":"F10-F11","v":0},{"$f":"G10-G11","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Budget",{"$f":"SUM(E13:AO13)","v":0},null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Actual",{"$f":"SUM(E14:AO14)","v":0}]
[null,null,{"$f":"C13-C14","v":0},null,{"$f":"E13-E14","v":0},{"$f":"F13-F14","v":0},{"$f":"G13-G14","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Budget",{"$f":"SUM(E16:AO16)","v":0},null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Actual",{"$f":"SUM(E17:AO17)","v":0}]
[null,null,{"$f":"C16-C17","v":0},null,{"$f":"E16-E17","v":0},{"$f":"F16-F17","v":0},{"$f":"G16-G17","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Budget",{"$f":"SUM(E19:AO19)","v":0},null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Actual",{"$f":"SUM(E20:AO20)","v":0}]
[null,null,{"$f":"C19-C20","v":0},null,{"$f":"E19-E20","v":0},{"$f":"F19-F20","v":0},{"$f":"G19-G20","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Budget",{"$f":"SUM(E22:AO22)","v":0},null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Actual",{"$f":"SUM(E23:AO23)","v":0}]
[null,null,{"$f":"C22-C23","v":0},null,{"$f":"E22-E23","v":0},{"$f":"F22-F23","v":0},{"$f":"G22-G23","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Budget",{"$f":"SUM(E25:AO25)","v":0},null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Actual",{"$f":"SUM(E26:AO26)","v":0}]
[null,null,{"$f":"C25-C26","v":0},null,{"$f":"E25-E26","v":0},{"$f":"F25-F26","v":0},{"$f":"G25-G26","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Budget",{"$f":"SUM(E28:AO28)","v":0},null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Actual",{"$f":"SUM(E29:AO29)","v":0}]
[null,null,{"$f":"C28-C29","v":0},null,{"$f":"E28-E29","v":0},{"$f":"F28-F29","v":0},{"$f":"G28-G29","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Budget",{"$f":"SUM(E31:AO31)","v":0},null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Actual",{"$f":"SUM(E32:AO32)","v":0}]
[null,null,{"$f":"C31-C32","v":0},null,{"$f":"E31-E32","v":0},{"$f":"F31-F32","v":0},{"$f":"G31-G32","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Budget",{"$f":"SUM(E34:AO34)","v":0},null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Actual",{"$f":"SUM(E35:AO35)","v":0}]
[null,null,{"$f":"C34-C35","v":0},null,{"$f":"E34-E35","v":0},{"$f":"F34-F35","v":0},{"$f":"G34-G35","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]