tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 704065d1605337933-in-a-summary-sheet-different-ways-sum-up-all-values-as-per-criteria-from-multiple-sheets-sum-up-all-amounts-as-per-different-criterias
Sheet: Summary

Criteria1 | Criteria2 | Sum |  | Criteria1 | Criteria2 | Criteria3 | Sum |  | Criteria1 | Sum
Date | Name | Amount |  | from Month | to Month | Name | Amount |  | Name | Amount
2020-01-01 00:00:00 | ASD |  |  | Jan-2020 | Mar-2020 | ASD |  |  | ASD
2020-01-02 00:00:00 | BCD |  |  | Jan-2020 | June-2020 | BCD |  |  | BCD
2020-02-04 00:00:00 | ASD |  |  | Apr-2020 | June-2020 | ASD |  |  | ABV
2020-03-04 00:00:00 | ABV |  |  | Jan-2020 | Mar-2020 | ABV |  |  | ABC
2020-04-01 00:00:00 | ABC |  |  | Jan-2020 | June-2020 | ABC |  |  | FGH
2020-05-05 00:00:00 | ABV |  |  | Apr-2020 | June-2020 | ABV
2020-06-06 00:00:00 | FGH |  |  | Jan-2020 | June-2020 | FGH
Date | Name | Amount
2020-01-01 00:00:00 | ABC | 100
2020-01-02 00:00:00 | BCD | 20
2020-01-01 00:00:00 | ABV | 65
2020-01-01 00:00:00 | ASD | 25
2020-01-01 00:00:00 | ASD | 145
2020-01-02 00:00:00 | ABC | 100
2020-01-02 00:00:00 | BCD | 20
2020-01-02 00:00:00 | ABV | 65
2020-03-03 00:00:00 | ASD | 25
2020-03-03 00:00:00 | ASD | 145
2020-02-01 00:00:00 | ABC | 100
2020-02-03 00:00:00 | BCD | 20
2020-02-02 00:00:00 | ABV | 65
2020-02-04 00:00:00 | ASD | 25
2020-02-04 00:00:00 | ASD | 145
2020-03-01 00:00:00 | ABC | 100
2020-03-01 00:00:00 | BCD | 20
2020-03-04 00:00:00 | ABV | 65
2020-03-01 00:00:00 | ASD | 25
2020-03-03 00:00:00 | BCD | 20
2020-03-04 00:00:00 | ABV | 65
2020-03-04 00:00:00 | ASD | 25
2020-03-04 00:00:00 | ASD | 145
2020-04-01 00:00:00 | ABC | 100
2020-04-01 00:00:00 | BCD | 20
2020-04-01 00:00:00 | ABC | 65
2020-04-01 00:00:00 | ASD | 25
2020-04-02 00:00:00 | ASD | 145
2020-04-01 00:00:00 | ABC | 100
2020-04-03 00:00:00 | BCD | 20
2020-04-04 00:00:00 | ABV | 65
2020-04-04 00:00:00 | ASD | 25
2020-04-04 00:00:00 | ASD | 145
2020-05-01 00:00:00 | ABC | 100
2020-05-01 00:00:00 | BCD | 20
2020-05-02 00:00:00 | ASD | 145
2020-05-01 00:00:00 | ABC | 100
2020-05-03 00:00:00 | BCD | 20
2020-05-05 00:00:00 | ABV | 65
2020-05-05 00:00:00 | ABV | 25
2020-05-05 00:00:00 | ABV | 145
2020-06-01 00:00:00 | ABC | 100
2020-06-01 00:00:00 | ABC | 65
2020-06-01 00:00:00 | ASD | 25
2020-06-01 00:00:00 | ABC | 100
2020-06-03 00:00:00 | BCD | 20
2020-06-06 00:00:00 | FGH | 65
2020-06-06 00:00:00 | FGH | 25
2020-06-06 00:00:00 | FGH | 145
Spreadsheet: 803397d1667430682-sum-with-criteria-across-worksheets-formula-help
Sheet: February Detail Expense

 | G/L EXPENSE DATA
 | BOMA Code | Account Title | Date | Month | Requested by | Amount | Name of Payee | Notes | Column2 | Column3
 | 401 |  | 2022-02-02 00:00:00 |  |  | 300
 | 1550 |  | 2022-02-02 00:00:00 |  |  | 1200
 | 1900 |  | 2022-02-02 00:00:00 |  |  | 100
 | 1900 |  | 2022-02-02 00:00:00 |  |  | 400
 | 5510 |  | 2022-02-02 00:00:00 |  |  | 33
