Excel. create a chart with filters, and flag out divergences
Budget: $30 – $250 USD
I am looking for experienced providers that are able to create Excel charts and pivot tables. I do not want apprentices or amateurs, as I do not want to waste my time. The work I need done includes:
1) Creating a chart that calculates and displays data from which I can filter. For example, the chart would show the number of items (e.g. 5) that are not met (number of NOs and number of N/A) by the tools, display the number of items (e.g. 35 Yes, 12 N/A) out of 70, and calculate the percentage of coverage (excluding the N/A).
2) Checking 8 files (all based on the same structure) and flagging out divergences on the main file. For example, if the cell 3 in the English sheet is different to the cell 3 in the Spanish sheet, the main file should highlight the divergences.
1) Creating a chart that calculates and displays data from which I can filter. For example, the chart would show the number of items (e.g. 5) that are not met (number of NOs and number of N/A) by the tools, display the number of items (e.g. 35 Yes, 12 N/A) out of 70, and calculate the percentage of coverage (excluding the N/A).
2) Checking 8 files (all based on the same structure) and flagging out divergences on the main file. For example, if the cell 3 in the English sheet is different to the cell 3 in the Spanish sheet, the main file should highlight the divergences.