Excel Formula and Calculator
Budget: $30 – $250 USD
I need to export two CSV's from different platforms and have them equally formatted when I upload the data into one excel spreadsheet. Then, I need a calculator to calculate the Personal Billing NUmber of our Recruiters and Sales People.
One spreadsheet will have data containing Records Ownership: There are deals splits dedicating percentages for Account Owner, Account Manager, Scheduler and Recruiter.
Second CSV export has the deal's breakdown and when they were paid.
The calculator needs to calculate the Personal Billing Number for each employee based on the Values in the spreadsheet if they match the ownership criteria per record.
One spreadsheet will have data containing Records Ownership: There are deals splits dedicating percentages for Account Owner, Account Manager, Scheduler and Recruiter.
Second CSV export has the deal's breakdown and when they were paid.
The calculator needs to calculate the Personal Billing Number for each employee based on the Values in the spreadsheet if they match the ownership criteria per record.