Microsoft Binary Format

From HandWiki
Short description: Floating-point number format by Microsoft

In computing, Microsoft Binary Format (MBF) is a format for floating-point numbers which was used in Microsoft's BASIC languages, including MBASIC, GW-BASIC and QuickBASIC prior to version 4.00.[1][2][3][4][5][6][7]

There are two main versions of the format. The original version was designed for memory-constrained systems and stored numbers in 32 bits (4 bytes), with a 23-bit mantissa, 1-bit sign, and an 8-bit exponent. Extended (12k) BASIC included a double-precision type with 64 bits.

During the period when it was being ported from the Intel 8080 platform to the MOS 6502 processor, computers were beginning to ship with more memory as a standard feature. This version was offered with the original 32-bit format or an optional expanded 40-bit (5-byte) format. The 40-bit format was used by most home computers of the 1970s and 1980s. These two versions are sometimes known as "6-digit" and "9-digit", respectively.[8]

On PCs with x86 processor, QuickBASIC, prior to version 4, reintroduced the double-precision format using a 55-bit mantissa in a 64-bit (8-byte) format. MBF was abandoned during the move to QuickBASIC 4, which used the standard IEEE 754 format, introduced a few years earlier.

History

Bill Gates and Paul Allen were working on Altair BASIC in 1975. They were developing the software at Harvard University on a DEC PDP-10 running their Altair emulator.[9] One thing they lacked was code to handle floating-point numbers, required to support calculations with very big and very small numbers,[9] which would be particularly useful for science and engineering.[10][11] One of the proposed uses of the Altair was as a scientific calculator.[12]

Altair 8800 front panel

At a dinner at Currier House, an undergraduate residential house at Harvard, Gates and Allen complained to their dinner companions that they had to write this code[9] and one of them, Monte Davidoff, told them that he had written floating-point routines before and convinced Gates and Allen that he was capable of writing the Altair BASIC floating-point code.[9] At the time, while IBM had introduced their own programs, there was no standard for floating-point numbers, so Davidoff had to come up with his own. He decided that 32 bits would allow enough range and precision.[13] When Allen had to demonstrate it to MITS, it was the first time it ran on an actual Altair.[14] But it worked, and when he entered ‘PRINT 2+2’, Davidoff's adding routine gave the correct answer.[9]

A copy of the source code for Altair BASIC resurfaced in 1999. In the late 1970s, Gates's former tutor and dean Harry Lewis had found it behind some furniture in an office in Aiden, and put it in a file cabinet. After more or less forgetting about its existence for a long time, Lewis eventually came up with the idea of displaying the listing in the lobby. Instead, it was decided on preserving the original listing and producing several copies for display and preservation, after librarian and conservator Janice Merrill-Oldham pointed out its importance.[15][16] A comment in the source credits Davidoff as the writer of Altair BASIC's math package.[15][16]

Radio Shack Tandy TRS-80 Model I System

Altair BASIC took off, and soon most early home computers ran some form of Microsoft BASIC.[17][18] The BASIC port for the 6502 CPU, such as used in the Commodore PET, took up more space due to the lower code density of the 6502. Because of this it would likely not fit in a single ROM chip together with the machine-specific input and output code. Since an extra chip was necessary, extra space was available, and this was used in part to extend the floating-point format from 32 to 40 bits.[8] This extended format was not only provided by Commodore BASIC 1 & 2, but was also supported by Applesoft BASIC I & II since version 1.1 (1977), KIM-1 BASIC since version 1.1a (1977), and MicroTAN BASIC since version 2b (1980).[8] Not long afterwards, the Z80 ports, such as Level II BASIC for the TRS-80 (1978), introduced the 64-bit, double-precision format as a separate data type from 32-bit, single-precision.[19][20][21] Microsoft used the same floating-point formats in their implementation of Fortran[22] and for their macro assembler MASM,[23] although their spreadsheet Multiplan[24][25] and their COBOL implementation used binary-coded decimal (BCD) floating point.[26] Even so, for a while MBF became the de facto floating-point format on home computers, to the point where people still occasionally encounter legacy files and file formats using it.[27][28][29][30][31][32]

