Attachment - Historical Data.xlsx
XLSX spreadsheet 22 KB Posted
- Solicitation number
- 36C25226Q0498
About this file
This is a historical data spreadsheet containing transportation utilization metrics for the Edward Hines VA Hospital. The data spans from October 2024 through August 2025 and tracks daily transportation activity across multiple months, recording three key metrics: sedan trips, wheelchair-accessible vehicle trips, and miles traveled. The spreadsheet is organized chronologically by month with daily row entries and monthly subtotals, capturing transportation demand patterns that appear to support Special Mode Transportation services for Veterans Health Administration patients.
The data reveals significant monthly variation in transportation usage, with total monthly sedan trips ranging from approximately 71 to 529 instances and wheelchair-accessible vehicle trips ranging from 82 to 447 instances per month. Total monthly mileage similarly varies widely, from 1,116 to 5,384 miles depending on the period. This historical utilization data serves as a baseline for forecasting transportation requirements and staffing needs under the V212 Special Mode Transportation contract for Edward Hines VA Hospital under the Department of Veterans Affairs Veterans Health Administration Veterans Integrated Service Network 12. The granular daily breakdowns enable analysis of transportation demand patterns to support capacity planning and resource allocation decisions.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| S02 - 36C25226Q0498 0003.docx | DOCX document | |
| S02 - 2015-5741.txt | TXT text file | |
| S02 - 2015-5035.txt | TXT text file | |
| S02 - 2015-4899.txt | TXT text file | |
| BAA SAMPLE.pdf | ||
| 36C25226Q0498 0002.docx | DOCX document | |
| S02 - 2015-5017.txt | TXT text file | |
| S02 - 2015-5025.txt | TXT text file | |
| S02 - 2015-5019.txt | TXT text file | |
| 36C25226Q0498 0001_1.docx | DOCX document | |
| 36C25226Q0498 0001.docx | DOCX document | |
| 36C25226Q0498_1.docx | DOCX document |
Show all 12
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Sheet1
| Transpo | |||||||||||
| 2024 October | Sedan | Wheelchair | Miles over 30 | 2025 March | Sedan | Wheelchair | Miles over 30 | 2025 August | Sedan | Wheelchair | Miles over 30 |
| 1 | 83 | 81 | 700 | 1 | 12 | 20 | 71 | 1 | 59 | 46 | 785 |
| 2 | 103 | 89 | 1109 | 2 | 0 | 0 | 0 | 2 | 5 | 15 | 0 |
| 3 | 98 | 85 | 554 | Total | 12 | 20 | 71 | 3 | 2 | 1 | 188 |
| 4 | 85 | 68 | 352 | Total | 66 | 62 | 973 | ||||
| 5 | 18 | 15 | 10 | 3 | 68 | 67 | 527 | ||||
| 6 | 5 | 0 | 376 | 4 | 64 | 78 | 613 | 4 | 66 | 72 | 925 |
| Total | 392 | 338 | 3101 | 5 | 71 | 74 | 497 | 5 | 53 | 54 | 911 |
| 6 | 59 | 71 | 1065 | 6 | 57 | 73 | 544 | ||||
| 7 | 106 | 88 | 560 | 7 | 48 | 62 | 988 | 7 | 63 | 64 | 872 |
| 8 | 79 | 91 | 486 | 8 | 10 | 18 | 10 | 8 | 57 | 60 | 744 |
| 9 | 118 | 74 | 1056 | 9 | 1 | 1 | 156 | 9 | 10 | 15 | 302 |
| 10 | 110 | 70 | 743 | Total | 321 | 371 | 3856 | 10 | 2 | 0 | 19 |
| 11 | 100 | 60 | 1231 | Total | 308 | 338 | 4493 | ||||
| 12 | 15 | 16 | 177 | 10 | 72 | 77 | 922 | ||||
| 13 | 1 | 0 | 0 | 11 | 67 | 83 | 657 | 11 | 72 | 63 | 774 |
| Total | 529 | 399 | 4253 | 12 | 58 | 68 | 757 | 12 | 63 | 68 | 832 |
| 13 | 72 | 84 | 675 | 13 | 67 | 69 | 900 | ||||
| 14 | 12 | 20 | 66 | 14 | 54 | 49 | 831 | 14 | 59 | 62 | 931 |
| 15 | 78 | 126 | 1205 | 15 | 12 | 17 | 10 | 15 | 61 | 65 | 1043 |
| 16 | 88 | 82 | 563 | 16 | 0 | 0 | 0 | 16 | 11 | 10 | 10 |
| 17 | 126 | 68 | 1152 | Total | 335 | 378 | 3852 | 17 | 1 | 1 | 312 |
| 18 | 71 | 64 | 1117 | Total | 334 | 338 | 4802 | ||||
| 19 | 15 | 15 | 10 | 17 | 76 | 76 | 679 | ||||
| 20 | 1 | 0 | 81 | 18 | 64 | 94 | 974 | 18 | 77 | 60 | 1099 |
| Total | 391 | 375 | 4194 | 19 | 64 | 66 | 450 | 19 | 59 | 74 | 266 |
| 20 | 54 | 56 | 566 | 20 | 7 | 6 | 35 | ||||
| 21 | 83 | 108 | 1532 | 21 | 47 | 54 | 500 | 21 | 73 | 61 | 303 |
| 22 | 81 | 74 | 879 | 22 | 10 | 18 | 10 | 22 | 52 | 40 | 888 |
| 23 | 85 | 89 | 850 | 23 | 1 | 0 | 158 | 23 | 11 | 14 | 59 |
| 24 | 115 | 78 | 1073 | Total | 316 | 364 | 3337 | 24 | 2 | 0 | 126 |
| 25 | 74 | 62 | 647 | Total | 281 | 255 | 2776 | ||||
| 26 | 12 | 12 | 197 | 24 | 62 | 80 | 1079 | ||||
| 27 | 3 | 0 | 206 | 25 | 68 | 72 | 455 | 25 | 71 | 68 | 604 |
| Total | 453 | 423 | 5384 | 26 | 65 | 64 | 370 | 26 | 64 | 52 | 396 |
| 27 | 70 | 82 | 694 | 27 | 82 | 68 | 381 | ||||
| 28 | 87 | 79 | 788 | 28 | 44 | 55 | 320 | 28 | 61 | 57 | 239 |
| 29 | 82 | 69 | 854 | 29 | 12 | 18 | 161 | 29 | 48 | 45 | 531 |
| 30 | 90 | 75 | 853 | 30 | 2 | 0 | 347 | 30 | 12 | 8 | 10 |
| 31 | 86 | 67 | 484 | Total | 323 | 371 | 3426 | 31 | 0 | 0 | 0 |
| Total | 345 | 290 | 2979 | Total | 338 | 298 | 2161 | ||||
| November | 31 | 83 | 57 | 625 | |||||||
| 1 | 81 | 63 | 1304 | 83 | 57 | 625 | September | ||||
| 2 | 13 | 19 | 330 | 1 | 8 | 19 | 310 | ||||
| 3 | 3 | 0 | 253 | April | 2 | 43 | 62 | 589 | |||
| Total | 97 | 82 | 1887 | 1 | 58 | 69 | 567 | 3 | 19 | 19 | 199 |
| 2 | 54 | 61 | 448 | 4 | 1 | 2 | 18 | ||||
| 4 | 95 | 73 | 635 | 3 | 53 | 77 | 775 | 5 | 0 | 0 | 0 |
| 5 | 94 | 90 | 1043 | 4 | 57 | 55 | 796 | 6 | 0 | 0 | 0 |
| 6 | 107 | 80 | 676 | 5 | 10 | 19 | 130 | 7 | 0 | 0 | 0 |
| 7 | 101 | 56 | 508 | 6 | 3 | 0 | 172 | Total | 71 | 102 | 1116 |
| 8 | 84 | 49 | 986 | Total | 245 | 281 | 2888 | ||||
| 9 | 15 | 17 | 7 | 8 | 58 | 63 | 573 | ||||
| 10 | 0 | 0 | 0 | 7 | 81 | 67 | 501 | 9 | 61 | 59 | 479 |
| Total | 496 | 365 | 3855 | 8 | 51 | 72 | 584 | 10 | 58 | 70 | 766 |
| 9 | 67 | 50 | 729 | 11 | 45 | 72 | 446 | ||||
| 11 | 15 | 20 | 50 | 10 | 58 | 83 | 1006 | 12 | 45 | 81 | 569 |
| 12 | 76 | 96 | 672 | 11 | 59 | 48 | 716 | 13 | 12 | 12 | 370 |
| 13 | 107 | 72 | 681 | 12 | 14 | 19 | 466 | 14 | 2 | 2 | 101 |
| 14 | 91 | 82 | 648 | 13 | 2 | 0 | 60 | Total | 281 | 359 | 3304 |
| 15 | 74 | 67 | 853 | Total | 332 | 339 | 4062 | ||||
| 16 | 21 | 14 | 604 | 15 | 47 | 67 | 931 | ||||
| 17 | 1 | 0 | 0 | 14 | 70 | 92 | 1239 | 16 | 49 | 84 | 402 |
| Total | 385 | 351 | 3508 | 15 | 53 | 62 | 682 | 17 | 58 | 67 | 811 |
| 16 | 57 | 81 | 495 | 18 | 62 | 55 | 301 | ||||
| 18 | 92 | 69 | 1300 | 17 | 90 | 74 | 945 | 19 | 51 | 63 | 885 |
| 19 | 108 | 98 | 914 | 18 | 64 | 56 | 881 | 20 | 11 | 12 | 280 |
| 20 | 100 | 95 | 674 | 19 | 10 | 17 | 36 | 21 | 2 | 0 | 97 |
| 21 | 79 | 92 | 890 | 20 | 0 | 0 | 0 | Total | 280 | 348 | 3707 |
| 22 | 66 | 75 | 448 | Total | 344 | 382 | 4278 | ||||
| 23 | 17 | 18 | 33 | 22 | 67 | 69 | 516 | ||||
| 24 | 2 | 0 | 0 | 21 | 73 | 75 | 1080 | 23 | 51 | 66 | 1348 |
| Total | 464 | 447 | 4259 | 22 | 61 | 77 | 914 | 24 | 63 | 67 | 840 |
| 23 | 57 | 72 | 485 | 25 | 47 | 71 | 378 | ||||
| 25 | 93 | 69 | 988 | 24 | 75 | 88 | 1017 | 26 | 58 | 68 | 793 |
| 26 | 83 | 72 | 699 | 25 | 57 | 71 | 706 | 27 | 5 | 18 | 138 |
| 27 | 75 | 68 | 515 | 26 | 11 | 15 | 5 | 28 | 3 | 0 | 95 |
| 28 | 6 | 12 | 10 | 27 | 3 | 0 | 11 | Total | 294 | 359 | 4108 |
| 29 | 70 | 47 | 585 | Total | 337 | 398 | 4218 | ||||
| 30 | 13 | 18 | 10 | 29 | 79 | 71 | 528 | ||||
| Total | 340 | 286 | 2807 | 28 | 62 | 70 | 944 | 30 | 55 | 67 | 728 |
| 29 | 57 | 73 | 508 | Total | 134 | 138 | 1256 | ||||
| December | 30 | 66 | 72 | 595 | |||||||
| 1 | 0 | 0 | 0 | Total | 185 | 215 | 2047 | ||||
| 2 | 70 | 78 | 1098 | ||||||||
| 3 | 80 | 90 | 439 | May | |||||||
| 4 | 78 | 83 | 564 | 1 | 48 | 70 | 1176 | ||||
| 5 | 68 | 88 | 489 | 2 | 53 | 62 | 630 | ||||
| 6 | 52 | 69 | 729 | 3 | 6 | 20 | 337 | ||||
| 7 | 16 | 13 | 123 | 4 | 3 | 0 | 0 | ||||
| 8 | 2 | 0 | 0 | Total | 110 | 152 | 2143 | ||||
| Total | 366 | 421 | 3442 | ||||||||
| 5 | 61 | 78 | 420 | ||||||||
| 9 | 83 | 59 | 335 | 6 | 68 | 89 | 511 | ||||
| 10 | 86 | 87 | 1088 | 7 | 67 | 75 | 679 | ||||
| 11 | 78 | 62 | 849 | 8 | 70 | 74 | 471 | ||||
| 12 | 79 | 83 | 1007 | 9 | 44 | 57 | 434 | ||||
| 13 | 66 | 48 | 438 | 10 | 6 | 22 | 10 | ||||
| 14 | 19 | 12 | 124 | 11 | 4 | 0 | 226 | ||||
| 15 | 1 | 0 | 1 | Total | 320 | 395 | 2751 | ||||
| Total | 412 | 351 | 3842 | ||||||||
| 12 | 63 | 83 | 646 | ||||||||
| 16 | 82 | 94 | 392 | 13 | 66 | 69 | 882 | ||||
| 17 | 88 | 71 | 604 | 14 | 59 | 55 | 292 | ||||
| 18 | 81 | 89 | 417 | 15 | 83 | 72 | 607 | ||||
| 19 | 92 | 75 | 545 | 16 | 45 | 58 | 501 | ||||
| 20 | 48 | 78 | 646 | 17 | 13 | 20 | 10 | ||||
| 21 | 15 | 16 | 16 | 18 | 3 | 0 | 277 | ||||
| 22 | 9 | 14 | 50 | Total | 332 | 357 | 3215 | ||||
| Total | 415 | 437 | 2670 | ||||||||
| 19 | 65 | 70 | 341 | ||||||||
| 23 | 59 | 92 | 512 | 20 | 70 | 81 | 1174 | ||||
| 24 | 36 | 29 | 36 | 21 | 43 | 79 | 609 | ||||
| 25 | 0 | 0 | 0 | 22 | 77 | 62 | 619 | ||||
| 26 | 46 | 52 | 204 | 23 | 50 | 62 | 711 | ||||
| 27 | 45 | 52 | 191 | 24 | 13 | 18 | 273 | ||||
| 28 | 11 | 15 | 13 | 25 | 0 | 0 | 0 | ||||
| 29 | 10 | 12 | 50 | Total | 318 | 372 | 3727 | ||||
| Total | 207 | 252 | 1286 | ||||||||
| 26 | 10 | 18 | 50 | ||||||||
| 30 | 68 | 74 | 871 | 27 | 53 | 93 | 1192 | ||||
| 31 | 73 | 43 | 290 | 28 | 55 | 69 | 247 | ||||
| Total | 141 | 117 | 1161 | 29 | 61 | 77 | 384 | ||||
| 30 | 54 | 62 | 699 | ||||||||
| 2025 January | 31 | 14 | 17 | 379 | |||||||
| 1 | 1 | 1 | 2 | Total | 247 | 336 | 2951 | ||||
| 2 | 67 | 69 | 264 | ||||||||
| 3 | 58 | 73 | 353 | June | |||||||
| 4 | 10 | 16 | 174 | 1 | 2 | 1 | 597 | ||||
| 5 | 2 | 0 | 131 | Total | 2 | 1 | 597 | ||||
| Total | 138 | 159 | 924 | ||||||||
| 2 | 76 | 65 | 661 | ||||||||
| 6 | 80 | 84 | 414 | 3 | 52 | 88 | 474 | ||||
| 7 | 67 | 84 | 592 | 4 | 54 | 66 | 443 | ||||
| 8 | 75 | 75 | 750 | 5 | 77 | 52 | 565 | ||||
| 9 | 50 | 61 | 307 | 6 | 52 | 45 | 144 | ||||
| 10 | 58 | 66 | 444 | 7 | 11 | 12 | 348 | ||||
| 11 | 11 | 15 | 5 | 8 | 3 | 0 | 174 | ||||
| 12 | 1 | 0 | 35 | Total | 325 | 328 | 2809 | ||||
| Total | 342 | 385 | 2547 | ||||||||
| 9 | 68 | 68 | 688 | ||||||||
| 13 | 87 | 81 | 1158 | 10 | 44 | 67 | 475 | ||||
| 14 | 79 | 69 | 535 | 11 | 65 | 69 | 412 | ||||
| 15 | 94 | 96 | 287 | 12 | 66 | 67 | 399 | ||||
| 16 | 92 | 81 | 1004 | 13 | 55 | 61 | 817 | ||||
| 17 | 57 | 47 | 273 | 14 | 8 | 19 | 217 | ||||
| 18 | 13 | 20 | 10 | 15 | 2 | 0 | 22 | ||||
| 19 | 0 | 0 | 0 | Total | 308 | 351 | 3030 | ||||
| Total | 422 | 394 | 3267 | ||||||||
| 16 | 66 | 63 | 846 | ||||||||
| 20 | 14 | 17 | 50 | 17 | 61 | 46 | 317 | ||||
| 21 | 53 | 82 | 547 | 18 | 62 | 85 | 1167 | ||||
| 22 | 81 | 84 | 729 | 19 | 12 | 20 | 271 | ||||
| 23 | 68 | 78 | 591 | 20 | 56 | 59 | 748 | ||||
| 24 | 60 | 57 | 186 | 21 | 12 | 19 | 294 | ||||
| 25 | 11 | 21 | 61 | 22 | 1 | 0 | 66 | ||||
| 26 | 1 | 0 | 0 | Total | 270 | 292 | 3709 | ||||
| Total | 288 | 339 | 2164 | ||||||||
| 23 | 71 | 74 | 1089 | ||||||||
| 27 | 74 | 79 | 889 | 24 | 64 | 57 | 433 | ||||
| 28 | 83 | 79 | 786 | 25 | 77 | 65 | 392 | ||||
| 29 | 79 | 63 | 526 | 26 | 82 | 77 | 355 | ||||
| 30 | 86 | 81 | 937 | 27 | 55 | 53 | 270 | ||||
| 31 | 66 | 70 | 762 | 28 | 18 | 12 | 296 | ||||
| Total | 388 | 372 | 3900 | 29 | 1 | 0 | 0 | ||||
| Total | 368 | 338 | 2835 | ||||||||
| February | |||||||||||
| 1 | 10 | 20 | 267 | 30 | 66 | 66 | 600 | ||||
| 2 | 0 | 0 | 0 | Total | 66 | 66 | 600 | ||||
| Total | 10 | 20 | 267 | ||||||||
| July | |||||||||||
| 3 | 70 | 63 | 659 | 1 | 55 | 67 | 470 | ||||
| 4 | 76 | 86 | 780 | 2 | 67 | 71 | 455 | ||||
| 5 | 84 | 87 | 766 | 3 | 68 | 64 | 500 | ||||
| 6 | 79 | 72 | 322 | 4 | 12 | 18 | 68 | ||||
| 7 | 66 | 61 | 527 | 5 | 10 | 15 | 17 | ||||
| 8 | 12 | 20 | 397 | 6 | 2 | 0 | 31 | ||||
| 9 | 1 | 0 | 0 | Total | 214 | 235 | 1541 | ||||
| Total | 388 | 389 | 3451 | ||||||||
| 7 | 55 | 69 | 545 | ||||||||
| 10 | 70 | 60 | 567 | 8 | 72 | 69 | 313 | ||||
| 11 | 72 | 61 | 698 | 9 | 77 | 48 | 685 | ||||
| 12 | 58 | 67 | 510 | 10 | 67 | 67 | 352 | ||||
| 13 | 50 | 54 | 429 | 11 | 44 | 60 | 1101 | ||||
| 14 | 54 | 58 | 707 | 12 | 14 | 14 | 32 | ||||
| 15 | 10 | 15 | 119 | 13 | 6 | 1 | 204 | ||||
| 16 | 0 | 0 | 0 | 335 | 328 | 3232 | |||||
| Total | 314 | 315 | 3030 | ||||||||
| 14 | 66 | 74 | 293 | ||||||||
| 17 | 15 | 16 | 73 | 15 | 68 | 72 | 1050 | ||||
| 18 | 47 | 85 | 720 | 16 | 58 | 65 | 682 | ||||
| 19 | 91 | 67 | 649 | 17 | 51 | 84 | 527 | ||||
| 20 | 56 | 89 | 860 | 18 | 44 | 47 | 506 | ||||
| 21 | 60 | 59 | 562 | 19 | 13 | 12 | 179 | ||||
| 22 | 15 | 17 | 10 | 20 | 3 | 0 | 60 | ||||
| 23 | 0 | 2 | 32 | Total | 303 | 354 | 3297 | ||||
| Total | 284 | 335 | 2906 | ||||||||
| 21 | 54 | 69 | 950 | ||||||||
| 24 | 68 | 74 | 588 | 22 | 48 | 90 | 596 | ||||
| 25 | 66 | 80 | 732 | 23 | 52 | 75 | 420 | ||||
| 26 | 63 | 69 | 590 | 24 | 82 | 53 | 581 | ||||
| 27 | 75 | 88 | 464 | 25 | 52 | 43 | 669 | ||||
| 28 | 55 | 69 | 552 | 26 | 15 | 11 | 216 | ||||
| Total | 327 | 380 | 2926 | 27 | 2 | 0 | 167 | ||||
| 305 | 341 | 3599 | |||||||||
| 28 | 58 | 88 | 886 | ||||||||
| 29 | 58 | 56 | 549 | ||||||||
| 30 | 53 | 64 | 478 | ||||||||
| 31 | 49 | 69 | 713 | ||||||||
| Total | 218 | 277 | 2626 |
File details come from the government source that posted it. Updated .