{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Solar Prices KE"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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 Prices KE","index":0,"n_rows":38,"n_cols":20,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,0,37,3],[1,2,1,16],[11,2,11,15],[36,5,36,15],[34,5,34,15],[27,5,27,15],[28,5,28,15],[29,5,29,15],[30,5,30,15],[31,5,31,15],[32,5,32,15],[33,5,33,15],[35,5,35,15]]}
[]
[null,null,"Motor Size"]
["Component","Unit","1.1kW","1.5kW","2.2kW","3kW","4kW","5.5kW","7.5kW","9.2kW","11kW","13kW","15kW","18.5kW","22kW","30kW","37kW"]
["Pump ","Watt",0.39196880570409981,0.3206122004357298,0.33801307189542484,0.38020065359477123,0.38584068627450979,0.34743358288770054,0.37401777777777773,0.39262659846547315,0.35756316102198449,0.37454012066365006,0.32709901960784316,0.28220832008479069,0.2676907308377896,0.21800653594771241,0.21520749958883836]
["Inverter - Grundfos","Watt",1.0686562948205856,0.78368128286842931,0.53432814741029278,0.44211337879698681,0.35585826343226318,0.2700754435925915,0.20039715503471944,0.16931757266989378,0.14161106077845662,0.13698820072731607,0.11872310729700726,0.11608471875147734,0.10850933728883497,9.3587285772100959E-2,9.3777592710975854E-2]
["DC Accessories ","Watt",0.52600018732855258,0.38573347070760522,0.26300009366427629,0.19286673535380261,0.17272753871410881,0.13277425852101446,0.10445144800789116,0.11770530005300031,9.8444432771600268E-2,0.10834124886022976,9.743757822510607E-2,8.1875195220010563E-2,0.10720410151873581,9.1907110588878307E-2,8.8206242157926357E-2]
["Cables & Low level ","m",6.1047973856209152,6.1047973856209152,6.1047973856209152,6.8596993464052289,6.8596993464052289,11.93813071895425,15.369503267973855,15.369503267973855,15.369503267973855,15.369503267973855,23.687150326797386,23.687150326797386,28.230287581699347,28.230287581699347,28.230287581699347]
["GI pipes & Well head ","m",9.2622549019607838,9.1307189542483655,9.1307189542483655,9.1307189542483655,10.415441176470589,11.186274509803923,11.568627450980392,11.568627450980392,16.750816993464053,15.58578431372549,19.341911764705884,35.87091503267974,29.484477124183009,35.87091503267974,46.990196078431374]
["Solar Modules ","Watt",0.80882352941176472,0.80882352941176483,0.80882352941176483,0.80882352941176483,0.80882352941176472,0.80882352941176472,0.80882352941176472,0.80882352941176472,0.80882352941176483,0.80882352941176472,0.80882352941176472,0.80882352941176472,0.80882352941176472,0.80882352941176472,0.80882352941176472,null,null,{"$f":"480/6","v":80}]
["Support Structure ","Watt",0.33398692810457514,0.33398692810457514,0.33398692810457514,0.33398692810457514,0.33398692810457514,0.33398692810457514,0.33398692810457514,0.33398692810457514,0.33398692810457514,0.33398692810457514,0.33398692810457514,0.33398692810457514,0.33398692810457514,0.33398692810457514,0.33398692810457514]
[]
[null,null,"Motor Size"]
["Component","Unit","1.1kW","1.5kW","2.2kW","3kW","4kW","5.5kW","7.5kW","9.2kW","11kW","13kW","15kW","18.5kW","22kW","30kW"]
["Pump ","Watt",0.39196880570409981,0.3206122004357298,0.33801307189542484,0.38020065359477123,0.38584068627450979,0.34743358288770054,0.37401777777777773,0.39262659846547315,0.35756316102198449,0.37454012066365006,0.32709901960784316,0.28220832008479069,0.2676907308377896,0.21800653594771241]
["Inverter - Lorentz","Watt",2.3561051693404633,1.7278104575163398,1.1780525846702317,0.86390522875816989,0.64793235294117646,0.47122103386809266,0.47758666666666666,0.54936125319693085,0.4594670231729055,0.42958989441930617,0.37231215686274505,0.33694297827239,0.30508458110516934,0.22372869281045751]
["DC Accessories ","Watt",0.48053895354933418,0.35239523260284505,0.24026947677466709,0.17619761630142253,0.1321482122260669,9.610779070986683E-2,7.0479046520569008E-2,5.7455744446116043E-2,4.8053895354933415E-2,6.1311329961848994E-2,5.3136485966935793E-2,4.308363727048848E-2,3.6229422250183496E-2,3.5516724336793537E-2]
["Cables & Low level ","m",6.1047973856209152,6.1047973856209152,6.1047973856209152,6.8596993464052289,6.8596993464052289,11.93813071895425,15.369503267973855,15.369503267973855,15.369503267973855,15.369503267973855,23.687150326797386,23.687150326797386,28.230287581699347,28.230287581699347]
["GI pipes & Well head ","m",9.2622549019607838,9.1307189542483655,9.1307189542483655,9.1307189542483655,10.415441176470589,11.186274509803923,11.568627450980392,11.568627450980392,16.750816993464053,15.58578431372549,19.341911764705884,35.87091503267974,29.484477124183009,35.87091503267974]
["Solar Modules ","Watt",0.80882352941176472,0.80882352941176483,0.80882352941176483,0.80882352941176483,0.80882352941176472,0.80882352941176472,0.80882352941176472,0.80882352941176472,0.80882352941176483,0.80882352941176472,0.80882352941176472,0.80882352941176472,0.80882352941176472,0.80882352941176472]
["Support Structure ","Watt",0.33398692810457514,0.33398692810457514,0.33398692810457514,0.33398692810457514,0.33398692810457514,0.33398692810457514,0.33398692810457514,0.33398692810457514,0.33398692810457514,0.33398692810457514,0.33398692810457514,0.33398692810457514,0.33398692810457514,0.33398692810457514]
[]
["Example:"]
["Duty of 8m3/h at 220m head"]
["Grundfos SP 9-40, 6\""]
["Grundfos Inverter"]
["7.5 kW Motor"]
[]
["Component","Unit","Qty","Unit Price","Total Price","Comments"]
["Pump","Watt",7500,0.37401777777777773,{"$f":"D29*C29","v":2805.1333333333328},"Motor rating of the pump"]
["Inverter","Watt",{"$f":"C29","v":7500},0.20039715503471944,{"$f":"D30*C30","v":1502.9786627603958},"Corresponds to the motor rating"]
["DC Accessories","Watt",{"$f":"C34","v":13500},0.10445144800789116,1410.0945481065307,"Based on the solar generator size"]
["Cables & Low level","m",250,15.369503267973855,3842.3758169934636,"Total cable length from pump to the controller"]
["GI pipes & Well head cover","m",250,11.568627450980392,2892.1568627450979,"Pump setting depth, based on PVC borehole pipes"]
["Solar Modules ","Watt",{"$f":"C29*1.8","v":13500},0.80882352941176472,10919.117647058823,"Solar generator size. Price is based on polycrystalline modules"]
["Support Structure ","Watt",{"$f":"C34","v":13500},0.33398692810457514,4508.8235294117649,"Corresponds to the solar generator size. Price is for a mild steel 3m high support structure"]
["Transport ","km",700,2,{"$f":"D36*C36","v":1400},"One way distance to site"]
["Installation","days",16,200,{"$f":"D37*C37","v":3200},"General guide: Upto 3.0kW allow 5-7days, 4.0-5.5kW allow 10-14days, 7.5-11kW allow 16days, above 11kW allow 20-30 days"]
["Total Price",null,null,null,{"$f":"SUM(E29:E37)","v":32480.680400409412}]