tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 40455d1238768214-formula-to-select-value-that-satisfies-conditions-after-3w
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | After 3W
 | G | Date |  | Opp | W/L | MP | FG |  | [NAME] end result | FG | Example
 | 1 | 2008-10-29 00:00:00 | @ | ORL | W | 240 | 38 |  | -
 | 2 | 2008-11-01 00:00:00 |  | PHI | W | 240 | 39 |  | -
 | 3 | 2008-11-05 00:00:00 | @ | NOH | W | 240 | 34 |  | -
 | 4 | 2008-11-07 00:00:00 |  | TOR | W | 240 | 44 |  | 44
 | 5 | 2008-11-09 00:00:00 | @ | OKC | W | 240 | 29 |  | 29
 | 6 | 2008-11-11 00:00:00 | @ | CHI | W | 240 | 39 |  | 39
 | 7 | 2008-11-12 00:00:00 | @ | BOS | L | 240 | 31 |  | 31
 | 8 | 2008-11-14 00:00:00 | @ | NJN | L | 240 | 38 |  | -
 | 9 | 2008-11-15 00:00:00 |  | NJN | L | 240 | 35 |  | -
 | 10 | 2008-11-18 00:00:00 | @ | IND | L | 240 | 36 |  | -
 | 11 | 2008-11-19 00:00:00 |  | WAS | W | 240 | 33 |  | -
 | 12 | 2008-11-21 00:00:00 |  | CHA | W | 240 | 29 |  | -
 | 13 | 2008-11-22 00:00:00 | @ | CLE | L | 240 | 36 |  | -
 | 14 | 2008-11-26 00:00:00 |  | MIL | W | 240 | 35 |  | -
 | 15 | 2008-11-28 00:00:00 | @ | TOR | L | 240 | 35 |  | -
 | 16 | 2008-11-29 00:00:00 | @ | WAS | W | 240 | 37 |  | -
 | 17 | 2008-12-03 00:00:00 |  | MEM | W | 240 | 40 |  | -
 | 18 | 2008-12-05 00:00:00 |  | NYK | W | 240 | 39 |  | -
 | 19 | 2008-12-06 00:00:00 | @ | DAL | L | 240 | 34 |  | 34
 | 20 | 2008-12-09 00:00:00 | @ | HOU | L | 240 | 34 |  | -
 | G | Date |  | Opp |  | MP | FG |  | -
 | 21 | 2008-12-10 00:00:00 | @ | SAS | L | 240 | 36 |  | -
 | 22 | 2008-12-12 00:00:00 | @ | MIA | W | 240 | 28 |  | -
 | 23 | 2008-12-13 00:00:00 |  | CLE | W | 240 | 30 |  | -
 | 24 | 2008-12-15 00:00:00 |  | CHA | W | 240 | 35 |  | -
 | 25 | 2008-12-17 00:00:00 |  | BOS | L | 240 | 29 |  | 29
 | 26 | 2008-12-19 00:00:00 |  | [NAME] | W | 240 | 44 |  | -
 | 27 | 2008-12-21 00:00:00 |  | DET | W | 240 | 31 |  | -
 |  |  |  |  |  |  |  |  | -
Spreadsheet: 746769d1631015512-rank-duplicate-text-uniquely-1-2-3-4-based-on-occurance-country-ranking
Sheet: Sheet1

 | First or Additional |  |  |  | Country Number
