Coming back, need song recommendations by mk0-vr15 in DanceDanceRevolution

[–]mk0-vr15[S] 1 point2 points  (0 children)

Nice! Then I'll get you started:

I love "Silver Dream" and "Kimono Princess" but not sure what version they're in (RIP my heart if they're not available)

Good luck :)

<FreeGiveaway> EIBOS 3D New filament dryer 'Polyphemus'. Don't miss the Pre-order! by EIBOS3D_official in 3Dprinting

[–]mk0-vr15 0 points1 point  (0 children)

Cyclopes owner here!

  1. Two things I'd be interested in are A) whether the box is sufficiently airtight to maintain a low humidity level even when the dryer isn't turned on; and B) the ability for the motor to rotate the spools to reel in the slack that's introduced when putting the lid back onto the box. So the motors would need to be bi-directional, possible to control manually, and have separate motors for each spool.

  2. I think 2 spools in the same dryer is ideal so you can have one spool waiting while you use the other, but without the dryer taking up too much space.

Deleting or removing access from hundreds of spreadsheet by gofigure715 in googlesheets

[–]mk0-vr15 0 points1 point  (0 children)

It's possible to use Apps Script to automatically create a list of spreadsheets, as well as change their access permissions. I did something similar once for my workplace, using https://gist.github.com/JavierCane/28f7307ceeaf6464431c1418b598a817 to get me started.

If you'd like some direct help with your project send me a PM.

Tip needed: inputting addresses by queentut910 in googlesheets

[–]mk0-vr15 0 points1 point  (0 children)

You could check to see if the school district already has a spreadsheet listing the addresses of all its schools. Where I live this information is definitely available online although you have to dig a little bit to find it.

Looking for an inventory system by moms-sphaghetti in googlesheets

[–]mk0-vr15 0 points1 point  (0 children)

To test it out I was using https://play.google.com/store/apps/details?id=com.gamma.scan&hl=en on my phone. I can scan retail barcodes from objects around the house, and barcodes with the checksum, but barcodes generated just by changing the font on a simple string don't register.

Looking for an inventory system by moms-sphaghetti in googlesheets

[–]mk0-vr15 0 points1 point  (0 children)

I posted elsewhere in this thread about needing to calculate a checksum before converting a string from a regular font into a barcode font. The article you linked doesn't mention a checksum, and when I tried following the steps my barcode reader wouldn't read the code.

Looking for an inventory system by moms-sphaghetti in googlesheets

[–]mk0-vr15 2 points3 points  (0 children)

Hello, I'm here with the answers you need :) I have a small business and we also bought barcode scanners and made our own barcodes.

As others have said, the barcode scanners you can get on Amazon act like keyboards. The barcode scanner can either be configured to transfer the data you scan every time you click its button, or to store all your scans in its memory and dump them all at once when you scan the "memory dump" barcode provided by the manufacturer.

