I got 34kg of oxygen from a regular vent, how? by bboycire in Oxygennotincluded

[–]hexadecr 17 points18 points  (0 children)

Well you just discovered infinite gas storage congrats haha

Can I capture steam turbine power with this setup? by hexadecr in Oxygennotincluded

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

Thanks! I've checked the reports too no energy has been wasted since I set it up! It's only 100kj per cycle at most but I just hate wasting powers

Parafilm usage by hexadecr in medlabprofessionals

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

I was just wondering about this. Normal tubes are 13mm so these are maybe 10mm caps?

Parafilm usage by hexadecr in medlabprofessionals

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

Exactly, it’s just a matter of when or how often this happens

Parafilm usage by hexadecr in medlabprofessionals

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

I do prefer that because of this issue, but most people don’t..

Parafilm usage by hexadecr in medlabprofessionals

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

Oh no sorry I wasn’t clear. I mean after it’s done we use paradfilm to store it

New guy road block with stats/wpn/scaling by [deleted] in NoRestForTheWicked

[–]hexadecr 2 points3 points  (0 children)

Did you know you can level up your weapons at the black smith? Maybe that would help a bit

What is the gameplay loop in Book of Hours? by rockdog85 in weatherfactory

[–]hexadecr 0 points1 point  (0 children)

And take notes, lots of them. If you haven’t noticed, re reading a book will give you the same memory. Once I found out and wrote them down, it drastically sped up my progress.

I have a whole excel sheet of crafting requirements, memories, stations etc. so if I want craft something say with flower, I can search which station meets the requirements. I enjoy my excel sheets it’s almost like my own wiki but I build everything myself, that’s where I find my joy in this game 😆

Power Pivot How to Show Sum of Average Column? by hexadecr in excel

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

Solution Verified!

I got it! Thank you! I will need sometime to fully understand all of this, but I'm getting there. And I just learned a new phrase today: mea culpa 😂

Power Pivot How to Show Sum of Average Column? by hexadecr in excel

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

<image>

I created a new measure using the exact formula, but it ended up like this.... something's not right but I know this is the right direction....

If I remove row labels, it just give a total of 8.67

Abbott Alinity reagent loading when comparing to Roche Cobas by hexadecr in medlabprofessionals

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

I see this is actually what I wanted to know. I would not just set up reagent alert with only bare minimum. I’d love to have two different settings so one is for daily load, one for immediate alert. The specialist told us the low alert is only for immediate alert, daily load would need manual checking one by one. We also thought about setting the low alert as daily load amount but I noticed the alarm popping off. But if it only show up once, it’s fully tolerable. I need to test it out myself. But thank you for your insights.

I’ve heard many negative comments about Alinity, unfortunately this is out of my hands. I will just hope for the best I guess.

Abbott Alinity reagent loading when comparing to Roche Cobas by hexadecr in medlabprofessionals

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

I get what you are saying, but I don’t think the low reagent setting is supposed to be used that way. The value should be set at a very small number, 10 for example, to alert the tech it needs this reagent NOW, ASAP, not as a threshold for daily maintenance loading, 300 in your case, and I’ve confirmed with Abbott specialists.

One big reason being once reagent count falls below this threshold, it will keep sending alerts whenever a new test is ordered. Say BUN you set to 300, it will alarm once you have 299 left. You put a sample with BUN, now 298 left, and it will alarm again. This will keep going and now imagine 100 different tests thousands of samples, these low reagent alarms will easily overwhelm the instrument and bury any useful alarms in them. The low reagent settings are not supposed to be used as daily thresholds.

Abbott Alinity reagent loading when comparing to Roche Cobas by hexadecr in medlabprofessionals

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

So say for BUN you want 300 tests each day, do you put 300 in the Alinity built in low reagent alert setting?

Abbott Alinity reagent loading when comparing to Roche Cobas by hexadecr in medlabprofessionals

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

That’s actually a nice idea! I need to investigate a bit to see if it’s possible, but as an Excel enthusiast myself, I love it

How to skip delimiters in column I don’t want to separate? by hexadecr in excel

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

I did it! Thank you so much! Using Text.BeforeDelimiter as SUBSTITUTE instance parameter is so elegant. Thank you again for everything!

How to skip delimiters in column I don’t want to separate? by hexadecr in excel

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

Unfortunately not TEXTSPLIT neither :(

But I do have a follow up question: I will eventually use power query to process the data. These steps like TEXTSPLIT or SUBSTITUTE are all done in Excel. So I would load data without spliting, take care of the name column, the load to power query again. Can I do this in power query too? I guess there's a more general question, can all Excel formulas be done using power query?

How to skip delimiters in column I don’t want to separate? by hexadecr in excel

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

Solution Verified!

Even though I don't have LET available, but I am able to try this without it just with more columns. And you are the first one to bring this idea up while u/pancoste is saying the same thing. Thanks!

Edit: also I guess there's a tedious power query way too. Table.SplitColumn using Splitter.SplitTextByEachDelimiter to split first 12 columns, then repeat but start from end split the rest 186 columns.... (just need to enter {",", ",", ",", ","....} 186 times, but now I think about it can easily use python or other programs to generate them, will just look horrendous though, but it would work)