進行中

Current Excel spreadsheet need to add VBA capability to analyze and plot historical values

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.

スキル: .NET, エクセル, ソフトウェアアーキテクチャ, ビジュアルベーシック, ウェブリサーチャー

さらに表示: sheets add, plotting a graph in c, how to graph data, graph how to

採用者について:
( 3件のレビュー ) Woodhaven, United States

プロジェクトID: #9803342

アワード:

watersev

Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regrads, Eugene PS. Windows only

$30 USD 0日以内
(144レビュー)
5.8

この仕事に、14人のフリーランサーが、平均$27で入札しています。

prameswara

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

$30 USD 1日以内
(220件のレビュー)
6.3
abhinovpankaj

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 va もっと

$35 USD 1日以内
(25件のレビュー)
4.9
vlayausa

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.

$30 USD 1日以内
(31件のレビュー)
4.3
arpankumarde

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.

$20 USD 1日以内
(35件のレビュー)
3.9
webanis

Hi , I am interested by your offer: Excel VBA code. I will be happy to do this job even though I'm new in the field of freelance. Let me know more details of this work. I will start working immediately :) B もっと

$25 USD 1日以内
(7件のレビュー)
3.1
oadsmedia

!!! Dear Honor !!! We Can Help You Make That Happen !!! Lets discus............. Choose wisely :) :)

$30 USD 1日以内
(0件のレビュー)
0.0
$25 USD 1日以内
(0件のレビュー)
0.0
$25 USD 1日以内
(0件のレビュー)
0.0
Shibinsv

I Will be able to meet the expectation you required... define my strength & ability... handling entries....

$25 USD 1日以内
(0件のレビュー)
0.0
$25 USD 10日以内
(0件のレビュー)
0.0
$25 USD 1日以内
(0件のレビュー)
0.0
$25 USD 10日以内
(0件のレビュー)
0.0
$25 USD 10日以内
(0件のレビュー)
0.0