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

Closed

Description

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.

Skills: Database Programming, Excel

See more: iwork numbers spreadsheet converted excel format, extract database information excel, extract specific information website excel, extract excel format, excel extract web information, extract website information excel, extract excel owner information, extract sort information excel, extract excel images, visual basic text extract necessary information excel, extract excel data perl, extract excel spreadsheet mysql, mp3 extract excel, extract excel, visual basic code extract excel data

Project ID: #12230695

Awarded to:

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 More

$200 USD in 4 days
(1 Review)
1.0

46 freelancers are bidding on average $162 for this job

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 More

$200 USD in 3 days
(366 Reviews)
7.7
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 in 0 days
(292 Reviews)
7.0
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 More

$155 USD in 3 days
(278 Reviews)
7.1
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, More

$150 USD in 3 days
(120 Reviews)
6.6
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. More

$166 USD in 4 days
(126 Reviews)
6.6
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 More

$200 USD in 3 days
(128 Reviews)
6.5
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, More

$222 USD in 7 days
(89 Reviews)
6.2
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 in 3 days
(117 Reviews)
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, More

$163 USD in 5 days
(65 Reviews)
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 More

$200 USD in 8 days
(96 Reviews)
6.1
pandey2008

Hello sir,we have 8 member team and we can start the work right now just check my review u can see and u never disappointed with my work quality,delivery and price. Awaiting your answer.thanx

$111 USD in 2 days
(174 Reviews)
6.4
$150 USD in 3 days
(59 Reviews)
5.8
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 More

$98 USD in 1 day
(58 Reviews)
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 More

$111 USD in 3 days
(51 Reviews)
5.3
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 More

$111 USD in 3 days
(65 Reviews)
5.7
zebracaro

i can do it for you quickly and exactly

$150 USD in 3 days
(70 Reviews)
5.5
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 More

$100 USD in 1 day
(67 Reviews)
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. More

$156 USD in 3 days
(39 Reviews)
5.5
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 More

$300 USD in 3 days
(31 Reviews)
5.4
manikhossain1111

A proposal has not yet been provided

$140 USD in 5 days
(18 Reviews)
4.4