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.
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.
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.
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.
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.
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
Hi, I included my bidding cover letter as a private message attached, please refer to that. Regards, Mayeen
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
well ... i have 3 year exp. in excel vba coding i.e writing macro.. Give me chance i will try my best...
Bachelor degree (Mathematics) completed at Havana University. Microsoft Office Excel Expert certification: Certification Verification Website wUAcP-k45r [url removed, login to view]
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
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.
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
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
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