Spreadsheet: 794733d1662276697-automatically-generate-a-new-sheet-with-the-information-flipped-lo-example
Sheet: Sheet1

LO # | Learning outcome | Question number
1 | 1. Read and respond to a text of an appropriate length in a given period of time | 4 | 5 | 6
2 | 2. Show understanding of instructions | 1 | 13
3 | 3. Skim a text for the main idea | 2 | 6 | 9
4 | 4. Scan a text and demonstrate comprehension of specific information | 4 | 12
5 | 5. Deduce the meaning of words from context | 5 | 11 | 21
6 | 6. Identify pronouns and their reference | 7 | 9
7 | 7. Identify parts of speech and their functions in a text | 3 | 9
8 | 8. Distinguish between main ideas and supporting details | 8 | 14
9 | 9. Identify ideas expressed in compound and complex sentences | 16 | 17
10 | 10. Identify the writer’s point of view | 14 | 15
11 | 11. Recognize logical relationships within and between sentences | 20
12 | 12. Distinguish between facts and opinions | 18 | 19
13 | 13. Summarize short texts | 10
14 | 14. Use knowledge of word formation (prefixes, suffixes and roots) to comprehend a text | 7
Spreadsheet: darrell_schoolcraft__7343__sharris0302wk3
Sheet: Plan vs. Forecast

Transwestern Pipeline Company
($[NAME])
Plan vs. Forecast
 |  |  | Weekly
 |  | Plan | Forecast | [NAME] |  | Comments
West Demand Revenues
West Commodity Revenues |  |  |  |  |  | Lower Volumes; PGE prepayment
East Demand Revenues
East Commodity Revenues |  |  |  |  |  | Higher East Volumes
[NAME] |  |  |  |  |  | New Contracts:  Burlington, [NAME]
[NAME] Revenues |  |  |  |  |  | Lower IT Volumes
PNR Revenues |  | 0
Revenue Variance
Fuel Price [NAME] |  |  |  |  |  | MTD index price of $2.60 vs. Plan index price of $2.56
Fuel Volume Variance-Unhedged |  |  |  |  |  | Lower retained volumes due to lower West flow & Bisti outage
Sales Margin Variance on Unhedged
Hedging Adjustment
Plan Fuel Stretch |  |  | 0
Other Adjustment
Fuel Variance (Excludes UAF)
Monthly Stretch |  | 0 | 0
Target Adjustment |  | 0 | 0
Current Month Margin Variance
Expenses |  | -0.942 | -0.75
Non-Recurring |  | 0
Other |  | -0.004
Total Current Month Variance
May |  | 0 | 0
April |  | 0 | 0
March |  | 0 | 0
February |  | 12.233 | 12.578 |  |  | Actuals
January |  | 13.71 | 13.451 |  |  | Actuals
March 31, 2002 YTD
Spreadsheet: 65448d1266170724-search-and-return-address-for-all-matches-findaddress
Sheet: Sheet1

