tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 868617d1715300717-fishing-club-sheet-formula-help-index-broe-comp-sheet-chads-new-edit
Sheet: SatFig

Sussex Inlet Bowling Club Fishing Club B.R.O.E.
 |  |  |  |  |  |  | SATURDAY |  | date & year:
Bream |  | Drummer |  | Dusky |  | Flathead |  | Leatherjacket |  | Ludrick |  | Morwong |  | Salmon |  | Snapper |  | Tailor
Angler | Length (mm) | Angler | Length (mm) | Angler | Length (mm) | Angler | Length (mm) | Angler | Length (mm) | Angler | Length (mm) | Angler | Length (mm) | Angler | Length (mm) | Angler | Length (mm) | Angler | Length (mm)
Spreadsheet: 784688d1655907774-how-to-combine-multiple-sumifs-name-manager-time-filter-v1
Sheet: Sheet1

Date | Gender | New vs Returning | Product ID | Category | Sub-Category | Product Name | Quantity | Total Revenue |  | Product ID | Price |  | Time Filter
2020-01-02 00:00:00 | Male | New | A01 | A | A1 | [NAME] | 3 |  |  | A01 | 10 |  | All Time
2020-02-01 00:00:00 | Male | New | A01 | A | A1 | [NAME] | 1 |  |  | A02 | 12 |  | Year
2020-03-02 00:00:00 | Male | New | A02 | A | A2 | Apple | 3 |  |  | A03 | 8 |  | Month
2020-04-02 00:00:00 | Female | New | A03 | A | A3 | Orange | 7 |  |  | B01 | 14 |  | Week
2020-05-02 00:00:00 | Female | New | B01 | B | B1 | Potato | 1 |  |  | B02 | 6 |  | Today
2020-06-02 00:00:00 | Male | New | B01 | B | B1 | Potato | 5 |  |  | B03 | 12 |  | Day
2020-07-02 00:00:00 | Male | New | B02 | B | B2 | Tomato | 1 |  |  | B04 | 15
2020-08-02 00:00:00 | Male | New | B02 | B | B2 | Tomato | 3 |  |  | C01 | 5
2020-09-02 00:00:00 | Male | New | B03 | B | B3 | Sweet Potato | 5 |  |  | C02 | 4
2020-10-02 00:00:00 | Male | New | B04 | B | B4 | [NAME] | 5
2020-11-02 00:00:00 | Female | New | C01 | A | C1 | [NAME] | 1
2020-12-02 00:00:00 | Female | New | C01 | A | C1 | [NAME] | 6
2021-01-02 00:00:00 | Female | Returning | C02 | A | C2 | Noodle | 3 |  |  | Year
2021-02-02 00:00:00 | Female | Returning | C02 | A | C2 | Noodle | 9 |  |  | Date | 2020-02-01 00:00:00
2021-03-02 00:00:00 | Female | Returning | B03 | B | B3 | Sweet Potato | 1
2021-04-02 00:00:00 | Female | Returning | B04 | B | B4 | [NAME] | 2 |  |  | Female
2021-05-02 00:00:00 | Female | New | C01 | A | C1 | [NAME] | 10 |  |  | Male
2021-06-02 00:00:00 | Female | New | C01 | A | C1 | [NAME] | 6
2021-07-02 00:00:00 | Female | New | A03 | A | A3 | Orange | 9
2021-08-02 00:00:00 | Male | New | B01 | B | B1 | Potato | 2
2021-09-02 00:00:00 | Male | New | B03 | B | B3 | Sweet Potato | 1
2021-10-02 00:00:00 | Female | New | B04 | B | B4 | [NAME] | 7
2021-11-02 00:00:00 | Female | Returning | C01 | A | C1 | [NAME] | 4
2021-12-02 00:00:00 | Female | Returning | C01 | A | C1 | [NAME] | 1
2022-01-02 00:00:00 | Female | Returning | C02 | A | C2 | Noodle | 4
2022-02-02 00:00:00 | Male | Returning | B03 | B | B3 | Sweet Potato | 5
2022-03-02 00:00:00 | Male | New | B04 | B | B4 | [NAME] | 8
2022-04-02 00:00:00 | Female | New | A03 | A | A3 | Orange | 8
2022-05-02 00:00:00 | Female | Returning | B01 | B | B1 | Potato | 3
2022-06-02 00:00:00 | Female | Returning | B01 | B | B1 | Potato | 5
Spreadsheet: 165308d1341154309-working-out-stock-levels-and-circular-reference-issues-stock-p-and-l
Sheet: Postage Table

 |  | Warehouse | £/$ |  | Yes
 |  | Hong Kong | £ |  | No
 |  | Europe | $
 |  | Hong Kong |  | Europe
 | Weight Grams | Price | Per 100 Gram | Price | Per 100 Gram
 | 50000 | 27.32 | Over 3kg | 16.94 | Over 25kg
 | 25000 | 27.32 | Over 3kg | 16.94
 | 10000 | 27.32 | Over 3kg | 11.49
 | 5000 | 27.32 | Over 3kg | 10.53
 | 2999 | 27.32 |  | 10.53
 | 2499 | 24.52 |  | 10.53
 | 1999 | 18.47 |  | 9.7
 | 1500 | 14.63 |  | 9.7
 | 999 | 11.33 |  | 9.7
 | 500 | 6.19 |  | 9.7
 | 300 | 4.43 |  | 9.7
 | 200 | 2.47 |  | 9.7
 | 100 | 2.47 |  | 9.7
 | 0 | 0 |  | 0
