Spreadsheet: 795967d1663035694-automatically-make-a-rundown-values-based-on-set-number-automatically-rundown-number-based-on-set-number
Sheet: PG

 | Form Pakan [NAME] Harian Karamba Farm Tambun Raya
 |  | [NAME] | 2022-09-11 00:00:00
RAKIT | UNIT | RING | [NAME] | PEMAKAIAN PAKAN (KG) |  |  |  |  |  |  |  |  |  |  | Vol PaKan | Mortalitas (EKor) |  | Total Mortalitas | Petugas |  | KET |  | TOTAL | [NAME]
 |  |  |  | MICRO -100 | ECO-1 | ECO-2 | ECO-3 | ECO-5 | ECO-7 | ECO-7 32% | ECO-9 | ECO-5 BR | Batchcode | Ex. Date |  | Feeder | Diver |  | Feeder | Diver
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PAKAN | 36900
M | AT02 | GA-01 | 2022-09-11 00:00:00 |  |  |  | 300 |  |  |  |  |  | 12A422H13K | 2022-11-13 00:00:00 | 300 | 423 |  |  | BOY, JOEL, PUTRA, SURYA |  |  |  | KEMATIAN | 10577
 | AT02 | GA-02 | 2022-09-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 15 |  |  | FIRMAN |  |  |  |  | IFERROR(SMALL(IF(COUNTIF($Y$9;$S$8:$S$67);MATCH(ROW($B$8:$B$67);ROW($C$8:$C$54));"");ROWS(Y$11:$Y11));"")
7 | AT02 | GA-03 | 2022-09-11 00:00:00 |  |  |  |  |  | 1050 |  |  |  | 12A322H23K | 2022-11-23 00:00:00 | 1050 | 21 |  |  | LIDEN, MARSON |  |  |  | petak | [NAME] | doc | date | %mort/day
2 | AT02 | [NAME] | 2022-09-11 00:00:00 |  |  |  |  |  | 1050 |  |  |  | 12A322H23K | 2022-11-23 00:00:00 | 1050 | 9 | 62 |  | CANI, FERY | RUDI
11 | AT02 | GA-05 | 2022-09-11 00:00:00 |  |  |  |  |  | 1440 |  |  |  | 12A322H23K | 2022-11-23 00:00:00 | 1440 | 13 | 25 |  | DOMALI, OIN | REDINO |  | Open BB
8 | AT02 | GA-06 | 2022-09-11 00:00:00 |  |  |  |  | 480 |  |  |  |  | 11A222H18K | 2022-11-18 00:00:00 | 480 | 35 |  |  | ASVEN, CARLES |  |  | Rakit GO
 | AT02 | GA-07 | 2022-09-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 0
