Custom ePlan P8 Macro Creation

My current project requires custom created eplan P8 macros for schematic symbols and terminal block. Required Skills: - Thorough understanding of ePlan P8 version 2.9 - Expertise in creating schematic symbols and Terminal block macros Key Attributes: - The macros should be compliant with specific company standards - Capability to incorporate detailed specifications inherent to my company standards We do project with 60plus of the same type of drives in them. I have attached example drive drawings with a spread sheet explaining the drawing references. Each drive has up to two motors attached, each motor has up to 2 pecs attached to them connected by a splitter(Junction Box) Each drive has a 24v bus system attached (3 wires) and also a ethernet bus. Each drive has a name, each motor has a name, each pec name is related to the motor name + e.g. “C04_PEC01”, likewise for all items on the page. There are currently 2 pages associated with each device, a device connection page and a single line drawing 95% of devices are as above but there are a few non standard that will need editing Our electrical design engineer only has about 2 years experience on eplan having learnt mostly on the job. Looking into our process I find that we are manually trying in the references, so for the 9 devices on the pages he manually types in 33 values. Ironically the device data exists in a spread sheet before the start of the drawing. We want to create these pages with the least amount of work, our initial thoughts are as the devices macro is inserted the pages are also inserted with the default layout and then we tweak those few non standard pages/devices We seek help in a 3 phase approach 1) Review existing database and drawings and advise best approach going forward, (maybe macro or script, it is open) 2) Modify existing 2 drive example project to the design determined in 1 above 3) Assist our electrical engineer to make a similar macro for a similar. (training)