Collating data from spreadsheet forms

$300-1500 USD

Ukończony

Opublikowano

ponad 16 lat temu

$300-1500 USD

Płatne przy odbiorze

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.

Visual Basic

Identyfikator projektu: 191855

Informację o projekcie

17 ofert

Zdalny projekt

Aktywny 17 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Adres e-mail

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe

Otrzymuj wynagrodzenie za swoją pracę

Przedstaw swoją propozycję

Rejestracja i składanie ofert jest bezpłatne

Przyznano:

@sensetech

Please see PM

$220 USD w 5 dni

5,0

(1 opinia)

2,7

17 freelancerzy składają oferty o średniej wysokości $388 USD dla tej pracy

@xamdam91

Looking forward to working with you.

$300 USD w 2 dni

4,9

(54 opinii)

6,1

@schandraram

Hello Please see PMB for details of my bid. Thank you

$300 USD w 2 dni

4,9

(35 opinii)

5,6

@KellogITSolution

Hi Plz check ur OMB for my bid. Regards

$300 USD w 2 dni

5,0

(15 opinii)

4,4

@crajeshbe

Dear sir, This is Rajesh. please see the pm details.

$300 USD w 2 dni

5,0

(8 opinii)

4,1

@guolibin

Hello,Please see the PM.

$300 USD w 7 dni

4,7

(6 opinii)

3,4

@ExactSystems

Please see detail on PMB. Regards

$690 USD w 7 dni

4,2

(4 opinii)

4,0

@cheungkc

We have reviewed the two files provided and are confident in providing the desired solution accordingly.

$300 USD w 2 dni

5,0

(6 opinii)

3,1

@ajay192

Please see PMB for a similar project delivered recently.

$799 USD w 7 dni

4,2

(3 opinii)

3,6

@vnb400

kindly refer PMB, Thanks

$300 USD w 5 dni

5,0

(3 opinii)

2,7

@kiracle

Hi! Please see PM for details. Thanks!

$300 USD w 3 dni

0,0

(0 opinii)

0,0

@rjmarie123

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 w 30 dni

0,0

(0 opinii)

0,0

@pbarbas

Can be done in 10 days.

$500 USD w 10 dni

0,0

(0 opinii)

0,0

@fengchunshan

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 w 2 dni

0,0

(0 opinii)

0,0

@KatoNamus

Hi, I have a completed product ready for you. Please see PM for details.

$300 USD w 0 dzień

0,0

(0 opinii)

0,0

@Philleas

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