|
My first impression is you can have a Weighing class with three fields: scaleName, date, and weight. Then a generic List<Weighing>.
Reading from the database into List<Weighing> is easy; just make a new Weighing object for each database record, and add it to the list.
Once you have all the Weighings in a list, you can easily manipulate them.
To get a list of all the scales for example, for each Weighing, insert the scaleName member into a generic Dictionary<string>.
To get a list of all the Weighings for a particular scale sorted by date, for each Weighing in the original list, insert the Weighing into a new SortedList<Weighing> if the scaleName member equals the particular scale.
modified on Tuesday, August 5, 2008 10:48 AM
|
|
|
|
|
While its nice to have your domain model all sorted out, your scenario is purely a reporting requirement. Database servers are designed for, and are very good and very fast at doing these manipulations - do it there, and get the results back as a dataset if you have to.
Even if your data layer supports aggregations, its rare that your query actually matches the model - so you could have a list of Chickens which arent real Chicken instances which kind of represents the average Chicken for the Scale they point at - are you going to get a benefit from this? Generally I find its easier to hook data up using data sets for reporting purposes - using reporting services.
|
|
|
|
|
Hi. I want some stuff regarding Bin Packing Algorithm. plz help me.
modified on Thursday, July 31, 2008 1:12 AM
|
|
|
|
|
2489128 wrote: I want to sum stuff
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke
[My articles]
|
|
|
|
|
|
What help you need? Idea how to do it or just code so you don't have to and not learn a thing?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Actually i want detailed stuff i.e. theory, Calculating order etc. I've to implement it in my project.
|
|
|
|
|
And none of the 6360 hits for bin packing algorithm that come up on Google helped you any?
If you don't have the data, you're just another a**hole with an opinion.
|
|
|
|
|
Actually I've found some good stuff but all are paid.
1
2
3
I want some free stuff for study purpose.
|
|
|
|
|
Does this [^] help?
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke
[My articles]
|
|
|
|
|
2489128 wrote: I want some free stuff for study purpose.
Then you needed to be more specific in your question. Your question essentially came across as I have a homework assignment that involves the bin packing algorithm and you're too lazy to even look it up. You didn't tell us what you knew or didn't know. There was no specific question.
If you don't have the data, you're just another a**hole with an opinion.
|
|
|
|
|
You may also try to implement it using Simulated Annealing [^].
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke
[My articles]
|
|
|
|
|
Tim Craig wrote: none of the 6360 hits for bin packing algorithm that come up on Google helped you any?
Certainly there has to be something useful in those 6360 results 
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Paul Conrad wrote: Certainly there has to be something useful in those 6360 results
I learned more about it than I wanted to from the first one, the Wikipedia article. 
If you don't have the data, you're just another a**hole with an opinion.
|
|
|
|
|
Which part? Where it says that it is a combinatorial NP-hard problem?
OT: Now only if google could help me figure out why Access won't work with a .dll I registered grrrrrrrrr
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Paul Conrad wrote: Where it says that it is a combinatorial NP-hard problem?
Pretty much. I actually worked on a project that did order picking of product from a carousel system to bins about 20 or so years ago. Fortunately, I got to work on more interesting parts of it and then went off to better problems.
Paul Conrad wrote: why Access won't work
Microsoft? 
If you don't have the data, you're just another a**hole with an opinion.
|
|
|
|
|
Tim Craig wrote: Microsoft? [Poke tongue]
Uh huh. The bastard works locally, but once I try to run the database over the network, it freaks out over the .dll, registered and everything. Nothing like doing a demo to the client, selling them on it, and now it craps.
They heard plenty of ranting and raving about Access today before this project 
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
The way the searching goes these days, maybe the cure for cancer... Or one of those fake websites that plauge google and pops up with people offering to pack your bins. Who knows? Google doesn't .
He who asks a question is a fool for five minutes. He who does not ask a question remains a fool forever. [Chineese Proverb]
Jonathan C Dickinson (C# Software Engineer)
|
|
|
|
|
I have solved FDIST in C#. now I have to find FINV
Which Returns the inverse of the F probability distribution. If p = FDIST(x,...), then FINV(p,...) = x.
Any idea about this. how to find inverse of the F probability distribution
Syntax
FINV(probability,degrees_freedom1,degrees_freedom2)
Probability is a probability associated with the F cumulative distribution.
Degrees_freedom1 is the numerator degrees of freedom.
Degrees_freedom2 is the denominator degrees of freedom.
thanks in advance
|
|
|
|
|
Follow the same steps you did before with the FDIST. Research for the algorithm how to do it, find code implementing the algorithm, and code yours.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
I Didn't Find any algorithm related to finv anywhere.
except that
FINV depends on precision of FDIST. FINV uses an iterative search technique. If the search has not converged after 100 iterations, the function returns the #N/A error value.
now i dont know how to do these iterations using FDIST?
|
|
|
|
|
|
Does it work as well as the one in Excel?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
|
Very nice. Have you considered writing an article about what you have been doing lately with all of these statistics problem you have been encountering?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
