tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: a51de5ef-2a89-46cc-9fcd-0dd41fc3e4ea
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2013-12-10 09:27:27.120000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
5 | 102.625 | 102.5 | 102.375 | 102 |  | and are added to price quote
4.875 | 102.573 | 102.448 | 102.323 | 101.948
4.75 | 102.529 | 102.404 | 102.279 | 101.904 |  | Note: | Refer To Price [NAME]
4.625 | 101.807 | 101.682 | 101.557 | 101.182 |  |  | For all Price Adjs
4.5 | 100.901 | 100.776 | 100.651 | 100.026
4.375 | 99.939 | 99.814 | 99.689 | 99.064
4.25 | 99.088 | 98.963 | 98.838 | 98.213
4.125 | 98.273 | 98.148 | 98.023 | 97.398
4 | 97.268 | 97.143 | 97.018 | 96.393 |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.625 | 102.5 | 102.375 | 102
3.875 | 102.355 | 102.23 | 102.105 | 101.73
3.75 | 101.677 | 101.552 | 101.427 | 101.052
3.625 | 101.258 | 101.133 | 101.008 | 100.633
3.5 | 100.73 | 100.605 | 100.48 | 99.855
3.375 | 99.975 | 99.85 | 99.725 | 99.1
3.25 | 99.247 | 99.122 | 98.997 | 98.372 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2013-12-24 09:27:27.120000
30 DAY | 2014-01-08 09:27:27.120000
45 DAY | 2014-01-23 09:27:27.120000
60 DAY | 2014-02-07 09:27:27.120000
90 DAY | 2014-03-09 09:27:27.120000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 2e77d0a5-a252-4d57-b3bd-52a035d58fa3
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | MINIATURE POT ROSES                                   2009/2010 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Check Product Form | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 |  |  |  |  |  |  |  |  | 4½" PINCH 'N' GO
 |  |  |  |  |  |  |  |  | 6" PINCH 'N' GO
ORDER TYPE |  |  | REASON CODE |  | REF               ORDER # |  | SALES ORG. |  | ORDER #
DISTRIB.  # & NAME |  |  |  |  |  | SHIP TO #
SOLD TO # / NAME |  |  |  |  |  | SHIP TO NAME
STREET, CITY, STATE & ZIP |  |  |  |  |  | STREET, CITY, STATE & ZIP
PHONE # |  |  |  |  |  | PHONE #
SALESREP NAME / NUMBER |  |  |  | PO# |  | VISA / MC / DISC |  | CARDHOLDER NAME
ARE SUBS OK? | IF NO, PHONE |  |  | WK WANTED |  | CREDIT CARD NUMBER / CCV# |  |  |  | EXP DATE
 | CUST
YES / NO | DIST |  |  | ORDER INFO |  | SHIP VIA:
 | SLSM
