Find Jobs
Hire Freelancers

More automation and easy reporting on our new training system

$15-25 AUD / hour

Closed
Posted about 7 years ago

$15-25 AUD / hour

We are implementing a formal training system for our workplace. It has several elements, most of which have been created as Microsoft Excel files. It is a lot of manual work to record employee training and assessment results, as well as report on progress. We would like a quote on updating our Excel files to achieve more automation and easy reporting. We have done some testing using Adobe fillable PDF forms for people to track training and competency results, but it is time consuming and we’re unsure how to use the data collected from PDF. The requirements can probably be met by using Excel but we’re open to using other methods like writing a database. However, we need to continue using JIBs in the format they have (Important Steps, Key Points, etc). Note that we have already created many JIBs using our current Excel template. We have access to Windows tablet PCs with stylus pens which can be used by trainees and trainers. The solution has to be Windows based and hosted inside our network. Elements of new training system. - Job Instruction Breakdowns (training scripts for specific work tasks) - Operator Development Plan (training plan for an employee, listing JIBs and other training materials to be completed for each work area or work machine) - Master Development Matrix (overall record of employee training progress) - Other training content hosted internally (e-learning videos, simulations) Requirements for JIB: - We want a master file that is blank where a trainer can add the specific Important Steps, Key Points and Reasons Why then save it as a specific JIB. - Protect the Excel file from user data entry mistakes (possibly use a data entry form or protected fields). - A Simple Standard Way of Operating which contains the training script of the JIB but we can add pictures to it and list hazards and control measures. This becomes a reference on how to do that job for employees in our factory. - A Self Assessment form where the trainee can mark that they believe they are competent in each item. - An Assessment form where a Assessor can mark the trainee as competent or not yet competent in each item. - The trainee and assessor need to be able to sign off on being competent. - Record this data in a way that can be easily reported on. For example, report on trainee John Smith’s competence in a specific JIB. - Collate the data so we can report an overall competence for a trainee in a group of JIBs. These are normally grouped into a machine or process. Site operational reporting requirements: - As well as any data or reporting about JIBs, we’d like an easy way to report on how many employees are competent in each machine or process at our site. Managing training plan requirements: - We’d like an easy way to track training plans for each employee with a timeframe for completion. - It would be nice to assign training tasks to people. - It would be nice to be able have reminders on who is overdue for their assigned training times.
Project ID: 12670903

About the project