Spreadsheet: 128399d1320941783-countif-drainage-material-call-off-b
Sheet: MANHOLES

 |  |  |  |  |  | Key: | Input from drop down box
 |  |  |  |  |  |  | Typed input
 |  |  |  |  |  |  | Calculation
 |  |  |  |  |  | FOUL WATER MANHOLES
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IRONWORKS
Pipe in Socket |  |  | Pipe out Spigot |  |  | Ref: | C.L | I.L | Depth | Diameter | largest pipe | Rising Pieces | Chamber Height | [NAME] | Balance | Concrete Rings c/w step irons |  |  | Concrete Cover Slab |  | Raising Pieces |  | D400 MH Cover |  |  | Ironwork Depth | Cover Slab | pipe thickness (1 wall)
 |  |  |  |  |  |  |  |  |  | Ø |  |  |  |  |  | 1000mm | 750mm | 500mm
0.45 | 0.45 | 0.45 | 0.45 | 0.45 | 0.45 | FWMH 17 | 83.67 | 80.634 | 3.036000000000001 | 1200 | 0.45 | 0.225 | 2.048500000000001 | 1.75 | 0.2985000000000011 | 1 | 1 |  | 1 | 1220 x 675 opening | 3 | 1220 x 675 opening | 1 | D400 1220 x 675 x 100mm |  | 0.1 | 0.15 | 0.06249999999999997
0.45 | 0.45 | 0.45 | 0.45 | 0.45 | 0.45 | FWMH 17 | 83.67 | 81 | 2.670000000000002 | 1500 | 0.6 | 0.15 | 1.565000000000002 | 1.5 | 0.06500000000000172 |  | 2 |  | 1 | 1220 x 675 opening | 2 | 1220 x 675 opening | 1 | D400 1220 x 675 x 100mm |  | 0.1 | 0.17 | 0.08500000000000002
0.45 | 0.45 | 0.45 | 0.45 | 0.45 | 0.45 | FWMH 17 | 83.67 | 80.6 | 3.070000000000007 | 1800 | 0.75 | 0.225 | 1.740000000000007 | 1.75 | -0.009999999999992681 | 1 | 1 |  | 1 | 1220 x 675 opening | 3 | 1220 x 675 opening | 1 | D400 1220 x 675 x 100mm |  | 0.1 | 0.175 | 0.08000000000000002
0.45 | 0.45 | 0.45 | 0.45 | 0.45 | 0.45 | FWMH 17 | 83.67 | 81.1 | 2.570000000000007 | 1200 | 0.6 | 0.15 | 1.485000000000007 | 1.25 | 0.2350000000000074 |  | 1 | 1 | 1 | 1220 x 675 opening | 2 | 1220 x 675 opening | 1 | D400 1220 x 675 x 100mm |  | 0.1 | 0.15 | 0.08500000000000002
0.45 | 0.45 | 0.45 | 0.45 | 0.45 | 0.45 | FWMH 17 | 83.67 | 80.634 | 3.036000000000001 | 1500 | 0.45 | 0.225 | 2.028500000000001 | 1.75 | 0.2785000000000011 | 1 | 1 |  | 1 | 1220 x 675 opening | 3 | 1220 x 675 opening | 1 | D400 1220 x 675 x 100mm |  | 0.1 | 0.17 | 0.06249999999999997
0.45 | 0.45 | 0.45 | 0.45 | 0.45 | 0.45 | FWMH 17 | 83.67 | 80.634 | 3.036000000000001 | 1500 | 0.225 | 0.225 | 2.276000000000001 | 1.75 | 0.5260000000000011 | 1 | 1 |  | 1 | 1220 x 675 opening | 3 | 1220 x 675 opening | 1 | D400 1220 x 675 x 100mm |  | 0.1 | 0.17 | 0.03999999999999999
0.45 | 0.45 | 0.45 | 0.45 | 0.45 | 0.45 | FWMH 17 | 83.67 | 80.634 | 3.036000000000001 | 1200 | 0.3 | 0.225 | 2.206000000000001 | 1.75 | 0.4560000000000013 | 1 | 1 |  | 1 | 1220 x 675 opening | 3 | 1220 x 675 opening | 1 | D400 1220 x 675 x 100mm |  | 0.1 | 0.15 | 0.05499999999999999
0 | 375
Spreadsheet: 150042d1334257629-mode-most-frequency-in-ranges-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | 1ST | 3RD
0 | 0.1 | 0.2 | 0.3 | 0.4 | 1 |  |  |  | 0
1.1 | 1.2 | 1.5 | 1.9 | 2 |  |  |  |  | 1
2.1 | 2.2 | 2.7 | 2.8 |  |  |  |  |  | 2
3.2 | 3.5 | 3.6 |  |  |  |  |  |  | 3
4.1 | 4.3 | 4.5 | 4.7 | 4.9 | 5 |  |  |  | 4
5.2 | 5.4 | 5.6 | 5.8 | 6 |  |  |  |  | 5
6.1 | 6.2 | 6.4 | 6.5 | 6.8 | 6.9 |  |  |  | 6
7.5 | 7.9 |  |  |  |  |  |  |  | 7
8.1 | 8.8 | 9 |  |  |  |  |  |  | 8
9.1 | 10 |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  | Most occurance:
Spreadsheet: a5cfad8c-a22b-40f9-b0e4-099598679935
Sheet: page2 translations

