{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Sheet1","index":0,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,1,6,1],[4,2,6,2],[4,4,6,4],[4,8,6,8]]}
[]
[null,"Estimate of the Solar Operated Drinking Water Project of ONE Village, Block- Gogunda, District-Udaipur"]
[null,"Unit Cost"]
[]
[null,"Sr. No.","Budget Head","Volume","Rate (Rs)","Total Cost","Local Contribution","Total Grant Required","Amount in US$"]
[null,null,null,"(cum)/",null,"(Rs)","(Rs)","(Rs)"]
[null,null,null,"Unit no."]
[null,1,2,3,4,5,6,7]
[null,1,"Drilling of New bore well","300 ft.",75,22500]
[null,2,"Kasing pipe ","20 ft",200,{"$f":"+E10*20","v":4000}]
[null,null,"Sub total",null,null,{"$f":"+F9+F10","v":26500},{"$f":"+F11*0.15","v":3975},{"$f":"+F11-G11","v":22525},{"$f":"+H11/58","v":388.36206896551727}]
[null,2,"Solar Submersible Pump SQF 5A suitable for 35 meters total head and water discharge for 40,000 LPD",1,96750,96750]
[null,null,"1380 W Solar Panels along with mounting structure","1 set",89700,89700]
[null,null,"Rotary Switch",1,1200,1200]
[null,null,"40 mm HDPE Riser Pipe – 40 meter",1,2500,2500]
[null,null,"3 core 2.5 sq.mm Power Cable –60 mtr",1,3800,3800]
[null,null,"Necessary fittings",1,5500,5500]
[null,null,"Transportation",1,25000,25000]
[null,null,"Installation",1,25000,25000]
[null,null,"Sub total",null,null,{"$f":"SUM(F12:F19)","v":249450},{"$f":"+F20*0.15","v":37417.5},{"$f":"+F20-G20","v":212032.5},{"$f":"+H20/58","v":3655.7327586206898}]
[null,3,"Construction of Water Storage Tank","8000 liters capacity",null,80000,12000,{"$f":"+F21-G21","v":68000}]
[null,null,"Supervision ",null,null,3000,450,{"$f":"+F22-G22","v":2550}]
[null,null,"Sub Total (1 to 3)",null,null,{"$f":"+F11+F20+F21+F22","v":358950},{"$f":"+G11+G20+G21+G22","v":53842.5},{"$f":"+F23-G23","v":305107.5},{"$f":"+H23/58","v":5260.4741379310344}]
[null,4,"Contingencies",0.1,null,{"$f":"+F23*0.1","v":35895},{"$f":"+F24*0.15","v":5384.25},{"$f":"+H23*0.1","v":30510.75}]
[null,null,"Training","2 Nos.",5000,10000,null,10000]
[null,null,"Sub-Total ",null,null,{"$f":"+F24+F25","v":45895},{"$f":"+G24+G25","v":5384.25},{"$f":"+H24+H25","v":40510.75}]
[null,null,"Sub Total (1 to 4)",null,null,{"$f":"+F23+F26","v":404845},{"$f":"+G23+G26","v":59226.75},{"$f":"+H23+H26","v":345618.25},{"$f":"+H27/58","v":5958.9353448275861}]
[null,5,"Management Cost @ 20%",null,null,{"$f":"+F27*0.2","v":80969},0,{"$f":"+F28","v":80969},{"$f":"+H28/58","v":1396.0172413793102}]
[null,null,"Grand Total",null,null,{"$f":"+F27+F28","v":485814},{"$f":"+G27+G28","v":59226.75},{"$f":"+H27+H28","v":426587.25},{"$f":"+H29/58","v":7354.9525862068967}]
[]
[null,null,"Cost for one Unit in Rupees",null,null,{"$f":"+F29","v":485814},{"$f":"+G29","v":59226.75},426587.25,7354.9525862068967]
[null,null,"Cost for Four Unit in Rupees",null,null,{"$f":"+F31*4","v":1943256},{"$f":"+G31*4","v":236907},1706349,29419.810344827587]
[null,null,"Total cost for four units in Dollar",null,null,{"$f":"+F32/58","v":33504.413793103449},{"$f":"+G32/58","v":4084.6034482758619},29419.810344827587]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}