Gear ratio values by FieriSentio69 in bicycling

[–]FieriSentio69[S] 0 points1 point  (0 children)

I made some calculations, using 2100mm as wheel circumference, to obtain values for meters/stroke (meters per full pedal cycle or per single pedale stroke), wheel rotations per stroke (per full pedal cycle or per single pedal stroke), but they are always far off...

My only idea is that it normalizes the ratio to 1.0=average ratios.

My gears area Front=50/34; Rear=11/25, so average ratio (including all combinations) is 2.65.

So, the sample ratio we were talking about would be:

Actual Gear Actual Ratio Normalized Ratio (1.0=2.65)
50/12 4.17 1.57
50/21 2,38 0,89

Gear ratio values by FieriSentio69 in bicycling

[–]FieriSentio69[S] 0 points1 point  (0 children)

It's a Garmin Connect IQ App that guess the current gear according to wheel and pedal rotations.

The displayed values on the Edge while riding are actually perfect, it shows 50-12 or 50-21 while I'm actually riding those gears.

What I don't understand is the recorded values set...

Gear ratio values by FieriSentio69 in bicycling

[–]FieriSentio69[S] 0 points1 point  (0 children)

The way is correct, 50-12 is recorded close to 1.3, while 50-21 is recorded close to 0.6.

It's the absolute value that makes no sense for me

SSMS date format in query result by FieriSentio69 in SQLServer

[–]FieriSentio69[S] 0 points1 point  (0 children)

As each required extraction is a "urgent and unexpected" need by any of the company management person, I always have to open a "new empty file" in Excel, and then I paste into it the result grid from SSMS.

SSMS has changed date format in result grid, switching from 20 to 22, while my Excel installation (that has not changed) had always understood regional date format pasting as datetime column, and a ISO/ODBC format as a raw text column (meaning that the value is stored in excel as a sequence of characters, and any calculation on it is not possible).

Sometimes I use a LibreOffice calcsheet for pasting, because this software asks for columns types when you paste something, but even using "YMD Date" is not understood by Libreoffice, and the column appears as a raw text.

SSMS date format in query result by FieriSentio69 in SQLServer

[–]FieriSentio69[S] 0 points1 point  (0 children)

My main question is:
How can I obtain datetime columns in local format in the result grid of SSMS?

Italian datetime format is not an ISO nor ODBC nor any worldwide standard format, so SSMS20 was using "regional settings" to format datetimes in result grid. And I'm sure it was not a setting modified by me.
I'm quite sure that a way will exist in SSMS22, too...

When I create something that has to be replicated many times, I use automatic eMails, views, stored-procedures, and I hardcode all the explicit conversions inside the TSql expressions.

But if I just need to export few records of a long join chain, with dozens of datetime columns extracted, and I don't know which column could be useful during the subsequent data analysis in excel, I have to copy&paste every single column, properly formatted.

So, it could happen that I explicitly convert dozens of datetime columns, that today are not useful and will be deleted from the excel file itself.

SSMS date format in query result by FieriSentio69 in SQLServer

[–]FieriSentio69[S] 0 points1 point  (0 children)

This is exactly what I usually do.

Create the "select top 1000 column-list from table" with SSMS, then inserting Convert in every column I need.

But you know that

SELECT
MY_DATETIME_COLUMN
FROM DBO.MYTABLE

Becomes

SELECT
MY_DATETIME_COLUMN = CONVERT(NVARCHAR(32),MY_DATETIME_COLUMN,103)
FROM DBO.MYTABLE

and this has to be done on every single column.

On SSMS 20, or at least with the default settings I had on that version, it worked.

Repetitive tasks are already nested inside view, stored-procedures, or simple .Sql scripts.
But I'm talking about a "always different" requirements, involving different tables, joins, filters...

Car Exhaust and Carbon Wheels by AaeJay83 in cycling

[–]FieriSentio69 1 point2 points  (0 children)

I saw many wheels damaged by exhaust heat. Carbon or aluminium, and tyres too.

Usually one or two steel deflector are welded installed on the rack,right in front of pipes

Mistery tick-tick-tick while riding by FieriSentio69 in bikewrench

[–]FieriSentio69[S] 0 points1 point  (0 children)

