예제 #1
0
        public override IMapViewerHighlight[] GetHighlights(Pane pane)
        {
            if (pane != Pane.Map)
                return null;

            return new CourseObj[1] { courseObj };
        }
 public override Cursor GetMouseCursor(Pane pane, PointF location, float pixelSize)
 {
     if (pane == Pane.Topology) {
         return Cursors.SizeAll;
     }
     else {
         return Cursors.Arrow;
     }
 }
        public override void LeftButtonCancelDrag(Pane pane, ref bool displayUpdateNeeded)
        {
            Debug.Assert(pane == Pane.Topology);

            // Drag was cancelled. Go back to normal mode.
            dropTargetHighlight = null;
            displayUpdateNeeded = true;

            controller.DefaultCommandMode();
        }
        public override IMapViewerHighlight[] GetHighlights(Pane pane)
        {
            if (pane != Pane.Topology)
                return null;

            if (dropTargetHighlight == null)
                return new CourseObj[] { courseObjectDrag };
            else
                return new CourseObj[] { courseObjectDrag, dropTargetHighlight };
        }
예제 #5
0
        internal Pane ToPane()
        {
            Pane p = new Pane();
            if (this.HorizontalSplit != 0) p.HorizontalSplit = this.HorizontalSplit;
            if (this.VerticalSplit != 0) p.VerticalSplit = this.VerticalSplit;
            if (this.TopLeftCell != null) p.TopLeftCell = this.TopLeftCell;
            if (this.ActivePane != PaneValues.TopLeft) p.ActivePane = this.ActivePane;
            if (this.State != PaneStateValues.Split) p.State = this.State;

            return p;
        }
예제 #6
0
 public override void Add(Widget c)
 {
     if( front == null )
     {
         front = Find<Pane>("Front");
         if( front == null )
         {
             base.Add( c );
             return;
         }
     }
     front.Add (c);
 }
예제 #7
0
 protected IWebElement SaveAndCloseButton(Pane pane = Pane.Single)
 {
     return(GetInputButton("Save & Close", pane));
 }
예제 #8
0
        protected IWebElement GetButton(string text, Pane pane = Pane.Single)
        {
            string selector = CssSelectorFor(pane) + ".header .action";

            return(wait.Until(dr => dr.FindElements(By.CssSelector(selector)).Single(e => e.Text == text)));
        }
예제 #9
0
 protected IWebElement EditButton(Pane pane = Pane.Single)
 {
     return(GetInputButton("Edit", pane));
 }
예제 #10
0
        public override MapViewer.DragAction LeftButtonDown(Pane pane, PointF location, float pixelSize, ref bool displayUpdateNeeded)
        {
            if (pane != Pane.Map)
                return MapViewer.DragAction.None;

            // Create the new corner
            RotateToAngle(location);
            controller.Rotate(courseObj.orientation);
            controller.DefaultCommandMode();
            return MapViewer.DragAction.None;
        }
