Translate to your own language

Become a member of ADDY as me with my link and get $25 to kickstart your own investing journey 🏠

Showing posts with label file format. Show all posts
Showing posts with label file format. Show all posts

May 25, 2020

Understanding The Difference Between XLS And XLSX In Tabular Form

Understanding The Difference Between XLS  And XLSX In Tabular Form


 Basis of Comparison XLS XLSX
 Version XLS is the older version of Microsoft Excel. XLSX  is the latest version of Microsoft  Excel
 Main Difference XLS is the default file format for the 2003 version of Excel XLSX is the file format for versions since 2007.
 Storage of Information XLS is based on BIFF (Binary Interchange File Format) and as such, information is directly stored to a binary format. XLSX is based on the Office Open XML format, a file format that was derived from XML. The information in an XLSX file is stored in a text file that uses XML to define all its parameters.
 Speed performance XLS version of the file is faster especially on files that require the use of complex formula for a large set of data. XLSX version of the file is slower especially on files that require use of complex formula for a large set of data.
 Readability XLS is readable by all Microsoft Excel versions. XLSX is only readable by Microsoft Excel versions 2007 and onwards.
 Capability XLS is capable of holding the spreadsheets either containing Macros or not. XLSX is not capable to support Macros. 
 Based On XLS is a proprietary binary format. XLSX is based on office open XML format.  

Summary - What is the main difference between XLS and XLSX versions of Microsoft Excel?

XLSX and XLS files are Microsoft Excel spreadsheets commonly used to store financial data and to create mathematical models. These files store data in worksheets that contain cells arranged as a grid of rows and columns. Excel spreadsheets may also contain charts, mathematical functions and various kinds of cell formatting. Spreadsheets are often used in business contexts to store financial data and to perfom mathematical computations.
The main difference between XLS and XLSX is that XLS files use a proprietary binary format whereas, XLSX use a newer file format known as Open XML. Another difference is that the XLS extension is used by Microsoft Excel 2003 and earlier whereas the XLSX extension is used by Microsoft Excel 2007 and later.

June 13, 2017

3GP vs MP4

Image courtesy of zirconicusso at FreeDigitalPhotos.net
Your new smart phone will record video in either 3GP or MP4 file format. 3GP (3GPP file format) is a multimedia container format defined by the Third Generation Partnership Project (3GPP) for 3G UMTS multimedia services. It is used on 3G mobile phones but can also be played on some 2G and 4G phones.
 MPEG-4 Part 14 or MP4 is a digital multimedia container format most commonly used to store video and audio, but it can also be used to store other data such as subtitles and still images. Like most modern container formats, it allows streaming over the Internet.
 The 3GP files store video streams as MPEG-4 part 2 or MPEG-4 part 10 (h. 264) or h. 263, and also audio streams. 3GP is a simplified version of the MP4 format and was designed to make file sizes smaller so mobile phones could support it. 3GP is able to store and transmit important priority of bytes. 
 3GP encoding profile is commonly used for digital video, telecommunications specialists engineered it especially for performance on 3G network mobile phones. Conversely, MP4 is a generic format for any digital video that was published with MPEG-4 compression. The formats are so highly similar, some 3GP files can be opened if their extension is changed to MP4.
 When evaluating the MP4 and 3GP formats, the question is not which one stores superior digital video, but rather, which one is best suited to the task at hand. While both contain multiple tracks of media and have similar encoding methods, their differences are most pronounced when it comes to use on portable devices. Despite this wide compatibility, MP4 files are not optimized for playback on 3G network mobile phones as 3GP files are.
 While 3GP files are specialized for 3G network mobile phones, they can also be opened in certain media players. These applications include QuickTime, VLC and RealPlayer. However, since MP4 files are widely shared and more generalized, support for the format is practically standard in media software. In addition to QuickTime, VLC and RealPlayer, MP4 files can be streamed in iTunes and Windows Media Player. MP4 files can also be uploaded to the Apple iPod, Apple iPhone and Sony PSP.
 When it comes to streaming video on your computer desktop or portable media player, MP4 is the better format because it can support higher resolution video. However, the 3GP should be used exclusively on 3G network phones since it is specifically formulated for the device.

Search This Blog