Originally Posted By -Obsessed-:


So basically, no change vs regular LabRadar? Since the BT module is worthless.

Originally Posted By ronemus:


Bluetooth is fixed with the latest firmware update.

Originally Posted By Tao:
So what's the best way to remove garbage/unwanted series, and keep the good stuff?

Originally Posted By Bandit432:
@-Obsessed-

Version 1.04 is crashing after importing the first record for me.


EditionWindows 11 Home
Version22H2
Installed on‎5/‎9/‎2022
OS build22616.1
ExperienceWindows Feature Experience Pack 1000.22632.1000.0

Office 365, running from the root of the SD Card.  Ver 1.0 and 1.02 are importing just fine.

Let me know if you need more details.

VR
Pitt

Originally Posted By -Obsessed-:


Thanks for the info. I'm digging into it now. I noticed that the BC calc crashes it under curtain circumstances.

You can jump back to 1.03 if need be for now until I can sort through it. Hope to have it straightened out this weekend.

To that point I may keep all versions linked and available to those that want/need it.

Sorry for the trouble and I appreciate the patience.

ETA: @Bandit432

Try This: LabRadar Data Consolidation Tool V1.0.4b

This fixed it for me.  It was just getting ahead of itself a bit, so slowed down the BC calculation routine by allowing DoEvents before merging ranges and that seemed to fix it on my end.

IM me if it doesn't fix it and we'll troubleshoot it together.

Originally Posted By AKSnowRider:

You are a great asset Obsessed....

Originally Posted By -Obsessed-:
Okay, my old thread fell into archives, so reviving it as we've had a huge influx of LR owners in the past 3 years since I last did this.

So, what is this jazz you ask? It's a LabRadar Data Consolidation Tool!

For those that are uninitiated, the LabRadar is THE chronograph to have.  However, it is not perfect.  One of the more annoying things about the LR is the way in which it manages files.  Every series gets its own folder.  Within that folder, there is a summary file, and then a folder of shots.  When you enter that folder, you have individual shot files.  It literally writes a workbook for every shot.  Annoying!

Here is how it looks, as it comes from the SD Card:

https://www.ar15.com/media/mediaFiles/467079/Tree-1_jpg-2299445.JPGhttps://www.ar15.com/media/mediaFiles/467079/Tree-2_jpg-2299446.JPGhttps://www.ar15.com/media/mediaFiles/467079/Tree-3_jpg-2299447.JPG

So, the tool I created is a VBA driven consolidation tool that takes all the data in ALL those spreadsheets, and consolidates it into a single workbook.  What's better, is the tool can pull series in at any time! So, you can just keep a "master" workbook that you just import new series into every time you get back from the range.

Here is what the tool looks like when you open it:

https://www.ar15.com/media/mediaFiles/467079/LR-Welcome_jpg-2299448.JPG

It has instructions, and the disclaimer that I am in NO way affiliated with LR...I am just a happy customer that saw an opportunity to improve the process for myself. Then I told others about it and shared it.

You click import, and a status bar splash screen will appear to let you know that it is importing the data.

The end result is a single tab for each series.  Create a new series on the LR, and it will end up as its own tab, with each shot in that series all in the same tab.

Here is an example, instructional screen grab of what is included in this newly created tab:

https://www.ar15.com/media/mediaFiles/467079/LR-Details_jpg-2299452.JPG

The top left has some administrative stuff: Device ID (Your LR ID), Series number, number of shots in series, and the units that the unit is set to for velocity, distance, kinetic energy, and bullet mass.  These are typically unchanged. Then below that are the stats of the series: Mean Velocity, STD Dev, ES, etc etc. Note these are formulas, and update in real time if you delete shots from the series (more on that later).

In the yellow section at the top, you enter in the recipe details: Load Description, Projectile, Powder, Primer, and Case info.  The projectile weight is then used to calculate the KE and PF in the chart below.

There are two charts shown, each with heat maps to show, visually, the different velocities, and can be used to QUICKLY identify shots that may have inaccurate readings. The velocity table is on the left, and the KE is on the right, each with their own color gradients.  To the right of each shot in the tables, there is a gray "Delete" button. Clicking this will remove that shot from the sheet.  The stats of that series will then be updated in real time to reflect the change.  This is NOT possible in the original data...if you wanted to delete a shot, you had to do it on the unit itself (or trough the app) before pulling it off the SD card.