Country | Wanted Outcome |  |  |  | Wanted Outcome
Australia | First |  |  |  | 1
Canada | First |  |  |  | 1
China | First |  |  |  | 1
Croatia | First |  |  |  | 1
Czech Republic | First |  |  |  | 1
Croatia | Additional |  |  |  | 2
Croatia | Additional |  |  |  | 3
Finland | First |  |  |  | 1
United Arab Emirates | First |  |  |  | 1
France | First |  |  |  | 1
Germany | First |  |  |  | 1
India | First |  |  |  | 1
Ireland | First |  |  |  | 1
Italy | First |  |  |  | 1
Japan | First |  |  |  | 1
Netherlands | First |  |  |  | 1
Poland | First |  |  |  | 1
South Africa | First |  |  |  | 1
South Africa | Additional |  |  |  | 2
Spain | First |  |  |  | 1
Sweden | First |  |  |  | 1
United Kingdom | First |  |  |  | 1
United States | First |  |  |  | 1
United Arab Emirates | Additional |  |  |  | 2
Italy | Additional |  |  |  | 2
Germany | Additional |  |  |  | 2
Germany | Additional |  |  |  | 3
Germany | Additional |  |  |  | 4
Spreadsheet: 707515d1607331307-using-a-list-to-reduce-worksheets-midshires-master
Sheet: PD

 |  |  |  | ADJUSTED HANDICAP |  |  |  |  |  | OFFICIAL HANDICAP |  |  |  |  | HANDICAPPING ALTERATIONS
hole | par | S/I | SHOTS | CALC | points | PAR 3 | SI/1 | SI/2 | S1/3 | SI/1 | S1/2 | S1/3 | CALC | points | EXACT | catagory | BUFFER | css | Nett | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAP |  | ZONE |  | Differential
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out |  |  |  |  |  | TOTAL
total
Spreadsheet: sally_beck__33791__NA GAS AND POWER-REGION BREAKOUT 09-20-00 EM
Sheet: US POWER CHARTS

ENRON - POWER
AVERAGE EOL AND NON-EOL TRANSACTIONS PER DAY
REGION BREAKOUT
As of September 20, 2000
 |  | AVERAGE DEALS PER DAY
MONTH | DAYS | EOL | NON-EOL | TOTAL
1999-12-01 00:00:00 | 21 | 7 | 164 | 171
2000-01-01 00:00:00 | 20 | 58 | 422 | 480
2000-02-01 00:00:00 | 20 | 87 | 421 | 509
2000-03-01 00:00:00 | 23 | 108 | 460 | 568
2000-04-01 00:00:00 | 19 | 128 | 492 | 620
2000-05-01 00:00:00 | 22 | 93 | 442 | 534
2000-06-01 00:00:00 | 22 | 96 | 407 | 503
2000-07-01 00:00:00 | 19 | 152 | 473 | 626
2000-08-01 00:00:00 | 23 | 189 | 513 | 702
2000-09-01 00:00:00 | 13 | 230 | 499 | 729
TOTAL AVERAGE | 202 | 111 | 427 | 537
REGION BREAKOUT (Region breakout based on deal locations)
Spreadsheet: 59363d1259855090-auto-fill-cells-based-on-value-entered-in-first-cell-schoolquestions
Sheet: Progress and Challenges

