Table Column Sum

WHAT IT DOES Table Column Sum is a floating panel that instantly calculates the sum of numeric values in any column of an HTML table. Select a table from a list of automatically detected tables, choose one or more columns (by index or header name), and the panel displays the sum, count of numeric values, average, minimum, and maximum for each selected column. Multiple columns can be selected simultaneously for comparison, making it easy to sum multiple columns in one operation. The panel automatically skips header rows by default, and includes smart options to exclude non-numeric cells, treat empty cells as zero, or skip rows hidden by filtering or pagination. You can copy the results to your clipboard or insert them directly into any editable field on the page (input, textarea, or contenteditable). Perfect for data analysts verifying totals, QA engineers checking column sums, financial professionals auditing spreadsheet-like tables, or anyone who needs quick column statistics without exporting to a spreadsheet. WHERE IT RUNS The panel overlays any website that loads the BotGentz extension—whether you're on a data dashboard, a financial report, a pricing table, an admin panel, a project management tool, or any other web page. It works on all modern Chromium‑based browsers (Chrome, Edge, Brave, Arc) and Firefox. The script injects a self‑contained UI element that does not interfere with the host page's layout, styles, or JavaScript execution. It runs client‑side only, with no external API calls or cloud dependencies. HOW TO USE After installing the free BotGentz extension, visit any page and click the extension icon to activate the panel. The first time you use Table Column Sum, it will appear as a draggable widget near the bottom‑right corner of your viewport. To calculate column sums: - Select a table from the dropdown menu. The panel automatically detects all tables on the page. - Select one or more columns from the column list (hold Ctrl/Cmd to select multiple). - Configure the calculation options: skip header row, exclude non-numeric cells, treat empty cells as zero, and skip hidden rows. - Click "Calculate" to see the results for each selected column. The panel displays the sum, count, average, minimum, and maximum for each column. To use the results: - Click "Copy Results to Clipboard" to copy the statistics for pasting elsewhere. - Click "Insert Results into Active Field" to paste the statistics directly into the focused editable field on the page. The panel remembers your selected table and columns across sessions. INTELLIGENT NUMERIC PARSING ENGINE WITH MULTI-COLUMN STATISTICS AGGREGATION Unlike simple calculators that only sum numbers, this panel uses a robust numeric parsing engine that extracts numeric values from cell content by stripping common formatting characters (commas, currency symbols, parentheses, units) before parsing. This ensures that values like "$1,234.56", "12.34%", or "(45.67)" are correctly interpreted as numbers. The engine supports multiple columns simultaneously by iterating through each selected column independently and aggregating statistics for each. The skip header detection identifies header rows by analyzing the presence of elements or by detecting that at least 30% of the first row's cells are header cells. The hidden row detection checks the style.display property of each row to exclude rows hidden by filtering or pagination. The empty cell handling can be configured to treat empty cells as zero (useful for sparse data) or skip them entirely. All statistics are computed in a single pass through the table for each selected column, ensuring efficient performance even on large tables. THE PANEL - Drag: Click and hold the panel's header bar to move it anywhere on the screen. - Per‑site position: The panel stores its last position separately for each domain (e.g., different positions for Google Sheets vs. Salesforce) using the browser's localStorage, keyed by hostname. - Snap: When dragged near any edge of the viewport, the panel snaps to that edge with a 16px margin for a clean, docked feel. - Collapse: Click the "−" button in the header to collapse the panel to a compact title bar, preserving all current values. Click "+" to expand it back. - Resize: Drag the bottom‑right corner handle to resize the panel from 280px to 600px wide and 200px to 500px tall; the layout adapts responsively. - Escape: Press the Escape key while the panel is focused to close it entirely (you can reopen it from the extension toolbar). PLEASE NOTE This script requires the free BotGentz extension to run—it is not a standalone bookmarklet or user script. Websites frequently update their DOM structures and security policies; while we strive to keep the panel functional across thousands of sites, occasional updates may be needed. The calculator performs all operations entirely in your browser—no data is sent to any server, and no cookies or tracking identifiers are used. Your table data and calculated statistics remain private to your local session and are persisted only via GM_setValue (the extension's local storage) for convenience, not shared across devices or sessions. The numeric parsing is a best‑effort conversion; values with complex formatting (e.g., "1,234.56", "$1,234.56", "1.234,56") may require manual verification. Hidden rows are detected via the display: none style—rows hidden by other methods (e.g., visibility:hidden) are not automatically excluded. For critical calculations, always verify results against your source data.