tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 723375d1615654646-conditional-formatting-and-color-cells-with-formula-testnameamount1
Sheet: Blad1

project | datum | nr vlist | nr defensie | vertrek | tijd | aankomst | aantal | wie NL | wie D | inkoop NL | inkoop D | verkoop NL | verkoop D
5154 | 2021-03-18 00:00:00 | 20404500 | 17NLD102 | Loheide | 22:00:00 | de lutte | 1 |  | nl | 3 | 254 | 4 | 255 |  | uren inkoop |  |  | km inkoop
5154 | 2021-03-18 00:00:00 | 20404500 | 17NLD102 | Loheide | 22:00:00 | de lutte | 1 |  | nl | 3 | 255 | 4 | 260 |  | [NAME] |  |  | km verkoop
5155 | 2021-03-18 00:00:00 | 20404757 | 18NLD104 | amersfoort | 20:00:00 | Loheide | 2 | ik | ics | 3 | 244 | 4 | 264 |  | [NAME] |  |  | [NAME]
5155 | 2021-03-18 00:00:00 | 20404757 | 18NLD104 | amersfoort | 20:00:00 | Loheide | 2 | nl | ics | 4 | 266 | 5 | 270
5155 | 2021-03-18 00:00:00 | 20404757 | 18NLD104 | amersfoort | 20:00:00 | Loheide | 2 |  | ics | 4 | 260 | 5 | 261 |  | Inkoop NL |  |  | Inkoop D
5156 | 2021-03-18 00:00:00 | 20404797 | 18NLD103 | Loheide | 22:30:00 | de lutte | 1 |  | ast | 3 | 299 | 4 | 300 |  | [NAME] |  |  | Verkoop D
5156 | 2021-03-18 00:00:00 | 20404797 | 18NLD103 | Loheide | 22:30:00 | de lutte | 1 |  | ast | 4 | 256 | 5 | 261 |  | [NAME] |  |  | Verschil D
5156 | 2021-03-18 00:00:00 | 20404797 | 18NLD103 | Loheide | 22:30:00 | de lutte | 1 |  | ast | 5 | 244 | 6 | 250
5157 | 2021-03-18 00:00:00 | 20404793 | 17NLD105 | Loheide | 22:45:00 | de lutte | 1 |  | nl | 5 | 266 | 6 | 270 |  | Totaal inkoop |  |  | proj nl in
5157 | 2021-03-18 00:00:00 | 20404793 | 17NLD105 | Loheide | 22:45:00 | de lutte | 1 |  | nl | 5 | 298 | 6 | 302 |  | Totaal verkoop |  |  | proj nl ver
5158 | 2021-03-18 00:00:00 | 20404798 | 17NLD107 | Loheide | 23:30:00 | de lutte | 1 |  | nl | 3 | 245 | 4 | 264 |  | totaal [NAME] |  |  | [NAME] in
5158 | 2021-03-18 00:00:00 | 20404798 | 17NLD107 | Loheide | 23:30:00 | de lutte | 1 |  | nl | 4 | 256 | 5 | 282 |  |  |  |  | [NAME] ver
5159 | 2021-03-19 00:00:00 | 20404799 | 17NLD108 | Loheide | 00:00:00 | darp | 2 | rene | rene | 3 | 250 | 4 | 271
5159 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | projrct [NAME] |  | project [NAME]
5159
5159 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | search code | aantal beg | inkoop NL | inkoop D | verkoop NL | verkoop D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5156
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | per begeleider
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | customer | amount
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | nl
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ik
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | willem
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | hilco
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ast
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ics
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | rene
Spreadsheet: 509091d1490550923-how-to-get-the-information-of-one-sheet-in-another-sheet-row-wise-test-tt-260317
Sheet: preview