예제 #11
0
 // Mouse cursor looks like a move cursor when hovering over something that is selected.
 public virtual Cursor GetMouseCursor(Pane pane, PointF location, float pixelSize)
 {
     return(Cursors.Default);
 }
        private static void GenerateWorksheetPartContent(WorksheetPart worksheetPart, XLWorksheet xlWorksheet,
            SaveContext context)
        {
            #region Worksheet

            if (worksheetPart.Worksheet == null)
                worksheetPart.Worksheet = new Worksheet();

            GenerateTables(xlWorksheet, worksheetPart, context);

            if (
                !worksheetPart.Worksheet.NamespaceDeclarations.Contains(new KeyValuePair<String, String>("r",
                    "http://schemas.openxmlformats.org/officeDocument/2006/relationships")))
            {
                worksheetPart.Worksheet.AddNamespaceDeclaration("r",
                    "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
            }

            #endregion

            var cm = new XLWSContentManager(worksheetPart.Worksheet);

            #region SheetProperties

            if (worksheetPart.Worksheet.SheetProperties == null)
                worksheetPart.Worksheet.SheetProperties = new SheetProperties();

            worksheetPart.Worksheet.SheetProperties.TabColor = xlWorksheet.TabColor.HasValue
                ? GetTabColor(xlWorksheet.TabColor)
                : null;

            cm.SetElement(XLWSContentManager.XLWSContents.SheetProperties, worksheetPart.Worksheet.SheetProperties);

            if (worksheetPart.Worksheet.SheetProperties.OutlineProperties == null)
                worksheetPart.Worksheet.SheetProperties.OutlineProperties = new OutlineProperties();

            worksheetPart.Worksheet.SheetProperties.OutlineProperties.SummaryBelow =
                (xlWorksheet.Outline.SummaryVLocation ==
                 XLOutlineSummaryVLocation.Bottom);
            worksheetPart.Worksheet.SheetProperties.OutlineProperties.SummaryRight =
                (xlWorksheet.Outline.SummaryHLocation ==
                 XLOutlineSummaryHLocation.Right);

            if (worksheetPart.Worksheet.SheetProperties.PageSetupProperties == null
                && (xlWorksheet.PageSetup.PagesTall > 0 || xlWorksheet.PageSetup.PagesWide > 0))
                worksheetPart.Worksheet.SheetProperties.PageSetupProperties = new PageSetupProperties {FitToPage = true};

            #endregion

            var maxColumn = 0;

            var sheetDimensionReference = "A1";
            if (xlWorksheet.Internals.CellsCollection.Count > 0)
            {
                maxColumn = xlWorksheet.Internals.CellsCollection.MaxColumnUsed;
                var maxRow = xlWorksheet.Internals.CellsCollection.MaxRowUsed;
                sheetDimensionReference = "A1:" + XLHelper.GetColumnLetterFromNumber(maxColumn) +
                                          maxRow.ToStringLookup();
            }

            if (xlWorksheet.Internals.ColumnsCollection.Count > 0)
            {
                var maxColCollection = xlWorksheet.Internals.ColumnsCollection.Keys.Max();
                if (maxColCollection > maxColumn)
                    maxColumn = maxColCollection;
            }

            #region SheetViews

            if (worksheetPart.Worksheet.SheetDimension == null)
                worksheetPart.Worksheet.SheetDimension = new SheetDimension {Reference = sheetDimensionReference};

            cm.SetElement(XLWSContentManager.XLWSContents.SheetDimension, worksheetPart.Worksheet.SheetDimension);

            if (worksheetPart.Worksheet.SheetViews == null)
                worksheetPart.Worksheet.SheetViews = new SheetViews();

            cm.SetElement(XLWSContentManager.XLWSContents.SheetViews, worksheetPart.Worksheet.SheetViews);

            var sheetView = (SheetView)worksheetPart.Worksheet.SheetViews.FirstOrDefault();
            if (sheetView == null)
            {
                sheetView = new SheetView {WorkbookViewId = 0U};
                worksheetPart.Worksheet.SheetViews.AppendChild(sheetView);
            }

            if (xlWorksheet.TabSelected)
                sheetView.TabSelected = true;
            else
                sheetView.TabSelected = null;


            if (xlWorksheet.ShowFormulas)
                sheetView.ShowFormulas = true;
            else
                sheetView.ShowFormulas = null;

            if (xlWorksheet.ShowGridLines)
                sheetView.ShowGridLines = null;
            else
                sheetView.ShowGridLines = false;

            if (xlWorksheet.ShowOutlineSymbols)
                sheetView.ShowOutlineSymbols = null;
            else
                sheetView.ShowOutlineSymbols = false;

            if (xlWorksheet.ShowRowColHeaders)
                sheetView.ShowRowColHeaders = null;
            else
                sheetView.ShowRowColHeaders = false;

            if (xlWorksheet.ShowRuler)
                sheetView.ShowRuler = null;
            else
                sheetView.ShowRuler = false;

            if (xlWorksheet.ShowWhiteSpace)
                sheetView.ShowWhiteSpace = null;
            else
                sheetView.ShowWhiteSpace = false;

            if (xlWorksheet.ShowZeros)
                sheetView.ShowZeros = null;
            else
                sheetView.ShowZeros = false;

            if (xlWorksheet.RightToLeft)
                sheetView.RightToLeft = true;
            else
                sheetView.RightToLeft = null;

            if (xlWorksheet.SheetView.View == XLSheetViewOptions.Normal)
                sheetView.View = null;
            else
                sheetView.View = xlWorksheet.SheetView.View.ToOpenXml();

            var pane = sheetView.Elements<Pane>().FirstOrDefault();
            if (pane == null)
            {
                pane = new Pane();
                sheetView.AppendChild(pane);
            }


            pane.State = PaneStateValues.FrozenSplit;
            Double hSplit = xlWorksheet.SheetView.SplitColumn;
            Double ySplit = xlWorksheet.SheetView.SplitRow;


            pane.HorizontalSplit = hSplit;
            pane.VerticalSplit = ySplit;

            pane.TopLeftCell = XLHelper.GetColumnLetterFromNumber(xlWorksheet.SheetView.SplitColumn + 1)
                               + (xlWorksheet.SheetView.SplitRow + 1);

            if (hSplit == 0 && ySplit == 0)
                sheetView.RemoveAllChildren<Pane>();

            if (xlWorksheet.SelectedRanges.Any() || xlWorksheet.ActiveCell != null)
            {
                sheetView.RemoveAllChildren<Selection>();

                var firstSelection = xlWorksheet.SelectedRanges.FirstOrDefault();
                var selection = new Selection();
                if (xlWorksheet.ActiveCell != null)
                    selection.ActiveCell = xlWorksheet.ActiveCell.Address.ToStringRelative(false);
                else if (firstSelection != null)
                    selection.ActiveCell = firstSelection.RangeAddress.FirstAddress.ToStringRelative(false);


                var seqRef = new List<String> {selection.ActiveCell.Value};
                seqRef.AddRange(xlWorksheet.SelectedRanges
                    .Select(range => range.RangeAddress.ToStringRelative(false)));


                selection.SequenceOfReferences = new ListValue<StringValue> {InnerText = String.Join(" ", seqRef.Distinct().ToArray())};

                sheetView.Append(selection);
            }

            #endregion

            var maxOutlineColumn = 0;
            if (xlWorksheet.ColumnCount() > 0)
                maxOutlineColumn = xlWorksheet.GetMaxColumnOutline();

            var maxOutlineRow = 0;
            if (xlWorksheet.RowCount() > 0)
                maxOutlineRow = xlWorksheet.GetMaxRowOutline();

            #region SheetFormatProperties

            if (worksheetPart.Worksheet.SheetFormatProperties == null)
                worksheetPart.Worksheet.SheetFormatProperties = new SheetFormatProperties();

            cm.SetElement(XLWSContentManager.XLWSContents.SheetFormatProperties,
                worksheetPart.Worksheet.SheetFormatProperties);

            worksheetPart.Worksheet.SheetFormatProperties.DefaultRowHeight = xlWorksheet.RowHeight;

            if (xlWorksheet.RowHeightChanged)
                worksheetPart.Worksheet.SheetFormatProperties.CustomHeight = true;
            else
                worksheetPart.Worksheet.SheetFormatProperties.CustomHeight = null;


            var worksheetColumnWidth = GetColumnWidth(xlWorksheet.ColumnWidth);
            if (xlWorksheet.ColumnWidthChanged)
                worksheetPart.Worksheet.SheetFormatProperties.DefaultColumnWidth = worksheetColumnWidth;
            else
                worksheetPart.Worksheet.SheetFormatProperties.DefaultColumnWidth = null;


            if (maxOutlineColumn > 0)
                worksheetPart.Worksheet.SheetFormatProperties.OutlineLevelColumn = (byte)maxOutlineColumn;
            else
                worksheetPart.Worksheet.SheetFormatProperties.OutlineLevelColumn = null;

            if (maxOutlineRow > 0)
                worksheetPart.Worksheet.SheetFormatProperties.OutlineLevelRow = (byte)maxOutlineRow;
            else
                worksheetPart.Worksheet.SheetFormatProperties.OutlineLevelRow = null;

            #endregion

            #region Columns

            if (xlWorksheet.Internals.CellsCollection.Count == 0 &&
                xlWorksheet.Internals.ColumnsCollection.Count == 0
                && xlWorksheet.Style.Equals(DefaultStyle))
                worksheetPart.Worksheet.RemoveAllChildren<Columns>();
            else
            {
                if (!worksheetPart.Worksheet.Elements<Columns>().Any())
                {
                    var previousElement = cm.GetPreviousElementFor(XLWSContentManager.XLWSContents.Columns);
                    worksheetPart.Worksheet.InsertAfter(new Columns(), previousElement);
                }

                var columns = worksheetPart.Worksheet.Elements<Columns>().First();
                cm.SetElement(XLWSContentManager.XLWSContents.Columns, columns);

                var sheetColumnsByMin = columns.Elements<Column>().ToDictionary(c => c.Min.Value, c => c);
                //Dictionary<UInt32, Column> sheetColumnsByMax = columns.Elements<Column>().ToDictionary(c => c.Max.Value, c => c);

                Int32 minInColumnsCollection;
                Int32 maxInColumnsCollection;
                if (xlWorksheet.Internals.ColumnsCollection.Count > 0)
                {
                    minInColumnsCollection = xlWorksheet.Internals.ColumnsCollection.Keys.Min();
                    maxInColumnsCollection = xlWorksheet.Internals.ColumnsCollection.Keys.Max();
                }
                else
                {
                    minInColumnsCollection = 1;
                    maxInColumnsCollection = 0;
                }

                var worksheetStyleId = context.SharedStyles[xlWorksheet.GetStyleId()].StyleId;
                if (minInColumnsCollection > 1)
                {
                    UInt32Value min = 1;
                    UInt32Value max = (UInt32)(minInColumnsCollection - 1);


                    for (var co = min; co <= max; co++)
                    {
                        var column = new Column
                        {
                            Min = co,
                            Max = co,
                            Style = worksheetStyleId,
                            Width = worksheetColumnWidth,
                            CustomWidth = true
                        };

                        UpdateColumn(column, columns, sheetColumnsByMin); //, sheetColumnsByMax);
                    }
                }

                for (var co = minInColumnsCollection; co <= maxInColumnsCollection; co++)
                {
                    UInt32 styleId;
                    Double columnWidth;
                    var isHidden = false;
                    var collapsed = false;
                    var outlineLevel = 0;
                    if (xlWorksheet.Internals.ColumnsCollection.ContainsKey(co))
                    {
                        styleId = context.SharedStyles[xlWorksheet.Internals.ColumnsCollection[co].GetStyleId()].StyleId;
                        columnWidth = GetColumnWidth(xlWorksheet.Internals.ColumnsCollection[co].Width);
                        isHidden = xlWorksheet.Internals.ColumnsCollection[co].IsHidden;
                        collapsed = xlWorksheet.Internals.ColumnsCollection[co].Collapsed;
                        outlineLevel = xlWorksheet.Internals.ColumnsCollection[co].OutlineLevel;
                    }
                    else
                    {
                        styleId = context.SharedStyles[xlWorksheet.GetStyleId()].StyleId;
                        columnWidth = worksheetColumnWidth;
                    }

                    var column = new Column
                    {
                        Min = (UInt32)co,
                        Max = (UInt32)co,
                        Style = styleId,
                        Width = columnWidth,
                        CustomWidth = true
                    };

                    if (isHidden)
                        column.Hidden = true;
                    if (collapsed)
                        column.Collapsed = true;
                    if (outlineLevel > 0)
                        column.OutlineLevel = (byte)outlineLevel;

                    UpdateColumn(column, columns, sheetColumnsByMin); //, sheetColumnsByMax);
                }

                var collection = maxInColumnsCollection;
                foreach (
                    var col in
                        columns.Elements<Column>().Where(c => c.Min > (UInt32)(collection)).OrderBy(
                            c => c.Min.Value))
                {
                    col.Style = worksheetStyleId;
                    col.Width = worksheetColumnWidth;
                    col.CustomWidth = true;

                    if ((Int32)col.Max.Value > maxInColumnsCollection)
                        maxInColumnsCollection = (Int32)col.Max.Value;
                }

                if (maxInColumnsCollection < XLHelper.MaxColumnNumber && !xlWorksheet.Style.Equals(DefaultStyle))
                {
                    var column = new Column
                    {
                        Min = (UInt32)(maxInColumnsCollection + 1),
                        Max = (UInt32)(XLHelper.MaxColumnNumber),
                        Style = worksheetStyleId,
                        Width = worksheetColumnWidth,
                        CustomWidth = true
                    };
                    columns.AppendChild(column);
                }

                CollapseColumns(columns, sheetColumnsByMin);

                if (!columns.Any())
                {
                    worksheetPart.Worksheet.RemoveAllChildren<Columns>();
                    cm.SetElement(XLWSContentManager.XLWSContents.Columns, null);
                }
            }

            #endregion

            #region SheetData

            if (!worksheetPart.Worksheet.Elements<SheetData>().Any())
            {
                var previousElement = cm.GetPreviousElementFor(XLWSContentManager.XLWSContents.SheetData);
                worksheetPart.Worksheet.InsertAfter(new SheetData(), previousElement);
            }

            var sheetData = worksheetPart.Worksheet.Elements<SheetData>().First();
            cm.SetElement(XLWSContentManager.XLWSContents.SheetData, sheetData);

            var cellsByRow = new Dictionary<Int32, List<IXLCell>>();
            foreach (var c in xlWorksheet.Internals.CellsCollection.GetCells())
            {
                var rowNum = c.Address.RowNumber;
                if (!cellsByRow.ContainsKey(rowNum))
                    cellsByRow.Add(rowNum, new List<IXLCell>());

                cellsByRow[rowNum].Add(c);
            }

            var lastRow = 0;
            var sheetDataRows =
                sheetData.Elements<Row>().ToDictionary(r => r.RowIndex == null ? ++lastRow : (Int32)r.RowIndex.Value,
                    r => r);
            foreach (
                var r in
                    xlWorksheet.Internals.RowsCollection.Deleted.Where(r => sheetDataRows.ContainsKey(r.Key)))
            {
                sheetData.RemoveChild(sheetDataRows[r.Key]);
                sheetDataRows.Remove(r.Key);
                xlWorksheet.Internals.CellsCollection.Deleted.RemoveWhere(d => d.Row == r.Key);
            }

            var distinctRows = cellsByRow.Keys.Union(xlWorksheet.Internals.RowsCollection.Keys);
            var noRows = (sheetData.Elements<Row>().FirstOrDefault() == null);
            foreach (var distinctRow in distinctRows.OrderBy(r => r))
            {
                Row row; // = sheetData.Elements<Row>().FirstOrDefault(r => r.RowIndex.Value == (UInt32)distinctRow);
                if (sheetDataRows.ContainsKey(distinctRow))
                    row = sheetDataRows[distinctRow];
                else
                {
                    row = new Row {RowIndex = (UInt32)distinctRow};
                    if (noRows)
                    {
                        sheetData.AppendChild(row);
                        noRows = false;
                    }
                    else
                    {
                        if (sheetDataRows.Any(r => r.Key > row.RowIndex.Value))
                        {
                            var minRow = sheetDataRows.Where(r => r.Key > (Int32)row.RowIndex.Value).Min(r => r.Key);
                            var rowBeforeInsert = sheetDataRows[minRow];
                            sheetData.InsertBefore(row, rowBeforeInsert);
                        }
                        else
                            sheetData.AppendChild(row);
                    }
                }

                if (maxColumn > 0)
                    row.Spans = new ListValue<StringValue> {InnerText = "1:" + maxColumn.ToStringLookup()};

                row.Height = null;
                row.CustomHeight = null;
                row.Hidden = null;
                row.StyleIndex = null;
                row.CustomFormat = null;
                row.Collapsed = null;
                if (xlWorksheet.Internals.RowsCollection.ContainsKey(distinctRow))
                {
                    var thisRow = xlWorksheet.Internals.RowsCollection[distinctRow];
                    if (thisRow.HeightChanged)
                    {
                        row.Height = thisRow.Height;
                        row.CustomHeight = true;
                        row.CustomFormat = true;
                    }

                    if (thisRow.GetStyleId() != xlWorksheet.GetStyleId())
                    {
                        row.StyleIndex = context.SharedStyles[thisRow.GetStyleId()].StyleId;
                        row.CustomFormat = true;
                    }

                    if (thisRow.IsHidden)
                        row.Hidden = true;
                    if (thisRow.Collapsed)
                        row.Collapsed = true;
                    if (thisRow.OutlineLevel > 0)
                        row.OutlineLevel = (byte)thisRow.OutlineLevel;
                }

                var lastCell = 0;
                var cellsByReference = row.Elements<Cell>().ToDictionary(c => c.CellReference == null
                    ? XLHelper.GetColumnLetterFromNumber(
                        ++lastCell) + distinctRow
                    : c.CellReference.Value, c => c);

                foreach (var c in xlWorksheet.Internals.CellsCollection.Deleted.ToList())
                {
                    var key = XLHelper.GetColumnLetterFromNumber(c.Column) + c.Row.ToStringLookup();
                    if (!cellsByReference.ContainsKey(key)) continue;
                    row.RemoveChild(cellsByReference[key]);
                    xlWorksheet.Internals.CellsCollection.Deleted.Remove(c);
                }

                if (!cellsByRow.ContainsKey(distinctRow)) continue;

                var isNewRow = !row.Elements<Cell>().Any();
                var mRows = row.Elements<Cell>().ToDictionary(c => XLHelper.GetColumnNumberFromAddress(c.CellReference.Value), c => c);
                foreach (var opCell in cellsByRow[distinctRow]
                    .OrderBy(c => c.Address.ColumnNumber)
                    .Select(c => (XLCell)c))
                {
                    var styleId = context.SharedStyles[opCell.GetStyleId()].StyleId;

                    var dataType = opCell.DataType;
                    var cellReference = (opCell.Address).GetTrimmedAddress();

                    Cell cell;
                    if (cellsByReference.ContainsKey(cellReference))
                        cell = cellsByReference[cellReference];
                    else
                    {
                        cell = new Cell {CellReference = new StringValue(cellReference)};
                        if (isNewRow)
                            row.AppendChild(cell);
                        else
                        {
                            var newColumn = XLHelper.GetColumnNumberFromAddress(cellReference);

                            Cell cellBeforeInsert = null;
                            int[] lastCo = {Int32.MaxValue};
                            foreach (var c in mRows.Where(kp => kp.Key > newColumn).Where(c => lastCo[0] > c.Key))
                            {
                                cellBeforeInsert = c.Value;
                                lastCo[0] = c.Key;
                            }
                            if (cellBeforeInsert == null)
                                row.AppendChild(cell);
                            else
                                row.InsertBefore(cell, cellBeforeInsert);
                        }
                    }

                    cell.StyleIndex = styleId;
                    var formula = opCell.FormulaA1;
                    if (opCell.HasFormula)
                    {
                        if (formula.StartsWith("{"))
                        {
                            formula = formula.Substring(1, formula.Length - 2);
                            var f = new CellFormula {FormulaType = CellFormulaValues.Array};
                            
                            if (opCell.FormulaReference.FirstAddress.Equals(opCell.Address))
                            {
                                f.Text = formula;
                                f.Reference = opCell.FormulaReference.ToStringRelative();
                            }

                            cell.CellFormula = f;
                        }
                        else
                            cell.CellFormula = new CellFormula(formula);

                        cell.CellValue = null;
                    }
                    else
                    {
                        cell.CellFormula = null;

                        cell.DataType = opCell.DataType == XLCellValues.DateTime ? null : GetCellValue(opCell);

                        var cellValue = new CellValue();
                        if (dataType == XLCellValues.Text)
                        {
                            if (opCell.InnerText.Length == 0)
                                cell.CellValue = null;
                            else
                            {
                                if (opCell.ShareString)
                                {
                                    cellValue.Text = opCell.SharedStringId.ToString();
                                    cell.CellValue = cellValue;
                                }
                                else
                                {
                                    var text = opCell.GetString();
                                    var t = new Text(text);
                                    if (text.PreserveSpaces())
                                        t.Space = SpaceProcessingModeValues.Preserve;

                                    cell.InlineString = new InlineString {Text = t};
                                }
                            }
                        }
                        else if (dataType == XLCellValues.TimeSpan)
                        {
                            var timeSpan = opCell.GetTimeSpan();
                            cellValue.Text =
                                XLCell.BaseDate.Add(timeSpan).ToOADate().ToString(CultureInfo.InvariantCulture);
                            cell.CellValue = cellValue;
                        }
                        else if (dataType == XLCellValues.DateTime || dataType == XLCellValues.Number)
                        {
                            if (!XLHelper.IsNullOrWhiteSpace(opCell.InnerText))
                                cellValue.Text = Double.Parse(opCell.InnerText).ToString(CultureInfo.InvariantCulture);
                            cell.CellValue = cellValue;
                        }
                        else
                        {
                            cellValue.Text = opCell.InnerText;
                            cell.CellValue = cellValue;
                        }
                    }
                }
                xlWorksheet.Internals.CellsCollection.Deleted.RemoveWhere(d => d.Row == distinctRow);
            }
            foreach (
                var r in
                    xlWorksheet.Internals.CellsCollection.Deleted.Select(c => c.Row).Distinct().Where(
                        sheetDataRows.ContainsKey))
            {
                sheetData.RemoveChild(sheetDataRows[r]);
                sheetDataRows.Remove(r);
            }

            #endregion

            #region SheetProtection

            if (xlWorksheet.Protection.Protected)
            {
                if (!worksheetPart.Worksheet.Elements<SheetProtection>().Any())
                {
                    var previousElement = cm.GetPreviousElementFor(XLWSContentManager.XLWSContents.SheetProtection);
                    worksheetPart.Worksheet.InsertAfter(new SheetProtection(), previousElement);
                }

                var sheetProtection = worksheetPart.Worksheet.Elements<SheetProtection>().First();
                cm.SetElement(XLWSContentManager.XLWSContents.SheetProtection, sheetProtection);

                var protection = xlWorksheet.Protection;
                sheetProtection.Sheet = protection.Protected;
                if (!XLHelper.IsNullOrWhiteSpace(protection.PasswordHash))
                    sheetProtection.Password = protection.PasswordHash;
                sheetProtection.FormatCells = GetBooleanValue(!protection.FormatCells, true);
                sheetProtection.FormatColumns = GetBooleanValue(!protection.FormatColumns, true);
                sheetProtection.FormatRows = GetBooleanValue(!protection.FormatRows, true);
                sheetProtection.InsertColumns = GetBooleanValue(!protection.InsertColumns, true);
                sheetProtection.InsertHyperlinks = GetBooleanValue(!protection.InsertHyperlinks, true);
                sheetProtection.InsertRows = GetBooleanValue(!protection.InsertRows, true);
                sheetProtection.DeleteColumns = GetBooleanValue(!protection.DeleteColumns, true);
                sheetProtection.DeleteRows = GetBooleanValue(!protection.DeleteRows, true);
                sheetProtection.AutoFilter = GetBooleanValue(!protection.AutoFilter, true);
                sheetProtection.PivotTables = GetBooleanValue(!protection.PivotTables, true);
                sheetProtection.Sort = GetBooleanValue(!protection.Sort, true);
                sheetProtection.SelectLockedCells = GetBooleanValue(!protection.SelectLockedCells, false);
                sheetProtection.SelectUnlockedCells = GetBooleanValue(!protection.SelectUnlockedCells, false);
            }
            else
            {
                worksheetPart.Worksheet.RemoveAllChildren<SheetProtection>();
                cm.SetElement(XLWSContentManager.XLWSContents.SheetProtection, null);
            }

            #endregion

            #region AutoFilter

            worksheetPart.Worksheet.RemoveAllChildren<AutoFilter>();
            if (xlWorksheet.AutoFilter.Enabled)
            {
                var previousElement = cm.GetPreviousElementFor(XLWSContentManager.XLWSContents.AutoFilter);
                worksheetPart.Worksheet.InsertAfter(new AutoFilter(), previousElement);


                var autoFilter = worksheetPart.Worksheet.Elements<AutoFilter>().First();
                cm.SetElement(XLWSContentManager.XLWSContents.AutoFilter, autoFilter);

                PopulateAutoFilter(xlWorksheet.AutoFilter, autoFilter);
            }
            else
            {
                cm.SetElement(XLWSContentManager.XLWSContents.AutoFilter, null);
            }

            #endregion

            #region MergeCells

            if ((xlWorksheet).Internals.MergedRanges.Any())
            {
                if (!worksheetPart.Worksheet.Elements<MergeCells>().Any())
                {
                    var previousElement = cm.GetPreviousElementFor(XLWSContentManager.XLWSContents.MergeCells);
                    worksheetPart.Worksheet.InsertAfter(new MergeCells(), previousElement);
                }

                var mergeCells = worksheetPart.Worksheet.Elements<MergeCells>().First();
                cm.SetElement(XLWSContentManager.XLWSContents.MergeCells, mergeCells);
                mergeCells.RemoveAllChildren<MergeCell>();

                foreach (var mergeCell in (xlWorksheet).Internals.MergedRanges.Select(
                    m => m.RangeAddress.FirstAddress.ToString() + ":" + m.RangeAddress.LastAddress.ToString()).Select(
                        merged => new MergeCell {Reference = merged}))
                    mergeCells.AppendChild(mergeCell);

                mergeCells.Count = (UInt32)mergeCells.Count();
            }
            else
            {
                worksheetPart.Worksheet.RemoveAllChildren<MergeCells>();
                cm.SetElement(XLWSContentManager.XLWSContents.MergeCells, null);
            }

            #endregion

            #region Conditional Formatting

            if (!xlWorksheet.ConditionalFormats.Any())
            {
                worksheetPart.Worksheet.RemoveAllChildren<ConditionalFormatting>();
                cm.SetElement(XLWSContentManager.XLWSContents.ConditionalFormatting, null);
            }
            else
            {
                worksheetPart.Worksheet.RemoveAllChildren<ConditionalFormatting>();
                var previousElement = cm.GetPreviousElementFor(XLWSContentManager.XLWSContents.ConditionalFormatting);


                //if (!worksheetPart.Worksheet.Elements<ConditionalFormatting>().Any())
                //{
                //    var previousElement = cm.GetPreviousElementFor(XLWSContentManager.XLWSContents.ConditionalFormatting);
                //    worksheetPart.Worksheet.InsertAfter(new ConditionalFormatting(), previousElement);
                //}

                //var conditionalFormats = worksheetPart.Worksheet.Elements<ConditionalFormatting>().First();
                //cm.SetElement(XLWSContentManager.XLWSContents.ConditionalFormatting, conditionalFormats);
                ////conditionalFormats.RemoveAllChildren<ConditionalFormat>();
                var priority = 0;
                foreach (var cf in xlWorksheet.ConditionalFormats)
                {
                    priority++;
                    var conditionalFormatting = new ConditionalFormatting
                    {
                        SequenceOfReferences =
                            new ListValue<StringValue> {InnerText = cf.Range.RangeAddress.ToStringRelative(false)}
                    };
                    conditionalFormatting.Append(XLCFConverters.Convert(cf, priority, context));

                    worksheetPart.Worksheet.InsertAfter(conditionalFormatting, previousElement);
                    previousElement = conditionalFormatting;
                    cm.SetElement(XLWSContentManager.XLWSContents.ConditionalFormatting, conditionalFormatting);
                }
            }

            #endregion

            #region DataValidations

            if (!xlWorksheet.DataValidations.Any(d => d.IsDirty()))
            {
                worksheetPart.Worksheet.RemoveAllChildren<DataValidations>();
                cm.SetElement(XLWSContentManager.XLWSContents.DataValidations, null);
            }
            else
            {
                if (!worksheetPart.Worksheet.Elements<DataValidations>().Any())
                {
                    var previousElement = cm.GetPreviousElementFor(XLWSContentManager.XLWSContents.DataValidations);
                    worksheetPart.Worksheet.InsertAfter(new DataValidations(), previousElement);
                }

                var dataValidations = worksheetPart.Worksheet.Elements<DataValidations>().First();
                cm.SetElement(XLWSContentManager.XLWSContents.DataValidations, dataValidations);
                dataValidations.RemoveAllChildren<DataValidation>();
                foreach (var dv in xlWorksheet.DataValidations)
                {
                    var sequence = dv.Ranges.Aggregate(String.Empty, (current, r) => current + (r.RangeAddress + " "));

                    if (sequence.Length > 0)
                        sequence = sequence.Substring(0, sequence.Length - 1);

                    var dataValidation = new DataValidation
                    {
                        AllowBlank = dv.IgnoreBlanks,
                        Formula1 = new Formula1(dv.MinValue),
                        Formula2 = new Formula2(dv.MaxValue),
                        Type = dv.AllowedValues.ToOpenXml(),
                        ShowErrorMessage = dv.ShowErrorMessage,
                        Prompt = dv.InputMessage,
                        PromptTitle = dv.InputTitle,
                        ErrorTitle = dv.ErrorTitle,
                        Error = dv.ErrorMessage,
                        ShowDropDown = !dv.InCellDropdown,
                        ShowInputMessage = dv.ShowInputMessage,
                        ErrorStyle = dv.ErrorStyle.ToOpenXml(),
                        Operator = dv.Operator.ToOpenXml(),
                        SequenceOfReferences =
                            new ListValue<StringValue> {InnerText = sequence}
                    };

                    dataValidations.AppendChild(dataValidation);
                }
                dataValidations.Count = (UInt32)xlWorksheet.DataValidations.Count();
            }

            #endregion

            #region Hyperlinks

            var relToRemove = worksheetPart.HyperlinkRelationships.ToList();
            relToRemove.ForEach(worksheetPart.DeleteReferenceRelationship);
            if (!xlWorksheet.Hyperlinks.Any())
            {
                worksheetPart.Worksheet.RemoveAllChildren<Hyperlinks>();
                cm.SetElement(XLWSContentManager.XLWSContents.Hyperlinks, null);
            }
            else
            {
                if (!worksheetPart.Worksheet.Elements<Hyperlinks>().Any())
                {
                    var previousElement = cm.GetPreviousElementFor(XLWSContentManager.XLWSContents.Hyperlinks);
                    worksheetPart.Worksheet.InsertAfter(new Hyperlinks(), previousElement);
                }

                var hyperlinks = worksheetPart.Worksheet.Elements<Hyperlinks>().First();
                cm.SetElement(XLWSContentManager.XLWSContents.Hyperlinks, hyperlinks);
                hyperlinks.RemoveAllChildren<Hyperlink>();
                foreach (var hl in xlWorksheet.Hyperlinks)
                {
                    Hyperlink hyperlink;
                    if (hl.IsExternal)
                    {
                        var rId = context.RelIdGenerator.GetNext(RelType.Workbook);
                        hyperlink = new Hyperlink {Reference = hl.Cell.Address.ToString(), Id = rId};
                        worksheetPart.AddHyperlinkRelationship(hl.ExternalAddress, true, rId);
                    }
                    else
                    {
                        hyperlink = new Hyperlink
                        {
                            Reference = hl.Cell.Address.ToString(),
                            Location = hl.InternalAddress,
                            Display = hl.Cell.GetFormattedString()
                        };
                    }
                    if (!XLHelper.IsNullOrWhiteSpace(hl.Tooltip))
                        hyperlink.Tooltip = hl.Tooltip;
                    hyperlinks.AppendChild(hyperlink);
                }
            }

            #endregion

            #region PrintOptions

            if (!worksheetPart.Worksheet.Elements<PrintOptions>().Any())
            {
                var previousElement = cm.GetPreviousElementFor(XLWSContentManager.XLWSContents.PrintOptions);
                worksheetPart.Worksheet.InsertAfter(new PrintOptions(), previousElement);
            }

            var printOptions = worksheetPart.Worksheet.Elements<PrintOptions>().First();
            cm.SetElement(XLWSContentManager.XLWSContents.PrintOptions, printOptions);

            printOptions.HorizontalCentered = xlWorksheet.PageSetup.CenterHorizontally;
            printOptions.VerticalCentered = xlWorksheet.PageSetup.CenterVertically;
            printOptions.Headings = xlWorksheet.PageSetup.ShowRowAndColumnHeadings;
            printOptions.GridLines = xlWorksheet.PageSetup.ShowGridlines;

            #endregion

            #region PageMargins

            if (!worksheetPart.Worksheet.Elements<PageMargins>().Any())
            {
                var previousElement = cm.GetPreviousElementFor(XLWSContentManager.XLWSContents.PageMargins);
                worksheetPart.Worksheet.InsertAfter(new PageMargins(), previousElement);
            }

            var pageMargins = worksheetPart.Worksheet.Elements<PageMargins>().First();
            cm.SetElement(XLWSContentManager.XLWSContents.PageMargins, pageMargins);
            pageMargins.Left = xlWorksheet.PageSetup.Margins.Left;
            pageMargins.Right = xlWorksheet.PageSetup.Margins.Right;
            pageMargins.Top = xlWorksheet.PageSetup.Margins.Top;
            pageMargins.Bottom = xlWorksheet.PageSetup.Margins.Bottom;
            pageMargins.Header = xlWorksheet.PageSetup.Margins.Header;
            pageMargins.Footer = xlWorksheet.PageSetup.Margins.Footer;

            #endregion

            #region PageSetup

            if (!worksheetPart.Worksheet.Elements<PageSetup>().Any())
            {
                var previousElement = cm.GetPreviousElementFor(XLWSContentManager.XLWSContents.PageSetup);
                worksheetPart.Worksheet.InsertAfter(new PageSetup(), previousElement);
            }

            var pageSetup = worksheetPart.Worksheet.Elements<PageSetup>().First();
            cm.SetElement(XLWSContentManager.XLWSContents.PageSetup, pageSetup);

            pageSetup.Orientation = xlWorksheet.PageSetup.PageOrientation.ToOpenXml();
            pageSetup.PaperSize = (UInt32)xlWorksheet.PageSetup.PaperSize;
            pageSetup.BlackAndWhite = xlWorksheet.PageSetup.BlackAndWhite;
            pageSetup.Draft = xlWorksheet.PageSetup.DraftQuality;
            pageSetup.PageOrder = xlWorksheet.PageSetup.PageOrder.ToOpenXml();
            pageSetup.CellComments = xlWorksheet.PageSetup.ShowComments.ToOpenXml();
            pageSetup.Errors = xlWorksheet.PageSetup.PrintErrorValue.ToOpenXml();

            if (xlWorksheet.PageSetup.FirstPageNumber > 0)
            {
                pageSetup.FirstPageNumber = (UInt32)xlWorksheet.PageSetup.FirstPageNumber;
                pageSetup.UseFirstPageNumber = true;
            }
            else
            {
                pageSetup.FirstPageNumber = null;
                pageSetup.UseFirstPageNumber = null;
            }

            if (xlWorksheet.PageSetup.HorizontalDpi > 0)
                pageSetup.HorizontalDpi = (UInt32)xlWorksheet.PageSetup.HorizontalDpi;
            else
                pageSetup.HorizontalDpi = null;

            if (xlWorksheet.PageSetup.VerticalDpi > 0)
                pageSetup.VerticalDpi = (UInt32)xlWorksheet.PageSetup.VerticalDpi;
            else
                pageSetup.VerticalDpi = null;

            if (xlWorksheet.PageSetup.Scale > 0)
            {
                pageSetup.Scale = (UInt32)xlWorksheet.PageSetup.Scale;
                pageSetup.FitToWidth = null;
                pageSetup.FitToHeight = null;
            }
            else
            {
                pageSetup.Scale = null;

                if (xlWorksheet.PageSetup.PagesWide > 0)
                    pageSetup.FitToWidth = (UInt32)xlWorksheet.PageSetup.PagesWide;
                else
                    pageSetup.FitToWidth = 0;

                if (xlWorksheet.PageSetup.PagesTall > 0)
                    pageSetup.FitToHeight = (UInt32)xlWorksheet.PageSetup.PagesTall;
                else
                    pageSetup.FitToHeight = 0;
            }

            #endregion

            #region HeaderFooter

            var headerFooter = worksheetPart.Worksheet.Elements<HeaderFooter>().FirstOrDefault();
            if (headerFooter == null)
                headerFooter = new HeaderFooter();
            else
                worksheetPart.Worksheet.RemoveAllChildren<HeaderFooter>();

            {
                var previousElement = cm.GetPreviousElementFor(XLWSContentManager.XLWSContents.HeaderFooter);
                worksheetPart.Worksheet.InsertAfter(headerFooter, previousElement);
                cm.SetElement(XLWSContentManager.XLWSContents.HeaderFooter, headerFooter);
            }
            if (((XLHeaderFooter)xlWorksheet.PageSetup.Header).Changed
                || ((XLHeaderFooter)xlWorksheet.PageSetup.Footer).Changed)
            {
                //var headerFooter = worksheetPart.Worksheet.Elements<HeaderFooter>().First();

                headerFooter.RemoveAllChildren();

                headerFooter.ScaleWithDoc = xlWorksheet.PageSetup.ScaleHFWithDocument;
                headerFooter.AlignWithMargins = xlWorksheet.PageSetup.AlignHFWithMargins;
                headerFooter.DifferentFirst = xlWorksheet.PageSetup.DifferentFirstPageOnHF;
                headerFooter.DifferentOddEven = xlWorksheet.PageSetup.DifferentOddEvenPagesOnHF;

                var oddHeader = new OddHeader(xlWorksheet.PageSetup.Header.GetText(XLHFOccurrence.OddPages));
                headerFooter.AppendChild(oddHeader);
                var oddFooter = new OddFooter(xlWorksheet.PageSetup.Footer.GetText(XLHFOccurrence.OddPages));
                headerFooter.AppendChild(oddFooter);

                var evenHeader = new EvenHeader(xlWorksheet.PageSetup.Header.GetText(XLHFOccurrence.EvenPages));
                headerFooter.AppendChild(evenHeader);
                var evenFooter = new EvenFooter(xlWorksheet.PageSetup.Footer.GetText(XLHFOccurrence.EvenPages));
                headerFooter.AppendChild(evenFooter);

                var firstHeader = new FirstHeader(xlWorksheet.PageSetup.Header.GetText(XLHFOccurrence.FirstPage));
                headerFooter.AppendChild(firstHeader);
                var firstFooter = new FirstFooter(xlWorksheet.PageSetup.Footer.GetText(XLHFOccurrence.FirstPage));
                headerFooter.AppendChild(firstFooter);
            }

            #endregion

            #region RowBreaks

            if (!worksheetPart.Worksheet.Elements<RowBreaks>().Any())
            {
                var previousElement = cm.GetPreviousElementFor(XLWSContentManager.XLWSContents.RowBreaks);
                worksheetPart.Worksheet.InsertAfter(new RowBreaks(), previousElement);
            }

            var rowBreaks = worksheetPart.Worksheet.Elements<RowBreaks>().First();

            var rowBreakCount = xlWorksheet.PageSetup.RowBreaks.Count;
            if (rowBreakCount > 0)
            {
                rowBreaks.Count = (UInt32)rowBreakCount;
                rowBreaks.ManualBreakCount = (UInt32)rowBreakCount;
                var lastRowNum = (UInt32)xlWorksheet.RangeAddress.LastAddress.RowNumber;
                foreach (var break1 in xlWorksheet.PageSetup.RowBreaks.Select(rb => new Break
                {
                    Id = (UInt32)rb,
                    Max = lastRowNum,
                    ManualPageBreak = true
                }))
                    rowBreaks.AppendChild(break1);
                cm.SetElement(XLWSContentManager.XLWSContents.RowBreaks, rowBreaks);
            }
            else
            {
                worksheetPart.Worksheet.RemoveAllChildren<RowBreaks>();
                cm.SetElement(XLWSContentManager.XLWSContents.RowBreaks, null);
            }

            #endregion

            #region ColumnBreaks

            if (!worksheetPart.Worksheet.Elements<ColumnBreaks>().Any())
            {
                var previousElement = cm.GetPreviousElementFor(XLWSContentManager.XLWSContents.ColumnBreaks);
                worksheetPart.Worksheet.InsertAfter(new ColumnBreaks(), previousElement);
            }

            var columnBreaks = worksheetPart.Worksheet.Elements<ColumnBreaks>().First();

            var columnBreakCount = xlWorksheet.PageSetup.ColumnBreaks.Count;
            if (columnBreakCount > 0)
            {
                columnBreaks.Count = (UInt32)columnBreakCount;
                columnBreaks.ManualBreakCount = (UInt32)columnBreakCount;
                var maxColumnNumber = (UInt32)xlWorksheet.RangeAddress.LastAddress.ColumnNumber;
                foreach (var break1 in xlWorksheet.PageSetup.ColumnBreaks.Select(cb => new Break
                {
                    Id = (UInt32)cb,
                    Max = maxColumnNumber,
                    ManualPageBreak = true
                }))
                    columnBreaks.AppendChild(break1);
                cm.SetElement(XLWSContentManager.XLWSContents.ColumnBreaks, columnBreaks);
            }
            else
            {
                worksheetPart.Worksheet.RemoveAllChildren<ColumnBreaks>();
                cm.SetElement(XLWSContentManager.XLWSContents.ColumnBreaks, null);
            }

            #endregion

            #region Drawings

            //worksheetPart.Worksheet.RemoveAllChildren<Drawing>();
            //{
            //    OpenXmlElement previousElement = cm.GetPreviousElementFor(XLWSContentManager.XLWSContents.Drawing);
            //    worksheetPart.Worksheet.InsertAfter(new Drawing() { Id = String.Format("rId{0}", 1) }, previousElement);
            //}

            //Drawing drawing = worksheetPart.Worksheet.Elements<Drawing>().First();
            //cm.SetElement(XLWSContentManager.XLWSContents.Drawing, drawing);

            #endregion

            #region Tables

            worksheetPart.Worksheet.RemoveAllChildren<TableParts>();
            {
                var previousElement = cm.GetPreviousElementFor(XLWSContentManager.XLWSContents.TableParts);
                worksheetPart.Worksheet.InsertAfter(new TableParts(), previousElement);
            }

            var tableParts = worksheetPart.Worksheet.Elements<TableParts>().First();
            cm.SetElement(XLWSContentManager.XLWSContents.TableParts, tableParts);

            tableParts.Count = (UInt32)xlWorksheet.Tables.Count();
            foreach (
                var tablePart in
                    from XLTable xlTable in xlWorksheet.Tables select new TablePart {Id = xlTable.RelId})
                tableParts.AppendChild(tablePart);

            #endregion

            #region LegacyDrawing

            if (xlWorksheet.LegacyDrawingIsNew)
            {
                worksheetPart.Worksheet.RemoveAllChildren<LegacyDrawing>();
                {
                    if (!XLHelper.IsNullOrWhiteSpace(xlWorksheet.LegacyDrawingId))
                    {
                        var previousElement = cm.GetPreviousElementFor(XLWSContentManager.XLWSContents.LegacyDrawing);
                        worksheetPart.Worksheet.InsertAfter(new LegacyDrawing {Id = xlWorksheet.LegacyDrawingId},
                            previousElement);
                    }
                }
            }

            #endregion

            #region LegacyDrawingHeaderFooter

            //LegacyDrawingHeaderFooter legacyHeaderFooter = worksheetPart.Worksheet.Elements<LegacyDrawingHeaderFooter>().FirstOrDefault();
            //if (legacyHeaderFooter != null)
            //{
            //    worksheetPart.Worksheet.RemoveAllChildren<LegacyDrawingHeaderFooter>();
            //    {
            //            var previousElement = cm.GetPreviousElementFor(XLWSContentManager.XLWSContents.LegacyDrawingHeaderFooter);
            //            worksheetPart.Worksheet.InsertAfter(new LegacyDrawingHeaderFooter { Id = xlWorksheet.LegacyDrawingId },
            //                                                previousElement);
            //    }
            //}

            #endregion
        }
예제 #13
0
        void graphListForm_showAllAsStackOnCurrentGraph( object sender, EventArgs e )
        {
            GraphForm currentGraphForm = CurrentGraphForm;
            if( currentGraphForm == null )
                throw new Exception( "current graph should not be null" );
            List<GraphItem> gList = ( ( sender as ToolStripMenuItem ).Owner as ContextMenuStrip ).Tag as List<GraphItem>;

            currentGraphForm.PaneList.Clear();
            foreach( GraphItem g in gList )
            {
                Pane pane = new Pane();
                pane.Add( g );
                currentGraphForm.PaneList.Add( pane );
            }
            currentGraphForm.Refresh();
        }
예제 #14
0
        protected void Page_Load(object sender, EventArgs e)
        {
            //if the current user is not an admin they cannot edit a user at all
            if (CurrentUser.IsAdmin() == false)
            {
                throw new UserAuthorizationException("Access denied");
            }

            int UID = int.Parse(Request.QueryString["id"]);

            u = BusinessLogic.User.GetUser(UID);

            //the true admin can only edit the true admin
            if (u.Id == 0 && CurrentUser.Id != 0)
            {
                throw new Exception("Only the root user can edit the 'root' user (id:0)");
            }

            //only another admin can edit another admin (who is not the true admin)
            if (u.IsAdmin() && CurrentUser.IsAdmin() == false)
            {
                throw new Exception("Admin users can only be edited by admins");
            }

            // check if canvas editing is enabled
            DefaultToLiveEditing.Visible = UmbracoSettings.EnableCanvasEditing;

            // Populate usertype list
            foreach (UserType ut in UserType.getAll)
            {
                if (CurrentUser.IsAdmin() || ut.Alias != "admin")
                {
                    ListItem li = new ListItem(ui.Text("user", ut.Name.ToLower(), base.getUser()), ut.Id.ToString());
                    if (ut.Id == u.UserType.Id)
                    {
                        li.Selected = true;
                    }

                    userType.Items.Add(li);
                }
            }

            // Populate ui language lsit
            foreach (
                string f in
                Directory.GetFiles(IOHelper.MapPath(SystemDirectories.Umbraco + "/config/lang"), "*.xml")
                )
            {
                XmlDocument x = new XmlDocument();
                x.Load(f);
                ListItem li =
                    new ListItem(x.DocumentElement.Attributes.GetNamedItem("intName").Value,
                                 x.DocumentElement.Attributes.GetNamedItem("alias").Value);
                if (x.DocumentElement.Attributes.GetNamedItem("alias").Value == u.Language)
                {
                    li.Selected = true;
                }

                userLanguage.Items.Add(li);
            }

            // Console access and disabling
            NoConsole.Checked            = u.NoConsole;
            Disabled.Checked             = u.Disabled;
            DefaultToLiveEditing.Checked = u.DefaultToLiveEditing;

            PlaceHolder medias = new PlaceHolder();

            mediaPicker.AppAlias  = Constants.Applications.Media;
            mediaPicker.TreeAlias = "media";

            if (u.StartMediaId > 0)
            {
                mediaPicker.Value = u.StartMediaId.ToString();
            }
            else
            {
                mediaPicker.Value = "-1";
            }

            medias.Controls.Add(mediaPicker);

            PlaceHolder content = new PlaceHolder();

            contentPicker.AppAlias  = Constants.Applications.Content;
            contentPicker.TreeAlias = "content";

            if (u.StartNodeId > 0)
            {
                contentPicker.Value = u.StartNodeId.ToString();
            }
            else
            {
                contentPicker.Value = "-1";
            }

            content.Controls.Add(contentPicker);


            // Add password changer
            passw.Controls.Add(new UserControl().LoadControl(SystemDirectories.Umbraco + "/controls/passwordChanger.ascx"));

            pp.addProperty(ui.Text("user", "username", base.getUser()), uname);
            pp.addProperty(ui.Text("user", "loginname", base.getUser()), lname);
            pp.addProperty(ui.Text("user", "password", base.getUser()), passw);
            pp.addProperty(ui.Text("email", base.getUser()), email);
            pp.addProperty(ui.Text("user", "usertype", base.getUser()), userType);
            pp.addProperty(ui.Text("user", "language", base.getUser()), userLanguage);

            //Media  / content root nodes
            Pane ppNodes = new Pane();

            ppNodes.addProperty(ui.Text("user", "startnode", base.getUser()), content);
            ppNodes.addProperty(ui.Text("user", "mediastartnode", base.getUser()), medias);

            //Generel umrbaco access
            Pane ppAccess = new Pane();

            if (UmbracoSettings.EnableCanvasEditing)
            {
                ppAccess.addProperty(ui.Text("user", "defaultToLiveEditing", base.getUser()), DefaultToLiveEditing);
            }
            ppAccess.addProperty(ui.Text("user", "noConsole", base.getUser()), NoConsole);
            ppAccess.addProperty(ui.Text("user", "disabled", base.getUser()), Disabled);

            //access to which modules...
            Pane ppModules = new Pane();

            ppModules.addProperty(ui.Text("user", "modules", base.getUser()), lapps);
            ppModules.addProperty(" ", sectionValidator);

            TabPage userInfo = UserTabs.NewTabPage(u.Name);

            userInfo.Controls.Add(pp);
            userInfo.Controls.Add(ppNodes);
            userInfo.Controls.Add(ppAccess);
            userInfo.Controls.Add(ppModules);
            userInfo.Style.Add("text-align", "center");

            userInfo.HasMenu = true;

            ImageButton save = userInfo.Menu.NewImageButton();

            save.ImageUrl = SystemDirectories.Umbraco + "/images/editor/save.gif";
            save.Click   += new ImageClickEventHandler(saveUser_Click);

            sectionValidator.ServerValidate   += new ServerValidateEventHandler(sectionValidator_ServerValidate);
            sectionValidator.ControlToValidate = lapps.ID;
            sectionValidator.ErrorMessage      = ui.Text("errorHandling", "errorMandatoryWithoutTab", ui.Text("user", "modules", base.getUser()), base.getUser());
            sectionValidator.CssClass          = "error";

            setupForm();
            setupChannel();

            ClientTools
            .SetActiveTreeType(TreeDefinitionCollection.Instance.FindTree <loadUsers>().Tree.Alias)
            .SyncTree(UID.ToString(), IsPostBack);
        }
 public override void Serialize(NetworkPacketReader reader)
 {
     PaneType   = (Pane)reader.ReadByte();
     MovingFrom = reader.ReadByte();
     MovingTo   = reader.ReadByte();
 }
예제 #16
0
 public virtual MapViewer.DragAction LeftButtonDown(Pane pane, PointF location, float pixelSize, ref bool displayUpdateNeeded)
 {
     return(MapViewer.DragAction.None);
 }
예제 #17
0
        private void setupChannel()
        {
            Channel userChannel;

            try
            {
                userChannel =
                    new Channel(u.Id);
            }
            catch
            {
                userChannel = new Channel();
            }

            // Populate dropdowns
            foreach (DocumentType dt in DocumentType.GetAllAsList())
            {
                cDocumentType.Items.Add(
                    new ListItem(dt.Text, dt.Alias)
                    );
            }

            // populate fields
            ArrayList fields = new ArrayList();

            cDescription.ID = "cDescription";
            cCategories.ID  = "cCategories";
            cExcerpt.ID     = "cExcerpt";
            cDescription.Items.Add(new ListItem(ui.Text("choose"), ""));
            cCategories.Items.Add(new ListItem(ui.Text("choose"), ""));
            cExcerpt.Items.Add(new ListItem(ui.Text("choose"), ""));

            foreach (PropertyType pt in PropertyType.GetAll())
            {
                if (!fields.Contains(pt.Alias))
                {
                    cDescription.Items.Add(new ListItem(string.Format("{0} ({1})", pt.Name, pt.Alias), pt.Alias));
                    cCategories.Items.Add(new ListItem(string.Format("{0} ({1})", pt.Name, pt.Alias), pt.Alias));
                    cExcerpt.Items.Add(new ListItem(string.Format("{0} ({1})", pt.Name, pt.Alias), pt.Alias));
                    fields.Add(pt.Alias);
                }
            }

            // Handle content and media pickers

            PlaceHolder medias = new PlaceHolder();

            cMediaPicker.AppAlias  = Constants.Applications.Media;
            cMediaPicker.TreeAlias = "media";

            if (userChannel.MediaFolder > 0)
            {
                cMediaPicker.Value = userChannel.MediaFolder.ToString();
            }
            else
            {
                cMediaPicker.Value = "-1";
            }

            medias.Controls.Add(cMediaPicker);

            PlaceHolder content = new PlaceHolder();

            cContentPicker.AppAlias  = Constants.Applications.Content;
            cContentPicker.TreeAlias = "content";

            if (userChannel.StartNode > 0)
            {
                cContentPicker.Value = userChannel.StartNode.ToString();
            }
            else
            {
                cContentPicker.Value = "-1";
            }

            content.Controls.Add(cContentPicker);


            // Setup the panes
            Pane ppInfo = new Pane();

            ppInfo.addProperty(ui.Text("name", base.getUser()), cName);
            ppInfo.addProperty(ui.Text("user", "startnode", base.getUser()), content);
            ppInfo.addProperty(ui.Text("user", "searchAllChildren", base.getUser()), cFulltree);
            ppInfo.addProperty(ui.Text("user", "mediastartnode", base.getUser()), medias);

            Pane ppFields = new Pane();

            ppFields.addProperty(ui.Text("user", "documentType", base.getUser()), cDocumentType);
            ppFields.addProperty(ui.Text("user", "descriptionField", base.getUser()), cDescription);
            ppFields.addProperty(ui.Text("user", "categoryField", base.getUser()), cCategories);
            ppFields.addProperty(ui.Text("user", "excerptField", base.getUser()), cExcerpt);


            TabPage channelInfo = UserTabs.NewTabPage(ui.Text("user", "contentChannel", base.getUser()));

            channelInfo.Controls.Add(ppInfo);
            channelInfo.Controls.Add(ppFields);

            channelInfo.HasMenu = true;
            ImageButton save = channelInfo.Menu.NewImageButton();

            save.ImageUrl = SystemDirectories.Umbraco + "/images/editor/save.gif";
            save.Click   += new ImageClickEventHandler(saveUser_Click);
            save.ID       = "save";
            if (!IsPostBack)
            {
                cName.Text = userChannel.Name;
                cDescription.SelectedValue  = userChannel.FieldDescriptionAlias;
                cCategories.SelectedValue   = userChannel.FieldCategoriesAlias;
                cExcerpt.SelectedValue      = userChannel.FieldExcerptAlias;
                cDocumentType.SelectedValue = userChannel.DocumentTypeAlias;
                cFulltree.Checked           = userChannel.FullTree;
            }
        }
예제 #18
0
 public virtual void MouseMoved(Pane pane, PointF location, float pixelSize, ref bool displayUpdateNeeded)
 {
 }
예제 #19
0
        public override void LeftButtonEndDrag(Pane pane, PointF location, PointF locationStart, float pixelSize, ref bool displayUpdateNeeded)
        {
            Debug.Assert(pane == Pane.Map);

            float  deltaX            = (location.X - startDrag.X);
            float  deltaY            = (location.Y - startDrag.Y);
            PointF newHandleLocation = new PointF(handleLocation.X + deltaX, handleLocation.Y + deltaY);

            if (courseObjectStart.specialId.IsNotNone)
            {
                // Moving a corner of a special
                Id <Special> specialId = courseObjectStart.specialId;

                if (courseObjectStart is DescriptionCourseObj)
                {
                    // Moving a description. Descriptions are rather special in the way their locations are used.
                    DescriptionCourseObj descObj = (DescriptionCourseObj)courseObjectStart.Clone();
                    descObj.MoveHandle(handleLocation, location);
                    controller.MoveSpecial(specialId, new PointF[2] {
                        new PointF(descObj.rect.Left, descObj.rect.Bottom), new PointF(descObj.rect.Left + descObj.CellSize, descObj.rect.Bottom)
                    }, descObj.NumberOfColumns);
                }
                else if (courseObjectStart is RectCourseObj)
                {
                    // Moving rectangle handles is sort of special too.
                    RectCourseObj rectObj = (RectCourseObj)courseObjectStart.Clone();
                    rectObj.MoveHandle(handleLocation, location);
                    RectangleF rect = rectObj.GetHighlightBounds();
                    controller.MoveSpecial(specialId, new PointF[2] {
                        new PointF(rect.Left, rect.Bottom), new PointF(rect.Right, rect.Top)
                    });
                }
                else if (courseObjectStart is BasicTextCourseObj)
                {
                    // Moving text handles is sort of special too.
                    BasicTextCourseObj textObj = (BasicTextCourseObj)courseObjectStart.Clone();
                    textObj.MoveHandle(handleLocation, location);
                    RectangleF rect = textObj.GetHighlightBounds();
                    rect = textObj.AdjustBoundingRect(rect);
                    controller.MoveSpecial(specialId, new PointF[2] {
                        new PointF(rect.Left, rect.Bottom), new PointF(rect.Right, rect.Top)
                    });
                }
                else
                {
                    controller.MoveSpecialPoint(specialId, handleLocation, newHandleLocation);
                }
            }
            else if ((courseObjectStart is LegCourseObj) || (courseObjectStart is FlaggedLegCourseObj))
            {
                // Moving a leg bend.
                LineCourseObj lineCourseObj = (LineCourseObj)courseObjectStart;

                controller.MoveLegBendOrGap(lineCourseObj.courseControlId, lineCourseObj.courseControlId2, handleLocation, newHandleLocation);
            }
            else if ((courseObjectStart is ControlCourseObj) || (courseObjectStart is FinishCourseObj))
            {
                PointCourseObj pointObj = (PointCourseObj)courseObjectStart.Clone();
                pointObj.MoveHandle(handleLocation, location);
                controller.MoveControlGap(courseObjectStart.controlId, pointObj.movableGaps);
            }
            else
            {
                Debug.Fail("unknown situation");
            }

            controller.DefaultCommandMode();
        }
예제 #20
0
        public override MapViewer.DragAction LeftButtonDown(Pane pane, PointF location, float pixelSize, ref bool displayUpdateNeeded)
        {
            Debug.Assert(pane == Pane.Map);

            return(MapViewer.DragAction.ImmediateDrag);
        }
예제 #21
0
 protected void Reload(Pane pane = Pane.Single)
 {
     Click(GetInputButton("Reload", pane));
 }
예제 #22
0
        public override void LeftButtonDrag(Pane pane, PointF location, PointF locationStart, float pixelSize, ref bool displayUpdateNeeded)
        {
            Debug.Assert(pane == Pane.Map);

            currentLocation = location;

            // Update the highlight.
            courseObjectDrag = ((CourseObj)courseObjectStart.Clone());
            courseObjectDrag.Offset(location.X - startDrag.X, location.Y - startDrag.Y);

            // If we're dragging a control in a course (not all controls) then add additional highlights for the leg(s) to/from the control.
            if (AreDraggingControlPoint() && courseObjectStart.courseControlId.IsNotNone)
            {
                ControlPoint control    = eventDB.GetControl(courseObjectStart.controlId);
                CourseView   courseView = selectionMgr.ActiveCourseView;

                // Find index of this course control in the course view.
                int index;
                for (index = 0; index < courseView.ControlViews.Count; ++index)
                {
                    if (courseView.ControlViews[index].courseControlIds.Contains(courseObjectStart.courseControlId))
                    {
                        break;
                    }
                }

                if (index < courseView.ControlViews.Count)
                {
                    // Get previous and next controls.
                    int prevIndex = courseView.GetPrevControl(index), nextIndex = courseView.GetNextControl(index);
                    Id <CourseControl> prevCourseControl = (prevIndex >= 0) ? courseView.ControlViews[prevIndex].courseControlIds[0] : Id <CourseControl> .None;
                    Id <CourseControl> nextCourseControl = (nextIndex >= 0) ? courseView.ControlViews[nextIndex].courseControlIds[0] : Id <CourseControl> .None;

                    // Get additional highlights to and from those controls.
                    additionalHighlights = AddControlMode.CreateLegHighlights(eventDB, ((PointCourseObj)courseObjectDrag).location, courseObjectDrag.controlId, control.kind, prevCourseControl, nextCourseControl,
                                                                              courseView.CourseObjRatio(courseObjectStart.appearance), courseObjectStart.appearance);

                    // If we're dragging the start, update the angle of the start appropriately.
                    if ((control.kind == ControlPointKind.Start || control.kind == ControlPointKind.MapExchange || control.kind == ControlPointKind.MapIssue) &&
                        additionalHighlights.Length > 0 &&
                        (courseView.Kind == CourseView.CourseViewKind.Normal || courseView.Kind == CourseView.CourseViewKind.AllVariations))
                    {
                        SymPath  pathFromStart = ((LineCourseObj)additionalHighlights[additionalHighlights.Length - 1]).path;
                        PointF[] pts           = pathFromStart.FlattenedPoints;
                        double   angleOut      = Math.Atan2(pts[1].Y - pts[0].Y, pts[1].X - pts[0].X);
                        if (!double.IsNaN(angleOut))
                        {
                            float angleInDegrees = (float)Geometry.RadiansToDegrees(angleOut);
                            if (control.kind == ControlPointKind.MapIssue)
                            {
                                ((MapIssueCourseObj)courseObjectDrag).orientation = angleInDegrees;
                            }
                            else
                            {
                                ((StartCourseObj)courseObjectDrag).orientation = angleInDegrees;
                            }
                        }
                    }
                }
            }

            displayUpdateNeeded = true;
        }
        // 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;
        }
