Mail Count Calculator Instructions

89 messages Options
Embed this post
Permalink
1 2 3 4 5
FrozenToes

Re: Mail Count Calculator Instructions

Reply Threaded More More options
Print post
Permalink
Looks like either you accidentally changed the formula or received a corrupt download. You could re download or try to change the formula
in cell F48  it should be:  =Sum(F10:F46)    
awnee

Re: Mail Count Calculator Instructions

Reply Threaded More More options
Print post
Permalink
How do you do the boxholders? We got 2 sets during the count.  How do I know what that adds up to? I usually case about 600, no more than 620 when I get them. I am sure it won't change the evaluation that much but I would like to know...thanks!
FrozenToes

Re: Mail Count Calculator Instructions

Reply Threaded More More options
Print post
Permalink
Should be you box count. So if you have 630 boxes, enter 630 for each day.
awnee

Re: Mail Count Calculator Instructions

Reply Threaded More More options
Print post
Permalink
Ok...I have 672 boxes, 21 are businesses/do not put boxholders in this box...so I figured about 620 average. So I would put 1200 for both days?  I had put only 2 in there because management said we had to scan a redplum label after delivery and it would "automatically" add the correct number in their sheets...altho I do not see how...this is confusing but I will do the 1200 on this calc and the nrlca and see what I get..thanks!
FrozenToes

Re: Mail Count Calculator Instructions

Reply Threaded More More options
Print post
Permalink
620 each day ,if you had 1 set each day.
dsrtdwlr2

Re: Mail Count Calculator Instructions

Reply Threaded More More options
Print post
Permalink
In reply to this post by Postaltexan
i sure hope the calculator is calibrated correctly because i came out pretty good.  but one thing i wonder about is that the dismounts and dismount distance came across as all 0's  sure they must give you some time for 139 dismounts and 11 thousand and some dismount feet or is that calculated in somewhere else?   thanks, dsrtdwlr2
FrozenToes

Re: Mail Count Calculator Instructions

Reply Threaded More More options
Print post
Permalink
You should get credit. You should check your data entry.
dsrtdwlr2

Re: Mail Count Calculator Instructions

Reply Threaded More More options
Print post
Permalink
thanks for taking interest in my problem..  when i input 139 dismounts in line 18 and 11,106  feet in line 19 and run the calculater i get 0's  straight across the board.  when i input what i think the items should be worth in column e..  (20 for the dismounts and 60 for the 11,106 feet)  column g pops up with .50 and .04260 respectively but the entire evaluation goes up by only 1 minute.  could the dismount distance and dismounts be figured somewhere else?  thanks,  dsrtdwlr2
FrozenToes

Re: Mail Count Calculator Instructions

Reply Threaded More More options
Print post
Permalink
Sounds like you accidentally erased a formula. On;y solution would be to download again.
1 2 3 4 5