OAKRIDGE MIDDLE SCHOOL 2009 10 PROGRESS & CHALLENGES Grade A;  87% AYP;  PREVENT I
READING | DIS 09 | FY09 | FY08 | FY07 |  |  | MATH | DIS 09 | FY09 | FY08 | FY07
TARGETS | 0.65 | 0.65 | 0.58 | 0.51 |  |  | TARGETS | 0.68 | 0.68 | 0.62 | 0.56
Total | 61 | 70 | 72 | 70 |  |  | Total | 66 | 72 | 72 | 70
White | 74 | 76 | 78 | 74 |  |  | White | 80 | 78 | 77 | 75
Hispanic | 50 | 51 | 57 | 58 |  |  | Hispanic | 56 | 58 | 61 | 57
Econ  Dis | 50 | 59 | 54 | 53 |  |  | Econ  Dis | 53 | 56 | 56 | 53
ESE | 32 | 26 | 38 | 30 |  |  | ESE | 39 | 33 | 39 | 33
6th Gr RDG | DIS 09 | FY09 | FY08 | FY07 |  |  | 6th Gr MATH | DIS 09 | FY09 | FY08 | FY07
% ≥ Level 3 | 64 | 72 | 74 | 72 |  |  | % ≥ Level 3 | 54 | 62 | 62 | 59
WORDS (18%) | 61 | 67 | 69 | 70 |  |  | NBRS (20%) | 58 | 59 | 54 | 54
M  IDEA (44%) | 69 | 71 | 77 | 70 |  |  | GEO (20%) | 64 | 68 | 76 | 62
C & C (24%) | 64 | 65 | 67 | 67 |  |  | MSR (20%) | 52 | 56 | 58 | 48
REF (13%) | 62 | 65 | 66 | 60 |  |  | ALG (18%) | 61 | 65 | 58 | 55
INFO (51%) | 61 | 64 | 69 | 66 |  |  | PROB (20%) | 60 | 64 | 71 | 60
LIT (49%) | 69 | 73 | 74 | 71
7th Gr RDG | DIS 09 | FY09 | FY08 | FY07 |  |  | 7th Gr MATH | DIS 09 | FY09 | FY08 | FY07
% ≥ Level 3 | 66 | 75 | 76 | 74 |  |  | % ≥ Level 3 | 59 | 74 | 72 | 74
WORDS (16%) | 67 | 73 | 76 | 75 |  |  | NBRS (20%) | 56 | 63 | 61 | 65
M  IDEA (47%) | 70 | 76 | 68 | 73 |  |  | GEO (18%) | 47 | 53 | 61 | 66
C & C (24%) | 66 | 71 | 75 | 80 |  |  | MSR (20%) | 60 | 68 | 63 | 58
REF (13%) | 67 | 72 | 68 | 71 |  |  | ALG (20%) | 59 | 67 | 62 | 62
INFO (58%) | 69 | 76 | 73 | 75 |  |  | PROB (20%) | 69 | 76 | 76 | 68
LIT (42%) | 66 | 71 | 68 | 73
8th Gr RDG | DIS 09 | FY09 | FY08 | FY07 |  |  | 8th Gr MATH | DIS 09 | FY09 | FY08 | FY07
% ≥ Level 3 | 54 | 61 | 65 | 60 |  |  | % ≥ Level 3 | 65 | 77 | 79 | 75
WORDS (16%) | 65 | 68 | 73 | 70 |  |  | NBRS (20%) | 62 | 69 | 71 | 62
M  IDEA (47%) | 63 | 67 | 72 | 68 |  |  | GEO (20%) | 52 | 58 | 55 | 50
C & C (29%) | 58 | 62 | 71 | 65 |  |  | MSR (20%) | 48 | 55 | 60 | 64
REF (8%) | 64 | 69 | 58 | 56 |  |  | ALG (20%) | 51 | 58 | 60 | 50
INFO (59%) | 64 | 68 | 65 | 65 |  |  | PROB (20%) | 52 | 61 | 58 | 58
LIT (41%) | 59 | 63 | 74 | 65
8th Gr WRTG | DIS 09 | FY09 | FY08 | FY07 |  |  | 8th Gr SCIENCE | DIS 09 | FY09 | FY08 | FY07
% [NAME] 3.5 | 89 | 92 | 91 | 90 |  |  | % ≥ Level 3 | 39 | 52 | 52 | 52
Mean Score | 4 3 | 4 4 | 4 3 | 4 2 |  |  | PhyChm (16%) | 56 | 64 | 67 | 52
 |  |  |  |  |  |  | E SP (47%) | 53 | 58 | 56 | 69
 |  |  |  |  |  |  | L ENV (29%) | 55 | 59 | 68 | 61
 |  |  |  |  |  |  | SC THKG (8%) | 57 | 65 | 63 | 65
Spreadsheet: 183948d1349100436-need-help-with-conditional-formatting-problem-please-help-tf-performance-2-latest-q3
Sheet: Sheet4

