Hi Folks,
I thought of adding another post to my Singapore series blogs where I would like to share the planning sheet that helped me plan the entire trip and the analysis on the expenses incurred in Singapore,
This is a series of blogs where I am trying to let people know about some tips and tricks to visit Singapore that are not available on internet,
Prior to this one,
3. Day 1
I would like to share the a google sheet that I created that helped me throughout the trip and if you are a planning freak like me then you would really appreciate this.
Here is the link to the sheet, https://docs.google.com/spreadsheets/d/1rJ2YZJhNQvPB6AONj5cbroBjNocBlyhlu0pWf0btHkE/edit?usp=sharing
Create a copy of it and save it in your own google drive, modify it and use it as per your own suitability.
This sheet has following features,
1. It has list of all the possible things you need to do (Expense wise), right from Visa photo till return taxi to home.
2. I have divided the sheet into 3 sections, Before Travel, in Singapore, Extras and Optional (In my case it’s now couldn’t do it).
3. I have left most of the activities as it is with the cost, this can work for you as a checklist in terms of travel and attraction planning.
4. This is a smart sheet and gives you automated updated results based on your expense inputs.
5. You can enter expenses in Indian rupees and Singapore dollar. The sheet automatically color codes the expense separately.
6. The sheet has a section where Singapore Dollar FX rate is updated automatically in realtime, this is fed into all the SGD expenses. This gives you the total trip cost in INR in realtime with current FX rates.
7. The sheet also has a section where you can mark an activity done, that will make the activity paint color black with white font, this really helps in seeing what else is pending.
Please use it and modify it use it even if you are travelling different country with different set of currency, that would require some change but if you know little bit of excel then you can figure that out pretty easily.
Now let me show you some Analysis on expenses occurred with me in Singapore,
Travel – 35% of my total expense on travel, of course the flight ticket was the major contributor to that,
Food – Food was just 10% of the total trip expenditure and it was interesting to see that we spent almost equal amount of money on meals and juices and drinks !!
Overall – Overall I feel it was a good trip with balanced funds spent on each activity. As I said earlier, I could have saved little bit on Hotel but I didn’t want to compromise because we had a small kid with us.
Write to me at ankkkit@hotmail.com if you need some more info that you would like to know.
No comments:
Post a Comment