{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Compressor & IHX","Condenser","Evaporators","Calculations CndU-Evps","CndU-Evps","EVPS","CND-CMP","Calculations EvpU-Cnd"],"not_rendered":{"charts":10,"images":0,"macros":1,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"CndU-Evps","index":4,"reason":"not_a_worksheet"}],"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":"Compressor & IHX","index":0,"n_rows":146,"n_cols":26,"rows_kept":146,"cut":false,"hidden":false,"merged":[[140,0,145,0],[133,0,138,0],[10,0,15,0],[17,0,22,0],[24,0,29,0],[126,0,131,0],[112,0,117,0],[119,0,124,0],[56,0,61,0],[42,0,47,0],[0,0,0,6],[32,0,32,6],[51,0,52,0],[105,0,110,0],[77,0,82,0],[91,0,96,0],[98,0,103,0],[84,0,89,0],[63,0,68,0],[70,0,75,0]]}
["Table Parameters",null,null,null,null,null,null,null,null,null,"COMPRESOR PARAMETERS - SCROLL COMPRESOR YF15KE-TFD"]
["Refrigerant",{"$f":"M3","v":"R454C"}]
["Drive",{"$f":"M9","v":"380-420 V / 3~ / 50 Hz"},null,null,null,null,null,null,null,null,"YF15K1E-TFD",null,"R454C"]
["Table Suction Temperature [oC]",{"$f":"M10","v":20},null,null,null,null,null,null,null,null,"Version","8.24.5.4610 / 45322"]
["Table Subcooling [K]",{"$f":"M7","v":0}]
[]
["n [RPM]",3000,null,null,null,null,null,null,null,null,"Liquid Subcooling",null,0,"K"]
["Compressor",{"$f":"K3","v":"YF15K1E-TFD"},null,null,null,null,null,null,null,null,"Voltage",null,400,"V"]
["V_dot [m^3.h^-1]",3.96," => ",null,null,null,null,null,null,null,"Power Supply",null,"380-420 V / 3~ / 50 Hz",null,null,null,null,null,null,null,null,null,null,"Cooling Capacity, kW",null,"Power, kW"]
[null,null,null,null,null,null,null,null,null,null,"Suction Return Temperature",null,20,"°C",null,null,null,null,null,null,null,null,"C0",19.831673803217001,null,2.362283462563]
["Table Cooling Capacity [kW]","SDT\\SST [°C]",{"$f":"C25","v":-10},{"$f":"D25","v":-5},0,5,13,null,null,null,"Swept Volume",null,98,"cm³",null,null,null,null,null,null,null,null,"C1",0.68784745232199995,null,3.7779459738000003E-2]
[null,25,{"$f":"($L$16+$M$16*C$11+$N$16*$B12+$O$16*C$11^2+$P$16*C$11*$B12+$Q$16*$B12^2+$R$16*C$11^3+$S$16*$B12*C$11^2+$T$16*C$11*$B12^2+$U$16*$B12^3)*$B$7/3000","v":10.782314424922001},13.004951470907004,15.554249814142002,18.455372281627007,23.891768824235001,null,null,null,"Dew Point",null,null,null,null,null,null,null,null,null,null,null,"C2",-0.177020841963,null,-9.7685989919999994E-3]
[null,32,9.985679439741002,12.038365457171002,14.397863794800999,17.089337279631,22.149009577727,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C3",8.4542665599999997E-3,null,0]
[null,39,9.1996209274739993,11.082958481108999,13.253259377894002,15.735686444829001,20.419598602029009,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C4",-5.7765083859999998E-3,null,-1.7727449880000001E-3]
[null,46,8.4207552212470009,10.135346875847002,12.117052896546999,14.391036110347004,18.700152230267001,null,null,null,null,"C0","C1","C2","C3","C4","C5","C6","C7","C8","C9",null,"C5",2.7805912099999999E-4,null,8.6099237000000005E-5]
[null,55,7.424480042482001,8.922998085317003,10.663110380902001,12.669979756237,16.498631898845009,null,null,null,"Cooling Capacity, kW",19.831673803217001,0.68784745232199995,-0.177020841963,8.4542665599999997E-3,-5.7765083859999998E-3,2.7805912099999999E-4,3.3550436000000002E-5,-5.6711362999999999E-5,1.2297240000000001E-6,-1.644153E-6,null,"C6",3.3550436000000002E-5,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C7",-5.6711362999999999E-5,null,0]
["Table Input Power [kW]","SDT\\SST [°C]",{"$f":"C11","v":-10},{"$f":"D11","v":-5},0,5,13,null,null,null,"Power, kW",2.362283462563,3.7779459738000003E-2,-9.7685989919999994E-3,0,-1.7727449880000001E-3,8.6099237000000005E-5,0,0,3.5280190000000001E-5,1.8122378000000001E-5,null,"C8",1.2297240000000001E-6,null,3.5280190000000001E-5]
[null,{"$f":"B12","v":25},{"$f":"($L$18+$M$18*C$18+$N$18*$B19+$O$18*C$18^2+$P$18*C$18*$B19+$Q$18*$B19^2+$R$18*C$18^3+$S$18*$B19*C$18^2+$T$18*C$18*$B19^2+$U$18*$B19^3)*$B$7/3000","v":2.2999331292580001},2.3774878981979999,2.4550426671379997,2.5325974360780004,2.6566850663819994,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C9",-1.644153E-6,null,1.8122378000000001E-5]
[null,{"$f":"B13","v":32},2.5599026489909997,2.6457953224009998,2.7316879958109999,2.8175806692210004,2.9550089466769993,null,null,null,"Current, A",6.0205359829810003,3.0527031763E-2,9.5199251159999998E-3,-1.5950867999999999E-5,-2.0935375429999999E-3,-1.3656808249999999E-3,-1.021667E-6,2.916723E-6,4.8226599000000001E-5,3.8294531000000002E-5]
[null,39,2.9642306399739997,3.0757485109539999,3.1872663819340001,3.2987842529140003,3.4772128464819998]
[null,46,3.5502129561310007,3.7046433177809996,3.8590736794309994,4.0135040410810001,4.2605926197209998,null,null,null,"Suction Mass Flow, g/s",90.755006887242999,3.3232212466100002,-0.249173156688,4.7724799993999999E-2,-7.8467291090000002E-3,6.2817454300000001E-4,2.9123259699999999E-4,-4.4653476000000003E-5,2.7533763999999999E-5,7.9007920000000004E-6,null,null,"Cooling Capacity, kW","Power, kW"]
[null,55,4.6305607481980005,4.8655660489379997,5.1005713496780007,5.335576650418,5.7115851316020008,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C0",19.831673803217001,2.362283462563]
[null,null,null,null,null,null,null,null,null,null,null,"X = C0 + C1*S + C2*D + C3*S^2 + C4*S*D + C5*D^2 + C6*S^3 + C7*D*S^2 +C8*S*D^2 + C9*D^3",null,null,null,null,null,null,null,null,null,null,"C1",0.68784745232199995,3.7779459738000003E-2]
["Table Suction Massflow [kg * s^-1]","SDT\\SST [oC]",-10,-5,0,5,13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C2",-0.177020841963,-9.7685989919999994E-3]
[null,{"$f":"B12","v":25},{"$f":"($L$22+$M$22*C$11+$N$22*$B12+$O$22*C$11^2+$P$22*C$11*$B12+$Q$22*$B12^2+$R$22*C$11^3+$S$22*$B12*C$11^2+$T$22*C$11*$B12^2+$U$22*$B12^3)/1000*$B$7/3000","v":5.7968734432967996E-2},{"$f":"($L$22+$M$22*D$11+$N$22*$B12+$O$22*D$11^2+$P$22*D$11*$B12+$Q$22*$B12^2+$R$22*D$11^3+$S$22*$B12*D$11^2+$T$22*D$11*$B12^2+$U$22*$B12^3)/1000*$B$7/3000","v":7.0449236330218004E-2},8.5041736934418008E-2,0.101964660693318,0.13443380629091797,null,null,null,null,"X = Cooling Capacity, kW; Power Input, kW; Current, A; Suction Mass Flow, g/s",null,null,null,null,null,null,null,null,null,null,"C3",8.4542665599999997E-3,0]
[null,{"$f":"B13","v":32},{"$f":"($L$22+$M$22*C$11+$N$22*$B13+$O$22*C$11^2+$P$22*C$11*$B13+$Q$22*$B13^2+$R$22*C$11^3+$S$22*$B13*C$11^2+$T$22*C$11*$B13^2+$U$22*$B13^3)/1000*$B$7/3000","v":5.7018761142134999E-2},6.9303000454649988E-2,8.3683609757515001E-2,0.10037901349848001,0.13245161933685604,null,null,null,null,"S = Evaporating Temperature, °C",null,null,null,null,null,null,null,null,null,null,"C4",-5.7765083859999998E-3,-1.7727449880000001E-3]
[null,39,{"$f":"($L$22+$M$22*C$11+$N$22*$B14+$O$22*C$11^2+$P$22*C$11*$B14+$Q$22*$B14^2+$R$22*C$11^3+$S$22*$B14*C$11^2+$T$22*C$11*$B14^2+$U$22*$B14^3)/1000*$B$7/3000","v":5.6177696518931994E-2},6.8279164791072003E-2,8.2461374336962004E-2,9.8942749604352023E-2,0.13064040215448003,null,null,null,null,"D = Cond. Temp., °C",null,null,null,null,null,null,null,null,null,null,"C5",2.7805912099999999E-4,8.6099237000000005E-5]
[null,46,{"$f":"($L$22+$M$22*C$11+$N$22*$B15+$O$22*C$11^2+$P$22*C$11*$B15+$Q$22*$B15^2+$R$22*C$11^3+$S$22*$B15*C$11^2+$T$22*C$11*$B15^2+$U$22*$B15^3)/1000*$B$7/3000","v":5.5461800393294992E-2},6.7393989169419979E-2,8.1391290502695002E-2,9.7672128840869982E-2,0.12901641457372603,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C6",3.3550436000000002E-5,0]
[null,55,{"$f":"($L$22+$M$22*C$11+$N$22*$B16+$O$22*C$11^2+$P$22*C$11*$B16+$Q$22*$B16^2+$R$22*C$11^3+$S$22*$B16*C$11^2+$T$22*C$11*$B16^2+$U$22*$B16^3)/1000*$B$7/3000","v":5.4751450998227986E-2},6.6485819018128001E-2,8.026520553097799E-2,9.6308034984527974E-2,0.12722971084844803,null,null,null,"WARNING - Data from coefficients valid only within operating range",null,null,null,null,null,null,null,null,null,null,null,"C7",-5.6711362999999999E-5,0]
[null,null,null,null,null,null,null,null,null,null,"WARNING - Cooling capacity is valid only for the given Liquid Subcooling and Return Gas Temperature or Suction Superheat",null,null,null,null,null,null,null,null,null,null,null,"C8",1.2297240000000001E-6,3.5280190000000001E-5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C9",-1.644153E-6,1.8122378000000001E-5]
["Calculated Parameters"]
["Chosen Saturated Suction Temperature [oC]",-9]
[]
["Chosen Suction Temperature [°C]",9]
["Suction Temperatures Ratio",{"$f":"(B4+273.15)/(B36+273.15)","v":1.0389863547758285}]
[]
["Evaporator Superheating [K]",7]
[]
["Chosen Subcooling [K]",0]
[]
["dh_sbcl [kJ * kg^-1]","SDT\\SST",{"$f":"$C$25","v":-10},{"$f":"$D$25","v":-5},{"$f":"$E$25","v":0},{"$f":"$F$25","v":5},{"$f":"$G$25","v":13},null,null,{"$f":"C43","v":-10}]
[null,{"$f":"$B$26","v":25},0,0,0,0,0,null,{"$f":"B44","v":25},{"$f":"[1]!enthalpy($B$2,\"tliq\",\"c\",$B44)-[1]!enthalpy($B$2,\"tliq\",\"c\",$B44-$B$41)","v":0}]
[null,{"$f":"$B$27","v":32},0,0,0,0,0]
[null,{"$f":"$B$28","v":39},0,0,0,0,0]
[null,{"$f":"$B$29","v":46},0,0,0,0,0]
[null,{"$f":"$B$30","v":55},0,0,0,0,0]
[]
["Internal HX","NO"]
["Type","KAPALINA-PARA"]
["Coefficients","C0","C1"]
[null,3.14,3.1]
[]
[]
[]
["U . A [kW * K^-1]","SDT\\SST",{"$f":"$C$25","v":-10},{"$f":"$D$25","v":-5},{"$f":"$E$25","v":0},{"$f":"$F$25","v":5},{"$f":"$G$25","v":13}]
[null,{"$f":"$B$26","v":25},{"$f":"$B$53+$C$53*($B$37*C26)","v":3.3267090446463801},3.3669069652795698,3.4139073332100174,3.4684136625020847,3.5729921601062062]
[null,{"$f":"$B$27","v":32},3.3236493158579918,3.3632151026339536,3.4095329988349747,3.4633065185254166,3.5666078179927627]
[null,{"$f":"$B$28","v":39},3.3209403663903148,3.3599174736535833,3.4055963524697122,3.4586805169030623,3.5607741451848876]
[null,{"$f":"$B$29","v":46},3.318634566841796,3.357066448936906,3.4021497647126764,3.4545880282334691,3.5555435122810284]
[null,{"$f":"$B$30","v":55},3.3163466325231425,3.3541413621123839,3.3985228052608871,3.4501944760330128,3.5497887938301962]
[]
["cp_vap [kJ * kg^-1]","SDT\\SST",{"$f":"C57","v":-10},{"$f":"$D$25","v":-5},{"$f":"$E$25","v":0},{"$f":"$F$25","v":5},{"$f":"$G$25","v":13},null,null,{"$f":"C64","v":-10}]
[null,{"$f":"$B$26","v":25},1.0583302488762822,1.0958711147455846,1.1118756334389164,1.1371194289351858,1.1594330815593858,null,{"$f":"B65","v":25},{"$f":"[1]!cp($B$2,\"pt\",\"c\",[1]!pressure($B$2,\"tvap\",\"c\",C$64),C$64+$B$39)","v":0.92054004369665965}]
[null,{"$f":"$B$27","v":32},1.0583302488762822,1.0958711147455846,1.1118756334389164,1.1371194289351858,1.1594330815593858]
[null,{"$f":"$B$28","v":39},1.0583302488762822,1.0958711147455846,1.1118756334389164,1.1371194289351858,1.1594330815593858]
[null,{"$f":"$B$29","v":46},1.0583302488762822,1.0958711147455846,1.1118756334389164,1.1371194289351858,1.1594330815593858]
[null,{"$f":"$B$30","v":55},1.0583302488762822,1.0958711147455846,1.1118756334389164,1.1371194289351858,1.1594330815593858]
[]
["cp_liq [kJ * kg^-1]","SDT\\SST",{"$f":"$C$25","v":-10},{"$f":"$D$25","v":-5},{"$f":"$E$25","v":0},{"$f":"$F$25","v":5},{"$f":"$G$25","v":13},null,null,{"$f":"C71","v":-10}]
[null,{"$f":"$B$26","v":25},1.7081979169847146,1.7081979169847146,1.7081979169847146,1.7081979169847146,1.7081979169847146,null,{"$f":"B72","v":25},{"$f":"[1]!cp($B$2,\"tliq\",\"c\",$B72)","v":1.53928538410917}]
[null,{"$f":"$B$27","v":32},1.7686941114812875,1.7686941114812875,1.7686941114812875,1.7686941114812875,1.7686941114812875]
[null,{"$f":"$B$28","v":39},1.8433340831549001,1.8433340831549001,1.8433340831549001,1.8433340831549001,1.8433340831549001]
[null,{"$f":"$B$29","v":46},1.9389245024404398,1.9389245024404398,1.9389245024404398,1.9389245024404398,1.9389245024404398]
[null,{"$f":"$B$30","v":55},2.0680185383544645,2.0680185383544645,2.0680185383544645,2.0680185383544645,2.0680185383544645]
[]
["Cmin [kW * K^-1]","SDT\\SST",{"$f":"C11","v":-10},{"$f":"D11","v":-5},0,5,13]
[null,{"$f":"$B$26","v":25},{"$f":"C65*($B$37*C26)","v":6.3741880544534321E-2},8.0213157736922461E-2,9.8242222456920103E-2,0.12046630850286554,0.16194368854290114]
[null,{"$f":"$B$27","v":32},6.2697298760628115E-2,7.8908059145651868E-2,9.6673281874944603E-2,0.11859294313440141,0.15955587646215305]
[null,{"$f":"$B$28","v":39},6.1772471933428143E-2,7.7742324840253271E-2,9.5261326658492546E-2,0.11689606690115477,0.1573740205781389]
[null,{"$f":"$B$29","v":46},6.098527922051121E-2,7.6734468183984633E-2,9.4025140547022545E-2,0.11539489000473808,0.1554177080535494]
[null,{"$f":"$B$30","v":55},6.0204185640874743E-2,7.5700430068140631E-2,9.2724260599307801E-2,0.11378327917597056,0.15326538194162848]
[]
["Cmax [kW * K^-1]","SDT\\SST",{"$f":"C78","v":-10},{"$f":"D78","v":-5},0,5,13]
[null,{"$f":"$B$26","v":25},{"$f":"C72*($B$37*C26)","v":0.10288258101521054},0.12503290498060768,0.1509315922697386,0.18096630135334896,0.23859235676262366]
[null,{"$f":"$B$27","v":32},0.10478047210825699,0.12735459278140804,0.153781105770746,0.18446139855465143,0.24339959212763876]
[null,{"$f":"$B$28","v":39},0.10759146593090389,0.13076818537644194,0.15792993834485242,0.18949505111123727,0.25020236229989407]
[null,{"$f":"$B$29","v":46},0.11172868988141699,0.13576627629080742,0.16396406519690462,0.19676207616654753,0.25990564444898245]
[null,{"$f":"$B$30","v":55},0.11764132426911,0.14285429247641487,0.17246127544094034,0.20693158933271619,0.2733712330486327]
[]
["NTU","SDT\\SST",{"$f":"C85","v":-10},{"$f":"D85","v":-5},0,5,13]
[null,{"$f":"$B$26","v":25},{"$f":"C58/C79","v":52.190318456671818},41.974497205584612,34.749899257491244,28.791565920853145,22.063176356265782]
[null,{"$f":"$B$27","v":32},53.011044838587793,42.62194684608815,35.268617478462204,29.203310306587554,22.353346658709675]
[null,{"$f":"$B$28","v":39},53.760846254773064,43.218639017518697,35.750041196451292,29.587655158899921,22.626187804720299]
[null,{"$f":"$B$29","v":46},54.416977494556392,43.749132930559156,36.183405256504145,29.937097111419966,22.877338475844468]
[null,{"$f":"$B$30","v":55},55.084984494359773,44.308088594651352,36.651926726566508,30.322508729047474,23.161060566058829]
[]
["eff","SDT\\SST",{"$f":"C92","v":-10},{"$f":"D92","v":-5},0,5,13]
[null,{"$f":"$B$26","v":25},{"$f":"1-EXP((C86/C79)*C93^0.22*(EXP((-C86/C79)*C93^0.78)-1))","v":0.97878170277197107},0.97118301630739001,0.96503645694826878,0.95697978393343153,0.94552662382742669]
[null,{"$f":"$B$27","v":32},0.98174032488402518,0.97489751818801762,0.96930174279500381,0.9619059228058946,0.95128541698265734]
[null,{"$f":"$B$28","v":39},0.98477631583951375,0.97876389823763199,0.97378444795470487,0.9671369272487258,0.95747718508050073]
[null,{"$f":"$B$29","v":46},0.98788952202075364,0.98279748140647605,0.97851505157020657,0.97272572276760849,0.9641904762784208]
[null,{"$f":"$B$30","v":55},0.99108661678595911,0.98703257017960999,0.98355456779880635,0.97877227207947615,0.97158578467627987]
[]
["Internal HX Capacity [kW]","SDT\\SST",{"$f":"C99","v":-10},{"$f":"D99","v":-5},0,5,13]
[null,{"$f":"$B$26","v":25},{"$f":"C100*C79*($B107-(C$106+$B$39))","v":1.7469028185634725},1.7917380990051506,1.7065318730858969,1.4986896844702948,0.76561034539064821]
[null,{"$f":"$B$27","v":32},2.1543363259113444,2.3078181307838794,2.3426395150774115,2.2815050880792676,1.8213981416679916]
[null,{"$f":"$B$28","v":39},2.5549468278978473,2.8153810939919959,2.968447948530335,3.0524715796565962,2.8629586503311875]
[null,{"$f":"$B$29","v":46},2.9520891986331979,3.3182354510045604,3.5881955947993616,3.8164176446406159,3.8961591227065613]
[null,{"$f":"$B$30","v":55},3.4607186344637655,3.9600958728545099,4.377569762794371,4.7888205033998759,5.2118663232113391]
[]
["HX Vapor Outlet Temperature [oC]","SDT\\SST",{"$f":"C106","v":-10},{"$f":"D106","v":-5},0,5,13]
[null,{"$f":"$B$26","v":25},{"$f":"(C$113+$B$39)+C107/C79","v":24.405887677615191},24.337209375069968,24.370656225068839,24.440737191134609,24.727633119137135]
[null,{"$f":"$B$27","v":32},31.360911370940883,31.246925545640529,31.232543569875098,31.238118456117892,31.415425003791889]
[null,{"$f":"$B$28","v":39},38.360605265259572,38.214264234792388,38.161102334550556,38.112697035715598,38.192066516529515]
[null,{"$f":"$B$29","v":46},45.406586579016931,45.243089181884947,45.162087011238057,45.072674574098684,45.068952383238937]
[null,{"$f":"$B$30","v":55},54.483023773585629,54.312726219519334,54.210619254342703,54.087207699417469,54.005502463669792]
[]
["HX Liquid Outlet Temperature [oC]","SDT\\SST",{"$f":"C113","v":-10},{"$f":"D113","v":-5},0,5,13]
[null,{"$f":"$B$26","v":25},{"$f":"$B121-C107/C86","v":8.0204219088826711},{"$f":"$B121-D107/D86","v":10.669867469822883},13.693342146447014,16.718404624162584,21.791136330689937]
[null,{"$f":"$B$27","v":32},11.439524535778677,13.878799339847696,16.766402196575598,19.631531008893912,24.516839795225088]
[null,{"$f":"$B$28","v":39},15.253257581427,17.470443052433833,20.204020088651614,22.891549875544051,27.557427579761907]
[null,{"$f":"$B$29","v":46},19.57805589802949,21.559207030934573,24.115963455222378,26.603896243652954,31.00933240227744]
[null,{"$f":"$B$30","v":55},25.582457686831113,27.278775777715474,29.617085768373101,31.857953303107617,35.934839905835489]
[]
["Cooling Capacity [kW]","SDT\\SST [oC]",{"$f":"C120","v":-10},{"$f":"D120","v":-5},0,5,13]
[null,{"$f":"$B$26","v":25},{"$f":"C12*$B$37+IF($B$50=\"YES\",C107,0)+C26*$B$37*C44","v":11.202677560396543},13.511967122794216,16.160653315668007,19.174879972918507,24.823221799838706]
[null,{"$f":"$B$27","v":32},10.374984681056441,12.507697443805348,14.959184020719167,17.755588245698483,23.012518723057486]
[null,{"$f":"$B$28","v":39},9.5582806127556363,11.515042632419291,13.769955649936653,16.349163499208299,21.215684317507723]
[null,{"$f":"$B$29","v":46},8.7490497717829463,10.530487104924857,12.589452619609261,14.952090149736751,19.429202999478189]
[null,{"$f":"$B$30","v":55},7.7139334554442618,9.2708732543352106,11.078826185225665,13.163936082016219,17.14185341536918]
[]
["Input Power [kW]","SDT\\SST",{"$f":"C127","v":-10},{"$f":"D127","v":-5},0,5,13]
[null,{"$f":"$B$26","v":25},{"$f":"C19/$B$37","v":2.2136316985166116},2.2882763447946979,2.3629209910727837,2.437565637350871,2.5569970713958079]
[null,{"$f":"$B$27","v":32},2.4638462644134762,2.5465159482020878,2.6291856319906999,2.7118553157793119,2.8441268098410895]
[null,{"$f":"$B$28","v":39},2.8530024733708479,2.9603358088544125,3.0676691443379775,3.1750024798215426,3.3467358165952454]
[null,{"$f":"$B$29","v":46},3.4169967101223326,3.5656323114852775,3.7142679128482228,3.862903514211169,4.1007204763918814]
[null,{"$f":"$B$30","v":55},4.4568061235001393,4.6829932140810389,4.9091803046619411,5.1353673952428407,5.4972667401722823]
[]
["Heat Rejection [kW]","SDT\\SST",{"$f":"C134","v":-10},{"$f":"D134","v":-5},0,5,13]
[null,{"$f":"$B$26","v":25},{"$f":"C128+C135","v":13.416309258913154},{"$f":"D128+D135","v":15.800243467588913},18.523574306740791,21.612445610269379,27.380218871234515]
[null,{"$f":"$B$27","v":32},{"$f":"C129+C136","v":12.838830945469917},15.054213392007437,17.588369652709869,20.467443561477793,25.856645532898575]
[null,{"$f":"$B$28","v":39},12.411283086126485,14.475378441273705,16.837624794274632,19.524165979029842,24.562420134102968]
[null,{"$f":"$B$29","v":46},12.16604648190528,14.096119416410135,16.303720532457483,18.81499366394792,23.529923475870071]
[null,{"$f":"$B$30","v":55},12.170739578944401,13.953866468416249,15.988006489887606,18.299303477259059,22.639120155541463]

{"sheet":"Condenser","index":1,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,6,0]]}
["Table or  SW Parameters","Table or SW Cooling Fluid Temperature [oC]",35]
[]
[null,"t_cnd [oC]","Q_cnd [kW]"]
[null,{"$f":"C1","v":35},0]
[null,42,{"$f":"(B5-$C$1)*$B$13*2/1000","v":8.6548000000000016}]
[null,46,{"$f":"(B6-$C$1)*$B$13*2/1000","v":13.600400000000002}]
[null,55,24.728000000000002]
[]
["Condenser Characteristics"]
["Considered Cooling Fluid Temperature [oC]",35]
[]
["Konstanty výkonu Q_evp=eps1*c1min*(t-t_evp)"]
["eps*c1min",618.20000000000005]

{"sheet":"Evaporators","index":2,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,6,0],[1,1,1,2],[1,4,1,5],[1,7,1,8]]}
["Table or  SW Parameters","Table or SW Cooled Fluid Temperature [oC]",1,null,7,null,null,13]
[null,"1st Evaporator",null,null,"2nd Evaporator",null,null,"3rd Evaporator"]
[null,"t_evp [oC]","Q_evp 1 [kW]",null,"t_evp [oC]","Q_evp 1 [kW]",null,"t_evp [oC]","Q_evp 3 [kW]"]
[null,{"$f":"C1","v":1},0,null,{"$f":"E1","v":7},0,null,{"$f":"H1","v":13},0]
[null,-5,{"$f":"($C$1-B5)*$B$29*2/1000","v":1.6763999999999999},null,3,{"$f":"($E$1-E5)*$B$30*2/1000","v":0.83079999999999998},null,7,{"$f":"($H$1-H5)*$B$31*2/1000","v":0.92687999999999993}]
[null,-9,{"$f":"($C$1-B6)*$B$29*2/1000","v":2.794},null,0,{"$f":"($E$1-E6)*$B$30*2/1000","v":1.4539},null,3,{"$f":"($H$1-H6)*$B$31*2/1000","v":1.5448}]
[null,-15,{"$f":"($C$1-B7)*$B$29*2/1000","v":4.4703999999999997},null,-3,{"$f":"($E$1-E7)*$B$30*2/1000","v":2.077},null,0,{"$f":"($H$1-H7)*$B$31*2/1000","v":2.0082399999999998}]
[]
[null,1,0,null,{"$f":"E6","v":0},0,null,{"$f":"H6","v":3},0]
[null,-5,{"$f":"$B$29*($B$4-B10)*2/1000","v":1.6763999999999999},null,3,{"$f":"$B$30*($E$4-E10)*2/1000","v":0.83079999999999998},null,7,{"$f":"$B$31*($H$4-H10)*2/1000","v":0.92687999999999993}]
[null,-9,{"$f":"$B$29*($B$4-B11)*2/1000","v":2.794},null,0,{"$f":"$B$30*($E$4-E11)*2/1000","v":1.4539},null,3,{"$f":"$B$31*($H$4-H11)*2/1000","v":1.5448}]
[null,-15,4.4703999999999997,null,-3,2.077,null,0,2.0082399999999998]
[]
[]
["Evaporators Characteristics"]
["1. Evaporator"]
["ON / OFF","ON"]
["Considered Cooling Fluid Temperature [oC]",1]
["2. Evaporator"]
["ON / OFF","ON"]
["Considered Cooling Fluid Temperature [oC]",7]
["3. Evaporator"]
["ON / OFF","ON"]
["Considered Cooling Fluid Temperature [oC]",13]
[]
[]
[]
["Konstanty výkonu Q_evp=eps1*c1min*(t-t_evp)"]
["eps1*c1min",139.69999999999999,{"$f":"B29*(1+9)","v":1397}]
["eps2*c2min",103.85,{"$f":"B30*16","v":1661.6}]
["eps3*c3min",77.239999999999995,{"$f":"B31*22","v":1699.28}]

{"sheet":"Calculations CndU-Evps","index":3,"n_rows":136,"n_cols":12,"rows_kept":136,"cut":false,"hidden":false,"merged":[[89,0,91,0],[0,0,0,7],[10,0,14,0],[17,0,21,0],[100,1,100,2],[76,0,80,0],[28,0,32,0],[34,0,39,0],[43,0,45,0],[52,0,56,0],[82,0,87,0],[131,0,135,0],[107,0,108,0],[122,0,123,0],[104,0,105,0],[119,0,120,0],[116,0,117,0],[125,0,126,0],[128,0,129,0],[110,0,111,0],[113,0,114,0]]}
["Cnd Unit"]
["Compressor"]
[null,"SDT","SDT^2"]
[null,{"$f":"'Compressor & IHX'!B128","v":25},{"$f":"B4^2","v":625}]
[null,{"$f":"'Compressor & IHX'!B129","v":32},{"$f":"B5^2","v":1024}]
[null,{"$f":"'Compressor & IHX'!B130","v":39},1521]
[null,{"$f":"'Compressor & IHX'!B131","v":46},2116]
[null,{"$f":"'Compressor & IHX'!B132","v":55},3025]
[]
["Compressor Cooling Capacity Characteristic Equation Coefficients","SST","A2","A1","A0"]
["SST",{"$f":"'Compressor & IHX'!C127","v":-10},{"$f":"LINEST('Compressor & IHX'!C128:C132,B4:C8,1,0)","v":7.1087172425107523E-5},-0.12192523651237294,14.205478436869646]
[null,{"$f":"'Compressor & IHX'!D127","v":-5},{"$f":"LINEST('Compressor & IHX'!D128:D132,B4:C8,1,0)","v":7.7475504705825052E-5},-0.14751462854505445,17.150510092408908]
[null,{"$f":"'Compressor & IHX'!E127","v":0},{"$f":"LINEST('Compressor & IHX'!E128:E132,B4:C8,1,0)","v":8.3863836986513416E-5},-0.17605013719362073,20.508591293821421]
[null,{"$f":"'Compressor & IHX'!F127","v":5},{"$f":"LINEST('Compressor & IHX'!F128:F132,B4:C8,1,0)","v":9.0252169267218476E-5},-0.2075317624580752,24.305865875007843]
[null,13,{"$f":"LINEST('Compressor & IHX'!G128:G132,B4:C8,1,0)","v":1.0047350091633802E-4},-0.26403028544224616,31.360282444251617]
[]
["Compressor Heat Rejection Capacity Characteristic Equation Coefficients","SST","A2","A1","A0"]
["SST",{"$f":"B11","v":-10},{"$f":"LINEST('Compressor & IHX'!C142:C146,B4:C8,1,0)","v":1.9079402716095019E-3},-0.19464428607744183,17.098248422253739]
[null,{"$f":"B12","v":-5},{"$f":"LINEST('Compressor & IHX'!D142:D146,B4:C8,1,0)","v":2.0841103812823361E-3},-0.22876480549139896,20.225089297732907]
[null,0,{"$f":"LINEST('Compressor & IHX'!E142:E146,B4:C8,1,0)","v":2.260280490955151E-3},-0.2658314415212415,23.764979719085339]
[null,5,{"$f":"LINEST('Compressor & IHX'!F142:F146,B4:C8,1,0)","v":2.4364506006279746E-3},-0.30584419416697173,27.744063520211665]
[null,13,{"$f":"LINEST('Compressor & IHX'!G142:G146,B4:C8,1,0)","v":2.7183227761044941E-3},-0.37599252096118452,35.089374841359295]
[]
["Throttling Valve Sat. Suct. Temp. Setting [oC]",10]
[]
["Condenser"]
["SW Chosen Cooling fluid Inlet Temperature [oC]",{"$f":"Condenser!C1","v":35}]
[]
["Input Table","SDT","dt","Qo"]
[null,{"$f":"B27","v":35},{"$f":"B30-$B$27","v":0},0]
[null,{"$f":"Condenser!B5","v":42},{"$f":"B31-$B$27","v":7},{"$f":"Condenser!C5","v":8.6548000000000016}]
[null,{"$f":"Condenser!B6","v":46},11,{"$f":"Condenser!C6","v":13.600400000000002}]
[null,{"$f":"Condenser!B7","v":55},20,{"$f":"Condenser!C7","v":24.728000000000002}]
[]
["Condenser Characteristic Equation","k","q"]
[null,{"$f":"LINEST('Calculations CndU-Evps'!D30:D33,C30:C33,0,1)","v":1.2364000000000002},0]
[null,0,{"$error":"#N/A"}]
[null,1,0]
[null,{"$error":"#NUM!"},3]
[null,871.35042720000024,0]
[]
["SDT_max - CFIT [K]",{"$f":"B33-B30","v":20},null,{"$f":"Condenser!B11","v":0},{"$f":"B33-B30","v":20}]
[]
["Characteristic Calculated Data","SDT","Qo"]
[null,{"$f":"Condenser!$B$10","v":35},0]
[null,{"$f":"B45+B42","v":55},{"$f":"B36*(B46-B45)","v":24.728000000000002}]
[]
["Axes crossing",20,null,null,{"$f":"B48","v":20}]
[]
["Considered Cooling Fluid Inlet Temperature [oC]",{"$f":"Condenser!B10","v":35}]
[]
["Condensing  Unit","SST","SST^2","SDT_eqp","Qo","Qc"]
["Compressor-Condenser Equilibrium Points",{"$f":"B18","v":-10},{"$f":"B53^2","v":100},{"$f":"tbalancep($B$50,E11,D11,C11,$C$36,$B$36,\"Cnd\")","v":42.412109375},{"$f":"E11+D11*D53+C11*D53^2","v":9.1622426534972945},{"$f":"E18+D18*D53+C18*D53^2","v":12.27495187054816}]
[null,{"$f":"B19","v":-5},{"$f":"B54^2","v":25},{"$f":"tbalancep($B$50,E12,D12,C12,$C$36,$B$36,\"Cnd\")","v":43.76953125},{"$f":"E12+D12*D54+C12*D54^2","v":10.842289340681544},{"$f":"E19+D19*D54+C19*D54^2","v":14.204841028652574}]
[null,{"$f":"B20","v":0},0,{"$f":"tbalancep($B$50,E13,D13,C13,$C$36,$B$36,\"Cnd\")","v":45.2734375},{"$f":"E13+D13*D55+C13*D55^2","v":12.710090787567569},{"$f":"E20+D20*D55+C20*D55^2","v":16.362737647031633}]
[null,{"$f":"B21","v":5},25,{"$f":"tbalancep($B$50,E14,D14,C14,$C$36,$B$36,\"Cnd\")","v":46.93359375},{"$f":"E14+D14*D56+C14*D56^2","v":14.764458514520596},{"$f":"E21+D21*D56+C21*D56^2","v":18.756617699922071}]
[null,{"$f":"B22","v":13},169,{"$f":"tbalancep($B$50,E15,D15,C15,$C$36,$B$36,\"Cnd\")","v":49.90234375},{"$f":"E15+D15*D57+C15*D57^2","v":18.434755903650458},{"$f":"E22+D22*D57+C22*D57^2","v":23.095753556272175}]
[]
[]
[null,"A2","A1","A0",null,{"$f":"IF(B57>=$B$24,F70,\"\")","v":20}]
["Condensing Unit Cooling Capacity Characteristic Equation Coefficients",{"$f":"LINEST('Calculations CndU-Evps'!E53:E57,'Calculations CndU-Evps'!B53:C57,1,0)","v":3.7171938527797168E-3},0.39203636072942161,12.710388655738495]
["Condensing Unit Heat Rejection Capacity Characteristic Equation Coefficients",{"$f":"LINEST('Calculations CndU-Evps'!F53:F57,'Calculations CndU-Evps'!B53:C57,1,0)","v":4.7586748211749554E-3},0.45602741614367803,16.361760457208156]
[]
[null,"SST","Qo","Qc",null,"SST","Qo","Qc"]
[null,{"$f":"B53","v":-10},{"$f":"IF(B65<=$B$24,$D$61+$C$61*B65+$B$61*B65^2,$D$61+$C$61*$B$24+$B$61*$B$24^2)","v":9.1617444337222498},{"$f":"IF(B65<=$B$24,$D$62+$C$62*B65+$B$62*B65^2,$D$62+$C$62*$B$24+$B$62*$B$24^2)","v":12.277353777888871},null,{"$f":"IF(B53<=$B$24,B53,$B$24)","v":-10},{"$f":"IF(F65<=$B$24,ROUND($D$61+$C$61*F65+$B$61*F65^2,1),ROUND($D$61+$C$61*$B$24+$B$61*$B$24^2,1))","v":9.1999999999999993},{"$f":"IF(F65<=$B$24,ROUND($D$62+$C$62*F65+$B$62*F65^2,1),ROUND($D$62+$C$62*$B$24+$B$62*$B$24^2,1))","v":12.3}]
[null,{"$f":"B54","v":-5},{"$f":"IF(B66<=$B$24,$D$61+$C$61*B66+$B$61*B66^2,$D$61+$C$61*$B$24+$B$61*$B$24^2)","v":10.843136698410879},{"$f":"IF(B66<=$B$24,$D$62+$C$62*B66+$B$62*B66^2,$D$62+$C$62*$B$24+$B$62*$B$24^2)","v":14.200590247019139},null,{"$f":"IF(B54<=$B$24,B54,$B$24)","v":-5},10.8,14.2]
[null,0,12.710388655738495,16.361760457208156,null,0,12.7,16.399999999999999]
[null,5,14.763500305705096,18.76086440845592,null,5,14.8,18.8]
[null,13,17.002471648310681,21.397902100762433,null,10,{"$f":"IF(F69<=$B$24,ROUND($D$61+$C$61*F69+$B$61*F69^2,1),ROUND($D$61+$C$61*$B$24+$B$61*$B$24^2,1))","v":17},{"$f":"IF(F69<=$B$24,ROUND($D$62+$C$62*F69+$B$62*F69^2,1),ROUND($D$62+$C$62*$B$24+$B$62*$B$24^2,1))","v":21.4}]
[null,null,null,null,null,{"$f":"IF(B57>=$B$24,B48,\"\")","v":20},{"$f":"IF(B69>=$B$24,ROUND(C69,1),\"\")","v":17},{"$f":"IF(B69>=$B$24,ROUND(D69,1),\"\")","v":21.4}]
[null,null,null,null,null,null,"CndU_Qo_y-axes","CndU_Qc_y-axes"]
["Evaporator"]
["SW Chosen Cooled Fluid Inlet Temperature [oC]",{"$f":"Evaporators!C1","v":1},null,null,null,{"$f":"Evaporators!E1","v":7},null,null,null,{"$f":"Evaporators!H1","v":13}]
["ON / OFF",{"$f":"Evaporators!B17","v":"ON"},null,null,null,{"$f":"Evaporators!B20","v":"ON"},null,null,null,{"$f":"Evaporators!B23","v":"ON"}]
["Considered Cooled Fluid Inlet Temperature [oC]",{"$f":"Evaporators!B18","v":1},null,null,null,{"$f":"Evaporators!B21","v":7},null,null,null,{"$f":"Evaporators!B24","v":13}]
[]
["Input Table","SST1","dt1","Qo1",null,"SST2","dt2","Qo2",null,"SST3","dt3","Qo3"]
[null,{"$f":"B73","v":1},{"$f":"$B$73-B78","v":0},0,null,{"$f":"F73","v":7},{"$f":"$F$73-F78","v":0},0,null,{"$f":"Evaporators!H4","v":13},{"$f":"$J$73-J78","v":0},{"$f":"Evaporators!I4","v":0}]
[null,{"$f":"Evaporators!B5","v":-5},{"$f":"$B$73-B79","v":6},{"$f":"Evaporators!C5","v":1.6763999999999999},null,{"$f":"Evaporators!E5","v":3},{"$f":"$F$73-F79","v":4},{"$f":"Evaporators!F5","v":0.83079999999999998},null,{"$f":"Evaporators!H5","v":7},{"$f":"$J$73-J79","v":6},{"$f":"Evaporators!I5","v":0.92687999999999993}]
[null,{"$f":"Evaporators!B6","v":-9},{"$f":"$B$73-B80","v":10},{"$f":"Evaporators!C6","v":2.794},null,{"$f":"Evaporators!E6","v":0},{"$f":"$F$73-F80","v":7},{"$f":"Evaporators!F6","v":1.4539},null,{"$f":"Evaporators!H6","v":3},10,{"$f":"Evaporators!I6","v":1.5448}]
[null,{"$f":"Evaporators!B7","v":-15},{"$f":"$B$73-B81","v":16},{"$f":"Evaporators!C7","v":4.4703999999999997},null,{"$f":"Evaporators!E7","v":-3},{"$f":"$F$73-F81","v":10},{"$f":"Evaporators!F7","v":2.077},null,{"$f":"Evaporators!H7","v":0},13,{"$f":"Evaporators!I7","v":2.0082399999999998}]
[]
["Evaporator Characteristic Equation","k","q",null,null,"k","q",null,null,"k","q"]
[null,{"$f":"LINEST('Calculations CndU-Evps'!D78:D81,C78:C81,0,1)","v":0.27939999999999998},0,null,null,{"$f":"LINEST('Calculations CndU-Evps'!H78:H81,G78:G81,0,1)","v":0.2077},0,null,null,{"$f":"LINEST('Calculations CndU-Evps'!L78:L81,K78:K81,0,1)","v":0.15448000000000001},0]
[null,1.2949904338195412E-17,{"$error":"#N/A"},null,null,0,{"$error":"#N/A"},null,null,1.5132969036418222E-17,{"$error":"#N/A"}]
[null,1,2.5639502485114184E-16,null,null,1,0,null,null,1,2.6428594233603072E-16]
[null,4.6549999754027486E+32,3,null,null,{"$error":"#NUM!"},3,null,null,1.0420684196630805E+32,3]
[null,30.601229119999996,1.9721522630525295E-31,null,null,7.1179828499999998,0,null,null,7.2785414719999988,2.0954117794933126E-31]
[]
["Characteristic Calculated Data","SST","Qo",null,null,"SST","Qo",null,null,"SST","Qo"]
[null,{"$f":"IF(B74=\"ON\",Evaporators!$B$18,\"\")","v":1},{"$f":"IF(B74=\"ON\",0,\"\")","v":0},null,null,{"$f":"IF(F74=\"ON\",Evaporators!B21,\"\")","v":7},{"$f":"IF(F74=\"ON\",0,\"\")","v":0},null,null,{"$f":"IF(J74=\"ON\",Evaporators!B24,\"\")","v":13},{"$f":"IF(J74=\"ON\",0,\"\")","v":0}]
[null,-10,{"$f":"IF(B74=\"ON\",B84*(B91-B92),\"\")","v":3.0733999999999999},null,null,-10,{"$f":"IF(F74=\"ON\",F84*(F91-F92),\"\")","v":3.5308999999999999},null,null,-10,{"$f":"IF(J74=\"ON\",J84*(J91-J92),\"\")","v":3.5530400000000002}]
[]
[]
["Condensing Unit - 2 Evaporators Equilibrium Point","SET=SST_calc","Qc","Qo","SDT_calc"]
[null,{"$f":"ROUND(tbalancep3(B24,Evaporators!B17,B75,Evaporators!B20,'Calculations CndU-Evps'!F75,Evaporators!B23,'Calculations CndU-Evps'!J75,D61,C61,B61,C84,B84,G84,F84,K84,J84),1)","v":-9},{"$f":"IF(B96<B24,ROUND(D62+C62*B96+B62*B96^2,1),ROUND(D62+C62*B24+B62*B24^2,1))","v":12.6},{"$f":"IF(B96<B24,ROUND(D61+C61*B96+B61*B96^2,1),ROUND(D61+C61*B24+B61*B24^2,1))","v":9.5},{"$f":"ROUND(B50+C96/B36,1)","v":45.2}]
["Qo1",null,null,{"$f":"IF(D96-IF(B74=\"ON\",B84*(B91-B96),0)<0.01,\"\",IF(B74=\"ON\",B84*(B91-B96),\"\"))","v":2.7939999999999996}]
["Qo2",null,null,{"$f":"IF(D96-IF(F74=\"ON\",F84*(F91-B96),0)<0.01,\"\",IF(F74=\"ON\",F84*(F91-B96),\"\"))","v":3.3231999999999999}]
["Qo3",null,null,{"$f":"IF(D96-IF(J74=\"ON\",J84*(J91-B96),0)<0.01,\"\",IF(J74=\"ON\",J84*(J91-B96),\"\"))","v":3.3985600000000002}]
[]
["Graph","3 Evaporators"]
["Graph Lines","t","Q"]
[]
[]
["SET=SST_calc_vertical",{"$f":"B96","v":-9},0]
[null,{"$f":"B105","v":-9},{"$f":"D96","v":9.5}]
[]
["Qo_horizontal",{"$f":"B96","v":-9},{"$f":"D96","v":9.5}]
[null,{"$f":"E48","v":20},{"$f":"C108","v":9.5}]
[]
["Qo_horizontal_1",{"$f":"B96","v":-9},{"$f":"D97","v":2.7939999999999996}]
[null,{"$f":"E48","v":20},{"$f":"C111","v":2.7939999999999996}]
[]
["Qo_horizontal_2",{"$f":"B111","v":-9},{"$f":"D98","v":3.3231999999999999}]
[null,{"$f":"B112","v":20},{"$f":"C114","v":3.3231999999999999}]
[]
["Qo_horizontal_3",{"$f":"B114","v":-9},{"$f":"D99","v":3.3985600000000002}]
[null,{"$f":"B115","v":20},{"$f":"C117","v":3.3985600000000002}]
[]
["Qc_vertical_1",{"$f":"B96","v":-9},{"$f":"D96","v":9.5}]
[null,{"$f":"B120","v":-9},{"$f":"C96","v":12.6}]
[]
["Qc_horizontal_1",{"$f":"B96","v":-9},{"$f":"C96","v":12.6},null,{"$f":"IF(B96<=$B$24,C96,\"\")","v":12.6}]
[null,{"$f":"E48","v":20},{"$f":"C123","v":12.6},null,{"$f":"IF(B96<=$B$24,C123,\"\")","v":12.6}]
[]
["Qc_horizontal_2",{"$f":"E48","v":20},{"$f":"C96","v":12.6}]
[null,{"$f":"E96","v":45.2},{"$f":"C96","v":12.6}]
[]
["Qc_vertical_2",{"$f":"E96","v":45.2},0]
[null,{"$f":"B129","v":45.2},{"$f":"C96","v":12.6}]
[]
["Additional Info",{"$f":"'Compressor & IHX'!B2","v":"R454C"}]
[null,{"$f":"'Compressor & IHX'!A3&\" \"&'Compressor & IHX'!B3","v":"Drive 380-420 V / 3~ / 50 Hz"}]
[null,{"$f":"\"Compressor Input Power: \"&ROUND(C96-D96,1)&\" kW\"","v":"Compressor Input Power: 3,1 kW"},null,null,null,{"$f":"\"Compressor Input Power: \"&ROUND(C96-D96,1)&\" kW\"","v":"Compressor Input Power: 3,1 kW"}]
[null,{"$f":"'Compressor & IHX'!A36&\": \"&'Compressor & IHX'!B36","v":"Chosen Suction Temperature [°C]: 9"}]
[null,{"$f":"'Compressor & IHX'!A5&\": \"&'Compressor & IHX'!B5","v":"Table Subcooling [K]: 0"}]

{"sheet":"EVPS","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"CND-CMP","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Calculations EvpU-Cnd","index":7,"n_rows":131,"n_cols":6,"rows_kept":131,"cut":false,"hidden":false,"merged":[[28,0,32,0],[34,0,39,0],[43,0,45,0],[0,0,0,6],[10,0,14,0],[17,0,21,0],[86,0,88,0],[102,0,103,0],[52,0,56,0],[73,0,77,0],[79,0,84,0],[117,0,118,0],[120,0,121,0],[126,0,130,0],[105,0,106,0],[114,0,115,0]]}
["Evap Unit"]
["Compressor"]
["SST",{"$f":"'Compressor & IHX'!C127","v":-10},{"$f":"'Compressor & IHX'!D127","v":-5},{"$f":"'Compressor & IHX'!E127","v":0},{"$f":"'Compressor & IHX'!F127","v":5},{"$f":"'Compressor & IHX'!G127","v":13}]
["SST^2",{"$f":"B3^2","v":100},{"$f":"C3^2","v":25},0,25,169]
[]
[]
[]
[]
[]
["Compressor Cooling Capacity Characteristic Equation Coefficients","SDT","A2","A1","A0"]
["SDT",{"$f":"'Compressor & IHX'!B128","v":25},{"$f":"LINEST('Compressor & IHX'!C128:G128,$B$3:$F$4,1,0)","v":7.4628995253835243E-3},0.56923373398128618,16.157006724214959]
[null,{"$f":"'Compressor & IHX'!B129","v":32},{"$f":"LINEST('Compressor & IHX'!C129:G129,$B$3:$F$4,1,0)","v":7.0504431991593938E-3},0.52773152915817068,14.955537429266114]
[null,{"$f":"'Compressor & IHX'!B130","v":39},{"$f":"LINEST('Compressor & IHX'!C130:G130,$B$3:$F$4,1,0)","v":6.6379868729352157E-3},0.48635453564775816,13.7663090584836]
[null,{"$f":"'Compressor & IHX'!B131","v":46},{"$f":"LINEST('Compressor & IHX'!C131:G131,B3:F4,1,0)","v":6.2255305467110184E-3},0.44510275345004618,12.585806028156211]
[null,{"$f":"'Compressor & IHX'!B132","v":55},{"$f":"LINEST('Compressor & IHX'!C132:G132,B3:F4,1,0)","v":5.69522955585142E-3},0.39224873173695862,11.07517959377261]
[]
["Compressor Heat Rejection Capacity Characteristic Equation Coefficients","SDT","A2","A1","A0"]
["SDT",{"$f":"'Compressor & IHX'!B142","v":25},{"$f":"LINEST('Compressor & IHX'!C142:G142,$B$3:$F$4,1,0)","v":7.4628995253835243E-3},0.58416266323690358,18.519927715287743]
[null,{"$f":"'Compressor & IHX'!B143","v":32},{"$f":"LINEST('Compressor & IHX'!C143:G143,$B$3:$F$4,1,0)","v":7.0504431991593808E-3},0.5442654659158932,17.58472306125681]
[null,{"$f":"'Compressor & IHX'!B144","v":39},{"$f":"LINEST('Compressor & IHX'!C144:G144,$B$3:$F$4,1,0)","v":6.6379868729352157E-3},0.50782120274447107,16.83397820282158]
[null,{"$f":"'Compressor & IHX'!B145","v":46},{"$f":"LINEST('Compressor & IHX'!C145:G145,B3:F4,1,0)","v":6.2255305467110245E-3},0.4748298737226353,16.300073941004435]
[null,{"$f":"'Compressor & IHX'!B146","v":55},{"$f":"LINEST('Compressor & IHX'!C146:G146,B3:F4,1,0)","v":5.6952295558514165E-3},0.43748614985313883,15.984359898434553]
[]
[]
[]
["Evaporator"]
["SW Chosen Cooled Fluid Inlet Temperature [oC]",{"$f":"Evaporators!C1","v":1}]
[]
["Input Table","SST","dt","Qo"]
[null,{"$f":"B27","v":1},{"$f":"$B$27-B30","v":0},0]
[null,{"$f":"Evaporators!B5","v":-5},{"$f":"$B$27-B31","v":6},{"$f":"Evaporators!C5","v":1.6763999999999999}]
[null,{"$f":"Evaporators!B6","v":-9},{"$f":"$B$27-B32","v":10},{"$f":"Evaporators!C6","v":2.794}]
[null,{"$f":"Evaporators!B7","v":-15},{"$f":"$B$27-B33","v":16},{"$f":"Evaporators!C7","v":4.4703999999999997}]
[]
["Evaporator Characteristic Equation","k","q"]
[null,{"$f":"LINEST('Calculations EvpU-Cnd'!D30:D33,C30:C33,0,1)","v":0.27939999999999998},0]
[null,1.2949904338195412E-17,{"$error":"#N/A"}]
[null,1,2.5639502485114184E-16]
[null,4.6549999754027486E+32,3]
[null,30.601229119999996,1.9721522630525295E-31]
[]
["EFIT - SET_min [K]",{"$f":"B30-B33","v":16},null,{"$f":"Evaporators!#REF!","v":{"$error":"#REF!"}},{"$f":"B30-B33","v":16}]
[]
["Characteristic Calculated Data","to","Qo"]
[null,{"$f":"Evaporators!$B$18","v":1},0]
[null,{"$f":"B45-B42","v":-15},{"$f":"B36*(B45-B46)","v":4.4703999999999997}]
[]
["Axes crossing",20]
[]
["Considered Cooled Fluid Fnlet Temperature [oC]",{"$f":"Evaporators!B18","v":1}]
[]
["Evaporator Unit","SDT","SDT^2","SST_eqp","Qo","Qc"]
["Compressor-Evaporator Equilibrium Points",{"$f":"B18","v":25},{"$f":"B53^2","v":625},{"$f":"tbalancep($B$50,E11,D11,C11,$C$36,$B$36,\"Evp\")","v":-23.609375},{"$f":"E11+D11*D53+C11*D53^2","v":6.8775935446170235},{"$f":"E18+D18*D53+C18*D53^2","v":8.8880518465454657}]
[null,{"$f":"B19","v":32},{"$f":"B54^2","v":1024},{"$f":"tbalancep($B$50,E12,D12,C12,$C$36,$B$36,\"Evp\")","v":-22.671875},{"$f":"E12+D12*D54+C12*D54^2","v":6.6149000850788653},{"$f":"E19+D19*D54+C19*D54^2","v":8.8692303696405634}]
[null,{"$f":"B20","v":39},1521,{"$f":"tbalancep($B$50,E13,D13,C13,$C$36,$B$36,\"Evp\")","v":-21.6953125},{"$f":"E13+D13*D55+C13*D55^2","v":6.3391067908093017},{"$f":"E20+D20*D55+C20*D55^2","v":8.9410498841506278}]
[null,{"$f":"B21","v":46},2116,{"$f":"tbalancep($B$50,E14,D14,C14,$C$36,$B$36,\"Evp\")","v":-20.640625},{"$f":"E14+D14*D56+C14*D56^2","v":6.0509034068384464},{"$f":"E21+D21*D56+C21*D56^2","v":9.1515849778102627}]
[null,{"$f":"B22","v":55},3025,{"$f":"tbalancep($B$50,E15,D15,C15,$C$36,$B$36,\"Evp\")","v":-19.1953125},{"$f":"E15+D15*D57+C15*D57^2","v":5.6443070176413572},{"$f":"E22+D22*D57+C22*D57^2","v":9.6851409448700583}]
[]
[]
[null,"A2","A1","A0"]
["Evaporator Unit Cooling Capacity Characteristic Equation Coefficients",{"$f":"LINEST('Calculations EvpU-Cnd'!E53:E57,'Calculations EvpU-Cnd'!B53:C57,1,0)","v":-1.725350412864641E-4},-2.7221051851245875E-2,7.6646593575624467]
["Evaporator Unit Heat Rejection Capacity Characteristic Equation Coefficients",{"$f":"LINEST('Calculations EvpU-Cnd'!F53:F57,'Calculations EvpU-Cnd'!B53:C57,1,0)","v":1.4407313125088244E-3},-8.9323363445416026E-2,10.231568536700617]
[]
[]
[]
[]
[]
[]
[]
[]
["Condenser"]
["SW Chosen Cooling Fluid Inlet Temperature [oC]",{"$f":"Condenser!C1","v":35}]
[]
["Input Table","SDT","dt","Qo"]
[null,{"$f":"B72","v":35},{"$f":"B75-$B$72","v":0},0]
[null,{"$f":"Condenser!B5","v":42},{"$f":"B76-$B$72","v":7},{"$f":"Condenser!C5","v":8.6548000000000016}]
[null,{"$f":"Condenser!B6","v":46},{"$f":"B77-$B$72","v":11},{"$f":"Condenser!C6","v":13.600400000000002}]
[null,{"$f":"Condenser!B7","v":55},{"$f":"B78-$B$72","v":20},{"$f":"Condenser!C7","v":24.728000000000002}]
[]
["Condenser Characteristic Equation","k","q"]
[null,{"$f":"LINEST('Calculations EvpU-Cnd'!D75:D78,C75:C78,0,1)","v":1.2364000000000002},0]
[null,0,{"$error":"#N/A"}]
[null,1,0]
[null,{"$error":"#NUM!"},3]
[null,871.35042720000024,0]
[]
["Characteristic Calculated Data","SDT","Qc"]
[null,{"$f":"Condenser!$B$10","v":35},0]
[null,{"$f":"B88-(B75-B78)","v":55},{"$f":"B81*(B89-B88)","v":24.728000000000002}]
[]
["Evaporating Unit - Condenser Equilibrium Point","SDT_calc","Qc","Qo","SET=SST_calc"]
[null,{"$f":"ROUND(tbalancep(B88,D62,C62,B62,C81,B81,\"Cnd\"),1)","v":42.3},{"$f":"ROUND(D62+C62*B92+B62*B92^2,1)","v":9},{"$f":"ROUND(D61+C61*B92+B61*B92^2,1)","v":6.2},{"$f":"ROUND(B50-D92/B36,1)","v":-21.2}]
[]
[]
[]
[]
[]
[]
["Graph"]
["Graph Lines","t","Q"]
[]
[]
["SDT_vertical",{"$f":"B92","v":42.3},0]
[null,{"$f":"B103","v":42.3},{"$f":"C92","v":9}]
[]
["Qc_horizontal",{"$f":"B92","v":42.3},{"$f":"C92","v":9}]
[null,{"$f":"B48","v":20},{"$f":"C106","v":9}]
[]
[]
[]
[]
[]
[]
[]
["Qo_horizontal_1",{"$f":"B92","v":42.3},{"$f":"D92","v":6.2}]
[null,{"$f":"B48","v":20},{"$f":"C115","v":6.2}]
[]
["Qo_horizontal_2",{"$f":"B48","v":20},{"$f":"D92","v":6.2}]
[null,{"$f":"E92","v":-21.2},{"$f":"C118","v":6.2}]
[]
["SET=SST_calc_vertical",{"$f":"E92","v":-21.2},{"$f":"D92","v":6.2}]
[null,{"$f":"B121","v":-21.2},0]
[]
[]
[]
[]
["Additional Info",{"$f":"'Compressor & IHX'!B2","v":"R454C"}]
[null,{"$f":"'Compressor & IHX'!A3&\":  \"&'Compressor & IHX'!B3","v":"Drive:  380-420 V / 3~ / 50 Hz"}]
[null,{"$f":"\"Compressor Input Power: \"&ROUND(C92-D92,1)&\" kW\"","v":"Compressor Input Power: 2,8 kW"}]
[null,{"$f":"'Compressor & IHX'!A36&\": \"&'Compressor & IHX'!B36","v":"Chosen Suction Temperature [°C]: 9"}]
[null,{"$f":"'Compressor & IHX'!A5&\": \"&'Compressor & IHX'!B5","v":"Table Subcooling [K]: 0"}]