VARIETY NAME |  |  |  |  | QTY | VARIETY NAME |  |  |  |  | QTY
WHITE |  |  |  |  |  | VARIEGATED
ANDROMEDATM PATIOHIT® |  |  | Poulpah025(N) | USPP16348 |  | EMERALDTM PATIOHIT® |  |  | Poulpar030(N) | USPP17888
DENISETM PARADE® |  |  | Poulra015(N) |  |  | ISOLDETM PATIOHIT® |  |  | Poulpah024(N)
HONORATM PATIOHIT® |  |  | Poulpah051(N) | Available 11/1/09, limited availability |  | NICOLATM PARADE® |  |  | Poulpar033(N) | USPP16503
YELLOW |  |  |  |  |  | OLIVIATM PARADE® |  |  | Poulra049(N) | Available 11/1/09, limited availability
[NAME] PARADE® |  |  | Poulra065(N) | Available 11/1/09, limited availability |  | RED
CORNELIATM PATIOHIT® |  |  | Poulpah019(N) | USPP16317 |  | BAHIATM PARADE® |  |  | Poulpar043(N)
MISTRALTM PARADE® |  |  | Poulmist(N) | USPPAF |  | CHARMTM PARADE® |  |  | Poulpar053(N) | Available 11/1/09, limited availability
SILVIATM PATIOHIT® |  |  | Poulpah054(N) | Available 11/1/09, limited availability |  | FASHIONTM PATIOHIT® |  |  | Poulpah035(N) | USPP17359
ORANGE / SALMON |  |  |  |  |  | ISABELTM PATIOHIT® |  |  | Poulpah053(N) | Available 11/1/09, limited availability
BREEZETM PARADE® |  |  | Poulpar039(N) | USPPAF |  | KARINATM PARADE® |  |  | Poulpar029(N) | USPP16148
DONNAWAYTM PATIOHIT® |  |  | Poulpah026(N) | USPP16577
ESTEPONATM PATIOHIT® |  |  | Poulpah028(N) | USPP16497 |  | ORDER TOTAL |  |  |  |  | 0
[NAME] |  |  | Poulpah022(N) | USPP16711
[NAME] 2007 |  |  | Poulpah043(N) | Available 11/1/09, limited availability
PINK
ALICANTETM PATIOHIT® |  |  | Poulpah033(N) | USPP17509
BELLETM PARADE® |  |  | Poulpar042(N)
HOTTM PARADE® |  |  | Poulpar038(N) | USPP17306 |  | ORDER REQUIREMENTS |  |  |  | Pinch 'n' Go | Pinch 'n' Go
LAVENDER |  |  |  |  |  |  |  |  |  | 4½" | 6"
ANDREATM PARADE® |  |  | Poulpar034(N) | USPP16582 |  | MINIMUM UNITS PER ORDER: |  |  |  | 150 | 96
LAMYTM PARADE® |  |  | Poulpar058(N) | Available 11/1/09, limited availability |  | MINIMUM UNITS PER VARIETY: |  |  |  | 15 | 8
 |  |  |  |  |  | NUMBER OF UNITS PER BOX: |  |  |  | 15 | 8
FOR INTERNAL USE ONLY |  |  | 2009-06-22 00:00:00 |  |  | VARIETIES IN MULTIPLES OF: |  |  |  | 15 | 8
PLACED VIA:                          PH / FAX / EMAIL |  |  | CUSTOMER: |  | DISTRIBUTOR |  | SALES PERSON |  | TAKEN BY / DATE:
Spreadsheet: 729325d1619022272-need-a-formula-for-inventory-union-clothing-and-accessories
Sheet: ResultsGrid_ExportData (2)

BCFR Local 4868 Union Clothing
Remaining Stock |  |  |  |  |  |  |  | Beginning Stock
Size |  | SS T-Shirt | LS T-Shirt | Hoodie |  |  |  | Size |  | SS T-Shirt | LS T-Shirt | Hoodie
S |  |  |  |  |  |  |  | S |  | 2 | 3 | 0
M |  |  |  |  |  |  |  | M |  | 6 | 0 | 0
L |  |  |  |  |  |  |  | L |  | 21 | 0 | 11
XL |  |  |  |  |  |  |  | XL |  | 8 | 1 | 7
XXL |  |  |  |  |  |  |  | XXL |  | 0 | 0 | 0
XXXL |  |  |  |  |  |  |  | XXXL |  | 10 | 3 | 5
Last Name | First Name | SS T-Shirt | LS T-Shirt | Hoodie
Alderman | [NAME]
[NAME] | [NAME]
Bivens | [NAME]
Boone | [NAME]
Burdin | [NAME]
Burger | Marcus | XL |  | XL
Cole | [NAME] | L |  | L
Cripe | [NAME]
Crumely | Jeremiah
Crump | Justin
[NAME] | Chase | L |  | L
[NAME] | [NAME]
Dicola | [NAME]
Durgin | [NAME]
Frey | Justin
Gilreath | Zachary
Gray | [NAME]
Grayless | Justin
[NAME] | Christian
[NAME] | [NAME]
Hudgins | Tennille
[NAME] | [NAME] | L |  | L
Jenkins | Preston
Ledford | Caleb
Mathews | [NAME]
Mcelroy | [NAME] | XL |  | L
Millsaps | [NAME]
Mullins | [NAME]
[NAME] | [NAME]
Ratcliff | Toby
Ream | Dakota
Rickman | Nathan |  |  | L
Rogers | Mark
Scoggins | [NAME]
Sims | [NAME]
Smith | [NAME] | M |  | M
Stearns | [NAME] | L |  | L
[NAME] | [NAME] | XL |  | XL
[NAME] | [NAME]
Suits | [NAME]
[NAME] | Walter
[NAME] | [NAME]
Thompson | Loretta
Watson | [NAME]
West | [NAME] | XL |  | XL
Wilson | [NAME]
Spreadsheet: 721796d1614866277-find-top-5-with-criteria-and-sum-error-sample
Sheet: Sheet2

