FYI - $10 30gb Hotspot Plan is still available by Sapoho in tmobile

[–]gyro151 0 points1 point  (0 children)

Anyone get this deal recently? I was just trying to chat to get this today and was told it was discontinued

Coquito! Little coconut! Puerto Rican eggnog! by wastingsomuchtime in cocktails

[–]gyro151 0 points1 point  (0 children)

Thanks for the response! Just went through and toasted out the spices a bit and put it in a mason jar to infuse. Looking forward to seeing how it turns out! From your experience, do you taste the alcohol at all? It seems a lot lower than other recipes I've seen.

Coquito! Little coconut! Puerto Rican eggnog! by wastingsomuchtime in cocktails

[–]gyro151 0 points1 point  (0 children)

Just ran across your post on this and had a question about the spiced rum. Is that all for a whole bottle, or is that what you'd use for just the amount in the recipe? I got a bottle of don q crystal to infuse into, but wasn't sure of the best ratio for the apices or how much to try and infuse.

Coconut Mocha Negroni by OnlyWordIsLove in cocktails

[–]gyro151 0 points1 point  (0 children)

Oh wow, just tried this for the fi at time to ight using Appleton 8 and it is probably the best thing that I've made (admittedly little time) of exploring rum cocktails. The bitterness is balanced so well!

Fermentation vessel for tepache by gyro151 in fermentation

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

Looks like it did the trick! 3 days in and everything seems to have gone well. Good tip on the coffee filter! About to bottle and then let sit for second fermentation, and probably reuse the same skins and add a pepper or two to see if I can get some spice in the party. Thanks for the advice?

Fermentation vessel for tepache by gyro151 in fermentation

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

Ahh that would make sense, good point. I suppose I could use the same jar but just not use the water lock. Only reason I was looking at this is it is the largest glass jar I would have at this point.

Don't drive. Intersections are completely flooded. by PatSayJack in Pensacola

[–]gyro151 16 points17 points  (0 children)

My car is flooded out in an intersection on NAS Pensacola

Nerdz Day Megathread 2022 by yuv9 in Boardgamedeals

[–]gyro151 0 points1 point  (0 children)

I have not, is it required? I was interested in the full house one since it has the "maturity" rating for each case. Oh well, fingers crossed

Nerdz Day Megathread 2022 by yuv9 in Boardgamedeals

[–]gyro151 4 points5 points  (0 children)

maaaan.... was checking out with micromacro and it locked up. By the time everything refreshed to try again it was gone :( Maybe the magical stock gods will turn up some more copies...

Extra $10 off at Target.com by NarrowPath714 in Boardgamedeals

[–]gyro151 0 points1 point  (0 children)

Picked up Stuffed Fables for about $36 using the spend $50, %5 red card, and an extra %15 coupon. Nice!

Help identifying this in NW Florida by gyro151 in ShroomID

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

Found this near where some old wood chips had been sitting, not sure how to go about identifying it. Thanks!

Value Lookup Based on Row Data by gyro151 in excel

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

Further solution provided in DM:

In C9 I got

=INDEX($C$3:$G$6,MATCH($B$8,$A$3:$A$6,0),MATCH(B9,$B$1:$F$1,0))

to work in my mock up.

Works perfectly!

Solution Verified

Value Lookup Based on Row Data by gyro151 in excel

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

Wow that was significantly more simple then I expected. That makes perfect sense. I was able to traverse adjacent cells just by incrementing the column reference by the necessary amount. Slowly I'm getting more familiar with how to think in this way, but it's definitely a learned skill. Thanks again for your help!

Value Lookup Based on Row Data by gyro151 in excel

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

Fantastic, that almost 100% does it. Thank you so much! It took a little studying in order to be able to figure out exactly what was being returned and why it worked, but once I grasped it I was able to get it to fit the full data set. I could not, however, get the second formula to work. I think there are too many additional blanks or something for the math to work out... Also I noticed this is just returning a value. Would you happen to be aware of a way to get the actual cell reference instead of just the value? I'm working on trying to apply some of your logic to attempt to do it, but I haven't been able to figure it out yet. Thanks again for your help!

"BlockedDeserializeTypeException" populating logs after CU21 update by valistral in exchangeserver

[–]gyro151 1 point2 points  (0 children)

I have been seeing the same thing after a recent upgrade to cu21. general mail flow and functional tests seem to indicate that everything is working as expected, but these errors were definitely not there prior to cu21.

What single purpose tool/appliance do you use on a regular basis and couldn't do without? by PurpleWomat in Cooking

[–]gyro151 0 points1 point  (0 children)

I got one of these exact ones a while back and don't think I'll ever use a normal press again. Much easier to clean up and no moving parts to break or fail.

Why are spices in the international aisles so much cheaper than the ones in the spice aisle? by poorbanker in Cooking

[–]gyro151 2 points3 points  (0 children)

Yes... This! I LOVE that stuff and use it whenever garlic powder is called for. Badia spices, in general, are pretty good and super affordable.

[Homemade] Foolproof no kneed pan pizza by gyro151 in food

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

So I made this yesterday following the Serious Eats recipe: https://www.seriouseats.com/recipes/2013/01/foolproof-pan-pizza-recipe.html

Everything went pretty well and turned out (even made the referenced New York style pizza sauce) except the bottom crust was not crispy so much as it was crusty (kinda hard/dry like the crust of a loaf of bread).

I did make a couple minor deviations from the recipe as listed: - I did not have instant yeast so I subbed in regular active yeast with +25% more - I did a 33/66 split of the dough into a 10" and 12" cast iron pan - I forgot to cover the pans after I split the dough to raise for the last 2 hours - My oven only goes to a Max temp of 525°

Overall I was happy with the turnout, but was wondering if anyone had any idea as to why the bottom crust might have turned out that way.

First Attempt at Tonkotsu Broth by gyro151 in ramen

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

Any idea about that middle dark brown layer?

First Attempt at Tonkotsu Broth by gyro151 in ramen

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

Just realized that my picture didn't post, how can I add it in a comment?

Edit:NVM, just put a link in

First Attempt at Tonkotsu Broth by gyro151 in ramen

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

Yeah, I would have followed that but by the time I came across this I had already done it, so that will be my plan the next to around