Spreadsheet: 882261d1730540849-get-value-from-different-workbook-based-on-multiple-criteria-and-based-on-the-latest-date-source-file_current
Sheet: Source file

 | Avd. | Maskin | Artikel_nr | Artikel besk. | [NAME] | Cykeltid | Antal fack | St./tim. (baserat på cykeltid) | [NAME]/vecko behov (Antal/st.) | [NAME]/veckobehov ([NAME] datum) | Avser period (Från vecka) | Avser period (Till vecka) | Ren körtid (tim/vecka) | Snitt OEE ([NAME] över tid) | Snitt antal (st/tim) | Verklig körtid (tim/vecka) | [NAME] på  effektivitet mot tiden maskinen beläggs med tim/OP | Kommentarer Senaste datum
 |  | 1001 | 71110 |  |  | =formula goes here | 1 |  | 0 | 2024-03-25 00:00:00
 |  | 1001 | 10202 |  |  | 64.6 | 2 |  | 800 | 2024-03-25 00:00:00
 |  | 1001 | 10199 |  |  | 65 | 1 |  | 0 | 2024-03-05 00:00:00
 |  | 1003 | 16106 |  |  | 58 | 1 |  | 0 | 2024-03-05 00:00:00
 |  | 1003 | 68117 |  |  | 67.7 | 1 |  | 250 | 2024-03-25 00:00:00
 |  | 1003 | 45136 |  |  | 68.3 | 1 |  | 0 | 2024-03-05 00:00:00
 |  | 1003 | 71114 |  |  | 52 | 4 |  | 3200 | 2024-03-25 00:00:00
 |  | 1004 | 54146 |  |  | 85 | 4 |  | 11000 | 2024-03-05 00:00:00
 |  | 1005 | 68107 |  |  | 88 | 1 |  | 150 | 2024-03-05 00:00:00
 |  | 1005 | 10405 |  |  | 73.4 | 2 |  | 800 | 2024-03-05 00:00:00
 |  | 1005 | 68118 |  |  | 65.8 | 1 |  | 0 | 2024-03-05 00:00:00
 |  | 1005 | 68103 |  |  | 91 | 1 |  | 140 | 2024-03-05 00:00:00
 |  | 1005 | 54163 |  |  | 74 | 1 |  | 650 | 2024-03-25 00:00:00
 |  | 1005 | 54161 |  |  | 82.52 | 4 |  | 0 | 2024-03-25 00:00:00
 |  | 1006 | 54146 |  |  | 85 | 4 |  | 0 | 2024-03-05 00:00:00
 |  | 1007 | 71112 |  |  | 36 | 6 |  | 2000 | 2024-03-25 00:00:00
 |  | 1007 | 71113 |  |  | 47.5 | 2 |  | 0 | 2024-03-05 00:00:00
 |  | 1007 | 71108 |  |  | 50 | 4 |  | 800 | 2024-03-05 00:00:00
 |  | 1007 | 71107 |  |  | 44.8 | 4 |  | 600 | 2024-03-25 00:00:00
 |  | 1007 | 66001 |  |  | 52 | 2 |  | 0 | 2024-03-11 00:00:00
 |  | 1007 | 66005 |  |  | 52 | 1 |  | 0 | 2024-03-12 00:00:00
 |  | 1007 | 66006 |  |  | 37 | 1 |  | 0
 |  | 1007 | 66008 |  |  | 36.66 | 1 |  | 0 | 2024-03-12 00:00:00
 |  | 1007 | 66010 |  |  | 64 | 1 |  | 0
 |  | 1007 | 66007 |  |  | 52 | 1 |  | 0 | 2024-03-11 00:00:00
 |  | 1007 | 66004 |  |  | 47 | 1 |  | 0
 |  | 1007 | 66009 |  |  | 52 | 2 |  | 0 | 2024-03-12 00:00:00
 |  | 1009 | 10301 |  |  | 24.7 | 1 |  | 250 | 2024-03-07 00:00:00
 |  | 1009 | 45121 |  |  | 52 | 1 |  | 300 | 2024-03-05 00:00:00
 |  | 1009 | 16104 |  |  | 37.6 | 2 |  | 0 | 2024-03-25 00:00:00
 |  | 1009 | 10158 |  |  | 43 | 2 |  | 0 | 2024-03-05 00:00:00
 |  | 1009 | 20106 |  |  | 29 | 1 |  | 0 | 2024-03-25 00:00:00
 |  | 1009 | 10159 |  |  | 43 | 2 |  | 0 | 2024-04-03 00:00:00
 |  | 1009 | 10163 |  |  | 43 | 1 |  | 0
 |  | 1009 | 10203 |  |  | 38.8 | 2 |  | 0
 |  | 1009 | 45122 |  |  | 27.1 | 1 |  | 0
 |  | 1009 | 45123 |  |  | 46.8 | 2 |  | 400 | 2024-04-08 00:00:00
 |  | 1009 | 20103 |  |  | 40.2 | 1 |  | 420 | 2024-03-25 00:00:00
 |  | 1010 | 10138 |  |  | 28 | 2 |  | 0 | 2024-03-25 00:00:00
 |  | 1010 | 10142 |  |  | 38 | 2 |  | 0 | 2024-03-25 00:00:00
 |  | 1010 | 10145 |  |  | 38 | 2 |  | 0 | 2024-03-25 00:00:00
 |  | 1010 | 45128 |  |  | 20 | 1 |  | 0
 |  | 1010 | 10201 |  |  | 33 | 4 |  | 2000 | 2024-03-25 00:00:00
 |  | 1010 | 10187 |  |  | 30 | 1 |  | 0
 |  | 1010 | 62101/2 |  |  | 0.5 | 1 |  | 0 | 2024-04-11 00:00:00
 |  | 1010 | 10207 |  |  | 64 | 1 |  | 300 | 2024-03-25 00:00:00
 |  | 1013 | 61100 |  |  | 70 | 1 |  | 400 | 2024-03-05 00:00:00
 |  | 1014 | 54156 |  |  | 72 | 4 |  | 14000
 |  | 1015 | 10208 |  |  | 151 | 1 |  | 0
 |  | 1015 | 10209 |  |  | 151 | 1 |  | 0 | 2024-03-06 00:00:00
 |  | 1015 | 10407 |  |  | 68 | 4 |  | 6000 | 2024-03-06 00:00:00
 |  | 1015 | 65101 |  |  | 79.2 | 1 |  | 300 | 2024-03-06 00:00:00
 |  | 1015 | 65104 |  |  | 70 | 1 |  | 600 | 2024-03-06 00:00:00
 |  | 1016 | 54158 |  |  | 63 | 1 |  | 3400 | 2024-03-06 00:00:00
 |  | 1016 | 54159 |  |  | 74.6 | 2 |  | 0 | 2024-04-15 00:00:00
 |  | 1016 | 54162 |  |  | 59 | 1 |  | 0
 |  | 1017 | 54156 |  |  | 77.8 | 1 |  | 500 | 2024-04-15 00:00:00
 |  | 1017 |  |  |  | 77.8 | 1 |  | 100
 |  | 1018 | 54155 |  |  | 70 | 2 |  | 6750
 |  | 1019 | 54155 |  |  | 67.7 | 2 |  | 6750
 |  | 1020 | 54166 |  |  | 55 | 1 |  | 4218
 |  | 1020 | 54159 |  |  | 74.6 | 2 |  | 0
 |  | 1022 | 71115 |  |  | 65.3 | 1 |  | 1244
 |  | 1022 | 71116 |  |  | 69.5 | 1 |  | 857
 |  | 1022 | 10200 |  |  | 77 | 1 |  | 114
 |  | 1022 | 71119 |  |  | 69.5 | 1 |  | 1517
 |  | 1210 | 61102 |  |  | 165 | 1 |  | 105
 |  | 1210 | 61101 |  |  | 152.5 | 1 |  | 105
 |  | 1211 | 71119-1 |  |  | 90 | 1 |  | 1200
 |  | 1212 | 71114-1 |  |  | 48 | 1 |  | 1500
 |  | 1212 | 10208-1 |  |  | 35 |  |  | 0
 |  | 1212 | 10208-2 |  |  | 35 |  |  | 0
 |  | 1212 | 10209-1 |  |  | 241 | 1 |  | 0
 |  | 1212 | 10209-2 |  |  | 160 | 1 |  | 0
 |  | 1224 | 10200-01 |  |  | 480 | 1 |  | 140
 |  | 1224 | 10203-01 |  |  | 244 | 4 |  | 600
 |  | 1224 | 11146-1 |  |  | 123 | 1 |  | 0
 |  | 1224 | 11147-1 |  |  | 123 | 1 |  | 0
 |  | 1224 | 11147-11 |  |  | 132 | 1 |  | 0
 |  | 1224 | 11147-2 |  |  | 205 | 1 |  | 0
 |  | 1224 | 66004-1 |  |  | 720 | 1 |  | 0
 |  | 1224 | 66005-1 |  |  | 450 | 1 |  | 0
 |  | 1226 | 10199-01 |  |  | 108 | 2 |  | 0
 |  | 1226 | 10199-02 |  |  | 120 | 2 |  | 0
 |  | 1226 | 10199-03 |  |  | 120 | 2 |  | 0
 |  | 1226 | 10199-04 |  |  | 130 | 2 |  | 0
 |  | 1226 |  |  |  | 44 | 1 |  | 800
 |  | 1226 | 54141-1 |  |  | 64 | 2 |  | 0
 |  | 1227 | 10189-1 |  |  | 72 | 1 |  | 0
 |  | 1227 | 10190-1 |  |  | 90 | 1 |  | 0
 |  | 1227 | 10191-1 |  |  | 82 | 1 |  | 0
 |  | 1227 | 10207 |  |  | 182 | 4 |  | 0
 |  | 1227 | 10208-3 |  |  | 124 | 1 |  | 0
 |  | 1227 | 10208-4 |  |  | 143 | 1 |  | 0
 |  | 1227 | 10209-3 |  |  | 288 | 2 |  | 0
 |  | 1227 | 10209-4 |  |  | 173 | 1 |  | 0
 |  | 1227 | 10305-1 |  |  | 223 | 2 |  | 0
 |  | 1227 | 10305-3 |  |  | 215 | 2 |  | 0
 |  | 1227 | 10305-5 |  |  | 215 | 2 |  | 0
 |  | 1227 | 66007-1 |  |  | 90 | 1 |  | 0
 |  | 1227 | 66008-1 |  |  | 150 | 1 |  | 0
 |  | 1227 | 66009-1 |  |  | 150 | 1 |  | 0
 |  | 1227 | 66010-1 |  |  | 180 | 1 |  | 0
 |  | 1227 | 68107-1 |  |  | 128 | 1 |  | 150
 |  | 1227 | 68113-1 |  |  | 138 | 1 |  | 0
 |  | 1227 | 68113-4 |  |  | 128 | 1 |  | 0
 |  | 1227 | 68113-7 |  |  | 103 | 1 |  | 0
 |  | 1227 | 71108-1 |  |  | 96 | 4 |  | 500
 |  | 1227 | 71113-2 |  |  | 162 | 3 |  | 0
 |  | 1227 | 71116-1 |  |  | 220 | 2 |  | 1200
 |  | 1228 | 10202-1 |  |  | 305 | 3 |  | 1400
 |  | 1228 | 54162-1 |  |  | 81.75 | 1 |  | 600
 |  | 1228 | 66006-1 |  |  | 410 | 1 |  | 0
 |  | 1228 | 68103-2 |  |  | 405 | 2 |  | 240
 |  | 1228 | 71110-1 |  |  | 184 | 2 |  | 160
 |  | 1229 | 54163-1 |  |  | 270 | 3 |  | 600
 |  | 1229 | 65101-1 |  |  | 82 | 1 |  | 120
 |  | 1229 | 65102-1 |  |  | 79 | 1 |  | 0
 |  | 1229 | 65102-2 |  |  | 120 | 1 |  | 0
 |  | 1229 | 65105 |  |  | 82 | 1 |  | 480
 |  | 1229 | 65106 |  |  | 124 | 1 |  | 140
 |  | 1230 | 54166-1 |  |  | 64 | 1 |  | 4218
 |  | 1231 | 54155-1 |  |  | 173 | 2 |  | 0
 |  | 1232 | 54155-1 |  |  | 172 | 2 |  | 0
 |  | 1236 | 54155-1 |  |  | 70 | 1 |  | 4000
 |  | 1237 | 54155-1 |  |  | 70 | 1 |  | 4000
 |  | 1238 | 54155-1 |  |  | 70 | 1 |  | 4000
 |  | 1233 | 54146-2 |  |  | 220 | 6 |  | 6500
 |  | 1234 | 54146-2 |  |  | 220 | 6 |  | 6500
 |  | 1235 | 54146-2 |  |  | 220 | 6 |  | 6500
 |  | 1235 | 54161-2 |  |  | 168 | 4 |  | 0
 |  | 1239 | 54146-2 |  |  | 220 | 6 |  | 6500
 |  | Bläster |  |  |  | 3600 | 330 |  | 14000
 |  | Bläster |  |  |  | 3600 | 330 |  | 250
 |  | Bläster |  |  |  | 3600 | 1050 |  | 4500
 |  | Bläster |  |  |  | 2200 | 188 |  | 0
 |  | Bläster |  |  |  | 1800 | 140 |  | 0
 |  | Bläster |  |  |  | 3200 | 175 |  | 180
 |  | Bläster |  |  |  | 4800 | 400 |  | 80
 |  | Bläster |  |  |  | 3600 | 204 |  | 30
 |  | Bläster |  |  |  | 3600 | 204 |  | 250
 |  | Bläster |  |  |  | 3600 | 250 |  | 200
 |  | [NAME] |  |  |  | 3600 | 48 |  | 1200
 |  | [NAME] |  |  |  | 2400 | 45 |  | 1400
 |  | [NAME] |  |  |  | 420 | 184 |  | 184
 |  | [NAME] |  |  |  | 420 | 36 |  | 160
 |  | [NAME] |  |  |  | 420 | 600 |  | 400
 |  | [NAME] |  |  |  | 3600 | 288 |  | 4500
 |  | [NAME] |  |  |  | 14400 | 702 |  | 380
 |  | [NAME] |  |  |  | 420 | 220 |  | 512
 |  | [NAME] |  |  |  | 16800 | 392 |  | 1600
 |  | [NAME] |  |  |  | 4600 | 72 |  | 1600
 |  | Provtryck 1 |  |  |  | 9600 | 120 |  | 1200
 |  | Provtryck 1 |  |  |  | 12800 | 210 |  | 1400
 |  | Provtryck 1 |  |  |  | 16900 | 392 | 84 | 1600
 |  | [NAME] |  |  |  | 24000 | 360 |  | 1600
 |  | Trumling 1114 |  |  |  | 3000 | 120 |  | 1200
 |  | Trumling 1114 |  |  |  | 4600 | 210 |  | 1400
 |  | Trumling 1114 |  |  |  | 5400 | 330 |  | 1600
 |  | Trumling 1114 |  |  |  | 2800 | 180 |  | 3600
 |  | Trumling 1115/1116 |  |  |  | 1800 | 720 |  | 26000
 |  | Trumling 1115/1116 |  |  |  | 3200 | 224 |  | 4500
 |  | Trumling 1115/1116 |  |  |  | 3400 | 224 |  | 1000
 |  | Trumling 1115/1116 |  |  |  | 3400 | 224 |  | 200
 |  | Trumling 1115/1116 |  |  |  | 2400 | 112 |  | 200
 |  | Trumling 1115/1116 |  |  |  | 2400 | 112 |  | 200
 |  | Trumling 1115/1116 |  |  |  | 3600 | 1050 |  | 4500
 |  | Trumling 1115/1116 |  |  |  | 5400 | 600 |  | 400
 |  | Trumling 1115/1116 |  |  |  | 7200 | 3000 |  | 400
 |  | Trumling 1115/1116 |  |  |  | 6400 | 1400 |  | 380
 |  | Trumling 1115/1116 |  |  |  | 7200 | 3500 |  | 500
 |  | Trumling 1115/1116 |  |  |  | 3600 | 1000 |  | 2000
 |  | Trumling 1115/1116 |  |  |  | 3600 | 1000 |  | 1000
 |  | Trumling 1115/1116 |  |  |  | 3600 | 2600 |  | 500
 |  | Montering/Gradning |  |  |  | 3600 | 100 | 80 | 2500
 |  | Gradning |  |  |  | 3600 | 100 | 7 | 45
 |  | Gradning |  |  |  | 3600 | 100 |  | 2000