tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 761931d1641306520-looking-to-activate-a-formula-only-after-another-action-is-taken-c-town-rose-random-4s-or-6s-vball-tournament
Sheet: Upper Schedule

UPPER NET
Schedule & Standings
Team Name |  |  |  |  |  |  |  |  |  |  |  | Final Standings
ROUND 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Points |  |  |  |  |  |  |  |  |  | 4s or 6s Scheduling Format |  |  |  |  |  | Match Winner
Home | Away |  |  |  |  |  |  |  |  |  | GP | W | L | Scored | Against | Differential | Points | PTS Rank | Diff Rank | Scored Rank | Total Rank | Rank |  | 4s |  |  | 6s
 |  | 11 | : | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Team 4 | Team 2 |  | Team 2 | Team 1
 |  | 9 | : | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Team 3 | Team 1 |  | Team 4 | Team 5
 |  | 11 | : | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Team 1 | Team 2 |  | Team 3 | Team 6
 |  | 11 | : | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Team 4 | Team 3 |  | Team 2 | Team 5
 |  | 11 | : | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Team 3 | Team 2 |  | Team 3 | Team 4
 |  | 11 | : | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Team 1 | Team 4 |  | Team 6 | Team 1
 |  | 7 | : | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Team 2 | Team 3
 |  | 6 | : | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Team 1 | Team 5
 |  | 5 | : | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Team 6 | Team 4
 |  | 11 | : | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Team 5 | Team 3
 |  | 11 | : | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Team 4 | Team 1
 |  | 5 | : | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Team 6 | Team 2
 |  | 9 | : | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Team 1 | Team 3
 |  | 11 | : | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Team 5 | Team 6
 |  | 11 | : | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Team 4 | Team 2
ROUND 2
Home | Away
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
ROUND 3
Home | Away
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
Spreadsheet: 85722d1285771777-excel-2007-excel-2007-problem-with-cell-formulas-cash20102011
Sheet: Income

Date | Description | Ref |  | Nat West | CFB | TMCP |  | Cash | Envelopes | S'ship | Other | Tax | Donat's | M&P | Int.TMCP | Int.CFB | Sundry | Legacies | [NAME] | Proj | Benevol | JMA | [NAME] | [NAME] | Contra
2009-09-30 00:00:00 | Standing 0rders
2010-09-30 00:00:00
2009-10-31 00:00:00 | Standing orders
2010-10-31 00:00:00
2010-11-30 00:00:00 | Standing orders
2009-11-30 00:00:00
2010-12-31 00:00:00 | Standing orders
2009-12-31 00:00:00
 | Standing Orders
2009-01-31 00:00:00
 | Standing Orders
2009-02-28 00:00:00
 | Standing Orders
2009-03-31 00:00:00
 | Standing Orders
2009-04-30 00:00:00
 | Standing Orders
2009-05-31 00:00:00
 | Standing Orders
2009-06-30 00:00:00
 | Standing Orders
2009-07-31 00:00:00
 | Standing Orders
2009-08-31 00:00:00
2007-08-31 00:00:00
Spreadsheet: 790022d1659509137-distribute-the-amount-based-on-day-difference-if-date-condition-met-true-amount-distributor
Sheet: Sheet1

Recovery Period From | 2020-10-17 00:00:00 | To | 2021-04-25 00:00:00
Exemption Period From | 2021-06-22 00:00:00 | To | 2021-10-01 00:00:00 |  | R
 |  |  |  |  |  |  | No Helper
