Link to home
Start Free TrialLog in
Avatar of curry199
curry199

asked on

collaberation on network

I have a client that has a big screen tv on the wall and has a networked computer attached to it.  They want to be able to show 'realtime' changes as they occur to a spredsheet or some sort of a scheduling program.  I need some suggestions.
Thanks
DAve
Avatar of SterlingMcClung
SterlingMcClung

I am not sure what type of suggestions you are looking for.  It sounds like the computer is already able to use the TV as a display, so are you asking for suggestions on the showing of realtime changes?  Are you asking for suggestions on specific scheduling software that can accomplish this?  Does the existing spreadsheet update in realtime when it is open on a computer?  How does this spreadsheet get the data that it contains(Manually entered or gathered from an external source)?
Is this for a conference call/net meeting or is this TV simply going to display data for others, sort of like a marquee?
Avatar of curry199

ASKER

Sorry I was not clear.
Real time changes are what I am looking for.  now they use an excel spreadsheet to enter schedules from various users.  But the spreadsheet that is open on the display computer does not reflect the changes until it is closed and reopened.  We want someway to show changes as they are entered.
cambo84
yes....like a marquee!
Okay - cool.  My answer is from a solution I did some time ago so there may be a better one out there but this does work.

On the computer running the spreadsheet, install the TV on it as a second monitor.  There are technologies that can send the HDMI signal over Ethernet cables to remote locations.  When the user updates the spreadsheet, her or she simple drags it over to their primary display and then moves it back to the secondary display when done (in this case the TV).

The other option is to have the two displays duplicated but then everyone sees the user's desktop and everything open on it.  That may not be desirable.

Some articles on getting your HDMI signal long distance:

http://www.popularmechanics.com/technology/how-to/tips/how-to-extend-your-hdmi-cables

http://lifehacker.com/5918457/hdmi-over-ethernet-adapter-extends-hdmi-connections-up-to-98-feet-saves-money
I need to check with client on how many people are entering info to the spreadsheet.  I think it may be more than a single person.
I'll get back to you
Instead of having a user drag the updated schedule to the other screen, it would probably be better to build a second spreadsheet that queries information from the "data" spreadsheet.  This can be setup in Excel to happen every so often, in order to refresh the data without human interaction.  This will also all the data entry spreadsheet to be in a slightly different format than the display screen, in case that makes more sense.  I will see if I can put together a quick example.
More than one scheduler posts data throughout the day.
Sterling
that sounds like it has possibilities!
ASKER CERTIFIED SOLUTION
Avatar of SterlingMcClung
SterlingMcClung

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Also, some of that information in the attached picture could be taken as personally identifiable, and it may be best to remove the picture.  Not an expert on that, but just a thought...
anyone know how to remove the example file?
Sorry.  Thought I had seen an edit button on a previous post, so I thought you could just edit it and remove it.  There is a "Request Attention" button just under your original post. Using that, a moderator might be able to help out???
sterling... thanks.  I will try the connect to another sheet suggestion tomorrow.  I will let you know and award points.
Thanks so much
works like a champ!  connector to another sheet.