Fees calculator sheet

[Viridis1886]

For those that meet one/all of the following criteria...
1. Hate maths
2. Can't keep track of the fee rates and mileages
3. Love a spreadsheet

Read the 'Read me' tab.
Enter your fee and mileage rates.
Click the drop-down box.
Enter your mileage.
Bingo.
Sit back with a beer.

Some will find it easier to just pull out the calculator, but if like me you cover a few leagues and age groups you might find it useful.

 

[Kref]

For those that meet one/all of the following criteria...
1. Hate maths
2. Can't keep track of the fee rates and mileages
3. Love a spreadsheet

Read the 'Read me' tab.
Enter your fee and mileage rates.
Click the drop-down box.
Enter your mileage.
Bingo.
Sit back with a beer.

Some will find it easier to just pull out the calculator, but if like me you cover a few leagues and age groups you might find it useful.

Wow Im getting scammed I getting paid £25 for OA and 40p/m.

 

[Viridis1886]

I can't help that. I just do the maths!

It was £25 last season and 35p/m

 

[JamesL]

I think I like this, I might incorporate it into my spreadsheet I keep.
The only issue I have is unusually knock off the odd pence and Round down, so I'd still have to manually enter what I received otherwise would end up paying more tax.
Although I am quite sure excel could deal with that anyway
Nice idea

 

[Quarryref]

Although I am quite sure excel could deal with that anyway

FLOOR function does that