{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Berechnung","Änderungen","Anleitung"],"not_rendered":{"charts":9,"images":5,"macros":1,"external_links":0,"defined_names":0,"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":"Berechnung","index":0,"n_rows":103,"n_cols":36,"rows_kept":103,"cut":false,"hidden":false,"merged":[[53,0,53,4],[71,0,71,4],[72,0,72,4],[70,0,70,4],[66,0,66,4],[67,0,67,4],[68,0,68,4],[69,0,69,4],[64,0,65,4],[103,1,103,4],[75,0,75,4],[74,0,74,4],[73,0,73,4],[76,0,77,4],[47,0,49,4],[41,0,41,4],[42,0,42,4],[50,0,50,4],[52,0,52,3],[51,0,51,3],[45,0,46,4],[44,0,44,4],[59,17,59,33],[59,8,59,15],[58,12,58,14],[58,17,58,24],[54,1,54,2],[55,1,55,2],[56,1,56,2],[57,1,57,2],[58,1,58,2],[64,7,64,15],[13,30,13,32],[13,12,13,14],[58,8,58,10],[91,26,91,33],[64,16,64,24],[64,25,64,33],[91,17,91,24],[91,7,92,7],[76,7,76,15],[91,8,91,15],[44,7,58,7],[60,7,63,33],[59,0,59,7],[40,0,40,4],[58,26,58,33],[0,1,0,4],[13,17,13,19],[13,21,13,23],[13,26,13,28],[1,26,1,33],[0,31,0,33],[11,0,12,1],[13,0,14,4],[1,7,2,7],[1,8,1,15],[1,17,1,24],[0,18,0,30],[29,7,43,7],[13,8,13,10],[13,7,28,7],[1,0,1,3],[26,0,26,4],[27,0,29,4],[39,0,39,4],[34,0,38,4],[43,0,43,4],[15,0,16,4],[17,0,18,4],[19,0,20,4]]}
[1,{"$f":"IF(A1=0,\"Datenanzeige nach Aperturfläche aktiv \",\"Datenanzeige nach Bruttofläche aktiv \")","v":"Datenanzeige nach Bruttofläche aktiv "},null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"Solartirol Tool (für Kollektorvergleich mit Kollektordaten aus Prüfberichten) ",null,null,null,null,null,null,null,null,null,null,null,null,"Version 17"]
[{"$f":"IF(A1=0,\"eingestellte Aperturfläche > \",\"eingestellte Bruttofläche > \")","v":"eingestellte Bruttofläche > "},null,null,null,18,null,null,"Str.  (W/m²)","Gesamtleistung nach eingetr. Strahlung und Diff. der ges. einget. Modulfl. (in kW)",null,null,null,null,null,null,null,null,"Gesamtleistung nach eingetr. Strahlung und Diff. der ges. einget. Modulfl. (in kW)",null,null,null,null,null,null,null,null,"Gesamtleistung nach eingetr. Strahlung und Diff. der ges. einget. Modulfl. (in kW)"]
["Absorberanteil (%)",{"$f":"IF(AND(B4>0,B5>0),B5/(B4/100),\"\")","v":54.577259475218654},{"$f":"IF(AND(C4>0,C5>0),C5/(C4/100),\"\")","v":94.170854271356788},91.571753986332581,86.778042959427196,null,null,null,{"$f":"$B$6","v":"Felzen VRK"},"Wirk.(%)",{"$f":"$C$6","v":"Synox FK"},"Wirk.(%)",{"$f":"$D$6","v":"CPC40VRK"},"Wirk.(%)",{"$f":"$E$6","v":"Hewalex FK"},"Wirk.(%)",null,{"$f":"$B$6","v":"Felzen VRK"},"Wirk.(%)",{"$f":"$C$6","v":"Synox FK"},"Wirk.(%)",{"$f":"$D$6","v":"CPC40VRK"},"Wirk.(%)",{"$f":"$E$6","v":"Hewalex FK"},"Wirk.(%)",null,{"$f":"$B$6","v":"Felzen VRK"},"Wirk.(%)",{"$f":"$C$6","v":"Synox FK"},"Wirk.(%)",{"$f":"$D$6","v":"CPC40VRK"},"Wirk.(%)",{"$f":"$E$6","v":"Hewalex FK"},"Wirk.(%)"]
["Modulfl. (Br. m²)",1.7150000000000001,1.99,4.3899999999999997,2.0950000000000002,{"$f":"COUNT(B4:E4)","v":4},null,100,{"$f":"IF($A$1>0,(H4*(J4)/100000)*$E$2,(H4*(J4)/100000)*$E$2)","v":0.12368298542274057},{"$f":"IF($A$1>0,I67,J67)","v":6.8712769679300321},{"$f":"IF($A$1>0,(H4*(L4)/100000)*$E$2,(H4*(L4)/100000)*$E$2)","v":-0.66413053266331668},{"$f":"IF($A$1>0,K67,L67)","v":-36.896140703517595},{"$f":"IF($A$1>0,(H4*(N4)/100000)*$E$2,(H4*(N4)/100000)*$E$2)","v":0.65536072892938502},{"$f":"IF($A$1>0,M67,N67)","v":36.408929384965838},{"$f":"IF($A$1>0,(H4*(P4)/100000)*$E$2,(H4*(P4)/100000)*$E$2)","v":-0.62214650119331716},{"$f":"IF($A$1>0,O67,P67)","v":-34.563694510739843},null,{"$f":"IF($A$1>0,(H4*(S4)/100000)*$E$2,(H4*(S4)/100000)*$E$2)","v":-0.14067834402332374},{"$f":"IF($A$1>0,R67,S67)","v":-7.8154635568513182},{"$f":"IF($A$1>0,(H4*(U4)/100000)*$E$2,(H4*(U4)/100000)*$E$2)","v":-1.414031879396985},{"$f":"IF($A$1>0,T67,U67)","v":-78.557326633165843},{"$f":"IF($A$1>0,(H4*(W4)/100000)*$E$2,(H4*(W4)/100000)*$E$2)","v":0.4958061047835991},{"$f":"IF($A$1>0,V67,W67)","v":27.544783599088838},{"$f":"IF($A$1>0,(H4*(Y4)/100000)*$E$2,(H4*(Y4)/100000)*$E$2)","v":-1.288966338902148},{"$f":"IF($A$1>0,X67,Y67)","v":-71.609241050119337},null,{"$f":"IF($A$1>0,(H4*(AB4)/100000)*$E$2,(H4*(AB4)/100000)*$E$2)","v":-0.43765504373177833},{"$f":"IF($A$1>0,AA67,AB67)","v":-24.314169096209909},{"$f":"IF($A$1>0,(H4*(AD4)/100000)*$E$2,(H4*(AD4)/100000)*$E$2)","v":-2.201902914572865},{"$f":"IF($A$1>0,AC67,AD67)","v":-122.3279396984925},{"$f":"IF($A$1>0,(H4*(AF4)/100000)*$E$2,(H4*(AF4)/100000)*$E$2)","v":0.32306514806378139},{"$f":"IF($A$1>0,AE67,AF67)","v":17.948063781321189},{"$f":"IF($A$1>0,(H4*(AH4)/100000)*$E$2,(H4*(AH4)/100000)*$E$2)","v":-1.9767170405727923},{"$f":"IF($A$1>0,AG67,AH67)","v":-109.81761336515513}]
["Absorberfläche (m²)",0.93600000000000005,1.8740000000000001,4.0199999999999996,1.8180000000000001,{"$f":"COUNT(B5:E5)","v":4},null,200,{"$f":"IF($A$1>0,(H5*(J5)/100000)*$E$2,(H5*(J5)/100000)*$E$2)","v":0.8447577376093296},{"$f":"IF($A$1>0,I68,J68)","v":23.465492711370267},0.69362484422110571,{"$f":"IF($A$1>0,K68,L68)","v":19.267356783919602},1.7102673348519357,{"$f":"IF($A$1>0,M68,N68)","v":47.507425968109331},0.63058132696897407,{"$f":"IF($A$1>0,O68,P68)","v":17.516147971360393},null,0.58039640816326532,{"$f":"IF($A$1>0,R68,S68)","v":16.122122448979592},-5.6276502512563012E-2,{"$f":"IF($A$1>0,T68,U68)","v":-1.5632361809045281},1.55071271070615,{"$f":"IF($A$1>0,V68,W68)","v":43.075353075170831},-3.6238510739856733E-2,{"$f":"IF($A$1>0,X68,Y68)","v":-1.0066252983293538},null,0.28341970845481046,{"$f":"IF($A$1>0,AA68,AB68)","v":7.8727696793002915},-0.8441475376884422,{"$f":"IF($A$1>0,AC68,AD68)","v":-23.448542713567839},1.3779717539863328,{"$f":"IF($A$1>0,AE68,AF68)","v":38.276993166287021},-0.72398921241050096,{"$f":"IF($A$1>0,AG68,AH68)","v":-20.110811455847248}]
["Kollekt.Name (SPF C Nr.)","Felzen VRK","Synox FK","CPC40VRK","Hewalex FK",null,null,300,1.5658324897959177,28.996897959183659,2.0513802211055281,37.988522613065328,2.7651739407744875,51.206924829157174,1.8833091551312648,34.876095465393789,null,1.3014711603498539,24.101317784256555,1.3014788743718593,24.101460636515917,2.6056193166287009,48.252209567198172,1.2164893174224347,22.52757995226731,null,1.0044944606413992,18.601749271137024,0.51360783919597996,9.5112562814070358,2.4328783599088837,45.05330296127562,0.52873861575179026,9.7914558472553761]
["η0  Abs. (z.B. 0,798)",0.73399999999999999,0.80100000000000005,0.64,0.80200000000000005,null,null,400,2.2869072419825072,31.762600583090375,3.40913559798995,47.349105527638194,3.8200805466970404,53.05667425968111,3.1360369832935566,43.556069212410513,null,2.0225459125364429,28.090915451895039,2.6592342512562812,36.933809045226127,3.6605259225512534,50.840637813211849,2.4692171455847256,34.294682577565631,null,1.7255692128279883,23.966239067055394,1.8713632160804028,25.99115577889448,3.4877849658314362,48.441457858769944,1.7814664439140819,24.742589498806691]
["a1 Abs. (z.B. 1,52)",1.5289999999999999,3.64,0.68799999999999994,3.8,{"$f":"COUNT(#REF!)","v":0},null,500,3.0079819941690964,33.422022157434405,4.7668909748743724,52.965455276381917,4.8749871526195898,54.166523917995448,4.3887648114558475,48.764053460620524,null,2.7436206647230321,30.48467405247813,4.0169896281407045,44.633218090452274,4.715432528473805,52.393694760820047,3.7219449737470165,41.354944152744622,null,2.446643965014577,27.184932944606409,3.2291185929648241,35.87909547738694,4.542691571753986,50.47435079726651,3.0341942720763724,33.713269689737473]
["a2 Abs. (z.B. 0,0143)",1.66E-2,1.12E-2,4.0000000000000001E-3,6.7000000000000002E-3,null,null,600,3.7290567463556843,34.52830320699708,6.1246463517587939,56.709688442211061,5.9298937585421427,54.906423690205017,5.6414926396181384,52.236042959427209,null,3.4646954169096209,32.080513119533528,5.374745005025126,49.766157453936351,5.7703391343963553,53.429066059225512,4.9746728019093069,46.061785202863952,null,3.1677187172011658,29.330728862973757,4.5868739698492469,42.471055276381918,5.597598177676538,51.829612756264247,4.2869221002386633,39.693723150357997]
["Winkelfaktor (IAM)",1.37,0.95,0.96,0.94,null,null,700,4.450131498542274,35.318503956684715,7.4824017286432163,59.384140703517595,6.984800364464693,55.43492352749756,6.8942204677804302,54.716035458574844,null,4.1857701690962097,33.220398167430233,6.7325003819095501,53.432542713567862,6.8252457403189064,54.168616986657987,6.2274006300715996,49.423814524377775,null,3.8887934693877546,30.863440233236147,5.9446293467336684,47.179597989949755,6.65250478359909,52.797657012691182,5.539649928400955,43.965475622229803]
["max.Peak lt.Test",687,1501,null,1458,null,null,800,5.1712062507288632,35.91115451895044,8.8401571055276396,61.389979899497497,8.0397069703872432,55.831298405466967,8.1469482959427193,56.576029832935554,null,4.9068449212827989,34.075311953352767,8.0902557587939725,56.182331658291467,7.8801523462414576,54.723280182232344,7.4801284582338914,51.945336515513134,null,4.6098682215743443,32.012973760932944,7.3023847236180917,50.71100502512563,7.707411389521643,53.523690205011405,6.7923777565632468,47.169289976133655]
["Bruttoflächenrechner",null,"Länge","Breite","Brutto",null,null,900,5.8922810029154533,36.372104956268231,10.197912482412066,62.950077051926328,9.0946135763097953,56.139589977220957,9.399676124105012,58.022692124105014,null,5.6279196734693873,34.74024489795918,9.448011135678394,58.321056393076503,8.9350589521640096,55.154684889901297,8.7328562863961814,53.90652028639618,null,5.3309429737609317,32.907055393585999,8.6601401005025167,53.457654941373555,8.7623179954441941,54.088382687927115,8.0451055847255386,49.661145584725546]
[null,null,null,null,{"$f":"IF(AND(C13>0,D13>0),C13*D13,\"\")","v":""},null,null,1000,6.6133557551020434,36.740865306122458,11.555667859296488,64.198154773869376,10.149520182232344,56.38622323462414,10.652403952267303,59.180021957040573,null,6.3489944256559765,35.272191253644316,10.805766512562814,60.032036180904527,9.9899655580865598,55.49980865603645,9.9855841145584723,55.475467303102626,null,6.0520177259475227,33.622320699708453,10.017895477386936,55.654974874371867,9.8172246013667426,54.540136674259678,9.2978334128878313,51.654630071599058]
[{"$f":"IF(F4<F5,\"eine Bruttofl. fehlt ! (keine Bruttoberechnung möglich)\",\"\")","v":""},null,null,null,null,null,null,"BRUTTOBERECHNUNG","eingest. Fläche (m²)",null,null,{"$f":"E2","v":18},"eingest. Differenz (K)",null,null,30,null,"eingest. Fläche (m²)",null,null,{"$f":"E2","v":18},"eingestellte Diff. (K)",null,null,40,null,"eingest. Fläche (m²)",null,null,{"$f":"E2","v":18},"eingestellte Diff. (K)",null,null,50]
[]
[{"$f":"IF(F4>F5,\"eine Abs.Fläche fehlt ! (keine Berechnung möglich)\",\"\")","v":""}]
[]
[{"$f":"IF($O$1=1,\"Winkelberechnung aktiv (mit eingetragenen IAM)\",\"Direktbestrahlung aktiv (ohne IAM)\")","v":"Direktbestrahlung aktiv (ohne IAM)"}]
[]
[{"$f":"IF($A$1=1,\"Daten n. Bruttofläche aktiv\",\"Daten n. Aperturfläche aktiv\")","v":"Daten n. Bruttofläche aktiv"}]
[]
[]
[]
[]
[]
[]
[]
["Hinweise"]
[]
[null,null,null,null,null,null,null,"ABSORBERBERECHNUNG"]
[]
[]
[]
[]
["Es können FK und VRK miteinander verglichen werden, die Daten müßen nach gleichen Flächenbezug eingetragen werden (mit Absorber oder Aperturfläche) und es muß die Modulbruttofläche eingetragen werden !"]
[]
[]
[]
[]
["Formelbasis (SPF)        η(x) = η0 – a1 * x – a2 * G * x²\nmit x = (Tm – Ta) / G"]
["zu den SPF Kollektordaten (C Nr. eingeben und Factsheet pdf öffnen)"]
["Keymark zertifizierte Sonnenkollektoren"]
["Kollektortestberichte ITW Stuttgart"]
["Keymarkliste"]
["Fehler (auch Anregungen) bitte melden ! (hier klicken)",null,null,null,null,null,null,"NACH SPF METHODE "]
["www.solartirol.at"]
[]
["es werden beim Diagramm unten links immer alle 4 Kollektoren mit gleicher Modulfl. (Brutto) gerechnet !"]
[]
[]
["Leistung b.gleicher Modulfl. u. fixer Diff. und fixer Strahlung (SPF)"]
["Modulfläche Brutto (m²)",null,null,null,2.0950000000000002]
["Fixstrahlung W/m²",null,null,null,1000]
["Max.Peak Werte bei 1000W/m² Bestrahlung und Diff 0"]
["Soll max. Peak ","Kollektor",null,"pro m²","pro Modul"]
[{"$f":"IF(B11>0,B11,\"\")","v":687},{"$f":"B6","v":"Felzen VRK"},null,{"$f":"IF(I86>0,(I86/$E$52)*1000,\"\")","v":400.59708454810499},{"$f":"IF(D56>0,D56*B4,\"\")","v":687.02400000000011}]
[{"$f":"IF(C11>0,C11,\"\")","v":1501},{"$f":"C6","v":"Synox FK"},null,{"$f":"IF(K86>0,(K86/$E$52)*1000,\"\")","v":754.30854271356782},{"$f":"IF(D57>0,D57*C4,\"\")","v":1501.0739999999998}]
[{"$f":"IF(D11>0,D11,\"\")","v":""},{"$f":"D6","v":"CPC40VRK"},null,{"$f":"IF(M86>0,(M86/$E$52)*1000,\"\")","v":586.05922551252831},{"$f":"IF(D58>0,D58*D4,\"\")","v":2572.7999999999993}]
[{"$f":"IF(E11>0,E11,\"\")","v":1458},{"$f":"E6","v":"Hewalex FK"},null,{"$f":"IF(O86>0,(O86/$E$52)*1000,\"\")","v":695.95990453460615},{"$f":"IF(D59>0,D59*E4,\"\")","v":1458.0360000000001},null,null,null,"eingest. Fläche (m²)",null,null,{"$f":"E52","v":2.0950000000000002},"eingestellte Strahlung (W/m²)",null,null,{"$f":"E53","v":1000},null," Diagramm nach Wirkungsgrad (Brutto)",null,null,null,null,null,null,null,null," Diagramm nach Wirkungsgrad (nach Absorberfläche)"]
["Kollektordaten bei Solartirol",null,null,null,null,null,null,null,"Passwort \" solartirol \"",null,null,null,null,null,null,null,null,"Diagrammnachbildung der Daten von ITW Stuttgard (pdf)"]
[]
[]
[]
[]
["Bruttoberechnung",null,null,null,null,null,null,"Wirkungsgrad bei eingetragener Strahlung und Diff. (in%)",null,null,null,null,null,null,null,null,"Wirkungsgrad bei eingetragener Strahlung und Diff. (in%)",null,null,null,null,null,null,null,null,"Wirkungsgrad bei eingetragener Strahlung und Diff. (in%)"]
[null,null,null,null,null,null,null,"W/m²","Kol1 n. Brutto","Kol1 n. Absorb.","Kol2 n. Brutto","Kol2 n. Absorb.","Kol3 n. Brutto","Kol3 n. Absorb.","Kol4 n. Brutto","Kol4 n. Absorb.","W/m²","Kol1 n. Brutto","Kol1 n. Absorb.","Kol2 n. Brutto","Kol2 n. Absorb.","Kol3 n. Brutto","Kol3 n. Absorb.","Kol4 n. Brutto","Kol4 n. Absorb.","W/m²","Kol1 n. Brutto","Kol1 n. Absorb.","Kol2 n. Brutto","Kol2 n. Absorb.","Kol3 n. Brutto","Kol3 n. Absorb.","Kol4 n. Brutto","Kol4 n. Absorb."]
["Strahlung 1 (W/m²)",null,null,null,null,null,null,100,{"$f":"IF($B$92=1,(I94*100000)/(H67*$E$2),\"\")","v":6.8712769679300321},{"$f":"($B$101*$B$7-($B$8*D79)-(($B$9*H67*(D79*D79))))*100","v":12.590000000000007},{"$f":"IF($C$92=1,(K94*100000)/(H67*$E$2),\"\")","v":-36.896140703517595},{"$f":"($C$101*$C$7-($C$8*D79)-(($C$9*H67*(D79*D79))))*100","v":-39.180000000000007},{"$f":"IF($D$92=1,(M94*100000)/(H67*$E$2),\"\")","v":36.408929384965838},{"$f":"($D$101*$D$7-($D$8*D79)-(($D$9*H67*(D79*D79))))*100","v":39.760000000000005},{"$f":"IF($E$92=1,(O94*100000)/(H67*$E$2),\"\")","v":-34.563694510739843},{"$f":"($E$101*$E$7-($E$8*D79)-(($E$9*H67*(D79*D79))))*100","v":-39.829999999999984},100,{"$f":"IF($B$92=1,(R94*100000)/(H67*$E$2),\"\")","v":-7.8154635568513182},{"$f":"($B$101*$B$7-($B$8*AI67)-(($B$9*Q67*(AI67*AI67))))*100","v":-14.320000000000011},{"$f":"IF($C$92=1,(T94*100000)/(H67*$E$2),\"\")","v":-78.557326633165843},{"$f":"($C$101*$C$7-($C$8*AI67)-(($C$9*Q67*(AI67*AI67))))*100","v":-83.420000000000016},{"$f":"IF($D$92=1,(V94*100000)/(H67*$E$2),\"\")","v":27.544783599088838},{"$f":"($D$101*$D$7-($D$8*AI67)-(($D$9*Q67*(AI67*AI67))))*100","v":30.080000000000002},{"$f":"IF($E$92=1,(X94*100000)/(H67*$E$2),\"\")","v":-71.609241050119337},{"$f":"($E$101*$E$7-($E$8*AI67)-(($E$9*Q67*(AI67*AI67))))*100","v":-82.52000000000001},100,{"$f":"IF($B$92=1,(AA94*100000)/(H67*$E$2),\"\")","v":-24.314169096209909},{"$f":"($B$101*$B$7-($B$8*AJ67)-(($B$9*Z67*(AJ67*AJ67))))*100","v":-44.55},{"$f":"IF($C$92=1,(AC94*100000)/(H67*$E$2),\"\")","v":-122.3279396984925},{"$f":"($C$101*$C$7-($C$8*AJ67)-(($C$9*Z67*(AJ67*AJ67))))*100","v":-129.9},{"$f":"IF($D$92=1,(AE94*100000)/(H67*$E$2),\"\")","v":17.948063781321189},{"$f":"($D$101*$D$7-($D$8*AJ67)-(($D$9*Z67*(AJ67*AJ67))))*100","v":19.600000000000005},{"$f":"IF($E$92=1,(AG94*100000)/(H67*$E$2),\"\")","v":-109.81761336515513},{"$f":"($E$101*$E$7-($E$8*AJ67)-(($E$9*Z67*(AJ67*AJ67))))*100","v":-126.54999999999998},{"$f":"$Y$14/Q67","v":0.4},{"$f":"$AH$14/Z67","v":0.5}]
["Strahlung 2 (W/m²)",null,null,null,null,null,null,200,{"$f":"IF($B$92=1,(I95*100000)/(H68*$E$2),\"\")","v":23.465492711370267},42.995000000000005,{"$f":"IF($C$92=1,(K95*100000)/(H68*$E$2),\"\")","v":19.267356783919602},20.46,{"$f":"IF($D$92=1,(M95*100000)/(H68*$E$2),\"\")","v":47.507425968109331},51.88,{"$f":"IF($E$92=1,(O95*100000)/(H68*$E$2),\"\")","v":17.516147971360393},20.185000000000009,200,{"$f":"IF($B$92=1,(R95*100000)/(H68*$E$2),\"\")","v":16.122122448979592},29.539999999999996,{"$f":"IF($C$92=1,(T95*100000)/(H68*$E$2),\"\")","v":-1.5632361809045281},-1.6600000000000059,{"$f":"IF($D$92=1,(V95*100000)/(H68*$E$2),\"\")","v":43.075353075170831},47.039999999999992,{"$f":"IF($E$92=1,(X95*100000)/(H68*$E$2),\"\")","v":-1.0066252983293538},-1.1599999999999979,200,{"$f":"IF($B$92=1,(AA95*100000)/(H68*$E$2),\"\")","v":7.8727696793002915},14.425000000000002,{"$f":"IF($C$92=1,(AC95*100000)/(H68*$E$2),\"\")","v":-23.448542713567839},-24.9,{"$f":"IF($D$92=1,(AE95*100000)/(H68*$E$2),\"\")","v":38.276993166287021},41.800000000000004,{"$f":"IF($E$92=1,(AG95*100000)/(H68*$E$2),\"\")","v":-20.110811455847248},-23.17499999999999,0.2,0.25]
["Strahlung 3 (W/m²)",null,null,null,null,null,null,300,28.996897959183659,53.129999999999988,37.988522613065328,40.339999999999996,51.206924829157174,55.92,34.876095465393789,40.190000000000005,300,24.101317784256555,44.16,24.101460636515917,25.593333333333334,48.252209567198172,52.693333333333335,22.52757995226731,25.960000000000012,300,18.601749271137024,34.083333333333329,9.5112562814070358,10.100000000000003,45.05330296127562,49.2,9.7914558472553761,11.28333333333334,0.13333333333333333,0.16666666666666666]
["Strahlung 4 (W/m²)",null,null,null,null,null,null,400,31.762600583090375,58.197500000000005,47.349105527638194,50.28,53.05667425968111,57.940000000000005,43.556069212410513,50.192500000000017,400,28.090915451895039,51.469999999999992,36.933809045226127,39.22,50.840637813211849,55.52,34.294682577565631,39.520000000000003,400,23.966239067055394,43.912500000000001,25.99115577889448,27.6,48.441457858769944,52.900000000000006,24.742589498806691,28.512500000000006,0.1,0.125]
["Strahlung 5 (W/m²)",null,null,null,null,null,null,500,33.422022157434405,61.238000000000007,52.965455276381917,56.244000000000007,54.166523917995448,59.152000000000001,48.764053460620524,56.19400000000001,500,30.48467405247813,55.855999999999995,44.633218090452274,47.396000000000008,52.393694760820047,57.216000000000001,41.354944152744622,47.656000000000006,500,27.184932944606409,49.809999999999995,35.87909547738694,38.1,50.47435079726651,55.120000000000005,33.713269689737473,38.85,0.08,0.1]
["Strahlung 6 (W/m²)",null,null,null,null,null,null,600,34.52830320699708,63.264999999999993,56.709688442211061,60.22,54.906423690205017,59.96,52.236042959427209,60.195000000000007,600,32.080513119533528,58.78,49.766157453936351,52.846666666666664,53.429066059225512,58.346666666666671,46.061785202863952,53.080000000000005,600,29.330728862973757,53.741666666666667,42.471055276381918,45.100000000000009,51.829612756264247,56.599999999999994,39.693723150357997,45.741666666666674,6.6666666666666666E-2,8.3333333333333329E-2]
["Strahlung 7 (W/m²)",null,null,null,null,null,null,700,35.318503956684715,64.712857142857146,59.384140703517595,63.06,55.43492352749756,60.537142857142854,54.716035458574844,63.052857142857157,700,33.220398167430233,60.868571428571428,53.432542713567862,56.740000000000009,54.168616986657987,59.154285714285713,49.423814524377775,56.954285714285724,700,30.863440233236147,56.55,47.179597989949755,50.1,52.797657012691182,57.657142857142865,43.965475622229803,50.664285714285725,5.7142857142857141E-2,7.1428571428571425E-2]
["Strahlung 8 (W/m²)",null,null,null,null,null,null,800,35.91115451895044,65.798749999999998,61.389979899497497,65.190000000000012,55.831298405466967,60.97,56.576029832935554,65.196250000000006,800,34.075311953352767,62.434999999999995,56.182331658291467,59.660000000000004,54.723280182232344,59.760000000000005,51.945336515513134,59.860000000000014,800,32.012973760932944,58.65625,50.71100502512563,53.849999999999994,53.523690205011405,58.45,47.169289976133655,54.356249999999996,0.05,6.25E-2]
["Strahlung 9 (W/m²)",null,null,null,null,null,null,900,36.372104956268231,66.643333333333345,62.950077051926328,66.846666666666678,56.139589977220957,61.306666666666665,58.022692124105014,66.86333333333333,900,34.74024489795918,63.653333333333329,58.321056393076503,61.931111111111115,55.154684889901297,60.231111111111112,53.90652028639618,62.120000000000012,900,32.907055393585999,60.294444444444437,53.457654941373555,56.76666666666668,54.088382687927115,59.06666666666667,49.661145584725546,57.227777777777789,4.4444444444444446E-2,5.5555555555555552E-2]
["Strahlung 10 (W/m²)",null,null,null,null,null,null,1000,36.740865306122458,67.319000000000003,64.198154773869376,68.172000000000011,56.38622323462414,61.576000000000001,59.180021957040573,68.197000000000003,1000,35.272191253644316,64.628,60.032036180904527,63.74799999999999,55.49980865603645,60.608000000000004,55.475467303102626,63.928000000000004,1000,33.622320699708453,61.604999999999997,55.654974874371867,59.099999999999994,54.540136674259678,59.56,51.654630071599058,59.525000000000006,0.04,0.05]
["Berechnung nach SPF Diagramm",null,null,null,null,null,null,"Wirkungsgrad nach SPF bei eingetragener Fixstrahlung und Differenz (in %)"]
[null,null,null,null,null,null,null,"Diff.","Br.(%)","Abs. (%)","Br.(%)","Abs. (%)","Br.(%)","Abs. (%)","Br.(%)","Abs. (%)"]
[null,null,null,{"$f":"$P$14/H67","v":0.3},{"$f":"H79/$E$53","v":0},null,null,0,{"$f":"IF($B$92=1,(I86*100000)/($E$53*$E$52),\"\")","v":40.059708454810504},{"$f":"IF($B$7>0,($B$101*$B$7-($B$8*E79)-(($B$9*$E$53*(E79*E79))))*100,\"\")","v":73.400000000000006},{"$f":"IF($C$92=1,(K86*100000)/($E$53*$E$52),\"\")","v":75.430854271356793},{"$f":"IF($C$7>0,($C$101*$C$7-($C$8*E79)-(($C$9*$E$53*(E79*E79))))*100,\"\")","v":80.100000000000009},{"$f":"IF($D$92=1,(M86*100000)/($E$53*$E$52),\"\")","v":58.605922551252839},{"$f":"IF($D$7>0,($D$101*$D$7-($D$8*E79)-(($D$9*$E$53*(E79*E79))))*100,\"\")","v":64},{"$f":"IF($E$92=1,(O86*100000)/($E$53*$E$52),\"\")","v":69.595990453460615},{"$f":"IF($E$7>0,($E$101*$E$7-($E$8*E79)-(($E$9*$E$53*(E79*E79))))*100,\"\")","v":80.2}]
[null,null,null,0.15,0.02,null,null,20,{"$f":"IF($B$92=1,(I87*100000)/($E$53*$E$52),\"\")","v":38.028342857142853},69.677999999999997,{"$f":"IF($C$92=1,(K87*100000)/($E$53*$E$52),\"\")","v":68.153330653266337},72.372,{"$f":"IF($D$92=1,(M87*100000)/($E$53*$E$52),\"\")","v":57.199380410022776},62.463999999999999,{"$f":"IF($E$92=1,(O87*100000)/($E$53*$E$52),\"\")","v":62.7682940334129},72.332000000000008]
[null,null,null,0.1,0.04,null,null,40,35.272191253644316,64.628,60.032036180904512,63.74799999999999,55.499808656036457,60.608000000000004,55.475467303102619,63.928000000000004]
[null,null,null,7.4999999999999997E-2,0.06,null,null,60,31.791253644314871,58.25,51.066970854271347,54.228000000000002,53.507207289293859,58.432000000000009,47.717510262529835,54.988000000000007]
[null,null,null,0.06,0.08,null,null,80,27.585530029154519,50.543999999999997,41.25813467336684,43.812000000000005,51.22157630979499,55.936000000000007,39.494422911694514,45.512000000000008]
[null,null,null,0.05,0.1,null,null,100,22.655020408163256,41.509999999999991,30.605527638190953,32.499999999999993,48.642915717539864,53.12,30.806205250596669,35.500000000000007]
[null,null,null,4.2857142857142858E-2,null,null,null,"Diff.",{"$f":"B6","v":"Felzen VRK"},"kW",{"$f":"C6","v":"Synox FK"},"kW",{"$f":"D6","v":"CPC40VRK"},"kW",{"$f":"E6","v":"Hewalex FK"},"kW"]
[null,null,null,3.7499999999999999E-2,null,null,null,0,{"$f":"J86/$B$4*$B$5","v":0.83925089212828008},{"$f":"IF($B$7>0,$E$53*$E$52*(J79/100)/1000,\"\")","v":1.5377300000000003},{"$f":"L86/$C$4*$C$5","v":1.5802763969849247},{"$f":"IF($C$7>0,$E$53*$E$52*(L79/100)/1000,\"\")","v":1.6780950000000001},{"$f":"N86/$D$4*$D$5","v":1.227794077448747},{"$f":"IF($D$7>0,$E$53*$E$52*(N79/100)/1000,\"\")","v":1.3408},{"$f":"P86/$E$4*$E$5","v":1.4580359999999999},{"$f":"IF($E$7>0,$E$53*$E$52*(P79/100)/1000,\"\")","v":1.6801900000000001}]
[null,null,null,3.3333333333333333E-2,null,null,null,20,0.79669378285714276,1.4597540999999998,1.4278122771859298,1.5161934000000001,1.1983270195899771,1.3086207999999999,1.3149957600000002,1.5153554000000002]
[null,null,null,0.03,null,null,null,40,0.73895240676384844,1.3539566000000001,1.2576711579899496,1.3355205999999997,1.1627209913439638,1.2697376000000002,1.1622110399999999,1.3392916000000001]
[null,null,null,null,null,null,null,60,0.66602676384839654,1.2203375000000001,1.0698530393969847,1.1360765999999998,1.1209759927107064,1.2241504000000003,0.99968184000000004,1.1519986000000002]
[null,null,null,null,null,null,null,80,0.57791685411078719,1.0588968000000001,0.86435792140703538,0.91786140000000016,1.0730920236902051,1.1718592000000001,0.82740816000000006,0.95347640000000011]
[null,null,null,null,null,null,null,100,{"$f":"J91/$B$4*$B$5","v":0.47462267755102028},0.86963449999999975,{"$f":"L91/$C$4*$C$5","v":0.6411858040201005},0.6808749999999999,{"$f":"N91/$D$4*$D$5","v":1.0190690842824601},1.1128640000000001,{"$f":"P91/$E$4*$E$5","v":0.64539000000000024},0.7437250000000003]
["Br.& Absorberfl.vorh.",{"$f":"IF(B3>0,1,0)","v":1},1,1,1,null,null,"Str.  (W/m²)","Gesamtleistung nach eingetr. Strahlung und Diff. der ges. einget. Modulfl. (in kW)",null,null,null,null,null,null,null,null,"Gesamtleistung nach eingetr. Strahlung und Diff. der ges. einget. Modulfl. (in kW)",null,null,null,null,null,null,null,null,"Gesamtleistung nach eingetr. Strahlung und Diff. der ges. einget. Modulfl. (in kW)"]
["Modulfl. (Br. m²)",1,1,1,1,null,null,null,{"$f":"$B$6","v":"Felzen VRK"},"Absorber",{"$f":"$C$6","v":"Synox FK"},"Absorber",{"$f":"$D$6","v":"CPC40VRK"},"Absorber",{"$f":"$E$6","v":"Hewalex FK"},"Absorber",null,{"$f":"$B$6","v":"Felzen VRK"},"Absorber",{"$f":"$C$6","v":"Synox FK"},"Absorber",{"$f":"$D$6","v":"CPC40VRK"},"Absorber",{"$f":"$E$6","v":"Hewalex FK"},"Absorber",null,{"$f":"$B$6","v":"Felzen VRK"},"Absorber",{"$f":"$C$6","v":"Synox FK"},"Absorber",{"$f":"$D$6","v":"CPC40VRK"},"Absorber",{"$f":"$E$6","v":"Hewalex FK"},"Absorber"]
["Absorberfläche (m²)",1,1,1,1,null,null,100,{"$f":"J94/$B$4*$B$5","v":0.12368298542274059},{"$f":"($H$94*(J67/100000))*$E$2","v":0.22662000000000013},{"$f":"L94/$C$4*$C$5","v":-0.66413053266331668},-0.70524000000000009,{"$f":"N94/$D$4*$D$5","v":0.65536072892938502},0.71568000000000009,{"$f":"P94/$E$4*$E$5","v":-0.62214650119331716},-0.71693999999999969,1.8,{"$f":"S94/$B$4*$B$5","v":-0.14067834402332374},-0.25776000000000021,{"$f":"U94/$C$4*$C$5","v":-1.4140318793969853},-1.5015600000000002,{"$f":"W94/$D$4*$D$5","v":0.4958061047835991},0.54144000000000003,{"$f":"Y94/$E$4*$E$5","v":-1.2889663389021482},-1.4853600000000002,1.8,{"$f":"AB94/$B$4*$B$5","v":-0.43765504373177838},-0.80189999999999995,{"$f":"AD94/$C$4*$C$5","v":-2.201902914572865},-2.3382000000000005,{"$f":"AF94/$D$4*$D$5","v":0.32306514806378139},0.35280000000000011,{"$f":"AH94/$E$4*$E$5","v":-1.9767170405727921},-2.2778999999999998]
["IAM    ",{"$f":"IF(B101>0,1,0)","v":1},{"$f":"IF(C101>0,1,0)","v":1},{"$f":"IF(D101>0,1,0)","v":1},{"$f":"IF(E101>0,1,0)","v":1},null,null,200,0.8447577376093296,{"$f":"($H$95*(J68/100000))*$E$2","v":1.5478200000000002},0.69362484422110571,0.7365600000000001,1.7102673348519362,1.86768,0.63058132696897407,0.72666000000000031,7.2,0.58039640816326532,1.0634399999999999,-5.6276502512563012E-2,-5.9760000000000209E-2,1.5507127107061498,1.6934399999999996,-3.6238510739856733E-2,-4.1759999999999922E-2,7.2,0.28341970845481051,0.51930000000000009,-0.8441475376884422,-0.89639999999999997,1.3779717539863325,1.5048000000000001,-0.72398921241050085,-0.83429999999999971]
["η0  Abs. (z.B. 0,798)",{"$f":"IF(B7>0,1,0)","v":1},1,1,1,null,null,300,1.5658324897959177,{"$f":"($H$96*(J69/100000))*$E$2","v":2.869019999999999},2.0513802211055276,2.1783599999999996,2.7651739407744875,3.0196800000000001,1.8833091551312648,2.1702600000000003,16.2,1.3014711603498541,2.3846399999999996,1.3014788743718595,1.3820399999999999,2.6056193166287014,2.84544,1.2164893174224347,1.4018400000000006,16.2,1.0044944606413992,1.8404999999999996,0.51360783919597996,0.54540000000000011,2.4328783599088837,2.6568000000000001,0.52873861575179038,0.6093000000000004]
["a1 Abs. (z.B. 1,52)",1,1,1,1,null,null,400,2.2869072419825072,{"$f":"($H$97*(J70/100000))*$E$2","v":4.1902200000000001},3.4091355979899496,3.6201599999999998,3.82008054669704,4.1716800000000012,3.1360369832935566,3.6138600000000012,28.8,2.0225459125364429,3.7058399999999994,2.6592342512562812,2.8238399999999997,3.660525922551253,3.9974400000000005,2.4692171455847256,2.84544,28.8,1.7255692128279885,3.1617000000000002,1.8713632160804023,1.9872000000000003,3.4877849658314357,3.8088000000000006,1.7814664439140815,2.0529000000000006]
["a2 Abs. (z.B. 0,0143)",1,1,1,1,null,null,500,3.0079819941690964,{"$f":"($H$98*(J71/100000))*$E$2","v":5.5114200000000002},4.7668909748743724,5.0619600000000009,4.8749871526195907,5.3236800000000004,4.3887648114558475,5.0574600000000007,45,2.7436206647230317,5.0270399999999995,4.0169896281407045,4.2656400000000012,4.7154325284738041,5.1494400000000002,3.721944973747016,4.28904,45,2.4466439650145766,4.482899999999999,3.2291185929648245,3.4290000000000003,4.542691571753986,4.9607999999999999,3.0341942720763724,3.4965000000000002]
["Absorberaktivierung",{"$f":"IF(B98+B97+B96+B94+B93=5,1,0)","v":1},{"$f":"IF(C98+C97+C96+C94+C93=5,1,0)","v":1},{"$f":"IF(D98+D97+D96+D94+D93=5,1,0)","v":1},{"$f":"IF(E98+E97+E96+E94+E93=5,1,0)","v":1},null,null,600,3.7290567463556847,{"$f":"($H$99*(J72/100000))*$E$2","v":6.8326199999999986},6.1246463517587948,6.5037599999999998,5.9298937585421418,6.4756800000000005,5.6414926396181384,6.5010600000000007,64.8,3.4646954169096209,6.3482399999999997,5.3747450050251251,5.7074399999999992,5.7703391343963553,6.3014400000000004,4.9746728019093069,5.73264,64.8,3.1677187172011658,5.8040999999999991,4.5868739698492469,4.8708000000000009,5.597598177676538,6.1128,4.2869221002386633,4.9401000000000002]
[null,null,null,null,null,null,null,700,4.450131498542274,{"$f":"($H$100*(J73/100000))*$E$2","v":8.1538199999999996},7.4824017286432172,7.9455600000000004,6.9848003644646921,7.6276799999999998,6.8942204677804302,7.9446600000000016,88.2,4.1857701690962097,7.6694399999999998,6.7325003819095501,7.1492400000000016,6.8252457403189064,7.4534400000000005,6.2274006300715996,7.1762400000000017,88.2,3.8887934693877542,7.1252999999999984,5.9446293467336693,6.3125999999999998,6.6525047835990891,7.264800000000001,5.539649928400955,6.3837000000000002]
["IAM    ",{"$f":"IF(OR($O$1=0,B10<0.1),1,B10)","v":1},{"$f":"IF(OR($O$1=0,C10<0.1),1,C10)","v":1},1,1,null,null,800,5.1712062507288632,{"$f":"($H$101*(J74/100000))*$E$2","v":9.4750200000000007},8.8401571055276396,9.387360000000001,8.0397069703872432,8.7796800000000008,8.1469482959427193,9.3882599999999989,115.2,4.906844921282798,8.9906399999999991,8.0902557587939707,8.5910400000000013,7.8801523462414576,8.6054399999999998,7.4801284582338914,8.6198400000000017,115.2,4.6098682215743434,8.4464999999999986,7.3023847236180908,7.7543999999999995,7.7074113895216421,8.4168000000000021,6.7923777565632459,7.8273000000000001]
[null,null,null,null,null,null,null,900,5.8922810029154542,{"$f":"($H$102*(J75/100000))*$E$2","v":10.796220000000003},10.197912482412065,10.829160000000003,9.0946135763097953,9.9316800000000001,9.399676124105012,10.831860000000001,145.79999999999998,5.6279196734693873,10.311839999999998,9.448011135678394,10.032840000000002,8.9350589521640096,9.7574400000000008,8.7328562863961814,10.063440000000002,145.79999999999998,5.3309429737609326,9.7676999999999996,8.6601401005025167,9.1962000000000028,8.7623179954441923,9.5688000000000013,8.0451055847255386,9.2709000000000028]
[null,null,null,null,null,null,null,1000,{"$f":"J103/$B$4*$B$5","v":6.6133557551020417},{"$f":"($H$103*(J76/100000))*$E$2","v":12.117420000000001},{"$f":"L103/$C$4*$C$5","v":11.555667859296486},{"$f":"($H$103*(L76/100000))*$E$2","v":12.270960000000002},{"$f":"N103/$D$4*$D$5","v":10.149520182232346},11.083679999999999,{"$f":"P103/$E$4*$E$5","v":10.652403952267303},12.275460000000001,180,{"$f":"S103/$B$4*$B$5","v":6.3489944256559774},11.633040000000001,{"$f":"U103/$C$4*$C$5","v":10.805766512562814},11.474639999999999,{"$f":"W103/$D$4*$D$5","v":9.9899655580865616},10.909440000000002,{"$f":"Y103/$E$4*$E$5","v":9.9855841145584723},11.50704,180,{"$f":"AB103/$B$4*$B$5","v":6.0520177259475219},11.088899999999999,{"$f":"AD103/$C$4*$C$5","v":10.017895477386936},10.638,{"$f":"AF103/$D$4*$D$5","v":9.8172246013667426},10.720800000000001,{"$f":"AH103/$E$4*$E$5","v":9.2978334128878295},10.714500000000001]

{"sheet":"Änderungen","index":1,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Version","Änderung"]
["V8","erste Testversion"]
["V9","falsche Anzeige der Modulfläche in K44 behoben (wenn keine Gesamtbruttofläche eingetragen ist)"]
["V11","Anzeige des Aperturanteils in % "]
["V13","zusätzliche Wirkungsgrad Diagrame (ITW Vergleich) / max. Peak Anzeige pro m²"]
["V15","Darstellung der Bruttodiagramme und max. Peak auch wenn nur Absorberdaten vorhanden sind (Brutto und Absorber bzw. Aperturfläche müßen aber vorhanden sein)"]
["V16","Links zu Kollektortests (auch Keymark geprüfte Kollektoren ) eingefügt, Link zu meiner Mail korrigiert, Eingabe max. Peak nach oben verschoben !"]
["V16","Bruttoflächenrechner eingefügt"]
["V17","IAM kann immer eingetragen werden , umschalten der Winkelberechnung (aus/ein) mit IAM über neue Button Winkelberechnung ein oder aus (oben)"]
["V17 ","Keymark Hyperlink eingefügt"]

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