Database & Checklist Automation - open to bidding


1. Need to a UserForm that integrates the QC and SOP checklists I made in an Excel sheet. This should be an interactive so that employees can click a box & it will assign a certain value. Everyone will store with a score of 100 and if I select NO, it deducts point.

2. The checklists will collect data on several different workboos automatically & the checklists should be able to be used over and over again without the data being erased.

3. RIght now, I created several functions and relationships between certain excel sheets but I'm having trouble automating it all using Macro/VBA so that a score can be input in one locaion and it will automatically input that score in all other locations that will then calculate a final score.

3. These inspections are based on a 2-week period.

4. I also need a tool that will objectively randomize employee IDs, Names, and applicable Scores in small groups, all at once. In other words: if I have 200 total employees that are borken down into groups of 15, which are assigned to a specific Manager, I want to be able to randomize all 200 people at once but still attach them only to the manager they belong to. The same associates will be inspected by the same Manager each 2 weeks, but when they'll be inspected will vary on the randomizaiton.

5. I used the =RAND() function to randomize 200 people but then I realized that I would not be able to identify which employee belongs to which Manager. Once randomization is done, their names should be automatically populated onto an individual schedule hey work in. For this purpose of this project, I used fake names and employee ID #s.

6. This database/program will be used by warehouse managers, and the data has to be collected to run metrics from and be used for training purposes.

7. On the "Quality and Safety Checklist" excel, I have built the 2 checklists we will be using and the simulated calculation. The data input in the Quality and SOP checklist should populate in the calculations sheet and based on that, populate on the Final Score workbook every other Sunday as the final report.

8. The problem I have is that in excel, I do not know how to make the checklist stand-alone, in other words, link the score for each checklist to a specific employee ID and store that data on a seperate check. Then, I want to be able to refresh the checklist to use on a new employee, without erasing the data that was collected for the previous employee.

9. Is there a way to build a database in excel to where the same checklist sheet can be used over and over, but each data entry can be saved for an individual employee without the previous data deleted? I'm not too familiar with Access and know that excel is more user friendly with its broad functions.

Please ask me for clarification as I know it can be diffiuclt to understand at works.

Ideally, there will be ONE final score sheet that I can upload into our database or provide to management, and the other sheets will work systematically in the background.

Habilidades: Entrada de datos, Procesamiento de datos, Excel, Visual Basic, Visual Basic para aplicaciones

Ver más:

Información del empleador:
( 1 comentario ) Arlington, United States

Nº del proyecto: #12162183

18 freelancers están ofertando el promedio de $218 para este trabajo


I have read your project description clearly and what I understood is you want to develop a excel app which collects checklists data from all employees and makes a report. We have good experience in Excel Apps developm Más

$100 USD en 3 días
(134 comentarios)

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega Más

$200 USD en 5 días
(159 comentarios)

Hi, Thanks for such detail project description. I guess you are also an expert in excel formulas, it will be exicting jobs for both us us. I am sure I can help you through all your needs and make this spreadsheet Más

$500 USD en 10 días
(190 comentarios)

Dear sir, Greetings. The features that you are trying to implement within Excel, won't give you.(Or compromise with some limitation) I would suggest you to use MS Access which is easy as well and give you extra co Más

$188 USD en 3 días
(161 comentarios)

Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Please send me more details so that I can estimate cost and time better. I have completed more than 290 projects. Plea Más

$200 USD en 15 días
(159 comentarios)

Hello, I am Excel and VBA expert. Can I see the file? Please note that I have 100% completion rate and 5-star feedback on 50 projects.

$188 USD en 3 días
(54 comentarios)

Self-motivated professional, certified data entry specialist, a proficient web researcher and transcriber, blogger, web designer, Wordpress and various social sites marketer, knowledgeable in SEO, and technical / help Más

$100 USD en 5 días
(36 comentarios)

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind o Más

$200 USD en 2 días
(70 comentarios)

Hi, Experienced Excel VBA and VB.Net Programmer. I have read your instructions carefully. Expertise in exchanging data between sheets, advance formulas, critical programming, developing system for management Más

$120 USD en 3 días
(55 comentarios)

Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporti Más

$200 USD en 5 días
(31 comentarios)

Hi, I am an expert in MS Excel, MS Access, SQL database production and management. I have over 7 years of experience in working with all of the databases and analytics. I am a financial engineering graduate and have e Más

$100 USD en 5 días
(10 comentarios)

Hi, I have sound knowledge of Excel VBA programming. I can help complete the development and troubleshooting quickly with good quality once hired. Look forward to working with you. Best Regards,

$222 USD en 10 días
(2 comentarios)

Native English speaker. Excel/VBA expert. I've done such tasks before and can definitely take care of this for you. I recently build a similar evaluation system and can definitely picture how this will work. Howe Más

$222 USD en 3 días
(1 comentario)

This sounds like a complex spreadsheet. I didn't see the Excel file so I couldn't review the file. Here is how I typically approach a projects of this nature. 1) Understand how the file is currently working. 2) Más

$250 USD en 3 días
(1 comentario)

I am very experienced in VBA. I am an Access programmer and I have written automation projects in Word, Project and Excel. I have Microsoft Office 2000, 2002, 2003 and 2007 installed. The solution would also work in la Más

$555 USD en 5 días
(0 comentarios)

I would like to apply and do the work as per instruction and I have good hand on Excel Macro and VBA. Regards Anuj

$155 USD en 3 días
(0 comentarios)

Hello, I understand the kind of project that you want to implement therefore after reading the requirements I would like to propose some simple solutions that I used before. SOLUTION1: The project will be splited Más

$222 USD en 10 días
(1 comentario)

Hi, I have good skill at typing speed, the data entry is accuracy and always able to control my time for on each project. Regards, Winnie.

$144 USD en 3 días
(0 comentarios)

Hi there My name is Ruben Ferreira. I am a Chartered Accountant (SA) and am considered by my peers to be a bits of a Excel and VBA expert. I would like the opportunity to take this project on - you give a lot of Más

$158 USD en 7 días
(0 comentarios)