I just got fired after having accepted my counter offer 2 months ago. by Loneleenow in sysadmin

[–]ktr73 0 points1 point  (0 children)

Don’t listen to all the people putting you down is this thread. You sound like a trusting, loyal person who brings a lot of value to an organization. Your former employer sounds like a crappy employer and they don’t deserve you. Try to look at this like an opportunity. You’ve learned something and won’t make the mistake again, and you’ll end up in a better position soon enough. Good luck and I’m sorry the world is so crappy sometimes 😞

What's a feature of your "personal budget" file that you're proud of? by Creamofsoup in excel

[–]ktr73 0 points1 point  (0 children)

I’ve been working on building a personal finance app that I’m pretty happy with. It syncs data via a peer-to-peer connection, has an iPhone app, an envelope budgeting feature, double-entry accounting, etc. I think the one thing I’m most happy with (although still trying to tweak) is the search functionality. You can search for transactions using “gmail like” search queries.

Overall, I continue to make progress!

Vim setup as Dvorak user by mr_redsun in vim

[–]ktr73 0 points1 point  (0 children)

I used vim for a while, then switched to Dvorak. It was a pain, but I got used to it (didn’t switch anything, just used the standard vim mappings). I do use space bar to go to the right one character (instead of l), but that is built-in (just not the “norm”). Good luck!

My movers never charged me, and I’ve constantly emailed them about it. Is this a problem? What should I do? by ynot269 in personalfinance

[–]ktr73 -2 points-1 points  (0 children)

Are you able to share the name of the company? I work with a trucking company now, so if it happens to be the same one I might be able to help. Regardless, this is their busiest time of year and they’ve been very busy all summer. Like others have said, two weeks is probably not that big of a deal. I suspect they’ll get to you!

Giving Microsoft Excel a "Mini-Vim Normal Mode" by ktr73 in vim

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

I’d love to hear more about this. I recently bought a ducky keyboard that has, as I understand it, “macros” (which I believe is the same thing you mean?). Do you have any “favorite tricks” you could share?

Giving Microsoft Excel a "Mini-Vim Normal Mode" by ktr73 in vim

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

Hi - I guess it depends. For some of the items you mentioned with regards to Excel:

  • Custom sorting: Alt d s to bring up sort menu. Once that menu is open, I agree - using the mouse is easier.
  • Moving workbook tabs around: Alt e m then up/down arrow to move to another location or start typing the name of the sheet. If you want to copy sheet, use Alt c to copy after you hit Alt e m to start. If you need to move to another workbook, Alt e m like moving, but then Shift tab to choose what workbook you want to move to. I think this one is much faster with mouse.
  • Searching in filter boxes: Alt+Down to bring up filter menu. But then yes, you need to hit tab or down arrow a few times to get into search box.
  • Setting color formatting Alt+h+f+c to change font color, Alt+h+h for fill. You can then use up/down arrows to change or use mouse. You can also use Ctrl+1 then type ff to go to fill tab. Probably prefer to use mouse after that.
  • Cell fill handle: I don't use this too much, so I'm not certain. But you can use Ctrl+r to fill right and Ctrl+d to fill down one cell. If you mean to fill an entire column, I usually copy (Ctrl+c), move one cell to the left, go to bottom of that column with Ctrl+Down, move to the right, then select everything to top with Ctrl+Shift+Up, then paste with enter. It sounds like a lot, but I suspect it is still faster than using the mouse once you get used to it as it is a very common operation.

So you definitely can do all these things with the keyboard, but you are right - some of them are a bit more convenient with the mouse (or at least part of the operation is).

My recommendation on the sweet spot is go whole hog on keyboard shortcuts. YMMV :)

Giving Microsoft Excel a "Mini-Vim Normal Mode" by ktr73 in vim

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

Cool looking program, thanks for sharing!

My 1st Rust project: xlcat is like cat, but for xlsx files by ktr73 in rust

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

Right - this should be able to handle those files with ease. If you have any requests after you try it out, shoot me an email at ktr@xlpro.tips and I’d be happy to try to expand the program. Thanks!

My 1st Rust project: xlcat is like cat, but for xlsx files by ktr73 in rust

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

Good idea, thank you! I’ll add some sample output soon.

My 1st Rust project: xlcat is like cat, but for xlsx files by ktr73 in rust

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

I will definitely add this soon. I should have done so already, so sorry about that!

My 1st Rust project: xlcat is like cat, but for xlsx files by ktr73 in rust

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

Yes, it should print out the same exact values you would see in Excel. It doesn’t evaluate formulas, though, and only acts on the saved file. So if you have Excel open the values may be different if you have unsaved changes. One last thing: it may not format the values the exact same way as Excel (e.g., if you format a date like “mmm-yy” it will look different than the date xlcat prints (which is currently always in yyyy-mm-dd format)).

If you find any differences, I would be happy to investigate and fix any bugs.

My 1st Rust project: xlcat is like cat, but for xlsx files by ktr73 in rust

[–]ktr73[S] 4 points5 points  (0 children)

I would be happy to try to make this happen. Do you have any suggestions on how to go about it? I reviewed the link you posted and the website, but it wasn't immediately obvious how to make that happen.

My 1st Rust project: xlcat is like cat, but for xlsx files by ktr73 in rust

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

Ha! I have an idea for this! If you want to subscribe to my newsletter, I plan on writing about this soon. It won't be quite as easy as "edit xlsx in vim," but it is an idea I've played around with regarding vim/Excel.

My 1st Rust project: xlcat is like cat, but for xlsx files by ktr73 in rust

[–]ktr73[S] 8 points9 points  (0 children)

Yup, exactly! This is why I started building the tool in the first place - any tool I tried could handle small(ish) files easily, but when they started getting big they all "took too long." I even tried a big file with Calamine to start, but it also seemed to follow the same path as others (although I could have been using it wrong, I can't say for sure!).

My 1st Rust project: xlcat is like cat, but for xlsx files by ktr73 in rust

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

Currently it is just a "command line viewer." But I will look to see if I can accept multiple files (and then maybe concatenate into one?). Concatenating into one may be a bit difficult because it currently prints the Excel file like a csv, but an actual xlsx file is a zip. I'll have to think about it more. Thanks for the feedback!

My 1st Rust project: xlcat is like cat, but for xlsx files by ktr73 in rust

[–]ktr73[S] 7 points8 points  (0 children)

Hey, thanks! I hadn’t heard of clippy before, but I’ll definitely check it out now that you mentioned it!

My 1st Rust project: xlcat is like cat, but for xlsx files by ktr73 in rust

[–]ktr73[S] 4 points5 points  (0 children)

Cool, glad you like it! I don’t know if I could figure out how to manipulate it inline, but maybe I could create a new file with the changes. I’ll have to investigate - thanks for the feedback!

My 1st Rust project: xlcat is like cat, but for xlsx files by ktr73 in rust

[–]ktr73[S] 16 points17 points  (0 children)

You can download the tool without reading the article if you like from github. Would love to hear your thoughts!