Dynamic Spreadsheet Mastery

I am looking for a talented freelancer proficient in Google Sheets to help me with a project focusing on numbers. The primary tasks involve: - Organizing numerical data efficiently. - Implementing formulas for sum and averages. - Applying data sorting and filtering techniques. The dataset will fit within less than 100 columns and rows, requiring precision and attention to detail to ensure accuracy and usability. Ideal skills for this job include: - Strong proficiency in Google Sheets - Experience with creating somewhat complex and easy to use Sheets - Capability to work with datasets of varying sizes but will start with less than 100 columns and rows. - Understanding of data presentation and making information easily accessible. I value clear communication and adherence to deadlines, aiming for a seamless collaboration that leads to the timely completion of our project with the highest quality standards. I currently have a data set with sales totals for specific names, but broken out by location and individual business unit. For instance: Person 1 sold $1200 of goods at our New York location. This location is under Business Unit A. Person 1 also sold $1200 of goods at our New Jersey location. This location is under Business Unit B. Based on this, Person 1 50% NY 50% NJ And 50% Business Unit A 50% Business Unit B I need a sheet that can tell me, by person, what percentage of their total sales were made at our New York location, what percentage of their total sales were made at our New Jersey location, and have that translate into a percentage of sales for that individual for Business Unit A and Business Unit B. I would like for the sheet to have a search bar so that I can search an individual’s name and quickly see the breakdown of their sales by location and business unit. The workbook is dynamic and used to calculate these totals bi-weekly, so the data sets will be on individual sheets and I would like the summary to be on its own sheet. The summary sheet should have a dropdown where I can select “Period” and “Person” to easily see the data for that person over that specific period. It may sound confusing, but I’m happy to explain in further detail if it is something you believe you’re able to create. Thanks!