> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/5347?src=pr&el=h1) Report > :exclamation: No coverage uploaded for pull request base (`next@c38ddae`). [Click here to learn what that means](https://docs.codecov.io/docs/error-reference#section-missing-base-commit). > The diff coverage is `0%`.
specific to the problem i was having trying to define my own combo-formula, replace() does need a range, while substiturd() can use a portion of a string
@Hosch250 BMI > 25.0 is considered obese. > 30.0 is morbidly obese.
Yes, it's a BS measurement. Yes, they calculate it for those in the Army and yes, most every one of them is > 30.0 and very, very few are actually obese.
They will take measurements of chest & waist if your BMI is "high". I'm not sure exactly what they're looking for, but I think it's a chest to waist ratio.
because the only meaningful measurement is body fat percentage and the only way to reliably calculate that is the dunk tank, but most people freak out when exhaling then getting dunked, so they can't get a good measurement
Granted, swimming might not help so much if you're in submarine or fast moving / large ships.
In latter, you're basically going to just have to tread until the ship returns to retrieve you. In former, well, you're more likely to die than to survive, especially if you're submerged.
@FreeMan yes but the point is that you can get the same result by measuring the water displaced.
I'm thinking about archimedes' principle where it shows there's a correlation between the submerged weight / unsubmerged weigh and the water displacement.
It's probably a lot easier to hang a scale over a tub, dunk a person and get a weight as opposed to carefully marking the water level, dunk a person, wait for the water to settle, mark the new level, pull the person out, hope he hasn't expired, do the math.
having done it twice a year for the three years i was in college, it's pretty simple. three measurements in freezing cold water for each time i had to go
@FreeMan "STOP MOVING!! YOU'RE MAKING WAVES, WE CAN'T SEE WHERE THE... aah, now that's better. There, done! Ok you can get out of the water now. Joe? JOE?!"
fill vessel 100% full with water, now slowly add a person so their head submerged, count to 5 (enough time to have the displayed water mass calculated) then get out... now do the same thing 2 more times
the amount of air in the lungs is negligible in that scheme provided you are not less than 1% body fat
but it's recommended to exhale ebfore you submerge
i woudl put my hands on the walls to hold myself under whiel i counted then emerged
they measure what sloshes over the side? How do they account for what's still stuck to the outside of the tub and the grate you walked in on and the floor that hasn't yet made it down the drain to be measured and...
I was thiking that you just put the person in a tank that's already full to the brim, in which case, the water will overflow into another tank, and you can then measure that amount of water displaced.
@FreeMan yes, they measure the water that has been displaced, aka what has been removed from the vessel. the % error is the gradiant on the tank versus what was measured
so i had 4.8% bodyfat with a 5% error at my lowest body fat per cent
there's mroe science that goes into the rationale for cold water, the width of the opening, the material for the vessel, etc., so those are supposedly accounted for with the test
@Hosch250 tbh, probably... the amount of people who say shit like "i won that after losing 20 lbs overnight" would definitely be the same people who say "i didn't drink for 3 days before that match"
he was our 112, i was 119 (i had just dropped from 135 the week before to be able to wrestle at sectionals/districts; have to have 1 match in regular season at a weightclass to be allowed to "register" for it)
educate me - why do they insist on keeping weights close with thin margin? I've seen people out-wrestle others that are much heavier or lighter for fun.
so starting at noon on Friday, he was working his ass off, then gave up about 2300. didn't even show up for the bus the Saturday morning to get to the tournament
coach goes to his house, picks him up at 0500 and they drive together to the venue, where the kid had to sit in the backseat working out on the way there... 2.5 hour ride with the heat cranked in layers of clothes. both he and the coach walked in drenched in sweat
at ~2300 he was down from the 134 at noon to ~118 (i think he puked some of it up)
@this my understanding is that weight classes are designed to not allow for unfair play. now, that concept predates modern wrestling by about 2k years. since then, people bulking the f up and keeping lean has changed a LOT... floating weight classes is now common, though not part of the design of weight classes
you will typically see those large fluctuations in high school, as opposed to college or middle school wrestling
@this i believe the question asked was "do you want to do this" and he said yes... his neighbor (the one who told our coach, our 145 lb'er) may have pressured him a little
he went on to place third in the tourney, so there's that
from the years of experience and going through it, high school is the worst form of wrestling... so many degrees of maturity, technique, and skill... if you suck at 145 lbs but can throw people around, i fyou drop 10 lbs and can still throw that weight, you drop a class to get a few easier wins
@Cyril it does seem kind of a bummer since you will never get to know if the guy from one bracket below can out-wrestle that guy because he's much better with his technique.
@Cyril you're basically saying that even if I'm only 10 lbs heavier, your superior technique won't be enough to beat me. That also sucks.
@this this i f'ing know... lived it. i was set to go to states my junior year of high school and got eliminated by the previous year's state champ at 125 (was for 119 wt class) because he lost weight to "wrestle" a match, forfeit the match so he could make weight before the cutoff, then spent the next two weeks moderating that to a maintainable weight
@this yes
in a good amount of cases, the truly technical wrestler will almost always win. being able to get out of a bunch of moves is great, but when you get caught by gorilla-boy, you are really, really f'd with that strength
had a couple friends who were legit technical geniuses on the mat; i believe they only lost when they gave up (which was often because they simply didn't want to get hurt against some asshole)
but more times than i can count, an upper-classman (junior/senior) cuts to a lower weight class to beat up on underclassman, who haven't had the time to mature physically/mentally
@Hosch250 schrutenkassen, i believe that's called. scottish sport
if you take you opponent off the ground in american wrestling, you must have a knee on the ground before they make contact. not the case for judo, as you land atop them
yes
better weight manipulation; i did san shou on the side of wrestling
as in throwing weight... handling other weight... the taoist principle
i can't do that move, but i'm more appropriately reacting when someone puts their hand on my neck, etc.
and time check... 15:26; i need to send out some credits to clients before i run. will catch you folks later
@this does "The request failed to run because the batch is aborted, this can be caused by abort signal sent from client, or another request is running in the same session, which makes the session busy." ring any bell?
@this remember I had to throttle HTTP requests to Shopify REST API? these intermittent exceptions make me feel like I now need to throttle the SQL Server commands....
basically I have too many things going on at the same time and SQL Server is freaking out
@M.Doerner I don't know whether the pool will just make new connections indefinitely. It might be possible that it's going to throw; would need to read the docs.
Back when I used the .NET connection pools, I recall that obtaining a new connection would get you a facade, where invoking "Close" would result in the connection being recycled into the connection pool
But for now, you can pretend it's 1:1 between connections and sessions.
Obviously, that breaks down if you expect the session state to persist on your connection.
(e.g. you're starting a transaction or recording the SPID, then letting the connection out of scope, then later open it again and expect it to still have the trasnaction or same SPID; it wont.)
does server setting "Remote query timeout" override an SqlCommand.CommandtimeOut? I'd think it's the other way around, but I have that timeout set to 0 and the server setting says 600 (seconds... which ...is a lot... nevermind)
> This value applies to an outgoing connection initiated by the Database Engine as a remote query. This value has no effect on queries received by the Database Engine. To disable the time-out, set the value to 0. A query will wait until it completes.
oh well. we have web hooks to configure, and then I'll have a scheduled script just plugging whatever holes the WinService leaves in the data
hey wait a minute... I'm opening the connection in HandleResponse, and then passing that connection to _repository.InsertUpdateAsync ....that makes no sense.
ah, it's because the base class is invoking the SP, and provides the connection to derived types for further processing... I'll just make it new up connections and see how it goes.
The solution I have in mind for the issue is just to log and swallow COM exceptions at the right place and to a log and swallow all around the one point I identified at which we do not do that at the highest level.
After the changes, what will remain of the issue should be that the caption of the refresh button never changes.
Dad: Why'd you nearly drown him son?
Iven: You told me not to put up with anyone's crap. He started it. I finished it.
Dad: You didn't have to hold him down so long.
Iven: Yes I did. If not he wouldn't have learned his lesson. Told him to quit 3 times already.
Dad: Don't tell mom I told you this but I'm proud of you right now. Let's get some ice cream.
the problem is more that RD originally has colors and whatnots hard-coded so they aren't sensitive to Windows theme
so one way to help make RD play better w/ Windows theme is to have its coloring derive from various system colors
but for making VBIDE actually dark, a la VS, as opposed to messing with Windows theme, would require custom panes for sure because VBIDE is lame like that.
VBA Rubberducking
VBA Rubberducking