tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 747297d1631360717-listing-differences-between-2-columns-comparelist-help
Sheet: Sheet1

 | DUTY | NAME | MON | TUE | WED | THUR | FRI | SAT |  |  | Master List |  | MON | TUE | WED | THUR | FRI | SAT
 | L1 | R J [NAME] | L5 | L24 | L24 | L24 | DAY OFF | L24 |  |  |  |  | L1
 | L2 | M S J GRIFFITH | A/L | A/L | A/L | A/L | A/L | DAY OFF |  |  |  |  | L2
 | L3 |  | L3 |  |  |  |  | OFF |  |  |  |  | L3
 | [NAME] | E M OWEN | A/L | [NAME] | DAY OFF | [NAME] | [NAME] | A/L |  |  |  |  | [NAME]
 | L5 | H PREUSS | L7 | L20 | [NAME] | DAY OFF | DAY OFF | DAY OFF |  |  |  |  | L5
 | L6 | H GRIFFITH | Day Off | DAY OFF | DAY OFF | L20 | L20 | L20 |  |  |  |  | L6
 | L7 | A W GRIFFITH | Day Off | [NAME] | L12 | L22 | L24 | L12 |  |  |  |  | L7
 | L8 | [NAME] | L8 | L6 | L20 | L6 | L6 | Day Off |  |  |  |  | L8
Spreadsheet: 680654d1591123073-need-a-formula-to-pull-data-from-another-sheets-chart-based-off-age-and-gender-2020-06-02-oeldere2-tbingham-680647d1591120212-need-a-formula-to-pull-data-from-another-sheet
Sheet: Applicants

Applicant | Sex | Age | Pushups | Pushup % | Situps | Situp % | Run Time | Run % | Overall % |  | push up
[NAME]
[NAME] | M | 23 | 38 |  | 44 | 65 | 13:33:00 | 27 |  |  | 63
[NAME]
[NAME]
[NAME] | F | 41
[NAME] | M | 59 | 33 |  | 20 | 37 | 12:22:00 | 87
[NAME] |  | 34 | 40 |  | 28 | 15 | 0 | 0
[NAME]
[NAME] | M | 23 | 35 |  | 26 | 1 | 0 | 0
[NAME] | M | 43 | 36 |  | 29 | 40 | 1 day, 3:00:00 | 48
I'm sorry i guess the example would be on sheet one says applicants where we put in their age and gender and show thier scores. So for column E i need this special formula to look at thier age and gender then find the value of say column D in the appropriate gender and age group sheet and put the percentage. So example the first guy is 25 year old male lets say he does 30 pushups... i would go to sheet 3 and look for his age range column, how many he did (30) which ends up right between 40-45% then that 45% would go back to his box under Column E on sheet one as his earned PT percentage on Pushups? Hopefully that makes sense
Spreadsheet: 78329d1278692399-average-vlookup-book1
Sheet: Sheet1

Customer | Date | Serial Number | Hours | Average Difference | Total Years as Customer
[NAME] | 2008-01-02 00:00:00 | 1234 | 30 | 30 | 2.008219178082192
[NAME] | 2010-01-03 00:00:00 | 1111 | 60
[NAME] | 2010-01-04 00:00:00 | 2222 | 90
[NAME] | 2003-02-04 00:00:00 | 3333 | 40 | 40 | 7.010958904109589
[NAME] | 2009-02-05 00:00:00 | 4444 | 80
[NAME] | 2010-02-06 00:00:00 | 4321 | 120
Spreadsheet: 547e850b-f564-4d18-959c-036778c64d01
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
BUTTE COUNTY PERMANENT ROAD DIVISION - ZONE NUMBER ___
BUDGET WORKSHEET - FIRST YEAR
STREETLIGHTS
 | STREETLIGHTS @ LS-1F 150 WATT RATE |  | 15.859 | PER LIGHT FOR |  | 12 | MONTHS |  | 0
