國際象棋,不用VBA

上傳人：dfg****19 文檔編號：253438701 上傳時間：2024-12-16 格式：XLS 頁數(shù)：35 大?。?09.59KB

收藏版權申訴舉報下載

第1頁 / 共35頁

第2頁 / 共35頁

第3頁 / 共35頁

下載文檔到電腦，查找使用更方便

15 積分

下載資源

還剩頁未讀，繼續(xù)閱讀

資源描述：

《國際象棋,不用VBA》由會員分享，可在線閱讀，更多相關《國際象棋,不用VBA（35頁珍藏版）》請在裝配圖網上搜索。

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)系上傳者。文件的所有權益歸上傳用戶所有。
3.本站RAR壓縮包中若帶圖紙，網頁內容里面會有圖紙預覽，若沒有圖紙預覽就沒有圖紙。
4. 未經權益所有人同意不得將文件中的內容挪作商業(yè)或盈利用途。
5. 裝配圖網僅提供信息存儲空間，僅對用戶上傳內容的表現(xiàn)方式做保護處理，對用戶上傳分享的文檔內容本身不做任何修改或編輯，并不能對任何下載內容負責。
6. 下載文件中如有侵權或不適當內容，請與我們聯(lián)系，我們立即糾正。
7. 本站不保證下載資源的準確性、安全性和完整性, 同時也不承擔用戶因使用這些下載資源對自己和他人造成任何形式的傷害或損失。

點擊下載此資源

國際象棋,不用VBA

最新文檔

相關資源

相關搜索