Name | Workflow | Completed Cases |  |  |  |  | name | 1 | 2 | 3 | 4 | 5
[NAME] | workflow a | 56 |  |  |  |  | [NAME]
[NAME] | workflow a | 500 |  |  |  |  | [NAME]
[NAME] | workflow a | 5 |  |  |  |  | [NAME]
[NAME] | workflow a | 78 |  |  |  |  | [NAME]
[NAME] | workflow a | 21
[NAME] | workflow b | 200
[NAME] | workflow b | 7000
[NAME] | workflow b | 55
[NAME] | workflow c | 100 |  |  |  | Row Labels | Sum of Completed Cases
[NAME] | workflow c | 22 |  |  |  | [NAME] | 8087
[NAME] | workflow d | 50 |  |  |  | workflow b | 7255
 |  |  |  |  |  | workflow a | 660
 |  |  |  |  |  | workflow c | 122
 |  |  |  |  |  | workflow d | 50
 |  |  |  |  |  | Grand Total | 8087
Spreadsheet: 00b1ceb6-866d-43a5-9f36-4fbf8b127fe4
Sheet: 13b

 |  | Dealers** |  |  | Buyside |  |  | TOTAL
Product |  | HY*** | IG | Other | HY | IG | Other | HY | IG | Other
Index Tranche* | Asia |  | <100 | 925 |  | <100 | <100 |  |  | 925
 | Europe |  |  | 814928 |  |  | 87566 |  |  | 902493
 | North America | 127678 | 1021374 | 28557 | 8923 | 27384 | 1488 | 136601 | 1048758 | 30045
Index | Asia | 6387 | 92870 | 201676 | 527 | 8271 | 38270 | 6914 | 101141 | 238718
 | Europe |  |  | 2832316 |  |  | 662270 |  |  | 3215558
 | North America | 278021 | 1627255 | 232948 | 130901 | 690615 | 35935 | 331037 | 1872233 | 268882
TOTAL |  | 412086 | 2741499 | 4111348 | 140351 | 726271 | 825528 | 474552 | 3022133 | 4656621
Estimated gross notional amount outstanding, November 30 weekly snapshot, by product type (millions of USD), all participant types, tenors and currencies. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for participant type descriptions.
***See Data Dictionary for product grade descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 3e7d8c7d-0de7-4135-a2a7-50173407a2fc
Sheet: East Side

