Create filter sets from excel

Revit
1

Hi I try to create filter from excel. Script works and I see my new filter but I don’t understand why values are different than in dynamo? Below my values:

image
image568×881 79.8 KB

And values in my created filter:
image
image453×226 12.3 KB

Values units are watts. Why values are different? Do You know how to fix it?

2

There are a lot of wires there
You need to show the whole thing

3

This appears to be a Revit internal units issue. A Watt’s base units are kg·m²·s⁻³ meaning Revit’s internal units are kg·ft²·s⁻³. So it appears you are imputing square feet values - so multiply by 10.7639

sq ft → sq m multiply by 144 / 1550
sq m → sq ft multiply by 1550 / 144

If you need it to be more accurate use 1550.0031

image
image738×525 29.5 KB

4

Omg thats it but how can I made my script bulletproof for any units format? Setting this for all projects one by one decrease time saving “value”.

5

You could use python to get the SpecType units from the Revit document and convert to internal

There’s a little bit of jiggery-pokey required as, for example SpecTypeId.Length returns a different ForgeTypeId than the one in UnitUtils.GetAllMeasurableSpecs() :person_shrugging: also Dynamo python strips the dictionary key text before the colon of the SpecTypeId label

""" Automatically convert numbers to internal Revit units based on SpecType"""

import clr

clr.AddReference("RevitServices")
from RevitServices.Persistence import DocumentManager

clr.AddReference("RevitAPI")
from Autodesk.Revit.DB import UnitUtils


def format_id(spec):
    """ Format spec type id label to get around issues
    with Dynamo python and Revit"""
    return spec.TypeId[14:].split("-", 1)[0].replace(":"," ")


def is_number(n):
    return isinstance(n, (int, float))

# Establish units for spec type
spectype = IN[1]

# Dictionary for lookups of Revit SpecTypeId
specs = UnitUtils.GetAllMeasurableSpecs()
specs = dict(zip(map(format_id, specs), specs))

spectypeid = specs.get(format_id(spectype))

doc = DocumentManager.Instance.CurrentDBDocument
units = doc.GetUnits().GetFormatOptions(spectypeid).GetUnitTypeId()


def to_internal(n, units=units):
    return UnitUtils.ConvertToInternalUnits(n, units)    


data = IN[0]

# data check
datalist = isinstance(data, list)
assert all(map(is_number, data)) if datalist else is_number(data)

OUT = map(to_internal, data) if datalist else to_internal(data)

image
image537×327 14.9 KB