Anyone know I can get a spreadsheet that is organized one way into an Access database that is setup different. I have attached the spreadsheet and what the data table looks like.
Week Ending: | |||||||||
MONDAY | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
5 PM E | 9 | 4 | 2 | 3 | |||||
Total Blue 1 | 9 | 4 | 0 | 0 | 0 | 2 | 3 | $ - | $ 3.00 |
MONDAY | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
4:30 PM W | 15 | 6 | 6 | 1 | 1 | 1 | |||
Total Blue 2 | 15 | 6 | 0 | 6 | 1 | 1 | 1 | $ - | $ 7.50 |
MONDAY | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
5 PM W | 10 | 7 | 2 | 1 | |||||
Total Blue 3 | 10 | 7 | 0 | 2 | 0 | 1 | 0 | $ - | $ 6.00 |
MONDAY | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
5:30 PM W | 10 | 7 | 2 | 1 | |||||
Total Blue 4 | 10 | 7 | 0 | 2 | 0 | 1 | 0 | $ - | $ 6.00 |
MONDAY | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
5:39 PM N/S | 32 | 23 | 1 | 7 | 1 | ||||
Total Red 1 | 32 | 23 | 0 | 1 | 0 | 7 | 1 | $ - | $ 19.00 |
MONDAY | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
5:40 PM S/N | 28 | 9 | 16 | 2 | 1 | ||||
Total Red 1 | 28 | 9 | 0 | 16 | 0 | 2 | 1 | $ - | $ 12.50 |
Monday Totals | |||||||||
Blue Route | 44 | 24 | 0 | 10 | 1 | 5 | 4 | $ - | $ 22.50 |
Red Route | 60 | 32 | 0 | 17 | 0 | 9 | 2 | $ - | $ 31.50 |
Special Service | |||||||||
MONDAY TOTAL | 104 | 56 | 0 | 27 | 1 | 14 | 6 | $ - | $ 54.00 |
Tuesday | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
5 PM E | 15 | 7 | 5 | 1 | 1 | 1 | |||
Total Blue 1 | 15 | 7 | 0 | 5 | 1 | 1 | 1 | $ - | $ 4.50 |
Tuesday | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
4:30 PM W | 17 | 11 | 2 | 2 | 2 | ||||
Total Blue 2 | 17 | 11 | 0 | 2 | 0 | 2 | 2 | $ - | $ 9.50 |
Tuesday | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
5 PM W | 9 | 8 | 1 | ||||||
Total Blue 3 | 9 | 8 | 0 | 1 | 0 | 0 | 0 | $ - | $ 7.00 |
Tuesday | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
5:30 PM W | 7 | 5 | 1 | 1 | |||||
Total Blue 4 | 7 | 5 | 0 | 0 | 0 | 1 | 1 | $ - | $ 4.00 |
Tuesday | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
5:39 PM N/S | 29 | 15 | 7 | 2 | 5 | ||||
Total Red 1 | 29 | 15 | 0 | 7 | 0 | 2 | 5 | $ 16.00 | |
Tuesday | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
5:40 PM S/N | 28 | 9 | 10 | 1 | 5 | 3 | |||
Total Red 1 | 28 | 9 | 0 | 10 | 1 | 5 | 3 | $ - | |
Tuesday Totals | |||||||||
Blue Route | 48 | 31 | 0 | 8 | 1 | 4 | 4 | $ - | $ 25.00 |
Red Route | 57 | 24 | 0 | 17 | 1 | 7 | 8 | $ - | $ 16.00 |
Special Service | |||||||||
Tuesday TOTAL | 105 | 55 | 0 | 25 | 2 | 11 | 12 | $ - | $ 41.00 |
Wednesday | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
5 PM E | 19 | 5 | 8 | 3 | 3 | ||||
Total Blue 1 | 19 | 5 | 0 | 8 | 3 | 3 | 0 | $ - | $ 5.00 |
Wednesday | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
4:30 PM W | 11 | 10 | 1 | ||||||
Total Blue 2 | 11 | 10 | 0 | 1 | 0 | 0 | 0 | $ - | $ 4.00 |
Wednesday | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
5 PM W | 12 | 2 | 6 | 2 | 2 | ||||
Total Blue 3 | 12 | 2 | 0 | 6 | 0 | 2 | 2 | $ - | $ 1.00 |
Wednesday | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
5:30 PM W | 15 | 8 | 2 | 3 | 2 | ||||
Total Blue 4 | 15 | 8 | 0 | 2 | 0 | 3 | 2 | $ - | $ 7.00 |
Wednesday | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
5:39 PM N/S | 32 | 23 | 6 | 3 | |||||
Total Red 1 | 32 | 23 | 0 | 0 | 0 | 6 | 3 | $ - | $ 20.00 |
Wednesday | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
5:40 PM S/N | 31 | 24 | 7 | ||||||
Total Red 1 | 31 | 24 | 0 | 0 | 0 | 7 | 0 | $ - | $ 17.00 |
Wednesday Totals | |||||||||
Blue Route | 57 | 25 | 0 | 17 | 3 | 8 | 4 | $ - | $ 17.00 |
Red Route | 63 | 47 | 0 | 0 | 0 | 13 | 3 | $ - | $ 37.00 |
Special Service | |||||||||
Wednesday TOTAL | 120 | 72 | 0 | 17 | 3 | 21 | 7 | $ - | $ 54.00 |
Thursday | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
5 PM E | 14 | 10 | 1 | 2 | 1 | ||||
Total Blue 1 | 14 | 10 | 0 | 1 | 0 | 2 | 1 | $ - | $ 9.00 |
Thursday | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
4:30 PM W | 14 | 4 | 4 | 1 | 5 | ||||
Total Blue 2 | 14 | 4 | 0 | 4 | 1 | 5 | 0 | $ - | $ 2.50 |
Thursday | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
5 PM W | 17 | 4 | 8 | 1 | 4 | ||||
Total Blue 3 | 17 | 4 | 0 | 8 | 1 | 4 | 0 | $ - | $ 3.50 |
Thursday | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
5:30 PM W | 7 | 5 | 1 | 1 | |||||
Total Blue 4 | 7 | 5 | 0 | 1 | 0 | 1 | 0 | $ - | $ 3.50 |
Thursday | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
5:39 PM N/S | 40 | 23 | 4 | 7 | 6 | ||||
Total Red 1 | 40 | 23 | 0 | 4 | 0 | 7 | 6 | $ - | $ 17.00 |
Thursday | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
5:40 PM S/N | 40 | 27 | 4 | 1 | 4 | 4 | |||
Total Red 1 | 40 | 27 | 0 | 4 | 1 | 4 | 4 | $ - | $ 20.50 |
Thursday Totals | 3 | ||||||||
Blue Route | 52 | 23 | 0 | 14 | 2 | 12 | 1 | $ - | $ 18.50 |
Red Route | 80 | 50 | 0 | 8 | 1 | 11 | 10 | $ - | $ 37.50 |
Special Service | |||||||||
Thursday TOTAL | 132 | 73 | 0 | 22 | 3 | 23 | 11 | $ - | $ 56.00 |
Friday | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
5 PM E | 9 | 6 | 1 | 2 | |||||
Total Blue 1 | 9 | 6 | 0 | 1 | 0 | 2 | 0 | $ - | $ 4.50 |
Friday | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
4:30 PM W | 11 | 5 | 5 | 1 | |||||
Total Blue 2 | 11 | 5 | 0 | 5 | 1 | 0 | 0 | $ - | $ 3.50 |
Friday | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
5 PM W | 7 | 2 | 1 | 2 | 2 | ||||
Total Blue 3 | 7 | 2 | 0 | 1 | 0 | 2 | 2 | $ - | $ 1.50 |
Friday | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
5:30 PM W | 17 | 8 | 5 | 2 | 2 | ||||
Total Blue 4 | 17 | 8 | 0 | 5 | 2 | 2 | 0 | $ - | $ 5.00 |
Friday | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
5:39 PM N/S | 77 | 14 | 1 | 61 | 1 | ||||
Total Red 1 | 77 | 14 | 0 | 1 | 0 | 61 | 1 | $ - | $ 11.00 |
Friday | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
5:40 PM S/N | 28 | 14 | 12 | 2 | |||||
Total Red 1 | 28 | 14 | 0 | 12 | 0 | 2 | 0 | $ - | $ 16.00 |
Friday Totals | |||||||||
Blue Route | 44 | 21 | 0 | 12 | 3 | 6 | 2 | $ - | $ 14.50 |
Red Route | 54 | 28 | 0 | 13 | 0 | 63 | 1 | $ - | $ 27.00 |
Special Service | 15 | ||||||||
Friday TOTAL | 113 | 49 | 0 | 25 | 3 | 69 | 3 | $ - | $ 41.50 |
Saturday | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
5 PM E | 32 | 26 | 3 | 3 | |||||
Total Blue 1 | 32 | 26 | 0 | 0 | 0 | 3 | 3 | $ - | $ 20.00 |
Saturday | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
7:30 AM E | 0 | ||||||||
8:30 AM W | 0 | ||||||||
9:30 AM E | 0 | ||||||||
10:30 AM W | 0 | ||||||||
11:30 AM E | 0 | ||||||||
12:30 PM W | 0 | ||||||||
1:30 PM E | 0 | ||||||||
2:30 PM W | 0 | ||||||||
3:30 PM E | 0 | ||||||||
4:30 PM W | 0 | ||||||||
Total Blue 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $ - | $ - |
Saturday | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
8 AM E | 0 | ||||||||
9 AM W | 0 | ||||||||
10 AM E | 0 | ||||||||
11 AM W | 0 | ||||||||
12 PM E | 0 | ||||||||
1 PM W | 0 | ||||||||
2 PM E | 0 | ||||||||
3 PM W | 0 | ||||||||
4 PM E | 0 | ||||||||
5 PM W | 0 | ||||||||
Total Blue 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $ - | $ - |
Saturday | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
8:30 AM E | 0 | ||||||||
9:30 AM W | 0 | ||||||||
10:30 AM E | 0 | ||||||||
11:30 AM W | 0 | ||||||||
12:30 PM E | 0 | ||||||||
1:30 PM W | 0 | ||||||||
2:30 PM E | 0 | ||||||||
3:30 PM W | 0 | ||||||||
4:30 PM E | 0 | ||||||||
5:30 PM W | 0 | ||||||||
Total Blue 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $ - | $ - |
Saturday | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
5:39 PM N/S | 25 | 18 | 1 | 2 | 4 | ||||
Total Red 1 | 25 | 18 | 0 | 0 | 1 | 2 | 4 | $ - | $ 11.50 |
Saturday | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
5:40 PM S/N | 11 | 5 | 4 | 2 | |||||
Total Red 1 | 11 | 5 | 0 | 4 | 0 | 2 | 0 | $ - | $ 5.00 |
Saturday Totals | |||||||||
Blue Route | 32 | 26 | 0 | 0 | 0 | 3 | 3 | $ - | $ 20.00 |
Red Route | 36 | 23 | 0 | 4 | 1 | 4 | 4 | $ - | $ 16.50 |
Special Service | |||||||||
Saturday TOTAL | 68 | 49 | 0 | 4 | 1 | 7 | 7 | $ - | $ 36.50 |
WEEKLY TOTALS | Total Trips | Pax (5-65) | Pax <5 | Senior/DA | ADA-Flex | Transfers | Promo/Free | TICKET BOOKS | FARE REVENUE |
Blue Route | 277 | 150 | 0 | 61 | 10 | 38 | 18 | $ - | $ 117.50 |
Red Route | 350 | 204 | 0 | 59 | 3 | 107 | 28 | $ - | $ 165.50 |
Special Service | 15 | 0 | 0 | 0 | 0 | 0 | 0 | $ - | $ - |
Total for Week | 642 | 354 | 0 | 120 | 13 | 145 | 46 | $ - | $ 283.00 |