Language Selected
Fee%
Min
 | Selected Desc | English | French
Field1 |  | Event date | Date de l'événement
Field2 |  | (DD/MM/YYYY) | (JJ/MM/AAAA)
Field3 |  | Event name | Nom de l'événement
Field4 |  | Gross receipts (A) | Recettes brutes (A)
Field5 |  | = $0 if the event is free | = 0 $ si gratuit
Field6 |  | Total licence fee | Total des droits de licence
Field7 |  | = (A) x 0.1% (or $5 if free event) | '= (A) x 0,1 % (ou 5 $ si gratuit)
Field8 |  | TOTAL DUE | TOTAL À PAYER
Spreadsheet: 95327d1294934444-excel-2007-dual-column-lookup-dual-column-lookup
Sheet: Sheet1

Vehicle | Color
Car | Blue
Boat | Red
Plane | Yellow
Bike | Green
Car | Black
Boat | Blue
Plane | Red
Bike | Yellow
Car | Green
Boat | Black
Plane | Blue
Bike | Red
Car | Yellow
Boat | Green
Plane | Black
Bike | Blue
Car | Red
Boat | Yellow
Plane | Green
Bike | Black
Spreadsheet: 864400d1711578213-index-match-reversed-need-to-find-the-value-in-column-a-index-match-reversed-need-to-find-the-value-in-column-a-v2
Sheet: Feuil1

