Spreadsheet: 836438d1689352790-combining-formulas-help
Sheet: CAR_CAP_MRC

Project: Project ID | Project: Work-order | Old Workorder | MSD htc_workordernumber | Project: Workorder Number | Project: Work Order Number | Capital Request: Capital Request # | Program | Project: MRC Data | Project: MRC Voice | Project: Site Name | Status | Project: Territory | Project: Region | Work-order | Amount | Project: Project Status | Project: Project Template | Project: Project Start Date (A) | Project: Site City | Project: Project Footage Total | Project: Project Complete (A)
A-012345 | 1234567890 |  |  |  |  | CR-001234 | Commercial Customers | 354 |  | 123 W Main St / Any Town / NC | Approved | North Carolina | Southeast | [PHONE] | 203853 | Complete | Temp 1 | 5/6/2022 | Any Town |  | 2023-05-10 00:00:00
A-012346 | 1234567891 |  |  |  |  | CR-001235 | New Builds |  |  | 234 W Main St / Any Town / SC | Approved | South Carolina | Southeast | [PHONE] | 389134.52 | Complete | Temp 2 | [NAME] | Any Town | 24948
A-012347 | 1234567892 |  |  |  |  | CR-001236 | Commercial Customers | 39.98 |  | 345 W Main St / Any Town / GA | Approved | Georgia | Southeast | [PHONE] | 7554 | Complete | Temp 3 | 7/1/2022 | Any Town |  | 2023-03-08 00:00:00
[NAME] | 1234567893 |  |  |  | 1234567890 | CR-001237 | New Builds |  |  | 456 W Main St / Any Town / FL | Approved | Florida | Southeast | [PHONE] | 350000 | Complete | Temp 4 | 9/15/2022 | Any Town
A-012349 | 1234567894 |  |  |  |  | CR-001238 | New Builds |  |  | 567 W Main St / Any Town / MS | Approved | Mississippi | Southeast | [PHONE] | 150856.88 | Complete | Temp 2 | 9/2/2022 | Any Town
A-012350 | 1234567895 |  |  |  |  | CR-001239 | Commercial Customers |  | 118.99 | 678 W Main St / Any Town / TN | Approved | Tennessee | Southeast | [PHONE] | 7554 | Complete | Temp 4 | 9/7/2022 | Any Town |  | 2023-01-06 00:00:00
A-012351 | 1234567896 |  |  |  | 1234567890 | CR-001240 | New Builds |  |  | 789 W Main St / Any Town / VA | Approved | Virginia | Southeast | [PHONE] | 51896.41 | Complete | Temp 4 | 8/1/2022 | Any Town
A-012352 | 1234567897 |  |  |  |  | CR-001241 | Commercial Customers | 352 |  | 890 W Main St / Any Town / KY | Approved | Kentucky | Southeast | [PHONE] | 7554 | Complete | Temp 3 | 8/31/2022 | Any Town |  | 2023-01-12 00:00:00
A-012353 | 1234567898 |  |  |  | 1234567890 | CR-001242 | New Builds |  |  | 123 N Main St / Any Town / NC | Approved | North Carolina | Southeast | [PHONE] | 457973.13 | Complete | Temp 2 | 8/2/2022 | Any Town
A-012354 | 1234567899 |  |  |  |  | CR-001243 | New Builds |  |  | 234 N Main St / Any Town / SC | Approved | South Carolina | Southeast | [PHONE] | 578932.64 | Complete | Temp 2 | 6/7/2022 | Any Town | 38016
A-012355 | 1234567900 |  |  |  |  | CR-001244 | Commercial Customers | 234.99 |  | 345 N Main St / Any Town / GA | Approved | Georgia | Southeast | [PHONE] | 580.39 | Delayed - Customer | Temp 3 | 2/8/2022 | Any Town |  | 2023-06-07 00:00:00
A-012356 | 1234567901 |  | 1234567890 |  |  | CR-001245 | Commercial Customers | 234.99 |  | 456 N Main St / Any Town / FL | Active | Florida | Southeast |  | 8785 | Delayed - Customer | Temp 3 | 2/8/2022 | Any Town
A-012357 | 1234567902 |  |  |  |  | [NAME] | Commercial Customers | 234.99 |  | 567 N Main St / Any Town / MS | Approved | Mississippi | Southeast | [PHONE] | 580.39 | Delayed - Customer | Temp 3 | 2/8/2022 | Any Town
A-012358 | 1234567903 |  |  |  |  | CR-001247 | Commercial Customers | 239.99 |  | 678 N Main St / Any Town / TN | Approved | Tennessee | Southeast | [PHONE] | 239.99 | Complete | Temp 3 | 6/8/2022 | Any Town |  | 2023-02-01 00:00:00