{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Introduction","PipelineDesign","PipeData","PipeList","User's Guide"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":5,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

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

{"sheet":"PipelineDesign","index":1,"n_rows":209,"n_cols":23,"rows_kept":209,"cut":false,"hidden":false,"merged":[[4,0,4,4]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Friction Loss (ft.) = 10.536 x ( gpm/C ) ^ 1.852 / ( D ^ 4.866 ) L"]
["Desired Maximum Velocity:",null,null,null,5,"FPS",null,null,null,null,null,null,null,null,null,null,null,null,null,"Vel=0.4085*GPM/(ID^2)"]
["Desired Largest Pressure Change at End:",null,null,null,-7,"Feet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of Sections=",null,{"$f":"COUNTA($A$10:$A$209)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Most Loss",null,{"$f":"MIN($T$10:$T$209)","v":-1.5779660196698088E-3}]
["PIPELINE SIZING WORKBOOK Version 2.0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Section",null,{"$f":"VLOOKUP($W$4,$T$10:$V$209,2,FALSE)","v":1}]
["Project:","Perlis Nixon",null,null,"County:","Washington",null,"Designed by:","JCJ",null,"Checked by:",null,null,null,null,null,null,null,null,null,"Pipe",null,{"$f":"VLOOKUP($W$4,$T$10:$V$209,3,FALSE)","v":12}]
["Pipeline location:",null,"Main",null,null,null,null,"Date:","5/13",null,"Date:"]
["Press Change at End=",null,{"$f":"IF(A10<>\"\",VLOOKUP(COUNTA(A10:A209),A10:L209,11),\"\")","v":-0.23669490295047133},"Feet","Ave Press Change= ",null,null,{"$f":"IF(A10<>\"\",(SUM($K$10:$K$209))/(COUNT($A$10:$A$209)),\"\")","v":-0.23669490295047133},"Feet","Travel Time=",{"$f":"IF(A10<>\"\",SUM($W$10:$W$209),\"\")","v":3.0054509770818401},"Minutes"]
["Sec Num","Length (Feet)","Outlet (GPM)","Flow (GPM)","Elev Diff (Feet)","Pipe Type","Nom Size","Pipe ID (Inches)","C","Fr Loss (Feet)","Tot Pr Change (Feet)","Vel (FPS)",null,null,null,"Pipe Type","Nom Size","Pipe ID (Inches)","C","LOSS PER FOOT","SECT NUMBER","PIPE SELECTION","TRAVEL TIME (MIN)"]
[1,150,8.6999999999999993,{"$f":"IF(C10<>\"\",IF(A10<>\"\",SUM(C10:$C$209),\"\"),\"\")","v":8.6999999999999993},0,{"$f":"IF(P10<>0,P10,\"\")","v":"SCH40"},{"$f":"IF(Q10<>0,Q10,\"\")","v":"2"},2.0670000000000002,150,{"$f":"IF(H10<>\"\",IF(I10<>\"\",-10.536*B10*(D10/I10)^1.852/(H10^4.866),\"\"),\"\")","v":-0.23669490295047133},{"$f":"IF(H10<>\"\",J10+E10,\"\")","v":-0.23669490295047133},{"$f":"IF(H10<>\"\",0.4085*D10/(H10^2),\"\")","v":0.83182191926064608},null,null,null,"SCH40","2",2.0670000000000002,150,{"$f":"IF(B10=0,0,J10/B10)","v":-1.5779660196698088E-3},1,12,{"$f":"IF(L10=\"\",0,(B10/L10)/60)","v":3.0054509770818401}]
[null,null,null,{"$f":"IF(C11<>\"\",IF(A11<>\"\",SUM(C11:$C$209),\"\"),\"\")","v":""},null,{"$f":"IF(P11<>0,P11,\"\")","v":""},"","","",{"$f":"IF(H11<>\"\",IF(I11<>\"\",-10.536*B11*(D11/I11)^1.852/(H11^4.866),\"\"),\"\")","v":""},{"$f":"IF(H11<>\"\",K10+J11+E11,\"\")","v":""},{"$f":"IF(H11<>\"\",0.4085*D11/(H11^2),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(B11=0,0,J11/B11)","v":0},2,12,{"$f":"IF(L11=\"\",0,(B11/L11)/60)","v":0}]
[null,null,null,{"$f":"IF(C12<>\"\",IF(A12<>\"\",SUM(C12:$C$209),\"\"),\"\")","v":""},null,"","","","","",{"$f":"IF(H12<>\"\",K11+J12+E12,\"\")","v":""},{"$f":"IF(H12<>\"\",0.4085*D12/(H12^2),\"\")","v":""},null,null,null,null,null,null,null,0,3,12,0]
[null,null,null,{"$f":"IF(C13<>\"\",IF(A13<>\"\",SUM(C13:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,4,11,0]
[null,null,null,{"$f":"IF(C14<>\"\",IF(A14<>\"\",SUM(C14:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,5,11,0]
[null,null,null,{"$f":"IF(C15<>\"\",IF(A15<>\"\",SUM(C15:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null," ",null,null,null,null,null,0,6,10,0]
[null,null,null,{"$f":"IF(C16<>\"\",IF(A16<>\"\",SUM(C16:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,7,null,0]
[null,null,null,{"$f":"IF(C17<>\"\",IF(A17<>\"\",SUM(C17:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null," ",null,null,null,null,null,0,8,null,0]
[null,null,null,{"$f":"IF(C18<>\"\",IF(A18<>\"\",SUM(C18:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,9,null,0]
[null,null,null,{"$f":"IF(C19<>\"\",IF(A19<>\"\",SUM(C19:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,10,null,0]
[null,null,null,{"$f":"IF(C20<>\"\",IF(A20<>\"\",SUM(C20:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,11,null,0]
[null,null,null,{"$f":"IF(C21<>\"\",IF(A21<>\"\",SUM(C21:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,12,null,0]
[null,null,null,{"$f":"IF(C22<>\"\",IF(A22<>\"\",SUM(C22:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,13,null,0]
[null,null,null,{"$f":"IF(C23<>\"\",IF(A23<>\"\",SUM(C23:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,14,null,0]
[null,null,null,{"$f":"IF(C24<>\"\",IF(A24<>\"\",SUM(C24:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,15,null,0]
[null,null,null,{"$f":"IF(C25<>\"\",IF(A25<>\"\",SUM(C25:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,16,null,0]
[null,null,null,{"$f":"IF(C26<>\"\",IF(A26<>\"\",SUM(C26:$C$209),\"\"),\"\")","v":""},null,"",{"$f":"IF(Q26<>0,Q26,\"\")","v":""},{"$f":"IF(R26<>0,R26,\"\")","v":""},{"$f":"IF(S26<>0,S26,\"\")","v":""},"","","",null,null,null,null,null,null,null,0,17,null,0]
[null,null,null,{"$f":"IF(C27<>\"\",IF(A27<>\"\",SUM(C27:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,18,null,0]
[null,null,null,{"$f":"IF(C28<>\"\",IF(A28<>\"\",SUM(C28:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,19,null,0]
[null,null,null,{"$f":"IF(C29<>\"\",IF(A29<>\"\",SUM(C29:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,20,null,0]
[null,null,null,{"$f":"IF(C30<>\"\",IF(A30<>\"\",SUM(C30:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,21,null,0]
[null,null,null,{"$f":"IF(C31<>\"\",IF(A31<>\"\",SUM(C31:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,22,null,0]
[null,null,null,{"$f":"IF(C32<>\"\",IF(A32<>\"\",SUM(C32:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,23,null,0]
[null,null,null,{"$f":"IF(C33<>\"\",IF(A33<>\"\",SUM(C33:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,24,null,0]
[null,null,null,{"$f":"IF(C34<>\"\",IF(A34<>\"\",SUM(C34:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,25,null,0]
[null,null,null,{"$f":"IF(C35<>\"\",IF(A35<>\"\",SUM(C35:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,26,null,0]
[null,null,null,{"$f":"IF(C36<>\"\",IF(A36<>\"\",SUM(C36:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,27,null,0]
[null,null,null,{"$f":"IF(C37<>\"\",IF(A37<>\"\",SUM(C37:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,28,null,0]
[null,null,null,{"$f":"IF(C38<>\"\",IF(A38<>\"\",SUM(C38:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,29,null,0]
[null,null,null,{"$f":"IF(C39<>\"\",IF(A39<>\"\",SUM(C39:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,30,null,0]
[null,null,null,{"$f":"IF(C40<>\"\",IF(A40<>\"\",SUM(C40:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,31,null,0]
[null,null,null,{"$f":"IF(C41<>\"\",IF(A41<>\"\",SUM(C41:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,32,null,0]
[null,null,null,{"$f":"IF(C42<>\"\",IF(A42<>\"\",SUM(C42:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,33,null,0]
[null,null,null,{"$f":"IF(C43<>\"\",IF(A43<>\"\",SUM(C43:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,34,null,0]
[null,null,null,{"$f":"IF(C44<>\"\",IF(A44<>\"\",SUM(C44:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,35,null,0]
[null,null,null,{"$f":"IF(C45<>\"\",IF(A45<>\"\",SUM(C45:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,36,null,0]
[null,null,null,{"$f":"IF(C46<>\"\",IF(A46<>\"\",SUM(C46:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,37,null,0]
[null,null,null,{"$f":"IF(C47<>\"\",IF(A47<>\"\",SUM(C47:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,38,null,0]
[null,null,null,{"$f":"IF(C48<>\"\",IF(A48<>\"\",SUM(C48:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,39,null,0]
[null,null,null,{"$f":"IF(C49<>\"\",IF(A49<>\"\",SUM(C49:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,40,null,0]
[null,null,null,{"$f":"IF(C50<>\"\",IF(A50<>\"\",SUM(C50:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,41,null,0]
[null,null,null,{"$f":"IF(C51<>\"\",IF(A51<>\"\",SUM(C51:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,42,null,0]
[null,null,null,{"$f":"IF(C52<>\"\",IF(A52<>\"\",SUM(C52:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,43,null,0]
[null,null,null,{"$f":"IF(C53<>\"\",IF(A53<>\"\",SUM(C53:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,44,null,0]
[null,null,null,{"$f":"IF(C54<>\"\",IF(A54<>\"\",SUM(C54:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,45,null,0]
[null,null,null,{"$f":"IF(C55<>\"\",IF(A55<>\"\",SUM(C55:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,46,null,0]
[null,null,null,{"$f":"IF(C56<>\"\",IF(A56<>\"\",SUM(C56:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,47,null,0]
[null,null,null,{"$f":"IF(C57<>\"\",IF(A57<>\"\",SUM(C57:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,48,null,0]
[null,null,null,{"$f":"IF(C58<>\"\",IF(A58<>\"\",SUM(C58:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,49,null,0]
[null,null,null,{"$f":"IF(C59<>\"\",IF(A59<>\"\",SUM(C59:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,50,null,0]
[null,null,null,{"$f":"IF(C60<>\"\",IF(A60<>\"\",SUM(C60:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,51,null,0]
[null,null,null,{"$f":"IF(C61<>\"\",IF(A61<>\"\",SUM(C61:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,52,null,0]
[null,null,null,{"$f":"IF(C62<>\"\",IF(A62<>\"\",SUM(C62:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,53,null,0]
[null,null,null,{"$f":"IF(C63<>\"\",IF(A63<>\"\",SUM(C63:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,54,null,0]
[null,null,null,{"$f":"IF(C64<>\"\",IF(A64<>\"\",SUM(C64:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,55,null,0]
[null,null,null,{"$f":"IF(C65<>\"\",IF(A65<>\"\",SUM(C65:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,56,null,0]
[null,null,null,{"$f":"IF(C66<>\"\",IF(A66<>\"\",SUM(C66:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,57,null,0]
[null,null,null,{"$f":"IF(C67<>\"\",IF(A67<>\"\",SUM(C67:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,58,null,0]
[null,null,null,{"$f":"IF(C68<>\"\",IF(A68<>\"\",SUM(C68:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,59,null,0]
[null,null,null,{"$f":"IF(C69<>\"\",IF(A69<>\"\",SUM(C69:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,60,null,0]
[null,null,null,{"$f":"IF(C70<>\"\",IF(A70<>\"\",SUM(C70:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,61,null,0]
[null,null,null,{"$f":"IF(C71<>\"\",IF(A71<>\"\",SUM(C71:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,62,null,0]
[null,null,null,{"$f":"IF(C72<>\"\",IF(A72<>\"\",SUM(C72:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,63,null,0]
[null,null,null,{"$f":"IF(C73<>\"\",IF(A73<>\"\",SUM(C73:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,64,null,0]
[null,null,null,{"$f":"IF(C74<>\"\",IF(A74<>\"\",SUM(C74:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,65,null,0]
[null,null,null,{"$f":"IF(C75<>\"\",IF(A75<>\"\",SUM(C75:$C$209),\"\"),\"\")","v":""},null,{"$f":"IF(P75<>0,P75,\"\")","v":""},"","","",{"$f":"IF(H75<>\"\",IF(I75<>\"\",-10.536*B75*(D75/I75)^1.852/(H75^4.866),\"\"),\"\")","v":""},"","",null,null,null,null,null,null,null,{"$f":"IF(B75=0,0,J75/B75)","v":0},66,null,{"$f":"IF(L75=\"\",0,(B75/L75)/60)","v":0}]
[null,null,null,{"$f":"IF(C76<>\"\",IF(A76<>\"\",SUM(C76:$C$209),\"\"),\"\")","v":""},null,"","","","","",{"$f":"IF(H76<>\"\",K75+J76+E76,\"\")","v":""},{"$f":"IF(H76<>\"\",0.4085*D76/(H76^2),\"\")","v":""},null,null,null,null,null,null,null,0,67,null,0]
[null,null,null,{"$f":"IF(C77<>\"\",IF(A77<>\"\",SUM(C77:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,68,null,0]
[null,null,null,{"$f":"IF(C78<>\"\",IF(A78<>\"\",SUM(C78:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,69,null,0]
[null,null,null,{"$f":"IF(C79<>\"\",IF(A79<>\"\",SUM(C79:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,70,null,0]
[null,null,null,{"$f":"IF(C80<>\"\",IF(A80<>\"\",SUM(C80:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,71,null,0]
[null,null,null,{"$f":"IF(C81<>\"\",IF(A81<>\"\",SUM(C81:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,72,null,0]
[null,null,null,{"$f":"IF(C82<>\"\",IF(A82<>\"\",SUM(C82:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,73,null,0]
[null,null,null,{"$f":"IF(C83<>\"\",IF(A83<>\"\",SUM(C83:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,74,null,0]
[null,null,null,{"$f":"IF(C84<>\"\",IF(A84<>\"\",SUM(C84:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,75,null,0]
[null,null,null,{"$f":"IF(C85<>\"\",IF(A85<>\"\",SUM(C85:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,76,null,0]
[null,null,null,{"$f":"IF(C86<>\"\",IF(A86<>\"\",SUM(C86:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,77,null,0]
[null,null,null,{"$f":"IF(C87<>\"\",IF(A87<>\"\",SUM(C87:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,78,null,0]
[null,null,null,{"$f":"IF(C88<>\"\",IF(A88<>\"\",SUM(C88:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,79,null,0]
[null,null,null,{"$f":"IF(C89<>\"\",IF(A89<>\"\",SUM(C89:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,80,null,0]
[null,null,null,{"$f":"IF(C90<>\"\",IF(A90<>\"\",SUM(C90:$C$209),\"\"),\"\")","v":""},null,"",{"$f":"IF(Q90<>0,Q90,\"\")","v":""},{"$f":"IF(R90<>0,R90,\"\")","v":""},{"$f":"IF(S90<>0,S90,\"\")","v":""},"","","",null,null,null,null,null,null,null,0,81,null,0]
[null,null,null,{"$f":"IF(C91<>\"\",IF(A91<>\"\",SUM(C91:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,82,null,0]
[null,null,null,{"$f":"IF(C92<>\"\",IF(A92<>\"\",SUM(C92:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,83,null,0]
[null,null,null,{"$f":"IF(C93<>\"\",IF(A93<>\"\",SUM(C93:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,84,null,0]
[null,null,null,{"$f":"IF(C94<>\"\",IF(A94<>\"\",SUM(C94:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,85,null,0]
[null,null,null,{"$f":"IF(C95<>\"\",IF(A95<>\"\",SUM(C95:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,86,null,0]
[null,null,null,{"$f":"IF(C96<>\"\",IF(A96<>\"\",SUM(C96:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,87,null,0]
[null,null,null,{"$f":"IF(C97<>\"\",IF(A97<>\"\",SUM(C97:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,88,null,0]
[null,null,null,{"$f":"IF(C98<>\"\",IF(A98<>\"\",SUM(C98:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,89,null,0]
[null,null,null,{"$f":"IF(C99<>\"\",IF(A99<>\"\",SUM(C99:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,90,null,0]
[null,null,null,{"$f":"IF(C100<>\"\",IF(A100<>\"\",SUM(C100:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,91,null,0]
[null,null,null,{"$f":"IF(C101<>\"\",IF(A101<>\"\",SUM(C101:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,92,null,0]
[null,null,null,{"$f":"IF(C102<>\"\",IF(A102<>\"\",SUM(C102:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,93,null,0]
[null,null,null,{"$f":"IF(C103<>\"\",IF(A103<>\"\",SUM(C103:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,94,null,0]
[null,null,null,{"$f":"IF(C104<>\"\",IF(A104<>\"\",SUM(C104:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,95,null,0]
[null,null,null,{"$f":"IF(C105<>\"\",IF(A105<>\"\",SUM(C105:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,96,null,0]
[null,null,null,{"$f":"IF(C106<>\"\",IF(A106<>\"\",SUM(C106:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,97,null,0]
[null,null,null,{"$f":"IF(C107<>\"\",IF(A107<>\"\",SUM(C107:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,98,null,0]
[null,null,null,{"$f":"IF(C108<>\"\",IF(A108<>\"\",SUM(C108:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,99,null,0]
[null,null,null,{"$f":"IF(C109<>\"\",IF(A109<>\"\",SUM(C109:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,100,null,0]
[null,null,null,{"$f":"IF(C110<>\"\",IF(A110<>\"\",SUM(C110:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,101,null,0]
[null,null,null,{"$f":"IF(C111<>\"\",IF(A111<>\"\",SUM(C111:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,102,null,0]
[null,null,null,{"$f":"IF(C112<>\"\",IF(A112<>\"\",SUM(C112:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,103,null,0]
[null,null,null,{"$f":"IF(C113<>\"\",IF(A113<>\"\",SUM(C113:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,104,null,0]
[null,null,null,{"$f":"IF(C114<>\"\",IF(A114<>\"\",SUM(C114:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,105,null,0]
[null,null,null,{"$f":"IF(C115<>\"\",IF(A115<>\"\",SUM(C115:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,106,null,0]
[null,null,null,{"$f":"IF(C116<>\"\",IF(A116<>\"\",SUM(C116:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,107,null,0]
[null,null,null,{"$f":"IF(C117<>\"\",IF(A117<>\"\",SUM(C117:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,108,null,0]
[null,null,null,{"$f":"IF(C118<>\"\",IF(A118<>\"\",SUM(C118:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,109,null,0]
[null,null,null,{"$f":"IF(C119<>\"\",IF(A119<>\"\",SUM(C119:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,110,null,0]
[null,null,null,{"$f":"IF(C120<>\"\",IF(A120<>\"\",SUM(C120:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,111,null,0]
[null,null,null,{"$f":"IF(C121<>\"\",IF(A121<>\"\",SUM(C121:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,112,null,0]
[null,null,null,{"$f":"IF(C122<>\"\",IF(A122<>\"\",SUM(C122:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,113,null,0]
[null,null,null,{"$f":"IF(C123<>\"\",IF(A123<>\"\",SUM(C123:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,114,null,0]
[null,null,null,{"$f":"IF(C124<>\"\",IF(A124<>\"\",SUM(C124:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,115,null,0]
[null,null,null,{"$f":"IF(C125<>\"\",IF(A125<>\"\",SUM(C125:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,116,null,0]
[null,null,null,{"$f":"IF(C126<>\"\",IF(A126<>\"\",SUM(C126:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,117,null,0]
[null,null,null,{"$f":"IF(C127<>\"\",IF(A127<>\"\",SUM(C127:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,118,null,0]
[null,null,null,{"$f":"IF(C128<>\"\",IF(A128<>\"\",SUM(C128:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,119,null,0]
[null,null,null,{"$f":"IF(C129<>\"\",IF(A129<>\"\",SUM(C129:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,120,null,0]
[null,null,null,{"$f":"IF(C130<>\"\",IF(A130<>\"\",SUM(C130:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,121,null,0]
[null,null,null,{"$f":"IF(C131<>\"\",IF(A131<>\"\",SUM(C131:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,122,null,0]
[null,null,null,{"$f":"IF(C132<>\"\",IF(A132<>\"\",SUM(C132:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,123,null,0]
[null,null,null,{"$f":"IF(C133<>\"\",IF(A133<>\"\",SUM(C133:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,124,null,0]
[null,null,null,{"$f":"IF(C134<>\"\",IF(A134<>\"\",SUM(C134:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,125,null,0]
[null,null,null,{"$f":"IF(C135<>\"\",IF(A135<>\"\",SUM(C135:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,126,null,0]
[null,null,null,{"$f":"IF(C136<>\"\",IF(A136<>\"\",SUM(C136:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,127,null,0]
[null,null,null,{"$f":"IF(C137<>\"\",IF(A137<>\"\",SUM(C137:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,128,null,0]
[null,null,null,{"$f":"IF(C138<>\"\",IF(A138<>\"\",SUM(C138:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,129,null,0]
[null,null,null,{"$f":"IF(C139<>\"\",IF(A139<>\"\",SUM(C139:$C$209),\"\"),\"\")","v":""},null,{"$f":"IF(P139<>0,P139,\"\")","v":""},"","","",{"$f":"IF(H139<>\"\",IF(I139<>\"\",-10.536*B139*(D139/I139)^1.852/(H139^4.866),\"\"),\"\")","v":""},"","",null,null,null,null,null,null,null,{"$f":"IF(B139=0,0,J139/B139)","v":0},130,null,{"$f":"IF(L139=\"\",0,(B139/L139)/60)","v":0}]
[null,null,null,{"$f":"IF(C140<>\"\",IF(A140<>\"\",SUM(C140:$C$209),\"\"),\"\")","v":""},null,"","","","","",{"$f":"IF(H140<>\"\",K139+J140+E140,\"\")","v":""},{"$f":"IF(H140<>\"\",0.4085*D140/(H140^2),\"\")","v":""},null,null,null,null,null,null,null,0,131,null,0]
[null,null,null,{"$f":"IF(C141<>\"\",IF(A141<>\"\",SUM(C141:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,132,null,0]
[null,null,null,{"$f":"IF(C142<>\"\",IF(A142<>\"\",SUM(C142:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,133,null,0]
[null,null,null,{"$f":"IF(C143<>\"\",IF(A143<>\"\",SUM(C143:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,134,null,0]
[null,null,null,{"$f":"IF(C144<>\"\",IF(A144<>\"\",SUM(C144:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,135,null,0]
[null,null,null,{"$f":"IF(C145<>\"\",IF(A145<>\"\",SUM(C145:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,136,null,0]
[null,null,null,{"$f":"IF(C146<>\"\",IF(A146<>\"\",SUM(C146:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,137,null,0]
[null,null,null,{"$f":"IF(C147<>\"\",IF(A147<>\"\",SUM(C147:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,138,null,0]
[null,null,null,{"$f":"IF(C148<>\"\",IF(A148<>\"\",SUM(C148:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,139,null,0]
[null,null,null,{"$f":"IF(C149<>\"\",IF(A149<>\"\",SUM(C149:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,140,null,0]
[null,null,null,{"$f":"IF(C150<>\"\",IF(A150<>\"\",SUM(C150:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,141,null,0]
[null,null,null,{"$f":"IF(C151<>\"\",IF(A151<>\"\",SUM(C151:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,142,null,0]
[null,null,null,{"$f":"IF(C152<>\"\",IF(A152<>\"\",SUM(C152:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,143,null,0]
[null,null,null,{"$f":"IF(C153<>\"\",IF(A153<>\"\",SUM(C153:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,144,null,0]
[null,null,null,{"$f":"IF(C154<>\"\",IF(A154<>\"\",SUM(C154:$C$209),\"\"),\"\")","v":""},null,"",{"$f":"IF(Q154<>0,Q154,\"\")","v":""},{"$f":"IF(R154<>0,R154,\"\")","v":""},{"$f":"IF(S154<>0,S154,\"\")","v":""},"","","",null,null,null,null,null,null,null,0,145,null,0]
[null,null,null,{"$f":"IF(C155<>\"\",IF(A155<>\"\",SUM(C155:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,146,null,0]
[null,null,null,{"$f":"IF(C156<>\"\",IF(A156<>\"\",SUM(C156:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,147,null,0]
[null,null,null,{"$f":"IF(C157<>\"\",IF(A157<>\"\",SUM(C157:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,148,null,0]
[null,null,null,{"$f":"IF(C158<>\"\",IF(A158<>\"\",SUM(C158:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,149,null,0]
[null,null,null,{"$f":"IF(C159<>\"\",IF(A159<>\"\",SUM(C159:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,150,null,0]
[null,null,null,{"$f":"IF(C160<>\"\",IF(A160<>\"\",SUM(C160:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,151,null,0]
[null,null,null,{"$f":"IF(C161<>\"\",IF(A161<>\"\",SUM(C161:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,152,null,0]
[null,null,null,{"$f":"IF(C162<>\"\",IF(A162<>\"\",SUM(C162:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,153,null,0]
[null,null,null,{"$f":"IF(C163<>\"\",IF(A163<>\"\",SUM(C163:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,154,null,0]
[null,null,null,{"$f":"IF(C164<>\"\",IF(A164<>\"\",SUM(C164:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,155,null,0]
[null,null,null,{"$f":"IF(C165<>\"\",IF(A165<>\"\",SUM(C165:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,156,null,0]
[null,null,null,{"$f":"IF(C166<>\"\",IF(A166<>\"\",SUM(C166:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,157,null,0]
[null,null,null,{"$f":"IF(C167<>\"\",IF(A167<>\"\",SUM(C167:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,158,null,0]
[null,null,null,{"$f":"IF(C168<>\"\",IF(A168<>\"\",SUM(C168:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,159,null,0]
[null,null,null,{"$f":"IF(C169<>\"\",IF(A169<>\"\",SUM(C169:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,160,null,0]
[null,null,null,{"$f":"IF(C170<>\"\",IF(A170<>\"\",SUM(C170:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,161,null,0]
[null,null,null,{"$f":"IF(C171<>\"\",IF(A171<>\"\",SUM(C171:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,162,null,0]
[null,null,null,{"$f":"IF(C172<>\"\",IF(A172<>\"\",SUM(C172:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,163,null,0]
[null,null,null,{"$f":"IF(C173<>\"\",IF(A173<>\"\",SUM(C173:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,164,null,0]
[null,null,null,{"$f":"IF(C174<>\"\",IF(A174<>\"\",SUM(C174:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,165,null,0]
[null,null,null,{"$f":"IF(C175<>\"\",IF(A175<>\"\",SUM(C175:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,166,null,0]
[null,null,null,{"$f":"IF(C176<>\"\",IF(A176<>\"\",SUM(C176:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,167,null,0]
[null,null,null,{"$f":"IF(C177<>\"\",IF(A177<>\"\",SUM(C177:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,168,null,0]
[null,null,null,{"$f":"IF(C178<>\"\",IF(A178<>\"\",SUM(C178:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,169,null,0]
[null,null,null,{"$f":"IF(C179<>\"\",IF(A179<>\"\",SUM(C179:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,170,null,0]
[null,null,null,{"$f":"IF(C180<>\"\",IF(A180<>\"\",SUM(C180:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,171,null,0]
[null,null,null,{"$f":"IF(C181<>\"\",IF(A181<>\"\",SUM(C181:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,172,null,0]
[null,null,null,{"$f":"IF(C182<>\"\",IF(A182<>\"\",SUM(C182:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,173,null,0]
[null,null,null,{"$f":"IF(C183<>\"\",IF(A183<>\"\",SUM(C183:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,174,null,0]
[null,null,null,{"$f":"IF(C184<>\"\",IF(A184<>\"\",SUM(C184:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,175,null,0]
[null,null,null,{"$f":"IF(C185<>\"\",IF(A185<>\"\",SUM(C185:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,176,null,0]
[null,null,null,{"$f":"IF(C186<>\"\",IF(A186<>\"\",SUM(C186:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,177,null,0]
[null,null,null,{"$f":"IF(C187<>\"\",IF(A187<>\"\",SUM(C187:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,178,null,0]
[null,null,null,{"$f":"IF(C188<>\"\",IF(A188<>\"\",SUM(C188:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,179,null,0]
[null,null,null,{"$f":"IF(C189<>\"\",IF(A189<>\"\",SUM(C189:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,180,null,0]
[null,null,null,{"$f":"IF(C190<>\"\",IF(A190<>\"\",SUM(C190:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,181,null,0]
[null,null,null,{"$f":"IF(C191<>\"\",IF(A191<>\"\",SUM(C191:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,182,null,0]
[null,null,null,{"$f":"IF(C192<>\"\",IF(A192<>\"\",SUM(C192:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,183,null,0]
[null,null,null,{"$f":"IF(C193<>\"\",IF(A193<>\"\",SUM(C193:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,184,null,0]
[null,null,null,{"$f":"IF(C194<>\"\",IF(A194<>\"\",SUM(C194:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,185,null,0]
[null,null,null,{"$f":"IF(C195<>\"\",IF(A195<>\"\",SUM(C195:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,186,null,0]
[null,null,null,{"$f":"IF(C196<>\"\",IF(A196<>\"\",SUM(C196:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,187,null,0]
[null,null,null,{"$f":"IF(C197<>\"\",IF(A197<>\"\",SUM(C197:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,188,null,0]
[null,null,null,{"$f":"IF(C198<>\"\",IF(A198<>\"\",SUM(C198:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,189,null,0]
[null,null,null,{"$f":"IF(C199<>\"\",IF(A199<>\"\",SUM(C199:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,190,null,0]
[null,null,null,{"$f":"IF(C200<>\"\",IF(A200<>\"\",SUM(C200:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,191,null,0]
[null,null,null,{"$f":"IF(C201<>\"\",IF(A201<>\"\",SUM(C201:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,192,null,0]
[null,null,null,{"$f":"IF(C202<>\"\",IF(A202<>\"\",SUM(C202:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,193,null,0]
[null,null,null,{"$f":"IF(C203<>\"\",IF(A203<>\"\",SUM(C203:$C$209),\"\"),\"\")","v":""},null,{"$f":"IF(P203<>0,P203,\"\")","v":""},"","","",{"$f":"IF(H203<>\"\",IF(I203<>\"\",-10.536*B203*(D203/I203)^1.852/(H203^4.866),\"\"),\"\")","v":""},"","",null,null,null,null,null,null,null,{"$f":"IF(B203=0,0,J203/B203)","v":0},194,null,{"$f":"IF(L203=\"\",0,(B203/L203)/60)","v":0}]
[null,null,null,{"$f":"IF(C204<>\"\",IF(A204<>\"\",SUM(C204:$C$209),\"\"),\"\")","v":""},null,"","","","","",{"$f":"IF(H204<>\"\",K203+J204+E204,\"\")","v":""},{"$f":"IF(H204<>\"\",0.4085*D204/(H204^2),\"\")","v":""},null,null,null,null,null,null,null,0,195,null,0]
[null,null,null,{"$f":"IF(C205<>\"\",IF(A205<>\"\",SUM(C205:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,196,null,0]
[null,null,null,{"$f":"IF(C206<>\"\",IF(A206<>\"\",SUM(C206:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,197,null,0]
[null,null,null,{"$f":"IF(C207<>\"\",IF(A207<>\"\",SUM(C207:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,198,null,0]
[null,null,null,{"$f":"IF(C208<>\"\",IF(A208<>\"\",SUM(C208:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,199,null,0]
[null,null,null,{"$f":"IF(C209<>\"\",IF(A209<>\"\",SUM(C209:$C$209),\"\"),\"\")","v":""},null,"","","","","","","",null,null,null,null,null,null,null,0,200,null,0]

{"sheet":"PipeData","index":2,"n_rows":29,"n_cols":23,"rows_kept":29,"cut":false,"hidden":false,"merged":[[6,8,6,10],[6,14,6,16],[6,20,6,22],[6,2,6,4]]}
[]
[]
[]
[]
[null,"Pipeline Design Data"]
[]
[null,"Table 1.",null,null,null,null,null,"Table 2.",null,null,null,null,null,"Table 3.",null,null,null,null,null,"Table 4."]
[]
[null,"Pipe Type"," Nominal Size","ID (Inches)"," C",null,null,"Pipe Type"," Nominal Size","ID (Inches)"," C",null,null,"Pipe Type"," Nominal Size","ID (Inches)"," C",null,null,"Pipe Type"," Nominal Size","ID (Inches)"," C"]
[null,"SDR32.5",1,1.2110000000000001,150,null,null,"SDR32.5",1,1.2110000000000001,150,null,null,"SDR32.5","2 1/2",2.6989999999999998,150,null,null,"SDR15","1/2",0.622,140]
[null,"SDR32.5","1 1/2",1.784,150,null,null,"SDR32.5","1 1/2",1.784,150,null,null,"SDR32.5",3,3.2839999999999998,150,null,null,"SDR15","3/4",0.82399999999999995,140]
[null,"SDR32.5",2,2.2290000000000001,150,null,null,"SDR32.5",2,2.2290000000000001,150,null,null,"SDR41",4,4.28,150,null,null,"SDR15",1,1.0489999999999999,140]
[null,"SDR32.5","2 1/2",2.6989999999999998,150,null,null,"SDR32.5","2 1/2",2.6989999999999998,150,null,null,"SDR41",5,5.2910000000000004,150]
[null,"SDR32.5",3,3.2839999999999998,150,null,null,"SDR32.5",3,3.2839999999999998,150,null,null,"SDR41",6,6.3010000000000002,150]
[null,"SDR41",4,4.28,150,null,null,"SDR41",4,4.28,150,null,null,"SDR41",8,8.2050000000000001,150]
[null,"SDR41",5,5.2910000000000004,150,null,null,"SDR41",5,5.2910000000000004,150,null,null,"SDR41",10,10.266,150]
[null,"SDR41",6,6.3010000000000002,150,null,null,"SDR41",6,6.3010000000000002,150,null,null,"SDR41",12,12.128,150]
[null,"SDR41",8,8.2050000000000001,150,null,null,"SDR41",8,8.2050000000000001,150]
[null,"SDR41",10,10.266,150,null,null,"SDR41",10,10.266,150]
[null,"SDR41",12,12.128,150,null,null,"SDR41",12,12.128,150]
[null,"SDR26",6,6.1150000000000002,150,null,null,"SDR15",1,1.0489999999999999,140]
[null,"SDR26",8,7.9610000000000003,150]
[null,"SDR26",10,9.9239999999999995,150]
[null,"SDR15",1,1.0489999999999999,140]
[null,"SCH40",2,2.0670000000000002,150]
[]
[]
[]
[null,"Number=",{"$f":"COUNT(D10:D27)","v":16}]

{"sheet":"PipeList","index":3,"n_rows":107,"n_cols":9,"rows_kept":107,"cut":false,"hidden":false,"merged":[[93,0,93,8],[94,0,94,3],[95,1,95,2],[24,0,24,8],[25,1,25,2],[25,6,25,7],[47,0,47,8],[71,1,71,2],[71,6,71,7],[48,1,48,2],[0,0,0,8],[1,0,1,8],[48,6,48,7],[69,0,69,8],[70,0,70,3],[70,5,70,8],[2,1,2,2],[2,6,2,7]]}
["The following list contains pipes that are commonly used in the design of irrigation pipelines, watering facilities, and component conservation practices that use pipelines. "]
["PVC IPS"]
["SDR","Dimensions in Inches",null,"C",null,"SDR","Dimensions in Inches",null,"C"]
[null,"Nominal Pipe Size","Inside Diameter",null,null,null,"Nominal Pipe Size","Inside Diameter"]
["SDR13.5","1/2",0.71599999999999997,150,null,"SDR17","3/4",0.92600000000000005,150]
["SDR13.5","3/4",0.89400000000000002,150,null,"SDR17",1,1.161,150]
["SDR13.5",1,1.121,150,null,"SDR17","1 1/4",1.464,150]
["SDR13.5","1 1/4",1.4139999999999999,150,null,"SDR17","1 1/2",1.6759999999999999,150]
["SDR13.5","1 1/2",1.6180000000000001,150,null,"SDR17",2,2.0950000000000002,150]
["SDR13.5",2,2.0230000000000001,150,null,"SDR17","2 1/2",2.5369999999999999,150]
["SDR13.5","2 1/2",2.4489999999999998,150,null,"SDR17",3,3.0880000000000001,150]
["SDR13.5",3,2.9820000000000002,150,null,"SDR17","3 1/2",3.53,150]
["SDR13.5","3 1/2",3.4079999999999999,150,null,"SDR17",4,3.97,150]
["SDR13.5",4,3.8340000000000001,150,null,"SDR17",5,4.9089999999999998,150]
["SDR13.5",5,4.7389999999999999,150,null,"SDR17",6,5.8449999999999998,150]
["SDR13.5",6,5.6429999999999998,150,null,"SDR17",8,7.609,150]
["SDR13.5",8,7.3470000000000004,150,null,"SDR17",10,9.4860000000000007,150]
["SDR13.5",10,9.1560000000000006,150,null,"SDR17",12,11.25,150]
["SDR13.5",12,10.86,150,null,"SDR17",14,12.353999999999999,150]
[null,null,null,null,null,"SDR17",16,14.118,150]
[null,null,null,null,null,"SDR17",18,15.882,150]
[null,null,null,null,null,"SDR17",20,17.648,150]
[null,null,null,null,null,"SDR17",24,21.175999999999998,150]
[]
["PVC IPS"]
["SDR","Dimensions in Inches",null,"C",null,"SDR","Dimensions in Inches",null,"C"]
[null,"Nominal Pipe Size","Inside Diameter",null,null,null,"Nominal Pipe Size","Inside Diameter"]
["SDR21","3/4",0.93,150,null,"SDR26",1,1.1950000000000001,150]
["SDR21",1,1.1890000000000001,150,null,"SDR26","1 1/4",1.532,150]
["SDR21","1 1/4",1.502,150,null,"SDR26","1 1/2",1.754,150]
["SDR21","1 1/2",1.72,150,null,"SDR26",2,2.1930000000000001,150]
["SDR21",2,2.149,150,null,"SDR26","2 1/2",2.6549999999999998,150]
["SDR21","2 1/2",2.601,150,null,"SDR26",3,3.23,150]
["SDR21",3,3.1659999999999999,150,null,"SDR26",4,4.1539999999999999,150]
["SDR21","3 1/2",3.62,150,null,"SDR26",5,5.1349999999999998,150]
["SDR21",4,4.0720000000000001,150,null,"SDR26",6,6.1150000000000002,150]
["SDR21",5,5.0330000000000004,150,null,"SDR26",8,7.9610000000000003,150]
["SDR21",6,5.9930000000000003,150,null,"SDR26",10,9.9239999999999995,150]
["SDR21",8,7.8049999999999997,150,null,"SDR26",12,11.77,150]
["SDR21",10,9.7279999999999998,150,null,"SDR26",14,12.923999999999999,150]
["SDR21",12,11.538,150,null,"SDR26",16,14.77,150]
["SDR21",14,12.667999999999999,150,null,"SDR26",18,16.616,150]
["SDR21",16,14.476000000000001,150,null,"SDR26",20,18.462,150]
["SDR21",18,16.286000000000001,150,null,"SDR26",24,22.154,150]
["SDR21",20,18.096,150]
["SDR21",24,21.713999999999999,150]
[]
["PVC IPS"]
["SDR","Dimensions in Inches",null,"C",null,"SDR","Dimensions in Inches",null,"C"]
[null,"Nominal Pipe Size","Inside Diameter",null,null,null,"Nominal Pipe Size","Inside Diameter"]
["SDR32.5",1,1.2110000000000001,150,null,"SDR41","3 1/2",3.8039999999999998,150]
["SDR32.5","1 1/4",1.54,150,null,"SDR41",4,4.28,150]
["SDR32.5","1 12/",1.78,150,null,"SDR41",5,5.2910000000000004,150]
["SDR32.5",2,2.2290000000000001,150,null,"SDR41",6,6.3010000000000002,150]
["SDR32.5","2 1/2",2.6989999999999998,150,null,"SDR41",8,8.2050000000000001,150]
["SDR32.5",3,3.2839999999999998,150,null,"SDR41",10,10.266,150]
["SDR32.5",4,4.2240000000000002,150,null,"SDR41",12,12.128,150]
["SDR32.5",5,5.2210000000000001,150,null,"SDR41",14,13.318,150]
["SDR32.5",6,6.2169999999999996,150,null,"SDR41",16,15.22,150]
["SDR32.5",8,8.0950000000000006,150,null,"SDR41",18,17.122,150]
["SDR32.5",10,10.087999999999999,150,null,"SDR41",20,19.024000000000001,150]
["SDR32.5",12,11.965999999999999,150,null,"SDR41",24,22.83,150]
["SDR32.5",14,13.14,150]
["SDR32.5",16,15.016,150]
["SDR32.5",18,16.891999999999999,150]
["SDR32.5",20,18.77,150]
["SDR32.5",24,22.524000000000001,150]
[]
[]
["PVC Schedule 40 and 80"]
["Plastic Pipe",null,null,null,null,"Plastic Pipe"]
["SCH","Dimensions in Inches",null,"C",null,"SCH","Dimensions in Inches",null,"C"]
[null,"Nominal Pipe Size","Inside Diameter",null,null,null,"Nominal Pipe Size","Inside Diameter"]
["SCH40","1/2",0.622,150,null,"SCH80","1/2",0.54600000000000004,150]
["SCH40","3/4",0.82399999999999995,150,null,"SCH80","3/4",0.74199999999999999,150]
["SCH40",1,1.0489999999999999,150,null,"SCH80",1,0.95699999999999996,150]
["SCH40","1 1/4",1.38,150,null,"SCH80","1 1/4",1.278,150]
["SCH40","1 1/2",1.61,150,null,"SCH80","1 1/2",1.5,150]
["SCH40",2,2.0670000000000002,150,null,"SCH80",2,1.9390000000000001,150]
["SCH40","2 1/2",2.4689999999999999,150,null,"SCH80","2 1/2",2.323,150]
["SCH40",3,3.0680000000000001,150,null,"SCH80",3,2.9,150]
["SCH40",4,4.0259999999999998,150,null,"SCH80",4,3.8260000000000001,150]
["SCH40",6,6.0650000000000004,150,null,"SCH80",6,5.7610000000000001,150]
["SCH40",8,7.9809999999999999,150,null,"SCH80",8,7.625,150]
["SCH40",10,10.02,150,null,"SCH80",10,9.5640000000000001,150]
["SCH40",12,11.938000000000001,150,null,"SCH80",12,11.736000000000001,150]
["SCH40",14,13.125999999999999,150,null,"SCH80",14,12.5,150]
["SCH40",16,15,150,null,"SCH80",16,14.314,150]
["SCH40",18,16.876000000000001,150,null,"SCH80",18,16.126000000000001,150]
["SCH40",20,18.814,150,null,"SCH80",20,17.937999999999999,150]
["SCH40",24,22.626000000000001,150,null,"SCH80",24,21.564,150]
[]
[]
["Polyethylene (PE)"]
["Plastic Pipe"]
["SCH","Dimensions in Inches",null,"C"]
[null,"Nominal Pipe Size","Inside Diameter"]
["SCH7","1/2",0.622,140]
["SCH7","3/4",0.82399999999999995,140]
["SCH7",1,1.0489999999999999,140]
["SCH7","1 1/4",1.38,140]
["SCH7","1 1/2",1.61,140]
["SCH7",2,2.0670000000000002,140]
["SCH7","2 1/2",2.4689999999999999,140]
["SCH7",3,3.0680000000000001,140]
["SCH7",4,4.0259999999999998,140]
["SCH7",6,6.0650000000000004,140]

{"sheet":"User's Guide","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}