1. First step is to locate electrical dataset. From Workspace>Configuration look for variable BBESDATA. This variable points to electrical dataset.
2. Use windows explorer to navigate to electrical dataset (the location BBESDATA points to).
3. Locate Metadata folder under electrical dataset.
4. Using Notepad open File New_Panel_Schedule.PSF
5. Using Save As option save it as New_Panel_Schedule_84_poles.PSF
6. In New_Panel_Schedule_84_poles.PSF make following changes:
7. Change entry HowMany to 84 (new schedule has 84 poles)
[PHASE]
HowMany=84
Notice pattern of Cell definitions. Odd numbered Cells 1-83 stand for odd numbered circuits.
J,O and T stand for phases a,b and c.
8. Add additional entries after
Cell41=T28
As shown below:
Cell43=J29
Cell45=O30
Cell47=T31
Cell49=J32
Cell51=O33
Cell53=T34
Cell55=J35
Cell57=O36
Cell59=T37
Cell61=J38
Cell63=O39
Cell65=T40
Cell67=J41
Cell69=O42
Cell71=T43
Cell73=J44
Cell75=O45
Cell77=T46
Cell79=J47
Cell81=O48
Cell83=T49
9. Add additional entries after
Cell42=AK28
As shown below:
Even numbered Cells 2-84 stand for even numbered circuits.
Cell44=AA29
Cell46=AF30
Cell48=AK31
Cell50=AA32
Cell52=AF33
Cell54=AK34
Cell56=AA35
Cell58=AF36
Cell60=AK37
Cell62=AA38
Cell64=AF39
Cell66=AK40
Cell68=AA41
Cell70=AF42
Cell72=AK43
Cell74=AA44
Cell76=AF45
Cell78=AK46
Cell80=AA47
Cell82=AF48
Cell84=AK49
10. Under [DESCR] area change how many to 84
[DESCR]
HowMany=84
Description is actually Load description that is defined in Panel Manager.
11. Add additional entries after
Cell41=B28
As shown below:
Cell43=B29
Cell45=B30
Cell47=B31
Cell49=B32
Cell51=B33
Cell53=B34
Cell55=B35
Cell57=B36
Cell59=B37
Cell61=B38
Cell63=B39
Cell65=B40
Cell67=B41
Cell69=B42
Cell71=B43
Cell73=B44
Cell75=B45
Cell77=B46
Cell79=B47
Cell81=B48
Cell83=B49
12. Add additional entries after
Cell42=AR28
As Shown below:
Cell44=AR29
Cell46=AR30
Cell48=AR31
Cell50=AR32
Cell52=AR33
Cell54=AR34
Cell56=AR35
Cell58=AR36
Cell60=AR37
Cell62=AR38
Cell64=AR39
Cell66=AR40
Cell68=AR41
Cell70=AR42
Cell72=AR43
Cell74=AR44
Cell76=AR45
Cell78=AR46
Cell80=AR47
Cell82=AR48
Cell84=AR49
13. Change [TYPE] HowMany to 84
TYPE stands for load type defined in Load section in Symbol Manager. Purpose is to distinguish between different load types, for example, Lighting (L), receptacles (R), Motors (M)....
[TYPE]
HowMany=84
14. Add additional entries after
Cell41=Y28
As shown below:
Cell43=Y29
Cell45=Y30
Cell47=Y31
Cell49=Y32
Cell51=Y33
Cell53=Y34
Cell55=Y35
Cell57=Y36
Cell59=Y37
Cell61=Y38
Cell63=Y39
Cell65=Y40
Cell67=Y41
Cell69=Y42
Cell71=Y43
Cell73=Y44
Cell75=Y45
Cell77=Y46
Cell79=Y47
Cell81=Y48
Cell83=Y49
15. Add additional entries after
Cell42=Z28
As shown below:
Cell44=Z29
Cell46=Z30
Cell48=Z31
Cell50=Z32
Cell52=Z33
Cell54=Z34
Cell56=Z35
Cell58=Z36
Cell60=Z37
Cell62=Z38
Cell64=Z39
Cell66=Z40
Cell68=Z41
Cell70=Z42
Cell72=Z43
Cell74=Z44
Cell76=Z45
Cell78=Z46
Cell80=Z47
Cell82=Z48
Cell84=Z49
16. Change [POLES] HowMany to 84
[POLES} Stands for breaker poles 1,2 or 3. Breaker selection is part of circuit setup process in Panel Manager.
[POLES]
HowMany=84
17. Add additional entries after
Cell41=H28
As shown below:
Cell43=H29
Cell45=H30
Cell47=H31
Cell49=H32
Cell51=H33
Cell53=H34
Cell55=H35
Cell57=H36
Cell59=H37
Cell61=H38
Cell63=H39
Cell65=H40
Cell67=H41
Cell69=H42
Cell71=H43
Cell73=H44
Cell75=H45
Cell77=H46
Cell79=H47
Cell81=H48
Cell83=H49
18. Add additional entries after
Cell42=AQ28
As shown below:
Cell44=AQ29
Cell46=AQ30
Cell48=AQ31
Cell50=AQ32
Cell52=AQ33
Cell54=AQ34
Cell56=AQ35
Cell58=AQ36
Cell60=AQ37
Cell62=AQ38
Cell64=AQ39
Cell66=AQ40
Cell68=AQ41
Cell70=AQ42
Cell72=AQ43
Cell74=AQ44
Cell76=AQ45
Cell78=AQ46
Cell80=AQ47
Cell82=AQ48
Cell84=AQ49
19. Change entry [BREAKER] to HowMany=84 as shown below:
BREAKER] stands for breaker size. Breaker sizes are selected as part of circuit setup process in Panel Manager.
[BREAKER]
HowMany=84
[
20. Add additional entries after
Cell41=I28
As shown below:
Cell43=I29
Cell45=I30
Cell47=I31
Cell49=I32
Cell51=I33
Cell53=I34
Cell55=I35
Cell57=I36
Cell59=I37
Cell61=I38
Cell63=I39
Cell65=I40
Cell67=I41
Cell69=I42
Cell71=I43
Cell73=I44
Cell75=I45
Cell77=I46
Cell79=I47
Cell81=I48
Cell83=I49
21. Add additional entries after
Cell42=AP28
As shown below:
Cell44=AP29
Cell46=AP30
Cell48=AP31
Cell50=AP32
Cell52=AP33
Cell54=AP34
Cell56=AP35
Cell58=AP36
Cell60=AP37
Cell62=AP38
Cell64=AP39
Cell66=AP40
Cell68=AP41
Cell70=AP42
Cell72=AP43
Cell74=AP44
Cell76=AP45
Cell78=AP46
Cell80=AP47
Cell82=AP48
Cell84=AP49
22. This concludes changes to New_Panel_Schedule_84_poles.PSF . Save this file in Metadata folder.
23. Next step is to add excel template file that will be used for 84 pole panel schedule.
From Metadata folder open file NEW_PANEL_SCHEDULE.xls
24. Using File Save as option save this file as NEW_PANEL_SCHEDULE_84_POLES.xls
25. Add additional rows for circuits 43-84 to the existing schedule. Easiest way is to copy existing rows for circuits 1-42, paste it after circuit 42 and change numbers to reflect new circuits 43-84.
26. Excel spread sheet has formulas imbedded. Select option to view formulas and modify each to include additional rows 29-49.
27. For example existing formula for Lighting load in phase A is
=SUMIF($Y$8:$Y$28,"=L",J8:J28)+SUMIF($Z$8:$Z$28,"=L",AA8:AA28)
Change this to
=SUMIF($Y$8:$Y$49,"=L",J8:J49)+SUMIF($Z$8:$Z$49,"=L",AA8:AA49)
The only change we are making is changing previous number of rows 28 to new number of rows 49.
28. Change all remaining formulas and save NEW_PANEL_SCHEDULE_84_POLES.xls into metadata folder.
29. When generating panel schedules, (Electrical>Output>Panel Schedules L+P) new option New_Panel_Schedule_84_poles.PSF is now available. By selecting it, new 84 poles panel schedule will be generated using file NEW_PANEL_SCHEDULE_84_POLES.xls as template.
