I am trying to create a script rule that automatically exports email body information when received into a predesigned spreadsheet that is done throughout the week but daily it is updated with the info. At the end of the week a new sheet is created for the following week. The email body looks like this. I will attach the spreadsheet layout also in about 10 mins.
Data Below is calculated Midnight-to-Midnight (Eastern Time) **=--- ** Wireless DTC shipped 38718 order-lines, 8593 handsets and 30170 accessories. Total of 8061 orders or 8077 cartons shipped and cancelled/zero-shipped 121 orders on 06/27/2016 with avg order-entry to ship of 37.49 hrs verses an internal WMS cycle time of 4.51 hrs. Order SLA (7PM CDT) fill-rate: 99.9211% with 14 orders/180 lines missed SLA. Order shipped fill-rate: 99.8%. 7247 cartons w/one or more phones and 830 accy-only cartons shipped. 8734 orders, 38367 order-lines downloaded yesterday while available for planning is 87 orders and 808 lines. ** DSL DTC shipped 9133 order-lines, 705 modems/routers and 8319 components. Total of 1058 orders or 1092 cartons shipped and cancelled/zero-shipped 0 orders on 06/27/2016 with avg order-entry to ship of 35.42 hrs verses an internal WMS cycle time of 8.02 hrs. Order SLA (3PM CDT) fill-rate: 100% with 2 orders/20 lines missed SLA. Order shipped fill-rate: 100%. 705 cartons w/one or more modems/routers and 387 accy-only cartons shipped. 740 orders, 12912 order-lines downloaded yesterday while available for planning is 154 orders and 1649 lines. ** UVERSE DTC shipped 33757 order-lines, 3728 STBs/RGs and 27562 components. Total of 5961 orders or 5966 cartons shipped and cancelled/zero-shipped 0 orders on 06/27/2016 with avg order-entry to ship of 44.54 hrs verses an internal WMS cycle time of 5.6 hrs. Order SLA (9PM CDT) fill-rate: 93.5771% with 720 orders/5435 lines missed SLA. Order shipped fill-rate: 99.8%. 3642 cartons w/one or more STBs/RGs and 2324 accy-only cartons shipped. 6729 orders, 48088 order-lines downloaded yesterday while available for planning is 3081 orders and 22630 lines. ** Wireless BULK shipped 24421 order-lines, 22465 handsets and 67425 accessories. Total of 3138 orders or 6440 cartons shipped and cancelled/zero-shipped 6 orders on 06/27/2016 with avg order-entry to ship of 466.43 hrs verses an internal WMS cycle time of 9.79 hrs. Order SLA (5PM CDT) fill-rate: 86.3166% with 558 orders/6539 lines missed SLA. Order shipped fill-rate: 99.6%. 4937 cartons w/one or more phones and 1503 accy-only cartons shipped. 3728 orders, 34313 order-lines downloaded yesterday while available for planning is 58 orders and 105 lines. ** DSL LFO(BULK) shipped 35 order-lines, 1292 modem/routers and 30 components. Total of 33 orders or 222 cartons shipped and cancelled/zero-shipped 0 orders on 06/27/2016 with avg order-entry to ship of 181.61 hrs verses an internal WMS cycle time of 47.6 hrs. Order SLA (3PM CDT) fill-rate: 100% with 3 orders/5 lines missed SLA. Order shipped fill-rate: 99.9%. 3 cartons w/one or more modems/routers and 219 accy-only cartons shipped. 6 orders, 13 order-lines downloaded yesterday while available for planning is 0 orders and 0 lines. ---=** Data Above is calculated Midnight-to-Midnight (Eastern Time) **=--- ---=** Data Below is calculated based on Carryover Cutoff time (4am-4am) **=--- ---=** [Hours are displayed in Eastern Time] **=--- ** MDC WMS Orders shipped by hour - 06/27/2016 06/27 07:00 Wireless DTC: 25 orders 111 lines 111 units 06/27 08:00 Wireless DTC: 414 orders 2075 lines 2076 units 06/27 09:00 Wireless DTC: 566 orders 2134 lines 2141 units 06/27 10:00 Wireless DTC: 722 orders 3026 lines 3026 units 06/27 11:00 Wireless DTC: 514 orders 2295 lines 2295 units 06/27 12:00 Wireless DTC: 688 orders 3140 lines 3140 units 06/27 13:00 Wireless DTC: 128 orders 540 lines 541 units 06/27 14:00 Wireless DTC: 535 orders 2729 lines 2731 units 06/27 15:00 Wireless DTC: 491 orders 2379 lines 2380 units 06/27 16:00 Wireless DTC: 250 orders 1290 lines 1292 units 06/27 17:00 Wireless DTC: 705 orders 3451 lines 3452 units 06/27 18:00 Wireless DTC: 606 orders 3182 lines 3183 units 06/27 19:00 Wireless DTC: 396 orders 1878 lines 1886 units 06/27 20:00 Wireless DTC: 599 orders 2923 lines 2925 units 06/27 21:00 Wireless DTC: 428 orders 2056 lines 2058 units 06/27 22:00 Wireless DTC: 508 orders 2709 lines 2731 units 06/27 23:00 Wireless DTC: 484 orders 2773 lines 2768 units 06/28 04:00 Wireless DTC: 41 orders 241 lines 239 units 06/27 08:00 DSL DTC: 23 orders 271 lines 287 units 06/27 09:00 DSL DTC: 44 orders 415 lines 423 units 06/27 10:00 DSL DTC: 100 orders 1036 lines 1040 units 06/27 11:00 DSL DTC: 61 orders 549 lines 520 units 06/27 12:00 DSL DTC: 82 orders 625 lines 575 units 06/27 13:00 DSL DTC: 61 orders 427 lines 404 units 06/27 14:00 DSL DTC: 85 orders 748 lines 708 units 06/27 15:00 DSL DTC: 39 orders 318 lines 316 units 06/27 17:00 DSL DTC: 60 orders 527 lines 561 units 06/27 18:00 DSL DTC: 61 orders 515 lines 545 units 06/27 19:00 DSL DTC: 44 orders 334 lines 338 units 06/27 20:00 DSL DTC: 64 orders 522 lines 516 units 06/27 21:00 DSL DTC: 26 orders 178 lines 170 units 06/27 22:00 DSL DTC: 84 orders 721 lines 690 units 06/27 23:00 DSL DTC: 224 orders 1947 lines 1931 units 06/28 04:00 DSL DTC: 7 orders 54 lines 47 units 06/27 07:00 UVERSE DTC: 12 orders 73 lines 49 units 06/27 08:00 UVERSE DTC: 241 orders 1779 lines 1812 units 06/27 09:00 UVERSE DTC: 303 orders 1457 lines 1338 units 06/27 10:00 UVERSE DTC: 673 orders 3171 lines 2850 units 06/27 11:00 UVERSE DTC: 278 orders 1884 lines 1903 units 06/27 12:00 UVERSE DTC: 396 orders 2679 lines 2914 units 06/27 13:00 UVERSE DTC: 240 orders 963 lines 842 units 06/27 14:00 UVERSE DTC: 307 orders 2002 lines 2023 units 06/27 15:00 UVERSE DTC: 275 orders 1740 lines 1800 units 06/27 16:00 UVERSE DTC: 96 orders 377 lines 319 units 06/27 17:00 UVERSE DTC: 226 orders 1542 lines 1347 units 06/27 18:00 UVERSE DTC: 372 orders 1999 lines 1505 units 06/27 19:00 UVERSE DTC: 190 orders 1283 lines 1318 units 06/27 20:00 UVERSE DTC: 302 orders 1824 lines 1476 units 06/27 21:00 UVERSE DTC: 216 orders 1152 lines 892 units 06/27 22:00 UVERSE DTC: 309 orders 1827 lines 1647 units 06/27 23:00 UVERSE DTC: 1524 orders 7995 lines 7254 units 06/28 04:00 UVERSE DTC: 49 orders 474 lines 479 units 06/27 07:00 Wireless BULK: 53 orders 149 lines 266 units 06/27 08:00 Wireless BULK: 314 orders 1437 lines 4789 units 06/27 09:00 Wireless BULK: 52 orders 268 lines 856 units 06/27 10:00 Wireless BULK: 92 orders 295 lines 1033 units 06/27 11:00 Wireless BULK: 174 orders 749 lines 2757 units 06/27 12:00 Wireless BULK: 42 orders 345 lines 884 units 06/27 13:00 Wireless BULK: 260 orders 5481 lines 19102 units 06/27 14:00 Wireless BULK: 99 orders 1854 lines 6537 units 06/27 15:00 Wireless BULK: 64 orders 486 lines 1263 units 06/27 16:00 Wireless BULK: 46 orders 559 lines 1716 units 06/27 17:00 Wireless BULK: 120 orders 1296 lines 4535 units 06/27 18:00 Wireless BULK: 99 orders 1593 lines 5831 units 06/27 19:00 Wireless BULK: 246 orders 1458 lines 6340 units 06/27 20:00 Wireless BULK: 315 orders 1066 lines 4995 units 06/27 21:00 Wireless BULK: 381 orders 2322 lines 9580 units 06/27 22:00 Wireless BULK: 387 orders 2404 lines 9180 units 06/27 23:00 Wireless BULK: 394 orders 2659 lines 10226 units 06/28 00:00 Wireless BULK: 661 orders 3064 lines 11606 units 06/28 01:00 Wireless BULK: 149 orders 2639 lines 31876 units 06/28 02:00 Wireless BULK: 28 orders 201 lines 748 units 06/28 03:00 Wireless BULK: 22 orders 472 lines 1580 units 06/28 04:00 Wireless BULK: 18 orders 369 lines 1569 units 06/27 12:00 DSL LFO (BULK): 3 orders 3 lines 144 units 06/27 13:00 DSL LFO (BULK): 6 orders 6 lines 252 units 06/27 14:00 DSL LFO (BULK): 4 orders 4 lines 168 units 06/27 15:00 DSL LFO (BULK): 14 orders 14 lines 600 units 06/27 17:00 DSL LFO (BULK): 5 orders 6 lines 139 units 06/27 18:00 DSL LFO (BULK): 1 orders 2 lines 19 units
Data Below is calculated Midnight-to-Midnight (Eastern Time) **=--- ** Wireless DTC shipped 38718 order-lines, 8593 handsets and 30170 accessories. Total of 8061 orders or 8077 cartons shipped and cancelled/zero-shipped 121 orders on 06/27/2016 with avg order-entry to ship of 37.49 hrs verses an internal WMS cycle time of 4.51 hrs. Order SLA (7PM CDT) fill-rate: 99.9211% with 14 orders/180 lines missed SLA. Order shipped fill-rate: 99.8%. 7247 cartons w/one or more phones and 830 accy-only cartons shipped. 8734 orders, 38367 order-lines downloaded yesterday while available for planning is 87 orders and 808 lines. ** DSL DTC shipped 9133 order-lines, 705 modems/routers and 8319 components. Total of 1058 orders or 1092 cartons shipped and cancelled/zero-shipped 0 orders on 06/27/2016 with avg order-entry to ship of 35.42 hrs verses an internal WMS cycle time of 8.02 hrs. Order SLA (3PM CDT) fill-rate: 100% with 2 orders/20 lines missed SLA. Order shipped fill-rate: 100%. 705 cartons w/one or more modems/routers and 387 accy-only cartons shipped. 740 orders, 12912 order-lines downloaded yesterday while available for planning is 154 orders and 1649 lines. ** UVERSE DTC shipped 33757 order-lines, 3728 STBs/RGs and 27562 components. Total of 5961 orders or 5966 cartons shipped and cancelled/zero-shipped 0 orders on 06/27/2016 with avg order-entry to ship of 44.54 hrs verses an internal WMS cycle time of 5.6 hrs. Order SLA (9PM CDT) fill-rate: 93.5771% with 720 orders/5435 lines missed SLA. Order shipped fill-rate: 99.8%. 3642 cartons w/one or more STBs/RGs and 2324 accy-only cartons shipped. 6729 orders, 48088 order-lines downloaded yesterday while available for planning is 3081 orders and 22630 lines. ** Wireless BULK shipped 24421 order-lines, 22465 handsets and 67425 accessories. Total of 3138 orders or 6440 cartons shipped and cancelled/zero-shipped 6 orders on 06/27/2016 with avg order-entry to ship of 466.43 hrs verses an internal WMS cycle time of 9.79 hrs. Order SLA (5PM CDT) fill-rate: 86.3166% with 558 orders/6539 lines missed SLA. Order shipped fill-rate: 99.6%. 4937 cartons w/one or more phones and 1503 accy-only cartons shipped. 3728 orders, 34313 order-lines downloaded yesterday while available for planning is 58 orders and 105 lines. ** DSL LFO(BULK) shipped 35 order-lines, 1292 modem/routers and 30 components. Total of 33 orders or 222 cartons shipped and cancelled/zero-shipped 0 orders on 06/27/2016 with avg order-entry to ship of 181.61 hrs verses an internal WMS cycle time of 47.6 hrs. Order SLA (3PM CDT) fill-rate: 100% with 3 orders/5 lines missed SLA. Order shipped fill-rate: 99.9%. 3 cartons w/one or more modems/routers and 219 accy-only cartons shipped. 6 orders, 13 order-lines downloaded yesterday while available for planning is 0 orders and 0 lines. ---=** Data Above is calculated Midnight-to-Midnight (Eastern Time) **=--- ---=** Data Below is calculated based on Carryover Cutoff time (4am-4am) **=--- ---=** [Hours are displayed in Eastern Time] **=--- ** MDC WMS Orders shipped by hour - 06/27/2016 06/27 07:00 Wireless DTC: 25 orders 111 lines 111 units 06/27 08:00 Wireless DTC: 414 orders 2075 lines 2076 units 06/27 09:00 Wireless DTC: 566 orders 2134 lines 2141 units 06/27 10:00 Wireless DTC: 722 orders 3026 lines 3026 units 06/27 11:00 Wireless DTC: 514 orders 2295 lines 2295 units 06/27 12:00 Wireless DTC: 688 orders 3140 lines 3140 units 06/27 13:00 Wireless DTC: 128 orders 540 lines 541 units 06/27 14:00 Wireless DTC: 535 orders 2729 lines 2731 units 06/27 15:00 Wireless DTC: 491 orders 2379 lines 2380 units 06/27 16:00 Wireless DTC: 250 orders 1290 lines 1292 units 06/27 17:00 Wireless DTC: 705 orders 3451 lines 3452 units 06/27 18:00 Wireless DTC: 606 orders 3182 lines 3183 units 06/27 19:00 Wireless DTC: 396 orders 1878 lines 1886 units 06/27 20:00 Wireless DTC: 599 orders 2923 lines 2925 units 06/27 21:00 Wireless DTC: 428 orders 2056 lines 2058 units 06/27 22:00 Wireless DTC: 508 orders 2709 lines 2731 units 06/27 23:00 Wireless DTC: 484 orders 2773 lines 2768 units 06/28 04:00 Wireless DTC: 41 orders 241 lines 239 units 06/27 08:00 DSL DTC: 23 orders 271 lines 287 units 06/27 09:00 DSL DTC: 44 orders 415 lines 423 units 06/27 10:00 DSL DTC: 100 orders 1036 lines 1040 units 06/27 11:00 DSL DTC: 61 orders 549 lines 520 units 06/27 12:00 DSL DTC: 82 orders 625 lines 575 units 06/27 13:00 DSL DTC: 61 orders 427 lines 404 units 06/27 14:00 DSL DTC: 85 orders 748 lines 708 units 06/27 15:00 DSL DTC: 39 orders 318 lines 316 units 06/27 17:00 DSL DTC: 60 orders 527 lines 561 units 06/27 18:00 DSL DTC: 61 orders 515 lines 545 units 06/27 19:00 DSL DTC: 44 orders 334 lines 338 units 06/27 20:00 DSL DTC: 64 orders 522 lines 516 units 06/27 21:00 DSL DTC: 26 orders 178 lines 170 units 06/27 22:00 DSL DTC: 84 orders 721 lines 690 units 06/27 23:00 DSL DTC: 224 orders 1947 lines 1931 units 06/28 04:00 DSL DTC: 7 orders 54 lines 47 units 06/27 07:00 UVERSE DTC: 12 orders 73 lines 49 units 06/27 08:00 UVERSE DTC: 241 orders 1779 lines 1812 units 06/27 09:00 UVERSE DTC: 303 orders 1457 lines 1338 units 06/27 10:00 UVERSE DTC: 673 orders 3171 lines 2850 units 06/27 11:00 UVERSE DTC: 278 orders 1884 lines 1903 units 06/27 12:00 UVERSE DTC: 396 orders 2679 lines 2914 units 06/27 13:00 UVERSE DTC: 240 orders 963 lines 842 units 06/27 14:00 UVERSE DTC: 307 orders 2002 lines 2023 units 06/27 15:00 UVERSE DTC: 275 orders 1740 lines 1800 units 06/27 16:00 UVERSE DTC: 96 orders 377 lines 319 units 06/27 17:00 UVERSE DTC: 226 orders 1542 lines 1347 units 06/27 18:00 UVERSE DTC: 372 orders 1999 lines 1505 units 06/27 19:00 UVERSE DTC: 190 orders 1283 lines 1318 units 06/27 20:00 UVERSE DTC: 302 orders 1824 lines 1476 units 06/27 21:00 UVERSE DTC: 216 orders 1152 lines 892 units 06/27 22:00 UVERSE DTC: 309 orders 1827 lines 1647 units 06/27 23:00 UVERSE DTC: 1524 orders 7995 lines 7254 units 06/28 04:00 UVERSE DTC: 49 orders 474 lines 479 units 06/27 07:00 Wireless BULK: 53 orders 149 lines 266 units 06/27 08:00 Wireless BULK: 314 orders 1437 lines 4789 units 06/27 09:00 Wireless BULK: 52 orders 268 lines 856 units 06/27 10:00 Wireless BULK: 92 orders 295 lines 1033 units 06/27 11:00 Wireless BULK: 174 orders 749 lines 2757 units 06/27 12:00 Wireless BULK: 42 orders 345 lines 884 units 06/27 13:00 Wireless BULK: 260 orders 5481 lines 19102 units 06/27 14:00 Wireless BULK: 99 orders 1854 lines 6537 units 06/27 15:00 Wireless BULK: 64 orders 486 lines 1263 units 06/27 16:00 Wireless BULK: 46 orders 559 lines 1716 units 06/27 17:00 Wireless BULK: 120 orders 1296 lines 4535 units 06/27 18:00 Wireless BULK: 99 orders 1593 lines 5831 units 06/27 19:00 Wireless BULK: 246 orders 1458 lines 6340 units 06/27 20:00 Wireless BULK: 315 orders 1066 lines 4995 units 06/27 21:00 Wireless BULK: 381 orders 2322 lines 9580 units 06/27 22:00 Wireless BULK: 387 orders 2404 lines 9180 units 06/27 23:00 Wireless BULK: 394 orders 2659 lines 10226 units 06/28 00:00 Wireless BULK: 661 orders 3064 lines 11606 units 06/28 01:00 Wireless BULK: 149 orders 2639 lines 31876 units 06/28 02:00 Wireless BULK: 28 orders 201 lines 748 units 06/28 03:00 Wireless BULK: 22 orders 472 lines 1580 units 06/28 04:00 Wireless BULK: 18 orders 369 lines 1569 units 06/27 12:00 DSL LFO (BULK): 3 orders 3 lines 144 units 06/27 13:00 DSL LFO (BULK): 6 orders 6 lines 252 units 06/27 14:00 DSL LFO (BULK): 4 orders 4 lines 168 units 06/27 15:00 DSL LFO (BULK): 14 orders 14 lines 600 units 06/27 17:00 DSL LFO (BULK): 5 orders 6 lines 139 units 06/27 18:00 DSL LFO (BULK): 1 orders 2 lines 19 units