A | F | K |  | Search: |  | Address:
B | G | L |  | A |  | $A$1 | $A$1 |  | 1 "A" was added in C10 to dubblecheck formula
C | H | M |  |  |  | $C$4 | $C$4
D | I | A |  |  |  | $B$6 | $B$6
E | J | O |  |  |  | $A$8 | $A$8
N | A | K |  |  |  | $B$8 | $B$8
B | G | L |  |  |  | $C$8 | $C$8
A | A | A |  |  |  | $A$10 | $A$10
D | H | M |  |  |  |  | $C$10
A | J | A
Spreadsheet: 771113d1646416714-summarizing-data-based-as-if-a-cell-contained-different-number-03-03-22-project
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  | 1 | CITY 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | CITY 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | CITY 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | CITY 4
 |  |  |  |  |  | HOURS | RATE | BURDEN | RATE TOTAL | BURDEN TOTAL | COMBINED
 |  |  |  |  | SAW | 12 |  | 0.58
 |  |  |  |  | HAMMER | 18 | 16 | 0.54
 |  |  |  |  | WELD | 22 | 20 | 0.21
 |  |  |  |  | PAINT | 5 | 22 | 0.35
 |  |  |  |  | ASSEMBLE | 7 | 30 | 0.66 |  |  |  |  |  |  |  | SUMMARY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL RATE | TOTAL BURDEN | COMBINED TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27.67
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28.53
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30.32999999999999
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23.77
 |  |  |  |  | CITY 1 |  | CITY 2 |  | CITY 3 |  | CITY 4
 |  |  |  | OP | RATE | BURDEN | RATE | BURDEN | RATE | BURDEN | RATE | BURDEN
 |  |  |  | SAW | 25 | 0.64 | 20 | 0.58 | 35 | 0.38 | 12 | 0.58
 |  |  |  | HAMMER | 30 | 0.5 | 40 | 0.69 | 40 | 0.36 | 16 | 0.54
 |  |  |  | WELD | 32 | 0.4 | 36 | 0.45 | 52 | 0.35 | 20 | 0.21
 |  |  |  | PAINT | 45 | 0.33 | 66 | 0.21 | 80 | 0.39 | 22 | 0.35
 |  |  |  | ASSEMBLE | 18 | 0.2 | 22 | 0 | 50 | 0.44 | 30 | 0.66
Spreadsheet: 03ffe133-18b8-4936-a4e4-67c67cee6429
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 | Key Dates for Odd year Election Calendar |  | DATES
 | Enter Date of Previous November State General Election |  | 2011-11-08 00:00:00
 | Enter Date that Legislative Session Begins |  | 2012-01-24 00:00:00
 | Enter Date of First Monday in January |  | 2012-01-03 00:00:00
 | Enter Date of Township Election (2nd [NAME] in March) |  | 2012-03-13 00:00:00
 | Enter Date of Primary Election (2nd [NAME].) |  | 2012-08-14 00:00:00
 | Enter Date of General Election (1st Tuesday after 1st Monday in Nov.) |  | 2012-11-06 00:00:00
 | Enter Date of Next Years March Township Election |  | 2013-03-12 00:00:00
 | Enter New Years Day |  | 2012-01-02 00:00:00
 | Enter [NAME] |  | 2012-01-16 00:00:00
 | Enter Presidents Day |  | 2012-02-20 00:00:00
 | Enter Memorial Day |  | 2012-05-28 00:00:00
 | Enter Independence Day Holiday |  | 2012-07-04 00:00:00
 | Enter Labor Day |  | 2012-09-03 00:00:00
 | Enter Columbus Day |  | 2012-10-08 00:00:00
 | Enter Veterans' Day |  | 2012-11-12 00:00:00
 | Enter Thanksgiving Day |  | 2012-11-22 00:00:00
 | Enter Christmas Day |  | 2012-12-25 00:00:00
 | Enter First Monday following the 3rd Sat. in May (Leg. Ending Date) |  | 2012-05-21 00:00:00
 | Enter Auditors' Summer Conference Beginning Date
 | Enter Auditors' Summer Conference Ending Date
 | Enter First  Thursday in December (Truth in Taxation) |  | 2012-12-06 00:00:00
 | Enter next years New Year's Day Holiday |  | 2013-01-01 00:00:00
 | Enter next years 1st Monday in January |  | 2013-01-07 00:00:00
 | Enter next years [NAME], Jr. Day |  | 2013-01-21 00:00:00
 | Enter last business day before May 1 |  | 2012-04-30 00:00:00
 | Enter First Monday after the Second Wednesday in December |  | 2012-12-17 00:00:00
 | Enter date of 2010 Precinct Caucuses |  | 2012-02-07 00:00:00
 | [NAME] on next pages will automatically update [NAME] (Even Year)