Ops # | Month | Date | Year | Client | Buyer | Cargo Type | Nominated Cargo Quantity (MT) | Support Craft | Invoiced Ammount ($) | Commenced Fendering | Completed Fendering | Total Fendering Time | Mooring Master
688 | September | Capital | 2011 | Vitol | Capital | PMS | 12000 | Commodore | 14815.97 | 14:10:00 | 15:14:00 | 01:04:00 | Goodness [NAME]
684 | September | Taurus | 2011 | Vitol | Taurus | PMS | 15000 | Glory | 10000 | 16:24:00 | 17:40:00 | 01:16:00 | Opuowubo [NAME]
680 | September | Deejones | 2011 | Vitol | Deejones | PMS | 13591 | Glory | 16715 | 11:00:00 | 12:00:00 | 01:00:00 | [NAME]
677 | September | Honeywell | 2011 | Vitol | Honeywell | PMS | 6700 | Mensah | 8972.22 | 08:36:00 | 09:20:00 | 00:44:00 | [NAME]
675 | September | Rainoil | 2011 | Vitol | Rainoil | PMS | 9000 | Mensah | 10005.21 | 06:30:00 | 08:15:00 | 01:45:00 | [NAME]
673 | September | Mocoh S.A. | 2011 | Vitol | [NAME] | PMS | 14500 | Glory | 14045.42 | 06:54:00 | 07:36:00 | 00:42:00 | Goodness [NAME]
672 | September | Nipco | 2011 | Vitol | Nipco | PMS | 23000 | Commodore | 18791.25 |  |  | 00:00:00 | [NAME]
671 | September | Honeywell | 2011 | Vitol | Honeywell | PMS | 14000 | Glory | 14010 | 18:00:00 | 19:05:00 | 01:05:00 | [NAME]
668 | September | Octogone Oil & Gas Ltd (Somerset→ Bellpoint ) | 2011 | Vitol | Somerset Energy | PMS | 14000 | Commodore | 13706.25 | 12:24:00 | 13:30:00 | 01:06:00 | [NAME]
657 | September |  | 2011 | Vitol | Honeywell | PMS | 8000 | Glory | 18281.25 | 10:30:00 | 11:15:00 | 00:45:00 | [NAME]
655 | September |  | 2011 | Vitol | Heyden | PMS | 7500 | Glory | 8854.17 | 14:10:00 | 15:40:00 | 01:30:00 | [NAME]
647 | September |  | 2011 | Vitol | Nipco | PMS | 22500 | Mensah | 12868.06 | 08:52:00 | 10:15:00 | 01:23:00 | [NAME]
631 | August |  | 2011 | Vitol | Heyden | PMS | 5000 | Top Fenders 1 | 20475 | 07:25:00 | 08:20:00 | 00:55:00 | [NAME]
620 | August |  | 2011 | Vitol | Sahara | PMS | 32300 | Commodore | 11763.89 | 06:35:00 | 07:45:00 | 01:10:00 | [NAME]
618 | August |  | 2011 | Vitol | Capital | PMS | 13500 | Mensah | 9041.67 | 19:12:00 | 20:54:00 | 01:42:00 | Briseimo Benedict
612 | August |  | 2011 | Vitol | Heyden | PMS | 5000 | Glory | 8244.17 | 13:10:00 | 14:17:00 | 01:07:00 | Alfred E Para
581 | July |  | 2011 | Vitol | Conoil | PMS | 18500 | Commodore | $12,364.17 | 07:30:00 | 08:48:00 | 01:18:00 | Alfred E Para
574 | July |  | 2011 | Vitol | Noble | PMS | 21280 | Other | $9,858.33 | 17:00:00 | 18:24:00 | 01:24:00 | Goodness [NAME]
556 | July |  | 2011 | Vitol | Capital | PMS | 6600 | Commodore | $7,400 | 16:50:00 | 18:00:00 | 01:10:00 | [NAME]
548 | July |  | 2011 | Vitol | [NAME] | PMS | 5000 | Glory | 4781.25 | 07:00:00 | 08:15:00 | 01:15:00 | [NAME]
Spreadsheet: 453035d1459125702-chart-days-instead-of-months-inventory
Sheet: Inventory Data

 |  |  |  | Inventory | Sales | Sales
Owner | Model | Empty1 | Empty2 | 2016-03-01 00:00:00 | 2016-03-02 00:00:00 | 2016-03-03 00:00:00 | 2016-03-04 00:00:00 | 2016-03-05 00:00:00 | 2016-03-06 00:00:00 | 2016-03-07 00:00:00
1 | S |  |  | 2222 | 3000 | 3500
2 | O |  |  | 10999 | 12333 | 9500
3 | SF |  |  | 4411 | 5000 | 4590
4 | S |  |  | 50 | 68 | 75
5 | O |  |  | 22 | 50 | 60
6 | SF |  |  | 10 | 40 | 75
Spreadsheet: daren_farmer__5026__SDSNOM
Sheet: Sheet1

