Calculate observed customer value and separate projections
Two spreadsheets quote different customer values because one folds forecast revenue into the total and the other never subtracts refunds. In this case, the immediate task is to calculate observed customer value and separate projections. The workflow should produce an LTV analysis reconciled against completed orders in the merchant's records.