The CIRCULAR REFERENCE was my problem, but I did not know how to get around it
What I want to do is have 1 sheet with a colum for the list of football teams and a a colum with ratings that I assign. Then I want to have a 2nd sheet where I just enter the team name in colum A and have the rating...
OK, well I have this thing working pretty good. Any idea how I can update the rating field where the original rating came from. I tried to use the VLOOKUP and just grab from the cell that had the new rating, but excel tells me that I can't have a formula get a figure from another formula...any...
I'm not sure what the issue is yet. I'm just happy to have a simple copy working for now. The next step will be getting it to work on 2 sheets so it looks cleaner.
I do have 1 more question now. I have my sheet set up that after the game the winning team gets a new rating value, I now want to...
Skip,
Thanks for the help, but I found a really good web site with alot of examples and I have the sheet working. It turns out the VLOOKUP worked best for me if I just had everything on 1 sheet instead of trying to use 2 sheets in the same work book. Here's the web site if anybody else wants...
Skip, Thanks for the help. Do you know of any place I could get examples. I seem to get things more when I can see them work. Even something simple would be great.
I would like to use excel to keeping track of football teams. I would like to have 1 sheet with 4 colums. col 1 for names, col 2 for wins, col 3 for loss's, col 4 for ties. Then in a 2nd tab of the same workbook I would like to be able to enter the name of the team and have it pull the...
I have a general question about Procomm. I want to be able to send a keep alive command to peice of equipment every 5 mins. Any idea's how I could do it only when I'm not sending a command. I have tried looking at the metakeys but do not see how I could put a timer on it.
ok guys, thanks for the help. I figured out why I was getting double showings in my logs, it was appending to my old files. I didn't notice that the box to over write the existing file was not checked.
here is the whole code, but pretty much what I pasted in is copied 4 times so I only pasted in the one section.
proc main
integer iEntries ;Number of entries in dialing class
integer iCount ;Loop variable
string sName...
The script logs in and checks the alarms then once it hits the last entry for the direcoty it does it again before moving on to the next directory.
set capture file "LA_Nav" ;sets caputure file to the file named in file_date proc
capture on ;turns on capture...
This script is working great now, thanks for all the help. I just noticed that when it dials the seprate groups it goes through the group twice before moving on to the next group, any ideas. I'm using the example from above still.
proc main
integer iEntries ;Number of...
thanks for all the help, the script works great now. going to start working on getting it to e-mail out but not yet, lol. last question thou, can I run a BAT file out of the script ???
The port number I placed in the connection directory after the IP address. Getting to the equipment is fine, but even with setting the echo at half duplex.
here's the error msgs I got
Error C002 Line 29: Missing space between tokens
Error C003 Line 29: Unexpected escape sequence
Error C002...
Still have not gotten the telneting with a port to work correctly yet, but still messing with it. My next question is can I use the " inside a line that I'm sending here's an example.
transmit "add user "netops"\m^M"
Knob, does procomm have a hard time with telneting to a port number. I have modifed the script to telnet to a port to send TL-1 commands and now the script will not close the capture file, I also noticed that in the TL-1 I don't see what the script is transmitting, is that normal also. It...
I just checked a little farther and my problem started when trying to only dial the group I created. Here is the script, do you see anything wrong with it.
proc main
integer iEntries ;Number of entries in dialing class
integer iCount ;Loop variable...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.