Spreadsheet: 872915d1719368767-automatically-identify-a-data-based-on-two-or-more-factor-identify-mort-based-on-two-factor
Sheet: Sheet1

 | Form Pakan [NAME] Harian Karamba Farm Tambun Raya
 |  | [NAME] | 2024-06-24 00:00:00
RAKIT | UNIT | RING | [NAME] | ABW (gram) | Vol Pakan (kg) | Total Mortalitas (pcs) |  |  |  |  |  |  |  |  |  |  |  |  |  | Cage | Vol Est | Realisasi | [NAME] |  | UNIT
 |  |  |  |  |  |  |  | THIS IS JUST EXAMPLE
10 | AT02 | GA-01 | 2024-06-24 00:00:00 | 225.785564684991 | 1350 | 105 |  | cage's | [NAME] | doc | [NAME] date | %mort/day | TREATMENT |  |  |  |  |  |  |  |  |  |  |  | GA
16 | AT02 | GA-02 | 2024-06-24 00:00:00 | 203.4649638268819 | 1050 | 15 |  |  |  |  |  | 2.623651811758347 | 27-05-24 |  |  |  |  |  |  |  |  |  |  |  | GB
10 | AT02 | GA-03 | 2024-06-24 00:00:00 | 86.1061452169488 | 540 | 449 |  |  |  |  |  | 0.9297160941864694 | 24-06-24 |  |  |  |  |  |  |  |  |  |  |  | GC
9 | AT02 | [NAME] | 2024-06-24 00:00:00 | 73.00999451004043 | 480 | 696 |  |  |  |  |  | 0.6919733456280761 | 08-06-24
P06 | AT02 | GA-05 | 2024-06-24 00:00:00 | 24.34832411031305 | 180 | 249 |  |  |  |  |  | 0.6036459750456719 | BELUM
8 | AT02 | GA-06 | 2024-06-24 00:00:00 | 562.1496995032794 | 1200 | 14 |  |  |  |  |  | 1.537723550187815 | BELUM
12 | AT02 | GA-07 | 2024-06-24 00:00:00 | 199.7185553487915 | 1020 | 38 |  |  |  |  |  | 0.8214576586897985 | BELUM
 | AT02 | GA-08 |  |  | 0 | 0
5 | AT02 | GA-09 | 2024-06-24 00:00:00 | 1048.545035360792 | 1440 | 37
 | AT02 | GA-10 |  |  | 0 | 0 |  |  | this is example for "morttalitas" => 1000 pcs.
10 | AT02 | GA-11 | 2024-06-24 00:00:00 | 163.1220157911873 | 960 | 47 |  |  | automaticly line down all the mort over 1000 pcs.
6 | AT02 | GA-12 | 2024-06-24 00:00:00 | 1138.994820119368 | 1350 | 35
 | AT02 | GB-01 |  |  | 0 | 0
