Spreadsheet: 62661d1263566771-auto-populate-the-selection-from-the-database-selected-data
Sheet: Data

Table Define
State ID | Product ID | Quantity | Gross Sales | Net Sales | Cost | Number of Orders
Montana | Product 1 | 102 | 10200 | 8364 | 7650 | 2
Nebraska | Product 1 | 158 | 15800 | 12956 | 11850 | 3
North Carolina | Product 1 | 212 | 21200 | 17384 | 15900 | 2
Michigan | Product 1 | 50 | 5000 | 4100 | 3750 | 1
Alabama | Product 1 | 102 | 10200 | 8364 | 7650 | 2
Florida | Product 1 | 50 | 5000 | 4100 | 3750 | 1
Texas | Product 1 | 149 | 14900 | 12218 | 11175 | 3
California | Product 1 | 152 | 15200 | 12464 | 11400 | 3
Nevada | Product 1 | 106 | 10600 | 8692 | 7950 | 2
Oregon | Product 1 | 50 | 5000 | 4100 | 3750 | 1
Utah | Product 1 | 49 | 4900 | 4018 | 3675 | 1
Montana | Product 10 | 10 | 5000 | 4050 | 3750 | 2
Nebraska | Product 10 | 15 | 7500 | 6075 | 5625 | 3
Maine | Product 10 | 104 | 52000 | 42120 | 39000 | 1
North Carolina | Product 10 | 598 | 299000 | 242190 | 224250 | 3
West Virginia | Product 10 | 200 | 100000 | 81000 | 75000 | 1
Michigan | Product 10 | 208 | 104000 | 84240 | 78000 | 2
Alabama | Product 10 | 413 | 206500 | 167265 | 154875 | 4
Texas | Product 10 | 99 | 49500 | 40095 | 37125 | 1
Oregon | Product 10 | 103 | 51500 | 41715 | 38625 | 1
Utah | Product 10 | 205 | 102500 | 83025 | 76875 | 2
Colorado | Product 11 | 315 | 4725 | 3826 | 3465 | 3
Montana | Product 11 | 20 | 300 | 240 | 220 | 4
Nebraska | Product 11 | 5 | 75 | 60 | 55 | 1
Maine | Product 11 | 204 | 3060 | 2478 | 2244 | 2
North Carolina | Product 11 | 794 | 11910 | 9645 | 8734 | 4
West Virginia | Product 11 | 212 | 3180 | 2575 | 2332 | 1
Alabama | Product 11 | 106 | 1590 | 1287 | 1166 | 1
Texas | Product 11 | 300 | 4500 | 3644 | 3300 | 3
California | Product 11 | 306 | 4590 | 3717 | 3366 | 3
Oregon | Product 11 | 203 | 3045 | 2466 | 2233 | 2
Utah | Product 11 | 202 | 3030 | 2453 | 2222 | 2
Colorado | Product 12 | 98 | 19600 | 15876 | 14700 | 1
Montana | Product 12 | 10 | 2000 | 1620 | 1500 | 2
Nebraska | Product 12 | 10 | 2000 | 1620 | 1500 | 2
Maine | Product 12 | 201 | 40200 | 32562 | 30150 | 2
North Carolina | Product 12 | 608 | 121600 | 98496 | 91200 | 3
West Virginia | Product 12 | 414 | 82800 | 67068 | 62100 | 2
Michigan | Product 12 | 204 | 40800 | 33048 | 30600 | 2
Alabama | Product 12 | 206 | 41200 | 33372 | 30900 | 2
Texas | Product 12 | 199 | 39800 | 32238 | 29850 | 2
California | Product 12 | 199 | 39800 | 32238 | 29850 | 2
Oregon | Product 12 | 516 | 103200 | 83592 | 77400 | 5
Utah | Product 12 | 100 | 20000 | 16200 | 15000 | 1
Nebraska | Product 14 | 211 | 105500 | 86510 | 79125 | 2
Maine | Product 14 | 209 | 104500 | 85690 | 78375 | 2
North Carolina | Product 14 | 404 | 202000 | 165640 | 151500 | 2
West Virginia | Product 14 | 418 | 209000 | 171380 | 156750 | 2
Michigan | Product 14 | 99 | 49500 | 40590 | 37125 | 1
Alabama | Product 14 | 103 | 51500 | 42230 | 38625 | 1
Florida | Product 14 | 106 | 53000 | 43460 | 39750 | 1
Texas | Product 14 | 104 | 52000 | 42640 | 39000 | 1
Arizona | Product 14 | 104 | 52000 | 42640 | 39000 | 1
California | Product 14 | 305 | 152500 | 125050 | 114375 | 3
Oregon | Product 14 | 212 | 106000 | 86920 | 79500 | 2
Utah | Product 14 | 203 | 101500 | 83230 | 76125 | 2
Colorado | Product 15 | 202 | 202000 | 165640 | 151500 | 4
Nebraska | Product 15 | 51 | 51000 | 41820 | 38250 | 1
Maine | Product 15 | 51 | 51000 | 41820 | 38250 | 1
New York | Product 15 | 51 | 51000 | 41820 | 38250 | 1
West Virginia | Product 15 | 206 | 206000 | 168920 | 154500 | 2
Michigan | Product 15 | 103 | 103000 | 84460 | 77250 | 2
Alabama | Product 15 | 103 | 103000 | 84460 | 77250 | 2
Florida | Product 15 | 54 | 54000 | 44280 | 40500 | 1
Texas | Product 15 | 50 | 50000 | 41000 | 37500 | 1
Nevada | Product 15 | 52 | 52000 | 42640 | 39000 | 1
Oregon | Product 15 | 150 | 150000 | 123000 | 112500 | 3
Colorado | Product 16 | 59 | 88500 | 72570 | 66375 | 2
Nebraska | Product 16 | 30 | 45000 | 36900 | 33750 | 1
Maine | Product 16 | 60 | 90000 | 73800 | 67500 | 2
New York | Product 16 | 30 | 45000 | 36900 | 33750 | 1
North Carolina | Product 16 | 182 | 273000 | 223860 | 204750 | 3
West Virginia | Product 16 | 124 | 186000 | 152520 | 139500 | 2
Michigan | Product 16 | 90 | 135000 | 110700 | 101250 | 3
Alabama | Product 16 | 61 | 91500 | 75030 | 68625 | 2
Florida | Product 16 | 30 | 45000 | 36900 | 33750 | 1
Texas | Product 16 | 30 | 45000 | 36900 | 33750 | 1
California | Product 16 | 151 | 226500 | 185730 | 169875 | 5
Utah | Product 16 | 30 | 45000 | 36900 | 33750 | 1
Colorado | Product 17 | 29 | 55100 | 45182 | 41325 | 1
Montana | Product 17 | 61 | 115900 | 95038 | 86925 | 2
Nebraska | Product 17 | 32 | 60800 | 49856 | 45600 | 1
Maine | Product 17 | 90 | 171000 | 140220 | 128250 | 3
North Carolina | Product 17 | 119 | 226100 | 185402 | 169575 | 2
West Virginia | Product 17 | 120 | 228000 | 186960 | 171000 | 2
Michigan | Product 17 | 30 | 57000 | 46740 | 42750 | 1
Florida | Product 17 | 30 | 57000 | 46740 | 42750 | 1
Arizona | Product 17 | 30 | 57000 | 46740 | 42750 | 1
California | Product 17 | 119 | 226100 | 185402 | 169575 | 4
Nevada | Product 17 | 60 | 114000 | 93480 | 85500 | 2
Oregon | Product 17 | 60 | 114000 | 93480 | 85500 | 2
Colorado | Product 18 | 100 | 10000 | 8200 | 7500 | 1
Montana | Product 18 | 100 | 10000 | 8200 | 7500 | 1
Nebraska | Product 18 | 208 | 20800 | 17056 | 15600 | 2
Maine | Product 18 | 309 | 30900 | 25338 | 23175 | 3
North Carolina | Product 18 | 1206 | 120600 | 98892 | 90450 | 6
Michigan | Product 18 | 104 | 10400 | 8528 | 7800 | 1
Alabama | Product 18 | 100 | 10000 | 8200 | 7500 | 1
Texas | Product 18 | 99 | 9900 | 8118 | 7425 | 1
California | Product 18 | 300 | 30000 | 24600 | 22500 | 3
Nevada | Product 18 | 100 | 10000 | 8200 | 7500 | 1
Utah | Product 18 | 199 | 19900 | 16318 | 14925 | 2
Colorado | Product 2 | 51 | 10200 | 8364 | 7650 | 1
Nebraska | Product 2 | 101 | 20200 | 16564 | 15150 | 2
Maine | Product 2 | 102 | 20400 | 16728 | 15300 | 2
North Carolina | Product 2 | 101 | 20200 | 16564 | 15150 | 1
Michigan | Product 2 | 49 | 9800 | 8036 | 7350 | 1
Alabama | Product 2 | 157 | 31400 | 25748 | 23550 | 3
Florida | Product 2 | 50 | 10000 | 8200 | 7500 | 1
Texas | Product 2 | 103 | 20600 | 16892 | 15450 | 2
Arizona | Product 2 | 50 | 10000 | 8200 | 7500 | 1
California | Product 2 | 204 | 40800 | 33456 | 30600 | 4
Nevada | Product 2 | 51 | 10200 | 8364 | 7650 | 1
Oregon | Product 2 | 50 | 10000 | 8200 | 7500 | 1
Utah | Product 2 | 100 | 20000 | 16400 | 15000 | 2
Colorado | Product 22 | 103 | 72100 | 59122 | 54075 | 1
Nebraska | Product 22 | 316 | 221200 | 181384 | 165900 | 3
Maine | Product 22 | 100 | 70000 | 57400 | 52500 | 1
North Carolina | Product 22 | 416 | 291200 | 238784 | 218400 | 2
West Virginia | Product 22 | 418 | 292600 | 239932 | 219450 | 2
Alabama | Product 22 | 109 | 76300 | 62566 | 57225 | 1
Texas | Product 22 | 204 | 142800 | 117096 | 107100 | 2
California | Product 22 | 307 | 214900 | 176218 | 161175 | 3
Utah | Product 22 | 100 | 70000 | 57400 | 52500 | 1
Colorado | Product 23 | 209 | 188100 | 154242 | 141075 | 2
Nebraska | Product 23 | 100 | 90000 | 73800 | 67500 | 1
North Carolina | Product 23 | 200 | 180000 | 147600 | 135000 | 1
West Virginia | Product 23 | 218 | 196200 | 160884 | 147150 | 1
Michigan | Product 23 | 201 | 180900 | 148338 | 135675 | 2
Alabama | Product 23 | 109 | 98100 | 80442 | 73575 | 1
Florida | Product 23 | 106 | 95400 | 78228 | 71550 | 1
California | Product 23 | 304 | 273600 | 224352 | 205200 | 3
Oregon | Product 23 | 198 | 178200 | 146124 | 133650 | 2
Utah | Product 23 | 100 | 90000 | 73800 | 67500 | 1
Colorado | Product 24 | 203 | 121800 | 99876 | 91350 | 2
Nebraska | Product 24 | 206 | 123600 | 101352 | 92700 | 2
Maine | Product 24 | 100 | 60000 | 49200 | 45000 | 1
North Carolina | Product 24 | 202 | 121200 | 99384 | 90900 | 1
Michigan | Product 24 | 101 | 60600 | 49692 | 45450 | 1
Alabama | Product 24 | 208 | 124800 | 102336 | 93600 | 2
Texas | Product 24 | 303 | 181800 | 149076 | 136350 | 3
Oregon | Product 24 | 100 | 60000 | 49200 | 45000 | 1
Colorado | Product 3 | 49 | 490 | 401 | 343 | 1
Montana | Product 3 | 50 | 500 | 410 | 350 | 1
Nebraska | Product 3 | 206 | 2060 | 1688 | 1442 | 4
Maine | Product 3 | 107 | 1070 | 876 | 749 | 2
North Carolina | Product 3 | 199 | 1990 | 1631 | 1393 | 2
West Virginia | Product 3 | 210 | 2100 | 1721 | 1470 | 2
Michigan | Product 3 | 50 | 500 | 410 | 350 | 1
Alabama | Product 3 | 53 | 530 | 434 | 371 | 1
Arizona | Product 3 | 50 | 500 | 410 | 350 | 1
California | Product 3 | 50 | 500 | 410 | 350 | 1
Nevada | Product 3 | 51 | 510 | 418 | 357 | 1
Oregon | Product 3 | 202 | 2020 | 1654 | 1414 | 4
Utah | Product 3 | 50 | 500 | 410 | 350 | 1
Colorado | Product 4 | 104 | 2080 | 1705 | 1560 | 2
Montana | Product 4 | 50 | 1000 | 820 | 750 | 1
Nebraska | Product 4 | 103 | 2060 | 1689 | 1545 | 2
Maine | Product 4 | 158 | 3160 | 2590 | 2370 | 3
New York | Product 4 | 103 | 2060 | 1689 | 1545 | 2
North Carolina | Product 4 | 201 | 4020 | 3296 | 3015 | 2
West Virginia | Product 4 | 303 | 6060 | 4969 | 4545 | 3
Michigan | Product 4 | 151 | 3020 | 2475 | 2265 | 3
Alabama | Product 4 | 104 | 2080 | 1705 | 1560 | 2
Texas | Product 4 | 50 | 1000 | 820 | 750 | 1
Arizona | Product 4 | 202 | 4040 | 3312 | 3030 | 4
California | Product 4 | 48 | 960 | 787 | 720 | 1
Nevada | Product 4 | 50 | 1000 | 820 | 750 | 1
Oregon | Product 4 | 152 | 3040 | 2492 | 2280 | 3
Utah | Product 4 | 50 | 1000 | 820 | 750 | 1
Colorado | Product 5 | 61 | 61000 | 50020 | 45750 | 1
Nebraska | Product 5 | 61 | 61000 | 50020 | 45750 | 1
Maine | Product 5 | 63 | 63000 | 51660 | 47250 | 1
New York | Product 5 | 121 | 121000 | 99220 | 90750 | 2
North Carolina | Product 5 | 356 | 356000 | 291920 | 267000 | 3
West Virginia | Product 5 | 482 | 482000 | 395240 | 361500 | 2
Michigan | Product 5 | 121 | 121000 | 99220 | 90750 | 2
Alabama | Product 5 | 125 | 125000 | 102500 | 93750 | 2
Texas | Product 5 | 119 | 119000 | 97580 | 89250 | 2
Arizona | Product 5 | 62 | 62000 | 50840 | 46500 | 1
California | Product 5 | 240 | 240000 | 196800 | 180000 | 4
Oregon | Product 5 | 300 | 300000 | 246000 | 225000 | 5
Utah | Product 5 | 58 | 58000 | 47560 | 43500 | 1
Colorado | Product 6 | 60 | 30000 | 24600 | 22500 | 1
Nebraska | Product 6 | 123 | 61500 | 50430 | 46125 | 2
Maine | Product 6 | 60 | 30000 | 24600 | 22500 | 1
New York | Product 6 | 121 | 60500 | 49610 | 45375 | 2
North Carolina | Product 6 | 254 | 127000 | 104140 | 95250 | 2
West Virginia | Product 6 | 503 | 251500 | 206230 | 188625 | 2
Michigan | Product 6 | 247 | 123500 | 101270 | 92625 | 4
Alabama | Product 6 | 60 | 30000 | 24600 | 22500 | 1
Texas | Product 6 | 124 | 62000 | 50840 | 46500 | 2
California | Product 6 | 298 | 149000 | 122180 | 111750 | 5
Oregon | Product 6 | 238 | 119000 | 97580 | 89250 | 4
Utah | Product 6 | 120 | 60000 | 49200 | 45000 | 2
Colorado | Product 7 | 412 | 4120 | 3378 | 2884 | 2
Montana | Product 7 | 208 | 2080 | 1705 | 1456 | 1
Nebraska | Product 7 | 200 | 2000 | 1640 | 1400 | 1
Maine | Product 7 | 200 | 2000 | 1640 | 1400 | 1
New York | Product 7 | 206 | 2060 | 1689 | 1442 | 1
North Carolina | Product 7 | 812 | 8120 | 6658 | 5684 | 2
West Virginia | Product 7 | 1656 | 16560 | 13579 | 11592 | 2
Alabama | Product 7 | 412 | 4120 | 3378 | 2884 | 2
Florida | Product 7 | 400 | 4000 | 3280 | 2800 | 1
Texas | Product 7 | 200 | 2000 | 1640 | 1400 | 1
Arizona | Product 7 | 212 | 2120 | 1738 | 1484 | 1
California | Product 7 | 418 | 4180 | 3427 | 2926 | 2
Nevada | Product 7 | 418 | 4180 | 3427 | 2926 | 2
Oregon | Product 7 | 206 | 2060 | 1689 | 1442 | 1
Utah | Product 7 | 400 | 4000 | 3280 | 2800 | 2
Nebraska | Product 8 | 630 | 12600 | 10331 | 9450 | 3
Maine | Product 8 | 208 | 4160 | 3411 | 3120 | 1
North Carolina | Product 8 | 824 | 16480 | 13513 | 12360 | 2
West Virginia | Product 8 | 1624 | 32480 | 26633 | 24360 | 2
Michigan | Product 8 | 400 | 8000 | 6560 | 6000 | 2
California | Product 8 | 394 | 7880 | 6461 | 5910 | 2
Nevada | Product 8 | 630 | 12600 | 10330 | 9450 | 3
Oregon | Product 8 | 808 | 16160 | 13250 | 12120 | 4
Colorado | Product 9 | 98 | 68600 | 55566 | 51450 | 1
Nebraska | Product 9 | 5 | 3500 | 2835 | 2625 | 1
Maine | Product 9 | 415 | 290500 | 235305 | 217875 | 4
North Carolina | Product 9 | 202 | 141400 | 114534 | 106050 | 1
West Virginia | Product 9 | 206 | 144200 | 116802 | 108150 | 1
Michigan | Product 9 | 203 | 142100 | 115101 | 106575 | 2
Alabama | Product 9 | 100 | 70000 | 56700 | 52500 | 1
Texas | Product 9 | 213 | 149100 | 120771 | 111825 | 2
California | Product 9 | 103 | 72100 | 58401 | 54075 | 1
Nevada | Product 9 | 5 | 3500 | 2835 | 2625 | 1
Oregon | Product 9 | 203 | 142100 | 115101 | 106575 | 2
Utah | Product 9 | 201 | 140700 | 113967 | 105525 | 2
Validation Listing
Alabama
Arizona
California
Colorado
Florida
Maine
Michigan
Montana
Nebraska
Nevada
Nevada
New York
North Carolina
Oregon
Texas
Utah
West Virginia