tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 80693d1280918305-multiple-conditional-formatting-conditional-formatting-issue
Sheet: Sheet1

 | Period | Result |  |  |  | 1
Income | Qtr1 | 1000
Income | Qtr2 | 2000
Income | Qtr3 | 3000 |  |  |  | Qtr1 | 1000 | Income
Income | Qtr4 | 4000 |  |  |  | Qtr2 | 2000
# Clients | Qtr1 | 50 |  |  |  | Qtr3 | 3000
# Clients | Qtr2 | 60 |  |  |  | Qtr4 | 4000
# Clients | Qtr3 | 70 |  |  |  | Qtr1 | 50 | # Clients
# Clients | Qtr4 | 80 |  |  |  | Qtr2 | 60
Product % | Qtr1 | 0.1 |  |  |  | Qtr3 | 70
Product % | Qtr2 | 0.2 |  |  |  | Qtr4 | 80
Product % | Qtr3 | 0.3
Product % | Qtr4 | 0.4
Spreadsheet: 106616d1303843708-multiple-cell-drop-down-list-example-pricing-system
Sheet: Data

ITEM CODE | [NAME] | LIST PRICE
A1DR2430 | ANGLE WALL CABINET 1-DRAWERS | 810
A1DR2436 | ANGLE WALL CABINET 1-DRAWERS | 949
A1DR2442 | ANGLE WALL CABINET 1-DRAWERS | 1090
A1DR2448 | ANGLE WALL CABINET 1-DRAWERS | 1362
A1DR2730-15 | ANGLE WALL CABINET 1-DRAWERS | 1053
A1DR2736-15 | ANGLE WALL CABINET 1-DRAWERS | 1234
A1DR2742-15 | ANGLE WALL CABINET 1-DRAWERS | 1416
A1DR2748-15 | ANGLE WALL CABINET 1-DRAWERS | 1771
A2430 | DIAGONAL CORNER WALL CABINET | 555
A2436 | DIAGONAL CORNER WALL CABINET | 694
A2442 | DIAGONAL CORNER WALL CABINET | 835
A2736-15 | DIAGONAL CORNER WALL CABINET | 902
A2742-15 | DIAGONAL CORNER WALL CABINET | 1086
Spreadsheet: 272159d1382242219-sum-exclusive-ocurrence-values-with-2-arguments-example
Sheet: Sheet1

Name | Status | Value
Analyst 3 | closed | 4
Analyst 1 | open | 1
Analyst 3 | closed | 2
Analyst 1 | open | 2
Analyst 2 | open | 1
Analyst 1 | open | 1
Analyst 1 | open | 2
Analyst 2 | Closed | 2
Analyst 2 | open | 1
Analyst 1 | open | 3
Analyst 3 | open | 4
Analyst 2 | open | 4
Analyst 1 | closed | 2
Analyst 1 | closed | 2
Analyst 3 | closed | 4
 | Open | Closed
Analyst 1 | 3 | 1
Analyst 2 | 2 | 1
Analyst 3 | 1 | 2
Spreadsheet: 704216d1605449942-correspondence-between-2-variables-apoio-trabalho-1db1
Sheet: Paises

country | continent
USA | Americas
UK | Europe
New Zealand | Oceania
Canada | Americas
Australia | Oceania
Belgium | Europe
Japan | Asia
Germany | Europe
China | Asia
France | Europe
Mexico | Americas
Spain | Europe
Hong Kong | Asia
Czech Republic | Europe
India | Asia
Soviet Union | Europe
South Korea | Asia
Peru | Americas
Italy | Europe
Russia | Europe
Aruba | Americas
Denmark | Europe
Libya | Africa
Ireland | Europe
South Africa | Africa
Iceland | Europe
Switzerland | Europe
Romania | Europe
West Germany | Europe
Chile | Americas
Netherlands | Europe
Hungary | Europe
Panama | Americas
Greece | Europe
Sweden | Europe
Norway | Europe
Taiwan | Asia
Cambodia | Asia
Thailand | Asia
Slovakia | Europe
Bulgaria | Europe
Iran | Asia
Poland | Europe
Georgia | Asia
Turkey | Asia
Nigeria | Africa
Brazil | Americas
Finland | Europe
Bahamas | Americas
Argentina | Americas
Colombia | Americas
Israel | Asia
Egypt | Africa
Kyrgyzstan | Asia
Indonesia | Asia
Pakistan | Asia
Slovenia | Europe
Afghanistan | Asia
Dominican Republic | Americas
Cameroon | Africa
United Arab Emirates | Asia
Kenya | Africa
Philippines | Asia
Spreadsheet: 594498d1539797950-mutiply-rows-if-date-columns-equal-to-a-full-year-calculate-with-full-year
Sheet: Brendas

