tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 40456d1238768310-excel-formula-required-to-calculate-number-of-days-remaining-days-remaining
Sheet: Sheet1

2 | 4 | 6 | 0.2608695652173913 | 23 days | Day | Current Month | Weekday Sunday  Count | Days Remaining | ????? | Days Remaining | Sundays | weekend Days
 |  |  |  |  | 1 | 1/4/2009 | 0 | 25 | 0.24 | 25 | 4 | 8
 |  |  |  |  | 2 | 2/4/2009 | 0 | 24 | 0.25 | 24 | 4 | 8
 |  |  |  |  | 3 | 3/4/2009 | 0 | 23 | 0.2608695652173913 | 23 | 4 | 8
 |  |  |  |  | 4 | 4/4/2009 | 0 | 22 | 0.2727272727272727 | 22 | 4 | 7
 |  |  |  |  | 5 | 5/4/2009 | 1 | 22 | 0.2727272727272727 | 22 | 3 | 6
 |  |  |  |  | 6 | 6/4/2009 | 1 | 21 | 0.2857142857142857 | 21 | 3 | 6
 |  |  |  |  | 7 | 7/4/2009 | 1 | 20 | 0.3 | 20 | 3 | 6
 |  |  |  |  | 8 | 8/4/2009 | 1 | 19 | 0.3157894736842105 | 19 | 3 | 6
 |  |  |  |  | 9 | 9/4/2009 | 1 | 18 | 0.3333333333333333 | 18 | 3 | 6
 |  |  |  |  | 10 | 10/4/2009 | 1 | 17 | 0.3529411764705883 | 17 | 3 | 6
 |  |  |  |  | 11 | 11/4/2009 | 1 | 16 | 0.375 | 16 | 3 | 5
 |  |  |  |  | 12 | 12/4/2009 | 2 | 16 | 0.375 | 16 | 2 | 4
 |  |  |  |  | 13 | 13/4/2009 | 2 | 15 | 0.4 | 15 | 2 | 4
 |  |  |  |  | 14 | 14/4/2009 | 2 | 14 | 0.4285714285714285 | 14 | 2 | 4
 |  |  |  |  | 15 | 15/4/2009 | 2 | 13 | 0.4615384615384616 | 13 | 2 | 4
 |  |  |  |  | 16 | 16/4/2009 | 2 | 12 | 0.5 | 12 | 2 | 4
 |  |  |  |  | 17 | 17/4/2009 | 2 | 11 | 0.5454545454545454 | 11 | 2 | 4
 |  |  |  |  | 18 | 18/4/2009 | 2 | 10 | 0.6 | 10 | 2 | 3
 |  |  |  |  | 19 | 19/4/2009 | 3 | 10 | 0.6 | 10 | 1 | 2
 |  |  |  |  | 20 | 20/4/2009 | 3 | 9 | 0.6666666666666666 | 9 | 1 | 2
 |  |  |  |  | 21 | 21/4/2009 | 3 | 8 | 0.75 | 8 | 1 | 2
 |  |  |  |  | 22 | 22/4/2009 | 3 | 7 | 0.8571428571428571 | 7 | 1 | 2
 |  |  |  |  | 23 | 23/4/2009 | 3 | 6 | 1 | 6 | 1 | 2
 |  |  |  |  | 24 | 24/4/2009 | 3 | 5 | 1.2 | 5 | 1 | 2
 |  |  |  |  | 25 | 25/4/2009 | 3 | 4 | 1.5 | 4 | 1 | 1
 |  |  |  |  | 26 | 26/4/2009 | 4 | 4 | 1.5 | 4 | 0 | 0
 |  |  |  |  | 27 | 27/4/2009 | 4 | 3 | 2 | 3 | 0 | 0
 |  |  |  |  | 28 | 28/4/2009 | 4 | 2 | 3 | 2 | 0 | 0
 |  |  |  |  | 29 | 29/4/2009 | 4 | 1 | 6 | 1 | 0 | 0
 |  |  |  |  | 30 | 30/4/2009 | 4 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 31 |  |  | 0 | 0
