Dan Burpee spreadsheet next generation

The forum for general banter about the team.

Moderator: The forum police - (nee naw)

Post Reply
sander
Free Spirit
Posts: 451
Joined: Fri Dec 03, 2010 10:07 am
I row on...: Model C with PM5
Location: Brno

Dan Burpee spreadsheet next generation

Post by sander »

We all know the Dan Burpee Row Pro extractor. You know that Greg and I have been playing with Python to reproduce those colorful graphs of Dan Burpee. In the meantime I have developed this a little further.

I will very soon have a web interface where you can upload your row files (CSV, TCX) and create those plots on-line. The interface can sync with the Concept 2 logbook so your rows will show up there and on the meterboard. The image files can be linked for including in blog or forum posts.

You can even import data from the C2 logbook and make plots, for example if you used ErgData.

Right now this lives and works on my computer and syncs with C2's sandbox test server. I will soon open to the public and will need some volunteers for debugging and testing the user interface. Send me a PM if you're interested.

Once everything is robust, I will ask C2 to allow me to post to the real logbook server.

It works with TCX (SpeedCoach, CrewNerd), ErgData, PainSled, RowPro ... And more ...

Will post some screenshots soon.
Image

Training Blog: http://blog.rowsandall.com/
Free Data and Analysis. For Rowers. By Rowers: http://rowsandall.com
User avatar
CamiCrew
Friend of the Free Spirits web site 2017
Friend of the Free Spirits web site 2017
Posts: 1138
Joined: Wed Jan 12, 2011 8:59 pm
I row on...: Model D with PM5
Location: California, USA

Re: Dan Burpee spreadsheet next generation

Post by CamiCrew »

Sander I'd love to try it out, starting in last 2 weeks of May. I now have 3 types -- Speedcoach files, ErgData (beta) and RowPro files.

So far I've been unsuccessful getting the RP and Erg Data XLS versions to work, due to either having the wrong OS or wrong version of Excel. If there will be requirements such as specific platform or browser, would be good to know.

Sounds great. Thanks for your time put into it. And Greg's too.
-barbara

F Hwt 53 yrs 5'10"
sander
Free Spirit
Posts: 451
Joined: Fri Dec 03, 2010 10:07 am
I row on...: Model C with PM5
Location: Brno

Re: Dan Burpee spreadsheet next generation

Post by sander »

There should be no browser requirements and I have even tested the prototype directly from the iPhone using Google drive. Will send you email as soon as I am ready.
Image

Training Blog: http://blog.rowsandall.com/
Free Data and Analysis. For Rowers. By Rowers: http://rowsandall.com
sander
Free Spirit
Posts: 451
Joined: Fri Dec 03, 2010 10:07 am
I row on...: Model C with PM5
Location: Brno

Re: Dan Burpee spreadsheet next generation

Post by sander »

As promised here are the screenshots. One disclaimer: I am not a graphics designer and the website layout you see is definitely not the final one. Just put the links on a grid in order to test the functionality.

Overview of workouts and recently created graphs:
Image

Uploading a new workout from a painsled/TCX/RowPro file:
Image

Workout detail edit (and graphs linked to this workout):
Image

The Concept2 development server view of the workout after succesful upload from my tool.

A. From TCX File (OTW)
Image

B. From Painsled File (OTE)
Image
Image

Training Blog: http://blog.rowsandall.com/
Free Data and Analysis. For Rowers. By Rowers: http://rowsandall.com
sander
Free Spirit
Posts: 451
Joined: Fri Dec 03, 2010 10:07 am
I row on...: Model C with PM5
Location: Brno

Re: Dan Burpee spreadsheet next generation

Post by sander »

I have opened the site for anybody who wants to register. Just go to rowsandall.com and click on the register link. For a preview of what the site can do:
http://rowsandall.com/rowers/workout/79
Image

Training Blog: http://blog.rowsandall.com/
Free Data and Analysis. For Rowers. By Rowers: http://rowsandall.com
User avatar
JonT
Friend of the Free Spirits web site 2020
Friend of the Free Spirits web site 2020
Posts: 1950
Joined: Tue Nov 11, 2014 2:31 pm
I row on...: Model D with PM5
Location: Bath, Somerset, UK

Re: Dan Burpee spreadsheet next generation

Post by JonT »

sander wrote:I have opened the site for anybody who wants to register. Just go to rowsandall.com and click on the register link. For a preview of what the site can do:
http://rowsandall.com/rowers/workout/79
I just get "Server Error (500)"
57 years old, 5"10', clinging on to 75kg and frustratingly but understandably inconsistent
Image
sander
Free Spirit
Posts: 451
Joined: Fri Dec 03, 2010 10:07 am
I row on...: Model C with PM5
Location: Brno

Re: Dan Burpee spreadsheet next generation

Post by sander »

Strange. It works here. Can you see the top page rowsandall.com?
Image

Training Blog: http://blog.rowsandall.com/
Free Data and Analysis. For Rowers. By Rowers: http://rowsandall.com
User avatar
JonT
Friend of the Free Spirits web site 2020
Friend of the Free Spirits web site 2020
Posts: 1950
Joined: Tue Nov 11, 2014 2:31 pm
I row on...: Model D with PM5
Location: Bath, Somerset, UK

Re: Dan Burpee spreadsheet next generation

Post by JonT »

sander wrote:Strange. It works here. Can you see the top page rowsandall.com?
Yes I can see the home page with a photo and a login button etc.
57 years old, 5"10', clinging on to 75kg and frustratingly but understandably inconsistent
Image
sander
Free Spirit
Posts: 451
Joined: Fri Dec 03, 2010 10:07 am
I row on...: Model C with PM5
Location: Brno

Re: Dan Burpee spreadsheet next generation

Post by sander »

The accessibility of http://rowsandall.com is a recurring issue with a few users. I am trying to work it out with my hosting provider (who claims it is a fault at the user's end) and my users (who claim it's a fault at my end). :-(

There is an alternative URL which works, though: http://rowsandall-1072.rostiapp.cz/

Check out the site. It has been upgraded recently. Here are some of the features:

- Import data from Strava, SportTracks or Concept2 logbook, or upload CSV or TCX files from CrewNerd, RiM, SpeedCoach, RowPro, PainSled, ErgData, ErgStick
- Export data to Concept2 logbook, Strava, SportTracks
- Data Analysis:
- Interactive plots
- Static plots for incorporation in blog posts (distance plot, time plot, pie chart). More plots will be added.
- Compare workouts
- Wind/Stream corrections for OTW rowers
- (beta) Calculate "equivalent" erg score from OTW pace
- Smoothen out noisy GPS data

Registering for the site is free. The data export/import and most plotting routines are part of the free registration. The "advanced" features are available for 5 EURO per year.
Image

Training Blog: http://blog.rowsandall.com/
Free Data and Analysis. For Rowers. By Rowers: http://rowsandall.com
Post Reply