| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | RANK | ||||||||||||||
2 | |||||||||||||||
3 | Rumus : Rank | ||||||||||||||
4 | No | Kategory | Sub Kategory | Item | Harga | Quantity | Nominal | Ranking By Item | Rumus | ||||||
5 | 1 | Food | Snack | Kentang Goreng | 10.000 | 390 | 3.900.000 | Kentang Goreng | 9 | =RANK(H5;H$5:H$19;0) | |||||
6 | 2 | Food | Snack | Kerupuk Udang | 6.000 | 500 | 3.000.000 | Kerupuk Udang | 10 | =RANK(H6;H$5:H$19;0) | |||||
7 | 3 | Food | Snack | Keripik | 4.000 | 60 | 240.000 | Keripik | 15 | =RANK(H7;H$5:H$19;0) | |||||
8 | 4 | Food | Snack | Sosis | 8.000 | 720 | 5.760.000 | Sosis | 7 | =RANK(H8;H$5:H$19;0) | |||||
9 | 5 | Food | Snack | Tahu Bakso | 3.000 | 510 | 1.530.000 | Tahu Bakso | 14 | =RANK(H9;H$5:H$19;0) | |||||
10 | 6 | Food | Nasi | Nasi Goreng | 27.000 | 750 | 20.250.000 | Nasi Goreng | 2 | =RANK(H10;H$5:H$19;0) | |||||
11 | 7 | Food | Nasi | Nasi Ayam | 33.000 | 300 | 9.900.000 | Nasi Ayam | 3 | =RANK(H11;H$5:H$19;0) | |||||
12 | 8 | Food | Nasi | Nasi Bebek | 25.000 | 870 | 21.750.000 | Nasi Bebek | 1 | =RANK(H12;H$5:H$19;0) | |||||
13 | 9 | Beverage | Juice | Juice Mangga | 12.000 | 330 | 3.960.000 | Juice Mangga | 8 | =RANK(H13;H$5:H$19;0) | |||||
14 | 10 | Beverage | Juice | Juice Durian | 15.000 | 200 | 3.000.000 | Juice Durian | 10 | =RANK(H14;H$5:H$19;0) | |||||
15 | 11 | Beverage | Juice | Juice Buah Naga | 10.000 | 300 | 3.000.000 | Juice Buah Naga | 10 | =RANK(H15;H$5:H$19;0) | |||||
16 | 12 | Beverage | Juice | Juice Melon | 11.000 | 210 | 2.310.000 | Juice Melon | 13 | =RANK(H16;H$5:H$19;0) | |||||
17 | 13 | Beverage | Juice | Semangka | 9.000 | 780 | 7.020.000 | Semangka | 4 | =RANK(H17;H$5:H$19;0) | |||||
18 | 14 | Beverage | Coffee | Coffee Arabica | 26.000 | 270 | 7.020.000 | Coffee Arabica | 4 | =RANK(H18;H$5:H$19;0) | |||||
19 | 15 | Beverage | Coffee | Coffee Robusta | 21.000 | 280 | 5.880.000 | Coffee Robusta | 6 | =RANK(H19;H$5:H$19;0) | |||||
20 | Total : | 98.520.000 | |||||||||||||
21 | Rata - rata : | 6.568.000 | |||||||||||||
22 | |||||||||||||||