RE: [libreoffice-users] (libreoffice-users) access data fron 2nd spreadsheet to use on 1st spreadsheet

Thank You for  your help!


-----Original Message-----
From: Tom Davies [mailto:tomcecf@gmail.com] 
Sent: Saturday, January 18, 2014 6:52 AM
To: Ed Konopki; users@global.libreoffice.org
Subject: Re: [libreoffice-users] (libreoffice-users) access data fron 2nd
spreadsheet to use on 1st spreadsheet

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 adding.

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);
=Sheet2.A1
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
https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_C
alc_Guide

Regards from
Tom :)





On 17 January 2014 23:58, Ed Konopki <eddort@ptd.net> 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 
> process.
> I like your idea of trying to use an already created program, although 
> I can't think of where I'd get one.
> Thanks
> Ed
>
> -----Original Message-----
> From: Tom Davies [mailto:tomcecf@gmail.com]
> Sent: Friday, January 17, 2014 3:30 PM
> To: Ed Konopki
> Cc: users@global.libreoffice.org
> 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 
> http://www.gnucash.org/ 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 <eddort@ptd.net> wrote:
> > Help!
> >
> > 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 spreadsheet
> >
> > .        Then I have to go to a different spread sheet to find the zip
> code
> > 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 
> > bingo.in 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.
> >
> > Ed
> >
> >
> >
> >
> >
> >
> >
> >
> > --
> > To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> > Problems?
> > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > Posting guidelines + more:
> > http://wiki.documentfoundation.org/Netiquette
> > List archive: http://listarchives.libreoffice.org/global/users/
> > All messages sent to this list will be publicly archived and cannot 
> > be deleted
>
> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: 
> http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be 
> deleted


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted