Live Capture Of "Orbits" Race Data

Oct 5, 2006

I have a program running on my computer called Orbits.

What Orbits does is monitor a race track, and via a transponder in each race car, when a race car crosses the start/finish line Orbits will record that infomation.

The orbits program continually feeds data out the port 50000.

I can start hyper-terminal (yes the free one that comes with windows) and create a link the the computer running orbits. I use IP and port (Ex. and port 50000).

As the race is going on I can see the data in hyperterminal: Below is a sample.

$F,9999,"00:00:00","19:52:40","02:09:14","Green "
$F,9999,"00:00:00","19:52:41","02:09:15","Green "
$F,9999,"00:00:00","19:52:42","02:09:16","Green "
$F,9999,"00:00:00","19:52:43","02:09:17","Green "

What I would like to do Is to get this data LIVE into excel, as the race is going on.

I have no idea of to get this data into Excel since It is not saving it as a file.

View 9 Replies


How To Capture The Value From A Running Live Value

Jun 9, 2008

I have a cell (for example, "A1") which is inserted with a WINROS formula to retrieve some data into my spreadsheet. And it is running live at all time.

Actually, I can't think of any formulas to capture the value from cell "A1" to "B1". Because I do not want the value that I captured into cell "B1" running live. I just want the value "B1" fixed after captured.

View 9 Replies View Related

Summary Results Of Race Data

Oct 29, 2007

I have the following table for results in 7 races by 8 competitors (NB Not all competitors compete in every race)

Competitor Race 1 Race 2 Race 3 Race 4 Race 5 Race 6 Race 7

What I'd like to have is a table with summary results by the follwing criteria:

Most 1sts:
Most top 3:
Most bottom 2:
Lowest average position:
Highest average position:

What formulas would I have to use to get each of the 5 results?

View 9 Replies View Related

Live Data Download Through VBA

Jan 26, 2012

I wanted to know how to download live data (stock data from a a website) through VBA.

View 1 Replies View Related

Logging Live Data

Nov 30, 2008

I'd like to log live update data continuously,i.e. as the data in the cell changes. The problem I'm facing is that the data comes in at uneven intervals-- ranging from 30 to 50 ticks per second. So I can't really use a timer function. I need to use some function which saves the data as the cell value changes. So, for example, if cell A1 gets updated continuously, cell B1 could save the first value of A1 and then cell B2 could save the second value of cell A1-- and so forth.

View 9 Replies View Related

Display Live Internet Data

Jun 19, 2009

eg having a live rate of intrest or exchange rate from the internet that is updated live whenever you load up excel and you are connceted to the intenet.

View 14 Replies View Related

Multiple Live Feed / Data

Aug 28, 2009

I have set an excel spreadsheet set up to update live data from a URL every 5 minutes. However I am wanting to do try and save a bit of time if possible.

Basically I am monitoring horses bought on a game website. Each horse has the same URL except for the number at the end which goes up in 1 increments. The URL is already set up and when the horse is bought it changes from being blank to having the horses details etc.

At the minute I am able to autofill cells with each uinique URL using fill, then series menu. This is so I dont have to manually enter each URL, as hundreds may be bought each day so it would take too long to do this.

My question is this, am i able to have a automatic series linked to the 'data from web' function in data tab, instead of having to manually adjusting each URL for each individual horse.

View 9 Replies View Related

Connect Live Data In Sheet

Dec 30, 2009

How To Connect Live Data in an Excel Sheet?

I want to track changes in some Stocks, I have made a sample file in Excel and would like to make it Live by Connecting it to a website..

However, I do not know how to go about the same?Can some please provide some examples as well as a File if possible explaining how it was done..

View 9 Replies View Related

Excel Live 60 Min Data Real Time

Jun 8, 2014

I need a forex excel spreadsheet that shows me the last 60 min of usd/jpy in real-time. It has to update every 60 minutes automatically.

View 1 Replies View Related

Save Live Feed Data To Another Sheet Every 5 Min

Mar 26, 2014

I new to excel and vba , and i have live stock feed data in excel.

The live feed has 17 rows..of ticker names and more column about feed starts at 9.00 to 3.00

I want only 13th column data to save for every 5 new spreedsheet.

I am also including a sample : live crude.xls‎

View 1 Replies View Related

Web Query Stay Connected And Get Live Data From A Site?

May 7, 2009

Is there any way to have a web query stay connected and get live data from a site while still being able to use excel at the same time?

Basically the site has information that changes by the second and i need to keep a running record of it, and when it hits the variables needed i want to be able to trigger a set of code.

View 9 Replies View Related

Adding Submit Buttons To Transfer Data To Live Spreadsheet

Mar 18, 2014

I would like to set up a maintenance register where I would have:

