>>108853470
Very funny

>>108853495
What do you need to learn to do it in exactly?

>>108853656
Creating spreadsheets for financial purposes, for example to organize my salary or create a bankroll for sports betting.

>>108853464
Just use AI.

>>108853862
Which of them is the best?

>>108853871
Actually a good question. Afaik, none. Like... They can't do it.

>>108853464
Vibe code them with Google AppScript

>>108853854
It is pretty straightforward. There are cells.
>You write 1 and A1
>You write 1 and A2
>In A3, you write =A1+A2, then click out
>A3 now shows as 2

I just loaded it in forever, but the first thing it showed me is "get AI help", so get in there, try, and talk with the chat bot.

If you want a YouTube playlist, only you know what type of teaching style works well for you. The general advice is to stay away from influencer slop, but if you just want to know how to get started with the very basics, even influencer slop might be ok for your needs.

File: 1755194980808.gif (2.43 MB, 320x240)

2.43 MB GIF

>>108853464
It's literally just a big ass array nigga lmao

>>108855082
can you write code in google sheets like VBA in Excel?

>>108853464
I'll give you a primer on the bone basics.

Spreadsheets were the original nocode lifehack. In the end, they got really complicated. They aren't actually intuitive.

You have to know about like this thing spreadsheets do, where sometimes they change your input, like right when you input it. And the other thing is dragging certain numbers or letters. They try to guess if you are typing a sequence and auto fill that. So that's a thing to learn, like they can auto fill like 10, 20, 30 into cells or rows inferring on the two being highlighted. But the end effect of this is actually like if you typed it.

The other thing is that cells contain either text, a formula, or a number. But, they have settings that determine how they look. There also are um. I forget what they're called, like style things that format the color and stuff. I know Sheets offers color-based highlighting, and those rules are in another layer, like basically settings for rows, although I guess it is actually a range. anyway, that's another layer.

And another layer, that's scripting. to varying degrees you can write programs. At least, in Excel you can. idk about Sheets, never tried.

But the real star of the show is the formulas.

AND a devil, the way formulas are copied.

All modern spreadsheets have columns, that's along the top, and it goes A, B, C, D etc and then it combines letters, like AA, AB, AC, AD... through ZZ, I guess, I forget how far it goes lol. Less columns. the rows are marked on the left and you have the main limitation of your spreadsheet there, whatever the max rows it supports is. 1,048,576 is what Libreoffice calc reports. Libreoffice Calc kind of sucks and has bugs if you do huge spreadsheets. but as an aside I have encountered a major bug in (Andriod) Google Sheets, but it might be fixed now.

Anyway, the way you refer to a cell - IN A FORMULA, ok? in a formula, ok the way you refer to a cell is like A1, that's the very first one.

cont

>>108855381
So how do we type a formula anyway?

Well this is the stupid "intuitive" thing we do. We begin a formula by typing =

an equals sign.

how do we begin typing?

well ok so you click on a cell, that's one of the uh places for putting stuff, in the spreadsheet. one of the "squares" - rectangles, usually.

you click on one, and just start typing, click on like one in the middle and type....

=A1[enter]

did you notice that as you type it appears in two places, in the cell, but also in that cell area in the toolbar? Yeah, so *AFTER PICKING A CELL* clicking there and typing is another way to enter stuff, formulas or text or numbers. But there's also F2 that you can hit.

See, F2, there's your DOS thing, clicking in the formula thing, that's the Windows one, and the just typing one, idk, it's like newer windows I guess.

ok so by now you have probably noticed that you can't even tell you typed anything, because after you hit enter, the cell moved down, because spreadsheets used to be used by secretaries a lot. I guess still.

warning. When you hit [home] it may go batshit. don't ask why, spreadsheets kind of suck in certain ways, you can actually learn how to deal with it, but idk.

oh yeah.

the fucking formulas ok

You have only entered anything into that one cell in the middle, whatever it was.

