{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Input","Data"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Input","index":0,"n_rows":51,"n_cols":31,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,1,0,2],[31,1,32,1]]}
[null,"Basic Traffic Analysis",null,null,null,null,null,"Information Only"]
[]
[null,"Contract Name:","<Enter Project Name>"]
[null,"Date:",{"$f":"NOW()","v":"2017-02-14T15:40:32.180"},null,"\"User input at green cells only\""]
[]
[]
[null,"Letable Area in Sq.Metres",3600]
[null,"Building Population (Area per person)",{"$f":"C7/E8","v":450},null,8,"Sq. Metres per person"]
[null,"Entrance Opening Width",900]
[null,"No of Cars",{"$f":"C8/E10","v":2.25},null,200,"Persons per Lift"]
[null,"No of Passengers",13,null,"."]
[null,"No of Stops",3]
[null,"HQ = Travel / Metres",12]
[null,"V = Speed # m/min.",{"$f":"E14*60","v":60},null,1,"m/Sec"]
[]
[null,"PASSENGERS PER TRIP",{"$f":"INDEX(Data!$C$10:$J$43,MATCH(Input!B16,Data!$B$10:$B$42,0),MATCH(Input!$C$14,Data!$C$8:$J$8,0))","v":10.4}]
[null,"TRIP LENGTH LOCAL ZONE",{"$f":"INDEX(Data!$C$10:$J$43,MATCH(Input!B17,Data!$B$10:$B$42,0),MATCH(Input!$C$14,Data!$C$8:$J$8,0))","v":12}]
[null,"AVERAGE TRIP LENGTH",{"$f":"INDEX(Data!$C$10:$J$43,MATCH(Input!B18,Data!$B$10:$B$42,0),MATCH(Input!$C$14,Data!$C$8:$J$8,0))","v":4.0598635325997394}]
[null,"AVERAGE TRIP TIME",{"$f":"INDEX(Data!$C$10:$J$43,MATCH(Input!B19,Data!$B$10:$B$42,0),MATCH(Input!$C$14,Data!$C$8:$J$8,0))","v":6.8704621679257372}]
[null,"TRIP TIME LOCAL ZONE",{"$f":"INDEX(Data!$C$10:$J$43,MATCH(Input!B20,Data!$B$10:$B$42,0),MATCH(Input!$C$14,Data!$C$8:$J$8,0))","v":20.307467320783246}]
[null,"DOOR CLOSE TIME",{"$f":"INDEX(Data!$C$10:$J$43,MATCH(Input!B21,Data!$B$10:$B$42,0),MATCH(Input!$C$14,Data!$C$8:$J$8,0))","v":7.0938345017616582}]
[null,"PASSENGER TRANSFER TIME",{"$f":"INDEX(Data!$C$10:$J$43,MATCH(Input!B22,Data!$B$10:$B$42,0),MATCH(Input!$C$14,Data!$C$8:$J$8,0))","v":20.672798279487786}]
[null,"LOST TIME",{"$f":"INDEX(Data!$C$10:$J$43,MATCH(Input!B23,Data!$B$10:$B$42,0),MATCH(Input!$C$14,Data!$C$8:$J$8,0))","v":2.7766632781249445}]
[null,"ROUND TRIP TIME (SECS)",{"$f":"INDEX(Data!$C$10:$J$43,MATCH(Input!B24,Data!$B$10:$B$42,0),MATCH(Input!$C$14,Data!$C$8:$J$8,0))","v":50.85076338015763}]
[null,"PASS. HAND. CAP. IN 5 MINS.",{"$f":"INDEX(Data!$C$10:$J$43,MATCH(Input!B25,Data!$B$10:$B$42,0),MATCH(Input!$C$14,Data!$C$8:$J$8,0))","v":61.35601105287337}]
[]
[null,"NUMBER OF CARS REQUIRED",{"$f":"INDEX(Data!$C$10:$J$43,MATCH(Input!B27,Data!$B$10:$B$42,0),MATCH(Input!$C$14,Data!$C$8:$J$8,0))","v":1.1001367077437949}]
[null,"ACTUAL NUMBER OF CARS",{"$f":"INDEX(Data!$C$10:$J$43,MATCH(Input!B28,Data!$B$10:$B$42,0),MATCH(Input!$C$14,Data!$C$8:$J$8,0))","v":2.25}]
[]
[null,"AVERAGE WAITING INTERVAL (SECS)",{"$f":"INDEX(Data!$C$10:$J$43,MATCH(Input!B30,Data!$B$10:$B$42,0),MATCH(Input!$C$14,Data!$C$8:$J$8,0))","v":22.60033928007006}]
[null,"THEORETICAL A. W. T. (SECS)",{"$f":"INDEX(Data!$C$10:$J$43,MATCH(Input!B31,Data!$B$10:$B$42,0),MATCH(Input!$C$14,Data!$C$8:$J$8,0))","v":12.430186604038534}]
[null,"HANDLING CAPACITY IN 5 MINS (%)",{"$f":"INDEX(Data!$C$10:$J$43,MATCH(Input!B32,Data!$B$10:$B$42,0),MATCH(Input!$C$14,Data!$C$8:$J$8,0))","v":30.678005526436682}]
[null,null,{"$f":"IF(C32>=15,\"Good\",\"Poor\")","v":"Good"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ISO LOADS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,320]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,450]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,550]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,630]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,800]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,900]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1150]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1250]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1350]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3500]

