tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 42841d1241478868-macros-and-assigning-buttons-urgent-help-required-excel-homework
Sheet: Salary & bonus

Year 1 |  |  | Monthly salary | Annual salary | Bonus | Annual salary plus bonus
 |  |  | £ | £ | £ | £
Anna |  |  | 1700 | 20400 | 2040 | 22440
[NAME] |  |  | 1350 | 16200 | 1620 | 17820
[NAME] |  |  | 1440 | 17280 | 1728 | 19008
Derek |  |  | 1660 | 19920 | 1992 | 21912
Edna |  |  | 1100 | 13200 | 1320 | 14520
[NAME] |  |  | 550 | 6600 | 660 | 7260
Total expenditure |  |  | 7800 | 93600 | 9360 | 102960 | OVER
Year 2 |  |  | Monthly salary | Annual salary | Bonus | Annual salary plus bonus
 |  |  | £ | £ | £ | £
Anna |  |  | 2000 | 24000 | 11175 | 35175
[NAME] |  |  | 1350 | 16200 | 0 | 16200
[NAME] |  |  | 1550 | 18600 | 4650 | 23250
Derek |  |  | 1800 | 21600 | 5400 | 27000
Edna |  |  | 1600 | 19200 | 4800 | 24000
[NAME] |  |  | 2500 | 30000 | 7500 | 37500
Total expenditure |  |  | 10800 | 129600 | 33525 | 163125 | 63125
Member of staff being paid closest to (but less than ) £25,000 for the year |  |  |  |  |  |  |  | Edna
Spreadsheet: 839146d1691690092-formula-to-confirm-of-payments-in-a-quarter-term-begin-date
Sheet: Sheet1

 |  |  | Q1 | Q2 | Q3 | Q4
 |  |  | 2023-07-01 00:00:00 | 2023-10-01 00:00:00 | 2024-01-01 00:00:00 | 2024-04-01 00:00:00
 |  |  | 9/31/2023 | 2023-12-31 00:00:00 | 2024-03-31 00:00:00 | 2024-06-30 00:00:00
Term Begin Date |  |  | Payment | Payment | Payment | Payment
2023-02-01 00:00:00 | 500 |  | 1500 | 1500 | 1500 | 1500
2023-09-01 00:00:00 | 500 |  | 500 | 1500 | 1500 | 1500
2023-11-01 00:00:00 | 500 |  | 0 | 1000 | 1500 | 1500
2024-08-01 00:00:00 | 500 |  | 0 | 0 | 0 | 0
Need a formula that will confirm how many month fall within each quarter based off of the Term Begin Date noted in Column A and multiply that by the dollar amount in colum B.  End result is to know how much is to be paid in each quarter.
Spreadsheet: 117948d1313290895-excel-2007-conditional-formulas-needtoprogresshlookup
Sheet: Sheet1

What | Current | Start | Rank1 | Rank2 | Rank3 | Need
Headshots | 75 | 0 | 50 | 100 | 150 |  | <<Your formula is here.
[NAME] kills | 10 | 0 | 25 | 50 | 100
Spreadsheet: 80154d1280358554-counting-how-many-times-a-character-appers-in-an-column-charactersincolumn
Sheet: Sheet1

 |  | 1 | 2 | 3 | A | B | X
 | XDEA1B2 | 1 | 1 | 0 | 1 | 1 | 1
 | XBDE3 | 0 | 0 | 1 | 0 | 1 | 1
 | XABDE | 0 | 0 | 0 | 1 | 1 | 1
 | [NAME] | 0 | 0 | 0 | 0 | 1 | 0
 | BDEXZY | 0 | 0 | 0 | 0 | 1 | 1
 | Total | 1 | 1 | 1 | 2 | 5 | 4
Spreadsheet: 0adac3ac-a2a1-499a-a417-1b8a4ab49446
Sheet: Potential

Fall 2014 Sales Potential
Each Scout Selling 15* Containers |  |  | Every Scout Fills Up A Sheet (30 lines)
Unit | Pack 50 |  | Unit
Number of Scouts | 35 |  | Number of Scouts
Commission Percent | 0.36 |  | Commission Percent
Average container sales | 15 |  | Filling a Sheet | 30
per Scout |  |  | (minimum containers)
Average Retail Price | 17 |  | Average Retail Price
Gross Sales Potential |  |  | Gross Sales Potential
Unit Commission Potential |  |  | Unit Commission Potential
*Based upon research, the average [NAME] sells 15 containers
Replace example with actual Unit info
Spreadsheet: 85811d1285850562-excel-2007-sum-of-unique-items-example-sheet
Sheet: DATA

