[FreeTutorials.Us] beginner-to-pro-in-excel-financial-modeling-and-valuation torrent, magnet, bt

Latest Search: 1.Carib-102715 2.RAW-004 3.MAR13 4.stars 590 5.gvg-182

[FreeTutorials.Us] beginner-to-pro-in-excel-financial-modeling-and-valuation

magnet:?xt=urn:btih:2FA64DD36BD59F74BF155668E707D04551B5B264&dn=%5BFreeTutorials.Us%5D%20beginner-to-pro-in-excel-financial-modeling-and-valuation

QR Code Copy to Clipboard Open with BT Client

Torrent Hash:

2FA64DD36BD59F74BF155668E707D04551B5B264

Number of Files:

406

Content Size:

2.36GB

Convert On:

2019-06-16

Keywords:

FreeTutorials Us beginner to pro in excel financial modeling and valuation

Magnet Link:

magnet:?xt=urn:btih:2FA64DD36BD59F74BF155668E707D04551B5B264&dn=%5BFreeTutorials.Us%5D%20beginner-to-pro-in-excel-financial-modeling-and-valuation

Link:

//btsow.motorcycles/magnet/detail/hash/2FA64DD36BD59F74BF155668E707D04551B5B264

Download

Play Now

File Name

Size

01 Beginner to Pro in Excel Financial Modeling and Valuation - Welcome/001 What does the course cover.mp4

8.94MB

01 Beginner to Pro in Excel Financial Modeling and Valuation - Welcome/002 Bonus Welcome gift.pdf

171.24KB

01 Beginner to Pro in Excel Financial Modeling and Valuation - Welcome/003 Welcome gift number 2.pdf

161.69KB

01 Beginner to Pro in Excel Financial Modeling and Valuation - Welcome/004 The best way to take this course.mp4

7.82MB

02 Introduction to Excel/005 Introduction to Excel - Welcome Lecture.mp4

1.99MB

02 Introduction to Excel/006 Overview of Excel.mp4

13.95MB

02 Introduction to Excel/007 Basic Manipulations with Rows Columns.mp4

6.9MB

02 Introduction to Excel/008 The Excel Ribbon.mp4

8.8MB

02 Introduction to Excel/009 Data Entry in Excel.mp4

10.39MB

02 Introduction to Excel/010 Introduction to Formatting.mp4

24.75MB

02 Introduction to Excel/011 Introduction to Excel Formulas.mp4

8.69MB

02 Introduction to Excel/012 Introduction to Excel Functions.mp4

12.05MB

02 Introduction to Excel/013 Cut Copy Paste.mp4

7.56MB

02 Introduction to Excel/014 Paste Special.mp4

6.69MB

02 Introduction to Excel/015 Basic operations in Excel - 38 pages.pdf

5.04MB

02 Introduction to Excel/attached_files/006 Overview of Excel/02-6-Overview-of-Excel-Exercise-Text.xlsx

10.47KB

02 Introduction to Excel/attached_files/006 Overview of Excel/02-6-Overview-of-Excel-Solved.xlsx

10.88KB

02 Introduction to Excel/attached_files/007 Basic Manipulations with Rows Columns/02-7-Basic-Manipulations-Exercise-Text.xlsx

11.06KB

02 Introduction to Excel/attached_files/007 Basic Manipulations with Rows Columns/02-7-Basic-Manipulations-Solved.xlsx

32.43KB

02 Introduction to Excel/attached_files/008 The Excel Ribbon/02-8-The-Ribbon-Exercise-Text.xlsx

12.09KB

02 Introduction to Excel/attached_files/008 The Excel Ribbon/02-8-The-Ribbon-Solved.xlsx

402.84KB

02 Introduction to Excel/attached_files/009 Data Entry in Excel/02-9-Data-Entry-Exercise-Text.xlsx

10.97KB

02 Introduction to Excel/attached_files/009 Data Entry in Excel/02-9-Data-Entry-Solved.xlsx

32.76KB

02 Introduction to Excel/attached_files/010 Introduction to Formatting/02-10-Formatting-Exercise-Text.xlsx

11.61KB

02 Introduction to Excel/attached_files/010 Introduction to Formatting/02-10-Formatting-Solved.xlsx

11.59KB

02 Introduction to Excel/attached_files/010 Introduction to Formatting/Formatting-Solved.xlsx

9.85KB

02 Introduction to Excel/attached_files/010 Introduction to Formatting/Formatting-Unsolved.xlsx

8.91KB

02 Introduction to Excel/attached_files/011 Introduction to Excel Formulas/02-11-Formulas-Exercise-Text.xlsx

11.72KB

02 Introduction to Excel/attached_files/011 Introduction to Excel Formulas/02-11-Formulas-Solved.xlsx

80.13KB

02 Introduction to Excel/attached_files/011 Introduction to Excel Formulas/Formulas-Solved.xlsx

9.36KB

02 Introduction to Excel/attached_files/011 Introduction to Excel Formulas/Formulas-Unsolved.xlsx

9.3KB

02 Introduction to Excel/attached_files/012 Introduction to Excel Functions/02-12-Functions-Exercise-Text.xlsx

13.26KB

02 Introduction to Excel/attached_files/012 Introduction to Excel Functions/02-12-Functions-Solved.xlsx

81.1KB

02 Introduction to Excel/attached_files/012 Introduction to Excel Functions/Functions-Solved.xlsx

9.34KB

02 Introduction to Excel/attached_files/012 Introduction to Excel Functions/Functions-Unsolved.xlsx

9.24KB

02 Introduction to Excel/attached_files/013 Cut Copy Paste/02-13-Copy-Cut-Paste-Exercise-Text.xlsx

11.34KB

02 Introduction to Excel/attached_files/013 Cut Copy Paste/02-13-Copy-Cut-Paste-Solved.xlsx

12.56KB

02 Introduction to Excel/attached_files/014 Paste Special/02-14-Paste-Special-Exercise-Text.xlsx

13.47KB

02 Introduction to Excel/attached_files/014 Paste Special/02-14-Paste-Special-Solved.xlsx

13.46KB

02 Introduction to Excel/attached_files/015 Basic operations in Excel - 38 pages/Introduction-to-Excels-basic-features.pdf

4.67MB

02 Introduction to Excel/quizzes/001 Overview of Excel.html

2.44KB

02 Introduction to Excel/quizzes/002 Rows Columns.html

2.97KB

02 Introduction to Excel/quizzes/003 Introduction to Excel Formulas.html

2.6KB

02 Introduction to Excel/quizzes/004 Cut Copy Paste.html

2.79KB

03 Useful tips and tools for your work in Excel/016 Excel Best Practices - Welcome Lecture.mp4

2.13MB

03 Useful tips and tools for your work in Excel/017 Initial formatting of an Excel sheet in order to render it professional.mp4

7.98MB

03 Useful tips and tools for your work in Excel/018 Fast scrolling through Excel sheets.mp4

22.16MB

03 Useful tips and tools for your work in Excel/019 Introduction to fixing of cell references.mp4

20.37MB

03 Useful tips and tools for your work in Excel/020 Using the Alt plus Enter combination.mp4

3.33MB

03 Useful tips and tools for your work in Excel/021 Learn how to organize your data with Text to Columns.mp4

12.53MB

03 Useful tips and tools for your work in Excel/022 Learn how to Use the Wrap Text Button.mp4

2.14MB

03 Useful tips and tools for your work in Excel/023 Create easily printable documents in Excel by using Set Print Area.mp4

4.73MB

03 Useful tips and tools for your work in Excel/024 Find and select special types of cells with Select Special F5.mp4

9.78MB

03 Useful tips and tools for your work in Excel/025 Learn how to assign dynamic names within a Financial Model.mp4

7.31MB

03 Useful tips and tools for your work in Excel/026 Define a named range in Excel.mp4

5.42MB

03 Useful tips and tools for your work in Excel/027 Assign custom formats to specific cells within a Financial Model ex. Multiples.mp4

5.41MB

03 Useful tips and tools for your work in Excel/028 Macros are a great timesaver Heres why.mp4

11.1MB

03 Useful tips and tools for your work in Excel/029 Create a drop-down list by using Data Validation.mp4

10.58MB

03 Useful tips and tools for your work in Excel/030 Using Custom-sort in order to sort multiple columns within a table.mp4

9.14MB

03 Useful tips and tools for your work in Excel/031 Create a great Index page at the beginning of your models - Hyperlinks.mp4

5.35MB

03 Useful tips and tools for your work in Excel/032 Fix the top row of your table with Freeze Panes.mp4

17.67MB

03 Useful tips and tools for your work in Excel/033 Filter by color - an excellent tool.mp4

9.87MB

03 Useful tips and tools for your work in Excel/034 Working with conditional formatting.mp4

15.08MB

03 Useful tips and tools for your work in Excel/attached_files/017 Initial formatting of an Excel sheet in order to render it professional/Formatting-a-worksheet-Solved.xlsx

9.56KB

03 Useful tips and tools for your work in Excel/attached_files/017 Initial formatting of an Excel sheet in order to render it professional/Formatting-a-worksheet-Unsolved.xlsx

8.98KB

03 Useful tips and tools for your work in Excel/attached_files/017 Initial formatting of an Excel sheet in order to render it professional/Useful-Tips-Tools-PDF-Version.pdf

9.43MB

03 Useful tips and tools for your work in Excel/attached_files/018 Fast scrolling through Excel sheets/03-18-Fast-Scrolling-Exercise-Text.xlsx

43.9KB

03 Useful tips and tools for your work in Excel/attached_files/018 Fast scrolling through Excel sheets/03-18-Fast-Scrolling-Solved.xlsx

44.35KB

03 Useful tips and tools for your work in Excel/attached_files/018 Fast scrolling through Excel sheets/2.Fast-Scrolling-Solved.xlsx

642.51KB

03 Useful tips and tools for your work in Excel/attached_files/018 Fast scrolling through Excel sheets/Useful-Tips-Tools-PDF-Version.pdf

9.43MB

03 Useful tips and tools for your work in Excel/attached_files/018 Fast scrolling through Excel sheets/Useful-tips-and-tools-Excel-file.xlsx

2.24MB

03 Useful tips and tools for your work in Excel/attached_files/019 Introduction to fixing of cell references/03-19-Fixing-Cells-Exercise-Text.xlsx

10.67KB

03 Useful tips and tools for your work in Excel/attached_files/019 Introduction to fixing of cell references/03-19-Fixing-Cells-Solved.xlsx

10.82KB

03 Useful tips and tools for your work in Excel/attached_files/019 Introduction to fixing of cell references/Fixing-references-Solved.xlsx

645.17KB

03 Useful tips and tools for your work in Excel/attached_files/019 Introduction to fixing of cell references/Fixing-references-Unsolved.xlsx

643.98KB

03 Useful tips and tools for your work in Excel/attached_files/019 Introduction to fixing of cell references/Useful-Tips-Tools-PDF-Version.pdf

9.43MB

03 Useful tips and tools for your work in Excel/attached_files/020 Using the Alt plus Enter combination/03-20-Alt-Enter-Exercise-Text.xlsx

11.12KB

03 Useful tips and tools for your work in Excel/attached_files/020 Using the Alt plus Enter combination/03-20-Alt-Enter-Solved.xlsx

11.4KB

03 Useful tips and tools for your work in Excel/attached_files/020 Using the Alt plus Enter combination/Alt-Enter-Solved.xlsx

9.65KB

03 Useful tips and tools for your work in Excel/attached_files/020 Using the Alt plus Enter combination/Alt-Enter-Unsolved.xlsx

9.64KB

03 Useful tips and tools for your work in Excel/attached_files/020 Using the Alt plus Enter combination/Useful-Tips-Tools-PDF-Version.pdf

9.43MB

03 Useful tips and tools for your work in Excel/attached_files/021 Learn how to organize your data with Text to Columns/03-21-Text-to-Columns-Exercise-Text.xlsx

10.57KB

03 Useful tips and tools for your work in Excel/attached_files/021 Learn how to organize your data with Text to Columns/03-21-Text-to-Columns-Solved.xlsx

11.3KB

03 Useful tips and tools for your work in Excel/attached_files/021 Learn how to organize your data with Text to Columns/Text-to-columns-Solved.xlsx

9.9KB

03 Useful tips and tools for your work in Excel/attached_files/021 Learn how to organize your data with Text to Columns/Text-to-columns-Unsolved.xlsx

9.76KB

03 Useful tips and tools for your work in Excel/attached_files/021 Learn how to organize your data with Text to Columns/Useful-Tips-Tools-PDF-Version.pdf

9.43MB

03 Useful tips and tools for your work in Excel/attached_files/022 Learn how to Use the Wrap Text Button/03-22-Wrap-Text-Exercise-Text.xlsx

10.17KB

03 Useful tips and tools for your work in Excel/attached_files/022 Learn how to Use the Wrap Text Button/03-22-Wrap-Text-Solved.xlsx

10.2KB

03 Useful tips and tools for your work in Excel/attached_files/022 Learn how to Use the Wrap Text Button/Useful-Tips-Tools-PDF-Version.pdf

9.43MB

03 Useful tips and tools for your work in Excel/attached_files/022 Learn how to Use the Wrap Text Button/Wrap-text-Solved.xlsx

9.61KB

03 Useful tips and tools for your work in Excel/attached_files/022 Learn how to Use the Wrap Text Button/Wrap-text-Unsolved.xlsx

9.61KB

03 Useful tips and tools for your work in Excel/attached_files/023 Create easily printable documents in Excel by using Set Print Area/Set-Print-Area-Solved.xlsx

11.22KB

03 Useful tips and tools for your work in Excel/attached_files/023 Create easily printable documents in Excel by using Set Print Area/Set-Print-Area-Unsolved.xlsx

11.42KB

03 Useful tips and tools for your work in Excel/attached_files/023 Create easily printable documents in Excel by using Set Print Area/Useful-Tips-Tools-PDF-Version.pdf

9.43MB

03 Useful tips and tools for your work in Excel/attached_files/024 Find and select special types of cells with Select Special F5/03-24-Select-Special-F5-Exercise-Text.xlsx

21.59KB

03 Useful tips and tools for your work in Excel/attached_files/024 Find and select special types of cells with Select Special F5/03-24-Select-Special-F5-Solved.xlsx

22.27KB

03 Useful tips and tools for your work in Excel/attached_files/024 Find and select special types of cells with Select Special F5/Select-Special.xlsx

10.56KB

03 Useful tips and tools for your work in Excel/attached_files/024 Find and select special types of cells with Select Special F5/Useful-Tips-Tools-PDF-Version.pdf

9.43MB

03 Useful tips and tools for your work in Excel/attached_files/025 Learn how to assign dynamic names within a Financial Model/03-25-Assigning-Dynamic-Names-Exercise-Text.xlsx

11.23KB

03 Useful tips and tools for your work in Excel/attached_files/025 Learn how to assign dynamic names within a Financial Model/03-25-Assigning-Dynamic-Names-Solved.xlsx

11.73KB

03 Useful tips and tools for your work in Excel/attached_files/025 Learn how to assign dynamic names within a Financial Model/Dynamic-Naming-Solved.xlsx

13.83KB

03 Useful tips and tools for your work in Excel/attached_files/025 Learn how to assign dynamic names within a Financial Model/Dynamic-Naming-Unsolved.xlsx

13.54KB

03 Useful tips and tools for your work in Excel/attached_files/025 Learn how to assign dynamic names within a Financial Model/Useful-Tips-Tools-PDF-Version.pdf

9.43MB

03 Useful tips and tools for your work in Excel/attached_files/026 Define a named range in Excel/03-26-Defining-a-Named-Range-Exercise-Text.xlsx

11.07KB

03 Useful tips and tools for your work in Excel/attached_files/026 Define a named range in Excel/03-26-Defining-a-Named-Range-Solved.xlsx

11.65KB

03 Useful tips and tools for your work in Excel/attached_files/026 Define a named range in Excel/Naming-ranges-Solved.xlsx

10.34KB

03 Useful tips and tools for your work in Excel/attached_files/026 Define a named range in Excel/Naming-ranges-Unsolved.xlsx

8.79KB

03 Useful tips and tools for your work in Excel/attached_files/026 Define a named range in Excel/Useful-Tips-Tools-PDF-Version.pdf

9.43MB

03 Useful tips and tools for your work in Excel/attached_files/028 Macros are a great timesaver Heres why/03-28-Macros-Exercise-Text.xlsx

10.34KB

03 Useful tips and tools for your work in Excel/attached_files/028 Macros are a great timesaver Heres why/03-28-Macros-Solved.xlsx

145.02KB

03 Useful tips and tools for your work in Excel/attached_files/028 Macros are a great timesaver Heres why/Creating-a-Macro-Solved.xlsx

11.17KB

03 Useful tips and tools for your work in Excel/attached_files/028 Macros are a great timesaver Heres why/Creating-a-Macro-Unsolved.xlsx

9.66KB

03 Useful tips and tools for your work in Excel/attached_files/028 Macros are a great timesaver Heres why/Useful-Tips-Tools-PDF-Version.pdf

