Spreadsheet: 876983d1723683986-currency-weighted-average-on-sales-and-credits-weighted-average-fx-rates
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | TransactionType | Date | Currency | EUR | Amount | USD Dollar
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-02 00:00:00 | CHF | 1.108143748407044 | 521 |  |  |  |  | Weighted Average
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-01 00:00:00 | CHF | 1.108143748407044 | 900
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-03 00:00:00 | CHF | 1.108585998558838 | 900 |  |  |  |  | Weighted Average rate
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-10 00:00:00 | CHF | 1.115013658917322 | 900 |  |  | Sales | CHF |  |  | First use Find and Replace to remove all trailing spaces in the words in columns L, N, S and T.
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-11 00:00:00 | CHF | 1.115063391353798 | 900 |  |  | Credit | CHF
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-09 00:00:00 | CHF | 1.115274803711635 | 900 |  |  | Sales | EUR
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-12 00:00:00 | CHF | 1.115386760359155 | 900 |  |  | Credit | EUR
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-04 00:00:00 | CHF | 1.118142988125322 | 900 |  |  | Sales | GBP
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-05 00:00:00 | CHF | 1.120774679458442 | 900 |  |  | Credit | GBP
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-06 00:00:00 | CHF | 1.121503712177287 | 900
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-07 00:00:00 | CHF | 1.124290291753331 | 900
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-13 00:00:00 | CHF | 1.11656989727557 | 1700
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-14 00:00:00 | CHF | 1.11845563645718 | 1750
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-15 00:00:00 | CHF | 1.123292595255212 | 1800
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-16 00:00:00 | CHF | 1.123292595255212 | 1850
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-17 00:00:00 | CHF | 1.120837489772358 | 1900
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-18 00:00:00 | CHF | 1.126900235522149 | 1950
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-19 00:00:00 | CHF | 1.130224462578268 | 2000
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-20 00:00:00 | CHF | 1.123570256848161 | 2050
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-21 00:00:00 | CHF | 1.120724436275609 | 2100
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-22 00:00:00 | CHF | 1.118243016572361 | 2150
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-23 00:00:00 | CHF | 1.118243016572361 | 2200
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-24 00:00:00 | CHF | 1.119733055639536 | 2250
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-25 00:00:00 | CHF | 1.119507416736636 | 2300
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-26 00:00:00 | CHF | 1.114131645795267 | 2350
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-27 00:00:00 | CHF | 1.114789917839983 | 2400
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-28 00:00:00 | CHF | 1.112037809285516 | 2450
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-29 00:00:00 | CHF | 1.112730752539808 | 2500
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-30 00:00:00 | CHF | 1.112730752539808 | 2550
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-08 00:00:00 | CHF | 1.115274803711635 | 5200
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-01 00:00:00 | EUR | 1.08492 | 600
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-02 00:00:00 | EUR | 1.08492 | 650
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-03 00:00:00 | EUR | 1.08349 | 700
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-04 00:00:00 | EUR | 1.08718 | 750
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-05 00:00:00 | EUR | 1.08735 | 800
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-06 00:00:00 | EUR | 1.08799 | 850
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-07 00:00:00 | EUR | 1.08918 | 900
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-08 00:00:00 | EUR | 1.08018 | 950
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-09 00:00:00 | EUR | 1.08018 | 1000
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-10 00:00:00 | EUR | 1.07433 | 1050
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-11 00:00:00 | EUR | 1.07508 | 1100
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-12 00:00:00 | EUR | 1.07527 | 1150
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-13 00:00:00 | EUR | 1.08022 | 1200
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-14 00:00:00 | EUR | 1.06873 | 1250
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-15 00:00:00 | EUR | 1.07058 | 1300
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-16 00:00:00 | EUR | 1.07058 | 1350
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-17 00:00:00 | EUR | 1.07112 | 1400
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-18 00:00:00 | EUR | 1.07197 | 1450
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-19 00:00:00 | EUR | 1.07372 | 1500
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-20 00:00:00 | EUR | 1.07253 | 1550
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-21 00:00:00 | EUR | 1.06979 | 1600
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-22 00:00:00 | EUR | 1.06928 | 1650
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-23 00:00:00 | EUR | 1.06928 | 1700
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-24 00:00:00 | EUR | 1.07228 | 1750
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-25 00:00:00 | EUR | 1.07246 | 1800
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-26 00:00:00 | EUR | 1.06889 | 1850
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-27 00:00:00 | EUR | 1.06972 | 1900
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-28 00:00:00 | EUR | 1.07093 | 1950
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-29 00:00:00 | EUR | 1.07132 | 2000
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-30 00:00:00 | EUR | 1.07132 | 2050
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-17 00:00:00 | GBP | 1.26675 | 758
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-18 00:00:00 | GBP | 1.26851 | 758
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-08 00:00:00 | GBP | 1.2722 | 758
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-09 00:00:00 | GBP | 1.2722 | 758
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-11 00:00:00 | GBP | 1.27338 | 758
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-07 00:00:00 | GBP | 1.2796 | 758
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-10 00:00:00 | GBP | 1.26979 | 1500
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-20 00:00:00 | GBP | 1.27062 | 2100
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-02 00:00:00 | GBP | 1.27422 | 2100
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-12 00:00:00 | GBP | 1.27563 | 2100
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-21 00:00:00 | GBP | 1.26531 | 2150
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-03 00:00:00 | GBP | 1.27046 | 2150
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-13 00:00:00 | GBP | 1.27836 | 2150
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-22 00:00:00 | GBP | 1.26417 | 2200
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-14 00:00:00 | GBP | 1.27059 | 2200
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-04 00:00:00 | GBP | 1.27638 | 2200
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-23 00:00:00 | GBP | 1.26417 | 2250
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-15 00:00:00 | GBP | 1.26865 | 2250
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-05 00:00:00 | GBP | 1.27764 | 2250
 |  |  |  |  |  |  |  |  |  |  | Credit | 2024-06-24 00:00:00 | GBP | 1.26691 | 2300
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-16 00:00:00 | GBP | 1.26865 | 2300
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-06 00:00:00 | GBP | 1.27847 | 2300
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-25 00:00:00 | GBP | 1.26911 | 2350
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-26 00:00:00 | GBP | 1.26686 | 2400
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-27 00:00:00 | GBP | 1.26472 | 2450
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-28 00:00:00 | GBP | 1.2649 | 2500
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-29 00:00:00 | GBP | 1.26436 | 2550
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-30 00:00:00 | GBP | 1.26436 | 2600
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-19 00:00:00 | GBP | 1.27308 | 5201
 |  |  |  |  |  |  |  |  |  |  | Sales | 2024-06-01 00:00:00 | GBP | 1.27422 | 6000