Fruits | Sum of Unique Codes
[NAME]
Apple
Grape
Orange
[NAME]
Fruits | Code | Unique Codes
[NAME] | 12345
Apple | 67891
Orange | 10111
[NAME] | 12345
Grape | 12131
Orange | 10111
Apple | 67891
[NAME] | 23456
[NAME] | 34567
Orange | 11213
[NAME] | 27836
Orange | 10111
Orange | 13421
Grape | 12131
Apple | 67891
Apple | 78910
[NAME] | 23456
Spreadsheet: 778366d1651030976-i-am-trying-to-group-together-rows-of-invoice-lines-into-a-specific-type-book3
Sheet: Sheet2

Row Labels | Sum of Net | Sum of GST | Sum of Total
Middle | 689.6100000000001 | 68.75 | 758.36
32958921 - 22-04  - Flight | 689.6100000000001 | 68.75 | 758.36
Top | 610.9200000000001 | 60.89 | 671.8100000000001
32959836 - 22-04  - Hotel | 447.2 | 44.57 | 491.77
32958735 - 22-04  - Hotel | 163.72 | 16.32 | 180.04
Grand Total | 1300.53 | 129.64 | 1430.17
Spreadsheet: 03cb9e63-2c59-4121-a576-2c6ef7c2262d
Sheet: Sheet1

Table 10--Global rice exporters, calendar years 2010-2012; monthly revisions and annual changes | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 | 2010 |  |  |  | 2011 |  |  |  |  |  | 2012 1/
 | April |  | March | April |  | Monthly | Annual |  | March | April |  | Monthly | Annual
 | 2012 |  | 2012 | 2012 |  | revisions | changes |  | 2012 | 2012 |  | revisions | changes
 |  |  |  |  |  |  | 1,000 metric tons (milled basis)
Argentina | 468 |  | 732 | 732 |  | 0 | 264 |  | 630 | 650 |  | 20 | -82
Australia | 54 |  | 350 | 311 |  | -39 | 257 |  | 450 | 450 |  | 0 | 139
Brazil | 430 |  | 1300 | 1296 |  | -4 | 866 |  | 725 | 625 |  | -100 | -671
Burma | 445 |  | 750 | 778 |  | 28 | 333 |  | 750 | 600 |  | -150 | -178
Cambodia | 1000 |  | 1000 | 1000 |  | 0 | 0 |  | 1000 | 1000 |  | 0 | 0
China | 619 |  | 500 | 487 |  | -13 | -132 |  | 600 | 500 |  | -100 | 13
Ecuador | 60 |  | 70 | 70 |  | 0 | 10 |  | 15 | 15 |  | 0 | -55
Egypt | 570 |  | 120 | 320 |  | 200 | -250 |  | 600 | 600 |  | 0 | 280
European Union-27 | 282 |  | 300 | 241 |  | -59 | -41 |  | 350 | 245 |  | -105 | 4
Guyana | 275 |  | 250 | 250 |  | 0 | -25 |  | 230 | 230 |  | 0 | -20
India | 2228 |  | 4200 | 4637 |  | 437 | 2409 |  | 6000 | 7000 |  | 1000 | 2363
Japan | 200 |  | 200 | 200 |  | 0 | 0 |  | 150 | 200 |  | 50 | 0
Korea, South | 4 |  | 3 | 3 |  | 0 | -1 |  | 3 | 3 |  | 0 | 0
Pakistan | 4000 |  | 3000 | 3200 |  | 200 | -800 |  | 3750 | 3750 |  | 0 | 550
Paraguay | 135 |  | 220 | 220 |  | 0 | 85 |  | 150 | 150 |  | 0 | -70
Peru | 55 |  | 50 | 50 |  | 0 | -5 |  | 20 | 20 |  | 0 | -30
Russia | 154 |  | 125 | 142 |  | 17 | -12 |  | 150 | 150 |  | 0 | 8
Thailand | 9047 |  | 10500 | 10647 |  | 147 | 1600 |  | 6500 | 6500 |  | 0 | -4147
Turkey | 52 |  | 90 | 90 |  | 0 | 38 |  | 95 | 95 |  | 0 | 5
Uganda | 25 |  | 30 | 30 |  | 0 | 5 |  | 30 | 30 |  | 0 | 0
United States | 3868 |  | 3213 | 3213 |  | 0 | -655 |  | 3000 | 3100 |  | 100 | -113
Uruguay | 808 |  | 841 | 841 |  | 0 | 33 |  | 850 | 850 |  | 0 | 9
Vietnam | 6734 |  | 7000 | 7000 |  | 0 | 266 |  | 6500 | 7000 |  | 500 | 0
Subtotal | 31513 |  | 34844 | 35758 |  | 914 | 4245 |  | 32548 | 33763 |  | 1215 | -1995
Other | 268 |  | 269 | 290 |  | 21 | 21 |  | 138 | 253 |  | 115 | -37
World total | 31781 |  | 35113 | 36048 |  | 935 | 4267 |  | 32686 | 34016 |  | 1330 | -2032
U.S. Share | 0.1217079387055159 |  | 0.09150457095662574 | 0.08913115845539281 |  | -- | -- |  | 0.09178241448938383 | 0.09113358419567262 |  | -- | --
-- Not available.  Note: All trade data are reported on a calendar-year basis.
1/ Projected.
Source: Production, Supply, & Distribution Online Data Base, FAS/USDA, http://www.fas.usda.gov/psdonline/psdHome.aspx.
Last updated April 10, 2012.
Spreadsheet: 786184d1657029639-reference-cells-from-multiple-worksheets-into-a-master-worksheet-sample_cell-references
Sheet: Tab 1 Summary

