LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 258
Default Histogram Bins Created From Sum Of Two Cells

I'm trying to model patient flow delays through a receptionist and a nurse to
see a doctor. I've got a two dimentional array, with the distribution of
delays created by a receptionist across the top, and those created by nursing
preparation down the side. In each cell, I have the percentage of patients
experiencing that combination of delays, kind of like this:

Receptionist Causes
2min 3min 4min 5min 6min
N 4min 2% 3% 6%
u 6min 8% 11%
r 8min 5%
s
etc.

The patient doesn't care (rightfully) whether the delay is created by the
receptionist or the nurse so I want to create an output histogram showing the
SUM of the two delays. Two patients wait eight minutes, but one delay was
caused mostly by the receptionist, and the other mostly by the nurse. He
doesn't care. I want to create a histogram from this table showing the
percentage of patients experiencing each level of total delay.

Then, I can go back and design process changes or staffing changes to reduce
those delays in a predictable way. Also, I can use the output as input for
queueing models at the next step (say, the doc, the lab, x-ray, an expensive
piece of equipment, etc.)

I've tried using SUMIF kinds of approaches, but have failed. I'm a VERY
novice VBA writer, so any help would be appreciated.

Thanks in advance.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
bins, frequency function Ellen Excel Discussion (Misc queries) 1 March 20th 10 09:43 PM
Histogram bins driving me crazy-please HELP Emily Excel Worksheet Functions 5 July 15th 08 10:56 PM
Histogram bins being ignored Emily Excel Discussion (Misc queries) 0 July 11th 08 05:20 PM
histogram from cells with formulas supersonikk Charts and Charting in Excel 2 May 29th 08 01:06 PM
How to Histogram w/o raw data but histogram Table on Excel 2005 Charts and Charting in Excel 1 February 1st 06 06:48 AM


All times are GMT +1. The time now is 03:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"