Spreadsheet: 826151d1681829777-combing-account-numbers-with-carrot-formula-with-carrot
Sheet: Sheet1

 | 16000000 | 16000001 | 16010000 | 16010001 | 16010002 | 16010003 | 16010070 | 16010090 | 16010100 | 16010120 | 16010130 | 16010140 | 16010150 | 16010160 | 16010170 | 16010180 | 16010190 | 16020000 | 16020001 | 16020002 | 16020003 | 16020004 | 16020005 | 16020100 | 16020200 | 16030000 | 16040000 | 16040500 | 16040600 | 16050000 | 16050010 | 16050020 | 16060000 | 16070000 | 16080000 | 16080010 | 16090000 | 16099999 | 16100000 | 16110000 | 16120000 | 16120001 | 16120002 | 16120003 | 16120004 | 16120005 | 16120006 | 16120007 | 16120008 | 16120009 | 16120010 | 16120011 | 16120012 | 16120013 | 16120014 | 16120015 | 16120016 | 16120017 | 16120018 | 16120019 | 16120020 | 16120021 | 16120022 | 16120024 | 16120025 | 16120026 | 16120027 | 16120028 | 16120029 | 16120030 | 16120032 | 16120033 | 16120034 | 16120035 | 16120040 | 16120041 | 16120042 | 16120043 | 16120044 | 16120045 | 16120046 | 16120048 | 16120050 | 16120060 | 16120070 | 16120080 | 16120081 | 16120082 | 16120083 | 16120084 | 16120085 | 16120086 | 16120087 | 16120110 | 16120120 | 16120130 | 16120140 | 16120150 | 16120160 | 16120170 | 16120180 | 16120190 | 16120200 | 16120201 | 16120210 | 16122015 | 16122020 | 16122030 | 16122095 | 16125000 | 16125001 | 16125002 | 16125003 | 16125004 | 16125005 | 16125006 | 16125100 | 16126000 | 16130000 | 16140000 | 16150000 | 16160000 | 16170000 | 16199999 | 16200000 | 16200001 | 16209999 | 16210000 | 16210001 | 16210002 | 16210003 | 16219999 | 16300000 | 16300001 | 16300002 | 16300003 | 16300004 | 16300005 | 16300006 | 16300007 | 16300008 | 16300009 | 16300010 | 16300011 | 16300012 | 16300013 | 16300014 | 16300015 | 16300016 | 16300017 | 16300018 | 16300019 | 16300020 | 16300021 | 16300025 | 16300026 | 16300027 | 16300029 | 16300030 | 16300031 | 16300032 | 16300041 | 16300042 | 16300043 | 16300044 | 16300045 | 16300046 | 16300050 | 16300060 | 16300070 | 16300095 | 16300099 | 16300100 | 16300999 | 16400000 | 16400001 | 16400002 | 16400003 | 16400004 | 16400005 | 16400006 | 16400007 | 16400008 | 16400009 | 16400010 | 16400011 | 16400012 | 16400013 | 16400014 | 16400015 | 16400016 | 16400017 | 16400018 | 16400019 | 16400020 | 16400021 | 16400022 | 16400023 | 16400024 | 16400025 | 16400026 | 16400027 | 16400029 | 16400031 | 16400032 | 16400041 | 16400042 | 16400043 | 16400044 | 16400045 | 16400046 | 16400050 | 16400060 | 16400080 | 16400090 | 16400091 | 16400092 | 16400093 | 16400095 | 16400096 | 16400097 | 16400098 | 16400100 | 16409020 | 16409021 | 16409030 | 16409920 | 16500010 | 16500020 | 16500030 | 16500040 | 16500050 | 16500500 | 16500501 | 16500502 | 16500503 | 16500504 | 16500505 | 16500506 | 16500507 | 16500508 | 16500509 | 16500510 | 16500511 | 16500512 | 16500513 | 16500514 | 16500515 | 16500520 | 16500600
 | Fixed Assets | Building & Improvements | Building - Purchase Price | Building - Reduction for % Allocation to Land | Building - CIP | Building - Allocation to Land - Adjustment for ASC 805/946 | Building - Price Adjustments | Building - Broker Credits | Building - Addition for Bargain Purchase | Building - Reduction for ASC 805 - Appliance Replacement | Building - Reduction for ASC 805 - HVAC Replacement | Building - Reduction for ASC 805 - Electrical Replacement | Building - Reduction for ASC 805 - Plumbing Replacement | Building - Reduction for ASC 805 - Above Market Leases | Building - Reduction for ASC 805 - In Place Leases | Building - Addition for ASC 805 - Below Market Leases | Building - Adjustment for ASC 805/946 - Push Down Accounting | Building Improvements - 10 Year Life - Do Not Use | Building Improvements - 10 Year Life | Building Improvements - 27.5 Year Life | Other Building Improvements | Building - Step Up/Down Adjustment | Impairment Loss | Property Loss | 1031 Exchange Adjustment | Building - Closing Costs | Building - Acquisition Costs | Building - Acquisition Costs - Advisor Fee - RPC | Building - Acquisition Cost - Commission Adjustment | Building - Inspection Fee | Building - Property Setup Fee - RPC | Building - Make Ready Scope Fee - RPC | Building - Back Taxes | Building - Back HOA | Building - Other / Misc | Building - Rental Fee - RPC | Building Held for Sale | Total Building & Improvements | Initial Rehab Costs | Building Improvements - 10 Year Life - Do Not Use | [NAME] | Initial Rehab - Appliance Replacement | Initial Rehab - HVAC System Replacement | Initial Rehab - Electrical System Replacement | Initial Rehab - Plumbing System Replacement | Initial Rehab - Pool System Replacement | Initial Rehab - Fence Replacement | Initial Rehab - Roof Replacement | Initial Rehab - Carpet | Initial Rehab - Garage Door System Replacement | Initial Rehab - Gutter Replacement | Initial Rehab - Door Replacement | [NAME], Toilet, Sink, Faucet Replacement | Initial Rehab - Window Replacement | Initial Rehab - Cabinet Replacement | Initial Rehab - Ceiling/Light Fixture Replacement | Initial Rehab - Irrigation System Replacement | Initial Rehab - Fire-protection and Alarm System Replacement | Initial Rehab - Countertop Replacement | Initial Rehab - Decking or Patio Replacement | Initial Rehab - Fireplace System Replacement | [NAME] or Driveway Replacement | Initial Rehab - Construction Management Fees | [NAME] | [NAME] | Initial Rehab - Vendor Reno Program | Initial Rehab - Hard Surface Flooring Replacement | Initial Rehab - Shelving / Straps | Initial Rehab - Framing, Insulation and Drywall | [NAME]Major Structural Costs | [NAME] | [NAME]Attic Stairs / Access Panel | [NAME]Bathroom Accessories / Mirrors | [NAME] | Initial Rehab - Cleaning | Initial Rehab - Appliance - Refrigerator Repl. | Initial Rehab - Appliance - Range/Oven Repl. | Initial Rehab - Appliance - Dishwasher Repl. | Initial Rehab - Appliance - Microwave Oven Repl. | Initial Rehab - Appliance - Washer Repl. | Initial Rehab - Appliance - Dryer Repl. | [NAME] SKU items | Initial Rehab - Maintenance Fees - RPC | Initial Rehab - Maintenance Labor - RPC | [NAME] | [NAME]. [NAME] 27.5 WIP | [NAME]. [NAME] 15 WIP | [NAME]. [NAME] 7 WIP | [NAME]. [NAME] 3 WIP | [NAME]. [NAME] 27.5 | [NAME]. [NAME] 15 | [NAME]. [NAME] | [NAME]. [NAME] 3 | Initial Rehab - Property Taxes | Initial Rehab - Utilities | [NAME] | Initial Rehab - Pool Maintenance | Initial Rehab - Insurance | Initial Rehab - Capitalized Interest | Initial Rehab - Winterization | Initial Rehab - Rekey | Initial Rehab - Smart Home Setup | Initial Rehab - Development Stage Improvements and WIP | Initial Rehab - Photo | Initial Rehab - PMC Pre-Yard Onboarding | [NAME] Stucco / Brick / Ext-trim | Initial Rehab - Painting | Initial Rehab - Septic Tank Replacement | Initial Rehab - Incident | HOA Capitalized Costs | HOA - Contributions, [NAME]., Transf. and Initia. Fees | HOA - Violations (pre Stabilization only) | HOA - Liens (pre Stabilization only) | HOA - Dues (pre Stabilization only) | HOA - Legal Fees (pre Stabilization only) | HOA Review Fees - RPC | Total HOA Capitalized Costs | [NAME] | Building Improvements - 27.5 Year Life | Furniture | Fixtures | Equipment - PR3M Client | Vehicles | Total Initial Rehab Costs | Turnover Costs | Turn - Building Improvements - 10 Year Life | Total Turnover Costs | Eviction Costs | Eviction Costs - Trash Removal | Eviction Costs - Cash for Keys | Eviction Costs - Services and Misc Costs | Total Eviction Costs | Maint - Building Improvements | Maint - Appliance Replacement | Maint - HVAC System Replacement | Maint - Electrical System Replacement | Maint - Plumbing System Replacement | Maint - Pool System Replacement | Maint - Fence Replacement | Maint - Roof Replacement | Maint - Carpet | Maint - Garage Door System Replacement | Maint - Gutter Replacement | Maint - Door Replacement | Maint - Bath, Toilet, Sink, Faucet Replacement | Maint - Window Replacement | Maint - Cabinet Replacement | Maint - Ceiling/Light Fixture Replacement | Maint - Irrigation System Replacement | Maint - Fire-protection and Alarm System Replacement | Maint - Countertop Replacement | Maint - Decking or Patio Replacement | Maint - Fireplace System Replacement | Maint - Walkway or Driveway Replacement | Maint - Exterior Painting and Siding | Maint - Carpentry | Maint - Hard Surface Flooring Replacement | Maint - Framing, Insulation and Drywall | Maint- Major Structural Costs | Maint - Window Screens | Maint - Landscaping - Sod | Maint - Appliance - Refrigerator Repl. | Maint - Appliance - Range/Oven Repl. | Maint - Appliance - Dishwasher Repl. | Maint - Appliance - Microwave Oven Repl. | Maint - Appliance - Washer Repl. | Maint - Appliance - Dryer Repl. | Maint - Maintenance Fees - RPC | Maint - Maintenance Labor | Maint - Septic Tank Replacement | Maint - Incident | Maint - Ongoing Capex - WIP | Total Maint - Building Improvements | Maint - Ongoing Capex - Offset | Turn - Building Improvements | Turn - Appliance Replacement | Turn - HVAC System Replacement | Turn - Electrical System Replacement | Turn - Plumbing System Replacement | Turn - Pool System Replacement | Turn - Fence Replacement | Turn - Roof Replacement | Turn - Carpet Replacement | Turn - Garage Door System Replacement | Turn - Gutter Replacement | Turn - Door Replacement | Turn - Bath, Toilet, Sink, Faucet Replacement | Turn - Window Replacement | Turn - Cabinet Replacement | Turn - Ceiling/Light Fixture Replacement | Turn - Irrigation System Replacement | Turn - Fire-protection and Alarm System Replacement | Turn - Countertop Replacement | Turn - Decking or Patio Replacement | Turn - Fireplace System Replacement | Turn - Walkway or Driveway Replacement | Turn - Interior / Exterior Improvements | Turn - Painting / Wall Repair | Turn - Lock & Keys | Turn - Exterior Painting and Siding | Turn - Carpentry | Turn - Hard Surface Flooring Replacement | Turn - Framing, Insulation and Drywall | Turn - Window Screens | Turn - Landscaping - Sod | Turn - Appliance - Refrigerator Repl. | Turn - Appliance - Range/Oven Repl. | Turn - Appliance - Dishwasher Repl. | Turn - Appliance - Microwave Oven Repl. | Turn - Appliance - Washer Repl. | Turn - Appliance - Dryer Repl. | Turn - Labor | Turn - Construction Management Fees - RPC | Turn - CIP / Development Costs | Turn - Property Taxes | Turn - Insurance | Turn - HOA - Dues | Turn - Capitalized Interest | Turn - Incident | Turn - value enhancing capex | Turn - Value enhancing Stainless Appliances | Turn - Value enhancing Countertops / Cabinets | Total Turn - Building Improvements | Turn - Fireplace System Replacement | Turn - Walkway or Driveway Replacement | Turn - Septic Tank Replacement | Turn - Fireplace System Replacement | Incident Turn | Renewal - Bathroom Replacement | Renewal - Electrical System Replacement | Renewal - Window Replacement | Renewal - HVAC System Replacement | Strategic [NAME] – Capex | Strategic - Gutters Replacement - FYR | Strategic Redevelopment Ext Paint/Siding/Cornice/Fascia | Strategic - Roof Replacement  - FYR | Strategic - Roof Inspections - FYR | Strategic - RETS LVP Flooring - FYR | Strategic - RETS Paint - FYR | Strategic - RETS SS Appliances - FYR | Strategic - RETS Cabinets - FYR | Strategic - RETS Countertops - FYR | Strategic [NAME] – Development Costs | Strategic - RETS Plumbing/Vanity/Sink/Faucet - FYR | Strategic - RETS Deck - FYR | Strategic - RETS Door/Window - FYR | Strategic - RETS Trash Removal / Cleaning - FYR | Strategic - RETS Others - FYR | Strategic [NAME] – Construction Management Fees | [NAME] | Total
 | 16000000^16000001^16010000