Excel programmer
£20-250 GBP
Paid on delivery
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
Project ID: #17875102
About the project
22 freelancers are bidding on average £159 for this job
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
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
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.
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.
Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards
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
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.
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
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
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
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.
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
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.
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
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.
