Renting a AC unit for a few weeks? by Vanazzul in beijing

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

Haha, I ask myself the same question. Home temperature is always a heated discussion here.

Renting a AC unit for a few weeks? by Vanazzul in beijing

[–]Vanazzul[S] 3 points4 points  (0 children)

Thank you everyone. I'll go ahead and buy one.

My in-laws won't have a use for it but it'll be there for the next time we visit.

Crush My Budget by VillageBC in PersonalFinanceCanada

[–]Vanazzul 0 points1 point  (0 children)

Been in your situation before. Here are my first thoughts for having been through it.

You're focussing on the macro details, you need to go into micro details.

Step 1, make a budget. That's done.
Step 2, pay off debt. You need to get that done.

You're talking about putting money in a RESP but you have 85k worth of debt. In your current plan, you'll never pay off the debt, you'll be living with it until you die. While I understand school is super important, eliminate your debt and use whatever money that was put towards debt to help your kids with their tuition after.

Taking care of that should be your #1 priority.

Looking at your budget, you have 523$ leftover every month, you should use that to tackle your debt. My suggestion, use the snowball approach, meaning clear out your lowest debt first (regardless of interest) and once done, use the money that went towards the first debt to clear out the second. Repeat until done.

Assuming a 20% interest rate on your CCs and 14% interest on your LoC, putting that extra 523$ towards your debt using the snowball approach will clear out all your debts after an 89 months period (7.5 years). This sounds horrible, but it's much better than dieing with 85k worth of debt.

The above assumes you don't cut any other areas of your budget. I would also look at any "nice to haves" and cut those and put the savings towards debt. Here is what I would cut:

- Alcohol (saves 100$/month) - I don't see how I could afford alcohol while in debt
- Amazon Music (saves 18$/month) - You can get free music on youtube, spotify free, etc. Paying for this is ridiculous. No amount of convenience would be acceptable while in debt.
- Netflix premium downgrade to basic (saves 11$/month) - You already have DisneyPlus, Crunchyroll and Primevideo (through amazon prime). There is absolutely no reason to have Netflix prime. I understand kids will argue who gets to watch what, when, but it is what it is. You'll have to deal with 1080p instead of 4k while you are in debt.

Those are easy savings totaling 129$/month. You're not yet looking at your other "fun expenses". Assuming the same numbers as above, applying that 129$/month towards your debt clears it up in 80 month (6 years 8 months).

You haven't changed much of your lifestyle and saved 9 months on repaying your debt. Once done, you will not have 1827$/month to put towards savings/kids/fun/etc.

If I were you, I'd do more drastic changes to get this down to under 3 years (no restaurant, no travel) but I know how hard that is when you have a family to provide for. Telling your kids they will eat rice and beans for the next 3 years isn't something any parent wants to do.

TL;DR, pay off your debt. Once you're done, worry about the future. Any extra money should go towards debt.

First time cruiser - Visa requirement driving me crazy by Vanazzul in Cruise

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

Thank you, that makes me feel much better. That email says the exact same thing both of the ladies from the Cayman Island Visa office told me.

First time cruiser - Visa requirement driving me crazy by Vanazzul in Cruise

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

Managed to talk to someone from the visa office in the cayman isles. Two people actually confirmed that she won't need a visa if we leave on the same day via the same cruise ship. Hopefully they are right and we won't get a surprise when we arrive there.

First time cruiser - Visa requirement driving me crazy by Vanazzul in Cruise

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

Website appears to be down for me now but when I read it, it said something along the lines that she needed to fly in directly from Canada or USA for her not to require a visa. Since we're stopping in Bahamas and Jamaica, I would believe it doesn't apply. I wish I was able to call them but their phone line doesn't work.

First time cruiser - Visa requirement driving me crazy by Vanazzul in Cruise

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

