{"data":{"status":"fail","conversions":[{"sample":"9007199254740993","target":"float64","verdict":"lossy","rule":"beyond-2^53","detail":"nearest binary64 prints as 9007199254740992","converted":"9007199254740992"},{"sample":"9007199254740993","target":"int64","verdict":"exact","rule":"exact","detail":"value is preserved","converted":"9007199254740993"},{"sample":"9007199254740993","target":"numeric(5,2)","verdict":"overflow","rule":"numeric(5,2)-precision","detail":"16 integer digit(s) exceed precision - scale = 3 (PostgreSQL: numeric field overflow)","converted":null},{"sample":"9007199254740993","target":"excel-number","verdict":"lossy","rule":"excel-15-digits","detail":"16 significant digits; Excel keeps 15 and rounds the rest down to zero","converted":"9007199254740990"},{"sample":"\"007\"","target":"float64","verdict":"lossy","rule":"leading-zeros","detail":"a float cannot keep the leading zeros of an identifier","converted":"7"},{"sample":"\"007\"","target":"int64","verdict":"lossy","rule":"leading-zeros","detail":"an integer column cannot keep the leading zeros of an identifier","converted":"7"},{"sample":"\"007\"","target":"numeric(5,2)","verdict":"lossy","rule":"leading-zeros","detail":"a decimal column cannot keep the leading zeros of an identifier","converted":"7"},{"sample":"\"007\"","target":"excel-number","verdict":"lossy","rule":"leading-zeros","detail":"Excel removes leading zeros from numerical text","converted":"7"},{"sample":"0.1","target":"float64","verdict":"exact","rule":"exact","detail":"value is preserved","converted":"0.1"},{"sample":"0.1","target":"int64","verdict":"lossy","rule":"fraction-truncated","detail":"fractional part dropped (0.1 -> 0)","converted":"0"},{"sample":"0.1","target":"numeric(5,2)","verdict":"exact","rule":"exact","detail":"value is preserved","converted":"0.10"},{"sample":"0.1","target":"excel-number","verdict":"exact","rule":"exact","detail":"opens as text","converted":"0.1"},{"sample":"1e400","target":"float64","verdict":"overflow","rule":"binary64-range","detail":"exceeds the largest binary64 value (about 1.7976931348623157e308); JSON.parse returns Infinity","converted":null},{"sample":"1e400","target":"int64","verdict":"overflow","rule":"int64-range","detail":"outside the int64 range","converted":null},{"sample":"1e400","target":"numeric(5,2)","verdict":"overflow","rule":"numeric(5,2)-precision","detail":"401 integer digit(s) exceed precision - scale = 3 (PostgreSQL: numeric field overflow)","converted":null},{"sample":"1e400","target":"excel-number","verdict":"overflow","rule":"excel-range","detail":"beyond the largest Excel number (9.99999999999999E+307)","converted":null}],"mangling":[{"index":0,"before":"00123456789012345678","after":"1.23457E+17","changed":true,"rules":[{"rule":"scientific-notation","detail":"digits collapsed into E notation, which keeps at most 15 significant digits in Excel"}]}],"summary":{"exact":4,"lossy":7,"overflow":5,"invalid":0,"changedPairs":1},"witnesses":[{"ruleId":"beyond-2^53","detail":"9007199254740993 -> float64: nearest binary64 prints as 9007199254740992","path":"/samples/0","index":0,"expected":"9007199254740993","actual":"9007199254740992"},{"ruleId":"numeric(5,2)-precision","detail":"9007199254740993 -> numeric(5,2): 16 integer digit(s) exceed precision - scale = 3 (PostgreSQL: numeric field overflow)","path":"/samples/0","index":0,"expected":"9007199254740993","actual":null},{"ruleId":"excel-15-digits","detail":"9007199254740993 -> excel-number: 16 significant digits; Excel keeps 15 and rounds the rest down to zero","path":"/samples/0","index":0,"expected":"9007199254740993","actual":"9007199254740990"},{"ruleId":"leading-zeros","detail":"\"007\" -> float64: a float cannot keep the leading zeros of an identifier","path":"/samples/1","index":1,"expected":"\"007\"","actual":"7"},{"ruleId":"leading-zeros","detail":"\"007\" -> int64: an integer column cannot keep the leading zeros of an identifier","path":"/samples/1","index":1,"expected":"\"007\"","actual":"7"},{"ruleId":"leading-zeros","detail":"\"007\" -> numeric(5,2): a decimal column cannot keep the leading zeros of an identifier","path":"/samples/1","index":1,"expected":"\"007\"","actual":"7"},{"ruleId":"leading-zeros","detail":"\"007\" -> excel-number: Excel removes leading zeros from numerical text","path":"/samples/1","index":1,"expected":"\"007\"","actual":"7"},{"ruleId":"fraction-truncated","detail":"0.1 -> int64: fractional part dropped (0.1 -> 0)","path":"/samples/2","index":2,"expected":"0.1","actual":"0"},{"ruleId":"binary64-range","detail":"1e400 -> float64: exceeds the largest binary64 value (about 1.7976931348623157e308); JSON.parse returns Infinity","path":"/samples/3","index":3,"expected":"1e400","actual":null},{"ruleId":"int64-range","detail":"1e400 -> int64: outside the int64 range","path":"/samples/3","index":3,"expected":"1e400","actual":null},{"ruleId":"numeric(5,2)-precision","detail":"1e400 -> numeric(5,2): 401 integer digit(s) exceed precision - scale = 3 (PostgreSQL: numeric field overflow)","path":"/samples/3","index":3,"expected":"1e400","actual":null},{"ruleId":"excel-range","detail":"1e400 -> excel-number: beyond the largest Excel number (9.99999999999999E+307)","path":"/samples/3","index":3,"expected":"1e400","actual":null},{"ruleId":"scientific-notation","detail":"digits collapsed into E notation, which keeps at most 15 significant digits in Excel","path":"/pairs/0","index":0,"expected":"00123456789012345678","actual":"1.23457E+17"}],"versions":{"json-schema-engine":"JSON Schema 2020-12 interpreter (https://json-schema.org/draft/2020-12/schema), no code generation; validated against JSON-Schema-Test-Suite tests/draft2020-12 at commit 245a45abc90190c0bff04d97e6d2b541b4bb9f12","json-pointer":"RFC 6901 (https://www.rfc-editor.org/rfc/rfc6901)","ieee754-binary64":"RFC 8259 section 6, interoperable integers +-(2^53 - 1) (https://www.rfc-editor.org/rfc/rfc8259#section-6), 2026-11-04","postgresql":"numeric types, https://www.postgresql.org/docs/current/datatype-numeric.html, 2026-11-04","parquet":"https://github.com/apache/parquet-format/blob/master/LogicalTypes.md, 2026-11-04","arrow":"https://github.com/apache/arrow/blob/main/format/Schema.fbs (Decimal precision derived from bitWidth), 2026-11-04","excel":"https://learn.microsoft.com/en-us/office/troubleshoot/excel/long-numbers-incorrectly-in-excel and https://support.microsoft.com/en-us/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3 (number range), 2026-11-04","pandas":"https://pandas.pydata.org/docs/user_guide/integer_na.html, 2026-11-04"},"limits":["Excel date and formula coercion is a pattern model of the documented automatic conversions; locale-specific date orders are not modelled.","Numeric rounding mode for Arrow and Parquet writers is library specific; only the need to round is reported."],"deterministic":true},"_provenance":{"version":"writerslogic-provenance/1","issuer":"did:web:agents.writerslogic.com","verify":{"endpoint":"POST /api/v1/verify-provenance","did":"did:web:agents.writerslogic.com"},"manifest":{"format":"application/json","instance_id":"xmp:iid:37cb2441-4a1d-4b4d-88e8-196f57c9bf78","claim_generator_info":[{"name":"WritersLogic x402 Agent Hub","version":"2.0.0"}],"title":"Does this value survive conversion to another numeric or spreadsheet type? Range, precision, leading zeros, E notation","assertions":[{"label":"c2pa.actions.v2","data":{"actions":[{"action":"c2pa.created","when":"2026-11-06T01:30:22.536Z","softwareAgent":{"name":"writerslogic-agent-hub/lossy-conversion","version":"2.0.0"},"digitalSourceType":"http://cv.iptc.org/newscodes/digitalsourcetype/algorithmicMedia","parameters":{"endpoint":"POST /api/v1/lossy-conversion","inputDigest":{"alg":"sha256","hash":"b80d5f66eeac9c75a118caa17012ca892de2431c63a62b1caf9a1df542e90e22","canonicalization":"JCS"}}}]}},{"label":"c2pa.hash.data","data":{"alg":"sha256","hash":"5dd62c65c4e08213a680db1081995a44fb64b0bab708a371ce720ce1117199a1","name":"jcs-canonical-json(data)"}}]},"credential":{"@context":["https://www.w3.org/ns/credentials/v2"],"id":"urn:uuid:10ded3c5-382c-47b5-bbfb-5fc7ea6673d4","type":["VerifiableCredential","AgentOutputCredential"],"issuer":"did:web:agents.writerslogic.com","validFrom":"2026-11-06T01:30:22.536Z","credentialSubject":{"id":"urn:sha256:5dd62c65c4e08213a680db1081995a44fb64b0bab708a371ce720ce1117199a1","agent":"lossy-conversion","endpoint":"POST /api/v1/lossy-conversion","outputDigest":{"alg":"sha256","value":"5dd62c65c4e08213a680db1081995a44fb64b0bab708a371ce720ce1117199a1","canonicalization":"JCS"},"inputDigest":{"alg":"sha256","value":"b80d5f66eeac9c75a118caa17012ca892de2431c63a62b1caf9a1df542e90e22","canonicalization":"JCS"},"manifestDigest":{"alg":"sha256","value":"8a29b46e23fd995c72347879335b969c8477027c9c569c3aaed34683123efb5f","canonicalization":"JCS"},"ingredients":[],"payment":{"scheme":"api-key","network":"eip155:8453","payer":"sample"}},"proof":{"type":"DataIntegrityProof","cryptosuite":"eddsa-jcs-2022","created":"2026-11-06T01:30:22.536Z","verificationMethod":"did:web:agents.writerslogic.com#key-1","proofPurpose":"assertionMethod","proofValue":"z3x1CmWkEUWDrsQERBU5Nrb2eDwepAWNvDUtt654y1T14YUqWQX24x6xMYiPe68JtUsf25EBHYSBP1Kp49BR8rera"}},"ethSignature":{"type":"EIP-191","signer":"did:pkh:eip155:8453:0x3DBd42560cA7a7E448A2c7DfC9E785526189411f","address":"0x3DBd42560cA7a7E448A2c7DfC9E785526189411f","message":"writerslogic-provenance:0d1b16858f3978c64eaa6b62f8c58c1f56d6187f6b573da4514a85ee21d418c5","signature":"0xd972408eb8c2b48f5f9b407d9947206dc2e83b4b254f88b1295f1424254405b9023100ef1c23535413d38ef30fa938f749475b4ba976f3ff86f40c6b2dce700a1c"}}}