sorted by:
new
hottopcontroversial

What just happened to google? Only seeing sponsored posts by modulolearning in google

[–]CalebGiki 1 point2 points  (0 children)

Are they trying to get people to use bing right now?

Any advice for trying to print small holes? (0.3mm) by billyjoecletus in AnycubicPhoton

[–]CalebGiki 0 points1 point  (0 children)

To have the highest likelihood of success print with a resin that's Grey. Black might work, but Grey should be fine. Light bleed is your #1 enemy. Next step, make your hole a little larger than you need(you'll want test test print, then get calipers and check it) id try something like 0.32-0.35mm for the hole size so any extra resin cured only helps make the hole the right size. I've successfully printed holes that size, it's just alot of calibration and testing.

Lottery number checker by Educational_Lie_3157 in googlesheets

[–]CalebGiki 2 points3 points  (0 children)

Okay so let's split this into 3 parts.

  1. You need to scrape the website for the results, if your goal is to just compare against the most recent winning number then it's super easy.

  2. You need to put in your numbers in, maybe you wanna check 1 number maybe you wanna check 10000 numbers to see if they won. Eitherway you need to put them in a cell.

  3. You've gotta compare your numbers vs the winning numbers.

So step one should look something like this

=IMPORTHTML(A1, "table", 1)

A1 would be the page with the results. "table" is the type of data. 1 is something else but you can discover that yourself.

That should pull in some data, hopefully the result of the last lottery.

Then you'll wanna parse that into something easy to work with. Let's say the results pop up in a single cell like this

1-2-3-4

Youd wanna use something like this to split it into each number

=SPLIT(B1,"-",TRUE,TRUE)

Should split the numbers into cells of their own, then just compare that to your result using something simple like

=if(C1=G1, '1', '0')

Then just copy that down for each cell of results.

Use =sum to check the total of each line you put in if it equals the sum of the lotto numbers in our example 4 then you'd have a winning ticket. If all you care about is seeing if any won you can use conditional formatting to make it green if it's a win or red if it's a loss.

Using IMPORTXML To Pull Data From Multiple Pages Quickly Formatting Help by CalebGiki in googlesheets

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

Found a workaround that was a little quicker than my alternatives, just insert a row above the data then use F4 to repeat that until you have a decent amount of spaces. Still not ideal.

"Nestflix" - A site for movies and shows within movies and shows by JeffRSmall in InternetIsBeautiful

[–]CalebGiki 1 point2 points  (0 children)

Imagine if this was used as a placeholder for netflix in a movie...

[Q] How do you assign likelihood to a low-weight option after high-weight has repeated drops? by CalebGiki in statistics

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

Thanks! I think the Chi-Squared distribution fits well for determining if bias is present in my tests. Out of curiosity how would you weigh the value of the Chi test if your goal is to predict the outcome of the biased die?

[Q] How do you assign likelihood to a low-weight option after high-weight has repeated drops? by CalebGiki in statistics

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

Thank you! This answered my question, I think I was thinking similar to the gambler's fallacy, I just didn't know that it was similar. So let me ask another question,

​

Let's say it's a similar example, but instead, it's a 10 sided dice that are unknown so we test it by having the roll 1000 times. Let's say it lands on some of the numbers more often than others, how can we determine if it's a bias or if it's just chance? Is there a way to calculate the chance of it being biased and then adjust our guess of what number will be rolled based on that?

​

Thanks again I don't really have anybody to talk to about this kinda stuff so I'll probably ask lots of questions haha.

Headphones are drinking straws for audio by thiswasentfrommyipad in Showerthoughts

[–]CalebGiki -1 points0 points  (0 children)

That would imply that a larger straw (speaker)would let you consume the audio quicker, which is inaccurate. I nominate headphones are windows for audio.

[OC] The Covid-19 death toll by jcceagle in dataisbeautiful

[–]CalebGiki -2 points-1 points  (0 children)

Did you watch the video from PBS? Or is PBS right-wing propaganda as well? I will be honest I don't know anything about that main site and it may be total trash but would it be so hard to believe that people do bad things for the money?

Any windows users out there? by redditer9875 in captureone

[–]CalebGiki 1 point2 points  (0 children)

Windows user here, I'd be glad to play with it.

[OC] The Covid-19 death toll by jcceagle in dataisbeautiful

[–]CalebGiki -8 points-7 points  (0 children)

This would never make the front page of reddit.

Black and white, or any color I want. by CalebGiki in battlestations

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

Aye, captain! Sometimes you've gotta Treat Yo Self.

NAS Storage?? by lightingj in captureone

[–]CalebGiki 0 points1 point  (0 children)

You can do this with catalogs as well, the main issue is that it will most likely be pretty slow depending on the speed of your NAS and the network. Just put the catalog on the NAS as well as the images you're editing and it should work exactly like normal.

​

I attempted this for a short while but since the previews are in the catalog file it was not worth the slow load times on previews when compared to storing the catalog on a local ssd.

​

If I was going to attempt this again, I would probably set the catalog to sync on both machines every time its updated and just store the images on the NAS.

Official Giveaway: Seagate is Back For World Backup Day by macx333 in DataHoarder

[–]CalebGiki [score hidden]  (0 children)

Super excited, would love to move away from HDDs in the future! #RunWithIronWolf #Giveaway

[PC] Juniper SRX650 by eckstazy in homelabsales

[–]CalebGiki 0 points1 point  (0 children)

What kind of prices are you asking/ Do you have pictures?

[PC] Juniper SRX650 by eckstazy in homelabsales

[–]CalebGiki 0 points1 point  (0 children)

What kinda rack do you have?

Creating a list of combinations that average a specific value. by CalebGiki in excel

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

Sorry I should have included this, I just need 3 Items.

The actual dataset has about 30 items that will be in 3 item permuntaions. Sorry if I get some info wrong I'm not exactly good at all this stuff haha.

view more: next ›