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.
50 freelancers are bidding on average $2300 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
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.
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