{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Solar Calculator"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Solar Calculator","index":0,"n_rows":57,"n_cols":12,"rows_kept":57,"cut":false,"hidden":false,"merged":[[1,1,1,7],[3,1,3,7],[5,1,5,5]]}
[]
[null,"AUTOMATIC SOLUTIONS SOLAR CALCULATOR"]
[]
[null,"The solar calculator will determine your intended current use and recommend a battery and solar panel combination. First choose 12 or 24 volts. Next enter on each line the item description, amps at standy by, amps during use and minutes of use per day (duty cycle). You can get the amps at standy by and amps during use from our website for each item. To calculate duty cycle simply multiply the estimated uses per day by the time being used. Example - If we have a pair of swing gates that will open about 10 times per day and they take 15 seconds to open our calculation of duty cycle would be - .5 (.25 minute open plus .25 minute close) X 10 (number of times perday) = 5 minutes of use per day."]
[]
[null,"TO START CHOOSE VOLTAGE HERE >>>>>>>>",null,null,null,null,null,12,null,null,12,24]
[]
[null,"ITEM",null,"AMPS @",null,"AMPS @",null,"DUTY CYCLE",null,null," "]
[null,"DESCRIPTION",null,"STANDBY",null,"USE",null,"MINUTES"]
[]
[null," ",null,0,null,0," ",0,null,null,{"$f":"($D11*24)+($F11*($H11/60))","v":0},{"$f":"($D11*24)+($F11*($H11/60))","v":0}]
[null," "]
[null," ",null,0,null,0,null,0,null,null,{"$f":"($D13*24)+($F13*($H13/60))","v":0},{"$f":"($D13*24)+($F13*($H13/60))","v":0}]
[null," ",null," "]
[null," ",null,0,null,0,null,0,null,null,{"$f":"($D15*24)+($F15*($H15/60))","v":0},{"$f":"($D15*24)+($F15*($H15/60))","v":0}]
[null," ",null," "]
[null," ",null,0,null,0,null,0,null,null,{"$f":"($D17*24)+($F17*($H17/60))","v":0},{"$f":"($D17*24)+($F17*($H17/60))","v":0}]
[null," "]
[null," ",null,0,null,0,null,0,null,null,{"$f":"($D19*24)+($F19*($H19/60))","v":0},{"$f":"($D19*24)+($F19*($H19/60))","v":0}]
[null," "]
[null," ",null,0,null,0,null,0,null,null,{"$f":"($D21*24)+($F21*($H21/60))","v":0},{"$f":"($D21*24)+($F21*($H21/60))","v":0}]
[null," "]
[null," ",null,0,null,0,null,0,null,null,{"$f":"($D23*24)+($F23*($H23/60))","v":0},{"$f":"($D23*24)+($F23*($H23/60))","v":0}]
[null," "]
[null," ",null,0,null,0,null,0,null,null,{"$f":"($D25*24)+($F25*($H25/60))","v":0},{"$f":"($D25*24)+($F25*($H25/60))","v":0}]
[null," "]
[null," ",null,0,null,0,null,0,null,null,{"$f":"($D27*24)+($F27*($H27/60))","v":0},{"$f":"($D27*24)+($F27*($H27/60))","v":0}]
[null," "]
[null," ",null,0,null,0,null,0,null,null,{"$f":"($D29*24)+($F29*($H29/60))","v":0},{"$f":"($D29*24)+($F29*($H29/60))","v":0}]
[null," "]
[null," ",null,0,null,0,null,0,null,null,{"$f":"($D31*24)+($F31*($H31/60))","v":0},{"$f":"($D31*24)+($F31*($H31/60))","v":0}]
[null," "]
[null," ",null,0,null,0,null,0,null,null,{"$f":"($D33*24)+($F33*($H33/60))","v":0},{"$f":"($D33*24)+($F33*($H33/60))","v":0}]
[null," "]
[null," ",null,0,null,0,null,0,null,null,{"$f":"($D35*24)+($F35*($H35/60))","v":0},{"$f":"($D35*24)+($F35*($H35/60))","v":0}]
[null," "]
[null," ",null,0,null,0,null,0,null,null,{"$f":"($D37*24)+($F37*($H37/60))","v":0},{"$f":"($D37*24)+($F37*($H37/60))","v":0}]
[null," "]
[null," ",null,0,null,0,null,0,null,null,{"$f":"($D39*24)+($F39*($H39/60))","v":0},{"$f":"($D39*24)+($F39*($H39/60))","v":0}]
[null," "]
[null," ",null,0,null,0,null,0,null,null,{"$f":"($D41*24)+($F41*($H41/60))","v":0},{"$f":"($D41*24)+($F41*($H41/60))","v":0}]
[null," "]
[null," ",null,0,null,0,null,0,null,null,{"$f":"($D43*24)+($F43*($H43/60))","v":0},{"$f":"($D43*24)+($F43*($H43/60))","v":0}]
[null," "]
[null," ",null,0,null,0,null,0,null,null,{"$f":"($D45*24)+($F45*($H45/60))","v":0},{"$f":"($D45*24)+($F45*($H45/60))","v":0}]
[null," "]
[null," ",null,0,null,0,null,0,null,null,{"$f":"($D47*24)+($F47*($H47/60))","v":0},{"$f":"($D47*24)+($F47*($H47/60))","v":0}]
[null," "]
[null," ",null,0,null,0,null,0,null,null,{"$f":"($D49*24)+($F49*($H49/60))","v":0},{"$f":"($D49*24)+($F49*($H49/60))","v":0}]
[null," "]
[null," ",null,0,null,0,null,0,null,null,{"$f":"($D51*24)+($F51*($H51/60))","v":0},{"$f":"($D51*24)+($F51*($H51/60))","v":0}]
[]
[null,"TOTAL AMPS USED EACH DAY - ",null,{"$f":"IF(H6=12, K53, L53)","v":0},null,null,null,"`",null,null,{"$f":"SUM(K11:K51)","v":0},{"$f":"SUM(L11:L51)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null," "]
[null,"SUGGESTED 12V SOLAR PANELS - ",{"$f":"IF(H6=12, \"1\", \"2\")","v":"1"},{"$f":"IF(K55=0, \" \", IF(K55<=10,\"10 WATT\", IF(K55<=25, \"25 WATT\", IF(K55<=60, \"60 WATT\", IF(K55<=120, \"120 WATT\", \"CHECK\")))))","v":" "},null,null,null,null,null,null,{"$f":"((D53/5)*H6)*1.33","v":0}," "]
[]
[null,"SUGGESTED 12V BATTERIES -",{"$f":"IF(H6=12, \"1\", \"2\")","v":"1"},{"$f":"IF(K57=0,\" \",IF(K57<=7,\"7AH\",IF(K57<=26,\"26AH\",IF(K57<=70,\"70AH\",IF(K57<=100,\"100AH\",IF(K57<=140,\"140AH\",IF(K57<=200,\"200AH\",\"CHECK\")))))))","v":" "}," ",null,null,null,null,null,{"$f":"D53*1.1*10","v":0}," "]