예제 #24
0
        internal void SetDockState(bool isHidden, DockState visibleState, DockPane oldPane)
        {
            if (IsSuspendSetDockState)
            {
                return;
            }

            if (DockPanel == null && visibleState != DockState.Unknown)
            {
                throw new InvalidOperationException(Strings.DockContentHandler_SetDockState_NullPanel);
            }

            if (visibleState == DockState.Hidden || (visibleState != DockState.Unknown && !IsDockStateValid(visibleState)))
            {
                throw new InvalidOperationException(Strings.DockContentHandler_SetDockState_InvalidState);
            }

            DockPanel dockPanel = DockPanel;

            if (dockPanel != null)
            {
                dockPanel.SuspendLayout(true);
            }

            SuspendSetDockState();

            DockState oldDockState = DockState;

            if (m_isHidden != isHidden || oldDockState == DockState.Unknown)
            {
                m_isHidden = isHidden;
            }
            m_visibleState = visibleState;
            m_dockState    = isHidden ? DockState.Hidden : visibleState;

            //Remove hidden content (shown content is added last so removal is done first to invert the operation)
            bool hidingContent = (DockState == DockState.Hidden) || (DockState == DockState.Unknown) || DockHelper.IsDockStateAutoHide(DockState);

            if (PatchController.EnableContentOrderFix == true && oldDockState != DockState)
            {
                if (hidingContent)
                {
                    if (!Win32Helper.IsRunningOnMono)
                    {
                        DockPanel.ContentFocusManager.RemoveFromList(Content);
                    }
                }
            }

            if (visibleState == DockState.Unknown)
            {
                Pane = null;
            }
            else
            {
                m_isFloat = (m_visibleState == DockState.Float);

                if (Pane == null)
                {
                    Pane = DockPanel.Theme.Extender.DockPaneFactory.CreateDockPane(Content, visibleState, true);
                }
                else if (Pane.DockState != visibleState)
                {
                    if (Pane.Contents.Count == 1)
                    {
                        Pane.SetDockState(visibleState);
                    }
                    else
                    {
                        Pane = DockPanel.Theme.Extender.DockPaneFactory.CreateDockPane(Content, visibleState, true);
                    }
                }
            }

            if (Form.ContainsFocus)
            {
                if (DockState == DockState.Hidden || DockState == DockState.Unknown)
                {
                    if (!Win32Helper.IsRunningOnMono)
                    {
                        DockPanel.ContentFocusManager.GiveUpFocus(Content);
                    }
                }
            }

            SetPaneAndVisible(Pane);

            if (oldPane != null && !oldPane.IsDisposed && oldDockState == oldPane.DockState)
            {
                RefreshDockPane(oldPane);
            }

            if (Pane != null && DockState == Pane.DockState)
            {
                if ((Pane != oldPane) ||
                    (Pane == oldPane && oldDockState != oldPane.DockState))
                {
                    // Avoid early refresh of hidden AutoHide panes
                    if ((Pane.DockWindow == null || Pane.DockWindow.Visible || Pane.IsHidden) && !Pane.IsAutoHide)
                    {
                        RefreshDockPane(Pane);
                    }
                }
            }

            if (oldDockState != DockState)
            {
                if (PatchController.EnableContentOrderFix == true)
                {
                    //Add content that is being shown
                    if (!hidingContent)
                    {
                        if (!Win32Helper.IsRunningOnMono)
                        {
                            DockPanel.ContentFocusManager.AddToList(Content);
                        }
                    }
                }
                else
                {
                    if (DockState == DockState.Hidden || DockState == DockState.Unknown ||
                        DockHelper.IsDockStateAutoHide(DockState))
                    {
                        if (!Win32Helper.IsRunningOnMono)
                        {
                            DockPanel.ContentFocusManager.RemoveFromList(Content);
                        }
                    }
                    else if (!Win32Helper.IsRunningOnMono)
                    {
                        DockPanel.ContentFocusManager.AddToList(Content);
                    }
                }

                ResetAutoHidePortion(oldDockState, DockState);
                OnDockStateChanged(EventArgs.Empty);
            }

            ResumeSetDockState();

            if (dockPanel != null)
            {
                dockPanel.ResumeLayout(true, true);
            }
        }
