{"actions":{"bootstrapAndRun":{"effect":"installs rote if missing, inspects, prepares, and asks before running","href":"https://play.modiqo.ai/install?play=shrinet82/spreadsheet-formula-audit@0.2.0","method":"GET","rel":"https://rote.dev/rels/bootstrap-and-run","requiresConsent":true,"responseMediaType":"text/x-shellscript"},"inspect":{"command":"rote play inspect https://play.modiqo.ai/shrinet82/spreadsheet-formula-audit@0.2.0","effect":"read-only"},"installCliOnly":{"effect":"installs the rote CLI, nothing else","href":"https://play.modiqo.ai/install","method":"GET","rel":"https://rote.dev/rels/install-cli","requiresConsent":true,"responseMediaType":"text/x-shellscript"},"run":{"command":"rote play run https://play.modiqo.ai/shrinet82/spreadsheet-formula-audit@0.2.0","effect":"executes the play locally after consent","headless":{"approvalAssertion":"--yes","approvalRequiredBeforeInvocation":true,"commandTemplate":"rote play run https://play.modiqo.ai/shrinet82/spreadsheet-formula-audit@0.2.0 <name=value...> --yes","stdinPolicy":"never pipe input to automate the interactive Ready selector"},"requiresConsent":true}},"description":"Finds the formula mistakes that quietly make a spreadsheet wrong: a total whose range stops before the data does, a formula that breaks the pattern its neighbours follow, a number typed inside a formula instead of living in its own cell, and cells already showing an error. Reads .xlsx with no library and no login -- point it at a file. Writes one PDF report; never modifies the workbook. Run it with no arguments to audit the bundled sample workbook first.","distribution":{"digest":"sha256:c4984db1c3ad2a59df8fda9e3e8b5d0cff7acd376c4855296662ac1384bc0939","mediaType":"application/vnd.modiqo.rote-flow","size":16640,"verifiedBy":"rote verifies the downloaded archive against this digest before it runs"},"effects":{"credentialsProvidedBy":"runner","credentialsRemainLocal":true,"declaredWrites":[],"publisherReceivesCredentials":false},"id":"https://play.modiqo.ai/shrinet82/spreadsheet-formula-audit@0.2.0","inputPolicy":{"optionalWithDefault":"show_default_and_accept_override","optionalWithoutDefault":"omit_unless_supplied","required":"ask","secrets":"collect_locally_outside_conversation"},"links":{"docs":"https://rote.dev","page":"https://play.modiqo.ai/shrinet82/spreadsheet-formula-audit@0.2.0","protocol":"https://play.modiqo.ai/.well-known/rote","self":"https://play.modiqo.ai/shrinet82/spreadsheet-formula-audit@0.2.0.json"},"name":"spreadsheet-formula-audit","owner":{"kind":"user","slug":"shrinet82"},"parameters":[{"description":"Absolute path to the .xlsx or .xlsm file to audit. Leave empty to audit the sample workbook bundled with this Play, so a first run needs no file of your own.","example":"/home/you/budget.xlsx","input":{"allowCustom":true,"choices":[],"label":"Workbook"},"name":"workbook","required":false,"type":"string"},{"default":"spreadsheet-audit.pdf","description":"Filename for the PDF report. Writes one file into the folder you run the Play from, every run, by default -- set to an empty string for no file at all. Give an absolute path to put it elsewhere.","example":"/home/you/audit.pdf","input":{"allowCustom":true,"choices":[],"label":"Report"},"name":"report","required":false,"type":"string"}],"preparation":[{"action":{"command":"rote play inspect https://play.modiqo.ai/shrinet82/spreadsheet-formula-audit@0.2.0 --json","effect":"read-only"},"step":1,"type":"inspect_local_readiness"},{"references":["/parameters"],"step":2,"type":"collect_parameters"},{"references":["/parameters","/requirements","/effects"],"step":3,"type":"review"},{"consentBoundary":"the user approves the exact play and parameter values","references":["/parameters","/requirements","/effects"],"step":4,"type":"obtain_run_consent"},{"action":{"command":"rote play run https://play.modiqo.ai/shrinet82/spreadsheet-formula-audit@0.2.0","headlessCommandTemplate":"rote play run https://play.modiqo.ai/shrinet82/spreadsheet-formula-audit@0.2.0 <name=value...> --yes"},"preservesAcquisitionBoundaries":["adapter_selection","oauth_dcr","google_discovery","static_token_setup","runtime_security_checks"],"requiresConsent":true,"step":5,"type":"run"}],"producedBy":{"roteVersion":"0.78.0"},"publishedAt":"2026-09-04T08:23:06.270688+00:00","reference":"shrinet82/spreadsheet-formula-audit@0.2.0","requirements":{"adapters":[],"browser":{"dependencies":[],"runtime":false,"signIn":false},"localTools":["python3"],"roteCli":{"minimumVersion":"0.62.0"},"sessions":false},"resolution":"pinned","schema":"rote.play.v1","stats":{"downloads":6,"installs":0},"steps":{"count":4,"names":["audit","scan_formulas","scan_structure","validate_input"]},"title":"spreadsheet-formula-audit","type":"play","version":"0.2.0","visibility":"public"}