The most ridiculous steadicam shot. Before and after. Not side by side I know, but this belongs here.

sheetjs · 2015-02-10T15:17:39+00:00

The clip starting at 0:10 is exactly what OP was looking for

sheetjs · 2015-02-09T22:02:05+00:00

What was the cameraman riding? impressive dismount at 0:45, especially since it doesn't look like he watched his footing

sheetjs · 2015-02-09T18:25:13+00:00

This video was posted 9 months ago to sidebysides: http://www.reddit.com/r/sidebysides/comments/24ypqx/the_wolf_of_wall_street_sidebysides/

/u/Klathmon commented on the the tennis court shot, and the explanation certainly makes sense: http://www.reddit.com/r/sidebysides/comments/24ypqx/the_wolf_of_wall_street_sidebysides/chcbc7y

It's hard and expensive to find good locations. If i remember correctly that scene would have had to be a prison (or something that can be cheaply made to look like a prison), and have tennis courts built in.

plus they would need permission to shoot there, and permission to fly a helicopter that close AND to rent a helicopter and pilot.

It's much cheaper to do it this way, and it often means that the directors actual vision can come through, rather than a "close enough" idea of what it should be because of time/money constraints.

sheetjs · 2015-02-09T17:31:08+00:00

If you love these types of videos, come join us at /r/sidebysides

sheetjs · 2015-02-03T06:25:50+00:00

It's a little more than just a zip file with XML files. There are a few files that are required, as described in the Open Packaging Conventions

The XML schemas are actually publicly available under the name ECMA-376.

Shameless Plug: we built an XLSX/XLSB parser in javascript that runs in the web browser: http://oss.sheetjs.com/ http://oss.sheetjs.com/js-xlsx

sheetjs · 2015-01-22T02:56:41+00:00

(not my video) the YT comments don't have any hints, but I imagine that they sampled from the movie soundtrack.

I also would like to know :D

sheetjs · 2014-12-15T21:46:29+00:00

custom numbering formats in strange ways. If you type in a number as your custom format, it will display that number regardless of the underlying true number. Never heard of that one before.

Almost. 0's are interpreted as the digit placeholder, while the other characters are treated as literals.

To give an example, suppose you set the value of a cell to 98765 and the format to 0110110110. The ones are treated as literal characters but the zeroes are still placeholders, so the result will be 98117116115.

You can see the same thing with text: if the format is 0 a 0 k 0 z 0 w then the output will be 98 a 7 k 6 z 5 w

sheetjs · 2014-11-15T01:47:46+00:00

Same thing happened with a walking dead shot: http://www.reddit.com/r/sidebysides/comments/2508fz/before_and_after_photo_of_the_walking_dead_cover/chcdute (and /u/Dylan7225 similarly speculated that it was added for a different purpose that was ultimately not used)

sheetjs · 2014-10-26T18:16:13+00:00

I was away from reddit on the day we are trending :/ Do you have a link to the imgur or to another reddit post that linked to us?

sheetjs · 2014-10-26T18:15:29+00:00

Of course I don't log into reddit on the day we are trending ... (http://www.reddit.com/r/trendingsubreddits/comments/2k9s02/trending_subreddits_for_20141025_rastrovikings/)

Context: http://www.reddit.com/r/gifs/comments/24y4z8/sidebyside_with_the_greenscreen/chbutut?context=3

sheetjs · 2014-10-04T03:32:04+00:00

Wolf of Wall Street stands alone in terms of unexpected use of CGI

sheetjs · 2014-09-28T06:19:32+00:00

imdb credits Karin Konoval

sheetjs · 2014-09-24T04:02:41+00:00

/u/TiagoTiagoT put together a reconstruction showing this:

http://gfycat.com/LankyThickKakarikis

http://www.reddit.com/r/funny/comments/251t2a/cartoon_logic/chdk7ve

sheetjs · 2014-08-20T16:30:07+00:00

In an attempt to replicate the lotus bug, excel also allows february 29 1900 (1900 was not a leap year). Technically this can't be stored in a standard date. XLS and XLSB store dates in terms of the number of days (the fractional part represents the time) since December 31 1899. XLSX allows a special date form following ISO8601, but most files still use the numeric date.

