HomeMy WebLinkAboutFile Documents.980 E Hyman Ave.0014.2019 (7).ARBKINSTRUCTIONS FOR APPLICANTS:
IMPORTANT: Turn on Macros: In order for the code within this spreadsheet to run correctly the security settings need to be altered.
Click "File" and then click "Options." In the "Trust Center" category, click "Trust Center Settings", then click "Macro Settings"
category. Beneath "Macro Settings" select "Enable all Macros."
NOTE: The security risks associated with enableing macros has been addressed by the City of Aspen, this spreadsheet comes from a trusted source.
Questions regarding the security of this spreadsheet can be directed to the City representatives listed below.
1. Save this file as the project address.
To save this spreadsheet: Click FILE, click SAVE AS, choose locations to save this spreadsheet (computer desktop, special folder, etc.),
enter project address as the File Name, Save As Type should say Excel Macro-Enabled Workbook, then click SAVE.
2. Continue to the PERMIT OVERVIEW sheet located at the bottom of the screen and follow the directions.
QUESTIONS:
Regarding definitions, service area boundaries, service area fees, fixture counts, etc. contact Steve Wilson, Plans Reviewer, at 970-429-1974
Regarding Excel, troubleshooting, and calculations contact PJ Murray, Civil Engineer I, at 970-920-5056
INSTRUCTIONS
01/29/2019
Permit No.
U.C.P.No.
THE CITY OFASPEN WATER DEPARTMENT
130 SOUTH GALENA STREET
# OF METERS FIRE SUPRESSION SYSTEM REQUIRED?SERVICE AREA
SERVICE AREA 1
MAILING ADDRESS
Click the "Generate Spreadsheet" button to the right
Continue to the next spreadsheet found at the bottom of the screen.
DISCLAIMER: The fees calculated here are estimates only and may not be the final fees charged. Your final fee estimate will be
determined at the issuance of permit.
ACCOUNT NUMBER
DESCRIPTION OF WORK
980 EAST HYMAN AVE. UNIT #1, ASPEN CO 81611 1/28/2019
LOT BLOCK SUBDIVISION
PERMIT INFORMATION
JOB ADDRESS DATE
LEGAL
DESCRIPTION
INTERIOR REMODEL
PARCEL ID
ANNE@ANNEGRICE.COM
ANNE GRICE
ASPEN EAST 273718206027
NAME PHONE NUMBER
BEST CONTACT PERSON
970-429-4148
EMAIL ADDRESS
408ABC SUITE 201 ASPEN, CO 81611
01/29/2019
FOLLOW THE INSTRUCTIONS BELOW:
STEP 1: Click the CLEAR INPUT VALUES button to the right.
STEP 2: Select a quantity from the drop down menu for the categories KITCHEN - SPA/HOT TUB in the existing residence in the table below. The pool and irrigated landscape catetoreis do not have drop down menus, enter gallons and square feet respectively.
CATEGORY INPUT
KITCHEN 1 STEP 2B: Select the existing domestic line size and tap size at the main from the drop down menus in the table below.
LAUNDRY ROOM 1
APPLICANT INPUT CELL = BEDROOM 4 CATEGORY
OFFICE 0 EXISTING DOMESTIC LINE SIZE (in)1.5 SERVICE LINE SIZE (in)MINIMUM ECU
BATHROOM 4 EXISTING TAP SIZE AT THE MAIN (in)1.5 3/4 1.0
HALF BATHROOM/POWDER ROOM 0 1.0 2.0
KITCHEN EFFICIENCY 1 1.5 4.0
HOSE BIB 0 2.0 8.0
SPA/HOT TUB 0 4.0"
POOL (GALLONS) 0 6.0"
IRRIGATED LANDSCAPING (SF) 0 8.0"
UNKNOWN
STEP 3: Click the GENERATE REPORT button to the right.
This button creates a table for additional required information for each quantity of Kitchens, Laundry Rooms, Bathrooms, and Spa/Hot Tub for the proposed residence.
STEP 4: Select a value from the drop down menu for each fixture type in the tables created below. Use the Down Arrow button to navigate the applicant input cells instead of the Tab button.
KITCHEN 1
SINK 1
REFRIGERATOR 1
DISHWASHER 1
GARBAGE DISPOSAL 1
POT FILLER/ADDITIONAL SINK 0
BAR/HAND SINK 0
STAND ALONE ICE MACHINE 0
LAUNDRY ROOM 1
LAUNDRY/UTILITY SINK/DOG WASH 0
WASHING MACHINE 1
BATHROOM: ENTER QUANTITY OF FIXTURES
BATHROOM 1 BATHROOM 2 BATHROOM 3 BATHROOM 4
TOILET 1 TOILET 1 TOILET 1 TOILET 1
SINK 1 SINK 1 SINK 1 SINK 1
WASHING FACILITY 1 WASHING FACILITY 1 WASHING FACILITY 1 WASHING FACILITY 1
URINAL 0 URINAL 0 URINAL 0 URINAL 0
BIDET 0 BIDET 0 BIDET 0 BIDET 0
ADDITIONAL TOILET 0 ADDITIONAL TOILET 0 ADDITIONAL TOILET 0 ADDITIONAL TOILET 0
ADDITIONAL SINK 0 ADDITIONAL SINK 0 ADDITIONAL SINK 1 ADDITIONAL SINK 0
ADDITIONAL WASHING FACILITY 0 ADDITIONAL WASHING FACILITY 0 ADDITIONAL WASHING FACILITY 0 ADDITIONAL WASHING FACILITY 0
OVERSIZED BATHTUB 0 OVERSIZED BATHTUB 0 OVERSIZED BATHTUB 0 OVERSIZED BATHTUB 0
WHIRLPOOL UPGRADE/JETS 0 WHIRLPOOL UPGRADE/JETS 0 WHIRLPOOL UPGRADE/JETS 0 WHIRLPOOL UPGRADE/JETS 0
STEAM ROOM/SHOWER 0 STEAM ROOM/SHOWER 0 STEAM ROOM/SHOWER 0 STEAM ROOM/SHOWER 0
STEAM SHOWER UPGRADE 0 STEAM SHOWER UPGRADE 0 STEAM SHOWER UPGRADE 0 STEAM SHOWER UPGRADE 0
0 No
STEP 5: Proceed to the INTERIOR REMODEL sheet or NEW-REDEVELOPMENT sheet at the bottom of the screen and follow the directions to enter values for the proposed residence.
EXISTING SINGLE/MULTI FAMILY RESIDENCE CONDITIONS
KITCHEN: ENTER QUANTITY OF FIXTURES
METER SIZING CHART
LAUNDRY ROOM: ENTER QUANTITY OF FIXTURES
01/29/2019
FOLLOW THE INSTRUCTIONS BELOW:
STEP 1: Click the CLEAR INPUT VALUES button to the right.
STEP 2: Select a quantity from the drop down menu for the categories KITCHEN - SPA/HOT TUB in the proposed residence in the table below. The pool and irrigated landscape catetoreis do not have drop down menus, enter gallons and square feet respectively.
Include ALL quantities for each of the categories below in the residence, not just the remodeled areas.
CATEGORY QUANTITY
KITCHEN 1 STEP 2B: Select the proposed domestic line size and tap size at the main from the drop down menus in the table below.
LAUNDRY ROOM 1
APPLICANT INPUT CELL = BEDROOM 4 CATEGORY INPUT
OFFICE 0 EXISTING DOMESTIC LINE SIZE (in)1 1/2 SERVICE LINE SIZE (in)MINIMUM ECU
BATHROOM 4 EXISTING TAP SIZE AT THE MAIN (in)1.5 3/4 1.0
HALF BATHROOM/POWDER ROOM 0 1 2.0
KITCHEN EFFICIENCY 0 1.5 4.0
HOSE BIB 0 2 8.0
SPA/HOT TUB 0 4.0"
POOL (GALLONS) 0 6.0"
IRRIGATED LANDSCAPING (SF)0 8.0"
UNKNOWN
STEP 3: Click the GENERATE REPORT button to the right.
This button creates a table for additional required information for each quantity of Kitchens, Laundry Rooms, Bathrooms, and Spa/Hot Tub for the proposed residence.
STEP 4: Select a value from the drop down menu for each fixture type in the tables created below. Use the Down Arrow button to navigate the applicant input cells instead of theTab button.
KITCHEN 1
SINK 1
REFRIGERATOR 1
DISHWASHER 1
GARBAGE DISPOSAL 1
POT FILLER/ADDITIONAL SINK 0
BAR/HAND SINK 0
STAND ALONE ICE MACHINE 0
LAUNDRY ROOM 1
LAUNDRY/UTILITY SINK/DOG WASH 1
WASHING MACHINE 1
BATHROOM: ENTER QUANTITY OF FIXTURES
BATHROOM 1 BATHROOM 2 BATHROOM 3 BATHROOM 4
TOILET 1 TOILET 1 TOILET 1 TOILET 1
SINK 1 SINK 1 SINK 1 SINK 1
WASHING FACILITY 1 WASHING FACILITY 1 WASHING FACILITY 1 WASHING FACILITY 1
URINAL 0 URINAL 0 URINAL 0 URINAL 0
BIDET 0 BIDET 0 BIDET 0 BIDET 0
ADDITIONAL TOILET 0 ADDITIONAL TOILET 0 ADDITIONAL TOILET 0 ADDITIONAL TOILET 0
ADDITIONAL SINK 1 ADDITIONAL SINK 0 ADDITIONAL SINK 1 ADDITIONAL SINK 1
ADDITIONAL WASHING FACILITY 0 ADDITIONAL WASHING FACILITY 0 ADDITIONAL WASHING FACILITY 0 ADDITIONAL WASHING FACILITY 0
OVERSIZED BATHTUB 0 OVERSIZED BATHTUB 0 OVERSIZED BATHTUB 0 OVERSIZED BATHTUB 0
WHIRLPOOL UPGRADE/JETS 0 WHIRLPOOL UPGRADE/JETS 0 WHIRLPOOL UPGRADE/JETS 0 WHIRLPOOL UPGRADE/JETS 0
STEAM ROOM/SHOWER 0 STEAM ROOM/SHOWER 0 STEAM ROOM/SHOWER 0 STEAM ROOM/SHOWER 0
STEAM SHOWER UPGRADE 1 STEAM SHOWER UPGRADE 0 STEAM SHOWER UPGRADE 0 STEAM SHOWER UPGRADE 0
Yes Yes Yes Yes0NoNoNoNo
STEP 5: Proceed to the UC COST ESTIMATE sheet (utility connection cost estimate sheet) at the bottom of the screen to see the tap fee cost estimate for the proposed residence.
PROPOSED SINGLE/MULTI FAMILY RESIDENCE CONDITIONS
METER SIZING CHART
LAUNDRY ROOM: ENTER QUANTITY OF FIXTURES
KITCHEN: ENTER QUANTITY OF FIXTURES
01/29/2019
Bldg. Permit
U.C.P.No.
ASPEN WATER DEPARTMENT
130 SOUTH GALENA STREET
ASPEN, CO 81611
JOB ADDRESS DATE
LOT BLOCK SUBDIVISION PARCEL ID
ACCOUNT NUMBER # OF METERS SERVICE AREA
DESCRIPTION OF WORK SERVICE LINE SIZE (if known)
1.5 inch
NET ECU TOTAL
(0.03)($173.85)
3/4" ($173.85)
RESIDENTIAL COST ESTIMATE
UTILITY INVESTMENT CHARGE
SERVICE AREA CHARGE
POTENTIAL FEE FOR UTILITY HOOK UP (SEE COA MUNICIPAL CODE TITLE 25)
MINIMUM SERVICE LINE SIZE
COMPUTATION OF FEE
980 EAST HYMAN AVE. UNIT #1, ASPEN CO 81611 1/28/2019
ASPEN EAST 273718206027
DISCLAIMER: The tap fees calculated here are estimates only and may not be the final fees charged. Your final tap fee estimate will be determined
at the issuance of permit. Final tap fee is subject to final inspection.
5,795.00$
LEGAL
DESCRIPTION
PERMIT INFORMATION
SERVICE AREA 1
INTERIOR REMODEL
ESTIMATED CONNECTION FEE DUE
01/29/2019
DATE:
NAME:
ADDRESS:
SERVICE AREA:
DESCRIPTION OF WORK:INTERIOR REMODEL
BEDROOM 0.10 4 0.4 4 0.4 0 0.00
OFFICE 0.01 0 0 0 0 0 0.00
1ST BATHROOM 0.36 1 0.36 1 0.36 0 0.00
ADDITIONAL BATHROOM 0.24 1 0.24 1 0.24 0 0.00
TOILETS / URINALS / BIDETS 0.05 2 0.1 2 0.1 0 0.00
ADDITIONAL LAV 0.02 3 0.06 5 0.1 2 0.04
ADDITIONAL BATHING FEATURE 0.05 2 0.1 2 0.1 0 0.00
TUB OVERSIZED 0.02 0 0 0 0 0 0.00
WHIRLPOOL UPGRADE 0.05 0 0 0 0 0 0.00
STEAM ROOM / SHOWER 0.08 0 0 0 0 0 0.00
STEAM SHOWER UPGRADE 0.03 0 0 1 0.03 1 0.03
KITCHEN 0.25 1 0.25 1 0.25 0 0.00
DISHWASHER 0.10 1 0.1 1 0.1 0 0.00
DISPOSAL 0.05 1 0.05 1 0.05 0 0.00
ADD KITCHEN SINK / POT FILLER 0.05 0 0 0 0 0 0.00
KITCHEN / EFF.0.15 1 0.15 0 0 -1 -0.15
BAR / HAND SINK 0.05 0 0 0 0 0 0.00
ICE MACHINE 0.05 0 0 0 0 0 0.00
WASHER 0.10 1 0.1 1 0.1 0 0.00
LNDRY /UTIL. SINK / DOG WASH 0.05 0 0 1 0.05 1 0.05
1st HOSE BIB 0.20 0 0 0 0 0 0.00
2nd HOSE BIB 0.10 0 0 0 0 0 0.00
ADD HOSE BIB 0.05 0 0 0 0 0 0.00
SPA / HOT TUB / 100 GALLONS 0.02 0 0 0 0 0 0.00
LANDSCAPE > 3000 SF 0.01 0 0 0 0 0 0.00
POOL > 1000 GAL 0.02 0 0 0 0 0 0.00
0 0.00
0 0.00
0 0.00
TOTAL ECU COUNT 1.91 1.88 -0.03 0.00
DOMESTIC LINE SIZE (inches)1.5 1.5
ECU MINIMUM 4 4.0
ECU BALANCE NEW ECU ESTIMATE NEW ECU TOTAL
2.12 1.88 0.00
CHARGE FOR THE SERVICE AREA 5,795.00$ 5,795.00$
( X ) TOTAL ADDITIONAL ECU -0.03
TAP FEE (173.85)$
FIXTURE EXISTING
CONDITIONS
PROPOSED
CONDITIONS
NET NEW
FIXTURES ECU RATE EXISTING
ECU
PROPOSED
ECU
RESIDENTIAL ECU COST ESTIMATE PAGE
THESE COLUMNS ARE COMPLETED DURING FINAL
INSPECTION OF THE RESIDENCE BY AN INSPECTOR FROM
THE CITY OF ASPEN
FINAL
CONDITIONS TOTAL FINAL ECU
NON-
PROPOSED
FIXTURES
980 EAST HYMAN AVE. UNIT #1, ASPEN CO 81611
ANNE GRICE
1/28/2019
ACCT. NUMBER:
PERMIT NUMBER:
INSPECTOR
NOTES:
CHANGE IN ECU
COUNT
SERVICE AREA 1
01/29/2019