Mail Count Calculator Instructions

[Postaltexan]

Grammy,

Make sure you input the time format like this

Say you need to input 4 minutes and 29 seconds

You have to do this

00:04:29

Entering the times in a different format will skew the numbers big time...

On Thu, Mar 5, 2009 at 9:26 PM, Grammy (via Nabble) - No Reply <[hidden email]> wrote:

Help ! I can't get line 16 & 17 to add up right.
tried hh:mm:ss  will not total correct. comes up like 109 hrs or 0

Be sure and visit my website!!

http://ruralinfo.net

[FrozenToes]

If you entered the time correctly, it is all right. The 109 in the total box is 109 minutes. The total box shows mmm:ss. So if you had 3 hours 29 minutes 34 sec., the total would be 109:34 .

[Nicole]

First off. Thanks for putting these calculators together for us. I did have trouble with my time. I was putting it in wrong and after reading this thread I've figured it out and got my evaluation. So far I've lost an hour.

[glenda barfield]

how do i make this page clear

[FrozenToes]

Are you asking for the directions to be clear?
I don't think they can.
If that calculator seems daunting try the simplified. It still lets you enter daily and still gives you an evaluation.
Make sure you fill out row with route info.Enter time as HH:MM:SS

[kathy webb]

the form came up butI can't type anything in on the clasic form

[FrozenToes]

You need to download the calculator .Opening from the website, it's only read only.

[RC07]

Hi.. I redownloaded everything and like you mine was showing the same result. Have you already figure out what to do with it? I have open office. Everything is protected though.

[FrozenToes]

Only the cells with formulas/text are protected. The  cells where you enter data are not protected. It will show that result until you enter data. If you want to unprotect sheet ( at risk of changing formulas) the password is rural.

[FrozenToes]

Did you download w/pay? Are you trying to enter data on Evaluation page? You enter data on 4241s. Look at tabs at bottom of spreadsheet. If you can't see all of the tabs,use arrows on bottom left until the tabs are visible.

[postal1998]

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

I ended up downloading the OpenOffice version and seemed as though everting worked fine. I also believe that the Excel version was fixed, but not sure....
 

 

---

Date: Mon, 9 Mar 2009 20:54:30 -0700
From: [hidden email]
To: [hidden email]
Subject: Re: Mail Count Calculator Instructions

Hi.. I redownloaded everything and like you mine was showing the same result. Have you already figure out what to do with it? I have open office. Everything is protected though.

---

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

[Grammy]

Thanks PT. I did finally get that right but new question for you.
Under the data description 16 & 17 ---the allowance factors are for (16) 98 and for (17) 113, they are coming out under office time as follows under (16) as 28 and (17) as 32.
This is not correct is it? Shouldn't they both be the same? Thanks for your help.

[FrozenToes]

The first numbers 98 & 113 are your totals for count ( so you can check accuracy with your PM). Remember you evaluation is based on an average week for your route. So the times you are seeing 28 & 32 are your average times for a weekly evaluation.


You are averaging 4 minutes 40 seconds a day Loading time
You are averaging 5 minutes 20 seconds a day "R" time

[help rr5]

On column 26 are they suppose to list all the return receipts for our certifieds? We are all L routes in our office and none of us have any time there. We do not use firm books?

[FrozenToes]

Only if you are a " L " route and use a firm book. So you wouldn't get that credit.

[awnee]

Hello...is there supposed to be anything in the strapping out column? Is that something that is automatically added in or what exactly is that? thanks

[FrozenToes]

The calcs. Posted here will auto calculate strapping out.

[awnee]

Oh thank you! I was about to burst into tears because I accidentally deleted it and then could not remember if it was supposed to be there or not...I would be about a 45H not a barely 43K! Thanks! I will have to redo the whole thing but that's ok! thanks!

[FrozenToes]

If you're using the w/pay it should show a total on the Evaluation page. If not,you might need to re download the calc.( might have deleted formula).

[C0URTNIE]

I think I have entered everything pretty correctly, but on the evaluation sheet where the weekly totals and standard time are supose to show it has all calculations *of:=SUM([.F10:.F46])* information still....... why isn't it changing?