TR NAME : ABC | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
MON | 11A |  | 12A | 10A |  | 9A | 11A
TUE | 11A |  | 12A | 10A |  | 9A | 11A | 11A
WED | 11A |  | 12A | 10A |  | 9A | 9B
THU | 11A |  | 12A | 10B |  | 12A | 12A
FRI | 11A |  | 12A | 10B |  | 12A | 9B
SAT | 11A |  | 12A | 10B |  |  | 9B
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
MON
TUE
WED
THU
FRI
SAT
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
MON
TUE
WED
THU
FRI
SAT
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
MON
TUE
WED
THU
FRI
SAT
Spreadsheet: 717317d1612571807-offset-index-match-formula-help-product-equivalence
Sheet: Sheet1

Product Equivalence
 | Vendor 1 | Vendor 2 | Vendor 3
Product 1 | TV Big | TV Large | TV Huge
Product 2 | Oven Gas | Gas Oven | Oven  non-electric
Product 3 | Large Sofa | Sofa 3 Cushion | Sofa
 |  |  | Vendor Product Number |  |  | Vendor Price |  |  | Proposed Spend
Current Vendor | Current Product | Usage | Vendor 1 | Vendor 2 | Vendor 3 | Vendor 1 | Vendor 2 | Vendor 3 | Vendor 1 | Vendor 2 | Vendor 3
Vendor 1 | Product 1 | 3 |  |  |  | Vlookup from vendor price tables using product number values from left
Vendor 1 | Product 2 | 5
Vendor 1 | Product 3 | 4
Vendor 2 | Product 1 | 9
Vendor 2 | Product 2 | 4
Vendor 2 | Product 3 | 2
Vendor 3 | Product 1 | 1
Vendor 3 | Product 2 | 6
Vendor 3 | Product 3 | 7
Spreadsheet: 100874d1299095055-multiple-conditions-on-data-validation-datavalidaton_problem
Sheet: Data

 | Date | Brand | Category | Feeling | Topic | Topic2 | Topic3 | URL | Content |  | Top2 Hidden | Top3 Hidden
 |  | Brand1 | [NAME] | Positive | [NAME]
Spreadsheet: 725296d1616606918-sum-data-by-month-p-l-statement-example
Sheet: Income

INCOME
Date | Client | Amount | Notes | Invoice Number | Status | Payment Date
2019-04-10 00:00:00 | Client A | 100 | Services provided | 1 | Paid | 2019-04-10 00:00:00
2019-04-15 00:00:00 | Client B | 200 | Services provided | 2 | Paid | 2019-04-15 00:00:00
2019-05-03 00:00:00 | Client A | 300 | Services provided | 3 | Paid | 2019-05-03 00:00:00
2019-05-10 00:00:00 | Client B | 100 | Services provided | 4 | Paid | 2019-05-10 00:00:00
2019-05-18 00:00:00 | Client A | 200 | Services provided | 5 | Paid | 2019-05-18 00:00:00
2019-05-19 00:00:00 | Client B | 300 | Services provided | 6 | Paid | 2019-05-19 00:00:00
2019-06-10 00:00:00 | Client A | 100 | Services provided | 7 | Paid | 2019-06-10 00:00:00
2019-06-11 00:00:00 | Client B | 200 | Services provided | 8 | Paid | 2019-06-11 00:00:00
2019-06-12 00:00:00 | Client A | 300 | Services provided | 9 | Paid | 2019-06-12 00:00:00
Spreadsheet: jeff_dasovich__14103__California PJM and NE Tables revised2
Sheet: A19

TABLE A19 FREQUENCY OF PRICE SPIKES IN CALIFORNIA ISO LOAD NON-SPINNING RESERVE MARKET NP15
PRICE EQUALS OR EXCEEDS | FY 00/99 | FY 99/98
 | # of hours
 | % of available hours
100 | 112 | 140
 | 0.01275 | 0.01598
250 | 64 | 87
 | 0.00729 | 0.00993
500 | 38 | 0
 | 0.00433 | 0