SDSNOM.xls
TO:    [NAME]
CC:   [NAME], [NAME], [NAME]/HPL
FROM:   [NAME] (Previously TUFCO) |  |  |  |  |  |  |  |  |  |  | June |  | 35 |  | 30
 |  |  |  |  |  |  |  |  |  |  | July |  | 35 |  | 31
SUBJECT:   Gas Sales and Purchase Contract between TXU Fuels and SDS |  |  |  |  |  |  |  |  |  |  | August |  | 35 |  | 31
Nomination of Estimated Monthly Quantity |  |  |  |  |  |  |  |  |  |  | September |  | 25 |  | 30
 |  |  |  |  |  |  |  |  |  |  | October |  | 20 |  | 31
 |  |  |  |  |  |  |  |  |  |  | November |  | 0 |  | 30
 |  | Date |  | Estimated |  | Estimated |  |  |  |  | December |  | 24.516 |  | 31
Nomination Month |  | Nominated |  | Daily Quantity |  | Monthly Quantity
 |  |  |  | MMBtu |  | MMBtu
2001 |  |  |  |  |  |  |  |  |  |  |  | Period Average -
January |  | 2000-12-21 00:00:00 |  | 30000
February |  | 2001-01-25 00:00:00 |  | 30000
March |  | 2001-02-22 00:00:00 |  | 20000 |  |  |  |  |  |  | January |  | 30 |  | 31
April |  | 2001-03-23 00:00:00 |  | 20000 |  |  |  |  |  |  | February |  | 30 |  | 28
May |  |  |  |  |  |  |  |  |  |  | March |  | 20 |  | 31
June |  |  |  |  |  |  |  |  |  |  | April |  | 20 |  | 30
July |  |  |  |  |  |  |  |  |  |  | May |  | 20 |  | 31
August |  |  |  |  |  |  |  |  |  |  | June |  | 30 |  | 30
September |  |  |  |  |  |  |  |  |  |  | July |  | 35 |  | 31
October |  |  |  |  |  |  |  |  |  |  | August |  | 35 |  | 31
November |  |  |  |  |  |  |  |  |  |  | September |  | 35 |  | 30
December |  |  |  |  |  |  |  |  |  |  | October |  | 22.1 |  | 31
 |  |  |  |  |  |  |  |  |  |  | November |  | 0 |  | 30
 |  |  |  |  | Total |  |  |  |  |  | December |  | 20 |  | 31
 |  |  |  |  |  |  |  |  |  |  |  | Period Average -
Note:  Please advise immediately should you have any questions concerning the above.
C:      R. Skerik
D. Avila
G. Green
M. Jones
Spreadsheet: 41d15a5a-fefe-4fd8-8aa6-ae5a1d232096
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: |  |  | 2011-11-01 09:41:52.110000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.5 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.375 | 101.713 | 101.588 | 101.463 | 101.088
4.25 | 101.295 | 101.17 | 101.045 | 100.67 |  | Note: | Refer To Price [NAME]
4.125 | 100.957 | 100.832 | 100.707 | 100.332 |  |  | For all Price Adjs
4 | 100.502 | 100.377 | 100.252 | 99.627
3.875 | 99.965 | 99.84 | 99.715 | 99.09
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 101.715 | 101.59 | 101.465 | 101.09
3.75 | 101.289 | 101.164 | 101.039 | 100.664
3.625 | 100.899 | 100.774 | 100.649 | 100.274
3.5 | 100.551 | 100.426 | 100.301 | 99.926
3.375 | 100.153 | 100.028 | 99.903 | 99.278
3.25 | 99.663 | 99.538 | 99.413 | 98.788
 |  |  |  |  |  | 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 | 2011-11-15 09:41:52.110000
