Crafty bugs Download this workbook for planning an arts and crafts show. You tel
ID: 3852256 • Letter: C
Question
Crafty bugs
Download this workbook for planning an arts and crafts show. You tell it how many small exhibits and large exhibits will be in the show, and it will tell you how many of these you’ll need:
Tables
Table cloths
Table sign holder
Chairs
Power strips
It’s supposed to use these rules:
Each large exhibit gets its own table. Each small exhibit gets half a table, so two small exhibits share one table. Plus three tables for the ticket counter. Round the total up. So if you need 14.5 tables, round up to 15.
One table cloth for each table.
One table sign holder for each exhibit, and one for the ticket counter.
One chair for each small exhibit, two for each large exhibit, four for the ticket counter, and four extras.
There’s a power strip for each two exhibit tables. Round up. Plus two for the ticket counter, and two spares.
Here’s an example of the correct output:
Option Explicit
Private Sub cmdRun_Click()
Dim largeExhibits As Integer
Dim smallExhibits As Integer
Dim tables As Integer
Dim tableCloths As Integer
Dim tableSignHolders As Integer
Dim chairs As Integer
Dim powerStrips As Integer
largeExhibits = Cells(3, 2)
smallExhibits = Cells(4, 2)
tables = Round(smallExhibits / 2 + largeExhibits) + 3
tableCloths = tables
tableSignHolders = largeExhibits + smallExhibits + 1
chairs = smallExhibits + largeExhibits * 2 + 8
powerStrips = Round(tables / 2) + 4
Cells(7, 2) = tables
Cells(8, 2) = tableCloths
Cells(9, 2) = tableSignHolders
Cells(10, 2) = chairs
Cells(11, 2) = powerStrips
End Sub
Explanation / Answer
Answer for the given question:
Here in the given code you need to declare the cells and Round parameters these are inaceesible to given code. if you taken care about those parameters declartions it will be solve.