Amount | Recovery | Exemption | Date |  |  |  | Recovery | Exemption | Day Diff. of Dates | Day of Recovery | Days of Exemption
430 |  |  | 2020-09-19 00:00:00
528.08 |  |  | 2020-10-13 00:00:00
1252.08 |  |  | 2020-11-20 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-10-17 00:00:00 | 2021-10-18 00:00:00 | 2021-10-19 00:00:00 | 2021-10-20 00:00:00
864.08 |  |  | 2020-12-14 00:00:00
854.09 |  |  | 2021-01-09 00:00:00
995.07 |  |  | 2021-02-12 00:00:00
628.11 |  |  | 2021-03-02 00:00:00
686.83 |  |  | 2021-03-27 00:00:00
791.2 |  |  | 2021-04-26 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-04-25 00:00:00
718.04 |  |  | 2021-05-25 00:00:00
727 |  |  | 2021-06-25 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-06-22 00:00:00 | 2021-06-23 00:00:00 | 2021-06-24 00:00:00 | 2021-06-25 00:00:00
5812.24 |  |  | 2021-07-24 00:00:00
7404.36 |  |  | 2021-08-26 00:00:00
6131.32 |  |  | 2021-09-27 00:00:00
5814.71 |  |  | 2021-10-30 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-09-28 00:00:00 | 2021-09-29 00:00:00 | 2021-09-30 00:00:00 | 2021-10-01 00:00:00
4130.82 |  |  | 2021-12-01 00:00:00
 | >> Figures shown in Green Cells (Cell B5:C20) I want generate using formula. |  |  |  |  |  |  |  | >> Calculation show in yellow cells (F4:M20) are only for your understanding and explain my point of view.
Spreadsheet: 12e01eaa-c177-4460-9a63-de242c5fc5ce
Sheet: Sheet1

Table 12--Annual U.S. cotton textile exports, by destination | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Region/country | 2007 | 2008 | 2009 | 2010 | 2011
 | 1,000 pounds 1/
North America | 1722353.799 | 1680984.744 | 1356760.22 | 1605765.112 | 1645964.399
Canada | 151470.477 | 135091.202 | 112927.664 | 111075.831 | 114771.456
Costa Rica | 34555.852 | 10261.535 | 4659.379 | 4631.498 | 3479.647
Dominican Republic | 218110.865 | 216934.536 | 209897.849 | 248181.361 | 332771.895
El Salvador | 154701.042 | 168581.227 | 114885.348 | 95127.771 | 137745.781
Guatemala | 68627.828 | 50017.872 | 42117.305 | 42866.667 | 34958.852
Haiti | 8148.411 | 8181.539 | 6739.748 | 8041.991 | 7242.092
Honduras | 640153.764 | 688713.629 | 510184.446 | 732140.939 | 670135.044
Jamaica | 4706.442 | 1278 | 1074 | 1314.743 | 1233
Mexico | 417731.238 | 374170.879 | 330032.585 | 331749.972 | 315928.094
Nicaragua | 14072.821 | 19784.725 | 16774.553 | 22671.468 | 18866
Panama | 1742 | 1804 | 1777 | 2240.42 | 4015.862
South America | 54118.541 | 37779.081 | 32446.212 | 33038.095 | 31489.891
Brazil | 8506.765 | 6074.064 | 5329.158 | 5932.926 | 8309.566
Chile | 2418.043 | 2396.491 | 2589.35 | 5514.507 | 2666.824
Colombia | 26665.396 | 14086.02 | 9865.699 | 7198.378 | 8303.47
Peru | 3216.824 | 2395.259 | 2950.509 | 4949.399 | 2944.434
Venezuela | 10504.417 | 9721.025 | 7895.179 | 5712.718 | 6168.505
Europe | 44141.118 | 46183.073 | 40068.13 | 41538.81 | 41015.211
Belgium | 6899.725 | 6235.693 | 4068.797 | 4776.39 | 4658.542
Germany | 6586.951 | 7464.803 | 7193.362 | 6360.763 | 7190.771
Italy | 2145 | 2532 | 2181 | 2016.708 | 2272.033
Netherlands | 4235.84 | 5481.974 | 4956.585 | 5421.656 | 4661.768
United Kingdom | 11973.493 | 12625.581 | 10602.711 | 11899.586 | 11748.676
Asia | 62280.243 | 64939.848 | 57521.603 | 87558.621 | 100804.773
China | 10559.884 | 12819.368 | 14821.219 | 39351.147 | 53300.864
Hong Kong | 5877.131 | 6114.314 | 4840.76 | 5569.061 | 5656.396
India | 3537.598 | 2306.6 | 2902.427 | 4141.143 | 3823.53
Israel | 2747.841 | 1730 | 2475.806 | 2022.039 | 2460.609
Japan | 12330.742 | 11739.166 | 9310.379 | 9893.36 | 10442.194
Singapore | 3305.028 | 3095.879 | 2286.379 | 2886.313 | 2373.468
South Korea | 6915.535 | 6992.407 | 6748.126 | 10451.588 | 7016.23
United Arab Emirates | 2724.848 | 3420.036 | 3352.943 | 2812.137 | 3025.448
Oceania | 5784.527 | 7148.943 | 7194.512 | 7100.352 | 9581.138
Australia | 4352.1 | 5545.952 | 5629.003 | 5288.074 | 7713.051
World 2/ | 1893477.515 | 1843718.99 | 1498247.41 | 1779107.942 | 1837476.287
1/ Raw-fiber equivalent.  2/ Totals may not add due to rounding.
Last update: 03/12/12.
Sources: USDA, Economic Research Service; and USDC,
U.S. Census Bureau.
Spreadsheet: 106892d1304028981-excel-2007-conditional-formatting-cells-that-contain-formulas-not-working-as-intended-tracker-test
Sheet: Active