At the bottom of the tab is the readings of the individual shots...this includes time, velocity, distance, and SNR.  This again allows you to quickly spot shots with inaccurate readings.  You can also use this data to calculate BCs if you like Calculus.

That pretty much sums it up!

Expecations:

• I expect you to tell me you're giving this a whirl.  I'm providing this free of charge...the least you can do is tell me you're using it. I want to know if my effort is actually being utilized/appreciated.


• I expect feedback.  If there is something that isn't working correctly, please tell me.  I'm not a professional programmer, and I'm only a sample size of 1, so there may be bugs. The goal is to fix bugs and also implement changes and improvements/capabilities that do not exist today in the tool.  I want this to be a tool for the people. So please tell me what you'd like to see in it.


• Please have a respectable, open discussion in this thread.  All responses in relation to the above two bullet points can be posted directly in this thread, via email, via private message, whatever. I don't care, but I'd prefer you at least help keep this an active discussion as I want this to be a living thread.  The last one fell into the archives pretty fast, and once that happens I can't update the link to the file, etc, and then I get emails asking for help on a file I haven't updated in ages for the rest of time.

So, now that you made it through this wall of text, here is the file! Let me know what you think!

LabRadar Data Consolidation Tool V1.0.4c

@lilMAC25
@arowneragain
@Redarts
@BuckeyeRifleman
@rob78
@DevilDog0402
@wildearp
@magnum_99
@montyw42
@MrEG
@RePp
@762SR25
@NFA-Joe
@popnfresh
@Kuraki
@AKSnowRider
@JQ66
@SeaDog951
@jakjakman
@AeroEngineer
@Haveme1
@MadCowRacer
@optoisolator
@Bubbatheredneck
@ppknut

Excel was able to open the file repairing or removing the unreadable content"

Removed Part: /xl/styles.bin part.  (Styles)
Repaired Records: Cell information from /xl/worksheets/sheet1.bin part
Repaired Records: Cell information from /xl/worksheets/sheet2.bin part

Originally Posted By lazyengineer:

I like OP's version, as this lets me consolidate my files into something useful to work with.  Though, FWIW, when I open it up in Excel, I get this error message:

Originally Posted By Tao:
To upgrade when a new version is released, I just remove the old one from the SD card and copy the new one in?

Or will that reset the changes I've made to the series in the spreadsheet?

Originally Posted By -Obsessed-:

Would it be helpful if it actually deleted the shot from the folder itself that way changes are persistent import to import?

Alternatively (or in addition to?) I can build upgrade functionality into the tool where it can update old versions of the sheet. I see that being more difficult, but possible, to pull off.

Originally Posted By Tao:


Absolutely, so long as the undo button works. I'd prefer this, because it just eliminates the garbage data altogether.

Being able to just update the whole thing would definitely also be great.

Originally Posted By -Obsessed-:


No undo button. I'll put an "Are you sure Tao?" Prompt in there as a next best alternative.

Originally Posted By -Obsessed-:
Okay, my old thread fell into archives, so reviving it as we've had a huge influx of LR owners in the past 3 years since I last did this.

So, what is this jazz you ask? It's a LabRadar Data Consolidation Tool!

[snip]

Expecations:

• I expect you to tell me you're giving this a whirl.  I'm providing this free of charge...the least you can do is tell me you're using it. I want to know if my effort is actually being utilized/appreciated.


• I expect feedback.  If there is something that isn't working correctly, please tell me.  I'm not a professional programmer, and I'm only a sample size of 1, so there may be bugs. The goal is to fix bugs and also implement changes and improvements/capabilities that do not exist today in the tool.  I want this to be a tool for the people. So please tell me what you'd like to see in it.


• Please have a respectable, open discussion in this thread.  All responses in relation to the above two bullet points can be posted directly in this thread, via email, via private message, whatever. I don't care, but I'd prefer you at least help keep this an active discussion as I want this to be a living thread.  The last one fell into the archives pretty fast, and once that happens I can't update the link to the file, etc, and then I get emails asking for help on a file I haven't updated in ages for the rest of time.

So, now that you made it through this wall of text, here is the file! Let me know what you think!

Originally Posted By AeroEngineer:


