{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["App I-8 Instructions","Tool","App I-8 Report","App I-8 Summary Form","Interface","Calcs","gridPoints","output"],"not_rendered":{"charts":2,"images":5,"macros":1,"external_links":1,"defined_names":99,"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":"App I-8 Instructions","index":0,"n_rows":52,"n_cols":2,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,0,0,4],[4,0,4,4],[6,0,6,4],[27,0,27,4],[7,0,7,4],[5,0,5,4],[8,0,8,4],[28,0,28,4],[29,0,29,4],[33,0,33,4],[9,0,9,4],[26,0,26,4],[11,0,11,4],[10,0,10,4],[12,0,12,4],[30,0,30,4],[31,0,31,4],[51,0,51,4],[50,0,50,4],[34,0,34,4],[35,0,35,4],[36,0,37,4],[47,0,47,4],[46,0,46,4],[40,0,40,4],[49,0,49,4],[48,0,48,4],[32,0,32,4],[45,0,45,4],[42,0,42,4],[44,0,44,4],[43,0,43,4],[41,0,41,16383],[39,0,39,4],[38,0,38,4]]}
["Appendix I-8: Instructions"]
["B3 Guidelines - Version 3.0"]
[]
["Instructions for Using the Daylighting Factor Calculator"]
["This section describes proper use of the tool provided for conceptual level and schematic design level calculations. The spreadsheet tool uses fundamental algorithms and has been bench tested against RADIANCE, the most accurate computer simulation tool for lighting and daylighting available[2].  The current tool allows up to windows (3 vision and 3 clerestorey only on one wall of a room."]
["Note: Users running Microsoft Excel 2007 or later must enable macros for the proper working of the daylighting tool. Click the 'Options' button on the main ribbon bar and select 'enable this content'."]
["The tool uses a standard CIE overcast sky to calculate the Daylight Factors[3] (DF) and can therefore be used for any regular orthogonal space in any location. However, the Report makes specific use of sky data pertaining to Minnesota.  "]
["Defaults "]
["1.        Overcast Sky "]
[{"$f":"\"3.       A Minimum \"&TEXT(minDF,\"0.0%\")&\" DF is required in 75% of the Grid\"","v":"3.       A Minimum 1.0% DF is required in 75% of the Grid"}]
["4.        The grid automatically adjusts to provide a granularity  of 20 X 20 points in any room."]
["5.        The limiting uniformity ratio at the work plane 10:1 "]
["Inputs "]
[1,"Room Width[4]"]
[2,"Room Depth[5]"]
[3,"Ceiling Height"]
[4,"Number of Windows (distributed horizontally in the wall, max of 3)"]
[5,"Width of each window"]
[6,"Sill height of the vision windows"]
[7,"Head height of the vision windows"]
[8,"Sill height of the Clerestory windows if any[1]"]
[9,"Head height of the Clerestory windows if any[2]"]
[10,"Ceiling Reflectance (typically between 75 -95 % for white ceilings) "]
[11,"Wall Reflectance[3]"]
[12,"Floor Reflectance (typically between 20 -40 % for carpets)"]
[13,"Glass Visible Transmittance (VT) "]
["How to use "]
["Begin on the \"tool\" sheet tab.  You can compare 2 alternatives side by side.  Enter information only in the yellow cells at the top.  Press the “calculate\" button each time you wish to see the results of a scenario.   The calculate button calculates both alternatives at once.  Summary results are shown in red text at the top.  To see grid points with similar daylight factor values, press the “Do Isocontours” button AFTER the calculations have been performed.  Press “Color for LEED” button to show colors for Minimum Daylight Factor and recommended Uniformity Ratio.  \nA report of inputs and results is provided on the Report sheet tab.  Fill in the yellow cells at the top of the sheet tab and print for your record.  \n"]
["You may enter the results for each room or space type in the table on sheet tab ‘Summary Form’ to calculate the overall percentage of occupied spaces that meet the minimum daylight factor. "]
["Outputs"]
["1.      DF on a 20X20 grid with coloring of cells by DF achieved"]
["2.      Minimum & maximum DF achieved"]
["3.      % area that achieves minimum DF"]
["4.      % area that exceeds the maximum uniformity ratio"]
["5.      Average Task  Illuminance achieved by daylight over an entire overcast day in each month"]
["6.      % of Design Ambient Illuminance achieved by daylight over an entire overcast day in each month"]
[]
[]
["Factors not included in this version that also affect daylighting "]
["1.      Partition heights and furniture, and their reflectances"]
["2.      Shading devices and light shelves"]
[]
["Footnotes"]
[" 1   Use only the tabs labeled Tool and Report to complete Summary Form I-D.1. Use of other tabs will render the results inaccurate."]
[" 2   The accuracy of the spreadsheet when used within the limits allowed is 90% to 100%.  It is most accurate when the measured points are in front of the window and more than 1 head height away from it. "]
[" 3    The Daylight Factor is a ratio of the light delivered (inside at the work surface) to the diffuse light available outside."]
[" 4   For open office plans a structural bay can be considered as a room width."]
[" 5    Deep rooms will require high ceilings and window head heights or very high visible transmittance of the glass or highly reflective surfaces in order to meet the performance criteria."]
[" 6   The clerestory sill height should be equal to or greater than the head height of the vision window."]
[" 7   The clerestory head height cannot be greater than the ceiling height."]
[" 8    Light colored walls are very important to the appearance of room brightness and visual comfort."]
[" 9   Ambient light levels range from 30 to 50 foot candles for most common task area functions.      Consult the IESNA Handbook"]

