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

{"sheet":"Sheet1","index":0,"n_rows":84,"n_cols":22,"rows_kept":84,"cut":false,"hidden":false,"merged":[[6,5,6,6]]}
[]
["Example of ABG highway and public transport accessibility statistic"]
[]
[]
[]
[]
["Combined Accessibility Stat",null,null,null,null,{"$f":"(L23*R15+L38*R13+L54*R14+L63*R15+L84*R16)/SUM(R12:R16)","v":0.33995285749746323}]
[]
[]
["What","Description",null,"Time(mins) to facility","exp(-at)","Size of Facility","Satisfaction at \n0 Time","Corrected Satisfaction for Time","Dissatisfaction","Dissatisfaction adjusted for size","Satisfaction adjusted for size","Cumulative Satisfied"]
[null,null,null,"t","E","S","W","W*E","1-W*E","(1-W*E)^S","1-(1-W*E)^S","1-ProductSum((1-W*E)^S)",null,null,null,"What","Description","Worth","Satisfaction","ScalingTime","SizeBase","SizeInfo"]
[1,{"$f":"VLOOKUP($A12,$P$11:$V$16,2)","v":"Jobs"},{"$f":"VLOOKUP($A12,$P$11:$V$16,5)","v":-0.04},4,{"$f":"EXP(D12*C12)","v":0.85214378896621135},10,{"$f":"VLOOKUP($A12,$P$11:$V$16,4)","v":1E-3},{"$f":"G12*E12","v":8.5214378896621135E-4},{"$f":"1-H12","v":0.99914785621103375},{"$f":"I12^F12","v":0.99151116467361722},{"$f":"1-J12","v":8.488835326382782E-3},{"$f":"1-MultIt($J$12:J12)","v":8.488835326382782E-3},null,null,null,1,"Jobs",10,1E-3,-0.04,125.89031127566599,"Ave jobs per OA EW"]
[1,{"$f":"VLOOKUP(A13,P$11:Q$16,2)","v":"Jobs"},{"$f":"VLOOKUP($A13,$P$11:$V$16,5)","v":-0.04},5,{"$f":"EXP(D13*C13)","v":0.81873075307798182},15,{"$f":"VLOOKUP($A13,$P$11:$V$16,4)","v":1E-3},{"$f":"G13*E13","v":8.1873075307798185E-4},{"$f":"1-H13","v":0.99918126924692197},{"$f":"I13^F13","v":0.98778917321159965},{"$f":"1-J13","v":1.2210826788400353E-2},{"$f":"1-MultIt($J$12:J13)","v":2.0596006416977453E-2},null,null,null,2,"Workers",5,1E-3,-0.04,147.08043746692499,"Ave workers per OA EW"]
[1,"Jobs",-0.04,8,0.72614903707369094,10,1E-3,7.2614903707369095E-4,0.99927385096292631,0.99276219189953585,7.2378081004641492E-3,{"$f":"1-MultIt($J$12:J14)","v":2.7684744575359632E-2},null,null,null,3,"Population",3,2E-3,-7.0000000000000007E-2,309.11487916740202,"Ave persons per oa EW"]
[1,"Jobs",-0.04,8,0.72614903707369094,70,1E-3,7.2614903707369095E-4,0.99927385096292631,0.95042227155887837,4.9577728441121627E-2,{"$f":"1-MultIt($J$12:J15)","v":7.5889926267962315E-2},null,null,null,4,"Airports",2,0.6,-2.5000000000000001E-2,6211299,"Passengers per year"]
[1,"Jobs",-0.04,8,0.72614903707369094,80,1E-3,7.2614903707369095E-4,0.99927385096292631,0.94354329754292798,5.6456702457072017E-2,{"$f":"1-MultIt($J$12:J16)","v":0.12806213373823483},null,null,null,5,"Stations",5,0.3,-0.08,1,"Compsite Stat"]
[1,"Jobs",-0.04,14,0.57120906384881487,90,1E-3,5.7120906384881484E-4,0.99942879093615122,0.94987630898699893,5.012369101300107E-2,{"$f":"1-MultIt($J$12:J17)","v":0.17176687792927503}]
[1,"Jobs",-0.04,19,0.46766642700990924,100,1E-3,4.6766642700990925E-4,0.99953233357299009,0.95429962768271592,4.5700372317284077E-2,{"$f":"1-MultIt($J$12:J18)","v":0.20961743997341376}]
[1,"Jobs",-0.04,20,0.44932896411722156,150,1E-3,4.4932896411722158E-4,0.9995506710358828,0.9348076512978688,6.5192348702131198E-2,{"$f":"1-MultIt($J$12:J19)","v":0.26114433543475013}]
[1,"Jobs",-0.04,20,0.44932896411722156,170,1E-3,4.4932896411722158E-4,0.9995506710358828,0.9264426912715773,7.3557308728422699E-2,{"$f":"1-MultIt($J$12:J20)","v":0.31549256965892014}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Accessibility Stat Jobs",{"$f":"L20","v":0.31549256965892014}]
[]
["What","Description",null,"Time(mins) to facility","exp(-at)","Size of Facility","Satisfaction at \n0 Time","Corrected Satisfaction for Time","Dissatisfaction","Dissatisfaction adjusted for size","Satisfaction adjusted for size","Cumulative Satisfied"]
[null,null,null,"t","E","S","W","W*E","1-W*E","(1-W*E)^S","1-(1-W*E)^S","1-ProductSum((1-W*E)^S)"]
[2,{"$f":"VLOOKUP($A27,$P$11:$V$16,2)","v":"Workers"},{"$f":"VLOOKUP($A27,$P$11:$V$16,5)","v":-0.04},4,{"$f":"EXP(D27*C27)","v":0.85214378896621135},12,{"$f":"VLOOKUP($A27,$P$11:$V$16,4)","v":1E-3},{"$f":"G27*E27","v":8.5214378896621135E-4},{"$f":"1-H27","v":0.99914785621103375},{"$f":"I27^F27","v":0.98982206449716004},{"$f":"1-J27","v":1.0177935502839963E-2},{"$f":"1-MultIt($J$27:J27)","v":1.0177935502839963E-2}]
[2,{"$f":"VLOOKUP(A28,P$11:Q$16,2)","v":"Workers"},{"$f":"VLOOKUP($A28,$P$11:$V$16,5)","v":-0.04},5,{"$f":"EXP(D28*C28)","v":0.81873075307798182},16,{"$f":"VLOOKUP($A28,$P$11:$V$16,4)","v":1E-3},{"$f":"G28*E28","v":8.1873075307798185E-4},{"$f":"1-H28","v":0.99918126924692197},{"$f":"I28^F28","v":0.98698043983793393},{"$f":"1-J28","v":1.3019560162066068E-2},{"$f":"1-MultIt($J$27:J28)","v":2.3064983421301144E-2}]
[2,"Workers",-0.04,8,0.72614903707369094,12,1E-3,7.2614903707369095E-4,0.99927385096292631,0.99132092875613653,8.6790712438634676E-3,{"$f":"1-MultIt($J$27:J29)","v":3.1543872030812659E-2}]
[2,"Workers",-0.04,8,0.72614903707369094,72,1E-3,7.2614903707369095E-4,0.99927385096292631,0.94904247627473004,5.095752372526996E-2,{"$f":"1-MultIt($J$27:J30)","v":8.0893998148685586E-2}]
[2,"Workers",-0.04,8,0.72614903707369094,84,1E-3,7.2614903707369095E-4,0.99927385096292631,0.94080566900968909,5.9194330990310906E-2,{"$f":"1-MultIt($J$27:J31)","v":0.13529986303745356}]
[2,"Workers",-0.04,14,0.57120906384881487,90,1E-3,5.7120906384881484E-4,0.99942879093615122,0.94987630898699893,5.012369101300107E-2,{"$f":"1-MultIt($J$27:J32)","v":0.1786418255214639}]
[2,"Workers",-0.04,19,0.46766642700990924,101,1E-3,4.6766642700990925E-4,0.99953233357299009,0.9538533337855406,4.6146666214459398E-2,{"$f":"1-MultIt($J$27:J33)","v":0.21654476704164261}]
[2,"Workers",-0.04,20,0.44932896411722156,155,1E-3,4.4932896411722158E-4,0.9995506710358828,0.93270935702608615,6.729064297391385E-2,{"$f":"1-MultIt($J$27:J34)","v":0.26926397340868791}]
[2,"Workers",-0.04,20,0.44932896411722156,180,1E-3,4.4932896411722158E-4,0.9995506710358828,0.9222883228961819,7.77116771038181E-2,{"$f":"1-MultIt($J$27:J35)","v":0.32605069555527899}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Accessibility Stat Workers",{"$f":"L35","v":0.32605069555527899}]
[]
[]
["What","Description",null,"Time(mins) to facility","exp(-at)","Size of Facility","Satisfaction at \n0 Time","Corrected Satisfaction for Time","Dissatisfaction","Dissatisfaction adjusted for size","Satisfaction adjusted for size","Cumulative Satisfied"]
[null,null,null,"t","E","S","W","W*E","1-W*E","(1-W*E)^S","1-(1-W*E)^S","1-ProductSum((1-W*E)^S)"]
[3,{"$f":"VLOOKUP($A43,$P$11:$V$16,2)","v":"Population"},{"$f":"VLOOKUP($A43,$P$11:$V$16,5)","v":-7.0000000000000007E-2},4,{"$f":"EXP(D43*C43)","v":0.75578374145572547},12,{"$f":"VLOOKUP($A43,$P$11:$V$16,4)","v":2E-3},{"$f":"G43*E43","v":1.511567482911451E-3},{"$f":"1-H43","v":0.99848843251708852},{"$f":"I43^F43","v":0.98201123216529462},{"$f":"1-J43","v":1.7988767834705377E-2},{"$f":"1-MultIt($J$43:J43)","v":1.7988767834705377E-2}]
[3,{"$f":"VLOOKUP(A44,P$11:Q$16,2)","v":"Population"},{"$f":"VLOOKUP($A44,$P$11:$V$16,5)","v":-7.0000000000000007E-2},5,{"$f":"EXP(D44*C44)","v":0.70468808971871344},16,{"$f":"VLOOKUP($A44,$P$11:$V$16,4)","v":2E-3},{"$f":"G44*E44","v":1.4093761794374269E-3},{"$f":"1-H44","v":0.99859062382056263},{"$f":"I44^F44","v":0.97768678151038291},{"$f":"1-J44","v":2.2313218489617093E-2},{"$f":"1-MultIt($J$43:J44)","v":3.9900599017267724E-2}]
[3,"Population",-7.0000000000000007E-2,8,0.57120906384881487,12,2E-3,1.1424181276976297E-3,0.99885758187230234,0.98637679315682325,1.3623206843176749E-2,{"$f":"1-MultIt($J$43:J45)","v":5.2980231746865614E-2}]
[3,"Population",-7.0000000000000007E-2,8,0.57120906384881487,72,2E-3,1.1424181276976297E-3,0.99885758187230234,0.92099458216683128,7.9005417833168723E-2,{"$f":"1-MultIt($J$43:J46)","v":0.12779992423397513}]
[3,"Population",-7.0000000000000007E-2,8,0.57120906384881487,84,2E-3,1.1424181276976297E-3,0.99885758187230234,0.90844768247252738,9.1552317527472615E-2,{"$f":"1-MultIt($J$43:J47)","v":0.20765186251799195}]
[3,"Population",-7.0000000000000007E-2,14,0.37531109885139952,90,2E-3,7.5062219770279906E-4,0.99924937780229717,0.93465166958534385,6.5348330414656153E-2,{"$f":"1-MultIt($J$43:J48)","v":0.25943049040960364}]
[3,"Population",-7.0000000000000007E-2,19,0.26447726129982396,101,2E-3,5.289545225996479E-4,0.9994710454774004,0.94796419985339109,5.2035800146608913E-2,{"$f":"1-MultIt($J$43:J49)","v":0.29796661740532171}]
[3,"Population",-7.0000000000000007E-2,20,0.24659696394160643,155,2E-3,4.9319392788321292E-4,0.99950680607211684,0.92638634127913499,7.3613658720865005E-2,{"$f":"1-MultIt($J$43:J50)","v":0.34964586324230085}]
[3,"Population",-7.0000000000000007E-2,20,0.24659696394160643,180,2E-3,4.9319392788321292E-4,0.99950680607211684,0.91503148373771259,8.4968516262287408E-2,{"$f":"1-MultIt($J$43:J51)","v":0.40490548928764325}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Accessibility Stat population",{"$f":"L51","v":0.40490548928764325}]
[]
["What","Description",null,"Time(mins) to facility","exp(-at)","Size of Facility","Satisfaction at \n0 Time","Corrected Satisfaction for Time","Dissatisfaction","Dissatisfaction adjusted for size","Satisfaction adjusted for size","Cumulative Satisfied"]
[null,null,null,"t","E","S","W","W*E","1-W*E","(1-W*E)^S","1-(1-W*E)^S","1-ProductSum((1-W*E)^S)"]
[4,{"$f":"VLOOKUP($A58,$P$11:$V$16,2)","v":"Airports"},{"$f":"VLOOKUP($A58,$P$11:$V$16,5)","v":-2.5000000000000001E-2},30,{"$f":"EXP(D58*C58)","v":0.47236655274101469},1,{"$f":"VLOOKUP($A58,$P$11:$V$16,4)","v":0.6},{"$f":"G58*E58","v":0.28341993164460882},{"$f":"1-H58","v":0.71658006835539112},{"$f":"I58^F58","v":0.71658006835539112},{"$f":"1-J58","v":0.28341993164460888},{"$f":"1-MultIt($J$58:J58)","v":0.28341993164460888}]
[4,{"$f":"VLOOKUP(A59,P$11:Q$16,2)","v":"Airports"},{"$f":"VLOOKUP($A59,$P$11:$V$16,5)","v":-2.5000000000000001E-2},45,{"$f":"EXP(D59*C59)","v":0.32465246735834974},1.5,{"$f":"VLOOKUP($A59,$P$11:$V$16,4)","v":0.6},{"$f":"G59*E59","v":0.19479148041500985},{"$f":"1-H59","v":0.80520851958499018},{"$f":"I59^F59","v":0.72254107684370728},{"$f":"1-J59","v":0.27745892315629272},{"$f":"1-MultIt($J$58:J59)","v":0.48224146576575833}]
[4,{"$f":"VLOOKUP(A60,P$11:Q$16,2)","v":"Airports"},{"$f":"VLOOKUP($A60,$P$11:$V$16,5)","v":-2.5000000000000001E-2},52,0.27253179303401259,0.75,{"$f":"VLOOKUP($A60,$P$11:$V$16,4)","v":0.6},0.16351907582040756,0.83648092417959241,0.87466556916078986,0.12533443083921014,{"$f":"1-MultIt($J$58:J60)","v":0.54713443696615072}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Accessibility Stat Workers",{"$f":"L60","v":0.54713443696615072}]
[]
[]
[]
[]
[]
[]
[]
["What","Description",null,"Time(mins) to facility","exp(-at)","Size of Facility","Satisfaction at \n0 Time","Corrected Satisfaction for Time","Dissatisfaction","Dissatisfaction adjusted for size","Satisfaction adjusted for size","Cumulative Satisfied"]
[null,null,null,"t","E","S","W","W*E","1-W*E","(1-W*E)^S","1-(1-W*E)^S","1-ProductSum((1-W*E)^S)"]
[5,{"$f":"VLOOKUP($A73,$P$11:$V$16,2)","v":"Stations"},{"$f":"VLOOKUP($A73,$P$11:$V$16,5)","v":-0.08},4,{"$f":"EXP(D73*C73)","v":0.72614903707369094},0.9,{"$f":"VLOOKUP($A73,$P$11:$V$16,4)","v":0.3},{"$f":"G73*E73","v":0.21784471112210727},{"$f":"1-H73","v":0.78215528887789276},{"$f":"I73^F73","v":0.80161103612846429},{"$f":"1-J73","v":0.19838896387153571},{"$f":"1-MultIt($J$73:J73)","v":0.19838896387153571}]
[5,{"$f":"VLOOKUP(A74,P$11:Q$16,2)","v":"Stations"},{"$f":"VLOOKUP($A74,$P$11:$V$16,5)","v":-0.08},5,{"$f":"EXP(D74*C74)","v":0.67032004603563933},1.2,{"$f":"VLOOKUP($A74,$P$11:$V$16,4)","v":0.3},{"$f":"G74*E74","v":0.20109601381069178},{"$f":"1-H74","v":0.79890398618930825},{"$f":"I74^F74","v":0.76382436156006439},{"$f":"1-J74","v":0.23617563843993561},{"$f":"1-MultIt($J$73:J74)","v":0.38770996210967401}]
[5,"Stations",-0.08,8,0.52729242404304855,0.94,0.3,0.15818772721291455,0.84181227278708548,0.85055487452126788,0.14944512547873212,{"$f":"1-MultIt($J$73:J75)","v":0.47921372365157144}]
[5,"Stations",-0.08,8,0.52729242404304855,2,0.3,0.15818772721291455,0.84181227278708548,0.70864790261495847,0.29135209738504153,{"$f":"1-MultIt($J$73:J76)","v":0.63094589755503194}]
[5,"Stations",-0.08,8,0.52729242404304855,1.1000000000000001,0.3,0.15818772721291455,0.84181227278708548,0.82744050807069514,0.17255949192930486,{"$f":"1-MultIt($J$73:J77)","v":0.6946296859673613}]
[5,"Stations",-0.08,14,0.32627979462303947,2.2999999999999998,0.3,9.788393838691184E-2,0.9021160616130881,0.78904823922205491,0.21095176077794509,{"$f":"1-MultIt($J$73:J78)","v":0.75904809140186047}]
[5,"Stations",-0.08,19,0.21871188695221475,0.9,0.3,6.5613566085664418E-2,0.93438643391433562,0.94074923098148644,5.925076901851356E-2,{"$f":"1-MultIt($J$73:J79)","v":0.77332467728277876}]
[5,"Stations",-0.08,20,0.20189651799465538,0.5,0.3,6.0568955398396615E-2,0.93943104460160343,0.96924251072763179,3.075748927236821E-2,{"$f":"1-MultIt($J$73:J80)","v":0.78029664108956431}]
[5,"Stations",-0.08,20,0.20189651799465538,0.4,0.3,6.0568955398396615E-2,0.93943104460160343,0.97531737954871622,2.4682620451283777E-2,{"$f":"1-MultIt($J$73:J81)","v":0.78571949570942268}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Accessaibility Stat Workers",{"$f":"L81","v":0.78571949570942268}]