# 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

Compétences : Excel, Visual Basic

Concernant l'employeur :
( 8 commentaires ) Nice, Thailand

Nº du projet : #1612088

## Décerné à:

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.

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(14 Commentaires)
4.4

## 18 freelance font une offre moyenne de \$72 pour ce travail

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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(29 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(44 Commentaires)
5.3
northwolves

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(50 Commentaires)
5.0
ahmedmayeen

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(4 Commentaires)
3.4
shagoon2u

Experts are ready to start immediately.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(3 Commentaires)
2.9
shaarawi

Hi I can help

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(4 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(1 Évaluation)
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...

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
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]

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0
Kinjalmahajan

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
anupamakarmalkar

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 6 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
sweetanamika

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0