예제 #25
0
 private void showData( GraphForm hostGraph, GraphItem item )
 {
     Pane pane;
     if( hostGraph.PaneList.Count == 0 || hostGraph.PaneList.Count > 1 )
     {
         hostGraph.PaneList.Clear();
         pane = new Pane();
         hostGraph.PaneList.Add( pane );
     } else
     {
         pane = hostGraph.PaneList[0];
         pane.Clear();
     }
     pane.Add( item );
     hostGraph.Refresh();
 }
        public MainPage()
        {
            this.InitializeComponent();
            topbar.DataContext = (Application.Current as App).NVM;
            Pane.DataContext   = (Application.Current as App).MPVM;
            //DoughnutSeries.ItemsSource =

            /*DoughnutSeries2.ItemsSource = CreateData2();
             * RoundSeries.ItemsSource = CreateData3();
             * PaymentSeries.ItemsSource = CreateData4();
             * DonationSeries.ItemsSource = CreateData5();
             */
            ChartColorModel cm1 = new ChartColorModel();

            cm1.CustomBrushes.Add(SCB1);
            cm1.CustomBrushes.Add(SCB2);
            cm1.CustomBrushes.Add(SCB3);
            cm1.CustomBrushes.Add(SCBTR);
            DoughnutSeries.ColorModel = cm1;

            ChartColorModel cm2 = new ChartColorModel();

            cm2.CustomBrushes.Add(SCB4);
            cm2.CustomBrushes.Add(SCBTR);
            DoughnutSeries2.ColorModel = cm2;

            ChartColorModel cm3 = new ChartColorModel();

            cm3.CustomBrushes.Add(SCB1);
            cm3.CustomBrushes.Add(SCBTR);

            RoundSeries.ColorModel = cm3;

            ChartColorModel cm4 = new ChartColorModel();

            cm4.CustomBrushes.Add(SCB2);
            cm4.CustomBrushes.Add(SCBTR);

            PaymentSeries.ColorModel = cm4;

            ChartColorModel cm5 = new ChartColorModel();

            cm5.CustomBrushes.Add(SCB3);
            cm5.CustomBrushes.Add(SCBTR);

            DonationSeries.ColorModel = cm5;


            if (!DesignMode.DesignModeEnabled)
            {
                this.SizeChanged += MainPage_SizeChanged;

                Pane.RegisterPropertyChangedCallback(SplitView.IsPaneOpenProperty, (sender, dp) =>
                {
                    if (ActualWidth < 748)
                    {
                        username2.Visibility = !Pane.IsPaneOpen ? Visibility.Collapsed : Visibility.Visible;
                    }
                });
            }
        }
