I also have a file called 1995Astro.xls. In it are three sheets. Sheet #1 is called "Miles per Gallon" where I record not only the average miles per gallon, but also the low and high mpg also, as well as the low, average and high; $ amount per gallon, total $ spent per fill, mileage per fill, gallons used, cost per mile, days between fills. Sheet #2 is called "Mileage Expense" where I record Business, Volunteer and Medical mileage for income tax deductions. Sheet #3 is called "Repair & Maintenance" wher I recird the entir R&M history of the vehicle.
I also have a file called Organizer.xls which, as John stated as an example, 1 sheet is for schedule A detail, Sheet #2 is for form 8829 detail, another sheet is for educational expenses. As John said, you can specify each sheet to print separately if you want. What I like so much about OO Calc being so M$ Excel compatable, is that I use ATX as my income tax software. You can create a Calc sheet as an Excel sheet, import it directly into whatever tax return you're working on, and even link it to other tax forms. Say you're tracking stock investments, or IRA activity history, or Mutual Fund Investments, or whatever. Can you tell what I do? Greg --- John Viestenz <[EMAIL PROTECTED]> wrote: > > ----- Original Message ----- > From: "Pete Holsberg" <[EMAIL PROTECTED]> > To: "OO" <[email protected]> > Sent: Saturday, December 10, 2005 2:50 PM > Subject: [users] Very Basic Calc Question > > > > What is the purpose of having "sheets"? > > > > I'm trying to convince a neighbor to switch from > Microsoft Works to OOo > > and I'm confused by what he says: "Sheets in Excel > however do not work > > that way, they are used to interact with each > other, not as simple page > > breaks." > > > > He likes Works because he can insert page breaks, > he says. > > > > When you have a spreadsheet with multiple sheets > in Calc, can't you p > > print each sheet separately? > > > > Thanks. > > -- > > Pete Holsberg > > Columbus, NJ > > Hi Pete; > As I recall, "Works" is flat. That is, it is > limited to just one sheet per > workbook. (Maybe I'm, wrong; have not looked at > Works in quite awhile). > Anyway, the advantage of having multiple sheets all > in one workbook is that > you can do things in an additional dimension, if > needed. For example, > similar worksheets for each month. Or worksheets > for all the various income > tax schedules (one sheet for 1040, one for Schedule > A, one for Schedule B, > etc). With all the sheets in the same workbook, it > is very easy to keep > your data together, and link formulas from one sheet > to another. Or, you > can easily format some sheets for whatever details > you are collecting (save > Revenue), format a separate sheet for other details > (say, Expenses), and > create various reports and summaries on still other > sheets. > > I couldn't survive without this capability! > > Multiple sheets can, but do not have to, interact. > Each sheet could just be > a separate, unrelated, worksheet. > > As for printing page breaks, it does not matter > whether you have just one > sheet or many sheets, you can define your print > ranges and breaks. So, yes, > you can print each sheet separately. > If you don't want to use more than one sheet, you > can of course just delete > all the rest and work with only one. > > -- John Viestenz > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