Notes To Brendas Case
 | Date | Pin: | Suppot
Date of court order to sell property | 1997-02-26 00:00:00
ARREARS (Letter Dated: 07/22/97) | 1997-07-22 00:00:00 | N/A | 9064
ARREARS (Letter Dated: 07/22/97) | 1997-07-25 00:00:00 | N/A | 3683.69
Notice Of Child Support [NAME] As Of | 1999-09-23 00:00:00 | 00.1126.9656 | 3632.87
Notice Of Child Support [NAME] As Of | 1999-10-19 00:00:00 | 00.1126.9656 | 8243.18 |  | The $4,610.31 Dollors amounts to the difference in money
 |  |  |  |  | between the: $3,632.87 and $8,243.18 accumulated in (26Days).
Difference In Days Between Dates:  9/23/1999 - 10/19/1999 |  | 00.1126.9656
Spreadsheet: darrell_schoolcraft__7445__imball0202
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 | 166919 | 164150
78311 | 57920 | 61000 |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500238 | 152831 | 188748 |  |  |  |  |  |  |  |  | lunch | 7.6
500239 | 169969 | 198005
500293 | 88812 | 101325
500302 |  | 1515
500303 |  | 3929
500305 |  | 263450
500307 | 16824 | 8512
500313 |  | 404
500314
500655 | 30298
500657 | 7029
INDEX
2002-01-31 00:00:00 |  |  | 121933.25
2002-02-05 00:00:00
CBS Volume
 |  |  | 70617
Spreadsheet: 05e63bd6-57e3-46fb-8618-9aeb13ece5dc
Sheet: Sheet1

