Lowyat.NET: Latest topics by stefan

Help with Excel Calculation

stefan — Tue, 03 May 2011 20:41:15 +0800

I'm trying to figure out how to create a formula according to the values in the table as below:

Range of samples: 1-5 6-10 11-15
Days needed 2.0 3.0 3.0

The range of samples (1-5, 6-10, 11-15) are referring to a number of samples i can cope with in how many days (2.0, 3.0). So when my lab send in says 60 samples at a time, I supposed to use the table above to calculate how many days I should complete by using a formula which I couldn't figure out till now. For instance, the result should be calculated in such a way that i could get a total of 11 days spent for 60 samples:

60 - 15 = 45 (3 days spent)
45 - 15 = 25 (another 3 days spent)
25 - 15 = 10 (another 3 days spent)
10 - 5 = 0 (only 2 days spent)

it's a lot easier when i can grab the value from the 11-15 range once but how can i multiply it (sometimes twice and sometimes more) so that the number left falls in the correct cells so that the "days needed" could be add up with the total of previous sum? Please help!! Thousand thanks in advance.

Reverse Engineering into Diagrams

stefan — Fri, 22 Oct 2010 15:43:08 +0800

I am actually looking for a tool to reverse java code into sequence/activity/use case diagrams. Currently I'm using the StarUML but it often return error whenever am trying to do the reserve engineering. As for the commercial tools, I think that MyEclipse UML and MaintainJ is not bad but again, I hope I could find a free tool that does the forward engineering as well after UML modeling, where the forward engineering step will generate not only the classes and interfaces described in your diagram but also with specified relationships (e.g. inheritance), any recommendation?

[addedon]October 24, 2010, 10:43 am[/addedon]had tried omondo eclipseUML seems pretty good but need to pay *sigh*

Working in GFK?

stefan — Tue, 12 Oct 2010 18:23:24 +0800

Does anybody know how's the working environment at GFK (Mid Valley)? Is the company considered as "big company"? With attractive bonus and benefits?

[addedon]October 12, 2010, 11:38 pm[/addedon]*sigh*.. Really nobody worked in GFK before?