{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Titles","InputData","Calc","DTQ","Results","Crisscross","TradeOffData","Curves","Grid","data","manual","Sheet1"],"not_rendered":{"charts":12,"images":3,"macros":1,"external_links":0,"defined_names":80,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Titles","index":0,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[[6,2,6,6]]}
[]
[]
[]
[]
[]
[]
[null,null,"Heat Integration Analysis"]
[]
[]
[]
[null,null,null,"Client     :","Pinchco"]
[]
[null,null,null,"Project  :",{"$f":"IF(InputData!C2<>\"\",InputData!C2,\" \")","v":"Example process"}]
[]
[null,null,null,"Process:",{"$f":"IF(InputData!C3<>\"\",InputData!C3,\" \")","v":"Gundersen & Grossmann"}]
[]
[null,null,null,"Version :",{"$f":"IF(InputData!C4<>\"\",InputData!C4,\" \")","v":"Basic"}]
[]
[null,null,null,"Date       :",{"$f":"NOW()","v":"2015-10-15T21:02:44.930"}]
[]
[null,null,null,"Author  :"," D. Declercq"]

{"sheet":"InputData","index":1,"n_rows":118,"n_cols":21,"rows_kept":118,"cut":false,"hidden":false,"merged":[[0,1,0,9],[2,2,2,4],[1,2,1,4],[3,2,3,4]]}
[null,"Inputdata process",null,null,null,null,null,null,null,null,null,null,null,null,"Inputdata financial"]
[null,"Project  :","Example process",null,null,null,null,null,null,null,null,null,null,"Cost units factor : 1 or 1000",null,null,1000]
[null,"Process","Gundersen & Grossmann",null,null,"Consider Threshold - Yes or No ?",null,null,"Yes",null,"Commands",null,null,"Cost Units",null,null,"€"]
[null,"Version : ","Basic",null,null,"Pinch manually set - Yes or No ?",null,null,"Yes"]
[null,null,null,null,null,"if mode not P, Pinch set for Stream N°",null,null,6,null,null,null,null,"Utility prices","Hot",{"$f":"CONCATENATE(\"€\",\"/\",$D$6,\"h\")","v":"€/kWh"},4.07E-2]
[null,"Units ","Heat","kW",null,"# of Streams",{"$f":"MAX(B17:B116)","v":8},"Grid ?","No",null,null,null,null,null,"Cold",{"$f":"CONCATENATE(\"€\",\"/\",$D$6,\"h\")","v":"€/kWh"},8.6E-3]
[null,null,"Temp","°C",null,"Integration Mode B, P, M, CC, T",null,null,"B",null,null,null,null,null,"Annual escalation","%",0,null,"Data input : "]
[null,null,"DeltaT","K",null,"Integration applied",null,4000,{"$f":"D6","v":"kW"},null,null,null,null,"Investment related cost",null,null,null,null,"in this sheet 'InputData' or"]
[null,null,"U*f",{"$f":"CONCATENATE(D6,\"/\",D10,\",\",D8)","v":"kW/m²,K"},null,"Heating range min/max",null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"HEX cost formula (\",Q3,\") = A+B*Area^c\")","v":"HEX cost formula (€) = A+B*Area^c"},null,null,null,null,"in sheet 'data' using 'Input'"]
[null,null,"Area","m²",null,"Shift streamN°/Step(K)",null,null,null,null,null,null,null,null,null,"A =",20000,null,"for data input:"]
[null,null,"Cost",{"$f":"CONCATENATE(IF(Q2=1,\" \",\"*000 \"),Q3)","v":"*000 €"},null,"Shift range min/max",null,null,null,null,null,null,null,null,null,"B =",480,null,null,"use button 'Input'"]
[null,null,null,null,null,null,null,"Suggested new shift",null,null,null,null,null,null,null,"c =",0.81,null,null,null,"or 'Ctrl + i' shortcut "]
[null,"Stream Data",null,null,null,null,null,null,null,null,null,null,null,null,null,"Lang-factor",1,null,"for calculation:"]
[null,"N°","Tsupply","Ttarget","Heat","Shift","U*f","Description","mcp","H or C","TsupplyS","TtargetS",null,null,null,"Annual O&M cost as % of Investm",0,null,null,"use button 'Run'"]
[null,null,{"$f":"D7","v":"°C"},{"$f":"D7","v":"°C"},{"$f":"D6","v":"kW"},{"$f":"D8","v":"K"},{"$f":"CONCATENATE(D6,\"/\",D10,\",\",D8)","v":"kW/m²,K"},"-",{"$f":"CONCATENATE(D6,\"/\",D8)","v":"kW/K"},"-",{"$f":"D7","v":"°C"},{"$f":"D7","v":"°C"},null,null,null,"O&M cost escalation",0,null,null,null,"or 'Ctrl+d' shortcut "]
[null,"--------------------------------------------------------------------------------------------------------------------",null,null,null,null,null,null,"---------------------------","---------","---------","---------",null,{"$f":"CONCATENATE(\"Heat exchanger area limit (\",D10,\")\")","v":"Heat exchanger area limit (m²)"},null,null,5000]
[null,1,300,200,1000,10,0.1,"H1",{"$f":"IF(B17<>\"\",E17/(D17-C17),\"\")","v":-10},{"$f":"IF(B17<>\"\",IF(D17>C17,\"C\",\"H\"),\"\")","v":"H"},{"$f":"IF(J17=\"H\",C17-F17,IF(J17=\"C\",C17+F17,\"\"))","v":290},{"$f":"IF(J17=\"H\",D17-F17,IF(J17=\"C\",D17+F17,\"\"))","v":190},null,"Operating hours",null,"h/year",8000,null,"Description for utilities :"]
[null,{"$f":"IF(C18<>\"\",B17+1,\"\")","v":2},200,190,1000,10,1,"H2",-100,"H",{"$f":"IF(J18=\"H\",C18-F18,IF(J18=\"C\",C18+F18,\"\"))","v":190},{"$f":"IF(J18=\"H\",D18-F18,IF(J18=\"C\",D18+F18,\"\"))","v":180},null,"Project Lifetime",null,"years",10,null,"Hot Utility : Heating"]
[null,{"$f":"IF(C19<>\"\",B18+1,\"\")","v":3},190,170,1000,10,1,"H3",-50,"H",180,160,null,"Discount rate",null,"%",0.15,null,"Cold utility : Cooling"]
[null,{"$f":"IF(C20<>\"\",B19+1,\"\")","v":4},160,180,1000,10,0.1,"C1",{"$f":"IF(B20<>\"\",E20/(D20-C20),\"\")","v":50},{"$f":"IF(B20<>\"\",IF(D20>C20,\"C\",\"H\"),\"\")","v":"C"},{"$f":"IF(J20=\"H\",C20-F20,IF(J20=\"C\",C20+F20,\"\"))","v":170},{"$f":"IF(J20=\"H\",D20-F20,IF(J20=\"C\",D20+F20,\"\"))","v":190},null,null,"Discount summation factor"]
[null,{"$f":"IF(C21<>\"\",B20+1,\"\")","v":5},180,190,1000,10,1,"C2",100,"C",190,200,null,"Annual utility cost multiplier",null,null,{"$f":"IF(Q19-Q7=0,Q18,(1-1/POWER(1+Q19-Q7,Q18))/(Q19-Q7))","v":5.0187686258542277}]
[null,{"$f":"IF(C22<>\"\",B21+1,\"\")","v":6},190,230,1000,10,1,"C3",{"$f":"IF(B22<>\"\",E22/(D22-C22),\"\")","v":25},{"$f":"IF(B22<>\"\",IF(D22>C22,\"C\",\"H\"),\"\")","v":"C"},{"$f":"IF(J22=\"H\",C22-F22,IF(J22=\"C\",C22+F22,\"\"))","v":200},{"$f":"IF(J22=\"H\",D22-F22,IF(J22=\"C\",D22+F22,\"\"))","v":240},null,"NPV O&M cost to add to Investment",null,null,{"$f":"Q14*IF(Q19-Q15=0,Q18,(1-1/POWER(1+Q19-Q15,Q18))/(Q19-Q15))","v":0}]
[null,{"$f":"IF(C23<>\"\",B22+1,\"\")","v":7},350.01,350,1000,null,4,"Heating",{"$f":"IF(B23<>\"\",E23/(D23-C23),\"\")","v":-100000.00000009095},"H",350.01,350]
[null,{"$f":"IF(C24<>\"\",B23+1,\"\")","v":8},30,50,1000,null,2,"Cooling",50,"C",30,50]
[null,{"$f":"IF(C25<>\"\",B24+1,\"\")","v":""},null,null,null,null,null,null,"","","","",null,"Comments"]
[null,"",null,null,null,null,null,null,"","","",""]
[null,"",null,null,null,null,null,null,"","","",""]
[null,{"$f":"IF(C28<>\"\",B27+1,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(B28<>\"\",E28/(D28-C28),\"\")","v":""},{"$f":"IF(B28<>\"\",IF(D28>C28,\"C\",\"H\"),\"\")","v":""},{"$f":"IF(J28=\"H\",C28-F28,IF(J28=\"C\",C28+F28,\"\"))","v":""},{"$f":"IF(J28=\"H\",D28-F28,IF(J28=\"C\",D28+F28,\"\"))","v":""}]
[null,{"$f":"IF(C29<>\"\",B28+1,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(B29<>\"\",E29/(D29-C29),\"\")","v":""},{"$f":"IF(B29<>\"\",IF(D29>C29,\"C\",\"H\"),\"\")","v":""},{"$f":"IF(J29=\"H\",C29-F29,IF(J29=\"C\",C29+F29,\"\"))","v":""},{"$f":"IF(J29=\"H\",D29-F29,IF(J29=\"C\",D29+F29,\"\"))","v":""}]
[null,{"$f":"IF(C30<>\"\",B29+1,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(B30<>\"\",E30/(D30-C30),\"\")","v":""},{"$f":"IF(B30<>\"\",IF(D30>C30,\"C\",\"H\"),\"\")","v":""},{"$f":"IF(J30=\"H\",C30-F30,IF(J30=\"C\",C30+F30,\"\"))","v":""},{"$f":"IF(J30=\"H\",D30-F30,IF(J30=\"C\",D30+F30,\"\"))","v":""}]
[null,"",null,null,null,null,null,null,"",{"$f":"IF(B31<>\"\",IF(D31>C31,\"C\",\"H\"),\"\")","v":""},"",""]
[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,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,null,"","","",""]
[null,"",null,null,null,null,null,null,"","","",""]
[null,"",null,null,null,null,null,null,"","","",""]
[null,"",null,null,null,null,null,null,{"$f":"IF(B49<>\"\",E49/(D49-C49),\"\")","v":""},"","",""]
[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,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,"",{"$f":"IF(B62<>\"\",IF(D62>C62,\"C\",\"H\"),\"\")","v":""},"",""]
[null,"",null,null,null,null,null,null,"","","",""]
[null,{"$f":"IF(C64<>\"\",B63+1,\"\")","v":""},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,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,"","","",""]
[null,"",null,null,null,null,null,null,"","","",""]
[null,"",null,null,null,null,null,null,"","","",""]
[null,"",null,null,null,null,null,null,{"$f":"IF(B81<>\"\",E81/(D81-C81),\"\")","v":""},"","",""]
[null,"",null,null,null,null,null,null,"","",{"$f":"IF(J82=\"H\",C82-F82,IF(J82=\"C\",C82+F82,\"\"))","v":""},{"$f":"IF(J82=\"H\",D82-F82,IF(J82=\"C\",D82+F82,\"\"))","v":""}]
[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,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,"",{"$f":"IF(B94<>\"\",IF(D94>C94,\"C\",\"H\"),\"\")","v":""},"",""]
[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,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,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,"Reserve blanc line"]
[null,"-------------------------------------------------------------------------------------------------------------------------------------"]