Tolerances on dimensions and form for hot rolled products according to EN 485-3 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | Tolerances on thickness for sheet, strip and plate
 | Specified thickness t |  | Tolerance on thickness for specifid width w
 | t > | t ≤ | [NAME] | 1250<w≤1600 | 1600<w≤2000 | 2000<w≤2500 | 2500<w≤3500
 | [NAME] 2,5 | 4 | ± 0,28 | ± 0,28 | ± 0,32 | ± 0,35 | ± 0,40
 | 4 | 5 | ± 0,30 | ± 0,30 | ± 0,35 | ± 0,40 | ± 0,45
 | 5 | 6 | ± 0,32 | ± 0,32 | ± 0,40 | ± 0,45 | ± 0,50
 | 6 | 8 | ± 0,35 | ± 0,40 | ± 0,40 | ± 0,50 | ± 0,55
 | 8 | 10 | ± 0,45 | ± 0,50 | ± 0,50 | ± 0,55 | ± 0,60
 | 10 | 15 | ± 0,50 | ± 0,60 | ± 0,65 | ± 0,65 | ± 0,80
 | 15 | 20 | ± 0,60 | ± 0,70 | ± 0,75 | ± 0,80 | ± 0,90
 | 20 | 30 | ± 0,65 | ± 0,75 | ± 0,85 | ± 0,90 | ± 1,0
 | 30 | 40 | ± 0,75 | ± 0,85 | ± 1,0 | ± 1,1 | ± 1,2
 | 40 | 50 | ± 0,90 | ± 1,0 | ± 1,1 | ± 1,2 | ± 1,5
 | Tolerances on width for strip
 | Specified thickness t |  | Tolerance on width for specifid width w
 |  |  | Less than 500 |  | 500…2500
 | 2,5…15 |  | by agreement |  | 0 / +8
 | Tolerances on width and length for sheet and plate
 | Specified thickness t |  | Tolerance on width and length for specifid width w and length x
 | t > | t ≤ | [NAME] 1000 | 1000<x≤2000 | 2000<x≤3000 | 3000<x≤3500 | 3500<x≤6000
 | - | 6 | 0 / +5 | 0 / +7 | 0 / +8 | 0 / +10 | 0 / +10
 | 6 | 12 | 0 / +6 | 0 / +7 | 0 / +8 | 0 / +10 | 0 / +10
 | 12 | 50 | 0 / +6 | 0 / +8 | 0 / +9 | 0 / +10 | 0 / +10
 | For length over 6000 mm up to and icluding 15000 mm, tolerance on length shall be +0,2/-0 % of the nominal length
 | Lateral curvature tolerances for sheet and plate
 | Specified width w |  | Lateral curvature dmax for specified length L
 | w > | [NAME] | L ≤ 2000 | 2000<L≤3000 | 3000<L≤5000 | 5000<L≤15000
 | - | 1250 | 4 | 7 | 10 | 0,2 % of
 | 1250 | 1500 | 3 | 6 | 8 | specified length
 | 1500 | 2000 | 3 | 6 | 7
 | 2000 | 3500 | - | 5 | 6
 | Flatness tolerances for sheet and plate
 | Specified thickness t |  | Total deviation % |  | Partial deviation %
 | t > | t ≤ | on length | on width | (for a chord ≥ 300 mm)
 |  |  | dmax / L | dmax / W | dmax / l
 | [NAME] 2,5 | 3,0 | 0,4 | 0,5 | 0,5
 | 3,0 | 6,0 | 0,3 | 0,4 | 0,35
 | 6,0 | 50 | 0,2 | 0,4 | 0,3
 | 50 | 350 | 0,2 | 0,2 | by agreement
 | Squareness tolerances for sheet and plate
 | Specified length L |  | Squareness tolerance for specified [NAME]
 | L > | L ≤ | [NAME] | 1000<w≤1500 | 1500<w≤2000 | 2000<w≤3500
 | - | 2000 | 6 | 7 | 8 | -
 | 2000 | 3000 | 7 | 7 | 9 | 10
 | 3000 | 3500 | 7 | 8 | 10 | 10
 | 3500 | 5000 | 8 | 10 | 10 | 12
 | 5000 | - | 12 | 12 | 15 | 15
Spreadsheet: 234012d1367979825-how-to-create-option-or-combo-box-within-cell-copy-of-test
Sheet: Lead

Date | Name | Gender | Residence Status | Contact |  | Project Type | Subject Property Address | Advisor | MLS | Listing Price | Offer price | Down Payment | Loan Amount | Last Follow up date | Next Follow up date | Referred by | Commission Ratio | Current Status | Note
 | Client1 |  |  | QQ
 | Client2
 | Client3
 | Client4
 | Client5
 | Client6
 | Client7
 | Client8
 | Client9
 | Client9