{"sheet":"Tool","index":1,"n_rows":45,"n_cols":44,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,"Appendix I-8: Daylighting Factor Calculator "]
[null,"B3 Guidelines - Version 3.0"]
[]
[null,"      © The Weidt Group 2011",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A L T E R N A T I V E   1",null,null,null,null,"Geometry",null,"Geometry",null,null,null,null,"A L T E R N A T I V E   2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"© The Weidt Group 2011      "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All dimensions are in feet",null,null,null,"Room Width",30,null,30,{"$f":"U5","v":"Room Width"},null,null,null,"All dimensions are in feet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Room Depth",30,null,30,"Room Depth"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ceiling Height",10,null,10,"Ceiling Height"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of Vision Windows",1,null,1,"Number of Vision Windows"]
[null,null,null,null,null,null,null,null,null,"Summary Results",null,null,null,null,null,null,"Surface Properties",null,null,null,"Width of each window",24,null,24,"Width of each window",null,null,null,"Surface Properties",null,null,null,null,null,null,"Summary Results"]
[null,null,{"$f":"1-COUNTIF(C20:V39,\"<\"&minDF)/COUNT(C20:V39)","v":0.45999999999999996},null,null,null,null,null,null,{"$f":"\"area above \"&TEXT(minDF,\"0.0%\")&\" Daylight Factor\"","v":"area above 1.0% Daylight Factor"},null,null,null,null,null,"Ceiling Reflectance",0.8,null,null,null,"Sill - Vision",0,null,4,"Sill - Vision",null,null,null,0.9,"Ceiling Reflectance",null,null,null,null,null,{"$f":"1-COUNTIF(Y20:AR39,\"<\"&minDF)/COUNT(Y20:AR39)","v":1},{"$f":"\"area above \"&TEXT(minDF,\"0.0%\")&\" Daylight Factor\"","v":"area above 1.0% Daylight Factor"}]
[null,null,{"$f":"COUNTIF(C20:V39,\">\"&H17)/COUNT(C20:V39)","v":0},null,null,null,null,null,null,{"$f":"\"area exceeds max uniformity ratio\"","v":"area exceeds max uniformity ratio"},null,null,null,null,null,"Wall Reflectance",0.5,null,null,null,"Head - Vision",2,null,10,"Head - Vision",null,null,null,0.75,"Wall Reflectance",null,null,null,null,null,{"$f":"COUNTIF(Y20:AR39,\">\"&AD17)/COUNT(Y20:AR39)","v":0.03},{"$f":"\"area exceeds max uniformity ratio\"","v":"area exceeds max uniformity ratio"}]
[null,null,null,null,{"$f":"'App I-8 Report'!D46","v":0.11555555555555555},null,null,null,null,"window/ floor area ratio",null,null,null,null,null,"Floor Reflectance",0.2,null,null,null,"Number of Clerestoreys",1,null,0,"Number of Clerestoreys",null,null,null,0.2,"Floor Reflectance",null,null,null,null,null,{"$f":"'App I-8 Report'!N46","v":0.16},"window/ floor area ratio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Glass Visible Transmittance",0.5,null,null,null,"Width of clerestorey",28,null,0,"Width of clerestorey",null,null,null,0.7,"Glass Visible Transmittance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sill - Clerestorey",7,null,0,"Sill - Clerestorey"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Head - Clerestorey",9,null,0,"Head - Clerestorey"]
[]
[null,null,null,null,null,null,{"$f":"MIN(C20:V39)","v":4.6115902579573955E-3},{"$f":"G17*maxContrast","v":4.6115902579573959E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(Y20:AR39)","v":1.771643870496465E-2},{"$f":"AC17*maxContrast","v":0.17716438704964649}]
[null,null,"0.75'","2.25'","3.75'","5.25'","6.75'","8.25'","9.75'","11.25'","12.75'","14.25'","15.75'","17.25'","18.75'","20.25'","21.75'","23.25'","24.75'","26.25'","27.75'","29.25'",null,null,"0.75'","2.25'","3.75'","5.25'","6.75'","8.25'","9.75'","11.25'","12.75'","14.25'","15.75'","17.25'","18.75'","20.25'","21.75'","23.25'","24.75'","26.25'","27.75'","29.25'"]
[null,null,null,null,null,null,null,null,null,null,null,"W   I   N   D   O   W       W   A   L   L",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W   I   N   D   O   W       W   A   L   L"]
[null,"0.75'",7.3984042330863687E-3,8.8895418718419484E-3,1.6629333636578175E-2,1.7878019773628465E-2,1.8150258470106755E-2,1.827831484407132E-2,1.8345612646074139E-2,1.8381654412244999E-2,1.8400297763580747E-2,1.8408242512021906E-2,1.8408242512021906E-2,1.8400297763580747E-2,1.8381654412244999E-2,1.8345612646074139E-2,1.827831484407132E-2,1.8150258470106755E-2,1.7878019773628465E-2,1.6629333636578175E-2,8.8895418718419484E-3,7.3984042330863687E-3,null,"0.75'",2.8231075419472108E-2,4.3245791608173087E-2,6.8958439566058446E-2,8.3984490283535829E-2,8.9760107790030769E-2,9.220033373901361E-2,9.3345726826826569E-2,9.3915919620133695E-2,9.4198847513956935E-2,9.4317009598183899E-2,9.4317009598183899E-2,9.4198847513956935E-2,9.3915919620133695E-2,9.3345726826826569E-2,9.220033373901361E-2,8.9760107790030769E-2,8.3984490283535829E-2,6.8958439566058446E-2,4.3245791608173087E-2,2.8231075419472108E-2]
[null,"2.25'",1.7314733615668328E-2,2.1837206510871288E-2,2.6082395509697463E-2,2.8821244797937427E-2,3.0333479500528789E-2,3.1186344914969577E-2,3.1677627134579701E-2,3.1960972062004746E-2,3.2116913702434052E-2,3.2186294882135404E-2,3.2186294882135404E-2,3.2116913702434052E-2,3.1960972062004746E-2,3.1677627134579701E-2,3.1186344914969577E-2,3.0333479500528789E-2,2.8821244797937427E-2,2.6082395509697463E-2,2.1837206510871288E-2,1.7314733615668328E-2,null,"2.25'",5.5247607894190948E-2,8.743329698485329E-2,0.12998902346037339,0.16216634831706522,0.17946734312661572,0.18820568514923675,0.19273803980128346,0.19514907121841807,0.19640320613393375,0.19694286296129179,0.19694286296129179,0.19640320613393375,0.19514907121841807,0.19273803980128346,0.18820568514923675,0.17946734312661572,0.16216634831706522,0.12998902346037339,8.743329698485329E-2,5.5247607894190948E-2]
[null,"3.75'",2.211524329644075E-2,2.7192707329507439E-2,3.1709487680481881E-2,3.4992508333976165E-2,3.7129269408480853E-2,3.8457097175385549E-2,3.9268738886470575E-2,3.9755698506823603E-2,4.0030766859463149E-2,4.0155002935387235E-2,4.0155002935387235E-2,4.0030766859463149E-2,3.9755698506823603E-2,3.9268738886470575E-2,3.8457097175385549E-2,3.7129269408480853E-2,3.4992508333976165E-2,3.1709487680481881E-2,2.7192707329507439E-2,2.211524329644075E-2,null,"3.75'",5.9137916475917755E-2,8.2858294209940203E-2,0.11052025994072924,0.13421762798637743,0.15020952007760341,0.15983797933535882,0.16542563036583199,0.16861457120856144,0.17034664613408801,0.17110988573895314,0.17110988573895314,0.17034664613408801,0.16861457120856144,0.16542563036583199,0.15983797933535882,0.15020952007760341,0.13421762798637743,0.11052025994072924,8.2858294209940203E-2,5.9137916475917755E-2]
[null,"5.25'",2.0872876965511152E-2,2.4868237291899319E-2,2.8453461389514288E-2,3.1304698689107242E-2,3.3323340150855925E-2,3.4675146886911125E-2,3.5550518273685723E-2,3.6098106397051945E-2,3.6416248354628727E-2,3.656229213092848E-2,3.656229213092848E-2,3.6416248354628727E-2,3.6098106397051945E-2,3.5550518273685723E-2,3.4675146886911125E-2,3.3323340150855925E-2,3.1304698689107242E-2,2.8453461389514288E-2,2.4868237291899319E-2,2.0872876965511152E-2,null,"5.25'",5.3708295042910074E-2,6.8964040358285822E-2,8.5765876494866083E-2,0.10098898439141177,0.11263730294588634,0.12060840656674027,0.12572607064084931,0.12886395565227324,0.13065043729545114,0.13145889968539448,0.13145889968539448,0.13065043729545114,0.12886395565227324,0.12572607064084931,0.12060840656674027,0.11263730294588634,0.10098898439141177,8.5765876494866083E-2,6.8964040358285822E-2,5.3708295042910074E-2]
[null,"6.75'",1.7796960231273258E-2,2.0607770208348409E-2,2.3020947274799163E-2,2.5164708029915845E-2,2.6783558222691867E-2,2.7937735973653857E-2,2.872583246506346E-2,2.9239379907853514E-2,2.954638730419289E-2,2.9689709241284213E-2,2.9689709241284213E-2,2.954638730419289E-2,2.9239379907853514E-2,2.872583246506346E-2,2.7937735973653857E-2,2.6783558222691867E-2,2.5164708029915845E-2,2.3020947274799163E-2,2.0607770208348409E-2,1.7796960231273258E-2,null,"6.75'",4.6610431577729372E-2,5.629414642930157E-2,6.6638088054429667E-2,7.6283738889560207E-2,8.4218991350974853E-2,9.0139884508226298E-2,9.4253762257857629E-2,9.6938652372272865E-2,9.8535818597276267E-2,9.9277523988689387E-2,9.9277523988689387E-2,9.8535818597276267E-2,9.6938652372272865E-2,9.4253762257857629E-2,9.0139884508226298E-2,8.4218991350974853E-2,7.6283738889560207E-2,6.6638088054429667E-2,5.629414642930157E-2,4.6610431577729372E-2]
[null,"8.25'",1.4882404410405392E-2,1.6785892909674867E-2,1.832443560273633E-2,1.9855032366473818E-2,2.1069774759363457E-2,2.1981037937123298E-2,2.2632247398111444E-2,2.3072472072515789E-2,2.3342724866980285E-2,2.3470917234898903E-2,2.3470917234898903E-2,2.3342724866980285E-2,2.3072472072515789E-2,2.2632247398111444E-2,2.1981037937123298E-2,2.1069774759363457E-2,1.9855032366473818E-2,1.832443560273633E-2,1.6785892909674867E-2,1.4882404410405392E-2,null,"8.25'",4.0318162576762906E-2,4.6567236846627384E-2,5.3117576481129733E-2,5.9326434338069917E-2,6.4666373308840633E-2,6.8889263157506458E-2,7.1999493364718545E-2,7.4132987497103717E-2,7.5450016977378825E-2,7.6075590903028137E-2,7.6075590903028137E-2,7.5450016977378825E-2,7.4132987497103717E-2,7.1999493364718545E-2,6.8889263157506458E-2,6.4666373308840633E-2,5.9326434338069917E-2,5.3117576481129733E-2,4.6567236846627384E-2,4.0318162576762906E-2]
[null,"9.75'",1.2574568212375674E-2,1.3866874820640227E-2,1.481810831585503E-2,1.5898209389622782E-2,1.6788136021946471E-2,1.7482891674786435E-2,1.7998182902224526E-2,1.8357524765235431E-2,1.8583276477787833E-2,1.8691883855129428E-2,1.8691883855129428E-2,1.8583276477787833E-2,1.8357524765235431E-2,1.7998182902224526E-2,1.7482891674786435E-2,1.6788136021946471E-2,1.5898209389622782E-2,1.481810831585503E-2,1.3866874820640227E-2,1.2574568212375674E-2,null,"9.75'",3.5301821784323464E-2,3.9431567440346094E-2,4.3704255565654979E-2,4.7794076637253262E-2,5.1413116147678316E-2,5.4390118498466561E-2,5.6676675632516868E-2,5.8305600150449555E-2,5.9341062949095628E-2,5.984201201846838E-2,5.984201201846838E-2,5.9341062949095628E-2,5.8305600150449555E-2,5.6676675632516868E-2,5.4390118498466561E-2,5.1413116147678316E-2,4.7794076637253262E-2,4.3704255565654979E-2,3.9431567440346094E-2,3.5301821784323464E-2]
[null,"11.25'",1.0830356613764542E-2,1.1721899376569041E-2,1.2289929845784626E-2,1.3055600221535887E-2,1.3704234378934442E-2,1.4226302739387678E-2,1.4625041416593751E-2,1.4910207177884785E-2,1.5092821894834711E-2,1.5181727371395684E-2,1.5181727371395684E-2,1.5092821894834711E-2,1.4910207177884785E-2,1.4625041416593751E-2,1.4226302739387678E-2,1.3704234378934442E-2,1.3055600221535887E-2,1.2289929845784626E-2,1.1721899376569041E-2,1.0830356613764542E-2,null,"11.25'",3.1430444423938254E-2,3.422423283901866E-2,3.7086167471332962E-2,3.9842078752183638E-2,4.232696580211625E-2,4.4426857499338696E-2,4.6088573718464643E-2,4.7305841950922481E-2,4.8097049981208423E-2,4.8485320263846311E-2,4.8485320263846311E-2,4.8097049981208423E-2,4.7305841950922481E-2,4.6088573718464643E-2,4.4426857499338696E-2,4.232696580211625E-2,3.9842078752183638E-2,3.7086167471332962E-2,3.422423283901866E-2,3.1430444423938254E-2]
[null,"12.75'",9.5171052683337698E-3,1.0144022405957336E-2,1.0462232293567707E-2,1.101067295642718E-2,1.1484877730386726E-2,1.1875425284464915E-2,1.2180537763235501E-2,1.2403123323644089E-2,1.2547866174616965E-2,1.2619016392734703E-2,1.2619016392734703E-2,1.2547866174616965E-2,1.2403123323644089E-2,1.2180537763235501E-2,1.1875425284464915E-2,1.1484877730386726E-2,1.101067295642718E-2,1.0462232293567707E-2,1.0144022405957336E-2,9.5171052683337698E-3,null,"12.75'",2.8469527541194427E-2,3.0399890011320492E-2,3.2361223382771365E-2,3.4256893508343274E-2,3.5987893890471474E-2,3.7478151667739719E-2,3.8682598860835568E-2,3.9582916712964211E-2,4.0177832303909561E-2,4.0472913306247485E-2,4.0472913306247485E-2,4.0177832303909561E-2,3.9582916712964211E-2,3.8682598860835568E-2,3.7478151667739719E-2,3.5987893890471474E-2,3.4256893508343274E-2,3.2361223382771365E-2,3.0399890011320492E-2,2.8469527541194427E-2]
[null,"14.25'",8.5163718232053303E-3,8.9652775929987896E-3,9.1192763521860051E-3,9.5167216565383642E-3,9.8655550557953109E-3,1.0157816187238147E-2,1.0390098897394388E-2,1.0562170877794506E-2,1.0675415248544148E-2,1.0731506770716475E-2,1.0731506770716475E-2,1.0675415248544148E-2,1.0562170877794506E-2,1.0390098897394388E-2,1.0157816187238147E-2,9.8655550557953109E-3,9.5167216565383642E-3,9.1192763521860051E-3,8.9652775929987896E-3,8.5163718232053303E-3,null,"14.25'",2.6222643508714352E-2,2.7583991874376476E-2,2.8957221861476375E-2,3.0287587372469837E-2,3.1513052266252853E-2,3.2581856468819621E-2,3.3458680879100686E-2,3.4123693516192453E-2,3.4568428428431761E-2,3.4790760466130943E-2,3.4790760466130943E-2,3.4568428428431761E-2,3.4123693516192453E-2,3.3458680879100686E-2,3.2581856468819621E-2,3.1513052266252853E-2,3.0287587372469837E-2,2.8957221861476375E-2,2.7583991874376476E-2,2.6222643508714352E-2]
[null,"15.75'",7.7400551620623627E-3,8.066579458838468E-3,8.1116251524050546E-3,8.4027967934876494E-3,8.6611735553114629E-3,8.8804194784833611E-3,9.0569360242975742E-3,9.1892305455860152E-3,9.2771018190352557E-3,9.3208822897930046E-3,9.3208822897930046E-3,9.2771018190352557E-3,9.1892305455860152E-3,9.0569360242975742E-3,8.8804194784833611E-3,8.6611735553114629E-3,8.4027967934876494E-3,8.1116251524050546E-3,8.066579458838468E-3,7.7400551620623627E-3,null,"15.75'",2.4452342505576593E-2,2.5422007745451052E-2,2.6393554779741178E-2,2.7336397243179759E-2,2.8210450638713448E-2,2.8979877831791533E-2,2.9617887182728533E-2,3.0106862831207379E-2,3.0436728227129194E-2,3.0602582541452719E-2,3.0602582541452719E-2,3.0436728227129194E-2,3.0106862831207379E-2,2.9617887182728533E-2,2.8979877831791533E-2,2.8210450638713448E-2,2.7336397243179759E-2,2.6393554779741178E-2,2.5422007745451052E-2,2.4452342505576593E-2]
[null,"17.25'",7.1259050589020378E-3,7.3664564426716671E-3,7.3387247509212987E-3,7.5540035018587959E-3,7.7465849114581875E-3,7.9115505019225103E-3,8.0456554889696483E-3,8.1470516975070822E-3,8.2148727190209953E-3,8.2488154336146941E-3,8.2488154336146941E-3,8.2148727190209953E-3,8.1470516975070822E-3,8.0456554889696483E-3,7.9115505019225103E-3,7.7465849114581875E-3,7.5540035018587959E-3,7.3387247509212987E-3,7.3664564426716671E-3,7.1259050589020378E-3,null,"17.25'",2.3041487967207466E-2,2.3735410864768922E-2,2.4426078124787531E-2,2.5097497466259652E-2,2.5723158425927584E-2,2.6277811009879932E-2,2.6741383265453909E-2,2.7099409037828995E-2,2.7342481025926256E-2,2.7465211283165557E-2,2.7465211283165557E-2,2.7342481025926256E-2,2.7099409037828995E-2,2.6741383265453909E-2,2.6277811009879932E-2,2.5723158425927584E-2,2.5097497466259652E-2,2.4426078124787531E-2,2.3735410864768922E-2,2.3041487967207466E-2]
[null,"18.75'",6.6304071953402696E-3,6.8093338389525766E-3,6.7328995343992979E-3,6.8931790142001161E-3,7.0374306914902773E-3,7.1618736721073464E-3,7.2637735516350842E-3,7.341332208458895E-3,7.3934842674837475E-3,7.419674098453951E-3,7.419674098453951E-3,7.3934842674837475E-3,7.341332208458895E-3,7.2637735516350842E-3,7.1618736721073464E-3,7.0374306914902773E-3,6.8931790142001161E-3,6.7328995343992979E-3,6.8093338389525766E-3,6.6304071953402696E-3,null,"18.75'",2.1903392961592653E-2,2.2399256995433367E-2,2.2889406915327454E-2,2.3367033957741937E-2,2.3814331497965226E-2,2.4213219799507673E-2,2.4548710434045946E-2,2.4809360079981239E-2,2.4987184365881661E-2,2.5077256775998938E-2,2.5077256775998938E-2,2.4987184365881661E-2,2.4809360079981239E-2,2.4548710434045946E-2,2.4213219799507673E-2,2.3814331497965226E-2,2.3367033957741937E-2,2.2889406915327454E-2,2.2399256995433367E-2,2.1903392961592653E-2]
[null,"20.25'",6.2229930145256667E-3,6.356932177523358E-3,6.2480735140839879E-3,6.3679321526054905E-3,6.4763151449033765E-3,6.570323230823967E-3,6.6477285969955601E-3,6.7069419266456744E-3,6.7469189424451143E-3,6.7670468292602183E-3,6.7670468292602183E-3,6.7469189424451143E-3,6.7069419266456744E-3,6.6477285969955601E-3,6.570323230823967E-3,6.4763151449033765E-3,6.3679321526054905E-3,6.2480735140839879E-3,6.356932177523358E-3,6.2229930145256667E-3,null,"20.25'",2.0970821517813071E-2,2.1325211059986849E-2,2.1669583898537535E-2,2.2006463697351524E-2,2.2323804817169182E-2,2.2608473608428201E-2,2.2849263782526292E-2,2.3037291956183561E-2,2.3166090049161852E-2,2.3231499201330497E-2,2.3231499201330497E-2,2.3166090049161852E-2,2.3037291956183561E-2,2.2849263782526292E-2,2.2608473608428201E-2,2.2323804817169182E-2,2.2006463697351524E-2,2.1669583898537535E-2,2.1325211059986849E-2,2.0970821517813071E-2]
[null,"21.75'",5.8819419278695519E-3,5.9824955367913067E-3,5.8523755000167961E-3,5.9421369361377209E-3,6.0236257627441104E-3,6.0946160178401571E-3,6.1533246845761908E-3,6.1984130166781743E-3,6.2289492701616284E-3,6.2443548262942159E-3,6.2443548262942159E-3,6.2289492701616284E-3,6.1984130166781743E-3,6.1533246845761908E-3,6.0946160178401571E-3,6.0236257627441104E-3,5.9421369361377209E-3,5.8523755000167961E-3,5.9824955367913067E-3,5.8819419278695519E-3,null,"21.75'",2.017930373860205E-2,2.0431058796420921E-2,2.0675751392568713E-2,2.0916493594749772E-2,2.1141132415832122E-2,2.1341136569536293E-2,2.1511355755926088E-2,2.1644956099626397E-2,2.1736825266475523E-2,2.178359311948776E-2,2.178359311948776E-2,2.1736825266475523E-2,2.1644956099626397E-2,2.1511355755926088E-2,2.1341136569536293E-2,2.1141132415832122E-2,2.0916493594749772E-2,2.0675751392568713E-2,2.0431058796420921E-2,2.017930373860205E-2]
[null,"23.25'",5.5916043933581117E-3,5.6670157960514887E-3,5.5233798564618668E-3,5.5904598179883766E-3,5.6515836913912151E-3,5.7050370532119726E-3,5.749406097803951E-3,5.7835926910097092E-3,5.8068048318869183E-3,5.8185344253115084E-3,5.8185344253115084E-3,5.8068048318869183E-3,5.7835926910097092E-3,5.749406097803951E-3,5.7050370532119726E-3,5.6515836913912151E-3,5.5904598179883766E-3,5.5233798564618668E-3,5.6670157960514887E-3,5.5916043933581117E-3,null,"23.25'",1.9520999311945036E-2,1.9691173999738361E-2,1.985466025091407E-2,2.0017372925107812E-2,2.0173825601251881E-2,2.0316730571323688E-2,2.0439645300865741E-2,2.0535038991492859E-2,2.0598968582658514E-2,2.0631601153971293E-2,2.0631601153971293E-2,2.0598968582658514E-2,2.0535038991492859E-2,2.0439645300865741E-2,2.0316730571323688E-2,2.0173825601251881E-2,2.0017372925107812E-2,1.985466025091407E-2,1.9691173999738361E-2,1.9520999311945036E-2]
[null,"24.75'",5.3405398970840044E-3,5.3967664678379913E-3,5.2450376356499399E-3,5.2948348708231133E-3,5.3403924639761156E-3,5.3803844858226289E-3,5.4136947796698705E-3,5.4394360911486639E-3,5.4569533939595703E-3,5.4658177954672923E-3,5.4658177954672923E-3,5.4569533939595703E-3,5.4394360911486639E-3,5.4136947796698705E-3,5.3803844858226289E-3,5.3403924639761156E-3,5.2948348708231133E-3,5.2450376356499399E-3,5.3967664678379913E-3,5.3405398970840044E-3,null,"24.75'",1.8967363299561796E-2,1.9075250549226635E-2,1.917705421512789E-2,1.9280672782221377E-2,1.9382575673120551E-2,1.9477280626324037E-2,1.9559902058229967E-2,1.9626346339222608E-2,1.9673446411517147E-2,1.9698531937746021E-2,1.9698531937746021E-2,1.9673446411517147E-2,1.9626346339222608E-2,1.9559902058229967E-2,1.9477280626324037E-2,1.9382575673120551E-2,1.9280672782221377E-2,1.917705421512789E-2,1.9075250549226635E-2,1.8967363299561796E-2]
[null,"26.25'",5.1202644504687121E-3,5.1616780493004694E-3,5.0056764907808696E-3,5.0421704453235735E-3,5.075723559638692E-3,5.1053055771562396E-3,5.1300365082053738E-3,5.1492055011176088E-3,5.1622794060144413E-3,5.1689043981025954E-3,5.1689043981025954E-3,5.1622794060144413E-3,5.1492055011176088E-3,5.1300365082053738E-3,5.1053055771562396E-3,5.075723559638692E-3,5.0421704453235735E-3,5.0056764907808696E-3,5.1616780493004694E-3,5.1202644504687121E-3,null,"26.25'",1.8497112749981927E-2,1.8556656101791486E-2,1.8610889932030736E-2,1.8669004127080231E-2,1.8728746236116107E-2,1.8785830799165883E-2,1.8836427628549868E-2,1.8877315474997436E-2,1.8905995319469616E-2,1.8920765528934118E-2,1.8920765528934118E-2,1.8905995319469616E-2,1.8877315474997436E-2,1.8836427628549868E-2,1.8785830799165883E-2,1.8728746236116107E-2,1.8669004127080231E-2,1.8610889932030736E-2,1.8556656101791486E-2,1.8497112749981927E-2]
[null,"27.75'",4.9244001259035339E-3,4.9542537259312175E-3,4.7966781993896415E-3,4.8228358848770225E-3,4.847053354326788E-3,4.8685261558171957E-3,4.8865600837453048E-3,4.9005880410355682E-3,4.910180051753559E-3,4.9150481480711135E-3,4.9150481480711135E-3,4.910180051753559E-3,4.9005880410355682E-3,4.8865600837453048E-3,4.8685261558171957E-3,4.847053354326788E-3,4.8228358848770225E-3,4.7966781993896415E-3,4.9542537259312175E-3,4.9244001259035339E-3,null,"27.75'",1.8094772890067595E-2,1.8115636852476871E-2,1.8131898658161484E-2,1.8153836763459143E-2,1.8180271771083611E-2,1.8207924664231531E-2,1.8233856590148912E-2,1.8255585530752936E-2,1.8271176968737229E-2,1.8279308137643932E-2,1.8279308137643932E-2,1.8271176968737229E-2,1.8255585530752936E-2,1.8233856590148912E-2,1.8207924664231531E-2,1.8180271771083611E-2,1.8153836763459143E-2,1.8131898658161484E-2,1.8115636852476871E-2,1.8094772890067595E-2]
[null,"29.25'",4.7480904764236392E-3,4.7688348977516538E-3,4.6115902579573955E-3,4.6296472481586427E-3,4.6465468355838683E-3,4.6616577306021183E-3,4.6744312647485449E-3,4.6844157253498869E-3,4.6912660418332239E-3,4.6947496605180801E-3,4.6947496605180801E-3,4.6912660418332239E-3,4.6844157253498869E-3,4.6744312647485449E-3,4.6616577306021183E-3,4.6465468355838683E-3,4.6296472481586427E-3,4.6115902579573955E-3,4.7688348977516538E-3,4.7480904764236392E-3,null,"29.25'",1.7745646169581485E-2,1.7736124913272595E-2,1.7722693188208846E-2,1.771643870496465E-2,1.7716977480341119E-2,1.7721779701570888E-2,1.7728575619546924E-2,1.7735444030469567E-2,1.7740883459634496E-2,1.7743864651934262E-2,1.7743864651934262E-2,1.7740883459634496E-2,1.7735444030469567E-2,1.7728575619546924E-2,1.7721779701570888E-2,1.7716977480341119E-2,1.771643870496465E-2,1.7722693188208846E-2,1.7736124913272595E-2,1.7745646169581485E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(C20:V39)","v":1.3544021291906985E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(Y20:AR39)","v":4.9940721818686445E-2}]
[]
[null,null,null,null,"Greater than Max Uniformity",null,null,null,null,null,"Daylight factor and uniformity ok",null,null,null,null,null,"Less than Min daylight factor",null,null,null,null,null,null,null,null,null,"Greater than Max Uniformity",null,null,null,null,null,"Daylight factor and uniformity ok",null,null,null,null,null,"Less than Min daylight factor"]
[]
[null,null,null,null,null,">20%",null,null,"10-20%",null,null,"7-10%",null,null,"4-7%",null,null,"2-4%",null,null,null,null,null,null,null,null,null,">20%",null,null,"10-20%",null,null,"7-10%",null,null,"4-7%",null,null,"2-4%"]
[null,null,null,null,null,"1-2%",null,null,"0.5-1%",null,null,"0.2-5%",null,null,"0.1-0.2%",null,null,"<0.1%",null,null,null,null,null,null,null,null,null,"1-2%",null,null,"0.5-1%",null,null,"0.2-5%",null,null,"0.1-0.2%",null,null,"<0.1%"]

{"sheet":"App I-8 Report","index":2,"n_rows":48,"n_cols":20,"rows_kept":48,"cut":false,"hidden":false,"merged":[[3,0,3,18],[4,0,4,18]]}
["Appendix I-8: Daylighting Factor Calculator Report"]
["B3 Guidelines - Version 3.0"]
[]
["PROJECT NAME"]
["Room (Name/ Number/ Other details)"]
["Alternative 1",null,null,null,null,null,null,null,null,null,"Alternative 2"]
[null,null,null,"Minimum Daylight Factor Required",{"$f":"minDF","v":0.01},null,null,null,null,null,null,null,null,"Minimum Daylight Factor Required",{"$f":"minDF","v":0.01}]
[null,null,null,"Max Uniformity Ratio Allowed",{"$f":"maxContrast","v":10},null,null,null,null,null,null,null,null,"Max Uniformity Ratio Allowed",{"$f":"maxContrast","v":10}]
[null,null,null,null,{"$f":"Tool!C10","v":0.45999999999999996},{"$f":"\"area achieves \"&TEXT(minDF,\"0.0%\")&\" Daylight Factor\"","v":"area achieves 1.0% Daylight Factor"},null,null,null,null,null,null,null,null,{"$f":"Tool!AJ10","v":1},{"$f":"\"area achieves \"&TEXT(minDF,\"0.0%\")&\" Daylight Factor\"","v":"area achieves 1.0% Daylight Factor"}]
[null,null,null,null,{"$f":"Tool!C11","v":0},{"$f":"\"area exceeds Max Uniformity Ratio\"","v":"area exceeds Max Uniformity Ratio"},null,null,null,null,null,null,null,null,{"$f":"Tool!AJ11","v":0.03},{"$f":"\"area exceeds Max Uniformity Ratio\"","v":"area exceeds Max Uniformity Ratio"}]
["Minimum daylight factor Achieved",null,null,null,{"$f":"MIN(Tool!$C$20:$V$39)","v":4.6115902579573955E-3},"Maximum daylight factor achieved",null,null,null,{"$f":"MAX(Tool!$C$20:$V$39)","v":4.0155002935387235E-2},"Minimum daylight factor Achieved",null,null,null,{"$f":"MIN(Tool!$Y$20:$AR$39)","v":1.771643870496465E-2},"Maximum daylight factor achieved",null,null,null,{"$f":"MAX(Tool!$Y$20:$AR$39)","v":0.19694286296129179}]
["Design Ambient Illuminance",null,null,null,50,"fc",null,null,null,null,"Design Ambient Illuminance",null,null,null,50,"fc"]
["On an overcast day in each month the average daylighting is predicted to be:",null,null,null,null,null,null,null,null,null,"On an overcast day in each month the average daylighting is predicted to be:"]
["Month","Average Daylight FC*","% of Amb. Illum.",null,"Overcast days in month**",null,null,null,null,null,"Month","Average Daylight FC*","% of Amb. Illum.",null,"Overcast days in month**"]
["Jan",{"$f":"VLOOKUP(A15,avgIlumTbl,2,FALSE)*alt1AvgDF/10.76","v":8.1412379120395038},{"$f":"B15/$E$12","v":0.16282475824079007},null,0.4838709677419355,null,null,null,null,null,"Jan",{"$f":"VLOOKUP(K15,avgIlumTbl,2,FALSE)*alt2AvgDF/10.76","v":30.019097656606132},{"$f":"L15/$O$12","v":0.60038195313212261},null,0.4838709677419355]
["Feb",9.716313348224249,0.19432626696448499,null,0.5,null,null,null,null,null,"Feb",35.826856113760279,{"$f":"L16/$O$12","v":0.71653712227520561},null,0.5]
["Mar",13.780892904565379,0.27561785809130757,null,0.54838709677419351,null,null,null,null,null,"Mar",50.814135929574249,1.0162827185914849,null,0.54838709677419351]
["Apr",15.955957025259881,0.31911914050519763,null,0.5,null,null,null,null,null,"Apr",58.834226111676713,1.1766845222335343,null,0.5]
["May",16.693383863686844,0.3338676772737369,null,0.4838709677419355,null,null,null,null,null,"May",61.553332040838256,1.2310666408167652,null,0.4838709677419355]
["Jun",17.916877236896283,0.35833754473792567,null,0.4,null,null,null,null,null,"Jun",66.064705796206582,1.3212941159241316,null,0.4]
["Jul",16.836880000050915,0.33673760000101827,null,0.29032258064516131,null,null,null,null,null,"Jul",62.082443777578987,1.2416488755515798,null,0.29032258064516131]
["Aug",16.072148228793541,0.32144296457587079,null,0.32258064516129031,null,null,null,null,null,"Aug",59.262656667742085,1.1852531333548417,null,0.32258064516129031]
["Sep",11.827296259697155,0.2365459251939431,null,0.4,null,null,null,null,null,"Sep",43.610660352820624,0.87221320705641248,null,0.4]
["Oct",9.5744192420907179,0.19148838484181435,null,0.45161290322580644,null,null,null,null,null,"Oct",35.303651525595598,0.70607303051191195,null,0.45161290322580644]
["Nov",8.0671122275629372,0.16134224455125876,null,0.6,null,null,null,null,null,"Nov",29.745774829634804,0.59491549659269605,null,0.6]
["Dec",6.8195629718441193,0.13639125943688238,null,0.58064516129032262,null,null,null,null,null,"Dec",25.145700081362566,0.50291400162725131,null,0.58064516129032262]
[]
["Summary of Inputs",null,null,null,null,null,null,null,null,null,"Summary of Inputs"]
["Geometry",null,null,null,null,"Surface Properties",null,null,null,null,"Geometry",null,null,null,null,"Surface Properties"]
[{"$f":"Tool!U5","v":"Room Width"},null,null,{"$f":"Tool!V5","v":30},"'",{"$f":"Tool!P10","v":"Ceiling Reflectance"},null,null,{"$f":"Tool!Q10","v":0.8},null,{"$f":"Tool!Y5","v":"Room Width"},null,null,{"$f":"Tool!X5","v":30},"'",{"$f":"Tool!AD10","v":"Ceiling Reflectance"},null,null,{"$f":"Tool!AC10","v":0.9}]
[{"$f":"Tool!U6","v":"Room Depth"},null,null,{"$f":"Tool!V6","v":30},"'",{"$f":"Tool!P11","v":"Wall Reflectance"},null,null,{"$f":"Tool!Q11","v":0.5},null,{"$f":"Tool!Y6","v":"Room Depth"},null,null,{"$f":"Tool!X6","v":30},"'",{"$f":"Tool!AD11","v":"Wall Reflectance"},null,null,{"$f":"Tool!AC11","v":0.75}]
[{"$f":"Tool!U7","v":"Ceiling Height"},null,null,{"$f":"Tool!V7","v":10},"'",{"$f":"Tool!P12","v":"Floor Reflectance"},null,null,{"$f":"Tool!Q12","v":0.2},null,{"$f":"Tool!Y7","v":"Ceiling Height"},null,null,{"$f":"Tool!X7","v":10},"'",{"$f":"Tool!AD12","v":"Floor Reflectance"},null,null,{"$f":"Tool!AC12","v":0.2}]
[{"$f":"Tool!U8","v":"Number of Vision Windows"},null,null,{"$f":"Tool!V8","v":1},null,{"$f":"Tool!P13","v":"Glass Visible Transmittance"},null,null,{"$f":"Tool!Q13","v":0.5},null,{"$f":"Tool!Y8","v":"Number of Vision Windows"},null,null,{"$f":"Tool!X8","v":1},null,{"$f":"Tool!AD13","v":"Glass Visible Transmittance"},null,null,{"$f":"Tool!AC13","v":0.7}]
[{"$f":"Tool!U9","v":"Width of each window"},null,null,{"$f":"Tool!V9","v":24},"'",null,null,null,null,null,{"$f":"Tool!Y9","v":"Width of each window"},null,null,{"$f":"Tool!X9","v":24},"'"]
[{"$f":"Tool!U10","v":"Sill - Vision"},null,null,{"$f":"Tool!V10","v":0},"'",null,null,null,null,null,{"$f":"Tool!Y10","v":"Sill - Vision"},null,null,{"$f":"Tool!X10","v":4},"'"]
[{"$f":"Tool!U11","v":"Head - Vision"},null,null,{"$f":"Tool!V11","v":2},"'",null,null,null,null,null,{"$f":"Tool!Y11","v":"Head - Vision"},null,null,{"$f":"Tool!X11","v":10},"'"]
[{"$f":"Tool!U12","v":"Number of Clerestoreys"},null,null,{"$f":"Tool!V12","v":1},null,null,null,null,null,null,{"$f":"Tool!Y12","v":"Number of Clerestoreys"},null,null,{"$f":"Tool!X12","v":0}]
[{"$f":"Tool!U13","v":"Width of clerestorey"},null,null,{"$f":"Tool!V13","v":28},null,null,null,null,null,null,{"$f":"Tool!Y13","v":"Width of clerestorey"},null,null,{"$f":"Tool!X13","v":0}]
[{"$f":"Tool!U14","v":"Sill - Clerestorey"},null,null,{"$f":"Tool!V14","v":7},"'",null,null,null,null,null,{"$f":"Tool!Y14","v":"Sill - Clerestorey"},null,null,{"$f":"Tool!X14","v":0},"'"]
[{"$f":"Tool!U15","v":"Head - Clerestorey"},null,null,{"$f":"Tool!V15","v":9},"'",null,null,null,null,null,{"$f":"Tool!Y15","v":"Head - Clerestorey"},null,null,{"$f":"Tool!X15","v":0},"'"]
[]
["Summary Geometry Information",null,null,null,null,null,null,null,null,null,"Summary Geometry Information"]
["Exterior Wall Area",null,null,{"$f":"D30*D32","v":300},"sf",null,null,null,null,null,"Exterior Wall Area",null,null,{"$f":"N30*N32","v":300},"sf"]
["Window Area",null,null,{"$f":"D33*D34*(D36-D35)+D37*D38*(D40-D39)","v":104},"sf",null,null,null,null,null,"Window Area",null,null,{"$f":"N33*N34*(N36-N35)+N37*N38*(N40-N39)","v":144},"sf"]
["Floor Area",null,null,{"$f":"D31*D30","v":900},"sf",null,null,null,null,null,"Floor Area",null,null,{"$f":"N31*N30","v":900},"sf"]
["Window/ Floor Area",null,null,{"$f":"D44/D45","v":0.11555555555555555},null,null,null,null,null,null,"Window/ Floor Area",null,null,{"$f":"N44/N45","v":0.16}]
[]
["*Based on overcast day sky data by Claude Robbins 1986",null,null,null,null,"**Source - NOAA",null,null,null,null,null,null,null,null,null,null,null,null,null,"© The Weidt Group 2011"]

{"sheet":"App I-8 Summary Form","index":3,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[3,0,3,5],[4,0,4,4],[5,0,5,5],[6,0,6,5]]}
["Appendix I-8: Daylighting Factor Calculator Summary Form"]
["B3 Guidelines - Version 3.0"]
[]
["Project Name: "]
["Overall continuously occupied spaces that achieve the minimum daylight factor",null,null,null,null,{"$f":"SUMPRODUCT(C9:C65537,D9:D65537)/IF(SUM(C9:C65537) <> 0, SUM(C9:C65537), 1)","v":0}]
[]
["List all the continuously occupied spaces below and enter results from the Tool Sheet"]
["Room Name","Room Number","Room Area","% Area above min Daylight Factor","% Area exceeding Uniformity Ratio","% Window to Wall Ratio"]

{"sheet":"Interface","index":4,"n_rows":39,"n_cols":6,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,null,"DF for color",0.01]
[null,null,null,"Uniformity Ratio for Color",10]
[null,null,null,"Z point for calculation grid",2.5]
[]
[]
[]
[]
[]
[null,null,null,null,"Alternative 1","Alternative 2"]
[null,null,"Room","Room Dimensions",{"$f":"COLUMN()-COLUMN($C13)+1","v":3},{"$f":"COLUMN()-COLUMN($C13)+1","v":4}]
[null,null,"Room Width","Width",{"$f":"Tool!V5","v":30},{"$f":"Tool!X5","v":30}]
[null,null,"Room depth","Depth",{"$f":"Tool!V6","v":30},{"$f":"Tool!X6","v":30}]
[null,null,"Ceiling Ht","Ceiling Height",{"$f":"Tool!V7","v":10},{"$f":"Tool!X7","v":10}]
[null,null,"wall thickness",null,0.75,0.75]
[null,null,"PartitionHt","Partition Height",5,5]
[null,null,"Windows","Windows"]
[null,null,"Nwin","Number of Windows",{"$f":"Tool!V8","v":1},{"$f":"Tool!X8","v":1}]
[null,null,"Wwin","Width of each window",{"$f":"Tool!V9","v":24},{"$f":"Tool!X9","v":24}]
[null,null,"ClearStorey","Clerestorey?",{"$f":"IF(AND(E28>E27,E27>0),\"y\",\"n\")","v":"y"},{"$f":"IF(AND(F28>F27,F27>0),\"y\",\"n\")","v":"n"}]
[null,null,"SillVision","Sill Height",{"$f":"Tool!V10","v":0},{"$f":"Tool!X10","v":4}]
[null,null,"HeadVision","Head Height",{"$f":"Tool!V11","v":2},{"$f":"Tool!X11","v":10}]
[null,null,"NClr","Number of Clerestoreys",{"$f":"Tool!V12","v":1},{"$f":"Tool!X12","v":0}]
[null,null,"WClr","Width of Clerestorey",{"$f":"Tool!V13","v":28},{"$f":"Tool!X13","v":0}]
[null,null,"SillClr","Sill Height",{"$f":"Tool!V14","v":7},{"$f":"Tool!X14","v":0}]
[null,null,"HeadClr","Head Height",{"$f":"Tool!V15","v":9},{"$f":"Tool!X15","v":0}]
[null,null,"."]
[null,null,"ClgRefl","Ceiling",{"$f":"Tool!Q10","v":0.8},{"$f":"Tool!AC10","v":0.9}]
[null,null,"WallRefl","Wall",{"$f":"Tool!Q11","v":0.5},{"$f":"Tool!AC11","v":0.75}]
[null,null,"FlrRefl","Floor",{"$f":"Tool!Q12","v":0.2},{"$f":"Tool!AC12","v":0.2}]
[null,null,"Tvis","Visible Transmittance",{"$f":"Tool!Q13","v":0.5},{"$f":"Tool!AC13","v":0.7}]
[]
[]
[null,null,"Checks"]
[null,null,null,"Spandrel Width",{"$f":"(E14-E20*E21)/(E20+1)","v":3},{"$f":"(F14-F20*F21)/(F20+1)","v":3}]
[null,null,null,"WinFitVert",{"$f":"E16-MAX(E24,E28)","v":1},{"$f":"F16-MAX(F24,F28)","v":0}]
[null,null,null,"WinIntersectVert",{"$f":"IF(E27=0,0,E27-E24)","v":5},{"$f":"IF(F27=0,0,F27-F24)","v":0}]

{"sheet":"Calcs","index":5,"n_rows":55,"n_cols":105,"rows_kept":55,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Room Width",{"$f":"VLOOKUP(B2,inputTbl,HLOOKUP($B$7&$C$7,inputTbl,2,FALSE),FALSE)","v":30},null,null,null,null,"Nwin",{"$f":"VLOOKUP(H2,inputTbl,HLOOKUP($B$7&$C$7,inputTbl,2,FALSE),FALSE)","v":1},null,null,null,null,null,"ReftPtHt",{"$f":"Interface!E6","v":2.5},null,null,"Ext Obst Ht",7.5,null,null,"ClgRefl",{"$f":"VLOOKUP(W2,inputTbl,HLOOKUP($B$7&$C$7,inputTbl,2,FALSE),FALSE)","v":0.9}]
[null,"Room depth",{"$f":"VLOOKUP(B3,inputTbl,HLOOKUP($B$7&$C$7,inputTbl,2,FALSE),FALSE)","v":30},null,null,null,null,"Wwin",24,null,null,null,null,null,"RefPtX",{"$f":"HLOOKUP(xPosition,gridXtbl,2,FALSE)","v":29.25},null,null,"Ext Obst Dist",50,null,null,"WallRefl",{"$f":"VLOOKUP(W3,inputTbl,HLOOKUP($B$7&$C$7,inputTbl,2,FALSE),FALSE)","v":0.75}]
[null,"Ceiling Ht",{"$f":"VLOOKUP(B4,inputTbl,HLOOKUP($B$7&$C$7,inputTbl,2,FALSE),FALSE)","v":10},null,null,null,null,"ClearStorey","n",null,null,null,null,null,"RefPtDepth",{"$f":"VLOOKUP(yPosition,gridYtbl,2,FALSE)","v":29.25},null,null,"Avg Ext Obstruction Refl",0.1,null,null,"FlrRefl",{"$f":"VLOOKUP(W4,inputTbl,HLOOKUP($B$7&$C$7,inputTbl,2,FALSE),FALSE)","v":0.2}]
[null,"wall thickness",{"$f":"VLOOKUP(B5,inputTbl,HLOOKUP($B$7&$C$7,inputTbl,2,FALSE),FALSE)","v":0.75},null,null,null,null,"SillVision",4,null,null,null,null,null,"Now X Position",20,null,null,null,null,null,null,"Tvis",{"$f":"VLOOKUP(W5,inputTbl,HLOOKUP($B$7&$C$7,inputTbl,2,FALSE),FALSE)","v":0.7}]
[null,"PartitionHt",{"$f":"VLOOKUP(B6,inputTbl,HLOOKUP($B$7&$C$7,inputTbl,2,FALSE),FALSE)","v":5},null,null,null,null,"HeadVision",10,null,null,null,null,null,"Now Y Position",20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SLOPE"]
[null,"Alternative ",2,null,null,null,null,"NClr",0,null,null,null,null,null,"nXpos",20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-5.0000000000000002E-5]
[null,"nAlts",2,null,null,null,null,"wClr",0,null,null,null,null,null,"nYpos",20]
[null,null,null,null,null,null,null,"SillClr",0]
[null,null,null,null,null,null,null,"HeadClr",0]
[null,null,null,null,null,null,null,"SpandrelW",{"$f":"(roomwidth-nWin*wWin)/(nWin+1)","v":3}]
[null,null,null,null,null,null,null,"SpandrelC",{"$f":"(roomwidth-nClr*wClr)/(nClr+1)","v":30}]
[]
[null,"Room",null,null,null,"Window","Window",null,null,null,null,null,null,null,"Ref Point",null,null,null,"Exterior Obstruction",null,null,null,"Interior Surfaces",null,null,null,null,null,"For Window from Ref Point to Head",null,null,null,null,null,null,"Sky Factors",null,null,null,null,null,"For Window from Sill to Ref Point",null,null,null,null,null,null,"Sky Factors",null,null,null,null,null,"For Exterior Obstruction",null,null,null,null,null,null,"Sky Factors",null,null,null,null,null,"For Effective Aperture",null,null,null,null,null,null,null,null,null,"Sky Components",null,null,null,null,null,"ERC",null,"For IRC",null,null,null,null,null,null,null,null,null,null,null,null,"IRC","Total","Total","Total","Total","Combined"]
[null,"Width","Depth","Ceiling Ht",null,"W",null,"Width","Sill","Head","xW","WinCondition","WinW",null,"Height","Depth","xP",null,"Ht of Ext Obstruction","Dist from Win","Angle in Degrees",null,"Ceiling Refl","Wall Refl","Floor Refl","Tvis",null,null,"W","H","D","W/D","H/D","D2+H2","D2+W2","SFH","SFV","SFP","T0","Angle",null,"W","H","D","W/D","H/D","D2+H2","D2+W2","SFH","SFV","SFP","T0","Angle",null,"W","H","D","W/D","H/D","D2+H2","D2+W2","SFH","SFV","SFP","T0","Angle",null,"SFH","SFV","SFP","Angle Subt by Aperture","sina","sinb","T0","Avg Angle of Elev","CIE sky multiplier",null,"SCH","SCV","SCP","Win/Flr Ratio",null,"1/n","ERC",null,"Ceiling Area","Wall Area","Floor Area","Wall above","Wall below","Win above","Win below","Win Refl","Rcw","Rfw","A","R","C","IRC","SC","ERC","IRC","DF","DF"]
[null,{"$f":"roomwidth","v":30},{"$f":"roomdepth","v":30},{"$f":"ClgHt","v":10},null,1,"v",{"$f":"IF(F16>nWin,0,wWin)","v":24},{"$f":"IF(G16=\"v\",SillVision,SillClr)","v":4},{"$f":"IF(G16=\"v\",HeadVision,HeadClr)","v":10},{"$f":"B16-F16*H16-F16*spandrelW","v":3},{"$f":"IF(Q16<K16,1,IF(Q16=K16,2,IF(Q16=K16+H16,4,IF(Q16<K16+H16,3,5))))","v":5},{"$f":"IF(OR(L16=2,L16=4),0,IF(L16=1,K16+H16-Q16,Q16-K16))","v":26.25},null,{"$f":"RefPtHt","v":2.5},{"$f":"RefPtDepth","v":29.25},{"$f":"RefPtWidth","v":29.25},null,{"$f":"ExtObstHt","v":7.5},{"$f":"ExtObstDist","v":50},{"$f":"DEGREES(ATAN(S16/(T16+P16)))","v":5.4062121722946257},null,{"$f":"ClgRefl","v":0.9},{"$f":"WallRefl","v":0.75},{"$f":"FlrRefl","v":0.2},{"$f":"Tvis","v":0.7},null,null,{"$f":"M16","v":26.25},{"$f":"J16-O16","v":7.5},{"$f":"$P16","v":29.25},{"$f":"AC16/AE16","v":0.89743589743589747},{"$f":"AD16/AE16","v":0.25641025641025639},{"$f":"AE16^2+AD16^2","v":911.8125},{"$f":"AC16^2+AE16^2","v":1544.625},{"$f":"50/PI()*(ATAN(AF16)-AE16/SQRT(AH16)*ATAN(AC16/SQRT(AH16)))*1/100","v":6.0829730259983209E-3},{"$f":"50/PI()*((AC16/SQRT(AI16)*ATAN(AD16/SQRT(AI16)))+(AD16/SQRT(AH16)*ATAN(AC16/SQRT(AI16))))*1/100","v":4.3322429737986251E-2},{"$f":"50/PI()*(ATAN(AG16)-AE16/SQRT(AI16)*ATAN(AD16/SQRT(AH16)))*1/100","v":1.1111823921732281E-2},{"$f":"(1.018*$Z16)*COS(RADIANS(AN16))*(1+(SIN(RADIANS(AN16))^3))","v":0.7008464299173669},{"$f":"DEGREES(ATAN(AG16))","v":14.381394591090604},null,{"$f":"AC16","v":26.25},{"$f":"IF(I16-O16>0,I16-O16,0)","v":1.5},{"$f":"AE16","v":29.25},{"$f":"AP16/AR16","v":0.89743589743589747},{"$f":"AQ16/AR16","v":5.128205128205128E-2},{"$f":"AR16^2+AQ16^2","v":857.8125},{"$f":"AP16^2+AR16^2","v":1544.625},{"$f":"50/PI()*(ATAN(AS16)-AR16/SQRT(AU16)*ATAN(AP16/SQRT(AU16)))*1/100","v":2.5651145246361444E-4},{"$f":"50/PI()*((AP16/SQRT(AV16)*ATAN(AQ16/SQRT(AV16)))+(AQ16/SQRT(AU16)*ATAN(AP16/SQRT(AV16))))*1/100","v":8.8550172933185411E-3},{"$f":"50/PI()*(ATAN(AT16)-AR16/SQRT(AV16)*ATAN(AQ16/SQRT(AU16)))*1/100","v":2.0935649785039814E-3},{"$f":"(1.018*$Z16)*COS(RADIANS(BA16))*(1+(SIN(RADIANS(BA16))^3))","v":0.71176042961690533},{"$f":"DEGREES(ATAN(AT16))","v":2.9356734464211725},null,{"$f":"AP16","v":26.25},{"$f":"S16","v":7.5},{"$f":"P16+T16","v":79.25},{"$f":"BC16/BE16","v":0.33123028391167192},{"$f":"BD16/BE16","v":9.4637223974763401E-2},{"$f":"BE16^2+BD16^2","v":6336.8125},{"$f":"BC16^2+BE16^2","v":6969.625},{"$f":"50/PI()*(ATAN(BF16)-BE16/SQRT(BH16)*ATAN(BC16/SQRT(BH16)))*1/100","v":4.3691204990615421E-4},{"$f":"50/PI()*((BC16/SQRT(BI16)*ATAN(BD16/SQRT(BI16)))+(BD16/SQRT(BH16)*ATAN(BC16/SQRT(BI16))))*1/100","v":9.0518152374272805E-3},{"$f":"50/PI()*(ATAN(BG16)-BE16/SQRT(BI16)*ATAN(BD16/SQRT(BH16)))*1/100","v":8.2470666545968023E-4},{"$f":"(1.018*$Z16)*COS(RADIANS(BN16))*(1+(SIN(RADIANS(BN16))^3))","v":0.71002349830710032},{"$f":"DEGREES(ATAN(BG16))","v":5.4062121722946257},null,{"$f":"AJ16-MAX(AW16,BJ16)","v":5.6460609760921668E-3},{"$f":"AK16-MAX(AX16,BK16)","v":3.4270614500558974E-2},{"$f":"AL16-MAX(AY16,BL16)","v":9.0182589432282988E-3},{"$f":"IF(AN16-MAX(BA16,BN16)=0,0.0001,AN16-MAX(BA16,BN16))","v":8.9751824187959777},{"$f":"SIN(RADIANS(AN16))","v":0.24837535026770383},{"$f":"SIN(RADIANS(MAX(BA16,BN16)))","v":9.4216254440907712E-2},{"$f":"(1.018*$Z16)*((BT16+BT16^4/4)-(BU16+BU16^4/4))/RADIANS(BS16)","v":0.70552313597902339},{"$f":"AN16-BS16/2","v":9.8938033816926154},{"$f":"-5*10^(-7)*BW16^3-2*10^(-5)*BW16^2+0.0154*BW16+0.4273","v":0.57722258609670241},null,{"$f":"BP16*$BX16*$BV16","v":2.2993238300044131E-3},{"$f":"BQ16*$BX16*$BV16","v":1.3956498331084213E-2},{"$f":"BR16*$BX16*$BV16","v":3.6726308449589701E-3},{"$f":"((J16-I16)*M16)/(B16*C16)","v":0.17499999999999999},null,{"$f":"IF(BN16>BA16,(BN16-BA16)/AN16-BA16,0.00001)","v":-2.7638863008682666},null,null,{"$f":"B16*C16","v":900},{"$f":"2*(B16+C16)*D16","v":1200},{"$f":"B16*C16","v":900},{"$f":"((J16-I16)/2+I16)*2*(B16+C16)-CM16","v":761.25},{"$f":"CI16-CK16","v":438.75},{"$f":"(J16-I16)*M16/2","v":78.75},{"$f":"(J16-I16)*M16-CM16","v":78.75},{"$f":"1-Z16","v":0.30000000000000004},{"$f":"(CH16*W16+CK16*X16+CM16*CO16)/(CH16+CK16+CM16)","v":0.80721982758620692},{"$f":"(CJ16*Y16+CL16*X16+CN16*CO16)/(CJ16+CL16+CN16)","v":0.37579365079365079},{"$f":"SUM(CH16:CJ16)","v":3000},{"$f":"(CH16*W16+(CK16+CL16)*X16+CJ16*Y16+(CM16+CN16)*CO16)/CR16","v":0.64575000000000005},{"$f":"8*10^-5*BN16^3-0.0078*BN16^2-0.2915*BN16+39","v":37.208758182671367},{"$f":"IF(BZ16=0,0,Z16*(CM16+CN16)/(CR16*(1-CS16))*(CT16*CQ16+5*CP16)*1/100)","v":1.8692875016821455E-2},{"$f":"IF(H16=0,0,IF(L16=3,BZ16+BZ17,ABS(BZ16-BZ17)))","v":2.009246489623198E-3},{"$f":"IF(H16=0,0,IF(L16=3,CF16+CF17,ABS(CF16-CF17)))","v":0},{"$f":"IF(H16=0,0,IF(L16=3,CU16+CU17,ABS(CU16-CU17)))","v":1.7198899679958284E-2},{"$f":"BZ16+CF16+CU16","v":2.099219884682587E-2},{"$f":"CV16+CW16+(IF(CX16<0,0,CX16))","v":1.9208146169581483E-2}]
[null,30,30,10,null,1,"v",24,4,10,3,{"$f":"IF(Q17<K17,1,IF(Q17=K17,2,IF(Q17=K17+H17,4,IF(Q17<K17+H17,3,5))))","v":5},{"$f":"ABS(M16-H17)","v":2.25},null,2.5,29.25,29.25,null,7.5,50,{"$f":"DEGREES(ATAN(S17/(T17+P17)))","v":5.4062121722946257},null,0.9,0.75,0.2,0.7,null,null,2.25,7.5,{"$f":"$P17","v":29.25},{"$f":"AC17/AE17","v":7.6923076923076927E-2},{"$f":"AD17/AE17","v":0.25641025641025639},{"$f":"AE17^2+AD17^2","v":911.8125},{"$f":"AC17^2+AE17^2","v":860.625},{"$f":"50/PI()*(ATAN(AF17)-AE17/SQRT(AH17)*ATAN(AC17/SQRT(AH17)))*1/100","v":7.5238268326022683E-4},{"$f":"50/PI()*((AC17/SQRT(AI17)*ATAN(AD17/SQRT(AI17)))+(AD17/SQRT(AH17)*ATAN(AC17/SQRT(AI17))))*1/100","v":6.081145509375491E-3},{"$f":"50/PI()*(ATAN(AG17)-AE17/SQRT(AI17)*ATAN(AD17/SQRT(AH17)))*1/100","v":1.31633420278985E-3},{"$f":"(1.018*$Z17)*COS(RADIANS(AN17))*(1+(SIN(RADIANS(AN17))^3))","v":0.7008464299173669},{"$f":"DEGREES(ATAN(AG17))","v":14.381394591090604},null,{"$f":"AC17","v":2.25},{"$f":"IF(I17-O17>0,I17-O17,0)","v":1.5},29.25,{"$f":"AP17/AR17","v":7.6923076923076927E-2},{"$f":"AQ17/AR17","v":5.128205128205128E-2},{"$f":"AR17^2+AQ17^2","v":857.8125},{"$f":"AP17^2+AR17^2","v":860.625},{"$f":"50/PI()*(ATAN(AS17)-AR17/SQRT(AU17)*ATAN(AP17/SQRT(AU17)))*1/100","v":3.198612910505701E-5},{"$f":"50/PI()*((AP17/SQRT(AV17)*ATAN(AQ17/SQRT(AV17)))+(AQ17/SQRT(AU17)*ATAN(AP17/SQRT(AV17))))*1/100","v":1.2475318485477087E-3},{"$f":"50/PI()*(ATAN(AT17)-AR17/SQRT(AV17)*ATAN(AQ17/SQRT(AU17)))*1/100","v":3.4671128422857703E-5},{"$f":"(1.018*$Z17)*COS(RADIANS(BA17))*(1+(SIN(RADIANS(BA17))^3))","v":0.71176042961690533},{"$f":"DEGREES(ATAN(AT17))","v":2.9356734464211725},null,{"$f":"AP17","v":2.25},{"$f":"S17","v":7.5},{"$f":"P17+T17","v":79.25},{"$f":"BC17/BE17","v":2.8391167192429023E-2},{"$f":"BD17/BE17","v":9.4637223974763401E-2},{"$f":"BE17^2+BD17^2","v":6336.8125},{"$f":"BC17^2+BE17^2","v":6285.625},{"$f":"50/PI()*(ATAN(BF17)-BE17/SQRT(BH17)*ATAN(BC17/SQRT(BH17)))*1/100","v":4.0088777459303208E-5},{"$f":"50/PI()*((BC17/SQRT(BI17)*ATAN(BD17/SQRT(BI17)))+(BD17/SQRT(BH17)*ATAN(BC17/SQRT(BI17))))*1/100","v":8.5145444051046672E-4},{"$f":"50/PI()*(ATAN(BG17)-BE17/SQRT(BI17)*ATAN(BD17/SQRT(BH17)))*1/100","v":7.2429255017495572E-5},{"$f":"(1.018*$Z17)*COS(RADIANS(BN17))*(1+(SIN(RADIANS(BN17))^3))","v":0.71002349830710032},{"$f":"DEGREES(ATAN(BG17))","v":5.4062121722946257},null,{"$f":"AJ17-MAX(AW17,BJ17)","v":7.1229390580092365E-4},{"$f":"AK17-MAX(AX17,BK17)","v":4.8336136608277819E-3},{"$f":"AL17-MAX(AY17,BL17)","v":1.2439049477723544E-3},8.9751824187959777,{"$f":"SIN(RADIANS(AN17))","v":0.24837535026770383},{"$f":"SIN(RADIANS(MAX(BA17,BN17)))","v":9.4216254440907712E-2},{"$f":"(1.018*$Z17)*((BT17+BT17^4/4)-(BU17+BU17^4/4))/RADIANS(BS17)","v":0.70552313597902339},9.8938033816926154,0.57722258609670241,null,{"$f":"BP17*$BX17*$BV17","v":2.9007734038121499E-4},{"$f":"BQ17*$BX17*$BV17","v":1.9684596256465863E-3},{"$f":"BR17*$BX17*$BV17","v":5.0657268860262485E-4},1.4999999999999999E-2,null,{"$f":"IF(BN17>BA17,(BN17-BA17)/AN17-BA17,0.00001)","v":-2.7638863008682666},null,null,{"$f":"B17*C17","v":900},{"$f":"2*(B17+C17)*D17","v":1200},{"$f":"B17*C17","v":900},833.25,{"$f":"CI17-CK17","v":366.75},6.75,6.75,{"$f":"1-Z17","v":0.30000000000000004},0.82584051724137941,0.35892226148409895,{"$f":"SUM(CH17:CJ17)","v":3000},0.63134999999999997,{"$f":"8*10^-5*BN17^3-0.0078*BN17^2-0.2915*BN17+39","v":37.208758182671367},{"$f":"IF(BZ17=0,0,Z17*(CM17+CN17)/(CR17*(1-CS17))*(CT17*CQ17+5*CP17)*1/100)","v":1.49397533686317E-3},null,null,null,1.7840526772443851E-3]
[null,30,30,10,null,2,"v",0,4,10,24,5,{"$f":"IF(OR(L18=2,L18=4),0,IF(L18=1,K18+H18-Q18,Q18-K18))","v":5.25},null,2.5,29.25,29.25,null,7.5,50,5.4062121722946257,null,0.9,0.75,0.2,0.7,null,null,5.25,7.5,29.25,0.17948717948717949,0.25641025641025639,911.8125,883.125,1.7265827480469865E-3,1.3863166127828929E-2,1.8116365351201463E-3,0.7008464299173669,14.381394591090604,null,5.25,1.5,29.25,0.17948717948717949,5.128205128205128E-2,857.8125,883.125,7.3365955470612406E-5,2.8433091922860504E-3,1.3877770759609259E-4,0.71176042961690533,2.9356734464211725,null,5.25,7.5,79.25,6.6246056782334389E-2,9.4637223974763401E-2,6336.8125,6308.125,9.3318979960251079E-5,1.9802461005459155E-3,9.9105881008838752E-5,0.71002349830710032,5.4062121722946257,null,1.6332637680867355E-3,1.1019856935542879E-2,1.6728588275240538E-3,8.9751824187959777,0.24837535026770383,9.4216254440907712E-2,0.70552313597902339,9.8938033816926154,0.57722258609670241,null,6.651366888431792E-4,4.4877693957656476E-3,6.8126153483761263E-4,3.5000000000000003E-2,null,-2.7638863008682666,null,null,900,1200,900,824.25,375.75,15.75,15.75,0.30000000000000004,0.82351293103448275,0.36123693379790944,3000,0.63314999999999999,37.208758182671367,3.517970735466469E-3,{"$f":"IF(H18=0,0,IF(L18=3,BZ18+BZ19,ABS(BZ18-BZ19)))","v":0},{"$f":"IF(H18=0,0,IF(L18=3,CF18+CF19,ABS(CF18-CF19)))","v":0},{"$f":"IF(H18=0,0,IF(L18=3,CU18+CU19,ABS(CU18-CU19)))","v":0},4.1831074243096483E-3,{"$f":"CV18+CW18+(IF(CX18<0,0,CX18))","v":0}]
[null,30,30,10,null,2,"v",0,4,10,24,5,{"$f":"ABS(M18-H19)","v":5.25},null,2.5,29.25,29.25,null,7.5,50,5.4062121722946257,null,0.9,0.75,0.2,0.7,null,null,5.25,7.5,29.25,0.17948717948717949,0.25641025641025639,911.8125,883.125,1.7265827480469865E-3,1.3863166127828929E-2,1.8116365351201463E-3,0.7008464299173669,14.381394591090604,null,5.25,1.5,29.25,0.17948717948717949,5.128205128205128E-2,857.8125,883.125,7.3365955470612406E-5,2.8433091922860504E-3,1.3877770759609259E-4,0.71176042961690533,2.9356734464211725,null,5.25,7.5,79.25,6.6246056782334389E-2,9.4637223974763401E-2,6336.8125,6308.125,9.3318979960251079E-5,1.9802461005459155E-3,9.9105881008838752E-5,0.71002349830710032,5.4062121722946257,null,1.6332637680867355E-3,1.1019856935542879E-2,1.6728588275240538E-3,8.9751824187959777,0.24837535026770383,9.4216254440907712E-2,0.70552313597902339,9.8938033816926154,0.57722258609670241,null,6.651366888431792E-4,4.4877693957656476E-3,6.8126153483761263E-4,3.5000000000000003E-2,null,-2.7638863008682666,null,null,900,1200,900,824.25,375.75,15.75,15.75,0.30000000000000004,0.82351293103448275,0.36123693379790944,3000,0.63314999999999999,37.208758182671367,3.517970735466469E-3,null,null,null,4.1831074243096483E-3]
[null,30,30,10,null,3,"v",0,4,10,21,5,{"$f":"IF(OR(L20=2,L20=4),0,IF(L20=1,K20+H20-Q20,Q20-K20))","v":8.25},null,2.5,29.25,29.25,null,7.5,50,5.4062121722946257,null,0.9,0.75,0.2,0.7,null,null,8.25,7.5,29.25,0.28205128205128205,0.25641025641025639,911.8125,923.625,2.6361353163972074E-3,2.0931511963344862E-2,2.6571360051125077E-3,0.7008464299173669,14.381394591090604,null,8.25,1.5,29.25,0.28205128205128205,5.128205128205128E-2,857.8125,923.625,1.1192209528811569E-4,4.2913014679349624E-3,3.1649150332881603E-4,0.71176042961690533,2.9356734464211725,null,8.25,7.5,79.25,0.10410094637223975,9.4637223974763401E-2,6336.8125,6348.625,1.4602315299127821E-4,3.0936885066349807E-3,1.4676594453580179E-4,0.71002349830710032,5.4062121722946257,null,2.490112163405929E-3,1.66402104954099E-2,2.3406445017836917E-3,8.9751824187959777,0.24837535026770383,9.4216254440907712E-2,0.70552313597902339,9.8938033816926154,0.57722258609670241,null,1.0140829617228048E-3,6.7766240376077973E-3,9.5321316990895242E-4,5.5E-2,null,-2.7638863008682666,null,null,900,1200,900,815.25,384.75,24.75,24.75,0.30000000000000004,0.82118534482758621,0.36348797250859105,3000,0.63495000000000001,37.208758182671367,5.5783170877482906E-3,{"$f":"IF(H20=0,0,IF(L20=3,BZ20+BZ21,ABS(BZ20-BZ21)))","v":0},{"$f":"IF(H20=0,0,IF(L20=3,CF20+CF21,ABS(CF20-CF21)))","v":0},{"$f":"IF(H20=0,0,IF(L20=3,CU20+CU21,ABS(CU20-CU21)))","v":0},6.5924000494710956E-3,{"$f":"CV20+CW20+(IF(CX20<0,0,CX20))","v":0}]
[null,30,30,10,null,3,"v",0,4,10,21,5,{"$f":"ABS(M20-H21)","v":8.25},null,2.5,29.25,29.25,null,7.5,50,5.4062121722946257,null,0.9,0.75,0.2,0.7,null,null,8.25,7.5,29.25,0.28205128205128205,0.25641025641025639,911.8125,923.625,2.6361353163972074E-3,2.0931511963344862E-2,2.6571360051125077E-3,0.7008464299173669,14.381394591090604,null,8.25,1.5,29.25,0.28205128205128205,5.128205128205128E-2,857.8125,923.625,1.1192209528811569E-4,4.2913014679349624E-3,3.1649150332881603E-4,0.71176042961690533,2.9356734464211725,null,8.25,7.5,79.25,0.10410094637223975,9.4637223974763401E-2,6336.8125,6348.625,1.4602315299127821E-4,3.0936885066349807E-3,1.4676594453580179E-4,0.71002349830710032,5.4062121722946257,null,2.490112163405929E-3,1.66402104954099E-2,2.3406445017836917E-3,8.9751824187959777,0.24837535026770383,9.4216254440907712E-2,0.70552313597902339,9.8938033816926154,0.57722258609670241,null,1.0140829617228048E-3,6.7766240376077973E-3,9.5321316990895242E-4,5.5E-2,null,-2.7638863008682666,null,null,900,1200,900,815.25,384.75,24.75,24.75,0.30000000000000004,0.82118534482758621,0.36348797250859105,3000,0.63495000000000001,37.208758182671367,5.5783170877482906E-3,null,null,null,6.5924000494710956E-3]
[null,30,30,10,null,1,"c",{"$f":"IF(ClrYN=\"y\",IF(F22>nClr,0,wClr),0)","v":0},0,0,{"$f":"B22-F22*H22-F22*spandrelC","v":0},5,{"$f":"IF(H22=0,0,IF(OR(L22=2,L22=4),0,IF(L22=1,K22+H22-Q22,Q22-K22)))","v":0},null,2.5,29.25,29.25,null,7.5,50,5.4062121722946257,null,0.9,0.75,0.2,0.7,null,null,0,-2.5,29.25,0,-8.5470085470085472E-2,861.8125,855.5625,0,0,-4.9058179205734613E-5,0.70957285791484337,-4.8852025681173004,null,0,0,29.25,0,0,855.5625,855.5625,0,0,0,0.71260000000000001,0,null,0,7.5,79.25,0,9.4637223974763401E-2,6336.8125,6280.5625,0,0,6.64072669007917E-5,0.71002349830710032,5.4062121722946257,null,0,0,-1.1546544610652632E-4,-10.291414740411927,-8.5159600262455823E-2,9.4216254440907712E-2,0.71166107585624983,0.26050480208866311,0.43131040785784081,null,0,0,-3.5441752528087237E-5,0,null,-1.1066505629833312,null,null,900,1200,900,0,1200,0,0,0.30000000000000004,0.9,0.51428571428571423,3000,0.63,37.208758182671367,0,{"$f":"IF(H22=0,0,IF(L22=3,BZ22+BZ23,ABS(BZ22-BZ23)))","v":0},{"$f":"IF(H22=0,0,IF(L22=3,CF22+CF23,ABS(CF22-CF23)))","v":0},{"$f":"IF(H22=0,0,IF(L22=3,CU22+CU23,ABS(CU22-CU23)))","v":0},0,{"$f":"CV22+CW22+(IF(CX22<0,0,CX22))","v":0}]
[null,30,30,10,null,1,"c",0,0,0,0,5,{"$f":"ABS(M22-H23)","v":0},null,2.5,29.25,29.25,null,7.5,50,5.4062121722946257,null,0.9,0.75,0.2,0.7,null,null,0,-2.5,29.25,0,-8.5470085470085472E-2,861.8125,855.5625,0,0,-4.9058179205734613E-5,0.70957285791484337,-4.8852025681173004,null,0,0,29.25,0,0,855.5625,855.5625,0,0,0,0.71260000000000001,0,null,0,7.5,79.25,0,9.4637223974763401E-2,6336.8125,6280.5625,0,0,6.64072669007917E-5,0.71002349830710032,5.4062121722946257,null,0,0,-1.1546544610652632E-4,-10.291414740411927,-8.5159600262455823E-2,9.4216254440907712E-2,0.71166107585624983,0.26050480208866311,0.43131040785784081,null,0,0,-3.5441752528087237E-5,0,null,-1.1066505629833312,null,null,900,1200,900,0,1200,0,0,0.30000000000000004,0.9,0.51428571428571423,3000,0.63,37.208758182671367,0,null,null,null,0]
[null,30,30,10,null,2,"c",0,0,0,-30,5,{"$f":"IF(H24=0,0,IF(OR(L24=2,L24=4),0,IF(L24=1,K24+H24-Q24,Q24-K24)))","v":0},null,2.5,29.25,29.25,null,7.5,50,5.4062121722946257,null,0.9,0.75,0.2,0.7,null,null,0,-2.5,29.25,0,-8.5470085470085472E-2,861.8125,855.5625,0,0,-4.9058179205734613E-5,0.70957285791484337,-4.8852025681173004,null,0,0,29.25,0,0,855.5625,855.5625,0,0,0,0.71260000000000001,0,null,0,7.5,79.25,0,9.4637223974763401E-2,6336.8125,6280.5625,0,0,6.64072669007917E-5,0.71002349830710032,5.4062121722946257,null,0,0,-1.1546544610652632E-4,-10.291414740411927,-8.5159600262455823E-2,9.4216254440907712E-2,0.71166107585624983,0.26050480208866311,0.43131040785784081,null,0,0,-3.5441752528087237E-5,0,null,-1.1066505629833312,null,null,900,1200,900,0,1200,0,0,0.30000000000000004,0.9,0.51428571428571423,3000,0.63,37.208758182671367,0,{"$f":"IF(H24=0,0,IF(L24=3,BZ24+BZ25,ABS(BZ24-BZ25)))","v":0},{"$f":"IF(H24=0,0,IF(L24=3,CF24+CF25,ABS(CF24-CF25)))","v":0},{"$f":"IF(H24=0,0,IF(L24=3,CU24+CU25,ABS(CU24-CU25)))","v":0},0,{"$f":"CV24+CW24+(IF(CX24<0,0,CX24))","v":0}]
[null,30,30,10,null,2,"c",0,0,0,-30,5,{"$f":"ABS(M24-H25)","v":0},null,2.5,29.25,29.25,null,7.5,50,5.4062121722946257,null,0.9,0.75,0.2,0.7,null,null,0,-2.5,29.25,0,-8.5470085470085472E-2,861.8125,855.5625,0,0,-4.9058179205734613E-5,0.70957285791484337,-4.8852025681173004,null,0,0,29.25,0,0,855.5625,855.5625,0,0,0,0.71260000000000001,0,null,0,7.5,79.25,0,9.4637223974763401E-2,6336.8125,6280.5625,0,0,6.64072669007917E-5,0.71002349830710032,5.4062121722946257,null,0,0,-1.1546544610652632E-4,-10.291414740411927,-8.5159600262455823E-2,9.4216254440907712E-2,0.71166107585624983,0.26050480208866311,0.43131040785784081,null,0,0,-3.5441752528087237E-5,0,null,-1.1066505629833312,null,null,900,1200,900,0,1200,0,0,0.30000000000000004,0.9,0.51428571428571423,3000,0.63,37.208758182671367,0,null,null,null,0]
[null,30,30,10,null,3,"c",0,0,0,-60,5,{"$f":"IF(H26=0,0,IF(OR(L26=2,L26=4),0,IF(L26=1,K26+H26-Q26,Q26-K26)))","v":0},null,2.5,29.25,29.25,null,7.5,50,5.4062121722946257,null,0.9,0.75,0.2,0.7,null,null,0,-2.5,29.25,0,-8.5470085470085472E-2,861.8125,855.5625,0,0,-4.9058179205734613E-5,0.70957285791484337,-4.8852025681173004,null,0,0,29.25,0,0,855.5625,855.5625,0,0,0,0.71260000000000001,0,null,0,7.5,79.25,0,9.4637223974763401E-2,6336.8125,6280.5625,0,0,6.64072669007917E-5,0.71002349830710032,5.4062121722946257,null,0,0,-1.1546544610652632E-4,-10.291414740411927,-8.5159600262455823E-2,9.4216254440907712E-2,0.71166107585624983,0.26050480208866311,0.43131040785784081,null,0,0,-3.5441752528087237E-5,0,null,-1.1066505629833312,null,null,900,1200,900,0,1200,0,0,0.30000000000000004,0.9,0.51428571428571423,3000,0.63,37.208758182671367,0,{"$f":"IF(H26=0,0,IF(L26=3,BZ26+BZ27,ABS(BZ26-BZ27)))","v":0},{"$f":"IF(H26=0,0,IF(L26=3,CF26+CF27,ABS(CF26-CF27)))","v":0},{"$f":"IF(H26=0,0,IF(L26=3,CU26+CU27,ABS(CU26-CU27)))","v":0},0,{"$f":"CV26+CW26+(IF(CX26<0,0,CX26))","v":0}]
[null,30,30,10,null,3,"c",0,0,0,-60,5,{"$f":"ABS(M26-H27)","v":0},null,2.5,29.25,29.25,null,7.5,50,5.4062121722946257,null,0.9,0.75,0.2,0.7,null,null,0,-2.5,29.25,0,-8.5470085470085472E-2,861.8125,855.5625,0,0,-4.9058179205734613E-5,0.70957285791484337,-4.8852025681173004,null,0,0,{"$f":"AE27","v":29.25},0,0,855.5625,855.5625,0,0,0,0.71260000000000001,0,null,0,7.5,79.25,0,9.4637223974763401E-2,6336.8125,6280.5625,0,0,6.64072669007917E-5,0.71002349830710032,5.4062121722946257,null,0,0,-1.1546544610652632E-4,{"$f":"IF(AN27-MAX(BA27,BN27)=0,0.0001,AN27-MAX(BA27,BN27))","v":-10.291414740411927},-8.5159600262455823E-2,9.4216254440907712E-2,0.71166107585624983,0.26050480208866311,0.43131040785784081,null,0,0,-3.5441752528087237E-5,0,null,-1.1066505629833312,null,null,900,1200,900,0,1200,0,0,0.30000000000000004,0.9,0.51428571428571423,3000,0.63,37.208758182671367,0,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(CV16:CV28)","v":2.009246489623198E-3},{"$f":"SUM(CW16:CW28)","v":0},{"$f":"IF(SUM(CX16:CX28)+$CX$7*RefPtDepth<0,0,SUM(CX16:CX28)+$CX$7*RefPtDepth)","v":1.5736399679958286E-2},null,{"$f":"CV29+CW29+CX29","v":1.7745646169581485E-2},"sums"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1/(100/($T$4*100)*(1/CE31-1))*BZ31","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BZ31=0,0,Z31*(CM31+CN31)/(CR31*(1-CS31))*(CT31*CQ31+5*CP31)*1/100+$CX$7*P31)","v":0},null,null,{"$f":"IF(H31=0,0,IF(L31=3,CU31+CU32,ABS(CU31-CU32)))+$CX$7*P31","v":0},null,"saved fomulae"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"13*0.85","v":11.049999999999999}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Notes"]
[null,"Window Conditions (imagine yourself standing at on the grid point and looking at the window wall)"]
[null,null,1,"point is to left of window"]
[null,null,2,"point is at the left edge of the window"]
[null,null,3,"point is between window width"]
[null,null,4,"point is on window right edge"]
[null,null,5,"point is to right of window"]

{"sheet":"gridPoints","index":6,"n_rows":35,"n_cols":31,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,"RoomWidth",{"$f":"roomwidth","v":30}]
[null,null,null,"RoomDepth",{"$f":"roomdepth","v":30}]
[]
[null,null,null,null,null,"position",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,null,null,null,null,{"$f":"C35","v":6}]
[null,null,null,null,null,"X",{"$f":"ROUND(roomwidth/nXpos/2,2)","v":0.75},{"$f":"ROUND(G6+roomwidth/nXpos,2)","v":2.25},3.75,5.25,6.75,8.25,9.75,11.25,12.75,14.25,15.75,17.25,18.75,20.25,21.75,23.25,24.75,26.25,27.75,29.25]
[]
[null,null,null,"index",null,null,{"$f":"COLUMN()-COLUMN($B$8)+1","v":6},{"$f":"COLUMN()-COLUMN($B$8)+1","v":7},8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25]
[]
[null,"position","Y"]
[null,1,{"$f":"ROUND(roomdepth/nYpos/2,2)","v":0.75},{"$f":"ROW()-ROW($D$5)","v":6},null,null,2.8231075419472108E-2,4.3245791608173087E-2,6.8958439566058446E-2,8.3984490283535829E-2,8.9760107790030769E-2,9.220033373901361E-2,9.3345726826826569E-2,9.3915919620133695E-2,9.4198847513956935E-2,9.4317009598183899E-2,9.4317009598183899E-2,9.4198847513956935E-2,9.3915919620133695E-2,9.3345726826826569E-2,9.220033373901361E-2,8.9760107790030769E-2,8.3984490283535829E-2,6.8958439566058446E-2,4.3245791608173087E-2,2.8231075419472108E-2,null,null,null,null,{"$f":"HLOOKUP($AE$5,gridTbl,$B11+6,FALSE)","v":9.220033373901361E-2}]
[null,2,{"$f":"ROUND(C11+roomdepth/nYpos,2)","v":2.25},{"$f":"ROW()-ROW($D$5)","v":7},null,null,5.5247607894190948E-2,8.743329698485329E-2,0.12998902346037339,0.16216634831706522,0.17946734312661572,0.18820568514923675,0.19273803980128346,0.19514907121841807,0.19640320613393375,0.19694286296129179,0.19694286296129179,0.19640320613393375,0.19514907121841807,0.19273803980128346,0.18820568514923675,0.17946734312661572,0.16216634831706522,0.12998902346037339,8.743329698485329E-2,5.5247607894190948E-2,null,null,null,null,0.18820568514923675]
[null,3,3.75,8,null,null,5.9137916475917755E-2,8.2858294209940203E-2,0.11052025994072924,0.13421762798637743,0.15020952007760341,0.15983797933535882,0.16542563036583199,0.16861457120856144,0.17034664613408801,0.17110988573895314,0.17110988573895314,0.17034664613408801,0.16861457120856144,0.16542563036583199,0.15983797933535882,0.15020952007760341,0.13421762798637743,0.11052025994072924,8.2858294209940203E-2,5.9137916475917755E-2,null,null,null,null,0.15983797933535882]
[null,4,5.25,9,null,null,5.3708295042910074E-2,6.8964040358285822E-2,8.5765876494866083E-2,0.10098898439141177,0.11263730294588634,0.12060840656674027,0.12572607064084931,0.12886395565227324,0.13065043729545114,0.13145889968539448,0.13145889968539448,0.13065043729545114,0.12886395565227324,0.12572607064084931,0.12060840656674027,0.11263730294588634,0.10098898439141177,8.5765876494866083E-2,6.8964040358285822E-2,5.3708295042910074E-2,null,null,null,null,0.12060840656674027]
[null,5,6.75,10,null,null,4.6610431577729372E-2,5.629414642930157E-2,6.6638088054429667E-2,7.6283738889560207E-2,8.4218991350974853E-2,9.0139884508226298E-2,9.4253762257857629E-2,9.6938652372272865E-2,9.8535818597276267E-2,9.9277523988689387E-2,9.9277523988689387E-2,9.8535818597276267E-2,9.6938652372272865E-2,9.4253762257857629E-2,9.0139884508226298E-2,8.4218991350974853E-2,7.6283738889560207E-2,6.6638088054429667E-2,5.629414642930157E-2,4.6610431577729372E-2,null,null,null,null,9.0139884508226298E-2]
[null,6,8.25,11,null,null,4.0318162576762906E-2,4.6567236846627384E-2,5.3117576481129733E-2,5.9326434338069917E-2,6.4666373308840633E-2,6.8889263157506458E-2,7.1999493364718545E-2,7.4132987497103717E-2,7.5450016977378825E-2,7.6075590903028137E-2,7.6075590903028137E-2,7.5450016977378825E-2,7.4132987497103717E-2,7.1999493364718545E-2,6.8889263157506458E-2,6.4666373308840633E-2,5.9326434338069917E-2,5.3117576481129733E-2,4.6567236846627384E-2,4.0318162576762906E-2,null,null,null,null,6.8889263157506458E-2]
[null,7,9.75,12,null,null,3.5301821784323464E-2,3.9431567440346094E-2,4.3704255565654979E-2,4.7794076637253262E-2,5.1413116147678316E-2,5.4390118498466561E-2,5.6676675632516868E-2,5.8305600150449555E-2,5.9341062949095628E-2,5.984201201846838E-2,5.984201201846838E-2,5.9341062949095628E-2,5.8305600150449555E-2,5.6676675632516868E-2,5.4390118498466561E-2,5.1413116147678316E-2,4.7794076637253262E-2,4.3704255565654979E-2,3.9431567440346094E-2,3.5301821784323464E-2,null,null,null,null,5.4390118498466561E-2]
[null,8,11.25,13,null,null,3.1430444423938254E-2,3.422423283901866E-2,3.7086167471332962E-2,3.9842078752183638E-2,4.232696580211625E-2,4.4426857499338696E-2,4.6088573718464643E-2,4.7305841950922481E-2,4.8097049981208423E-2,4.8485320263846311E-2,4.8485320263846311E-2,4.8097049981208423E-2,4.7305841950922481E-2,4.6088573718464643E-2,4.4426857499338696E-2,4.232696580211625E-2,3.9842078752183638E-2,3.7086167471332962E-2,3.422423283901866E-2,3.1430444423938254E-2,null,null,null,null,4.4426857499338696E-2]
[null,9,12.75,14,null,null,2.8469527541194427E-2,3.0399890011320492E-2,3.2361223382771365E-2,3.4256893508343274E-2,3.5987893890471474E-2,3.7478151667739719E-2,3.8682598860835568E-2,3.9582916712964211E-2,4.0177832303909561E-2,4.0472913306247485E-2,4.0472913306247485E-2,4.0177832303909561E-2,3.9582916712964211E-2,3.8682598860835568E-2,3.7478151667739719E-2,3.5987893890471474E-2,3.4256893508343274E-2,3.2361223382771365E-2,3.0399890011320492E-2,2.8469527541194427E-2,null,null,null,null,3.7478151667739719E-2]
[null,10,14.25,15,null,null,2.6222643508714352E-2,2.7583991874376476E-2,2.8957221861476375E-2,3.0287587372469837E-2,3.1513052266252853E-2,3.2581856468819621E-2,3.3458680879100686E-2,3.4123693516192453E-2,3.4568428428431761E-2,3.4790760466130943E-2,3.4790760466130943E-2,3.4568428428431761E-2,3.4123693516192453E-2,3.3458680879100686E-2,3.2581856468819621E-2,3.1513052266252853E-2,3.0287587372469837E-2,2.8957221861476375E-2,2.7583991874376476E-2,2.6222643508714352E-2,null,null,null,null,3.2581856468819621E-2]
[null,11,15.75,16,null,null,2.4452342505576593E-2,2.5422007745451052E-2,2.6393554779741178E-2,2.7336397243179759E-2,2.8210450638713448E-2,2.8979877831791533E-2,2.9617887182728533E-2,3.0106862831207379E-2,3.0436728227129194E-2,3.0602582541452719E-2,3.0602582541452719E-2,3.0436728227129194E-2,3.0106862831207379E-2,2.9617887182728533E-2,2.8979877831791533E-2,2.8210450638713448E-2,2.7336397243179759E-2,2.6393554779741178E-2,2.5422007745451052E-2,2.4452342505576593E-2]
[null,12,17.25,17,null,null,2.3041487967207466E-2,2.3735410864768922E-2,2.4426078124787531E-2,2.5097497466259652E-2,2.5723158425927584E-2,2.6277811009879932E-2,2.6741383265453909E-2,2.7099409037828995E-2,2.7342481025926256E-2,2.7465211283165557E-2,2.7465211283165557E-2,2.7342481025926256E-2,2.7099409037828995E-2,2.6741383265453909E-2,2.6277811009879932E-2,2.5723158425927584E-2,2.5097497466259652E-2,2.4426078124787531E-2,2.3735410864768922E-2,2.3041487967207466E-2]
[null,13,18.75,18,null,null,2.1903392961592653E-2,2.2399256995433367E-2,2.2889406915327454E-2,2.3367033957741937E-2,2.3814331497965226E-2,2.4213219799507673E-2,2.4548710434045946E-2,2.4809360079981239E-2,2.4987184365881661E-2,2.5077256775998938E-2,2.5077256775998938E-2,2.4987184365881661E-2,2.4809360079981239E-2,2.4548710434045946E-2,2.4213219799507673E-2,2.3814331497965226E-2,2.3367033957741937E-2,2.2889406915327454E-2,2.2399256995433367E-2,2.1903392961592653E-2]
[null,14,20.25,19,null,null,2.0970821517813071E-2,2.1325211059986849E-2,2.1669583898537535E-2,2.2006463697351524E-2,2.2323804817169182E-2,2.2608473608428201E-2,2.2849263782526292E-2,2.3037291956183561E-2,2.3166090049161852E-2,2.3231499201330497E-2,2.3231499201330497E-2,2.3166090049161852E-2,2.3037291956183561E-2,2.2849263782526292E-2,2.2608473608428201E-2,2.2323804817169182E-2,2.2006463697351524E-2,2.1669583898537535E-2,2.1325211059986849E-2,2.0970821517813071E-2]
[null,15,21.75,20,null,null,2.017930373860205E-2,2.0431058796420921E-2,2.0675751392568713E-2,2.0916493594749772E-2,2.1141132415832122E-2,2.1341136569536293E-2,2.1511355755926088E-2,2.1644956099626397E-2,2.1736825266475523E-2,2.178359311948776E-2,2.178359311948776E-2,2.1736825266475523E-2,2.1644956099626397E-2,2.1511355755926088E-2,2.1341136569536293E-2,2.1141132415832122E-2,2.0916493594749772E-2,2.0675751392568713E-2,2.0431058796420921E-2,2.017930373860205E-2]
[null,16,23.25,21,null,null,1.9520999311945036E-2,1.9691173999738361E-2,1.985466025091407E-2,2.0017372925107812E-2,2.0173825601251881E-2,2.0316730571323688E-2,2.0439645300865741E-2,2.0535038991492859E-2,2.0598968582658514E-2,2.0631601153971293E-2,2.0631601153971293E-2,2.0598968582658514E-2,2.0535038991492859E-2,2.0439645300865741E-2,2.0316730571323688E-2,2.0173825601251881E-2,2.0017372925107812E-2,1.985466025091407E-2,1.9691173999738361E-2,1.9520999311945036E-2]
[null,17,24.75,22,null,null,1.8967363299561796E-2,1.9075250549226635E-2,1.917705421512789E-2,1.9280672782221377E-2,1.9382575673120551E-2,1.9477280626324037E-2,1.9559902058229967E-2,1.9626346339222608E-2,1.9673446411517147E-2,1.9698531937746021E-2,1.9698531937746021E-2,1.9673446411517147E-2,1.9626346339222608E-2,1.9559902058229967E-2,1.9477280626324037E-2,1.9382575673120551E-2,1.9280672782221377E-2,1.917705421512789E-2,1.9075250549226635E-2,1.8967363299561796E-2]
[null,18,26.25,23,null,null,1.8497112749981927E-2,1.8556656101791486E-2,1.8610889932030736E-2,1.8669004127080231E-2,1.8728746236116107E-2,1.8785830799165883E-2,1.8836427628549868E-2,1.8877315474997436E-2,1.8905995319469616E-2,1.8920765528934118E-2,1.8920765528934118E-2,1.8905995319469616E-2,1.8877315474997436E-2,1.8836427628549868E-2,1.8785830799165883E-2,1.8728746236116107E-2,1.8669004127080231E-2,1.8610889932030736E-2,1.8556656101791486E-2,1.8497112749981927E-2]
[null,19,27.75,24,null,null,1.8094772890067595E-2,1.8115636852476871E-2,1.8131898658161484E-2,1.8153836763459143E-2,1.8180271771083611E-2,1.8207924664231531E-2,1.8233856590148912E-2,1.8255585530752936E-2,1.8271176968737229E-2,1.8279308137643932E-2,1.8279308137643932E-2,1.8271176968737229E-2,1.8255585530752936E-2,1.8233856590148912E-2,1.8207924664231531E-2,1.8180271771083611E-2,1.8153836763459143E-2,1.8131898658161484E-2,1.8115636852476871E-2,1.8094772890067595E-2]
[null,20,29.25,25,null,null,1.7745646169581485E-2,1.7736124913272595E-2,1.7722693188208846E-2,1.771643870496465E-2,1.7716977480341119E-2,1.7721779701570888E-2,1.7728575619546924E-2,1.7735444030469567E-2,1.7740883459634496E-2,1.7743864651934262E-2,1.7743864651934262E-2,1.7740883459634496E-2,1.7735444030469567E-2,1.7728575619546924E-2,1.7721779701570888E-2,1.7716977480341119E-2,1.771643870496465E-2,1.7722693188208846E-2,1.7736124913272595E-2,1.7745646169581485E-2]
[]
[]
[]
[]
[null,"Y grid",6,{"$f":"\"Daylight Factor for points \"&HLOOKUP(C35,gridXtbl,2,FALSE)&\"' from the left side\"","v":"Daylight Factor for points 8.25' from the left side"}]

{"sheet":"output","index":7,"n_rows":47,"n_cols":33,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,"MaxUniformity"]
[null,null,null,null,{"$f":"Interface!$E$5","v":10},{"$f":"MIN(E10:N19)*E3","v":0.26222643508714349}]
[null,null,null,null,"MinDF"]
[null,null,null,null,{"$f":"Interface!$E$4","v":0.01}]
[]
[null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,null,null,null,{"$f":"HLOOKUP(E7,gridTbl,2,FALSE)&\"'\"","v":"0.75'"},"2.25'","3.75'","5.25'","6.75'","8.25'","9.75'","11.25'","12.75'","14.25'","15.75'","17.25'","18.75'","20.25'","21.75'","23.25'","24.75'","26.25'","27.75'","29.25'"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"W   I   N   D   O   W       W   A   L   L",null,null,null,null,null,null,null,null,null,null,null,"Color for Iso-contours",null,null,"colors","values"]
[null,null,1,{"$f":"VLOOKUP(C10,gridTbl,2,FALSE)&\"'\"","v":"0.75'"},{"$f":"VLOOKUP($C10,gridTbl,HLOOKUP(E$7,gridTbl,4,FALSE),FALSE)","v":2.8231075419472108E-2},4.3245791608173087E-2,6.8958439566058446E-2,8.3984490283535829E-2,8.9760107790030769E-2,9.220033373901361E-2,9.3345726826826569E-2,9.3915919620133695E-2,9.4198847513956935E-2,9.4317009598183899E-2,{"$f":"VLOOKUP($C10,gridTbl,HLOOKUP(O$7,gridTbl,4,FALSE),FALSE)","v":9.4317009598183899E-2},9.4198847513956935E-2,9.3915919620133695E-2,9.3345726826826569E-2,9.220033373901361E-2,8.9760107790030769E-2,8.3984490283535829E-2,6.8958439566058446E-2,4.3245791608173087E-2,2.8231075419472108E-2,null,null,">20","%",3,0.2,10,{"$f":"\"cv_\"&AE10","v":"cv_10"},{"$f":"AF10&\" = range(\"&AF10&\").value\"","v":"cv_10 = range(cv_10).value"}]
[null,null,2,"2.25'",5.5247607894190948E-2,8.743329698485329E-2,0.12998902346037339,0.16216634831706522,0.17946734312661572,0.18820568514923675,0.19273803980128346,0.19514907121841807,0.19640320613393375,0.19694286296129179,0.19694286296129179,0.19640320613393375,0.19514907121841807,0.19273803980128346,0.18820568514923675,0.17946734312661572,0.16216634831706522,0.12998902346037339,8.743329698485329E-2,5.5247607894190948E-2,null,null,"10-20","%",46,0.2,9,{"$f":"\"cv_\"&AE11","v":"cv_9"},"cv_9 = range(cv_9).value"]
[null,null,3,"3.75'",5.9137916475917755E-2,8.2858294209940203E-2,0.11052025994072924,0.13421762798637743,0.15020952007760341,0.15983797933535882,0.16542563036583199,0.16861457120856144,0.17034664613408801,0.17110988573895314,0.17110988573895314,0.17034664613408801,0.16861457120856144,0.16542563036583199,0.15983797933535882,0.15020952007760341,0.13421762798637743,0.11052025994072924,8.2858294209940203E-2,5.9137916475917755E-2,null,null,"7-10","%",45,0.1,8,"cv_8","cv_8 = range(cv_8).value"]
[null,null,4,"5.25'",5.3708295042910074E-2,6.8964040358285822E-2,8.5765876494866083E-2,0.10098898439141177,0.11263730294588634,0.12060840656674027,0.12572607064084931,0.12886395565227324,0.13065043729545114,0.13145889968539448,0.13145889968539448,0.13065043729545114,0.12886395565227324,0.12572607064084931,0.12060840656674027,0.11263730294588634,0.10098898439141177,8.5765876494866083E-2,6.8964040358285822E-2,5.3708295042910074E-2,null,null,"4-7","%",44,7.0000000000000007E-2,7,"cv_7","cv_7 = range(cv_7).value"]
[null,null,5,"6.75'",4.6610431577729372E-2,5.629414642930157E-2,6.6638088054429667E-2,7.6283738889560207E-2,8.4218991350974853E-2,9.0139884508226298E-2,9.4253762257857629E-2,9.6938652372272865E-2,9.8535818597276267E-2,9.9277523988689387E-2,9.9277523988689387E-2,9.8535818597276267E-2,9.6938652372272865E-2,9.4253762257857629E-2,9.0139884508226298E-2,8.4218991350974853E-2,7.6283738889560207E-2,6.6638088054429667E-2,5.629414642930157E-2,4.6610431577729372E-2,null,null,"2-4","%",43,0.04,6,"cv_6","cv_6 = range(cv_6).value"]
[null,null,6,"8.25'",4.0318162576762906E-2,4.6567236846627384E-2,5.3117576481129733E-2,5.9326434338069917E-2,6.4666373308840633E-2,6.8889263157506458E-2,7.1999493364718545E-2,7.4132987497103717E-2,7.5450016977378825E-2,7.6075590903028137E-2,7.6075590903028137E-2,7.5450016977378825E-2,7.4132987497103717E-2,7.1999493364718545E-2,6.8889263157506458E-2,6.4666373308840633E-2,5.9326434338069917E-2,5.3117576481129733E-2,4.6567236846627384E-2,4.0318162576762906E-2,null,null,"1-2","%",37,0.02,5,"cv_5","cv_5 = range(cv_5).value"]
[null,null,7,"9.75'",3.5301821784323464E-2,3.9431567440346094E-2,4.3704255565654979E-2,4.7794076637253262E-2,5.1413116147678316E-2,5.4390118498466561E-2,5.6676675632516868E-2,5.8305600150449555E-2,5.9341062949095628E-2,5.984201201846838E-2,5.984201201846838E-2,5.9341062949095628E-2,5.8305600150449555E-2,5.6676675632516868E-2,5.4390118498466561E-2,5.1413116147678316E-2,4.7794076637253262E-2,4.3704255565654979E-2,3.9431567440346094E-2,3.5301821784323464E-2,null,null,".5-1","%",42,0.01,4,"cv_4","cv_4 = range(cv_4).value"]
[null,null,8,"11.25'",3.1430444423938254E-2,3.422423283901866E-2,3.7086167471332962E-2,3.9842078752183638E-2,4.232696580211625E-2,4.4426857499338696E-2,4.6088573718464643E-2,4.7305841950922481E-2,4.8097049981208423E-2,4.8485320263846311E-2,4.8485320263846311E-2,4.8097049981208423E-2,4.7305841950922481E-2,4.6088573718464643E-2,4.4426857499338696E-2,4.232696580211625E-2,3.9842078752183638E-2,3.7086167471332962E-2,3.422423283901866E-2,3.1430444423938254E-2,null,null,".2-5","%",23,5.0000000000000001E-3,3,"cv_3","cv_3 = range(cv_3).value"]
[null,null,9,"12.75'",2.8469527541194427E-2,3.0399890011320492E-2,3.2361223382771365E-2,3.4256893508343274E-2,3.5987893890471474E-2,3.7478151667739719E-2,3.8682598860835568E-2,3.9582916712964211E-2,4.0177832303909561E-2,4.0472913306247485E-2,4.0472913306247485E-2,4.0177832303909561E-2,3.9582916712964211E-2,3.8682598860835568E-2,3.7478151667739719E-2,3.5987893890471474E-2,3.4256893508343274E-2,3.2361223382771365E-2,3.0399890011320492E-2,2.8469527541194427E-2,null,null,".1-.2","%",5,2E-3,2,"cv_2","cv_2 = range(cv_2).value"]
[null,null,10,"14.25'",2.6222643508714352E-2,2.7583991874376476E-2,2.8957221861476375E-2,3.0287587372469837E-2,3.1513052266252853E-2,3.2581856468819621E-2,3.3458680879100686E-2,3.4123693516192453E-2,3.4568428428431761E-2,3.4790760466130943E-2,3.4790760466130943E-2,3.4568428428431761E-2,3.4123693516192453E-2,3.3458680879100686E-2,3.2581856468819621E-2,3.1513052266252853E-2,3.0287587372469837E-2,2.8957221861476375E-2,2.7583991874376476E-2,2.6222643508714352E-2,null,null,"<.1","%",1,1E-3,1,"cv_1",{"$f":"AF19&\" = range(\"&AF19&\").value\"","v":"cv_1 = range(cv_1).value"}]
[null,null,11,"15.75'",{"$f":"VLOOKUP($C20,gridTbl,HLOOKUP(E$7,gridTbl,4,FALSE),FALSE)","v":2.4452342505576593E-2},2.5422007745451052E-2,2.6393554779741178E-2,2.7336397243179759E-2,2.8210450638713448E-2,2.8979877831791533E-2,2.9617887182728533E-2,3.0106862831207379E-2,3.0436728227129194E-2,3.0602582541452719E-2,{"$f":"VLOOKUP($C20,gridTbl,HLOOKUP(O$7,gridTbl,4,FALSE),FALSE)","v":3.0602582541452719E-2},3.0436728227129194E-2,3.0106862831207379E-2,2.9617887182728533E-2,2.8979877831791533E-2,2.8210450638713448E-2,2.7336397243179759E-2,2.6393554779741178E-2,2.5422007745451052E-2,2.4452342505576593E-2]
[null,null,12,"17.25'",2.3041487967207466E-2,2.3735410864768922E-2,2.4426078124787531E-2,2.5097497466259652E-2,2.5723158425927584E-2,2.6277811009879932E-2,2.6741383265453909E-2,2.7099409037828995E-2,2.7342481025926256E-2,2.7465211283165557E-2,2.7465211283165557E-2,2.7342481025926256E-2,2.7099409037828995E-2,2.6741383265453909E-2,2.6277811009879932E-2,2.5723158425927584E-2,2.5097497466259652E-2,2.4426078124787531E-2,2.3735410864768922E-2,2.3041487967207466E-2]
[null,null,13,"18.75'",2.1903392961592653E-2,2.2399256995433367E-2,2.2889406915327454E-2,2.3367033957741937E-2,2.3814331497965226E-2,2.4213219799507673E-2,2.4548710434045946E-2,2.4809360079981239E-2,2.4987184365881661E-2,2.5077256775998938E-2,2.5077256775998938E-2,2.4987184365881661E-2,2.4809360079981239E-2,2.4548710434045946E-2,2.4213219799507673E-2,2.3814331497965226E-2,2.3367033957741937E-2,2.2889406915327454E-2,2.2399256995433367E-2,2.1903392961592653E-2]
[null,null,14,"20.25'",2.0970821517813071E-2,2.1325211059986849E-2,2.1669583898537535E-2,2.2006463697351524E-2,2.2323804817169182E-2,2.2608473608428201E-2,2.2849263782526292E-2,2.3037291956183561E-2,2.3166090049161852E-2,2.3231499201330497E-2,2.3231499201330497E-2,2.3166090049161852E-2,2.3037291956183561E-2,2.2849263782526292E-2,2.2608473608428201E-2,2.2323804817169182E-2,2.2006463697351524E-2,2.1669583898537535E-2,2.1325211059986849E-2,2.0970821517813071E-2]
[null,null,15,"21.75'",2.017930373860205E-2,2.0431058796420921E-2,2.0675751392568713E-2,2.0916493594749772E-2,2.1141132415832122E-2,2.1341136569536293E-2,2.1511355755926088E-2,2.1644956099626397E-2,2.1736825266475523E-2,2.178359311948776E-2,2.178359311948776E-2,2.1736825266475523E-2,2.1644956099626397E-2,2.1511355755926088E-2,2.1341136569536293E-2,2.1141132415832122E-2,2.0916493594749772E-2,2.0675751392568713E-2,2.0431058796420921E-2,2.017930373860205E-2]
[null,null,16,"23.25'",1.9520999311945036E-2,1.9691173999738361E-2,1.985466025091407E-2,2.0017372925107812E-2,2.0173825601251881E-2,2.0316730571323688E-2,2.0439645300865741E-2,2.0535038991492859E-2,2.0598968582658514E-2,2.0631601153971293E-2,2.0631601153971293E-2,2.0598968582658514E-2,2.0535038991492859E-2,2.0439645300865741E-2,2.0316730571323688E-2,2.0173825601251881E-2,2.0017372925107812E-2,1.985466025091407E-2,1.9691173999738361E-2,1.9520999311945036E-2]
[null,null,17,"24.75'",1.8967363299561796E-2,1.9075250549226635E-2,1.917705421512789E-2,1.9280672782221377E-2,1.9382575673120551E-2,1.9477280626324037E-2,1.9559902058229967E-2,1.9626346339222608E-2,1.9673446411517147E-2,1.9698531937746021E-2,1.9698531937746021E-2,1.9673446411517147E-2,1.9626346339222608E-2,1.9559902058229967E-2,1.9477280626324037E-2,1.9382575673120551E-2,1.9280672782221377E-2,1.917705421512789E-2,1.9075250549226635E-2,1.8967363299561796E-2]
[null,null,18,"26.25'",1.8497112749981927E-2,1.8556656101791486E-2,1.8610889932030736E-2,1.8669004127080231E-2,1.8728746236116107E-2,1.8785830799165883E-2,1.8836427628549868E-2,1.8877315474997436E-2,1.8905995319469616E-2,1.8920765528934118E-2,1.8920765528934118E-2,1.8905995319469616E-2,1.8877315474997436E-2,1.8836427628549868E-2,1.8785830799165883E-2,1.8728746236116107E-2,1.8669004127080231E-2,1.8610889932030736E-2,1.8556656101791486E-2,1.8497112749981927E-2]
[null,null,19,"27.75'",1.8094772890067595E-2,1.8115636852476871E-2,1.8131898658161484E-2,1.8153836763459143E-2,1.8180271771083611E-2,1.8207924664231531E-2,1.8233856590148912E-2,1.8255585530752936E-2,1.8271176968737229E-2,1.8279308137643932E-2,1.8279308137643932E-2,1.8271176968737229E-2,1.8255585530752936E-2,1.8233856590148912E-2,1.8207924664231531E-2,1.8180271771083611E-2,1.8153836763459143E-2,1.8131898658161484E-2,1.8115636852476871E-2,1.8094772890067595E-2]
[null,null,20,"29.25'",1.7745646169581485E-2,1.7736124913272595E-2,1.7722693188208846E-2,1.771643870496465E-2,1.7716977480341119E-2,1.7721779701570888E-2,1.7728575619546924E-2,1.7735444030469567E-2,1.7740883459634496E-2,1.7743864651934262E-2,1.7743864651934262E-2,1.7740883459634496E-2,1.7735444030469567E-2,1.7728575619546924E-2,1.7721779701570888E-2,1.7716977480341119E-2,1.771643870496465E-2,1.7722693188208846E-2,1.7736124913272595E-2,1.7745646169581485E-2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3.4000000000000002E-2]
[]
[]
[null,null,null,null,"average overcast Iluminance for a day "]
[null,null,null,null,null,"Lux"]
[null,null,null,null,"Jan",6467.7777777777774]
[null,null,null,null,"Feb",7719.090909090909]
[null,null,null,null,"Mar",10948.181818181818]
[null,null,null,null,"Apr",12676.153846153846]
[null,null,null,null,"May",13262]
[null,null,null,null,"Jun",14234]
[null,null,null,null,"Jul",13376]
[null,null,null,null,"Aug",12768.461538461539]
[null,null,null,null,"Sep",9396.1538461538457]
[null,null,null,null,"Oct",7606.363636363636]
[null,null,null,null,"Nov",6408.8888888888887]
[null,null,null,null,"Dec",5417.7777777777774]