STREETS
25 | YEAR CYCLE
 | SLURRY OR CAPE SEAL AT |  |  | 10 | YEARS
 | SLURRY OR CAPE SEAL AT |  |  | 17 | YEARS
 |  | [NAME] IN LENGTH
 | 0 | FEET IN LENGTH |  |  | FEET IN WIDTH
 | 0 | SQ. FEET OF ROAD SURFACE
 |  | COST PER SQUARE FOOT - PER APPROVED ESTIMATE
 | 0 | TOTAL COST FOR SLURRY OR CAPE SEAL AT YEAR 10
 | 0 | TOTAL COST FOR SLURRY OR CAPE SEAL AT YEAR 17
 | 0 | TOTAL COST FOR BOTH SLURRY OR CAPE SEALS
 | 17 | YEARS TO ACCRUE
 |  | COST PER YEAR |  |  |  |  |  |  | 0
 | OVERLAY AT 25 YEARS
 | 0 | [NAME] IN LENGTH |  | 0 | FEET IN WIDTH
 | 0 | FEET IN LENGTH
 | 0 | SQ. FEET OF ROAD SURFACE
 |  | COST PER SQUARE FOOT - PER APPROVED ESTIMATE
 | 0 | TOTAL COST FOR OVERLAY AT YEAR 25
 | 25 | YEARS TO ACCRUE
 |  | COST PER YEAR |  |  |  |  |  |  | 0
 |  | 25 YEAR CYCLE TOTAL ROAD COSTS PER YEAR |  |  |  |  |  |  | 0
[NAME]
 | MAINTAIN AND REPLACE WITHIN TOTAL YEARS CYCLE OF |  |  | 50 | YEARS
 |  | FEET IN LENGTH
 |  | COST PER LINEAR FOOT - PER APPROVED ESTIMATE
 | 0 | TOTAL COST FOR STORM DRAINAGE MAINTENANCE AND REPLACEMENT
 |  | ANNUALIZED COST OVER TOTAL NUMBER OF YEARS |  |  |  |  |  |  | 0
DETENTION BASIN MAINTENANCE
 |  | APPROVED ANNUAL MAINTENANCE COST PER YEAR |  |  |  |  |  |  | 0
SUBTOTAL OF COSTS PER YEAR |  |  |  |  |  |  |  |  | 0
TAX ROLL FEE
 | 1 | TOTAL NUMBER OF PARCELS
 | 0.3 | AUDITOR COST PER PARCEL TO PLACE ASSESSMENT OF TAX ROLL |  |  |  |  |  |  | 1
ADMINISTRATION
 | 0.1 | FLAT RATE PERCENTAGE OF SUBTOTAL COSTS PER YEAR SHOWN ABOVE |  |  |  |  |  |  | 0
MANAGEMENT
 | 0.1 | FLAT RATE PERCENTAGE OF SUBTOTAL COSTS PER YEAR SHOWN ABOVE |  |  |  |  |  |  | 0
CONTINGENCY
 | 0.05 | FLAT RATE PERCENTAGE OF SUBTOTAL COSTS PER YEAR SHOWN ABOVE |  |  |  |  |  |  | 0
TOTAL COST |  |  |  |  |  |  |  |  | 1
ANNUAL COST PER PARCEL |  |  |  |  |  |  |  |  | 1
FIRST YEAR FORMATION COSTS
 | 100 | REQUIRED PUBLIC NOTICE
 | 100 | TOTAL FIRST YEAR ADDITIONAL COSTS |  |  |  |  |  |  | 100
 |  | FIRST YEAR FORMATION COSTS PER PARCEL |  |  |  |  |  |  | 100
FIRST YEAR COST PER PARCEL |  |  |  |  |  |  |  |  | 101
Spreadsheet: larry_campbell__21590__Winter_icap_auction_monthly_offer_form_09-27-01_20_00
Sheet: Monthly OPP Awards

Delete Rows working from the last month and work yourself up to current.  Deleting top down will cause errors.
Insert Rows working from the last month and work yourself up to current.  Inserting top down will cause errors.
 |  |  |  |  |  |  |  | If you change the size of the table, MAKE SURE that you copy the contents of the
 |  |  |  |  |  |  |  | first tabel row B:F to the end of the table area B:F
Offer# | PTID# | Minimum Price Offered [($/kW- per month) express to nearest $.01] | Amount (MW) [expressed to nearest 0.1 MW] | [NAME]. | Amount (MW) Sold | Market Clearing Price | Sold Amount $ | NYC Mitigated
1
 |  | Month Sold: |  |  | Total Value Sold |  |  |  | If you change the size of the table, MAKE SURE that you copy the contents of the
 |  |  |  |  |  |  |  |  | first tabel row B:F to the end of the table area B:F