Spreadsheet: 0198e2d6-57ee-4abb-94fe-df9b1edc6995
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5206.0 Australian National Accounts: National Income, Expenditure and Product
 | Table 36. External Account, Current prices, Annual
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Imports of goods and services ; |  |  | Original | A2304626K | 1960-06-01 00:00:00 | 2009-06-01 00:00:00 | 50 | $ Millions | DERIVED | Annual | 6
Primary income receivable by non-residents - Compensation of employees ; |  |  | Original | A2304890W | 1960-06-01 00:00:00 | 2009-06-01 00:00:00 | 50 | $ Millions | DERIVED | Annual | 6
Primary income receivable by non-residents - Property Income ; |  |  | Original | A2304891X | 1960-06-01 00:00:00 | 2009-06-01 00:00:00 | 50 | $ Millions | DERIVED | Annual | 6
Secondary income receivable by non-residents - Current transfers ; |  |  | Original | A2304860J | 1960-06-01 00:00:00 | 2009-06-01 00:00:00 | 50 | $ Millions | DERIVED | Annual | 6
Exports of goods and services ; |  |  | Original | A2304641J | 1960-06-01 00:00:00 | 2009-06-01 00:00:00 | 50 | $ Millions | DERIVED | Annual | 6
Primary income payable by non-residents - Compensation of employees ; |  |  | Original | A2304894F | 1960-06-01 00:00:00 | 2009-06-01 00:00:00 | 50 | $ Millions | DERIVED | Annual | 6
Primary income payable by non-residents - Property Income ; |  |  | Original | A2304896K | 1960-06-01 00:00:00 | 2009-06-01 00:00:00 | 50 | $ Millions | DERIVED | Annual | 6
Secondary income payable by non-residents - Current transfers ; |  |  | Original | A2304859X | 1960-06-01 00:00:00 | 2009-06-01 00:00:00 | 50 | $ Millions | DERIVED | Annual | 6
Balance on external income account ; |  |  | Original | A2304662V | 1960-06-01 00:00:00 | 2009-06-01 00:00:00 | 50 | $ Millions | DERIVED | Annual | 6
Capital transfers - Receivable by non-residents ; |  |  | Original | A2304852J | 1960-06-01 00:00:00 | 2009-06-01 00:00:00 | 50 | $ Millions | DERIVED | Annual | 6
Capital transfers - Payable by non-residents ; |  |  | Original | A2304853K | 1960-06-01 00:00:00 | 2009-06-01 00:00:00 | 50 | $ Millions | DERIVED | Annual | 6
Balance on external income and capital transfers ; |  |  | Original | [NAME] | 1960-06-01 00:00:00 | 2009-06-01 00:00:00 | 50 | $ Millions | DERIVED | Annual | 6
Acquisitions less disposals of non-produced non-financial assets ; |  |  | Original | A2304629T | 1960-06-01 00:00:00 | 2009-06-01 00:00:00 | 50 | $ Millions | DERIVED | Annual | 6
Net lending (+) / net borrowing (-) ; |  |  | Original | A2304663W | 1960-06-01 00:00:00 | 2009-06-01 00:00:00 | 50 | $ Millions | DERIVED | Annual | 6
TOTAL CAPITAL ACCUMULATION AND NET LENDING (+) / NET BORROWING (-) ; |  |  | Original | A2304640F | 1960-06-01 00:00:00 | 2009-06-01 00:00:00 | 50 | $ Millions | DERIVED | Annual | 6
© Commonwealth of Australia  2010
Spreadsheet: 1d684243-7b74-47b7-8277-97ae79b2ba36
Sheet: Sheet1

Table 1--U.S. cotton supply and use estimates | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  |  |  |  | 2013/14
Item | 2012/13 |  | July |  | Aug. |  | Sep.
 | Million acres
Upland:
Planted | 12.076 |  | 10.025 | 10.025 | 10.015 |  | 10.136
Harvested | 9.135 |  | 7.579 | 7.579 | 7.519 |  | 7.582
 | Pounds
Yield/harvested acre | 869 |  | 815 | 815 | 796 |  | 777
 | Million 480-lb. [NAME]
Beginning stocks | 3.081 |  | 3.72 |  | 3.603 |  | 3.705
Production | 16.535 |  | 12.872 |  | 12.473 |  | 12.273
Total supply   1/ | 19.622 |  | 16.597 |  | 16.081 |  | 15.983
[NAME] use | 3.478 |  | 3.475 |  | 3.48 |  | 3.48
Exports | 12.19 |  | 10.35 |  | 9.9 |  | 9.65
Total use | 15.668 |  | 13.825 |  | 13.38 |  | 13.13
Ending stocks  2/ | 3.705 |  | 2.767 |  | 2.743 |  | 2.844
 | Percent
Stocks-to-use ratio | 23.6 |  | 20 | 20 | 20.5 |  | 21.7
 | 1,000 acres
Extra-long staple:
Planted | 238.4 |  | 226 | 226 | 186 |  | 201
Harvested | 236.8 |  | 221 | 221 | 183.8 |  | 198.8
 | Pounds
Yield/harvested acre | 1581 |  | 1365 | 1365 | 1514 |  | 1510
 | 1,000 480-lb. [NAME]