As a note, I'm running the LabRadar Lite, which is supposed to be the same as a LabRadar minus Bluetooth, so clearly the output file is the same.  Not that I'd really expect this to be different, but you never know.

Originally Posted By Tao:
So, I just imported data again from the last range trip, and it duplicated all the old stuff when it was done.

What's the best way to handle data going forward?

Save as individual sheets in a separate xcel file?

Originally Posted By -Obsessed-:


Generally I will save off a new version of the file for each range trip.

Originally Posted By -Obsessed-:


Generally I will save off a new version of the file for each range trip.

Originally Posted By Tao:
Think you could add a graph that auto populates?

Great for ladders.

https://i.imgur.com/ChwKUEm.jpg

Originally Posted By -Obsessed-:


Only heathens shoot ladders in the same series.

I will look into that. Shouldn't be too hard to do. but for real though...you shoot different loads in the same series? Never heard of anyone doing that before. I certainly don't. I prefer them each their own series so I can see stats on that particular load.

Originally Posted By drfroglegs:
You did an awesome job on this @-Obsessed-

Very much appreciated.

Everything worked flawlessly, I just have one question...

Occasionally I'll see 1 BC calculation that is way off. For instance, the fourth shot/line calculated a BC of 0.191 while all the rest of them seem pretty close.

Any idea why I see this? Is it just from a misaligned Labradar that is missing data points in the calculation?

https://www.ar15.com/media/mediaFiles/322543/Capture_JPG-2437884.JPG

I agree it would be really cool if there was a way to make a automatic plot. Could be something where if you have 5 series with each series being a different powder weight, it automatically grabs each weight and average from each series and creates a new tab with the plot. No idea how to do it, but it's a cool idea!

Regardless, thank you for your work on this. I'm extremely impressed with how easy it is to use.

Originally Posted By bigriver:
Anybody try this using LibreOffice Calc? I'm not having very much luck pulling in data. Made my own that works OK, but the BC calcs would come in handy.

Originally Posted By GHPorter:

I've been impressed with LibreOffice and how well the various apps can import external documents, sheets, etc.

What's "not working" when you try to import your data?  Are you starting with the file in the Labradar default format?

I fought the "Numbers versus Excel War" years ago and finally surrendered to needing to have Excel handy for some of the complex spreadsheets I developed using Excel.  But LibreOffice seems to have gone a long way to fix those issues.  So I'm interested in finding out what glitches you are encountering.

Originally Posted By bigriver:
Yea I copy files from the SD to another folder, drop the spreadsheet file beside the LBR folder.

Stays on 0% for a long time. Escape out and this is noted:

BASIC runtime error.'51'
Internal error .

Looks to be having trouble with this section of the macro:

'Delete any defined names, to eliminate duplication
   If ActiveWorkbook.Names.Count > 0 Then
       On Error Resume Next
       Dim N As Variant
       For Each N In Actieworkbooks.Names
           N.Delete
       Next N
       Set N = Nothing
   End If

I have used calc for some of my spreadsheets made in excel, but I don't do macro's. This is above my paygrade.

Originally Posted By -Obsessed-:


Libre office doesn't use the same reference libraries as Excel. To put it plainly, it's a "rough approximation" of what VBA can do, but not nearly as powerful.

That said I don't have the time to learn a different programming language, but it does make me wonder if it is cross platform compatible with Mac without having to recode it. I doubt that's the case, but when I get time I'll look into it.

Originally Posted By TNC:
My club just got a labradar lite and they're renting it to members. I used it for an hour and got familiar with it. Next time I'll take an SD card so I can bring all the data home.

This was the second time I've had opportunity to compare results from a labradar and my magnetospeed.  The first time a friend and I checked a variety of rifle ammo and found the two instruments agree to within 1%.

I haven't worked up the data yet, but the differences between the two were 0 - 10 fps for loads going 1900-ish fps. The sample size is small, but it gives me more confidence both instruments are accurate.

Originally Posted By Blowout:

A member on this forum did a side by side some time ago and reported the LR and MS were very consistent with each other's readings. The optical chrony he used did not correlate very close.    

This test demonstrated an Oehler right in line with the LR and MS.
https://bulletin.accurateshooter.com/2019/11/chrono-test-labradar-vs-magnetospeed-vs-oehler-35p/