Spreadsheet: 851499d1701721681-pulling-estimated-work-hours-based-on-schedule-forumula-test-file
Sheet: SCHEDULE ADMIN & EQUIP PLAN

 |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36
SCHEDULE START DATE | 2024-05-01 00:00:00
SCHEDULE TYPE | MONTHLY
[NAME] CRAFT | SCH ACT |  |  | BUDGET HRS | CRFT |  | SCH HRS | START DATE | END DATE
PROJECT DURATION TO [NAME]. | -
ELEC | -
TRENCHING | -
TRACKER PILES | -
INVERTER PILES | -
TRACKERS | -
MODULES | -
STARTUP - PRE/ HOT COMMISSIONING | -
 | -
 | - |  |  |  |  |  |  | 2024-07-01 00:00:00 | 2025-05-25 00:00:00
 | - |  |  |  |  |  |  | 2024-09-01 00:00:00 | 2025-06-30 00:00:00
 | CIVIL |  |  |  | CR4 |  |  | 2024-08-01 00:00:00 | 2025-04-20 00:00:00
 | CIVIL |  |  |  | CR1 |  |  | 2024-08-01 00:00:00 | 2025-04-20 00:00:00
 | CIVIL |  |  |  | ELEC |  |  | 2024-08-01 00:00:00 | 2025-04-20 00:00:00
 | U/G ELEC |  |  |  | CR4 |  |  | 2024-08-01 00:00:00 | 2025-04-20 00:00:00
 | U/G ELEC |  |  |  | ELEC |  |  | 2024-08-01 00:00:00 | 2025-04-20 00:00:00
 | PILES - INVERTER |  |  |  | LB |  |  | 2024-08-08 00:00:00 | 2025-04-30 00:00:00
 | PILES |  |  |  | LB |  |  | 2024-08-08 00:00:00 | 2025-04-30 00:00:00
 | PILES |  |  |  | CP |  |  | 2024-08-08 00:00:00 | 2025-04-30 00:00:00
 | PILES |  |  |  | CR2 |  |  | 2024-08-08 00:00:00 | 2025-04-30 00:00:00
 | TRACKERS |  |  |  | CP |  |  | 2024-09-01 00:00:00 | 2025-05-10 00:00:00
 | TRACKERS |  |  |  | CR2 |  |  | 2024-09-01 00:00:00 | 2025-05-10 00:00:00
 | MODULES |  |  |  | CP |  |  | 2024-09-23 00:00:00 | 2025-05-30 00:00:00
 | MODULES |  |  |  | CR2 |  |  | 2024-09-23 00:00:00 | 2025-05-30 00:00:00
 | -
 | -
 | INVERTERS |  |  |  | CR4 |  |  | 2025-05-01 00:00:00 | 2025-06-01 00:00:00
 | INVERTERS |  |  |  | ELEC |  |  | 2025-05-01 00:00:00 | 2025-06-01 00:00:00
 | A/G ELEC |  |  |  | ELEC |  |  | 2024-11-01 00:00:00 | 2025-07-15 00:00:00
 | A/G ELEC |  |  |  | CR4 |  |  | 2024-11-01 00:00:00 | 2025-07-15 00:00:00
 | -
 | A/G ELEC |  |  |  | CR3 |  |  | 2025-05-01 00:00:00 | 2025-09-30 00:00:00
 | -
 | MISC DIRECT LABOR |  |  |  | LB
 | MISC DIRECT LABOR |  |  |  | CP
 | MISC DIRECT LABOR |  |  |  | ELEC
 | MISC DIRECT LABOR |  |  |  | CR1
 | MISC DIRECT LABOR |  |  |  | CR2
 | MISC DIRECT LABOR |  |  |  | CR3
 | MISC DIRECT LABOR |  |  |  | CR4
 | -
 | -
 | -
 | -
 | -
 | -
 | -
 | -
