现看效果
主要用了excle的随机函数rand（）；和排序函数RANK.EQ（）
操作很简单，在无关的地方按个del或者F9，注意笔记本可能是Fn+f9
逻辑：
解释一下公式
J3单元格=INDEX($R$2:$R$11,RANK.EQ(S2,$S$2:$S$11))
rank.eq 表示选出s2在s2到s11中顺序号，1-11，假设顺序是3,
index($R$2:$R$11,3) 就表示从R2:R11 中的第3个的值，那么应该就是=主考官3了；
注意里边用了$表示绝对引用；
K3=INDEX($T$2:$T$61,RANK.EQ(INDIRECT("U"&B3),$U$2:$U$61))
里边的INDIRECT("U"&B3）由于B3=2，所以其实就是U2，这样写便于填充。
注意几点61，表示有2-61，共计60个，如果只有50个，那么应该是2-51。
$61替换成$51
K3=INDEX($T$2:$T$51,RANK.EQ(INDIRECT("U"&B3),$U$2:$U$51))
涉及到特殊情况的，比如某几个位置只有在某些人里边选，那么多加1个随机列
下面是xml的内容
把下面的文件，复制到记事本，然后另存为xml（选所有文件类型，然后命名成aa.xml）。
然后用excle打开这个aa.xml(把aa.xml拖入打开的其他excle)，后面可以另存为(.xlsx)都可以。
提示：多余的要删除，结尾是</Worksheet></Workbook>，可能csdn会加点内容
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"><DocumentProperties xmlns="urn:schemas-microsoft-com:office:office"><Author>Administrator</Author><LastAuthor>SKY)</LastAuthor><Created>2023-03-16T06:47:00Z</Created><LastSaved>2023-03-17T11:25:18Z</LastSaved></DocumentProperties><CustomDocumentProperties xmlns="urn:schemas-microsoft-com:office:office"><ICV dt:dt="string">E44102CD8E23429695556B519F976B8E</ICV><KSOProductBuildVer dt:dt="string">2052-11.1.0.12970</KSOProductBuildVer></CustomDocumentProperties><ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"><WindowWidth>19200</WindowWidth><WindowHeight>7130</WindowHeight><ProtectStructure>False</ProtectStructure><ProtectWindows>False</ProtectWindows></ExcelWorkbook><Styles><Style ss:ID="Default" ss:Name="Normal"><Alignment ss:Vertical="Center"/><Borders/><Font ss:FontName="宋体" x:CharSet="134" ss:Size="12"/><Interior/><NumberFormat/><Protection/></Style><Style ss:ID="s49"/><Style ss:ID="s50"><Alignment ss:Horizontal="Center" ss:Vertical="Center"/></Style><Style ss:ID="s51"><Alignment ss:Horizontal="Center" ss:Vertical="Center"/><Font ss:FontName="方正小标宋简体" x:CharSet="134" ss:Size="20"/></Style><Style ss:ID="s52"><Alignment ss:Horizontal="Center" ss:Vertical="Center"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/></Borders></Style><Style ss:ID="s53"><Alignment ss:Horizontal="Center" ss:Vertical="Center"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/></Borders></Style><Style ss:ID="s54"><Alignment ss:Horizontal="Center" ss:Vertical="Center"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/></Borders></Style><Style ss:ID="s55"><Alignment ss:Horizontal="Center" ss:Vertical="Center"/><Borders><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/></Borders></Style><Style ss:ID="s56"><Alignment ss:Horizontal="Center" ss:Vertical="Center"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders></Style><Style ss:ID="s57"><Alignment ss:Horizontal="Center" ss:Vertical="Center"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders></Style><Style ss:ID="s58"><Alignment ss:Horizontal="Center" ss:Vertical="Center"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders></Style><Style ss:ID="s59"><Alignment ss:Horizontal="Center" ss:Vertical="Center"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders></Style><Style ss:ID="s60"><Alignment ss:Horizontal="Center" ss:Vertical="Center"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders></Style><Style ss:ID="s61"><Alignment ss:Horizontal="Center" ss:Vertical="Center"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/></Borders></Style><Style ss:ID="s62"><Alignment ss:Horizontal="Center" ss:Vertical="Center"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/></Borders></Style><Style ss:ID="s63"><Alignment ss:Horizontal="Left" ss:Vertical="Center"/><Font ss:FontName="楷体" x:CharSet="134" ss:Size="16"/></Style><Style ss:ID="s64"><Alignment ss:Horizontal="Center" ss:Vertical="Center"/><Font ss:FontName="楷体" x:CharSet="134" ss:Size="16"/></Style><Style ss:ID="s65"><Alignment ss:Horizontal="Center" ss:Vertical="Center"/><Font ss:FontName="宋体" x:CharSet="134" ss:Size="12" ss:Bold="1"/></Style><Style ss:ID="s66"><Alignment ss:Horizontal="Center" ss:Vertical="Center"/><Interior ss:Color="#FFFF00" ss:Pattern="Solid"/></Style><Style ss:ID="s67"><Alignment ss:Horizontal="Center" ss:Vertical="Center"/><Font ss:FontName="方正小标宋简体" x:CharSet="134" ss:Size="20"/></Style><Style ss:ID="s68"><Alignment ss:Horizontal="Left" ss:Vertical="Center"/><Font ss:FontName="楷体" x:CharSet="134" ss:Size="16"/></Style><Style ss:ID="s69"><Alignment ss:Horizontal="Left" ss:Vertical="Center"/><Font ss:FontName="楷体" x:CharSet="134" ss:Size="16"/></Style><Style ss:ID="s70"><Alignment ss:Horizontal="Left" ss:Vertical="Center"/><Font ss:FontName="楷体" x:CharSet="134" ss:Size="16"/></Style><Style ss:ID="s71"><Alignment ss:Horizontal="Left" ss:Vertical="Center"/><Font ss:FontName="楷体" x:CharSet="134" ss:Size="16"/></Style><Style ss:ID="s72"><Alignment ss:Horizontal="Center" ss:Vertical="Center"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/></Borders></Style><Style ss:ID="s73"><Alignment ss:Horizontal="Center" ss:Vertical="Center"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/></Borders></Style><Style ss:ID="s74"><Alignment ss:Horizontal="Center" ss:Vertical="Center"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/></Borders></Style><Style ss:ID="s75"><Alignment ss:Horizontal="Center" ss:Vertical="Center"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/></Borders></Style><Style ss:ID="s76"><Alignment ss:Horizontal="Center" ss:Vertical="Center"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/></Borders></Style><Style ss:ID="s77"><Alignment ss:Horizontal="Center" ss:Vertical="Center"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/></Borders></Style><Style ss:ID="s78"><Alignment ss:Horizontal="Center" ss:Vertical="Center"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/></Borders></Style><Style ss:ID="s79"><Alignment ss:Horizontal="Center" ss:Vertical="Center"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/></Borders></Style><Style ss:ID="s80"><Alignment ss:Horizontal="Center" ss:Vertical="Center"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/></Borders></Style><Style ss:ID="s81"><Alignment ss:Horizontal="Center" ss:Vertical="Center"/><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/></Borders></Style></Styles><Worksheet ss:Name="打印"><Names><NamedRange ss:Name="Print_Area" ss:RefersTo="=打印!R1C9:R25C16"/></Names><Table ss:ExpandedColumnCount="22" ss:ExpandedRowCount="62" x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="15"><Column ss:Index="2" ss:StyleID="Default" ss:Width="76"/><Column ss:Index="9" ss:StyleID="Default" ss:AutoFitWidth="0" ss:Width="71.25"/><Column ss:StyleID="s50" ss:AutoFitWidth="0" ss:Width="66.25" ss:Span="6"/><Column ss:Index="17" ss:StyleID="s50" ss:AutoFitWidth="0" ss:Width="42.65"/><Column ss:StyleID="s50" ss:AutoFitWidth="0" ss:Width="77" ss:Span="2"/><Column ss:Index="21" ss:StyleID="Default" ss:AutoFitWidth="0" ss:Width="77"/><Column ss:StyleID="s50"/><Row ss:Height="47"><Cell ss:Index="9" ss:StyleID="s67" ss:MergeAcross="7"><Data ss:Type="String">xx考官抽签结果</Data></Cell><Cell ss:StyleID="s51"/><Cell ss:StyleID="s65"><Data ss:Type="String">主考官</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">辅助序列</Data></Cell><Cell ss:StyleID="s65"><Data ss:Type="String">其余考官</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">辅助序列</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">序号</Data></Cell></Row><Row ss:Height="39"><Cell ss:Index="2" ss:Formula="=INDIRECT("U"&R[1]C)"><Data ss:Type="Number">0.243522613316199</Data></Cell><Cell ss:Index="9" ss:StyleID="s72" ss:MergeDown="1"><Data ss:Type="String">第一试场</Data></Cell><Cell ss:StyleID="s53"><Data ss:Type="String">主考</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官1</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官2</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官3</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官4</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官5</Data></Cell><Cell ss:StyleID="s55"><Data ss:Type="String">考官6</Data></Cell><Cell ss:Index="18" ss:StyleID="s50"><Data ss:Type="String">主考官01</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=RAND()"><Data ss:Type="Number">0.793813072067244</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">姓名01</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.243522613316199</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">1</Data></Cell></Row><Row ss:Height="39"><Cell><Data ss:Type="String">R2</Data></Cell><Cell><Data ss:Type="Number">2</Data></Cell><Cell><Data ss:Type="Number">3</Data></Cell><Cell><Data ss:Type="Number">4</Data></Cell><Cell><Data ss:Type="Number">5</Data></Cell><Cell><Data ss:Type="Number">6</Data></Cell><Cell><Data ss:Type="Number">7</Data></Cell><Cell/><Cell ss:Index="10" ss:StyleID="s57" ss:Formula="=INDEX(R2C18:R11C18,RANK.EQ(R[-1]C[9],R2C19:R11C19))"><Data ss:Type="String">主考官06</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名47</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名26</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名35</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名59</Data></Cell><Cell ss:StyleID="s59" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名46</Data></Cell><Cell ss:StyleID="s60" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名50</Data></Cell><Cell ss:Index="18" ss:StyleID="s50"><Data ss:Type="String">主考官02</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=RAND()"><Data ss:Type="Number">0.993751944555658</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">姓名02</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.55794325940984</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">2</Data></Cell></Row><Row ss:Height="39"><Cell ss:Index="9" ss:StyleID="s73" ss:MergeDown="1"><Data ss:Type="String">第二试场</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">主考</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官1</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官2</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官3</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官4</Data></Cell><Cell ss:StyleID="s61"><Data ss:Type="String">考官5</Data></Cell><Cell ss:StyleID="s62"><Data ss:Type="String">考官6</Data></Cell><Cell ss:Index="18" ss:StyleID="s50"><Data ss:Type="String">主考官03</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=RAND()"><Data ss:Type="Number">0.596892701504341</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">姓名03</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.427706396780005</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">3</Data></Cell></Row><Row ss:Height="39"><Cell><Data ss:Type="String">R3</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">8</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">9</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">10</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">11</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">12</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">13</Data></Cell><Cell ss:Index="10" ss:StyleID="s58" ss:Formula="=INDEX(R2C18:R11C18,RANK.EQ(R[-2]C[9],R2C19:R11C19))"><Data ss:Type="String">主考官01</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名37</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名57</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名40</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名14</Data></Cell><Cell ss:StyleID="s59" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名09</Data></Cell><Cell ss:StyleID="s60" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名15</Data></Cell><Cell ss:Index="18" ss:StyleID="s50"><Data ss:Type="String">主考官04</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=RAND()"><Data ss:Type="Number">0.114846063459163</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">姓名04</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.0164325980058635</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">4</Data></Cell></Row><Row ss:Height="39"><Cell ss:Index="9" ss:StyleID="s74" ss:MergeDown="1"><Data ss:Type="String">第三试场</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">主考</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官1</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官2</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官3</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官4</Data></Cell><Cell ss:StyleID="s61"><Data ss:Type="String">考官5</Data></Cell><Cell ss:StyleID="s62"><Data ss:Type="String">考官6</Data></Cell><Cell ss:Index="18" ss:StyleID="s50"><Data ss:Type="String">主考官05</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=RAND()"><Data ss:Type="Number">0.852434118243503</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">姓名05</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.249397282576015</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">5</Data></Cell></Row><Row ss:Height="39"><Cell><Data ss:Type="String">R4</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">14</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">15</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">16</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">17</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">18</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">19</Data></Cell><Cell ss:Index="10" ss:StyleID="s58" ss:Formula="=INDEX(R2C18:R11C18,RANK.EQ(R[-3]C[9],R2C19:R11C19))"><Data ss:Type="String">主考官08</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名11</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名20</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名21</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名34</Data></Cell><Cell ss:StyleID="s59" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名25</Data></Cell><Cell ss:StyleID="s60" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名52</Data></Cell><Cell ss:Index="18" ss:StyleID="s50"><Data ss:Type="String">主考官06</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=RAND()"><Data ss:Type="Number">0.914996854831522</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">姓名06</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.213835327844837</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">6</Data></Cell></Row><Row ss:Height="39"><Cell ss:Index="9" ss:StyleID="s75" ss:MergeDown="1"><Data ss:Type="String">第四试场</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">主考</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官1</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官2</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官3</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官4</Data></Cell><Cell ss:StyleID="s61"><Data ss:Type="String">考官5</Data></Cell><Cell ss:StyleID="s62"><Data ss:Type="String">考官6</Data></Cell><Cell ss:Index="18" ss:StyleID="s50"><Data ss:Type="String">主考官07</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=RAND()"><Data ss:Type="Number">0.646174043030835</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">姓名07</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.39938777136711</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">7</Data></Cell></Row><Row ss:Height="39"><Cell><Data ss:Type="String">R5</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">20</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">21</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">22</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">23</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">24</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">25</Data></Cell><Cell ss:Index="10" ss:StyleID="s58" ss:Formula="=INDEX(R2C18:R11C18,RANK.EQ(R[-4]C[9],R2C19:R11C19))"><Data ss:Type="String">主考官10</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名41</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名51</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名03</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名16</Data></Cell><Cell ss:StyleID="s59" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名06</Data></Cell><Cell ss:StyleID="s60" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名55</Data></Cell><Cell ss:Index="18" ss:StyleID="s50"><Data ss:Type="String">主考官08</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=RAND()"><Data ss:Type="Number">0.807545452726987</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">姓名08</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.064974856985677</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">8</Data></Cell></Row><Row ss:Height="39"><Cell ss:Index="9" ss:StyleID="s76" ss:MergeDown="1"><Data ss:Type="String">第五试场</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">主考</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官1</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官2</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官3</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官4</Data></Cell><Cell ss:StyleID="s61"><Data ss:Type="String">考官5</Data></Cell><Cell ss:StyleID="s62"><Data ss:Type="String">考官6</Data></Cell><Cell ss:Index="18" ss:StyleID="s50"><Data ss:Type="String">主考官09</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=RAND()"><Data ss:Type="Number">0.972151121679225</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">姓名09</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.367882290645566</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">9</Data></Cell></Row><Row ss:Height="39"><Cell><Data ss:Type="String">R6</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">26</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">27</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">28</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">29</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">30</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">31</Data></Cell><Cell ss:Index="10" ss:StyleID="s58" ss:Formula="=INDEX(R2C18:R11C18,RANK.EQ(R[-5]C[9],R2C19:R11C19))"><Data ss:Type="String">主考官04</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名08</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名44</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名12</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名17</Data></Cell><Cell ss:StyleID="s59" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名42</Data></Cell><Cell ss:StyleID="s60" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名22</Data></Cell><Cell ss:Index="18" ss:StyleID="s50"><Data ss:Type="String">主考官10</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=RAND()"><Data ss:Type="Number">0.549036408905885</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">姓名10</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.75680593216997</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">10</Data></Cell></Row><Row ss:Height="39"><Cell ss:Index="9" ss:StyleID="s77" ss:MergeDown="1"><Data ss:Type="String">第六试场</Data></Cell><Cell ss:StyleID="s53"><Data ss:Type="String">主考</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官1</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官2</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官3</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官4</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官5</Data></Cell><Cell ss:StyleID="s55"><Data ss:Type="String">考官6</Data></Cell><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名11</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.798569096536238</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">11</Data></Cell></Row><Row ss:Height="39"><Cell><Data ss:Type="String">R7</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">32</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">33</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">34</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">35</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">36</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">37</Data></Cell><Cell ss:Index="10" ss:StyleID="s57" ss:Formula="=INDEX(R2C18:R11C18,RANK.EQ(R[-6]C[9],R2C19:R11C19))"><Data ss:Type="String">主考官03</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名18</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名39</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名45</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名23</Data></Cell><Cell ss:StyleID="s59" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名36</Data></Cell><Cell ss:StyleID="s60" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名33</Data></Cell><Cell ss:StyleID="s66"/><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名12</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.750957765560068</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">12</Data></Cell></Row><Row ss:Height="39"><Cell ss:Index="9" ss:StyleID="s78" ss:MergeDown="1"><Data ss:Type="String">第七试场</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">主考</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官1</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官2</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官3</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官4</Data></Cell><Cell ss:StyleID="s61"><Data ss:Type="String">考官5</Data></Cell><Cell ss:StyleID="s62"><Data ss:Type="String">考官6</Data></Cell><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名13</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.795261803541002</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">13</Data></Cell></Row><Row ss:Height="39"><Cell><Data ss:Type="String">R8</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">38</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">39</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">40</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">41</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">42</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">43</Data></Cell><Cell ss:Index="10" ss:StyleID="s58" ss:Formula="=INDEX(R2C18:R11C18,RANK.EQ(R[-7]C[9],R2C19:R11C19))"><Data ss:Type="String">主考官07</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名19</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名05</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名60</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名49</Data></Cell><Cell ss:StyleID="s59" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名32</Data></Cell><Cell ss:StyleID="s60" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名27</Data></Cell><Cell ss:StyleID="s66"/><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名14</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.668863211018135</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">14</Data></Cell></Row><Row ss:Height="39"><Cell ss:Index="9" ss:StyleID="s79" ss:MergeDown="1"><Data ss:Type="String">第八试场</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">主考</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官1</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官2</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官3</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官4</Data></Cell><Cell ss:StyleID="s61"><Data ss:Type="String">考官5</Data></Cell><Cell ss:StyleID="s62"><Data ss:Type="String">考官6</Data></Cell><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名15</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.66434158273582</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">15</Data></Cell></Row><Row ss:Height="39"><Cell><Data ss:Type="String">R9</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">44</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">45</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">46</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">47</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">48</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">49</Data></Cell><Cell ss:Index="10" ss:StyleID="s58" ss:Formula="=INDEX(R2C18:R11C18,RANK.EQ(R[-8]C[9],R2C19:R11C19))"><Data ss:Type="String">主考官05</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名31</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名07</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名02</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名01</Data></Cell><Cell ss:StyleID="s59" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名54</Data></Cell><Cell ss:StyleID="s60" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名28</Data></Cell><Cell ss:StyleID="s66"/><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名16</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.468296584311161</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">16</Data></Cell></Row><Row ss:Height="39"><Cell ss:Index="9" ss:StyleID="s80" ss:MergeDown="1"><Data ss:Type="String">第九试场</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">主考</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官1</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官2</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官3</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官4</Data></Cell><Cell ss:StyleID="s61"><Data ss:Type="String">考官5</Data></Cell><Cell ss:StyleID="s62"><Data ss:Type="String">考官6</Data></Cell><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名17</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.5662588741732</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">17</Data></Cell></Row><Row ss:Height="39"><Cell><Data ss:Type="String">R10</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">50</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">51</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">52</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">53</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">54</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">55</Data></Cell><Cell ss:Index="10" ss:StyleID="s58" ss:Formula="=INDEX(R2C18:R11C18,RANK.EQ(R[-9]C[9],R2C19:R11C19))"><Data ss:Type="String">主考官02</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名24</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名10</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名58</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名43</Data></Cell><Cell ss:StyleID="s59" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名56</Data></Cell><Cell ss:StyleID="s60" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名29</Data></Cell><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名18</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.15375940770111</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">18</Data></Cell></Row><Row ss:Height="39"><Cell ss:Index="9" ss:StyleID="s81" ss:MergeDown="1"><Data ss:Type="String">第十试场</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">主考</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官1</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官2</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官3</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">考官4</Data></Cell><Cell ss:StyleID="s61"><Data ss:Type="String">考官5</Data></Cell><Cell ss:StyleID="s62"><Data ss:Type="String">考官6</Data></Cell><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名19</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.364889806723631</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">19</Data></Cell></Row><Row ss:Height="39"><Cell><Data ss:Type="String">R11</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">56</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">57</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">58</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">59</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">60</Data></Cell><Cell ss:Formula="=R[-2]C+6"><Data ss:Type="Number">61</Data></Cell><Cell ss:Index="10" ss:StyleID="s58" ss:Formula="=INDEX(R2C18:R11C18,RANK.EQ(R[-10]C[9],R2C19:R11C19))"><Data ss:Type="String">主考官09</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名38</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名13</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名48</Data></Cell><Cell ss:StyleID="s58" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名53</Data></Cell><Cell ss:StyleID="s59" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名30</Data></Cell><Cell ss:StyleID="s60" ss:Formula="=INDEX(R2C20:R61C20,RANK.EQ(INDIRECT("U"&RC[-9]),R2C21:R61C21))"><Data ss:Type="String">姓名04</Data></Cell><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名20</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.210764542859289</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">20</Data></Cell></Row><Row ss:Height="21"><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名21</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.97667330457854</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">21</Data></Cell></Row><Row ss:Height="25"><Cell ss:Index="10" ss:StyleID="s68" ss:MergeAcross="2"/><Cell ss:StyleID="s69" ss:MergeAcross="3"/><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名22</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.742019265811708</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">22</Data></Cell></Row><Row ss:Height="16"><Cell ss:Index="10" ss:StyleID="s64"/><Cell ss:StyleID="s64"/><Cell ss:StyleID="s64"/><Cell ss:StyleID="s64"/><Cell ss:StyleID="s64"/><Cell ss:StyleID="s64"/><Cell ss:StyleID="s64"/><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名23</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.901396228669609</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">23</Data></Cell></Row><Row ss:Height="25"><Cell ss:Index="10" ss:StyleID="s70" ss:MergeAcross="2"/><Cell ss:StyleID="s71" ss:MergeAcross="3"/><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名24</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.115974188031228</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">24</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名25</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.80173358894701</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">25</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名26</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.275173934844265</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">26</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名27</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.779510606208908</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">27</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名28</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.722157852063833</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">28</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名29</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.352336029874591</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">29</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名30</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.63313980979402</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">30</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名31</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.719135339650434</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">31</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名32</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.379811231993855</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">32</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名33</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.262064711104513</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">33</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名34</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.611796738586608</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">34</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名35</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.421026817823287</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">35</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名36</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.475147546352831</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">36</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名37</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.681250500770455</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">37</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名38</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.92374521851061</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">38</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名39</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.00445709640520642</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">39</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名40</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.222863019842783</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">40</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名41</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.476673332141923</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">41</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名42</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.554811685397284</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">42</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名43</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.483946521176208</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">43</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名44</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.895288938045523</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">44</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名45</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.981571958919131</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">45</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名46</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.98666030396578</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">46</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名47</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.138120558516306</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">47</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名48</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.508710236295579</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">48</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名49</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.595190154853205</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">49</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名50</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.795675189740266</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">50</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名51</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.0624169134033006</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">51</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名52</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.316164718162831</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">52</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名53</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.110478221854783</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">53</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名54</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.502543586303886</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">54</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名55</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.394362621495729</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">55</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名56</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.757741292627617</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">56</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名57</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.233304523391074</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">57</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名58</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.139103267957791</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">58</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名59</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.497373043189973</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">59</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名60</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.941080667656567</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">60</Data></Cell></Row><Row><Cell ss:Index="20" ss:StyleID="s50"><Data ss:Type="String">姓名61</Data></Cell><Cell ss:Formula="=RAND()"><Data ss:Type="Number">0.714481753839195</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">61</Data></Cell></Row></Table><WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"><PageSetup><Layout x:CenterHorizontal="1"/><Header x:Margin="0.511805555555556"/><Footer x:Margin="0.511805555555556"/><PageMargins x:Left="0.786805555555556" x:Right="0.786805555555556" x:Top="0.786805555555556" x:Bottom="0.786805555555556"/></PageSetup><FitToPage/><Print><ValidPrinterInfo/><Scale>81</Scale><PaperSizeIndex>9</PaperSizeIndex><HorizontalResolution>600</HorizontalResolution></Print><Zoom>115</Zoom><Selected/><TopRowVisible>0</TopRowVisible><LeftColumnVisible>0</LeftColumnVisible><ShowPageBreakZoom/><PageBreakZoom>90</PageBreakZoom><Panes><Pane><Number>3</Number><ActiveRow>1</ActiveRow><ActiveCol>6</ActiveCol><RangeSelection>R2C7</RangeSelection></Pane></Panes><ProtectObjects>False</ProtectObjects><ProtectScenarios>False</ProtectScenarios></WorksheetOptions><PageBreaks xmlns="urn:schemas-microsoft-com:office:excel"><ColBreaks><ColBreak><Column>16</Column></ColBreak></ColBreaks><RowBreaks/></PageBreaks></Worksheet></Workbook>
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
