Re: [libreoffice-users] Additional "KSSS for an Auction" Question

On Fri, Jan 24, 2014 at 12:46 PM, Pikov Andropov <pikov22@gmail.com> wrote:

> We would like the Kingsoft Spreadsheet (KSSS) to have the following
> columns:
>
> A. Name
> B. Amount of winning bid
> C. Code for item purchased
> D. Description of item purchased
> E. Starting bid
>
> We realize that D and E can be entered (somewhere -- "lower down" in the
> spreadsheet. in another sheet, ???) as soon as the auction catalog is
> prepared, but is there any way to get KSSS to automatically enter the
> description and starting bid when the purchase is logged at the auction?
>
> If I understand, it seems the end goal is to have a spreadsheet after the
auction with rows where columns A, B, C, D, and E are completed. And items
that don't sell would have no entry in column A or B on their row.

If C, D, and E are known before the auction begins why not work directly in
the spreadsheet when buyers come to cash out? When the buyer is cashed out
search the column of item codes and put the buyer's name and winning bid
amount right in the correct row during the cash out transaction.

If E is actual starting bid vs something like minimum starting bid, then
enter A, B, and E when the buyer comes to cash out.

Seems to me this would work and produce the final output desired as part of
the cash out process. Not post production steps. If the cashiers couldn't
do the lookup and data entry then more thinking is needed.

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