Current Excel spreadsheet need to add VBA capability to analyze and plot historical values
$10-30 USD
Completed
Posted about 8 years ago
$10-30 USD
Paid on delivery
I designed an Excel workbook that includes sheets with the following:
1) one sheet with 400+ names and dates of birth,
2) one sheet that calculates and plots Biorhythm data for each name.
The biorhythm data formula is already included. Right now If I choose a name from the list, the formula calculates how many days since birth the person has lived. It also calculates 4 different bio-rhythmic data fields: Physical, Intellectual, Emotional and "Mojo" (mojo is the average of all three). I am also plotting a graph for easier visual of the data.
What I need now is to have a sheet where I can query this information and give me a list of all individuals for TODAY whose PHYSICAL or INTELLECTUAL or EMOTIONAL or MOJO or any combination...reaches a range. For example: "Show me a list of people from the main list whose Physical AND Intellectual is higher than .50"
I need to take it a step further.
1) I want to be able to query this list for different dates for example: Today, Yesterday, Tomorrow or any given date.
2) I want to be able to query: For any chosen name in the list, give me a list of dates within a RANGE of dates where this person meets a given Criteria. For example: "For John Doe, I want to get a list of dates between April 1, 2016 and May 4, 2016 where His Physical or Emotional or Intellectual or "Mojo" or any combination, reaches above .50
This is a very simple project for the right person.
Hello Sir
Im excel VBA macro and formula Expert :)
i can do anything in excel :)
please give me a chance for doing your job and im able to start doing your job right now :)
Thank You
Sincerely
Prameswara
Hello,
after I read better your requirements, I agree it is quite simple project.
I am proficient with Excel and VBA and I can finish this task for you.
Please contact me for more information.
Hello,
I have been working as freelancer since last ~ 2.5 years,prior to this was working with a MNC as an Sr. Software Professional.
The project is Product based development and integration of the product with various already existing Products and processes..
Below are some key areas of my skills:
-- VBA and Excel,Word,Office Applications
-- Expert on C# using .NET framework using Visual Studio 2012 and 2013
-- Expert in VB.NET using VS2012/VS2013
-- WPF and Windows Forms Application
I have experience in all the above areas and during my project work I have completed all of the above tasks.
As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best.
Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution.
Would be looking forward to work on this opportunity and will ensure to deliver best.
Regards,
Abhinov
Hi,
I have seen your requirement and I understand it completely. Can I have a look at the actual data ? I am good and fast with excel vba. I can be of more help once I see the template.