{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["aula","ana entrópica"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":1,"defined_names":2,"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":"aula","index":0,"n_rows":26,"n_cols":13,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Fluido","nitrogen"]
["P1",20,"bar",null,null,"xk",null,null,"fk",null,"QR","T3","T6"]
["T1",25,"°C",null,"QR",360.38631486160978,"kW","f1",{"$f":"F3-B22*([1]!enthalpy(B1,\"PT\",\"C\",B7/10,F4)-B9)","v":0},1,1,{"$f":"((F3-B22*([1]!enthalpy(B1,\"PT\",\"C\",B7/10,(F4+eps))-B9))-(F3-B22*([1]!enthalpy(B1,\"PT\",\"C\",B7/10,F4)-B9)))/eps","v":-1.121303210197766},0]
["h1",{"$f":"[1]!enthalpy($B$1,\"PT\",\"C\",B2/10,B3)","v":305.09854433364194},"kJ/kg",null,"T3",474.68827740456271,"°C","f2",{"$f":"F3-B22*(B19-[1]!enthalpy(B1,\"PT\",\"C\",B17/10,F5))","v":0},2,1,0,{"$f":"((F3-B22*(B19-[1]!enthalpy(B1,\"PT\",\"C\",B17/10,(F5+eps))))-(F3-B22*(B19-[1]!enthalpy(B1,\"PT\",\"C\",B17/10,F5))))/eps","v":1.060275759130036}]
["s1",{"$f":"[1]!entropy($B$1,\"PT\",\"C\",B2/10,B3)","v":5.9370549548163263},"kJ/kg/K",null,"T6",146.18261753806053,"°C","f3",{"$f":"(B18-F4)-(F5-B8)*EXP(B23/F3*((B18-F4)-(F5-B8)))","v":-5.5777604757167865E-13},3,{"$f":"(((B18-F4)-(F5-B8)*EXP(B23/(F3+eps)*((B18-F4)-(F5-B8))))-((B18-F4)-(F5-B8)*EXP(B23/F3*((B18-F4)-(F5-B8)))))/eps","v":5.114856364762943E-2},{"$f":"(((B18-(F4+eps))-(F5-B8)*EXP(B23/F3*((B18-(F4+eps))-(F5-B8))))-((B18-F4)-(F5-B8)*EXP(B23/F3*((B18-F4)-(F5-B8)))))/eps","v":2.9568171634624107},{"$f":"(((B18-F4)-((F5+eps)-B8)*EXP(B23/F3*((B18-F4)-((F5+eps)-B8))))-((B18-F4)-(F5-B8)*EXP(B23/F3*((B18-F4)-(F5-B8)))))/eps","v":-44.254492246905919}]
[]
["P2",{"$f":"B12","v":65},"bar",null,null,"xk+1",null,null,"dxk",null,"QR","T3","T6"]
["T2",{"$f":"[1]!Temperature($B$1,\"PS\",\"C\",B7/10,B10)","v":146.08406602021444},"°C",null,"QR",{"$f":"F3-I8","v":360.38631486160978},"kW","dQr",{"$f":"MMULT(K8:M10,I3:I5)","v":-1.255495718009282E-14},1,{"$f":"MINVERSE(K3:M5)","v":5.9354927699599824E-2},0.93949377147058699,2.250895719662363E-2]
["h2",{"$f":"[1]!enthalpy($B$1,\"PS\",\"C\",B7/10,B10)","v":430.47567790469691},"kJ/kg",null,"T3",{"$f":"F4-I9","v":474.68827740456271},"°C","dT3",-1.1196754870503297E-14,2,-0.83888556078823417,0.83785880832793391,2.0073925582228279E-2]
["s2",{"$f":"B5","v":5.9370549548163263},"kJ/kg/K",null,"T6",146.18261753806053,"°C","dT6",1.1841218731996899E-14,3,-5.5980651437604181E-2,5.7066501811810534E-2,-2.122934246378733E-2]
[]
["P4",65,"bar"]
["T4",750,"°C",null,"h1",{"$f":"B4","v":305.09854433364194},"kJ/kg","s1",{"$f":"B5","v":5.9370549548163263},"kJ/kg/K",null,"T1",{"$f":"B3","v":25}]
["h4",{"$f":"[1]!enthalpy($B$1,\"PT\",\"C\",B12/10,B13)","v":1107.4775039595445},"kJ/kg",null,"h2",{"$f":"B9","v":430.47567790469691},"kJ/kg","s2",{"$f":"B10","v":5.9370549548163263},"kJ/kg/K",null,"T2",{"$f":"B8","v":146.08406602021444}]
["s4",{"$f":"[1]!entropy($B$1,\"PT\",\"C\",B12/10,B13)","v":6.9308985181164404},"kJ/kg/K",null,"h3",{"$f":"[1]!enthalpy(B1,\"PT\",\"C\",B2/10,F9)","v":789.1033551532754},"kJ/kg","s3",{"$f":"[1]!entropy(B1,\"PT\",\"C\",B2/10,F9)","v":6.9238386589623229},"kJ/kg/K",null,"T3",{"$f":"F9","v":474.68827740456271}]
[null,null,null,null,"h4",{"$f":"B14","v":1107.4775039595445},"kJ/kg","s4",{"$f":"B15","v":6.9308985181164404},"kJ/kg/K",null,"T4",{"$f":"B13","v":750}]
["P5",{"$f":"B2","v":20},"bar",null,"h5",{"$f":"B19","v":794.39975654133036},"kJ/kg","s5",{"$f":"B20","v":6.9308985181164404},"kJ/kg/K",null,"T5",{"$f":"B18","v":479.44353194145094}]
["T5",{"$f":"[1]!Temperature($B$1,\"PS\",\"C\",B17/10,B20)","v":479.44353194145094},"°C",null,"h6",{"$f":"[1]!enthalpy(B1,\"PT\",\"C\",B17/10,F10)","v":434.0134416797207},"kJ/kg","s6",{"$f":"[1]!entropy(B1,\"PT\",\"C\",B17/10,F10)","v":6.3000031880428988},"kJ/kg/K",null,"T6",{"$f":"F10","v":146.18261753806053}]
["h5",{"$f":"[1]!enthalpy($B$1,\"PS\",\"C\",B17/10,B20)","v":794.39975654133036},"kJ/kg"]
["s5",{"$f":"B15","v":6.9308985181164404},"kJ/kg/K"]
[]
["m",1,"kg/s"]
["UA",300,"kW/k"]
["eps",1E-3,"-"]
[]
["macro = ","ctr + h","solve"]

{"sheet":"ana entrópica","index":1,"n_rows":27,"n_cols":19,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Fluido","carbon dioxide"]
["P1",20,"bar",null,null,"xk",null,null,"fk",null,"QR","T3","T6",null,"UA","sgen",null,"UA","dTln"]
["T1",25,"°C",null,"QR",365.31400940116032,"kW","f1",{"$f":"F3-B22*([1]!enthalpy(B1,\"PT\",\"C\",B7/10,F4)-B9)","v":0},1,1,{"$f":"((F3-B22*([1]!enthalpy(B1,\"PT\",\"C\",B7/10,(F4+eps))-B9))-(F3-B22*([1]!enthalpy(B1,\"PT\",\"C\",B7/10,F4)-B9)))/eps","v":-1.1894807901171589},0,null,1,3.2286393082239684E-2,null,1,101.947]
["h1",{"$f":"[1]!enthalpy($B$1,\"PT\",\"C\",B2/10,B3)","v":486.46890323779979},"kJ/kg",null,"T3",471.14207816002022,"°C","f2",{"$f":"F3-B22*(B19-[1]!enthalpy(B1,\"PT\",\"C\",B17/10,F5))","v":0},2,1,0,{"$f":"((F3-B22*(B19-[1]!enthalpy(B1,\"PT\",\"C\",B17/10,(F5+eps))))-(F3-B22*(B19-[1]!enthalpy(B1,\"PT\",\"C\",B17/10,F5))))/eps","v":1.0204849066894894},null,5,1.9184287056022598E-2,null,5,34.954000000000001]
["s1",{"$f":"[1]!entropy($B$1,\"PT\",\"C\",B2/10,B3)","v":2.1268666269519754},"kJ/kg/K",null,"T6",186.50622421873194,"°C","f3",{"$f":"(B18-F4)-(F5-B8)*EXP(B23/F3*((B18-F4)-(F5-B8)))","v":0},3,{"$f":"(((B18-F4)-(F5-B8)*EXP(B23/(F3+eps)*((B18-F4)-(F5-B8))))-((B18-F4)-(F5-B8)*EXP(B23/F3*((B18-F4)-(F5-B8)))))/eps","v":6.9009759890548139E-2},{"$f":"(((B18-(F4+eps))-(F5-B8)*EXP(B23/F3*((B18-(F4+eps))-(F5-B8))))-((B18-F4)-(F5-B8)*EXP(B23/F3*((B18-F4)-(F5-B8)))))/eps","v":0.29096020946894896},{"$f":"(((B18-F4)-((F5+eps)-B8)*EXP(B23/F3*((B18-F4)-((F5+eps)-B8))))-((B18-F4)-(F5-B8)*EXP(B23/F3*((B18-F4)-(F5-B8)))))/eps","v":-0.41568340525799385},null,10,1.1658999533450398E-2,null,10,19.186655140737582]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,6.5519927411070711E-3,null,20,10.083445349259623]
["P2",{"$f":"B12","v":100},"bar",null,null,"xk+1",null,null,"dxk",null,"QR","T3","T6",null,40,3.630569615747703E-3,null,40,5.1706140812453976]
["T2",{"$f":"[1]!Temperature($B$1,\"PS\",\"C\",B7/10,B10)","v":158.87307390785145},"°C",null,"QR",{"$f":"F3-I8","v":365.31400940116032},"kW","dQr",{"$f":"MMULT(K8:M10,I3:I5)","v":0},1,{"$f":"MINVERSE(K3:M5)","v":0.33928528041683137},0.56499545199450196,1.3870395686129149,null,60,2.6520151188460517E-3,null,60,3.4748293230022886]
["h2",{"$f":"[1]!enthalpy($B$1,\"PS\",\"C\",B7/10,B10)","v":582.97715996983061},"kJ/kg",null,"T3",{"$f":"F4-I9","v":471.14207816002022},"°C","dT3",0,2,-0.55546480874070359,0.47499333884900508,1.1660882463484739,null,100,1.9520700163688787E-3,null,100,2.0966330849268822]
["s2",{"$f":"B5","v":2.1268666269519754},"kJ/kg/K",null,"T6",186.50622421873194,"°C","dT6",0,3,-0.33247456987628743,0.42627239771402137,-1.3591965540309159,null,200,1.6208786121705288E-3,null,200,1.051068312050069]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,300,1.588283895957332E-3,null,300,0.7008921935096164]
["P4",100,"bar",null,null,null,null,null,null,null,null,null,null,null,400,1.5843045157204472E-3,null,400,0.52568382762847177]
["T4",750,"°C",null,null,null,{"$f":"B18","v":518.30330865328369},"T5",null,null,null,null,null,null,500,1.5843474733543417E-3,null,500,0.4205483540166246]
["h4",{"$f":"[1]!enthalpy($B$1,\"PT\",\"C\",B12/10,B13)","v":1290.1574587359303},"kJ/kg",null,"T3",{"$f":"F4","v":471.14207816002022},null,null,{"$f":"G13-F14","v":47.161230493263474},"delta",null,null,null,null,600,1.5843045157204472E-3,null,600,0.35045708027860339]
["s4",{"$f":"[1]!entropy($B$1,\"PT\",\"C\",B12/10,B13)","v":3.1530896100264703},"kJ/kg/K",null,null,null,null,null,null,null,null,null,null,null,700,1.5843045157204472E-3,null,700,0.30039179400464427]
[null,null,null,null,null,null,{"$f":"F5","v":186.50622421873194},"T6",null,null,null,null,null,null,800,1.5843045157204472E-3,null,800,0.26284281930536307]
["P5",{"$f":"B2","v":20},"bar",null,"T2",{"$f":"B8","v":158.87307390785145},null,null,{"$f":"G16-F17","v":27.633150310880495},"delta",null,null,null,null,900,1.5843045157204472E-3,null,900,0.23363805040362401]
["T5",{"$f":"[1]!Temperature($B$1,\"PS\",\"C\",B17/10,B20)","v":518.30330865328369},"°C",null,null,null,null,null,null,null,null,null,null,null,1000,1.5842991993046951E-3,null,1000,0.21027430085239648]
["h5",{"$f":"[1]!enthalpy($B$1,\"PS\",\"C\",B17/10,B20)","v":1012.9276723266198},"kJ/kg"]
["s5",{"$f":"B15","v":3.1530896100264703},"kJ/kg/K",null,"h3",{"$f":"[1]!enthalpy($B$1,\"PT\",\"C\",B7/10,F9)","v":948.29116937099093},null,"w12",{"$f":"B4-B9","v":-96.508256732030816}]
[null,null,null,null,"s3",{"$f":"[1]!entropy($B$1,\"PT\",\"C\",B7/10,F9)","v":2.7635778904188801},null,"w45",{"$f":"B14-B19","v":277.22978640931046}]
["m",1,"kg/s",null,null,null,null,null,null,null,{"$f":"(I23+I24)-(I20+I21)","v":0}," = balanço energia"]
["UA",10,"kW/k",null,"h6",{"$f":"[1]!enthalpy($B$1,\"PT\",\"C\",B2/10,F10)","v":647.61366292545961},null,"q34",{"$f":"B14-F20","v":341.86628936493935},null,{"$f":"-(B10+B20)+(F21+F24)","v":4.2225817808702715E-2}," = balanço de entropia"]
["eps",1E-3,"-",null,"s6",{"$f":"[1]!entropy($B$1,\"PT\",\"C\",B2/10,F10)","v":2.5586041643682682},null,"q61",{"$f":"B4-F23","v":-161.14475968765981}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"((B18-F9)-(F10-B8))/LN((B18-F9)/(F10-B8))","v":36.531400940116022}," = deltaTln"]
[null,null,null,null,null,null,null,"q23",{"$f":"F20-B9","v":365.31400940116032}]
[null,null,null,null,null,null,null,"q56",{"$f":"F23-B19","v":-365.31400940116021}]