Vector Projection Excel Macro

Hello Freelancers!

Here is some work that can link to more projects as I often need help from good excel resources.

1. General objective: Create a new Excel spreadsheet based on 2 existing spreadsheets and compute additional calculations. For each row of spreadsheet 1:

a. Identify matching rows in spreadsheet 1 and 2

b. Export matching data in a new spreadsheet

2. Existing spreadsheets: simple and group vectors

a. In the spreadsheet 2 is recorded information concerning “vectors”. These vectors have been extracted from a database. They are formed from points that are consecutive in time. Each vector is always composed of a low (SL Num) and a high point (SH Num). Low points are numbered from 1 to X consecutively. High points numbered as well from 1 to X.

i. Each row in spreadsheet 2 corresponds to one “vector” and each column is a variable concerning this vector.

b. In spreadsheet 1, the same principle than in the spreadsheet 2 applies. However here, vectors are created by grouping together non consecutive points. Thus they encompass more than 2 points. We can call them “Group vectors” compared to the “simple vectors” in spreadsheet 2

c. All vectors up are within spreadsheets 1 and 2 while all vectors down are in spreadsheets 1’ and 2’

3. Detailed objectives

a. Identify inner vectors within larger ones:

i. For each group vector listed in spreadsheet 1 (here called “larger vector”, identify all existing vectors in spreadsheet 1 and 2 with the same starting point but with a previous ending point (=ending point with smaller number). These will be called “inner vectors”.

1. One simple vector within spreadsheet 2 is always an inner vector of a group vector

2. Potentially X Group vectors from spreadsheet 1 are inner vectors of another group vector.

b. Every time an inner vector is identified, create an excel row within a new spreadsheet:

i. Export larger group data from spreadsheet 1

ii. Export Inner group data from spreadsheet 1 or 2

c. Automate additional calculation between the data imported in a row in step b above. All calculation are provided in Excel format.

Additional information are available for serious freelancers.

Please provide in your answers the number of years working with VBA and proofs of similar work.

Thanks

Hello Freelancers,
I am working on unifying files 1 and 2 so that they contain the same information. This will make the project much easier. Once the algorithm that exports these excel files is changed I will post an example of what I expect to make my description clearer. This should be done in a couple of days. Then I will answer individually your pm.
Kind regards
Nicolas

Hi all,

I have attached new explanations as well as an example of what the macro should perform.
The project will be awarded soon.

Kind regards

Kỹ năng: Excel, Visual Basic

Về Bên Thuê:
( 8 nhận xét ) Nice, Thailand

Mã Dự Án: #1612088

Đã trao cho:

himanshuhc

Hi, I have over 6 years of experience in VBA programming and I have posted a WORKING SAMPLE for you to review before bid acceptance. Please refer PM.

\$75 USD trong 1 ngày
(14 Đánh Giá)
4.4

18 freelancer đang chào giá trung bình \$72 cho công việc này

Krusche

Hello. We are a German company with a team of 2 dedicated professionals working with MS based projects including VBA programming. French speaking. Please check your inbox for examples.

\$120 USD trong 1 ngày
(29 Đánh Giá)
5.6
FIBIN

Hi, I am an expert in excel and VBA Programming in Excel. I have experience working on lot of Excel based projects. I am interested to work for your project. I will make sure that I deliver you the best with 100% ac Thêm

\$80 USD trong 3 ngày
(44 Đánh Giá)
5.3
northwolves

\$80 USD trong 3 ngày
(50 Đánh Giá)
5.0
ahmedmayeen

Hi, I included my bidding cover letter as a private message attached, please refer to that. Regards, Mayeen

\$80 USD trong 2 ngày
(4 Đánh Giá)
3.4
shagoon2u

Experts are ready to start immediately.

\$100 USD trong 5 ngày
(3 Đánh Giá)
2.9
shaarawi

Hi I can help

\$50 USD trong 7 ngày
(4 Đánh Giá)
2.4
forsameer

Quality is my first priority. This is my first project on freelancer, but I have a vast experience programming macro functions for MNC bank. Automation is like my passion. If you choose me for this project, you will be Thêm

\$99 USD trong 3 ngày
(1 Đánh Giá)
1.2
maya6109

well ... i have 3 year exp. in excel vba coding i.e writing macro.. Give me chance i will try my best...

\$120 USD trong 2 ngày
(0 Đánh Giá)
0.0
ceromat

Bachelor degree (Mathematics) completed at Havana University. Microsoft Office Excel Expert certification: Certification Verification Website wUAcP-k45r [url removed, login to view]

\$75 USD trong 1 ngày
(0 Đánh Giá)
0.0
neo4228

I have vast experience programming macros and working within multiple worksheets. This project is very important for me because it would be my first on freelancer and allow me to get exposure so that I will be conside Thêm

\$60 USD trong 1 ngày
(0 Đánh Giá)
0.0
azeem381

I am a very hardworking person and highly motivated to get the work [url removed, login to view] give to do this job & pls send the details.

\$60 USD trong 10 ngày
(0 Đánh Giá)
0.0
Kinjalmahajan

Hi, I would like to work on this project. Regards Nikunj

\$50 USD trong 3 ngày
(0 Đánh Giá)
0.9
prashant7043

Hi I did many project in VB, like way2sms automation using Ms access/excel, extraction of result etc. Give some information regarding "c. Automate additional calculations" and which field suggests what in both the she Thêm

\$45 USD trong 4 ngày
(0 Đánh Giá)
0.0
manojgilra

Hi I am working with a content management company as a senior software engineer. I have 4 years of experience in VBA and have created lots of macros to automate day to day work in MS-Word and Excel. I am sure I will b Thêm

\$50 USD trong 2 ngày
(0 Đánh Giá)
0.0
anupamakarmalkar

has got excellent skills for working on excel & VB. Professionally trained.

\$50 USD trong 6 ngày
(0 Đánh Giá)
0.0
biitservices

BIITServices team has also built various reports for our client's worldwide as per customer's needs and based on various data sources like SQL Server, SharePoint, MS Access, MS Excel etc. we also provide various marke Thêm

\$40 USD trong 3 ngày
(0 Đánh Giá)
0.0
sweetanamika

Have more than four years of work experience in VBA and excel

\$65 USD trong 7 ngày
(0 Đánh Giá)
0.0