HUD UTILITY MODEL INSTRUCTIONS - HUD User本实用新型说明书-用户HUD平视显示器.docVIP

HUD UTILITY MODEL INSTRUCTIONS I. Introduction The HUD Utility Schedule Model has been developed to provide a consistent basis for determining utility schedules, using form HUD-52667, throughout the U.S. This spreadsheet model is organized into several tabs and was designed to work with Microsoft Excel 2000 and 2003 although it may also work with other spreadsheets including older versions of Excel. Each first time user must complete the entries on the “Location” tab and the “Tariffs” tab of the spreadsheet model. Entries are shown as cells with a white background and are surrounded by cells with a grey background. The resulting forms are on tabs with “52667” as part of their name. When you print from the “52667” tabs, the entire page is not printed, only the utility schedule. Four different “52667” forms are included but you can add more or remove any that you don’t want. No changes to the “52667” tabs are needed except for selecting the Unit Type, the type of Electric Tariff, kind of Electric Heating, and Age of Dwelling. Values cannot be entered directly on the form. They are based on the calculations shown to the right and below the form. The summary tab shows the total allowances for a large number of common cases. It can be used to see the overall impact of a rate change. Almost all the calculations are performed on the “52667” tabs. The main form is in the upper left hand corner of the worksheet tab but below it and to the right are the calculations. They are shown in a step-by-step fashion to make it clear how the calculations were performed. These calculations cannot be changed, they take the values you have entered on the “Location” and “Tariffs” tabs and simply perform the calculations. II. Detailed Instructions The following sections are related to the sections on each of the tabs of the HUD Utility Schedule Model. Remember, the input is on the “Location” tab, “Tariffs” tab, and just four places at the top of the “52667” tabs. No other inpu