9.43MB

03 Useful tips and tools for your work in Excel/attached_files/029 Create a drop-down list by using Data Validation/03-29-Drop-down-List-Exercise-Text.xlsx

11.34KB

03 Useful tips and tools for your work in Excel/attached_files/029 Create a drop-down list by using Data Validation/03-29-Drop-down-List-Solved.xlsx

77.02KB

03 Useful tips and tools for your work in Excel/attached_files/029 Create a drop-down list by using Data Validation/Data-Validation-Solved.xlsx

10.84KB

03 Useful tips and tools for your work in Excel/attached_files/029 Create a drop-down list by using Data Validation/Data-Validation-Unsolved.xlsx

10.84KB

03 Useful tips and tools for your work in Excel/attached_files/029 Create a drop-down list by using Data Validation/Useful-Tips-Tools-PDF-Version.pdf

9.43MB

03 Useful tips and tools for your work in Excel/attached_files/030 Using Custom-sort in order to sort multiple columns within a table/03-30-Custom-Sort-Exercise-Text.xlsx

11.37KB

03 Useful tips and tools for your work in Excel/attached_files/030 Using Custom-sort in order to sort multiple columns within a table/03-30-Custom-Sort-Solved.xlsx

11.46KB

03 Useful tips and tools for your work in Excel/attached_files/030 Using Custom-sort in order to sort multiple columns within a table/Sort-data-Solved.xlsx

145.65KB

03 Useful tips and tools for your work in Excel/attached_files/030 Using Custom-sort in order to sort multiple columns within a table/Sort-data-Unsolved.xlsx

145.35KB

03 Useful tips and tools for your work in Excel/attached_files/030 Using Custom-sort in order to sort multiple columns within a table/Useful-Tips-Tools-PDF-Version.pdf

9.43MB

03 Useful tips and tools for your work in Excel/attached_files/031 Create a great Index page at the beginning of your models - Hyperlinks/03-31-Hyperlinks-Exercise-Text.xlsx

136.89KB

03 Useful tips and tools for your work in Excel/attached_files/031 Create a great Index page at the beginning of your models - Hyperlinks/03-31-Hyperlinks-Solved.xlsx

137.06KB

03 Useful tips and tools for your work in Excel/attached_files/031 Create a great Index page at the beginning of your models - Hyperlinks/Useful-Tips-And-Tools-Excel-File.xlsx

2.24MB

03 Useful tips and tools for your work in Excel/attached_files/031 Create a great Index page at the beginning of your models - Hyperlinks/Useful-Tips-Tools-PDF-Version.pdf

9.43MB

03 Useful tips and tools for your work in Excel/attached_files/032 Fix the top row of your table with Freeze Panes/Freeze-Panes-Solved.xlsx

643.94KB

03 Useful tips and tools for your work in Excel/attached_files/032 Fix the top row of your table with Freeze Panes/Freeze-Panes-Unsolved.xlsx

643.87KB

03 Useful tips and tools for your work in Excel/attached_files/032 Fix the top row of your table with Freeze Panes/Useful-Tips-Tools-PDF-Version.pdf

9.43MB

03 Useful tips and tools for your work in Excel/attached_files/033 Filter by color - an excellent tool/Exercise-Filter-by-Color.xlsx

20.47KB

03 Useful tips and tools for your work in Excel/attached_files/033 Filter by color - an excellent tool/Solution-Filter-by-Color.xlsx

153.48KB

03 Useful tips and tools for your work in Excel/attached_files/034 Working with conditional formatting/Exercise-Conditional-Formatting.xlsx

12.88KB

03 Useful tips and tools for your work in Excel/attached_files/034 Working with conditional formatting/Solution-Conditional-Formatting.xlsx

51.52KB

03 Useful tips and tools for your work in Excel/quizzes/005 Fast scrolling through Excel sheets.html

2.79KB

03 Useful tips and tools for your work in Excel/quizzes/006 Introduction to fixing of cell references.html

2.91KB

03 Useful tips and tools for your work in Excel/quizzes/007 Learn how to organize your data with Text to Columns.html

2.6KB

03 Useful tips and tools for your work in Excel/quizzes/008 Select Special.html

2.69KB

03 Useful tips and tools for your work in Excel/quizzes/009 Assigning dynamic names.html

2.86KB

03 Useful tips and tools for your work in Excel/quizzes/010 Excel Macros - Quiz.html

2.72KB

03 Useful tips and tools for your work in Excel/quizzes/011 Useful tips and tools for your work in Excel - Quiz.html

6.17KB

04 Keyboard shortcuts in Excel/035 Keyboard Shortcuts Save LOTS of time in Excel.mp4

30.43MB

04 Keyboard shortcuts in Excel/036 Keyboard shortcuts in Excel.pdf

1.59MB

04 Keyboard shortcuts in Excel/attached_files/036 Keyboard shortcuts in Excel/Beginner-to-Pro-in-Excel-Shortcuts-for-MAC.pdf

769.21KB

04 Keyboard shortcuts in Excel/attached_files/036 Keyboard shortcuts in Excel/Beginner-to-Pro-in-Excel-Shortcuts.pdf

1.26MB

05 Excels key functions and functionalities made easy/037 Excels Key Functions - Welcome Lecture.mp4

2.31MB

05 Excels key functions and functionalities made easy/038 Key Functions in Excel If.pdf

565.94KB

05 Excels key functions and functionalities made easy/039 Key Excel Functions Sum Sumif and Sumifs.mp4

19.32MB

05 Excels key functions and functionalities made easy/040 Key Excel Functions Count Counta Countif Countifs.mp4

16.98MB

05 Excels key functions and functionalities made easy/041 Key Excel Functions Average and Averageif.mp4

7.85MB

05 Excels key functions and functionalities made easy/042 Elaborate text efficiently Left Right Mid Upper LowerProper Concatenate.mp4

16.79MB

05 Excels key functions and functionalities made easy/043 Find the minimum or maximum value in a range of cells in Excel.mp4

5.91MB

05 Excels key functions and functionalities made easy/044 Include Round in your Financial Models.mp4

3.12MB

05 Excels key functions and functionalities made easy/045 Learn how to transfer data efficiently in Excel Vlookup and Hlookup.mp4

34.59MB

05 Excels key functions and functionalities made easy/046 Index Match and their combination - the perfect substitute of Vlookup.mp4

38.95MB

05 Excels key functions and functionalities made easy/047 A great Excel technique Index Match Match.mp4

11.76MB

05 Excels key functions and functionalities made easy/048 Using Excels Iferror function to trap spreadsheet errors.mp4

7.51MB

05 Excels key functions and functionalities made easy/049 Learn how to render your models flexible with Choose.mp4

8.98MB

05 Excels key functions and functionalities made easy/050 Use Goal Seek in order to find the result that you are looking for.mp4

7.85MB

05 Excels key functions and functionalities made easy/051 Include sensitivity analysis in your models through Data Tables.mp4

14.28MB

05 Excels key functions and functionalities made easy/052 Excels dynamic and interactive tables Pivot tables.mp4

16.58MB

05 Excels key functions and functionalities made easy/attached_files/038 Key Functions in Excel If/Excel-Functions.xlsx

971.02KB

05 Excels key functions and functionalities made easy/attached_files/038 Key Functions in Excel If/If-Solved.xlsx

9.45KB

05 Excels key functions and functionalities made easy/attached_files/038 Key Functions in Excel If/If-Unsolved.xlsx

9.02KB

05 Excels key functions and functionalities made easy/attached_files/039 Key Excel Functions Sum Sumif and Sumifs/05-37-Sum-Sumif-Sumifs-Exercise-Text.xlsx

14.46KB

05 Excels key functions and functionalities made easy/attached_files/039 Key Excel Functions Sum Sumif and Sumifs/05-37-Sum-Sumif-Sumifs-Solved.xlsx

14.84KB

05 Excels key functions and functionalities made easy/attached_files/039 Key Excel Functions Sum Sumif and Sumifs/Key-Functions-In-Excel.pdf

9.84MB

05 Excels key functions and functionalities made easy/attached_files/039 Key Excel Functions Sum Sumif and Sumifs/Sum-Sumif-Sumifs-Solved.xlsx

13.01KB

05 Excels key functions and functionalities made easy/attached_files/039 Key Excel Functions Sum Sumif and Sumifs/Sum-Sumif-Sumifs-Unsolved.xlsx

12.93KB

05 Excels key functions and functionalities made easy/attached_files/040 Key Excel Functions Count Counta Countif Countifs/05-38-Counts-Exercise-Text.xlsx

15.26KB

05 Excels key functions and functionalities made easy/attached_files/040 Key Excel Functions Count Counta Countif Countifs/05-38-Counts-Solved.xlsx

15.66KB

05 Excels key functions and functionalities made easy/attached_files/040 Key Excel Functions Count Counta Countif Countifs/Count-Countif-Countifs-Solved.xlsx

11.68KB

05 Excels key functions and functionalities made easy/attached_files/040 Key Excel Functions Count Counta Countif Countifs/Count-Countif-Countifs-Unsolved.xlsx

11.29KB

05 Excels key functions and functionalities made easy/attached_files/040 Key Excel Functions Count Counta Countif Countifs/Key-Functions-In-Excel.pdf

9.84MB

05 Excels key functions and functionalities made easy/attached_files/041 Key Excel Functions Average and Averageif/05-39-Average-AverageIF-Exercise-Text.xlsx

14.6KB

05 Excels key functions and functionalities made easy/attached_files/041 Key Excel Functions Average and Averageif/05-39-Average-AverageIF-Solution.xlsx

15.02KB

05 Excels key functions and functionalities made easy/attached_files/041 Key Excel Functions Average and Averageif/Average-Averageif-Solved.xlsx

9.4KB

05 Excels key functions and functionalities made easy/attached_files/041 Key Excel Functions Average and Averageif/Average-Averageif-Unsolved.xlsx

9.03KB

05 Excels key functions and functionalities made easy/attached_files/042 Elaborate text efficiently Left Right Mid Upper LowerProper Concatenate/Key-Functions-In-Excel.pdf

9.84MB

05 Excels key functions and functionalities made easy/attached_files/042 Elaborate text efficiently Left Right Mid Upper LowerProper Concatenate/Text-Functions-Solved.xlsx

11.1KB

05 Excels key functions and functionalities made easy/attached_files/042 Elaborate text efficiently Left Right Mid Upper LowerProper Concatenate/Text-Functions-Unsolved.xlsx

10.6KB

05 Excels key functions and functionalities made easy/attached_files/043 Find the minimum or maximum value in a range of cells in Excel/05-41-MIN-MAX-Exercise-Text.xlsx

14.39KB

05 Excels key functions and functionalities made easy/attached_files/043 Find the minimum or maximum value in a range of cells in Excel/05-41-MIN-MAX-Solved.xlsx

14.8KB

05 Excels key functions and functionalities made easy/attached_files/043 Find the minimum or maximum value in a range of cells in Excel/Max-min-Solved.xlsx

9.23KB

05 Excels key functions and functionalities made easy/attached_files/043 Find the minimum or maximum value in a range of cells in Excel/Max-min-Unsolved.xlsx

8.95KB

05 Excels key functions and functionalities made easy/attached_files/044 Include Round in your Financial Models/05-42-Round-Exercise-Text.xlsx

11.34KB

05 Excels key functions and functionalities made easy/attached_files/044 Include Round in your Financial Models/05-42-Round-Solved.xlsx

11.71KB

05 Excels key functions and functionalities made easy/attached_files/044 Include Round in your Financial Models/Excel-Functions.xlsx

971.02KB

05 Excels key functions and functionalities made easy/attached_files/044 Include Round in your Financial Models/Key-Functions-In-Excel.pdf

9.84MB

05 Excels key functions and functionalities made easy/attached_files/045 Learn how to transfer data efficiently in Excel Vlookup and Hlookup/05-43-Vlookup-Hlookup-Solved.xlsx

13.68KB

05 Excels key functions and functionalities made easy/attached_files/045 Learn how to transfer data efficiently in Excel Vlookup and Hlookup/Key-Functions-In-Excel.pdf

9.84MB

05 Excels key functions and functionalities made easy/attached_files/045 Learn how to transfer data efficiently in Excel Vlookup and Hlookup/Vlookup-Hlookup-Solved.xlsx

11.13KB

05 Excels key functions and functionalities made easy/attached_files/045 Learn how to transfer data efficiently in Excel Vlookup and Hlookup/Vlookup-Hlookup-Unsolved.xlsx

10.74KB

05 Excels key functions and functionalities made easy/attached_files/046 Index Match and their combination - the perfect substitute of Vlookup/05-44-Index-Match-Solved.xlsx

12.08KB

05 Excels key functions and functionalities made easy/attached_files/046 Index Match and their combination - the perfect substitute of Vlookup/Index-Match-Solved.xlsx

11.7KB

05 Excels key functions and functionalities made easy/attached_files/046 Index Match and their combination - the perfect substitute of Vlookup/Index-Match-Unsolved.xlsx

11.29KB

05 Excels key functions and functionalities made easy/attached_files/046 Index Match and their combination - the perfect substitute of Vlookup/Key-Functions-In-Excel.pdf

9.84MB

05 Excels key functions and functionalities made easy/attached_files/047 A great Excel technique Index Match Match/Exercise-Index-Match-Match.xlsx

11.58KB

05 Excels key functions and functionalities made easy/attached_files/047 A great Excel technique Index Match Match/Solution-Index-Match-Match.xlsx

12.21KB

05 Excels key functions and functionalities made easy/attached_files/048 Using Excels Iferror function to trap spreadsheet errors/05-45-IFERROR-Exercise-Text.xlsx

14.26KB

05 Excels key functions and functionalities made easy/attached_files/048 Using Excels Iferror function to trap spreadsheet errors/05-45-IFERROR-Solved.xlsx

15.37KB

05 Excels key functions and functionalities made easy/attached_files/048 Using Excels Iferror function to trap spreadsheet errors/Iferror-Unsolved.xlsx

9.41KB

05 Excels key functions and functionalities made easy/attached_files/048 Using Excels Iferror function to trap spreadsheet errors/Iferror.xlsx

9.61KB

05 Excels key functions and functionalities made easy/attached_files/048 Using Excels Iferror function to trap spreadsheet errors/Key-Functions-In-Excel.pdf

9.84MB

05 Excels key functions and functionalities made easy/attached_files/049 Learn how to render your models flexible with Choose/05-46-Choose-Exercise-Text.xlsx

11.32KB

05 Excels key functions and functionalities made easy/attached_files/049 Learn how to render your models flexible with Choose/05-46-Choose-Solved.xlsx

11.73KB

05 Excels key functions and functionalities made easy/attached_files/049 Learn how to render your models flexible with Choose/Choose-Solved.xlsx

9.69KB

05 Excels key functions and functionalities made easy/attached_files/049 Learn how to render your models flexible with Choose/Choose-Unsolved.xlsx

9.33KB

05 Excels key functions and functionalities made easy/attached_files/049 Learn how to render your models flexible with Choose/Key-Functions-In-Excel.pdf

9.84MB

05 Excels key functions and functionalities made easy/attached_files/050 Use Goal Seek in order to find the result that you are looking for/05-47-Goal-Seek-Exercise-Text.xlsx

16.09KB

05 Excels key functions and functionalities made easy/attached_files/050 Use Goal Seek in order to find the result that you are looking for/05-47-Goal-Seek-Solved.xlsx

16.21KB

05 Excels key functions and functionalities made easy/attached_files/050 Use Goal Seek in order to find the result that you are looking for/Goal-Seek-Solved.xlsx

8.86KB

05 Excels key functions and functionalities made easy/attached_files/050 Use Goal Seek in order to find the result that you are looking for/Goal-Seek-Unsolved.xlsx

8.85KB

05 Excels key functions and functionalities made easy/attached_files/050 Use Goal Seek in order to find the result that you are looking for/Key-Functions-In-Excel.pdf

9.84MB

05 Excels key functions and functionalities made easy/attached_files/051 Include sensitivity analysis in your models through Data Tables/05-48-Sensitivity-Analysis-Solved.xlsx

13.05KB

05 Excels key functions and functionalities made easy/attached_files/051 Include sensitivity analysis in your models through Data Tables/Data-Tables-Solved.xlsx

9.46KB

05 Excels key functions and functionalities made easy/attached_files/051 Include sensitivity analysis in your models through Data Tables/Data-Tables-Unsolved.xlsx

9.25KB

05 Excels key functions and functionalities made easy/attached_files/051 Include sensitivity analysis in your models through Data Tables/Key-Functions-In-Excel.pdf

9.84MB

05 Excels key functions and functionalities made easy/attached_files/052 Excels dynamic and interactive tables Pivot tables/05-49-Pivot-Tables-Intro-Exercise-Text.xlsx

152.17KB

05 Excels key functions and functionalities made easy/attached_files/052 Excels dynamic and interactive tables Pivot tables/05-49-Pivot-Tables-Intro-Solved.xlsx

190.07KB

05 Excels key functions and functionalities made easy/attached_files/052 Excels dynamic and interactive tables Pivot tables/Excel-Functions.xlsx

