REKLAMA

arkusz podglądowy (2).xls

Trudne zadanie - automatyczna kalkulacja wybranych komórek

Trzeba podawać przykłady reprezentatywne, obejmujące wszystkie przypadki, jakie mogą zaistnieć. Nie ma sensu komplikować programu przewidując na zapas jaki może wystąpić układ danych. Jeśli bloki mogą występować jeden po drugim, to trzeba zastosować trochę inny algorytm. Kolejność numeracji nie jest brana pod uwagę. Uwzględniana jest tylko zmiana numeru wiersza/bloku. Wiersze bez ukośnika nie są zmieniane.


Pobierz plik - link do postu

" l.p " , " ca?e " , " perfor. " , " d?ugo?? " , " szer. " , " wys. " , " box " , " szer. Obud. " , " typ " ,,,,, " l.p " , " ca?e " , " perfor. " , " d?ugo?? " , " szer. " , " wys. " , " box " , " szer. Obud. " , " typ "
" 1 " , " 0 " , " 21 " , " 804 " , " 668 " , " 954 " , " 150 " , " 658 " ,,,,,, " 1 " , " 0 " , " 21 " , " 804 " , " 668 " , " 954 " , " 150 " , " 658 "
" 2 " , " 0 " , " 15 " , " 567 " , " 1888 " , " 717 " , " 150 " , " 1878 " ,,,,,, " 2 " , " 0 " , " 15 " , " 567 " , " 1888 " , " 717 " , " 150 " , " 1878 "
" 3/1 " , " 0 " , " 37 " , " 1454 " , " 2462 " , " 1604 " , " 150 " , " 2452 " , " z " ,,,,, " 3 " , " 0 " , " 37 " , " 1454 " , " 2462 " , " 1604 " , " 150 " , " 4667 " , " z "
" 3/2 " , " 0 " , " 64 " , " 2499 " , " 2215 " , " 2649 " , " 150 " , " 2205 " , " z " ,,,,,, " 0 " , " 64 " , " 2499 " , " 2215 " , " 2499 " ,,, " z "
" 4 " , " 0 " , " 20 " , " 761 " , " 738 " , " 911 " , " 150 " , " 728 " ,,,,,, " 4 " , " 0 " , " 20 " , " 761 " , " 738 " , " 911 " , " 150 " , " 728 "
" 5 " , " 0 " , " 34 " , " 1336 " , " 1886 " , " 1486 " , " 150 " , " 1876 " ,,,,,, " 5 " , " 0 " , " 34 " , " 1336 " , " 1886 " , " 1486 " , " 150 " , " 1876 "
" 6 " , " 0 " , " 15 " , " 584 " , " 1932 " , " 734 " , " 150 " , " 1922 " ,,,,,, " 6 " , " 0 " , " 15 " , " 584 " , " 1932 " , " 734 " , " 150 " , " 1922 "
" 7/1 " , " 0 " , " 46 " , " 1794 " , " 1482 " , " 1944 " , " 150 " , " 1472 " , " z " ,,,,, " 7 " , " 0 " , " 46 " , " 1794 " , " 1482 " , " 1944 " , " 150 " , " 3136 " , " z "
" 7/2 " , " 0 " , " 33 " , " 1293 " , " 1208 " , " 1443 " , " 150 " , " 1198 " , " p " ,,,,,, " 0 " , " 33 " , " 1293 " , " 1208 " , " 1293 " ,,, " p "
" 7/3 " , " 0 " , " 57 " , " 2212 " , " 456 " , " 2362 " , " 150 " , " 446 " , " z " ,,,,,, " 0 " , " 57 " , " 2212 " , " 456 " , " 2212 " ,,, " z "
" 8 " , " 0 " , " 17 " , " 675 " , " 1529 " , " 825 " , " 150 " , " 1519 " ,,,,,, " 8 " , " 0 " , " 17 " , " 675 " , " 1529 " , " 825 " , " 150 " , " 1519 "
" 9 " , " 0 " , " 60 " , " 2359 " , " 944 " , " 2509 " , " 150 " , " 934 " ,,,,,, " 9 " , " 0 " , " 60 " , " 2359 " , " 944 " , " 2509 " , " 150 " , " 934 "
" 10 " , " 0 " , " 45 " , " 1754 " , " 877 " , " 1904 " , " 150 " , " 867 " ,,,,,, " 10 " , " 0 " , " 45 " , " 1754 " , " 877 " , " 1904 " , " 150 " , " 867 "
" 11/1 " , " 0 " , " 62 " , " 2436 " , " 1187 " , " 2586 " , " 150 " , " 1177 " , " z " ,,,,, " 11 " , " 0 " , " 62 " , " 2436 " , " 1187 " , " 2586 " , " 150 " , " 4574 " , " z "
" 11/2 " , " 0 " , " 54 " , " 2089 " , " 1871 " , " 2239 " , " 150 " , " 1861 " , " p " ,,,,,, " 0 " , " 54 " , " 2089 " , " 1871 " , " 2089 " ,,, " p "
" 11/3 " , " 0 " , " 25 " , " 981 " , " 701 " , " 1131 " , " 150 " , " 691 " , " p " ,,,,,, " 0 " , " 25 " , " 981 " , " 701 " , " 981 " ,,, " p "
" 11/4 " , " 0 " , " 34 " , " 1343 " , " 825 " , " 1493 " , " 150 " , " 815 " , " z " ,,,,,, " 0 " , " 34 " , " 1343 " , " 825 " , " 1343 " ,,, " z "
" 12 " , " 0 " , " 25 " , " 969 " , " 1184 " , " 1119 " , " 150 " , " 1174 " ,,,,,, " 12 " , " 0 " , " 25 " , " 969 " , " 1184 " , " 1119 " , " 150 " , " 1174 "
" 13/1 " , " 0 " , " 52 " , " 2032 " , " 2170 " , " 2182 " , " 150 " , " 2160 " , " x " ,,,,, " 13 " , " 0 " , " 52 " , " 2032 " , " 2170 " , " 2182 " , " 150 " , " 4860 " , " x "
" 13/2 " , " 0 " , " 31 " , " 1209 " , " 2700 " , " 1359 " , " 150 " , " 2690 " , " x " ,,,,,, " 0 " , " 31 " , " 1209 " , " 2700 " , " 1209 " ,,, " x "
,,,,,,,,,,
,,,,,,,,,,
, " TAKIE DANE S? WST?PNIE WPROWADZANE " ,,,,,,,,,,,,, " TAK WYGL?DAJ? DANE PO PRZETWORZENIU " ,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,, " W WIERSZACH OZNACZONYCH PRZEZ " " ZZ " " , " " ZPZ " " , " " ZPPZ " " I " " XX " " DOKONYWANE JEST OBLICZENIE " ,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,, " OBLICZENIE POLEGA NA ZSUMOWANIU WARTO?CI Z KOLUMNY " " SZER. " " W WIERSZACH Z OZNACZENIEM LITEROWYM, MINUS 10 " ,,,,,,,,,,,,
,,,,,,,,,,,,, " A PO DOKONANIU OBLICZENIA, USUWANE S? WARTO?CI W KOLUMNACH " " L.P " " , " " BOX " " ORAZ " " SZER. OBUD. " " ZA WYJ?TKIEM TYCH " ,,,,,,,,,,,,
" l.p " , " ca?e " , " perfor. " , " d?ugo?? " , " szer. " , " wys. " , " box " , " szer. Obud. " , " typ " ,,,,, " UMIESZCZONYCH NAJWY?EJ, A PONADTO LICZBY W " " L.P. " " ZAWIERAJ?CE ZNAK " " / " " S? ZAMIENIANE JAK W TABELI POWY?EJ. " ,,,,,,,,,,,,
" 1 " , " 0 " , " 21 " , " 804 " , " 668 " , " 954 " , " 150 " , " 658 " ,,,
" 2 " , " 0 " , " 15 " , " 567 " , " 1888 " , " 717 " , " 150 " , " 1878 " ,,,
" 3/1 " , " 0 " , " 37 " , " 1454 " , " 2462 " , " 1604 " , " 150 " , " 2452 " , " z " ,,,, " l.p " , " ca?e " , " perfor. " , " d?ugo?? " , " szer. " , " wys. " , " box " , " szer. Obud. " , " typ "
" 3/2 " , " 0 " , " 64 " , " 2499 " , " 2215 " , " 2649 " , " 150 " , " 2205 " , " z " ,,,, " 1 " , " 0 " , " 21 " , " 804 " , " 668 " , " 954 " , " 150 " , " 658 "
" 4/1 " , " 0 " , " 20 " , " 761 " , " 738 " , " 926 " , " 165 " , " 728 " , " z " ,,,, " 2 " , " 0 " , " 15 " , " 567 " , " 1888 " , " 717 " , " 150 " , " 1878 "
" 4/2 " , " 0 " , " 34 " , " 1336 " , " 1886 " , " 1501 " , " 165 " , " 1876 " , " z " ,,,, " 3 " , " 0 " , " 37 " , " 1454 " , " 2462 " , " 1604 " , " 150 " , " 4667 " , " z "
" 6 " , " 0 " , " 15 " , " 584 " , " 1932 " , " 734 " , " 150 " , " 1922 " ,,,,,, " 0 " , " 64 " , " 2499 " , " 2215 " , " 2499 " ,,, " z "
" 7/1 " , " 0 " , " 46 " , " 1794 " , " 1482 " , " 1974 " , " 180 " , " 1472 " , " z " ,,,, " 4 " , " 0 " , " 20 " , " 761 " , " 738 " , " 926 " , " 165 " , " 2614 " , " z "
" 7/2 " , " 0 " , " 33 " , " 1293 " , " 1208 " , " 1473 " , " 180 " , " 1198 " , " p " ,,,,, " 0 " , " 34 " , " 1336 " , " 1886 " , " 1336 " ,,, " z "
" 7/3 " , " 0 " , " 57 " , " 2212 " , " 456 " , " 2392 " , " 180 " , " 446 " , " z " ,,,, " 6 " , " 0 " , " 15 " , " 584 " , " 1932 " , " 734 " , " 150 " , " 1922 "
" 8/1 " , " 0 " , " 17 " , " 675 " , " 1529 " , " 805 " , " 130 " , " 1519 " , " z " ,,,, " 7 " , " 0 " , " 46 " , " 1794 " , " 1482 " , " 1974 " , " 180 " , " 3136 " , " z "
" 8/2 " , " 0 " , " 60 " , " 2359 " , " 944 " , " 2489 " , " 130 " , " 934 " , " p " ,,,,, " 0 " , " 33 " , " 1293 " , " 1208 " , " 1293 " ,,, " p "
" 8/3 " , " 0 " , " 45 " , " 1754 " , " 877 " , " 1884 " , " 130 " , " 867 " , " z " ,,,,, " 0 " , " 57 " , " 2212 " , " 456 " , " 2212 " ,,, " z "
" 11 " , " 0 " , " 62 " , " 2436 " , " 1187 " , " 2586 " , " 150 " , " 4574 " , " z " ,,,, " 8 " , " 0 " , " 17 " , " 675 " , " 1529 " , " 805 " , " 130 " , " 3340 " , " z "
, " 0 " , " 54 " , " 2089 " , " 1871 " , " 2089 " ,,, " p " ,,,,, " 0 " , " 60 " , " 2359 " , " 944 " , " 2359 " ,,, " p "
, " 0 " , " 25 " , " 981 " , " 701 " , " 981 " ,,, " p " ,,,,, " 0 " , " 45 " , " 1754 " , " 877 " , " 1754 " ,,, " z "
, " 0 " , " 34 " , " 1343 " , " 825 " , " 1343 " ,,, " z " ,,,, " 11 " , " 0 " , " 62 " , " 2436 " , " 1187 " , " 2586 " , " 150 " , " 4574 " , " z "
" 12 " , " 0 " , " 25 " , " 969 " , " 1184 " , " 1119 " , " 150 " , " 1174 " ,,,,,, " 0 " , " 54 " , " 2089 " , " 1871 " , " 2089 " ,,, " p "
" 13 " , " 0 " , " 52 " , " 2032 " , " 2170 " , " 2182 " , " 150 " , " 4860 " , " x " ,,,,, " 0 " , " 25 " , " 981 " , " 701 " , " 981 " ,,, " p "
, " 0 " , " 31 " , " 1209 " , " 2700 " , " 1209 " ,,, " x " ,,,,, " 0 " , " 34 " , " 1343 " , " 825 " , " 1343 " ,,, " z "
,,,,,,,,,,,, " 12 " , " 0 " , " 25 " , " 969 " , " 1184 " , " 1119 " , " 150 " , " 1174 "
,,,,,,,,,,,, " 13 " , " 0 " , " 52 " , " 2032 " , " 2170 " , " 2182 " , " 150 " , " 4860 " , " x "
,,,,,,,,,,,,, " 0 " , " 31 " , " 1209 " , " 2700 " , " 1209 " ,,, " x "
,,,,,,,,,,,,, " Rezultat przekszta?ce?. Skrypt traktuje now? pierwsz? cyfr? w kolumnie l.p, jako now? grup? do przekszta?ce?. Tak samo jest zarówno dla zestawie? " " zpz " " jak i " " xxx " " . " ,,,,,,
,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,