Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I create an xls for an OTR driver including trips and fees?
My husband is an over the road truck driver, I am in need of a spread sheet
that can keep track of his mileage, load total, fees acrued, places of travel from pick-up to delivery with drop sites, etc. I am at a loss of how to achieve this as there are so many variables and was wondering if there are any templates for anything similar to our needs. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I create an xls for an OTR driver including trips and fees?
That doesn't seem like many variables to me, and it seems that you just need
all of those attributes as column headings, and then each row defines one trip. From your description I was not sure if one trip could include many places of travel, many pick-up and so, which might mean that you just repeat the previous row and change the variable. Of course, the real hearty of the matter is getting information out of that list, it might just be a simple pivot table, it might be a more complex table analysis. Can you give an example of the data that you might want to capture and the information you want to produce from said data? -- HTH Bob "wolfchild" wrote in message ... My husband is an over the road truck driver, I am in need of a spread sheet that can keep track of his mileage, load total, fees acrued, places of travel from pick-up to delivery with drop sites, etc. I am at a loss of how to achieve this as there are so many variables and was wondering if there are any templates for anything similar to our needs. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I create an xls for an OTR driver including trips and fees?
See if any of these templates will do the trick.
You can always alter them to suit. http://office.microsoft.com/en-us/te...+log&av=TPL000 Gord Dibben MS Excel MVP On Thu, 18 Mar 2010 09:50:01 -0700, wolfchild wrote: My husband is an over the road truck driver, I am in need of a spread sheet that can keep track of his mileage, load total, fees acrued, places of travel from pick-up to delivery with drop sites, etc. I am at a loss of how to achieve this as there are so many variables and was wondering if there are any templates for anything similar to our needs. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to install two video adapter driver using the same WDDM driver? | New Users to Excel | |||
Postscript driver won't print rows that the PCL driver will | Excel Discussion (Misc queries) | |||
Financial Loan calc including monthly fees | Excel Discussion (Misc queries) | |||
How to create a link including all formatting from origin cell? | Excel Worksheet Functions | |||
Create Excel through XSL including image | Excel Discussion (Misc queries) |