{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Case Calculator"],"not_rendered":{"charts":3,"images":1,"macros":1,"external_links":0,"defined_names":15,"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":"Case Calculator","index":0,"n_rows":99,"n_cols":51,"rows_kept":99,"cut":false,"hidden":false,"merged":[[61,25,61,26],[61,27,61,28],[61,29,61,30],[61,31,61,32],[53,18,54,18],[32,18,33,18],[61,21,61,22],[61,23,61,24],[39,18,40,18],[41,18,42,18],[46,18,47,18],[48,18,49,18],[21,9,21,13],[1,0,1,15],[2,0,2,11],[6,1,6,3],[7,1,7,3],[6,12,6,14],[7,12,7,14],[5,1,5,6],[5,9,5,14],[8,1,8,3],[9,1,9,3],[10,1,10,3],[6,9,6,11],[7,9,7,11],[8,9,8,11],[9,9,9,11],[6,4,6,6],[7,4,7,6],[8,4,8,6],[9,4,9,6],[10,4,10,6],[14,1,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[10,9,10,11],[2,36,2,41],[2,43,2,48],[0,0,0,13],[18,9,18,11],[18,12,18,14],[13,9,13,11],[13,12,13,14],[15,9,15,11],[15,12,15,14],[16,9,16,11],[16,12,16,14],[17,9,17,11],[17,12,17,14],[8,12,8,14],[9,12,9,14],[10,12,10,14],[0,14,0,15],[81,0,81,15],[22,9,22,13],[22,2,22,6],[23,10,24,12],[23,3,24,5],[77,0,80,15],[14,4,14,6],[13,1,13,6],[14,9,14,11],[14,12,14,14],[18,1,18,3],[15,4,15,6],[16,4,16,6],[17,4,17,6],[18,4,18,6]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.0000000000000001E-3]
["Business Case Calculator"]
[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,"Lifetime",null,null,"cost per repair"]
["Inputs are blue.",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,1,5.0000000000000001E-3,null,{"$f":"M10+(E17*E18)+E19","v":57.5},"replace chain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"km","cost"]
[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,2,0.01]
[null,"Bike Share Program",null,null,null,null,null,null,null,"Current Bike Drive System",null,null,null,null,null,null,null,null,null,null,"Gates Carbon Drive",null,null,null,null,null,null,3,1.4999999999999999E-2]
[null,"Bike share name",null,null,"Renaissance Bike Share",null,null,null,null,"Lifetime expectancy bike in years",null,null,3,null,null,null,null,null,null,null,"APPLIED PRICE",100,null,null,null,null,null,4]
[null,"Contact person",null,null,"Galileo",null,null,null,null,"Drive Type",null,null,"Chain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,"# bikes",null,null,3000,null,null,null,null,"Drive Brand/Model",null,null,"XYZ/V2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,"# stations",null,null,0,null,null,null,null,"Cost of system per drive",null,null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,"# of cities",null,null,1,null,null,null,null,"Cost of total bike",null,null,900,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,"Location of city",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,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assumptions",null,null,null,null,null,null,null,null,null,10]
[null,"Cost of Ownership",null,null,null,null,null,null,null,"Service Level Agreement",null,null,null,null,null,null,null,"Chain life assumed 5000 km"]
[null,"# km per bike per year",null,null,10000,null,null,null,null,null,null,null,null,null,null,null,null,"CDX life assumed 30,000 km"]
[null,"# of repairs per chain per year",null,null,2,null,null,null,null,"Minimum bikes operational",null,null,2500,null,null,null,null,"CDX repairs assumed 0.05% of chain."]
[null,"Costs technician per hour",null,null,45,null,null,null,null,"T-A-T per repair in days",null,null,4]
[null,"# hours per repair",null,null,0.5,null,null,null,null,"Bikes out of order (drive related)",null,null,{"$f":"CEILING(V90,1)","v":66}]
[null,"Cost per pick up",null,null,20,null,null,null,null,"Investment value defective stock",null,null,{"$f":"V91","v":59178.082191780828}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost of ownership per time",null,null,"replace only"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1km","1month","km per drive","drive buy","km/mnth",{"$f":"$E$15/12","v":833.33333333333337}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bike",{"$f":"$M$8","v":"Chain"},{"$f":"(X33+(E17*E18)+E19)/W33","v":1.15E-2},{"$f":"U33*$Z$32","v":9.5833333333333339},{"$f":"E15/E16","v":5000},{"$f":"$M$10","v":15}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CDX",{"$f":"((X34+(E17*E18)+E19)/W34)+((((E17*E18)+E19)/W34)*O1)","v":4.7570833333333336E-3},{"$f":"U34*$Z$32","v":3.9642361111111115},30000,{"$f":"$V$7","v":100}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost of ownership per time - replacement only"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,6,12,18,24,30,36,42,48,54,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bike",{"$f":"$M$8","v":"Chain"},0,{"$f":"V39*$V$33","v":57.5},{"$f":"W39*$V$33","v":115},172.5,230,287.5,345,402.5,460,517.5,575]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T34","v":"CDX"},0,{"$f":"V39*$V$34","v":23.78541666666667},{"$f":"W39*$V$34","v":47.57083333333334},71.356250000000003,95.14166666666668,118.92708333333334,142.71250000000001,166.4979166666667,190.28333333333336,214.06875000000002,237.85416666666669]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fleet",{"$f":"$M$8","v":"Chain"},0,{"$f":"V40*$E$9","v":172500},{"$f":"W40*$E$9","v":345000},517500,690000,862500,1035000,1207500,1380000,1552500,1725000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T34","v":"CDX"},{"$f":"U41*$E$9","v":0},{"$f":"V41*$E$9","v":71356.250000000015},142712.50000000003,214068.75,285425.00000000006,356781.25,428137.5,499493.75000000012,570850.00000000012,642206.25000000012,713562.5]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost of ownership per km - replacement only"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,4000,8000,12000,16000,20000,24000,28000,32000,36000,40000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bike",{"$f":"$M$8","v":"Chain"},{"$f":"U40","v":0},{"$f":"V46*$U$33","v":46},{"$f":"W46*$U$33","v":92},138,184,230,276,322,368,414,{"$f":"AE46*$U$33","v":460}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T34","v":"CDX"},{"$f":"U41","v":0},{"$f":"V46*$U$34","v":19.028333333333336},{"$f":"W46*$U$34","v":38.056666666666672},57.085000000000001,76.113333333333344,95.14166666666668,114.17,133.19833333333335,152.22666666666669,171.25500000000002,{"$f":"AE46*$U$34","v":190.28333333333336}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fleet",{"$f":"$M$8","v":"Chain"},{"$f":"U42","v":0},{"$f":"V47*$E$9","v":138000},{"$f":"W47*$E$9","v":276000},414000,552000,690000,828000,966000,1104000,1242000,1380000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T34","v":"CDX"},{"$f":"U43","v":0},{"$f":"V48*$E$9","v":57085.000000000007},114170.00000000001,171255,228340.00000000003,285425.00000000006,342510,399595.00000000006,456680.00000000006,513765.00000000006,570850.00000000012]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cashflow influence per time"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,6,12,18,24,30,36,42,48,54,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fleet",{"$f":"$M$8","v":"Chain"},{"$f":"AF64","v":45000},{"$f":"AF65","v":345000},{"$f":"AF66","v":645000},{"$f":"AF67","v":945000},{"$f":"AF68","v":1245000},{"$f":"AF69","v":1545000},{"$f":"AF70","v":1845000},{"$f":"AF71","v":2145000},{"$f":"AF72","v":2445000},{"$f":"AF73","v":2745000},{"$f":"AF74","v":3045000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T34","v":"CDX"},{"$f":"AG64","v":300000},{"$f":"AG65","v":300318.75},{"$f":"AG66","v":300637.5},{"$f":"AG67","v":300956.25},{"$f":"AG68","v":301275},{"$f":"AG69","v":301593.75},{"$f":"AG70","v":729412.5},{"$f":"AG71","v":729731.25},{"$f":"AG72","v":730050},{"$f":"AG73","v":730368.75},{"$f":"AG74","v":730687.5}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Used drives",null,"Start",null,"Repair",null,"Replaced",null,"Total",null,"Total fleet",null,null,"km per Repair only"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"months","km",{"$f":"$T$33","v":"Chain"},{"$f":"$T$34","v":"CDX"},{"$f":"$T$33","v":"Chain"},{"$f":"$T$34","v":"CDX"},{"$f":"$T$33","v":"Chain"},{"$f":"$T$34","v":"CDX"},{"$f":"$T$33","v":"Chain"},{"$f":"$T$34","v":"CDX"},{"$f":"$T$33","v":"Chain"},{"$f":"$T$34","v":"CDX"},{"$f":"$T$33","v":"Chain"},{"$f":"$T$34","v":"CDX"},null,{"$f":"$T$33","v":"Chain"},{"$f":"$T$34","v":"CDX"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"T64*$Z$32","v":0},{"$f":"FLOOR(U64/$W$33,1)","v":0},{"$f":"FLOOR(U64/$W$34,1)","v":0},{"$f":"$X$33","v":15},{"$f":"$X$34","v":100},0,0,0,0,{"$f":"AB64+Z64+X64","v":15},{"$f":"AC64+AA64+Y64","v":100},{"$f":"AD64*$E$9","v":45000},{"$f":"AE64*$E$9","v":300000},null,{"$f":"$E$15/$E$16","v":5000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"T65*$Z$32","v":5000},{"$f":"FLOOR(U65/$W$33,1)","v":1},{"$f":"FLOOR(U65/$W$34,1)","v":0},{"$f":"$X$33","v":15},{"$f":"$X$34","v":100},{"$f":"(($E$17*$E$18)+$E$19)*U65/$AI$64","v":42.5},{"$f":"(($E$17*$E$18)+$E$19)*(($O$1/12)*T65)","v":0.10625},{"$f":"V65*(X65+($E$17*$E$18)+$E$19)","v":57.5},{"$f":"W65*(Y65+($E$17*$E$18)+$E$19)","v":0},{"$f":"AB65+Z65+X65","v":115},{"$f":"AC65+AA65+Y65","v":100.10625},{"$f":"AD65*$E$9","v":345000},{"$f":"AE65*$E$9","v":300318.75}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,10000,{"$f":"FLOOR(U66/$W$33,1)","v":2},{"$f":"FLOOR(U66/$W$34,1)","v":0},15,100,{"$f":"(($E$17*$E$18)+$E$19)*U66/$AI$64","v":85},{"$f":"(($E$17*$E$18)+$E$19)*(($O$1/12)*T66)","v":0.21249999999999999},{"$f":"V66*(X66+($E$17*$E$18)+$E$19)","v":115},{"$f":"W66*(Y66+($E$17*$E$18)+$E$19)","v":0},{"$f":"AB66+Z66+X66","v":215},{"$f":"AC66+AA66+Y66","v":100.21250000000001},{"$f":"AD66*$E$9","v":645000},{"$f":"AE66*$E$9","v":300637.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,15000,3,0,15,100,127.5,0.31875000000000003,172.5,0,315,100.31874999999999,945000,300956.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,20000,4,0,15,100,170,0.42499999999999999,230,0,415,100.425,1245000,301275]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,25000,5,0,15,100,212.5,0.53125,287.5,0,515,100.53125,1545000,301593.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,30000,6,1,15,100,255,0.63750000000000007,345,142.5,615,243.13749999999999,1845000,729412.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,35000,7,1,15,100,297.5,0.74375000000000002,402.5,142.5,715,243.24375000000001,2145000,729731.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,40000,8,1,15,100,340,0.85,460,142.5,815,243.35,2445000,730050]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,45000,9,1,15,100,382.5,0.95625000000000016,517.5,142.5,915,243.45625000000001,2745000,730368.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,50000,10,1,15,100,425,1.0625,575,142.5,1015,243.5625,3045000,730687.5]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"# bikes",null,{"$f":"E9","v":3000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"# of defects per hub per year",null,{"$f":"E16","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Repair Turn Around Time",null,{"$f":"M17","v":4}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Out of order days per year",null,{"$f":"V84*V85","v":8}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Percentage out of order",null,{"$f":"V87/365","v":2.1917808219178082E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bikes out of order",null,{"$f":"V83*V89","v":65.753424657534254}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dead investment",null,{"$f":"V90*M11","v":59178.082191780828}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Investment value defective stock"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost of Ownership"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$M$8","v":"Chain"},null,null,{"$f":"W98/E15/E16","v":1}]