Manual and Help for add-in Broadcaster - Real Time Excel Network

-> Content

Previous: 2. USAGE

Next: 2.2.8. Data Receiving

---

2.2. System Tools

Access:

• Menu - Broadcaster | Help on line
• - Toolbar Broadcaster

Description: Open the browser Internet Explorer or Netscape in manual and help of system functions page.

Access:

• Menu - Broadcaster | Status
• - Toolbar Broadcaster

Description: Allows user to follow system version updates as well his signature/license. If system signature/license expire, all the system will we disabled and will return #N/A (version 1.0.4 and older) or !Expired! (version 1.0.5).

There is some possibilities for the status indicator:

• - Normal system use.
• - Next to expire.
• - System unavailable - signature/license must be renewed.

2.2.3.1. Excel Network Status

Access:

• - Toolbar Broadcaster

Description: Show the actual connection status of Microsoft Excel. It Does not execute any effective system operation.

The connection status can be:

• - Disconnected from Real Time Excel Network.
• - Connected to Real Time Excel Network.

The connections are realized at the Microsoft Excel instances level.That is, it is possible to connect or to Disconnect instances independently. If an instance is connected, all the archives opened in this instance will be able to use the CoRTEx.In the same way, if an instance is disconnected, none of the archives opened in it will be able to use CoRTEx.

Each Excel instance open have a connection status indicator independent from the others.

Access:

• Menu - Broadcaster | Idiom

Description: Allows to configure the add-in idiom.

Is possible configure the system to Portuguese (Brazil) ou English (USA).
After changing the idiom, will be necessary restart Microsoft Excel.
The option for idiom changes are available on version 1.0.3 and newer.

2.2.5.1. Connect Command

Access:

• Menu - Broadcaster | Conectar
• - Toolbar Broadcaster

Description: Connect a instance of Microsoft Excel to the Real Time Excel Network (CoRTEx).

When a connection is established, the connection status indicator changes to "Connected to Real Time Excel Network” and the connecting options are disabled, with the consequent unlocking the disconnection options.
After a instance establish connection, is possible to send and receive data in Excel through the CoRTEx.

The connection speed of a certain instance to the CoRTEx depend from some factors, including such hardware characteristic (i.e. processor speed, RAM etc.) as the amount of data transmitted. Although, there is not a established limit to the amount of data transmitted over a Excel instance.

When opening a new archive in the Excel and before connecting the CoRTEx, can be necessary to save the file or an error of moniker will be presented. It happens cause to establish the network, the system needs to access data about the file and, depending of the Windows version or updates, this data about the file are only able after saving. Again, it may be necessary only in the first connection and when done by a new file.

By Excel limitations, we advise to not open the same file in differents Excel instances. If the CoRTEx is started the first time in a instance, being that a same file of this instance is opened in another one, may occur inconsistencies in system functions, If, although, user need to use Real Time Excel Network for two Excel instances, being that each one contain a copy of the same file, user first need to connect to CoRTEx and later open the file copied. This will prevent updates errors in Excel Instances.
If a instance is not connected, all the recalculated cells will inform error #NUM (version 1.0.4 and older) or !Disconnected! (version 1.0.5).

Excel 97 limitations
The system use a set of auxiliar functions to work correctly , and the version 97 does not have one of this functions.
The system, although, can work correctly in Excel 97, but is necessary, when a new file is opened, force a manual calculation in the cells of its spread sheets that contain the system functions.
It can be manual, cell by cell (less efficient) or through a keyboard shortcut CTRL + ALT+ SHIFT + F9, which recalculate all cells at once.

2.2.6.1. Disconnect Command

Access:

• Menu - Broadcaster | Disconnect
• - Toolbar Broadcaster

Description: Disconnect a instance of Microsoft Excel from Real Time Excel Network (CoRTEx).

After disconnected, the status indicator changes to "disconnected from Real Time Excel Network”, the connection options are enabled and the options to disconnect disabled. While disconnected, a Excel instance can't use send and receive data functions.

Before closing a spread sheet connected to CoRTEx or close Microsoft Excel or also shutdown the computer, we advise to disconnect. This increases the perfomance for the remain of Real Time Excel Network.

The connections to CoRTEx are over the Microsoft Excel instance level. Although, all instances have a unique representation on the network.
When user use much (or only one) excel instances connected to CoRTEx, the "computer name" is used to represent it to others computers. In other way, all the instances are restricted to one computer and this computer is who participates effectively of CoRTEx through its "name".

It's important know, so, how your instances will be identified in the network.

2.2.7.1. My Computer Command

Access:

• Menu - Broadcaster | My computer

Description: Return the computer or workstation name (in version 1.0.5 also returns the IP) through a message for the user.This name its used in Real Time Excel Network to identify all Excel instances of the workstation which are connected.

This command its a way to user know his computer identity and does not execute any effective operation.

-> Content

Previous: 2. USAGE

Next: 2.2.8. Data Reception