Beginning stocks | 269 |  | 180 | 180 | 197 |  | 195
Production | 780 |  | 628 | 628 | 580 |  | 626
Total supply   1/ | 1053 |  | 808 | 808 | 777 |  | 826
[NAME] use | 22 |  | 25 | 25 | 20 |  | 20
Exports | 836 |  | 650 | 650 | 700 |  | 750
Total use | 858 |  | 675 | 675 | 720 |  | 770
Ending stocks  2/ | 195 |  | 133 | 133 | 57 |  | 56
 | Percent
Stocks-to-use ratio | 22.7 |  | 19.7 | 19.7 | 7.9 |  | 7.3
1/ Includes imports.  2/ Includes unaccounted.
Sources: USDA, World Agricultural Outlook Board; and
U.S. Dept. of Commerce, U.S. Census Bureau.
Last update: 09/16/13.
Spreadsheet: 837830d1690455358-drop-down-chooses-defined-list-test-file-5-aligw
Sheet: Lookups

Ash AM |  | Ash AM |  | Ash PM
Ash PM |  | GP Anima AM |  | Duty (GP) A PM
Duty (GP) A PM |  | GP Routine AM |  | Duty (GP) B PM
Duty (GP) B PM |  | GP Triage AM (Salaried) A |  | Duty (GP) PM
Duty (GP) PM |  | GP Triage AM (Salaried) B |  | Duty (Salaried) A PM
Duty (Salaried) A PM |  | GP Triage AM A |  | Duty (Salaried) B PM
Duty (Salaried) B PM |  | GP Triage AM B |  | Duty (Salaried) PM
Duty (Salaried) PM |  | Minor Illness AM |  | GP Anima PM
GP Anima AM |  | Salaried GP Anima AM |  | GP Routine PM
GP Anima PM |  | Salaried GP Routine AM |  | Minor Illness PM
GP Routine AM |  |  |  | Salaried GP Anima PM
GP Routine PM |  |  |  | Salaried GP Routine PM
GP Triage AM (Salaried) A
GP Triage AM (Salaried) B
GP Triage AM A
GP Triage AM B
Minor Illness AM
Minor Illness PM
Salaried GP Anima AM
Salaried GP Anima PM
Salaried GP Routine AM
Salaried GP Routine PM
Spreadsheet: 812002d1672911623-prospect-calculation-in-months-excel-issue
Sheet: Blad1

[NAME] | Status | Succes factor | Value p.m | January | February | March | April | May | June | July | August | September | October | November | December
Project X | Prospect | 0.25 | 1200
Project Y | Client | 1 | 600
Project Z | Prospect | 0.75 | 7777
Spreadsheet: 162202d1339767017-pivot-table-help-pivot-table-sample
Sheet: Branch Codes

Branch Number | Branch Name | North/South
10 | [NAME] | South
11 | MAN | North
12 | FAS | South
13 | DOV | South
14 | SOU | South
15 | COR | North
16 | BHX | North
17 | SWI | South
18 | LAI | South
19 | EXE | South
20 | HUL | North
21 | LPL | North
22 | GLA | Scotland
23 | PRO | Projects
24 | IMN | North
25 | [NAME] | North
26 | FLX | South
28 | MGP | North
30 | VSHIP | Scotland
Spreadsheet: chris_germany__2694__May00_FOM_Reqs
Sheet: FOM May Storage

 | First-of-the Month Baseload Storage Injections/(Withdrawals)
 |  | Monthly | Daily
 |  | Inj/(WD) | Inj/(WD)
LDC | Pipe/Service | Dth# | Dth#
Atlanta Gas Light
 | IBSS | 195052
 | [NAME] WSS | 65503
 | Transco ESS | 1209
 | Tennessee FS-MA | -17190
 | Tennessee FS-PA | -43230
 | CNG | 0
 | SONAT | 144491
Columbia Gas of Ohio
 | TCO FSS | 1089109
Spreadsheet: 437fcdd2-a299-4f84-a894-5e34f33b9ab0
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
5586 | 30318 | Rafael | Lopez Ordoñez | ESP | 481 | 00:42:11 | 00:01:10 | 01:34:22 | 00:01:39 | 00:24:22 | 1 | 02:43:44
Spreadsheet: 831037d1685367351-match-and-sum-match-and-sum2
Sheet: Sheet1