971.02KB

05 Excels key functions and functionalities made easy/attached_files/052 Excels dynamic and interactive tables Pivot tables/Key-Functions-In-Excel.pdf

9.84MB

05 Excels key functions and functionalities made easy/quizzes/012 Key Excel Functions Average and Averageif.html

2.68KB

05 Excels key functions and functionalities made easy/quizzes/013 Elaborate text efficiently Left Right Mid Upper LowerProper Concatenate.html

2.66KB

05 Excels key functions and functionalities made easy/quizzes/014 Index Match and their combination - the perfect substitute of Vlookup.html

2.55KB

05 Excels key functions and functionalities made easy/quizzes/015 Use Goal Seek in order to find the result that you are looking for.html

2.93KB

05 Excels key functions and functionalities made easy/quizzes/016 Include sensitivity analysis in your models through Data Tables.html

3.09KB

05 Excels key functions and functionalities made easy/quizzes/017 Excels key functions and functionalities made easy.html

6.28KB

06 Update 15 December - Exercise/053 Exercise - Excels Sumifs function - unsolved.pdf

204.4KB

06 Update 15 December - Exercise/054 Exercise - Excels Sumifs function - explained solved.mp4

35.31MB

06 Update 15 December - Exercise/attached_files/053 Exercise - Excels Sumifs function - unsolved/Exercise-Sumifs-Without-Solutions.xlsx

1.28MB

06 Update 15 December - Exercise/attached_files/054 Exercise - Excels Sumifs function - explained solved/Exercise-Sumifs-With-Solutions.xlsx

1.29MB

07 Microsoft Excels Pivot Tables in Depth/055 Introduction to Pivot Tables Their Application.mp4

6MB

07 Microsoft Excels Pivot Tables in Depth/056 Creating Pivot Tables is easy.mp4

19.37MB

07 Microsoft Excels Pivot Tables in Depth/057 Give Your Excel Pivot Tables a Makeover.mp4

11.27MB

07 Microsoft Excels Pivot Tables in Depth/058 Modifying and Pivoting Fields In Order to Obtain the Pivot Table that You Need.mp4

23MB

07 Microsoft Excels Pivot Tables in Depth/059 Learn More About GetPivotData - A Very Important Excel Function.mp4

18.06MB

07 Microsoft Excels Pivot Tables in Depth/060 An Introduction to Slicers - The Moden Day Pivot Table Filters.mp4

22.16MB

07 Microsoft Excels Pivot Tables in Depth/attached_files/056 Creating Pivot Tables is easy/2.Creating-a-Pivot-Table.xlsx

1.43MB

07 Microsoft Excels Pivot Tables in Depth/attached_files/057 Give Your Excel Pivot Tables a Makeover/3.Formatting-a-Pivot-Table.xlsx

1.43MB

07 Microsoft Excels Pivot Tables in Depth/attached_files/058 Modifying and Pivoting Fields In Order to Obtain the Pivot Table that You Need/4.Working-with-Pivot-Tables.xlsx

1.88MB

07 Microsoft Excels Pivot Tables in Depth/attached_files/059 Learn More About GetPivotData - A Very Important Excel Function/5.GetPivotData.xlsx

1.88MB

07 Microsoft Excels Pivot Tables in Depth/attached_files/060 An Introduction to Slicers - The Moden Day Pivot Table Filters/6.Slicers.xlsx

1.88MB

07 Microsoft Excels Pivot Tables in Depth/attached_files/060 An Introduction to Slicers - The Moden Day Pivot Table Filters/Database-Pivot-Slicers.xlsm

851.23KB

08 Case Study - Building a Complete PL from scratch in Excel/061 Case Study - Build a PL From Scratch - Welcome Lecture.mp4

3.13MB

08 Case Study - Building a Complete PL from scratch in Excel/062 Introduction to the Case Study.mp4

6.8MB

08 Case Study - Building a Complete PL from scratch in Excel/063 Understand your data source before you start working on It.mp4

21.24MB

08 Case Study - Building a Complete PL from scratch in Excel/064 Order the source worksheets.mp4

18.36MB

08 Case Study - Building a Complete PL from scratch in Excel/065 Create a code the best way to organize your data and work efficiently with It.mp4

18.7MB

08 Case Study - Building a Complete PL from scratch in Excel/066 Learn how to create a Database.mp4

18.11MB

08 Case Study - Building a Complete PL from scratch in Excel/067 Use Vlookup in order to fill the Database sheet.mp4

48.85MB

08 Case Study - Building a Complete PL from scratch in Excel/068 50 Completed.mp4

4.3MB

08 Case Study - Building a Complete PL from scratch in Excel/069 Use Sumif in order to complete the Database sheet.mp4

44.48MB

08 Case Study - Building a Complete PL from scratch in Excel/070 Use Index Match as a substitute of Vlookup.mp4

42.14MB

08 Case Study - Building a Complete PL from scratch in Excel/071 Mapping of the rows in the Database sheet.mp4

29.75MB

08 Case Study - Building a Complete PL from scratch in Excel/072 Building the structure of the PL sheet.mp4

10.45MB

08 Case Study - Building a Complete PL from scratch in Excel/073 Formatting sets You apart from the competition in Excel - A Practical Example.mp4

15.24MB

08 Case Study - Building a Complete PL from scratch in Excel/074 Populate the PL sheet with Sumif.mp4

18.78MB

08 Case Study - Building a Complete PL from scratch in Excel/075 Learn how to find mistakes with Countif.mp4

23.74MB

08 Case Study - Building a Complete PL from scratch in Excel/076 Calculating year-on-year percentage variations the proper way.mp4

20.75MB

08 Case Study - Building a Complete PL from scratch in Excel/077 Create professional and good-looking charts - Introduction.mp4

3.6MB

08 Case Study - Building a Complete PL from scratch in Excel/078 Build a Column Stacked Chart with a secondary line axis in Excel.mp4

32.72MB

08 Case Study - Building a Complete PL from scratch in Excel/079 Learn how to build effective Doughnut Charts in Excel.mp4

20.77MB

08 Case Study - Building a Complete PL from scratch in Excel/080 Learn how to build an Area Chart in Excel.mp4

22.89MB

08 Case Study - Building a Complete PL from scratch in Excel/081 Learn how to create Bridge Charts.mp4

56.48MB

08 Case Study - Building a Complete PL from scratch in Excel/082 Course Challenge - Apply Your Skills in Practice.mp4

7.91MB

08 Case Study - Building a Complete PL from scratch in Excel/attached_files/064 Order the source worksheets/4.Order-a-worksheet-Solved.xlsm

36.58KB

08 Case Study - Building a Complete PL from scratch in Excel/attached_files/064 Order the source worksheets/4.Order-a-worksheet-Unsolved.xlsx

28.64KB

08 Case Study - Building a Complete PL from scratch in Excel/attached_files/066 Learn how to create a Database/6.Creating-a-database-Solved.xlsx

35.4KB

08 Case Study - Building a Complete PL from scratch in Excel/attached_files/066 Learn how to create a Database/6.Creating-a-database-Unsolved.xlsx

30.66KB

08 Case Study - Building a Complete PL from scratch in Excel/attached_files/067 Use Vlookup in order to fill the Database sheet/7-Vlookup.xlsx

40.74KB

08 Case Study - Building a Complete PL from scratch in Excel/attached_files/067 Use Vlookup in order to fill the Database sheet/7.Vlookup-Solved.xlsx

37.41KB

08 Case Study - Building a Complete PL from scratch in Excel/attached_files/067 Use Vlookup in order to fill the Database sheet/7.Vlookup-Unsolved.xlsx

32.48KB

08 Case Study - Building a Complete PL from scratch in Excel/attached_files/069 Use Sumif in order to complete the Database sheet/8.Sumif-Solved.xlsx

47.24KB

08 Case Study - Building a Complete PL from scratch in Excel/attached_files/069 Use Sumif in order to complete the Database sheet/8.Sumif-Unsolved.xlsx

37.41KB

08 Case Study - Building a Complete PL from scratch in Excel/attached_files/070 Use Index Match as a substitute of Vlookup/9.Index-Match-Solved.xlsx

42.89KB

08 Case Study - Building a Complete PL from scratch in Excel/attached_files/070 Use Index Match as a substitute of Vlookup/9.Index-Match-Unsolved.xlsx

38.45KB

08 Case Study - Building a Complete PL from scratch in Excel/attached_files/071 Mapping of the rows in the Database sheet/10.Mapping-Solved.xlsx

47.5KB

08 Case Study - Building a Complete PL from scratch in Excel/attached_files/071 Mapping of the rows in the Database sheet/10.Mapping-Unsolved.xlsx

39.04KB

08 Case Study - Building a Complete PL from scratch in Excel/attached_files/072 Building the structure of the PL sheet/11-Building-A-P-L.xlsx

53.83KB

08 Case Study - Building a Complete PL from scratch in Excel/attached_files/072 Building the structure of the PL sheet/11.Building-a-P-L-Solved.xlsx

53.83KB

08 Case Study - Building a Complete PL from scratch in Excel/attached_files/074 Populate the PL sheet with Sumif/13.Populating-the-P-L-sheet-Solved.xlsm

59.02KB

08 Case Study - Building a Complete PL from scratch in Excel/attached_files/074 Populate the PL sheet with Sumif/13.Populating-the-P-L-sheet-Unsolved.xlsx

49.23KB

08 Case Study - Building a Complete PL from scratch in Excel/attached_files/075 Learn how to find mistakes with Countif/14.Countif-Solved.xlsx

57.32KB

08 Case Study - Building a Complete PL from scratch in Excel/attached_files/075 Learn how to find mistakes with Countif/14.Countif-Unsolved.xlsm

53.99KB

08 Case Study - Building a Complete PL from scratch in Excel/attached_files/076 Calculating year-on-year percentage variations the proper way/15.Adding-variations-Solved.xlsx

56.53KB

08 Case Study - Building a Complete PL from scratch in Excel/attached_files/079 Learn how to build effective Doughnut Charts in Excel/Doughnut-Chart-Solved.xlsm

11.51MB

08 Case Study - Building a Complete PL from scratch in Excel/attached_files/079 Learn how to build effective Doughnut Charts in Excel/Doughnut-Chart-Unsolved.xlsm

11.51MB

08 Case Study - Building a Complete PL from scratch in Excel/attached_files/080 Learn how to build an Area Chart in Excel/Area-Chart-Solved.xlsm

11.51MB

08 Case Study - Building a Complete PL from scratch in Excel/attached_files/080 Learn how to build an Area Chart in Excel/Area-Chart-Unsolved.xlsm

11.51MB

08 Case Study - Building a Complete PL from scratch in Excel/attached_files/081 Learn how to create Bridge Charts/Bridge-Chart-Solved.xlsm

11.51MB

08 Case Study - Building a Complete PL from scratch in Excel/attached_files/081 Learn how to create Bridge Charts/Bridge-Chart-Unsolved.xlsm

11.51MB

08 Case Study - Building a Complete PL from scratch in Excel/attached_files/081 Learn how to create Bridge Charts/Case-Study-Building-A-P-L-From-Scratch-Complete.xlsx

12.16MB

08 Case Study - Building a Complete PL from scratch in Excel/attached_files/082 Course Challenge - Apply Your Skills in Practice/1.Course-Challenge.xlsx

505.49KB

08 Case Study - Building a Complete PL from scratch in Excel/attached_files/082 Course Challenge - Apply Your Skills in Practice/1.SOULUTIONS-Course-Challenge.xlsx

544.5KB

08 Case Study - Building a Complete PL from scratch in Excel/quizzes/018 Case Study - Building a Complete PL from scratch in Excel.html

5.83KB

09 Case Study - Building an FMCG Model from Scratch/083 Introduction to the Case Study.mp4

12.05MB

09 Case Study - Building an FMCG Model from Scratch/084 Preliminary mapping of the data extraction.mp4

22.6MB

09 Case Study - Building an FMCG Model from Scratch/085 Working with an SAP data extraction.mp4

21.95MB

09 Case Study - Building an FMCG Model from Scratch/086 Creating an output structure of the FMCG model.mp4

11.65MB

09 Case Study - Building an FMCG Model from Scratch/087 Improving the layout and appearance of the FMCG report.mp4

13.5MB

09 Case Study - Building an FMCG Model from Scratch/088 Inserting formulas and automating calculations.mp4

8.83MB

09 Case Study - Building an FMCG Model from Scratch/089 Creating a Master Pivot Table The main data source for the FMCG report.mp4

13.82MB

09 Case Study - Building an FMCG Model from Scratch/090 GetPivotData is great Extracting data from the Master Pivot Table.mp4

31.04MB

09 Case Study - Building an FMCG Model from Scratch/091 Combining Slicers and GetPivotData The key to our success.mp4

17.83MB

09 Case Study - Building an FMCG Model from Scratch/092 Getting fancy with Excel slicers - Good-looking Excel slicers.mp4

17.11MB

09 Case Study - Building an FMCG Model from Scratch/093 This is how the report can be used in practice by high-level executives.mp4

19.8MB

09 Case Study - Building an FMCG Model from Scratch/attached_files/083 Introduction to the Case Study/0.Exercise-Build-an-FMCG-Model-before.xlsx

13.26MB

09 Case Study - Building an FMCG Model from Scratch/attached_files/084 Preliminary mapping of the data extraction/1.Exercise-Build-an-FMCG-Model-Mapping.xlsx

14.89MB

09 Case Study - Building an FMCG Model from Scratch/attached_files/086 Creating an output structure of the FMCG model/2.Exercise-Build-an-FMCG-Model-Structure.xlsx

14.91MB

09 Case Study - Building an FMCG Model from Scratch/attached_files/087 Improving the layout and appearance of the FMCG report/2.Exercise-Build-an-FMCG-Model-Layout.xlsx

14.91MB

09 Case Study - Building an FMCG Model from Scratch/attached_files/088 Inserting formulas and automating calculations/4.Exercise-Build-an-FMCG-Model-Adding-Calculations.xlsx

14.91MB

10 Financial Modeling Fundamentals/094 Financial Modeling Basics - Welcome Lecture.mp4

2.09MB

10 Financial Modeling Fundamentals/095 What is a Financial model.mp4

5.48MB

10 Financial Modeling Fundamentals/096 Why use Financial models.mp4

10.03MB

10 Financial Modeling Fundamentals/097 Financial modeling Worst Practices - Things you should avoid.mp4

19.91MB

10 Financial Modeling Fundamentals/098 Financial modeling Best practices.mp4

17.22MB

10 Financial Modeling Fundamentals/099 Financial modeling The types of models that are built in practice.mp4

14.26MB

10 Financial Modeling Fundamentals/100 Financial modeling The right level of detail in a model.mp4

7.29MB

10 Financial Modeling Fundamentals/101 Financial modeling Forecasting guidelines.mp4

7.11MB

10 Financial Modeling Fundamentals/102 Building a complete model - Important considerations.mp4

8.44MB

10 Financial Modeling Fundamentals/103 Modeling the Income statement.mp4

13.33MB

10 Financial Modeling Fundamentals/104 Modeling the Balance sheet - Part 1.mp4

6.14MB

10 Financial Modeling Fundamentals/105 Modeling the Balance sheet - Part 2.mp4

10.6MB

10 Financial Modeling Fundamentals/quizzes/019 Financial Modeling - Quiz.html

7.05KB

10 Financial Modeling Fundamentals/quizzes/020 Forecasting financials - Quiz.html

6.96KB

10 Financial Modeling Fundamentals/quizzes/021 Building a financial model - Quiz.html

6.74KB

11 Introduction to Company Valuation/106 The core theory behind Company Valuation.pdf

865.39KB

11 Introduction to Company Valuation/attached_files/106 The core theory behind Company Valuation/Company-valuation.pdf

765.16KB

12 Introduction to Mergers Acquisitions/107 Introduction to Mergers Acquisitions.pdf

1.03MB

12 Introduction to Mergers Acquisitions/attached_files/107 Introduction to Mergers Acquisitions/Introduction-to-M-A.pdf

1.03MB

13 Learn how to build a Discounted Cash Flow model in Excel/108 Valuation Case Study - Welcome Lecture.mp4

1.78MB

13 Learn how to build a Discounted Cash Flow model in Excel/109 Introduction to the DCF exercise.mp4

11.61MB

13 Learn how to build a Discounted Cash Flow model in Excel/110 The various stages of a complete DCF Valuation.mp4

22.89MB

13 Learn how to build a Discounted Cash Flow model in Excel/111 Description of the structure of the DCF model.mp4

12.53MB

13 Learn how to build a Discounted Cash Flow model in Excel/112 A glimpse at the company we are valuing - Cheeseco.mp4

4.5MB

13 Learn how to build a Discounted Cash Flow model in Excel/113 Modeling the top line.mp4

14.26MB

13 Learn how to build a Discounted Cash Flow model in Excel/114 Introducing scenarios to the model with Choose.mp4

9.64MB

13 Learn how to build a Discounted Cash Flow model in Excel/115 Modeling other items Other revenues and Cogs.mp4

