[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_107":108,"_109":110},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","oromaskevic23","name","imperial-nca-runtime-recovery","path","real10_rfq_file_qa.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":53,"_54":-5,"_55":56,"_57":58,"_59":32,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_13":44},"permalink","https://www.val.town/x/oromaskevic23/imperial-nca-runtime-recovery/code/real10_rfq_file_qa.ts","extension","id","a9f34205-7da3-4507-945b-7337b41dfe5b","fileId","736adaaa-af95-11f1-b6c4-1607ee4eb77e","parentId","branchId","fe58c05b-d08c-4472-a9bd-606aa5280a38","branchVersion",1285,"latest",true,"createdAt",["D",1789319418079],"version",2,"fileType","script","content","import {sqlite} from \"https://esm.town/v/std/sqlite/main.ts\";\nimport {callLiveModel,LIVE_MODEL} from \"./nca_live_model_router.ts\";\nimport {sha} from \"./real10_revenue_worker.ts\";\nconst source=\"{\\\"file_pipeline\\\":\\\"// IMPERIAL Core — Alexander Romaskevich / RomaskevicH. Internal prototype, not a client delivery.\\\\nimport {getDocumentProxy} from \\\\\\\"npm:unpdf@1.8.1\\\\\\\";\\\\nimport * as XLSX from \\\\\\\"https://cdn.sheetjs.com/xlsx-0.20.3/package/xlsx.mjs\\\\\\\";\\\\nimport {buildQuote,type CatalogueRow,type PriceRow} from \\\\\\\"./core.ts\\\\\\\";\\\\nexport const FORMAT=\\\\\\\"IMPERIAL RFQ DEMO V1\\\\\\\",COLUMNS=\\\\\\\"CODE | QUANTITY | UNIT | DESCRIPTION\\\\\\\";\\\\nexport type SourceRow={page:number;line:number;raw:string};\\\\nconst HEADER_SET=new Set([FORMAT,COLUMNS]);\\\\nexport async function hashBytes(bytes:Uint8Array){return [...new Uint8Array(await crypto.subtle.digest(\\\\\\\"SHA-256\\\\\\\",bytes))].map(x=>x.toString(16).padStart(2,\\\\\\\"0\\\\\\\")).join(\\\\\\\"\\\\\\\");}\\\\nexport async function readPdfRows(bytes:Uint8Array){\\\\n if(bytes.byteLength>2*1024*1024||bytes.byteLength<5)throw Error(\\\\\\\"PDF_SIZE_LIMIT\\\\\\\");\\\\n if(new TextDecoder().decode(bytes.slice(0,5))!==\\\\\\\"%PDF-\\\\\\\")throw Error(\\\\\\\"PDF_REQUIRED\\\\\\\");\\\\n const pdf=await getDocumentProxy(bytes.slice(),{isEvalSupported:false,disableFontFace:true,useSystemFonts:false});\\\\n const rows:SourceRow[]=[],warnings:any[]=[];let characters=0;\\\\n try{\\\\n if(pdf.numPages>5)throw Error(\\\\\\\"PDF_PAGE_LIMIT\\\\\\\");\\\\n for(let p=1;p<=pdf.numPages;p++){\\\\n const page=await pdf.getPage(p),content=await page.getTextContent();\\\\n if(content.items.length>10000)throw Error(\\\\\\\"PDF_ITEM_LIMIT\\\\\\\");\\\\n let current=\\\\\\\"\\\\\\\",lastY:number|null=null,line=0;\\\\n const flush=()=>{if(current.trim()){rows.push({page:p,line:++line,raw:current.trim()});current=\\\\\\\"\\\\\\\";}};\\\\n for(const item of content.items as any[]){\\\\n if(typeof item.str!==\\\\\\\"string\\\\\\\")continue;\\\\n characters+=item.str.length;if(characters>20000)throw Error(\\\\\\\"PDF_TEXT_LIMIT\\\\\\\");\\\\n const y=Number(item.transform?.[5]??0);\\\\n if(item.str.trim()&&(!Array.isArray(item.transform)||Math.abs(item.transform[1])>0.01||Math.abs(item.transform[2])>0.01||item.transform[0]<=0||item.transform[3]<=0||(lastY!==null&&y>lastY+2)))warnings.push({page:p,line:line+1,raw:item.str.slice(0,200),status:\\\\\\\"REVIEW\\\\\\\",reason:\\\\\\\"PDF_READING_ORDER_OR_ROTATION_ANOMALY\\\\\\\"});\\\\n if(lastY!==null&&Math.abs(y-lastY)>2)flush();\\\\n current+=(current&&!current.endsWith(\\\\\\\" \\\\\\\")?\\\\\\\" \\\\\\\":\\\\\\\"\\\\\\\")+item.str;lastY=y;\\\\n if(item.hasEOL)flush();\\\\n }\\\\n flush();if(line===0)rows.push({page:p,line:0,raw:\\\\\\\"[NO_EXTRACTABLE_TEXT_PAGE]\\\\\\\"});\\\\n }\\\\n return {rows,pages:pdf.numPages,pdf_sha256:await hashBytes(bytes),warnings};\\\\n }finally{if(typeof pdf.cleanup===\\\\\\\"function\\\\\\\")await pdf.cleanup();if(typeof pdf.loadingTask?.destroy===\\\\\\\"function\\\\\\\")await pdf.loadingTask.destroy();}\\\\n}\\\\nexport function parseRows(rows:SourceRow[]){\\\\n if(!rows.length||rows[0].raw!==FORMAT)throw Error(\\\\\\\"UNSUPPORTED_LAYOUT_OR_SCANNED_PDF\\\\\\\");\\\\n const lines:any[]=[],issues:any[]=[];\\\\n for(const page of new Set(rows.map(r=>r.page))){const pageRows=rows.filter(r=>r.page===page);if(pageRows[0]?.raw!==FORMAT||pageRows[1]?.raw!==COLUMNS)throw Error(\\\\\\\"UNSUPPORTED_PAGE_HEADER\\\\\\\");}\\\\n for(const source of rows){\\\\n if(HEADER_SET.has(source.raw)&&source.line<=2)continue;\\\\n const parts=source.raw.split(\\\\\\\"|\\\\\\\").map(v=>v.trim());\\\\n if(parts.length!==4||!/^[A-Za-z0-9_.-]{1,64}$/.test(parts[0])||!/^[A-Za-z0-9_/-]{1,16}$/.test(parts[2])){\\\\n issues.push({...source,status:\\\\\\\"REVIEW\\\\\\\",reason:\\\\\\\"UNPARSED_SOURCE_ROW\\\\\\\"});continue;\\\\n }\\\\n if(!/^[1-9][0-9]{0,8}$/.test(parts[1])){\\\\n issues.push({...source,status:\\\\\\\"REVIEW\\\\\\\",reason:\\\\\\\"INVALID_QUANTITY\\\\\\\"});continue;\\\\n }\\\\n lines.push({code:parts[0],quantity:Number(parts[1]),unit:parts[2],description:parts[3],source});\\\\n }\\\\n if(lines.length+issues.length===0)issues.push({page:1,line:0,raw:\\\\\\\"\\\\\\\",status:\\\\\\\"REVIEW\\\\\\\",reason:\\\\\\\"NO_LINE_ITEMS\\\\\\\"});\\\\n if(lines.length+issues.length>250)throw Error(\\\\\\\"RFQ_ROW_LIMIT\\\\\\\");\\\\n return {lines,issues};\\\\n}\\\\nexport function validateSources(catalogue:CatalogueRow[],prices:PriceRow[]){\\\\n if(!Array.isArray(catalogue)||!Array.isArray(prices)||catalogue.length>500||prices.length>500)throw Error(\\\\\\\"CATALOGUE_SIZE_LIMIT\\\\\\\");\\\\n const text=(v:any,n:number)=>typeof v===\\\\\\\"string\\\\\\\"&&v.trim().length>0&&v.length<=n;\\\\n for(const r of catalogue)if(!r||!text(r.code,64)||!text(r.unit,16)||!text(r.description,500))throw Error(\\\\\\\"INVALID_CATALOGUE_ROW\\\\\\\");\\\\n for(const r of prices)if(!r||!text(r.code,64)||!text(r.unit,16)||typeof r.amountMinor!==\\\\\\\"bigint\\\\\\\"||r.amountMinor<0n||r.amountMinor>999999999999999n||!text(r.priceListVersion,100)||typeof r.currency!==\\\\\\\"string\\\\\\\"||!/^[A-Z]{3}$/.test(r.currency))throw Error(\\\\\\\"INVALID_APPROVED_PRICE\\\\\\\");\\\\n}\\\\nexport function quoteParsed(parsed:ReturnType,catalogue:CatalogueRow[],prices:PriceRow[]){\\\\n validateSources(catalogue,prices);\\\\n const base=buildQuote(parsed.lines,catalogue,prices);\\\\n const issues=[...parsed.issues];\\\\n const results=base.results.map((r:any)=>({...r,source:parsed.lines[r.index].source,description:parsed.lines[r.index].description,requestedQuantity:parsed.lines[r.index].quantity,requestedUnit:parsed.lines[r.index].unit}));\\\\n if(new Set(results.filter(r=>r.status===\\\\\\\"MATCHED\\\\\\\").map(r=>r.currency)).size>1)issues.push({page:0,line:0,raw:\\\\\\\"\\\\\\\",status:\\\\\\\"REVIEW\\\\\\\",reason:\\\\\\\"MIXED_CURRENCIES_NO_CONVERSION\\\\\\\"});\\\\n if(new Set(results.filter(r=>r.status===\\\\\\\"MATCHED\\\\\\\").map(r=>r.priceListVersion)).size>1)issues.push({page:0,line:0,raw:\\\\\\\"\\\\\\\",status:\\\\\\\"REVIEW\\\\\\\",reason:\\\\\\\"MIXED_APPROVED_PRICE_LIST_VERSIONS\\\\\\\"});\\\\n const reviewRequired=base.reviewRequired||issues.length>0;\\\\n return {...base,truth:\\\\\\\"PROTOTYPE_DRAFT_NOT_CLIENT_ACCEPTED\\\\\\\",results,issues,reviewRequired,totalMinor:reviewRequired?null:base.totalMinor};\\\\n}\\\\nexport async function writeWorkbook(quote:ReturnType,source:{pdf_sha256:string;pages:number}){\\\\n const wb=XLSX.utils.book_new();wb.Props={Author:\\\\\\\"Alexander Romaskevich / RomaskevicH\\\\\\\",Title:\\\\\\\"RFQ quotation draft — review required\\\\\\\"};\\\\n const rows:any[][]=[],review:any[][]=[],meta:any[][]=[];\\\\n rows.push([\\\\\\\"Page\\\\\\\",\\\\\\\"Source line\\\\\\\",\\\\\\\"Source text\\\\\\\",\\\\\\\"Code\\\\\\\",\\\\\\\"Description from RFQ\\\\\\\",\\\\\\\"Quantity\\\\\\\",\\\\\\\"Unit\\\\\\\",\\\\\\\"Match status\\\\\\\",\\\\\\\"Reason\\\\\\\",\\\\\\\"Line amount minor units (exact text)\\\\\\\",\\\\\\\"Currency\\\\\\\",\\\\\\\"Approved price list version\\\\\\\"]);\\\\n for(const r of quote.results as any[])rows.push([r.source.page,r.source.line,r.source.raw,r.code,r.description,r.requestedQuantity,r.requestedUnit,r.status,r.reason??\\\\\\\"\\\\\\\",r.amountMinor??\\\\\\\"\\\\\\\",r.currency??\\\\\\\"\\\\\\\",r.priceListVersion??\\\\\\\"\\\\\\\"]);\\\\n review.push([\\\\\\\"Page\\\\\\\",\\\\\\\"Source line\\\\\\\",\\\\\\\"Source text\\\\\\\",\\\\\\\"Reason\\\\\\\"]);\\\\n for(const r of quote.results as any[])if(r.status===\\\\\\\"REVIEW\\\\\\\")review.push([r.source.page,r.source.line,r.source.raw,r.reason]);\\\\n for(const r of quote.issues)review.push([r.page,r.line,r.raw,r.reason]);\\\\n meta.push(...[\\\\n [\\\\\\\"Status\\\\\\\",\\\\\\\"INTERNAL PROTOTYPE / NOT CLIENT ACCEPTED\\\\\\\"],\\\\n [\\\\\\\"PDF SHA-256\\\\\\\",source.pdf_sha256],[\\\\\\\"PDF pages\\\\\\\",source.pages],\\\\n [\\\\\\\"Layout\\\\\\\",FORMAT],[\\\\\\\"Review required\\\\\\\",quote.reviewRequired?\\\\\\\"YES\\\\\\\":\\\\\\\"NO\\\\\\\"],\\\\n [\\\\\\\"Grand total minor units (exact text)\\\\\\\",quote.totalMinor??\\\\\\\"WITHHELD\\\\\\\"],\\\\n [\\\\\\\"Currency\\\\\\\",quote.currency??\\\\\\\"UNRESOLVED\\\\\\\"],[\\\\\\\"Money representation\\\\\\\",\\\\\\\"Integer minor units as text; no assumed decimal precision, tax or FX\\\\\\\"],\\\\n [\\\\\\\"Matching\\\\\\\",\\\\\\\"Exact normalized code and unit; no fuzzy confidence or product substitution\\\\\\\"],\\\\n [\\\\\\\"Approval boundary\\\\\\\",\\\\\\\"Supplied price rows are inputs, not proof of buyer authorization. Final delivery requires agreed scope and independent QA.\\\\\\\"]\\\\n ]);\\\\n for(const [name,data] of [[\\\\\\\"Quote Draft\\\\\\\",rows],[\\\\\\\"Review\\\\\\\",review],[\\\\\\\"Evidence\\\\\\\",meta]] as [string,any[][]][]){\\\\n const sheet=XLSX.utils.aoa_to_sheet(data);\\\\n sheet[\\\\\\\"!cols\\\\\\\"]=data[0].map((_,i)=>({wch:i===2?60:26}));\\\\n XLSX.utils.book_append_sheet(wb,sheet,name);\\\\n }\\\\n // The worksheet builder writes all strings as text, never formula objects.\\\\n return new Uint8Array(XLSX.write(wb,{bookType:\\\\\\\"xlsx\\\\\\\",type:\\\\\\\"array\\\\\\\"}));\\\\n}\\\\nexport async function processPdfQuote(bytes:Uint8Array,catalogue:CatalogueRow[],prices:PriceRow[]){\\\\n validateSources(catalogue,prices);\\\\n const extracted=await readPdfRows(bytes),parsed=parseRows(extracted.rows);\\\\n parsed.issues.push(...extracted.warnings);\\\\n const quote=quoteParsed(parsed,catalogue,prices);\\\\n const xlsx=await writeWorkbook(quote,extracted);\\\\n return {quote,xlsx,evidence:{pdf_sha256:extracted.pdf_sha256,xlsx_sha256:await hashBytes(xlsx),pages:extracted.pages,format:FORMAT,client_delivery_ready:false}};\\\\n}\\\\n\\\",\\\"synthetic_pdf\\\":\\\"import {PDFDocument,StandardFonts} from \\\\\\\"npm:pdf-lib@1.17.1\\\\\\\";\\\\nimport {FORMAT,COLUMNS} from \\\\\\\"./file_pipeline.ts\\\\\\\";\\\\nexport const DEMO_ROWS=[\\\\\\\"SW-01 | 3 | EA | Synthetic switch\\\\\\\",\\\\\\\"CB-99 | 2 | EA | Unknown synthetic item\\\\\\\",\\\\\\\"LN-10 | 4 | BOX | Synthetic unit mismatch\\\\\\\"];\\\\nexport async function makePdf(rows:string[]=DEMO_ROWS,pages=1,withHeaders=true){\\\\n const pdf=await PDFDocument.create(),font=await pdf.embedFont(StandardFonts.Helvetica);\\\\n pdf.setCreationDate(new Date(\\\\\\\"2026-09-13T00:00:00Z\\\\\\\"));pdf.setModificationDate(new Date(\\\\\\\"2026-09-13T00:00:00Z\\\\\\\"));\\\\n pdf.setTitle(\\\\\\\"Synthetic RFQ fixture — not a client document\\\\\\\");pdf.setAuthor(\\\\\\\"Alexander Romaskevich / RomaskevicH\\\\\\\");\\\\n for(let p=0;p s.trim().toUpperCase();\\\\n\\\\nexport function buildQuote(lines: RfqLine[], catalogue: CatalogueRow[], prices: PriceRow[]) {\\\\n const results = lines.map((line, index) => {\\\\n const code = norm(line.code);\\\\n const unit = norm(line.unit);\\\\n const cat = catalogue.filter(c => norm(c.code) === code);\\\\n if (cat.length === 0) return { index, code, status: 'REVIEW', reason: 'UNKNOWN_CODE' };\\\\n if (cat.length > 1) return { index, code, status: 'REVIEW', reason: 'AMBIGUOUS_CATALOGUE_CODE' };\\\\n if (norm(cat[0].unit) !== unit) return { index, code, status: 'REVIEW', reason: 'UNIT_MISMATCH' };\\\\n const price = prices.filter(p => norm(p.code) === code && norm(p.unit) === unit);\\\\n if (price.length !== 1) return { index, code, status: 'REVIEW', reason: price.length === 0 ? 'MISSING_APPROVED_PRICE' : 'AMBIGUOUS_APPROVED_PRICE' };\\\\n if (!Number.isInteger(line.quantity) || line.quantity <= 0) return { index, code, status: 'REVIEW', reason: 'INVALID_QUANTITY' };\\\\n return {\\\\n index, code, status: 'MATCHED', quantity: line.quantity, unit,\\\\n amountMinor: (BigInt(line.quantity) * price[0].amountMinor).toString(),\\\\n currency: price[0].currency,\\\\n priceListVersion: price[0].priceListVersion\\\\n };\\\\n });\\\\n const reviewRequired = results.some(r => r.status === 'REVIEW');\\\\n const currencies = [...new Set(results.filter(r => r.status === 'MATCHED').map((r: any) => r.currency))];\\\\n const totalMinor = reviewRequired || currencies.length !== 1 ? null : results.reduce((sum, r: any) => sum + BigInt(r.amountMinor ?? '0'), 0n).toString();\\\\n return { truth: 'SYNTHETIC_DEMO_NOT_CLIENT_DELIVERY', results, reviewRequired, totalMinor, currency: currencies.length === 1 ? currencies[0] : null };\\\\n}\\\\n\\\\nexport const sample = {\\\\n lines: [\\\\n { code: 'SW-01', description: 'Switch', quantity: 3, unit: 'EA' },\\\\n { code: 'CB-99', description: 'Unknown breaker', quantity: 2, unit: 'EA' },\\\\n { code: 'LN-10', description: 'Lamp', quantity: 4, unit: 'BOX' }\\\\n ],\\\\n catalogue: [\\\\n { code: 'SW-01', description: 'Synthetic switch', unit: 'EA' },\\\\n { code: 'LN-10', description: 'Synthetic lamp', unit: 'EA' }\\\\n ],\\\\n prices: [\\\\n { code: 'SW-01', unit: 'EA', amountMinor: 1250n, currency: 'USD', priceListVersion: 'SYNTHETIC-2026-09' },\\\\n { code: 'LN-10', unit: 'EA', amountMinor: 500n, currency: 'USD', priceListVersion: 'SYNTHETIC-2026-09' }\\\\n ]\\\\n};\\\\n\\\",\\\"http_handler_candidate\\\":\\\"import verification from \\\\\\\"./file_verification.json\\\\\\\" with {type:\\\\\\\"json\\\\\\\"};\\\\nimport { buildQuote, sample } from './core.ts';\\\\n\\\\nconst proof = buildQuote(sample.lines, sample.catalogue, sample.prices);\\\\nlet fileDemo:Promise|undefined;\\\\nasync function getFileDemo(){\\\\n if(!fileDemo)fileDemo=(async()=>{\\\\n const [{makePdf},{processPdfQuote}]=await Promise.all([import(\\\\\\\"./synthetic_pdf.ts\\\\\\\"),import(\\\\\\\"./file_pipeline.ts\\\\\\\")]);\\\\n const pdf=await makePdf(),result=await processPdfQuote(pdf,sample.catalogue,sample.prices);\\\\n return {pdf,...result};\\\\n })().catch(e=>{fileDemo=undefined;throw e;});\\\\n return await fileDemo;\\\\n}\\\\n\\\\nexport default async function handler(req: Request): Promise {\\\\n const url = new URL(req.url);\\\\n if(req.method!==\\\\\\\"GET\\\\\\\")return new Response(\\\\\\\"Method not allowed\\\\\\\",{status:405,headers:{allow:\\\\\\\"GET\\\\\\\"}});\\\\n if([\\\\\\\"/demo.pdf\\\\\\\",\\\\\\\"/demo.xlsx\\\\\\\",\\\\\\\"/api/file-demo\\\\\\\"].includes(url.pathname)){\\\\n try{\\\\n const result=await getFileDemo();\\\\n if(url.pathname===\\\\\\\"/api/file-demo\\\\\\\")return Response.json({status:\\\\\\\"SYNTHETIC_PIPELINE_RUNTIME_VERIFIED\\\\\\\",checks_passed:verification.checks,verified_at:verification.verified_at,scope:\\\\\\\"One explicit demo PDF layout to exact matching and XLSX draft\\\\\\\",client_delivery_ready:false,result:result.quote,evidence:result.evidence,limits:[\\\\\\\"Synthetic layout only; buyer layout not received\\\\\\\",\\\\\\\"No OCR or scanned PDFs\\\\\\\",\\\\\\\"No n8n deployment yet\\\\\\\",\\\\\\\"No client upload or automatic delivery\\\\\\\"]});\\\\n const isPdf=url.pathname===\\\\\\\"/demo.pdf\\\\\\\";\\\\n return new Response(isPdf?result.pdf:result.xlsx,{headers:{\\\\\\\"content-type\\\\\\\":isPdf?\\\\\\\"application/pdf\\\\\\\":\\\\\\\"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet\\\\\\\",\\\\\\\"content-disposition\\\\\\\":isPdf?'attachment; filename=\\\\\\\"synthetic-rfq.pdf\\\\\\\"':'attachment; filename=\\\\\\\"synthetic-quote-draft.xlsx\\\\\\\"',\\\\\\\"cache-control\\\\\\\":\\\\\\\"public, max-age=3600\\\\\\\",\\\\\\\"x-content-type-options\\\\\\\":\\\\\\\"nosniff\\\\\\\"}});\\\\n }catch{return Response.json({status:\\\\\\\"FILE_DEMO_UNAVAILABLE\\\\\\\",client_delivery_ready:false},{status:503});}\\\\n }\\\\n if (url.pathname === '/api/demo') {\\\\n return new Response(JSON.stringify({\\\\n name: 'IMPERIAL RFQ-to-Quote Synthetic Proof',\\\\n truth: 'SYNTHETIC_DEMO_NOT_CLIENT_DELIVERY',\\\\n verification: {status:\\\\\\\"RECORDED_BASELINE\\\\\\\",checks_passed:10,scope:\\\\\\\"Unchanged core matching only\\\\\\\"},\\\\n scope: 'Exact catalogue and approved-price matching with explicit human-review exceptions',\\\\n result: proof,\\\\n exclusions: ['OCR/scanned PDFs','ERP integration','automatic email','dashboard','silent product substitution']\\\\n }, null, 2), { headers: { 'content-type': 'application/json; charset=utf-8' } });\\\\n }\\\\n\\\\n const html = `IMPERIAL RFQ-to-Quote Synthetic Proof

IMPERIAL RFQ-to-Quote Synthetic Proof

Truth boundary: synthetic evaluation demo — not a client delivery and not an electrical-parts production deployment.

Previously recorded core-matching verification: 10/10 checks PASS on Val Town.

What this proves

Exact normalized product-code and unit matching; prices sourced only from an approved versioned price list; unknown codes, unit mismatches and ambiguous/missing prices are routed to human review; a complete quotation total is withheld while exceptions remain.

Current demo result

${JSON.stringify(proof, null, 2)}

PDF to Excel: executable synthetic example

A fixed text-PDF fixture is extracted and exported to an actual Excel workbook with Quote Draft, Review and Evidence sheets. Recorded file-pipeline verification: ${verification.checks} checks passed at ${verification.verified_at}. This does not establish compatibility with a buyer PDF layout.

Download synthetic input PDF · Download generated Excel draft · File-pipeline evidence

Paid-test boundary

A real paid test requires adapting and verifying this prototype against the buyer’s agreed PDF layout, catalogue, price list and workbook format, then adding the native n8n workflow, independent QA and one revision against written acceptance criteria.

Excluded unless separately scoped: OCR/scans, catalogue cleansing, ERP, automatic email, dashboards, tax/currency rules, additional layouts and production hosting.

Machine-readable demo evidence

`;\\\\n return new Response(html, { headers: { 'content-type': 'text/html; charset=utf-8' } });\\\\n}\\\\n\\\",\\\"verification\\\":{\\\"status\\\":\\\"PASS\\\",\\\"checks\\\":28,\\\"tests\\\":[\\\"actual_pdf_extracted\\\",\\\"exact_price_arithmetic\\\",\\\"unknown_code_review\\\",\\\"unit_mismatch_review\\\",\\\"review_blocks_total\\\",\\\"hashes_bound\\\",\\\"real_xlsx_readable\\\",\\\"all_rows_exported\\\",\\\"review_sheet_two_exceptions\\\",\\\"money_exact_text\\\",\\\"withheld_total_exported\\\",\\\"clean_total_exact\\\",\\\"unparsed_rows_retained\\\",\\\"unparsed_rows_block_total\\\",\\\"duplicate_catalogue_review\\\",\\\"mixed_currency_review\\\",\\\"mixed_price_versions_block_total\\\",\\\"missing_column_header_rejected\\\",\\\"negative_price_rejected\\\",\\\"empty_price_version_rejected\\\",\\\"non_pdf_rejected\\\",\\\"oversize_pdf_rejected\\\",\\\"no_extractable_text_rejected\\\",\\\"unrecognized_document_header\\\",\\\"page_limit\\\",\\\"empty_line_items_block_total\\\",\\\"formula_injection_remains_text\\\",\\\"input_bytes_not_detached\\\"],\\\"verified_at\\\":\\\"2026-09-13T17:08:33.282Z\\\",\\\"fixture\\\":\\\"SYNTHETIC_NOT_CLIENT_DATA\\\",\\\"sample_evidence\\\":{\\\"pdf_sha256\\\":\\\"d952f47a9d20346b622fc47d80472a17f2fcea0e1567d23e8cd8d588bc84a15d\\\",\\\"xlsx_sha256\\\":\\\"0dddc6ff3624ced329aec9327a6fd48526223795b780e8f2aac8f34f3903032e\\\",\\\"pages\\\":1,\\\"format\\\":\\\"IMPERIAL RFQ DEMO V1\\\",\\\"client_delivery_ready\\\":false},\\\"output_bytes\\\":22403,\\\"client_delivery\\\":false}}\",digest=await sha(source),id=\"REAL10-RFQ-FILE-QA:\"+digest;\nconst previous:any=(await sqlite.execute({sql:\"SELECT payload FROM crm_communications WHERE communication_id=?\",args:[id]})).rows[0];\nif(previous)console.log(JSON.stringify({status:\"CACHED\",review:JSON.parse(String(previous.payload))}));\nelse{\nconst r=await callLiveModel({agentId:\"NCA-432\",purpose:\"REAL10_RFQ_FILE_PIPELINE_QA\",model:LIVE_MODEL,maxCompletionTokens:4000,prompt:\"Independent NCA-432 re-review of changed code authored by ASTRA. Prior defects fixed: mixed priceListVersion now creates REVIEW issue and suppresses total; each page requires both exact header lines; misplaced headers become unparsed issues; rotation/reversed vertical reading order emits review warnings; unmatched/malformed rows retained; public file verification comes from maintained test record with timestamp, prior unchanged core10 explicitly labeled historical baseline. 28 actual runtime tests passed (provided). Scope still only explicitly synthetic layout and fixed public fixture downloads, not arbitrary buyer PDF, scans, paid work, upload or delivery. Reject promises of complete extraction for unknown layouts, but do not require OCR support outside scope. Evaluate remaining concrete bugs. Return JSON only {verdict:PASS|REVISE,defects:[{severity:string,description:string}],reason:string}. Do not claim tests run by you. CODE_DATA:\"+source});\nawait sqlite.execute({sql:`INSERT INTO crm_communications(communication_id,actor_agent_id,event_type,object_type,object_id,channel,result,payload,evidence,created_at) VALUES(?,'NCA-432','RFQ_PIPELINE_CODE_REVIEW','OPPORTUNITY','OPP-DICON-N8N-RFQ-312281','INTERNAL_RUNTIME','REVIEW_RECEIVED',?,?,?)`,args:[id,JSON.stringify({review:r.text,model_request_id:r.requestId}),JSON.stringify({code_sha256:digest,author:\"ASTRA\",reviewer:\"NCA-432\",tests_executed_by_reviewer:false}),new Date().toISOString()]});\nconsole.log(JSON.stringify({code_sha256:digest,model_request_id:r.requestId,review:r.text}));\n}","deleted",false,"label",[14],"04f41296-b07d-43ba-83f9-d5f45983c8e6",["D",1787955492364],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Recovered NCA runtime with ORION learning loop","imageUrl","userId","fe39b163-4b50-466e-82d1-8bd01133e4b6","pinnedFileId","6796d66a-a32f-11f1-bd77-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a03585-eb44-758d-92a4-77db1a9a243c","tursoName","04f41296b07d43ba83f9d5f45983c8e6","tursoHostname","04f41296b07d43ba83f9d5f45983c8e6-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789526460011],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_106":102},"org",{"_9":10,"_99":100,"_101":102,"_55":56,"_103":104,"_105":42},"branch",{"_35":89,"_11":90,"_22":28,"_91":45,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":12,"_98":10},"isOwned",1288,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Олександр Ромаскевич","avatar","https://lh3.googleusercontent.com/a/ACg8ocIo1MJ3hDjpQrinMIRok3d2YY1vpHgehs8m2u1_vc7pmFovRGI=s96-c","tier","free","canRestrictVals","profileImageUrl","ctx",{"_82":-5,"_140":141,"_142":143,"_144":145,"_146":42,"_147":42,"_148":42,"_149":32,"_150":-5,"_151":-7,"_152":-7,"_153":63,"_154":42,"_155":42,"_156":-5,"_157":42,"_158":42,"_159":42,"_160":-5},"ENV",{"_111":112,"_113":114,"_115":90,"_116":117,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135,"_136":137,"_138":139},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]