{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Project Summary Sheet"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Project Summary Sheet","index":0,"n_rows":74,"n_cols":12,"rows_kept":74,"cut":false,"hidden":false,"merged":[[22,0,22,2],[3,11,4,11],[19,1,19,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[8,1,8,3],[12,1,12,3],[13,1,13,3],[1,0,1,11],[37,0,37,2],[31,0,31,2],[32,0,32,2],[33,0,33,2],[34,0,34,2],[35,0,35,2],[36,0,36,2],[20,1,20,3],[3,0,4,0],[3,1,4,3],[5,1,5,3],[30,0,30,3],[29,0,29,3],[27,0,27,3],[21,1,21,3],[65,0,65,2],[66,0,66,2],[49,0,49,2],[38,0,38,2],[39,0,39,2],[40,0,40,2],[41,0,41,2],[42,0,42,2],[43,0,43,2],[44,0,44,2],[45,0,45,2],[46,0,46,2],[47,0,47,2],[48,0,48,2],[67,0,67,2],[61,0,61,2],[50,0,50,2],[51,0,51,2],[52,0,52,2],[53,0,53,2],[54,0,54,2],[55,0,55,2],[56,0,56,2],[57,0,57,2],[58,0,58,2],[59,0,59,2],[60,0,60,2],[62,0,62,2],[63,0,63,2],[64,0,64,2],[28,0,28,3],[3,10,4,10],[73,8,74,11],[9,1,9,3],[10,1,10,3],[11,1,11,3],[30,4,30,5],[29,4,29,5],[26,4,26,5],[25,0,25,3],[26,0,26,3],[27,4,27,5],[28,4,28,5],[25,4,25,5],[6,1,6,3],[7,1,7,3]]}
[]
["Complete the Budget Template below or equivalent.  Provide total study costs and list the Customer and NYSERDA cost-share within the Scope of Work. The budget should be broken down according to task and potential EEMs as identified during the onsite walk-through and listed in the Scope of Work."]
["LABOR"]
["Task Number","Task Description",null,null,"Principal","Sr Engineer","Engineer","Jr Engineer","Project Manager","Admin","Total Hours","Total Labor:"]
[null,null,null,null,150,120,100,80,75,50]
[1,"Kickoff Meeting",null,null,1,1,null,null,1,1,{"$f":"SUM(E6:J6)","v":4},{"$f":"(E6*$E$5)+(F6*$F$5)+(G6*$G$5)+(H6*$H$5)+(I6*$I$5)+(J6*$J$5)","v":395}]
[2,"Documentation Collection",null,null,null,2,5,10,3,2,{"$f":"SUM(E7:J7)","v":22},{"$f":"(E7*$E$5)+(F7*$F$5)+(G7*$G$5)+(H7*$H$5)+(I7*$I$5)+(J7*$J$5)","v":1865}]
[3,"Utiltiy Bill Analysis",null,null,1,null,5,55,null,null,{"$f":"SUM(E8:J8)","v":61},5050]
[4,null,null,null,null,null,null,null,null,null,0,0]
[5,null,null,null,null,null,null,null,null,null,0,0]
[6,null,null,null,null,null,null,null,null,null,0,0]
[7,null,null,null,null,null,null,null,null,null,0,0]
[8,null,null,null,null,null,null,null,null,null,0,0]
[9,"Draft Report",null,null,1,2,10,20,5,5,43,3615]
[10,"Final Report",null,null,1,1,5,5,1,1,14,1295]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,{"$f":"IFERROR(SUM(E6:E22)*E5,\"0\")","v":600},{"$f":"IFERROR(SUM(F6:F22)*F5,\"0\")","v":720},2500,7200,750,450,{"$f":"SUM(K6:K22)","v":144},{"$f":"SUM(L6:L22)","v":12220}]
[]
["EXPENSES"]
["Item",null,null,null,"Total Cost"]
["Mileage",null,null,null,500]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[" "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[" "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Total Expenses",null,{"$f":"SUM(E27:F31)","v":500}]
[]
[null,null,null,null,null,null,null,null,null,"Total Budget",null,{"$f":"L69+L23","v":12720}]
[null,null,null,null,null,null,null,null,null,"NYSERDA Cost-Share*",null,{"$f":"L71/2","v":6360}]
[null,null,null,null,null,null,null,null,null,"Customer Cost-Share",null,{"$f":"L71-L72","v":6360}]
[null,null,null,null,null,null,null,null,"*Default at 50%. Modify as needed based on \nproject type and study eligbilty."]