750 | 0 | 0
 | 0 | 0
1000 | 0 | 0
 | 0 | 0
Source: CAISO website (www.caiso.com)
FY 00/99: 8/1/1999-7/31/2000
FY 99/98: 8/1/1998-7/31/1999
Spreadsheet: b099dc30-b00b-43d7-b3bc-ea2ba8e02919
Sheet: Page 3

Permit No.: |  |  | WQ0000795 |  |  | Facility Name: |  | Surf City WWTF |  |  |  |  |  | County: | Pender |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 09 |  | Field Name: |  | 10 |  | Field Name: |  | 11 |  | Field Name: |  | 12
 |  |  |  |  |  | Area (acres): |  | 5.3 |  | Area (acres): |  | 5.21 |  | Area (acres): |  | 4.6 |  | Area (acres): |  | 6.25
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in):
 |  |  |  |  |  | Annual Rate (in): |  | 10.73 / 60.38 |  | Annual Rate (in): |  | 10.73 / 60.38 |  | Annual Rate (in): |  | 10.73 / 60.38 |  | Annual Rate (in): |  | 10.73 / 60.38
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 102897d1300805484-match-cell-from-array-and-copy-entire-row-example
Sheet: Meters Removed

 | [NAME] Removed | [NAME] | Manuf | New Meter
 | 10088197 | 2S | SI | 6024596079
 | 48284701 | 2S | SI | 6024376754
 | 10088241 | 2S | SI | 6024597648
 | 10088243 | 2S | SI | 6024593205
 | 10088245 | 2S | SI | 6024597333
 | 10088275 | 2S | SI | 6024595589
 | 10088336 | 2S | SI | 21200718
 | 48015813 | 2S | SI | 6024595948
 | 10088352 | 2S | SI | 6024595951
 | 10088357 | 2S | SI | 6024593036
 | 10221325 | 2S | SI | 6024595946
 | 10221339 | 2S | SI | 6024596447
 | 10221340 | 2S | SI | 6024594075
 | 10221350 | 2S | SI | 6024595787
 | 10221374 | 2S | SI | 6024596510
 | 48284642 | 2S | SI | 6024594336
 | 10239911 | 2S | SI | 6024594018
 | 10239923 | 2S | SI | 6024594425
 | 10239941 | 2S | SI | 6024597692
 | 10239941 | 2S | SI | G011662300
 | 10239944 | 2S | SI | 6024594541
Spreadsheet: 732643d1621092806-price-menu-dependent-drop-downs-with-lookup-function-based-on-multiple-selections-price-menu-xlookup
Sheet: Service Invoice

 |  | INVOICE
 | Company Name
 | street |  | DATE:
 | City, ST  ZIP Code |  | INVOICE # | 100
 |  |  | FOR: | Project or Service Description
 | BILL TO:
 | Name
 | Company Name |  | Make | Model
 | Street Address |  | HONDA | Fit
 | City, ST  ZIP Code
 | Phone
 | Category | Service | HOURS | AMOUNT
 | BRAKES | MASTER CYLINDER REPLACEMENT
 | BRAKES | R&R FRONT BRAKE PADS
 |  |  | TAX RATE | 0.0775
 |  |  | SALES TAX
 |  |  | OTHER
 |  |  | TOTAL
Spreadsheet: 7573b3ce-52fe-4106-91cd-dc8978ecdbbd
Sheet: Sheet1

Cabinet configuration (speaker count x speaker size in inches). | Total surface area in cubic inches.
4x15 | 707.1
8x10 | 628.6
2x18 | 509.1
6x10 | 471.4
4x12 | 452.6
8x8 | 402.3
2x15 | 353.6
4x10 | 314.2
6x8 | 301.7
1x18 | 254.6
8x6 | 226.3
2x12 | 226.2
4x8 | 201.1
1x15 | 178.7
6x6 | 169.7
2x10 | 157.1
4x6 | 113.1
1x12 | 113.1
2x8 | 100.6
1x10 | 78.6
2x6 | 56.6
Spreadsheet: 743794d1628728019-help-pls-hard-excel-countif-for-multiple-criteria-rollbook-20example-20final
Sheet: TU1 HQ

 |  |  |  |  |  |  |  |  |  |  |  | AUGUST