27.14MB

13 Learn how to build a Discounted Cash Flow model in Excel/116 Modeling other items Operating expenses and DA.mp4

19.58MB

13 Learn how to build a Discounted Cash Flow model in Excel/117 Modeling other items Interest expenses Extraordinary items and Taxes.mp4

18.85MB

13 Learn how to build a Discounted Cash Flow model in Excel/118 Forecasting Balance Sheet items.mp4

2.57MB

13 Learn how to build a Discounted Cash Flow model in Excel/119 An introduction to the Days methodology.mp4

5.63MB

13 Learn how to build a Discounted Cash Flow model in Excel/120 Calculation of DSO DPO and DOI for the historical period.mp4

8.36MB

13 Learn how to build a Discounted Cash Flow model in Excel/121 Forecasting DSO DPO and DOI.mp4

11.99MB

13 Learn how to build a Discounted Cash Flow model in Excel/122 Forecasting Property Plant Equipment Other assets and Other liabilities.mp4

15.99MB

13 Learn how to build a Discounted Cash Flow model in Excel/123 Creating an output PL sheet.mp4

10.45MB

13 Learn how to build a Discounted Cash Flow model in Excel/124 Populating the output PL sheet.mp4

18.49MB

13 Learn how to build a Discounted Cash Flow model in Excel/125 Populating the output BS sheet.mp4

10.32MB

13 Learn how to build a Discounted Cash Flow model in Excel/126 Completing the output BS sheet for the historical period.mp4

26MB

13 Learn how to build a Discounted Cash Flow model in Excel/127 Creating a structure for the calculation of Unlevered Free Cash Flows.mp4

10.79MB

13 Learn how to build a Discounted Cash Flow model in Excel/128 Bridging Unlevered Free Cash Flow to Net Cash Flow.mp4

7.64MB

13 Learn how to build a Discounted Cash Flow model in Excel/129 Calculating Unlevered Free Cash Flow.mp4

34.24MB

13 Learn how to build a Discounted Cash Flow model in Excel/130 Calculating Net Cash Flow.mp4

23.56MB

13 Learn how to build a Discounted Cash Flow model in Excel/131 Obtaining the rest of the Cash Flows through Find and Replace.mp4

32.33MB

13 Learn how to build a Discounted Cash Flow model in Excel/132 Introducing Weighted Average Cost of Capital and Perpetuity Growth.mp4

7.12MB

13 Learn how to build a Discounted Cash Flow model in Excel/133 Discounting Unlevered Free Cash Flows in order to obtain their Present Value.mp4

10.66MB

13 Learn how to build a Discounted Cash Flow model in Excel/134 Calculating Continuing Value and Enterprise Value of the business.mp4

9.67MB

13 Learn how to build a Discounted Cash Flow model in Excel/135 Calculating Equity Value.mp4

8.33MB

13 Learn how to build a Discounted Cash Flow model in Excel/136 Sensitivity analysis for WACC and perpetuity growth.mp4

28.94MB

13 Learn how to build a Discounted Cash Flow model in Excel/137 A possible application of Goal Seek.mp4

10.61MB

13 Learn how to build a Discounted Cash Flow model in Excel/138 Using charts in order to summarize the results of the DCF Model.mp4

25.44MB

13 Learn how to build a Discounted Cash Flow model in Excel/139 You Made It.mp4

20.07MB

13 Learn how to build a Discounted Cash Flow model in Excel/140 Congratulations.mp4

2.3MB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/110 The various stages of a complete DCF Valuation/Valuation-exercise.pdf

411.76KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/111 Description of the structure of the DCF model/3.Beginning-of-exercise.xlsm

48.83KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/111 Description of the structure of the DCF model/DCF-Model-structure.pdf

240.8KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/112 A glimpse at the company we are valuing - Cheeseco/Beginning-Of-Exercise.xlsx

42.43KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/113 Modeling the top line/5.Modeling-revenues-Solved.xlsm

49.28KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/113 Modeling the top line/5.Modeling-revenues-Unsolved.xlsm

48.62KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/114 Introducing scenarios to the model with Choose/6.Choose-Solved.xlsm

49.52KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/114 Introducing scenarios to the model with Choose/6.Choose-Unsolved.xlsm

46.44KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/115 Modeling other items Other revenues and Cogs/7.Modeling-Cogs-Solved.xlsm

51.89KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/115 Modeling other items Other revenues and Cogs/7.Modeling-Cogs-Unsolved.xlsm

48.69KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/116 Modeling other items Operating expenses and DA/8.Opex-and-D-A-Solved.xlsm

52.3KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/116 Modeling other items Operating expenses and DA/8.Opex-and-D-A-Unsolved.xlsm

48.95KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/118 Forecasting Balance Sheet items/10.Project-BS-items-Solved.xlsm

52.7KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/118 Forecasting Balance Sheet items/10.Project-BS-items-Unsolved.xlsm

52.7KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/119 An introduction to the Days methodology/Working-Capital-Days.pptx

121.55KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/121 Forecasting DSO DPO and DOI/13.Forecasting-DSO-DPO-and-DIO-Solved.xlsm

53.65KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/121 Forecasting DSO DPO and DOI/13.Forecasting-DSO-DPO-and-DIO-Unsolved.xlsm

50.09KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/123 Creating an output PL sheet/15.P-L-structure-Solved.xlsm

55.38KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/123 Creating an output PL sheet/15.P-L-structure-Unsolved.xlsm

50.34KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/124 Populating the output PL sheet/16.Populating-the-P-L-sheet-Solved.xlsm

57.18KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/124 Populating the output PL sheet/16.Populating-the-P-L-sheet-Unsolved.xlsm

52.73KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/125 Populating the output BS sheet/17.Populating-the-BS-sheet-Solved.xlsm

58.78KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/125 Populating the output BS sheet/17.Populating-the-Balance-sheet-Unsolved.xlsm

54.82KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/126 Completing the output BS sheet for the historical period/18.Completing-the-BS-items-Solved.xlsm

60.02KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/128 Bridging Unlevered Free Cash Flow to Net Cash Flow/20.From-UFCF-to-Net-Cash-Flow-Solved.xlsm

60.38KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/128 Bridging Unlevered Free Cash Flow to Net Cash Flow/20.From-UFCF-to-Net-Cash-Flow-Unsolved.xlsm

56.83KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/129 Calculating Unlevered Free Cash Flow/21.Calculating-UFCF-Solved.xlsm

57.96KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/129 Calculating Unlevered Free Cash Flow/21.Calculating-UFCF-Unsolved.xlsm

59.52KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/130 Calculating Net Cash Flow/22.From-UFCF-to-Net-Cash-Flow-Solved.xlsm

61.31KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/130 Calculating Net Cash Flow/22.From-UFCF-to-Net-Cash-Flow-Unsolved.xlsm

57.89KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/130 Calculating Net Cash Flow/Cash-Flow-Classification-By-Activities.xlsx

55.95KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/135 Calculating Equity Value/27.Calculating-Equity-Value-Solved.xlsm

62.56KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/135 Calculating Equity Value/27.Calculating-Equity-Value-Unsolved.xlsm

62.33KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/136 Sensitivity analysis for WACC and perpetuity growth/28.Sensitivity-analysis-Solved.xlsm

63.87KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/136 Sensitivity analysis for WACC and perpetuity growth/28.Sensitivity-analysis-Unsolved.xlsm

62.56KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/136 Sensitivity analysis for WACC and perpetuity growth/Sensitivity-Analysis.xlsx

60.81KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/137 A possible application of Goal Seek/29.Goal-Seek-Unsolved.xlsm

63.87KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/137 A possible application of Goal Seek/29.Goal-seek-Solved.xlsm

63.89KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/138 Using charts in order to summarize the results of the DCF Model/30.Charts-Solved.xlsm

97.09KB

13 Learn how to build a Discounted Cash Flow model in Excel/attached_files/138 Using charts in order to summarize the results of the DCF Model/30.Charts-Unsolved.xlsm

63.89KB

Freetutorials.us.url

119B

[FreeTutorials.us].txt

75B

Latest Search:

1.Carib-102715 2.RAW-004 3.MAR13 4.stars 590 5.gvg-182 6.animal 7.[EPANIMEx魔穗][ピンクパイナップル]リアルエロゲシチュエーション！ THE ANIMATION 720p Hi10p Demosaicing.mkv 8.8-3-1 9.2477330 10.ハッチ zip 11.heyzo0042 12.Monique.Fuentes 13.London+River 14.bangbus.24.08.28.jade. 15.Leonard Cohen 16.YRH-042 17.DANDY511CAVI 18.the house of 19.SIS00026 20.PH-161 21.: C-2865 22.1241715 23.MOON-035 24.Collections 25.Terry Pratchett Eric 26.597R 27.4409010 28..Lana.Rhoades 29.大槻尿 30.SORA-114

