Application of Speadsheet

users
#1

At my wife's church auction, they are going to use a spreadsheet (as
long suffering readers already know :-)).

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.

1. Does that make more sense than dividing them by paddle number?

2. When it's all over, how do I combine the two spreadsheets??

Thanks.

#2

The first thing that stood out to me is phase 3. Why not have the entire
spreadsheet on both laptops?

I ask because I can't imagine everybody always going to the correct queue.
So why not support them even if they show up in the wrong place? The other
scenario that came to mind is one queue is busy. So, my process suggestion.

-Alan

#3

That would require Internet access, something the church doesn't have.

#4

I thought I said that after phase 2, the spreadsheet would be copied to a second computer.

I thought that dividing the way I mentioned would make merging easier.

#5

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.

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.