REGIONAL DIRECTORY 2014/2015
EAST SIDE UNION HIGH SCHOOL DISTRICT
[NAME], Superintendent | [NAME], Associate Superintendent | TBD, MEP Administrator
830 North Capitol Avenue | 830 North Capitol Avenue | 830 North Capitol Avenue
San Jose, CA 95133 | San Jose, CA 95133 | San Jose, CA 95133
O: [PHONE] | O: [PHONE] | O: [PHONE]
F: [PHONE] | F: [PHONE] | F: [PHONE]
[EMAIL] | [EMAIL]
[NAME], Senior Accountant | [NAME], Community Resource Technician | [NAME], Office Assistant
830 North Capitol Avenue | 830 North Capitol Avenue | 830 North Capitol Avenue
San Jose, CA 95133 | San Jose, CA 95133 | San Jose, CA 95133
O: [PHONE] | O: [PHONE] | O: [PHONE]
F: [PHONE] | F: [PHONE] | F: [PHONE]
[EMAIL] | [EMAIL] | [EMAIL]
Antonia (Toni) Romo, OSY Advocate
1290 Ridder Park Dr.
San Jose, CA 95133
O: [PHONE]
C: [PHONE]
[EMAIL]
Spreadsheet: 77812d1278318184-mistakes-with-simple-data-excel-tip
Sheet: Sheet1

Code | Item | Mistakes? | Validated
X0001 | 2 | Y | 2010-05-18 00:00:00
X0002 | 3 | Y | 2010-05-18 00:00:00
X0003 | 4 | Y | 2010-05-18 00:00:00
X0004 | 7 | Y | 2010-05-18 00:00:00
[NAME] | 2 | Y | 2010-05-18 00:00:00
X0006 | 4 | Y | 2010-05-26 00:00:00
X0007 | 5 | Y | 2010-06-08 00:00:00
X0008 | 6 | Y | 2010-06-08 00:00:00
X0009 | 7 | Y | 2010-06-02 00:00:00
X0010 | 89 | Y | 2010-06-02 00:00:00
X0011 | 8 | Y | 2010-06-01 00:00:00
X0012 | 6 | Y | 2010-06-01 00:00:00
X0013 | 7 | Y | 2010-06-01 00:00:00
X0014 | 8 | Y | 2010-06-01 00:00:00
X0015 | 9 | N | 2010-06-24 00:00:00
Spreadsheet: louise_kitchen__24097__NEWCO HEADCOUNT NAMES1
Sheet: Legal

Lawyers | ok |  |  | Bonus
Houston
[NAME], Leslie | Sr. Counsel |  |  | 75000
[NAME], Mary | Sr. Counsel |  |  |  | R
[NAME], [NAME] | MD |  |  |  | R
Hodge, [NAME] | VP |  |  | 125000
Koehler, [NAME] | Sr. Counsel |  |  | 75000
[NAME], [NAME] | VP |  |  |  | R
Nemec, [NAME] | Sr. Counsel |  |  | 25000
Nettelton, Marcus | Sr. Counsel |  |  | 75000
[NAME], [NAME] | Sr. Counsel |  |  | 75000
Sager, [NAME] | VP |  |  |  | R
St. Clair, Carol | VP |  |  |  | R
[NAME], [NAME] | VP |  |  |  | R
[NAME], [NAME] | Asst. General Counsel |  |  | 75000
Portland
Hall, [NAME] | Sr. Counsel |  |  | 100000
[NAME], [NAME] |  |  |  | 75000
Yoder, Christian | Sr. Counsel |  |  | 75000
Legal Specialists
Fitzgerald, Genia | Sr. Counsel |  |  | 15000
Heard, [NAME] | Sr. Counsel |  |  | 15000
Jones, [NAME] | Sr. Counsel |  |  | 15000
Admins
[NAME], Janette | [NAME] |  |  | 5000
Kaiser, Holly | [NAME] |  |  | 4000
Adams, Suzanne | [NAME] |  |  | 4000
Simmons, [NAME] | [NAME] |  |  | 3000
Total | 21
 | 22
Removed
Cash
Add
Adams, Suzanne | [NAME] |  |  | 4000
Simmons, [NAME] | [NAME] |  |  | 3000
Spreadsheet: 220237d1363104747-how-to-display-string-in-different-ways-according-to-conditions-book1
Sheet: Sheet1

 |  |  |  |  |  |  | The Summary Table
