need some help create a spreadsheet

[Cpl Ledanek]

Need some help with spreadsheet

We (wife and I) visit some senior citizens/patients for Home Healthcare.
Some days, we visit them in one day, a total of 10-20 of them.
Some days, we have to split them in groups (either days or areas, i.e. city or suburbs)

Basically, for tax purposes, we're trying to account for the distance traveled.


So, the first column would be the patient list

2nd column :Home to patient (HTP)

3rd column :Office to patient (OTP)

On the patient list, we have to account the mileage in between patient, then a total mileage at the bottom for both HTP & OTP

hope I'm making sense.

I need to print out that spread sheet also for current and future trip to be used to file next year.

advance thanks

[[XC] Lead Head]

What's the problem?

[Cpl Ledanek]

problem: I don't know how-to make them

I was told at work that, spreadsheet is the way to help me organize all these and make it readily available for next tax filing.
Easier to collect and enter the info next time we go around visiting patients.

[[XC] Lead Head]

Download LibreOffice, it's free and comes with a quite competent spreadsheet software. Cells can do math for you too.

[Cpl Ledanek]

thanks will give it a try this weekend

[Cpl Ledanek]

I gave Google Sheet a try and its easiest for me to bounce from one desktop at work, to my desktop at home.

Here's the layout I got so far


I figured out how to get the total of mileage from Home to Patient (HTP) & Office to Patient (OTP) at the bottom.

The part I'm stumped is how to get the total mileage for the end of the year, on both column.
Any idea would be greatly appreciated

[Weedsqueezer]

=sum(c1:c16)

[Reefa_Madness]

=sum(c1:c16)

Actually, I believe that the formula should read =sum(C7:C15). Since the totals go in row 16 that row would not be included within the range being added and the formula would start to sum at row #7 (the first row under the column heading "HTP) instead of starting at row #1.

To the OP, you can insert extra rows, if needed, anywhere between row 7 and 15 in the example above, and the formula would self adjust.

...and the formula for column E totals would use the same, except that you would replace the "C" in the formula with an "E".

If you also needed to add each week up so that you had totals for the year, then the simplest way would be to use a simple "=C16+C?+C??", etc where the "?" is replaced by the number of the row where your individual totals are. For example, using the example above, you would have totals at C16 and E16. Assuming that there were 3 weeks only in this "year" and you replicated the above schedule for the 3 weeks and your weekly totals for the second week were at row 35 and the third week totals were calculated at row 55, your Yearly Totals formula for column "C" would look like =C16+C35+C55 and for Column E it would be =E16+E35+E55.

There are more "refined" ways to make stuff like this, but at your comfort level, the use of the "+" along with the basic cell ID is probably the best way to go.

[Reefa_Madness]

One more thing...once you have the layout that you like and before you populate it with a bunch of data, make a generic copy of it then next year you can open the file, save it under a new name that includes Year 2015 and use it, keeping the original "intact" for future uses.

I've always kept an assortment of basic spreadsheets that only have the basic layouts and whenever I needed to start a new project I would look for a basic spreadsheet that was similar to what I needed and modified a copy for use in the new project. That saved me a ton of time over starting from scratch on every project.