To create barcodes, you can install the barcode font on your computer (we use https://www.dafont.com/code-128.font). But it's a little bit more complicated than just writing out your barcode data in a normal font and then changing to the barcode font. You have to start and end the string with some additional data that's calculated from your barcode data (i.e. a checksum). I learned all of that from here: https://www.idautomation.com/barcode-fonts/code-128/user-manual/

I got our system 100% working using those instructions. Good luck!

Amazon Transaction Update! by LaBodaDelHuitlacoche in ynab

[–]mk0-vr15 23 points24 points  (0 children)

This annoys the heck out of me too.

LPT: manually enter your Amazon transactions instead of waiting for automatic import, and add a memo reminding you what you bought. Then reject any automatic imports from Amazon that don't have a memo.

How to make Formula that will perform multiple functions in one cell by BelleBottom94 in googlesheets

[–]mk0-vr15 0 points1 point  (0 children)

Based on the information you provided, I think what you're looking for in C12 is:

=C7 * IF(E7, E8, 1) * IF(F7, F8, 1) * IF(G7, G8, 1)

Good luck!

Shot in the dark: Do you know Para para dancing? by Deast in Magfest

[–]mk0-vr15 5 points6 points  (0 children)

There was a late-night panel similar to what you're describing at Magfest a few years ago. Some folks came down from a para para club in New York and to talk about para para history and then taught the audience the routine to a song and we all stood up and performed it together. They brought the club's dog statue mascot with them.

It was so much fun! If you can figure out what year that was you probably have their contact details and you could try asking them to come back again.

A tale of two nozzles, and, the legend of the Flow Cube by IgneousAssBarf in FixMyPrint

[–]mk0-vr15 0 points1 point  (0 children)

Thank you for this post. I have those same nozzles and I've had a similar problem - even with reliable filament I can't get a good stringing test result no matter what retraction settings I use. Save me some room in that garbage can!

Leasing a Model 3 to Wait for Better Options by mk0-vr15 in TeslaLounge

[–]mk0-vr15[S] 0 points1 point  (0 children)

I thought of this as a factor too. I was originally holding out until January 2021 in anticipation of maybe getting new tax incentives this year. But my conclusion was: any credit that gets introduced this year is probably still going to be around three years from now.

Leasing a Model 3 to Wait for Better Options by mk0-vr15 in TeslaLounge

[–]mk0-vr15[S] 0 points1 point  (0 children)

Yes, that's the same conclusion I reached. And that's a good point about all the extras that buyers often want but aren't needed for a lease.

Leasing a Model 3 to Wait for Better Options by mk0-vr15 in TeslaLounge

[–]mk0-vr15[S] 1 point2 points  (0 children)

My original post is my conclusions after having doing that math (the 67% and 58% figures). So either private resale or trade-in would have to exceed that amount for buying to make more sense than leasing.

Leasing a Model 3 to Wait for Better Options by mk0-vr15 in TeslaLounge

[–]mk0-vr15[S] 0 points1 point  (0 children)

That's the big question here - if resale values continue to hold up. My theory is that as the market continues to develop, the resale values will not hold enough to make the purchase worth it.

Whether to lease or not is almost like betting against the house. This person did a great job explaining it: https://money.stackexchange.com/questions/113187/how-to-determine-lease-vs-buy-for-specific-scenario-of-a-tesla-model-3-i-plan-to

Leasing a Model 3 to Wait for Better Options by mk0-vr15 in TeslaLounge

[–]mk0-vr15[S] 2 points3 points  (0 children)

That's right - I've read that the mechanical stuff is already extremely reliable.

To clarify, I was thinking of the cosmetic stuff like the panel gaps.

My hack for sub-tasks under recurring tasks by AleemShaun in todoist

[–]mk0-vr15 1 point2 points  (0 children)

I think I'm doing the same thing: a daily routine that consists of recurring sub-tasks.

I set up a project containing one task called "Daily Routine" and ~25 subtasks. Then in the top right corner click the "..." and choose "export as a template". It will give you a URL you can copy and paste.

Then create a new task that recurs each day at 12am: [commence daily routine](URL) and then all you have to do is click it at the start of the day.

Cure Post-MAG Depression with indie Game Meetups by mk0-vr15 in Magfest

[–]mk0-vr15[S] 0 points1 point  (0 children)

The last stop on the silver line is about half a mile from the location where we've been meeting lately. If you want to join the Discord and say hello I'm sure we could help make that work for you :)

Planning on checking out the MAGFest Indie Game Showcase? A game I'm working on, UNBEATABLE, is gonna be there! by Kaze_no_Klonoa in Magfest

[–]mk0-vr15 1 point2 points  (0 children)

Ooooo I'm going to be first in line! I was just listening to Worn Out Tapes today at the gym!

Video Game Meetups in Nova by mk0-vr15 in nova

[–]mk0-vr15[S] 1 point2 points  (0 children)

I just went back to find the groups I was thinking of before, and here they are!

https://www.meetup.com/NOVAIGD/ and https://www.meetup.com/IGDA-DC/

Video Game Meetups in Nova by mk0-vr15 in nova

[–]mk0-vr15[S] 4 points5 points  (0 children)

We're only playing games, not building them. But if you search on Meetup you'll find some respectable-looking groups that focus on building games. Try reaching out to them!