예제 #27
0
        void graphListForm_showAsNewGraph( object sender, EventArgs e )
        {
            GraphForm newGraph = OpenGraph( true );
            GraphItem g = ( ( sender as ToolStripMenuItem ).Owner as ContextMenuStrip ).Tag as GraphItem;

            Pane pane = new Pane();
            pane.Add( g );
            newGraph.PaneList.Add( pane );
            newGraph.Refresh();
        }
예제 #28
0
        protected void WaitForMessage(string message, Pane pane = Pane.Single)
        {
            string p = CssSelectorFor(pane);

            wait.Until(dr => dr.FindElement(By.CssSelector(p + ".header .messages")).Text == message);
        }
 public static void Write(string text)
 {
     Pane.OutputString(text);
 }
예제 #30
0
 // Get the highlights to display.
 public virtual IMapViewerHighlight[] GetHighlights(Pane pane)
 {
     return(null);
 }
예제 #31
0
        protected IWebElement GetLCA(string actionName, Pane pane = Pane.Single)
        {
            var selector = CssSelectorFor(pane) + $"nof-collection nof-action input[value='{actionName}']";

            return(wait.Until(d => d.FindElement(By.CssSelector(selector))));
        }
 public static void WriteLine(string text)
 {
     Pane.OutputString(text + Environment.NewLine);
 }