Acct # | Customer Name | Open Date | Notice Date | Follow Up Date | Days Open | Notice Expiration Date | Next Follow Up Date | Days FU Past Due
12345 | jane doe | 2011-02-24 00:00:00 | 2011-03-10 00:00:00 | 2011-04-16 00:00:00
6789 | [NAME] doe | 2011-04-15 00:00:00 |  | 2011-04-22 00:00:00
Spreadsheet: 867567d1714401882-even-team-distribution-for-draft-team-example
Sheet: Sheet1

Team | Under Class | Upper Class | Total | [NAME] Under Class | Draft Upper Class | Total Draft | # Needed to [NAME] Under Class | # Needed to Draft Upper Class
A | 3 | 6 | 9 | 17 | 13 | 30
B | 3 | 11 | 14
C | 4 | 10 | 14
Spreadsheet: 4e6e1762-a0ac-4770-9e17-dc772f8b9229
Sheet: Sheet1

site_name
Albuquerque
Anchorage
Atlanta
Baltimore
Birmingham
Boston
Buffalo
Caribbean
Charleston
Chicago
Cincinnati
Cleveland
Columbia
Columbus
Coral Gables
Denver
Des Moines
Detroit
Fort Worth
Grand Rapids
Greensboro
Hartford
Headquarters - PPSD
Honolulu
Houston
Indianapolis
[NAME]
Jacksonville
Kansas City
Knoxville
Las Vegas
Little Rock
Los Angeles
Louisville
[NAME]
Milwaukee
Minneapolis
Nashville
New Orleans
New York
Newark
Oklahoma City
Omaha
Philadelphia
Phoenix
Pittsburgh
Portland
Providence
Richmond
Sacramento
San Antonio
San Diego
San Francisco
Seattle
Shreveport
Spokane
St. Louis
Tulsa
Washington, DC
Spreadsheet: 119025d1314141074-extract-last-word-from-a-cell-to-another-cell-seimens_site_for_forum
Sheet: Values

