Concluído

Excel Project

I have a basic Excel 2007 Spreadsheet that is in dire need of some automation. I am not sure if additional programming will be required. The sheet is used to keep track of clients enrolled in a fitness bootcamp. The clients? weigh in weekly (Mon-Sun)? and pounds? & body fat (%) are measured. Along with the client's name, are their ages and initial weight and body fat. Then a goal is set for each and the weekly measures are deducted from the initial goal. Currently, the calculations are done manually because of lack of skills with advanced formulas.

The client list contains a list of about 2000 clients all of which are not active, but I would like to retain the historical data.?

* I would like to have an accumulated total of the pounds and body fat automatically calculated per person after the weekly measurements are entered.

* I would then like to be able to pull monthly, weekly and/or individual reports on total weight loss.

* I would also like the color to change if the client has 3 weight gains

I hope that someone is out there that can help me rather quickly.

## Deliverables

I have attached a copy of the file for review. I know that there are some duplicates right now, but I need them there to verify some other information.

* On the total pounds lost, I would like it to be rounded up.

* The format can be changed as long as it is simple to input the data.

* Would love to keep it in Excel format.

* Each person has 2 goals which need to be met - If something can be done to indicate a client has met the first goal and then the second goal.

Habilidades: Engenharia, Excel, Microsoft Access, Microsoft Exchange, MySQL, PHP, Powerpoint, Gestão de projetos, Arquitetura de software, Teste de Software, Word

Veja mais: programming in excel, php project name list, out there monthly, need someone to help with excel reports, fitness programming, fitness 2000, bootcamp programming, advanced excel formulas, active reports review, programming with excel, project management format, weigh, reports in excel, lost excel, fitness project, excel reports, excel project, excel project 2/2, Excel Formulas, excel advanced, change fitness, automation project , advanced excel, excel contains, excel data automation

Acerca do Empregador:
( 4 comentários ) United States

ID do Projeto: #3913450

Concedido a:

burrock

See private message.

$42.5 USD em 14 dias
(0 Comentários)
1.3

10 freelancers estão ofertando em média $104 para esse trabalho

krylenkom

See private message.

$127.5 USD in 14 dias
(210 Comentários)
6.6
dominique1

See private message.

$127.5 USD in 14 dias
(426 Comentários)
6.5
iLoveCoding

See private message.

$85 USD in 14 dias
(74 Comentários)
5.2
softadmin

See private message.

$120.7 USD in 14 dias
(28 Comentários)
5.0
vibsworld

See private message.

$127.5 USD in 14 dias
(19 Comentários)
3.7
indrasyafruddin

See private message.

$85 USD in 14 dias
(4 Comentários)
3.2
raghasvw

See private message.

$127.5 USD in 14 dias
(2 Comentários)
1.7
nix1128vw

See private message.

$102 USD in 14 dias
(0 Comentários)
0.0
FaisalY75

See private message.

$93.5 USD in 14 dias
(1 Comentário)
0.0