# Excel programmer

I need a spreadsheet for clients to enter data about their sleep patterns, lifestyle and a rating for how they feel about the night they just had. Clients will fill his in each morning while they are undergoing therapy so graphs will be necessary to illustrate progression / regression.

This will include:

Client reference number (manual entry)

Date

Did you take a sleeping tablet last night (yes/no and type)

Did you take any other medication last night? (yes/no and type)

Did you drink alcohol last night? (yes/no and manual entry for quantity)

What time did you eat supper? (hours/ mins in 5 min options)

What did you eat? (manual entry)

What exercise did you do? (start time, duration, type. Type = manual entry)

Did you nap yesterday? (Yes/no, start time & duration)

Agreed “To bed time” (hours /

At what time did you go to bed last night? (hours/ mins in 5 min options)

After settling down, how long did it take you to fall asleep? (hours/ mins in 5 min options)

After falling asleep, for how long were you awake during the night in total? (hours/ mins in 5 min options)

At what time did you finally wake up? (hours/ mins in 5 min options)

At what time did you get up? (hours/ mins in 5 min options)

How well do you feel this morning? (Rating 1-5)

How enjoyable was your sleep last night? (Rating 1-5)

How active was your mind in bed last night? (Rating 1-5)

How physically tense were you in bed last night? (Rating 1-5)

How anxious were you in bed last night? (Rating 1-5)

I will need calculations to produce the following:

Total time in bed

Total time awake

Total time asleep

Sleep efficiency (time asleep as % of time in bed)

The following data will need to be shown on graphs (grouped accordingly):

Graph 1

Total time in bed

Total time awake

Total time asleep

Graph 2

Sleep efficiency

Graph 3

How well do you feel this morning? (Rating 1-5, 1 = Not at all, 3 = Moderately, 5 = Very well)

How enjoyable was your sleep last night? (Rating as above)

Graph 4

How active was your mind in bed last night? (Rating as above)

How physically tense were you in bed last night? (Rating as above)

How anxious were you in bed last night? (Rating as above)

These graphs will show progression over the duration of therapy. Reporting is required in tabular form as well, with options to show daily data in weekly groups (i.e. week 1 or 2 or 3 etc broken down into days).

All reporting to be done in hours and minutes, not minutes only unless duration is under 1 hour. Use 12 hour clock with am/pm option

Skills: Excel

( 0 reviews ) United Kingdom

Project ID: #17875102

## Awarded to:

afenache

Hi, I can create the excel file with questionnaire and graphs that you need. I am a chemical engineer and I have over five years experience in using Excel at an advanced level (complex formulas, array formulas, pivot More

£100 GBP in 3 days
(11 Reviews)
3.9

## 24 freelancers are bidding on average £158 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( More

£200 GBP in 2 days
(617 Reviews)
8.3
schoudhary1553

Hello! This is Vibrant Webtech and I was glad to see that you're looking for help for project Excel programmer. I've delivered more than 400 + projects in the last 5 years and this makes me very confident with you More

£200 GBP in 3 days
(259 Reviews)
7.5
asin1987

Dear Employer, I will create an Excel tool for you using which your clients can find their sleeping patterns and related ativities. Please message me. Thanks and Regards, Ash

£250 GBP in 3 days
(107 Reviews)
7.0
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

£200 GBP in 3 days
(272 Reviews)
7.2
dgled

Hi, I am a financial expert and guru in Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout More

£250 GBP in 3 days
(59 Reviews)
6.6
paris2785

Hello! My name is Paris and just had the chance to read your project's brief. I was very excited that you mention Microsoft Excel because this is my favorite field and MS Excel projects are among the tasks I work with More

£180 GBP in 5 days
(143 Reviews)
6.7
avinav606lx

Hello there, Share your sample file. I have developed more than 500 VBA macros for Windows/MAC I am an expert in Excel/Access/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. Ping me to disc More

£222 GBP in 3 days
(157 Reviews)
6.4
polarjin2017

Hello? How are you? I have read your brief description. I have good skills in So I think we can work together. Hope to work with you. Thank you.

£133 GBP in 3 days
(50 Reviews)
6.1
seoguru17

There are lot of things to be created in Excel file, I am going through with the requirement and I am sure that I can automate this through Programm.

£222 GBP in 5 days
(62 Reviews)
6.2
periyannas

Ok Sure let me help

£200 GBP in 7 days
(60 Reviews)
5.5
citijayamala

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex mar More

£250 GBP in 3 days
(52 Reviews)
5.3
rinabuoy13

Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards

£166 GBP in 3 days
(46 Reviews)
5.0
aubrey03

I am an Excel specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]

£50 GBP in 1 day
(45 Reviews)
5.0
Piao217

Hi I have built several excel sheets which needs user interactions using VBA. I understand what you mean and I can fulfill your requirements. Let us discuss in more detail through chat. Thanks. Wang C.

£222 GBP in 3 days
(3 Reviews)
4.4
natalka503

£200 GBP in 1 day
(43 Reviews)
4.2
furqanahmed55

Hello, I'm an expert in maintaining data in excel without any mistakes as I'm doing this for the past 8 years now. You can check my past employers feedback about my attention to detail and how precise my results More

£200 GBP in 3 days
(6 Reviews)
4.4
nishantha041

Dear Sir, I have many years of experience with excel and vba programming. i can meet your requirement as explained in the description. Kindly contact me. Thank You.

£44 GBP in 3 days
(4 Reviews)
2.9
DMagnes

This should be fairly easy but I would like to discuss it more with you in order to help facilitate exactly what you want. I believe it will be simple to create. If you have any questions message me.

£75 GBP in 5 days
(4 Reviews)
1.8
egafiori

My name is Esteban, I'm an industrial engineer and I'm new to this. I would love to help you in your project and that you can help me earn more points.

£75 GBP in 5 days
(2 Reviews)
1.4
srijanagrawal21

About me & what I can provide - • 5 Yrs. of Experience in Excel & VBA. • Knowledge of Formatting, Graphs, Chart & Formulas. • I can also create useform for user to fill in data which can be filled by client having More

£50 GBP in 3 days
(2 Reviews)
1.4