VAX-11/780 minicomputer

In a parallel development, Intel had started the development of a floating-point coprocessor in 1976.[33][34] William Morton Kahan, as a consultant to Intel, suggested that Intel use the floating point of Digital Equipment Corporation's (DEC) VAX. The first VAX, the VAX-11/780 had just come out in late 1977, and its floating point was highly regarded. VAX's floating-point formats differed from MBF only in that it had the sign in the most significant bit.[35][36] However, seeking to market their chip to the broadest possible market, Kahan was asked to draw up specifications.[33] When rumours of Intel's new chip reached its competitors, they started a standardization effort, called IEEE 754, to prevent Intel from gaining too much ground. As an 8-bit exponent was not wide enough for some operations desired for double-precision numbers, e.g. to store the product of two 32-bit numbers,[1] Intel's proposal and a counter-proposal from DEC used 11 bits, like the time-tested 60-bit floating-point format of the CDC 6600 from 1965.[34][37][38] Kahan's proposal also provided for infinities, which are useful when dealing with division-by-zero conditions; not-a-number values, which are useful when dealing with invalid operations; denormal numbers, which help mitigate problems caused by underflow;[37][39][40] and a better balanced exponent bias, which could help avoid overflow and underflow when taking the reciprocal of a number.[41][42]

By the time QuickBASIC 4.00 was released,[when?] the IEEE 754 standard had become widely adopted—for example, it was incorporated into Intel's 387 coprocessor and every x86 processor from the 486 on. QuickBASIC versions 4.0 and 4.5 use IEEE 754 floating-point variables by default, but (at least in version 4.5) there is a command-line option /MBF for the IDE and the compiler that switches from IEEE to MBF floating-point numbers, to support earlier-written programs that rely on details of the MBF data formats. Visual Basic also uses the IEEE 754 format instead of MBF.

Technical details

MBF numbers consist of an 8-bit base-2 exponent, a sign bit (positive mantissa: s = 0; negative mantissa: s = 1) and a 23-,[43][8] 31-[8] or 55-bit[43] mantissa of the significand. There is always a 1-bit implied to the left of the explicit mantissa, and the radix point is located before this assumed bit. The exponent is encoded with a bias of 128[citation needed], so that exponents −127…−1[citation needed] are represented by x = 1…127 (01h…7Fh)[citation needed], exponents 0…127[citation needed] are represented by x = 128…255 (80h…FFh)[citation needed], with a special case for x = 0 (00h) representing the whole number being zero.

The MBF double-precision format provides less scale than the IEEE 754 format, and although the format itself provides almost one extra decimal digit of precision, in practice the stored values are less accurate because IEEE calculations use 80-bit intermediate results, and MBF doesn't.[1][3][43][44] Unlike IEEE floating point, MBF doesn't support denormal numbers, infinities or NaNs.[45]

MBF single-precision format (32 bits, "6-digit BASIC"):[43][8]

Exponent Sign Significand
8 bits,
bit 31–24
1 bit,
bit 23
23 bits,
bit 22–0
xxxxxxxx s mmmmmmmmmmmmmmmmmmmmmmm

MBF extended-precision format (40 bits, "9-digit BASIC"):[8]

Exponent Sign Significand
8 bits,
bit 39–32
1 bit,
bit 31
31 bits,
bit 30–0
xxxxxxxx s mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm

MBF double-precision format (64 bits):[43][1]

Exponent Sign Significand
8 bits,
bit 63–56
1 bit,
bit 55
55 bits,
bit 54–0
xxxxxxxx s mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm

Examples

32-bit format: 84h, 20h, 00h, 00h
40-bit format: 84h, 20h, 00h, 00h, 00h
  • "2":
