On Fri, 1 Mar 2013 02:58:53 +0000, TimLeonard wrote:



HOW can the program know that Node 2 is being used if there are no loops
selected?
THere are a few ways nodes can be present with no loops for example

--A Voice panel, this one gets programmed using only zones...
--A Remote Annunciator is a node that is only to display what the panel
displays, but it would be located at the main entrance of a building for
the fire department to see the status of the main panel as they enter
the building.
--A computer workstation that is used to show the status of the system
on a computer with graphics is a node
--And there are cards that can page or email when a device is in alarm
or trouble that is considered a node...All of these have no loops.

As far as how the system knows...It just complies all the node
information down the list on the PanelData spreadsheet. I know on the
voice panel it just shows the node number and uses zeros for the loop
and has the zones Z000-Z999. I will need to double check how the others
that I mentioned are shown and if they capture the zones....I will post
this later as I will have to download it to find the answer

Did you solve the problem of the ambiguous name?
Yes i did, there was two macros with the same name


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+

I have not finished with the work to allow the engineer to add nodes or loops in the field yet, but I have a routine to check and return the differences between the CompareData and Summary sheets.
I have made some assumptions with I need to check with you.

I am considering differences to be either
Changes
Deletions
Additions

The comparison is run on the SUBSET of rows (on the Summary and CompareData sheets) that have an entry in the DeviceTypes column.
On Summary, if the engineer deletes the data in all of the columns we allow him to edit, the DeviceTypes entry will blank.
Since CompareData is derived from PanelData, and PanelData is downloaded from the field, I am assuming that PanelData will not include a DeviceType entry of 1 or 2 or 3 unless there is a Device present.

If that assumption is true, then:

1. Any row on the Summary sheet that has data in the first (ProjectNumber) column is "Changed"
2. Any row on the Summary sheet, where the data in the columns for
DeviceLabel
ExtendedLabel and/or
TypeCodeLabel
do not agree with the data in those columns for the row on the CompareData sheet that has the same Merged Address is "Changed"
3. Any row on the Summary sheet which contains a MergedAddress entry that does not exist on CompareData is an "Addition"
4. Any row on the CompareData sheet for which the MergedAddress does not exist on the Summary sheet is a "Deletion"

So I wind up with a list of MergedAddresses that can fall into one of the above three categories (and can be used to lookup the rest of the row).
How exactly would you want this information presented?

One way would be to have three tables
Added -- and give the row information from the Summary sheet
Deleted -- and give the row information from the CompareData sheet
Changed -- and I suppose for this we could output the data from both sheets
If we present the row information, do you want to present ALL of the columns? Or just a subset of the columns?

One further question: On PanelData, I have noted that unpopulated Extended Label fields are, in fact, populated with thirteen (13) spaces. Do you have any objection if, in creating the CompareData and Summary sheets, we remove these spaces?

Also, where are you located. I'm in Maine, in the US, and your responses usually get here in the evening local time.

-- Ron