worksheet 1 - a page where staff can choose a location and choose a maintenance issue and hit submit
worksheet 2 - after they have hit submit the detail will appear in designated cells in worksheet 2 (a ledger of maintenance issues). so each submit should send the info to a new line in worksheet 2.

I have a basic knowledge of Excel and have used formulas and functions before but not VBA/Macros. Any step by step through setting up the submit button and macro correctly?

I've tried to do Worksheet("Register").Range("A2").Value = Worksheet("Request").Range("A1") after installing a push button but all I get is errors.

View 5 Replies View Related

Race Track Chart

Jul 12, 2006

I am running a contest for my office and the theme is 'nascar'. Anyway - we'd like to chart the contestants using a racetrack. Is this possible in Excel or any other MS Office tool?

Basically I'd like to show the placement of ten contestants on a circular racetrack. It would be updated weekly.

View 3 Replies View Related

Isolating Race Numbers From Text?

Oct 29, 2012

I have the following examples of text in column A


I want to isolate the race numbers so thy are in column P as follows


View 8 Replies View Related

VBA To Calculate Profit & Loss Of Each Race Bet

Feb 1, 2009

I had a member make the MACRO in the attached spreadsheet some time ago, when i run it on the spreadsheet a runtime mismatch error occurs. I cant find the mismatch.

View 4 Replies View Related

Race Car Driver Comparision Tool

Jul 30, 2006

1: two colums of data for each car (lap distance covered and speed). Now each driver is going to decide to brake at different points.
2: i have coner data (eg corner 1 is at 150meters to 200 meters, corner 2 is at etc)
3. I am trying to create something that will do the following.

determine the lap distance at which the driver is braking (the point where speed decreases). I would like to do this for each corner and each driver. I am struggling to find a way of determining how to read the "lap distance" value when the corresponding "speed" value stops increasing and actually starts to decrease. This is the point at which the driver is braking

View 9 Replies View Related

How To Capture Streaming Data

Oct 6, 2007

I have streaming data coming into my excel spreadsheet. The data is in 1 cell and its a number that changes almost every second. How can I capture and store this data.

View 1 Replies View Related

Find And Capture Data

Jan 24, 2007

I need to find a term "aa" and upon finding this term, the term on the right must be "bb" before we capture the number. Output will be 15 for this case.

Note that we do not know which cell "aa" will occur in, but the term "bb" will always be on the right of "aa". Can anybody help me with this? I have attached an example for your reference. Hopfully by modifying the below code, i can get the value i desired.

Sub test2()

Dim xx As Variant

