Since the New Year, I've noticed many memverse users setting and sharing memorization goals they would like to achieve in 2012. I myself haven't been one to set many New Year's resolutions in the past, but this year I decided one might be in order since I've slacked off recently in learning new verses.
Even though I'm not nearly as skilled in programming as Andy and Alex are, I thought it would be helpful to have an easy-to-read workbook that lets me know if I'm on track to reach my goal – and since I know my way around Excel, I spent today making that happen. Not only does this program tell me how many verses per day I should memorize, but it even lets me know exactly how long it will take me to achieve what I've set my sights on at my current pace!
When you get started, you’ll be presented with the following set of questions which Excel will then use to analyze your circumstances:
How many verses have you already memorized?
How many new verses would you like to memorize?
By what date would you like to be finished?
Once you’ve completed this initial interview, all you have to do is come back periodically and input how many verses you’ve since memorized. This tells the computer how many verses per day you’re averaging and whether that is enough to reach your goal within the desired timeframe. Once you’ve been doing this for a couple weeks, you’ll even be able to see a fairly accurate prediction of the exact day it is you’ll cross the finish line!
Of course anything this complex carries the potential have a few bugs, so the first few of you to download this can consider yourselves the “beta group” despite my best efforts to make sure everything is in working order prior to this post. If ever you encounter a glitch or mathematical error, feel free to comment and let me know.
LAST REVISED: 2/6/12
NOTE: This workbook requires the enabling of macros on your PC. If they are not already allowed on your machine, follow the instructions in this tutorial.
After clicking the "Get it Now" link, choose "Download" in the upper, right-hand corner of your screen.