Offer# | PTID# | Minimum Price Offered [($/kW- per month) express to nearest $.01] | Amount (MW) [expressed to nearest 0.1 MW] | [NAME]. | Amount (MW) Sold | Market Clearing Price | Sold Amount $ | NYC Mitigated
1
 |  | Month Sold: |  |  | Total Value Sold |  |  |  | If you change the size of the table, MAKE SURE that you copy the contents of the
 |  |  |  |  |  |  |  |  | first tabel row B:F to the end of the table area B:F
Offer# | PTID# | Minimum Price Offered [($/kW- per month) express to nearest $.01] | Amount (MW) [expressed to nearest 0.1 MW] | [NAME]. | Amount (MW) Sold | Market Clearing Price | Sold Amount $ | NYC Mitigated
1
 |  | Month Sold: |  |  | Total Value Sold |  |  |  | If you change the size of the table, MAKE SURE that you copy the contents of the
 |  |  |  |  |  |  |  |  | first tabel row B:F to the end of the table area B:F
Offer# | PTID# | Minimum Price Offered [($/kW- per month) express to nearest $.01] | Amount (MW) [expressed to nearest 0.1 MW] | [NAME]. | Amount (MW) Sold | Market Clearing Price | Sold Amount $ | NYC Mitigated
1
 |  | Month Sold: |  |  | Total Value Sold |  |  |  | If you change the size of the table, MAKE SURE that you copy the contents of the
 |  |  |  |  |  |  |  |  | first tabel row B:F to the end of the table area B:F
Offer# | PTID# | Minimum Price Offered [($/kW- per month) express to nearest $.01] | Amount (MW) [expressed to nearest 0.1 MW] | [NAME]. | Amount (MW) Sold | Market Clearing Price | Sold Amount $ | NYC Mitigated
1
 |  | Month Sold: |  |  | Total Value Sold |  |  |  | If you change the size of the table, MAKE SURE that you copy the contents of the
 |  |  |  |  |  |  |  |  | first tabel row B:F to the end of the table area B:F
Offer# | PTID# | Minimum Price Offered [($/kW- per month) express to nearest $.01] | Amount (MW) [expressed to nearest 0.1 MW] | [NAME]. | Amount (MW) Sold | Market Clearing Price | Sold Amount $ | NYC Mitigated
1
 |  | Month Sold: |  |  | Total Value Sold
Spreadsheet: 214821d1361136043-issue-finding-a-date-in-vlookup-vlookup-date-question-021713
Sheet: Sheet1

