tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 882646d1731037386-sumifs-with-multiple-sum-range-and-criteria-in-different-sheets-sumifs-accross-mutiple-sheets
Sheet: Total Summary

Name | 2024-11-01 00:00:00 | 2024-11-04 00:00:00 | 2024-11-08 00:00:00 | Total
[NAME] | [NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | [NAME]
Spreadsheet: eric_saibi__9716__010702
Sheet: J M Stuart 03

Owner Name | Dayton Power and Light Company
Station Name | J M Stuart Generating Station
Unit Name | J M Stuart 03
NERC Region | ECAR
State | OH
Fuel Type | Coal
Capacity | 610 MW
Start Date | 2002-01-07 00:00:00
End Date | 2002-01-10 00:00:00
Comments | Tube Leak
SIC | 4911
Plant ID | 1018004
Unit ID | 1003907
Outage ID | 19395
Spreadsheet: 811042d1672242215-help-with-returning-the-category-the-value-belongs-to-rather-than-the-value-itself-help-with-returning-the-category-the-value-belongs-to-rather-than-the-value-itself
Sheet: Sheet2

 | Name | Cost Centre 1 | Cost Centre 2 | Cost Centre 3 | Cost Centre 4 | Cost Centre 5 |  | [NAME] |  |  | JEC
 | [NAME] |  | 20 |  |  |  |  |  |  |  |  | Cost Centre 2
 | [NAME] |  |  | 50 |  |  |  |  |  |  | [NAME] | Cost Centre 3
 | [NAME] |  | 6 |  |  |  |  |  |  |  | [NAME] | Cost Centre 2
 | [NAME] |  |  |  | 15 |  |  |  |  |  | [NAME] | Cost Centre 4
 | [NAME] | 2 |  |  |  |  |  |  |  |  | [NAME] | Cost Centre 1
 | Help with returning the category the value belongs to rather than the value itself
 | https://www.excelforum.com/excel-formulas-and-functions/1396382-help-with-returning-the-category-the-value-belongs-to-rather-than-the-value-itself.html
Spreadsheet: 748034d1631846227-using-transpose-function-with-indirect-and-row-function-excel-transpose-formula-example
Sheet: Parts Sold Table

 |  | Number of Parts Sold
Categories | Description | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12
Hex | Hex 1/2" x 1/2" [NAME]
Hex | Hex 3/4" x 1/2" [NAME]
Spreadsheet: 053723aa-71ab-4649-987c-326900fc3c22
Sheet: 4 YEARS

Form PR-B ORSP BUDGET WORKSHEET    Must be completed and initialed by ORSP Staff
 | MUID |  |  |  | ACCT
Prepared by
Last Modified on
PI |  |  |  |  | DEPT
Project Title
Sponsor
 | Budget Period
 | Increase Annually By | 1.03
 | BUDGET ITEM | Name or Comment |  |  |  | PERIOD 1 | PERIOD 2 | PERIOD 3 | PERIOD 4 | TOTAL
A. | PERSONNEL
6000 | PI Acad. Year
6000 | Co-I Acad Year
6000 | Co-I Acad Year
6000 | Other Professional
6000 | Total Professional
6007 | PI Summer
6007 | Co-I Summer
6007 | Co-I Summer
6007 | Total Sumr Salaries
6008 | Post Doc/Fellow Full-Time
6012 | Clinical/Lab Staff Full-Time
6013 | Clinical/Lab Staff Part-Time
6020 | Full-Time Hourly Staff
6035 | Part-Time Hourly Staff
6050 | Undergraduate Students
6024 | GRA-Academic Year | #: |  | Biweekly $:
6024 | GRA-Summer | #: |  | Biweekly $:
6024 | Total GRA
6195 | Fringe FT |  |  |  | 0.285
6195 | [NAME] |  |  |  | 0.16
6195 | Fringe PT & Summer Students |  |  |  | 0.08
6195 | Total Fringes
 | TOTAL PERSONNEL
B. | NONPERSONNEL
6200 | Office Expenses
6235 | Lab Supplies
6247 | Equipment > $5000
6265 | Computer Software
6505 | Consulting Fees
6602 | Student Stipends
6900 | Domestic Travel
6900 | Domestic Travel
6900 | Total Domestic Travel
6930 | Foreign Travel
7010 | Publications
7225 | Tuition
 | TOTAL NONPERSONNEL
 | TOTAL DIRECT COSTS
 | MTDC BASE
7520 | F&A Costs |  |  |  | 0.51
 | TOTAL PROJ COSTS
Spreadsheet: 727397d1617882361-sumif-not-correct-using-but-using-is-correct-explain-me-weird-sumif-version-2-
Sheet: Sheet2

Customer Code | Qty |  | Sum of Qty with Customer Code other than:
0501 | 6
0500 | 2
0502 | 3 |  | 0501
0501 | 4
Using SUMPRODUCT | Using SUMIF
[NAME] | [NAME] |  | sum Qty
formula in A10 | formula in B10 |  | formula in D10
I am know correct answer for sumif |  |  |  | my question is why is sumif not Correct using sign <> like in B10
 |  |  |  | but if using "=" like in D10 is correct
 | formula in B16
Spreadsheet: 150351d1334447410-lowest-number-of-corresponding-category-that-is-part-of-a-group-excelsmalloflist
Sheet: Sheet1

Fruit |  |  | Highest Price | Lowest Price | Food 1 |  | Food 2 |  | Food 3 |  | Food 4 |  | Food 5
[NAME] |  |  |  |  | Name | Price | Name | Price | Name | Price | Name | Price | Name | Price
Apple |  | Store 1 |  |  | Apple | 10 |  |  | Pear | 7 | Steak | 8 | Orange | 12
Pear |  | Store 2 |  |  | Beans | 8 | Pear | 4 | Broccoli | 10 | Apple | 9 | Butter | 3
Grape |  | Store 3 |  |  | [NAME] | 10 | Steak | 9 | Grape | 1 |  |  | Potato | 2
Orange |  | Store 4 |  |  | Cheese | 12 | Apple | 13 |  |  | [NAME] | 19 | Milk | 6
Spreadsheet: 86362d1286364732-how-to-format-as-numbers-dummy3
Sheet: Sheet1

2 000,00
1 000,00
2 000,00
2 000,00
2 000,00
1 000,00
1 000,00
1000
1 000,00
1 000,00
500
1 000,00
1 000,00
1 000,00
1 000,00
700
1 100,00
1 200,00
220
250
Spreadsheet: 45820d1244614309-multiple-copy-and-paste-excel-question-sample
Sheet: Sheet1

 | Jan | Feb
[NAME] | 1001
[NAME] | 1002
[NAME] | 1003
S Total | 3006
[NAME] | 1004
[NAME] | 1005
[NAME] | 1006
Geroge | 1007
S Total | 4022
[NAME] | 1008
Issac | 1009
[NAME] | 1010
[NAME] | 1011
Lloyd | 1012
S Total | 5050
Mark | 1013
Nick | 1014
[NAME] | 1015
[NAME] | 1016
S Total | 4058
Spreadsheet: 826638d1682112013-merging-data-for-match-cases-vlookup-merge-value-vlookup
Sheet: Preparation

Grid | Sample
A1 |  |  | * If column E of 'Source' worksheet has matched value get that value, if empty return 'Empty' on column B of this worksheet
A1
A1
A2 |  |  | * Would be great if it can be matched with column D instead of column K
A2 |  |  | * Column K is created using formula, contains formula
A2
A3
A3
A3
A4
A4
A4
A5
A5
A5
A6
A6
A6
A7
A7
A7
A8
A8
A8
A9
A9
A9
A10
A10
A10
A11
A11
A11
A12
A12
A12
B1
B1
B1
B2
B2
B2
B3
B3
B3
B4
B4
B4
B5
B5
B5
B6
B6
B6
B7
B7
B7
B8
B8
B8
B9
B9
B9
B10
B10
B10
B11
B11
B11
B12
B12
B12
C1
C1
C1
C2
C2
C2
[NAME]
[NAME]
[NAME]
C4
C4
C4
C5
C5
C5
C6
C6
C6
C7
C7
C7
C8
C8
C8
C9
C9
C9
C10
C10
C10
C11
C11
C11
C12
C12
C12
D1
D1
D1
D2
D2
D2
D3
D3
D3
D4
D4
D4
D5
D5
D5
D6
D6
D6
D7
D7
D7
D8
D8
D8
D9
D9
D9
D10
D10
D10
D11
D11
D11
D12
D12
D12
E1
E1
E1
E2
E2
E2
E3
E3
E3
E4
E4
E4
E5
E5
E5
E6
E6
E6
E7
E7
E7
E8
E8
E8
E9
E9
E9
E10
E10
E10
E11
E11
E11
E12
E12
E12
F1
F1
F1
F2
F2
F2
F3
F3
F3
F4
F4
F4
F5
F5
F5
F6
F6
F6
F7
F7
F7
F8
F8
F8
F9
F9
F9
[NAME]
[NAME]
[NAME]
F11
F11
F11
F12
F12
F12
[NAME]
[NAME]
[NAME]
G2
G2
G2
G3
G3
G3
G4
G4
G4
G5
G5
G5
G6
G6
G6
G7
G7
G7
G8
G8
G8
G9
G9
G9
G10
G10
G10
G11
G11
G11
G12
G12
G12
H1
H1
H1
H2
H2
H2
H3
H3
H3
H4
H4
H4
H5
H5
H5
H6
H6
H6
H7
H7
H7
H8
H8
H8
H9
H9
H9
H10
H10
H10
H11
H11
H11
H12
H12
H12
Spreadsheet: 823610d1680034181-if-and-string-search-text-combination-help-sample
Sheet: Sheet1

Date | Admitted | Charge Type | Report Dates | Scope Years check
2023-03-28 09:23:32 | I do not know its could be Meta | Trial | 2007-07-31 00:00:00 |  | IF "E2 =<5 years and C= Trial and B = Meta If true =D or " " | B will always be a string of text but could contain the word meta
2023-03-28 02:51:47 |  | Trial | 2007-11-20 00:00:00
2023-03-28 00:12:27 | maybe Meta | Trial | 2010-03-20 00:00:00
2023-03-28 10:51:32 |  | Trial | 2021-01-01 00:00:00
2023-03-28 01:00:19 | not sure Meta | Trial | 2022-10-29 00:00:00
2023-03-28 06:05:23 | could be Meta | Trial | 2017-12-05 00:00:00
Spreadsheet: 680899d1591247397-is-there-a-way-to-adjust-the-y-axis-y-axis-reference
Sheet: Sheet1

 | time | open | high | low | close
20 | 2020-05-04 15:13:44.140000 | 9273.35 | 9273.35 | 9270.15 | 9270.15
19 | 2020-05-04 15:14:34.390000 | 9270.15 | 9271.65 | 9268.25 | 9269
18 | 2020-05-04 15:15:25.760000 | 9269 | 9277.45 | 9268.85 | 9277.45
17 | 2020-05-04 15:16:16.360000 | 9277.45 | 9283.7 | 9277.45 | 9283.9
16 | 2020-05-04 15:17:06.230000 | 9283.9 | 9286.4 | 9283.25 | 9282.2
15 | 2020-05-04 15:17:56.280000 | 9282.2 | 9285 | 9279.2 | 9279.6
14 | 2020-05-04 15:18:47.600000 | 9279.6 | 9285.9 | 9279.2 | 9285
13 | 2020-05-04 15:19:37.840000 | 9285 | 9285.6 | 9282.4 | 9282.4
12 | 2020-05-04 15:20:28.570000 | 9282.4 | 9286.95 | 9281.65 | 9285.15
11 | 2020-05-04 15:21:18.570000 | 9285.15 | 9288.55 | 9285 | 9287
10 | 2020-05-04 15:22:09.170000 | 9287 | 9293.2 | 9287.8 | 9290.85
9 | 2020-05-04 15:22:59.210000 | 9290.85 | 9296.65 | 9290 | 9296.65
8 | 2020-05-04 15:23:50.830000 | 9296.65 | 9303 | 9296.65 | 9303
7 | 2020-05-04 15:24:40.700000 | 9303 | 9306 | 9303 | 9305.1
6 | 2020-05-04 15:25:31.230000 | 9305.1 | 9308.8 | 9305 | 9306.1
5 | 2020-05-04 15:26:21.280000 | 9306.1 | 9308.15 | 9302.5 | 9303
4 | 2020-05-04 15:27:11.480000 | 9303 | 9305.95 | 9303 | 9305.2
3 | 2020-05-04 15:28:02.210000 | 9305.2 | 9308.5 | 9305.2 | 9308.5
2 | 2020-05-04 15:28:52.790000 | 9308.5 | 9308.5 | 9305 | 9304.35
1 | 2020-05-04 15:29:43.720000 | 9304.35 | 9305 | 9295.45 | 9297.25
0 | 2020-05-04 15:30:06.200000 | 9297.25 | 9299.05 | 9297 | 9297
 | Is there a way to  adjust the y axis by relating it to the [NAME] and min to the cells N23,N24 ? |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Min
Spreadsheet: 167680d1342061361-counting-days-on-delayed-report-submission-count-days
Sheet: Sheet1

Serial Number | Opn date | Document Type | Finish date | Submission | Pending Status (days)
112471897 | 700 | Hardness | 2012-07-09 00:00:00 | Yes
112471898 | 1200 | Hardness | 2012-07-09 00:00:00 | No
112471899 | 4000 | Hardness | 2012-07-09 00:00:00 | No
112471900 | 1700 | Hardness | 2012-07-09 00:00:00 | No
Spreadsheet: 0477874b-8786-494f-8ec2-7f27b85193e6
Sheet: Sheet1

PAST IMPACT | MOR | SL | SC | CWC | CS | HV | SM | OMZ | AP | MnA | BP | HT
DISPOSAL
Clinker | 1 | 2 | 1 | ? | ? |  | ? | ? | 2 | 2 |  | 1
Sewage |  | 3 | 2 | 1 |  |  |  |  |  |  | 1
Dredge spoil |  | 3 | 1 | 1 |  |  |  |  |  |  | 1
Pharmaceuticals |  | 1 |  |  |  |  |  |  |  |  | 1 | 1
Low-level radioactive waste |  | 2 | 1 |  |  |  |  |  | 1
Radionucleids |  | 1 |  |  |  |  |  |  | 1 | 1
Chemical cont.: CFCs | ? | ? | ? | ? | ? |  | ? | ? | ? | ? | 1 | ?
Chemical cont.: PAHs |  | 1 | 1 | ? | 1 |  | ? | ? | ? | ? | ? | ?
Large structures (wrecks) |  | 1 | 1 | ? | 1 |  | ? | ? | 1 | 1 |  | ?
Munitions |  | 1 | 1 |  |  |  |  |  | ? | ? |  | ?
CO2 |  | 0 |  |  | 0 |  |  |  | 0 | 0 |  | 0
Total impact disposal | 1 | 16 | 8 | 3 | 2 | 1 | 0 | 0 | 6 | 5 | 4 | 3
Mean impact disposal | 0.08333333333333333 | 1.333333333333333 | 0.6666666666666666 | 0.25 | 0.1666666666666667 | 0.08333333333333333 | 0 | 0 | 0.5 | 0.4166666666666667 | 0.3333333333333333 | 0.25
EXPLOITATION
Trawling | 1 | 1 | 1 | 1 | 1 |  | 1 | 0 | 0 |  | 1
Long-lining | 1 | 1 | 1 | 1 | 1 |  | 1 | 0 | 0 |  | 1
Ghost fishing | 0 | 0 | 0 | 0 | 0 |  | 0
Mining | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0
Oil and gas |  | 3 |  | 2 | 3 |  |  | 3 |  |  | 1
Underwater cables | 1 | 1 | 1 | 1 | 1 |  |  | 1 | 1 | 1
Pipelines |  | 0 | 0 | 0 | 0 |  |  | 0 | 0
Science | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Acoustics | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | 2 | ?
Total impact exploitation | 3 | 6 | 3 | 5 | 6 | 0 | 2 | 4 | 1 | 1 | 5 | 0
Mean impact exploitation | 0.3333333333333333 | 0.6666666666666666 | 0.3333333333333333 | 0.5555555555555556 | 0.6666666666666666 | 0 | 0.2222222222222222 | 0.4444444444444444 | 0.1111111111111111 | 0.1111111111111111 | 0.5555555555555556 | 0
ACIDIFICATION & CLIMATE
Ocean acidification | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Warming temperature | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0
Hypoxia | 0 | 0 | 0 | 1 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
Nutrient loading | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Stratification | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Deep circulation shutdown | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Regional circulation change | ? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total impact climate | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Mean impact climate | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GRAND TOTAL | 4 | 22 | 11 | 8 | 8 | 1 | 2 | 4 | 7 | 6 | 9 | 3
GRAND MEAN | 0.1388888888888889 | 0.6666666666666666 | 0.3333333333333333 | 0.2685185185185185 | 0.2777777777777777 | 0.02777777777777778 | 0.07407407407407407 | 0.1481481481481481 | 0.2037037037037037 | 0.1759259259259259 | 0.2962962962962963 | 0.08333333333333333
Spreadsheet: 137138d1326973930-updating-another-spreadsheet-based-on-certain-information-and-certain-conditions-dates
Sheet: Ali Khan

 | 10:00:00 | 10:15:00 | 10:30:00 | 10:45:00 | 11:00:00 | 11:15:00 | 11:30:00 | 11:45:00 | 12:00:00 | 12:15:00 | 12:30:00 | 13:30:00 | 13:45:00 | 14:00:00 | 14:15:00 | 14:30:00 | 14:45:00 | 15:00:00 | 15:15:00 | 15:30:00 | 15:45:00
2012-04-23 00:00:00
2012-04-24 00:00:00
2012-04-25 00:00:00
2012-04-26 00:00:00
2012-04-27 00:00:00
Spreadsheet: 125421d1319026254-value-added-prototype-value-added-ks3-v2-1-
Sheet: Sheet1

first name | Surname | Target | current | value added |  |  | table
 |  | 3A | 7C |  |  |  | 3A
 |  | 3B | 7B |  |  |  | 3B
 |  | 3C | 7A |  |  |  | 3C
 |  | 4A | 6C |  |  |  | 4A
 |  | 4B | 6B |  |  |  | 4B
 |  | 4C | 6B |  |  |  | 4C
 |  | 5A | 6A |  |  |  | 5A
 |  | 5B | 5C |  |  |  | 5B
 |  | 5C | 5B |  |  |  | 5C
 |  | 6A | 5A |  |  |  | 6A
 |  | 6B | 4C |  |  |  | 6B
 |  | 6C | 4B |  |  |  | 6C
 |  | 6C | 4A |  |  |  | 7A
 |  | 7A | 3C |  |  |  | 7B
 |  | 7B | 3B |  |  |  | 7C
 |  | 7C | 3A
Spreadsheet: 1a1a350b-5676-41af-9e02-ddfebf2318f1
Sheet: Table 2.3

Monthly Statistical Bulletin
2.3 Wage price index
Quarter | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013-14
Wage price index (a) (b) – index
September | 101.8 | 105.5 | 109.3 | 113.3 | 116.4
December | 102.6 | 106.6 | 110.4 | 114.2
March | 103.6 | 107.6 | 111.4 | 115
June | 104.4 | 108.4 | 112.5 | 115.8
Annual average | 103.125 | 107.025 | 110.9 | 114.575
Quarterly change (b) – per cent
September | 0.3944773175542426 | 1.053639846743293 | 0.830258302583009 | 0.7111111111111068 | 0.5181347150259086
December | 0.7858546168958647 | 1.042654028436019 | 1.006404391582816 | 0.7943512797881747
March | 0.974658869395717 | 0.9380863039399667 | 0.9057971014492683 | 0.7005253940455258
June | 0.7722007722007929 | 0.743494423791824 | 0.9874326750448859 | 0.6956521739130306
Annual change (b) – per cent
September | 3.140830800405259 | 3.63457760314343 | 3.601895734597149 | 3.659652333028363 | 2.736098852603708
December | 2.908726178535592 | 3.898635477582846 | 3.564727954971869 | 3.442028985507251
March | 2.982107355864816 | 3.861003861003853 | 3.531598513011169 | 3.23159784560143
June | 2.958579881656798 | 3.831417624521083 | 3.782287822878216 | 2.933333333333321
Annual average | 3.124999999999986 | 3.781818181818188 | 3.620649380985751 | 3.313796212804339
(a) Total hourly rate of pay excluding bonuses, all sectors. Index base: 2008–09 = 100.0.
(b) Quarterly figures are seasonally adjusted.
Source: ABS, Wage Price Index, Australia, Cat. no. 6345.0 | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=6345.0&viewtitle=Labour%20Price%20Index,%20Australia~Dec%202007~Latest~20/02/2008&&tabname=Past%20Future%20Issues&prodno=6345.0&issue=Dec%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=6345.0&viewtitle=Labour%20Price%20Index,%20Australia~Dec%202007~Latest~20/02/2008&&tabname=Past%20Future%20Issues&prodno=6345.0&issue=Dec%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=6345.0&viewtitle=Labour%20Price%20Index,%20Australia~Dec%202007~Latest~20/02/2008&&tabname=Past%20Future%20Issues&prodno=6345.0&issue=Dec%202007&num=&view=&
Note: Prior to September quarter 2012, this publication was known as Labour Price Index. The catalogue number (6345.0) remains unchanged.
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 2014-02-19 00:00:00
Spreadsheet: 703629d1605092206-create-summary-sheet-trail
Sheet: Summary

 | Sheet | Part No. | Rev. | 1 | 5 | 10 | 50 | 100
 | Sheet1
 | Sheet2
 | Sheet3
 | Sheet4
 | Sheet5
 | Sheet6
 | Sheet7
 | Sheet50
Spreadsheet: 99752d1298325094-excel-2007-table-autoexpansion-issues-sales-figures-sample
Sheet: Sheet1

Location | Month | Year | Territory | Sales | Gross Profit
US | January | 2011 | CT | 1000 | 15075
US | January | 2011 | MA | 2000 | 35852
US | January | 2011 | VT | 1500 | 20042
US | January | 2011 | NH | 3819 | 12779
US | January | 2011 | ME | 3819 | 95736
US | January | 2011 | RI | 4515 | 16525
US | January | 2011 | PA | 3777 | 8806
US | January | 2011 | NJ | 4521 | 1976
US | January | 2011 | DE | 9354 | 3199
US | January | 2011 | MD | 1524 | 5949
CA | January | 2011 | CT | 5365
CA | January | 2011 | MA | 8462
CA | January | 2011 | VT | 2645
CA | January | 2011 | NH | 4581
CA | January | 2011 | ME | 1025
CA | January | 2011 | RI | 6103
CA | January | 2011 | PA | 5521
CA | January | 2011 | NJ | 9608
CA | January | 2011 | DE | 3151
CA | January | 2011 | MD | 3409
CA | January | 2011 | KY | 5827
US | February | 2011 | CT
US | February | 2011 | MA
US | February | 2011 | VT
US | February | 2011 | NH
US | February | 2011 | ME
US | February | 2011 | RI
US | February | 2011 | PA
US | February | 2011 | NJ
US | February | 2011 | DE
US | February | 2011 | MD
CA | February | 2011 | CT
CA | February | 2011 | MA
CA | February | 2011 | VT
CA | February | 2011 | NH
CA | February | 2011 | ME
CA | February | 2011 | RI
CA | February | 2011 | PA
CA | February | 2011 | NJ
CA | February | 2011 | DE
CA | February | 2011 | MD
CA | February | 2011 | KY
Spreadsheet: 851768d1701900002-help-with-a-filter-formula-and-date-sample
Sheet: DATA

 | Client: Referral Source |  |  | Client: Ethnicity
 | Alameda County Office of Education | School, SARB, SART |  | [DPN]-Afghan/Middle E. | Afghan/Middle E.
 | Alameda County Probation | DA/Truancy (Probation) |  | [DPN]-African-American | African-American
 | Bar Association of San Francisco | Other |  | [DPN]-Am indian/[NAME]. | Am indian/[NAME].
 | CCHS Conley-Caraballo High School | School, SARB, SART |  | [DPN]-Asian/Pacific Is. | Asian/Pacific Is.
 | [NAME] | School, SARB, SART |  | [DPN]-Latino/Hispanic | Latino/Hispanic
 | Centro De Servicios | Other |  | [DPN]-Mixed Ethnicity | [NAME]
 | City of Fremont Youth and Family Services | Other |  | [DPN]-Other/Unknown | Other/Unknown
 | City of Union City | Other |  | [DPN]-White/.Caucasian | White/Caucasian
 | Filipino Advocates for Justice | Other
 | FLY Fresh Lifeliness for Youth | Other |  | [P64]-American Indian/Alaska Native | Am indian/[NAME].
 | Fremont Family Resource Center | Other |  | [P64]-Asian Indian | Asian/Pacific Is.
 | Household | Family, Self |  | [P64]-Black or African American | African-American
 | [NAME] | School, SARB, SART |  | [P64]-Decline to state | Other/Unknown
 | [NAME] | School, SARB, SART |  | [P64]-Filipino | Asian/Pacific Is.
 | MidPen Housing Services | Other |  | [P64]-Guamanian | Asian/Pacific Is.
 | NHUSD New Haven Unified School District | School, SARB, SART |  | [P64]-Hispanic, Latino, or Spanish | Latino/Hispanic
 | Searles Elementary School | School, SARB, SART |  | [P64]-Middle Eastern/North African | Afghan/Middle E.
 | UCFC Union City Family Center | Other |  | [P64]-Multi-ethnic origin, ethnicity or race that includes American Indian/Alaska Native | [NAME]
 | UCPD Union City Police Department | Law Enforcement |  | [P64]-Other (Asian) | Asian/Pacific Is.
 | UCYFS Youth and Family Services | Other |  | [P64]-Unknown | Other/Unknown
 |  |  |  | [P64]-White | White/Caucasian
 |  |  |  | Other | Other/Unknown
Spreadsheet: 69663d1270215642-drop-down-lists-to-populate-an-order-form-getlist
Sheet: Sheet1

suppliers |  | stock |  | [NAME] | STOCK CODE | RE-ORDER QTY
wickes |  | BOUGHT STOCK |  | hoses7 | 493848 | 8
 |  |  |  | hoses18 | 493892 | 40
 |  |  |  | hoses4 | 493836 | 80
 |  |  |  | hoses5 | 493840 | 52
 |  |  |  | hoses11 | 493864 | 4
Spreadsheet: 59532d1260073149-league-spreadsheet-709588-league-spreadsheet
Sheet: Teams

Teams | 1 | Blue | members | Blue | red |  |  | total number of teams | 6
 | 2 | red |  | bill | [NAME] |  |  | total number of pairings per week | 3
 | 3 | yellow |  | bob | ron
 | 4 | green |  | [NAME] | ray
 | 5 | purple
 | 6 | orange |  | yellow | green
 |  |  |  | [NAME] | gary
 |  |  |  | erin | grendel
 |  |  |  | elwood | greg
 |  |  |  | purple | orange
 |  |  |  | [NAME] | oliver
 |  |  |  | pete | [NAME]
 |  |  |  | [NAME] | otto
Spreadsheet: 7f4f71ab-4fec-4148-9937-9f21486049fa
Sheet: 15a

Product1 | Cleared2 | Uncleared | TOTAL
Index Tranche | 0 | 64 | 64
Index | 540859 | 3808 | 544667
Europe | 285905 | 1416 | 287320
North America/Asia | 248613 | 1641 | 250253
Other | 6342 | 752 | 7093
OTHER* | 1550 | 4939 | 6489
TOTAL | 542409 | 8811 | 551220
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 08309c3a-e586-405e-bb2d-a80c26a2801e
Sheet: 2Yearly O&M Costs 11-20

Table 5.2.18. Present Value of Operations and [NAME] (Years 11-20)
 |  |  |  |  |  |  |  |  |  |  |  | EPA Discount Rate:
 |  |  |  | Present Value of O&M Costs for Year:
Component | Unit Cost | Unit | Quantity | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 |  |  | Total Present Value of Yearly O&M Expenses (Years 11-20):
 |  |  |  |  |  |  |  |  |  |  |  | Total Present Value of Annual O&M Costs (Life of Project):
i= | 0.04875
Spreadsheet: 164596d1340816602-excel-2007-index-with-duplicates-department-updates-and-announcements
Sheet: NetworkDevelopment

Announcement Number | Employee Announcements |  |  |  |  | Announcement Number | Employee Announcements
1 |  |  |  |  |  | 1
2 |  |  |  |  |  | 2
3 |  |  |  |  |  | 3
4 |  |  |  |  |  | 4
5 |  |  |  |  |  | 5
6 |  |  |  |  |  | 6
7 |  |  |  |  |  | 7
Announcement Number | Manager [NAME] |  |  |  |  | Announcement Number | Manager [NAME]
1 |  |  |  |  |  | 1
2 |  |  |  |  |  | 2
3 |  |  |  |  |  | 3
4 |  |  |  |  |  | 4
5 |  |  |  |  |  | 5
6 |  |  |  |  |  | 6
7 |  |  |  |  |  | 7
Spreadsheet: 731373d1620312134-defining-a-pivot-table-column-in-a-sumif-formula-sample-data
Sheet: Pivot table

proposed budget | (Multiple Items)
actual spend | (blank)
category 1 | (Multiple Items)
Row Labels | scheme | Sum of proposed budget
x013 | address4 | 100000
 | grape | 100000
x013 Total |  | 100000
x015 | address6 | 300000
 | pear | 300000
x015 Total |  | 300000
[NAME] | address7 | 400000
 | clementine | 400000
x016 Total |  | 400000
x017 | address8 | 500000
 | [NAME] and lemon | 500000
x017 Total |  | 500000
x018 | [NAME] | 600000
 | blueberry | 600000
x018 Total |  | 600000
x023 | address14 | 30000
 | pear, lemon | 30000
x023 Total |  | 30000
x024 | address15 | 40000
 | ginger | 40000
x024 Total |  | 40000
x025 | address16 | 50000
 | carot | 50000
x025 Total |  | 50000
Grand Total |  | 2020000
Spreadsheet: 730471d1619708718-highlight-date-range-on-calendar-ef1523_test-2-copy
Sheet: Calendar

 | 2020 | FEBRUARY |  | MONDAY |  | 3099 Issue [NAME]
 | CALENDAR YEAR | CALENDAR MONTH |  | FIRST DAY OF WEEK
 |  | 43851 | 43852 | 43853 | 43854 | 43855 | 43856
 |  | 2020-01-28 00:00:00 | 2020-01-29 00:00:00 | 2020-01-30 00:00:00 | 2020-01-31 00:00:00 | 2020-02-01 00:00:00 | 2020-02-02 00:00:00
 |  | 2020-02-04 00:00:00 | 2020-02-05 00:00:00 | 2020-02-06 00:00:00 | 2020-02-07 00:00:00 | 2020-02-08 00:00:00 | 2020-02-09 00:00:00
 |  | 2020-02-11 00:00:00 | 2020-02-12 00:00:00 | 2020-02-13 00:00:00 | 2020-02-14 00:00:00 | 2020-02-15 00:00:00 | 2020-02-16 00:00:00
 |  | 2020-02-18 00:00:00 | 2020-02-19 00:00:00 | 2020-02-20 00:00:00 | 2020-02-21 00:00:00 | 2020-02-22 00:00:00 | 2020-02-23 00:00:00
 |  | 2020-02-25 00:00:00 | 2020-02-26 00:00:00 | 2020-02-27 00:00:00 | 2020-02-28 00:00:00 | 2020-02-29 00:00:00 | 2020-03-01 00:00:00
 |  | 2020-03-03 00:00:00 | 2020-03-04 00:00:00 | 2020-03-05 00:00:00 | 2020-03-06 00:00:00 | 2020-03-07 00:00:00 | 2020-03-08 00:00:00