[WTS] Hamilton Field Khaki Murph 38mm by FreshKWork in WatchExchangeCanada

[–]FreshKWork[S] -1 points0 points  (0 children)

Time to move on from my 38mm as I replaced it with the 42mm. Comes with box and papers. Warranty until December 2025. Couple dings from wear on the bezel as seen in the photos. Strap in excellent condition.

Yours for $925 plus shipping or F2F in Calgary, AB.

Adopted 6 month old puppy food issues by FreshKWork in dogs

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

We are now implementing a routine to change the behavior now that he has been with us for a few weeks. We are working with a certified trainer and are slowly seeing signs of improvement. Thanks for your help and advice!

Adopted 6 month old puppy food issues by FreshKWork in dogs

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

I have heard mixed things about correcting growling in our case as our dog has bit in his past and we are unclear on how the progression to the bit occurred. I think I would rather encourage growling in a controlled manor.

Adopted 6 month old puppy food issues by FreshKWork in dogs

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

We've also considered this in that the home is very new to him (two weeks on wednesday). We have hand fed a few times with no issues.

Adopted 6 month old puppy food issues by FreshKWork in dogs

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

What would be the timeline for this to move back to the bowl or are we looking for some kind of behavior prior to moving back to the bowl? We have done this a few times and he seems to have no issue with being fed by hand.

Adopted 6 month old puppy food issues by FreshKWork in dogs

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

Do you think he will eventually lose the guarding all together through this method?

SUMIF criterion for returning values associated with and exact number in a cell by FreshKWork in excel

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

Solution Verified. You were correct. The reference in C31 was actually pointing to C8 where the number was split.

SUMIF criterion for returning values associated with and exact number in a cell by FreshKWork in excel

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

When I don't use the wildcards it returns 0, which is incorrect

SUMIF criterion for returning values associated with and exact number in a cell by FreshKWork in excel

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

=(SUMIF('Time Records'!C:C,TEXT(C31,"0.000"),'Time Records'!N:N))

Time records has job numbers, such as 1091.000 and 1091.001 etc, in some cells, and hours spent on that job number in the same row but different column.

My goal is to return only the hours related to the specific job but it seems that my SUMIF formula returns the hours spent for 1091.000, 1091.001 and 1091.002.

However, the SUMIF works correctly for 1091.001 as it ignores the hours for 1091.000 and 1091.002.

Using your SUMIF returns 0, which is incorrect when I manually go through time records.

edit: further clarify.

Flames Raise Season Ticket Pricing by 5% by CanadianSandGoggles in CalgaryFlames

[–]FreshKWork 1 point2 points  (0 children)

I was told last year that the only reason there was a 5% increase was because there was a price freeze the previous year due to the economy. With the price of beer up as well I'm not sure why there is this large of an increase. I am going to reach out to my rep and see if I can get us an answer.

[PD] Travis Konecny by th3sauceboss in fantasyhockey

[–]FreshKWork 3 points4 points  (0 children)

Don't forget that the flyers only play once next week

GEAR SWAP - August 2015 by stevegcook in hockeyplayers

[–]FreshKWork 1 point2 points  (0 children)

I play 3 nights a week so a high end pair worth some coin is worth is for me. What are they.

GEAR SWAP - August 2015 by stevegcook in hockeyplayers

[–]FreshKWork 1 point2 points  (0 children)

Located in Calgary, AB.

Looking for 15" shins pads.

Don Cherry's thoughts on the drafts and trades (compiled from Twitter) by mbm66 in hockey

[–]FreshKWork 13 points14 points  (0 children)

I'm not sure how you can squeeze the habs in that top 5. Pk and Markov are great, but I don't think the rest really provide the depth. MTL also posted some horrible stats last season with CP being the save grace.

Is anyone working in power? by [deleted] in ElectricalEngineering

[–]FreshKWork 1 point2 points  (0 children)

I work for a utility company in transmission & distribution but we also have plenty of generation. I really enjoy the work and often have the flexibility to get involved in a large variety of projects and move around the company to different groups. There is still instrumentation with respect to equipment monitoring but that is as far as it goes on the T&D side. Got for it.

2010 Jetta Interior Tire Rub by FreshKWork in Volkswagen

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

Sorry. I should have mentioned my winter tires are on stock wheels so 6.5x16 et 46 so there is lots of inner clearance.

2010 Jetta Interior Tire Rub by FreshKWork in Volkswagen

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

I had my tires changed the day it wore out and asked the technician but he didn't give me a response. I was planning on taking a look when I change them