Закрито

Database & Checklist Automation - open to bidding

INSTRUCTIONS:

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.

Навички: Введення даних, Обробка даних, Excel, Visual Basic, Visual Basic для додатків

Показати більше:

Про роботодавця:
( 1 відгук ) Arlington, United States

ID проекту: #12162183

18 фрілансерів(-а) подали заявки на цю роботу; середня заявка - $218

SBITServices

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 Більше

$100 USD за 3 дні(-в)
(134 відгуків(-и))
6.6
elqueabandona

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 Більше

$200 USD за 5 дні(-в)
(159 відгуків(-и))
6.6
danielgpratidya

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 Більше

$500 USD за 10 дні(-в)
(190 відгуків(-и))
6.5
bdoutsource

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 Більше

$188 USD за 3 дні(-в)
(161 відгуків(-и))
6.5
dpune

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 Більше

$200 USD за 15 дні(-в)
(159 відгуків(-и))
6.4
macroPOL

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 за 3 дні(-в)
(54 відгуків(-и))
5.4
abdussamad

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 Більше

$100 USD за 5 дні(-в)
(36 відгуків(-и))
5.6
schoudhary1553

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 Більше

$200 USD за 2 дні(-в)
(70 відгуків(-и))
5.2
vsprybhanu

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 Більше

$120 USD за 3 дні(-в)
(55 відгуків(-и))
5.0
ksriniravi

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 Більше

$200 USD за 5 дні(-в)
(31 відгуків(-и))
4.6
jssinfosys

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 Більше

$100 USD за 5 дні(-в)
(10 відгуків(-и))
3.8
vivirain

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 за 10 дні(-в)
(2 відгуків(-и))
1.9
CanadianQuality

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 Більше

$222 USD за 3 дні(-в)
(1 відгук)
1.8
WestonPalmer

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) Більше

$250 USD за 3 дні(-в)
(1 відгук)
1.0
warrenbain

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 Більше

$555 USD за 5 дні(-в)
(0 відгуків(-и))
0.0
tracygearth

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 за 3 дні(-в)
(0 відгуків(-и))
0.0
insidenetsoft

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 Більше

$222 USD за 10 дні(-в)
(1 відгук)
0.0
winniemak

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 за 3 дні(-в)
(0 відгуків(-и))
0.0
RubenF85SA

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 Більше

$158 USD за 7 дні(-в)
(0 відгуків(-и))
0.0