{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","CO2 calculation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Sheet1","index":0,"n_rows":28,"n_cols":15,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
["Isobutane",null,"R600a",null,null,null,null,null,null,null,"R600"]
[]
["Kritisk temperature",null,{"$f":"R_Tcrit(C2)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,{"$f":"R_Tcrit(K2)","v":{"$error":"#VALUE!"}}]
["Kritisk Trykk",null,{"$f":"R_Pcrit(C2)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,{"$f":"R_Pcrit(K2)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"kokepunkt","mettet","Fordampnings",null,null,null,null,null,"kokepunkt","mettet","Fordampnings"]
[null,null,null,"Væske","Gas","varme","gass",null,null,null,null,"Væske","Gas","varme","gass"]
[null,"Trykk","Temp","Entalpi","Entalpi","Entalpi","Entalpi",null,null,"Trykk","Temp","Entalpi","Entalpi","Entalpi","Entalpi"]
[null,{"$f":"R_PsatliqT($C$2,C10)","v":{"$error":"#VALUE!"}},{"$f":"134-1","v":133},{"$f":"R_hsatliqT($C$2,C10)","v":{"$error":"#VALUE!"}},{"$f":"R_hsatgasT($C$2,C10)","v":{"$error":"#VALUE!"}},{"$f":"E10-D10","v":{"$error":"#VALUE!"}},{"$f":"r_hgastp($C$2,C10,B10)","v":{"$error":"#VALUE!"}},{"$f":"r_hgastp($C$2,C10+10,B10)","v":{"$error":"#VALUE!"}},null,{"$f":"R_PsatliqT($K$2,K10)","v":{"$error":"#VALUE!"}},{"$f":"134-1","v":133},{"$f":"R_hsatliqT($K$2,K10)","v":{"$error":"#VALUE!"}},{"$f":"R_hsatgasT($K$2,K10)","v":{"$error":"#VALUE!"}},{"$f":"M10-L10","v":{"$error":"#VALUE!"}},{"$f":"r_hgastp($K$2,K10,J10)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"R_PsatliqT($C$2,C11)","v":{"$error":"#VALUE!"}},130,{"$f":"R_hsatliqT($C$2,C11)","v":{"$error":"#VALUE!"}},{"$f":"R_hsatgasT($C$2,C11)","v":{"$error":"#VALUE!"}},{"$f":"E11-D11","v":{"$error":"#VALUE!"}},{"$f":"r_hgastp($C$2,C11,B11)","v":{"$error":"#VALUE!"}},{"$f":"r_hgastp($C$2,C11+10,B11)","v":{"$error":"#VALUE!"}},null,{"$f":"R_PsatliqT($K$2,K11)","v":{"$error":"#VALUE!"}},130,{"$f":"R_hsatliqT($K$2,K11)","v":{"$error":"#VALUE!"}},{"$f":"R_hsatgasT($K$2,K11)","v":{"$error":"#VALUE!"}},{"$f":"M11-L11","v":{"$error":"#VALUE!"}},{"$f":"r_hgastp($K$2,K11,J11)","v":{"$error":"#VALUE!"}}]
[null,{"$error":"#VALUE!"},120,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},120,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},110,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},110,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},100,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},100,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},90,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},90,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},80,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},80,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},70,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},70,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},60,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},60,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},50,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},50,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},40,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},40,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},20,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},20,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},10,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},10,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},-10,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},-10,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},-20,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},-20,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},-30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},-30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},-40,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},-40,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]