Stud ID | Grade | Team | Recommendation
 |  |  |  | Tab A | B1 | B4 | E4 | B7
 |  |  |  | [NAME]
 |  |  |  | [NAME]
Spreadsheet: 01ceb975-1f66-44d8-a5a3-10c8ee2f81b6
Sheet: Sheet1

ARRIVAL / DEPARTURE  FORM | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Name of the Event |  | BWF Annual General [NAME], India
Deadline - 5 May 2014                           Email To: |  |  |  |  | [EMAIL]
Member Association
[NAME]
Delegates Family Name | Date | Airlines | Flight No. | Time of arrival | Place of Airport |  | Name of Airport
Departure Details
Delegates Family Name | Date | Airlines | Flight No. | Time of arrival | Place of Airport |  | Name of Airport
Date |  |  | Name
Spreadsheet: 92478d1292028503-help-with-searching-for-category-then-adding-the-value-to-another-cell-sumif-example
Sheet: Sheet1

Date | Trans | Amt |  |  |  |  | Totals
2010-12-01 00:00:00 | Gas | 15 |  |  |  | Gas | 15
2010-12-02 00:00:00 | Food | 6 |  |  |  | Food | 18.25
2010-12-02 00:00:00 | Bills | 37 |  |  |  | Bills | 100
2010-12-03 00:00:00 | Food | 12.25
2010-12-04 00:00:00 | Bills | 63
Spreadsheet: 25364d63-aa90-4858-8a13-1b619f36549b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | APPROPRIATION TRANSACTION | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  | CITY  OF  KANSAS  CITY,  MISSOURI
 |  |  | DEPARTMENT: |  |  | Water Services
BUSINESS UNIT: |  |  |  | KCMBU |  | DATE: |  | 2007-07-03 00:00:00 |  | JOURNAL ID:
LEDGER GROUP: |  |  |  |  | APPROP
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
AL |  | 8069 |  | 807703 |  | B |  | 80CONV |  | 12800000 |  | I
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  | 12800000
BUSINESS UNIT: |  |  |  | KCMBU |  | DATE: |  | 2007-07-03 00:00:00 |  | JOURNAL ID: |  | C
 |  |  |  |  |  |  |  |  |  |  |  | (same as above, except
LEDGER GROUP: |  |  |  |  | ADMIN |  |  | BUDGET PERIOD: |  |  |  | prefixed by a C)
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
AL |  | 8069 |  | 807703 |  | 611060 |  | 80CONV |  | 12800000 |  | I
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  | 12800000
[NAME]: |  |  |  |  |  |  |  |  |  |  |  | NET
 |  | Estimation and appropriation of the revenues associated with the Water Series 2007A Revenue Project Fund
 |  | Fund
APPROVED BY: |  |  |  |  |  | DATE |  | APPROVED BY:  DEPARTMENT HEAD |  |  |  |  |  | DATE
Spreadsheet: 688360d1595744870-find-formula-refere-to-character-in-cell-and-sort-data-from-a-z-problem-find-formula-refere-to-character-in-cell-and-sort-data-from-a-z-problem
Sheet: Sheet1

