Skip to main content

Create a Financial Freedom Blueprint Using Google Sheet Template

 



In my previous article on Financial Freedom Blueprint, I wrote that using this Blueprint can be a powerful tool to help kickstart your action plans to achieve your financial goals. I also shared a Google Sheet template which I created to act like a template.

You can get the Google Sheet template for the blueprint here:

GOOGLE SHEET - FINANCIAL FREEDOM BLUEPRINT COPY


Using this template can be difficult for some people as I created it based on my own understanding and I wanted to simplify the Blueprint creation through semi-automation. Most of the fields are quite straight forward and easy to fill, but some may will require more explanation from me. Anyway I will try to explain as much as I can. Feel free to copy this google sheet into your own Google Drive account and make any modifications that you may like.


I will have a few sheets. You will only need to make changes to one sheet that is BLUEPRINT PLANNING. The other sheets we do not need to touch.


I will have 7 rows. Each No will represent a Blueprint. So your first blueprint will be under No 1 (I left No 0 as a sample).  Only cells with this background color will need to be filled. This part should be easy but I will elaborate on IMAGE HTTP (1 and 2).


IMAGE HTTP

For IMAGE HTTP, there are 3 few ways you can do this to add images into your blueprint.

OPTION 1 : PUBLIC IMAGE

You will only need to enter the URL of any public image that you can find online. For instance, you search for a Ferrari car through Google Images. Just click on that image until you land into the website, look for the image on that website and copy image address. 


OPTION 2: UPLOAD THE IMAGE INTO YOUR GOOGLE DRIVE

This option is a bit tricky. You will need to upload the image into your google drive, make the image public, get the shared URL, change the format of the URL. It is abit troublesome to do this so you may want to choose either option 1 or option 3 if you prefer less hassle.

 

For example in Google Drive, the Shared URL is https://drive.google.com/file/d/10KFBTAzaKGhpKx3hrqyfPrJLZqBNB4wg/view?usp=sharing

Copy 10KFBTAzaKGhpKx3hrqyfPrJLZqBNB4wg from this URL, and substitute it with <Image_URL> here:

Google Drive URL format : http://drive.google.com/uc?export=view&id=<Image_URL>

This is the URL you should put into Google Sheet: 
http://drive.google.com/uc?export=view&id=10KFBTAzaKGhpKx3hrqyfPrJLZqBNB4wg


OPTION 3: INSERT THE IMAGE DIRECTLY INTO THE CELL

Directly view to the Blueprint sheet  (eg: BluePrint 1, BluePrint 2,etc), Highlight the cell, go to the Insert tab, choose Image -> Image in Cell.

Choose the Image and you should be able to see this image in the Blueprint.
Choose the image (upload or search the Internet) and Insert



Take note that doing this will clear the excel formula in the cell 

MILESTONES

After you have completed a milestone, just to tick on the checkbox and it will be reflected in the Blueprint page. 



PRINT OR EXPORT THE BLUEPRINT INTO PDF

Once your Blueprint is ready you can now either print your blueprint or create a pdf (which you can save it in your phone or PC).


PRINT












SAVE TO PDF









NEXT : How to set Desktop Background Slideshow - for your Financial Freedom Blueprints



Labels:

Comments

Post a Comment

Popular posts from this blog

A Study in Technical Analysis : Candlestick Part 1 - One White Soldier

Decided to start a Technical Analysis series to analyze a few candlestick patterns and other tools to help me improve my stock and options trading.  ONE WHITE SOLDIER One White Soldier candlestick pattern is a Bullish Reversal Pattern used to predict the reversal of the current downtrend. The pattern consists of two consecutive long-bodied candlesticks - The first being a Bearish Candlestick followed by a Bullish Candlestick. This candlestick pattern rarely appears and if it does appear it's likely a strong indication of a reversal in trend (supported by other indicators as well). The One White Soldier should have the following  characteristics.  Bearish Candle followed by a Bullish Candle.  If it is during a long downtrend, The Bearish Candle must be a new low in the downtrend(Counter Trend Trade).   1.   The Bullish Candle must open Above the Close of the Bearish Candle Open2 Higher than Close1   ...
Post a Comment
Read more

Sell Put Spread Strategy on SPY To Generate Monthly Income

  I was introduced into the world of Options Trading when I joined a Value Investing Course by a stock investing guru named  Sean Seah . One was the strategies I learned from this course is called VIOS (Value Investing Option Strategy). This strategy aims to consistently make money by selling naked put options to collect premiums on fundamentally good stocks with minimal risk (worst case scenario you are forced to buy that stock if your option is exercised). Anyway I won't be talking too much about the Fundamentals of Options as you can find many free videos of these on YouTube and paid courses on Udemy. I have been selling mostly naked put options to collect premium for 4 years using the ThinkOrSwim platform and I was collecting good premiums making some small profit. One strategy I used was to keep rolling my option if it went In-The-Money (ITM) on expiration day . However I discovered that  there is a huge risk involved with this Naked Selling Option Strategy even when...
Post a Comment
Read more

The TOP 3 DOs and DONTs To Be a Successful Investor

Many times we ask ourselves "Why do some people make money easily while I have a difficult time doing so?". I already have a few friends who are making tons of money after huge investment in crypto and I have another friend who has made tons of money in options trading. I am still struggling and I have been asking myself why. What am I lacking compared to them? I believe it is the amount of effort and time that my friends have placed to master the art of trading and investing -that make them successful. They will only focus on one thing and continue to sharpen that skills and knowledge relevant to that instead of jumping from one to another. For my case I have dabbled in the futures market, day trading, options, some crypto....all with mild or no success.  It is time for a change.  I have to put in more effort to be a more of a successful investor. knowledge without action is meaningless. We must Do the right things and DONT Do some things that may hinder our progress to be s...
Post a Comment
Read more