{"text_format":"2","workbook":"xlsx","n_sheets":27,"sheets":["Home","Conductivity","Hydrology","Weir","SideIntake","BottomIntake","Diagrams","HeadraceCanals","HeadracePipe","SettlingBasinDesign","Penstock&Power","AnchorLoads","AnchorBlock","Turbine","Electrical","MachineFoundation","Transmission","Loads&Benefits","Costing&Financial Analyses","Utilities","CanalDepth","LoanPayment","Power","Spillway","ffactor","VDrop","References"],"not_rendered":{"charts":15,"images":65,"macros":0,"external_links":4,"defined_names":272,"comments":23,"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":"Home","index":0,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[18,2,18,5],[14,2,14,5],[15,2,15,5],[27,2,27,5],[19,2,19,5],[22,2,22,5],[23,2,23,5],[24,2,24,5],[13,2,13,5],[0,0,0,6],[1,0,1,6],[2,0,2,6],[10,2,10,5],[9,2,9,5],[11,2,11,5]]}
["MICROHYDRO DESIGN AIDS © 2010 for Microsoft Excel 2003",{"$nulls":6}," "]
["Small Hydropower Promotion Project (SHPP)/GTZ"]
[]
[]
[null,"By Mr. Pushpa Chitrakar"]
[]
[]
[]
["Worksheets",{"$nulls":4},"Collaboration Partmers"]
["Conductivity",null,"SHPP/GTZ, Nepal"]
["Hydrology",null,"Email"]
["Weir",null,"Web"]
["Side Intake"]
["Bottom Intake",null,"Entec AG, Switzerland"]
["Headrace Canal",null,"Email"]
["Headrace Pipe",null,"Web"]
["Settling Basin"]
["Penstock & Power",{"$nulls":4},"Feedback"]
["Loads on Anchor",null,"Pushpa Chitrakar"]
["Anchor Block Stability",null,"pushpa.chitrakar@gmail.com"]
["Turbine"]
["Electrical",{"$nulls":4},"Help"]
["Machine Foundation",null,"Online Manual"]
["Transmission Line",null,"Drawings"]
["Loads and Benefits",null,"List of Reference"]
["Costing & Financial Analyses"]
["Utilities"]
["Version: 2010.04","© Small Hydropower Promotion Project 2006","Kathmandu, Nepal"]
[null," "]

{"sheet":"Conductivity","index":1,"n_rows":107,"n_cols":12,"rows_kept":107,"cut":false,"hidden":false,"merged":[[10,2,10,3],[11,2,11,3],[13,1,13,4],[20,0,20,3]]}
["Discharge Measurement by Conductivity Meter",{"$nulls":6},"Time","Reading 1","Reading 2","Reading 3","Reading 4"]
["Small Hydropower Promotion Project (SHPP)/GTZ","Spreadsheet by Mr Pushpa Chitrakar",{"$nulls":5},0,25,24,24,0]
["Referances: 6,12,13,15,16","Date",{"$f":"TODAY()","v":"2012-07-20"},{"$nulls":4},{"$f":"H2+$E$12","v":5},26,24,25]
["SMALL HYDROPOWER PROMOTION PROJECT/GTZ","Revision","2006.05",{"$nulls":4},10,27,24,25]
["Project","Golmagad SHP",{"$nulls":5},15,28,24,26]
["Developer","Kankaimai Hydropower P Ltd",{"$nulls":5},20,29,24,27]
["Consultant","EPC Consult",{"$nulls":5},25,30,24,29]
["Designed","Pushpa Chitrakar",{"$nulls":5},30,31,24,30]
["Checked","Pushpa Chitrakar",{"$nulls":5},35,32,24,32]
["Meter","HANNA Instruments (HI 933000)",{"$nulls":5},40,32,25,33]
["Salt","Iyoo Noon","Water temp:",null,11,null,null,45,33,28,37]
["Given k",1.8,"Time intervals",null,5,null,null,50,34,34,39]
[{"$nulls":7},55,34,41,42]
["Salt Const. (k)",{"$f":"B12","v":1.8},{"$nulls":5},60,34,49,45]
["Wt. of Salt",400,1580,1795,0,null,null,65,35,54,48]
["Nr of data",{"$f":"COUNT(Reading01)","v":70},{"$f":"COUNT(Reading02)","v":91},{"$f":"COUNT(Reading03)","v":106},{"$f":"COUNT(Reading04)","v":1},null,null,70,35,60,49]
["Baseline conductivity",{"$f":"IF(B16=0,0,MIN(Reading01))","v":25},{"$f":"IF(C16=0,0,MIN(Reading02))","v":24},{"$f":"IF(D16=0,0,MIN(Reading03))","v":24},{"$f":"IF(E16=0,0,MIN(Reading04))","v":0},null,null,75,35,68,51]
["Sum of readings",{"$f":"IF(B16=0,0,SUM(Reading01))","v":2062},{"$f":"IF(C16=0,0,SUM(Reading02))","v":3433},{"$f":"IF(D16=0,0,SUM(Reading03))","v":3997},{"$f":"IF(E16=0,0,SUM(Reading04))","v":0},null,null,80,35,70,52]
["Effective Area",{"$f":"(B18-B17*B16)*$E$12","v":1560},{"$f":"(C18-C17*C16)*$E$12","v":6245},{"$f":"(D18-D17*D16)*$E$12","v":7265},{"$f":"(E18-E17*E16)*$E$12","v":0},null,null,85,34,73,54]
["Discharge",{"$f":"IF(ISERROR($B$14*B15*1000/B19),0,$B$14*B15*1000/B19)","v":461.53846153846155},{"$f":"IF(ISERROR($B$14*C15*1000/C19),0,$B$14*C15*1000/C19)","v":455.40432345876701},{"$f":"IF(ISERROR($B$14*D15*1000/D19),0,$B$14*D15*1000/D19)","v":444.73503097040606},{"$f":"IF(ISERROR($B$14*E15*1000/E19),0,$B$14*E15*1000/E19)","v":0},null,null,90,34,76,55]
["Average Discharge",null,null,null,{"$f":"SUM(B20:E20)/COUNTIF(B20:E20,\">0\")","v":453.89260532254485},null,null,95,34,76,56]
[{"$nulls":7},100,33,74,58]
[{"$nulls":7},105,33,73,58]
[{"$nulls":7},110,33,70,58]
[{"$nulls":7},115,32,70,58]
[{"$nulls":7},120,32,68,59]
[{"$nulls":7},125,32,64,58]
[{"$nulls":7},130,32,64,58]
[{"$nulls":7},135,31,61,57]
[{"$nulls":7},140,31,58,57]
[{"$nulls":7},145,31,56,56]
[{"$nulls":7},150,31,54,56]
[{"$nulls":7},155,31,52,55]
[{"$nulls":7},160,31,50,54]
[{"$nulls":7},{"$f":"H34+$E$12","v":165},30,48,53]
[{"$nulls":7},170,30,47,52]
[{"$nulls":7},175,30,46,52]
[{"$nulls":7},180,30,44,51]
[{"$nulls":7},185,29,43,50]
[{"$f":"A1&\": \"&B5","v":"Discharge Measurement by Conductivity Meter: Golmagad SHP"},{"$f":"\"Date= \"&YEAR(C3)&\"/\"&MONTH(C3)&\"/\"&DAY(C3)&\", \"&E11&\"deg C, \"&B10&\", \"&B11&\", k=\"&ROUND(B14,2)&\", Ave. Discharge = \"&ROUND(E21,2)&\" l/s\"","v":"Date= 2012/7/20, 11deg C, HANNA Instruments (HI 933000), Iyoo Noon, k=1,8, Ave. Discharge = 453,89 l/s"},{"$nulls":5},190,29,41,49]
[null,{"$f":"\"Salt =\"&B15&\"gm, A eff =\"&ROUND(B19,2)","v":"Salt =400gm, A eff =1560"},{"$f":"\"Salt =\"&C15&\"gm, A eff =\"&ROUND(C19,2)","v":"Salt =1580gm, A eff =6245"},{"$f":"\"Salt =\"&D15&\"gm, A eff =\"&ROUND(D19,2)","v":"Salt =1795gm, A eff =7265"},{"$f":"\"Salt =\"&E15&\"gm, A eff =\"&ROUND(E19,2)","v":"Salt =0gm, A eff =0"},null,null,195,29,40,48]
[{"$nulls":7},200,29,40,48]
[{"$nulls":7},205,29,39,47]
[{"$nulls":7},210,29,38,46]
[{"$nulls":7},215,28,37,45]
[{"$nulls":7},220,28,36,44]
[{"$nulls":7},225,28,35,44]
[{"$nulls":7},230,28,35,43]
[{"$nulls":7},235,28,34,42]
[{"$nulls":7},240,28,33,42]
[{"$nulls":7},245,28,33,41]
[{"$nulls":7},250,27,32,40]
[{"$nulls":7},255,27,32,39]
[{"$nulls":7},260,27,31,39]
[{"$nulls":7},265,27,31,38]
[{"$nulls":7},270,27,30,37]
[{"$nulls":7},275,26,30,37]
[{"$nulls":7},280,26,29,36]
[{"$nulls":7},285,26,29,36]
[{"$nulls":7},290,26,29,35]
[{"$nulls":7},295,26,29,35]
[{"$nulls":7},300,26,28,34]
[{"$nulls":7},305,26,28,34]
[{"$nulls":7},310,26,28,34]
[{"$nulls":7},315,26,27,33]
[{"$nulls":7},320,26,27,33]
[{"$nulls":7},{"$f":"H66+$E$12","v":325},26,27,32]
[{"$nulls":7},330,26,27,32]
[{"$nulls":7},335,25,27,32]
[{"$nulls":7},340,25,26,31]
[{"$nulls":7},345,25,26,31]
[{"$nulls":7},350,null,26,31]
[{"$nulls":7},355,null,26,30]
[{"$nulls":7},360,null,26,30]
[{"$nulls":7},365,null,26,30]
[{"$nulls":7},370,null,26,30]
[{"$nulls":7},375,null,26,29]
[{"$nulls":7},380,null,25,29]
[{"$nulls":7},385,null,25,29]
[{"$nulls":7},390,null,25,29]
[{"$nulls":7},395,null,25,28]
[{"$nulls":7},400,null,25,28]
[{"$nulls":7},405,null,25,28]
[{"$nulls":7},410,null,25,28]
[{"$nulls":7},415,null,25,27]
[{"$nulls":7},420,null,25,27]
[{"$nulls":7},425,null,25,27]
[{"$nulls":7},430,null,25,27]
[{"$nulls":7},435,null,25,27]
[{"$nulls":7},440,null,25,27]
[{"$nulls":7},445,null,25,27]
[{"$nulls":7},450,null,25,27]
[{"$nulls":7},455,null,null,26]
[{"$nulls":7},460,null,null,26]
[{"$nulls":7},465,null,null,26]
[{"$nulls":7},470,null,null,26]
[{"$nulls":7},475,null,null,26]
[{"$nulls":7},480,null,null,26]
[{"$nulls":7},{"$f":"H98+$E$12","v":485},null,null,26]
[{"$nulls":7},490,null,null,26]
[{"$nulls":7},495,null,null,26]
[{"$nulls":7},500,null,null,26]
[{"$nulls":7},505,null,null,26]
[{"$nulls":7},510,null,null,25]
[{"$nulls":7},515,null,null,25]
[{"$nulls":7},520,null,null,25]
[{"$nulls":7},525,null,null,25]

