Dream Room Floor Plan (budgeting and Microsoft Excel)

If you could have any room, with no money limit, what would your room look like? If you were constrained to a budget, how would your room change? Use Microsoft Excel, create a blue print depicting what your dream room would look like.

Step 1: Step 1: Dream Room Furniture

Using Google or any other appropriate sites (Walmart, Kmart, Ikea, Mealy’s, The Dump….) choose the furniture you prefer. DOCUMENT UNIT OF MEASUREMENT

Bed: Cost_______________

Length______________Width________________ Height_____________

Night Table: Cost_______________

Length______________Width________________ Height_____________

Desk: Cost_______________

Length______________Width________________ Height_____________

Chair: Cost_______________

Length______________Width________________ Height_____________

Wall Closet: Length_______________ Width______________ Height____________

Drawers: Cost_________________

Length______________Width________________ Height_____________

________________(furniture of your choosing): Cost_________________

Length______________Width________________ Height_____________

________________(furniture of your choosing): Cost_________________

Length______________Width________________ Height_____________

________________(furniture of your choosing): Cost_________________

Length______________Width________________ Height_____________

Bed linens: Cost_______________

Mattress: Cost_______________

Lamp: Cost_______________

Blinds: Cost_______________

________________(decoration of your choosing): Cost_________________

Step 2: Step 2: Furniture on a Budget

The number in the parenthesis is the maximum amount of money you can spend on each item. Use Google or any other appropriate sites (Walmart, Kmart, Ikea, Mealy’s, The Dump….) choose the furniture you prefer. DOCUMENT UNIT OF MEASUREMENT

Bed ($150) Cost_______________

Length______________Width________________ Height_____________

Night Table ($30) Cost_______________

Length______________Width________________ Height_____________

Desk ($50) Cost_______________

Length______________Width________________ Height_____________

Chair ($40) Cost_______________

Length______________Width________________ Height_____________

Wall Closet

Length_______________ Width______________ Height____________

Drawers ($140) Cost_______________

Length______________Width________________ Height_____________

_______________ ($150) Cost_________________

Length______________Width________________ Height_____________

________________ ($150) Cost_________________

Length______________Width________________ Height_____________

________________($150) Cost_________________

Length______________Width________________ Height_____________

Bed linens ($60) Cost_______________

Mattress ($200) Cost_______________

One lamp ($20) Cost_______________

Blinds ($30) Cost_______________

________________ ($50) Cost_________________

Step 3: Step 3: Calculating Cost

Open up Microsoft Excel and create a new workbook. Rename 'sheet 1' Cost

1. Cell A1 type Furniture
B1 type Dream Cost
C1 type Budget Cost
D1 type Difference

2. Cell A2 type Bed
A3 type Night Table
A4 type Desk
A5 type Chair
A6 type Drawers
A7 furniture you choose or leave blank
A8 furniture you choose or leave blank
A9 furniture you choose or leave blank
A10 type Bed Linens
A11 type Mattress
A12 type Lamp
A13 type Blinds
A14 decoration you choose or leave blank
A15 decoration you choose or leave blank
A16 decoration you choose or leave blank
A17 type in Total

3. In column B enter the cost of each piece of furniture you selected for your Dream Room

4. In column C enter the cost of each piece of furniture you selected for your Budgeted Room

5. In D2 type =B2-C2 then hit the enter key

6. Place your mouse at the right corner of cell D2 until your mouse turns into a back plus sign

7. Click and drag your mouse to D16 then let go. This is the Auto Fill function which automatically enters the formula you created in D2 into the selected cells (ie D2 was =B2-C2, in D3 the formula becomes =B3-C3 etc)

8. In B17 type =sum(B2:B16) and hit enter

9. In C17 type =sum(C2:C16) and hit enter

10. In D17 type =sum(D2:D16) and hit enter

Step 4: Step 4: Converting Measurement Into Feet

Convert measurements into feet (round to the nearest whole number ex. 4.5 to 5 feet)

Bed: Length______________Width________________ Height_____________

Night Table: Length______________Width________________ Height_____________

Desk: Length______________Width________________ Height_____________

Chair: Length______________Width________________ Height_____________

Closet: Length_______________ Width______________ Height____________

Drawers: Length______________Width________________ Height_____________

________________: Length______________Width________________ Height_____________

Total Length_________________________ Total Width______________________________

Step 5: Step 5: Formatting Excel

Rename 'Sheet 2' Blueprint

1. Click on column heading A and drag the mouse across the headings until you reach the number of cells that matches your room’s width

Example: If your width is 8 feet, then you highlight headings A to H

2. Next right click on the last heading highlighted and select column width. Type 5.00 into the pop up box, and click OK

3. Click on row heading 1, and drag the mouse down the rows until you reach the correct number of cells to match the room’s length, right clicking on the last row heading and selecting row height…

Example: If your length is 10 feet, then you highlight headings 1 to 10

4. Select the area that will be your room and make the fill color to match your dream room’s carpet

5. Highlight and fill the correct length and width for the bed you selected. The fill color should be the color of the bed linens you selected. (If you want a color that is not there select more colors… and either standard or custom to see more colors)

6. Label the “bed” BED by merging and center the selected cells. Format the font however you want by right clicking and selecting format cell.

7. Follow steps 5-6 for the other required furniture

8. Add a door and at least one window by selecting the cells where the door/window will go. Right click the cells, click on format cells and border.