The Pivot Table |  |  |  |  |  |  | Base Field No | Base Sum | VAT Field No | [NAME]
Tax code Name correct if Credit Note | VAT Return Form Base Field Number | [NAME] Number | Sum of Net | Sum of VAT | Sum of Gross
BE|AP| Bank Charge VAT (21%) | 82 | 59 | 82.64 | 17.35 | 99.99 |  | 81 |  | 55
BE|AP| Various goods/services CoContract Reverse Charge - 21% | 82,87 | 56,59 | 468.02 | 0 | 468.02 |  | 82 |  | 59
BE|AP|Investments - 21% - 75% ded | 83 | 59 | 0 | 144.38 | 144.38 |  | 83 |  | 61
BE|AP|Trade goods - 6% | 81 | 59 | 82.64 | 4.96 | 87.6 |  | 84 |  | 62
BE|AP|Trade goods - EU Acq. - 21% | 81,86 | 55,59 | 100 | 0 | 100 |  | 85 |  | 63
BE|AP|Various goods/services - 21% - 100% ded | 82 | 59 | 82.64 | 17.36 | 100 |  | 86 |  | 82
BE|AP|Various goods/services - 21% - 35% ded | 82 | 59 | 93.15 | 6.85 | 100 |  | 87 |  | 84
BE|AP|Various services  by a EU established service provider - 21% - 100% ded - credit note | -82,84,-88 | 61,62* | -82.64 | -17.35 | -99.99 |  | 88 |  | 86
BE|AP|Various services by a EU established service provider - 21% - 100% ded | 82,88 | 55,59 | 82.64 | 17.36 | 100
BE|AP|Various goods/services - 21% - 100% ded - credit note | -82,85 | 63 | -413.22 | -86.78 | -500
BE|AP|Capitalised services by a non-EU established service provider - 21% - 100% ded - credit note | -83,85,-87 | 61,62* | -82.64 | -17.36 | -100
BE|AP|Various goods - EU Acq. - 21% - 0% ded - credit note | -82, 84, -86 | 59 | -330.59 | 0 | -330.59
BE|AP|Various goods/services - 6% - 0% ded - credit note | -82,85 | n/a | 0 | -69.41 | -69.41
Grand Total |  |  | 82.63999999999993 | 17.36000000000003 | 100
Spreadsheet: 0b33bdd9-8331-4410-96bd-511c5b1dff4b
Sheet: Science

 | Associate In Science (2011 - 2012) |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Unofficial Audit |  |  |  |  |  |  |  |  |  |  |  | General Help | Return To AA
 | NAME: |  |  |  |  | DATE: |  |  |  |  |  |  | [NAME] | Return To AS
 | ID: |  |  |  |  | FOCUS: |  |  |  |  |  | Focus Areas | [NAME] | [NAME]
 | CATEGORY I:  General Education & Core Transfer Courses |  |  |  |  |  |  | Hours: |  | /33 |  | Category I Help
 |  |  |  | Course | Credit | Grade |  | Course | Credit | Grade
 | Writing (6)
 | Communication (3)
 | Heritage (3)
 | Humanities (3)
 | Social Interaction (9)
 | Science (6)
 | Mathematics (3)
 | CATEGORY II:  Additional General Education Courses |  |  |  |  |  |  | Hours: |  | /15 |  | Category II Help
 |  |  |  | Course | Credit | Grade |  | Course | Credit | Grade
 | Science & Mathematics (9)
 | Computer Literacy (3)
 | General Education (3)
 | CATEGORY III:  Electives |  |  |  |  |  |  | Hours: |  | /12 |  | Category III Help
 |  |  |  | Course | Credit | Grade |  | Course | Credit | Grade
 | Electives (12)
 | Total Credits: |  |  |  |  |  |  | Earned Credits:
 | Additional Credits: |  |  |  |  |  |  | Credits IPS:
 | Requirements |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 1.  Student must take one approved Cultural Studies course.
 | 2.  Student must take Social Interaction courses from at least two disciplines.
 | 3.  Student must take at least one Science Lab.
 | 4.  Student must take at least 4 credits in MA/MAT/MT/ST/STA from the approved list. |  |  |  |  |  |  |  |  | /4
 | 5.  Student must earn a minimum of sixty (60) credit hours for a degree. |  |  |  |  |  |  |  |  | /60
 | 6.  Student must earn at least fifteen (15) credit hours at BCTC. |  |  |  |  |  |  |  |  | /15
 | 7.  Student must have a cumulative GPA of 2.0 to earn a degree. |  |  |  |  |  |  |  |  | /4.0
 | Notes
 | Auditor: |  |  |  |  | E-mail:
Spreadsheet: fletcher_sturm__10910__ng gas correlation matrix
Sheet: 08.29.00

Prompt Month Correlations for Primary Curves
2000-08-29 00:00:00
Factor [NAME] 1368
Primary Curves |  | NG | CGPR-AECO/BASIS | CGPR-DAWN | IF-ANR/OK | IF-ELPO/PERMIAN | IF-ELPO/SJ | IF-HPL/SHPCHAN | IF-NNG/DEMARCAT | IF-NWPL_ROCKY_M | IF-TRANSCO/Z2 | IF-TRANSCO/Z6 | NGI-MALIN | NGI-SOCAL | NGI/CHI. GATE
NG |  | 1 | 0.97 | 1 | 1 | 1 | 0.98 | 1 | 1 | 0.99 | 1 | 1 | 0.96 | 0.82 | 1
CGPR-AECO/BASIS |  | 0.97 | 1 | 0.97 | 0.97 | 0.97 | 0.99 | 0.97 | 0.97 | 0.99 | 0.97 | 0.96 | 0.95 | 0.76 | 0.97
CGPR-DAWN |  | 1 | 0.97 | 1 | 1 | 1 | 0.98 | 1 | 1 | 0.98 | 1 | 1 | 0.96 | 0.82 | 1
IF-ANR/OK |  | 1 | 0.97 | 1 | 1 | 1 | 0.98 | 1 | 1 | 0.98 | 1 | 1 | 0.96 | 0.82 | 1
IF-ELPO/PERMIAN |  | 1 | 0.97 | 1 | 1 | 1 | 0.98 | 1 | 1 | 0.98 | 1 | 1 | 0.96 | 0.82 | 1
IF-ELPO/SJ |  | 0.98 | 0.99 | 0.98 | 0.98 | 0.98 | 1 | 0.98 | 0.98 | 0.99 | 0.98 | 0.97 | 0.92 | 0.75 | 0.98
IF-HPL/SHPCHAN |  | 1 | 0.97 | 1 | 1 | 1 | 0.98 | 1 | 1 | 0.98 | 1 | 1 | 0.96 | 0.82 | 1
IF-NNG/DEMARCAT |  | 1 | 0.97 | 1 | 1 | 1 | 0.98 | 1 | 1 | 0.98 | 1 | 1 | 0.96 | 0.82 | 1
IF-NWPL_ROCKY_M |  | 0.99 | 0.99 | 0.98 | 0.98 | 0.98 | 0.99 | 0.98 | 0.98 | 1 | 0.99 | 0.98 | 0.94 | 0.74 | 0.99
IF-TRANSCO/Z2 |  | 1 | 0.97 | 1 | 1 | 1 | 0.98 | 1 | 1 | 0.99 | 1 | 1 | 0.96 | 0.82 | 1
IF-TRANSCO/Z6 |  | 1 | 0.96 | 1 | 1 | 1 | 0.97 | 1 | 1 | 0.98 | 1 | 1 | 0.95 | 0.82 | 1
NGI-MALIN |  | 0.96 | 0.95 | 0.96 | 0.96 | 0.96 | 0.92 | 0.96 | 0.96 | 0.94 | 0.96 | 0.95 | 1 | 0.92 | 0.96
NGI-SOCAL |  | 0.82 | 0.76 | 0.82 | 0.82 | 0.82 | 0.75 | 0.82 | 0.82 | 0.74 | 0.82 | 0.82 | 0.92 | 1 | 0.82
NGI/CHI. GATE |  | 1 | 0.97 | 1 | 1 | 1 | 0.98 | 1 | 1 | 0.99 | 1 | 1 | 0.96 | 0.82 | 1
Spreadsheet: 686504d1594659615-avoiding-deleting-information-as-the-year-begins-2020-07-13-oeldere-sunboy-pt-686478d1594650501-avoiding-deleting-information-as-the-year-begi
Sheet: PT