Hyperlink | First extract | Second part | Trying to convert as number for sort purpose |  | Character used | - | .
[PHONE]-029.pdf
[PHONE]-0190.pdf
[PHONE]-0196.pdf
[PHONE]-0197.pdf
[PHONE]-0199.pdf
[PHONE]-0201.pdf
[PHONE]-0253.pdf
[PHONE]-0256.pdf
[PHONE]-0316.pdf
[PHONE]-0418.pdf
[PHONE]-0430.pdf
[PHONE]-0432.pdf
[PHONE]-0437.pdf
[PHONE]-0438.pdf
[PHONE]-0489.pdf
[PHONE]-0490.pdf
[PHONE]-0497.pdf
[PHONE]-0530.pdf
[PHONE]-0565.pdf
[PHONE]-0586.pdf
[PHONE]-0721.pdf
[PHONE]-0722.pdf
[PHONE]-0755 .pdf
[PHONE]-0756.pdf
[PHONE]-0772.pdf
[PHONE]-0783.pdf
[PHONE]-0784.pdf
[PHONE]-0801 .pdf
[PHONE]-0801.pdf
[PHONE]-0809.pdf
[PHONE]-0830.pdf
[PHONE]-0902.pdf
[PHONE]-1086.pdf
[PHONE]-1135.pdf
[PHONE]-1170.pdf
[PHONE]-1171.pdf
[PHONE]-1181.pdf
[PHONE]-1225.pdf
[PHONE]-1294.pdf
[PHONE]-1295.pdf
[PHONE]-1380.pdf
[PHONE]-1415.pdf
[PHONE]-1448.pdf
[PHONE]-1510.pdf
[PHONE]-1520.pdf
[PHONE]-1522.pdf
[PHONE]-1529.pdf
[PHONE]-1567.pdf
[PHONE]-1581.pdf
[PHONE]-1588.pdf
[PHONE]-1596.pdf
[PHONE]-1614.pdf
[PHONE]-1615.pdf
[PHONE]-1718.pdf
[PHONE]-1725.pdf
[PHONE]-1731.pdf
[PHONE]-1753.pdf
[PHONE]-1756.pdf
[PHONE]-1759.pdf
[PHONE]-1806.pdf
[PHONE]-1840.pdf
[PHONE]-1841.pdf
[PHONE]-1847.pdf
[PHONE]-1862.pdf
[PHONE]-1870.pdf
[PHONE]-1936.pdf
[PHONE]-1962.pdf
[PHONE]-1973.pdf
[PHONE]-2013.pdf
[PHONE]-2019.pdf
[PHONE]-2065.pdf
[PHONE]-2071.pdf
[PHONE]-2088.pdf
[PHONE]-2127.pdf
[PHONE]-2240.pdf
[PHONE]-2573.pdf
[PHONE]-2735.pdf
[PHONE]-2751.pdf
[PHONE]-3138.pdf
[PHONE]-3181.pdf
[PHONE]-3289.pdf
[PHONE]-3517.pdf
[PHONE]-2065 2.pdf
[PHONE]-1520 2.pdf
[PHONE]-1529 2.pdf
[PHONE]-1510 2.pdf
Spreadsheet: 100333d1298692125-solver-issue-oil-blend-v2
Sheet: Sheet1

 |  |  | Fuel 1 | Fuel 2 | Fuel 3 | Fuel 4 | Fuel 5 | Fuel 6 | Fuel 7 | Fuel 8 | Fuel 9 | Fuel 10 | Fuel 11 | Fuel 12
 |  |  | 1% Sulfur | 3% Sulfur | 3% Sulfur | Heating | 1% Vacuum | 2% Vacuum | 0.5% Vacuum | Straight Run | Straight Run | [NAME] | Diesel
 |  |  | Fuel Oil | Fuel Oil | Fuel Oil | Oil | Gas Oil | Gas Oil | Gas Oil | (Low Sulfur) | (High Sulfur) | [NAME] | Fuel 11 | Slurry
 | Density |  | 0.996 | 0.996 | 0.996 | 0.855 | 0.904 | 0.904 | 0.904 | 0.928 | 0.953 | 0.797 | 0.85 | 1.1114
 | Linear visc. |  | 1.819 | 1.819 | 1.189 | 0.243 | 1.17 | 1.17 | 1.17 | 1.678 | 1.678 | -0.782 | -0.054 | 1.716
 | Sulfur |  | 1 | 3 | 0.7 | 0.2 | 1 | 2 | 0.5 | 0.3 | 2.75 | 0.125 | 0.2 | 2.37
 | Linear flash |  | 204.8 | 204.8 | 204.8 | 260.4 | 52.5 | 52.5 | 52.5 | 18.5 | 18.5 | 308.8 | 161.7 | 437
 | Price |  | 16.08 | 13.25 | 17.3 | 24.1 | 20.83 | 20.1 | 21.46 | 21 | 20 | 25.52 | 24.3 | 11.5
 | Portion Used |  | 0.999998207367311 | 0 | 0 | 1.586217252166952e-06 | 0 | 0 | 0 | 6.832953908319391e-07 | 0 | 0 | 0 | 6.162974130572884e-07
 |  |  | Blended Fuel 1
 | Density
 | Linear visc.
 | Sulfur
 | Linear flash
 | Cost