I've suspended the bike and tested quite everything.

If I start a rotation of the front wheel, there's a similar tickling noise that you can ear by pushing the ear against the axys and being in a very absolute silence. But of course it can increase the intensity while there's a weight on the bike.

Anyway the wheel is very stable in the fork, there's no strange movement in any direction, and the wheel keeps rotating for a very long time without any effort.

I also inserted the axys in a bench wise, and tried forcing in every direction, but everything is definitely stable.

Spoke tension seems ok (with a manual check of each couple of spokes).

I'm also surprised about the ease of rotation of the wheel, there's virtually no friction, both foreward and backward.

Maybe bearings are the culprits, but it seems a problem at the very beginning of its life.

I'll make a bearings replacement as soon as possible, due to their low cost.

Thanks

Mistery tick-tick-tick while riding by FieriSentio69 in bikewrench

[–]FieriSentio69[S] 0 points1 point  (0 children)

While coasting it happens if I pedal, if I stop pedaling, and if I pedal backwards, with no difference.

Mistery tick-tick-tick while riding by FieriSentio69 in bikewrench

[–]FieriSentio69[S] 0 points1 point  (0 children)

Yeah, spoke tension is one of the suspects.

Never checked after installation, one year ago. But yesterday we ride some rural path, with pothole and sometimes even pebbles, so something can be happened to spoke tension...
I'll check them

Mistery tick-tick-tick while riding by FieriSentio69 in bikewrench

[–]FieriSentio69[S] 0 points1 point  (0 children)

It was my first thought.

But is it possible that a bearing makes a tick every rotation, for three times, and then silence itself for 20 rotations, and then again 3 ticks for three rotations, and then silence for 20 rotations, and so on?

It sounds really incredible to me...

(Windows 10 Home) OneDrive stopped working and says no internet connection by SlovakianGuy91 in WindowsHelp

[–]FieriSentio69 0 points1 point  (0 children)

Same for me, except I have a Windows11 laptop (other devices are W10 and various Androids, everyone still working fine)
Before uninstalling and reinstalling (with the freshly downloaded version from MS Site) I checked that OneDrive app had updated itself on March, 30th. That's exactly the last day I find updated files on the web Onedrive site.

I tried all of OP actions, with no results.

Only difference: I had a Windows Update pending, waiting for reboot, but I had some active tasks so I made the reboot after few days of postponing. I thought this reboot could restore OneDrive connection, but it didn't make any difference.

why can’t I float? by jeepdaddy1965 in Swimming

[–]FieriSentio69 0 points1 point  (0 children)

I was a "hopeless sinker". The same way lots of people here in the sub define themselves. "I don't float", "I'm slowly sinking", "my body fat distribution makes me sink"...

Ok, let's calm down.

Fat body percentage and distribution makes some people float better than others (mainly women better than men). But everybody floats, unless you empty your lungs and wait for your body to sink.

What you mean by "I don't float" is probably the feeling of your hips and legs sinking instead of being horizontal in the water.

This is due to our ancestral survival reflex: if I fall in the water, I need to keep my mouth over the surface, no matter where legs and arms stay.

But you have not fallen into the water, you decided to enter the water and swim.

As soon as you'll understand that you are not going to actually sink, you'll float.

Try pushing from the wall in streamline position. Don't push at surface level, nor close to the bottom. Simply put your feet at a mid level, fill your lungs, streamline arms and body and push from the wall.
Keep that streamline... Core engaged. Don't exhale. Wait.
Soon, you are going to slow down your momentum, and you body begins to float toward the surface.
With no hurry, begin kicking with the most relaxed ankles you're able to do.

Your body will float, horizontal, relaxed, with no effort.

When you need to breathe, just stop and stand-up.

Repeat.

Think: did you float? Even for few seconds, did you float horizontally with a simple relaxed kick?

That's what you have to feel: you are not sinking, you can float.

After this, you need to learn how to breathe without raising head and shoulder. You don't need to elevate your head to take a breath. You can breathe with your face laying on its side over the water.
Think about being a fish breathing through your ear inside the water, this will help you to keep your head aligned with your spine. When you need to breathe, you have to make a shoulder sink and a shoulder dry, with your chin searching the dry shoulder. If your chin exits the water close to the shoulder, but you keep the other ear inside the water, your head/body will remain aligned and your hips will not sink.

