In developing seating layouts for Restaurants, hotel banquest rooms, church halls, event venues, etc. The Tables & Chairs PIO makes short work of creating layouts but?
?> The count of tables and chairs has to be done by hand and not spreadsheet/worksheet.
Why? Because the PIO stores the numer of chairs as TEXT not as a number. So in a Worksheet, =(('Tables and Chairs'.'Side chairs')) for a table with 6 chairs results in a column displaying the text representation of the chair count but that cannot be added to get the total number of chairs required for the room.
Solution: Store the chair count as a number in the PIO taht is recognized as anumber in the Worksheet formulas. Ditto tables, etc.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
bclydeb
Nice tool - but?
In developing seating layouts for Restaurants, hotel banquest rooms, church halls, event venues, etc. The Tables & Chairs PIO makes short work of creating layouts but?
?> The count of tables and chairs has to be done by hand and not spreadsheet/worksheet.
Why? Because the PIO stores the numer of chairs as TEXT not as a number. So in a Worksheet, =(('Tables and Chairs'.'Side chairs')) for a table with 6 chairs results in a column displaying the text representation of the chair count but that cannot be added to get the total number of chairs required for the room.
Solution: Store the chair count as a number in the PIO taht is recognized as anumber in the Worksheet formulas. Ditto tables, etc.
Link to comment
4 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.