終了

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.

スキル: データ入力, 情報処理, エクセル, ビジュアルベーシック, アプリ用ビジュアルベーシック

さらに表示:

プロジェクトID: #12162183

この仕事に、18人のフリーランサーが、平均$218で入札しています。

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
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
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
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
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
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
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
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
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
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
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
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