Here's an Ideate BIMLink step-by-step video showing how occupancy load values can be calculated in Excel and then easily pushed back into Revit for use in Room Tags.
Ideate BIMLink works with Revit Extension so you can pull data from a Revit file into Microsoft Excel and push Excel data into Revit with equal ease.
Push. Pull. Power.