Excel database with input and output forms that allows multiple users accessing simulatenously
€30-250 EUR
Zavřený
Zveřejněno přibližně před 6 roky
€30-250 EUR
Zaplaceno při doručení
I am managing a call center with close to 200 people. For each request they receive they have to register 15-20 fields of information through an input form (let's call it Form A) in Excel. The information supplied on Form A is compiled in an Excel table, containing the fields of the input form. Then, when an operator needs to address a certain request, there is Form B, which reads information from the Excel table and displays it, with the operator being able to change part of the information (e.g. status of the request), which then updates the Excel table.
Our problem right now is that the Form A and Form B are based in an individual Excel file, where multiple users access simultaneously. This is generating errors when recording information.
What I need is an Excel based "system" where:
- There are only 3 files: Form A, Excel Table and Form B
- Users can access simultaneously to Form A or Form B and edit information, which then saves it to the Excel Table
- Access to Excel table is limited to one single user
I know there are better solutions than using Excel for this, but right now we will have to go with Excel.
I'm available for further clarifications.
Best regards
jorge Santos
Hi there.....
Warm Greetings
We came along with your request for Excel database with input and output forms and we reviewed your project description. We'd like to help you with confidence and satisfying results...
We have professionals working here with 100% results and more creative and renovative ideas for our clients !
We have worked on several similar projects before!
We are offering our services for more than 5 years in the field of Data Processing, Database Programming, Excel, Microsoft Access, Visual Basic
We have worked on 300+ Projects. Please check the profile reviews
Feel free to message us to discuss briefly about your project !
Hi, can you please tell me : 1. If you already have these forms and table ? (you current system). Also tell me how you are currently working ? (how the users access the same file at the same moment) . Thanks
I am an excel expert and have completed many complicated excel related tasks. Can provide you sample if required of my past and current work. Read the project specs - Excel database with input and output forms that allows multiple users accessing simulatenously . Looks like this project is feasible. Just want to understand and make sure some of the requirements ..so kindly open PM to discuss work and budget..I am based in california and can talk over phone to understand the requirements and will provide support though out the project till you are satisfied with the work..
Regards,
Hello Jorge!!
Hope you doing good. I have a better solution so that the file will be accessible to your complete team and whenever you need to update the data will automatically gets update and at the same time it will be easy accesible to your team.
But for discussion you need to reply to my bid and I will be able to share my suggestion and will discuss more.
Looking forward to hearing from you!!
Thanks
Brad
"I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work.
I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. "
Hi Jorge,
I have 6 years of experience in Excel formula,macro,VBA and I will automate your excel sheet.I understood what you have mentioned all I need the data
Good day. Even though you said that excel is the right solution for this problem I will just put my bid here and will strongly suggest to use a database system such as MS Access for this problem. The data will be more secured and multi-user access will be inherent to the application. Feel free to message me whenever you change your mind regarding the platform to use. Thanks and have a nice day.
Hello,
I am proficient with Excel and VBA and would love to help.
Can you tell me which version of Office do you use?
Please contact me for more information.
I have excellent command on MS Excel. I can create the required database using Excel only so that multiple users can access it at a given time. I have completed complex projects in Excel before . For instance
- Get match details, odds and stats of tennis matches and place bet automatically on betfair, pinnacle and tennisinsight websites
- Built a POS and inventory management system
- Built a hotel price comparison that pulls data using the website's API
- Built a complex shift allowance calendar and calculator
You can see the reviews of the same in my profile
As per your requirement MS Access database would be best solution.
Why Access:
Multiple user enabled, at a time 200 people can enter their data into one place.
User specific login screen with individual authorization.
keep your backend into secured network path with high security.
2GB of data storage.
excellent output of reports. track each records as per your requirement.
I can create the MS Access database for you. let me know if you want to proceed.
hi, I can develop a real system to capture and browse the info what you need to store using a real database also I can export data to excel file, don't pay twice let me build a database system for you.
check my portfolio.
only need know what fields you need to save.
Hello there, after reading your project description and with a drive for excellence, with a keen attention to details and with more than 10 years experience working with Microsoft office especially excel vba, i can do the best database job in the least time starting right now. I will do all and extra to ensure that you won't regret giving me this project.
Please message me and lets talk more about your project.
Thanks
Dear Sir,
Your problem is easy to be solved just convert your excel sheet to Access database and let the database work as multi user system, all your team work together without any conflict and they all be updated with the current version of data.
Kind Regards
No no no no no no!
Excel will NOT work in a multiple user scenario. Let me build you a quick PROPER database solution which multiple users can access at the same time.
Contact me
Maurice Marinus
Hello there, I am an IT expert specialized in advanced excel macro and database management. We can create a user-friendly database that will suite your needs. We can clarify further over chat
Hello,
I am web developer and also know excel. Now what you want can not be developed using excel because it does not meant to be used by more than a person at a given time.
These 2 forms and one table can easily created and executed on a web based platform which will not cost you much. If you have a local networking done you can set a local server or if you have basic internet connection than its just $10-15 USD per year for a hosting and the charge for development is just 180 - 200 EUR.
I know you have to use excel but think about it as a future proof solution.
Thank
Have a nice day
Hi Employer,
I have read your description and been interested in the project. You can develop the web-based application for your staff or the desktop application to run in your organization. May you share me the Form A and Form B files (excel format)?
I'm ready to discuss and start on the project now.
==================================
Please discuss before awading the project.
Hi dear, I've just checked your requirements.
I am very interested in that sort of thing and have a lot of experiences of the field like that.
If you hire me, I will be able to finish your project earlier ahead the appointed time and in timely manner. That will be absolutely perfect.
My bid always is cheaper than other, but it will be changed little by little according to your details and the worth of your project.
I can be willing to satisfy you with startling result.
Thanks for your reading.
*Note: Don't award me your project without consulting me.
I'm honest with my work and I have a good grip on Excel and Google docs, can automate reports by the help of formula and functions.
Can complete tasks on estimated time mentioned by client, also will not demand to pay for extra hours (if I'll sped extra time on projects).
