public override void WriteOpenXml(OpenXmlWriter writer) { X14.ConditionalFormatting cf = new X14.ConditionalFormatting(); cf.AddNamespaceDeclaration("xm", "http://schemas.microsoft.com/office/excel/2006/main"); ReferenceSequence referenceSequence = new ReferenceSequence(); referenceSequence.Text = $"{SpreadsheetHelper.ExcelColumnFromNumber(RangeStart.ColumnIndex)}{RangeStart.RowIndex}:{SpreadsheetHelper.ExcelColumnFromNumber(RangeEnd.ColumnIndex)}{RangeEnd.RowIndex}"; X14.ConditionalFormattingRule conditionalFormattingRule = new X14.ConditionalFormattingRule() { Type = ConditionalFormatValues.IconSet, Priority = 1, Id = Guid.NewGuid().ToString("B").ToUpper() }; X14.IconSet iconSet1 = new X14.IconSet() { IconSetTypes = new EnumValue <IconSetTypeValues>(IconSetTypeValues.FourTrafficLights), ShowValue = false, Custom = true }; //ConditionalFormattingIcon var conditionalFormattingIcon1 = new X14.ConditionalFormattingIcon() { IconSet = X14.IconSetTypeValues.NoIcons, IconId = (UInt32Value)0U }; var conditionalFormattingIcon2 = new X14.ConditionalFormattingIcon() { IconSet = X14.IconSetTypeValues.ThreeSymbols2, IconId = (UInt32Value)2U }; var conditionalFormattingIcon3 = new X14.ConditionalFormattingIcon() { IconSet = X14.IconSetTypeValues.ThreeSymbols, IconId = (UInt32Value)1U }; var conditionalFormattingIcon4 = new X14.ConditionalFormattingIcon() { IconSet = X14.IconSetTypeValues.ThreeSymbols, IconId = (UInt32Value)0U }; X14.ConditionalFormattingValueObject conditionalFormattingValueObject1 = new X14.ConditionalFormattingValueObject() { Type = X14.ConditionalFormattingValueObjectTypeValues.Numeric }; Formula formula1 = new Formula(); formula1.Text = "0"; conditionalFormattingValueObject1.Append(formula1); X14.ConditionalFormattingValueObject conditionalFormattingValueObject2 = new X14.ConditionalFormattingValueObject() { Type = X14.ConditionalFormattingValueObjectTypeValues.Numeric }; Formula formula2 = new Formula(); formula2.Text = "1"; conditionalFormattingValueObject2.Append(formula2); X14.ConditionalFormattingValueObject conditionalFormattingValueObject3 = new X14.ConditionalFormattingValueObject() { Type = X14.ConditionalFormattingValueObjectTypeValues.Numeric }; Formula formula3 = new Formula(); formula3.Text = "2"; conditionalFormattingValueObject3.Append(formula3); X14.ConditionalFormattingValueObject conditionalFormattingValueObject4 = new X14.ConditionalFormattingValueObject() { Type = X14.ConditionalFormattingValueObjectTypeValues.Numeric }; Formula formula4 = new Formula(); formula4.Text = "3"; conditionalFormattingValueObject4.Append(formula4); iconSet1.Append( conditionalFormattingValueObject1 , conditionalFormattingValueObject2 , conditionalFormattingValueObject3 , conditionalFormattingValueObject4 , conditionalFormattingIcon1 , conditionalFormattingIcon2 , conditionalFormattingIcon3 , conditionalFormattingIcon4 ); conditionalFormattingRule.Append(iconSet1); cf.Append(conditionalFormattingRule); cf.Append(referenceSequence); writer.WriteElement(cf); }
// Generates content of worksheetPart1. private void GenerateWorksheetPart1Content(WorksheetPart worksheetPart1) { Worksheet worksheet1 = new Worksheet(); worksheet1.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); SheetProperties sheetProperties1 = new SheetProperties(); PageSetupProperties pageSetupProperties1 = new PageSetupProperties() { FitToPage = true }; sheetProperties1.Append(pageSetupProperties1); SheetDimension sheetDimension1 = new SheetDimension() { Reference = "B3:AR42" }; SheetViews sheetViews1 = new SheetViews(); SheetView sheetView1 = new SheetView() { ShowZeros = false, TabSelected = true, TopLeftCell = "B1", ZoomScale = (UInt32Value)85U, WorkbookViewId = (UInt32Value)0U }; Pane pane1 = new Pane() { HorizontalSplit = 5D, TopLeftCell = "G1", ActivePane = PaneValues.TopRight, State = PaneStateValues.FrozenSplit }; Selection selection1 = new Selection() { ActiveCell = "B13", SequenceOfReferences = new ListValue<StringValue>() { InnerText = "B13 B13" } }; Selection selection2 = new Selection() { Pane = PaneValues.TopRight, ActiveCell = "AM21", SequenceOfReferences = new ListValue<StringValue>() { InnerText = "AM21:AM26" } }; sheetView1.Append(pane1); sheetView1.Append(selection1); sheetView1.Append(selection2); sheetViews1.Append(sheetView1); SheetFormatProperties sheetFormatProperties1 = new SheetFormatProperties() { BaseColumnWidth = (UInt32Value)10U, DefaultColumnWidth = 11.42578125D, DefaultRowHeight = 12.75D }; Columns columns1 = new Columns(); Column column1 = new Column() { Min = (UInt32Value)1U, Max = (UInt32Value)1U, Width = 6.140625D, Style = (UInt32Value)4U, CustomWidth = true }; Column column2 = new Column() { Min = (UInt32Value)2U, Max = (UInt32Value)2U, Width = 39.7109375D, Style = (UInt32Value)4U, BestFit = true, CustomWidth = true }; Column column3 = new Column() { Min = (UInt32Value)3U, Max = (UInt32Value)3U, Width = 30D, Style = (UInt32Value)4U, CustomWidth = true }; Column column4 = new Column() { Min = (UInt32Value)4U, Max = (UInt32Value)4U, Width = 17.85546875D, Style = (UInt32Value)4U, BestFit = true, CustomWidth = true }; Column column5 = new Column() { Min = (UInt32Value)5U, Max = (UInt32Value)5U, Width = 12.42578125D, Style = (UInt32Value)4U, CustomWidth = true }; Column column6 = new Column() { Min = (UInt32Value)6U, Max = (UInt32Value)6U, Width = 14.5703125D, Style = (UInt32Value)4U, BestFit = true, CustomWidth = true }; Column column7 = new Column() { Min = (UInt32Value)7U, Max = (UInt32Value)20U, Width = 3.85546875D, Style = (UInt32Value)44U, CustomWidth = true }; Column column8 = new Column() { Min = (UInt32Value)21U, Max = (UInt32Value)21U, Width = 4.140625D, Style = (UInt32Value)44U, CustomWidth = true }; Column column9 = new Column() { Min = (UInt32Value)22U, Max = (UInt32Value)22U, Width = 3.85546875D, Style = (UInt32Value)44U, CustomWidth = true }; Column column10 = new Column() { Min = (UInt32Value)23U, Max = (UInt32Value)23U, Width = 3.140625D, Style = (UInt32Value)44U, BestFit = true, CustomWidth = true }; Column column11 = new Column() { Min = (UInt32Value)24U, Max = (UInt32Value)33U, Width = 3.85546875D, Style = (UInt32Value)44U, CustomWidth = true }; Column column12 = new Column() { Min = (UInt32Value)34U, Max = (UInt32Value)37U, Width = 4D, Style = (UInt32Value)44U, CustomWidth = true }; Column column13 = new Column() { Min = (UInt32Value)38U, Max = (UInt32Value)38U, Width = 10.42578125D, Style = (UInt32Value)44U, BestFit = true, CustomWidth = true }; Column column14 = new Column() { Min = (UInt32Value)39U, Max = (UInt32Value)39U, Width = 14D, Style = (UInt32Value)44U, BestFit = true, CustomWidth = true }; Column column15 = new Column() { Min = (UInt32Value)40U, Max = (UInt32Value)40U, Width = 13.7109375D, Style = (UInt32Value)44U, BestFit = true, CustomWidth = true }; Column column16 = new Column() { Min = (UInt32Value)41U, Max = (UInt32Value)41U, Width = 10D, Style = (UInt32Value)4U, CustomWidth = true }; Column column17 = new Column() { Min = (UInt32Value)42U, Max = (UInt32Value)44U, Width = 13.7109375D, Style = (UInt32Value)4U, CustomWidth = true }; Column column18 = new Column() { Min = (UInt32Value)45U, Max = (UInt32Value)45U, Width = 11.42578125D, Style = (UInt32Value)4U, CustomWidth = true }; Column column19 = new Column() { Min = (UInt32Value)46U, Max = (UInt32Value)16384U, Width = 11.42578125D, Style = (UInt32Value)4U }; columns1.Append(column1); columns1.Append(column2); columns1.Append(column3); columns1.Append(column4); columns1.Append(column5); columns1.Append(column6); columns1.Append(column7); columns1.Append(column8); columns1.Append(column9); columns1.Append(column10); columns1.Append(column11); columns1.Append(column12); columns1.Append(column13); columns1.Append(column14); columns1.Append(column15); columns1.Append(column16); columns1.Append(column17); columns1.Append(column18); columns1.Append(column19); SheetData sheetData1 = new SheetData(); Row row1 = new Row() { RowIndex = (UInt32Value)3U, Spans = new ListValue<StringValue>() { InnerText = "2:44" } }; Cell cell1 = new Cell() { CellReference = "B3", StyleIndex = (UInt32Value)5U }; Cell cell2 = new Cell() { CellReference = "C3", StyleIndex = (UInt32Value)5U }; Cell cell3 = new Cell() { CellReference = "D3", StyleIndex = (UInt32Value)5U }; Cell cell4 = new Cell() { CellReference = "E3", StyleIndex = (UInt32Value)5U }; Cell cell5 = new Cell() { CellReference = "F3", StyleIndex = (UInt32Value)6U }; Cell cell6 = new Cell() { CellReference = "AO3", StyleIndex = (UInt32Value)6U }; Cell cell7 = new Cell() { CellReference = "AP3", StyleIndex = (UInt32Value)6U }; Cell cell8 = new Cell() { CellReference = "AQ3", StyleIndex = (UInt32Value)6U }; Cell cell9 = new Cell() { CellReference = "AR3", StyleIndex = (UInt32Value)6U }; row1.Append(cell1); row1.Append(cell2); row1.Append(cell3); row1.Append(cell4); row1.Append(cell5); row1.Append(cell6); row1.Append(cell7); row1.Append(cell8); row1.Append(cell9); Row row2 = new Row() { RowIndex = (UInt32Value)5U, Spans = new ListValue<StringValue>() { InnerText = "2:44" } }; Cell cell10 = new Cell() { CellReference = "B5", StyleIndex = (UInt32Value)7U }; Cell cell11 = new Cell() { CellReference = "C5", StyleIndex = (UInt32Value)7U }; Cell cell12 = new Cell() { CellReference = "D5", StyleIndex = (UInt32Value)7U }; Cell cell13 = new Cell() { CellReference = "E5", StyleIndex = (UInt32Value)8U, DataType = CellValues.SharedString }; CellValue cellValue1 = new CellValue(); cellValue1.Text = "0"; cell13.Append(cellValue1); Cell cell14 = new Cell() { CellReference = "F5", StyleIndex = (UInt32Value)9U, DataType = CellValues.SharedString }; CellValue cellValue2 = new CellValue(); cellValue2.Text = "30"; cell14.Append(cellValue2); row2.Append(cell10); row2.Append(cell11); row2.Append(cell12); row2.Append(cell13); row2.Append(cell14); Row row3 = new Row() { RowIndex = (UInt32Value)6U, Spans = new ListValue<StringValue>() { InnerText = "2:44" } }; Cell cell15 = new Cell() { CellReference = "B6", StyleIndex = (UInt32Value)7U }; Cell cell16 = new Cell() { CellReference = "C6", StyleIndex = (UInt32Value)7U }; Cell cell17 = new Cell() { CellReference = "D6", StyleIndex = (UInt32Value)7U }; Cell cell18 = new Cell() { CellReference = "E6", StyleIndex = (UInt32Value)8U, DataType = CellValues.SharedString }; CellValue cellValue3 = new CellValue(); cellValue3.Text = "1"; cell18.Append(cellValue3); Cell cell19 = new Cell() { CellReference = "F6", StyleIndex = (UInt32Value)10U }; row3.Append(cell15); row3.Append(cell16); row3.Append(cell17); row3.Append(cell18); row3.Append(cell19); Row row4 = new Row() { RowIndex = (UInt32Value)7U, Spans = new ListValue<StringValue>() { InnerText = "2:44" } }; Cell cell20 = new Cell() { CellReference = "B7", StyleIndex = (UInt32Value)4U, DataType = CellValues.SharedString }; CellValue cellValue4 = new CellValue(); cellValue4.Text = "2"; cell20.Append(cellValue4); Cell cell21 = new Cell() { CellReference = "E7", StyleIndex = (UInt32Value)8U, DataType = CellValues.SharedString }; CellValue cellValue5 = new CellValue(); cellValue5.Text = "3"; cell21.Append(cellValue5); Cell cell22 = new Cell() { CellReference = "F7", StyleIndex = (UInt32Value)11U }; row4.Append(cell20); row4.Append(cell21); row4.Append(cell22); Row row5 = new Row() { RowIndex = (UInt32Value)8U, Spans = new ListValue<StringValue>() { InnerText = "2:44" } }; Cell cell23 = new Cell() { CellReference = "B8", StyleIndex = (UInt32Value)4U, DataType = CellValues.SharedString }; CellValue cellValue6 = new CellValue(); cellValue6.Text = "4"; cell23.Append(cellValue6); Cell cell24 = new Cell() { CellReference = "F8", StyleIndex = (UInt32Value)7U }; row5.Append(cell23); row5.Append(cell24); Row row6 = new Row() { RowIndex = (UInt32Value)9U, Spans = new ListValue<StringValue>() { InnerText = "2:44" } }; Cell cell25 = new Cell() { CellReference = "B9", StyleIndex = (UInt32Value)7U }; Cell cell26 = new Cell() { CellReference = "C9", StyleIndex = (UInt32Value)7U }; Cell cell27 = new Cell() { CellReference = "D9", StyleIndex = (UInt32Value)7U }; Cell cell28 = new Cell() { CellReference = "E9", StyleIndex = (UInt32Value)7U }; Cell cell29 = new Cell() { CellReference = "F9", StyleIndex = (UInt32Value)7U }; row6.Append(cell25); row6.Append(cell26); row6.Append(cell27); row6.Append(cell28); row6.Append(cell29); Row row7 = new Row() { RowIndex = (UInt32Value)10U, Spans = new ListValue<StringValue>() { InnerText = "2:44" } }; Cell cell30 = new Cell() { CellReference = "B10", StyleIndex = (UInt32Value)8U, DataType = CellValues.SharedString }; CellValue cellValue7 = new CellValue(); cellValue7.Text = "5"; cell30.Append(cellValue7); Cell cell31 = new Cell() { CellReference = "C10", StyleIndex = (UInt32Value)9U }; Cell cell32 = new Cell() { CellReference = "D10", StyleIndex = (UInt32Value)9U }; Cell cell33 = new Cell() { CellReference = "E10", StyleIndex = (UInt32Value)9U }; row7.Append(cell30); row7.Append(cell31); row7.Append(cell32); row7.Append(cell33); Row row8 = new Row() { RowIndex = (UInt32Value)11U, Spans = new ListValue<StringValue>() { InnerText = "2:44" } }; Cell cell34 = new Cell() { CellReference = "B11", StyleIndex = (UInt32Value)8U, DataType = CellValues.SharedString }; CellValue cellValue8 = new CellValue(); cellValue8.Text = "6"; cell34.Append(cellValue8); Cell cell35 = new Cell() { CellReference = "C11", StyleIndex = (UInt32Value)9U }; Cell cell36 = new Cell() { CellReference = "D11", StyleIndex = (UInt32Value)9U }; Cell cell37 = new Cell() { CellReference = "E11", StyleIndex = (UInt32Value)9U }; row8.Append(cell34); row8.Append(cell35); row8.Append(cell36); row8.Append(cell37); Row row9 = new Row() { RowIndex = (UInt32Value)12U, Spans = new ListValue<StringValue>() { InnerText = "2:44" } }; Cell cell38 = new Cell() { CellReference = "B12", StyleIndex = (UInt32Value)8U, DataType = CellValues.SharedString }; CellValue cellValue9 = new CellValue(); cellValue9.Text = "7"; cell38.Append(cellValue9); Cell cell39 = new Cell() { CellReference = "C12", StyleIndex = (UInt32Value)9U }; Cell cell40 = new Cell() { CellReference = "D12", StyleIndex = (UInt32Value)9U }; Cell cell41 = new Cell() { CellReference = "E12", StyleIndex = (UInt32Value)9U }; Cell cell42 = new Cell() { CellReference = "N12", StyleIndex = (UInt32Value)12U }; row9.Append(cell38); row9.Append(cell39); row9.Append(cell40); row9.Append(cell41); row9.Append(cell42); Row row10 = new Row() { RowIndex = (UInt32Value)13U, Spans = new ListValue<StringValue>() { InnerText = "2:44" } }; Cell cell43 = new Cell() { CellReference = "B13", StyleIndex = (UInt32Value)8U, DataType = CellValues.SharedString }; CellValue cellValue10 = new CellValue(); cellValue10.Text = "8"; cell43.Append(cellValue10); Cell cell44 = new Cell() { CellReference = "C13", StyleIndex = (UInt32Value)13U }; Cell cell45 = new Cell() { CellReference = "D13", StyleIndex = (UInt32Value)13U }; Cell cell46 = new Cell() { CellReference = "E13", StyleIndex = (UInt32Value)9U }; Cell cell47 = new Cell() { CellReference = "N13", StyleIndex = (UInt32Value)12U }; row10.Append(cell43); row10.Append(cell44); row10.Append(cell45); row10.Append(cell46); row10.Append(cell47); Row row11 = new Row() { RowIndex = (UInt32Value)14U, Spans = new ListValue<StringValue>() { InnerText = "2:44" } }; Cell cell48 = new Cell() { CellReference = "B14", StyleIndex = (UInt32Value)8U, DataType = CellValues.SharedString }; CellValue cellValue11 = new CellValue(); cellValue11.Text = "9"; cell48.Append(cellValue11); Cell cell49 = new Cell() { CellReference = "C14", StyleIndex = (UInt32Value)13U }; Cell cell50 = new Cell() { CellReference = "D14", StyleIndex = (UInt32Value)13U }; Cell cell51 = new Cell() { CellReference = "E14", StyleIndex = (UInt32Value)9U }; Cell cell52 = new Cell() { CellReference = "F14", StyleIndex = (UInt32Value)9U }; Cell cell53 = new Cell() { CellReference = "G14", StyleIndex = (UInt32Value)12U }; Cell cell54 = new Cell() { CellReference = "H14", StyleIndex = (UInt32Value)12U }; Cell cell55 = new Cell() { CellReference = "I14", StyleIndex = (UInt32Value)12U }; Cell cell56 = new Cell() { CellReference = "J14", StyleIndex = (UInt32Value)12U }; Cell cell57 = new Cell() { CellReference = "K14", StyleIndex = (UInt32Value)12U }; Cell cell58 = new Cell() { CellReference = "L14", StyleIndex = (UInt32Value)12U }; Cell cell59 = new Cell() { CellReference = "M14", StyleIndex = (UInt32Value)12U }; Cell cell60 = new Cell() { CellReference = "N14", StyleIndex = (UInt32Value)12U }; Cell cell61 = new Cell() { CellReference = "O14", StyleIndex = (UInt32Value)12U }; Cell cell62 = new Cell() { CellReference = "P14", StyleIndex = (UInt32Value)12U }; Cell cell63 = new Cell() { CellReference = "Q14", StyleIndex = (UInt32Value)12U }; Cell cell64 = new Cell() { CellReference = "R14", StyleIndex = (UInt32Value)12U }; Cell cell65 = new Cell() { CellReference = "S14", StyleIndex = (UInt32Value)12U }; Cell cell66 = new Cell() { CellReference = "T14", StyleIndex = (UInt32Value)12U }; row11.Append(cell48); row11.Append(cell49); row11.Append(cell50); row11.Append(cell51); row11.Append(cell52); row11.Append(cell53); row11.Append(cell54); row11.Append(cell55); row11.Append(cell56); row11.Append(cell57); row11.Append(cell58); row11.Append(cell59); row11.Append(cell60); row11.Append(cell61); row11.Append(cell62); row11.Append(cell63); row11.Append(cell64); row11.Append(cell65); row11.Append(cell66); Row row12 = new Row() { RowIndex = (UInt32Value)15U, Spans = new ListValue<StringValue>() { InnerText = "2:44" } }; Cell cell67 = new Cell() { CellReference = "B15", StyleIndex = (UInt32Value)8U, DataType = CellValues.SharedString }; CellValue cellValue12 = new CellValue(); cellValue12.Text = "10"; cell67.Append(cellValue12); Cell cell68 = new Cell() { CellReference = "C15", StyleIndex = (UInt32Value)13U }; Cell cell69 = new Cell() { CellReference = "D15", StyleIndex = (UInt32Value)13U }; Cell cell70 = new Cell() { CellReference = "E15", StyleIndex = (UInt32Value)14U }; row12.Append(cell67); row12.Append(cell68); row12.Append(cell69); row12.Append(cell70); Row row13 = new Row() { RowIndex = (UInt32Value)16U, Spans = new ListValue<StringValue>() { InnerText = "2:44" }, StyleIndex = (UInt32Value)3U, CustomFormat = true, Height = 15D, CustomHeight = true }; Cell cell71 = new Cell() { CellReference = "B16", StyleIndex = (UInt32Value)8U, DataType = CellValues.SharedString }; CellValue cellValue13 = new CellValue(); cellValue13.Text = "11"; cell71.Append(cellValue13); Cell cell72 = new Cell() { CellReference = "C16", StyleIndex = (UInt32Value)15U }; Cell cell73 = new Cell() { CellReference = "D16", StyleIndex = (UInt32Value)16U }; Cell cell74 = new Cell() { CellReference = "E16", StyleIndex = (UInt32Value)9U }; Cell cell75 = new Cell() { CellReference = "F16", StyleIndex = (UInt32Value)9U }; Cell cell76 = new Cell() { CellReference = "G16", StyleIndex = (UInt32Value)2U }; Cell cell77 = new Cell() { CellReference = "H16", StyleIndex = (UInt32Value)2U }; Cell cell78 = new Cell() { CellReference = "I16", StyleIndex = (UInt32Value)2U }; Cell cell79 = new Cell() { CellReference = "J16", StyleIndex = (UInt32Value)2U }; Cell cell80 = new Cell() { CellReference = "K16", StyleIndex = (UInt32Value)2U }; Cell cell81 = new Cell() { CellReference = "L16", StyleIndex = (UInt32Value)2U }; Cell cell82 = new Cell() { CellReference = "M16", StyleIndex = (UInt32Value)2U }; Cell cell83 = new Cell() { CellReference = "N16", StyleIndex = (UInt32Value)2U }; Cell cell84 = new Cell() { CellReference = "O16", StyleIndex = (UInt32Value)2U }; Cell cell85 = new Cell() { CellReference = "P16", StyleIndex = (UInt32Value)2U }; Cell cell86 = new Cell() { CellReference = "Q16", StyleIndex = (UInt32Value)2U }; Cell cell87 = new Cell() { CellReference = "R16", StyleIndex = (UInt32Value)2U }; Cell cell88 = new Cell() { CellReference = "S16", StyleIndex = (UInt32Value)2U }; Cell cell89 = new Cell() { CellReference = "T16", StyleIndex = (UInt32Value)2U }; Cell cell90 = new Cell() { CellReference = "U16", StyleIndex = (UInt32Value)2U }; Cell cell91 = new Cell() { CellReference = "V16", StyleIndex = (UInt32Value)2U }; Cell cell92 = new Cell() { CellReference = "W16", StyleIndex = (UInt32Value)2U }; Cell cell93 = new Cell() { CellReference = "X16", StyleIndex = (UInt32Value)2U }; Cell cell94 = new Cell() { CellReference = "Y16", StyleIndex = (UInt32Value)2U }; Cell cell95 = new Cell() { CellReference = "Z16", StyleIndex = (UInt32Value)2U }; Cell cell96 = new Cell() { CellReference = "AA16", StyleIndex = (UInt32Value)2U }; Cell cell97 = new Cell() { CellReference = "AB16", StyleIndex = (UInt32Value)2U }; Cell cell98 = new Cell() { CellReference = "AC16", StyleIndex = (UInt32Value)2U }; Cell cell99 = new Cell() { CellReference = "AD16", StyleIndex = (UInt32Value)2U }; Cell cell100 = new Cell() { CellReference = "AE16", StyleIndex = (UInt32Value)2U }; Cell cell101 = new Cell() { CellReference = "AF16", StyleIndex = (UInt32Value)2U }; Cell cell102 = new Cell() { CellReference = "AG16", StyleIndex = (UInt32Value)2U }; Cell cell103 = new Cell() { CellReference = "AH16", StyleIndex = (UInt32Value)2U }; Cell cell104 = new Cell() { CellReference = "AI16", StyleIndex = (UInt32Value)2U }; Cell cell105 = new Cell() { CellReference = "AJ16", StyleIndex = (UInt32Value)2U }; Cell cell106 = new Cell() { CellReference = "AK16", StyleIndex = (UInt32Value)2U }; Cell cell107 = new Cell() { CellReference = "AL16", StyleIndex = (UInt32Value)2U }; Cell cell108 = new Cell() { CellReference = "AM16", StyleIndex = (UInt32Value)2U }; Cell cell109 = new Cell() { CellReference = "AN16", StyleIndex = (UInt32Value)2U }; Cell cell110 = new Cell() { CellReference = "AO16", StyleIndex = (UInt32Value)2U }; Cell cell111 = new Cell() { CellReference = "AP16", StyleIndex = (UInt32Value)2U }; Cell cell112 = new Cell() { CellReference = "AQ16", StyleIndex = (UInt32Value)2U }; Cell cell113 = new Cell() { CellReference = "AR16", StyleIndex = (UInt32Value)2U }; row13.Append(cell71); row13.Append(cell72); row13.Append(cell73); row13.Append(cell74); row13.Append(cell75); row13.Append(cell76); row13.Append(cell77); row13.Append(cell78); row13.Append(cell79); row13.Append(cell80); row13.Append(cell81); row13.Append(cell82); row13.Append(cell83); row13.Append(cell84); row13.Append(cell85); row13.Append(cell86); row13.Append(cell87); row13.Append(cell88); row13.Append(cell89); row13.Append(cell90); row13.Append(cell91); row13.Append(cell92); row13.Append(cell93); row13.Append(cell94); row13.Append(cell95); row13.Append(cell96); row13.Append(cell97); row13.Append(cell98); row13.Append(cell99); row13.Append(cell100); row13.Append(cell101); row13.Append(cell102); row13.Append(cell103); row13.Append(cell104); row13.Append(cell105); row13.Append(cell106); row13.Append(cell107); row13.Append(cell108); row13.Append(cell109); row13.Append(cell110); row13.Append(cell111); row13.Append(cell112); row13.Append(cell113); Row row14 = new Row() { RowIndex = (UInt32Value)17U, Spans = new ListValue<StringValue>() { InnerText = "2:44" } }; Cell cell114 = new Cell() { CellReference = "E17", StyleIndex = (UInt32Value)9U }; Cell cell115 = new Cell() { CellReference = "F17", StyleIndex = (UInt32Value)9U }; Cell cell116 = new Cell() { CellReference = "AL17", StyleIndex = (UInt32Value)4U }; Cell cell117 = new Cell() { CellReference = "AM17", StyleIndex = (UInt32Value)4U }; Cell cell118 = new Cell() { CellReference = "AN17", StyleIndex = (UInt32Value)4U }; Cell cell119 = new Cell() { CellReference = "AO17", StyleIndex = (UInt32Value)2U }; Cell cell120 = new Cell() { CellReference = "AP17", StyleIndex = (UInt32Value)2U }; Cell cell121 = new Cell() { CellReference = "AQ17", StyleIndex = (UInt32Value)2U }; Cell cell122 = new Cell() { CellReference = "AR17", StyleIndex = (UInt32Value)2U }; row14.Append(cell114); row14.Append(cell115); row14.Append(cell116); row14.Append(cell117); row14.Append(cell118); row14.Append(cell119); row14.Append(cell120); row14.Append(cell121); row14.Append(cell122); Row row15 = new Row() { RowIndex = (UInt32Value)18U, Spans = new ListValue<StringValue>() { InnerText = "2:44" } }; Cell cell123 = new Cell() { CellReference = "G18", StyleIndex = (UInt32Value)79U }; CellFormula cellFormula1 = new CellFormula(); cellFormula1.Text = "+F6"; CellValue cellValue14 = new CellValue(); cellValue14.Text = "0"; cell123.Append(cellFormula1); cell123.Append(cellValue14); Cell cell124 = new Cell() { CellReference = "H18", StyleIndex = (UInt32Value)80U }; Cell cell125 = new Cell() { CellReference = "I18", StyleIndex = (UInt32Value)80U }; Cell cell126 = new Cell() { CellReference = "J18", StyleIndex = (UInt32Value)80U }; Cell cell127 = new Cell() { CellReference = "K18", StyleIndex = (UInt32Value)80U }; Cell cell128 = new Cell() { CellReference = "L18", StyleIndex = (UInt32Value)80U }; Cell cell129 = new Cell() { CellReference = "M18", StyleIndex = (UInt32Value)80U }; Cell cell130 = new Cell() { CellReference = "N18", StyleIndex = (UInt32Value)80U }; Cell cell131 = new Cell() { CellReference = "O18", StyleIndex = (UInt32Value)80U }; Cell cell132 = new Cell() { CellReference = "P18", StyleIndex = (UInt32Value)80U }; Cell cell133 = new Cell() { CellReference = "Q18", StyleIndex = (UInt32Value)80U }; Cell cell134 = new Cell() { CellReference = "R18", StyleIndex = (UInt32Value)80U }; Cell cell135 = new Cell() { CellReference = "S18", StyleIndex = (UInt32Value)80U }; Cell cell136 = new Cell() { CellReference = "T18", StyleIndex = (UInt32Value)80U }; Cell cell137 = new Cell() { CellReference = "U18", StyleIndex = (UInt32Value)80U }; Cell cell138 = new Cell() { CellReference = "V18", StyleIndex = (UInt32Value)80U }; Cell cell139 = new Cell() { CellReference = "W18", StyleIndex = (UInt32Value)80U }; Cell cell140 = new Cell() { CellReference = "X18", StyleIndex = (UInt32Value)80U }; Cell cell141 = new Cell() { CellReference = "Y18", StyleIndex = (UInt32Value)80U }; Cell cell142 = new Cell() { CellReference = "Z18", StyleIndex = (UInt32Value)80U }; Cell cell143 = new Cell() { CellReference = "AA18", StyleIndex = (UInt32Value)80U }; Cell cell144 = new Cell() { CellReference = "AB18", StyleIndex = (UInt32Value)80U }; Cell cell145 = new Cell() { CellReference = "AC18", StyleIndex = (UInt32Value)80U }; Cell cell146 = new Cell() { CellReference = "AD18", StyleIndex = (UInt32Value)80U }; Cell cell147 = new Cell() { CellReference = "AE18", StyleIndex = (UInt32Value)80U }; Cell cell148 = new Cell() { CellReference = "AF18", StyleIndex = (UInt32Value)80U }; Cell cell149 = new Cell() { CellReference = "AG18", StyleIndex = (UInt32Value)80U }; Cell cell150 = new Cell() { CellReference = "AH18", StyleIndex = (UInt32Value)80U }; Cell cell151 = new Cell() { CellReference = "AI18", StyleIndex = (UInt32Value)80U }; Cell cell152 = new Cell() { CellReference = "AJ18", StyleIndex = (UInt32Value)80U }; Cell cell153 = new Cell() { CellReference = "AK18", StyleIndex = (UInt32Value)80U }; Cell cell154 = new Cell() { CellReference = "AL18", StyleIndex = (UInt32Value)80U }; Cell cell155 = new Cell() { CellReference = "AM18", StyleIndex = (UInt32Value)80U }; Cell cell156 = new Cell() { CellReference = "AN18", StyleIndex = (UInt32Value)81U }; Cell cell157 = new Cell() { CellReference = "AO18", StyleIndex = (UInt32Value)2U }; Cell cell158 = new Cell() { CellReference = "AP18", StyleIndex = (UInt32Value)2U }; Cell cell159 = new Cell() { CellReference = "AQ18", StyleIndex = (UInt32Value)2U }; Cell cell160 = new Cell() { CellReference = "AR18", StyleIndex = (UInt32Value)2U }; row15.Append(cell123); row15.Append(cell124); row15.Append(cell125); row15.Append(cell126); row15.Append(cell127); row15.Append(cell128); row15.Append(cell129); row15.Append(cell130); row15.Append(cell131); row15.Append(cell132); row15.Append(cell133); row15.Append(cell134); row15.Append(cell135); row15.Append(cell136); row15.Append(cell137); row15.Append(cell138); row15.Append(cell139); row15.Append(cell140); row15.Append(cell141); row15.Append(cell142); row15.Append(cell143); row15.Append(cell144); row15.Append(cell145); row15.Append(cell146); row15.Append(cell147); row15.Append(cell148); row15.Append(cell149); row15.Append(cell150); row15.Append(cell151); row15.Append(cell152); row15.Append(cell153); row15.Append(cell154); row15.Append(cell155); row15.Append(cell156); row15.Append(cell157); row15.Append(cell158); row15.Append(cell159); row15.Append(cell160); Row row16 = new Row() { RowIndex = (UInt32Value)19U, Spans = new ListValue<StringValue>() { InnerText = "2:44" }, StyleIndex = (UInt32Value)3U, CustomFormat = true, Height = 12.75D, CustomHeight = true }; Cell cell161 = new Cell() { CellReference = "B19", StyleIndex = (UInt32Value)18U, DataType = CellValues.SharedString }; CellValue cellValue15 = new CellValue(); cellValue15.Text = "12"; cell161.Append(cellValue15); Cell cell162 = new Cell() { CellReference = "C19", StyleIndex = (UInt32Value)19U, DataType = CellValues.SharedString }; CellValue cellValue16 = new CellValue(); cellValue16.Text = "13"; cell162.Append(cellValue16); Cell cell163 = new Cell() { CellReference = "D19", StyleIndex = (UInt32Value)19U, DataType = CellValues.SharedString }; CellValue cellValue17 = new CellValue(); cellValue17.Text = "14"; cell163.Append(cellValue17); Cell cell164 = new Cell() { CellReference = "E19", StyleIndex = (UInt32Value)18U, DataType = CellValues.SharedString }; CellValue cellValue18 = new CellValue(); cellValue18.Text = "15"; cell164.Append(cellValue18); Cell cell165 = new Cell() { CellReference = "F19", StyleIndex = (UInt32Value)20U, DataType = CellValues.SharedString }; CellValue cellValue19 = new CellValue(); cellValue19.Text = "16"; cell165.Append(cellValue19); Cell cell166 = new Cell() { CellReference = "G19", StyleIndex = (UInt32Value)21U, DataType = CellValues.SharedString }; CellValue cellValue20 = new CellValue(); cellValue20.Text = "17"; cell166.Append(cellValue20); Cell cell167 = new Cell() { CellReference = "H19", StyleIndex = (UInt32Value)21U, DataType = CellValues.SharedString }; CellValue cellValue21 = new CellValue(); cellValue21.Text = "18"; cell167.Append(cellValue21); Cell cell168 = new Cell() { CellReference = "I19", StyleIndex = (UInt32Value)21U, DataType = CellValues.SharedString }; CellValue cellValue22 = new CellValue(); cellValue22.Text = "19"; cell168.Append(cellValue22); Cell cell169 = new Cell() { CellReference = "J19", StyleIndex = (UInt32Value)21U, DataType = CellValues.SharedString }; CellValue cellValue23 = new CellValue(); cellValue23.Text = "20"; cell169.Append(cellValue23); Cell cell170 = new Cell() { CellReference = "K19", StyleIndex = (UInt32Value)21U, DataType = CellValues.SharedString }; CellValue cellValue24 = new CellValue(); cellValue24.Text = "20"; cell170.Append(cellValue24); Cell cell171 = new Cell() { CellReference = "L19", StyleIndex = (UInt32Value)21U, DataType = CellValues.SharedString }; CellValue cellValue25 = new CellValue(); cellValue25.Text = "21"; cell171.Append(cellValue25); Cell cell172 = new Cell() { CellReference = "M19", StyleIndex = (UInt32Value)21U, DataType = CellValues.SharedString }; CellValue cellValue26 = new CellValue(); cellValue26.Text = "22"; cell172.Append(cellValue26); Cell cell173 = new Cell() { CellReference = "N19", StyleIndex = (UInt32Value)21U, DataType = CellValues.SharedString }; CellValue cellValue27 = new CellValue(); cellValue27.Text = "17"; cell173.Append(cellValue27); Cell cell174 = new Cell() { CellReference = "O19", StyleIndex = (UInt32Value)21U, DataType = CellValues.SharedString }; CellValue cellValue28 = new CellValue(); cellValue28.Text = "18"; cell174.Append(cellValue28); Cell cell175 = new Cell() { CellReference = "P19", StyleIndex = (UInt32Value)21U, DataType = CellValues.SharedString }; CellValue cellValue29 = new CellValue(); cellValue29.Text = "19"; cell175.Append(cellValue29); Cell cell176 = new Cell() { CellReference = "Q19", StyleIndex = (UInt32Value)21U, DataType = CellValues.SharedString }; CellValue cellValue30 = new CellValue(); cellValue30.Text = "20"; cell176.Append(cellValue30); Cell cell177 = new Cell() { CellReference = "R19", StyleIndex = (UInt32Value)21U, DataType = CellValues.SharedString }; CellValue cellValue31 = new CellValue(); cellValue31.Text = "20"; cell177.Append(cellValue31); Cell cell178 = new Cell() { CellReference = "S19", StyleIndex = (UInt32Value)21U, DataType = CellValues.SharedString }; CellValue cellValue32 = new CellValue(); cellValue32.Text = "21"; cell178.Append(cellValue32); Cell cell179 = new Cell() { CellReference = "T19", StyleIndex = (UInt32Value)21U, DataType = CellValues.SharedString }; CellValue cellValue33 = new CellValue(); cellValue33.Text = "22"; cell179.Append(cellValue33); Cell cell180 = new Cell() { CellReference = "U19", StyleIndex = (UInt32Value)21U, DataType = CellValues.SharedString }; CellValue cellValue34 = new CellValue(); cellValue34.Text = "17"; cell180.Append(cellValue34); Cell cell181 = new Cell() { CellReference = "V19", StyleIndex = (UInt32Value)21U, DataType = CellValues.SharedString }; CellValue cellValue35 = new CellValue(); cellValue35.Text = "18"; cell181.Append(cellValue35); Cell cell182 = new Cell() { CellReference = "W19", StyleIndex = (UInt32Value)21U, DataType = CellValues.SharedString }; CellValue cellValue36 = new CellValue(); cellValue36.Text = "19"; cell182.Append(cellValue36); Cell cell183 = new Cell() { CellReference = "X19", StyleIndex = (UInt32Value)21U, DataType = CellValues.SharedString }; CellValue cellValue37 = new CellValue(); cellValue37.Text = "20"; cell183.Append(cellValue37); Cell cell184 = new Cell() { CellReference = "Y19", StyleIndex = (UInt32Value)21U, DataType = CellValues.SharedString }; CellValue cellValue38 = new CellValue(); cellValue38.Text = "20"; cell184.Append(cellValue38); Cell cell185 = new Cell() { CellReference = "Z19", StyleIndex = (UInt32Value)21U, DataType = CellValues.SharedString }; CellValue cellValue39 = new CellValue(); cellValue39.Text = "21"; cell185.Append(cellValue39); Cell cell186 = new Cell() { CellReference = "AA19", StyleIndex = (UInt32Value)21U, DataType = CellValues.SharedString }; CellValue cellValue40 = new CellValue(); cellValue40.Text = "22"; cell186.Append(cellValue40); Cell cell187 = new Cell() { CellReference = "AB19", StyleIndex = (UInt32Value)21U, DataType = CellValues.SharedString }; CellValue cellValue41 = new CellValue(); cellValue41.Text = "17"; cell187.Append(cellValue41); Cell cell188 = new Cell() { CellReference = "AC19", StyleIndex = (UInt32Value)21U, DataType = CellValues.SharedString }; CellValue cellValue42 = new CellValue(); cellValue42.Text = "18"; cell188.Append(cellValue42); Cell cell189 = new Cell() { CellReference = "AD19", StyleIndex = (UInt32Value)21U, DataType = CellValues.SharedString }; CellValue cellValue43 = new CellValue(); cellValue43.Text = "19"; cell189.Append(cellValue43); Cell cell190 = new Cell() { CellReference = "AE19", StyleIndex = (UInt32Value)21U, DataType = CellValues.SharedString }; CellValue cellValue44 = new CellValue(); cellValue44.Text = "20"; cell190.Append(cellValue44); Cell cell191 = new Cell() { CellReference = "AF19", StyleIndex = (UInt32Value)21U, DataType = CellValues.SharedString }; CellValue cellValue45 = new CellValue(); cellValue45.Text = "20"; cell191.Append(cellValue45); Cell cell192 = new Cell() { CellReference = "AG19", StyleIndex = (UInt32Value)21U, DataType = CellValues.SharedString }; CellValue cellValue46 = new CellValue(); cellValue46.Text = "21"; cell192.Append(cellValue46); Cell cell193 = new Cell() { CellReference = "AH19", StyleIndex = (UInt32Value)21U, DataType = CellValues.SharedString }; CellValue cellValue47 = new CellValue(); cellValue47.Text = "22"; cell193.Append(cellValue47); Cell cell194 = new Cell() { CellReference = "AI19", StyleIndex = (UInt32Value)21U, DataType = CellValues.SharedString }; CellValue cellValue48 = new CellValue(); cellValue48.Text = "17"; cell194.Append(cellValue48); Cell cell195 = new Cell() { CellReference = "AJ19", StyleIndex = (UInt32Value)21U, DataType = CellValues.SharedString }; CellValue cellValue49 = new CellValue(); cellValue49.Text = "18"; cell195.Append(cellValue49); Cell cell196 = new Cell() { CellReference = "AK19", StyleIndex = (UInt32Value)21U, DataType = CellValues.SharedString }; CellValue cellValue50 = new CellValue(); cellValue50.Text = "19"; cell196.Append(cellValue50); Cell cell197 = new Cell() { CellReference = "AL19", StyleIndex = (UInt32Value)22U, DataType = CellValues.SharedString }; CellValue cellValue51 = new CellValue(); cellValue51.Text = "23"; cell197.Append(cellValue51); Cell cell198 = new Cell() { CellReference = "AM19", StyleIndex = (UInt32Value)23U, DataType = CellValues.SharedString }; CellValue cellValue52 = new CellValue(); cellValue52.Text = "24"; cell198.Append(cellValue52); Cell cell199 = new Cell() { CellReference = "AN19", StyleIndex = (UInt32Value)22U, DataType = CellValues.SharedString }; CellValue cellValue53 = new CellValue(); cellValue53.Text = "25"; cell199.Append(cellValue53); Cell cell200 = new Cell() { CellReference = "AO19", StyleIndex = (UInt32Value)2U }; Cell cell201 = new Cell() { CellReference = "AP19", StyleIndex = (UInt32Value)2U }; Cell cell202 = new Cell() { CellReference = "AQ19", StyleIndex = (UInt32Value)2U }; Cell cell203 = new Cell() { CellReference = "AR19", StyleIndex = (UInt32Value)2U }; row16.Append(cell161); row16.Append(cell162); row16.Append(cell163); row16.Append(cell164); row16.Append(cell165); row16.Append(cell166); row16.Append(cell167); row16.Append(cell168); row16.Append(cell169); row16.Append(cell170); row16.Append(cell171); row16.Append(cell172); row16.Append(cell173); row16.Append(cell174); row16.Append(cell175); row16.Append(cell176); row16.Append(cell177); row16.Append(cell178); row16.Append(cell179); row16.Append(cell180); row16.Append(cell181); row16.Append(cell182); row16.Append(cell183); row16.Append(cell184); row16.Append(cell185); row16.Append(cell186); row16.Append(cell187); row16.Append(cell188); row16.Append(cell189); row16.Append(cell190); row16.Append(cell191); row16.Append(cell192); row16.Append(cell193); row16.Append(cell194); row16.Append(cell195); row16.Append(cell196); row16.Append(cell197); row16.Append(cell198); row16.Append(cell199); row16.Append(cell200); row16.Append(cell201); row16.Append(cell202); row16.Append(cell203); Row row17 = new Row() { RowIndex = (UInt32Value)20U, Spans = new ListValue<StringValue>() { InnerText = "2:44" }, StyleIndex = (UInt32Value)3U, CustomFormat = true, Height = 13.5D, CustomHeight = true, ThickBot = true }; Cell cell204 = new Cell() { CellReference = "B20", StyleIndex = (UInt32Value)24U }; Cell cell205 = new Cell() { CellReference = "C20", StyleIndex = (UInt32Value)25U }; Cell cell206 = new Cell() { CellReference = "D20", StyleIndex = (UInt32Value)25U }; Cell cell207 = new Cell() { CellReference = "E20", StyleIndex = (UInt32Value)22U, DataType = CellValues.SharedString }; CellValue cellValue54 = new CellValue(); cellValue54.Text = "26"; cell207.Append(cellValue54); Cell cell208 = new Cell() { CellReference = "F20", StyleIndex = (UInt32Value)26U }; Cell cell209 = new Cell() { CellReference = "G20", StyleIndex = (UInt32Value)27U }; CellValue cellValue55 = new CellValue(); cellValue55.Text = "1"; cell209.Append(cellValue55); Cell cell210 = new Cell() { CellReference = "H20", StyleIndex = (UInt32Value)27U }; CellValue cellValue56 = new CellValue(); cellValue56.Text = "2"; cell210.Append(cellValue56); Cell cell211 = new Cell() { CellReference = "I20", StyleIndex = (UInt32Value)27U }; CellValue cellValue57 = new CellValue(); cellValue57.Text = "3"; cell211.Append(cellValue57); Cell cell212 = new Cell() { CellReference = "J20", StyleIndex = (UInt32Value)27U }; CellValue cellValue58 = new CellValue(); cellValue58.Text = "4"; cell212.Append(cellValue58); Cell cell213 = new Cell() { CellReference = "K20", StyleIndex = (UInt32Value)27U }; CellValue cellValue59 = new CellValue(); cellValue59.Text = "5"; cell213.Append(cellValue59); Cell cell214 = new Cell() { CellReference = "L20", StyleIndex = (UInt32Value)27U }; CellValue cellValue60 = new CellValue(); cellValue60.Text = "6"; cell214.Append(cellValue60); Cell cell215 = new Cell() { CellReference = "M20", StyleIndex = (UInt32Value)27U }; CellValue cellValue61 = new CellValue(); cellValue61.Text = "7"; cell215.Append(cellValue61); Cell cell216 = new Cell() { CellReference = "N20", StyleIndex = (UInt32Value)27U }; CellValue cellValue62 = new CellValue(); cellValue62.Text = "8"; cell216.Append(cellValue62); Cell cell217 = new Cell() { CellReference = "O20", StyleIndex = (UInt32Value)27U }; CellValue cellValue63 = new CellValue(); cellValue63.Text = "9"; cell217.Append(cellValue63); Cell cell218 = new Cell() { CellReference = "P20", StyleIndex = (UInt32Value)27U }; CellValue cellValue64 = new CellValue(); cellValue64.Text = "10"; cell218.Append(cellValue64); Cell cell219 = new Cell() { CellReference = "Q20", StyleIndex = (UInt32Value)27U }; CellValue cellValue65 = new CellValue(); cellValue65.Text = "11"; cell219.Append(cellValue65); Cell cell220 = new Cell() { CellReference = "R20", StyleIndex = (UInt32Value)27U }; CellValue cellValue66 = new CellValue(); cellValue66.Text = "12"; cell220.Append(cellValue66); Cell cell221 = new Cell() { CellReference = "S20", StyleIndex = (UInt32Value)27U }; CellValue cellValue67 = new CellValue(); cellValue67.Text = "13"; cell221.Append(cellValue67); Cell cell222 = new Cell() { CellReference = "T20", StyleIndex = (UInt32Value)27U }; CellValue cellValue68 = new CellValue(); cellValue68.Text = "14"; cell222.Append(cellValue68); Cell cell223 = new Cell() { CellReference = "U20", StyleIndex = (UInt32Value)27U }; CellValue cellValue69 = new CellValue(); cellValue69.Text = "15"; cell223.Append(cellValue69); Cell cell224 = new Cell() { CellReference = "V20", StyleIndex = (UInt32Value)27U }; CellValue cellValue70 = new CellValue(); cellValue70.Text = "16"; cell224.Append(cellValue70); Cell cell225 = new Cell() { CellReference = "W20", StyleIndex = (UInt32Value)27U }; CellValue cellValue71 = new CellValue(); cellValue71.Text = "17"; cell225.Append(cellValue71); Cell cell226 = new Cell() { CellReference = "X20", StyleIndex = (UInt32Value)27U }; CellValue cellValue72 = new CellValue(); cellValue72.Text = "18"; cell226.Append(cellValue72); Cell cell227 = new Cell() { CellReference = "Y20", StyleIndex = (UInt32Value)27U }; CellValue cellValue73 = new CellValue(); cellValue73.Text = "19"; cell227.Append(cellValue73); Cell cell228 = new Cell() { CellReference = "Z20", StyleIndex = (UInt32Value)27U }; CellValue cellValue74 = new CellValue(); cellValue74.Text = "20"; cell228.Append(cellValue74); Cell cell229 = new Cell() { CellReference = "AA20", StyleIndex = (UInt32Value)27U }; CellValue cellValue75 = new CellValue(); cellValue75.Text = "21"; cell229.Append(cellValue75); Cell cell230 = new Cell() { CellReference = "AB20", StyleIndex = (UInt32Value)27U }; CellValue cellValue76 = new CellValue(); cellValue76.Text = "22"; cell230.Append(cellValue76); Cell cell231 = new Cell() { CellReference = "AC20", StyleIndex = (UInt32Value)27U }; CellValue cellValue77 = new CellValue(); cellValue77.Text = "23"; cell231.Append(cellValue77); Cell cell232 = new Cell() { CellReference = "AD20", StyleIndex = (UInt32Value)27U }; CellValue cellValue78 = new CellValue(); cellValue78.Text = "24"; cell232.Append(cellValue78); Cell cell233 = new Cell() { CellReference = "AE20", StyleIndex = (UInt32Value)27U }; CellValue cellValue79 = new CellValue(); cellValue79.Text = "25"; cell233.Append(cellValue79); Cell cell234 = new Cell() { CellReference = "AF20", StyleIndex = (UInt32Value)27U }; CellValue cellValue80 = new CellValue(); cellValue80.Text = "26"; cell234.Append(cellValue80); Cell cell235 = new Cell() { CellReference = "AG20", StyleIndex = (UInt32Value)27U }; CellValue cellValue81 = new CellValue(); cellValue81.Text = "27"; cell235.Append(cellValue81); Cell cell236 = new Cell() { CellReference = "AH20", StyleIndex = (UInt32Value)27U }; CellValue cellValue82 = new CellValue(); cellValue82.Text = "28"; cell236.Append(cellValue82); Cell cell237 = new Cell() { CellReference = "AI20", StyleIndex = (UInt32Value)27U }; CellValue cellValue83 = new CellValue(); cellValue83.Text = "29"; cell237.Append(cellValue83); Cell cell238 = new Cell() { CellReference = "AJ20", StyleIndex = (UInt32Value)27U }; CellValue cellValue84 = new CellValue(); cellValue84.Text = "30"; cell238.Append(cellValue84); Cell cell239 = new Cell() { CellReference = "AK20", StyleIndex = (UInt32Value)27U }; CellValue cellValue85 = new CellValue(); cellValue85.Text = "31"; cell239.Append(cellValue85); Cell cell240 = new Cell() { CellReference = "AL20", StyleIndex = (UInt32Value)21U, DataType = CellValues.SharedString }; CellValue cellValue86 = new CellValue(); cellValue86.Text = "27"; cell240.Append(cellValue86); Cell cell241 = new Cell() { CellReference = "AM20", StyleIndex = (UInt32Value)28U, DataType = CellValues.SharedString }; CellValue cellValue87 = new CellValue(); cellValue87.Text = "28"; cell241.Append(cellValue87); Cell cell242 = new Cell() { CellReference = "AN20", StyleIndex = (UInt32Value)21U, DataType = CellValues.SharedString }; CellValue cellValue88 = new CellValue(); cellValue88.Text = "29"; cell242.Append(cellValue88); Cell cell243 = new Cell() { CellReference = "AO20", StyleIndex = (UInt32Value)2U }; Cell cell244 = new Cell() { CellReference = "AP20", StyleIndex = (UInt32Value)2U }; Cell cell245 = new Cell() { CellReference = "AQ20", StyleIndex = (UInt32Value)2U }; Cell cell246 = new Cell() { CellReference = "AR20", StyleIndex = (UInt32Value)2U }; row17.Append(cell204); row17.Append(cell205); row17.Append(cell206); row17.Append(cell207); row17.Append(cell208); row17.Append(cell209); row17.Append(cell210); row17.Append(cell211); row17.Append(cell212); row17.Append(cell213); row17.Append(cell214); row17.Append(cell215); row17.Append(cell216); row17.Append(cell217); row17.Append(cell218); row17.Append(cell219); row17.Append(cell220); row17.Append(cell221); row17.Append(cell222); row17.Append(cell223); row17.Append(cell224); row17.Append(cell225); row17.Append(cell226); row17.Append(cell227); row17.Append(cell228); row17.Append(cell229); row17.Append(cell230); row17.Append(cell231); row17.Append(cell232); row17.Append(cell233); row17.Append(cell234); row17.Append(cell235); row17.Append(cell236); row17.Append(cell237); row17.Append(cell238); row17.Append(cell239); row17.Append(cell240); row17.Append(cell241); row17.Append(cell242); row17.Append(cell243); row17.Append(cell244); row17.Append(cell245); row17.Append(cell246); Row row18 = new Row() { RowIndex = (UInt32Value)21U, Spans = new ListValue<StringValue>() { InnerText = "2:44" }, StyleIndex = (UInt32Value)3U, CustomFormat = true, Height = 13.5D, CustomHeight = true }; Cell cell247 = new Cell() { CellReference = "B21", StyleIndex = (UInt32Value)29U }; Cell cell248 = new Cell() { CellReference = "C21", StyleIndex = (UInt32Value)30U }; Cell cell249 = new Cell() { CellReference = "D21", StyleIndex = (UInt32Value)31U }; Cell cell250 = new Cell() { CellReference = "E21", StyleIndex = (UInt32Value)31U, DataType = CellValues.SharedString }; CellValue cellValue89 = new CellValue(); cellValue89.Text = "31"; cell250.Append(cellValue89); Cell cell251 = new Cell() { CellReference = "F21", StyleIndex = (UInt32Value)32U }; Cell cell252 = new Cell() { CellReference = "G21", StyleIndex = (UInt32Value)33U }; Cell cell253 = new Cell() { CellReference = "H21", StyleIndex = (UInt32Value)34U }; Cell cell254 = new Cell() { CellReference = "I21", StyleIndex = (UInt32Value)34U }; Cell cell255 = new Cell() { CellReference = "J21", StyleIndex = (UInt32Value)34U }; Cell cell256 = new Cell() { CellReference = "K21", StyleIndex = (UInt32Value)34U }; Cell cell257 = new Cell() { CellReference = "L21", StyleIndex = (UInt32Value)34U }; CellValue cellValue90 = new CellValue(); cellValue90.Text = "0"; cell257.Append(cellValue90); Cell cell258 = new Cell() { CellReference = "M21", StyleIndex = (UInt32Value)34U }; Cell cell259 = new Cell() { CellReference = "N21", StyleIndex = (UInt32Value)35U }; Cell cell260 = new Cell() { CellReference = "O21", StyleIndex = (UInt32Value)34U }; Cell cell261 = new Cell() { CellReference = "P21", StyleIndex = (UInt32Value)34U }; Cell cell262 = new Cell() { CellReference = "Q21", StyleIndex = (UInt32Value)34U }; Cell cell263 = new Cell() { CellReference = "R21", StyleIndex = (UInt32Value)34U }; Cell cell264 = new Cell() { CellReference = "S21", StyleIndex = (UInt32Value)34U }; Cell cell265 = new Cell() { CellReference = "T21", StyleIndex = (UInt32Value)34U }; Cell cell266 = new Cell() { CellReference = "U21", StyleIndex = (UInt32Value)35U }; Cell cell267 = new Cell() { CellReference = "V21", StyleIndex = (UInt32Value)34U }; Cell cell268 = new Cell() { CellReference = "W21", StyleIndex = (UInt32Value)34U }; Cell cell269 = new Cell() { CellReference = "X21", StyleIndex = (UInt32Value)34U }; Cell cell270 = new Cell() { CellReference = "Y21", StyleIndex = (UInt32Value)34U }; Cell cell271 = new Cell() { CellReference = "Z21", StyleIndex = (UInt32Value)34U }; Cell cell272 = new Cell() { CellReference = "AA21", StyleIndex = (UInt32Value)34U }; Cell cell273 = new Cell() { CellReference = "AB21", StyleIndex = (UInt32Value)35U }; Cell cell274 = new Cell() { CellReference = "AC21", StyleIndex = (UInt32Value)35U }; Cell cell275 = new Cell() { CellReference = "AD21", StyleIndex = (UInt32Value)35U }; Cell cell276 = new Cell() { CellReference = "AE21", StyleIndex = (UInt32Value)34U }; Cell cell277 = new Cell() { CellReference = "AF21", StyleIndex = (UInt32Value)34U }; Cell cell278 = new Cell() { CellReference = "AG21", StyleIndex = (UInt32Value)34U }; Cell cell279 = new Cell() { CellReference = "AH21", StyleIndex = (UInt32Value)34U }; Cell cell280 = new Cell() { CellReference = "AI21", StyleIndex = (UInt32Value)34U }; Cell cell281 = new Cell() { CellReference = "AJ21", StyleIndex = (UInt32Value)34U }; Cell cell282 = new Cell() { CellReference = "AK21", StyleIndex = (UInt32Value)34U }; Cell cell283 = new Cell() { CellReference = "AL21", StyleIndex = (UInt32Value)36U }; CellFormula cellFormula2 = new CellFormula(); cellFormula2.Text = "SUM(G21:AK21)"; CellValue cellValue91 = new CellValue(); cellValue91.Text = "0"; cell283.Append(cellFormula2); cell283.Append(cellValue91); Cell cell284 = new Cell() { CellReference = "AM21", StyleIndex = (UInt32Value)92U }; CellValue cellValue92 = new CellValue(); cellValue92.Text = "0"; cell284.Append(cellValue92); Cell cell285 = new Cell() { CellReference = "AN21", StyleIndex = (UInt32Value)89U }; CellFormula cellFormula3 = new CellFormula(); cellFormula3.Text = "SUM(AM21*AL21)"; CellValue cellValue93 = new CellValue(); cellValue93.Text = "0"; cell285.Append(cellFormula3); cell285.Append(cellValue93); Cell cell286 = new Cell() { CellReference = "AO21", StyleIndex = (UInt32Value)2U }; Cell cell287 = new Cell() { CellReference = "AP21", StyleIndex = (UInt32Value)2U }; Cell cell288 = new Cell() { CellReference = "AQ21", StyleIndex = (UInt32Value)2U }; Cell cell289 = new Cell() { CellReference = "AR21", StyleIndex = (UInt32Value)2U }; row18.Append(cell247); row18.Append(cell248); row18.Append(cell249); row18.Append(cell250); row18.Append(cell251); row18.Append(cell252); row18.Append(cell253); row18.Append(cell254); row18.Append(cell255); row18.Append(cell256); row18.Append(cell257); row18.Append(cell258); row18.Append(cell259); row18.Append(cell260); row18.Append(cell261); row18.Append(cell262); row18.Append(cell263); row18.Append(cell264); row18.Append(cell265); row18.Append(cell266); row18.Append(cell267); row18.Append(cell268); row18.Append(cell269); row18.Append(cell270); row18.Append(cell271); row18.Append(cell272); row18.Append(cell273); row18.Append(cell274); row18.Append(cell275); row18.Append(cell276); row18.Append(cell277); row18.Append(cell278); row18.Append(cell279); row18.Append(cell280); row18.Append(cell281); row18.Append(cell282); row18.Append(cell283); row18.Append(cell284); row18.Append(cell285); row18.Append(cell286); row18.Append(cell287); row18.Append(cell288); row18.Append(cell289); Row row19 = new Row() { RowIndex = (UInt32Value)22U, Spans = new ListValue<StringValue>() { InnerText = "2:44" }, StyleIndex = (UInt32Value)3U, CustomFormat = true, Height = 13.5D, CustomHeight = true }; Cell cell290 = new Cell() { CellReference = "B22", StyleIndex = (UInt32Value)37U }; Cell cell291 = new Cell() { CellReference = "C22", StyleIndex = (UInt32Value)64U }; Cell cell292 = new Cell() { CellReference = "D22", StyleIndex = (UInt32Value)61U }; Cell cell293 = new Cell() { CellReference = "E22", StyleIndex = (UInt32Value)61U, DataType = CellValues.SharedString }; CellValue cellValue94 = new CellValue(); cellValue94.Text = "31"; cell293.Append(cellValue94); Cell cell294 = new Cell() { CellReference = "F22", StyleIndex = (UInt32Value)38U }; Cell cell295 = new Cell() { CellReference = "G22", StyleIndex = (UInt32Value)33U }; Cell cell296 = new Cell() { CellReference = "H22", StyleIndex = (UInt32Value)34U }; Cell cell297 = new Cell() { CellReference = "I22", StyleIndex = (UInt32Value)34U }; Cell cell298 = new Cell() { CellReference = "J22", StyleIndex = (UInt32Value)34U }; Cell cell299 = new Cell() { CellReference = "K22", StyleIndex = (UInt32Value)34U }; Cell cell300 = new Cell() { CellReference = "L22", StyleIndex = (UInt32Value)34U }; Cell cell301 = new Cell() { CellReference = "M22", StyleIndex = (UInt32Value)34U }; Cell cell302 = new Cell() { CellReference = "N22", StyleIndex = (UInt32Value)34U }; Cell cell303 = new Cell() { CellReference = "O22", StyleIndex = (UInt32Value)34U }; Cell cell304 = new Cell() { CellReference = "P22", StyleIndex = (UInt32Value)35U }; Cell cell305 = new Cell() { CellReference = "Q22", StyleIndex = (UInt32Value)34U }; Cell cell306 = new Cell() { CellReference = "R22", StyleIndex = (UInt32Value)34U }; Cell cell307 = new Cell() { CellReference = "S22", StyleIndex = (UInt32Value)34U }; Cell cell308 = new Cell() { CellReference = "T22", StyleIndex = (UInt32Value)34U }; Cell cell309 = new Cell() { CellReference = "U22", StyleIndex = (UInt32Value)34U }; Cell cell310 = new Cell() { CellReference = "V22", StyleIndex = (UInt32Value)35U }; Cell cell311 = new Cell() { CellReference = "W22", StyleIndex = (UInt32Value)34U }; Cell cell312 = new Cell() { CellReference = "X22", StyleIndex = (UInt32Value)34U }; Cell cell313 = new Cell() { CellReference = "Y22", StyleIndex = (UInt32Value)34U }; Cell cell314 = new Cell() { CellReference = "Z22", StyleIndex = (UInt32Value)34U }; Cell cell315 = new Cell() { CellReference = "AA22", StyleIndex = (UInt32Value)34U }; Cell cell316 = new Cell() { CellReference = "AB22", StyleIndex = (UInt32Value)35U }; Cell cell317 = new Cell() { CellReference = "AC22", StyleIndex = (UInt32Value)35U }; Cell cell318 = new Cell() { CellReference = "AD22", StyleIndex = (UInt32Value)35U }; CellValue cellValue95 = new CellValue(); cellValue95.Text = "0"; cell318.Append(cellValue95); Cell cell319 = new Cell() { CellReference = "AE22", StyleIndex = (UInt32Value)34U }; Cell cell320 = new Cell() { CellReference = "AF22", StyleIndex = (UInt32Value)34U }; Cell cell321 = new Cell() { CellReference = "AG22", StyleIndex = (UInt32Value)34U }; Cell cell322 = new Cell() { CellReference = "AH22", StyleIndex = (UInt32Value)34U }; Cell cell323 = new Cell() { CellReference = "AI22", StyleIndex = (UInt32Value)34U }; Cell cell324 = new Cell() { CellReference = "AJ22", StyleIndex = (UInt32Value)34U }; Cell cell325 = new Cell() { CellReference = "AK22", StyleIndex = (UInt32Value)34U }; Cell cell326 = new Cell() { CellReference = "AL22", StyleIndex = (UInt32Value)36U }; CellFormula cellFormula4 = new CellFormula(); cellFormula4.Text = "SUM(G22:AK22)"; CellValue cellValue96 = new CellValue(); cellValue96.Text = "0"; cell326.Append(cellFormula4); cell326.Append(cellValue96); Cell cell327 = new Cell() { CellReference = "AM22", StyleIndex = (UInt32Value)92U }; CellValue cellValue97 = new CellValue(); cellValue97.Text = "0"; cell327.Append(cellValue97); Cell cell328 = new Cell() { CellReference = "AN22", StyleIndex = (UInt32Value)89U }; CellFormula cellFormula5 = new CellFormula(); cellFormula5.Text = "SUM(AM22*AL22)"; CellValue cellValue98 = new CellValue(); cellValue98.Text = "0"; cell328.Append(cellFormula5); cell328.Append(cellValue98); Cell cell329 = new Cell() { CellReference = "AO22", StyleIndex = (UInt32Value)2U }; Cell cell330 = new Cell() { CellReference = "AP22", StyleIndex = (UInt32Value)2U }; Cell cell331 = new Cell() { CellReference = "AQ22", StyleIndex = (UInt32Value)2U }; Cell cell332 = new Cell() { CellReference = "AR22", StyleIndex = (UInt32Value)2U }; row19.Append(cell290); row19.Append(cell291); row19.Append(cell292); row19.Append(cell293); row19.Append(cell294); row19.Append(cell295); row19.Append(cell296); row19.Append(cell297); row19.Append(cell298); row19.Append(cell299); row19.Append(cell300); row19.Append(cell301); row19.Append(cell302); row19.Append(cell303); row19.Append(cell304); row19.Append(cell305); row19.Append(cell306); row19.Append(cell307); row19.Append(cell308); row19.Append(cell309); row19.Append(cell310); row19.Append(cell311); row19.Append(cell312); row19.Append(cell313); row19.Append(cell314); row19.Append(cell315); row19.Append(cell316); row19.Append(cell317); row19.Append(cell318); row19.Append(cell319); row19.Append(cell320); row19.Append(cell321); row19.Append(cell322); row19.Append(cell323); row19.Append(cell324); row19.Append(cell325); row19.Append(cell326); row19.Append(cell327); row19.Append(cell328); row19.Append(cell329); row19.Append(cell330); row19.Append(cell331); row19.Append(cell332); Row row20 = new Row() { RowIndex = (UInt32Value)23U, Spans = new ListValue<StringValue>() { InnerText = "2:44" }, StyleIndex = (UInt32Value)3U, CustomFormat = true, Height = 13.5D, CustomHeight = true }; Cell cell333 = new Cell() { CellReference = "B23", StyleIndex = (UInt32Value)37U }; Cell cell334 = new Cell() { CellReference = "C23", StyleIndex = (UInt32Value)64U }; Cell cell335 = new Cell() { CellReference = "D23", StyleIndex = (UInt32Value)61U }; Cell cell336 = new Cell() { CellReference = "E23", StyleIndex = (UInt32Value)61U, DataType = CellValues.SharedString }; CellValue cellValue99 = new CellValue(); cellValue99.Text = "31"; cell336.Append(cellValue99); Cell cell337 = new Cell() { CellReference = "F23", StyleIndex = (UInt32Value)38U }; Cell cell338 = new Cell() { CellReference = "G23", StyleIndex = (UInt32Value)40U }; Cell cell339 = new Cell() { CellReference = "H23", StyleIndex = (UInt32Value)35U }; Cell cell340 = new Cell() { CellReference = "I23", StyleIndex = (UInt32Value)35U }; Cell cell341 = new Cell() { CellReference = "J23", StyleIndex = (UInt32Value)34U }; Cell cell342 = new Cell() { CellReference = "K23", StyleIndex = (UInt32Value)34U }; Cell cell343 = new Cell() { CellReference = "L23", StyleIndex = (UInt32Value)35U }; Cell cell344 = new Cell() { CellReference = "M23", StyleIndex = (UInt32Value)35U }; Cell cell345 = new Cell() { CellReference = "N23", StyleIndex = (UInt32Value)34U }; Cell cell346 = new Cell() { CellReference = "O23", StyleIndex = (UInt32Value)34U }; Cell cell347 = new Cell() { CellReference = "P23", StyleIndex = (UInt32Value)34U }; Cell cell348 = new Cell() { CellReference = "Q23", StyleIndex = (UInt32Value)34U }; Cell cell349 = new Cell() { CellReference = "R23", StyleIndex = (UInt32Value)34U }; Cell cell350 = new Cell() { CellReference = "S23", StyleIndex = (UInt32Value)35U }; Cell cell351 = new Cell() { CellReference = "T23", StyleIndex = (UInt32Value)35U }; Cell cell352 = new Cell() { CellReference = "U23", StyleIndex = (UInt32Value)34U }; Cell cell353 = new Cell() { CellReference = "V23", StyleIndex = (UInt32Value)34U }; Cell cell354 = new Cell() { CellReference = "W23", StyleIndex = (UInt32Value)35U }; Cell cell355 = new Cell() { CellReference = "X23", StyleIndex = (UInt32Value)34U }; Cell cell356 = new Cell() { CellReference = "Y23", StyleIndex = (UInt32Value)34U }; Cell cell357 = new Cell() { CellReference = "Z23", StyleIndex = (UInt32Value)35U }; Cell cell358 = new Cell() { CellReference = "AA23", StyleIndex = (UInt32Value)35U }; Cell cell359 = new Cell() { CellReference = "AB23", StyleIndex = (UInt32Value)35U }; Cell cell360 = new Cell() { CellReference = "AC23", StyleIndex = (UInt32Value)35U }; CellValue cellValue100 = new CellValue(); cellValue100.Text = "0"; cell360.Append(cellValue100); Cell cell361 = new Cell() { CellReference = "AD23", StyleIndex = (UInt32Value)35U }; Cell cell362 = new Cell() { CellReference = "AE23", StyleIndex = (UInt32Value)34U }; Cell cell363 = new Cell() { CellReference = "AF23", StyleIndex = (UInt32Value)34U }; Cell cell364 = new Cell() { CellReference = "AG23", StyleIndex = (UInt32Value)35U }; Cell cell365 = new Cell() { CellReference = "AH23", StyleIndex = (UInt32Value)35U }; Cell cell366 = new Cell() { CellReference = "AI23", StyleIndex = (UInt32Value)35U }; Cell cell367 = new Cell() { CellReference = "AJ23", StyleIndex = (UInt32Value)35U }; Cell cell368 = new Cell() { CellReference = "AK23", StyleIndex = (UInt32Value)35U }; Cell cell369 = new Cell() { CellReference = "AL23", StyleIndex = (UInt32Value)36U }; CellFormula cellFormula6 = new CellFormula(); cellFormula6.Text = "SUM(G23:AK23)"; CellValue cellValue101 = new CellValue(); cellValue101.Text = "0"; cell369.Append(cellFormula6); cell369.Append(cellValue101); Cell cell370 = new Cell() { CellReference = "AM23", StyleIndex = (UInt32Value)92U }; CellValue cellValue102 = new CellValue(); cellValue102.Text = "0"; cell370.Append(cellValue102); Cell cell371 = new Cell() { CellReference = "AN23", StyleIndex = (UInt32Value)89U }; CellFormula cellFormula7 = new CellFormula(); cellFormula7.Text = "SUM(AM23*AL23)"; CellValue cellValue103 = new CellValue(); cellValue103.Text = "0"; cell371.Append(cellFormula7); cell371.Append(cellValue103); Cell cell372 = new Cell() { CellReference = "AO23", StyleIndex = (UInt32Value)2U }; Cell cell373 = new Cell() { CellReference = "AP23", StyleIndex = (UInt32Value)2U }; Cell cell374 = new Cell() { CellReference = "AQ23", StyleIndex = (UInt32Value)2U }; Cell cell375 = new Cell() { CellReference = "AR23", StyleIndex = (UInt32Value)2U }; row20.Append(cell333); row20.Append(cell334); row20.Append(cell335); row20.Append(cell336); row20.Append(cell337); row20.Append(cell338); row20.Append(cell339); row20.Append(cell340); row20.Append(cell341); row20.Append(cell342); row20.Append(cell343); row20.Append(cell344); row20.Append(cell345); row20.Append(cell346); row20.Append(cell347); row20.Append(cell348); row20.Append(cell349); row20.Append(cell350); row20.Append(cell351); row20.Append(cell352); row20.Append(cell353); row20.Append(cell354); row20.Append(cell355); row20.Append(cell356); row20.Append(cell357); row20.Append(cell358); row20.Append(cell359); row20.Append(cell360); row20.Append(cell361); row20.Append(cell362); row20.Append(cell363); row20.Append(cell364); row20.Append(cell365); row20.Append(cell366); row20.Append(cell367); row20.Append(cell368); row20.Append(cell369); row20.Append(cell370); row20.Append(cell371); row20.Append(cell372); row20.Append(cell373); row20.Append(cell374); row20.Append(cell375); Row row21 = new Row() { RowIndex = (UInt32Value)24U, Spans = new ListValue<StringValue>() { InnerText = "2:44" }, StyleIndex = (UInt32Value)3U, CustomFormat = true, Height = 13.5D, CustomHeight = true }; Cell cell376 = new Cell() { CellReference = "B24", StyleIndex = (UInt32Value)41U }; Cell cell377 = new Cell() { CellReference = "C24", StyleIndex = (UInt32Value)64U }; Cell cell378 = new Cell() { CellReference = "D24", StyleIndex = (UInt32Value)61U }; Cell cell379 = new Cell() { CellReference = "E24", StyleIndex = (UInt32Value)61U, DataType = CellValues.SharedString }; CellValue cellValue104 = new CellValue(); cellValue104.Text = "31"; cell379.Append(cellValue104); Cell cell380 = new Cell() { CellReference = "F24", StyleIndex = (UInt32Value)38U }; Cell cell381 = new Cell() { CellReference = "G24", StyleIndex = (UInt32Value)33U }; Cell cell382 = new Cell() { CellReference = "H24", StyleIndex = (UInt32Value)34U }; Cell cell383 = new Cell() { CellReference = "I24", StyleIndex = (UInt32Value)34U }; Cell cell384 = new Cell() { CellReference = "J24", StyleIndex = (UInt32Value)34U }; Cell cell385 = new Cell() { CellReference = "K24", StyleIndex = (UInt32Value)34U }; Cell cell386 = new Cell() { CellReference = "L24", StyleIndex = (UInt32Value)34U }; Cell cell387 = new Cell() { CellReference = "M24", StyleIndex = (UInt32Value)34U }; Cell cell388 = new Cell() { CellReference = "N24", StyleIndex = (UInt32Value)34U }; Cell cell389 = new Cell() { CellReference = "O24", StyleIndex = (UInt32Value)35U }; Cell cell390 = new Cell() { CellReference = "P24", StyleIndex = (UInt32Value)34U }; Cell cell391 = new Cell() { CellReference = "Q24", StyleIndex = (UInt32Value)34U }; Cell cell392 = new Cell() { CellReference = "R24", StyleIndex = (UInt32Value)34U }; Cell cell393 = new Cell() { CellReference = "S24", StyleIndex = (UInt32Value)34U }; Cell cell394 = new Cell() { CellReference = "T24", StyleIndex = (UInt32Value)34U }; Cell cell395 = new Cell() { CellReference = "U24", StyleIndex = (UInt32Value)35U }; Cell cell396 = new Cell() { CellReference = "V24", StyleIndex = (UInt32Value)35U }; Cell cell397 = new Cell() { CellReference = "W24", StyleIndex = (UInt32Value)35U }; Cell cell398 = new Cell() { CellReference = "X24", StyleIndex = (UInt32Value)34U }; Cell cell399 = new Cell() { CellReference = "Y24", StyleIndex = (UInt32Value)34U }; Cell cell400 = new Cell() { CellReference = "Z24", StyleIndex = (UInt32Value)34U }; Cell cell401 = new Cell() { CellReference = "AA24", StyleIndex = (UInt32Value)35U }; Cell cell402 = new Cell() { CellReference = "AB24", StyleIndex = (UInt32Value)35U }; Cell cell403 = new Cell() { CellReference = "AC24", StyleIndex = (UInt32Value)35U }; Cell cell404 = new Cell() { CellReference = "AD24", StyleIndex = (UInt32Value)35U }; Cell cell405 = new Cell() { CellReference = "AE24", StyleIndex = (UInt32Value)34U }; Cell cell406 = new Cell() { CellReference = "AF24", StyleIndex = (UInt32Value)34U }; Cell cell407 = new Cell() { CellReference = "AG24", StyleIndex = (UInt32Value)34U }; Cell cell408 = new Cell() { CellReference = "AH24", StyleIndex = (UInt32Value)34U }; Cell cell409 = new Cell() { CellReference = "AI24", StyleIndex = (UInt32Value)34U }; Cell cell410 = new Cell() { CellReference = "AJ24", StyleIndex = (UInt32Value)34U }; Cell cell411 = new Cell() { CellReference = "AK24", StyleIndex = (UInt32Value)34U }; Cell cell412 = new Cell() { CellReference = "AL24", StyleIndex = (UInt32Value)36U }; CellFormula cellFormula8 = new CellFormula(); cellFormula8.Text = "SUM(G24:AK24)"; CellValue cellValue105 = new CellValue(); cellValue105.Text = "0"; cell412.Append(cellFormula8); cell412.Append(cellValue105); Cell cell413 = new Cell() { CellReference = "AM24", StyleIndex = (UInt32Value)92U }; CellValue cellValue106 = new CellValue(); cellValue106.Text = "0"; cell413.Append(cellValue106); Cell cell414 = new Cell() { CellReference = "AN24", StyleIndex = (UInt32Value)89U }; CellFormula cellFormula9 = new CellFormula(); cellFormula9.Text = "SUM(AM24*AL24)"; CellValue cellValue107 = new CellValue(); cellValue107.Text = "0"; cell414.Append(cellFormula9); cell414.Append(cellValue107); Cell cell415 = new Cell() { CellReference = "AO24", StyleIndex = (UInt32Value)2U }; Cell cell416 = new Cell() { CellReference = "AP24", StyleIndex = (UInt32Value)2U }; Cell cell417 = new Cell() { CellReference = "AQ24", StyleIndex = (UInt32Value)2U }; Cell cell418 = new Cell() { CellReference = "AR24", StyleIndex = (UInt32Value)2U }; row21.Append(cell376); row21.Append(cell377); row21.Append(cell378); row21.Append(cell379); row21.Append(cell380); row21.Append(cell381); row21.Append(cell382); row21.Append(cell383); row21.Append(cell384); row21.Append(cell385); row21.Append(cell386); row21.Append(cell387); row21.Append(cell388); row21.Append(cell389); row21.Append(cell390); row21.Append(cell391); row21.Append(cell392); row21.Append(cell393); row21.Append(cell394); row21.Append(cell395); row21.Append(cell396); row21.Append(cell397); row21.Append(cell398); row21.Append(cell399); row21.Append(cell400); row21.Append(cell401); row21.Append(cell402); row21.Append(cell403); row21.Append(cell404); row21.Append(cell405); row21.Append(cell406); row21.Append(cell407); row21.Append(cell408); row21.Append(cell409); row21.Append(cell410); row21.Append(cell411); row21.Append(cell412); row21.Append(cell413); row21.Append(cell414); row21.Append(cell415); row21.Append(cell416); row21.Append(cell417); row21.Append(cell418); Row row22 = new Row() { RowIndex = (UInt32Value)25U, Spans = new ListValue<StringValue>() { InnerText = "2:44" }, StyleIndex = (UInt32Value)3U, CustomFormat = true, Height = 13.5D, CustomHeight = true, ThickBot = true }; Cell cell419 = new Cell() { CellReference = "B25", StyleIndex = (UInt32Value)41U }; Cell cell420 = new Cell() { CellReference = "C25", StyleIndex = (UInt32Value)65U }; Cell cell421 = new Cell() { CellReference = "D25", StyleIndex = (UInt32Value)66U }; Cell cell422 = new Cell() { CellReference = "E25", StyleIndex = (UInt32Value)66U, DataType = CellValues.SharedString }; CellValue cellValue108 = new CellValue(); cellValue108.Text = "31"; cell422.Append(cellValue108); Cell cell423 = new Cell() { CellReference = "F25", StyleIndex = (UInt32Value)39U }; Cell cell424 = new Cell() { CellReference = "G25", StyleIndex = (UInt32Value)67U }; Cell cell425 = new Cell() { CellReference = "H25", StyleIndex = (UInt32Value)68U }; Cell cell426 = new Cell() { CellReference = "I25", StyleIndex = (UInt32Value)68U }; Cell cell427 = new Cell() { CellReference = "J25", StyleIndex = (UInt32Value)68U }; Cell cell428 = new Cell() { CellReference = "K25", StyleIndex = (UInt32Value)68U }; Cell cell429 = new Cell() { CellReference = "L25", StyleIndex = (UInt32Value)68U }; Cell cell430 = new Cell() { CellReference = "M25", StyleIndex = (UInt32Value)68U }; Cell cell431 = new Cell() { CellReference = "N25", StyleIndex = (UInt32Value)68U }; Cell cell432 = new Cell() { CellReference = "O25", StyleIndex = (UInt32Value)68U }; Cell cell433 = new Cell() { CellReference = "P25", StyleIndex = (UInt32Value)68U }; Cell cell434 = new Cell() { CellReference = "Q25", StyleIndex = (UInt32Value)68U }; Cell cell435 = new Cell() { CellReference = "R25", StyleIndex = (UInt32Value)68U }; Cell cell436 = new Cell() { CellReference = "S25", StyleIndex = (UInt32Value)68U }; Cell cell437 = new Cell() { CellReference = "T25", StyleIndex = (UInt32Value)68U }; Cell cell438 = new Cell() { CellReference = "U25", StyleIndex = (UInt32Value)68U }; Cell cell439 = new Cell() { CellReference = "V25", StyleIndex = (UInt32Value)68U }; Cell cell440 = new Cell() { CellReference = "W25", StyleIndex = (UInt32Value)68U }; Cell cell441 = new Cell() { CellReference = "X25", StyleIndex = (UInt32Value)68U }; Cell cell442 = new Cell() { CellReference = "Y25", StyleIndex = (UInt32Value)68U }; Cell cell443 = new Cell() { CellReference = "Z25", StyleIndex = (UInt32Value)68U }; Cell cell444 = new Cell() { CellReference = "AA25", StyleIndex = (UInt32Value)69U }; Cell cell445 = new Cell() { CellReference = "AB25", StyleIndex = (UInt32Value)69U }; Cell cell446 = new Cell() { CellReference = "AC25", StyleIndex = (UInt32Value)69U }; Cell cell447 = new Cell() { CellReference = "AD25", StyleIndex = (UInt32Value)69U }; Cell cell448 = new Cell() { CellReference = "AE25", StyleIndex = (UInt32Value)68U }; Cell cell449 = new Cell() { CellReference = "AF25", StyleIndex = (UInt32Value)68U }; CellValue cellValue109 = new CellValue(); cellValue109.Text = "0"; cell449.Append(cellValue109); Cell cell450 = new Cell() { CellReference = "AG25", StyleIndex = (UInt32Value)68U }; Cell cell451 = new Cell() { CellReference = "AH25", StyleIndex = (UInt32Value)68U }; Cell cell452 = new Cell() { CellReference = "AI25", StyleIndex = (UInt32Value)68U }; Cell cell453 = new Cell() { CellReference = "AJ25", StyleIndex = (UInt32Value)68U }; Cell cell454 = new Cell() { CellReference = "AK25", StyleIndex = (UInt32Value)68U }; Cell cell455 = new Cell() { CellReference = "AL25", StyleIndex = (UInt32Value)70U }; CellFormula cellFormula10 = new CellFormula(); cellFormula10.Text = "SUM(G25:AK25)"; CellValue cellValue110 = new CellValue(); cellValue110.Text = "0"; cell455.Append(cellFormula10); cell455.Append(cellValue110); Cell cell456 = new Cell() { CellReference = "AM25", StyleIndex = (UInt32Value)93U }; CellValue cellValue111 = new CellValue(); cellValue111.Text = "0"; cell456.Append(cellValue111); Cell cell457 = new Cell() { CellReference = "AN25", StyleIndex = (UInt32Value)90U }; CellFormula cellFormula11 = new CellFormula(); cellFormula11.Text = "SUM(AM25*AL25)"; CellValue cellValue112 = new CellValue(); cellValue112.Text = "0"; cell457.Append(cellFormula11); cell457.Append(cellValue112); Cell cell458 = new Cell() { CellReference = "AO25", StyleIndex = (UInt32Value)2U }; Cell cell459 = new Cell() { CellReference = "AP25", StyleIndex = (UInt32Value)2U }; Cell cell460 = new Cell() { CellReference = "AQ25", StyleIndex = (UInt32Value)2U }; Cell cell461 = new Cell() { CellReference = "AR25", StyleIndex = (UInt32Value)2U }; row22.Append(cell419); row22.Append(cell420); row22.Append(cell421); row22.Append(cell422); row22.Append(cell423); row22.Append(cell424); row22.Append(cell425); row22.Append(cell426); row22.Append(cell427); row22.Append(cell428); row22.Append(cell429); row22.Append(cell430); row22.Append(cell431); row22.Append(cell432); row22.Append(cell433); row22.Append(cell434); row22.Append(cell435); row22.Append(cell436); row22.Append(cell437); row22.Append(cell438); row22.Append(cell439); row22.Append(cell440); row22.Append(cell441); row22.Append(cell442); row22.Append(cell443); row22.Append(cell444); row22.Append(cell445); row22.Append(cell446); row22.Append(cell447); row22.Append(cell448); row22.Append(cell449); row22.Append(cell450); row22.Append(cell451); row22.Append(cell452); row22.Append(cell453); row22.Append(cell454); row22.Append(cell455); row22.Append(cell456); row22.Append(cell457); row22.Append(cell458); row22.Append(cell459); row22.Append(cell460); row22.Append(cell461); Row row23 = new Row() { RowIndex = (UInt32Value)26U, Spans = new ListValue<StringValue>() { InnerText = "2:44" }, StyleIndex = (UInt32Value)3U, CustomFormat = true, Height = 13.5D, CustomHeight = true, ThickBot = true }; Cell cell462 = new Cell() { CellReference = "B26", StyleIndex = (UInt32Value)17U, DataType = CellValues.SharedString }; CellValue cellValue113 = new CellValue(); cellValue113.Text = "25"; cell462.Append(cellValue113); Cell cell463 = new Cell() { CellReference = "C26", StyleIndex = (UInt32Value)42U }; Cell cell464 = new Cell() { CellReference = "D26", StyleIndex = (UInt32Value)43U }; Cell cell465 = new Cell() { CellReference = "E26", StyleIndex = (UInt32Value)62U }; Cell cell466 = new Cell() { CellReference = "F26", StyleIndex = (UInt32Value)63U }; Cell cell467 = new Cell() { CellReference = "G26", StyleIndex = (UInt32Value)71U }; CellFormula cellFormula12 = new CellFormula() { FormulaType = CellFormulaValues.Shared, Reference = "G26:AK26", SharedIndex = (UInt32Value)0U }; cellFormula12.Text = "SUM(G21:G25)"; CellValue cellValue114 = new CellValue(); cellValue114.Text = "0"; cell467.Append(cellFormula12); cell467.Append(cellValue114); Cell cell468 = new Cell() { CellReference = "H26", StyleIndex = (UInt32Value)72U }; CellFormula cellFormula13 = new CellFormula() { FormulaType = CellFormulaValues.Shared, SharedIndex = (UInt32Value)0U }; cellFormula13.Text = ""; CellValue cellValue115 = new CellValue(); cellValue115.Text = "0"; cell468.Append(cellFormula13); cell468.Append(cellValue115); Cell cell469 = new Cell() { CellReference = "I26", StyleIndex = (UInt32Value)72U }; CellFormula cellFormula14 = new CellFormula() { FormulaType = CellFormulaValues.Shared, SharedIndex = (UInt32Value)0U }; cellFormula14.Text = ""; CellValue cellValue116 = new CellValue(); cellValue116.Text = "0"; cell469.Append(cellFormula14); cell469.Append(cellValue116); Cell cell470 = new Cell() { CellReference = "J26", StyleIndex = (UInt32Value)72U }; CellFormula cellFormula15 = new CellFormula() { FormulaType = CellFormulaValues.Shared, SharedIndex = (UInt32Value)0U }; cellFormula15.Text = ""; CellValue cellValue117 = new CellValue(); cellValue117.Text = "0"; cell470.Append(cellFormula15); cell470.Append(cellValue117); Cell cell471 = new Cell() { CellReference = "K26", StyleIndex = (UInt32Value)72U }; CellFormula cellFormula16 = new CellFormula() { FormulaType = CellFormulaValues.Shared, SharedIndex = (UInt32Value)0U }; cellFormula16.Text = ""; CellValue cellValue118 = new CellValue(); cellValue118.Text = "0"; cell471.Append(cellFormula16); cell471.Append(cellValue118); Cell cell472 = new Cell() { CellReference = "L26", StyleIndex = (UInt32Value)72U }; CellFormula cellFormula17 = new CellFormula() { FormulaType = CellFormulaValues.Shared, SharedIndex = (UInt32Value)0U }; cellFormula17.Text = ""; CellValue cellValue119 = new CellValue(); cellValue119.Text = "0"; cell472.Append(cellFormula17); cell472.Append(cellValue119); Cell cell473 = new Cell() { CellReference = "M26", StyleIndex = (UInt32Value)72U }; CellFormula cellFormula18 = new CellFormula() { FormulaType = CellFormulaValues.Shared, SharedIndex = (UInt32Value)0U }; cellFormula18.Text = ""; CellValue cellValue120 = new CellValue(); cellValue120.Text = "0"; cell473.Append(cellFormula18); cell473.Append(cellValue120); Cell cell474 = new Cell() { CellReference = "N26", StyleIndex = (UInt32Value)72U }; CellFormula cellFormula19 = new CellFormula() { FormulaType = CellFormulaValues.Shared, SharedIndex = (UInt32Value)0U }; cellFormula19.Text = ""; CellValue cellValue121 = new CellValue(); cellValue121.Text = "0"; cell474.Append(cellFormula19); cell474.Append(cellValue121); Cell cell475 = new Cell() { CellReference = "O26", StyleIndex = (UInt32Value)72U }; CellFormula cellFormula20 = new CellFormula() { FormulaType = CellFormulaValues.Shared, SharedIndex = (UInt32Value)0U }; cellFormula20.Text = ""; CellValue cellValue122 = new CellValue(); cellValue122.Text = "0"; cell475.Append(cellFormula20); cell475.Append(cellValue122); Cell cell476 = new Cell() { CellReference = "P26", StyleIndex = (UInt32Value)72U }; CellFormula cellFormula21 = new CellFormula() { FormulaType = CellFormulaValues.Shared, SharedIndex = (UInt32Value)0U }; cellFormula21.Text = ""; CellValue cellValue123 = new CellValue(); cellValue123.Text = "0"; cell476.Append(cellFormula21); cell476.Append(cellValue123); Cell cell477 = new Cell() { CellReference = "Q26", StyleIndex = (UInt32Value)72U }; CellFormula cellFormula22 = new CellFormula() { FormulaType = CellFormulaValues.Shared, SharedIndex = (UInt32Value)0U }; cellFormula22.Text = ""; CellValue cellValue124 = new CellValue(); cellValue124.Text = "0"; cell477.Append(cellFormula22); cell477.Append(cellValue124); Cell cell478 = new Cell() { CellReference = "R26", StyleIndex = (UInt32Value)72U }; CellFormula cellFormula23 = new CellFormula() { FormulaType = CellFormulaValues.Shared, SharedIndex = (UInt32Value)0U }; cellFormula23.Text = ""; CellValue cellValue125 = new CellValue(); cellValue125.Text = "0"; cell478.Append(cellFormula23); cell478.Append(cellValue125); Cell cell479 = new Cell() { CellReference = "S26", StyleIndex = (UInt32Value)72U }; CellFormula cellFormula24 = new CellFormula() { FormulaType = CellFormulaValues.Shared, SharedIndex = (UInt32Value)0U }; cellFormula24.Text = ""; CellValue cellValue126 = new CellValue(); cellValue126.Text = "0"; cell479.Append(cellFormula24); cell479.Append(cellValue126); Cell cell480 = new Cell() { CellReference = "T26", StyleIndex = (UInt32Value)72U }; CellFormula cellFormula25 = new CellFormula() { FormulaType = CellFormulaValues.Shared, SharedIndex = (UInt32Value)0U }; cellFormula25.Text = ""; CellValue cellValue127 = new CellValue(); cellValue127.Text = "0"; cell480.Append(cellFormula25); cell480.Append(cellValue127); Cell cell481 = new Cell() { CellReference = "U26", StyleIndex = (UInt32Value)72U }; CellFormula cellFormula26 = new CellFormula() { FormulaType = CellFormulaValues.Shared, SharedIndex = (UInt32Value)0U }; cellFormula26.Text = ""; CellValue cellValue128 = new CellValue(); cellValue128.Text = "0"; cell481.Append(cellFormula26); cell481.Append(cellValue128); Cell cell482 = new Cell() { CellReference = "V26", StyleIndex = (UInt32Value)72U }; CellFormula cellFormula27 = new CellFormula() { FormulaType = CellFormulaValues.Shared, SharedIndex = (UInt32Value)0U }; cellFormula27.Text = ""; CellValue cellValue129 = new CellValue(); cellValue129.Text = "0"; cell482.Append(cellFormula27); cell482.Append(cellValue129); Cell cell483 = new Cell() { CellReference = "W26", StyleIndex = (UInt32Value)72U }; CellFormula cellFormula28 = new CellFormula() { FormulaType = CellFormulaValues.Shared, SharedIndex = (UInt32Value)0U }; cellFormula28.Text = ""; CellValue cellValue130 = new CellValue(); cellValue130.Text = "0"; cell483.Append(cellFormula28); cell483.Append(cellValue130); Cell cell484 = new Cell() { CellReference = "X26", StyleIndex = (UInt32Value)72U }; CellFormula cellFormula29 = new CellFormula() { FormulaType = CellFormulaValues.Shared, SharedIndex = (UInt32Value)0U }; cellFormula29.Text = ""; CellValue cellValue131 = new CellValue(); cellValue131.Text = "0"; cell484.Append(cellFormula29); cell484.Append(cellValue131); Cell cell485 = new Cell() { CellReference = "Y26", StyleIndex = (UInt32Value)72U }; CellFormula cellFormula30 = new CellFormula() { FormulaType = CellFormulaValues.Shared, SharedIndex = (UInt32Value)0U }; cellFormula30.Text = ""; CellValue cellValue132 = new CellValue(); cellValue132.Text = "0"; cell485.Append(cellFormula30); cell485.Append(cellValue132); Cell cell486 = new Cell() { CellReference = "Z26", StyleIndex = (UInt32Value)72U }; CellFormula cellFormula31 = new CellFormula() { FormulaType = CellFormulaValues.Shared, SharedIndex = (UInt32Value)0U }; cellFormula31.Text = ""; CellValue cellValue133 = new CellValue(); cellValue133.Text = "0"; cell486.Append(cellFormula31); cell486.Append(cellValue133); Cell cell487 = new Cell() { CellReference = "AA26", StyleIndex = (UInt32Value)72U }; CellFormula cellFormula32 = new CellFormula() { FormulaType = CellFormulaValues.Shared, SharedIndex = (UInt32Value)0U }; cellFormula32.Text = ""; CellValue cellValue134 = new CellValue(); cellValue134.Text = "0"; cell487.Append(cellFormula32); cell487.Append(cellValue134); Cell cell488 = new Cell() { CellReference = "AB26", StyleIndex = (UInt32Value)72U }; CellFormula cellFormula33 = new CellFormula() { FormulaType = CellFormulaValues.Shared, SharedIndex = (UInt32Value)0U }; cellFormula33.Text = ""; CellValue cellValue135 = new CellValue(); cellValue135.Text = "0"; cell488.Append(cellFormula33); cell488.Append(cellValue135); Cell cell489 = new Cell() { CellReference = "AC26", StyleIndex = (UInt32Value)72U }; CellFormula cellFormula34 = new CellFormula() { FormulaType = CellFormulaValues.Shared, SharedIndex = (UInt32Value)0U }; cellFormula34.Text = ""; CellValue cellValue136 = new CellValue(); cellValue136.Text = "0"; cell489.Append(cellFormula34); cell489.Append(cellValue136); Cell cell490 = new Cell() { CellReference = "AD26", StyleIndex = (UInt32Value)72U }; CellFormula cellFormula35 = new CellFormula() { FormulaType = CellFormulaValues.Shared, SharedIndex = (UInt32Value)0U }; cellFormula35.Text = ""; CellValue cellValue137 = new CellValue(); cellValue137.Text = "0"; cell490.Append(cellFormula35); cell490.Append(cellValue137); Cell cell491 = new Cell() { CellReference = "AE26", StyleIndex = (UInt32Value)72U }; CellFormula cellFormula36 = new CellFormula() { FormulaType = CellFormulaValues.Shared, SharedIndex = (UInt32Value)0U }; cellFormula36.Text = ""; CellValue cellValue138 = new CellValue(); cellValue138.Text = "0"; cell491.Append(cellFormula36); cell491.Append(cellValue138); Cell cell492 = new Cell() { CellReference = "AF26", StyleIndex = (UInt32Value)72U }; CellFormula cellFormula37 = new CellFormula() { FormulaType = CellFormulaValues.Shared, SharedIndex = (UInt32Value)0U }; cellFormula37.Text = ""; CellValue cellValue139 = new CellValue(); cellValue139.Text = "0"; cell492.Append(cellFormula37); cell492.Append(cellValue139); Cell cell493 = new Cell() { CellReference = "AG26", StyleIndex = (UInt32Value)72U }; CellFormula cellFormula38 = new CellFormula() { FormulaType = CellFormulaValues.Shared, SharedIndex = (UInt32Value)0U }; cellFormula38.Text = ""; CellValue cellValue140 = new CellValue(); cellValue140.Text = "0"; cell493.Append(cellFormula38); cell493.Append(cellValue140); Cell cell494 = new Cell() { CellReference = "AH26", StyleIndex = (UInt32Value)72U }; CellFormula cellFormula39 = new CellFormula() { FormulaType = CellFormulaValues.Shared, SharedIndex = (UInt32Value)0U }; cellFormula39.Text = ""; CellValue cellValue141 = new CellValue(); cellValue141.Text = "0"; cell494.Append(cellFormula39); cell494.Append(cellValue141); Cell cell495 = new Cell() { CellReference = "AI26", StyleIndex = (UInt32Value)72U }; CellFormula cellFormula40 = new CellFormula() { FormulaType = CellFormulaValues.Shared, SharedIndex = (UInt32Value)0U }; cellFormula40.Text = ""; CellValue cellValue142 = new CellValue(); cellValue142.Text = "0"; cell495.Append(cellFormula40); cell495.Append(cellValue142); Cell cell496 = new Cell() { CellReference = "AJ26", StyleIndex = (UInt32Value)72U }; CellFormula cellFormula41 = new CellFormula() { FormulaType = CellFormulaValues.Shared, SharedIndex = (UInt32Value)0U }; cellFormula41.Text = ""; CellValue cellValue143 = new CellValue(); cellValue143.Text = "0"; cell496.Append(cellFormula41); cell496.Append(cellValue143); Cell cell497 = new Cell() { CellReference = "AK26", StyleIndex = (UInt32Value)72U }; CellFormula cellFormula42 = new CellFormula() { FormulaType = CellFormulaValues.Shared, SharedIndex = (UInt32Value)0U }; cellFormula42.Text = ""; CellValue cellValue144 = new CellValue(); cellValue144.Text = "0"; cell497.Append(cellFormula42); cell497.Append(cellValue144); Cell cell498 = new Cell() { CellReference = "AL26", StyleIndex = (UInt32Value)72U }; CellFormula cellFormula43 = new CellFormula(); cellFormula43.Text = "SUM(AL21:AL25)"; CellValue cellValue145 = new CellValue(); cellValue145.Text = "0"; cell498.Append(cellFormula43); cell498.Append(cellValue145); Cell cell499 = new Cell() { CellReference = "AM26", StyleIndex = (UInt32Value)94U }; CellFormula cellFormula44 = new CellFormula(); cellFormula44.Text = "SUM(AM21:AM25)"; CellValue cellValue146 = new CellValue(); cellValue146.Text = "0"; cell499.Append(cellFormula44); cell499.Append(cellValue146); Cell cell500 = new Cell() { CellReference = "AN26", StyleIndex = (UInt32Value)91U }; CellFormula cellFormula45 = new CellFormula(); cellFormula45.Text = "SUM(AN21:AN25)"; CellValue cellValue147 = new CellValue(); cellValue147.Text = "0"; cell500.Append(cellFormula45); cell500.Append(cellValue147); Cell cell501 = new Cell() { CellReference = "AO26", StyleIndex = (UInt32Value)2U }; Cell cell502 = new Cell() { CellReference = "AP26", StyleIndex = (UInt32Value)2U }; Cell cell503 = new Cell() { CellReference = "AQ26", StyleIndex = (UInt32Value)2U }; Cell cell504 = new Cell() { CellReference = "AR26", StyleIndex = (UInt32Value)2U }; row23.Append(cell462); row23.Append(cell463); row23.Append(cell464); row23.Append(cell465); row23.Append(cell466); row23.Append(cell467); row23.Append(cell468); row23.Append(cell469); row23.Append(cell470); row23.Append(cell471); row23.Append(cell472); row23.Append(cell473); row23.Append(cell474); row23.Append(cell475); row23.Append(cell476); row23.Append(cell477); row23.Append(cell478); row23.Append(cell479); row23.Append(cell480); row23.Append(cell481); row23.Append(cell482); row23.Append(cell483); row23.Append(cell484); row23.Append(cell485); row23.Append(cell486); row23.Append(cell487); row23.Append(cell488); row23.Append(cell489); row23.Append(cell490); row23.Append(cell491); row23.Append(cell492); row23.Append(cell493); row23.Append(cell494); row23.Append(cell495); row23.Append(cell496); row23.Append(cell497); row23.Append(cell498); row23.Append(cell499); row23.Append(cell500); row23.Append(cell501); row23.Append(cell502); row23.Append(cell503); row23.Append(cell504); Row row24 = new Row() { RowIndex = (UInt32Value)27U, Spans = new ListValue<StringValue>() { InnerText = "2:44" } }; Cell cell505 = new Cell() { CellReference = "B27", StyleIndex = (UInt32Value)12U }; Cell cell506 = new Cell() { CellReference = "C27", StyleIndex = (UInt32Value)12U }; Cell cell507 = new Cell() { CellReference = "D27", StyleIndex = (UInt32Value)12U }; Cell cell508 = new Cell() { CellReference = "E27", StyleIndex = (UInt32Value)12U }; Cell cell509 = new Cell() { CellReference = "AL27", StyleIndex = (UInt32Value)4U }; Cell cell510 = new Cell() { CellReference = "AM27", StyleIndex = (UInt32Value)4U }; Cell cell511 = new Cell() { CellReference = "AN27", StyleIndex = (UInt32Value)4U }; Cell cell512 = new Cell() { CellReference = "AO27", StyleIndex = (UInt32Value)2U }; Cell cell513 = new Cell() { CellReference = "AP27", StyleIndex = (UInt32Value)2U }; Cell cell514 = new Cell() { CellReference = "AQ27", StyleIndex = (UInt32Value)2U }; Cell cell515 = new Cell() { CellReference = "AR27", StyleIndex = (UInt32Value)2U }; row24.Append(cell505); row24.Append(cell506); row24.Append(cell507); row24.Append(cell508); row24.Append(cell509); row24.Append(cell510); row24.Append(cell511); row24.Append(cell512); row24.Append(cell513); row24.Append(cell514); row24.Append(cell515); Row row25 = new Row() { RowIndex = (UInt32Value)28U, Spans = new ListValue<StringValue>() { InnerText = "2:44" } }; Cell cell516 = new Cell() { CellReference = "B28", StyleIndex = (UInt32Value)12U }; Cell cell517 = new Cell() { CellReference = "C28", StyleIndex = (UInt32Value)12U }; Cell cell518 = new Cell() { CellReference = "D28", StyleIndex = (UInt32Value)12U }; Cell cell519 = new Cell() { CellReference = "E28", StyleIndex = (UInt32Value)12U }; Cell cell520 = new Cell() { CellReference = "AO28", StyleIndex = (UInt32Value)2U }; Cell cell521 = new Cell() { CellReference = "AP28", StyleIndex = (UInt32Value)2U }; Cell cell522 = new Cell() { CellReference = "AQ28", StyleIndex = (UInt32Value)2U }; Cell cell523 = new Cell() { CellReference = "AR28", StyleIndex = (UInt32Value)2U }; row25.Append(cell516); row25.Append(cell517); row25.Append(cell518); row25.Append(cell519); row25.Append(cell520); row25.Append(cell521); row25.Append(cell522); row25.Append(cell523); Row row26 = new Row() { RowIndex = (UInt32Value)29U, Spans = new ListValue<StringValue>() { InnerText = "2:44" }, StyleIndex = (UInt32Value)3U, CustomFormat = true, Height = 15.75D, CustomHeight = true }; Cell cell524 = new Cell() { CellReference = "C29", StyleIndex = (UInt32Value)45U, DataType = CellValues.SharedString }; CellValue cellValue148 = new CellValue(); cellValue148.Text = "14"; cell524.Append(cellValue148); Cell cell525 = new Cell() { CellReference = "D29", StyleIndex = (UInt32Value)46U, DataType = CellValues.SharedString }; CellValue cellValue149 = new CellValue(); cellValue149.Text = "32"; cell525.Append(cellValue149); Cell cell526 = new Cell() { CellReference = "E29", StyleIndex = (UInt32Value)2U }; Cell cell527 = new Cell() { CellReference = "F29", StyleIndex = (UInt32Value)2U }; Cell cell528 = new Cell() { CellReference = "G29", StyleIndex = (UInt32Value)2U }; Cell cell529 = new Cell() { CellReference = "H29", StyleIndex = (UInt32Value)2U }; Cell cell530 = new Cell() { CellReference = "I29", StyleIndex = (UInt32Value)2U }; Cell cell531 = new Cell() { CellReference = "J29", StyleIndex = (UInt32Value)2U }; Cell cell532 = new Cell() { CellReference = "K29", StyleIndex = (UInt32Value)2U }; Cell cell533 = new Cell() { CellReference = "L29", StyleIndex = (UInt32Value)2U }; Cell cell534 = new Cell() { CellReference = "M29", StyleIndex = (UInt32Value)2U }; Cell cell535 = new Cell() { CellReference = "N29", StyleIndex = (UInt32Value)2U }; Cell cell536 = new Cell() { CellReference = "O29", StyleIndex = (UInt32Value)2U }; Cell cell537 = new Cell() { CellReference = "P29", StyleIndex = (UInt32Value)2U }; Cell cell538 = new Cell() { CellReference = "Q29", StyleIndex = (UInt32Value)2U }; Cell cell539 = new Cell() { CellReference = "R29", StyleIndex = (UInt32Value)2U }; Cell cell540 = new Cell() { CellReference = "S29", StyleIndex = (UInt32Value)2U }; Cell cell541 = new Cell() { CellReference = "T29", StyleIndex = (UInt32Value)2U }; Cell cell542 = new Cell() { CellReference = "U29", StyleIndex = (UInt32Value)2U }; Cell cell543 = new Cell() { CellReference = "V29", StyleIndex = (UInt32Value)2U }; Cell cell544 = new Cell() { CellReference = "W29", StyleIndex = (UInt32Value)2U }; Cell cell545 = new Cell() { CellReference = "X29", StyleIndex = (UInt32Value)2U }; Cell cell546 = new Cell() { CellReference = "Y29", StyleIndex = (UInt32Value)2U }; Cell cell547 = new Cell() { CellReference = "Z29", StyleIndex = (UInt32Value)2U }; Cell cell548 = new Cell() { CellReference = "AA29", StyleIndex = (UInt32Value)2U }; Cell cell549 = new Cell() { CellReference = "AB29", StyleIndex = (UInt32Value)2U }; Cell cell550 = new Cell() { CellReference = "AC29", StyleIndex = (UInt32Value)2U }; Cell cell551 = new Cell() { CellReference = "AD29", StyleIndex = (UInt32Value)2U }; Cell cell552 = new Cell() { CellReference = "AE29", StyleIndex = (UInt32Value)2U }; Cell cell553 = new Cell() { CellReference = "AF29", StyleIndex = (UInt32Value)2U }; Cell cell554 = new Cell() { CellReference = "AG29", StyleIndex = (UInt32Value)2U }; Cell cell555 = new Cell() { CellReference = "AH29", StyleIndex = (UInt32Value)2U }; Cell cell556 = new Cell() { CellReference = "AI29", StyleIndex = (UInt32Value)2U }; Cell cell557 = new Cell() { CellReference = "AJ29", StyleIndex = (UInt32Value)2U }; Cell cell558 = new Cell() { CellReference = "AK29", StyleIndex = (UInt32Value)2U }; Cell cell559 = new Cell() { CellReference = "AL29", StyleIndex = (UInt32Value)47U }; Cell cell560 = new Cell() { CellReference = "AM29", StyleIndex = (UInt32Value)48U, DataType = CellValues.SharedString }; CellValue cellValue150 = new CellValue(); cellValue150.Text = "33"; cell560.Append(cellValue150); Cell cell561 = new Cell() { CellReference = "AN29", StyleIndex = (UInt32Value)49U }; CellFormula cellFormula46 = new CellFormula(); cellFormula46.Text = "+AL26"; CellValue cellValue151 = new CellValue(); cellValue151.Text = "0"; cell561.Append(cellFormula46); cell561.Append(cellValue151); Cell cell562 = new Cell() { CellReference = "AO29", StyleIndex = (UInt32Value)2U }; Cell cell563 = new Cell() { CellReference = "AP29", StyleIndex = (UInt32Value)2U }; Cell cell564 = new Cell() { CellReference = "AQ29", StyleIndex = (UInt32Value)2U }; Cell cell565 = new Cell() { CellReference = "AR29", StyleIndex = (UInt32Value)2U }; row26.Append(cell524); row26.Append(cell525); row26.Append(cell526); row26.Append(cell527); row26.Append(cell528); row26.Append(cell529); row26.Append(cell530); row26.Append(cell531); row26.Append(cell532); row26.Append(cell533); row26.Append(cell534); row26.Append(cell535); row26.Append(cell536); row26.Append(cell537); row26.Append(cell538); row26.Append(cell539); row26.Append(cell540); row26.Append(cell541); row26.Append(cell542); row26.Append(cell543); row26.Append(cell544); row26.Append(cell545); row26.Append(cell546); row26.Append(cell547); row26.Append(cell548); row26.Append(cell549); row26.Append(cell550); row26.Append(cell551); row26.Append(cell552); row26.Append(cell553); row26.Append(cell554); row26.Append(cell555); row26.Append(cell556); row26.Append(cell557); row26.Append(cell558); row26.Append(cell559); row26.Append(cell560); row26.Append(cell561); row26.Append(cell562); row26.Append(cell563); row26.Append(cell564); row26.Append(cell565); Row row27 = new Row() { RowIndex = (UInt32Value)30U, Spans = new ListValue<StringValue>() { InnerText = "2:44" }, StyleIndex = (UInt32Value)3U, CustomFormat = true, Height = 15.75D, CustomHeight = true }; Cell cell566 = new Cell() { CellReference = "B30", StyleIndex = (UInt32Value)4U }; Cell cell567 = new Cell() { CellReference = "C30", StyleIndex = (UInt32Value)50U, DataType = CellValues.SharedString }; CellValue cellValue152 = new CellValue(); cellValue152.Text = "30"; cell567.Append(cellValue152); Cell cell568 = new Cell() { CellReference = "D30", StyleIndex = (UInt32Value)51U }; Cell cell569 = new Cell() { CellReference = "E30", StyleIndex = (UInt32Value)2U }; Cell cell570 = new Cell() { CellReference = "F30", StyleIndex = (UInt32Value)2U }; Cell cell571 = new Cell() { CellReference = "G30", StyleIndex = (UInt32Value)2U }; Cell cell572 = new Cell() { CellReference = "H30", StyleIndex = (UInt32Value)2U }; Cell cell573 = new Cell() { CellReference = "I30", StyleIndex = (UInt32Value)2U }; Cell cell574 = new Cell() { CellReference = "J30", StyleIndex = (UInt32Value)2U }; Cell cell575 = new Cell() { CellReference = "K30", StyleIndex = (UInt32Value)2U }; Cell cell576 = new Cell() { CellReference = "L30", StyleIndex = (UInt32Value)2U }; Cell cell577 = new Cell() { CellReference = "M30", StyleIndex = (UInt32Value)2U }; Cell cell578 = new Cell() { CellReference = "N30", StyleIndex = (UInt32Value)2U }; Cell cell579 = new Cell() { CellReference = "O30", StyleIndex = (UInt32Value)2U }; Cell cell580 = new Cell() { CellReference = "P30", StyleIndex = (UInt32Value)2U }; Cell cell581 = new Cell() { CellReference = "Q30", StyleIndex = (UInt32Value)2U }; Cell cell582 = new Cell() { CellReference = "R30", StyleIndex = (UInt32Value)2U }; Cell cell583 = new Cell() { CellReference = "S30", StyleIndex = (UInt32Value)2U }; Cell cell584 = new Cell() { CellReference = "T30", StyleIndex = (UInt32Value)2U }; Cell cell585 = new Cell() { CellReference = "U30", StyleIndex = (UInt32Value)2U }; Cell cell586 = new Cell() { CellReference = "V30", StyleIndex = (UInt32Value)2U }; Cell cell587 = new Cell() { CellReference = "W30", StyleIndex = (UInt32Value)2U }; Cell cell588 = new Cell() { CellReference = "X30", StyleIndex = (UInt32Value)2U }; Cell cell589 = new Cell() { CellReference = "Y30", StyleIndex = (UInt32Value)2U }; Cell cell590 = new Cell() { CellReference = "Z30", StyleIndex = (UInt32Value)2U }; Cell cell591 = new Cell() { CellReference = "AA30", StyleIndex = (UInt32Value)2U }; Cell cell592 = new Cell() { CellReference = "AB30", StyleIndex = (UInt32Value)2U }; Cell cell593 = new Cell() { CellReference = "AC30", StyleIndex = (UInt32Value)2U }; Cell cell594 = new Cell() { CellReference = "AD30", StyleIndex = (UInt32Value)2U }; Cell cell595 = new Cell() { CellReference = "AE30", StyleIndex = (UInt32Value)2U }; Cell cell596 = new Cell() { CellReference = "AF30", StyleIndex = (UInt32Value)2U }; Cell cell597 = new Cell() { CellReference = "AG30", StyleIndex = (UInt32Value)2U }; Cell cell598 = new Cell() { CellReference = "AH30", StyleIndex = (UInt32Value)2U }; Cell cell599 = new Cell() { CellReference = "AI30", StyleIndex = (UInt32Value)2U }; Cell cell600 = new Cell() { CellReference = "AJ30", StyleIndex = (UInt32Value)2U }; Cell cell601 = new Cell() { CellReference = "AK30", StyleIndex = (UInt32Value)2U }; Cell cell602 = new Cell() { CellReference = "AL30", StyleIndex = (UInt32Value)47U }; Cell cell603 = new Cell() { CellReference = "AM30", StyleIndex = (UInt32Value)48U, DataType = CellValues.SharedString }; CellValue cellValue153 = new CellValue(); cellValue153.Text = "34"; cell603.Append(cellValue153); Cell cell604 = new Cell() { CellReference = "AN30", StyleIndex = (UInt32Value)85U, DataType = CellValues.Error }; CellFormula cellFormula47 = new CellFormula(); cellFormula47.Text = "+AN26/AN29"; CellValue cellValue154 = new CellValue(); cellValue154.Text = "#DIV/0!"; cell604.Append(cellFormula47); cell604.Append(cellValue154); Cell cell605 = new Cell() { CellReference = "AO30", StyleIndex = (UInt32Value)2U }; Cell cell606 = new Cell() { CellReference = "AP30", StyleIndex = (UInt32Value)2U }; Cell cell607 = new Cell() { CellReference = "AQ30", StyleIndex = (UInt32Value)2U }; Cell cell608 = new Cell() { CellReference = "AR30", StyleIndex = (UInt32Value)2U }; row27.Append(cell566); row27.Append(cell567); row27.Append(cell568); row27.Append(cell569); row27.Append(cell570); row27.Append(cell571); row27.Append(cell572); row27.Append(cell573); row27.Append(cell574); row27.Append(cell575); row27.Append(cell576); row27.Append(cell577); row27.Append(cell578); row27.Append(cell579); row27.Append(cell580); row27.Append(cell581); row27.Append(cell582); row27.Append(cell583); row27.Append(cell584); row27.Append(cell585); row27.Append(cell586); row27.Append(cell587); row27.Append(cell588); row27.Append(cell589); row27.Append(cell590); row27.Append(cell591); row27.Append(cell592); row27.Append(cell593); row27.Append(cell594); row27.Append(cell595); row27.Append(cell596); row27.Append(cell597); row27.Append(cell598); row27.Append(cell599); row27.Append(cell600); row27.Append(cell601); row27.Append(cell602); row27.Append(cell603); row27.Append(cell604); row27.Append(cell605); row27.Append(cell606); row27.Append(cell607); row27.Append(cell608); Row row28 = new Row() { RowIndex = (UInt32Value)31U, Spans = new ListValue<StringValue>() { InnerText = "2:44" }, StyleIndex = (UInt32Value)3U, CustomFormat = true, Height = 15.75D, CustomHeight = true }; Cell cell609 = new Cell() { CellReference = "B31", StyleIndex = (UInt32Value)4U }; Cell cell610 = new Cell() { CellReference = "C31", StyleIndex = (UInt32Value)50U, DataType = CellValues.SharedString }; CellValue cellValue155 = new CellValue(); cellValue155.Text = "35"; cell610.Append(cellValue155); Cell cell611 = new Cell() { CellReference = "D31", StyleIndex = (UInt32Value)51U }; Cell cell612 = new Cell() { CellReference = "E31", StyleIndex = (UInt32Value)2U }; Cell cell613 = new Cell() { CellReference = "F31", StyleIndex = (UInt32Value)2U }; Cell cell614 = new Cell() { CellReference = "G31", StyleIndex = (UInt32Value)2U }; Cell cell615 = new Cell() { CellReference = "H31", StyleIndex = (UInt32Value)2U }; Cell cell616 = new Cell() { CellReference = "I31", StyleIndex = (UInt32Value)2U }; Cell cell617 = new Cell() { CellReference = "J31", StyleIndex = (UInt32Value)2U }; Cell cell618 = new Cell() { CellReference = "K31", StyleIndex = (UInt32Value)2U }; Cell cell619 = new Cell() { CellReference = "L31", StyleIndex = (UInt32Value)2U }; Cell cell620 = new Cell() { CellReference = "M31", StyleIndex = (UInt32Value)2U }; Cell cell621 = new Cell() { CellReference = "N31", StyleIndex = (UInt32Value)2U }; Cell cell622 = new Cell() { CellReference = "O31", StyleIndex = (UInt32Value)2U }; Cell cell623 = new Cell() { CellReference = "P31", StyleIndex = (UInt32Value)2U }; Cell cell624 = new Cell() { CellReference = "Q31", StyleIndex = (UInt32Value)2U }; Cell cell625 = new Cell() { CellReference = "R31", StyleIndex = (UInt32Value)2U }; Cell cell626 = new Cell() { CellReference = "S31", StyleIndex = (UInt32Value)2U }; Cell cell627 = new Cell() { CellReference = "T31", StyleIndex = (UInt32Value)2U }; Cell cell628 = new Cell() { CellReference = "U31", StyleIndex = (UInt32Value)2U }; Cell cell629 = new Cell() { CellReference = "V31", StyleIndex = (UInt32Value)2U }; Cell cell630 = new Cell() { CellReference = "W31", StyleIndex = (UInt32Value)2U }; Cell cell631 = new Cell() { CellReference = "X31", StyleIndex = (UInt32Value)2U }; Cell cell632 = new Cell() { CellReference = "Y31", StyleIndex = (UInt32Value)2U }; Cell cell633 = new Cell() { CellReference = "Z31", StyleIndex = (UInt32Value)2U }; Cell cell634 = new Cell() { CellReference = "AA31", StyleIndex = (UInt32Value)2U }; Cell cell635 = new Cell() { CellReference = "AB31", StyleIndex = (UInt32Value)2U }; Cell cell636 = new Cell() { CellReference = "AC31", StyleIndex = (UInt32Value)2U }; Cell cell637 = new Cell() { CellReference = "AD31", StyleIndex = (UInt32Value)2U }; Cell cell638 = new Cell() { CellReference = "AE31", StyleIndex = (UInt32Value)2U }; Cell cell639 = new Cell() { CellReference = "AF31", StyleIndex = (UInt32Value)2U }; Cell cell640 = new Cell() { CellReference = "AG31", StyleIndex = (UInt32Value)2U }; Cell cell641 = new Cell() { CellReference = "AH31", StyleIndex = (UInt32Value)2U }; Cell cell642 = new Cell() { CellReference = "AI31", StyleIndex = (UInt32Value)2U }; Cell cell643 = new Cell() { CellReference = "AJ31", StyleIndex = (UInt32Value)2U }; Cell cell644 = new Cell() { CellReference = "AK31", StyleIndex = (UInt32Value)2U }; Cell cell645 = new Cell() { CellReference = "AL31", StyleIndex = (UInt32Value)47U }; Cell cell646 = new Cell() { CellReference = "AM31", StyleIndex = (UInt32Value)48U, DataType = CellValues.SharedString }; CellValue cellValue156 = new CellValue(); cellValue156.Text = "36"; cell646.Append(cellValue156); Cell cell647 = new Cell() { CellReference = "AN31", StyleIndex = (UInt32Value)86U, DataType = CellValues.Error }; CellFormula cellFormula48 = new CellFormula(); cellFormula48.Text = "+AN30*AN29"; CellValue cellValue157 = new CellValue(); cellValue157.Text = "#DIV/0!"; cell647.Append(cellFormula48); cell647.Append(cellValue157); Cell cell648 = new Cell() { CellReference = "AO31", StyleIndex = (UInt32Value)2U }; Cell cell649 = new Cell() { CellReference = "AP31", StyleIndex = (UInt32Value)2U }; Cell cell650 = new Cell() { CellReference = "AQ31", StyleIndex = (UInt32Value)2U }; Cell cell651 = new Cell() { CellReference = "AR31", StyleIndex = (UInt32Value)2U }; row28.Append(cell609); row28.Append(cell610); row28.Append(cell611); row28.Append(cell612); row28.Append(cell613); row28.Append(cell614); row28.Append(cell615); row28.Append(cell616); row28.Append(cell617); row28.Append(cell618); row28.Append(cell619); row28.Append(cell620); row28.Append(cell621); row28.Append(cell622); row28.Append(cell623); row28.Append(cell624); row28.Append(cell625); row28.Append(cell626); row28.Append(cell627); row28.Append(cell628); row28.Append(cell629); row28.Append(cell630); row28.Append(cell631); row28.Append(cell632); row28.Append(cell633); row28.Append(cell634); row28.Append(cell635); row28.Append(cell636); row28.Append(cell637); row28.Append(cell638); row28.Append(cell639); row28.Append(cell640); row28.Append(cell641); row28.Append(cell642); row28.Append(cell643); row28.Append(cell644); row28.Append(cell645); row28.Append(cell646); row28.Append(cell647); row28.Append(cell648); row28.Append(cell649); row28.Append(cell650); row28.Append(cell651); Row row29 = new Row() { RowIndex = (UInt32Value)32U, Spans = new ListValue<StringValue>() { InnerText = "2:44" }, StyleIndex = (UInt32Value)3U, CustomFormat = true, Height = 15.75D, CustomHeight = true }; Cell cell652 = new Cell() { CellReference = "C32", StyleIndex = (UInt32Value)50U, DataType = CellValues.SharedString }; CellValue cellValue158 = new CellValue(); cellValue158.Text = "37"; cell652.Append(cellValue158); Cell cell653 = new Cell() { CellReference = "D32", StyleIndex = (UInt32Value)51U }; Cell cell654 = new Cell() { CellReference = "E32", StyleIndex = (UInt32Value)2U }; Cell cell655 = new Cell() { CellReference = "F32", StyleIndex = (UInt32Value)2U }; Cell cell656 = new Cell() { CellReference = "G32", StyleIndex = (UInt32Value)2U }; Cell cell657 = new Cell() { CellReference = "H32", StyleIndex = (UInt32Value)2U }; Cell cell658 = new Cell() { CellReference = "I32", StyleIndex = (UInt32Value)2U }; Cell cell659 = new Cell() { CellReference = "J32", StyleIndex = (UInt32Value)2U }; Cell cell660 = new Cell() { CellReference = "K32", StyleIndex = (UInt32Value)2U }; Cell cell661 = new Cell() { CellReference = "L32", StyleIndex = (UInt32Value)2U }; Cell cell662 = new Cell() { CellReference = "M32", StyleIndex = (UInt32Value)2U }; Cell cell663 = new Cell() { CellReference = "N32", StyleIndex = (UInt32Value)2U }; Cell cell664 = new Cell() { CellReference = "O32", StyleIndex = (UInt32Value)2U }; Cell cell665 = new Cell() { CellReference = "P32", StyleIndex = (UInt32Value)2U }; Cell cell666 = new Cell() { CellReference = "Q32", StyleIndex = (UInt32Value)2U }; Cell cell667 = new Cell() { CellReference = "R32", StyleIndex = (UInt32Value)2U }; Cell cell668 = new Cell() { CellReference = "S32", StyleIndex = (UInt32Value)2U }; Cell cell669 = new Cell() { CellReference = "T32", StyleIndex = (UInt32Value)2U }; Cell cell670 = new Cell() { CellReference = "U32", StyleIndex = (UInt32Value)2U }; Cell cell671 = new Cell() { CellReference = "V32", StyleIndex = (UInt32Value)2U }; Cell cell672 = new Cell() { CellReference = "W32", StyleIndex = (UInt32Value)2U }; Cell cell673 = new Cell() { CellReference = "X32", StyleIndex = (UInt32Value)2U }; Cell cell674 = new Cell() { CellReference = "Y32", StyleIndex = (UInt32Value)2U }; Cell cell675 = new Cell() { CellReference = "Z32", StyleIndex = (UInt32Value)2U }; Cell cell676 = new Cell() { CellReference = "AA32", StyleIndex = (UInt32Value)2U }; Cell cell677 = new Cell() { CellReference = "AB32", StyleIndex = (UInt32Value)2U }; Cell cell678 = new Cell() { CellReference = "AC32", StyleIndex = (UInt32Value)2U }; Cell cell679 = new Cell() { CellReference = "AD32", StyleIndex = (UInt32Value)2U }; Cell cell680 = new Cell() { CellReference = "AE32", StyleIndex = (UInt32Value)2U }; Cell cell681 = new Cell() { CellReference = "AF32", StyleIndex = (UInt32Value)2U }; Cell cell682 = new Cell() { CellReference = "AG32", StyleIndex = (UInt32Value)2U }; Cell cell683 = new Cell() { CellReference = "AH32", StyleIndex = (UInt32Value)2U }; Cell cell684 = new Cell() { CellReference = "AI32", StyleIndex = (UInt32Value)2U }; Cell cell685 = new Cell() { CellReference = "AJ32", StyleIndex = (UInt32Value)2U }; Cell cell686 = new Cell() { CellReference = "AK32", StyleIndex = (UInt32Value)2U }; Cell cell687 = new Cell() { CellReference = "AL32", StyleIndex = (UInt32Value)47U }; Cell cell688 = new Cell() { CellReference = "AM32", StyleIndex = (UInt32Value)48U, DataType = CellValues.SharedString }; CellValue cellValue159 = new CellValue(); cellValue159.Text = "38"; cell688.Append(cellValue159); Cell cell689 = new Cell() { CellReference = "AN32", StyleIndex = (UInt32Value)87U, DataType = CellValues.Error }; CellFormula cellFormula49 = new CellFormula(); cellFormula49.Text = "+AN31*0.21"; CellValue cellValue160 = new CellValue(); cellValue160.Text = "#DIV/0!"; cell689.Append(cellFormula49); cell689.Append(cellValue160); Cell cell690 = new Cell() { CellReference = "AO32", StyleIndex = (UInt32Value)2U }; Cell cell691 = new Cell() { CellReference = "AP32", StyleIndex = (UInt32Value)2U }; Cell cell692 = new Cell() { CellReference = "AQ32", StyleIndex = (UInt32Value)2U }; Cell cell693 = new Cell() { CellReference = "AR32", StyleIndex = (UInt32Value)2U }; row29.Append(cell652); row29.Append(cell653); row29.Append(cell654); row29.Append(cell655); row29.Append(cell656); row29.Append(cell657); row29.Append(cell658); row29.Append(cell659); row29.Append(cell660); row29.Append(cell661); row29.Append(cell662); row29.Append(cell663); row29.Append(cell664); row29.Append(cell665); row29.Append(cell666); row29.Append(cell667); row29.Append(cell668); row29.Append(cell669); row29.Append(cell670); row29.Append(cell671); row29.Append(cell672); row29.Append(cell673); row29.Append(cell674); row29.Append(cell675); row29.Append(cell676); row29.Append(cell677); row29.Append(cell678); row29.Append(cell679); row29.Append(cell680); row29.Append(cell681); row29.Append(cell682); row29.Append(cell683); row29.Append(cell684); row29.Append(cell685); row29.Append(cell686); row29.Append(cell687); row29.Append(cell688); row29.Append(cell689); row29.Append(cell690); row29.Append(cell691); row29.Append(cell692); row29.Append(cell693); Row row30 = new Row() { RowIndex = (UInt32Value)33U, Spans = new ListValue<StringValue>() { InnerText = "2:44" } }; Cell cell694 = new Cell() { CellReference = "G33", StyleIndex = (UInt32Value)1U }; Cell cell695 = new Cell() { CellReference = "H33", StyleIndex = (UInt32Value)1U }; Cell cell696 = new Cell() { CellReference = "I33", StyleIndex = (UInt32Value)1U }; Cell cell697 = new Cell() { CellReference = "J33", StyleIndex = (UInt32Value)1U }; Cell cell698 = new Cell() { CellReference = "K33", StyleIndex = (UInt32Value)1U }; Cell cell699 = new Cell() { CellReference = "L33", StyleIndex = (UInt32Value)1U }; Cell cell700 = new Cell() { CellReference = "M33", StyleIndex = (UInt32Value)1U }; Cell cell701 = new Cell() { CellReference = "N33", StyleIndex = (UInt32Value)1U }; Cell cell702 = new Cell() { CellReference = "O33", StyleIndex = (UInt32Value)1U }; Cell cell703 = new Cell() { CellReference = "P33", StyleIndex = (UInt32Value)1U }; Cell cell704 = new Cell() { CellReference = "Q33", StyleIndex = (UInt32Value)1U }; Cell cell705 = new Cell() { CellReference = "R33", StyleIndex = (UInt32Value)1U }; Cell cell706 = new Cell() { CellReference = "S33", StyleIndex = (UInt32Value)1U }; Cell cell707 = new Cell() { CellReference = "T33", StyleIndex = (UInt32Value)1U }; Cell cell708 = new Cell() { CellReference = "U33", StyleIndex = (UInt32Value)1U }; Cell cell709 = new Cell() { CellReference = "V33", StyleIndex = (UInt32Value)1U }; Cell cell710 = new Cell() { CellReference = "W33", StyleIndex = (UInt32Value)1U }; Cell cell711 = new Cell() { CellReference = "X33", StyleIndex = (UInt32Value)1U }; Cell cell712 = new Cell() { CellReference = "Y33", StyleIndex = (UInt32Value)1U }; Cell cell713 = new Cell() { CellReference = "Z33", StyleIndex = (UInt32Value)1U }; Cell cell714 = new Cell() { CellReference = "AA33", StyleIndex = (UInt32Value)1U }; Cell cell715 = new Cell() { CellReference = "AB33", StyleIndex = (UInt32Value)1U }; Cell cell716 = new Cell() { CellReference = "AC33", StyleIndex = (UInt32Value)1U }; Cell cell717 = new Cell() { CellReference = "AD33", StyleIndex = (UInt32Value)1U }; Cell cell718 = new Cell() { CellReference = "AE33", StyleIndex = (UInt32Value)1U }; Cell cell719 = new Cell() { CellReference = "AF33", StyleIndex = (UInt32Value)1U }; Cell cell720 = new Cell() { CellReference = "AG33", StyleIndex = (UInt32Value)1U }; Cell cell721 = new Cell() { CellReference = "AH33", StyleIndex = (UInt32Value)1U }; Cell cell722 = new Cell() { CellReference = "AI33", StyleIndex = (UInt32Value)1U }; Cell cell723 = new Cell() { CellReference = "AJ33", StyleIndex = (UInt32Value)1U }; Cell cell724 = new Cell() { CellReference = "AK33", StyleIndex = (UInt32Value)1U }; Cell cell725 = new Cell() { CellReference = "AL33", StyleIndex = (UInt32Value)52U }; Cell cell726 = new Cell() { CellReference = "AM33", StyleIndex = (UInt32Value)53U, DataType = CellValues.SharedString }; CellValue cellValue161 = new CellValue(); cellValue161.Text = "39"; cell726.Append(cellValue161); Cell cell727 = new Cell() { CellReference = "AN33", StyleIndex = (UInt32Value)88U, DataType = CellValues.Error }; CellFormula cellFormula50 = new CellFormula(); cellFormula50.Text = "SUM(AN31:AN32)"; CellValue cellValue162 = new CellValue(); cellValue162.Text = "#DIV/0!"; cell727.Append(cellFormula50); cell727.Append(cellValue162); row30.Append(cell694); row30.Append(cell695); row30.Append(cell696); row30.Append(cell697); row30.Append(cell698); row30.Append(cell699); row30.Append(cell700); row30.Append(cell701); row30.Append(cell702); row30.Append(cell703); row30.Append(cell704); row30.Append(cell705); row30.Append(cell706); row30.Append(cell707); row30.Append(cell708); row30.Append(cell709); row30.Append(cell710); row30.Append(cell711); row30.Append(cell712); row30.Append(cell713); row30.Append(cell714); row30.Append(cell715); row30.Append(cell716); row30.Append(cell717); row30.Append(cell718); row30.Append(cell719); row30.Append(cell720); row30.Append(cell721); row30.Append(cell722); row30.Append(cell723); row30.Append(cell724); row30.Append(cell725); row30.Append(cell726); row30.Append(cell727); Row row31 = new Row() { RowIndex = (UInt32Value)34U, Spans = new ListValue<StringValue>() { InnerText = "2:44" }, StyleIndex = (UInt32Value)3U, CustomFormat = true, Height = 51D, CustomHeight = true }; Cell cell728 = new Cell() { CellReference = "C34", StyleIndex = (UInt32Value)54U, DataType = CellValues.SharedString }; CellValue cellValue163 = new CellValue(); cellValue163.Text = "40"; cell728.Append(cellValue163); Cell cell729 = new Cell() { CellReference = "D34", StyleIndex = (UInt32Value)54U, DataType = CellValues.SharedString }; CellValue cellValue164 = new CellValue(); cellValue164.Text = "14"; cell729.Append(cellValue164); Cell cell730 = new Cell() { CellReference = "E34", StyleIndex = (UInt32Value)54U, DataType = CellValues.SharedString }; CellValue cellValue165 = new CellValue(); cellValue165.Text = "41"; cell730.Append(cellValue165); Cell cell731 = new Cell() { CellReference = "F34", StyleIndex = (UInt32Value)54U, DataType = CellValues.SharedString }; CellValue cellValue166 = new CellValue(); cellValue166.Text = "42"; cell731.Append(cellValue166); Cell cell732 = new Cell() { CellReference = "G34", StyleIndex = (UInt32Value)82U, DataType = CellValues.SharedString }; CellValue cellValue167 = new CellValue(); cellValue167.Text = "43"; cell732.Append(cellValue167); Cell cell733 = new Cell() { CellReference = "H34", StyleIndex = (UInt32Value)83U }; Cell cell734 = new Cell() { CellReference = "I34", StyleIndex = (UInt32Value)84U }; Cell cell735 = new Cell() { CellReference = "J34", StyleIndex = (UInt32Value)2U }; Cell cell736 = new Cell() { CellReference = "K34", StyleIndex = (UInt32Value)2U }; Cell cell737 = new Cell() { CellReference = "L34", StyleIndex = (UInt32Value)2U }; Cell cell738 = new Cell() { CellReference = "M34", StyleIndex = (UInt32Value)2U }; Cell cell739 = new Cell() { CellReference = "N34", StyleIndex = (UInt32Value)2U }; Cell cell740 = new Cell() { CellReference = "O34", StyleIndex = (UInt32Value)2U }; Cell cell741 = new Cell() { CellReference = "P34", StyleIndex = (UInt32Value)2U }; Cell cell742 = new Cell() { CellReference = "Q34", StyleIndex = (UInt32Value)2U }; Cell cell743 = new Cell() { CellReference = "R34", StyleIndex = (UInt32Value)2U }; Cell cell744 = new Cell() { CellReference = "S34", StyleIndex = (UInt32Value)2U }; Cell cell745 = new Cell() { CellReference = "T34", StyleIndex = (UInt32Value)2U }; Cell cell746 = new Cell() { CellReference = "U34", StyleIndex = (UInt32Value)2U }; Cell cell747 = new Cell() { CellReference = "V34", StyleIndex = (UInt32Value)2U }; Cell cell748 = new Cell() { CellReference = "W34", StyleIndex = (UInt32Value)2U }; Cell cell749 = new Cell() { CellReference = "X34", StyleIndex = (UInt32Value)2U }; Cell cell750 = new Cell() { CellReference = "Y34", StyleIndex = (UInt32Value)2U }; Cell cell751 = new Cell() { CellReference = "Z34", StyleIndex = (UInt32Value)2U }; Cell cell752 = new Cell() { CellReference = "AA34", StyleIndex = (UInt32Value)2U }; Cell cell753 = new Cell() { CellReference = "AB34", StyleIndex = (UInt32Value)2U }; Cell cell754 = new Cell() { CellReference = "AC34", StyleIndex = (UInt32Value)2U }; Cell cell755 = new Cell() { CellReference = "AD34", StyleIndex = (UInt32Value)2U }; Cell cell756 = new Cell() { CellReference = "AE34", StyleIndex = (UInt32Value)2U }; Cell cell757 = new Cell() { CellReference = "AF34", StyleIndex = (UInt32Value)2U }; Cell cell758 = new Cell() { CellReference = "AG34", StyleIndex = (UInt32Value)2U }; Cell cell759 = new Cell() { CellReference = "AH34", StyleIndex = (UInt32Value)2U }; Cell cell760 = new Cell() { CellReference = "AI34", StyleIndex = (UInt32Value)2U }; Cell cell761 = new Cell() { CellReference = "AJ34", StyleIndex = (UInt32Value)2U }; Cell cell762 = new Cell() { CellReference = "AK34", StyleIndex = (UInt32Value)2U }; Cell cell763 = new Cell() { CellReference = "AL34", StyleIndex = (UInt32Value)2U }; Cell cell764 = new Cell() { CellReference = "AM34", StyleIndex = (UInt32Value)2U }; Cell cell765 = new Cell() { CellReference = "AN34", StyleIndex = (UInt32Value)2U }; Cell cell766 = new Cell() { CellReference = "AO34", StyleIndex = (UInt32Value)2U }; Cell cell767 = new Cell() { CellReference = "AP34", StyleIndex = (UInt32Value)2U }; Cell cell768 = new Cell() { CellReference = "AQ34", StyleIndex = (UInt32Value)2U }; Cell cell769 = new Cell() { CellReference = "AR34", StyleIndex = (UInt32Value)2U }; row31.Append(cell728); row31.Append(cell729); row31.Append(cell730); row31.Append(cell731); row31.Append(cell732); row31.Append(cell733); row31.Append(cell734); row31.Append(cell735); row31.Append(cell736); row31.Append(cell737); row31.Append(cell738); row31.Append(cell739); row31.Append(cell740); row31.Append(cell741); row31.Append(cell742); row31.Append(cell743); row31.Append(cell744); row31.Append(cell745); row31.Append(cell746); row31.Append(cell747); row31.Append(cell748); row31.Append(cell749); row31.Append(cell750); row31.Append(cell751); row31.Append(cell752); row31.Append(cell753); row31.Append(cell754); row31.Append(cell755); row31.Append(cell756); row31.Append(cell757); row31.Append(cell758); row31.Append(cell759); row31.Append(cell760); row31.Append(cell761); row31.Append(cell762); row31.Append(cell763); row31.Append(cell764); row31.Append(cell765); row31.Append(cell766); row31.Append(cell767); row31.Append(cell768); row31.Append(cell769); Row row32 = new Row() { RowIndex = (UInt32Value)35U, Spans = new ListValue<StringValue>() { InnerText = "2:44" }, StyleIndex = (UInt32Value)3U, CustomFormat = true, Height = 15D, CustomHeight = true }; Cell cell770 = new Cell() { CellReference = "B35", StyleIndex = (UInt32Value)4U }; Cell cell771 = new Cell() { CellReference = "C35", StyleIndex = (UInt32Value)55U }; Cell cell772 = new Cell() { CellReference = "D35", StyleIndex = (UInt32Value)56U }; Cell cell773 = new Cell() { CellReference = "E35", StyleIndex = (UInt32Value)56U }; Cell cell774 = new Cell() { CellReference = "F35", StyleIndex = (UInt32Value)56U }; Cell cell775 = new Cell() { CellReference = "G35", StyleIndex = (UInt32Value)73U }; CellFormula cellFormula51 = new CellFormula(); cellFormula51.Text = "+AL21"; CellValue cellValue168 = new CellValue(); cellValue168.Text = "0"; cell775.Append(cellFormula51); cell775.Append(cellValue168); Cell cell776 = new Cell() { CellReference = "H35", StyleIndex = (UInt32Value)74U }; Cell cell777 = new Cell() { CellReference = "I35", StyleIndex = (UInt32Value)75U }; Cell cell778 = new Cell() { CellReference = "J35", StyleIndex = (UInt32Value)2U }; Cell cell779 = new Cell() { CellReference = "K35", StyleIndex = (UInt32Value)2U }; Cell cell780 = new Cell() { CellReference = "L35", StyleIndex = (UInt32Value)2U }; Cell cell781 = new Cell() { CellReference = "M35", StyleIndex = (UInt32Value)2U }; Cell cell782 = new Cell() { CellReference = "N35", StyleIndex = (UInt32Value)2U }; Cell cell783 = new Cell() { CellReference = "O35", StyleIndex = (UInt32Value)2U }; Cell cell784 = new Cell() { CellReference = "P35", StyleIndex = (UInt32Value)2U }; Cell cell785 = new Cell() { CellReference = "Q35", StyleIndex = (UInt32Value)2U }; Cell cell786 = new Cell() { CellReference = "R35", StyleIndex = (UInt32Value)2U }; Cell cell787 = new Cell() { CellReference = "S35", StyleIndex = (UInt32Value)2U }; Cell cell788 = new Cell() { CellReference = "T35", StyleIndex = (UInt32Value)2U }; Cell cell789 = new Cell() { CellReference = "U35", StyleIndex = (UInt32Value)2U }; Cell cell790 = new Cell() { CellReference = "V35", StyleIndex = (UInt32Value)2U }; Cell cell791 = new Cell() { CellReference = "W35", StyleIndex = (UInt32Value)2U }; Cell cell792 = new Cell() { CellReference = "X35", StyleIndex = (UInt32Value)2U }; Cell cell793 = new Cell() { CellReference = "Y35", StyleIndex = (UInt32Value)2U }; Cell cell794 = new Cell() { CellReference = "Z35", StyleIndex = (UInt32Value)2U }; Cell cell795 = new Cell() { CellReference = "AA35", StyleIndex = (UInt32Value)2U }; Cell cell796 = new Cell() { CellReference = "AB35", StyleIndex = (UInt32Value)2U }; Cell cell797 = new Cell() { CellReference = "AC35", StyleIndex = (UInt32Value)2U }; Cell cell798 = new Cell() { CellReference = "AD35", StyleIndex = (UInt32Value)2U }; Cell cell799 = new Cell() { CellReference = "AE35", StyleIndex = (UInt32Value)2U }; Cell cell800 = new Cell() { CellReference = "AF35", StyleIndex = (UInt32Value)2U }; Cell cell801 = new Cell() { CellReference = "AG35", StyleIndex = (UInt32Value)2U }; Cell cell802 = new Cell() { CellReference = "AH35", StyleIndex = (UInt32Value)2U }; Cell cell803 = new Cell() { CellReference = "AI35", StyleIndex = (UInt32Value)2U }; Cell cell804 = new Cell() { CellReference = "AJ35", StyleIndex = (UInt32Value)2U }; Cell cell805 = new Cell() { CellReference = "AK35", StyleIndex = (UInt32Value)2U }; Cell cell806 = new Cell() { CellReference = "AL35", StyleIndex = (UInt32Value)2U }; Cell cell807 = new Cell() { CellReference = "AM35", StyleIndex = (UInt32Value)2U }; Cell cell808 = new Cell() { CellReference = "AN35", StyleIndex = (UInt32Value)2U }; Cell cell809 = new Cell() { CellReference = "AO35", StyleIndex = (UInt32Value)2U }; Cell cell810 = new Cell() { CellReference = "AP35", StyleIndex = (UInt32Value)2U }; Cell cell811 = new Cell() { CellReference = "AQ35", StyleIndex = (UInt32Value)2U }; Cell cell812 = new Cell() { CellReference = "AR35", StyleIndex = (UInt32Value)2U }; row32.Append(cell770); row32.Append(cell771); row32.Append(cell772); row32.Append(cell773); row32.Append(cell774); row32.Append(cell775); row32.Append(cell776); row32.Append(cell777); row32.Append(cell778); row32.Append(cell779); row32.Append(cell780); row32.Append(cell781); row32.Append(cell782); row32.Append(cell783); row32.Append(cell784); row32.Append(cell785); row32.Append(cell786); row32.Append(cell787); row32.Append(cell788); row32.Append(cell789); row32.Append(cell790); row32.Append(cell791); row32.Append(cell792); row32.Append(cell793); row32.Append(cell794); row32.Append(cell795); row32.Append(cell796); row32.Append(cell797); row32.Append(cell798); row32.Append(cell799); row32.Append(cell800); row32.Append(cell801); row32.Append(cell802); row32.Append(cell803); row32.Append(cell804); row32.Append(cell805); row32.Append(cell806); row32.Append(cell807); row32.Append(cell808); row32.Append(cell809); row32.Append(cell810); row32.Append(cell811); row32.Append(cell812); Row row33 = new Row() { RowIndex = (UInt32Value)36U, Spans = new ListValue<StringValue>() { InnerText = "2:44" }, StyleIndex = (UInt32Value)3U, CustomFormat = true, Height = 15D, CustomHeight = true }; Cell cell813 = new Cell() { CellReference = "B36", StyleIndex = (UInt32Value)4U }; Cell cell814 = new Cell() { CellReference = "C36", StyleIndex = (UInt32Value)55U }; Cell cell815 = new Cell() { CellReference = "D36", StyleIndex = (UInt32Value)56U }; Cell cell816 = new Cell() { CellReference = "E36", StyleIndex = (UInt32Value)56U }; Cell cell817 = new Cell() { CellReference = "F36", StyleIndex = (UInt32Value)56U }; Cell cell818 = new Cell() { CellReference = "G36", StyleIndex = (UInt32Value)73U }; CellFormula cellFormula52 = new CellFormula(); cellFormula52.Text = "+AL22"; CellValue cellValue169 = new CellValue(); cellValue169.Text = "0"; cell818.Append(cellFormula52); cell818.Append(cellValue169); Cell cell819 = new Cell() { CellReference = "H36", StyleIndex = (UInt32Value)74U }; Cell cell820 = new Cell() { CellReference = "I36", StyleIndex = (UInt32Value)75U }; Cell cell821 = new Cell() { CellReference = "J36", StyleIndex = (UInt32Value)2U }; Cell cell822 = new Cell() { CellReference = "K36", StyleIndex = (UInt32Value)2U }; Cell cell823 = new Cell() { CellReference = "L36", StyleIndex = (UInt32Value)2U }; Cell cell824 = new Cell() { CellReference = "M36", StyleIndex = (UInt32Value)2U }; Cell cell825 = new Cell() { CellReference = "N36", StyleIndex = (UInt32Value)2U }; Cell cell826 = new Cell() { CellReference = "O36", StyleIndex = (UInt32Value)2U }; Cell cell827 = new Cell() { CellReference = "P36", StyleIndex = (UInt32Value)2U }; Cell cell828 = new Cell() { CellReference = "Q36", StyleIndex = (UInt32Value)2U }; Cell cell829 = new Cell() { CellReference = "R36", StyleIndex = (UInt32Value)2U }; Cell cell830 = new Cell() { CellReference = "S36", StyleIndex = (UInt32Value)2U }; Cell cell831 = new Cell() { CellReference = "T36", StyleIndex = (UInt32Value)2U }; Cell cell832 = new Cell() { CellReference = "U36", StyleIndex = (UInt32Value)2U }; Cell cell833 = new Cell() { CellReference = "V36", StyleIndex = (UInt32Value)2U }; Cell cell834 = new Cell() { CellReference = "W36", StyleIndex = (UInt32Value)2U }; Cell cell835 = new Cell() { CellReference = "X36", StyleIndex = (UInt32Value)2U }; Cell cell836 = new Cell() { CellReference = "Y36", StyleIndex = (UInt32Value)2U }; Cell cell837 = new Cell() { CellReference = "Z36", StyleIndex = (UInt32Value)2U }; Cell cell838 = new Cell() { CellReference = "AA36", StyleIndex = (UInt32Value)2U }; Cell cell839 = new Cell() { CellReference = "AB36", StyleIndex = (UInt32Value)2U }; Cell cell840 = new Cell() { CellReference = "AC36", StyleIndex = (UInt32Value)2U }; Cell cell841 = new Cell() { CellReference = "AD36", StyleIndex = (UInt32Value)2U }; Cell cell842 = new Cell() { CellReference = "AE36", StyleIndex = (UInt32Value)2U }; Cell cell843 = new Cell() { CellReference = "AF36", StyleIndex = (UInt32Value)2U }; Cell cell844 = new Cell() { CellReference = "AG36", StyleIndex = (UInt32Value)2U }; Cell cell845 = new Cell() { CellReference = "AH36", StyleIndex = (UInt32Value)2U }; Cell cell846 = new Cell() { CellReference = "AI36", StyleIndex = (UInt32Value)2U }; Cell cell847 = new Cell() { CellReference = "AJ36", StyleIndex = (UInt32Value)2U }; Cell cell848 = new Cell() { CellReference = "AK36", StyleIndex = (UInt32Value)2U }; Cell cell849 = new Cell() { CellReference = "AL36", StyleIndex = (UInt32Value)2U }; Cell cell850 = new Cell() { CellReference = "AM36", StyleIndex = (UInt32Value)2U }; Cell cell851 = new Cell() { CellReference = "AN36", StyleIndex = (UInt32Value)2U }; Cell cell852 = new Cell() { CellReference = "AO36", StyleIndex = (UInt32Value)2U }; Cell cell853 = new Cell() { CellReference = "AP36", StyleIndex = (UInt32Value)2U }; Cell cell854 = new Cell() { CellReference = "AQ36", StyleIndex = (UInt32Value)2U }; Cell cell855 = new Cell() { CellReference = "AR36", StyleIndex = (UInt32Value)2U }; row33.Append(cell813); row33.Append(cell814); row33.Append(cell815); row33.Append(cell816); row33.Append(cell817); row33.Append(cell818); row33.Append(cell819); row33.Append(cell820); row33.Append(cell821); row33.Append(cell822); row33.Append(cell823); row33.Append(cell824); row33.Append(cell825); row33.Append(cell826); row33.Append(cell827); row33.Append(cell828); row33.Append(cell829); row33.Append(cell830); row33.Append(cell831); row33.Append(cell832); row33.Append(cell833); row33.Append(cell834); row33.Append(cell835); row33.Append(cell836); row33.Append(cell837); row33.Append(cell838); row33.Append(cell839); row33.Append(cell840); row33.Append(cell841); row33.Append(cell842); row33.Append(cell843); row33.Append(cell844); row33.Append(cell845); row33.Append(cell846); row33.Append(cell847); row33.Append(cell848); row33.Append(cell849); row33.Append(cell850); row33.Append(cell851); row33.Append(cell852); row33.Append(cell853); row33.Append(cell854); row33.Append(cell855); Row row34 = new Row() { RowIndex = (UInt32Value)37U, Spans = new ListValue<StringValue>() { InnerText = "2:44" }, StyleIndex = (UInt32Value)3U, CustomFormat = true, Height = 15D, CustomHeight = true }; Cell cell856 = new Cell() { CellReference = "B37", StyleIndex = (UInt32Value)4U }; Cell cell857 = new Cell() { CellReference = "C37", StyleIndex = (UInt32Value)55U }; Cell cell858 = new Cell() { CellReference = "D37", StyleIndex = (UInt32Value)56U }; Cell cell859 = new Cell() { CellReference = "E37", StyleIndex = (UInt32Value)56U }; Cell cell860 = new Cell() { CellReference = "F37", StyleIndex = (UInt32Value)56U }; Cell cell861 = new Cell() { CellReference = "G37", StyleIndex = (UInt32Value)73U }; CellFormula cellFormula53 = new CellFormula(); cellFormula53.Text = "+AL23"; CellValue cellValue170 = new CellValue(); cellValue170.Text = "0"; cell861.Append(cellFormula53); cell861.Append(cellValue170); Cell cell862 = new Cell() { CellReference = "H37", StyleIndex = (UInt32Value)74U }; Cell cell863 = new Cell() { CellReference = "I37", StyleIndex = (UInt32Value)75U }; Cell cell864 = new Cell() { CellReference = "J37", StyleIndex = (UInt32Value)2U }; Cell cell865 = new Cell() { CellReference = "K37", StyleIndex = (UInt32Value)2U }; Cell cell866 = new Cell() { CellReference = "L37", StyleIndex = (UInt32Value)2U }; Cell cell867 = new Cell() { CellReference = "M37", StyleIndex = (UInt32Value)2U }; Cell cell868 = new Cell() { CellReference = "N37", StyleIndex = (UInt32Value)2U }; Cell cell869 = new Cell() { CellReference = "O37", StyleIndex = (UInt32Value)2U }; Cell cell870 = new Cell() { CellReference = "P37", StyleIndex = (UInt32Value)2U }; Cell cell871 = new Cell() { CellReference = "Q37", StyleIndex = (UInt32Value)2U }; Cell cell872 = new Cell() { CellReference = "R37", StyleIndex = (UInt32Value)2U }; Cell cell873 = new Cell() { CellReference = "S37", StyleIndex = (UInt32Value)2U }; Cell cell874 = new Cell() { CellReference = "T37", StyleIndex = (UInt32Value)2U }; Cell cell875 = new Cell() { CellReference = "U37", StyleIndex = (UInt32Value)2U }; Cell cell876 = new Cell() { CellReference = "V37", StyleIndex = (UInt32Value)2U }; Cell cell877 = new Cell() { CellReference = "W37", StyleIndex = (UInt32Value)2U }; Cell cell878 = new Cell() { CellReference = "X37", StyleIndex = (UInt32Value)2U }; Cell cell879 = new Cell() { CellReference = "Y37", StyleIndex = (UInt32Value)2U }; Cell cell880 = new Cell() { CellReference = "Z37", StyleIndex = (UInt32Value)2U }; Cell cell881 = new Cell() { CellReference = "AA37", StyleIndex = (UInt32Value)2U }; Cell cell882 = new Cell() { CellReference = "AB37", StyleIndex = (UInt32Value)2U }; Cell cell883 = new Cell() { CellReference = "AC37", StyleIndex = (UInt32Value)2U }; Cell cell884 = new Cell() { CellReference = "AD37", StyleIndex = (UInt32Value)2U }; Cell cell885 = new Cell() { CellReference = "AE37", StyleIndex = (UInt32Value)2U }; Cell cell886 = new Cell() { CellReference = "AF37", StyleIndex = (UInt32Value)2U }; Cell cell887 = new Cell() { CellReference = "AG37", StyleIndex = (UInt32Value)2U }; Cell cell888 = new Cell() { CellReference = "AH37", StyleIndex = (UInt32Value)2U }; Cell cell889 = new Cell() { CellReference = "AI37", StyleIndex = (UInt32Value)2U }; Cell cell890 = new Cell() { CellReference = "AJ37", StyleIndex = (UInt32Value)2U }; Cell cell891 = new Cell() { CellReference = "AK37", StyleIndex = (UInt32Value)2U }; Cell cell892 = new Cell() { CellReference = "AL37", StyleIndex = (UInt32Value)2U }; Cell cell893 = new Cell() { CellReference = "AM37", StyleIndex = (UInt32Value)2U }; Cell cell894 = new Cell() { CellReference = "AN37", StyleIndex = (UInt32Value)2U }; Cell cell895 = new Cell() { CellReference = "AO37", StyleIndex = (UInt32Value)2U }; Cell cell896 = new Cell() { CellReference = "AP37", StyleIndex = (UInt32Value)2U }; Cell cell897 = new Cell() { CellReference = "AQ37", StyleIndex = (UInt32Value)2U }; Cell cell898 = new Cell() { CellReference = "AR37", StyleIndex = (UInt32Value)2U }; row34.Append(cell856); row34.Append(cell857); row34.Append(cell858); row34.Append(cell859); row34.Append(cell860); row34.Append(cell861); row34.Append(cell862); row34.Append(cell863); row34.Append(cell864); row34.Append(cell865); row34.Append(cell866); row34.Append(cell867); row34.Append(cell868); row34.Append(cell869); row34.Append(cell870); row34.Append(cell871); row34.Append(cell872); row34.Append(cell873); row34.Append(cell874); row34.Append(cell875); row34.Append(cell876); row34.Append(cell877); row34.Append(cell878); row34.Append(cell879); row34.Append(cell880); row34.Append(cell881); row34.Append(cell882); row34.Append(cell883); row34.Append(cell884); row34.Append(cell885); row34.Append(cell886); row34.Append(cell887); row34.Append(cell888); row34.Append(cell889); row34.Append(cell890); row34.Append(cell891); row34.Append(cell892); row34.Append(cell893); row34.Append(cell894); row34.Append(cell895); row34.Append(cell896); row34.Append(cell897); row34.Append(cell898); Row row35 = new Row() { RowIndex = (UInt32Value)38U, Spans = new ListValue<StringValue>() { InnerText = "2:44" }, StyleIndex = (UInt32Value)3U, CustomFormat = true, Height = 15D, CustomHeight = true }; Cell cell899 = new Cell() { CellReference = "B38", StyleIndex = (UInt32Value)4U }; Cell cell900 = new Cell() { CellReference = "C38", StyleIndex = (UInt32Value)57U }; Cell cell901 = new Cell() { CellReference = "D38", StyleIndex = (UInt32Value)58U }; Cell cell902 = new Cell() { CellReference = "E38", StyleIndex = (UInt32Value)58U }; Cell cell903 = new Cell() { CellReference = "F38", StyleIndex = (UInt32Value)58U }; Cell cell904 = new Cell() { CellReference = "G38", StyleIndex = (UInt32Value)73U }; CellFormula cellFormula54 = new CellFormula(); cellFormula54.Text = "+AL24"; CellValue cellValue171 = new CellValue(); cellValue171.Text = "0"; cell904.Append(cellFormula54); cell904.Append(cellValue171); Cell cell905 = new Cell() { CellReference = "H38", StyleIndex = (UInt32Value)74U }; Cell cell906 = new Cell() { CellReference = "I38", StyleIndex = (UInt32Value)75U }; Cell cell907 = new Cell() { CellReference = "J38", StyleIndex = (UInt32Value)2U }; Cell cell908 = new Cell() { CellReference = "K38", StyleIndex = (UInt32Value)2U }; Cell cell909 = new Cell() { CellReference = "L38", StyleIndex = (UInt32Value)2U }; Cell cell910 = new Cell() { CellReference = "M38", StyleIndex = (UInt32Value)2U }; Cell cell911 = new Cell() { CellReference = "N38", StyleIndex = (UInt32Value)2U }; Cell cell912 = new Cell() { CellReference = "O38", StyleIndex = (UInt32Value)2U }; Cell cell913 = new Cell() { CellReference = "P38", StyleIndex = (UInt32Value)2U }; Cell cell914 = new Cell() { CellReference = "Q38", StyleIndex = (UInt32Value)2U }; Cell cell915 = new Cell() { CellReference = "R38", StyleIndex = (UInt32Value)2U }; Cell cell916 = new Cell() { CellReference = "S38", StyleIndex = (UInt32Value)2U }; Cell cell917 = new Cell() { CellReference = "T38", StyleIndex = (UInt32Value)2U }; Cell cell918 = new Cell() { CellReference = "U38", StyleIndex = (UInt32Value)2U }; Cell cell919 = new Cell() { CellReference = "V38", StyleIndex = (UInt32Value)2U }; Cell cell920 = new Cell() { CellReference = "W38", StyleIndex = (UInt32Value)2U }; Cell cell921 = new Cell() { CellReference = "X38", StyleIndex = (UInt32Value)2U }; Cell cell922 = new Cell() { CellReference = "Y38", StyleIndex = (UInt32Value)2U }; Cell cell923 = new Cell() { CellReference = "Z38", StyleIndex = (UInt32Value)2U }; Cell cell924 = new Cell() { CellReference = "AA38", StyleIndex = (UInt32Value)2U }; Cell cell925 = new Cell() { CellReference = "AB38", StyleIndex = (UInt32Value)2U }; Cell cell926 = new Cell() { CellReference = "AC38", StyleIndex = (UInt32Value)2U }; Cell cell927 = new Cell() { CellReference = "AD38", StyleIndex = (UInt32Value)2U }; Cell cell928 = new Cell() { CellReference = "AE38", StyleIndex = (UInt32Value)2U }; Cell cell929 = new Cell() { CellReference = "AF38", StyleIndex = (UInt32Value)2U }; Cell cell930 = new Cell() { CellReference = "AG38", StyleIndex = (UInt32Value)2U }; Cell cell931 = new Cell() { CellReference = "AH38", StyleIndex = (UInt32Value)2U }; Cell cell932 = new Cell() { CellReference = "AI38", StyleIndex = (UInt32Value)2U }; Cell cell933 = new Cell() { CellReference = "AJ38", StyleIndex = (UInt32Value)2U }; Cell cell934 = new Cell() { CellReference = "AK38", StyleIndex = (UInt32Value)2U }; Cell cell935 = new Cell() { CellReference = "AL38", StyleIndex = (UInt32Value)2U }; Cell cell936 = new Cell() { CellReference = "AM38", StyleIndex = (UInt32Value)2U }; Cell cell937 = new Cell() { CellReference = "AN38", StyleIndex = (UInt32Value)2U }; Cell cell938 = new Cell() { CellReference = "AO38", StyleIndex = (UInt32Value)2U }; Cell cell939 = new Cell() { CellReference = "AP38", StyleIndex = (UInt32Value)2U }; Cell cell940 = new Cell() { CellReference = "AQ38", StyleIndex = (UInt32Value)2U }; Cell cell941 = new Cell() { CellReference = "AR38", StyleIndex = (UInt32Value)2U }; row35.Append(cell899); row35.Append(cell900); row35.Append(cell901); row35.Append(cell902); row35.Append(cell903); row35.Append(cell904); row35.Append(cell905); row35.Append(cell906); row35.Append(cell907); row35.Append(cell908); row35.Append(cell909); row35.Append(cell910); row35.Append(cell911); row35.Append(cell912); row35.Append(cell913); row35.Append(cell914); row35.Append(cell915); row35.Append(cell916); row35.Append(cell917); row35.Append(cell918); row35.Append(cell919); row35.Append(cell920); row35.Append(cell921); row35.Append(cell922); row35.Append(cell923); row35.Append(cell924); row35.Append(cell925); row35.Append(cell926); row35.Append(cell927); row35.Append(cell928); row35.Append(cell929); row35.Append(cell930); row35.Append(cell931); row35.Append(cell932); row35.Append(cell933); row35.Append(cell934); row35.Append(cell935); row35.Append(cell936); row35.Append(cell937); row35.Append(cell938); row35.Append(cell939); row35.Append(cell940); row35.Append(cell941); Row row36 = new Row() { RowIndex = (UInt32Value)39U, Spans = new ListValue<StringValue>() { InnerText = "2:44" }, StyleIndex = (UInt32Value)3U, CustomFormat = true, Height = 15D, CustomHeight = true }; Cell cell942 = new Cell() { CellReference = "B39", StyleIndex = (UInt32Value)4U }; Cell cell943 = new Cell() { CellReference = "C39", StyleIndex = (UInt32Value)57U }; Cell cell944 = new Cell() { CellReference = "D39", StyleIndex = (UInt32Value)58U }; Cell cell945 = new Cell() { CellReference = "E39", StyleIndex = (UInt32Value)58U }; Cell cell946 = new Cell() { CellReference = "F39", StyleIndex = (UInt32Value)58U }; Cell cell947 = new Cell() { CellReference = "G39", StyleIndex = (UInt32Value)73U }; CellFormula cellFormula55 = new CellFormula(); cellFormula55.Text = "+AL25"; CellValue cellValue172 = new CellValue(); cellValue172.Text = "0"; cell947.Append(cellFormula55); cell947.Append(cellValue172); Cell cell948 = new Cell() { CellReference = "H39", StyleIndex = (UInt32Value)74U }; Cell cell949 = new Cell() { CellReference = "I39", StyleIndex = (UInt32Value)75U }; Cell cell950 = new Cell() { CellReference = "J39", StyleIndex = (UInt32Value)2U }; Cell cell951 = new Cell() { CellReference = "K39", StyleIndex = (UInt32Value)2U }; Cell cell952 = new Cell() { CellReference = "L39", StyleIndex = (UInt32Value)2U }; Cell cell953 = new Cell() { CellReference = "M39", StyleIndex = (UInt32Value)2U }; Cell cell954 = new Cell() { CellReference = "N39", StyleIndex = (UInt32Value)2U }; Cell cell955 = new Cell() { CellReference = "O39", StyleIndex = (UInt32Value)2U }; Cell cell956 = new Cell() { CellReference = "P39", StyleIndex = (UInt32Value)2U }; Cell cell957 = new Cell() { CellReference = "Q39", StyleIndex = (UInt32Value)2U }; Cell cell958 = new Cell() { CellReference = "R39", StyleIndex = (UInt32Value)2U }; Cell cell959 = new Cell() { CellReference = "S39", StyleIndex = (UInt32Value)2U }; Cell cell960 = new Cell() { CellReference = "T39", StyleIndex = (UInt32Value)2U }; Cell cell961 = new Cell() { CellReference = "U39", StyleIndex = (UInt32Value)2U }; Cell cell962 = new Cell() { CellReference = "V39", StyleIndex = (UInt32Value)2U }; Cell cell963 = new Cell() { CellReference = "W39", StyleIndex = (UInt32Value)2U }; Cell cell964 = new Cell() { CellReference = "X39", StyleIndex = (UInt32Value)2U }; Cell cell965 = new Cell() { CellReference = "Y39", StyleIndex = (UInt32Value)2U }; Cell cell966 = new Cell() { CellReference = "Z39", StyleIndex = (UInt32Value)2U }; Cell cell967 = new Cell() { CellReference = "AA39", StyleIndex = (UInt32Value)2U }; Cell cell968 = new Cell() { CellReference = "AB39", StyleIndex = (UInt32Value)2U }; Cell cell969 = new Cell() { CellReference = "AC39", StyleIndex = (UInt32Value)2U }; Cell cell970 = new Cell() { CellReference = "AD39", StyleIndex = (UInt32Value)2U }; Cell cell971 = new Cell() { CellReference = "AE39", StyleIndex = (UInt32Value)2U }; Cell cell972 = new Cell() { CellReference = "AF39", StyleIndex = (UInt32Value)2U }; Cell cell973 = new Cell() { CellReference = "AG39", StyleIndex = (UInt32Value)2U }; Cell cell974 = new Cell() { CellReference = "AH39", StyleIndex = (UInt32Value)2U }; Cell cell975 = new Cell() { CellReference = "AI39", StyleIndex = (UInt32Value)2U }; Cell cell976 = new Cell() { CellReference = "AJ39", StyleIndex = (UInt32Value)2U }; Cell cell977 = new Cell() { CellReference = "AK39", StyleIndex = (UInt32Value)2U }; Cell cell978 = new Cell() { CellReference = "AL39", StyleIndex = (UInt32Value)2U }; Cell cell979 = new Cell() { CellReference = "AM39", StyleIndex = (UInt32Value)2U }; Cell cell980 = new Cell() { CellReference = "AN39", StyleIndex = (UInt32Value)2U }; Cell cell981 = new Cell() { CellReference = "AO39", StyleIndex = (UInt32Value)2U }; Cell cell982 = new Cell() { CellReference = "AP39", StyleIndex = (UInt32Value)2U }; Cell cell983 = new Cell() { CellReference = "AQ39", StyleIndex = (UInt32Value)2U }; Cell cell984 = new Cell() { CellReference = "AR39", StyleIndex = (UInt32Value)2U }; row36.Append(cell942); row36.Append(cell943); row36.Append(cell944); row36.Append(cell945); row36.Append(cell946); row36.Append(cell947); row36.Append(cell948); row36.Append(cell949); row36.Append(cell950); row36.Append(cell951); row36.Append(cell952); row36.Append(cell953); row36.Append(cell954); row36.Append(cell955); row36.Append(cell956); row36.Append(cell957); row36.Append(cell958); row36.Append(cell959); row36.Append(cell960); row36.Append(cell961); row36.Append(cell962); row36.Append(cell963); row36.Append(cell964); row36.Append(cell965); row36.Append(cell966); row36.Append(cell967); row36.Append(cell968); row36.Append(cell969); row36.Append(cell970); row36.Append(cell971); row36.Append(cell972); row36.Append(cell973); row36.Append(cell974); row36.Append(cell975); row36.Append(cell976); row36.Append(cell977); row36.Append(cell978); row36.Append(cell979); row36.Append(cell980); row36.Append(cell981); row36.Append(cell982); row36.Append(cell983); row36.Append(cell984); Row row37 = new Row() { RowIndex = (UInt32Value)40U, Spans = new ListValue<StringValue>() { InnerText = "2:44" } }; Cell cell985 = new Cell() { CellReference = "C40", StyleIndex = (UInt32Value)59U, DataType = CellValues.SharedString }; CellValue cellValue173 = new CellValue(); cellValue173.Text = "39"; cell985.Append(cellValue173); Cell cell986 = new Cell() { CellReference = "D40", StyleIndex = (UInt32Value)60U }; Cell cell987 = new Cell() { CellReference = "E40", StyleIndex = (UInt32Value)60U }; Cell cell988 = new Cell() { CellReference = "F40", StyleIndex = (UInt32Value)60U }; Cell cell989 = new Cell() { CellReference = "G40", StyleIndex = (UInt32Value)76U }; CellFormula cellFormula56 = new CellFormula(); cellFormula56.Text = "SUM(G35:I39)"; CellValue cellValue174 = new CellValue(); cellValue174.Text = "0"; cell989.Append(cellFormula56); cell989.Append(cellValue174); Cell cell990 = new Cell() { CellReference = "H40", StyleIndex = (UInt32Value)77U }; Cell cell991 = new Cell() { CellReference = "I40", StyleIndex = (UInt32Value)78U }; Cell cell992 = new Cell() { CellReference = "AN40", StyleIndex = (UInt32Value)4U }; row37.Append(cell985); row37.Append(cell986); row37.Append(cell987); row37.Append(cell988); row37.Append(cell989); row37.Append(cell990); row37.Append(cell991); row37.Append(cell992); Row row38 = new Row() { RowIndex = (UInt32Value)41U, Spans = new ListValue<StringValue>() { InnerText = "2:44" } }; Cell cell993 = new Cell() { CellReference = "F41", StyleIndex = (UInt32Value)44U }; Cell cell994 = new Cell() { CellReference = "AN41", StyleIndex = (UInt32Value)4U }; row38.Append(cell993); row38.Append(cell994); Row row39 = new Row() { RowIndex = (UInt32Value)42U, Spans = new ListValue<StringValue>() { InnerText = "2:44" } }; Cell cell995 = new Cell() { CellReference = "AN42", StyleIndex = (UInt32Value)4U }; row39.Append(cell995); sheetData1.Append(row1); sheetData1.Append(row2); sheetData1.Append(row3); sheetData1.Append(row4); sheetData1.Append(row5); sheetData1.Append(row6); sheetData1.Append(row7); sheetData1.Append(row8); sheetData1.Append(row9); sheetData1.Append(row10); sheetData1.Append(row11); sheetData1.Append(row12); sheetData1.Append(row13); sheetData1.Append(row14); sheetData1.Append(row15); sheetData1.Append(row16); sheetData1.Append(row17); sheetData1.Append(row18); sheetData1.Append(row19); sheetData1.Append(row20); sheetData1.Append(row21); sheetData1.Append(row22); sheetData1.Append(row23); sheetData1.Append(row24); sheetData1.Append(row25); sheetData1.Append(row26); sheetData1.Append(row27); sheetData1.Append(row28); sheetData1.Append(row29); sheetData1.Append(row30); sheetData1.Append(row31); sheetData1.Append(row32); sheetData1.Append(row33); sheetData1.Append(row34); sheetData1.Append(row35); sheetData1.Append(row36); sheetData1.Append(row37); sheetData1.Append(row38); sheetData1.Append(row39); MergeCells mergeCells1 = new MergeCells() { Count = (UInt32Value)8U }; MergeCell mergeCell1 = new MergeCell() { Reference = "G38:I38" }; MergeCell mergeCell2 = new MergeCell() { Reference = "G39:I39" }; MergeCell mergeCell3 = new MergeCell() { Reference = "G40:I40" }; MergeCell mergeCell4 = new MergeCell() { Reference = "G18:AN18" }; MergeCell mergeCell5 = new MergeCell() { Reference = "G34:I34" }; MergeCell mergeCell6 = new MergeCell() { Reference = "G35:I35" }; MergeCell mergeCell7 = new MergeCell() { Reference = "G36:I36" }; MergeCell mergeCell8 = new MergeCell() { Reference = "G37:I37" }; mergeCells1.Append(mergeCell1); mergeCells1.Append(mergeCell2); mergeCells1.Append(mergeCell3); mergeCells1.Append(mergeCell4); mergeCells1.Append(mergeCell5); mergeCells1.Append(mergeCell6); mergeCells1.Append(mergeCell7); mergeCells1.Append(mergeCell8); PhoneticProperties phoneticProperties1 = new PhoneticProperties() { FontId = (UInt32Value)0U, Type = PhoneticValues.NoConversion }; ConditionalFormatting conditionalFormatting1 = new ConditionalFormatting() { SequenceOfReferences = new ListValue<StringValue>() { InnerText = "G21:AK25" } }; ConditionalFormattingRule conditionalFormattingRule1 = new ConditionalFormattingRule() { Type = ConditionalFormatValues.CellIs, FormatId = (UInt32Value)0U, Priority = 1, Operator = ConditionalFormattingOperatorValues.GreaterThanOrEqual }; Formula formula1 = new Formula(); formula1.Text = "1"; conditionalFormattingRule1.Append(formula1); conditionalFormatting1.Append(conditionalFormattingRule1); PageMargins pageMargins1 = new PageMargins() { Left = 0.75D, Right = 0.75D, Top = 0.91D, Bottom = 1D, Header = 0D, Footer = 0D }; PageSetup pageSetup1 = new PageSetup() { PaperSize = (UInt32Value)9U, Scale = (UInt32Value)52U, Orientation = OrientationValues.Landscape, HorizontalDpi = (UInt32Value)300U, VerticalDpi = (UInt32Value)300U, Id = "rId1" }; HeaderFooter headerFooter1 = new HeaderFooter() { AlignWithMargins = false }; Drawing drawing1 = new Drawing() { Id = "rId2" }; worksheet1.Append(sheetProperties1); worksheet1.Append(sheetDimension1); worksheet1.Append(sheetViews1); worksheet1.Append(sheetFormatProperties1); worksheet1.Append(columns1); worksheet1.Append(sheetData1); worksheet1.Append(mergeCells1); worksheet1.Append(phoneticProperties1); worksheet1.Append(conditionalFormatting1); worksheet1.Append(pageMargins1); worksheet1.Append(pageSetup1); worksheet1.Append(headerFooter1); worksheet1.Append(drawing1); worksheetPart1.Worksheet = worksheet1; }
internal X14.ConditionalFormattingRule ToConditionalFormattingRule() { var cfr = new X14.ConditionalFormattingRule(); if (Type != null) { cfr.Type = Type.Value; } if (Priority != null) { cfr.Priority = Priority.Value; } if (StopIfTrue) { cfr.StopIfTrue = StopIfTrue; } if (!AboveAverage) { cfr.AboveAverage = AboveAverage; } if (Percent) { cfr.Percent = Percent; } if (Bottom) { cfr.Bottom = Bottom; } if (HasOperator) { cfr.Operator = Operator; } if ((Text != null) && (Text.Length > 0)) { cfr.Text = Text; } if (HasTimePeriod) { cfr.TimePeriod = TimePeriod; } if (Rank != null) { cfr.Rank = Rank.Value; } if (StandardDeviation != null) { cfr.StandardDeviation = StandardDeviation.Value; } if (EqualAverage) { cfr.EqualAverage = EqualAverage; } if (ActivePresent) { cfr.ActivePresent = ActivePresent; } if (Id != null) { cfr.Id = Id; } foreach (var f in Formulas) { cfr.Append((Formula)f.CloneNode(true)); } if (HasColorScale) { cfr.Append(ColorScale.ToColorScale()); } if (HasDataBar) { cfr.Append(DataBar.ToDataBar(Priority != null)); } if (HasIconSet) { cfr.Append(IconSet.ToIconSet()); } if (HasDifferentialType) { cfr.Append(DifferentialType.ToDifferentialType()); } return(cfr); }
internal X14.ConditionalFormattingRule ToConditionalFormattingRule() { X14.ConditionalFormattingRule cfr = new X14.ConditionalFormattingRule(); if (this.Type != null) cfr.Type = this.Type.Value; if (this.Priority != null) cfr.Priority = this.Priority.Value; if (this.StopIfTrue) cfr.StopIfTrue = this.StopIfTrue; if (!this.AboveAverage) cfr.AboveAverage = this.AboveAverage; if (this.Percent) cfr.Percent = this.Percent; if (this.Bottom) cfr.Bottom = this.Bottom; if (HasOperator) cfr.Operator = this.Operator; if (this.Text != null && this.Text.Length > 0) cfr.Text = this.Text; if (HasTimePeriod) cfr.TimePeriod = this.TimePeriod; if (this.Rank != null) cfr.Rank = this.Rank.Value; if (this.StandardDeviation != null) cfr.StandardDeviation = this.StandardDeviation.Value; if (this.EqualAverage) cfr.EqualAverage = this.EqualAverage; if (this.ActivePresent) cfr.ActivePresent = this.ActivePresent; if (this.Id != null) cfr.Id = this.Id; foreach (Excel.Formula f in this.Formulas) { cfr.Append((Excel.Formula)f.CloneNode(true)); } if (HasColorScale) cfr.Append(this.ColorScale.ToColorScale()); if (HasDataBar) cfr.Append(this.DataBar.ToDataBar(this.Priority != null)); if (HasIconSet) cfr.Append(this.IconSet.ToIconSet()); if (HasDifferentialType) cfr.Append(this.DifferentialType.ToDifferentialType()); return cfr; }
internal X14.ConditionalFormattingRule ToConditionalFormattingRule() { X14.ConditionalFormattingRule cfr = new X14.ConditionalFormattingRule(); if (this.Type != null) { cfr.Type = this.Type.Value; } if (this.Priority != null) { cfr.Priority = this.Priority.Value; } if (this.StopIfTrue) { cfr.StopIfTrue = this.StopIfTrue; } if (!this.AboveAverage) { cfr.AboveAverage = this.AboveAverage; } if (this.Percent) { cfr.Percent = this.Percent; } if (this.Bottom) { cfr.Bottom = this.Bottom; } if (HasOperator) { cfr.Operator = this.Operator; } if (this.Text != null && this.Text.Length > 0) { cfr.Text = this.Text; } if (HasTimePeriod) { cfr.TimePeriod = this.TimePeriod; } if (this.Rank != null) { cfr.Rank = this.Rank.Value; } if (this.StandardDeviation != null) { cfr.StandardDeviation = this.StandardDeviation.Value; } if (this.EqualAverage) { cfr.EqualAverage = this.EqualAverage; } if (this.ActivePresent) { cfr.ActivePresent = this.ActivePresent; } if (this.Id != null) { cfr.Id = this.Id; } foreach (Excel.Formula f in this.Formulas) { cfr.Append((Excel.Formula)f.CloneNode(true)); } if (HasColorScale) { cfr.Append(this.ColorScale.ToColorScale()); } if (HasDataBar) { cfr.Append(this.DataBar.ToDataBar(this.Priority != null)); } if (HasIconSet) { cfr.Append(this.IconSet.ToIconSet()); } if (HasDifferentialType) { cfr.Append(this.DifferentialType.ToDifferentialType()); } return(cfr); }