Elikkä jos on tämmöinen tehtävänanto niin mitenkä ja millälailla ton sais tehtyä mahdollisimman yksinkertaisesti ja helpoiten?
Geometrinen jono voi olla vaikka seuraavanlainen:
1, 2, 4, 8, 16, 32, ... eli jonon seuraava termi saadaan kertomalla edellinen kahdella. Tee Excel-taulukko, johon tulee kyseisen jonon 200 ensimmäistä termia. Laske lisäksi näiden summa johonkin soluun.
Geometrinen jono voi olla vaikka seuraavanlainen:
1, 2, 4, 8, 16, 32, ... eli jonon seuraava termi saadaan kertomalla edellinen kahdella. Tee Excel-taulukko, johon tulee kyseisen jonon 200 ensimmäistä termia. Laske lisäksi näiden summa johonkin soluun.
Vastaukset 7
Vanhimmat
eli ihan mahdotonta.
Tuollainen sarja kasvaa niin nopeasti että jo
muutaman kymmenen termin jälkeen mitkään
maailmankaikeuden numeromäärät eivät riitä.
Eivät Excelissäkään.
keksimisestä. Siinä ei laskettu kuin 64 ensimmäistä.
Ihastuneena shakkipelistä, niin kerrotaan, Intian muinainen hallitsija kehotti pelin keksijää itse ehdottamaan palkkionsa. Tämä pyysi muutamia vehnänjyviä, yhden jyvän pelilaudan ensimmäisestä ruudusta, kaksi toisesta, neljä kolmannesta, kahdeksan neljännestä ja niin edespäin aina kaksinkertaisen määrän seuraavasta ruudusta pelilaudan viimeiseen eli kuudenteenkymmenenteenneljänteen ruutuun saakka. Hallitsija ilomielin lupasi täyttää näin kohtuullisen pyynnön. Mutta kun ryhdyttiin laskemaan, paljonko vehnää pyynnön täyttämiseksi tarvittiin, havaittiin, että kaikki maailman pellot eivät vuosisatojenkaan kuluessa kykenisi tuottamaan sellaista määrää. Se oli viljavuori, jota ei tämä kansa ole nähnyt eikä tule koskaan näkemään. Yli 1000 kuutiokilometriä.
Mitenkähän tuon 200 kanssa kävisi?
Kirjoitin soluun A1 1
ja soluun A2 kaava =A1*2
vedin sen soluun A200 asti.
Kyllä näyttäis Excelissä numeroita riittävän
1
2
4
8
16
32
64
128
256
512
1024
2048
4096
8192
16384
32768
65536
131072
262144
524288
1048576
2097152
4194304
8388608
16777216
33554432
67108864
134217728
268435456
536870912
1073741824
2147483648
4294967296
8589934592
17179869184
34359738368
68719476736
137438953472
274877906944
549755813888
1099511627776
2199023255552
4398046511104
8796093022208
17592186044416
35184372088832
70368744177664
140737488355328
281474976710656
562949953421312
1125899906842620
2251799813685250
4503599627370500
9007199254740990
18014398509482000
36028797018964000
72057594037927900
144115188075856000
288230376151712000
576460752303423000
1152921504606850000
2305843009213690000
4611686018427390000
9223372036854780000
18446744073709600000
36893488147419100000
73786976294838200000
147573952589676000000
295147905179353000000
590295810358706000000
1180591620717410000000
2361183241434820000000
4722366482869650000000
9444732965739290000000
18889465931478600000000
37778931862957200000000
75557863725914300000000
151115727451829000000000
302231454903657000000000
604462909807315000000000
1208925819614630000000000
2417851639229260000000000
4835703278458520000000000
9671406556917030000000000
19342813113834100000000000
38685626227668100000000000
77371252455336300000000000
154742504910673000000000000
309485009821345000000000000
618970019642690000000000000
1237940039285380000000000000
2475880078570760000000000000
4951760157141520000000000000
9903520314283040000000000000
19807040628566100000000000000
39614081257132200000000000000
79228162514264300000000000000
158456325028529000000000000000
316912650057057000000000000000
633825300114115000000000000000
1267650600228230000000000000000
2535301200456460000000000000000
5070602400912920000000000000000
10141204801825800000000000000000
20282409603651700000000000000000
40564819207303300000000000000000
81129638414606700000000000000000
162259276829213000000000000000000
324518553658427000000000000000000
649037107316853000000000000000000
1298074214633710000000000000000000
2596148429267410000000000000000000
5192296858534830000000000000000000
10384593717069700000000000000000000
20769187434139300000000000000000000
41538374868278600000000000000000000
83076749736557200000000000000000000
166153499473114000000000000000000000
332306998946229000000000000000000000
664613997892458000000000000000000000
1329227995784920000000000000000000000
2658455991569830000000000000000000000
5316911983139660000000000000000000000
10633823966279300000000000000000000000
21267647932558700000000000000000000000
42535295865117300000000000000000000000
85070591730234600000000000000000000000
170141183460469000000000000000000000000
340282366920938000000000000000000000000
680564733841877000000000000000000000000
1361129467683750000000000000000000000000
2722258935367510000000000000000000000000
5444517870735020000000000000000000000000
10889035741470000000000000000000000000000
21778071482940100000000000000000000000000
43556142965880100000000000000000000000000
87112285931760200000000000000000000000000
174224571863520000000000000000000000000000
348449143727041000000000000000000000000000
696898287454082000000000000000000000000000
1393796574908160000000000000000000000000000
2787593149816330000000000000000000000000000
5575186299632660000000000000000000000000000
11150372599265300000000000000000000000000000
22300745198530600000000000000000000000000000
44601490397061200000000000000000000000000000
89202980794122500000000000000000000000000000
178405961588245000000000000000000000000000000
356811923176490000000000000000000000000000000
713623846352980000000000000000000000000000000
1427247692705960000000000000000000000000000000
2854495385411920000000000000000000000000000000
5708990770823840000000000000000000000000000000
11417981541647700000000000000000000000000000000
22835963083295400000000000000000000000000000000
45671926166590700000000000000000000000000000000
91343852333181400000000000000000000000000000000
182687704666363000000000000000000000000000000000
365375409332726000000000000000000000000000000000
730750818665451000000000000000000000000000000000
1461501637330900000000000000000000000000000000000
2923003274661810000000000000000000000000000000000
5846006549323610000000000000000000000000000000000
11692013098647200000000000000000000000000000000000
23384026197294400000000000000000000000000000000000
46768052394588900000000000000000000000000000000000
93536104789177800000000000000000000000000000000000
187072209578356000000000000000000000000000000000000
374144419156711000000000000000000000000000000000000
748288838313422000000000000000000000000000000000000
1496577676626840000000000000000000000000000000000000
2993155353253690000000000000000000000000000000000000
5986310706507380000000000000000000000000000000000000
11972621413014800000000000000000000000000000000000000
23945242826029500000000000000000000000000000000000000
47890485652059000000000000000000000000000000000000000
95780971304118100000000000000000000000000000000000000
191561942608236000000000000000000000000000000000000000
383123885216472000000000000000000000000000000000000000
766247770432944000000000000000000000000000000000000000
1532495540865890000000000000000000000000000000000000000
3064991081731780000000000000000000000000000000000000000
6129982163463560000000000000000000000000000000000000000
12259964326927100000000000000000000000000000000000000000
24519928653854200000000000000000000000000000000000000000
49039857307708400000000000000000000000000000000000000000
98079714615416900000000000000000000000000000000000000000
196159429230834000000000000000000000000000000000000000000
392318858461668000000000000000000000000000000000000000000
784637716923335000000000000000000000000000000000000000000
1569275433846670000000000000000000000000000000000000000000
3138550867693340000000000000000000000000000000000000000000
6277101735386680000000000000000000000000000000000000000000
12554203470773400000000000000000000000000000000000000000000
25108406941546700000000000000000000000000000000000000000000
50216813883093400000000000000000000000000000000000000000000
100433627766187000000000000000000000000000000000000000000000
200867255532374000000000000000000000000000000000000000000000
401734511064748000000000000000000000000000000000000000000000
803469022129495000000000000000000000000000000000000000000000
muskelit.
"Kyllä näyttäis Excelissä numeroita riittävän"
Ei. Merkkasin kohdan jossa se luovutti ja täyttää
hännät vaan nollilla
1
2
4
8
16
32
64
128
256
512
1024
2048
4096
8192
16384
32768
65536
131072
262144
524288
1048576
2097152
4194304
8388608
16777216
33554432
67108864
134217728
268435456
536870912
1073741824
2147483648
4294967296
8589934592
17179869184
34359738368
68719476736
137438953472
274877906944
549755813888
1099511627776
2199023255552
4398046511104
8796093022208
17592186044416
35184372088832
70368744177664
140737488355328
281474976710656
562949953421312
-->
1125899906842620
2251799813685250
4503599627370500
9007199254740990
18014398509482000
36028797018964000
72057594037927900
144115188075856000
288230376151712000
576460752303423000
1152921504606850000
2305843009213690000
4611686018427390000
9223372036854780000
18446744073709600000
36893488147419100000
73786976294838200000
147573952589676000000
295147905179353000000
590295810358706000000
1180591620717410000000
2361183241434820000000
4722366482869650000000
9444732965739290000000
18889465931478600000000
37778931862957200000000
75557863725914300000000
151115727451829000000000
302231454903657000000000
604462909807315000000000
1208925819614630000000000
2417851639229260000000000
4835703278458520000000000
9671406556917030000000000
19342813113834100000000000
38685626227668100000000000
77371252455336300000000000
154742504910673000000000000
309485009821345000000000000
618970019642690000000000000
1237940039285380000000000000
2475880078570760000000000000
4951760157141520000000000000
9903520314283040000000000000
19807040628566100000000000000
39614081257132200000000000000
79228162514264300000000000000
158456325028529000000000000000
316912650057057000000000000000
633825300114115000000000000000
1267650600228230000000000000000
2535301200456460000000000000000
5070602400912920000000000000000
10141204801825800000000000000000
20282409603651700000000000000000
40564819207303300000000000000000
81129638414606700000000000000000
162259276829213000000000000000000
324518553658427000000000000000000
649037107316853000000000000000000
1298074214633710000000000000000000
2596148429267410000000000000000000
5192296858534830000000000000000000
10384593717069700000000000000000000
20769187434139300000000000000000000
41538374868278600000000000000000000
83076749736557200000000000000000000
166153499473114000000000000000000000
332306998946229000000000000000000000
664613997892458000000000000000000000
1329227995784920000000000000000000000
2658455991569830000000000000000000000
5316911983139660000000000000000000000
10633823966279300000000000000000000000
21267647932558700000000000000000000000
42535295865117300000000000000000000000
85070591730234600000000000000000000000
170141183460469000000000000000000000000
340282366920938000000000000000000000000
680564733841877000000000000000000000000
1361129467683750000000000000000000000000
2722258935367510000000000000000000000000
5444517870735020000000000000000000000000
10889035741470000000000000000000000000000
21778071482940100000000000000000000000000
43556142965880100000000000000000000000000
87112285931760200000000000000000000000000
174224571863520000000000000000000000000000
348449143727041000000000000000000000000000
696898287454082000000000000000000000000000
1393796574908160000000000000000000000000000
2787593149816330000000000000000000000000000
5575186299632660000000000000000000000000000
11150372599265300000000000000000000000000000
22300745198530600000000000000000000000000000
44601490397061200000000000000000000000000000
89202980794122500000000000000000000000000000
178405961588245000000000000000000000000000000
356811923176490000000000000000000000000000000
713623846352980000000000000000000000000000000
1427247692705960000000000000000000000000000000
2854495385411920000000000000000000000000000000
5708990770823840000000000000000000000000000000
11417981541647700000000000000000000000000000000
22835963083295400000000000000000000000000000000
45671926166590700000000000000000000000000000000
91343852333181400000000000000000000000000000000
182687704666363000000000000000000000000000000000
365375409332726000000000000000000000000000000000
730750818665451000000000000000000000000000000000
1461501637330900000000000000000000000000000000000
2923003274661810000000000000000000000000000000000
5846006549323610000000000000000000000000000000000
11692013098647200000000000000000000000000000000000
23384026197294400000000000000000000000000000000000
46768052394588900000000000000000000000000000000000
93536104789177800000000000000000000000000000000000
187072209578356000000000000000000000000000000000000
374144419156711000000000000000000000000000000000000
748288838313422000000000000000000000000000000000000
1496577676626840000000000000000000000000000000000000
2993155353253690000000000000000000000000000000000000
5986310706507380000000000000000000000000000000000000
11972621413014800000000000000000000000000000000000000
23945242826029500000000000000000000000000000000000000
47890485652059000000000000000000000000000000000000000
95780971304118100000000000000000000000000000000000000
191561942608236000000000000000000000000000000000000000
383123885216472000000000000000000000000000000000000000
766247770432944000000000000000000000000000000000000000
1532495540865890000000000000000000000000000000000000000
3064991081731780000000000000000000000000000000000000000
6129982163463560000000000000000000000000000000000000000
12259964326927100000000000000000000000000000000000000000
24519928653854200000000000000000000000000000000000000000
49039857307708400000000000000000000000000000000000000000
98079714615416900000000000000000000000000000000000000000
196159429230834000000000000000000000000000000000000000000
392318858461668000000000000000000000000000000000000000000
784637716923335000000000000000000000000000000000000000000
1569275433846670000000000000000000000000000000000000000000
3138550867693340000000000000000000000000000000000000000000
6277101735386680000000000000000000000000000000000000000000
12554203470773400000000000000000000000000000000000000000000
25108406941546700000000000000000000000000000000000000000000
50216813883093400000000000000000000000000000000000000000000
100433627766187000000000000000000000000000000000000000000000
200867255532374000000000000000000000000000000000000000000000
401734511064748000000000000000000000000000000000000000000000
803469022129495000000000000000000000000000000000000000000000
Niinpä näkyy tekevän. Jossain biljoonan kohdalla (1000000000000)Excel rupeaa tekemään luvuista exponenttilukuja, vai mitä ne nyt mahtaa oikealta nimeltä ollakaan(1,09951E 12).
Siinä vaiheessa loppuu myös häntien laskeminen, ja tulee pelkkiä nollia tilalle.
Alkuperäiselle kysyjälle vielä sen verran että kahdessadas luku on noin.
803469022129495000000000000000000000000000000000000000000000
ja yhteissumma noin
1606938044258990000000000000000000000000000000000000000000000
excel käyttää IEEE (Institute of Electrical and Electronic Engineers)standardia numeroiden varastoimiseen ja sen tarkkuus on 15 numeroa ja sen jälkeiset luvut pyöristetään. Ainoastaan tekstinä voit näyttää isompia lukuja.
tuolta voit latailla apuohjelman, jolla tarkkuudet kohdallaan...
http://xlprecision.precisioncalc.qarchive.org/