Spreadsheet: 801373d1666180704-need-to-calculate-two-different-answers-sheet1-afternoons
Sheet: Sheet1

name | MORNINGS ONLY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY |  | TOTAL AFTERNOONS
example | x |  |  | x | x | x
example | x
example |  | x | x
Spreadsheet: 843031d1695005789-modify-formula-to-retrieve-value-from-sheet-1-to-sheet-2-sample-book_finish_placement-copy
Sheet: Sheet2

 |  |  |  |  | Desired Result on yellow
 |  |  |  | Name | Place | What I'm trying to achieve;
 |  |  |  | [NAME] |  | [NAME] on F5 to be modify to look on SHEET 1 for values 3 and 4 on columns [NAME]:K25, S12:S25, AA12:AA25, AI12:AI25, if value is 3, to retrieve value from SHEET1 Q10 to column F, if value is 4, to retrieve value from  Y10
 |  |  |  | [NAME] |  |  |  |  |  | Place |  |  |  |  |  | Place
 |  |  |  | [NAME] |  |  |  |  | 3rd= | 17 |  |  |  |  | 4th= | 25
 |  |  |  | [NAME] |  |  |  | H1 |  |  | H2 |  |  | H3 |  |  | H4
 |  |  |  | [NAME] | 53 |  |  | [NAME] | 4 |  | [NAME] | 1 |  | [NAME] | 1 |  | Pablo Díaz | 1
 |  |  |  | [NAME] | 53 |  |  | [NAME] | 2 |  | [NAME] | 4 |  | Hector Santamaría | 3 |  | [NAME] | 2
 |  |  |  | Esteban Chaves Morua |  |  |  | [NAME] | 3 |  | [NAME] | 2 |  | [NAME] | 2 |  | [NAME] | 3
 |  |  |  | [NAME] | 53 |  |  | [NAME] | 1 |  | [NAME] | 3 |  | Moises Montalvo | 4 |  | [NAME] | 4
 |  |  |  | [NAME] |  |  |  | H5 | Plc. |  | H6 | [NAME] |  | H7 | [NAME] |  | H8 | [NAME]
 |  |  |  | [NAME] | 41 |  |  | [NAME] | 3 |  | Ricardo Delgado | 2 |  | Esteban Chaves Morua | 2 |  | [NAME] | 3
 |  |  |  | [NAME] |  |  |  | [NAME] | 2 |  | [NAME] | 3 |  | Micha Cantor | 3 |  | Shane Kertesz | 1
 |  |  |  | [NAME] | 41 |  |  | [NAME] | 1 |  | [NAME] | 1 |  | [NAME] Orias | 1 |  | Lucas Madrid | 2
 |  |  |  | Giovanni Marín | 41 |  |  | [NAME] | 4 |  | [NAME] | 4 |  | [NAME] | 4 |  | Mikel Kauffmann | 4
 |  |  |  | [NAME] |  |  |  | H9 | [NAME] |  | H10 | [NAME] |  | H11 | [NAME] |  | H12 | [NAME]
 |  |  |  | Hector Santamaría | 53 |  |  | Israel Barona | 1 |  | [NAME] | 3 |  | [NAME] | 1 |  | [NAME] | 1
 |  |  |  | Israel Barona |  |  |  | [NAME] | 3 |  | [NAME] | 2 |  | [NAME] | 3 |  | [NAME] | 2
 |  |  |  | [NAME] Orias |  |  |  | Ricardo Lucke | 2 |  | [NAME] | 1 |  | [NAME] | 4 |  | Giovanni Marín | 3
 |  |  |  | [NAME] |  |  |  | [NAME] | 4 |  | [NAME] | 4 |  | [NAME] | 2 |  | [NAME] | 4
 |  |  |  | [NAME] | 53
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME] | 41
 |  |  |  | [NAME] | 53
 |  |  |  | [NAME] | 41
 |  |  |  | [NAME]
 |  |  |  | Lucas Madrid | 53
 |  |  |  | [NAME]
 |  |  |  | [NAME] | 53
 |  |  |  | Micha Cantor | 41
 |  |  |  | [NAME]
 |  |  |  | Mikel Kauffmann
 |  |  |  | Moises Montalvo | 41
 |  |  |  | [NAME]
 |  |  |  | [NAME] | 53
 |  |  |  | Pablo Díaz | 53
 |  |  |  | [NAME] | 41
 |  |  |  | Ricardo Delgado
 |  |  |  | Ricardo Lucke
 |  |  |  | [NAME] | 41
 |  |  |  | [NAME]
 |  |  |  | [NAME] | 41
 |  |  |  | Shane Kertesz
 |  |  |  | [NAME]
 |  |  |  | [NAME] | 53
 |  |  |  | [NAME]
 |  |  |  | [NAME] | 41
 |  |  |  | [NAME] | 41
 |  |  |  | [NAME] | 53