PMKEYS | RANK | NAME | TE | PL | HOTELS | SECTION | SERCAT | UNIT | HOME LOC | START DT | END DT | 10/08 | 11/08 | 12/08 | 13/08 | 14/08 | 15/08 | 16/08 | 17/08 | 18/08 | 19/08 | 20/08 | 21/08 | 22/08 | 23/08 | 24/08 | 25/08 | 26/08 | 27/08 | 28/08 | 29/08 | 30/08 | 31/08
810000 | PTE(P) | Henz,Excel | [NAME] | HQ | [NAME] | 0 |  | REGULAR |  |  |  | ENOG-LO | ENOG-LO | ENOG-LO | ENOG-LO | R-GOLD-LI | R-GOLD-LI | AM-GOLD-LO | AM-BRIS-LO | AM-BRIS-LO | AM-BRIS-LO
Spreadsheet: louise_kitchen__22533__3base329c
Sheet: Initial

Porcupine Initial Balance Sheet and 3% Test
Raptor 3
2000-09-27 00:00:00
Resco Warrants |  | 120600
Initial Value |  | 2149.55
IPO/Hedge Value |  |  | 21
Shares per warrant |  | 200
Warrants subject to TRS |  | 90042
At inception
 | Assets |  |  | Liabilities + Equity
 | Cash |  |  | Note Payable | 259212085
 | ResCo Warrants |  |  | Note Payable
 | Note from ENE | 50000000 |  | Minority Interest
 |  |  |  | LJM | 30000000
 |  |  |  | ENE | 1000
Spreadsheet: 67785d1268316894-using-auto-complete-horizontally-test-1-
Sheet: Conference DashBoard

Conference Name | Date | Host/Sponsor | Location | Audience | Themes | Notes | Past Participation | Cost | BTF Participation | Key Personnel
Data Interoperability Conference | 2010-02-08 00:00:00 | ABCD | Los Angeles, CA | Data and Information Policy Leaders | New Challenges and Opportunities for the Enterprise | None | None | 1900-08-12 00:00:00 | Person1 | TBD
Data Interoperability Conference | Cell B1 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
Spreadsheet: 681634d1591682180-calculate-order-values-using-records-in-multiple-tables-supplier-order-values-aligw
Sheet: ORDER SHEET

CUSTOMER | ITEM | QTY | SUPPLIER | ORDER # | COST
GEORGE | BVBB123 | 2 | COMPANY A
[NAME] | RVTR321 | 1 | COMPANY B
STEPHEN | BSBB222 | 1 | COMPANY A
[NAME] | RVTR111 | 2 | COMPANY B
Spreadsheet: 123593d1317746014-excel-2007-row-count-help-example
Sheet: Sheet1

AcctNbr | Pages |  |  | AcctNbr | PageCount
123456 | Page 1 of 2 |  |  | 123456 | 2
123456 | Page 2 of 2 |  |  | 456789 | 2
456789 | Page 1 of 2 |  |  | 444444 | 1
456789 | Page 2 of 2 |  |  | 555555 | 3
444444 | Page 1 of 1 |  |  | 987654 | 4
555555 | Page 1 of 3
555555 | Page 2 of 3
555555 | Page 3 of 3
987654 | Page 1 of 4
987654 | Page 2 of 4
987654 | Page 3 of 4
987654 | Page 4 of 4
Spreadsheet: 860626d1708645264-calculate-averages-in-different-columns-based-experiment-dpsh-averages
Sheet: Sheet1

