Statistics
Moderator: nick
Forumsregeln
Please create new posts in the according categories and label them with an appropriate subject.
When replying to a post, please stick to its subject, and create a new subject if you want to add a whole new aspect.
Please create new posts in the according categories and label them with an appropriate subject.
When replying to a post, please stick to its subject, and create a new subject if you want to add a whole new aspect.
-
- Beiträge: 16
- Registriert: Mo 6. Mär 2017, 20:11
Statistics
Hello Nick;
Now that I have a season of data to play with, I'm experimenting with the Statistics. What is the secret to running a report that lists how many KMs a member rowed in 'Crew 1'. I'm trying to figure out the distance and number of outings that everyone bowed. The best I've been able to do so far is to run a report using 'Logbook' filtered on people and then count the number of times their name is 'bolded'. I'm sure there is a friendlier way to do this but I can't find options for filtering by seat (Crew 1,2,3,4, etc...). Can you point me in the right direction?
Thanks,
Rob
Now that I have a season of data to play with, I'm experimenting with the Statistics. What is the secret to running a report that lists how many KMs a member rowed in 'Crew 1'. I'm trying to figure out the distance and number of outings that everyone bowed. The best I've been able to do so far is to run a report using 'Logbook' filtered on people and then count the number of times their name is 'bolded'. I'm sure there is a friendlier way to do this but I can't find options for filtering by seat (Crew 1,2,3,4, etc...). Can you point me in the right direction?
Thanks,
Rob
Re: Statistics
Hi Rob,
Hmm, you're the first one asking for this. No, this is indeed not supported at the moment. There's no way to filter by a particular seat. Your approach is the best I can think of (at least in the current version). Instead of counting bold entries by hand, you could create the logbook statistic as a CSV file (select "CSV" as output), then open the created file in a spreadsheet (Excel and co), and let Excel do the counting.
Is this a feasible solution, or do you need to do this for dozens of persons?
Thanks,
Nick
Hmm, you're the first one asking for this. No, this is indeed not supported at the moment. There's no way to filter by a particular seat. Your approach is the best I can think of (at least in the current version). Instead of counting bold entries by hand, you could create the logbook statistic as a CSV file (select "CSV" as output), then open the created file in a spreadsheet (Excel and co), and let Excel do the counting.
Is this a feasible solution, or do you need to do this for dozens of persons?
Thanks,
Nick
-
- Beiträge: 266
- Registriert: Fr 24. Feb 2012, 15:42
- Wohnort: Itzehoe
- Kontaktdaten:
Re: Statistics
Hi Rob,
your request is possibly be a bit misleading...
Are you looking for ...
...the total distance and number of trips per person on seat 1, seat 2, seat N...?
This can actuallly only be done on exported data as Nick proposed.
or
...the total distance and the number of trips per person, no matter on which seat?
This is possible with the available report features in efa. It gives you for a chosen period the person's name, the total distance, the number of trips and the average distance per trip.
However you can distinguish between the total distance as a rower and the total distance as a coxswain.
Martin
Itzehoer Wasser-Wanderer e.V.
your request is possibly be a bit misleading...
Are you looking for ...
...the total distance and number of trips per person on seat 1, seat 2, seat N...?
This can actuallly only be done on exported data as Nick proposed.
or
...the total distance and the number of trips per person, no matter on which seat?
This is possible with the available report features in efa. It gives you for a chosen period the person's name, the total distance, the number of trips and the average distance per trip.
However you can distinguish between the total distance as a rower and the total distance as a coxswain.
Martin
Itzehoer Wasser-Wanderer e.V.
-
- Beiträge: 16
- Registriert: Mo 6. Mär 2017, 20:11
Re: Statistics
Hello Martin and Nick;
Sorry for the late response but I've been away from rowing for awhile here in the frozen North What I'm after specifically is a way to report the distance rowed for each individual club member in seat 1. Not really worried about seats 2 - 8. This is so that I can create a report so that each individual can see how many KMs they've bowed in blind boats. This is important to us because this number helps us update our bow list and rower qualifications for specific equipment.
and yes, I have to do this for everyone in the club (about 200) and I do eventually want to make this a report that individuals can pull themselves.
Thanks again,
Rob
Sorry for the late response but I've been away from rowing for awhile here in the frozen North What I'm after specifically is a way to report the distance rowed for each individual club member in seat 1. Not really worried about seats 2 - 8. This is so that I can create a report so that each individual can see how many KMs they've bowed in blind boats. This is important to us because this number helps us update our bow list and rower qualifications for specific equipment.
and yes, I have to do this for everyone in the club (about 200) and I do eventually want to make this a report that individuals can pull themselves.
Thanks again,
Rob
-
- Beiträge: 266
- Registriert: Fr 24. Feb 2012, 15:42
- Wohnort: Itzehoe
- Kontaktdaten:
Re: Statistics
Hi Rob,
ok, than you have to create a statistic to export log book entries into a csv- or xml-file. You can load the exported files in Excel.
For a csv export you have to split up in Excel the crew data column into separate seat / crew member columns.
The first crew member is the rower on seat 1.
The easisest way to see the km for rowers on seat 1 is to create a Pivot Table Report for the imported log book entry data.
I hope that helps
Martin
Itzehoer Wasser-Wanderer e.V.
ok, than you have to create a statistic to export log book entries into a csv- or xml-file. You can load the exported files in Excel.
For a csv export you have to split up in Excel the crew data column into separate seat / crew member columns.
The first crew member is the rower on seat 1.
The easisest way to see the km for rowers on seat 1 is to create a Pivot Table Report for the imported log book entry data.
I hope that helps
Martin
Itzehoer Wasser-Wanderer e.V.