Estimate Notebook

Lenders and estimates may use differnt categories. As you estimate, it’s helpful to assign numbers to categories - possibly using different a different organization.

As an example, we’ll use one breakdown for lender A.

Each category has a code and a description.

categoryID_A = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10,
         11, 12, 13, 14, 15, 16, 17, 18, 19, 20,
         21, 22, 23, 24, 25, 26, 27, 28, 29, 30,
         31, 32, 33, 34, 35, 36, 37, 38, 39, 40,
         41, 42, 43, 44, 45, 46, 47]
categoryDescription_A = ['SURVEY, BUILDING PERMIT', 'ARCHITECTURAL SERVICES', 'CLEARING BUILDING SITE',
                'EXCAVATING, FILLING', 'GRADING BACKFILL', 'FOUNDATION', 'WATER, GAS, SEWER CONNECTIONS',
                'WELL, PUMP & SEPTIC SYSTEM', 'CONCRETE', 'BLOCK', 'WATER PROOFING', 'CONCRETE WORK',
                'ROOFING', 'STRUCTURAL STEEL', 'LAMINATED UNITS, TRUSSES', 'BRICKWORK, CHIMNEY, FIREPLACE',
                'WINDOWS AND EXT. DOORS', 'LUMBER', 'ROOFING MATERIAL', 'WOOD FLOORING', 'INSULATION',
                'HARDWARE', 'MILLWORK, TRIM, WINDOWS', 'CABINET WORK, CABINETS & COUNTERTOPS',
                'SIDING, DECK, RAILINGS', 'PLUMBING, ROUGH IN', 'PLUMBING MATERIALS',
                'HEATING/AIR CONDITIONING', 'ELECTRIC WIRING', 'ELECTRIC FIXTURES', 'DRYWALL/MATERIALS',
                'DRYWALL TAPING', 'PAINTING INTERIOR, DECORATING', 'PAINTING EXTERIOR', 'TILEWORK, CERAMIC, PLASTIC',
                'LINOLEUM, FLOOR TILE', 'CARPETING', 'GARAGE DOORS', 'APPLIANCES', 'BLACKTOP/DRIVEWAY',
                'LANDSCAPING/SOD', 'Equipment', 'CONTRACTOR FEES/PROJECT MNGT', 'RISK INS., CLEANING, TEMP UTILITIES',
                'Contingency', 'Construction of Building', 'Closing costs']

categoriesDict_A = {categoryID_A[i]: categoryDescription_A[i] for i in range(len(categoryID_A))}
categoriesDict_A[5]  # Returns 'GRADING BACKFILL'

'GRADING BACKFILL'