Spreadsheet: 05ec17bd-d723-450e-b7b6-264f2458d1ed
Sheet: Sheet1

Table 7--U.S. textile exports, by fiber | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Sept. | Oct. | Nov. |  | Nov.
Item | 2012 | 2012 | 2012 |  | 2011
 | 1,000 pounds 1/
[NAME], thread, and fabric: | 245843.685 | 240961.437 | 219508.135 |  | 230123.273
Cotton | 130962.124 | 124140.304 | 115956.12 |  | 126958.199
Linen | 6762.965 | 7047.501 | 6235.318 |  | 6521.451
Wool | 2929.695 | 2974.896 | 2594.118 |  | 3311.062
Silk | 1053.537 | 1111.204 | 963.816 |  | 887.593
Manmade | 104135.364 | 105687.532 | 93758.763 |  | 92444.968
Apparel: | 25480.095 | 25798.933 | 22386.072 |  | 21980.235
Cotton | 11166.389 | 11321.205 | 9469.459 |  | 9778.26
Linen | 305.216 | 383.075 | 276.687 |  | 494.599
Wool | 1739.337 | 1563.844 | 1275.639 |  | 1447.712
Silk | 1363.611 | 1454.762 | 1216.091 |  | 1067.1
Manmade | 10905.542 | 11076.047 | 10148.196 |  | 9192.564
Home furnishings: | 5902.689 | 5449.011 | 5172.688 |  | 4362.750999999999
Cotton | 2878.091 | 2592.85 | 2369.787 |  | 2072.558
Linen | 268.422 | 274.383 | 324.224 |  | 171.557
Wool | 162.174 | 196.609 | 181.727 |  | 98.729
Silk | 150 | 177.498 | 177.23 |  | 90.941
Manmade | 2444.002 | 2207.671 | 2119.72 |  | 1928.966
Floor coverings: | 29665.881 | 31674.918 | 31805.226 |  | 31656.562
Cotton | 2292.731 | 2212.555 | 2136.606 |  | 2141.341
Linen | 1077.15 | 1092.078 | 902.473 |  | 949.743
Wool | 2252 | 2429.421 | 2793.565 |  | 2852.722
Silk | 29 | 39.904 | 36.987 |  | 35.9
Manmade | 24015 | 25900.96 | 25935.595 |  | 25676.856
Total exports: 2/ | 307004.413 | 303983.75 | 278981.377 |  | 288377.8
Cotton | 147381.019 | 140332.432 | 130007.524 |  | 141046.938
Linen | 8413.753 | 8797.037 | 7738.702 |  | 8145.12
Wool | 7086.891 | 7171.954 | 6846.974 |  | 7719.491
Silk | 2595.628 | 2783.368 | 2394.124 |  | 2081.534
Manmade | 141527.122 | 144898.959 | 131994.053 |  | 129384.717
1/ Raw-fiber equivalent.  2/ Includes headgear.
Last update:  2/12/13.
Sources: USDA, Economic Research Service; and USDC,
U.S. Census Bureau.
Spreadsheet: 793808d1661755563-count-how-often-a-value-occurs-per-week-2022-08-28-oeldere-eugz-calculation
Sheet: Sheet1

 | Week1 |  | Week2 |  | Week3 |  | Week4 |  | Week5
 | 2022-08-01 00:00:00 | 2022-08-05 00:00:00 | 2022-08-08 00:00:00 | 2022-08-12 00:00:00 | 2022-08-15 00:00:00 | 2022-08-19 00:00:00 | 2022-08-22 00:00:00 | 2022-08-26 00:00:00 | 2022-08-29 00:00:00 | 2022-09-02 00:00:00