30 DAY | 2011-11-30 09:41:52.110000
45 DAY | 2011-12-15 09:41:52.110000
60 DAY | 2011-12-30 09:41:52.110000
90 DAY | 2012-01-29 09:41:52.110000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 714006d1611056656-using-if-statement-with-a-unique-id-example-sheet
Sheet: Sheet2

UNIQUE ID | AGENT NAME | DATE | ADHERENCE | PICK UP % | FOLLOW UP
 | Agent 1 | 2021-01-04 00:00:00
 | Agent 2 | 2021-01-04 00:00:00
 | Agent 3 | 2021-01-04 00:00:00
 | Agent 4 | 2021-01-04 00:00:00
 | Agent 5 | 2021-01-04 00:00:00
 | Agent 6 | 2021-01-04 00:00:00
 | Agent 7 | 2021-01-04 00:00:00
 | Agent 8 | 2021-01-04 00:00:00
 | Agent 9 | 2021-01-04 00:00:00
 | Agent 10 | 2021-01-04 00:00:00
 | Agent 11 | 2021-01-04 00:00:00
 | Agent 12 | 2021-01-04 00:00:00
 | Agent 13 | 2021-01-04 00:00:00
 | Agent 14 | 2021-01-04 00:00:00
 | Agent 15 | 2021-01-04 00:00:00
 | Agent 16 | 2021-01-04 00:00:00
 | Agent 17 | 2021-01-04 00:00:00
 | Agent 18 | 2021-01-04 00:00:00
 | Agent 19 | 2021-01-04 00:00:00
 | Agent 20 | 2021-01-04 00:00:00
 | Agent 21 | 2021-01-04 00:00:00
 | Agent 22 | 2021-01-04 00:00:00
 | Agent 23 | 2021-01-04 00:00:00
 | Agent 24 | 2021-01-04 00:00:00
 | Agent 25 | 2021-01-04 00:00:00
 | Agent 26 | 2021-01-04 00:00:00
 | Agent 27 | 2021-01-04 00:00:00
 | Agent 28 | 2021-01-04 00:00:00
 | Agent 29 | 2021-01-04 00:00:00
 | Agent 30 | 2021-01-04 00:00:00
 | Agent 31 | 2021-01-04 00:00:00
 | Agent 32 | 2021-01-04 00:00:00
 | Agent 33 | 2021-01-04 00:00:00
Spreadsheet: 679553d1590492676-number-items-in-a-list-that-are-not-chosen-example-list
Sheet: Development

#
1 |  | Adam
2 |  | [NAME]
3 |  | [NAME]
4 |  | [NAME]
5 |  | [NAME]
6 |  | [NAME]
7 |  | George
8 |  | [NAME]
9 |  | [NAME]
10 |  | [NAME]
11 |  | [NAME]
12 |  | [NAME]
13 |  | Mark
14 |  | Nathan
15 |  | Ozzie
16 |  | [NAME]
17 |  | Quinn
18 |  | Rodger
19 |  | [NAME]
20 |  | [NAME]
21 |  | Umberto
22 |  | Victor
23 |  | Walter
24 |  | Xander
Spreadsheet: 486334d1477422162-22-people-randomized-into-4-groups-excel-forum-example-bsb2-
Sheet: groups

 | [NAME]
 | student2
 | student3
 | student4
 | [NAME]
 | student6
 | student7
 | student8
 | student9
 | student10
 | student11
 | student12
 | student13
 | student14
 | student15
 | student16
 | student17
 | student18
 | student19
 | student20
 | student21
 | student22
 | group 1 | group 2 | group 3 | group 4
Spreadsheet: 854780d1704538211-main-contributor-q1
Sheet: Sheet1

What I have: |  |  |  | What I want:
Department | Product | Profit |  | The total profit of all departments is 25.
A | AA | -5 |  | The profit of department A is 20 and the main contributing product is AC with a profit of 15.
A | AB | 10 |  | The profit of department B is 25 and the main contributing product is AD with a profit of 15.
A | AC | 15 |  | The profit of department C is negative 20 and the main contributing product is AB with a negative profit of 15.
A | AD | 0
B | AA | 5
B | AC | 5
B | AD | 15
C | AB | -15 |  |  |  | Row Labels | Sum of Profit | [NAME] of Profit2
C | AC | -10 |  |  |  | A | 20 | 15
C | AD | -5 |  |  |  | B | 25 | 15
C | AE | 10 |  |  |  | C | -20 | 10
 |  |  |  |  |  | Grand Total | 25 | 15
