HTMT interactive

[Eduardo Araujo]

I would like to publish an OOcalc spreadsheet adding interactive
feature, in order the users can change some contents. Does is
possible to do this using OO 3.3 ?
thanks
Eduardo

[Bruce Martin]

Dear Eduardo:

Depending on the details of what you would like to do, this should be
quite possible.

I have done spreadsheet workbooks to handle:

- Industrial chemical inventories with ongoing turnover (Weight or
Volume, English or Metric, Canadian or U.s. Dollars in combination. This
was normally used ongoing day to day to manage purchasing and stock
reserve for jobs planned for production.


- Sales tracker for an Automobile dealer: This dealer has about 20
regular salesmen and one Fleet Salesman. A regular salesman could sell
up to 100 vehicles a month. The Fleet salesman could sell up to 200, as
he was selling largely to Car rental companies during the month,
possible with some government sales.

A secretary supported the sales team full time, entering certain
specific information about each sale in the sheet related to the
salesman who sole it. e.g. Profit figure, model and type, duration of
lease, etc. and type of contract.

Each model and each type of contract had specific mnemonic codes that
were common to dealers in that brand of vehicles.

At the end of the month, only 2 of about 25 sheets were printed: One
went to the sales manager to support his keeping track of thew
performance of each salesman.

The other went to the general manager who, as far as I now used his
customized report to determine which cars he would order in the next
business cycle from the auto manufacturer - This would suggest a lot of
financial responsibility resting on that report!

The spreadsheet was then cloned for each successive month without the
input data and so the cycle repeated monthly.

- Another application was designed for industries based in a recipe
by weight with adds testing.

The initial recipe was entered with quantities designed to produce a
test batch of 50 gm. This was then made up in the lab and tested. If the
qualities desired were not exactly satisfactory, the lab would add small
snippets of one or other ingredient.

Each time the lab had to add, naturally the batch was larger than 50 gm.
Therefore the batch ingredient weights were "normalized' or proportioned
to render weights for a 50 gram batch with the modified proportions of
the ingredients. The spreadsheet would track this for up to 10 adds.

Since the mixing machine had a capacity of 50 Kg., it was easy to
multiple the normalized weights by 1000 to get a list of a production batch.

When an order came in, the requested quantity was divided by the batch
size of 50 Kg. to give the number of batches needed for the order.

In another sheet, a bill of ingredients automatically calculated the
total weight of each ingredient needed for the whole order.

In another column of this sheet, the weight of available stock for each
ingredient was pasted from the ongoing inventory, and the remaining
quantity in stock after the order was filed would be shown. In the event
that there was insufficient quantity of any ingredient, a red flag would
show to draw the stock manager's attention.

He then could arrange purchasing for the shortages.

Finally he could post a reserve quantity for any or all of the
ingredients in the inventory so that the proforma available quantities
would show. A bottom line figure for the value of inventory with or
without the reserved items would then show on the summary page.

In the summary page, each ingredient was a line, the totals being pinned
at the top.
In the column on the summary page where the product description was to
go, the descriptions were actually hyperlinks to the corresponding
detail "electronic ledger" pages, so there was no need to struggle with
the tabs in a workbook of easily 100 sheets.

Generally, in each application, the details are entered in detail pages,
and the results show on one or more summary pages, depending on how many
different report are needed to support different personnel each with
different needs.

¡La versatilidad y la complexidad son hermanos - son siempre in los
mismos lugares!


Bruce Martin,
Greater Montreal area,
Quebec
Canada.

Post by Eduardo Araujo
I would like to publish an OOcalc spreadsheet adding interactive
feature, in order the users can change some contents. Does is possible
to do this using OO 3.3 ?
thanks
Eduardo