Depth of measurment | DPSH-22+564 | DPSH-32+846 |  |  | ID | top of layer | bottom of layer | Average blows
 | Blows | Blows |  |  | PD-22+564 | 0 | 0.2
0 | 0 | 0 |  |  | PD-22+564 | 0.2 | 0.5
0.2 | 40 | 21 |  |  | PD-22+564 | 0.5 | 1
0.4 | 28 | 33 |  |  | PD-22+564 | 1 | 5
0.6 | 45 | 17 |  |  | PD-32+846 | 0 | 0.4
0.8 | 22 | 39 |  |  | PD-32+846 | 0.4 | 1
1 | 24 | 6 |  |  | PD-32+846 | 1 | 2.3
1.2 | 15 | 3 |  |  | PD-32+846 | 2.3 | 5
1.4 | 30 | 40
1.6 | 30 | 30
1.8 | 36 | 32
2 | 33 | 21
2.2 | 4 | 28
2.4 | 3 | 50
2.6 | 4 | 36
2.8 | 20 | 17
3 | 27 | 9
3.2 | 50 | 31
3.4 | 4 | 20
3.6 | 33 | 18
3.8 | 42 | 5
4 | 30 | 44
4.2 | 33 | 35
4.4 | 9 | 39
4.6 | 14 | 23
4.8 | 47 | 31
5 | 12 | 6
Spreadsheet: 690845d1597318568-no-body-can-fill-this-sheet-if-todays-date-over-password-protected-covid-checklist
Sheet: Sheet1

 | [NAME]
 | Questions |  | Yes | No | Remarks
 | General Questions
 | 1 | Own vehicle used for coming in office
 | 2 | Coming all alone to office
 | 3 | Thermal Scaning done at gate
 | 4 | Self declaration fill with proper information at gate
 | 5 | Wearing of masks provided by company during duty
 | 6 | Wearing mask properly in correct way informed
 | 7 | Non declaration if residence is undeer containment zone
 | 8 | Non declaration of self or family members residing in same household in self declaration form
 | 9 | Non declaration or late declaration of any covid symptoms, hospitalization etc, in self or family members to company officials
 | 10 | Use of sanitizer or soap wash done periodically during duty
 | 11 | Has the PPE stocks monitored everyday
 | 12 | Social Distancing maintain in office area and during going to canteen.
Spreadsheet: 716717d1612342515-help-filtering-2-columns-silmutaneously-testing
Sheet: Sheet1