well, go to A1, that's the top left actual cell you can put stuff in..

aw snap of course there's another way to enter formulas/text/numbers. double clicking. ain't that nice?

anyway, put asiprtufwynadfupty in A1, or whatever, put your mom, then hit [enter]

yeah so it's in two places now, pretty cool right? no.

anyway, type something else, now that you're in A2, because you hit [enter]. hit asf;9yuwjrt;afdrtadrt and then [enter]. or your postman's name. we are doing your family tree.

obviously, put some text in A3, A4, A5, and A6. It doesn't matter, because honestly you're not gonna reproduce.

now these sheets are gonna reproduce tho
con

>>108855404
Now see that cell in the middle where you typed A1, and now it has your mom? ok well we are going to click on it once. you could also use the arrow keys to select it. You can also you the goto function thing, but idk there's also something called named ranges and you don't want to get into those yet.

anyway, you are gonna hit [ctrl]+c and now it will have dancing ants around it. I have no idea why this is the tradition. That represents the from part of the clipboard. uh. ok so like drag to select several cells below the one with the dancing ants. you're gonna hit [ctrl]+v now.

ok so obviously that's fucking stupid, it didn't copy what you selected, it now shows your dad the mailman, and like idk, maybe your quarter mexican half sister. so now what you need to do is like idk fucking click on them cells but what you pasted just now. Check it out, that's the fucking thing you mainly have to get used to with spreadsheets, actually, not that other stuff I said. That shit right there. those are RELATIVE addresses. It's literally just the software doing that weird thing, it's supposed to be an awesome feature.

you can also use the little square thing and drag it. because of course you can do it another way. and you need to know you can sometimes double click that little square thing.

ok so like here's the deal, when you copy and paste relative addresses, they get changed by just however many up/down/left/right you paste it TO

yeah. to. because the software is fucking with you, because this is intuitive.

If you copy the formula you have in the middle that you typed, the =A1 to the right a couple of cells it will paste as =C1 or =D1 or whatever, like depends how far over you're pasting.

but like if you have a $ in front of the letter... or the number... in a particular address in a formula, like that one stays and doesn't change, and this is where some of the "Excel wizardry" comes from.

important note. an ' apostrophe make it do be text homey

>>108855428
There are also certain specialty types of functions that do things like uh. they call them database functions. Like there are lookup formulas, and let me tell you, you can learn them, and they aren't as good as they should be. They exist because back in the day computers sucked and databases were too slow / expensive / hard to use.

Yeah so of course a spreadsheet can query a real database, because why not make it even more annoying?

I don't think that honestly the database functions are that hard to learn, I just want to warn you that when you use them, like it's much more limited than a real database, so sometimes you think it will do something that is *really hard to do* but sounds easy, and is easy in a real database.

formulas have things like concatenation, which is easy to learn.

something related to the wizardry is address() and row() and column() and indirect().

=INDIRECT(ADDRESS(ROW(),$AD2-AG$1))

an example from a recent spreadsheet of mine.

sed and awk are honestly better, but like whatevs, I learned spreadsheet stuff.

You'll want to know how about pasting values only, pasting formulas, and paste rotate.

You'll want to know what's up with sheet references. Spreadsheets are 3D, technically, but most formulas don't work in the 3rd dimension, and the syntax is horrible. The exclamation thing. It's easy to try it, start entering a formula in one page and click on a cell in another sheet, it will fill the formula out for you.

The main way to not suck is don't wait for assignments, try and do shit like instantly, like not waiting, like put shit in there.

idk, print ranges are weird.

oh, a trick. if you click in the formula bar thing, again, that's like a url bar, that thingy. well, you can select your formula and honestly, I'll hit [ctrl]+x and then [esc] and now the REAL formula is in your real clipboard so when you paste, it's exactly the same

>>108855352
Yes. It's called Apps Script and its basically javascript.