Staying On Track

Time Posted on February 04, 2012 User Dakota Lynch

 

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.
 

Get it Now!

 

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.

43 responses to Staying On Track

C0928da0dba0ffe38d3cd02cf87a03b5?d=wavatar
BibleBeeJunior14 (~*Lady Ariana*~)

Wow! :) Coolness. Thanks. I'll have to try it soon. :)

C0928da0dba0ffe38d3cd02cf87a03b5?d=wavatar
BibleBeeJunior14 (~*Lady Ariana*~)

Yay! :) First comment.

A3806e5a47ff9fa527155bd268c37099?d=wavatar
His Servant

Thanks so much for making this...it's really neat! I did have one question though -- on the bottom, there's a green button that says "I memorized a Scripture" is this supposed to be when you memorized one on Memverse, or just when you memorize a verse? I was wondering, because it asked "how many do you have memorized on Memverse"...or something similiar to that.

Thanks again, Dakota!

563d64f818c863649c6f43983a7daeca?d=wavatar
Dakota Lynch

REVISED: Choosing when to click the green button is really up to you, although I plan on waiting until it is "officially" memorized on here before doing so to ensure that my numbers always match up with my memverse account. Whatever works best for you.

By the way, I went ahead and removed that question about how many verses you're currently learning. It seemed to complicate things too much in the long run. :)

563d64f818c863649c6f43983a7daeca?d=wavatar
Dakota Lynch

By the way, I made a point to ensure that your starting number of memorized verses is always visible since I know it can be a challenge to enter every verse you memorize without forgetting a couple here and there. By comparing this number to your current number of memorized verses on memverse, you can always tell how many Scriptures you've really memorized since starting the program.

D7e51a6e027780a48295eb2d73bc059f?d=wavatar
Rachel Irene

Wow! I'll have to try this!

9e3bcc5e7bd16e78ae9c6d4fb710f83a?d=wavatar

Thanks! I hope this will be useful! But I have 1 question:
How do I start using it? Thanks again!

D041df7adb6f87bed0a4ce5324625e83?d=wavatar
Jael

Coolness! I'm gonna have to try it (on something other than my iPad!)! Thanks, Dakota!

563d64f818c863649c6f43983a7daeca?d=wavatar
Dakota Lynch

Chloe:

Click "Get it Now" (above), and when Excel opens click "Get Started." You'll be walked through the rest with prompts, etc.

D041df7adb6f87bed0a4ce5324625e83?d=wavatar
Jael

Dakota: It doesn't work on our Excell - it must be too old. Any suggestions? My Dad's an Excell whiz, so he might be able to program what you did into our "ancient" Excell.

563d64f818c863649c6f43983a7daeca?d=wavatar
Dakota Lynch

Jael,

What version of Excel are you using? If it's from 1997-2003, try following the link below and downloading the compatibility version (click File>Download Original). Some of the features will probably be lost, but it's worth a try.

https://docs.google.com/open?id=0B-Qn1uwP-OeSZDkwYTE3MTMtMTBhMC00YjgzLTk3OWItM2RlMzllM2VlNzky

Unfortunately, if you're using a version prior to '97 (there's versions all the way back to '87!), then the only suggestion I could offer would be to update.

D041df7adb6f87bed0a4ce5324625e83?d=wavatar
Jael

I know it's not earlier than '97. I think its '03, but I'm not 100% sure. I'll try it. Thanks! (I set a goal of 100 verses per month in December, but I wasn't sure how I'd be able to tell if I was making it! This excel idea is fantastic!)
Thank you thank you thank you!

D31c974fe43f1230dbcb183971bfbdec?d=wavatar
Emily H

Wow, this is really neat! Thanks!

A5add584fd0f556712d9e039c68fa698?d=wavatar
Andy

That is very cool. Thanks for sharing that with everyone, Dakota.

D7e51a6e027780a48295eb2d73bc059f?d=wavatar
Rachel Irene

When I click on it, I see a button that says: Click here to get started! But when I click on it, it says that my macros have been disabled. What can I do about this?

9e3bcc5e7bd16e78ae9c6d4fb710f83a?d=wavatar

It still does not work! Sorry for all the trouble!

E722bfd45297b0c0558ed8ed53593094?d=wavatar
Alex Watt

Thanks, Dakota! I've often made basic spreadsheets for things like this, but from now on I can use yours. :)

C0928da0dba0ffe38d3cd02cf87a03b5?d=wavatar
BibleBeeJunior14 (~*Lady Ariana*~)

Um it doesn't work on mine. It says, no preview available or something like that.

C0928da0dba0ffe38d3cd02cf87a03b5?d=wavatar
BibleBeeJunior14 (~*Lady Ariana*~)

YAYYYYYYYYYYYY!!!!!!!!!!!!!!!!!!!!!!!!! Congratulations to me, congratulations to me, congrats are in order, congratulations to me! :) LOL I memorized my 100th verse!!!! :)

C0928da0dba0ffe38d3cd02cf87a03b5?d=wavatar
BibleBeeJunior14 (~*Lady Ariana*~)

I'm gonna have to ask my dad if I can download this...

7dd80386abb09077121e3035a6872af4?d=wavatar
God's Maiden of Virtue

Congratulations, BBJ12!! That is very exciting!

Dakota- Wow! Thank you! This is a big help.

C0928da0dba0ffe38d3cd02cf87a03b5?d=wavatar
BibleBeeJunior14 (~*Lady Ariana*~)