12 | AT02 | GB-02 | 2024-06-24 00:00:00 | 1224.960790189375 | 660 | 117 |  | THIS IS WHAT I WANTED, |  |  |  |  | this or that that should have a formula.
14 | AT02 | GB-03 | 2024-06-24 00:00:00 | 1171.521411459761 | 1290 | 31 |  | cage's
1 | AT02 | [NAME] | 2024-06-24 00:00:00 | 940.2326329038112 | 1350 | 113
16 | AT02 | GB-05 | 2024-06-24 00:00:00 | 151.810014460867 | 900 | 9
3 | AT02 | GB-06 | 2024-06-24 00:00:00 | 983.514938098018 | 1440 | 212
11 | AT02 | GB-07 | 2024-06-24 00:00:00 | 390.8864183807664 | 1650 | 77 |  |  |  |  |  |  | I want to identify mort between ABW 600 gr - 900 gr that has mort over 100 pcs
4 | AT02 | GB-08 | 2024-06-24 00:00:00 | 1040.147428145423 | 1410 | 103
15 | AT02 | GB-09 | 2024-06-24 00:00:00 | 1065.658078405182 | 1350 | 18 |  |  |  |  |  |  | Thanks!
3 | AT02 | GB-10 | 2024-06-24 00:00:00 | 850.938431631204 | 1440 | 288
15 | AT02 | GB-11 | 2024-06-24 00:00:00 | 823.808142215174 | 1500 | 14
2 | AT02 | GB-12 | 2024-06-24 00:00:00 | 768.4653120755177 | 1350 | 25
9 | AT02 | GC-01 | 2024-06-24 00:00:00 | 123.5536363405531 | 810 | 48
10 | AT02 | GC-02 | 2024-06-24 00:00:00 | 56.17063229263249 | 390 | 6602
17 | AT02 | GC-03 | 2024-06-24 00:00:00 | 114.0266808922007 | 840 | 16
1 | AT02 | GC-04 | 2024-06-24 00:00:00 | 701.4807530518324 | 1590 | 90
13 | AT02 | [NAME] | 2024-06-24 00:00:00 | 496.4080587510732 | 1440 | 60
7 | AT02 | GC-06 | 2024-06-24 00:00:00 | 564.4843284518155 | 1500 | 16
17 | AT02 | GC-07 | 2024-06-24 00:00:00 | 104.1990238816464 | 660 | 13
17 | AT02 | GC-08 | 2024-06-24 00:00:00 | 94.0719608018086 | 540 | 9
8 | AT02 | GC-09 | 2024-06-24 00:00:00 | 536.4577105633659 | 1230 | 131
7 | AT02 | GC-10 | 2024-06-24 00:00:00 | 512.0971180455626 | 1530 | 14
2 | AT02 | GC-11 | 2024-06-24 00:00:00 | 420.7423567771352 | 1500 | 42
11 | AT02 | GC-12 | 2024-06-24 00:00:00 |  | 0 | 64
12 | AT02 | GD-01 | 2024-06-24 00:00:00 | 226.7442067950404 | 1260 | 28
9 | AT02 | GD-02 | 2024-06-24 00:00:00 | 257.9116794589703 | 1260 | 60
14 | AT02 | GD-03 | 2024-06-24 00:00:00 | 264.2767004377188 | 1500 | 21
16 | AT02 | [NAME] | 2024-06-24 00:00:00 | 285.4876732943804 | 1350 | 18
13 | AT02 | GD-05 | 2024-06-24 00:00:00 | 353.4282250828322 | 1500 | 57
6 | AT02 | GD-06 | 2024-06-24 00:00:00 | 356.1229013136198 | 1500 | 26
P06 | AT02 | GD-07 | 2024-06-24 00:00:00 | 46.94836960796468 | 0 | 2403
P06 | AT02 | GD-08 | 2024-06-24 00:00:00 | 43.4859266826892 | 390 | 1756
P06 | AT02 | GD-09 | 2024-06-24 00:00:00 | 44.14138505162099 | 360 | 552
P06 | AT02 | GD-10 | 2024-06-24 00:00:00 | 38.91355184751684 | 330 | 1553
P06 | AT02 | GD-11 | 2024-06-24 00:00:00 | 33.06945454227471 | 300 | 3975
P06 | AT02 | GD-12 | 2024-06-24 00:00:00 | 29.09999565912917 | 300 | 2108
 | AT02 | GE-01 |  |  | 0 | 0
 | AT02 | GE-02 |  |  | 0 | 0
 | AT02 | GE-03 |  |  | 0 | 0
 | AT02 | [NAME] |  |  | 0 | 0
4 | AT02 | GE-05 | 2024-06-24 00:00:00 | 978.8453765017485 | 1560 | 119
 | AT02 | GE-06 |  |  | 0 | 0
 | AT02 | GE-07 |  |  | 0 | 0
 | AT02 | GE-08 |  |  | 0 | 0
 | AT02 | GE-09 |  |  | 0 | 0
 | AT02 | GE-10 |  |  | 0 | 0
 | AT02 | GE-11 |  |  | 0 | 0
 | AT02 | GE-12 |  |  | 0 | 0
5 | AT02 | [NAME] | 2024-06-24 00:00:00 | 1189.918379911139 | 1320 | 45
11 | AT02 | GG-02 | 2024-06-24 00:00:00 | 1127.021373086115 | 1200 | 65
 | AT02 | GG-03 |  |  | 0 | 0
 | AT02 | [NAME] |  |  | 0 | 0
 | AT02 | GG-05 |  |  | 0 | 0
 | AT02 | [NAME] |  |  | 0 | 0
 | AT02 | GG-07 |  |  | 0 | 0
 | AT02 | GG-08 |  |  | 0 | 0
 | AT02 | GG-09 |  |  | 0 | 0
 | AT02 | GG-10 |  |  | 0 | 0
 | AT02 | GG-11 |  |  | 0 | 0
 | AT02 | GG-12 |  |  | 0 | 0
 |  | TOTAL | 2024-06-24 00:00:00 |  | 50070 | 22583
 |  |  | 2024-06-24 00:00:00 | KONTROL | 0 | 0