Dynamic Pricing System

Closed

I need a piece of database software written for either MS Access or PHP/MySQL (explain your choice) that will dynamically generate a resale price for real estate properties as they are added to the database. I need it to filter out which properties are listed at 20% or lower of the average sales price per sqft for that particular subdivision. Please add in some extra time for tweaking this workflow. Here is the workflow as I imagine it at this point:

Download property data into database (MySQL or desktop MS Access file), with current status (A=active,P=pending sale, S=Sold, etc). See attached spreadsheet for data setup (header "S" = current status).

-- Each upload can be assumed that it’s the most recent data, so update data if the ML# matches one already in database. Data that may change: status (“S”), list price.

-- The ML# will be unique

-- Data will be in CSV format

-- Add/update field "last update", date and time each unique record was updated or added

-- Add/update fields “LP-Sqft” and “SP-Sqft” to be calculated on updates

-- A, AC status generates “LP-Sqft” number on new and updated records

-- S status update generates “SP-Sqft” number field for that ML# record and stored

Generate this report on demand: pull up all records where status=A, AC, and where the list price/sqft is <80% of that property's "SUBD" average SP-Sqft

To calculate unique SUBD values:

-- Average SP-Sqft for those within the same SUBD is viewable at the top along with subject property information

-- select usable criteria for SUBD pricing using these fields: MAPSCO page, Zip (within 1 or 2 numbers), then middle 8 characters of SUBD using %LIKE%, and records updated within 9 months. (Note: we may need to modify how this searches depending on results). This is to narrow down records to those that are nearby to the subject record and are in the same subdivision. If the SUBD is less than 8 characters, use the entire field.

-- question: SP-Sqft for each SUBD is updated upon uploading and saved as field in a separate SUBD table, or process these calculations upon demand?

-- Report’s table show last 9 months of records where status=S (or all of them, if less than 9 months of data), showing the SUBD name for visual inspection for each record. Table is sortable by SUBD. Fields for results table: ML#, Address, City, Zip, Property Type, Bd, FB, St, YrBlt, Sqft, SoldPrice, Sold Price/Sqft, Frcslr, Subd.

-- Check off properties to calculate SP-Sqft (select all/none buttons); automatically selects all

-- SP-Sqft average is calculated by adding Sold Price numbers, then dividing by the sum all Sqft numbers of those selected records

Skills: Microsoft Access, PHP, Software Architecture

See more: dynamic pricing system, dynamic pricing software, we-top dynamic, we top dynamic, visual workflow, new pricing, format pricing, dynamic sum, dynamic p, check point software, system dynamic pricing, desktop fb, lp , field inspection, dynamic pricing, can i resale, active filter, update mysql using csv, update mysql csv php, mysql select filter, update status php mysql, average php mysql, dynamic buttons, php add record mysql table, workflow setup

Project ID: #4014297

Awarded to:

VBAWhizz

Hi, I would use Access to do this - please see PMB for further details - thanks.

$400 USD in 10 days
(7 Reviews)
4.7

18 freelancers are bidding on average $463 for this job

buraqtech

Check your PMB for details!!!

$685 USD in 18 days
(59 Reviews)
7.5
OneClickDevelope

Hello, Good to see project from you again :) do let me know if you have any comment and i am ready to start. Thanks, Ali

$500 USD in 8 days
(103 Reviews)
6.5
rhomeu

MS Access expert here. MS Access program is the best solution for this.

$450 USD in 2 days
(40 Reviews)
6.5
mkinternation

Hey there, I have over 6 years of experience in PHP/MySQL. Please check my PM for details.

$500 USD in 1 day
(83 Reviews)
6.2
jhaynes75

Professional software developer with over 12 years experience. Please see PM.

$475 USD in 14 days
(29 Reviews)
6.1
NiceDeveloper

Hi, I'll give you a desktop app plus database with various reports form. Please check your inbox for more details and sample.

$450 USD in 10 days
(22 Reviews)
5.1
winnet21

Hi, I have experience with this project, I happily if work with you in this project. Regards

$400 USD in 20 days
(15 Reviews)
5.0
Altantsetseg

Hello. I will provide you with bug free professional solution.Please consider my private message.

$410 USD in 4 days
(18 Reviews)
5.0
bistanil98

Need more detail,can we discuss this,for more detail,check PM. we have more than 10 year of experience in web development,so we can handle this project.

$420 USD in 18 days
(9 Reviews)
4.8
stefanache

Hello, Please consult your PMB. Thanks.

$425 USD in 15 days
(15 Reviews)
4.8
amnmttl

Hello, I have read your requirements carefully and would like to work on this interesting project. Please check PMB for details of the solution i propose. Aman

$400 USD in 10 days
(18 Reviews)
4.6
SAP2907

Sir, we are professional freelancers and can do this job using MySQL preferably as backend. We have made several database connected interfaces before. Please contact us for any other info. Can provide you with a quick More

$325 USD in 7 days
(6 Reviews)
3.7
amfuries

############# ****** WE HAVE DONE THE SIMILAR APPLICATION PLEASE CHECK THE PM ****** #############

$400 USD in 2 days
(3 Reviews)
3.6
FoxproGuy

Hello, I am an MS Access developer for a commercial accounting software firm.

$750 USD in 10 days
(0 Reviews)
0.0
Techsmelter

We are technology firm with ample resources to finish this project in time and to ur expectations

$500 USD in 40 days
(0 Reviews)
0.0
pomalley

Thank you for the opportunity to submit my proposal for your project entitled "Dynamic Pricing System" . About Me: I have been an Oracle professional for the past 10 years and an IT professional for the past 20 More

$500 USD in 30 days
(0 Reviews)
0.0
rubenimc

This is possible with Zoho Creator an online equivalent to Ms Access. Ping me if you are interested

$500 USD in 3 days
(0 Reviews)
0.0
DaddyWarbucksEsq

My name is George Panko, dba The Immaculate Cohhection. I am relatively new to this freelancer site, but am well-established on Guru.com. Since 2001, I have specialized in designing, developing, and maintaining MS More

$250 USD in 10 days
(0 Reviews)
0.0