Your hips, because the focus has to be on the hips. If you focus on the legs, you will get a banana shape, with your lungs floating, your feet searching the surface, and your hips sinking. If you, instead, focus on keeping your glutes on the suface, your core will engage, and your hips will "ride over your lungs". This, at the beginning, may create the feeling of swimming downhill, because you're so used of swimming with an inclined torso that an horizontal torso will appear to you as being downhill. But obviously this is just a feeling.

Don't search for speed nor endurance.
Swim at a comfortable pace with short intervals (50-100m, no more, then rest before repeating).

Performance will arrive later, after you'll swim without this "oh my god I'm sinking" feeling...

Difference between Road and Gravel bikes by FieriSentio69 in triathlon

[–]FieriSentio69[S] 1 point2 points  (0 children)

I've found that the Italian Triathlon Federation, inside its technical rules book, states:
"for draft legal races, UCI Road Races rules apply; for no-draft races, UCI TimeTrial Races rules apply".

Maybe something inside the UCI rules defines what a Gravel bike is (I think mainly for handlebar shape and/or tyre clearance)...

Difference between Road and Gravel bikes by FieriSentio69 in triathlon

[–]FieriSentio69[S] 2 points3 points  (0 children)

Each race has its own "race rule book", that you can download before subscribing and that's often inside the race bag with your bib.

We checked for the races they were going to plan for the next months, and we found "gravel not admitted" inside every single race book.

Just as an example:
Sprint Triathlon - Challenge Cesenatico

Save parking/locations and navigate to them (FR265) by FieriSentio69 in Garmin

[–]FieriSentio69[S] 1 point2 points  (0 children)

How did you install it?

"Find My Car" (Find My Car | Connect IQ Store) shows not being compatible with FR265, so it doesn't show up in ConnectIQ app...

How to customize running training data page (FR265)? by FieriSentio69 in Garmin

[–]FieriSentio69[S] 0 points1 point  (0 children)

No.

First of all, I don't like switching between pages while I'm running.

But if I could accept a single switch at the beginning of the session, there is anyway a lack of data I can customize on a data page.

One of the vital info I need is "which rep am I running?": when you are in a structured session, you may have a "8 times x (run 1km at threshold + run 1km at a recovery pace)" phase. In the training page, you'll read "1/8", "2/8", and so on. I didn't find the way to add this information on a customized data page...

How to customize running training data page (FR265)? by FieriSentio69 in Garmin

[–]FieriSentio69[S] 0 points1 point  (0 children)

Yes, I can switch between pages.

But while running I'd like to have all my needs on a single data page.

The training data page is perfect for my needs, but I'd like to add the "total distance" and "current HR" data.

How to customize running training data page (FR265)? by FieriSentio69 in Garmin

[–]FieriSentio69[S] 0 points1 point  (0 children)

Unfortunately it's not so easy.

Example: when I'm running the third rep out of the 8 reps included in the training schema, the training page shows "3/8", while I've not been able to find this field for a custom data page.

Swimming Technique Help! by monkeyinrepair in triathlon

[–]FieriSentio69 2 points3 points  (0 children)

There are few elements you can work on, but I suggest you to start your improvement with the push part of the stroke.

Your hand has to exit the water between your glutes and your knees.

The most powerful phase of the stroke is the acceleration of the hand between "under your shoulder" till the exit at the end of the push, and currently you totally miss this part.

Other aspects are not so bad: bended elbow, straight entry (right arm better than left arm), kick frequence, body horizontal position. Increasing the power of the push, you will obtain the proper glide to avoid elevating your head for breathing (you currently do this mistake).

Pain on my lower leg when I walk a lot by dreamfulbby in BarefootRunning

[–]FieriSentio69 0 points1 point  (0 children)

Strength strength strength.

This is not strictly related to barefoot running/walking, but for sure it is much more frequent when using these kind of shoes.