Contract Description |  |  | Coverage Hours |  |  | Coverage Type
7 X 24 Turnkey Vendor Maintenance Services |  |  | Basic - 8X5 |  |  | Core Processor/ CPU Only
7 X 24 Turnkey Vendor Maintenance Services with SSS |  |  | Complete - 7X24 |  |  | Equipment Only
7 X 24 Vendor Backed Maintenance Services |  |  |  |  |  | Full Maintenance
7 X 24 Vendor Backed Maintenance Services with SSS |  |  |  |  |  | Monitoring - Core Processor/ CPU Only
8 X 5 Turnkey Vendor Maintenance Services |  |  |  |  |  | Monitoring - Equipment
8 X 5 Turnkey Vendor Maintenance Services with SSS |  |  |  |  |  | Monitoring - Full Maintenance
8 X 5 Vendor Backed Maintenance Services |  |  |  |  |  | Monitoring - Switch Only
8 X 5 Vendor Backed Maintenance Services with SSS |  |  |  |  |  | Switch Only
Essential Hardware Maint 7 X 24 including Terminals
Essential Hardware Maint 7 X 24 no Terminal Coverage
Essential Hardware Maint 7 X 24 (no hardware covered)
Fault Monitoring Services
Software Subscription Option
Software Subscription Services (SSS)
Uknown/Other
Wireless Hand Coverage, Vendor Backed
Wireless Hand Coverage, Vendor Turnkey
Spreadsheet: 755096d1636654857-conditional-formatting-with-color-coding-is-not-working-color-matching-for-numbers
Sheet: Color Matching

Working Scenario
Set1
78 | 74 | 97 | 37 | 74 | 81
43 | 31 | 99 | 79 | 73 | 09 |  |  | 99 | 9+3=12 | 3 | 38
06 | 99 | 33 | 27 | 63 | 09 |  |  | 27 | 9+8=17 | 8
09 | 94 | 84 | 91 | 85 | 62
39 | 19 | 07 | 01 | 60 | 49
62 | 02 | 68 | 06 | 07 | 06
35 | 60 | 98 | 74 | 23 | 62
62 | 87 | 04 | 34 | 58 | 90
66 | 32 | 86 | 21 | 14 | 82 |  | 66 | 6+6=12 | 6 | 62
28 | 34 | 34 | 32 | 17 | 09 |  | 28 | 6+2=08 | 2
Set2
89 | 00 | 66 | 08 | 22 | 29
66 | 25 | 66 | 26 | 14 | 33 |  |  | 66 | 6+3=09 | 3 | 38
80 | 07 | 54 | 94 | 60 | 18 |  |  | 94 | 6+8=14 | 8
83 | 15 | 07 | 24 | 45 | 23
59 | 64 | 15 | 91 | 92 | 18
35 | 14 | 27 | 92 | 76 | 64
30 | 85 | 10 | 73 | 55 | 87
82 | 58 | 18 | 57 | 51 | 94
80 | 99 | 76 | 22 | 18 | 30 |  | 80 | 8+6=14 | 6 | 62
42 |  |  |  |  |  |  | 42 | 0+2=02 | 2
 | Working Formula
 | "=MOD((IF(LEFT(A16,1)>=LEFT(A3,1),LEFT(A16,1)-LEFT(A3,1),LEFT(A16,1)+10-LEFT(A3,1))&(IF(RIGHT(A16,1)>=RIGHT(A3,1),RIGHT(A16,1)-RIGHT(A3,1),RIGHT(A16,1)+10-RIGHT(A3,1))))),100)=99"
