Programming

Programming questions? Ask a programmer for answers ASAP

Ask a Computer Expert,
Get an Answer ASAP!

It is an Excel question.. 2010, Microsoft Office, I am

Customer Question
It is an Excel...

It is an Excel question..

Technician's Assistant: What programs and versions are you using?

2010

Technician's Assistant: What is your ideal outcome? How can we solve this for you?

Microsoft Office

Technician's Assistant: Anything else you want the programmer to know before I connect you?

I am looking for assistance in figuring out a formula for a report

Submitted: 1 year ago.Category: Programming
Show More
Show Less
Ask Your Own Programming Question
Customer reply replied 1 year ago
I need assistance as fast as possible, please.
Answered in 5 minutes by:
3/9/2017
Programmer: Richard, Consultant replied 1 year ago
Richard
Richard, Consultant
Category: Programming
Satisfied Customers: 47,126
Experience: Programming and Network consultancy for 15+ years
Verified

Hi there and welcome

Can you tell me please what type of formula you require?

Please let me know

Ask Your Own Programming Question
Customer reply replied 1 year ago
Good morning and thank you so much! I have this report that shows the range dates when doctors are assigned to give results. Doctors have 2 business days after the due date to read and stay at least 80%. I need a formula that will show if doctors read with the overdue date and show if they were at 80%. an outlier.
Programmer: Richard, Consultant replied 1 year ago

Can you attach the sheet please so I can look at this?

Use the attach file button please.

Ask Your Own Programming Question
Customer reply replied 1 year ago
Please let me know if you have any questions regarding the report...
Customer reply replied 1 year ago
Sheet 3 has the dates that are assigned to each doctor and table 1 shows when the doctors actually read the test...
Programmer: Richard, Consultant replied 1 year ago

I have the file, thanks.

Just trying to understand the requirements. Sheet 3 shows a start and end date and there is a Date Required in Table 1 Column F, are you saying to indicate when the Date Required falls between the start and end date?

Ask Your Own Programming Question
Customer reply replied 1 year ago
Column F is when doctor read the report, I need to indicate if he was with the 2 business day after the end date and if he met his 80% requirement.
Programmer: Richard, Consultant replied 1 year ago

Thanks

I see that you have the doctor as RP, yet there are many entries for RP on both sheets, how do I know which one matches with the other between the sheets?

