Mail Count Calculator Instructions

[Pats2]

Make sure you enter vehicle load and column 17 correctly.   (HH:MM:SS)
It worked for me after I did that.

[FrozenToes]

Check what Pats2 said. You're route time looks right. Your office time is waaayyy off.
Time is entered HH:MM:SS so 5min 30 sec. loading would be 00:05:30.

As far as the time your reading under the columns, 110 would be hours ( which we know is wrong) and 51 is minutes. so right know it thinks your route is eval. at 110 hours and 51 minutes.(Look at the labels under these numbers.)

[Rosie]

Thank you, I did enter it wrong forgot it was hours, minutes, seconds.  My frustration is going away!!

[putback]

Some javascript/style in this post has been disabled (why?)

I'm looking for a "running eval" 2nd part of your response. A few years back there was a program available allowing you to enter your data daily showing you what your eval was up to that specific day during the count. Its outdated now. Most folks are desperately trying to find all the minutes they can. However there are circumstances when you need to loose a few minutes of say loading time to stay below certain standard hours. I've been around awhile, been burned high end as well as low by as little as a minute!   Thanks.

----- Original Message -----

From: [hidden email]

To: [hidden email]

Sent: Sunday, February 22, 2009 2:39 PM

Subject: Re: Mail Count Calculator Instructions

Not sure what you're asking.
You want to figure your eval. for each day individually? ie: Sat. is 43k,Tues 45K,etc..
Do you want a running eval. that represents your eval. as it progresses after 1 day then 2?ie: Sat. your a 43k after Tuesday route is a 44k.

---

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.237 / Virus Database: 270.11.2/1965 - Release Date: 02/21/09 15:36:00

[FrozenToes]

These calculators will do "Running Evaluations". The past calculators needed you to change the number of days, that have occurred manually. These calculators will automatically do it. They add a day if there is data in the letter column ( anything over one). So if you want to plug in numbers to forecast make sure you have something in the letter column. On the Eval. page top right is a box showing how many days the calculator is using at that time.

[postal1998]

Hey,

I have been using count calculators for about 6 years and never had a problem before that I could not find an answer to but it seems as though I am the only one here that has this problem. I entered all my information into the daily calculator but when I click on the "Evalulation" tab at the bottom where my route evalulation should be it comes up with ....
H Route #VALUE! Low Option #VALUE!
J Route #VALUE! #VALUE!
K Route #VALUE! High Option #VALUE!
                        #VALUE!
Not sure what I am doing wrong?! I checked my input values and made sure that all of the information that should be imputted is there and correct. Help!

-Thanks for your time!

-postal1998

[FrozenToes]

Are you getting totals on the Eval page for Office Time and Route Time?
Does the standard Time show the hours and minutes?

[postal1998]

Some javascript/style in this post has been disabled (why?)

Nope. I am just getting:
 

Weekly Totals (Minutes)			########	#VALUE!
Standard Time (Hours and Minutes)			#VALUE!	#VALUE!
			Hours	Minutes
		H Route	#VALUE!	Low Option	#VALUE!
		J Route	#VALUE!		#VALUE!
		K Route	#VALUE!	High Option	#VALUE!
					#VALUE!

 

---

Date: Sun, 22 Feb 2009 18:41:24 -0800
From: [hidden email]
To: [hidden email]
Subject: Re: Mail Count Calculator Instructions

Are you getting totals on the Eval page for Office Time and Route Time?
Does the standard Time show the hours and minutes?

---

This email is a reply to your post @ http://n2.nabble.com/Mail-Count-Calculator-Instructions-tp2299987p2370144.html
You can reply by email or by visting the link above.

[FrozenToes]

You could upload your spreadsheet to this thread and I can check. My first guess would be you inadvertendly
changed a formula. The formula can't resovle so it displays value.
Try downloading again.I protected the formulas so that they can't be changed.

[postal1998]

Some javascript/style in this post has been disabled (why?)

Ok Thanks. I will try to download again.
 

---

Date: Sun, 22 Feb 2009 18:52:59 -0800
From: [hidden email]
To: [hidden email]
Subject: Re: Mail Count Calculator Instructions

You could upload your spreadsheet to this thread and I can check. My first guess would be you inadvertendly
changed a formula. The formula can't resovle so it displays value.
Try downloading again.I protected the formulas so that they can't be changed.

---

This email is a reply to your post @ http://n2.nabble.com/Mail-Count-Calculator-Instructions-tp2299987p2370183.html
You can reply by email or by visting the link above.

[Awnee]

Wow now this is awesome! I finally figured out how to do this...I actually gained 30 mins for the first week but lost it when I put day 6 in...oh well hope it will get better...good luck to you all!

[postal1998]

Some javascript/style in this post has been disabled (why?)

Hello,

Just re-downloaded the "2009 Count Calculator-With Pay Calculation" for excel and re-inputted just 1 day of numbers to see if it worked and I had the same problem with it. Any other ideas of what I am doing wrong?

---

Date: Sun, 22 Feb 2009 18:52:59 -0800
From: [hidden email]
To: [hidden email]
Subject: Re: Mail Count Calculator Instructions

You could upload your spreadsheet to this thread and I can check. My first guess would be you inadvertendly
changed a formula. The formula can't resovle so it displays value.
Try downloading again.I protected the formulas so that they can't be changed.

---

This email is a reply to your post @ http://n2.nabble.com/Mail-Count-Calculator-Instructions-tp2299987p2370183.html
You can reply by email or by visting the link above.

[FrozenToes]

Could you upload the file. When you post click "More Options","Upload File",browse to find on your computer,then upload.
It seems the Mail Count page doesn't have my newest calculators. They are located in the first thread "Mail count calculators" on the first page.

[Dee]

I am having the same trouble I have downloaded the program 3 times and still the same thing.
Any reason why? don't know what else to do

[FrozenToes]

Dee are you using the appropriate program?
The Excel will only work with Microsoft Office or Excel. They will not work with Microsoft Works.
The Open Office calcs. would need Open Office.

[Dee]

I have Excel and could not get that one ot work so I downloaded the OpenOffice Program and I got that one to work
Thanks,

Just don't know why the excel one will not work?

[Dee]

In Excel I am just getting the Value and no numbers at the bottom of the evaluation page
It is not telling me what my route is

[Dee]

just like postal1998

[gjtrisa]

Could be the version of Excel you are using????

Just don't know why the excel one will not work?

 

---

Looking for work? Get job alerts, employment information, career advice and job-seeking tools at AOL Find a Job.

[FrozenToes]

What version of Excel do you have?