32-bit format: 82h, 00h, 00h, 00h
40-bit format: 82h, 00h, 00h, 00h, 00h
32-bit format: 81h, 00h, 00h, 00h
40-bit format: 81h, 00h, 00h, 00h, 00h
32-bit format: 00h, 00h, 00h, 00h (or 00h, xxh, xxh, xxh)
40-bit format: 00h, 00h, 00h, 00h, 00h (or 00h, xxh, xxh, xxh, xxh)
32-bit format: 80h, 00h, 00h, 00h
40-bit format: 80h, 00h, 00h, 00h, 00h
32-bit format: 7Fh, 00h, 00h, 00h
40-bit format: 7Fh, 00h, 00h, 00h, 00h
32-bit format: 80h, 80h, 00h, 00h
40-bit format: 80h, 80h, 00h, 00h, 00h
32-bit format: 80h, 35h, 04h, F3h
40-bit format: 80h, 35h, 04h, F3h, 34h
32-bit format: 81h, 35h, 04h, F3h
40-bit format: 81h, 35h, 04h, F3h, 34h
32-bit format: 80h, 31h, 72h, 18h
40-bit format: 80h, 31h, 72h, 17h, F8h
32-bit format: 81h, 38h, AAh, 3Bh
40-bit format: 81h, 38h, AAh, 3Bh, 29h
32-bit format: 81h, 49h, 0Fh, DBh
40-bit format: 81h, 49h, 0Fh, DAh, A2h
32-bit format: 83h, 49h, 0Fh, DBh
40-bit format: 83h, 49h, 0Fh, DAh, A2h

See also

