Help tracking equipment life (chain, tire, battery, etc)

[Craig Dinger]

I have found 2 conversations about tracking, but I don't understand the details of making it happen.  I don't know anything about Python, sadly I'm not even sure that is the issue. If I need to learn basic Python I will work on it, but I'd at least like to know that is the right direction to go.

https://groups.google.com/g/golden-cheetah-users/c/Bk5G1PpP60s/m/knIU_bmjBAAJ

and

https://groups.google.com/g/golden-cheetah-users/c/43GxSvQDHz4/m/Q4PJOktVBQAJ

I would like to track mileage on items like tires, chains, cassettes, etc. I would like both a running current item mileage and historical data.

I am using Linux, build date Sept 16, 2022, Id 4011 with Python 3.7.14 installed.

Thanks,

Craig

[Ale Martinez]

https://groups.google.com/g/golden-cheetah-users/c/DcYrBGooeP0/m/N2bWNuHwAgAJ

[Craig Dinger]

Sorry, I'm still not understanding. I have a data field "Workout, Equipment, Text". I entered "Goodyear Eagle F1" in the Equipment field for the first ride on 2022/09/10. Since 2022/09/10 I have uploaded several rides. Now I want to have a chart or tile that tells me the cumulative miles on this tire. 

If I enter Goodyear Eagle F1 for each new ride using this tire, modify a tile to "round(sum(metrics(Distance)));", and search for "Goodyear Eagle F1" it will display the cumulative mileage. I'm pretty sure there are ways to obtain the same data without entering "Goodyear Eagle F1" on each ride.

Craig

[Ale Martinez]

El lunes, 26 de septiembre de 2022 a la(s) 20:59:37 UTC-3, cad...@gmail.com escribió:

Sorry, I'm still not understanding. I have a data field "Workout, Equipment, Text". I entered "Goodyear Eagle F1" in the Equipment field for the first ride on 2022/09/10. Since 2022/09/10 I have uploaded several rides. Now I want to have a chart or tile that tells me the cumulative miles on this tire. 

If I enter Goodyear Eagle F1 for each new ride using this tire, modify a tile to "round(sum(metrics(Distance)));", and search for "Goodyear Eagle F1" it will display the cumulative mileage. I'm pretty sure there are ways to obtain the same data without entering "Goodyear Eagle F1" on each ride.

Read the FAQs on data for ways to automate this process. 

[Ale Martinez]

BTW, to tag each activity is the general solution when you have more than one item of each type, and use them alternatively in the same time frame. For the particular case having just one item of each type, date ranges may be a simpler solution.. 

[Jérôme launay]

Le mardi 27 septembre 2022 à 01:59:37 UTC+2, cad...@gmail.com a écrit :

Sorry, I'm still not understanding. I have a data field "Workout, Equipment, Text". I entered "Goodyear Eagle F1" in the Equipment field for the first ride on 2022/09/10. Since 2022/09/10 I have uploaded several rides. Now I want to have a chart or tile that tells me the cumulative miles on this tire. 

If I enter Goodyear Eagle F1 for each new ride using this tire, modify a tile to "round(sum(metrics(Distance)));", and search for "Goodyear Eagle F1" it will display the cumulative mileage. I'm pretty sure there are ways to obtain the same data without entering "Goodyear Eagle F1" on each ride.

Craig

I don't know if it can help but I'm also using the data field Equipment (Equipement in French), after each ride I manually fill in the equipment used according to the sport, bike, shoes etc.
Then in Trends I added a user chart, type: Stacked Bar Chart with one serie named "Distance"

Then on the left pane I select the date range, for example "this year"



In the filter I can filter by sport, for example Bike



which gives me



Or another example, run, this month

[Craig Dinger]

Thanks Ale,

I believe I have it working now. I created a new overview called "Equipment" and added tiles for tracking front and rear tire, cassette and chain.  The tile for the rear tire is a search for "Goodyear Eagle F1" The Data Field Defaults is set to Field "Bike", Value "Canyon Endurance", Linked field "Equipment" Default Value " Goodyear Eagle F1". Like you indicated, this enters "Goodyear Eagle F1" into the Equipment field whenever the Bike Field is entered or changed to "Canyon Endurance"

I appreciate your patience and assistance,

Craig

[Craig Dinger]

Thanks launayj...@gmail.com

I'll give your method a try.

Craig

[Ale Martinez]

El martes, 27 de septiembre de 2022 a la(s) 20:48:42 UTC-3, cad...@gmail.com escribió:

Thanks Ale,

I believe I have it working now. I created a new overview called "Equipment" and added tiles for tracking front and rear tire, cassette and chain.  The tile for the rear tire is a search for "Goodyear Eagle F1" The Data Field Defaults is set to Field "Bike", Value "Canyon Endurance", Linked field "Equipment" Default Value " Goodyear Eagle F1". Like you indicated, this enters "Goodyear Eagle F1" into the Equipment field whenever the Bike Field is entered or changed to "Canyon Endurance"