Scale | Pointing1 | Pointing2 | Pointing3 | Pointing4
0 | Horrible | 1,10 and more GJ/m2 | 0-20% | Extreme
1 | Bad | 0,95 to 1,09999 GJ/m2 | 20-40% | Very high
2 | Passable | 0,8 to 0,94999 GJ/m2 | 40-60% | High
3 | Average | 0,65 to 0,79999 GJ/m2 | 60-80% | Moderate
4 | Good | 0,5 to 0,64999 GJ/m2 | 80-100% | Low
5 | Excellent |  |  | Very low
 |  |  | Expected result
Criterion 1 : | Pointing3 | 60-80% | 3
Criterion 2 | Pointing1 | Excellent | 5 |  |  |  | [NAME] to give me the scale according to the Pointing column and the date in said column.
Spreadsheet: 863198d1710777231-vlookup-if-with-conditions-in-two-columns-solar-salaried-employee-list-mm
Sheet: ENTRY TAB

Emp No | Employee Full Name | First Name | Last Name | PHONE NUMBER | Hire Date
1001
1036
1037
1068
 |  |  |  | Lookup on A2
 |  |  |  | in WD DROP
 |  |  |  | for work phone#
 |  |  |  | if none, then add
 |  |  |  | personal phone #
Spreadsheet: 485861d1477117179-find-trends-in-employee-data-example
Sheet: page 5

Tur | Mandag | Tirsdag | Onsdag | Torsdag | Fredag | Lørdag | Søndag
9 | 17:40     0:17 |  |  |  | 7:51     17:19 | 6:47     14:04 | 7:46     17:04
 | 4:35     12:40 | 6:10     12:17 | 12:17    21:48 | 14:20    22:39
 |  | 7:00     16:00 | 7:00     16:00 |  | 11:49    22:43 | 10:05    20:06 | 11:45    21:48
 |  | 14:20    22:39 | 22:17     6:34 | 23:47     6:31
 | 6:05     13:39 | 6:00     14:00 | 6:10     12:17 | 6:00     15:00 | 6:00     14:00
 | 6:00     15:30 | 6:12     16:38 | 6:09     13:23 | 6:17     20:37
Tur | Mandag | Tirsdag | Onsdag | Torsdag | Fredag | Lørdag | Søndag
1 0 | 15:11     6:50 | 22:47     6:09 |  |  |  | 6:28     16:58 | 9:49     18:23
 | 9:06     20:38 | 14:19    22:15 |  | 5:38     12:02 | 5:47     15:09
 |  |  | 14:20    22:39 | 22:47     6:09 | 22:21     7:53 |  | 9:32     19:13
 |  | 6:05     13:39 | 6:22     13:44 | 6:15     13:09 | 4:35     12:40
 |  |  | 14:00    23:00 | 14:33    23:47 | 13:15    22:09 | 14:47    22:23 | 16:15    23:09
 |  | 12:20    19:17 | 3:23     10:48 | 6:00     14:00 | 6:00     15:00
Spreadsheet: 40332d1238622678-how-to-clear-the-lowest-10-values-from-a-list-of-30-values-student-top20scores
Sheet: RawGrades