@God's Maiden of Virtue - how's your little brother?

Congratulations on memorizing your 400th verse btw. :)

563d64f818c863649c6f43983a7daeca?d=wavatar
Dakota Lynch

BBJunior,

Yes, the workbook must be downloaded to work properly. Google Docs (the file host) does not provide previews of Excel files.

563d64f818c863649c6f43983a7daeca?d=wavatar
Dakota Lynch

I just noticed that, on Excel 2010, the feature which provides you with a running total of your memorized verses was not displaying properly due to the previous font size. If any of you had trouble with that, the problem is now resolved.

93fcb35bede1ac128cb83b71e8060885?d=wavatar
SavedByGrace

Wow, this looks great, Dakota! However, I'm going to have to ask for some from my dad with this. I'm not the best with computers... But thank you anyway!

C28bde243ab1957d69d6429cdf8b5e8e?d=wavatar
biblebee

Thanks Dakota for making this!!! It looks great. I just downloaded it and set it up with my goal.

C0928da0dba0ffe38d3cd02cf87a03b5?d=wavatar
BibleBeeJunior14 (~*Lady Ariana*~)

@Dakota - ok great! :) my dad just doesn't like it if we download stuff like this without permission, especially since we all share a computer...:)

C0928da0dba0ffe38d3cd02cf87a03b5?d=wavatar
BibleBeeJunior14 (~*Lady Ariana*~)

ALRIGHT! :) 101 verses!!!! :)

7dd80386abb09077121e3035a6872af4?d=wavatar
God's Maiden of Virtue

BBJ12- He is doing really well. It seems like he gets cuter everyday. WHY CAN'T BABIES STAY LITTLE!?!?!?!

C0928da0dba0ffe38d3cd02cf87a03b5?d=wavatar
BibleBeeJunior14 (~*Lady Ariana*~)

@God's Maiden of Virtue - I know!!!!!!! My little brother is growing up WAY TOO FAST!!!!! :) It seems like he was just born yesterday and now he's over 1 year old!!!!!!! BTW, is that you? You're pretty!

7dd80386abb09077121e3035a6872af4?d=wavatar
God's Maiden of Virtue

BBJ12- Yes, it is. Thank you! Are you going to put up a picture of yourself sometime?

C0928da0dba0ffe38d3cd02cf87a03b5?d=wavatar
BibleBeeJunior14 (~*Lady Ariana*~)

I'll have to ask my mom. I did it a couple of months ago but now I have to find a good picture...again. :) I probably will...:) How old are you?

C0928da0dba0ffe38d3cd02cf87a03b5?d=wavatar
BibleBeeJunior14 (~*Lady Ariana*~)

Do you compete in bible bee?

what version do you use?

D7983f1197e2172216bac29a559ec30c?d=wavatar
Ruth (Joy)

This is really cool! Thanks, Dakota! It will really help me to stay on track.


GMOF: I really like that picture of you better than your old one.

C0928da0dba0ffe38d3cd02cf87a03b5?d=wavatar
BibleBeeJunior14 (~*Lady Ariana*~)

@Mommy's Helper - same here! :)

5c3d80d9bf04a645711fc934afb54a80?d=wavatar
ZachB - zachbaas.com

Wow, thanks! I'll have to check it out!

9e3bcc5e7bd16e78ae9c6d4fb710f83a?d=wavatar

I think it's just that my family's just to old, we're just to old school...........well, I'm only 10, so don't you think I'm a little young 4 doing this? My family's sick and grandma has cancer, (sigh) Help, Lord!

7dd80386abb09077121e3035a6872af4?d=wavatar
God's Maiden of Virtue

Mommy's Helper and BBJ12- Thank you! I like it a lot better too!

Chloe O. (choleo)- Would you like me to pray for your family and grandma?

BBJ12- I am 12 years old.
I did compete in the Bible Bee. I was in the Junior Timothy Track. I came in 1st place in the locals, and 22nd place nationally. I used the NIV, but I use NKJV when I read my Bible at home and at church. What version do you use?

D42734f93635b065b62ec60db502cb49?d=wavatar
Everett H

This is neat! but I can't get it......oh well.

C0928da0dba0ffe38d3cd02cf87a03b5?d=wavatar
BibleBeeJunior14 (~*Lady Ariana*~)

@God's maiden of Virtue - wow! You did great!!!! :) I use NASB. :)

7dd80386abb09077121e3035a6872af4?d=wavatar
God's Maiden of Virtue

Thank you, BBJ12! I did a lot better than in 2010. We had moved that summer, so I wasn't prepared at all.

Fc2b647e40ef1cad58fd484418c81fc4?d=wavatar
A.K.

Hi, Dakota, I have been using this spreadsheet as frequently as I memorize another verse. It has been absolutely wonderful!

However, I have two questions:

First, is it possible to amend one's goal if you discover you've really overstretched yourself with lofty ideals (when I first started) that were really unrealistic? :)

Instead of becoming disheartened, I'd prefer to be able to reduce my original goal, without upsetting the original entered values for verses already memorized and those I've subsequently added (or the occasional deletion).

Or is the only way to do this is to download a new spreadsheet and start all over?

Secondly, on your summary page, there is no mention of the actual Goal Number that one has set in the initial questions. Is it possible to amend this spreadsheet to show this? (It is password protected or I would simply do it in my copy, but it would be nice to have that linked to the answer to that question.)

Thanks!! AK


Trans