{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Title Page","Solar Resource","Lights","Battery Bank","Array Sizing"," Design Spec","Conclusion"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":2,"comments":5,"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":"Title Page","index":0,"n_rows":50,"n_cols":12,"rows_kept":50,"cut":false,"hidden":false,"merged":[[25,5,25,10],[11,2,11,11],[13,2,13,10],[14,2,14,10],[12,2,12,10],[24,5,24,13]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Solar-Powered Lighting System Worksheet"]
[null,null,"Authors: Professor Thomas Jenkins, ETSE"]
[null,null,"Gabriel Bolivar-Mendoza ",null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2014-08-26"}]
[null,null,"Copyright © NMSU 2013"]
[null,null,"Acknowledgements: "]
[null,null,"The authors wish to express extreme gratitude for the assistance of the following:"]
[null,null,"College of Engineering (COE) and Engineering NM:                                       http://engr.nmsu.edu/index.shtml"]
[null,null,"NMSU Cooperative Extension Service:                                                            http://extension.nmsu.edu/"]
[null,null,"New Mexico Space Grant Consortium (NMSGC):                                            http://www.nmspacegrant.com/"]
[null,null,"Department of Engineering Technology and Surveying Engineering (ETSE):  http://et.nmsu.edu/"]
[]
[null,null,"Disclaimer: This document is only intended to provide an education tool and should not be used beyond this purpose. "]
[null,null,"The authors tried to use good engineering analysis, but all situations are different and the user should consult a professional in all cases."]
[null,null,"See solar lighting video at:",null,null,"http://www.youtube.com/watch?v=AzAiqkLL9z4&list=PL89870B418A514D27&index=20 "]
[null,null,"See related energy videos at:",null,null,"http://www.youtube.com/playlist?list=PL89870B418A514D27  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["http://www.youtube.com/watch?v=AzAiqkLL9z4&list=PL89870B418A514D27&index=20 "]
["http://www.youtube.com/playlist?list=PL89870B418A514D27  "]

{"sheet":"Solar Resource","index":1,"n_rows":163,"n_cols":37,"rows_kept":163,"cut":false,"hidden":false,"merged":[[61,9,65,9],[45,0,48,0],[45,9,48,9],[30,0,33,0],[24,9,29,9],[40,0,44,0],[34,0,36,0],[34,9,36,9],[34,1,36,8],[24,0,29,0],[30,1,33,8],[24,1,29,8],[30,9,33,9],[116,11,118,13],[149,11,151,13],[38,1,39,8],[70,1,71,8],[102,1,103,8],[134,1,135,8],[115,1,120,8],[136,1,136,8],[104,1,104,8],[94,9,100,9],[72,1,73,8],[74,1,80,8],[81,1,87,8],[94,1,100,8],[83,11,85,13],[50,11,52,13],[40,9,44,9],[66,9,68,9],[40,1,44,8],[45,1,48,8],[49,1,54,8],[55,1,60,8],[61,1,65,8],[66,1,68,8],[110,0,114,0],[110,9,114,9],[115,0,120,0],[115,9,120,9],[110,1,114,8],[105,0,109,0],[105,9,109,9],[105,1,109,8],[49,0,54,0],[94,0,100,0],[88,1,93,8],[81,0,87,0],[81,9,87,9],[88,0,93,0],[88,9,93,9],[72,0,73,0],[72,9,73,9],[74,0,80,0],[74,9,80,9],[49,9,54,9],[66,0,68,0],[55,0,60,0],[55,9,60,9],[61,0,65,0],[144,0,147,0],[144,9,147,9],[140,1,143,8],[144,1,147,8],[137,0,139,0],[137,9,139,9],[137,1,139,8],[121,0,126,0],[121,9,126,9],[127,0,132,0],[127,9,132,9],[121,1,126,8],[127,1,132,8],[140,0,143,0],[140,9,143,9],[162,0,164,0],[162,9,164,9],[157,1,161,8],[162,1,164,8],[148,0,151,0],[148,9,151,9],[152,0,156,0],[152,9,156,9],[148,1,151,8],[152,1,156,8],[157,0,161,0],[157,9,161,9],[0,0,0,14],[1,0,1,7],[4,8,4,9],[19,9,23,9],[19,0,23,0],[12,9,18,9],[12,0,18,0],[8,9,11,9],[8,0,11,0],[17,11,19,13],[6,1,7,8],[19,1,23,8],[12,1,18,8],[8,1,11,8],[1,12,1,14],[2,12,2,14],[3,12,5,14],[2,0,3,7],[4,0,5,7],[2,8,2,9]]}
["Solar Resource: The average amount of sunlight in your area",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,"Invalid Latitude!!",null,null,null,null,null,"Latitude","Y/N","Order"]
["Step 1: Select your state (NM, AZ, CO, UT, NV) using the drop-down menu.",null,null,null,null,null,null,null,null,null,null,null,"Select your",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,{"$f":"IF(OR($M$4=\"New Mexico\",$M$4=\"Arizona\"),1.012,0.012)","v":1.012},{"$f":"INDEX($AI$2:$AI$13,MATCH(LARGE($AJ$2:$AJ$13,1),$AJ$2:$AJ$13,0))","v":31}]
["Next: Enter the \"Latitude\" of the location where you plan to install your solar lighting system using the state's reference map below and the drop-down menu. ",null,null,null,null,null,null,null,"Enter your Latitude",null,35,null,"State:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Mexico","Winter","Latitude",{"$f":"IF(#REF!=\"Summer\",4,3)","v":{"$error":"#REF!"}},null,null,32,{"$f":"IF(OR($M$4=\"New Mexico\",$M$4=\"Arizona\"),1.011,0.011)","v":1.0109999999999999},{"$f":"INDEX($AI$2:$AI$13,MATCH(LARGE($AJ$2:$AJ$13,2),$AJ$2:$AJ$13,0))","v":32}]
[null,null,null,null,null,null,null,null,null,null,null,null,"New Mexico",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Arizona","Summer","1-Axis Tracker",{"$f":"IF(#REF!=\"Summer\",6,5)","v":{"$error":"#REF!"}},null,null,33,{"$f":"IF(OR($M$4=\"New Mexico\",$M$4=\"Arizona\"),1.01,0.01)","v":1.01},{"$f":"INDEX($AI$2:$AI$13,MATCH(LARGE($AJ$2:$AJ$13,3),$AJ$2:$AJ$13,0))","v":33}]
["Step 2: Once Total Daily Insolation is calculated, move on to the next sheet titled Lights.",null,null,null,null,null,null,null,"Total Daily Insolation",null,{"$f":"IFERROR(IF(M4=\"New Mexico\",INDEX(AD26:AI31,MATCH(K3,AC26:AC31,0),AF8),IF(M4=\"Arizona\",INDEX(AD62:AI68,MATCH(K3,AC62:AC68,0),AF8),IF(M4=\"Colorado\",INDEX(AD91:AI95,MATCH(K3,AC91:AC95,0),AF8),IF(M4=\"Utah\",INDEX(AD126:AI131,MATCH(K3,AC126:AC131,0),AF8),IF(M4=\"Nevada\",INDEX(AD155:AI162,MATCH(K3,AC155:AC162,0),AF8)))))),0)","v":5},"kWh/day",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Colorado","All Year","+/- 15°",{"$f":"IF(#REF!=\"Summer\",2,1)","v":{"$error":"#REF!"}},null,null,34,{"$f":"IF(OR($M$4=\"New Mexico\",$M$4=\"Arizona\"),1.009,0.009)","v":1.0089999999999999},{"$f":"INDEX($AI$2:$AI$13,MATCH(LARGE($AJ$2:$AJ$13,4),$AJ$2:$AJ$13,0))","v":34}]
[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,"Utah",null,null,null,null,null,35,{"$f":"IF(OR($M$4=\"New Mexico\",$M$4=\"Arizona\",$M$4=\"Nevada\"),1.008,0.008)","v":1.008},{"$f":"INDEX($AI$2:$AI$13,MATCH(LARGE($AJ$2:$AJ$13,5),$AJ$2:$AJ$13,0))","v":35}]
[null,"NEW MEXICO",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,"Nevada",null,null,null,null,null,36,{"$f":"IF(OR($M$4=\"New Mexico\",$M$4=\"Arizona\",$M$4=\"Nevada\"),1.007,0.007)","v":1.0069999999999999},{"$f":"INDEX($AI$2:$AI$13,MATCH(LARGE($AJ$2:$AJ$13,6),$AJ$2:$AJ$13,0))","v":36}]
[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":"IF(#REF!=\"Summer\",1,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Latitude\",3,IF(#REF!=\"1-Axis Tracker\",5,3))","v":{"$error":"#REF!"}},3,null,null,37,{"$f":"IF(OR($M$4=\"Utah\",$M$4=\"Colorado\",$M$4=\"Nevada\"),1.006,0.006)","v":6.0000000000000001E-3},{"$f":"INDEX($AI$2:$AI$13,MATCH(LARGE($AJ$2:$AJ$13,7),$AJ$2:$AJ$13,0))","v":37}]
[36,36,null,null,null,null,null,null,null,36,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,{"$f":"IF(OR($M$4=\"Utah\",$M$4=\"Colorado\",$M$4=\"Nevada\"),1.005,0.005)","v":5.0000000000000001E-3},{"$f":"INDEX($AI$2:$AI$13,MATCH(LARGE($AJ$2:$AJ$13,8),$AJ$2:$AJ$13,0))","v":38}]
[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,39,{"$f":"IF(OR($M$4=\"Utah\",$M$4=\"Colorado\",$M$4=\"Nevada\"),1.004,0.004)","v":4.0000000000000001E-3},{"$f":"INDEX($AI$2:$AI$13,MATCH(LARGE($AJ$2:$AJ$13,9),$AJ$2:$AJ$13,0))","v":39}]
[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,40,{"$f":"IF(OR($M$4=\"Utah\",$M$4=\"Colorado\",$M$4=\"Nevada\"),1.003,0.003)","v":3.0000000000000001E-3},{"$f":"INDEX($AI$2:$AI$13,MATCH(LARGE($AJ$2:$AJ$13,10),$AJ$2:$AJ$13,0))","v":40}]
[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,"winter",{"$f":"IF(#REF!=\"Latitude\",3,IF(#REF!=\"1-Axis Tracker\",5,1))","v":{"$error":"#REF!"}},{"$f":"IFERROR(IF(M4=\"New Mexico\",INDEX(AD26:AI31,MATCH(K3,AC26:AC31,0),AE12),IF(M4=\"Arizona\",INDEX(AD62:AI68,MATCH(K3,AC62:AC68,0),AE12),IF(M4=\"Colorado\",INDEX(AD91:AI95,MATCH(K3,AC91:AC95,0),AE12),IF(M4=\"Utah\",INDEX(AD126:AI131,MATCH(K3,AC126:AC131,0),AE12),IF(M4=\"Nevada\",INDEX(AD155:AI162,MATCH(K3,AC155:AC162,0),AE12)))))),0)","v":0},null,null,41,{"$f":"IF(OR($M$4=\"Utah\",$M$4=\"Colorado\",$M$4=\"Nevada\"),1.002,0.002)","v":2E-3},{"$f":"INDEX($AI$2:$AI$13,MATCH(LARGE($AJ$2:$AJ$13,11),$AJ$2:$AJ$13,0))","v":41}]
[35,35,null,null,null,null,null,null,null,35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"summer",{"$f":"IF(#REF!=\"Latitude\",4,IF(#REF!=\"1-Axis Tracker\",6,2))","v":{"$error":"#REF!"}},{"$f":"IFERROR(IF(M4=\"New Mexico\",INDEX(AD26:AI31,MATCH(K3,AC26:AC31,0),AE13),IF(M4=\"Arizona\",INDEX(AD62:AI68,MATCH(K3,AC62:AC68,0),AE13),IF(M4=\"Colorado\",INDEX(AD91:AI95,MATCH(K3,AC91:AC95,0),AE13),IF(M4=\"Utah\",INDEX(AD126:AI131,MATCH(K3,AC126:AC131,0),AE13),IF(M4=\"Nevada\",INDEX(AD155:AI162,MATCH(K3,AC155:AC162,0),AE13)))))),0)","v":0},null,null,42,{"$f":"IF(OR($M$4=\"Utah\",$M$4=\"Nevada\"),1.001,0.001)","v":1E-3},{"$f":"INDEX($AI$2:$AI$13,MATCH(LARGE($AJ$2:$AJ$13,12),$AJ$2:$AJ$13,0))","v":42}]
[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,"Useless",{"$f":"COUNTIF(AJ2:AJ13,\"<1\")","v":6}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(INDEX(AJ2:AJ13,MATCH(K3,AI2:AI13,0))<1,AC1,\"\")","v":""}]
[]
[34,34,null,null,null,null,null,null,null,34]
[]
[]
[]
[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,"Adjusting tilt +/- 15",null,"Fixed at latitude",null,"1-Axis tracker"]
[33,33,null,null,null,null,null,null,null,33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Latitude","Winter","Summer","Winter","Summer","Winter","Summer"]
[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,31,5.6,6.4,5.0999999999999996,6.6,6.3,8.6999999999999993]
[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,32,5.58,6.45,5.08,6.65,6.25,8.7799999999999994]
[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,33,5.55,6.5,5.05,6.7,6.2,8.85]
[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,34,5.53,6.55,5.03,6.75,6.15,8.93]
[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,35,5.5,6.6,5,6.8,6.1,9]
[32,32,null,null,null,null,null,null,null,32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,5.6,6.55,5.0999999999999996,6.75,6.2,9.0500000000000007]
[]
[]
[]
[31,31,null,null,null,null,null,null,null,31]
[]
[]
[]
[null,"ARIZONA"]
[]
[36,36,null,null,null,null,null,null,null,36]
[]
[]
[]
[]
[35,35,null,null,null,null,null,null,null,35]
[]
[]
[]
[34,34,null,null,null,null,null,null,null,34]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(INDEX(AJ2:AJ13,MATCH(K3,AI2:AI13,0))<1,AC1,\"\")","v":""}]
[]
[]
[]
[]
[33,33,null,null,null,null,null,null,null,33]
[]
[]
[]
[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,"Adjusting tilt +/- 15",null,"Fixed at latitude",null,"1-Axis tracker"]
[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,"Latitude","Winter","Summer","Winter","Summer","Winter","Summer"]
[32,32,null,null,null,null,null,null,null,32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,5.9,6.4,5.3,6.6,6.6,8.9]
[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,32,5.6,6.6,5.0999999999999996,6.8,6.2,9.1]
[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,33,5.3,6.8,4.9000000000000004,7,5.8,9.3000000000000007]
[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,34,5.33,6.9,4.9000000000000004,7.07,5.83,9.4700000000000006]
[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,35,5.37,7,4.9000000000000004,7.13,5.87,9.6300000000000008]
[31,31,null,null,null,null,null,null,null,31,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,5.4,7.1,4.9000000000000004,7.2,5.9,9.8000000000000007]
[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,37,5.13,6.92,4.67,7.02,5.6,9.57]
[]
[]
[null,"COLORADO"]
[]
[41,41,null,null,null,null,null,null,null,41]
[]
[40,40,null,null,null,null,null,null,null,40]
[]
[]
[]
[]
[]
[]
[39,39,null,null,null,null,null,null,null,39]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(INDEX(AJ2:AJ13,MATCH(K3,AI2:AI13,0))<1,AC1,\"\")","v":""}]
[]
[]
[]
[]
[38,38,null,null,null,null,null,null,null,38,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adjusting tilt +/- 15",null,"Fixed at latitude",null,"1-Axis tracker"]
[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,"Latitude","Winter","Summer","Winter","Summer","Winter","Summer"]
[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,37,5.7,6.5,5.2,6.7,6.3,9.1]
[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,38,5.3,6.3,4.87,6.47,5.83,8.6999999999999993]
[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,39,4.9000000000000004,6.1,4.53,6.23,5.37,8.3000000000000007]
[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,40,4.5,5.9,4.2,6,4.9000000000000004,7.9]
[37,37,null,null,null,null,null,null,null,37,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,4.43,5.97,4.13,6.07,4.8,8.0299999999999994]
[]
[]
[]
[]
[]
[]
[]
[null,"UTAH"]
[]
[42,42,null,null,null,null,null,null,null,42]
[41,41,null,null,null,null,null,null,null,41]
[]
[]
[]
[]
[40,40,null,null,null,null,null,null,null,40]
[]
[]
[]
[]
[39,39,null,null,null,null,null,null,null,39]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(INDEX(AJ2:AJ13,MATCH(K3,AI2:AI13,0))<1,AC1,\"\")","v":""}]
[]
[]
[]
[]
[38,38,null,null,null,null,null,null,null,38]
[]
[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,"Adjusting tilt +/- 15",null,"Fixed at latitude",null,"1-Axis tracker"]
[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,"Latitude","Winter","Summer","Winter","Summer","Winter","Summer"]
[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,37,5.13,6.92,4.67,7.02,5.6,9.57]
[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,38,4.87,6.73,4.43,6.83,5.3,9.33]
[37,37,null,null,null,null,null,null,null,37,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,4.5999999999999996,6.55,4.2,6.65,5,9.1]
[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,40,4.34,6.46,3.98,6.58,4.6900000000000004,8.9600000000000009]
[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,41,4.08,6.38,3.75,6.5,4.38,8.83]
[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,42,3.81,6.29,3.53,6.43,4.0599999999999996,8.69]
[]
[]
[]
[null,"NEVADA"]
[]
[42,42,null,null,null,null,null,null,null,42]
[41,41,null,null,null,null,null,null,null,41]
[]
[]
[40,40,null,null,null,null,null,null,null,40]
[]
[]
[]
[39,39,null,null,null,null,null,null,null,39]
[]
[]
[]
[38,38,null,null,null,null,null,null,null,38]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(INDEX(AJ2:AJ13,MATCH(K3,AI2:AI13,0))<1,AC1,\"\")","v":""}]
[]
[]
[37,37,null,null,null,null,null,null,null,37,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adjusting tilt +/- 15",null,"Fixed at latitude",null,"1-Axis tracker"]
[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,"Latitude","Winter","Summer","Winter","Summer","Winter","Summer"]
[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,35,5.63,7.27,5.0999999999999996,7.37,6.17,10]
[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,36,5.4,7.1,4.9000000000000004,7.2,5.9,9.8000000000000007]
[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,37,5.17,6.93,4.7,7.03,5.63,9.6]
[36,36,null,null,null,null,null,null,null,36,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,4.93,6.77,4.5,6.87,5.37,9.4]
[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,39,4.7,6.6,4.3,6.7,5.0999999999999996,9.1999999999999993]
[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,40,4.24,6.53,3.89,6.64,4.58,9.09]
[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,41,3.78,6.45,3.48,6.58,4.05,8.98]
[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,42,3.31,6.38,3.06,6.51,3.53,8.86]
[35,35,null,null,null,null,null,null,null,35]

{"sheet":"Lights","index":2,"n_rows":23,"n_cols":18,"rows_kept":23,"cut":false,"hidden":false,"merged":[[14,8,15,13],[11,8,11,10],[0,0,0,13],[13,8,13,11],[8,0,10,7],[13,0,14,7],[1,8,1,13],[11,0,12,7],[1,0,7,7],[15,0,15,7]]}
["Daily Energy Requirement of Lights"]
["Step 3: In the green cells to the right under the heading Quantity, enter the number of lights that you need to power. Next, enter the type of light (incandescent, LED, etc.) using the drop-down menu of those cells.  If you have any other type of light, you can enter the power required and the number of lights in the \"Other Lights\" cells. Finally, enter the number of hours per day you will be using each type of light in order to obtain the Daily Energy Requirement.",null,null,null,null,null,null,null,"Power Requirements",null,null,null,null,null,null,null,null,"Incandescent"]
[null,null,null,null,null,null,null,null,"Lights","Quantity","Type of Light","Total Power (W)","Hours/Day","Total (watt-hr/day)",null,null,null,"Halogen"]
[null,null,null,null,null,null,null,null,"40 Watt Light",1,"Halogen",{"$f":"IF(K4=\"Incandescent\",D18,IF(K4=\"Halogen\",E18,IF(K4=\"Fluorescent\",F18,IF(K4=\"LED\",G18,0))))","v":28},2,{"$f":"M4*L4*J4","v":56},null,null,null,"Fluorescent"]
[null,null,null,null,null,null,null,null,"50 Watt Light",1,"Fluorescent",{"$f":"IF(K5=\"Incandescent\",D19,IF(K5=\"Halogen\",E19,IF(K5=\"Fluorescent\",F19,IF(K5=\"LED\",G19,0))))","v":15},4,{"$f":"M5*L5*J5","v":60},null,null,null,"LED"]
[null,null,null,null,null,null,null,null,"60 Watt Light",0,"Incandescent",{"$f":"IF(K6=\"Incandescent\",D20,IF(K6=\"Halogen\",E20,IF(K6=\"Fluorescent\",F20,IF(K6=\"LED\",G20,0))))","v":60},0,0]
[null,null,null,null,null,null,null,null,"75 Watt Light",1,"LED",15,3,45]
[null,null,null,null,null,null,null,null,"100 Watt Light",0,"Incandescent",100,0,0]
["NOTE: The table below contains the typical power requirements of an incandescent light and the comparable power required by other types of lights. These values are used to determine the corresponding energy requirements depending on the type of light you will be using.",null,null,null,null,null,null,null,"150 Watt Light",0,"LED",{"$f":"IF(K9=\"Incandescent\",D23,IF(K9=\"Halogen\",E23,IF(K9=\"Fluorescent\",F23,IF(K9=\"LED\",G23,0))))","v":30},0,0]
[null,null,null,null,null,null,null,null,"Other Lights",0,"Misc ",0,0,{"$f":"M10*L10*J10","v":0}]
[]
["Step 4: You can enter an additional power percentage in the Multiplier cell. This value will be used to generate an extra amount of power to provide for any additional uses.",null,null,null,null,null,null,null,"Daily Energy Requirement",null,null,null,{"$f":"SUM(N4:N10)","v":161},"watt-hr/day"]
[null,null,null,null,null,null,null,null,"Multiplier** (additional %)",null,null,0,"%"]
["Step 5:  After getting the Daily Energy Requirement, move on to the next sheet titled Battery Bank by clicking that sheet's tab on the bottom of this page.",null,null,null,null,null,null,null,"Daily Energy Requirement (with multiplier)",null,null,null,{"$f":"M12+M12*(L13/100)","v":161},"watt-hr/day"]
[null,null,null,null,null,null,null,null,"**Multiplier is used to add a percentage of the daily requirement for margin of error. Valid values are 0–20%. Use 0 if no margin is needed."]
["Typical power requirement for lights (Watts/hour)"]
[null,null,"Lumens","Incandescent","Halogen","Fluorescent","LED"]
["40 Watt Light",null,450,40,{"$f":"D18*0.7","v":28},{"$f":"D18*0.3","v":12},{"$f":"D18*0.2","v":8}]
["50 Watt Light",null,600,50,{"$f":"D19*0.7","v":35},{"$f":"D19*0.3","v":15},{"$f":"D19*0.2","v":10}]
["60 Watt Light",null,800,60,42,18,12]
["75 Watt Light",null,1100,75,52.5,22.5,15]
["100 Watt Light",null,1600,100,70,30,20]
["150 Watt Light",null,2600,150,105,{"$f":"D23*0.3","v":45},30]

{"sheet":"Battery Bank","index":3,"n_rows":34,"n_cols":31,"rows_kept":34,"cut":false,"hidden":false,"merged":[[8,11,8,13],[11,0,12,5],[21,0,22,5],[5,0,7,9],[8,0,9,9],[0,0,0,17],[2,11,3,17],[5,11,5,13],[6,11,6,13],[7,11,7,13],[1,0,4,9],[4,11,4,13]]}
["Battery Bank",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,"Temperatures"]
["Step 6: In the System Features table below, enter the values of system voltage (6, 12, 24, or 48), system de-rating factor (typically 5–20%), minimum temperature where the batteries are kept, and solar panel efficiency (typically about 85%). These are used to calculate the total W/day and A/day capacity required for the loads.",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","C",null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,"NOTE: Enter one-way distance between components. The units are in feet.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[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,80,26.7,1,null,24]
[null,null,null,null,null,null,null,null,null,null,null,"Distance from:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,21.2,1.04,null,48]
["Step 7: In the Battery Bank Size table, enter the  battery voltage and the rated battery Amp-hours.  Enter the number of days you want the lights to be able to run without recharging (used for cloudy days). Finally, enter your maximum depth of discharge (typically between 20–60%).",null,null,null,null,null,null,null,null,null,null,"Solar panels to controller",null,null,10,"ft",null,null,null,null,null,null,null,null,null,null,60,15.6,1.1100000000000001]
[null,null,null,null,null,null,null,null,null,null,null,"Batteries to controller",null,null,50,"ft",null,null,null,null,null,null,null,null,null,null,50,10,1.19]
[null,null,null,null,null,null,null,null,null,null,null,"Lights to controller",null,null,20,"ft",null,null,null,null,null,null,null,null,null,null,40,4.4000000000000004,1.3]
["Step 8: In the green cells to the right and using the diagram below as a guide, enter the distances between the components of the system. This is used to calculate the wire losses. ",null,null,null,null,null,null,null,null,null,null,"Total Distance",null,null,{"$f":"SUM(O6:O8)","v":80},"ft",null,null,null,null,null,null,null,null,null,null,30,-1.1000000000000001,1.4]
[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,20,-6.7,1.59]
[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,10,-12.2,1.8]
["SYSTEM FEATURES",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,"New Mexico",null,34]
[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,"Arizona",null,42]
["System Voltage",null,null,null,12,"V",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Colorado",null,24]
["System De-rating (losses)",null,null,null,5,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Utah",null,26]
["Minimum Temperature",null,null,null,10,"F",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nevada",null,30]
["Solar Panel Efficiency",null,null,null,50,"%"]
["Max Amps Drawn (All lights on)",null,null,null,{"$f":"ROUNDUP(Lights!M14/'Battery Bank'!E14,0)","v":14},"A/day"]
["Total Wattage Required",null,null,null,{"$f":"ROUNDUP(((IF(E16=80,1,IF(E16=70,1.04,IF(E16=60,1.11,IF(E16=50,1.19,IF(E16=40,1.3,IF(E16=30,1.4,IF(E16=20,1.59,IF(E16=10,1.8,1))))))))*Lights!M14)/(E17/100))*(1+(E15/100)),0)","v":609},"W/day"]
["TOTAL A/H REQUIRED",null,null,null,{"$f":"ROUNDUP(E19/E14,0)","v":51},"A/day"]
[]
["BATTERY BANK SIZE"]
[]
["Battery Voltage",null,null,null,12,"V"]
["Battery Amps/Hour Capacity",null,null,null,100,"A/h"]
["Storage Days",null,null,null,2,"days"]
["Maximum Depth of Discharge",null,null,null,50,"%"]
["Battery Bank Wattage Required",null,null,null,{"$f":"ROUNDUP((E19*E26)/(E27/100),0)","v":2436},"W/day"]
["Battery Bank Amperage Required",null,null,null,{"$f":"ROUNDUP(E28/E24,0)","v":203},"A/day"]
["Batteries in Series",null,null,null,{"$f":"ROUNDUP(E14/E24,0)","v":1}]
["Batteries in Parallel",null,null,null,{"$f":"ROUNDUP((E28/(E30*E24))/E25,0)","v":3}]
["Total Number of Batteries",null,null,null,{"$f":"ROUNDUP(E30*E31,0)","v":3}]
["Total Battery Bank Wattage",null,null,null,{"$f":"E25*E24*E32","v":3600},"W/day"]
["Actual Days of Autonomy",null,null,null,{"$f":"E33/(E19/(E27/100))","v":2.9556650246305418}]

{"sheet":"Array Sizing","index":4,"n_rows":51,"n_cols":46,"rows_kept":51,"cut":false,"hidden":false,"merged":[[3,16,3,18],[2,0,6,5],[19,10,19,12],[7,0,8,8],[10,0,10,6],[11,0,11,3],[11,4,11,5],[9,0,9,10],[19,13,19,15],[35,2,35,4],[31,13,31,15],[31,10,31,11],[31,0,32,8],[12,21,12,36],[29,0,29,8],[20,13,20,15],[0,0,0,15],[21,6,21,7],[23,6,23,7],[25,6,25,7],[34,0,34,4]]}
["Sizing the PV Array"]
[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,"Wattage","Column",null,null,null,1]
["The purpose of this sheet is to calculate the size of the array needed for your system (see box to right). You should choose a PV module size (50–315W) from the sample list of ten below. The (most efficient) recommended choice is shown in the Recommended Option table at the bottom right.",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,"Smallest",{"$f":"SMALL($V$26:$AK$26,1)","v":4.2203999999999988},{"$f":"MATCH(SMALL($V$26:$AK$26,1),$V$26:$AK$26,0)","v":4},{"$f":"IFERROR(INDEX($V$12:$AK$12,AN3),0)","v":"4c1v"},null,{"$f":"IF(AO3>0,INDEX($V$27:$AK$27,AN3),0)","v":2},2]
[null,null,null,null,null,null,"Peak Panel Wattage",{"$f":"'Battery Bank'!E19*'Battery Bank'!E26/'Solar Resource'!K5","v":243.6},"W",null,null,null,null,null,null,null,"Pump Requirements",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SMALL($V$26:$AK$26,2)","v":24.220199999999998},{"$f":"MATCH(SMALL($V$26:$AK$26,2),$V$26:$AK$26,0)","v":2},{"$f":"IFERROR(INDEX($V$12:$AK$12,AN4),0)","v":"2c1v"},null,{"$f":"IF(AO4>0,INDEX($V$27:$AK$27,AN4),0)","v":5},3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Voltage",{"$f":"H6","v":12},{"$f":"R5","v":12},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SMALL($V$26:$AK$26,3)","v":29.220299999999998},{"$f":"MATCH(SMALL($V$26:$AK$26,3),$V$26:$AK$26,0)","v":3},"3c1v",null,4,4]
[null,null,null,null,null,null,"Voltage",{"$f":"'Battery Bank'!E14","v":12},"V",null,null,null,null,null,null,null,"Current",{"$f":"H4/H6","v":20.3},{"$f":"R6/0.8","v":25.375},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SMALL($V$26:$AK$26,4)","v":44.220599999999997},{"$f":"MATCH(SMALL($V$26:$AK$26,4),$V$26:$AK$26,0)","v":6},{"$f":"IFERROR(INDEX($V$12:$AK$12,AN6),0)","v":0},null,0,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Power",{"$f":"H4","v":243.6},{"$f":"R7/0.8","v":304.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SMALL($V$26:$AK$26,5)","v":59.22},{"$f":"MATCH(SMALL($V$26:$AK$26,5),$V$26:$AK$26,0)","v":1},{"$f":"IFERROR(INDEX($V$12:$AK$12,AN7),0)","v":0},null,0,6]
["NOTE:  Modules in series (a string) give the required voltage, and the modules in parallel will achieve the power required by increasing the total amount of current.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Real Power",{"$f":"H4","v":243.6},{"$f":"R8*1.05","v":255.78},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SMALL($V$26:$AK$26,6)","v":69.220500000000001},{"$f":"MATCH(SMALL($V$26:$AK$26,6),$V$26:$AK$26,0)","v":5},{"$f":"IFERROR(INDEX($V$12:$AK$12,AN8),0)","v":"5c1v"},null,2,7]
[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":"SMALL($V$26:$AK$26,7)","v":94.220699999999994},{"$f":"MATCH(SMALL($V$26:$AK$26,7),$V$26:$AK$26,0)","v":7},0,null,0,8]
["==============================================================================================",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":"SMALL($V$26:$AK$26,8)","v":144.2208},{"$f":"MATCH(SMALL($V$26:$AK$26,8),$V$26:$AK$26,0)","v":8},0,null,0,9]
["Step 9: Enter your choice from the table below for a solar panel size to use (module 1–10) :",null,null,null,null,null,null,null,2,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":"SMALL($V$26:$AK$26,9)","v":194.2209},{"$f":"MATCH(SMALL($V$26:$AK$26,9),$V$26:$AK$26,0)","v":9},0,null,0,10]
["PV module choices",null,null,null,"Sizes are inches",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND((((INDEX($C$14:$C$23,V27)))<($S$5+$AN$25)),((INDEX($C$14:$C$23,V27))>($S$5-$AN$25))),\"1v1c\",IF(AND((((INDEX(D14:D23,V27)))<(S6+AN26)),((INDEX(D14:D23,V27))>(S6-AN26))),\"1c1v\",0))","v":0},{"$f":"IF(AND((((INDEX(C14:C23,W27))*2)<(S5+AN25)),((INDEX(C14:C23,W27)*2)>(S5-AN25))),\"2v1c\",IF(AND((((INDEX(D14:D23,W27))*2)<(S6+AN26)),((INDEX(D14:D23,W27)*2)>(S6-AN26))),\"2c1v\",0))","v":"2c1v"},{"$f":"IF(AND((((INDEX(C14:C23,X27))*3)<(S5+AN25)),((INDEX(C14:C23,X27)*3)>(S5-AN25))),\"3v1c\",IF(AND((((INDEX(D14:D23,X27))*3)<(S6+AN26)),((INDEX(D14:D23,X27)*3)>(S6-AN26))),\"3c1v\",0))","v":"3c1v"},{"$f":"IF(AND((((INDEX(C14:C23,Y27))*2)<(S5+AN25)),((INDEX(C14:C23,Y27)*2)>(S5-AN25))),\"2v2c\",IF(AND((((INDEX(D14:D23,Y27))*2)<(S6+AN26)),((INDEX(D14:D23,Y27)*2)>(S6-AN26))),\"2c2v\",IF(AND((((INDEX(C14:C23,Y27))*4)<(S5+AN25)),((INDEX(C14:C23,Y27)*4)>(S5-AN25))),\"4v1c\",IF(AND((((INDEX(D14:D23,Y27))*4)<(S6+AN26)),((INDEX(D14:D23,Y27)*4)>(S6-AN26))),\"4c1v\",0))))","v":"4c1v"},{"$f":"IF(AND((((INDEX(C14:C23,Z27))*5)<(S5+AN25)),((INDEX(C14:C23,Z27)*5)>(S5-AN25))),\"5v1c\",IF(AND((((INDEX(D14:D23,Z27))*5)<(S6+AN26)),((INDEX(D14:D23,Z27)*5)>(S6-AN26))),\"5c1v\",0))","v":"5c1v"},{"$f":"IF(AND((((INDEX(C14:C23,AA27))*2)<(S5+AN25)),((INDEX(C14:C23,AA27)*2)>(S5-AN25))),\"2v3c\",IF(AND((((INDEX(D14:D23,AA27))*2)<(S6+AN26)),((INDEX(D14:D23,AA27)*2)>(S6-AN26))),\"2c3v\",IF(AND((((INDEX(C14:C23,AA27))*3)<(S5+AN25)),((INDEX(C14:C23,AA27)*3)>(S5-AN25))),\"3v2c\",IF(AND((((INDEX(D14:D23,AA27))*3)<(S6+AN26)),((INDEX(D14:D23,AA27)*3)>(S6-AN26))),\"3c2v\",0))))","v":0},{"$f":"IF(AND((((INDEX(C14:C23,AB27))*7)<(S5+AN25)),((INDEX(C14:C23,AB27)*7)>(S5-AN25))),\"7v1c\",IF(AND((((INDEX(D14:D23,AB27))*7)<(S6+AN26)),((INDEX(D14:D23,AB27)*7)>(S6-AN26))),\"7c1v\",0))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND((((INDEX(C14:C23,AC27))*4)<(S5+AN25)),((INDEX(C14:C23,AC27)*4)>(S5-AN25))),\"4v2c\",IF(AND((((INDEX(D14:D23,AC27))*4)<(S6+AN26)),((INDEX(D14:D23,AC27)*4)>(S6-AN26))),\"4c2v\",0))","v":0},{"$f":"IF(AND((((INDEX(C14:C23,AD27))*3)<(S5+AN25)),((INDEX(C14:C23,AD27)*3)>(S5-AN25))),\"3v3c\",IF(AND((((INDEX(D14:D23,AD27))*3)<(S6+AN26)),((INDEX(D14:D23,AD27)*3)>(S6-AN26))),\"3c3v\",0))","v":0},{"$f":"IF(AND((((INDEX(C14:C23,AE27))*5)<(S5+AN25)),((INDEX(C14:C23,AE27)*5)>(S5-AN25))),\"5v2c\",IF(AND((((INDEX(D14:D23,AE27))*5)<(S6+AN26)),((INDEX(D14:D23,AE27)*5)>(S6-AN26))),\"5c2v\",0))","v":"5c2v"},{"$f":"IF(AND((((INDEX(C14:C23,AF27))*11)<(S5+AN25)),((INDEX(C14:C23,AF27)*11)>(S5-AN25))),\"11v1c\",IF(AND((((INDEX(D14:D23,AF27))*11)<(S6+AN26)),((INDEX(D14:D23,AF27)*11)>(S6-AN26))),\"11c1v\",0))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND((((INDEX(C14:C23,AG27))*6)<(S5+AN25)),((INDEX(C14:C23,AG27)*6)>(S5-AN25))),\"6v2c\",IF(AND((((INDEX(D14:D23,AG27))*6)<(S6+AN26)),((INDEX(D14:D23,AG27)*6)>(S6-AN26))),\"6c2v\",IF(AND((((INDEX(C14:C23,AG27))*4)<(S5+AN25)),((INDEX(C14:C23,AG27)*4)>(S5-AN25))),\"4v3c\",IF(AND((((INDEX(D14:D23,AG27))*4)<(S6+AN26)),((INDEX(D14:D23,AG27)*4)>(S6-AN26))),\"4c3v\",IF(AND((((INDEX(C14:C23,AG27))*3)<(S5+AN25)),((INDEX(C14:C23,AG27)*3)>(S5-AN25))),\"3v4c\",IF(AND((((INDEX(D14:D23,AG27))*3)<(S6+AN26)),((INDEX(D14:D23,AG27)*3)>(S6-AN26))),\"3c4v\",0))))))","v":"6c2v"},{"$f":"IF(AND((((INDEX(C14:C23,AH27))*13)<(S5+AN25)),((INDEX(C14:C23,AH27)*13)>(S5-AN25))),\"13v1c\",IF(AND((((INDEX(D14:D23,AH27))*13)<(S6+AN26)),((INDEX(D14:D23,AH27)*13)>(S6-AN26))),\"13c1v\",0))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND((((INDEX(C14:C23,AI27))*7)<(S5+AN25)),((INDEX(C14:C23,AI27)*7)>(S5-AN25))),\"7v2c\",IF(AND((((INDEX(D14:D23,AI27))*7)<(S6+AN26)),((INDEX(D14:D23,AI27)*7)>(S6-AN26))),\"7c2v\",0))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND((((INDEX(C14:C23,AJ27))*5)<(S5+AN25)),((INDEX(C14:C23,AJ27)*5)>(S5-AN25))),\"5v3c\",IF(AND((((INDEX(D14:D23,AJ27))*5)<(S6+AN26)),((INDEX(D14:D23,AJ27)*5)>(S6-AN26))),\"5c3v\",IF(AND((((INDEX(C14:C23,AJ27))*3)<(S5+AN25)),((INDEX(C14:C23,AJ27)*3)>(S5-AN25))),\"3v5c\",IF(AND((((INDEX(D14:D23,AJ27))*3)<(S6+AN26)),((INDEX(D14:D23,AJ27)*3)>(S6-AN26))),\"3c5v\",0))))","v":"5c3v"},{"$f":"IF(AND((((INDEX(C14:C23,AK27))*4)<(S5+AN25)),((INDEX(C14:C23,AK27)*4)>(S5-AN25))),\"4v4c\",IF(AND((((INDEX(D14:D23,AK27))*4)<(S6+AN26)),((INDEX(D14:D23,AK27)*4)>(S6-AN26))),\"4c4v\",IF(AND((((INDEX(C14:C23,AK27))*8)<(S5+AN25)),((INDEX(C14:C23,AK27)*8)>(S5-AN25))),\"8v2c\",IF(AND((((INDEX(D14:D23,AK27))*8)<(S6+AN26)),((INDEX(D14:D23,AK27)*8)>(S6-AN26))),\"8c2v\",0))))","v":"8c2v"},null,{"$f":"SMALL($V$26:$AK$26,10)","v":244.221},{"$f":"MATCH(SMALL($V$26:$AK$26,10),$V$26:$AK$26,0)","v":10},"5c2v",null,1]
[null,"Power","Vmp","Imp","length","width","For your chosen PV selection , you need:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of panels used",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number",{"$f":"SMALL($V$26:$AK$26,11)","v":294.22110000000004},{"$f":"MATCH(SMALL($V$26:$AK$26,11),$V$26:$AK$26,0)","v":11},0,null,0]
[1,50,17.399999999999999,2.9,26,25,"Modules in Series (a string)",null,{"$f":"IFERROR(IF(J14=0,0,IF(MID(J14,2,1)=\"v\",(MID(J14,1,1)),MID(J14,3,1))),ROUNDUP((H6/D26),0))","v":"1"},{"$f":"INDEX(AO3:AO18,MATCH(I11,AQ3:AQ18,0))","v":"4c1v"},null,null,null,null,null,null,null,null,null,null,"Wattage",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,"option",{"$f":"SMALL($V$26:$AK$26,12)","v":344.22120000000001},{"$f":"MATCH(SMALL($V$26:$AK$26,12),$V$26:$AK$26,0)","v":12},"6c2v",null,1]
[2,65,17.899999999999999,3.6,40,20,null,null,{"$f":"D26*I14","v":17.899999999999999},"V",null,null,null,null,null,null,null,null,null,null,50,{"$f":"V14*$U$15","v":50},{"$f":"W14*$U$15","v":100},150,200,250,300,{"$f":"IF($AK$29=1,$AB$14*U15,0)","v":350},{"$f":"AC14*$U$15","v":400},{"$f":"IF($AK$29=1,$AD$14*U15,0)","v":450},500,{"$f":"IF($AK$29=1,$AF$14*U15,0)","v":550},600,{"$f":"IF($AK$29=1,$AH$14*U15,0)","v":650},700,{"$f":"IF($AK$29=1,$AJ$14*U15,0)","v":750},800,1,{"$f":"SMALL($V$26:$AK$26,13)","v":394.22130000000004},{"$f":"MATCH(SMALL($V$26:$AK$26,13),$V$26:$AK$26,0)","v":13},0,null,0]
[3,80,17.600000000000001,4.5,40,26,"Number of PV Strings in Parallel",null,{"$f":"IFERROR(IF(J14=0,0,IF(MID(J14,4,1)=\"c\",(MID(J14,3,1)),MID(J14,1,1))),ROUNDUP(((H4/(I14*D26))/D27),0))","v":"4"},null,null,null,null,null,null,null,null,null,null,null,65,{"$f":"V14*$U$16","v":65},{"$f":"W14*$U$16","v":130},195,260,325,390,{"$f":"IF($AK$29=1,$AB$14*U16,0)","v":455},520,{"$f":"IF($AK$29=1,$AD$14*U16,0)","v":585},650,{"$f":"IF($AK$29=1,$AF$14*U16,0)","v":715},780,{"$f":"IF($AK$29=1,$AH$14*U16,0)","v":845},910,{"$f":"IF($AK$29=1,$AJ$14*U16,0)","v":975},1040,2,{"$f":"SMALL($V$26:$AK$26,14)","v":444.22140000000002},{"$f":"MATCH(SMALL($V$26:$AK$26,14),$V$26:$AK$26,0)","v":14},0,null,0]
[4,95,18.5,5.0999999999999996,47.5,21.5,null,null,{"$f":"D27*I16","v":14.4},"A",null,null,null,null,null,null,null,null,null,null,80,{"$f":"V14*$U$17","v":80},{"$f":"W14*$U$17","v":160},240,320,400,480,560,640,720,800,880,960,1040,1120,1200,1280,3,{"$f":"SMALL($V$26:$AK$26,15)","v":494.22150000000005},{"$f":"MATCH(SMALL($V$26:$AK$26,15),$V$26:$AK$26,0)","v":15},"5c3v",null,1]
[5,140,17.7,7.9,59,26,"Total Number of Panels",null,{"$f":"(I14*I16)","v":4},null,null,null,null,null,null,null,null,null,null,null,95,{"$f":"V14*$U$18","v":95},{"$f":"W14*$U$18","v":190},285,380,475,570,665,760,855,950,1045,1140,1235,1330,1425,1520,4,{"$f":"SMALL($V$26:$AK$26,16)","v":544.22160000000008},{"$f":"MATCH(SMALL($V$26:$AK$26,16),$V$26:$AK$26,0)","v":16},"8c2v",null,1]
[6,185,36.200000000000003,5.0999999999999996,62,31,null,null,{"$f":"I15*I17","v":257.76},"W",null,null,null,null,null,null,null,null,null,null,140,{"$f":"V14*$U$19","v":140},{"$f":"W14*$U$19","v":280},420,560,700,840,980,1120,{"$f":"IF($AK$29=1,$AD$14*U19,0)","v":1260},1400,1540,1680,1820,1960,2100,2240,5]
[7,200,36.9,5.4,62,32,"Total Peak Power",{"$f":"(D26*D27*I18)-(D26*D27*I18*M32)","v":250.8959568384},"Watts",null,"Recommended option",null,null,"Other recommended panels",null,null,null,null,null,null,185,{"$f":"V14*$U$20","v":185},{"$f":"W14*$U$20","v":370},555,740,925,1110,1295,1480,1665,1850,2035,2220,2405,2590,2775,2960,6]
[8,230,29.8,7.72,66,37.5,null,null,null,{"$f":"INDEX(AO3:AO18,MATCH(M22,AN3:AN18,0))","v":"4c1v"},"Panel Option Number",null,{"$f":"INDEX(V27:AK27,M22)","v":2},"options are:",null,null,null,null,null,null,200,{"$f":"V14*$U$21","v":200},{"$f":"W14*$U$21","v":400},600,800,1000,1200,1400,1600,1800,2000,2200,2400,2600,2800,3000,3200,7]
[9,250,31.1,8.0500000000000007,66,39.5,"Total Wire Length",null,null,null,"Number of Panels",null,{"$f":"IF(AO3>0,AN3,IF(AO4>0,AN4,IF(AO5>0,AN5,IF(AO6>0,AN6,IF(AO7>0,AN7,IF(AO8>0,AN8,IF(AO9>0,AN9,IF(AO10>0,AN10,IF(AO11>0,AN11,IF(AO12>0,AN12,IF(AO13>0,AN13,IF(AO14>0,AN14,IF(AO15>0,AN15,IF(AO16>0,AN16,IF(AO17>0,AN17,IF(AO18>0,AN18))))))))))))))))","v":4},null,{"$f":"IF($AO$38<9,INDEX($AP$28:$AP$37,1+AT28),\"\")","v":1},null,null,null,null,null,230,{"$f":"V14*$U$22","v":230},{"$f":"W14*$U$22","v":460},690,920,1150,1380,1610,1840,2070,2300,2530,2760,2990,3220,3450,3680,8]
[10,315,39.799999999999997,7.92,65.5,52,null,{"$f":"'Battery Bank'!O9*1.15","v":92},"ft",null,"Total Wattage",null,{"$f":"INDEX(U15:U24,M21)*M22","v":260},null,{"$f":"IF($AO$38<8,INDEX($AP$28:$AP$37,2+AT29),\"\")","v":4},null,null,null,null,null,250,{"$f":"V14*$U$23","v":250},{"$f":"W14*$U$23","v":500},{"$f":"X14*$U$23","v":750},1000,1250,1500,1750,2000,2250,2500,2750,3000,3250,3500,3750,4000,9]
[null,null,null,null,null,null,"Minimum Amp Capacity of the Controller",null,null,null,null,null,null,null,{"$f":"IF($AO$38<7,INDEX($AP$28:$AP$37,3+AT30),\"\")","v":5},null,null,null,null,null,315,{"$f":"V14*$U$24","v":315},{"$f":"W14*$U$24","v":630},945,1260,1575,1890,2205,2520,2835,3150,3465,3780,4095,4410,4725,5040,10]
["The chosen panel Power is:",null,null,{"$f":"LOOKUP(I11,A14:A23,B14:B23)","v":65},"Watts",null,null,{"$f":"ROUNDUP(I16*D27*1.25,0)","v":18},"amps",null,"Modules in Series",null,{"$f":"IF(MID(J21,2,1)=\"v\",(MID(J21,1,1)),MID(J21,3,1))","v":"1"},null,{"$f":"IF($AO$38<6,INDEX($AP$28:$AP$37,4+AT31),\"\")","v":""},null,null,null,null,null,"T Watts",{"$f":"MIN(IF((V15:V24>=$S$8),V15:V24))","v":315},{"$f":"MIN(IF((W15:W24>=$S$8),W15:W24))","v":280},{"$f":"MIN(IF((X15:X24>=$S$8),X15:X24))","v":285},{"$f":"MIN(IF((Y15:Y24>=$S$8),Y15:Y24))","v":260},{"$f":"MIN(IF((Z15:Z24>=$S$8),Z15:Z24))","v":325},{"$f":"MIN(IF((AA15:AA24>=$S$8),AA15:AA24))","v":300},{"$f":"MIN(IF((AB15:AB24>=$S$8),AB15:AB24))","v":350},{"$f":"MIN(IF((AC15:AC24>=$S$8),AC15:AC24))","v":400},{"$f":"MIN(IF((AD15:AD24>=$S$8),AD15:AD24))","v":450},{"$f":"MIN(IF((AE15:AE24>=$S$8),AE15:AE24))","v":500},{"$f":"MIN(IF((AF15:AF24>=$S$8),AF15:AF24))","v":550},{"$f":"MIN(IF((AG15:AG24>=$S$8),AG15:AG24))","v":600},{"$f":"MIN(IF((AH15:AH24>=$S$8),AH15:AH24))","v":650},{"$f":"MIN(IF((AI15:AI24>=$S$8),AI15:AI24))","v":700},{"$f":"MIN(IF((AJ15:AJ24>=$S$8),AJ15:AJ24))","v":750},{"$f":"MIN(IF((AK15:AK24>=$S$8),AK15:AK24))","v":800},null,"+/- volts",12]
["The chosen panel Voltage is:",null,null,{"$f":"LOOKUP(I11,A14:A23,C14:C23)","v":17.899999999999999},"Volts",null,"Minimum Fuse Size",null,null,null,"Voltage generated",null,{"$f":"(INDEX(C14:C23,M21))*M25","v":17.899999999999999}," V",{"$f":"IF($AO$38<5,INDEX($AP$28:$AP$37,5+AT32),\"\")","v":""},null,null,null,null,null,"Excess",{"$f":"ABS(V25-$S$8)","v":59.22},{"$f":"ABS(W25-$S$8)+0.0002","v":24.220199999999998},{"$f":"ABS(X25-$S$8)+0.0003","v":29.220299999999998},{"$f":"ABS(Y25-$S$8)+0.0004","v":4.2203999999999988},{"$f":"ABS(Z25-$S$8)+0.0005","v":69.220500000000001},{"$f":"ABS(AA25-$S$8)+0.0006","v":44.220599999999997},{"$f":"ABS(AB25-$S$8)+0.0007","v":94.220699999999994},{"$f":"ABS(AC25-$S$8)+0.0008","v":144.2208},{"$f":"ABS(AD25-$S$8)+0.0009","v":194.2209},{"$f":"ABS(AE25-$S$8)+0.001","v":244.221},{"$f":"ABS(AF25-$S$8)+0.0011","v":294.22110000000004},{"$f":"ABS(AG25-$S$8)+0.0012","v":344.22120000000001},{"$f":"ABS(AH25-$S$8)+0.0013","v":394.22130000000004},{"$f":"ABS(AI25-$S$8)+0.0014","v":444.22140000000002},{"$f":"ABS(AJ25-$S$8)+0.0015","v":494.22150000000005},{"$f":"ABS(AK25-$S$8)+0.0016","v":544.22160000000008},null,"+/- current",13]
["The chosen panel Current is:",null,null,{"$f":"LOOKUP(I11,A14:A23,D14:D23)","v":3.6},"Amps",null,null,{"$f":"ROUNDUP(D27*I16*1.56,0)","v":23},"amps",null,"Modules in Parallel",null,{"$f":"IF(MID(J21,4,1)=\"c\",(MID(J21,3,1)),MID(J21,1,1))","v":"4"},null,{"$f":"IF($AO$38<4,INDEX($AP$28:$AP$37,6+AT33),\"\")","v":""},null,null,null,null,null,"Rows",{"$f":"MATCH(V25,V15:V24,0)","v":10},{"$f":"MATCH(W25,W15:W24,0)","v":5},{"$f":"MATCH(X25,X15:X24,0)","v":4},2,2,{"$f":"MATCH(AA25,AA15:AA24,0)","v":1},{"$f":"IF(AK30=0,0,MATCH(AB25,AB15:AB24,0))","v":0},1,1,1,{"$f":"IF(AK30=0,0,MATCH(AF25,AF15:AF24,0))","v":0},1,{"$f":"IF(AK30=0,0,MATCH(AH25,AH15:AH24,0))","v":0},{"$f":"IF(AK30=0,0,MATCH(AI25,AI15:AI24,0))","v":0},1,1,null,null,"Option","Y/N","Order",null,null,"Other Options"]
[null,null,null,null,null,null,null,null,null,null,"Current generated",null,{"$f":"(INDEX(D14:D23,M21))*M27","v":14.4}," A",{"$f":"IF($AO$38<3,INDEX($AP$28:$AP$37,7+AT34),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AQ28>0,1.0001,0.0001)","v":1.0001},{"$f":"INDEX($AN$28:$AN$37,MATCH(LARGE($AO$28:$AO$37,1),$AO$28:$AO$37,0))","v":1},{"$f":"COUNTIF($AQ$3:$AQ$18,AN28)","v":4},null,{"$f":"IF($M$21=AP28,1,0)","v":0},{"$f":"SUM(AS28)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Actual power generated",null,{"$f":"M28*M26","v":257.76}," W",{"$f":"IF($AO$38<2,INDEX($AP$28:$AP$37,8+AT35),\"\")","v":""},null,null,null,null,null,null,"Col.",{"$f":"MATCH(MIN(V26:AK26),V26:AK26,0)","v":4},null,"Row ",{"$f":"INDEX(V27:AL27,1,W29)","v":2},null,null,null,null,null,null,"Use odd numbers?",null,null,null,1,null,null,2,{"$f":"IF(AQ29>0,1.00009,0.00009)","v":1.0000899999999999},{"$f":"INDEX($AN$28:$AN$37,MATCH(LARGE($AO$28:$AO$37,2),$AO$28:$AO$37,0))","v":2},{"$f":"COUNTIF($AQ$3:$AQ$18,AN29)","v":2},null,{"$f":"IF($M$21=AP29,1,0)","v":1},{"$f":"SUM(AS28:AS29)","v":1}]
["NOTE: A controller will be needed to control the power generated for the PV modules and the power going to the",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AO$38<1,INDEX($AP$28:$AP$37,9+AT36),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Disable(7,11,13,14)",null,null,null,0,null,null,3,{"$f":"IF(AQ30>0,1.00008,0.00008)","v":8.0000000000000007E-5},{"$f":"INDEX($AN$28:$AN$37,MATCH(LARGE($AO$28:$AO$37,3),$AO$28:$AO$37,0))","v":4},0,null,{"$f":"IF($M$21=AP30,1,0)","v":0},{"$f":"SUM(AS28:AS30)","v":1}]
["batteries. These are selected to marry with a particular wattage and amperage.",null,null,null,null,null,null,null,null,null,"Wire size recommended",null,{"$f":"IFERROR(D49,\"None\")","v":"Wire 4"},null,{"$f":"IF($AO$38<0,INDEX($AP$28:$AP$37,10+AT37),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"IF(AQ31>0,1.00007,0.00007)","v":1.00007},{"$f":"INDEX($AN$28:$AN$37,MATCH(LARGE($AO$28:$AO$37,4),$AO$28:$AO$37,0))","v":5},1,null,0,{"$f":"SUM(AS28:AS31)","v":1}]
["Step 10: Proceed to the next sheet titled Design Spec where you will see your design scenario's components and example prices. ",null,null,null,null,null,null,null,null,null,"Wire power losses",null,{"$f":"IF(M31=\"Wire 12\",H48,IF(M31=\"Wire 10\",I48,IF(M31=\"Wire 8\",J48,IF(M31=\"Wire 6\",K48,IF(M31=\"Wire 4\",L48,IF(M31=\"Wire 2\",M48,IF(M31=\"Wire 0\",N48,IF(M31=\"Wire 00\",O48,0))))))))","v":2.6629590167597764E-2},"Acceptable voltage wire losses",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,{"$f":"IF(AQ32>0,1.00006,0.00006)","v":1.0000599999999999},{"$f":"INDEX($AN$28:$AN$37,MATCH(LARGE($AO$28:$AO$37,5),$AO$28:$AO$37,0))","v":3},1,null,0,{"$f":"SUM(AS28:AS32)","v":1}]
[null,null,null,null,null,null,null,null,null,null,"Wire voltage losses",null,{"$f":"IF(M31=\"Wire 12\",H50,IF(M31=\"Wire 10\",I50,IF(M31=\"Wire 8\",J50,IF(M31=\"Wire 6\",K50,IF(M31=\"Wire 4\",L50,IF(M31=\"Wire 2\",M50,IF(M31=\"Wire 0\",N50,IF(M31=\"Wire 00\",O50,0))))))))","v":3.6857564245810055E-2},null,0.05,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"IF(AQ33>0,1.00005,0.00005)","v":5.0000000000000002E-5},{"$f":"INDEX($AN$28:$AN$37,MATCH(LARGE($AO$28:$AO$37,6),$AO$28:$AO$37,0))","v":6},0,null,0,{"$f":"SUM(AS28:AS33)","v":1}]
[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,7,{"$f":"IF(AQ34>0,1.00004,0.00004)","v":4.0000000000000003E-5},{"$f":"INDEX($AN$28:$AN$37,MATCH(LARGE($AO$28:$AO$37,7),$AO$28:$AO$37,0))","v":7},{"$f":"COUNTIF($AQ$3:$AQ$18,AN34)","v":0},null,{"$f":"IF($M$21=AP34,1,0)","v":0},{"$f":"SUM(AS28:AS34)","v":1}]
["With the selected panel, this system will generate ",null,null,null,null,{"$f":"H20*'Solar Resource'!K5","v":1254.4797841919999},"watts/day",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,8,{"$f":"IF(AQ35>0,1.00003,0.00003)","v":3.0000000000000001E-5},{"$f":"INDEX($AN$28:$AN$37,MATCH(LARGE($AO$28:$AO$37,8),$AO$28:$AO$37,0))","v":8},{"$f":"COUNTIF($AQ$3:$AQ$18,AN35)","v":0},null,{"$f":"IF($M$21=AP35,1,0)","v":0},{"$f":"SUM(AS28:AS35)","v":1}]
[null,null,"of the total required of ",null,null,{"$f":"'Solar Resource'!K5*H4","v":1218},"watts/day",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,9,{"$f":"IF(AQ36>0,1.00002,0.00002)","v":2.0000000000000002E-5},{"$f":"INDEX($AN$28:$AN$37,MATCH(LARGE($AO$28:$AO$37,9),$AO$28:$AO$37,0))","v":9},{"$f":"COUNTIF($AQ$3:$AQ$18,AN36)","v":0},null,{"$f":"IF($M$21=AP36,1,0)","v":0},{"$f":"SUM(AS28:AS36)","v":1}]
[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,10,{"$f":"IF(AQ37>0,1.00001,0.00001)","v":1.0000000000000001E-5},{"$f":"INDEX($AN$28:$AN$37,MATCH(LARGE($AO$28:$AO$37,10),$AO$28:$AO$37,0))","v":10},{"$f":"COUNTIF($AQ$3:$AQ$18,AN37)","v":0},null,{"$f":"IF($M$21=AP37,1,0)","v":0},{"$f":"SUM(AS28:AS37)","v":1}]
[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,"Useless",{"$f":"COUNTIF(AO28:AO37,\"<1\")","v":6},1]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Wire 12","Wire 10","Wire 8","Wire 6","Wire 4","Wire 2","Wire 0","Wire 00"]
[null,null,null,null,null,null,"Wire Resistance",{"$f":"(($D$48)*2)*0.1588/100","v":0.29219200000000001},{"$f":"(($D$48)*2)*0.0999/100","v":0.18381599999999998},{"$f":"(($D$48)*2)*0.0628/100","v":0.11555199999999999},{"$f":"(($D$48)*2)*0.0395/100","v":7.2679999999999995E-2},{"$f":"(($D$48)*2)*0.0249/100","v":4.5815999999999996E-2},{"$f":"(($D$48)*2)*0.0156/100","v":2.8704E-2},{"$f":"(($D$48)*2)*0.0098/100","v":1.8031999999999999E-2},{"$f":"(($D$48)*2)*0.0078/100","v":1.4352E-2}]
[null,null,null,null,null,null,"Total Resistance",{"$f":"D51+H45","v":0.29219200000000001},{"$f":"D51+I45","v":0.18381599999999998},{"$f":"D51+J45","v":0.11555199999999999},{"$f":"D51+K45","v":7.2679999999999995E-2},{"$f":"D51+L45","v":4.5815999999999996E-2},{"$f":"D51+M45","v":2.8704E-2},{"$f":"D51+N45","v":1.8031999999999999E-2},{"$f":"D51+O45","v":1.4352E-2}]
[null,null,null,null,null,null,"Power Losses",{"$f":"((($D$27*$I$16)*0.85)^2)*H45","v":43.775504179199999},{"$f":"((($D$27*$I$16)*0.85)^2)*I45","v":27.538871961599998},17.311723315199998,10.888743168,6.8640431615999997,4.3003643904000004,2.7015109632000001,2.1501821952000002]
["Total Wire Length",null,null,{"$f":"IF(H23>0,H23,100)","v":92},null,null,"Percentage",{"$f":"H47/(D26*D27*I18)","v":0.16983047865921788},{"$f":"I47/(D26*D27*I18)","v":0.10683919910614524},{"$f":"J47/(D26*D27*I18)","v":6.7162179217877094E-2},{"$f":"K47/(D26*D27*I18)","v":4.2243727374301675E-2},{"$f":"L47/(D26*D27*I18)","v":2.6629590167597764E-2},{"$f":"M47/(D26*D27*I18)","v":1.6683598659217879E-2},{"$f":"N47/(D26*D27*I18)","v":1.0480722234636872E-2},{"$f":"O47/(D26*D27*I18)","v":8.3417993296089395E-3}]
["Wire Size recommended",null,null,{"$f":"IF(AND(H51=\"Acceptable\",H50<=O33),\"Wire 12\",IF(AND(I50<=O33,I51=\"Acceptable\"),\"Wire 10\",IF(AND(J50<=O33,J51=\"Acceptable\"),\"Wire 8\",IF(AND(K50<=O33,K51=\"Acceptable\"),\"Wire 6\",IF(AND(L50<=O33,L51=\"Acceptable\"),\"Wire 4\",IF(AND(M50<=O33,M51=\"Acceptable\"),\"Wire 2\",IF(AND(N50<=O33,N51=\"Acceptable\"),\"Wire 0\",IF(AND(O50<=O33,O51=\"Acceptable\"),\"Wire 00\",\"None\"))))))))","v":"Wire 4"},"or bigger",null,"Voltage Losses",{"$f":"H45*$D$27*$I$16","v":4.2075648000000001},2.6469503999999997,1.6639487999999998,1.046592,0.65975039999999996,0.41333760000000003,0.25966080000000002,0.20666880000000001]
[null,null,null,null,null,null,"Percentage",{"$f":"((($D$27*$I$16)*H45))/($D$26*$I$14)","v":0.23505948603351959},0.14787432402234638,9.2958033519553063E-2,5.8468826815642458E-2,3.6857564245810055E-2,2.3091486033519557E-2,1.4506189944134081E-2,1.1545743016759778E-2]
[null,null,null,null,null,null,"Current?",{"$f":"IF((I16*D27)>=20,\"Unacceptable\",\"Acceptable\")","v":"Acceptable"},{"$f":"IF((I16*D27)>=30,\"Unaceptable\",\"Acceptable\")","v":"Acceptable"},{"$f":"IF((I16*D27)>=40,\"Unacceptable\",\"Acceptable\")","v":"Acceptable"},{"$f":"IF((I16*D27)>=55,\"Unacceptable\",\"Acceptable\")","v":"Acceptable"},{"$f":"IF((I16*D27)>=70,\"Unacceptable\",\"Acceptable\")","v":"Acceptable"},{"$f":"IF((I16*D27)>=95,\"Unacceptable\",\"Acceptable\")","v":"Acceptable"},{"$f":"IF((I16*D27)>=125,\"Unacceptable\",\"Acceptable\")","v":"Acceptable"},{"$f":"IF((I16*D27)>=165,\"Unacceptable\",\"Acceptable\")","v":"Acceptable"}]

{"sheet":" Design Spec","index":5,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,5],[17,1,17,3],[17,4,17,5],[20,1,20,3],[20,4,20,5],[11,0,16,0],[6,0,7,0],[6,3,7,3],[6,5,7,5],[1,0,1,5]]}
["Design Specification Summary  (estimated 2012 dollar amounts)"]
[]
["Item","Description",null,"Quantity","~","Price"]
["Charge Controller",{"$f":"'Battery Bank'!E14","v":12},"V",1,null,{"$f":"200*D4","v":200}]
["PV Solar Module(s) with j/box ","with a chosen wattage size of",{"$f":"'Array Sizing'!D25","v":65},{"$f":"'Array Sizing'!I18","v":4},null,{"$f":"2.5*C5*D5","v":650}]
["Fixed PV Rack System",null,null,1,null,{"$f":"IF(D5=1,250,IF(D5=2, 300,IF(D5=3,550,IF(D5=4,800,1000))))*D6","v":800}]
["Batteries",{"$f":"'Battery Bank'!E25","v":100},"A/H",{"$f":"'Battery Bank'!E32","v":3},null,{"$f":"B7*B8*D7*0.2","v":720}]
[null,{"$f":"'Battery Bank'!E24","v":12},"V"]
[{"$f":"IF('Array Sizing'!M31=\"Wire 12\",\"#12 UF wire\",IF('Array Sizing'!M31=\"Wire 10\",\"#10 UF wire\",IF('Array Sizing'!M31=\"Wire 8\",\"#8 UF wire\",IF('Array Sizing'!M31=\"Wire 6\",\"#6 UF wire\",IF('Array Sizing'!M31=\"Wire 4\",\"#4 UF wire\",IF('Array Sizing'!M31=\"Wire 2\",\"#2 UF wire\",IF('Array Sizing'!M31=\"Wire 0\",\"#0 UF wire\",IF('Array Sizing'!M31=\"Wire 00\",\"#00 UF wire\",\"Wire\"))))))))","v":"#4 UF wire"},"AWG sized wire for PV pump",null,{"$f":"'Array Sizing'!$D$48*1.25","v":115},"ft",{"$f":"IF(D9<250,200,400)","v":200}]
["Solid copper ground rod",null,null,8,"ft",25]
["Fuse Breaker","Minimum amperage",{"$f":"'Array Sizing'!H27","v":23},3,null,{"$f":"15*D11","v":45}]
["Lights","40 W                 (450 Lumens)",{"$f":"Lights!K4","v":"Halogen"},{"$f":"Lights!J4","v":1},null,{"$f":"ROUNDUP(IF(C12=\"LED\",30,IF(C12=\"Fluorescent\",15,IF(C12=\"Halogen\",7,IF(C12=\"Incandescent\",0.6,0))))*D12,0)","v":7}]
[null,"50 W                (600 Lumens)",{"$f":"Lights!K5","v":"Fluorescent"},{"$f":"Lights!J5","v":1},null,{"$f":"ROUNDUP(IF(C13=\"LED\",30,IF(C13=\"Fluorescent\",15,IF(C13=\"Halogen\",7,IF(C13=\"Incandescent\",0.6,0))))*D13,0)","v":15}]
[null,"60 W                (800 Lumens)",{"$f":"Lights!K6","v":"Incandescent"},{"$f":"Lights!J6","v":0},null,0]
[null,"75 W                (1100 Lumens)",{"$f":"Lights!K7","v":"LED"},{"$f":"Lights!J7","v":1},null,30]
[null,"100 W              (1600 Lumens)",{"$f":"Lights!K8","v":"Incandescent"},{"$f":"Lights!J8","v":0},null,0]
[null,"150 W              (2600 Lumens)",{"$f":"Lights!K9","v":"LED"},{"$f":"Lights!J9","v":0},null,0]
[{"$f":"TODAY()","v":"2014-08-26"},"Grand Total of the System",null,null,{"$f":"SUM(F4:F17)","v":2692}]
["Federal tax credits (as of 2012)",null,0.3]
["State tax credits average about 10% ",null,0.1]
["You may go to the Conclusion sheet for an example picture","Grand Total of the System with tax credits",null,null,{"$f":"E18*(1-(C19+C20))","v":1615.2}]
["For specific state tax credits visit the link:","http://www.dsireusa.org/"]

{"sheet":"Conclusion","index":6,"n_rows":31,"n_cols":1,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,12],[28,7,28,8],[27,0,27,3],[27,7,27,8],[28,0,28,3]]}
["Simplified sketch of an example system (not your specs)"]
["Before exiting, print any sheets that you will need. Contact your county Extension agent if you have any questions (http://aces.nmsu.edu/county/)."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Ref: Home Power Magazine."]