Spreadsheet: 815972d1675288454-formula-to-calculate-new-worth-based-on-todays-date-sample6
Sheet: Sheet1

 |  |  |  | Today's Date
Assets |  |  | Current Net Worth |  | [NAME] Here
Asset 1 |  |  | Asset 2 |  |  | Asset 3
Month | Amount |  | Month | Amount |  | Month | Amount
Jan | 5000 |  | Jan | 250 |  | Jan | 2000
Feb | 5250 |  | Feb | 330 |  | Feb | 2100
Mar | 5500 |  | Mar | 450 |  | Mar | 1900
Apr | 6000 |  | Apr | 510 |  | Apr | 1600
May | 6500 |  | May | 550 |  | May | 1400
Jun |  |  | Jun |  |  | Jun
Jul |  |  | Jul |  |  | Jul
Aug |  |  | Aug |  |  | Aug
Sep |  |  | Sep |  |  | Sep
Oct |  |  | Oct |  |  | Oct
Nov |  |  | Nov |  |  | Nov
Dec |  |  | Dec |  |  | Dec
Spreadsheet: 697921d1601620711-ranking-based-on-criteria-test
Sheet: Test

 |  |  |  |  |  |  | 2020-04-01 00:00:00
Item | Price | Category | Date | Rank | Desired Rank
CTR_01 | 3.5 | Urgent | 2020-04-04 00:00:00 |  | 1
[NAME] | 3.2 | Not Urgent | 2020-04-05 00:00:00 |  |  |  |  |  | * Ranking is needed for only urgent item based on there price and date
CTR_03 | 3.44 | Not Urgent | 2020-04-06 00:00:00
CTR_08 | 3.44 | Urgent | 2020-05-11 00:00:00 |  | 2
CTR_18 | 3.44 | Urgent | 2020-04-21 00:00:00 |  | 2
CTR_06 | 3.4 | Urgent | 2020-04-09 00:00:00 |  | 3
CTR_07 | 3.2 | Urgent | 2020-04-06 00:00:00 |  | 4
CTR_17 | 3.2 | Urgent | 2020-04-20 00:00:00 |  | 4
CTR_09 | 3 | Not Urgent | 2020-04-12 00:00:00
CTR_10 | 2.1 | Not Urgent | 2020-04-06 00:00:00
CTR_11 | 3.4 | Not Urgent | 2020-05-14 00:00:00
CTR_12 | 3.2 | Not Urgent | 2020-04-15 00:00:00
CTR_13 | 3.44 | Not Urgent | 2020-04-16 00:00:00
CTR_14 | 3 | Not Urgent | 2020-04-17 00:00:00
CTR_15 | 2.1 | Not Urgent | 2020-04-18 00:00:00
CTR_16 | 3.4 | Not Urgent | 2020-04-19 00:00:00
CTR_04 | 3 | Urgent | 2020-04-06 00:00:00 |  | 5
CTR_19 | 3 | Urgent | 2020-04-06 00:00:00 |  | 5
CTR_05 | 2.1 | Urgent | 2020-04-08 00:00:00 |  | 6
CTR_20 | 2.1 | Urgent | 2020-04-23 00:00:00 |  | 6
Spreadsheet: 0c9447f1-18f2-4e3e-a1eb-150e516047e2
Sheet: Sheet1

Unnamed: 0 | Team | Wins | Loss | Tie | PCT | GB | Gaveup | Runs
1 | Heartbreakers | 6 | 2 | 0 | 0.75 | --- | 115 | 117
2 | In Heat | 6 | 2 | 0 | 0.75 | --- | 79 | 95
3 | Boom See That | 4 | 4 | 0 | 0.5 | 2 | 92 | 131
4 | Diamonds | 3 | 5 | 0 | 0.375 | 3 | 95 | 100
5 | Bad Pitches | 0 | 8 | 0 | 0 | 6 | 126 | 64
Spreadsheet: 466796d1466447217-report-formula-query-profitability-may-2016
Sheet: Raw Data (DO NOT TOUCH)

