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

c. Automate additional calculations

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.


Hello Freelancers,
Thanks for your bids.
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

Hi all,

Thanks for your patience.
I have attached new explanations as well as an example of what the macro should perform.
Please review your bids.
The project will be awarded soon.

Kind regards

Compétences : Excel, Visual Basic

en voir plus : projection vector excel, point projection vector excel, vector excel macro, macro excel projection, vector excel vba, vba vector projection, vba macro excel, vectors vba excel, vector vba macro, vector projection excel, vector of ones, starting with visual basic, starting objective c, macro freelancers, freelancers excel, excel work freelancers, excel vba freelancers, basic vectors, vector excel, excel vba projection, automate excel work, new excel, excel vba help, need help with excel, need help excel

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

Nº du projet : #1612088

Décerné à:


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)

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


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)

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)

Ready to start,see PMB please.

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

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)

Experts are ready to start immediately.

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

Hi I can help

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(4 Commentaires)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)