13 | AT02 | GA-08 | 2022-09-11 00:00:00 |  |  |  |  |  | 1200 |  |  |  | 12A322H23K | 2022-11-23 00:00:00 | 1200 | 6 |  |  | WILMAR, ANDREY |  |  |  | RAKIT | FEEDER
2 | AT02 | GA-09 | 2022-09-11 00:00:00 |  |  |  |  | 1050 |  |  |  |  | 11A222H18K | 2022-11-18 00:00:00 | 1050 | 19 | 55 |  | CANI, FERY | IMAM, RUDI |  |  | 1 | BENTUA, RICO
10 | AT02 | GA-10 | 2022-09-11 00:00:00 |  |  |  |  |  | 1200 |  |  |  | 12A322H23K | 2022-11-23 00:00:00 | 1200 | 28 | 34 |  | PRAS, HARRY | REDINO, FAJAR |  |  | 2 | CANI, FERY
9 | AT02 | GA-11 | 2022-09-11 00:00:00 |  |  |  |  |  | 1080 |  |  |  | 12A322H23K | 2022-11-23 00:00:00 | 1080 | 12 | 68 |  | GENTA, MARUBA | FAJAR, PIRMAN |  |  | 3 |  |  |  | I WANT TO IDENTIFY THE [NAME] BIGGER THAN 1000
5 | AT02 | GA-12 | 2022-09-11 00:00:00 |  |  |  |  |  | 1350 |  |  |  | 12A322H23K | 2022-11-23 00:00:00 | 1350 | 19 | 73 |  | CANDRA, BAYU | [NAME], POSTER |  |  | 4
6 | AT02 | GB-01 | 2022-09-11 00:00:00 |  |  |  |  |  | 930 |  |  |  | 12A322H23K | 2022-11-23 00:00:00 | 930 | 15 | 74 |  | MUIS, FERDINAN | POSTER, [NAME] |  |  | 5 | CANDRA, BAYU
14 | AT02 | GB-02 | 2022-09-11 00:00:00 |  |  |  |  |  | 1320 |  |  |  | 12A322H23K | 2022-11-23 00:00:00 | 1320 | 11 |  |  | RIZAL, [NAME] |  |  |  | 6 | MUIS, FERDINAN
5 | AT02 | GB-03 | 2022-09-11 00:00:00 |  |  |  |  |  | 1380 |  |  |  | 12A322H23K | 2022-11-23 00:00:00 | 1380 | 22 | 72 |  | CANDRA, BAYU | POSTER, [NAME] |  |  | 7 | LIDEN, MARSON |  |  | I WANT TO MAKE THIS AUTOMATICALLY FILL BY THE VALUES IN THE "S" CELL
1 | AT02 | [NAME] | 2022-09-11 00:00:00 |  |  |  |  | 1110 |  |  |  |  | 11A222H18K | 2022-11-18 00:00:00 | 1110 | 12 |  |  | BENTUA, RICO |  |  |  | 8 | ASVEN, CARLES
M | AT02 | GB-05 | 2022-09-11 00:00:00 |  |  |  | 300 |  |  |  |  |  | 12A422H13K | 2022-11-13 00:00:00 | 300 | 120 | 43 |  | BOY, JOEL, PUTRA, SURYA | RIZKY |  |  | 9 | GENTA, MARUBA
6 | AT02 | GB-06 | 2022-09-11 00:00:00 |  |  |  |  | 1110 |  |  |  |  | 11A222H18K | 2022-11-18 00:00:00 | 1110 | 23 | 39 |  | MUIS, FERDINAN | POSTER, [NAME] |  |  | 10 | PRAS, HARRY
M | AT02 | GB-07 | 2022-09-11 00:00:00 |  |  |  | 330 |  |  |  |  |  | 12A422H13K | 2022-11-13 00:00:00 | 330 | 365 | 563 |  | BOY, JOEL, PUTRA, SURYA | RIZKY |  |  | 11 | DOMALI, OIN
5 | AT02 | GB-08 | 2022-09-11 00:00:00 |  |  |  |  |  | 1200 |  |  |  | 12A322H23K | 2022-11-23 00:00:00 | 1200 | 17 | 53 |  | CANDRA, BAYU | [NAME], PIRMAN |  |  | 12 | HENDRA, SLAMET
6 | AT02 | GB-09 | 2022-09-11 00:00:00 |  |  |  |  | 1110 |  |  |  |  | 11A222H18K | 2022-11-18 00:00:00 | 1110 | 19 |  |  | MUIS, FERDINAN |  |  |  | 13 | WILMAR, ANDREY
13 | AT02 | GB-10 | 2022-09-11 00:00:00 |  |  |  |  | 930 |  |  |  |  | 11A222H18K | 2022-11-18 00:00:00 | 930 | 29 |  |  | WILMAR, ANDREY |  |  |  | 14 | RIZAL, [NAME]
10 | AT02 | GB-11 | 2022-09-11 00:00:00 |  |  |  |  | 840 |  |  |  |  | 11A222H18K | 2022-11-18 00:00:00 | 840 | 28 | 46 |  | PRAS, HARRY | PIRMAN, FAJAR |  |  | M | BOY, JOEL, PUTRA, SURYA
8 | AT02 | GB-12 | 2022-09-11 00:00:00 |  |  |  |  | 660 |  |  |  |  | 11A222H18K | 2022-11-18 00:00:00 | 660 | 22 |  |  | ASVEN, CARLES
 | AT02 | GC-01 |  |  |  |  |  |  |  |  |  |  |  |  | 0