PROJECT DURATION | -
PRE-FAB PIPE | -
PRE-FAB PIPE LNTP | -
PRE-FAB PIPE PO ISSUE DATE | -
PRE-FAB PIPE PRCUREMENT | -
PRE-FAB PIPE DRAFTING | PRE-FAB PIPE DRAFTING |  |  |  | PREFABDR
PRE-FAB PIPE BENDING | -
PRE-FAB PIPE MACHINING | -
PRE-FAB PIPE MISC | -
PRE-FAB PIPE CS | PRE-FAB PIPE CS |  |  |  | PF FAB
PRE-FAB PIPE SS | PRE-FAB PIPE SS |  |  |  | PF FAB
PRE-FAB PIPE CR M | PRE-FAB PIPE CR M |  |  |  | PF FAB
PRE-FAB PIPE P5-P91 | PRE-FAB PIPE P5-P91 |  |  |  | PF FAB
PRE-FAB PIPE VALVE HANDLE | PRE-FAB PIPE VALVE HANDLE |  |  |  | PF FAB
PRE-FAB PIPE HANDLE | PRE-FAB PIPE HANDLE |  |  |  | PF FAB
PRE-FAB PIPE LOADING/PACKAGING | PRE-FAB PIPE LOADING/PACKAGING |  |  |  | PF FAB
PRE-FAB PIPE YARD HANDLE | PRE-FAB PIPE YARD HANDLE |  |  |  | PF FAB
PRE-FAB PIPE NDE | -
PRE-FAB PIPE PWHT | PRE-FAB PIPE PWHT |  |  |  | PF FAB
PRE-FAB PIPE HYDRO | PRE-FAB PIPE HYDRO |  |  |  | PF FAB
PRE-FAB PIPE PAINT/ COATINGS | -
PRE-FAB PIPE FREIGHT TO SITE | -
PRE-FAB PIPE SUPERVISION | PRE-FAB PIPE SUPERVISION |  |  |  | PREFABPFS
PRE-FAB PIPE PROJECT MANAGER | PRE-FAB PIPE PROJECT MANAGER |  |  |  | PREFABPM
PRE-FAB PIPE COORDINATOR | PRE-FAB PIPE COORDINATOR |  |  |  | PREFCO0RD
PRE-FAB PIPE QA/QC COORDINATOR | PRE-FAB PIPE QA/QC COORDINATOR |  |  |  | PREFABQA
PRE-FAB PIPE PROJECT CONTROLS | PRE-FAB PIPE PROJECT CONTROLS |  |  |  | PREFABPC
 | -
 | -
 | -
 | -
PRE-FAB METAL
PRE-FAB METAL LNTP | -
PRE-FAB METAL PO ISSUE DATE | -
PRE-FAB METAL PRCUREMENT | -
PRE-FAB METAL PROCUREMENT STRUCTURAL | -
PRE-FAB METAL PROCUREMENT PLATE | -
PRE-FAB METAL PROCUREMENT BOLTS | -
PRE-FAB METAL PROCUREMENT STUDS | -
PRE-FAB METAL PROCUREMENT GRATING | -
PRE-FAB METAL PROCUREMENT PIPE | -
PRE-FAB METAL PROCUREMENT TREADS | -
PRE-FAB METAL PROCUREMENT EXTRA | -
PRE-FAB METAL SUBCONTRACTS | -
PRE-FAB METAL SUBCONTRACTS DRAFTING | -
PRE-FAB METAL SUBCONTRACTS BENDING | -
PRE-FAB METAL SUBCONTRACTS MACHINING | -
PRE-FAB METAL SUBCONTRACTS PAINT | -
PRE-FAB METAL SUBCONTRACTS GALV | -
PRE-FAB METAL SUBCONTRACTS MACHINING | -
PRE-FAB METAL SUBCONTRACTS FREIGHT TO SUBS | -
PRE-FAB METAL SUBCONTRACTS FREIGHT TO SITE | -
PRE-FAB METAL SUBCONTRACTS NDE | -
PRE-FAB METAL SUBCONTRACTS HYDRO | -
PRE-FAB METAL SUBCONTRACTS MISC | -
PRE-FAB METAL DIRECT LABOR HOURS | PRE-FAB METAL HANDLE |  |  |  | M FAB
PRE-FAB METAL SUPERVISION | - |  |  |  | PREFABSMS
PRE-FAB METAL PROJECT MANAGER | - |  |  |  | PREFABPM
PRE-FAB METAL COORDINATOR | - |  |  |  | PREFCO0RD
PRE-FAB METAL QA/QC COORDINATOR | - |  |  |  | PREFABQA
PRE-FAB METAL PROJECT CONTROLS | - |  |  |  | PREFABPC
PRE-FAB METAL PROJECT CONTROLS | - |  |  |  | PREFABDR
 | -
 | -
 | -
 | -
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^INSERT ROWS ABOVE THIS LINE AND COPY DOWN ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
TOTAL CREW SIZE BY CRAFT | MAX CRAFT COUNT |  |  | BUDGET HRS | CRFT |  | SCH HRS | START DATE | END DATE
BM
PF
IW
MW
ELEC
LB
SM
CP
CR1
CR2
CR3
CR4