CONTRACTOR | COUNTRY OF COMPANY/ LEADER | CONTRACT VALUE | SIGNATURE DATE | AMENDMENT / EXCHANGE SIGNATURE |  |  |  | CONTRACTOR | COUNTRY OF COMPANY/ LEADER | CONTRACT VALUE | SIGNATURE DATE | AMENDMENT / EXCHANGE SIGNATURE
Gonzales | Greece | 7679169.49 | 2019-07-16 00:00:00 | 2020-08-31 00:00:00
Gonzales | Greece | 1977356.83 | 2019-01-11 00:00:00 | 2020-08-31 00:00:00
Gonzales | Greece | 307600.7 | 2019-05-03 00:00:00 | 2020-08-31 00:00:00
Gonzales | Belgium | 80000 | 2020-05-09 00:00:00 | 2021-01-15 00:00:00
Gonzales | Greece | 607600.7 | 2020-07-30 00:00:00 | 2021-01-20 00:00:00
Gonzales | Malta | 132000 | 2020-09-28 00:00:00 | 2021-01-20 00:00:00
Gonzales | Malta | 38500 | 2020-05-04 00:00:00 | 2021-01-15 00:00:00
Gonzales | Malta | 15000 | 2020-06-22 00:00:00 | 2021-01-20 00:00:00
Gonzales | Malta | 60000 | 2020-06-02 00:00:00 | 2021-01-20 00:00:00
Gonzales | Malta | 44000 | 2020-10-16 00:00:00 | 2020-03-24 00:00:00
Gonzales | Malta | 60000 | 2020-05-26 00:00:00 | 2021-01-20 00:00:00
Gonzales | Malta | 6000 | 2016-04-28 00:00:00 | 2020-06-05 00:00:00
Gonzales | Spain | 300000 | 2016-02-03 00:00:00 | 2020-06-11 00:00:00
Gonzales | Belgium |  | 2016-03-03 00:00:00 | 2020-03-03 00:00:00
Gonzales | Spain | 900000 | 2016-03-03 00:00:00 | 2020-03-03 00:00:00
Gonzales | Belgium |  | 2016-03-04 00:00:00 | 2020-03-03 00:00:00
Gonzales | Belgium | 2000000 | 2016-06-09 00:00:00 | 2020-03-24 00:00:00
Gonzales | Greece |  | 2016-06-09 00:00:00 | 2020-06-03 00:00:00
Gonzales | Belgium |  | 2016-06-09 00:00:00 | 2020-06-16 00:00:00
Gonzales | France | 6000000 | 2016-05-26 00:00:00 | 2020-08-18 00:00:00
Gonzales | Italy |  | 2016-04-19 00:00:00 | 2020-06-24 00:00:00
Gonzales | Greece |  | 2016-02-16 00:00:00 | 2020-03-11 00:00:00
Gonzales | Macedonia | 1000000 | 2016-04-19 00:00:00 | 2020-03-11 00:00:00
Gonzales | Romania | 1200000 | 2016-03-30 00:00:00 | 2020-07-27 00:00:00
Gonzales | Malta | 3000000 | 2016-07-29 00:00:00 | 2020-07-14 00:00:00
Gonzales | Italy | 1600000 | 2016-10-10 00:00:00 | 2020-09-09 00:00:00
Gonzales | Malta | 495000 | 2016-05-10 00:00:00 | 2018-01-04 00:00:00
Gonzales | The Netherlands | 60000 | 2016-12-16 00:00:00 | 2018-01-04 00:00:00
Gonzales | Belgium | 165000 | 2016-11-30 00:00:00 | 2018-10-22 00:00:00
Spreadsheet: 50415d1249859433-sum-according-to-auto-filter-non-visible-cells-subtotal
Sheet: Sheet1

Col. "A" is Auto filtered
Custom: Greater than 100
Amount | #
80
130 | 6
20 | 5
60 |  |  | 0
90
15 | 5
110 | 3
30
120 | 5.5
Need to sum only Visible cells in col. "A" |  |  | 250
while adjacent cells (col. "B") are greater than 5 |  |  | Requested result:
 |  |  | 250
Spreadsheet: jeff_dasovich__14103__California PJM and NE Tables revised2
Sheet: A6

TABLE A6 FREQUENCY OF PRICE SPIKES IN CALIFORNIA ISO REAL-TIME ENERGY MARKET NP15
PRICE EQUALS OR EXCEEDS | FY 00/99 | FY 99/98
 | # of hours
 | % of available hours
100 | 708 | 155
 | 0.0806 | 0.0178
250 | 216 | 38
 | 0.02459 | 0.00434
500 | 83 | 0
 | 0.00945 | 0
750 | 26 | 0
 | 0.0029 | 0
1000 | 0 | 0
 | 0 | 0
Source: CAISO website (www.caiso.com)
FY 00/99: 8/1/1999-7/31/2000
FY 99/98: 8/1/1998-7/31/1999
Spreadsheet: 38339d1236468406-countif-within-a-range-slovenc0417_excel_forum_countif_database_ronc
Sheet: Contacts

