public static void GenerateCalculationCell(CalculationChain calculationChain, string cellRef, int sheetId)
        {
            CalculationCell calculationCell1 = new CalculationCell()
            {
                CellReference = cellRef, SheetId = sheetId
            };

            calculationChain.Append(calculationCell1);
        }
        //BLP(A2 & " " & B2;C1)
        public static void GenerateCalculationChainPart1Content(CalculationChainPart calculationChainPart, string cellRef, int sheetId)
        {
            CalculationChain calculationChain1 = new CalculationChain();
            CalculationCell  calculationCell1  = new CalculationCell()
            {
                CellReference = cellRef, SheetId = sheetId
            };

            calculationChain1.Append(calculationCell1);

            calculationChainPart.CalculationChain = calculationChain1;
        }
        // Generates content of calculationChainPart1.
        private void GenerateCalculationChainPart1Content(CalculationChainPart calculationChainPart1)
        {
            CalculationChain calculationChain1 = new CalculationChain();
            CalculationCell calculationCell1 = new CalculationCell() { CellReference = "AG21", SheetId = 1 };
            CalculationCell calculationCell2 = new CalculationCell() { CellReference = "AG23", InChildChain = true };
            CalculationCell calculationCell3 = new CalculationCell() { CellReference = "AF21" };
            CalculationCell calculationCell4 = new CalculationCell() { CellReference = "AF23", InChildChain = true };
            CalculationCell calculationCell5 = new CalculationCell() { CellReference = "AI21" };
            CalculationCell calculationCell6 = new CalculationCell() { CellReference = "AJ21" };
            CalculationCell calculationCell7 = new CalculationCell() { CellReference = "AH20" };
            CalculationCell calculationCell8 = new CalculationCell() { CellReference = "AH21", InChildChain = true };
            CalculationCell calculationCell9 = new CalculationCell() { CellReference = "AH23", InChildChain = true };
            CalculationCell calculationCell10 = new CalculationCell() { CellReference = "AJ23" };
            CalculationCell calculationCell11 = new CalculationCell() { CellReference = "C21" };
            CalculationCell calculationCell12 = new CalculationCell() { CellReference = "C23", InChildChain = true };
            CalculationCell calculationCell13 = new CalculationCell() { CellReference = "D21" };
            CalculationCell calculationCell14 = new CalculationCell() { CellReference = "D23", InChildChain = true };
            CalculationCell calculationCell15 = new CalculationCell() { CellReference = "E21" };
            CalculationCell calculationCell16 = new CalculationCell() { CellReference = "E23", InChildChain = true };
            CalculationCell calculationCell17 = new CalculationCell() { CellReference = "F21" };
            CalculationCell calculationCell18 = new CalculationCell() { CellReference = "F23", InChildChain = true };
            CalculationCell calculationCell19 = new CalculationCell() { CellReference = "G21" };
            CalculationCell calculationCell20 = new CalculationCell() { CellReference = "G23", InChildChain = true };
            CalculationCell calculationCell21 = new CalculationCell() { CellReference = "H21" };
            CalculationCell calculationCell22 = new CalculationCell() { CellReference = "H23", InChildChain = true };
            CalculationCell calculationCell23 = new CalculationCell() { CellReference = "I21" };
            CalculationCell calculationCell24 = new CalculationCell() { CellReference = "I23", InChildChain = true };
            CalculationCell calculationCell25 = new CalculationCell() { CellReference = "J21" };
            CalculationCell calculationCell26 = new CalculationCell() { CellReference = "J23", InChildChain = true };
            CalculationCell calculationCell27 = new CalculationCell() { CellReference = "K21" };
            CalculationCell calculationCell28 = new CalculationCell() { CellReference = "K23", InChildChain = true };
            CalculationCell calculationCell29 = new CalculationCell() { CellReference = "L21" };
            CalculationCell calculationCell30 = new CalculationCell() { CellReference = "L23", InChildChain = true };
            CalculationCell calculationCell31 = new CalculationCell() { CellReference = "M21" };
            CalculationCell calculationCell32 = new CalculationCell() { CellReference = "M23", InChildChain = true };
            CalculationCell calculationCell33 = new CalculationCell() { CellReference = "N21" };
            CalculationCell calculationCell34 = new CalculationCell() { CellReference = "N23", InChildChain = true };
            CalculationCell calculationCell35 = new CalculationCell() { CellReference = "O21" };
            CalculationCell calculationCell36 = new CalculationCell() { CellReference = "O23", InChildChain = true };
            CalculationCell calculationCell37 = new CalculationCell() { CellReference = "P21" };
            CalculationCell calculationCell38 = new CalculationCell() { CellReference = "P23", InChildChain = true };
            CalculationCell calculationCell39 = new CalculationCell() { CellReference = "Q21" };
            CalculationCell calculationCell40 = new CalculationCell() { CellReference = "Q23", InChildChain = true };
            CalculationCell calculationCell41 = new CalculationCell() { CellReference = "R21" };
            CalculationCell calculationCell42 = new CalculationCell() { CellReference = "R23", InChildChain = true };
            CalculationCell calculationCell43 = new CalculationCell() { CellReference = "S21" };
            CalculationCell calculationCell44 = new CalculationCell() { CellReference = "S23", InChildChain = true };
            CalculationCell calculationCell45 = new CalculationCell() { CellReference = "T21" };
            CalculationCell calculationCell46 = new CalculationCell() { CellReference = "T23", InChildChain = true };
            CalculationCell calculationCell47 = new CalculationCell() { CellReference = "U21" };
            CalculationCell calculationCell48 = new CalculationCell() { CellReference = "U23", InChildChain = true };
            CalculationCell calculationCell49 = new CalculationCell() { CellReference = "V21" };
            CalculationCell calculationCell50 = new CalculationCell() { CellReference = "V23", InChildChain = true };
            CalculationCell calculationCell51 = new CalculationCell() { CellReference = "W21" };
            CalculationCell calculationCell52 = new CalculationCell() { CellReference = "W23", InChildChain = true };
            CalculationCell calculationCell53 = new CalculationCell() { CellReference = "X21" };
            CalculationCell calculationCell54 = new CalculationCell() { CellReference = "X23", InChildChain = true };
            CalculationCell calculationCell55 = new CalculationCell() { CellReference = "Y21" };
            CalculationCell calculationCell56 = new CalculationCell() { CellReference = "Y23", InChildChain = true };
            CalculationCell calculationCell57 = new CalculationCell() { CellReference = "Z21" };
            CalculationCell calculationCell58 = new CalculationCell() { CellReference = "Z23", InChildChain = true };
            CalculationCell calculationCell59 = new CalculationCell() { CellReference = "AA21" };
            CalculationCell calculationCell60 = new CalculationCell() { CellReference = "AA23", InChildChain = true };
            CalculationCell calculationCell61 = new CalculationCell() { CellReference = "AB21" };
            CalculationCell calculationCell62 = new CalculationCell() { CellReference = "AB23", InChildChain = true };
            CalculationCell calculationCell63 = new CalculationCell() { CellReference = "AC21" };
            CalculationCell calculationCell64 = new CalculationCell() { CellReference = "AC23", InChildChain = true };
            CalculationCell calculationCell65 = new CalculationCell() { CellReference = "AD21" };
            CalculationCell calculationCell66 = new CalculationCell() { CellReference = "AD23", InChildChain = true };
            CalculationCell calculationCell67 = new CalculationCell() { CellReference = "AE21" };
            CalculationCell calculationCell68 = new CalculationCell() { CellReference = "AE23", InChildChain = true };
            CalculationCell calculationCell69 = new CalculationCell() { CellReference = "AK20", NewLevel = true };
            CalculationCell calculationCell70 = new CalculationCell() { CellReference = "AK21", InChildChain = true };

            calculationChain1.Append(calculationCell1);
            calculationChain1.Append(calculationCell2);
            calculationChain1.Append(calculationCell3);
            calculationChain1.Append(calculationCell4);
            calculationChain1.Append(calculationCell5);
            calculationChain1.Append(calculationCell6);
            calculationChain1.Append(calculationCell7);
            calculationChain1.Append(calculationCell8);
            calculationChain1.Append(calculationCell9);
            calculationChain1.Append(calculationCell10);
            calculationChain1.Append(calculationCell11);
            calculationChain1.Append(calculationCell12);
            calculationChain1.Append(calculationCell13);
            calculationChain1.Append(calculationCell14);
            calculationChain1.Append(calculationCell15);
            calculationChain1.Append(calculationCell16);
            calculationChain1.Append(calculationCell17);
            calculationChain1.Append(calculationCell18);
            calculationChain1.Append(calculationCell19);
            calculationChain1.Append(calculationCell20);
            calculationChain1.Append(calculationCell21);
            calculationChain1.Append(calculationCell22);
            calculationChain1.Append(calculationCell23);
            calculationChain1.Append(calculationCell24);
            calculationChain1.Append(calculationCell25);
            calculationChain1.Append(calculationCell26);
            calculationChain1.Append(calculationCell27);
            calculationChain1.Append(calculationCell28);
            calculationChain1.Append(calculationCell29);
            calculationChain1.Append(calculationCell30);
            calculationChain1.Append(calculationCell31);
            calculationChain1.Append(calculationCell32);
            calculationChain1.Append(calculationCell33);
            calculationChain1.Append(calculationCell34);
            calculationChain1.Append(calculationCell35);
            calculationChain1.Append(calculationCell36);
            calculationChain1.Append(calculationCell37);
            calculationChain1.Append(calculationCell38);
            calculationChain1.Append(calculationCell39);
            calculationChain1.Append(calculationCell40);
            calculationChain1.Append(calculationCell41);
            calculationChain1.Append(calculationCell42);
            calculationChain1.Append(calculationCell43);
            calculationChain1.Append(calculationCell44);
            calculationChain1.Append(calculationCell45);
            calculationChain1.Append(calculationCell46);
            calculationChain1.Append(calculationCell47);
            calculationChain1.Append(calculationCell48);
            calculationChain1.Append(calculationCell49);
            calculationChain1.Append(calculationCell50);
            calculationChain1.Append(calculationCell51);
            calculationChain1.Append(calculationCell52);
            calculationChain1.Append(calculationCell53);
            calculationChain1.Append(calculationCell54);
            calculationChain1.Append(calculationCell55);
            calculationChain1.Append(calculationCell56);
            calculationChain1.Append(calculationCell57);
            calculationChain1.Append(calculationCell58);
            calculationChain1.Append(calculationCell59);
            calculationChain1.Append(calculationCell60);
            calculationChain1.Append(calculationCell61);
            calculationChain1.Append(calculationCell62);
            calculationChain1.Append(calculationCell63);
            calculationChain1.Append(calculationCell64);
            calculationChain1.Append(calculationCell65);
            calculationChain1.Append(calculationCell66);
            calculationChain1.Append(calculationCell67);
            calculationChain1.Append(calculationCell68);
            calculationChain1.Append(calculationCell69);
            calculationChain1.Append(calculationCell70);

            calculationChainPart1.CalculationChain = calculationChain1;
        }
        public static void bloom(string col, int li, string formule)
        {
            //Copie du template et ouverture du fichier
            System.IO.File.Copy("TemplateBloom.xlsx", "BloomGenerated.xlsx", true);
            SpreadsheetDocument myWorkbook = SpreadsheetDocument.Open("BloomGenerated.xlsx", true);


            //myWorkbook.WorkbookPart.Workbook.NamespaceDeclarations

            //myWorkbook.WorkbookPart.Workbook.CalculationProperties.ForceFullCalculation = true;
            //myWorkbook.WorkbookPart.Workbook.CalculationProperties.FullCalculationOnLoad = true;

            //Access the main Workbook part, which contains all references.
            WorkbookPart workbookPart = myWorkbook.WorkbookPart;


            WorksheetPart worksheetPart = workbookPart.WorksheetParts.ElementAt <WorksheetPart>(2);
            SheetData     sheetData     = worksheetPart.Worksheet.GetFirstChild <SheetData>();


            sheetData.RemoveNamespaceDeclaration("x");

            //CalculationChainPart calculationChainPart1 = workbookPart.AddNewPart<CalculationChainPart>("rId7");
            //GenerateCalculationChainPart1Content(calculationChainPart1,"C2",1);

            CalculationChain CC = workbookPart.GetPartsOfType <CalculationChainPart>().First().CalculationChain;

            CalculationCell calculationCell = new CalculationCell()
            {
                CellReference = col + li
            };

            CC.Append(calculationCell);

            //GenerateCalculationCell(CC, "C3", 1);



            Row  r    = (Row)sheetData.ChildElements.GetItem(2);
            Cell cell = GenerateCell(col + li, formule);

            //Cell cell = (Cell) r.ChildElements.GetItem(2);
            //cell.DataType = CellValues.Error;
            //cell.CellValue.Text="#NAME?";
            //cell.CellFormula.Text = formule;

            r.RemoveNamespaceDeclaration("x");
            cell.RemoveNamespaceDeclaration("x");

            r.AppendChild(cell);



            CalculationChainPart ccp = workbookPart.CalculationChainPart;

            workbookPart.DeletePart(ccp);



            myWorkbook.WorkbookPart.Workbook.Save();
            myWorkbook.Close();
        }
        // Generates content of calculationChainPart1.
        private void GenerateCalculationChainPart1Content(CalculationChainPart calculationChainPart1)
        {
            CalculationChain calculationChain1 = new CalculationChain();
            CalculationCell calculationCell1 = new CalculationCell() { CellReference = "AN29", SheetId = 26 };
            CalculationCell calculationCell2 = new CalculationCell() { CellReference = "AN26" };
            CalculationCell calculationCell3 = new CalculationCell() { CellReference = "AM26" };
            CalculationCell calculationCell4 = new CalculationCell() { CellReference = "G40" };
            CalculationCell calculationCell5 = new CalculationCell() { CellReference = "AF26" };
            CalculationCell calculationCell6 = new CalculationCell() { CellReference = "AL25" };
            CalculationCell calculationCell7 = new CalculationCell() { CellReference = "AL24" };
            CalculationCell calculationCell8 = new CalculationCell() { CellReference = "AL23" };
            CalculationCell calculationCell9 = new CalculationCell() { CellReference = "AL22" };
            CalculationCell calculationCell10 = new CalculationCell() { CellReference = "AL21" };
            CalculationCell calculationCell11 = new CalculationCell() { CellReference = "G39" };
            CalculationCell calculationCell12 = new CalculationCell() { CellReference = "G38" };
            CalculationCell calculationCell13 = new CalculationCell() { CellReference = "G37" };
            CalculationCell calculationCell14 = new CalculationCell() { CellReference = "G36" };
            CalculationCell calculationCell15 = new CalculationCell() { CellReference = "G35" };
            CalculationCell calculationCell16 = new CalculationCell() { CellReference = "AN25" };
            CalculationCell calculationCell17 = new CalculationCell() { CellReference = "AN24" };
            CalculationCell calculationCell18 = new CalculationCell() { CellReference = "AN23" };
            CalculationCell calculationCell19 = new CalculationCell() { CellReference = "G18" };
            CalculationCell calculationCell20 = new CalculationCell() { CellReference = "AN22" };
            CalculationCell calculationCell21 = new CalculationCell() { CellReference = "G26" };
            CalculationCell calculationCell22 = new CalculationCell() { CellReference = "H26" };
            CalculationCell calculationCell23 = new CalculationCell() { CellReference = "I26" };
            CalculationCell calculationCell24 = new CalculationCell() { CellReference = "J26" };
            CalculationCell calculationCell25 = new CalculationCell() { CellReference = "K26" };
            CalculationCell calculationCell26 = new CalculationCell() { CellReference = "L26" };
            CalculationCell calculationCell27 = new CalculationCell() { CellReference = "M26" };
            CalculationCell calculationCell28 = new CalculationCell() { CellReference = "N26" };
            CalculationCell calculationCell29 = new CalculationCell() { CellReference = "O26" };
            CalculationCell calculationCell30 = new CalculationCell() { CellReference = "P26" };
            CalculationCell calculationCell31 = new CalculationCell() { CellReference = "Q26" };
            CalculationCell calculationCell32 = new CalculationCell() { CellReference = "R26" };
            CalculationCell calculationCell33 = new CalculationCell() { CellReference = "S26" };
            CalculationCell calculationCell34 = new CalculationCell() { CellReference = "T26" };
            CalculationCell calculationCell35 = new CalculationCell() { CellReference = "U26" };
            CalculationCell calculationCell36 = new CalculationCell() { CellReference = "V26" };
            CalculationCell calculationCell37 = new CalculationCell() { CellReference = "W26" };
            CalculationCell calculationCell38 = new CalculationCell() { CellReference = "X26" };
            CalculationCell calculationCell39 = new CalculationCell() { CellReference = "Y26" };
            CalculationCell calculationCell40 = new CalculationCell() { CellReference = "Z26" };
            CalculationCell calculationCell41 = new CalculationCell() { CellReference = "AA26" };
            CalculationCell calculationCell42 = new CalculationCell() { CellReference = "AB26" };
            CalculationCell calculationCell43 = new CalculationCell() { CellReference = "AC26" };
            CalculationCell calculationCell44 = new CalculationCell() { CellReference = "AD26" };
            CalculationCell calculationCell45 = new CalculationCell() { CellReference = "AE26" };
            CalculationCell calculationCell46 = new CalculationCell() { CellReference = "AG26" };
            CalculationCell calculationCell47 = new CalculationCell() { CellReference = "AH26" };
            CalculationCell calculationCell48 = new CalculationCell() { CellReference = "AI26" };
            CalculationCell calculationCell49 = new CalculationCell() { CellReference = "AJ26" };
            CalculationCell calculationCell50 = new CalculationCell() { CellReference = "AK26" };
            CalculationCell calculationCell51 = new CalculationCell() { CellReference = "AL26", NewLevel = true };
            CalculationCell calculationCell52 = new CalculationCell() { CellReference = "AN21" };
            CalculationCell calculationCell53 = new CalculationCell() { CellReference = "AN30", InChildChain = true };
            CalculationCell calculationCell54 = new CalculationCell() { CellReference = "AN31", InChildChain = true };
            CalculationCell calculationCell55 = new CalculationCell() { CellReference = "AN32", NewLevel = true };
            CalculationCell calculationCell56 = new CalculationCell() { CellReference = "AN33" };

            calculationChain1.Append(calculationCell1);
            calculationChain1.Append(calculationCell2);
            calculationChain1.Append(calculationCell3);
            calculationChain1.Append(calculationCell4);
            calculationChain1.Append(calculationCell5);
            calculationChain1.Append(calculationCell6);
            calculationChain1.Append(calculationCell7);
            calculationChain1.Append(calculationCell8);
            calculationChain1.Append(calculationCell9);
            calculationChain1.Append(calculationCell10);
            calculationChain1.Append(calculationCell11);
            calculationChain1.Append(calculationCell12);
            calculationChain1.Append(calculationCell13);
            calculationChain1.Append(calculationCell14);
            calculationChain1.Append(calculationCell15);
            calculationChain1.Append(calculationCell16);
            calculationChain1.Append(calculationCell17);
            calculationChain1.Append(calculationCell18);
            calculationChain1.Append(calculationCell19);
            calculationChain1.Append(calculationCell20);
            calculationChain1.Append(calculationCell21);
            calculationChain1.Append(calculationCell22);
            calculationChain1.Append(calculationCell23);
            calculationChain1.Append(calculationCell24);
            calculationChain1.Append(calculationCell25);
            calculationChain1.Append(calculationCell26);
            calculationChain1.Append(calculationCell27);
            calculationChain1.Append(calculationCell28);
            calculationChain1.Append(calculationCell29);
            calculationChain1.Append(calculationCell30);
            calculationChain1.Append(calculationCell31);
            calculationChain1.Append(calculationCell32);
            calculationChain1.Append(calculationCell33);
            calculationChain1.Append(calculationCell34);
            calculationChain1.Append(calculationCell35);
            calculationChain1.Append(calculationCell36);
            calculationChain1.Append(calculationCell37);
            calculationChain1.Append(calculationCell38);
            calculationChain1.Append(calculationCell39);
            calculationChain1.Append(calculationCell40);
            calculationChain1.Append(calculationCell41);
            calculationChain1.Append(calculationCell42);
            calculationChain1.Append(calculationCell43);
            calculationChain1.Append(calculationCell44);
            calculationChain1.Append(calculationCell45);
            calculationChain1.Append(calculationCell46);
            calculationChain1.Append(calculationCell47);
            calculationChain1.Append(calculationCell48);
            calculationChain1.Append(calculationCell49);
            calculationChain1.Append(calculationCell50);
            calculationChain1.Append(calculationCell51);
            calculationChain1.Append(calculationCell52);
            calculationChain1.Append(calculationCell53);
            calculationChain1.Append(calculationCell54);
            calculationChain1.Append(calculationCell55);
            calculationChain1.Append(calculationCell56);

            calculationChainPart1.CalculationChain = calculationChain1;
        }
        // Generates content of calculationChainPart1.
        private void GenerateCalculationChainPart1Content(CalculationChainPart calculationChainPart1)
        {
            CalculationChain calculationChain1 = new CalculationChain();
            CalculationCell calculationCell1 = new CalculationCell() { CellReference = "J42", SheetId = 1 };
            CalculationCell calculationCell2 = new CalculationCell() { CellReference = "J37" };
            CalculationCell calculationCell3 = new CalculationCell() { CellReference = "J34" };
            CalculationCell calculationCell4 = new CalculationCell() { CellReference = "J32" };
            CalculationCell calculationCell5 = new CalculationCell() { CellReference = "H27" };
            CalculationCell calculationCell6 = new CalculationCell() { CellReference = "G27" };
            CalculationCell calculationCell7 = new CalculationCell() { CellReference = "F27" };
            CalculationCell calculationCell8 = new CalculationCell() { CellReference = "E27" };
            CalculationCell calculationCell9 = new CalculationCell() { CellReference = "D27" };
            CalculationCell calculationCell10 = new CalculationCell() { CellReference = "C27" };
            CalculationCell calculationCell11 = new CalculationCell() { CellReference = "B27" };
            CalculationCell calculationCell12 = new CalculationCell() { CellReference = "J27", InChildChain = true };
            CalculationCell calculationCell13 = new CalculationCell() { CellReference = "H22" };
            CalculationCell calculationCell14 = new CalculationCell() { CellReference = "G22" };
            CalculationCell calculationCell15 = new CalculationCell() { CellReference = "F22" };
            CalculationCell calculationCell16 = new CalculationCell() { CellReference = "E22" };
            CalculationCell calculationCell17 = new CalculationCell() { CellReference = "D22" };
            CalculationCell calculationCell18 = new CalculationCell() { CellReference = "C22" };
            CalculationCell calculationCell19 = new CalculationCell() { CellReference = "B22" };
            CalculationCell calculationCell20 = new CalculationCell() { CellReference = "J22", InChildChain = true };
            CalculationCell calculationCell21 = new CalculationCell() { CellReference = "H47", InChildChain = true };
            CalculationCell calculationCell22 = new CalculationCell() { CellReference = "H49", InChildChain = true };
            CalculationCell calculationCell23 = new CalculationCell() { CellReference = "H50", InChildChain = true };
            CalculationCell calculationCell24 = new CalculationCell() { CellReference = "H51", InChildChain = true };

            calculationChain1.Append(calculationCell1);
            calculationChain1.Append(calculationCell2);
            calculationChain1.Append(calculationCell3);
            calculationChain1.Append(calculationCell4);
            calculationChain1.Append(calculationCell5);
            calculationChain1.Append(calculationCell6);
            calculationChain1.Append(calculationCell7);
            calculationChain1.Append(calculationCell8);
            calculationChain1.Append(calculationCell9);
            calculationChain1.Append(calculationCell10);
            calculationChain1.Append(calculationCell11);
            calculationChain1.Append(calculationCell12);
            calculationChain1.Append(calculationCell13);
            calculationChain1.Append(calculationCell14);
            calculationChain1.Append(calculationCell15);
            calculationChain1.Append(calculationCell16);
            calculationChain1.Append(calculationCell17);
            calculationChain1.Append(calculationCell18);
            calculationChain1.Append(calculationCell19);
            calculationChain1.Append(calculationCell20);
            calculationChain1.Append(calculationCell21);
            calculationChain1.Append(calculationCell22);
            calculationChain1.Append(calculationCell23);
            calculationChain1.Append(calculationCell24);

            calculationChainPart1.CalculationChain = calculationChain1;
        }
        // Generates content of calculationChainPart1.
        private void GenerateCalculationChainPart1Content(CalculationChainPart calculationChainPart1)
        {
            CalculationChain calculationChain1 = new CalculationChain();
            CalculationCell calculationCell1 = new CalculationCell() { CellReference = "I49", SheetId = 1 };
            CalculationCell calculationCell2 = new CalculationCell() { CellReference = "I48" };
            CalculationCell calculationCell3 = new CalculationCell() { CellReference = "I46" };
            CalculationCell calculationCell4 = new CalculationCell() { CellReference = "I44" };
            CalculationCell calculationCell5 = new CalculationCell() { CellReference = "J42" };
            CalculationCell calculationCell6 = new CalculationCell() { CellReference = "J37" };
            CalculationCell calculationCell7 = new CalculationCell() { CellReference = "J32" };
            CalculationCell calculationCell8 = new CalculationCell() { CellReference = "J27" };
            CalculationCell calculationCell9 = new CalculationCell() { CellReference = "J22" };

            calculationChain1.Append(calculationCell1);
            calculationChain1.Append(calculationCell2);
            calculationChain1.Append(calculationCell3);
            calculationChain1.Append(calculationCell4);
            calculationChain1.Append(calculationCell5);
            calculationChain1.Append(calculationCell6);
            calculationChain1.Append(calculationCell7);
            calculationChain1.Append(calculationCell8);
            calculationChain1.Append(calculationCell9);

            calculationChainPart1.CalculationChain = calculationChain1;
        }
        // Generates content of calculationChainPart1.
        private void GenerateCalculationChainPart1Content(CalculationChainPart calculationChainPart1)
        {
            CalculationChain calculationChain1 = new CalculationChain();
            CalculationCell calculationCell1 = new CalculationCell() { CellReference = "G20", SheetId = 2 };
            CalculationCell calculationCell2 = new CalculationCell() { CellReference = "G21" };

            calculationChain1.Append(calculationCell1);
            calculationChain1.Append(calculationCell2);

            calculationChainPart1.CalculationChain = calculationChain1;
        }
        // Generates content of calculationChainPart1.
        private void GenerateCalculationChainPart1Content(CalculationChainPart calculationChainPart1)
        {
            CalculationChain calculationChain1 = new CalculationChain();
            CalculationCell calculationCell1 = new CalculationCell() { CellReference = "A6", SheetId = 1, NewLevel = true };

            calculationChain1.Append(calculationCell1);

            calculationChainPart1.CalculationChain = calculationChain1;
        }
        // Generates content of calculationChainPart1.
        private void GenerateCalculationChainPart1Content(CalculationChainPart calculationChainPart1)
        {
            CalculationChain calculationChain1 = new CalculationChain();
            CalculationCell calculationCell1 = new CalculationCell(){ CellReference = "C22", SheetId = 27 };
            CalculationCell calculationCell2 = new CalculationCell(){ CellReference = "D22" };
            CalculationCell calculationCell3 = new CalculationCell(){ CellReference = "E22" };
            CalculationCell calculationCell4 = new CalculationCell(){ CellReference = "F22" };
            CalculationCell calculationCell5 = new CalculationCell(){ CellReference = "G22" };
            CalculationCell calculationCell6 = new CalculationCell(){ CellReference = "H22" };
            CalculationCell calculationCell7 = new CalculationCell(){ CellReference = "I22" };
            CalculationCell calculationCell8 = new CalculationCell(){ CellReference = "J22" };
            CalculationCell calculationCell9 = new CalculationCell(){ CellReference = "C27" };
            CalculationCell calculationCell10 = new CalculationCell(){ CellReference = "D27" };
            CalculationCell calculationCell11 = new CalculationCell(){ CellReference = "E27" };
            CalculationCell calculationCell12 = new CalculationCell(){ CellReference = "F27" };
            CalculationCell calculationCell13 = new CalculationCell(){ CellReference = "G27" };
            CalculationCell calculationCell14 = new CalculationCell(){ CellReference = "H27" };
            CalculationCell calculationCell15 = new CalculationCell(){ CellReference = "I27" };
            CalculationCell calculationCell16 = new CalculationCell(){ CellReference = "J27" };
            CalculationCell calculationCell17 = new CalculationCell(){ CellReference = "C32" };
            CalculationCell calculationCell18 = new CalculationCell(){ CellReference = "D32" };
            CalculationCell calculationCell19 = new CalculationCell(){ CellReference = "E32" };
            CalculationCell calculationCell20 = new CalculationCell(){ CellReference = "F32" };
            CalculationCell calculationCell21 = new CalculationCell(){ CellReference = "G32" };
            CalculationCell calculationCell22 = new CalculationCell(){ CellReference = "H32" };
            CalculationCell calculationCell23 = new CalculationCell(){ CellReference = "I32" };
            CalculationCell calculationCell24 = new CalculationCell(){ CellReference = "J32" };
            CalculationCell calculationCell25 = new CalculationCell(){ CellReference = "C37" };
            CalculationCell calculationCell26 = new CalculationCell(){ CellReference = "D37" };
            CalculationCell calculationCell27 = new CalculationCell(){ CellReference = "E37" };
            CalculationCell calculationCell28 = new CalculationCell(){ CellReference = "F37" };
            CalculationCell calculationCell29 = new CalculationCell(){ CellReference = "G37" };
            CalculationCell calculationCell30 = new CalculationCell(){ CellReference = "H37" };
            CalculationCell calculationCell31 = new CalculationCell(){ CellReference = "I37" };
            CalculationCell calculationCell32 = new CalculationCell(){ CellReference = "J37" };
            CalculationCell calculationCell33 = new CalculationCell(){ CellReference = "C42" };
            CalculationCell calculationCell34 = new CalculationCell(){ CellReference = "D42" };
            CalculationCell calculationCell35 = new CalculationCell(){ CellReference = "E42" };
            CalculationCell calculationCell36 = new CalculationCell(){ CellReference = "F42" };
            CalculationCell calculationCell37 = new CalculationCell(){ CellReference = "G42" };
            CalculationCell calculationCell38 = new CalculationCell(){ CellReference = "H42" };
            CalculationCell calculationCell39 = new CalculationCell(){ CellReference = "I42" };
            CalculationCell calculationCell40 = new CalculationCell(){ CellReference = "J42" };
            CalculationCell calculationCell41 = new CalculationCell(){ CellReference = "I44" };
            CalculationCell calculationCell42 = new CalculationCell(){ CellReference = "G45" };
            CalculationCell calculationCell43 = new CalculationCell(){ CellReference = "G46" };
            CalculationCell calculationCell44 = new CalculationCell(){ CellReference = "I46" };
            CalculationCell calculationCell45 = new CalculationCell(){ CellReference = "G47" };
            CalculationCell calculationCell46 = new CalculationCell(){ CellReference = "G48" };
            CalculationCell calculationCell47 = new CalculationCell(){ CellReference = "I48" };
            CalculationCell calculationCell48 = new CalculationCell(){ CellReference = "G49" };
            CalculationCell calculationCell49 = new CalculationCell(){ CellReference = "I49" };
            CalculationCell calculationCell50 = new CalculationCell(){ CellReference = "G50" };

            calculationChain1.Append(calculationCell1);
            calculationChain1.Append(calculationCell2);
            calculationChain1.Append(calculationCell3);
            calculationChain1.Append(calculationCell4);
            calculationChain1.Append(calculationCell5);
            calculationChain1.Append(calculationCell6);
            calculationChain1.Append(calculationCell7);
            calculationChain1.Append(calculationCell8);
            calculationChain1.Append(calculationCell9);
            calculationChain1.Append(calculationCell10);
            calculationChain1.Append(calculationCell11);
            calculationChain1.Append(calculationCell12);
            calculationChain1.Append(calculationCell13);
            calculationChain1.Append(calculationCell14);
            calculationChain1.Append(calculationCell15);
            calculationChain1.Append(calculationCell16);
            calculationChain1.Append(calculationCell17);
            calculationChain1.Append(calculationCell18);
            calculationChain1.Append(calculationCell19);
            calculationChain1.Append(calculationCell20);
            calculationChain1.Append(calculationCell21);
            calculationChain1.Append(calculationCell22);
            calculationChain1.Append(calculationCell23);
            calculationChain1.Append(calculationCell24);
            calculationChain1.Append(calculationCell25);
            calculationChain1.Append(calculationCell26);
            calculationChain1.Append(calculationCell27);
            calculationChain1.Append(calculationCell28);
            calculationChain1.Append(calculationCell29);
            calculationChain1.Append(calculationCell30);
            calculationChain1.Append(calculationCell31);
            calculationChain1.Append(calculationCell32);
            calculationChain1.Append(calculationCell33);
            calculationChain1.Append(calculationCell34);
            calculationChain1.Append(calculationCell35);
            calculationChain1.Append(calculationCell36);
            calculationChain1.Append(calculationCell37);
            calculationChain1.Append(calculationCell38);
            calculationChain1.Append(calculationCell39);
            calculationChain1.Append(calculationCell40);
            calculationChain1.Append(calculationCell41);
            calculationChain1.Append(calculationCell42);
            calculationChain1.Append(calculationCell43);
            calculationChain1.Append(calculationCell44);
            calculationChain1.Append(calculationCell45);
            calculationChain1.Append(calculationCell46);
            calculationChain1.Append(calculationCell47);
            calculationChain1.Append(calculationCell48);
            calculationChain1.Append(calculationCell49);
            calculationChain1.Append(calculationCell50);

            calculationChainPart1.CalculationChain = calculationChain1;
        }