{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Interface","Level_1","Demand_Curves","Level_2","Transformer","Cables","Lighting_Design","Lighting_Retrofit","Motor","Level_3","VSD_curves"],"not_rendered":{"charts":8,"images":9,"macros":1,"external_links":0,"defined_names":9,"comments":2,"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":"Interface","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[0,0,1048575,16383]]}

{"sheet":"Level_1","index":1,"n_rows":30,"n_cols":22,"rows_kept":30,"cut":false,"hidden":true,"merged":[[5,19,6,20],[5,21,6,21],[8,19,9,20],[8,21,9,21]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flat rate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Time-of-use"]
["Hours","Lighting","daily usage","HVAC",null,"Lifts",null,"Computer Loads",null,"Other Loads",null,"Motor Loads",null,"Total Demand","Tariff",null,"Demand"]
[]
[null,50,"kWh",50,null,20,null,75,null,50,null,44,null,null,"Demand",null,null,"Charges"]
["0000-0100",75,{"$f":"B$5*B6/100","v":37.5},10,{"$f":"D$5*D6/100*0.85","v":4.25},0,{"$f":"F$5*F6/100*0.85","v":0},0,{"$f":"H$5*H6/100*0.85","v":0},10,{"$f":"J$5*J6/100*0.85","v":4.25},0,{"$f":"L$5*L6/100","v":0},{"$f":"C6+E6+G6+I6+K6+M6","v":46},{"$f":"IF(O$5=\"Flat rate\",0.21, IF(O$5=\"Time-of-use\", Q6, IF(O$5=\"Demand\",P6)))","v":0.21},{"$f":"IF(N6=MAX(N$6:N$29),9.21,0.21)","v":0.21},{"$f":"IF(O$5=\"Time-of-use\", 0.21,0)","v":0},{"$f":"O6*N6","v":9.66},"Total",{"$f":"N30","v":2944.9749999999999},null,"kWh"]
["0100-0200",75,{"$f":"B$5*B7/100","v":37.5},10,{"$f":"D$5*D7/100*0.85","v":4.25},0,{"$f":"F$5*F7/100*0.85","v":0},0,{"$f":"H$5*H7/100*0.85","v":0},10,{"$f":"J$5*J7/100*0.85","v":4.25},0,{"$f":"L$5*L7/100","v":0},{"$f":"C7+E7+G7+I7+K7+M7","v":46},{"$f":"IF(O$5=\"Flat rate\",0.21, IF(O$5=\"Time-of-use\", Q7, IF(O$5=\"Demand\",P7)))","v":0.21},{"$f":"IF(N7=MAX(N$6:N$29),9.21,0.21)","v":0.21},{"$f":"IF(O$5=\"Time-of-use\", 0.21,0)","v":0},{"$f":"O7*N7","v":9.66},"Demand"]
["0200-0300",75,37.5,10,4.25,0,0,0,0,10,4.25,0,0,46,0.21,0.21,0,9.66]
["0300-0400",75,37.5,10,4.25,0,0,0,0,10,4.25,10,4.4000000000000004,50.4,0.21,0.21,0,10.584,"Total",{"$f":"R30","v":2596.1947499999997},null,"AUD"]
["0400-0500",75,37.5,10,4.25,0,0,0,0,10,4.25,25,11,57,0.21,0.21,0,11.969999999999999,"Cost"]
["0500-0600",75,37.5,10,4.25,0,0,0,0,10,4.25,30,13.2,59.2,0.21,0.21,0,12.432]
["0600-0700",75,37.5,10,4.25,0,0,0,0,10,4.25,50,22,68,0.21,0.21,0,14.28]
["0700-0800",50,25,20,8.5,100,17,20,12.75,100,42.5,100,44,149.75,0.21,0.21,0,31.447499999999998]
["0800-0900",20,10,30,12.75,100,17,50,31.875,100,42.5,100,44,158.125,0.21,0.21,0,33.206249999999997]
["0900-1000",10,5,100,42.5,100,17,100,63.75,100,42.5,100,44,214.75,0.21,0.21,0,45.097499999999997]
["1000-1100",10,5,100,42.5,100,17,100,63.75,100,42.5,100,44,214.75,0.21,0.21,0,45.097499999999997]
["1100-1200",10,5,100,42.5,100,17,100,63.75,100,42.5,100,44,214.75,0.21,0.21,{"$f":"IF(O$5=\"Time-of-use\", 0.42,0)","v":0},45.097499999999997]
["1200-1300",10,5,100,42.5,100,17,100,63.75,100,42.5,100,44,214.75,0.21,0.21,{"$f":"IF(O$5=\"Time-of-use\", 0.42,0)","v":0},45.097499999999997]
["1300-1400",10,5,100,42.5,100,17,100,63.75,100,42.5,100,44,214.75,0.21,0.21,0,45.097499999999997]
["1400-1500",10,5,100,42.5,100,17,100,63.75,100,42.5,100,44,214.75,0.21,0.21,0,45.097499999999997]
["1500-1600",10,5,100,42.5,100,17,100,63.75,100,42.5,100,44,214.75,0.21,0.21,0,45.097499999999997]
["1600-1700",20,10,100,42.5,100,17,100,63.75,100,42.5,100,44,219.75,9.2100000000000009,9.2100000000000009,0,2023.8975000000003]
["1700-1800",30,15,100,42.5,0,0,40,25.5,30,12.75,100,44,139.75,0.21,0.21,0,29.3475]
["1800-1900",50,25,40,17,0,0,20,12.75,20,8.5,100,44,107.25,0.21,0.21,0,22.522500000000001]
["1900-2000",100,50,20,8.5,0,0,0,0,0,0,100,44,102.5,0.21,0.21,0,21.524999999999999]
["2000-2100",100,50,10,4.25,0,0,0,0,0,0,0,0,54.25,0.21,0.21,0,11.3925]
["2100-2200",100,50,10,4.25,0,0,0,0,0,0,0,0,54.25,0.21,0.21,0,11.3925]
["2200-2300",75,37.5,10,4.25,0,0,0,0,0,0,0,0,41.75,0.21,0.21,{"$f":"IF(O$5=\"Time-of-use\", 0.21,0)","v":0},8.7675000000000001]
["2300-0000",75,37.5,10,4.25,0,0,0,0,0,0,0,0,41.75,0.21,0.21,0,8.7675000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total kWh",{"$f":"SUM(N6:N29)","v":2944.9749999999999},"Total Cost",null,null,{"$f":"SUM(R6:R29)","v":2596.1947499999997}]

{"sheet":"Demand_Curves","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Level_2","index":3,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total Load",{"$f":"Level_1!B5+Level_1!D5+Level_1!F5+Level_1!H5+Level_1!J5+(Level_1!L5/0.85)","v":296.76470588235293},"kVA"]
["Transformer Loading Percentage",75,"%"]
[null,{"$f":"B12/B13*100","v":395.68627450980387},"kVA"]
["Select the transformer",500,"kVA"]

{"sheet":"Transformer","index":4,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":true,"merged":[[8,1,8,2]]}
[]
[]
[null,"Transformer A","Transformer B"]
[null,"Standard","High Efficiency",null,"Discount Factor %",7.5]
["Purchase price",10194,10845,null,"No of Years",15]
["No-load losses",1647,1100,null,"Electricity costs /kWh",0.21]
["Load losses at 100%",9507,7100,null,"Loaded hours per year",6000]
["Load losses at selected value",5348,3808]
["PW",{"$f":"(((1+($F4/100))^$F5)-1)/(($F4/100)*((1+($F4/100))^$F5))","v":8.8271197450366898}]
["Present Value of No Load Losses",{"$f":"(B6*8760*$F6/1000)*$B9","v":26744.594538450758},{"$f":"(C6*8760*$F6/1000)*$B9","v":17862.206431266444}]
["Present Value of Load Losses",{"$f":"(B8/1000)*$F7*$F6*$B9","v":59481.369859534832},{"$f":"(C8/1000)*$F7*$F6*$B9","v":42353.226706265639}]
["Total Owning Cost (TOC)",{"$f":"B5+B10+B11","v":96419.96439798559},{"$f":"C5+C10+C11","v":71060.433137532091}]
[]
["Present Value of Savings",{"$f":"B12-C12","v":25359.531260453499}]

{"sheet":"Cables","index":5,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":true,"merged":[[3,1,3,4],[4,1,4,4],[26,1,26,4],[24,0,24,4],[9,0,9,4],[13,0,13,4],[17,0,17,4]]}
[]
[null,null,null,null,null,null,null,"Discount Factor %",7.5]
[null,null,null,null,null,null,null,"Electricity price",0.21]
["Design current for the conductor",{"$f":"Level_2!B12/(1.7*415)*1000","v":420.64451577938053},null,null,null,null,null,"No of Years",10]
["Length of the cable m",1000,null,null,null,null,null,"No of hours loaded",3700]
[null,null,null,null,null,null,null,"Loading percentage",70]
[null,null,null,null,null,null,null,"PW",{"$f":"(((1+(I2*0.01))^I4)-1)/((I2*0.01)*((1+(I2*0.01))^I4))","v":6.8640809559804747}]
[null,null,null,null,null,null,null,"F $/W",{"$f":"((0.01*I6)^2)*I5*I7*I3/1000","v":2.6133615423704466}]
[null,{"$f":"IF(B30=MIN($B30:$E30),1,0)","v":1},{"$f":"IF(C30=MIN($B30:$E30),1,0)","v":0},{"$f":"IF(D30=MIN($B30:$E30),1,0)","v":0},{"$f":"IF(E30=MIN($B30:$E30),1,0)","v":0}]
["Voltage Drop Anlysis",null,null,null,null,null,null,"Cable price per metre per sqmm",0.1]
["Selected Cable sizes",300,400,500,630]
["Voltage Drop",0.185,0.16600000000000001,0.15,0.13800000000000001]
["Total voltage drop",{"$f":"(B$12*$B5*$B4)/1000","v":77.819235419185389},{"$f":"(C$12*$B5*$B4)/1000","v":69.826989619377173},{"$f":"(D$12*$B5*$B4)/1000","v":63.09667736690708},{"$f":"(E$12*$B5*$B4)/1000","v":58.048943177554506},null,null,"Optimal Cross Section A mm2",{"$f":"B4*0.1433*(SQRT(I8/I10))","v":308.14928858006198}]
["Total voltage drop should be less than 5% of feeder volatge"]
["voltage drop of the selected cable",0.16600000000000001]
["Maximum length of the cable / m",{"$f":"20000/(B15*B4)","v":286.42220019821599}]
[]
["Short Circuit Analysis"]
["Short circuit current",{"$f":"(Level_2!B15*100000)/(415*4*1.7)","v":17717.930545712261}]
["Minimum cable size to withstand for Isc",{"$f":"(SQRT(B19*B19*5))/143","v":277.05242741840948}]
["(Assuming XLPE cable)"]
[]
[]
[]
["Cable Comparission"]
["Cross section of the conductor",300,400,500,630]
["Current",{"$f":"B4","v":420.64451577938053}]
["Price of the cable /m",{"$f":"$I10*B26","v":30},{"$f":"$I10*C26","v":40},{"$f":"$I10*D26","v":50},{"$f":"$I10*E26","v":63}]
["loss cost /m",{"$f":"(1/B26)*$B27*$B27*0.02054*$I8","v":31.659871117502313},{"$f":"(1/C26)*$B27*$B27*0.02054*$I8","v":23.744903338126729},{"$f":"(1/D26)*$B27*$B27*0.02054*$I8","v":18.995922670501386},{"$f":"(1/E26)*$B27*$B27*0.02054*$I8","v":15.076129103572528}]
["Total",{"$f":"B28+B29","v":61.659871117502313},{"$f":"C28+C29","v":63.744903338126733},{"$f":"D28+D29","v":68.995922670501386},{"$f":"E28+E29","v":78.076129103572526}]

{"sheet":"Lighting_Design","index":6,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":true,"merged":[[1,0,1,2],[13,1,13,2]]}
[]
["Lighting Layout Calculator"]
["Area to be lit/ m2",150]
["Desired Lux level",265]
["Average number of hours on per year",3000]
[]
[null,"Luminar 1","Luminar 2"]
["Watts per fixture",18,20]
["Number of lamps per fixture",2,2]
["Rated mean lumen per lamp",500,700]
["Ballast factor (BF)",1,1]
["Coefficient of Utilization (CU)",0.6,0.6]
[]
["Electric cost per kilowatt hour AUD",0.21]
[]
["No of fixtures required",{"$f":"($B3*$B4)/(B9*B10*B11*B12)","v":66.25},{"$f":"($B3*$B4)/(C9*C10*C11*C12)","v":47.321428571428569}]
["Total power load kW",{"$f":"B16*B8/1000","v":1.1924999999999999},{"$f":"C16*C8/1000","v":0.94642857142857129}]
["Energy cost per year",{"$f":"B17*$B5*$B14","v":751.27499999999986},{"$f":"C17*$B5*$B14","v":596.24999999999989}]
[]
[]
["Cost (including disposal cost)",80,60]
["Life in hours",10000,10000]
["Cost of labor to replace lamp",10,10]
[]
["Cost per year",{"$f":"B16*B8*$B5*$B14/1000","v":751.27499999999998},{"$f":"C16*C8*$B5*$B14/1000","v":596.24999999999989}]

{"sheet":"Lighting_Retrofit","index":7,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":true,"merged":[[7,1,7,2],[4,0,4,2]]}
[null,null,null,null,null,null,null,null,null,"Existing lux",null,"lux"]
["Area/ m2",150,null,null,null,null,null,null,null,{"$f":"(K2*$C$10*$C$11*$C$12*$C$13)/$B$2","v":28},5,{"$f":"(K2*$B$10*$B$11*$B$12*$B$13)/$B$2","v":20}]
["Average number of hours on per year",3000,null,null,null,null,null,null,null,{"$f":"(K3*$C$10*$C$11*$C$12*$C$13)/$B$2","v":56},10,{"$f":"(K3*$B$10*$B$11*$B$12*$B$13)/$B$2","v":40}]
[null,null,null,null,null,null,null,null,null,84,15,60]
["Compare Life Cycle Cost",null,null,null,null,null,null,null,null,112,20,80]
[null,null,null,null,null,null,null,null,null,140,25,100]
[null,"Luminar 1(New)","Luminar 2(Existing)",null,null,null,null,null,null,168,30,120]
["No of Fixtures",47,null,null,null,null,null,null,null,196,35,140]
["Watts per fixture",18,20,null,null,null,null,null,null,224,40,160]
["Number of lamps per fixture",2,2,null,null,null,null,null,null,252,45,180]
["Rated mean lumen per lamp",500,700,null,null,null,null,null,null,280,50,200]
["Ballast factor (BF)",1,1,null,null,null,null,null,null,308,55,220]
["Coefficient of Utilization (CU)",0.6,0.6,null,null,null,null,null,null,336,60,240]
["Operating Cost Per Year",{"$f":"(B9*Lighting_Design!$B5*Lighting_Design!$B14*$B8)/1000","v":532.98},{"$f":"(C9*Lighting_Design!$B5*Lighting_Design!$B14*$B8)/1000","v":592.20000000000005},null,null,null,null,null,null,364,65,260]
[null,null,null,null,null,null,null,null,null,392,70,280]
["Existing Lux Level with existing luminar",{"$f":"(B8*C10*C11*C12*C13)/B2","v":263.2},null,null,null,null,null,null,null,420,75,300]
["Achieved Lux Level with new Luminar",{"$f":"(B8*B10*B11*B12*B13)/B2","v":188},null,null,null,null,null,null,null,448,80,320]
[null,null,null,null,null,null,null,null,null,476,85,340]
[null,null,null,null,null,null,null,null,null,504,90,360]
[null,null,null,null,null,null,null,null,null,532,95,380]
[null,null,null,null,null,null,null,null,null,560,100,400]

{"sheet":"Motor","index":8,"n_rows":53,"n_cols":19,"rows_kept":53,"cut":false,"hidden":true,"merged":[[8,1,8,2],[9,1,9,2],[13,1,13,2]]}
[]
[null,"Motor A","Motor B",null,"Interest rate",10,null,null,null,null,"E","MOC",null,"Year","PW","MOC A","MOC B","savings"]
["Motor size kW",1.5,1.5,null,"Electricity cost $/kWh",0.21,null,null,null,null,50,{"$f":"(B$4*B$3*74.6*F$3)/(K3)","v":1174.95},null,1,{"$f":"(((1+(0.01*$F$2))^N3) -1)/(($F$2*0.01)*((1+(0.01*$F$2))^N3))","v":0.90909090909090973},{"$f":"($B$7*O3)+B6","v":1968.5210312075992},{"$f":"($C$7*O3)+C6","v":1929.7520661157032},{"$f":"(P3-Q3)*O3","v":35.244513719905484},{"$f":"R3","v":35.244513719905484}]
["Motor operating hours in a year",2500,2500,null,"No of Years",8,null,null,null,null,51,{"$f":"(B$4*B$3*74.6*F$3)/(K4)","v":1151.9117647058824},null,2,{"$f":"(((1+(0.01*$F$2))^N4) -1)/(($F$2*0.01)*((1+(0.01*$F$2))^N4))","v":1.7355371900826457},{"$f":"($B$7*O4)-($B$7*O3)","v":971.38275564327182},{"$f":"($C$7*O4)-($C$7*O3)","v":845.22915101427543},{"$f":"P4-Q4","v":126.15360462899639},{"$f":"S3+R4","v":161.39811834890187}]
["Motor efficiency",67,77,null,null,null,null,null,null,null,52,{"$f":"(B$4*B$3*74.6*F$3)/(K5)","v":1129.7596153846155},null,3,{"$f":"(((1+(0.01*$F$2))^N5) -1)/(($F$2*0.01)*((1+(0.01*$F$2))^N5))","v":2.4868519909842246},{"$f":"($B$7*O5)-($B$7*O4)","v":883.07523240297519},{"$f":"($C$7*O5)-($C$7*O4)","v":768.3901372857058},114.68509511726938,{"$f":"S4+R5","v":276.08321346617129}]
["Acquisition cost",900,1000,null,null,null,null,null,null,null,53,1108.4433962264152,null,4,3.169865446349295,{"$f":"($B$7*O6)-($B$7*O5)","v":802.79566582088501},698.53648844154895,104.25917737933605,{"$f":"S5+R6","v":380.34239084550734}]
["Operating Cost in a year",{"$f":"(B4*B3*$F3)/(B5*0.01)","v":1175.3731343283582},{"$f":"(C4*C3*$F3)/(C5*0.01)","v":1022.7272727272727},null,null,null,null,null,null,null,54,1087.9166666666667,null,5,3.7907867694084505,729.81424165535054,635.03317131050017,94.781070344850377,475.12346119035772]
[null,null,null,null,null,null,null,null,null,null,55,1068.1363636363637,null,6,4.355260699462228,663.46749241395537,577.30288300954544,86.16460940440993,561.28807059476765]
["Simple Payback Period",{"$f":"(C6-B6)/(B7-C7)","v":0.6551111111111112},null,null,null,null,null,null,null,null,56,1049.0625,null,7,4.8684188176929348,603.15226583086769,524.82080273594966,78.331463094918035,639.61953368968568]
["PW",{"$f":"(((1+(0.01*F2))^F4) -1)/((F2*0.01)*((1+(0.01*F2))^F4))","v":5.3349261979026679},null,null,null,null,null,null,null,null,57,1030.6578947368421,null,8,5.3349261979026679,548.32024166442534,477.1098206690458,71.210420995379536,710.82995468506522]
["Present Value of  Operational Costs",{"$f":"B7*$B10","v":6270.5289266393302},{"$f":"C7*$B10","v":5456.1745205822745},null,null,null,null,null,null,null,58,1012.8879310344828,null,9,5.7590238162751533,498.47294696765948,433.73620060822304,64.736746359436438,775.56670104450166]
[null,null,null,null,null,null,null,null,null,null,59,995.72033898305085,null,10,6.1445671057046853,453.15722451605507,394.30563691656698,58.851587599488084,834.41828864398974]
["Total Owning Cost",{"$f":"B11+B6","v":7170.5289266393302},{"$f":"C11+C6","v":6456.1745205822745},null,null,null,null,null,null,null,60,979.125,null,11,6.4950610051860771,411.96111319641204,358.45966992415106,53.501443272260985,887.91973191625073]
["Present Value of Savings",{"$f":"B13-C13","v":714.35440605705571},null,null,null,null,null,null,null,null,61,963.07377049180332,null,12,6.8136918228964332,374.51010290582872,325.87242720377344,48.637675702055276,936.557407618306]
[null,null,null,null,null,null,null,null,null,null,62,947.54032258064512,null,13,7.1033562026331216,340.46372991439057,296.2476610943404,44.216068820050168,980.77347643835617]
[null,null,null,null,null,null,null,null,null,null,63,932.5,null,14,7.3666874569392018,309.51248174035572,269.31605554030921,40.196426200046517,1020.9699026384027]
[null,null,null,null,null,null,null,null,null,null,64,917.9296875,null,15,7.6060795063083662,281.37498340032471,244.83277776391787,36.542205636406834,1057.5121082748096]
[null,null,null,null,null,null,null,null,null,null,65,903.80769230769226,null,16,7.8237086420985138,255.79543945483783,222.57525251265088,33.220186942186956,1090.7322952169966]
[null,null,null,null,null,null,null,null,null,null,66,890.11363636363637,null,17,8.0215533109986499,232.54130859530778,202.3411386478665,30.200169947441282,1120.9324651644379]
[null,null,null,null,null,null,null,null,null,null,67,876.82835820895525,null,18,8.2014121009078629,211.40118963209716,183.94648967987632,27.454699952220835,1148.3871651166587]
[null,null,null,null,null,null,null,null,null,null,68,863.93382352941171,null,19,8.3649200917344224,192.18289966554585,167.22408152716343,24.958818138382412,1173.3459832550411]
[null,null,null,null,null,null,null,null,null,null,69,851.41304347826087,null,20,8.5135637197585652,174.71172696867689,152.02189229741998,22.689834671256904,1196.035817926298]
[null,null,null,null,null,null,null,null,null,null,70,839.25]
[null,null,null,null,null,null,null,null,null,null,71,827.42957746478874]
[null,null,null,null,null,null,null,null,null,null,72,815.9375]
[null,null,null,null,null,null,null,null,null,null,73,804.7602739726027]
[null,null,null,null,null,null,null,null,null,null,74,793.8851351351351]
[null,null,null,null,null,null,null,null,null,null,75,783.3]
[null,null,null,null,null,null,null,null,null,null,76,772.99342105263156]
[null,null,null,null,null,null,null,null,null,null,77,762.9545454545455]
[null,null,null,null,null,null,null,null,null,null,78,753.17307692307691]
[null,null,null,null,null,null,null,null,null,null,79,743.63924050632909]
[null,null,null,null,null,null,null,null,null,null,80,734.34375]
[null,null,null,null,null,null,null,null,null,null,81,725.27777777777783]
[null,null,null,null,null,null,null,null,null,null,82,716.43292682926824]
[null,null,null,null,null,null,null,null,null,null,83,707.80120481927713]
[null,null,null,null,null,null,null,null,null,null,84,699.375]
[null,null,null,null,null,null,null,null,null,null,85,691.14705882352939]
[null,null,null,null,null,null,null,null,null,null,86,683.1104651162791]
[null,null,null,null,null,null,null,null,null,null,87,675.25862068965512]
[null,null,null,null,null,null,null,null,null,null,88,667.58522727272725]
[null,null,null,null,null,null,null,null,null,null,89,660.08426966292132]
[null,null,null,null,null,null,null,null,null,null,90,652.75]
[null,null,null,null,null,null,null,null,null,null,91,645.57692307692309]
[null,null,null,null,null,null,null,null,null,null,92,638.55978260869563]
[null,null,null,null,null,null,null,null,null,null,93,631.69354838709683]
[null,null,null,null,null,null,null,null,null,null,94,624.97340425531911]
[null,null,null,null,null,null,null,null,null,null,95,618.39473684210532]
[null,null,null,null,null,null,null,null,null,null,96,611.953125]
[null,null,null,null,null,null,null,null,null,null,97,605.64432989690727]
[null,null,null,null,null,null,null,null,null,null,98,599.46428571428567]
[null,null,null,null,null,null,null,null,null,null,99,593.40909090909088]
[null,null,null,null,null,null,null,null,null,null,100,587.47500000000002]

{"sheet":"Level_3","index":9,"n_rows":106,"n_cols":15,"rows_kept":106,"cut":false,"hidden":true,"merged":[[7,1,7,2]]}
[]
["Existing System(Valve controlled)",null,null,null,null,null,null,"Electricity cost",0.21]
[]
["Motor size kW",15.1,{"$f":"B4*(B5*0.01)","v":13.891999999999999}]
["Motor Efficiency %",92,null,null,null,null,null,null,null,null,null,null,"flow","vsd"]
["Flow rate @ 100% m3/h",125,null,null,null,null,null,null,null,null,null,null,0,{"$f":"$C$4*((M6*0.01)^3)","v":0},{"$f":"$C$4","v":13.891999999999999}]
["Head / m",32,null,null,null,null,null,null,null,null,null,null,1,{"$f":"$C$4*((M7*0.01)^3)","v":1.3892000000000002E-5},{"$f":"$C$4","v":13.891999999999999}]
[null,"Flow rate demands",null,null,null,null,null,null,null,null,null,null,2,1.1113600000000001E-4,13.891999999999999]
["No of hours per day",14.4,9.6,null,null,null,null,null,null,null,null,null,3,3.7508399999999998E-4,13.891999999999999]
["Flow rate %",75,100,null,null,"to see how total head changes",null,null,null,null,null,null,4,8.8908800000000012E-4,13.891999999999999]
["VSD controlled system kW",{"$f":"$C4*((B$10*0.01)^3)","v":5.8606875},{"$f":"$C4*((C$10*0.01)^3)","v":13.891999999999999},null,null,null,null,null,null,null,null,null,5,1.7365000000000004E-3,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,6,3.0006719999999998E-3,13.891999999999999]
["Electricity cost per day for existing system",{"$f":"C4*(B9+C9)*I2","v":70.015680000000003},null,null,null,null,null,null,null,null,null,null,7,4.7649560000000007E-3,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,8,7.1127040000000009E-3,13.891999999999999]
["Electricity cost per day for VSD system",{"$f":"((B11*B9)+(C11*C9))*I2","v":45.728990999999994},null,null,null,null,null,null,null,null,null,null,9,1.0127267999999998E-2,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,10,1.3892000000000003E-2,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,11,1.8490251999999999E-2,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,12,2.4005375999999998E-2,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,13,3.0520724000000003E-2,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,14,3.8119648000000006E-2,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,15,4.6885499999999997E-2,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,16,5.6901632000000008E-2,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,17,6.825139600000002E-2,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,18,8.1018143999999986E-2,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,19,9.5285228E-2,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,20,0.11113600000000003,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,21,0.12865381199999998,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,22,0.14792201599999999,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,23,0.169023964,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,24,0.19204300799999999,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,25,0.21706249999999999,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,26,0.24416579200000002,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,27,0.273436236,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,28,0.30495718400000005,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,29,0.33881198799999995,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,30,0.37508399999999997,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,31,0.41385657199999998,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,32,0.45521305600000006,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,33,0.49923680400000003,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,34,0.54601116800000016,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,35,0.59561950000000008,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,36,0.64814515199999989,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,37,0.70367147599999991,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,38,0.762281824,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,39,0.82405954800000003,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,40,0.88908800000000021,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,41,0.95745053200000008,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,42,1.0292304959999998,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,43,1.1045112439999998,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,44,1.1833761279999999,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,45,1.2659085000000001,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,46,1.352191712,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,47,1.4423091160000003,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,48,1.5363440639999999,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,49,1.6343799079999999,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,50,1.7364999999999999,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,51,1.8427876919999997,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,52,1.9533263360000002,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,53,2.0681992840000003,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,54,2.187489888,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,55,2.3112815000000007,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,56,2.4396574720000004,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,57,2.5727011560000008,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,58,2.7104959039999996,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,59,2.8531250679999998,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,60,3.0006719999999998,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,61,3.1532200519999996,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,62,3.3108525759999998,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,63,3.473652924,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,64,3.6417044480000005,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,65,{"$f":"$C$4*((M71*0.01)^3)","v":3.8150905000000006},{"$f":"$C$4","v":13.891999999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,66,3.9938944320000003,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,67,4.1781995960000007,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,68,4.3680893440000013,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,69,4.563647028000001,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,70,4.7649560000000006,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,71,4.9720996119999992,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,72,5.1851612159999991,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,73,5.4042241639999986,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,74,5.6293718079999993,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,75,5.8606875,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,76,6.098254592,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,77,6.3421564359999998,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,78,6.5924763840000002,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,79,6.8492977880000012,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,80,7.1127040000000017,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,81,7.3827783720000024,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,82,7.6596042560000006,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,83,7.9432650040000015,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,84,8.2338439679999986,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,85,8.5314244999999982,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,86,8.8360899519999982,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,87,9.1479236760000013,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,88,9.4670090239999993,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,89,9.7934293480000001,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,90,10.127268000000001,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,91,10.468608332000001,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,92,10.817533696,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,93,11.174127444000002,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,94,11.538472928000003,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,95,11.9106535,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,96,12.290752511999999,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,97,12.678853316,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,98,13.075039263999999,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,99,13.479393707999998,13.891999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,100,13.891999999999999,13.891999999999999]

{"sheet":"VSD_curves","index":10,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,"sys","h2","q","h","q/qd","h/hd"]
[null,null,null,null,null,null,null,{"$f":"$K$7*((J2/$J$7)^2)","v":0},{"$f":"K2*((Level_3!$B$10*0.01)^2)","v":20},{"$f":"($J$7/$L$7)*L2","v":0},{"$f":"N2*($K$7/$N$7)","v":35.555555555555557},0,100,100]
[null,null,null,null,null,null,null,0.32000000000000006,{"$f":"K3*((Level_3!$B$10*0.01)^2)","v":19.98},12.5,35.520000000000003,10,{"$f":"100-(((L3)^0.5)^(4/3))","v":95.358411166387214},{"$f":"100-((L3^2)*0.001)","v":99.9}]
[null,null,null,null,null,null,null,1.2800000000000002,{"$f":"K4*((Level_3!$B$10*0.01)^2)","v":19.920000000000002},25,35.413333333333334,20,{"$f":"100-(((L4)^0.5)^(4/3))","v":92.631937002719226},{"$f":"100-((L4^2)*0.001)","v":99.6}]
[null,null,null,null,null,null,null,11.52,{"$f":"K5*((Level_3!$B$10*0.01)^2)","v":19.28},75,34.275555555555556,60,{"$f":"100-(((L5)^0.5)^(4/3))","v":84.673811352128936},96.4]
[null,null,null,null,null,null,null,20.480000000000004,{"$f":"K6*((Level_3!$B$10*0.01)^2)","v":18.72},{"$f":"($J$7/$L$7)*L6","v":100},{"$f":"N6*($K$7/$N$7)","v":33.28},80,81.433644665548883,93.6]
[null,null,null,null,null,null,null,{"$f":"$K$7*((J7/$J$7)^2)","v":32},{"$f":"K7*((Level_3!$B$10*0.01)^2)","v":18},{"$f":"Level_3!B6","v":125},{"$f":"Level_3!B7","v":32},100,78.455653099681157,90]
[null,null,null,null,null,null,null,{"$f":"$K$7*((J8/$J$7)^2)","v":46.08},{"$f":"K8*((Level_3!$B$10*0.01)^2)","v":17.12},{"$f":"($J$7/$L$7)*L8","v":150},{"$f":"N8*($K$7/$N$7)","v":30.435555555555556},120,75.671192017706403,85.6]
[null,null,null,null,null,null,null,62.719999999999992,{"$f":"K9*((Level_3!$B$10*0.01)^2)","v":16.080000000000002},{"$f":"($J$7/$L$7)*L9","v":175},{"$f":"N9*($K$7/$N$7)","v":28.58666666666667},140,73.038005002241491,80.400000000000006]
[null,null,null,null,null,null,null,81.920000000000016,{"$f":"K10*((Level_3!$B$10*0.01)^2)","v":14.880000000000003},200,26.453333333333337,160,70.527748010876905,74.400000000000006]
[null,null,null,null,null,null,null,103.68,{"$f":"K11*((Level_3!$B$10*0.01)^2)","v":13.52},225,24.035555555555554,180,68.120242924521662,67.599999999999994]
[null,null,null,null,null,null,null,128,{"$f":"K12*((Level_3!$B$10*0.01)^2)","v":12.000000000000002},250,21.333333333333336,200,65.800481066466062,60]
[null,null,null,null,null,null,null,154.88000000000002,{"$f":"K13*((Level_3!$B$10*0.01)^2)","v":10.32},275,18.346666666666668,220,63.556916128084168,51.6]