{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Introduction","InAndOutput","Intermediate","Data"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":33,"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":"Introduction","index":0,"n_rows":51,"n_cols":17,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["Subject:","Evaluation tool for SOLCAL method",null,null,null,null,null,null,null,null,null,null,null,{"$f":"InAndOutput!L6","v":"vAConsult"}]
["Device:",{"$f":"InAndOutput!C7","v":"Solar water heater or solar device for water heating"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"InAndOutput!L7","v":"28.07.2015"}]
["Document:",{"$f":"InAndOutput!C8","v":"Transitional document 2014/C 207/03"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"InAndOutput!L8","v":"V3.7"}]
["Part:",{"$f":"InAndOutput!C9","v":"Annex IV, paragraph 3"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"No inputs for this sheet!"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version history:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:","2014-12-11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Author:","Gerard van Amerongen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Location: CalcModule,  Function Calc"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\"If Qnonsol(Mn) < 0 Then Qnonsol(Mn) = 0 Else If Qnonsol(Mn) > Lwh(Mn) Then Qnonsol(Mn) = Lwh(Mn)\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"is skipped and replaced by:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\"If LsolW(Mn) < 0 Then LsolW(Mn) = 0 Else If LsolW(Mn) > Lwh(Mn) Then LsolW(Mn) = Lwh(Mn)\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:","2014-12-11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Author:","Gerard van Amerongen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\"— Vsol is the solar storage tank volume, as defined in EN 15316-4-3;\" was  not implemented fully."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Location: sheet InAndOutput: extra input field added 'Backup control:'"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Location: Sheet Data: list of options added"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Location: CalcModule,  Function Calc"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Processing of extra input field added  "]
["Contents:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Location: CalcModule,  Function Calc"]
["-","Input and output sheet (main sheet)",null,null,null,"…Define your solar domestic hot water system here and see the results",null,null,null,null,null,null,null,null,null,null,"\"Vsol = Vnom - Vbu\" replaced by \"Vsol = Vnom * (1 - x * Vbu / Vnom)\""]
["-","Intermediate results",null,null,null,"…Look here if you want to validate your own tool",null,null,null,null,null,null,null,null,null,"Date:","2014-12-17"]
["-","Data used for the calculations",null,null,null,"…For interested people only",null,null,null,null,null,null,null,null,null,"Author:","Gerard van Amerongen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Location: CalcModule,  Function Calc"]
["This Excel application is offered to you by the courtesy of vAConsult , (T) +31 (0) 64 8624487, (E) vaconsult@vaconsult.net",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Software error corrected. \"x as single\" was defined twice. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Replaced by \"xf\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:","2015-01-04"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Author:","Gerard van Amerongen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Location: Sub Worksheet_Change"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Software error corrected. Vnom added to trigger calculation of heat losses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:","09/03/2015 V3.4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Author:","Gerard van Amerongen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Location: CalcModule,  Function Calc"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\"If LsolW(Mn) < 0 Then LsolW(Mn) = 0 Else If LsolW(Mn) > Lwh(Mn) Then Qnonsol(Mn) = Lwh(Mn)\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"is skipped "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Effects are assumed to be minimal and at the worsed at months with high input"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:","17/06/2015 V3.5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Author:","Gerard van Amerongen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Location: InAndOutput  Sub Worksheet_Change"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Change in 'Backup-Control' now also triggers recalculation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Replacement of 'BusyFlag' to the correct position: uninterupted recalculcations"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Effects are assumed to be minimal and at the worsed at months with high input"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:","03/07/2015, V3.6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Author:","Gerard van Amerongen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Location: InAndOutput  Sub Worksheet_Change"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rounding of the numerical input values according to the regulations added."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The calculation results may differ from the V3.5 results,"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:","28/07/2015, V3.6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Author:","Gerard van Amerongen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Location: InAndOutput  Sub Worksheet_Change"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Option for collectortype and storage label class has been removed"]

{"sheet":"InAndOutput","index":1,"n_rows":53,"n_cols":12,"rows_kept":53,"cut":false,"hidden":false,"merged":[[43,1,43,11],[10,1,10,11],[27,1,27,11],[12,8,12,10],[12,1,12,3],[20,8,20,10],[16,9,16,10],[36,1,36,11],[38,2,38,5]]}
[]
[]
[]
[]
[]
[null,"Subject:","Calculation sheet SOLCAL method",null,null,null,null,null,null,null,null,"vAConsult"]
[null,"Device:","Solar water heater or solar device for water heating",null,null,null,null,null,null,null,null,"28.07.2015"]
[null,"Document:","Transitional document 2014/C 207/03",null,null,null,null,null,null,null,null,"V3.7"]
[null,"Part:","Annex IV, paragraph 3"]
[]
[null,"Input specifications of the applied components"]
[]
[null,"Collector",null,null,null,null,null,null,"Heat storage"]
[]
[null,"Asol =",3,"m2","...Collector area",null,null,null,"Vnom =",150,"litres","…Nominal volume"]
[null,"ɳo =",0.85599999999999998,"-","…Zero loss efficiency",null,null,null,"Vbu =",0,"litres","…Backup volume"]
[null,"a1 =",3.69,"W/(m2K)","…First order heat loss",null,null,null,"Backup control:","Permanent powered"]
[null,"a2 =",2.1000000000000001E-2,"W/(m2K2)","…Second order heat loss",null,null,null,"psbsol =",1.6,"W/K","…Heat loss storage"]
[null,"IAM =",0.96,"-","…Incindence angle modifier",null,null,null,"StoLoc: ","Inside","...{list}","…Storage location"]
[]
[null,null,null,null,null,null,null,null,"Pump & control"]
[]
[null,null,null,null,null,null,null,null,"solpump =",6,"W","…Pump power"]
[null,null,null,null,null,null,null,null,"solsb =",1,"W","…Controller power"]
[]
[]
[]
[null,"Calculation results. Input for the fiche"]
[]
[null,"Load profile:","M","L","XL","XXL"]
[null,"Lwh =",{"$f":"366*0.6*(Data!D25+1.09)","v":1522.9259999999999},{"$f":"366*0.6*(Data!E25+1.09)","v":2798.8019999999997},{"$f":"366*0.6*(Data!F25+1.09)","v":4427.1359999999995},{"$f":"366*0.6*(Data!G25+1.09)","v":5626.152},"kWh/a","Heat demand"]
[]
[null,"Qnonsol =",748.65118408203125,1427.2120361328125,2682.25146484375,3724.287841796875,"kWh/a","Non-solar heat contribution"]
[null,"Qaux=",{"$f":"(Solpump*2000+Solsb*24*365)/1000","v":20.76},"kWh/a","Parasitic electricity consumption"]
[]
[]
[null,"Calculation results for other climates"]
[]
[null,null,"Qnonsol:"]
[null,"Colder:",940.57598876953125,1745.5902099609375,3076.472412109375,4149.494140625,"kWh/a","Non-solar heat contribution"]
[null,"Warmer:",574.6583251953125,963.33538818359375,2024.316162109375,2981.154296875,"kWh/a","Non-solar heat contribution"]
[]
[]
[null,"Additional information (illustrative only!)"]
[]
[null,"LwSolar",774.2747802734375,1371.590087890625,1744.884521484375,1901.8643798828125,"kWh/a","Solar thermal output"]
[null,"fsolar =",{"$f":"C46/C31","v":0.50841260854003245},{"$f":"D46/D31","v":0.49006327989283455},{"$f":"E46/E31","v":0.39413393252079337},{"$f":"F46/F31","v":0.33803999249981381},"kWh/a","Solar fraction"]
[]
[]
[null,"vAConsult, (T) +31 (0) 64 8624487, (E) vaconsult@vaconsult.net"]
[]
[null,"xxx","These cells are manual input cells",null,null,null,"xxx","Do not change cells marked like this!"]
[null,"To be safe: dot not change any other cell",null,null,null,null,"xxx","These cells are calculation outputs"]

{"sheet":"Intermediate","index":2,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Subject:","Intermediate results of the calculations for evaluation purposes",null,null,null,null,null,null,null,null,null,null,null,{"$f":"InAndOutput!L6","v":"vAConsult"}]
["Device:",{"$f":"InAndOutput!C7","v":"Solar water heater or solar device for water heating"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"InAndOutput!L7","v":"28.07.2015"}]
["Document:",{"$f":"InAndOutput!C8","v":"Transitional document 2014/C 207/03"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"InAndOutput!L8","v":"V3.7"}]
["Part:",{"$f":"InAndOutput!C9","v":"Annex IV, paragraph 3"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"No inputs for this sheet!"]
[]
[null,"Ac =",4.5300002098083496]
[null,"UL =",2.2999999523162842]
[null,"etaloop=",0.9684135913848877]
[null,"ccap =",1.1066819429397583]
[null,"Vsol =",150]
[]
[]
[null,"Month:","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,"Qsol =",128,137,182,227,248,268,268,263,243,175,126,109,"…Average global solar irradiation in W/m2"]
[null,"Ta =",20,20,20,20,20,20,20,20,20,20,20,20,"…Monthly average air temperature surrounding the storage"]
[null,"Tout =",9.5,10.1,11.6,15.3,21.4,26.5,28.8,27.9,23.6,19,14.5,10.4,"…Average daytime temperature in oC"]
[null,"Lwh =",468.84600830078125,468.84600830078125,468.84600830078125,468.84600830078125,468.84600830078125,468.84600830078125,468.84600830078125,468.84600830078125,468.84600830078125,468.84600830078125,468.84600830078125,468.84600830078125,"…Monthly heat demand in kWh"]
[null,"Trefw =",84.860000610351563,84.068000793457031,82.087997436523437,77.204002380371094,69.152000427246094,62.419998168945312,59.383998870849609,60.571998596191406,66.248001098632813,72.319999694824219,78.260002136230469,83.6719970703125,"…Reference temperature in oC"]
[null,"X =",2.5837316513061523,2.5360066890716553,2.416694164276123,2.1223902702331543,1.6371862888336182,1.231523871421814,1.048578143119812,1.1201655864715576,1.4621946811676025,1.8280861377716064,2.186023473739624,2.5121440887451172,"…X-factr"]
[null,"Y =",0.47710937261581421,0.51065611839294434,0.67838990688323975,0.84612363576889038,0.92439943552017212,0.99894773960113525,0.99894773960113525,0.98031067848205566,0.90576231479644775,0.6522979736328125,0.46965453028678894,0.40628844499588013,"…Y factor"]
[null,"Qbuf =",4.7775626182556152,6.5104408264160156,14.373613357543945,22.161224365234375,26.776073455810547,30.893077850341797,31.545473098754883,30.62660026550293,26.692371368408203,15.232978820800781,5.7371783256530762,1.5893595218658447,"…Solar storage tank correction in kWh"]

{"sheet":"Data","index":3,"n_rows":42,"n_cols":15,"rows_kept":42,"cut":false,"hidden":false,"merged":[[7,1,7,14],[14,1,14,14],[22,1,22,14],[16,1,18,1],[9,1,11,1]]}
[null,"Subject:","Data used in the calculations",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Intermediate!N1","v":"vAConsult"}]
[null,"Device:",{"$f":"InAndOutput!C7","v":"Solar water heater or solar device for water heating"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Intermediate!N2","v":"28.07.2015"}]
[null,"Document:",{"$f":"InAndOutput!C8","v":"Transitional document 2014/C 207/03"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Intermediate!N3","v":"V3.7"}]
[null,"Part:",{"$f":"InAndOutput!C9","v":"Annex IV, paragraph 3"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No inputs for this sheet!"]
[]
[]
[null,"Table 4 (annex VII): Average daytime temperature in oC  "]
[null,null,"Month:","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,"Climate:","Average",2.8,2.6,7.4,12.2,16.3,19.8,21,22,17,11.9,5.6,3.2]
[null,null,"Colder",-3.8,-4.0999999999999996,-0.6,5.2,11,16.5,19.3,18.399999999999999,12.8,6.7,1.2,-3.5]
[null,null,"Warmer",9.5,10.1,11.6,15.3,21.4,26.5,28.8,27.9,23.6,19,14.5,10.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(check GvA 3/10/14)"]
[]
[null,"Table 5 (annex VII): Average solar irradiation in W/m2"]
[null,null,"Month:","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,"Climate:","Average",70,104,149,192,221,222,232,217,176,129,80,56]
[null,null,"Colder",22,75,124,192,234,237,238,181,120,64,23,13]
[null,null,"Warmer",128,137,182,227,248,268,268,263,243,175,126,109]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(check GvA 3/10/14)"]
[]
[]
[null,"Table 3 (annex VII): Load profiles of water heaters "]
[null,null,null,"M","L","XL","XXL"]
[null,null,"Qref:",5.8449999999999998,11.654999999999999,19.07,24.53,"kWh/day","Typical daily heat withdrawal"]
[null,null,null,null,null,null,"(check GvA 3/10/14)"]
[]
[]
[null,null,null,null,null,null,"Predefined",null,"Labelclass"]
[null,null,"Location of storage tank:",null,null,null,"Collectortypes",null,"Storage"]
[null,null,"Inside",null,null,null,"User defined",null,"User defined"]
[null,null,"Outside",null,null,null,"Unglazed",null,"Class: A"]
[null,null,null,null,null,null,"Glazed",null,"Class: B"]
[null,null,null,null,null,null,"Vacuum tube",null,"Class: C"]
[null,null,"Types of solar system:",null,null,null,"            ",null,"Class: D"]
[null,null,"Preheater type",null,null,null,"            ",null,"Class: E"]
[null,null,"Solar-plus-supplementary",null,null,null,"            ",null,"Class: F"]
[null,null,null,null,null,null,null,null,"Class: G"]
[null,null,"Types of backup heater control"]
[null,null,"Permanent powered"]
[null,null,"Night back-up"]
[null,null,"Emergency back-up"]