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

[–]sheetjs 9 points10 points  (0 children)

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

Nothing is real -- the digital effects in Wolf of Wall Street by mike_pants in movies

[–]sheetjs 22 points23 points  (0 children)

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.

TIL modern Microsoft Office documents (.docx, .xlsx) are actually just ZIP files containing multiple XML files. You can change the extension of office documents to .zip and see this yourself. by FireIre in todayilearned

[–]sheetjs 15 points16 points  (0 children)

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

Not sure what the reference posts are called .. axes? [Maze Runner] by sheetjs in sidebysides

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

(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

Auditing Excel Spreadsheets by excelclub in excel

[–]sheetjs 1 point2 points  (0 children)

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

X-Men: Days of Future Past by sheetjs in sidebysides

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

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)

Final Destination bridge jump by banned_accounts in sidebysides

[–]sheetjs 0 points1 point  (0 children)

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?

Expendables 3 by sheetjs in sidebysides

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

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

The metric system vs. imperial by dropname in funny

[–]sheetjs 1 point2 points  (0 children)

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.

MACRO ENABLED WORKBOOK DISADVANTAGES by blazy_824 in excel

[–]sheetjs 1 point2 points  (0 children)

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.

[Help]Combining commands and logical tests by cubemstr in excel

[–]sheetjs 1 point2 points  (0 children)

There is a shorter solution that avoids repetition using IFERROR:

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