Assistant Operations Manager (AOM) Hourly DBR Confirmation Check
AOMs must check for Pending DBRs every hour and fill out their market tracker with the number confirmed.
Time Required: 1 minute (30 seconds computer work, 30 seconds staff engagement)
1. Remind Nesters to submit DBRs
2. Open Air Control
3. Click Batteries
4. Click Check Mark in Top Left Corner
5. Click ‘Approve’
6. Fill out market tracker with the number of DBRs confirmed
AOM/OM EOS DBR Confirmation Check
At the end of shift AOMs must do a final check of pending DBRs, conduct a final floor walk, and notate the total number of batteries confirmed in their EOS document.
Time Required: 5 minutes (1 min computer work and 4 mins of floor walk + staff engagement)
1. Remind Nesters to submit DBRs
2. Open Air Control
3. Click Batteries
4. Spot check serial numbers against blue bins to ensure label and packing is correct
5. Click Check Mark in Top Left Corner
6. Click ‘Approve’
7. Notate number of batteries confirmed during shift in EOS document (sum hourly tracker)
AOM and NOC Review Process
Responsible: NOC and BKN AOMs
Conduct the following at the following interval (Nationwide):
NOC – 9 AM and 5 PM BKN AOMs – 1 PM, 930 PM, 3 AM
Time Required: 5-10 minutes
1. Open Air Control
2. Go to Reports
3. Go to Battery Swap
4. Open ‘Battery BTS Scan Tracker’
5. Adjust dates to previous day and two days in the future (for example if the day is 4/9, set the date filters to 4/8 and 4/11)
6. Click Run
7. Sort file to make sure there is data from the past hour
a. If there is data from the last hour, continue to step 8
b. If there is not data from the last hour, set the date to 3 days out and click Run, if there still is no recent data, refresh and start again at step 5
c. If you have repeated steps 5-7 and it is not resolved, escalate to Peter Bengtson, Valentin Benitez, and Jessica Theriault
8. Click Export
9. Open file “ac_battery_bts_scan_tracker-1_0_bts_scan_result” followed by a string of letters and numbers
a. It will be the largest file
10. Highlight Row 1
11. Click ‘Data’ in the Top Ribbon
12. Click ‘Filter’
13. Highlight Column C
14. Click ‘Home’ in the Top Ribbon
15. Click the Format drop down
16. Select more number formats
17. Click Custom
18. Scroll down and select ‘m/d/yyyy h:mm’
19. Click apply
20. Click the drop down in Column D
21. Select ‘BATTERY_FAILED_DAMAGED’ and ‘BATTERY_FAILED’
22. Click the drop down in Column C
23. Sort Newest to Oldest
24. Select all the Battery Serial numbers from the last time this check was done
a. To determine the last time the check was done, please refer to the DBR Audit Log
25. Copy all the columns down to where the last check was done
26. Open a new sheet
27. Paste into new sheet
28. Select all columns
29. Click ‘Data’ in the Top Ribbon
30. Click ‘Remove Duplicates’
31. Deselect all Columns besides ‘battery_serial_number’
32. Click OK in the pop-up window
33. Click OK
34. Open Air Control on a second screen
a. If no second screen available, use the computers' ability to open the two windows on one screen
35. Select ‘Citi Bike’
36. Click ‘Fleet’
37. Click ‘Batteries’
38. Click ‘Damaged’
39. Sort by ‘Reported at’
a. Ensure the newest are at the top
40. At bottom of page, adjust ‘rows per page’ to make sure it includes the number of unique records
a. For example, if there were16 unique serial numbers, change rows to 25
41. Confirm each of the unique S/Ns has a DBR and place an x in column F to track
a. Look for the last 5 of the Battery S/Ns
b. If unable to find a record, try ctrl F
42. If all unique S/Ns are found to have DBRs skip to step 49
43. In the URL of AC, highlight everything to the right of the word ‘Depot’
44. Press Backslash
45. Search for any unique S/N not found
46. If battery is confirmed damaged, place an x in column B
47. If battery is not confirmed damaged, report status and market in column B and C
a. This will be used for follow-up in step 49
48. Repeat until all batteries have been confirmed or their status is in Column B
49. Create post on ‘DBR Audit Escalations’ Team and tag the market to inform the MOD to review any unconfirmed batteries and request they either action the pending battery or search for the un-DBR'd battery
50. Fill out tracking sheet column definitions below:
a. Date – date of scheduled audit
b. Day – day of scheduled audit
c. Hour- hour of scheduled audit
d. Responsible – AOM/NOC responsibility for the audit
e. MOD Initials – Auditors initials
f. Batteries Audited – count of number of batteries checked for DBR
g. Local Follow Up Required – were there any missed
h. Most Recent Damage Checked – Date/Time of most recent battery checked for DBR (where the next auditor should start from)
51. Audit now complete