Som van Amount incl [NAME] | Month
Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | Eindtotaal
1919 | 20000 | 70000 | 5000 | 15000 | 20000 | 12000 | 4000 | 6000 | 8000 | 1000 | 2000 | 3000 |  | 166000
1920 | 4000 |  |  |  |  |  |  |  |  |  |  |  |  | 4000
2019 | 11500 |  |  |  |  |  |  |  |  |  |  |  |  | 11500
2020 | 102000 | 70000 | 5000 |  |  |  | 10000 |  |  |  |  |  |  | 187000
Eindtotaal | 137500 | 140000 | 10000 | 15000 | 20000 | 12000 | 14000 | 6000 | 8000 | 1000 | 2000 | 3000 |  | 368500
Spreadsheet: 785572d1656498473-having-trouble-using-and-and-countif-on-multiple-criteria-this-or-that-countif
Sheet: Sheet1

Primary | Partner 1 | Partner 2 | Partner 3 |  |  | CURRENT RESULT
True | THIS
True |  | THIS
False
True |  |  | THIS
False
False
Primary | Partner 1 | Partner 2 | Partner 3 |  |  | DESIRED RESULT | WHERE I'M AT WITH FORMULA
True |  | THAT |  |  |  | Y | =IF(AND(A11,COUNTIFS(OR(B11:D11,"*THIS*",B11:D11,"*THAT*"))),"Y","N")
True |  | THIS |  |  |  | Y
False |  |  |  |  |  | N
True | THAT |  | THIS |  |  | Y
False
False
Spreadsheet: 790798d1659995549-formula-for-totals-across-multiple-tabs-countifs-non-equal-columns-eba
Sheet: Totals

Name | Total Games Played | Total Full Time Different to Half Time |  |  |  | Tabs
[NAME] |  |  |  |  |  | 18
[NAME] |  |  |  |  |  | 19
[NAME] |  |  |  |  |  | 20
[NAME] |  |  |  |  |  | 21
[NAME]
[NAME]
Bethany
[NAME]
[NAME]
Nicki
Spreadsheet: 711923d1609968991-returning-a-row-number-from-an-array-sample
Sheet: Sheet1

row | 18 | 19 | 20 | 21 | 22 | 23 |  | Age | value | row
1 | 6 | 8 | 9 | 11 | 10 | 9 |  | 19 | 10 |  | #REF! | #REF! | #REF! | #REF! | #REF!
2 | 7 | 9 | 10 | 12 | 11 | 10 |  | 22 | 10 | #REF! | #REF! | #REF! | #REF! | #REF! | #REF!
3 | 8 | 10 | 11 | 13 | 12 | 11 |  |  |  | #REF! | #REF! | #REF! | #REF! | #REF! | #REF!
4 | 9 | 11 | 12 | 14 | 13 | 12 |  |  |  | #REF! | #REF! | #REF! | #REF! | #REF! | #REF!
Spreadsheet: 115451d1311069816-automate-unmerging-of-cells-example
Sheet: Sheet1

Original
Organisation | Division | Directorate | Count
MSFT | Division 1 | Directorate 1-1 | 15
 |  | Directorate 1-2 | 12
 | Division 2 | Directorate 2-1 | 11
 |  | Directorate 2-2 | 14
 |  | Directorate 2-3 | 8
 | Division 3 | Directorate 3-1 | 12
 |  | Directorate 3-2 | 12
 |  | Directorate 3-3 | 15
 |  | Directorate 3-4 | 7