If you (almost) always use that bike for your rides an additional rule setting the Bike field to it when Sport is “Bike” (assuming Sport is automatically set, which is for most of the import formats)  may further automate the import process.

[Ale Martinez]

This is a nice general chart, and a good example of the flexibility of User Charts with GC formulas Mark has devised, can you contribute it to CloudDB or attach the gchart here?

[Ale Martinez]

Nevermind, I will add the attached version of your chart to default layout, thank you. 

[Mark Liversedge]

On Tuesday, 27 September 2022 at 21:08:24 UTC+1 launayj...@gmail.com wrote:

Le mardi 27 septembre 2022 à 01:59:37 UTC+2, cad...@gmail.com a écrit :

Sorry, I'm still not understanding. I have a data field "Workout, Equipment, Text". I entered "Goodyear Eagle F1" in the Equipment field for the first ride on 2022/09/10. Since 2022/09/10 I have uploaded several rides. Now I want to have a chart or tile that tells me the cumulative miles on this tire. 

If I enter Goodyear Eagle F1 for each new ride using this tire, modify a tile to "round(sum(metrics(Distance)));", and search for "Goodyear Eagle F1" it will display the cumulative mileage. I'm pretty sure there are ways to obtain the same data without entering "Goodyear Eagle F1" on each ride.

Craig

I don't know if it can help

That is fab, really fab. Thank you for sharing.

Mark

[Jérôme launay]

Le mercredi 28 septembre 2022 à 17:24:04 UTC+2, Ale Martinez a écrit :

  Nevermind, I will add the attached version of your chart to default layout, thank you. 

Le mercredi 28 septembre 2022 à 20:07:07 UTC+2, liver...@gmail.com a écrit 

That is fab, really fab. Thank you for sharing.

Mark

I was on a business trip today, I just saw your messages.
I may have other graphs that I will not hesitate to share on the cloud.
Thank you very much for your work

[José Luis García Pallero]

Thanks for sharing the chart. Until now I used the field "Keywords" in Details tab in order to track the different bikes, although I had not graphical representation. But I have installed 3.6 build Sep 16 2022 and I can't see the "Equipment" field. How it is possible?

[Ale Martinez]

El jueves, 29 de septiembre de 2022 a la(s) 07:15:57 UTC-3, jgpa...@gmail.com escribió:

Thanks for sharing the chart. Until now I used the field "Keywords" in Details tab in order to track the different bikes, although I had not graphical representation. But I have installed 3.6 build Sep 16 2022 and I can't see the "Equipment" field. How it is possible?

See https://groups.google.com/g/golden-cheetah-users/c/BW5pfoCW4KY/m/j4-fY4q4AQAJ 

[Ale Martinez]

Added a new FAQ about metadata config since this comes recurrently: https://github.com/GoldenCheetah/GoldenCheetah/wiki/FAQ-DATA#where-is-metadata-configuration-stored 

[Steve Edmonds]

I have been using V3.6 through development and had no Equipment field showing. After following the discussions I made the suggested changes with metadata.xml.

I have updated https://github.com/GoldenCheetah/GoldenCheetah/wiki/FAQ-DATA#how-can-i-addremove-a-field-to-edit-on-the-details-screen with the following which applied for me.

If you are already using v3.6 and want to reset metadata to incorporate new fields from a GC release, delete metadata.xml parallel to your athletes folders or better move it to the folder of your first athlete, before a GC restart. Moving metadata.xml to the folder of your first athlete will retain any existing metadata.

[Peter K]

Hi all,

This post help me to create a maintenance overview and I figured I'd share it along with the process I used to create it.

I followed Steve's direction and created this "Maint" tab for my activity:

Then I created this python fix to populate the data on old activities. It is also set to be used at import for future activities.

Finally, I created this overview. Each tile is using the same formula to calculate distance. Then it is using a filter to only count miles for a specific tag.

Here is one example of the formula and the filter:

 

I'm using the start and stop fields as a reminder to change the component. It would be nice if there was a way to change the tile color, background or text when the value approaches the stop field.

I hope it helps.

Peter

[M Thomas]

Peter, thank you for sharing your solution. Looks pretty good right now. You set the parts to the equipment - id. How is the update procedure if you are changing the chain for example? 

Do you know where the data have been stored, is it in the json file ore somewhere in a database (couldnt find it in userwiki). I ask this question why I would like to recherche in the history of parts e.g. what tire did I use or is there a significant difference in quality of chains?

All the best,

Maik

[Steve Edmonds]

Thanks Peter.
I have taken to waxing my chains and these tiles make tracking the life of the chain and each waxing a breeze.

In answer to Maik, I think I have pretty much followed what Peter has done. The below should report km on the chain on my trainer, new on 2023-04-01 and the km since I waxed it on 2023-08-29.