{"sheet":"Hydrology","index":2,"n_rows":53,"n_cols":27,"rows_kept":53,"cut":false,"hidden":false,"merged":[[26,5,26,6],[0,0,0,7],[38,12,38,18]]}
["HYDROLOGICAL CALCULATIONS FOR UNGAUGED MHP RIVERS",{"$nulls":22},"MIP Region","Q messured on date",null,"Q measured in"]
["Small Hydropower Promotion Project (SHPP)/GTZ",{"$nulls":4},"Spreadsheet by Mr Pushpa Chitrakar"]
["Referances:2,2,4, 6,12,13,15,16",{"$nulls":4},"Date",{"$f":"TODAY()","v":"2012-07-20"}]
["SMALL HYDROPOWER PROMOTION PROJECT/GTZ",{"$nulls":4},"Revision","2006.05"]
["Project:   ","Upper Jogmai SHP"]
["Developer","Kankai Hydropower P Ltd"]
["Consultant","EPC Consult"]
["Designed","Pushpa Chitrakar"]
["Checked","Pushpa Chitrakar"]
[{"$nulls":23},1,1,null,"January"]
["INPUT",{"$nulls":22},2,2,null,"February"]
["      River name :",{"$nulls":5},"Chhyota Khola",{"$nulls":16},3,3,null,"March"]
["      Location :",{"$nulls":5},"Barand, Sertung VDC 2, Dhading",{"$nulls":16},4,4,null,"April"]
["      Measured flow for MIP method l/s:",{"$nulls":5},80,{"$nulls":16},5,5,null,"May"]
["      Month and day of flow measurement:",{"$nulls":5},"March",23,{"$nulls":15},6,6,null,"June"]
["      MIP region (1 -7) :",{"$nulls":5},3,{"$nulls":16},7,7,null,"July"]
["      Area of basin below 3000m elevation A3000 km2 :",{"$nulls":5},1.5,{"$nulls":17},8,null,"August"]
["      Turbine discharge Qd l/s:",{"$nulls":5},80,{"$nulls":4},"PRE-CALCULATIONS",{"$nulls":12},9,null,"September"]
["      Water losses due to evaporation/flushing/seepage % of Qd :",{"$nulls":5},0.05,{"$nulls":4},"GRAPH TITLES",{"$nulls":12},10,null,"October"]
["      Downstream water release due to environmental reasons % of Q lowest :",{"$nulls":5},0.1,{"$nulls":4},{"$f":"\"Long Term Average Annual Hydrograph of \"&\" \"&NAME&\" river, \"&Hydrology!B5","v":"Long Term Average Annual Hydrograph of  Chhyota Khola river, Upper Jogmai SHP"},{"$nulls":12},11,null,"November"]
[{"$nulls":11},"Months","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec",12,null,"December"]
[{"$nulls":11},"MIP flows",{"$f":"B28","v":{"$error":"#NAME?"}},{"$f":"B29","v":{"$error":"#NAME?"}},{"$f":"B30","v":{"$error":"#NAME?"}},{"$f":"B31","v":{"$error":"#NAME?"}},{"$f":"B32","v":{"$error":"#NAME?"}},{"$f":"B33","v":{"$error":"#NAME?"}},{"$f":"B34","v":{"$error":"#NAME?"}},{"$f":"B35","v":{"$error":"#NAME?"}},{"$f":"B36","v":{"$error":"#NAME?"}},{"$f":"B37","v":{"$error":"#NAME?"}},{"$f":"B38","v":{"$error":"#NAME?"}},{"$f":"B39","v":{"$error":"#NAME?"}},13]
["OUTPUT",{"$nulls":10},"Qturbine MGSP",{"$f":"Qturbine","v":80},80,80,80,80,80,80,80,80,80,80,80,14]
[{"$nulls":11},{"$f":"\"Q design =\"&ROUND(F34,3)&\" l/s with \"&F39&\"-month exceedence\"","v":"Q design =80 l/s with 12-month exceedence"},{"$f":"Hydrology!$F$38","v":{"$error":"#NAME?"}},{"$f":"Hydrology!$F$38","v":{"$error":"#NAME?"}},{"$f":"Hydrology!$F$38","v":{"$error":"#NAME?"}},{"$f":"Hydrology!$F$38","v":{"$error":"#NAME?"}},{"$f":"Hydrology!$F$38","v":{"$error":"#NAME?"}},{"$f":"Hydrology!$F$38","v":{"$error":"#NAME?"}},{"$f":"Hydrology!$F$38","v":{"$error":"#NAME?"}},{"$f":"Hydrology!$F$38","v":{"$error":"#NAME?"}},{"$f":"Hydrology!$F$38","v":{"$error":"#NAME?"}},{"$f":"Hydrology!$F$38","v":{"$error":"#NAME?"}},{"$f":"Hydrology!$F$38","v":{"$error":"#NAME?"}},{"$f":"Hydrology!$F$38","v":{"$error":"#NAME?"}},15]
["MIP monthly average discharge",null,null,null,"Hydest Flood Flows",{"$nulls":6},{"$f":"\"Q as per MGSP =\"&ROUND(G34,3)&\" l/s with \"&G39&\"-month exceedence\"","v":{"$error":"#NAME?"}},{"$f":"Hydrology!$G$38","v":{"$error":"#NAME?"}},{"$f":"Hydrology!$G$38","v":{"$error":"#NAME?"}},{"$f":"Hydrology!$G$38","v":{"$error":"#NAME?"}},{"$f":"Hydrology!$G$38","v":{"$error":"#NAME?"}},{"$f":"Hydrology!$G$38","v":{"$error":"#NAME?"}},{"$f":"Hydrology!$G$38","v":{"$error":"#NAME?"}},{"$f":"Hydrology!$G$38","v":{"$error":"#NAME?"}},{"$f":"Hydrology!$G$38","v":{"$error":"#NAME?"}},{"$f":"Hydrology!$G$38","v":{"$error":"#NAME?"}},{"$f":"Hydrology!$G$38","v":{"$error":"#NAME?"}},{"$f":"Hydrology!$G$38","v":{"$error":"#NAME?"}},{"$f":"Hydrology!$G$38","v":{"$error":"#NAME?"}},16]
[{"$nulls":11},"FLOOD FLOW CALCULATION",{"$nulls":12},17]
[" Month","@ river","To plant",null,"Return Period (yrs)","Flood Discharge (m3/s)",{"$nulls":5},"RATIO OF Q2/Q100 COEF",{"$nulls":12},18]
["January",{"$f":"Hydrology!T41","v":{"$error":"#NAME?"}},{"$f":"IF($G$35<B28,$G$35,B28-10%*MIN($B$28:$B$39))","v":{"$error":"#NAME?"}},null,null,"Daily","Instantaneous",{"$nulls":4},{"$f":"IF(ISERROR(LN(Hydrology!F31/Hydrology!F29)/2.326),0,(LN(Hydrology!F31/Hydrology!F29)/2.326))","v":0.65643603765474823},{"$nulls":12},19]
["February",{"$f":"Hydrology!T42","v":{"$error":"#NAME?"}},{"$f":"IF($G$35<B29,$G$35,B29-10%*MIN($B$28:$B$39))","v":{"$error":"#NAME?"}},null,2,{"$f":"IF(A3000A>0,0.8154*(G17+1)^0.9527,\"-\")","v":1.9520374859210841},{"$f":"IF(A3000A>0,1.8767*(G17+1)^0.8783,\"-\")","v":4.1966771824018609},{"$nulls":4},{"$f":"IF(ISERROR(LN(Hydrology!G31/Hydrology!G29)/2.326),0,LN(Hydrology!G31/Hydrology!G29)/2.326)","v":0.82610567723726458},{"$nulls":12},20]
["March",{"$f":"Hydrology!T43","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,20,{"$f":"IF(A3000A>0,EXP(LN(F$29)+1.645*Hydrology!$L$28),\"-\")","v":5.7471896200828079},{"$f":"IF(A3000A>0,EXP(LN(G$29)+1.645*Hydrology!$L$29),\"-\")","v":16.333805287456535},{"$nulls":4},{"$f":"IF(F34>0.1,EXP(LN(G$29)+1.645*Hydrology!$L$29),EXP(LN(1.8767*(1)^0.8783)+1.645*LN((14.63*(1)^0.7342)/(1.8767*(1)^0.8783))/2.326))","v":16.333805287456535},{"$nulls":12},21]
["April",{"$f":"Hydrology!T44","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,100,{"$f":"IF(A3000A>0,4.144*(G17+1)^0.8448,\"-\")","v":8.9866839019278579},{"$f":"IF(A3000A>0,14.63*(G17+1)^0.7342,\"-\")","v":28.668956158029033},{"$nulls":17},22]
["May",{"$f":"Hydrology!T45","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$nulls":8},"MIP Mid month flow calculaton",{"$nulls":12},23]
["June",{"$f":"Hydrology!T46","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,"Discharges (l/s)","Designed","As per MGSP",{"$nulls":4},"K prev month",null,null,null,{"$f":"INDEX(MidHGraph,MATCH((G15),MidMonths,0)-1,REGION)","v":1.88},{"$nulls":8},24]
["July",{"$f":"Hydrology!T47","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,"Qturbine (Qd)",{"$f":"Qturbine","v":80},{"$f":"MIN(Qturbine,0.85*LARGE(B28:B39,11))","v":{"$error":"#NAME?"}},{"$nulls":4},"K measured month",null,null,null,{"$f":"INDEX(MidHGraph,MATCH((G15),MidMonths,0),REGION)","v":1.38},{"$nulls":8},25]
["August",{"$f":"Hydrology!T48","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,"Q diverted Qd+Qlosses",{"$f":"F34/(1-Qlosses)","v":84.21052631578948},{"$f":"G34/(1-Qlosses)","v":{"$error":"#NAME?"}},{"$nulls":4},"K next month",null,null,null,{"$f":"INDEX(MidHGraph,MATCH((G15),MidMonths,0)+1,REGION)","v":1},{"$nulls":8},26]
["September",{"$f":"Hydrology!T49","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,{"$f":"\"Q losses \"&100*Qlosses&\"% of Qd\"","v":"Q losses 5% of Qd"},{"$f":"F35-F34","v":4.2105263157894797},{"$f":"G35-G34","v":{"$error":"#NAME?"}},{"$nulls":4},"MIP K correction",null,null,null,{"$f":"kcorr(H15,P33,P34,P35)","v":{"$error":"#NAME?"}},{"$nulls":8},27]
["October",{"$f":"Hydrology!T50","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,{"$f":"\"Q release \"&100*G20&\"% of Qlow\"","v":"Q release 10% of Qlow"},{"$f":"G20*MIN(B28:B39)","v":{"$error":"#NAME?"}},{"$f":"G20*MIN(B28:B39)","v":{"$error":"#NAME?"}},{"$nulls":17},28]
["November",{"$f":"Hydrology!T51","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,"Q min required @ river",{"$f":"F35+F37","v":{"$error":"#NAME?"}},{"$f":"G35+G37","v":{"$error":"#NAME?"}},{"$nulls":4},"Non-dimensional regional hydrographs",{"$nulls":12},29]
["December",{"$f":"Hydrology!T52","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,"Q exceedence (month)",{"$f":"COUNTIF(B28:B39,\">=\"&TEXT(F38,\"#0.000\"))","v":12},{"$f":"COUNTIF(B28:B39,\">=\"&TEXT(G38,\"#0.000\"))","v":12},{"$nulls":4},"Month","Regions",{"$nulls":6},"MIP Flow l/s","Regional data for Graph","Error of +10%","Error of -10%",null,30]
["Annual av",{"$f":"AVERAGEA(B28:B39)","v":{"$error":"#NAME?"}},{"$f":"AVERAGEA(C28:C39)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F39<11,\"Q turbine for 11m\",\"\")","v":""},{"$f":"IF(F39<11,LARGE(B28:B39,11)-LARGE(B28:B39,11)*G20-LARGE(B28:B39,11)*(1-G20)*Qlosses,\"\")","v":""},{"$nulls":6},1,2,3,4,5,6,7,{"$nulls":5},31]
[{"$nulls":11},"January",2.4,2.2400000000000002,2.71,2.59,2.42,2.0299999999999998,3.3,{"$f":"$T$44*(INDEX(HGraph,MATCH((L41),Months,0),REGION))","v":{"$error":"#NAME?"}},{"$f":"(INDEX(HGraph,MATCH((L41),Months,0),REGION))","v":2.71},{"$f":"1.1*U41","v":2.9810000000000003},{"$f":"0.9*U41","v":2.4390000000000001}]
[{"$nulls":11},"February",1.8,1.7,1.88,1.88,1.82,1.62,2.2000000000000002,{"$f":"$T$44*(INDEX(HGraph,MATCH((L42),Months,0),REGION))","v":{"$error":"#NAME?"}},1.88,2.0680000000000001,1.6919999999999999]
[{"$nulls":11},"March",1.3,1.33,1.38,1.38,1.36,1.27,1.4,{"$f":"$T$44*(INDEX(HGraph,MATCH((L43),Months,0),REGION))","v":{"$error":"#NAME?"}},1.38,1.518,1.242]
[{"$nulls":11},"April",1,1,1,1,1,1,1,{"$f":"Hydrology!G14/P36","v":{"$error":"#NAME?"}},1,1.1000000000000001,0.9]
[{"$nulls":11},"May",2.6,1.21,1.88,2.19,0.91,2.57,3.5,{"$f":"$T$44*(INDEX(HGraph,MATCH((L45),Months,0),REGION))","v":{"$error":"#NAME?"}},1.88,2.0680000000000001,1.6919999999999999]
[{"$nulls":11},"June",6,7.27,3.13,3.75,2.73,6.08,6,{"$f":"$T$44*(INDEX(HGraph,MATCH((L46),Months,0),REGION))","v":{"$error":"#NAME?"}},3.13,3.4430000000000001,2.8170000000000002]
[{"$nulls":11},"July",14.5,18.18,13.54,6.89,11.21,24.32,14,{"$error":"#NAME?"},13.54,14.894,12.186]
[{"$nulls":11},"August",25,27.27,25,27.27,13.94,33.78,35,{"$error":"#NAME?"},25,27.500000000000004,22.5]
[{"$nulls":11},"September",16.5,20.91,20.83,20.91,10,27.03,24,{"$error":"#NAME?"},20.83,22.913,18.747]
[{"$nulls":11},"October",8,9.09,10.42,6.89,6.52,6.08,12,{"$error":"#NAME?"},10.42,11.462000000000002,9.3780000000000001]
[{"$nulls":11},"November",4.0999999999999996,3.94,5,5,4.55,3.38,7.5,{"$error":"#NAME?"},5,5.5,4.5]
[{"$nulls":11},"December",3.1,3.03,3.75,3.44,3.33,2.57,5,{"$error":"#NAME?"},3.75,4.125,3.375]
[{"$nulls":11},"January",2.4,2.2400000000000002,2.71,2.59,2.42,2.0299999999999998,3.3]

{"sheet":"Weir","index":3,"n_rows":82,"n_cols":13,"rows_kept":82,"cut":false,"hidden":false,"merged":[[0,0,0,3],[41,0,42,0],[41,1,42,1],[43,0,43,3],[41,2,42,2],[41,3,42,3]]}
["Design of Stone Masonry Weir",{"$nulls":5},"Section",null,"Plan"]
["Small Hydropower Promotion Project (SHPP)/GTZ","Spreadsheet by Mr Pushpa Chitrakar",{"$nulls":4},"X","y","x","y"]
["Referances: 6,12,13,15,16","Date",{"$f":"TODAY()","v":"2012-07-20"},null,null,null,0,0,0,0]
["SMALL HYDROPOWER PROMOTION PROJECT/GTZ","Revision","2006.05",null,null,null,{"$f":"B35","v":0.25},{"$f":"H3","v":0}]
["Project","Upper Jogmai, Ilam",{"$nulls":4},{"$f":"B36+G4","v":2.25},0]
["Developer","Kankaimai Hydropower P Ltd",{"$nulls":4},{"$f":"B37+G5","v":3.25},0]
["Consultant","EPC Consult",{"$nulls":4},{"$f":"G6+B38","v":3.75},0]
["Designed","Pushpa Chitrakar",{"$nulls":4},{"$f":"G7","v":3.75},{"$f":"D36","v":1.5}]
["Checked","Pushpa Chitrakar",{"$nulls":4},{"$f":"G6","v":3.25},{"$f":"H8","v":1.5}]
[{"$nulls":6},{"$f":"G5","v":2.25},{"$f":"D35","v":3}]
[{"$nulls":6},{"$f":"G4","v":0.25},{"$f":"H10","v":3}]
[{"$nulls":6},{"$f":"G11","v":0.25},{"$f":"D37","v":1}]
[{"$nulls":6},0,{"$f":"H12","v":1}]
[{"$nulls":6},0,0]
[{"$nulls":6},{"$f":"G10","v":2.25},{"$f":"H10","v":3},null,null,null,"Turbine CL"]
[{"$nulls":6},{"$f":"G15","v":2.25},{"$f":"H8","v":1.5},null,null,null,1,1]
[{"$nulls":6},{"$f":"G9","v":3.25},{"$f":"H8","v":1.5},null,null,null,2,2]
[{"$nulls":6},{"$f":"G17","v":3.25},{"$nulls":4},1,3]
[{"$nulls":6},{"$f":"G16","v":2.25},{"$f":"H16","v":1.5}]
[{"$nulls":6},{"$f":"G19","v":2.25},0]
[{"$nulls":6},{"$f":"G12","v":0.25},{"$f":"H12","v":1}]
[]
[{"$nulls":6},{"$f":"G21","v":0.25},0]
[{"$nulls":11},"Generator CL"]
[{"$nulls":6},{"$f":"A45&\" =\"&ROUND(B45,3)&\" kN\"","v":"G1 =5,5 kN"},null,{"$f":"A50&\" =\"&ROUND(B50,3)&\" kN\"","v":"W1 =5 kN"},null,null,2,{"$f":"M16","v":1}]
[{"$nulls":6},{"$f":"$G$4/2","v":0.125},{"$f":"H13+0.2","v":1.2},{"$f":"G26","v":0.125},{"$f":"1+H26","v":2.2000000000000002},null,3,{"$f":"M17","v":2}]
[{"$nulls":6},{"$f":"G26","v":0.125},{"$f":"AVERAGE(H26,H28)","v":0.65},{"$f":"G27","v":0.125},{"$f":"AVERAGE(J26,J28)","v":1.65},null,2,{"$f":"M18","v":3}]
[{"$nulls":6},{"$f":"G27","v":0.125},0.1,{"$f":"G28","v":0.125},{"$f":"H26-0.1","v":1.0999999999999999}]
["Foundation and Soil",{"$nulls":5},{"$f":"A46&\" =\"&ROUND(B46,3)&\" kN\"","v":"G2 =132 kN"},null,{"$f":"A51&\" =\"&ROUND(B51,3)&\" kN\"","v":"W2 =45 kN"}]
["Foundation on ","Soil","Coeff of soil at active state (ka)",0.33,null,null,{"$f":"G4+(G5-G4)/2","v":1.25},{"$f":"H26","v":1.2},{"$f":"G49","v":-0.6},{"$f":"ABS(C51)","v":1}]
["Allowable bearing capacity Pall (kN/m2)",180,"Soil Density (kN/m3)",20,null,null,{"$f":"G30","v":1.25},{"$f":"AVERAGE(H30,H32)","v":0.65},{"$f":"AVERAGE(I30,I32)","v":-0.35},{"$f":"J30","v":1}]
["Coeff of soil at rest (ko)",1,"Friction coeff between block and soil m",0.5,null,null,{"$f":"G31","v":1.25},{"$f":"H28","v":0.1},-0.1,{"$f":"J31","v":1}]
[{"$nulls":6},{"$f":"A47&\" =\"&ROUND(B47,3)&\" kN\"","v":"G3 =16,5 kN"},null,{"$f":"A52&\" =\"&ROUND(B52,3)&\" kN\"","v":"W3 =5 kN"}]
["Weir Geometry",{"$nulls":5},{"$f":"G9-B37*2/3","v":2.5833333333333335},{"$f":"H30+H8","v":2.7},{"$f":"G51-0.1","v":3.65},{"$f":"H52/3","v":0.5}]
["Length L1 (m)",0.25,"Height H1 (m)",3,null,null,{"$f":"G34","v":2.5833333333333335},{"$f":"AVERAGE(H34,H36)","v":2.1500000000000004},{"$f":"AVERAGE(I34,I36)","v":3.8499999999999996},{"$f":"J34","v":0.5}]
["Length L2 (m)",2,"Height H2 (m)",1.5,null,null,{"$f":"G35","v":2.5833333333333335},{"$f":"H32+H8","v":1.6},{"$f":"G53","v":4.05},{"$f":"J35","v":0.5}]
["Length L3 (m)",1,"Height H3 (m)",1,null,null,{"$f":"A48&\" =\"&ROUND(B48,3)&\" kN\"","v":"G4 =49,5 kN"},null,{"$f":"A53&\" =\"&ROUND(B53,3)&\" kN\"","v":"U1 =84,375 kN"}]
["Length L4 (m)",0.5,"Density (kM/m3)",22,null,null,{"$f":"$G$8-(G8-G5)/2","v":3},{"$f":"H8+0.1","v":1.6},{"$f":"ABS(C53)","v":2.0833333333333335},{"$f":"H56","v":-0.6}]
["Total length L (m)",{"$f":"SUM(B35:B38)","v":3.75},"Head above crest during flood, hf (m)",0.5,null,null,{"$f":"G38","v":3},{"$f":"AVERAGE(H38,H40)","v":0.85000000000000009},{"$f":"I38","v":2.0833333333333335},{"$f":"AVERAGE(J38,J40)","v":-0.3}]
["Material","Concrete",{"$nulls":4},{"$f":"G39","v":3},0.1,{"$f":"I39","v":2.0833333333333335},0]
["OUTPUT",{"$nulls":5},"Water"]
["Forces","Weight Wi (kN)","LA along XX (m)","Moment (kN-m)",null,null,{"$f":"G13","v":0},{"$f":"H13","v":1}]
[{"$nulls":6},{"$f":"G4","v":0.25},{"$f":"H42","v":1}]
["Weir",{"$nulls":5},{"$f":"G43","v":0.25},{"$f":"H15","v":3}]
["G1",{"$f":"B35*D37*$D$38","v":5.5},{"$f":"SUM(B36:B38)+B35/2","v":3.625},{"$f":"C45*B45","v":19.9375},null,null,0,{"$f":"H44","v":3}]
["G2",{"$f":"B36*D35*$D$38","v":132},{"$f":"SUM(B37:B38)+B36/2","v":2.5},{"$f":"C46*B46","v":330},null,null,{"$f":"G42","v":0},{"$f":"H42","v":1}]
["G3",{"$f":"0.5*B37*(D35-D36)*$D$38","v":16.5},{"$f":"B38+1/3*B37","v":0.83333333333333326},13.749999999999998,null,null,0,0]
["G4",{"$f":"(B38+B37)*D36*$D$38","v":49.5},{"$f":"(B38+B37)/2","v":0.75},37.125,null,null,0,{"$f":"H10","v":3}]
["Water (normal conditions)",{"$nulls":5},{"$f":"-H48/5","v":-0.6},0]
["W1",{"$f":"10*B35*(D35-D37)","v":5},{"$f":"C45","v":3.625},18.125,null,null,0,0]
["W2",{"$f":"0.5*10*D35^2","v":45},{"$f":"-D35/3","v":-1},-45,null,null,{"$f":"G8","v":3.75},0]
["W3",{"$f":"0.5*10*D37^2","v":5},{"$f":"D36/3","v":0.5},2.5,null,null,{"$f":"G51","v":3.75},{"$f":"H8","v":1.5}]
["U1",{"$f":"B39*10*(D35+D36)/2","v":84.375},{"$f":"-B39/3*(D36+2*D35)/(D36+D35)","v":-2.0833333333333335},-175.78125,null,null,{"$f":"G52+H52/5","v":4.05},{"$f":"H51","v":0}]
[{"$nulls":6},{"$f":"G51","v":3.75},0]
["Water (flood conditions)",{"$nulls":5},{"$f":"G47","v":0},{"$f":"H51","v":0}]
["W1",{"$f":"10*B35*(D35+D39-D37)","v":6.25},{"$f":"C45","v":3.625},{"$f":"C56*B56","v":22.65625},null,null,0,{"$f":"G49","v":-0.6}]
["W2",{"$f":"0.5*10*(D35+D39)^2","v":61.25},{"$f":"-(D35+D39)/3","v":-1.1666666666666667},{"$f":"C57*B57","v":-71.458333333333343},null,null,{"$f":"G7","v":3.75},{"$f":"-H52/5","v":-0.3}]
["W3",{"$f":"0.5*10*(D37+D39)^2","v":11.25},{"$f":"(D36+D39)/3","v":0.66666666666666663},{"$f":"C58*B58","v":7.5},null,null,{"$f":"G57","v":3.75},0]
["U1",{"$f":"B39/2*10*(D35+D39+D36+D39)","v":103.125},{"$f":"-B39/3*(D36+D39+2*(D35+D39))/(D36+D39+D35+D39)","v":-2.0454545454545454},{"$f":"C59*B59","v":-210.9375}]
["Soil",{"$nulls":5},"Flood Level"]
["S1",{"$f":"0.5*D30*(D31-10)*D37^2","v":1.6500000000000001},{"$f":"-1/3*D37","v":-0.33333333333333331},{"$f":"C61*B61","v":-0.55000000000000004},null,null,{"$f":"G70","v":-0.89999999999999991},{"$f":"H44+D39","v":3.5}]
["S2",{"$f":"0.5*B32*(D31-10)*D36^2","v":11.25},{"$f":"1/3*D36","v":0.5},{"$f":"C62*B62","v":5.625},null,null,{"$f":"G5","v":2.25},{"$f":"H61","v":3.5}]
[{"$nulls":6},{"$f":"G6","v":3.25},{"$f":"H8+D39","v":2}]
["Summantion forces","Normal","Flood",null,null,null,{"$f":"G74","v":4.4499999999999993},{"$f":"H63","v":2}]
["Sum of moments SM (kN-m)",{"$f":"SUM(D45:D53,D61:D62)","v":205.73124999999999},{"$f":"SUM(D45:D48,D56:D62)","v":153.64791666666662}]
["Sum of vertical forces SV (kN)",{"$f":"SUM(B45:B48,B50,-B53)","v":124.125},{"$f":"SUM(B45:B48,B56,-B59)","v":106.625}]
["Sum of horizontal forces SH (kN)",{"$f":"B51+B61-B52-B62","v":30.4},{"$f":"B57+B61-B58-B62","v":40.4},null,null,null,"Soil"]
[{"$nulls":6},{"$f":"G49-0.1","v":-0.7},0,{"$f":"A61&\" =\"&ROUND(B61,3)&\" kN\"","v":"S1 =1,65 kN"}]
["Overturning: Equivalent distance at which SM acts from critical point",{"$nulls":5},{"$f":"G68","v":-0.7},{"$f":"H13","v":1},{"$f":"G70","v":-0.89999999999999991},{"$f":"H69/3","v":0.33333333333333331}]
["d (m)",{"$f":"B65/B66","v":1.6574521651560925},{"$f":"C65/C66","v":1.4410121141070726},null,null,null,{"$f":"G69-H69/5","v":-0.89999999999999991},0,{"$f":"AVERAGE(I69,I71)","v":-0.79999999999999993},{"$f":"J69","v":0.33333333333333331}]
["Eccentricity e, (m)",{"$f":"(B39/2-B70)","v":0.21754783484390749},{"$f":"(B39/2-C70)","v":0.43398788589292736},null,null,null,{"$f":"G68","v":-0.7},0,{"$f":"G71","v":-0.7},{"$f":"J70","v":0.33333333333333331}]
["Allowable eccentricity e all (m)",{"$f":"B39/6","v":0.625},{"$f":"B72","v":0.625},null,null,null,{"$f":"G53+0.1","v":4.1499999999999995},0,{"$f":"A62&\" =\"&ROUND(B62,3)&\" kN\"","v":"S2 =11,25 kN"}]
["Comment on overturning moment",{"$f":"IF(B72>B71, \"Ok\",\"Not Ok\")","v":"Ok"},{"$f":"IF(C72>C71, \"Ok\",\"Not Ok\")","v":"Ok"},null,null,null,{"$f":"G72","v":4.1499999999999995},{"$f":"H17","v":1.5},{"$f":"G74","v":4.4499999999999993},{"$f":"H73/3","v":0.5}]
[{"$nulls":6},{"$f":"G73+H73/5","v":4.4499999999999993},0,{"$f":"AVERAGE(I73,I75)","v":4.3499999999999996},{"$f":"J73","v":0.5}]
["Bearing",{"$nulls":5},{"$f":"G72","v":4.1499999999999995},0,{"$f":"G75+0.1","v":4.2499999999999991},{"$f":"J74","v":0.5}]
["Pressure at base, Pmax",{"$f":"B66/(B39*1)*(1+6*B71/B39)","v":44.62133333333334},{"$f":"C66/(B39*1)*(1+6*C71/B39)","v":48.176888888888911}]
["Pressure at base, Pmin",{"$f":"B66/(B39*1)*(1-6*B71/B39)","v":21.57866666666666},{"$f":"C66/(B39*1)*(1-6*C71/B39)","v":8.6897777777777598}]
["Comments on bearing",{"$f":"IF(OR(B76>B31,B76<0,B77<0), \"Not Ok\",\"Ok\")","v":"Ok"},{"$f":"IF(OR(C76>C31,C76<0,C77<0), \"Not Ok\",\"Ok\")","v":"Ok"}]
[]
["Sliding"]
["Factor of safety against sliding, FS sl",{"$f":"D32*B66/B67","v":2.041529605263158},{"$f":"D32*C66/C67","v":1.3196163366336635}]
["Comment of sliding",{"$f":"IF(B81<1.5, \"Not Ok\",\"Ok\")","v":"Ok"},{"$f":"IF(C81<1.5, \"Not Ok\",\"Ok\")","v":"Not Ok"}]

{"sheet":"SideIntake","index":4,"n_rows":67,"n_cols":8,"rows_kept":67,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Design of Orifice Side Intake "]
["Spreadsheet developed by Mr. Pushpa Chitrakar, Engineering Advisor, SHPP/GTZ"]
["Referances: 6,12,13,15,16","Date",{"$f":"TODAY()","v":"2012-07-20"}]
["SMALL HYDROPOWER PROMOTION PROJECT/GTZ","Revision","2006.05"]
["Project","Ankhu HEP"]
["Developer","Ankhu Hydropower P Ltd"]
["Consultant","HSEC P Ltd"]
["Designed","Neeraj Shrestha"]
["Checked","Pushpa Chitrakar"]
{"$rows_empty":9}
[{"$nulls":5},"Trashrack Coeff"]
[{"$nulls":5},"Cross section","k"]
[{"$nulls":5},"Flat",2.4]
[{"$nulls":5},"Round/Rounded front",1.8]
[{"$nulls":5},"Tipped back",1.7]
[{"$nulls":5},"Both end rounded",1]
[{"$nulls":5},"Tipped section",0.8]
[{"$nulls":5},"No Trashrack",0]
[]
[]
[]
["Trashrack calculations"]
["Input",null,"Output"]
["Trashrack coeffieient  kt","2.4"]
["Bar thickness t mm",15,"Headloss due to friction hf m",{"$f":"B32*(B33/B34)^(4/3)*(B35^2/2/9.81)*SIN(PI()/180*B36)","v":236.09088405464476}]
["Clear spacing of bars b mm",75,"Headloss due to bends hb m",{"$f":"(B35^2/2/9.81)*SIN(PI()/180*B37)","v":5.09683995922528E-2}]
["Approach velocity Vo m/s",1,"Headloss coeff K",{"$f":"B32*(B33/B34)^(4/3)*SIN(PI()/180*B36)+SIN(PI()/180*B37)","v":4633.1031451521303},null,"Spillway Profiles and Discharge coeff"]
["Angle of inclination from horizontal f deg",75,"Total headloss ht m",{"$f":"D34+D33","v":236.14185245423701},null,"Profiles","Coeff"]
["Flow deviation b deg",90,"Trashrack coeff, K1","0.8",null,"Broad; sharp edges",1.5]
["Design Discharge Qd cumec",{"$f":"16.835*2","v":33.67},"Surface area A surface m2",{"$f":"IF(B32=\"0\",0,1/D37*(B33+B34)/B34*B38/B35*1/SIN(PI()/180*B36))","v":{"$error":"#VALUE!"}},null,"Broad; round edges",1.6]
["Height of trashrack bottom from river bed ht",1.25,"Vertical height h m",{"$f":"IF(B32=\"0\",0,B65-B39)","v":2.25},null,"round overfall",1.9]
["Canal invert level (m)",890.65,"Trashrack width B m",{"$f":"IF(B32=\"0\",0,D38/(D39/SIN(B36*PI()/180)))","v":{"$error":"#VALUE!"}},null,"sharp edged",2.1]
[{"$nulls":5},"rounded",2.2000000000000002]
["Orifice Calculations for (B = 2H or provided) rectangular canal downstream of orifice",{"$nulls":4},"roof-shaped",2.2999999999999998]
["Input"]
["Orifice",null,"River"]
["Velocity coeff of orifice c",0.8,"Crest length L m",35,null,"Trashrack Coeff K1"]
["Velocity through orifice Vo m/s",1.5,"Provided Q flood m3/s",976.1,null,"Automatic mechanical cleaning",0.8]
["Manning's coeff of roughness","0.012","Q flood m3/s (Q20 for MHP with Qd>100)",{"$f":"Hydrology!G30","v":16.333805287456535},null,"Manual cleaning",0.3]
["Downstream submergence depth hsub m",0.1,"Used Q flood",{"$f":"IF(D46>0,D46,D47)","v":976.1}]
["Orifice height H m",1.1000000000000001,"Canal & Spillway"]
["Height of orifice from canal bed h bot m",1.25,"Spillway crest height above NWL m",0.1,null,"Velocity coeff of orifice c"]
["Provided water depth in the river hr (m)",3.5,"Spillway discharge coeff",1.6,null,"Sharp edged / roughly finished concrete/masonry",0.6]
["Provided canal width (m) ",21,"Provided Freeboard h fb1 m",3,null,"carefully finished aperture",0.8]
[]
["Output",{"$nulls":4},"Typical values of Manningís n.   "]
["Normal Condition",null,"Flood",null,null,"Type of Orifice","Manningís n","M"]
["Canal witdth d/s of orifice ",{"$f":"IF(B52>0,B52,2*B58)","v":21},"Critical depth of water at crest yc m",{"$f":"IF(D48=\"-\",\"-\",(D48^2/D45^2/9.81)^(1/3))","v":4.2959693727595969},null,"Steel, smooth                 ",1.2E-2,{"$f":"1/G56","v":83.333333333333329}]
["1/Slope of canal immediately d/s of orifice",{"$f":"1/(B38*B47*(B56+2*(B48+B49+B50))^(2/3)/(B56*(B48+B49+B50))^(5/3))^2","v":{"$error":"#VALUE!"}},"1/Slope of canal immediately d/s of orifice",{"$f":"1/(D61*B47*(B56+2*(B48+B49+B50))^(2/3)/(B56*(B48+B49+B50))^(5/3))^2","v":{"$error":"#NAME?"}},null,"Cast iron                         ",1.2999999999999999E-2,{"$f":"1/G57","v":76.92307692307692}]
["Depth of water in canal hc m",{"$f":"B50+B49+B48","v":2.4500000000000002},"Flood head at river hf r = hw+yc m",{"$f":"IF(D48=\"-\",\"-\",B66+D56)","v":7.8959693727595965},null,"Concrete, well finished   ",1.2E-2,83.333333333333329]
["Free board in canal h fb m",{"$f":"IF(D52>=IF(B38<=0.2,0.2,IF(B38<=0.5,0.3,0.4)),D52,IF(B15<=0.2,0.2,IF(B15<=0.5,0.3,0.4)))","v":3},"Head difference dhf",{"$f":"IF(D48=\"-\",\"-\",D58-D62)","v":{"$error":"#NAME?"}},null,"Concrete, unfinished      ",1.4E-2,71.428571428571431]
["Area of orifice A m2",{"$f":"B38/B62","v":22.446666666666669},"Velocity through orifice Vof m/s",{"$f":"IF(D48=\"-\",\"-\",B45*SQRT(2*9.81*D59))","v":{"$error":"#NAME?"}},null,"Planed wood                   ",1.2E-2,83.333333333333329]
["Width of orifice B m",{"$f":"IF(B38/(B46*B49)<B56-0.1,B60/B49,B56-0.1)","v":20.406060606060606},"Q intake Qf cumec",{"$f":"IF(D48=\"-\",\"-\",B45*B60*SQRT(2*9.81*D59))","v":{"$error":"#NAME?"}},null,"Brickwork                        ",1.4999999999999999E-2,66.666666666666671]
["Actual velocity through orifice Vo act m/s",{"$f":"B45*SQRT(2*9.81*B64)","v":1.5},"Depth of water at canal (hc f) m",{"$f":"IF(D48=\"-\",\"-\",Hflood(D58, B60, B45, B47,B57))","v":{"$error":"#NAME?"}},null,"Rubble masonry             ",2.5000000000000001E-2,40]
["Canal width Wc m",{"$f":"IF(B52>0,B52,B61+0.1)","v":21},"Spillway",null,null,"Stonemasonry                ",0.02,50]
["Water level difference dh m",{"$f":"(B46/B45)^2/2/9.81","v":0.17918577981651376},"Ls1 for Qf w/o d/s Obs m",{"$f":"IF(D48=\"-\",\"-\",D61/D51/(B67/2)^1.5)","v":{"$error":"#NAME?"}},null,"Plastered Stone masnry ",1.7000000000000001E-2,58.823529411764703]
["Water depth in the river hr = hc + dh m",{"$f":"IF(B51>0,B51,B64+B58)","v":3.5},"Ls2 for Qf-Qd w/o d/s obstruction m",{"$f":"IF(D48=\"-\",\"-\",(D61-B38)/D51/(B67/2)^1.5)","v":{"$error":"#NAME?"}}]
["Height of weir (hw = hr+0.1) m",{"$f":"B65+0.1","v":3.6},"Ls3 for Qf with d/s Obs m",{"$f":"IF(D48=\"-\",\"-\",D61/D51/B67^1.5)","v":{"$error":"#NAME?"}}]
["Spillway overtopping height h overtop m",{"$f":"(B59-D50)-0.3","v":2.6},"Ls4 for Qf-Qd with d/s obstruction m",{"$f":"IF(D48=\"-\",\"-\",(D61-B38)/D51/B67^1.5)","v":{"$error":"#NAME?"}}]

{"sheet":"BottomIntake","index":5,"n_rows":58,"n_cols":8,"rows_kept":58,"cut":false,"hidden":false,"merged":[[40,0,40,2],[0,0,0,3]]}
["Design of Bottom/Drop Intake"]
["Spreadsheet developed by Mr. Pushpa Chitrakar, Engineering Advisor, SHPP/GTZ"]
["Referances: 6,7,8,12,13","Date",{"$f":"TODAY()","v":"2012-07-20"}]
["SMALL HYDROPOWER PROMOTION PROJECT/GTZ","Revision","2006.05"]
["Project","Sarbari SHP"]
["Developer","Kullu, Himanchal Pradesh, India"]
["Consultant"]
["Designed","Pushpa Chitrakar"]
["Checked","Pushpa Chitrakar"]
[{"$nulls":6},"Critical Depth Considered",1]
[{"$nulls":6},"Critical Depth Not Considered",0]
[{"$nulls":6},"Table 3.4   c values for b"]
[{"$nulls":6},"b","c"]
[{"$nulls":6},0,1]
[{"$nulls":6},2,0.98]
[{"$nulls":6},4,0.96099999999999997]
[{"$nulls":6},6,0.94399999999999995]
[{"$nulls":6},8,0.92700000000000005]
[{"$nulls":6},10,0.91]
[{"$nulls":6},12,0.89400000000000002]
[{"$nulls":6},14,0.879]
[{"$nulls":6},16,0.86499999999999999]
[{"$nulls":6},18,0.85099999999999998]
[{"$nulls":6},20,0.83699999999999997]
[{"$nulls":6},22,0.82499999999999996]
[{"$nulls":6},24,0.81200000000000006]
[{"$nulls":6},26,0.8]
[{"$nulls":6},28,0.78900000000000003]
[{"$nulls":6},32,0.76700000000000002]
[{"$nulls":6},36,0.747]
[{"$nulls":6},40,0.72899999999999998]
[{"$nulls":6},45,0.70699999999999996]
["Input",null,1]
[null,null,"River Width flood (Brf) m =",20]
["River Width (Br) m =",8,"ho flood m =",3]
["Head/Critical Depth of u/s water (ho)m  =",0.22644243411762935,"vo flood m/s =",4]
["Upstream water velocity (vo) m/s =",1.494,"Design Discharge (Qd), m3/s =",2.7]
["River gradient (i) degrees =",9.4619999999999997,"Trashrack witdth/diameter (t) mm =",60]
["Trashrack gradient (b)  deg =",36,"Trashrack clearance (a) mm =",30]
["Contraction coeff (m) =",0.85,"Invert level of crest (masl)",500]
["Aspect ratio (Length across the river/Breadth along the river) =",null,null,3.5464681875145598]
[]
["Output"]
["c/c distance of trash rack bars d mm =",{"$f":"D38+D39","v":90},"Qo u/s of intake (m3/s) normal =",{"$f":"IF(C33=1,SQRT(9.81*B36^3*B35^2),B37*B35*B36)","v":2.699984137294511}]
["Total head (he) m =",{"$f":"B36+B37^2/2/9.81","v":0.34020573686992295},"Qu d/s of intake (m3/s) normal =",{"$f":"D44-D37","v":-1.5862705489144702E-5}]
["kappa (c) =",{"$f":" -0.0000005*B39^3 + 0.0001*B39^2 - 0.0099*B39 + 0.9996","v":0.74947199999999992},"h d/s normal (m)",{"$f":"IF(D45<0,0,D45/D44*B36)","v":0}]
["velocity head (h) m =",{"$f":"IF(C33=1,3/4*B36,2/3*B46*B45)","v":0.16983182558822202},"h flood u/s=",{"$f":"2/3*B46*(D35+D36^2/2/9.81)","v":1.9064041427115186}]
["Correction factor ( c) =",{"$f":"0.6*D39/B44*(COS(B39*PI()/180))^1.5","v":0.14553466902253551},"h d/s flood (m)",{"$f":"IF(D51<0,0,D51/D49*D47)","v":1.8635406113609188}]
["Length of intake (L) m =",{"$f":"SQRT(3*D37/(2*B48*B40*D41*SQRT(2*9.81*B47)))","v":2.2488332970014948},"Qof u/s of intake = Br * hof * vof (m3/s) =",{"$f":"IF(C33=1,SQRT(9.81*D35^3*D34^2),D36*D35*D34)","v":325.49654376045225}]
["Length (L' ) m =",{"$f":"B49*COS(B39*PI()/180)","v":1.8193443547904529},"Q in flood m3/s =",{"$f":"2/3*B48*B40*B51*B50*SQRT(2*9.81*D47)","v":7.3184541490473087}]
["Intake length across the river (b) m =",{"$f":"B49*D41","v":7.9754157468392828},"Quf d/s of intake (m3/s) =",{"$f":"D49-D50","v":318.17808961140497}]
["Area of intake (A=L' *b) m2 =",{"$f":"B49*B51","v":17.935380488922224},{"$f":"IF(C33=1,\"\",\"Critical depth Yc =\")","v":""},{"$f":"IF(C33=1,\"\",ROUND((D37^2/B35^2/9.81)^(1/3),3))","v":""}]
[]
["Collection Chamber"]
["1/Longitudinal slope",30,"1/Mannings coeff",50]
["Horizontal projection of L'",{"$f":"B50*COS(PI()/180*B39)","v":1.4718805016456002},"Min velocity for flushing v min m/s",{"$f":"SQRT(32*D39/1000*(B57*1000/D39)^(1/3))","v":{"$error":"#NAME?"}}]
["Depth of water at the end for Qd h (m)",{"$f":"YDEPTH(D37,D55,B55,B56)","v":{"$error":"#NAME?"}},{"$f":"\"v act of \"&ROUND(D37/B57/B56,2)&IF(D37/B57/B56>D56,\" > \",\" < \")&\"v min of \"&ROUND(D56,2)&IF(D37/B57/B56>D56,\" Ok\",\" Not Ok\")","v":{"$error":"#NAME?"}}]
["Min. freeboard (m)",{"$f":"0.25*B57","v":{"$error":"#NAME?"}}]

{"sheet":"Diagrams","index":6,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Side Intake",null,{"$f":"\"Orific =\"&ROUND(SideIntake!B49,2)&\"x\"&ROUND(SideIntake!B61,2)","v":"Orific =1,1x20,41"}]
["Spreadsheet developed by Mr. Pushpa Chitrakar, Engineering Advisor, SHPP/GTZ",0,0]
[null,0,300]
[null,500,{"$f":"C3","v":300}]
[null,500,{"$f":"SideIntake!B39*1000+C4","v":1550}]
[null,{"$f":"B5+300","v":800},{"$f":"C5","v":1550}]
[null,{"$f":"B6","v":800},300,{"$f":"\"Top =\"&ROUND(SideIntake!$D$58+0.5+SideIntake!$B$40,2)","v":"Top =899,05"}]
[null,{"$f":"B7+1000","v":1800},{"$f":"C7","v":300},{"$f":"B8","v":1800},{"$f":"C10+SideIntake!B49*1000","v":2650},null,{"$f":"\"Crest =\"&ROUND(SideIntake!$B$66+SideIntake!$B$40,2)","v":"Crest =894,25"},{"$f":"\"NWL =\"&ROUND(SideIntake!$B$65+SideIntake!$B$40,2)","v":"NWL =894,15"},{"$f":"\"HFL =\"&ROUND(SideIntake!$D$58+SideIntake!$B$40,2)","v":"HFL =898,55"},null,{"$f":"\"NWL =\"&ROUND(SideIntake!$B$58+SideIntake!$B$40,2)","v":"NWL =893,1"},{"$f":"\"HFL =\"&ROUND(SideIntake!$D$62+SideIntake!$B$40,2)","v":{"$error":"#NAME?"}}]
[null,{"$f":"B8","v":1800},{"$f":"300+SideIntake!B50*1000","v":1550},{"$f":"D8","v":1800},{"$f":"800+SideIntake!D58*1000","v":8695.9693727595968},0,{"$f":"C3+SideIntake!B66*1000","v":3900},{"$f":"SideIntake!B65*1000+C3","v":3800},{"$f":"C3+SideIntake!D58*1000","v":8195.9693727595968},{"$f":"$F$10+300","v":2100},{"$f":"C3+SideIntake!B58*1000","v":2750},{"$f":"C3+SideIntake!D62*1000","v":{"$error":"#NAME?"}}]
[null,{"$f":"B9+300","v":2100},{"$f":"C9","v":1550},{"$f":"D9+300","v":2100},{"$f":"E9","v":8695.9693727595968},1800,{"$f":"G9","v":3900},{"$f":"H9","v":3800},{"$f":"I9","v":8195.9693727595968},{"$f":"J9+1000","v":3100},{"$f":"K9","v":2750},{"$f":"L9","v":{"$error":"#NAME?"}}]
[null,{"$f":"B10","v":2100},{"$f":"C3","v":300},{"$f":"D10","v":2100},{"$f":"E8","v":2650}]
[null,{"$f":"B11+1000","v":3100},{"$f":"C3","v":300},{"$f":"D9","v":1800},{"$f":"E8","v":2650}]
[null,{"$f":"B12","v":3100},0,null,{"$f":"\"Canal =\"&ROUND(SideIntake!B40,2)","v":"Canal =890,65"}]
[null,0,0,{"$f":"B13","v":3100},{"$f":"C12","v":300}]
[null,null,null,{"$f":"D14+400","v":3500},{"$f":"E14","v":300}]
[null,{"$f":"MAX(C2:C14)-MIN(C2:C14)","v":1550},{"$f":"MAX(B2:B14)","v":3100}]
[]
[]
["Bottom Intake"]
[null,null,{"$f":"\"Top =\"&ROUND(BottomIntake!D40,2)","v":"Top =500"},null,{"$f":"\"Top =\"&ROUND(BottomIntake!D40-BottomIntake!B50*TAN(PI()/180*BottomIntake!B39),2)","v":"Top =498,68"},null,{"$f":"\"NWL =\"&ROUND(BottomIntake!D40+BottomIntake!B36,2)","v":"NWL =500,23"},{"$f":"\"HFL =\"&ROUND(BottomIntake!D40+BottomIntake!D47,2)","v":"HFL =501,91"},"Trashrack",null,{"$f":"\"Width =\"&ROUND(BottomIntake!B50,2)","v":"Width =1,82"}]
[null,0,0,{"$f":"1300+BottomIntake!$B$50*1000","v":3119.3443547904526},{"$f":"C21","v":0},0,{"$f":"BottomIntake!$B$36*1000+C23","v":2048.2734809593671},{"$f":"BottomIntake!D35*1000+C23","v":4821.8310468417376},{"$f":"B25","v":1300},{"$f":"C23","v":1821.8310468417378},{"$f":"B24","v":1300},0]
[null,500,0,{"$f":"D21","v":3119.3443547904526},500,1300,{"$f":"G21","v":2048.2734809593671},{"$f":"BottomIntake!D47*1000+C23","v":3728.2351895532565},{"$f":"D21","v":3119.3443547904526},{"$f":"E22","v":500},{"$f":"D21","v":3119.3443547904526},0]
[null,1000,{"$f":"500+BottomIntake!$B$50*1000*TAN(PI()/180*BottomIntake!$B$39)","v":1821.8310468417378},{"$f":"D22+300","v":3419.3443547904526},{"$f":"E22","v":500},{"$f":"D21","v":3119.3443547904526},{"$f":"BottomIntake!D46*1000+E23","v":500},{"$f":"BottomIntake!D48*1000+E23","v":2363.5406113609188}]
[null,1300,{"$f":"C23","v":1821.8310468417378},{"$f":"D23+300","v":3719.3443547904526},0,{"$f":"D23","v":3419.3443547904526},{"$f":"G23","v":500},{"$f":"H23","v":2363.5406113609188}]
[null,{"$f":"B24","v":1300},0,{"$f":"D24+200","v":3919.3443547904526},0,{"$f":"D24","v":3719.3443547904526},{"$f":"G24","v":500},{"$f":"H24","v":2363.5406113609188}]

{"sheet":"HeadraceCanals","index":7,"n_rows":77,"n_cols":10,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
["Canal Design: Proposed design and optimum canal sections"]
["Small Hydropower Promotion Project (SHPP)/GTZ",null,"Spreadsheet by Mr Pushpa Chitrakar"]
["Referances: 6,12,13,15,16",null,"Date",{"$f":"TODAY()","v":"2012-07-20"}]
["SMALL HYDROPOWER PROMOTION PROJECT/GTZ",null,"Revision","2006.05"]
["Project","Sisne Small Hydropower Project"]
["Developer","Gautam Buddha Hydropower P Ltd"]
["Consultant","EPC Consult"]
["Designed","Pushpa Chitrakar"]
["Checked","Pushpa Chitrakar"]
["Input",{"$nulls":7},"Sectional Profiles"]
["Type and Name","Intake Canal","Tailrace","Main2","Main3",null,null,null,"Semicircular"]
["Flow (m3/s)",0.185,0.14499999999999999,0.14499999999999999,0.14499999999999999,null,null,null,"Rectangular"]
["Roughness coefficient (n)","0.02","0.017","0.02","0.02",null,null,null,"Triangular"]
["Sectional Profile","Rectangular","Trapezoidal","Semicircular","Triangular",null,null,null,"Trapezoidal"]
["Side slope N (1V:NHorizontal)","0","0.5","0","0.5",null,null,null,"Side Slope"]
["Length of the canal (m)",20,40,150,120,null,null,null,"Lined/vertical",0]
["1/Canal slope (s)",77,200,30,72,null,null,null,"Unlined fissured/disintegrated rock/tough hardpen cut",0.5]
["Channel Depth/diameter D (m)",0.3,0.52500000000000002,0.3,0.3,null,null,null,"Unlined cemented gravel/stiff clay/ordinary hardpan cut ",0.75]
["Freeboard  FB (m)",0.3,0.25,0.15,0.15,null,null,null,"Unlined firm/gravelyl/clay/side hill c/s in average loam cut",1]
["Channel Width (B) m",0.5,1,0.4,0.4,null,null,null,"Unlined cuts/fills in average loam or gravelly loam  ",1.5]
["Channel Drops di m",0,0,0,0,null,null,null,"Unlined cuts/fills in loose sandy loam  ",2]
["Channel Drops Horizontal length hi m",0,0,0,0,null,null,null,"Unlined cuts/fills in very sandy soil  ",3]
["Desired velocity Vo (m/s)",1,1.5,1.5,1.5]
[]
[{"$nulls":8},"Manningís n for headrace channel.   "]
["Output",{"$nulls":7},"Unlined Clean   ",2.1999999999999999E-2]
["Side slope d (degrees)",{"$f":"IF(OR(UPPER(B14)=\"TRAPEZOIDAL\",UPPER(B14)=\"TRIANGULAR\"),DEGREES(ATAN(1/B15)),0)","v":0},{"$f":"IF(OR(UPPER(C14)=\"TRAPEZOIDAL\",UPPER(C14)=\"TRIANGULAR\"),DEGREES(ATAN(1/C15)),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(UPPER(D14)=\"TRAPEZOIDAL\",UPPER(D14)=\"TRIANGULAR\"),DEGREES(ATAN(1/D15)),0)","v":0},{"$f":"IF(OR(UPPER(E14)=\"TRAPEZOIDAL\",UPPER(E14)=\"TRIANGULAR\"),DEGREES(ATAN(1/E15)),0)","v":{"$error":"#VALUE!"}},null,null,null,"Unlined Gravelly   ",2.5000000000000001E-2]
["Canal slope S",{"$f":"1/B17","v":1.2987012987012988E-2},{"$f":"1/C17","v":5.0000000000000001E-3},{"$f":"1/D17","v":3.3333333333333333E-2},{"$f":"1/E17","v":1.3888888888888888E-2},null,null,null,"Unlined Weedy   ",0.03]
["Total depth  H (m)",{"$f":"B18+B19","v":0.6},{"$f":"C18+C19","v":0.77500000000000002},{"$f":"D18+D19","v":0.44999999999999996},{"$f":"E18+E19","v":0.44999999999999996},null,null,null,"Unlined Stony, cobbles (or natural streams)   ",3.5000000000000003E-2]
["Chainage L (m)",{"$f":"IF(OR(UPPER($B$5)=\"DIFFERENT PROJECTS\",$B$5=\"\"),B16+B22,IF(ISERROR(A30+B16+B22),B16+B22,A30+B16+B22))","v":20},{"$f":"IF(UPPER($B$5)=\"DIFFERENT PROJECTS\",C16+C22,IF(ISERROR(B30+C16+C22),C16+C22,B30+C16+C22))","v":60},{"$f":"IF(UPPER($B$5)=\"DIFFERENT PROJECTS\",D16+D22,IF(ISERROR(C30+D16+D22),D16+D22,C30+D16+D22))","v":210},{"$f":"IF(UPPER($B$5)=\"DIFFERENT PROJECTS\",E16+E22,IF(ISERROR(D30+E16+E22),E16+E22,D30+E16+E22))","v":330},null,null,null,"Lined Brass   ",1.0999999999999999E-2]
[{"$nulls":8},"Lined Steel, smooth   ",1.2E-2]
["Present canal",{"$nulls":7},"Lined Steel, painted   ",1.4E-2]
["Area A m2",{"$f":"IF(UPPER(B14)=\"SEMICIRCULAR\",PI()*B18^2/4/2,IF(UPPER(B14)=\"TRAPEZOIDAL\",(B20+B15*B18)*B18,IF(UPPER(B14)=\"RECTANGULAR\",B18*B20,B18*B20/2)))","v":0.15},{"$f":"IF(UPPER(C14)=\"SEMICIRCULAR\",PI()*C18^2/4/2,IF(UPPER(C14)=\"TRAPEZOIDAL\",(C20+C15*C18)*C18,IF(UPPER(C14)=\"RECTANGULAR\",C18*C20,C18*C20/2)))","v":{"$error":"#VALUE!"}},{"$f":"IF(UPPER(D14)=\"SEMICIRCULAR\",PI()*D18^2/4/2,IF(UPPER(D14)=\"TRAPEZOIDAL\",(D20+D15*D18)*D18,IF(UPPER(D14)=\"RECTANGULAR\",D18*D20,D18*D20/2)))","v":3.5342917352885174E-2},{"$f":"IF(UPPER(E14)=\"SEMICIRCULAR\",PI()*E18^2/4/2,IF(UPPER(E14)=\"TRAPEZOIDAL\",(E20+E15*E18)*E18,IF(UPPER(E14)=\"RECTANGULAR\",E18*E20,E18*E20/2)))","v":0.06},null,null,null,"Lined Cast iron   ",1.2999999999999999E-2]
["Top Width T (m)",{"$f":"IF(UPPER(B14)=\"TRAPEZOIDAL\",(B20+2*B18*B15),B20)","v":0.5},{"$f":"IF(UPPER(C14)=\"TRAPEZOIDAL\",(C20+2*C18*C15),C20)","v":{"$error":"#VALUE!"}},{"$f":"IF(UPPER(D14)=\"TRAPEZOIDAL\",(D20+2*D18*D15),D20)","v":0.4},{"$f":"IF(UPPER(E14)=\"TRAPEZOIDAL\",(E20+2*E18*E15),E20)","v":0.4},null,null,null,"Lined Concrete, well finished   ",1.2E-2]
["Wetted Perimeter P (m)",{"$f":"IF(UPPER(B14)=\"SEMICIRCULAR\",PI()*B18/2,IF(UPPER(B14)=\"TRAPEZOIDAL\",B20+2*B18*SQRT(1+B15^2),IF(UPPER(B14)=\"RECTANGULAR\",2*B18+B20,2*B18*SQRT(1+B15^2))))","v":1.1000000000000001},{"$f":"IF(UPPER(C14)=\"SEMICIRCULAR\",PI()*C18/2,IF(UPPER(C14)=\"TRAPEZOIDAL\",C20+2*C18*SQRT(1+C15^2),IF(UPPER(C14)=\"RECTANGULAR\",2*C18+C20,2*C18*SQRT(1+C15^2))))","v":{"$error":"#VALUE!"}},{"$f":"IF(UPPER(D14)=\"SEMICIRCULAR\",PI()*D18/2,IF(UPPER(D14)=\"TRAPEZOIDAL\",D20+2*D18*SQRT(1+D15^2),IF(UPPER(D14)=\"RECTANGULAR\",2*D18+D20,2*D18*SQRT(1+D15^2))))","v":0.47123889803846897},{"$f":"IF(UPPER(E14)=\"SEMICIRCULAR\",PI()*E18/2,IF(UPPER(E14)=\"TRAPEZOIDAL\",E20+2*E18*SQRT(1+E15^2),IF(UPPER(E14)=\"RECTANGULAR\",2*E18+E20,2*E18*SQRT(1+E15^2))))","v":{"$error":"#VALUE!"}},null,null,null,"Lined Concrete, unfinished   ",1.4E-2]
["Hydraulic Radius r (m)",{"$f":"B33/B35","v":0.13636363636363635},{"$f":"C33/C35","v":{"$error":"#VALUE!"}},{"$f":"D33/D35","v":7.4999999999999997E-2},{"$f":"E33/E35","v":{"$error":"#VALUE!"}},null,null,null,"Lined Planed wood   ",1.2E-2]
["Calculated flow (m3/s) & remarks",{"$f":"IF(B33*B36^(2/3)*B28^0.5/B13<B12,ROUND(B33*B36^(2/3)*B28^0.5/B13,3)&\" low\",IF(B33*B36^(2/3)*B28^0.5/B13>B12,ROUND(B33*B36^(2/3)*B28^0.5/B13,3)&\" high\",B33*B36^(2/3)*B28^0.5/B13))","v":{"$error":"#VALUE!"}},{"$f":"IF(C33*C36^(2/3)*C28^0.5/C13<C12,ROUND(C33*C36^(2/3)*C28^0.5/C13,3)&\" low\",IF(C33*C36^(2/3)*C28^0.5/C13>C12,ROUND(C33*C36^(2/3)*C28^0.5/C13,3)&\" high\",C33*C36^(2/3)*C28^0.5/C13))","v":{"$error":"#VALUE!"}},{"$f":"IF(D33*D36^(2/3)*D28^0.5/D13<D12,ROUND(D33*D36^(2/3)*D28^0.5/D13,3)&\" low\",IF(D33*D36^(2/3)*D28^0.5/D13>D12,ROUND(D33*D36^(2/3)*D28^0.5/D13,3)&\" high\",D33*D36^(2/3)*D28^0.5/D13))","v":{"$error":"#VALUE!"}},{"$f":"IF(E33*E36^(2/3)*E28^0.5/E13<E12,ROUND(E33*E36^(2/3)*E28^0.5/E13,3)&\" low\",IF(E33*E36^(2/3)*E28^0.5/E13>E12,ROUND(E33*E36^(2/3)*E28^0.5/E13,3)&\" high\",E33*E36^(2/3)*E28^0.5/E13))","v":{"$error":"#VALUE!"}},null,null,null,"Lined Clay tile   ",1.4E-2]
["Comment on freeboard",{"$f":"IF(B19<B52,\"low \",\"ok\")","v":"ok"},{"$f":"IF(C19<C52,\"low \",\"ok\")","v":"low "},{"$f":"IF(D19<D52,\"low \",\"ok\")","v":"ok"},{"$f":"IF(E19<E52,\"low \",\"ok\")","v":"ok"},null,null,null,"Lined Brickwork   ",1.4999999999999999E-2]
["Velocity V m/s",{"$f":"B12/B33","v":1.2333333333333334},{"$f":"C12/C33","v":{"$error":"#VALUE!"}},{"$f":"D12/D33","v":4.1026607552577463},{"$f":"E12/E33","v":2.4166666666666665},null,null,null,"Lined Asphalt   ",1.6E-2]
["Critical Velocity Vc m/s & Remarks",{"$f":"IF(B39<0.8*SQRT(B33*9.81/B34),ROUND(SQRT(B33*9.81/B34),2)&\" Ok\",ROUND(SQRT(B33*9.81/B34),2)&\" Not Ok\")","v":"1,72 Ok"},{"$f":"IF(C39<0.8*SQRT(C33*9.81/C34),ROUND(SQRT(C33*9.81/C34),2)&\" Ok\",ROUND(SQRT(C33*9.81/C34),2)&\" Not Ok\")","v":{"$error":"#VALUE!"}},{"$f":"IF(D39<0.8*SQRT(D33*9.81/D34),ROUND(SQRT(D33*9.81/D34),2)&\" Ok\",ROUND(SQRT(D33*9.81/D34),2)&\" Not Ok\")","v":"0,93 Not Ok"},{"$f":"IF(E39<0.8*SQRT(E33*9.81/E34),ROUND(SQRT(E33*9.81/E34),2)&\" Ok\",ROUND(SQRT(E33*9.81/E34),2)&\" Not Ok\")","v":"1,21 Not Ok"},null,null,null,"Lined Corrugated metal   ",2.1999999999999999E-2]
["Headloss hl (m)",{"$f":"B28*B16+B21","v":0.25974025974025977},{"$f":"C28*C16+C21","v":0.2},{"$f":"D28*D16+D21","v":5},{"$f":"E28*E16+E21","v":1.6666666666666665},null,null,null,"Lined Rubble masonry   ",2.5000000000000001E-2]
["Total headloss Hl(m)",{"$f":"IF(ISERROR(A42+B41),B41,A42+B41)","v":0.25974025974025977},{"$f":"IF(ISERROR(B42+C41),C41,B42+C41)","v":0.45974025974025978},{"$f":"IF(ISERROR(C42+D41),D41,C42+D41)","v":5.4597402597402596},{"$f":"IF(ISERROR(D42+E41),E41,D42+E41)","v":7.1264069264069256},null,null,null,"Lined Stonemasonry   ",0.02]
["Critical dia of sediment d crit (mm)",{"$f":"11000*B36*B28","v":19.480519480519483},{"$f":"11000*C36*C28","v":{"$error":"#VALUE!"}},{"$f":"11000*D36*D28","v":27.5},{"$f":"11000*E36*E28","v":{"$error":"#VALUE!"}},null,null,null,"Plastered Stone masonry ",1.7000000000000001E-2]
[]
[]
["Optimum canal"]
["Area Ao m2",{"$f":"B12/B23","v":0.185},{"$f":"C12/C23","v":9.6666666666666665E-2},{"$f":"D12/D23","v":9.6666666666666665E-2},{"$f":"E12/E23","v":9.6666666666666665E-2}]
["Top Width T (m)",{"$f":"IF(UPPER(B14)=\"TRAPEZOIDAL\",(B54+2*B51*B15),B54)","v":0.6021627686929838},{"$f":"IF(UPPER(C14)=\"TRAPEZOIDAL\",(C54+2*C51*C15),C54)","v":{"$error":"#VALUE!"}},{"$f":"IF(UPPER(D14)=\"TRAPEZOIDAL\",(D54+2*D51*D15),D54)","v":0.99492043232947369},{"$f":"IF(UPPER(E14)=\"TRAPEZOIDAL\",(E54+2*E51*E15),E54)","v":{"$error":"#VALUE!"}}]
["Critical Velocity Vc m/s & Remarks",{"$f":"ROUND(SQRT(B47*9.81/B48),2)&IF(B23<0.8*SQRT(B47*9.81/B48),\" Ok\",\" Not Ok\")","v":"1,74 Ok"},{"$f":"ROUND(SQRT(C47*9.81/C48),2)&IF(C23<0.8*SQRT(C47*9.81/C48),\" Ok\",\" Not Ok\")","v":{"$error":"#VALUE!"}},{"$f":"ROUND(SQRT(D47*9.81/D48),2)&IF(D23<0.8*SQRT(D47*9.81/D48),\" Ok\",\" Not Ok\")","v":"0,98 Not Ok"},{"$f":"ROUND(SQRT(E47*9.81/E48),2)&IF(E23<0.8*SQRT(E47*9.81/E48),\" Ok\",\" Not Ok\")","v":{"$error":"#VALUE!"}}]
["Hydraulic Radius ro (m)",{"$f":"IF(UPPER(B14)=\"SEMICIRCULAR\",0.4*SQRT(B47),IF(UPPER(B14)=\"TRAPEZOIDAL\",0.5*SQRT(SIN(PI()*B27/180)*B47/(2-COS(PI()*B27/180))),0.35*SQRT(B47)))","v":0.15054069217324595},{"$f":"IF(UPPER(C14)=\"SEMICIRCULAR\",0.4*SQRT(C47),IF(UPPER(C14)=\"TRAPEZOIDAL\",0.5*SQRT(SIN(PI()*C27/180)*C47/(2-COS(PI()*C27/180))),0.35*SQRT(C47)))","v":{"$error":"#VALUE!"}},{"$f":"IF(UPPER(D14)=\"SEMICIRCULAR\",0.4*SQRT(D47),IF(UPPER(D14)=\"TRAPEZOIDAL\",0.5*SQRT(SIN(PI()*D27/180)*D47/(2-COS(PI()*D27/180))),0.35*SQRT(D47)))","v":0.12436505404118421},{"$f":"IF(UPPER(E14)=\"SEMICIRCULAR\",0.4*SQRT(E47),IF(UPPER(E14)=\"TRAPEZOIDAL\",0.5*SQRT(SIN(PI()*E27/180)*E47/(2-COS(PI()*E27/180))),0.35*SQRT(E47)))","v":0.10881942228603618}]
["Channel Depth/diameter Do (m)",{"$f":"IF(UPPER(B14)=\"SEMICIRCULAR\",4*B50,IF(UPPER(B14)=\"TRAINGULAR\",2.8*B50,2*B50))","v":0.3010813843464919},{"$f":"IF(UPPER(C14)=\"SEMICIRCULAR\",4*C50,IF(UPPER(C14)=\"TRAINGULAR\",2.8*C50,2*C50))","v":{"$error":"#VALUE!"}},{"$f":"IF(UPPER(D14)=\"SEMICIRCULAR\",4*D50,IF(UPPER(D14)=\"TRAINGULAR\",2.8*D50,2*D50))","v":0.49746021616473685},{"$f":"IF(UPPER(E14)=\"SEMICIRCULAR\",4*E50,IF(UPPER(E14)=\"TRAINGULAR\",2.8*E50,2*E50))","v":0.21763884457207236}]
["Freeboard  Fbo (m)",{"$f":"MIN(0.5*B18, 0.3)","v":0.15},{"$f":"MIN(0.5*C18, 0.3)","v":0.26250000000000001},{"$f":"MIN(0.5*D18, 0.3)","v":0.15},{"$f":"MIN(0.5*E18, 0.3)","v":0.15}]
["Total depth Ho (m)",{"$f":"B51+B52","v":0.45108138434649192},{"$f":"C51+C52","v":{"$error":"#VALUE!"}},{"$f":"D51+D52","v":0.64746021616473681},{"$f":"E51+E52","v":0.36763884457207235}]
["Channel Width Bo (m)",{"$f":"IF(UPPER(B14)=\"SEMICIRCULAR\",2*B51,IF(UPPER(B14)=\"RECTANGULAR\",4*B50,IF(UPPER(B14)=\"TRAINGULAR\",5.7*B50,4*B50/SIN(PI()*B27/180))))","v":0.6021627686929838},{"$f":"IF(UPPER(C14)=\"SEMICIRCULAR\",2*C51,IF(UPPER(C14)=\"RECTANGULAR\",4*C50,IF(UPPER(C14)=\"TRAINGULAR\",5.7*C50,4*C50/SIN(PI()*C27/180))))","v":{"$error":"#VALUE!"}},{"$f":"IF(UPPER(D14)=\"SEMICIRCULAR\",2*D51,IF(UPPER(D14)=\"RECTANGULAR\",4*D50,IF(UPPER(D14)=\"TRAINGULAR\",5.7*D50,4*D50/SIN(PI()*D27/180))))","v":0.99492043232947369},{"$f":"IF(UPPER(E14)=\"SEMICIRCULAR\",2*E51,IF(UPPER(E14)=\"RECTANGULAR\",4*E50,IF(UPPER(E14)=\"TRAINGULAR\",5.7*E50,4*E50/SIN(PI()*E27/180))))","v":{"$error":"#VALUE!"}}]
["Canal Slope ",{"$f":"B23^2*B13^2/B50^(4/3)","v":{"$error":"#VALUE!"}},{"$f":"C23^2*C13^2/C50^(4/3)","v":{"$error":"#VALUE!"}},{"$f":"D23^2*D13^2/D50^(4/3)","v":{"$error":"#VALUE!"}},{"$f":"E23^2*E13^2/E50^(4/3)","v":{"$error":"#VALUE!"}}]
["Headloss hlo (m)",{"$f":"B55*B16+B21","v":{"$error":"#VALUE!"}},{"$f":"C55*C16+C21","v":{"$error":"#VALUE!"}},{"$f":"D55*D16+D21","v":{"$error":"#VALUE!"}},{"$f":"E55*E16+E21","v":{"$error":"#VALUE!"}}]
["Total headloss Hlo(m)",{"$f":"IF(ISERROR(A57+B56),B56,A57+B56)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISERROR(B57+C56),C56,B57+C56)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISERROR(C57+D56),D56,C57+D56)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISERROR(D57+E56),E56,D57+E56)","v":{"$error":"#VALUE!"}}]
["Critical dia of sediment d crito (mm)",{"$f":"11000*B50*B55","v":{"$error":"#VALUE!"}},{"$f":"11000*C50*C55","v":{"$error":"#VALUE!"}},{"$f":"11000*D50*D55","v":{"$error":"#VALUE!"}},{"$f":"11000*E50*E55","v":{"$error":"#VALUE!"}}]
[]
[null,{"$f":"IF(UPPER(B14)=\"RECTANGULAR\",\"B = \"&ROUND(B20,3)&\" & \"&ROUND(B48,3),\"\")","v":"B = 0,5 & 0,602"},{"$f":"IF(UPPER(C14)=\"RECTANGULAR\",\"B = \"&ROUND(C20,3)&\" & \"&ROUND(C48,3),\"\")","v":""},{"$f":"IF(UPPER(D14)=\"RECTANGULAR\",\"B = \"&ROUND(D20,3)&\" & \"&ROUND(D48,3),\"\")","v":""},{"$f":"IF(UPPER(E14)=\"RECTANGULAR\",\"B = \"&ROUND(E20,3)&\" & \"&ROUND(E48,3),\"\")","v":""}]
[null,{"$f":"IF(UPPER(B14)=\"RECTANGULAR\",\"D = \"&ROUND(B18+B19,3)&\" & \"&ROUND(B51+B52,3),\"\")","v":"D = 0,6 & 0,451"},{"$f":"IF(UPPER(C14)=\"RECTANGULAR\",\"D = \"&ROUND(C18+C19,3)&\" & \"&ROUND(C51+C52,3),\"\")","v":""},{"$f":"IF(UPPER(D14)=\"RECTANGULAR\",\"D = \"&ROUND(D18+D19,3)&\" & \"&ROUND(D51+D52,3),\"\")","v":""},{"$f":"IF(UPPER(E14)=\"RECTANGULAR\",\"D = \"&ROUND(E18+E19,3)&\" & \"&ROUND(E51+E52,3),\"\")","v":""}]
[null,{"$f":"IF(UPPER(B14)=\"RECTANGULAR\",\"d & FB  (\"&ROUND(B18,3)&\" & \"&ROUND(B19,3)&\")     &     (\"&ROUND(B51,3)&\" & \"&ROUND(B52,3)&\")\",\"\")","v":"d & FB  (0,3 & 0,3)     &     (0,301 & 0,15)"},{"$f":"IF(UPPER(C14)=\"RECTANGULAR\",\"d & FB  (\"&ROUND(C18,3)&\" & \"&ROUND(C19,3)&\")     &     (\"&ROUND(C51,3)&\" & \"&ROUND(C52,3)&\")\",\"\")","v":""},{"$f":"IF(UPPER(D14)=\"RECTANGULAR\",\"d & FB  (\"&ROUND(D18,3)&\" & \"&ROUND(D19,3)&\")     &     (\"&ROUND(D51,3)&\" & \"&ROUND(D52,3)&\")\",\"\")","v":""},{"$f":"IF(UPPER(E14)=\"RECTANGULAR\",\"d & FB  (\"&ROUND(E18,3)&\" & \"&ROUND(E19,3)&\")     &     (\"&ROUND(E51,3)&\" & \"&ROUND(E52,3)&\")\",\"\")","v":""}]
[null,{"$f":"IF(UPPER(B14)=\"TRAPEZOIDAL\",\"B = \"&ROUND(B20,3)&\" & \"&ROUND(B48,3),\"\")","v":""},{"$f":"IF(UPPER(C14)=\"TRAPEZOIDAL\",\"B = \"&ROUND(C20,3)&\" & \"&ROUND(C48,3),\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(UPPER(D14)=\"TRAPEZOIDAL\",\"B = \"&ROUND(D20,3)&\" & \"&ROUND(D48,3),\"\")","v":""},{"$f":"IF(UPPER(E14)=\"TRAPEZOIDAL\",\"B = \"&ROUND(E20,3)&\" & \"&ROUND(E48,3),\"\")","v":""}]
[null,{"$f":"IF(UPPER(B14)=\"TRAPEZOIDAL\",\"D = \"&ROUND(B18+B19,3)&\" & \"&ROUND(B51+B52,3),\"\")","v":""},{"$f":"IF(UPPER(C14)=\"TRAPEZOIDAL\",\"D = \"&ROUND(C18+C19,3)&\" & \"&ROUND(C51+C52,3),\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(UPPER(D14)=\"TRAPEZOIDAL\",\"D = \"&ROUND(D18+D19,3)&\" & \"&ROUND(D51+D52,3),\"\")","v":""},{"$f":"IF(UPPER(E14)=\"TRAPEZOIDAL\",\"D = \"&ROUND(E18+E19,3)&\" & \"&ROUND(E51+E52,3),\"\")","v":""}]
[null,{"$f":"IF(UPPER(B14)=\"TRAPEZOIDAL\",\"d & FB  (\"&ROUND(B18,3)&\" & \"&ROUND(B19,3)&\")     &     (\"&ROUND(B51,3)&\" & \"&ROUND(B52,3)&\")\",\"\")","v":""},{"$f":"IF(UPPER(C14)=\"TRAPEZOIDAL\",\"d & FB  (\"&ROUND(C18,3)&\" & \"&ROUND(C19,3)&\")     &     (\"&ROUND(C51,3)&\" & \"&ROUND(C52,3)&\")\",\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(UPPER(D14)=\"TRAPEZOIDAL\",\"d & FB  (\"&ROUND(D18,3)&\" & \"&ROUND(D19,3)&\")     &     (\"&ROUND(D51,3)&\" & \"&ROUND(D52,3)&\")\",\"\")","v":""},{"$f":"IF(UPPER(E14)=\"TRAPEZOIDAL\",\"d & FB  (\"&ROUND(E18,3)&\" & \"&ROUND(E19,3)&\")     &     (\"&ROUND(E51,3)&\" & \"&ROUND(E52,3)&\")\",\"\")","v":""}]
[]
[null,{"$f":"IF(UPPER(B14)=\"SEMICIRCULAR\",\"B = \"&ROUND(B20,3)&\" & \"&ROUND(B48,3),\"\")","v":""},{"$f":"IF(UPPER(C14)=\"SEMICIRCULAR\",\"B = \"&ROUND(C20,3)&\" & \"&ROUND(C48,3),\"\")","v":""},{"$f":"IF(UPPER(D14)=\"SEMICIRCULAR\",\"B = \"&ROUND(D20,3)&\" & \"&ROUND(D48,3),\"\")","v":"B = 0,4 & 0,995"},{"$f":"IF(UPPER(E14)=\"SEMICIRCULAR\",\"B = \"&ROUND(E20,3)&\" & \"&ROUND(E48,3),\"\")","v":""}]
[null,{"$f":"IF(UPPER(B14)=\"SEMICIRCULAR\",\"D = \"&ROUND(B18+B19,3)&\" & \"&ROUND(B51+B52,3),\"\")","v":""},{"$f":"IF(UPPER(C14)=\"SEMICIRCULAR\",\"D = \"&ROUND(C18+C19,3)&\" & \"&ROUND(C51+C52,3),\"\")","v":""},{"$f":"IF(UPPER(D14)=\"SEMICIRCULAR\",\"D = \"&ROUND(D18+D19,3)&\" & \"&ROUND(D51+D52,3),\"\")","v":"D = 0,45 & 0,647"},{"$f":"IF(UPPER(E14)=\"SEMICIRCULAR\",\"D = \"&ROUND(E18+E19,3)&\" & \"&ROUND(E51+E52,3),\"\")","v":""}]
[]
[null,{"$f":"IF(UPPER(B14)=\"SEMICIRCULAR\",\"d & FB  (\"&ROUND(B18,3)&\" & \"&ROUND(B19,3)&\")     &     (\"&ROUND(B51,3)&\" & \"&ROUND(B52,3)&\")\",\"\")","v":""},{"$f":"IF(UPPER(C14)=\"SEMICIRCULAR\",\"d & FB  (\"&ROUND(C18,3)&\" & \"&ROUND(C19,3)&\")     &     (\"&ROUND(C51,3)&\" & \"&ROUND(C52,3)&\")\",\"\")","v":""},{"$f":"IF(UPPER(D14)=\"SEMICIRCULAR\",\"d & FB  (\"&ROUND(D18,3)&\" & \"&ROUND(D19,3)&\")     &     (\"&ROUND(D51,3)&\" & \"&ROUND(D52,3)&\")\",\"\")","v":"d & FB  (0,3 & 0,15)     &     (0,497 & 0,15)"},{"$f":"IF(UPPER(E14)=\"SEMICIRCULAR\",\"d & FB  (\"&ROUND(E18,3)&\" & \"&ROUND(E19,3)&\")     &     (\"&ROUND(E51,3)&\" & \"&ROUND(E52,3)&\")\",\"\")","v":""}]
[]
[null,{"$f":"IF(UPPER(B14)=\"TRIANGULAR\",\"B = \"&ROUND(B20,3)&\" & \"&ROUND(B48,3),\"\")","v":""},{"$f":"IF(UPPER(C14)=\"TRIANGULAR\",\"B = \"&ROUND(C20,3)&\" & \"&ROUND(C48,3),\"\")","v":""},{"$f":"IF(UPPER(D14)=\"TRIANGULAR\",\"B = \"&ROUND(D20,3)&\" & \"&ROUND(D48,3),\"\")","v":""},{"$f":"IF(UPPER(E14)=\"TRIANGULAR\",\"B = \"&ROUND(E20,3)&\" & \"&ROUND(E48,3),\"\")","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(UPPER(B14)=\"TRIANGULAR\",\"D = \"&ROUND(B18+B19,3)&\" & \"&ROUND(B51+B52,3),\"\")","v":""},{"$f":"IF(UPPER(C14)=\"TRIANGULAR\",\"D = \"&ROUND(C18+C19,3)&\" & \"&ROUND(C51+C52,3),\"\")","v":""},{"$f":"IF(UPPER(D14)=\"TRIANGULAR\",\"D = \"&ROUND(D18+D19,3)&\" & \"&ROUND(D51+D52,3),\"\")","v":""},{"$f":"IF(UPPER(E14)=\"TRIANGULAR\",\"D = \"&ROUND(E18+E19,3)&\" & \"&ROUND(E51+E52,3),\"\")","v":"D = 0,45 & 0,368"}]
[]
[]
[]
[null,null,{"$f":"IF(UPPER(C14)=\"TRIANGULAR\",\"d & FB  (\"&ROUND(C18,3)&\" & \"&ROUND(C19,3)&\")     &     (\"&ROUND(C51,3)&\" & \"&ROUND(C52,3)&\")\",\"\")","v":""}]

{"sheet":"HeadracePipe","index":8,"n_rows":79,"n_cols":12,"rows_kept":79,"cut":false,"hidden":false,"merged":[]}
[null,null,"HEADRACE PIPE CALCULATIONS"]
["Small Hydropower Promotion Project (SHPP)/GTZ",{"$nulls":4},"Spreadsheet by Mr Pushpa Chitrakar"]
["Referances: 2,4, 6,12,13,15,16",{"$nulls":4},"Date",{"$f":"TODAY()","v":"2012-07-20"}]
["SMALL HYDROPOWER PROMOTION PROJECT/GTZ",{"$nulls":4},"Revision","2006.05"]
["Project:   ",{"$f":"Hydrology!B5","v":"Upper Jogmai SHP"},null,"Location:","Jogmai"]
["Developer","Kankaimai Hydropower P Ltd"]
["Consultant","EPC Consult"]
["Designed","Pushpa Chitrakar"]
["Checked","Pushpa Chitrakar"]
[]
["INPUT"]
[]
[{"$nulls":6},"Economic life (years)",15]
[{"$nulls":10},"Valves & Coeff"]
["Hydraulics:",{"$nulls":9},"Spherical/No valves",0]
["Diversion flow Qd (m3/s)",null,null,0.16,null,null,"U/S Invert Level (m)",1950,null,null,"Gate",0.1]
["Flow in each pipe Qi (m3/s)",null,null,{"$f":"D16/H23","v":0.16},null,null,"% head available or  headloss hlt (m)",0.95,null,null,"Butterfly",0.3]
["Gross headHg (m)",null,null,7,null,null,"Entrance Type",0.8]
[{"$nulls":6},"Bending radius (r/d)",0.3]
[{"$nulls":10},"Yes"]
["Headrace pipe",{"$nulls":9},"No"]
["Pipe Material",null,null,"HDPE",null,null,"Exit (Yes/No)","Yes"]
["Welded / Flat rolled if steel",null,null,"NA",null,null,"No of pipes",1,null,null,"Pipe type"]
["Rolled if steel",null,null,"NA",null,null,"Bending angle 01",20,null,null,"Steel"]
["Type if steel",null,null,"NA",null,null,"Bending angle 02",4,null,null,"HDPE"]
["Burried or exposed",null,null,"Burried",null,null,"Bending angle 03",6,null,null,"PVC"]
["Type of valve",null,null,0,null,null,"Bending angle 04",20]
["Non standard ultimate tensile strength (UTS) N/mm2",null,null,0,null,null,"Bending angle 05",null,null,null,"Steel"]
["Estimated pipe diameter d(mm)",null,null,{"$f":"41*(D17*1000)^0.38","v":282.06516237397221},null,null,"Bending angle 06",null,null,null,"Welded"]
["Provided pipe diameter d(mm)",null,null,260,null,null,"Bending angle 07",null,null,null,"Flat rolled"]
["Min pipe thickness t (mm)",null,null,{"$f":"IF(UPPER(D22)=\"STEEL\",MAX(3,2.5*MAX(D33)/1000+1.2),\"NA\")","v":"NA"},null,null,"Bending angle 08",null,null,null,"NA"]
["Provided pipe thickness t (mm)",null,null,3,null,null,"Bending angle 09",null,null,null,"Steel"]
["Pipe Length L (m)",null,null,140,null,null,"Bending angle 10",null,null,null,"Rolled"]
[{"$nulls":10},"NA"]
["Trashrack",{"$nulls":9},"Steel type"]
["k","t","b","Vo","f","b","Q","H",null,null,"Ungraded"]
[2.4,6,20,1,60,0,{"$f":"D16","v":0.16},3,null,null,"IS"]
[{"$nulls":10},"NA"]
["Expansion Joints",{"$nulls":9},"Installation"]
["Tmax (deg)","T installation","Tmin","1st Pipe length(m)","2nd Pipe L (m)","3rd Pipe L (m)","4th Pipe L (m)","5th Pipe L (m)",null,null,"Burried"]
[40,20,4,50,100,150,200,250,null,null,"Exposed"]
[]
["OUTPUT",{"$nulls":9},"Entrance #"]
["Trashrack",{"$nulls":9},"Hooded",1]
["hf","hb","H coeff","H","S","B","Min Submergence","CGL=1.5v^2/2g",null,null,"Inward projecting ",0.8]
[{"$f":"A37*(B37/C37)^(4/3)*(D37^2/2/9.81)*SIN(PI()/180*E37)","v":2.1275080400055733E-2},{"$f":"(D37^2/2/9.81)*SIN(PI()/180*F37)","v":0},{"$f":"A37*(B37/C37)^(4/3)*SIN(PI()/180*E37)+SIN(PI()/180*F37)","v":0.41741707744909351},{"$f":"B46+A46","v":2.1275080400055733E-2},{"$f":"1/0.3*(B37+C37)/C37*G37/D37*1/SIN(PI()/180*E37)","v":0.8005923732762813},{"$f":"E46/(H37/SIN(PI()*E37/180))","v":0.23111111111111116},{"$f":"D30/1000*(1+2.3*D59/SQRT(9.81*D30/1000))","v":1.387946870295762},{"$f":"1.5*D59^2/9.81/2","v":0.69376043816889854},null,null,"Sharp cornered ",0.5]
[{"$nulls":10},"Slightly rounded ",0.2]
[{"$nulls":10},"Bell mouth ",0.04]
["Turbulent loss coefficients"]
["K inlet",{"$f":"H18","v":0.8},null,"K bend 05",{"$f":"IF(H28=0,0,FORECAST(H28,{0.5,0.75,1},{20,45,90})*H$19)","v":0},null,"K bend 10",{"$f":"IF(H33=0,0,FORECAST(H33,{0.5,0.75,1},{20,45,90})*H$19)","v":0},null,null,"Bending Radius & Coeff"]
["K bend 01",{"$f":"IF(H24=0,0,FORECAST(H24,{0.5,0.75,1},{20,45,90})*H$19)","v":0.15894039735099338},null,"K bend 06",{"$f":"IF(H29=0,0,FORECAST(H29,{0.5,0.75,1},{20,45,90})*H$19)","v":0},null,"K valve",{"$f":"D27","v":0},null,null,1,0.6]
["K bend 02",{"$f":"IF(H25=0,0,FORECAST(H25,{0.5,0.75,1},{20,45,90})*H$19)","v":0.12556291390728477},null,"K bend 07",{"$f":"IF(H30=0,0,FORECAST(H30,{0.5,0.75,1},{20,45,90})*H$19)","v":0},null,"K exit",{"$f":"IF(UPPER(H22)=\"YES\",1,0)","v":1},null,null,2,0.5]
["K bend 03",{"$f":"IF(H26=0,0,FORECAST(H26,{0.5,0.75,1},{20,45,90})*H$19)","v":0.12973509933774835},null,"K bend 08",{"$f":"IF(H31=0,0,FORECAST(H31,{0.5,0.75,1},{20,45,90})*H$19)","v":0},null,"K others",null,null,null,3,0.4]
["K bend 04",{"$f":"IF(H27=0,0,FORECAST(H27,{0.5,0.75,1},{20,45,90})*H$19)","v":0.15894039735099338},null,"K bend 09",{"$f":"IF(H32=0,0,FORECAST(H32,{0.5,0.75,1},{20,45,90})*H$19)","v":0},null,"K Total",{"$f":"SUM(B50:B54,E50:E54,H50:H53)","v":2.3731788079470197},null,null,5,0.3]
[{"$nulls":10},1.5,0.45]
["Hydraulics"]
["Pipe Area A (m2)",null,null,{"$f":"((D30/1000)^2*22)/28","v":5.3114285714285718E-2},null,null,"U/S Invert Level (mAOD)",{"$f":"H16","v":1950},null,null,"Trashrack Coeff"]
["Hydraulic Radius R (m)",null,null,{"$f":"(D30/1000)/4","v":6.5000000000000002E-2},null,null,"D/S Invert Level (mAOD)",{"$f":"H57-$D$18","v":1943},null,null,"Cross section","k"]
["Velocity V (m/s)",null,null,{"$f":"$D$17/D57","v":3.0123722431414737},null,null,"Is HL tot < HL available",{"$f":"IF(H63<$H$17*$D$18,\"OKAY\",\"Use bigger pipe\")","v":"OKAY"},null,null,"Flat",2.4]
["Pipe Roughness ks (mm)",null,null,0.06,null,null,"Friction Losses hf (m)",{"$f":"(D64*D33*D59^2)/(8*9.81*D58)","v":3.820579223256884},null,null,"Round/Rounded front",1.8]
["Relative Roughness ks/d",null,null,{"$f":"D60/D30","v":2.3076923076923076E-4},null,null,"Fitting Losses hfit (m)",{"$f":"($H$54*D59^2)/(2*9.81)","v":1.0976117131029792},null,null,"Tipped back",1.7]
["Reynolds Number Re = d V /Vk",null,null,{"$f":"(D59*(D30/1000))/0.00000114","v":687032.26597963437},null,null,"Trashracks and intake loss (m)",{"$f":"D46","v":2.1275080400055733E-2},null,null,"Both end rounded",1]
["Type of Flow",null,null,{"$f":"IF(D62<2000,\"Laminar\",IF(D62>4000,\"Turbulent\",\"Transitional\"))","v":"Turbulent"},null,null,"Total Head Loss htot individual (m)",{"$f":"H61+H60+H62","v":4.9394660167599191},null,null,"Tipped section",0.8]
["Friction Factor f",null,null,{"$f":"IF(D63=\"Laminar\",L76,L79)","v":1.5341091155357582E-2},null,null,"% of H.Loss of individual pipe",{"$f":"IF(H63>$H$17*$D$18,ROUND(H63/($D$18)*100,2)&\"% Not Ok\",ROUND(H63/($D$18)*100,2)&\"% Ok\")","v":"70,56% Ok"},null,null,"No Trashrack",0]
["Expansion Joints (mm)",null,null,{"$f":"IF(UPPER(D22)=\"HDPE\",\"\",\"Coeff of linear expansion /deg C\")","v":""},{"$f":"IF(UPPER(D22)=\"STEEL\",12,IF(UPPER(D22)=\"PVC\",54,0))*0.000001","v":0}]
["EJ number",1,2,2,4,5,{"$nulls":4},"K contraction"]
["dL theoretical",{"$f":"$E$65*($A$41-$C$41)*D41*1000","v":0},{"$f":"$E$65*($A$41-$C$41)*E41*1000","v":0},{"$f":"$E$65*($A$41-$C$41)*F41*1000","v":0},{"$f":"$E$65*($A$41-$C$41)*G41*1000","v":0},{"$f":"$E$65*($A$41-$C$41)*H41*1000","v":0},{"$nulls":4},"d l/ d s  ","Kc         "]
["dL recommended",{"$f":"2*B67","v":0},{"$f":"2*C67","v":0},{"$f":"2*D67","v":0},{"$f":"2*E67","v":0},{"$f":"2*F67","v":0},{"$nulls":4},0]
["dL for expansion",{"$f":"2*$E$65*($A$41-$B$41)*D41*1000","v":0},{"$f":"2*$E$65*($A$41-$B$41)*E41*1000","v":0},{"$f":"2*$E$65*($A$41-$B$41)*F41*1000","v":0},{"$f":"2*$E$65*($A$41-$B$41)*G41*1000","v":0},{"$f":"2*$E$65*($A$41-$B$41)*H41*1000","v":0},{"$nulls":4},1,0]
["dL for contraction",{"$f":"B68-B69","v":0},{"$f":"C68-C69","v":0},{"$f":"D68-D69","v":0},{"$f":"E68-E69","v":0},{"$f":"F68-F69","v":0},{"$nulls":4},1.5,0.25]
[{"$nulls":10},2,0.35]
[{"$nulls":10},2.5,0.4]
[{"$nulls":10},5,0.5]
[]
[{"$nulls":10},"Calculation for Friction Factors "]
[{"$nulls":10},"Laminar Flow",{"$f":"(64/D62)","v":9.3154285714285723E-5}]
[{"$nulls":11},{"$f":"-2*LOG(D61/3.7+2.51/D62*L78)","v":8.0736863688648874}]
[{"$nulls":11},{"$f":"L77","v":8.0736863688648874}]
[{"$nulls":10},"Transitional  Flow & Turbulent Flow",{"$f":"1/L78^2","v":1.5341091155357582E-2}]

{"sheet":"SettlingBasinDesign","index":9,"n_rows":109,"n_cols":15,"rows_kept":109,"cut":false,"hidden":false,"merged":[]}
["Settling Basin Design"]
["Small Hydropower Promotion Project (SHPP)/GTZ",{"$nulls":4},"Spreadsheet by Mr Pushpa Chitrakar"]
["Referances: 2,4, 6,9,12,13,15,16",{"$nulls":4},"Date",{"$f":"TODAY()","v":"2012-07-20"}]
["SMALL HYDROPOWER PROMOTION PROJECT/GTZ",{"$nulls":4},"Revision","2006.05"]
["Project:   ",{"$f":"Welcome","v":"Upper Jogmai SHP"},null,null,null,"Location:","Jogmai"]
["Developer","Kankaimai Hydropower P Ltd"]
["Consultant","EPC Consult"]
["Designed","Pushpa Chitrakar"]
["Checked","Pushpa Chitrakar"]
[]
[null,null,null,"Q flood",0,null,null,null,"Sediment swelling factor S =",1.5]
[null,null,null,"Manning's number M (m1/3/s) 1/n=",50,null,null,null,"Volume of sediment storage V (m3) =",{"$f":"(E13+E14)*(E21*3600)*E20/E24*J11","v":15.119999999999997}]
[null,null,null,"Design discharge Qdesign (m3/s)  =",0.42099999999999999,null,null,null,"Sediment depth Hs (m) = V/Asi",{"$f":"J12/E22","v":0.62999999999999989}]
[null,null,null,"Flushing discharge Qflush  (m3/s) =",3.4000000000000002E-2,null,null,null,"Inlet approach conveyance Canal/Pipe =","Canal"]
[null,null,null,"Total discharge Qbasins  (m3/s) =",{"$f":"E13+E14","v":0.45499999999999996},null,null,null,"1/Bottom slope of SB Sf (1:50 to 1:20) =",50]
[null,null,null,"Particles to settle d (mm) =",0.3,null,null,null,"Outlet approach conveyance Canal/Pipe =","Pipe"]
[null,null,null,"Trapping efficiency n (%) =",0.85,null,null,null,"Water level at inlet NWL (m) =",1950]
[null,null,null,"water temperature t (oC) =",15,null,null,null,"h flush below the base slab (L<6m)",1.7]
[null,null,null,{"$f":"\"Fall velocity w at \"&E18&\" deg C (m/s) =\"","v":"Fall velocity w at 15 deg C (m/s) ="},{"$f":"HLOOKUP(E16,{0.1,0.15,0.2,0.25,0.3,0.4,0.5;6,0.015,0.02,0.03,0.035,0.05,0.067;0.007,0.015,0.022,0.031,0.037,0.055,0.071;0.008,0.016,0.025,0.033,0.04,0.06,0.075},IF(E18=10,2,IF(E18=15,3,4)))","v":3.6999999999999998E-2},null,null,null,"Number of basins N",1]
[null,null,null,"Sediment concentration Cmax (kg/m3) =",2,null,null,null,"Spillway crest height above NWL m",0.05]
[null,null,null,"Flushing Frequency FI (hours) =",8,null,null,null,"Spillway discharge coeff",1.6]
[null,null,null,{"$f":"\"Surface area / basin Asi (m2) \"&ROUND(E17*100,2)&\" % =\"","v":"Surface area / basin Asi (m2) 85 % ="},{"$f":"IF(J29=0,CEILING(-(E13+E14)/E19*LN(1-E17),1),J29*E28)","v":24},null,null,null,"Provided Freeboard h fb1 m",0.3]
[null,null,null,"Basin transit velocity Vt (m/s) =",{"$f":"IF(E16>1,0.33,0.44)*SQRT(E16)","v":0.24099792530227307},null,null,null,"Discharge coeff for pipe as orifice (2.76 if L <6 m)",2.76]
[null,null,null,"Bulk Sed density G (kg/m3) =",2600,null,null,null,"Drawdown discharge % of design discharge",1]
[]
[null,null,null,"Discharge per basin Qbasin  (m3/s) =",{"$f":"($E$13+$E$14)/J19","v":0.45499999999999996},null,null,null,"Water depth of inlet canal hc1 (m) =",0.5]
[null,null,null,"Max section width for hydraulic flushing B (m) =",{"$f":"IF(4.83*E26^0.5<E28,\"Use <=\"&ROUND(4.83*E26^0.5,2),4.83*E26^0.5)","v":3.2580131215205377},null,null,null,"Outlet canal width /canal diameter Bc2 (m) =",0.5]
[null,null,null,"Width used B (m) =",2.5,null,null,null,"Water depth of outlet canal hc2 (m) =",0.3]
[null,null,null,"Inlet canal width /canal diameter Bc1 (m) =",1,null,null,null,"Provided Length of the basin Lact (m)=",0]
[]
[null,null,null,{"$f":"\"Length of basin L  (m) \"&IF(4*E28>IF($E$22/E28/J19<J29,J29,$E$22/E28/J19),\"(Idel L = \"&ROUND(IF($E$22/E28/J19<J29,J29,$E$22/E28/J19),2)&\")\",\"\")&\" =\"","v":"Length of basin L  (m) (Idel L = 9,6) ="},{"$f":"MAX(4*E28,IF($E$22/E28/J19<J29,J29,$E$22/E28/J19))","v":10},null,null,null,{"$f":"IF(UPPER(J16)=\"PIPE\",\"Pipe does not need a straight approach!\",\"Straight outlet transition length at 1:2.5 (m) =\")","v":"Pipe does not need a straight approach!"},{"$f":"IF(UPPER($J$16)<>\"PIPE\",5*(E28-J27)/2/2,\"***\")","v":"***"}]
[null,null,null,{"$f":"\"Aspect ratio (\"&IF(LEFT(A1,1)=\"G\",\"1.5<=AR<=2)\", \"4<=AR<=10)\")","v":"Aspect ratio (4<=AR<=10)"},{"$f":"E31/E28","v":4},null,null,null,"Head over outlet weir h overtop (m) =",{"$f":"(E26/1.65/E28)^(2/3)","v":0.2299984782131903}]
[null,null,null,"Min. water depth Hi (m) =",{"$f":"E26/E28/$E$23","v":0.75519322322682003},null,null,null,"Approach inlet velocity vi1 (m/s) =",{"$f":"E26/(J26*E29)","v":0.90999999999999992}]
[null,null,null,"X-sectional area / basin Ai (m2) =",{"$f":"E33*E28","v":1.88798305806705},null,null,null,"Approach outlet velocity vi2 (m/s) =",{"$f":"E26/(J27*J28)","v":3.0333333333333332}]
[null,null,null,"Wetted perimeter / basin Pi (m) =",{"$f":"2*E33+E28","v":4.0103864464536398},null,null,null,"1/Energy gradient during operation So =",{"$f":"1/($E$23/$E$12/E36^(2/3))^2","v":15763.859650475784}]
[null,null,null,"Hydraulic radius Ri (m) =",{"$f":"E34/E35","v":0.47077334897153911},null,null,null,"d 50 during operation (mm) =",{"$f":"11*E36/J35*1000","v":0.32850500787924947}]
[null,null,null,"Normal WL @ basin h b m =",{"$f":"$J$13+E33","v":1.3851932232268198},null,null,null,"Depth of water during flushing  yfi (m) =",{"$f":"YDEPTH(E26,$E$12,$J$15,E28)","v":{"$error":"#NAME?"}}]
[null,null,null,{"$f":"IF(UPPER(J14)=\"PIPE\",\"Pipe does not need a straight approach!\",\"Straight inlet transition length at 1:5 (m) =\")","v":"Straight inlet transition length at 1:5 (m) ="},{"$f":"5*(E28-E29)/2","v":3.75},null,null,null,"d 50f during flushing (mm) =",{"$f":"11*(J37*E28/(2*J37+E28))^(2/3)*1/$J$15*1000","v":{"$error":"#NAME?"}}]
[null,null,null,{"$f":"IF(UPPER(J14)=\"PIPE\",\"Pipe does not need a straight approach!\",\"Straight approach canal length (m) =\")","v":"Straight approach canal length (m) ="},{"$f":"IF(UPPER($J$14)<>\"PIPE\",10*E29,\"***\")","v":10},null,null,null,"Length of an Ideal Basin (m) =",{"$f":"MAX(4*E28,E26/E28/E19)","v":10}]
[]
["Spilling of excess water"]
["Vertical Flushing pipe"]
[null,null,null,"Diameter for flood d1 m =",{"$f":"IF($E$11/J19/(1.9*PI()*(E47-$J$20-0.05)^1.5)>0.5,IF($E$11/2/J19/(1.9*PI()*(E47-$J$20-0.05)^1.5)>0.5,\"Big 2x \"&ROUND($E$11/2/J19/(1.9*PI()*(E47-$J$20-0.05)^1.5),2),\"2 x \"&ROUND($E$11/2/J19/(1.9*PI()*(E47-$J$20-0.05)^1.5),2)),$E$11/J19/(1.9*PI()*(E47-$J$20-0.05)^1.5))","v":0},null,null,null,"Diameter for load rejection (u/s flood bypass)  d1 m =",{"$f":"IF(E26/(1.9*PI()*(E47-$J$20-0.05)^1.5)>0.5,IF(E26/2/(1.9*PI()*(E47-$J$20-0.05)^1.5)>0.5,\"Big 2x \"&ROUND(E26/2/(1.9*PI()*(E47-$J$20-0.05)^1.5),2),\"2 x \"&ROUND(E26/2/(1.9*PI()*(E47-$J$20-0.05)^1.5),2)),E26/(1.9*PI()*(E47-$J$20-0.05)^1.5))","v":"2 x 0,43"}]
[]
[]
["Spillway"]
[null,null,null,"Freeboard m",{"$f":"IF(IF(E26<0.2,0,IF(E26<0.5,0.3,IF(E26<1,0.4,0.5)))>=$J$22,IF(E26<0.2,0,IF(E26<0.5,0.3,IF(E26<1,0.4,0.5))),$J$22)","v":0.3},null,null,null,{"$f":"\"Spillway length for \"&IF($E$11=0,\"Qd\",\"Qf-Qd\")&\" (under operation)\"","v":"Spillway length for Qd (under operation)"},{"$f":"IF(E11=0,0,ABS($E$11/J19-E26)/$J$21/E48^1.5)","v":0}]
[null,null,null,"Spillway overtopping height h overtop m",{"$f":"50%*(E47-$J$20)","v":0.125},null,null,null,"Spillway length for Qd (load rejection & u/s flood bypass)",{"$f":"E26/$J$21/E48^1.5","v":6.4346717087975778}]
[null,null,null,"Spillway length for Qf (flood and non operational)",{"$f":"$E$11/J19/$J$21/E48^1.5","v":0},null,null,null,{"$f":"\"Spillway length for \"&IF($E$11=0,\"Qd\",\"Qf-Qd\")&\" (d/s obstruction & full hovertop-50)\"","v":"Spillway length for Qd (d/s obstruction & full hovertop-50)"},{"$f":"ABS($E$11/J19-E26)/$J$21/(2*E48-0.05)^1.5","v":3.1794091555075119}]
[]
["Combination of vertical flushing pipe and spillway",{"$nulls":7},"Flood and non operational (Qf)"]
[null,null,null,"Vertical flushing pipe diameter d1 m",0.3,null,null,null,"Flood discharge passing through vertical pipe",{"$f":"IF(E11=0,0,E53*E52*1.9*PI()*(E47-$J$20-0.05)^1.5)","v":0}]
[null,null,null,"No of vertical flushing pipe",1,null,null,null,"Spillway length for the remaining discharge m",{"$f":"IF(E54>($E$11/J19-J52)/$J$21/E48^1.5,E54,($E$11/J19-J52)/$J$21/E48^1.5)","v":1}]
[null,null,null,"Spillway length used (m)",1]
[]
[null,null,null,"Flood and Under Operation (Qf- Qd)",{"$nulls":4},"Load Rejection (Qd)"]
[null,null,null,"H overtopping",{"$f":"($E$11/J19/(1.9*PI()*E53*E52+$J$21*J53))^(2/3)","v":0},null,null,null,"H overtopping",{"$f":"(E26/(1.9*PI()*E53*E52+$J$21*J53))^(2/3)","v":0.26210824738385385}]
[null,null,null,"Discharge passing through vertical pipe",{"$f":"1.9*PI()*E52*E57^1.5","v":0},null,null,null,"Discharge passing through vertical pipe",{"$f":"1.9*PI()*E53*E52*J57^1.5","v":0.24029556651673753}]
[null,null,null,"Discharge passing over spillway",{"$f":"$J$21*J53*E57^1.5","v":0},null,null,null,"Discharge passing over spillway",{"$f":"$J$21*J53*J57^1.5","v":0.2147044334832624}]
[]
["Flushing of water and sediment"]
["Flushing pipe and orifice diameter",{"$nulls":6},"Gate ","Relative","Discharge"]
[null,null,null,"d for incoming flow and draw down m",{"$f":"($J$24*4*E26/(PI()*$J$23*SQRT(E37+$J$18)))^0.5","v":0.34568905105115738},null,null,"Opening","Gate Openinig","One basin"]
[null,null,null,"d for incoming flow only (empty state) m",{"$f":"(4*E26/(PI()*$J$23*SQRT($J$18)))^0.5","v":0.40123054366963307},null,null,"Hg","Hg/H1","Q "]
[null,null,null,"d for incoming flow only (empty state & with y flushing) m",{"$f":"(4*E26/(PI()*$J$23*SQRT($J$18+J37)))^0.5","v":{"$error":"#NAME?"}},null,null,5.5511151231257827E-17,{"$f":"H65/$E$75","v":4.0074662726073775E-17},{"$f":"IF($E$75>1.5*H65,(-17.726*I65^5 + 37.373*I65^4 - 29.789*I65^3 + 11.122*I65^2 - 2.23*I65 + 2.2443)*    $E$69*($E$75^1.5-($E$75-H65)^1.5),1.7*$E$69*$E$75^1.5)","v":0}]
[{"$nulls":7},3.3333333333333381E-2,2.4064031482685922E-2,0.12848716328983012]
["Gate",{"$nulls":6},6.6666666666666707E-2,4.8128062965371803E-2,0.25109060870451749]
[null,null,null,"Buoyance weight of the gate W kgf",300,null,null,0.1,7.2192094448057673E-2,0.36934420235991067]
[null,null,null,"Gate Opening B, (m)",1,null,null,0.13333333333333336,9.6256125930743577E-2,0.48433317198682169]
[null,null,null,"Gate Opening H (m)",0.5,null,null,0.16666666666666669,0.12032015741342945,0.59677760296416382]
[null,null,null,"Submerged area of th gate A m2",{"$f":"E69*E70","v":0.5},null,null,0.2,0.14438418889611535,0.70710762847853192]
[null,null,null,"Water surface to cg of submerged area h m",{"$f":"E37-E70/2","v":1.1351932232268198},null,null,0.23333333333333334,0.16844822037880122,0.81553051605877425]
[null,null,null,"Coeff of static friction mu",0.9,null,null,0.26666666666666666,0.1925122518614871,0.92208985754520179]
[null,null,null,"Lifting force F kgf",{"$f":"E68+1000*E73*E71*E72","v":810.83695045206889},null,null,0.3,0.21657628334417298,1.026717074699907]
[null,null,null,"H. of water (H1)",{"$f":"E37","v":1.3851932232268198},null,null,0.33333333333333331,0.24064031482685888,1.1292754581853466]
[{"$nulls":7},0.36666666666666664,0.26470434630954476,1.2295969635773318]
[{"$nulls":7},0.4,0.28876837779223069,1.3275119944873182]
[{"$nulls":7},0.43333333333333329,0.31283240927491651,1.4228724098078227]
[{"$nulls":7},0.46666666666666662,0.33689644075760239,1.5155679996347606]
[{"$nulls":7},0.5,0.36096047224028832,{"$f":"IF($E$75>1.5*H80,(-17.726*I80^5 + 37.373*I80^4 - 29.789*I80^3 + 11.122*I80^2 - 2.23*I80 + 2.2443)*$E$69*($E$75^1.5-($E$75-H80)^1.5),1.7*$E$69*$E$75^1.5)","v":1.6055366826455288}]
[]
[{"$nulls":6},"Forebay cum settling basin (one basin)"]
[{"$nulls":6},"Penstock diameter m",null,null,0.41]
[{"$nulls":6},"Penstock velocity m/s",null,null,{"$f":"E15*4/PI()/J83^2","v":3.4463057278673355}]
[{"$nulls":6},"Submergence depth of penstock pipe m",null,null,{"$f":"1.5*J84^2/2/9.81","v":0.90802929433724799}]
[{"$nulls":6},"Height of pipe above the base slab m",null,null,{"$f":"IF(J83>0.5,J83,0.3)","v":0.3}]
[{"$nulls":6},"Min. pond depth m",null,null,{"$f":"J85+J83+J86","v":1.6180292943372481}]
[{"$nulls":6},"Effective thickness of penstock mm",null,null,3]
[{"$nulls":6},"FS for air vent (5 burried, 10 exposed)",null,null,10]
[{"$nulls":6},"Young's modulus of elasticity E N/mm2",null,null,200000]
[{"$nulls":6},"Penstock inlet gate (Yes/No)",null,null,"No"]
[{"$nulls":6},"Air vent diameter mm",null,null,{"$f":"IF(J91=\"Yes\",SQRT(E15*1000*SQRT(J89/J90*(J83*1000/J88)^3)),\"Nominal\")","v":"Nominal"}]
["Gradual Expansion of 1:5",{"$nulls":5},"half of Gr expansion",{"$nulls":5},"x","y"]
[{"$nulls":7},{"$f":"J27","v":0.5},{"$nulls":4},0,{"$f":"N95+E47","v":1.6851932232268199}]
[{"$f":"E29","v":1},null,null,{"$f":"\"Width \"&ROUND(E28,1)&\"m\"","v":"Width 2,5m"},null,"Flushing cone/spillway O",{"$nulls":6},0,{"$f":"N96+E33","v":1.3851932232268198}]
[{"$nulls":12},0,{"$f":"J13","v":0.62999999999999989}]
["Gradual Expansion 1 in 10 (1:2 for MHP)",null,null,null,{"$f":"\"L =\"&ROUND(E31,2)","v":"L =10"},{"$nulls":7},0,0,0]
[{"$nulls":5},"Spillway",null,{"$f":"J28","v":0.3},{"$nulls":4},{"$f":"E28","v":2.5},{"$f":"N97","v":0}]
[{"$f":"J26","v":0.5},null,null,{"$f":"\"Water depths \"&ROUND(E33,2)&\"m & \"&ROUND(E33+E31/J15,2)&\"m\"","v":"Water depths 0,76m & 0,96m"},{"$nulls":8},{"$f":"M98","v":2.5},{"$f":"N96","v":0.62999999999999989}]
[null,null,{"$f":"\"Sediment depth \"&ROUND(J13,3)&\"m\"","v":"Sediment depth 0,63m"},null,null,{"$f":"\"Slope 1:\"&J15","v":"Slope 1:50"},{"$nulls":6},{"$f":"M99","v":2.5},{"$f":"N95","v":1.3851932232268198}]
[{"$nulls":12},{"$f":"M100","v":2.5},{"$f":"N95+E48","v":1.5101932232268198}]
[{"$nulls":12},{"$f":"M101","v":2.5},{"$f":"N94","v":1.6851932232268199}]
[]
[{"$nulls":12},0,{"$f":"N95","v":1.3851932232268198},{"$f":"N96","v":0.62999999999999989}]
[{"$nulls":12},{"$f":"M102","v":2.5},{"$f":"N104","v":1.3851932232268198},{"$f":"O104","v":0.62999999999999989}]
[{"$nulls":12},{"$f":"\"Av. H ot =\"&ROUND(E48,3)&\"m\"","v":"Av. H ot =0,125m"}]
[{"$nulls":12},{"$f":"M104","v":0},{"$f":"N101","v":1.5101932232268198}]
[{"$nulls":12},{"$f":"M105+0.15","v":2.65},{"$f":"N107","v":1.5101932232268198}]
[{"$nulls":12},{"$f":"M108+0.15","v":2.8},{"$f":"N108-0.15","v":1.3601932232268199}]

{"sheet":"Penstock&Power","index":10,"n_rows":116,"n_cols":13,"rows_kept":116,"cut":false,"hidden":false,"merged":[]}
[null,null,"PENSTOCK AND POWER CALCULATIONS"]
["Small Hydropower Promotion Project (SHPP)/GTZ",{"$nulls":4},"Spreadsheet by Mr Pushpa Chitrakar"]
["Referances:2,4, 5,6,12,13,15,16",{"$nulls":4},"Date",{"$f":"TODAY()","v":"2012-07-20"}]
["SMALL HYDROPOWER PROMOTION PROJECT/GTZ",{"$nulls":4},"Revision","2006.05"]
["Project:   ","Jhankre mini-hydropower",null,null,"Location:"]
["Developer","Himal Power Limited"]
["Consultant","BPC Hydroconsult"]
["Designed","Pushpa Chitrakar"]
["Checked","Pushpa Chitrakar"]
[]
["INPUT"]
["General:"]
["Project:","Jogmai I",{"$nulls":8},"Turbines"]
["Location:","Ilam",{"$nulls":4},"Economic life (years)",10,null,null,"Crossflow"]
["Hydraulics:",{"$nulls":9},"Pelton"]
["Diversion flow Qd (m3/s)",null,null,0.45,null,null,"WL @ forebay or U/S Invert Level (m)",1213.9000000000001]
["Flow in each pipe Qi (m3/s)",null,null,{"$f":"D16/D31","v":0.45},null,null,"% head allowable headloss hlt (m)",0.16,null,null,"Valves & Coeff"]
["Gross head (from forebay) Hg (m)",null,null,180,null,null,"Cumulative knowm efficiency (g,t,tr,others)",0.79379999999999995,null,null,"Spherical",0]
["Power:",{"$nulls":9},"Gate",0.1]
["Turbine type (CROSSFLOW/PELTON)",null,null,"Pelton",null,null,"Valves (Sperical/Gate/Butterfly)",0.3,null,null,"Butterfly",0.3]
[{"$f":"IF(UPPER(D20)=\"PELTON\",\"No of total jets (nj) & % closure\",\"No of CF units\")","v":"No of total jets (nj) & % closure"},null,null,1,0.1,null,"Taper (Yes/No)","No"]
["Direct Coupling (Yes/No)",null,null,"Yes",null,null,"Exit (Yes/No)","No"]
["Closure time T sec",null,null,30,null,null,"Non standard ult. tensile strength (UTS) N/mm2",0,null,null,"Yes"]
["Number of units",null,null,3,{"$nulls":6},"No"]
["Penstock pipe:"]
["Pipe Material (STEEL/HDPE/PVC)",null,null,"Steel",null,null,"Safety factor for lower pipes (0 for default)",null,null,null,"Pipe type"]
["Welded / Flat rolled if steel",null,null,"Welded",null,null,"Entrance Type",0.5,null,null,"Steel"]
["Rolled if steel",null,null,"Rolled",null,null,"Entrance with gate and air-vent (Yes/No)","No",null,null,"HDPE"]
["Type if steel (UNGRAGED/IS)",null,null,"IS",null,null,"Bending radius (r/d) (1/2/3/5/1.5)",0.45,null,null,"PVC"]
["Burried or exposed",null,null,"Exposed",null,null,"Bending angle 05",22]
["No of pipes",null,null,1,null,null,"Bending angle 06",14,null,null,"Steel"]
["Bending angle 01(degrees)",null,null,2,null,null,"Bending angle 07",0,null,null,"Welded"]
["Bending angle 02",null,null,11,null,null,"Bending angle 08",0,null,null,"Flat rolled"]
["Bending angle 03",null,null,4,null,null,"Bending angle 09",0]
["Bending angle 04",null,null,11,null,null,"Bending angle 10",0,null,null,"Steel"]
["Penstock diameter d=>d estd, d act (mm)",null,{"$f":"41*(D17*1000)^0.38","v":417.8348037852362},450,"Pipe thickness t=>t min, t act (mm)",null,{"$f":"IF(UPPER(D26)=\"STEEL\",MAX(3,2.5*MAX(D36:D36)/1000+1.2),\"NA\")","v":3},7,null,null,"Rolled"]
["Pipe Length L (m)",null,550,null,"Roughness coefficient (ks)",null,null,0.06]
["Trashrack",{"$nulls":9},"Steel type"]
["Trashrack coefficient, kt","thickness, t(mm)","Clear spacing, b (mm)","Approach velocity, Vo (m/s)","Angle of inclination, f (deg)","Flow deviation, b (deg)","Design discharge, Q (m3/s)","Submergence depth @ trashrack, h (m)",null,null,"Ungraded"]
[2.4,6,20,1,71.56,0,{"$f":"D16","v":0.45},0.7,null,null,"IS"]
["Expansion Joints"]
["Tmax (deg)","T installation","Tmin","1st Pipe length(m)","2nd Pipe L (m)","3rd Pipe L (m)","4th Pipe L (m)","5th Pipe L (m)",null,null,"Installation"]
[40,20,4,10,15,20,25,30,null,null,"Burried"]
[{"$nulls":10},"Exposed"]
["OUTPUT"]
["Trashrack",{"$nulls":9},"Entrance #"]
["Frictional headloss, hf (m)","Bend loss, hb (m)","Headloss coeff","Total headloss, H(m)","Surface area, S (m2)","trashrack width, B (m)","Submergence @ penstock, h min (m)","Submergence @ penstock, h min (m)",null,null,"Hooded",1]
[{"$f":"A40*(B40/C40)^(4/3)*(D40^2/2/9.81)*SIN(PI()/180*E40)","v":2.3304997931346924E-2},{"$f":"(D40^2/2/9.81)*SIN(PI()/180*F40)","v":0},{"$f":"A40*(B40/C40)^(4/3)*SIN(PI()/180*E40)+SIN(PI()/180*F40)","v":0.45724405941302665},{"$f":"B48+A48","v":2.3304997931346924E-2},{"$f":"1/0.3*(B40+C40)/C40*G40/D40*1/SIN(PI()/180*E40)","v":2.055540892367008},{"$f":"E48/(H40/SIN(PI()*E40/180))","v":2.7857142857142865},{"$f":"D36/1000*(1+2.3*D60/SQRT(9.81*D36/1000))","v":1.8432287441894384},{"$f":"1.5*D60^2/9.81/2","v":0.61155839118956523},null,null,"Inward projecting ",0.8]
[{"$nulls":10},"Sharp cornered ",0.5]
["Turbulent loss coefficients","K Total",{"$f":"SUM(B51:B55,E51:E55,H51:H55)","v":2.0552317880794702},{"$nulls":7},"Slightly rounded ",0.2]
["K inlet",{"$f":"H27","v":0.5},null,"K bend 05",{"$f":"IF(H30=0,0,FORECAST(H30,{0.5,0.75,1},{20,45,90})*H$29)","v":0.24466887417218544},null,"K bend 10",{"$f":"IF(H35=0,0,FORECAST(H35,{0.5,0.75,1},{20,45,90})*H$29)","v":0},null,null,"Bell mouth ",0.04]
["K bend 01",{"$f":"IF(D32=0,0,FORECAST(D32,{0.5,0.75,1},{20,45,90})*H$29)","v":0.1820860927152318},null,"K bend 06",{"$f":"IF(H31=0,0,FORECAST(H31,{0.5,0.75,1},{20,45,90})*H$29)","v":0.21963576158940398},null,"K valve",{"$f":"H20","v":0.3}]
["K bend 02",{"$f":"IF(D33=0,0,FORECAST(D33,{0.5,0.75,1},{20,45,90})*H$29)","v":0.21024834437086093},null,"K bend 07",{"$f":"IF(H32=0,0,FORECAST(H32,{0.5,0.75,1},{20,45,90})*H$29)","v":0},null,"K taper",{"$f":"IF(UPPER(H21)=\"YES\",0.06,0)","v":0},null,null,"Bending Radius & Coeff"]
["K bend 03",{"$f":"IF(D34=0,0,FORECAST(D34,{0.5,0.75,1},{20,45,90})*H$29)","v":0.18834437086092717},null,"K bend 08",{"$f":"IF(H33=0,0,FORECAST(H33,{0.5,0.75,1},{20,45,90})*H$29)","v":0},null,"K exit",{"$f":"IF(UPPER(H22)=\"YES\",1,0)","v":0},null,null,1,0.6]
["K bend 04",{"$f":"IF(D35=0,0,FORECAST(D35,{0.5,0.75,1},{20,45,90})*H$29)","v":0.21024834437086093},null,"K bend 09",{"$f":"IF(H34=0,0,FORECAST(H34,{0.5,0.75,1},{20,45,90})*H$29)","v":0},null,"K others",0,null,null,2,0.5]
[{"$nulls":10},3,0.4]
["Hydraulics",{"$nulls":9},5,0.3]
["Pipe Area A (m2)",null,null,{"$f":"((D36/1000)^2*22)/28","v":0.15910714285714286},null,null,"U/S Invert Level (mAOD)",{"$f":"H16","v":1213.9000000000001},null,null,1.5,0.45]
["Hydraulic Radius R (m)",null,null,{"$f":"(D36/1000)/4","v":0.1125},null,null,"D/S Invert Level (mAOD)",{"$f":"H58-$D$18","v":1033.9000000000001}]
["Velocity V (m/s)",null,null,{"$f":"($D$17)/D58","v":2.8282828282828283},null,null,"Is HLtot < HL available",{"$f":"IF(H64<$H$17*$D$18,\"OKAY\",\"Use bigger pipe\")","v":"OKAY"},null,null,"Trashrack Coeff"]
["Pipe Roughness ks (mm)",null,null,{"$f":"H37","v":0.06},null,null,"Friction Losses hf (m)",{"$f":"(D65*C37*D60^2)/(8*9.81*D59)","v":6.8704588843075332},null,null,"Cross section","k"]
["Relative Roughness ks/d",null,null,{"$f":"H37/D36","v":1.3333333333333334E-4},null,null,"Fitting Losses hfit (m)",{"$f":"($C$50*D60^2)/(2*9.81)","v":0.83792949722635612},null,null,"Flat",2.4]
["Reynolds Number Re = d V /Vk",null,null,{"$f":"(D60*(D36/1000))/0.00000114","v":1116427.4322169058},null,null,"Trashracks and intake loss (m)",{"$f":"D48","v":2.3304997931346924E-2},null,null,"Round/Rounded front",1.8]
["Type of Flow",null,null,{"$f":"IF(D63<2000,\"Laminar\",IF(D63>4000,\"Turbulent\",\"Transitional\"))","v":"Turbulent"},null,null,"Total Head Loss htot individual (m)",{"$f":"H62+H61+H63","v":7.731693379465236},null,null,"Tipped back",1.7]
["Friction Factor f",null,null,{"$f":"IF(D64=\"Laminar\",L113,L116)","v":1.3787607093670953E-2},null,null,"% of H.Loss of individual pipe",{"$f":"IF(H64>$H$17*$D$18,ROUND(H64/($D$18)*100,2)&\"% Not Ok\",ROUND(H64/($D$18)*100,2)&\"% Ok\")","v":"4,3% Ok"},null,null,"Both end rounded",1]
["Factor of Safety",{"$nulls":9},"Tipped section",0.8]
["Young's modulus of elasticity E N/mm2",null,null,{"$f":"IF(UPPER(D26)=\"STEEL\",200000,IF(UPPER(D26)=\"PVC\",2750,IF(UPPER(D26)=\"HDPE\",2150)))","v":200000},null,null,"Ultimate tensile strength (UTS) N/mm2",{"$f":"IF(AND(H23>0,UPPER(D26)=\"STEEL\"),H23,IF(AND(UPPER(D26)=\"STEEL\",UPPER(D29)=\"IS\"),410,IF(AND(UPPER(D26)=\"STEEL\",UPPER(D29)=\"UNGRADED\"),320,IF(UPPER(D26)=\"PVC\",45,IF(UPPER(D26)=\"HDPE\",27,\"Pipe material?\")))))","v":410},null,null,"No trashrack",0]
["Thickness",null,null,{"$f":"H36","v":7},null,null,{"$f":"\"H total for \"&IF(UPPER(D20)=\"PELTON\",ROUND(E21*100,2)&\"% closure of one jet\", \"unit Crossflow\")&\"(m)\"","v":"H total for 10% closure of one jet(m)"},{"$f":"D73+$D$18","v":211.92532635135208},null,null,"K contraction"]
["Diameter (mm)",null,null,{"$f":"D36","v":450},null,null,"t effective (mm)",{"$f":"IF(AND(UPPER($D$26)=\"STEEL\",UPPER($D$27)=\"WELDED\",UPPER($D$28)=\"ROLLED\"),H36/1.32-$H$14/10,IF(AND(UPPER($D$26)=\"STEEL\",UPPER($D$27)=\"WELDED\"),H36/1.1-$H$14/10,IF(UPPER($D$26)=\"STEEL\",H36/1.2-$H$14/10,H36)))","v":4.3030303030303028},null,null,"d l/ d s  ","Kc         "]
["Net Head (m)",null,null,{"$f":"$D$18-H64","v":172.26830662053476},null,null,"Minimum t effictive for negative pressure (mm)",{"$f":"IF(UPPER($D$30)=\"BURRIED\",D36*(2*0.1/2/$D$67)^0.33,D36*(4*0.1/2/$D$67)^0.33)","v":4.7120784662290491},null,null,0]
["Wave Velocity a (m/s)",null,null,{"$f":"1440/(SQRT(1+(2150*D36/$D$67/H36)))","v":1107.341346398915},null,null,"Comment on thickness",{"$f":"IF(UPPER($H$28)<>\"No\",IF(H70>H69,\"low by \"&ROUND(H70-H69,1),\"Ok\"),\"NA, No gate\")","v":"NA, No gate"},null,null,1,0]
["Critical time Tc (sec) *2 = Closing time T",null,null,{"$f":"IF(2*2*$C$37/D71<=$D$23,ROUND(2*$C$37/D71,2)&\" Ok\",ROUND(2*$C$37/D71,2)&\" Not Ok\")","v":"0,99 Ok"},null,null,"Safety Factor (S)",{"$f":"200*H69*$H$67/H68/D36","v":3.6999246744476766},null,null,1.5,0.25]
[{"$f":"IF(UPPER(D20)=\"PELTON\",\"Hsurge for \"&ROUND(E21*100,2)&\"% closure of one jet\",\"K if crossflow turbine Kcf\")","v":"Hsurge for 10% closure of one jet"},null,null,{"$f":"IF(UPPER($D$20)=\"PELTON\",D71*D60/(9.81*$D$21)*E21,($C$37*D60/9.81/$D$18/$D$23)^2)","v":31.925326351352073},null,null,"Check on Safety Factor",{"$f":"IF(H26=0,IF(OR(AND(UPPER($D$26)=\"HDPE\",H72>=1.5),AND(UPPER($D$26)=\"STEEL\",H72>=3.5)),\"Ok\",\"Not Ok\"),IF(H72>=H26,\"Ok\",\"Not Ok\"))","v":"Ok"},null,null,2,0.35]
[{"$f":"\"Hsurge for one \"&IF(UPPER(D20)=\"PELTON\",\"jet closure of Pelton\", \"unit Crossflow\")&\"(m)\"","v":"Hsurge for one jet closure of Pelton(m)"},null,null,{"$f":"IF(UPPER($D$20)=\"PELTON\",D71*D60/(9.81*$D$21),(D73/2+SQRT(D73+D73^2/4))*$D$18/$D$21)","v":319.25326351352072},null,null,"Air vent diameter d vent (mm)",{"$f":"IF(H71=\"NA, Gate is used\",\"Provide moninal\",SQRT($D$17*1000*SQRT(10/$D$67*(D36/H69)^3)))","v":58.33474985681984},null,null,2.5,0.4]
[{"$f":"\"Hsurge for instanteneous closure of all unit closure of \"&$D$20&\" (m)\"","v":"Hsurge for instanteneous closure of all unit closure of Pelton (m)"},null,null,{"$f":"D71*D60/9.81","v":319.25326351352072},null,null,"H total capacity of the specified pipe (m)",{"$f":"ROUND(IF($H$26>0,1/$H$26,IF(UPPER($D$26)=\"STEEL\",1/3.5,1/1.5))*200*H69*$H$67/D36,2)","v":224.03},null,null,5,0.5]
[{"$f":"\"Lengths (max & actual) of the specified pipe (m) & \"&IF(D76<C37,\"Not Ok\",\"Ok\")","v":"Lengths (max & actual) of the specified pipe (m) & Ok"},null,{"$f":"H75/H68*C37","v":581.41469979722353},{"$f":"IF(C76>C37,C37,C76)","v":550},null,null,"H static capacity of the specified pipe (m)",{"$f":"IF(H75-D73>0,H75-D73,0)","v":192.10467364864792}]
[{"$nulls":10},"Extra pressures to be considered"]
["Power",{"$nulls":9},"Static only",1]
["Turbine efficiency as per MGSP",null,null,{"$f":"IF(UPPER(D20)=\"PELTON\",0.75,0.65)","v":0.75},null,null,"Electrical Power as per MGSP GL (kW)",{"$f":"D16*9.81*D18*0.5","v":397.30500000000001},null,null,"H surge of instant one jet closure",2]
["Available shaft power(kW)",null,null,{"$f":"D16*9.81*(D18-H64)*D79*IF(UPPER(D22)=\"NO\",0.95,1)","v":570.35882968226304},null,null,"Electrical Power based on Hnet (kW)",{"$f":"D16*9.81*(D18-H64)*IF(UPPER(D20)=\"PELTON\",0.6,0.5)","v":456.28706374581043},null,null,"H surge of instant one fourth jet closure",3]
["Reqd.'Turbine Capacity (+10%) (kW)",null,null,{"$f":"D80*1.1","v":627.3947126504894},null,null,"Power for known cumulative eff (kW)",{"$f":"D16*9.81*(D18-H64)*H18","v":603.66778533570721},null,null,"50% of test pressure",4]
[]
["Expansion Joints (mm)",null,null,{"$f":"IF(UPPER(D26)=\"HDPE\",\"\",\"Coeff of linear expansion /deg C\")","v":"Coeff of linear expansion /deg C"},{"$f":"IF(UPPER(D26)=\"STEEL\",12,IF(UPPER(D26)=\"PVC\",54,0))*0.000001","v":1.2E-5},{"$nulls":5},{"$f":"CHOOSE(C25,K78,K79,K80,K81)","v":{"$error":"#VALUE!"}}]
["EJ number",1,2,2,4,5]
["dL theoretical",{"$f":"$E$83*($A$43-$C$43)*D43*1000","v":4.32},{"$f":"$E$83*($A$43-$C$43)*E43*1000","v":6.4799999999999995},{"$f":"$E$83*($A$43-$C$43)*F43*1000","v":8.64},{"$f":"$E$83*($A$43-$C$43)*G43*1000","v":10.799999999999999},{"$f":"$E$83*($A$43-$C$43)*H43*1000","v":12.959999999999999},{"$nulls":4},"Need of Surge Shaft if L/H=> exceeds","L/H"]
["dL recommended",{"$f":"2*B85","v":8.64},{"$f":"2*C85","v":12.959999999999999},{"$f":"2*D85","v":17.28},{"$f":"2*E85","v":21.599999999999998},{"$f":"2*F85","v":25.919999999999998},{"$nulls":4},"Small Hydropower Project",6]
["dL for expansion",{"$f":"2*$E$83*($A$43-$B$43)*D43*1000","v":4.8000000000000007},{"$f":"2*$E$83*($A$43-$B$43)*E43*1000","v":7.2},{"$f":"2*$E$83*($A$43-$B$43)*F43*1000","v":9.6000000000000014},{"$f":"2*$E$83*($A$43-$B$43)*G43*1000","v":12},{"$f":"2*$E$83*($A$43-$B$43)*H43*1000","v":14.4},{"$nulls":4},"Large Hydropower Project",4]
["dL for contraction",{"$f":"B86-B87","v":3.84},{"$f":"C86-C87","v":5.7599999999999989},{"$f":"D86-D87","v":7.68},{"$f":"E86-E87","v":9.5999999999999979},{"$f":"F86-F87","v":11.519999999999998}]
[{"$nulls":10},"Stability of Surge System if"]
[{"$nulls":10},"hc = hloss u/s of surge shaft =< Hn /2"]
[{"$nulls":10},"As = n1 * Ath = free surface area of shaft"]
[{"$nulls":10},"n1 = 1.5 to 2.0"]
[{"$nulls":10},"Ath = v^2/2/g*A*L/Hc/hc = Shaft surface area after Thoma"]
[{"$nulls":10},"A = area of penstock u/s of surge shaft"]
[{"$nulls":10},"L = lenth of penstock u/s of surge shaft"]
[{"$nulls":10},"Hc = hr-8*hc/3+2Y+2 = height of surge chamber from the top of u/s penstock"]
[{"$nulls":10},"Y = +/-v*sqrt(L*A/g/As) = Max occilation"]
[{"$nulls":10},"hr = max depletion of reservoir"]
[{"$nulls":10},"Wave velocity"]
[{"$nulls":10},"a=sqrt(K/(r*(1+(K/E)y)))"]
[{"$nulls":10},"Material","M of Elasticity (Gpa)","Poisson Ratio"]
[{"$nulls":10},"Cast iron","70-160",0.25]
[{"$nulls":10},"Concrete","15-30",".1-.15"]
[{"$nulls":10},"Mild Steel","200-210",0.27]
[{"$nulls":10},"PVC Rigid","2.4-2.7",0.4]
[]
[{"$nulls":10},"r = 999 at 20 degrees"]
[{"$nulls":10},"y rigid/anchored against longitudinal movement = d/t*(1-u^2)"]
[{"$nulls":10},"y upper end anchored against longitudinal movement = d/t*(1.25-u)"]
[{"$nulls":10},"y free/expansion joint for longitudinal movement = d/t"]
[]
[{"$nulls":10},"Calculation for Friction Factors "]
[{"$nulls":10},"Laminar Flow",{"$f":"(64/D63)","v":5.7325714285714293E-5}]
[{"$nulls":11},{"$f":"-2*LOG(D62/3.7+2.51/D63*L115)","v":8.5163901819267736}]
[{"$nulls":11},{"$f":"L114","v":8.5163901819267736}]
[{"$nulls":10},"Transitional  Flow & Turbulent Flow",{"$f":"1/L115^2","v":1.3787607093670953E-2}]

{"sheet":"AnchorLoads","index":11,"n_rows":149,"n_cols":16,"rows_kept":149,"cut":false,"hidden":false,"merged":[[2,8,2,9],[112,4,112,5],[112,6,112,7]]}
["Forces on Anchor Block",{"$nulls":4},"Block # & type",2,"Convex"]
["Small Hydropower Promotion Project (SHPP)/GTZ",null,"Spreadsheet by Mr Pushpa Chitrakar"]
["Referances: 6,12,13,15,16",{"$nulls":6},"Date",{"$f":"TODAY()","v":"2012-07-20"}]
["SMALL HYDROPOWER PROMOTION PROJECT/GTZ",{"$nulls":6},"Revision","2006.05"]
["Project",null,{"$f":"Project","v":"Golmagad SHP"}]
["Developer",null,"Kankaimai Hydropower P Ltd",{"$nulls":4},"Designed","Pushpa Chitrakar"]
["Consultant",null,"EPC Consult",{"$nulls":4},"Checked","Pushpa Chitrakar"]
[]
["Input",{"$nulls":13},{"$f":"IF(OR(UPPER(C24)=\"YES\",UPPER(C24)=\"NO\"),\"\",\"yes/no only\")","v":""}]
["Particulars",null,"Upstream","Central","Downstream",null,"Design Discharge, Q (m3/s)",null,0.37]
["Pipe dimensions",{"$nulls":5},"Unit Weights (kN/m3)"]
[null,"Diameter (Di)",0.39,null,{"$f":"C12","v":0.39},null,"Mild Steel",null,78.5]
[null,"Thickness ",6.0000000000000001E-3,null,{"$f":"C13","v":6.0000000000000001E-3},null,"Water",null,9.81]
[null,"Shaddle Spacing & number",4,7,{"$f":"C14","v":4},null,"RCC",null,25]
[{"$nulls":6},"Anchor Block",null,22]
["Elevations",null,null,818,null,null,"Soil"]
[{"$nulls":6},"Bearing capacity (kN/m2)",null,200,{"$nulls":5},"Friction Factors:"]
["Horizontal Distance (m)",null,2,null,53.712000000000003,null,"f",null,30,{"$f":"I18*PI()/180","v":0.52359877559829882},{"$nulls":4},"Steel to Concrete (m)",0.6]
[{"$nulls":6},"gs",null,20,{"$nulls":5},"Steel to Bitumen Sheet (m)",0.5]
["Vertical angles, a & b (deg)",null,0,null,27.783200000000001,{"$nulls":9},"Steel to Steel (rusty) (m)",0.5]
[{"$nulls":14},"Steel to (HDPVC) to Steel (greased) (m)",0.25]
["Location of Expansion Joint",null,2,null,2,null,"Heads (m)",{"$nulls":7},"Steel to Steel (Rollar) (m)",0.1]
[{"$nulls":6},"Forebay WL",null,835,{"$nulls":5},"Concrete to Colluvium (m)"]
["D/S Expansion Joint :",null,"Yes",null,"Yes",null,"Tot.Transient Length (m)",null,511,{"$nulls":5},"Sandy (m)",0.4]
[{"$nulls":6},"Tpot Pipe Len (forebay to AB)",null,56.387999999999998,{"$nulls":5},"Gravel Mix (m)",0.5]
["Output",{"$nulls":5},"Total Surge Head",null,96.36,{"$nulls":5},"Boulder Mix (m)",0.6]
["Weight of pipe, Wp (kN/m)",null,{"$f":"PI()*(C12+C13)*C13*$I$12","v":0.58595729537695396},null,{"$f":"PI()*(E12+E13)*E13*$I$12","v":0.58595729537695396},null,"Static Head",null,{"$f":"I23-D16","v":17},{"$nulls":5},"Rubber Packing in Expansion Joint (m)",{"$f":"0.5*0.5","v":0.25}]
["Weight of water, Ww (kN/m)",null,{"$f":"PI()*(C12)^2/4*$I$13","v":1.1718933850034963},null,{"$f":"PI()*(E12)^2/4*$I$13","v":1.1718933850034963},null,"Surge Head ±",null,{"$f":"I26/I24*I25","v":10.633165714285713}]
["Total weight, W (kN/m))",null,{"$f":"SUM(C27:C28)","v":1.7578506803804501},null,{"$f":"SUM(E27:E28)","v":1.7578506803804501},null,null,"Total (H)",{"$f":"SUM(I27:I28)","v":27.633165714285713}]
["Velocity, v (m/s)",null,{"$f":"I10/(PI()*(C12)^2/4)","v":3.0972954079685087},null,{"$f":"I10/(PI()*(E12)^2/4)","v":3.0972954079685087},null,"Youngs Modulus of Elasticity (E)",null,210000000000]
["Vertical angles, a & b (rad)",null,{"$f":"IF(C16<>\"\",ATAN((C16-D16)/C18),C20*PI()/180)","v":0},null,{"$f":"IF(E16<>\"\",ATAN((D16-E16)/E18),E20*PI()/180)","v":0.48490831674008855},null,"Coefficient of Linear Expansion (a)",null,1.2E-5]
[]
["GENERAL FORCES"]
["1.","Perpendicular component of Wt of pipe and water act perpendicular to the pipe CL along the anchor faces"]
[]
[]
[]
[]
[]
[]
[null,"F1=dead weight of half of anchor saddle pipe perp to pipe"]
[null,null,{"$f":"C29*C14/2","v":3.5157013607609002},null,{"$f":"E29*E14/2","v":3.5157013607609002},{"$nulls":9},"Cos","Sin"]
[null,"F1u (kN)=wu*lmu/2*COS(a): ","F1d (kN)=wd*lmd/2*COS(b)",{"$nulls":10},1,{"$f":"COS(N43)","v":0.54030230586813977},{"$f":"SIN(N43)","v":0.8414709848078965}]
[null,"F1 perpendicular to pipe",{"$f":"C29*C14/2*COS(C31)","v":3.5157013607609002},null,{"$f":"E29*E14/2*COS(E31)","v":3.11040318272843},{"$nulls":8},-1,{"$f":"COS(N44)","v":0.54030230586813977},{"$f":"SIN(N44)","v":-0.8414709848078965}]
[null,"F1 axial",{"$f":"-C29*C14/2*SIN(C31)","v":0},null,{"$f":"-E29*E14/2*SIN(E31)","v":-1.6387641986963521}]
[null,"Fixed end moment = wl^2/8 for proped cantilever FEM."]
[null,"FEMu (kN-m)= Restoring moment:",null,"FEMd (kN-m)= Overturning moment"]
[null,"FEM",{"$f":"C29*C14^2/12","v":2.3438009071739336},null,{"$f":"-E29*(E14^2)/12","v":-2.3438009071739336}]
[]
["2.","Axial frictional force of pipe on saddle supports transferred to anchor "]
[null,"F2 (kN)= ±m*w*L'*cos a ",{"$nulls":5},0.25]
[null,"US Pipe Length, L' (m):",{"$f":"IF(C16=\"\",C18/COS(C31),SQRT(C18^2+(C16-D16)^2))","v":2}]
[null,"F2 (kN) = ±",{"$f":"IF(D14>0,D14*C29*C14*$H$51*COS(C31),C29*(C52-C22-C14/2)*$H$51*COS(C31))*IF(UPPER(C24)=\"YES\",1,0)","v":12.304954762663151},"+ve for expansion"]
[]
["3.","Hydrostatic Pressure at Bend due to the vector difference of static pressure & acting towards IP"]
[null,"Pu (kN) = F3u =PI/4*dui^2*Ht*g",{"$f":"PI()*(C12)^2/4*I29*I13","v":32.383124107276842}]
[null,"Pd (kN) = F3d =PI/4*ddi^2*Ht*g",null,null,{"$f":"PI()*(E12)^2/4*I29*I13","v":32.383124107276842}]
[null,"F3 = 2*P*sin((b-a)/2)",null,{"$f":"2*C56*SIN((E31-C31)/2)","v":15.549451685771606}]
[]
[]
["4.","Component of weight of pipe (wp) along the pipe"]
[null,"F4u= wp*active arm L’*sin(a) ","F4d= wp*active arm L’*sin(b) "]
[null,"F4",{"$f":"C27*SIN(C31)*(C52-C22)","v":0},null,{"$f":"E27*SIN(E31)*IF(UPPER(E24)=\"YES\",E22,IF(E16=\"\",E18/COS(E31),SQRT((D16-E16)^2+E18^2)))","v":0.54626132261749927}]
[]
[]
["5.","Thermally (expansion/contraction) induced axial force ( if no EJ provided)"]
[null,"F5 (kN)=pi()*Dmean*t*E*a*Dt","+ Expansion, - Contraction"]
[null,"Condition","Tmax","Tinstallation","Tmin"]
[null,"Temp at oC",40,20,4]
[null,"F5 expansion",{"$f":"PI()*(C12+C13)*C13*I30*I31*(C69-D69)/1000*IF(UPPER(C24)=\"YES\",0,1)","v":0},null,{"$f":"PI()*(C12+C13)*C13*I30*I31*(C69-D69)/1000*IF(UPPER(E24)=\"YES\",0,1)","v":0}]
[null,"F5 contraction",{"$f":"PI()*(E12-E13)*E13*I30*I31*(D69-E69)/1000*IF(UPPER(C24)=\"YES\",0,1)","v":0},null,{"$f":"PI()*(E12-E13)*E13*I30*I31*(D69-E69)/1000*IF(UPPER(E24)=\"YES\",0,1)","v":0}]
[]
["6.","Axial friction within Expansion joint seal due to the movement against the circumferential pressure"]
[null,"F6=±PI()*D*W*H*g*m","+ Expansion, - Contraction"]
[null,"m for rubber packing",{"$f":"0.5*0.5","v":0.25},"Seal width, W (m)",{"$f":"8*2/100","v":0.16}]
[null,"Static Pressure at Exp, Ps (m)",{"$f":"IF(C16=\"\",I27-C52*SIN(C31),(I23-C16+(C16-D16)/C18*C22/COS(C31)))","v":17},null,{"$f":"IF(C16=\"\",I27+E22*SIN(E31),(I23-(D16-(D16-E16)/E18*E22/COS(E31))))","v":17.932254495212117}]
[null,"Dynamic Pressure at Exp, Pd (m)",{"$f":"I26/I24*(I25-C18/COS(C31))","v":10.256022857142856},null,{"$f":"I26/I24*(I25+E22/COS(E31))","v":11.059451818743497}]
[null,"Total (AH)",{"$f":"SUM(C76:C77)","v":27.256022857142856},null,{"$f":"SUM(E76:E77)","v":28.991706313955614}]
[null,"F6 (kN)      = ±",{"$f":"PI()*(C12+2*C13)*E75*C78*I13*C75*IF(UPPER(C24)=\"YES\",1,0)","v":13.507264653140306},null,{"$f":"PI()*E12*E75*E78*I13*C75*IF(UPPER(E24)=\"YES\",1,0)","v":13.938539015092788}]
[]
["7.","Axial hydrostatic pressure on exposed end of pipe in Expansion Joint"]
[null,"F7=PI*D*t*H*g"]
[null,"F7",{"$f":"PI()*(C12+C13)*C13*C78*I13*IF(UPPER(C24)=\"YES\",1,0)","v":1.9958495532252092},null,{"$f":"PI()*(E12-E13)*E13*E78*I13*IF(UPPER(E24)=\"YES\",1,0)","v":2.0586149929983195}]
[]
["8.","Dynamic pressure at the bend due to the vector difference of momentum"]
[null,"F8 = 2.5*(Q^2/d^2)*sin((b-a)/2)",null,"P8= mV =Q*r*Vi "]
[null,"P8 (kN)",{"$f":"I10*I13/9.81*C30","v":1.1459993009483482},null,{"$f":"I10*I13/9.81*E30","v":1.1459993009483482}]
[null,"F8",null,{"$f":"2.5*(I10^2/C12^2)*SIN((E31-C31)/2)","v":0.54023234403265041}]
[]
["9.","Axial (small diameter) force on Reducer "]
[null,"F9=PI()*(Dupi^2-Ddni^2)/4*g*H"]
[null,"Reducer:","No",null,"No"]
[null,"Location & Diameter:",3,0.4,4,0.4]
[null,"St. Head",{"$f":"I23-(D16+C93*SIN(C31))","v":17},null,{"$f":"I23-(D16-E93*SIN(E31))","v":18.86450899042427}]
[null,"Dyn. Head",{"$f":"I26/I24*(I25-C93*SIN(C31))","v":10.633165714285713},null,{"$f":"I26/I24*(I25+E93*SIN(E31))","v":10.984758838194283}]
[null,"F9 (kN)",{"$f":"PI()*((C12)^2-(D93)^2)/4*I13*(C94+C95)*IF(UPPER(C92)=\"YES\",1,0)","v":0},null,{"$f":"PI()*((E12)^2-(F93)^2)/4*I13*(E94+E95)*IF(UPPER(E92)=\"YES\",1,0)","v":0}]
[]
[10,"Axial drag of flowing Water (friction of flowing water) (not considered in MHP)"]
[null,"F10=g*PI()*Dupi^2/4*DH(Exp to block)"]
[null,"F10 (kN)",{"$f":"IF(C16=\"\",I27-C52*SIN(C31),(C16-D16)/C18*(C18-C22))*(I13*PI()*(C12)^2/4)*IF(D100=\"No\",0,1)","v":0},"No",{"$f":"IF(C16=\"\",I27+E22*SIN(E31),(D16-E16)/E18*E22)*(I13*PI()*(E12-E13*2)^2/4)*IF(F100=\"No\",0,1)","v":0},"No"]
[]
[11,"Axial (u/s slope) force due to soil pressure upstream of the block "]
[null,"F11 =gs*hs^2/2*cos f*ka*B"]
[null,"ka= (cosi-sqrt(cosi^2-cosf^2))/(cosi+sqrt(cosi^2-cosf^2))",null,{"$f":"(COS(C31)-SQRT(COS(C31)^2-COS(J18)^2))/(COS(C31)+SQRT(COS(C31)^2-COS(J18)^2))","v":0.33333333333333343},null,"Width, B(m)",2]
[null,"hs = soil depth = hu",1.8]
[null,"F11 ",{"$f":"(I19*C105^2/2*COS(C31)*D104*G104)*IF(D106=\"No\",0,1)","v":21.600000000000009},"Yes","@ 1/3 of hs",{"$f":"C105/3","v":0.6}]
[]
[12,"Vertical force due to the weight of the block "]
[null,"F12 =gblock*Vol of block"]
[null,"Vol of block",16.190999999999999]
[null,"F12",null,{"$f":"I15*C110*IF(E111=\"No\",0,1)","v":356.202},"Yes"]
[]
["SUMMARY OF CRITICAL FORCES",null,null,null,"Expansion",null,"Contraction"]
[{"$nulls":4},"@ bend","Total","@ bend","Total"]
[1,"Summation of total horizontal forces SH (kN)",null,null,{"$f":"C145","v":16.551450688686465},{"$f":"C144","v":38.151450688686474},{"$f":"C149","v":-10.409644094980131},{"$f":"C148","v":11.190355905019878}]
[2,"Summation of total vertical forces SV (kN)",null,null,{"$f":"D145","v":-16.553639974625924},{"$f":"D144","v":339.64836002537407},{"$f":"D149","v":-3.559374321116195},{"$f":"D148","v":352.6426256788838}]
[3,"Summation of total moment forces SM (kN-m)",null,null,{"$f":"C48+E48","v":0},null,{"$f":"E117","v":0}]
[]
[null,"Expansion"]
[null,null,"H","V"]
[null,"F1",{"$f":"-C44*SIN(C31)","v":0},{"$f":"C44*COS(C31)","v":3.5157013607609002}]
[null,null,{"$f":"-E44*SIN(E31)","v":-1.4498436745103267},{"$f":"E44*COS(E31)","v":2.7518287153472216}]
[null,"F2",{"$f":"C53*COS(C31)","v":12.304954762663151},{"$f":"C53*SIN(C31)","v":0}]
[]
[null,"F3",{"$f":"D58*SIN((E31+C31)/2)","v":3.7332013879694457},{"$f":"-D58*COS((E31+C31)/2)","v":-15.094656509010347}]
[]
[null,"F4",{"$f":"C63*COS(C31)","v":0},{"$f":"C63*SIN(C31)","v":0}]
[null,null,{"$f":"E63*COS(E31)","v":0.48328705487748774},{"$f":"E63*SIN(E31)","v":0.25462728678533997}]
[null,"F5",{"$f":"C70*COS(C31)","v":0},{"$f":"C70*SIN(C31)","v":0}]
[null,null,{"$f":"-E70*COS(E31)","v":0},{"$f":"-E70*SIN(E31)","v":0}]
[null,"F6",{"$f":"C79*COS(C31)","v":13.507264653140306},{"$f":"C79*SIN(C31)","v":0}]
[null,null,{"$f":"-E79*COS(E31)","v":-12.331672023970157},{"$f":"-E79*SIN(E31)","v":-6.4971328267548598}]
[null,"F7",{"$f":"C83*COS(C31)","v":1.9958495532252092},{"$f":"C83*SIN(C31)","v":0}]
[null,null,{"$f":"-E83*COS(E31)","v":-1.8212930989248233},{"$f":"-E83*SIN(E31)","v":-0.95957654056687158}]
[null,"F8",{"$f":"D88*SIN((E31+C31)/2)","v":0.12970207421616867},{"$f":"-D88*COS((E31+C31)/2)","v":-0.52443146118728934}]
[]
[null,"F9",{"$f":"C96*COS($C$31)","v":0},{"$f":"C96*SIN($C$31)","v":0}]
[null,null,{"$f":"-E96*COS($E$31)","v":0},{"$f":"-E96*SIN($E$31)","v":0}]
[null,"F10",{"$f":"C100*COS($C$31)","v":0},{"$f":"C100*SIN($C$31)","v":0}]
[null,null,{"$f":"-E100*COS($E$31)","v":0},{"$f":"-E100*SIN($E$31)","v":0}]
[null,"F11",{"$f":"C106*COS($C$31)","v":21.600000000000009},{"$f":"C106*SIN($C$31)","v":0}]
[]
[null,"F12",null,{"$f":"D111","v":356.202}]
[null,"Total",{"$f":"SUM(C121:C143)","v":38.151450688686474},{"$f":"SUM(D121:D143)","v":339.64836002537407}]
[null,"Bend",{"$f":"C144-$C$141","v":16.551450688686465},{"$f":"D144-$D$141-$D$143","v":-16.553639974625924}]
[]
[null,"Contraction"]
[null,"Total",{"$f":"C144-2*(C123+C131+C132)","v":11.190355905019878},{"$f":"D144-2*(D123+D131+D132)","v":352.6426256788838}]
[null,"Bend",{"$f":"C148-$C$141","v":-10.409644094980131},{"$f":"D148-$D$141-$D$143","v":-3.559374321116195}]

{"sheet":"AnchorBlock","index":12,"n_rows":43,"n_cols":14,"rows_kept":43,"cut":false,"hidden":false,"merged":[[2,6,2,7]]}
["Anchor Block Stability"]
["Small Hydropower Promotion Project (SHPP)/GTZ",null,"Spreadsheet by Mr Pushpa Chitrakar"]
["Referances: 6,12,13,15,16",null,null,null,"Date",null,{"$f":"TODAY()","v":"2012-07-20"}]
["SMALL HYDROPOWER PROMOTION PROJECT/GTZ",null,null,null,"Revision",null,"2006.05"]
["Project",null,{"$f":"Project","v":"Golmagad SHP"}]
["Developer",null,"Mansarawar Hydropower P Ltd"]
["Consultant",null,"EHS"]
["Designed",null,"Pushpa Chitrakar"]
["Checked",null,"Pushpa Chitrakar"]
[]
["Input",null,null,"Output"]
["Anchor",{"$nulls":10},"X","Y"]
[null,"Upstream depth, Hu (m)",3.3,null,"Concrete volume of Anchor Block",{"$f":"((C14*C16)+(0.5*C16*(C13-C14)))*C15-C21*PI()*C23^2/4*COS(C24*PI()/180)-(C16-C21)*PI()*C23^2/4*COS(C25*PI()/180)","v":16.190848964386255},{"$nulls":5},0,{"$f":"C13","v":3.3}]
[null,"Downstream depth, Hd (m)",2.25,null,"Weight of block, Wb (kN)",{"$f":"F13*C17","v":356.19867721649763},{"$nulls":5},{"$f":"L13","v":0},0]
[null,"Width, W (m)",2,null,"Centre of gravity XX",{"$f":"((C16*C14)*C16/2+(0.5*C16*(C13-C14)*C16/3))/((C16*C14)+(0.5*C16*(C13-C14)))","v":1.4054054054054055},{"$nulls":5},{"$f":"C16","v":3},{"$f":"M14","v":0}]
[null,"Length, L (m)",3,{"$nulls":8},{"$f":"L15","v":3},{"$f":"C14","v":2.25}]
[null,"g anchor (kN/m3)",22,{"$nulls":8},{"$f":"L14","v":0},{"$f":"M13","v":3.3}]
[null,"m",0.5]
[]
["Penstock",{"$nulls":10},"Pipe CL"]
[null,"Bend at (X), (m)",1,{"$nulls":8},{"$f":"L13-0.5","v":-0.5},{"$f":"M22+(ABS(L21)+L22)*TAN(PI()/180*C24)","v":2.4963022866883446}]
[null,"Bend at (Y), (m)",2.15,{"$nulls":8},{"$f":"C21","v":1},{"$f":"C22","v":2.15}]
[null,"Diameter, d (m)",0.45800000000000002,{"$nulls":8},{"$f":"L15+0.5","v":3.5},{"$f":"M22-(L23-L22)*TAN(PI()/180*C25)","v":0.98423085461250337}]
[null,"Upstream angle, a (deg)",13]
[null,"Upstream angle, b (deg)",25,{"$nulls":8},1,{"$f":"M13","v":3.3}]
[{"$nulls":11},1,{"$f":"C22","v":2.15}]
["Foundation",{"$nulls":10},1,0]
[null,"Upstream depth hfu (m)",1.8,null,"Active earth pressure coeff, Ka",{"$f":"(COS(C24*PI()/180)-SQRT(COS(C24*PI()/180)^2-COS(C29*PI()/180)^2))/(COS(C24*PI()/180)+SQRT(COS(C24*PI()/180)^2-COS(C29*PI()/180)^2))","v":0.37147426453874921}]
[null,"Soil friction f, (deg)",30,null,null,"F Pa","Fx","Fy",null,null,null,"Pipe "]
[null,"g soil (kN/m3)",20,null,"Soil force",{"$f":"C30*C28^2/2*COS(PI()/180*C24)*F28*C15","v":23.454580527662532},{"$f":"C30*C28^2/2*COS(PI()/180*C24)*F28*C15*COS(PI()/180*C24)","v":22.853441148249058},{"$f":"C30*C28^2/2*COS(PI()/180*C24)*F28*C15*SIN(PI()/180*C24)","v":5.276132618890772},null,null,null,{"$f":"L21","v":-0.5},{"$f":"M21+$C$23","v":2.9543022866883448},{"$f":"M21-$C$23","v":2.0383022866883445}]
[null,"Bearing Capacity, SBC (kN/m2)",200,null,"Acting at (m)",{"$f":"C28/3","v":0.6},{"$nulls":5},{"$f":"L22","v":1},{"$f":"M22+$C$23","v":2.6080000000000001},{"$f":"M22-$C$23","v":1.6919999999999999}]
[{"$nulls":11},{"$f":"L23","v":3.5},{"$f":"M23+$C$23","v":1.4422308546125033},{"$f":"M23-$C$23","v":0.52623085461250341}]
["Forces (with soil pressure and block weight)"]
[null,"Forces with earthpressure & anchor","Yes",null,"Overturning",null,"Bearing",null,"Sliding"]
["Expansion",null,null,"Net Forces @ bend","SM @ O",{"$f":"D36*C22+G30*F31+F14*F15+D37*C21","v":563.30290274314666},"P max",{"$f":"C37/(C15*C16)*(1+6*F37/C16)","v":72.68096758104889},{"$f":"C18*C37","v":172.63},null,null,{"$f":"L30","v":-0.5},{"$f":"C28+ABS(L35)*TAN(C24*PI()/180)","v":1.9154340955627815}]
[null,"SH (kN)",53.18,{"$f":"C36-$G$30*IF(C34=\"No\",0,1)","v":30.326558851750942},"d",{"$f":"F35/C37","v":1.631532476229933},"P min",{"$f":"C37/(C15*C16)*(1-6*F37/C16)","v":42.405699085617769},{"$f":"IF(I35<1.5*C36,\"Not Ok\", \"Ok\")","v":"Ok"},null,null,{"$f":"L13","v":0},{"$f":"C28","v":1.8}]
[null,"SV (kN)",345.26,{"$f":"C37-($H$30+$F$14)*IF(C34=\"No\",0,1)","v":-16.214809835388394},{"$f":"\"eccentricity e, \"&IF(F38>F37, \"Ok\", \"Not OK\")","v":"eccentricity e, Ok"},{"$f":"ABS(C16/2-F36)","v":0.13153247622993303},null,{"$f":"IF(OR(H35<0,H36<0,H35>C31),\"Not Ok\", \"Ok\")","v":"Ok"}]
[{"$nulls":4},"e allowable",{"$f":"C16/6","v":0.5}]
[]
["Contraction",null,null,null,"SM @ O",{"$f":"D40*C22+G30*F31+F14*F15+D42*C21","v":473.28080121188202},"P max",{"$f":"C42/(C15*C16)*(1+6*F42/C16)","v":55.866399596039336},{"$f":"C18*C42","v":160.22}]
[null,"SH (kN)",16.66,{"$f":"C41-$G$30*IF(C34=\"No\",0,1)","v":-6.1934411482490574},"d",{"$f":"F40/C42","v":1.4769716677439833},"P min",{"$f":"C42/(C15*C16)*(1-6*F42/C16)","v":50.946933737293996},{"$f":"IF(I40<1.5*C41,\"Not Ok\", \"Ok\")","v":"Ok"}]
[null,"SV (kN)",320.44,{"$f":"C42-($H$30+$F$14)*IF(C34=\"No\",0,1)","v":-41.034809835388387},{"$f":"\"eccentricity e, \"&IF(F38>F42, \"Ok\", \"Not OK\")","v":"eccentricity e, Ok"},{"$f":"ABS(C16/2-F41)","v":2.3028332256016748E-2},null,{"$f":"IF(OR(H40<0,H41<0,H40>C31),\"Not Ok\", \"Ok\")","v":"Ok"}]
[{"$nulls":10},{"$f":" 30.327*2.15 + 22.853 * 0.6 + 356.199 * 1.405 - 16.215 * 1","v":563.15944500000001}]

{"sheet":"Turbine","index":13,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Turbine Selection"]
["Small Hydropower Promotion Project (SHPP)/GTZ",null,"Spreadsheet by Mr Pushpa Chitrakar"]
["Referances: 6,7,8,12,13","Date",{"$f":"TODAY()","v":"2012-07-20"}]
["SMALL HYDROPOWER PROMOTION PROJECT/GTZ","Revision","2006.05"]
["Project",{"$f":"Hydrology!$B$5","v":"Upper Jogmai SHP"}]
["Developer","Kankaimai Hydropower P Ltd"]
["Consultant","EPC Consult"]
["Designed","Pushpa Chitrakar"]
["Checked","Pushpa Chitrakar"]
[]
["Input"]
["Discharge (l/s)",150,"Gear ratio at turbine",1]
["Gross head (m)",69,"Gear ratio at generator",2]
["Hydraulic losses",0.15939999999999999,"No of turbines/generators",1]
["Max turbine output kW",67.89,"Total number of jets if Pelton n",2]
["Turbine rpm",750,"Specified turbine","Pelton"]
[{"$f":"IF(D16=\"Pelton\",\"Cd\",\"bo (mm)\")","v":"Cd"},0.96,{"$f":"IF(D16=\"Pelton\",\"Cu\",\"bo (mm)\")","v":"Cu"},0.46]
[]
["Output"]
["Net head m",{"$f":"B13*(1-B14)","v":58.001400000000004},"Generator with gearing rpm",{"$f":"B16*D13/D12","v":1500}]
[]
["No Gearing",null,"With Gearing"]
["Sp speed of runner rpm (no gearing)",{"$f":"B16*SQRT(1.4*B15/D14)/B20^(5/4)","v":45.680420185635334},"Sp speed of turbine",{"$f":"D12/D13*B23","v":22.840210092817667}]
[{"$f":"\"Pelton (12-30) => (Ns \"&ROUND(12*SQRT(D15),0)&\"-\"&ROUND(30*SQRT(D15),0)&\")\"","v":"Pelton (12-30) => (Ns 17-42)"},{"$f":"IF(OR(B23<12*SQRT(D15),B23>30*SQRT(D15)),\"**\",\"Pelton\")","v":"**"},{"$f":"\"Pelton (12-30) => (Ns \"&ROUND(12*SQRT(D15),0)&\"-\"&ROUND(30*SQRT(D15),0)&\")\"","v":"Pelton (12-30) => (Ns 17-42)"},{"$f":"IF(OR(D23<12*SQRT(D15),D23>30*SQRT(D15)),\"**\",\"Pelton\")","v":"Pelton"}]
[{"$f":"\"Turgo (Ns 20-70) => (Ns \"&ROUND(20*SQRT(D15),0)&\"-\"&ROUND(70*SQRT(D15),0)&\")\"","v":"Turgo (Ns 20-70) => (Ns 28-99)"},{"$f":"IF(OR(B23<20*SQRT(D15),B23>70*SQRT(D15)),\"**\",\"Turgo\")","v":"Turgo"},{"$f":"\"Turgo (Ns 20-70) => (Ns \"&ROUND(20*SQRT(D15),0)&\"-\"&ROUND(70*SQRT(D15),0)&\")\"","v":"Turgo (Ns 20-70) => (Ns 28-99)"},{"$f":"IF(OR(D23<20*SQRT(D15),D23>70*SQRT(D15)),\"**\",\"Turgo\")","v":"**"}]
["Crossflow (Ns 20-80)",{"$f":"IF(OR(B23<20,B23>80),\"**\",\"Crossflow\")","v":"Crossflow"},"Crossflow (Ns 20-80)",{"$f":"IF(OR(D23<20,D23>80),\"**\",\"Crossflow\")","v":"Crossflow"}]
["Fracis (Ns 80-400)",{"$f":"IF(OR(B23<80,B23>400),\"**\",\"Francis\")","v":"**"},"Fracis (Ns 80-400)",{"$f":"IF(OR(D23<80,D23>400),\"**\",\"Francis\")","v":"**"}]
["Propeller or Kaplan (Ns 340-1000)",{"$f":"IF(OR(B23<340,B23>1000),\"**\",\"Propeller/Kaplan\")","v":"**"},"Propeller or Kaplan (Ns 340-1000)",{"$f":"IF(OR(D23<340,D23>1000),\"**\",\"Propeller/Kaplan\")","v":"**"}]
[]
[{"$f":"IF(D16=\"Pelton\",\"Jet velocity Vj (m/s)\",\"bo (mm)\")","v":"Jet velocity Vj (m/s)"},{"$f":"IF(D16=\"Pelton\",B17*SQRT(2*9.81*B13*(1-B14)),B12/D14/(0.92*1*SQRT(B13)))","v":32.384707046826904}]
[{"$f":"IF(D16=\"Pelton\",\"Nozzle diameter, Dn (mm)\",\"nt\")","v":"Nozzle diameter, Dn (mm)"},{"$f":"IF(D16=\"Pelton\",SQRT(4*B12/D15/1000*1/(PI()*B30*0.98))*1000,40*SQRT(B13)/B17)","v":54.853288219552908}]
["Pitch circle diameter, PCD (mm)",{"$f":"60*(D17*SQRT(2*9.81*B13*(1-B14))*D20/B16)/(PI()*D20)*1000","v":395.15427587655023}]

{"sheet":"Electrical","index":14,"n_rows":159,"n_cols":9,"rows_kept":159,"cut":false,"hidden":false,"merged":[]}
["Selection of Electrical Equipment"]
["Small Hydropower Promotion Project (SHPP)/GTZ",null,"Spreadsheet by Mr Pushpa Chitrakar"]
["Referances: 6,7,8,12,13","Date",{"$f":"TODAY()","v":"2012-07-20"}]
["SMALL HYDROPOWER PROMOTION PROJECT/GTZ","Revision","2006.05"]
["Project",{"$f":"Hydrology!$B$5","v":"Upper Jogmai SHP"}]
["Developer","Kankaimai Hydropower P Ltd"]
["Consultant","EPC Consult"]
["Designed","Pushpa Chitrakar"]
["Checked","Pushpa Chitrakar"]
[]
["INPUT"]
["Discharge (m3/s)",0.08,"Power factor",0.8]
["Gross head (m)",50.968000000000004,"Safety factor of generator",1.3]
["Overall plant efficiency (%)",0.5,"Phase",1]
["Temperature (oC)",45,"Type of Generator",2]
["Altitude (m)",1500,"Over rating factor of MCCB",1.25]
["ELC correction factor",0.83,"Over rating factor of cable",1.5]
["Frequency of the system (Hz)",50,"No. of poles",4]
[{"$f":"\"Capacity of used generator \"&IF(D15=2,\"(kW)\",\"(kVA)\")","v":"Capacity of used generator (kW)"},0,"Rated rotor speed if induction generator  N (rpm)",1450]
[{"$f":"IF(D15=1,\"\",\"Capacitor configuration\")","v":"Capacitor configuration"},"Delta",{"$f":"IF(D15=1,\"\",\"Efficiency of motor at full load\")","v":"Efficiency of motor at full load"},0.89]
[]
["OUTPUT"]
["Pe Electrical output (active power) (kW)",{"$f":"B12*B13*B14*9.81","v":19.999843200000001},{"$f":"IF(AND(B23>10,D14=1),\"Use of 3-phase generator is mandatory\",\"Ok\")","v":"Use of 3-phase generator is mandatory"}]
[]
["Generator"]
["Temp.factor",{"$f":"FORECAST(B15,D86:D93,C86:C93)","v":0.95607142857142868},"Altitude factor",{"$f":"FORECAST(B16,B86:B100,A86:A100)","v":0.96278571428571436}]
[{"$f":"\"Capacity \"&IF(D15=2,\"(kW)\",\"(kVA)\")","v":"Capacity (kW)"},{"$f":"(B23/B26/D26)*D13*IF(D15=1,1/B17/D12,1)","v":28.245545436428273},{"$f":"\"Actual available capacity \"&IF(D15=2,\"(kW)\",\"(kVA)\")","v":"Actual available capacity (kW)"},{"$f":"IF(OR(AND(D15=1,OR(B27>200,B27<5))=TRUE,AND(D15=2,OR(B27>150,B27<0.1))=TRUE),\"NA\", IF(D15=1,IF(ISNA(MATCH(B27,D135:D157,0))=FALSE,B27,CHOOSE(MATCH(B27,D135:D157,1)+1,5,6,7.5,10,15,20,25,30,40,45,50,63,75,82.5,90,100,110,125,140,150,160,180,200)),IF(ISNA(MATCH(B27,H135:H159,0))=FALSE,B27,CHOOSE(MATCH(B27,H135:H159,1)+1,0.1,0.4,0.55,0.75,1.1,1.5,2.2,3.7,5.5,7.5,9.3,11,15,18.5,22,30,37,45,55,75,90,110,125,132,150))))","v":30}]
["Synchronous rotational speed Ns (rpm)",{"$f":"120*B18/D18","v":1500},{"$f":"IF(D15=1,\"\",\"Rotational speed of the generator (rpm)\")","v":"Rotational speed of the generator (rpm)"},{"$f":"IF(D15=1,\"\",B28*(1+(B28-D19)/B28))","v":1550.0000000000002}]
[]
[{"$f":"IF(D15=1,\"ELC\",\"IGC\")&\"  capacity (kW)\"","v":"IGC  capacity (kW)"},{"$f":"B23","v":19.999843200000001},"Calculated Ballast capacity 1.2*Pe (kW)",{"$f":"B23*1.2","v":23.99981184}]
[null,null,{"$f":"IF(D15=1,IF(B23<50,\"\",\"Ballast capacity of ELC-Extention (kW)\"),\"Excitation Capacitance (micro F)\")","v":"Excitation Capacitance (micro F)"},{"$f":"IF(D15=1,IF(B23<50,\"\",60%*1.2*B23+40%*B30),1000000/D20*IF(B20=\"Star\",3,1)*1000*B23*SIN(ACOS(D12))/(3*(IF(D14=1,SQRT(3),1)*B33)^2*D12*2*PI()*B18))","v":123.15728427054626}]
[]
["Rated Voltage (V)",{"$f":"IF(D15=1,IF(D14=1,230,400),IF(D14=1,220,380))","v":220},"Irated for Cable & MCCB (A) at Generator side",{"$f":"1000/B33*IF(B19>0,B19,D27)*IF(D14=1,1,1/1.732)*IF(D15=1,1,1/D12)","v":170.45454545454547}]
[]
["Rating of MCCB (A)",{"$f":"IF(D14=1,1,1/1.732)*B23*1000/D12/B33","v":113.63547272727271},"Calculated size of MCCB (A)",{"$f":"B35*D16","v":142.04434090909089}]
[]
["Cable "]
["Rating (A)",{"$f":"D33*D17","v":255.68181818181819},{"$f":"\"Size of \"&IF(D14=3,\"4\",\"2\")&\"-core cupper armoured cables\"","v":"Size of 2-core cupper armoured cables"},{"$f":"IF(ISNA(VLOOKUP(B38,A50:C67,2,FALSE)),VLOOKUP(B38,A50:C67,3,TRUE))","v":150}]
[]
[]
[]
[]
[]
[]
["REFERENCES AND TABLES"]
[]
["Table 1: 3-Phase system"]
["Current Rating of power cable with cupper conductor"]
["Current Rating (amps)","Conductor area (mm2)"]
[17,1.5,2.5]
[24,2.5,4]
[30,4,6]
[39,6,10]
[52,10,16]
[66,16,25]
[90,25,35]
[110,35,50]
[135,50,70]
[165,70,95]
[200,95,120]
[230,120,150]
[265,150,185]
[305,185,240]
[355,240,300]
[400,300,400]
[455,400,500]
[500,500]
[]
["Table 2: 1-Phase system"]
["Current Rating of power cable with cupper conductor"]
["Current Rating (amps)","Conductor area (mm2)"]
[12,1,1.5]
[15,1.5,2.5]
[22,2.5,4]
[29,4,6]
[37,6,10]
[51,10,16]
[68,16,25]
[86,25,35]
[110,35,40]
[121,40,50]
[145,50,"Refer cell note C27"]
[]
["Table 3: Altitudes and altitude factors",null,"Table 4: Temperatures and temperature factors"]
["Altitude ","Factor","Temperatures","Factors"]
[1000,1,20,1.1000000000000001]
[1250,0.98,25,1.08]
[1500,0.96,30,1.06]
[1750,0.94499999999999995,35,1.03]
[2000,0.93,40,1]
[2250,0.91500000000000004,45,0.96]
[2500,0.9,50,0.92]
[2750,0.88,55,0.88]
[3000,0.86]
[3250,0.84499999999999997]
[3500,0.83]
[3750,0.81499999999999995,"Table 5: Phases"]
[4000,0.8,"Phase"]
[4250,0.78500000000000003,"1-phase",1]
[4500,0.77,"3-phase",3]
[]
[]
[]
["Type of Generator"]
["Synchronous",1]
["Induction",2]
{"$rows_empty":9}
["Altitude ","Altitude factor",null,"Temperature","Temperature factor"]
[1000,1,null,20,1.1000000000000001]
[1250,0.98,null,25,1.08]
[1500,0.96,null,30,1.06]
[1750,0.94499999999999995,null,35,1.03]
[2000,0.93,null,40,1]
[2250,0.91500000000000004,null,45,0.96]
[2500,0.9,null,50,0.92]
[2750,0.88,null,55,0.88]
[3000,0.86]
[3250,0.84499999999999997]
[3500,0.83]
[3750,0.81499999999999995]
[4000,0.8]
[4250,0.78500000000000003]
[4500,0.77]
["Synchronous Generator",{"$nulls":6},"Induction Generator"]
["Single Phase",null,null,"Three Phase",null,null,null,"Three Phase"]
["Size (kVA)","Cost (Rs)",null,"Size (kVA)","Cost (Rs)",null,null,"Size (kW)","Cost (Rs)"]
[5,44400,null,5,36030,null,null,0.1,6180]
[6,48680,null,6,40310,null,null,0.4,6500]
[7.5,53520,null,7.5,49330,null,null,0.55000000000000004,7230]
[10,63290,null,10,54920,null,null,0.75,8470]
[15,86190,null,15,70180,null,null,1.1000000000000001,9340]
[20,75000,null,20,82235,null,null,1.5,11850]
[25,80000,null,25,104370,null,null,2.2000000000000002,14190]
[30,85000,null,30,101660,null,null,3.7,20730]
[40,90000,null,40,156640,null,null,5.5,23080]
[null,null,null,45,136070,null,null,7.5,38180]
[null,null,null,50,149520,null,null,9.3000000000000007,45100]
[null,null,null,63,190960,null,null,11,47490]
[null,null,null,75,204200,null,null,15,69510]
[null,null,null,82.5,207550,null,null,18.5,90520]
[null,null,null,90,216790,null,null,22,98330]
[null,null,null,100,247150,null,null,30,153320]
[null,null,null,110,254690,null,null,37,201580]
[null,null,null,125,278440,null,null,45,256870]
[null,null,null,140,307440,null,null,55,298500]
[null,null,null,150,332230,null,null,75,366690]
[null,null,null,160,342180,null,null,90,461360]
[null,null,null,180,357590,null,null,110,509020]
[null,null,null,200,388250,null,null,125,568550]
[{"$nulls":7},132,602000]
[{"$nulls":7},150,616720]

{"sheet":"MachineFoundation","index":15,"n_rows":69,"n_cols":10,"rows_kept":69,"cut":false,"hidden":false,"merged":[[55,0,55,1],[56,0,56,1],[42,2,42,3],[42,0,43,0],[42,1,43,1],[54,0,54,1],[57,0,57,1],[60,0,60,1],[67,0,67,1],[68,0,68,1],[61,0,61,1],[62,0,62,1],[63,0,63,1],[66,0,66,1]]}
["Turbine and Generator Machine Foundation",{"$nulls":5},"Section",null,"Plan"]
["Small Hydropower Promotion Project (SHPP)/GTZ","Spreadsheet by Mr Pushpa Chitrakar",{"$nulls":4},"X","y","x","y"]
["Referances: 6,12,13,15,16","Date",{"$f":"TODAY()","v":"2012-07-20"},null,null,null,0,0,0,0]
["SMALL HYDROPOWER PROMOTION PROJECT/GTZ","Revision","2006.05",null,null,null,{"$f":"B32","v":3.2},{"$f":"H3","v":0},{"$f":"G4","v":3.2},{"$f":"J3","v":0}]
["Project","Upper Jogmai, Ilam",{"$nulls":4},{"$f":"G4","v":3.2},{"$f":"B34","v":1.5},{"$f":"I4","v":3.2},{"$f":"B33","v":2.5}]
["Developer","Kankaimai Hydropower P Ltd",{"$nulls":4},{"$f":"C39+D33/2","v":0.85},{"$f":"H5","v":1.5},{"$f":"I3","v":0},{"$f":"J5","v":2.5}]
["Consultant","EPC Consult",{"$nulls":4},{"$f":"G6","v":0.85},{"$f":"H6-D35","v":0.5},{"$f":"I3","v":0},{"$f":"J3","v":0}]
["Designed","Pushpa Chitrakar",{"$nulls":4},{"$f":"G7-D33","v":0.39999999999999997},{"$f":"H7","v":0.5}]
["Checked","Pushpa Chitrakar",{"$nulls":4},{"$f":"G8","v":0.39999999999999997},{"$f":"H5","v":1.5},{"$f":"G9","v":0.39999999999999997},{"$f":"D39-D34/2","v":1}]
[{"$nulls":6},{"$f":"G3","v":0},{"$f":"H9","v":1.5},{"$f":"I9+D33","v":0.85},{"$f":"J9","v":1}]
[{"$nulls":6},{"$f":"G3","v":0},{"$f":"H3","v":0},{"$f":"I10","v":0.85},{"$f":"J10+D34","v":1.5}]
[{"$nulls":8},{"$f":"I9","v":0.39999999999999997},{"$f":"J11","v":1.5}]
[{"$nulls":8},{"$f":"I9","v":0.39999999999999997},{"$f":"J9","v":1}]
[]
[{"$nulls":6},"Turbine CL"]
[{"$nulls":6},{"$f":"I16","v":0.625},{"$f":"H17+0.1","v":1.6},{"$f":"C39","v":0.625},{"$f":"J17+0.5","v":1.75}]
[{"$nulls":6},{"$f":"I17","v":0.625},{"$f":"B34","v":1.5},{"$f":"I16","v":0.625},{"$f":"D39","v":1.25}]
[{"$nulls":6},{"$f":"I18","v":0.625},{"$f":"H17-0.5","v":1},{"$f":"I17","v":0.625},{"$f":"J17-0.5","v":0.75}]
[]
[{"$nulls":8},{"$f":"I21+0.5","v":1.125},{"$f":"D39","v":1.25}]
[{"$nulls":8},{"$f":"C39","v":0.625},{"$f":"J20","v":1.25}]
[{"$nulls":8},{"$f":"I21-0.5","v":0.125},{"$f":"J21","v":1.25}]
[{"$nulls":6},"Generator CL"]
["INPUT",{"$nulls":5},{"$f":"I24","v":2.0249999999999999},{"$f":"H16","v":1.6},{"$f":"C40","v":2.0249999999999999},{"$f":"J25+0.5","v":1.75}]
["Gross head hg (m)",51,"Design Discharge Qd (m3/s)",0.15,null,null,{"$f":"I25","v":2.0249999999999999},{"$f":"H17","v":1.5},{"$f":"I24","v":2.0249999999999999},{"$f":"D40","v":1.25}]
["Surge head hs (m)",50,{"$nulls":4},{"$f":"I26","v":2.0249999999999999},{"$f":"H18","v":1},{"$f":"I25","v":2.0249999999999999},{"$f":"J25-0.5","v":0.75}]
[]
["Foundation",null,"Penstock",{"$nulls":5},{"$f":"I29+0.5","v":2.5249999999999999},{"$f":"D40","v":1.25}]
["Foundation on ","Soil","Diameter dp (m)",0.3,{"$nulls":4},{"$f":"C40","v":2.0249999999999999},{"$f":"J28","v":1.25}]
["Allowable bearing capacity Pall (kN/m2)",180,"Material","mild steel",{"$nulls":4},{"$f":"I29-0.5","v":1.5249999999999999},{"$f":"J29","v":1.25}]
["Friction coeff between block and soil m",0.5,"Centreline above PH floor hp (m)",0.3]
["Length L (m)",3.2,"Turbine Pit",null,null,null,"W1"]
["Bredth B (m)",2.5,"Length of opening Lo (m)",0.45,null,null,{"$f":"$B$32-C47","v":0.20000000000000018},{"$f":"H16-0.9","v":0.70000000000000007}]
["Height H (m)",1.5,"Bredth of opening Bo (m)",0.5,null,null,{"$f":"G33","v":0.20000000000000018},{"$f":"H17-0.9","v":0.6}]
["Material of foundation","Concrete","Height of opening Ho (m)",1,null,null,{"$f":"G34","v":0.20000000000000018},{"$f":"H18-0.9","v":9.9999999999999978E-2}]
["Density of foundation (kM/m3)",22,"Height of tailrace canal Htr (m)",0.5]
[{"$nulls":6},"W2"]
["Electro-mechanical",null,"XX (m)","YY (m)",null,null,{"$f":"$B$32-C48","v":0.625},{"$f":"H33","v":0.70000000000000007}]
["Weight of turbine Wt (kN) & cl position",{"$f":"300*9.81/1000","v":2.9430000000000001},0.625,1.25,null,null,{"$f":"G38","v":0.625},{"$f":"H34","v":0.6}]
["Weight of generator Wg (kN) & cl position",{"$f":"350*9.81/1000","v":3.4335},2.0249999999999999,1.25,null,null,{"$f":"G39","v":0.625},{"$f":"H35","v":9.9999999999999978E-2}]
[{"$nulls":6},"W3"]
["OUTPUT",{"$nulls":5},{"$f":"$B$32-C49","v":2.0250000000000004},{"$f":"H38","v":0.70000000000000007}]
["Forces","Weight Wi (kN)","Lever Arm LA (m)",null,null,null,{"$f":"G42","v":2.0250000000000004},{"$f":"H39","v":0.6}]
[null,null,"LA along XX","LA along YY",null,null,{"$f":"G43","v":2.0250000000000004},{"$f":"H40","v":9.9999999999999978E-2}]
[{"$f":"\"Force due to h total of \"&ROUND(B25+B26,3)&\" m, Fh (kN)\"","v":"Force due to h total of 101 m, Fh (kN)"},{"$f":"PI()*D29^2/4*(B25+B26)*9.81","v":70.036231884824318},{"$f":"B34+D31","v":1.8}]
["Foundation"]
["W1",{"$f":"(C39-D33/2)*B34*B33*$B$36","v":33.000000000000007},{"$f":"B32-(C39-D33/2)/2","v":3},{"$f":"B33/2","v":1.25}]
["W2",{"$f":"(D33*B34*B33-D33*D34*D35-D33*D36*D35)*$B$36","v":27.224999999999994},{"$f":"B32-C39","v":2.5750000000000002},{"$f":"D47","v":1.25}]
["W3",{"$f":"(B32-(C39+D33/2))*B34*B33*$B$36","v":193.875},{"$f":"(C48-D33/2)/2","v":1.175},{"$f":"D47","v":1.25}]
["Sum of moments SM (kN-m)",null,{"$f":"B47*C47+(B48+B39)*C48+(B49+B40)*C49-B45*C45","v":282.45487010731625},{"$f":"B47*D47+(B48+B39)*D48+(B49+B40)*D49-B45*C45","v":199.53040760731625}]
["Sum of vertical forces SM (kN)",null,{"$f":"SUM(B47:B49,B39:B40)","v":260.47649999999999},{"$f":"C51","v":260.47649999999999}]
[]
["Overturning"]
["Equivalent distance at which SM acts from critical point",null,"LA along XX","LA along YY"]
["d (m)",null,{"$f":"C50/C51","v":1.0843775546251437},{"$f":"D50/D51","v":0.76602076428129318}]
["Eccentricity e, (m)",null,{"$f":"(B32/2-C55)","v":0.51562244537485635},{"$f":"(B33/2-D55)","v":0.48397923571870682}]
["Allowable eccentricity e all (m)",null,{"$f":"B32/6","v":0.53333333333333333},{"$f":"B33/6","v":0.41666666666666669}]
["Comment on overturning moment",null,{"$f":"IF(C57>C56, \"Ok\",\"Not Ok\")","v":"Ok"},{"$f":"IF(D57>D56, \"Ok\",\"Not Ok\")","v":"Not Ok"}]
[]
["Bearing"]
["Pressure at base",null,"LA along XX","LA along YY"]
["Pmax",null,{"$f":"C51/(B32*B33)*(1+6*C56/B32)","v":64.037889818597762},{"$f":"D51/(B32*B33)*(1+6*D56/B33)","v":70.379127717805105}]
["Pmin",null,{"$f":"C51/(B32*B33)*(1-6*C56/B32)","v":1.0812351814022421},{"$f":"D51/(B32*B33)*(1-6*D56/B33)","v":-5.2600027178051194}]
["Comments on bearing",null,{"$f":"IF(OR(C62>B30,C62<0,C63<0), \"Not Ok\",\"Ok\")","v":"Ok"},{"$f":"IF(OR(D62>B30,D62<0,D63<0), \"Not Ok\",\"Ok\")","v":"Not Ok"}]
[]
["Sliding"]
[null,null,"LA along XX","LA along YY"]
["Factor of safety against sliding, FS sl",null,{"$f":"B31*C51/B45","v":1.8595839109987933},{"$f":"B31*D51/B45","v":1.8595839109987933}]
["Comment of sliding",null,{"$f":"IF(C68<1.5, \"Not Ok\",\"Ok\")","v":"Ok"},{"$f":"IF(D68<1.5, \"Not Ok\",\"Ok\")","v":"Ok"}]

{"sheet":"Transmission","index":16,"n_rows":42,"n_cols":36,"rows_kept":42,"cut":false,"hidden":false,"merged":[[13,7,13,8],[16,0,16,2],[25,0,25,2],[38,0,38,2],[28,0,28,2],[34,0,34,2],[22,0,22,2],[31,0,31,2]]}
["Transmission and Distribution System: ",{"$nulls":26},"Sizes and designations of ACSR conductors for MHP systems:"]
["Small Hydropower Promotion Project (SHPP)/GTZ",{"$nulls":5},"Spreadsheet by Mr Pushpa Chitrakar",{"$nulls":20},"ACSR Code  number","Type of ACSR","Resistance  Ohm/km","Current rating max Amps","Equivalent Cu area mm2","Inductive Reactance Ohm/km","Sp. Weight (kg/km)","Sp. Cost (Rs/km)","ACSR Code  number"]
["Referances:2,4, 6,12,13,15,16",{"$nulls":11},"Date",{"$f":"TODAY()","v":"2012-07-20"},{"$nulls":13},1,"Squirrel",1.3740000000000001,76,13,0.35499999999999998,80,13000,1]
["SMALL HYDROPOWER PROMOTION PROJECT/GTZ",{"$nulls":11},"Revision","2006.05",{"$nulls":13},2,"Gopher",1.0980000000000001,85,16,0.34899999999999998,106,14500,2]
["Project:   ",null,{"$f":"Hydrology!B5","v":"Upper Jogmai SHP"},{"$nulls":5},"Location:","Power factor",null,0.8,null,"Cable Summary",{"$nulls":13},3,"Weasel",0.91159999999999997,95,20,0.34499999999999997,128,15500,3]
["Developer",null,"Kankaimai Hydropower P Ltd",{"$nulls":6},"Voltage systems",null,11000,null,"Type","Length(km)",{"$nulls":12},4,"Rabbit",0.54490000000000005,135,30,0.33500000000000002,214,25750,4]
["Consultant",null,"EPC Consult",{"$nulls":8},400,null,"Squirrel",{"$f":"SUM(U:U)","v":4.5},{"$nulls":12},5,"Otter",0.34339999999999998,185,50,0.32800000000000001,null,35000,5]
["Designed",null,"Pushpa Chitrakar",{"$nulls":8},230,null,"Gopher",{"$f":"SUM(V:V)","v":0},{"$nulls":12},6,"Dog",0.27450000000000002,205,65,0.315,394,52000,6]
["Checked",null,"Pushpa Chitrakar",{"$nulls":10},"Weasel",{"$f":"SUM(W:W)","v":10}]
[{"$nulls":13},"Rabbit",{"$f":"SUM(X:X)","v":3}]
[{"$nulls":13},"Otter",{"$f":"SUM(Y:Y)","v":1.1499999999999999},{"$nulls":14},"Dog",6]
[{"$nulls":13},"Dog",{"$f":"SUM(Z:Z)","v":5.3000000000000007},{"$nulls":14},"Dog",6]
[{"$nulls":13},"Total Cost(Rs)",{"$f":"SUMPRODUCT(AI3:AI8,O7:O12)","v":606600},{"$nulls":14},"Gopher",2]
[{"$nulls":7},"Intermediate Calculation",{"$nulls":4},"Length of neutral cables (km)",{"$nulls":9},10,null,null,0.3,null,null,null,"Otter",5]
["Node name",null,"Reach name","Reach Length (km)","Phase 1,3,11","Power at next node (kW)","ACSR type","ACSR code","Remarks \" \" or repeated","Load Momentum (kW-m)","V @ prev node (V)","Current (A) ","Reach Voltage drop (V)","V @ next node (V)","  S% voltage drop","dV at brach (V)","V @ prev node (V)","Resistance Ohm/km","Reactance Ohm/km","Impedence Ohm/km","Squirrel","Gopher","Weasel","Rabbiit","Otter","Dog",null,null,null,"Rabbit",4]
[{"$nulls":29},"Squirrel",1]
["PH-A-B-C-D",null,null,null,3,{"$nulls":5},400,null,null,{"$f":"K17","v":400},null,null,{"$f":"K17","v":400},null,null,null,{"$f":"IF(AND(H17=1,UPPER(I17=\"\")),D17,0)*IF(E17=1,2,3)","v":0},{"$f":"IF(AND(H17=2,UPPER(I17=\"\")),D17,0)*IF(E17=1,2,3)","v":0},{"$f":"IF(AND(H17=3,UPPER(I17=\"\")),D17,0)*IF(E17=1,2,3)","v":0},{"$f":"IF(AND(H17=4,UPPER(I17=\"\")),D17,0)*IF(E17=1,2,3)","v":0},{"$f":"IF(AND(H17=5,UPPER(I17=\"\")),D17,0)*IF(E17=1,2,3)","v":0},{"$f":"IF(AND(H17=6,UPPER(I17=\"\")),D17,0)*IF(E17=1,2,3)","v":0},null,null,null,"Weasel",3]
["PH","A",{"$f":"IF(AND(A17=\"\",A18=\"\"),LEFT(C17,1),IF(A18=\"\",LEFT(C17,1),A18))&B18","v":"PHA"},0.3,3,16,"Dog",{"$f":"VLOOKUP(G18,$AD$11:$AE$17,2)","v":6},null,{"$f":"D18*1000*F18","v":4800},{"$f":"IF(M17=0,K17,IF(OR(E18=3,E18=11),Q18,IF(AND(E17=3,E18=1),Q18/SQRT(3),IF(A18=\"\",K17,IF(AND(E17=1,E18=1),N17,K17)))))","v":400},{"$f":"F18*1000/$L$5/K18*(IF(OR(AND(E18=11,E17=11),AND(E18=3,E17=3)),1/SQRT(3),1))","v":28.867513459481291},{"$f":"ROUND(T18*D18*L18*IF(E18=1,2, SQRT(3)),1)","v":6.3},{"$f":"K18-M18","v":393.7},{"$f":"100*(1-N18/IF(E18=11,$L$6,IF(E18=3,$L$7,$L$8)))","v":1.5750000000000042},{"$f":"IF(OR(AND(E17=1,E18=1,A18<>\"\"),AND(E17=3,E18=1)),O17,0)","v":0},{"$f":"IF(A19=\"\",Q17,IF(OR(AND(E18=11,E17=11),AND(E18=1,E17=1),AND(E17=3,E18=3)),N17-M18,IF(AND(E18=1,E17=3),N17/SQRT(3))))","v":393.7},{"$f":"CHOOSE(H18,1.347,1.098,0.9116,0.5449,0.3434,0.2745)","v":0.27450000000000002},{"$f":"CHOOSE(H18,0.355,0.349,0.345,0.335,0.328,0.315)","v":0.315},{"$f":"SQRT(S18^2+R18^2)","v":0.41782203149187813},{"$f":"IF(AND(H18=1,UPPER(I18)=\"\"),D18,0)*IF(E18=1,2,3)","v":0},{"$f":"IF(AND(H18=2,UPPER(I18)=\"\"),D18,0)*IF(E18=1,2,3)","v":0},{"$f":"IF(AND(H18=3,UPPER(I18)=\"\"),D18,0)*IF(E18=1,2,3)","v":0},{"$f":"IF(AND(H18=4,UPPER(I18)=\"\"),D18,0)*IF(E18=1,2,3)","v":0},{"$f":"IF(AND(H18=5,UPPER(I18)=\"\"),D18,0)*IF(E18=1,2,3)","v":0},{"$f":"IF(AND(H18=6,UPPER(I18)=\"\"),D18,0)*IF(E18=1,2,3)","v":0.89999999999999991}]
["A","B",{"$f":"IF(AND(A18=\"\",A19=\"\"),LEFT(C18,1),IF(A19=\"\",LEFT(C18,1),A19))&B19","v":"AB"},0.5,1,5,"Rabbit",{"$f":"VLOOKUP(G19,$AD$11:$AE$17,2)","v":4},null,{"$f":"D19*1000*F19","v":2500},{"$f":"IF(M18=0,K18,IF(OR(E19=3,E19=11),Q19,IF(AND(E18=3,E19=1),Q19/SQRT(3),IF(A19=\"\",K18,IF(AND(E18=1,E19=1),N18,K18)))))","v":227.30280097995566},{"$f":"F19*1000/$L$5/K19*(IF(OR(AND(E19=11,E18=11),AND(E19=3,E18=3)),1/SQRT(3),1))","v":27.496361562879052},{"$f":"ROUND(T19*D19*L19*IF(E19=1,2, SQRT(3)),1)","v":17.600000000000001},{"$f":"K19-M19","v":209.70280097995567},{"$f":"100*(1-N19/IF(E19=11,$L$6,IF(E19=3,$L$7,$L$8)))","v":8.8248691391497047},{"$f":"IF(OR(AND(E18=1,E19=1,A19<>\"\"),AND(E18=3,E19=1)),O18,0)","v":1.5750000000000042},{"$f":"IF(A20=\"\",Q18,IF(OR(AND(E19=11,E18=11),AND(E19=1,E18=1),AND(E18=3,E19=3)),N18-M19,IF(AND(E19=1,E18=3),N18/SQRT(3))))","v":393.7},{"$f":"CHOOSE(H19,1.347,1.098,0.9116,0.5449,0.3434,0.2745)","v":0.54490000000000005},{"$f":"CHOOSE(H19,0.355,0.349,0.345,0.335,0.328,0.315)","v":0.33500000000000002},{"$f":"SQRT(S19^2+R19^2)","v":0.63964131355002396},{"$f":"IF(AND(H19=1,UPPER(I19)=\"\"),D19,0)*IF(E19=1,2,3)","v":0},{"$f":"IF(AND(H19=2,UPPER(I19)=\"\"),D19,0)*IF(E19=1,2,3)","v":0},{"$f":"IF(AND(H19=3,UPPER(I19)=\"\"),D19,0)*IF(E19=1,2,3)","v":0},{"$f":"IF(AND(H19=4,UPPER(I19)=\"\"),D19,0)*IF(E19=1,2,3)","v":1},{"$f":"IF(AND(H19=5,UPPER(I19)=\"\"),D19,0)*IF(E19=1,2,3)","v":0},{"$f":"IF(AND(H19=6,UPPER(I19)=\"\"),D19,0)*IF(E19=1,2,3)","v":0}]
[null,"C",{"$f":"IF(AND(A19=\"\",A20=\"\"),LEFT(C19,1),IF(A20=\"\",LEFT(C19,1),A20))&B20","v":"AC"},0.5,1,5,"Rabbit",{"$f":"VLOOKUP(G20,$AD$11:$AE$17,2)","v":4},null,{"$f":"D20*1000*F20","v":2500},{"$f":"IF(M19=0,K19,IF(OR(E20=3,E20=11),Q20,IF(AND(E19=3,E20=1),Q20/SQRT(3),IF(A20=\"\",K19,IF(AND(E19=1,E20=1),N19,K19)))))","v":227.30280097995566},{"$f":"F20*1000/$L$5/K20*(IF(OR(AND(E20=11,E19=11),AND(E20=3,E19=3)),1/SQRT(3),1))","v":27.496361562879052},{"$f":"ROUND(T20*D20*L20*IF(E20=1,2, SQRT(3)),1)","v":17.600000000000001},{"$f":"K20-M20","v":209.70280097995567},{"$f":"100*(1-N20/IF(E20=11,$L$6,IF(E20=3,$L$7,$L$8)))","v":8.8248691391497047},{"$f":"IF(A20=\"\",P19,0)","v":1.5750000000000042},{"$f":"IF(A21=\"\",Q19,IF(OR(AND(E20=11,E19=11),AND(E20=1,E19=1),AND(E19=3,E20=3)),N19-M20,IF(AND(E20=1,E19=3),N19/SQRT(3))))","v":393.7},{"$f":"CHOOSE(H20,1.347,1.098,0.9116,0.5449,0.3434,0.2745)","v":0.54490000000000005},{"$f":"CHOOSE(H20,0.355,0.349,0.345,0.335,0.328,0.315)","v":0.33500000000000002},{"$f":"SQRT(S20^2+R20^2)","v":0.63964131355002396},{"$f":"IF(AND(H20=1,UPPER(I20)=\"\"),D20,0)*IF(E20=1,2,3)","v":0},{"$f":"IF(AND(H20=2,UPPER(I20)=\"\"),D20,0)*IF(E20=1,2,3)","v":0},{"$f":"IF(AND(H20=3,UPPER(I20)=\"\"),D20,0)*IF(E20=1,2,3)","v":0},{"$f":"IF(AND(H20=4,UPPER(I20)=\"\"),D20,0)*IF(E20=1,2,3)","v":1},{"$f":"IF(AND(H20=5,UPPER(I20)=\"\"),D20,0)*IF(E20=1,2,3)","v":0},{"$f":"IF(AND(H20=6,UPPER(I20)=\"\"),D20,0)*IF(E20=1,2,3)","v":0}]
[null,"D",{"$f":"IF(AND(A20=\"\",A21=\"\"),LEFT(C20,1),IF(A21=\"\",LEFT(C20,1),A21))&B21","v":"AD"},0.5,1,5,"Rabbit",{"$f":"VLOOKUP(G21,$AD$11:$AE$17,2)","v":4},null,{"$f":"D21*1000*F21","v":2500},{"$f":"IF(M20=0,K20,IF(OR(E21=3,E21=11),Q21,IF(AND(E20=3,E21=1),Q21/SQRT(3),IF(A21=\"\",K20,IF(AND(E20=1,E21=1),N20,K20)))))","v":227.30280097995566},{"$f":"F21*1000/$L$5/K21*(IF(OR(AND(E21=11,E20=11),AND(E21=3,E20=3)),1/SQRT(3),1))","v":27.496361562879052},{"$f":"ROUND(T21*D21*L21*IF(E21=1,2, SQRT(3)),1)","v":17.600000000000001},{"$f":"K21-M21","v":209.70280097995567},{"$f":"100*(1-N21/IF(E21=11,$L$6,IF(E21=3,$L$7,$L$8)))","v":8.8248691391497047},{"$f":"IF(A21=\"\",P20,0)","v":1.5750000000000042},{"$f":"IF(A22=\"\",Q20,IF(OR(AND(E21=11,E20=11),AND(E21=1,E20=1),AND(E20=3,E21=3)),N20-M21,IF(AND(E21=1,E20=3),N20/SQRT(3))))","v":393.7},{"$f":"CHOOSE(H21,1.347,1.098,0.9116,0.5449,0.3434,0.2745)","v":0.54490000000000005},{"$f":"CHOOSE(H21,0.355,0.349,0.345,0.335,0.328,0.315)","v":0.33500000000000002},{"$f":"SQRT(S21^2+R21^2)","v":0.63964131355002396},{"$f":"IF(AND(H21=1,UPPER(I21)=\"\"),D21,0)*IF(E21=1,2,3)","v":0},{"$f":"IF(AND(H21=2,UPPER(I21)=\"\"),D21,0)*IF(E21=1,2,3)","v":0},{"$f":"IF(AND(H21=3,UPPER(I21)=\"\"),D21,0)*IF(E21=1,2,3)","v":0},{"$f":"IF(AND(H21=4,UPPER(I21)=\"\"),D21,0)*IF(E21=1,2,3)","v":1},{"$f":"IF(AND(H21=5,UPPER(I21)=\"\"),D21,0)*IF(E21=1,2,3)","v":0},{"$f":"IF(AND(H21=6,UPPER(I21)=\"\"),D21,0)*IF(E21=1,2,3)","v":0}]
[]
["PH-T1",null,null,null,3,{"$nulls":5},400,null,null,{"$f":"K23","v":400},null,null,{"$f":"K23","v":400},null,null,null,{"$f":"IF(AND(H23=1,UPPER(I23=\"\")),D23,0)*IF(E23=1,2,3)","v":0},{"$f":"IF(AND(H23=2,UPPER(I23=\"\")),D23,0)*IF(E23=1,2,3)","v":0},{"$f":"IF(AND(H23=3,UPPER(I23=\"\")),D23,0)*IF(E23=1,2,3)","v":0},{"$f":"IF(AND(H23=4,UPPER(I23=\"\")),D23,0)*IF(E23=1,2,3)","v":0},{"$f":"IF(AND(H23=5,UPPER(I23=\"\")),D23,0)*IF(E23=1,2,3)","v":0},{"$f":"IF(AND(H23=6,UPPER(I23=\"\")),D23,0)*IF(E23=1,2,3)","v":0}]
["PH","T1",{"$f":"IF(AND(A23=\"\",A24=\"\"),LEFT(C23,1),IF(A24=\"\",LEFT(C23,1),A24))&B24","v":"PHT1"},0.05,3,21,"Otter",{"$f":"VLOOKUP(G24,$AD$11:$AE$17,2)","v":5},null,{"$f":"D24*1000*F24","v":1050},{"$f":"IF(M23=0,K23,IF(OR(E24=3,E24=11),Q24,IF(AND(E23=3,E24=1),Q24/SQRT(3),IF(A24=\"\",K23,IF(AND(E23=1,E24=1),N23,K23)))))","v":400},{"$f":"F24*1000/$L$5/K24*(IF(OR(AND(E24=11,E23=11),AND(E24=3,E23=3)),1/SQRT(3),1))","v":37.888611415569194},{"$f":"ROUND(T24*D24*L24*IF(E24=1,2, SQRT(3)),1)","v":1.6},{"$f":"K24-M24","v":398.4},{"$f":"100*(1-N24/IF(E24=11,$L$6,IF(E24=3,$L$7,$L$8)))","v":0.40000000000000036},{"$f":"IF(OR(AND(E23=1,E24=1,A24<>\"\"),AND(E23=3,E24=1)),O23,0)","v":0},{"$f":"IF(A25=\"\",Q23,IF(OR(AND(E24=11,E23=11),AND(E24=1,E23=1),AND(E23=3,E24=3)),N23-M24,IF(AND(E24=1,E23=3),N23/SQRT(3))))","v":400},{"$f":"CHOOSE(H24,1.347,1.098,0.9116,0.5449,0.3434,0.2745)","v":0.34339999999999998},{"$f":"CHOOSE(H24,0.355,0.349,0.345,0.335,0.328,0.315)","v":0.32800000000000001},{"$f":"SQRT(S24^2+R24^2)","v":0.47487636285669138},{"$f":"IF(AND(H24=1,UPPER(I24)=\"\"),D24,0)*IF(E24=1,2,3)","v":0},{"$f":"IF(AND(H24=2,UPPER(I24)=\"\"),D24,0)*IF(E24=1,2,3)","v":0},{"$f":"IF(AND(H24=3,UPPER(I24)=\"\"),D24,0)*IF(E24=1,2,3)","v":0},{"$f":"IF(AND(H24=4,UPPER(I24)=\"\"),D24,0)*IF(E24=1,2,3)","v":0},{"$f":"IF(AND(H24=5,UPPER(I24)=\"\"),D24,0)*IF(E24=1,2,3)","v":0.15000000000000002},{"$f":"IF(AND(H24=6,UPPER(I24)=\"\"),D24,0)*IF(E24=1,2,3)","v":0}]
[]
["T1-T2",null,null,null,11,{"$nulls":5},11000,null,null,{"$f":"K26","v":11000},null,null,{"$f":"K26","v":11000},null,null,null,{"$f":"IF(AND(H26=1,UPPER(I26=\"\")),D26,0)*IF(E26=1,2,3)","v":0},{"$f":"IF(AND(H26=2,UPPER(I26=\"\")),D26,0)*IF(E26=1,2,3)","v":0},{"$f":"IF(AND(H26=3,UPPER(I26=\"\")),D26,0)*IF(E26=1,2,3)","v":0},{"$f":"IF(AND(H26=4,UPPER(I26=\"\")),D26,0)*IF(E26=1,2,3)","v":0},{"$f":"IF(AND(H26=5,UPPER(I26=\"\")),D26,0)*IF(E26=1,2,3)","v":0},{"$f":"IF(AND(H26=6,UPPER(I26=\"\")),D26,0)*IF(E26=1,2,3)","v":0}]
["T1 ","T2",{"$f":"IF(AND(A26=\"\",A27=\"\"),LEFT(C26,1),IF(A27=\"\",LEFT(C26,1),A27))&B27","v":"T1 T2"},1.5,11,21,"Squirrel",{"$f":"VLOOKUP(G27,$AD$11:$AE$17,2)","v":1},null,{"$f":"D27*1000*F27","v":31500},{"$f":"IF(M26=0,K26,IF(OR(E27=3,E27=11),Q27,IF(AND(E26=3,E27=1),Q27/SQRT(3),IF(A27=\"\",K26,IF(AND(E26=1,E27=1),N26,K26)))))","v":11000},{"$f":"F27*1000/$L$5/K27*(IF(OR(AND(E27=11,E26=11),AND(E27=3,E26=3)),1/SQRT(3),1))","v":1.3777676878388798},{"$f":"ROUND(T27*D27*L27*IF(E27=1,2, SQRT(3)),1)","v":5},{"$f":"K27-M27","v":10995},{"$f":"100*(1-N27/IF(E27=11,$L$6,IF(E27=3,$L$7,$L$8)))","v":4.5454545454548523E-2},{"$f":"IF(OR(AND(E26=1,E27=1,A27<>\"\"),AND(E26=3,E27=1)),O26,0)","v":0},{"$f":"IF(A28=\"\",Q26,IF(OR(AND(E27=11,E26=11),AND(E27=1,E26=1),AND(E26=3,E27=3)),N26-M27,IF(AND(E27=1,E26=3),N26/SQRT(3))))","v":11000},{"$f":"CHOOSE(H27,1.347,1.098,0.9116,0.5449,0.3434,0.2745)","v":1.347},{"$f":"CHOOSE(H27,0.355,0.349,0.345,0.335,0.328,0.315)","v":0.35499999999999998},{"$f":"SQRT(S27^2+R27^2)","v":1.3929946159264219},{"$f":"IF(AND(H27=1,UPPER(I27)=\"\"),D27,0)*IF(E27=1,2,3)","v":4.5},{"$f":"IF(AND(H27=2,UPPER(I27)=\"\"),D27,0)*IF(E27=1,2,3)","v":0},{"$f":"IF(AND(H27=3,UPPER(I27)=\"\"),D27,0)*IF(E27=1,2,3)","v":0},{"$f":"IF(AND(H27=4,UPPER(I27)=\"\"),D27,0)*IF(E27=1,2,3)","v":0},{"$f":"IF(AND(H27=5,UPPER(I27)=\"\"),D27,0)*IF(E27=1,2,3)","v":0},{"$f":"IF(AND(H27=6,UPPER(I27)=\"\"),D27,0)*IF(E27=1,2,3)","v":0}]
[]
["T2-E",null,null,null,3,{"$nulls":5},400,null,null,{"$f":"K29","v":400},null,null,{"$f":"K29","v":400},null,null,null,{"$f":"IF(AND(H29=1,UPPER(I29=\"\")),D29,0)*IF(E29=1,2,3)","v":0},{"$f":"IF(AND(H29=2,UPPER(I29=\"\")),D29,0)*IF(E29=1,2,3)","v":0},{"$f":"IF(AND(H29=3,UPPER(I29=\"\")),D29,0)*IF(E29=1,2,3)","v":0},{"$f":"IF(AND(H29=4,UPPER(I29=\"\")),D29,0)*IF(E29=1,2,3)","v":0},{"$f":"IF(AND(H29=5,UPPER(I29=\"\")),D29,0)*IF(E29=1,2,3)","v":0},{"$f":"IF(AND(H29=6,UPPER(I29=\"\")),D29,0)*IF(E29=1,2,3)","v":0}]
["T2 ","E",{"$f":"IF(AND(A29=\"\",A30=\"\"),LEFT(C29,1),IF(A30=\"\",LEFT(C29,1),A30))&B30","v":"T2 E"},0.3,3,21,"Dog",{"$f":"VLOOKUP(G30,$AD$11:$AE$17,2)","v":6},null,{"$f":"D30*1000*F30","v":6300},{"$f":"IF(M29=0,K29,IF(OR(E30=3,E30=11),Q30,IF(AND(E29=3,E30=1),Q30/SQRT(3),IF(A30=\"\",K29,IF(AND(E29=1,E30=1),N29,K29)))))","v":400},{"$f":"F30*1000/$L$5/K30*(IF(OR(AND(E30=11,E29=11),AND(E30=3,E29=3)),1/SQRT(3),1))","v":37.888611415569194},{"$f":"ROUND(T30*D30*L30*IF(E30=1,2, SQRT(3)),1)","v":8.1999999999999993},{"$f":"K30-M30","v":391.8},{"$f":"100*(1-N30/IF(E30=11,$L$6,IF(E30=3,$L$7,$L$8)))","v":2.0499999999999963},{"$f":"IF(OR(AND(E29=1,E30=1,A30<>\"\"),AND(E29=3,E30=1)),O29,0)","v":0},{"$f":"IF(A31=\"\",Q29,IF(OR(AND(E30=11,E29=11),AND(E30=1,E29=1),AND(E29=3,E30=3)),N29-M30,IF(AND(E30=1,E29=3),N29/SQRT(3))))","v":400},{"$f":"CHOOSE(H30,1.347,1.098,0.9116,0.5449,0.3434,0.2745)","v":0.27450000000000002},{"$f":"CHOOSE(H30,0.355,0.349,0.345,0.335,0.328,0.315)","v":0.315},{"$f":"SQRT(S30^2+R30^2)","v":0.41782203149187813},{"$f":"IF(AND(H30=1,UPPER(I30)=\"\"),D30,0)*IF(E30=1,2,3)","v":0},{"$f":"IF(AND(H30=2,UPPER(I30)=\"\"),D30,0)*IF(E30=1,2,3)","v":0},{"$f":"IF(AND(H30=3,UPPER(I30)=\"\"),D30,0)*IF(E30=1,2,3)","v":0},{"$f":"IF(AND(H30=4,UPPER(I30)=\"\"),D30,0)*IF(E30=1,2,3)","v":0},{"$f":"IF(AND(H30=5,UPPER(I30)=\"\"),D30,0)*IF(E30=1,2,3)","v":0},{"$f":"IF(AND(H30=6,UPPER(I30)=\"\"),D30,0)*IF(E30=1,2,3)","v":0.89999999999999991}]
[]
["E-J ( r )",null,null,null,1,{"$nulls":5},{"$f":"N30/SQRT(3)","v":226.20583546849539},null,null,{"$f":"K32","v":226.20583546849539},null,null,{"$f":"K32","v":226.20583546849539},null,null,null,{"$f":"IF(AND(H32=1,UPPER(I32=\"\")),D32,0)*IF(E32=1,2,3)","v":0},{"$f":"IF(AND(H32=2,UPPER(I32=\"\")),D32,0)*IF(E32=1,2,3)","v":0},{"$f":"IF(AND(H32=3,UPPER(I32=\"\")),D32,0)*IF(E32=1,2,3)","v":0},{"$f":"IF(AND(H32=4,UPPER(I32=\"\")),D32,0)*IF(E32=1,2,3)","v":0},{"$f":"IF(AND(H32=5,UPPER(I32=\"\")),D32,0)*IF(E32=1,2,3)","v":0},{"$f":"IF(AND(H32=6,UPPER(I32=\"\")),D32,0)*IF(E32=1,2,3)","v":0}]
["E","J",{"$f":"IF(AND(A32=\"\",A33=\"\"),LEFT(C32,1),IF(A33=\"\",LEFT(C32,1),A33))&B33","v":"EJ"},0.5,1,7,"Dog",{"$f":"VLOOKUP(G33,$AD$11:$AE$17,2)","v":6},null,{"$f":"D33*1000*F33","v":3500},{"$f":"IF(M32=0,K32,IF(OR(E33=3,E33=11),Q33,IF(AND(E32=3,E33=1),Q33/SQRT(3),IF(A33=\"\",K32,IF(AND(E32=1,E33=1),N32,K32)))))","v":226.20583546849539},{"$f":"F33*1000/$L$5/K33*(IF(OR(AND(E33=11,E32=11),AND(E33=3,E32=3)),1/SQRT(3),1))","v":38.681583885216121},{"$f":"ROUND(T33*D33*L33*IF(E33=1,2, SQRT(3)),1)","v":16.2},{"$f":"K33-M33","v":210.00583546849541},{"$f":"100*(1-N33/IF(E33=11,$L$6,IF(E33=3,$L$7,$L$8)))","v":8.6931150136976498},{"$f":"IF(OR(AND(E32=1,E33=1,A33<>\"\"),AND(E32=3,E33=1)),O32,0)","v":0},{"$f":"IF(A34=\"\",Q32,IF(OR(AND(E33=11,E32=11),AND(E33=1,E32=1),AND(E32=3,E33=3)),N32-M33,IF(AND(E33=1,E32=3),N32/SQRT(3))))","v":226.20583546849539},{"$f":"CHOOSE(H33,1.347,1.098,0.9116,0.5449,0.3434,0.2745)","v":0.27450000000000002},{"$f":"CHOOSE(H33,0.355,0.349,0.345,0.335,0.328,0.315)","v":0.315},{"$f":"SQRT(S33^2+R33^2)","v":0.41782203149187813},{"$f":"IF(AND(H33=1,UPPER(I33)=\"\"),D33,0)*IF(E33=1,2,3)","v":0},{"$f":"IF(AND(H33=2,UPPER(I33)=\"\"),D33,0)*IF(E33=1,2,3)","v":0},{"$f":"IF(AND(H33=3,UPPER(I33)=\"\"),D33,0)*IF(E33=1,2,3)","v":0},{"$f":"IF(AND(H33=4,UPPER(I33)=\"\"),D33,0)*IF(E33=1,2,3)","v":0},{"$f":"IF(AND(H33=5,UPPER(I33)=\"\"),D33,0)*IF(E33=1,2,3)","v":0},{"$f":"IF(AND(H33=6,UPPER(I33)=\"\"),D33,0)*IF(E33=1,2,3)","v":1}]
[]
["E-H (y)",null,null,null,1,{"$nulls":5},{"$f":"K32","v":226.20583546849539},null,null,{"$f":"K35","v":226.20583546849539},null,null,{"$f":"K35","v":226.20583546849539},null,null,null,{"$f":"IF(AND(H35=1,UPPER(I35=\"\")),D35,0)*IF(E35=1,2,3)","v":0},{"$f":"IF(AND(H35=2,UPPER(I35=\"\")),D35,0)*IF(E35=1,2,3)","v":0},{"$f":"IF(AND(H35=3,UPPER(I35=\"\")),D35,0)*IF(E35=1,2,3)","v":0},{"$f":"IF(AND(H35=4,UPPER(I35=\"\")),D35,0)*IF(E35=1,2,3)","v":0},{"$f":"IF(AND(H35=5,UPPER(I35=\"\")),D35,0)*IF(E35=1,2,3)","v":0},{"$f":"IF(AND(H35=6,UPPER(I35=\"\")),D35,0)*IF(E35=1,2,3)","v":0}]
["E","G",{"$f":"IF(AND(A35=\"\",A36=\"\"),LEFT(C35,1),IF(A36=\"\",LEFT(C35,1),A36))&B36","v":"EG"},0.5,1,7,"Otter",{"$f":"VLOOKUP(G36,$AD$11:$AE$17,2)","v":5},null,{"$f":"D36*1000*F36","v":3500},{"$f":"IF(M35=0,K35,IF(OR(E36=3,E36=11),Q36,IF(AND(E35=3,E36=1),Q36/SQRT(3),IF(A36=\"\",K35,IF(AND(E35=1,E36=1),N35,K35)))))","v":226.20583546849539},{"$f":"F36*1000/$L$5/K36*(IF(OR(AND(E36=11,E35=11),AND(E36=3,E35=3)),1/SQRT(3),1))","v":38.681583885216121},{"$f":"ROUND(T36*D36*L36*IF(E36=1,2, SQRT(3)),1)","v":18.399999999999999},{"$f":"K36-M36","v":207.80583546849539},{"$f":"100*(1-N36/IF(E36=11,$L$6,IF(E36=3,$L$7,$L$8)))","v":9.6496367528280942},{"$f":"IF(OR(AND(E35=1,E36=1,A36<>\"\"),AND(E35=3,E36=1)),O35,0)","v":0},{"$f":"IF(A37=\"\",Q35,IF(OR(AND(E36=11,E35=11),AND(E36=1,E35=1),AND(E35=3,E36=3)),N35-M36,IF(AND(E36=1,E35=3),N35/SQRT(3))))","v":207.80583546849539},{"$f":"CHOOSE(H36,1.347,1.098,0.9116,0.5449,0.3434,0.2745)","v":0.34339999999999998},{"$f":"CHOOSE(H36,0.355,0.349,0.345,0.335,0.328,0.315)","v":0.32800000000000001},{"$f":"SQRT(S36^2+R36^2)","v":0.47487636285669138},{"$f":"IF(AND(H36=1,UPPER(I36)=\"\"),D36,0)*IF(E36=1,2,3)","v":0},{"$f":"IF(AND(H36=2,UPPER(I36)=\"\"),D36,0)*IF(E36=1,2,3)","v":0},{"$f":"IF(AND(H36=3,UPPER(I36)=\"\"),D36,0)*IF(E36=1,2,3)","v":0},{"$f":"IF(AND(H36=4,UPPER(I36)=\"\"),D36,0)*IF(E36=1,2,3)","v":0},{"$f":"IF(AND(H36=5,UPPER(I36)=\"\"),D36,0)*IF(E36=1,2,3)","v":1},{"$f":"IF(AND(H36=6,UPPER(I36)=\"\"),D36,0)*IF(E36=1,2,3)","v":0}]
[{"$f":"B36","v":"G"},"H",{"$f":"IF(AND(A36=\"\",A37=\"\"),LEFT(C36,1),IF(A37=\"\",LEFT(C36,1),A37))&B37","v":"GH"},0.2,1,3,"Dog",{"$f":"VLOOKUP(G37,$AD$11:$AE$17,2)","v":6},null,{"$f":"D37*1000*F37","v":600},{"$f":"IF(M36=0,K36,IF(OR(E37=3,E37=11),Q37,IF(AND(E36=3,E37=1),Q37/SQRT(3),IF(A37=\"\",K36,IF(AND(E36=1,E37=1),N36,K36)))))","v":207.80583546849539},{"$f":"F37*1000/$L$5/K37*(IF(OR(AND(E37=11,E36=11),AND(E37=3,E36=3)),1/SQRT(3),1))","v":18.045691505946774},{"$f":"ROUND(T37*D37*L37*IF(E37=1,2, SQRT(3)),1)","v":3},{"$f":"K37-M37","v":204.80583546849539},{"$f":"100*(1-N37/IF(E37=11,$L$6,IF(E37=3,$L$7,$L$8)))","v":10.953984578915044},{"$f":"IF(OR(AND(E36=1,E37=1,A37<>\"\"),AND(E36=3,E37=1)),O36,0)","v":9.6496367528280942},{"$f":"IF(A38=\"\",Q36,IF(OR(AND(E37=11,E36=11),AND(E37=1,E36=1),AND(E36=3,E37=3)),N36-M37,IF(AND(E37=1,E36=3),N36/SQRT(3))))","v":207.80583546849539},{"$f":"CHOOSE(H37,1.347,1.098,0.9116,0.5449,0.3434,0.2745)","v":0.27450000000000002},{"$f":"CHOOSE(H37,0.355,0.349,0.345,0.335,0.328,0.315)","v":0.315},{"$f":"SQRT(S37^2+R37^2)","v":0.41782203149187813},{"$f":"IF(AND(H37=1,UPPER(I37)=\"\"),D37,0)*IF(E37=1,2,3)","v":0},{"$f":"IF(AND(H37=2,UPPER(I37)=\"\"),D37,0)*IF(E37=1,2,3)","v":0},{"$f":"IF(AND(H37=3,UPPER(I37)=\"\"),D37,0)*IF(E37=1,2,3)","v":0},{"$f":"IF(AND(H37=4,UPPER(I37)=\"\"),D37,0)*IF(E37=1,2,3)","v":0},{"$f":"IF(AND(H37=5,UPPER(I37)=\"\"),D37,0)*IF(E37=1,2,3)","v":0},{"$f":"IF(AND(H37=6,UPPER(I37)=\"\"),D37,0)*IF(E37=1,2,3)","v":0.4}]
[]
["E-M (b)",null,null,null,1,{"$nulls":5},{"$f":"K35","v":226.20583546849539},null,null,{"$f":"K39","v":226.20583546849539},null,null,{"$f":"K39","v":226.20583546849539},null,null,null,{"$f":"IF(AND(H39=1,UPPER(I39=\"\")),D39,0)*IF(E39=1,2,3)","v":0},{"$f":"IF(AND(H39=2,UPPER(I39=\"\")),D39,0)*IF(E39=1,2,3)","v":0},{"$f":"IF(AND(H39=3,UPPER(I39=\"\")),D39,0)*IF(E39=1,2,3)","v":0},{"$f":"IF(AND(H39=4,UPPER(I39=\"\")),D39,0)*IF(E39=1,2,3)","v":0},{"$f":"IF(AND(H39=5,UPPER(I39=\"\")),D39,0)*IF(E39=1,2,3)","v":0},{"$f":"IF(AND(H39=6,UPPER(I39=\"\")),D39,0)*IF(E39=1,2,3)","v":0}]
["E ","K",{"$f":"IF(AND(A39=\"\",A40=\"\"),LEFT(C39,1),IF(A40=\"\",LEFT(C39,1),A40))&B40","v":"E K"},0.5,1,7,"Dog",{"$f":"VLOOKUP(G40,$AD$11:$AE$17,2)","v":6},null,{"$f":"D40*1000*F40","v":3500},{"$f":"IF(M39=0,K39,IF(OR(E40=3,E40=11),Q40,IF(AND(E39=3,E40=1),Q40/SQRT(3),IF(A40=\"\",K39,IF(AND(E39=1,E40=1),N39,K39)))))","v":226.20583546849539},{"$f":"F40*1000/$L$5/K40*(IF(OR(AND(E40=11,E39=11),AND(E40=3,E39=3)),1/SQRT(3),1))","v":38.681583885216121},{"$f":"ROUND(T40*D40*L40*IF(E40=1,2, SQRT(3)),1)","v":16.2},{"$f":"K40-M40","v":210.00583546849541},{"$f":"100*(1-N40/IF(E40=11,$L$6,IF(E40=3,$L$7,$L$8)))","v":8.6931150136976498},{"$f":"IF(OR(AND(E39=1,E40=1,A40<>\"\"),AND(E39=3,E40=1)),O39,0)","v":0},{"$f":"IF(A41=\"\",Q39,IF(OR(AND(E40=11,E39=11),AND(E40=1,E39=1),AND(E39=3,E40=3)),N39-M40,IF(AND(E40=1,E39=3),N39/SQRT(3))))","v":210.00583546849541},{"$f":"CHOOSE(H40,1.347,1.098,0.9116,0.5449,0.3434,0.2745)","v":0.27450000000000002},{"$f":"CHOOSE(H40,0.355,0.349,0.345,0.335,0.328,0.315)","v":0.315},{"$f":"SQRT(S40^2+R40^2)","v":0.41782203149187813},{"$f":"IF(AND(H40=1,UPPER(I40)=\"\"),D40,0)*IF(E40=1,2,3)","v":0},{"$f":"IF(AND(H40=2,UPPER(I40)=\"\"),D40,0)*IF(E40=1,2,3)","v":0},{"$f":"IF(AND(H40=3,UPPER(I40)=\"\"),D40,0)*IF(E40=1,2,3)","v":0},{"$f":"IF(AND(H40=4,UPPER(I40)=\"\"),D40,0)*IF(E40=1,2,3)","v":0},{"$f":"IF(AND(H40=5,UPPER(I40)=\"\"),D40,0)*IF(E40=1,2,3)","v":0},{"$f":"IF(AND(H40=6,UPPER(I40)=\"\"),D40,0)*IF(E40=1,2,3)","v":1}]
[{"$f":"B40","v":"K"},"L",{"$f":"IF(AND(A40=\"\",A41=\"\"),LEFT(C40,1),IF(A41=\"\",LEFT(C40,1),A41))&B41","v":"KL"},0.2,1,3,"Dog",{"$f":"VLOOKUP(G41,$AD$11:$AE$17,2)","v":6},null,{"$f":"D41*1000*F41","v":600},{"$f":"IF(M40=0,K40,IF(OR(E41=3,E41=11),Q41,IF(AND(E40=3,E41=1),Q41/SQRT(3),IF(A41=\"\",K40,IF(AND(E40=1,E41=1),N40,K40)))))","v":210.00583546849541},{"$f":"F41*1000/$L$5/K41*(IF(OR(AND(E41=11,E40=11),AND(E41=3,E40=3)),1/SQRT(3),1))","v":17.856646657623791},{"$f":"ROUND(T41*D41*L41*IF(E41=1,2, SQRT(3)),1)","v":3},{"$f":"K41-M41","v":207.00583546849541},{"$f":"100*(1-N41/IF(E41=11,$L$6,IF(E41=3,$L$7,$L$8)))","v":9.9974628397846104},{"$f":"IF(OR(AND(E40=1,E41=1,A41<>\"\"),AND(E40=3,E41=1)),O40,0)","v":8.6931150136976498},{"$f":"IF(A42=\"\",Q40,IF(OR(AND(E41=11,E40=11),AND(E41=1,E40=1),AND(E40=3,E41=3)),N40-M41,IF(AND(E41=1,E40=3),N40/SQRT(3))))","v":207.00583546849541},{"$f":"CHOOSE(H41,1.347,1.098,0.9116,0.5449,0.3434,0.2745)","v":0.27450000000000002},{"$f":"CHOOSE(H41,0.355,0.349,0.345,0.335,0.328,0.315)","v":0.315},{"$f":"SQRT(S41^2+R41^2)","v":0.41782203149187813},{"$f":"IF(AND(H41=1,UPPER(I41)=\"\"),D41,0)*IF(E41=1,2,3)","v":0},{"$f":"IF(AND(H41=2,UPPER(I41)=\"\"),D41,0)*IF(E41=1,2,3)","v":0},{"$f":"IF(AND(H41=3,UPPER(I41)=\"\"),D41,0)*IF(E41=1,2,3)","v":0},{"$f":"IF(AND(H41=4,UPPER(I41)=\"\"),D41,0)*IF(E41=1,2,3)","v":0},{"$f":"IF(AND(H41=5,UPPER(I41)=\"\"),D41,0)*IF(E41=1,2,3)","v":0},{"$f":"IF(AND(H41=6,UPPER(I41)=\"\"),D41,0)*IF(E41=1,2,3)","v":0.4}]
[{"$f":"B41","v":"L"},"M",{"$f":"IF(AND(A41=\"\",A42=\"\"),LEFT(C41,1),IF(A42=\"\",LEFT(C41,1),A42))&B42","v":"LM"},0.2,1,2,"Dog",{"$f":"VLOOKUP(G42,$AD$11:$AE$17,2)","v":6},null,{"$f":"D42*1000*F42","v":400},{"$f":"IF(M41=0,K41,IF(OR(E42=3,E42=11),Q42,IF(AND(E41=3,E42=1),Q42/SQRT(3),IF(A42=\"\",K41,IF(AND(E41=1,E42=1),N41,K41)))))","v":207.00583546849541},{"$f":"F42*1000/$L$5/K42*(IF(OR(AND(E42=11,E41=11),AND(E42=3,E41=3)),1/SQRT(3),1))","v":12.076954228570429},{"$f":"ROUND(T42*D42*L42*IF(E42=1,2, SQRT(3)),1)","v":2},{"$f":"K42-M42","v":205.00583546849541},{"$f":"100*(1-N42/IF(E42=11,$L$6,IF(E42=3,$L$7,$L$8)))","v":10.86702805717591},{"$f":"IF(OR(AND(E41=1,E42=1,A42<>\"\"),AND(E41=3,E42=1)),O41,0)","v":9.9974628397846104},{"$f":"IF(A43=\"\",Q41,IF(OR(AND(E42=11,E41=11),AND(E42=1,E41=1),AND(E41=3,E42=3)),N41-M42,IF(AND(E42=1,E41=3),N41/SQRT(3))))","v":207.00583546849541},{"$f":"CHOOSE(H42,1.347,1.098,0.9116,0.5449,0.3434,0.2745)","v":0.27450000000000002},{"$f":"CHOOSE(H42,0.355,0.349,0.345,0.335,0.328,0.315)","v":0.315},{"$f":"SQRT(S42^2+R42^2)","v":0.41782203149187813},{"$f":"IF(AND(H42=1,UPPER(I42)=\"\"),D42,0)*IF(E42=1,2,3)","v":0},{"$f":"IF(AND(H42=2,UPPER(I42)=\"\"),D42,0)*IF(E42=1,2,3)","v":0},{"$f":"IF(AND(H42=3,UPPER(I42)=\"\"),D42,0)*IF(E42=1,2,3)","v":0},{"$f":"IF(AND(H42=4,UPPER(I42)=\"\"),D42,0)*IF(E42=1,2,3)","v":0},{"$f":"IF(AND(H42=5,UPPER(I42)=\"\"),D42,0)*IF(E42=1,2,3)","v":0},{"$f":"IF(AND(H42=6,UPPER(I42)=\"\"),D42,0)*IF(E42=1,2,3)","v":0.4}]

{"sheet":"Loads&Benefits","index":17,"n_rows":111,"n_cols":25,"rows_kept":111,"cut":false,"hidden":false,"merged":[[56,6,57,6],[59,0,59,3],[69,0,69,2],[56,2,56,3]]}
["LOADS AND BENEFITS"]
["Small Hydropower Promotion Project (SHPP)/GTZ",{"$nulls":4},"Spreadsheet by Mr Pushpa Chitrakar"]
["Referances: 1,2,3,4, 6,12,13,15,16",{"$nulls":4},"Date",{"$f":"TODAY()","v":"2012-07-20"}]
["SMALL HYDROPOWER PROMOTION PROJECT/GTZ",{"$nulls":4},"Revision","2006.05"]
["Project:   ","Gaddi Gad Khola",null,null,"Location:","Ladagada VDC, Doti"]
["Developer","Gaddi Gad Khola MHP"]
["Consultant","Perinial"]
["Designed","Pushpa Chitrakar"]
["Checked","Pushpa Chitrakar"]
[]
["INPUT"]
["General"]
["Power Output (kW)",96.1,null,null,"Domestic lighting"]
["Name of the Source","Gaddi Gad Khola",null,null,"Average subscription/household (W/HH)",null,null,85]
[{"$nulls":4},"System loss",0.1]
["Beneficiary HH (nos.)",471,null,null,"time",0,5,8,18,20]
["Plant's operating days",330,null,null,"load",88,0,0,91.1,0]
[{"$nulls":5},{"$f":"(G16-F16)*F17","v":440},{"$f":"(H16-G16)*G17","v":0},{"$f":"(I16-H16)*H17","v":0},{"$f":"(J16-I16)*I17","v":182.2}]
["Loads (kWh or W/m)","Operating days/year","Tariff (Rs)",null,"Probable Business Load Expected after 3 years"]
["Domestic",330,1,null,null,"Operating d/y","Tariff (Rs)","Load","From (hr)","To (hr)"]
["Agro-processing ",330,6,null,"Metal Workshop",330,6,10,12,16]
["Bakery",320,6,null,"Photo Studio",320,6,1,8,20]
["Saw Mill",300,5,null,"Dairy Processing",320,6,8,8,18]
["Herbs Processing",180,5.5,null,"Cold Store",310,6,6,8,18]
["Load 5",330,null,null,"Load 5"]
["Load 6",330,null,null,"Load 6"]
[]
["Proposed end uses and operting hours"]
["time (hr)",0,4,12,16,22,null,"Daily Energy Demand (Dd) kWh",{"$f":"SUM(F18:J18)+SUM(G31:G46)","v":1037.2}]
[{"$f":"A21","v":"Agro-processing "},0,0,22.5,0,0,null,"Yearly Energy Demand (Dy) kWh",{"$f":"365*I29","v":378578}]
[null,{"$f":"(C29-B29)*B30","v":0},{"$f":"(D29-C29)*C30","v":0},{"$f":"(E29-D29)*D30","v":90},{"$f":"(F29-E29)*E30","v":0},{"$f":"IF(F29=24,B29,(24-F29)+B29)*F30","v":0},{"$f":"SUM(B31:F31)","v":90}]
["time (hr)",0,8,14,18,22,null,"Average Load Factor",{"$f":"I29/24/(B13*(1-F15))","v":0.49967240914171202}]
[{"$f":"A22","v":"Bakery"},0,9,0,0,0]
[null,{"$f":"(C32-B32)*B33","v":0},{"$f":"(D32-C32)*C33","v":54},{"$f":"(E32-D32)*D33","v":0},{"$f":"(F32-E32)*E33","v":0},{"$f":"IF(F32=24,B32,(24-F32)+B32)*F33","v":0},{"$f":"SUM(B34:F34)","v":54}]
["time (hr)",0,3,16,18,22]
[{"$f":"A23","v":"Saw Mill"},0,0,10,0,0]
[null,{"$f":"(C35-B35)*B36","v":0},{"$f":"(D35-C35)*C36","v":0},{"$f":"(E35-D35)*D36","v":20},{"$f":"(F35-E35)*E36","v":0},{"$f":"IF(F35=24,B35,(24-F35)+B35)*F36","v":0},{"$f":"SUM(B37:F37)","v":20}]
["time (hr)",0,3,12,17,22]
[{"$f":"A24","v":"Herbs Processing"},0,0,25,0,0]
[null,{"$f":"(C38-B38)*B39","v":0},{"$f":"(D38-C38)*C39","v":0},{"$f":"(E38-D38)*D39","v":125},{"$f":"(F38-E38)*E39","v":0},{"$f":"IF(F38=24,B38,(24-F38)+B38)*F39","v":0},{"$f":"SUM(B40:F40)","v":125}]
["time (hr)",0,6,8,15,22]
[{"$f":"A25","v":"Load 5"},15,0,0,0,0]
[null,{"$f":"(C41-B41)*B42","v":90},{"$f":"(D41-C41)*C42","v":0},{"$f":"(E41-D41)*D42","v":0},{"$f":"(F41-E41)*E42","v":0},{"$f":"IF(F41=24,B41,(24-F41)+B41)*F42","v":0},{"$f":"SUM(B43:F43)","v":90}]
["time (hr)",0,3,5,10,22]
[{"$f":"A26","v":"Load 6"},12,0,0,0,0]
[null,{"$f":"(C44-B44)*B45","v":36},{"$f":"(D44-C44)*C45","v":0},{"$f":"(E44-D44)*D45","v":0},{"$f":"(F44-E44)*E45","v":0},{"$f":"IF(F44=24,B44,(24-F44)+B44)*F45","v":0},{"$f":"SUM(B46:F46)","v":36}]
["OUTPUT"]
[]
["Summary"]
["Annual Available kWh",{"$f":"B17*B13*24","v":761111.99999999988}]
[null,null,null,"First 3 years","After 3 years"]
["Yearly end use load (kWh)",null,null,{"$f":"E67","v":117060},{"$f":"D52+0.5*E77","v":147680}]
["Productive end use load factor (%)",null,null,{"$f":"F67","v":15.380128023208151},{"$f":"B78","v":19.403189018173414}]
["Total load plant factor",null,null,{"$f":"F59+F67","v":42.357235203228967},{"$f":"D54+F77","v":50.403357193159493}]
["Annual total (domestic + end uses) Income (Rs)",null,null,{"$f":"G68","v":916050},{"$f":"G68+G77","v":1099770}]
[]
["End Use","Load","Operation Period",null,"Yearly Load",null,"Annual Income (Rs)"]
[null,"(kW)","Hours/day","Days/year","kWh","LF (%)"]
["Domestic Lighting",{"$f":"B16*H14/(1-F15)/1000","v":44.483333333333334},{"$f":"IF(ISERROR(E59/D59/B59),\"-\",E59/D59/B59)","v":13.987261146496817},{"$f":"B20","v":330},{"$f":"((G16-F16)*F17+(H16-G16)*G17+(I16-H16)*H17+(J16-I16)*I17+(24-J16)*J17)*B20","v":205326.00000000003},{"$f":"E59*100/B$50","v":26.97710718002082},{"$f":"H14*B16*C20*12","v":480420}]
["Existing/Committed Business Load"]
[{"$f":"A21","v":"Agro-processing "},{"$f":"MAX(B30:F30)","v":22.5},{"$f":"IF(ISERROR(E61/D61/B61),\"-\",E61/D61/B61)","v":4},{"$f":"B21","v":330},{"$f":"((C29-B29)*B30+(D29-C29)*C30+(E29-D29)*D30+(F29-E29)*E30+(24-F29)*F30)*B21","v":29700},{"$f":"E61*100/$B$50","v":3.902185223725287},{"$f":"E61*C21","v":178200}]
["Bakery",{"$f":"MAX(B33:F33)","v":9},6,320,{"$f":"((C32-B32)*B33+(D32-C32)*C33+(E32-D32)*D33+(F32-E32)*E33+(24-F32)*F33)*B22","v":17280},2.2703623119856213,103680]
["Saw Mill",{"$f":"MAX(B36:F36)","v":10},2,300,{"$f":"((C35-B35)*B36+(D35-C35)*C36+(E35-D35)*D36+(F35-E35)*E36+(24-F35)*F36)*B23","v":6000},0.7883202472172296,30000]
["Herbs Processing",{"$f":"MAX(B39:F39)","v":25},5,180,{"$f":"((C38-B38)*B39+(D38-C38)*C39+(E38-D38)*D39+(F38-E38)*E39+(24-F38)*F39)*B24","v":22500},2.9562009270646112,123750]
["Load 5",{"$f":"MAX(B42:F42)","v":15},6,330,{"$f":"((C41-B41)*B42+(D41-C41)*C42+(E41-D41)*D42+(F41-E41)*E42+(24-F41)*F42)*B25","v":29700},3.902185223725287,0]
["Load 6",{"$f":"MAX(B45:F45)","v":12},3,330,{"$f":"((C44-B44)*B45+(D44-C44)*C45+(E44-D44)*D45+(F44-E44)*E45+(24-F44)*F45)*B26","v":11880},1.5608740894901147,0]
["Total ",null,null,null,{"$f":"SUM(E61:E66)","v":117060},{"$f":"SUM(F61:F66)","v":15.380128023208151},{"$f":"SUM(G61:G66)","v":435630}]
["Total Annual Income from sales of electricity",{"$nulls":5},{"$f":"G59+G67","v":916050}]
[]
["Probable Business Load after 3 years"]
[{"$f":"E21","v":"Metal Workshop"},{"$f":"H21","v":10},{"$f":"J21-I21","v":4},{"$f":"F21","v":330},{"$f":"B71*C71*D71","v":13200},{"$f":"E71*100/B$50","v":1.7343045438779052},{"$f":"G21*E71","v":79200}]
["Photo Studio",1,12,320,3840,0.50452495821902699,23040]
["Dairy Processing",8,10,320,25600,3.3634997214601796,153600]
["Cold Store",6,10,310,18600,2.443792766373412,111600]
["Load 5",0,0,0,0,0,0]
["Load 6",0,0,0,0,0,0]
["Total additional annual income after 3 years",null,null,null,{"$f":"SUM(E71:E76)","v":61240},{"$f":"SUM(F71:F76)","v":8.0461219899305227},{"$f":"0.5*SUM(G71:G76)","v":183720}]
["Productive End Use (%)",{"$f":"F67+(F77*0.5)","v":19.403189018173414}]
[{"$f":"\"Load Duration Chart for the first three years of operation of \"&B5","v":"Load Duration Chart for the first three years of operation of Gaddi Gad Khola"}]
{"$rows_empty":21}
["Graph Data for the first three years"]
["Time",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23]
[{"$f":"A20","v":"Domestic"},{"$f":"HLOOKUP(B102,$F$16:$J$17,2)","v":88},{"$f":"HLOOKUP(C102,$F$16:$J$17,2)","v":88},{"$f":"HLOOKUP(D102,$F$16:$J$17,2)","v":88},88,88,0,0,0,0,0,0,0,0,0,0,0,0,0,91.1,91.1,0,0,0,0]
[{"$f":"A21","v":"Agro-processing "},{"$f":"HLOOKUP(B102,$B$29:$F$30,2)","v":0},0,0,0,0,0,0,0,0,0,0,0,22.5,22.5,22.5,22.5,0,0,0,0,0,0,0,0]
["Bakery",{"$f":"HLOOKUP(B102,$B$32:$F$33,2)","v":0},0,0,0,0,0,0,0,9,9,9,9,9,9,0,0,0,0,0,0,0,0,0,0]
["Saw Mill",{"$f":"HLOOKUP(B102,$B$35:$F$36,2)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10,10,0,0,0,0,0,0]
["Herbs Processing",{"$f":"HLOOKUP(B102,$B$38:$F$39,2)","v":0},0,0,0,0,0,0,0,0,0,0,0,25,25,25,25,25,0,0,0,0,0,0,0]
["Load 5",{"$f":"HLOOKUP(B102,$B$41:$F$42,2)","v":15},15,15,15,15,15,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Load 6",{"$f":"HLOOKUP(B102,$B$44:$F$45,2)","v":12},12,12,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Load",{"$f":"SUM(B103:B109)","v":115},{"$f":"SUM(C103:C109)","v":115},115,103,103,15,0,0,9,9,9,9,56.5,56.5,47.5,47.5,35,10,91.1,91.1,0,0,0,0]
["Installed Capacity",{"$f":"$B$13","v":96.1},96.1,96.1,96.1,96.1,96.1,96.1,96.1,96.1,96.1,96.1,96.1,96.1,96.1,96.1,96.1,96.1,96.1,96.1,96.1,96.1,96.1,96.1,96.1]

{"sheet":"Costing&Financial Analyses","index":18,"n_rows":58,"n_cols":13,"rows_kept":58,"cut":false,"hidden":false,"merged":[[15,0,15,2],[16,0,16,2],[34,4,34,5],[40,4,40,5],[40,6,40,7],[40,0,41,0],[40,1,41,1],[40,2,41,2],[40,3,41,3]]}
["Project Costing and Financial Analyses"]
["Small Hydropower Promotion Project (SHPP)/GTZ",{"$nulls":4},"Spreadsheet by Mr Pushpa Chitrakar"]
["Referances: 1,2,3,4, 6,7,8,12,13",{"$nulls":4},"Date",{"$f":"TODAY()","v":"2012-07-20"}]
["SMALL HYDROPOWER PROMOTION PROJECT/GTZ",{"$nulls":4},"Revision","2006.05"]
["Project",null,{"$f":"Project","v":"Golmagad SHP"},{"$nulls":7},"Walking distance","Subsidy","Ceiling"]
["Developer",null,"Kankaimai Hydropower P Ltd",{"$nulls":7},"less than 2 days walking distance",70000,{"$f":"L6+100000","v":170000}]
["Consultant",null,"EPC Consult",{"$nulls":7},"2-5 days walking distance",78750,{"$f":"L7+100000","v":178750}]
["Designed",null,"Pushpa Chitrakar",{"$nulls":7},"more than 5 days walking distance",91500,{"$f":"L8+100000","v":191500}]
["Checked",null,"Pushpa Chitrakar"]
[]
["INPUT"]
["Project size (kW):",null,{"$f":"'Loads&Benefits'!B13","v":96.1}]
["Total Project Cost (Rs.)",null,{"$f":"SUM(C15:H15)","v":12734865}]
["Subsidy/kW",null,"Total subsidy","Bank loan","Other loan","Cash equity","Kind equity","Others"]
[91500,{"$f":"\"Rs/kW x \"&C12&\" =\"","v":"Rs/kW x 96,1 ="},{"$f":"A15*C12","v":8793150},1890044,null,1200000,851671,0]
["Interest rate i (%)",null,null,0.03]
["Payback  period n (yr)",null,null,7]
["Plant life N (yr)",null,15]
["Discount Rate I (%)",null,0.04]
[{"$nulls":6},"O & M (Rs)",{"$f":"SUM(H21:H26)","v":305004}]
["Investment Cost (Rs)",null,{"$f":"SUM(C22:C26,E22:E26)","v":8516715},null,null,null,"Salary",114000]
["Mechanical components",null,999040,"Installation",232500,null,"Spares",0]
["Electrical component",null,2061717,"Commissioning",0,null,"Maintenance",171000]
["Civil component",null,1363497,"VAT ",623611,null,"Office expenses"]
["Spare parts & tools",null,57550,"Contingencies",0,null,"Miscellaneous",20004]
["Transport.",null,3178800,"Others",null,null,"Others"]
[]
["Cost Summary",{"$nulls":4},"NPV Based on Different Project Costs"]
["Project cost (Rs)",null,null,{"$f":"C13","v":12734865},null,"NPV","Probable Business Load"]
["Annual Operation, Maintenance and other Costs (Rs)",null,null,{"$f":"H20","v":305004},null,null,"Without ","With"]
["Annual Income without probable business loads (Rs) ",null,null,{"$f":"'Loads&Benefits'!D55","v":916050},null,"Total investment cost",{"$f":"NPV($C$19,-$C$21,F44:F58)*(1+$C$19)","v":-3543676.5714140912},{"$f":"NPV($C$19,-$C$21,H44:H58)*(1+$C$19)","v":-2010846.1570006548}]
["Annual Income with probable business loads (Rs) ",null,null,{"$f":"'Loads&Benefits'!E55","v":1099770},null,"Total Inv Cost-Subsidy",{"$f":"NPV($C$19,-$C$21+$C$15,F44:F58)*(1+$C$19)","v":5249473.4285859074},{"$f":"NPV($C$19,-$C$21+$C$15,H44:H58)*(1+$C$19)","v":6782303.8429993475}]
["Annual installment for Bank loan",null,null,{"$f":"IF(D17=0,\"NA\",D15*(D16*(1+D16)^D17)/((1+D16)^D17-1))","v":303364.07087513932},null,"Equity",{"$f":"D35","v":3773038.4285859084},{"$f":"D36","v":5305868.8429993466}]
["Annual installment for other loan",null,null,{"$f":"IF(E17=0,\"NA\",E15*(E16*(1+E16)^E17)/((1+E16)^E17-1))","v":"NA"}]
[{"$f":"\"NPV on equity without probable business load (Rs)\"&IF(NPV($C$19,F43:F58)>0,\"+ve\",\"-ve\")","v":"NPV on equity without probable business load (Rs)+ve"},null,null,{"$f":"NPV($C$19,F43:F58)*(1+$C$19)","v":3773038.4285859084}]
[{"$f":"\"NPV equity with probable business load (Rs)\"&IF(NPV($C$19,H43:H58)>0,\"+ve\",\"-ve\")","v":"NPV equity with probable business load (Rs)+ve"},null,null,{"$f":"NPV($C$19,H43:H58)*(1+$C$19)","v":5305868.8429993466}]
[{"$f":"\"Cost/Kw =>>\"&IF(D37>A15+100000,\"not viable\",\"Ok\")","v":"Cost/Kw =>>Ok"},null,null,{"$f":"C13/C12","v":132516.80541103019}]
["Subsidy/HH",null,null,{"$f":"C15/'Loads&Benefits'!B16","v":18669.108280254775}]
[]
["Annual Cash Flows"]
["Year","Equity","O & M costs","Loan repayment ","Without Probable Business Loads",null,"With Probable Business Loads"]
[{"$nulls":4},"Income","Cash flow","Income","Cash flow"]
[0,{"$f":"F15","v":1200000},null,null,null,{"$f":"E43-C43-D43-B43","v":-1200000},null,{"$f":"G43-C43-D43-B43","v":-1200000}]
[1,null,{"$f":"$D$30","v":305004},{"$f":"IF(A44>$D$17,0,$D$33)","v":303364.07087513932},{"$f":"$D$31","v":916050},307681.92912486068,{"$f":"$D$31","v":916050},307681.92912486068]
[2,null,305004,303364.07087513932,916050,307681.92912486068,{"$f":"$D$31","v":916050},307681.92912486068]
[3,null,305004,303364.07087513932,916050,307681.92912486068,{"$f":"$D$31","v":916050},307681.92912486068]
[4,null,305004,303364.07087513932,916050,307681.92912486068,{"$f":"$D$32","v":1099770},491401.92912486068]
[5,null,305004,303364.07087513932,916050,307681.92912486068,1099770,491401.92912486068]
[6,null,305004,303364.07087513932,916050,307681.92912486068,1099770,491401.92912486068]
[7,null,305004,303364.07087513932,916050,307681.92912486068,1099770,491401.92912486068]
[8,null,305004,0,916050,611046,1099770,794766]
[9,null,305004,0,916050,611046,1099770,794766]
[10,null,305004,0,916050,611046,1099770,794766]
[11,null,305004,0,916050,611046,1099770,794766]
[12,null,305004,0,916050,611046,1099770,794766]
[13,null,305004,0,916050,611046,1099770,794766]
[14,null,305004,0,916050,611046,1099770,794766]
[15,null,305004,0,916050,611046,1099770,794766]

{"sheet":"Utilities","index":19,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Ulitilities and Short Calculations"]
["Small Hydropower Promotion Project (SHPP)/GTZ"]

{"sheet":"CanalDepth","index":20,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Uniform Depth of a \"&IF(B12=0,\"Rectangular\",\"Trapezoidal\")&\" Canal (Y-m)\"","v":"Uniform Depth of a Trapezoidal Canal (Y-m)"},{"$nulls":8},"Side Slope (z)"]
["Small Hydropower Promotion Project (SHPP)/GTZ","Spreadsheet by Mr Pushpa Chitrakar",{"$nulls":7},"Lined/vertical",0]
[{"$f":"Project","v":"Golmagad SHP"},"Date",{"$f":"TODAY()","v":"2012-07-20"},{"$nulls":6},"Unlined fissured/disintegrated rock/tough hardpen cut",0.5]
["Stone masonry canal","Revision","2006.05",{"$nulls":6},"Unlined cemented gravel/stiff clay/ordinary hardpan cut",0.75]
[{"$nulls":9},"Unlined firm/gravelyl/clay/side hill c/s in average loam cut",1]
["Design Discharge (l/s):",1000,{"$nulls":7},"Unlined cuts/fills in average loam or gravelly loam",1.5]
["1/Mannings Coeff (M):",50,{"$nulls":7},"Unlined cuts/fills in loose sandy loam",2]
["1/Canal Slope (S):",300,{"$nulls":7},"Unlined cuts/fills in very sandy soil",3]
["Freeboard, FB (m)",0.2]
["Wall Thickness, t (m)",0.3]
["Width of Canal, b (m):",1]
[null,0.5]
["Top width, T (m)",{"$f":"2*B12*B14+B11","v":{"$error":"#NAME?"}}]
["Uniform Depth (Y-m)",{"$f":"YDEPTH(B6/1000,B7,B8,B11,B12)","v":{"$error":"#NAME?"}}]
[]
[{"$nulls":7},"Present Canal"]
[{"$nulls":7},"Wall"]
[{"$nulls":7},"x","y"]
[{"$nulls":7},{"$f":"0+I21*B12","v":{"$error":"#NAME?"}},0]
[{"$nulls":7},{"$f":"IF(B12<>0,H19+2*B10*1000*TAN((PI()/2-ATAN(B12))/2)+B11*1000,(2*B10+B11)*1000)","v":{"$error":"#NAME?"}},{"$f":"I19","v":0}]
[{"$nulls":7},{"$f":"H20+H19","v":{"$error":"#NAME?"}},{"$f":"IF(B12<>0,(B9+B10+B14),(2*B10+B14+B9))*1000","v":{"$error":"#NAME?"}}]
[{"$nulls":7},{"$f":"H21-B10*1000/COS(ATAN(B12))","v":{"$error":"#NAME?"}},{"$f":"I21","v":{"$error":"#NAME?"}}]
[{"$nulls":7},{"$f":"H22-B12*(B9+B14)*1000","v":{"$error":"#NAME?"}},{"$f":"B10*1000","v":300}]
[{"$nulls":7},{"$f":"H23-B11*1000","v":{"$error":"#NAME?"}},{"$f":"I23","v":300}]
[{"$nulls":7},{"$f":"H24-B12*(B9+B14)*1000","v":{"$error":"#NAME?"}},{"$f":"I22","v":{"$error":"#NAME?"}}]
[{"$nulls":7},{"$f":"IF(B12<>0,H25-B10*1000/COS(ATAN(B12)),H19)","v":{"$error":"#NAME?"}},{"$f":"I25","v":{"$error":"#NAME?"}}]
[{"$nulls":7},{"$f":"IF(B12<>0,H19,H26)","v":{"$error":"#NAME?"}},{"$f":"I19","v":0}]
[{"$nulls":7},{"$f":"\"NWL = \"&ROUND(1000*B14,0)&\" mm & \"&\"T = \"&ROUND(H30-H29,0)&\" mm\"","v":{"$error":"#NAME?"}}]
[{"$nulls":7},{"$f":"H24-B12*B14*1000","v":{"$error":"#NAME?"}},{"$f":"I21-B9*1000","v":{"$error":"#NAME?"}}]
[{"$nulls":7},{"$f":"H23+B12*B14*1000","v":{"$error":"#NAME?"}},{"$f":"I29","v":{"$error":"#NAME?"}}]

{"sheet":"LoanPayment","index":21,"n_rows":12,"n_cols":22,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Payment of a loan",{"$nulls":15},{"$f":"\"Payment Schedule of \"&A3&\" with Loan(\"&ROUND(B7,0)&\")\"&\" & Interest(\"&ROUND(B8,2)&\"%)\"","v":"Payment Schedule of Golmagad SHP with Loan(1800000) & Interest(13%)"}]
["Small Hydropower Promotion Project (SHPP)/GTZ","Spreadsheet by Mr Pushpa Chitrakar",{"$nulls":14},"Month","Pmt No.","Pmt","Principal","Interest","Balance"]
[{"$f":"Project","v":"Golmagad SHP"},"Date",{"$f":"TODAY()","v":"2012-07-20"},{"$nulls":13},{"$f":"DATE($D$8,$D$7,1)","v":"2006-02-01"},1,{"$f":"-PMT($B$8%/$D$6,$B$9,$B$7,0)","v":331721.20049108344},{"$f":"S3-U3","v":97721.200491083437},{"$f":"($B$8%/$D$6)*B7","v":234000},{"$f":"B7-T3","v":1702278.7995089167}]
["Stone masonry canal","Revision","2006.05",{"$nulls":13},{"$f":"DATE(YEAR(Q3)+IF($D$6=1,1,0),MONTH(Q3)+IF($D$6=12,1,IF($D$6=4,4,0)),1)","v":"2007-02-01"},{"$f":"R3+1","v":2},{"$f":"-PMT($B$8%/$D$6,$B$9,$B$7,0)","v":331721.20049108344},{"$f":"S4-U4","v":110424.95655492425},{"$f":"($B$8%/$D$6)*V3","v":221296.24393615918},{"$f":"V3-T4","v":1591853.8429539925}]
[{"$nulls":16},{"$f":"DATE(YEAR(Q4)+IF($D$6=1,1,0),MONTH(Q4)+IF($D$6=12,1,IF($D$6=4,4,0)),1)","v":"2008-02-01"},{"$f":"R4+1","v":3},{"$f":"-PMT($B$8%/$D$6,$B$9,$B$7,0)","v":331721.20049108344},{"$f":"S5-U5","v":124780.2009070644},{"$f":"($B$8%/$D$6)*V4","v":206940.99958401904},{"$f":"V4-T5","v":1467073.6420469282}]
[null,null,"Payback",{"$f":"IF(LEFT(A9,1)=\"M\",12,IF(LEFT(A9,1)=\"Q\",4,1))","v":1},{"$nulls":12},"2009-02-01",4,331721.20049108344,141001.62702498276,190719.57346610067,1326072.0150219453]
["Loan amount (NRs) :",1800000,"Starting Month",2,{"$nulls":12},"2010-02-01",5,331721.20049108344,159331.83853823054,172389.36195285289,1166740.1764837147]
["Interest rate (APR):",13,"Starting Year",2006,{"$nulls":12},"2011-02-01",6,331721.20049108344,180044.97754820052,151676.22294288292,986695.1989355142]
["Yearly payment and No",10,{"$nulls":14},"2012-02-01",7,331721.20049108344,203450.82462946657,128270.37586161685,783244.37430604757]
[{"$nulls":16},"2013-02-01",8,331721.20049108344,229899.43183129723,101821.76865978619,553344.94247475034]
[{"$f":"IF(LEFT(A9,1)=\"M\",\"Monthly \",IF(LEFT(A9,1)=\"Q\",\"Quarterly \",\"Yearly \"))&\"Payment\"","v":"Yearly Payment"},{"$f":"PMT(B8/IF(LEFT(A9,1)=\"M\",12,IF(LEFT(A9,1)=\"Q\",4,1))/100,B9,-B7)","v":331721.20049108344},{"$nulls":14},"2014-02-01",9,331721.20049108344,259786.3579693659,71934.842521717539,293558.58450538444]
[{"$nulls":16},"2015-02-01",10,331721.20049108344,293558.58450538345,38162.61598569998,9.8953023552894592E-10]

{"sheet":"Power","index":22,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Actual vs AEPC Power (Pe-kW)"]
["Small Hydropower Promotion Project (SHPP)/GTZ","Spreadsheet by Mr Pushpa Chitrakar"]
[{"$f":"Project","v":"Golmagad SHP"},"Date",{"$f":"TODAY()","v":"2012-07-20"}]
["Stone masonry canal","Revision","2006.05"]
[]
[]
["Discharge (l/s):",120]
["Cumulative efficiency including head loss (n%)",80]
["Gross Head (H-m)",300]
["Actual Power (Pact-kW)",{"$f":"9.81*B7/1000*B8/100*B9","v":282.52800000000002}]
["Power MGSP-ESAP (Pe-kW)",{"$f":"9.81*B7/1000*0.5*B9","v":176.58}]

{"sheet":"Spillway","index":23,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Spillway Lengths (m)",{"$nulls":7},"Spillway Profiles and Discharge coeff"]
["Small Hydropower Promotion Project (SHPP)/GTZ","Spreadsheet by Mr Pushpa Chitrakar",{"$nulls":6},"Profiles","Coeff"]
[{"$f":"Project","v":"Golmagad SHP"},"Date",{"$f":"TODAY()","v":"2012-07-20"},{"$nulls":5},"Broad; sharp edges",1.5]
["Stone masonry canal","Revision","2006.05",{"$nulls":5},"Broad; round edges",1.6]
[{"$nulls":8},"round overfall",1.9]
[{"$nulls":8},"sharp edged",2.1]
[{"$nulls":8},"rounded",2.2000000000000002]
["Flood discharge (l/s):",2000,{"$nulls":6},"roof-shaped",2.2999999999999998]
["Design discharge (l/s):",500]
["Overtopping height (ho) mm:",300]
["Spillway discharge coeff","1.5"]
["L spillway min for Qf m & full height",{"$f":"B8/1000/B11/(B10/1000)^1.5","v":2.966515327566097E-4}]
["Length of spillway Ls1 for Qf m & half height",{"$f":"(B8-B9)/1000/B11/(B10/1000/2)^1.5","v":6.2929293138474563E-4}]

{"sheet":"ffactor","index":24,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Friction Factor (f) & Net head"]
["Small Hydropower Promotion Project (SHPP)/GTZ","Spreadsheet by Mr Pushpa Chitrakar"]
[{"$f":"Project","v":"Golmagad SHP"},"Date",{"$f":"TODAY()","v":"2012-07-20"}]
["Stone masonry canal","Revision","2006.05"]
[]
[]
[]
[]
["Discharge (m3/s)",0.5,"Flow"]
["Gross head (m)",63,"Velocity, v(m/s)",{"$f":"(B9*4/PI()/(B12/1000)^2)","v":2.5464790894703255}]
["Pipe roughness ks (mm)",0.01,"Reynold's nr, (R )",{"$f":"((B9*4/PI()/(B12/1000)^2)*(B12/1000)/0.00000114)","v":1116876.7936273357}]
["Pipe diameter (mm)",500,"Laminar Flow",{"$f":"64/((B9*4/PI()/(B12/1000)^2)*(B12/1000)/0.00000114)","v":5.7302650001477828E-5}]
["Pipe Length (m)",100,null,{"$f":"-2*LOG((B11/B12)/3.7+2.51/((B9*4/PI()/(B12/1000)^2)*(B12/1000)/0.00000114)*D14)","v":9.169630247249609}]
["Turbulent headloss factor (K)",1.5,null,{"$f":"D13","v":9.169630247249609}]
["Friction factor f",{"$f":"IF(((B9*4/PI()/(B12/1000)^2)*(B12/1000)/0.00000114)<2000,D12,D15)","v":1.1893135109153763E-2},"Transitional  Flow & Turbulent Flow",{"$f":"1/D14^2","v":1.1893135109153763E-2}]
["Headloss hl (m)",{"$f":"B10-B18","v":1.281915044270086}]
["Headloss hl (%)",{"$f":"(B10-B18)/B10*100","v":2.0347857845556918}]
["Net Head (m)",{"$f":"B10-(B15*B13/(B12/1000)+B14)*D10^2/2/9.81","v":61.718084955729914}]

{"sheet":"VDrop","index":25,"n_rows":18,"n_cols":22,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Voltage Drop",{"$nulls":11},"Sizes and designations of ACSR conductors for MHP systems:",{"$nulls":7},"Side Slope"]
["Small Hydropower Promotion Project (SHPP)/GTZ","Spreadsheet by Mr Pushpa Chitrakar",{"$nulls":9},"Type of ACSR","ACSR Code  number","Resistance  Ohm/km","Current rating max Amps","Equivalent Cu area mm2","Inductive Reactance Ohm/km","Sp. Weight (kg/km)","Sp. Cost (Rs/km)",null,"Lined/vertical (z m)",0]
[{"$f":"Project","v":"Golmagad SHP"},"Date",{"$f":"TODAY()","v":"2012-07-20"},{"$nulls":8},"Squirrel",1,1.3740000000000001,76,13,0.35499999999999998,80,13000,null,"Unlined fissured/disintegrated rock/tough hardpen cut (z m)",0.5]
["Stone masonry canal","Revision","2006.05",{"$nulls":8},"Gopher",2,1.0980000000000001,85,16,0.34899999999999998,106,14500,null,"Unlined cemented gravel/stiff clay/ordinary hardpan cut (z m)",0.75]
[{"$nulls":11},"Weasel",3,0.91159999999999997,95,20,0.34499999999999997,128,15500,null,"Unlined firm/gravelyl/clay/side hill c/s in average loam cut (z m)",1]
[{"$nulls":11},"Rabbit",4,0.54490000000000005,135,30,0.33500000000000002,214,25750,null,"Unlined cuts/fills in average loam or gravelly loam (z m)",1.5]
["Reach length, L (km)",1,{"$nulls":9},"Otter",5,0.34339999999999998,185,50,0.32800000000000001,null,null,null,"Unlined cuts/fills in loose sandy loam (z m)",2]
["Voltage at 1st node, V1 (V)",230,{"$nulls":9},"Dog",6,0.27450000000000002,205,65,0.315,394,52000,null,"Unlined cuts/fills in very sandy soil (z m)",3]
["Power, P (kW)",20]
["ASCR type",6]
["Phase at 1st node, f1 (1/3)",1]
["Phase at 2nd node, f2 (1/3)",1]
["Current, I (A)",{"$f":"B9*1000/0.8/B8*(IF(AND(B12=1,B11=1),1,IF(AND(B12=3,B11=3),1/SQRT(3),SQRT(3))))","v":108.69565217391305}]
["Impedence, Z (Ω/km)",{"$f":"SQRT((CHOOSE(B10,1.347,1.098,0.9116,0.5449,0.3434,0.2745))^2+(CHOOSE(B10,0.355,0.349,0.345,0.335,0.328,0.315))^2)","v":0.41782203149187813}]
["Voltage at 2nd node, V2 (V) ",{"$f":"B8/IF(B12=B11,1,SQRT(3))-B17","v":139.16912358872213}]
["Power loss P loss (kW)",{"$f":"IF(AND(B11=3,B12=3),SQRT(3),1)*(B8-B15)/2/1000*B13*0.8","v":3.9491685396207772}]
["Voltage drop, dV (V)",{"$f":"B14*B7*B13*IF(B12=1,2, 1.732)","v":90.830876411277856}]
["% Voltage drop",{"$f":"B14*B7*B13*IF(B11=1,2, 1.732)/B8*100","v":39.491685396207764}]

{"sheet":"References","index":26,"n_rows":37,"n_cols":2,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["List of References"]
["Small Hydropower Promotion Project (SHPP)/GTZ"]
[1,"Mini-Grid Support Programme, Alternative Energy Promotion Centre, Kathmandu, Nepal (2002), Peltric Standards"]
[]
[2,"Mini-Grid Support Programme, Alternative Energy Promotion Centre, Kathmandu, Nepal (2003), Preliminary Feasibility Studies of Prospective Micro-hydro Projects"]
[]
[3,"Mini-Grid Support Programme, Alternative Energy Promotion Centre , Kathmandu, Nepal(2001), Technical Details and Cost Estimate"]
[]
[4,"Mini-Grid Support Programme, Alternative Energy Promotion Centre , Kathmandu, Nepal(2003), Guidelines for Detailed Feasibility Study of Micro-Hydro Projects"]
[]
[5,"European Small Hydropower Association (1998), Layman's Guidebook on How to Develop a Small Hydro Site"]
[]
[6,"BPC Hydroconsult, Intermediate Technology Development Group (ITDG), Kathmandu, Nepal (2002), Civil Works Guidelines for Micro-Hydropower in Nepal."]
[]
[7,"United Nations Industrial Development Organization (UNIDO), Report on Standardiztion of Civil Works for Small Hydropower Plants"]
[]
[8,"GTZ/Department of Energy Development, Energy Division, Papua New Guinea, Micro Hydropower Training Modules (1994), Modules 1-7, 10, 13, 14 & 18B."]
[]
[9,"Americal Society of Civil Engineer (ASCE), Sediment Transportation."]
[]
[10,"KB Raina & SK Bhattacharya, New Age International (P) Ltd (1999), Electrical Design Estimating and Costing."]
[]
[11,"Badri Ram & DN Vishwakarma, Tata McGraw-Hill Publishing Company Limited, New Delhi (1995), Power System Protection and Switchgear."]
[]
[12,"Adam Harvey et.al. (1993), Micro-Hydro Design Manual, A guide to small-scale water power schemes, Intermediate Technology Publications, ISBN 1 85339 103 4. "]
[]
[13,"Allen R. Inversin (1986), Micro-Hydropower Sourcebook, A Practical Guide to Design and Implementation in Developing Countries, NRECA International Foundation, 1800 Massachusetts Avenue N. W., Washington, DC 20036."]
[]
[14,"Helmut Lauterjung/Gangolf Schmidt (1989), Planning of Intake Structures, GATE/GTZ, Vieweg."]
[]
[15,"Methodologies for estimating hydrologic characteristics of ungauged locations in Nepal (1990), HMG of Nepal, Ministry of Water Resources, Water and Energy Commission Secretariat, Department of Hydrology and Meteorology."]
[]
[16,"Design Manuals for Irrigation Projects in Nepal (1990), Planning and Design Strengthening Project (PDSP), His Majesty's Government of Nepal, Ministry of Water Resources, Department of Irrigation.  United Nations Development Programme (NEP/85/013)/World Bank."]
[]
[17,"Salleri Chialsa Small Hydel Project (1983), Technical Report, DEH/SATA, ITECO. "]
[]
[18,"P.N. Khanna (1996), Indian Practical Civil Engineer's Handbook, 15th Edition, Engineer's Publishers, Post Box 725, New Delhi - 110001."]