First Name 1 | Last Name 1 | Contact Media | Last Visit |  | Monday through Sunday |  | # of Visititors | Drive By | Ivy Website | Radio Ad | RJP Website | Signs
Ami | Franks | RJP Website | 2008-11-08 00:00:00 |  | 2008-11-03 00:00:00 | 2008-11-09 00:00:00 | 3 | 0 | 1 | 0 | 2 | 0
Cathy | Scott | Ivy Website | 2008-11-08 00:00:00 |  | 2008-11-10 00:00:00 | 2008-11-16 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Smith | RJP Website | 2008-11-08 00:00:00 |  | 2008-11-17 00:00:00 | 2008-11-23 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Mouton | Radio Ad | 2009-11-13 00:00:00 |  | 2008-11-24 00:00:00 | 2008-11-30 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Sadler | RJP Website | 2009-11-13 00:00:00 |  | 2008-12-01 00:00:00 | 2008-12-07 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Burbank | Radio Ad | 2009-11-13 00:00:00 |  | 2008-12-08 00:00:00 | 2008-12-14 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
Jeanette | [NAME] | Drive By | 2009-11-13 00:00:00 |  | 2008-12-15 00:00:00 | 2008-12-21 00:00:00 | 5 | 0 | 1 | 2 | 0 | 2
[NAME] | [NAME] | Radio Ad | 2008-12-17 00:00:00 |  | 2008-12-22 00:00:00 | 2008-12-28 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
Kathy | Hart | Signs | 2008-12-18 00:00:00 |  | 2008-12-29 00:00:00 | 2009-01-04 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Hribar | Signs | 2008-12-19 00:00:00 |  | 2009-01-05 00:00:00 | 2009-01-11 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
Leticia | Crowe | Radio Ad | 2008-12-19 00:00:00 |  | 2009-01-12 00:00:00 | 2009-01-18 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Burbank | Ivy Website | 2008-12-19 00:00:00 |  | 2009-01-19 00:00:00 | 2009-01-25 00:00:00 | 6 | 0 | 1 | 1 | 1 | 3
[NAME] | McCarney | Radio Ad | 2009-01-21 00:00:00 |  | 2009-01-26 00:00:00 | 2009-02-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Warrior | Signs | 2009-01-21 00:00:00 |  | 2009-02-02 00:00:00 | 2009-02-08 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
Sandee | Grace | Signs | 2009-01-21 00:00:00 |  | 2009-02-09 00:00:00 | 2009-02-15 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | [NAME] | Signs | 2009-01-21 00:00:00 |  | 2009-02-16 00:00:00 | 2009-02-22 00:00:00 | 2 | 0 | 0 | 0 | 1 | 1
Flip | [NAME] | Ivy Website | 2009-01-22 00:00:00 |  | 2009-02-23 00:00:00 | 2009-03-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | [NAME] | RJP Website | 2009-01-23 00:00:00 |  | 2009-03-02 00:00:00 | 2009-03-08 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
Toi | Spelman | RJP Website | 2009-02-21 00:00:00 |  | 2009-03-09 00:00:00 | 2009-03-15 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | [NAME] | Signs | 2009-02-21 00:00:00 |  | 2009-03-16 00:00:00 | 2009-03-22 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: mary_hain__25906__ENE Analysis of PGE Financials
Sheet: Debt Total

 | Utility Debt | (in $ millions)
 |  | Long-term debt as of September 30, 2000
 | 399 | Current portion of long-term debt
 | -200 | Semiannual payment of current long-term debt
 | 680 | Issuance of five-year notes on November 1, 2000
 | 1817 | Rate reduction bonds
 | 290 | Current portion of rate reduction bonds
 | -145 | Semiannual payment of bonds
 | 1240 | Short-term floating rate notes
 | 1427.758 | Revolving credit line
 | 411.3 | Commercial paper
 |  | TOTAL DEBT
 | 2813 | Electric power procurement
 | 356.8 | Gas procurement
 | 323.151 | Qualifying Facilities
 |  | ESTIMATED LIABILITIES DUE AT 1/31/01
 |  | TOTAL DEBT + ESTIMATED LIABILITIES DUE AT 1/31/01