{"sheet":"Data","index":1,"n_rows":63,"n_cols":10,"rows_kept":63,"cut":false,"hidden":false,"merged":[[1,1,1,2],[0,0,0,9]]}
["TRAFFIC STUDY PASSENGER ELEVATORS"]
["CONTRACT:",{"$f":"Input!C3","v":"<Enter Project Name>"}]
["LETABLE AREA IN SQ. METRES :",null,{"$f":"Input!C7","v":3600}]
["BUILDING POPULATION :",null,{"$f":"Input!C8","v":450},"USING SQUARE METRES PER PERSON OF :",null,null,null,null,null,{"$f":"Input!E8","v":8}]
["15% OF POPULATION :  ",null,{"$f":"C4*0.15","v":67.5},"STOPS ABOVE OR BELOW LOBBY",null,null,{"$f":"Input!C12","v":3},"LOC.ZONE TRAVEL (M):",null,{"$f":"Input!C13","v":12}]
["OPENING IN MM :",null,{"$f":"Input!C9","v":900},"EXP/STOP (PE):",0,null,null,"EXP.ZONE TRAVEL:",null,0]
["NO/CARS:",null,{"$f":"Input!C10","v":2.25},"NO. PASS",{"$f":"Input!C11","v":13},null,null,"DATE:",null,{"$f":"Input!C4","v":"2017-02-14T15:40:32.180"}]
["SPEED OF LIFT (# meters per minute)",null,{"$f":"Input!C14","v":60},90,105,120,150,180,210,240]
[]
["R","NO. OF PASSENGERS",{"$f":"E7","v":13},{"$f":"E7","v":13},{"$f":"E7","v":13},{"$f":"E7","v":13},{"$f":"E7","v":13},{"$f":"E7","v":13},{"$f":"E7","v":13},{"$f":"E7","v":13}]
["V","SPEED IN METRES PER SECOND",1,1.5,1.75,2,2.5,3,3.5,4]
["N","NO. OF STOPS ABOVE LOBBY",{"$f":"G5","v":3},{"$f":"G5","v":3},{"$f":"G5","v":3},{"$f":"G5","v":3},{"$f":"G5","v":3},{"$f":"G5","v":3},{"$f":"G5","v":3},{"$f":"G5","v":3}]
["R","PASSENGERS PER TRIP",{"$f":"C10*0.8","v":10.4},10.4,10.4,10.4,10.4,10.4,10.4,10.4]
["PL","NO. OF PROBABLE LOCAL STOPS",{"$f":"C12*(1-(((C12-1)/C12)^C13))","v":2.9557643757340242},2.9557643757340242,2.9557643757340242,2.9557643757340242,2.9557643757340242,2.9557643757340242,2.9557643757340242,2.9557643757340242]
["PE","NO. OF PROBABLE EXPRESS STOPS",{"$f":"E6","v":0},{"$f":"E6","v":0},{"$f":"E6","v":0},{"$f":"E6","v":0},{"$f":"E6","v":0},{"$f":"E6","v":0},{"$f":"E6","v":0},{"$f":"E6","v":0}]
["P","TOTAL PROBABLE STOPS",{"$f":"C15+C14","v":2.9557643757340242},2.9557643757340242,2.9557643757340242,2.9557643757340242,2.9557643757340242,2.9557643757340242,2.9557643757340242,2.9557643757340242]
["SL","TRIP LENGTH LOCAL ZONE",{"$f":"J5","v":12},{"$f":"J5","v":12},{"$f":"J5","v":12},{"$f":"J5","v":12},{"$f":"J5","v":12},{"$f":"J5","v":12},{"$f":"J5","v":12},{"$f":"J5","v":12}]
["SE","TRIP LENGTH EXPRESS ZONE",{"$f":"J6","v":0},{"$f":"J6","v":0},{"$f":"J6","v":0},{"$f":"J6","v":0},{"$f":"J6","v":0},{"$f":"J6","v":0},{"$f":"J6","v":0},{"$f":"J6","v":0}]
["J","AVERAGE TRIP LENGTH",{"$f":"(C17/C14)","v":4.0598635325997394},4.0598635325997394,4.0598635325997394,4.0598635325997394,4.0598635325997394,4.0598635325997394,4.0598635325997394,4.0598635325997394]
["TJ","AVERAGE TRIP TIME",{"$f":"(1.01*C19)+2.77","v":6.8704621679257372},{"$f":"(0.655*D19)+3.575","v":6.234210613852829},{"$f":"(0.564*C19)+3.826","v":6.1157630323862531},{"$f":"IF(C19<=5.75,0.874+SQRT(0.76+(4.5*C19)),3.09+(C19/2))","v":5.2362684347365454},{"$f":"IF(C19<=9.1,0.874+SQRT(0.76+(4.5*C19)),3.65+(C19/2.5))","v":5.2362684347365454},{"$f":"IF(C19<=12.6,0.874+SQRT(0.76+(4.5*C19)),4.2+(C19/3))","v":5.2362684347365454},{"$f":"IF(C19<=16.7,0.874+SQRT(0.76+(4.5*C19)),4.76+(C19/3.5))","v":5.2362684347365454},{"$f":"IF(C19<=21.3,0.874+SQRT(0.76+(4.5*C19)),5.32+(C19/4))","v":5.2362684347365454}]
["TL","TRIP TIME LOCAL ZONE",{"$f":"(C20*C14)","v":20.307467320783246},18.426857643249136,18.076754501558376,15.477175701174842,15.477175701174842,15.477175701174842,15.477175701174842,15.477175701174842]
["TAE","ADDITIONAL EXPRESS TIME",{"$f":"C15*2.7","v":0},{"$f":"D15*3.3","v":0},{"$f":"C15*3.6","v":0},{"$f":"C15*3.02","v":0},{"$f":"C15*3.58","v":0},{"$f":"C15*4.13","v":0},{"$f":"C15*4.69","v":0},{"$f":"C15*5.24","v":0}]
["TE","TRIP TIME EXPRESS ZONE",{"$f":"C18/C11","v":0},0,0,0,0,0,0,0]
["TD","DOOR CLOSE TIME",{"$f":"C50","v":7.0938345017616582},{"$f":"(C50)","v":7.0938345017616582},{"$f":"C50","v":7.0938345017616582},{"$f":"C50","v":7.0938345017616582},{"$f":"C50","v":7.0938345017616582},{"$f":"C50","v":7.0938345017616582},{"$f":"C50","v":7.0938345017616582},{"$f":"C50","v":7.0938345017616582}]
["TR","PASSENGER TRANSFER TIME",{"$f":"(0.8+($D$50)*(($C$16-1)^0.333))*$C$13","v":20.672798279487786},20.672798279487786,20.672798279487786,20.672798279487786,20.672798279487786,20.672798279487786,20.672798279487786,20.672798279487786]
["TA","LOST TIME",{"$f":"0.1*(C25+C24)","v":2.7766632781249445},2.7766632781249445,2.7766632781249445,2.7766632781249445,2.7766632781249445,2.7766632781249445,2.7766632781249445,2.7766632781249445]
[]
["RTT","ROUND TRIP TIME (SECS)",{"$f":"SUM(C21:C26)","v":50.85076338015763},48.97015370262352,48.620050560932768,46.020471760549228,46.020471760549228,46.020471760549228,46.020471760549228,46.020471760549228]
[]
["HC","PASS. HAND. CAP. IN 5 MINS.",{"$f":"((60*5)/C28)*C13","v":61.35601105287337},63.712277052396708,64.171056261858055,67.795915179526716,67.795915179526716,67.795915179526716,67.795915179526716,67.795915179526716]
[]
["NR","NUMBER OF CARS REQUIRED",{"$f":"(C5/C30)","v":1.1001367077437949},{"$f":"(C5/D30)","v":1.0594504406817589},{"$f":"(C5/E30)","v":1.0518760938663339},{"$f":"(C5/F30)","v":0.99563520635803615},{"$f":"(C5/G30)","v":0.99563520635803615},{"$f":"(C5/H30)","v":0.99563520635803615},{"$f":"(C5/I30)","v":0.99563520635803615},{"$f":"(C5/J30)","v":0.99563520635803615}]
[]
["NO","ACTUAL NUMBER OF CARS",{"$f":"C7","v":2.25},{"$f":"C7","v":2.25},{"$f":"C7","v":2.25},{"$f":"C7","v":2.25},{"$f":"C7","v":2.25},{"$f":"C7","v":2.25},{"$f":"C7","v":2.25},{"$f":"C7","v":2.25}]
[]
["AWI","AVERAGE WAITING INTERVAL (SECS)",{"$f":"(C28/C34)","v":22.60033928007006},21.764512756721565,21.608911360414563,20.453543004688544,20.453543004688544,20.453543004688544,20.453543004688544,20.453543004688544]
[null,null,null,null,null,"  "]
["TAWT","THEORETICAL A. W. T. (SECS)",{"$f":"(C36*0.55)","v":12.430186604038534},11.970482016196861,11.88490124822801,11.2494486525787,11.2494486525787,11.2494486525787,11.2494486525787,11.2494486525787]
[]
["QC","HANDLING CAPACITY IN 5 MINS (%)",{"$f":"((C30*C34)/C4)*100","v":30.678005526436682},{"$f":"((D30*D34)/C4)*100","v":31.85613852619835},{"$f":"((E30*E34)/C4)*100","v":32.085528130929028},{"$f":"((F30*F34)/C4)*100","v":33.897957589763358},{"$f":"((G30*G34)/C4)*100","v":33.897957589763358},{"$f":"((H30*H34)/C4)*100","v":33.897957589763358},{"$f":"((I30*I34)/C4)*100","v":33.897957589763358},{"$f":"((J30*J34)/C4)*100","v":33.897957589763358}]
[]
["FT","BUILDING FILLING TIME (MINS)",{"$f":"(500/C40)","v":16.298321596204371},15.695562084174206,15.583349538760503,14.75015120530424,14.75015120530424,14.75015120530424,14.75015120530424,14.75015120530424]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF($C$6=800,$C$16*2,$C$51)","v":7.0938345017616582},{"$f":"IF(C$6=800,1,D$51)","v":0.95},{"$f":"IF(C$6=800,1,D$51)","v":0.95},0,0,0,0,0]
[null,null,{"$f":"IF($C$6=850,$C$16*2.2,$C$52)","v":7.0938345017616582},{"$f":"IF(C$6=850,1,D$52)","v":0.95},0,0,0,0,0,0]
[null,null,{"$f":"IF($C$6=900,$C$16*2.4,$C$53)","v":7.0938345017616582},{"$f":"IF(C$6=900,0.95,D$53)","v":0.95}]
[null,null,{"$f":"IF($C$6=950,$C$16*2.6,$C54)","v":0},{"$f":"IF(C$6=950,0.95,D$54)","v":0}]
[null,null,{"$f":"IF(C$6=1000,C$16*2.8,C55)","v":0},{"$f":"IF(C$6=1000,0.9,D$55)","v":0}]
[null,null,{"$f":"IF(C$6=1050,C$16*3,C56)","v":0},{"$f":"IF(C$6=1050,0.88,D$56)","v":0}]
[null,null,{"$f":"IF(C$6=1100,C$16*3.3,C57)","v":0},{"$f":"IF(C$6=1100,0.85,D$57)","v":0}]
[null,null,{"$f":"IF(C$6=1150,C$16*3.4,C58)","v":0},{"$f":"IF(C$6=1150,0.85,D$58)","v":0}]
[null,null,{"$f":"IF(C$6=1200,C$16*3.7,C59)","v":0},{"$f":"IF(C$6=1200,0.8,D$59)","v":0}]
[null,null,{"$f":"IF(C$6=1250,C$16*4,C60)","v":0},{"$f":"IF(C$6=1250,0.78,D$60)","v":0}]
[null,null,{"$f":"IF(C$6=1300,C$16*4.2,C61)","v":0},{"$f":"IF(C$6=1300,0.75,D$61)","v":0}]
[null,null,{"$f":"IF(C$6=1350,C$16*4.4,C62)","v":0},{"$f":"IF(C$6=1350,0.75,D$62)","v":0}]
[null,null,{"$f":"IF($C35=1400,$C27*4.7,C63)","v":0},{"$f":"IF(C$6=1400,0.7,D$63)","v":0}]
[null,null,{"$f":"IF($C$6=1500,$C$16*5.1,C64)","v":0},{"$f":"IF(C$6=1500,0.65,D$64)","v":0}]