Case1
 |  |  |  | Expected result
Magh | Ma-45/49/54 | [NAME]
Case2
 |  |  |  |  |  |  | Expected result
Magh | Ma-45/49/54 | [NAME]
Case3 |  |  |  |  |  |  | Expected result
 | Ma-45/49/54 | [NAME] |  |  |  |  | 4626/2023.5.26,846/2023.5.24,342/2023.5.27
Spreadsheet: 51770d1251380717-summing-numbers-with-multiple-criteria-697346_aaaarrrggh
Sheet: Sheet2

7.999999999999996 | Month
Ethnicity | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00
A2 | 0 | 0 | 0 | 0 | 0 | 7 | 7 | 7 | 7 | 7 | 7 | 0 | 0 | 0 | 0 | 0
A9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 37.5 | 66.5 | 66.5 | 66.5 | 66.5 | 24 | 24 | 24 | 24
B2 | 0 | 0 | 0 | 0 | 16 | 22 | 22 | 25 | 25 | 25 | 19 | 0 | 0 | 0 | 0 | 0
A1 | 19 | 19 | 19 | 19 | 19 | 27 | 27 | 30 | 30 | 33 | 22 | 3 | 0 | 0 | 0 | 0
W9 | 0 | 0 | 0 | 27 | 54 | 60 | 60 | 65 | 65 | 67 | 63 | 8.5 | 8.5 | 0 | 0 | 0
B9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 0
W1 | 9 | 9 | 9 | 25 | 25 | 25 | 33 | 47.5 | 57.5 | 57.5 | 77.5 | 21 | 11 | 11 | 11 | 11
B1 | 13.5 | 13.5 | 13.5 | 13.5 | 13.5 | 13.5 | 13.5 | 21.5 | 21.5 | 21.5 | 21.5 | 8 | 8 | 8 | 0 | 0
Spreadsheet: 820614d1678199166-match-person-project-and-charge-help_match_project_person_charge-1-
Sheet: Sheet2

[NAME] | [NAME] |  | [NAME] | Index Match | If Index | Filter
 |  | Test1
 |  | Test3 |  |  |  | 0.1
 |  | Test4 |  |  |  | 0.02
 | René |  |  |  |  | -0.0733333333333334
 |  | Test1 |  |  |  | -0.163333333333333
 | Michel |  |  |  |  | -0.253333333333333
 | [NAME] |  |  |  |  | -0.343333333333333
 |  |  |  |  |  | -0.433333333333333
 |  |  |  |  |  | -0.523333333333333
Spreadsheet: 292572d1390667850-rommates-cleaning-schedule-cleanup
Sheet: Sheet2

1 | R1
2 | R2
3 | R3
4 | R4
5 | R5
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
Spreadsheet: 707569d1607350738-getting-information-for-a-table-707558d1607348235-getting-information-for-a-table-book3
Sheet: Filter

Name | Claimants | Workcoach FTE | Interventions | Interventions Per FTE | Attended | Failed To Attend | Cancelled | Rescheduled
Barking
Canning town
Hackney
Hoxton
Poplar
Redbridge
Romford
[NAME]
Walthamstow
Walthamstow support office
Uttlesford
[NAME] (sea project)
 |  | 60.02 | 5254 | 87.54 | 3127 | 621 | 440 | 607 | 13
 | 24280 | 31.95 | 2572 | 80.5 | 1447 | 287 | 254 | 345 | 2
 | 25082 | 37.59 | 3329 | 88.57 | 1998 | 315 | 195 | 196 | 19
 | 20385 | 38.02 | 3690 | 97.06 | 1860 | 514 | 372 | 584 | 8
 | 35911 | 59.26 | 4937 | 83.31 | 2996 | 542 | 317 | 472 | 6
 | 29669 | 41.19 | 4037 | 98.01 | 2420 | 511 | 307 | 539 | 5
 | 22360 | 51.18 | 4368 | 85.35 | 2790 | 418 | 323 | 646 | 1
 | 28389 | 39.54 | 3658 | 92.51 | 2086 | 274 | 413 | 520 | 0
 | 30708 | 53.02 | 5015 | 94.58 | 2742 | 559 | 568 | 586 | 7
 | 6892 | 12.28 | 1327 | 108.1 | 820 | 120 | 145 | 168 | 7