Non-Working Scenario
Set 1
87 | 47 | 79 | 73 | 47 | 18
34 | 13 | 99 | 97 | 37 | 90
60 | 99 | 33 | 72 | 36 | 90
90 | 94 | 48 | 19 | 58 | 26 |  |  |  |  | 94 | 4+6=10 | 6
93 | 91 | 70 | 10 | 06 | 94 |  | eg 2
26 | 20 | 86 | 60 | 70 | 60 |  |  |  |  | 02 | 9+3=12 | 3
53 | 06 | 89 | 47 | 32 | 26 |  | 74 | 4+4=08 | 4
26 | 78 | 40 | 43 | 85 | 09 | eg 1
67 | 23 | 68 | 12 | 41 | 28 |  | 86 | 7+9=16 | 9
82 | 43 | 43 | 23 | 71 | 90
Set 2
89 | 00 | 66 | 08 | 22 | 29
66 | 25 | 66 | 26 | 14 | 33
80 | 07 | 54 | 94 | 60 | 18
83 | 15 | 07 | 24 | 45 | 23 |  |  |  |  | 15 | 5+6=11 | 6
59 | 64 | 15 | 91 | 92 | 18 |  | eg 2
35 | 14 | 27 | 92 | 76 | 64 |  |  |  |  | 14 | 1+3=04 | 3
30 | 85 | 10 | 73 | 55 | 87 |  | 73 | 3+4=07 | 4
82 | 58 | 18 | 57 | 51 | 94 | eg 1
90 | 99 | 76 | 22 | 18 | 30 |  | 76 | 7+9=16 | 9
42
 |  | Issue
 |  | > The similar formula is working for Scenario 1 and it is not working for Scenario 2
 |  | > The formula is just comparing the cells across the sets and not within the set
 |  | Requirement:
 |  | > The formuala or script should identify the pair of numbers with same output within the set and outside the set as in above examples
 |  | > The currently known formula is as below
 |  |  |  | "=MOD((IF(LEFT(A49,1)>=RIGHT(A36,1),LEFT(A49,1)-RIGHT(A36,1),LEFT(A49,1)+10[NAME])))))
 |  | > The matching cells should be highlighted with same color
Spreadsheet: 733791d1621822580-rental-calculation-for-a-list-of-shops-rental-question_revised_rent-free-issue
Sheet: Rent Roll 

A. Monthly Rental |  |  |  |  |  |  |  | Rent Free
Floor | Shop | Tenant | Area |  | Start | End | Rental | Start | End | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00
B2 | 1 | ABC | 1216 | Period 1 | 2020-12-16 00:00:00 | 2021-01-15 00:00:00 | 100 | 2020-12-16 00:00:00 | 2021-01-15 00:00:00
 |  |  |  | Period 2 | 2021-01-16 00:00:00 | 2022-12-15 00:00:00 | 150
B2 | 2 | DEF | 450 | Period 1 | 2018-07-20 00:00:00 | 2019-07-19 00:00:00 | 2000 | 2018-07-20 00:00:00 | 2018-09-19 00:00:00
 |  |  |  | Period 2 | 2019-07-20 00:00:00 | 2020-07-19 00:00:00 | 3000
 |  |  |  | Period 3 | 2020-07-20 00:00:00 | 2021-07-19 00:00:00 | 4000 | 2021-03-01 00:00:00 | 2021-03-31 00:00:00
 |  |  |  | Period 4 | 2021-07-20 00:00:00 | 2022-07-19 00:00:00 | 5000
Spreadsheet: 40065d1238398084-running-totals-in-column-utility-billing
Sheet: GAS

Imperial to Metric Conversion Factor |  |  | 2.83 |  |  |  | Billing |  |  |  | Monthly Readings
Correction Factor |  |  | 1.02264 |  |  |  | Date | Usage | Total |  | Date | Reading | Usage
Calorific Value |  |  | 40 |  |  |  |  |  |  |  | 2009-02-27 00:00:00 | 627
kWh Conversion Factor |  |  | 3.6 |  |  |  |  |  |  |  | 2009-03-30 00:00:00
Tariff Costs
Standard Energy |  | 0.0437
Discounted Energy |  | 0.033
Direct Debit Discount |  | 0.06
VAT |  | 0.05
 |  | Last Reading | This Reading | Units
Date | 2009-02-27 00:00:00 | 302 | 627
 |  | Total Metric Units Used |  |  | m3
 |  | Total kWh |  |  | kWh
 |  |  | Units | Cost
Standard Energy |  |  | 1143
Discounted Energy
Monthly DD Discount
Sub Total
VAT
Total
Spreadsheet: 688778d1595952607-using-data-validation-to-link-data-to-different-locations-excel-help-2-bebo-
Sheet: Financing Structure & Fees Ass.

Financing Structure
 | Structure
