Dreamline Worksheet 2.0– Updates to the popular 4-Hour Workweek spreadsheet

March 3, 2008 by Jared Goralnick

Discover how to escape your inbox without missing urgent messages

Update: this has been downloaded over 10,000 times!
In the mean time, I put together a web tool that helps people to spend less time with email. It helps me tune out email distractions so I can check my inbox twice a day, but still get notified of urgent stuff via text message. It’s my other project (called AwayFind), you can check it out here (it’s also free).

The original 4-Hour Workweek Dreamline spreadsheet is available at that link. Below you’ll find a newly designed version that incorporates a lot of the feedback I received.

Screenshot of the Dreamline Spreadsheet - click here to download it

Download the Dreamline Worksheet and Expense Calculator 2.0 (Excel/XLS)

(Find the original instructions here)

The most noteworthy new feature is allowing both one-time and monthly expenses. In the previous version, one had to determine the monthly cost of each of their goals. Now one can enter the full cost and the spreadsheet will divide that total by the number of months for the Dreamline:

Demonstration of one time and monthly expense calculations

One thing to considerwhen using this new feature is that some purchases lend themselves to long-term monthly installments, like a mortgage or car payment. In those cases one should enter their monthly mortgage payment rather than the cost of the house.

The additional changes were small:

  • Prompts that help guide the user through the spreadsheet
  • Wider, improved printed layout
  • Minor bug fixes (these were all added to the previous download page as released, but many people have likely been using earlier versions)

If you find this helpful, you’ll probably enjoy my other posts on 4-Hour Workweek related topics. You can also subscribe to my blog by RSS or email today to stay notified of updates to this spreadsheet, and to read other ideas for reaching your goals through productivity hacks.

Feel free to leave any thoughts you have on this spreadsheet in the comments below, or add this to Stumble, Digg, or del.icio.us!

Discover how to escape your inbox without missing urgent messages

You should really subscribe to Technotheory via Subcribe via email email or rss.

78 Responses to “Dreamline Worksheet 2.0– Updates to the popular 4-Hour Workweek spreadsheet”

20 Trackbacks

  1. Technotheory.com – Dreamline worksheet: a follow up to the Four Hour Workweek
  2. Do Some Dreaming With The 4-Hour Workweek spreadsheet >> Persistence Unlimited
  3. Alternative Lifestyle Designing (The Rabbit Hole Tax and Baselining | The Growing Life | Alternative Productivity, Anti-Hacks for Living)
  4. The Income Snowball & Funding Your Freedom: A Four-Part Guide | The Growing Life | Alternative Productivity, Anti-Hacks for Living
  5. Funding Your Freedom to Work as You Please: A Four-Part Guide : Brazen Careerist – A Career Center for Generation Y
  6. 47 Decent Lifestyle Design Resources | The Growing Life | Alternative Productivity, Anti-Hacks for Living
  7. Howto: Dreamline | Student Business Blog
  8. Dreamlining: The Four Hour Work Week and Living Jet Set | Living Jet Set
  9. Resolutions Just Don’t Cut It – Reflect and Dreamline Instead
  10. FORECAST RAINZ » Daily Digest for 2009-01-01
  11. FORECAST RAINZ » Daily Digest for 2009-01-02
  12. How Much Money Do I Need To Fund My Nomad Lifestyle? | Dan Haneveer
  13. ROAD TO FAME: Setting Goals through Dreamlines « Fitness Junkie
  14. Dreamlining – The Cost Of Living Like You Want | James-Stickel.com
  15. Reach Your Dreams with Lifestyle Design | Thrilling Heroics
  16. 49 Tools for Living the Location Independent Lifestyle | Thrilling Heroics
  17. Happy New Year! Best Posts of 2009 & Goals for 2010 | Thrilling Heroics
  18. Day #1: New Year’s day 2010. DREAMLINING. @ jotsquared
  19. It’s time to shake things up! Wanna watch? « The (Revolved Life)
  20. Lessons learned from the richest man whomever lived / Limitless365

