Fermé

Excel file to DB

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

Compétences : Saisie de Données, Traitement de Données, Excel, Visual Basic, Web Development

en voir plus : how to import data from excel to sql server, import data from excel to mysql using command line, excel to mysql converter, mysql for excel, import excel to mysql workbench, import data from excel to sql server using query, inserting data from excel to sql table, excel database examples, creation excel file, convert excel file address book, program sort excel file, search excel file vbscript, save datagrid excel file, create excel file visual, contact excel file, excel file dog breeds, excel file example vehicle, excel file merger vbscript example, example reading excel file, example vba code import excel file

Concernant l'employeur :
( 0 commentaires ) Seven Hills, Australia

Nº du projet : #17809910

54 freelance font une offre moyenne de $2281 pour ce travail

TypingxpertRehan

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 30 jours
(1358 Commentaires)
9.0
schoudhary1553

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 30 jours
(295 Commentaires)
7.7
ponnarasiBabu

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 30 jours
(400 Commentaires)
7.4
zekovicm

Hi there, I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio and form Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 30 jours
(103 Commentaires)
7.0
paris2785

Hello! My name's Paris and I was glad to see that you're looking for a database developer. You mention that you need somebody to transform your Excel spreadsheet to a database. I don't know how big your Exce file is, Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 14 jours
(161 Commentaires)
6.8
dpune

Hi, I have more than 14 years of Excel, various kind of databases and web design exp. Let us discuss more details so that I can estimate cost and time better. I have completed more than 310 projects. Ple Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 30 jours
(180 Commentaires)
6.5
vsprybhanu

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 30 jours
(73 Commentaires)
5.3
amitmishra2u

Hi, We can start now, We have gone through your project ("Excel file to DB") requirements and found myself as a best available freelancer for this project. We can create front web page so you can directly insert y Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 30 jours
(2 Commentaires)
5.2
khoddam

Hello, Do you have a server now? Is the database system public or for some people to update or view the data? The type of scripting language depends on the type of server and normally is php and MySqL. I am ready t Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 20 jours
(19 Commentaires)
4.7
jasalaz100

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 21 jours
(27 Commentaires)
4.8
expertcoder1vw

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 45 jours
(13 Commentaires)
4.6
yanghua8031

Hello, I've read your description and fully understood. I have good skills and experiences of database importing and managing over 4years I can export excel to db easily and manage all database with perfect web backe Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 30 jours
(1 Évaluation)
4.6
supergana

Hi Jason - My understanding of your problem; What you have is a rate computation and invoicing solution. You have the master list of services, the rates available. On top of this you provide the hourly effort spent Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 30 jours
(23 Commentaires)
4.5
urmate

Hi There I've excellent programming and development skills and knowledge. I can provide an efficient, perfect, well documented development of your Programming and Computer project according to 100% accuracy and re Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 30 jours
(29 Commentaires)
4.3
vijayvizzu7

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 30 jours
(6 Commentaires)
3.8
adicoman

Hi, I am very interested to work on your project. I have 15+ years experience in Database/Web Development using a large variety of programming languages, frameworks, database architecture, APIs, CRMs, ERPs, mobi Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 30 jours
(3 Commentaires)
3.8
rIbrarahmed

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(16 Commentaires)
4.1
jayamsoft

Hi, I went through the project description and i can help you to make it more easily manageable and can also help you for analytics reports also. I am available online to discuss and clear your doubts or queries Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 60 jours
(5 Commentaires)
4.2
AndroPetre

Hello, my name is Daniel, nice to meet you. I am an experienced web designer & developer and I`m really interested in your project. Quality and speed are my leading stars and I am one message away from being at your se Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 30 jours
(4 Commentaires)
3.6
dionisiotumbaga

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 10 jours
(4 Commentaires)
3.3