I was helping my bartender friend with a spreadsheet for his per-bottle profits, and it would have been so much simpler if we could have named the columns after each liquor, and the rows for their wholesale-cost, serving-size, bottle-size, serving-charge, etc.
You'd probably need a way to override it to allow certain individual cells to have a unique name, though - constants if you will.
Constants should be in a separate sheet named 'config', 'constants', or the like. Alternatively, in Excel, one can define names with values that aren't stored in a cell (one can enter 42 or sin(d3) in the text box where one can edit name values in the 'Name Manager'h
Disadvantage is that such constants won't be visible when looking at formulas in other sheets. That's why Apple's Numbers spreadsheet allows for multiple tables in a sheet.
I was helping my bartender friend with a spreadsheet for his per-bottle profits, and it would have been so much simpler if we could have named the columns after each liquor, and the rows for their wholesale-cost, serving-size, bottle-size, serving-charge, etc.
You can do that with Excel 2007+ with tables, which are probably one of the best improvements in Excel in a long time, and underused because so many Excel users have spent so much time learning how to work without them they failed to notice that it was no longer necessary, and that the most common Excel use cases had just gotten much easier.
Comments
I was helping my bartender friend with a spreadsheet for his per-bottle profits, and it would have been so much simpler if we could have named the columns after each liquor, and the rows for their wholesale-cost, serving-size, bottle-size, serving-charge, etc.
You'd probably need a way to override it to allow certain individual cells to have a unique name, though - constants if you will.
Constants should be in a separate sheet named 'config', 'constants', or the like. Alternatively, in Excel, one can define names with values that aren't stored in a cell (one can enter 42 or sin(d3) in the text box where one can edit name values in the 'Name Manager'h
Disadvantage is that such constants won't be visible when looking at formulas in other sheets. That's why Apple's Numbers spreadsheet allows for multiple tables in a sheet.
Excel's solution for that problem is he table (http://office.microsoft.com/en-001/excel-help/overview-of-ex...) if you are willing to transpose rows and columns, theta might come close to what you want.
You can do that with Excel 2007+ with tables, which are probably one of the best improvements in Excel in a long time, and underused because so many Excel users have spent so much time learning how to work without them they failed to notice that it was no longer necessary, and that the most common Excel use cases had just gotten much easier.