ORIGINAL SCORES - Tests, Quizzes
Name | Q1 | Q2 | Q3 | Q4 | Q5 | Q6 | Q7 | Q8 | Q9 | Q10 | Q11 | Q12 | Q13 | Q14 | Q15 | Q16 | Q17 | Q18 | Q19 | Q20 | [NAME] | Q22 | [NAME] | Q24 | Q25 | Q26 | Q27 | Q28 | Q29 | Q30 | Total | AVG
Jack- | 10 | 7 | 8 | 5 | 10 | 9 | 8 | 7 | 3 | 6 | 4 | 7 | 3 | 10 | 7 | 8 | 5 | 10 | 9 | 8 | 7 | 3 | 6 | 4 | 7 | 3 | 3 | 4 | 5 | 6 | 192 | 6.4
Millie- | 2 | 3 | 10 | 9 | 8 | 2 | 7 | 1 | 2 | 9 | 2 | 0 | 7 | 9 | 2 | 3 | 10 | 9 | 8 | 2 | 7 | 1 | 2 | 9 | 2 | 0 | 7 | 9 | 9 | 2 | 153 | 5.1
Ryan- | 4 | 5 | 7 | 8 | 9 | 10 | 2 | 4 | 5 | 7 | 8 | 9 | 4 | 4 | 4 | 5 | 7 | 8 | 9 | 10 | 2 | 4 | 5 | 7 | 8 | 9 | 5 | 7 | 8 | 9 | 193 | 6.433333333333334
Spreadsheet: 870714d1717170952-sort-by-date-formula-not-seeing-year-report-builder-copy
Sheet: What's Happening

 | YSC | LSC or YSC
 | 2024-04-01 00:00:00 | First Date of Reporting Month
 | 2024-04-30 00:00:00 | Last Date of Reporting month
 | Worksheet Name |  | What is the worksheet doing? | User Intervention
 | What's Happening | Three Questions | Answer the three questions above in yellow | Enter three bits of info
 | Sheet 0 | Paste FULL Report Here | Pulling in raw data from SF report | Copy / Paste FULL report that is output from SalesForce, headers and all
 | Sheet 1 | "All Data" | Makes previous data useable | NONE
 | Sheet 2 | "Old Closures" | filters out closures prior to reporting month; also renaming headers | NONE
 | Sheet 2A |  |  | Enter first day of the reporting month in cell A1
 | Sheet 3 | "Future First Contacts" | filters out clients with a start date AFTER end of report month | Cell A1 - enter last date of reporting month
 | Sheet 4-LSC | "LSC Only" | Filters in LSC or YSC clients only | NONE
 | Sheet 5 | "Remove Text" | removes "LSC", "CM, "FLY" from Column N, Col. T, U, V rename text to be report specific | NONE
 | Sheet 6 | "Corrected rows" | Pulls in corrected columns with corrected report naming (i.e. corrected ethnicities, referral source, etc.) | NONE
 | Sheet 7 | "End Day Sort" | Sorts by end date date so closed clients are at top of the report | NONE
 | Sheet 8 | "Staff Initials" | Renames staff to initials only | NONE
 | FINAL-LSC | "Final LSC" | This is the final to copy/paste into the actual LSC report | Enter Servive Month and Year, cells A2 and [NAME]
 | DINAL-YSC | "Final YSC" | This is the final to copy/paste into the actual YSC report | Enter Servive Month and Year, cells A2 and [NAME]
Spreadsheet: 888540d1739054952-update-needed-to-formula-to-only-show-data-for-month-sample-sheet-holger3
Sheet: February

 | Note: Rep names must be entered in exactly as they are shown in the survey report. Enter the supervisor name in the green boxes.
 | Claim Rep | Number of Promoters | Number of Detractors | Total Survey Count | Overall Score
 | [NAME]
 | 2025-02-01 00:00:00
 | [NAME]
 |  |  |  |  |  |  |  |  | = test date array in above formula for yes/no
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  | Team Score |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  | Team Score
 |  |  |  | Team Score
 |  |  |  | Team Score
 | Sup 5
 |  |  |  | Team Score
 | Sup 6
 |  |  |  | DRG Score
Spreadsheet: 86525d1286482763-vlookup-multiple-entries-book1
Sheet: Test

 | [NAME] |  |  |  |  | Overstock #1 |  |  |  |  | Overstock #2 |  |  |  |  | Overstock #3
SKU | Sec | Row | Bay | Bin | Exp Date | Sec | Row | Bay | Bin | Exp Date | Sec | Row | Bay | Bin | Exp Date | Sec | Row | Bay | Bin | Exp Date | Correct Rotation
236300157
Summary-- |  | # of SKUs checked: |  |  |  |  | # of SKUS rotated correctly: |  |  |  |  |  | # of SKUS rotated incorrectly: |  |  |  |  |  | % Error:
Spreadsheet: 130473d1322348078-search-formula-workbook1
Sheet: Data Table