Set rng = Cells.Find(What:="aa" , After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
If Not rng Is Nothing Then xx = rng.Offset(0, 3).Value
MsgBox xx
If rng Is Nothing Then xx = 0
MsgBox xx

End Sub

View 8 Replies View Related

Sum Of Lap Times In Order To Give Race Time At Any Lap

Apr 13, 2009


Where C4 is 'Qualifying time', C5 is 'Starting fuel', C2 is 'Lap number' and C3 is 'Fuel consumption'. I also plan to make the 0.3 a changeable variable.

I'm not fussed as to whether or not this is a realistic function that would work in a real race, it's only hypothetical. However I would like to have a function that would give me the over all race time at any given lap, not just the lap time for it.

View 7 Replies View Related

Formula To Capture Data In Cells That Are After It

Aug 12, 2009

I have a moving average spreadsheet that I am having trouble with. In column F of 'Data for Pivot' Tab, I have a set of data that doesn't begin populating until 101 data points (cell C8 in 'Mov_Avg_Chart' is the input; in this cell F138 of 'Data for Pivot' tab) after data begins populating in Column E of 'Data for Pivot' Tab (in this case data begins populating in Column E in row 38).

What I would like to do is have the data in cells F38 to F137 = the value in cell F138. From there on forward (cells F138 and onwards), I would like the formula to calculate data in the same way as it is currently calculating it. That is, I would like the values in cells F38 to F137 be 0.00110 (in the current example). However, the data will be constantly changing. Thus, sometimes the data in column F will begin at a different cell than cell F138. In essence, I want the formula: when column E begins populating data but column F has not, I want those column F values to equal the value of the first populated value in column F (which is usually numerous cells below this value).

I just can't seem to get this one right after spending considerable time on it. I would appreciate any help you can give on this.

View 10 Replies View Related

Data Auditing - Capture Changing?

Jul 10, 2014

I have an excel file with column stating month and rows are phases ... for each Phases we add the revenue numbers by month and it does keep changes as and when scope changes. However, i am finding it difficult to capture the changes ... is there a way i can set the guidelines to ensure all historical data changes as and when any updates and it should store the historic inputs for consolidation ... i would like to be called as Baseline, Re-baseline1, Re-beseline2 like wise.

Sample attached : sample_auditing.xlsx‎

View 13 Replies View Related

Combobox Data Capture From Other Workbook

Nov 20, 2007

how data capturing works, using controls. I try to explain what I mean. I have a userform with a combobox that allows to select data from a worksheet in another workbook (database). Using VBA, I'm asked to define the "source" for the combobox. I don't understand the difference between controlsource and row source because when I close the userform, I find only the first field filled in (column "A"), while I would like the entire row to be copied.I also would like to have an "ok" button to allow me for multiple selection. In other words:

I select the desired data from the combobox
I click on the "ok" button ahd this event should copy the data (entire row) selected via the combobox on my worksheet without closing the userform in order to allow me to select other data on the same session. The row to copy data into is selected using the firstemptyrow method..

View 4 Replies View Related

Trying To Capture Point In Time Data In New Fields Each Day

Oct 2, 2008

Trying to capture data from specific fields (which are populated with live data collected elsewhere) into new fields based on date. Ex:

A1 - A4 have "totals" derived from an external source, and the fluctuate daily.

I want to take today's totals and drop them into D1 - D4. Tomorrow, I want totals dumped into E1 - E4, the next day they go into F 1- F4, and so on... in other words, I'm tracking daily totals over time.

I've started with a macro that I would attach to BeforeSave as follows--

View 2 Replies View Related

Formula To Capture Completed Status For Relevant Data

Apr 2, 2014

I have attached the the excel sheet where in i want to calculate the total number of completed data points for one person.

Let's say "Wasim" would have completed 7 tasks and would updated the relevant cell as Completed.

Now in a huge data list How will i find "Wasim" and how do i calculate how many he has completed.

I believe Pivot table would be the answer here but is there any formula which would replace the pivot table?

(Please see the attachment) Example.xlsx

View 2 Replies View Related

Capturing Data: Capture Fleet No & Model From Book 1

Oct 22, 2009

find the attached file. Book 2 there is 4 columns ie,reg no,fleet no,product & model and on book 1 there is fleet no,reg no and model and what i need is to capture fleet no & model from Book 1.

View 2 Replies View Related

Macro To Capture Data From A Specific Cell Upon Selection Changes

May 22, 2007

I'm trying to do is definetly simple to a lot of you, but I'm struggling on how to get started. I attached a workbook that clearly shows my work! I'm almost there but not quiet. Basically the user will be able to make a slection that will be used to lookup values from a different sheet. Each selection triggers a ranking number at the bottom (red pattern) in the worksheet. Now I would like to capture all scenarios and display the ranking.

View 4 Replies View Related

Capture External Data Refresh Date & Time

May 29, 2008

In the Data tab under Connection Properties, I have "Refresh every x minutes" checked. Question is how do I capture in a cell within a sheet the last time it was refreshed?

View 2 Replies View Related

Capture And Calculate Data Based On Work Week In VBA Or Formulas

Jul 21, 2014

I have a requirements to capture the data and calculate the qty based on the defined work week. How to to this in vba macro or a formulas. I'll giving a sample data as reference. In my sample data i have already the formulas
but i wanted to automate the work week calculation specially if the number of days in a month has been change.

Btw, the values of every column is came from other worksheet. i copy paste this data as my sample.

For ex : Today is July and it has 31 days, the 31 days will be distributed to the defined workweek and calculate the contents of the corresponding column.

here is the distribution of columns per week as reference.

(31 days)
wk1 - Day1 to Day8 (8 colums)
wk2 - Day9 to Day16 (8 colums)
wk3 - Day17 to Day24 (8)
wk4 - Day25 to day 31 (7) columns

(30 days)
wk1 - Day1 to Day8 (8 colums)
wk2 - Day9 to Day16 (8 colums)
wk3 - Day17 to Day23 (7)
wk4 - Day23 to day 30 (7) columns

View 1 Replies View Related

Consolidating Live Tables

Nov 26, 2008

I have two tables that pull data from two different SQL tables via an ODBC connection and refresh every 5 minutes. The table headers etc are all identical (it is support call information FYI) but what I want to do is display those tables as one as opposed to two seperate tables - can this be done relatively easily and hopefully without the use of VBA? (Unless anyone is willing to provide the code of course!!)

View 9 Replies View Related

How To Get An Actual Live Clock

Nov 29, 2009

I am looking to get a Live Clock changing every minute..

Lets say I put the Total Time in the Cell A2 = 15 minutes and I have a Command Button next to it "Start"..

On the Click Event I want the Actual Time time-stamped at that moment in the Cell A3 and in Cell A4 the Time should keep on Ticking...

Can someone attach a file in Windows 2003 i.e .xls format and also explain the code if possible.

View 9 Replies View Related

Copyrights 2005-15, All rights reserved