TURBORETARD9000

@TURBORETARD9000@bae.st

Exactly what it says on the tin

Let's be friends, and Make Fedi Comfy Again!

#NoCondomClub 's leader and mouthpiece

This profile is from a federated server and may be incomplete. Browse more on the original instance.

sjw, to random
@sjw@bae.st avatar

I need to get one of these cans of popcorn

Also, is cans of Christmas popcorn just an American thing or do other countries have them too?
PXL_20231215_164215773.RAW-01.COVER.jpg

TURBORETARD9000,

@sjw @McMongoose you can wash out the cans and use them as storage and makeshift trash cans

TURBORETARD9000,

@sjw @McMongoose I was the opposite
Cheddar got boring the fastest

TURBORETARD9000,

@sjw @McMongoose @ins0mniak I want to fill one with rocket candy

TURBORETARD9000,

@sjw @McMongoose My only wish was for them to replace the cheddar or butter with kettle corn

Kyou, to random
@Kyou@kyou.social avatar

Next they should add cock, balls and ass jiggly physics to them

TURBORETARD9000,

@Kyou put them in skirts

Kyou, to random
@Kyou@kyou.social avatar

4 years since the last time I went to the beach :fxface:
I used to go every year

TURBORETARD9000,

@Kyou :hug: hopefully you'll be able to go soon

TURBORETARD9000, to random

How do I use INDEX() and MATCH() over multiple sheets at once?

I've got five sheets in total: one summary sheet, and four specifics sheets
Sheet1 occupies A1:F99, the others A1:H99, with A1 being column labels and entries going down
Product IDs are column A, product names column B on all sheets
On sheet 1 I want the value of column B to be fetched from the same row on any of sheets 2-5, because some sheets may have products others don't. There will be duplicates across sheets, they cannot be assumed to occupy the same row on different sheets, but you can assume the same ID will have the same name
Currently trying to do adulting stuff and trying to play into my compsci fixation

TURBORETARD9000,

@sjw You know anyone good with spreadsheets?

TURBORETARD9000,

@sjw lmao yeah

TURBORETARD9000,

@sjw @jeffcliff @s8n ok figured it out

I hate it but it works

=IF(NOT(ISERROR(VLOOKUP($A2,$Sheet2.$A$2:$B$99,2,0))),
VLOOKUP($A2,$Sheet2.$A$2:$B$99,2,0),
IF(NOT(ISERROR(VLOOKUP($A2,$Sheet3.$A$2:$B$99,2,0))),
VLOOKUP($A2,$Sheet3.$A$2:$B$99,2,0),
IF(NOT(ISERROR(VLOOKUP($A2,$Sheet4.$A$2:$B$99,2,0))),
VLOOKUP($A2,$Sheet4.$A$2:$B$99,2,0),
VLOOKUP($A2,$Sheet5.$A$2:$B$99,2,0))))

TURBORETARD9000,

@s8n @sjw @jeffcliff I'm using libreoffice :sob2:

TURBORETARD9000,

@sjw @jeffcliff @s8n It's not SQL
SQL could probably do it more efficiently once I've learned it

Kyou, to random
@Kyou@kyou.social avatar

