{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Tunnel Cost"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":4,"defined_names":22,"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":"Tunnel Cost","index":0,"n_rows":40,"n_cols":21,"rows_kept":40,"cut":false,"hidden":false,"merged":[[7,18,8,18],[9,8,9,10],[10,8,10,10],[1,3,2,10],[15,8,15,10],[15,15,15,16],[5,1,5,5],[6,7,6,12],[6,15,6,16],[11,8,11,10],[12,8,12,10],[13,8,13,10],[14,8,14,10],[14,15,14,16],[1,12,2,13],[20,21,20,22],[21,15,21,16],[21,18,21,19],[21,21,21,22],[16,8,16,10],[17,8,17,10],[18,8,18,10],[18,18,18,19],[18,21,18,22],[19,8,19,10],[19,18,19,19],[19,21,19,22],[20,8,20,10],[20,15,20,16],[20,18,20,19],[22,1,22,3],[22,18,22,19],[22,21,22,22],[23,1,23,3],[23,18,23,19],[25,1,25,3],[26,1,26,3],[26,8,26,10],[26,15,26,16],[24,1,24,3],[24,7,24,12],[27,1,27,3],[27,8,27,11],[27,15,27,16],[33,15,33,16],[34,1,34,4],[28,1,28,3],[28,8,28,10],[29,1,29,3],[29,8,29,10],[30,1,30,3],[30,8,30,10],[38,1,38,3],[38,7,38,10],[38,11,38,12],[31,1,31,3],[31,8,31,10],[32,1,32,3],[32,8,32,10],[35,7,35,12],[36,1,36,3],[37,1,37,3],[37,7,37,10],[37,11,37,12],[51,6,51,7],[39,1,39,3],[39,7,39,10],[39,11,39,12],[45,6,45,7],[45,9,45,10],[46,6,46,7],[46,9,46,10],[47,9,47,10],[48,9,48,10],[49,6,49,7],[49,9,49,10],[50,6,50,7]]}
[]
[null,null,null,"Tunnel Construction Costs  © Rocketwaveuk",null,null,null,null,null,null,null,null,"Unlocked"]
[]
[]
[]
[null,"Tube Tunnel Design"]
[null,null,null,null,null,null,null,"Dimensions Of Tunnel  ( 2 decimal places )",null,null,null,null,null,null,null,"Basic Trigonometry"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A° SIN= O/H",{"$f":"Q19/Q17","v":0.8},null,"Pie  Drawing  Of Tunnel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ASIN = ",{"$f":"ASIN(Q8)","v":0.9272952180016123}]
[null,null,null,null,null,null,null,null,"Radius Mtrˢ",null,null,6,null,null,null,"Degrees =",{"$f":"DEGREES(Q9)","v":53.130102354155987},null,{"$f":"IF(L10>10,10,L10)","v":6}]
[null,null,null,null,null,null,null,null,"° at M (Section AC)",null,null,80,null,null,null,"B° SIN = O/H",{"$f":"Q18/Q17","v":0.6},null,{"$f":"(360-((S10+S12)*2))/2","v":134}]
[null,null,null,null,null,null,null,null,"Length  A B mtrˢ",null,null,{"$f":"L31","v":3.8567256581192355},null,null,null,"ASIN = ",{"$f":"ASIN(Q11)","v":0.64350110879328437},null,{"$f":"L11/2","v":40}]
[null,null,null,null,null,null,null,null,"Length M B mtrˢ",null,null,{"$f":"L33","v":4.5962666587138683},null,null,null,"Degrees =",{"$f":"DEGREES(Q12)","v":36.86989764584402},null,{"$f":"L11/2","v":40}]
[null,null,null,null,null,null,null,null,"Internal Height Tunnel mtrˢ",null,null,{"$f":"(L10*2)-L13","v":7.4037333412861317},null,null,null,null,null,null,{"$f":"(360-((S10+S12)*2))/2","v":134}]
[null,null,null,null,null,null,null,null,"Angles° @  A & C",null,null,{"$f":"90-(L11/2)","v":50},null,null,null,"Test & Try  Values Below",null,null,{"$f":"IF(L10>10,10,L10)","v":6}]
[null,null,null,null,null,null,null,null,"Area Circle mtr²",null,null,{"$f":"PI()*(L10*L10)","v":113.09733552923255},null,null,null,"Find Hypotenuse"]
[null,null,null,null,null,null,null,null,"Area Circle Section mtr²",null,null,{"$f":"(L11/360)*L16","v":25.132741228718345},null,null,null,"HYP",{"$f":"SQRT((Q18*Q18)+(Q19*Q19))","v":10}]
[null,null,null,null,null,null,null,null,"Area Triangle mtr²",null,null,{"$f":"L12*L13","v":17.726539554219745},null,null,null,"AJC",{"$f":"Q36","v":6}]
[null,"A°",null,null,null,"C°",null,null,"Area Chord mtr²",null,null,{"$f":"L17-L18","v":7.4062016744986003},null,null,null,"OPP",{"$f":"Q37","v":8},null,"Value of PI",null,{"$f":"PI()","v":3.1415926535897931}]
[null,null,null,null,null,null,null,null,"Area Tunnel Sect mtr²",null,null,{"$f":"L16-L19","v":105.69113385473395},null,null,null,null,null,null,"360° / (Deg 1 Radian)",null,{"$f":"360/DEGREES(1)","v":6.2831853071795862}]
[null,null,null,null,null,null,null,null,"Volume Tunnel  mtr³",null,null,{"$f":"L20*E23","v":1056911.3385473394},null,null,null,"Test & Try  Values Below",null,null,"360° / ( Deg 2 Radian )",null,{"$f":"360/(DEGREES(2))","v":3.1415926535897931}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Find Adjacent",null,null,"180ᵒ / ( 1 Radian )",null,{"$f":"180/(DEGREES(1))","v":3.1415926535897931}]
[null,"Tunnel Length mtrˢ",null,null,10000,null,null,null,null,null,null,null,null,null,null,"HYP",{"$f":"Q35","v":10},null,"Deg( 1 Radian )",null,{"$f":"DEGREES(1)","v":57.295779513082323}]
[null,"Actual length in Kilometres",null,null,{"$f":"E23/1000","v":10},null,null,null,null,null,null,null,null,null,null,"AJC",{"$f":"SQRT((Q23*Q23)-(Q25*Q25))","v":6},null," 2 * PI * (Deg ( 1 Radian ))",null,{"$f":"U23*U20","v":360}]
[null,"Excavated Per Day mtr³",null,null,1500,null,null,null,null,null,null,null,null,null,null,"OPP",{"$f":"Q37","v":8}]
[null,"Days req to complete",null,null,{"$f":"ROUNDUP((L21/E25),0)","v":705}]
[null,"Size of trucks mtr³",null,null,30,null,null,null,"1 Radian = circumfrance /",null,null,6.2831853070000001,null,null,null,"Test & Try  Values Below"]
[null,"Number of truck loads req",null,null,{"$f":"ROUNDUP(L21/E27,0)","v":35231},null,null,null,"Tunnel Informational Data",null,null,null,null,null,null,"Find Opposite"]
[null,"Number of truck loads per day",null,null,{"$f":"ROUNDUP(E25/E27,0)","v":50},null,null,null,"Radians (deg)",null,null,{"$f":"RADIANS((L11/2))","v":0.69813170079773179},null,null,null,"HYP",{"$f":"Q35","v":10}]
[null,"Average Trucks Req Per Day",null,null,{"$f":"ROUND(E29/8,0)","v":6},null,null,null,"Sin (Radians)",null,null,{"$f":"SIN(L29)","v":0.64278760968653925},null,null,null,"AJC",{"$f":"Q36","v":6}]
[null,"Cost of truck Per Load",null,null,185,null,null,null,"Opp =  (Sin * Hyp)",null,null,{"$f":"L10*L30","v":3.8567256581192355},null,null,null,"OPP",{"$f":"SQRT((Q29*Q29)-(Q30*Q30))","v":8}]
[null,"Total cost of trucks per day",null,null,{"$f":"E29*E31","v":9250},null,null,null,"Cos (Radians)",null,null,{"$f":"COS(L29)","v":0.76604444311897801}]
[null,"Cost in Millions For Trucks",null,null,{"$f":"(E28*E31)/1000000","v":6.5177350000000001},null,null,null,"Ajc = Cos * Hyp",null,null,{"$f":"L10*L32","v":4.5962666587138683}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter The Values Here"]
[null,"Digger Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,"HYP",10]
[null,"Number Of Days Required",null,null,{"$f":"E26","v":705},null,null,"These colour sells are Not locked ",null,null,null,null,null,null,null,"AJC",6]
[null,"Machine Hire Cost",null,null,4200,null,null,null,null,null,null,null,null,null,null,"OPP",8]
[null,"Drivers Per Day",null,null,125,null,null,"Total Trucks Costs",null,null,null,{"$f":"(E28*E31)","v":6517735}]
[null,"Total Digger Costs",null,null,{"$f":"(E38+E37)*E36","v":3049125},null,null,"Total Digger Costs",null,null,null,{"$f":"(E38+E37)*E36","v":3049125}]
[null,null,null,null,null,null,null,"Total Cost Complete",null,null,null,{"$f":"E39+(E33*1000000)","v":9566860}]