2 Tweetbacks

  1. ebarbaric (Ernest Barbaric)

    @katieloumitch Hey that’s awesome! I’m working on Tim Ferris’ Dreamline worksheet: http://bit.ly/yqm4 and http://bit.ly/Ei6Wl

  2. usecas (Juan Jos? Bautista)

    I have just finished to fill the Dreamline Worksheet 2.0 of @tferris, http://tinyurl.com/6cynk4


  1. Art Gonzalez

    Jared, fantastic tool! Thank you. I will try it today. Have already share this link with my 4HWW fan friends.

    Many blessings,

    Art Gonzalez
    Check my Squidoo Lens at: Quantum Knights

  2. BrandMover

    Thank you Tim,

    This helped me to FOCUS a lot.
    Truncates all the fluff, as a 80/20 rasor ;-)

  3. Jessalynn Coolbaugh

    Positively Brilliant!

    I am so glad I took a friend’s recommendation to come take a look – I’m definitely looking forward to using this to implement my own goals, thank you!

    Jessalynn Coolbaugh

  4. DaveH

    How can I add rows to the sections of the spreadsheet? What if I want to use more than five rows for, say, “Having” items?

  5. Jared Goralnick

    You would simply unprotect the spreadsheet and add a row to any of the middle rows–this would help prevent messing up any formulas. If there are any troubles with that, I’d recommend taking a look at the named ranges and making sure that whatever you’re changing is represented there, as well.

    Here’s more on protection and named ranges:

    Hope that helps!

  6. Tim Wright

    In the book, only the cost of the 4 starred dreams are added into the TMI/TDI.

    In the spread sheet, all costs are totaled in the Have, Be, and Do sections and all are added into the TMI/TDI.

    If I’m only focusing on the 4 dreams isn’t the ‘sheet misleading?

  7. SIA Licence

    Hi Tim,
    Just finished reading your book, I run a Security Training business in London
    I have outsourced most work, works like a charm.

  8. Hayden

    Any way to add more fields?

  9. Jared Goralnick

    @Hayden, sure nothing to stop you from it at all! Just insert rows and columns as you’d like. Mind you, you might need to adjust formulas accordingly, of course.

    Though the spreadsheet is locked, there’s no password. I wrote above in the comments other tips on working with it.

  10. SIA License Training

    Yes I to ousource many functions and it does help a lot! Thanks

  11. Plumbing Training

    Hi Tim!

    The updates are useful ongoing training, many thanks old chap!

  12. Fin

    Is there anyway we could get a version that works in google documents?

  13. Jared Goralnick

    Hi Fin,

    There are a number of features in this spreadsheet that wouldn’t work in Google Documents, but you’re certainly welcome to work out the basic featureset there. If you put it up, just let me know and I’ll be happy to link to it.


  14. Houston SEO

    Thanks for sharing this spreadsheet. I am all about planning out my dreams for my business. Having set goals, specially the lofty ones, have been a huge motivator for me. I am going to put this up on the wall in front of my desk.

  15. FlashBack

    Thank you for sharing this spreadsheet. I’m all about the planning of my dreams for my business. Having established the goals, especially the nobles, have been a great motivator for me. I will put this on the wall opposite my desk.

  16. siggi

    i am form iceland and live in boston, did u take that trip to iceland

  17. Jared Goralnick

    Yes, Siggi, I did make the trip (though I went for 10 days)! Here are some photos : ).

  18. Steven Cates

    Jared I like the enhansements however my worksheet won’t give me a total. What do I need to do?


  19. Jared Goralnick

    Hi Steven,

    You’re not giving me much info to go by… You can write some more details here so other people can see if they’re running into the same issue, or you can email the file to jared at this domain.

    Best of luck!

  20. internet marketing Melbourne

    Great thanks Jared.
    This spreadsheet is fantastic
    I attended a marketing seminar by a world renowned guru and he mentioned the 4 hour workweek, but I didn’t know what exactly it was or how to get started. This is great.

  21. SIA Training

    The spreadsheet is cool – I produced a similar one recenly.

  22. ??

    I attended a marketing seminar by a world renowned guru and he mentioned the 4 hour workweek, but I didn’t know what exactly it was or how to get started. This is great.

  23. Celebrity

    Thank you!! Very useful!

  24. Phil Williams

    Thanks for an amazing tool! I found it useful to add TMI and TDI without Monthly Expenses. For those of us not planning on leaving our “day” jobs, this is the number we need to hit with our muse(s) to make these dreams happen. I added these two rows just above where you currently have the TMI and TDI and labeled the originals “* w/ Monthly Exp.”. If you find this useful, please include it.

  25. Phil Williams

    Some more ideas came to me:

    1. Add a notes column to the right of each expense to remind you what went into each expense. For example, my subscriptions included dog insurance, gym, professional membership, 3 magazines.

    2. Have a blank brainstorming area where we could write down lots of ideas for each dreamline category.

  26. Darpan

    Hi Jared,
    After going through the Dreamline work sheet ,i have the following querries.Would be grateful if you please could clear them up for me:
    1)What do the sections of HAVING,BEING and DOING mean there exactly in the Work sheet?
    2)What do the STEPS NOW,TOMORROW and DAY AFTER TOMORROW indicate there?

    Darpan Schdeva

  27. Jared Goralnick

    Hi Darpan,

    HAVING BEING and DOING refer to things you would like to have, be, or do in that column.

    Now, tomorrow, and day after are the time period when those steps are to take place.


  28. CCTV training London


    The article is very useful and keep on going with updated and interesting one.

  29. Ross

    Hey Jared

    I’m not able to download the xls – for some reason clicking the link is not doing anything! Is it still available?


  30. Ross

    Hi again

    Sorry – turns out it was a FF for Mac thing – tried on safari and it was a-ok.


  31. Joseph

    Fantastic book, let me thank you dearly – outsourcing almost all of the work is like a charm… and stress relieving!

    The spreadsheet? I think that talks for itself – awesome of course :)

  32. SSIS Tutorials

    Thanks Jared. This even works in Open Office. This will definitely motive me!

  33. Buster

    Does anyone ever have the xls document open in a wordpad? for some reason I can’t open the spreadsheet even with excel

  34. speed dating nyc

    I tried it in Open office too and it works great … thanks for sharing!

  35. killer sudoku puzzles

    The download link seems to be working fine for me, perhaps change broswers and try it that way, and thanks as well jared cheers

  36. Zygman

    Hey Jared,

    I found your spreadsheet very useful. Thanks for putting so much work and sharing with the community.

    I have one question though. How do you change the currency? If, for example, I want EUR/DKK/£ instead of $, how should I go about it?


  37. 100 kondome

    Oh yes, it works. outsorcing at its best…

  38. Rob

    Hmm … I got an error:

    “Excel found unreadable content in ‘DreamlineWorksheet2.0.xls’. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.”

    Then I clicked Yes, and got:

    “Unable to read file.” and then, “The workbook cannot be opened or repaired by Microsoft Excel because it is corrupt.”

  39. Anthony

    How do I unlock the stars…it says its protected.

  40. Oyunlar

    Thank you!! Very useful!

  41. Constantine

    I just downloaded your worksheet and I just wanted to say thank you. It works great and it looks great. Thanks!

  42. Grossesse Semaine Par Semaine

    Hopefully this’ll set you down the right path to working away from the office.

  43. Goran Gligorin


    I like this worksheet a lot – but as Zygman a few comments back asked – can the currency be changed? That would be great.

    - Goran

  44. Vitamins

    Nice one! I have tried it, wonderful!

  45. Caroline


    I tried to download the file twice and received the same error Rob did. “Excel found unreadable content…”. After clicking Yes, it said “Unable to read file.”

    Nevertheless, I was able to download the older version of the Dreamline Worksheet, but am interested in the adjustments you made for Cost Type.


  46. sia licence uk

    this looks good, might have to give it a go.

  47. noels ebooks

    Thanks for the worksheet, it will help me take it to the next level. I am well on my way to achieving the 4 hour work week.

  48. Ramzi

    I love the spread sheeet but the TMI of starred items and TDI of starred items does not calculate correctly

  49. Richard

    Nice one Jared!

  50. EMMA

    Hi, wondered how you guys deal with time costs? A couple things on my dreamline cost, in actual money, zero, but take up time.

    At the moment ive calculated my hourly ‘earnings’ based on my job at work, and factored in time costs into dreamline item costs like this..

    is this correct?

  51. bodybuilding store

    I love the spread sheeet but the TMI of starred items and TDI of starred items does not calculate correctly

  52. Luke

    I like to share a folder with my friends in Dropbox so that we can compete on who is getting closer to their goals. It really helps – also with following diet according to 4HB.

    Use this link for a free account with extra storage than normal.

  53. w

    nice effort cool spreadsheet i had made a similar spreadsheet for training website 1 ace security dealing in cheap sia compliant security courses

  54. Rodrigo Langeani

    Great post. This is the second year ina row that I use this sheet to make my new year planning.
    Thanks for sharing!
    Cheers from Brazil!

  55. Smart Company Software

    I came across this from the Lifestyle Business Podcast. I’ve not tried it yet, but it looks pretty cool and should definitely help me focus on the goals for this year. Thanks for sharing.

  56. Sarah

    I’m just getting into this whole 4-hour workweek. Loved the book!

Impart Your Theoretically Interesting Wisdom

Your Comments