Find Jobs
Hire Freelancers

Collating data from spreadsheet forms

$300-1500 USD

Completed
Posted over 16 years ago

$300-1500 USD

Paid on delivery
The purpose of the application is to collate data from a number of spreadsheet forms (see attached file RCA Record) into a table in a summary spreadsheet (see attached file RCA Summary). It is envisaged that once a month the user will be able to open the summary spreadsheet and press a button to import data from all spreadsheet forms. The summary spreadsheet will be recreated from scratch each month and a copy retained to keep a history. All spreadsheet forms are of identical fixed structure and there may be up to 200 within the folder. The import data is clearly shown at $B$61:$N$61. It is envisaged that this application will have a very short life (< 12 months) during which it will get incorporated into a corporate system. It is likely that minor changes will be needed (e.g. add an extra data item) and the client is capable of making minor changes to the source code to cope with these small variations as long as the source is clearly documented. Error handling is important and a simple report of files within the folder that caused errors (e.g. did not have the named worksheet) would be useful.
Project ID: 191855

About the project

17 proposals
Remote project
Active 16 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
Awarded to:
User Avatar
Please see PM
$220 USD in 5 days
5.0 (1 review)
2.7
2.7
17 freelancers are bidding on average $388 USD for this job
User Avatar
Looking forward to working with you.
$300 USD in 2 days
4.9 (54 reviews)
6.1
6.1
User Avatar
Hello Please see PMB for details of my bid. Thank you
$300 USD in 2 days
4.9 (35 reviews)
5.6
5.6
User Avatar
Hi Plz check ur OMB for my bid. Regards
$300 USD in 2 days
5.0 (15 reviews)
4.4
4.4
User Avatar
Dear sir, This is Rajesh. please see the pm details.
$300 USD in 2 days
5.0 (8 reviews)
4.1
4.1
User Avatar
Hello,Please see the PM.
$300 USD in 7 days
4.7 (6 reviews)
3.4
3.4
User Avatar
Please see detail on PMB. Regards
$690 USD in 7 days
4.2 (4 reviews)
4.0
4.0
User Avatar
We have reviewed the two files provided and are confident in providing the desired solution accordingly.
$300 USD in 2 days
5.0 (6 reviews)
3.1
3.1
User Avatar
Please see PMB for a similar project delivered recently.
$799 USD in 7 days
4.2 (3 reviews)
3.6
3.6
User Avatar
kindly refer PMB, Thanks
$300 USD in 5 days
5.0 (3 reviews)
2.7
2.7
User Avatar
Hi! Please see PM for details. Thanks!
$300 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a service-oriented offshore individual with extensive experience, in data entry, blogging, captcha, virtual assistance and many other. Although I am not an American, I am abreast with the current situations. I have good command of english and I have impeccable writing skills. I am seeking for a challenging and informative project, and I believe this project serves it oven fresh. I assure you of quality output that wille exceed your expectations.
$600 USD in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Can be done in 10 days.
$500 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am very good at Excel and VBA in Excel. I am very confident about this project. Education: Management PhD. (1) 2000-2004 PhD. School of Management, Shanghai Jiaotong University, Major: Management Science and Engineering Study,,,etc. Doctor Dissertation Title: Research on the Oil Price Fluctuation and Risk Management (2) 1997-2000 Master Degree, School of Management, Dalian University of Technology, Major: Management Science and Engineering Study,,,, etc. Master Dissertation Title: Production Plan Support System (3) 1993-1997 Bachelor Degree, School of Chemistry, Dalian University of Technology, Major: Applied Chemistry Study,,,, etc. By years of study, I master the knowledge of chemistry and management. I also published over 10 articles on the publication, and took part in several research project. Because of excellent mathematics, I had won the first prize in mathematics competition. Working Experience 2005,1-Current: Toyo Heavy Industry(Dalian)Co.,Ltd. Company Introduction: We produce hydraulic system(including pumps, valves, cylinders, etc) according to customer’s requirement. Using the Numerical Controlled Lathe and Machining Center as basic manufacture tool, 96% of our products are sold to Japan, 3% of our products are sold to America, 1% of our products are sold in China. There are about 220 employees. Duty: 1 Production Scheduling I make the production plan by analyze the customer orderassembly capacity and producing plan, and assign the daily workshop producing. The production plan must assign every CNC every day duty. 2 Information Officer I develop production information system for my company. It has the MRP function, and has been used in routine operation. This system is B/S way, the database is SQL SERVER. 3 English Translator My English is better than other colleagues in my company. All the English Contact is charged by me. I had translated English Contracts, mechanical drawings, hydraulic technical information, etc. The production management system, which I developed, greatly improved the efficiency of making plan, order contact and searching production information. For example, in the past, it will take more than a day to checking the remaining order amount, now, one hour is enough. This system greatly improve our company information construction level.
$300 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have a completed product ready for you. Please see PM for details.
$300 USD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I provide superior quality code, thorough documentation, and guaranteed satisfaction. I have extensive experience in Excel and VBA. Please see my profile for more information.
$495 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
bedford, United Kingdom
5.0
2
Member since Nov 2, 2007

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.