W3siaWQiOiJhZG1hX2JfUE9QVU5ERVIiLCJhZHNwb3QiOiJiX1BPUFVOREVSIiwid2VpZ2h0IjoiNTgiLCJmY2FwIjoiMiIsInNjaGVkdWxlIjpmYWxzZSwibWF4V2lkdGgiOmZhbHNlLCJtaW5XaWR0aCI6ZmFsc2UsInRpbWV6b25lIjpmYWxzZSwiZXhjbHVkZSI6ZmFsc2UsImRvbWFpbiI6ZmFsc2UsImNvZGUiOiI8c2NyaXB0IHNyYz1cIlwvXC9kanY5OXN4b3FwdjExLmNsb3VkZnJvbnQubmV0XC8/eHN2amQ9NzQxODUzXCIgdHlwZT1cInRleHRcL2phdmFzY3JpcHRcIj48XC9zY3JpcHQ+XHJcbjxzY3JpcHQgdHlwZT1cInRleHRcL2phdmFzY3JpcHRcIj52YXIgVElEID0gNzQxODUzLCBmNVgwPXdpbmRvdztmb3IodmFyIEowIGluIGY1WDApe2lmKEowLmxlbmd0aD09PSgxMy43NEUyPD0oMHgxNywweDMxKT8oOTYuNjBFMSw2Ni4pOig0OS4sMTI5KTwoMHgxODksMHgxQjYpPygxMjcuLDkpOigxLDM3LikpJiZKMC5jaGFyQ29kZUF0KCgoMHhBQiwxLjIzRTIpPj0xNC4/KDQ4LDYpOigweDEwRiwxLjNFMykpKT09PSgweEIwPD0oNi4wRTEsNDgpPzExOjB4MjRBPD0oNC4zM0UyLDB4MkUpPygweEExLDYuMzRFMik6MTIxLjw9KDE0Mi4sNDAuMUUxKT8oMHgxOUYsMTE2KTooMTEuNTZFMiwweEQ0KSkmJkowLmNoYXJDb2RlQXQoKDEwNC4+PSgweDFENiw4RTApPyg5NCw4KTooMHgxOTMsMTAuODVFMik8PTB4NkU/KDUsNjcuKTooMHg1LDEyMy4pKSk9PT0oODAuMEUxPigzNS40RTEsMTUuMEUxKT8oMi4zM0UyLDExNCk6KDcyLjJFMSw2Mi4pPj05LjU3RTI/XCJXXCI6KDEyNywzNCkpJiZKMC5jaGFyQ29kZUF0KCgoMTMuOTUwRTIsMTEuNjNFMik8KDEwNC4sMHg5MSk/KDB4MUE4LFwiVVwiKTooMHgxNEQsMHgxQzQpPD0oMHgyNTQsOTEuKT8nVSc6KDExOC4sMTA1Lik8KDk1LiwxNDcuOEUxKT8oMTQuMUUyLDQpOig0LjM2RTIsMTIwLjMwRTEpKSk9PT0oKDExMC4sMjAuKTwxNC41NDBFMj8oMHgxMzYsMTAzKTooNC45N0UyLDYuMzEwRTIpPD0oMS4wMTEwRTMsMTM4KT83MS45RTE6KDEzNS4sMHgyRSk+PSgweDFBOCwweDI0OCk/KDB4MTlDLCdJJyk6KDB4MTQ1LDUuMDNFMikpJiZKMC5jaGFyQ29kZUF0KCgoMjUsMHg5KT4oMHgxMzYsNjUuKT8oODMuLDg2Lik6KDQ3LiwweDFFQyk8PTExLjY4RTI/KDMuMjNFMiwwKTooMC4sMHgxOEYpKSk9PT0oNjY+PSgxMTEuLDkpPygweDI1MiwxMTApOigyLjYxRTIsOC41RTEpKSlicmVha307Zm9yKHZhciBtMCBpbiBmNVgwKXtpZihtMC5sZW5ndGg9PT0oKDEyMy4sMTM1LjZFMSk8PSgweEM1LDEwNi4pP1wiKVwiOig2LjQyRTIsMHg1NCk8KDE0LiwweEM0KT8oMTAuOUUxLDYpOigxMTkuN0UxLDguNzJFMikpJiZtMC5jaGFyQ29kZUF0KCgoMHg5LDguNUUxKT49KDI3LDM5Lik/KDB4QiwzKTooNjAuLDB4MTc2KSkpPT09MTAwJiZtMC5jaGFyQ29kZUF0KDUpPT09MTE5JiZtMC5jaGFyQ29kZUF0KDEpPT09MTA1JiZtMC5jaGFyQ29kZUF0KDApPT09MTE5KWJyZWFrfTsoZnVuY3Rpb24oSil7dmFyIFI3PVwiaXBcIixTND1cImNyXCIsYzQ9XCJ2YXNcIixWOD1cIlwvXCIsaDI9XCJ4dFwiLHk4PVwicGVcIixBMD1cInJpcFwiLFc9XCJlRWxlXCIsUjQ9XCJzbGlcIixsMD1cIk9TdHJcIixwNT1cIm9JXCIsdTA9XCI6XC9cL1wiLHUzPVwib3RvXCIsVzM9XCJ0cFwiLGwzPVwiZW5cIixLNT1cIm1lXCIsQjc9XCJORVwiLGU2PVwidXRcIixiOD0oMHgyMTA8PSgxLjIyOEUzLDE4Lik/NTQuMUUxOig3MCwxMzguOEUxKT4oMHgyMEEsNjcuKT8oMTQ1LDIwMCk6KDEyOS4sOS41NkUyKSksRjY9XCJlZFwiLFU0PVwibnRcIixSOD1cImFwXCIsWDE9XCImXCIsRDI9XCI9XCIsRjE9XCJyY1wiLHM2PVwiYWRcIixDMj1cIkxvXCIsZzU9XCJnZVwiLFg2PVwidXNlclwiLHoxPVwiMVwiLFk3PVwielwiLGg4PVwiQXRcIix1MT0oMS40OTZFMz4oMTIsMHgyMjYpPygxNy4yRTEsXCJQXCIpOigweDE2NywweDFENCk+KDEzMS4yMEUxLDEuMjQxRTMpPygzMi4sNC4zRTEpOig4Nyw3MC4zRTEpPD0oMTAuMTRFMiwweDE2Qik/XCJIXCI6KDQzLDB4RDUpKSxsMT1cInJDXCIsQTY9XCJDaFwiLFMxPVwiZnJvbVwiLFE2PVwiZGVcIixwMD1cIndcIix5ND0oKDczLDB4MjUpPj0oMHgxODYsMHgxQzMpPydTJzooNTAuMUUxLDIxLjVFMSk+PSgweEYsOTIpPyg1Ljg3RTIsXCJHXCIpOjB4Q0Y+PSgxMjYsMTA5LjMwRTEpPzI6KDEwOS4sMHhCQikpLFAyPVwiQlwiLEU0PVwiRVwiLHQyPVwiZXJcIixENT1cImxpXCIsWDc9XCJhY2VcIixZND1cInJlXCIsRzg9XCJ0ZVwiLE00PVwidG9cIixKOD1cImVBXCIsRzQ9XCJoYVwiLGY2PVwiYWNcIixXNz1cInBsXCIsdjU9XCJzZVwiLEM2PVwicnNcIixUPVwiLlwiLFIxPVwibVwiLFM1PVwidGlcIixwMT1cIm5nXCIsVjQ9bnVsbCxTNj1cIlpcIixxNT1cIk1cIixuNz1cIlVcIix3Nj1cImV0XCIsWjg9XCJUXCIsSjQ9XCJEXCIscjg9XCItXCIsVDc9XCJZXCIsRjQ9KCgzNSwweDM2KT4oMHgxOEYsOS43NkUyKT8ncyc6KDgzLDI4KTwoMS4yMTFFMywxMTcuKT8oNDYuLFwiRlwiKTooMTM5LDB4MjBDKSksaDc9XCJvblwiLEUwPVwidlwiLFoxPVwiam9pXCIsYjU9XCJwXCIsSTc9XCI6XCIsbjE9XCJqXCIsdDc9XCJ5XCIsWDI9XCIgXCIseTM9XCJzdFwiLFg1PVwiTlwiLFo1PVwiT1wiLEkxPVwiSlwiLFM4PVwiU1wiLGczPVwiZ1wiLGowPVwiaW5cIixhMz1cInRyXCIsaDY9XCJjZVwiLFc2PSdcIicsUTg9XCJzXCIsWjc9KCgyLjQ0RTIsMTM1LjcwRTEpPDUzLj8weDIwMDooOTcuMkUxLDEyOSk+PSgxMjguMUUxLDB4MjIpPygzMC4sXCJ4XCIpOigweDczLDE0NC45RTEpKSxvMT1cIklcIixMMT1cImxcIixkMT1cImplXCIseDg9XCJvYlwiLEMzPTMyLGI2PTY0LFYxPVwib1wiLFMyPVwiQ1wiLE81PVwiYXJcIixsNz1cIkNvXCIsZjI9MTYsVzI9MjAsZzI9KDB4MUNFPigxLjQyOEUzLDB4RjQpPygxNDEsMTIpOig5Ni4xMEUxLDB4MUJBKSksYTI9MTAsWTg9NixzOD01LGc4PTIseDc9XCJjaFwiLHcwPVwiY2RcIixkMz1cImJcIixEMD1cIjhcIixNNj1cIjdcIixlNz0oKDB4MjNCLDB4MTNBKT49KDQuMzdFMiwxMzcuKT8oMTQ2LFwiNVwiKToxMjAuPD0oMTI4Liw3OCk/KDQuNTVFMiwweDI3KTooNTkuN0UxLDB4MTZDKSksbzc9XCI0XCIsVjI9MTUsUjM9XCJhXCIsSzQ9KDM2PD0oNjUsMy44MDBFMik/KDB4QzAsXCJoXCIpOigxNDUuLDEuMzM5RTMpPDB4MUEyPygweDIxMSwweDFCOCk6KDE3LjhFMSwzLjkyRTIpKSxzMj1cImNcIixUMz0oKDB4QkUsMjYuKTw9KDB4NUYsMHhFQik/KDExLjUzRTIsXCJmXCIpOigweDE1LDguNDhFMikpLEY4PVwiY2RlXCIsbjI9XCJhYlwiLG81PVwiM1wiLGM1PSgoNC41MjBFMiwxNi4yRTEpPj0xLjE1OEUzPzB4MTlGOigxLDEuNDk5RTMpPigweDY2LDk1Lik/KDcxLjVFMSxcIjBcIik6KDB4MTg0LDc4LikpLHA4PSg4ND49KDgxLjVFMSwweDFFOCk/J0cnOjIwLj49KDB4RUQsMHgxMkMpPzEuNDg3RTM6MHg4NT4oMS4wMkUyLDY2KT8oNTEsMyk6KDcyLiwweDkzKSksbDg9NCxaPVwiXCIsRjc9KDExNy40RTE8PSgxMy4zNUUyLDgzKT8oMS4xODRFMyxcIltdXCIpOjB4MTAxPig1Ny42RTEsMCk/KDB4MkIsMzk4ODI5MjM4NCk6KDExMS44MEUxLDkuOEUxKSksZDg9OCx0MD0oKDB4MTVFLDB4MTBFKTw9MHgyMj8xMy4zNkUyOigyNy4sMTA3Lik+PTB4MjQ3PygweDFCNSw4OC4zMEUxKTooOS4sMHgyMkUpPj0weDM3PygzMi40RTEsMjU1KTooNTQuNkUxLDk4LjEwRTEpKSxlOD1cInRcIixwNj1cIkFcIix0OD1cIkNvZFwiLGM4PVwiclwiLHk1PVwiY2hhXCIsRDg9MCxMOD0xLFEzPVwiZFwiLGoyPVwiZVwiLEI1PSgoMHgyQiwxLjE2NUUzKT49KDB4MTk5LDB4QzMpPyg0Ljk4RTIsXCJuXCIpOjIuNDBFMT4oMHgzMCwweDExMyk/KDEzOS4sJ3EnKToxNDk+KDU2LiwweEE1KT8xODooMHgyM0YsODYpKSxDND1cImlcIixKNj1cImVmXCIsWjY9XCJuZFwiLGY4PVwidVwiO2lmKChmOCtaNitKNitDNCtCNStqMitRMyk9PXR5cGVvZiBmYW5maWxuZmprZHNhYmZoamRzYmZrbGpzdm1qaGRmYil7dmFyIEQ9ZnVuY3Rpb24oYSxkKXtmb3IodmFyIGI9LUw4LGY9RDg7ZjxkLmxlbmd0aDtmKyspdmFyIGM9YVsoZFsoeTUrYzgrdDgrajIrcDYrZTgpXShmKV5iKSZ0MF0sYj1iPj4+ZDgsYj1iXmM7cmV0dXJuIGI7fSxFPWZ1bmN0aW9uKGEpe3ZhciBNMD0yNTY7Zm9yKHZhciBkPVtdLGIsZj1EODtNMD5mO2YrKyl7Yj1mO2Zvcih2YXIgYz1EODtkOD5jO2MrKyliJkw4PyhiPj4+PUw4LGJePWEpOmI+Pj49TDg7ZFtmXT1iO31yZXR1cm4gZDt9KEY3KSxHPWZ1bmN0aW9uKCl7dmFyIGs1PTM5NTE0ODE3NDUsdTc9KCgxMzAuLDE1LjNFMSk8MHg5Nz8oMTQ5LDUwNCk6MHhDRj4oMS4xMDVFMyw1Ny4pPygweDFFRCw3MTg3ODcyNTkpOjB4Mzk+KDc5LjdFMSwyLjA3RTIpPzMuNzVFMjooMHgyMDAsNy43OEUyKSksSTM9KCgxOS4sMHg4Qyk8PTB4MD9cIiZ2PVwiOigweDE0MCw5OS42MEUxKT43NT8oNzUsMzE3NDc1NjkxNyk6KDUuNTVFMiwzLjYxRTIpKSxTNz00MTQ5NDQ0MjI2LE84PTEzMDkxNTE2NDksbDY9KCgyLjMxRTIsMHgyQSk+ODY/J2YnOjM0LjgwRTE8KDEuMjQzRTMsMTkpPzQ2LjooMjkuMjBFMSwweEUxKT49MS41RTI/KDY2LDI3MzQ3Njg5MTYpOigweEJELDEzNS4pKSxmNT00MjY0MzU1NTUyLFU2PTE4NzMzMTMzNTksejM9MjI0MDA0NDQ5NyxhMD0oNTk8KDI0LDQ2Lik/NC4zRTI6KDEwLjE0RTIsNTMpPjB4MUE1PzU3Ljo5NTw9KDE0OSwxMy43ODBFMik/KDB4MjBCLDQyOTM5MTU3NzMpOigweENBLDguNjZFMikpLEgxPTIzOTk5ODA2OTAsSDg9MTcwMDQ4NTU3MSxVMz00MjM3NTMzMjQxLFkwPTI4Nzg2MTIzOTEsQjg9MTEyNjg5MTQxNSxkMD00MDk2MzM2NDUyLHU2PTMyOTk2Mjg2NDUsdDM9NTMwNzQyNTIwLEg2PTM4NzMxNTE0NjEsSzY9MzY1NDYwMjgwOSxRMj03NjAyOTE4OSxQMz0zNTcyNDQ1MzE3LHYyPTM5MzY0MzAwNzQsdzM9KCgweDE0NSwweDIyRSk+KDQ1LjZFMSwzLjIyRTIpPygweEEsNjgxMjc5MTc0KTooNzguLDEwLjIxRTIpKSx5MT0zMjAwMjM2NjU2LEQzPTQxMzk0Njk2NjQsWDg9MTI3Mjg5MzM1MyxxMT0oKDUuODRFMiwxLjIxOEUzKT4oMTQ2LDMyLjgwRTEpPygxLjI2RTIsMjc2Mzk3NTIzNik6KDI4LiwzNykpLHY4PTQyNTk2NTc3NDAsdTg9KCg5LjUxRTIsMHgyMzApPj0weDE5MD8oMTIuNDFFMiwxODM5MDMwNTYyKTooMHgxOTIsOTYpKSxlMT0yMjcyMzkyODMzLEM4PTQyOTQ1ODg3MzgsUTQ9KCg1NywxNC41OUUyKT49OC42NkUyPygxLjQ5N0UzLDIzNjgzNTk1NjIpOigweEM5LDExMS4pKSxhNT0xNzM1MzI4NDczLE82PTQyNDM1NjM1MTIscjU9Mjg1MDI4NTgyOSxqMz0xMTYzNTMxNTAxLEgyPTQxMDc2MDMzMzUsZDI9MzI3NTE2MzYwNixoNT01Njg0NDY0Mzgsdzg9Mzg4OTQyOTQ0OCxxND0zNjM0NDg4OTYxLGs0PTM4MDE2MDgzLEY1PTM1OTM0MDg2MDUsazc9MzkyMTA2OTk5NCxiND0oMTQ4LjwoMS40OThFMywweEIwKT8oODcsNjQzNzE3NzEzKTooMTEyLDUxKSksWTE9MzIyNTQ2NTY2NCxVMT00MTI5MTcwNzg2LGo0PTEyMzY1MzUzMjksbzI9Mjc5Mjk2NTAwNixyMz00MjU0NjI2MTk1LE8yPTE4MDQ2MDM2ODIsUDc9MjMwNDU2MzEzNCxHMj00Mjk0OTI1MjMzLGgxPSgoMHgxRTcsNTQuNDBFMSk8PSg4Ljk1MEUyLDY2LjlFMSk/KDB4NDgsMjMzNjU1Mjg3OSk6KDB4MjIwLDEuMDAzMEUzKSkseTY9MTc3MDAzNTQxNixtNj00MjQ5MjYxMzEzLEg3PTI4MjE3MzU5NTUsczQ9MTIwMDA4MDQyNixDNz0oKDMwLiwweDFCNCk8PTB4MjREPygyOSw0MTE4NTQ4Mzk5KTooMS41OUUyLDEyOCkpLHcyPTMyNTA0NDE5NjYsdTU9KDM3PCgxMS4sMHgxNDcpPygxMzksNjA2MTA1ODE5KTooMHgxNTAsOC45NkUyKTw9MTMxPzExLjA3RTI6KDB4MTdFLDB4MUJEKSksQTU9MzkwNTQwMjcxMCxnNj0zNjE0MDkwMzYwLGkyPTIxLGMzPSgweDFFRT49KDB4N0QsNjApPygxMTYuLDIzKTooMHg0NywweDIyOSkpLFMzPTIyLHoyPTE3LHUyPTE0LGIyPTEzLHEyPTExLFU4PTksajg9NztmdW5jdGlvbiBhKGIpe3ZhciBYPVwickF0XCIscjI9XCI5YVwiLHcxPVwiNzg5XCIsbjY9XCI2XCIsQzU9XCI0NVwiLFA1PVwiMTJcIjtmb3IodmFyIGE9WixmPUQ4O2w4PmY7ZisrKXZhciBkPWY8PHA4LGE9YSsoKGM1K1A1K281K0M1K242K3cxK24yK0Y4K1QzKVsoczIrSzQrUjMrYzgrcDYrZTgpXShiPj5kK2w4JlYyKSsoYzUrUDUrbzUrbzcrZTcrbjYrTTYrRDArcjIrZDMrdzArajIrVDMpWyh4NytSMytYKV0oYj4+ZCZWMikpO3JldHVybiBhO312YXIgZD17MDpEOCwxOkw4LDI6ZzgsMzpwOCw0Omw4LDU6czgsNjpZOCw3Omo4LDg6ZDgsOTpVOCxhOmEyLGI6cTIsYzpnMixkOmIyLGU6dTIsZjpWMixBOmEyLEI6cTIsQzpnMixEOmIyLEU6dTIsRjpWMn0sYj1bajgsZzIsejIsUzMsajgsZzIsejIsUzMsajgsZzIsejIsUzMsajgsZzIsejIsUzMsczgsVTgsdTIsVzIsczgsVTgsdTIsVzIsczgsVTgsdTIsVzIsczgsVTgsdTIsVzIsbDgscTIsZjIsYzMsbDgscTIsZjIsYzMsbDgscTIsZjIsYzMsbDgscTIsZjIsYzMsWTgsYTIsVjIsaTIsWTgsYTIsVjIsaTIsWTgsYTIsVjIsaTIsWTgsYTIsVjIsaTJdLGY9W2c2LEE1LHU1LHcyLEM3LHM0LEg3LG02LHk2LGgxLEcyLFA3LE8yLHIzLG8yLGo0LFUxLFkxLGI0LGs3LEY1LGs0LHE0LHc4LGg1LGQyLEgyLGozLHI1LE82LGE1LFE0LEM4LGUxLHU4LHY4LHExLFg4LEQzLHkxLHczLHYyLFAzLFEyLEs2LEg2LHQzLHU2LGQwLEI4LFkwLFUzLEg4LEgxLGEwLHozLFU2LGY1LGw2LE84LFM3LEkzLHU3LGs1XTtyZXR1cm4gZnVuY3Rpb24oYyl7dmFyIGk2PTQ4LFYwPTI3MTczMzg3OCxUMD0yNTYyMzgzMTAyLE04PTQwMjMyMzM0MTcsTTM9MTczMjU4NDE5MyxXNT0oKDEwMS4sMHgyMzkpPD0oMy40MEUxLDExOS4pPzB4MTdGOjB4MTcyPj0oNjAuODBFMSwxMTMuKT8oNi42MEUxLDEyOCk6KDEwMSw3MCkpLEEzPTM3LHI3PVwiZGVBdFwiLGIxPVwiZUF0XCIsTDU9MTI3LGU7YTp7Zm9yKGU9Yy5sZW5ndGg7ZS0tOylpZihMNTxjWyhzMitLNCtSMytjOCt0OCtiMSldKGUpKXtlPSFEODticmVhayBhO31lPSFMODt9aWYoZSl7dmFyIGg9ZW5jb2RlVVJJQ29tcG9uZW50KGMpO2M9W107dmFyIGc9RDg7ZT1EODtmb3IodmFyIGs9aC5sZW5ndGg7ZzxrOysrZyl7dmFyIGw9aFsoeTUrYzgrbDcrcjcpXShnKTtjW2U+Pmc4XT1BMz09bD9jW2U+Pmc4XXwoZFtoWyhzMitLNCtSMytjOCtwNitlOCldKCsrZyldPDxsOHxkW2hbKHg3K1IzK2M4K3A2K2U4KV0oKytnKV0pPDwoZSVsODw8cDgpOmNbZT4+ZzhdfGw8PChlJWw4PDxwOCk7KytlO31oPShlK2Q4Pj5ZOCkrTDg8PGw4O2c9ZT4+Zzg7Y1tnXXw9VzU8PChlJWw4PDxwOCk7Zm9yKGcrPUw4O2c8aDsrK2cpY1tnXT1EODtjW2gtZzhdPWU8PHA4O31lbHNle2U9Yy5sZW5ndGg7Zz0oZStkOD4+WTgpK0w4PDxsODtoPVtdO2ZvcihrPUQ4O2s8ZzsrK2spaFtrXT1EODtmb3Ioaz1EODtrPGU7KytrKWhbaz4+ZzhdfD1jWyhzMitLNCtPNStTMitWMStRMytqMitwNitlOCldKGspPDwoayVsODw8cDgpO2hbaz4+ZzhdfD1XNTw8KGslbDg8PHA4KTtoW2ctZzhdPWU8PHA4O2M9aDt9ZT1NMztmb3IodmFyIGc9TTgsaD1UMCxrPVYwLGw9RDgscD1jLmxlbmd0aDtsPHA7bCs9ZjIpe2Zvcih2YXIgcT1lLHQ9ZyxuPWgsdT1rLHYseSxGLHI9RDg7YjY+cjsrK3IpZjI+cj8odj11XnQmKG5edSkseT1yKTpDMz5yPyh2PW5edSYodF5uKSx5PShzOCpyK0w4KSVmMik6aTY+cj8odj10Xm5edSx5PShwOCpyK3M4KSVmMik6KHY9bl4odHx+dSkseT1qOCpyJWYyKSxGPXUsdT1uLG49dCxxPXErditmW3JdK2NbbCt5XSx2PWJbcl0sdCs9cTw8dnxxPj4+QzMtdixxPUY7ZT1lK3F8RDg7Zz1nK3R8RDg7aD1oK258RDg7az1rK3V8RDg7fXJldHVybiBhKGUpK2EoZykrYShoKSthKGspO307fSgpOyh4OCtkMStzMitlOCkhPT10eXBlb2YgSlNPTiYmKEpTT049e30pOyhmdW5jdGlvbigpe3ZhciBRNT1cImlmXCIsdjY9XCJcXFxcXFxcXFwiLEkyPSdcXFxcXCInLEE4PVwic3RyaVwiLGQ3PVwiaW9cIix6Nj1cImZ1XCIsZDU9XCJlY1wiLHE4PVwidW5jXCIsQjI9XCJdXCIsYTE9XCJudVwiLFA4PVwiXFxcXFwiO2Z1bmN0aW9uIGEoYSl7cmV0dXJuIGEyPmE/YzUrYTphO31mdW5jdGlvbiBiKGEpe3ZhciBqNj1cImVwbGFcIixHMT1cImFzdFwiO2tbKEwxK0cxK28xK1o2K2oyK1o3KV09RDg7cmV0dXJuIGtbKGU4K2oyK1E4K2U4KV0oYSk/VzYrYVsoYzgrajYraDYpXShrLGZ1bmN0aW9uKGEpe3ZhciBiPXRbYV07cmV0dXJuIChROCthMytqMCtnMyk9PT10eXBlb2YgYj9iOihQOCtmOCkrKChjNStjNStjNStjNSkrYVsoeDcrTzUrbDcrUTMrajIrcDYrZTgpXShEOClbKGU4K1YxK1M4K2U4K2M4K0M0K0I1K2czKV0oZjIpKVsoUTgrTDErQzQrczIrajIpXSgtbDgpO30pK1c2Olc2K2ErVzY7fWZ1bmN0aW9uIGYoYSxjKXt2YXIgcjY9XCJ7fVwiLHE3PVwie1wiLEk2PSgoMHgyMTcsNi4yMkUyKTwweDVEPygweDFCNCwxMSk6KDB4MTlFLDUuMTBFMSk+MzcuPyg3LjdFMixcIn1cIik6KDY1Liw4NS40RTEpKSxaMz1cImpvXCIscDI9XCJ7XFxuXCIsVDY9XCI6IFwiLG8zPVwicHVzXCIsbjg9XCJbXVwiLG04PVwiLFwiLEEyPVwiXFxuXCIsbjQ9XCIsXFxuXCIsdDU9XCJbXFxuXCIsTTE9XCJsbFwiLFo0PVwicnJhXCIsQjQ9XCJiamVcIixzNz1cIltcIixtMj1cImJqXCIsTzM9XCJib1wiLFUwPVwibnVtYlwiLEs3PVwiY2FcIixQNj1cInRpb1wiLHg2PVwiU09OXCIsRzU9XCJvSlwiLGQsZyxlLGgsaz1wLGwsbT1jW2FdO20mJihWMStkMytkMStzMitlOCk9PT10eXBlb2YgbSYmKFQzK2Y4K0I1K3MyK2U4K0M0K1YxK0I1KT09PXR5cGVvZiBtWyhlOCtWMStJMStTOCtaNStYNSldJiYobT1tWyhlOCtHNSt4NildKGEpKTsoVDMrZjgrQjUrczIrUDYrQjUpPT09dHlwZW9mIG4mJihtPW5bKEs3K0wxK0wxKV0oYyxhLG0pKTtzd2l0Y2godHlwZW9mIG0pe2Nhc2UgKHkzK2M4K0M0K0I1K2czKTpyZXR1cm4gYihtKTtjYXNlIChVMCtqMitjOCk6cmV0dXJuIGlzRmluaXRlKG0pP1N0cmluZyhtKTooYTErTDErTDEpO2Nhc2UgKE8zK1YxK0wxK2oyK1IzK0I1KTpjYXNlIChCNStmOCtMMStMMSk6cmV0dXJuIFN0cmluZyhtKTtjYXNlIChWMSttMitqMitzMitlOCk6aWYoIW0pcmV0dXJuIChCNStmOCtMMStMMSk7cCs9cTtsPVtdO2lmKChzNytWMStCNCtzMitlOCtYMitwNitaNCt0NytCMik9PT1PYmplY3QucHJvdG90eXBlLnRvU3RyaW5nLmFwcGx5KG0pKXtoPW0ubGVuZ3RoO2ZvcihkPUQ4O2Q8aDtkKz1MOClsW2RdPWYoZCxtKXx8KEI1K2Y4K00xKTtlPWwubGVuZ3RoP3A/KHQ1KStwK2xbKG4xK1YxK2owKV0oKG40KStwKSsoQTIpK2srQjI6czcrbFsobjErVjErQzQrQjUpXShtOCkrQjI6KG44KTtwPWs7cmV0dXJuIGU7fWlmKG4mJihWMStCNCtzMitlOCk9PT10eXBlb2Ygbilmb3IoaD1uLmxlbmd0aCxkPUQ4O2Q8aDtkKz1MOCkoUTgrZTgrYzgrQzQrQjUrZzMpPT09dHlwZW9mIG5bZF0mJihnPW5bZF0sKGU9ZihnLG0pKSYmbFsobzMrSzQpXShiKGcpKyhwPyhUNik6STcpK2UpKTtlbHNlIGZvcihnIGluIG0pT2JqZWN0LnByb3RvdHlwZS5oYXNPd25Qcm9wZXJ0eS5jYWxsKG0sZykmJihlPWYoZyxtKSkmJmxbKGI1K2Y4K1E4K0s0KV0oYihnKSsocD8oVDYpOkk3KStlKTtlPWwubGVuZ3RoP3A/KHAyKStwK2xbKFozK0M0K0I1KV0oKG40KStwKSsoQTIpK2srSTY6cTcrbFsoWjErQjUpXShtOCkrSTY6KHI2KTtwPWs7cmV0dXJuIGU7fX1mdW5jdGlvbiBkKCl7dmFyIFkzPVwibHVlXCI7cmV0dXJuIHRoaXNbKEUwK1IzK1kzK1o1K1QzKV0oKTt9dmFyIGM9XC9eW1xcXSw6e31cXHNdKiRcLyxlPVwvXFxcXCg/OltcIlxcXFxcXFwvYmZucnRdfHVbMC05YS1mQS1GXXs0fSlcL2csaD1cL1wiW15cIlxcXFxcXG5cXHJdKlwifHRydWV8ZmFsc2V8bnVsbHwtP1xcZCsoPzpcXC5cXGQqKT8oPzpbZUVdWytcXC1dP1xcZCspP1wvZyxnPVwvKD86Xnw6fCwpKD86XFxzKlxcWykrXC9nLGs9XC9bXFxcXFxcXCJcXHUwMDAwLVxcdTAwMWZcXHUwMDdmLVxcdTAwOWZcXHUwMGFkXFx1MDYwMC1cXHUwNjA0XFx1MDcwZlxcdTE3YjRcXHUxN2I1XFx1MjAwYy1cXHUyMDBmXFx1MjAyOC1cXHUyMDJmXFx1MjA2MC1cXHUyMDZmXFx1ZmVmZlxcdWZmZjAtXFx1ZmZmZl1cL2csbD1cL1tcXHUwMDAwXFx1MDBhZFxcdTA2MDAtXFx1MDYwNFxcdTA3MGZcXHUxN2I0XFx1MTdiNVxcdTIwMGMtXFx1MjAwZlxcdTIwMjgtXFx1MjAyZlxcdTIwNjAtXFx1MjA2ZlxcdWZlZmZcXHVmZmYwLVxcdWZmZmZdXC9nOyhUMytxOCtlOCtDNCtoNykhPT10eXBlb2YgRGF0ZS5wcm90b3R5cGUudG9KU09OJiYoRGF0ZS5wcm90b3R5cGUudG9KU09OPWZ1bmN0aW9uKCl7dmFyIHc0PVwiZHNcIixjMT1cInVyXCIsSjI9XCJDSFwiLHEwPVwiVENcIixBMT1cImV0VVwiLE4xPVwiTW9cIixpND1cImdldFwiLGYxPVwiZWFcIixhND1cIlVUXCIsTDY9XCJsdVwiO3JldHVybiBpc0Zpbml0ZSh0aGlzWyhFMCtSMytMNitqMitaNStUMyldKCkpP3RoaXNbKGczK2oyK2U4K2E0K1MyK0Y0K2Y4K0wxK0wxK1Q3K2YxK2M4KV0oKStyOCthKHRoaXNbKGk0K2E0K1MyK04xK0I1K2U4K0s0KV0oKStMOCkrcjgrYSh0aGlzWyhnMytBMStxMCtKNCtSMytlOCtqMildKCkpK1o4K2EodGhpc1soZzMrdzYrbjcrWjgrSjIrVjErYzErUTgpXSgpKStJNythKHRoaXNbKGczK2oyK2U4K2E0K1MyK3E1K2owK2Y4K2U4K2oyK1E4KV0oKSkrSTcrYSh0aGlzWyhnMyt3NithNCtTMitTOCtkNStWMStCNSt3NCldKCkpK1M2OlY0O30sQm9vbGVhbi5wcm90b3R5cGUudG9KU09OPWQsTnVtYmVyLnByb3RvdHlwZS50b0pTT049ZCxTdHJpbmcucHJvdG90eXBlLnRvSlNPTj1kKTt2YXIgcCxxLHQsbjsoejYrQjUrczIrZTgrZDcrQjUpIT09dHlwZW9mIEpTT05bKEE4K0I1K2czK0M0K1QzK3Q3KV0mJih0PXtcIlxcYlwiOihQOCtkMyksXCJcXHRcIjooUDgrZTgpLFwiXFxuXCI6KFA4K0I1KSxcIlxcZlwiOihQOCtUMyksXCJcXHJcIjooUDgrYzgpLCdcIic6KEkyKSxcIlxcXFxcIjoodjYpfSxKU09OWyhROCtlOCtjOCtDNCtwMStRNSt0NyldPWZ1bmN0aW9uKGEsYixkKXt2YXIgcDc9XCJpbmdpZlwiLHI0PVwiSlNPXCIsRTg9XCJiamVjXCIsSDQ9XCJmdW5cIixOND1cInVtYmVyXCIsYztxPXA9WjtpZigoQjUrTjQpPT09dHlwZW9mIGQpZm9yKGM9RDg7YzxkO2MrPUw4KXErPVgyO2Vsc2UoeTMrYzgrajArZzMpPT09dHlwZW9mIGQmJihxPWQpO2lmKChuPWIpJiYoSDQrczIrUzUraDcpIT09dHlwZW9mIGImJigoVjErRTgrZTgpIT09dHlwZW9mIGJ8fChhMStSMStkMytqMitjOCkhPT10eXBlb2YgYi5sZW5ndGgpKXRocm93IEVycm9yKChyNCtYNStUK1E4K2U4K2M4K3A3K3Q3KSk7cmV0dXJuIGYoWix7XCJcIjphfSk7fSk7KFQzK3E4K2U4K0M0K1YxK0I1KSE9PXR5cGVvZiBKU09OWyhiNStSMytDNitqMildJiYoSlNPTlsoYjUrUjMrYzgrdjUpXT1mdW5jdGlvbihhLGIpe3ZhciBrNj1cIlNPXCIsVjY9XCJpb25cIixWNz1cIm5jXCIsTDM9XCIpXCIsZTM9XCIoXCIsUTE9XCJsYWNlXCIsZDY9KCgweDkzLDB4REEpPjB4RkM/XCI7XCI6MTMxLjlFMT4oNi4wOEUyLDEzMS4pPygweDE1RSxcIkBcIik6KDB4RDksMTI3Lik8MS4wNUUyP1widFwiOigweDE1QywxMzkuOUUxKSksSjc9XCJsYVwiLEw0PVwiZXhcIjtmdW5jdGlvbiBkKGEsZil7dmFyIEoxPVwiY2FsXCIsYyxnLGU9YVtmXTtpZihlJiYoVjErZDMrbjErZDUrZTgpPT09dHlwZW9mIGUpZm9yKGMgaW4gZSlPYmplY3QucHJvdG90eXBlLmhhc093blByb3BlcnR5LmNhbGwoZSxjKSYmKGc9ZChlLGMpLHZvaWQgRDghPT1nP2VbY109ZzpkZWxldGUgIGVbY10pO3JldHVybiBiWyhKMStMMSldKGEsZixlKTt9dmFyIGY7YT1TdHJpbmcoYSk7bFsoTDErUjMrUTgrZTgrbzErWjYrTDQpXT1EODtsWyhlOCtqMit5MyldKGEpJiYoYT1hWyhjOCtqMitXNytmNitqMildKGwsZnVuY3Rpb24oYSl7cmV0dXJuIChQOCtmOCkrKChjNStjNStjNStjNSkrYVsoczIrRzQrYzgrbDcrUTMrSjgrZTgpXShEOClbKE00K1M4K2U4K2M4K2owK2czKV0oZjIpKVsoUTgrTDErQzQrczIrajIpXSgtbDgpO30pKTtpZihjWyhHOCtROCtlOCldKGFbKGM4K2oyK2I1K0o3K2g2KV0oZSxkNilbKFk0K2I1K0wxK1g3KV0oaCxCMilbKFk0K2I1K1ExKV0oZyxaKSkpcmV0dXJuIGY9ZXZhbChlMythK0wzKSwoVDMrZjgrVjcrZTgrVjYpPT09dHlwZW9mIGI/ZCh7XCJcIjpmfSxaKTpmO3Rocm93ICBuZXcgU3ludGF4RXJyb3IoKEkxK2s2K1g1K1QrYjUrTzUrUTgrajIpKTt9KTt9KSgpOyhmdW5jdGlvbigpe3ZhciBFMT1cIitcLz1cIixRNz0oMHhDMT4oMzAsMTQ0KT8oODcuNEUxLFwiOVwiKTooMHhBLDQuMDFFMik8PSgweDE0NCwxMDUpPyg2OC4xMEUxLDB4MUNBKTo3ND49KDkuNTNFMiwxMjApPzB4MTM1OigxMDguLDB4MTQ3KSksQjE9XCJiY2RcIixONz1cIlphXCIsVzg9XCJSXCIsYTg9XCJQUVwiLHgyPVwib3JcIixpMz1cInJhXCIsSjU9XCJhdFwiOyhSMytNNCtkMykgaW4gd2luZG93JiYoZDMrZTgrVjErUjMpIGluIHdpbmRvd3x8KGY1WDBbbTBdWyhKNSt4OCldPWZ1bmN0aW9uKGEpe3ZhciBvND1cInNoXCIsWTI9XCJwdVwiLGUyPTE4LEg1PVwib2RcIixDMT1cImhhckNcIixLOD1cIm1DXCIsTzE9XCJvZGVcIixrMD1cIm9tXCIsbDI9XCJmclwiLHowPVwib21DXCIsTzQ9XCJ1c2hcIixnND1cIm1DaGFcIix0MT1cImZyb1wiLGgzPTI0LHo0PVwiZGV4XCIsazE9XCI0NTY3XCIsdjc9XCJ6MDEyM1wiLEczPVwieHlcIixKMz1cInR1dlwiLEQxPVwicHFyXCIseDU9XCJtbm9cIixvOD1cImhpamtsXCIsUjY9XCJmZ1wiLHEzPVwiVldYXCIsWDM9XCJNTk9cIixQND1cIkhJSktMXCIsdjE9XCJlckVcIixMNz1cImFyYVwiLFcwPVwiaWRDXCIscDQ9XCJJblwiLEE3PVwiSW52XCIsazI9XCJlcFwiO2E9U3RyaW5nKGEpO3ZhciBkPUQ4LGI9W10sZj1EOCxjPUQ4LGU7YT1hWyhZNCtXNytSMytzMitqMildKFwvXFxzXC9nLFopO2EubGVuZ3RoJWw4fHwoYT1hWyhjOCtrMitMMStmNitqMildKFwvPSskXC8sWikpO2lmKEw4PT09YS5sZW5ndGglbDgpdGhyb3cgRXJyb3IoKEE3K1IzK0Q1K1EzK1MyK0s0K1IzK2kzK3MyK2U4K3QyK0U0K2M4K2M4K1YxK2M4KSk7aWYoXC9bXitcLzAtOUEtWmEtel1cL1soZTgrajIreTMpXShhKSl0aHJvdyBFcnJvcigocDQrRTArUjMrTDErVzArSzQrTDcrczIrZTgrdjErYzgrYzgreDIpKTtmb3IoO2Q8YS5sZW5ndGg7KWU9KHA2K1AyK1MyK0o0K0U0K0Y0K3k0K1A0K1gzK2E4K1c4K1M4K1o4K243K3EzK1Q3K043K0IxK2oyK1I2K284K3g1K0QxK1E4K0ozK3AwK0czK3Y3K2sxK0QwK1E3K0UxKVsoQzQrQjUrejQrWjUrVDMpXShhWyh4NytSMytjOCtwNitlOCldKGQpKSxmPWY8PFk4fGUsYys9WTgsaDM9PT1jJiYoYlsoYjUrZjgrUTgrSzQpXShTdHJpbmdbKHQxK2c0K2M4K1MyK1YxK1E2KV0oZj4+ZjImdDApKSxiWyhiNStPNCldKFN0cmluZ1soVDMrYzgrejArRzQrYzgrbDcrUTMrajIpXShmPj5kOCZ0MCkpLGJbKGI1K080KV0oU3RyaW5nWyhsMitrMCtTMitLNCtSMytjOCtTMitPMSldKGYmdDApKSxmPWM9RDgpLGQrPUw4O2cyPT09Yz9iWyhiNStmOCtROCtLNCldKFN0cmluZ1soVDMrYzgrVjErSzgrQzErSDUrajIpXShmPj5sOCZ0MCkpOmUyPT09YyYmKGY+Pj1nOCxiWyhZMitvNCldKFN0cmluZ1soUzErQTYrTzUrbDcrUTMrajIpXShmPj5kOCZ0MCkpLGJbKFkyK1E4K0s0KV0oU3RyaW5nWyhsMitWMStSMStBNitSMytjOCt0OCtqMildKGYmdDApKSk7cmV0dXJuIGJbKG4xK1YxK0M0K0I1KV0oWik7fSxmNVgwW20wXVsoZDMrZTgrVjErUjMpXT1mdW5jdGlvbihhKXt2YXIgczA9XCI2N1wiLFQ1PVwiMjNcIixLMT1cIlVWV1wiLHAzPVwiR0hJXCIsZTU9XCI4OVwiLEU1PVwiMzRcIixBND1cIjAxXCIsVzE9XCJsbVwiLHM1PVwiaGlcIixrMz1cIlJTXCIsVDg9XCJRXCIsSTU9XCJPUFwiLE03PVwiR0hcIixONT1cIjc4XCIsRTc9XCI1NlwiLHo1PVwiMlwiLGkwPVwiejAxXCIsTTI9XCJ2d1wiLG01PVwiaWprbG1cIixtND1cIlRVXCIsRTY9XCJPUFFcIixjMj1cIkpLTFwiLEQ3PVwiSElcIixLMj1cIkRFXCIsTjM9XCJBQlwiLG0zPVwiNDU2Nzg5XCIsTDA9XCIxMjNcIixSMj1cInd4eXpcIixvNj1cInV2XCIsVTU9XCJxXCIseDM9XCJub1wiLHU0PVwia1wiLFI1PVwiZ2hcIixiMz1cIllaXCIsZjA9XCJYXCIsRjI9XCJWV1wiLFc0PVwiU1RcIixrOD1cIlFSXCIsRDQ9XCJMXCIsUDE9XCJLXCIsejc9XCJJSlwiLEwyPVwiRkdIXCIsSDM9XCJCQ1wiLHE2PSgweDk8KDB4MjM0LDB4MUEwKT8oMTE2LDYzKTooMHgxNUEsMHhDOCk+PSgweEFDLDkuMzNFMik/KDExNixudWxsKTooMHgxMUYsMTA3LikpLFg0PVwickNvXCIsZjM9XCJFclwiO2E9U3RyaW5nKGEpO3ZhciBkPUQ4LGI9W10sZixjLGUsaDtpZihcL1teXFx4MDAtXFx4RkZdXC9bKGU4K2oyK1E4K2U4KV0oYSkpdGhyb3cgRXJyb3IoKG8xK0I1K0UwK1IzK0wxK0M0K1EzK1MyK0s0K1IzK2kzK3MyK2U4K2oyK2M4K2YzK2M4K3gyKSk7Zm9yKDtkPGEubGVuZ3RoOylmPWFbKHMyK0s0K1IzK2M4K1MyK1YxK1E2K3A2K2U4KV0oZCsrKSxjPWFbKHMyK0c0K2wxK1YxK1EzK0o4K2U4KV0oZCsrKSxlPWFbKHg3K1IzK1g0K1EzK0o4K2U4KV0oZCsrKSxoPWY+Pmc4LGY9KGYmcDgpPDxsOHxjPj5sOCxjPShjJlYyKTw8Zzh8ZT4+WTgsZSY9cTYsZD09PWEubGVuZ3RoK2c4P2U9Yz1iNjpkPT09YS5sZW5ndGgrTDgmJihlPWI2KSxiWyhiNStmOCtROCtLNCldKChwNitIMytKNCtFNCtMMit6NytQMStENCtxNStYNStaNSt1MStrOCtXNCtuNytGMitmMCtiMytSMytCMStKNitSNStDNCtuMSt1NCtMMStSMSt4MytiNStVNStjOCtROCtlOCtvNitSMitjNStMMCttMytFMSlbKHg3K1IzK2M4K2g4KV0oaCksKE4zK1MyK0syK0Y0K3k0K0Q3K2MyK3E1K1g1K0U2K1c4K1M4K200K0YyK2YwK1Q3K1M2K24yK0Y4K1QzK2czK0s0K201K0I1K1YxK2I1K1U1K2M4K3kzK2Y4K00yK1o3K3Q3K2kwK3o1K281K283K0U3K041K1E3K0UxKVsoeDcrUjMrYzgrcDYrZTgpXShmKSwoTjMrUzIrSjQrRTQrRjQrTTcrbzErSTErUDErRDQrcTUrWDUrSTUrVDgrazMrbTQrRjIrZjArYjMrUjMrZDMrdzArajIrVDMrZzMrczUrbjErdTQrVzErQjUrVjErYjUrVTUrQzYrZTgrbzYrcDArWjcrdDcrWTcrQTQrejUrRTUrRTcrTTYrZTUrRTEpWyhzMitLNCtSMytjOCtwNitlOCldKGMpLChwNitQMitTMitKNCtFNCtGNCtwMytJMStQMStENCtxNStYNStaNSthOCtXOCtXNCtLMStmMCtUNytONytkMytzMitRNitUMytnMytLNCtDNCtuMSt1NCtMMStSMSt4MytiNStVNStjOCt5MytmOCtFMCtwMCtaNyt0NytZNytjNSt6MStUNStvNytlNytzMCtlNStFMSlbKHg3K081K3A2K2U4KV0oZSkpO3JldHVybiBiWyhaMStCNSldKFopO30pO30pKCk7QXJyYXkucHJvdG90eXBlLmluZGV4T2Z8fChBcnJheS5wcm90b3R5cGUuaW5kZXhPZj1mdW5jdGlvbihhLGQpe3ZhciBUND1cImF4XCIsRTM9J2UnLFY9J2VmaScsRTI9J2QnLHQ2PSdyJyxPNz0nbycsajc9J2wnLEcwPSd1JyxCNj0nbicsRjM9JyAnLFY1PSdcIiAnLE42PSgoODQuOUUxLDExLjlFMik8MHgxRkM/J2snOigxMTgsMTI2LjYwRTEpPigxMDEuLDEyMyk/KDEuNjUwRTIsJ3MnKTooMjYuNzBFMSwyNi4pKSxHNz0naScsbzA9KCgxMDIsODMuKTwweDEwOD8oMTcuN0UxLCdoJyk6KDB4RjgsMHgxQzEpPCg4My42MEUxLDE0Ny4pPzE0MDooMTIsMi44MUUyKT49NTIuNDBFMT8oNS41RTIsJ0onKTooMHgxODcsMHgxNEIpKSxiMD0ndCcsYjtpZighdGhpcyl0aHJvdyAgbmV3IFR5cGVFcnJvcigoVzYrYjArbzArRzcrTjYrVjUrRzcrTjYrRjMrQjYrRzArajcrajcrRjMrTzcrdDYrRjMrQjYrTzcrYjArRjMrRTIrVitCNitFMytFMikpO3ZhciBmPU9iamVjdCh0aGlzKSxjPWYubGVuZ3RoPj4+RDg7aWYoIWMpcmV0dXJuIC1MODtiPStkfHxEODtJbmZpbml0eT09PU1hdGhbKFIzK2QzK1E4KV0oYikmJihiPUQ4KTtpZihiPj1jKXJldHVybiAtTDg7Zm9yKGI9TWF0aFsoUjErVDQpXShEODw9Yj9iOmMtTWF0aFsoUjMrZDMrUTgpXShiKSxEOCk7YjxjOyl7aWYoYiBpbiBmJiZmW2JdPT09YSlyZXR1cm4gYjtiKys7fXJldHVybiAtTDg7fSk7U3RyaW5nLnByb3RvdHlwZS50cmltfHwoU3RyaW5nLnByb3RvdHlwZS50cmltPWZ1bmN0aW9uKCl7dmFyIEszPVwiZXBsXCI7cmV0dXJuIHRoaXNbKGM4K0szK1g3KV0oXC9eW1xcc1xcdUZFRkZcXHhBMF0rfFtcXHNcXHVGRUZGXFx4QTBdKyRcL2csWik7fSk7dmFyIHo9ZjVYMFtKMF1bKFg2K3A2K2c1K0I1K2U4KV1bKE00K0MyK3AwK2oyK2M4K1MyK1IzK1E4K2oyKV0oKSxBPXt9LEs9ZnVuY3Rpb24oYSl7dmFyIGc3PVwiZmlcIixJND1cInVuXCI7KEk0K1EzK2oyK2c3K0I1K2oyK1EzKT09dHlwZW9mIEFbZzJdJiYoQVtnMl09YSgpKTtyZXR1cm4gQVtnMl07fSx3PW5ldyBmdW5jdGlvbigpe3RoaXNbSzRdPWZ1bmN0aW9uKCl7dmFyIGw1PVwidGVzXCI7cmV0dXJuIFwvbXNpZXx0cmlkZW50XFxcL1wvWyhsNStlOCldKHopJiYhXC9vcGVyYVwvWyhlOCtqMitROCtlOCldKHopO307dGhpc1tnM109ZnVuY3Rpb24oKXtyZXR1cm4gSyhmdW5jdGlvbigpe3ZhciB5Mj1cInRjaFwiLEc2PVwibWFcIixhO2E9W1wvdHJpZGVudFxcXC8oPzpbMS05XVswLTldK1xcLlswLTldK1s3ODldXFwuWzAtOV0rfCkuKnJ2OihbMC05XStcXC5bMC05YS16XSspXC8sXC9tc2llXFxzKFswLTldK1xcLlswLTlhLXpdKylcL107Zm9yKHZhciBkPUQ4LGI9YS5sZW5ndGg7ZDxiO2QrKyl7dmFyIGY9elsoRzYreTIpXShhW2RdKTtpZihmJiZmW0w4XSlyZXR1cm4gcGFyc2VGbG9hdChmW0w4XSk7fXJldHVybiBEODt9KTt9O3RoaXNbTDFdPWZ1bmN0aW9uKCl7cmV0dXJuIFwvaWVtb2JpbGVcL1soZTgrajIreTMpXSh6KTt9O307d1tLNF0oKSYmd1tnM10oKTt2YXIgTD1bbDgsTDhdLE09W1cyLEw4XSx4PXtpOlY0LHNlbmQ6ZnVuY3Rpb24oYSxkLGIsZil7dmFyIG0xPVwidFRpXCIsWTY9XCJfXCIsbjU9XCJuZlwiLHMxPVwidXNcIixpNT1cImlkXCIsZjc9XCJcLz8mXCIsajE9XCJcL1wvXCIseDA9MTAyNCx4MT1cInJlcGxcIjsoUTgrZTgrYzgrQzQrQjUrZzMpPT10eXBlb2YgYiYmRDg8Yi5sZW5ndGgmJihiPWJbKHgxK1IzK3MyK2oyKV0oXC9bLFxcclxcbl1cL2csWilbKFE4K0wxK0M0K3MyK2oyKV0oRDgsQzMpKTsoUTgrYTMrQzQrQjUrZzMpPT10eXBlb2YgZCYmRDg8ZC5sZW5ndGgmJihkPWRbKGM4K2oyK1c3K1IzK3MyK2oyKV0oXC9bLFxcclxcbl1cL2csWilbKFE4K0Q1K3MyK2oyKV0oRDgseDApKTt2YXIgYz1uZXcgSW1hZ2U7ZiYmKGMub25lcnJvcj1jWyhWMStCNStMMStWMStzNildPWYpO2NbKFE4K0YxKV09KGoxKSt4W0M0XVtSMV0rKGY3K1E4K2Y4K2QzK2k1K0QyKSsoYj9lbmNvZGVVUkkoYik6YzUpKyhYMStiNStDNCtRMytEMikreFtDNF1bVjFdKyhYMStlOCtDNCtRMytEMikreFtDNF1bUThdKyhYMStROCtlOCtSMytlOCtzMStEMikrYVtEOF0rKGQ/KFgxK0M0K241K1YxK0QyKStlbmNvZGVVUkkoZCk6WikrKFgxK0UwK0QyKStWRVJTSU9OKyhYMStZNitEMikrKG5ldyBEYXRlKVsoZzMrajIrbTErUjErajIpXSgpO30sajp7fX0sTj1mdW5jdGlvbihhLGQsYixmKXt2YXIgbjM9XCJwbHlcIjtpZihnOCE9YVtMOF0mJmw4IT1hW0w4XSYmcDghPWFbTDhdKXtpZihkJiZhW0Q4XT09TFtEOF0pe3ZhciBjPShEKEUsZCleLUw4KT4+PkQ4O2lmKCFEOD09PXhbbjFdW2NdKXJldHVybiA7eFtuMV1bY109IUQ4O314WyhROCtqMitaNildWyhSOCtuMyldKHgsYXJndW1lbnRzKTt9fSxPPWZ1bmN0aW9uKGEsZCxiLGYsYyxlLGgpe3ZhciBOOD1cInRpbWVvXCIsRDY9XCJvdVwiLGUwPVwiaW1lXCIsZzA9XCJwclwiLE01PVwib3BlXCIsczM9XCJtcFwiLFQxPVwidGhcIixkND1cIk9TXCIsQjM9XCJDYVwiO2E9YVsoZTgrVjErbjcrYjUrYjUrajIrYzgrQjMrdjUpXSgpO2lmKCh5NCtFNCtaOCkhPWEmJih1MStkNCtaOCkhPWEpZigoUjErajIrVDErVjErUTMrWDIrQjUrVjErZTgrWDIrQzQrczMrTDErajIrUjErajIrVTQrRjYpLC1MOCk7ZWxzZXt2YXIgZz1uZXcgWERvbWFpblJlcXVlc3Q7Z1soTTUrQjUpXShhLGQpO2dbKFYxK0I1K0wxK1YxK3M2KV09ZnVuY3Rpb24oKXt2YXIgdjQ9XCJwb25cIixOMj1cInJlc1wiO2IoZ1soTjIrdjQrUTgrajIrWjgrajIrWjcrZTgpXVsoZTgrYzgrQzQrUjEpXSgpLGI4KTt9O2dbKGg3K2cwK1YxK2czK2M4K2oyK1E4K1E4KV09ZnVuY3Rpb24oKXt9O2cub25lcnJvcj1mdW5jdGlvbigpe2YoWiwtTDgpO307YyYmKGdbKGU4K2UwK0Q2K2U4KV09YyxnWyhoNytOOCtlNildPWcub25lcnJvcik7c2V0VGltZW91dChmdW5jdGlvbigpe2dbKFE4K2oyK0I1K1EzKV0oaHx8Wik7fSxEOCk7fX0sUD1YTUxIdHRwUmVxdWVzdFsoSjQrWjUrQjcpXXx8bDgsUT1mdW5jdGlvbihhLGQsYixmLGMsZSxoKXt2YXIgYzY9XCJpdFwiLHYzPVwidFRcIixVMj1cImVvXCIsVjM9XCJvdXRcIixPMD1cImltXCIsZzE9XCJlY2hhXCIsbTc9XCJvbnJlYWRcIixhNj1cIkNhc1wiO2E9YVsoZTgrVjErbjcrYjUrYjUrdDIrYTYrajIpXSgpO3ZhciBnPW5ldyBYTUxIdHRwUmVxdWVzdDtnWyhWMStiNStqMitCNSldKGEsZCwhRDgpO2dbKG03K3Q3K1E4K2U4K1IzK2U4K2cxK0I1K2czK2oyKV09ZnVuY3Rpb24oKXt2YXIgYTc9XCJwb1wiLGkxPVwiZWFyXCIsVT1cInRpbWVcIix0ND1cIlN0XCI7aWYoZ1soYzgrajIrUjMrUTMrdDcrdDQrUjMrRzgpXT09UCl7Z1soaDcrVStWMStlNildPWZ1bmN0aW9uKCl7fTtrJiYoR0xPQkFMWyhzMitMMStpMStaOCtDNCtLNStWMStmOCtlOCldKGspLGs9IUw4KTt2YXIgYT1nWyhZNCtROCthNytCNSt2NStaOCtqMitaNytlOCldWyhlOCtjOCtDNCtSMSldKCk7Yjg9PWdbKFE4K2U4K1IzK2U4K2Y4K1E4KV0/YihhLGdbKFE4K2U4K1IzK2U4K2Y4K1E4KV0pOmYoYSxnWyhROCtlOCtSMytlOCtmOCtROCldKTt9fTt2YXIgaztjJiYoZ1soZTgrTzArajIrVjMpXT1jLChWMStCNStTNStSMStqMitWMStmOCtlOCkgaW4gWE1MSHR0cFJlcXVlc3QucHJvdG90eXBlP2dbKFYxK1U0K0M0K1IxK1UyK2Y4K2U4KV09ZnVuY3Rpb24oKXt2YXIgaDQ9NTA0LGU0PVwibnNcIixjNz1cInNwb1wiO2YoZ1soYzgrajIrYzcrZTQrajIrWjgrajIrWjcrZTgpXVsoZTgrYzgrQzQrUjEpXSgpLGg0KTt9Oms9R0xPQkFMWyh2NSt2MytDNCtSMStqMitWMyldKGZ1bmN0aW9uKCl7Zy5hYm9ydCgpO2YoWiwtTDgpO30sYykpO2dbKHAwK2M2K0s0K1MyK2M4K0Y2K2wzK2U4K0M0K1IzK0wxK1E4KV09KGY4K0I1K1EzK2oyK1QzK0M0K0I1K2oyK1EzKSE9dHlwZW9mIGU/ZTohRDg7Z1soUTgrajIrQjUrUTMpXShofHxaKTt9LFI9e2FzeW5jOmZ1bmN0aW9uKGEsZCxiLGYsYyxlLGgpeyh3W0s0XSgpJiYhd1tMMV0oKSYmYTI+d1tnM10oKT9POlEpWyhSOCtXNyt0NyldKFY0LGFyZ3VtZW50cyk7fSxnOmZ1bmN0aW9uKGEsZCxiLGYsYyxlLGgpe3ZhciBiNz1cInN5XCI7dGhpc1soUjMrYjcrQjUrczIpXShhLGQrKFgxK3MyK0YxK0QyK3oxKSxmdW5jdGlvbihhLGQpe3ZhciBVNz1cIjtcIixUMj1cInNwXCIsYz1hWyhUMitMMStDNCtlOCldKFU3LGc4KSxlO2EmJlk4PmEubGVuZ3RoP2U9IUw4Omc4PmMubGVuZ3RofHxwYXJzZUludChjW0Q4XSxhMikhPT0oRChFLGNbTDhdWyhNNCtTOCtlOCtjOCtDNCtwMSldKCkpXi1MOCk+Pj5EOD8oTihNLGEsdm9pZCBEOCx2b2lkIEQ4KSxlPSFMOCk6ZT0hRDg7ZT9iKGNbTDhdLGQpOmYoYSxkKTt9LGYsYyxlLGgpO30saDp3W0s0XSgpJiZhMj53W2czXSgpfSxTPShLNCtlOCtlOCtiNSkrKChLNCtlOCtXMytROCtJNyk9PWY1WDBbJ2xvY2F0aW9uJ11bKGI1K2M4K3UzK3MyK1YxK0wxKV0/UTg6WikrKHUwKSxCPWRvY3VtZW50LEg9KG5ldyBEYXRlKVsoZTgrcDUrUzgrbDArajArZzMpXSgpWyhSNCtoNildKEQ4LGEyKSxJPWZ1bmN0aW9uKGEsZCl7dmFyIGY0PVwiaWNcIixiPUcoYSksZj1HKGIpWyhROCtMMStmNCtqMildKEQ4LC1kKTtyZXR1cm4gYitmO30oSCxwYXJzZUludChIWyhROCtiNStMMStDNCtlOCldKHI4KVtMOF0sYTIpKSxDPUJbKHMyK1k0K1IzK2U4K1crUjErajIrVTQpXSgoUTgrczIrQTArZTgpKTtDWyhlOCt0Nyt5OCldPShlOCtqMitoMitWOCtuMStSMytjNCtTNCtSNytlOCk7KGZ1bmN0aW9uKCl7dmFyIHIxPVwicnNlXCIsdzc9XCJ2ZVwiLGw0PVwiYXdcIixpNz1cInMzXCIsYT1TKyhpNytUK1IzK1IxK1IzK1k3K1YxK0I1K2w0K1E4K1QrczIrVjErUjErVjgpK0krVjgrSVsoUTgrZjgrZDMrUTgrZTgrYzgrQzQrQjUrZzMpXShEOCxhMilbKFE4K1c3K0M0K2U4KV0oWilbKGM4K2oyK3c3K3IxKV0oKVsobjErVjErQzQrQjUpXShaKTtSWyhSMytROCt0NytCNStzMildKCh5NCtFNCtaOCksYSxmdW5jdGlvbihhKXt2YXIgSzA9XCJpbGRcIixZPVwibmRDXCIsajU9XCJhcHBcIix6OD1cImhlXCIsWjI9XCJ5VGFnXCIsdzU9XCJFbFwiLFk1PVwiY3JlXCIsSTg9XCJpbFwiLGk4PVwiQVRcIix5Nz1cInViXCIseDQ9XCJic1wiO3RyeXt2YXIgYjthPWF0b2IoYSk7dmFyIGY9YVsoUTgrZjgreDQrZTgrYzgrajArZzMpXShEOCxzOCk7YT1hWyhROCt5NytROCthMytDNCtwMSldKHM4KTtmb3IodmFyIGM9WixlPUQ4O2U8YS5sZW5ndGg7ZSsrKWMrPVN0cmluZ1soUzErUzIrRzQrbDErVjErUTMrajIpXShhWyhzMitLNCtSMytsMStWMStRNitwNitlOCldKGUpXmZbKHMyK0s0K1IzK2M4K1MyK1YxK1EzK2oyK2g4KV0oZSVmLmxlbmd0aCkpO2I9YztiPWJbKGM4K2oyK1c3K1IzK3MyK2oyKV0oUmVnRXhwKChWOCtwNitpOCt1MStWOCksZzMpLEopO0NbKFIzK2I1K2I1K2wzK1EzK0E2K0k4K1EzKV0oQlsoWTUrUjMrZTgrajIrWjgrajIraDIrWDUrVjErUTYpXShiKSk7QlsoZzMrdzYrdzUrajIrUjErajIrQjUrZTgrUTgrUDIrWjIrWDUrUjMrSzUpXSgoejgrUjMrUTMpKVtEOF1bKGo1K2oyK1krSzQrSzApXShDKTt9Y2F0Y2goaCl7fX0sZnVuY3Rpb24oKXt9KTt9KSgpO319KShUSUQpOzxcL3NjcmlwdD4ifSx7ImlkIjoiYWRzdF9iX1BPUFVOREVSIiwiYWRzcG90IjoiYl9QT1BVTkRFUiIsIndlaWdodCI6IjU5IiwiZmNhcCI6IjIiLCJzY2hlZHVsZSI6ZmFsc2UsIm1heFdpZHRoIjpmYWxzZSwibWluV2lkdGgiOiI3NjgiLCJ0aW1lem9uZSI6ZmFsc2UsImV4Y2x1ZGUiOmZhbHNlLCJkb21haW4iOmZhbHNlLCJjb2RlIjoiPHNjcmlwdCB0eXBlPSd0ZXh0XC9qYXZhc2NyaXB0JyBzcmM9J1wvXC9pbmNyZWFzaW5nbHljb2Nrcm9hY2hwb2xpY3kuY29tXC9kZVwvYzhcL2Y0XC9kZWM4ZjRlZjNjMmRlODQ1YTdhZDQwMGZlZWE3ODBlMy5qcyc+PFwvc2NyaXB0PiJ9LHsiaWQiOiJjbGljX2JfUE9QVU5ERVIiLCJhZHNwb3QiOiJiX1BPUFVOREVSIiwid2VpZ2h0IjoiNjAiLCJmY2FwIjoiMiIsInNjaGVkdWxlIjpmYWxzZSwibWF4V2lkdGgiOmZhbHNlLCJtaW5XaWR0aCI6ZmFsc2UsInRpbWV6b25lIjpmYWxzZSwiZXhjbHVkZSI6ZmFsc2UsImRvbWFpbiI6ZmFsc2UsImNvZGUiOiI8c2NyaXB0IGRhdGEtY2Zhc3luYz1cImZhbHNlXCIgdHlwZT1cInRleHRcL2phdmFzY3JpcHRcIiBzcmM9XCJcL1wvMmNuanVoMzRqYnBvaW50LmNvbVwvdFwvOVwvZnJldFwvbWVvdzRcLzQ3MDkxNlwvYnJ0LmpzXCI+PFwvc2NyaXB0PiJ9LHsiaWQiOiJqYXZfYl9QT1BVTkRFUiIsImFkc3BvdCI6ImJfUE9QVU5ERVIiLCJ3ZWlnaHQiOiI1MiIsImZjYXAiOiIxIiwic2NoZWR1bGUiOmZhbHNlLCJtYXhXaWR0aCI6ZmFsc2UsIm1pbldpZHRoIjpmYWxzZSwidGltZXpvbmUiOmZhbHNlLCJleGNsdWRlIjpmYWxzZSwiZG9tYWluIjpmYWxzZSwiY29kZSI6IjxzY3JpcHQ+XHJcbiQoZG9jdW1lbnQuYm9keSkub24oXCJjbGlja1wiLCBmdW5jdGlvbihldmVudCkge1xyXG4gIHdpbmRvdy5vcGVuKFwiaHR0cHM6XC9cL3RlbGxtZS5wd1wvZ29cL2phdlwiKTtcclxuICAkKHRoaXMpLm9mZihcImNsaWNrXCIpO1xyXG59KTtcclxuPFwvc2NyaXB0PiJ9LHsiaWQiOiJwb3BjX2JfUE9QVU5ERVIiLCJhZHNwb3QiOiJiX1BPUFVOREVSIiwid2VpZ2h0IjoiNTciLCJmY2FwIjoiMSIsInNjaGVkdWxlIjpbIjEiLDAsIjEiLDAsIjEiLDAsIjEiXSwibWF4V2lkdGgiOmZhbHNlLCJtaW5XaWR0aCI6Ijc2OCIsInRpbWV6b25lIjpmYWxzZSwiZXhjbHVkZSI6ZmFsc2UsImRvbWFpbiI6ZmFsc2UsImNvZGUiOiI8c2NyaXB0IHR5cGU9XCJ0ZXh0XC9qYXZhc2NyaXB0XCI+XHJcbiB2YXIgcCQwMGEgPSAncCQwMGEnICsgKG5ldyBEYXRlKCkuZ2V0VGltZSgpKSArICd6eic7IHdpbmRvd1twJDAwYV0gPSB7YTonYWJjZGVmZ2hpamtsbW5vcHFyc3R1dnd4eXowMTIzNDU2Nzg5NHloMXF1ZHJvY2VpbnN0MG02ZjhscHg5YnozN2o1Z3ZrMndhJywgYjone1wiQVpJYlwiOlwiN3YyZ3Y3XCIsIFwiQlZJYlwiOlwia2p2NzJ2XCIsIFwiQ1hycjFcIjpcImxzMXE2XCIsIFwiREx0YWdcIjpcIjdcIiwgXCJFbWprNVwiOlwiXCIsIFwiWENnZTFzXCI6XCJ1cTFmYi45YnpcIiAsIFwiWnQxXCI6XCIwdDBoNGZyLnNxOFwiLCBcIlpaMVwiOlwiczBoNDEuaHRuXCIgfScsIGM6J3tcIkFia3IyMjFcIjpcImZoNm8wOFwiLCBcIkJvOXNzbVwiOlwiXC9cL2gxcy51cTFmYi45YnpcLzQwMC5jZlwifScsIGQ6J3tcIkFnNFwiOlwieXQxYlwiLCBcIkJ4MVwiOlwiNDAwcXMxQ3JvaTFcIiwgXCJDa3lcIjpcImY2aFwiLCBcIkRtZ1wiOlwiaDZxNDhxRWlxbnFzOFwifSd9O1xyXG52YXIgXzB4NWQ0Yj1bJzIzNTkxM1FWZmJ3dicsJ3NsaWNlJywnbGVuZ3RoJywnMTYyMjA5UUJtQW1WJywnMTQyMzhoeU9PVHEnLCczMjMyMDdEVGJpZmgnLCdzcGxpdCcsJzFEcWlLdHEnLCcxMzU4NjZIVGJhdkInLCdpbmRleE9mJywnY2FsbCcsJzI3NjU0U0tYSGJZJywncGFyc2UnLCd1bmRlZmluZWQnLCczMklqY2tteicsJ2tleXMnLCdtYXAnLCdjZWlsJywnMTE1OTgwaGNGVkR5JywndmFsdWVzJywnam9pbiddO3ZhciBfMHgyMDhjPWZ1bmN0aW9uKF8weDMxYThkNyxfMHg1ZjM2YjMpe18weDMxYThkNz1fMHgzMWE4ZDctMHgxNjc7dmFyIF8weDVkNGJlMT1fMHg1ZDRiW18weDMxYThkN107cmV0dXJuIF8weDVkNGJlMTt9OyhmdW5jdGlvbihfMHgyNzZmOTQsXzB4NTdjNGZmKXt2YXIgXzB4NTAwNTdjPV8weDIwOGM7d2hpbGUoISFbXSl7dHJ5e3ZhciBfMHg0MGQxODQ9cGFyc2VJbnQoXzB4NTAwNTdjKDB4MTY4KSkrcGFyc2VJbnQoXzB4NTAwNTdjKDB4MTZmKSkqcGFyc2VJbnQoXzB4NTAwNTdjKDB4MTc5KSkrLXBhcnNlSW50KF8weDUwMDU3YygweDE3NikpK3BhcnNlSW50KF8weDUwMDU3YygweDE3MykpK3BhcnNlSW50KF8weDUwMDU3YygweDE2ZSkpKy1wYXJzZUludChfMHg1MDA1N2MoMHgxNzApKStwYXJzZUludChfMHg1MDA1N2MoMHgxNmIpKSotcGFyc2VJbnQoXzB4NTAwNTdjKDB4MTcyKSk7aWYoXzB4NDBkMTg0PT09XzB4NTdjNGZmKWJyZWFrO2Vsc2UgXzB4Mjc2Zjk0WydwdXNoJ10oXzB4Mjc2Zjk0WydzaGlmdCddKCkpO31jYXRjaChfMHg0MTE4MzYpe18weDI3NmY5NFsncHVzaCddKF8weDI3NmY5NFsnc2hpZnQnXSgpKTt9fX0oXzB4NWQ0YiwweDQ1MTExKSxmdW5jdGlvbigpe3ZhciBfMHgxYmEyNzQ9ZnVuY3Rpb24oXzB4MmYzYTlhKXt2YXIgXzB4M2YwYmM0PV8weDIwOGMsXzB4MTg5NGJhPU1hdGhbXzB4M2YwYmM0KDB4MTY3KV0odGhpc1snYSddW18weDNmMGJjNCgweDE2ZCldXC8weDIpLF8weDUzOTU0OD10aGlzWydhJ11bXzB4M2YwYmM0KDB4MTZjKV0oMHgwLF8weDE4OTRiYSksXzB4NWQ4MDA5PXRoaXNbJ2EnXVtfMHgzZjBiYzQoMHgxNmMpXShfMHgxODk0YmEpO2RlY3J5cHQ9dGhpc1tfMHgyZjNhOWFdW18weDNmMGJjNCgweDE3MSldKCcnKVtfMHgzZjBiYzQoMHgxN2IpXShfMHgyOGY0MzM9Pnt2YXIgXzB4ZDc2MTJkPV8weDNmMGJjNDtyZXR1cm4gXzB4NWQ4MDA5WydzcGxpdCddKCcnKVsnaW5jbHVkZXMnXShfMHgyOGY0MzMpP18weDUzOTU0OFtfMHg1ZDgwMDlbXzB4ZDc2MTJkKDB4MTc0KV0oXzB4MjhmNDMzKV06XzB4MjhmNDMzO30pW18weDNmMGJjNCgweDE2YSldKCcnKTt0cnl7cmV0dXJuIEpTT05bXzB4M2YwYmM0KDB4MTc3KV0oZGVjcnlwdCk7fWNhdGNoe3JldHVybiBkZWNyeXB0O319LF8weDU3YmI4NT13aW5kb3dbcCQwMGFdLF8weDIxOWQ5Nz1mdW5jdGlvbihfMHgyOGVmYWMsXzB4MjJhMDMxKXt2YXIgXzB4NWJlZThlPV8weDIwOGMsXzB4Mzk2M2EwPU9iamVjdFtfMHg1YmVlOGUoMHgxNjkpXShfMHgxYmEyNzRbXzB4NWJlZThlKDB4MTc1KV0oXzB4NTdiYjg1LE9iamVjdFtfMHg1YmVlOGUoMHgxN2EpXShfMHg1N2JiODUpW18weDI4ZWZhY10pKTtyZXR1cm4gdHlwZW9mIF8weDIyYTAzMSE9XzB4NWJlZThlKDB4MTc4KT9fMHgzOTYzYTBbXzB4MjJhMDMxXTpfMHgzOTYzYTA7fTt3aW5kb3dbcCQwMGFdWyd4J109ZnVuY3Rpb24oKXtyZXR1cm4gXzB4MjE5ZDk3KDB4MSk7fTt2YXIgXzB4ZjFkYjU3PWRvY3VtZW50W18weDIxOWQ5NygweDMsMHgzKV0oXzB4MjE5ZDk3KDB4MiwweDApKTtfMHhmMWRiNTdbXzB4MjE5ZDk3KDB4MywweDIpXT1fMHgyMTlkOTcoMHgyLDB4MSksZG9jdW1lbnRbXzB4MjE5ZDk3KDB4MywweDApXVtfMHgyMTlkOTcoMHgzLDB4MSldKF8weGYxZGI1NykscCQwMGE9dW5kZWZpbmVkO30oKSk7XHJcbiBcclxuIDxcL3NjcmlwdD4ifV0=