Spreadsheet: 357059d1415291405-vlookup-to-show-multile-values-in-one-cell-november_dashboard
Sheet: Dashboard 11-(3-7)

 | Monday Targets |  |  |  |  | Tuesday Targets |  |  |  |  | Wednesday Targets |  |  |  |  | Thursday Targets |  |  |  |  | Friday targets
 | Bulk | 570 | Route | 588 |  | Bulk | 380 | Route | 501 |  | Bulk | 394 | Route | 500 |  | Bulk |  | Route |  |  | Bulk |  | Route
 | Stacker Actual |  | Stacker Actual |  |  | Stacker Actual |  | Stacker Actual |  |  | Stacker Actual |  | Stacker Actual |  |  | Stacker Actual |  | Stacker Actual |  |  | Stacker Actual |  | Stacker Actual
 | CPH | CASES | CPH | CASES |  | CPH | CASES | CPH | CASES |  | CPH | CASES | CPH | CASES |  | CPH | CASES | CPH | CASES |  | CPH | CASES | CPH | CASES
[NAME] (0360)
[NAME] (0513)
[NAME] (0684)
[NAME] (1618)
[NAME] (2746)
[NAME] (3286)
[NAME] (4518)
[NAME] (5948)
[NAME] (7643)
[NAME] (7661)
[NAME] (7947)
[NAME] (9177)
[NAME] (9223)
Donnie Justice (9330)
[NAME] (9336)
Brent Pickard (9657)
[NAME] (9201)
Spreadsheet: 04ee76f2-efdb-4fc8-a540-8bde2dc353f7
Sheet: 8.1 Students with Disabilities 

Institution
Indicator 8: Students with Disabilities Enrollment and Graduation
Table 8.1: Enrollment and Graduation of Students with Disabilities / AY 2010-11
Please enter the student with disabilities enrollment and graduation data.
Disabled Students Enrollment
 |  |  |  |  | Fall 2010 (October 15, 2010)
 |  | American Indian |  | Non-Indian |  |  | Total
 |  | M | F | M | F | M | F | Total
Undergraduate | Full Time Total | m | m | m | m
 | Part Time Total | m | m | m | m
 | Total Undergraduate Students
Graduate | Full Time Total
 | Part Time Total
 | Total Graduate Students
Total Headcount
Number of students receiving services |  | m | m | m | m
Degrees / Certificates Conferred to Disabled Students
Degrees / Certificates Conferred |  |  |  |  | July 1, 2010 - June 30, 2011
Number of Students who Earned |  | American Indian |  | Non-Indian |  |  | Total
 |  | M | F | M | F | M | F | Total
Apprenticeship/Occupational Program
Diploma
Certificate |  | m | m | m | m
Associate Degree |  | m | m | m | m
Bachelor's Degree |  | m | m | m | m
Master's Degree |  | m | m | m | m
Total number degrees conferred
Number of Associate's Degree graduates admitted to four-year program |  | m | m | m | m
Number of Bachelor's Degree graduates admitted to graduate school
Number of graduates employed after graduation |  | m | m | m | m
Notes:
We have seven (7) male and four (4) female students with disabilities.  They are all Native American.  They are not separated by full-time or part-time, nor do we separate them out with regard to degrees/Certificates conferred.  Tracking is being refined.
Spreadsheet: 702774d1604517614-need-formula-help-to-compare-2-data-sheets-and-extract-cell-value-demo
Sheet: Sheet B

data 1 | data 2 | data 3 | data 4 | data 5 | data 6 | data 7 | data 8 | data 9 | data 10 | data 11 | data 12 | data 13 | data 14 | data 15 | data 16
x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
value | x | x | x | apple | x | x | x | x | orange | x | x | lemon | x | x | x | <--- matching value combination found. Return value in A6 to Sheet A, P2
x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x