{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["1. Identify transport needs","2. Define fleet requirements","3. Make asset plan"],"read":"whole","date_system":"1900"}

{"sheet":"1. Identify transport needs","index":0,"n_rows":29,"n_cols":8,"rows_kept":29,"merged":[[2,1,2,6],[7,3,7,7]]}
["ASSET PLANNING TOOL"]
["1. Identify transport needs"]
[]
[]
[]
["Complete the table below for each program and for administrative activities. Then compile the totals and go to Step 2"]
[]
["Activities (per program)*","Number of people (including drivers) who will use the transport","Total days per month for the activity","Number of days required per month for each type of vehicles"]
["Identify activities that require transport ","Determine the number of people, who will use the transport in each activity.","Summarize the number of days for each vehicle type used for a specific activity","City sedan\n(e.g. Toyota Corolla)","Light Vehicle \n(e.g. Toyota Land Cruiser)","Trucks","Armoured \nVehicles","Mini-Bus"]
[]
["Field missions"]
["Staff transportation accomodation-office"]
["Support of daily admin activities"]
["Private use of vehicles"]
["Cargo movement"]
["Etc. (Add more activities if applicable)"]
{"$rows_empty":12}
["TOTAL NUMBER OF DAYS PER COLUMN"]

{"sheet":"2. Define fleet requirements","index":1,"n_rows":28,"n_cols":8,"rows_kept":28,"merged":[[7,3,7,7]]}
["ASSET PLANNING TOOL"]
["2. Define fleet requirements"]
[]
[]
["Country:"]
[]
["2019 Transport Needs"]
["Activity","Number of staff","Number of days per month","Type of vehicle required"]
["."," ","Column1","City sedan","Light Vehicle ","Trucks","Armoured \nVehicles","Mini-Bus"]
["(Insert program 1)"]
["(Insert program 2)"]
["(Insert program 3)"]
["Administration"]
[]
[]
["Total",null,null,{"$f":"SUM(D10:D15)","v":0},{"$f":"SUM(E10:E15)","v":0},0,null,0]
[]
[]
["number of working days",20]
["safety factor",{"v":0.1,"d":"10%"},null,"Safety factor can be adjusted based on nature of operation"]
[]
[]
["2019 Fleet Requirements"]
["Activity","City sedan","Light Vehicle ","Trucks","Armoured \nVehicles","Mini-Bus"]
["Total transport needs",{"$f":"D16","v":0},{"$f":"E16","v":0},0,0,{"$f":"H16","v":0}]
["Safety factor",{"$f":"B25*(100%+$B$20)","v":0},{"$f":"C25*(100%+$B$20)","v":0},0,{"$f":"E25*(100%+$B$20)","v":0},0]
["divided by nr of working days",{"$f":"B26/$B$19","v":0},{"$f":"C26/$B$19","v":0},0,{"$f":"E26/$B$19","v":0},0]
["rounded into whole number of vehicles"]

{"sheet":"3. Make asset plan","index":2,"n_rows":15,"n_cols":5,"rows_kept":15,"merged":[[2,1,2,4]]}
["ASSET PLANNING TOOL"]
["3. Make asset plan"]
[]
[]
[]
["Country:"]
[]
["2019 Asset Plan"]
[".","Current # vehicles","# vehicles needed","# vehicles to dispose","# vehicles to be ordered"]
["City sedan",null,{"$f":"'2. Define fleet requirements'!B$28","v":0},{"$f":"IF(Table16[[#This Row],[Current '# vehicles]]-Table16[[#This Row],['# vehicles needed]]>=0,Table16[[#This Row],[Current '# vehicles]]-Table16[[#This Row],['# vehicles needed]],0)","v":0},{"$f":"IF(Table16[[#This Row],['# vehicles needed]]-Table16[[#This Row],[Current '# vehicles]]>=0,Table16[[#This Row],['# vehicles needed]]-Table16[[#This Row],[Current '# vehicles]],0)","v":0}]
["Light Vehicle ",null,{"$f":"'2. Define fleet requirements'!C$28","v":0},{"$f":"IF(Table16[[#This Row],[Current '# vehicles]]-Table16[[#This Row],['# vehicles needed]]>=0,Table16[[#This Row],[Current '# vehicles]]-Table16[[#This Row],['# vehicles needed]],0)","v":0},{"$f":"IF(Table16[[#This Row],['# vehicles needed]]-Table16[[#This Row],[Current '# vehicles]]>=0,Table16[[#This Row],['# vehicles needed]]-Table16[[#This Row],[Current '# vehicles]],0)","v":0}]
["Trucks",null,{"$f":"'2. Define fleet requirements'!D$28","v":0},{"$f":"IF(Table16[[#This Row],[Current '# vehicles]]-Table16[[#This Row],['# vehicles needed]]>=0,Table16[[#This Row],[Current '# vehicles]]-Table16[[#This Row],['# vehicles needed]],0)","v":0},{"$f":"IF(Table16[[#This Row],['# vehicles needed]]-Table16[[#This Row],[Current '# vehicles]]>=0,Table16[[#This Row],['# vehicles needed]]-Table16[[#This Row],[Current '# vehicles]],0)","v":0}]
["Armoured Vehicles",null,{"$f":"'2. Define fleet requirements'!E$28","v":0},{"$f":"IF(Table16[[#This Row],[Current '# vehicles]]-Table16[[#This Row],['# vehicles needed]]>=0,Table16[[#This Row],[Current '# vehicles]]-Table16[[#This Row],['# vehicles needed]],0)","v":0},{"$f":"IF(Table16[[#This Row],['# vehicles needed]]-Table16[[#This Row],[Current '# vehicles]]>=0,Table16[[#This Row],['# vehicles needed]]-Table16[[#This Row],[Current '# vehicles]],0)","v":0}]
["Mini-Bus",null,{"$f":"'2. Define fleet requirements'!F$28","v":0},{"$f":"IF(Table16[[#This Row],[Current '# vehicles]]-Table16[[#This Row],['# vehicles needed]]>=0,Table16[[#This Row],[Current '# vehicles]]-Table16[[#This Row],['# vehicles needed]],0)","v":0},{"$f":"IF(Table16[[#This Row],['# vehicles needed]]-Table16[[#This Row],[Current '# vehicles]]>=0,Table16[[#This Row],['# vehicles needed]]-Table16[[#This Row],[Current '# vehicles]],0)","v":0}]
["Total",null,{"$f":"'2. Define fleet requirements'!B33","v":0},{"$f":"SUM(D10:D14)","v":0},{"$f":"SUM(E10:E14)","v":0}]