예제 #33
0
        internal void SetDockState(bool isHidden, DockState visibleState, DockPane oldPane)
        {
            if (IsSuspendSetDockState)
            {
                return;
            }

            if (DockPanel == null && visibleState != DockState.Unknown)
            {
                throw new InvalidOperationException(Strings.DockContentHandler_SetDockState_NullPanel);
            }

            if (visibleState == DockState.Hidden || (visibleState != DockState.Unknown && !IsDockStateValid(visibleState)))
            {
                throw new InvalidOperationException(Strings.DockContentHandler_SetDockState_InvalidState);
            }

            DockPanel dockPanel = DockPanel;

            if (dockPanel != null)
            {
                dockPanel.SuspendLayout(true);
            }

            SuspendSetDockState();

            DockState oldDockState = DockState;

            if (m_isHidden != isHidden || oldDockState == DockState.Unknown)
            {
                m_isHidden = isHidden;
            }
            m_visibleState = visibleState;
            m_dockState    = isHidden ? DockState.Hidden : visibleState;

            if (visibleState == DockState.Unknown)
            {
                Pane = null;
            }
            else
            {
                m_isFloat = (m_visibleState == DockState.Float);

                if (Pane == null)
                {
                    Pane = DockPanel.DockPaneFactory.CreateDockPane(Content, visibleState, true);
                }
                else if (Pane.DockState != visibleState)
                {
                    if (Pane.Contents.Count == 1)
                    {
                        Pane.SetDockState(visibleState);
                    }
                    else
                    {
                        Pane = DockPanel.DockPaneFactory.CreateDockPane(Content, visibleState, true);
                    }
                }
            }

            if (Form.ContainsFocus)
            {
                if (DockState == DockState.Hidden || DockState == DockState.Unknown)
                {
                    DockPanel.ContentFocusManager.GiveUpFocus(Content);
                }
            }

            SetPaneAndVisible(Pane);

            if (oldPane != null && !oldPane.IsDisposed && oldDockState == oldPane.DockState)
            {
                RefreshDockPane(oldPane);
            }

            if (Pane != null && DockState == Pane.DockState)
            {
                if ((Pane != oldPane) ||
                    (Pane == oldPane && oldDockState != oldPane.DockState))
                {
                    // Avoid early refresh of hidden AutoHide panes
                    if ((Pane.DockWindow == null || Pane.DockWindow.Visible || Pane.IsHidden) && !Pane.IsAutoHide)
                    {
                        RefreshDockPane(Pane);
                    }
                }
            }

            if (oldDockState != DockState)
            {
                if (DockState == DockState.Hidden || DockState == DockState.Unknown ||
                    DockHelper.IsDockStateAutoHide(DockState))
                {
                    DockPanel.ContentFocusManager.RemoveFromList(Content);
                }
                else
                {
                    DockPanel.ContentFocusManager.AddToList(Content);
                }

                OnDockStateChanged(EventArgs.Empty);
            }
            ResumeSetDockState();

            if (dockPanel != null)
            {
                dockPanel.ResumeLayout(true, true);
            }
        }
