Spreadsheet: 864980d1712090839-help-extracting-values-from-cell-test-04022024
Sheet: Complete Timeline DIG+FAB

 |  |  | DO NOT EDIT THIS SHEET- IT IS A REFERENCE SHEET!  DATA IS PULLED HERE FROM DIGITAL AND FABRIC TABS.
 |  |  |  |  | Total Press Time
 |  |  |  |  | Total Pieces
Press | SchedTime | Due Date | Job# | Line# | Master [NAME] | QTY | H | W | Material | Sides | PrintMode | Kitting | #OfKits | Notes | DateRecieved | SqFt | LinearFT
 | 0.905810546875 | 00:00:00 | 0 | 0 | 0 | 121 | 37 | 27 | PAP-  444054 - 60X120 4MM COROPLAST | 1 | 4 Pass | 0 | 0 | 0 | 00:00:00 | 839.4375 | 99.93303571428571 | 60 | 120 | 1 | 4 | 4 | 2 | 3 | 6 | 6 | 21
[NAME] | 0.884130859375 | 00:00:00 | 0 | 0 | 0 | 117 | 37 | 27 | PAP-  444054 - 60X120 4MM COROPLAST | 1 | 4 Pass | 0 | 0 | 0 | 00:00:00 | 811.6875 | 96.62946428571429 | 60 | 120 | 1 | 4 | 4 | 2 | 3 | 6 | 6 | 20
[NAME] | 0.43427734375 | 00:00:00 | 0 | 0 | 0 | 34 | 37 | 27 | PAP-  444054 - 60X120 4MM COROPLAST | 1 | 4 Pass | 0 | 0 | 0 | 00:00:00 | 235.875 | 28.08035714285715 | 60 | 120 | 1 | 4 | 4 | 2 | 3 | 6 | 6 | 6
[NAME] | 0.7925347222222222 | 00:00:00 | 0 | 0 | 0 | 1000 | 10 | 10 | PAP- SO-  2265 - STYRENE WHITE 18PT 29.5X20.5 | 1 | 4 Pass | 0 | 0 | 0 | 00:00:00 | 694.4444444444445 | 82.67195767195767 | 29.5 | 20.5 | 2 | 1 | 2 | 2 | 1 | 2 | 2 | 500
[NAME] | 0.298828125 | 00:00:00 | 0 | 0 | 0 | 1000 | 3 | 3 | PAP-  449847 - 48 X 96 2MM WHITE SINTRA 700 SERIES | 1 | 4 Pass | 0 | 0 | 0 | 00:00:00 | 62.5 | 7.440476190476191 | 48 | 96 | 13 | 27 | 351 | 13 | 27 | 351 | 351 | 3
[NAME] | 0.2608506944444444 | 00:00:00 | 0 | 0 | 0 | 500 | 2 | 2 | PAP- SO-  2265 - STYRENE WHITE 18PT 29.5X20.5 | 1 | 4 Pass | 0 | 0 | 0 | 00:00:00 | 13.88888888888889 | 1.653439153439154 | 29.5 | 20.5 | 11 | 8 | 88 | 11 | 8 | 88 | 88 | 6
[NAME] | 0.2527126736111111 | 00:00:00 | 0 | 0 | 0 | 20 | 5 | 5 | PAP- SO-  0017 - 50X99 20PT DEAD WHITE | 1 | 4 Pass | 0 | 0 | 0 | 00:00:00 | 3.472222222222222 | 0.4133597883597884 | 50 | #[NAME]! | 9 | #[NAME]! | #[NAME]! | 9 | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
[NAME] | 0.3042534722222222 | 00:00:00 | 0 | 0 | 0 | 100 | 10 | 10 | PAP-  449847 - 48 X 96 2MM WHITE SINTRA 700 SERIES | 1 | 4 Pass | 0 | 0 | 0 | 00:00:00 | 69.44444444444444 | 8.267195767195766 | 48 | 96 | 4 | 9 | 36 | 4 | 9 | 36 | 36 | 3
[NAME] | 2.420138888888889 | 00:00:00 | 0 | 0 | 0 | 1000 | 20 | 20 | PAP-  442004 - 60X120 3MM SINTRA WHITE | 1 | 4 Pass | 0 | 0 | 0 | 00:00:00 | 2777.777777777778 | 330.6878306878307 | 60 | 120 | 2 | 5 | 10 | 2 | 5 | 10 | 10 | 100
[NAME] | 0.875 | 00:00:00 | 0 | 0 | 0 | 50 | 48 | 48 | ART- 4237 - SINTRA 6MM BLACK 48X96 | 1 | 4 Pass | 0 | 0 | 0 | 00:00:00 | 800 | 95.23809523809524 | #[NAME]! | 96 | #[NAME]! | 1 | #[NAME]! | #[NAME]! | 1 | #[NAME]! | #[NAME]! | #[NAME]!
[NAME] | 0.3042534722222222 | 00:00:00 | 0 | 0 | 0 | 100 | 10 | 10 | ART-  4026 - 24X50 30MIL ADH BACK MAGNETIC BOARD | 1 | 4 Pass | 0 | 0 | 0 | 00:00:00 | 69.44444444444444 | 8.267195767195766 | 24 | #[NAME]! | 2 | #[NAME]! | #[NAME]! | 2 | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
[NAME] | 0.3639322916666666 | 00:00:00 | 0 | 0 | 0 | 100 | 14 | 15 | ART- 4361 - SINTRA WHITE 19MM 48X96 | 1 | 4 Pass | 0 | 0 | 0 | 00:00:00 | 145.8333333333333 | 17.36111111111111 | #[NAME]! | 96 | #[NAME]! | 6 | #[NAME]! | #[NAME]! | 6 | #[NAME]! | #[NAME]! | #[NAME]!
[NAME] | 0.3671875 | 00:00:00 | 0 | 0 | 0 | 50 | 12 | 36 | PAP-  413740 - 48X60 24PT C2S SBS | 1 | 4 Pass | 0 | 0 | 0 | 00:00:00 | 150 | 17.85714285714286 | 48 | #[NAME]! | 3 | #[NAME]! | #[NAME]! | 1 | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
[NAME] | 0.3585069444444444 | 00:00:00 | 0 | 0 | 0 | 100 | 20 | 10 | PAP-  412430 - 100# COMMERCIAL COVER 35X45 | 1 | 4 Pass | 0 | 0 | 0 | 00:00:00 | 138.8888888888889 | 16.53439153439153 | #[NAME]! | 45 | #[NAME]! | 4 | #[NAME]! | #[NAME]! | 2 | #[NAME]! | #[NAME]! | #[NAME]!