國(guó)際象棋,不用VBA
《國(guó)際象棋,不用VBA》由會(huì)員分享,可在線閱讀,更多相關(guān)《國(guó)際象棋,不用VBA(35頁(yè)珍藏版)》請(qǐng)?jiān)谘b配圖網(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: 本站所有資源如無(wú)特殊說(shuō)明,都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請(qǐng)下載最新的WinRAR軟件解壓。
2: 本站的文檔不包含任何第三方提供的附件圖紙等,如果需要附件,請(qǐng)聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶所有。
3.本站RAR壓縮包中若帶圖紙,網(wǎng)頁(yè)內(nèi)容里面會(huì)有圖紙預(yù)覽,若沒(méi)有圖紙預(yù)覽就沒(méi)有圖紙。
4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
5. 裝配圖網(wǎng)僅提供信息存儲(chǔ)空間,僅對(duì)用戶上傳內(nèi)容的表現(xiàn)方式做保護(hù)處理,對(duì)用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯,并不能對(duì)任何下載內(nèi)容負(fù)責(zé)。
6. 下載文件中如有侵權(quán)或不適當(dāng)內(nèi)容,請(qǐng)與我們聯(lián)系,我們立即糾正。
7. 本站不保證下載資源的準(zhǔn)確性、安全性和完整性, 同時(shí)也不承擔(dān)用戶因使用這些下載資源對(duì)自己和他人造成任何形式的傷害或損失。
最新文檔
- 市教育局冬季運(yùn)動(dòng)會(huì)安全工作預(yù)案
- 2024年秋季《思想道德與法治》大作業(yè)及答案3套試卷
- 2024年教師年度考核表個(gè)人工作總結(jié)(可編輯)
- 2024年xx村兩委涉案資金退還保證書(shū)
- 2024年憲法宣傳周活動(dòng)總結(jié)+在機(jī)關(guān)“弘揚(yáng)憲法精神推動(dòng)發(fā)改工作高質(zhì)量發(fā)展”專(zhuān)題宣講報(bào)告會(huì)上的講話
- 2024年XX村合作社年報(bào)總結(jié)
- 2024-2025年秋季第一學(xué)期初中歷史上冊(cè)教研組工作總結(jié)
- 2024年小學(xué)高級(jí)教師年終工作總結(jié)匯報(bào)
- 2024-2025年秋季第一學(xué)期初中物理上冊(cè)教研組工作總結(jié)
- 2024年xx鎮(zhèn)交通年度總結(jié)
- 2024-2025年秋季第一學(xué)期小學(xué)語(yǔ)文教師工作總結(jié)
- 2024年XX村陳規(guī)陋習(xí)整治報(bào)告
- 2025年學(xué)校元旦迎新盛典活動(dòng)策劃方案
- 2024年學(xué)校周邊安全隱患自查報(bào)告
- 2024年XX鎮(zhèn)農(nóng)村規(guī)劃管控述職報(bào)告