POS Spreadsheet for a coffee business

[david.paton]

Hi,

I need to make a spreadsheet for a business that sells coffees. The owner wants to be able to enter the information into an ipad on the fly so that he does not have to enter all the information at the end of the day.

I have a spreadsheet with the options for the coffees in a drop down menu. There are 4 other drop down menus, with one of them being size, which determines the cost, small is $3.50, medium is $4 and large is $4.50. The other drop down menus are for the owner to remember what was in each coffee. There is one of the drop down menus that has options that can add an additional cost to the total for the coffee.

Any ideas on the best formula I could accomplish this with?

Thanks,
David

 

[Ranman256]

This is actually a database and not really good for a spreadsheet.
Couldn't this data be collected from the 'register' using the POS app?

BUT you may be able to simulate a POS sale screen using an excel FORM and vb code.
The form would need:
Product table
Price table
AddIn table
Order table,
OrderDetail table.

The form would simulate a web site Shopping cart,
Dbl-click a product
Pick size,
And dbl-click Addins.

All this would produce an Order, to be charged and paid.

 

[david.paton]

I thought it would be a database but how could I make a database for the ipad, as Access won't run on the ipad?

 

[Rx_]

Access won't run on Apple. But the new small business Citrix would allow Access to run on just about any platform over the Internet. It is most likely more than a small coffee shop owner wants to do.

For a POS, it would be possible to just enter data in a spreadsheet then send that spreadsheet to a PC where Access could consume the formatted data with automation. Basically, put the spreadsheet of a specific format into a specific folder then have Access import the data and append it into a table.

 

[plog]

Do you mean Ipad as the product from Apple? Or ipad as a generic name for a tablet?

I have a few thoughts on how to accomplish this:

1. Use an android device and Google Docs. That allows you to build the spreadsheet which you seem comfortable with.

2. Make this a web app. Use HTML/MySQL to capture the data via a browser.

3. Stick with pen and paper and enter the data at the end of the day. I would design a spreadsheet like form where he can quickly circle options for orders. Then at the end of the day or during free time he can then enter them into an actual spreadsheet.

 

[Rx_]

That is a better idea, use the web version of a spreadsheet.
I seem to remember a post somewhere that we discussed how to connect a google doc into Access.