Spreadsheet: 43794d1242397700-excel-2007-automatically-hide-a-row-that-has-a-zero-value-book-2
Sheet: Data

Name | Grades | Gender
[NAME] | 100 | F
[NAME] | 0 | M
[NAME] | 0 | M
Fred | 92 | M
[NAME] | 88 | F
[NAME] | 0 | F
Desired Result
Name | Grades | Gender |  | IF  Gender "F" selected
[NAME] | 100 | F
[NAME] | 88 | F
[NAME] | 0 | F |  | (HIDDEN)
Name | Grades | Gender |  | IF  Gender "M" selected
[NAME] | 0 | M |  | (HIDDEN)
[NAME] | 0 | M |  | (HIDDEN)
Fred | 92 | M
Spreadsheet: 45911d1244686297-find-value-matching-multiple-text-criteria-and-max-date-findmaxdate
Sheet: Soluction

Date | Category | Currnecy | Exchag Rate
2009-03-01 00:00:00 | A | USD | 1
2009-06-01 00:00:00 | A | EUR | 9
2009-06-01 00:00:00 | A | USD | 2
2009-08-01 00:00:00 | A | USD | 25
2009-05-01 00:00:00 | A | EUR | 2
2009-05-02 00:00:00 | A | USD | 25
2009-05-03 00:00:00 | A | USD | #N/A | 0
Spreadsheet: 05a736a3-7b5a-4238-a833-54cfdb7dca6c
Sheet: Exhibit XVII, Sheet 3, pg 2

Owners Forms
USAA-CIC
Pennsylvania
Claims, Losses, & Expenses Summary
 |  | Claims Closed With Payment
 |  | (incl [NAME])
Accident Year | as of | 15 Months | 27 Months | 39 Months | 51 Months
2001-06-30 00:00:00 |  | 589 | 599 | 599 | 599
2002-06-30 00:00:00 |  | 617 | 628 | 629 | 628
2003-06-30 00:00:00 |  | 548 | 555 | 555 | 555
2004-06-30 00:00:00 |  | 688 | 691 | 692 | 692
2005-06-30 00:00:00 |  | 702 | 716 | 716 | 716
2006-06-30 00:00:00 |  | 704 | 714 | 717 | 715
2007-06-30 00:00:00 |  | 1074 | 1086 | 1091 | 1091
2008-06-30 00:00:00 |  | 1077 | 1095 | 1095 | 1095
2009-06-30 00:00:00 |  | 1276 | 1318 | 1321 | 1321
2010-06-30 00:00:00 |  | 1759 | 1868 | 1872
2011-06-30 00:00:00 |  | 1590 | 1659
2012-06-30 00:00:00 |  | 1939
 |  | Claims Closed With Payment
 |  | (excl [NAME])
Accident Year | as of | 15 Months | 27 Months | 39 Months | 51 Months
2001-06-30 00:00:00 |  | 573 | 583 | 583 | 583
2002-06-30 00:00:00 |  | 599 | 610 | 611 | 610
2003-06-30 00:00:00 |  | 484 | 493 | 493 | 493
2004-06-30 00:00:00 |  | 544 | 547 | 548 | 548
2005-06-30 00:00:00 |  | 622 | 635 | 635 | 635
2006-06-30 00:00:00 |  | 616 | 626 | 629 | 627
2007-06-30 00:00:00 |  | 912 | 924 | 929 | 929
2008-06-30 00:00:00 |  | 1042 | 1059 | 1059 | 1059
2009-06-30 00:00:00 |  | 1140 | 1177 | 1180 | 1180
2010-06-30 00:00:00 |  | 1213 | 1258 | 1262
2011-06-30 00:00:00 |  | 1373 | 1419
2012-06-30 00:00:00 |  | 1229
Spreadsheet: sally_beck__33921__PG&E Cash Schedule
Sheet: January

PG&E CASH SCHEDULE THROUGH JANUARY 31, 2001
 |  | (US DOLLARS)