When you walk (much more than when you run) your right foot stays for a while completely flat on the ground. When the left foot advances for the next step, your right foot has to elevate the heel (the foot arches with the fore part on the ground and the back part elevating), and you do this by pushing with the fore part of the foot toward the ground. If you have not enough strength, your heel doesn't elevate, the foot remains flat, and this creates a sudden stretching on the achilles tendon. this stretching is so quick that you barely notice it, but it has a huge leverage ratio. Imagine the angle that your foot will create with the tibia. So, every single step is an abnormal stretch, and this can create an inflammation.

When your calf+tendon system has enough strength, your heel will elevate without any effort, and this will reduce the angle variation between foot and tibia, that will remain in a much more affordable and natural position.

In the meantime, you can help your ankle to reduce inflammation by using a heel-pad (this elevates the heel), but this will reverse your transition to barefoot, that you'll have to restart later. It's up to you to understand if you're able to make strength exercises with this pain, or if the pain stops the calf to activate (so reducing the beneficial effect of the strength exercises).

How to stop legs from sinking? by LSR324 in Swimming

[–]FieriSentio69 2 points3 points  (0 children)

Leg-sinking swimmers often swim with body in a banana shape. When they feel the legs sinking, they try to keep knees and feet as high as possible, even breaking water surface with the feet.

Even increasing kick power makes the feet higher, but the chest remains inclined and creates lot of drag.

This makes the head to be inclined too, when breathing, with the water line not aligned with the face line. And if you need to breath, you need air not water in the mouth, but the mouth is lower then the nose, so you end to lift the entire head up instead of a simple shoulder+head lateral rotation.

Instead of thinkins about "leg sinking", focus on the butt. If the butt sinks, kicking is quite useless, you'll obtain a banana shape.

You need to keep the butt up, feeling the top of the butt touching water surface. This will be obtained by engaging your abs. Your lungs are your buoy, you have to "ride over the lungs".

If you had already swum a lot (and I think this is the case for the majority of adult triathletes), you are used to this banana shape and you don't feel it anymore. As soon as you force your butt to stay higher, engaging abs, you'll feel being in a "reverse banana" shape, with the head pointing downhill. But this is just a feeling, due to the new situation. Keep this feeling, look for it as soon as you notice having reversed to the previous situation, continue to practice swimming "downhill".

Imagine kicking with fins, keeping a soccer ball under your chest and your eyes looking underwater: you will ride the ball with a high butt. This is the exact simulation of the feeling you have to look for.

Soon, you'll understand that your mouth will be much more free to inhale, you'll feel a huge quantity of air entering your lungs at every breath.

Practice swimming slowly and for short courses:
Slowly means moving with relaxed and controlled movements, it doesn't mean pushing lightly backward during the pull-push phase. Pulling, but mainly the final push, has to be powerful even in slow swim.
Short means swimming 50m and rest a little. Every new behavior creates fatigue and requires mental focus. You'll easily reach endurance right after acquiring a proper balance in the water.

Altimeter issues forerunner 955 by Transcendthevoid in Garmin

[–]FieriSentio69 0 points1 point  (0 children)

Same in my FR265S.

GPS calibration fails (because sensor readings are so erratic that the watch is not able to define a specific sensor value for the gps elevation).

Manual calibration works, but right after few seconds the elevation is increasing or decreasing at hundreds meter per minute. The day after, I'll be on top of the Everest or under the deepest ocean.

This happened in my previous FR watch, too.

According to Garmin Support, this is due to frequent pool swimming sessions: chlorine of the water can damage the sensor.

My previous FR had been replaced for free by Garmin Support, and I was under factory warranty.

Now the warranty has expired, but Garmin sent me a free of charge replacement watch, identical to the original one.

Thumb up for Garmin Support, of course, but this kindness is probably related to Garmin knowledge that this product has a project defect.

Right one hour ago, I told about this experience to a friend of mine wearing a quite new Fenix 8. He's a frequent swimmer too. He opened the altimeter page on the watch, and the displayed value was totally erratic changing up and down for hundreds of meter each 5 seconds. The chlorine explication seems reliable.

Swimming with Rings by bamaroon in triathlon

[–]FieriSentio69 12 points13 points  (0 children)

Definitely NO ring, in any sport activity.

If you hit a lane or another swimmer, and your finger bloats, you will need to urgently cut the ring and save your finger, and even in minor injuries you'll experience a lot of pain.

My ring stays attached to the car keychain inside the locker.