Spreadsheet: 718345d1613103601-extract-from-tables-from-multiple-tabs-one-workbook-excel-help-take-3v2
Sheet: Input PQ

Name | Store | Date | CAT1 | CAT2 | CAT3 | CAT4 | CAT5 | CAT7 | CAT8 | CAT9 | CAT10 | CAT11 | CAT12 | CAT13 | CAT14 | CAT15 | CAT16 | CAT17 | CAT18 | CAT19 | [NAME]
2019 | AAA | 2019-01-01 00:00:00 | -59360.66959002035 | -7433.230785566619 | -1738.445474160763 | -1133.057237296593 | -480.9284928549832 | 5243.758811878203 | 1144.525670481536 | 1056.485234290648 | 1320.60654286331 | 1320.60654286331 | 4187.051315121751 | 4066.136880104988 | 542.6218332799306 | 1145.534981368742 | 1326.408925795386 | 874.6992 | 13769.43597989679 | 7922.477894623336
2019 | AAA | 2019-10-01 00:00:00 | -59476.97860821536 | -7476.005086506792 | -1758.928695137545 | -1113.016966832793 | -472.422358519213 | 5273.690001556623 | 1151.058582494461 | 1062.515614610272 | 1328.144518262839 | 1328.144518262839 | 4210.950855814261 | 4089.346245482578 | 545.7190994964399 | 1152.073654492484 | 1333.980020991298 | 873.6504 | 13440.36321324735 | 8225.541172214602
2019 | AAA | 2019-11-01 00:00:00 | -60583.21909690577 | -7615.054845150835 | -1791.643842826835 | -1133.718496435034 | -481.2091656668844 | 5355.999589372655 | 1169.023832148737 | 1079.09892198345 | 1348.873652479312 | 1348.873652479312 | 4276.673647475001 | 4153.171082324212 | 554.2364590927813 | 1170.054746973649 | 1354.80023333791 | 873.6504 | 13440.36321324735 | 8225.541172214602
2019 | AAA | 2019-12-01 00:00:00 | -60356.71337650798 | -7586.584032452511 | -1784.945328199102 | -1129.479802476686 | -479.410043230735 | 5431.109603828982 | 1185.417671518461 | 1094.231696786272 | 1367.78962098284 | 1367.78962098284 | 4336.647703508203 | 4211.413196579026 | 562.0088100349438 | 1186.463043407104 | 1373.799313418752 | 873.6504 | 13440.36321324735 | 8225.541172214602
2019 | AAA | 2019-02-01 00:00:00 | -60669.381295158 | -7597.109599657625 | -1776.772601474034 | -1158.037502500513 | -491.5314181973101 | 5310.470853156058 | 1159.086531595089 | 1069.926029164697 | 1337.407536455871 | 1337.407536455871 | 4240.319733862553 | 4117.867003689717 | 549.5251656868362 | 1160.108683116654 | 1343.2837383456 | 874.6992 | 13769.43597989679 | 7922.477894623336
2019 | AAA | 2019-03-01 00:00:00 | -59991.91995313048 | -7512.276889070465 | -1756.932366987113 | -1145.106339798434 | -486.042759386029 | 5406.837075000454 | 1180.119843504552 | 1089.341394004201 | 1361.676742505252 | 1361.676742505252 | 4317.266506279489 | 4192.591693114845 | 559.4970995303643 | 1181.160543452991 | 1367.659576629779 | 874.6992 | 13769.43597989679 | 7922.477894623336
2019 | AAA | 2019-04-01 00:00:00 | -60275.77883270602 | -7547.822117535544 | -1765.245500715332 | -1150.524546164624 | -488.3425283084591 | 5333.949545687118 | 1164.211093436161 | 1074.656393941072 | 1343.32049242634 | 1343.32049242634 | 4259.067066447116 | 4136.072947369074 | 551.9547303638692 | 1165.237764101502 | 1349.222674222791 | 874.6992 | 13769.43597989679 | 7922.477894623336
2019 | AAA | 2019-05-01 00:00:00 | -63225.90810517436 | -7947.229695491042 | -1869.796796082705 | -1183.172214042996 | -502.1998986081607 | 5627.938191514726 | 1228.378337592703 | 1133.887696239418 | 1417.359620299272 | 1417.359620299272 | 4493.811948945336 | 4364.038824141274 | 582.3765448838476 | 1229.461594754789 | 1423.587109716072 | 873.6504 | 13440.36321324735 | 8225.541172214602
2019 | AAA | 2019-06-01 00:00:00 | -66538.14924564176 | -8363.564421856092 | -1967.750594737475 | -1245.155533872773 | -528.5088471825565 | 5920.579969320795 | 1292.2516084601 | 1192.847638578554 | 1491.059548223192 | 1491.059548223192 | 4727.481380469701 | 4590.960307009884 | 612.6589860990549 | 1293.391192875782 | 1497.610854908801 | 873.6504 | 13440.36321324735 | 8225.541172214602
2019 | AAA | 2019-07-01 00:00:00 | -68846.42899869419 | -8653.705440763146 | -2036.013973090862 | -1288.351314651542 | -546.843385865874 | 6161.914095748629 | 1344.926247544227 | 1241.470382348517 | 1551.837977935646 | 1551.837977935646 | 4920.182533916058 | 4778.096601240903 | 637.6321343336086 | 1346.112283593174 | 1558.656328371043 | 873.6504 | 13440.36321324735 | 8225.541172214602
2019 | AAA | 2019-08-01 00:00:00 | -71065.57370712045 | -8932.642560907943 | -2101.641336781028 | -1329.879074973826 | -564.469929809136 | 6246.029865840086 | 1363.285722420134 | 1258.417589926278 | 1573.021987407847 | 1573.021987407847 | 4987.347531090625 | 4843.321995321298 | 646.3363968697475 | 1364.487948947245 | 1579.933414570494 | 873.6504 | 13440.36321324735 | 8225.541172214602
2019 | AAA | 2019-09-01 00:00:00 | -60190.6091815496 | -7565.70543647374 | -1780.033084138765 | -1126.371426907232 | -478.0906867775589 | 5336.961723828897 | 1164.86854457589 | 1075.263271916206 | 1344.079089895258 | 1344.079089895258 | 4261.472238939289 | 4138.40866284935 | 552.2664292203757 | 1165.895795020793 | 1349.984604760919 | 873.6504 | 13440.36321324735 | 8225.541172214602
2019 | BBB | 2019-01-01 00:00:00 | -50899.50573512211 | 0 | -1718.735962400319 | -961.3587437913684 | -480.9284928549832 | 5243.758811878203 | 1144.525670481536 | 1056.485234290648 | 1320.60654286331 | 1320.60654286331 | 3226.88590653045 | 7359.488701178739 | 1263.073691688113 | 779.1161327402472 | 916.607214988526 | 770.2824 | 10930.70723471122 | 3942.232463438781
2019 | BBB | 2019-10-01 00:00:00 | -52071.29229129528 | 0 | -1738.986956200158 | -1047.281001880864 | -472.422358519213 | 5273.690001556623 | 1151.058582494461 | 1062.515614610272 | 1328.144518262839 | 1328.144518262839 | 3245.304857058875 | 7401.496402172193 | 1270.283271609695 | 783.5633000465962 | 921.8391765254073 | 769.3588 | 10711.61437645819 | 4143.492060662848
2019 | BBB | 2019-11-01 00:00:00 | -53039.79091343455 | 0 | -1771.331198044134 | -1066.759877143651 | -481.2091656668844 | 5355.999589372655 | 1169.023832148737 | 1079.09892198345 | 1348.873652479312 | 1348.873652479312 | 3295.956242529587 | 7517.015918470043 | 1290.109331250086 | 795.7928342504588 | 936.2268638240691 | 769.3588 | 10711.61437645819 | 4143.492060662848
2019 | BBB | 2019-12-01 00:00:00 | -52841.48821130546 | 0 | -1764.708627387492 | -1062.771524955277 | -479.410043230735 | 5431.109603828982 | 1185.417671518461 | 1094.231696786272 | 1367.78962098284 | 1367.78962098284 | 3342.177179796839 | 7622.431007639396 | 1308.201216602861 | 806.9526579747536 | 949.3560682055925 | 769.3588 | 10711.61437645819 | 4143.492060662848
2019 | BBB | 2019-02-01 00:00:00 | -52021.67601051392 | 0 | -1756.628558416663 | -982.5536098453676 | -491.5314181973101 | 5310.470853156058 | 1159.086531595089 | 1069.926029164697 | 1337.407536455871 | 1337.407536455871 | 3267.938928516844 | 7453.117438050618 | 1279.142742016286 | 789.0281880944851 | 928.2684565817472 | 770.2824 | 10930.70723471122 | 3942.232463438781
2019 | BBB | 2019-03-01 00:00:00 | -51440.77879857191 | 0 | -1737.013261289448 | -971.581978473334 | -486.042759386029 | 5406.837075000454 | 1180.119843504552 | 1089.341394004201 | 1361.676742505252 | 1361.676742505252 | 3327.240436135935 | 7588.365100325362 | 1302.354648579059 | 803.3462528231911 | 945.1132386155189 | 770.2824 | 10930.70723471122 | 3942.232463438781
2019 | BBB | 2019-04-01 00:00:00 | -51684.17694028273 | 0 | -1745.232145408221 | -976.1791337575905 | -488.3425283084591 | 5333.949545687118 | 1164.211093436161 | 1074.656393941072 | 1343.32049242634 | 1343.32049242634 | 3282.387163981187 | 7486.069215315693 | 1284.798097251931 | 792.516645283851 | 932.372523863354 | 770.2824 | 10930.70723471122 | 3942.232463438781
2019 | BBB | 2019-05-01 00:00:00 | -53150.78436638101 | 0 | -1794.755434280142 | -1003.879518121363 | -502.1998986081607 | 5517.586462269339 | 1204.292487835983 | 1111.654604156292 | 1389.568255195365 | 1389.568255195365 | 3395.393005648727 | 7743.799187496104 | 1329.031054273585 | 819.8013640149622 | 964.472192958779 | 769.3588 | 10917.60087112043 | 3937.505566000605
2019 | BBB | 2019-06-01 00:00:00 | -55935.21593727419 | 0 | -1888.778010857633 | -1056.470159199432 | -528.5088471825565 | 5804.490166000778 | 1266.913341627549 | 1169.458469194661 | 1461.823086493326 | 1461.823086493326 | 3571.946800610698 | 8146.461598504588 | 1398.138069533363 | 862.4294314260239 | 1014.622860501205 | 769.3588 | 10917.60087112043 | 3937.505566000605
2019 | BBB | 2019-07-01 00:00:00 | -60274.11969288801 | 0 | -2012.930797953353 | -1212.259916775817 | -546.843385865874 | 6161.914095748629 | 1344.926247544227 | 1241.470382348517 | 1551.837977935646 | 1551.837977935646 | 3791.897084927256 | 8648.097441585638 | 1484.231419483337 | 915.5353731530085 | 1077.10043900354 | 769.3588 | 10711.61437645819 | 4143.492060662848
2019 | BBB | 2019-08-01 00:00:00 | -62216.9509437879 | 0 | -2077.814115703809 | -1251.335003438646 | -564.469929809136 | 6246.029865840086 | 1363.285722420134 | 1258.417589926278 | 1573.021987407847 | 1573.021987407847 | 3843.659952511903 | 8766.151891034524 | 1504.492537522927 | 928.0332693849389 | 1091.803846335222 | 769.3588 | 10711.61437645819 | 4143.492060662848
2019 | BBB | 2019-09-01 00:00:00 | -52696.06622974412 | 0 | -1759.852075572622 | -1059.846733350469 | -478.0906867775589 | 5336.961723828897 | 1164.86854457589 | 1075.263271916206 | 1344.079089895258 | 1344.079089895258 | 3284.240787601642 | 7490.296734504819 | 1285.523646061869 | 792.9641938209102 | 932.8990515540119 | 769.3588 | 10711.61437645819 | 4143.492060662848
2020 | AAA | 2020-01-01 00:00:00 | -60547.88298182077 | -7610.613244681299 | -1790.598838385586 | -1133.057237296593 | -480.9284928549832 | 5348.633988115768 | 1167.416183891166 | 1077.614938976461 | 1347.018673720576 | 1347.018673720576 | 4270.792341424187 | 4147.459617707088 | 553.4742699455293 | 1168.445680996117 | 1352.937104311294 | 874.6992 | 13456.49810305917 | 8235.415771460957
2020 | AAA | 2020-10-01 00:00:00 | -60666.51818037967 | -7476.005086506792 | -1811.696555991671 | -1113.016966832793 | -472.422358519213 | 5379.163801587755 | 1174.07975414435 | 1083.765926902477 | 1354.707408628096 | 1354.707408628096 | 4286.195425207417 | 4212.94673575229 | 559.3620769838509 | 1180.875495854796 | 1367.32952151608 | 873.6504 | 13115.45433694487 | 8550.450048517077
2020 | AAA | 2020-11-01 00:00:00 | -61794.88347884388 | -7615.054845150835 | -1845.39315811164 | -1133.718496435034 | -481.2091656668844 | 5463.119581160107 | 1192.404308791712 | 1100.680900423119 | 1375.851125528898 | 1375.851125528898 | 4353.092603206816 | 4278.700678287461 | 568.0923705701008 | 1199.306115647991 | 1388.670239171357 | 873.6504 | 13115.45433694487 | 8550.450048517077
2020 | AAA | 2020-12-01 00:00:00 | -61563.84764403814 | -7586.584032452511 | -1838.493688045075 | -1129.479802476686 | -479.410043230735 | 5539.731795905563 | 1209.126024948831 | 1116.116330721997 | 1395.145413402497 | 1395.145413402497 | 4414.138322666046 | 4338.703160445627 | 576.0590302858175 | 1216.124619492281 | 1408.14429625422 | 873.6504 | 13115.45433694487 | 8550.450048517077
2020 | AAA | 2020-02-01 00:00:00 | -61882.76892106117 | -7778.4027710694 | -1830.075779518255 | -1158.037502500513 | -491.5314181973101 | 5416.68027021918 | 1182.268262226991 | 1091.324549747991 | 1364.155687184989 | 1364.155687184989 | 4325.126128539805 | 4200.224343763512 | 560.515669000573 | 1183.310856778987 | 1370.149413112512 | 874.6992 | 13456.49810305917 | 8235.415771460957
2020 | AAA | 2020-03-01 00:00:00 | -61191.7583521931 | -7691.545660157345 | -1809.640337996727 | -1145.106339798434 | -486.042759386029 | 5514.973816500464 | 1203.722240374643 | 1111.128221884285 | 1388.910277355357 | 1388.910277355357 | 4403.611836405079 | 4276.443526977142 | 570.6870415209717 | 1204.783754322051 | 1395.012768162375 | 874.6992 | 13456.49810305917 | 8235.415771460957
2020 | AAA | 2020-04-01 00:00:00 | -61481.29440936015 | -7727.939120059981 | -1818.202865736792 | -1150.524546164624 | -488.3425283084591 | 5440.628536600861 | 1187.495315304885 | 1096.149521819894 | 1370.186902274867 | 1370.186902274867 | 4344.248407776059 | 4218.794406316456 | 562.9938249711466 | 1188.542519383532 | 1376.207127707247 | 874.6992 | 13456.49810305917 | 8235.415771460957
2020 | AAA | 2020-05-01 00:00:00 | -64490.42626727786 | -7947.229695491042 | -1925.890699965186 | -1183.172214042996 | -502.1998986081607 | 5740.496955345021 | 1252.945904344557 | 1156.565450164206 | 1445.706812705258 | 1445.706812705258 | 4574.110901987101 | 4495.941897600944 | 596.9359585059437 | 1260.198134623659 | 1459.176787458974 | 873.6504 | 13115.45433694487 | 8550.450048517077
2020 | AAA | 2020-06-01 00:00:00 | -67868.9122305546 | -8363.564421856092 | -2026.783112579599 | -1245.155533872773 | -528.5088471825565 | 6038.991568707211 | 1318.096640629302 | 1216.704591350125 | 1520.880739187656 | 1520.880739187656 | 4811.955722006234 | 4729.722082289258 | 627.9754607515312 | 1325.725972697677 | 1535.051126281521 | 873.6504 | 13115.45433694487 | 8550.450048517077
2020 | AAA | 2020-07-01 00:00:00 | -70223.35757866807 | -8653.705440763146 | -2097.094392283588 | -1288.351314651542 | -546.843385865874 | 6285.152377663601 | 1371.824772495111 | 1266.299789995487 | 1582.874737494359 | 1582.874737494359 | 5008.100210653858 | 4922.514571013409 | 653.5729376919488 | 1379.765090683003 | 1597.622736580319 | 873.6504 | 13115.45433694487 | 8550.450048517077
2020 | AAA | 2020-08-01 00:00:00 | -72486.88518126286 | -8932.642560907943 | -2164.690576884459 | -1329.879074973826 | -564.469929809136 | 6370.950463156888 | 1390.551436868537 | 1283.585941724803 | 1604.482427156004 | 1604.482427156004 | 5076.465364625249 | 4989.711402629885 | 662.4948067914912 | 1398.600147670926 | 1619.431749934756 | 873.6504 | 13115.45433694487 | 8550.450048517077
2020 | AAA | 2020-09-01 00:00:00 | -61394.4213651806 | -7565.70543647374 | -1833.434076662928 | -1126.371426907232 | -478.0906867775589 | 5443.700958305476 | 1188.165915467408 | 1096.76853735453 | 1370.960671693163 | 1370.960671693163 | 4337.619563992284 | 4263.492064683972 | 566.0730899508851 | 1195.043189896313 | 1383.734219879941 | 873.6504 | 13115.45433694487 | 8550.450048517077
2020 | BBB | 2020-01-01 00:00:00 | -53008.85462144249 | 0 | -1770.298041272328 | -1066.137672672698 | -480.9284928549832 | 5348.633988115768 | 1167.416183891166 | 1077.614938976461 | 1347.018673720576 | 1347.018673720576 | 3291.423624661059 | 7506.678475202314 | 1288.335165521875 | 794.6984553950521 | 934.9393592882965 | 770.2824 | 10724.4734573423 | 4148.466240807701 | 0
2020 | BBB | 2020-10-01 00:00:00 | -54050.0013983645 | 0 | -1791.156564886163 | -1140.720475327662 | -472.422358519213 | 5379.163801587755 | 1174.07975414435 | 1083.765926902477 | 1354.707408628096 | 1354.707408628096 | 3442.291508892417 | 8000.146846465533 | 1302.040353399938 | 803.1523825477611 | 944.8851559385425 | 769.3588 | 10494.85191328695 | 4360.25452383409 | 0
2020 | BBB | 2020-11-01 00:00:00 | -55055.30296814506 | 0 | -1824.471133985458 | -1161.937275602572 | -481.2091656668844 | 5463.119581160107 | 1192.404308791712 | 1100.680900423119 | 1375.851125528898 | 1375.851125528898 | 3496.017381129111 | 8125.00985305218 | 1322.362064531338 | 815.6876551067203 | 959.632535419671 | 769.3588 | 10494.85191328695 | 4360.25452383409 | 0
2020 | BBB | 2020-12-01 00:00:00 | -54849.46476333506 | 0 | -1817.649886209117 | -1157.593078585797 | -479.410043230735 | 5539.731795905563 | 1209.126024948831 | 1116.116330721997 | 1395.145413402497 | 1395.145413402497 | 3545.043881533853 | 8238.951162669053 | 1340.906247017932 | 827.1264744241224 | 973.0899699107323 | 769.3588 | 10494.85191328695 | 4360.25452383409 | 0
2020 | BBB | 2020-02-01 00:00:00 | -54177.52925058926 | 0 | -1809.327415169163 | -1089.642576865179 | -491.5314181973101 | 5416.68027021918 | 1182.268262226991 | 1091.324549747991 | 1364.155687184989 | 1364.155687184989 | 3333.297707087182 | 7602.179786811631 | 1304.725596856611 | 804.8087518563748 | 946.8338257133821 | 770.2824 | 10724.4734573423 | 4148.466240807701 | 0
2020 | BBB | 2020-03-01 00:00:00 | -53572.55882085507 | 0 | -1789.123659128131 | -1077.475142375249 | -486.042759386029 | 5514.973816500464 | 1203.722240374643 | 1111.128221884285 | 1388.910277355357 | 1388.910277355357 | 3393.785244858654 | 7740.132402331869 | 1328.40174155064 | 819.4131778796549 | 964.0155033878292 | 770.2824 | 10724.4734573423 | 4148.466240807701 | 0
2020 | BBB | 2020-04-01 00:00:00 | -53826.04373240255 | 0 | -1797.589109770467 | -1082.573343715098 | -488.3425283084591 | 5440.628536600861 | 1187.495315304885 | 1096.149521819894 | 1370.186902274867 | 1370.186902274867 | 3348.034907260811 | 7635.790599622007 | 1310.49405919697 | 808.3669781895278 | 951.019974340621 | 770.2824 | 10724.4734573423 | 4148.466240807701 | 0
2020 | BBB | 2020-05-01 00:00:00 | -55353.42948426706 | 0 | -1848.598097308547 | -1113.292805631326 | -502.1998986081607 | 5627.938191514726 | 1228.378337592703 | 1133.887696239418 | 1417.359620299272 | 1417.359620299272 | 3463.300865761702 | 7898.675171246027 | 1355.611675359057 | 836.1973912952615 | 983.7616368179546 | 769.3588 | 10711.61437645819 | 4143.492060662848 | 0
2020 | BBB | 2020-06-01 00:00:00 | -58253.25191305311 | 0 | -1945.441351183362 | -1171.615324717401 | -528.5088471825565 | 5920.579969320795 | 1292.2516084601 | 1192.847638578554 | 1491.059548223192 | 1491.059548223192 | 3643.385736622912 | 8309.39083047468 | 1426.10083092403 | 879.6780200545443 | 1034.915317711229 | 769.3588 | 10711.61437645819 | 4143.492060662848 | 0
2020 | BBB | 2020-07-01 00:00:00 | -62564.53624121775 | 0 | -2073.318721891954 | -1320.418976379456 | -546.843385865874 | 6285.152377663601 | 1371.824772495111 | 1266.299789995487 | 1582.874737494359 | 1582.874737494359 | 4022.061320263263 | 9347.575911125654 | 1521.33720497042 | 938.4237574818338 | 1104.027949978628 | 769.3588 | 10494.85191328695 | 4360.25452383409 | 0
2020 | BBB | 2020-08-01 00:00:00 | -64581.19507965184 | 0 | -2140.148539174923 | -1362.980381915736 | -564.469929809136 | 6370.950463156888 | 1390.551436868537 | 1283.585941724803 | 1604.482427156004 | 1604.482427156004 | 4076.966140429845 | 9475.178882221142 | 1542.104850961 | 951.2341011195623 | 1119.098942493603 | 769.3588 | 10494.85191328695 | 4360.25452383409 | 0
2020 | BBB | 2020-09-01 00:00:00 | -54698.51674647439 | 0 | -1812.6476378398 | -1154.407334106829 | -478.0906867775589 | 5443.700958305476 | 1188.165915467408 | 1096.76853735453 | 1370.960671693163 | 1370.960671693163 | 3483.590810191235 | 8096.12955861918 | 1317.661737213416 | 812.7882986664329 | 956.2215278428622 | 769.3588 | 10494.85191328695 | 4360.25452383409 | 0