import datetime

materials = [
    {
        'id': 2484,
        'type': 'room_roof_insulation',
        'description': 'Room in roof insulation',
        'depth': 100,
        'depth_unit': 'mm',
        'cost_unit': 'gbp_per_m2',
        'r_value_per_mm': 0.038,
        'r_value_unit': 'square_meter_kelvin_per_watt',
        'thermal_conductivity': 0.022,
        'thermal_conductivity_unit': 'watt_per_meter_kelvin',
        'link': 'SCIS',
        'created_at': '2025-03-16 15:26:22.379',
        'cost': None,
        'is_active': True,
        'prime_material_cost': None,
        'material_cost': 0.0,
        'labour_cost': 0.0,
        'labour_hours_per_unit': 0.0,
        'plant_cost': 0.0,
        'total_cost': 210.0,
        'notes': None,
        'is_installer_quote': True
    },
    {'id': 1997, 'type': 'cavity_wall_insulation', 'description': 'Imperial Bead cavity wall insulation', 'depth': 75.0,
     'depth_unit': 'mm', 'cost': None, 'cost_unit': 'gbp_per_m2', 'r_value_per_mm': 0.030303031,
     'r_value_unit': 'square_meter_kelvin_per_watt', 'thermal_conductivity': 0.033,
     'thermal_conductivity_unit': 'watt_per_meter_kelvin', 'link': 'SCIS',
     'created_at': datetime.datetime(2024, 9, 24, 13, 42, 52, 584553), 'is_active': True, 'prime_material_cost': None,
     'material_cost': 0.0, 'labour_cost': 0.0, 'labour_hours_per_unit': 0.0, 'plant_cost': 0.0, 'total_cost': 14.21,
     'notes': None, 'is_installer_quote': True},
    {'id': 1998, 'type': 'mechanical_ventilation', 'description': 'Mechanical Extract Ventilation', 'depth': 0.0,
     'depth_unit': None, 'cost': None, 'cost_unit': 'gbp_per_unit', 'r_value_per_mm': None,
     'r_value_unit': 'square_meter_kelvin_per_watt', 'thermal_conductivity': None, 'thermal_conductivity_unit': None,
     'link': 'SCIS', 'created_at': datetime.datetime(2024, 9, 24, 13, 42, 52, 584553), 'is_active': True,
     'prime_material_cost': None, 'material_cost': 0.0, 'labour_cost': 0.0, 'labour_hours_per_unit': 0.0,
     'plant_cost': 0.0, 'total_cost': 535.5, 'notes': None, 'is_installer_quote': True},
    {'id': 2015, 'type': 'loft_insulation', 'description': 'Knauf Loft Roll 44 glass fibre roll', 'depth': 100.0,
     'depth_unit': 'mm', 'cost': None, 'cost_unit': 'gbp_per_m2', 'r_value_per_mm': 0.022727273,
     'r_value_unit': 'square_meter_kelvin_per_watt', 'thermal_conductivity': 0.044,
     'thermal_conductivity_unit': 'watt_per_meter_kelvin', 'link': 'SCIS',
     'created_at': datetime.datetime(2024, 9, 24, 13, 42, 52, 584553), 'is_active': True, 'prime_material_cost': None,
     'material_cost': 0.0, 'labour_cost': 0.0, 'labour_hours_per_unit': 0.09, 'plant_cost': 0.0, 'total_cost': 14.95,
     'notes': 'This is a placeholder cost until SCIS gives us a breakdown by thickness', 'is_installer_quote': True},
    {'id': 2016, 'type': 'loft_insulation', 'description': 'Knauf Loft Roll 44 glass fibre roll', 'depth': 200.0,
     'depth_unit': 'mm', 'cost': None, 'cost_unit': 'gbp_per_m2', 'r_value_per_mm': 0.022727273,
     'r_value_unit': 'square_meter_kelvin_per_watt', 'thermal_conductivity': 0.044,
     'thermal_conductivity_unit': 'watt_per_meter_kelvin', 'link': 'SCIS',
     'created_at': datetime.datetime(2024, 9, 24, 13, 42, 52, 584553), 'is_active': True, 'prime_material_cost': None,
     'material_cost': 0.0, 'labour_cost': 0.0, 'labour_hours_per_unit': 0.11, 'plant_cost': 0.0, 'total_cost': 15.525,
     'notes': 'This is a placeholder cost until SCIS gives us a breakdown by thickness', 'is_installer_quote': True},
    {'id': 2017, 'type': 'loft_insulation', 'description': 'Knauf Loft Roll 44 glass fibre roll', 'depth': 270.0,
     'depth_unit': 'mm', 'cost': None, 'cost_unit': 'gbp_per_m2', 'r_value_per_mm': 0.022727273,
     'r_value_unit': 'square_meter_kelvin_per_watt', 'thermal_conductivity': 0.044,
     'thermal_conductivity_unit': 'watt_per_meter_kelvin', 'link': 'SCIS',
     'created_at': datetime.datetime(2024, 9, 24, 13, 42, 52, 584553), 'is_active': True, 'prime_material_cost': None,
     'material_cost': 0.0, 'labour_cost': 0.0, 'labour_hours_per_unit': 0.11, 'plant_cost': 0.0, 'total_cost': 16.1,
     'notes': 'This is a placeholder cost until SCIS gives us a breakdown by thickness', 'is_installer_quote': True},
    {'id': 2018, 'type': 'loft_insulation', 'description': 'Knauf Loft Roll 44 glass fibre roll', 'depth': 300.0,
     'depth_unit': 'mm', 'cost': None, 'cost_unit': 'gbp_per_m2', 'r_value_per_mm': 0.022727273,
     'r_value_unit': 'square_meter_kelvin_per_watt', 'thermal_conductivity': 0.044,
     'thermal_conductivity_unit': 'watt_per_meter_kelvin', 'link': 'SCIS',
     'created_at': datetime.datetime(2024, 9, 24, 13, 42, 52, 584553), 'is_active': True, 'prime_material_cost': None,
     'material_cost': 0.0, 'labour_cost': 0.0, 'labour_hours_per_unit': 0.11, 'plant_cost': 0.0, 'total_cost': 16.53,
     'notes': 'This is a placeholder cost until SCIS gives us a breakdown by thickness', 'is_installer_quote': True},
    {'id': 2039, 'type': 'internal_wall_insulation', 'description': 'SWIP EcoBatt', 'depth': 95.0, 'depth_unit': 'mm',
     'cost': None, 'cost_unit': 'gbp_per_m2', 'r_value_per_mm': 0.03125, 'r_value_unit': 'square_meter_kelvin_per_watt',
     'thermal_conductivity': 0.032, 'thermal_conductivity_unit': None, 'link': 'SCIS',
     'created_at': datetime.datetime(2024, 9, 24, 13, 42, 52, 584553), 'is_active': True, 'prime_material_cost': None,
     'material_cost': 0.0, 'labour_cost': 0.0, 'labour_hours_per_unit': 2.1, 'plant_cost': 0.0, 'total_cost': 244.8,
     'notes': 'We are awaiting further breakdown of costs by thickness and finishes', 'is_installer_quote': False},
    {'id': 2074, 'type': 'suspended_floor_insulation', 'description': 'Q-bot underfloor insulation', 'depth': 50.0,
     'depth_unit': 'mm', 'cost': None, 'cost_unit': 'gbp_per_m2', 'r_value_per_mm': 0.045454547,
     'r_value_unit': 'square_meter_kelvin_per_watt', 'thermal_conductivity': 0.022,
     'thermal_conductivity_unit': 'watt_per_meter_kelvin', 'link': 'SCIS',
     'created_at': datetime.datetime(2024, 9, 24, 13, 42, 52, 584553), 'is_active': True, 'prime_material_cost': None,
     'material_cost': 0.0, 'labour_cost': 0.0, 'labour_hours_per_unit': 1.63, 'plant_cost': 0.0, 'total_cost': 75.0,
     'notes': 'Linearly interpolated based on Qbot costs', 'is_installer_quote': True},
    {'id': 2075, 'type': 'suspended_floor_insulation', 'description': 'Q-bot underfloor insulation', 'depth': 75.0,
     'depth_unit': 'mm', 'cost': None, 'cost_unit': 'gbp_per_m2', 'r_value_per_mm': 0.045454547,
     'r_value_unit': 'square_meter_kelvin_per_watt', 'thermal_conductivity': 0.022,
     'thermal_conductivity_unit': 'watt_per_meter_kelvin', 'link': 'SCIS',
     'created_at': datetime.datetime(2024, 9, 24, 13, 42, 52, 584553), 'is_active': True, 'prime_material_cost': None,
     'material_cost': 0.0, 'labour_cost': 0.0, 'labour_hours_per_unit': 1.63, 'plant_cost': 0.0, 'total_cost': 93.75,
     'notes': 'Linearly interpolated based on Qbot costs', 'is_installer_quote': True},
    {'id': 2076, 'type': 'suspended_floor_insulation', 'description': 'Q-bot underfloor insulation', 'depth': 100.0,
     'depth_unit': 'mm', 'cost': None, 'cost_unit': 'gbp_per_m2', 'r_value_per_mm': 0.045454547,
     'r_value_unit': 'square_meter_kelvin_per_watt', 'thermal_conductivity': 0.022,
     'thermal_conductivity_unit': 'watt_per_meter_kelvin', 'link': 'SCIS',
     'created_at': datetime.datetime(2024, 9, 24, 13, 42, 52, 584553), 'is_active': True, 'prime_material_cost': None,
     'material_cost': 0.0, 'labour_cost': 0.0, 'labour_hours_per_unit': 1.63, 'plant_cost': 0.0, 'total_cost': 112.5,
     'notes': 'Linearly interpolated based on Qbot costs', 'is_installer_quote': True},
    {'id': 2077, 'type': 'suspended_floor_insulation', 'description': 'Q-bot underfloor insulation', 'depth': 125.0,
     'depth_unit': 'mm', 'cost': None, 'cost_unit': 'gbp_per_m2', 'r_value_per_mm': 0.045454547,
     'r_value_unit': 'square_meter_kelvin_per_watt', 'thermal_conductivity': 0.022,
     'thermal_conductivity_unit': 'watt_per_meter_kelvin', 'link': 'SCIS',
     'created_at': datetime.datetime(2024, 9, 24, 13, 42, 52, 584553), 'is_active': True, 'prime_material_cost': None,
     'material_cost': 0.0, 'labour_cost': 0.0, 'labour_hours_per_unit': 1.63, 'plant_cost': 0.0, 'total_cost': 112.5,
     'notes': 'Linearly interpolated based on Qbot costs', 'is_installer_quote': True},
    {'id': 2078, 'type': 'suspended_floor_insulation', 'description': 'Q-bot underfloor insulation', 'depth': 150.0,
     'depth_unit': 'mm', 'cost': None, 'cost_unit': 'gbp_per_m2', 'r_value_per_mm': 0.045454547,
     'r_value_unit': 'square_meter_kelvin_per_watt', 'thermal_conductivity': 0.022,
     'thermal_conductivity_unit': 'watt_per_meter_kelvin', 'link': 'SCIS',
     'created_at': datetime.datetime(2024, 9, 24, 13, 42, 52, 584553), 'is_active': True, 'prime_material_cost': None,
     'material_cost': 0.0, 'labour_cost': 0.0, 'labour_hours_per_unit': 1.63, 'plant_cost': 0.0, 'total_cost': 150.0,
     'notes': 'Linearly interpolated based on Qbot costs', 'is_installer_quote': True},
    {'id': 2079, 'type': 'solid_floor_demolition', 'description': 'Removal of carpet and underfelt', 'depth': 0.0,
     'depth_unit': None, 'cost': None, 'cost_unit': None, 'r_value_per_mm': None,
     'r_value_unit': 'square_meter_kelvin_per_watt', 'thermal_conductivity': None, 'thermal_conductivity_unit': None,
     'link': 'SPONs', 'created_at': datetime.datetime(2024, 9, 24, 13, 42, 52, 584553), 'is_active': True,
     'prime_material_cost': None, 'material_cost': 0.0, 'labour_cost': 3.32, 'labour_hours_per_unit': 0.11,
     'plant_cost': 0.0, 'total_cost': 3.32,
     'notes': 'We ignore the plant cost that is in SPONs because we assume the carpet is not scrapped and therefore '
              'there is no need for a skip',
     'is_installer_quote': False}, {'id': 2080, 'type': 'solid_floor_preparation',
                                    'description': 'clean surface of concrete to receive new damp-proof membrane',
                                    'depth': 0.0, 'depth_unit': None, 'cost': None, 'cost_unit': None,
                                    'r_value_per_mm': None, 'r_value_unit': 'square_meter_kelvin_per_watt',
                                    'thermal_conductivity': None, 'thermal_conductivity_unit': None, 'link': None,
                                    'created_at': datetime.datetime(2024, 9, 24, 13, 42, 52, 584553), 'is_active': True,
                                    'prime_material_cost': None, 'material_cost': 0.0, 'labour_cost': 4.36,
                                    'labour_hours_per_unit': 0.14, 'plant_cost': 0.0, 'total_cost': 4.36, 'notes': None,
                                    'is_installer_quote': False}, {'id': 2081, 'type': 'solid_floor_preparation',
                                                                   'description': 'Clean out crack to form a '
                                                                                  '20mm×20mm groove and fill with '
                                                                                  'cement: mortar mixed with bonding '
                                                                                  'agent',
                                                                   'depth': 0.0, 'depth_unit': None, 'cost': None,
                                                                   'cost_unit': None, 'r_value_per_mm': None,
                                                                   'r_value_unit': 'square_meter_kelvin_per_watt',
                                                                   'thermal_conductivity': None,
                                                                   'thermal_conductivity_unit': None, 'link': None,
                                                                   'created_at': datetime.datetime(2024, 9, 24, 13, 42,
                                                                                                   52, 584553),
                                                                   'is_active': True, 'prime_material_cost': None,
                                                                   'material_cost': 6.91, 'labour_cost': 18.99,
                                                                   'labour_hours_per_unit': 0.61, 'plant_cost': 0.16,
                                                                   'total_cost': 26.06,
                                                                   'notes': 'This step is the assessment and repair '
                                                                            'of any damage to the concrete floor such '
                                                                            'as filling cracks or levelling uneven '
                                                                            'areas',
                                                                   'is_installer_quote': False},
    {'id': 2082, 'type': 'solid_floor_vapour_barrier', 'description': 'Visqueen High Performance Vapour Barrier',
     'depth': 0.0, 'depth_unit': None, 'cost': None, 'cost_unit': None, 'r_value_per_mm': None,
     'r_value_unit': 'square_meter_kelvin_per_watt', 'thermal_conductivity': None, 'thermal_conductivity_unit': None,
     'link': 'SPONs', 'created_at': datetime.datetime(2024, 9, 24, 13, 42, 52, 584553), 'is_active': True,
     'prime_material_cost': 0.58, 'material_cost': 1.21, 'labour_cost': 0.48, 'labour_hours_per_unit': 0.02,
     'plant_cost': 0.0, 'total_cost': 1.69, 'notes': None, 'is_installer_quote': False},
    {'id': 2083, 'type': 'solid_floor_insulation', 'description': 'Kay-Cel Expanded Polystyrene Board', 'depth': 25.0,
     'depth_unit': 'mm', 'cost': None, 'cost_unit': 'gbp_per_m2', 'r_value_per_mm': 0.030303031,
     'r_value_unit': 'square_meter_kelvin_per_watt', 'thermal_conductivity': 0.033,
     'thermal_conductivity_unit': 'watt_per_meter_kelvin', 'link': 'SPONs',
     'created_at': datetime.datetime(2024, 9, 24, 13, 42, 52, 584553), 'is_active': True, 'prime_material_cost': None,
     'material_cost': 3.88, 'labour_cost': 3.24, 'labour_hours_per_unit': 0.14, 'plant_cost': 0.0, 'total_cost': 7.12,
     'notes': None, 'is_installer_quote': False},
    {'id': 2084, 'type': 'solid_floor_insulation', 'description': 'Kay-Cel Expanded Polystyrene Board', 'depth': 50.0,
     'depth_unit': 'mm', 'cost': None, 'cost_unit': 'gbp_per_m2', 'r_value_per_mm': 0.030303031,
     'r_value_unit': 'square_meter_kelvin_per_watt', 'thermal_conductivity': 0.033,
     'thermal_conductivity_unit': 'watt_per_meter_kelvin', 'link': 'SPONs',
     'created_at': datetime.datetime(2024, 9, 24, 13, 42, 52, 584553), 'is_active': True, 'prime_material_cost': None,
     'material_cost': 6.62, 'labour_cost': 3.71, 'labour_hours_per_unit': 0.16, 'plant_cost': 0.0, 'total_cost': 10.33,
     'notes': None, 'is_installer_quote': False},
    {'id': 2085, 'type': 'solid_floor_insulation', 'description': 'Kay-Cel Expanded Polystyrene Board', 'depth': 75.0,
     'depth_unit': 'mm', 'cost': None, 'cost_unit': 'gbp_per_m2', 'r_value_per_mm': 0.030303031,
     'r_value_unit': 'square_meter_kelvin_per_watt', 'thermal_conductivity': 0.033,
     'thermal_conductivity_unit': 'watt_per_meter_kelvin', 'link': 'SPONs',
     'created_at': datetime.datetime(2024, 9, 24, 13, 42, 52, 584553), 'is_active': True, 'prime_material_cost': None,
     'material_cost': 9.3, 'labour_cost': 4.17, 'labour_hours_per_unit': 0.18, 'plant_cost': 0.0, 'total_cost': 13.47,
     'notes': None, 'is_installer_quote': False}, {'id': 2086, 'type': 'solid_floor_insulation',
                                                   'description': 'Kingspan Thermafloor TF70 High Performance Rigid '
                                                                  'Floor Insulation',
                                                   'depth': 50.0, 'depth_unit': 'mm', 'cost': None,
                                                   'cost_unit': 'gbp_per_m2', 'r_value_per_mm': 0.045454547,
                                                   'r_value_unit': 'square_meter_kelvin_per_watt',
                                                   'thermal_conductivity': 0.022,
                                                   'thermal_conductivity_unit': 'watt_per_meter_kelvin',
                                                   'link': 'SPONs',
                                                   'created_at': datetime.datetime(2024, 9, 24, 13, 42, 52, 584553),
                                                   'is_active': True, 'prime_material_cost': None,
                                                   'material_cost': 10.36, 'labour_cost': 4.06,
                                                   'labour_hours_per_unit': 0.18, 'plant_cost': 0.0,
                                                   'total_cost': 14.42, 'notes': None, 'is_installer_quote': False},
    {'id': 2087, 'type': 'solid_floor_insulation',
     'description': 'Kingspan Thermafloor TF70 High Performance Rigid Floor Insulation', 'depth': 75.0,
     'depth_unit': 'mm', 'cost': None, 'cost_unit': 'gbp_per_m2', 'r_value_per_mm': 0.045454547,
     'r_value_unit': 'square_meter_kelvin_per_watt', 'thermal_conductivity': 0.022,
     'thermal_conductivity_unit': 'watt_per_meter_kelvin', 'link': 'SPONs',
     'created_at': datetime.datetime(2024, 9, 24, 13, 42, 52, 584553), 'is_active': True, 'prime_material_cost': None,
     'material_cost': 15.35, 'labour_cost': 4.06, 'labour_hours_per_unit': 0.18, 'plant_cost': 0.0, 'total_cost': 19.41,
     'notes': None, 'is_installer_quote': False}, {'id': 2088, 'type': 'solid_floor_insulation',
                                                   'description': 'Ecotherm Eco-Versal General Purpose Insulation '
                                                                  'Board',
                                                   'depth': 30.0, 'depth_unit': 'mm', 'cost': None,
                                                   'cost_unit': 'gbp_per_m2', 'r_value_per_mm': 0.045454547,
                                                   'r_value_unit': 'square_meter_kelvin_per_watt',
                                                   'thermal_conductivity': 0.022,
                                                   'thermal_conductivity_unit': 'watt_per_meter_kelvin',
                                                   'link': 'SPONs',
                                                   'created_at': datetime.datetime(2024, 9, 24, 13, 42, 52, 584553),
                                                   'is_active': True, 'prime_material_cost': 6.16,
                                                   'material_cost': 16.73, 'labour_cost': 28.34,
                                                   'labour_hours_per_unit': 1.2, 'plant_cost': 0.0, 'total_cost': 45.07,
                                                   'notes': None, 'is_installer_quote': False},
    {'id': 2089, 'type': 'solid_floor_insulation',
     'description': 'Ecotherm Eco-Versal General Purpose Insulation Board', 'depth': 50.0, 'depth_unit': 'mm',
     'cost': None, 'cost_unit': 'gbp_per_m2', 'r_value_per_mm': 0.045454547,
     'r_value_unit': 'square_meter_kelvin_per_watt', 'thermal_conductivity': 0.022,
     'thermal_conductivity_unit': 'watt_per_meter_kelvin', 'link': 'SPONs',
     'created_at': datetime.datetime(2024, 9, 24, 13, 42, 52, 584553), 'is_active': True, 'prime_material_cost': 8.46,
     'material_cost': 19.1, 'labour_cost': 28.34, 'labour_hours_per_unit': 1.2, 'plant_cost': 0.0, 'total_cost': 47.44,
     'notes': None, 'is_installer_quote': False}, {'id': 2090, 'type': 'solid_floor_insulation',
                                                   'description': 'Ecotherm Eco-Versal General Purpose Insulation '
                                                                  'Board',
                                                   'depth': 60.0, 'depth_unit': 'mm', 'cost': None,
                                                   'cost_unit': 'gbp_per_m2', 'r_value_per_mm': 0.045454547,
                                                   'r_value_unit': 'square_meter_kelvin_per_watt',
                                                   'thermal_conductivity': 0.022,
                                                   'thermal_conductivity_unit': 'watt_per_meter_kelvin',
                                                   'link': 'https://londonbuildingsupplies.co.uk/products/60mm--ecotherm-eco-versal-general-purpose-pir-insulation-board---2.4m-x-1.2m-x-60mm.html',
                                                   'created_at': datetime.datetime(2024, 9, 24, 13, 42, 52, 584553),
                                                   'is_active': True, 'prime_material_cost': None,
                                                   'material_cost': 24.081198, 'labour_cost': 28.34,
                                                   'labour_hours_per_unit': 1.2, 'plant_cost': 0.0,
                                                   'total_cost': 52.421196,
                                                   'notes': "This material isn't in SPONs but checking online, "
                                                            "is around 92% of the cost of the 100mm",
                                                   'is_installer_quote': False},
    {'id': 2091, 'type': 'solid_floor_insulation',
     'description': 'Ecotherm Eco-Versal General Purpose Insulation Board', 'depth': 70.0, 'depth_unit': 'mm',
     'cost': None, 'cost_unit': 'gbp_per_m2', 'r_value_per_mm': 0.045454547,
     'r_value_unit': 'square_meter_kelvin_per_watt', 'thermal_conductivity': 0.022,
     'thermal_conductivity_unit': 'watt_per_meter_kelvin',
     'link': 'https://londonbuildingsupplies.co.uk/products/70mm--ecotherm-eco-versal-general-purpose-pir-insulation'
             '-board---2.4m-x-1.2m-x-70mm.html',
     'created_at': datetime.datetime(2024, 9, 24, 13, 42, 52, 584553), 'is_active': True, 'prime_material_cost': None,
     'material_cost': 27.089088, 'labour_cost': 28.34, 'labour_hours_per_unit': 1.2, 'plant_cost': 0.0,
     'total_cost': 55.42909,
     'notes': "This material isn't in SPONs but checking online, is around 104% of the cost of the 100mm (more "
              "expensive than 100mm)",
     'is_installer_quote': False}, {'id': 2092, 'type': 'solid_floor_insulation',
                                    'description': 'Ecotherm Eco-Versal General Purpose Insulation Board',
                                    'depth': 100.0, 'depth_unit': 'mm', 'cost': None, 'cost_unit': 'gbp_per_m2',
                                    'r_value_per_mm': 0.045454547, 'r_value_unit': 'square_meter_kelvin_per_watt',
                                    'thermal_conductivity': 0.022, 'thermal_conductivity_unit': 'watt_per_meter_kelvin',
                                    'link': 'SPONs', 'created_at': datetime.datetime(2024, 9, 24, 13, 42, 52, 584553),
                                    'is_active': True, 'prime_material_cost': 15.12, 'material_cost': 25.96,
                                    'labour_cost': 30.7, 'labour_hours_per_unit': 1.3, 'plant_cost': 0.0,
                                    'total_cost': 56.66, 'notes': None, 'is_installer_quote': False},
    {'id': 2093, 'type': 'solid_floor_insulation', 'description': 'Ravatherm XPS X 500 SL Polystyrene Foam',
     'depth': 50.0, 'depth_unit': 'mm', 'cost': None, 'cost_unit': 'gbp_per_m2', 'r_value_per_mm': 0.032258064,
     'r_value_unit': 'square_meter_kelvin_per_watt', 'thermal_conductivity': 0.031,
     'thermal_conductivity_unit': 'watt_per_meter_kelvin', 'link': 'SPONs',
     'created_at': datetime.datetime(2024, 9, 24, 13, 42, 52, 584553), 'is_active': True, 'prime_material_cost': None,
     'material_cost': 11.07, 'labour_cost': 10.66, 'labour_hours_per_unit': 0.46, 'plant_cost': 0.0,
     'total_cost': 21.73,
     'notes': "In Spons, the thermal conductivity is 0.033 however the datasheet indicates it's 0.32: "
              "https://ravagobuildingsolutions.com/uk/wp-content/uploads/sites/30/2022/08/ravatherm-xps-x-500-sl-tds"
              "-version-1-20210901.pdf",
     'is_installer_quote': False},
    {'id': 2094, 'type': 'solid_floor_insulation', 'description': 'Ravatherm XPS X 500 SL Polystyrene Foam',
     'depth': 75.0, 'depth_unit': 'mm', 'cost': None, 'cost_unit': 'gbp_per_m2', 'r_value_per_mm': 0.03125,
     'r_value_unit': 'square_meter_kelvin_per_watt', 'thermal_conductivity': 0.032,
     'thermal_conductivity_unit': 'watt_per_meter_kelvin', 'link': 'SPONs',
     'created_at': datetime.datetime(2024, 9, 24, 13, 42, 52, 584553), 'is_active': True, 'prime_material_cost': None,
     'material_cost': 16.28, 'labour_cost': 10.66, 'labour_hours_per_unit': 0.46, 'plant_cost': 0.0,
     'total_cost': 26.94, 'notes': None, 'is_installer_quote': False}, {'id': 2095, 'type': 'solid_floor_redecoration',
                                                                        'description': 'Screeded beds; protection to '
                                                                                       'compressible formwork '
                                                                                       'exceeding 600mm wide',
                                                                        'depth': 0.0, 'depth_unit': None, 'cost': None,
                                                                        'cost_unit': None, 'r_value_per_mm': None,
                                                                        'r_value_unit': 'square_meter_kelvin_per_watt',
                                                                        'thermal_conductivity': None,
                                                                        'thermal_conductivity_unit': None,
                                                                        'link': 'SPONs',
                                                                        'created_at': datetime.datetime(2024, 9, 24, 13,
                                                                                                        42, 52, 584553),
                                                                        'is_active': True, 'prime_material_cost': 9.6,
                                                                        'material_cost': 9.89, 'labour_cost': 2.67,
                                                                        'labour_hours_per_unit': 0.15,
                                                                        'plant_cost': 0.0, 'total_cost': 12.56,
                                                                        'notes': 'This is the screed layer, '
                                                                                 'placed on top of the insulation',
                                                                        'is_installer_quote': False},
    {'id': 2096, 'type': 'solid_floor_redecoration', 'description': 'Fitting carpet', 'depth': 0.0, 'depth_unit': None,
     'cost': None, 'cost_unit': None, 'r_value_per_mm': None, 'r_value_unit': 'square_meter_kelvin_per_watt',
     'thermal_conductivity': None, 'thermal_conductivity_unit': None, 'link': 'SPONs',
     'created_at': datetime.datetime(2024, 9, 24, 13, 42, 52, 584553), 'is_active': True, 'prime_material_cost': None,
     'material_cost': 0.0, 'labour_cost': 6.59, 'labour_hours_per_unit': 0.37, 'plant_cost': 0.0, 'total_cost': 6.59,
     'notes': 'SPONs does not have data on re-fitting the carpet so we use the data in Fitted carpeting; Gradus woven '
              'polypropylene tufted loop\n\n as a baseline. We assume re-use of carpets, therefore we need just '
              'labour rates',
     'is_installer_quote': False}, {'id': 2097, 'type': 'solid_floor_redecoration',
                                    'description': 'Fitting existing softwood skirting or architrave to new frames; '
                                                   '150mm high',
                                    'depth': 0.0, 'depth_unit': None, 'cost': None, 'cost_unit': None,
                                    'r_value_per_mm': None, 'r_value_unit': 'square_meter_kelvin_per_watt',
                                    'thermal_conductivity': None, 'thermal_conductivity_unit': None, 'link': 'SPONs',
                                    'created_at': datetime.datetime(2024, 9, 24, 13, 42, 52, 584553), 'is_active': True,
                                    'prime_material_cost': None, 'material_cost': 0.01, 'labour_cost': 4.87,
                                    'labour_hours_per_unit': 0.12, 'plant_cost': 0.0, 'total_cost': 4.88, 'notes': None,
                                    'is_installer_quote': False}, {'id': 2132, 'type': 'external_wall_insulation',
                                                                   'description': 'EWI Pro EPS external wall '
                                                                                  'insulation system with Brick Slip '
                                                                                  'finish',
                                                                   'depth': 150.0, 'depth_unit': 'mm', 'cost': None,
                                                                   'cost_unit': 'gbp_per_m2',
                                                                   'r_value_per_mm': 0.02631579,
                                                                   'r_value_unit': 'square_meter_kelvin_per_watt',
                                                                   'thermal_conductivity': 0.038,
                                                                   'thermal_conductivity_unit': 'watt_per_meter_kelvin',
                                                                   'link': 'SCIS',
                                                                   'created_at': datetime.datetime(2024, 9, 24, 13, 42,
                                                                                                   52, 584553),
                                                                   'is_active': True, 'prime_material_cost': None,
                                                                   'material_cost': 0.0, 'labour_cost': 0.0,
                                                                   'labour_hours_per_unit': 0.0, 'plant_cost': 0.0,
                                                                   'total_cost': 298.35,
                                                                   'notes': 'This is the quoted value from SCIS',
                                                                   'is_installer_quote': True},
    {'id': 2133, 'type': 'low_energy_lighting_installation', 'description': 'Installation of fittings and cost of bub',
     'depth': 0.0, 'depth_unit': None, 'cost': None, 'cost_unit': 'gbp_per_unit', 'r_value_per_mm': None,
     'r_value_unit': 'square_meter_kelvin_per_watt', 'thermal_conductivity': None, 'thermal_conductivity_unit': None,
     'link': 'https://www.checkatrade.com/blog/cost-guides/cost-install-downlights/ '
             'https://www.hamuch.com/cost/led-spot-light#:~:text=It%20costs%20an%20average%20of,'
             'will%20drive%20up%20the%20cost.',
     'created_at': datetime.datetime(2024, 9, 24, 13, 42, 52, 584553), 'is_active': True, 'prime_material_cost': None,
     'material_cost': 20.0, 'labour_cost': 15.0, 'labour_hours_per_unit': 0.8, 'plant_cost': 0.0, 'total_cost': 35.0,
     'notes': 'We estimate the unit economics from the checkatrade article. We assume that the average job consists '
              'of installing 6 lights based on the hamuch article. We use the median value of 400 for a job of 6 '
              'lights',
     'is_installer_quote': False},
    {'id': 2147, 'type': 'flat_roof_insulation', 'description': 'Ecotherm Eco-Versal General Purpose Insulation Board',
     'depth': 150.0, 'depth_unit': 'mm', 'cost': None, 'cost_unit': 'gbp_per_m2', 'r_value_per_mm': 0.045454547,
     'r_value_unit': 'square_meter_kelvin_per_watt', 'thermal_conductivity': 0.022,
     'thermal_conductivity_unit': 'watt_per_meter_kelvin', 'link': 'SCIS',
     'created_at': datetime.datetime(2024, 9, 24, 13, 42, 52, 584553), 'is_active': True, 'prime_material_cost': None,
     'material_cost': 0.0, 'labour_cost': 0.0, 'labour_hours_per_unit': 0.0, 'plant_cost': 0.0, 'total_cost': 195.0,
     'notes': 'Rough estimate based on a quote from Nic on 30th May, but the cost is just a rough estimate',
     'is_installer_quote': True},
    {'id': 2149, 'type': 'windows_glazing', 'description': 'REHAU PVCu Casement Windows', 'depth': 0.0,
     'depth_unit': None, 'cost': None, 'cost_unit': 'gbp_per_unit', 'r_value_per_mm': None,
     'r_value_unit': 'square_meter_kelvin_per_watt', 'thermal_conductivity': None, 'thermal_conductivity_unit': None,
     'link': 'SCIS', 'created_at': datetime.datetime(2024, 9, 24, 13, 42, 52, 584553), 'is_active': True,
     'prime_material_cost': None, 'material_cost': 0.0, 'labour_cost': 0.0, 'labour_hours_per_unit': 0.0,
     'plant_cost': 0.0, 'total_cost': 1140.0, 'notes': None, 'is_installer_quote': True}
]
