Dear Laurent:
I create this easily on a regular basis in Calc, However it is not just
1 click.
I add an extra sheet at the beginning (leftmost tab) then add hyperlinks
to each of the sheets in Column B or C. Column A is a sequence number
(or a priority number) so that I can sort by arbitrary criteria.
With this I can jump to any sheet in a {ctrl-click}. This sheet can also
use added columns for items such as a total from each of the other
sheets if these sheets are, say accounts. Since the "accounts" can be
part of an ongoing inventory reconciliation, Their end results can be
in Lbs., Kg. Litres, Gallons, etc or the calculated value of the current
stock level for each, also taking account of value from different
currencies, Metric/English conversions,
Averaged unit value across multiple purchases of the same stock item,
differences in taxable status, etc. One of these applications I did was
for an industrial inventory of powdered pigments that were subject to
daily ins and outs, U.S. and Canadian currency, Metric and English
Purchasing units, and other freight -in costs.
This one was also used to do pre-production reservation of stock, so
that nobody could end up using stock that was earmarked for another
production batch.
This application later served in another application where liquids were
involved, and conversion to weight was needed.
Another such large workbook application was a sales tracker for a car
dealership. The dealership had 20 regular salesmen, each of which could
sell up to 100 cars a month. Added to that was the fleet salesman, who
could sell double that, as he was selling fleets typically to car rental
companies.
The workbook was about 25 sheets wide. 1 sheet for each salesman,
another for the fleet salesman (total 21 sheets so far), then there were
2 summary sheets at the beginning.
The sales department secretary entered all the sales data throughout the
month, as each vehicle or fleet was sold, along with the model name,
edition code for the model sold, length of the lease, profit figure for
the sale, etc.
At the end of the month, the 2 summary sheets were sorted and printed.
Each of these sheets were about 1800 lines deep, and the formulate in
most of the cells ran right off the edit line, they were so long.
When the sheets were printed, each one only printed as many lines as
there were records active, not the whole 1800 lines.
The first of these print-out takeoffs went to the sales manager so he
had a fast summary of what his sales staff were doing.
The second went to the general manager, who, as far as I know used this
to decide what cars he would order from the manufacturer for the next
business cycle. since he was financially committed to the cost of those
vehicles from the time they left the manufacturer, this made for a big
financial responsibility.
In this case, as we see, the application was serving 2 diverse sets of
needs at the same time.
My fee at the time to do that was about $CDN 365.00, although today it
would be somewhat higher.
I also have another application which related to an industry whose
production is based on a recipe by weight which may also have ongoing
experimental changes in the batch. Usually in this type of production,
the recipe is predicated on a specific final batch weight which is based
on the capacity of the mixing machinery used. When a client places an
order for a much larger quantity, another part of the workbook
calculates the total weight of each product needed for the whole order,
which then becomes the pre-reservation in the inventory as previously
mentioned.
At the point where this transition happens, any stock shortages
resulting from the calculation of the bill of materials for the client
order are then passed to the purchasing agent who obtains the added
stock needs.
The purchasing agent, on advice from the marketing dept. and with
financial executive approval, may increase the order to provide for
expected demand, possibly getting a better price in the process due to
his larger order.
Best Regard$$$
On 11/18/2010 08:22, L Duperval wrote:
Hi,
In Excel 2K3, you can right-click on the sheet navigation arrows and have
a list of all the sheets in the current workbook, so you can click on the
one you need and go there directly. It makes it easier to navigate from
one sheet to the other.
What's the equivalent in Calc?
Thanks,
L
--
Best Regards, Bruce Martin
