Re: HTMT interactive

Dear Eduardo:

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

I have done spreadsheet workbooks to handle:

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


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

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

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

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

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

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

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

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

Each time the lab had to add, naturally the batch was larger than 50 gm.=20
Therefore the batch ingredient weights were "normalized' or proportioned=20
to render weights for a 50 gram batch with the modified proportions of=20
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=20
multiple the normalized weights by 1000 to get a list of a production bat=
ch.

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

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

In another column of this sheet, the weight of available stock for each=20
ingredient was pasted from the ongoing inventory, and the remaining=20
quantity in stock after the order was filed would be shown. In the event=20
that there was insufficient quantity of any ingredient, a red flag would=20
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=20
ingredients in the inventory so that the proforma available quantities=20
would show. A bottom line figure for the value of inventory with or=20
without the reserved items would then show on the summary page.

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

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

=A1La versatilidad y la complexidad son hermanos - son siempre in los=20
mismos lugares!


Bruce Martin,
Greater Montreal area,
Quebec
Canada.

On 11/5/2011 5:28 PM, Eduardo Araujo wrote:
> I would like to publish an OOcalc spreadsheet adding interactive=20
> feature, in order the users can change some contents. Does is possible=20
> to do this using OO 3.3 ?
> thanks
> Eduardo
>

--=20
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help