{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Project Summary Sheet","References","Savings Check"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":1,"defined_names":2,"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":61,"n_cols":13,"rows_kept":61,"cut":false,"hidden":false,"merged":[[59,0,59,4],[60,0,60,4],[53,0,53,2],[54,0,54,2],[55,0,55,2],[56,0,56,2],[57,0,57,2],[58,0,58,2],[52,0,52,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],[49,0,49,2],[50,0,50,2],[51,0,51,2],[40,0,40,2],[29,0,29,2],[30,0,30,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],[37,0,37,2],[38,0,38,2],[39,0,39,2],[14,0,14,2],[15,0,15,2],[28,0,28,2],[17,0,17,2],[18,0,18,2],[19,0,19,2],[20,0,20,2],[21,0,21,2],[22,0,22,2],[23,0,23,2],[24,0,24,2],[25,0,25,2],[26,0,26,2],[27,0,27,2],[16,0,16,2],[7,11,8,11],[7,12,8,12],[9,0,9,2],[7,7,8,7],[7,8,8,8],[11,0,11,2],[12,0,12,2],[13,0,13,2],[6,0,6,12],[0,0,0,12],[1,10,1,11],[2,10,2,11],[3,10,3,11],[4,10,4,11],[10,0,10,2],[7,0,8,2],[7,3,8,3],[7,4,8,4],[7,5,7,6],[7,9,8,9],[7,10,8,10]]}
["BASELINE ENERGY SUMMARY"]
[null,"Electric \n(kWh)","Natural Gas (therms)","#2 Oil (gallons)","#4 Oil (gallons)","#6 Oil (gallons)","Steam \n(lbs.)","Propane (gallons)","Coal \n(tons)","Other \n(MMBtu)","Total Baseline Use (MMBtu)"]
["Baseline Energy Use",null,null,null,null,null,null,null,null,null,{"$f":"$B$3*References!$I$4+$C$3*References!$I$5+$D$3*References!$I$6+$E$3*References!$I$7+$F$3*References!$I$8+$G$3*References!$I$9+$H$3*References!$I$10+$I$3*References!$I$11+$J$3","v":0}]
["Average Utility Rate",null,null,null,null,null,null,null,null,null,"Total Annual Cost ($)"]
[" Baseline Annual Cost",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B5:J5)","v":0}]
[]
["ENERGY SAVINGS SUMMARY"]
["Measure Description",null,null,"Measure Status 1","Fuel Savings Type 2","Electric",null,"Fuel Savings\n(MMBtu)","Energy Savings \nto Total Baseline Use (%) 3","Annual Cost Savings","Cost Savings \nto Total Annual Cost (%) 4","Project Cost","Simple Payback\n(Years)"]
[null,null,null,null,null,"Supply Savings\n(kWh)","Demand Savings\n(kW)"]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F10=\"\",H10=\"\"),\"\",(F10*References!$I$4+H10)/$K$3)","v":""},null,{"$f":"IF(J10=\"\",\"\",J10/$K$5)","v":""},null,{"$f":"IFERROR(L10/J10,\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F11=\"\",H11=\"\"),\"\",(F11*References!$I$4+H11)/$K$3)","v":""},null,"",null,{"$f":"IFERROR(L11/J11,\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F12=\"\",H12=\"\"),\"\",(F12*References!$I$4+H12)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F13=\"\",H13=\"\"),\"\",(F13*References!$I$4+H13)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F14=\"\",H14=\"\"),\"\",(F14*References!$I$4+H14)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F15=\"\",H15=\"\"),\"\",(F15*References!$I$4+H15)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F16=\"\",H16=\"\"),\"\",(F16*References!$I$4+H16)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F17=\"\",H17=\"\"),\"\",(F17*References!$I$4+H17)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F18=\"\",H18=\"\"),\"\",(F18*References!$I$4+H18)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F19=\"\",H19=\"\"),\"\",(F19*References!$I$4+H19)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F20=\"\",H20=\"\"),\"\",(F20*References!$I$4+H20)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F21=\"\",H21=\"\"),\"\",(F21*References!$I$4+H21)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F22=\"\",H22=\"\"),\"\",(F22*References!$I$4+H22)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F23=\"\",H23=\"\"),\"\",(F23*References!$I$4+H23)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F24=\"\",H24=\"\"),\"\",(F24*References!$I$4+H24)/$K$3)","v":""},null,"",null,{"$f":"IFERROR(L24/J24,\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F25=\"\",H25=\"\"),\"\",(F25*References!$I$4+H25)/$K$3)","v":""},null,"",null,{"$f":"IFERROR(L25/J25,\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F26=\"\",H26=\"\"),\"\",(F26*References!$I$4+H26)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F27=\"\",H27=\"\"),\"\",(F27*References!$I$4+H27)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F28=\"\",H28=\"\"),\"\",(F28*References!$I$4+H28)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F29=\"\",H29=\"\"),\"\",(F29*References!$I$4+H29)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F30=\"\",H30=\"\"),\"\",(F30*References!$I$4+H30)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F31=\"\",H31=\"\"),\"\",(F31*References!$I$4+H31)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F32=\"\",H32=\"\"),\"\",(F32*References!$I$4+H32)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F33=\"\",H33=\"\"),\"\",(F33*References!$I$4+H33)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F34=\"\",H34=\"\"),\"\",(F34*References!$I$4+H34)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F35=\"\",H35=\"\"),\"\",(F35*References!$I$4+H35)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F36=\"\",H36=\"\"),\"\",(F36*References!$I$4+H36)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F37=\"\",H37=\"\"),\"\",(F37*References!$I$4+H37)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F38=\"\",H38=\"\"),\"\",(F38*References!$I$4+H38)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F39=\"\",H39=\"\"),\"\",(F39*References!$I$4+H39)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F40=\"\",H40=\"\"),\"\",(F40*References!$I$4+H40)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F41=\"\",H41=\"\"),\"\",(F41*References!$I$4+H41)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F42=\"\",H42=\"\"),\"\",(F42*References!$I$4+H42)/$K$3)","v":""},null,"",null,{"$f":"IFERROR(L42/J42,\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F43=\"\",H43=\"\"),\"\",(F43*References!$I$4+H43)/$K$3)","v":""},null,"",null,{"$f":"IFERROR(L43/J43,\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F44=\"\",H44=\"\"),\"\",(F44*References!$I$4+H44)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F45=\"\",H45=\"\"),\"\",(F45*References!$I$4+H45)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F46=\"\",H46=\"\"),\"\",(F46*References!$I$4+H46)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F47=\"\",H47=\"\"),\"\",(F47*References!$I$4+H47)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F48=\"\",H48=\"\"),\"\",(F48*References!$I$4+H48)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F49=\"\",H49=\"\"),\"\",(F49*References!$I$4+H49)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F50=\"\",H50=\"\"),\"\",(F50*References!$I$4+H50)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F51=\"\",H51=\"\"),\"\",(F51*References!$I$4+H51)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F52=\"\",H52=\"\"),\"\",(F52*References!$I$4+H52)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F53=\"\",H53=\"\"),\"\",(F53*References!$I$4+H53)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F54=\"\",H54=\"\"),\"\",(F54*References!$I$4+H54)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F55=\"\",H55=\"\"),\"\",(F55*References!$I$4+H55)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F56=\"\",H56=\"\"),\"\",(F56*References!$I$4+H56)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F57=\"\",H57=\"\"),\"\",(F57*References!$I$4+H57)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F58=\"\",H58=\"\"),\"\",(F58*References!$I$4+H58)/$K$3)","v":""},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(F59=\"\",H59=\"\"),\"\",(F59*References!$I$4+H59)/$K$3)","v":""},null,"",null,""]
["TOTAL (All):",null,null,null,null,{"$f":"SUM(F10:F59)","v":0},{"$f":"SUM(G10:G59)","v":0},{"$f":"SUM(H10:H59)","v":0},{"$f":"IFERROR(((F60*References!I4)+H60)/K3,\"0\"%)","v":0},{"$f":"SUM(J10:J59)","v":0},{"$f":"IFERROR(J60/$K$5,\"0\"%)","v":0},{"$f":"SUM(L10:L59)","v":0},{"$f":"IFERROR(L60/J60,\"0.0\")","v":"0.0"}]
["TOTAL (Recommended Only):",null,null,null,null,{"$f":"SUMIF($D$10:$D$59,References!$B$3,F10:F59)+SUMIF($D$10:$D$59,References!$B$4,F10:F59)+SUMIF($D$10:$D$59,References!$B$7,F10:F59)+SUMIF($D$10:$D$59,References!$B$9,F10:F59)","v":0},{"$f":"SUMIF($D$10:$D$59,References!$B$3,G10:G59)+SUMIF($D$10:$D$59,References!$B$4,G10:G59)+SUMIF($D$10:$D$59,References!$B$7,G10:G59)+SUMIF($D$10:$D$59,References!$B$9,G10:G59)","v":0},{"$f":"SUMIF($D$10:$D$59,References!$B$3,H10:H59)+SUMIF($D$10:$D$59,References!$B$4,H10:H59)+SUMIF($D$10:$D$59,References!$B$7,H10:H59)+SUMIF($D$10:$D$59,References!$B$9,H10:H59)","v":0},{"$f":"IFERROR(((F61*References!I4)+H61)/K3,\"0\"%)","v":0},{"$f":"SUMIF($D$10:$D$59,References!$B$3,J10:J59)+SUMIF($D$10:$D$59,References!$B$4,J10:J59)+SUMIF($D$10:$D$59,References!$B$7,J10:J59)+SUMIF($D$10:$D$59,References!$B$9,J10:J59)","v":0},{"$f":"IFERROR(J61/$K$5,\"0\"%)","v":0},{"$f":"SUMIF($D$10:$D$59,References!$B$3,L10:L59)+SUMIF($D$10:$D$59,References!$B$4,L10:L59)+SUMIF($D$10:$D$59,References!$B$7,L10:L59)+SUMIF($D$10:$D$59,References!$B$9,L10:L59)","v":0},{"$f":"IFERROR(L61/J61,\"0.0\")","v":"0.0"}]