Kolom1 | Kolom2 | Kolom3 | Kolom4 | Kolom5 | Kolom6 | Kolom7 | Kolom8 | Kolom9 | Kolom10 | Kolom11 | Kolom12
ID | Status | Date |  | Status |  | Status |  | Status |  |  | Cat
A | Cancel | 2022-08-01 00:00:00 | 0 | Complete | 8 | Complete | 7 | Cancel | 4 | sa | Member
C | Complete | 2022-08-05 00:00:00 | 0 | Complete | 8 | Complete | 7 | Complete | 4 | ds | Claim
B | Complete | 2022-08-03 00:00:00 | 0 | Complete | 8 | Complete | 7 | Complete | 4 | fd | Member
D | Panding | 2022-08-14 00:00:00 | 1 | Panding | 8 | Panding | 7 | Panding | 4 | sa | Member
A | Complete | 2022-08-04 00:00:00 | 1 | Complete | 3 | Panding | 5 | Panding | 0 | rf | Claim
C | Complete | 8/222022 | 1 | Complete | 3 | Cancel | 5 | Complete | 0 | hg | Member
B | Panding | 8/202023 | 5 | Panding | 3 | Panding | 5 | Cancel | 0 | fd | Claim
D | Complete | 2022-08-28 00:00:00 | 5 | Cancel | 3 | Complete | 9 | Complete | 2 | gg | Member
B | Cancel | 2022-08-19 00:00:00 | 5 | Cancel | 2 | Cancel | 9 | Cancel | 2 | rr | Member
M | Complete | 2022-08-31 00:00:00 | 5 | Complete | 2 | Complete | 9 | Complete | 2 | tt | Other
Total Status with Cat without ID
Total Complete
Spreadsheet: 033d4855-ec7b-4602-8b8c-aaab9c75b6fc
Sheet: 4

 | Jan 11 |  | Jan 18 |  | Jan 25 |  | Feb 1
 | Long | Short | Long | Short | Long | Short | Long | Short
Total Interest Rate* | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs** | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Credit | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Weekly snapshot, net notional amount outstanding by asset class and participant type (millions of USD), all products, origins, currencies, tenors, cleared and uncleared.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: vkaminski__40901__CASH_EPE_0400MyCopy
Sheet: Annex 12-Gas

APPENDIX IV - GAS TARIFF (ANNEX 12)
 |  | Transport Gas Capacity Revenues |  |  |  |  |  |  |  |  |  |  |  | Commodity Gas Capacity Revenues |  |  |  |  |  |  |  |  |  |  |  | Variable Commodity Gas Revenues |  |  |  |  |  |  |  |  |  |  |  | Commodity Gas Escalator
 |  |  |  | Escalated | (Multiply By) | (Divide By) | Adjusted | Plant | Monthly | (Divide By) | Monthly | Annual |  |  | Commodity | Escalated | (Multiply By) | (Divide By) | Adjusted | Plant | Monthly | (Divide By) | Monthly | Annual |  |  | Commodity | Escalated | (Multiply By) | (Divide By) | Adjusted | Gas | Monthly | (Divide By) | Monthly | Annual |  | Base |  | Escalated |  | Total | Original | Commodity
 |  | [NAME] |  | [NAME] | Current | Bid Date | [NAME] | MW | Revenues | Current | Revenues | Revenues |  | [NAME] | Gas | [NAME] | Current | Bid Date | [NAME] | MW | Revenues | Current | Revenues | Revenues |  | VCG Tariff | Gas | VCG Tariff | Current | Bid Date | VCG Tariff | Mwhs | Revenues | Current | Revenues | Revenues |  | Com Gas |  | Com Gas | Yabog | Tariff | CG+Yabog | Gas