{"sheet":"Calc","index":2,"n_rows":116,"n_cols":82,"rows_kept":116,"cut":false,"hidden":true,"merged":[]}
[null,"Inputdata process",null,null,null,"Calculations",null,null,null,null,null,null,null,"CCShift","CCArea","Exergy Loss","Anergy Hot","Anergy Cold",null,"Summary",null,null,"TLevel","HotBase","HotCurve","ColdBase","ColdCurve","QHot",4000,null,"Balanced System",null,null,"Potential",null,"Transfer1","Transfer2","Transfer3","Transfer4",null,null,null,null,null,null,null,"Inputdata Units",null,null,null,"Inputdata financial",null,null,null,null,"TLevel","LevelN°","mcpHot","mcpCold","DHHot","DHCold","Balance","Cascade",null,"QS","THotS","TColdS",null,"DeltaQS","AreaS","AreaSum","DTS","DTHotS","DTColdS",null,null,"Hrange","Crange","Area","Energy","Capital","Total"]
[null,"Project :",{"$f":"Titles!E13","v":"Example process"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Problem Type :","Balanced System",null,null,350.01,null,4000,null,4000,"QCold",4000,null,"Shift Hot curve",4000,null,0,null,null,null,null,null,1,null,null,null,null,null,null,"Heat","Temperature",null,"Cost units factor : 1 or 1000",null,null,1000,null,null,350.01,1,null,null,null,null,0,0,null,4000,null,350.01,null,null,null,null,null,null,null,null,null,17000,24720,33835.376291133733,7373.1840000000002,8595.22544845634,15968.409448456339]
[null,"Process:",{"$f":"Titles!E15","v":"Gundersen & Grossmann"},null,null,"Consider Threshold - Yes or No ?",null,null,"Yes",null,null,null,null,null,null,null,null,null,null,"Level","Temp","Flow",350,null,3000,0,4000,"QHot+QCold",8000,null,"Shift Cold curve",4000,null,1000,null,"Project",null,"Example process",null,2,null,null,null,null,"B","Yes","kW","°C",null,"Cost Units",null,null,"€",null,null,350,2,-100000.00000009095,0,1000,0,1000,1000,null,4000,350.01,240,null,null,null,null,110.00999999999999,null,null,null,null,17500,25220,31440.974335761872,7574.7839999999997,8082.2375557351643,15657.021555735164]
[null,"Version :",{"$f":"Titles!E17","v":"Basic"},null,null,"Pinch manually set - Yes or No ?",null,null,"Yes",null,null,null,null,null,null,null,null,null,null,"N°","°C","kW",290,null,3000,0,4000,null,null,null,"Optimum shift",4000,null,1000,null,"Process",null,"Gundersen & Grossmann",null,3,null,null,null,null,"P","No","MW","K",null,null,null,null,null,null,null,290,3,0,0,0,0,1000,1000,null,3000,350,200,null,1000,null,null,150,110.00999999999999,150,null,null,18000,25720,29426.236519207425,7776.384,7646.4324984727118,15422.816498472712]
[null,null,null,null,null,"if Manual mode, Pinch set for Stream N°",null,null,6,null,null,null,null,null,null,null,null,null,"Pinch",5,200,0,240,null,2500,0,4000,null,null,null,"Max. integration",4000,null,1500,null,"Version",null,"Basic",null,4,null,null,null,null,"M",null,"MJ/h",null,null,"Utility prices","Hot","€/kWh",4.07E-2,null,null,240,4,-10,0,500,0,1500,1500,null,3000,290,200,null,0,null,null,90,null,null,null,null,18500,26220,27705.328097708516,7977.9840000000004,7270.9149212453131,15248.898921245313]
[null,"Units","Heat","kW",null,"Number of Streams",8,"Grid ?","No",null,null,null,null,null,null,null,null,null,"Pinch caused by stream N#",null,6,null,200,null,2100,-1000,3000,null,null,null,"Applied integration",4000,null,900,null,"Units Heat","UnHeat","kW",null,5,null,null,null,null,null,null,"GJ/h",null,null,null,"Cold","€/kWh",8.6E-3,null,null,200,5,-10,25,400,1000,900,900,null,2500,240,195,null,500,null,null,45,90,45,null,null,19000,26720,26217.189502343164,8179.5839999999998,6943.566327208885,15123.150327208885]
[null,null,"Temp","°C",null,"Integration Mode B, P, M, CC, T",null,null,"B",null,null,null,null,null,null,null,null,null,null,null,null,null,190,null,2000,-2000,2000,null,null,null,"Further potential",0,null,0,null,"Units Temperature/Temp.Difference","UnTemp,UnTempDiff","°C","K",6,null,null,null,null,null,null,null,null,null,null,"Annual escalation","%",0,null,null,190,6,-10,100,100,1000,0,0,null,2100,200,191,null,400,null,null,9,45,9,null,null,19500,27220,24917.009327360698,8381.1839999999993,6655.4246447182986,15036.608644718297]
[null,null,"DeltaT","K",null,"Integration applied",null,3000,"kW",null,null,null,null,null,null,null,null,null,null,"Hot","Cold",null,180,null,1000,-2500,1500,null,null,null,null,null,null,500,null,"Units Cost","UnCost","*000 €",null,7,null,null,null,null,null,null,null,null,null,"Investment related cost",null,null,null,null,null,180,7,-100,50,1000,500,500,500,null,2000,190,190,null,100,null,null,0,9,0,null,null,20000,27720,23771.04822167127,8582.7839999999997,6399.693644234394,14982.477644234394]
[null,null,"U","kW/m²,K",null,"Heating range min/max",null,null,null,null,null,null,null,null,null,null,null,null,null,"kW","kW",null,170,null,500,-3000,1000,null,null,null,null,null,null,500,null,"Comment","Text","Pinch caused by stream N#",null,8,null,null,null,null,null,null,null,null,null,"HEX cost formula (€) = A+B*Area^c",null,null,null,null,null,170,8,-50,50,500,500,500,500,null,1500,185,180,null,500,null,null,5,0,5,null,null,20500,28220,22753.353576466412,8784.384,6171.1101596395492,14955.494159639549]
[null,null,"Area","m²",null,"Shift streamN°/Step(K)",null,null,null,null,"for Data change :",null,null,null,null,null,null,null,"Total Heat",4000,4000,null,160,null,0,-3000,1000,null,null,null,null,null,null,1000,null,"Problem Type","character","Balanced System",null,9,null,null,null,null,null,null,null,null,null,null,null,"A =",20000,null,null,160,9,-50,0,500,0,1000,1000,null,1000,180,170,null,500,null,null,10,5,10,null,null,21000,28720,21843.595893361802,8985.9840000000004,5965.5248682085785,14951.508868208579]
[null,null,"Cost","*000 €",null,"Shift range min/max",null,null,null,null,"back to 'InputData'",null,null,null,null,null,null,null,"Targets",0,0,null,50,null,0,-3000,1000,null,null,null,null,null,null,1000,null,"Consider Threshold,Modus","ConsidThresh,Modus","Yes","B",10,null,null,null,null,null,null,null,null,null,null,null,"B =",480,null,null,50,10,0,0,0,0,1000,1000,null,1000,180,50,null,0,null,null,130,null,null,null,null,21500,29220,21025.598880666057,9187.5840000000007,5779.6158927177785,14967.199892717779]
[null,null,null,null,null,null,null,"Suggested new shift",null,null,null,null,null,null,null,null,null,null,"Curves Shift",4000,4000,null,30,null,0,-4000,0,null,null,null,null,null,null,0,null,"Sort Status/Manual Pinch","StatusHC/PMSet","NotSorted","Yes",11,null,null,null,null,null,null,null,null,null,null,null,"c =",0.81,null,null,30,11,0,50,0,1000,0,0,null,500,170,40,null,500,null,null,130,130,130,null,null,22000,29720,20286.243096778722,9389.1839999999993,5536.124924790447,14925.308924790446]
[null,"Stream Data",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,"Units Surface area/Heat transfer","UnA, UnU","m²","kW/m²,K",12,null,null,null,null,null,null,null,null,null,null,null,"Lang-factor",1,null,null,null,null,null,null,null,null,null,null,null,0,160,30,null,500,null,null,130,130,130,null,null,22500,30220,19615.019827684031,9590.7839999999997,5433.9733704687787,15024.757370468778]
[null,"N°","Tsupply","Ttarget","Heat","Shift","U*f","Description","mcp","H or C","TsupplyS","TtargetS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Units mcp","Unmcp","kW/K",null,13,null,null,null,null,null,null,null,null,null,null,null,"Annual O&M cost as % of Investm",0,null,null,null,null,null,null,null,null,null,null,null,0,null,30,null,null,null,null,null,null,null,null,null,23000,30720,19003.196653618565,9792.384,5293.7385997229521,15086.122599722952]
[null,null,"°C","°C","kW","K","kW/m²,K","-","kW/K","-","°C","°C",null,null,null,null,null,null,null,"Temperature Range",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of Hot/Cold streams","NSH,NSC",4,4,14,null,null,null,null,null,null,null,null,null,null,null,"O&M cost escalation",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23500,31220,18443.313186777941,9993.9840000000004,5164.87684081103,15158.86084081103]
[null,{"$f":"REPT(\"-\",120)","v":"------------------------------------------------------------------------------------------------------------------------"},null,null,null,null,null,null,"---------------------------","---------",null,{"$f":"REPT(\"-\",25)","v":"-------------------------"},null,null,null,null,null,null,null,"Hot","Cold",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N# of streams","NS",8,null,15,null,null,null,null,null,null,null,null,null,"Heat exchanger area limit (m²)",null,null,5000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24000,31720,17929.138667706015,10195.583999999999,5046.0654980120134,15241.649498012011]
[null,1,300,200,1000,10,0.1,"H1",-10,"H",290,190,null,null,null,null,null,null,"from Level",1,11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N# of Temp.Levels","NL",11,11,16,null,null,null,null,null,null,null,null,null,"Operating hours",null,"h/year",8000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24500,32220,17455.422361066343,10397.184000000001,4936.1862449463833,15333.370244946385]
[null,2,200,190,1000,10,1,"H2",-100,"H",190,180,null,null,null,null,null,null,"to Level",9,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Level Hot Str. Max","LTHMax",1,1,17,null,null,null,null,null,null,null,null,null,"Project Lifetime",null,"years",10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25000,32720,17017.703427293396,10598.784,4834.2858093039113,15433.06980930391]
[null,3,190,170,1000,10,1,"H3",-50,"H",180,160,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Level HotStr. Min","LTHMin",9,8,18,null,null,null,null,null,null,null,null,null,"Discount rate",null,"%",0.15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25500,33220,16612.164439021471,10800.384,4739.5457054330691,15539.929705433069]
[null,4,160,180,1000,10,0.1,"C1",50,"C",170,190,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Level Cold Str. Min","LTCMin",11,11,19,null,null,null,null,null,null,null,null,null,null,"Discount summation factor",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,26000,33720,16235.517034866622,11001.984,4651.2585637940711,15653.242563794072]
[null,5,180,190,1000,10,1,"C2",100,"C",190,200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Level Cold Str. Max","LTCMax",4,4,20,null,null,null,null,null,null,null,null,null,"Annual utility cost multiplier",null,null,5.0187686258542277,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26500,34220,15884.911610702518,11203.583999999999,4568.8094010245095,15772.393401024508]
[null,6,190,230,1000,10,1,"C3",25,"C",200,240,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pinch stream Number,HorC","PinchStream,PSHC",6,"C",21,null,null,null,null,null,null,null,null,null,"NPV O&M cost to add to Investment",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,27000,34720,15557.86524260059,11405.184000000001,4491.6606423727517,15896.844642372753]
[null,7,350.01,350,1000,null,4,"Heating",-100000.00000009095,"H",350.01,350,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pinch Temp.Shifted,Unshifted","PinchTemp,PinchTempNS",200,190,22]
[null,8,30,50,1000,null,2,"Cooling",50,"C",30,50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q-value Pinch,location on Q-axis","QvPinchS,QlocS",3000,3,23]
[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,"Max.Int.Pot., Int. Set value","MaxInt,SetInt",4000,3000,24]
[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,"Integration Applied,Pinchflow","AppliedInt,PinchFlow",4000,0,25]
[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,"Total Q Hot,Total Q cold","SumHot,SumCold",4000,4000,26]
[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,"Max.Temp. Hot Str.","THMax,RTHMax",350.01,350.01,27]
[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,"Min.Temp. Hot Str.","THMin,RTHMin",160,170,28]
[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,"Min.Temp. Cold Str.","TCMin,RTCMin",30,30,29]
[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,"Max.Temp. Cold Str.","TCMax,RTCMax",240,230,30]
[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,"Minimum Heating/Cooling","TargetHot,TargetCold",0,0,31]
[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,"Shift Cold curve,Optimum Shift","ShiftCold,OptShiftC",4000,4000,32]
[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,"N# of Q values,NQV with Criss-cros","NQV,NQVS",12,13,33]
[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,"Target Surface area,Units Limit","Area, UnLimit",null,5000,34]
[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,"Target Area above/below pinch","AreaA,AreaB",null,null,35]
[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,"N# of streams above/below Pinch","NSAP,NSBP",2,6,36]
[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,"Actual Heating/Cooling","ActHot, ActCold",0,0,37]
[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,"Utility Input Heating,Cooling","HotUtilIn,ColdUtilIn",1000,1000,38]
[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,"N# of units above/below Pinch","NUAP, NUBP",1,5,39]
[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,"PinchStreamN# manual/HorC","PinchNSM/PSMHC",6,"C",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,null,null,null,null,null,null,null,"Cost scale factor","CSF",1000,null,41]
[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,"Utility prices Hot/Cold","PHot, PCold",4.07E-2,8.6E-3,42]
[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,"HE Cost formula A,B","HEA, HEB",20000,480,43]
[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,"HE Cost formula c","HEc",0.81,null,44]
[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,"Lang factor, Maintenance %","Lang, Maintenrate",1,0,45]
[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,"Escalation Energy/Maintenance","EscU, EscM",0,0,46]
[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,"Operating hours, Lifetime","Hours, Life",8000,10,47]
[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,"Discount rate","Disc",0.15,null,48]
[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,"N° to Shift/Shiftstep","NtoShift, Shiftstep",0,null,49]
[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,"PinchLevel/PinchTempManual","PinchLevel/PinchTempM",5,200,50]
[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,"AreaSA/AreaSB","AreaSA/AreaSB",null,null,51]
[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,"AreaS Sum","AreaSSum",null,null,52]
[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,"DT0 at Pinch","DT0Pinch",150,null,53]
[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,"# of Runs","Runs",null,null,54]
[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,"ECost/ICost","ECost/ICost",null,null,55]
[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,"ExergyHot/ExergyCold","AnerHot/AnerCold",1733.5939135812969,1203.472177551407,56]
[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,"Exergy Loss",null,530.12173602988992,null,57]
[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,58]
[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,"No",null,59]
[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,60]
[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,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,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,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,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,"",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,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,"",""]
[null,"",null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,null,"",""]

{"sheet":"DTQ","index":3,"n_rows":13,"n_cols":20,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[null,"RTLevel","RLevelN","RmcpH","RmcpC","RDHHot","RDHCold","RHotC","RColdC","RTLevel","Q","THot","TCold","DeltaT","DeltaQ","DeltaTH","DeltaTC","DTLnM","Area","Tot.Area"]
[null,350.01,1,null,null,null,null,4000,null,350.01,4000,350.01,230,120.00999999999999]
[null,350,2,-100000.00000009095,0,1000,0,3000,null,350,3250,350.0025,200,150.0025,750,120.00999999999999,150.0025,134.44915908364686]
[null,300,3,0,0,0,0,3000,null,300,3000,350,190,160,250,150.0025,160,154.94749895925611]
[null,230,4,-10,0,700,0,2300,4000,230,3000,300,190,110,0,160,110,133.44241826095308]
[null,200,5,-10,25,300,750,2000,3250,200,2300,230,183,47,700,110,47,74.088642306975984]
[null,190,6,-100,25,1000,250,1000,3000,190,2000,200,180,20,300,47,20,31.60055667337955]
[null,180,7,-50,100,500,1000,500,2000,180,1500,195,170,25,500,20,25,22.407100588622754]
[null,170,8,-50,50,500,500,0,1500,170,1000,190,160,30,500,25,30,27.424074738735392]
[null,160,9,0,50,0,500,null,1000,160,1000,190,50,140,0,30,140,71.407935418693057]
[null,50,10,0,0,0,0,null,1000,50,500,180,40,140,500,140,140,140]
[null,30,11,0,50,0,1000,null,0,30,0,170,30,140,500,140,140,140]
[null,null,null,null,null,null,null,null,null,null,0,null,30]

{"sheet":"Results","index":4,"n_rows":106,"n_cols":62,"rows_kept":106,"cut":false,"hidden":false,"merged":[[11,28,11,30],[1,1,1,6],[0,28,0,30],[1,28,1,30],[1,8,1,17],[1,18,1,21],[1,22,1,25]]}
[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,"Energy balance check"]
[null,"RESULTS",null,null,null,null,null,null,"Stream Data",null,null,null,null,null,null,null,null,null,"DT versus Q",null,null,null,"Surface Area",null,null,null,null,null,{"$f":"REPT(\"-\",53)","v":"-----------------------------------------------------"},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,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,null,null,"Total QHot",4000]
[null,"Problem Type :",null,null,"Balanced System",null,null,null,"N°","Tsupply","Ttarget","Heat","Shift","U*f","mcp","TPinch","H abv P","H below P","Q","THot","TCold","DeltaT","DeltaQ","DTHot","DTCold","Area",null,null,"Total QCold",4000]
[null,"Pinch Temperature Shifted/Unshifted :",null,null,200,190,"°C",null,null,"°C","°C","kW","K","kW/m²,K","kW/K","°C","kW","kW","kW","°C","°C","K","kW","K","K","m²",null,null,"Total",null,8000]
[null,"Pinch caused by stream N#",null,null,"Balanced System","C",null,null,{"$f":"REPT(\"-\",90)","v":"------------------------------------------------------------------------------------------"},null,null,null,null,null,null,null,null,{"$f":"REPT(\"-\",90)","v":"------------------------------------------------------------------------------------------"},{"$f":"REPT(\"-\",92)","v":"--------------------------------------------------------------------------------------------"},null,null,null,null,null,null,{"$f":"REPT(\"-\",92)","v":"--------------------------------------------------------------------------------------------"},null,null,"Heat above Pinch",2000]
[null,"Minimum Heating / Cooling :",null,null,0,0,"kW",null,1,300,200,1000,10,0.1,-10,null,null,1000,4000,350.01,230,120.00999999999999,null,null,null,null,null,null,"Heat below Pinch",6000]
[null,"Actual required Heating / Cooling :",null,null,0,0,"kW",null,2,200,190,1000,10,1,-100,null,null,1000,3250,350.0025,200,150.0025,750,120.00999999999999,150.0025,null,null,null,"Total",null,8000]
[null,"InputUtil.Hot/Cold",null,null,1000,1000,"kW",null,3,190,170,1000,10,1,-50,null,null,1000,3000,350,190,160,250,150.0025,160]
[null,"Target Integration/ remaining Potential :",null,null,4000,0,"kW",null,4,160,180,1000,10,0.1,50,null,null,1000,3000,300,190,110,0,160,110,null,null,null,null,"Exergy balance"]
[null,"Number of Hot streams/Cold streams :",null,null,4,4,null,null,5,180,190,1000,10,1,100,190,null,1000,2300,230,183,47,700,110,47,null,null,null,null,"Integrated section"]
[null,"Number of streams above/below Pinch :",null,null,2,6,null,null,6,190,230,1000,10,1,25,190,1000,null,2000,200,180,20,300,47,20,null,null,null,{"$f":"REPT(\"-\",53)","v":"-----------------------------------------------------"}]
[null,"Target # units above/below Pinch :",null,null,1,5,null,null,7,350.01,350,1000,null,4,-100000.00000009095,350,1000,null,1500,195,170,25,500,20,25,null,null,null,"Exergy Hot streams",null,1733.5939135812969]
[null,"Feasible # units above/below Pinch :",null,null,1,5,null,null,8,30,50,1000,null,2,50,null,null,1000,1000,190,160,30,500,25,30,null,null,null,"Exergy Cold streams",null,1203.472177551407]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,1000,190,50,140,0,30,140,null,null,null,"Exergy Loss",null,530.12173602988992]
[null,null,null,"Total","Above Pinch","Below Pinch",null,null,"",null,null,null,null,null,"",null,null,null,500,180,40,140,500,140,140]
[null,"HEX area (vertical):",null,null,null,null,"m²",null,"",null,null,null,null,null,"",null,null,null,0,170,30,140,500,140,140]
[null,"HEX area (criss-cross):",null,null,null,null,"m²",null,"",null,null,null,null,null,"",null,null,null,0,null,30]
[null,"Cost NPV Utilities :",null,1979.4023460369071,1634.1110645781364,345.29128145877087,"*000 €",null,"",null,null,null,null,null,""]
[null,"Cost NPV Investment :",null,null,null,null,"*000 €",null,"",null,null,null,null,null,""]
[null,"Total Cost NPV :",null,null,null,null,"*000 €",null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,"Integration Potential",null,null,null,null,"",null,null,null,null,null,""]
[null,null,"Level","Temp","Value",null,null,null,"",null,null,null,null,null,""]
[null,null,"N°","°C","kW",null,null,null,"",null,null,null,null,null,""]
[null,null,{"$f":"REPT(\"-\",42)","v":"------------------------------------------"},null,{"$f":"REPT(\"-\",42)","v":"------------------------------------------"},null,null,null,"",null,null,null,null,null,""]
[null,null,1,350.01,0,null,null,null,"",null,null,null,null,null,""]
[null,null,2,350,1000,null,null,null,"",null,null,null,null,null,""]
[null,null,3,290,1000,null,null,null,"",null,null,null,null,null,""]
[null,null,4,240,1500,null,null,null,"",null,null,null,null,null,""]
[null,null,5,200,900,null,null,null,"",null,null,null,null,null,""]
[null,null,6,190,0,null,null,null,"",null,null,null,null,null,""]
[null,null,7,180,500,null,null,null,"",null,null,null,null,null,""]
[null,null,8,170,500,null,null,null,"",null,null,null,null,null,""]
[null,null,9,160,1000,null,null,null,"",null,null,null,null,null,""]
[null,null,10,50,1000,null,null,null,"",null,null,null,null,null,""]
[null,null,11,30,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,""]

{"sheet":"Crisscross","index":5,"n_rows":4,"n_cols":45,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,"Stream N°","CCShift","CCArea",null,"Stream N°","CCShift","CCArea",null,"Stream N°","CCShift","CCArea",null,"Stream N°","CCShift","CCArea",null,"Stream N°","CCShift","CCArea",null,"Stream N°","CCShift","CCArea",null,"Stream N°","CCShift","CCArea",null,"Stream N°","CCShift","CCArea",null,"Stream N°","CCShift","CCArea",null,"Stream N°","CCShift","CCArea"]
[]
[]
[null,"The Crisscross feature is not available in this version of Heatit"]

{"sheet":"TradeOffData","index":6,"n_rows":7,"n_cols":78,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Hrange","Crange","Area","Energy","Capital","Total",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,"QS","THotS","TColdS",null,"DeltaQS","AreaS","AreaSum","DTS","DTHotS","DTColdS"]
[null,"Heat","kW",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1333]
[null,"Cost","*000 €",null,null,null,null,null,null,null,null,"The Trade-off feature is not available in this version of Heatit",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,null,null,null,null,null,null,null,null,null,null,null,null,null,1433]
[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,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,1533]
[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,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,1633]
[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,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,1733]
[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,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,1833]

{"sheet":"Curves","index":7,"n_rows":4,"n_cols":63,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Heat","kW",null,null,null,null,null,null,null,"Heat","kW",null,null,null,null,null,null,null,"Heat","kW",null,null,null,null,null,null,null,"Heat","kW",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,-250]
[null,"Temp","°C",null,null,"Problem Type :","Balanced System",null,null,null,"Temp","°C",null,null,null,null,null,null,null,"Temp","°C",null,null,null,null,null,null,null,"Temp","°C"]
[null,"DT","K",null,null,null,null,null,null,null,"DT","K",null,null,null,null,null,null,null,"DT","K",null,null,null,null,null,null,null,"DT","K"]

{"sheet":"Grid","index":8,"n_rows":125,"n_cols":22,"rows_kept":125,"cut":false,"hidden":false,"merged":[]}
[null,"Process :",null,null,null,null,"Version :"]
[null,null,"Area","# HEX","Area Cost"]
[null,"Heatit",null,6,null,null,null,null,null,null,"QS",4000,null,3000,null,2000,null,1000,null,0]
[null,null,null,null,null,null,null,null,null,null,"THotS",350.01,null,350,null,200,null,190,null,170]
[null,null,null,null,null,null,null,null,null,null,"TColdS",230,null,190,null,180,null,160,null,30]
[]
[]
[]
[null,"N# of Hot streams",null,4]
[null,"N# of cold streams",null,4]
[null,"N# of bands",null,4]
[]
[]
[]
[]
[]
[null,"N°","Tsupply","Ttarget","Heat","HaboveP","Shift","Description","U*f","mcp","DeltaTS",120.00999999999999,null,160,null,20,null,30,null,140,"mcp","HbelowP"]
[null,null,"°C","°C","kW","kW","K","-","kW/m²,K","kW/K","DeltaQ",null,1000,null,1000,null,1000,null,1000,null,"kW/K","kW"]
[null,{"$f":"REPT(\"-\",120)","v":"------------------------------------------------------------------------------------------------------------------------"},null,null,null,null,null,null,null,{"$f":"REPT(\"-\",25)","v":"-------------------------"},null,1,null,2,null,3,null,4,null,null,"---------------------------"]
[null,7,350.01,350,1000,1000,null,"Heating",4,100000.00000009095,null,350.01,null,350,null," ",null," ",null,null,100000.00000009095]
[]
[null,1,300,200,1000,null,null,"H1",0.1,10,null," ",null,300,null,200,null," ",null,null,10,1000]
[]
[null,2,200,190,1000,null,null,"H2",1,100,null," ",null," ",null,200,null,190,null,null,100,1000]
[]
[null,3,190,170,1000,null,null,"H3",1,50,null," ",null," ",null," ",null,190,null,170,50,1000]
[]
[null,4,160,180,1000,null,null,"C1",0.1,50,null," ",null," ",null,180,null,160,null,null,50,1000]
[]
[null,5,180,190,1000,null,null,"C2",1,100,null," ",null,190,null,180,null," ",null,null,100,1000]
[]
[null,6,190,230,1000,1000,null,"C3",1,25,null,230,null,190,null," ",null," ",null,null,25]
[]
[null,8,30,50,1000,null,null,"Cooling",2,50,null," ",null," ",null," ",null,50,null,30,50,1000]
[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,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,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,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,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,"",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,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,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,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,""]
[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,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,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,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,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,"",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,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,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,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,""]
[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,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,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,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,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,"",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,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,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,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,""]
[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,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,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,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,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,""]

{"sheet":"data","index":9,"n_rows":188,"n_cols":54,"rows_kept":188,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Example Problem Small plant",null,null,null,null,null,null,"Gundersen and Grossmann 'Classic'",null,null,null,null,null,null,"double pinch",null,null,null,null,null,null,null,"Shenoy (4S1)",null,null,null,null,null,null,null,"Zhu",null,null,null,null,null,null,"Castillo",null,null,null,null,null,null,null,null,"Drying tunnel",null,"Data set 1"]
[null,"Tsupply","Ttarget","Heat","DTMin","U*f","Description",null,"Tsupply","Ttarget","Heat","DT-shift","U*f","Descript.",null,"Tsupply","Ttarget","Heat","DTMin","U*f","Description",null,null,"Tsupply","Ttarget","Heat","DTMin","U*f","Description",null,null,"Tsupply","Ttarget","Heat","DT-shift","U*f","Descript.",null,"Tsupply","Ttarget","Heat","DT-shift","U*f","Descript.",null,null,null,"Tsupply","Ttarget","Heat","DTMin","U*f","Description","mcp"]
[null,"°C","°C","MW","K","MW/K,m²","-",null,"°C","°C","MW","K","MW/K,m²","-",null,"°C","°C","kW","K","kW/K,m²","-",null,null,"°C","°C","kW","K","kW/K,m²","-",null,null,"°C","°C","kW","K","kW/K,m²","-",null,"°C","°C","kW","K","kW/K,m²","-",null,null,null,"°C","°C","kW","K","kW/K,m²","-"]
[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,33.9,58.8,83.81,7,0.05,"air in",3.3660000000000001]
[null,245,30,86,5,2,"H1",null,300,200,1000,10,0.1,"H1",null,255,55,2800,5,1,"H1",null,null,175,45,1300,null,0.2,"H1",null,null,150,50,20000,null,0.2,"H1",null,840,40,3991.52,5,1.5,"H1",null,null,null,58.8,122.8,193.28,7,0.05,"air in",3.02]
[null,195,95,100,5,2,"H2",null,200,190,1000,10,1,"H2",null,195,65,2600,5,1,"H2",null,null,125,65,2400,null,0.2,"H2",null,null,170,40,13000,null,0.2,"H2",null,76,45,145.20400000000001,5,1.5,"H2",null,null,null,122.8,270.2,445.15,7,0.05,"air in",3.02]
[null,30,180,90,5,2,"C1",null,190,170,1000,10,1,"H3",null,95,110,1800,5,1,"C1",null,null,20,155,2700,null,0.2,"C1",null,null,50,120,21000,null,0.2,"C1",null,50,40,7.72,5,1.5,"H3",null,null,null,270.2,353,250.06,7,0.05,"air in",3.02]
[null,125,200,120,5,2,"C2",null,160,180,1000,10,0.1,"C1",null,55,175,1200,5,1,"C2",null,null,40,112,1080,null,0.2,"C2",null,null,80,110,15000,null,0.2,"C2",null,180,77,62.799100000000003,5,1.5,"H4",null,null,null,525,223.7,444.72,7,0.05,"CHP flue gas",1.476]
[null,200.01,200,null,null,2,"Heating",null,180,190,1000,10,1,"C2",null,150,200,2000,5,1,"C3",null,null,180,179,350,null,0.2,"Heating",null,null,180.01,180,null,null,0.2,"Heating",null,180,179,292.7,5,0.8,"H5",null,null,null,223.7,135.9,129.58000000000001,0,0.05,"CHP flue gas",1.476]
[null,10,10.01,null,null,2,"Cooling",null,190,230,1000,10,1,"C3",null,200.01,200,220,5,1,"Heating",null,null,15,25,270,null,0.2,"Cooling",null,null,20,40,null,null,0.2,"Cooling",null,90,45,137.97,5,1.5,"H6",null,null,null,122,135.9,129.58000000000001,0,0.05,"off gas",9.3219999999999992]
[null,null,null,null,null,null,null,null,350.01,350,null,null,4,"Heating",null,110.01,110,480,5,1,"Heating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,25,329.8,5,0.8,"C1",null,null,null,135.9,118,193.28,7,0.05,"off gas + flue gas",10.798]
[null,"Example Problem Large plant classic",null,null,null,null,null,null,30,50,null,null,2,"Cooling",null,10,15,1100,5,1,"Cooling",null,null,"Cost","A",30000,"Cost = 30000 + 750 x A exp 0.81",null,null,null,null,null,null,null,null,null,null,null,25,70,24.223500000000001,5,1.5,"C2",null,null,null,90,70,83.74,7,1,"Cooling water",4.1870000000000003]
[null,245,30,1720,5,2,"H1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B",750,"annuity = 0.3221",null,null,null,null,"Frausto-Hernandez",null,null,null,null,null,null,35,122,324.24899999999997,5,1.5,"C3"]
[null,195,95,2000,5,2,"H2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c",0.81,null,null,null,null,null,"Tsupply","Ttarget","Heat","DT-shift","U*f","Descript.",null,90,180,54.873000000000005,5,1.5,"C4",null,null,null,"Drying tunnel",null,"Data set 2"]
[null,30,180,1800,5,2,"C1",null,"Gundersen and Grossmann : input for minimum area",null,null,null,null,null,null,"hot stream above the pinch",null,null,"large",null,null,null,null,null,null,null,null,null,null,null,null,"°C","°C","kW","K","kW/K,m²","-",null,180,181,2581.1,5,0.8,"C5",null,null,null,"Tsupply","Ttarget","Heat","DTMin","U*f","Description","mcp"]
[null,125,200,2400,5,2,"C2",null,"Tsupply","Ttarget","Heat","DT-shift","U*f","Descript.",null,"Tsupply","Ttarget","Heat","DTMin","U*f","Comment",null,null,null,null,null,null,null,null,null,null,"------------------------------------------------------------------------------------------",null,null,null,null,null,null,50,235,null,5,1,"Water 30.6 bar",1.1587875471785671,"t/h",null,"°C","°C","kW","K","kW/K,m²","-"]
[null,220.01,220,null,5,4,"Heating",null,"°C","°C","MW","K","MW/K,m²","-",null,"°C","°C","kW","K","kW/K,m²","-",null,null,"Ravagnani variable Uf",null,null,null,null,null,null,null,175,45,1300,null,2.6150000000000002,"H1",null,235,240,null,5,1.5,"Steam 30.6 bar",1.1587875471785671,"t/h",null,33.9,353,963.68,7,0.05,"air in",3.02]
[null,10,10.01,null,5,1,"Cooling",null,"------------------------------------------------------------------------------------------------------",null,null,null,null,"------------------------------------------------------------------------------------------------------",null,"----------------------------------------------------------------------------------------------------",null,null,null,null,null,null,null,"Tsupply","Ttarget","Heat","DTMin","U*f","Description",null,null,125,65,2400,null,1.333,"H2",null,230.01,230,null,5,1.5,"Heating",null,null,null,122,90,298.3,7,0.05,"off gas",9.3219999999999992]
[null,null,null,null,null,null,null,null,300,200,1000,0,0.1,"H1",null,230,30,4000,0,2,"H1",null,null,"°C","°C","kW","K","kW/K,m²","-",null,null,20,155,2700,null,0.91700000000000004,"C1",null,20,40,null,5,0.8,"Cooling",null,null,null,525,90,642.05999999999995,7,0.05,"CHP flue gas",1.476]
[null,"Example Problem Large plant unequal U set 1",null,null,null,null,"series 1/3",null,200,190,1000,0,1,"H2",null,220,219,1000,27,0.1,"H2",null,null,"----------------------------------------------------------------------------------------",null,null,null,null,null,null,null,40,112,1080,null,0.1666,"C2",null,null,null,null,null,null,null,null,null,null,90,70,83.74,7,1,"Cooling water",4.1870000000000003]
[null,245,30,1720,10.6,0.2,"H1",null,190,170,1000,0,1,"H3",null,20,100,500,0,2,"C1",null,null,175,45,1300,0,2.6150000000000002,"H1",null,null,180,179,null,null,5,"Heating"]
[null,195,95,2000,1.1000000000000001,2,"H2",null,160,180,1000,30,0.1,"C1",null,100,200,4000,0,2,"C2",null,null,125,65,2400,1,1.333,"H2",null,null,15,25,null,null,2.5,"Cooling"]
[null,30,180,1800,9.5,0.2,"C1",null,180,190,1000,0,1,"C2",null,250.01,250,600,0,2,"Heating",null,null,20,155,2700,0,0.91700000000000004,"C1"]
[null,125,200,2400,0,2,"C2",null,190,230,1000,7,1,"C3",null,10,15,1100,0,2,"Cooling",null,null,40,112,1080,8,0.16600000000000001,"C2"]
[null,220.01,220,980,-15,4,"Heating",null,350.01,350,1000,0,4,"Heating",null,null,null,null,null,null,null,null,null,180,179,185,0,5,"Heating",null,null,"Rezaei"]
[null,10,10.01,500,0,1,"Cooling",null,30,50,1000,0,2,"Cooling",null,null,null,null,null,null,null,null,null,15,25,105,0,2.5,"Cooling",null,null,"Tsupply","Ttarget","Heat","DT-Shift","U*f","Descript"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"forbidden match",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"°C","°C","kW","K","kW/K,m²"]
[null,"Example Problem Large plant unequal U set 2",null,null,null,null,"series 2/3",null,null,null,null,null,null,null,null,"Tsupply","Ttarget","Heat","DTMin","U*f","Comment",null,null,"Cost","A",0,null,null,null,null,null,"---------------------------------------------------------------------------------------"]
[null,245,30,1720,0,2,"H1",null,"Gundersen and Grossmann : input for minimum cost",null,null,null,null,null,null,"°C","°C","kW","K","kW/K,m²","-",null,null,null,"B",1200,null,null,null,null,null,280,60,6600,10,0.2,"H1"]
[null,195,95,2000,7.1,0.2,"H2",null,"Tsupply","Ttarget","Heat","DT-shift","U*f","Descript.",null,"----------------------------------------------------------------------------------------------------",null,null,null,null,null,null,null,null,"c",0.56999999999999995,null,null,null,null,null,180,20,7200,10,0.2,"H2"]
[null,30,180,1800,6.3,0.2,"C1",null,"°C","°C","MW","K","MW/K,m²","-",null,180,140,40,10,2,"H1",null,null,null,null,null,null,null,null,null,null,100,200,4000,10,0.2,"C1"]
[null,125,200,2400,0,2,"C2",null,"------------------------------------------------------------------------------------------------------",null,null,null,null,"------------------------------------------------------------------------------------------------------",null,220,170,40,10,2,"H2",null,null,null,null,null,null,null,null,null,null,120,260,8400,10,0.2,"C2"]
[null,220.01,220,980,-25,4,"Heating",null,300,200,1000,0,0.1,"H1",null,180,80,40,10,2,"H3",null,null,"Cooler on H1",null,null,null,null,null,null,null,300.10000000000002,300,4900,null,0.2,"Heating"]
[null,10,10.01,500,0,1,"Cooling",null,200,190,1000,0,1,"H2",null,40,120,56,10,2,"C1",null,null,"Tsupply","Ttarget","Heat","DTMin","U*f","Description",null,null,5,10,6300,null,0.2,"Cooling"]
[null,null,null,null,null,null,null,null,190,170,1000,0,1,"H3",null,150,220,84,10,2,"C2",null,null,"°C","°C","kW","K","kW/K,m²","-"]
[null,"Example Problem 1",null,null,null,null,null,null,160,180,1000,30,0.1,"C1",null,null,null,null,null,null,null,null,null,"----------------------------------------------------------------------------------------"]
[null,180,80,100,5,1,"H1",null,180,190,1000,0,1,"C2",null,null,null,null,null,null,null,null,null,175,55.5,1195,0,2.6150000000000002,"H1",null,null,"Hallberg"]
[null,130,40,180,5,1,"H2",null,190,230,1000,20,1,"C3",null,"pinch depending on heat transfer coefficient",null,null,null,"low C2",null,null,null,125,65,2400,1,1.333,"H2",null,null,"Tsupply","Ttarget","Heat","DT-Shift","U*f","Descript"]
[null,60,100,160,5,1,"C1",null,350.01,350,1000,0,4,"Heating",null,"Tsupply","Ttarget","Heat","DTMin","U*f","Comment",null,null,20,155,2700,0,0.91700000000000004,"C1",null,null,"°C","°C","kW","K","kW/K,m²","°C"]
[null,30,120,162,5,1,"C2",null,30,50,1000,0,2,"Cooling",null,"°C","°C","kW","K","kW/K,m²","-",null,null,40,112,1080,8,0.16600000000000001,"C2",null,null,"---------------------------------------------------------------------------------------"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"----------------------------------------------------------------------------------------------------",null,null,null,null,null,null,null,180,179,185,0,5,"Heating",null,null,159,77,18737,null,0.4,"H1"]
[null,"Fool proof test",null,null,null,null,null,null,null,null,null,null,null,null,null,245,30,4000,5,2,"H1",null,null,15,25,0,0,2.5,"Cooling",null,null,267,80,3814.7999999999997,2,0.3,"H2"]
[null,260,230,60,5,1,"H1",null,null,null,null,null,null,null,null,195,90,2000,5,2,"H2",null,null,null,null,null,null,null,null,null,null,343,90,13611.4,4,0.25,"H3"]
[null,180,130,100,5,1,"H2",null,null,null,null,null,null,null,null,30,180,2000,3,2,"C1",null,null,null,null,null,null,null,null,null,null,26,127,9423.2999999999993,12,0.15,"C1"]
[null,95,120,50,5,1,"C1",null,null,null,null,null,null,null,null,90,120,1500,15,0.1,"C2",null,null,"Cooler on H2",null,null,null,null,null,null,null,118,265,28826.7,0,0.5,"C2"]
[null,150,220,140,5,1,"C2",null,null,null,null,null,null,null,null,150,180,2400,3,2,"C3",null,null,"Tsupply","Ttarget","Heat","DTMin","U*f","Description",null,null,500,499,14000,null,0.53,"Heating"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,220.01,220,592.79999999999995,0,4,"Heating",null,null,"°C","°C","kW","K","kW/K,m²","-",null,null,20,40,null,null,0.53,"Cooling"]
[null,"Threshold examples",null,null,null,null,null,null,null,null,null,null,null,null,null,10,10.01,692.8,5,1,"Cooling",null,null,"----------------------------------------------------------------------------------------"]
[null,180,90,100,5,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,175,45,1300,0,2.6150000000000002,"H1"]
[null,10,110,50,5,1,"Thresh.HC-causeC",null,null,null,null,null,null,null,null,"pinch depending on heat transfer coefficient",null,null,null,"low C3",null,null,null,125,67.625,2295,1,1.333,"H2"]
[null,110,118,40,5,1,null,null,null,null,null,null,null,null,null,"Tsupply","Ttarget","Heat","DTMin","U*f","Comment",null,null,20,155,2700,0,0.91700000000000004,"C1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"°C","°C","kW","K","kW/K,m²","-",null,null,40,112,1080,8,0.16600000000000001,"C2"]
[null,180,80,160,5,1,2,null,null,null,null,null,null,null,null,"----------------------------------------------------------------------------------------------------",null,null,null,null,null,null,null,180,179,185,0,5,"Heating"]
[null,130,120,150,5,1,"Thresh.HC-causeH",null,null,null,null,null,null,null,null,245,30,4000,5,2,"H1",null,null,15,25,0,0,2.5,"Cooling"]
[null,30,130,270,5,1,null,null,null,null,null,null,null,null,null,195,90,2000,5,2,"H2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,180,2000,6,2,"C1"]
[null,160,80,90,5,1,3,null,null,null,null,null,null,null,null,90,120,1500,6,2,"C2"]
[null,0,100,50,5,1,"Thresh.HC-causeC",null,null,null,null,null,null,null,null,150,180,2400,20,0.1,"C3"]
[null,100,110,50,5,1,null,null,null,null,null,null,null,null,null,220.01,220,592.79999999999995,4,4,"Heating"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,10.01,692.8,5,1,"Cooling"]
[null,180,80,120,5,1,4]
[null,120,110,130,5,1,"Thresh.CH-causeH"]
[null,30,130,240,5,1]
[]
[null,160,50,250,5,1,5]
[null,20,100,30,5,1,"Thresh.H-causeC"]
[null,100,110,40,5,1]
[]
[null,170,60,330,5,1,6]
[null,150,30,180,5,1,"Thresh.H-No StreamPinch"]
[null,20,120,230,5,1]
[]
[null,140,80,100,5,1,7]
[null,20,100,70,5,1,"Thresh.C-causeC"]
[null,100,110,150,5,1]
[]
[null,190,90,70,5,1,8]
[null,110,100,130,5,1,"Thresh.C-causeH"]
[null,40,140,270,5,1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," "," "]

{"sheet":"manual","index":10,"n_rows":62,"n_cols":4,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[null,"How to use the code"]
[]
[null,"Commands"]
[null,null,"Use \"Input\" button or 'Ctrl+i' shortcut"]
[null,null,null,"to copy data from sheet 'data' into sheet 'InputData' after selection of data in 'data' sheet"]
[null,null,"Use \"Run\" button or 'Ctrl+d' shortcut"]
[null,null,null,"to run the code"]
[null,null,"Use 'Ctrl+e' shortcut"]
[null,null,null,"to set or change password for sheet protection "]
[]
[null,"Instructions"]
[null,null,"Data input exclusively in Sheet 'Inputdata' for process data and financials"]
[null,null,"General data should be entered into the green cells"]
[null,null,"Process stream data should be entered into the grey-framed area"]
[null,null,"For convenience, data can be prepared in the 'data' sheet and copied into the 'InputData' sheet using Input"]
[null,null,"Do not move data within the input area : either input directly into the cells or copy paste values"]
[null,null,"Cells shall not contain formula, only data will ensure correct calculation"]
[null,null,"First stream data should be entered on the first line"]
[null,null,"There should be no empty lines between stream data"]
[null,null,"Identical supply and target temperatures for a stream are not allowed"]
[null,null,"However, the difference can be as small as appropriate"]
[null,null,"The code is written for maximum 100 streams"]
[null,null,"Choose the integration mode in cell I7 : options - depending upon the version - are:"]
[null,null,null,"B = Balanced energy requirements are satisfied by the Utilities input "]
[null,null,null,"P = Pinched  "]
[null,null,null,"M = Manual with given integration"]
[null,null,null,"CC = crisscross calculation (depending upon version)"]
[null,null,null,"T = Trade-off calculation energy versus capital"]
[null,null,"For 'stop at the Threshold' : enter Yes in cell H9"]
[null,null,"For disregarding Thresholds : enter No in cell H9"]
[]
[null,"Comments"]
[null,null,"Sheets are protected before and after each run"]
[null,null,"To unprotect sheet : select \"unprotect\" with password"]
[null,null,"Password is blank at package delivery; it is optional to introduce a password upon activation"]
[null,null,"Be aware that unprotecting Sheets and changing content may disturb correct calculation "]
[null,null,"Sheet protection Password can be entered and changed with 'Ctrl + e'"]
[]
[null,"Process data input"]
[null,null,"Although not obligatory, it is advised to start with process streams only, without any utility streams "]
[null,null,"Utility streams can be introduced thereafter in order to calculate total cost"]
[null,null,"In such case, however, precautions should be taken to preserve the character of the problem"]
[null,null,"This can be done in two ways :"]
[null,null,"  1) by ensuring that the utility streams introduced do not cover the full utility demand "]
[null,null,"     To do so, utility loads can be put in that cover 99.999 % of the demand, but not the full 100 %  "]
[null,null,"  2) by using the manual pinch identification feature and imposing a stream as pinch stream"]
[null,null,"Maintaining the character of the problem is important when calculating the minimum number of units above and below the pinch"]
[null,null,"Heating utility is identified by the input \"Heating\" in the InputData sheet, Column G, \"Description\""]
[null,null,"Cooling utility is identified by the input \"Cooling\" in the InputData sheet, Column G, \"Description\""]
[null,null,"In the Results, utility loads put in as streams should be added to target and actual figures in order to obtain full target and actual figures"]
[null,null,"The program includes any utility input figures in the total utility requirements for cost calculations "]
[null,null,"The DTShift value is the value by which the stream position on the temperature axis is corrected for construction of the shifted curves  "]
[null,null,"Criss-cross heat exchange will be driven by different values for the DTShift"]
[]
[null,"Data input financial"]
[null,null,"Basis for total cost calculation analysis is NPV"]
[null,null,"Annual Utility cost = Utility consumption x operation hours x utility prices in first year, escalated "]
[null,null,"Utility cost NPV = cumulated annual utility cost discounted at discount rate"]
[null,null,"The annual utility cost multiplier is the factor which the utility cost in the first year is multiplied with to obtain the NPV of total utility cost over the lifetime of the project "]
[null,null,"Annual O&M cost = Operation and Maintenance cost expressed as a percentage of investment cost"]
[null,null,"O&M cost NPV = cumulated annual O&M cost discounted at discount rate"]
[null,null,"NPV O&M cost to add to Investment = the percentage to increase the investment cost with in order to include the NPV of Operation and Maintenance cost"]

{"sheet":"Sheet1","index":11,"n_rows":42,"n_cols":22,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["Example Gundersen & Grossmann"]
[null,"Classic"]
[null,"N°","Tsupply","Ttarget","Heat","HaboveP","Shift","Description","U*f","mcp","DeltaTS",120.00999999999999,null,160,null,20,null,30,null,140,"mcp","HbelowP"]
[null,null,"°C","°C","kW","kW","K","-","kW/m²,K","kW/K","DeltaQ",null,1000,null,1000,null,1000,null,1000,null,"kW/K","kW"]
[null,{"$f":"REPT(\"-\",120)","v":"------------------------------------------------------------------------------------------------------------------------"},null,null,null,null,null,null,null,{"$f":"REPT(\"-\",25)","v":"-------------------------"},null,1,null,2,null,3,null,4,null,null,"---------------------------"]
[null,7,350.01,350,1000,1000,null,"Heating",4,100000.00000009095,null,350.01,null,350,null," ",null," ",null,null,100000.00000009095]
[]
[null,1,300,200,1000,1000,null,"H1",0.1,10,null," ",null,300,null,200,null," ",null,null,10]
[]
[null,2,200,190,1000,null,null,"H2",1,100,null," ",null," ",null,200,null,190,null,null,100,1000]
[]
[null,3,190,170,1000,null,null,"H3",1,50,null," ",null," ",null," ",null,190,null,170,50,1000]
[]
[null,4,160,180,1000,null,null,"C1",0.1,50,null," ",null," ",null,180,null,160,null,null,50,1000]
[]
[null,5,180,190,1000,1000,null,"C2",1,100,null," ",null,190,null,180,null," ",null,null,100]
[]
[null,6,190,230,1000,1000,null,"C3",1,25,null,230,null,190,null," ",null," ",null,null,25]
[]
[null,8,30,50,1000,null,null,"Cooling",2,50,null," ",null," ",null," ",null,50,null,30,50,1000]
[]
[]
[]
[null,"With stream dependent shift contributions - crisscross optimisation for minimum cost"]
[null,"N°","Tsupply","Ttarget","Heat","HaboveP","Shift","Description","U*f","mcp","DeltaTS",100.00999999999999,null,140,null,10,null,10,null,140,"mcp","HbelowP"]
[null,null,"°C","°C","kW","kW","K","-","kW/m²,K","kW/K","DeltaQ",null,1000,null,1000,null,1000,null,1000,null,"kW/K","kW"]
[null,{"$f":"REPT(\"-\",120)","v":"------------------------------------------------------------------------------------------------------------------------"},null,null,null,null,null,null,null,{"$f":"REPT(\"-\",25)","v":"-------------------------"},null,1,null,2,null,3,null,4,null,null,"---------------------------"]
[null,7,350.01,350,1000,1000,null,"Heating",4,100000.00000009095,null,350.01,null,350,null," ",null," ",null,null,100000.00000009095]
[]
[null,1,300,200,1000,1000,null,"H1",0.1,10,null," ",null,300,null,200,null," ",null,null,10]
[]
[null,2,200,190,1000,null,null,"H2",1,100,null," ",null," ",null,200,null,190,null,null,100,1000]
[]
[null,3,190,170,1000,null,null,"H3",1,50,null," ",null," ",null," ",null,190,null,170,50,1000]
[]
[null,4,160,180,1000,1000,30,"C1",0.1,50,null," ",null,180,null,160,null,null,null,null,50]
[]
[null,5,180,190,1000,null,null,"C2",1,100,null," ",null,null,null,190,null,180,null,null,100,1000]
[]
[null,6,190,230,1000,1000,20,"C3",1,25,null,230,null,190,null," ",null," ",null,null,25]
[]
[null,8,30,50,1000,null,null,"Cooling",2,50,null," ",null," ",null," ",null,50,null,30,50,1000]