Sources of Funds | Structure 1 | Structure 2 | Structure 3 | Structure 4 | Status Quo
Revolving Credit Facility Size | 250 | 250 | 250 | 250
Revolving Credit Facility Draw
Term Loan A |  | 500
Term Loan B | 2150 | 1650 | 2100 | 1750
Term Loan C
2nd [NAME]
Senior Notes | 1500 | 1500 | 700 | 1000
Senior Suboridinate Notes |  |  | 700 | 1000
Senior Bridge Facility
Senior Subordinate Bridge Facility
Equity Contribution | 2100 | 2100 | 2250 | 2250
Rollover Equity
Cash and Cash Equivalents | 250 | 250 | 250
Total Sources of Funds
Uses of Funds
Equity Purchase Price | 4350 | 4350 | 4350 | 4350 | 4350
Existing Bank Debt | 1000 | 1000 | 1000 | 1000 | 1000
Existing Bond Debt | 500 | 500 | 500 | 500 | 500
Existing Mezzanine Debt | 0 | 0 | 0 | 0 | 0
Tender / Call Premiums | 20 | 20 | 20 | 20 | 20
Deferred Financing Fees | 90 | 90 | 90 | 90 | 90
Other Fees and Expenses | 40 | 40 | 40 | 40 | 40
Total Use of Funds
Financing Fees
 |  | Fees
 | Structure 1 | Size | (%) | ($)
Revolving Credit Facility Size |  |  | 0.015
Term Loan A |  |  | 0.015
Term Loan B |  |  | 0.015
Term Loan C |  |  | 0.015
2nd [NAME] |  |  | 0.0225
Senior Notes |  |  | 0.0225
Senior Suboridinate Notes |  |  | 0.0225
Senior Bridge Facility |  | 1500 | 0.01
Senior Subordinate Bridge Facility |  | 0 | 0.01
Other Financing Fees & Expense |  |  |  | 5.3
Total Financing Fees
Amortization of Financing Fees
 | Term | Year 1 2013 | Year 2 2014 | Year 3 2015 | Year 4  2016 | Year 5 2017 | Year 6  2018 | Year 7  2019 | Year 8 2020 | Year 9  2021 | Year 10 2022
Revolving Credit Facility Size | 6
Term Loan A
Term Loan B | 7
Term Loan C
2nd [NAME]
Senior Notes | 8
Senior Suboridinate Notes
Senior Bridge Facility | 8
Senior Subordinate Bridge Facility
Other Financing Fees & Expense | 8
Annual Amortization
Spreadsheet: 731384d1620315252-collate-data-from-different-worksheets-sample-workbook_1
Sheet: B

Category | Activity Name | AU | Trainee | India TM | Trainer | Training Date | Time Spent | Training Time | Due Date
Recon | SIR | 120 | abc | def | afasf | 2021-04-30 00:00:00 | 1 | 04:30 PM - 05:30 PM | 2021-05-01 00:00:00
Other | OCQ | 120 | abc | def | afasf | 2021-04-30 00:00:00 | 1 | 04:30 PM - 05:30 PM | 2021-05-01 00:00:00
Spreadsheet: 98054d1297137498-lookup-formula-sample
Sheet: MASTER

Customer | PART NO. | PART NAME | PART G/W
AGRI (IMV-1) | 90389-T0001 | [NAME],Shock [NAME] | 0.128357142857143
AGRI (IMV-1) | A0181-01203 | Packing Case | 0.02448
AGRI (IMV-1) | A0201-02614 | End Bolt | 0.06179
AGRI (IMV-1) | A0201-03986 | Spring Guide | 0.4266666666666666
AGRI (IMV-1) | A0201-05927 | Bracket | 0.01698
AGRI (IMV-1) | A0202-59009 | [NAME] (RH) | 0.06052
AGRI (IMV-1) | A0202-59010 | [NAME] (LH) | 0.06072
AGRI (IMV-1) | A0181-01315 | Seal Oil | 0.006650000000000001
AGRI | 90389-T0001 | [NAME],Shock [NAME] | 0.2
AGRI | A0181-01203 | Packing Case | 0.06
AGRI | A0201-02614 | End Bolt | 0.05
AGRI | A0201-03986 | Spring Guide | 0.008
AGRI | A0201-05927 | Bracket | 0.07
AGRI | A0202-59009 | [NAME] (RH) | 0.01
AGRI | A0202-59010 | [NAME] (LH) | 0.008
AGRI | A0181-01315 | Seal Oil | 0.437
Spreadsheet: 813673d1673917017-aggregate-values-to-a-table-from-a-data-set-with-a-specific-value-aggregate
Sheet: Open Tickets

