Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index

Hi :)
Your email only got to me off-list but doesn't appear to have anything
confidential so i'm forwarding it back to the mailing list.
Annoyingly this mailing list now needs people to use "Reply to all" or
"Group Reply" rather than just "Reply" otherwise the list doesn't see
the responses and that means there is no-one to check on quality and
no-one else to jump in when they realise something useful worth

I've no idea about packages/programs designed for assessing insurance
values (errr, or whatever the task is for).  Given my lack of
knowledge of the insurance industry i would go with GnuCash or i might
try to make a "relational database" in Base.

However since this is a "one off" task it might be easier to use
spreadsheets, this time.  I think some sort of copy&pasting between
sheets or formulae such as (in cell A1 on sheet 3 (as an example);
to pull in the value from sheet 2.  You might do some operations on
that figure or include it in a formula.

This guide might help you get to grips with spreadsheets

Regards from
Tom :)

On 17 January 2014 23:58, Ed Konopki <> wrote:
Hi Tom,
Thanks for the quick response.
I am actually in the insurance business and the formula I'm trying to create
is for a particular type of coverage that has three variables as a part of
the equation that I have to put in the formula.
Those variables are on three different spread sheets.
It is not for a website, it is for my own personal use...just trying to
shorten the time it takes to quote a policy.

I used the idea of a retail product because it seemed like a similar
I like your idea of trying to use an already created program, although I
can't think of where I'd get one.

-----Original Message-----
From: Tom Davies []
Sent: Friday, January 17, 2014 3:30 PM
To: Ed Konopki
Subject: Re: [libreoffice-users] (libreoffice-users) access data fron 2nd
spreadsheet to use on 1st spreadsheet

Hi :)
Sounds like you are designing a "relational database"!!  An "off the peg"
program made by someone else might be a MUCH easier way to get the results
you want.

Is this for a web-site?  If so there might be an option "e-commerce"
plug-in that might make all this much easier.  What are you using to build
your website?  Joomla/Drupal or WordPress or ...?

If it's for a shop or for invoicing then you might like "GnuCash", kinda
like Sage but it's a free accountancy/personal-finances package There are other Free programs that are more focused
at one end of the scale or the other but GnuCash covers a reasonable range
of "scale of enterprise".

If you let us know whether it's for a computer in a shop or for "e-commerce"
through a web-site then we might be able to suggest a few alternatives.
Regard from
Tom :)

On 17 January 2014 19:28, Ed Konopki <> wrote:

I have created a spreadsheet which is basically a formula sheet for
taking wholesale items then adding profit/commission to it adding to
it a per user
multiplier(50 different multipliers in all)  to come to a retail number.

Currently I have the formula which works perfectly fine, but

.        The different products are listed on their own spreadsheet - so I
have to go to that paper & get the product number and find the
associated price for that product  and manually enter it in my formula

.        Then I have to go to a different spread sheet to find the zip
for the user and the multiplier for that user and manually enter it in
to my formula sheet.

Is there any way I can design the "Formula" spreadsheet to access
spreadsheet # 2 cell information and when I type in the user number
the spreadsheet will automatically insert the correct multiplier??

The same with spreadsheet #3 simply type in the zip code  and
comes the correct multiplier to my formula??

As you can tell I'm new to spreadsheets and computers in general,
thanks in advance for your help and patience.


To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.