{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Pellet Boiler Calculator","Servicing Calculator","DHW Demand Estimator","Data sources","Tool Temp Rise = Energy","Tool Cold~Hot"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":"Pellet Boiler Calculator","index":0,"n_rows":89,"n_cols":13,"rows_kept":89,"cut":false,"hidden":false,"merged":[[87,8,87,10],[6,1,6,5],[7,1,7,5],[10,1,10,5],[12,1,12,5],[22,3,22,5],[84,3,86,3],[84,4,86,4],[8,1,8,5],[66,1,66,5],[72,3,72,5],[64,1,64,5],[63,1,63,5],[10,7,10,10],[11,9,11,10],[20,7,20,10],[22,7,22,10],[23,7,23,10],[11,1,11,5],[65,1,65,5],[85,2,86,2],[21,7,21,10],[21,3,21,5],[40,3,40,5]]}
[]
[]
[]
[]
[]
[]
[null,"Pellet boiler toolkit"]
[null,"V2.2 May 2022"]
[null,"Enter data in to yellow cells, results in green cells"]
[]
[null,"Pellet boilers for DHW systems",null,null,null,null,null,"Fuel comparison for DHW - carbon emissions & running costs"]
[null,"Use this calculator for DHW loads.  Depending on heating load these boilers may be able to deliver space heating as well",null,null,null,null,null,"Annual estimated fuel use",{"$f":"C16*365","v":305581.39534883719},"kWh/year"]
[null,"Use DHW Demand Estimator worksheet for guidance on estimating DHW consumption for different building typologies",null,null,null,null,null,"Fuel","CO2 emissions kgCO2e","Reduction in CO2 emissions if replaced with pellets","Estimated annual running cost"]
[null,"Enter project specific data in yellow boxes",null,null,null,null,null,"Pellets",{"$f":"I12*'Data sources'!K4","v":896.37209302325573},{"$f":"(I14/I14)-1","v":0},{"$f":"$I$12*'Data sources'!E23","v":23967.168262653897}]
[null,"Litres of DHW/day",15000,"Normalise to 60°C",null,null,null,"Natural gas",{"$f":"I12*'Data sources'!K5","v":59588.372093023252},{"$f":"($I$14/I15)-1","v":-0.98495726495726499},{"$f":"$I$12*'Data sources'!E18","v":33613.953488372092}]
[null,"Energy required",{"$f":"C15*48/860","v":837.20930232558135},"kWh / day (48°C temperature rise from cold)",null,null,null,"LPG",{"$f":"I12*'Data sources'!K13","v":67636.012423301276},{"$f":"($I$14/I16)-1","v":-0.98674711797890602},{"$f":"$I$12*'Data sources'!E19","v":54745.852586925226}]
[null,"Average DHW demand period",12,"hours",null,null,null,"Electricity",{"$f":"I12*'Data sources'!K7","v":32697.20930232558},-0.97258566978193151,{"$f":"$I$12*'Data sources'!E21","v":64172.093023255809}]
[null,"Average hourly DHW load",{"$f":"C16/C17","v":69.767441860465112},"kW",null,null,null,"Heat pump COP 3 + electricity ",{"$f":"I12/3*'Data sources'!K7","v":10899.069767441861},-0.91775700934579441,{"$f":"(I12/3)*'Data sources'!E21","v":21390.697674418603}]
[null,"Peak DHW load",0.5,"of total daily use",null,null,null,"Diesel",{"$f":"I12*'Data sources'!K6","v":81284.651162790702},-0.98897243107769428,{"$f":"$I$12*'Data sources'!E20","v":61116.279069767443}]
[null,"No. hours at peak DHW load",2,"hours",null,null,null,"Coal",{"$f":"I12*'Data sources'!K8","v":73721.511627906977},-0.98784110535405878,{"$f":"$I$12*'Data sources'!E22","v":13369.186046511626}]
[null,"Peak hourly DHW load ",{"$f":"(C15*C19)/C20","v":3750},"Litres",null,null,null,"For simple comparison all systems calculated at 100% efficiency except heat pumps at 300%."]
[null,"Indicative no. Pellematic boilers",{"$f":"ROUNDUP((C18/64),0)","v":2},"OkoFEN PES64 boilers (additional boiler may be required for redundancy in critical service provision)",null,null,null,"Fuel carbon emission factors and average costs take from MfE and MBIE figures respectively - see Data Sources tab"]
[null,"Estimated buffer storage required",{"$f":"IF(C21<1000,\"1,000\",IF(C21<2000,\"2,000\",IF(C21<3000,\"3,000\",IF(C21<4000,\"4,000\",IF(C21<5000,\"5,000\",IF(C21>=5000,\"6,000\"))))))","v":"4,000"},"Litres stored to meet peak load requirements (may be inaccurate in large or very peaky DHW loads)",null,null,null,"Natural gas price is seldom seen in all but very largest commercial gas users - cost is likely to be higher in reality"]
[null,"Peak output of boilers",{"$f":"ROUNDUP(C22,0)*64","v":128},"kW",null,null,null,"Heat pump running cost unlikely to be full cost as boosting electricity will be required"]
[null,"Recovery time of buffer from cold",{"$f":"C26/C24","v":2.2892441860465116},"hours"]
[null,"Energy stored in buffer",{"$f":"C23*63/860","v":293.02325581395348},"kWh at 80°C"]
[]
[null,"Estimated fuel consumption & storage required for DHW",null,null,null,null,null,"Flexilo storage","Tonnes stored","Footprint","Dimensions","Flexilo","Price inc vacuum hoses"]
[null,"Average DHW energy per month",{"$f":"C16*(365/12)","v":25465.116279069767},"kWh / month",null,null,null,"Small",4,3.4,"1.84 x 1.84m","KGT1818EU",{"$f":"6100+1600","v":7700}]
[null,"Tonnes of pellets required",{"$f":"(C29/0.93)/5100","v":5.3689893061500671},"tonnes / month at 93% boiler efficiency, 5,100kWh / tonne fuel",null,null,null,"Medium",8,6.8,"2.6 x 2.6m","KGT2626EU",{"$f":"7400+1600","v":9000}]
[null,"Select storage room available","Large","Flexilo bagged pellet storage - can be larger as required",null,null,null,"Large",16,13.6,"2 x (2.6 x 2.6m)","2 x KGT2626EU",{"$f":"14800+1600","v":16400}]
[null,"Pellet fuel store footprint",{"$f":"VLOOKUP(C31,Flexilo,3,FALSE)","v":13.6},"m²"]
[null,"Annual pellet fuel use",{"$f":"C30*12","v":64.427871673800809},"tonnes"]
[null,"Amount of pellet fuel stored on site",{"$f":"VLOOKUP(C31,Flexilo,2,FALSE)","v":16},"tonnes"]
[null,"Approximate delivery frequency",{"$f":"C34/C30","v":2.980076712328767},"months between deliveries"]
[]
[null,"Pellet boiler system for DHW and indicative cost (not including flues, site variable depending on height)"]
[null,"Proposed number of boilers",{"$f":"C22","v":2},"OkoFEN PES64 boilers"]
[null,"Proposed number of DHW cylinders",{"$f":"IF(C23=\"1,000\",\"1 x 1,000L\",IF(C23=\"2,000\",\"1 x 2,000L\",IF(C23=\"3,000\",\"2 x 1,500L\",IF(C23=\"4,000\",\"2 x 2,000L\",IF(C23=\"5,000\",\"3 x 2,000L\",IF(C23=\"6,000\",\"3 x 2,000L\"))))))","v":"2 x 2,000L"},"Stainless steel for potable DHW, indoor case"]
[null,"Proposed Flexilo pellet storage",{"$f":"C31","v":"Large"},"Flexilo"]
[null,"Estimated cost of boilers",{"$f":"IF(C38=1, 44000, IF(C38>1,C38*38500))*1.1","v":84700},"Includes boiler, PWM primary pump/s, expansion vessel, controller"]
[null,"Estimated cost of DHW cylinders",{"$f":"IF(C39=\"1 x 1,000L\",10000,IF(C39=\"1 x 2,000L\",20000,IF(C39=\"2 x 1,500L\",13600,IF(C39=\"2 x 2,000L\",40000,IF(C39=\"3 x 2,000L\",60000,IF(C39=\"3 x 2,000L\",60000))))))*1.1","v":44000},"Cylinder"]
[null,"Estimated cost of pellet storage",{"$f":"VLOOKUP(C40,Flexilo,6,FALSE)*1.1","v":18040},"Includes vacuum fuel delivery system"]
[null,"Estimated total system cost",{"$f":"SUM(C41:C43)","v":146740},"exc GST, freight, flues, HX if required, installation materials, labour"]
[]
[null,"Indicative area required for boilers, buffers & fuel storage - not including clearances"]
[null,"Proposed number of boilers",{"$f":"C22","v":2},"OkoFEN PES64 boilers"]
[null,"Floor area for boilers",{"$f":"IF(C47=1,\"3.6\", IF(C47>1,C47*3.6))","v":7.2},"m²"]
[null,"Floor area for buffers",{"$f":"IF(C23=\"1,000\",1,C23*0.0013)","v":5.2},"m²"]
[null,"Floor area for pellet storage",{"$f":"C32","v":13.6},"m²"]
[null,"Total floor area (indicative)",{"$f":"SUM(C48:C50)","v":26},"m²"]
[]
[]
[null,"Basic Space Heating System Calculator "]
[null,"Does not consider potential to reduce boiler numbers with buffers"]
[null,"Enter project specific data in yellow boxes"]
[null,"Area of building to heat",1000,"m²"]
[null,"Indicative heat load",{"$f":"C57*E58/1000","v":70},"kW",70,"70W/m2 standard heat load figure for calculation - adjust if necessary"]
[null,"Enter heat load if known",null,"kW"]
[null,"Calculated heat load",{"$f":"MAX(C58:C59)","v":70},"kW"]
[null,"Indicative no. Pellematic boilers",{"$f":"ROUNDUP(C60/64,0)","v":2},"OkoFEN PES64 boilers"]
[null,"Peak output of boilers",{"$f":"IF(C61<1.9,\"64\",ROUNDUP(C61*64,0))","v":128},"kW"]
[null,"Notes:"]
[null,"Depending on hours of heat load, buffers can be used to reduce number of boilers for peak load"]
[null,"Depending on hours of space heating load boilers indicated above may be able to deliver DHW or other loads, i.e. swimming pools, hot tubs, etc"]
[null,"Pellet consumption and storage required will vary depending on building insulation levels, location and temperature set points (degree days).  This cannot be calculated using this toolkit"]
[null,"Annual fuel consumption, running cost and carbon emissions for space heating systems require more detailed calculation of seasonal heat loads.  Contact Apricus for assistance with this calculation."]
[]
[null,"Pellet boiler system for space heating and indicative cost "]
[null,"Proposed number of boilers",{"$f":"C61","v":2},"OkoFEN PES64 boilers"]
[null,"Proposed number of buffers","n/a","Contact Apricus for designs"]
[null,"Proposed Flexilo pellet storage","n/a","Contact Apricus for designs"]
[null,"Estimated total system cost",{"$f":"IF(C70=1,\"$44,000\", IF(C70>1,C70*39000))*1.1","v":85800},"exc GST, pellet storage, buffer if required, freight, flues, HX if required, installation materials, labour"]
[]
[]
[null,"Replacement system - current fuel comparison calculator"]
[null,"Current fuel use","Enter ONE fuel use in litres, kg or tonnes","Calculated or enter kWh in yellow","CO2 emissions kgCO2e"]
[null,"Natural gas kWh",null,0,{"$f":"D78*'Data sources'!K5","v":0}]
[null,"Diesel litre",10000,{"$f":"C79*'Data sources'!G6","v":100000},{"$f":"D79*'Data sources'!K6","v":26600}]
[null,"Electricity kWh",null,0,{"$f":"D80*'Data sources'!K7","v":0}]
[null,"LPG kg",0,{"$f":"C81*('Data sources'!G10/45)","v":0},{"$f":"D81*'Data sources'!K10","v":0}]
[null,"Coal tonnes",0,{"$f":"C82*'Data sources'!G8*1000","v":0},{"$f":"D82*'Data sources'!K8","v":0}]
[null,null,"Annual max ",{"$f":"MAX(D78:D82)","v":100000},{"$f":"MAX(E78:E82)","v":26600}]
[null,null,null,"kWh","kg CO2e"]
[null,"Choose from list of boiler use:",null,{"$f":"IF(C86=\"heating season only\",6,12)","v":6},"months fuel use"]
[null,"Heating season only","Heating season only"]
[null,"All year - DHW"]
[null,null,"Indicative tonnes of pellets per year","CO2 emissions with pellets","CO2 emission savings","Estimated volume required for pellet storage assuming deliveries every 2 months m³","Total fuel volume /year                          m³","Estimated annual cost of pellet fuel","Minimum economic delivery is generally 5 tonnes. NB delivery frequency & stored volume can be modified to suit site  needs."]
[null,"Pellet fuel",{"$f":"D83/5100","v":19.607843137254903},{"$f":"D83*'Data sources'!K4","v":293.33333333333331},{"$f":"(D89/E83)-1","v":-0.98897243107769428},{"$f":"G89/(IF(C85=6,3,6))","v":5.0276520864756158},{"$f":"C89/0.65","v":30.165912518853695},{"$f":"C89*5100*'Data sources'!E23","v":7843.1372549019607}]