{"sheet":"CO2 calculation","index":1,"n_rows":56,"n_cols":13,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
["Finding the rigth values"]
["Red indicates fixed value"]
["Assume that the temperature difference between CO2 and water is 5-10˚C"]
[]
["Hot water use per person per day"]
[64,"l/pr pers per house hold"]
[5,"persons in house hold",null,null,null,null,"100% effect"]
[null,null,null,null,null,null,null,null,null,"Total mas flow of water in the system"]
[{"$f":"A6*A7","v":320},"l/used per day",null,null,"Mass flow water",null,{"$f":"A9/(24*3600)","v":3.7037037037037038E-3},"kg/s",null,{"$f":"G9+G13","v":2.7627148679780257E-2},"kg/s",{"$f":"J9*24*3600","v":2386.9856459330144},"l/day"]
[]
["Water use in the space heating cycle"]
[500,"l/per day",null,null,"Mass flow heating cycle",null,{"$f":"A12/(24*3600)","v":5.7870370370370367E-3},"kg/s"]
[null,null,"Mass flow depending on the effect of Pb (water)",null,null,null,{"$f":"G24/(J22*(B27-B24))","v":2.3923444976076555E-2},"kg/s",{"$f":"G13*24*3600","v":2066.9856459330144},"l/day"]
[]
[]
["Total effect need for heating of domestic water from 5-85˚C"]
[null,"Effekt som trengs oppvarming vann","Pa+Pc",{"$f":"G9*J22*(B26-B25)","v":1.1611111111111112},"kW"]
[]
[]
["There are three (3) gas coolers"]
["Temperature of the water "]
[null,"In",null,null,"Effect water ",null,null,null,"cp water",4.18,"kJ/kg ˚C"]
["e",{"$f":"B28","v":35},"˚C",null,"Pa",null,{"$f":"G9*J22*(B26-B23)","v":0.77407407407407403},"kW","cp CO2",0.84,"kJ/kg ˚C"]
["c",{"$f":"B35-5","v":35},"˚C",null,"Pb",null,3,"kW"]
["a",10,"˚C",null,"Pc",null,{"$f":"G9*J22*(B28-B25)","v":0.38703703703703701},"kW"]
["f",{"$f":"B33-5","v":85},"˚C",null,"Pa+Pc",null,{"$f":"G23+G25","v":1.161111111111111},"kW"]
["d",{"$f":"B34-5","v":65},"˚C"]
["b",{"$f":"B35-5","v":35},"˚C"]
[]
["Temperature of the gas coolers",null,null,null,null,null,null,null,null,null,"R744"]
[null,null,null,null,"Trykk [bar]",null,null,null,null,null,"CO2","[J/kg]"]
[1,-10,"˚C",null,27,null,"Effect gas cooler",null,null,null,"h1",{"$f":"R_hsatgasP(K30,E32*100000)","v":435962.3752693595}]
[2,90,"˚C",null,92,null,"A",{"$f":"G40*(L33-L34)/1000","v":0.79297461900966149},"kW",null,"h2",{"$f":"r_hgastp(K30,B33,E33*100000)","v":496067.53928292252}]
["3'",70,"˚C",null,92,null,"B",{"$f":"G40*(L34-L35)/1000","v":2.9999999999999996},"kW",null,"h3'",{"$f":"r_hgastp(K30,B34,E34*100000)","v":462078.35980747163}]
["3''",40,"˚C","Pa",{"$f":"E34","v":92},null,"C",{"$f":"G40*(L35-L36)/1000","v":2.663854945759295},"kW",null,"h3''",{"$f":"r_hgastp(K30,B35,E35*100000)","v":333489.70642320701}]
[3,10,"˚C","Pb",92,null,"PA+PC",{"$f":"H33+H35","v":3.4568295647689564},"kW",null,"h3",{"$f":"r_hgastp(K30,B36,E36*100000)","v":219309.19966114001}]
[4,{"$f":"B32","v":-10},"˚C","Pc",27,null,null,null,null,null,"h4",{"$f":"L36","v":219309.19966114001}]
[]
[]
[null,null,null,"Find mCO2 by Pb water",null,null,{"$f":"G24/(L34-L35)*1000","v":2.3330207767516053E-2},"kg/s"]
[null,null,null,null,null,null,null,null,null,"COP for 1 stage compression"]
[null,null,null,"Find T(A-in water) by PA water",null,null,{"$f":"-(G23/(G9*J22))+B26","v":35},"˚C",null,"COP","(h2-h3'')/(h2-h1)"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"(L33-L35)/(L33-L32)","v":2.7048895968910265}]
[null,null,null,"Compressor effect",null,0.8,{"$f":"((G40*(L33-L32))*F44)/1000","v":1.1218127714696433},"kW"]
[]
[]
[null,null,null,null,"Effect total"]
[null,null,null,null,"Water",null,{"$f":"G23+G24+G25","v":4.1611111111111114},"kW",{"$f":"G48*24*31","v":3095.8666666666668},"kWh"]
[null,null,null,null,"CO2",null,{"$f":"H33+H34+H35","v":6.456829564768956},"kW",{"$f":"G49*24*31","v":4803.8811961881029},"kWh"]
[]
[]
[]
[null,null,null,"Find mR717 by Pb water",null,null,null,null,null,null,"h1",-63.8]
[null,null,null,"Find mR290 by Pb water",null,null,null,null,null,null,"h2",-11.1]
[null,null,null,null,null,null,null,null,null,null,"h3",-299.7]
[null,null,null,null,null,null,null,null,null,"COP",{"$f":"(L54-L53)/(L54-L55)","v":0.18260568260568261}]