Ask Your Own Programming Question
Customer reply replied 1 year ago
in table 1 there is a list that I removed the patients name, with each patient D.O.S. (Date of Service), the doctor (let's say RP) gave results to each of the patients test and the date that he gave the report is in column F. In sheet 3 are the range of dates that the doc was assigned to read those reports. Did I explain that ok, it's hard to write out what you really I want to say... lol
Programmer: Richard, Consultant replied 1 year ago

yes, but how do I know which row in Table 1 is linked to the row in Sheet3?

So I can do the check

Ask Your Own Programming Question
Customer reply replied 1 year ago
i'm sorry for the delay, I'm at work and trying to do this at the same time...
Do you see in Sheet3 in column D, I have the results of PFT's that were done but I used the wrong column, I used DOS instead of Date Read in Table1. If I changed that to Date Read it would give me the total that Dr. Read within those dates, I need to show the amount that he was within the 2 business after the due date... I just don't know how to write the formula that shows after the records that were within the 2 business day and get the %.
Programmer: Richard, Consultant replied 1 year ago

ok, column D is assigned done... but again, I just need this one thing answered.

Table 1 sheet you have the doctor via their initials, eg RP and in sheet 3 you also hev the doctors in C

You have many RP in table 1 and also in sheet3 so how do I know which row in Table 1 links to the row in sheet 3.

It is not D as D does not appear in Table 1

Ask Your Own Programming Question
Customer reply replied 1 year ago
I think what is happening is that your knowledge is much more than mine when it comes to Excel therefore making it a little difficult for me to understand what you are asking for. I can only tell you in my level of understanding of what I need.In sheet 3 in column c are the initials of the docs that are assigned to read during the start and end date.
Programmer: Richard, Consultant replied 1 year ago

Thanks

But then there is no way to match the doctor in Table 1

Because you have multiple rows of the same doctor

Does that make sense? Would you like me to call and explain?

Ask Your Own Programming Question
Customer reply replied 1 year ago
Im sorry, I cant afford any more funds... I'm doing this on my own time as it is...
So maybe what I'm thinking that I have unnecessary information in the sheet...
I only need in table1:
* Date of test
* Assigned Doc to read
* Doc who actually read
* Date that was readwhat do you think?
Customer reply replied 1 year ago
Maybe not even Assigned Doc to read so,*D.O.S
*Doctor who read
*Date Read
Programmer: Richard, Consultant replied 1 year ago

yes, as then you can see how far the date was after the date that was read

Then you just use an if statement like (lets sate date read was A and date of test B

=if(B1-A1>=2,"Outside 2 days","Within 2 Days")

As then you have the data needed to check

Ask Your Own Programming Question
Customer reply replied 1 year ago
ok, so how do I lay-it-out in one sheet?
Customer reply replied 1 year ago
or do i keep in separate sheets?
Programmer: Richard, Consultant replied 1 year ago

You can put it in the same sheet, just put it in a column in the sheet

Ask Your Own Programming Question
Customer reply replied 1 year ago
but how do I show the test was read with-in the start and end date of sheet 3?
Programmer: Richard, Consultant replied 1 year ago

you put it on the same row in the table 1 sheet

Ask Your Own Programming Question
Customer reply replied 1 year ago
Do I eliminate the Start Date, and just have the due date?
Programmer: Richard, Consultant replied 1 year ago

If you only need to check on the Due date then the start date is not needed

Ask Your Own Programming Question
Customer reply replied 1 year ago
Ok, so with that said.... please look at the updated sheet and let me know the correct formula to get the results that I need, please.
Customer reply replied 1 year ago
Is this possible?
Customer reply replied 1 year ago
I need the total of test read on time not to tell lme if it was read or not...
Programmer: Richard, Consultant replied 1 year ago

can you check the file here please, the new sheet I made for you

http://wikisend.com/download/299700/PFT+Report1%20(1).xlsx

Ask Your Own Programming Question
Customer reply replied 1 year ago
When I try to open I get this:We are sorry, but the requested file doesn't exist or has expired and is no longer available.
You can return to the download page and try again
Programmer: Richard, Consultant replied 1 year ago

strange, go to www.wikisend.com

Click Download and enter in this id 299700 and download please

Ask Your Own Programming Question
Customer reply replied 1 year ago
Ok, I opened it... thank you so much for your help, I do appreciate it however it is not showing what I originally asked for. I need to show the *amount that he was within the 2 business after the due date... .
Programmer: Richard, Consultant replied 1 year ago

You mean the amount of days outside of the 2 days? So how many days late?

Ask Your Own Programming Question
Programmer: Richard, Consultant replied 1 year ago

Please check the file under ID 218892 at www.wikisend.com

As it shows the amount of days outside the two days

Let me know how you go please

Ask Your Own Programming Question
Customer reply replied 1 year ago
are each of the rows with the amount 2 days over due from the end date?
Programmer: Richard, Consultant replied 1 year ago

yes, I get the Due date, I work out the amount of days between it and the Date Read so eg: If it was 1/6 and read 1.6 it would be 0 as it was read on the same date, then I minus 2

But it was doing it the wrong way around, use this version please

436596

When it says for example -2 days it means it was done 2 days earlier then needed.

Ask Your Own Programming Question
Customer reply replied 1 year ago
Ok, but can I get a *total of records that were done with-in the 2 business after the due dateI'm so sorry about the communication... :(
Customer reply replied 1 year ago
amount that he was within the 2 business after the due date...I said *amount, maybe I should have said *total...
Customer reply replied 1 year ago
remember, I don't have the same knowledge as you...
Programmer: Richard, Consultant replied 1 year ago

That is no problem!

I upadated it with this here

487472

Let me know how you go please

Ask Your Own Programming Question
Customer reply replied 1 year ago
D.O.S. Read *Date Read Due Date *Assigned Week amount done with-in 2 business days % done
01/05/16 RP 01/14/16 01/07/16 RPI need to know the total amount of records (D.O.S) each that each doctor read during his assigned week, so if RP week was 1/1/16 to 1/7/16 I need to know the total amount of test that were read with-in that week (which it would be "Date Read" that was 2 *business days of the due date.I don't know how else to explain it... I'm so sorry! :\
Customer reply replied 1 year ago
D.O.S.-----Read-------Date Read----Due Date --Assigned Week-----amount done with-in 2 business days-----% done
01/05/16--RP----------01/14/16-------01/07/16----RP
Programmer: Richard, Consultant replied 1 year ago

So like this? Where each row it shows how many in the entire list was done within the 2 days?

129106

So when you see a row with RP, it shows in the last column all times RP did it within 2 days

Ask Your Own Programming Question
Customer reply replied 1 year ago
You have to add the "Read" into the formula, that will tell me who actually read the report during that week and, if the assigned was the one who "Read" the total that he actually read.
Programmer: Richard, Consultant replied 1 year ago

Sorry I do not understand your last message... are you saying to add the word Read? So just the text?

Ask Your Own Programming Question
Customer reply replied 1 year ago
check out the attached
Programmer: Richard, Consultant replied 1 year ago

an issue occurred with attaching it, can you attach it again please

Ask Your Own Programming Question
Customer reply replied 1 year ago
sorry
Programmer: Richard, Consultant replied 1 year ago

its ok, but it still did not attach.

Go to www.filedropper.com

Upload it there and give me the download link please,

Ask Your Own Programming Question
Customer reply replied 1 year ago
ok, thank you. I'm going to try now...
Programmer: Richard, Consultant replied 1 year ago

thanks

Ask Your Own Programming Question
Customer reply replied 1 year ago
http://www.filedropper.com/pftreport116
Programmer: Richard, Consultant replied 1 year ago

Thanks

This is now done under ID 935372 at www.wikisend.com

Let me know please how you go

Ask Your Own Programming Question
Programmer: Richard, Consultant replied 1 year ago

Hi there

Once you got the final results I never heard back from you or received a rating.

Was there a reason for this?

Please let me know

Ask Your Own Programming Question
Customer reply replied 1 year ago
I'm sorry Richard, you were very kind and willing to help me and I appreciate your effort and the time you took. Unfortunately, the last spreadsheet still did not have the solution that I needed for the report.
Programmer: Richard, Consultant replied 1 year ago

ok.. yet it does everything you are asking, the total times outside the 2 hours and the percentage of that overall.

If thats not what you want, can you please clearly tell me what it is you are requiring...

Ask Your Own Programming Question
Customer reply replied 1 year ago
please look at attachment.
Programmer: Richard, Consultant replied 1 year ago

sorry it did not attach, please attach at www.filedropper.com

Ask Your Own Programming Question
Customer reply replied 1 year ago
Sorry, I forget...http://www.filedropper.com/pftreport17
Programmer: Richard, Consultant replied 1 year ago

thanks, ***** ***** the % overall will that go over all figures or a subset? As over all RP has 13.72% within 2 days, but in the Red it is 0%

Like here it is overall

https://www.dropbox.com/s/v5o9msnwmq7y071/PFT%2BReport1%20%287%29.xlsx?dl=0

Ask Your Own Programming Question
Customer reply replied 1 year ago
sorry, I cant open it...
Customer reply replied 1 year ago
I'm not worried as to how many days he was over, I'm worried how many of those was he over the 2 business days... This is where we are having the miscommunication. I researched the answer and figured out my solution, please see attach.
http://www.filedropper.com/pftreport51
Programmer: Richard, Consultant replied 1 year ago

yes that is what my sheet is doing, the last one did this over.... it calculates everyone that is two days over. Both sheets I have provided have done this

The link is working for me, what do you see when you click it?

Ask Your Own Programming Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a programmerLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask Richard Your Own Question
Richard
Richard
Richard, Consultant
Category: Programming
Satisfied Customers: 47,126
47,126 Satisfied Customers
Experience: Programming and Network consultancy for 15+ years

Richard is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

ATLPROG

ATLPROG

Computer Software Engineer

7,677 satisfied customers

MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML

LogicPro

LogicPro

Computer Software Engineer

7,175 satisfied customers

Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.

unvadim

unvadim

Computer Software Engineer

1,168 satisfied customers

Good knowledge of OOP principles. 3+ years of programming experience with Java and C++. Sun Certified Java Programmer 5.0.

lifesaver

lifesaver

Computer Software Engineer

950 satisfied customers

Several years of intensive programming and application development experience in various platforms.

ehabtutor

ehabtutor

Computer Software Engineer

936 satisfied customers

Bachelor of computer science, 5+ years experience in software development, software company owner

TheDoctor

TheDoctor

Software Engineer

893 satisfied customers

M.S. in Internet Information Systems

The-PC-Guy

The-PC-Guy

Software Engineer

848 satisfied customers

Extensive Knowledge in PHP, MYSQL, CSS & Javascript

< Previous | Next >

Related Programming Questions
Does this forum charge. It's excel formulas. Office 365. I
I run a report on projects once a week and in the report are dates in six columns. I need to write a formula that looks up a project I'd on the latest report look for it on the previous weeks report then look at the first if six cells to see if the dates have changed. If do I need to apply conditional formatting to highlight the change… read more
The-PC-Guy
The-PC-Guy
Software Engineer
Bachelor's Degree
848 satisfied customers
I would really love some help please. The job I have just
I would really love some help please. The job I have just started has some very manual procedures and the right formula could the cut manual processing down the time by 10-15 hours a month, and it wil… read more
Michael Rademacher
Michael Rademacher
MBA
13 satisfied customers
I have a worksheet with rankings for an award. Each nominee
I have a worksheet with rankings for an award. Each nominee is ranked 1-5. I want to awards points, 6,4,3,2,1 for places 1-5. How do I set up a formula to do this for me? … read more
Richard
Richard
Consultant
47,126 satisfied customers
I have a question about excel. I am needing to take totals
I have a question about excel. I am needing to take totals from different reports and move them to one spreadsheet. However, the totals i am wanting to move contain formulas. Is there a way to change … read more
Richard
Richard
Consultant
47,126 satisfied customers
I have a problem in excel that I amnot skilled enough to
I have a problem in excel that I amnot skilled enough to figure out on my own. … read more
Richard
Richard
Consultant
47,126 satisfied customers
I had Microsoft office 2007 and saved all my work in excel
I had Microsoft office 2007 and saved all my work in excel on a portable hard drive...my laptop crashed and i purchased a new laptop with Microsoft Office 2010. My issue is that I can open all my word… read more
TheDoctor
TheDoctor
Software Engineer
Master's Degree
893 satisfied customers
excel will copy but not copy a formula. cuts and pastes but
Excel will copy the contents of a cell but not copy a formula. It cuts and pastes but leaves the cut cell still in its original position. Ctrl x and v not working. Ctrl c working but leaving contents … read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I have a spread sheet that I use for my 501C Mens orginazation.
I have a spread sheet that I use for my 501C Mens orginazation. The spread sheet was configured using the Excel 97 program by my predecessor and had functions in many of the cells. I loaded on to my l… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Hello, I have multiple General Ledgers to balance, is there
Hello, I have multiple General Ledgers to balance, is there a formula to balance db and cr colums, including mltiple transactions on either column? thanks Carmen… read more
Steve The IT Guy
Steve The IT Guy
Master\u0027s Degree
54 satisfied customers
Excell formula please I need to create an excell formula
Excell formula please: I need to create an excell formula for the complex formula in the attached link. Can you help? http://currency-forecasting.blogspot.com/2010/03/technique-3-investigating-coupled… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I am trying to find a way to sort a number of columns first
I am trying to find a way to sort a number of columns first by date (increasing) and then by another column (decreasing) and then pick the largest number in the decreasing column and write it into a c… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
This question is for Ehab if he is available. I have an excel
This question is for Ehab if he is available.If not I am willing to work with someone else. I have an excel worksheet that I am in need of assistance with getting a formula to work more efficiently. T… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I am building a workbook in excel and need help in the formulas
I am building a workbook in excel and need help in the formulas in the pages that are tied in to the input page. I bring over my data into the first page (Input) and then have additional sheets that a… read more
Louis vdW
Louis vdW
Bachelor's Degree
92 satisfied customers
hi there,_ive got a speadsheet with two columns one column
hi there,_ive got a speadsheet with two columns one column with headings and other with actual figures from my report from a cash register till report big problem - my report show the total of the rep… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I have built a complex business model to forecast pro forma
I have built a complex business model to forecast pro forma financial statements. When I change forecasted revenues, none of the formulas in the rest of the worksheet recalculate new results. The form… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
What is a program that can be used to track project cost. I
What is a program that can be used to track project cost. I am a project accountant. I am currently keeping the projects in excel for tracking and reporting purposes. I am constantly adding and deleti… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I am trying to make a X Y line chart in Excel 2003. The Y
I am trying to make a X Y line chart in Excel 2003. The Y axis is date and the X axis is the BMI of a patient on this date. As I weight them every week I would like this chart to automatically expand … read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I HAVE THIS FORMULA IN A DOCUMENT TO WORK OUT THE TERM OF PAYMENTS,
I HAVE THIS FORMULA IN A DOCUMENT TO WORK OUT THE TERM OF PAYMENTS, STARTING FROM FORMULA : =COUNTIF(Sheet2!A$1:A$360,">0") RIGHT DOWN TO : =COUNTIF(Sheet2!X$1:X$360,">0") THE PROBLEM NOW IS THA… read more
C.Martin
C.Martin
IT Consultant
Bachelor's Degree
453 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x