Spreadsheet: 103351d1301079563-losing-formulas-after-live-office-update-post-update-clean-sample
Sheet: Data Entry

 | Source | ALL MTD |  | January | February | March | April | May | June | July | August | September | October | November | December | YTD JAN | YTD FEB | YTD MAR | YTD APR | YTD MAY | YTD JUN | YTD JUL | YTD AUG | YTD SEP | YTD OCT | YTD NOV | YTD DEC | Q1 | Q2 | Q3 | Q4
Prod | CHART-Invoiced | UT Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add
Prod | CHART-Invoiced | TL Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add
Prod | Manual-Dispatch | WIP Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add
Prod | CHART-Individual | New Tech Train Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add
Prod | Manual | # [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | avg
Prod | Manual | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add
[NAME] | Manual | EC Rate |  | 99 | 99 | 99 | 99 | 99 | 99 | 99 | 99 | 99 | 99 | 99 | 99 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | avg
[NAME] | CHART-Invoiced | EC X03 Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add
[NAME] | CHART-Invoiced | EC X04 Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add
[NAME] | CHART-Invoiced | EC Non-Std Rate 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mult
[NAME] | CHART-Invoiced | EC Non-Std Hours 1
[NAME] | CHART-Invoiced | EC Non-Std Rate 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mult
[NAME] | CHART-Invoiced | EC Non-Std Hours 2
[NAME] | CHART-Invoiced | EC Non-Std Rate 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mult
[NAME] | CHART-Invoiced | EC Non-Std Hours 3
[NAME] | CHART-Invoiced | EC Non-Std Rate 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mult
[NAME] | CHART-Invoiced | EC Non-Std Hours 4
[NAME] | CHART-Invoiced | EC Non-Std Rate 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mult
[NAME] | CHART-Invoiced | EC Non-Std Hours 5
[NAME] | CHART-Invoiced | EC Non-Std Rate 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mult
[NAME] | CHART-Invoiced | EC Non-Std Hours 6
[NAME] | CHART-Invoiced | EC Non-Std Rate 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mult
[NAME] | CHART-Invoiced | EC Non-Std Hours 7
[NAME] | CHART-Invoiced | EC Non-Std Rate 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mult
[NAME] | CHART-Invoiced | EC Non-Std Hours 8
[NAME] | CHART-Invoiced | EC Non-Std Rate 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mult
[NAME] | CHART-Invoiced | EC Non-Std Hours 9
[NAME] | CHART-Invoiced | EC Non-Std Rate 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mult
[NAME] | CHART-Invoiced | EC Non-Std Hours 10
[NAME] | CHART-Invoiced | EN X03 Rate |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mult
[NAME] | CHART-Invoiced | EN X03 Hours
[NAME] | CHART-Invoiced | EN [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mult
[NAME] | CHART-Invoiced | EN X04 Hours
[NAME] | CHART-Invoiced | EN Non-Std Rate 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mult
[NAME] | CHART-Invoiced | [NAME]
[NAME] | CHART-Invoiced | EN Non-Std Rate 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mult
[NAME] | CHART-Invoiced | [NAME]
[NAME] | CHART-Invoiced | EN Non-Std Rate 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mult
[NAME] | CHART-Invoiced | [NAME]
[NAME] | CHART-Invoiced | EN Non-Std Rate 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mult
[NAME] | CHART-Invoiced | [NAME]
[NAME] | CHART-Invoiced | EN Non-Std Rate 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mult
[NAME] | CHART-Invoiced | [NAME]
[NAME] | CHART-Invoiced | TL Ext $$ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add
[NAME] | CHART-Invoiced | TL Ext Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add
[NAME] | CHART-Invoiced | CFPM Goal % |  | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | avg
[NAME] | CHART-Invoiced | CFPM OT $$ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add
[NAME] | CHART-Invoiced | CFPM Billings $$ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add
[NAME] | CHART-Invoiced | CFPM Profit $$ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add
Rep Eff | CHART-Invoiced | Ext Parts $$ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add
Rep Eff | CHART-Invoiced | Int Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add
Rep Eff | CHART-Invoiced | Int Parts $$ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add
Resp Time | 1st Call Log | # Calls |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add
Resp Time | 1st Call Log | # Calls > 4 Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add
Unit Ret | Manual-IQ Rep | # [NAME] on Cont |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | avg
Unit Ret | Manual-Dispatch | # Units LOST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add
SM Comp | Manual-PMFM | # [NAME]'s due |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add
SM Comp | Manual-Dispatch | # SM's Completed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add
SM Comp | Manual-Dispatch | # SM Exceptions |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add
Insp Pass | Manual-QA | # Inspections |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add
Insp Pass | Manual-QA | Average Score |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | factor
SM Effect | 1st Call Log | # Breakdowns |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add
1st Call | 1st Call Log | # 1st Call Complete |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add
Act Inv | Kirk e-mail | Inventory $$ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add
Act Inv | Kirk e-mail | Inv No-move $$ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add
Inv Acc | Manual-Inv. Rep | $$ Inventoried |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add
Inv Acc | Manual-Inv. Rep | $$ [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add
Unit Ret | Manual-Incentive | # Units ADDED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add
 |  | Primary Calculations
 |  | OT % |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | calc
 |  | Special Rate $$ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add
 |  | Special Rate Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add
 |  | Special Rate $$/Hr |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | calc
 |  | Special Rate % |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | calc
 |  | Reporting | 1 | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | YTD JAN | YTD FEB | YTD MAR | YTD APR | YTD MAY | YTD JUN | YTD JUL | YTD AUG | YTD SEP | YTD OCT | YTD NOV | YTD DEC | Q1 | Q2 | Q3 | Q4
 |  | [NAME] (MTD) / YTD | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | calc
 |  | Prod MTD / YTD | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | calc
 |  | [NAME] (MTD) / YTD | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | calc
 |  | [NAME] / YTD | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | calc
 |  | [NAME] (MTD) / YTD | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | calc
 |  | [NAME] / YTD | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | calc
 |  | SM Completion | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | calc
 |  | Insp Avg Score | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | calc
 |  | 4 Hour Response | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | calc
 |  | 1st Call Completion | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | calc
 |  | Ext Part $/Lab Hour | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | calc
 |  | [NAME] / $100 Parts | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | calc
 |  | Unit [NAME] | 14 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add
 |  | Units Added | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | calc
 |  | Unit [NAME] | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | calc
 |  | BD's per SM | 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | calc
 |  | No-Move | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | calc
 |  | [NAME] | 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | calc