Excel Spreadsheet Expert to parse and organize a 190K database
Budget: $8 – $15 USD
Short-Term Excel Specialist Needed for Quick Data Analysis
***Important: This task must be completely finished by 4PM Pacific Standard Time so please do not apply unless you are able to accommodate that timeline***
Looking for an Excel expert for a brief engagement involving data analysis. Ideal candidate should be:
Proficient in handling and analyzing large datasets in Excel.
Detail-oriented with a keen eye for accuracy.
Experienced in using advanced Excel features, such as pivot tables and complex formulas.
Project Details:
I will be giving you the parameters in real time as we move through the data
Sample Data Attached
Duration: A few hours
.
Objective: Analyze provided datasets and extract key insights.
Deliverables: Comprehensive Excel report based on analysis.
Here are the first set of instructions for your reference- this was written with the expectation that I wil be available in real time for any questions and to approve each step.
Actual Project Objectives'
Create 3 new Col.
1. Total buyers represent
2. Total sellers represented
3. Total transactions (add 1&2)
Rank all the agents by total transactions
Separate the list into two pieces
1. Agents that have represented 9 or more total buyers and sellers
And any agents who may have less than nine total but have represented at least three in 2023
Any agents that don't meet either of these criteria are to be removed from the main list and placed on a separate list.
Let's keep our 9+ agents, which I'll refer to you as veterin agents, separate from the "three in 2023" which I'll call the rookie agents from now on.
So now turning our focus to the veteran agents list. I want to get and indication of which price point they deal in.
So for each of their 9+ transactions, there's a column called "closed price" and we're just going to take the average of all of their closed prices... In other words add up the close prices for each of their transactions, regardless of whether they represented the buyer or seller and divide by the number of transactions. if they happen to represent the buyer and the seller count that close price twice for the purposes of the average.
Then add a new column to the master spreadsheet called average sale price.
Next we're going to focus just on the transactions where an agent represented the seller and for this metric, we are only including agents who have represented at least six sellers in total.
So for each of their 6+ seller representing transactions, we are going to take the close price and we're going to subtract The dollar amount that is in the "concessions amount" Column and then we're going to divide that number by the original list price which will leave us with a number like .9 or .95 which we'll call "percentage of list price" Then we're going to take an average by adding each value and dividing by the number of transactions...
Finally will create a column called average percentage of list price which will reflect the average
If you're efficient, skilled, and available for a quick turnaround, I am looking forward to speaking to you. Thank you very much for you time and consideration,
Steve
***Important: This task must be completely finished by 4PM Pacific Standard Time so please do not apply unless you are able to accommodate that timeline***
Looking for an Excel expert for a brief engagement involving data analysis. Ideal candidate should be:
Proficient in handling and analyzing large datasets in Excel.
Detail-oriented with a keen eye for accuracy.
Experienced in using advanced Excel features, such as pivot tables and complex formulas.
Project Details:
I will be giving you the parameters in real time as we move through the data
Sample Data Attached
Duration: A few hours
.
Objective: Analyze provided datasets and extract key insights.
Deliverables: Comprehensive Excel report based on analysis.
Here are the first set of instructions for your reference- this was written with the expectation that I wil be available in real time for any questions and to approve each step.
Actual Project Objectives'
Create 3 new Col.
1. Total buyers represent
2. Total sellers represented
3. Total transactions (add 1&2)
Rank all the agents by total transactions
Separate the list into two pieces
1. Agents that have represented 9 or more total buyers and sellers
And any agents who may have less than nine total but have represented at least three in 2023
Any agents that don't meet either of these criteria are to be removed from the main list and placed on a separate list.
Let's keep our 9+ agents, which I'll refer to you as veterin agents, separate from the "three in 2023" which I'll call the rookie agents from now on.
So now turning our focus to the veteran agents list. I want to get and indication of which price point they deal in.
So for each of their 9+ transactions, there's a column called "closed price" and we're just going to take the average of all of their closed prices... In other words add up the close prices for each of their transactions, regardless of whether they represented the buyer or seller and divide by the number of transactions. if they happen to represent the buyer and the seller count that close price twice for the purposes of the average.
Then add a new column to the master spreadsheet called average sale price.
Next we're going to focus just on the transactions where an agent represented the seller and for this metric, we are only including agents who have represented at least six sellers in total.
So for each of their 6+ seller representing transactions, we are going to take the close price and we're going to subtract The dollar amount that is in the "concessions amount" Column and then we're going to divide that number by the original list price which will leave us with a number like .9 or .95 which we'll call "percentage of list price" Then we're going to take an average by adding each value and dividing by the number of transactions...
Finally will create a column called average percentage of list price which will reflect the average
If you're efficient, skilled, and available for a quick turnaround, I am looking forward to speaking to you. Thank you very much for you time and consideration,
Steve