Spreadsheet: 95963d1295464164-index-match-vlookup-help-book1
Sheet: Smith Log

TRAINING ITEM | TYPE | REQUIRED | COMPLETE DATE | DUE DATE | TRAINEE INITIALS | CERTIFIER INITIALS
Training Item 1 | TASK | Six controls every 6 months | 2011-01-01 00:00:00
Training Item 2 | TASK | Every 6 months | 2010-11-05 00:00:00
Training Item 3 | TASK | Every 6 months | 2010-10-05 00:00:00
Training Item 4 | TASK | Every 6 months | 2010-12-05 00:00:00
Training Item 5 | TASK | Every 6 months | 2011-01-02 00:00:00
Training Item 6 | TASK | Every 6 months | 2011-01-03 00:00:00
Training Item 7 | ACAD / TASK | Every 6 months | 2011-01-04 00:00:00
Training Item 8 | ACAD / TASK | Every 6 months | 2011-01-05 00:00:00
NAME OF TRAINEE (Last, First, Middle Initial)
Spreadsheet: 03dae1ef-4368-414b-9ea2-cdd21809f6f4
Sheet: LEA MOE Flexibility Form

LEA MOE Flexibility (§300.205)
For any fiscal year for which the IDEA Part B allocation received by an LEA exceeds the amount the LEA received for the previous fiscal year, the LEA may reduce the level of expenditures otherwise required for MOE by not more than 50 percent of the amount of that excess. (34 CFR §300.205).  Please refer to the USOE TA Memos on MOE dated 4-6-10 for additional details.
[NAME] |  | Date
Part One
Prior Fiscal Year Part B Allocation (611 and 619) |  | 0
Current Fiscal Year Allocation (611 and 619) |  | 0
Total Increase in Allocation
Part Two
LEA is not using CEIS funds:
Maximum amount available for MOE reduction if LEA is not using CEIS
 | Actual Amount LEA Used for MOE Reduction | 0
LEA is using CEIS funds:
Maximum amount available for CEIS - may not exceed 15% (611 and 619)
 | Actual LEA Expenditure on CEIS | 0
 | Amount that LEA may reduce MOE by
 | (maximum amount available for MOE reduction - amount spent on CEIS)
 | Actual Amount LEA Used for MOE Reduction | 0
Part Three
Requirements: Funds freed up by reducing the MOE by up to 50% of the increase in funding must be used for activities that could be supported under the Elementary and Secondary Education Act. The USOE will annually collect from the LEA and report information on the use of the freed-up funds.
Description of ESEA Activity (LEA Use of Freed-up Funds) |  | Amount
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
Total (Must Match Actual Amount LEA Used for MOE Reduction)
Spreadsheet: 94016d1293791553-copying-data-from-a-table-to-another-one-example-fix
Sheet: DEC.

