Spreadsheet: 850054d1700451309-formula-errors-error-daily-inventory
Sheet: 1.11.23

 | BOUSTEAD PETROLEUM - LPG PLANT DAILY STOCK RECORD SHEET
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DATE
VEHICLE NO. | RECEIPT FROM *CUSTOMER/TRANSFER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ISSUE TO *CUSTOMER/TRANSFER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REMARKS | GATE PASS
 | BOTTLE |  |  |  |  |  |  |  |  |  |  |  |  | CYLINDERS |  |  | TYPE OF 50 KG Empty IN |  |  |  | TYPE OF 50 KG Leak & Fill IN |  |  |  | BOTTLE |  |  |  |  |  |  |  |  | BOTTLE |  | TYPE OF 50 KG - Filled Out |  |  |  | TYPE OF 50 KG - Empty Out
 | 12 KG |  |  | 14 KG |  |  | 14 KG PDB | 12 KG BT |  |  | 14 KG BLW |  |  | 50 KG |  |  |  |  |  |  |  |  |  |  | 12 KG |  | 14 KG |  | 14 KG PDB | 12 KG BT |  | 14 KG BLW |  | 50 KG
 | FULL | LEAK | EMPTY | FULL | LEAK | EMPTY | EMPTY | FULL | LEAK | EMPTY | FULL | LEAK | EMPTY | FULL | LEAK | EMPTY | C | CLW | YT | [NAME] | C | CLW | YT | [NAME] | FULL | EMPTY | FULL | EMPTY | FULL | FULL | EMPTY | FULL | EMPTY | FULL | EMPTY | C | CLW | YT | [NAME] | C | CLW | YT | [NAME]