ESH3  15 min   #1 |  | Formula Source Sheet #1.  Enter and modify formulas for this sheet on Sheet1
Date Time | High | Low |  | Date input: | 2013-02-15 10:00:00
2013-02-15 17:00:00 | 1517.75 | 1517
2013-02-15 16:45:00 | 1517.5 | 1516.75 |  | Results:
2013-02-15 16:30:00 | 1517.5 | 1516.5
2013-02-15 16:00:00 | 1518.5 | 1516.75
2013-02-15 15:45:00 | 1517.5 | 1515.5
2013-02-15 15:30:00 | 1516.5 | 1514.25
2013-02-15 15:15:00 | 1515 | 1512.75
2013-02-15 15:00:00 | 1514 | 1512.25
2013-02-15 14:45:00 | 1513.25 | 1511.25
2013-02-15 14:30:00 | 1514.25 | 1511.5
2013-02-15 14:15:00 | 1516 | 1511.5
2013-02-15 14:00:00 | 1519.25 | 1515.75
2013-02-15 13:45:00 | 1519.25 | 1518.25
2013-02-15 13:30:00 | 1518.75 | 1517.5
2013-02-15 13:15:00 | 1518.5 | 1517
2013-02-15 13:00:00 | 1517.75 | 1517.25
2013-02-15 12:45:00 | 1517.75 | 1516.75
2013-02-15 12:30:00 | 1517.25 | 1515.75
2013-02-15 12:15:00 | 1516.5 | 1515.25
2013-02-15 12:00:00 | 1518.5 | 1515.75
2013-02-15 11:45:00 | 1518.5 | 1517
2013-02-15 11:30:00 | 1519.5 | 1517
2013-02-15 11:15:00 | 1520.75 | 1518.75
2013-02-15 11:00:00 | 1521 | 1520
2013-02-15 10:45:00 | 1521 | 1518.75
2013-02-15 10:30:00 | 1520.25 | 1518.25
2013-02-15 10:15:00 | 1521 | 1519.5
2013-02-15 10:00:00 | 1521.75 | 1520.5
2013-02-15 09:45:00 | 1521.25 | 1518.75
2013-02-15 09:30:00 | 1520.75 | 1519.25
2013-02-15 09:15:00 | 1521 | 1517.5
2013-02-15 09:00:00 | 1518.75 | 1517.75
Spreadsheet: 05c25e8b-3f4d-49f4-b40b-6f3a56f61941
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
POSV | Test | POSV | Post [NAME], Semen | Post [NAME], Semen | Manual | Semen analysis kit: SemAnl |  |  |  | Varies | [NAME] must arrive within 24 hours of collection. Send specimen Monday through Thursday only and not the day before a holiday. If holiday falls on a Saturday, holiday will be observed on the preceding Friday. Sunday holidays are observed on the following Monday. [NAME] should be collected and packaged as close to shipping time as possible. Laboratory does not perform testing on weekends.   Container/Tube: Semen [NAME] (Supply T178) [NAME]: Total ejaculate Collection Instructions: Patient should have 2 to 7 days of sexual abstinence at the time of semen collection for accurate results. Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | Zero sperm seen | Monday through Friday; Upon arrival | 1 day | 4 days | 1 | 89321 |  |  |  |  | Rochester
POSV | [NAME] | SEMEN | Semen |  |  |  | Ambient
POSV | Result | ABSTN | Abstinence | Abstinence | Numeric |  |  |  |  | d |  |  |  |  |  |  |  |  |  | 10587-4 | Sexual abstinence duration:Time:Pt:^Patient:Qn:
POSV | Result | CLST1 | Collection Site | Collection Site | Alphanumeric
POSV | Result | VL53 | Semen Volume | Semen Volume | Numeric |  |  |  |  | mL |  |  |  |  |  |  |  |  |  | 3160-9 | [NAME] volume:Vol:Pt:Semen:Qn:
POSV | Result | CENT | Centrifuged | Centrifuged | Alphanumeric
POSV | Result | SPML1 | Sperm/mL | Sperm/mL | Numeric |  |  |  |  | x10(6) |  |  |  |  |  |  |  |  |  | 9780-8 | Spermatozoa:NCnc:Pt:Semen:Qn:
POSV | Result | MOTIL | Motility | Motility | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 6800-7 | Spermatozoa.motile/100 spermatozoa:NFr:Pt:Semen:Qn:
POSV | Result | GR3 | Grade | Grade | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
POSV | Result | CMMT4 | Comment | Comment | Alphanumeric
Spreadsheet: 820410d1678097599-data-selection-using-drop-down-options-book1
Sheet: 0303

[NAME] | Status | Contract Value
123 | Won | 132500
124 | In Process | 155000
127 | Lost | 76000
128 | Won | 145000
130 | Won | 30000
131 | In Process | 35000
134 | Won | 86000
137 | Lost | 90000
139 | Lost | 40000
141 | Won | 200000
143 | In Process | 50000
Spreadsheet: 141562d1329331766-excel-2007-finding-the-counts-between-a-given-criteria-sample
Sheet: Sheet1

Wrist | Palm | Count
8.6 | 8.4 | 1
9.5 | 18 | 1 |  | Customer A
9.5 | 18 | 1
9.5 | 20.2 | 1 |  |  | All given dimensions are with a +/- [NAME]
10 | 18 | 1 |  | Size | Given Wrist | Wrist Min | [NAME] | Given Palm | Palm Min | [NAME]
10 | 18.5 | 1 |  | 1 | 14.5 |  |  | 17.5
10 | 18.5 | 1 |  | 2 | 16 |  |  | 19
10 | 19 | 1 |  | 3 | 17.5 |  |  | 20.5
10.2 | 14.3 | 1 |  | 4 | 19 |  |  | 22
10.2 | 14.3 | 1 |  | 5 | 20.5 |  |  | 23.5
10.2 | 14.3 | 1 |  | 6 | 22 |  |  | 25
10.2 | 14.3 | 1
10.2 | 14.3 | 1
10.2 | 19.4 | 1 |  | Size | Fit (count) | Percent of Total
10.3 | 9.7 | 1 |  | 1
10.3 | 9.7 | 1 |  | 2
10.5 | 13 | 1 |  | 3
10.5 | 13 | 1 |  | 4
10.5 | 13 | 1 |  | 5
11 | 9 | 1 |  | 6
11 | 12.5 | 1
11 | 12.5 | 1
11 | 18.5 | 1 |  | Total %
11 | 20.6 | 1 |  | Total Population
11 | 21.5 | 1
11.2 | 14.1 | 1
11.5 | 13 | 1
11.5 | 18 | 1
11.5 | 19.5 | 1
11.5 | 21.5 | 1
11.9 | 13 | 1
11.9 | 13 | 1
11.9 | 13 | 1
12 | 13 | 1
12 | 13 | 1
12 | 13 | 1
12 | 13 | 1
12 | 13 | 1
12 | 13 | 1
12 | 13 | 1
12 | 13.5 | 1
12 | 13.5 | 1
12 | 23 | 1
12.1 | 14 | 1
12.4 | 13.3 | 1
Spreadsheet: 879812d1727371186-conditional-formatting-based-on-dates-conform-etaf
Sheet: Sheet1