P1
JANUARY | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 | W | W | WP | P | V | V | V | V | V | V | V | P | P | P | P | W | W | P | P | P | P | P | W | P | P | P | P | P | P | W | P
FEBRUARY | 2010-02-01 00:00:00 | 2010-02-02 00:00:00 | 2010-02-03 00:00:00 | 2010-02-04 00:00:00 | 2010-02-05 00:00:00 | 2010-02-06 00:00:00 | 2010-02-07 00:00:00 | 2010-02-08 00:00:00 | 2010-02-09 00:00:00 | 2010-02-10 00:00:00 | 2010-02-11 00:00:00 | 2010-02-12 00:00:00 | 2010-02-13 00:00:00 | 2010-02-14 00:00:00 | 2010-02-15 00:00:00 | 2010-02-16 00:00:00 | 2010-02-17 00:00:00 | 2010-02-18 00:00:00 | 2010-02-19 00:00:00 | 2010-02-20 00:00:00 | 2010-02-21 00:00:00 | 2010-02-22 00:00:00 | 2010-02-23 00:00:00 | 2010-02-24 00:00:00 | 2010-02-25 00:00:00 | 2010-02-26 00:00:00 | 2010-02-27 00:00:00 | 2010-02-28 00:00:00
[NAME] | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
APRIL | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
MAY | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
[NAME] | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
JULY | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
AUGUST | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
SEPTEMBER | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
OCTOBER | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
NOVEMBER | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
DECEMBER | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
Spreadsheet: 92519050-4ae8-4acb-9da2-817d8bbaee0c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
TYPES OF DEPOSITS: |  |  | SEPTEMBER 30 |  |  | DEPOSITS |  |  | WITHDRAWALS |  |  | OCTOBER 31
CHECKING ACCOUNTS
WELLS FARGO GENERAL CHECKING |  | $ | 20383.28 |  | $ | 684150.94 |  | $ | 684479.36 |  | $ | 20054.86
PACIFIC WESTERN NAT BANK RDA PROGRAMS (SBA/FTHB/HPP) |  |  | 2146.03 |  |  | 0 |  |  | 0 |  |  | 2146.03
SUB-TOTAL |  | $ | 22529.31 |  | $ | 684150.94 |  | $ | 684479.36 |  | $ | 22200.89
OTHER INVESTMENTS:
LOCAL AGENCY INVESTMENT FUND (LAIF) |  | $ | 19611055.61 |  | $ | 301759.13 |  | $ | 1292000 |  | $ | 18620814.74
LOS ANGELES COUNTY POOL (LACIP) |  |  | 2048423.26 |  |  | 7955.57 |  |  | 0 |  |  | 2056378.83
SUB-TOTAL |  | $ | 21659478.87 |  | $ | 309714.7 |  | $ | 1292000 |  | $ | 20677193.57
TOTAL |  | $ | 21682008.18 |  | $ | 993865.64 |  | $ | 1976479.36 |  | $ | 20699394.46
COMMUNITY FACILITIES DISTRICT REVENUE FUND
WELLS FARGO BANK C.F.D. CHECKING |  | $ | 1968.41 |  | $ | 738083.24 |  | $ | 739694.32 |  | $ | 357.33
LOS ANGELES COUNTY POOL (LACIP) |  |  | 705135.26 |  |  | 8351.91 |  |  | 564000 |  |  | 149487.17
TOTAL FOR C.F.D. REVENUE FUND |  | $ | 707103.67 |  | $ | 746435.15 |  | $ | 1303694.32 |  | $ | 149844.5
It has been verified that this investment portfolio is in conformity with the City of West Covina's investment policy which was approved by the City Council on January 18, 2005.
The investment portfolio provides sufficient cash flow liquidity to meet estimated expenditures for the next six months. This report is accurate with respect to all information received as of November 21, 2007.
EARNED INTEREST YIELD THIS PERIOD:  5.137% |  |  |  |  |  | SIX-MONTH TREASURY BILL YIELD:  4.010%
REVIEWED BY: |  |  |  |  |  | PREPARED BY:
_________________________________________________ |  |  |  |  |  | _________________________________________________
[NAME], City Controller |  |  |  |  |  | [NAME], Revenue Services Supervisor
SUBMITTED BY: |  |  |  |  |  | APPROVED BY:
_________________________________________________ |  |  |  |  |  | _________________________________________________
[NAME], Finance Director |  |  |  |  |  | [NAME], City Treasurer
Spreadsheet: daren_farmer__5562__HPLN1104
Sheet: Sheet1

