Spreadsheet: 868118d1714836949-best-choice-to-get-desired-output-for-bulk-data-book12
Sheet: Output

 |  |  |  | Target Set |  |  |  |  |  | Times Target Achieve
 | IDs | Category | Period | Region-1 | [NAME] | Region-3 | Region-4 | Region-5 | Region-6 | Region-1 | [NAME] | Region-3 | Region-4 | Region-5 | Region-6
 | ID_110201307 | C | 1st_Quarter | 1000 | 400 | 300 | 100 | 0 | 0 | 5 | 0 | 1 | 1 | 0 | 0
 | ID_110201307 | C | 2nd_Quarter | 2800 | 600 | 400 | 100 | 100 | 0 | 12 | 1 | 3 | 0 | 1 | 0
 | ID_120402038 | B | 1st_Quarter | 1300 | 200 | 100 | 0 | 100 | 100 | 7 | 1 | 1 | 0 | 1 | 1
 | ID_120402038 | B | 2nd_Quarter | 3100 | 400 | 300 | 100 | 100 | 0 | 11 | 0 | 0 | 0 | 0 | 0
 | ID_130200761 | B | 1st_Quarter | 1400 | 200 | 0 | 100 | 100 | 0 | 6 | 1 | 0 | 1 | 1 | 0
 | ID_130201165 | C | 1st_Quarter | 1100 | 200 | 300 | 200 | 0 | 0 | 3 | 1 | 2 | 1 | 0 | 0
 | ID_130201165 | C | 2nd_Quarter | 2400 | 900 | 600 | 0 | 100 | 0 | 8 | 4 | 3 | 0 | 0 | 0
 | ID_130400664 | B | 2nd_Quarter | 2100 | 800 | 1000 | 0 | 100 | 0 | 6 | 4 | 3 | 0 | 0 | 0
 | ID_130402435 | B | 1st_Quarter | 1500 | 100 | 200 | 0 | 0 | 0 | 7 | 0 | 0 | 0 | 0 | 0
 | ID_130402435 | B | 2nd_Quarter | 2800 | 700 | 200 | 100 | 200 | 0 | 15 | 1 | 1 | 0 | 0 | 0
 | ID_140403468 | C | 1st_Quarter | 1300 | 200 | 100 | 100 | 100 | 0 | 1 | 0 | 0 | 1 | 0 | 0
 | ID_150200118 | C | 1st_Quarter | 1000 | 300 | 300 | 100 | 100 | 0 | 5 | 1 | 0 | 0 | 0 | 0
 | ID_150200118 | C | 2nd_Quarter | 2600 | 900 | 400 | 0 | 100 | 0 | 12 | 2 | 1 | 0 | 1 | 0
 | ID_150400754 | C | 1st_Quarter | 1200 | 500 | 0 | 0 | 0 | 0 | 7 | 4 | 0 | 0 | 0 | 0
 | ID_150400815 | B | 1st_Quarter | 1100 | 500 | 100 | 0 | 100 | 0 | 5 | 2 | 0 | 0 | 1 | 0
 | ID_150402497 | C | 2nd_Quarter | 2300 | 1000 | 400 | 100 | 100 | 100 | 9 | 5 | 0 | 1 | 0 | 0
 | ID_150403859 | B | 1st_Quarter | 1300 | 300 | 100 | 0 | 100 | 0 | 8 | 3 | 1 | 0 | 0 | 0
 | ID_150403859 | B | 2nd_Quarter | 2500 | 900 | 500 | 0 | 100 | 0 | 14 | 3 | 2 | 0 | 0 | 0
 | ID_160200991 | B | 1st_Quarter | 1100 | 400 | 100 | 0 | 100 | 100 | 3 | 2 | 0 | 0 | 1 | 0
 | ID_160201528 | C | 1st_Quarter | 1200 | 300 | 200 | 100 | 0 | 0 | 4 | 1 | 0 | 0 | 0 | 0
 | ID_160201528 | C | 2nd_Quarter | 2500 | 900 | 300 | 100 | 200 | 0 | 11 | 4 | 2 | 0 | 1 | 0
 | ID_160401403 | C | 1st_Quarter | 1100 | 400 | 100 | 200 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 0
 | ID_160401403 | C | 2nd_Quarter | 2700 | 600 | 500 | 100 | 100 | 0 | 8 | 2 | 0 | 0 | 1 | 0
 | ID_160401509 | C | 1st_Quarter | 1200 | 300 | 0 | 200 | 100 | 0 | 3 | 0 | 0 | 1 | 0 | 0
 | ID_160401509 | C | 2nd_Quarter | 3000 | 700 | 200 | 0 | 100 | 0 | 7 | 2 | 0 | 0 | 0 | 0
 | ID_160401749 | B | 1st_Quarter | 900 | 300 | 400 | 100 | 100 | 0 | 0 | 1 | 2 | 0 | 0 | 0
 | ID_160401749 | B | 2nd_Quarter | 2600 | 800 | 500 | 0 | 100 | 0 | 7 | 3 | 1 | 0 | 0 | 0
 | ID_160401803 | B | 1st_Quarter | 1300 | 100 | 200 | 100 | 0 | 100 | 7 | 0 | 1 | 0 | 0 | 1
 | ID_160401803 | B | 2nd_Quarter | 2500 | 800 | 400 | 100 | 200 | 0 | 11 | 2 | 2 | 1 | 0 | 0
 | ID_160402065 | C | 1st_Quarter | 1300 | 300 | 100 | 100 | 0 | 0 | 7 | 1 | 0 | 0 | 0 | 0
 | ID_160402065 | C | 2nd_Quarter | 2800 | 700 | 400 | 0 | 0 | 100 | 14 | 1 | 2 | 0 | 0 | 0
 | ID_160402190 | C | 1st_Quarter | 1200 | 200 | 300 | 100 | 0 | 0 | 4 | 0 | 1 | 0 | 0 | 0
 | ID_160402469 | C | 1st_Quarter | 1400 | 400 | 0 | 0 | 0 | 0 | 6 | 2 | 0 | 0 | 0 | 0
 | ID_160402469 | C | 2nd_Quarter | 2400 | 1200 | 400 | 0 | 0 | 0 | 6 | 4 | 1 | 0 | 0 | 0
 | ID_160402891 | C | 1st_Quarter | 1300 | 300 | 0 | 100 | 0 | 100 | 4 | 1 | 0 | 0 | 0 | 0
 | ID_160402891 | C | 2nd_Quarter | 2300 | 1300 | 300 | 100 | 0 | 0 | 8 | 4 | 1 | 0 | 0 | 0
 | ID_160403622 | B | 1st_Quarter | 1200 | 400 | 100 | 100 | 0 | 0 | 8 | 2 | 0 | 0 | 0 | 0
 | ID_160403622 | B | 2nd_Quarter | 3000 | 700 | 200 | 0 | 0 | 100 | 13 | 1 | 0 | 0 | 0 | 0
 | ID_160403687 | D | 1st_Quarter | 1400 | 200 | 200 | 0 | 0 | 0 | 7 | 2 | 1 | 0 | 0 | 0
 | ID_160403687 | D | 2nd_Quarter | 2700 | 800 | 400 | 100 | 0 | 0 | 10 | 4 | 1 | 0 | 0 | 0
 | ID_160403818 | C | 1st_Quarter | 1200 | 400 | 200 | 0 | 0 | 0 | 6 | 2 | 1 | 0 | 0 | 0
 | ID_160404214 | B | 1st_Quarter | 1300 | 300 | 100 | 100 | 0 | 0 | 6 | 0 | 1 | 0 | 0 | 0
 | ID_160404214 | B | 2nd_Quarter | 2800 | 700 | 400 | 100 | 0 | 0 | 10 | 3 | 1 | 1 | 0 | 0
 | ID_170200915 | C | 1st_Quarter | 1100 | 200 | 300 | 200 | 0 | 0 | 4 | 0 | 2 | 0 | 0 | 0
 | ID_170200915 | C | 2nd_Quarter | 2400 | 1100 | 500 | 0 | 0 | 0 | 13 | 3 | 2 | 0 | 0 | 0
 | ID_170200950 | B | 1st_Quarter | 1500 | 200 | 0 | 100 | 0 | 0 | 6 | 2 | 0 | 1 | 0 | 0
 | ID_170201079 | C | 1st_Quarter | 800 | 400 | 400 | 200 | 0 | 0 | 4 | 0 | 0 | 2 | 0 | 0
 | ID_170201079 | C | 2nd_Quarter | 2400 | 1000 | 500 | 100 | 0 | 0 | 9 | 8 | 1 | 0 | 0 | 0
 | ID_170201179 | C | 1st_Quarter | 1200 | 200 | 100 | 200 | 0 | 100 | 5 | 1 | 0 | 1 | 0 | 0
 | ID_170201179 | C | 2nd_Quarter | 2600 | 900 | 500 | 0 | 0 | 0 | 8 | 3 | 1 | 0 | 0 | 0
 | ID_170201315 | C | 1st_Quarter | 1400 | 300 | 100 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0
 | ID_170201315 | C | 2nd_Quarter | 2100 | 1000 | 800 | 0 | 0 | 100 | 7 | 5 | 2 | 0 | 0 | 1
 | ID_170201438 | C | 1st_Quarter | 1300 | 400 | 100 | 0 | 0 | 0 | 4 | 1 | 0 | 0 | 0 | 0
 | ID_170201438 | C | 2nd_Quarter | 2900 | 700 | 200 | 200 | 0 | 0 | 7 | 2 | 0 | 1 | 0 | 0
 | ID_170201716 | B | 1st_Quarter | 1300 | 400 | 100 | 0 | 0 | 0 | 6 | 1 | 0 | 0 | 0 | 0
 | ID_170201716 | B | 2nd_Quarter | 2300 | 1100 | 500 | 100 | 0 | 0 | 12 | 9 | 0 | 0 | 0 | 0
 | ID_170201793 | C | 1st_Quarter | 1400 | 300 | 100 | 0 | 0 | 0 | 3 | 1 | 0 | 0 | 0 | 0
 | ID_170201793 | C | 2nd_Quarter | 2600 | 600 | 700 | 100 | 0 | 0 | 14 | 2 | 2 | 0 | 0 | 0
 | ID_170201883 | B | 2nd_Quarter | 2400 | 1000 | 400 | 100 | 0 | 100 | 14 | 1 | 2 | 1 | 0 | 0
 | ID_170202111 | D | 1st_Quarter | 1300 | 500 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0
 | ID_170202111 | D | 2nd_Quarter | 2700 | 600 | 500 | 200 | 0 | 0 | 7 | 3 | 0 | 0 | 0 | 0
 | ID_170202340 | D | 1st_Quarter | 1400 | 300 | 100 | 0 | 0 | 0 | 6 | 3 | 1 | 0 | 0 | 0
 | ID_170202353 | C | 1st_Quarter | 1400 | 300 | 100 | 0 | 0 | 0 | 4 | 1 | 0 | 0 | 0 | 0
 | ID_170202353 | C | 2nd_Quarter | 3300 | 400 | 200 | 0 | 0 | 100 | 16 | 2 | 1 | 0 | 0 | 1
 | ID_170202394 | C | 1st_Quarter | 1100 | 600 | 100 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0
 | ID_170202394 | C | 2nd_Quarter | 2600 | 800 | 400 | 100 | 0 | 100 | 8 | 3 | 2 | 0 | 0 | 1
 | ID_170202531 | C | 1st_Quarter | 1000 | 800 | 0 | 0 | 0 | 0 | 7 | 5 | 0 | 0 | 0 | 0
 | ID_170202531 | C | 2nd_Quarter | 2400 | 1100 | 300 | 200 | 0 | 0 | 8 | 6 | 1 | 0 | 0 | 0
 | ID_170202557 | A | 1st_Quarter | 1000 | 300 | 400 | 100 | 0 | 0 | 6 | 2 | 2 | 0 | 0 | 0
 | ID_170202687 | C | 1st_Quarter | 1300 | 400 | 100 | 0 | 0 | 0 | 6 | 2 | 0 | 0 | 0 | 0
 | ID_170202687 | C | 2nd_Quarter | 3000 | 800 | 100 | 100 | 0 | 0 | 6 | 3 | 0 | 0 | 0 | 0
 | ID_170203133 | D | 1st_Quarter | 1200 | 100 | 500 | 0 | 0 | 0 | 6 | 1 | 0 | 0 | 0 | 0
 | ID_170203133 | D | 2nd_Quarter | 2600 | 1200 | 200 | 0 | 0 | 0 | 9 | 3 | 0 | 0 | 0 | 0
 | ID_170400050 | A | 1st_Quarter | 1500 | 100 | 100 | 100 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0
 | ID_170400050 | A | 2nd_Quarter | 2700 | 600 | 700 | 0 | 0 | 0 | 17 | 2 | 4 | 0 | 0 | 0
 | ID_170400359 | D | 2nd_Quarter | 2900 | 400 | 200 | 400 | 0 | 100 | 12 | 1 | 1 | 2 | 0 | 0
 | ID_170400390 | B | 2nd_Quarter | 3100 | 700 | 200 | 0 | 0 | 0 | 10 | 2 | 1 | 0 | 0 | 0
 | ID_170400420 | C | 1st_Quarter | 1200 | 200 | 300 | 100 | 0 | 0 | 8 | 1 | 3 | 1 | 0 | 0
 | ID_170400420 | C | 2nd_Quarter | 2500 | 1100 | 400 | 0 | 0 | 0 | 11 | 6 | 1 | 0 | 0 | 0
 | ID_170400665 | B | 1st_Quarter | 1300 | 300 | 100 | 100 | 0 | 0 | 11 | 1 | 1 | 0 | 0 | 0
 | ID_170401098 | C | 1st_Quarter | 1300 | 200 | 0 | 300 | 0 | 0 | 3 | 0 | 0 | 1 | 0 | 0
 | ID_170401098 | C | 2nd_Quarter | 2400 | 900 | 600 | 100 | 0 | 0 | 6 | 6 | 3 | 1 | 0 | 0
 | ID_170401212 | B | 1st_Quarter | 1300 | 300 | 200 | 0 | 0 | 0 | 5 | 1 | 1 | 0 | 0 | 0
 | ID_170401212 | B | 2nd_Quarter | 2700 | 1000 | 200 | 100 | 0 | 0 | 9 | 2 | 1 | 1 | 0 | 0
 | [NAME] | C | 1st_Quarter | 900 | 700 | 0 | 200 | 0 | 0 | 2 | 2 | 0 | 0 | 0 | 0
 | [NAME] | C | 2nd_Quarter | 2300 | 1100 | 500 | 100 | 0 | 0 | 5 | 4 | 1 | 0 | 0 | 0
 | ID_170401559 | B | 1st_Quarter | 1100 | 300 | 300 | 100 | 0 | 0 | 5 | 1 | 3 | 1 | 0 | 0
 | ID_170401559 | B | 2nd_Quarter | 3100 | 700 | 100 | 100 | 0 | 0 | 22 | 3 | 0 | 1 | 0 | 0
 | ID_170401634 | C | 1st_Quarter | 1300 | 400 | 100 | 0 | 0 | 0 | 4 | 1 | 1 | 0 | 0 | 0
 | ID_170401634 | C | 2nd_Quarter | 2900 | 800 | 200 | 100 | 0 | 0 | 14 | 2 | 0 | 1 | 0 | 0
 | ID_170401804 | B | 1st_Quarter | 1400 | 400 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0
 | ID_170401822 | C | 1st_Quarter | 1200 | 500 | 0 | 0 | 0 | 100 | 5 | 2 | 0 | 0 | 0 | 1
 | ID_170401822 | C | 2nd_Quarter | 2800 | 800 | 200 | 200 | 0 | 0 | 10 | 1 | 0 | 0 | 0 | 0
 | ID_170401884 | C | 1st_Quarter | 1400 | 100 | 100 | 200 | 0 | 0 | 6 | 1 | 1 | 0 | 0 | 0
 | ID_170401884 | C | 2nd_Quarter | 2900 | 900 | 200 | 0 | 0 | 0 | 15 | 5 | 0 | 0 | 0 | 0
 | ID_170402595 | B | 1st_Quarter | 1500 | 200 | 0 | 100 | 0 | 0 | 8 | 1 | 0 | 1 | 0 | 0
 | ID_170402595 | B | 2nd_Quarter | 2200 | 1100 | 600 | 100 | 0 | 0 | 8 | 3 | 2 | 0 | 0 | 0
 | ID_170402614 | C | 2nd_Quarter | 2400 | 800 | 700 | 100 | 0 | 0 | 6 | 3 | 2 | 1 | 0 | 0
 | ID_170402783 | D | 1st_Quarter | 600 | 800 | 100 | 200 | 0 | 100 | 3 | 4 | 0 | 0 | 0 | 1
 | ID_170402783 | D | 2nd_Quarter | 2400 | 700 | 700 | 200 | 0 | 0 | 9 | 1 | 1 | 2 | 0 | 0
 | ID_170402973 | C | 1st_Quarter | 1300 | 200 | 200 | 100 | 0 | 0 | 3 | 1 | 1 | 0 | 0 | 0
 | ID_170402973 | C | 2nd_Quarter | 2800 | 700 | 300 | 100 | 0 | 100 | 6 | 1 | 0 | 0 | 0 | 1
 | ID_170403248 | C | 1st_Quarter | 1300 | 400 | 100 | 0 | 0 | 0 | 5 | 2 | 1 | 0 | 0 | 0
 | ID_170403248 | C | 2nd_Quarter | 2900 | 700 | 400 | 0 | 0 | 0 | 10 | 2 | 1 | 0 | 0 | 0
 | ID_170403267 | D | 1st_Quarter | 1100 | 300 | 300 | 0 | 0 | 100 | 6 | 1 | 2 | 0 | 0 | 0
 | ID_170403267 | D | 2nd_Quarter | 2800 | 900 | 300 | 0 | 0 | 0 | 3 | 3 | 0 | 0 | 0 | 0
 | ID_170403270 | C | 1st_Quarter | 1000 | 200 | 300 | 300 | 0 | 0 | 5 | 2 | 1 | 1 | 0 | 0
 | ID_170403618 | B | 1st_Quarter | 1200 | 200 | 300 | 100 | 0 | 0 | 5 | 0 | 0 | 1 | 0 | 0
 | ID_170403618 | B | 2nd_Quarter | 2500 | 900 | 400 | 200 | 0 | 0 | 9 | 1 | 2 | 0 | 0 | 0
 | ID_170403779 | B | 1st_Quarter | 1300 | 400 | 0 | 0 | 0 | 100 | 3 | 2 | 0 | 0 | 0 | 0
 | ID_170403779 | B | 2nd_Quarter | 2600 | 500 | 800 | 100 | 0 | 0 | 8 | 1 | 2 | 0 | 0 | 0
 | ID_170403786 | D | 1st_Quarter | 1300 | 100 | 300 | 0 | 0 | 100 | 5 | 1 | 1 | 0 | 0 | 0
 | ID_170403786 | D | 2nd_Quarter | 2700 | 800 | 400 | 100 | 0 | 0 | 11 | 1 | 1 | 0 | 0 | 0
 | ID_170403866 | C | 1st_Quarter | 1500 | 200 | 0 | 100 | 0 | 0 | 7 | 0 | 0 | 0 | 0 | 0
 | ID_170403866 | C | 2nd_Quarter | 2700 | 700 | 500 | 100 | 0 | 0 | 4 | 0 | 3 | 0 | 0 | 0
 | ID_170403869 | C | 1st_Quarter | 1100 | 400 | 300 | 0 | 0 | 0 | 8 | 2 | 0 | 0 | 0 | 0
 | ID_170403870 | C | 1st_Quarter | 1200 | 300 | 100 | 100 | 0 | 100 | 7 | 1 | 1 | 0 | 0 | 0
 | ID_170403870 | C | 2nd_Quarter | 2900 | 800 | 300 | 0 | 0 | 0 | 11 | 1 | 1 | 0 | 0 | 0
 | ID_170403964 | B | 1st_Quarter | 1000 | 300 | 400 | 100 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0
 | ID_170403964 | B | 2nd_Quarter | 2400 | 1100 | 500 | 0 | 0 | 0 | 7 | 4 | 2 | 0 | 0 | 0
 | ID_170404169 | C | 1st_Quarter | 1400 | 200 | 200 | 0 | 0 | 0 | 9 | 2 | 2 | 0 | 0 | 0
 | ID_170404169 | C | 2nd_Quarter | 2600 | 800 | 400 | 200 | 0 | 0 | 12 | 3 | 1 | 1 | 0 | 0
 | ID_170404210 | B | 1st_Quarter | 1500 | 100 | 200 | 0 | 0 | 0 | 9 | 1 | 0 | 0 | 0 | 0
 | ID_170404210 | B | 2nd_Quarter | 3100 | 800 | 100 | 0 | 0 | 0 | 14 | 3 | 0 | 0 | 0 | 0
 | ID_170404299 | C | 1st_Quarter | 1200 | 400 | 0 | 100 | 0 | 100 | 6 | 2 | 0 | 0 | 0 | 1
 | ID_170404299 | C | 2nd_Quarter | 2700 | 600 | 500 | 200 | 0 | 0 | 12 | 4 | 1 | 2 | 0 | 0
 | ID_170404370 | B | 1st_Quarter | 1100 | 300 | 200 | 200 | 0 | 0 | 8 | 0 | 0 | 0 | 0 | 0
 | ID_170404370 | B | 2nd_Quarter | 2700 | 800 | 300 | 100 | 0 | 100 | 14 | 3 | 1 | 0 | 0 | 1
 | ID_170404523 | C | 1st_Quarter | 1100 | 200 | 200 | 100 | 0 | 100 | 4 | 0 | 0 | 0 | 0 | 0
 | ID_170404523 | C | 2nd_Quarter | 3000 | 500 | 300 | 100 | 0 | 100 | 7 | 2 | 2 | 0 | 0 | 0
 | ID_170404918 | C | 1st_Quarter | 1400 | 100 | 100 | 100 | 0 | 100 | 7 | 0 | 0 | 0 | 0 | 1
 | ID_170404918 | C | 2nd_Quarter | 2500 | 1100 | 400 | 0 | 0 | 0 | 10 | 3 | 1 | 0 | 0 | 0
 | ID_170405300 | C | 1st_Quarter | 1200 | 400 | 0 | 100 | 0 | 100 | 5 | 0 | 0 | 0 | 0 | 0
 | ID_170405300 | C | 2nd_Quarter | 2900 | 600 | 400 | 100 | 0 | 0 | 11 | 1 | 1 | 1 | 0 | 0
 | ID_170405383 | B | 1st_Quarter | 1100 | 600 | 100 | 0 | 0 | 0 | 8 | 1 | 1 | 0 | 0 | 0
 | ID_170405385 | C | 1st_Quarter | 100 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0