Mail Count Calculators

[FrozenToes]

The formula is 2 mins. for each. remember the calculator is a "running evaluation" so it bases the office and route times on weekly averages not what you actually have. So If you had 2 parcel pickups in 4 days the calculator will go 2 divided by 4 times 6 = average of 3 a week. Then it takes 3 times the time standards.
So on the Eval. page it will show a total of 2 picked up ( I left it this way so you can check totals). But the office and route time would have 6 min. in each column ( gives the apperance of 3 min. each) because this is what the route is averaging at this point for a weekly evaluation.

[havinfun]

I think that the boxes for L and nonL are reversed on the calculator maybe check on this PT

[FrozenToes]

I don't see a problem. Which spreadsheet are you using?
Regular Boxes are entered in cell B3
L route boxes are entered in cell C3
Eval. refers to appropriate cell, then multiplied by respective time standard ( 2 min. for Reg., 1.82 min. for L )

[RCAtoo]

OK, I downloaded the Open Office version and entered my numbers. I got a total just below my current evaluation. My supervisor handed out printouts of the same spreadsheets to each route (as an idea where the routes might be after week one, nothing official), and her total is eight hours lower than mine. I've checked all the route information and all the numbers, everything matches. On her 'Evaluation' page, the first two columns show the formulas, not the numbers. The only numbers on that page are Office time and Route time, and then the totals. Does that mean her calculator is wrong, and mine is correct? I didn't ask where she got it. It's a BIG difference on her totals. I ran week one for another carrier, and the Open Office calculator shows he's down about two hours. Her totals show him down 12 hours! Any ideas that might help to calm the panic in our office?!? Thanks.

[FrozenToes]

I've used my calculators for 8 years and never had a problem. Checking the numbers is the right thing to do. Are you checking the same time period ( 1 week, not 9 days)? In my experience the Postal Calcs. aren't right until the end of count because of data that needs to be entered . It will not do a "Running Evaluation". The time showing up in the Office and Route time , are they the same? What about the totals?
Last thing , if you enter loading and " R " time wrong, it will mess up your eval.( Make it high)
You have to enter all time entries as HH:MM:SS. So 10 minutes 51 seconds would be 00:10:51 NOT 10:51.That would be quite a difference.
As a last resort you could figure manually to check.

[Sarah]

Hey P.T.-

I put my Y in mail withdrawal-it hasn't or maybe doesn't transfer over to the evaluation page. Not sure if it's me or something wrong in the formula?

Thanks for all you do for all of us!!

[FrozenToes]

If you using any of the calculators except the weekly, you enter Yes or No. Make sure to capitalize the first letter in whatever word your using.

[RCAtoo]

Now I'm thinking that her calculator wasn't doing the running total. The numbers on the Week 1&2 page are exactly the same, times in proper format, and the Total line under each box matches, all route information is the same. Without the numbers in the first two columns on her Evaluation page, I can't tell what numbers/averages were used to calculate the times. The times for random letters, DPS, and flats are the biggest difference, her totals are way below mine, so it must not have calculated based on all the entries. Your calculator shows my route just under evaluation for the first week, and that matches the amount of mail that came through. I know it wasn't eight hours lighter! I'll tell the other carriers to download this calculator and run their own numbers, her totals probably won't be correct until the last day is entered. Thanks for making this calculator available, and helping me figure this out!

[TMF]

Can anyone tell me why the calculator, at the bottom of the evalution sheet, in the standard time place mine says "#VALUE!"  It says that in a lot of places, can anyone tell me what I need to do to get it to calculate? It also says "ENTER#" in the lock pouch slot. (in red print) and "undetermind" in the DPS flats slot.. Can anyone help? thanks

[FrozenToes]

To resolve the calculation just put 0 in the locked pouch spot where it says Enter.
I did update the calculator if you just want to download it again.

[Postal]

I just ran my numbers on this wedsite I'm 47K, but on NRLCA I'm 42K.  I'm confused!!!!!!!!!!!!!!!!

[FrozenToes]

Did you change the number of weeks on the NRLCA's calc. It is set at 4 weeks. You need to change it to the right number. ( # days enterd divided by 6 ). It's on the top right.

[RC005]

I'm setting up my calculator for the upcoming 2 weeks by putting in the basics ie boxes miles etc. When I try to put in the Yes for Withdrawal it tells me that it's a protected cell. Is it programmed to carry it over from the last two week? Thanks

[FrozenToes]

Yes
Only fill out route info on page "4241 weeks 1 & 2"

[Queen B]

Hi. I have one Question: Am I doing something wrong or am I just getting screwed???? I've been putting my numbers daily into your calculator and so far with every day that passes by I'm loosing an average of about one hour. I started as a 45K the first two days of the count and now after two weeks I'm down to a 45J....Are you kidding me?? I've checked and double checked and all the numbers are right, i've filled out everything on the sheet just as it asked so what am I doing wrong. I've given this website info to other carriers in my PO and they did it and came back as 43K's or 44K's after the two weeks. I don't feel that they're getting much more mail than me, not to make such a significant difference anyway....Please help, Is it human error or is anybody else experiencing this dramatic drop in volume? Oh, by the way, these other people just downloaded the Calculator over the weekend and i've had it since day one. Has it been upgraded and should I Redownload the Calculator?

[FrozenToes]

I did update a couple calculators. I would download again. Sorry for the trouble.One wrong entry could mess it up. Did you do time entries right HH:MM:SS ? Did you answer Yes or No to withdrawel an USPS vehicle?

[Queen B]

But would it really make such a significant difference?

[FrozenToes]

Which calc. are you using? If route was under 22.22 miles with USPS vehile 30 min. difference.

[Queen B]

Ok. I just did what you suggested and after enetring all the same data i came out a 40K. That's a little better but still a far cry from where I wanna be!!! Thanks for your help!

[kathy webb]

I want george back Ican't get any of the calulators to work I've tried what you said and doesn't work maybe you can talk me like a lst grader and maybe I can figure it out. The postmaster can't do it at work it won't let me. I'm down 4,000 letters for 2 weeks sounds like not a pretty picture. Not holding mail huh. and pigs can fly.