Extract information from Excel spreadsheet to provide information in a useful format

Completado Publicado hace 7 años Pagado a la entrega
Completado Pagado a la entrega

Please do NOT RUSH.

I will NOT review any submitted bids until 6 PM New York time on November 30th

The attached SAMPLE Excel spread sheet includes 152 rows of data and many columns of data (not all columns of data will be used or relevant.

The real spreadsheet will include one to three thousand rows of data however the rear spread sheet data will increase over time.

I wish for your way of viewing the data to be compatible with future Excel spreadsheets I tell it to reference.

Every single potential client who calls our office has to identify the property they are under contract to purchase otherwise my office can not provide them with a price quote.

There are two types of data.

There are Potential clients "P" (The Scheduled Date

column will be blank for these) and those who turned into real Clients "C" (The Scheduled Date column NOT will be blank for these because the client scheduled a date and time for the home inspection)

I want you to design some way for me to be able to know and to have a custom report or a way to obtain the data to gain the following information:

For One, Two and Three listed below breakdown number of P that turn into C MONTHLY (so I can see how my price variations effect inspections booked

Report Variation One Breakdown number of P that turn into C MONTHLY

By List Price Column letter P

0 to 299,000

300,000 to 399,000

400,000 to 499,000

and every hundred thousand up from there

Report Variation Two Breakdown number of P that turn into C MONTHLY

By Order Fee column K

$500 to $549

$550 to $599

and every fifty dollars up from there

Report Variation Three Breakdown number of P that turn into C MONTHLY

Inspections By Created by column B to easily see what creator is booking more inspections as a percentage on a monthly basis.

Once again I am looking for you to create an "overlay" type program I can run on a monthly basis as the Excel spreadsheet changes.

The number of rows will change every month however the columns will remain consistent.

Yes, I know reformatting the dates will be a challenge.

I have added this to answer questions that have come up in order to make sure everyone is bidding on exactly the same job.

Please keep in mind my specification indicates I will be downloading new information into Excel for different time periods as time goes on and that your "program" must continue to work regardless of the time periods I download.

The way to separate the C (clients) from the P (potential clients) .... the C (clients) will have a Scheduled Date. Those who are P (potential clients) will NOT have a Scheduled Date

I want to make sure you know what you are bidding on because you have to make money and I have to be happy or no one will be happy.

My goal is to use the extracted data to figure out why (if there is a pattern) some potential clients (those who do not give me money) become clients.

Every few weeks I will download new data, I wish for the overlay you create to be usable not only for the provided sample Excel sheet but for all future ones I download without further changes or modifications.

For those of you who asked.... php is fine, I have a server and will be able to upload for php to be executed without an issue

My goal is to use the extracted data to figure out why (if there is a pattern) some potential clients (those who do not give me money) become clients.

Every few weeks I will download new data, I wish for the overlay you create to be usable not only for the provided sample Excel sheet but for all future ones I download without further changes or modifications.

For those of you who asked.... php is fine, I have a server and will be able to upload for php to be executed without an issue

In response to questions the information I am looking to extract will be for various unknown to me at this time monthly time frames.

Each month must have its own summary

Please see the attached file for two sample months however the overlay must be designed to work for months from June 2015 on forward.

My "sample" attached is about as ugly as I know how to make it. My hope is you can do something nicer

Since I have not been able to iron out details with other bidders I will set a new award deadline of 6 PM New York time Tomorrow December 2, 16

I have revised, cleaned up and updated my project specifications in response to questions have been asked.

What I am looking for is a way to determine how many inspections are being booked by home sales price. I wish to figure out if my prices may be too high for one home sales price segment causing me too book too few inspections from those buyers.

2.) What I am looking for is a way to determine how many inspections are being booked by home inspection fee. I wish to figure out if my prices may be too high for one home sales price segment causing me too book too few inspections from those buyers.

The Inspection fee I wish to use for the report is the inspection fee shown in column P. Fees listed in columns q r s t u v and w are not part of the information I am interested in

Please realize the data I download in csv type format will be for different date ranges and each date range must sort out by month. Some reports may only have one single month others may have 120 months.

The latest data sample file:
ISN Potential vs. Scheduled May 15 to Nov 16.xls

The latst Concept of layout
ISN report layout 2.xls


Programación de bases de datos Excel

Nº del proyecto: #12230695

Sobre el proyecto

46 propuestas Proyecto remoto Activo hace 7 años

Adjudicado a:

WestonPalmer

I have reviewed your updates and I can still do the project for the original bid. The percent is a little confusing since at the end of the month the clients will be potential or confirmed. How would you determine th Más

$200 USD en 4 días
(1 comentario)
1.0

46 freelancers están ofertando un promedio de $162 por este trabajo

jaylancer43

Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among Más

$200 USD en 3 días
(366 comentarios)
7.7
HongGiang

Hello sir! I'm expert on data entry, data processing and have more experience in the sorting data. I'm very proficient in the use of spreadsheet, function, macro in Ms Excel. Please take a look at my profile on Freelan Más

$155 USD en 3 días
(278 comentarios)
7.1
cgullapalli

Hi, I am good at Excel and vba. I have understood the scope of the work. Looking forward to work with you. Thanks.

$150 USD en 0 días
(292 comentarios)
7.0
mirniyazuddin92

Dear Sir/Ma'am, I am a Web research, Data Entry & Webs Scrapping expert. I checked and understood your requirements. I can handle this job very well to your appreciation. I can find and extract the information Más

$200 USD en 3 días
(128 comentarios)
6.5
aarifakhtar

Hi: Here's my understanding of your requirements: You download data from your CRM software every week. You want to use that information to generate tables/charts which help you identify patterns and generate insights. Más

$166 USD en 4 días
(126 comentarios)
6.6
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$150 USD en 3 días
(117 comentarios)
6.3
mantislin

Dear sir, I am scraping expert, I have did too many scraping projects, please check my reviews then you will know. Can you tell me more details? then I will provide example data/script for you. Thanks, Más

$163 USD en 5 días
(65 comentarios)
6.2
cugamelover

I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, Más

$150 USD en 3 días
(120 comentarios)
6.6
shikhamehta

Hey, I reviewed the requirements brief you shared and here is my understanding: In the given data, out of 152 rows, 57 have a non-blank "Scheduled Date". Now, you need a way to easily tell you that out of these 57, Más

$222 USD en 7 días
(89 comentarios)
6.2
dpune

Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. I have completed more than 290 projects. Please look at the feedback left by my employers to know more about my work. Wai Más

$200 USD en 8 días
(96 comentarios)
6.1
kevivu

Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 75 projects, almost 70+ are complex VB/VBA/.Net/Webscrapping projects, hence i ca Más

$111 USD en 3 días
(65 comentarios)
5.7
zebracaro

i can do it for you quickly and exactly

$150 USD en 3 días
(70 comentarios)
5.5
nagybatonyi

Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macr Más

$98 USD en 1 día
(58 comentarios)
5.7
macroPOL

I've read Additional Project Description. Yes, macro will be flexible. You can use it the future (for next txt data file). Hello, I am Excel and VBA expert. I saw the file and read carefully the descriptio Más

$111 USD en 3 días
(51 comentarios)
5.3
ferozstk

Hello, After reading your project details I believe I'm suitable for this Excel project. As I'm expert on Excel with more than 5 years experience. Please feel free to contact me. I am looking forward to hear fro Más

$300 USD en 3 días
(31 comentarios)
5.4
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Más

$100 USD en 1 día
(67 comentarios)
5.2
sonarkaushik

Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. Más

$156 USD en 3 días
(39 comentarios)
5.5
manikhossain1111

A proposal has not yet been provided

$140 USD en 5 días
(18 comentarios)
4.4
citijayamala

Expert in Excel, Excel formulas, and all excel functions, macros, lookup concepts. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Can complete on time with Más

$155 USD en 3 días
(28 comentarios)
4.5
vsprybhanu

Hi, Experienced Excel VBA and VB.Net Programmer. I have read your instructions carefully and saw attached excel file. I will create consolidated report as per your instructions through VBA macro program and i Más

$120 USD en 3 días
(31 comentarios)
4.1