1 | AT02 | GC-02 | 2022-09-11 00:00:00 |  |  |  |  |  | 1380 |  |  |  | 12A322H23K | 2022-11-23 00:00:00 | 1380 | 7 |  |  | BENTUA, RICO
M | AT02 | GC-03 | 2022-09-11 00:00:00 |  |  |  | 210 |  |  |  |  |  | 12A422H13K | 2022-11-13 00:00:00 | 210 | 136 | 481 |  | BOY, JOEL, PUTRA, SURYA | RIZKY
9 | AT02 | GC-04 | 2022-09-11 00:00:00 |  |  |  |  | 930 |  |  |  |  | 11A222H18K | 2022-11-18 00:00:00 | 930 | 26 | 65 |  | GENTA, MARUBA | PIRMAN, FAJAR
11 | AT02 | [NAME] | 2022-09-11 00:00:00 |  |  |  |  | 660 |  |  |  |  | 11A222H18K | 2022-11-18 00:00:00 | 660 | 46 |  |  | DOMALI, OIN
11 | AT02 | GC-06 | 2022-09-11 00:00:00 |  |  |  |  | 720 |  |  |  |  | 11A222H18K | 2022-11-18 00:00:00 | 720 | 43 |  |  | DOMALI, OIN
M | AT02 | GC-07 | 2022-09-11 00:00:00 |  |  |  | 330 |  |  |  |  |  | 12A422H13K | 2022-11-13 00:00:00 | 330 | 320 | 718 |  | BOY, JOEL, PUTRA, SURYA | RIZKY
M | AT02 | GC-08 | 2022-09-11 00:00:00 |  |  |  | 60 |  |  |  |  |  | 12A422H13K | 2022-11-13 00:00:00 | 60 | 5 | 804 |  | BOY, JOEL, PUTRA, SURYA | RIZKY
2 | AT02 | GC-09 | 2022-09-11 00:00:00 |  |  |  |  | 660 |  |  |  |  | 11A222H18K | 2022-11-18 00:00:00 | 660 | 28 | 254 |  | CANI, FERY | IMAM
12 | AT02 | GC-10 | 2022-09-11 00:00:00 |  |  |  |  | 420 |  |  |  |  | 11A222H18K | 2022-11-18 00:00:00 | 420 | 106 | 892 |  | HENDRA, SLAMET | REDINO
2 | AT02 | GC-11 | 2022-09-11 00:00:00 |  |  |  |  | 540 |  |  |  |  | 11A222H18K | 2022-11-18 00:00:00 | 540 | 103 | 390 |  | CANI, FERY | IMAM
14 | AT02 | GC-12 | 2022-09-11 00:00:00 |  |  |  |  |  | 1200 |  |  |  | 12A322H23K | 2022-11-23 00:00:00 | 1200 | 16 |  |  | RIZAL, [NAME]
M | AT02 | GD-01 | 2022-09-11 00:00:00 |  |  |  | 180 |  |  |  |  |  | 12A422H13K | 2022-11-13 00:00:00 | 180 | 4 | 353 |  | BOY, JOEL, PUTRA, SURYA | RIZKY
8 | AT02 | GD-02 | 2022-09-11 00:00:00 |  |  |  |  | 480 |  |  |  |  | 11A222H18K | 2022-11-18 00:00:00 | 480 | 32 |  |  | ASVEN, CARLES
12 | AT02 | GD-03 | 2022-09-11 00:00:00 |  |  |  | 270 | 210 |  |  |  |  | 12A422H13K, 11A222H18K | 13-Nov-22, 18-Nov-22 | 480 | 71 | 627 |  | HENDRA, SLAMET | REDINO
M | AT02 | [NAME] | 2022-09-11 00:00:00 |  |  |  | 180 | 270 |  |  |  |  | 12A422H13K, 11A222H18K | 13-Nov-22, 18-Nov-22 | 450 | 54 |  |  | BOY, JOEL, PUTRA, SURYA
8 | AT02 | GD-05 | 2022-09-11 00:00:00 |  |  |  | 210 | 270 |  |  |  |  | 12A422H13K, 11A222H18K | 13-Nov-22, 18-Nov-22 | 480 | 31 |  |  | ASVEN, CARLES
12 | AT02 | GD-06 | 2022-09-11 00:00:00 |  |  |  | 300 | 180 |  |  |  |  | 12A422H13K, 11A222H18K | 13-Nov-22, 18-Nov-22 | 480 | 86 | 473 |  | HENDRA, SLAMET | REDINO
 | AT02 | GD-07 |  |  |  |  |  |  |  |  |  |  |  |  | 0