HPLN1104.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LAURA BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - November 4, 2000
 |  |  |  |  |  | **Sat/Sun | **Monday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 11/4-5/2000 | 2000-11-06 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs. | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL
 |  |  |  |  | 0 to 0  0900hrs | 0 to 0  0900hrs | 0 to 0  0900hrs
 |  |  |  |  | 0  to 0 2100hrs | 0  to 0 2100hrs | 0  to 0 2100hrs
 |  | Firm Summary
Enron (S) |  | Sandhills |  | HPL | 8 | 8 | 8
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 199602d1355256553-formula-in-cell-to-result-in-a-1-5-score-via-vlookup-media-trackingv6_reply
Sheet: Tables - Gross Profit

Avg Daily Sales (Avg)
 |  |  |  |  |  |  |  |  |  | Vlookup Table
Medium |  |  |  |  |  |  |  |  |  | Points Score |  |  |  | Gross Profit Compared
 | TV | Radio |  |  |  |  |  |  |  | -100000 | 1
Brisbane |  |  |  |  |  |  |  |  |  | -2000 | 2 |  |  |  | Low | High | Pts
Adelaide |  |  |  |  |  |  |  |  |  | -1000 | 2.5 |  |  |  | 5000 | + | 5
Perth |  |  |  |  |  |  |  |  |  | 1000 | 3 |  |  |  | 3000 | 5000 | 4
Sydney |  |  |  |  |  |  |  |  |  | 3000 | 4 |  |  |  | 1000 | 3000 | 3
Melbourne |  |  |  |  |  |  |  |  |  | 5000 | 5 |  |  |  | -1000 | 1000 | 2.5
Newcastle |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -2000 | -1000 | 2
Gold Coast |  |  |  |  |  |  |  |  |  |  |  |  |  |  | + | -2000 | 1
ACT
TV Station
 | Seven Network | Nine Network | Network Ten | Prime7 | NBN | SCA | WIN
Brisbane
Adelaide
Perth
Sydney
Melbourne
Newcastle
Gold Coast
ACT
Radio Station
 | ATN | 97.3 | Triple M | Beat 105 | Nova | Sea FM | Gold FM | Hot Tomato | 2DAY | Mix | WSFM | FOX FM | 92.9 | 96FM | NXFM | KOFM | SAFM | 104.7
Brisbane
Adelaide
Perth
Sydney
Melbourne
Newcastle
Gold Coast
ACT
TV Reach % |  |  |  |  |  |  | TV Frequency %
 | 0-50% | 50-60% | 60-70% | 70-80% | 80-100% |  |  | 0-40% | 40-50% | 50-60% | 60-70% | 70-100%
Brisbane |  |  |  |  |  |  | Brisbane
Adelaide |  |  |  |  |  |  | Adelaide
Perth |  |  |  |  |  |  | Perth
Sydney |  |  |  |  |  |  | Sydney
Melbourne |  |  |  |  |  |  | Melbourne
Newcastle |  |  |  |  |  |  | Newcastle
Gold Coast |  |  |  |  |  |  | Gold Coast
ACT |  |  |  |  |  |  | ACT
Radio Reach % |  |  |  |  |  |  | Radio Frequency %
 | 0-50% | 50-60% | 60-70% | 70-80% | 80-100% |  |  | 0-40% | 40-50% | 50-60% | 60-70% | 70-100%
Brisbane |  |  |  |  |  |  | Brisbane
Adelaide |  |  |  |  |  |  | Adelaide
Perth |  |  |  |  |  |  | Perth
Sydney |  |  |  |  |  |  | Sydney
Melbourne |  |  |  |  |  |  | Melbourne
Newcastle |  |  |  |  |  |  | Newcastle
Gold Coast |  |  |  |  |  |  | Gold Coast
ACT |  |  |  |  |  |  | ACT
Spreadsheet: 687194d1595014390-top-3-most-frequent-text-book1
Sheet: Sheet1