VAU6202 |  |  | 77 |  |  | 833 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 77 |  | 833 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 583734
QCE7717 |  |  |  |  |  | 990 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 990 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 583735
BPG7797 |  |  | 63 |  |  | 669 |  |  |  |  |  |  |  |  |  | 65 | 26 | 39 |  |  |  |  |  |  | 63 |  | 669 |  |  |  |  |  |  | 65 |  | 26 | 39 |  |  |  |  |  |  |  | 583736
[NAME] |  |  | 90 |  |  | 378 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 90 |  | 378 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 583737
MDA1522 |  |  | 50 |  |  | 386 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 |  | 386 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 583738
NDQ6603 |  |  | 105 |  |  | 700 |  |  |  |  |  |  |  |  |  | 24 | 24 |  |  |  |  |  |  |  | 105 |  | 700 |  |  |  |  |  |  | 23 | 1 | 23 |  |  |  |  |  |  |  |  | 583739
VAY1295 |  |  |  |  |  | 210 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 210 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PATI TEKNIK | 583740
BKD5406 |  |  |  |  |  | 170 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 170 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ISTIHANDAL | 583741
BME9218 |  |  |  |  |  |  | 875 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 875 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PETRONAS | 583742
NBT4886 |  |  |  |  |  | 924 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 945 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRAI | 583743
DDP6818 |  |  |  |  |  | 300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 583744
WYR1819 |  |  |  |  |  | 470 |  |  |  |  |  |  |  |  |  | 112 | 112 |  |  |  |  |  |  |  | 100 |  | 470 |  |  |  |  |  |  | 105 |  | 105 |  |  |  |  |  |  |  | DEPOSIT 100 | 583745
WNJ1819 |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 144 | 112 | 32 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 144 |  | 112 | 32 |  |  |  |  |  |  |  | 583746
WRV3339 |  |  |  |  |  |  | 504 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 504 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PETRONAS | 583747
BJA7416 |  |  | 96 |  |  | 465 |  |  |  |  |  |  |  |  |  | 90 | 66 | 11 |  | 13 |  |  |  |  | 96 |  | 465 |  |  |  |  |  |  | 90 |  | 66 | 11 |  | 13 |  |  |  |  |  | 583748
VAY1295 |  |  |  |  |  | 210 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 210 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PATI TEKNIK | 583749
BKD5406 |  |  |  |  |  | 170 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 170 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ISTIHANDAL | 583750
RT9531 |  |  | 98 |  |  | 336 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 98 |  | 336 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 583751
KET6818 |  |  | 210 |  |  | 700 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 210 |  | 700 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 583752
DDP6818 |  |  |  |  |  | 300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PATI TEKNIK | 583753
VGT1773 |  |  |  |  |  | 479 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 479 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 583754
VLC6123 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 162 | 93 | 11 | 47 | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  | 155 |  | 86 | 11 | 47 | 11 |  |  |  |  |  | 583755
VAY1295 |  |  |  |  |  | 210 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 210 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PATI TEKNIK | 583756
VFA3836 |  |  |  |  |  | 840 |  |  |  |  |  |  | 70 |  |  |  |  |  |  |  |  |  |  |  |  |  | 840 |  |  |  |  | 70 |  |  |  |  |  |  |  |  |  |  |  |  | 583757
BKD5406 |  |  |  |  |  | 170 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 170 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ISTIHANDAL | 583758
BME9218 |  |  |  |  |  |  | 875 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 875 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PETRONAS | 583759
VAP5487 |  |  |  |  |  | 441 |  |  |  |  |  |  |  |  |  | 108 | 54 |  | 54 |  |  |  |  |  |  |  | 441 |  |  |  |  |  |  | 108 |  | 54 |  | 54 |  |  |  |  |  |  | 583760
VN6345 |  |  | 264 |  |  | 295 |  |  |  | 120 |  |  | 34 |  |  |  |  |  |  |  |  |  |  |  | 264 |  | 295 |  |  | 120 |  | 34 |  |  |  |  |  |  |  |  |  |  |  |  | 583761
MDA1522 |  |  | 50 |  |  | 384 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 |  | 384 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 583762
[NAME] |  |  |  |  | 2 | 880 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 882 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 583763
DDP6818 |  |  |  |  |  | 300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PATI TEKNIK | 583764
WPX9195 |  |  |  |  |  |  | 797 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 797 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PETRONAS | 583765
BKD5406 |  |  |  |  |  | 170 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 170 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ISTIHANDAL | 583766
RT9531 |  |  | 56 |  |  | 378 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56 |  | 378 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 583767
BPG7797 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 143 | 111 | 32 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 243 |  | 211 | 32 |  |  |  |  |  |  | DEPOSIT 100 | 583768
QCE7717 |  |  |  |  | 3 | 524 |  |  |  |  |  |  | 17 |  |  | 102 |  |  | 102 |  |  |  |  |  |  |  | 527 |  |  |  |  | 17 |  | 102 |  |  |  | 102 |  |  |  |  |  |  | 583769
VAY1295 |  |  |  |  |  | 210 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 210 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 583770
DCS5590 |  |  |  |  |  |  | 406 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 406 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 583771
VBD2613 |  |  |  |  |  |  | 525 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 525 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PETRONAS | 583772
VAU6202 |  |  |  |  |  | 462 |  |  |  |  |  |  |  |  |  | 114 | 114 |  |  |  |  |  |  |  |  |  | 462 |  |  |  |  |  |  | 114 |  | 114 |  |  |  |  |  |  |  |  | 583773
MDA1522 |  |  | 130 |  |  | 304 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 130 |  | 304 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 583774
BNK8672 |  |  |  |  |  | 637 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 637 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 583775
VLC6123 |  |  |  |  |  | 553 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 553 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 583776
VIP4132 |  |  |  |  |  |  | 756 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 756 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PETRONAS | 583777
JMM1956 |  |  | 225 |  |  | 525 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 225 |  | 525 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  | 583778
TOTAL
S/No | JENIS SILINDER DAN KATEGORY |  |  |  |  |  |  |  |  | 12 KG |  |  | 14 KG |  |  | 12 KG BT |  |  | 14 KG BLW |  |  |  |  |  |  | 50 KG OREN |  | 50 KG CLW |  | 50 KG YT |  | 50 KG YTW
1 | JUMLAH JUALAN [NAME]
2A | BOCOR ISI DITERIMA DARI [NAME]
3A | SILINDER ISI DITERIMA DARI [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | For [NAME] Quantity Manually
4 | SILINDER DITERIMA DARI PETRONAS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0
PEMBUKAAN DAN PENUTUPAN BUKU STOK UNTUK HARI INI
1 | Cylinder Type |  |  |  |  | 12 KG |  |  |  | 14 KG |  |  |  | 12 KG BT |  |  |  | 14 KG BLW |  |  |  | 50 KG |  |  |  | 50 KG ORANGE |  |  |  | 50 KG CLW |  |  |  | 50 KG YT |  |  |  | 50 KG YTW
2 | Opening Quantities (B/F) Closing |  |  |  |  | 11003 |  |  |  | 34338 |  |  |  | 759 |  |  |  | 3363 |  |  |  |  |  |  |  | 1329 |  |  |  | 449 |  |  |  | 1332 |  |  |  | 333
3 | Category |  |  |  |  | Empty |  | Fill |  | Empty |  | Fill |  | Empty |  | Fill |  | Empty |  | Fill |  | Empty |  | Fill |  | Empty |  | Fill |  | Empty |  | Fill |  | Empty |  | Fill |  | Empty |  | Fill
 |  |  |  |  |  | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out
4 | Total (DATA Cell 65)
5 | Grand Total (G74+G77-H77) (J77-I77)
6 | Closing Quantities (C/F - Opening Tomorrow) (G78-I78)
 | Please ensure closing cell at G79
 | Note | 1st day of the Month OPENING is manual input from lst month Closing
 |  | New worksheet is created on daily basis for a month
 |  | From 2nd day to month end, the OPENING AND CLOSING need to be Auto update
 |  | [NAME] used for carry forward the CLOSING to OPENING for the 2nd day is
 | 1 | The first formula being used from 2nd to the 8th is ='1.11.23'!G79
 | 2 | The second formula being used from 9th to the 12th is =sum('8.11.23'!G79)
 |  | In both formula, I need to change the date to retrieve the closing balance as Opening for the 2nd day onwards.
 |  | Have tried the Indirect formula but result showing REF error on the 3rd.
 |  | Need help on the following
 | 1 | What formula I can use to Auto Update today's closing to tomorrow's Opening
 | 2 | What formula is suitable to track if there are changes to CLOSING AND OPENING BALANCE
 | 3 | Can I use Conditional Formating <> for CLOSING and OPENING