Sri Lanka Day 41 (Welisara): Production Report Refinement Down!
Yup, so it has become an unspoken fact that we won't be leaving today. Time really fies and guess what, we haven't planned anything for this weekend. HAHAHA. SO it is going to be Colombo Food Trail again! Actually I wanted to go to some places which we have missed out last time. Shall see how things go!
Breakfast: Egg sandwich
Finally had an idea how to modify the production report and I am quite proud of my brain. So basically, instead of isolating PMG report, we have combined it with the other production report and created a PMG input file. After having formula like =IF(H40>INDEX('Volume Of Tanks'!$B$4:$AJ$1528,MATCH(MAX('Volume Of Tanks'!AH:AH),'Volume Of Tanks'!AH:AH,0),1),MAX('Volume Of Tanks'!AH:AH),IF(H40=0,"NA",IF(H40=0,0,VLOOKUP(Input!M39,'Volume Of Tanks'!$B$4:$AJ$1528,MATCH(A40,'Volume Of Tanks'!$B$4:$AJ$4,0),FALSE))+IFERROR(IF(H40=0,0,VLOOKUP(Input!N39,'Volume Of Tanks'!$B$1532:$AJ$1542,MATCH(A40,'Volume Of Tanks'!$B$1532:$AJ$1532,0),TRUE)),0))) in the tank farm report, I think the production report wasn't difficult anymore. HAHAH glad that I have learnt something and improved my excel skills.
Lunch: Tandoori Chicken Buriyani
Finished Production Report Refinement but because of what Operation Manager said to us yesterday, I realised yup, actually I still had a lot to find out. So the things left on my to-do list are: import and export learning reports, lab learning report, tank farm learning report and consolidation report.
As for my own personal things: photo organisation, facebook photo upload, blog update, OSL application, forensic science assignment, course registration.
Too many things to do and yet too little time.
Went to Tilakma after work to buy ice cream for our office and hotel as farewell. I also bought a lot of biscuits and cookies. yummzz. Lost 2 rubberband here because I am as careless as usual. So, I had to buy rubberband and of course replace the battery for my mouse. Umbrella... thought of getting it at the road side tomorrow since it should be cheaper.
Dinner: Half portion of seafood noodle, which was damn salty. It was funny how they even cut the egg into half. HAHAHHA.
