國際象棋,不用VBA
《國際象棋,不用VBA》由會員分享,可在線閱讀,更多相關(guān)《國際象棋,不用VBA(35頁珍藏版)》請在裝配圖網(wǎng)上搜索。
1、The Immortal Game -Adolf Anderssen vs Kieseritsky(1851)Excel craft:Daniel Ferrydaniel.ferryDemonstrates:Popcorn Chart Chess Game ViewerCombination of XY(Scatter)and Stacked Column chart typesMarker Fill with picture files.Conditional Chart Formatting for chessboard styleDynamic Charting with No VBAN
2、o IF()fucntions.Not even one.REPT()and boolean logic as alternative to IF()INDEX/MATCHThe most famous chess game of all time-NotesProject crafted on February 12,2010.Chess Game Viewer requires IFCC Numeric Notation for game input.The Algebraic Notation issimply for display.Disambiguity of the Algebr
3、aic Notation by formula proved too demanding forthis simple demonstration project.It would be interesting to complete the formulaic parsing ona future version.I plan to use the Windows Sockets API from VBA to enable live game play over the internet.Current version uses no VBA.Game Viewer currently s
4、upports games with queenside castling.It does not supportpawn promotion,yet.Workbook license:Creative Commons,Attribution 3.0 United StatesChess piece images courtesy of:Maurizio MongeMovesWhiteBlack1e4e52f4exf43Bc4Qh4+4Kf1b55Bxb5Nf66Nf3Qh67d3Nh58Nh4Qg59Nf5c610g4Nf611Rg1cxb512h4Qg613h5Qg514Qf3Ng815B
5、xf4Qf616Nc3Bc517Nd5Qxb218Bd6Bxg119e5Qxa1+20Ke2Na621Nxg7+Kd822Qf6+Nxf623Be7#1-0Chessboard Style:ModernChess Game Viewer requires IFCC Numeric Notation for game input.The Algebraic Notation issimply for display.Disambiguity of the Algebraic Notation by formula proved too demanding forthis simple demon
6、stration project.It would be interesting to complete the formulaic parsing ona future version.I plan to use the Windows Sockets API from VBA to enable live game play Chessboard-Stacked Column chart typeY-AxisSeries 0Series 1Series 2Series 3Series 4110101200101310101400101510101600101710101800101Seri
7、es 1bSeries 3b1111111111111111Pieces-XY(Scatter)chart typeWhitexywb13.021.5wb26.021.5wk5.021.5wn12.021.5wn27.021.5wq4.021.5wr11.021.5wr28.021.5wp11.022.5wp22.022.5wp33.022.5wp44.022.5wp55.022.5wp66.022.5wp77.022.5wp88.022.5Series 5Series 6Series 7Series 8Series 90101001010010100101001010010100101001
8、010Series 5bSeries 7bSeries 9b111111111111111111111111Blackxybb13.028.5bb26.028.5bk5.028.5bn12.028.5bn27.028.5bq4.028.5br11.028.5br28.028.5bp11.027.5bp22.027.5bp33.027.5bp44.027.5bp55.027.5bp66.027.5bp77.027.5bp88.027.5ndxMove-00MovesSquarexy1111wr1WhiteBlack2121wn11525457553131wb12626455644141wq361
9、3448845151wk4516127256161wb25342578667171wn26716384868181wr27424366851212wp18638486752222wp29846537363232wp310727485664242wp411817136255252wp512828475766262wp613848576757272wp714416366788282wp815316475661313162133683523231733456622333318644635714343195455221153532061522816636321657758487373226366786
10、683832346571414242424253434264444275454286464297474308484311515322525333535344545355555366565377575388585391616402626413636424646435656446666457676468686471717bp1482727bp2493737bp3504747bp4515757bp5526767bp6537777bp7548787bp81818br12828bn13838bb14848bq5858bk6868bb27878bn28888br2123456789525762556148
11、512734545564643484612525wr1wr1wr1wr1wr1wr1wr1wr1wr1wn1wn1wn1wn1wn1wn1wn1wn1wn1wb1wb1wb1wb1wb1wb1wb1wb1wb1wqwqwqwqwqwqwqwqwqwkwkwkwkwkwkwb2wb2wb2wb2wkwkwkwn2wn2wn2wn2wn2wn2wn2wn2wn2wr2wr2wr2wr2wr2wr2wr2wr2wr2wp1wp1wp1wp1wp1wp1wp1wp1wp1wp2wp2wp2wp2wp2wp2wp2wp2wp2wp3wp3wp3wp3wp3wp3wp3wp3wp3wp4wp4wp4wp4
12、wp4wp4wp4wp4wp4wp6wp6wp7wp7wp7wp7wp7wp7wp7wp7wp7wp8wp8wp8wp8wp8wp8wp8wp8wp8wb2wb2wb2wb2wp5wp5wp5wp5wp5wp5wp5wp5wp5wp6bp5bp5bp5bp5bp5bp5bqbqbqbqbp2wb2bp5bp5bp1bp1bp1bp1bp1bp1bp1bp1bp1bp2bp2bp2bp2bp2bp2bp2bp3bp3bp3bp3bp3bp3bp3bp3bp3bp4bp4bp4bp4bp4bp4bp4bp4bp4bp5bp6bp6bp6bp6bp6bp6bp6bp6bp6bp7bp7bp7bp7b
13、p7bp7bp7bp7bp7bp8bp8bp8bp8bp8bp8bp8bp8bp8br1br1br1br1br1br1br1br1br1bn1bn1bn1bn1bn1bn1bn1bn1bn1bb1bb1bb1bb1bb1bb1bb1bb1bb1bqbqbqbqbqbkbkbkbkbkbkbkbkbkbb2bb2bb2bb2bb2bb2bb2bb2bb2bn2bn2bn2bn2bn2bn2bn2bn2bn2br2br2br2br2br2br2br2br2br2101112131415161718787184426663868437666386438584756536wr1wr1wr1wr1wr1
14、wr1wr1wr1wr1wn1wn1wn1wn1wn1wn1wn1wn1wn1wb1wb1wb1wb1wb1wb1wb1wb1wb1wqwqwqwqwqwqwqwqwqwkwkwkwkwkwkwkwkwkwn2wr2wr2wr2wr2wr2wr2wr2wr2wr2wp1wp1wp1wp1wp1wp1wp1wp1wp1wp2wp2wp2wp2wp2wp2wp2wp2wp2wp3wp3wp3wp3wp3wp3wp3wp3wp3wp4wp4wp4wp7wp7wp7wp7wp7wp7wp7wp7wp7wp8wp8wp8wp8wp8wp8wp8wp8wp8wp4wp4wp4wp4wp4wp4wn2wn2
15、wn2wn2wp5wp5wp5wp5wp5wp5wp5wp5wp5bp5bp5bp5bp5bp5bp5bp5bp5bp5bqbqwn2wn2wb2wb2wb2wb2wb2wb2wb2wb2wb2wn2wn2bqbqbqbn2bn2bn2bn2bn2bp3bn2bn2bn2bn2bqbqbqbqbp1bp1bp1bp1bp1bp1bp1bp1bp1bp3bp3bp3bp3bp3bp3bp3bp3bp4bp4bp4bp4bp4bp4bp4bp4bp4bp6bp6bp6bp6bp6bp6bp6bp6bp6bp7bp7bp7bp7bp7bp7bp7bp7bp7bp8bp8bp8bp8bp8bp8bp8
16、bp8bp8br1br1br1br1br1br1br1br1br1bn1bn1bn1bn1bn1bn1bn1bn1bn1bb1bb1bb1bb1bb1bb1bb1bb1bb1bkbkbkbkbkbkbkbkbkbb2bb2bb2bb2bb2bb2bb2bb2bb2br2br2br2br2br2br2br2br2br2192021222324252627728581368275847641746671258476857563wr1wr1wr1wr1wr1wr1wr1wr1wr1wn1wn1wn1wn1wn1wn1wn1wn1wn1wb1wb1wb1wb1wb1wb1wb1wb1wb1wqwqwq
17、wqwqwqwqwqwkwkwkwkwkwkwkwkwkwr2wr2wr2wr2wr2wr2wr2wr2wr2wp1wp1wp1wp1wp1wp1wp1wp1wp1wp2wp2wp2wp2wp2wp2wp2wp2wp2wp3wp3wp3wp3wp3wp3wp3wp3wp3wp8wp8wp8wp8wp4wp4wp4wp4wp4wp4wp4wp4wp4wqwp5wp5wp5wp5wp5wp5wp5wp5wp5bp5bp5bp5bp5bp5bp5bp5bp5bp5wp7wp7wp7wp7wp7wp7wp7wp7wp7wp8wp8wb2wb2wb2bp3bp3bp3bp3bp3bp3wn2wn2wn2
18、wn2wn2wn2wn2wn2wn2bqbqbqbqbqbqbqbn2wp8wp8wp8bp3bp3bp3bn2bn2bn2bn2bn2bn2bn2bn2bqbqbp1bp1bp1bp1bp1bp1bp1bp1bp1bp4bp4bp4bp4bp4bp4bp4bp4bp4bp6bp6bp6bp6bp6bp6bp6bp6bp6bp7bp7bp7bp7bp7bp7bp7bp7bp7bp8bp8bp8bp8bp8bp8bp8bp8bp8br1br1br1br1br1br1br1br1br1bn1bn1bn1bn1bn1bn1bn1bn1bn1bb1bb1bb1bb1bb1bb1bb1bb1bb1bkb
19、kbkbkbkbkbkbkbkbb2bb2bb2bb2bb2bb2bb2bb2bb2br2br2br2br2br2br2br2br2br2282930313233343536663175216833666435786466333545224671wr1wr1wr1wr1wr1wr1wr1wr1wr1wn1wn1wn1wb1wkwkwkwkwkwkwkwkwkwr2wr2wr2wr2wr2wr2wr2wr2bb2wp1wp1wp1wp1wp1wp1wp1wp1wp1wp2wp2wp2wp2wp2wp2bqbqbqwp3wp3wp3wp3wp3wp3wp3wp3wp3wn1wn1wp4wp4wp4
20、wp4wp4wp4wp4wp4wp4wqwqwqwqwqwqwqwqwqwp5wp5wp5wp5wp5wp5wp5wp5wp5bp5wb1wb1wb1wb1wb1wb1wp7wp7wp7wp7wp7wp7wp7wp7wp7bp3bp3bp3bp3bp3bp3bp3bp3bp3bb2bb2bb2bb2wn1wn1wn1wn1wn2wn2wn2wn2wn2wn2wn2wn2wn2bqbqwp8wp8wp8wp8wp8wp8wp8wp8wp8wb1wb1bqbqbqbqbp1bp1bp1bp1bp1bp1bp1bp1bp1bp4bp4bp4bp4bp4bp4bp4bp4bp4bp6bp6bp6bp6
21、bp6bp6bp6bp6bp6bp7bp7bp7bp7bp7bp7bp7bp7bp7bp8bp8bp8bp8bp8bp8bp8bp8bp8br1br1br1br1br1br1br1br1br1bn1bn1bn1bn1bn1bn1bn1bn1bn1bb1bb1bb1bb1bb1bb1bb1bb1bb1bkbkbkbkbkbkbkbkbkbb2bb2bb2bb2bn2bn2bn2bn2bn2bn2bn2bn2bn2br2br2br2br2br2br2br2br2br2373839404142434445542261286558637846551152167748666657wr1bqbqbqbqb
22、qbqbqbqwkwkbb2bb2bb2bb2bb2bb2bb2bb2bb2wp1wp1wp1wp1wp1wp1wp1wp1wp1bqwp3wp3wp3wp3wp3wp3wp3wp3wp3wkwkwkwkwkwkwkwp4wp4wp4wp4wp4wp4wp4wp4wp4wqwqwqwqwqwqwp7wp7wp7wp7wp7wp7wp7wp7wp7bp3bp3bp3bp3bp3bp3bp3bp3bp3wn1wn1wn1wn1wn1wn1wn1wn1wn1wp5wp5wp5wp5wp5wp5wp5wp5wp5wn2wn2wn2wn2wp8wp8wp8wp8wp8wp8wp8wp8wp8bn1bn1
23、bn1bn1bn1bn1wb1wb1wb1wb1wb1wb1wb1wb1wqbn2bn2bp1bp1bp1bp1bp1bp1bp1bp1bp1bp4bp4bp4bp4bp4bp4bp4bp4bp4wb1bp6bp6bp6bp6bp6bp6bp6bp6bp6bp7bp7bp7bp7wn2wn2wn2wn2wn2bp8bp8bp8bp8bp8bp8bp8bp8bp8br1br1br1br1br1br1br1br1br1bn1bn1bn1bb1bb1bb1bb1bb1bb1bb1bb1bb1bkbkbkbkbkbkbkbkbkbn2bn2bn2bn2bn2bn2bn2br2br2br2br2br2b
24、r2br2br2br2464748495051525354#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALU
25、E!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VAL
26、UE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VA
27、LUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#V
28、ALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#
29、VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!
30、#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE
31、!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALU
32、E!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VAL
33、UE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VA
34、LUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#V
35、ALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#
36、VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!
- 溫馨提示:
1: 本站所有資源如無特殊說明,都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請下載最新的WinRAR軟件解壓。
2: 本站的文檔不包含任何第三方提供的附件圖紙等,如果需要附件,請聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶所有。
3.本站RAR壓縮包中若帶圖紙,網(wǎng)頁內(nèi)容里面會有圖紙預(yù)覽,若沒有圖紙預(yù)覽就沒有圖紙。
4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
5. 裝配圖網(wǎng)僅提供信息存儲空間,僅對用戶上傳內(nèi)容的表現(xiàn)方式做保護(hù)處理,對用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯,并不能對任何下載內(nèi)容負(fù)責(zé)。
6. 下載文件中如有侵權(quán)或不適當(dāng)內(nèi)容,請與我們聯(lián)系,我們立即糾正。
7. 本站不保證下載資源的準(zhǔn)確性、安全性和完整性, 同時也不承擔(dān)用戶因使用這些下載資源對自己和他人造成任何形式的傷害或損失。