The Form

LAPTOP QUESTIONNAIRE

• Total budget (in local currency) and country of purchase. Please do not use USD unless purchasing in the US: Whatever I can convince my parents to pay for. Multiple options in different budget ranges would be great. My current laptop is still working fine for most things I strictly need it for, it just also frequently makes me want to bash my head into a wall, so I can afford to wait and save up.
• Are you open to refurbs/used? Yes.
• How would you prioritize form factor (ultrabook, 2-in-1, etc.), build quality, performance, and battery life? Performance and durability, followed by battery life. I do not give a shit about form factor.
• How important is weight and thinness to you? Not very/if at all.
• Do you have a preferred screen size? If indifferent, put N/A. N/A
• Are you doing any CAD/video editing/photo editing/gaming? List which programs/games you desire to run. Gaming. Minecraft, vintage story, sims4. Other than that mostly just steam games. Looking for a windows laptop partially because I keep running into programs/things I want to do that work on windows but don't work on mac. Other programs I use include GPlates, Praat, Godot, Fontforge, OBS, SketchbookPro, and Microsoft Office (word, excel, etc.) I also use a Wacom drawing tablet.
• If you're gaming, do you have certain games you want to play? At what settings and FPS do you want? I would like the games to be reasonably functional. I don't need super high settings or FPS, I just want to stop lagging out constantly. At the same time, something that allows me to play at higher graphics settings would be a definite bonus.
• Any specific requirements such as good keyboard, reliable build quality, touch-screen, finger-print reader, optical drive or good input devices (keyboard/touchpad)? Good keyboard and a touchpad similar to a mac (not one with seperate buttons for clicking). A good microphone would be great, but is not a strict requirement. I would like at least 24GB of RAM and I want something that runs windows because I've reached the point where I keep trying to do various technical things that don't work on mac, but I don't have the technical expertise to feel super comfortable with anything other than windows, since that's the only other operating system that's easy to find tutorials for a lot of this stuff for. Something fairly durable (ideally more than my current macbook air) and/or repairable would be good: my laptops tend to get beat up a bit. I would also like something with at least 500GB of storage. More would be ideal but idk what the options are.
• Leave any finishing thoughts here that you may feel are necessary and beneficial to the discussion. I currently have a mac and would like the process of transferring all my files and stuff to be as simple as possible.

I have a 2022 MacBook Air with an M2 chip running OS version 12.7.6. I am trying to play a game that needs OpenGL. I have 4.1, but the version I'm playing requires 4.3. It still runs on 4.1, technically, but I've been having a lot of problems popping up and the tech support people on the server I was using said I should try to upgrade to 4.3 if possible. Unfortunately, they didn't know how to do that on Mac. I know that Mac stopped supporting OpenGL after 4.1, based on a quick Google search. It sounded like there might be some workarounds, but all of them were well above my level of computer experience. Could anyone walk me through how to get OpenGL 4.3 on Mac like I'm an absolute idiot?

I have a spreadsheet with names in column A and numerical responses in columns B, C, etc. I want to make it so that if, in a given row, column A contains a specific name (say, "Bob"), then the numerical value in column B in that same row will be added.

Basically, I want the sum of all the rows in column b for which column a contains "Bob".

I can't just sort by column a because sometimes it will contain multiple names per cell (ie Susan, Bob), and I need the equivalent numerical value to be added to both Bob and Susan's total.

I've tried google searching this but I can't figure out how to specify same row but different column. I know I could probably do this with what I know already using just like... a lengthy chain of conditionals, but last time I tried that I ended up with an excel file that crashes my computer every time I try to open it, so I was hoping there's a better option.

This is Version 16.85 on a Mac btw.