• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Dragon Lake Books

The home of great stories

  • About
    • Privacy policy
  • Where To Buy
  • Sample Chapters
  • Events
  • My 100 Goals Blog
  • Contact Form
  • Mailing List Sign-up

skills

Analysis of a Project

June 6, 2017 by Mark Anderson Smith Leave a Comment

Back in 2013 I completed one of the largest projects I’d tackled to date and decided to work out what I’d actually managed to produce during four months developing a complex business application. I realised then that I’d actually produced the equivalent of a book with all the code, queries and user documentation I’d written. That realisation was pivotal in helping me believe I could finish my first novel.

Last week I completed a much smaller project, one that only took 17 days and decided to carry out the same analysis.

The final application had:

  • 12 user forms, each providing a different type of functionality to the users.
  • 3635 lines of code.
  • 13 database tables
  • 57 SQL queries.
  • 28 user guide.

Converting those lines of code into pages, that’s 95 pages, plus effectively 57 pages for the SQL queries and the 28 page user guide. A total of 180 pages, not including the forms or database design. 180 pages equivalent, after editing and testing… A proof read, formatted, final draft…

Divided by number of days on the project, that works out to just over ten pages a day, full time. So, in theory, if I could match that level of output for my fiction writing, I could potentially write a 300 page novel in 30 working days, or in six weeks.

Writing that last sentence, I still find it hard to believe that it’s possible. But, it’s worth noting that I’ve been working as a software developer for 13 years now. Enough time to have honed my skills, to have learned the methods and routines that allow me to tackle complex projects.

If we keep working towards developing our skills and experience in areas we want to improve, we will see progress. Often, there is no substitute for perseverance. For taking the long road, building discipline and habits. This is part of the reason I’ve set myself the challenge of writing at least 100 words a day for 100 days.

What goals do you want to achieve? What skills will you need to achieve them? Will you commit to developing those skills, day in and out? If you do, one day you’ll look back and be amazed at how far you’ve come.

Filed Under: 100 Words 100 Days, SQL, VBA, Writing Tagged With: 100X100, goals, project, skills

Primary Sidebar

Follow

Follow me on:

Recent Posts

  • Q2 Halfway point
  • The 12 Week Year – a first quarter review
  • Double Your Salary …Without losing your soul!
  • 40K
  • Progress

Recent Blog Posts

  • Q2 Halfway point

    Q2 Halfway point

    May 12, 2021
    Back in December 2020/January 2021 I wondered if the contracting and job markets in the UK would continue to be dead through till the summer. It seemed possible that I might have to go six months without working and so to put a plan in place to make constructive use of the time seemed sensible. […]Read More »
  • The 12 Week Year – a first quarter review

    The 12 Week Year – a first quarter review

    April 21, 2021
    I recently finished my first 12 Week Year and wanted to review how it went to see if I could learn some lessons from the experience. If you’ve not read it, The 12 Week Year by Brian P. Moran and Michael Lennington proposes by working to a 12 week plan, you can get more done […]Read More »
  • Double Your Salary …Without losing your soul!

    Double Your Salary …Without losing your soul!

    June 25, 2019
    I’m excited to share that the hardback of my next book: Double Your Salary …Without losing your soul! will be released for sale on 1st August 2019. I believe that doubling your salary is possible when you understand who you are and what you are capable of. Sharing my story of how I doubled my […]Read More »
  • 40K

    40K

    June 15, 2019
    It might be that weekly posts are all I can manage until the first draft of Fallen Warriors Season Two is complete. I met my target of 10,000 words today and did manage to hit 2,000 words each day this week. That feels good. An accomplishment. I haven’t managed much else, publishing wise. I kept […]Read More »
  • Progress

    Progress

    June 8, 2019
    I wrote last week that I was setting a new target to write 5,000 words a day. Why do I do this to myself? The results are in. I think I managed a thousand words one day that first half week, then I’ve managed 4,790 this week. That’s not even a fifth of what I’d […]Read More »

Footer

My 100 Goals Blog

  • Q2 Halfway point

    Q2 Halfway point

    May 12, 2021
  • The 12 Week Year – a first quarter review

    The 12 Week Year – a first quarter review

    April 21, 2021
  • Double Your Salary …Without losing your soul!

    Double Your Salary …Without losing your soul!

    June 25, 2019
  • 40K

    40K

    June 15, 2019
  • Progress

    Progress

    June 8, 2019

Copyright © 2023 · Author Pro on Genesis Framework · WordPress · Log in