Not sure you've gotten answers to your questions and whether the auction has come and gone and any answer is moot.
If you still wish answers here are some suggestions I hope you might find helpful. On Fri, Feb 21, 2014 at 3:05 PM, Pikov Andropov <piko...@gmail.com> wrote: > Attendees' names and "paddle numbers" will be entered at the start of > the auction. > > The second phase is the entry of purchased item codes, winning bid > amounts and paddle numbers of winners. > > Third phase is checkout. I was thinking of copying the spreadsheet as it > existed after phase 2 to a second laptop so that people could checkout > with last-names-A-through-M going to laptop 1 and N-Z, to laptop 2. > > From your descriptions of phase 1, 2 and 3 I am presuming phases 1 and 2 are done by an individual and only phase three may be done by people working independently of one another. So one computer, one file to build the spreadsheet through phase one and two. > 2. When it's all over, how do I combine the two spreadsheets?? > > My answers to your question #2 ~~~~ If you break the spreadsheet into two pieces as you've suggested with A-M on one and N-Z on another to combine them at laptop with A-M names.. 1. make copy of A-M names spreadsheet as error insurance 2. open original A-M 3. open copy of N-Z spreadsheet on A-M computer (get copy there with thumb drive perhaps) 4. copy all rows / columns of spreadsheet N-Z 5. paste all just copied rows into spreadsheet A-M at bottom of existing data ~~~~ If you have complete spreadsheets at each computer as I've suggested at laptop with spreadsheet 1, s1... 1. make copy of s1 spreadsheet as error insurance 2. open original s1 3. open copy of spreadsheet 2, s2, on s1 computer (get copy there with thumb drive perhaps) 4. copy all rows / columns of spreadsheet s2 5. paste all just copied rows into spreadsheet s1 at bottom of existing data 6. sort spreadsheet by paddle number Presumably winning bidders will check out at only one computer. So in this case there will be two rows for each paddle number. One with purchased items codes, one without. At your convenience delete the rows that contain only paddle numbers and names. (came from the spreadsheet on the computer that the bid winner didn't check out at) Note: this presumes organization of your spreadsheet as follows... Stage 1 columns - "name", "paddle no" Stage 2 columns - "name", "paddle no", {"purch item code", "winning bid amount"}... where a paddle holder who purchases more than one item has the additional items listed on the same row as in... Stage 2 columns - "name", "paddle no", "purch item code1", "winning bid amount1","purch item code2", "winning bid amount2"... If your spreadsheet(s) have a different column configuration please advise so I may consider other options. -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