Required
Organisation | Division | Directorate | Count
MSFT | Division 1 | Directorate 1-1 | 15
MSFT | Division 1 | Directorate 1-2 | 12
MSFT | Division 2 | Directorate 2-1 | 11
MSFT | Division 2 | Directorate 2-2 | 14
MSFT | Division 2 | Directorate 2-3 | 8
MSFT | Division 3 | Directorate 3-1 | 12
MSFT | Division 3 | Directorate 3-2 | 12
MSFT | Division 3 | Directorate 3-3 | 15
MSFT | Division 3 | Directorate 3-4 | 7
Spreadsheet: 88647d1288441213-retrieve-row-data-useindexmatch
Sheet: Sheet2

 | my requirement
 | Serial no | 2
 | [NAME] | sef |  | data3 | dfgdgf
 | data2 | asdf |  | data4 | asdf
 | Serial no | 5
 | [NAME] | gfdg |  | data3 | [NAME]
 | data2 | dgfsd |  | data4 | were
Spreadsheet: 793739d1661682536-365-how-to-use-a-a-formula-deduplication-to-sort-from-big-to-small-f8-28-aligw
Sheet: Sheet1

DATA | AMOUNT
A | 5 |  |  |  |  | 8 | 6 | 5
B | 7 |  |  | B
A | 6 |  |  | C |  | 6
C | 8
A | 5
C | 6
B | 7
A | 10
C | 8
A | 8
A | 6
Spreadsheet: 161545d1339544974-excel-2010-find-name-in-columns-then-add-1-weeks-scheduled-to-work
Sheet: Sheet1

 | Lead | Day 1 Lead
 | Install Team | 5/19/12 - 5/25/12
 | Juliano | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] |  |  |  | Name | Weeks Scheduled to Work
 |  |  |  |  | Juliano | 3
 | Install Team | 5/28/12 - 6/1/12 |  |  | [NAME] | 2
 | Juliano | [NAME] |  |  | [NAME]
 | [NAME] | [NAME] |  |  | [NAME]
 | [NAME] | [NAME] |  |  | [NAME]
 |  |  |  |  | [NAME]
 | Install Team | 6/4/12 - 6/8/12 |  |  | [NAME]
 | Juliano | [NAME] |  |  | [NAME]
 | [NAME] | Scott |  |  | [NAME]
 |  |  |  |  | Scott
 | Install Team | 6/09/12 - 6/14/12
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | Scott
Spreadsheet: 706574d1606776743-adding-additional-m-code-to-an-existing-powerquery-table-tennispq-original
Sheet: Tennis Data

Carpet |  | Name | Age | Wins | Matches | Lost | Surface Win % | Best Surface | Best Surface Win % | Prize Money
[NAME] |  | [NAME] | 23 | 283 | 417 | 134 | 0.6875 | Hard | 0.7374 | 724877
[NAME] |  | [NAME] | 27 | 313 | 499 | 186 | 0.6543 | Clay | 0.6719 | 479742
Spreadsheet: 110465d1307113487-excel-2007-can-a-cell-change-colour-based-on-a-calculation-alexa-20rank-1-
Sheet: Sheet1

Alexa Rank Stats
2011-03-30 00:00:00 | 3781207
2011-04-01 00:00:00 | 3797227
2011-04-05 00:00:00 | 3564567
2011-04-07 00:00:00 | 3567983
2011-04-11 00:00:00 | 3409058 |  |  | Total Difference:
 | 3261266
2011-05-05 00:00:00 | 3994804
2011-05-10 00:00:00 | 3447464
2011-05-16 00:00:00 | 3302578
2011-05-18 00:00:00 | 3303119
2011-05-20 00:00:00 | 2918274
2011-05-23 00:00:00 | 2927605
2011-05-24 00:00:00 | 2923816
2011-05-26 00:00:00 | 2926766
2011-06-01 00:00:00 | 2778938