I work at a high line auto dealershhip in the US. The dealership leases roughly 150 - 200 cars per month. The dealer wants to know up to the minute:
How many people are due to come off leaase this month, next month up to 6 months from now.
How many people did we contact (speak with on the phone)
How many people turned in their car only
how many people renewed (either kept their car or bought a new one)
how many people did we set an appointment with to preinspect their vehicle.
How many bought a different brand?
The data is supplied to us by a website that allows us to import via excel with the following columns:
Last Name/Company Name, First Name, Co-signer, Address City, State, ZIP, Home Phone, Work Phone,Email, Account No, Vin, Make & Model, Year, Color, Contract Start Date, Maturity Date, Payoff Good Thru Date, Security Deposit, Monthly Payment,Payoff Amount Money Factor, Term, Contract Type, New/Used, Residual Value, Contract Miles, Client Advisor, Contact Status, PreInspection
I would like to either have an Access or Excel report that I can just drop monthly imports into that will allow me to answer the above mentioned questions
I have 5 years of experience using Access heavily for inventory management at a large health insurance company. I can build a way to automatically import the data from the spreadsheet you specified in the requirements Daha Fazla
39 freelancers are bidding on average $138 for this job
Over ten years experience in developing Excel/VBA solutions.
Good afternoon, I have close on thirty years’ experience, whilst much of that is overkill for this project, it does mean that I can recognise the real needs behind a specification. I would recommend an Access s Daha Fazla
Access is the best solution to your problem sir Rod and its not that complicated to use. Check PMB for details.
Hi, I can deliver a solution in excel, access or a .Net application - which ever is your preference.
Dear Sirs/Madams, I can do this job. Please contact me to work for you. Thank you for your reading, Cam Thuy
I am excellent at creating an application in Excel/Access to do these tasks. Thanks.
Hi. I am a post-graduate in Marketing. I would be able to help set up the required analytics. Please check your PMB.
I developed numerous similar systems for use by barclays whereby we obtained telephone survey data as a spreadsheet and then generated daily reports by opening a linked spreadsheet. I would write you a spreadsheet w Daha Fazla
I am an accounting manager with vast experience in reports. I usually export data from quickbooks to an excel sheet and process the information for decision making.
READY TO START !!!! I have relevant experience for this work so that i can do it successfully if you will give me an opportunity. Thank you