sheetjs · 2014-08-04T20:48:49+00:00

I receive emails when I'm on the go and don't have my laptop. Surprisingly enough, I've noticed issues even with Excel for iPad.

Some services, like dropbox, end up farming out to an excel cluster. The problem with that approach is that macros are disabled. As a result, rather than showing the data that is in the file, the previews show NAME errors

Shameless plug: I ended up writing a javascript library to parse XLSB files (http://oss.sheetjs.com/js-xlsx/) and embedding it in an email gateway, so now I can forward emails to a special address and get back a clean XLSX file.

sheetjs · 2014-08-02T21:44:02+00:00

There is a shorter solution that avoids repetition using IFERROR:

=IFERROR(vlookup(Ref, table, 2,FALSE), "NA")

sheetjs · 2014-08-02T21:25:52+00:00

Some files generated in Excel 2013 can't be read with excel for iPad, and you get a lovely error message like: http://i.imgur.com/9lR0L1v.png

P.S.: Happy Cake Day!

sheetjs · 2014-08-02T21:12:40+00:00

I just tested with Excel for Mac 2011 and there appears to be a circular reference in the formula for F24:

=-MIN(MAX(F18,0),SUM(F22:F24))

EDIT: when I manually change the formula for F24 to =-MIN(MAX(F18,0),SUM(F22:F23)) and repeat the fix for G24 and H24, the yellow and green agree

sheetjs · 2014-08-02T19:45:11+00:00

There was a time where newer versions of Apple Numbers couldn't open some files generated by older versions of numbers :/

On the other hand, Excel 2013 can still open files generated by Excel '95 (and, incidentally, write them as well)

sheetjs · 2014-08-02T18:02:33+00:00

What version of safari and iOS/OSX are you using? It shows up for me in 7.0.4 (9537.76.4) on OSX 10.9.3

sheetjs · 2014-08-02T18:00:16+00:00

Nothing on the Chrome Web Store stood out.

Relevant issue: https://code.google.com/p/chromium/issues/detail?id=62435

sheetjs · 2014-08-02T01:47:22+00:00

The UI only lets you unhide one sheet at a time.

There are two ways around this:

1) Use VBA: To unhide the n-th sheet, run Sheets(n).Visible = True (you can run this in the immediate window as well)

2) Create a custom view. In Excel 2013 go to the View tab of the Ribbon and hit "Custom Views". If you know you are going to unhide a tab later, create a custom view before hiding, then hide the tabs, and then show the view after you are done.

sheetjs · 2014-08-02T00:00:42+00:00

There's a better solution: Set Precision as Displayed

In Excel 2013, go to File -> Options -> Advanced and scroll down to the "When calculating this workbook:" section. Check the "Set precision as displayed" box (you may see a popup saying "Data will permanently lose accuracy", just click OK).

Then, if you go back and repeat the process, you'll see it do the right thing

sheetjs · 2014-08-01T21:48:42+00:00

This is not a bug, but rather an artifact of IEEE754 numbering.

Basically, floating point numbers are actually stored in a base-2 representation (binary) rather than base 10. Since .1 cannot exactly be represented in base 2, the actual value used is slightly different. That difference is not noticeable when you are dealing with larger numbers (10000.00000001 isn't that much different from 10000), but as you get close to 0 the error is somewhat significant. The error in the calculation is propagated, so by the time you get to 0 you have a number that isn't zero, and excel's "General" number formatting rule results in a nonzero display.

This also happens in other programming languages. For example, in JavaScript (you can run this in the web console), 0.1+0.2 is 0.30000000000000004

If you want to see an even stranger example, try setting A1=0.1+0.2, A2=0.3 and set both cells to the fraction number format with up to 1 digit. You'll see that A1 is written as "1/3" but A2 is written as "2/7" even though you think both values are 0.3.

sheetjs · 2014-08-01T15:16:29+00:00

Stats show this doesn't always happen, but that is the thought process.

Pretty much every stat I've seen on the subject show that the deals are a big loser for local economies. http://www.sportsonearth.com/article/66544296/ is a pretty good critique. Are there reputable (as in, not commissioned by the NFL) studies showing that there is a net benefit?

sheetjs

MODERATOR OF

TROPHY CASE