Search |  |  |  |  |  | Rank | Search | Frequency
dog |  |  |  |  |  | #1
Bird |  |  |  |  |  | #2
DOG |  |  |  |  |  | #3
dog
dog
Cat
cat
CAT
fish
dog
bird
tiger
cat
fish
fish
Spreadsheet: 108493d1305562234-survey-results-array-formula-survey-results
Sheet: Sheet1

 | Results
 |  | A. 1-2 | B. 3-4
 | q1a
 | q1b
 | q1c
 | q1d
 | q1e
 | q1f
 | Data Set
 | srvyname | q1a | q1b | q1c | q1d | q1e | q1f | q2
 | Staff1 | N | N | Y | N | N | N | A. 1-2
 | Staff2 | Y | N | N | Y | Y | N | A. 1-2
 | Staff3 | N | N | Y | N | N | N | B. 3-4
 | Staff4 | N | N | Y | N | N | N | C. 5+
 | Staff5 | Y | N | N | Y | Y | N | A. 1-2
 | Staff6 | N | N | Y | N | N | N | A. 1-2
 | Staff7 | N | N | Y | N | N | N | A. 1-2
 | Staff8 | N | N | Y | N | N | N | B. 3-4
 | Staff9 | N | N | Y | N | N | N | B. 3-4
 | Staff10 | Y | N | N | Y | Y | N | A. 1-2
Spreadsheet: 151116d1334783564-ranks-a-list-of-numbers-however-ranking-whilst-ignoring-or-signs-results-copy
Sheet: Sheet1