예제 #34
0
        public override void LeftButtonClick(Pane pane, PointF location, float pixelSize, ref bool displayUpdateNeeded)
        {
            if (pane != Pane.Map)
                return;

            // Create the new control!

            // Are we creating a new control point, or using existing one?
            PointF highlightLocation;
            Id<ControlPoint> controlId = HitTestPoint(location, pixelSize, out highlightLocation);
            bool createNewControl = controlId.IsNone;
            string commandString;

            switch (controlKind) {
            case ControlPointKind.Start: commandString = CommandNameText.AddStart; break;
            case ControlPointKind.Finish: commandString = CommandNameText.AddFinish; break;
            case ControlPointKind.CrossingPoint: commandString = CommandNameText.AddCrossingPoint; break;
            case ControlPointKind.MapExchange: commandString = CommandNameText.AddMapExchange; break;
            default:
                if (exchangeAtControl)
                    commandString = CommandNameText.AddMapExchange;
                else
                    commandString = CommandNameText.AddControl;
                break;
            }

            undoMgr.BeginCommand(1321, commandString);

            if (createNewControl) {
                // Creating a new control point.
                string newCode = null;
                if (controlKind == ControlPointKind.Normal)
                    newCode = QueryEvent.NextUnusedControlCode(eventDB);
                controlId = ChangeEvent.AddControlPoint(eventDB, controlKind, newCode, highlightLocation, 0);
                if (controlKind == ControlPointKind.Finish)
                    ChangeEvent.ChangeDescriptionSymbol(eventDB, controlId, 0, "14.3");   // set finish to "navigate to finish".
                else if (controlKind == ControlPointKind.CrossingPoint)
                    ChangeEvent.ChangeDescriptionSymbol(eventDB, controlId, 0, "13.3");   // set to mandatory crossing point.
            }

            if (allControls) {
                // select the new control.
                selectionMgr.SelectControl(controlId);
            }
            else {
                // Add the control to the current course.

                // Get where to add the control.
                CourseDesignator courseDesignator;
                Id<CourseControl> courseControl1, courseControl2;
                GetControlInsertionPoint(highlightLocation, out courseDesignator, out courseControl1, out courseControl2);

                // And add it.
                Id<CourseControl> courseControlId;
                if (controlKind == ControlPointKind.Start)
                    courseControlId = ChangeEvent.AddStartToCourse(eventDB, controlId, courseDesignator.CourseId, true);
                else if (controlKind == ControlPointKind.Finish)
                    courseControlId = ChangeEvent.AddFinishToCourse(eventDB, controlId, courseDesignator.CourseId, true);
                else if (controlKind == ControlPointKind.MapExchange) {
                    courseControlId = ChangeEvent.AddCourseControl(eventDB, controlId, courseDesignator.CourseId, courseControl1, courseControl2);
                    ChangeEvent.ChangeControlExchange(eventDB, courseControlId, true);
                }
                else if (exchangeAtControl && QueryEvent.CourseUsesControl(eventDB, courseDesignator, controlId)) {
                    // Selected control already on course, just add map exchange at that courseControl(s)).
                    courseControlId = Id<CourseControl>.None;
                    foreach (Id<CourseControl> courseControlBecomesExchange in QueryEvent.GetCourseControlsInCourse(eventDB, courseDesignator, controlId)) {
                        ChangeEvent.ChangeControlExchange(eventDB, courseControlBecomesExchange, true);
                        courseControlId = courseControlBecomesExchange;
                    }
                }
                else {
                    courseControlId = ChangeEvent.AddCourseControl(eventDB, controlId, courseDesignator.CourseId, courseControl1, courseControl2);
                    if (exchangeAtControl)
                        ChangeEvent.ChangeControlExchange(eventDB, courseControlId, true);
                }

                // select the new control.
                selectionMgr.SelectCourseControl(courseControlId);
            }

            undoMgr.EndCommand(1321);

            controller.DefaultCommandMode();
        }
        private Pane AddLanguagePane(int?languageId)
        {
            string strLanguageId = languageId != null?languageId.Value.ToString() : string.Empty;

            Pane pane = new Pane();

            PropertyPanel ppnlSubject = new PropertyPanel();

            ppnlSubject.Text = CommonTerms.Subject;
            pane.Controls.Add(ppnlSubject);

            TextBox txtSubject = new TextBox();

            txtSubject.ID       = "TxtSubject" + strLanguageId;
            txtSubject.CssClass = "guiInputText guiInputStandardSize";
            ppnlSubject.Controls.Add(txtSubject);

            PropertyPanel ppnlSenderName = new PropertyPanel();

            ppnlSenderName.Text = CommonTerms.SenderName;
            pane.Controls.Add(ppnlSenderName);

            TextBox txtSenderName = new TextBox();

            txtSenderName.ID       = "TxtSenderName" + strLanguageId;
            txtSenderName.CssClass = "guiInputText guiInputStandardSize";
            ppnlSenderName.Controls.Add(txtSenderName);

            PropertyPanel ppnlSenderAddress = new PropertyPanel();

            ppnlSenderAddress.Text = CommonTerms.SenderAddress;
            pane.Controls.Add(ppnlSenderAddress);

            TextBox txtSenderAddress = new TextBox();

            txtSenderAddress.ID       = "TxtSenderAddress" + strLanguageId;
            txtSenderAddress.CssClass = "guiInputText guiInputStandardSize";
            ppnlSenderAddress.Controls.Add(txtSenderAddress);

            CustomValidator cusValSenderAddress = new CustomValidator();

            cusValSenderAddress.ID = "CusValSenderAddress" + strLanguageId;
            cusValSenderAddress.ControlToValidate = txtSenderAddress.ID;
            cusValSenderAddress.ServerValidate   += Email_ServerValidate;
            cusValSenderAddress.ErrorMessage      = "*";
            ppnlSenderAddress.Controls.Add(cusValSenderAddress);

            PropertyPanel ppnlToAddresses = new PropertyPanel();

            ppnlToAddresses.Text = CommonTerms.ToAddresses + "<br /><small>" + CommonTerms.SeparateBySemicolon + "</small>";
            pane.Controls.Add(ppnlToAddresses);

            TextBox txtToAddresses = new TextBox();

            txtToAddresses.ID       = "TxtToAddresses" + strLanguageId;
            txtToAddresses.CssClass = "guiInputText guiInputStandardSize";
            ppnlToAddresses.Controls.Add(txtToAddresses);

            CustomValidator cusValToAddresses = new CustomValidator();

            cusValToAddresses.ID = "CusValToAddresses" + strLanguageId;
            cusValToAddresses.ControlToValidate = txtToAddresses.ID;
            cusValToAddresses.ServerValidate   += Email_ServerValidate;
            cusValToAddresses.ErrorMessage      = "*";
            ppnlToAddresses.Controls.Add(cusValToAddresses);

            PropertyPanel ppnlCCAddresses = new PropertyPanel();

            ppnlCCAddresses.Text = CommonTerms.CCAddresses + "<br /><small>" + CommonTerms.SeparateBySemicolon + "</small>";
            pane.Controls.Add(ppnlCCAddresses);

            TextBox txtCCAddresses = new TextBox();

            txtCCAddresses.ID       = "TxtCCAddresses" + strLanguageId;
            txtCCAddresses.CssClass = "guiInputText guiInputStandardSize";
            ppnlCCAddresses.Controls.Add(txtCCAddresses);

            CustomValidator cusValCCAddresses = new CustomValidator();

            cusValCCAddresses.ID = "CusValCCAddresses" + strLanguageId;
            cusValCCAddresses.ControlToValidate = txtCCAddresses.ID;
            cusValCCAddresses.ServerValidate   += Email_ServerValidate;
            cusValCCAddresses.ErrorMessage      = "*";
            ppnlCCAddresses.Controls.Add(cusValCCAddresses);

            PropertyPanel ppnlBCCAddresses = new PropertyPanel();

            ppnlBCCAddresses.Text = CommonTerms.BCCAddresses + "<br /><small>" + CommonTerms.SeparateBySemicolon + "</small>";
            pane.Controls.Add(ppnlBCCAddresses);

            TextBox txtBCCAddresses = new TextBox();

            txtBCCAddresses.ID       = "TxtBCCAddresses" + strLanguageId;
            txtBCCAddresses.CssClass = "guiInputText guiInputStandardSize";
            ppnlBCCAddresses.Controls.Add(txtBCCAddresses);

            CustomValidator cusValBCCAddresses = new CustomValidator();

            cusValBCCAddresses.ID = "CusValBCCAddresses" + strLanguageId;
            cusValBCCAddresses.ControlToValidate = txtBCCAddresses.ID;
            cusValBCCAddresses.ServerValidate   += Email_ServerValidate;
            cusValBCCAddresses.ErrorMessage      = "*";
            ppnlBCCAddresses.Controls.Add(cusValBCCAddresses);

            PropertyPanel ppnlTemplate = new PropertyPanel();

            ppnlTemplate.Text = CommonTerms.TemplateFile;
            pane.Controls.Add(ppnlTemplate);

            TemplateFileSelector templateFileSelectorControl = new TemplateFileSelector();

            templateFileSelectorControl.ID = "TemplateFileSelectorControl" + strLanguageId;
            templateFileSelectorControl.InsertEmptyItem = true;
            ppnlTemplate.Controls.Add(templateFileSelectorControl);

            return(pane);
        }
예제 #36
0
 public override void MouseMoved(Pane pane, PointF location, float pixelSize, ref bool displayUpdateNeeded)
 {
     if (pane == Pane.Map) {
         PointF highlightLocation;
         Id<ControlPoint> controlId = HitTestPoint(location, pixelSize, out highlightLocation);
         SetHighlightLocation(highlightLocation, pixelSize, ref displayUpdateNeeded);
     }
 }
