Re: Word Count Countdown,
Who's online
There are currently 31408 users online.
About | Staff | Help | Terms & Conditions | Codes of Conduct | Privacy Policy
Copyright © 2012 The Office of Letters and Light :: All posted novel excerpts remain copyright their authors.
Re: Word Count Countdown,
Oh, you wanted a formula. Try z=(word count goal)/450 it won't be perfect, but I can't figure out why, so, for now it's what I've got.
When you've solved for z, you just multiply by the number of days left in the challenge, so... for day one, you'd do z*30 and so on, so then you'd have 0 words to write on the 30th.\
Instructions for how to put this in an excel sheet copied from here: http://nanowrimo.org/en/forum_comments/246407
SO!!! To make your own daily excel table!
Make column A = days! So type in 1 in row one, 2 in row two, and 3 in row three.... (at this point, you can just box the three cells, hover over the corner until it is a solid black plus sign, then click and drag down, it will repeat the pattern.)
Next, in column B, type "=108*(31-A1)" then, just hover over the bottom corner of that cell until you see the black plus sign, and then click and drag down. The formula should show you how many words you need on a given day.
(note, I'm using 108 as my z-value. you'd use whatever value you got using my previous formula. It's still annoyingly off but I can't figure out why.)
Re: Word Count Countdown,
Good Lord, my head just imploded. Guess I'll stick to the the 50k :-)
I made a calendar for this year with the numbers from Anotherauthor's post. The blog post is about Nanowrimo in general and using this method. The calendar (very no-frills) can be found at the bottom of the page.
http://lemonbar77.wordpress.com/2011/10/27/another-way-to-50k/
Re: Word Count Countdown,
I made a couple of examples for other sliding scales too, in this thread: http://nanowrimo.org/en/forum_comments/246407 And IDK if I offered it in here, but seriously, if you want me to figure it out for a different word count, I'd be more than happy too.
I'm also considering making a nanowrimo OneNote template that would have a wordcount progress page in it, and will be putting these in there, of course. Because I am a nerd.
And an engineer.
For those who wonder how to get pretty close to the ideal? I think it's if you use 30.468 ish as your upper limit of integration. That's as close as I can get without going into annoying numbers of decimal places. IDK why this works and 30 doesn't, but think it might have to do with calculus zeros not being null values like real world zeroes are.
Re: Word Count Countdown,
the weird 30.468 number translates to my formula as
z=(your word goal)/464.145
daily goal=z*(days left in challenge)
Re: Word Count Countdown,
So I've been trying to figure this out, but let's just say there's a reason I'm an English major. I want this for 75k, easy enough, but I also only plan to write 26 out of the 30 days (I like to give myself one day off a week, and I'm very religious, so I don't write on Sundays).
Any tips on how to calculate this? I can get the numbers for 75k in 30 days (just multiply by 1.5, round half of the non-whole numbers up, the other half down. Is there a word for non-whole numbers? I feel like an idiot lol), but for the life of me I can't figure out how to reduce the number of days without making it go all wonky. Any help would be greatly appreciated!
Re: Word Count Countdown,
That calendar on the site is great. The only thing I would add is a second number on each day that shows the "total to date"