How to Fill slot Number in Panel Schedule Cell

[Pravin_Lande]

Hi,

We want to add Slot Number in Panel schedule which will show Circuit numbers in Standard format.

The Column used in Panel Schedule is not having any parameter linked to the cells. we want to fill this column with Circuit Numbers in standard format like 1,2,3, etc. Attached is the screenshot for explaining the requirement with highlights in green.

Regards,

Pravin 

[jeremytammik]

Dear Pravin,

Thank you for your query.

First of all, how do you achieve this manually in the Revit user interface?

That is always the first question to ask before beginning to research how to solve a Revit API programming task:

http://thebuildingcoder.typepad.com/blog/2017/01/virtues-of-reproduction-research-mep-settings-ontol...

Do you simply fill in the numbers manually one by one?

That is obviously a tedious, mind-numbing and error prone task.

I would very strongly assume that it can easily be automated.

As a next step, you can use RevitLookup and other tools to analyse what modifications happen in the Revit database as a result of the manual interaction, and how they are represented there.

Have you performed this analysis yet?

What did you see?

What elements and properties are modified?

Is the schedule displaying the slot numbers accessible via the Schedule API?

It allows schedule views to be created, modified, and added to drawing sheets using the following classes:

• The ViewSchedule class that represents the schedule view. Its create methods are used to create new schedules.
• The ScheduleField class for the individual fields in a schedule.
• The ScheduleSheetInstance class represents schedules placed on sheets. The create method creates an instance of a schedule on a sheet.
• The ScheduleDefinition class defines the contents of a schedule view, including:
• Basic properties that determine the kind of schedule, such as the schedule's category.
• A set of fields that become the columns of the schedule.
• Filters that restrict the set of elements visible in the schedule.
• Sorting and grouping criteria.

https://thebuildingcoder.typepad.com/blog/2012/05/the-schedule-api-and-access-to-schedule-data.html

I hope this helps.

Best regards,

Jeremy