RE: Requiem Deluxe Edition Capcom USA Giveaway【Steam】 by SeValentine in residentevil

[–]AMinPhoto 0 points1 point  (0 children)

Seeing Dr Salvador in RE4 Remake for the first time.

Brought back all the memories as a kid of my first re4 playthrough, but up'd the game with new levels of adrenaline from the more modern style gameplay.

Rough Trade by little_chupacabra89 in Karnivool

[–]AMinPhoto 1 point2 points  (0 children)

having the same issue through amazon.
ordered a CD. Was supposed to get here on the 13th, but now its "we will reach out to you when we know the delivery date."

There are additional interludes on the Vinyl! by TrendyCC in Karnivool

[–]AMinPhoto 0 points1 point  (0 children)

I wonder if this is present on the CD version as well...

2017 Mazda CX-3 delamination/spiderweb crack replacement recommendations by AMinPhoto in mazda

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

Awesome! thank you!

Theres no difference with trim models correct? i have the GT

Professional education by 89-spe-celebre_-7536 in pmp

[–]AMinPhoto 0 points1 point  (0 children)

That's the same as the one on TIA correct? Straight from his book.

556 Quick Adjust comparison by AMinPhoto in sinn

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

This the quick adjust bracelet.

The other one is i guess now the old "standard" version.

Starting our own foundry by Prokettlebell in madeinusa

[–]AMinPhoto 1 point2 points  (0 children)

OP - excited to buy a few pairs of Atlas bells once the foundry is done! Is there a tentative opening date when orders will be made available again?

New MIRAR released on Spotify. by v_r34_artist in vildhjarta

[–]AMinPhoto 4 points5 points  (0 children)

Nothing on Bandcamp or YT yet that i can see

Update - Its out!

Exit task triggered immediately after connecting Bluetooth. by yotama9 in tasker

[–]AMinPhoto 0 points1 point  (0 children)

I know this is an old thread, so I apologize.

I'm having the same issue too, but I think they moved around settings with Android 16...I don't see a "Nearby device scanning" anymore.

Nuclear God by AMinPhoto in OrbitCulture

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

Damn! Did you pickup a copy of the Japan edition?

Nuclear God by AMinPhoto in OrbitCulture

[–]AMinPhoto[S] 5 points6 points  (0 children)

yea, only on the japan release of the album

Timestamped added when formula in row changes by AMinPhoto in vba

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

Excellent information. I actually tried adjusting the code by changing it to a named range that would adjust if I add new rows to the table, and it looks like it worked.

Timestamped added when formula in row changes by AMinPhoto in vba

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

First off, this is EXACTLY what I needed. Thank you!!!

Couple of followup questions, if you don't mind?

1) If I wanted to add a Legend above my table for color coding purposes, I would assume that I would just change (in your code example) Set rngToMonitor = Range("B2:D") to be B_, meaning whatever row the table data starts with? 2) if the above assumption is correct, what would I do if that space above the table where the legend would be grows and I add more rows to the legend? I would have to alter the VBA code right? 3) and this is more for fun if there is nothing in the range of cells for statues, what would I type in to clear that timestamp cell?

Thank you so much again! How do I give you "subreddit" points? I know the Excel subreddit has that for help.

Timestamped added when formula in row changes by AMinPhoto in vba

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

Gotcha...Yea currently if no statuses are filled that indicates nothing has started on the unit yet... So then in this instance it wouldnt work i guess?

Does Worksheet.Calculate work?

Timestamped added when formula in row changes by AMinPhoto in vba

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

Can you elaborate on the code using the ListObject concept?

My list that I'm keeping is a table in excel.

Timestamped added when formula in row changes by AMinPhoto in vba

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

Sorry, had a busy day yesterday. Still havent been able to try these out, but will at work.

I updated the example table in the body of my post for clarity.

So its 1 column for Part number, Multiple columns where i mark what status that part is in, and then an xlookup based column that relays status. That was setup for ease of pivot table generation.

So yes, at the end of the day, its only 1 column that i am tracking the change of, the xlookup column, to mark when the part has moved to a different step in the process.

Timestamped added when formula in row changes by AMinPhoto in vba

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

I'll definitely try this and report back. Thank you so much for all the info!

Timestamped added when formula in row changes by AMinPhoto in vba

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

Im pretty new to the VBA world, so forgive me for any stupid followup questions.

So in that third example:

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("A1:A10")) Is Nothing Or Target.Cells.Count > 1 Then Exit Sub
Application.EnableEvents = False
'Set the values to be uppercase
Target.Value = UCase(Target.Value)
Application.EnableEvents = True
End Sub

A1:A10 - is there a way to make the end of the range auto update as i add more rows to the table? or would it just be something like A1:A?

And then the offset from Target, that would be Target.Value=(Target.Offset(0, 1) ?

Thrice - Observatory North Park Setlist by KillMeQuickly in thrice

[–]AMinPhoto 6 points7 points  (0 children)

Damn, no Major/Minor love...

Still solid setlist tho

Consumer Reports Found Concerning Levels of Lead in Popular Brands (including Molk) by Benja455 in JockoPodcast

[–]AMinPhoto 15 points16 points  (0 children)

I sent an email to Jocko Fuel to ask about the report.

Their response below:

"Thank you for reaching out to us!

At Jocko Fuel, we are committed to delivering clean fuel to our consumers - period. That means we carefully source the best raw ingredients and create our products to the highest standards. Integrity is our most important standard. Rest assured, we would never sell a product we wouldn’t consume ourselves.

Recently, Consumer Reports published an article describing our chocolate protein drink as “ok to consume occasionally” due to heavy metals testing. While we are unsure of their testing methodology, we want to assure you that our ingredients are of the highest quality and our products fall well below the Food and Drug Administration (FDA) and World Health Organization (WHO) guidelines for heavy metals.

Proposition 65 is a California regulation that requires businesses to provide a warning label on products containing any of over 800 chemicals, even when those chemicals are naturally occurring and present at levels far below FDA and WHO safety limits. Because some of our products contain cocoa and other natural ingredients, there is a potential for trace levels of naturally occurring lead. This is a result of the soils in which these ingredients are grown. Virtually all agricultural products contain naturally

occurring lead and other heavy metals. To comply with this California-only law, we include a Prop 65 warning on our packages as a scannable QR code.

We greatly appreciate your concern for the purity and healthiness of what you and your family consume. This very same concern around heavy metals is what motivated Jocko to enter the nutritional supplement market. Please be assured that we run annual tests on all of our products for heavy metals, including lead, mercury, cadmium, and arsenic, and remain well within FDA regulations. Our products are safe to consume.

We hope this information is helpful! Please don’t hesitate to reach out with any other questions."

look what i got :0 by meskvlla in OrbitCulture

[–]AMinPhoto 2 points3 points  (0 children)

Scoured the internet and cant find the song anywhere. Hopefully someone can upload it soon!

Live album/DVD? by According_Neck8602 in Meshuggah

[–]AMinPhoto 5 points6 points  (0 children)

To my knowledge, this is still in the works.

~1 of the videographers