13 | AT02 | GD-08 | 2022-09-11 00:00:00 |  |  |  | 240 |  |  |  |  |  | 12A422H13K | 2022-11-13 00:00:00 | 240 | 76 |  |  | WILMAR, ANDREY
 | AT02 | GD-09 |  |  |  |  |  |  |  |  |  |  |  |  | 0
10 | AT02 | GD-10 | 2022-09-11 00:00:00 |  |  |  | 330 |  |  |  |  |  | 12A422H13K | 2022-11-13 00:00:00 | 330 | 61 | 611 |  | PRAS, HARRY | FAJAR
1 | AT02 | GD-11 | 2022-09-11 00:00:00 |  |  |  |  |  | 1050 |  |  |  | 12A322H23K | 2022-11-23 00:00:00 | 1050 | 10 | 42 |  | BENTUA, RICO | RUDI
9 | AT02 | GD-12 | 2022-09-11 00:00:00 |  |  |  | 360 |  |  |  |  |  | 12A422H13K | 2022-11-13 00:00:00 | 360 | 162 | 875 |  | GENTA, MARUBA | PIRMAN
 | AT02 | GE-01 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | AT02 | GE-02 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | AT02 | GE-03 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | AT02 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | AT02 | GE-05 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | AT02 | GE-06 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | AT02 | GE-07 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | AT02 | GE-08 |  |  |  |  |  |  |  |  |  |  |  |  | 0
14 | AT02 | GE-09 | 2022-09-11 00:00:00 |  |  |  |  |  | 1200 |  |  |  | 12A322H23K | 2022-11-23 00:00:00 | 1200 | 11 |  |  | RIZAL, [NAME]
7 | AT02 | GE-10 | 2022-09-11 00:00:00 |  |  |  |  |  | 1200 |  |  |  | 12A322H23K | 2022-11-23 00:00:00 | 1200 | 37 | 1065 |  | LIDEN, MARSON | REDINO
12 | AT02 | GE-11 | 2022-09-11 00:00:00 |  |  |  |  |  | 1440 |  |  |  | 12A322H23K | 2022-11-23 00:00:00 | 1440 | 30 |  |  | HENDRA, SLAMET
 | AT02 | GE-12 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | GF-01 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | GF-02 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | GF-03 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | GF-05 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | GF-06 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | GF-07 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | GF-08 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | GF-09 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | GF-10 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | GF-11 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | GF-12 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | TOTAL | 2022-09-11 00:00:00 | 0 | 0 | 0 | 3600 | 12630 | 20670 | 0 | 0 | 0 |  |  | 36900 | 2769 | 7808
 |  |  |  | 0 | 0 | 0 | 120 | 421 | 689 | 0 | 0 | 0 |  | KONTROL | 0