Company | Last payment made | [NAME] date |  | Today
A | 2024-07-29 00:00:00 |  |  | Today - 31
B | 2023-06-13 00:00:00
C | 2022-12-20 00:00:00
D | 2022-10-28 00:00:00
E | 2022-06-10 00:00:00
F | 2023-09-01 00:00:00
G | 2022-03-22 00:00:00
H | 2022-03-18 00:00:00
I | 2022-02-24 00:00:00
J | 2022-02-18 00:00:00
The cell in column B should turn Orange when the expiry date is 31 days away from expiring until it expires
The cell in column B should turn Red once it is expired.
Spreadsheet: 148433d1333400494-output-a-value-based-on-multiple-drop-down-lists-multiple-drop-down-sample
Sheet: 4 Drop Downs to Calc Price

Color | Engine | [NAME] | Region |  | PRICE |  |  |  |  | Color | Engine | [NAME] | Region
Red | 4 Cylinder | 1 Year | North |  |  | **Want the Price from 'Price Data' Sheet to be automatically input into F2 based on the 4 drop down selections made in A2:D2 |  |  |  | Red | 4 Cylinder | 1 Year | North
 |  |  |  |  |  |  |  |  |  | Blue | V6 | 3 Years | South
 |  |  |  |  |  |  |  |  |  | Green | V8 |  | East
 |  |  |  |  |  |  |  |  |  |  |  |  | West
Spreadsheet: 153894d1336087592-problem-with-chart-where-horizongal-axis-is-a-time-series-marketshare
Sheet: Problem worksheet

 | 2012-04-29 01:00:00 | 0.23
 |  | 0.17
 |  | 0.11
 |  | 0.22
 |  | 0.13
 |  | 0.19
 |  | 0.07
 |  | 0.07
 |  | 0.12
 |  | 0.34
 |  | 34.69
 |  | 0.13
 |  | 11.42
 |  | 105.32
 |  | 368.91
 |  | 580.85
 |  | 416.35
 |  | 335.97
 |  | 288.48 |  | Why is Excel creating a bar for each day rather than each hour?
 |  | 18.82
 |  | 209.5
 |  | 84.51
 |  | 66.75
 |  | 33.21
 |  | 29.63
 |  | 21.52
 |  | 2.55
 |  | 0.03
 |  | 0.03
 |  | 0.03
 |  | 0.02
 |  | 7.63
 |  | 3.27
 |  | 1.06
 |  | 0.84
 |  | 14.7
 |  | 2.72
 |  | 7.31
 |  | 3.63
 |  | 21.45
 |  | 14.05
 |  | 1.6
 |  | 31.57
 |  | 20.16
 |  | 66.54
 |  | 20.76
 |  | 8.31
 |  | 31.65
 |  | 51.27
 |  | 24.13
 |  | 0.06
 |  | 0.12
 |  | 0.05
 |  | 0.06
 |  | 0.12
 |  | 9.22
 |  | 4.76
 |  | 3.87
 |  | 9.09
 |  | 2.95
 |  | 0.43
 |  | 2
 |  | 5.59
 |  | 7.4
 |  | 77.79
 |  | 2.85
 |  | 14.72
 |  | 226.71
 |  | 161.35
 |  | 13.23
 |  | 18.05
 |  | 20.24
 |  | 67.89
 |  | 0.4
 |  | 0.11
 |  | 0.08
 |  | 0.04
 |  | 0.22
 |  | 0.08
 |  | 11.88
 |  | 8.26
 |  | 16.96
 |  | 2.79
 |  | 0.24
 |  | 11.04
 |  | 7.64
 |  | 23.6
 |  | 64.35
 |  | 400.21
 |  | 95.3
 |  | 52.34
 |  | 68.15
 |  | 58.08
 |  | 97.58
 |  | 48.65
 |  | 33.85
 |  | 44.49
 |  | 0.11
 |  | 0.05
 |  | 0.08
 |  | 0.04
 |  | 0.04
 |  | 0.13
 |  | 0.25
 |  | 0.59
 |  | 3.55
 |  | 0.06
 |  | 0.03
 |  | 16.25
 |  | 15.68
 |  | 5.55
 |  | 8.13
 |  | 37.1
 |  | 12.31
 |  | 24.79
 |  | 56.72
 |  | 71.42
 |  | 47.74
 |  | 76.88
 |  | 19.56
 |  | 23.25
 |  | 0.07
 |  | 0.06
 |  | 0.1
 |  | 0.07
 |  | 0.08
 |  | 0.05
 |  | 6.7