Spreadsheet: 328581d1403953186-multiple-variables-to-calculate-a-value-pricing_calculator_solution
Sheet: Therm Bifold

[NAME]
Only enter data in the purple boxes
64/90/114 (only off white) | [NAME] | [NAME] | [NAME]
For square [NAME] calculation enter [NAME] and [NAME]
The Price per square metre used in this calculation is $222.00 per Sq Mtr
Include cost of sliding track hardware  Only Two times widths of Tracks.This is calculated at $105.00 per linear metre for internal application.Enter width. |  |  |  | If double tracks are required at the top and bottom then extra costs will apply
Include cost of sliding track hardware .Only Two times widths of Tracks.This is calculated at $195.00 per linear metre for external application Includes stainless steel hinges wheels and carriers.Enter width. |  |  |  | If double tracks are required at the top and bottom then extra costs will apply
Additional Tracks (Price per Track per metre ) top or bottom (Enter additional  width here) |  | 52.5
Additional Fascia (Enter extra width here)
Sliding Side board - included in std pricing
Light Block - included in std pricing
Total cost of goods
This price includes a 55% mark up and now becomes your Retail Price before any freight,installation or GST is included.
5% of total wholesale price $70 minimum (per order)
Installation charges are based on $50.00 per panel.Enter the number of panels being fitted |  | 50
Extra charges. Calculate the retail price for any extra work required  eg Custom painting side boards etc. Then enter the retail price befor GST into the purple box | 1
Sub Total (Add all the figures in the grey boxes)
Add GST to total retail price
Total Retail price
Extra's
Sliding Sideboards and Light block | included
Light block per overlap | included
Stainless steel hinges add | $11.50 per panel
Rebate face reveal or pivot hinges add | $11.50 per panel
Custom Paint and matching | n/a
Spreadsheet: 177739d1346419976-maths-for-a-scoring-system-scoring-system
Sheet: Sheet1

 | 10 | 9 | 4 | 10 | 7 | 10 | 9 |  |  |  |  | 0 | 0
 | 10 | 9 | 4 | 4 | 7 | 10 | 9 |  |  |  |  | 1 | 0.1
 | 1 | 8 | 4 | 4 | 7 | 5 | 9 |  |  |  |  | 2 | 0.2
 |  |  |  |  |  |  |  |  |  |  |  | 3 | 0.3
 | 10.5 | 26 | 12 | 12.6 | 21 | 20 | 27 |  |  |  |  | 4 | 0.4
 |  |  |  |  |  |  |  |  |  |  |  | 5 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  | 6 | 0.6