deleted_by_author

    •
    TURBORETARD9000,

    @Kyou mfw all my ram is cannibalized from previous computers

    icedquinn, to random
    @icedquinn@blob.cat avatar

    ah yes. the hex grind planet aesthetic.

    TURBORETARD9000,

    @Awoo @icedquinn hexagons are the bestagons

    Kyou, to random
    @Kyou@kyou.social avatar

    Would you wear this

    TURBORETARD9000,

    @Kyou ... maybe
    But not in public
    Not yet...

    Kyou, to random
    @Kyou@kyou.social avatar
    TURBORETARD9000,

    @Kyou I hope they have so many babies... :hibiki_hnng:

    Hoss, to random
    @Hoss@shitpost.cloud avatar

    Whenever a regular poster in this circle of Fedi suddenly goes radio silent, I assume he was graduated from the government watch list to the government act list.

    TURBORETARD9000,

    @Awoo @MK2boogaloo @Hoss @Zerglingman Fifteen F-16s have been beployed to your location

    mushroom_soup, to random
    @mushroom_soup@breastmilk.club avatar
    TURBORETARD9000,

    @Awoo @YTFoidLover1488 @burner @mushroom_soup If they all look half as good as Abby, gladly

    TURBORETARD9000,

    @Awoo @YTFoidLover1488 @burner @mushroom_soup if they make my dick hard they make my dick hard, I'm not going to lie to myself

    Awoo, to random
    @Awoo@bae.st avatar

    image.png

    TURBORETARD9000,

    @Awoo @Kerosene @Kyou @McMongoose Kyou is HR and her weapon of choice is this
    Screenshot_20181030-095933_Google-640x333-1656828114.jpg

    TURBORETARD9000,

    @Awoo @Kerosene @Kyou @McMongoose the military couldn't stand the idea that someone can make more freedom than them and were too stupid to steal it

    Terry, to random
    @Terry@breastmilk.club avatar
    TURBORETARD9000,

    @Awoo @Terry He's finally lost it

    TURBORETARD9000,

    @degen @Awoo @Terry sometimes it's the same thing

    sjw, to random
    @sjw@bae.st avatar

    Would you fugg your wife right in the thigh gap?

    https://bae.st/media/a42e59b57d26af5fff0d9c8b6b3f933029e5c0f88227e60063c3be615e40e5ed.png?name=pool_91884832.png

    TURBORETARD9000,

    @sjw @1iceloops123 IMPREGNATE

    DiamondMind, to random

    @Terry @CatLord @Inginsub @NecroKvntPuke @SoyMagnus @Waerloga @anonymous @dcc @ehhh @gh0st @ins0mniak @jasonl8446 @kumicota @lunarised @mac_ack @mia @mischievoustomato @p @peemasons @pressure @pwm @redneonglow @sjw @threat @tiskaan @triodug @warmbeverageenjoyer we are celebrating the mass deaths of the vaxxed and the new White Lung disease in this thread, in jubilation! https://boards.4chan.org/pol/thread/450807013

    TURBORETARD9000,

    @DiamondMind @mischievoustomato @dcc @threat @Terry @jasonl8446 @kumicota @redneonglow @sjw @Inginsub @pressure @pwm @tiskaan @triodug @NecroKvntPuke @SoyMagnus @Waerloga @amerika @anonymous @gh0st @ins0mniak @lonelyowl @mia @p @warmbeverageenjoyer @mac_ack @CatLord @peemasons @ehhh @lunarised rape and breed time

    TURBORETARD9000,

    @lunarised @mischievoustomato @dcc @threat @Terry @jasonl8446 @kumicota @redneonglow @sjw @Inginsub @pressure @pwm @tiskaan @triodug @DiamondMind @NecroKvntPuke @SoyMagnus @Waerloga @amerika @anonymous @gh0st @ins0mniak @lonelyowl @mia @p @warmbeverageenjoyer @mac_ack @CatLord @peemasons @ehhh damn right

    TURBORETARD9000, to random

    @jeffcliff @admitsWrongIfProven @sjw I don't have screenshots or shit yet to show but who wants to watch me make an RV32I core in a visual manner
    Hoping to get to RV64G + Supervisor eventually

    TURBORETARD9000,

    @ai @ceo_of_monoeye_dating @jeffcliff @p @sjw That being said, I'm gonna have to do a lot of digging into microarchitecture and that sort of meta-logic very soon in order to make those instructions work, and to get a unified memory architecture

    TURBORETARD9000,

    @ai @ceo_of_monoeye_dating @jeffcliff @p @sjw multiplication extension added and cpu organized
    Screenshot_2023-12-03_15-47-49.png

    TURBORETARD9000,

    @ai @ceo_of_monoeye_dating @jeffcliff @p @sjw wait I'm dumb I can eliminate two of those dividers

    TURBORETARD9000,

    @ai @ceo_of_monoeye_dating @jeffcliff @p @sjw I feel now would be a good time to try and figure out how to unify the memory space, because before I can implement CSRs, I'm probably going to want to add atomics
    I want to keep it stupid simple at first though
    ... also I just realized I overwrote the base core...

    TURBORETARD9000,

    @ai @ceo_of_monoeye_dating @jeffcliff @p @sjw uhhhhh ok yeah this is an interesting hurdle
    Multi cycle architecture never quite clicked with me but I think the amount of stuff in front of my face is distracting me

    TURBORETARD9000,

    @ceo_of_monoeye_dating @ai @jeffcliff @p @sjw well tbh pipelines are more foreign to me, I've never really strayed far from single cycle simulation, but that doesn't work if I want to fetch instructions and data from the same place

    TURBORETARD9000,

    @ceo_of_monoeye_dating @ai @jeffcliff @p @sjw In theory, I have dual port RAM pieces, but it doesn't have unaligned access, and I'd rather have that

    TURBORETARD9000,

    @ai @ceo_of_monoeye_dating @jeffcliff @p @sjw wait
    Fuck
    If I want to move to rv64 I'm gonna need 64bit data
    Which the unaligned chip doesn't do...
    So I'm going to have to make a new chip anyway

    TURBORETARD9000,

    @ai @ceo_of_monoeye_dating @jeffcliff @p @sjw I just skipped the hurdle lol
    Now have ROM at 0x0, Dual-port RAM at 0x80000000
    Screenshot_2023-12-04_02-11-55.png

    TURBORETARD9000,

    @ai @ceo_of_monoeye_dating @jeffcliff @p @sjw I can now use the ROM to bootstrap and hold traps and shit
    Once I get there

    TURBORETARD9000,

    @ai @ceo_of_monoeye_dating @jeffcliff @p @sjw Notably: due to java constraints I haven't cared to change yet, only 8MiB each ROM and RAM

    TURBORETARD9000,

    @ai @ceo_of_monoeye_dating @jeffcliff @p @sjw Ughhhhh this is foreign waters to me
    I'm trying to go through the Spike simulator codebase to glean what I can about how CSRs and privileges ISA is supposed to work and it's all blurring together

    TURBORETARD9000,

    @ai @ceo_of_monoeye_dating @jeffcliff @p @sjw I found someone's implementation of cache and wew boy do I have a lot to learn

    TURBORETARD9000,

    @ai @ceo_of_monoeye_dating @jeffcliff @p @sjw Ok so in theory I can use this to get a better idea of how to pipeline this shit, and eventually add things like branch prediction and cache
    It's going to be.... a lot of work but at least now I have a diagram to read
    https://arxiv.org/pdf/2002.03568v1.pdf
    I also found a sim file for a pipelined MIPS CPU with full hazard detection so 🤞

    TURBORETARD9000,

    @sjw @ai @ceo_of_monoeye_dating @jeffcliff @p tfw the only architectures I've put my time into were x86 and Risc-V

    TURBORETARD9000,

    @sjw @ai @ceo_of_monoeye_dating @jeffcliff @p holy shit interrupts
    I need them asap
    I thought there was something missing

    TURBORETARD9000,

    @ai @ceo_of_monoeye_dating @jeffcliff @p @sjw Damnit I need part of the privileged ISA anyway
    Ok back to figuring out CSRs and pipelining and IO

    TURBORETARD9000,

    @ai @ceo_of_monoeye_dating @jeffcliff @p @sjw interim first stage
    image.png

    TURBORETARD9000,

    @ai @ceo_of_monoeye_dating @jeffcliff @p @sjw Following these videos, it's a bit confusing because he's using MIPS but it's kinda piecing itself together
    kinda

    TURBORETARD9000,

    @ai @ceo_of_monoeye_dating @jeffcliff @p @sjw
    MIPS pipeline
    Risc-V pipeline
    first three stages?

    Risc-V pipeline
    first three stages?

    TURBORETARD9000,

    @ai @ceo_of_monoeye_dating @jeffcliff @p @sjw Getting there
    image.png

    TURBORETARD9000,

    @ai @ceo_of_monoeye_dating @jeffcliff @p @sjw Notably I still haven't handled branches and jumps and hazard detection or even basic testing yet

  • All
  • Subscribed
  • Moderated
  • Favorites
  • •
  • random
  • Hentai
  • doujinshi
  • announcements
  • general
  • All magazines
    •