{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Instructions","Above Ground Pipework","Buried Pipework","PI Calculator","Reference >>>","BS5422","Reference","Non PI Calculator","Storage Tanks","Results","HLC Guide"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":49,"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":"Instructions","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[14,1,14,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[24,8,24,9],[19,8,19,9],[15,1,15,9]]}
[]
[null,"RHI HEAT LOSS ASSESSMENT TOOL"]
[]
[null,"Version:",2.2000000000000002,"Released:","2015-12-01"]
[]
[null,"Please note that this spreadsheet should be saved as a 'Macro-enabled' workbook ('.xlsm')"]
[null,null,"[File > Save As > Excel Macro-Enabled Workbook]"]
[]
[]
[null,"1) Complete the 'Above Ground Pipework' tab to see if 'above ground' pipe lengths may be considered 'properly Insulated'."]
[null,"2) Complete the 'Buried Pipework' tab to see if buried pipe lengths may be considered 'properly insulated'."]
[null,"3) Complete the 'PI Calculator' for any pipe lengths that have been confirmed as 'properly insulated' and are greater than 10 metres in length."]
[]
[null,"4) Complete the 'Non PI Calculator' for any pipe lengths that may not be considered 'properly insulated'."]
[null,"5) Complete the 'Storage Tanks' calculator for any external tanks for which heat losses need to be accounted for."]
[null,"6) View the 'Results' tab to see what values should be entered on your RHI application form."]
[null,"For further assistance with completing the Heat Loss Assessment (HLA), please see the 'Heat Loss Assessment Guidance'."]
[null,"Please email a copy of the completed Heat Loss Assessment in Excel format to: ",null,null,null,null,null,"RHI.heatloss@ofgem.gov.uk"]

{"sheet":"Above Ground Pipework","index":1,"n_rows":172,"n_cols":30,"rows_kept":172,"cut":false,"hidden":false,"merged":[[103,0,103,4],[35,0,35,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[65,0,65,4],[66,0,66,1],[52,0,52,1],[53,0,53,1],[51,0,51,1],[50,0,50,1],[91,0,91,1],[60,0,60,1],[92,0,92,1],[93,2,93,4],[36,0,36,1],[19,0,19,4],[26,0,26,4],[29,0,29,4],[30,0,30,1],[31,0,31,1],[21,0,21,1],[22,0,23,1],[24,0,24,1],[24,2,24,4],[28,0,28,4],[3,0,3,4],[94,0,100,0],[47,0,47,4],[54,0,54,1],[55,0,55,1],[56,0,56,1],[57,0,57,1],[58,0,58,1],[59,0,59,1],[67,0,67,1],[64,0,64,1],[63,0,63,4],[64,2,64,4],[21,2,21,4],[22,2,23,4],[20,0,20,1],[71,0,71,4],[72,0,72,4],[73,0,74,1],[73,2,73,3],[74,2,74,4],[75,0,77,1],[75,2,75,3],[76,2,76,4],[77,2,77,4],[72,5,72,7],[82,5,82,6],[83,2,83,4],[84,0,89,1],[84,2,84,3],[88,5,88,6],[89,2,89,4],[78,0,83,1],[78,2,78,3],[78,5,78,6],[43,0,43,1],[48,0,48,2],[41,0,41,1],[68,0,68,1],[37,0,37,1],[38,0,38,1],[39,0,39,1],[40,0,40,1],[42,0,42,1]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Key:"]
[null,"Answer to be selected from a 'drop down' menu"]
[null,"Answer to be typed into box"]
[null,"Automatic calculation (PASS)"]
[null,"Automatic calculation (FAIL)"]
[]
[]
[]
[]
["STEP 1:",null,"Complete Question 1 for each individual length of external pipework located 'above ground'.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["STEP 2:",null,"Complete the table in Question 2 with details of all external pipe lengths located 'above ground' using the results from Question 1.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
["STEP 3:",null,"Each length of 'above ground' external pipework that may be considered 'properly insulated' in accordance with Question 1 and is > 10m in length must be added to the PI Calculator."]
[]
["STEP 4:",null,"Each length of 'above ground' external pipework that cannot be considered 'properly insulated' in accordance with Question 1 must be added to the Non PI Calculator."]
[]
["Question 1: 'Properly Insulated' Test for 'above ground' external pipework"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Metal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plastic"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Buried"]
["b",null,"If piping is 'buried' is it 'pre-insulated'?",null,"Pre-insulated' piping would be supplied by the manufacturer with the insulation already attached to the piping",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Above Ground"]
["a",null,"Pipe material:"]
["b",null,"Average temperature of fluid running through pipes (or hot face temperature of process pipework) (deg C):"]
["c",null,"Pipe diameter (mm), excluding any insulation:",null,"This is the diameter of the pipe carrying the liquid, not the outside diameter of the insulation.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"≤ 95ºC"]
["d",null,"Is the pipe diameter entered above the nominal or outside measurement?",null,"'nominal' = diameter on the inside of the pipe\n'outside' = diamater on the outside of the pipe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"96 - 120ºC"]
["e",null,"Use the manufacturer heat loss declaration instead of specifying insulation properties?",null,"This figure in W/m must be confirmed by the technical data sheet for your insulated pipework.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"121 - 150ºC"]
["f",null,"The heat loss rate for the pipework (W/m) defined in the manufacturer declaration:",null,"Must be in units of W/m length of pipe."]
["g",null,"Insulation thickness (mm):",null,"From the outside of the pipe carrying the liquid, to the edge of the insulated pipe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nominal"]
["h",null,"Thermal conductivity of the insulation (W/m per deg K):",null,"Must be in units of W/m K ['Watt per metre per Kelvin']",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Outside"]
["i",null,"What is the surface finish of the insulation?",null,"A polished, shiny or white surface has low emissivity; otherwise select high emissivity."]
["j",null,"Using the above evidence that you have provided the adjacent cell should provide you with an answer as to whether Ofgem will/ won't accept your insulation as being 'properly insulated'.",{"$f":"IF(AND(D38=\"\",D40=\"\"),\"\",IF(D37=\"Yes\",IF(D38=\"\",\"FAIL\",IF(D38<='BS5422'!AF35,\"PASS\",\"FAIL\")),IF(D40=\"\",\"FAIL\",IF(D39>='BS5422'!AF34,\"PASS\",\"FAIL\"))))","v":""},"                                                                                    ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High emissivity"]
["l",null,"Pictorial evidence of whether the piping is 'above ground' or 'buried'.                                                                        This should include if possible a photo of the piping in place (if installed prior to the RHI application), or being installed and or (if possible) a cross section of the pipe.","See notes at top of page for details on how to submit this information.","You may be requested to submit more evidence in the following questions; if using the 'email' option this should all be attached and sent in one email with the specific RHI ORG number in the subject line.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Low emissivity"]
["m",null,"A copy of the relevant page of the insulation manufacturer 's specification which details the insulation's thickness and associated conductivity.","See notes at top of page for details on how to submit this information.","You may be requested to submit more evidence in the following questions; if using the 'email' option this should all be attached and sent in one email with the specific RHI ORG number in the subject line."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5000000000000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.5000000000000003E-2]
["Question 2: Details of all 'above ground' external pipe lengths ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.4999999999999998E-2]
[null,null,null,1,2,3,4,5,6,7,8,9,10]
[null,null,"Description of pipe to enable it to be identified on schematic:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.05]
[null,null,"Pipe Length (m):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.5E-2]
["a",null,"Pipe material:"]
["b",null,"Average temperature of fluid running through the pipes (deg C):"]
["c",null,"Pipe diameter (mm), excluding any insulation:"]
["d",null,"Is the pipe diameter entered above the nominal or outside measurement?"]
["e",null,"Use the manufacturer heat loss declaration instead of specifying insulation properties?"]
["f",null,"The heat loss rate for the pipework (W/m) defined in the manufacturer declaration:"]
["g",null,"Insulation thickness (mm):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(i) No - All individual lengths of pipework <10m"]
["h",null,"Thermal conductivity of the insulation (W/m per deg K):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(ii) Yes - One or more individual lengths of pipework >10m"]
["i",null,"What is the surface finish of the insulation?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(ii) use a heat loss calculation    "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"√"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"√ Physical constraints "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"√ Reasons of safety                                                                                                                                                                                                                                   "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"√ Environmental conditions                                                           "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"√ Metering would provide less accurate results than a heat loss calculation.                                                                                              "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes - (i) Physical constraints "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes - (iii) Environmental conditions "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes - (iv) Metering would provide less accurate results than a heat loss calculation"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
["j",null,"Result of 'Properly Insulated' Test above?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
["k",null,"What should I do next?",{"$f":"IF(D92=\"\",\"\",IF(AND(D52>=10,D92=\"PASS\"),\"Add to PI Calculator\",IF(AND(D52<10,D92=\"PASS\"),\"Disregarded\",IF(D92=\"FAIL\",\"Add to Non PI Calculator\",\"\"))))","v":""},"","","","","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[]
[]
[]
[]
[null,null,null,"PASS"]
[null,null,null,"FAIL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,"High emissivity "]
[null,null,null,"Low emissivity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20+"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"≤ 95ºC (hot water)",null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"96 - 120ºC (hot water)",null,null,null,null,{"$f":"AD152+1","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"121 - 150ºC (hot water)",null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"100ºC (process pipework)",null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"200ºC (process pipework)",null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"300ºC (process pipework)",null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"400ºC (process pipework)",null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"500ºC (process pipework)",null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"600ºC (process pipework)",null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"700ºC (process pipework)",null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20+"]

{"sheet":"Buried Pipework","index":2,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[22,9,22,10],[27,9,27,10],[1,1,1,6],[19,9,19,10],[20,9,20,10],[21,9,21,10],[7,1,7,6],[5,1,5,6],[9,1,9,6],[6,0,6,13],[1,7,5,10]]}
[]
[null,"Question 1: 'Properly Insulated' Test for 'buried' external pipework"]
[]
[null,"External pipework located underground can be considered as being ‘properly insulated’ where it can be demonstrated that the pipework "]
[null,"has been insulated in accordance with BS EN 253 (2009), BS EN 15632:2 and 3 (2010) and BS EN 15632:4 (2009), or BS EN 15698:1 (2009).  "]
[null,"In line with the declaration you accept when submitting your application to us, the information you provide here must be accurate to the best of your knowledge and belief. You must be able to demonstrate that this is the pipework manufacturer and model that you have installed as part of your heating system and be able to provide evidence such as invoices, receipts or photos if requested by Ofgem [(you are reminded that participants on the scheme have an ongoing obligation to provide us, if requested, with evidence that the heat for which payments are made is used for an eligible purpose: this includes evidence relating to the calculation of heat loss from piping)]."]
[]
[null,"STEP 1: For each length of 'buried' external pipework please state the make and model of pipework and select which of the standards above (if any) are applicable."]
[null,"STEP 2: Each length of 'buried' external pipework that may be considered 'properly insulated' in accordance with one of these standards and is > 10m in length must be added to the PI Calculator."]
[null,"STEP 3: Each length of 'buried' external pipework that cannot be considered 'properly insulated' in accordance with one of these standards must be added to the Non PI Calculator."]
[]
[null,null,"Length (m)","Description of pipe to enable it to be identified on schematic:","Pipework make and model","Pipework insulated in accordance with:","What should I do next?",null,"BS EN 253 (2009)"]
[null,1,null,null,null,null,{"$f":"IF(OR(C13=\"\",F13=\"\"),\"\",IF(AND(C13>=10,OR(F13=\"BS EN 253 (2009)\",F13=\"BS EN 15632: 2 and 3 (2010) and BS EN 15632:4 (2009)\",F13=\"BS EN 15698: 1 (2009)\")),\"Add to PI Calculator\",IF(AND(C13<10,OR(F13=\"BS EN 253 (2009)\",F13=\"BS EN 15632: 2 and 3 (2010) and BS EN 15632:4 (2009)\",F13=\"BS EN 15698: 1 (2009)\")),\"Disregarded\",\"Add to Non PI Calculator\")))","v":""},null,"BS EN 15632: 2 and 3 (2010) and BS EN 15632:4 (2009)"]
[null,2,null,null,null,null,{"$f":"IF(OR(C14=\"\",F14=\"\"),\"\",IF(AND(C14>=10,OR(F14=\"BS EN 253 (2009)\",F14=\"BS EN 15632: 2 and 3 (2010) and BS EN 15632:4 (2009)\",F14=\"BS EN 15698: 1 (2009)\")),\"Add to PI Calculator\",IF(AND(C14<10,OR(F14=\"BS EN 253 (2009)\",F14=\"BS EN 15632: 2 and 3 (2010) and BS EN 15632:4 (2009)\",F14=\"BS EN 15698: 1 (2009)\")),\"Disregarded\",\"Add to Non PI Calculator\")))","v":""},null,"BS EN 15698: 1 (2009)"]
[null,3,null,null,null,null,"",null,"None of the above"]
[null,null,null,null,null,null,""]
[null,4,null,null,null,null,""]
[null,5,null,null,null,null,""]
[null,6,null,null,null,null,""]
[null,7,null,null,null,null,""]
[null,8,null,null,null,null,""]
[null,9,null,null,null,null,""]
[null,10,null,null,null,null,""]
[null,11,null,null,null,null,""]
[null,12,null,null,null,null,""]
[null,13,null,null,null,null,""]
[null,14,null,null,null,null,""]
[null,15,null,null,null,null,""]
[null,16,null,null,null,null,""]
[null,17,null,null,null,null,""]
[null,18,null,null,null,null,""]
[null,19,null,null,null,null,""]
[null,20,null,null,null,null,""]
[]
[]
[null,"Evidence that 'buried' pipework has been insulated in accordance with BS EN 253 (2009), BS EN 15632:2 and 3 (2010) and BS EN 15632:4 (2009), or BS EN 15698:1 (2009) will need to be provided to Ofgem."]
[null,"Possible methods of demonstrating this are as follows:"]
[]
[null,"1) Provide a test certificate confirming that your make and model of pipework has been insulated in accordance with one of the above standards."]
[null,"2) Provide a photo that shows a stamp on your pipework indicating insulation has been in accordance with one of the above standards (if accessible)."]
[null,"3) Other forms of evidence may be submitted which Ofgem will assess on a case-by-case basis."]

{"sheet":"PI Calculator","index":3,"n_rows":178,"n_cols":5,"rows_kept":178,"cut":false,"hidden":false,"merged":[[25,2,25,3],[20,2,20,3],[15,2,15,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3]]}
[]
[null,"Before filling in this sheet, please read the"]
[null,"HLC Guide"]
[]
[null,"Renewable Heat Incentive"]
[null,"Calculation of Heat Losses from 'Properly Insulated' pipes > 10m in length."]
[]
[null,null,null,null,"Belfast"]
[null,null,null,null,"Birmingham"]
[null,null,null,null,"Cardiff"]
[null,"Location",null,null,"Edinburgh"]
[null,null,null,null,"Glasgow"]
[null,null,null,null,"Leeds"]
[null,null,null,null,"London"]
[null,"User Defined Insulation 1",null,null,"Manchester"]
[null,"Name:",null,null,"Newcastle"]
[null,"Conductivity (Flow):",null,"W/mK","Nottingham"]
[null,"Conductivity (Return):",null,"W/mK","Plymouth"]
[null,null,null,null,"Southampton"]
[null,"User Defined Insulation 2",null,null,"Manchester"]
[null,"Name:",null,null,"Newcastle"]
[null,"Conductivity (Flow):",null,"W/mK","Nottingham"]
[null,"Conductivity (Return):",null,"W/mK","Plymouth"]
[null,null,null,null,"Southampton"]
[null,"User Defined Insulation 3"]
[null,"Name:"]
[null,"Conductivity (Flow):",null,"W/mK"]
[null,"Conductivity (Return):",null,"W/mK"]
[]
[null,"Use these buttons to add"]
[null,"and delete a column for each","column count start with col E",{"$f":"COUNTA(E89:E89)","v":1}]
[null,"external pipe run."]
[null,"Projected Annual Generation","kWh"]
[]
[null,"Distribution System Details"]
[null,"Pipe Sections","Units","Total"]
[null,"Section Name","-","-","Example"]
[null,"Flow or Return?","-","-","Flow"]
[null,"Length","m",{"$f":"SUMIF(OFFSET(E39,0,1,1,$D$31),\"<>#n/a\",OFFSET(E39,0,1,1,$D$31))","v":0},1000]
[null,"Is the pipe length pre-insulated or buried?\n(If yes please complete Row 54 below) ","-","-","No"]
[null,"Not Pre-insulated"]
[null,"Nominal Diameter","mm","-",90]
[null,"  Outside Diameter","mm","-","-"]
[null,"Insulation Type (select only for temperatures < 95oC)","-","-","Glass Fibre"]
[null,"Insulation Thickness","mm","-",25]
[null,"  User defined insulation thickness","mm","-","-"]
[null,"Surface Emissivity","-","-","High"]
[null,"External Condition","-","-","Sheltered"]
[null,"  No. Valves","-",{"$f":"SUMIF(OFFSET(E49,0,1,1,$D$31),\"<>#n/a\",OFFSET(E49,0,1,1,$D$31))","v":0},1]
[null,"  Valves Insulated?","-","-","No"]
[null,"  No. Flanges","-",{"$f":"SUMIF(OFFSET(E51,0,1,1,$D$31),\"<>#n/a\",OFFSET(E51,0,1,1,$D$31))","v":0},1]
[null,"  Flanges Insulated?","-","-","No"]
[null,"Pre-insulated or buried"]
[null,"Heat Loss Rate for total cross-section of pipe","W/mK","-","-"]
[null,"Based on ground or air temperature?",null,null,"-"]
[null,null,null,null,true]
[null,"Fluid Temperature",null,"Outside Dia:",{"$f":"IF(E42<>\"User Defined o.d.\",VLOOKUP(E42,Reference!$B$4:$C$22,2,FALSE),'PI Calculator'!E43)","v":101.6}]
[null,"Month","Units","Total"]
[null,"January","ºC","-",80]
[null,"February","ºC","-",80]
[null,"March","ºC","-",80]
[null,"April","ºC","-",80]
[null,"May","ºC","-",80]
[null,"June","ºC","-",80]
[null,"July","ºC","-",80]
[null,"August","ºC","-",80]
[null,"September","ºC","-",80]
[null,"October","ºC","-",80]
[null,"November","ºC","-",80]
[null,"December","ºC","-",80]
[]
[null,"Operating Hours"]
[null,"Month","Units","Total"]
[null,"January","hrs","-",600]
[null,"February","hrs","-",550]
[null,"March","hrs","-",500]
[null,"April","hrs","-",450]
[null,"May","hrs","-",400]
[null,"June","hrs","-",350]
[null,"July","hrs","-",350]
[null,"August","hrs","-",400]
[null,"September","hrs","-",450]
[null,"October","hrs","-",500]
[null,"November","hrs","-",550]
[null,"December","hrs","-",600]
[]
[null,"Heat Loss Rates (W/K)"]
[null,"Pipe Sections","Units","Total"]
[null,"Pipe","W/K",{"$f":"SUMIF(OFFSET(E89,0,1,1,$D$31),\"<>#n/a\",OFFSET(E89,0,1,1,$D$31))","v":0},{"$f":"IF(E$40=\"Yes\",E$54*E$39,E39*PI()*(E57/1000)*(1/(((E57/1000)/(2*OFFSET(Reference!$B$25,MATCH(E44,Reference!$B$26:$B$31,0),MATCH(E38,Reference!$C$25:$D$25,0)))*LN((E57+(2*IF(E45=\"User Defined\",E46,E45) ))/E57))+(E57/(VLOOKUP(E48,Reference!$B$36:$E$37,IF(E47=\"High\",2,IF(E47=\"Low\",4,3)),FALSE)*(E57+(2*IF(E45=\"User Defined\",E46,E45))))))))","v":554.84047088740488}]
[null,"Valves","W/K",{"$f":"SUMIF(OFFSET(E90,0,1,1,$D$31),\"<>#n/a\",OFFSET(E90,0,1,1,$D$31))","v":0},{"$f":"IF(E40=\"No\",IF(E49>0,E49*IF(E50=\"Yes\",0,5*(E57/1000)*PI()*(E57/1000)*VLOOKUP(E48,Reference!$B$36:$E$37,IF(E47=\"High\",2,IF(E47=\"Low\",4,3)),FALSE)),0),0)","v":1.6214639331119927}]
[null,"Flanges","W/K",{"$f":"SUMIF(OFFSET(E91,0,1,1,$D$31),\"<>#n/a\",OFFSET(E91,0,1,1,$D$31))","v":0},{"$f":"IF(E40=\"No\",IF(E51>0,E51*IF(E52=\"Yes\",0,1.5*(E57/1000)*PI()*(E57/1000)*VLOOKUP(E48,Reference!$B$36:$E$37,IF(E47=\"High\",2,IF(E47=\"Low\",4,3)),FALSE)),0),0)","v":0.4864391799335977}]
[]
[null,"Monthly Heat Losses"]
[null,"Month","Units","Total"]
[null,"January","kWh",{"$f":"SUMIF(OFFSET(E95,0,1,1,$D$31),\"<>#n/a\",OFFSET(E95,0,1,1,$D$31))","v":0},{"$f":"IF(E$55=\"Ground\",SUM(E$89:E$91)*(E59-Reference!$D$63)*E74*0.001,SUM(E$89:E$91)*(E59-Reference!$D$46)*E74*0.001)","v":{"$error":"#N/A"}}]
[null,"February","kWh",0,{"$f":"IF(E$55=\"Ground\",SUM(E$89:E$91)*(E60-Reference!$E$63)*E75*0.001,SUM(E$89:E$91)*(E60-Reference!$E$46)*E75*0.001)","v":{"$error":"#N/A"}}]
[null,"March","kWh",0,{"$f":"IF(E$55=\"Ground\",SUM(E$89:E$91)*(E61-Reference!$F$63)*E76*0.001,SUM(E$89:E$91)*(E61-Reference!$F$46)*E76*0.001)","v":{"$error":"#N/A"}}]
[null,"April","kWh",0,{"$f":"IF(E$55=\"Ground\",SUM(E$89:E$91)*(E62-Reference!$G$63)*E77*0.001,SUM(E$89:E$91)*(E62-Reference!$G$46)*E77*0.001)","v":{"$error":"#N/A"}}]
[null,"May","kWh",0,{"$f":"IF(E$55=\"Ground\",SUM(E$89:E$91)*(E63-Reference!$H$63)*E78*0.001,SUM(E$89:E$91)*(E63-Reference!$H$46)*E78*0.001)","v":{"$error":"#N/A"}}]
[null,"June","kWh",0,{"$f":"IF(E$55=\"Ground\",SUM(E$89:E$91)*(E64-Reference!$I$63)*E79*0.001,SUM(E$89:E$91)*(E64-Reference!$I$46)*E79*0.001)","v":{"$error":"#N/A"}}]
[null,"July","kWh",0,{"$f":"IF(E$55=\"Ground\",SUM(E$89:E$91)*(E65-Reference!$J$63)*E80*0.001,SUM(E$89:E$91)*(E65-Reference!$J$46)*E80*0.001)","v":{"$error":"#N/A"}}]
[null,"August","kWh",0,{"$f":"IF(E$55=\"Ground\",SUM(E$89:E$91)*(E66-Reference!$K$63)*E81*0.001,SUM(E$89:E$91)*(E66-Reference!$K$46)*E81*0.001)","v":{"$error":"#N/A"}}]
[null,"September","kWh",0,{"$f":"IF(E$55=\"Ground\",SUM(E$89:E$91)*(E67-Reference!$L$63)*E82*0.001,SUM(E$89:E$91)*(E67-Reference!$L$46)*E82*0.001)","v":{"$error":"#N/A"}}]
[null,"October","kWh",0,{"$f":"IF(E$55=\"Ground\",SUM(E$89:E$91)*(E68-Reference!$M$63)*E83*0.001,SUM(E$89:E$91)*(E68-Reference!$M$46)*E83*0.001)","v":{"$error":"#N/A"}}]
[null,"November","kWh",0,{"$f":"IF(E$55=\"Ground\",SUM(E$89:E$91)*(E69-Reference!$N$63)*E84*0.001,SUM(E$89:E$91)*(E69-Reference!$N$46)*E84*0.001)","v":{"$error":"#N/A"}}]
[null,"December","kWh",0,{"$f":"IF(E$55=\"Ground\",SUM(E$89:E$91)*(E70-Reference!$O$63)*E85*0.001,SUM(E$89:E$91)*(E70-Reference!$O$46)*E85*0.001)","v":{"$error":"#N/A"}}]
[]
[null,"Quaterly Heat Losses"]
[null,"Period","Units","Total"]
[null,"January - March","kWh",{"$f":"SUM(D95:D97)","v":0}]
[null,"April - June","kWh",{"$f":"SUM(D98:D100)","v":0}]
[null,"July - September","KWh",{"$f":"SUM(D101:D103)","v":0}]
[null,"October - December","kWh",{"$f":"SUM(D104:D106)","v":0}]
[]
[null,"Annual Heat Loss","kWh",{"$f":"SUM(D95:D106)","v":0}]
[]
[]
[]
[]
[null,"Flow"]
[null,"Return"]
[null,"DUO"]
[null,"Exposed"]
[null,"Buried"]
[]
[null,"Yes"]
[null,"No"]
[]
[null,{"$f":"Reference!B26","v":"Glass Fibre"}]
[null,{"$f":"Reference!B27","v":"Mineral Wool"}]
[null,{"$f":"Reference!B28","v":"85% Magnesia"}]
[null,{"$f":"Reference!B29","v":"Calcium Silicate"}]
[null,{"$f":"Reference!B30","v":""}]
[null,{"$f":"Reference!B31","v":""}]
[null,{"$f":"Reference!B32","v":""}]
[]
[null,{"$f":"Reference!B36","v":"Sheltered"}]
[null,{"$f":"Reference!B37","v":"Exposed"}]
[]
[null,"High"]
[null,"Medium"]
[null,"Low"]
[]
[null,"User Defined"]
[null,12.5]
[null,19]
[null,25]
[null,38]
[null,50]
[null,75]
[null,100]
[]
[null,"User Defined o.d."]
[null,{"$f":"Reference!B4","v":8}]
[null,{"$f":"Reference!B5","v":10}]
[null,{"$f":"Reference!B6","v":15}]
[null,{"$f":"Reference!B7","v":20}]
[null,{"$f":"Reference!B8","v":25}]
[null,{"$f":"Reference!B9","v":32}]
[null,{"$f":"Reference!B10","v":40}]
[null,{"$f":"Reference!B11","v":50}]
[null,{"$f":"Reference!B12","v":65}]
[null,{"$f":"Reference!B13","v":80}]
[null,{"$f":"Reference!B14","v":90}]
[null,{"$f":"Reference!B15","v":100}]
[null,{"$f":"Reference!B16","v":125}]
[null,{"$f":"Reference!B17","v":150}]
[null,{"$f":"Reference!B18","v":175}]
[null,{"$f":"Reference!B19","v":200}]
[null,{"$f":"Reference!B20","v":222.5}]
[null,{"$f":"Reference!B21","v":250}]
[null,{"$f":"Reference!B22","v":300}]
[]
[null,"Ground"]
[null,"Air"]
[]
[]
[null,"Delete"]

{"sheet":"Reference >>>","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"BS5422","index":5,"n_rows":81,"n_cols":143,"rows_kept":81,"cut":false,"hidden":true,"merged":[[65,22,66,22],[64,1,66,1],[64,2,66,2],[65,3,65,21],[2,1,5,1],[2,2,5,2],[2,3,2,26],[3,3,3,10],[3,11,3,18],[3,19,3,26],[4,3,4,10],[4,11,4,18],[4,19,4,26],[6,1,6,2],[6,3,6,9],[6,11,6,17],[6,19,6,25],[24,1,27,1],[24,2,27,2],[24,3,24,26],[25,3,25,10],[25,11,25,18],[25,19,25,26],[26,3,26,10],[26,11,26,18],[26,19,26,26],[46,19,46,25],[46,26,47,26],[28,1,28,2],[28,3,28,9],[28,11,28,17],[28,19,28,25],[46,3,46,9],[46,10,47,10],[45,1,47,1],[45,2,47,2],[45,11,45,18],[46,18,47,18],[45,3,45,10],[46,11,46,17],[65,23,65,41],[64,23,64,42],[64,3,64,22],[45,51,45,58],[46,51,46,57],[46,58,47,58],[45,43,45,50],[46,43,46,49],[46,50,47,50],[45,35,45,42],[46,35,46,41],[46,42,47,42],[45,27,45,34],[46,27,46,33],[46,34,47,34],[45,19,45,26],[65,43,65,61],[65,63,65,81],[64,63,64,82],[64,43,64,62],[65,42,66,42],[65,62,66,62],[64,123,64,142],[64,103,64,122],[64,83,64,102],[65,82,66,82],[65,102,66,102],[65,142,66,142],[65,123,65,141],[65,122,66,122],[65,83,65,101],[65,103,65,121]]}
[]
[null,"Table 15: Indicative thickness of insulation for non-domestic heating services to control heat loss - Low emissivity outer surfaces",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop down menu items"]
[null,"Nominal diameter","Outside diameter","Low emissivity surface finish (ε = 0.05)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Metal","Buried","≤ 95ºC (hot water)","Nominal","High emissivity",2.5000000000000001E-2]
[null,null,null,"Low temperature heating services (< 95ºC)",null,null,null,null,null,null,null,"Medium temperature heating services (96 - 120ºC)",null,null,null,null,null,null,null,"High temperature heating services (121 - 150ºC)",null,null,null,null,null,null,null,null,null,"Plastic","Above Ground","96 - 120ºC (hot water)","Outside","Low emissivity",0.03]
[null,null,null,"t = 75",null,null,null,null,null,null,null,"t = 100",null,null,null,null,null,null,null,"t = 125",null,null,null,null,null,null,null,null,null,null,null,"121 - 150ºC (hot water)",null,null,3.5000000000000003E-2]
[null,null,null,"λ = 0.025","λ = 0.03","λ = 0.035","λ = 0.04","λ = 0.045","λ = 0.05","λ = 0.055","Max heat loss","λ = 0.025","λ = 0.03","λ = 0.035","λ = 0.04","λ = 0.045","λ = 0.05","λ = 0.055","Max heat loss","λ = 0.025","λ = 0.03","λ = 0.035","λ = 0.04","λ = 0.045","λ = 0.05","λ = 0.055","Max heat loss",null,null,null,null,"100ºC (process pipework)",null,null,0.04]
[null,"(mm)",null,"Thickness of insulation (mm)",null,null,null,null,null,null,"(W/m)","Thickness of insulation (mm)",null,null,null,null,null,null,"(W/m)","Thickness of insulation (mm)",null,null,null,null,null,null,"(W/m)",null,null,null,null,"200ºC (process pipework)",null,null,4.4999999999999998E-2]
[null,10,17.2,12,17,22,30,39,51,66,8.9,11,15,20,26,34,44,56,13.34,10,13,18,24,31,39,50,17.920000000000002,null,null,null,null,"300ºC (process pipework)",null,null,0.05]
[null,15,21.3,14,20,26,35,46,59,75,9.2799999999999994,14,18,25,32,42,54,69,13.56,12,17,22,29,38,48,61,18.32,null,null,null,null,"400ºC (process pipework)",null,null,5.5E-2]
[null,20,26.9,16,22,29,38,49,62,78,10.06,17,24,31,41,53,67,82,13.83,16,22,28,37,47,60,76,18.7,null,null,null,null,"500ºC (process pipework)",null,null,0.06]
[null,25,33.700000000000003,18,24,31,40,51,64,79,11.07,21,28,37,48,62,78,98,14.39,20,27,36,46,59,74,93,19.02,null,null,null,null,"600ºC (process pipework)",null,null,6.5000000000000002E-2]
[null,32,42.4,20,26,33,42,52,65,79,12.3,24,32,41,52,66,83,103,15.66,26,35,45,59,71,93,117,19.25,null,null,null,null,"700ºC (process pipework)",null,null,7.0000000000000007E-2]
[null,40,48.3,21,27,35,44,55,67,82,12.94,25,33,42,53,67,83,102,16.670000000000002,28,37,48,61,77,97,120,20.170000000000002,null,null,null,null,null,null,null,7.4999999999999997E-2]
[null,50,60.3,23,29,37,46,56,68,82,14.45,27,36,46,57,71,87,106,18.25,31,41,52,66,83,102,125,21.96,null,null,null,null,null,null,null,0.08]
[null,65,76.099999999999994,24,31,39,48,58,70,83,16.350000000000001,30,39,49,60,74,89,107,20.420000000000002,34,45,57,71,88,107,129,24.21,null,null,null,null,null,null,null,8.5000000000000006E-2]
[null,80,88.9,25,32,40,49,59,70,82,17.91,31,40,51,62,76,91,108,22.09,36,47,60,74,91,110,132,25.99,null,null,null,null,null,null,null,0.09]
[null,100,114.3,27,34,42,51,61,71,83,20.77,34,43,54,65,79,93,110,25.31,40,51,64,79,96,115,136,29.32,null,null,null,null,null,null,null,9.5000000000000001E-2]
[null,125,139.69999999999999,28,35,43,52,61,71,82,23.71,36,46,57,68,82,96,112,28.23,43,55,68,83,100,118,139,32.47,null,null,null,null,null,null,null,0.1,null,{"$f":"IFERROR(MATCH(AF25,Temps,0),\"NO\")","v":"NO"},"Column offset to move to different temperatures in table"]
[null,150,168.3,29,37,44,53,62,72,82,26.89,38,48,59,70,83,98,113,31.61,46,58,71,86,103,121,141,36.04,null,null,null,null,null,null,null,0.105,null,{"$f":"IFERROR(MATCH(AF25,ProcessTemps,0),\"NO\")","v":"NO"},"Column offset to move to different temperatures in table for process temp"]
[null,200,219.1,30,38,45,54,62,72,82,32.54,40,50,61,72,85,98,113,37.659999999999997,49,62,75,90,106,124,144,42.16,null,null,null,null,null,null,null,0.11,null,{"$f":"MIN(AK18,AK19)","v":0},"shown figures"]
[null,250,273,31,38,46,54,62,71,80,38.83,42,52,63,74,87,100,114,43.72,52,64,78,93,109,127,145,48.48,null,null,null,null,null,null,null,0.115]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculation",null,"Input","Notes"]
[null,"Table 16: Indicative thickness of insulation for non-domestic heating services to control heat loss - High emissivity outer surfaces",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pipework material",null,{"$f":"'Above Ground Pipework'!D33","v":0}]
[null,"Nominal diameter","Outside diameter","High emissivity surface finish (ε = 0.90)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fluid temperature",null,{"$f":"'Above Ground Pipework'!D34","v":0},{"$f":"AK20","v":0},"Column offset to move to different temperatures in table"]
[null,null,null,"Low temperature heating services (< 95ºC)",null,null,null,null,null,null,null,"Medium temperature heating services (96 - 120ºC)",null,null,null,null,null,null,null,"High temperature heating services (121 - 150ºC)",null,null,null,null,null,null,null,null,null,"Measurement type",null,{"$f":"'Above Ground Pipework'!D36","v":0}]
[null,null,null,"t = 75",null,null,null,null,null,null,null,"t = 100",null,null,null,null,null,null,null,"t = 125",null,null,null,null,null,null,null,null,null,"Pipe diameter",null,{"$f":"'Above Ground Pipework'!D35","v":0},{"$f":"IF(AF26=\"Nominal\",IF(AF27<=MAX(B8:B21),IF(AF27<MIN(B8:B21),1,MATCH(AF27,$B$8:$B$21,1)),14),IF(AF27<=MAX(C8:C21),IF(AF27<MIN(C8:C21),1,MATCH(AF27,$C$8:$C$21,1)),14))+1","v":2},{"$f":"IF(AF26=\"Nominal\",OFFSET(B8,AG27-2,0),OFFSET(C8,AG27-2,0))","v":17.2},{"$f":"IF(AF26=\"Nominal\",IF(AF27<=MAX(B8:B21),OFFSET(B8,AG27-1,0),B21),IF(AF27<=MAX(C8:C21),OFFSET(C8,AG27-1,0),C21))","v":21.3},{"$f":"IF(AH27<>AI27,IF(AF27<=AH27,0,1),0)","v":0},"These are the calculated diameters and the proportion for interpolation, note: that intermediate values are always rounded up"]
[null,null,null,"λ = 0.025","λ = 0.03","λ = 0.035","λ = 0.04","λ = 0.045","λ = 0.05","λ = 0.055","Max heat loss","λ = 0.025","λ = 0.03","λ = 0.035","λ = 0.04","λ = 0.045","λ = 0.05","λ = 0.055","Max heat loss","λ = 0.025","λ = 0.03","λ = 0.035","λ = 0.04","λ = 0.045","λ = 0.05","λ = 0.055","Max heat loss",null,null,"Above ground?",null,{"$f":"'Above Ground Pipework'!D31","v":0}]
[null,"(mm)",null,"Thickness of insulation (mm)",null,null,null,null,null,null,"(W/m)","Thickness of insulation (mm)",null,null,null,null,null,null,"(W/m)","Thickness of insulation (mm)",null,null,null,null,null,null,"(W/m)",null,null,"Thermal conductivity",null,{"$f":"'Above Ground Pipework'!D40","v":0},{"$f":"IF(OR(AF25=\"≤ 95ºC (hot water)\",AF25=\"96 - 120ºC (hot water)\",AF25=\"121 - 150ºC (hot water)\"),IF(AF29<AI3,1,IF(AF29>AI9,7,MATCH(AF29,AI3:AI9,1))),IF(AF29<AI3,1,IF(AF29>AI21,19,MATCH(AF29,AI3:AI21,1))))","v":1},{"$f":"IF(OR(AF25=\"≤ 95ºC (hot water)\",AF25=\"96 - 120ºC (hot water)\",AF25=\"121 - 150ºC (hot water)\"),IF(AF29<AI3,1,MIN(AG29+1,7)),IF(AF29<AI3,1,MIN(AG29+1,19)))","v":1},{"$f":"IF(OR(AF25=\"≤ 95ºC (hot water)\",AF25=\"96 - 120ºC (hot water)\",AF25=\"121 - 150ºC (hot water)\"),OFFSET(D6,0,AG29-1),OFFSET(D6,61,AG29-1))","v":"λ = 0.025"},{"$f":"IF(OR(AF25=\"≤ 95ºC (hot water)\",AF25=\"96 - 120ºC (hot water)\",AF25=\"121 - 150ºC (hot water)\"),OFFSET(D6,0,AH29-1),OFFSET(D6,61,AH29-1))","v":"λ = 0.025"},{"$f":"IFERROR(IF(AND(AF29>=0.025,AF29<=0.115),(AF29-OFFSET($AI$2,$AG$29,0))/(OFFSET($AI$2,$AH$29,0)-OFFSET($AI$2,$AG$29,0)),0),0)","v":0},"These are the calculated conductivities and the proportion for interpolation"]
[null,10,17.2,14,19,25,34,44,57,72,8.9,13,17,23,30,38,49,62,13.34,12,16,21,28,35,45,57,17.920000000000002,null,null,"Surface finish",null,{"$f":"'Above Ground Pipework'!D41","v":0},{"$f":"IF(AF30=AH3,22,IF(AF30=AH4,0,IF(OR(AF25=\"≤ 95ºC (hot water)\",AF25=\"96 - 120ºC (hot water)\",AF25=\"121 - 150ºC (hot water)\"),0,60)))","v":60},"Row offset to move to second table or fourth one"]
[null,15,21.3,16,22,30,39,50,64,81,9.2799999999999994,16,21,28,36,47,60,75,13.56,15,20,26,33,42,54,67,18.32]
[null,20,26.9,18,25,33,42,54,68,85,10.06,20,26,35,45,58,73,92,13.83,18,24,32,41,52,66,82,18.7,null,null,"Reqd. thickness (Low Con.)",null,{"$f":"IFERROR(AG32+((AH32-AG32)*AJ27),0)","v":0},{"$f":"IFERROR(IF(OR(AF25=\"≤ 95ºC (hot water)\",AF25=\"96 - 120ºC (hot water)\",AF25=\"121 - 150ºC (hot water)\"),OFFSET(C8,AG30+(AG27-2),(AG29+((AG25-1)*8))),IF(OFFSET(C8,AG30+(AG27-2),(AG29+((AG25-1)*20)))<>\"\",OFFSET(C8,AG30+(AG27-2),(AG29+((AG25-1)*20))),10000)),0)","v":0},{"$f":"IFERROR(IF(OR(AF25=\"≤ 95ºC (hot water)\",AF25=\"96 - 120ºC (hot water)\",AF25=\"121 - 150ºC (hot water)\"),OFFSET(C8,AG30+(AG27-1),(AG29+((AG25-1)*8))),IF(OFFSET(C8,AG30+(AG27-1),(AG29+((AG25-1)*20)))<>\"\",OFFSET(C8,AG30+(AG27-1),(AG29+((AG25-1)*20))),10000)),0)","v":0},{"$f":"IFERROR(IF(OR(AF25=\"≤ 95ºC (hot water)\",AF25=\"96 - 120ºC (hot water)\",AF25=\"121 - 150ºC (hot water)\"),ADDRESS(ROW(OFFSET(C8,AG30+(AG27-2),(AG29+((AG25-1)*8)))),COLUMN(OFFSET(C8,AG30+(AG27-2),(AG29+((AG25-1)*8))))),ADDRESS(ROW(OFFSET(C8,AG30+(AG27-2),(AG29+((AG25-1)*20)))),COLUMN(OFFSET(C8,AG30+(AG27-2),(AG29+((AG25-1)*20)))))),0)","v":0},{"$f":"IFERROR(IF(OR(AF25=\"≤ 95ºC (hot water)\",AF25=\"96 - 120ºC (hot water)\",AF25=\"121 - 150ºC (hot water)\"),ADDRESS(ROW(OFFSET(C8,AG30+(AG27-1),(AG29+((AG25-1)*8)))),COLUMN(OFFSET(C8,AG30+(AG27-1),(AG29+((AG25-1)*8))))),ADDRESS(ROW(OFFSET(C8,AG30+(AG27-1),(AG29+((AG25-1)*20)))),COLUMN(OFFSET(C8,AG30+(AG27-1),(AG29+((AG25-1)*20)))))),0)","v":0},"This is the cell reference of the calculated required thickness"]
[null,25,33.700000000000003,20,2,35,44,56,69,85,11.07,23,31,41,53,67,84,106,14.39,23,30,39,51,64,81,100,19.02,null,null,"Reqd. thickness (High Con.)",null,{"$f":"IFERROR(AG33+((AH33-AG33)*AJ27),0)","v":0},{"$f":"IFERROR(IF(OR(AF25=\"≤ 95ºC (hot water)\",AF25=\"96 - 120ºC (hot water)\",AF25=\"121 - 150ºC (hot water)\"),OFFSET(C8,AG30+(AG27-2),(AH29+((AG25-1)*8))),IF(OFFSET(C8,AG30+(AG27-2),(AH29+((AG25-1)*20)))<>\"\",OFFSET(C8,AG30+(AG27-2),(AH29+((AG25-1)*20))),10000)),0)","v":0},{"$f":"IFERROR(IF(OR(AF25=\"≤ 95ºC (hot water)\",AF25=\"96 - 120ºC (hot water)\",AF25=\"121 - 150ºC (hot water)\"),OFFSET(C8,AG30+(AG27-1),(AH29+((AG25-1)*8))),IF(OFFSET(C8,AG30+(AG27-1),(AH29+((AG25-1)*20)))<>\"\",OFFSET(C8,AG30+(AG27-1),(AH29+((AG25-1)*20))),10000)),0)","v":0},{"$f":"IFERROR(IF(OR(AF25=\"≤ 95ºC (hot water)\",AF25=\"96 - 120ºC (hot water)\",AF25=\"121 - 150ºC (hot water)\"),ADDRESS(ROW(OFFSET(C8,AG30+(AG27-2),(AH29+((AG25-1)*8)))),COLUMN(OFFSET(C8,AG30+(AG27-2),(AH29+((AG25-1)*8))))),ADDRESS(ROW(OFFSET(C8,AG30+(AG27-2),(AH29+((AG25-1)*20)))),COLUMN(OFFSET(C8,AG30+(AG27-2),(AH29+((AG25-1)*20)))))),0)","v":0},{"$f":"IFERROR(IF(OR(AF25=\"≤ 95ºC (hot water)\",AF25=\"96 - 120ºC (hot water)\",AF25=\"121 - 150ºC (hot water)\"),ADDRESS(ROW(OFFSET(C8,AG30+(AG27-1),(AH29+((AG25-1)*8)))),COLUMN(OFFSET(C8,AG30+(AG27-1),(AH29+((AG25-1)*8))))),ADDRESS(ROW(OFFSET(C8,AG30+(AG27-1),(AH29+((AG25-1)*20)))),COLUMN(OFFSET(C8,AG30+(AG27-1),(AH29+((AG25-1)*20)))))),0)","v":0},"This is the cell reference of the calculated required thickness"]
[null,32,42.4,22,29,37,46,57,70,86,12.3,26,35,45,57,72,89,110,15.66,28,38,49,63,80,100,124,19.25,null,null,"Reqd. thickness (Interpolated)",null,{"$f":"IF(OR(AF25=\"≤ 95ºC (hot water)\",AF25=\"96 - 120ºC (hot water)\",AF25=\"121 - 150ºC (hot water)\"),IF(AF29<0.055,IF(AF28=\"Above Ground\",1,1)*(AF32+((AF33-AF32)*AK29)),10000),IF(AND(AG29<20,AF32<>10000,AF29<=AI21),IF(AF28=\"Above Ground\",1,1)*(AF32+((AF33-AF32)*AK29)),10000))","v":0}]
[null,40,48.3,23,30,39,48,60,73,88,12.94,27,36,46,58,72,89,109,16.670000000000002,30,40,52,66,83,103,127,20.170000000000002,null,null,"Max heat loss",null,{"$f":"(AG35+((AH35-AG35)*AJ27))","v":17.2},{"$f":"AI39","v":17.2},{"$f":"AJ39","v":21.3},"These are the maximum heat losses"]
[null,50,60.3,25,32,41,51,62,74,89,14.45,30,39,50,62,77,94,113,18.25,24,44,57,71,88,109,133,21.96]
[null,65,76.099999999999994,27,35,43,53,64,76,90,16.350000000000001,32,42,53,65,80,96,115,20.420000000000002,27,48,61,75,94,114,137,24.21,null,null,null,null,null,null,null,{"$f":"IF(OR(AF25=\"≤ 95ºC (hot water)\",AF25=\"96 - 120ºC (hot water)\",AF25=\"121 - 150ºC (hot water)\"),OFFSET(C8,AG30+(AG27-2),AG25*8),0)","v":0},{"$f":"IF(OR(AF25=\"≤ 95ºC (hot water)\",AF25=\"96 - 120ºC (hot water)\",AF25=\"121 - 150ºC (hot water)\"),OFFSET(C8,AG30+(AG27-1),AG25*8),0)","v":0},"max heat loss water"]
[null,80,88.9,28,36,44,54,64,76,90,17.91,34,44,55,68,82,98,116,22.09,29,51,65,79,97,117,140,25.99,null,null,null,null,null,null,null,{"$f":"IF(OR(AF25=\"≤ 95ºC (hot water)\",AF25=\"96 - 120ºC (hot water)\",AF25=\"121 - 150ºC (hot water)\"),0,OFFSET(C8,AG30+(AG27-2),AG25*20))","v":17.2},{"$f":"IF(OR(AF25=\"≤ 95ºC (hot water)\",AF25=\"96 - 120ºC (hot water)\",AF25=\"121 - 150ºC (hot water)\"),0,OFFSET(C8,AG30+(AG27-1),AG25*20))","v":21.3},"max heat loss steam or liquid"]
[null,100,114.3,30,38,47,56,66,78,91,20.77,37,47,58,71,85,100,118,25.31,43,55,69,85,102,122,144,29.32,null,null,null,null,null,null,null,{"$f":"MAX(AI37:AI38)","v":17.2},{"$f":"MAX(AJ37:AJ38)","v":21.3},"shown figures"]
[null,125,139.69999999999999,31,39,48,57,67,78,90,23.71,39,50,61,74,88,103,120,28.23,46,59,73,89,106,126,148,32.47]
[null,150,168.3,33,40,49,58,68,79,90,26.89,41,52,64,76,90,105,122,31.61,49,62,76,92,109,129,150,36.04]
[null,200,219.1,34,42,50,60,69,79,90,32.54,44,55,66,79,92,106,122,37.659999999999997,53,66,81,96,114,132,153,42.16]
[null,250,273,35,43,51,60,69,79,89,38.83,46,57,68,81,94,108,123,43.72,56,69,84,100,117,135,155,48.48]
[]
[null,"Table 21: Minimum insulation thickness for process pipework and equipment to control heat loss"]
[null,"Nominal diameter (mm)","Outside diameter (mm)","t = 100",null,null,null,null,null,null,null,"t = 200",null,null,null,null,null,null,null,"t = 300",null,null,null,null,null,null,null,"t = 400",null,null,null,null,null,null,null,"t = 500",null,null,null,null,null,null,null,"t = 600",null,null,null,null,null,null,null,"t = 700"]
[null,null,null,"insulation thickness (mm)",null,null,null,null,null,null,"Max heat loss (W/m)","insulation thickness (mm)",null,null,null,null,null,null,"Max heat loss (W/m)","insulation thickness (mm)",null,null,null,null,null,null,"Max heat loss (W/m)","insulation thickness (mm)",null,null,null,null,null,null,"Max heat loss (W/m)","insulation thickness (mm)",null,null,null,null,null,null,"Max heat loss (W/m)","insulation thickness (mm)",null,null,null,null,null,null,"Max heat loss (W/m)","insulation thickness (mm)",null,null,null,null,null,null,"Max heat loss (W/m)"]
[null,null,null,"λ = 0.025","λ = 0.03","λ = 0.035","λ = 0.04","λ = 0.045","λ = 0.05","λ = 0.055",null,"λ = 0.035","λ = 0.04","λ = 0.045","λ = 0.05","λ = 0.055","λ = 0.06","λ = 0.065",null,"λ = 0.045","λ = 0.05","λ = 0.055","λ = 0.06","λ = 0.065","λ = 0.07","λ = 0.075",null,"λ = 0.055","λ = 0.06","λ = 0.065","λ = 0.07","λ = 0.075","λ = 0.08","λ = 0.085",null,"λ = 0.065","λ = 0.07","λ = 0.075","λ = 0.08","λ = 0.085","λ = 0.09","λ = 0.095",null,"λ = 0.075","λ = 0.08","λ = 0.085","λ = 0.09","λ = 0.095","λ = 0.1","λ = 0.105",null,"λ = 0.085","λ = 0.09","λ = 0.095","λ = 0.1","λ = 0.105","λ = 0.11","λ = 0.115"]
[null,10,17.2,10,14,19,24,31,40,51,12.79,20,26,33,42,54,68,85,28.67,30,38,47,59,73,91,112,47.12,39,48,59,73,89,108,131,69.08,46,56,67,80,96,115,137,96.08,52,62,73,87,102,120,141,126.93,56,65,76,88,103,119,138,163.63]
[null,15,21.3,11,15,20,25,32,40,51,14.04,22,28,36,46,57,71,88,30.72,32,41,50,62,76,93,114,50.54,42,51,62,76,91,110,132,74.099999999999994,49,59,70,83,98,116,137,103,56,66,77,91,106,123,143,135.4,60,69,80,92,106,122,141,174.49]
[null,20,26.9,13,17,21,27,34,42,52,15.42,24,30,38,47,59,72,88,33.729999999999997,35,43,53,65,79,95,115,54.97,46,55,66,80,95,113,134,80.06,54,64,75,88,103,121,141,110.72,61,71,82,96,111,128,147,145.58000000000001,65,75,86,98,113,128,146,186.89]
[null,25,33.700000000000003,14,18,23,28,35,43,52,17.25,26,32,40,49,60,73,88,37.11,38,46,56,68,81,97,116,59.9,49,58,69,82,97,114,134,87.16,58,68,79,92,107,124,143,119.8,66,76,87,101,115,132,151,156.77000000000001,70,80,91,103,117,133,150,201.2]
[null,32,42.4,15,19,24,30,37,45,54,19.149999999999999,28,35,43,52,63,76,90,40.76,41,49,59,71,84,99,116,65.790000000000006,53,62,73,86,101,117,136,95.05,62,72,83,96,110,127,145,130.57,71,81,92,105,120,136,155,170,76,86,97,109,123,138,155,217.29]
[null,40,48.3,16,20,25,31,38,46,54,20.420000000000002,29,36,44,53,64,76,90,43.42,43,51,61,73,86,101,118,69.42,55,65,76,89,104,120,139,99.66,64,75,86,99,113,129,148,136.94999999999999,73,84,95,108,123,139,157,178.3,79,89,100,112,126,141,158,227.84]
[null,50,60.3,17,21,26,32,39,46,54,23.17,31,38,46,55,65,77,90,48.44,46,54,64,76,88,102,119,76.66,59,68,79,92,106,121,139,109.91,69,80,91,104,118,134,151,149.28,78,89,101,113,127,143,160,194.3,85,95,106,118,132,147,163,247.23]
[null,65,76.099999999999994,18,23,28,34,41,48,56,26.21,34,41,49,58,68,80,92,54.2,49,58,68,80,92,106,122,85.08,63,73,84,97,111,126,143,121.21,74,85,96,109,123,138,155,164.62,84,95,107,119,133,149,165,213.22,91,102,113,125,139,153,169,270.2]
[null,80,88.9,19,24,29,35,42,49,57,28.73,36,43,51,60,70,81,94,58.66,51,60,70,81,94,107,122,92.02,66,76,87,100,113,128,145,130.15,77,88,99,112,125,140,15,176.67,88,99,111,123,137,152,168,227.69,95,106,117,129,143,157,173,288.43]
[null,100,114.3,20,25,30,36,43,49,57,33.89,38,46,54,63,73,84,96,67.25,55,64,74,85,97,110,125,104.55,71,81,92,105,118,133,148,146.83000000000001,83,94,105,118,131,146,161,198.17,95,106,118,130,144,159,174,254.18,103,114,125,137,151,165,180,320.67]
[null,125,139.69999999999999,21,26,31,37,44,50,57,38.74,40,48,56,65,75,85,97,75.739999999999995,58,67,77,88,100,113,127,116.62,74,84,95,107,120,134,149,163.6,88,99,110,123,136,150,166,218.23,100,111,123,135,149,163,178,279.81,109,120,131,143,157,170,185,351.43]
[null,150,168.3,22,27,33,38,44,51,58,43.99,42,50,58,67,77,87,98,84.85,61,70,80,91,103,115,129,129.46,78,88,99,111,124,138,153,180.38,92,103,114,126,140,154,169,240.54,106,117,129,141,155,169,184,305.52999999999997,115,126,137,149,162,176,191,383.75]
[null,200,219.1,23,28,34,39,45,52,58,53.38,44,52,60,69,78,88,99,101.24,64,73,83,94,105,117,130,152.69999999999999,83,93,104,116,129,142,156,209.59,98,109,120,132,145,159,173,277.77,113,124,136,148,161,175,189,350.96,123,135,146,158,170,184,192,437.18]
[null,250,273,24,29,35,40,46,53,59,62.87,46,54,62,71,80,90,100,117.64,67,76,86,97,108,120,132,175.73,87,97,108,120,133,146,159,239.4,103,114,125,137,150,163,176,315.35000000000002,123,135,147,159,173,191,191,386.92,128,139,154,166,179,193,193,495.09]
[]
[null,"Table 21: Minimum insulation thickness for process pipework and equipment to control heat loss"]
[null,"Nominal diameter (mm)","Outside diameter (mm)","t = 100",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"t = 200",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"t = 300",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"t = 400",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"t = 500",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"t = 600",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"t = 700"]
[null,null,null,"insulation thickness (mm)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max heat loss (W/m)","insulation thickness (mm)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max heat loss (W/m)","insulation thickness (mm)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max heat loss (W/m)","insulation thickness (mm)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max heat loss (W/m)","insulation thickness (mm)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max heat loss (W/m)","insulation thickness (mm)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max heat loss (W/m)","insulation thickness (mm)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max heat loss (W/m)"]
[null,null,null,"λ = 0.025","λ = 0.03","λ = 0.035","λ = 0.04","λ = 0.045","λ = 0.05","λ = 0.055","λ = 0.06","λ = 0.065","λ = 0.07","λ = 0.075","λ = 0.08","λ = 0.085","λ = 0.09","λ = 0.095","λ = 0.1","λ = 0.105","λ = 0.11","λ = 0.115",null,"λ = 0.025","λ = 0.03","λ = 0.035","λ = 0.04","λ = 0.045","λ = 0.05","λ = 0.055","λ = 0.06","λ = 0.065","λ = 0.07","λ = 0.075","λ = 0.08","λ = 0.085","λ = 0.09","λ = 0.095","λ = 0.1","λ = 0.105","λ = 0.11","λ = 0.115",null,"λ = 0.025","λ = 0.03","λ = 0.035","λ = 0.04","λ = 0.045","λ = 0.05","λ = 0.055","λ = 0.06","λ = 0.065","λ = 0.07","λ = 0.075","λ = 0.08","λ = 0.085","λ = 0.09","λ = 0.095","λ = 0.1","λ = 0.105","λ = 0.11","λ = 0.115",null,"λ = 0.025","λ = 0.03","λ = 0.035","λ = 0.04","λ = 0.045","λ = 0.05","λ = 0.055","λ = 0.06","λ = 0.065","λ = 0.07","λ = 0.075","λ = 0.08","λ = 0.085","λ = 0.09","λ = 0.095","λ = 0.1","λ = 0.105","λ = 0.11","λ = 0.115",null,"λ = 0.025","λ = 0.03","λ = 0.035","λ = 0.04","λ = 0.045","λ = 0.05","λ = 0.055","λ = 0.06","λ = 0.065","λ = 0.07","λ = 0.075","λ = 0.08","λ = 0.085","λ = 0.09","λ = 0.095","λ = 0.1","λ = 0.105","λ = 0.11","λ = 0.115",null,"λ = 0.025","λ = 0.03","λ = 0.035","λ = 0.04","λ = 0.045","λ = 0.05","λ = 0.055","λ = 0.06","λ = 0.065","λ = 0.07","λ = 0.075","λ = 0.08","λ = 0.085","λ = 0.09","λ = 0.095","λ = 0.1","λ = 0.105","λ = 0.11","λ = 0.115",null,"λ = 0.025","λ = 0.03","λ = 0.035","λ = 0.04","λ = 0.045","λ = 0.05","λ = 0.055","λ = 0.06","λ = 0.065","λ = 0.07","λ = 0.075","λ = 0.08","λ = 0.085","λ = 0.09","λ = 0.095","λ = 0.1","λ = 0.105","λ = 0.11","λ = 0.115"]
[null,10,17.2,10,14,19,24,31,40,51,null,null,null,null,null,null,null,null,null,null,null,null,12.79,20,20,20,26,33,42,54,68,85,null,null,null,null,null,null,null,null,null,null,28.67,30,30,30,30,30,38,47,59,73,91,112,null,null,null,null,null,null,null,null,47.12,39,39,39,39,39,39,39,48,59,73,89,108,131,null,null,null,null,null,null,69.08,46,46,46,46,46,46,46,46,46,56,67,80,96,115,137,null,null,null,null,96.08,52,52,52,52,52,52,52,52,52,52,52,62,73,87,102,120,141,null,null,126.93,56,56,56,56,56,56,56,56,56,56,56,56,56,65,76,88,103,119,138,163.63]
[null,15,21.3,11,15,20,25,32,40,51,null,null,null,null,null,null,null,null,null,null,null,null,14.04,22,22,22,28,36,46,57,71,88,null,null,null,null,null,null,null,null,null,null,30.72,32,32,32,32,32,41,50,62,76,93,114,null,null,null,null,null,null,null,null,50.54,42,42,42,42,42,42,42,51,62,76,91,110,132,null,null,null,null,null,null,74.099999999999994,49,49,49,49,49,49,49,49,49,59,70,83,98,116,137,null,null,null,null,103,56,56,56,56,56,56,56,56,56,56,56,66,77,91,106,123,143,null,null,135.4,60,60,60,60,60,60,60,60,60,60,60,60,60,69,80,92,106,122,141,174.49]
[null,20,26.9,13,17,21,27,34,42,52,null,null,null,null,null,null,null,null,null,null,null,null,15.42,24,24,24,30,38,47,59,72,88,null,null,null,null,null,null,null,null,null,null,33.729999999999997,35,35,35,35,35,43,53,65,79,95,115,null,null,null,null,null,null,null,null,54.97,46,46,46,46,46,46,46,55,66,80,95,113,134,null,null,null,null,null,null,80.06,54,54,54,54,54,54,54,54,54,64,75,88,103,121,141,null,null,null,null,110.72,61,61,61,61,61,61,61,61,61,61,61,71,82,96,111,128,147,null,null,145.58000000000001,65,65,65,65,65,65,65,65,65,65,65,65,65,75,86,98,113,128,146,186.89]
[null,25,33.700000000000003,14,18,23,28,35,43,52,null,null,null,null,null,null,null,null,null,null,null,null,17.25,26,26,26,32,40,49,60,73,88,null,null,null,null,null,null,null,null,null,null,37.11,38,38,38,38,38,46,56,68,81,97,116,null,null,null,null,null,null,null,null,59.9,49,49,49,49,49,49,49,58,69,82,97,114,134,null,null,null,null,null,null,87.16,58,58,58,58,58,58,58,58,58,68,79,92,107,124,143,null,null,null,null,119.8,66,66,66,66,66,66,66,66,66,66,66,76,87,101,115,132,151,null,null,156.77000000000001,70,70,70,70,70,70,70,70,70,70,70,70,70,80,91,103,117,133,150,201.2]
[null,32,42.4,15,19,24,30,37,45,54,null,null,null,null,null,null,null,null,null,null,null,null,19.149999999999999,28,28,28,35,43,52,63,76,90,null,null,null,null,null,null,null,null,null,null,40.76,41,41,41,41,41,49,59,71,84,99,116,null,null,null,null,null,null,null,null,65.790000000000006,53,53,53,53,53,53,53,62,73,86,101,117,136,null,null,null,null,null,null,95.05,62,62,62,62,62,62,62,62,62,72,83,96,110,127,145,null,null,null,null,130.57,71,71,71,71,71,71,71,71,71,71,71,81,92,105,120,136,155,null,null,170,76,76,76,76,76,76,76,76,76,76,76,76,76,86,97,109,123,138,155,217.29]
[null,40,48.3,16,20,25,31,38,46,54,null,null,null,null,null,null,null,null,null,null,null,null,20.420000000000002,29,29,29,36,44,53,64,76,90,null,null,null,null,null,null,null,null,null,null,43.42,43,43,43,43,43,51,61,73,86,101,118,null,null,null,null,null,null,null,null,69.42,55,55,55,55,55,55,55,65,76,89,104,120,139,null,null,null,null,null,null,99.66,64,64,64,64,64,64,64,64,64,75,86,99,113,129,148,null,null,null,null,136.94999999999999,73,73,73,73,73,73,73,73,73,73,73,84,95,108,123,139,157,null,null,178.3,79,79,79,79,79,79,79,79,79,79,79,79,79,89,100,112,126,141,158,227.84]
[null,50,60.3,17,21,26,32,39,46,54,null,null,null,null,null,null,null,null,null,null,null,null,23.17,31,31,31,38,46,55,65,77,90,null,null,null,null,null,null,null,null,null,null,48.44,46,46,46,46,46,54,64,76,88,102,119,null,null,null,null,null,null,null,null,76.66,59,59,59,59,59,59,59,68,79,92,106,121,139,null,null,null,null,null,null,109.91,69,69,69,69,69,69,69,69,69,80,91,104,118,134,151,null,null,null,null,149.28,78,78,78,78,78,78,78,78,78,78,78,89,101,113,127,143,160,null,null,194.3,85,85,85,85,85,85,85,85,85,85,85,85,85,95,106,118,132,147,163,247.23]
[null,65,76.099999999999994,18,23,28,34,41,48,56,null,null,null,null,null,null,null,null,null,null,null,null,26.21,34,34,34,41,49,58,68,80,92,null,null,null,null,null,null,null,null,null,null,54.2,49,49,49,49,49,58,68,80,92,106,122,null,null,null,null,null,null,null,null,85.08,63,63,63,63,63,63,63,73,84,97,111,126,143,null,null,null,null,null,null,121.21,74,74,74,74,74,74,74,74,74,85,96,109,123,138,155,null,null,null,null,164.62,84,84,84,84,84,84,84,84,84,84,84,95,107,119,133,149,165,null,null,213.22,91,91,91,91,91,91,91,91,91,91,91,91,91,102,113,125,139,153,169,270.2]
[null,80,88.9,19,24,29,35,42,49,57,null,null,null,null,null,null,null,null,null,null,null,null,28.73,36,36,36,43,51,60,70,81,94,null,null,null,null,null,null,null,null,null,null,58.66,51,51,51,51,51,60,70,81,94,107,122,null,null,null,null,null,null,null,null,92.02,66,66,66,66,66,66,66,76,87,100,113,128,145,null,null,null,null,null,null,130.15,77,77,77,77,77,77,77,77,77,88,99,112,125,140,15,null,null,null,null,176.67,88,88,88,88,88,88,88,88,88,88,88,99,111,123,137,152,168,null,null,227.69,95,95,95,95,95,95,95,95,95,95,95,95,95,106,117,129,143,157,173,288.43]
[null,100,114.3,20,25,30,36,43,49,57,null,null,null,null,null,null,null,null,null,null,null,null,33.89,38,38,38,46,54,63,73,84,96,null,null,null,null,null,null,null,null,null,null,67.25,55,55,55,55,55,64,74,85,97,110,125,null,null,null,null,null,null,null,null,104.55,71,71,71,71,71,71,71,81,92,105,118,133,148,null,null,null,null,null,null,146.83000000000001,83,83,83,83,83,83,83,83,83,94,105,118,131,146,161,null,null,null,null,198.17,95,95,95,95,95,95,95,95,95,95,95,106,118,130,144,159,174,null,null,254.18,103,103,103,103,103,103,103,103,103,103,103,103,103,114,125,137,151,165,180,320.67]
[null,125,139.69999999999999,21,26,31,37,44,50,57,null,null,null,null,null,null,null,null,null,null,null,null,38.74,40,40,40,48,56,65,75,85,97,null,null,null,null,null,null,null,null,null,null,75.739999999999995,58,58,58,58,58,67,77,88,100,113,127,null,null,null,null,null,null,null,null,116.62,74,74,74,74,74,74,74,84,95,107,120,134,149,null,null,null,null,null,null,163.6,88,88,88,88,88,88,88,88,88,99,110,123,136,150,166,null,null,null,null,218.23,100,100,100,100,100,100,100,100,100,100,100,111,123,135,149,163,178,null,null,279.81,109,109,109,109,109,109,109,109,109,109,109,109,109,120,131,143,157,170,185,351.43]
[null,150,168.3,22,27,33,38,44,51,58,null,null,null,null,null,null,null,null,null,null,null,null,43.99,42,42,42,50,58,67,77,87,98,null,null,null,null,null,null,null,null,null,null,84.85,61,61,61,61,61,70,80,91,103,115,129,null,null,null,null,null,null,null,null,129.46,78,78,78,78,78,78,78,88,99,111,124,138,153,null,null,null,null,null,null,180.38,92,92,92,92,92,92,92,92,92,103,114,126,140,154,169,null,null,null,null,240.54,106,106,106,106,106,106,106,106,106,106,106,117,129,141,155,169,184,null,null,305.52999999999997,115,115,115,115,115,115,115,115,115,115,115,115,115,126,137,149,162,176,191,383.75]
[null,200,219.1,23,28,34,39,45,52,58,null,null,null,null,null,null,null,null,null,null,null,null,53.38,44,44,44,52,60,69,78,88,99,null,null,null,null,null,null,null,null,null,null,101.24,64,64,64,64,64,73,83,94,105,117,130,null,null,null,null,null,null,null,null,152.69999999999999,83,83,83,83,83,83,83,93,104,116,129,142,156,null,null,null,null,null,null,209.59,98,98,98,98,98,98,98,98,98,109,120,132,145,159,173,null,null,null,null,277.77,113,113,113,113,113,113,113,113,113,113,113,124,136,148,161,175,189,null,null,350.96,123,123,123,123,123,123,123,123,123,123,123,123,123,135,146,158,170,184,192,437.18]
[null,250,273,24,29,35,40,46,53,59,null,null,null,null,null,null,null,null,null,null,null,null,62.87,46,46,46,54,62,71,80,90,100,null,null,null,null,null,null,null,null,null,null,117.64,67,67,67,67,67,76,86,97,108,120,132,null,null,null,null,null,null,null,null,175.73,87,87,87,87,87,87,87,97,108,120,133,146,159,null,null,null,null,null,null,239.4,103,103,103,103,103,103,103,103,103,114,125,137,150,163,176,null,null,null,null,315.35000000000002,123,123,123,123,123,123,123,123,123,123,123,135,147,159,173,191,191,null,null,386.92,128,128,128,128,128,128,128,128,128,128,128,128,128,139,154,166,179,193,193,495.09]

{"sheet":"Reference","index":6,"n_rows":76,"n_cols":49,"rows_kept":76,"cut":false,"hidden":true,"merged":[[40,7,42,11],[37,25,41,28],[37,42,41,45]]}
[]
[null,"Nominal Pipe Sizes [BS:3600]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nominal Pipe Sizes [BS:3600]"]
[null,"Nominal Pipe Size (mm)","Odmax",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nominal Pipe Size (mm)","Odmax"]
[null,8,13.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,13.5]
[null,10,17.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,17.2]
[null,15,21.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,21.3]
[null,20,26.9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,26.9]
[null,25,33.700000000000003,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,33.700000000000003]
[null,32,42.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,42.4]
[null,40,48.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,48.3]
[null,50,60.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,60.3]
[null,65,76.099999999999994,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,76.099999999999994]
[null,80,88.9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,88.9]
[null,90,101.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,101.6]
[null,100,114.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,114.3]
[null,125,139.69999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,125,139.69999999999999]
[null,150,168.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,168.3]
[null,175,193.7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,175,193.7]
[null,200,219.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,219.1]
[null,222.5,244.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,222.5,244.5]
[null,250,273,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,250,273]
[null,300,323.89999999999998,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300,323.89999999999998]
[]
[null,"Thermal Conductivity, W/mK [CIBSE Guide C, Figure 3.8]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thermal Conductivity, W/mK [CIBSE Guide C, Figure 3.8]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thermal Conductivity, W/mK [CIBSE Guide C, Figure 3.8]"]
[null,"Material","Flow","Return",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Material","Flow","Return",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Material","Flow","Return"]
[null,"Glass Fibre",0.04,0.04,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Glass Fibre",0.04,0.04,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Glass Fibre",0.04,0.04]
[null,"Mineral Wool",4.4999999999999998E-2,4.4999999999999998E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mineral Wool",4.4999999999999998E-2,4.4999999999999998E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mineral Wool",4.4999999999999998E-2,4.4999999999999998E-2]
[null,"85% Magnesia",6.3500000000000001E-2,6.3500000000000001E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"85% Magnesia",6.3500000000000001E-2,6.3500000000000001E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"85% Magnesia",6.3500000000000001E-2,6.3500000000000001E-2]
[null,"Calcium Silicate",6.4000000000000001E-2,6.4000000000000001E-2,null,"Re-ordered",null,null,null,null,null,null,null,null,null,null,null,null,"Calcium Silicate",6.4000000000000001E-2,6.4000000000000001E-2,null,"Re-ordered",null,null,null,null,null,null,null,null,null,null,null,null,"Calcium Silicate",6.4000000000000001E-2,6.4000000000000001E-2,null,"Re-ordered"]
[null,{"$f":"IF('PI Calculator'!C16<>\"\",'PI Calculator'!C16,\"\")","v":""},{"$f":"IF('PI Calculator'!C17=\"\",1,'PI Calculator'!C17)","v":1},{"$f":"IF('PI Calculator'!C18=\"\",1,'PI Calculator'!C18)","v":1},null,{"$f":"IF(B30=\"\",IF(B31<>\"\",B31,IF(B32<>\"\",B32,\"\")),B30)","v":""},{"$f":"IF(C30=1,IF(C31<>1,C31,IF(C32<>1,C32,1)),C30)","v":1},{"$f":"IF(D30=1,IF(D31<>1,D31,IF(D32<>1,D32,1)),D30)","v":1},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Non PI Calculator'!C16<>\"\",'Non PI Calculator'!C16,\"\")","v":""},{"$f":"IF('Non PI Calculator'!C17=\"\",1,'Non PI Calculator'!C17)","v":1},{"$f":"IF('Non PI Calculator'!C18=\"\",1,'Non PI Calculator'!C18)","v":1},null,{"$f":"IF(S30=\"\",IF(S31<>\"\",S31,IF(S32<>\"\",S32,\"\")),S30)","v":""},{"$f":"IF(T30=1,IF(T31<>1,T31,IF(T32<>1,T32,1)),T30)","v":1},{"$f":"IF(U30=1,IF(U31<>1,U31,IF(U32<>1,U32,1)),U30)","v":1},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Storage Tanks'!C16<>\"\",'Storage Tanks'!C16,\"\")","v":""},{"$f":"IF('Storage Tanks'!C17=\"\",1,'Storage Tanks'!C17)","v":1},{"$f":"IF('Storage Tanks'!C18=\"\",1,'Storage Tanks'!C18)","v":1},null,{"$f":"IF(AJ30=\"\",IF(AJ31<>\"\",AJ31,IF(AJ32<>\"\",AJ32,\"\")),AJ30)","v":""},{"$f":"IF(AK30=1,IF(AK31<>1,AK31,IF(AK32<>1,AK32,1)),AK30)","v":1},{"$f":"IF(AL30=1,IF(AL31<>1,AL31,IF(AL32<>1,AL32,1)),AL30)","v":1}]
[null,{"$f":"IF('PI Calculator'!C21<>\"\",'PI Calculator'!C21,\"\")","v":""},{"$f":"IF('PI Calculator'!C22=\"\",1,'PI Calculator'!C22)","v":1},{"$f":"IF('PI Calculator'!C23=\"\",1,'PI Calculator'!C23)","v":1},null,{"$f":"IF(B30<>\"\",IF(B31<>\"\",B31,IF(AND(B32<>\"\",F30<>B32),B32,\"\")),IF(AND(B32<>\"\",F30<>B32),B32,\"\"))","v":""},{"$f":"IF(C30<>1,IF(C31<>1,C31,IF(C32<>1,C32,1)),IF(C32<>1,C32,1))","v":1},{"$f":"IF(D30<>1,IF(D31<>1,D31,IF(D32<>1,D32,1)),IF(D32<>1,D32,1))","v":1},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Non PI Calculator'!C21<>\"\",'Non PI Calculator'!C21,\"\")","v":""},{"$f":"IF('Non PI Calculator'!C22=\"\",1,'Non PI Calculator'!C22)","v":1},{"$f":"IF('Non PI Calculator'!C23=\"\",1,'Non PI Calculator'!C23)","v":1},null,{"$f":"IF(S30<>\"\",IF(S31<>\"\",S31,IF(AND(S32<>\"\",W30<>S32),S32,\"\")),IF(AND(S32<>\"\",W30<>S32),S32,\"\"))","v":""},{"$f":"IF(T30<>1,IF(T31<>1,T31,IF(T32<>1,T32,1)),IF(T32<>1,T32,1))","v":1},{"$f":"IF(U30<>1,IF(U31<>1,U31,IF(U32<>1,U32,1)),IF(U32<>1,U32,1))","v":1},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Storage Tanks'!C21<>\"\",'Storage Tanks'!C21,\"\")","v":""},{"$f":"IF('Storage Tanks'!C22=\"\",1,'Storage Tanks'!C22)","v":1},{"$f":"IF('Storage Tanks'!C23=\"\",1,'Storage Tanks'!C23)","v":1},null,{"$f":"IF(AJ30<>\"\",IF(AJ31<>\"\",AJ31,IF(AND(AJ32<>\"\",AN30<>AJ32),AJ32,\"\")),IF(AND(AJ32<>\"\",AN30<>AJ32),AJ32,\"\"))","v":""},{"$f":"IF(AK30<>1,IF(AK31<>1,AK31,IF(AK32<>1,AK32,1)),IF(AK32<>1,AK32,1))","v":1},{"$f":"IF(AL30<>1,IF(AL31<>1,AL31,IF(AL32<>1,AL32,1)),IF(AL32<>1,AL32,1))","v":1}]
[null,{"$f":"IF('PI Calculator'!C26<>\"\",'PI Calculator'!C26,\"\")","v":""},{"$f":"IF('PI Calculator'!C27=\"\",1,'PI Calculator'!C27)","v":1},{"$f":"IF('PI Calculator'!C28=\"\",1,'PI Calculator'!C28)","v":1},null,{"$f":"IF(AND(F31<>B32,F30<>B32),B32,\"\")","v":""},{"$f":"IF(F32<>\"\",C32,1)","v":1},{"$f":"IF(F32<>\"\",D32,1)","v":1},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Non PI Calculator'!C26<>\"\",'Non PI Calculator'!C26,\"\")","v":""},{"$f":"IF('Non PI Calculator'!C27=\"\",1,'Non PI Calculator'!C27)","v":1},{"$f":"IF('Non PI Calculator'!C28=\"\",1,'Non PI Calculator'!C28)","v":1},null,{"$f":"IF(AND(W31<>S32,W30<>S32),S32,\"\")","v":""},{"$f":"IF(W32<>\"\",T32,1)","v":1},{"$f":"IF(W32<>\"\",U32,1)","v":1},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Storage Tanks'!C26<>\"\",'Storage Tanks'!C26,\"\")","v":""},{"$f":"IF('Storage Tanks'!C27=\"\",1,'Storage Tanks'!C27)","v":1},{"$f":"IF('Storage Tanks'!C28=\"\",1,'Storage Tanks'!C28)","v":1},null,{"$f":"IF(AND(AN31<>AJ32,AN30<>AJ32),AJ32,\"\")","v":""},{"$f":"IF(AN32<>\"\",AK32,1)","v":1},{"$f":"IF(AN32<>\"\",AL32,1)","v":1}]
[]
[null,"External Heat Transfer Coefficient, W/m²K [CIBSE Guide C, Table 3.25]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"External Heat Transfer Coefficient, W/m²K [CIBSE Guide C, Table 3.25]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"External Heat Transfer Coefficient, W/m²K [CIBSE Guide C, Table 3.25]"]
[null,null,"High-e","Med-e","Low-e","Tanks",null,null,null,null,null,null,null,null,null,null,null,null,null,"High-e","Med-e","Low-e","Tanks",null,null,null,null,null,null,null,null,null,null,null,null,null,"High-e","Med-e","Low-e","Tanks"]
[null,"Sheltered",10,8,5.7,16.7,null,null,null,null,null,null,null,null,null,null,null,null,"Sheltered",10,8,5.7,16.7,null,null,null,null,null,null,null,null,null,null,null,null,"Sheltered",10,8,5.7,16.7]
[null,"Exposed",20,18,15.5,40,null,null,null,null,null,null,null,null,null,null,null,null,"Exposed",20,18,15.5,40,null,null,null,null,null,null,null,null,null,null,null,null,"Exposed",20,18,15.5,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NON PI CALCULATOR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STORAGE TANK CALCULATOR"]
[null,"Fitting Heat Loss, W/K",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fitting Heat Loss, W/K",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fitting Heat Loss, W/K"]
[null,"Insulated?","Yes","No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Insulated?","Yes","No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Insulated?","Yes","No"]
[null,"Valve",1.5,1.8,null,null,null,"PI CALCULATOR",null,null,null,null,null,null,null,null,null,null,"Valve",1.5,1.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Valve",1.5,1.8]
[null,"Flange",1.2,1.35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flange",1.2,1.35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flange",1.2,1.35]
[]
[null,"Monthly Air Temperature Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Monthly Air Temperature Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Monthly Air Temperature Data"]
[null,null,"Unit","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec",null,null,null,null,"Unit","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec",null,null,null,null,"Unit","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,"Ambient Temperature","ºC",{"$f":"VLOOKUP('PI Calculator'!$C$11,Reference!$B$47:$O$59,COLUMN()-1,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('PI Calculator'!$C$11,Reference!$B$47:$O$59,COLUMN()-1,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('PI Calculator'!$C$11,Reference!$B$47:$O$59,COLUMN()-1,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('PI Calculator'!$C$11,Reference!$B$47:$O$59,COLUMN()-1,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('PI Calculator'!$C$11,Reference!$B$47:$O$59,COLUMN()-1,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('PI Calculator'!$C$11,Reference!$B$47:$O$59,COLUMN()-1,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('PI Calculator'!$C$11,Reference!$B$47:$O$59,COLUMN()-1,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('PI Calculator'!$C$11,Reference!$B$47:$O$59,COLUMN()-1,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('PI Calculator'!$C$11,Reference!$B$47:$O$59,COLUMN()-1,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('PI Calculator'!$C$11,Reference!$B$47:$O$59,COLUMN()-1,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('PI Calculator'!$C$11,Reference!$B$47:$O$59,COLUMN()-1,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('PI Calculator'!$C$11,Reference!$B$47:$O$59,COLUMN()-1,FALSE)","v":{"$error":"#N/A"}},null,null,null,"Ambient Temperature","ºC",{"$f":"VLOOKUP('Non PI Calculator'!$C$11,Reference!$S$47:$AF$59,COLUMN()-18,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Non PI Calculator'!$C$11,Reference!$S$47:$AF$59,COLUMN()-18,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Non PI Calculator'!$C$11,Reference!$S$47:$AF$59,COLUMN()-18,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Non PI Calculator'!$C$11,Reference!$S$47:$AF$59,COLUMN()-18,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Non PI Calculator'!$C$11,Reference!$S$47:$AF$59,COLUMN()-18,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Non PI Calculator'!$C$11,Reference!$S$47:$AF$59,COLUMN()-18,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Non PI Calculator'!$C$11,Reference!$S$47:$AF$59,COLUMN()-18,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Non PI Calculator'!$C$11,Reference!$S$47:$AF$59,COLUMN()-18,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Non PI Calculator'!$C$11,Reference!$S$47:$AF$59,COLUMN()-18,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Non PI Calculator'!$C$11,Reference!$S$47:$AF$59,COLUMN()-18,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Non PI Calculator'!$C$11,Reference!$S$47:$AF$59,COLUMN()-18,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Non PI Calculator'!$C$11,Reference!$S$47:$AF$59,COLUMN()-18,FALSE)","v":{"$error":"#N/A"}},null,null,null,"Ambient Temperature","ºC",{"$f":"VLOOKUP('Storage Tanks'!$C$11,Reference!$AJ$47:$AW$59,COLUMN()-35,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Storage Tanks'!$C$11,Reference!$AJ$47:$AW$59,COLUMN()-35,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Storage Tanks'!$C$11,Reference!$AJ$47:$AW$59,COLUMN()-35,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Storage Tanks'!$C$11,Reference!$AJ$47:$AW$59,COLUMN()-35,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Storage Tanks'!$C$11,Reference!$AJ$47:$AW$59,COLUMN()-35,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Storage Tanks'!$C$11,Reference!$AJ$47:$AW$59,COLUMN()-35,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Storage Tanks'!$C$11,Reference!$AJ$47:$AW$59,COLUMN()-35,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Storage Tanks'!$C$11,Reference!$AJ$47:$AW$59,COLUMN()-35,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Storage Tanks'!$C$11,Reference!$AJ$47:$AW$59,COLUMN()-35,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Storage Tanks'!$C$11,Reference!$AJ$47:$AW$59,COLUMN()-35,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Storage Tanks'!$C$11,Reference!$AJ$47:$AW$59,COLUMN()-35,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Storage Tanks'!$C$11,Reference!$AJ$47:$AW$59,COLUMN()-35,FALSE)","v":{"$error":"#N/A"}}]
[null,"Belfast","ºC",4.7258064516129004,4.0574404761904725,6.2358870967741957,6.8404166666666661,10.92110215053764,12.534166666666673,14.599596774193552,14.700000000000001,12.755972222222226,9.9344086021505316,6.6829166666666637,5.7368279569892557,null,null,null,"Belfast","ºC",4.7258064516129004,4.0574404761904725,6.2358870967741957,6.8404166666666661,10.92110215053764,12.534166666666673,14.599596774193552,14.700000000000001,12.755972222222226,9.9344086021505316,6.6829166666666637,5.7368279569892557,null,null,null,"Belfast","ºC",4.7258064516129004,4.0574404761904725,6.2358870967741957,6.8404166666666661,10.92110215053764,12.534166666666673,14.599596774193552,14.700000000000001,12.755972222222226,9.9344086021505316,6.6829166666666637,5.7368279569892557]
[null,"Birmingham","ºC",4.9288978494623681,5.4974702380952376,6.3176075268817167,7.4656944444444484,11.613978494623655,14.22916666666667,17.114381720430099,16.27620967741937,13.150555555555545,9.8883064516129178,6.6087500000000068,5.1948924731182746,null,null,null,"Birmingham","ºC",4.9288978494623681,5.4974702380952376,6.3176075268817167,7.4656944444444484,11.613978494623655,14.22916666666667,17.114381720430099,16.27620967741937,13.150555555555545,9.8883064516129178,6.6087500000000068,5.1948924731182746,null,null,null,"Birmingham","ºC",4.9288978494623681,5.4974702380952376,6.3176075268817167,7.4656944444444484,11.613978494623655,14.22916666666667,17.114381720430099,16.27620967741937,13.150555555555545,9.8883064516129178,6.6087500000000068,5.1948924731182746]
[null,"Cardiff","ºC",6.2024193548387085,4.9145833333333329,6.5956989247311801,8.4819444444444461,12.185349462365586,13.970972222222205,16.063306451612899,16.120161290322589,13.856527777777778,11.174462365591392,8.5633333333333432,6.7474462365591403,null,null,null,"Cardiff","ºC",6.2024193548387085,4.9145833333333329,6.5956989247311801,8.4819444444444461,12.185349462365586,13.970972222222205,16.063306451612899,16.120161290322589,13.856527777777778,11.174462365591392,8.5633333333333432,6.7474462365591403,null,null,null,"Cardiff","ºC",6.2024193548387085,4.9145833333333329,6.5956989247311801,8.4819444444444461,12.185349462365586,13.970972222222205,16.063306451612899,16.120161290322589,13.856527777777778,11.174462365591392,8.5633333333333432,6.7474462365591403]
[null,"Edinburgh","ºC",4.0366935483870883,5.0767857142857205,6.3071236559139763,7.3834722222222231,10.086559139784955,12.767361111111111,14.8095430107527,14.307526881720419,11.748472222222208,8.9842741935483907,5.7631944444444523,4.0967741935483906,null,null,null,"Edinburgh","ºC",4.0366935483870883,5.0767857142857205,6.3071236559139763,7.3834722222222231,10.086559139784955,12.767361111111111,14.8095430107527,14.307526881720419,11.748472222222208,8.9842741935483907,5.7631944444444523,4.0967741935483906,null,null,null,"Edinburgh","ºC",4.0366935483870883,5.0767857142857205,6.3071236559139763,7.3834722222222231,10.086559139784955,12.767361111111111,14.8095430107527,14.307526881720419,11.748472222222208,8.9842741935483907,5.7631944444444523,4.0967741935483906]
[null,"Glasgow","ºC",2.983602150537636,2.9376488095238105,5.8807795698924803,6.7777777777777768,10.434274193548394,13.123472222222217,14.477150537634406,14.177688172043021,12.257638888888899,9.1206989247311725,6.0456944444444405,5.3651881720430135,null,null,null,"Glasgow","ºC",2.983602150537636,2.9376488095238105,5.8807795698924803,6.7777777777777768,10.434274193548394,13.123472222222217,14.477150537634406,14.177688172043021,12.257638888888899,9.1206989247311725,6.0456944444444405,5.3651881720430135,null,null,null,"Glasgow","ºC",2.983602150537636,2.9376488095238105,5.8807795698924803,6.7777777777777768,10.434274193548394,13.123472222222217,14.477150537634406,14.177688172043021,12.257638888888899,9.1206989247311725,6.0456944444444405,5.3651881720430135]
[null,"Leeds","ºC",4.3376344086021561,5.4424107142857174,6.7168010752688136,8.7337500000000006,11.624865591397853,14.225138888888889,17.425134408602162,15.643145161290299,13.548611111111114,10.372849462365581,7.2295833333333359,6.403091397849459,null,null,null,"Leeds","ºC",4.3376344086021561,5.4424107142857174,6.7168010752688136,8.7337500000000006,11.624865591397853,14.225138888888889,17.425134408602162,15.643145161290299,13.548611111111114,10.372849462365581,7.2295833333333359,6.403091397849459,null,null,null,"Leeds","ºC",4.3376344086021561,5.4424107142857174,6.7168010752688136,8.7337500000000006,11.624865591397853,14.225138888888889,17.425134408602162,15.643145161290299,13.548611111111114,10.372849462365581,7.2295833333333359,6.403091397849459]
[null,"London","ºC",6.2247311827956961,6.2870535714285793,7.1256720430107494,9.6252777777777752,13.480913978494632,16.012222222222199,18.511559139784943,17.886021505376341,15.060416666666677,11.836155913978494,8.6663888888888927,6.1955645161290276,null,null,null,"London","ºC",6.2247311827956961,6.2870535714285793,7.1256720430107494,9.6252777777777752,13.480913978494632,16.012222222222199,18.511559139784943,17.886021505376341,15.060416666666677,11.836155913978494,8.6663888888888927,6.1955645161290276,null,null,null,"London","ºC",6.2247311827956961,6.2870535714285793,7.1256720430107494,9.6252777777777752,13.480913978494632,16.012222222222199,18.511559139784943,17.886021505376341,15.060416666666677,11.836155913978494,8.6663888888888927,6.1955645161290276]
[null,"Manchester","ºC",5.4008064516129091,5.8278273809523817,6.5801075268817195,7.99,11.097580645161282,13.989722222222214,15.742204301075271,16.412768817204306,13.527500000000009,10.567338709677424,6.5736111111111075,5.9813172043010718,null,null,null,"Manchester","ºC",5.4008064516129091,5.8278273809523817,6.5801075268817195,7.99,11.097580645161282,13.989722222222214,15.742204301075271,16.412768817204306,13.527500000000009,10.567338709677424,6.5736111111111075,5.9813172043010718,null,null,null,"Manchester","ºC",5.4008064516129091,5.8278273809523817,6.5801075268817195,7.99,11.097580645161282,13.989722222222214,15.742204301075271,16.412768817204306,13.527500000000009,10.567338709677424,6.5736111111111075,5.9813172043010718]
[null,"Newcastle","ºC",4.616666666666668,5.2480654761904724,6.9479838709677386,7.2416666666666627,10.178629032258062,13.364166666666657,15.386559139784953,14.837231182795696,13.111249999999998,11.446505376344104,7.0124999999999975,5.4059139784946248,null,null,null,"Newcastle","ºC",4.616666666666668,5.2480654761904724,6.9479838709677386,7.2416666666666627,10.178629032258062,13.364166666666657,15.386559139784953,14.837231182795696,13.111249999999998,11.446505376344104,7.0124999999999975,5.4059139784946248,null,null,null,"Newcastle","ºC",4.616666666666668,5.2480654761904724,6.9479838709677386,7.2416666666666627,10.178629032258062,13.364166666666657,15.386559139784953,14.837231182795696,13.111249999999998,11.446505376344104,7.0124999999999975,5.4059139784946248]
[null,"Nottingham","ºC",3.9791666666666674,4.7388392857142829,6.2005376344086054,7.0104166666666679,11.743817204301084,14.291944444444463,16.930913978494637,15.51720430107528,12.95166666666668,10.114112903225802,6.0016666666666678,5.6159946236559106,null,null,null,"Nottingham","ºC",3.9791666666666674,4.7388392857142829,6.2005376344086054,7.0104166666666679,11.743817204301084,14.291944444444463,16.930913978494637,15.51720430107528,12.95166666666668,10.114112903225802,6.0016666666666678,5.6159946236559106,null,null,null,"Nottingham","ºC",3.9791666666666674,4.7388392857142829,6.2005376344086054,7.0104166666666679,11.743817204301084,14.291944444444463,16.930913978494637,15.51720430107528,12.95166666666668,10.114112903225802,6.0016666666666678,5.6159946236559106]
[null,"Plymouth","ºC",7.4528225806451447,6.8718750000000046,7.034274193548387,9.4118055555555546,12.101881720430116,13.97625,16.577419354838714,15.620564516128999,14.271111111111107,11.78454301075268,9.5297222222222224,8.2744623655914058,null,null,null,"Plymouth","ºC",7.4528225806451447,6.8718750000000046,7.034274193548387,9.4118055555555546,12.101881720430116,13.97625,16.577419354838714,15.620564516128999,14.271111111111107,11.78454301075268,9.5297222222222224,8.2744623655914058,null,null,null,"Plymouth","ºC",7.4528225806451447,6.8718750000000046,7.034274193548387,9.4118055555555546,12.101881720430116,13.97625,16.577419354838714,15.620564516128999,14.271111111111107,11.78454301075268,9.5297222222222224,8.2744623655914058]
[null,"Southampton","ºC",5.0732526881720421,6.701488095238096,7.0936827956989248,9.2520833333333332,12.53508064516129,15.756250000000005,16.858333333333359,17.185215053763429,14.826388888888882,11.681048387096769,7.9847222222222207,6.2487903225806516,null,null,null,"Southampton","ºC",5.0732526881720421,6.701488095238096,7.0936827956989248,9.2520833333333332,12.53508064516129,15.756250000000005,16.858333333333359,17.185215053763429,14.826388888888882,11.681048387096769,7.9847222222222207,6.2487903225806516,null,null,null,"Southampton","ºC",5.0732526881720421,6.701488095238096,7.0936827956989248,9.2520833333333332,12.53508064516129,15.756250000000005,16.858333333333359,17.185215053763429,14.826388888888882,11.681048387096769,7.9847222222222207,6.2487903225806516]
[null,"Swindon","ºC",4.5450268817204353,5.0505952380952355,5.4944892473118276,7.2683333333333255,11.865188172043027,14.32569444444446,16.572849462365603,15.996774193548383,13.368194444444462,10.335483870967728,6.4338888888888972,5.847043010752687,null,null,null,"Swindon","ºC",4.5450268817204353,5.0505952380952355,5.4944892473118276,7.2683333333333255,11.865188172043027,14.32569444444446,16.572849462365603,15.996774193548383,13.368194444444462,10.335483870967728,6.4338888888888972,5.847043010752687,null,null,null,"Swindon","ºC",4.5450268817204353,5.0505952380952355,5.4944892473118276,7.2683333333333255,11.865188172043027,14.32569444444446,16.572849462365603,15.996774193548383,13.368194444444462,10.335483870967728,6.4338888888888972,5.847043010752687]
[]
[null,"Monthly Ground Temperature Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Monthly Ground Temperature Data"]
[null,null,"Unit","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec",null,null,null,null,"Unit","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,"Ambient Temperature","ºC",{"$f":"VLOOKUP('PI Calculator'!$C$11,Reference!$B$64:$O$76,COLUMN()-1,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('PI Calculator'!$C$11,Reference!$B$64:$O$76,COLUMN()-1,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('PI Calculator'!$C$11,Reference!$B$64:$O$76,COLUMN()-1,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('PI Calculator'!$C$11,Reference!$B$64:$O$76,COLUMN()-1,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('PI Calculator'!$C$11,Reference!$B$64:$O$76,COLUMN()-1,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('PI Calculator'!$C$11,Reference!$B$64:$O$76,COLUMN()-1,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('PI Calculator'!$C$11,Reference!$B$64:$O$76,COLUMN()-1,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('PI Calculator'!$C$11,Reference!$B$64:$O$76,COLUMN()-1,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('PI Calculator'!$C$11,Reference!$B$64:$O$76,COLUMN()-1,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('PI Calculator'!$C$11,Reference!$B$64:$O$76,COLUMN()-1,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('PI Calculator'!$C$11,Reference!$B$64:$O$76,COLUMN()-1,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('PI Calculator'!$C$11,Reference!$B$64:$O$76,COLUMN()-1,FALSE)","v":{"$error":"#N/A"}},null,null,null,"Ambient Temperature","ºC",{"$f":"VLOOKUP('Non PI Calculator'!$C$11,Reference!$B$64:$O$76,COLUMN()-18,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Non PI Calculator'!$C$11,Reference!$B$64:$O$76,COLUMN()-18,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Non PI Calculator'!$C$11,Reference!$B$64:$O$76,COLUMN()-18,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Non PI Calculator'!$C$11,Reference!$B$64:$O$76,COLUMN()-18,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Non PI Calculator'!$C$11,Reference!$B$64:$O$76,COLUMN()-18,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Non PI Calculator'!$C$11,Reference!$B$64:$O$76,COLUMN()-18,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Non PI Calculator'!$C$11,Reference!$B$64:$O$76,COLUMN()-18,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Non PI Calculator'!$C$11,Reference!$B$64:$O$76,COLUMN()-18,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Non PI Calculator'!$C$11,Reference!$B$64:$O$76,COLUMN()-18,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Non PI Calculator'!$C$11,Reference!$B$64:$O$76,COLUMN()-18,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Non PI Calculator'!$C$11,Reference!$B$64:$O$76,COLUMN()-18,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Non PI Calculator'!$C$11,Reference!$B$64:$O$76,COLUMN()-18,FALSE)","v":{"$error":"#N/A"}}]
[null,"Belfast","ºC",6.75,6.5,7.5,9.5,13,16,18,18,16.5,13.5,10,7.75,null,null,null,"Belfast","ºC",6.75,6.5,7.5,9.5,13,16,18,18,16.5,13.5,10,7.75]
[null,"Birmingham","ºC",5.75,5.5,6.5,8.5,12,15,17,17,15.5,12.5,9,6.75,null,null,null,"Birmingham","ºC",5.75,5.5,6.5,8.5,12,15,17,17,15.5,12.5,9,6.75]
[null,"Cardiff","ºC",6.75,6.5,7.5,9.5,13,16,18,18,16.5,13.5,10,7.75,null,null,null,"Cardiff","ºC",6.75,6.5,7.5,9.5,13,16,18,18,16.5,13.5,10,7.75]
[null,"Edinburgh","ºC",5.75,5.5,6.5,8.5,12,15,17,17,15.5,12.5,9,6.75,null,null,null,"Edinburgh","ºC",5.75,5.5,6.5,8.5,12,15,17,17,15.5,12.5,9,6.75]
[null,"Glasgow","ºC",5.75,5.5,6.5,8.5,12,15,17,17,15.5,12.5,9,6.75,null,null,null,"Glasgow","ºC",5.75,5.5,6.5,8.5,12,15,17,17,15.5,12.5,9,6.75]
[null,"Leeds","ºC",5.75,5.5,6.5,8.5,12,15,17,17,15.5,12.5,9,6.75,null,null,null,"Leeds","ºC",5.75,5.5,6.5,8.5,12,15,17,17,15.5,12.5,9,6.75]
[null,"London","ºC",7.75,7.5,8.5,10.5,14,17,19,19,17.5,14.5,11,8.75,null,null,null,"London","ºC",7.75,7.5,8.5,10.5,14,17,19,19,17.5,14.5,11,8.75]
[null,"Manchester","ºC",6.75,6.5,7.5,9.5,13,16,18,18,16.5,13.5,10,7.75,null,null,null,"Manchester","ºC",6.75,6.5,7.5,9.5,13,16,18,18,16.5,13.5,10,7.75]
[null,"Newcastle","ºC",4.75,4.5,5.5,7.5,11,14,16,16,14.5,11.5,8,5.75,null,null,null,"Newcastle","ºC",4.75,4.5,5.5,7.5,11,14,16,16,14.5,11.5,8,5.75]
[null,"Nottingham","ºC",6.75,6.5,7.5,9.5,13,16,18,18,16.5,13.5,10,7.75,null,null,null,"Nottingham","ºC",6.75,6.5,7.5,9.5,13,16,18,18,16.5,13.5,10,7.75]
[null,"Plymouth","ºC",8.75,8.5,9.5,11.5,15,18,20,20,18.5,15.5,12,9.75,null,null,null,"Plymouth","ºC",8.75,8.5,9.5,11.5,15,18,20,20,18.5,15.5,12,9.75]
[null,"Southampton","ºC",8.75,8.5,9.5,11.5,15,18,20,20,18.5,15.5,12,9.75,null,null,null,"Southampton","ºC",8.75,8.5,9.5,11.5,15,18,20,20,18.5,15.5,12,9.75]
[null,"Swindon","ºC",8.75,8.5,9.5,11.5,15,18,20,20,18.5,15.5,12,9.75,null,null,null,"Swindon","ºC",8.75,8.5,9.5,11.5,15,18,20,20,18.5,15.5,12,9.75]

{"sheet":"Non PI Calculator","index":7,"n_rows":178,"n_cols":5,"rows_kept":178,"cut":false,"hidden":false,"merged":[[15,2,15,3],[20,2,20,3],[25,2,25,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3]]}
[]
[null,"Before filling in this sheet, please read the"]
[null,"HLC Guide"]
[]
[null,"Renewable Heat Incentive"]
[null,"Calculation of Heat Losses from all 'Non-Properly Insulated' pipe lengths."]
[]
[null,null,null,null,"Belfast"]
[null,null,null,null,"Birmingham"]
[null,null,null,null,"Cardiff"]
[null,"Location:",null,null,"Edinburgh"]
[null,null,null,null,"Glasgow"]
[null,null,null,null,"Leeds"]
[null,null,null,null,"London"]
[null,"User Defined Insulation 1",null,null,"Manchester"]
[null,"Name:",null,null,"Newcastle"]
[null,"Conductivity (Flow):",null,"W/mK","Nottingham"]
[null,"Conductivity (Return):",null,"W/mK","Plymouth"]
[null,null,null,null,"Southampton"]
[null,"User Defined Insulation 2",null,null,"Manchester"]
[null,"Name:",null,null,"Newcastle"]
[null,"Conductivity (Flow):",null,"W/mK","Nottingham"]
[null,"Conductivity (Return):",null,"W/mK","Plymouth"]
[null,null,null,null,"Southampton"]
[null,"User Defined Insulation 3"]
[null,"Name:"]
[null,"Conductivity (Flow):",null,"W/mK"]
[null,"Conductivity (Return):",null,"W/mK"]
[]
[null,"Use these buttons to add"]
[null,"and delete a column for each","column count start with col E",{"$f":"COUNTA(E89:E89)","v":1}]
[null,"external pipe run."]
[null,"Projected Annual Generation","kWh"]
[]
[null,"Distribution System Details"]
[null,"Pipe Sections","Units","Total"]
[null,"Section Name","-","-","Example"]
[null,"Flow or Return?","-","-","Flow"]
[null,"Length","m",{"$f":"SUMIF(OFFSET(E39,0,1,1,$D$31),\"<>#n/a\",OFFSET(E39,0,1,1,$D$31))","v":0},1000]
[null,"Is the pipe length pre-insulated or buried?\n(If yes please complete Row 54 below) ","-","-","No"]
[null,"Not Pre-insulated"]
[null,"Nominal Diameter","mm","-",40]
[null,"  Outside Diameter","mm","-","-"]
[null,"Insulation Type (select only for temperatures < 95oC)","-","-","85% Magnesia"]
[null,"Insulation Thickness","mm","-",25]
[null,"  User defined insulation thickness","mm","-","-"]
[null,"Surface Emissivity","-","-","Medium"]
[null,"External Condition","-","-","Exposed"]
[null,"  No. Valves","-",{"$f":"SUMIF(OFFSET(E49,0,1,1,$D$31),\"<>#n/a\",OFFSET(E49,0,1,1,$D$31))","v":0},1]
[null,"  Valves Insulated?","-","-","No"]
[null,"  No. Flanges","-",{"$f":"SUMIF(OFFSET(E51,0,1,1,$D$31),\"<>#n/a\",OFFSET(E51,0,1,1,$D$31))","v":0},1]
[null,"  Flanges Insulated?","-","-","No"]
[null,"Pre-insulated or buried"]
[null,"Heat Loss Rate for total cross-section of pipe","W/mK","-","-"]
[null,"Based on ground or air temperature?",null,null,"-"]
[null,null,null,null,true]
[null,"Fluid Temperature",null,"Outside Dia:",{"$f":"IF(E42<>\"User Defined o.d.\",VLOOKUP(E42,Reference!$B$4:$C$22,2,FALSE),'Non PI Calculator'!E43)","v":48.3}]
[null,"Month","Units","Total"]
[null,"January","ºC","-",80]
[null,"February","ºC","-",80]
[null,"March","ºC","-",80]
[null,"April","ºC","-",80]
[null,"May","ºC","-",80]
[null,"June","ºC","-",80]
[null,"July","ºC","-",80]
[null,"August","ºC","-",80]
[null,"September","ºC","-",80]
[null,"October","ºC","-",80]
[null,"November","ºC","-",80]
[null,"December","ºC","-",80]
[]
[null,"Operating Hours"]
[null,"Month","Units","Total"]
[null,"January","hrs","-",600]
[null,"February","hrs","-",550]
[null,"March","hrs","-",500]
[null,"April","hrs","-",450]
[null,"May","hrs","-",400]
[null,"June","hrs","-",350]
[null,"July","hrs","-",350]
[null,"August","hrs","-",400]
[null,"September","hrs","-",450]
[null,"October","hrs","-",500]
[null,"November","hrs","-",550]
[null,"December","hrs","-",600]
[]
[null,"Heat Loss Rates (W/K)"]
[null,"Pipe Sections","Units","Total"]
[null,"Pipe","W/K",{"$f":"SUMIF(OFFSET(E89,0,1,1,$D$31),\"<>#n/a\",OFFSET(E89,0,1,1,$D$31))","v":0},{"$f":"IF(E$40=\"Yes\",E$54*E$39,E39*PI()*(E57/1000)*(1/(((E57/1000)/(2*OFFSET(Reference!$S$25,MATCH(E44,Reference!$S$26:$S$31,0),MATCH(E38,Reference!$T$25:$U$25,0)))*LN((E57+(2*IF(E45=\"User Defined\",E46,E45) ))/E57))+(E57/(VLOOKUP(E48,Reference!$S$36:$V$37,IF(E47=\"High\",2,IF(E47=\"Low\",4,3)),FALSE)*(E57+(2*IF(E45=\"User Defined\",E46,E45))))))))","v":509.967381173197}]
[null,"Valves","W/K",{"$f":"SUMIF(OFFSET(E90,0,1,1,$D$31),\"<>#n/a\",OFFSET(E90,0,1,1,$D$31))","v":0},{"$f":"IF(E40=\"No\",IF(E49>0,E49*IF(E50=\"Yes\",0,5*(E57/1000)*PI()*(E57/1000)*VLOOKUP(E48,Reference!$B$36:$E$37,IF(E47=\"High\",2,IF(E47=\"Low\",4,3)),FALSE)),0),0)","v":0.65960910770697823}]
[null,"Flanges","W/K",{"$f":"SUMIF(OFFSET(E91,0,1,1,$D$31),\"<>#n/a\",OFFSET(E91,0,1,1,$D$31))","v":0},{"$f":"IF(E40=\"No\",IF(E51>0,E51*IF(E52=\"Yes\",0,1.5*(E57/1000)*PI()*(E57/1000)*VLOOKUP(E48,Reference!$B$36:$E$37,IF(E47=\"High\",2,IF(E47=\"Low\",4,3)),FALSE)),0),0)","v":0.19788273231209344}]
[]
[null,"Monthly Heat Losses"]
[null,"Month","Units","Total"]
[null,"January","kWh",{"$f":"SUMIF(OFFSET(E95,0,1,1,$D$31),\"<>#n/a\",OFFSET(E95,0,1,1,$D$31))","v":0},{"$f":"IF(E$55=\"Ground\",SUM(E$89:E$91)*(E59-Reference!$U$63)*E74*0.001,SUM(E$89:E$91)*(E59-Reference!$U$46)*E74*0.001)","v":{"$error":"#N/A"}}]
[null,"February","kWh",0,{"$f":"IF(E$55=\"Ground\",SUM(E$89:E$91)*(E60-Reference!$V$63)*E75*0.001,SUM(E$89:E$91)*(E60-Reference!$V$46)*E75*0.001)","v":{"$error":"#N/A"}}]
[null,"March","kWh",0,{"$f":"IF(E$55=\"Ground\",SUM(E$89:E$91)*(E61-Reference!$W$63)*E76*0.001,SUM(E$89:E$91)*(E61-Reference!$W$46)*E76*0.001)","v":{"$error":"#N/A"}}]
[null,"April","kWh",0,{"$f":"IF(E$55=\"Ground\",SUM(E$89:E$91)*(E62-Reference!$X$63)*E77*0.001,SUM(E$89:E$91)*(E62-Reference!$X$46)*E77*0.001)","v":{"$error":"#N/A"}}]
[null,"May","kWh",0,{"$f":"IF(E$55=\"Ground\",SUM(E$89:E$91)*(E63-Reference!$Y$63)*E78*0.001,SUM(E$89:E$91)*(E63-Reference!$Y$46)*E78*0.001)","v":{"$error":"#N/A"}}]
[null,"June","kWh",0,{"$f":"IF(E$55=\"Ground\",SUM(E$89:E$91)*(E64-Reference!$Z$63)*E79*0.001,SUM(E$89:E$91)*(E64-Reference!$Z$46)*E79*0.001)","v":{"$error":"#N/A"}}]
[null,"July","kWh",0,{"$f":"IF(E$55=\"Ground\",SUM(E$89:E$91)*(E65-Reference!$AA$63)*E80*0.001,SUM(E$89:E$91)*(E65-Reference!$AA$46)*E80*0.001)","v":{"$error":"#N/A"}}]
[null,"August","kWh",0,{"$f":"IF(E$55=\"Ground\",SUM(E$89:E$91)*(E66-Reference!$AB$63)*E81*0.001,SUM(E$89:E$91)*(E66-Reference!$AB$46)*E81*0.001)","v":{"$error":"#N/A"}}]
[null,"September","kWh",0,{"$f":"IF(E$55=\"Ground\",SUM(E$89:E$91)*(E67-Reference!$AC$63)*E82*0.001,SUM(E$89:E$91)*(E67-Reference!$AC$46)*E82*0.001)","v":{"$error":"#N/A"}}]
[null,"October","kWh",0,{"$f":"IF(E$55=\"Ground\",SUM(E$89:E$91)*(E68-Reference!$AD$63)*E83*0.001,SUM(E$89:E$91)*(E68-Reference!$AD$46)*E83*0.001)","v":{"$error":"#N/A"}}]
[null,"November","kWh",0,{"$f":"IF(E$55=\"Ground\",SUM(E$89:E$91)*(E69-Reference!$AE$63)*E84*0.001,SUM(E$89:E$91)*(E69-Reference!$AE$46)*E84*0.001)","v":{"$error":"#N/A"}}]
[null,"December","kWh",{"$f":"SUMIF(OFFSET(E106,0,1,1,$D$31),\"<>#n/a\",OFFSET(E106,0,1,1,$D$31))","v":0},{"$f":"IF(E$55=\"Ground\",SUM(E$89:E$91)*(E70-Reference!$AF$63)*E85*0.001,SUM(E$89:E$91)*(E70-Reference!$AF$46)*E85*0.001)","v":{"$error":"#N/A"}}]
[]
[null,"Quaterly Heat Losses"]
[null,"Period","Units","Total"]
[null,"January - March","kWh",{"$f":"SUM(D95:D97)","v":0}]
[null,"April - June","kWh",{"$f":"SUM(D98:D100)","v":0}]
[null,"July - September","KWh",{"$f":"SUM(D101:D103)","v":0}]
[null,"October - December","kWh",{"$f":"SUM(D104:D106)","v":0}]
[]
[null,"Annual Heat Loss","kWh",{"$f":"SUM(D95:D106)","v":0}]
[]
[]
[]
[]
[null,"Flow"]
[null,"Return"]
[null,"DUO"]
[null,"Exposed"]
[null,"Buried"]
[]
[null,"Yes"]
[null,"No"]
[]
[null,{"$f":"Reference!S26","v":"Glass Fibre"}]
[null,{"$f":"Reference!S27","v":"Mineral Wool"}]
[null,{"$f":"Reference!S28","v":"85% Magnesia"}]
[null,{"$f":"Reference!S29","v":"Calcium Silicate"}]
[null,{"$f":"Reference!S30","v":""}]
[null,{"$f":"Reference!S31","v":""}]
[null,{"$f":"Reference!S32","v":""}]
[null,{"$f":"Reference!S36","v":"Sheltered"}]
[null,{"$f":"Reference!S37","v":"Exposed"}]
[null,{"$f":"Reference!S32","v":""}]
[]
[null,"High"]
[null,"Medium"]
[null,"Low"]
[]
[null,"User Defined"]
[null,12.5]
[null,19]
[null,25]
[null,38]
[null,50]
[null,75]
[null,100]
[]
[null,"User Defined o.d."]
[null,{"$f":"Reference!S4","v":8}]
[null,{"$f":"Reference!S5","v":10}]
[null,{"$f":"Reference!S6","v":15}]
[null,{"$f":"Reference!S7","v":20}]
[null,{"$f":"Reference!S8","v":25}]
[null,{"$f":"Reference!S9","v":32}]
[null,{"$f":"Reference!S10","v":40}]
[null,{"$f":"Reference!S11","v":50}]
[null,{"$f":"Reference!S12","v":65}]
[null,{"$f":"Reference!S13","v":80}]
[null,{"$f":"Reference!S14","v":90}]
[null,{"$f":"Reference!S15","v":100}]
[null,{"$f":"Reference!S16","v":125}]
[null,{"$f":"Reference!S17","v":150}]
[null,{"$f":"Reference!S18","v":175}]
[null,{"$f":"Reference!S19","v":200}]
[null,{"$f":"Reference!S20","v":222.5}]
[null,{"$f":"Reference!S21","v":250}]
[null,{"$f":"Reference!S22","v":300}]
[]
[null,"Ground"]
[null,"Air"]
[]
[]
[null,"Delete"]

{"sheet":"Storage Tanks","index":8,"n_rows":142,"n_cols":5,"rows_kept":142,"cut":false,"hidden":false,"merged":[[15,2,15,3],[20,2,20,3],[25,2,25,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3]]}
[]
[null,"Before filling in this sheet, please read the"]
[null,"HLC Guide"]
[]
[null,"Renewable Heat Incentive"]
[null,"Calculation of Heat Losses from External Storage Tanks."]
[null,null,null,null,"Belfast"]
[null,null,null,null,"Birmingham"]
[null,null,null,null,"Cardiff"]
[null,null,null,null,"Edinburgh"]
[null,"Location:",null,null,"Glasgow"]
[null,null,null,null,"Leeds"]
[null,null,null,null,"London"]
[null,null,null,null,"Manchester"]
[null,"User Defined Insulation 1",null,null,"Newcastle"]
[null,"Name:",null,null,"Nottingham"]
[null,"Conductivity:",null,"W/mK","Plymouth"]
[null,null,null,null,"Southampton"]
[]
[null,"User Defined Insulation 2"]
[null,"Name:"]
[null,"Conductivity:",null,"W/mK"]
[]
[]
[null,"User Defined Insulation 3"]
[null,"Name:"]
[null,"Conductivity:",null,"W/mK"]
[]
[]
[null,"Use these buttons to add"]
[null,"and delete a storage tank."]
[null,null,null,{"$f":"COUNTA(E76:E76)","v":1}]
[null,"Storage Tank Details"]
[null,"Tank Dimensions","Units","Total"]
[null,"Is the tank cylindrical?","-","-","Yes"]
[null,"Height","m","-",1.8]
[null,"Internal Diameter","m","-",0.5]
[null,"Internal Surface Area","m²","-","-"]
[null,"Insulation Properties"]
[null,"Insulation Type","-","-","85% Magnesia"]
[null,"Insulation Thickness","mm","-",12.5]
[null,"  User defined insulation thickness","mm","-","-"]
[null,"External Condition","-","-","Sheltered"]
[]
[null,"Fluid Temperature"]
[null,"Month","Units","Total"]
[null,"January","ºC","-",80]
[null,"February","ºC","-",80]
[null,"March","ºC","-",80]
[null,"April","ºC","-",80]
[null,"May","ºC","-",80]
[null,"June","ºC","-",80]
[null,"July","ºC","-",80]
[null,"August","ºC","-",80]
[null,"September","ºC","-",80]
[null,"October","ºC","-",80]
[null,"November","ºC","-",80]
[null,"December","ºC","-",80]
[]
[null,"Operating Hours"]
[null,"Month","Units","Total"]
[null,"January","hrs","-",600]
[null,"February","hrs","-",550]
[null,"March","hrs","-",500]
[null,"April","hrs","-",450]
[null,"May","hrs","-",400]
[null,"June","hrs","-",350]
[null,"July","hrs","-",350]
[null,"August","hrs","-",400]
[null,"September","hrs","-",450]
[null,"October","hrs","-",500]
[null,"November","hrs","-",550]
[null,"December","hrs","-",600]
[]
[null,"Heat Loss Rates (W/K)"]
[null,"Tanks","W/K",{"$f":"SUMIF(OFFSET(E76,0,1,1,$D$32),\"<>#n/a\",OFFSET(E76,0,1,1,$D$32))","v":0},{"$f":"IF(E35=\"Yes\",E108+E109,E110)","v":12.879479156418233}]
[]
[null,"Monthly Heat Losses"]
[null,"Month","Units","Total"]
[null,"January","kWh",{"$f":"SUMIF(OFFSET(E80,0,1,1,$D$32),\"<>#n/a\",OFFSET(E80,0,1,1,$D$32))","v":0},{"$f":"E$76*(E47-Reference!$AL$46)*E62*0.001","v":{"$error":"#N/A"}}]
[null,"February","kWh",{"$f":"SUMIF(OFFSET(E81,0,1,1,$D$32),\"<>#n/a\",OFFSET(E81,0,1,1,$D$32))","v":0},{"$f":"E$76*(E48-Reference!$AM$46)*E63*0.001","v":{"$error":"#N/A"}}]
[null,"March","kWh",0,{"$f":"E$76*(E49-Reference!$AN$46)*E64*0.001","v":{"$error":"#N/A"}}]
[null,"April","kWh",0,{"$f":"E$76*(E50-Reference!$AO$46)*E65*0.001","v":{"$error":"#N/A"}}]
[null,"May","kWh",0,{"$f":"E$76*(E51-Reference!$AP$46)*E66*0.001","v":{"$error":"#N/A"}}]
[null,"June","kWh",0,{"$f":"E$76*(E52-Reference!AQ$46)*E67*0.001","v":{"$error":"#N/A"}}]
[null,"July","kWh",0,{"$f":"E$76*(E53-Reference!$AR$46)*E68*0.001","v":{"$error":"#N/A"}}]
[null,"August","kWh",0,{"$f":"E$76*(E54-Reference!$AS$46)*E69*0.001","v":{"$error":"#N/A"}}]
[null,"September","kWh",0,{"$f":"E$76*(E55-Reference!$AT$46)*E70*0.001","v":{"$error":"#N/A"}}]
[null,"October","kWh",0,{"$f":"E$76*(E56-Reference!$AU$46)*E71*0.001","v":{"$error":"#N/A"}}]
[null,"November","kWh",0,{"$f":"E$76*(E57-Reference!$AV$46)*E72*0.001","v":{"$error":"#N/A"}}]
[null,"December","kWh",0,{"$f":"E$76*(E58-Reference!$AW$46)*E73*0.001","v":{"$error":"#N/A"}}]
[]
[null,"Quaterly Heat Losses"]
[null,"Period","Units","Total"]
[null,"January - March","kWh",{"$f":"SUM(D80:D82)","v":0}]
[null,"April - June","kWh",{"$f":"SUM(D83:D85)","v":0}]
[null,"July - September","KWh",{"$f":"SUM(D86:D88)","v":0}]
[null,"October - December","kWh",{"$f":"SUM(D89:D91)","v":0}]
[]
[null,"Annual Heat Loss","kWh",{"$f":"SUM(D80:D91)","v":0}]
[]
[null,null,null,null,{"$f":"E36*PI()*E37","v":2.8274333882308138}]
[null,null,null,null,{"$f":"(2*PI()*(E37/2)^2)","v":0.39269908169872414}]
[null,null,null,null,{"$f":"IF(E41=$B$129,E42,E41)","v":12.5}]
[null,"Flow",null,null,{"$f":"OFFSET(Reference!$AJ$25,MATCH(E40,Reference!$AJ$26:$AJ$32,0),1)","v":6.3500000000000001E-2}]
[null,"Return",null,null,{"$f":"VLOOKUP(E43,Reference!$AJ$36:$AN$37,5,FALSE)","v":16.7}]
[null,"DUO",null,null,{"$f":"(E37)/(2*E105)*LN((E37+(2*E104*0.001))/E37)","v":0.192087260509575}]
[null,"Exposed",null,null,{"$f":"E103*(1/((1/E106)+(E104*0.001/E105)))","v":1.5296152109730468}]
[null,"Buried",null,null,{"$f":"(PI()*E36*E37)/(E107+(E37)/(E106*(E37+(2*E104*0.001))))","v":11.349863945445186}]
[null,null,null,null,{"$f":"E38*(1/((1/E106)+(E104*0.001/E105)))","v":{"$error":"#VALUE!"}}]
[null,"Yes"]
[null,"No"]
[]
[null,"Glass Fibre"]
[null,"Mineral Wool"]
[null,"85% Magnesia"]
[null,"Calcium Silicate"]
[null,{"$f":"Reference!AN30","v":""}]
[null,{"$f":"Reference!AN31","v":""}]
[null,{"$f":"Reference!AN32","v":""}]
[]
[null,"Sheltered"]
[null,"Exposed"]
[]
[null,"High"]
[null,"Medium"]
[null,"Low"]
[]
[null,"User Defined"]
[null,12.5]
[null,19]
[null,25]
[null,38]
[null,50]
[null,75]
[null,100]
[]
[null,"Ground"]
[null,"Air"]
[]
[]
[null,"Delete"]

{"sheet":"Results","index":9,"n_rows":56,"n_cols":6,"rows_kept":56,"cut":false,"hidden":false,"merged":[[48,1,48,5],[56,1,60,17],[49,1,49,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[53,1,53,2],[54,1,54,2],[55,1,55,2],[0,0,1,17],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[3,1,9,5],[2,1,2,5],[14,1,14,5],[33,1,38,2],[33,3,33,4],[38,3,38,5],[23,1,23,2],[26,1,26,5],[27,1,27,5],[30,1,32,2],[30,3,30,4],[31,3,31,5],[32,3,32,5],[61,0,371,14],[28,1,29,2],[28,3,28,4],[29,3,29,5],[18,1,18,5],[19,1,19,2],[19,3,19,5],[20,1,20,5],[21,1,21,2],[22,1,22,2],[2,0,60,0],[2,6,55,17],[39,1,44,2],[39,3,39,4],[44,3,44,5],[47,1,47,5]]}
[]
[]
[null,"Results of heat loss calculation for 'properly insulated' pipe lengths >10m"]
[]
[]
[]
[]
[]
[]
[]
[null,1,null,"AUTOMATIC CALCULATION. Total calculated average annual heat loss from all individual 'properly insulated' pipe lengths >10m (kWhth).",{"$f":"'PI Calculator'!D115","v":0},"Automatically populated upon completion of the \"PI Calculator\"."]
[null,2,null,"Projected annual heat output from the plant (kWhth)",{"$f":"'PI Calculator'!D33","v":0},"Automatically populated upon completion of the \"PI Calculator\"."]
[null,3,null,"AUTOMATIC CALCULATION. The calculated % of average annual heat loss from all individual 'properly insulated' pipe lengths >10m compared with the plant's projected annual heat output (kWhth):",{"$f":"IFERROR(E11/E12,0)","v":0},{"$f":"IF(E13<0.03,\"As the figure calculated is <3% these losses will be disregarded.\",\"As the figure calculated is >3% you should note that these losses will be deducted from periodic support payments.\")","v":"As the figure calculated is <3% these losses will be disregarded."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Heat Loss Assessment Results"]
[]
[null,"a",null,"Average annual heat lost from 'Non Properly Insulated' pipe lengths (kWhth) and external storage tanks",{"$f":"SUM('Non PI Calculator'!D115,'Storage Tanks'!D100)","v":0},"For Example: '6058'. NB - Do NOT type 'kWhth' after the number."]
[null,"b",null,"Average annual heat loss from 'Properly Insulated' pipe lengths >10m (kWth)",{"$f":"IF(E13<=0.03,\"\",'PI Calculator'!D115)","v":""},"For Example: '112603'. NB - Do NOT type 'kWhth' after the number."]
[null,"c",null,"Projected annual heat output (kWhth)",{"$f":"'Non PI Calculator'!D33","v":0}]
[null,"d",null,"Total average annual heat loss from all 'Non Properly Insulated' pipe lengths, 'Properly Insulated' pipe lengths >10m (kWth) and external storage tanks.",{"$f":"SUM(E50,E51)","v":0}]
[null,"e",null,"AUTOMATIC CALCULATION. The calculated % of average annual heat loss from the Heat Loss Calculator for 'Non Properly Insulated' pipework compared with the plant's projected annual heat output (kWhth)",{"$f":"IF(AND(E50<>0,E52<>0),E50/E52,0)","v":0},"This will automatically calcuate the percentage. If the figure calculated is >6% it will need an internal assessment by Ofgem."]
[null,"f",null,"Heat loss calculation",{"$f":"IF(AND(E50<>0,E52<>0),IF(E54<0.06,\"Approved\",\"Heat loss case needs an internal assessment\"),\"\")","v":""}]
[null,"g",null,"AUTOMATIC CALCULATION. Quarterly heat loss figure (QHLF) (kWhth)",{"$f":"E53/4","v":0},"Enter this figure into Question HH123-3 of the IT Register.                                                         "]

{"sheet":"HLC Guide","index":10,"n_rows":57,"n_cols":11,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Quick User Guide"]
[]
[null,"The following colour-coding indicates the type of data field:",null,null,"Required = ",null,null,"Complete = ",null,null,"Optional = "]
[]
[null,"Step 1: Description"]
[null,"Details of the installation should be entered in the 'Description' worksheet. The 'Location' should be selected from the available regions using the drop down list. "]
[null,"Optionally, a 'User Defined Insulation' maybe specified. This requires a 'Name' and conductivities associated with both flow and return temperatures."]
[]
[null,"Step 2: Calculator"]
[null,"The annual pipework heat loss is displayed at the bottom of the 'Calculator' worksheet."]
[null,"To add a pipe section, click the 'Add' button to automatically create another column."]
[null,"To remove a pipe section, select the column, right-click and select the 'Delete' menu item."]
[null,"Please note that the 'Nominal Diameter' drop down list values are for steel pipe taken from BS:3600."]
[null,"To enter pipe sizes or pipe types described by other standards please use the 'Outside Diameter' field."]
[null,"For buried or plastic pipe sections, the 'Outside Diameter' and the 'External Heat Loss Rate' must be specified."]
[]
[null,"The following parameters are required:"]
[]
[null,"Flow or Return?","- Identify whether this pipe section is part of the flow or return pipework."]
[null,"Length","- Enter the length of the pipe section (m)."]
[null,"Nominal Diameter","- Select either the nominal diameter (mm) or 'User Defined o.d.' to enter the measured outside diameter (mm)."]
[null,"Outside Diameter","- When applicable, enter the measured outside diameter (mm)."]
[null,"Insulation Type","- Select the insulation type. If a 'User Defined Insulation' has been defined it will be available on the drop down list."]
[null,"Insulation Thickness","- Select the insulation thickness (mm)."]
[null,"Surface Emissivity","- Select the insulation surface emissivity."]
[null,"External Condition","- Select the external condition adjacent to the pipe section."]
[null,"Buried Pipework?","- Identify whether the pipe section is buried."]
[null,"Ext. Heat Loss Rate","- When buried or plastic pipe section, provide the external heat loss rate (W/mK)."]
[null,"No. Valves","- Enter the number of valves."]
[null,"Valves Insulated?","- Identify if the valves are insulated."]
[null,"No. Flanges","- Enter the number of flanges."]
[null,"Flanges Insulated?","- Identify if the flanges are insulated."]
[null,"Fluid Temperature","- Monthly fluid temperature."]
[null,"Operating Hours","- Monthly hours of operation."]
[]
[null,"The heat loss calculation is taken from CIBSE Guide C (eqa. 3.111), where the heat exchange per metre length is:"]
[]
[]
[]
[]
[]
[null,"The thermal resistance of insulation is (eqa. 3.113) is:"]
[]
[]
[]
[]
[null,"The full list of parameters include:"]
[]
[null,"don = outside diameter of insulation (m)"]
[null,"dop = outside diameter of pipe (m)"]
[null,"hso = outside surface heat transfer coefficient (W.m-2.K-1)"]
[null,"kn = thermal conductivity of insulation (W.m-1.K-1)"]
[null,"Rn = thermal resistance of insulation  (m2.K.W-1)"]
[null,"ta = air temperature (ºC)"]
[null,"ts = surface temperature (ºC)"]