Spreadsheet: 56618d1256761201-shift-managment-shift-managment
Sheet: Sheet1

 |  | Punch Details
 |  | [NAME] blogs |  |  |  |  | Shifts & shift times
 |  |  |  |  |  |  | Days | Afters | Nights
 |  |  | In | out |  |  | 06:00 - 14:00 | 14:00 - 22:00 | 22:00 - 06:00
 |  | Mon | 05:45:00 | 14:10:00 |  |  | 08:00:00 | 0 | 0
 |  | Tue | 10:00:00 | 18:00:00 |  |  | 04:00:00 | 04:00:00 | 0
 |  | Wed | 21:50:00 | 06:01:00 |  |  | 0 | 0 | 08:00:00
 |  |  |  | Mon
 |  |  |  | [NAME] clocks in at 5:30 and clocks out at 14:10 , because [NAME] doesn’t get paid till 06:00 the 15 mins has to be discarded and
 |  |  |  | only 8hrs are recorded . Also he clocked out at 14:10 but he needs to work past 14:15 to qualify for extra time which would flow into afters
 |  |  |  | Tue
 |  |  |  | [NAME] works a 10:00 - 18:00 shift . 4 hrs are recorded in days and the other 4 in afters. He contributes to both shifts.
 |  |  |  | Wed
 |  |  |  | [NAME] works a night shift he clocks in at 21:50 and clocks out at 06:01 once again he only gets paid for 8 hrs
 |  |  |  | [NAME] has to work a minimum of 15 minutes past the standard shift end time before the next shift starts capturing the excess hrs.
 |  |  |  | like wise if [NAME] clocks in 15 minutes or less before his shift start time these minutes / hrs are not captured.
 |  | My Effort ( incorrect & Incomplete )
 |  |  |  |  |  |  |  |  | DAYS |  |  |  |  |  | Afters |  |  |  |  |  | nights
 |  |  | Day | IN | OUT |  | In Hrs | out hrs | Total | worked | start | Chop | [NAME] | Carried | Total | worked | start | Chop | [NAME] | Carried | Total | worked | start | Chop | [NAME] | Carried
 |  |  | Sat | 05:30:00 | 14:10:00 |  | 5.5 | 14.16666666666667 | 8.666666666666668 | 8 | 6 | 14 | 0.5 | 0.1666666666666679 | 0 | 0.1666666666666679 | 14 | 14.16666666666667 | 8.5 | -8.666666666666668
 |  |  | Sun | 10:00:00 | 18:00:00 |  |  |  | 0
 |  |  | Mon | 21:50:00 | 06:01:00 |  |  |  | 0
Spreadsheet: 543689d1508512039-help-populating-filtering-list-based-on-multi-drop-down-menus-mark-pr-filter-multiple-criteria
Sheet: Employee Leave Tracker

 | Employee Name | Start Date | End Date | Type of Leave | Days
 | [NAME] | 2017-10-02 00:00:00 | 2017-10-04 00:00:00 | Annual leave
 | [NAME] | 2017-09-29 00:00:00 | 2017-09-29 00:00:00 | Sick leave (half day)
 | [NAME] | 2017-01-11 00:00:00 | 2017-01-12 00:00:00 | Unpaid leave
 | [NAME] | 2017-11-14 00:00:00 | 2017-11-14 00:00:00 | Sick leave (half day)
 | [NAME] | 2017-10-11 00:00:00 | 2017-10-11 00:00:00 | Unpaid leave (half day)
 | [NAME] | 2017-11-14 00:00:00 | 2017-11-14 00:00:00 | Annual leave (half day)
 | [NAME] | 2017-05-18 00:00:00 | 2017-05-18 00:00:00 | Annual leave
 | [NAME] | 2018-01-02 00:00:00 | 2018-01-02 00:00:00 | Annual leave
 | [NAME] | 2017-01-15 00:00:00 | 2017-01-15 00:00:00 | Start Date
 | [NAME] | 2017-12-18 00:00:00 | 2017-12-18 00:00:00 | Leave Date
 | [NAME] | 2017-10-19 00:00:00 | 2017-10-19 00:00:00 | Unpaid leave
 | [NAME] | 2017-10-19 00:00:00 | 2017-10-19 00:00:00 | Unpaid leave
 | [NAME] | 2017-01-15 00:00:00 | 2017-01-15 00:00:00 | Annual leave (half day)
Spreadsheet: 113497d1309375587-lookup-function-search-2-columns-pull-date-from-3rd-vlookupexample
Sheet: Table

digital | 2011-01-01 00:00:00 |  | 1
digital | 2011-02-01 00:00:00 |  | 2
magazine | 2011-01-01 00:00:00 |  | 3
magazine | 2011-02-01 00:00:00 |  | 4
magazine | 2011-03-01 00:00:00 |  | 5
Spreadsheet: 761943d1641309021-looking-up-text-in-a-column-and-returning-one-of-3-values-help-needed
Sheet: Sheet1

