1 00:00:00,080 --> 00:00:03,459 A live Google Sheet recalculates when the underlying numbers change. 2 00:00:03,459 --> 00:00:07,176 That is useful while working, but a report sent for a 3 00:00:07,176 --> 00:00:10,217 finished week should preserve the values that were approved. 4 00:00:10,217 --> 00:00:13,934 In one spreadsheet, we will build a small live table, copy 5 00:00:13,934 --> 00:00:17,650 it to a Report tab with Paste values only, then change 6 00:00:17,650 --> 00:00:21,029 a source number and prove the frozen copy stays unchanged. 7 00:00:21,629 --> 00:00:24,138 Download the input CSV with three workstreams. 8 00:00:24,138 --> 00:00:29,154 Planned counts are ten, eight and six; actual counts are twelve, seven and six. 9 00:00:29,154 --> 00:00:33,813 In a Google Sheets spreadsheet, put the data on a tab named Live. 10 00:00:33,813 --> 00:00:37,754 Add a Variance column with actual minus planned for each row, 11 00:00:37,754 --> 00:00:39,546 then add a total row. 12 00:00:39,546 --> 00:00:43,846 The verified starting totals are twenty-four planned and twenty-five actual. 13 00:00:44,446 --> 00:00:48,336 In the Live tab, enter equals C two minus B two 14 00:00:48,336 --> 00:00:51,872 for the first variance, then fill down through row four. 15 00:00:51,872 --> 00:00:54,701 Sum planned, actual and variance in row five. 16 00:00:54,701 --> 00:00:58,591 The result should be plus two, minus one and zero, with 17 00:00:58,591 --> 00:01:00,005 total variance plus one. 18 00:01:00,005 --> 00:01:03,895 Fix the source table before making a snapshot; Paste values only 19 00:01:03,895 --> 00:01:07,785 will preserve whatever numbers are showing at that moment, including mistakes. 20 00:01:08,385 --> 00:01:11,850 Create a second tab named Report in the same spreadsheet. 21 00:01:11,850 --> 00:01:14,623 Copy Live cells A one through D five. 22 00:01:14,623 --> 00:01:19,129 Select Report cell A one, then choose Edit, Paste special, Paste values only. 23 00:01:19,129 --> 00:01:23,287 Google's current help says this option pastes the displayed text or 24 00:01:23,287 --> 00:01:24,674 values, not the formulas. 25 00:01:24,674 --> 00:01:28,486 It also says Paste special works only within one spreadsheet, which 26 00:01:28,486 --> 00:01:31,605 is why both tabs are in the same file. 27 00:01:32,205 --> 00:01:37,887 The Report tab should show twenty-four planned, twenty-five actual and plus one variance. 28 00:01:37,887 --> 00:01:42,053 Click its variance cells and check the formula bar: they should 29 00:01:42,053 --> 00:01:44,704 contain fixed numbers, not equals-sign formulas. 30 00:01:44,704 --> 00:01:49,249 A normal paste can look identical at first yet keep calculations alive. 31 00:01:49,249 --> 00:01:53,037 This formula-bar check distinguishes a genuine frozen snapshot from 32 00:01:53,037 --> 00:01:55,309 another copy of the live model. 33 00:01:55,909 --> 00:02:00,893 Back on Live, change Workstream B's actual count from seven to nine. 34 00:02:00,893 --> 00:02:05,110 Its variance becomes plus one, and the live actual and variance 35 00:02:05,110 --> 00:02:07,794 totals become twenty-seven and plus three. 36 00:02:07,794 --> 00:02:09,327 Now return to Report. 37 00:02:09,327 --> 00:02:13,928 If the snapshot was pasted as values only, its earlier twenty-five 38 00:02:13,928 --> 00:02:15,844 and plus one remain unchanged. 39 00:02:15,844 --> 00:02:18,911 This deliberate source change is the decisive verification. 40 00:02:19,511 --> 00:02:23,462 Do not edit the Report snapshot when correcting the source model; 41 00:02:23,462 --> 00:02:27,413 create a new dated snapshot if a revised report is approved. 42 00:02:27,413 --> 00:02:32,441 The practice answer check includes both the original static output and later live totals. 43 00:02:32,441 --> 00:02:36,392 We reproduced this with a fictional Google Sheet: changing Workstream B 44 00:02:36,392 --> 00:02:40,702 from seven to nine updated Live to twenty-seven and plus three 45 00:02:40,702 --> 00:02:43,575 while Report stayed twenty-five and plus one.