{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Title Page","Solar Resource","Daily Water Requirement","Total Dynamic Head","Pump Selection","Array Sizing"," Design Spec","Conclusion"],"not_rendered":{"charts":7,"images":13,"macros":1,"external_links":0,"defined_names":5,"comments":6,"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":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":false,"merged":[[28,2,28,7],[11,2,11,11],[13,2,13,10],[14,2,14,10],[12,2,12,10],[26,2,26,12]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Solar Water Pumping 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-01-29"}]
[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,"Cooperative Extension Service:                                                     http://extension.nmsu.edu/"]
[null,null,"New Mexico Space Grant Consortium (NMSGC):                        http://www.nmspacegrant.com/"]
[null,null,"Southwest Technology Development Institute (SWTDI)                 http://www.nmsu.edu/~tdi/"]
[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,"Please watch a simple video on solar pumps at:"]
[null,null,"http://www.youtube.com/watch?v=4gFbCdHle0w&list=PL89870B418A514D27&index=10&feature=plpp_video  "]
[null,null,"See more energy related videos at:"]
[null,null,"http://www.youtube.com/playlist?list=PL89870B418A514D27  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["http://www.youtube.com/watch?v=4gFbCdHle0w&list=PL89870B418A514D27&index=10&feature=plpp_video  "]
["http://www.youtube.com/playlist?list=PL89870B418A514D27  "]

{"sheet":"Solar Resource","index":1,"n_rows":238,"n_cols":37,"rows_kept":238,"cut":false,"hidden":false,"merged":[[17,11,19,13],[50,11,52,13],[83,11,85,13],[116,11,118,13],[149,11,151,13],[48,1,49,8],[81,1,82,8],[114,1,115,8],[147,1,148,8],[127,1,132,8],[105,1,111,8],[28,1,32,8],[33,1,38,8],[39,1,42,8],[43,1,45,8],[15,1,16,8],[170,0,174,0],[170,9,174,9],[153,0,156,0],[153,9,156,9],[157,0,160,0],[157,9,160,9],[153,1,156,8],[157,1,160,8],[133,0,138,0],[133,9,138,9],[139,0,144,0],[139,9,144,9],[133,1,138,8],[139,1,144,8],[122,0,126,0],[122,9,126,9],[127,0,132,0],[127,9,132,9],[122,1,126,8],[105,0,111,0],[105,9,111,9],[92,1,98,8],[99,1,104,8],[175,0,177,0],[175,9,177,9],[170,1,174,8],[175,1,177,8],[161,0,164,0],[161,9,164,9],[165,0,169,0],[165,9,169,9],[161,1,164,8],[165,1,169,8],[92,0,98,0],[92,9,98,9],[99,0,104,0],[99,9,104,9],[76,0,78,0],[76,9,78,9],[50,1,54,8],[55,1,58,8],[59,1,64,8],[65,1,70,8],[71,1,75,8],[76,1,78,8],[65,0,70,0],[65,9,70,9],[71,0,75,0],[71,9,75,9],[55,0,58,0],[55,9,58,9],[59,0,64,0],[59,9,64,9],[50,0,54,0],[50,9,54,9],[33,0,38,0],[33,9,38,9],[39,0,42,0],[39,9,42,9],[17,0,20,0],[17,9,20,9],[21,0,27,0],[21,9,27,9],[28,0,32,0],[28,9,32,9],[189,9,195,9],[189,0,195,0],[189,1,195,8],[180,1,181,8],[182,0,188,0],[182,1,188,8],[182,9,188,9],[0,0,0,14],[7,16,8,18],[2,0,7,7],[12,0,13,14],[10,0,10,14],[11,0,11,14],[1,0,1,7],[8,0,9,7],[8,8,8,9],[5,10,5,11],[7,12,8,14],[2,12,3,14],[4,12,5,14],[43,0,45,0],[43,9,45,9],[17,1,20,8],[21,1,27,8],[226,9,231,9],[232,0,236,0],[232,1,236,8],[232,9,236,9],[213,1,214,8],[215,9,220,9],[215,1,220,8],[215,0,220,0],[196,0,202,0],[237,0,240,0],[237,1,240,8],[237,9,240,9],[182,11,184,13],[215,11,217,13],[83,1,91,8],[83,0,91,0],[83,9,91,9],[149,9,152,9],[149,1,152,8],[149,0,152,0],[116,0,121,0],[116,1,121,8],[116,9,121,9],[203,9,210,9],[203,1,210,8],[203,0,210,0],[196,9,202,9],[196,1,202,8],[221,0,225,0],[221,1,225,8],[221,9,225,9],[226,0,231,0],[226,1,231,8]]}
["Solar Resource: The average amount of sun light 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, WY, MT) using the drop-down menu.",null,null,null,null,null,null,null,null,null,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,{"$f":"IF(OR($M$8=\"New Mexico\",$M$8=\"Arizona\"),1.018,0.018)","v":1.018},{"$f":"INDEX($AI$2:$AI$19,MATCH(LARGE($AJ$2:$AJ$19,1),$AJ$2:$AJ$19,0))","v":31}]
["Next: Enter the \"Latitude\" of the location where you plan to put your solar well using the state's reference map below and the drop-down menu. Click on the \"Time Period\" green cell to get a menu for the part of year you will be grazing - choose \"Summer\" for ONLY summer watering, \"Winter\" or \"All-Year\" - see *NOTE1 below. The next green cell \"Tracker or Tilt Angles\" allows you to choose the angle at which the solar panels will  be tilted - see *NOTE2.",null,null,null,null,null,null,null,"Latitude",null,34,null,"Select your",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Mexico","Winter","Latitude",{"$f":"IF(K4=\"Summer\",4,3)","v":3},null,null,32,{"$f":"IF(OR($M$8=\"New Mexico\",$M$8=\"Arizona\"),1.017,0.017)","v":1.0169999999999999},{"$f":"INDEX($AI$2:$AI$19,MATCH(LARGE($AJ$2:$AJ$19,2),$AJ$2:$AJ$19,0))","v":32}]
[null,null,null,null,null,null,null,null,"Time Period*",null,"All Year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Arizona","Summer","1-Axis Tracker",{"$f":"IF(K4=\"Summer\",6,5)","v":5},null,null,33,{"$f":"IF(OR($M$8=\"New Mexico\",$M$8=\"Arizona\"),1.016,0.016)","v":1.016},{"$f":"INDEX($AI$2:$AI$19,MATCH(LARGE($AJ$2:$AJ$19,3),$AJ$2:$AJ$19,0))","v":33}]
[null,null,null,null,null,null,null,null,null,null,null,null,"State:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Colorado","All Year","+/- 15°",{"$f":"IF(K4=\"Summer\",2,1)","v":1},null,null,34,{"$f":"IF(OR($M$8=\"New Mexico\",$M$8=\"Arizona\"),1.015,0.015)","v":1.0149999999999999},{"$f":"INDEX($AI$2:$AI$19,MATCH(LARGE($AJ$2:$AJ$19,4),$AJ$2:$AJ$19,0))","v":34}]
[null,null,null,null,null,null,null,null,"Tracker or Tilt Angles",null,"+/- 15°",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$8=\"New Mexico\",$M$8=\"Arizona\",$M$8=\"Nevada\"),1.014,0.014)","v":1.014},{"$f":"INDEX($AI$2:$AI$19,MATCH(LARGE($AJ$2:$AJ$19,5),$AJ$2:$AJ$19,0))","v":35}]
[null,null,null,null,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$8=\"New Mexico\",$M$8=\"Arizona\",$M$8=\"Nevada\"),1.013,0.013)","v":1.0129999999999999},{"$f":"INDEX($AI$2:$AI$19,MATCH(LARGE($AJ$2:$AJ$19,6),$AJ$2:$AJ$19,0))","v":36}]
[null,null,null,null,null,null,null,null,"Insolation at given latitude",null,{"$f":"IFERROR(IF(M8=\"New Mexico\",INDEX(AD26:AI31,MATCH(K3,AC26:AC31,0),AF8),IF(M8=\"Arizona\",INDEX(AD62:AI68,MATCH(K3,AC62:AC68,0),AF8),IF(M8=\"Colorado\",INDEX(AD91:AI95,MATCH(K3,AC91:AC95,0),AF8),IF(M8=\"Utah\",INDEX(AD126:AI131,MATCH(K3,AC126:AC131,0),AF8),IF(M8=\"Nevada\",INDEX(AD155:AI162,MATCH(K3,AC155:AC162,0),AF8),IF(M8=\"Wyoming\",INDEX(AE189:AJ192,MATCH(K3,AD189:AD192,0),AF8),IF(M8=\"Montana\",INDEX(AE221:AJ225,MATCH(K3,AD221:AD225,0),AF8)))))))),0)","v":5.53},"kWh/day","New Mexico",null,null,null,{"$f":"IF(INDEX(AJ2:AJ19,MATCH(K3,AI2:AI19,0))<1,AC1,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"Wyoming",{"$f":"IF(K4=\"Summer\",1,0)","v":0},{"$f":"IF(K6=\"Latitude\",3,IF(K6=\"1-Axis Tracker\",5,0))","v":0},{"$f":"IF(SUM(AD8:AE8)=0,1,IF(SUM(AD8:AE8)=1,2,SUM(AD8:AE8)))","v":1},null,null,37,{"$f":"IF(OR($M$8=\"Utah\",$M$8=\"Colorado\",$M$8=\"Nevada\"),1.012,0.012)","v":1.2E-2},{"$f":"INDEX($AI$2:$AI$19,MATCH(LARGE($AJ$2:$AJ$19,7),$AJ$2:$AJ$19,0))","v":37}]
["Step 2:  Once Total Daily Insolation is calculated, move on to the next sheet titled Daily Water Requirement.",null,null,null,null,null,null,null,"Total Daily Insolation",null,{"$f":"$K$8","v":5.53},"kWh/day",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Montana",null,null,null,null,null,38,{"$f":"IF(OR($M$8=\"Utah\",$M$8=\"Colorado\",$M$8=\"Nevada\"),1.011,0.011)","v":1.0999999999999999E-2},{"$f":"INDEX($AI$2:$AI$19,MATCH(LARGE($AJ$2:$AJ$19,8),$AJ$2:$AJ$19,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$8=\"Utah\",$M$8=\"Colorado\",$M$8=\"Nevada\"),1.01,0.01)","v":0.01},{"$f":"INDEX($AI$2:$AI$19,MATCH(LARGE($AJ$2:$AJ$19,9),$AJ$2:$AJ$19,0))","v":39}]
["*NOTE1: Use the drop-down menu to choose Summer, Winter, or All Year. A \"Winter\" entry provides the most conservative solar numbers.",null,null,null,null,null,null,null,null,null,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$8=\"Utah\",$M$8=\"Colorado\",$M$8=\"Nevada\"),1.009,0.009)","v":8.9999999999999993E-3},{"$f":"INDEX($AI$2:$AI$19,MATCH(LARGE($AJ$2:$AJ$19,10),$AJ$2:$AJ$19,0))","v":40}]
["Choose Summer if you are only pumping during the summer months. Typically summer values are 20-35% different than winter values.",null,null,null,null,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(K6=\"Latitude\",3,IF(K6=\"1-Axis Tracker\",5,1))","v":1},{"$f":"IFERROR(IF(M8=\"New Mexico\",INDEX(AD26:AI31,MATCH(K3,AC26:AC31,0),AE12),IF(M8=\"Arizona\",INDEX(AD62:AI68,MATCH(K3,AC62:AC68,0),AE12),IF(M8=\"Colorado\",INDEX(AD91:AI95,MATCH(K3,AC91:AC95,0),AE12),IF(M8=\"Utah\",INDEX(AD126:AI131,MATCH(K3,AC126:AC131,0),AE12),IF(M8=\"Nevada\",INDEX(AD155:AI162,MATCH(K3,AC155:AC162,0),AE12)))))),0)","v":5.53},null,null,41,{"$f":"IF(OR($M$8=\"Utah\",$M$8=\"Nevada\",$M$8=\"Wyoming\"),1.008,0.008)","v":8.0000000000000002E-3},{"$f":"INDEX($AI$2:$AI$19,MATCH(LARGE($AJ$2:$AJ$19,11),$AJ$2:$AJ$19,0))","v":41}]
["*NOTE2: Enter \"Latitude\" if you plan to tilt the PV panels at a fixed angle equal to the latitude of your location. Enter \"+/- 15°\" if you plan to change tilt angles based on winter or summer seasons (Lat+15° for Winter and Lat-15° for Summer). Enter \"1-Axis Tracker\" if you plan to use a 1-axis tracker. See user manual for more discussion.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"summer",{"$f":"IF(K6=\"Latitude\",4,IF(K6=\"1-Axis Tracker\",6,2))","v":2},{"$f":"IFERROR(IF(M8=\"New Mexico\",INDEX(AD26:AI31,MATCH(K3,AC26:AC31,0),AE13),IF(M8=\"Arizona\",INDEX(AD62:AI68,MATCH(K3,AC62:AC68,0),AE13),IF(M8=\"Colorado\",INDEX(AD91:AI95,MATCH(K3,AC91:AC95,0),AE13),IF(M8=\"Utah\",INDEX(AD126:AI131,MATCH(K3,AC126:AC131,0),AE13),IF(M8=\"Nevada\",INDEX(AD155:AI162,MATCH(K3,AC155:AC162,0),AE13)))))),0)","v":6.55},null,null,42,{"$f":"IF($M$8=\"Wyoming\",1.007,0.007)","v":7.0000000000000001E-3},{"$f":"INDEX($AI$2:$AI$19,MATCH(LARGE($AJ$2:$AJ$19,12),$AJ$2:$AJ$19,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,43,{"$f":"IF($M$8=\"Wyoming\",1.006,0.006)","v":6.0000000000000001E-3},{"$f":"INDEX($AI$2:$AI$19,MATCH(LARGE($AJ$2:$AJ$19,13),$AJ$2:$AJ$19,0))","v":43}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,{"$f":"IF(OR($M$8=\"Wyoming\",$M$8=\"Montana\"),1.005,0.005)","v":5.0000000000000001E-3},{"$f":"INDEX($AI$2:$AI$19,MATCH(LARGE($AJ$2:$AJ$19,14),$AJ$2:$AJ$19,0))","v":44}]
[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,null,null,null,null,null,null,45,{"$f":"IF($M$8=\"Montana\",1.004,0.004)","v":4.0000000000000001E-3},{"$f":"INDEX($AI$2:$AI$19,MATCH(LARGE($AJ$2:$AJ$19,15),$AJ$2:$AJ$19,0))","v":45}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,{"$f":"IF($M$8=\"Montana\",1.003,0.003)","v":3.0000000000000001E-3},{"$f":"INDEX($AI$2:$AI$19,MATCH(LARGE($AJ$2:$AJ$19,16),$AJ$2:$AJ$19,0))","v":46}]
[36,36,null,null,null,null,null,null,null,36,null,{"$f":"IF(INDEX(AJ2:AJ19,MATCH(K3,AI2:AI19,0))<1,AC1,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,{"$f":"IF($M$8=\"Montana\",1.002,0.002)","v":2E-3},{"$f":"INDEX($AI$2:$AI$19,MATCH(LARGE($AJ$2:$AJ$19,17),$AJ$2:$AJ$19,0))","v":47}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,{"$f":"IF($M$8=\"Montana\",1.001,0.001)","v":1E-3},{"$f":"INDEX($AI$2:$AI$19,MATCH(LARGE($AJ$2:$AJ$19,18),$AJ$2:$AJ$19,0))","v":48}]
[]
[null,null,null,null,null,null,null,null,null,null,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:AJ19,\"<1\")","v":12}]
[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,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,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]
[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,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]
[null,null,null,null,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.6,6.55,5.0999999999999996,6.75,6.2,9.0500000000000007]
[]
[]
[33,33,null,null,null,null,null,null,null,33]
[]
[]
[]
[]
[]
[32,32,null,null,null,null,null,null,null,32]
[]
[]
[]
[31,31,null,null,null,null,null,null,null,31]
[]
[]
[]
[]
[null,"ARIZONA"]
[]
[36,36,null,null,null,null,null,null,null,36,null,{"$f":"IF(INDEX(AJ2:AJ19,MATCH(K3,AI2:AI19,0))<1,AC1,\"\")","v":""}]
[]
[]
[]
[]
[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,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,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]
[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,35,5.37,7,4.9000000000000004,7.13,5.87,9.6300000000000008]
[null,null,null,null,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.13,6.92,4.67,7.02,5.6,9.57]
[]
[]
[]
[32,32,null,null,null,null,null,null,null,32]
[]
[]
[]
[]
[31,31,null,null,null,null,null,null,null,31]
[]
[]
[]
[]
[null,"COLORADO"]
[]
[40,40,null,null,null,null,null,null,null,40,null,{"$f":"IF(INDEX(AJ2:AJ19,MATCH(K3,AI2:AI19,0))<1,AC1,\"\")","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,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]
[39,39,null,null,null,null,null,null,null,39,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]
[null,null,null,null,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.43,5.97,4.13,6.07,4.8,8.0299999999999994]
[]
[]
[]
[]
[38,38,null,null,null,null,null,null,null,38]
[]
[]
[]
[]
[]
[37,37,null,null,null,null,null,null,null,37]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"UTAH"]
[]
[41,41,null,null,null,null,null,null,null,41,null,{"$f":"IF(INDEX(AJ2:AJ19,MATCH(K3,AI2:AI19,0))<1,AC1,\"\")","v":""}]
[]
[]
[]
[]
[]
[40,40,null,null,null,null,null,null,null,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,"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]
[39,39,null,null,null,null,null,null,null,39,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]
[]
[]
[38,38,null,null,null,null,null,null,null,38]
[]
[]
[]
[]
[]
[37,37,null,null,null,null,null,null,null,37]
[]
[]
[]
[]
[]
[]
[]
[null,"NEVADA"]
[]
[41,41,null,null,null,null,null,null,null,41,null,{"$f":"IF(INDEX(AJ2:AJ19,MATCH(K3,AI2:AI19,0))<1,AC1,\"\")","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,null,null,null,null,null,"Adjusting tilt +/- 15",null,"Fixed at latitude",null,"1-Axis tracker"]
[40,40,null,null,null,null,null,null,null,40,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]
[39,39,null,null,null,null,null,null,null,39,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]
[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,42,3.31,6.38,3.06,6.51,3.53,8.86]
[]
[]
[]
[37,37,null,null,null,null,null,null,null,37]
[]
[]
[]
[]
[36,36,null,null,null,null,null,null,null,36]
[]
[]
[]
[]
[35,35,null,null,null,null,null,null,null,35]
[]
[]
[]
[]
[null,"WYOMING"]
[]
[44,44,null,null,null,null,null,null,null,44,null,{"$f":"IF(INDEX(AJ2:AJ19,MATCH(K3,AI2:AI19,0))<1,AC1,\"\")","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,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,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,null,41,4.05,6.1,3.78,6.2,4.3499999999999996,8.2799999999999994]
[43,43,null,null,null,null,null,null,null,43,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,4.3,6.1,4,6.2,4.5999999999999996,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,null,43,4.05,5.95,3.77,5.98,4.33,8.07]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,3.8,5.8,3.53,5.85,4.07,7.83]
[]
[]
[]
[]
[42,42,null,null,null,null,null,null,null,42]
[]
[]
[]
[]
[]
[]
[41,41,null,null,null,null,null,null,null,41]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"MONTANA"]
[]
[48,48,null,null,null,null,null,null,null,48,null,{"$f":"IF(INDEX(AJ2:AJ19,MATCH(K3,AI2:AI19,0))<1,AC1,\"\")","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,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,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,null,44,3.8,5.8,3.53,5.85,4.07,7.83]
[47,47,null,null,null,null,null,null,null,47,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,3.55,5.65,3.3,5.71,3.8,7.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,3.3,5.5,3.07,5.57,3.53,7.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,3.05,5.35,2.83,5.44,3.27,7.13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,2.8,5.2,2.6,5.3,3,6.9]
[]
[46,46,null,null,null,null,null,null,null,46]
[]
[]
[]
[]
[]
[45,45,null,null,null,null,null,null,null,45]
[]
[]
[]
[]
[44,44,null,null,null,null,null,null,null,44]

{"sheet":"Daily Water Requirement","index":2,"n_rows":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":false,"merged":[[35,9,36,14],[13,0,14,8],[0,0,0,9],[30,9,30,12],[27,9,27,12],[1,0,4,8],[5,0,7,8],[8,0,10,8],[11,0,12,8],[15,0,15,6],[15,7,15,8],[1,9,1,14],[24,9,24,10],[28,9,28,10],[32,9,33,14]]}
["Daily Water Requirement and Storage for",null,null,null,null,null,null,null,null,null,{"$f":"H17","v":"All Year"},"Watering"]
["Step 3: Enter the number of each animal that needs water in the green cells to the right under the heading Quantity. If you have any other daily water requirements, you can enter that value in the Other Water Requirements cell. You can change the animal water requirement values in the green cells below. Use the values in the grey cells below as a guide.",null,null,null,null,null,null,null,null,"Water Requirements"]
[null,null,null,null,null,null,null,null,null,"Animal",null,null,"Quantity","Gallons/Day"]
[null,null,null,null,null,null,null,null,null,"Nursing Cows",null,null,0,{"$f":"$M$4*E18","v":0}]
[null,null,null,null,null,null,null,null,null,"Bred Dry Cows & Heifers",null,null,0,{"$f":"$M$5*E19","v":0}]
["NOTE: The orange colored cells calculate the daily water requirements for the number of each animal entered (gallons per day). The highlighted cells in yellow at the bottom gives your Total Daily Water Requirement.  ",null,null,null,null,null,null,null,null,"Bulls",null,null,5,{"$f":"$M$6*E20","v":100}]
[null,null,null,null,null,null,null,null,null,"Growing Cattle"]
[null,null,null,null,null,null,null,null,null,null,"400 lbs",null,4,{"$f":"$M$8*E22","v":40}]
["Step 4:  In PV pumping systems it is important to have water storage for times of low light conditions, nights, cloudy days, etc. Enter a value for the amount of storage you need in days. This is used to find the size of a storage tank you will need. For NM, a standard value is three (3) days.",null,null,null,null,null,null,null,null,null,"600 lbs",null,5,{"$f":"$M$9*E23","v":65}]
[null,null,null,null,null,null,null,null,null,null,"800 lbs",null,5,{"$f":"$M$10*E24","v":75}]
[null,null,null,null,null,null,null,null,null,"Finishing Cattle"]
["Step 5:  After getting the Total Daily Water Requirement, move on to the next sheet titled Total Dynamic Head by clicking that sheet's tab on the bottom of this page.",null,null,null,null,null,null,null,null,null,"400 lbs",null,2,{"$f":"$M$12*E26","v":34}]
[null,null,null,null,null,null,null,null,null,null,"600 lbs",null,5,{"$f":"$M$13*E27","v":100}]
["The following is typical gallons/day water requirement (grey cells) for a single animal based upon your seasonal choice. The user may change these values (in green) but it is not recommended. ",null,null,null,null,null,null,null,null,null,"800 lbs",null,6,{"$f":"$M$14*E28","v":132}]
[null,null,null,null,null,null,null,null,null,null,"1200 lbs",null,2,{"$f":"$M$15*E29","v":50}]
["Typical water requirement for this region",null,null,null,null,null,null,"Gallons/day",null,"Horses",null,null,6,{"$f":"$M$16*E30","v":90}]
[null,null,null,null,null,null,null,{"$f":"'Solar Resource'!K4","v":"All Year"},"Typical","Sheeps and Goats",null,null,8,{"$f":"$M$17*E31","v":32}]
["Nursing Cows",null,null,null,{"$f":"H18","v":20},"gallons/day",null,{"$f":"IF($H$17=\"Summer\",20,IF($H$17=\"Winter\",15,20))","v":20},"15-20","Hogs",null,null,3,{"$f":"$M$18*E32","v":15}]
["Bred Dry Cows and Heifers",null,null,null,{"$f":"H19","v":18},null,null,{"$f":"IF($H$17=\"Summer\",18,IF($H$17=\"Winter\",13,18))","v":18},null,"Human Beings",null,null,20,{"$f":"$M$19*E33","v":2000}]
["Bulls",null,null,null,{"$f":"H20","v":20},null,null,{"$f":"IF($H$17=\"Summer\",20,IF($H$17=\"Winter\",16,20))","v":20},null,"Chickens ",null,null,5,{"$f":"$M$20*E34","v":0.5}]
["Growing Cattle",null,null,null,null,null,null,null,"7-15","Turkeys ",null,null,5,{"$f":"$M$21*E35","v":0.75}]
[null,"400 lbs",null,null,{"$f":"H22","v":10},null,null,{"$f":"IF($H$17=\"Summer\",10,IF($H$17=\"Winter\",7,10))","v":10},null,"Elk",null,null,0,{"$f":"$M$22*E36","v":0}]
[null,"600 lbs",null,null,{"$f":"H23","v":13},null,null,{"$f":"IF($H$17=\"Summer\",13,IF($H$17=\"Winter\",9,13))","v":13},null,"Deer",null,null,0,{"$f":"$M$23*E37","v":0}]
[null,"800 lbs",null,null,{"$f":"H24","v":15},null,null,{"$f":"IF($H$17=\"Summer\",15,IF($H$17=\"Winter\",11,15))","v":15},null,"Other Water Requirements",null,null,0,{"$f":"M24","v":0}]
["Finishing Cattle",null,null,null,null,null,null,null,"15-25","Daily Water Requirement",null,null,null,{"$f":"SUM(N3:N24)","v":2734.25},"gal/day"]
[null,"400 lbs",null,null,{"$f":"H26","v":17},null,null,{"$f":"IF($H$17=\"Summer\",17,IF($H$17=\"Winter\",15,17))","v":17},null,"Multiplier** (additional %)",null,null,0,"%"]
[null,"600 lbs",null,null,20,null,null,{"$f":"IF($H$17=\"Summer\",20,IF($H$17=\"Winter\",15,20))","v":20}]
[null,"800 lbs",null,null,22,null,null,{"$f":"IF($H$17=\"Summer\",22,IF($H$17=\"Winter\",18,22))","v":22},null,"Daily Water Requirement (with multiplier)",null,null,null,{"$f":"N25+N25*(M26/100)","v":2734.25},"gal/day"]
[null,"1200 lbs",null,null,25,null,null,{"$f":"IF($H$17=\"Summer\",25,IF($H$17=\"Winter\",20,25))","v":25},null,"Necessary flow-rate (Q) in gpm",null,{"$f":"ROUNDUP('Daily Water Requirement'!$N$28/('Solar Resource'!$K$9*60),2)","v":8.25},"gpm",{"$f":"$N$28*3.7854","v":10350.229950000001},"L/day"]
["Horses",null,null,null,15,null,null,{"$f":"IF($H$17=\"Summer\",15,IF($H$17=\"Winter\",10,15))","v":15},"8-15","Days of Storage",null,null,3,"Days"]
["Sheeps and Goats",null,null,null,4,null,null,{"$f":"IF($H$17=\"Summer\",4,IF($H$17=\"Winter\",2,4))","v":4},"1-4","Storage Tank Size (recommended)",null,null,null,{"$f":"ROUNDUP(N28*M30,0)","v":8203},"Gallons"]
["Hogs",null,null,null,5,null,null,{"$f":"IF($H$17=\"Summer\",5,IF($H$17=\"Winter\",3,5))","v":5},"3-5"]
["Human Beings",null,null,null,100,null,null,{"$f":"IF($H$17=\"Summer\",100,IF($H$17=\"Winter\",75,100))","v":100},"1-100*","**Multiplier is used to add a percentage of the daily requirement for evaporation and for refilling the storage tank after draw-down days. Valid values are 0-20%. Use 0 if no margin is needed."]
["Chickens - per bird",null,null,null,0.1,null,null,{"$f":"IF($H$17=\"Summer\",0.1,IF($H$17=\"Winter\",0.08,0.1))","v":0.1},"0.08-0.1"]
["Turkeys - per birds",null,null,null,0.15,null,null,{"$f":"IF($H$17=\"Summer\",0.15,IF($H$17=\"Winter\",0.1,0.15))","v":0.15},"0.1 - 0.15"]
["Elk",null,null,null,7,null,null,{"$f":"IF($H$17=\"Summer\",7,IF($H$17=\"Winter\",4,7))","v":7},"4-7","*NOTE: Humans need about a gallon of drinking water per day but may use up to 50-100 gallons per day for cooking, cleaning, showers, etc."]
["Deer",null,null,null,3,null,null,{"$f":"IF($H$17=\"Summer\",3,IF($H$17=\"Winter\",2,3))","v":3},"2-3"]

{"sheet":"Total Dynamic Head","index":3,"n_rows":41,"n_cols":19,"rows_kept":41,"cut":false,"hidden":false,"merged":[[34,0,34,10],[33,0,33,2],[0,0,0,13],[27,0,29,7],[33,8,33,10],[2,0,5,7],[30,8,30,10],[30,0,32,7],[9,11,10,15],[11,12,14,15]]}
["Total Dynamic Head (TDH)"]
[null,null,null,null,null,null,null,null,null,null,null,"Choices for ","Max.","Pipe "]
["Step 6: Using the \"example\" diagram  below, enter your values for well water level and the discharge elevation of your storage tank as well as other information in the green cells to the right. Note the corresponding color coding of diagram parts and their associated table entries to the right.",null,null,null,null,null,null,null,"Water Level",50,"ft","Pipe Sizes (in.)","gpm","Choice"]
[null,null,null,null,null,null,null,null,"Pump Level ",55,"ft",0.5,7,"PVC",null,null,null,{"$f":"IF(OR(L14=\"0.5 in\"),1.006,0.006)","v":6.0000000000000001E-3},{"$f":"INDEX(L4:L9,MATCH(LARGE(R4:R9,1),R4:R9,0))","v":1}]
[null,null,null,null,null,null,null,null,"Discharge Elevation",15,"ft",0.75,11,"Poly",null,null,null,{"$f":"IF(OR(L14=\"0.5 in\",L14=\"0.75 in\"),1.005,0.005)","v":5.0000000000000001E-3},{"$f":"INDEX(L4:L9,MATCH(LARGE(R4:R9,2),R4:R9,0))","v":1.5}]
[null,null,null,null,null,null,null,null,"Distance from well to storage tank",80,"ft",1,16,"Metal ",null,null,null,{"$f":"IF(OR(L14=\"0.5 in\",L14=\"0.75 in\",L14=\"1 in\"),1.004,0.004)","v":1.004},{"$f":"INDEX(L4:L9,MATCH(LARGE(R4:R9,3),R4:R9,0))","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,1.5,35,null,null,null,null,{"$f":"IF(OR(L14=\"0.5 in\",L14=\"0.75 in\",L14=\"1 in\",L14=\"1.5 in\"),1.003,0.003)","v":1.0029999999999999},{"$f":"INDEX(L4:L9,MATCH(LARGE(R4:R9,4),R4:R9,0))","v":3}]
[null,null,null,null,null,null,null,null,"Total Vertical Lift (Static Head)",{"$f":"SUM(J4,J5)","v":70},"ft",2,55,null,null,null,null,{"$f":"IF(OR(L14=\"0.5 in\",L14=\"0.75 in\",L14=\"1 in\",L14=\"1.5 in\",L14=\"2 in\"),1.002,0.002)","v":1.002},{"$f":"INDEX(L4:L9,MATCH(LARGE(R4:R9,5),R4:R9,0))","v":0.5}]
[null,null,null,null,null,null,null,null,null,null,null,3,140,null,null,null,null,{"$f":"IF(OR(L14=\"0.5 in\",L14=\"0.75 in\",L14=\"1 in\",L14=\"1.5 in\",L14=\"2 in\",L14=\"3 in\"),1.001,0.001)","v":1.0009999999999999},{"$f":"INDEX(L4:L9,MATCH(LARGE(R4:R9,6),R4:R9,0))","v":0.75}]
[null,null,null,null,null,null,null,null,"Total Length of  Pipe",{"$f":"$J$6+$J$5+$J$4","v":150},"ft",{"$f":"IF(INDEX(R4:R9,MATCH(J12,L4:L9,0))<1,A40,\"\")","v":""},null,null,null,null,null,{"$f":"COUNTIF(R4:R9,\"<1\")","v":2}]
[]
[null,null,null,null,null,null,null,null,"Nominal Pipe Diameter (inches)",1,"in","Recommended",{"$f":"IF(J3>=J4,A41,\"\")","v":""}]
[null,null,null,null,null,null,null,null,"Type of Pipe","PVC",{"$f":"IF(J13=\"PVC\", 150, (IF(J13=\"Poly\", 140,135)))","v":150},"Pipe Size"]
[null,null,null,null,null,null,null,null,"Friction Losses Due to Pipe",{"$f":"(10.472/(K13^1.852))*((('Pump Selection'!$T$2^1.852)/('Total Dynamic Head'!$J$12^4.871))*'Total Dynamic Head'!$J$10)","v":7.3812940697989147},"ft",{"$f":"IF('Pump Selection'!$T$2<=1.5,\"0.5 in\",IF('Pump Selection'!$T$2<=4.8,\"0.75 in\",IF('Pump Selection'!$T$2<=14,\"1 in\",IF('Pump Selection'!$T$2<=35,\"1.5 in\",IF('Pump Selection'!$T$2<=55,\"2 in\",\"3 in\")))))","v":"1 in"}]
[]
[null,null,null,null,null,null,null,null,"Fittings"," Quantity",null,"Equivalent Length"]
[]
[null,null,null,null,null,null,null,null,"Globe Valve, Fully Open",1,null,{"$f":"($J$12*$J$18*275)/12","v":22.916666666666668}]
[null,null,null,null,null,null,null,null,"Gate Valve, Fully Open",1,null,{"$f":"($J$12*$J$19*9)/12","v":0.75}]
[null,null,null,null,null,null,null,null,"Gate Valve, 3/4 Open",0,null,{"$f":"($J$12*$J$20*35)/12","v":0}]
[null,null,null,null,null,null,null,null,"Gate Valve, 1/2 Open",0,null,{"$f":"($J$12*$J$21*160)/12","v":0}]
[null,null,null,null,null,null,null,null,"Butterfly Valve",0,null,{"$f":"($J$12*$J$22*120)/12","v":0}]
[null,null,null,null,null,null,null,null,"Swing Check Valve, Fully Open",1,null,{"$f":"($J$12*$J$23*135)/12","v":11.25}]
[null,null,null,null,null,null,null,null,"In-Line Ball Check Valve, Fully Open",0,null,{"$f":"($J$12*$J$24*150)/12","v":0}]
[null,null,null,null,null,null,null,null,"90 Degree Standard Elbow",1,null,{"$f":"($J$12*$J$25*30)/12","v":2.5}]
[null,null,null,null,{"$f":"IF('Total Dynamic Head'!$D$34>1500,\"see note below\",\"\")","v":""},null,null,null,"45 Degree Standard Elbow",0,null,{"$f":"($J$12*$J$26*16)/12","v":0}]
[null,null,null,null,null,null,null,null,"90 Degree Street Elbow",0,null,{"$f":"($J$12*$J$27*50)/12","v":0}]
["Step 7: After completing this sheet and finding the value for the Total Dynamic Head of your system you can move on to the next sheet titled Pump Selection.",null,null,null,null,null,null,null,"Standard Tee, Flow Through Run",0,null,{"$f":"($J$12*$J$28*16)/12","v":0}]
[null,null,null,null,null,null,null,null,"Standard Tee, Flow Through Branch",0,null,{"$f":"($J$12*$J$29*60)/12","v":0}]
[]
["*In the above example, the \"Water Level \" is 145', the pump is 5' under the water level, discharge \"Elevation\" is 10', horizontal pipe run is 80', there is one Globe Valve, one Swing Check Value, and three 90 degree Elbows.",null,null,null,null,null,null,null,"Friction Loss Due to Fittings",null,null,{"$f":"SUM(L18:L29)","v":37.416666666666671},"ft"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"$L$34*0.3048","v":35.052},"m"]
["Hydraulic Workload (m4)**",null,null,{"$f":"$L$33*('Daily Water Requirement'!$N$29/1000)","v":362.79626020740005},null,null,null,null,"Total Dynamic Head (TDH)",null,null,{"$f":"ROUNDUP($J$8+$J$14+$L$31,0)","v":115},"ft"]
["**NOTE: If the above Hydraulic Workload value is greater than 1500, then solar may not be a good choice - see manual for discussion.",null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L34*0.433,0)","v":50},"psi"]
[]
[]
[]
[]
["The pipe size selected does not match the requirements of the system."]
["The pump is not under water at this level. Correct the Water level and Pump level entries."]

{"sheet":"Pump Selection","index":4,"n_rows":186,"n_cols":108,"rows_kept":186,"cut":false,"hidden":false,"merged":[[32,0,32,14],[29,0,29,14],[30,0,30,14],[29,20,29,25],[15,0,15,3],[16,15,16,18],[15,15,15,18],[16,0,16,3],[31,0,31,14],[17,15,17,18],[27,19,27,26],[27,0,27,14],[28,0,28,14],[20,8,20,13],[18,8,18,13],[22,8,22,13],[18,0,18,3],[0,32,0,55],[9,15,9,20],[1,0,6,13],[1,15,1,18],[3,15,3,18],[2,15,2,19],[0,0,0,19],[0,20,0,30],[4,96,5,96],[6,96,12,96],[11,0,12,13],[14,8,14,13],[6,21,8,26],[7,0,9,13],[7,15,7,18],[6,15,6,18],[14,0,14,3]]}
["Pump Selection",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"       Go back to start!",null,null,null,null,null,null,null,null,null,null,null,"Go back to start!"]
["Step 8: In this step you will select a solar pump for the calculated Q and TDH values shown in the yellow cells to the right.  Every pump has certain limits of Q and TDH which are defined by the manufacturer - often in what's called a pump curve. You must select a pump that falls within these limits, try to maximize its efficiency, and determine its operating voltage and the PV power needed to run it. Using an example manufacturer (SUN PUMPS) and a small set of 1HP (or less) pumps,  the system will recommend the best pump (from the example pumps curve data). The user may use this same technique to select another pump, different type or manufacturer - see user manual for more discussion.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flow Rate (Q)",null,null,null,{"$f":"ROUNDUP('Daily Water Requirement'!$N$28/('Solar Resource'!$K$9*60),1)","v":8.2999999999999989},"gpm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sorted"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Dynamic Head (TDH)",null,null,null,{"$f":"'Total Dynamic Head'!$L$34","v":115},"ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pump","W","V","I",null,"SDS-T-128",{"$f":"IF(AND($CI$10=0,CI9=0),0.00013,1.00013)","v":1.2999999999999999E-4},{"$f":"INDEX(CZ4:CZ18,MATCH(LARGE($DA$4:$DA$18,1),$DA$4:$DA$18,0))","v":"SCS-18-160"},null,{"$f":"IF(INDEX(DA4:DA18,MATCH(T16,CZ4:CZ18,0))=0,A184,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T4*0.3048","v":35.052},"m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCS-8-90",{"$f":"IF(AND($CI$34=0,$CI$46=0),0.00009,1.00009)","v":9.0000000000000006E-5},{"$f":"INDEX(CZ4:CZ18,MATCH(LARGE($DA$4:$DA$18,2),$DA$4:$DA$18,0))","v":"SCS-10-230"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCS-6-185",{"$f":"IF(AND($CI$58=0,$CI$70=0,$CI$82=0,$CI$94=0,$CI$105=0),0.00006,1.00006)","v":6.0000000000000002E-5},{"$f":"INDEX(CZ4:CZ18,MATCH(LARGE($DA$4:$DA$18,3),$DA$4:$DA$18,0))","v":"SCS-30-115"},"SDS-T-128"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Preferred SCS Pump Choice",null,null,null,{"$f":"U31","v":"18-160"},null,{"$f":"IF(AND(CI108=0,CI107=0,CI106=0,CI105=0,CI104=0,CI99=0,CI98=0,CI97=0,CI96=0,CI95=0,CI94=0,CI93=0,CI92=0),A182,\"\")","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCS","At 30 V",{"$f":"CQ38","v":"None"},{"$f":"IF(CU7<>\"None\",(SMALL(CK30:CK37,COUNTIF(CK30:CK37,0)+1)),0)","v":0},{"$f":"IF(CU7<>\"None\",30,0)","v":0},{"$f":"IF(CU7<>\"None\",CV7/CW7,0)","v":0},null,"SCS-4-325",{"$f":"IF(AND($CI$57=0,$CI$69=0,$CI$81=0,$CI$93=0,$CI$104=0),0.00007,1.00007)","v":6.9999999999999994E-5},{"$f":"INDEX(CZ4:CZ18,MATCH(LARGE($DA$4:$DA$18,4),$DA$4:$DA$18,0))","v":"SDS-Q-128"}]
["NOTE: Other pumps (and manufacturers) are available which may meet your pumping requirements. However, the process for determining flow-rate (Q) and TDH is the same while a different pump curve would be used to select a pump, PV wattage, and operating voltage. See user manual for more discussion.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"and its Motor Voltage",null,null,null,{"$f":"IF(U31=\"None\",0,Y31)","v":90},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"At 45 V",{"$f":"CQ51","v":"None"},{"$f":"IF(CU8<>\"None\",SMALL(CK42:CK50,COUNTIF(CK42:CK50,0)+1),0)","v":0},{"$f":"IF(CU8<>\"None\",45,0)","v":0},0,null,"SCS-3-425",{"$f":"IF(AND($CI$68=0,$CI$92=0,$CI$80=0),0.00002,1.00002)","v":2.0000000000000002E-5},{"$f":"INDEX(CZ4:CZ18,MATCH(LARGE($DA$4:$DA$18,5),$DA$4:$DA$18,0))","v":"SDS-Q-135"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Recommended PV Panel Wattage",null,null,null,{"$f":"IFERROR(M17,0)","v":477.96930120589423},"W",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"At 60 V",{"$f":"CQ64","v":"None"},{"$f":"IF(CU9<>\"None\",SMALL(CK55:CK63,COUNTIF(CK55:CK63,0)+1),0)","v":0},{"$f":"IF(CU9<>\"None\",60,0)","v":0},0,null,"SCS-3-200",{"$f":"IF(AND($CI$31=0,$CI$43=0),0.0001,1.0001)","v":1E-4},{"$f":"INDEX(CZ4:CZ18,MATCH(LARGE($DA$4:$DA$18,6),$DA$4:$DA$18,0))","v":"SDS-T-128"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($T$7=\"None\",\"No SCS series fits these parameters - retry\",\"\")","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"At 75 V",{"$f":"CQ76","v":"None"},{"$f":"IF(CU10<>\"None\",SMALL(CK68:CK75,COUNTIF(CK68:CK75,0)+1),0)","v":0},{"$f":"IF(CU10<>\"None\",75,0)","v":0},0,null,"SCS-30-115",{"$f":"IF(AND($CI$63=0,$CI$75=0,$CI$87=0,$CI$99=0,$CI$108=0),0.00001,1.00001)","v":1.0000100000000001},{"$f":"INDEX(CZ4:CZ18,MATCH(LARGE($DA$4:$DA$18,7),$DA$4:$DA$18,0))","v":"SCS-18-45"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"At 90 V",{"$f":"CQ88","v":"18-160"},{"$f":"IF(CU11<>\"None\",SMALL(CK80:CK87,COUNTIF(CK80:CK87,0)+1),0)","v":590},{"$f":"IF(CU11<>\"None\",90,0)","v":90},6.5555555555555554,null,"SCS-18-160",{"$f":"IF(AND($CI$50=0,$CI$62=0,$CI$74=0,$CI$86=0,$CI$98=0,$CI$107=0),0.00008,1.00008)","v":1.0000800000000001},{"$f":"INDEX(CZ4:CZ18,MATCH(LARGE($DA$4:$DA$18,8),$DA$4:$DA$18,0))","v":"SCS-12-95"}]
["Step 9: Once you have selected a Pump, its operating Motor Voltage, Wattage, and the \"average PV efficiency\", enter the required information in the green cells and move to the Array Sizing sheet.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"At 105 V",{"$f":"CQ100","v":"18-160"},{"$f":"IF(CU12<>\"None\",(SMALL(CK92:CK99,COUNTIF(CK92:CK99,0)+1)),0)","v":848},{"$f":"IF(CU12<>\"None\",105,0)","v":105},8.0761904761904759,null,"SCS-14-160",{"$f":"IF(AND($CI$61=0,$CI$85=0,$CI$97=0,$CI$73=0),0.00003,1.00003)","v":3.0000000000000001E-5},{"$f":"INDEX(CZ4:CZ18,MATCH(LARGE($DA$4:$DA$18,9),$DA$4:$DA$18,0))","v":"SCS-3-200"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"At 120 V",{"$f":"CQ109","v":"18-160"},{"$f":"IF(CU13<>\"None\",(SMALL(CK104:CK108,COUNTIF(CK104:CK108,0)+1)),0)","v":1146},{"$f":"IF(CU13<>\"None\",120,0)","v":120},9.5500000000000007,null,"SCS-12-95",{"$f":"IF(AND($CI$35=0,$CI$47=0,$CI$56=0),0.00011,1.00011)","v":1.1E-4},{"$f":"INDEX(CZ4:CZ18,MATCH(LARGE($DA$4:$DA$18,10),$DA$4:$DA$18,0))","v":"SCS-8-90"}]
[null,null,null,null,"User ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(CV5:CV13,COUNTIF(CV5:CV13,0)+1)","v":590},null,null,null,"SCS-11-210",{"$f":"IF(AND($CI$60=0,$CI$72=0,$CI$84=0,$CI$96=0,$CI$106=0),0.00004,1.00004)","v":4.0000000000000003E-5},{"$f":"INDEX(CZ4:CZ18,MATCH(LARGE($DA$4:$DA$18,11),$DA$4:$DA$18,0))","v":"SCS-4-325"}]
["Average Pump Efficiency",null,null,null,"Entries",null,"Typical",null,"Taking into account avg. Pump & PV efficiencies: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCS",{"$f":"IF(AND(CP38=0,CP51=0,CP64=0,CP76=0,CP88=0,CP100=0,CP109=0),\"None\",INDEX(CU7:CU13,MATCH((SMALL(CV7:CV13,COUNTIF(CV7:CV13,0)+1)),CV7:CV13,0)))","v":"18-160"},{"$f":"IF(CU15=\"None\",0,SMALL(CV7:CV13,COUNTIF(CV7:CV13,0)+1))","v":590},{"$f":"IF(CU15=\"None\",0,INDEX(CW7:CW13,MATCH((SMALL(CV7:CV13,COUNTIF(CV7:CV13,0)+1)),CV7:CV13,0)))","v":90},{"$f":"IF(CU15=\"None\",0,INDEX(CX7:CX13,MATCH((SMALL(CV7:CV13,COUNTIF(CV7:CV13,0)+1)),CV7:CV13,0)))","v":6.5555555555555554},null,"SCS-10-230",{"$f":"IF(AND($CI$59=0,$CI$71=0,$CI$83=0,$CI$95=0),0.00005,1.00005)","v":1.0000500000000001},{"$f":"INDEX(CZ4:CZ18,MATCH(LARGE($DA$4:$DA$18,12),$DA$4:$DA$18,0))","v":"SCS-6-185"}]
["SCS Submersible Centrifugal ",null,null,null,{"$f":"IF(E17>=0.1,E17,0.1)","v":0.44},null,0.28000000000000003,null,"To meet Q and TDH, a SCS pump requires input power from:",null,null,null,null,null,null," User Pump Choice",null,null,null,"SCS-10-230",null,"Go to the recommended pump's chart",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCS-18-45",{"$f":"IF(AND($CI$37=0,$CI$49=0),0.00012,1.00012)","v":1.2E-4},{"$f":"INDEX(CZ4:CZ18,MATCH(LARGE($DA$4:$DA$18,13),$DA$4:$DA$18,0))","v":"SCS-11-210"}]
["Real Pump Efficiency",null,null,null,{"$f":"IF(E18>=0.1,E18,0.1)","v":0.44},null,null,null,null,{"$f":"IFERROR(ROUNDUP((($T$2*$T$4/3960)/E16*746),0),0)","v":409},"W","to",{"$f":"IFERROR((('Daily Water Requirement'!$N$29*$T$5/367)/$E$16/$E$19)/'Solar Resource'!K9,0)","v":477.96930120589423},"W",null,"Pump Motor Voltage",null,null,null,75,"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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(T16=\"SCS-3-200\",\"3-200\",IF(T16=\"SCS-8-90\",\"8-90\",IF(T16=\"SCS-12-95\",\"12-95\",IF(T16=\"SCS-18-45\",\"18-45\",IF(T16=\"SCS-4-325\",\"4-325\",IF(T16=\"SCS-10-230\",\"10-230\",IF(T16=\"SCS-18-160\",\"18-160\",IF(T16=\"SCS-30-115\",\"30-115\",\"Error\"))))))))","v":"10-230"},{"$f":"MATCH(CT17,CU7:CU13,0)","v":{"$error":"#N/A"}},{"$f":"INDEX(CV7:CV13,CU17)","v":{"$error":"#N/A"}},null,null,null,"SDS-Q-135",{"$f":"IF(AND($CI$9=0,CI10=0),0.00014,1.00014)","v":1.3999999999999999E-4},{"$f":"INDEX(CZ4:CZ18,MATCH(LARGE($DA$4:$DA$18,14),$DA$4:$DA$18,0))","v":"SCS-14-160"}]
[null,null,null,null,{"$f":"IF(T7=\"3-200\",INDEX(AL26:AL48,MATCH(CV15,AK26:AK48,0)),IF(T7=\"8-90\",INDEX(AR26:AR50,MATCH(CV15,AQ26:AQ50,0)),IF(T7=\"12-95\",INDEX(AX26:AX55,MATCH(CV15,AW26:AW55,0)),IF(T7=\"18-45\",INDEX(BD26:BD38,MATCH(CV15,BC26:BC38,0)),IF(T7=\"4-325\",INDEX(AL59:AL122,MATCH(CV15,AK59:AK122,0)),IF(T7=\"10-230\",INDEX(AR59:AR105,MATCH(CV15,AQ59:AQ105,0)),IF(T7=\"18-160\",INDEX(AX59:AX104,MATCH(CV15,AW59:AW104,0)),IF(T7=\"30-115\",INDEX(BD59:BD118,MATCH(CV15,BC59:BC118,0)),\"Error\"))))))))","v":0.44},null,null,null,null,null,null,null,null,null,null,"Pump Motor Wattage",null,null,null,520,"W","Go to the recommended pump's data table",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SDS-Q-128",{"$f":"IF(AND($CI$7=0,$CI$18=0),0.00015,1.00015)","v":1.4999999999999999E-4},{"$f":"INDEX(CZ4:CZ18,MATCH(LARGE($DA$4:$DA$18,15),$DA$4:$DA$18,0))","v":"SCS-3-425"}]
["Average PV Efficiency",null,null,null,{"$f":"G19","v":0.85},null,0.85,null,{"$f":"IFERROR(IF(INDEX(DA4:DA18,MATCH(T16,CZ4:CZ18,0))<1,A184,\"\"),A184)","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eff",{"$f":"IF(T16=\"SCS-3-200\",INDEX(AL26:AL48,MATCH(CV17,AK26:AK48,0)),IF(T16=\"SCS-8-90\",INDEX(AR26:AR50,MATCH(CV17,AQ26:AQ50,0)),IF(T16=\"SCS-12-95\",INDEX(AX26:AX55,MATCH(CV17,AW26:AW55,0)),IF(T16=\"SCS-18-45\",INDEX(BD26:BD38,MATCH(CV17,BC26:BC38,0)),IF(T16=\"SCS-4-325\",INDEX(AL59:AL122,MATCH(CV17,AK59:AK122,0)),IF(T16=\"SCS-10-230\",INDEX(AR59:AR105,MATCH(CV17,AQ59:AQ105,0)),IF(T16=\"SCS-18-160\",INDEX(AX59:AX104,MATCH(CV17,AW59:AW104,0)),IF(T16=\"SCS-30-115\",INDEX(BD59:BD118,MATCH(CV17,BC59:BC118,0)),\"Error\"))))))))","v":{"$error":"#N/A"}},null,null,null,"Useless",{"$f":"COUNTIF(DA4:DA18,\"<1\")","v":12}]
[]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(T17>=(INDEX(DB33:DB40,8-DA41)-((7-DA41)*15)),T17<=(INDEX(DB33:DB40,8-DA41))),\"\",A185),A185)","v":"The voltage selected does not satisfy the pump requirements!!"}]
[]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(OR(T18>(T9+100),T18<J17),A186,\"\"),A186)","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,null,null,null,null,null,null,null,null,"3-200","TDH","GPM","AMPS","WATTS",{"$f":"E16","v":0.44},"8-90","TDH","GPM","AMPS","WATTS",{"$f":"E16","v":0.44},"12-95","TDH","GPM","AMPS","WATTS",{"$f":"E16","v":0.44},"18-45","TDH","GPM","AMPS","WATTS",{"$f":"E16","v":0.44}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,4.2,5.85,176,0,30,0,10.3,5.1100000000000003,153,0,30,0,12.2,4.57,137,0,30,0,23,5.15,155,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,23,3.8,5.87,176,0.09,null,12,9.4,5.18,155,0.13,null,12,10.8,4.57,137,0.17,null,12,18.600000000000001,5.29,159,0.26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCS",null,null,"meets","meets"]
["SCS series Centrifugal  pumps are high-power submersibles, intended for pumping higher water volumes from greater depth",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCS series Centrifugal type Solar Pumps",null,null,null,null,null,null,null,null,null,null,null,null,null,46,3.4,5.87,176,0.17,null,23,8.3000000000000007,5.3,159,0.23,null,23,8.5,4.47,134,0.28000000000000003,null,23,13.5,5.3,159,0.37,null,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/2 HP",null,null,"gpm","tdh",null,null,"TDH","gpm"]
["   Can be used to fill an open tank or in a pressurized system.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69,2.9,5.83,175,0.22,null,35,7.2,5.36,161,0.28999999999999998,null,35,5.4,4.21,126,0.28000000000000003,null,35,5.6,4.62,139,0.26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,"Volts",null,"Vlookup","Match",null,"Order"]
["   Operate on 140 to 2000 watts of DC power at 30 to 180 volts from any combination of DC power sources.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Recommended SCS Pump and Voltage",null,null,null,null,null,null,null,null,null,null,null,null,92,2.4,5.7,171,0.24,null,46,5.9,5.33,160,0.32,null,46,0,3.11,93,0,null,46,0,3.3,99,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,8,"2-280",{"$f":"-0.0174*T4+4.0148","v":2.0138000000000003},null,{"$f":"IF($T$2<CE30,\"Y\",\"N\")","v":"N"},{"$f":"IF($T$4<#REF!,\"Y\",\"N\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(CI30=1,VLOOKUP($T$4,#REF!,4,TRUE),0)","v":0},{"$f":"IF(CI30=1,INDEX(#REF!,MATCH($T$2,#REF!,-1)),0)","v":0},"2-280",null,null,{"$f":"COUNTIF($CK$38:$CN$38,CQ30)","v":0},"2-280"]
["   Constructed of corrosion resistant marine grade bronze and stainless steel - multi-stage centrifugal type.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CU15","v":"18-160"},null,null,null,{"$f":"CW15","v":90},"Volts",null,null,null,null,null,null,null,116,1.8,5.49,165,0.24,null,58,4.5999999999999996,5.22,157,0.32,45,0,17.600000000000001,6.98,314,0,45,0,33,8,360,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,7,"3-200",{"$f":"-0.025*T4+4.461","v":1.5860000000000003},null,{"$f":"IF($T$2<CE31,\"Y\",\"N\")","v":"N"},{"$f":"IF($T$4<AH33,\"Y\",\"N\")","v":"Y"},{"$f":"IF(AND(CG31=\"Y\",CH31=\"Y\"),1,0)","v":0},null,{"$f":"IF(CI31=1,VLOOKUP($T$4,AH26:AK33,4,TRUE),0)","v":0},{"$f":"IF(CI31=1,INDEX(AK26:AK33,MATCH($T$2,AI26:AI33,-1)),0)","v":0},"3-200",null,null,0,"3-200"]
["   The submersible motors incorporate the latest in high efficiency, permanent magnet, brushless DC technology.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,139,1,5.04,151,0.17,null,69,3,4.7699999999999996,143,0.27,null,12,16.5,6.98,314,0.11,null,12,30,8.1,365,0.18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"5-160",{"$f":"-0.0478*T4+4.34","v":-1.157},null,{"$f":"IF($T$2<CE32,\"Y\",\"N\")","v":"N"},{"$f":"IF($T$4<#REF!,\"Y\",\"N\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(CI32=1,VLOOKUP($T$4,#REF!,4,TRUE),0)","v":0},{"$f":"IF(CI32=1,INDEX(#REF!,MATCH($T$2,#REF!,-1)),0)","v":0},"5-160",null,null,0,"5-160"]
["   Supplied with an industry standard NEMA connection, they bolt directly to standard 4” submersible pump ends.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,162,0,4.38,131,0,null,81,1.2,4.2300000000000004,127,0.14000000000000001,null,23,15.2,6.97,314,0.21,null,23,26.5,8.36,376,0.31,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,"5-95",{"$f":"-0.0915*T4+7.6566","v":-2.865899999999999},null,"N",{"$f":"IF($T$4<#REF!,\"Y\",\"N\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(CI33=1,VLOOKUP($T$4,#REF!,4,TRUE),0)","v":0},{"$f":"IF(CI33=1,INDEX(#REF!,MATCH($T$2,#REF!,-1)),0)","v":0},"5-95",null,null,0,"5-95",null,null,null,null,null,null,45,null,15,{"$f":"IF(OR(AND($T$16=\"SDS-Q-128\",$CI$7=1),AND($T$16=\"SDS-Q-135\",$CI$9=1),AND($T$16=\"SDS-T-128\",CI10=1)),1.00008,0.00008)","v":8.0000000000000007E-5},{"$f":"INDEX($CZ$33:$CZ$40,MATCH(LARGE($DA$33:$DA$40,1),$DA$33:$DA$40,0))","v":90},{"$f":"OFFSET(DB33,0,0,8-DA41,1)","v":90}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,0,5.7,9.23,415,0,null,92,0,3.81,114,0,null,35,13.8,6.9,311,0.28999999999999998,null,35,22.5,8.5500000000000007,385,0.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,6,"8-90",{"$f":"-0.1145*T4+10.836","v":-2.3315000000000001},null,"N",{"$f":"IF($T$4<AN34,\"Y\",\"N\")","v":"N"},0,null,{"$f":"IF(CI34=1,VLOOKUP($T$4,AN26:AQ34,4,TRUE),0)","v":0},{"$f":"IF(CI34=1,INDEX(AQ26:AQ34,MATCH($T$2,AO26:AO34,-1)),0)","v":0},"8-90",null,null,0,"8-90",null,null,null,null,null,null,null,null,30,{"$f":"IF(OR(AND(T16=\"SCS-3-200\",CI31=1),AND(T16=\"SCS-8-90\",CI34=1),AND(T16=\"SCS-12-95\",CI35=1),AND(T16=\"SCS-18-45\",CI37=1)),1.00007,0.00007)","v":6.9999999999999994E-5},{"$f":"INDEX($CZ$33:$CZ$40,MATCH(LARGE($DA$33:$DA$40,2),$DA$33:$DA$40,0))","v":105}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,5.5,9.23,415,0.06,45,0,14.2,8.1999999999999993,369,0,null,46,12.1,6.77,305,0.35,null,46,17.7,8.44,380,0.41,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,"12-95",{"$f":"-0.02585*T4+13.378","v":10.405250000000001},null,"Y",{"$f":"IF($T$4<AT30,\"Y\",\"N\")","v":"N"},0,null,{"$f":"IF(CI35=1,VLOOKUP($T$4,AT26:AW30,4,TRUE),0)","v":0},{"$f":"IF(CI35=1,INDEX(AW26:AW30,MATCH($T$2,AU26:AU30,-1)),0)","v":0},"12-95",null,null,0,"12-95",null,null,null,null,null,null,{"$f":"INDEX(DB33:DB40,8-DA41)","v":105},null,45,{"$f":"IF(OR(AND(T16=\"SCS-3-200\",CI43=1),AND(T16=\"SCS-8-90\",CI46=1),AND(T16=\"SCS-12-95\",CI47=1),AND(T16=\"SCS-18-45\",CI49=1),AND(T16=\"SCS-18-160\",CI50=1)),1.00006,0.00006)","v":6.0000000000000002E-5},{"$f":"INDEX($CZ$33:$CZ$40,MATCH(LARGE($DA$33:$DA$40,3),$DA$33:$DA$40,0))","v":15}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,5.3,9.25,416,0.11,null,12,13.6,8.27,372,0.08,null,58,10,6.6,297,0.37,null,58,12,7.92,356,0.37,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,"14-70",{"$f":"-0.2886*T4+18.57","v":-14.619},null,"N",{"$f":"IF($T$4<#REF!,\"Y\",\"N\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(CI36=1,VLOOKUP($T$4,#REF!,4,TRUE),0)","v":0},{"$f":"IF(CI36=1,INDEX(#REF!,MATCH($T$2,#REF!,-1)),0)","v":0},"14-70",null,null,0,"14-70",null,null,null,null,null,null,{"$f":"INDEX(DB33:DB40,8-DA41)-((7-DA41)*15)","v":90},null,60,{"$f":"IF(OR(AND(T16=\"SCS-5-160\",CI55=1),AND(T16=\"SCS-12-95\",CI56=1),AND(T16=\"SCS-4-325\",CI57=1),AND(T16=\"SCS-6-185\",CI58=1),AND(T16=\"SCS-10-230\",CI59=1),AND(T16=\"SCS-11-210\",CI60=1),AND(T16=\"SCS-14-160\",CI61=1),AND(T16=\"SCS-18-160\",CI62=1),AND(T16=\"SCS-30-115\",CI63=1)),1.00005,0.00005)","v":5.0000000000000002E-5},{"$f":"INDEX($CZ$33:$CZ$40,MATCH(LARGE($DA$33:$DA$40,4),$DA$33:$DA$40,0))","v":30}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69,5,9.26,417,0.16,null,23,13,8.35,376,0.15,null,69,7.9,6.34,285,0.36,null,69,6,7.21,324,0.24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"18-45",{"$f":"-0.513*T4+24.041","v":-34.954000000000008},null,"N",{"$f":"IF($T$4<AZ30,\"Y\",\"N\")","v":"N"},0,null,{"$f":"IF(CI37=1,VLOOKUP($T$4,AZ26:BC30,4,TRUE),0)","v":0},{"$f":"IF(CI37=1,INDEX(BC26:BC30,MATCH($T$2,BA26:BA30,-1)),0)","v":0},"18-45",null,null,0,"18-45",null,null,null,null,null,null,null,null,75,{"$f":"IF(OR(AND(T16=\"SCS-3-425\",CI68=1),AND(T16=\"SCS-4-325\",CI69=1),AND(T16=\"SCS-6-185\",CI70=1),AND(T16=\"SCS-10-230\",CI71=1),AND(T16=\"SCS-11-210\",CI72=1),AND(T16=\"SCS-14-160\",CI73=1),AND(T16=\"SCS-18-160\",CI74=1),AND(T16=\"SCS-30-115\",CI75=1)),1.00004,0.00004)","v":4.0000000000000003E-5},{"$f":"INDEX($CZ$33:$CZ$40,MATCH(LARGE($DA$33:$DA$40,5),$DA$33:$DA$40,0))","v":45}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,92,4.7,9.24,416,0.2,null,35,12.3,8.4600000000000009,381,0.21,null,81,5.4,5.87,264,0.31,null,81,0,6.21,279,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,{"$f":"VLOOKUP(SMALL(CK30:CK37,COUNTIF(CK30:CK37,0)+1),CK30:CM37,3,FALSE)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(SMALL(CL30:CL37,COUNTIF(CL30:CL37,0)+1),CL30:CM37,2,FALSE)","v":{"$error":"#NUM!"}},null,{"$f":"IF(CI35=1,CD35,IF(CI37=1,CD37,IF(CI32=1,CD32,IF(CI33=1,CD33,IF(CI36=1,CD36,IF(CI34=1,CD34,IF(CI31=1,CD31,IF(CI30=1,CD30,\"ERROR\"))))))))","v":"ERROR"},null,{"$f":"SUM(CP30:CP37)","v":0},{"$f":"IF(CP38>0,VLOOKUP(MAX(CP30:CP37),CP30:CQ37,2,FALSE),\"None\")","v":"None"},null,null,null,null,null,null,null,null,90,{"$f":"IF(OR(AND(T16=\"SCS-3-425\",CI80=1),AND(T16=\"SCS-4-325\",CI81=1),AND(T16=\"SCS-6-185\",CI82=1),AND(T16=\"SCS-10-230\",CI83=1),AND(T16=\"SCS-11-210\",CI84=1),AND(T16=\"SCS-14-160\",CI85=1),AND(T16=\"SCS-18-160\",CI86=1),AND(T16=\"SCS-30-115\",CI87=1)),1.00003,0.00003)","v":1.00003},{"$f":"INDEX($CZ$33:$CZ$40,MATCH(LARGE($DA$33:$DA$40,6),$DA$33:$DA$40,0))","v":60}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,116,4.4000000000000004,9.2100000000000009,414,0.23,null,46,11.6,8.5399999999999991,384,0.26,null,92,1.5,4.82,217,0.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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,105,{"$f":"IF(OR(AND(T16=\"SCS-3-425\",CI92=1),AND(T16=\"SCS-4-325\",CI93=1),AND(T16=\"SCS-6-185\",CI94=1),AND(T16=\"SCS-10-230\",CI95=1),AND(T16=\"SCS-11-210\",CI96=1),AND(T16=\"SCS-14-160\",CI97=1),AND(T16=\"SCS-18-160\",CI98=1),AND(T16=\"SCS-30-115\",CI99=1)),1.00002,0.00002)","v":1.0000199999999999},{"$f":"INDEX($CZ$33:$CZ$40,MATCH(LARGE($DA$33:$DA$40,7),$DA$33:$DA$40,0))","v":75}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,139,4,9.17,413,0.25,null,58,10.9,8.6,387,0.31,null,104,0,4.5,203,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,"TDH","gpm",null,null,null,null,null,null,null,null,null,null,null,null,null,120,{"$f":"IF(OR(AND(T16=\"SCS-4-325\",CI104=1),AND(T16=\"SCS-6-185\",CI105=1),AND(T16=\"SCS-11-210\",CI106=1),AND(T16=\"SCS-18-160\",CI107=1),AND(T16=\"SCS-30-115\",CI108=1)),1.00001,0.00001)","v":1.0000000000000001E-5},{"$f":"INDEX($CZ$33:$CZ$40,MATCH(LARGE($DA$33:$DA$40,8),$DA$33:$DA$40,0))","v":120}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,162,3.6,9.1,410,0.27,null,69,10,8.6300000000000008,388,0.34,60,0,21.9,9.3800000000000008,563,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,45,"Volts",null,"Vlookup","Match",null,"Order",null,null,null,null,null,null,null,null,null,null,null,"Useless",{"$f":"COUNTIF(DA33:DA40,\"<1\")","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,185,3.2,8.98,404,0.28000000000000003,null,81,9.1,8.6,387,0.36,null,12,21,9.3699999999999992,562,8.1000000000000003E-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,null,9,"2-280",{"$f":"-0.0134*T4+5.7494","v":4.2083999999999993},null,{"$f":"IF($T$2<CE42,\"Y\",\"N\")","v":"N"},{"$f":"IF($T$4<#REF!,\"Y\",\"N\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(CI42=1,VLOOKUP($T$4,#REF!,4,TRUE),0)","v":0},{"$f":"IF(CI42=1,INDEX(#REF!,MATCH($T$2,#REF!,-1)),0)","v":0},"2-280",null,null,{"$f":"COUNTIF($CK$51:$CN$51,CQ42)","v":0},"2-280"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,208,2.8,8.7799999999999994,395,0.27,null,92,8.1999999999999993,8.5500000000000007,385,0.37,null,23,20.100000000000001,9.36,562,0.156,null,null,null,null,null,null,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,"3-200",{"$f":"-0.0174*T4+6.1709","v":4.1699000000000002},null,{"$f":"IF($T$2<CE43,\"Y\",\"N\")","v":"N"},{"$f":"IF($T$4<AH48,\"Y\",\"N\")","v":"Y"},{"$f":"IF(AND(CG43=\"Y\",CH43=\"Y\"),1,0)","v":0},null,{"$f":"IF(CI43=1,VLOOKUP($T$4,AH34:AK48,4,TRUE),0)","v":0},{"$f":"IF(CI43=1,INDEX(AK34:AK48,MATCH($T$2,AI34:AI48,-1)),0)","v":0},"3-200",null,null,0,"3-200"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,231,2.2999999999999998,8.5500000000000007,985,0.26,null,104,7.2,8.4700000000000006,381,0.37,null,35,19.100000000000001,9.34,560,0.222,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"5-160",{"$f":"-0.0372*T4+6.7338","v":2.4558},null,"N",{"$f":"IF($T$4<#REF!,\"Y\",\"N\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(CI44=1,VLOOKUP($T$4,#REF!,4,TRUE),0)","v":0},{"$f":"IF(CI44=1,INDEX(#REF!,MATCH($T$2,#REF!,-1)),0)","v":0},"5-160",null,null,0,"5-160"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,254,1.8,8.1999999999999993,369,0.23,null,116,6,8.24,371,0.35,null,46,18,9.36,562,0.27900000000000003,null,null,null,null,null,null,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,"5-95",{"$f":"-0.067*T4+11.284","v":3.5790000000000006},null,"N",{"$f":"IF($T$4<#REF!,\"Y\",\"N\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(CI45=1,VLOOKUP($T$4,#REF!,4,TRUE),0)","v":0},{"$f":"IF(CI45=1,INDEX(#REF!,MATCH($T$2,#REF!,-1)),0)","v":0},"5-95",null,null,0,"5-95"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,277,1.3,7.82,352,0.19,null,127,4.8,7.9,356,0.32,null,58,16.899999999999999,9.3000000000000007,558,0.32900000000000001,null,null,null,null,null,null,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,"8-90",{"$f":"-0.085*T4+15.283","v":5.5079999999999991},null,"N",{"$f":"IF($T$4<AN50,\"Y\",\"N\")","v":"Y"},0,null,{"$f":"IF(CI46=1,VLOOKUP($T$4,AN35:AQ50,4,TRUE),0)","v":0},{"$f":"IF(CI46=1,INDEX(AQ35:AQ50,MATCH($T$2,AO35:AO50,-1)),0)","v":0},"8-90",null,null,0,"8-90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300,0.7,7.3,329,0.12,null,139,3.4,7.38,332,0.27,null,69,15.5,9.2100000000000009,553,0.36599999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"12-95",{"$f":"-0.1748*T4+19.09","v":-1.0120000000000005},null,"N",{"$f":"IF($T$4<AT40,\"Y\",\"N\")","v":"N"},0,null,{"$f":"IF(CI47=1,VLOOKUP($T$4,AT31:AW40,4,TRUE),0)","v":0},{"$f":"IF(CI47=1,INDEX(AW31:AW40,MATCH($T$2,AU31:AU40,-1)),0)","v":0},"12-95",null,null,0,"12-95"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,323,0,6.78,305,0,null,150,1.9,6.89,310,0.17,null,81,14,9.09,545,0.39100000000000001,null,null,null,null,null,null,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,"14-70",{"$f":"-0.2132*T4+26.534","v":2.0159999999999982},null,"N",{"$f":"IF($T$4<#REF!,\"Y\",\"N\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(CI48=1,VLOOKUP($T$4,#REF!,4,TRUE),0)","v":0},{"$f":"IF(CI48=1,INDEX(#REF!,MATCH($T$2,#REF!,-1)),0)","v":0},"14-70",null,null,0,"14-70"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,162,0.5,6.58,296,0.05,null,92,12.3,8.9,534,0.40100000000000002,null,null,null,null,null,null,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,"18-45",{"$f":"-0.4125*T4+35.167","v":-12.270499999999998},null,"N",{"$f":"IF($T$4<AZ38,\"Y\",\"N\")","v":"N"},0,null,{"$f":"IF(CI49=1,VLOOKUP($T$4,AZ31:BC38,4,TRUE),0)","v":0},{"$f":"IF(CI49=1,INDEX(BC31:BC38,MATCH($T$2,BA31:BA38,-1)),0)","v":0},"18-45",null,null,0,"18-45"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,173,0,6.01,270,0,null,104,10.7,8.69,521,0.40200000000000002,null,null,null,null,null,null,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,"18-160",{"$f":"-0.3127*T4+15.854","v":-20.106499999999997},null,"N",{"$f":"IF($T$4<AT63,\"Y\",\"N\")","v":"N"},0,null,{"$f":"IF(CI50=1,VLOOKUP($T$4,AT59:AW63,4,TRUE),0)","v":0},{"$f":"IF(CI50=1,INDEX(AW59:AW63,MATCH($T$2,AU59:AU63,-1)),0)","v":0},"18-160",null,null,0,"18-160"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,116,9,8.3800000000000008,503,0.38900000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"VLOOKUP(SMALL(CK42:CK50,COUNTIF(CK42:CK50,0)+1),CK42:CM50,3,FALSE)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(SMALL(CL42:CL50,COUNTIF(CL42:CL50,0)+1),CL42:CM50,2,FALSE)","v":{"$error":"#NUM!"}},null,{"$f":"IF(CI50=1,CD50,IF(CI44=1,CD44,IF(CI47=1,CD47,IF(CI45=1,CD45,IF(CI49=1,CD49,IF(CI46=1,CD46,IF(CI48=1,CD48,IF(CI43=1,CD43,IF(CI42=1,CD42,\"ERROR\")))))))))","v":"ERROR"},null,{"$f":"SUM(CP42:CP50)","v":0},{"$f":"IF(CP51>0,VLOOKUP(MAX(CP42:CP50),CP42:CQ50,2,FALSE),\"None\")","v":"None"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,127,7,7.96,478,0.35099999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,139,4.4000000000000004,7.29,437,0.26300000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TDH","gpm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,1.1000000000000001,6.44,386,8.1000000000000003E-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,null,null,null,null,null,null,60,"Volts",null,"Vlookup","Match",null,"Order"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,162,0,5.98,359,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,8,"5-160",{"$f":"-0.0283*T4+8.5966","v":5.3421000000000003},null,{"$f":"IF($T$2<CE55,\"Y\",\"N\")","v":"N"},{"$f":"IF($T$4<#REF!,\"Y\",\"N\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(CI55=1,VLOOKUP($T$4,#REF!,4,TRUE),0)","v":0},{"$f":"IF(CI55=1,INDEX(#REF!,MATCH($T$2,#REF!,-1)),0)","v":0},"5-160",null,null,{"$f":"COUNTIF($CK$64:$CN$64,CQ55)","v":0},"5-160"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"12-95",{"$f":"-0.1367*T4+23.798","v":8.0774999999999988},null,{"$f":"IF($T$2<CE56,\"Y\",\"N\")","v":"N"},{"$f":"IF($T$4<AT55,\"Y\",\"N\")","v":"Y"},{"$f":"IF(AND(CG56=\"Y\",CH56=\"Y\"),1,0)","v":0},null,{"$f":"IF(CI56=1,VLOOKUP($T$4,AT41:AW55,4,TRUE),0)","v":0},{"$f":"IF(CI56=1,INDEX(AW41:AW55,MATCH($T$2,AU41:AU55,-1)),0)","v":0},"12-95",null,null,0,"12-95"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"4-325",{"$f":"-0.0224*T4+4.8121","v":2.2361},null,"N",{"$f":"IF($T$4<AH65,\"Y\",\"N\")","v":"Y"},0,null,{"$f":"IF(CI57=1,VLOOKUP($T$4,AH59:AK65,4,TRUE),0)","v":0},{"$f":"IF(CI57=1,INDEX(AK59:AK65,MATCH($T$2,AI59:AI65,-1)),0)","v":0},"4-325",null,null,0,"4-325"]
[null,null,null,null,null,null,null,null,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-325","TDH","GPM","AMPS","WATTS",{"$f":"E16","v":0.44},"10-230","TDH","GPM","AMPS","WATTS",{"$f":"E16","v":0.44},"18-160","TDH","GPM","AMPS","WATTS",{"$f":"E16","v":0.44},"30-115","TDH","GPM","AMPS","WATTS",{"$f":"E16","v":0.44},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,"6-185",{"$f":"-0.0626*T4+6.24","v":-0.95900000000000052},null,"N",{"$f":"IF($T$4<#REF!,\"Y\",\"N\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(CI58=1,VLOOKUP($T$4,#REF!,4,TRUE),0)","v":0},{"$f":"IF(CI58=1,INDEX(#REF!,MATCH($T$2,#REF!,-1)),0)","v":0},"6-185",null,null,0,"6-185"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,0,4.5,3.93,236,0,60,0,11.3,5.0999999999999996,306,0,45,0,15,2.8,126,0,60,0,30,3.71,223,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,7,"10-230",{"$f":"-0.076*T4+12.326","v":3.5860000000000003},null,"N",{"$f":"IF($T$4<AN65,\"Y\",\"N\")","v":"Y"},0,null,{"$f":"IF(CI59=1,VLOOKUP($T$4,AN59:AQ65,4,TRUE),0)","v":0},{"$f":"IF(CI59=1,INDEX(AQ59:AQ65,MATCH($T$2,AO59:AO65,-1)),0)","v":0},"10-230",null,null,0,"10-230"]
[null,null,null,null,null,null,null,null,null,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,4,3.95,237,0.11,null,23,10.3,5.0199999999999996,301,0.15,null,12,12,2.77,125,0.22,null,12,27.6,3.82,229,0.26,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,"11-210",{"$f":"-0.1322*T4+13.68","v":-1.5230000000000015},null,"N",{"$f":"IF($T$4<#REF!,\"Y\",\"N\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(CI60=1,VLOOKUP($T$4,#REF!,4,TRUE),0)","v":0},{"$f":"IF(CI60=1,INDEX(#REF!,MATCH($T$2,#REF!,-1)),0)","v":0},"11-210",null,null,0,"11-210"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69,3.5,3.94,236,0.19,null,46,9.3000000000000007,4.99,299,0.27,null,23,10,2.69,121,0.36,null,23,24,4.1399999999999997,248,0.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,6,"14-160",{"$f":"-0.1965*T4+20","v":-2.5975000000000001},null,"N",{"$f":"IF($T$4<#REF!,\"Y\",\"N\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(CI61=1,VLOOKUP($T$4,#REF!,4,TRUE),0)","v":0},{"$f":"IF(CI61=1,INDEX(#REF!,MATCH($T$2,#REF!,-1)),0)","v":0},"14-160",null,null,0,"14-160"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,104,2.8,3.86,232,0.24,null,69,8,4.91,295,0.35,null,35,6,2.4300000000000002,109,0.36,null,35,18,4.2699999999999996,256,0.46,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"18-160",{"$f":"-0.2078*T4+19.28","v":-4.6170000000000009},null,"N",{"$f":"IF($T$4<AT68,\"Y\",\"N\")","v":"N"},0,null,{"$f":"IF(CI62=1,VLOOKUP($T$4,AT64:AW68,4,TRUE),0)","v":0},{"$f":"IF(CI62=1,INDEX(AW64:AW68,MATCH($T$2,AU64:AU68,-1)),0)","v":0},"18-160",null,null,0,"18-160"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,139,1.9,3.69,221,0.22,null,92,6.5,4.7,282,0.4,null,46,0,1.81,81,0,null,46,11,4,240,0.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,4,"30-115",{"$f":"-0.5095*T4+33.209","v":-25.383499999999991},null,"N",{"$f":"IF($T$4<AZ64,\"Y\",\"N\")","v":"N"},0,null,{"$f":"IF(CI63=1,VLOOKUP($T$4,AZ59:BC64,4,TRUE),0)","v":0},{"$f":"IF(CI63=1,INDEX(BC59:BC63,MATCH($T$2,BA59:BA63,-1)),0)","v":0},"30-115",null,null,0,"30-115"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,173,0.7,3.25,195,0.12,null,116,4,4.29,257,0.34,60,0,18.2,4.3,258,0,null,58,0,3.09,185,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,{"$f":"VLOOKUP(SMALL(CK55:CK63,COUNTIF(CK55:CK63,0)+1),CK55:CM63,3,FALSE)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(SMALL(CL55:CL63,COUNTIF(CL55:CL63,0)+1),CL55:CM63,2,FALSE)","v":{"$error":"#NUM!"}},null,{"$f":"IF(CI58=1,CD58,IF(CI62=1,CD62,IF(CI57=1,CD57,IF(CI63=1,CD63,IF(CI60=1,CD60,IF(CI61=1,CD61,IF(CI59=1,CD59,IF(CI55=1,CD55,IF(CI56=1,CD56,\"ERROR\")))))))))","v":"ERROR"},null,{"$f":"SUM(CP55:CP63)","v":0},{"$f":"IF(CP64>0,VLOOKUP(MAX(CP55:CP63),CP55:CQ63,2,FALSE),\"None\")","v":"None"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,208,0,2.93,176,0,null,139,0,3.16,190,0,null,23,15.4,4.29,257,0.26,75,0,36,4.75,356,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,75,0,5.4,5.1100000000000003,383,0,75,0,13.6,6.61,496,0,null,46,11,4.05,243,0.39,null,12,34,4.8499999999999996,364,0.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,null,null,null,"TDH","gpm"]
[null,null,null,null,null,null,null,null,null,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.12,384,0.08,null,23,12.8,6.52,489,0.11,null,69,4,3.36,202,0.26,null,23,31.3,5.18,389,0.35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,"Volts",null,"Vlookup","Match",null,"Order"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69,4.5999999999999996,5.13,385,0.15,null,46,12,6.53,490,0.21,null,92,0,2.89,173,0,null,35,28,5.44,408,0.45,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,"3-425",{"$f":"-0.0134*T4+5.5078","v":3.9667999999999992},null,{"$f":"IF($T$2<CE68,\"Y\",\"N\")","v":"N"},{"$f":"IF($T$4<#REF!,\"Y\",\"N\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(CI68=1,VLOOKUP($T$4,#REF!,4,TRUE),0)","v":0},{"$f":"IF(CI68=1,INDEX(#REF!,MATCH($T$2,#REF!,-1)),0)","v":0},"3-425",null,null,{"$f":"COUNTIF($CK$76:$CN$76,CQ68)","v":0},"3-425"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,104,4.0999999999999996,5.1100000000000003,383,0.21,null,69,11,6.46,485,0.3,75,0,22.5,5.65,424,0,null,46,24,5.6,420,0.5,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,"4-325",{"$f":"-0.0183*T4+5.8075","v":3.7030000000000003},null,{"$f":"IF($T$2<CE69,\"Y\",\"N\")","v":"N"},{"$f":"IF($T$4<AH74,\"Y\",\"N\")","v":"Y"},{"$f":"IF(AND(CG69=\"Y\",CH69=\"Y\"),1,0)","v":0},null,{"$f":"IF(CI69=1,VLOOKUP($T$4,AH66:AK74,4,TRUE),0)","v":0},{"$f":"IF(CI69=1,INDEX(AK66:AK74,MATCH($T$2,AI66:AI74,-1)),0)","v":0},"4-325",null,null,0,"4-325"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,139,3.6,5.0599999999999996,380,0.25,null,92,10,6.41,481,0.36,null,23,19.8,5.63,422,0.2,null,58,20,5.57,418,0.52,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,"6-185",{"$f":"-0.0509*T4+7.7829","v":1.9293999999999993},null,"N",{"$f":"IF($T$4<#REF!,\"Y\",\"N\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(CI70=1,VLOOKUP($T$4,#REF!,4,TRUE),0)","v":0},{"$f":"IF(CI70=1,INDEX(#REF!,MATCH($T$2,#REF!,-1)),0)","v":0},"6-185",null,null,0,"6-185"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,173,3,4.96,372,0.26,null,116,8.9,6.26,470,0.41,null,46,16.8,5.55,416,0.35,null,69,15,5.27,395,0.5,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,"10-230",{"$f":"-0.0615*T4+14.831","v":7.7584999999999997},null,"N",{"$f":"IF($T$4<AN75,\"Y\",\"N\")","v":"Y"},0,null,{"$f":"IF(CI71=1,VLOOKUP($T$4,AN66:AQ75,4,TRUE),0)","v":0},{"$f":"IF(CI71=1,INDEX(AQ66:AQ75,MATCH($T$2,AO66:AO75,-1)),0)","v":0},"10-230",null,null,0,"10-230"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,208,2.2999999999999998,4.7699999999999996,358,0.25,null,139,7.6,6.05,454,0.44,null,69,13,5.28,396,0.43,null,81,8.5,4.84,363,0.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,4,"11-210",{"$f":"-0.1039*T4+16.601","v":4.6524999999999981},null,"N",{"$f":"IF($T$4<#REF!,\"Y\",\"N\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(CI72=1,VLOOKUP($T$4,#REF!,4,TRUE),0)","v":0},{"$f":"IF(CI72=1,INDEX(#REF!,MATCH($T$2,#REF!,-1)),0)","v":0},"11-210",null,null,0,"11-210"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,243,1.4,4.42,332,0.19,null,162,5.5,6.65,499,0.34,null,92,7.2,4.7,353,0.36,null,92,0,4.07,305,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,6,"14-160",{"$f":"-0.1608*T4+24.715","v":6.222999999999999},null,"N",{"$f":"IF($T$4<#REF!,\"Y\",\"N\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(CI73=1,VLOOKUP($T$4,#REF!,4,TRUE),0)","v":0},{"$f":"IF(CI73=1,INDEX(#REF!,MATCH($T$2,#REF!,-1)),0)","v":0},"14-160",null,null,0,"14-160"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,277,0,3.74,281,0,null,185,3,4.97,373,0.28000000000000003,null,116,0,3.76,282,0,90,0,40.5,5.82,524,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,3,"18-160",{"$f":"-0.1905*T4+24.201","v":2.2935000000000016},null,{"$f":"IF($T$2<CE74,\"Y\",\"N\")","v":"N"},{"$f":"IF($T$4<AT74,\"Y\",\"N\")","v":"Y"},0,null,{"$f":"IF(CI74=1,VLOOKUP($T$4,AT69:AW74,4,TRUE),0)","v":0},{"$f":"IF(CI74=1,INDEX(AW69:AW74,MATCH($T$2,AU69:AU74,-1)),0)","v":0},"18-160",null,null,0,"18-160"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,0,6.4,6.29,566,0,null,208,0,3.97,298,0,90,0,26,6.99,629,0,null,12,39,5.93,534,0.16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"30-115",{"$f":"-0.3782*T4+39.347","v":-4.1459999999999937},null,"N",{"$f":"IF($T$4<AZ73,\"Y\",\"N\")","v":"N"},0,null,{"$f":"IF(CI75=1,VLOOKUP($T$4,AZ65:BC73,4,TRUE),0)","v":0},{"$f":"IF(CI75=1,INDEX(BC65:BC73,MATCH($T$2,BA65:BA73,-1)),0)","v":0},"30-115",null,null,0,"30-115"]
[null,null,null,null,null,null,null,null,null,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,6,6.31,568,7.0000000000000007E-2,90,0,15.8,8.08,727,0,null,23,23.8,6.97,627,0.17,null,23,37.1,6.29,566,0.28999999999999998,null,null,null,null,null,null,null,null,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":"VLOOKUP(SMALL(CK68:CK75,COUNTIF(CK68:CK75,0)+1),CK68:CM75,3,FALSE)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(SMALL(CL68:CL75,COUNTIF(CL68:CL75,0)+1),CL68:CM75,2,FALSE)","v":{"$error":"#NUM!"}},null,{"$f":"IF(CI70=1,CD70,IF(CI75=1,CD75,IF(CI74=1,CD74,IF(CI72=1,CD72,IF(CI69=1,CD69,IF(CI73=1,CD73,IF(CI68=1,CD68,IF(CI71=1,CD71,\"ERROR\"))))))))","v":"ERROR"},null,{"$f":"SUM(CP68:CP75)","v":0},{"$f":"IF(CP76>0,VLOOKUP(MAX(CP68:CP75),CP68:CQ75,2,FALSE),\"None\")","v":"None"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69,5.7,6.32,569,0.13,null,23,15.1,8.08,727,0.09,null,46,21.1,6.95,626,0.28999999999999998,null,35,35.200000000000003,6.57,591,0.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,104,5.3,6.33,570,0.18,null,46,14.4,8.1,729,0.17,null,69,18.100000000000001,6.81,613,0.39,null,46,33,6.79,611,0.47,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TDH","gpm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,139,4.9000000000000004,6.3,567,0.23,null,69,13.6,8.08,727,0.24,null,92,14.8,6.55,590,0.44,null,58,30,6.96,626,0.52,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,"Volts",null,"Vlookup","Match",null,"Order"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,173,4.5,6.27,564,0.26,null,92,12.8,8.01,721,0.31,null,116,10.9,6.11,550,0.43,null,69,26,7.04,634,0.54,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,"3-425",{"$f":"-0.0117*T4+6.4308","v":5.0852999999999993},null,{"$f":"IF($T$2<CE80,\"Y\",\"N\")","v":"N"},{"$f":"IF($T$4<#REF!,\"Y\",\"N\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(CI80=1,VLOOKUP($T$4,#REF!,4,TRUE),0)","v":0},{"$f":"IF(CI80=1,INDEX(#REF!,MATCH($T$2,#REF!,-1)),0)","v":0},"3-425",null,null,{"$f":"COUNTIF($CK$88:$CN$88,CQ80)","v":0},"3-425"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,208,4,6.2,558,0.28000000000000003,null,116,12,7.97,717,0.36,null,139,6,5.43,589,0.32,null,81,22,6.92,623,0.54,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"4-325",{"$f":"-0.0152*T4+6.8128","v":5.0648},null,{"$f":"IF($T$2<CE81,\"Y\",\"N\")","v":"N"},{"$f":"IF($T$4<AH87,\"Y\",\"N\")","v":"Y"},{"$f":"IF(AND(CG81=\"Y\",CH81=\"Y\"),1,0)","v":0},null,{"$f":"IF(CI81=1,VLOOKUP($T$4,AH75:AK87,4,TRUE),0)","v":0},{"$f":"IF(CI81=1,INDEX(AK75:AK87,MATCH($T$2,AI75:AI87,-1)),0)","v":0},"4-325",null,null,0,"4-325"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,243,3.4,6.09,548,0.28000000000000003,null,139,11,7.84,706,0.41,null,162,0,4.66,419,0,null,92,17,6.62,596,0.5,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,"6-185",{"$f":"-0.0452*T4+9.3164","v":4.1184000000000003},null,"N",{"$f":"IF($T$4<#REF!,\"Y\",\"N\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(CI82=1,VLOOKUP($T$4,#REF!,4,TRUE),0)","v":0},{"$f":"IF(CI82=1,INDEX(#REF!,MATCH($T$2,#REF!,-1)),0)","v":0},"6-185",null,null,0,"6-185"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,277,2.8,5.92,533,0.28000000000000003,null,162,9.9,7.68,691,0.44,105,0,29,8.3800000000000008,880,0,null,104,11,6.25,563,0.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,8,"10-230",{"$f":"-0.0526*T4+17.19","v":11.141000000000002},null,{"$f":"IF($T$2<CE83,\"Y\",\"N\")","v":"Y"},{"$f":"IF($T$4<AN88,\"Y\",\"N\")","v":"Y"},1,null,{"$f":"IF(CI83=1,VLOOKUP($T$4,AN76:AQ88,4,TRUE),0)","v":721},{"$f":"IF(CI83=1,INDEX(AQ76:AQ88,MATCH($T$2,AO76:AO88,-1)),0)","v":672},"10-230",null,null,0,"10-230"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,312,2.2000000000000002,5.64,508,0.25,null,185,8.6,7.47,672,0.45,null,23,27,8.35,877,0.13,null,116,5,5.65,509,0.21,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,"11-210",{"$f":"-0.0882*T4+19.534","v":9.3909999999999982},null,"Y",{"$f":"IF($T$4<#REF!,\"Y\",\"N\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(CI84=1,VLOOKUP($T$4,#REF!,4,TRUE),0)","v":0},{"$f":"IF(CI84=1,INDEX(#REF!,MATCH($T$2,#REF!,-1)),0)","v":0},"11-210",null,null,0,"11-210"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,347,1.5,5.25,473,0.21,null,208,7.1,7.17,645,0.43,null,46,25,8.32,874,0.25,null,127,0,5.0999999999999996,459,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,6,"14-160",{"$f":"-0.1394*T4+28.957","v":12.926000000000002},null,"Y",{"$f":"IF($T$4<#REF!,\"Y\",\"N\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(CI85=1,VLOOKUP($T$4,#REF!,4,TRUE),0)","v":0},{"$f":"IF(CI85=1,INDEX(#REF!,MATCH($T$2,#REF!,-1)),0)","v":0},"14-160",null,null,0,"14-160"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,381,0.8,4.72,425,0.14000000000000001,null,231,5.4,6.71,604,0.39,null,69,22.6,8.24,865,0.34,105,0,45.5,7.05,740,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,4,"18-160",{"$f":"-0.1566*T4+27.756","v":9.7469999999999999},null,"Y",{"$f":"IF($T$4<AT82,\"Y\",\"N\")","v":"Y"},1,null,{"$f":"IF(CI86=1,VLOOKUP($T$4,AT75:AW82,4,TRUE),0)","v":590},{"$f":"IF(CI86=1,INDEX(AW75:AW82,MATCH($T$2,AU75:AU82,-1)),0)","v":550},"18-160",null,null,3,"18-160"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,416,0,4.51,406,0,null,254,3,5.92,533,0.27,null,92,20,8.08,848,0.41,null,12,44.1,7.15,751,0.13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"30-115",{"$f":"-0.3219*T4+45.118","v":8.099499999999999},null,"N",{"$f":"IF($T$4<AZ85,\"Y\",\"N\")","v":"Y"},{"$f":"IF(AND(CG87=\"Y\",CH87=\"Y\"),1,0)","v":0},null,{"$f":"IF(CI87=1,VLOOKUP($T$4,AZ74:BC85,4,TRUE),0)","v":0},{"$f":"IF(CI87=1,INDEX(BC74:BC85,MATCH($T$2,BA74:BA85,-1)),0)","v":0},"30-115",null,null,0,"30-115"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,105,0,7.2,7.45,782,0,null,277,0,4.84,436,0,null,116,17,7.82,821,0.45,null,23,42.6,7.41,778,0.24,null,null,null,null,null,null,null,null,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":"VLOOKUP(SMALL(CK80:CK87,COUNTIF(CK80:CK87,0)+1),CK80:CM87,3,FALSE)","v":"18-160"},{"$f":"VLOOKUP(SMALL(CL80:CL87,COUNTIF(CL80:CL87,0)+1),CL80:CM87,2,FALSE)","v":"18-160"},null,{"$f":"IF(CI82=1,CD82,IF(CI81=1,CD81,IF(CI87=1,CD87,IF(CI86=1,CD86,IF(CI84=1,CD84,IF(CI85=1,CD85,IF(CI80=1,CD80,IF(CI83=1,CD83,\"ERROR\"))))))))","v":"18-160"},null,{"$f":"SUM(CP80:CP87)","v":3},{"$f":"IF(CP88>0,VLOOKUP(MAX(CP80:CP87),CP80:CQ87,2,FALSE),\"None\")","v":"18-160"}]
[null,null,null,null,null,null,null,null,null,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,6.9,7.53,791,0.06,105,0,18.899999999999999,9.64,1012,0,null,139,13.6,7.46,783,0.45,null,35,40.9,7.7,809,0.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,null,null,null,null,69,6.6,7.53,791,0.11,null,23,18.2,9.65,1013,0.08,null,162,9,6.89,723,0.38,null,46,38.9,7.98,838,0.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,null,null,null,null,"TDH","gpm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,104,6.3,7.53,791,0.15,null,46,17.5,9.67,1015,0.15,null,185,3.3,6.15,646,0.18,null,58,36.5,8.18,859,0.46,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,105,"Volts",null,"Vlookup","Match",null,"Order"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,139,5.9,7.52,790,0.2,null,69,16.8,9.69,1017,0.22,null,208,0,5.55,583,0,null,69,34,8.34,876,0.51,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,"3-425",{"$f":"-0.0108*T4+7.4022","v":6.1601999999999997},null,{"$f":"IF($T$2<CE92,\"Y\",\"N\")","v":"N"},{"$f":"IF($T$4<#REF!,\"Y\",\"N\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(CI92=1,VLOOKUP($T$4,#REF!,4,TRUE),0)","v":0},{"$f":"IF(CI92=1,INDEX(#REF!,MATCH($T$2,#REF!,-1)),0)","v":0},"3-425",null,null,{"$f":"COUNTIF($CK$100:$CN$100,CQ92)","v":0},"3-425"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,173,5.5,7.5,788,0.23,null,92,16,9.68,1016,0.27,120,0,33,9.7200000000000006,1166,0,null,81,31,8.4600000000000009,888,0.53,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,"4-325",{"$f":"-0.0135*T4+7.6821","v":6.1295999999999999},null,{"$f":"IF($T$2<CE93,\"Y\",\"N\")","v":"N"},{"$f":"IF($T$4<AH103,\"Y\",\"N\")","v":"Y"},{"$f":"IF(AND(CG93=\"Y\",CH93=\"Y\"),1,0)","v":0},null,{"$f":"IF(CI93=1,VLOOKUP($T$4,AH88:AK103,4,TRUE),0)","v":0},{"$f":"IF(CI93=1,INDEX(AK88:AK103,MATCH($T$2,AI88:AI103,-1)),0)","v":0},"4-325",null,null,0,"4-325"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,208,5.0999999999999996,7.47,784,0.25,null,116,15.1,9.6199999999999992,1010,0.33,null,23,31,9.6999999999999993,1164,0.12,null,92,27.5,8.48,890,0.54,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,"6-185",{"$f":"-0.042*T4+10.961","v":6.1310000000000002},null,"N",{"$f":"IF($T$4<#REF!,\"Y\",\"N\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(CI94=1,VLOOKUP($T$4,#REF!,4,TRUE),0)","v":0},{"$f":"IF(CI94=1,INDEX(#REF!,MATCH($T$2,#REF!,-1)),0)","v":0},"6-185",null,null,0,"6-185"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,243,4.7,7.43,780,0.28000000000000003,null,139,14.2,9.56,1004,0.41,null,46,29,9.68,1162,0.22,null,104,23.5,8.34,876,0.53,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,"10-230",{"$f":"-0.0493*T4+20.372","v":14.702500000000001},null,"Y",{"$f":"IF($T$4<AN105,\"Y\",\"N\")","v":"Y"},1,null,{"$f":"IF(CI95=1,VLOOKUP($T$4,AN89:AQ105,4,TRUE),0)","v":1016},{"$f":"IF(CI95=1,INDEX(AQ89:AQ105,MATCH($T$2,AO89:AO105,-1)),0)","v":921},"10-230",null,null,0,"10-230"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,277,4.3,7.35,772,0.28999999999999998,null,162,13.3,9.48,995,0.44,null,69,27,9.66,1159,0.3,null,116,19.5,8.06,846,0.5,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,"11-210",{"$f":"-0.076*T4+21.693","v":12.953000000000001},null,"Y",{"$f":"IF($T$4<#REF!,\"Y\",\"N\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(CI96=1,VLOOKUP($T$4,#REF!,4,TRUE),0)","v":0},{"$f":"IF(CI96=1,INDEX(#REF!,MATCH($T$2,#REF!,-1)),0)","v":0},"11-210",null,null,0,"11-210"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,312,3.8,7.23,759,0.28999999999999998,null,185,12.3,9.3699999999999992,984,0.45,null,92,25,9.5500000000000007,1146,0.38,null,127,15,7.73,812,0.44,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,"14-160",{"$f":"-0.1225*T4+32.103","v":18.015500000000003},null,"Y",{"$f":"IF($T$4<#REF!,\"Y\",\"N\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(CI97=1,VLOOKUP($T$4,#REF!,4,TRUE),0)","v":0},{"$f":"IF(CI97=1,INDEX(#REF!,MATCH($T$2,#REF!,-1)),0)","v":0},"14-160",null,null,0,"14-160"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,347,3.3,7.08,743,0.28999999999999998,null,208,11.1,9.2100000000000009,967,0.46,null,116,22.7,9.3800000000000008,1126,0.44,null,139,10,7.35,772,0.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,3,"18-160",{"$f":"-0.1405*T4+31.266","v":15.108499999999996},null,"Y",{"$f":"IF($T$4<AT92,\"Y\",\"N\")","v":"Y"},1,null,{"$f":"IF(CI98=1,VLOOKUP($T$4,AT83:AW92,4,TRUE),0)","v":848},{"$f":"IF(CI98=1,INDEX(AW83:AW92,MATCH($T$2,AU83:AU92,-1)),0)","v":723},"18-160",null,null,2,"18-160"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,381,2.8,6.87,721,0.28000000000000003,null,231,10,9,945,0.46,null,139,20,9.1300000000000008,1096,0.48,null,150,5,6.69,702,0.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,2,"30-115",{"$f":"-0.2815*T4+50.383","v":18.010500000000008},null,"Y",{"$f":"IF($T$4<AZ100,\"Y\",\"N\")","v":"Y"},1,null,{"$f":"IF(CI99=1,VLOOKUP($T$4,AZ86:BC100,4,TRUE),0)","v":876},{"$f":"IF(CI99=1,INDEX(BC86:BC100,MATCH($T$2,BA86:BA100,-1)),0)","v":772},"30-115",null,null,1,"30-115"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,416,2.2000000000000002,6.59,692,0.25,null,254,8.8000000000000007,8.77,921,0.46,null,162,16.8,8.8000000000000007,1056,0.48,null,162,0,6.16,647,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,{"$f":"VLOOKUP(SMALL(CK92:CK99,COUNTIF(CK92:CK99,0)+1),CK92:CM99,3,FALSE)","v":"18-160"},{"$f":"VLOOKUP(SMALL(CL92:CL99,COUNTIF(CL92:CL99,0)+1),CL92:CM99,2,FALSE)","v":"18-160"},null,{"$f":"IF(CI94=1,CD94,IF(CI99=1,CD99,IF(CI98=1,CD98,IF(CI93=1,CD93,IF(CI96=1,CD96,IF(CI97=1,CD97,IF(CI92=1,CD92,IF(CI95=1,CD95,\"ERROR\"))))))))","v":"30-115"},null,{"$f":"SUM(CP92:CP99)","v":3},{"$f":"IF(CP100>0,VLOOKUP(MAX(CP92:CP99),CP92:CQ99,2,FALSE),\"None\")","v":"18-160"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,450,1.5,6.22,953,0.19,null,277,7.4,8.4700000000000006,889,0.43,null,185,13,8.33,1000,0.45,120,0,51.4,8.2200000000000006,986,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,485,0.8,5.76,605,0.12,null,300,5.8,8.02,842,0.39,null,208,8.1,7.87,944,0.34,null,12,50,8.35,1002,0.11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TDH","gpm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,520,0,5.34,561,0,null,323,4,7.34,771,0.32,null,231,2.8,6.97,836,0.15,null,23,48.5,8.61,1033,0.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,120,"Volts",null,"Vlookup","Match",null,"Order"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120,0,8.1999999999999993,8.6999999999999993,1044,0,null,347,1.9,6.52,685,0.18,null,254,0,6.44,773,0,null,35,46.7,8.8699999999999992,1064,0.28999999999999998,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,"4-325",{"$f":"-0.0126*T4+8.6897","v":7.2407000000000004},null,{"$f":"IF($T$2<CE104,\"Y\",\"N\")","v":"N"},{"$f":"IF($T$4<AH122,\"Y\",\"N\")","v":"Y"},{"$f":"IF(AND(CG104=\"Y\",CH104=\"Y\"),1,0)","v":0},null,{"$f":"IF(CI104=1,VLOOKUP($T$4,AH104:AK122,4,TRUE),0)","v":0},{"$f":"IF(CI104=1,INDEX(AK104:AK122,MATCH($T$2,AI104:AI122,-1)),0)","v":0},"4-325",null,null,{"$f":"COUNTIF($CK$109:$CN$109,CQ104)","v":0},"4-325"]
[null,null,null,null,null,null,null,null,null,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,7.9,8.69,1043,0.05,null,370,0,5.77,606,0,null,null,null,null,null,null,null,46,45,9.15,1098,0.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,1,"6-185",{"$f":"-0.0372*T4+12.279","v":8.0010000000000012},null,{"$f":"IF($T$2<CE105,\"Y\",\"N\")","v":"N"},{"$f":"IF($T$4<#REF!,\"Y\",\"N\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(CI105=1,VLOOKUP($T$4,#REF!,4,TRUE),0)","v":0},{"$f":"IF(CI105=1,INDEX(#REF!,MATCH($T$2,#REF!,-1)),0)","v":0},"6-185",null,null,{"$f":"COUNTIF($CK$109:$CN$109,CQ105)","v":0},"6-185"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69,7.6,8.6999999999999993,1044,0.09,null,null,null,null,null,null,null,null,null,null,null,null,null,58,43,9.4,1128,0.41,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,"11-210",{"$f":"-0.0684*T4+24.16","v":16.294},null,"Y",{"$f":"IF($T$4<#REF!,\"Y\",\"N\")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(CI106=1,VLOOKUP($T$4,#REF!,4,TRUE),0)","v":0},{"$f":"IF(CI106=1,INDEX(#REF!,MATCH($T$2,#REF!,-1)),0)","v":0},"11-210",null,null,{"$f":"COUNTIF($CK$109:$CN$109,CQ106)","v":0},"11-210"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,104,7.3,8.7100000000000009,1045,0.14000000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,69,41,9.6199999999999992,1154,0.46,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"18-160",{"$f":"-0.1301*T4+35.563","v":20.601500000000001},null,"Y",{"$f":"IF($T$4<AT104,\"Y\",\"N\")","v":"Y"},{"$f":"IF(AND(CG107=\"Y\",CH107=\"Y\"),1,0)","v":1},null,{"$f":"IF(CI107=1,VLOOKUP($T$4,AT93:AW104,4,TRUE),0)","v":1146},{"$f":"IF(CI107=1,INDEX(AW93:AW104,MATCH($T$2,AU93:AU104,-1)),0)","v":1000},"18-160",null,null,{"$f":"COUNTIF($CK$109:$CN$109,CQ107)","v":2},"18-160"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,139,6.9,8.7200000000000006,1046,0.17,null,null,null,null,null,null,null,null,null,null,null,null,null,81,38.6,9.77,1172,0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"30-115",{"$f":"-0.2554*T4+56.357","v":26.985999999999997},null,"Y",{"$f":"IF($T$4<AZ118,\"Y\",\"N\")","v":"Y"},{"$f":"IF(AND(CG108=\"Y\",CH108=\"Y\"),1,0)","v":1},null,{"$f":"IF(CI108=1,VLOOKUP($T$4,AZ101:BC118,4,TRUE),0)","v":1200},{"$f":"IF(CI108=1,INDEX(BC101:BC118,MATCH($T$2,BA101:BA118,-1)),0)","v":1027},"30-115",null,null,{"$f":"COUNTIF($CK$109:$CN$109,CQ108)","v":1},"30-115"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,173,6.6,8.7100000000000009,1045,0.2,null,null,null,null,null,null,null,null,null,null,null,null,null,92,36,9.91,1189,0.53,null,null,null,null,null,null,null,null,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":"VLOOKUP(SMALL(CK104:CK108,COUNTIF(CK104:CK108,0)+1),CK104:CM108,3,FALSE)","v":"18-160"},{"$f":"VLOOKUP(SMALL(CL104:CL108,COUNTIF(CL104:CL108,0)+1),CL104:CM108,2,FALSE)","v":"18-160"},null,{"$f":"IF(CI105=1,CD105,IF(CI108=1,CD108,IF(CI107=1,CD107,IF(CI106=1,CD106,IF(CI104=1,CD104,\"ERROR\")))))","v":"30-115"},null,{"$f":"SUM(CP104:CP108)","v":3},{"$f":"IF(CP109>0,VLOOKUP(MAX(CP104:CP108),CP104:CQ108,2,FALSE),\"None\")","v":"18-160"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,208,6.2,8.6999999999999993,1044,0.23,null,null,null,null,null,null,null,null,null,null,null,null,null,104,33,10,1200,0.54]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,243,5.8,8.68,1042,0.26,null,null,null,null,null,null,null,null,null,null,null,null,null,116,30,9.98,1198,0.55000000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,277,5.5,8.65,1038,0.28000000000000003,null,null,null,null,null,null,null,null,null,null,null,null,null,127,26.4,9.83,1180,0.54]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,312,5.0999999999999996,8.6,1032,0.28999999999999998,null,null,null,null,null,null,null,null,null,null,null,null,null,139,23,9.59,1151,0.52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,347,4.7,8.51,1021,0.3,null,null,null,null,null,null,null,null,null,null,null,null,null,150,19,9.27,1112,0.48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,381,4.3,8.41,1009,0.3,null,null,null,null,null,null,null,null,null,null,null,null,null,162,15,8.9499999999999993,1074,0.43]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,416,3.8,8.26,991,0.3,null,null,null,null,null,null,null,null,null,null,null,null,null,173,10.7,8.56,1027,0.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,null,null,null,null,450,3.3,8.09,971,0.28999999999999998,null,null,null,null,null,null,null,null,null,null,null,null,null,185,5.5,7.95,954,0.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,null,null,null,null,485,2.8,7.89,947,0.27,null,null,null,null,null,null,null,null,null,null,null,null,null,196,0,7.31,877,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,520,2.2000000000000002,7.59,911,0.23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,554,1.5,7.24,869,0.18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,589,0.8,6.85,822,0.11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,624,0,6.4,768,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["The SDS series pumps may not suitable for your application due to a higher flow rate (GPM) or TDH than the pumps can achive!  SCS type pumps might be tried.  "]
["The SDS series pumps listed below may not be suitable for your application due to a higher required Wattage power.  SCS type pumps might be tried.  "]
["The SCS series may not be suitable due to higher required flow rates(GPM) or TDH or power. Try another type."]
[]
["The pump selected does not work at these requirements!!"]
["The voltage selected does not satisfy the pump requirements!!"]
["Check Power Requirements!!"]

{"sheet":"Array Sizing","index":5,"n_rows":49,"n_cols":46,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,0,0,15],[20,13,20,15],[31,13,31,15],[31,10,31,11],[12,21,12,36],[28,0,28,8],[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],[30,0,31,8],[19,13,19,15]]}
["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 pump requirements (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 at the right bottom of the sheet.",null,null,null,null,null,null,null,null,null,null,null,null,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.0011000000000001},{"$f":"MATCH(SMALL($V$26:$AK$26,1),$V$26:$AK$26,0)","v":11},{"$f":"IFERROR(INDEX($V$12:$AK$12,AN3),0)","v":0},null,{"$f":"IF(AO3>0,INDEX($V$27:$AK$27,AN3),0)","v":0},2]
[null,null,null,null,null,null,"Peak Panel Wattage",{"$f":"'Pump Selection'!T18","v":520},"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":9.0002999999999993},{"$f":"MATCH(SMALL($V$26:$AK$26,2),$V$26:$AK$26,0)","v":3},{"$f":"IFERROR(INDEX($V$12:$AK$12,AN4),0)","v":0},null,{"$f":"IF(AO4>0,INDEX($V$27:$AK$27,AN4),0)","v":0},3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Voltage",{"$f":"H6","v":75},{"$f":"R5","v":75},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":14.000400000000001},{"$f":"MATCH(SMALL($V$26:$AK$26,3),$V$26:$AK$26,0)","v":4},"4v1c",null,5,4]
[null,null,null,null,null,null,"Motor Voltage",{"$f":"'Pump Selection'!T17","v":75},"V",null,null,null,null,null,null,null,"Current",{"$f":"H4/H6","v":6.9333333333333336},{"$f":"R6/0.8","v":8.6666666666666661},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":14.0007},{"$f":"MATCH(SMALL($V$26:$AK$26,4),$V$26:$AK$26,0)","v":7},{"$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":520},{"$f":"R7/0.8","v":650},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":24.000599999999999},{"$f":"MATCH(SMALL($V$26:$AK$26,5),$V$26:$AK$26,0)","v":6},{"$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":520},{"$f":"R8*1.05","v":546},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":39.000900000000001},{"$f":"MATCH(SMALL($V$26:$AK$26,6),$V$26:$AK$26,0)","v":9},0,null,0,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":54.001199999999997},{"$f":"MATCH(SMALL($V$26:$AK$26,7),$V$26:$AK$26,0)","v":12},"4v3c",null,1,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":84.000200000000007},{"$f":"MATCH(SMALL($V$26:$AK$26,8),$V$26:$AK$26,0)","v":2},"2v1c",null,10,9]
["Step 10: Enter your choice from the table below for a solar panel size to use (1-10) :",null,null,null,null,null,null,null,5,null,null,null,null,null,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":94.000799999999998},{"$f":"MATCH(SMALL($V$26:$AK$26,9),$V$26:$AK$26,0)","v":8},"4v2c",null,3,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":{"$error":"#N/A"}},{"$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":"2v1c"},{"$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":0},{"$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":"4v1c"},{"$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":0},{"$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":"4v2c"},{"$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":0},{"$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":"4v3c"},{"$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":"5v3c"},{"$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":"4v4c"},null,{"$f":"SMALL($V$26:$AK$26,10)","v":104.001},{"$f":"MATCH(SMALL($V$26:$AK$26,10),$V$26:$AK$26,0)","v":10},0,null,0]
[null,"Power","Vmp","Imp","length","width","For your choosen PV selection , values would be:",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":104.0013},{"$f":"MATCH(SMALL($V$26:$AK$26,11),$V$26:$AK$26,0)","v":13},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":"4"},{"$f":"INDEX(AO3:AO18,MATCH(I11,AQ3:AQ18,0))","v":"4v1c"},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":154.00049999999999},{"$f":"MATCH(SMALL($V$26:$AK$26,12),$V$26:$AK$26,0)","v":5},0,null,0]
[2,65,17.899999999999999,3.6,40,20,null,null,{"$f":"D26*I14","v":70.8},"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":154.00139999999999},{"$f":"MATCH(SMALL($V$26:$AK$26,13),$V$26:$AK$26,0)","v":14},0,null,0]
[3,80,17.600000000000001,4.5,40,26,"Number of PV Strings (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":"1"},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":204.00149999999999},{"$f":"MATCH(SMALL($V$26:$AK$26,14),$V$26:$AK$26,0)","v":15},"5v3c",null,1]
[4,95,18.5,5.0999999999999996,47.5,21.5,null,null,{"$f":"D27*I16","v":7.9},"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":254.0016},{"$f":"MATCH(SMALL($V$26:$AK$26,15),$V$26:$AK$26,0)","v":16},"4v4c",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":546},{"$f":"MATCH(SMALL($V$26:$AK$26,16),$V$26:$AK$26,0)","v":1},0,null,0]
[6,185,36.200000000000003,5.0999999999999996,62,31,null,null,{"$f":"I15*I17","v":559.32000000000005},"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":550.54164031700009},"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":"4v1c"},"Panel Option Number",null,{"$f":"INDEX(V27:AK27,M22)","v":5},"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,null,null,null,null,"# 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$40<9,INDEX($AP$28:$AP$39,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,null,null,null,"Total Wattage",null,{"$f":"INDEX(U15:U24,M21)*M22","v":560},null,{"$f":"IF($AO$40<8,INDEX($AP$28:$AP$39,2+AT29),\"\")","v":3},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,null,null,null,null,null,null,null,null,{"$f":"IF($AO$40<7,INDEX($AP$28:$AP$39,3+AT30),\"\")","v":10},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]
[null,"The chosen panel Power:",null,{"$f":"LOOKUP(I11,A14:A23,B14:B23)","v":140},"Watts",null,null,null,null,null,"Modules in Series",null,{"$f":"IF(MID(J21,2,1)=\"v\",(MID(J21,1,1)),MID(J21,3,1))","v":"4"},null,{"$f":"IF($AO$40<6,INDEX($AP$28:$AP$39,4+AT31),\"\")","v":""},null,null,null,null,null,"T Watts",{"$f":"MIN(IF((V15:V24>=$S$8),V15:V24))","v":0},{"$f":"MIN(IF((W15:W24>=$S$8),W15:W24))","v":630},{"$f":"MIN(IF((X15:X24>=$S$8),X15:X24))","v":555},{"$f":"MIN(IF((Y15:Y24>=$S$8),Y15:Y24))","v":560},{"$f":"MIN(IF((Z15:Z24>=$S$8),Z15:Z24))","v":700},{"$f":"MIN(IF((AA15:AA24>=$S$8),AA15:AA24))","v":570},{"$f":"MIN(IF((AB15:AB24>=$S$8),AB15:AB24))","v":560},{"$f":"MIN(IF((AC15:AC24>=$S$8),AC15:AC24))","v":640},{"$f":"MIN(IF((AD15:AD24>=$S$8),AD15:AD24))","v":585},{"$f":"MIN(IF((AE15:AE24>=$S$8),AE15:AE24))","v":650},{"$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",13]
[null,"The chosen panel Voltage:",null,{"$f":"LOOKUP(I11,A14:A23,C14:C23)","v":17.7},"Volts",null,null,null,null,null,"Voltage generated",null,{"$f":"(INDEX(C14:C23,M21))*M25","v":70.8}," V",{"$f":"IF($AO$40<5,INDEX($AP$28:$AP$39,5+AT32),\"\")","v":""},null,null,null,null,null,"Excess",{"$f":"ABS(V25-$S$8)","v":546},{"$f":"ABS(W25-$S$8)+0.0002","v":84.000200000000007},{"$f":"ABS(X25-$S$8)+0.0003","v":9.0002999999999993},{"$f":"ABS(Y25-$S$8)+0.0004","v":14.000400000000001},{"$f":"ABS(Z25-$S$8)+0.0005","v":154.00049999999999},{"$f":"ABS(AA25-$S$8)+0.0006","v":24.000599999999999},{"$f":"ABS(AB25-$S$8)+0.0007","v":14.0007},{"$f":"ABS(AC25-$S$8)+0.0008","v":94.000799999999998},{"$f":"ABS(AD25-$S$8)+0.0009","v":39.000900000000001},{"$f":"ABS(AE25-$S$8)+0.001","v":104.001},{"$f":"ABS(AF25-$S$8)+0.0011","v":4.0011000000000001},{"$f":"ABS(AG25-$S$8)+0.0012","v":54.001199999999997},{"$f":"ABS(AH25-$S$8)+0.0013","v":104.0013},{"$f":"ABS(AI25-$S$8)+0.0014","v":154.00139999999999},{"$f":"ABS(AJ25-$S$8)+0.0015","v":204.00149999999999},{"$f":"ABS(AK25-$S$8)+0.0016","v":254.0016},null,"+/- current",0.8]
[null,"The chosen panel Current:",null,{"$f":"LOOKUP(I11,A14:A23,D14:D23)","v":7.9},"Amps",null,null,null,null,null,"Modules in Parallel",null,{"$f":"IF(MID(J21,4,1)=\"c\",(MID(J21,3,1)),MID(J21,1,1))","v":"1"},null,{"$f":"IF($AO$40<4,INDEX($AP$28:$AP$39,6+AT33),\"\")","v":""},null,null,null,null,null,"Rows",{"$f":"MATCH(V25,V15:V24,0)","v":{"$error":"#N/A"}},{"$f":"MATCH(W25,W15:W24,0)","v":10},{"$f":"MATCH(X25,X15:X24,0)","v":6},5,5,{"$f":"MATCH(AA25,AA15:AA24,0)","v":4},{"$f":"IF(AK30=0,0,MATCH(AB25,AB15:AB24,0))","v":0},3,2,2,{"$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":7.9}," A",{"$f":"IF($AO$40<3,INDEX($AP$28:$AP$39,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$39,MATCH(LARGE($AO$28:$AO$39,1),$AO$28:$AO$39,0))","v":1},{"$f":"COUNTIF($AQ$3:$AQ$18,AN28)","v":3},null,{"$f":"IF($M$21=AP28,1,0)","v":0},{"$f":"SUM(AS28)","v":0}]
["NOTE: A pump controller will be needed to control the PV and on/off float valves. ",null,null,null,null,null,null,null,null,null,"Actual power generated",null,{"$f":"M28*M26","v":559.32000000000005}," W",{"$f":"IF($AO$40<2,INDEX($AP$28:$AP$39,8+AT35),\"\")","v":""},null,null,null,null,null,null,"Col.",{"$f":"MATCH(MIN(V26:AK26),V26:AK26,0)","v":11},null,"Row ",{"$f":"INDEX(V27:AL27,1,W29)","v":0},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":9.0000000000000006E-5},{"$f":"INDEX($AN$28:$AN$39,MATCH(LARGE($AO$28:$AO$39,2),$AO$28:$AO$39,0))","v":3},{"$f":"COUNTIF($AQ$3:$AQ$18,AN29)","v":0},null,{"$f":"IF($M$21=AP29,1,0)","v":0},{"$f":"SUM(AS28:AS29)","v":0}]
["These are selected to marry with a particular pump type and size.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AO$40<1,INDEX($AP$28:$AP$39,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":1.0000800000000001},{"$f":"INDEX($AN$28:$AN$39,MATCH(LARGE($AO$28:$AO$39,3),$AO$28:$AO$39,0))","v":5},1,null,1,{"$f":"SUM(AS28:AS30)","v":1}]
["Step 11: 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 size recommended",null,{"$f":"IFERROR(H45,\"None\")","v":"Wire 8"},null,{"$f":"IF($AO$40<0,INDEX($AP$28:$AP$39,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":6.9999999999999994E-5},{"$f":"INDEX($AN$28:$AN$39,MATCH(LARGE($AO$28:$AO$39,4),$AO$28:$AO$39,0))","v":10},0,null,0,{"$f":"SUM(AS28:AS31)","v":1}]
[null,null,null,null,null,null,null,null,null,null,"Wire power losses",null,{"$f":"IF(M31=\"Wire 12\",H40,IF(M31=\"Wire 10\",I40,IF(M31=\"Wire 8\",J40,IF(M31=\"Wire 6\",K40,IF(M31=\"Wire 4\",L40,0)))))","v":1.5694700141242936E-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$39,MATCH(LARGE($AO$28:$AO$39,5),$AO$28:$AO$39,0))","v":2},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\",H42,IF(M31=\"Wire 10\",I42,IF(M31=\"Wire 8\",J42,IF(M31=\"Wire 6\",K42,IF(M31=\"Wire 4\",L42,0)))))","v":2.1722768361581921E-2},null,0.03,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$39,MATCH(LARGE($AO$28:$AO$39,6),$AO$28:$AO$39,0))","v":4},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,null,null,null,null,null,0,{"$f":"SUM(AS28:AS34)","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,null,null,null,null,null,0,{"$f":"SUM(AS28:AS35)","v":1}]
[null,null,null,null,null,null,null,"Wire 12","Wire 10","Wire 8","Wire 6","Wire 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,7,{"$f":"IF(AQ36>0,1.00004,0.00004)","v":4.0000000000000003E-5},{"$f":"INDEX($AN$28:$AN$39,MATCH(LARGE($AO$28:$AO$39,7),$AO$28:$AO$39,0))","v":6},0,null,0,{"$f":"SUM(AS28:AS36)","v":1}]
["Distance from PV to Switch",null,null,0,null,null,"Wire Resistance",{"$f":"(($D$40)*2)*0.1588/100","v":0.49228},{"$f":"(($D$40)*2)*0.0999/100","v":0.30969000000000002},{"$f":"(($D$40)*2)*0.0628/100","v":0.19467999999999999},{"$f":"(($D$40)*2)*0.0395/100","v":0.12245},{"$f":"(($D$40)*2)*0.0249/100","v":7.7189999999999995E-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,8,{"$f":"IF(AQ37>0,1.00003,0.00003)","v":3.0000000000000001E-5},{"$f":"INDEX($AN$28:$AN$39,MATCH(LARGE($AO$28:$AO$39,8),$AO$28:$AO$39,0))","v":7},0,null,0,{"$f":"SUM(AS28:AS37)","v":1}]
["Distance from PV to Well",null,null,50,null,null,"Total Resistance",{"$f":"D43+H37","v":11.309587692307691},{"$f":"D43+I37","v":11.126997692307691},{"$f":"D43+J37","v":11.011987692307692},{"$f":"D43+K37","v":10.939757692307692},{"$f":"D43+L37","v":10.894497692307691},null,null,null,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(AQ38>0,1.00002,0.00002)","v":2.0000000000000002E-5},{"$f":"INDEX($AN$28:$AN$39,MATCH(LARGE($AO$28:$AO$39,9),$AO$28:$AO$39,0))","v":8},0,null,0,{"$f":"SUM(AS28:AS38)","v":1}]
[" Pump Depth",null,null,{"$f":"'Total Dynamic Head'!J3+'Total Dynamic Head'!J4","v":105},null,null,"Power Losses",{"$f":"((($D$27*$I$16)*0.85)^2)*H37","v":22.197508243000001},{"$f":"((($D$27*$I$16)*0.85)^2)*I37","v":13.964301470250001},{"$f":"((($D$27*$I$16)*0.85)^2)*J37","v":8.7783596829999997},{"$f":"((($D$27*$I$16)*0.85)^2)*K37","v":5.5214205012500006},{"$f":"((($D$27*$I$16)*0.85)^2)*L37","v":3.4805916577499998},null,null,null,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(AQ39>0,1.00001,0.00001)","v":1.0000100000000001},{"$f":"INDEX($AN$28:$AN$39,MATCH(LARGE($AO$28:$AO$39,10),$AO$28:$AO$39,0))","v":9},1,null,0,{"$f":"SUM(AS28:AS39)","v":1}]
["Total Wire Length",null,null,{"$f":"SUM(D37:D39)","v":155},null,null,"Percentage",{"$f":"H39/(D26*D27*I18)","v":3.968659844632768E-2},{"$f":"I39/(D26*D27*I18)","v":2.4966569173728814E-2},{"$f":"J39/(D26*D27*I18)","v":1.5694700141242936E-2},{"$f":"K39/(D26*D27*I18)","v":9.8716664901129948E-3},{"$f":"L39/(D26*D27*I18)","v":6.2228986228813551E-3},null,null,null,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:AO39,\"<1\")","v":6},1]
[null,null,null,null,null,null,"Voltage Losses",{"$f":"H37*$D$27*$I$16","v":3.8890120000000001},{"$f":"I37*$D$27*$I$16","v":2.4465510000000004},{"$f":"J37*$D$27*$I$16","v":1.5379719999999999},{"$f":"K37*$D$27*$I$16","v":0.96735500000000008},{"$f":"L37*$D$27*$I$16","v":0.60980100000000004}]
[null,null,null,null,null,null,"Percentage",{"$f":"((($D$27*$I$16)*H37))/($D$26*$I$14)","v":5.4929548022598876E-2},{"$f":"((($D$27*$I$16)*I37))/($D$26*$I$14)","v":3.4555805084745768E-2},{"$f":"((($D$27*$I$16)*J37))/($D$26*$I$14)","v":2.1722768361581921E-2},{"$f":"((($D$27*$I$16)*K37))/($D$26*$I$14)","v":1.3663206214689267E-2},{"$f":"((($D$27*$I$16)*L37))/($D$26*$I$14)","v":8.6130084745762725E-3}]
["Pump Resistance",null,null,{"$f":"((H6^2)/H4)","v":10.817307692307692},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"}]
["Float Valve Resistance",null,null,0]
["Controller Resistance",null,null,0,null,null,"Wire Size recommended",{"$f":"IF(AND(H43=\"Acceptable\",H42<O33),\"Wire 12\",IF(AND(I42<O33,I43=\"Acceptable\"),\"Wire 10\",IF(AND(J42<O33,J43=\"Acceptable\"),\"Wire 8\",IF(AND(K42<O33,K43=\"Acceptable\"),\"Wire 6\",IF(AND(L42<O33,L43=\"Acceptable\"),\"Wire 4\",\"Too much power losses\")))))","v":"Wire 8"},"or bigger"]
[null,null,null,null,null,"Acceptable Percentage Losses"]
[null,null,null,null,null,null,null,null,null,"*Copper"]
[]
["WARNING!: The option that you have selected is not suitable to satisfy the system power requirements. This could be because the array configuration that satisfies the voltage and power requirements generates a larger amount of power than required and best configurations are available with other panels."]

{"sheet":" Design Spec","index":6,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,5],[25,1,25,3],[25,4,25,5],[28,1,28,3],[28,4,28,5],[13,0,24,0]]}
["Design Specification Summary  ( est. 2012 dollar amounts)*"]
[]
["Item","Description",null,"Quantity","~","Price"]
["Submersible solar water pump by Sun Pumps",{"$f":"'Pump Selection'!T16","v":"SCS-10-230"},null,1,null,{"$f":"IF(B4=\"SDS-Q-128\",820,IF(B4=\"SDS-Q-135\",820,IF(B4=\"SDS-T-135\",530,IF(B4=\"SCS-18-45\",1950,IF(B4=\"SCS-12-95\",1700,IF(B4=\"SCS-3-200\",2000,IF(B4=\"SCS-8-90\",1600,IF(B4=\"SCS-18-160\",1900,IF(B4=\"SCS-4-325\",2100,IF(B4=\"SCS-6-185\",1750,IF(B4=\"SCS-10-230\",2100,IF(B4=\"SCS-11-120\",1980,IF(B4=\"SCS-14-160\",2050,IF(B4=\"SCS-30-115\",2075,IF(B4=\"SCS-3-425\",2200,0)))))))))))))))","v":2100}]
["PV Solar Module(s) with j/box ","with a chosen Wattage Size of",{"$f":"'Array Sizing'!D25","v":140},{"$f":"'Array Sizing'!I18","v":4},null,{"$f":"2.5*C5*D5","v":1400}]
["Fixed PV Rack System",null,null,{"$f":"IF(D7=1,0,1)","v":1},null,{"$f":"IF(D5=1,250,IF(D5=2, 300,IF(D5=3,550,IF(D5=4,800,1000))))*D6","v":800}]
["Tracker system","1-Axis Tracker System",null,{"$f":"IF('Solar Resource'!$K$6=\"1-Axis Tracker\",1,0)","v":0},null,{"$f":"('Array Sizing'!$D$27*'Array Sizing'!$D$26*'Array Sizing'!$I$18)*2.3*D7","v":0}]
["DC Solar Pump Controller & float level controller","The specific size and type is dependent on Pump Voltage and should be sized accordingly",{"$f":"IF('Pump Selection'!T17<31,\"15-30V\",IF('Pump Selection'!T17<61,\"30-60V\",IF('Pump Selection'!T17<71,\"30-60V\",IF('Pump Selection'!T17<91,\"60-90V\",IF('Pump Selection'!T17<121,\"90-120V\",\"?\")))))","v":"60-90V"},1,null,400]
[{"$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\")))))","v":"#8 UF wire"},"AWG sized wire for PV-Pump",null,{"$f":"'Array Sizing'!$D$40*1.25","v":193.75},"ft",{"$f":"IF(D9<250,200,400)","v":200}]
["Solid copper ground rod",null,null,8,"ft",25]
["PVC pipe",{"$f":"'Total Dynamic Head'!$J$12","v":1},"in",{"$f":"'Total Dynamic Head'!$J$10+10","v":160},"ft",{"$f":"(ROUNDUP(D11,0)/10)*5","v":80}]
["Plastic Storage Tank",{"$f":"ROUNDUP(('Daily Water Requirement'!N31),-3)","v":9000},"gallons",1,null,{"$f":"B12*0.5","v":4500}]
["Fuse Breaker",null,null,1,null,60]
["Pipe Fittings","Globe Valve, Fully Open",null,{"$f":"'Total Dynamic Head'!J18","v":1},null,{"$f":"D14*10","v":10}]
[null,"Gate Valve, Fully Open",null,{"$f":"'Total Dynamic Head'!J19","v":1},null,{"$f":"D15*20","v":20}]
[null,"Gate Valve, 3/4 Open",null,{"$f":"'Total Dynamic Head'!J20","v":0},null,{"$f":"D16*20","v":0}]
[null,"Gate Valve, 1/2 Open",null,{"$f":"'Total Dynamic Head'!J21","v":0},null,{"$f":"D17*20","v":0}]
[null,"Butterfly Valve",null,{"$f":"'Total Dynamic Head'!J22","v":0},null,{"$f":"D18*20","v":0}]
[null,"Swing Check Valve, Fully Open",null,{"$f":"'Total Dynamic Head'!J23","v":1},null,{"$f":"D19*20","v":20}]
[null,"In-Line Ball Check Valve, Fully Open",null,{"$f":"'Total Dynamic Head'!J24","v":0},null,{"$f":"D20*40","v":0}]
[null,"90 Degree Standard Elbow",null,{"$f":"'Total Dynamic Head'!J25","v":1},null,{"$f":"D21*1.5","v":1.5}]
[null,"45 Degree Standard Elbow",null,{"$f":"'Total Dynamic Head'!J26","v":0},null,{"$f":"D22*1.75","v":0}]
[null,"90 Degree Street Elbow",null,{"$f":"'Total Dynamic Head'!J27","v":0},null,{"$f":"D23*1.5","v":0}]
[null,"Standard Tee, Flow Through Run",null,{"$f":"'Total Dynamic Head'!J28","v":0},null,{"$f":"D24*1.75","v":0}]
[null,"Standard Tee, Flow Through Branch",null,{"$f":"'Total Dynamic Head'!J29","v":0},null,{"$f":"D25*1.75","v":0}]
[{"$f":"TODAY()","v":"2014-01-29"},"Grand Total of the System",null,null,{"$f":"SUM(F4:F25)","v":9616.5}]
["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":"E26*(1-(C27+C28))","v":5769.9}]
["For specific state tax credits visit the link:","http://www.dsireusa.org/"]
[]
[]
[]
[]
[]
[]
["http://www.dsireusa.org/"]

{"sheet":"Conclusion","index":7,"n_rows":29,"n_cols":16,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,12],[28,7,28,8],[27,0,27,3],[27,7,27,8],[17,15,22,17]]}
[" Simplified sketch of an example system (not your specs)"]
["Before exiting, print any sheets that you will need. Contact your extension agent if you have any questions."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND('Solar Resource'!K4=\"Summer\",G29<L28),\"System configuration is for Summer only. Your water requirements will NOT be satisfied during the WINTER season.\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
["References: Diagrams are from Masters, G. M. (2004). Renewable and Efficient Electric Power Systems. Hoboken: John Wiley & Sons, Inc."]
["Actual Water Pumped on a Full Sun day in",null,null,null,"Summer","is:",{"$f":"IF(OR('Pump Selection'!$T$16=\"Q-128\",'Pump Selection'!$T$16=\"Q-135\",'Pump Selection'!$T$16=\"T-128\"),('Array Sizing'!$D$26*'Array Sizing'!$D$27*'Array Sizing'!$I$18*'Solar Resource'!AF13*60*'Pump Selection'!$E$19*'Pump Selection'!#REF!)/(0.1885*'Total Dynamic Head'!$L$34),('Array Sizing'!$D$26*'Array Sizing'!$D$27*'Array Sizing'!$I$18*'Solar Resource'!AF13*60*'Pump Selection'!$E$19*'Pump Selection'!$E$16)/(0.1885*'Total Dynamic Head'!$L$34))","v":3792.4102059739366},"Gallons per Day",null,"for required water of: ",null,{"$f":"'Daily Water Requirement'!$N$28","v":2734.25},"Gallons per Day"]
["Actual Water Pumped on a Full Sun day in",null,null,null,"Winter","is: ",{"$f":"IF(OR('Pump Selection'!$T$16=\"Q-128\",'Pump Selection'!$T$16=\"Q-135\",'Pump Selection'!$T$16=\"T-128\"),('Array Sizing'!$D$26*'Array Sizing'!$D$27*'Array Sizing'!$I$18*'Solar Resource'!AF12*60*'Pump Selection'!$E$19*'Pump Selection'!#REF!)/(0.1885*'Total Dynamic Head'!$L$34),('Array Sizing'!$D$26*'Array Sizing'!$D$27*'Array Sizing'!$I$18*'Solar Resource'!AF12*60*'Pump Selection'!$E$19*'Pump Selection'!$E$16)/(0.1885*'Total Dynamic Head'!$L$34))","v":3201.8364029062395},"Gallons per Day"]