34 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
34 freelancers are bidding on average $21 AUD/hour for this job
User Avatar
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 of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$26 AUD in 40 days
4.9 (311 reviews)
7.9
7.9
User Avatar
Greetings! Having driven Competency Development initiative myself for my department in my last full time job for a Fortune 100 company, it is really gladdening to see the level of detailed planning in your organization. I have gone through the requirements in detail and the individual workbooks that have been attached. I think automation in Excel has to be preceded by focused effort on process re-definition to support information mining through automation(define categories of information (process, machine, employee), re-assessment management, folder structure, file naming convention, overall process flow comes on top my mind). 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 Reporting. In fact, over the last MONTH , I have spent at least 225 HOURS on automation in Excel. . I feel 40 hours may not be sufficient to complete detailed requirements capture and subsequent implementation. Would like to discuss on this when I get an opportunity. I can get your work completed to your fullest satisfaction. Looking forward to hearing a positive response from you. Thanks in advance! Have a Great Day! Srinivasan Krishnamoorthi
$20 AUD in 40 days
5.0 (188 reviews)
6.8
6.8
User Avatar
Hello! We are extremely interested in this project and would love to work on this project, please reply back to discuss further. Looking forward to hear from you soon. Thanks!
$27 AUD in 40 days
4.5 (155 reviews)
7.1
7.1
User Avatar
Hi, I would like to use my experience to serve you better. You can trust my sincere indulgence both in quality and time frame. If you will give me a chance, I will ensure that you're satisfied. I'm really interested in the project since it's my area of expertise. I'm sure we can work together. I have read and understood the project guideline. Please check my completed projects & samples at: https://www.freelancer.com/u/erinkennedy.html. Thanks
$22 AUD in 40 days
4.6 (145 reviews)
6.9
6.9
User Avatar
Expert in Excel, Excel formulas, and all excel functions, macros, lookup concepts. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Can complete on time with good quality and on time. Expert in referencing and will deliver work with no plagiarism. Experienced MBA Finance as well.
$22 AUD in 40 days
4.7 (118 reviews)
6.2
6.2
User Avatar
I am a competent academic writer, with high lead times and turnaround time, proposal writer, masters level dissertation writer, PHD level dissertation and thesis writer, PHD defense PowerPoint presentation writer, argumentative essays, comparative analysis, company analysis, business strategy development, conversant with all international citations, marketing, management, business studies, advertising, procurement, strategy development, marketing plans, marketing strategy, communication strategies, stakeholder man. I have good reviews and record of writing excellent quality and a PhD level Essay, Thesis, dissertation. I can assure you about ZERO Plagiarism work. Give me a chance to join your team and i will prove myself. I believe in Quality … Let’s Discuss.
$22 AUD in 40 days
4.7 (69 reviews)
6.3
6.3
User Avatar
Hello I'm creative with superb writing skills and a passion for the job. I don't just get over projects but I always effort to deliver the best as per clients' requirements and leave them satisfied. Kindly give me more details and consider me for the job. Thank you in advance
$22 AUD in 40 days
4.9 (26 reviews)
5.3
5.3
User Avatar
Using Excel and managing data is critical for my job, so am proficient with formulas and additionally can code. Have done HR and evaluation work as well, hence have some background understanding to your requirements. Am confident to do this project. Looking forward to hearing from you!
$25 AUD in 40 days
5.0 (9 reviews)
4.7
4.7
User Avatar
Dear sir I am an expert in excel and also I am an economist (BA+MBA) by profession. I have vast experience in excel and VBA and i am confident i can assist you with your requirements. feel free to contact me over the web site chat for further details it would be hard to think of a solution with out review of your current system and getting to know the needs with regard to it. pls contact me if u can present your current system and we can discuss on possible solutions using excel tools and macros. brgds. Itay
$27 AUD in 15 days
5.0 (12 reviews)
4.2
4.2
User Avatar
Hi, My core expertise is in project implementation, project planning, project reporting, data processing, online data mining, online research projects. Follows instruction and do pay close attention to details. Looking forward for your reply Thanks
$15 AUD in 40 days
5.0 (2 reviews)
3.2
3.2
User Avatar
Hi, I have more than 10 Years experience as Data Entry Operator. I will give, -Friendly Service -Unlimited Revisions -Quick Response Thank You,
$16 AUD in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, After reading your project description, I know I can help you! as we have worked on various projects similar to your requirements. ►►Please check some of our previous reputation below-- https://www.freelancer.com/u/eClickApps.html We believe in best quality work and on time delivery. Please initiate a chat so that we can discuss. -Thanks and regards, Daniel
$15 AUD in 40 days
0.0 (1 review)
0.0
0.0
User Avatar
At the first glance your business task is definitely requires a database. All JIB-s (protected Excel or PDF forms) can be generated automatically from the information stored in the database. If to speak about all existing Excel JIBs - I think they can be parsed up into upcoming database automatically (maybe with some manual review afterwards). Btw, didn't you consider a web-based alternative for Excel forms for trainees? I mean the work in a tablet's browser inside your company's intranet. Feel free to contact me to discuss all that more detailed. Thanks UPD: Hourly rate is updated. Was muddled between USD and AUD.
$27 AUD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$22 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I think I may be able to assist you as I have run my own training both for a large corporate and my own company, so I am familiar with many of the tasks you require. This appears to be quite an intensive programme and I'm not sure of how many trainees you are requiring this for, but I think a methodical approach is called for. I would like to know more of the project as I'm sure you would like to know more of my background. I have also fulfilled roles as Human Resources Administrator where we worked with the IT Seta to train IT personnel to fixed goals, Been a Project Administrator and Manager where the training needs for both the Petroleum Industry and IT sector were priorities. I have also trained the Microsoft suite of products and so I am familiar with Excel and its capabilities. I trust this information will enable you to make a ;positive decision. Many thanks.
$22 AUD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$16 AUD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$22 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I will transfer your files to database making it more convenient and easy to use, all files will be located at one database. I can customized it to appear like you are browsing an internet website. And I will provide months of assistance free of charged, until you finally master using it.
$17 AUD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Accomplished Talent Development executive with 30 years of experience and a superior history of implementing process and efficiency improvements resulting in revenue gains and long-term growth within the financial services, public and private sectors. Analytical thinker, recognized for commitment to staff training and development that meets corporate and employee needs ushering in a deep understanding of company initiatives and seamless execution. Strong and decisive leadership style. Flexible in responding to changing organizational demands. Motivational leader, instructional designer and trainer adept at employee development, workforce planning and overall operational policy creation. Seizes opportunities to overcome challenges and resolve issues, securing smooth operations. - Analysis, MBTI, Keirsey Temperament, Organization Development, Strategic Planning, Collections, Lending, Mortgage Banking, Perfomance Management, Succession Planning, Business Development, Human Resources, GAAP, Project Management , Workflow Optimization, 360 Assessments, Customer Service, Sales, Learning Management Systems.
$22 AUD in 40 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Australia
0.0
0
Member since Jan 3, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.