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.

42 responses to Staying On Track

7a9642c0b68fc82ba62575e98065846e?d=wavatar
BibleBeeJunior12

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

7a9642c0b68fc82ba62575e98065846e?d=wavatar
BibleBeeJunior12

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.

C5774965d7cf99fd952cd0ed251d39e6?d=wavatar
Jesus Paid It All (Rachel)

Wow! I'll have to try this!

9e3bcc5e7bd16e78ae9c6d4fb710f83a?d=wavatar
Chloe O'Connor

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.

C5774965d7cf99fd952cd0ed251d39e6?d=wavatar
Jesus Paid It All (Rachel)

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
Chloe O'Connor

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

E3d5a38f477fec7e320a827373b4dcff?d=wavatar
Alex Watt

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

7a9642c0b68fc82ba62575e98065846e?d=wavatar
BibleBeeJunior12

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

7a9642c0b68fc82ba62575e98065846e?d=wavatar
BibleBeeJunior12

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

7a9642c0b68fc82ba62575e98065846e?d=wavatar
BibleBeeJunior12

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.

7a9642c0b68fc82ba62575e98065846e?d=wavatar
BibleBeeJunior12

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

12f50796f1ac6c43f1346c0957ad5ba3?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.

7a9642c0b68fc82ba62575e98065846e?d=wavatar
BibleBeeJunior12

@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...:)

7a9642c0b68fc82ba62575e98065846e?d=wavatar
BibleBeeJunior12

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!?!?!?!

7a9642c0b68fc82ba62575e98065846e?d=wavatar
BibleBeeJunior12

@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?

7a9642c0b68fc82ba62575e98065846e?d=wavatar
BibleBeeJunior12

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?

7a9642c0b68fc82ba62575e98065846e?d=wavatar
BibleBeeJunior12

Do you compete in bible bee?

what version do you use?

89e337bd972cb46cf40878ad9e461d64?d=wavatar
Love

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.

7a9642c0b68fc82ba62575e98065846e?d=wavatar
BibleBeeJunior12

@Mommy's Helper - same here! :)

3ba4bff3f8b5619872e9ce381f9cf977?d=wavatar
ZacharyΒ (MemVerseFanatic)

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

9e3bcc5e7bd16e78ae9c6d4fb710f83a?d=wavatar
Chloe O'Connor

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

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

7a9642c0b68fc82ba62575e98065846e?d=wavatar
BibleBeeJunior12

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



Recent Posts

More pages

RSS Feed

Feed-icon Subscribe to feed

Search Blog

Memverse Blog Fans

Trans