KöMaL - Középiskolai Matematikai és Fizikai Lapok
Sign In
Sign Up
 Magyar
Information
Contest
Journal
Articles

 

Problem I. 159. (April 2007)

I. 159. A lumber yard sells wooden boards of fixed length, but their cross-section can be freely determined by the customers. The yard cuts the appropriate boards out of trunks of different diameter. Due to the manufacturing technology they cut only right prism shaped, parallel boards of the same size out of a given trunk. The figure shows a possible arrangement.

You should prepare an Excel sheet that chooses between three cutting sizes so that the waste of wood is minimal when the boards are manufactured. Your file should contain two sheets, the first specifying the three possible cutting sizes, e.g. 10 cm×20 cm, 15 cm×15 cm and 12 cm×17 cm, further, the diameter of the trunk, e.g. 87 cm. Your answer should also appear here, giving which cutting size is optimal to that diameter. Auxiliary computations should be performed on the second sheet.

We will take into account the user-friendliness of your sheets (e.g. cell protection) too. (If cell protection is applied, there is no need to specify a password.)

The worksheet with your solution (i159.xls, \ldots) should be submitted.

(10 pont)

Deadline expired on 15 May 2007.


Sorry, the solution is available only in Hungarian. Google translation

Kovács Péter (Szolnok, Verseghy Ferenc Gimnázium) megoldása. Köztünk szólva, a felületet még lehetett volna csicsázni kicsit, de a táblázatos elrendezés, és a megfelelő cellák védelme a fontos.

i159.xls


Statistics:

13 students sent a solution.
10 points:Balambér Dávid, Danka Miklós András, Gál Tibor, Györök Péter, Kovács 129 Péter, Ridinger Tamás, Szoldatics András, Véges Márton, Vincze János.
9 points:Czigler András.
6 points:1 student.
1 point:2 students.

Our web pages are supported by:   Ericsson   Cognex   Emberi Erőforrás Támogatáskezelő   Emberi Erőforrások Minisztériuma   Nemzeti Tehetség Program    
MTA Energiatudományi Kutatóközpont   MTA Wigner Fizikai Kutatóközpont     Nemzeti
Kulturális Alap   ELTE   Morgan Stanley