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.
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...
I did start out with punch cards! See, I am old. I was at University of WI, Madison in Mechanical Engineering (my half-life was 5 years) and my first punch card program in Fortran hung up the mainframe. They confiscated my program and really thought I did something bad on purpose! Computers...
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...
Hey everyone! Yes, Greg's Mother and I are unbelieveably proud of Greg and his Sister. I'm a bit of a neophyte with forums, but have been into computers since my first Apple II in the early 80's. Yes, I'm that old.
It's very touching to hear all the compliments about Greg!
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...