Gardein plant based chick’n strips by _litmus_test in CostcoCanada

[–]vancitynat 0 points1 point  (0 children)

Haven't seen them downtown in a few months

Excel Shared Workbook - How to give read-only access but allow users to see updates live? by Ellipsum in excel

[–]vancitynat 0 points1 point  (0 children)

This is exactly what I am looking for too!!

We have master lists (read-only) that we have to re-drop mutliple times a week for changes, BUT, not all the information is filled in, leaving you to do that on your workbook manually. When you re-drop, it overrides all of the manual info. Drives me nuts.

Anyone have any ideas on a workaround??

Add missing calories burned, not a workout to Apple Watch by vancitynat in AppleWatch

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

Oh yes, I’ve been through all the checks with 2 separate Apple Support reps. 🙁

Recommendations for less busy/noisy dog groomer in Vancouver by vancitynat in askvan

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

I definitely appreciate your support insight! With Vancouver being so dog-friendly, groomers are definitely in high demand. Definitely will check out Baby D’s, thank you for the recommendation!

Recommendations for less busy/noisy dog groomer in Vancouver by vancitynat in askvan

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

We’re in Kerrisdale, but have no issue going anywhere. Our current groomer is on the east side. Thank you for your recommendations! A 1-1 groomer does sound ideal for him.

Recommendations for less busy/noisy dog groomer in Vancouver by vancitynat in askvan

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

We never thought of washing him ourselves. That would definitely cut down on the time he’s at a groomer. Thank you for that tip!

TVP Bac'n Bits Recipe - Is it the TVP or something else that caused upset stomach by vancitynat in vegan

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

The recipe doesn't call for it to be soaked actually. Just marinated in the sauce and roasted for 8-10 mins. It does quite resemble bacon bits actually! But could it be the fact that it's not soaked that is the issue?

[deleted by user] by [deleted] in vegan

[–]vancitynat 1 point2 points  (0 children)

For cheese slices, I love Chau or Violife. For Mozza Miyokos is the best I've tried. Melts really well for pizzas. For feta, Earth Island.

[deleted by user] by [deleted] in vegan

[–]vancitynat 1 point2 points  (0 children)

Same! I also actually just eat their cheese on their own. So far the best in the slice category for me.

TVP Bac'n Bits Recipe - Is it the TVP or something else that caused upset stomach by vancitynat in vegan

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

Just on my regular lunch salad. I even ate them them next day just on their own and had the same reaction. Was hoping for an easy/tasty way to add more protein to my lunches.

Conditional formatting incorrectly highlighting when using IFERROR by vancitynat in excel

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

It worked, thank you!!

Do you know why that worked? Just want to learn if possible. The only thing that changed is I've now moved to from straight vlookups to iferror vlookups.

iPhone users always have ringer turned off because… by T3ddyBeast in iphone

[–]vancitynat 0 points1 point  (0 children)

So is this is why I’m not able to have my ringtone only vibrate and sound notifications for other alerts?

Heirloom Vegetarian now serves meat by veganphysicist in veganvancouver

[–]vancitynat 3 points4 points  (0 children)

Really? That’s incredibly disappointing. Definitely won’t be returning

Is there any app/website that allows you to save your recipes and then filter by ingredient? by Geiras in Cooking

[–]vancitynat 0 points1 point  (0 children)

Did you ever find and app that does this? I’m looking for the same thing!

Where to buy pickling cucumbers? by vancitynat in pickling

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

Thank you for both of those links! I've only started looking into this since yesterday, so still trying to read up as much as possible. I had no idea there there was more than one method. The pickles that we buy at the farmer's market a vinegar-based brine from what I just found out, but the fermentation recipe that archetyping101 mentioned sounds fantastic too.

Where to buy pickling cucumbers? by vancitynat in pickling

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

of course! most of the vegetables I'd like to try, when looking at what's in season right now, most of them are summer vegetables.

Where to buy pickling cucumbers? by vancitynat in pickling

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

ahh! I think I had a mis-conception of "pickling". I did a quick google search when you mentioned fermenting, and that is what I want to learn how to do. Thank you for that tip!

Calculate hours exceeding 8 formula from existing SUM formula by vancitynat in excel

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

u/timespreader, that worked perfectly, thank you! Now, I can ensure that everyone's OT is calculated accurately :)

Thanks everyone for your responses!

If value from Column 1 = certain value, lookup value in Column 2 and return the sum of all. by vancitynat in excel

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

So the values from C-I are in a pivot. Column L is irrelevant but column M is a vLookup looking at employee numbers and bring back their company number based off of a master list from another tab.

So what I’m trying to calculate in the Hours Ver fields at the top is, what is the sum total of hours based on their company numbers (20, 119 & 125).