References

  1. 1.0 1.1 1.2 1.3 "IEEE vs. Microsoft Binary Format; Rounding Issues (Complete)". Microsoft Support. Microsoft. 2006-11-21. https://www.betaarchive.com/wiki/index.php/Microsoft_KB_Archive/35826#IEEE_vs._Microsoft_Binary_Format.3B_Rounding_Issues_.28Complete.29. 
  2. "(Complete) Tutorial to Understand IEEE Floating-Point Errors". Knowledge Base. Microsoft. 2005-08-16. https://www.betaarchive.com/wiki/index.php/Microsoft_KB_Archive/42980. 
  3. 3.0 3.1 "Convert pre-IEEE-754 C++ floating-point numbers to/from C#". 2010-04-21. https://stackoverflow.com/questions/2686298/convert-pre-ieee-754-c-floating-point-numbers-to-from-c-sharp.  (NB. The second reference could be mistaken to say that QB 4.0 could use MBF internally, but it only uses IEEE. It just has a few conversion functions to convert IEEE floating point numbers to strings containing MBF data, e.g. MKDMBF$ in addition to MKD$ which just copies the bytes of the IEEE value to a string.)
  4. "The MASM 6.1 documentation notes that 5.1 was the last MASM version to support MBF". http://people.sju.edu/~ggrevera/arch/references/MASM61PROGUIDE.pdf. 
  5. GW-BASIC User's Manual, Appendix D.3 USR Function Calls.
  6. BASIC Second edition (May 1982), IBM: Appendix C-15 (NB. This is the BASICA manual).
  7. "ROM Routes (Integer Math)". http://www.trs-80.com/trs80-zaps-internals.htm#rommath. 
  8. 8.00 8.01 8.02 8.03 8.04 8.05 8.06 8.07 8.08 8.09 8.10 8.11 8.12 8.13 8.14 8.15 8.16 8.17 "Create your own Version of Microsoft BASIC for 6502". pagetable.com. 2008-10-20. http://www.pagetable.com/?p=46. 
  9. 9.0 9.1 9.2 9.3 9.4 "Dawn of a revolution". Harvard Gazette (news.harvard.edu). 2013-09-20. http://news.harvard.edu/gazette/story/2013/09/dawn-of-a-revolution. 
  10. "An introduction to the scientific computing language Pascal-SC". Computers & Mathematics with Applications (Mathematics Research Center, University of Wisconsin-Madison, Madison, Wisconsin: Pergamon Journals Ltd) 14 (1): 53–69. 1987. doi:10.1016/0898-1221(87)90181-7.  (17 pages)
  11. "Floating-Point Numbers in Digital Computers". Department of Computer and Information Science, Polytechnic University. 2005-02-03. http://cis.poly.edu/~mleung/CS3734/s05/ch01/floatingPoints2.pdf. 
  12. Bill Gates: A Biography. 2014-08-26. ISBN 978-1-44083014-3. https://books.google.com/books?id=klV_BAAAQBAJ&pg=PA16. Retrieved 2016-05-30. 
  13. "The Math Package". 2014. http://altairbasic.org/math_ex.htm.  (NB. Altair BASIC 3.2 (4K Edition).)
  14. "Microsoft Altair BASIC legend talks about Linux, CPRM and that very frightening photo - A very rare interview with Monte Davidoff". 2001-05-11. https://www.theregister.co.uk/2001/05/11/microsoft_altair_basic_legend_talks/. 
  15. 15.0 15.1 "Raiders of the Lost Altair BASIC Source Code - They came, they saw … they disassembled". 2001-05-13. https://www.theregister.co.uk/2001/05/13/raiders_of_the_lost_altair/. 
  16. 16.0 16.1 "Quest for the Holy Source - Ian's trip to Harvard". 2000-05-08. http://www.rjh.org.uk/altair/ian.htm. 
  17. "Great people personally responsible for advancing the art of early computers". 2020-07-18. http://www.oldcomputers.net/important-computer-people.html. 
  18. "Basic 7.0 for Windows". http://comp.lang.basic.powerbasic.narkive.com/erBpXdwr/basic-7-0-for-windows#post4. 
  19. Radio Shack Hardware Manual: Level II BASIC Reference Manual (1 ed.). Fort Worth, Texas: Radio Shack. 1978. https://archive.org/details/Level_II_BASIC_Reference_Manual_1st_Ed._1978_Radio_Shack. Retrieved 2016-05-30.  [1]
  20. (PDF) Level II BASIC Reference Manual. Radio Shack. 1979. http://akhara.com/trs-80/docs/model1/Level%20II%20BASIC%20Reference%20Manual%20(1979)(Radio%20Shack)(pdf).zip. Retrieved 2016-06-02. 
  21. (PDF) BASIC-80 (MBASIC) Reference Manual. https://archive.org/details/BASIC-80_MBASIC_Reference_Manual. Retrieved 2016-05-30. 
  22. Microsoft FORTRAN-80 Version 3.4 Users Manual. November 1980. pp. 45, 55. http://www.textfiles.com/bitsavers/pdf/microsoft/cpm/Microsoft_FORTRAN-80_Ver3.4_Users_Manual_Nov80.pdf. Retrieved 2016-05-30. 
  23. Pätzold, Michael, ed (April 1993). "Zettelsammlung MS-DOS und AT" (in de). Gruppe Datenverarbeitung am MPI für Strömungsforschung Göttingen, Max-Planck-Institut. http://ftp.gwdg.de/pub/mpsf/pc_doc/dosbesch.ps. 
  24. "Tandy 200 Multiplan Manual". http://www.classiccmp.org/dunfield/kyocera/t200mpln.pdf. 
  25. Microsoft C Pcode Specifications, page 13. (NB. Multiplan wasn't compiled to machine code, but to a kind of byte-code which was run by an interpreter, in order to make Multiplan portable across the widely varying hardware of the time. This byte-code distinguished between the machine-specific floating point format to calculate on, and an external (standard) format, which was binary-coded decimal (BCD). The PACK and UNPACK instructions converted between the two.)
  26. Microsoft COBOL-80. 1978. pp. 26, 32. http://www.textfiles.com/bitsavers/pdf/microsoft/cpm/Microsoft_COBOL-80_1978.pdf. Retrieved 2016-05-30. 
  27. "QWK Mail Packet File Layout" (TXT). http://www.textfiles.com/programming/qwk.txt. 
  28. "CSI Millennium (CSIM) format with CSI Y2K extensions" (TXT). Boca Raton, Florida: Commodity Systems, Inc.. 1998-11-17. http://www.csidata.com/patch/csim.txt. "[…] This document describes the abandoned CompuTrac data format, which until recently was actively used by Equis' MetaStock charting software. […]" 
  29. "Converting Microsoft Binary Format to IEEE format Using VB 6". 2016-05-04. https://forums.codeguru.com/showthread.php?21573-Converting-Microsoft-Binary-Format-to-iEEE-format-Using-VB-6. 
  30. JerMyster (2003-07-02). "Help !Anybody know how to convert old M/S MBF value from Qbasic to VB6". Tek-Tips. http://www.tek-tips.com/viewthread.cfm?qid=592713. 
  31. GL88. "Reading Binary Format (QBasic) with C#". Social.msdn.microsoft.com. https://social.msdn.microsoft.com/Forums/vstudio/en-US/64a201b5-852d-41df-9abe-2ad2645cc937/reading-binary-format-qbasic-with-c?forum=netfxbcl. 
  32. "Rmetrics - Reading MetaStock data format in R". R.789695.n4.nabble.com. 2013-09-30. http://r.789695.n4.nabble.com/Reading-MetaStock-data-format-in-R-td4677240.html. 
  33. 33.0 33.1 "Intel and Floating-Point - Updating One of the Industry's Most Successful Standards - The Technology Vision for the Floating-Point Standard". Intel. 2016. http://www.intel.com/content/dam/www/public/us/en/documents/case-studies/floating-point-case-study.pdf.  (11 pages)
  34. 34.0 34.1 "An Interview with the Old Man of Floating-Point". cs.berkeley.edu. 1998-02-20. https://www.cs.berkeley.edu/~wkahan/ieee754status/754story.html. 
  35. "VAX Floating Point Numbers". http://nssdc.gsfc.nasa.gov/nssdc/formats/VAXFloatingPoint.htm.  (NB. The VAX-11/780 did not implement the "G" format yet. Although this is not directly apparent from the tables because the structures have been cut up in two-byte words, the byte order is actually the same as on modern CPUs. There isn't enough room in the exponent range for NaNs, Infinity, infinities or denormals.)
  36. "VAX11 780". http://www.ece.cmu.edu/~ece447/s15/lib/exe/fetch.php?media=vax_hwhbk_1979.pdf. 
  37. 37.0 37.1 "IEEE 754: An Interview with William Kahan". http://www.dr-chuck.com/dr-chuck/papers/columns/r3114.pdf. 
  38. Design of a Computer: The Control Data 6600 (1 ed.). Glenview, Illinois: Scott, Foresman and Company. 1970. http://ygdes.com/CDC/DesignOfAComputer_CDC6600.pdf. Retrieved 2016-06-02.  (1+13+181+2+2 pages)
  39. "Why do we need a floating-point arithmetic standard?". https://www.cs.berkeley.edu/~wkahan/ieee754status/why-ieee.pdf. 
  40. "How Java's Floating-Point Hurts Everyone Everywhere". https://www.cs.berkeley.edu/~wkahan/JAVAhurt.pdf. 
  41. Numerical Analysis and Parallel Processing: Lectures given at The Lancaster …. 2013-12-21. ISBN 978-3-66239812-8. https://books.google.com/books?id=sUD8CAAAQBAJ&pg=PA171. Retrieved 2016-05-30. 
  42. "Names for Standardized Floating-Point Formats". https://www.cs.berkeley.edu/~wkahan/ieee754status/Names.pdf. 
  43. 43.0 43.1 43.2 43.3 43.4 43.5 Borland staff (1998-07-02). "Converting between Microsoft Binary and IEEE formats". Technical Information Database. Embarcadero USA / Inprise (originally: Borland). https://community.embarcadero.com/index.php/article/technical-articles/162-programming/14799-converting-between-microsoft-binary-and-ieee-forma. "[…] _fmsbintoieee(float *src4, float *dest4) […] MS Binary Format […] byte order => m3 | m2 | m1 | exponent […] m1 is most significant byte => sbbb|bbbb […] m3 is the least significant byte […] m = mantissa byte […] s = sign bit […] b = bit […] MBF is bias 128 and IEEE is bias 127. […] MBF places the decimal point before the assumed bit, while IEEE places the decimal point after the assumed bit. […] ieee_exp = msbin[3] - 2; /* actually, msbin[3]-1-128+127 */ […] _dmsbintoieee(double *src8, double *dest8) […] MS Binary Format […] byte order => m7 | m6 | m5 | m4 | m3 | m2 | m1 | exponent […] m1 is most significant byte => smmm|mmmm […] m7 is the least significant byte […] MBF is bias 128 and IEEE is bias 1023. […] MBF places the decimal point before the assumed bit, while IEEE places the decimal point after the assumed bit. […] ieee_exp = msbin[7] - 128 - 1 + 1023; […]" 
  44. "Google Groups". https://groups.google.com/forum/#!topic/comp.os.msdos.programmer/mDyRI1wolAc. 
  45. "Understanding single precision MBF". boyet.com. 2018-11-03. http://www.boyet.com/Articles/MBFSinglePrecision.html. "[…] IEEE 754 Single format […] The exponent is biased by 127. There is an assumed 1 bit before the radix point (so the assumed mantissa is 1.ffff… where f's are the fraction bits) […] Microsoft Binary Format (single precision) […] The exponent is biased by 128. There is an assumed 1 bit after the radix point (so the assumed mantissa is 0.1ffff… where f's are the fraction bits) […] the IEEE mantissa is twice the MBF mantissa. […] to convert from MBF to IEEE single […] subtract 2 from the exponent (one for the bias change, one for the mantissa factor), and then rearrange the sign and exponent bits. The fraction does not change. To convert from IEEE single to MBF, […] add 2 to the exponent (one for the bias change, one for the mantissa factor), and then rearrange the sign and exponent bits. The fraction does not change. […]" 
  46. 46.0 46.1 46.2 46.3 46.4 46.5 46.6 46.7 Steil, Michael, ed (2008-10-20). "msbasic/float.s". MIST64. https://github.com/mist64/msbasic/blob/master/float.s.  [2] (NB. Commented 6502 disassembly listings, merged from several versions of Microsoft BASIC for 6502 between 1977 and 1982 to recreate byte-exact copies of the original ROMs for 10 different machines from different vendors.)
  47. 47.0 47.1 47.2 Steil, Michael, ed (2008-10-20). "msbasic/trig.s". MIST64. https://github.com/mist64/msbasic/blob/master/trig.s.  [3] (NB. Commented 6502 disassembly listings, merged from several versions of Microsoft BASIC for 6502 between 1977 and 1982 to recreate byte-exact copies of the original ROMs for 10 different machines from different vendors.)

External links

  • Microsoft provides a dynamic link library for 16-bit Visual Basic containing functions to convert between MBF data and IEEE 754.
    • This library wraps the MBF conversion functions in the 16-bit Visual C(++) CRT.
    • These conversion functions will round an IEEE double-precision number like ¾ ⋅ 2−128 to zero rather than to 2−128.
    • They don't support denormals at all: the IEEE or MBF single-precision number 2−128 will be converted to zero, even though it is representable in either format.
    • This library is only intended for use with Visual Basic; C(++) programs are expected to call the CRT functions directly.