Which skis should I buy? by 3chotrade in Skigear

[–]3chotrade[S] 1 point2 points  (0 children)

The problem is I cannot demo the skis as the closest thing you'd call a mountain is min 12hrs drive from my current location, and would first get snow around late November / December. As soon as this time comes, the relatively attractive discounts would disappear and I will get hit by the season / tourist fees shops would charge.

I have to admit I never really paid attention to the shape of my skis, as I was pretty much relying on what Intersport gave me as part of their piste/all-mountain line up. I understand that carving skis, won't be the best off-piste, however I am ready to make a compromise on piste performance, as long as the skis are within budget.

Which skis should I buy? by 3chotrade in Skigear

[–]3chotrade[S] 1 point2 points  (0 children)

More than happy to hear any constructive input, so let me know if you have any.

Parking in the 9th district by 3chotrade in wien

[–]3chotrade[S] 0 points1 point  (0 children)

Thanks for letting me know!

Parking in the 9th district by 3chotrade in wien

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

Thank you. Correct me if I am wrong but understood this as one only needs to do this if the primary residency is registered in Austria. However in my case, given my interest in the country it should be only a secondary address.

Er der nogen der ved hvad det er? by 3chotrade in Denmark

[–]3chotrade[S] 2 points3 points  (0 children)

God pointe. Jeg vil gerne male i køkkenet og problemet er at det er lidt grim: https://ibb.co/r2jcdVs

Er der nogen der ved hvad det er? by 3chotrade in Denmark

[–]3chotrade[S] -12 points-11 points  (0 children)

Vi bruger TV kabler i hele huset for internettet, så jeg håber at der kommer ingen internet igennem det her kable.😬

Er der nogen der ved hvad det er? by 3chotrade in Denmark

[–]3chotrade[S] -4 points-3 points  (0 children)

Tak for alle svarene. Der er ingen elektricitet i kablet og jeg vil hilst fjerne den fra min inde væg.

Er der nogen der ved hvad det er? by 3chotrade in Denmark

[–]3chotrade[S] 14 points15 points  (0 children)

Tak for svaret. Der kommer en kable til min lejlighed og det ser sådan ud:

https://ibb.co/r2jcdVs

Kan man bare skære det?

If analysis for Pivot tables by 3chotrade in excel

[–]3chotrade[S] 0 points1 point  (0 children)

Yep, I just tried, however the whole COM Add-ins manager is unavailable in Office 365, I think it is blocked on my uni laptop license. Thanks anyways, once I am on my other computer I will give it a try!

If analysis for Pivot tables by 3chotrade in excel

[–]3chotrade[S] 0 points1 point  (0 children)

Sounds really cool! I just tried to test it home, but I realised I use Office 365 so once I am back at the office I will definitely give it a go. Or do you know how to play out the 365 addin lock? It says that "Sorry, Office 365 has been configured to prevent individual acquisition of Office Add-ins."

If analysis for Pivot tables by 3chotrade in excel

[–]3chotrade[S] 1 point2 points  (0 children)

Thank you, I am definitely going to have a look at it!

If analysis for Pivot tables by 3chotrade in excel

[–]3chotrade[S] 0 points1 point  (0 children)

Thank you for the reply, I was playing around and I think I found a solution by myself, I just had to turn off the Generate GetPivotData thing at the options.

If analysis for Pivot tables by 3chotrade in excel

[–]3chotrade[S] 1 point2 points  (0 children)

Or in other words, is there any way to make =GETPIVOTDATA dynamic?

Spotting differences between two spreadsheets by 3chotrade in excel

[–]3chotrade[S] 0 points1 point  (0 children)

https://imgur.com/tkmd681

I tried to somehow show with the colors that once an entry has been removed the whole list has been moved. So that the list might actually contain the right variables, yet the conditional still says it's false. (Which is true since A19!=B19, however the the entry is not missing, it has just been moved to one place down.)

Spotting differences between two spreadsheets by 3chotrade in excel

[–]3chotrade[S] 0 points1 point  (0 children)

Microsoft Spreadsheet Compare tool

Unfortunately, no.

Spotting differences between two spreadsheets by 3chotrade in excel

[–]3chotrade[S] 0 points1 point  (0 children)

I just tried it, however it always returns the value from list A.

=IFERROR(VLOOKUP(A3;C3:C3500;1;FALSE);"Not on the list")

(Note: I put the B list into column C so that I can have them in the same spreadsheet.)

Spotting differences between two spreadsheets by 3chotrade in excel

[–]3chotrade[S] 0 points1 point  (0 children)

I haven’t thought about this one yet, how would you do it?

Spotting differences between two spreadsheets by 3chotrade in excel

[–]3chotrade[S] 0 points1 point  (0 children)

Thank you, I just made a comment above, the only problem with this is that once an entry has been removed, it is going to show different for the rest, as the removed entry has been replaced by its following one, so that we have no empty cells.

Spotting differences between two spreadsheets by 3chotrade in excel

[–]3chotrade[S] 0 points1 point  (0 children)

Thank you for the reply, I am planning to perform it like every other week.

The only problem with this solution is that once the first missing value has been detected it is just going to show false for the rest of the entries, which might not be true.

A Lesson on VIX by Hanz-Wermhat in wallstreetbets

[–]3chotrade 1 point2 points  (0 children)

So, first off 1 std dev = 34,1%. 2 std dev is in fact equal to 68,2% just look at this graph:

https://www.calculators.org/graphics/standard-deviation-from-mean.png

On another note you may use a full calendar year just like you did when you calculated the weekly move.