Date |  | R$ / Mw-Mo |  | R$ / Mw-Mo | Exch Rate | Exch Rate | R$ / Mw-Mo | Capacity | R $000 | Exch Rate | US $000 | US $000 |  | R$ / Mw-Mo | Escalator | R$ / Mw-Mo | Exch Rate | Exch Rate | R$ / Mw-Mo | Capacity | R $000 | Exch Rate | US $000 | US $000 |  | R$ / Mwh | Escalator | R$ / Mwh | Exch Rate | Exch Rate | R$ / Mwh | Produced | R $000 | Exch Rate | US $000 | US $000 |  | $ / MMBTU |  | $ / MMBTU | $ / MMBTU | $ / MMBTU | Tariff | Escalator
 |  |  |  |  |  |  |  |  |  |  | Total Transport Gas Revenues |  |  |  |  |  |  |  |  |  |  |  | Total Commodity Gas Revenues |  |  |  |  |  |  |  |  |  |  |  | Total Variable Commodity Gas Revenues
1
Spreadsheet: 700369d1603166412-need-help-to-have-formula-to-ignore-cells-with-no-dates-multiple-cells-in-a-row-playing-with-timeline
Sheet: Condo Conv (tbd)

Subject | Start Date | All day event | Reminder on/off | Meeting Organizer | Categories | Description | Location
Sign Disclosures |  | True | False | Team Rosa | Sign Disclosures
[NAME] |  | True | False | Team Rosa | [NAME]
[NAME] |  | True | False | Team Rosa | [NAME]
Processing Review |  | True | False | Team Rosa | Processing Review
[NAME] |  | True | False | Team Rosa | [NAME] | _x000D_
Submit for Condo Approval |  | True | False | Team Rosa | Submit 4 Condo Approval
[NAME] |  | True | False | Team Rosa | [NAME]
Submit Conditions |  | True | False | Team Rosa | Submit Conditions
CD |  | True | False | Team Rosa | CD
Final Approval |  | True | False | Team Rosa | Final Approval
[NAME] CD |  | True | False | Team Rosa | [NAME] CD
Docs Out |  | True | False | Team Rosa | Docs Out
Signing |  | True | False | Team Rosa | Signing
Close Date |  | True | False | Team Rosa | Close Date
KOT Resubmit |  | True | False | Team Rosa | KOT Resubmit
Spreadsheet: 93815d1293595070-ask-search-a-text-in-a-sheet-ask
Sheet: Sheet1

Table:
Name | Point | No. | Name | Point | No. | Name | Point | No.
AA | 10 | 1 | UU | 0 | 1 | EEE | 8 | 1
BB | 5 | 2 | VV | 8 | 2 | FFF | 7 | 2
CC | 3 | 3 | WW | 10 | 3 | GGG | 9 | 3
DD | 2 | 4 | XX | 7 | 4 | HHH | 3 | 4
EE | 9 | 5 | YY | 8 | 5 | III | 8 | 5
FF | 9 | 6 | ZZ | 4 | 6 | JJJ | 5 | 6
GG | 6 | 7 | AAA | 4 | 7 | KKK | 2 | 7
HH | 4 | 8 | BBB | 1 | 8 | LLL | 3 | 8
II | 8 | 9 | CCC | 4 | 9 | MMM | 8 | 9
JJ | 4 | 10 | DDD | 8 | 10 | NNN | 10 | 10
KK | 8 | 11 |  |  |  | OOO | 5 | 11
LL | 10 | 12 |  |  |  | PPP | 9 | 12
MM | 7 | 13 |  |  |  | QQQ | 8 | 13
NN | 7 | 14
OO | 8 | 15
PP | 1 | 16
QQ | 5 | 17
Question:
How to return "Point Column" based on "Name Column" (using 1 formula) as below:
I cant using VLOOKUP as the column that containing KEY reference is more than one (3)
Name: | Point:
BB
DD
AAA
QQQ
UU
Spreadsheet: f1085018-7255-4f41-bb0e-d3980ecef02f
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
44039553 | 2014-11-15 23:32:19 | AXIS | 0 | 2 | 6 | 1503014 | Agent Avacado | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
44039849 | 2014-11-15 23:49:58 | ALLIES | 1 | 6 | 1 | 1503014 | Agent Avacado | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
44123055 | 2014-11-21 21:58:07 | AXIS | 1 | 5 | 3 | 757054 | Bulldoz44 | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
44123343 | 2014-11-21 22:29:40 | ALLIES | 1 | 5 | 4 | 757054 | Bulldoz44 | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
44195333 | 2014-11-26 22:24:27 | AXIS | 0 | 3 | 7 | 1672362 | Guillaume le batard IV | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
44195551 | 2014-11-26 22:46:02 | ALLIES | 0 | 5 | 7 | 1672362 | Guillaume le batard IV | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri