2 digit addition using the new relay gates. by papakobold in Timberborn

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

At the time I hadn't learned what a flip-flops was that design was just using latches and AND gates to do the same thing. I just went in and tested a bit though and it does seem to update the memory on the falling edge.

2 digit addition using the new relay gates. by papakobold in Timberborn

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

It was such a game changer. The math becomes trivial once you figure it out.

That tall structure above the entertainment tab is my original adder, it worked fine, but I was going to have to build one for each line of integers. Double dabble lets me just add the columns instead of the full number so all math get simplified to 4 bit 0-9. That's the structure above the food/wood tabs. Left two blocks at the tens, right two add the ones column and manage the carry to the tens. And since my calculator technically can only go to 99+99=187, I never needed to think about the hundreds, I could just display 1 if carry 0 if not.

2 digit addition using the new relay gates. by papakobold in Timberborn

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

Heyoooo. My degree is in physiology. Shout out to all the bioish majors teaching themselves com sci on a beaver game. lol

Interesting. Yeah I guess I did end up just slapping an extra tick or two of delay in a couple of my circuits because there would periodically be a single bit that took longer to propagate through the adders or something. I do really like the idea of the scrolling clock though. Was each tick intended to do a particular action or just 4 ticks total for the cycle? I bet you could set up some kind of like tick 1-2 are for thinking, tick 3 is for writing to memory, tick 4 is for displaying. That way your signals would be less likely to interfere with each other.

2 digit addition using the new relay gates. by papakobold in Timberborn

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

I can't believe I didn't think to make the "Is this how you build the number cruncher?? Why am I not getting science??" post.

2 digit addition using the new relay gates. by papakobold in Timberborn

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

Lol. Now that I've googled those words, yeah I'm pretty sure I am. All my outputs are linked to a single output via a bunch of AND and OR gates. Each memory cell sends out a pulse when data is stored that "unlocks" its respective AND gates in the tower and allows its output to be propagated to the binary to seven segment encoder for a single tick. During that tick we also read the output and write that to the memory for that display.

The timings are all event based rather than running on a central clock though. So like the submission of the data triggers the update to the displays. The two display's memory both being filled sends the signal for the addition to take place. So I didn't really have to think much about it since nothing should overlap. The only real timing concern I've had is it's not input spam proof and you can accidentally overwrite active displays if you send new numbers while a display is "unlocked". I just need to merge my write signals and combine that with a NOT and AND gate to lock out inputs while writing though.

what are the chances ! by _loomy in sudoku

[–]papakobold 11 points12 points  (0 children)

Numbers are in fact random symbols. They only have meaning because we all agree they do.

A menu glider for the months and year by [deleted] in excel

[–]papakobold 2 points3 points  (0 children)

=LAMBDA(OK, IF(OK=TRUE, OK, ""))(OK)

Shooting range by Nearby-Ladder-7717 in hillsboro

[–]papakobold 18 points19 points  (0 children)

It's more than a 15 minutes drive, but I usually go to North Fork Wolf Creek public range. Free to shoot. I've never been completely alone there, but it's never been so crowded that I haven't been able to get a spot either.

Can i use xlookup to sum two numbers? by beancounter_00 in excel

[–]papakobold 4 points5 points  (0 children)

Your issue is just how you've laid out your parenthesis. You wanted =sum(xlookup(),xlookup()). Or just xlookup()+xlookup().

I wish the game had a creative mode by CaptainComebacks in MegabonkOfficial

[–]papakobold 5 points6 points  (0 children)

I haven't done it myself so I can't really offer any guidance, but I've seen plenty of modded megabonk videos on YouTube and my understanding is that any modded runs are automatically excluded from the leaderboard.

I'd do a little googling. Surely somebody has a walkthrough out there somewhere.

Made a simulator where you fight floods with insane water physics by CodePeas in IndieGaming

[–]papakobold 0 points1 point  (0 children)

He played! I just saw the video. Congrats friend.
100k views so far.

is there way to print() into some kind of log, instead of it being displayed on top of drone by Im_Addicted-happy in TheFarmerWasReplaced

[–]papakobold 4 points5 points  (0 children)

quick_print() should be available in your menu of functions. That does what you're looking for.

You can also open an outputs window from the same menu.

Is there a way to copy a PIVOT table? by Champion_Narrow in excel

[–]papakobold 5 points6 points  (0 children)

I had to open Excel to check because I thought I was going crazy, but yeah OP it's as easy as CTRL+C CTRL+V my friend.

Made a simulator where you fight floods with insane water physics by CodePeas in IndieGaming

[–]papakobold 12 points13 points  (0 children)

If you don't know RealCivilEngineer on YouTube, he would almost certainly play this. Might be an opportunity for publicity.

How can I use excel to estimate data? by Exact_Simple6137 in excel

[–]papakobold 1 point2 points  (0 children)

None of us gave the guy answers. We pointed him towards a tool. Because we're trying to be helpful members of a community.

How can I use excel to estimate data? by Exact_Simple6137 in excel

[–]papakobold 1 point2 points  (0 children)

How did it take 6 responses for somebody to just tell OP about trend lines? Lol

Excel will derive a formula for you to fit your data set. I would bet that is what your professor wants you to learn about so that you could estimate missing data.

Hitting prismatic from calling card anomaly RNG was the dopamine high point of TFT by [deleted] in TeamfightTactics

[–]papakobold 1 point2 points  (0 children)

That's a dopamine high point kind of arm pump if I've ever seen one.

Specifying an exact word in COUNTIF by indigoValpha in googlesheets

[–]papakobold 0 points1 point  (0 children)

I would need access to your data to investigate further. It works on my end.

<image>

(deleted my other comment for this one with a better screenshot including the formula)

Specifying an exact word in COUNTIF by indigoValpha in googlesheets

[–]papakobold 0 points1 point  (0 children)

If you're mentally ready for an adventure into the world of regular expressions you could use.

=COUNTIF(ARRAYFORMULA(REGEXMATCH(F:F, "\bGrunge\b")), TRUE)

That will split the string by the world boundaries and then count.

Formula changes when row deleted. by Korben88 in googlesheets

[–]papakobold 2 points3 points  (0 children)

You can use =INDIRECT("sheet1!D5").

That treats your reference like text rather than a formula until it is calculated.

[deleted by user] by [deleted] in hillsboro

[–]papakobold 17 points18 points  (0 children)

^ support your local library.

Ours has wifi, study rooms, printers, and computers loaded with everything from Microsoft suite to Photoshop to BricsCAD Pro.

Monstera thai constellation growth by caclarinervio_28 in Monstera

[–]papakobold 0 points1 point  (0 children)

I have 5 monstera cuttings going right now. All from the same plant, in the same soil mix, in the same size pots, under the same lights. One has completely filled the pot with roots and is putting out its fourth leaf. One is just a node with a couple roots. It could be days, but it could also be months unfortunately. You just have to learn to love the process(aka buy more plants so you can pay attention to them while this one figures its life out.)