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 2UPLOAD 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



Comments

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   ...

What are the Different Levels of FiRe ?

FiRe (Financial Independence / Retire Early)  is a movement where a person has to adopt to a certain lifestyle with the goal of gaining Financial Independence and Retiring Early. I only got to know of this movement a few years ago after watching a video on Graham Stephen's Youtube channel.  Just like Graham Stephen, I started adapting a frugal and savings lifestyle when I was young but there wasn't a name for this until  Fi/Re  was made famous. I got serious about Saving To Retire Early about 10 years ago after attending T Harv Eker's Millionaire Mindset seminar . I learned about the JAR system from the seminar and I have been practicing it without fail for the past 10 years. I am proud to say this has helped me tremendously to achieve my financial freedom goal. T Harv Eker has a book called " Secrets of the Millionaire Mind: Mastering the Inner Game of Wealth " which I highly recommend.  I wrote an article about the Money JAR System which you can read by c lic...

Trading Journey [ Part 2 ] - Consistent Set of Actions

The month of March2021 had been a rather rough month for me. I lost 100% in my Sell Put strategy for SPY due to the crazy volatility caused by the 10 year yield scare. I have since adjusted my Stop Loss to be triggered at 250% instead to avoid being stopped out from price volatility. I closed my PEPSI sell put option by manual cut loss 21 days before  expiration which ended up bring profitable if I didn't cut early...another reason to stick with the original game plan instead of tweaking my exit plan halfway after entering the trade. I just realized 100% losses from my bull put strategy on APPLE and JNJ.   The losses was a bit hard to take and do I decided to take more risks by not sticking with my game plan for my overall trading strategy and added more options trades which did not follow my rules and went beyond my trading size. Once such trade is I did a SELL Iron Condor on Facebook when it was trading at $260. I looked at the chart and saw it was in middle a strong Re...