These results return all ticket records in my dataset |  |  |  |  | What I want to return is only those ticket records marked as open
Open Ticket # |  |  |  |  | Open Ticket #
 |  |  |  |  | INC2064351
 |  |  |  |  | INC2071335 |  | INC2071335
 |  |  |  |  | [NAME] |  | [NAME]
 |  |  |  |  | INC2042424 |  | INC2042424
 |  |  |  |  | INC2043839 |  | INC2043839
 |  |  |  |  | REQ3051041 |  | REQ3051041
 |  |  |  |  | REQ3074099 |  | REQ3074099
 |  |  |  |  | REQ3076895 |  | REQ3076895
Spreadsheet: 831059d1685378985-trying-to-fill-dates-with-formula-andre-test-2-ans
Sheet: Sheet1

Date | Name | Ticket # | Shift | Manager
2023-05-21 00:00:00 |  |  |  |  |  | Headings in both the shheets should exactly match.
 |  |  |  |  |  | In Column C Formula is given. You cannot have formula and validation.
 |  |  |  |  |  | For Sick leave how to mark?
Spreadsheet: 214813d1361133055-sum-level-at-each-change-in-level-book1
Sheet: Sheet2

Level 1
Level 2 |  |  | 2
Level 2 |  |  | 3
Level 2 |  |  | 4
Level 2 |  |  | 5
Level 1
Level 2 |  |  | 7
Level 2 |  |  | 8
Level 1
Level 2 |  |  | 10
Level 2 |  |  | 11
Level 2 |  |  | 12
Level 2 |  |  | 13
Level 2 |  |  | 14
Level 2 | 23
Spreadsheet: 835635d1688692069-calculate-averages-conditional-upon-a-series-of-zero-values-bwl-condtnl-avg-example
Sheet: Sheet1

Runs | Wkts | [NAME] | [NAME] | Avg |  | Final Output
56 | 1
35 | 0
16 | 0
74 | 2
97 | 1
105 | 3
1 | 0
47 | 0
51 | 0
56 | 1
Spreadsheet: 272621d1382447511-formula-to-calculate-change-of-a-value-across-two-tables-tracker1
Sheet: % Change

Programs | Subject1 | Subject2 | Subject3 | Subject4 | Subject5 | Totals
101 | -0.75
102
103
104
105
106
107
107B
108
109
110
111
Spreadsheet: 703882d1605206233-if-isnumber-search-and-or-with-extra-criteria-erf-log-projects
Sheet: PWPS

ERF# | Site [NAME] | Start Date | Rate | Hours  (Base) | Cost (Base) | Status | PO# | Order
Spreadsheet: 117496d1312829756-excel-2007-convert-sales-into-a-currency-corresponding-from-a-drop-down-test-drop-down-currency
Sheet: Sheet1

Display currency: |  | EUR | 1
 |  | USD | 0.7
 |  | CAD | 0.9889
 |  | [NAME] | 12.1409