Diseases | Symptom 1 | Symptom 2 | Symptom 3 | Symptom 4 | Symptom 5
a | A | G | C | F
b | B
c | C | B | E | F | G
d | D
h | G
g | E
r | F | E | D
e | A
w | B | G
q | F
d | G | C | F
f | E | A
g | C | B | E
h | D
j | F
k
l | G | C | B | E
p | F
o | E | F | G | C | B
i
u | D
y | G
t | E | F | G
z | F
c | A | E | F | G
v | B
b | A | C | B
n | B
m | C | F | G |  | B
l | D
k | G | A | E
k | E
j | F
h | F | G | C | B
l | B
o | F | B | D
i | G
u | E
uu | D | A
ii | G
oo | E | B
pp | F | E
dd | A | G
ed | B | C
fr | F | A
th | G
nj | E | G
kl | C
oi | D
Spreadsheet: 59149d1259616895-formulas-for-lookups-swim-tracking
Sheet: Pivot Tables

Date | (All)
Count of Reg_Name
Meet | Event | Total
Nationals | 1500 Free | 2
 | 200 IM | 2
 | 50m [NAME] | 2
Nationals Total |  | 6
World Cup | 1500 Free | 2
 | 200 IM | 2
 | 50m [NAME] | 2
World Cup Total |  | 6
Grand Total |  | 12
Spreadsheet: 867560d1714397259-countif-not-following-standart-when-add-new-line-testes
Sheet: BRAZIL

Contagem de casos | Coluna5 | Coluna4 | Coluna3 | Coluna2 | Coluna1 | Coluna6 | Coluna7 | Coluna8 | Coluna9 | Coluna10 | Coluna11 | Coluna12 | Coluna13 | Coluna14 | Coluna15 | Coluna16 | Coluna17 | Coluna18 | Coluna19 | Coluna20 | Coluna21 | Coluna22 | Coluna23 | Coluna24 | Coluna25
 |  | BBB
 |  | AAA
 |  | AAA
 |  | CCC
 |  | [NAME]
 |  | AAA
 |  | AAA
 |  | AAA
 |  | CCC
 |  | ZZZ
 |  | ZZZ
 |  | ZZZ
 |  | ZZZ
 |  | VVV
 |  | AAA
 |  | AAA
 |  | AAA
 |  | VVV
 |  | BBB
 |  | BBB
 |  | BBB
 |  | BBB
 | 2024-04-29 00:00:00 | AAA |  | AAA | AAAA
 |  | AAA
 |  | CCC
 |  | CCC
 |  | AAA
Spreadsheet: 148847d1333576241-vlookup-to-return-column-header-name-example
Sheet: Sheet1

 | Item1 | Item2 | Item3 | Item4 | Item5 | Item6 | Item7 | Item8 | Item9 |  |  | Number of Item Owned 1 | Type of Item Owned 1 | Number of Item Owned 2 | Type of Item Owned 2 | Number of Item Owned 3 | Type of Item Owned 3
[NAME] | 1 |  |  | 2 |  | 1 |  |  |  |  | [NAME] | 1 | Item1 | 2 | Item4 | 1 | Item6
Collin |  | 7 |  |  |  |  |  | 3 |  |  | Collin
[NAME] |  |  |  | 12 |  |  |  |  |  |  | [NAME]
[NAME] |  | 7 | 2 |  |  |  | 3 |  |  |  | [NAME]
Victor |  | 4 |  |  |  | 4 |  |  |  |  | Victor
[NAME] |  | 2 |  |  |  |  |  |  |  |  | [NAME]
Cat |  |  |  | 6 | 4 |  |  |  | 78 |  | Cat
Spreadsheet: 1455b351-3967-43bb-aa9c-ebc34d6e6262
Sheet: Sheet1

 | 2012-06-19 00:00:00
 |  | Beginning | Income Distribution | FY2013 | Total Monthly | Total Ending
 |  | Balance |  | Budget | Charges | Balance
 |  | 2012-04-01 00:00:00 |  |  |  | 2012-06-19 00:00:00
