Get email alerts on the Data Integrity topic
No spam. Unsubscribe anytime.
Committee flags spreadsheet translation error; Slipstream to issue corrected calculator
Summary
Members identified a formula/translation issue that showed zeros for buildings 'above target' in a shared spreadsheet. Staff recommended downloading and opening the file in Excel and Slipstream agreed to send an updated calculator with instructions.
Committee members noticed a discrepancy: several columns that should indicate numbers of buildings above target displayed zeros after the spreadsheet was shared. Members and staff discussed whether Google Sheets translation or a Slipstream export had altered formulas.
Stephanie and Gabriela said they had not modified formulas and recommended members download the file and open it in Excel rather than in Google Sheets. Gabriela said Slipstream will supply an updated calculator and instructions so the group can reproduce counts and medians reliably. The committee agreed staff will email the corrected Excel file and that members should avoid editing the original export in Google Sheets.
AI generated
The text on this page is AI generated. Summaries, highlights, analysis, and video transcripts are all produced from the original source material.
AI can make mistakes, so if you spot one, and we will fix it for everyone.
Note: the source content is unaltered by us. Any content source we link to, be it a video, an audio recording, or a document, is presented exactly as its publisher released it. That publisher is usually a government body, sometimes an individual official or another organisation.