When I change the chain I will change the contents of the TrainerChain field, similarly when I rewax the chain.
The .json activity file contains this data.

            "TrainChainWax":"Wax20230829 ",
            "TrainerChain":"Chain20230401 ",

Steve

--
_______________________________________________
Golden-Cheetah-Users mailing list
golden-che...@googlegroups.com
http://groups.google.com/group/golden-cheetah-users?hl=en
---
You received this message because you are subscribed to the Google Groups "golden-cheetah-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to golden-cheetah-u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/golden-cheetah-users/7859501d-b9b5-4747-a4a8-5b62d6981695n%40googlegroups.com.

[Steve Edmonds]

Maik, for a more graphical comparison of say chain life for different chains the charting proposed by Jérôme launay also works well.
Steve

--

_______________________________________________
Golden-Cheetah-Users mailing list
golden-che...@googlegroups.com
http://groups.google.com/group/golden-cheetah-users?hl=en
---
You received this message because you are subscribed to the Google Groups "golden-cheetah-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to golden-cheetah-u...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/golden-cheetah-users/ae014b12-766f-45d6-aa27-eeeba8087f0dn%40googlegroups.com.

[Peter K]

Hi Maik,

Steve and I seem to be thinking along the same lines. The value for each of the new fields always end with the date it was first used. When I replace or to something else to that component, I either change the date at the end or change the whole value. This way I can preserve the historical information. I've already used Jérôme's chart. I simply changed the

equipment <- metadata("Equipment"); to equipment <- metadata("TarmacChain");

and I get a bar graph showing the distance for each chain I've used. Obviously, since I just implemented this, there is no old data for chains. If you have the old data you can use something similar to the python fix I used and batch processing to populate the old activities. Similarly, you can use any of the new fields you created.

As Steve said, the data is stored in the activity json file. I've been using GC for a while and I've also enabled the automatic backup feature in the athlete tab to keep a copy of all my activities in the cloud.

Peter

[Steve Edmonds]

On 03/09/2023 01:47, Peter K wrote:

Hi Maik,

Steve and I seem to be thinking along the same lines. The value for each of the new fields always end with the date it was first used. When I replace or to something else to that component, I either change the date at the end or change the whole value. This way I can preserve the historical information. I've already used Jérôme's chart. I simply changed the

equipment <- metadata("Equipment"); to equipment <- metadata("TarmacChain");

and I get a bar graph showing the distance for each chain I've used. Obviously, since I just implemented this, there is no old data for chains. If you have the old data you can use something similar to the python fix I used and batch processing to populate the old activities. Similarly, you can use any of the new fields you created.

I used a filter to easily populate some previous activities, i.e. set(Waxings, "T20230402", Activity_Date >= "2023/04/01" && Activity_Date < "2023/08/25")
Steve

To view this discussion on the web visit https://groups.google.com/d/msgid/golden-cheetah-users/9fc0bd46-6bae-494d-8ef3-ee9372742a49n%40googlegroups.com.

[M Thomas]

Hi,

thanks to the helpful content from Peter and Steve I finally managed it to show the lifetime of parts -> Image in german language.

1) Due to the python script values are stored automatically in the json file after getting activities from strava. 

2) As long as no maintenance has been performed there is nothing further to be done.

3) After changig a part, both the script and the filter in the chart has to be modified manually but that is an easy task.

The only thing I am thinking about is the performance. In my .json files are about 70 fields of metadata. The old activities only had 20 fields and I do not know exactly what has happened that fields like [EPOC] or [DanielsPoints] are shown as metadata?

And generally spoken with a view of the raw data: would it be possible to recalculate the sampling pattern from 1second to 2 or 3 seconds which would result in a dramatically smaller file size.

Best regards,

Maik

[Paul J]

I appreciate this thread is old, but it is the most recent on the topic of tracking equipment usage and maintenance within GoldenCheetah.

I have developed a PR ( https://github.com/GoldenCheetah/GoldenCheetah/pull/4533  ) which provides an integrated method of tracking equipment using an Overview tiles format approach, and would like feedback on whether this useful.

The PR is based on assigning a single "EquipmentLink" metadata item to all activities, and then for each activity listing the equipment used for that activity within the EquipmentLink (Batch processing is useful for updating past activities with bike or shoes used).  Pages and tiles can then be created with time spans without the equipment window to track equipment. Allowing a wheelset to be moved between bicycles whilst tracking its total distance. I have created a page for each bike I own, then within the page capture the aspects I wish to track: chain, tyre, cassette, etc wear. The pages update automatically, searching all the activities for the loaded Athletes (supports equipment used by multiple Athletes) within GC and totalling up the distance covered (and other useful info) in each tile representing an item of equipment, please see the PR for more details.

Any feedback and/or improvement ideas would be welcome.

Note: Currently the primary user entered data (that which cannot be derived) is held and saved within the Tiles, I intend to separate this in the near future and this change will not affect the usability of the equipment feature.

Thank you

Paul.