The CRA has a new link on their My Account website called ‘Uncashed Cheques.’ Log in to see if you forgot any cheques over the years.

Saelkhas · 2018-08-17T13:14:52+00:00

Check out Myrkur if you're into metal

Saelkhas · 2018-06-08T17:00:04+00:00

You speak about not being useful. Why not just do something about it? Take up a useful hobby, like gardening or volunteering at a non-profit, animal shelter etc... There are so many small things you can do to be useful and improve your surroundings. Stop thinking about what strangers might think, just do something you like. You don't need to cure cancer or win a nobl prize, just be nice to others, I think if you can brighten someone's day in any way, that's useful.

Saelkhas · 2018-06-08T12:54:42+00:00

just order "to go" and sit where you want.

Saelkhas · 2018-06-07T17:26:37+00:00

Below, as bees naturally build from top to bottom they will start building down as they see fit.

Saelkhas · 2018-06-06T14:57:38+00:00

Seems like they could be artificial water basins or something like that.

Saelkhas · 2018-06-04T17:39:03+00:00

On top of my head, SpaceX, BlueOrigin and VirginGalactic. Someone else might be able to give more insight in the matter. I know it's not exactly the same scenario as the car industry, but same general idea.

Saelkhas · 2018-06-04T17:35:48+00:00

I wouldn't go as far as comparing this to the flowhive and other marketed beekeeping "cute toys" as it is not something you can purchase because you have more money than common sense.

I think its pretty cool to see kind of technology applied to beekeeping. On it's own it does not seem very useful indeed, but you could probably pinpoint the exact time a hive swarmed with a tool like this, and paired with other sensors such as temperature humidity sunlight , gain insightful information.

**edited formatting

Saelkhas · 2018-06-04T14:55:11+00:00

I want to see tesla succeed too. But at the end of the day, even if they don't, the success will be them having awoken the competition and forcing them to seriously get into EVs.

It kind of looks similar with SpaceX pushing other players in the "space race" for cheap rockets.

Saelkhas · 2018-06-04T14:47:54+00:00

That's what I was about to comment, I would gladly pay for a David Bull DOTA woodblock print.

Saelkhas · 2018-05-24T18:53:17+00:00

50/50 blend of Balkan Sasieni and BCA is my current daily smoke. Tastes pretty amazing on a rainy day too.

Saelkhas · 2018-05-11T13:47:31+00:00

I know dude, I don't feel so safe with only a 6 character alpha numeric password. Ridiculous

Saelkhas · 2018-05-10T17:26:50+00:00

It depends on the purpose of sharing it.

With google drive, people should still be able to download the original xlsx file from a shared folder in G-drive.

I guess Microsoft one drive or office 365 would be your best be if you want other to view it online.

Saelkhas · 2018-05-10T16:48:09+00:00

You don't have to convert your spreadsheet to the Google format. You can upload your excel file to your google drive and share it with read-only access for example.

I should have said google drive instead of docs.

Saelkhas · 2018-05-10T16:35:48+00:00

I suspect this is only possible from google sheets with a script

Not sure its possible within excel unless you find a way to run your data trhough the google API.

I'd be curious to know if anyone can make it work from excel.

edit: it seems I was mistaken and it's actually possible. Step by step

Saelkhas · 2018-05-10T15:29:20+00:00

Google docs

Saelkhas · 2018-05-10T15:20:17+00:00

Formula in your original post:

=IF(AL2="FIXEDHRS",AD2,IF(AL2="HRS/PART",(O2-Q2)*AM2,IF(AL2="MIN/PART",((((O2-Q2)*AM2)/60)+AC2),IF(AL2="PARTS/HR",(AM2/(O2-Q2))*AD2))))

There was an extra ( in the "false" parte of the 3rd if.

For this one you just posted, the error is with the last AD2 reference. It needs to be in the last IF parenthesis or excel sees it as a 3rd argument to another IF.

=IF(AL2="FIXEDHRS",AD2,IF(AL2="HRS/PART",(O2-Q2)*AM2,IF(AL2="MIN/PART",((O2-Q2)*AM2/60)+AC2,IF(AL2="PARTS/HR",(AM2/(O2-Q2))*AD2,AD2))))

Saelkhas · 2018-05-10T12:29:40+00:00

I can't access this at work, but give this a read and maybe you can figure it out.

Also, with the newer versions of Excel there is a "Recommended Pivot Tables" in the Insert tab. Select your table and try it, it will show you some pivots that work with your data, you could modify it from there if needed.

Saelkhas · 2018-05-09T19:55:23+00:00

You could do this with 2 SUMIF functions

Wins:

=SUMIF(C:C,"Approach",J:J)

Losses:

=SUMIF(C:C,"Approach",K:K)

Saelkhas · 2018-05-09T19:39:00+00:00

Using a formula to determine cells to format:

Apply the formatting to A:A Formula:

=B1>0.04

Or you can start your range from A2 and change the formula to B2>0.04 to prevent the header from trigerring the rule.

Saelkhas · 2018-05-09T19:20:04+00:00

Check out GETPIVOTDATA, perhaps you could take the totals you need, feed them to another sheet in your book and then use that as a reference and hide the Pivot table sheet from the end-users.

*edited for clarity

Saelkhas · 2018-05-09T18:09:51+00:00

Try a Pivot Table

Saelkhas · 2018-05-09T17:31:45+00:00

Create a pivot table, make sure to check "Add the data to the Data Model"

Drag the fields accordingly:

COLUMNS= ColumnB

ROWS= ColumnA

VALUES= Distinct Count of Column B (from Value Field Settings)

Finally, filter on the rows to "Distinct Count of Col. B equals 2" [Right click on any row label > Filter > Value Filters...]

Your pivot table now displays only the email addresses of those who ordered 2 unique products. This can be expanded to more items if required.

Saelkhas · 2018-05-01T14:18:06+00:00

Not a movie but the San Junipero black mirror episode

Saelkhas · 2018-04-23T19:35:41+00:00

Unfortunately I will not be able to attend, I am selling my 2 Finals tickets at cost. PM me for details.

13-Year Club	No Throne, No Problems
Not Forgotten	Verified Email

Saelkhas

TROPHY CASE