예제 #37
0
        protected IWebElement GetReferenceProperty(string propertyName, string refTitle, Pane pane = Pane.Single)
        {
            string propCss = CssSelectorFor(pane) + " " + ".property";
            var    prop    = wait.Until(dr => dr.FindElements(By.CssSelector(propCss))
                                        .Where(we => we.FindElement(By.CssSelector(".name")).Text == propertyName + ":" &&
                                               we.FindElement(By.CssSelector(".reference")).Text == refTitle).Single()
                                        );

            return(prop.FindElement(By.CssSelector(".reference")));
        }
예제 #38
0
        public override void LeftButtonClick(Pane pane, PointF location, float pixelSize, ref bool displayUpdateNeeded)
        {
            if (pane != Pane.Map)
                return;

            // Left button clicked. Ends creating the item and we're done.
            CreateObject();

            controller.DefaultCommandMode();
            displayUpdateNeeded = true;
        }
예제 #39
0
        protected IWebElement GetInputButton(string text, Pane pane = Pane.Single)
        {
            string selector = CssSelectorFor(pane) + "input";

            return(wait.Until(dr => dr.FindElements(By.CssSelector(selector)).Single(e => e.GetAttribute("value") == text)));
        }
예제 #40
0
        public override MapViewer.DragAction LeftButtonDown(Pane pane, PointF location, float pixelSize, ref bool displayUpdateNeeded)
        {
            if (pane != Pane.Map)
                return MapViewer.DragAction.None;

            if (numberFixedPoints == 0) {
                // The first point. Fix it at the location.
                AddFixedPoint(location);
            }

            displayUpdateNeeded = true;
            return MapViewer.DragAction.DelayedDrag;
        }
예제 #41
0
 protected IWebElement SaveVMButton(Pane pane = Pane.Single)
 {
     return(GetInputButton("Save", pane));
 }
예제 #42
0
        public override void LeftButtonDrag(Pane pane, PointF location, PointF locationStart, float pixelSize, ref bool displayUpdateNeeded)
        {
            Debug.Assert(pane == Pane.Map);

            // In the middle of dragging. Current location isn't fixed yet.
            AddUnfixedPoint(location);
            displayUpdateNeeded = true;
        }
예제 #43
0
 protected IWebElement GetCancelEditButton(Pane pane = Pane.Single)
 {
     //string p = CssSelectorFor(pane);
     //return wait.Until(d => d.FindElements(By.CssSelector(p + ".header .action")).Single(el => el.Text == "Cancel"));
     return(GetInputButton("Cancel", pane));
 }
예제 #44
0
        public override void LeftButtonEndDrag(Pane pane, PointF location, PointF locationStart, float pixelSize, ref bool displayUpdateNeeded)
        {
            Debug.Assert(pane == Pane.Map);

            // If we ended near to the first point, we've create a polygon and creation is done.
            if (numberFixedPoints >= 3 && Geometry.Distance(location, points[0]) < pixelSize * CLOSEDISTANCE) {
                if (!isArea)
                    AddFixedPoint(points[0]);  // area symbols close automatically.

                CreateObject();

                controller.DefaultCommandMode();
                displayUpdateNeeded = true;
            }
            else {
                // Ended dragging. Current location the next location.
                AddFixedPoint(location);
                displayUpdateNeeded = true;
            }
        }
예제 #45
0
 public PaneBounds(Pane pane, Rectangle bounds)
 {
     Pane   = pane;
     Bounds = bounds;
 }
예제 #46
0
        public override IMapViewerHighlight[] GetHighlights(Pane pane)
        {
            if (pane != Pane.Map)
                return null;

            if (highlight != null)
                return new CourseObj[] { highlight };
            else
                return null;
        }
예제 #47
0
        private void Authorized(object sender, EventArgs ea )
        {
            Label label = EmergeTk.Widgets.Html.Label.InsertLabel( this, "h1", "EmergeTk Administration" );
            label.AppendClass("Admin");

            Button logout = CreateWidget<Button>(this);
            logout.Label = "logout";
            logout.OnClick += delegate {
                LogOut();
                Reload();
            };

            adminList = RootContext.CreateWidget<Pane>(this);

            ShowList();
        }
예제 #48
0
        public override void LeftButtonClick(Pane pane, PointF location, float pixelSize, ref bool displayUpdateNeeded)
        {
            if (pane != Pane.Map)
                return;

            // Create the new special!

            PointF highlightLocation = new PointF(location.X + PIXELOFFSETX * pixelSize, location.Y + PIXELOFFSETY * pixelSize);

            undoMgr.BeginCommand(1322, CommandNameText.AddObject);

            // Creat the special
            Id<Special> specialId = ChangeEvent.AddPointSpecial(eventDB, specialKind, highlightLocation, 0);

            // select the new special.
            selectionMgr.SelectSpecial(specialId);
            undoMgr.EndCommand(1322);

            controller.DefaultCommandMode();
        }
예제 #49
0
 public static ChartControl CreatXYChart(SolidColorBrush forecolor, string ChartTitle, List<ChartDataChartCommonData> dtchart)
 {
     mausac = 0;
     ChartControl abc = new ChartControl();
     XYDiagram2D dg1 = new XYDiagram2D();
     //Tao Tile cho Chart
     Title nt = new Title();
     nt.Content = ChartTitle;
     nt.Foreground = forecolor;
     abc.Titles.Add(nt);
     //Tinh so Series
     List<string> countsr = (from p in dtchart group p by p.Series into g select g.Key).ToList();
     //Creat Diagram
     abc.Diagram = dg1;
     //Begin tao guong
     Pane pane1 = new Pane();
     pane1.MirrorHeight = 100;//Do cao guong
     dg1.DefaultPane = pane1;
     //End tao guong
     //Begin set kieu bieu do
     for (int i = 0; i < countsr.Count; i++)
     {
         BarSideBySideSeries2D dgs1 = new BarSideBySideSeries2D() { DisplayName = countsr[i].ToString() };//Neu ko co DisplayName chu thich khong hien thi
         Quasi3DBar2DModel an1 = new Quasi3DBar2DModel();
         dgs1.Model = an1;
         foreach (ChartDataChartCommonData dr in dtchart)//Tao cac point
         {
             if (dr.Series == countsr.ElementAt(i))
             {
                 //Tao Series
                 SeriesPoint sr1 = new SeriesPoint();
                 sr1.Argument = dr.Agrument;
                 sr1.Value = dr.Value;
                 sr1.Tag = mausac.ToString();
                 dgs1.Points.Add(sr1);
                 mausac++;
             }
         }
         SeriesLabel lbl1 = new SeriesLabel();
         dgs1.LabelsVisibility = true;//Hien thi Lablel cho tung vung
         lbl1.Indent = 10;
         lbl1.ConnectorThickness = 1;
         lbl1.ResolveOverlappingMode = ResolveOverlappingMode.Default;
         dgs1.Label = lbl1;
         dg1.Series.Add(dgs1);
     }
     //Tao chu thich
     abc.Legend = new Legend()
     {
         VerticalPosition = VerticalPosition.BottomOutside,
         HorizontalPosition = HorizontalPosition.Center,
         Orientation = Orientation.Horizontal
     };
     //End tao chu thich
     return abc;
 }
예제 #50
0
 public override MapViewer.DragAction LeftButtonDown(Pane pane, PointF location, float pixelSize, ref bool displayUpdateNeeded)
 {
     if (pane == Pane.Map) {
         // Delay to see if click or drag.
         return MapViewer.DragAction.DelayedDrag;
     }
     else {
         return MapViewer.DragAction.None;
     }
 }
예제 #51
0
 private void showDataStacked(GraphForm hostGraph, GraphItem item )
 {
     Pane pane = new Pane();
     pane.Add( item );
     hostGraph.PaneList.Add( pane );
     hostGraph.Refresh();
 }
예제 #52
0
        public override void LeftButtonDrag(Pane pane, PointF location, PointF locationStart, float pixelSize, ref bool displayUpdateNeeded)
        {
            Debug.Assert(pane == Pane.Map);

            // Drag is move map.
            controller.InitiateMapDragging(locationStart, System.Windows.Forms.MouseButtons.Left);
        }
예제 #53
0
        void graphListForm_showAllAsStackOnNewGraph( object sender, EventArgs e )
        {
            List<GraphItem> gList = ( ( sender as ToolStripMenuItem ).Owner as ContextMenuStrip ).Tag as List<GraphItem>;

            GraphForm newGraph = OpenGraph( true );
            foreach( GraphItem g in gList )
            {
                Pane pane = new Pane();
                pane.Add( g );
                newGraph.PaneList.Add( pane );
            }
            newGraph.Refresh();
        }
예제 #54
0
        public override void MouseMoved(Pane pane, PointF location, float pixelSize, ref bool displayUpdateNeeded)
        {
            if (pane != Pane.Map)
                return;

            PointF highlightLocation = new PointF(location.X + PIXELOFFSETX * pixelSize, location.Y + PIXELOFFSETY * pixelSize);
            SetHighlightLocation(highlightLocation, pixelSize, ref displayUpdateNeeded);
        }
예제 #55
0
        void graphListForm_stackOnCurrentGraph( object sender, EventArgs e )
        {
            GraphForm currentGraphForm = CurrentGraphForm;
            if( currentGraphForm == null )
                throw new Exception( "current graph should not be null" );
            GraphItem g = ( ( sender as ToolStripMenuItem ).Owner as ContextMenuStrip ).Tag as GraphItem;

            Pane pane = new Pane();
            pane.Add( g );
            currentGraphForm.PaneList.Add( pane );
            currentGraphForm.Refresh();
        }
예제 #56
0
 public override void OnInitInstance()
 {
     _tarRps = new IRichPane[] { Pane.GetPane("Resource") };
 }
예제 #57
0
        public override void MouseMoved(Pane pane, PointF location, float pixelSize, ref bool displayUpdateNeeded)
        {
            if (pane != Pane.Map)
                return;

            RotateToAngle(location);
            displayUpdateNeeded = true;
        }
예제 #58
0
        public RptViewWin(RptInfo p_info)
        {
            // 确保RptInfo已初始化,因含异步!

            IRptSearchForm searchForm = null;

            if (p_info.ScriptObj != null)
            {
                p_info.ScriptObj.View = _view;
                searchForm            = p_info.ScriptObj.GetSearchForm(p_info);
            }

            Main wc   = new Main();
            var  tabs = new Tabs();
            var  tab  = new Tab {
                Title = "内容"
            };

            tab.Content = _view;
            tabs.Items.Add(tab);
            wc.Items.Add(tabs);
            Items.Add(wc);

            var setting = p_info.Root.ViewSetting;

            if (setting.ShowMenu)
            {
                var menu = new Menu();
                if (!setting.ShowSearchForm &&
                    (searchForm != null || p_info.Root.Params.ExistXaml))
                {
                    menu.Items.Add(new Mi {
                        ID = "查询", Icon = Icons.搜索, Cmd = _view.CmdSearch
                    });
                }
                menu.Items.Add(new Mi {
                    ID = "导出", Icon = Icons.导出, Cmd = _view.CmdExport
                });
                menu.Items.Add(new Mi {
                    ID = "打印", Icon = Icons.打印, Cmd = _view.CmdPrint
                });
                p_info.ScriptObj?.InitMenu(menu);
                tab.Menu = menu;
            }

            if (setting.ShowSearchForm &&
                (searchForm != null || p_info.Root.Params.ExistXaml))
            {
                Pane wi = new Pane();
                tabs = new Tabs();
                tab  = new Tab {
                    Title = "查询"
                };

                // 加载查询面板内容
                if (searchForm == null)
                {
                    searchForm = new RptSearchForm(p_info);
                }
                tab.Menu          = searchForm.Menu;
                searchForm.Query += (s, e) => _view.LoadReport(e);
                tab.Content       = searchForm;

                tabs.Items.Add(tab);
                wi.Items.Add(tabs);
                Items.Add(wi);
            }

            // 初次加载自动执行查询
            if (setting.AutoQuery || p_info.Root.Params.Data.Count == 0)
            {
                _view.LoadReport(p_info);
            }
        }
예제 #59
0
 // Mouse cursor looks like a crosshair
 public override Cursor GetMouseCursor(Pane pane, PointF location, float pixelSize)
 {
     if (pane == Pane.Map)
         return Cursors.Cross;
     else
         return Cursors.Arrow;
 }
예제 #60
0
 /// <summary>
 /// ジャンプしているときの継続イベント
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void onJumping(object sender, EventArgs e)
 {
     Pane.Invalidate(null);
 }