D or I | ContactType
N/A | operating an international flight |  |  | I
N/A | operating a domestic flight |  |  | D
N/A | jumpseating (domestic) |  |  | N/A
N/A | training |  |  | N/A
N/A | Commercial DH |  |  | N/A
Spreadsheet: 24983d1216054756-im-stuck-call-log-1
Sheet: Sheet1

 |  | Ref | Location | Comments
 |  | 312 | America | Caller comments
 |  | 791 | China | Caller comments
 |  | 33 | Spain | Caller comments
 |  | 312 | London | Caller comments
 |  | 334 | Scotland | Caller comments
 |  | 334 | Scotland | Caller comments
 |  | 334 | China | Caller comments
 |  | 711 | India | Caller comments
 |  | 988 | Wales | Caller comments
 |  | 791 | Ghana | Caller comments
 |  | 33 | Spain | Caller comments
 |  | 711 | India | Caller comments
 |  | 711 | Dubai | Caller comments
 |  | 711 | Dubai | Caller comments
Spreadsheet: 757861d1638473649-remove-cells-with-same-words-but-different-order-test-file2
Sheet: Sheet1

Query
carpet green red
red carpet
green carpet best red
red carpet green
yellow black carpet pink
black green carpet
best green red carpet
best blue floor
Green free carpet
best green carpet red
1 as you can see the three red cells contains the same words but in different order, so does the blue ones.
2. I want only one version of the blue and red to exist in the final product together with the white cells (with black text) that got a unique setup with words.
NOTE: The color doesnt exist in my original file, they are just here in this example to make it easier to show that they contains the same words (but in different order.
So the final product should look like this:
carpet green red
red carpet | carpet red |  | carpet red
green carpet best red | best carpet green red |  | best carpet green red
yellow black carpet pink | black carpet pink yellow |  | black carpet pink yellow
black green carpet | black carpet green |  | black carpet green
best blue floor | best blue floor |  | best blue floor
Green free carpet | carpet free Green |  | carpet free green
Spreadsheet: 0e30daf1-5d56-45c4-aa73-8c45f5a05b6e
Sheet: Budget3 F-K

*ORGANIZATIONAL DUNS:
*Budget Type: |  | Project: |  | Subaward/Consortium:
*Name of Organization:
*Start Date: |  |  | *End Date: |  |  | *Budget Period: | 3
F. Other Direct Costs |  |  |  |  |  |  |  | *Funds Requested ($)
1. | Materials and Supplies |  |  |  |  |  |  | 0
2. | Publication Costs |  |  |  |  |  |  | 0
3. | Consultant Services |  |  |  |  |  |  | 0
4. | ADP/Computer Services |  |  |  |  |  |  | 0
5. | Subawards/Consortium/Contractual Costs |  |  |  |  |  |  | 0
6. | Equipment or Facility Rental/User Fees |  |  |  |  |  |  | 0
7. | Alterations and Renovations |  |  |  |  |  |  | 0
8. |  |  |  |  |  |  |  | 0
9. |  |  |  |  |  |  |  | 0
10. |  |  |  |  |  |  |  | 0
 |  |  |  |  | Total Other Direct Costs
G.  Direct Costs |  |  |  |  |  |  |  | Funds Requested ($)
 |  |  |  |  |  | Total Direct Costs (A thru F)
H. Indirect Costs
 | Indirect Cost Type |  |  |  |  | *Indirect Cost          Rate (%) | *Indirect Cost           Base ($) | *Funds Requested ($)
1. |  |  |  |  |  | 0 | 0
2. |  |  |  |  |  | 0 | 0
3. |  |  |  |  |  | 0 | 0
4. |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | Total Indirect Costs
Cognizant Federal Agency
(Agency Name, POC Name, and POC Phone Number)
I.  Total Direct and Indirect Costs |  |  |  |  |  |  |  | Funds Requested ($)
 |  |  |  | Total Direct and Indirect Institutional Costs (G + H)
[NAME] |  |  |  |  |  |  |  | Funds Requested ($)
 |  |  |  |  |  |  |  | 0
K.  *Budget Justification |  |  | (Only attach one file)
 | * Required Field
Spreadsheet: 83757d1283797021-calculating-wire-length-yield-cutting_wire
Sheet: Sheet1

 |  |  | To run Solver (Excel 2007) Data-> Solver -> Solve
 |  |  | To solve a new problem change numbers in "Demand" (F34 to K34). Before a new run, clear range O12 to O29.
 |  |  |  |  | wire | wire | wire | wire | wire | wire | wire | cost | cost | used | Total wire | Wire
 |  |  |  | Lenght | 800 | 386 | 300 | 250 | 120 | 8 | used | used wire | left wire | cut | used | left
 |  |  | Roll 1 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  | Roll no 1
 |  |  | Roll 2 | 600 |  |  |  |  |  |  |  |  |  |  |  |  | Roll no 2
 |  |  | Roll 3 | 450 |  |  |  |  |  |  |  |  |  |  |  |  | Roll no 3
 |  |  | Roll 4 | 150 |  |  |  |  |  |  |  |  |  |  |  |  | Roll no 4
 |  |  |  | Produced
 |  |  |  | Demand | 0 | 1 | 1 | 1 | 1 | 17
 |  |  |  |  |  |  |  |  |  |  |  | Tot costs
Spreadsheet: 765910d1643662790-pay-off-balance-using-two-sources-sample
Sheet: Sheet1

LP Total Contributions | Priority Return % |  | Pro Forma Distribution |  | Distribution Growth Rate |  | Refi Year | 10 |  | Salel Price |  |  | Year | 21
14005000 | 0.06 |  | 1200000 |  | 0 |  | [NAME] | 0.05 |  | Sale Price Year | 21 |  | NOI | 4000000
 |  |  |  |  |  |  | [NAME] | 25000000 |  | Disposition Fee | 0.015
Purchase Price |  |  |  |  |  |  | [NAME] | 60000000 |  | Closing Costs | 0.04
 |  |  |  |  |  |  | [NAME] |  |  | Exit Cap Rate | 0.04
Loan Balance |  |  |  |  |  |  | [NAME]
10000000
Prepayment Fees
0.01 |  |  | Year | Year | Year | Year | Year | Year | Year | Year | Year | Year | Year | Year | Year | Year | Year | Year | Year | Year | Year | Year | Year | Year
Partnership Finance Fee |  |  | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
0.005 |  |  | 2013-06-24 00:00:00 | 2014-06-24 00:00:00 | 2015-06-24 00:00:00 | 2016-06-24 00:00:00 | 2017-06-24 00:00:00 | 2018-06-24 00:00:00 | 2019-06-24 00:00:00 | 2020-06-24 00:00:00 | 2021-06-24 00:00:00 | 2022-06-24 00:00:00 | 2023-06-24 00:00:00 | 2024-06-24 00:00:00 | 2025-06-24 00:00:00 | 2026-06-24 00:00:00 | 2027-06-24 00:00:00 | 2028-06-24 00:00:00 | 2029-06-24 00:00:00 | 2030-06-24 00:00:00 | 2031-06-24 00:00:00 | 2032-06-24 00:00:00 | 2033-06-24 00:00:00 | 2034-06-24 00:00:00
 |  | Distributions
 |  |  |  |  |  |  |  |  |  |  |  |  | Pro Forma
 |  | Operating Income
 |  | Actual Priority Returns |  |  | 500000 | 1200000 | 600002 | 500003 | 300002 | 119998 | 900000 | 600000
 |  | Priority Return Amount
 |  | Priority Return Balance
 | 0.14 | x
 | 0.15 | y
 | 0.7 | z
**^^
 |  | Sale & Refinance
 |  |  |  |  |  |  |  |  |  |  |  |  | Pro Forma
 |  | Sale Price
 |  | Existing Loan Principal
 |  | New Loan Principal
 |  | Prepay Fees
 |  | Partnership Financing Fees
 |  | Disposition Fees
 |  | Other Fees
 |  | Cash Available for Distribution
 |  | Cash Available for Contribution Return
 |  | Prirority Retuns from Refi
 |  | [NAME]
split
 |  | Cash Flow Returns
 |  |  |  |  |  |  |  |  |  |  |  |  | Pro Forma
 |  | Cash on Cash Multiple
 |  | Cumulative Distributions
 |  | LP Account Balance
 |  | Equity Multiple
 |  | Returns from [NAME] or Sale
 |  | Annual Returns
 |  | IRR
 |  | NPV
 |  | [NAME]
refi or sale event for capital returned |  | look at COC after split
Spreadsheet: 0e7d184a-6183-400d-b1df-a12dd5a5fc06
Sheet: OA CWW BUGET

OA CEREMONIAL/WORK WEEKEND BUDGET PLANNER AND CONTROL SHEET
 | Activity Title: |  |  |  |  | Chapter/Lodge:
 | Dates of Activity: |  |  |  |  | Staff Advisor:
 | Location: |  |  |  |  | Chairperson:
 | Submitted By: |  |  |  |  | Date Submitted:
 | Cost Center: | 1-2371- |  | -00
Acc # | ESTIMATED REVENUE |  |  | BUDGET |  | ACTUAL REVENUE |  |  | ACTUAL
Participant Fees |  | Estimated # | Fee |  |  | Explanations | Actual # | Fee
Ordeal Candidates
Brotherhood Candidates
[NAME]
General [NAME] (Current Members)
Total Participant Fees
Other Income (enter description below / do not include trading post)
 |  |  |  | 0 |  |  |  |  | 0
 |  |  |  | 0 |  |  |  |  | 0
Total Other Income
 | TOTAL ESTIMATED REVENUE |  |  |  |  | TOTAL ACTUAL REVENUE
ESTIMATED EXPENSES |  |  |  |  |  | ACTUAL EXPENSES
Explanations |  |  |  |  |  | Explanations
 | Program Supplies |  |  | 0 |  |  |  |  | 0
 | Service Project Materials |  |  | 0 |  |  |  |  | 0
 | Food & Commissary Supplies |  |  | 0 |  |  |  |  | 0
 | Ordeal Cannidate Meals |  |  | 0 |  |  |  |  | 0
 | Sanitation Supplies |  |  | 0 |  |  |  |  | 0
 | Expendable Equipment |  |  | 0 |  |  |  |  | 0
 | Telephone |  |  | 0 |  |  |  |  | 0
 | Equipment Rental |  |  | 0 |  |  |  |  | 0
 | Printing/Postage |  |  | 0 |  |  |  |  | 0
 | Youth Recognition |  |  | 0 |  |  |  |  | 0
 | [NAME] |  |  | 0 |  |  |  |  | 0
 | Other Recognition |  |  | 0 |  |  |  |  | 0
 | Cannidate Recognition - Sashes/Books/Flaps |  |  |  |  | Sashes/Books/Flaps
 | Liability Insurance Fee ($1.00 per person) |  |  |  |  | Liability Insurance Fee ($1.00 per person)
 | Facility Rental Fee (including council camp rentals) |  |  | 0 |  |  |  |  | 0
Expense contingency (10% of expenses not including liability ins. fee)
 | TOTAL ESTIMATED EXPENSES |  |  |  |  | TOTAL ACTUAL REVENUE
 | NET Difference + OR (-) |  |  |  |  | ACTUAL NET Difference + OR (-)
Lodge Advisor _______________________  ____/____ /____     Staff Advisor ______________________  ____ /____ /____
Lodge Acct#'s 995 Operating,   996 Lodge Activities,  997 Ceremonial/Service Weekends,  998 [NAME],  999 Section & National Activities
 | Considerations: Ordeal Packets =$20 / Meals Roughly $3 to $5 Per Person Per Meal
Spreadsheet: 483894d1475923351-how-to-connect-to-value-to-any-cell-in-excel-xirr-and-npv
Sheet: Sheet1

 |  |  |  |  |  |  |  | 1 |  |  |  | 2 |  | 2.5
 |  |  | Timelines | 2017-03-31 00:00:00
 |  |  | Project
 |  |  | Project 1 |  |  |  |  |  |  |  |  | 3.5 | 3.5 | 5
 |  |  | xirr