E103 | [NAME]. Fund | 34.97 | 0 |  | 0
E132 | William & Anita Fritsch Library Book Fund | 3186.19 |  |  | 0
E157 | Dr. [NAME] Memorial Endowment | 1283.44
E175 | [NAME] Library Endowment | 16.63
E178 | [NAME] Lotta Degree Memorial | 0 | 0 |  | 0
E195 | Independent Insurance Agents Lib Endow | 7119.34
E234 | Platt Family Library Endowment | 466.1 |  |  | 0
E238 | The David & Fannie Black Memorial Endow | 861.49
E258 | [NAME]. | 191.88
E265 | E & O Carlson Women's Studies [NAME]. Mat. | 407.2
E271 | Mildred Mckowen & [NAME] | -102.38
E297 | Hartford, [NAME] | 699.42 |  |  | 0
E348 | [NAME] and [NAME] | 648.93 |  |  | 0
E380 | Dr. [NAME]. End. | 524.88
EC25 | Urish, [NAME] | 1258.08 | 1747 |  | 0
5881 | Bouclin, Marilynn Library Journals | 854.75
Spreadsheet: 144754d1331128608-highlighting-a-row-with-the-current-date-0180
Sheet: PM Service SPS 2012

Planned Maintenace Schedule SPS 2012 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Planned Maintenace Schedule SPS 2006 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Planned Maintenace Schedule SPS 2006 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Planned Maintenace Schedule SPS 2006 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Planned Maintenace Schedule SPS 2006 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Planned Maintenace Schedule SPS 2006 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Planned Maintenace Schedule SPS 2006 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Planned Maintenace Schedule SPS 2006 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Planned Maintenace Schedule SPS 2006 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Planned Maintenace Schedule SPS 2006 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Planned Maintenace Schedule SPS 2006 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Planned Maintenace Schedule SPS 2006 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Planned Maintenace Schedule SPS 2006 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Planned Maintenace Schedule SPS 2006 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Planned Maintenace Schedule SPS 2006
SPS No | Hospital | City | Country | Jan | Feb | Mar | Apr | Maj | Jun | Jul | Aug | Sep | Okt | Nov | Dec
 | Karolinska | Stockholm | Sweden |  |  |  |  |  |  |  |  |  |  |  | PM
 | Århus | Århus | Denmark |  | PM
 | Lund | Lund | Sweden |  |  |  |  |  |  |  |  |  |  | PM
 | Tammerfors | Tammerfors | Finland |  |  |  |  |  |  |  |  |  |  | PM
 | Linköping | Linköping | Sweden |  |  |  |  |  |  |  |  | PM
 | Tammerfors | Tammerfors | Finland |  |  |  |  |  |  |  |  | PM
Spreadsheet: 017a395b-425c-4fce-8526-867f69a8dc1d
Sheet: State Report

 | State Summary Provided by the Educational Choice Program
 | Ohio Department of Education
 | January 2013
 | Statewide Student Enrollment in EdChoice and Proficiency on Ohio Achievement and Graduation Tests for Spring 2012
 | Student Enrollment in EdChoice
 | Students participating for one year: |  |  |  |  |  | 4276
 | Students participating between one and three years: |  |  |  |  |  | 2943
 | Students participating for more than three years: |  |  |  |  |  | 8416
 | Percent of Students Proficient by Tested Grade
 | Tested Grade |  | Percent Proficient or Above in Reading |  | Percent Proficient or Above in Math |  | Percent Proficient or Above in Science
 | 3 |  | 59 |  | 47.6 |  | Science test not given
 | 4 |  | 69.2 |  | 39.8 |  | Science test not given
 | 5 |  | 50.8 |  | 24 |  | 35.4
 | 6 |  | 75.7 |  | 41.4 |  | Science test not given
 | 7 |  | 63.1 |  | 37.2 |  | Science test not given
 | 8 |  | 71.2 |  | 53.2 |  | 36.4
 | OGT |  | 89.9 |  | 80.8 |  | 76.1
 | Percent of Students Proficient by Student Gender
 | Gender |  | Percent Proficient or Above in Reading |  | Percent Proficient or Above in Math |  | Percent Proficient or Above in Science
 | Female |  | 69.5 |  | 41.8 |  | 15
 | Male |  | 63.7 |  | 46.3 |  | 18.5
 | Missing Gender |  | 66.7 |  | 50 |  | 33.3
 | Percent of Students Proficient by Student Ethnicity
 | Ethnicity |  | Percent Proficient or Above in Reading |  | Percent Proficient or Above in Math |  | Percent Proficient or Above in Science
 | Asian/Pacific Island. |  | 82.5 |  | 63.2 |  | 19.3
 | Black |  | 61.1 |  | 35.9 |  | 15.5
 | Hispanic |  | 57.4 |  | 37.1 |  | 15.1
 | Multi-racial |  | 70.1 |  | 45.4 |  | 14.9
 | Native American |  | 70 |  | 50 |  | 10
 | White-Non Hispanic |  | 76.6 |  | 57.3 |  | 19.2
 | Unknown |  | 55.6 |  | 55.6 |  | 11.1
 | Other |  | 82.6 |  | 69.6 |  | 39.1
 | Notes
 | (1) All 2012 report card affiliated data is preliminary pending the Auditor of State's investigation.
 | (2) This data may be amended from time to time as students are manually matched to their test and added to the report.
 | (3) Categories with fewer than 10 test takers are reported with 'NC'
 | (4) This data represents unverified assessment data from Spring 2012
 | (5) OGT Stands for Ohio Graduation Test.  This assessment is given starting in the 10th grade.
 | (6) Student enrollment participation includes all students in program
