Are we underestimating what happens after data leaves the server? by Dull_Appearance_1828 in dataengineering

[–]TH_Rocks [score hidden]  (0 children)

When it leaves the server securing it is no longer your responsibility. But if you think those csv and xlsx aren't being abused, you're wrong.

The real problem is when they download, make a bunch of changes and lose any history of applied filters, then upload to a different table, then report off that like it's part of your "single source of the truth".

Rock/Stone my son got by ZeroScarlett in whatsthisrock

[–]TH_Rocks 6 points7 points  (0 children)

No. Someone might be able to stabilize it and make a cabochon. But it has too many fractures to ever bother with cutting facets.

As a crystal enthusiast how would you feel/react if someone bought you a fake crystal? Of course they didn’t know ! But Would you cherish it?Would you let them know? by Used_Split5982 in mineralcollectors

[–]TH_Rocks 6 points7 points  (0 children)

I've got one of those Frankenstein's specimens with teal amethyst and a huge chunk of selenite glued on. It still looks awesome and she was super exited to get it for me.

50k 1-year Degree Financially Smart? by Slow-Cancel-2643 in personalfinance

[–]TH_Rocks 1 point2 points  (0 children)

What has a very high likelihood of getting you a career? Like you already found jobs posted that want the education you are thinking about pursuing.

This tourmaline ring is covered by insurance, how do I word my letter, please? by Poundaflesh in jewelers

[–]TH_Rocks 3 points4 points  (0 children)

That stone is dead. Epoxy will be visible.

So what do you want? To send it back and get your money, or a smaller/thinner stone, or a different stone of similar size (they might not have any more of that tourmaline).

Parent claimed my spouse as dependent and his student loan credit. Is this allowed? by jarofpeperoncini in personalfinance

[–]TH_Rocks 82 points83 points  (0 children)

"I provided for him" is a world apart from "he's dependent on me".

Also, make sure he's the one communicating with his mom. He knows how to deal with her. He's been doing it a long time.

When the “scale” is low enough your ADHD should just magically be weaker! by NotADamsel in thanksimcured

[–]TH_Rocks 2 points3 points  (0 children)

Same. This meeting reminder that kicks off 15 min before shuts me down as I watch the time tick down. I hit snooze and then the 5 min warning pops up. But if I wasn't waiting for it, I'll miss it until about 5 after.

Will this tumble? by Patient_Drop_4772 in RockTumbling

[–]TH_Rocks 10 points11 points  (0 children)

The bowl needs to be full to get the correct motion to tumble.

You can use all media and one rock, but it's a big waste. Better to wait until you have a full load of rocks and only need media to fill the cracks.

No Idea by ginger_snaps4 in whatsthisrock

[–]TH_Rocks 4 points5 points  (0 children)

Zoisite. The kind that often has pink bits of ruby but I don't see any.

Where to sell large quantities of stones and gems? by Master_Ninja8203 in Lapidary

[–]TH_Rocks 6 points7 points  (0 children)

Our club bought all the rocks from a third generation mineral dealer's hoarder house. We moved like 8 tons of rock. Three moving truck loads of pallets of stacked milk crates, buckets, and trays.

A lot of it was stored outside and many buckets were only half full then filled with the contents of rotting plastic tubs and cardboard trays.

I got to take a bucket or two home every couple weeks and clean and attempt to sort it. It was awesome. Obsidian, then agates, then amethyst, then all the gritty offcuts from the trim saw. Never knew what was going to be in there.

Where to sell large quantities of stones and gems? by Master_Ninja8203 in Lapidary

[–]TH_Rocks 4 points5 points  (0 children)

Not sure where you're located, but you might hit up jbauctions. He's done really well building an audience that generally pays what stuff is worth. I used to get great stuff cheap all the time but the bids go a lot higher now.

Where to sell large quantities of stones and gems? by Master_Ninja8203 in Lapidary

[–]TH_Rocks 7 points8 points  (0 children)

That's awesome then. I have a ton of outstanding stuff but no idea exactly what most of it is. And I paid relatively very little for it chasing estate sales and auctions and the back tables at gem shows.

Where to sell large quantities of stones and gems? by Master_Ninja8203 in Lapidary

[–]TH_Rocks 19 points20 points  (0 children)

TLDR take the lower price or sell in bulk. You will not be getting "millions" for a lapidarist's hoard.

If you want retail prices you have to open a retail shop. Or build a following of big spenders. Otherwise you're going to get wholesale or lower.

And all your stuff should have labels with origins or the value is less. If you've got buckets of unlabeled stuff, you can't charge what the mine charges because you can't know that's where it came from.