Results
PP | Cond A | Cond B | d | Little Helper | Rank of D | Rank of + diff | Rank of - diff
1 | 9 | 5 | 4 | 4 | 10 | 4
2 | 8 | 3 | 5 | 5 | 13 | 5
3 | 10 | 6 | 4 | 4 | 10 | 4
4 | 5 | 8 | -3 | 3 | -5 |  | -5
5 | 7 | 4 | 3 | 3 | 5 | 3
6 | 9 | 6 | 3 | 3 | 5 | 3
7 | 9 | 5 | 4 | 4 | 10 | 4
8 | 8 | 4 | 4 | 4 | 10 | 4
9 | 8 | 5 | 3 | 3 | 5 | 3
10 | 8 | 4 | 4 | 4 | 10 | 4
11 | 7 | 6 | 1 | 1 | 1 | 1
12 | 7 | 4 | 3 | 3 | 5 | 3
13 | 8 | 6 | 2 | 2 | 2 | 2
Total | 103 | 66 |  | 0 | #N/A | 40 | -5
Mean | 7 | 5 |  | 0 | #N/A
 | NEEDS TO BE MINUS (D6 = -3, E -5
Note:
G7  should be -5
G17 should be -5
Spreadsheet: 61589d1262526555-two-y-axis-both-using-same-data-series-frost-20iwi-20graphsv1-1-
Sheet: 4- hand-formed

 | WDR Zone 1 |  | WDR Zone 2 |  | WDR Zone 3 |  | WDR Zone 4
 | Cambridge | London | Grendon Underwood | Wallingford | [NAME] | [NAME] | [NAME] | Rawtenstall
None | 14.48 | 8.35 | 42.27 | 25.7 | 26.64 | 24.15 | 26.68 | 27.25
WF | 41.13 | 34.81 | 57.41 | 39.7 | 54.88 | 51.45 | 31.66 | 53.28
MW | 41.3 | 34.58 | 57.37 | 39.87 | 55.73 | 52.03 | 32.51 | 57.54
EPS | 42.99 | 35.68 | 59.23 | 41.12 | 56.62 | 60 | 32.92 | 59.48
PF | 44.62 | 36.69 | 60.26 | 42.02 | 57.06 | 54.43 | 32.67 | 60.85
Hand-formed brick free water saturation (Wf) |  |  |  | 200 | kg/m3 | is 100%
75% of Wf Fmax |  |  |  | 150 | kg/m3
 |  |  |  | 100
Spreadsheet: 785262d1656317161-count-true-values-if-name-matches-with-data-in-2-other-columns-count-example
Sheet: Count Example

[NAME] | True |  | [NAME] | 4
[NAME] | True |  | [NAME] | 3
[NAME] | True |  | [NAME] | 2
[NAME] | True
[NAME] | False
[NAME] | True |  | I just want column E to count all the TRUE values if the names match between both sets of columns if that makes sense, the counts would be the numbers in Column E if the formula is correct.
[NAME] | True
[NAME] | True
[NAME] | True
[NAME] | True
Spreadsheet: 96709d1296037223-how-to-show-a-value-dependent-on-the-value-shown-in-a-drop-down-list-test-1-
Sheet: Prices

Paper |  | Type - Shops | Master | Price
ShopsPaper | 1 | White Paper 50 - 100 Copies Single Sided (Minimum Charge) - includes Master - Shops Paper | 0 | 1.75
CustomersPaper | 2 | White Paper 50 - 100 Copies Double Sided (Minimum Charge) - Includes Master - Shops Paper | 0 | 2.5
 | 3 | White Paper 100+ Copies Single Sided (Minimum Charge) - Shops Paper | 0.25 | 0.02
 | 4 | White Paper 100+ Copies Double Sided (Minimum Charge) - Shops Paper | 0.25 | 0.02
 | 5 | Coloured Paper 50 - 100 Copies Single Sided (Minimum Charge) - Includes Master - Shops Paper | 0 | 2.25
 | 6 | Coloured Paper 50 - 100 Copies Double Sided (Minimum Charge) - Includes Master - Shops Paper | 0 | 3
 | 7 | Coloured Paper 100+ Copies Single Sided (Minimum Charge) - Shops Paper | 0.25 | 0.02
 | 8 | Coloured Paper 100+ Copies Double Sided (Minimum Charge) - Shops Paper | 0.25 | 0.03
 |  | Type - Customers | Master | Price
 | 9 | White Paper 50 - 100 Copies Single Sided (Minimum Charge) - includes Master - Own Paper | 0 | 0.75
 | 10 | White Paper 50 - 100 Copies Double Sided (Minimum Charge) - Includes Master - Own Paper | 0 | 1.5
 | 11 | White Paper 100+ Copies Single Sided (Minimum Charge) - Own Paper | 0.25 | 0.05
 | 12 | White Paper 100+ Copies Double Sided (Minimum Charge) - Own Paper | 0.25 | 0.01
 | 13 | Coloured Paper 50 - 100 Copies Single Sided (Minimum Charge) - Includes Master - Own Paper | 0 | 0.75
 | 14 | Coloured Paper 50 - 100 Copies Double Sided (Minimum Charge) - Includes Master - Own Paper | 0 | 1.5
 | 15 | Coloured Paper 100+ Copies Single Sided (Minimum Charge) - Own Paper | 0.25 | 0.01
 | 16 | Coloured Paper 100+ Copies Double Sided (Minimum Charge) - Own Paper | 0.25 | 0.01
Spreadsheet: 3a830485-b87a-451a-aa8a-ad6718fb3dc0
Sheet: Sheet1

Table 1--U.S. rice supply and use  1/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Item | 2006/07 | 2007/08 | 2008/09 | 2009/10 | 2010/11 | 2011/12 | 2012/13
 |  |  |  |  |  | 2/ | 2/
TOTAL RICE |  |  |  | Million acres
Area:
Planted | 2.838 | 2.761 | 2.995 | 3.135 | 3.636 | 2.689 | 2.661
Harvested | 2.821 | 2.748 | 2.976 | 3.103 | 3.615 | 2.618 | 2.64
 |  |  |  | Pounds per harvested acre
Yield | 6898 | 7219 | 6846 | 7085 | 6725 | 7067 | 7235
 |  |  |  | Million cwt
Beginning stocks | 42.992 | 39.315 | 29.492 | 30.419 | 36.499 | 48.467 | 34.476
Production | 194.585 | 198.388 | 203.733 | 219.85 | 243.104 | 185.009 | 191
Imports | 20.581 | 23.9 | 19.218 | 19.019 | 18.336 | 20 | 21.5
Total supply | 258.158 | 261.603 | 252.443 | 269.288 | 297.939 | 253.476 | 246.976
Food, industrial,
& residual 3/ | 124.671 | 123.152 | 123.77 | 120.012 | 134.502 | 114.715
Seed | 3.408 | 3.697 | 3.87 | 4.488 | 3.324 | 3.285
Total domestic use | 128.079 | 126.849 | 127.64 | 124.5 | 137.826 | 118 | 126
Exports | 90.764 | 105.262 | 94.384 | 108.341 | 111.646 | 101 | 92
Rough | 32.112 | 37.663 | 31.633 | 40.351 | 34.896 | 33 | 32
Milled 4/ | 58.652 | 67.599 | 62.751 | 67.953 | 76.75 | 68 | 60
Total use | 218.843 | 232.111 | 222.024 | 232.841 | 249.472 | 219 | 218
Ending stocks | 39.315 | 29.492 | 30.419 | 36.499 | 48.46700000000004 | 34.476 | 28.976
 |  |  |  | Percent
Stocks-to-use ratio | 17.96493376530206 | 12.70598980660115 | 13.70077108781033 | 15.67550388462513 | 19.42783158029761 | 15.7 | 13.3
 |  |  | $/cwt | $/cwt
Average farm |  |  |  |  |  |  | 13.80 to
price 5/ | 9.96 | 12.8 | 16.8 | 14.4 | 12.7 | 14.1 | 14.8
 |  |  |  | Percent
Average
milling rate | 71 | 69.88 | 70.83 | 71.53 | 68.86 | 70 | 70.25
N/A = not available.  1/ August-July market year; rough equivalent.  2/ Projected.  3/ Residual includes unreported
use, processing losses, and estimating errors.  4/  Rough-rice equivalent.  5/ Market-year weighted average.
Source: World Agricultural Supply and Demand Estimates, WAOB, USDA.
Updated July 11, 2012.
Spreadsheet: 806111d1669112413-helper-column-and-vlookup-project-calendar-2-ans-2
Sheet: Hol-Cal

Holiday & Country | Day | Date | Status
US New Year's Day | Mon | 2023-01-02 00:00:00 | No
US MLK Day | Mon | 2023-01-16 00:00:00 | No
India Republic Day | Thu | 2023-01-26 00:00:00 | No
[NAME] | Wed | 2023-03-08 00:00:00 | No
India Ram Navami | Thu | 2023-03-30 00:00:00 | No
India Mahavir Jayanti | Tue | 2023-04-04 00:00:00 | No
India Good Friday | Fri | 2023-04-07 00:00:00 | No
India Buddh Purnima | Fri | 2023-05-05 00:00:00 | No
[NAME] | Thu | 2023-06-29 00:00:00 | No
US Independence Day | Tue | 2023-07-04 00:00:00 | No
India Independence Day | Tue | 2023-08-15 00:00:00 | No
US Labor Day | Mon | 2023-09-04 00:00:00 | No
India Id Milad | Thu | 2023-09-28 00:00:00 | No
India Gandhi Jayanti | Mon | 2023-10-02 00:00:00 | No
US Colombus Day | Mon | 2023-10-09 00:00:00 | No
India Dussehra | Tue | 2023-10-24 00:00:00 | No
US Veterans Day | Fri | 2023-11-10 00:00:00 | No
US Thanksgiving | Fri | 2023-11-24 00:00:00 | No
India Christmas | Mon | 2023-12-25 00:00:00 | No