Spreadsheet: 54632d1254679297-need-help-printing-tabs-example
Sheet: tab 1

 | type
 | red | blue | green | yellow | orange | purple | black | grey
qty | 1 | 0 | 0 | 1 | 3 | 1 | 5 | 2
 | 1 | 1 | 0 | 1 | 2 | 2 | 3 | 1
total | 2 | 1 | 0 | 2 | 5 | 3 | 8 | 3
 | basically I want to press print once and have everything print off other than the green tab as is total value is zero
 |  |  | this page must always be printed along with 2 copies of 'tab 2'
Spreadsheet: 771584d1646746261-transpose-and-return-a-row-values-in-a-columns-limited-to-one-unique-and-one-duplicate-transpose-and-return-a-row-values-in-a-columns-limited-to-one-unique-and-one-duplicate
Sheet: Sheet1

 | 1214 |  | Expected result | 1214 | 1214 | 1450 | 1450 | 1560 | 1560
 | 1214
 |  |  |  |  | 1214 | 1450 | 1450 | 1560 | 1560
 |  |  |  |  | 1214 | 1450 | 1450 | 1560 | 1560
 | 1214
 | 1214
 | 1214
 | 1214
 | 1450
 | 1450
 | 1450
 | 1450
 | 1450
 | 1450
 | 1560
 | 1560
 | 1560
 | 1560
 | 1560
 | 1560
Spreadsheet: 781703d1653495165-how-to-index-match-a-cell-that-has-formula-with-another-sheet-reference-efwitherror-fixed-aligw-with-2-dexter2-
Sheet: Sheet3

ID | Time | Code | Sequence | Name | Unique
101 | 06:30:00 | A | 1
101 | 06:31:00 | B | 2
101 | 06:32:00 | C | 3
101 | 06:33:00 | D | 4
101 | 06:34:00 | E | 5
101 | 06:35:00 | F | 6
101 | 06:36:00 | G | 7
101 | 06:37:00 | H | 8
101 | 06:38:00 | I | 9
101 | 06:38:00 | J | 10
101 | 06:39:00 | K | 11
101 | 06:39:00 | L | 12
101 | 06:40:00 | M | 13
101 | 06:40:00 | N | 14
101 | 06:41:00 | O | 15
101 | 06:42:00 | P | 16
101 | 06:43:00 | Q | 17
101 | 06:44:00 | R | 18
101 | 06:45:00 | S | 19
101 | 06:46:00 | T | 20
101 | 06:46:00 | U | 21
101 | 06:47:00 | V | 22
101 | 06:48:00 | W | 23
101 | 06:49:00 | X | 24
101 | 06:50:00 | Y | 25
101 | 06:51:00 | Z | 26
101 | 06:53:00 | AA | 27
101 | 06:53:00 | AB | 28
101 | 06:55:00 | AC | 29
101 | 06:58:00 | AD | 30
102 | 08:00:00 | AE | 1
102 | 08:10:00 | AF | 2
102 | 08:15:00 | AG | 3
103 | 08:30:00 | AE | 1
103 | 08:35:00 | AF | 2
103 | 08:40:00 | AG | 3
103 | 08:42:00 | AH | 4
103 | 08:50:00 | AI | 5