Product | Number | Currency | Ex-change rate | Price | Qty | Sales
Lamp | 111 | USD | 1.3247 | 20 | 10
Bulb | 222 | EUR | 1 | 3 | 20
Shelve | 333 | USD | 1.3247 | 50 | 10
Spreadsheet: darrell_schoolcraft__7633__NNG LAMAR NOMNATION
Sheet: 01-(12-14)

 |  |  |  | Time/Date
 |  |  |  | Beginning Gas Day: | 2002-01-12 00:00:00
 |  |  |  | Ending Gas Day: | 2002-01-14 00:00:00
 |  | [NAME] |  |  | 15000
 |  | Hour
 |  | Ending | [NAME] | Accumulated | Remaining | Daily Burn
 |  | CST |  |  |  | Rate
 |  | 10 | 1300
 |  |  | 1300
 |  |  | 1300
 |  |  | 1300
 |  |  | 1300
 |  |  | 1300
 |  |  | 1300
 |  |  | 1300
 |  |  | 1300
 |  |  | 1300
 |  |  | 1300
 |  |  | 700
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  | 1 | 0
 |  | 2 | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
Spreadsheet: 586777d1534612721-if-h4-error-value-than-j4-shows-0-but-if-h4-3-or-any-number-than-j4-3-or-the-number-attach
Sheet: Sheet1

 |  |  |  |  |  |  |  | [NAME] |  | Data |  | Result
 |  |  |  |  |  |  |  | 10pág , 114-123
 |  |  |  |  |  |  |  | 11pág , 127-137 |  |  |  | 11
 |  |  |  |  |  |  |  | 9pág , 138-146 |  |  |  | 9
 |  |  |  |  |  |  |  | 6pág , 147-153 |  |  |  | 6
 |  |  |  |  |  |  |  | 6pág, 154-159 |  |  |  | 6
 |  |  |  |  |  |  |  | 8pág, 17-24 |  |  |  | 8
 |  |  |  |  |  |  |  | 5pág. 25-29 |  |  |  | 5
 |  |  |  |  |  |  |  | 20pág,30-50 |  |  |  | 20
 |  |  |  |  |  |  |  | 21pág,51-72 |  |  |  | 21
 |  |  |  |  |  |  |  | 20pág,73-92 |  |  |  | 20
 |  |  |  |  |  |  |  | 20pág, 93-104 |  |  |  | 20
 |  |  |  |  |  |  |  | 19pág , 105-123 |  |  |  | 19
 |  |  |  |  |  |  |  | 5pág ,124-127 |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 186311d1349981262-determining-if-a-value-is-within-a-range-when-there-are-gaps-overlaps-sample-data-for-analysis
Sheet: Turn Taking

 | Beginning of Turn | End of Turn | Speaker
 | 19286 | 19344 | E
 | 19378 | 19472 | C
 | 19400 | 19468 | E
 | 19489 | 19826 | C
 | 19784 | 19899 | E
 | 19926 | 20032 | C
 | 20056 | 20359 | E
 | 20287 | 20347 | C
 | 20363 | 20385 | E
 | 20385 | 20883 | C
 | 20919 | 20967 | E
 | 20985 | 21477 | C
 | 21456 | 21626 | E
 | 21658 | 22188 | C
 | 22186 | 22427 | E
 | 22454 | 23221 | C
 | 23176 | 23330 | E
 | 23362 | 23489 | C
 | 23559 | 23778 | E
 | 23803 | 24820 | C
 | 24830 | 25085 | E
 | 25085 | 25371 | E
 | 25410 | 26554 | C
 | 26637 | 27093 | E
 | 27116 | 29281 | C
 | 29293 | 29758 | E
 | 29790 | 32804 | E
Spreadsheet: 276050d1383740986-i-tried-but-failed-countif-based-questions-test-file
Sheet: Sheet1

BP Tracker | 2013-14
XJ | 2013-04-01 00:00:00 | 2013-05-01 00:00:00
X351 Jaguar XJ | 2013-04-30 00:00:00 | 2013-05-30 00:00:00
 | April | May | June | July | August | September | October | November | December | January | February | March
BP
Retail with COUNTIFS
Retail with SUMPRODUCT
Retail with {Sum(If(array))}
BP Achievement %
Retail 12/13
YoY Growth %