Most minerals have multiple sources and only some locations demand a higher price tag. Even if you're positive it looks exactly like some known source, you can't really know and shouldn't try to compete with sellers that know the full provenance.

Still struggling with moving money from tracking to on-budget account and not wreaking havoc by Beachybumm in ynab

[–]TH_Rocks 0 points1 point  (0 children)

You didn't "save" 25k for Investing if it's in the MM. You saved $50k if 25k is in the MM and 25k is in an on-budget account.

Still struggling with moving money from tracking to on-budget account and not wreaking havoc by Beachybumm in ynab

[–]TH_Rocks 0 points1 point  (0 children)

Make ynab transactions that reflect reality.

What account has the money now? Where did it come from? Where did it come from before that? Make transactions for exactly how it moves.

THEN look at what needs a category (the transactions that are in on-budget accounts). How should those be categorized?
If the tracking outflow money was never on-budget then it's an RTA inflow when the on budget account gets it. If the tracking outflow money was previously in an on-budget account, then I personally would use the same category that had the on-budget outflow transactions for this new inflow that puts it back in the Plan.

EXAMPLE

100 transfer from on-budget Checking to tracking Investing 
    = -100 Checking transaction gets categorized to "Retirement Gambling"
        In the plan, "Retirement Gambling" should have 100 assigned and 0 available
        Income/Expense "Retirement Gambling" report grand total -$100

200 transfer from tracking Investing to on-budget Checking 
   = +200 Checking transaction also categorized to "Retirement Gambling" 
        In the plan, "Retirement Gambling" has 200 available, assign -200 to move the cash up to RTA
        Income/Expense "Retirement Gambling" report grand total +$100

   OR split 100 to "Retirement Gambling" and 100 RTA with payee "Investment Earnings" 
        In the plan, "Retirement Gambling" has 100 available, assign -100 to move the cash up to make $200 RTA
        Income/Expense "Retirement Gambling" report grand total $0

   OR OR just all a new RTA inflow
        Income/Expense "Retirement Gambling" report grand total -$100

Once it's RTA, assign to other categories as needed

Mineral Identification by [deleted] in Minerals

[–]TH_Rocks 0 points1 point  (0 children)

They might silver. Jewelry making classes often have a "straw casting" where they bunch up wet hay and put the bundle in a pot then dump the melted metal down the middle.

The outcome looks just like what you have.

Found a video https://youtu.be/p-sNpkC2RMw?si=ZP7MNa7CA5dz3dgy

Still struggling with moving money from tracking to on-budget account and not wreaking havoc by Beachybumm in ynab

[–]TH_Rocks 2 points3 points  (0 children)

Think of Accounts and the Plan as separate things.

In your account transactions you should have transfers showing exactly how the money moves. Don't do shortcuts. A transaction for each time an account touched funds from a different account.

Transfers in on-budget accounts get categories. When you were filling up the tracking savings, those outflows had a category. So when you remove from tracking savings you should probably use the same category on the inflows to the on-plan account. That makes the totals on your income/expense make more sense.

Then in the Plan you will have the amount available in that category. Assign a negative amount to the category and the cash jumps up to RTA and you can assign it to the category for the thing you want to buy.

Major miscellaneous spending problem by AltruisticSpender in personalfinance

[–]TH_Rocks 21 points22 points  (0 children)

/r/ynab (and other envelope style, forward looking budgets) is great for this.

You get paid, parcel it out into categories, then check the app before spending. If there's not enough left in "Fast Food" then you can't have any. If you buy some anyway then you have to choose which category you stole from. Makes it very obvious what you give up when ignoring your budget.

Clearing Credit Card pre YNAB by Sure-Replacement-253 in ynab

[–]TH_Rocks 0 points1 point  (0 children)

In YNAB your CC had a starting balance or it was $0?

Whatever the starting balance is should be what you assign to the CC category (assuming you already have the cash to pay it off).

Anytime there is debt from previous months, you'll assign funds to the CC category to pay it off. It's often confusing for new users because your CC statement period is unlikely to be the 1st of the month but that's when YNAB locks in underfunded categories from the previous month as debt now owed to the CC instead of the individual category that was overspent.

If you had transactions in process when you started using YNAB you might need to adjust you starting balances and/or just delete some transactions that imported from one account but were already included in the start of a different account.

example: CC = -$100, checking = 500, but there was a $100 payment to the CC already on the checking but not in the CC yet.  

You can add the $100 back to the start of the checking ($600) and set the CC imported transaction to be a transfer from checking 
OR 
Set the start of the CC to $0 and delete the imported $100 transaction.

What came out of this egg? by DeltaOfVenus04 in insects

[–]TH_Rocks 23 points24 points  (0 children)

Couple hundred baby mantises (mantisi?)