CONSTRUCTION COSTS CALCULATOR by maneeshchoudhury

VIEWS: 21 PAGES: 59

									Index
Index           2

Costs_by_Date

Instructions
4/8/2012   CONSTRUCTION COSTS                        SUMMARY OF COSTS
DATE        ITEM          AMOUNT      CATEGORY    APPLIANCES
                                                  ARCHITECT
                                                  CABINETS
                              TOTAL         $0.00 CARPET
                      SUMMARY TOTAL         $0.00 DRY WALL
                                                  ENGINEERING
                                                  FINISH CARPENTRY
                                                  FLOORS
                                                  FOUNDATION
                                                  FRAMING
DATE        ITEM          AMOUNT      CATEGORY GUTTERS
                                                  HEATING
                                                  LANDSCAPING
                                                 LIGHT FIXTURES
                                                 MIRRORS
                                                 MISCELLANEOUS
                                                 PAINTING
                                                 PERMITS
                                                 PLANS
                                                 PLUMBING
                                                 ROOF
                                                 SECURITY
                                                 STUCCO
                                                 TILE
                                                 VINYL
                                                 WALLPAPER
                                                          TOTAL
SUMMARY OF COSTS           BUDGET   STATUS      26   13   2
                   $0.00
                   $0.00
                   $0.00
                   $0.00
                   $0.00
                   $0.00
                   $0.00
                   $0.00
                   $0.00
                   $0.00
                   $0.00
                   $0.00
                   $0.00
                   $0.00
                   $0.00
                   $0.00
                   $0.00
                   $0.00
                   $0.00
                   $0.00
                   $0.00
                   $0.00
                   $0.00
                   $0.00
                   $0.00
                   $0.00
                   $0.00
                                     4/8/2012
                                                        Instructions


                                                              The purpose of Construction_Costs is to give the user a good
                                                              record of their construction costs. This record can be a very
                                                              valuable item whenever the property is sold.




NEW ENTRY BUTTON:
This button is used to make all of your entries. A dialog box appears where you can enter the date, item, amount, and select
the category. If the date is the same as the date of entry, Construction_Costs will enter the date for you, just press the tab
key. If you are making more than one entry click the Repeat box in the dialog box. Unclick it on your last entry.

GO TO LAST LINE BUTTON:
This button will take you to the last line of your entries.

COMPLETE RECALCULATION BUTTON:
This button recalculates all categories from the entries into the summary.

PRINT SUMMARY OF COSTS BUTTON:
This button sets the print area, and prints the Summary of Costs.

SAVE AS PROJECT & CLEAR BUTTON:
This button is used when the project is completed. A dialog box will appear where you will enter the name of the just
completed project. It will then copy and move the sheet to the right of the Instructions sheet. It will remove no longer needed
buttons, and reformat the page. It will then go back to the Costs_by_Date sheet, and clear it for a new project.

ADD COST BUTTON:
Same as the Complete Recalculation button, but only one category is entered. Use this button when you wish to add
only one or two entries to the summary.

ADD CATEGORY BUTTON:
You can add categories to the category list with this button. Enter the name of the new category into the dialog box that will
appear, and Construction_Costs does the rest.

DELETE CATEGORY BUTTON:
If you use a general contractor you may wish to delete quite a few of the categories, and add Contractor to the categories
list. Just select the category to be deleted from the dialog box and Construction_Costs will delete it.

RETURN ORIGINAL CATEGORIES BUTTON:
This button can be used to return deleted categories. The user may decide after finishing one project that he requires the
deleted categories from the last project. This button will replace the 26 original categories, but it will also delete any new
ones the user may have added.

Index Sheet Changes
If you add or remove sheets to the workbook, you should click the New Index button on the Index sheet.

If you have any problems or suggestions, you can contact me at:
jackkarnes_pc@mindspring.com

                            ©1998 JACK KARNES. ALL RIGHTS RESERVED.

                You can see more files on my web site: http://www.mindspring.com/~jackkarnes




                                                         Page 44
Instructions




 Page 45
Instructions




 Page 46
Instructions




 Page 47
                              Instructions


ve the user a good
rd can be a very




 item, amount, and select
 you, just press the tab




e name of the just
remove no longer needed



en you wish to add



 o the dialog box that will



 actor to the categories



ect that he requires the
 l also delete any new




                               Page 48
Instructions




 Page 49
Instructions




 Page 50
Instructions




 Page 51
Instructions




 Page 52
Instructions




 Page 53
Instructions




 Page 54
Instructions




 Page 55
Instructions




 Page 56
Instructions




 Page 57
Instructions




 Page 58
Instructions




 Page 59

								
To top