Excel programmer

已完成 已发布的 5 年前 货到付款
已完成 货到付款

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)

Other comments (manual entry)

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

Excel

项目ID: #17875102

关于项目

22个方案 远程项目 活跃的5 年前

授予:

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 更多

£100 GBP 在3天内
(22条评论)
5.3

有22名威客正在参与此工作的竞标,均价£159/小时

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 更多

£200 GBP 在3天内
(361条评论)
8.0
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 在3天内
(212条评论)
7.9
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 更多

£180 GBP 在5天内
(260条评论)
7.6
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 在3天内
(423条评论)
7.7
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 更多

£250 GBP 在3天内
(90条评论)
7.1
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 在3天内
(91条评论)
6.7
periyannas

Ok Sure let me help

£200 GBP 在7天内
(131条评论)
6.6
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 在3天内
(110条评论)
6.3
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 更多

£222 GBP 在3天内
(161条评论)
6.4
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 在5天内
(80条评论)
6.4
natalka503

Hello, I have big experience in this kind of projects and I would like to help you. Please contact me via chat to discuss details. Greetings, Natalie

£200GBP 在1天里
(65条评论)
6.2
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 更多

£250 GBP 在3天内
(69条评论)
5.8
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 更多

£200 GBP 在3天内
(8条评论)
5.0
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 在5天内
(27条评论)
4.2
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 更多

£50 GBP 在3天内
(27条评论)
3.9
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 在3天内
(4条评论)
2.9
sub234

Hi, Looks like you are trying to get inferences about sleep patterns from data entered by the clients. We can help you by creating python programs to do the same. Let me know if it suits you. Regards, sub234

£150 GBP 在3天内
(0条评论)
0.0
sudhakarrulz

I am a post graduate student in the field of computer science. I have a good knowledge in Excel and data visualization. I assure you to get the project done on time. please do consider my proposal.

£40 GBP 在2天内
(0条评论)
0.0