Project | Quantity | Cost Amount | Charge Amount | Invoiced | Date
Twenty | 1 | 32 | 100 |  | 2016-02-01 00:00:00
Thirty | 1 | 32 | 100 |  | 2016-02-01 00:00:00
Twenty |  |  |  | 13823 | 2016-02-01 00:00:00
Thirty |  |  |  | 1950 | 2016-02-01 00:00:00
Twenty | 1 | 52 | 160 |  | 2016-03-01 00:00:00
Thirty | 1 | 52 | 160 |  | 2016-03-01 00:00:00
Twenty |  |  |  | 12001 | 2016-03-01 00:00:00
Thirty |  |  |  | 12433 | 2016-03-01 00:00:00
Twenty | 1 | 13 | 150 |  | 2016-01-01 00:00:00
Thirty | 1 | 13 | 150 |  | 2016-01-01 00:00:00
Twenty |  |  |  | 100 | 2016-01-01 00:00:00
Thirty |  |  |  | 10000 | 2016-01-01 00:00:00
Twenty | 1 | 20 | 120 | 1655 | 2015-02-05 00:00:00
Thirty | 1 | 10 | 500 | 3413 | 2014-02-02 00:00:00
Twenty |  |  |  | 85250 | 2014-02-02 00:00:00
Thirty |  |  |  | 14200 | 2014-02-02 00:00:00
Spreadsheet: 864214d1711470197-stop-changing-formula-pool-league_1
Sheet: Players

To Add Weekly Scores: Right click on column G and click [NAME] to add a new column. Add Date and Scores in New Column "G" |  |  |  |  | a
To Add a New Player: Right Click on Row Number below the Last Player. [NAME] and [NAME], APPG and APPM cells from above player to new player.
To Arrange Players By Team: Left Click and Hold Row Number of First Player and drag to Last Player. [NAME] tab and then on Sort. Then [NAME].
Sort By "Column B", "Cell Value" and "Smallest to Largest" and click OK
Name | Team Number |  |  |  | a
 |  | Handicap | APPG | APPM | a |  | 2023-01-07 00:00:00 | 2023-01-06 00:00:00 | 2023-01-05 00:00:00 | 2023-01-05 00:00:00 | 2023-01-05 00:00:00 | 2023-01-04 00:00:00 | 2023-01-03 00:00:00 | 2023-01-02 00:00:00
 |  |  |  |  | a |  | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45
 |  |  |  |  | a |  | 63 | 45 | 55 | 45 | 45 | 55 | 45 | 45
 |  |  |  |  | a |  | 45 | 23 | 23 | 45 | 34 | 43 | 37 | 45
 |  |  |  |  | a |  | 24 | 23 | 54 | 65 | 45 | 45 | 47 | 53
 |  |  |  |  |  |  | 34 | 61 | 23 | 34 | 43 | 34 | 27 | 43
 |  |  |  |  | a |  | 45 | 45 | 65 | 45 | 45 | 42 | 51 | 45
 |  |  |  |  |  |  | 45 | 45
 |  |  |  |  | a | 45
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
Spreadsheet: 765428d1643311945-sumifs-counts-single-cell-twice-copy-of-book1
Sheet: Sheet1

Sample name | Number of samples | Type of analysis | Helper | GMO |  |  |  |  | corn
Corn seed | 1 | GMO A |  | Corn |  |  |  |  | polenta
Corn gold pellets | 6 | GMO A |  | Soybean |  |  |  |  | maize
Soybean | 3 | Purity A
corn maize | 2 | GMO B |  | Purity
Corn polenta | 1 | GMO C |  | Corn
[NAME] | 2 | Purity B |  | Soybean
Cat food maize | 2 | GMO A
Corn seed | 14 | Purity A