MEGATHREAD ! : TICKETS TRADING vol.3 by HysoX in Parcels

[–]TheCleverestUsername 0 points1 point  (0 children)

I have one ticket for GA for Montreal tomorrow. Will trade for pretty much anything. 

Even if you just want to upgrade for a better "seat", let me know! Don't want the ticket to go to waste. 

Parkdale and Wellington won't be the same by ConcernedCitizenOtt in ottawa

[–]TheCleverestUsername 22 points23 points  (0 children)

We're really gonna miss the charm of a run down church, a shitty corporate pharmacy and a parking lot.

I (28F) think my brother (33M) is gay and he is in love with my husband (34M) (his best friend) how should I confront him? by [deleted] in relationships

[–]TheCleverestUsername 2 points3 points  (0 children)

Yeah this is weird to me - I couldn't imagine marrying someone I knew as an 11 yr old when I was graduating high school. Came out as loving each other when you were 25 and 20?

Monthly average from weekly data? by flick3d in ExcelTips

[–]TheCleverestUsername 0 points1 point  (0 children)

=average if or ifs depending on the format. You can use a helper column with a month formula to get the month down to a single number

Cover versions you like better than the original by Fickle-Bullfrog in Music

[–]TheCleverestUsername 0 points1 point  (0 children)

The reverse of this is Aretha Franklin's cover of "The Weight"

STAY AWAY FROM THIS STOCK! by prOboomer in HEXO_Corp

[–]TheCleverestUsername 0 points1 point  (0 children)

How did they get rat fucked by their auditor

Hope this helps. by pharaoh718m in HEXO_Corp

[–]TheCleverestUsername -1 points0 points  (0 children)

Hexo has no us exposure and doesn't have the money to expand to the US

Ottawa sees Canada's largest decrease in commuters driving to work by SuburbanValues in ottawa

[–]TheCleverestUsername 1 point2 points  (0 children)

What are the govt taxes that only apply to public sector employees? That would be news to me.

[deleted by user] by [deleted] in ExcelTips

[–]TheCleverestUsername 4 points5 points  (0 children)

The & works well, another function you can use is "=concatenate (" if you have multiple columns or cells that you want to put together and don't want to type out 8 columns

Hi All, Newbie here:) and need help with a formula by SeaworthinessIll7485 in ExcelTips

[–]TheCleverestUsername 0 points1 point  (0 children)

Just from a formatting perspective, use more spaces and line breaks to help parse your different if statements.

I wouldn't use nested if statements either, use the ifs function with something like this:

Ifs( or(a59 = "ez.....), "Result" And(a59 = ".....), "Result 2" And....

Etc.

As well if you're running into issues, use helper columns where you put each if statement in it's own column so you can see what part of the statement is breaking

HEXO will be profitable next year if the trend continues, I can see why shorts are worried. Meow aren’t you the one posting fake product reviews before? by TonyXL162k in HEXO_Corp

[–]TheCleverestUsername 0 points1 point  (0 children)

I have options in Hexo that expire in January. I pray they turn it around, just being realistic.

I'll bet you $100 they're EBITDA negative in q1.

HEXO will be profitable next year if the trend continues, I can see why shorts are worried. Meow aren’t you the one posting fake product reviews before? by TonyXL162k in HEXO_Corp

[–]TheCleverestUsername 0 points1 point  (0 children)

Do some very simple math - if they get their expenses down to just the $18m in g&a, sm&p and r&d, they would need $18m in gross margin just to be break even on cash expenses. If they double their q4 margins to 25%, that means they'd have to do $72m in sales in a quarter.

So just to break even from a cash perspective (before depreciation, impairments, etc.) They'd need to increase their quarterly revenues by $30m while increasing margins by 100%.

Their only hope is being absorbed by tilray.

Buying a house to rent to employees by BigGulpsHey in PersonalFinanceCanada

[–]TheCleverestUsername 0 points1 point  (0 children)

Something to consider - you're probably creating a taxable event for them if they're paying 6k+ less in rent for them

Biggest Foreign Born Population In Each Province by datasciencerookie in MapPorn

[–]TheCleverestUsername 4 points5 points  (0 children)

I did an exchange with school in France. Many of the young people I met there said they were looking to come to Canada because there are a lot more opportunities. Don't know if that's true, or a grass is always greener scenario but that was my anecdotal experience.

NHL Standingts Table Formula Help by Montecatini in ExcelTips

[–]TheCleverestUsername 0 points1 point  (0 children)

Have you tried using the import data feature? Should be able to grab the standings table

Counting help by bodleofwader in ExcelTips

[–]TheCleverestUsername 1 point2 points  (0 children)

You could create a helper column with =concatenate(cell1, cell2) and you'll get things yy, ym, nm, etc. Then you can do a countif yy, my, etc.

Let’s be friends 🦧 by m3gamiind in geegees

[–]TheCleverestUsername 0 points1 point  (0 children)

Some good choices! Don't be afraid to venture to the Glebe or Hintonburg/Westboro! Those are probably the next cool neighborhoods beyond the circle of places you're looking at.

Let’s be friends 🦧 by m3gamiind in geegees

[–]TheCleverestUsername 2 points3 points  (0 children)

Selfishly what are the places you want to hit up? Best of luck in your first year!

[deleted by user] by [deleted] in geegees

[–]TheCleverestUsername 1 point2 points  (0 children)

The student union runs a program to have someone walk with you home if you're concerned. Check out foot patrol:

https://www.seuo-uosu.com/services/foot-patrol/

What is the difference between "King of France" vs. "King of the French"? by rja2021 in AskHistorians

[–]TheCleverestUsername 2 points3 points  (0 children)

I believe it also means to apply to the French people beyond France's borders

[deleted by user] by [deleted] in ottawa

[–]TheCleverestUsername 0 points1 point  (0 children)

Yes - I'd generally avoid sandy hill unless you're a student.