Excel file to DB
$1500-3000 AUD
Paid on delivery
Hi,
Currently we have a multi sheet excel file that contains what we call as monthly charges. We manage a service company and each month we enter the information into this file to charge our users, we want to look at making this into a DB and use a web page to manage it. On top of this, we currently override this file each month with no historical data, we would like to possible keep this if feasible. At the moment our historical data is taking a copy of each month once completed and then override the data.
Some important sheets are:
- Rate; we keep a list of services and products we offer and how much we charge
- User Info; A list of users that have location, company and cost centre (we have multiple companies and cost centres)
- Invoice Summary and Invoice Detail; Pivot tables that collect all the charges and easy to view for the end users (Summary is by Company/Cost Centre and Detail is by Company/Cost Centre/User
- There are another 22 sheets within the excel document that we are using to charge different ascepts out to either the entire company the cost centre or to the specific user. All these sheets pull information like the rate from "rate" sheet.
- There are some excel conditions like ifs are used to calculate some more complex rules, for example. Our helpdesk charge is a a flat fee per month of $50 which includes 1 helpdesk call per month, after that each call is $85 per hour.
The solution we are looking for will also need to be designed that we can add users, companies, cost centres, do general maintenance and etc.. We were thinking a potential python with django solution however open to others.
Can supply excel file, but contains some sensitive info once project is a go head.
Thanks Jason
Project ID: #17809910
About the project
43 freelancers are bidding on average $2385 for this job
i am interested in completing your project,if you like to see my experience please visit my profile once, waiting to chat in details in private thanks
Hello, i have read your project details and i can help you with 100% quality and your satisfaction. I have delivered more than 400 project with client satisfaction. Please see my profile . I have more than 5 years o More
I read your requirements, I am based in california and my experience is below which I hope will be suitable to carry out this project Desktop Application Development in .Net and C++ Technology , Data entry , Excel A More
Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I can develop a complete system for your requirements. However, it can be explained in more details when you share da More
Hi, I am Ibrahim and I can work on this excel sheet, once I get thorough details, we can start to build this model and set up milestones too. Regards, Ibrahim Anjum
hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I feel fit myself for this project. please contact with me. Thanks.
Hello, I hope you are well. These are my strengths: Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after com More
Hi, You should not make this a web-based program. Rather, you should make it a local desktop application that will work in your company only. I can develop this for you as a Windows desktop application, that is mult More
Hi, I am interested in this project. I have considerable expertise in the design and development of MS Access databases. I would be happy to discuss about your requirement. Regards.
Hi I have 10+ years of experience in Advance Excel, MS Access, VBA, Macros and other office integration development. I am sure i can handle your request
i can build this solution for you web , so you can use it everywhere and update simple and with user management so you can track the same stuff more practical