Re: [libreoffice-users] how to have output in table from calc data?
Hi On Sat, 2011-08-06 at 11:06 +0530, soumalya ray wrote: hi, i searched for this but since i am totally new to calc i could not even understand what to search for. i have calc sheet named students demography with the name,age,gender,wt,height,BMI,sponsored candidate or not etc.now i need to make tables for comparing the data.say the row header contains *BMI 30 BMI 30* and the column of the table contains *male female*. what is the way to have this output from the calc data? @tomdavies i am attaching a proforma of the calc sheet and the expected output. any help will be highly appreciated.thanks in advance -- Dr soumalya ray http://drsoumalya.blogspot.com drsouma...@gmail.com MBBS,MD(PGT)C.Medicine,Ex-HousePhysician(Medicine) Skype: som3776 | Twitter: @docbkp http://twitter.com/docbkp It sounds like you need to columns if statements to select the data needed. The if statement format is =if(condition=true,true statement/action,false statement/action). For example column d has the BMI data, a possible if statement is =if(d230,D2,). The execution is to determine if the value in D2 is greater than 30, if true copy the value of D2 into the cell and if false enter nothing. The last is a method so you have a column of numbers and empty cells for functions like sum, average. If you need to reference a cell on another sheet you use this notation sheetname.cell or if you are referencing cell b3 on sheet3, sheet3.b3. and in the formula =if(sheet3.b334,something,something else) If you leave the true action or more commonly the false action, the result in the cell will be TRUE or FALSE. Example, =if(b235,,a2+b2) and =if(b235,a2+b2). In the first example your answer is TRUE or a2+b2 and in the second is a2+b2 or FALSE. The TRUE and FALSE are Boolean values not characters, a common trait in spreadsheets and one that catch new users. If you want a text value you must use true and false (upper case if desired). Note also, in the second example the false clause was omitted but there must be a true clause. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@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] how to have output in table from calc data?
thanks.will try let you know On 6 August 2011 12:26, planas jsloz...@gmail.com wrote: Hi On Sat, 2011-08-06 at 11:06 +0530, soumalya ray wrote: hi, i searched for this but since i am totally new to calc i could not even understand what to search for. i have calc sheet named students demography with the name,age,gender,wt,height,BMI,sponsored candidate or not etc.now i need to make tables for comparing the data.say the row header contains *BMI 30 BMI 30* and the column of the table contains *male female*. what is the way to have this output from the calc data? @tomdavies i am attaching a proforma of the calc sheet and the expected output. any help will be highly appreciated.thanks in advance -- Dr soumalya ray http://drsoumalya.blogspot.com drsouma...@gmail.com MBBS,MD(PGT)C.Medicine,Ex-HousePhysician(Medicine) Skype: som3776 | Twitter: @docbkp http://twitter.com/docbkp It sounds like you need to columns if statements to select the data needed. The if statement format is =if(condition=true,true statement/action,false statement/action). For example column d has the BMI data, a possible if statement is =if(d230,D2,). The execution is to determine if the value in D2 is greater than 30, if true copy the value of D2 into the cell and if false enter nothing. The last is a method so you have a column of numbers and empty cells for functions like sum, average. If you need to reference a cell on another sheet you use this notation sheetname.cell or if you are referencing cell b3 on sheet3, sheet3.b3. and in the formula =if(sheet3.b334,something,something else) If you leave the true action or more commonly the false action, the result in the cell will be TRUE or FALSE. Example, =if(b235,,a2+b2) and =if(b235,a2+b2). In the first example your answer is TRUE or a2+b2 and in the second is a2+b2 or FALSE. The TRUE and FALSE are Boolean values not characters, a common trait in spreadsheets and one that catch new users. If you want a text value you must use true and false (upper case if desired). Note also, in the second example the false clause was omitted but there must be a true clause. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@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 -- Dr soumalya ray http://drsoumalya.blogspot.com drsouma...@gmail.com MBBS,MD(PGT)C.Medicine,Ex-HousePhysician(Medicine) Skype: som3776 | Twitter: @docbkp http://twitter.com/docbkp -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] how to have output in table from calc data?
hi, i searched for this but since i am totally new to calc i could not even understand what to search for. i have calc sheet named students demography with the name,age,gender,wt,height,BMI,sponsored candidate or not etc.now i need to make tables for comparing the data.say the row header contains *BMI 30 BMI 30* and the column of the table contains *male female*. what is the way to have this output from the calc data? @tomdavies i am attaching a proforma of the calc sheet and the expected output. any help will be highly appreciated.thanks in advance -- Dr soumalya ray http://drsoumalya.blogspot.com drsouma...@gmail.com MBBS,MD(PGT)C.Medicine,Ex-HousePhysician(Medicine) Skype: som3776 | Twitter: @docbkp http://twitter.com/docbkp -- For unsubscribe instructions e-mail to: users+h...@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