Spreadsheet: 771642d1646767734-select-conditional-data-from-a-table-preserve-line-breaks-when-using-filter-function-rev-000
Sheet: Sheet1

 |  |  | Original Table |  |  |  |  | Using filter command  =FILTER(Table1[[Product]:[Column4]];Table1[Product]<>"";"Error")  Note issue in yellow cells
 |  |  | Product | TextWithLineBreaks | Column3 | Column4
 |  |  | Apple | Green Healthy Fruit | thb | sf |  |  | Green Healthy Fruit | thb | sf
 |  |  | Orange | Spain Sweet Bright color | gfggf | jhg |  | Orange | Spain Sweet Bright color | gfggf | jhg
 |  |  | [NAME] | thnjmuj | rgv | htf |  | [NAME] | thnjmuj | rgv | htf
 |  |  |  | rr | rgb | ku7 |  | Bread | xd3e | [NAME] | rgbgrb
 |  |  | Bread | xd3e | [NAME] | rgbgrb
Spreadsheet: 178489d1346808007-need-help-with-a-formula-to-exclude-test
Sheet: Sheet1

a | b | c | a | b | c | a | b | c | a | b | c | a | b | c | a | b | c | a | b | c | a | b | c | a | b | c | a | b | c | a | AF | c | a | b | AJ | a | b | c | AN | b | c | a | AR | c | a | b | AV | a | b | c | AZ | b | c | a | G | BE | I | J | BH | L | M | BK | P | Q | BN | S | T | BQ | V | W | BT | W | Z
0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 14f5a78f-7046-4e6f-ac0b-4ec429c96b1a
Sheet: Sheet1

