Get Full Government Meeting Transcripts, Videos, & Alerts Forever!
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.
