Spreadsheet: 708808d1608036456-extract-and-sum-numerical-values-using-string-matching-from-single-multi-value-cell-submission
Sheet: Real Actual (2)

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monday | Tuesday | Wednesday | Thursday | Friday
Fred |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2675_Mechanism Drive_Guard Bottom_Fit _02, 2675_Mechanism Drive_Guard Bottom_Weld_05 |  |  |  |  |  | 2675_Mechanism Drive_Guard Bottom_Fit _02 |  |  |  |  |  | 2675_Mechanism Drive_Guard Bottom_Fit _03, 2675_Mechanism Drive_Guard Bottom_weld_05
Jake |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2675_Mechanism Drive_Guard Bottom_Fit _02 |  |  |  |  |  | 2675_Mechanism Drive_Guard Bottom_Fit _05
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2675_Mechanism Drive_Guard Bottom_Weld_03 |  |  |  |  |  | 2675_Mechanism Drive_Guard Bottom_Weld_05
[NAME]
[NAME]
STEP 1 - EXTRACT PROJECT
STEP 2 - EXTRACT TASK "DRIVE BASE"
STEP 3 - EXTRACT COMPONENT
STEP 4 - EXTRACT ACTION
STEP 5 - EXTRACT HOURS
 | 2675
1 | 2675 |  |  | Qty | Travellers | Total $ | hours | Part # | Fit | Weld | Assemble | [NAME] | Pack | Length
1.1 | [NAME]
1.1.1 | [NAME] |  |  | 1 | x | 2130 |  | 70122
1.1.2 | Motor Swivel Plate |  |  | 1 | x | 100 |  | 70128 | 0.5 | 1
1.1.3 | Swivel Pin |  |  | 1 | x | 45 |  | 70139 |  | 0.5
1.1.4 | [NAME] |  |  | 2 |  | 40 |  | 70129
1.2 | FL300U Mechanism
1.2.1 | W19 Rotor [NAME], 205 |  |  | 1 | x | 260 |  | 22045 | 2 | 2
1.2.2 | F2 [NAME] |  |  | 1 | x | 260 |  | 78893 | 1 | 3
1.2.3 | W19 Stator Skeleton, 205 |  |  | 2 | x | 520 |  | 22065 | 4 | 4
1.2.4 | [NAME] |  |  | 1 | x | 650 |  | 78997 | 4 | 6
1.3 | Mechanism Drive | Together | Length
1.3.1 | Guard Bottom |  |  | 1 | x | 65 |  | 78917 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Find Position of 2675_Mechanism Drive_Guard Bottom
1.3.1.1 | Fit |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Return last 7 digits
1.3.1.2 | Weld |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Find the Comma
1.3.1.3 | Assm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | repeat same action after comma
1.3.1.4 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | join text
1.3.2 | Guard Bottom |  |  | 1 | x | 195 |  | 78918 | 1 | 2
1.3.2.1 | Fred |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | THIS IS OPTION 2, BUT CURRENTLY FAILS IF I HAVE 2 TASKS
1.3.2.2 | Jake |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ON ONE DAY FOR SOMEONE AS IT'S RUN BY USING A MID AND LENGTH SUBTRACTION
1.3.2.3 | [NAME]
1.3.2.4 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | THIS IS OPTION 1, BUT EQUATION
1.3.2.5 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WILL GET BIG WITH MANY
1.3.3 | Guard Top Door 919 |  |  | 1 | x | 130 |  | 78919 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ITEMS IN 1 DAY
1.3.3.1 | Fred
1.3.3.2 | Jake
1.3.3.3 | [NAME]
1.3.3.4 | [NAME]
1.3.3.5 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | using search
1.3.4 | Guard Top Door 920 |  |  | 1 | x | 130 |  | 78920 | 1 | 1
1.3.4.1 | Fred
1.3.4.2 | Jake
1.3.4.3 | [NAME]
1.3.4.4 | [NAME]
1.3.4.5 | [NAME]
1.3.5 | Reinforcement Channel |  |  | 2 | x | 130 |  | 78995 |  |  |  | 1
1.3.5.1 | Fred
1.3.5.2 | Jake
1.3.5.3 | [NAME]
1.3.5.4 | [NAME]
1.3.5.5 | [NAME]
1.4 | Assy, Testing & Packaging
1.4.1 | 8.7M3 W19 Mechanism Upgrade |  |  |  | x |  |  | 70120
1.4.2 | H-W19 Retrofit Mechanism |  |  | 1 | x | 686 |  | 70121 |  |  | 10.6
1.4.3 | Packaging |  |  | 1 |  | 1000
1.4.4 | Guard Assembly |  |  | 1 | x | 260 |  | 78916 |  |  | 4