Spreadsheet: 780821d1652801309-real-numbers-should-sum-to-exactly-0-but-dont-binary-arith-anomaly
Sheet: original

 |  |  | diff A | diff B | diff C
-2646462000000000 |  |  |  |  |  |  | #colD
457566100000000 |  |  |  |  |  |  | #colD<>0
4126900000000 |  |  |  |  |  |  | #colE<>0
927500000000 |  |  |  |  |  |  | #colF<>0
568600000000
4956400000000
-2295900000000
2295900000000
3619800000000
-1088900000000
1088900000000
4567400000000
-293300000000
1012000000000
15000000000
2486200000000
2781000000000
15000000000
2285400000000
2781000000000
5284400000000.001
-2211100000000
1501700000000
2941200000000
4290800000000
912600000000
1454100000000
10824900000000
7871900000000.001
6192400000000
4769400000000
4458500000000
271500000000
846700000000
5505800000000
119900000000
499799999999.9999
6590599999999.999
2028000000000
3245900000000
15000000000
815000000000
2781000000000
4545700000000
1769400000000
2381800000000
6574299999999.999
466599999999.9999
678500000000
4951600000000
1264700000000
1948400000000
25000000000
-954400000000
975000000000
7235200000000
100000000000
2201200000000
6843000000000
971600000000
2082100000000
13526400000000
2808900000000
2100500000000
7572900000000
2291400000000
2347200000000
11427600000000
4245200000000
2730000000000
9303100000000
-396800000000
1444400000000
15000000000
248200000000
2781000000000
6586200000000
1405100000000
2223800000000
6401700000000
22100000000
914300000000.0001
5588600000000
-37200000000
659300000000.0001
5769400000000.001
1699200000000
1867400000000
5511100000000
3145200000000
2723500000000
6129299999999.999
808100000000
500300000000
4751800000000
939700000000
1838900000000
3489700000000
-74900000000
1573300000000
4747900000000
1196600000000
2556600000000
7887000000000
945100000000
2078000000000
3103800000000
-263700000000
1573300000000
3924700000000
177100000000
1602500000000
6298700000000
133700000000
1563500000000
6335300000000
-159000000000
2055900000000
5040300000000
672099999999.9999
2115600000000
4924400000000
1166200000000
2255400000000
5630700000000.001
959900000000
1825500000000
3988800000000
727800000000
1602500000000
762000000000
-4280300000000
-4738800000000
1413900000000
2600000000
901200000000
-1402200000000
-1402200000000
4921400000000
2923400000000
2033500000000
5047700000000
340400000000
2246900000000
5080200000000
-372100000000
1600600000000
5499100000000
-251500000000
1734000000000
3945000000000
-1176500000000
1723400000000
4961200000000
2377400000000
5670000000000
4961200000000
1475700000000
1291200000000
1291200000000
6278600000000
1248300000000
2400900000000
4941800000000
238600000000
1385100000000
9418100000000
573300000000
2676200000000
4678000000000
428400000000.0001
1600600000000
4717700000000
286500000000
250000000000
517500000000
5368099999999.999
943900000000
1549400000000
3834600000000
1678000000000
285000000000
1405500000000
5044200000000
1927000000000
1830100000000
4620700000000
-297200000000
927000000000
5045800000000
-278300000000
677099999999.9999
4698600000000
-115700000000
1925900000000
9741000000000
-351900000000
1595600000000
4591300000000
-345600000000
1753500000000
15000000000
-76300000000
2781000000000
4899400000000
1948800000000
1600000000000
8322800000000
185600000000
2402200000000
6088700000000
282300000000
862500000000
3924000000000
-385100000000
1948400000000
4342600000000
-518300000000
1616800000000
4772000000000
615400000000
2922600000000
4033200000000
-67900000000
1802800000000
6058700000000
738700000000
1670400000000
4709000000000
-874400000000
2181200000000
7227300000000
2028700000000
2267500000000
4260300000000
721000000000
1876600000000
8984400000000
-298400000000
1265000000000
5881900000000.001
-59700000000
2188500000000
3095000000000
9604900000000
2521600000000
2472000000000
9856500000000
865200000000
3460800000000
5358000000000
-63300000000
1762800000000
5201300000000
468500000000
2063900000000
5052900000000
437400000000
407900000000
1282200000000
-5875800000000
-3032600000000
-6618600000000
-837300000000
-1622300000000
5535400000000
471400000000
335200000000.0001
5298900000000
-708400000000
708400000000
4772200000000
-222000000000
1480100000000
15000000000
-1374200000000
2781000000000
4578600000000
1820800000000
1360000000000
2753300000000
7849100000000
-98100000000
1357000000000
5905200000000
791100000000
985600000000
7294299999999.999
2588600000000
3501600000000
5984500000000
150200000000
2359900000000
5657400000000
48099999999.99999
2042600000000
3816700000000
1571600000000
2063900000000
6956500000000
-1311300000000
2410200000000
4639600000000
30500000000
958300000000
6892800000000
331300000000
3166000000000
25000000000
-979400000000
1000000000000
25000000000
-1000000000000
1000000000000
25000000000
-979400000000
1000000000000
6961900000000.001
460000000000
874000000000
4233000000000
526300000000
1626800000000
1175500000000
-4299400000000
-4021900000000
-5247800000000
-2400000000
-1873900000000
-2003100000000
6361300000000
260900000000
609500000000
4751600000000
496200000000
414000000000
4691500000000
-293300000000
293300000000
5226700000000
2563100000000
2080300000000
9211100000000
1747100000000
1492100000000
6605500000000
2989300000000
3204900000000
5459600000000
-416500000000
1480100000000
6984400000000.001
-410200000000.0001
6758900000000
6984400000000.001
891500000000
921200000000
921200000000
8077700000000
894100000000
1238200000000
2951000000000
4636400000000
-2514300000000
1730400000000
4989200000000
-3559600000000
2540600000000
5369100000000
316500000000
922400000000
4337700000000
675300000000
2073000000000
7242200000000
-493700000000
2485400000000
7449000000000
2600000000000
3840800000000
9162400000000
1511500000000
2655100000000
3466100000000
1969100000000
1534400000000
6583400000000
3340700000000
3693100000000
7722000000000
1694000000000
1213700000000
7287700000000
1848800000000
1931300000000
8513200000000.001
363900000000
3287200000000
5684600000000
547800000000
2912400000000
12253800000000
1984300000000
2039300000000
5013000000000
2130400000000
2206700000000
6182100000000
-493300000000
244200000000
3771200000000
9200700000000
2403700000000
2657400000000
8457700000000
3540400000000
1342100000000
6483900000000
732700000000
2872400000000
5465700000000.001
904300000000.0001
1700500000000
9780100000000
2196400000000
2826300000000
4639900000000
2847600000000
1772700000000
5293200000000.001
257300000000
1823800000000
4895800000000
799500000000
1969700000000
7723600000000
-228800000000
-680000000000
1466300000000
7145400000000
1042500000000
3054800000000
4345400000000
244800000000
1793400000000
6725300000000
1327800000000
2766000000000
3139000000000
793700000000
1351100000000
6706900000000.001
1310300000000
1973500000000
5534000000000
1226800000000
2042600000000
3389900000000
565200000000
1573300000000
5166400000000
2439000000000
1284900000000
5131500000000
-276400000000
282600000000
3370300000000
5215200000000
53700000000
632500000000
7889700000000
2640000000000
3263000000000
3531600000000
1941500000000
429500000000
1444700000000
4244900000000
462299999999.9999
2680900000000
7992400000000
2450900000000
2216600000000
5361500000000
775699999999.9999
1539900000000
3722200000000
-1251100000000
1251100000000
4694800000000
2155000000000
2316200000000
4370700000000
1192000000000
1602500000000
7734100000000
1245200000000
2817100000000
4488800000000
357900000000
1360000000000
2200100000000
3753500000000
2120800000000
1021300000000
3606800000000
-317200000000
242300000000
1360000000000
1360000000000
1984800000000
4157000000000
-767000000000
2163300000000
4496300000000
1950500000000
2403700000000
5412700000000
812700000000
1707000000000
7668400000000
-516000000000
838500000000
4477400000000
1683700000000
2493400000000
4468200000000
1168800000000
2033500000000
25000000000
1464600000000
1000000000000
25000000000
-979400000000
1000000000000
-15000000000
-24600000000
-309000000000
-309000000000
15000000000
-645400000000.0001
2781000000000
5375800000000
-194500000000
2600100000000
4607100000000
1739300000000
-4514600000000
4607100000000
-283700000000
283700000000
283700000000
5530800000000
442100000000
728300000000
3499000000000
366500000000
575000000000
5240400000000
200500000000
922400000000
5610599999999.999
1056000000000
3485200000000
5652100000000
1090400000000
513200000000
3848300000000
1138500000000
1821900000000
3504700000000
735400000000.0001
1723400000000
6313400000000
671100000000
2723500000000
4676400000000
-119900000000
1611000000000
5892000000000
699000000000
1600600000000
4433900000000
16100000000
2297900000000
5875000000000
2106700000000
2014700000000
3768800000000
-573700000000
-11146600000000
1891500000000
4203900000000
1133300000000
1930100000000
6099500000000
-305000000000
1702600000000
4604400000000
-786000000000
1511000000000
4073900000000
1806400000000
1711700000000
4400900000000
-285200000000
2604300000000
5989800000000
1516100000000
2635300000000
6407700000000
427000000000
821300000000
6936600000000
583900000000
821300000000
4667100000000
152300000000
628700000000
5984500000000
713300000000
887000000000
3605500000000
1284300000000
1288800000000
3519900000000
-61700000000
693000000000
6893900000000
-4273400000000
4133600000000
7692100000000
-1396600000000
1405300000000
5618800000000
466000000000
824200000000
3458600000000
1643000000000
1532000000000
3554500000000
496300000000
1072400000000
5374000000000
713400000000
1284900000000
4575100000000
275300000000
2338000000000
4816100000000
298500000000
1603500000000
4083200000000
-1173600000000
2003100000000
5475100000000
-856300000000
1770300000000
4948600000000
270700000000
1763000000000
7505800000000
-731900000000
3769100000000
5132900000000
-4100000000
2403700000000
3861400000000
92100000000.00002
5979000000000
1650700000000
1018700000000
3485500000000
827600000000
1914900000000
3400900000000
88500000000
1327700000000
5138700000000
1446900000000
1308100000000
5489299999999.999
415800000000
2655400000000
4720100000000
1241800000000
784900000000
4666900000000
278700000000
2683000000000
5044000000000
167200000000
1738100000000
3556800000000
607900000000
1376600000000
6630500000000
-295000000000
2223000000000
7810700000000.001
1669500000000
2667700000000
5242400000000
3066700000000
2859600000000
6038400000000
-1812500000000
2408000000000
4902800000000
828100000000
2726500000000
5590700000000.001
858100000000
1762800000000
4343000000000
1350200000000
2338000000000
6175500000000
245700000000
2527700000000
3716600000000
-1251100000000
1251100000000
2925600000000
6149200000000
1173700000000
5967000000000
729100000000
499799999999.9999
3476600000000
128300000000
2359900000000
4974400000000
1219800000000
2687000000000
6188099999999.999
-93100000000
690000000000
7383700000000
1935800000000
909500000000
5503400000000
139500000000
1158800000000
5147100000000
1735300000000
2170300000000
5844100000000
592800000000
2054100000000
6694500000000
910000000000
641200000000
5466500000000
33100000000
402500000000
6835200000000
2208300000000
3100400000000
15000000000
331400000000
2781000000000
15000000000
301300000000
2781000000000
15000000000
2288600000000
2781000000000
15000000000
-1241800000000
2781000000000
2458700000000
-301300000000
1297800000000
3837100000000
3150500000000
1723400000000
3868400000000
852200000000
1530600000000
4016300000000
1847500000000
1721900000000
4076000000000
1392400000000
1810700000000
3417400000000
1430200000000
1091700000000
3755400000000
1280500000000
1207200000000
3817900000000
-62200000000
1207200000000
3646900000000
953500000000
1339300000000
4339400000000
2146000000000
1454100000000
3713400000000
1197400000000
1339300000000
4492700000000
-450100000000
2025800000000
3465500000000
-215500000000
1147900000000
4426300000000
1477600000000
2184600000000
3979300000000
1168300000000
1452300000000
3958300000000
2744600000000
1752000000000
4859800000000
2229300000000
1943600000000
4775100000000
3964000000000
1943600000000
4952400000000
4837800000000
1483200000000
4174500000000
1258200000000
1721100000000
681700000000
1750000000000
3096200000000
1360000000000
4462600000000
-1188000000000
2224800000000
4308300000000
3190800000000
2224800000000
4305200000000
888100000000
2224800000000
5164800000000
-3749400000000
9708200000000
480300000000
4306100000000
2224800000000
5498500000000
1690500000000
3137700000000
4797600000000
1940700000000
1913200000000
4005200000000
411200000000
918300000000
4154600000000
1394000000000
1147900000000
4537800000000
2826300000000
1721900000000
4310800000000
2342400000000
1377500000000
5735500000000
1298800000000
1760600000000
2386800000000
724400000000
1505200000000
15000000000
1050100000000
2781000000000
15000000000
2640700000000
2781000000000
7839600000000
2712600000000
3112500000000
7255200000000
2677400000000
321900000000
1939500000000
7087000000000
743700000000
985600000000
7314299999999.999
917300000000
1029300000000
7578700000000
49200000000
1200800000000
5084600000000
1845200000000
2710700000000
4545400000000
-1242700000000
2720400000000
3847900000000
-2093100000000
2093100000000
440000000000
121000000000
450000000000
151300000000
440000000000
121000000000
340000000000
121000000000
683000000000
121000000000
0 | -0.5878497688627249