{"sheet":"References","index":1,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,0,22,8],[14,0,14,9],[15,0,15,9],[16,0,16,9],[20,0,20,9],[1,4,1,5],[1,7,1,8],[19,0,19,8],[1,1,1,2],[21,0,21,8]]}
[]
[null,"Measure Status1",null,null,"Fuel Saved",null,null,"MMBtu Conversion Factors"]
[null,"I","Implemented",null,"Elec","Electric",null,"Btu",1000000]
[null,"R","Recommended",null,"NGas","Natural Gas",null,"kWh",3.4120000000000001E-3]
[null,"RS","Further Study Recommended",null,"Oil2","#2 Oil",null,"therms",0.1]
[null,"NR","Not Recommended",null,"Oil4","#4 Oil",null,"#2 gallon",0.13900000000000001]
[null,"RME","Recommeded Mutually Exclusive",null,"Oil6","#6 Oil",null,"#4 gallon",0.1467]
[null,"ME","Mutually Exclusive to Recommended Option",null,"Steam","District Steam",null,"#6 gallon",0.15]
[null,"RNE","Recommended Non-Energy",null,"LPG","Propane",null,"Steam lbs.",1.1999999999999999E-3]
[null,null,null,null,"Coal","Coal",null,"LPG gallon",9.1499999999999998E-2]
[null,null,null,null,"Other","Other",null,"Coal tons",24]
[]
[]
["Notes:"]
["2 Fuel Savings Type: Indicate the reported MMBtu savings fuel type. Select the predominant fuel type if there are MMBtu \n  savings from multiple fuel sources"]
["3 Energy Savings to Total Fuel Baseline Use is a comparison of the total electric & fuel savings to the total baseline energy use"]
["4 Cost Savings to Total Annual Cost is a comparison of the total annual cost savings to the total baseline annual energy cost"]
[]
["Instructions:"]
["* Fill in the light blue cells, as appropriate. White cells will auto-calculate."]
["* Energy savings must be presented as savings at the customer’s utility meter(s), not at the individual building or tenant space"]
["* Update the baseline energy use conversion factors in the 'References' tab, as necessary"]
["* Unhide rows to enter more measures, as necessary"]

