I use thundertix for event sales and ticket inventory management for tours.
I am able to export spreadsheets that have information about my sales and clients, but the format that they are exported in is not very usable to me. I need the information to be consolidated into specific reports.
I am going to include an example of the spreadsheet that I get from thundertix and another couple of spreadsheets that we use with google docs that is much closer to the type of reporting that we need.
In broad terms, I need a report for each individual trip that we do that shows name of passenger, their email, gender, occupancy type, survey responses amount paid, special notes, etc. All this information is present in the spreadsheet that I can export from them, but it is not in a format that I need. I cannot get a report for each trip (and trip date), I cannot get a report that shows total sales by a particular agent, total sales at a particular location.
I need to be able to upload these spreadsheets to a database that recognizes new entries (doesn't duplicate) and organizes and updates the information of the custom reports.
I included an example of the trip reports from previous system we used. This shows what the reports for the various trips should look like (though there would be more field, such as for email).
I didn't include here the master spreadsheet that we use to keep track of sales over time, but I would want these individual trip reports to be compiled in an on going tracking of sales over time for each trip, by school, by agent and other parameters.
I am sure to get many automated responses. Help me to give my attention to you who have actually read my project details by using the code word 'Database Pro' as the first word of your bid.
Database Pro
I am currently a database administrator and a freelance database programmer. I am also a freelance java programmer. Regarding your project, I think I can help you with that. I am thinking to create a program so that in your future reports, it will not be hard for you to generate your desired report. I am looking forward to working with you.
$111 USD dalam 3 hari
5,0 (1 ulasan)
0,8
0,8
11 freelancers are bidding on average $144 USD for this job
Hello Sir,
We are a working team with excellent experienced and skilled operator with lot of experience in this segment,since last 4 years in Freelancer.com, i have gone through your project description, its really a simple task, we can make a well formatted,error free list.
Sir, we are waiting for your reply for communicate also like to make a sample if you allow by a single reply.
Thanks
DG
Database Pro
Hi,
I would love to work on this project. I have 8 years of experience in Microsoft Excel including working with excel modeling, dashboards and macros.
Please contact with further details if interested.
Regards
Raghav Bansal
Hi there - My name is Paris.
I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
Hello,
I am interested in this project. Your requirements can be easily met using MS Access.
Please let me know when we can discuss further about this.
Thank you.
Hi
I have read your job description ...
I am highly experienced in this field.
I did over 100 similar job perfectly like this one .
I can fulfill your requirement .
High quality work goes cheap .
I assure 100% satisfaction with my work.
lets start now .
Thanks.......
Database Pro
Hi,
I'm an expert VB / Excel / Access / database programmer and can do the job for you. I can develop an Access database, with forms, queries, reports, SQL / VBA code and the needed functionality to make your new database import the data from the Excel files and produce the reports as needed.
I can deliver in 12 days or less, and will deliver frequent updates as work progresses. Good quality work done.
Fixed price for this job: US$400; with free support after the job is complete for any fixes. Updates will be charged a nominal rates.
Thanks for considering my bid.
Bests,
Larry