Newspaper Readership & Audience 2008 by Age and [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Study: Scarborough USA+ 2008 Release 2 (Current 6 Months only, February 2008 - September 2008)
Base: Total U.S. Adults
 | U.S. Adults | Men | Women | Age 18 - 34 | Age 35 or older | Age 55 or older
Base Total
Target Pop | 229865814 | 111551416 | 118314398 | 69339168 | 160526646 | 73190484
Target % | 1 | 1 | 1 | 1 | 1 | 1
[NAME]. Issue - Any Daily Newspaper (Print)
Target Pop | 103734012 | 52447766 | 51286246 | 20781118 | 82952894 | 44365846
Target % | 0.451 | 0.47 | 0.433 | 0.3 | 0.517 | 0.606
Newspaper Print or Web - Yesterday
Target Pop | 113810160 | 57602244 | 56207916 | 24499526 | 89310634 | 45983628
Target % | 0.495 | 0.516 | 0.475 | 0.353 | 0.556 | 0.628
5 Weekday [NAME]
Target Pop | 146696178 | 72689002 | 74007176 | 36461166 | 110235012 | 54719926
Target % | 0.638 | 0.652 | 0.626 | 0.526 | 0.687 | 0.748
[NAME]. Issue - Sunday (Print)
Target Pop | 114647848 | 54619674 | 60028174 | 24379010 | 90268838 | 46561764
Target % | 0.499 | 0.49 | 0.507 | 0.352 | 0.562 | 0.636
Past Week Newspaper Print Only
Target Pop | 162508600 | 79215264 | 83293336 | 40868480 | 121640120 | 59052622
Target % | 0.7070000000000001 | 0.71 | 0.7040000000000001 | 0.589 | 0.758 | 0.807
Past Week Newspaper Print or Web
Target Pop | 170772714 | 83257208 | 87515506 | 44084348 | 126688366 | 60235660
Target % | 0.743 | 0.746 | 0.74 | 0.636 | 0.789 | 0.823
Source: Scarborough Research, USA+, [NAME], 6 Months
Prepared by: Newspaper Association of America
Spreadsheet: 195227d1353448283-how-to-stop-value-appearing-rate-calculator
Sheet: Purchases

 |  | `
 | [NAME] | UNIT | QUANTITY | UNIT COST | TOTAL
 | RATE 1 |  | 2
 | RATE 2 |  | 1
Spreadsheet: 782005d1653680098-very-basic-formula-question-formula-breakdown
Sheet: Sheet1

R_
R0
S
S0
T |  |  |  | EXP(-0.7*R_/R0) |  | EXP(-1.08*S/S0) |  |  | (1.24-EXP(-2.43*T/T0)) |  |  | EXP(-(0.023*N/N0)^2)
T0 |  |  |  |  |  |  |  |  |  |  |  |  | Product=
N
N0
Spreadsheet: 2a1eb375-0ee4-43a9-8e4a-28bbb93b2c5e
Sheet: 4.2(AC) Major Group Enroll-Grad

Institution
Indicator 4: Student Enrollment and Graduation by Major Group
Table 4.2(AC): Major Group Fall Enrollment, Graduation & Post-Graduate / AY 2011-12
 | Major Group | AC - Accounting
 | Please enter the number of students enrolled in this major group for the fall semester.
 |  |  |  |  | Fall 2011 (October 15, 2011)
 | Fall Enrollment (Snapshot) |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
 |  | Full Time | 0 | 0 | 0 | 0
 |  | Part Time | 0 | 1 | 0 | 0
 |  | Total
 | Please enter the number of diploma, certificates, and degrees earned in this major group.  Also enter the number of students who were admitted to a 4 year (Associate degree graduates), or graduate school (Bachelor's degree graduates).  Lastly, enter the number of all graduating students(certificate or degree) who secured gainful employment after graduation.
 |  |  |  |  | July 1, 2011- June 30, 2012
 | Graduation |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
Apprenticeship/Occupational Program |  |  | na | na | na | na
 | App. graduates admitted to a college program |  | na | na | na | na
Diploma |  |  | na | na | na | na
 | [NAME]. graduates admitted to a college program |  | na | na | na | na
Certificate |  |  | na | na | na | na
 | Cert. graduates admitted to a college program |  | na | na | na | na
Associate Degree |  |  | 1 | 3 | 0 | 0
 | Assoc. graduates admitted to four-year program |  | 0 | 0 | 0 | 0
Bachelor's Degree |  |  | na | na | na | na
 | [NAME]. graduates admitted to graduate school |  | na | na | na | na
Master's Degree |  |  | na | na | na | na
Gainfully Employed after graduation |  |  | m | m | m | m
Graduates who completed remedial courses during their time at the TCU |  |  | m | m | m | m
Graduates who received A*CF support at some point during their coursework |  |  | m | m | m | m
Notes:
Graduates are not tracked after graduation.  Graduates who took remedial courses are not tracked.  Graduates who received ACF are not tracked.
Spreadsheet: 471099d1468867749-collect-rows-with-specific-values-and-then-comiple-example-ndm
Sheet: Before

ID | Name | State
1 | item 1 | Kept
2 | item 2 | Transferred
3 | item 3 | Kept
4 | item 4 | Kept
5 | item 5 | Transferred
6 | item 6 | Transferred
7 | item 7 | Transferred
8 | item 8 | Kept
9 | item 9 | Kept
Spreadsheet: 860646d1708660109-does-a-derivative-of-sumif-exist-avgirondistance
Sheet: Sheet1

 |  | Average Distance
 | 5i | For each "5i" in column B, add the value in Column A to the value in column C.  Then, divide by the count of "5i" in column B.
 | 5i |  | <- This formula incorporates Shot #1, 3, and 5.  However, there wasn't a shot and thus the cell (D11) was null.  How can null cells be excluded from the formula?  If they aren't excluded, this formula overstates the average distance.
Shot | Yardage | Iron | -Lft / +Rgt
1 | 195 | 5i | -2
2 | 135 | 58* | 11
3 | 200 | 5i | 8
4 | 120 | 58* | -7
5 | 205 | 5i |  | If not
6 | 175 | 58*