[libreoffice-users] first step forward
Hello, Just few days've gone, I had opportunity to discover your LibreOffice 4.4.1.2. I've got really impressed. Unfortunatly, there is not enough time, till now, to answer the question: Is the LO abbly, for example, to proceed efficiently a specific arrey of numbers (a kind of compilation)? I'm pretty sure, but to get forward I've attached simple sample as below. Is the spreadsheet, or rather is the database the proper tool? Could you proceed the sample, please? Best regards, Andrew Anddos -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] first step forward
Hi :) You might find this website more useful; http://pl.libreoffice.org/ Also the Polish language mailing list might be easier as you can use Polish; https://wiki.documentfoundation.org/Local_Mailing_Lists#Polish or if your main language is something else then there is probably a different mailing list for that too. I think most people use spreadsheets (ie Calc or Excel) to create an array of numbers. However if this for bookkeeping then you might find it better to use a specialist tool such as GnuCash (also "Libre" and free OpenSource program). It really depends on what you are trying to do. If you think a database might be better then using Base as a "front-end" with an "external back-end" such as MySql/MariaDb, Postgresql or something else is probably a good idea. Some people have a go with a spreadsheet first as part of the planning process before designing a database. There is a book about how to use Base but it is primarily only available in German. The English one is quite outdated now (already! Time flies!) and the translator teams are often even smaller and mostly have only just begun to think about translating the "Published Guides". Of course they do have the "built-in help" but it sounds like you really need something a bit more hefty to get a good overview. If you can find it in an appropriate language then you might like the "Getting Started Guide" Regards from Tom :) On 2 March 2015 at 23:22, wrote: > > Hello, > > Just few days've gone, I had opportunity to discover your LibreOffice > 4.4.1.2. > > I've got really impressed. Unfortunatly, there is not enough time, till > now, to answer the question: > > Is the LO abbly, for example, to proceed efficiently a specific arrey of > numbers (a kind of compilation)? > > I'm pretty sure, but to get forward I've attached simple sample as below. > > Is the spreadsheet, or rather is the database the proper tool? > > Could you proceed the sample, please? > > > > > Best regards, > > > > > Andrew Anddos > > > > > -- > To unsubscribe e-mail to: users+unsubscr...@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+unsubscr...@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
Re: [libreoffice-users] first step forward
Hi Tom, would you mind sending me the link to this book in german or is it only available in hardcopy? Thanks Ralf -- Laboratório de Biodiversidade Genética Instituto de Ciências Biológicas Universidade Federal do Rio Grande - FURG Av. Itália, s/n, Carreiros 96201-900, Rio Grande, RS - Brasil Tel.:+.55.53.3293.5128 +.55.53.3233.6742/6538 e-mail:dmbralf"at"furg.br msn:r_kersanach"at"hotmail.com skype: ralfkersanach On Tuesday 03 March 2015 17:29:26 Tom Davies wrote: > Hi :) > You might find this website more useful; > http://pl.libreoffice.org/ > > Also the Polish language mailing list might be easier as you can use > Polish; > https://wiki.documentfoundation.org/Local_Mailing_Lists#Polish > or if your main language is something else then there is probably a > different mailing list for that too. > > > > I think most people use spreadsheets (ie Calc or Excel) to create an array > of numbers. > > However if this for bookkeeping then you might find it better to use a > specialist tool such as GnuCash (also "Libre" and free OpenSource > program). > > It really depends on what you are trying to do. If you think a database > might be better then using Base as a "front-end" with an "external > back-end" such as MySql/MariaDb, Postgresql or something else is probably a > good idea. Some people have a go with a spreadsheet first as part of the > planning process before designing a database. > > There is a book about how to use Base but it is primarily only available in > German. The English one is quite outdated now (already! Time flies!) and > the translator teams are often even smaller and mostly have only just begun > to think about translating the "Published Guides". Of course they do have > the "built-in help" but it sounds like you really need something a bit more > hefty to get a good overview. If you can find it in an appropriate > language then you might like the "Getting Started Guide" > > Regards from > Tom :) > > On 2 March 2015 at 23:22, wrote: > > Hello, > > > > Just few days've gone, I had opportunity to discover your LibreOffice > > 4.4.1.2. > > > > I've got really impressed. Unfortunatly, there is not enough time, till > > now, to answer the question: > > > > Is the LO abbly, for example, to proceed efficiently a specific arrey of > > numbers (a kind of compilation)? > > > > I'm pretty sure, but to get forward I've attached simple sample as below. > > > > Is the spreadsheet, or rather is the database the proper tool? > > > > Could you proceed the sample, please? > > > > > > > > > > Best regards, > > > > > > > > > > Andrew Anddos > > > > > > > > > > -- > > To unsubscribe e-mail to: users+unsubscr...@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+unsubscr...@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
Re: [libreoffice-users] first step forward
Hi :) The link to the English translation is; https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Handbook The original in German is; https://wiki.documentfoundation.org/Documentation/de#Handbuch_f.C3.BCr_Base_.28Datenbank-Programm.29 Regards from Tom :) On 3 March 2015 at 18:40, Ralf Kersanach wrote: > Hi Tom, > > would you mind sending me the link to this book in german or is it only > available in hardcopy? > > Thanks > > Ralf > > -- > Laboratório de Biodiversidade Genética > Instituto de Ciências Biológicas > Universidade Federal do Rio Grande - FURG > Av. Itália, s/n, Carreiros > 96201-900, Rio Grande, RS - Brasil > Tel.:+.55.53.3293.5128 > +.55.53.3233.6742/6538 > e-mail:dmbralf"at"furg.br > msn:r_kersanach"at"hotmail.com > skype: ralfkersanach > On Tuesday 03 March 2015 17:29:26 Tom Davies wrote: > > Hi :) > > You might find this website more useful; > > http://pl.libreoffice.org/ > > > > Also the Polish language mailing list might be easier as you can use > > Polish; > > https://wiki.documentfoundation.org/Local_Mailing_Lists#Polish > > or if your main language is something else then there is probably a > > different mailing list for that too. > > > > > > > > I think most people use spreadsheets (ie Calc or Excel) to create an > array > > of numbers. > > > > However if this for bookkeeping then you might find it better to use a > > specialist tool such as GnuCash (also "Libre" and free OpenSource > > program). > > > > It really depends on what you are trying to do. If you think a database > > might be better then using Base as a "front-end" with an "external > > back-end" such as MySql/MariaDb, Postgresql or something else is > probably a > > good idea. Some people have a go with a spreadsheet first as part of the > > planning process before designing a database. > > > > There is a book about how to use Base but it is primarily only available > in > > German. The English one is quite outdated now (already! Time flies!) > and > > the translator teams are often even smaller and mostly have only just > begun > > to think about translating the "Published Guides". Of course they do > have > > the "built-in help" but it sounds like you really need something a bit > more > > hefty to get a good overview. If you can find it in an appropriate > > language then you might like the "Getting Started Guide" > > > > Regards from > > Tom :) > > > > On 2 March 2015 at 23:22, wrote: > > > Hello, > > > > > > Just few days've gone, I had opportunity to discover your LibreOffice > > > 4.4.1.2. > > > > > > I've got really impressed. Unfortunatly, there is not enough time, till > > > now, to answer the question: > > > > > > Is the LO abbly, for example, to proceed efficiently a specific arrey > of > > > numbers (a kind of compilation)? > > > > > > I'm pretty sure, but to get forward I've attached simple sample as > below. > > > > > > Is the spreadsheet, or rather is the database the proper tool? > > > > > > Could you proceed the sample, please? > > > > > > > > > > > > > > > Best regards, > > > > > > > > > > > > > > > Andrew Anddos > > > > > > > > > > > > > > > -- > > > To unsubscribe e-mail to: users+unsubscr...@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+unsubscr...@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+unsubscr...@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
Re: [libreoffice-users] first step forward
On Tue, Mar 3, 2015 at 8:24 AM, wrote: > Thank you, Allan for the prompt reply, ... > The sample is simply enough, I belive, so the point is how to proceed it > to get output in several seperate SS or database tables, preserving > the sequention in row position. > Unfortunately I don't understand your spreadsheet. I've added the mail list address back to the message. Please reply to mail list. That way more (and better) brains than mine can then give their feedback too. I did edit your spreadsheet and put a copy here. https://docs.google.com/spreadsheets/d/1xusCFUw5wy62IOcRJTTTfCQxtAcnyccXJuMHUilZ9T8/edit?usp=sharing In my copy I've highlighted all the number/value "pairs" and have some questions based on that. First, some numbers aren't paired with anything. What do they belong with? Second, you refer to the values as an array but, given the organization of the spreadsheet I don't see any arrays. What arrays are you referring to? Cell addresses would be helpful to understand. Regarding your question about numbers of rows and columns I believe the max number of rows is 1,000,000 and max columns is 1024. Your example for "A" target shows the one positive value for "A" in one column and the negative values for "A" in a different column. In the target the order of values by row is the same as in the source. Which gets me back to I still don't understand what you need to accomplish. Answers to a few questions may help me: - is the goal to rearrange the "Raw Alphanumerical" so it is organized like the target? - is there a specific repeatable method for why data is where it is in the "Raw Alphanumerical" and if there is what are the rules? Knowing the rules would go a long way to planning how to rearrange "Raw" into "Target" -Alan -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] first step forward
Hi Tom, many thanks for the links. Ralf -- On Tuesday 03 March 2015 23:32:21 Tom Davies wrote: > Hi :) > The link to the English translation is; > https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_B > ase_Handbook > > The original in German is; > https://wiki.documentfoundation.org/Documentation/de#Handbuch_f.C3.BCr_Base_ > .28Datenbank-Programm.29 > > Regards from > Tom :) > > On 3 March 2015 at 18:40, Ralf Kersanach wrote: > > Hi Tom, > > > > would you mind sending me the link to this book in german or is it only > > available in hardcopy? > > > > Thanks > > > > Ralf > > > > -- > > Laboratório de Biodiversidade Genética > > Instituto de Ciências Biológicas > > Universidade Federal do Rio Grande - FURG > > Av. Itália, s/n, Carreiros > > 96201-900, Rio Grande, RS - Brasil > > Tel.:+.55.53.3293.5128 > > > > +.55.53.3233.6742/6538 > > > > e-mail:dmbralf"at"furg.br > > msn:r_kersanach"at"hotmail.com > > skype: ralfkersanach > > > > On Tuesday 03 March 2015 17:29:26 Tom Davies wrote: > > > Hi :) > > > You might find this website more useful; > > > http://pl.libreoffice.org/ > > > > > > Also the Polish language mailing list might be easier as you can use > > > Polish; > > > https://wiki.documentfoundation.org/Local_Mailing_Lists#Polish > > > or if your main language is something else then there is probably a > > > different mailing list for that too. > > > > > > > > > > > > I think most people use spreadsheets (ie Calc or Excel) to create an > > > > array > > > > > of numbers. > > > > > > However if this for bookkeeping then you might find it better to use a > > > specialist tool such as GnuCash (also "Libre" and free OpenSource > > > program). > > > > > > It really depends on what you are trying to do. If you think a database > > > might be better then using Base as a "front-end" with an "external > > > back-end" such as MySql/MariaDb, Postgresql or something else is > > > > probably a > > > > > good idea. Some people have a go with a spreadsheet first as part of > > > the > > > planning process before designing a database. > > > > > > There is a book about how to use Base but it is primarily only available > > > > in > > > > > German. The English one is quite outdated now (already! Time flies!) > > > > and > > > > > the translator teams are often even smaller and mostly have only just > > > > begun > > > > > to think about translating the "Published Guides". Of course they do > > > > have > > > > > the "built-in help" but it sounds like you really need something a bit > > > > more > > > > > hefty to get a good overview. If you can find it in an appropriate > > > language then you might like the "Getting Started Guide" > > > > > > Regards from > > > Tom :) > > > > > > On 2 March 2015 at 23:22, wrote: > > > > Hello, > > > > > > > > Just few days've gone, I had opportunity to discover your LibreOffice > > > > 4.4.1.2. > > > > > > > > I've got really impressed. Unfortunatly, there is not enough time, > > > > till > > > > now, to answer the question: > > > > > > > > Is the LO abbly, for example, to proceed efficiently a specific arrey > > > > of > > > > > > numbers (a kind of compilation)? > > > > > > > > I'm pretty sure, but to get forward I've attached simple sample as > > > > below. > > > > > > Is the spreadsheet, or rather is the database the proper tool? > > > > > > > > Could you proceed the sample, please? > > > > > > > > > > > > > > > > > > > > Best regards, > > > > > > > > > > > > > > > > > > > > Andrew Anddos > > > > > > > > > > > > > > > > > > > > -- > > > > To unsubscribe e-mail to: users+unsubscr...@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+unsubscr...@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+unsubscr...@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
Re: Re: [libreoffice-users] first step forward
On Wed, Mar 4, 2015 at 5:49 AM, anddos wrote: > > I work for medicine, to be precise, as an engineer active in the human > ecosystem personal care. > It makes me very satisfied, but I have to deal with quite a range of > technological problems. > That, explains maybe that I'd rather try to get help, instead of wasting > time on my one in case > > I did edit your spreadsheet and put a copy here. > > https://docs.google.com/spreadsheets/d/1xusCFUw5wy62IOcRJTTTfCQxtAcnyccXJuMHUilZ9T8/edit?usp=sharing > In my copy I've highlighted all the number/value "pairs" and have some > questions based on that. > > First, some numbers aren't paired with anything. What do they belong with? > thay are orfans, I,ve just did not remark it > Second, you refer to the values as an array but, given the organization of > the spreadsheet I don't see any arrays. What arrays are you referring to? > Cell addresses would be helpful to understand. > the array was ment as follow: > There are severall tools, which give their output sequentially in time. > The output creates "an arrey", data are > placed in rows and columns > Regarding your question about numbers of rows and columns I believe the > max number of rows is 1,000,000 and max columns is 1024. > thank you. > The question: till know, I don't realise, it was meant spreadseet or base > table 1,000,000x1024 ? > Your example was given in a spreadsheet. My answer re: rows and columns was therefore limits for the spreadsheet. > Your example for "A" target shows the one positive value for "A" in one > column and the negative values for "A" in a different column. In the target > the order of values by row is the same as in the source. > right, it should rest as in the input "array" > Which gets me back to I still don't understand what you need to accomplish. > I belive now, to be understood, I need to accomlish it as in example for A > > Answers to a few questions may help me: > - is the goal to rearrange the "Raw Alphanumerical" so it is organized > like the target > yes, separately in files for A, B, C, etc, and additionally, if possible, > all in columns in one file > - is there a specific repeatable method for why data is where it is in the > "Raw Alphanumerical" and if there is what are the rules? Knowing the rules > would go a long way to planning how to rearrange "Raw" into "Target" > output of each tool gives specyfic array of data, there are several tools. > Tools are active in axis of time, > independently each of other, in a kind of burst of time. > I am still trying to understand the source data. Looking again at the spreadsheet I wonder does each row represent the same point in time? In other words, for row 7 events were recorded from source A and B at the same point in time. For row 9 events were recorded from source B, D and G at the same point in time. With this idea as reference my thought is to first organize the input so it is collected in one of two ways with some similar rules for both methods. First rule, no empty rows. Second rule, column A should be a time stamp for when the event happened. Method1 Column A is time stamp Column B is "A", "B", ..., "G", etc, a tag to indicate which device provided the value Column C is the value provided by the device In this method Column A may have multiple rows with the same value because multiple devices may have an event at the same time. Therefore the values in column A and column B together make each row unique. The spreadsheet can now be used as the source for a pivot table or database query that displays the data in your desired format. Method2 Column A is time stamp Column B is "A", "B", ..., "G", etc, a tag to indicate which device provided the value Column C is the value provided by the device Column D is "A", "B", ..., "G", etc, a tag to indicate which device provided the value Column E is the value provided by the device Column F repeat pattern above... This method requires data from each device, the device label and value, go into specific columns. In other words device A must always put it's values in columns B and C, device B puts its values in columns D and E, ..., device G puts its values in columns N and O, etc. As in the first method each row represents a single point in time Again the spreadsheet would be used as the source for a pivot table or database query to display the data. I think Method1 is the better way to attempt. Devices can be added and removed without considering what column the data goes in. It will always go in A, B, and C. Timestamp, Device identifier, Value. > > > Allan, sorry for shaggy english from time to time. My brain was created in > polsh, I have friends and technical > relations in the world, so I have to deal with english, russian, germen > and french. > I believe, my english part of the brain is helpfull enough, to make me be > understood with a bit of effort of yours. > :-) no worries about your English. I'm jealous of your language skills. I can only speak English,