Travel Expense Claim Form

I have a couple of questions about the form.
-Time away from HQ can be computed and this could be used for column J.
-Return Journey - do you allow for one-way trips? How do you want to compute them?
-Substance Category is lookup but the cells are not shaded green. I see you also allow a blank entry
-Subsistence Amount could possibly be looked up from the table, but then you wont be able to enter in a "free" value - the kind of validation you have on this cell doesn't allow for free entry anyway. You could change this to give the user a message that they are entering in a non-standard amount and still accept it.

By mileage, I assume you mean money paid out for the trip, not linear distance

I can see that the bands are computed in km. Just to confirm the first 1,500 km is paid out at 39.86 per km and km number 1501 is paid out at 73.21? The way I read the text, the mileage is based on cumulative per year.

I'm probably going to have to add some helper columns (that may be hidden) to keep a running total and also separate mileage or kilometerage into "buckets" to apply the different rates. The rate structure looks funny to me in that it goes up and then comes back down, but I guess you know what you are doing.

How does this work out? Does a person each have his own spreadsheet and fills it out and then sends it to you? Do you need to consolidate the data?

Now for a question that has nothing to do with the post. Have you been in Jordan's? - next time say hi to Kate (my wife's sister) and Andy.


-

Pl see file Slight changes are done in Data sheet for Formula.
ARRAY formula in L13 then copied down In January sheet

Please Login or Register  to view this content.

Similarly for other sheet.