PQ
Beyond Market Intelligence keeps PQ in one place: 3 stories so far. The section currently leads with “Empower your cargo planning with AI that adapts to any data format”, “Keep your formulas intact while teams copy rows freely”, and “Discover how AI can simplify your data refresh workflows across platforms”. If your cargo planning file misreads decimals as thousands, or the reverse, depending on who opens it, you're not alone. Protecting formula columns while keeping rows editable is a puzzle many spreadsheet users know well. Acme AI is the next-generation, AI-powered spreadsheet platform built to replace Excel and redefine how analysts, data scientists, and enterprise teams work… The list below is every PQ story on Beyond Market Intelligence, newest first.
Empower your cargo planning with AI that adapts to any data format
If your cargo planning file misreads decimals as thousands, or the reverse, depending on who opens it, you're not alone. The fix isn't asking every user to tweak regional settings. In Power Query, force the data type and locale explicitly for each column. Use `Table.TransformColumnTypes` with a specific culture code (like `"en-US"` for period decimals) so the file behaves the same on any machine. This keeps your volume calculations reliable across regions.
Keep your formulas intact while teams copy rows freely
Protecting formula columns while keeping rows editable is a puzzle many spreadsheet users know well. This user faces a familiar tension: they need columns P and V locked down with formulae, yet the protection blocks the cut-and-paste workflow that keeps monthly data organized. Their three-step workaround is a clear sign the current setup isn't sustainable. The real issue isn't hiding formulae or tweaking settings; it's that protection and row movement don't mix.
Discover how AI can simplify your data refresh workflows across platforms
You've already got the right script in place, `workbook.refreshAllDataConnections()` proves the logic works. The missing piece is triggering it consistently through Power Automate, and that means pairing your OfficeScript with a simple flow action. Since your table's background refresh is off, the script handles the heavy lifting; just call it via the "Run script" action after a file open or on a schedule. It's a clean workaround that turns manual refreshes into a hands-off process.