Spreadsheet: 95410d1295006318-condition-conditions
Sheet: Instructions

 | Instructions for filling the Workload Tracker
 |  |  |  |  |  | 1.     PF & D formula removed, so there will be exact match between Daily Tracker & Workload Tracker hours.
1 | Estimated hours include Review hours. |  |  |  |  | 2.     [NAME] and [NAME] time to be filled in 1 worksheet.
2 | Default category of [NAME] to Shape parts is BTS. |  |  |  |  | 3.     Complexity will be decided automatically based on Estimated Hours.
3 | Default category of Welded parts is Welded. |  |  |  |  | 4.     Part weight in Lb & Kg columns added.
4 | Default category of Machined parts is Machined. |  |  |  |  | 5.     Type of Part as per eBOM categories.
5 | Part complexity will be decided on basis of Estimated hours. |  |  |  |  | 6.     Cost of each plant in separate column, so SC in USD, East Euro, West Euro, Brazil, China, India to be added.
6 | Estimated Start Date and Estimated End Date for each part will be decided in advance. |  |  |  |  | 7.     Unit cost  per [NAME] or Unit cost per [NAME] for each part will be available for each category of part.
7 | If you self assign the parts fill the Estimated Start Date & Estimated End date. |  |  |  |  | 8.     Actual Effort and [NAME] will be visible.
8 | If 2 or more persons are working on 1 big assembly then the estimated hours will be divided equally. |  |  |  |  | 9.     Total hours between 2 dates of every Estimator will be visible from Tracker.
9 | In case of [NAME] parts those parts will be copied in new row and remaining Estimated hours will be calculated as estimated hours minus used hours.
10 | Write Carry Over as "Carry Over-Jan 11". Change the month as per current.
11 | For machining parts No of child parts model made = Total no of callouts.
12 | If you work on more than 1 part on a day divide the PF & D time on all parts equally. No need to divide the time for Miscellaneous Project Activity & Miscellaneous Non Project Activity.
13 | The tolerance for Effort [NAME] is +/- 15%
14 | The [NAME] variance should be 0%. In case of exceptions the tolerance for [NAME] is +/- 1 day.
15 | If part is delivered by doing Self Review only, do not fill the [NAME] details.
16 | Update leaves in column "D" of "Team Loading" worksheet before going on leave.
17 | Update additional hours required in column "F" of "Team Loading" worksheet 2 days in advance of Estimated Completion Date.
 | Also update hours in column "E" in the same spreadheet if there is no workload.
19 | Parts will be assigned on the basis of "Team Loading" worksheet.
20 | Do not copy and paste tracker rows from your system to main tracker.
21 | For fabrication+machined part add 2 rows Part #_Fab & Part #_[NAME].
 | [NAME] | To be filled by Cost [NAME] | To be checked by Cost [NAME] | To be filled by [NAME] | To be filled by Sunil / WSR | Automatic calculations
 | Part No | Type of Part | Actual Effort Variance | Reviewer | Originating Plant | Complexity
 | Revision Level (SCR,Vis,Drg) | Estimator | Actual [NAME] | Review Start Date | Estimated Hours with Efficiency | Total Time of Cost Modeler
 | Part Name | Actual Start Date |  | Review End Date | # of Check Points | Total Time of Reviewer
 | Paint  (Yes/No) | Actual Time to Download Drawings |  | # of Defects | # of Defects | Billable Hours
 | CPPD Team | Actual Time to [NAME] |  | Time spent by [NAME] | # of Child Parts | Effort Variance
 | Priority | Actual time to create Costimator SC model / Nesting |  | Miscellaneous Project Activity | Estimated Hours | [NAME]
 | Reference Part | Actual time to create Costimator SC Spreadsheet |  | [NAME] Activity | Estimated Start Date | [NAME]
 | Product | Actual time to create Weld Table |  | PF&D | Estimated Completion date | Average hours per part
 | Model | Self QC + Review Time of Cost Modeler |  |  |  | Unit Cost - USA per Lb
 | EAU | Time spent on corrections |  |  |  | Unit Cost - East Europe per Kg
 | Requested by | Miscellaneous Project Activity |  |  |  | Unit Cost - West Europe per Kg
 | Requested on | [NAME] Activity |  |  |  | Unit Cost - China per Kg
 | Targeted Completion Date | PF&D |  |  |  | Unit Cost - Brazil per [NAME]
 | Charge # / PAC 2 # | No of models made including Child parts |  |  |  | Unit Cost - India per [NAME]
 | Finish Weld Only | SC model delivered on
 | Weld Table Required | Part/Assembly Net Weight in [NAME]
 | PDF Output | Part/Assembly Net Weight in Kg
 | Comments | Part Should Cost - USA
 |  | Part Should Cost - Mexico
 |  | Part Should Cost - East Europe
 |  | Part Should Cost - West Europe
 |  | Part Should Cost - China
 |  | Part Should Cost - Brazil
 |  | Part Should Cost - UK
 |  | Part Should Cost - India
 |  | Turning Callouts
 |  | Milling Callouts
 |  | Drilling Callouts
 |  | Grinding Callouts
 |  | Broaching
 |  | Hobbing