{"sheet":"Savings Check","index":2,"n_rows":53,"n_cols":4,"rows_kept":53,"cut":false,"hidden":true,"merged":[]}
["Measure","Electric (kWh) \nsavings over \nElectric (kWh) baseline","Fuel (MMBtu) \nsavings over \nFuel (MMBtu) baseline","Total Project Energy savings\n(all energy sources): "]
[{"$f":"IF('Project Summary Sheet'!A10=\"\",\"\",'Project Summary Sheet'!A10)","v":""},{"$f":"IFERROR(VLOOKUP(A2,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A2,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A2,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A2,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A11=\"\",\"\",'Project Summary Sheet'!A11)","v":""},{"$f":"IFERROR(VLOOKUP(A3,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A3,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A3,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A3,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A12=\"\",\"\",'Project Summary Sheet'!A12)","v":""},{"$f":"IFERROR(VLOOKUP(A4,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A4,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A4,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A4,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A13=\"\",\"\",'Project Summary Sheet'!A13)","v":""},{"$f":"IFERROR(VLOOKUP(A5,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A5,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A5,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A5,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A14=\"\",\"\",'Project Summary Sheet'!A14)","v":""},{"$f":"IFERROR(VLOOKUP(A6,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A6,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A6,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A6,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A15=\"\",\"\",'Project Summary Sheet'!A15)","v":""},{"$f":"IFERROR(VLOOKUP(A7,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A7,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A7,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A7,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A16=\"\",\"\",'Project Summary Sheet'!A16)","v":""},{"$f":"IFERROR(VLOOKUP(A8,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A8,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A8,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A8,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A17=\"\",\"\",'Project Summary Sheet'!A17)","v":""},{"$f":"IFERROR(VLOOKUP(A9,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A9,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A9,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A9,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A18=\"\",\"\",'Project Summary Sheet'!A18)","v":""},{"$f":"IFERROR(VLOOKUP(A10,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A10,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A10,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A10,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A19=\"\",\"\",'Project Summary Sheet'!A19)","v":""},{"$f":"IFERROR(VLOOKUP(A11,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A11,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A11,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A11,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A20=\"\",\"\",'Project Summary Sheet'!A20)","v":""},{"$f":"IFERROR(VLOOKUP(A12,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A12,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A12,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A12,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A21=\"\",\"\",'Project Summary Sheet'!A21)","v":""},{"$f":"IFERROR(VLOOKUP(A13,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A13,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A13,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A13,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A22=\"\",\"\",'Project Summary Sheet'!A22)","v":""},{"$f":"IFERROR(VLOOKUP(A14,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A14,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A14,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A14,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A23=\"\",\"\",'Project Summary Sheet'!A23)","v":""},{"$f":"IFERROR(VLOOKUP(A15,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A15,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A15,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A15,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A24=\"\",\"\",'Project Summary Sheet'!A24)","v":""},{"$f":"IFERROR(VLOOKUP(A16,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A16,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A16,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A16,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A25=\"\",\"\",'Project Summary Sheet'!A25)","v":""},{"$f":"IFERROR(VLOOKUP(A17,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A17,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A17,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A17,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A26=\"\",\"\",'Project Summary Sheet'!A26)","v":""},{"$f":"IFERROR(VLOOKUP(A18,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A18,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A18,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A18,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A27=\"\",\"\",'Project Summary Sheet'!A27)","v":""},{"$f":"IFERROR(VLOOKUP(A19,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A19,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A19,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A19,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A28=\"\",\"\",'Project Summary Sheet'!A28)","v":""},{"$f":"IFERROR(VLOOKUP(A20,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A20,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A20,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A20,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A29=\"\",\"\",'Project Summary Sheet'!A29)","v":""},{"$f":"IFERROR(VLOOKUP(A21,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A21,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A21,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A21,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A30=\"\",\"\",'Project Summary Sheet'!A30)","v":""},{"$f":"IFERROR(VLOOKUP(A22,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A22,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A22,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A22,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A31=\"\",\"\",'Project Summary Sheet'!A31)","v":""},{"$f":"IFERROR(VLOOKUP(A23,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A23,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A23,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A23,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A32=\"\",\"\",'Project Summary Sheet'!A32)","v":""},{"$f":"IFERROR(VLOOKUP(A24,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A24,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A24,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A24,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A33=\"\",\"\",'Project Summary Sheet'!A33)","v":""},{"$f":"IFERROR(VLOOKUP(A25,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A25,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A25,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A25,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A34=\"\",\"\",'Project Summary Sheet'!A34)","v":""},{"$f":"IFERROR(VLOOKUP(A26,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A26,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A26,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A26,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A35=\"\",\"\",'Project Summary Sheet'!A35)","v":""},{"$f":"IFERROR(VLOOKUP(A27,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A27,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A27,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A27,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A36=\"\",\"\",'Project Summary Sheet'!A36)","v":""},{"$f":"IFERROR(VLOOKUP(A28,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A28,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A28,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A28,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A37=\"\",\"\",'Project Summary Sheet'!A37)","v":""},{"$f":"IFERROR(VLOOKUP(A29,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A29,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A29,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A29,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A38=\"\",\"\",'Project Summary Sheet'!A38)","v":""},{"$f":"IFERROR(VLOOKUP(A30,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A30,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A30,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A30,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A39=\"\",\"\",'Project Summary Sheet'!A39)","v":""},{"$f":"IFERROR(VLOOKUP(A31,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A31,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A31,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A31,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A40=\"\",\"\",'Project Summary Sheet'!A40)","v":""},{"$f":"IFERROR(VLOOKUP(A32,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A32,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A32,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A32,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A41=\"\",\"\",'Project Summary Sheet'!A41)","v":""},{"$f":"IFERROR(VLOOKUP(A33,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A33,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A33,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A33,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A42=\"\",\"\",'Project Summary Sheet'!A42)","v":""},{"$f":"IFERROR(VLOOKUP(A34,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A34,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A34,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A34,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A43=\"\",\"\",'Project Summary Sheet'!A43)","v":""},{"$f":"IFERROR(VLOOKUP(A35,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A35,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A35,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A35,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A44=\"\",\"\",'Project Summary Sheet'!A44)","v":""},{"$f":"IFERROR(VLOOKUP(A36,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A36,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A36,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A36,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A45=\"\",\"\",'Project Summary Sheet'!A45)","v":""},{"$f":"IFERROR(VLOOKUP(A37,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A37,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A37,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A37,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A46=\"\",\"\",'Project Summary Sheet'!A46)","v":""},{"$f":"IFERROR(VLOOKUP(A38,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A38,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A38,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A38,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A47=\"\",\"\",'Project Summary Sheet'!A47)","v":""},{"$f":"IFERROR(VLOOKUP(A39,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A39,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A39,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A39,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A48=\"\",\"\",'Project Summary Sheet'!A48)","v":""},{"$f":"IFERROR(VLOOKUP(A40,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A40,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A40,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A40,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A49=\"\",\"\",'Project Summary Sheet'!A49)","v":""},{"$f":"IFERROR(VLOOKUP(A41,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A41,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A41,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A41,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A50=\"\",\"\",'Project Summary Sheet'!A50)","v":""},{"$f":"IFERROR(VLOOKUP(A42,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A42,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A42,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A42,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A51=\"\",\"\",'Project Summary Sheet'!A51)","v":""},{"$f":"IFERROR(VLOOKUP(A43,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A43,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A43,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A43,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A52=\"\",\"\",'Project Summary Sheet'!A52)","v":""},{"$f":"IFERROR(VLOOKUP(A44,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A44,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A44,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A44,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A53=\"\",\"\",'Project Summary Sheet'!A53)","v":""},{"$f":"IFERROR(VLOOKUP(A45,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A45,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A45,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A45,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A54=\"\",\"\",'Project Summary Sheet'!A54)","v":""},{"$f":"IFERROR(VLOOKUP(A46,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A46,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A46,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A46,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A55=\"\",\"\",'Project Summary Sheet'!A55)","v":""},{"$f":"IFERROR(VLOOKUP(A47,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A47,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A47,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A47,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A56=\"\",\"\",'Project Summary Sheet'!A56)","v":""},{"$f":"IFERROR(VLOOKUP(A48,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A48,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A48,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A48,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A57=\"\",\"\",'Project Summary Sheet'!A57)","v":""},{"$f":"IFERROR(VLOOKUP(A49,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A49,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A49,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A49,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A58=\"\",\"\",'Project Summary Sheet'!A58)","v":""},{"$f":"IFERROR(VLOOKUP(A50,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A50,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A50,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A50,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"IF('Project Summary Sheet'!A59=\"\",\"\",'Project Summary Sheet'!A59)","v":""},{"$f":"IFERROR(VLOOKUP(A51,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A51,'Project Summary Sheet'!$A$8:$M$59,8,FALSE)/('Project Summary Sheet'!$K$3-('Project Summary Sheet'!$B$3*References!$I$4)),\"\")","v":""},{"$f":"IFERROR(((VLOOKUP(A51,'Project Summary Sheet'!$A$8:$M$59,6,FALSE)*References!$I$4)+VLOOKUP(A51,'Project Summary Sheet'!$A$8:$M$59,8,FALSE))/'Project Summary Sheet'!$K$3,\"\")","v":""}]
[{"$f":"'[1]Project Summary Sheet'!A60","v":"TOTAL (All):"}]
[{"$f":"'[1]Project Summary Sheet'!A61","v":"TOTAL (Recommended Only):"},{"$f":"IFERROR(VLOOKUP(A53,'Project Summary Sheet'!$A$8:$M$61,6,FALSE)/'Project Summary Sheet'!$B$3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A53,'Project Summary Sheet'!$A$8:$M$61,8,FALSE)/SUM('Project Summary Sheet'!$C$3:$J$3),\"\")","v":""},{"$f":"IFERROR((('Project Summary Sheet'!$F$61*References!$I$4)+'Project Summary Sheet'!$H$61)/'Project Summary Sheet'!$K$3,\"\")","v":""}]