Counterparty | Enron Entity | Total Receivable | Total Payable | Net Amount | Native Currency |  | Due Date
PG&E Energy Trading - Gas Corp. | ENA | 10000000 | 10000000 | 10000000 |  |  | 2001-01-25 00:00:00
Pacific Gas & Electric Company | ENA | 1200 | 1000 |  |  |  | 2001-01-25 00:00:00
PG&E Core | ENA | 1500 | 1200 |  |  |  | 2001-01-25 00:00:00
PG&E Energy Tading, Canada | ENA | 1000 | 1200 |  |  |  | 2001-01-25 00:00:00
CEG Energy Options Inc. | ENA | 1500 | 1500 |  |  |  | 2001-01-25 00:00:00
Nine Energy Service LLC (WIMBE) | ENA | 1200 | 500 |  |  |  | 2001-01-25 00:00:00
Subtotal ENA Net Physical Gas
Pacific Gas & Electric Company | ENA | 1000 | 2000 |  |  |  | 2001-01-25 00:00:00
PG&E Gas Transmission Teco, Inc. | ENA | 1000 | 2000 |  |  |  | 2001-01-25 00:00:00
PG&E Texas Pipeline, L.P. | ENA | 1000 | 2000 |  |  |  | 2001-01-25 00:00:00
Subtotal ENA Transport
PG&E Energy Trading Power LP | ENA | 1000 | 100 |  |  |  | 2001-01-25 00:00:00
Subtotal ENA SWAPS
Subtotal ENA
PG&E Energy Trading -Gas Corp. | HPL | 2000 | 1000 |  |  |  | 2001-01-25 00:00:00
Subtotal HPL Transport
No scheduled payments |  | 0 | 0 | 0
Subtotal EPMI Physical Power | EPM
No scheduled payments |  | 0 | 0 | 0
Subtotal EGM | EGM
PG&E Energy Tading - Gas Corp. | ECC | 1500 | 1000 |  | 300 | CDN$ | 2001-01-25 00:00:00
PG&E Energy Trading, Canada | ECC | 1000 | 1000 |  | 300 | CDN$ | 2001-01-25 00:00:00
Pacific Gas & Electric Company | ECC | 1500 | 1000 |  | 300 | CDN$ | 2001-01-25 00:00:00
Subtotal ECC Net Physical Gas
PG&E Energy Trading - Gas Corp. | EES | 100 | 1000 |  |  |  | 2001-01-25 00:00:00
Subtotal EES Physical Gas
No scheduled payments | EES | 100 | 1000 |  |  |  | 2001-01-25 00:00:00
Subtotal EES Physical Power
Subtotal EES
Grand Total Enron
Spreadsheet: 729252d1618985512-data-validation-list-with-conditions-and-vlookup-test_validation
Sheet: Sheet1

Value A | Value B
1.1.1.1 | 1.3 |  |  | Test single value | 1.1.1.1 |  |  | =VLOOKUP(F2;$A$2:$B$5;2;FALSE)
1.3.5.4 | 2.1
3.2.2 | 1.3 |  |  | Test multiple value | 3.1.1 | 1.3 |  | =IF(E4="1.2.1.1";list_1;IF(E4="3.1.1";list_2;""))
4.1.3 | 3.6
 |  |  |  | Test If belongs to the single list | 1.1.1.1 |  |  | =COUNTIF($A$2:$A$5;F6)>0
1.2.1.1 | 1.4 | name = list_1
 | 2.1
3.1.1 | 1.3 | name = list_2
 | 3.6
Spreadsheet: 190633d1351722965-dividing-two-numbers-in-the-same-cell-example
Sheet: Sheet1

PLAYER | FGM-FGA
A.J. Price | 59-174
[NAME] | 83-161 |  |  |  | FGM-FGA | FGM | FGA
[NAME] | 345-773 |  |  | A.J. Price |  | 59 | 174
[NAME] | 57-103
[NAME] | 516-1048 |  |  |  | what formula can you use to break FGM and FGA into each cell? Such as G4 AND H4
[NAME] | 55-142
[NAME] | 153-357
[NAME] | 150-365