{"sheet":"Servicing Calculator","index":1,"n_rows":63,"n_cols":11,"rows_kept":63,"cut":false,"hidden":false,"merged":[[7,1,7,5],[4,1,4,5],[5,1,5,5],[6,1,6,5]]}
[]
[]
[]
[]
[null,"OkoFEN pellet boiler maintenance & service guidance"]
[null,"Cost per each single OkoFEN boiler"]
[null,"Does not include any labour or materials for servicing any other components of the system, e.g. corrosion inhibitor"]
[null,"travel, management oversight, heating system servicing and any consumables are not included"]
[]
[null,"NOTE - servicing required after 40 tonnes pellets or 3,000 hours, whichever sooner"]
[null,"Number of OkoFEN boilers at site",1]
[null,"Total tonnes of pellets for site / yr",50,{"$f":"(C12/C11)/40","v":1.25},"Boiler annual servicing factor"]
[null,"Number of services / boiler / yr",{"$f":"IF(D12<1,\"1\",D12)","v":1.25}]
[]
[null,"Hours per boiler (4 hours suggested)","Hourly rate","Labour cost per boiler"]
[null,4,85,{"$f":"C16*B16","v":340},"Modify any figures in yellow to change total costs"]
[]
[null,"STANDARD SITES - DHW NOT CRITICAL SERVICE",null,null,null,null,null,null,null,"All replaceable parts covered under warranty for first 2 years"]
[null,"Years","Expected Visits","Labour","Parts","Total per boiler","Total for site","Total for site over period","5 year maintenance costs estimated"]
[null,"1-2",1,{"$f":"D16*C20","v":340},{"$f":"D38","v":0},{"$f":"(D20+E20)*C13","v":425},{"$f":"F20*$C$11","v":425},{"$f":"G20*2","v":850},null,"Years"]
[null,"3-5",1.5,{"$f":"C21*D$16","v":510},{"$f":"D39","v":0},{"$f":"(D21+E21)*C13","v":637.5},{"$f":"F21*$C$11","v":637.5},{"$f":"G21*3","v":1912.5},{"$f":"(G20*2)+(G21*3)","v":2762.5},"1 to 5"]
[null,"5-10",2,{"$f":"C22*D$16","v":680},{"$f":"E39","v":1019.434},{"$f":"(D22+E22)*C13","v":2124.2925},{"$f":"F22*$C$11","v":2124.2925},{"$f":"G22*5","v":10621.4625},{"$f":"G22*5","v":10621.4625},"5 to 10"]
[null,"10-15",2.5,{"$f":"C23*D$16","v":850},{"$f":"F39","v":1423.0580000000002},{"$f":"(D23+E23)*C13","v":2841.3225000000002},{"$f":"F23*$C$11","v":2841.3225000000002},{"$f":"G23*5","v":14206.612500000001},{"$f":"G23*5","v":14206.612500000001},"10 to 15"]
[null,null,null,null,null,null,"Average annual maintenance costs for site over 15 years",{"$f":"SUM(H20:H23)/15","v":1839.3716666666667}]
[null,null,null,null,null,null,"Per boiler over 15 years",{"$f":"H24/C11","v":1839.3716666666667}]
[]
[null,"SITES WITH DHW AS CRITICAL SERVICE - ONLY SERVICE 1 BOILER PER VISIT",null,null,null,2,"additional time for repeat visits, i.e. not all boilers can be serviced on same day for redundancy reasons"]
[null,"Years","Expected Visits","Labour","Parts","Total per boiler","Total for site","Total for site over period","5 year maintenance costs estimated"]
[null,"1-2",{"$f":"C20*F27","v":2},{"$f":"(C29*D16)","v":680},{"$f":"D38","v":0},{"$f":"(D29+E29)*C13","v":850},{"$f":"F29*C11","v":850},{"$f":"G29*2","v":1700},null,"Years"]
[null,"3-5",{"$f":"C21*F27","v":3},{"$f":"(C30*D16)","v":1020},{"$f":"D39","v":0},{"$f":"(D30+E30)*C13","v":1275},{"$f":"F30*C11","v":1275},{"$f":"G30*3","v":3825},{"$f":"(G29*2)+(G30*3)","v":5525},"1 to 5",{"$f":"I21/I30","v":0.5}]
[null,"5-10",{"$f":"C22*F27","v":4},{"$f":"(C31*D16)","v":1360},{"$f":"E39","v":1019.434},{"$f":"(D31+E31)*C13","v":2974.2925000000005},{"$f":"F31*C11","v":2974.2925000000005},{"$f":"G31*5","v":14871.462500000001},{"$f":"G31*5","v":14871.462500000001},"5 to 10"]
[null,"10-15",{"$f":"C23*F27","v":5},{"$f":"(C32*D16)","v":1700},{"$f":"F39","v":1423.0580000000002},{"$f":"(D32+E32)*C13","v":3903.8225000000002},{"$f":"F32*C11","v":3903.8225000000002},{"$f":"G32*5","v":19519.112500000003},{"$f":"G32*5","v":19519.112500000003},"10 to 15"]
[null,null,null,null,null,null,"Average annual maintenance costs for site over 15 years",{"$f":"SUM(H29:H32)/15","v":2661.0383333333334}]
[null,null,null,null,null,null,"Per boiler over 15 years",{"$f":"H33/C11","v":2661.0383333333334}]
[]
[null,"Conservative figures for replacement parts and costs per boiler over years 3 to 15, see workings in table below",null,null,null,null,"All parts in years 1 to 2 are covered under warranty"]
[null,null,"Years","3-5","5-10","10-15"]
[null,null,"Total average parts cost",{"$f":"SUM(H43:H63)","v":0},{"$f":"SUM(I43:I63)","v":5097.17},{"$f":"SUM(J43:J63)","v":7115.2900000000009}]
[null,null,"Average cost per year",{"$f":"+D38/3","v":0},{"$f":"+E38/5","v":1019.434},{"$f":"+F38/5","v":1423.0580000000002}]
[]
[null,null,null,null,"Conservative quantity of parts over years",null,null,"Average cost over years"]
[null,"Spare parts","Part Number","Cost","3-5","5-10","10-15","3-5","5-10","10-15","Conservative number of replacements over period"]
[null,"Controller CP021","E1411",2085.2000000000003,0,0.3,0.5,{"$f":"+E43*$D43","v":0},625.56000000000006,1042.6000000000001,{"$f":"+E43+F43+G43","v":0.8}]
[null,"Touch display","E1330",1410.5,0,0.3,0.5,0,423.15,705.25,0.8]
[null,"Negative pressure sensor",24155,148.20000000000002,0,0.4,0.6,0,59.280000000000008,88.92,1]
[null,"Chamber sensor set","PE277S",289.90000000000003,0,1,1,0,289.90000000000003,289.90000000000003,2]
[null,"Boiler sensor","E1049",46.800000000000004,0,0.3,0.4,0,14.040000000000001,18.720000000000002,0.7]
[null,"Boiler temperature limiter STB","E1073",88.4,0,0.3,0.4,0,26.52,35.360000000000007,0.7]
[null,"Main switch","E1653",88.4,0,0.3,0.4,0,26.52,35.360000000000007,0.7]
[null,"Ignition element","E1004",183.3,0,0.6,0.9,0,109.98,164.97000000000003,1.5]
[null,"Burner motor","E1306",743.6,0,0.3,0.4,0,223.08,297.44,0.7]
[null,"Cleaning motor","E1204E",245.70000000000002,0,0.4,0.6,0,98.280000000000015,147.42000000000002,1]
[null,"Belimo valve","E1413E",1028.3,0,0.4,0.6,0,411.32,616.9799999999999,1]
[null,"Burner fan","E1005P",510.90000000000003,0,0.3,0.4,0,153.27000000000001,204.36,0.7]
[null,"Exhaust extractor","E1249P",995.80000000000007,0,0.4,0.6,0,398.32000000000005,597.48,1]
[null,"Burner plate","B213",492.7,0,0.6,0.8,0,295.62,394.16,1.4]
[null,"Cumbustion pipe","B174",670.80000000000007,0,1.3,1.6,0,872.04000000000008,1073.2800000000002,2.9000000000000004]
[null,"Ash screw hardened","PE462-1",393.90000000000003,0,0.4,0.5,0,157.56000000000003,196.95000000000002,0.9]
[null,"Burner cleaning motor","E1640",789.1,0,0.3,0.4,0,236.73,315.64000000000004,0.7]
[null,"Suction turbine","E1205P",640.9,0,0.3,0.4,0,192.26999999999998,256.36,0.7]
[null,"Silo motor","K130",1179.1000000000001,0,0.3,0.4,0,353.73,471.6400000000001,0.7]
[null,"Others",null,325,0,0.4,0.5,0,130,162.5,0.9]
[null,null,null,null,"Warranty cover"]

