cmothebean
Member
Hi,
I use Excel to write some routines and was wondering if it is possible to add rung comments when doing so?
Excel function:
="MOV "&[@[Range Type]]&" "&AI_Config&".R"&[@Rack]&".S"&[@Slot]&".AI"&[@Ch]&".RangeType BST MOV "&[@[Low mA]]&" "&AI_Config&".R"&[@Rack]&".S"&[@Slot]&".AI"&[@Ch]&".Input_Min NXB MOV "&[@[High mA]]&" "&AI_Config&".R"&[@Rack]&".S"&[@Slot]&".AI"&[@Ch]&".Input_Max BND BST MOV "&[@[Low EU]]&" ">_AI_Config&".R"&[@Rack]&".S"&[@Slot]&".AI"&[@Ch]&".Output_Min NXB MOV "&[@[High EU]]&" "&AI_Config&".R"&[@Rack]&".S"&[@Slot]&".AI"&[@Ch]&".Output_Max BND BST MOV "&[@[Filter Time Base (ms)]]&" "&AI_Config&".R"&[@Rack]&".S"&[@Slot]&".AI"&[@Ch]&".FilterTimeBase NXB MOV "&[@[Filter Ratio]]&" "&AI_Config&".R"&[@Rack]&".S"&[@Slot]&".AI"&[@Ch]&".FilterRatio BND EOR SOR AI_Config "&AI_Config&".R"&[@Rack]&".S"&[@Slot]&".AI"&[@Ch]&" "&O_SCADA_Tag&".R"&[@Rack]&".S"&[@Slot]&".AI"&[@Ch]&" "&RackName&":"&[@Slot]&":I.Ch"&[@Ch]&"Data "&O_Program_PV_V&".S"&[@Slot]&".AI["&[@Ch]&"] "&RackName&":"&[@Slot]&":C.Ch"&[@Ch]&"Config.RangeType "&RackName&":"&[@Slot]&":C.Ch"&[@Ch]&"Config.LowSignal "&RackName&":"&[@Slot]&":C.Ch"&[@Ch]&"Config.HighSignal Local:"&[@Slot]&":C.Ch"&[@Ch]&"Config.LowEngineering "&RackName&":"&[@Slot]&":C.Ch"&[@Ch]&"Config.HighEngineering"
Thanks,
cmo
I use Excel to write some routines and was wondering if it is possible to add rung comments when doing so?
Excel function:
="MOV "&[@[Range Type]]&" "&AI_Config&".R"&[@Rack]&".S"&[@Slot]&".AI"&[@Ch]&".RangeType BST MOV "&[@[Low mA]]&" "&AI_Config&".R"&[@Rack]&".S"&[@Slot]&".AI"&[@Ch]&".Input_Min NXB MOV "&[@[High mA]]&" "&AI_Config&".R"&[@Rack]&".S"&[@Slot]&".AI"&[@Ch]&".Input_Max BND BST MOV "&[@[Low EU]]&" ">_AI_Config&".R"&[@Rack]&".S"&[@Slot]&".AI"&[@Ch]&".Output_Min NXB MOV "&[@[High EU]]&" "&AI_Config&".R"&[@Rack]&".S"&[@Slot]&".AI"&[@Ch]&".Output_Max BND BST MOV "&[@[Filter Time Base (ms)]]&" "&AI_Config&".R"&[@Rack]&".S"&[@Slot]&".AI"&[@Ch]&".FilterTimeBase NXB MOV "&[@[Filter Ratio]]&" "&AI_Config&".R"&[@Rack]&".S"&[@Slot]&".AI"&[@Ch]&".FilterRatio BND EOR SOR AI_Config "&AI_Config&".R"&[@Rack]&".S"&[@Slot]&".AI"&[@Ch]&" "&O_SCADA_Tag&".R"&[@Rack]&".S"&[@Slot]&".AI"&[@Ch]&" "&RackName&":"&[@Slot]&":I.Ch"&[@Ch]&"Data "&O_Program_PV_V&".S"&[@Slot]&".AI["&[@Ch]&"] "&RackName&":"&[@Slot]&":C.Ch"&[@Ch]&"Config.RangeType "&RackName&":"&[@Slot]&":C.Ch"&[@Ch]&"Config.LowSignal "&RackName&":"&[@Slot]&":C.Ch"&[@Ch]&"Config.HighSignal Local:"&[@Slot]&":C.Ch"&[@Ch]&"Config.LowEngineering "&RackName&":"&[@Slot]&":C.Ch"&[@Ch]&"Config.HighEngineering"
Thanks,
cmo