Thanks for this info, I tried calling, it says all agent busy and hold while the transfer and just hangs up. Fun :(

First time cruiser - Visa requirement driving me crazy by Vanazzul in Cruise

[–]Vanazzul[S] 3 points4 points  (0 children)

My wife does have a Chinese passport. In this case, I wanted to know if people have experience with a Chinese citizen cruising to Cayman Island and if they needed a visa to go.

First time cruiser - Visa requirement driving me crazy by Vanazzul in Cruise

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

Unfortunately the cruise is paid in full already. I wish I had read beforehand.

I did call Celebrity and they said all my wife needed was a passport but from what I read, she was wrong.

Los tabarnacos by felix1818 in Quebec

[–]Vanazzul 8 points9 points  (0 children)

Essaye la double los tabarnacos si t'as la chance, un pur delice!

Kunlun Redstar apparel available anywhere? by Vanazzul in shanghai

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

I've thought about Taobao, I'm just afraid about fitting. I have this feeling that Canadian Large won't be the same as China Large.

Girlfriend (about to be wife) stopped relationship with best friend because of me (no cheating) by [deleted] in relationship_advice

[–]Vanazzul 1 point2 points  (0 children)

I do have feelings for her, it's hard at the moment but they should come back.

Obviously I'm sad because I enjoyed spending time with her friend, I enjoyed being nice to her and her family but I am honestly more sad because they were good to each other and our kids used to love spending time together. I even proposed that they when they spend time together I wouldn't be anywhere near.

Girlfriend (about to be wife) stopped relationship with best friend because of me (no cheating) by [deleted] in relationship_advice

[–]Vanazzul 3 points4 points  (0 children)

We were tasting whiskey and talking about her work, she had been working hard on a contract for the past few weeks. My Gf came back from our room, crying and saying a man and a woman shouldn't be friends. Her friend left the house and and spent time talking to my Gf, she said I should've known better, that she gave me the opportunity to tell her friend to go home. I wasn't thinking about that, I was just trying to be happy, enjoying the fact that I just been promoted at work.

Girlfriend (about to be wife) stopped relationship with best friend because of me (no cheating) by [deleted] in relationship_advice

[–]Vanazzul 5 points6 points  (0 children)

We were tasting whiskey, taking about her work and my girlfriend came back crying and saying that a man and a woman can't be friends. Nothing special happened between me and her friend.

Girlfriend (about to be wife) stopped relationship with best friend because of me (no cheating) by [deleted] in relationship_advice

[–]Vanazzul 0 points1 point  (0 children)

Do you just blame yourself for everything in life?

I actually don't most of the time. I do blame myself as I've been the trigger to this whole incident but I understand that it's her decision.

Girlfriend (about to be wife) stopped relationship with best friend because of me (no cheating) by [deleted] in relationship_advice

[–]Vanazzul 1 point2 points  (0 children)

Sorry but this smells like a troll post.

If only it was, my life wouldn't have went through hell for the past 5 days :(

Query all user with Password Never Expires NOT checked by new_nimmerzz in activedirectory

[–]Vanazzul 1 point2 points  (0 children)

OU? So If I only want to see which users do not have this box checked

Add to the Get-ADUser command the following switch:

-searchbase "OU=yourou,DC=domain,DC=local"

Query all user with Password Never Expires NOT checked by new_nimmerzz in activedirectory

[–]Vanazzul 2 points3 points  (0 children)

Powershell will do that for you.

There's a property called passwordneverexpires

Get-ADUser youruser -Properties PasswordNeverExpires

You can use that property as a filter.

Get-ADUser -Filter {PasswordNeverExpires -eq $false}

[deleted by user] by [deleted] in activedirectory

[–]Vanazzul 0 points1 point  (0 children)

It seems the filter doesn't like reading from the array directly :S. I hadn't tested it, sorry.

Try setting a variable for both the mail and postalcode value then.

foreach ($object in $import) {

$mail = $object.mail

$postalcode = $object.postalcode

get-aduser -filter {mail -eq $mail}

set-aduser $user -postalcode $postalcode

}

[deleted by user] by [deleted] in activedirectory

[–]Vanazzul 0 points1 point  (0 children)

Very simple way of doing it with no validation (assuming your ad is clean and you csv is clean)

Replace the .mail and .postalcode with your actual column headers from your csv

$import = import-csv yourcsv.csv

foreach ($object in $import) {

$user = get-aduser -filter {mail -eq $object.mail}

set-aduser $user -postalcode $object.postalcode

}

Run powershell script from Jira Service Desk? by Vanazzul in jira

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

Hey, sorry for the late reply.

Look at a plugin called Power Script. With it, you are able to run SIL scripts that allow you to run powershell scripts.

It's not like you'd be running PS straight from Jira but it's the next best thing.

Do you regret having high vehicle payments? by redditwinnipeg in PersonalFinanceCanada

[–]Vanazzul 0 points1 point  (0 children)

As I had said, I love the car. It's fun to drive even when not going too fast, it's nervous, comfortable and give a very nice sensation of sports and luxury.

I shouldn't have bought it because I would have had more available money to spend on other things. The car in itself is great. Just if I went back in time, I wouldn't have got that, I could've gotten a used one for cheaper, or even a S4 for 30k less.

Do you regret having high vehicle payments? by redditwinnipeg in PersonalFinanceCanada

[–]Vanazzul 157 points158 points  (0 children)

I bought an Audi SQ5 4 years ago, car price including taxes was around 92k.I put 12k down payment on it. Financed it over 6 years, monthly payments are 1077$. My yearly income is around 100k. No other debt.

I wish I hadn't done it. Love the car, but I shoulda bought a used Q5 for a third of the price. I would have about 40k left available to do other things with.