 All right, what's up everyone? So I wanted to do a brief video on SCIM I'm just gonna call it skim Actually a subscriber recommended this to me. It is a terminal based Spreadsheet manager and I have sort of implicitly always been looking for one of these things just because You know, you might have seen some of my videos where I'm doing my workflow And I have all these terminal programs. They're all VIM based and then I have to use Excel for something And I have to open up this huge program yada yada. It's just a huge pain So he directed me to this and I actually love it. I I've only gotten I Don't want to say superficially into it because there's so much you can do in this program But it is definitely worth looking at I might do videos on the in the future on this as well So I'm gonna open it up again. It's terminal based so you can just open up any file It reads CSVs its files natively by default are like SCs, but it can read CSVs. It can read Excel files stuff like that So I'm gonna go ahead and open this up. I'm sure I'm gonna make it a little bigger So maybe you can see it better So let me turn on screen key that would make sense Just right off the bat, you have VIM based bindings So you have like hjkl to move around you can use the arrow keys if you really want I don't know why you'd want to do that. So you got hjkl. You also have things like so like capital L for the lowest portion or capital H for the highest portion Capital M for the middle stuff like that You also have let's see what other VIM kind of things. So you have like gg to go to the top G and then dollar sign is go to the like right most visible place You have g0 which does the same thing of course It won't force you to go to the first line like gg will and I think you also have gm and that puts you in the middle So just basically VIM like bindings and even with just these I'm already sold because whenever I'm using Excel Whenever I pull that thing up. I just already want to use VIM bindings just because I've been using them everywhere else So this is like already a selling point for me But there's a whole lot of other stuff as well So inserting stuff. So skim treats text and numbers like strings and numbers as essentially different things Now to insert text you usually use the angle brackets So if I do right angle bracket, I can just type in, you know some kind of text and That will actually have it right aligned if you want left-aligned text you use the left angle bracket And do that or you can also have the backslash, which we'll put it in the center So all of those are ways of inserting text But unlike Excel, it's not well Excel technically treats texts and numbers differently But you sort of put them in the same way in skim you insert numbers with the equal sign So I can say insert four and now this it appears as four point zero zero This is you know, it treats that as a number In fact, you can actually have numbers and strings in the same cell so you can have you know string So you'll see up here. It actually Has a string and four in it, but of course if I want to get rid of that string I can just write over it by typing in zero So the other thing that's pretty cool is Well, actually I should go ahead and say this so let's say have a really long string. So this is a long String this sort of annoys me by default skim like just puts a puts a bunch of asterisks Asterisks is what a difficult word to pronounce so it puts a bunch of the stars and So which is kind of annoying I don't know why they just don't like you know strip off a part of it But if you want to see the whole text you just press a a and that'll give you the automatic length of it So again, there are Vim like keys here So you can press X to delete something in a cell actually I can realign that by pressing a again Now it's sort of automatically aligned And also if you don't if you just want a little bit more room you can use f f is sort of well If you use F H and f L So F H will shrink a column f L will make it a little bit bigger So those are both pretty useful and you might be wondering what f J and K do and if you actually look at I don't know why I'm pointing to it like you can see it But if you look at four here if I press f J You'll see that that actually decreases the decimal value F K will actually increase it. So that's a nice little tool to have When you're especially when you're doing sort of advanced equations and you want you really care about your decimals and stuff like that So anyway, this is just we're only barely getting into this stuff. So that's inserting text You can also modify it and the way you modify text can actually be Vim based as well So let's say I have a really long string. So this is a long string And along yeah, and I'll go ahead and modify that so In addition to treating Numbers and strings as fundamentally different you also edit them differently So if you want to edit a number you go to that and just press E and you'll be able to change that to whatever other Excuse me, you'll be able to change that to whatever else. So let's say some number But if you want to edit text you have to use capital E and that's just because they're different now when I'm in this I'm in basically edit mode Which is as you may be able to guess it's a VIM like mode. So if you look at my cursor up here if I press B It's gonna use VIM Hotkeys so B means back a word W means forward a word. So I use, you know H&L to move around. So you really have like VIM bindings here Well, so we'll replace this CW change word to this R something like that And so that's how you even the editing mode is VIM based which is really nice to have So anyway, so this program this is basic manipulation, but of course there's there's more than that as well You also have commands that you can sort of string together So DD itself is like delete delete whatever you have highlighted So I've deleted this text now if I move to some other place just like in VIM you can use P to paste it in or YY is Yank and you can you know paste it wherever you want In addition to that you can also if I use V You have a visual mode in this just like in VIM so I can highlight a bunch of stuff yank it up Put it wherever I want stuff like that. It's absolutely fantastic or let's say I made a huge mess So I'm gonna get rid of all this I can just highlight it all and press either X or DD and it's gonna delete it You also columns and rows are sort of objects in skim So if I if I'm on row e or column e and I want to get rid of it I can literally just say D for delete C for column and it's gone And I'll delete this one as well because it has stuff in it So you can literally just do stuff like that or as well you can yank Columns and say I want to yank this row so Y and then R to yank the row and then I can go and paste it in a million times there's also a difference so P is the normal paste you also have T Which will put it's sort of like in VIM the difference between P and capital P in terms of If it creates a new row below or where you actually are And of course like VIM you also have you for undo control or for redo stuff like that so Pretty much all the basic stuff. I'm trying to think what else. Oh, and if you do have Like VIM you also have numbers that you can repeat commands with so let's say we're up here Well, I can do nine and then K to go up nine cells if I'm on this one and I press I'm gonna have to remember. I think it's a little different from them But if I do nine delete row, yeah, so that deletes all nine rows downward I don't know if you can specify direction like if you can say delete upwards there might be a way of doing that I just don't know it off the top of my head So I'm trying to think so. Oh, yeah, and of course it's expressions. That's another huge thing. So let's Just like in Excel, let's say we have a bunch of numbers Let's say we want to calculate the average of those It works pretty much just like it would work in Excel the syntax is sometimes a little different So let's say if you want to find some kind of if you're not run some kind of function or expression On numbers you can just go to a cell and say equals And then let's say I want to use the I want to average numbers up So I'm going to do the at sign and then a VG I think is how they do average and then you put what you want averaged in parentheses, so we'll do B1 all the way to B4 because we want the GPA average And I think that might have to be capitalized, but whatever So just run that and now this is the GPA average And of course you can if you know I can modify this I can say let's say Terence has a GPO GPA of zero as you would expect that does change the expression So these they're not like static, of course, so it's what you you'd expect I will say one thing If anyone's used this program before there's one thing I don't know how to do which I think you probably Can do so if you are an Excel user You're familiar with the fact that like if you have an expression in this column You can basically just tell Excel to move it over here and apply it to the things in this column instead So hypothetically if I copy this here and paste it there I'd want the average of this stuff rather than this stuff But there doesn't seem right off the bat a way to do that and skim. I'm a little I don't know if I'm disappointed. There's just so much that I don't know about it yet But that's one little thing. So if anyone knows about that tell me I sort of feel like there will be something In addition to having these functions you can run on so you have average you can have Max Men I think men different kind of you know these functions that you can run on numbers But you also have things that you can run on text. So for example No, it's come I don't do this much so it always confuse me if you insert backslash and then I think an Open quotation mark, you're not going to close this but this means an expression to be run on the string So there are some like at sign Upper and then that's going to take I'll feed it just some text And that will automatically put that in uppercase and I think I Think there's a way See how I Think there is a way to say like a particular Cell so if I do a for Okay, maybe not there's probably a different way to do that you might put There might be some other parentheses or something, but I know there is a way to have like Something running on another cell or something like that Oh, and I should say as you would sort of expect in addition to having like, you know number modifications So five to the right five to the left stuff like that. You can also do something like Go and then be to and that'll take me directly to be to so That's another thing another Vim like thing that is in here But anyway, so this is basically skim. This is sort of an introduction It was a little rambly because there's so much about this But I definitely encourage you to look into it. I'm having a lot of fun sort of figuring it out Oh, and of course, how do you save? How do you save files and skim? Well colon w as you would expect and if you know just like in Vim you can name it as something else or CS you know something else But yeah, that's basically it. So I definitely encourage you to check this thing out because it is pretty cool and There's not I again I don't know how to do everything in this thing But I definitely plan on moving toward it if I can in the future as a total replacement for Excel Because that's really the only thing in like an office suite that I would actually use and I'd prefer not to I'd like to be able to Rely on some kind of Vimish terminal program just to have all the workflow in sync So anyway, I hope you enjoyed it. I hope you learned something and you know throw your comments if you have any So I'll see you guys next time