Recent content by Greg'sDad

I de-constructed your model spreadsheet to the point where it really gets interesting. Am I correct that now brute-force trial and error steps are needed to complete the matrix? I've never seen the Excel index command, and that's extremely powerful in this exercise.

OK. I confess you're way ahead of me! Now you say this is actually easy? I'm in awe.

(1 2 3 4) (5 6 7 8) (9 10 11 12) (13 14 15 16) (1 5 9 13) (2 6 10 14) (3 7 11 15) (4 8 12 16) (1 6 11 16) (2 5 12 15) (3 8 9 14) (4 7 10 13) (1 7 12 14) (2 8 11 13) (3 5 10 16) (4 6 9 15) Minor change to make sure couple #13 hosts only once... Amazing work. My challenge will come now...

Absolutely amazing! We need the following small change so #13 doesn't host twice: (1 2 3 4) (5 6 7 8) (9 10 11 12) (13 14 15 (16 hosts)) (I don't see how to format) (1 5 9 13) (2 6 10 14) (3 7 11 15) (4 8 12 16) (1 6 11 16) (2 5 12 15) (3 8 9 14) (4 7 10 13) (1 7 12 14) (2 8 11 13) (3 5 10...

It's really an interesting problem. I'd make a small change to start with: (1 2 3 4) (5 6 7 8) (9 10 11 12) (13 14 15 16) (1 5 9 13) (2 6 10 14) (3 7 11 15) (4 8 12 16) (1 6 11 16) (2 7 12 13) (3 8 9 14) (4 5 10 15) (1 7 12 14) (2 8 9 15) (3 5 11 13) (4 6 10 16)

It was careless for me not to mention that... Apologies. By the way, the next planning session won't happen until next summer, so don't feel rushed... Thanks again.

I spent more time reviewing the solution and see a problem. Maybe it has to do with how to use the result. If I look at the first four rows as being the first dinner session, couple #5 attends with three hosts. They should be assigned to only one row(host).

It certainly seems you've solved the problem! Just brilliant... I tried a simple 2 dimensional matrix and quickly saw that fail. I'm impressed (not that I'm surprised to be). I'll need to dive into your approach to see if I can duplicate it myself as the number of caveats and/or as...

It's been 40 years since engineering school, so I could use some help. We have a subdivision dinner club. Each year, a leader sets up the schedule. Knowns: Number of couples, usually around 16 Number of dinners attended each season, 4 Number of couples per home, usually 4 including the...

Thanks for all the comments. VAV = variable air volume system. We provide tempered air year round to the areas of the building, and reheat with electricity. Electricity is used for cooling and heating all year round. It's a 4 story mostly office building which is 2 1/2 years new...

As I fine tune our VAV HVAC system (506,000 sq.ft. facility), we'd like to determine the effectiveness of our adjustments over time. As we both heat and cool portions of the building at the same time (electric VAV reheat), we need to apply degree days to the analysis. How is that done...