{"sheet":"DHW Demand Estimator","index":2,"n_rows":185,"n_cols":15,"rows_kept":185,"cut":false,"hidden":false,"merged":[[9,1,10,1],[9,2,10,3],[23,1,26,1],[23,5,26,9],[32,1,35,1],[32,5,35,9],[41,1,44,1],[41,5,44,9],[51,1,51,4],[69,1,76,1],[69,5,76,9]]}
[]
[]
[null,"Domestic Hot Water Daily Demand Estimator"]
[null,"Use this sheet to estimate daily domestic hot water demand"]
[]
[null,"Step One","Choose buidling location ","Choose Building Location",{"$f":"IF(D6=\"Auckland - NZ\", \"Default location\",\" \")","v":" "}]
[null,"Step Two","Click button below for prefered calculation methodology for DHW demand estimation"]
[]
[]
[null,"Step Three","Proceed to chosen estimation tool below",null,null,null,"Compare esimatation methods for DHW demand summary L/day at 60°C"]
[null,null,null,null,null,null,"Green Star",{"$f":"D62","v":0}]
[null,null,null,null,null,null,"Energy Use",{"$f":"D78","v":0}]
[null,null,null,null,null,null,"ASHRAE Total",{"$f":"D47","v":21820}]
[null,null,"Estimated DHW demand",{"$f":"IF(D15=\"Energy Use\",H12,IF(D15=\"NZ GBC\",H11,IF(D15=\"ASHRAE\",H13,0)))","v":0},"L/Day",null,"ASHRAE Type 1",{"$f":"D27","v":14019.999999999998},{"$f":"IF(H14=0,\"Not selected\",\"Selected\")","v":"Selected"}]
[null,null,"Estimation method selected","Energy Use",null,null,"ASHRAE Type 2",{"$f":"D36","v":7800},{"$f":"IF(H15=0,\"Not selected\",\"Selected\")","v":"Selected"}]
[null,null,null,null,null,null,"ASHRAE Type 3",{"$f":"D45","v":0},{"$f":"IF(H16=0,\"Not selected\",\"Selected\")","v":"Not selected"}]
[]
[]
[]
[]
[null,"ASHRAE DHW Estimator by Building Type / Application"]
[null,"Choose building type and entire data for up to 3 building types / applications below",null,null,null,"Notes on ASHRAE domestic hot water data"]
[]
[null,1,"Building Type / Application","Apartment (76-100 Units)",{"$f":"IF(ISNUMBER(SEARCH(\"Hotel\",D24)),\" confirm # units\",IF(ISNUMBER(SEARCH(\"Apartment\",D24)),\" confirm # units\",IF(ISNUMBER(SEARCH(\"Office\",D24)),\" adjust occupancy\",\"\")))","v":" confirm # units"},{"$f":"UPPER(D24&\":\")&(VLOOKUP(D24,$C$101:$L$124,8,FALSE))","v":"APARTMENT (76-100 UNITS): Hot water requirements for both garden-type and high-rise apartments  for 1 and 2 bath apartments, for showers, lavatories, kitchen, dishwasher, clothes washers, and general cleaning. These data apply to central water heating systems only."}]
[null,null,{"$f":"(VLOOKUP(D24,$C$101:$I$124,2,FALSE))","v":"Number of Units"},100,{"$f":"(VLOOKUP(D24,$C$101:$I$124,7,FALSE))","v":"units"}]
[null,null,"Hot Water Usage Pattern","Average"]
[null,null,"Estimated Demand",{"$f":"IF(D26=\"Average\",VLOOKUP(D24,$C$101:$N$125,3,FALSE)*D25,IF(D26=\"High\",VLOOKUP(D24,$C$101:$N$125,4,FALSE)*D25))","v":14019.999999999998},"L/Day"]
[]
[]
[null,null,"Add second building type / application?","Yes"]
[]
[]
[null,2,"Building Type / Application","Restaurant (Quick Service)",{"$f":"IF(ISNUMBER(SEARCH(\"Hotel\",D33)),\" confirm # units\",IF(ISNUMBER(SEARCH(\"Apartment\",D33)),\" confirm # units\",IF(ISNUMBER(SEARCH(\"Office\",D33)),\" adjust occupancy\",\"\")))","v":""},{"$f":"UPPER(D33&\":\")&(VLOOKUP(D33,$C$101:$L$124,8,FALSE))","v":"RESTAURANT (QUICK SERVICE): Hot water requirements are primarily for dish washing. Other uses include food preparation, cleaning of utensils and floors, and hand washing for employees and customers. Recommendations are for  serving food at tables, counters, booths, and parked cars. Establishments that use disposable service exclusively are not covered."}]
[null,null,{"$f":"(VLOOKUP(D33,$C$101:$I$124,2,FALSE))","v":"Number of Meals per Day"},3000,{"$f":"(VLOOKUP(D33,$C$101:$I$124,7,FALSE))","v":"meals"}]
[null,null,"Hot Water Usage Pattern","Average"]
[null,null,"Estimated Demand",{"$f":"IF(D35=\"Average\",VLOOKUP(D33,$C$101:$N$125,3,FALSE)*D34,IF(D35=\"High\",VLOOKUP(D33,$C$101:$N$125,4,FALSE)*D34))","v":7800},"L/Day"]
[]
[]
[null,null,"Add third building type / application?","Yes"]
[]
[]
[null,3,"Building Type / Application","Select a building or application",{"$f":"IF(ISNUMBER(SEARCH(\"Hotel\",D42)),\" confirm # units\",IF(ISNUMBER(SEARCH(\"Apartment\",D42)),\" confirm # units\",IF(ISNUMBER(SEARCH(\"Office\",D42)),\" adjust occupancy\",\"\")))","v":""},{"$f":"UPPER(D42&\":\")&(VLOOKUP(D42,$C$101:$L$124,8,FALSE))","v":"SELECT A BUILDING OR APPLICATION:"}]
[null,null,{"$f":"(VLOOKUP(D42,$C$101:$I$124,2,FALSE))","v":"Unit"},null,{"$f":"(VLOOKUP(D42,$C$101:$I$124,7,FALSE))","v":""}]
[null,null,"Hot Water Usage Pattern","Average"]
[null,null,"Estimated Demand",{"$f":"IF(D44=\"Average\",VLOOKUP(D42,$C$101:$N$125,3,FALSE)*D43,IF(D44=\"High\",VLOOKUP(D42,$C$101:$N$125,4,FALSE)*D43))","v":0},"L/Day"]
[]
[null,null,"Estimated Daily Demand",{"$f":"D27+D36+D45","v":21820},"L/day at 60°C","NB: Check that total is correct for number of hot water applications selected"]
[]
[]
[]
[]
[null,"DHW Estimator for OFFICES, EDUCATION & INDUSTRIAL BUILDINGS ONLY from NZGBC GreenStar V3.2"]
[null,"Enter office occupancy and select hours of operation and water efficiency",null,null,null,"Notes on NZGBC method, data from GreenStar V3.2, Appendix I: WAT-1 Water Calculator Guide "]
[null,null,"Occupants"]
[null,null,"Hours of operation ","10 hrs/day, 5 days/wk",null,{"$f":"\"Occupancy multiplier of \"&TEXT(VLOOKUP(D55,G161:H165,2,FALSE),\"#0.0\")","v":"Occupancy multiplier of 1.0"}]
[null,null,"Shower usage ","Showers & 2 TRAvel points",null,{"$f":"IFERROR(\"Shower usage rate of \"&TEXT(VLOOKUP(D56,G166:H170,2,FALSE),\"#0%\"),\"\")","v":"Shower usage rate of 15%"}]
[null,null,"Water efficiency rating","WELS 4*",null,"WELS rating is for fixture total water consumption. This is adjusted below to show hot portion only."]
[null,null,"Shower consumption",{"$f":"VLOOKUP($D$57,$J$162:$L$168,2,FALSE)*$E$163","v":5.6},"L/min at 60°C",{"$f":"TEXT(VLOOKUP($D$57,$J$162:$L$168,2,FALSE),\"#0.0\")&\" L/min shower fittings\"","v":"9.0 L/min shower fittings"}]
[null,null,"Shower DHW demand",{"$f":"D58*$D$54*VLOOKUP($D$55,$G$161:$H$165,2,FALSE)*VLOOKUP($D$56,$G$166:$H$170,2,FALSE)*$K$169","v":0},"L/day at 60°C",null,null,null,{"$f":"\"HOT=\"&TEXT(D163,0)&\"°C\"&\", USE=\"&TEXT(D164,0)&\"°C\"&\", COLD=\"&TEXT(D165,\"#0.0\")&\"°C\"","v":"HOT=60°C, USE=43°C, COLD=15.0°C"}]
[null,null,"Wash Hand Basin consumption",{"$f":"VLOOKUP($D$57,$J$162:$L$168,3,FALSE)*$E$163","v":4.666666666666667},"L/min at 60°C",{"$f":"TEXT(VLOOKUP($D$57,$J$162:$L$168,3,FALSE),\"#0.0\")&\" L/min WHB fittings\"","v":"7.5 L/min WHB fittings"},null,null,{"$f":"\"Therefore HOT %=\"&TEXT(E163,\"#0%\")","v":"Therefore HOT %=62%"}]
[null,null,"Wash Hand Basin DHW demand",{"$f":"$D$60*$L$169*$L$170*$D$54*VLOOKUP($D$55,$G$161:$H$165,2,FALSE)","v":0},"L/day at 60°C"]
[null,null,"Estimated Daily Demand",{"$f":"D59+D61","v":0},"L/day at 60°C"]
[]
[]
[]
[]
[null,"Metered Energy Use DHW Estimator"]
[null,"Enter annual MWh use for water heating",null,null,null,"Notes on energy use method"]
[]
[null,null,"MWh used per year",null,"MWh/Year","Use this method if the MWh of consumption for water heating from electricity or gas is known. \nLPG 1MJ = 0.0139 MWh/kg \nNATURAL GAS 0.0002778 MWh/MJ \nSuggested efficiency of the 'heating type' is based on the typical equipment COP/efficiency used in these applications. This value can be altered by entering a % value for the 'known heater efficiency'. This method assumes the same set temperature difference between the target temperature and average cold inlet temperature.\n"]
[null,null,"Heating Type","Gas/Oil Heater "]
[null,null,"Suggested Heater Efficiency",{"$f":"VLOOKUP(D71,$F$180:$G$184,2,FALSE)","v":0.8}]
[null,null,"Known Heater Efficiency",0]
[null,null,"System Heat Loss",0.05]
[null,null,"Days usage per year",365,"Days"]
[null,null,"Estimated Annual Demand",{"$f":"IF(D73=0,D72*(1-D74)*(D70*859.8*1000)/(D163-D165),D73*(1-D74)*(D70*859.8*1000)/(D163-D165))","v":0},"L/Year"]
[]
[null,null,"Estimated Daily Demand",{"$f":"D76/D75","v":0},"L/day at 60°C"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Data Sources"]
[]
[null,null,"Service Water Heating by ASHRAE 2003",null,{"$f":"\"at 60°C (\"&(TEXT(D163-D165,0))&\"ºC temperature rise)\"","v":"at 60°C (45ºC temperature rise)"}]
[null,null,"Type Of Building","Unit Type","Average consumption (L/day/unit) ","Maximum consumption (L/unit/day)","Average Energy Use (kWh/unit/day)","Maximum Energy Use (kWh/unit/day)"]
[null,null,"Select a building or application","Unit",null,null,null,null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""}]
[null,null,"Apartment (<20 Units)","Number of Units",159.19999999999999,303.2,{"$f":"E102*($D$163-$D$165)*4.184/3600","v":8.326159999999998},15.85736,"units"," Hot water requirements for both garden-type and high-rise apartments  for 1 and 2 bath apartments, for showers, lavatories, kitchen, dishwasher, clothes washers, and general cleaning. These data apply to central water heating systems only."]
[null,null,"Apartment (21-50 Units)","Number of Units",151.6,276.7,7.9286799999999999,14.471410000000001,"units"," Hot water requirements for both garden-type and high-rise apartments  for 1 and 2 bath apartments, for showers, lavatories, kitchen, dishwasher, clothes washers, and general cleaning. These data apply to central water heating systems only."]
[null,null,"Apartment (51-75 Units)","Number of Units",144,250,7.5312000000000001,13.074999999999999,"units"," Hot water requirements for both garden-type and high-rise apartments  for 1 and 2 bath apartments, for showers, lavatories, kitchen, dishwasher, clothes washers, and general cleaning. These data apply to central water heating systems only."]
[null,null,"Apartment (76-100 Units)","Number of Units",140.19999999999999,227.4,7.3324599999999993,11.893020000000002,"units"," Hot water requirements for both garden-type and high-rise apartments  for 1 and 2 bath apartments, for showers, lavatories, kitchen, dishwasher, clothes washers, and general cleaning. These data apply to central water heating systems only."]
[null,null,"Apartment (100+ Units)","Number of Units",132.69999999999999,195,6.9402099999999995,10.198499999999999,"units"," Hot water requirements for both garden-type and high-rise apartments  for 1 and 2 bath apartments, for showers, lavatories, kitchen, dishwasher, clothes washers, and general cleaning. These data apply to central water heating systems only."]
[null,null,"High School","Number of Students",6.8,13.6,0.35564000000000001,0.71128000000000002,"students"," High schools require hot water for showers, lavatories, dishwashers, kitchens, and general cleaning. High schools without showers follow the recommendations for primary schools."]
[null,null,"Hotel/Motel (<20 units)","Number of Units",75.8,132.6,3.96434,6.9349800000000004,"units"," Domestic hot water requirements are for tubs and showers, lavatories, and general cleaning purposes. Food service, laundry, and swimming pool requirements are not included."]
[null,null,"Hotel/Motel (20-100 units)","Number of Units",53.1,94.8,2.7771300000000001,4.9580399999999996,"units"," Domestic hot water requirements are for tubs and showers, lavatories, and general cleaning purposes. Food service, laundry, and swimming pool requirements are not included."]
[null,null,"Hotel/Motel (100+ units)","Number of Units",37.9,56.8,1.98217,2.9706399999999999,"units"," Domestic hot water requirements are for tubs and showers, lavatories, and general cleaning purposes. Food service, laundry, and swimming pool requirements are not included."]
[null,null,"Military barracks","Number of Soldiers",114,{"$f":"E111*1.5","v":171},5.9622000000000002,8.9433000000000007,"soldiers"," The estimated DHW needs for a barracks building is 30 gal (114 L) of hot water per soldier per day at a temperature of 140 °F (60 °C). Most soldiers take two showers per day and one of them is in the morning, from 7:30 am to 8:00 am."]
[null,null,"Military mess hall","Number of Meals Per Day",9,18,0.47070000000000001,0.94140000000000001,"meals"," Three meals are served per day - breakfast (7:30 to 9:00 am), lunch (11:00 am to 1:00 pm) and supper (5:00 pm to 6:30 pm). The hot water use of this facility is per meal served. "]
[null,null,"Nursing Home","Number of Beds",69.7,114,3.6453099999999998,5.9622000000000002,"beds"," Hot water is required for tubs and showers, wash basins, service sinks, kitchen equipment, and general cleaning. These figures include hot water for kitchen use. When other equipment, such as that for heavy laundry and hydrotherapy purposes, is to be used, its hot water requirement should be added."]
[null,null,"Office Building","Number of People",3.8,7.6,0.19874000000000003,0.39748000000000006,"people"," Hot water requirements are primarily for cleaning and lavatory use by occupants and visitors. Hot water use for food service or shower facilities in office buildings is not included (add showers separately). Adjust occupancy by 1.4 = (7 days/wk), 2 = (24hrs/day, 5 days/wk), 2.8 = (24hrs/day, 7 days/wk)\n\n"]
[null,null,"Primary School","Number of Students",2.2999999999999998,5.7,0.12028999999999999,0.29811000000000004,"students"," Hot water requirements are for lavatories, cafeteria and kitchen use, and general cleaning purposes. When showers are used, their additional hot water requirements should be added."]
[null,null,"Restaurant (Quick Service)","Number of Meals per Day",2.6,22.7,0.13598000000000002,1.1872100000000001,"meals"," Hot water requirements are primarily for dish washing. Other uses include food preparation, cleaning of utensils and floors, and hand washing for employees and customers. Recommendations are for  serving food at tables, counters, booths, and parked cars. Establishments that use disposable service exclusively are not covered."]
[null,null,"Resturant (Full Meal)","Number of Meals per Day",9.1,41.7,0.47592999999999996,2.1809100000000003,"meals"," Hot water requirements are primarily for dish washing. Other uses include food preparation, cleaning of utensils and floors, and hand washing for employees and customers. Recommendations are for  serving food at tables, counters, booths, and parked cars. Establishments that use disposable service exclusively are not covered."]
[null,null,"Shower only","Number of Showers Per Day",{"$f":"114/60*5","v":9.5},{"$f":"E118*2","v":19},0.49685000000000001,0.99370000000000003,"showers"," Assumes an average shower length is 5 minutes, with average consumption of 9L/min, and high usage of 16L/min. For offices with showering for gym or cycling facilities assume 5-15% occupant usage to determine number of showers per day (e.g. number of office staff x 0.05)"]
[null,null,"Student Housing","Number of Students",49.7,100,2.59931,5.23,"students"," Hot water requirements for college dormitories generally include showers, lavatories,  ervice sinks, and clothes washers. The figures do not include hot water used for food service."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plumbing Engineering Design Handbook, Volume 2 © 2014, American Society of Plumbing Engineers."]
[null,null,"Service Water Heating by ASHRAE 2003"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"NZGBC GreenStar V3.2 Appendix I: WAT-1 Water Calculator Guide ",null,null,null,"Hours of occupancy multiplier",0,null,"Water efficiency ratings","Shower L/min","WHB L/min"]
[null,null,null,null,"Water ratio",null,"10 hrs/day, 5 days/wk",1,null,"WELS 0*",18,18]
[null,null,"Hot",60,{"$f":"(D164-D165)/(D163-D165)","v":0.62222222222222223},null,"10 hrs/day, 7 days/wk",1.4,null,"WELS 1*",16,16]
[null,null,"Use",43,null,null,"24 hrs/day, 5 days/wk",2,null,"WELS 2*",12,12]
[null,null,"Cold",15,{"$f":"(D163-D164)/(D163-D165)","v":0.37777777777777777},null,"24 hrs/day, 7 days/wk",2.8,null,"WELS 3*",9,9]
[null,null,null,null,null,null,"Shower use %",{"$f":"\"\"","v":""},null,"WELS 4*",9,7.5]
[null,null,null,null,null,null,"No showers",0,null,"WELS 5*",9,6]
[null,null,null,null,null,null,"Showers (low use)",0.05,null,"WELS 6*",9,4.5]
[null,null,null,null,null,null,"Showers & 1 TRAvel point or gym",0.1,null,"Usage Time (mins)",5,0.17]
[null,null,null,null,null,null,"Showers & 2 TRAvel points",0.15,null,"Usage per day per occupant",null,2.5]
[]
[null,null,"Average demand","at 49C","at 60C"]
[null,null,"Medium",113.6,{"$f":"D173/0.77","v":147.53246753246754}]
[null,null,"High",205,266.23376623376623]
[null,null,"Max demand","at 49C","at 60C"]
[null,null,"Medium",185,{"$f":"D176/0.77","v":240.25974025974025}]
[null,null,"High",340,441.55844155844153]
[]
[]
[null,null,null,null,null,"Select Heating Type",0]
[null,null,"Select estimation method",null,null,"Gas/Oil Heater ",0.8,"Average"]
[null,null,"Energy Use",null,null,"Electrical Element",1,"High"]
[null,null,"Green Star",null,null,"Heat Pump",3.5]
[null,null,"ASHRAE",null,null,"Modern Pellet Boiler ",0.85,"No"]
[null,null,"All",null,null,null,null,"Yes"]

{"sheet":"Data sources","index":3,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Fuel conversions - MfE Measuring Emissions 2022 summary of emissions factors, using data from 2020"]
[null,null,null,"kg","Litres","MJ","kWh / unit","m³","kWh/kg","CO2e/unit","CO2e/kWh","kgCO2e/MWh"]
[null,"Pellets (wood - industrial)","kg",1,null,null,5.0999999999999996,{"$f":"1/0.65","v":1.5384615384615383},{"$f":"G4/D4","v":5.0999999999999996},1.4959999999999999E-2,{"$f":"J4/I4","v":2.9333333333333334E-3},{"$f":"K4*1000","v":2.9333333333333336}]
[null,"Natural Gas","kWh",null,null,null,1,null,null,0.19500000000000001,0.19500000000000001,{"$f":"K5*1000","v":195}]
[null,"Diesel","litre",null,1,null,10,null,null,2.66,{"$f":"J6/G6","v":0.26600000000000001},{"$f":"K6*1000","v":266}]
[null,"Electricity","kWh",null,null,null,1,null,null,null,0.107,{"$f":"K7*1000","v":107}]
[null,"Coal - default","kg",1,null,{"$f":"G8*3.6","v":28.8},8,null,8,1.93,{"$f":"J8/I8","v":0.24124999999999999},{"$f":"K8*1000","v":241.25}]
[null,"Coal - Huntly peas","kg",1,null,{"$f":"G9*3.6","v":28.8},8,null,8,2.1419459999999999,{"$f":"J9/I9","v":0.26774324999999999},{"$f":"K9*1000","v":267.74324999999999}]
[null,"LPG","kg",45,84,2212,614,null,{"$f":"G10/D10","v":13.644444444444444},3.02,{"$f":"J10/I10","v":0.22133550488599349},{"$f":"K10*1000","v":221.33550488599349}]
[null,"LPG","kg",90,167,4423,1229,null,{"$f":"G11/D11","v":13.655555555555555},3.02,{"$f":"J11/I11","v":0.22115541090317331},{"$f":"K11*1000","v":221.1554109031733}]
[null,"LPG","kg",210,3980,10321,2867,null,{"$f":"G12/D12","v":13.652380952380952},3.02,0.22120683641437044,221.20683641437046]
[null,"LPG","kg",{"$f":"G13/G10*45","v":219.8697068403909},null,null,3000,null,{"$f":"G13/D13","v":13.644444444444442},3.02,{"$f":"J13/I13","v":0.22133550488599352},221.33550488599352]
[null,"https://environment.govt.nz/publications/measuring-emissions-a-guide-for-organisations-2022-summary-of-emission-factors/"]
[]
[null,"Commercial average fuel costs May 2022"]
[null,null,null,"$/unit","$/kWh"]
[null,"Natural Gas",null,null,0.11]
[null,"LPG per 45kg bottle",null,110,{"$f":"D19/G10","v":0.17915309446254071}]
[null,"Diesel - litres",null,2,0.2]
[null,"Electricity",null,null,0.21]
[null,"Coal - commercial sub-bituminous tonne",null,350,{"$f":"D22/(G8*1000)","v":4.3749999999999997E-2}]
[null,"Pellets - tonnes",null,400,{"$f":"D23/(G4*1000)","v":7.8431372549019607E-2},"Note - price per tonne will vary depending on delivery quantity, annual consumption and location for freight cost"]
[null,"Average market rates for these fuels without published data"]
[null,"Prices updated based on standard commercial contracts offered May 2022."]

{"sheet":"Tool Temp Rise = Energy","index":4,"n_rows":51,"n_cols":6,"rows_kept":51,"cut":false,"hidden":false,"merged":[[38,2,38,5],[50,2,50,5],[0,0,0,7],[3,2,3,5],[5,2,5,5],[20,2,20,4],[29,2,29,4],[37,2,37,4]]}
["Back to INDEX page"]
[]
[]
[null,null,"Energy vs Temperature Rise Calculators"]
[]
[null,null,"Energy Required to Raise Water Temperature"]
[]
[null,null,"Water Vol (L)","Temp Rise (oC)","Energy Required"]
[null,null,2200,50,{"$f":"C9*D9","v":110000},"kcal"]
[null,null,null,null,{"$f":"E9/859.8","v":127.93672947197024},"kWh"]
[null,null,null,null,{"$f":"E10*3412","v":436520.12095836247},"Btu"]
[null,null,null,null,{"$f":"E10*3.6","v":460.57222609909286},"MJ"]
[]
[null,null,"Water Vol (US gal)","Temp Rise (oF)","Energy Required"]
[null,null,5000,80,{"$f":"(C15*3.785)*(D15*0.5555)","v":841027},"kcal"]
[null,null,null,null,{"$f":"E15/859.8","v":978.16585252384277},"kWh"]
[null,null,null,null,{"$f":"E16*3412","v":3337501.8888113517},"Btu"]
[null,null,null,null,{"$f":"E16*3.6","v":3521.3970690858341},"MJ"]
[]
[]
[null,null,"Temperature Rise for Given Energy Input"]
[]
[null,null,"Energy Input (kWh)","Water Vol (L)","Temp Rise (oC)"]
[null,null,95,2200,{"$f":"(C24*859.8)/D24","v":37.12772727272727}]
[]
[null,null,"Energy Input (Btu)","Water Vol (US gal)","Temp Rise (oF)"]
[null,null,40000,80,{"$f":"((C27*859.8/3412)/(D27*3.785))/0.5555","v":59.92505971921107}]
[]
[]
[null,null,"Volume of Water for Given Energy Input"]
[]
[null,null,"Energy Input (kWh)","Temp Rise (oC)","Volume (Litres)"]
[null,null,13,70,{"$f":"(C33*859.8)/D33","v":159.67714285714285}]
[]
[null,null,"Energy Input (Btu)","Temp Rise (oF)","Volume (US G)"]
[null,null,40000,80,{"$f":"(C36/D36)/8.34","v":59.95203836930456}]
[]
[null,null,"Time to Heat Up"]
[null,null,"(Eg. Electrical Element, Boiler Output or Peak Solar Output)"]
[]
[null,null,"Energy Input (kW)","Tank Volume (L)"]
[null,null,3.6,300]
[null,null,"Starting Temp (oC)","Target Temp (oC)","Time to Heat (h)"]
[null,null,20,60,{"$f":"((D44-C44)*D42)/(C42*860)","v":3.8759689922480618}]
[]
[null,null,"Energy Input (kW)","Tank Volume (G)"]
[null,null,3.6,80]
[null,null,"Starting Temp (oF)","Target Temp (oF)","Time to Heat (h)"]
[null,null,60,140,{"$f":"((D49-C49)*D47*8.34)/(C47*3412)","v":4.3454474404064083}]
[]
[null,null,"Copyright © 2009  Apricus Solar Co., Ltd"]

{"sheet":"Tool Cold~Hot","index":5,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,6],[2,1,2,5],[4,1,4,5],[14,1,14,5],[26,1,26,5]]}
["Back to INDEX page"]
[]
[null,"Cold-Hot Water Ratio Calculator"]
[]
[null,"Target Temp Volume Know"]
[]
[null,"Target Temp Volume*",650]
[null,"Hot Water Temperature",60,"oC/oF"]
[null,"Cold Water Temperature",15,"oC/oF"]
[null,"Temperature Differential",{"$f":"C8-C9","v":45},"oC/oF"]
[null,"Target Water Temp",40,"oC/oF"]
[null,"Cold Water Volume",{"$f":"C7*(C8-C11)/C10","v":288.88888888888891},"m1=m*(t2-t)/(t2-t1)"]
[null,"Hot Water Volume",{"$f":"C7*(C11-C9)/C10","v":361.11111111111109},"m2=m*(t-t1)/(t2-t1)"]
[]
[null,"Hot Water Volume Know"]
[]
[null,"Hot Water Volume*",18376]
[null,"Hot Water Temperature",65,"oC/oF"]
[null,"Cold Water Temperature",12,"oC/oF"]
[null,"Temperature Differential",{"$f":"C18-C19","v":53},"oC/oF"]
[null,"Target Water Temp",60,"oC/oF"]
[null,"Target Temp Volume",{"$f":"C17/(((C21-C19)/C20))","v":20290.166666666668}]
[]
[]
[]
[]
[null,"Copyright © 2009, Apricus Solar Co., Ltd"]