tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 708027d1607591411-how-to-report-the-top-20-and-bottom-20-of-a-data-table-report-with-2-conditions-dashboard
Sheet: PORTUGAL

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: 02f2993f-518a-41ac-ad1f-6112c4ac0dbe
Sheet: Sheet1

Student Name | ORAL | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | WRITTEN | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Student Evaluation Done
 | Pre Test |  | Post Test |  | Pretest |  |  |  | Post Test
 | (Score / SPL) |  | (Score / SPL) |  | (Read / Write / Total / SPL) |  |  |  | (Read / Write / Total / SPL)
Spreadsheet: 830461d1684933707-finding-1st-2nd-3rd-and-4th-largest-numbers-in-a-range-of-cells-find-values-in-a-range-ans
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 4 | 0 | 5 | 0 | 0 | 13 | 144 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Correct Answers-> |  | 144-9 | 13-8 | 5-5 | 4-3
Spreadsheet: 538840d1505842843-pivot-table-displaying-old-data-s666-newpts-53rd-street-cost-schedule-4
Sheet: Draw 3 - 06.27.17

Description | Line Item | Line Item # | Date | Amount | Payee | Notes |  | Line Item | Sum of Line Item # | Sum of Amount
Retaining Wall Labor | Block/Retaining Walls | 345 | 2017-06-16 00:00:00 | 1480 | [NAME] | Block wall layout and footings |  | Block/Retaining Walls | 4485 | 7340.610000000001
Retaining Wall Materials | Block/Retaining Walls | 345 | 2017-06-16 00:00:00 | 121.52 | Home Depot | Retaining wall materials |  | GC Supervision | 403 | 10000
Retaining Wall Materials | Block/Retaining Walls | 345 | 2017-06-15 00:00:00 | 891.66 | La Mesa Lumber | Retaining wall form lumber |  | Inspections | 407 | 100
Fence Repair | Miscellaneous Rentals | 304 | 2017-06-07 00:00:00 | 150 | [NAME] | Fence extension and gate repair |  | Insurance Premiums | 109 | 425
Clean Up | Rough Grading | 302 | 2017-06-17 00:00:00 | 100 | [NAME] | Clean up and debris removal for grading |  | Miscellaneous Rentals | 304 | 150
Retaining Wall Materials | Block/Retaining Walls | 345 | 2017-06-21 00:00:00 |  | HD Supply | Form lumber for retaining walls |  | Plumbing | 306 | 220
Retaining Wall Materials | Block/Retaining Walls | 345 | 2017-06-24 00:00:00 | 1254.92 | HD Supply | Retaining wall materials |  | Rough Grading | 604 | 5680
Retaining Wall Materials | Block/Retaining Walls | 345 | 2017-06-21 00:00:00 | 355.56 | HD Supply | Retaining wall steel cutter |  | Rough Lumber | 307 | 823.2
Retaining Wall Materials | Block/Retaining Walls | 345 | 2017-06-21 00:00:00 | 227.43 | HD Supply | Retaining wall concrete test kit |  | Grand Total | 6925 | 24738.81
Grading and Export | Rough Grading | 302 | 2017-06-23 00:00:00 | 5580 | B&M Grading | Grading and export material to [NAME]
Retaining Wall Labor | Block/Retaining Walls | 345 | 2017-06-23 00:00:00 | 2240 | [NAME] | Retaining wall construction labor
Retaining Wall Materials | Block/Retaining Walls | 345 | 2017-06-21 00:00:00 | 92.53 | Home Depot | Retaining wall materials
Retaining Wall Materials | Block/Retaining Walls | 345 | 2017-06-18 00:00:00 | 80.81 | Home Depot | Retaining wall materials
Retaining Wall Labor | Block/Retaining Walls | 345 | 2017-06-19 00:00:00 | 250 | [NAME] | Retaining wall forming labor
Site Plumbing | Plumbing | 306 | 2017-06-25 00:00:00 | 220 | Cesar Dominguez | Repair of the plumbing riser and [NAME] bibb
Rental Equipment | Block/Retaining Walls | 345 | 2017-06-23 00:00:00 | 200 | Sunbelt Rentals | Deposit for rental of rebar cutting machine
Rental Equipment | Block/Retaining Walls | 345 | 2017-06-27 00:00:00 | 140.88 | Sunbelt Rentals | Final payment for rebar cutting machine
Supervision Fee | GC Supervision | 403 | 2017-06-27 00:00:00 | 10000 | [NAME] | Monthly GC supervision fee
Monthly Insurance | Insurance Premiums | 109 | 2017-06-27 00:00:00 | 425 | DJM Insurance | Monthly insurance contribution (June)
Lumber | Rough Lumber | 307 | 2017-06-23 00:00:00 | 823.2 | La Mesa Lumber | Shed lumber
Inspection Fee | Inspections | 407 | 2017-06-27 00:00:00 | 100 | Pacific Premier Bank | Inspection for Draw 3
Spreadsheet: 206679d1358255939-how-to-transpose-one-column-into-multiple-rows-and-columns-indextemps
Sheet: Sheet1

Span From Str. | Span To Str. | Span Length  (ft) | [NAME] (°F)
 |  |  | 0 | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100
1 | 2 | 212.43 |  |  |  |  |  |  |  |  |  |  |  | 4.23 | 0 | 1
2 | 3 | 195.765 |  |  |  |  |  |  |  |  |  |  |  | 4.41 | 10 | 2
3 | 4 | 187.683 |  |  |  |  |  |  |  |  |  |  |  | 4.59 | 20 | 3
4 | 5 | 199.703 |  |  |  |  |  |  |  |  |  |  |  | 4.76 | 30 | 4
5 | 6 | 209.872 |  |  |  |  |  |  |  |  |  |  |  | 4.93 | 40 | 5
6 | 7 | 171.254 |  |  |  |  |  |  |  |  |  |  |  | 5.09 | 50 | 6
7 | 8 | 200.36 |  |  |  |  |  |  |  |  |  |  |  | 5.25 | 60 | 7
8 | 9 | 201.915 |  |  |  |  |  |  |  |  |  |  |  | 5.4 | 70 | 8
9 | 10 | 200.3 |  |  |  |  |  |  |  |  |  |  |  | 5.55 | 80 | 9
10 | 11 | 191.542 |  |  |  |  |  |  |  |  |  |  |  | 5.7 | 90 | 10
11 | 12 | 166.096 |  |  |  |  |  |  |  |  |  |  |  | 5.8 | 100 | 11
12 | 13 | 180.019 |  |  |  |  |  |  |  |  |  |  |  | 4.24 | 0 | 12
13 | 14 | 157.608 |  |  |  |  |  |  |  |  |  |  |  | 4.43 | 10 | 13
14 | 15 | 157.2 |  |  |  |  |  |  |  |  |  |  |  | 4.6 | 20 | 14
15 | 16 | 130.581 |  |  |  |  |  |  |  |  |  |  |  | 4.77 | 30 | 15
16 | 17 | 223.097 |  |  |  |  |  |  |  |  |  |  |  | 4.94 | 40 | 16
17 | 18 | 209.371 |  |  |  |  |  |  |  |  |  |  |  | 5.1 | 50 | 17
18 | 19 | 208.444 |  |  |  |  |  |  |  |  |  |  |  | 5.26 | 60 | 18
19 | 20 | 208.258 |  |  |  |  |  |  |  |  |  |  |  | 5.42 | 70 | 19
20 | 21 | 206.423 |  |  |  |  |  |  |  |  |  |  |  | 5.57 | 80 | 20
21 | 22 | 209.501 |  |  |  |  |  |  |  |  |  |  |  | 5.72 | 90 | 21
22 | 23 | 204.525 |  |  |  |  |  |  |  |  |  |  |  | 5.82 | 100 | 22
23 | 24 | 196.339 |  |  |  |  |  |  |  |  |  |  |  | 4.24 | 0 | 23
24 | 25 | 196.594 |  |  |  |  |  |  |  |  |  |  |  | 4.43 | 10 | 24
25 | 26 | 184.16 |  |  |  |  |  |  |  |  |  |  |  | 4.6 | 20 | 25
26 | 27 | 208.232 |  |  |  |  |  |  |  |  |  |  |  | 4.77 | 30 | 26
27 | 28 | 198.133 |  |  |  |  |  |  |  |  |  |  |  | 4.94 | 40 | 27
28 | 29 | 214.575 |  |  |  |  |  |  |  |  |  |  |  | 5.1 | 50 | 28
29 | 30 | 215 |  |  |  |  |  |  |  |  |  |  |  | 5.26 | 60 | 29
30 | 31 | 215 |  |  |  |  |  |  |  |  |  |  |  | 5.42 | 70 | 30
31 | 32 | 215 |  |  |  |  |  |  |  |  |  |  |  | 5.57 | 80 | 31
32 | 33 | 215 |  |  |  |  |  |  |  |  |  |  |  | 5.72 | 90 | 32
33 | 34 | 215 |  |  |  |  |  |  |  |  |  |  |  | 5.81 | 100 | 33
Spreadsheet: benjamin_rogers__1201__3rd Party Retail Shorts version 2
Sheet: IS

INCOME STATEMENT
('000 $)
 |  | 2001-12-31 00:00:00 | 2002-12-31 00:00:00 | 2003-12-31 00:00:00 | 2004-12-31 00:00:00 | 2005-12-31 00:00:00 | 2006-12-31 00:00:00 | 2007-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-12-31 00:00:00 | 2013-12-31 00:00:00 | 2014-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-12-31 00:00:00 | 2017-12-31 00:00:00 | 2018-12-31 00:00:00 | 2019-12-31 00:00:00 | 2020-12-31 00:00:00 | 2021-12-31 00:00:00 | 2022-12-31 00:00:00 | 2023-12-31 00:00:00 | 2024-12-31 00:00:00 | 2025-12-31 00:00:00 | 2026-12-31 00:00:00 | 2027-12-31 00:00:00 | 2028-12-31 00:00:00 | 2029-12-31 00:00:00 | 2030-12-31 00:00:00 | 2031-12-31 00:00:00
Revenue
Spread Option Capacity Revenue
EES Energy Revenue
ICAP |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Revenue
Expense
Expense of Serving EES Load
Fixed Operating Expenses
Insurance
SG&A
Start Charge
Property Tax |  | 400
Franchise Tax
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Debt Service Reserve [NAME]
Marketing Fee
Administrative Fee
O&M Fees
Total Expense
EBITDA
Depreciation & Amortization
EBIT
Interest Expense
Pretax Book Income
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense)
Net Income
Spreadsheet: 684964d1593635624-juxtaposing-successive-levels-from-parent-child-relational-data-relational-data
Sheet: Relataional data

Raw data table: IDs are generated as serial numbers without regard to what types of levels they are generated for. There may be gaps in the serial numbers, there may be duplicates and they may be listed in no particluar order etc. IDs and ParentTypes may be numbers stored as text. |  |  |  |  | Results table: Table is dynamic as new parents arrive and existing parents (Level1) begets more children (Level2) and grand children (Level3). Data is therefore continuously expanded downwards in the table, from all levels. The table must automatically be sorted by Level1, then Level2 and then Level3.
ID children | ID parents | Level1 ParentTypes | Level2 & Level3 ParentTypes |  | Sorted ID children for Level1_ParentType1, Level1_ParentType2 & Level1_ParentType3 | Sorted ID children for Level2_ParentType4 | Sorted ID children for Level3_ParentType5
1000 |  | Level1_ParentType1 |  |  | 1000 | 1006 | 1013
1001 |  | Level1_ParentType1 |  |  | 1000 | 1006 | 1014
1002 |  | Level1_ParentType2 |  |  | 1000 | 1006 | 1015
1003 |  | Level1_ParentType2 |  |  | 1000 | 1007 | 1016
1004 |  | Level1_ParentType3 |  |  | 1000 | 1007 | 1017
1005 |  | Level1_ParentType3 |  |  | 1001 | 1008 | 1018
1006 | 1000 |  | Level2_ParentType4 |  | 1001 | 1009 | 1019
1007 | 1000 |  | Level2_ParentType4 |  | 1001 | 1009 | 1020
1008 | 1001 |  | Level2_ParentType4 |  | 1002 | 1010
1009 | 1001 |  | Level2_ParentType4 |  | 1002 | 1011
1010 | 1002 |  | Level2_ParentType4 |  | 1003 | 1012 | 1021
1011 | 1002 |  | Level2_ParentType4 |  | 1004
1012 | 1003 |  | Level2_ParentType4 |  | 1005
1013 | 1006 |  | Level3_ParentType5
1014 | 1006 |  | Level3_ParentType5
1015 | 1006 |  | Level3_ParentType5
1016 | 1007 |  | Level3_ParentType5
1017 | 1007 |  | Level3_ParentType5
1018 | 1008 |  | Level3_ParentType5
1019 | 1009 |  | Level3_ParentType5
1020 | 1009 |  | Level3_ParentType5
1021 | 1012 |  | Level3_ParentType5
Spreadsheet: tracy_geaccone__40483__EOTT Summary subunits
Sheet: Sell Ratio .35

Project NFL: Gain/Loss Calculation
Enron recapitalizing Sub-Units, and API at .35
All Estimates based on March / 2001 information
Summary:
 |  |  |  |  |  |  |  |  |  | Co #105 |  |  |  | Co #105 | Co #23Q
 |  |  |  |  |  |  |  |  |  | Recapitalizing EOTT's Subordinated Units |  |  |  | Sell EOTT GP, Sub-Units and API | [NAME] API's |  | Total
Income Statement Effect
 | Proceeds on Sale |  |  |  |  |  |  |  |  |  |  |  |  | 33.4
 |  | Book Basis per G/L - pre-sale |  |  |  |  |  |  |  |  |  |  |  | 38.3 | 9.32
 | Effective Book Basis
 |  |  | Book Gain/(Loss) pre-tax
 | Tax Expense
 |  |  |  | Current
 |  |  |  | Deferred
 |  |  |  |  |  | Total Tax Expense
 |  |  |  |  |  | Net Income/(Loss) on Sale
 |  |  |  |  |  | Effective Tax Rate on Sale
Current Tax Calculation
 | Proceeds on Sale
 | Tax Basis |  |  |  |  |  |  |  |  | -6.3 |  |  |  | 1.8
 | Tax effect/basis in contingency items |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 |  | 0
 |  |  |  |  | Taxable Income
 |  |  |  |  |  | Statutory Tax Rate |  |  |  | 0.383 |  |  |  | 0.383 | 0.383 |  | 0.383
 |  |  |  |  |  | Total Current Tax Expense
Deferred Tax Calculation
 |  |  |  | Tax Basis (estimate) |  |  |  |  |  |  |  |  |  | 1.8
 |  |  |  | Book Basis |  |  |  |  |  |  |  |  |  | 33.9
 |  |  |  |  | Net Basis difference
 |  |  |  |  | Statutory Tax Rate |  |  |  |  | 0.383 |  |  |  | 0.383 | 0.383 |  | 0.383
 |  |  |  |  |  | Subtotal Deferred Taxes Calculated
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.1
 |  |  |  |  |  | Total Deferred Taxes per G/L |  |  |  | -11.9
 | USE FOR PLANNING PURPOSES ONLY.  ACTUAL WILL BE DIFFERENT.
 |  |  |  |  |  | Sub-Units |  |  |  | 7000000
 |  |  |  |  |  | API's |  |  |  |  |  |  |  |  | 9318213
 |  |  |  |  |  | Convertion Ratio |  |  |  | 0.35 |  |  |  |  | 0.35
 |  |  |  |  |  | Base converted
 |  |  |  |  |  | Market Price |  |  |  | 16.95
 |  |  | Prepared By: |  |  |  |  | [NAME]
 |  |  | Date Prepared: |  |  |  |  | 2001-05-08 00:00:00
 |  |  | Location:
 |  |  | Run Date:
Spreadsheet: 754641d1636399826-creating-a-formula-to-do-a-teammate-count-team-mate-example_gw_reva
Sheet: Comb

Unique player list | Player-1 | Player-2 | Unique
M Hayden |  |  |  |  | Necessary Rows: |  |  |  |  |  | SUMPRODUCT(MMULT(TRANSPOSE(($C$2:$C$34=F2)*(Sheet2!$J$2:$J$34={1,2,3})), SIGN(ROW(2:34))),                                  MMULT(TRANSPOSE(($C$2:$C$34=G2)*(Sheet2!$J$2:$J$34={1,2,3})), SIGN(ROW(2:34))))
J Langer |  |  |  |  | Combinations:
R Ponting
M Waugh
M Clarke
S Waugh
A Gilchrist
B [NAME]
J Gillespie
S Warne
G McGrath
A Border
D Martyn
S Marsh
M Marsh
I Healy
D Fleming
S Macgill
M Johnson
S Smith
D Warner
M Wade
G Maxwell
N Lyon
M Starc
Spreadsheet: 724230d1616081707-joining-columns-vertically-with-dynamic-array-functions-joining-columns-vertically
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Result
Table 1 |  | Table 2 |  |  | Table 3 |  |  |  | Table 4
Column1 |  | Column2 | Column3 |  | Column4 | Column5 | Column6 |  | Column7 | Column8 | Column9 |  | Column1 | Column2 | Column3
1 |  | A | 6 |  | A |  | 56 |  | 1 |  |  |  | 1
2 |  | B | 7 |  | Z |  | 8 |  | 2 |  |  |  | 2
3 |  | C | 8 |  | X | d | 8 |  | 3 |  |  |  | 3
4 |  | D | 9 |  | 567 |  | p |  | 4 |  |  |  | 4
 |  |  |  |  |  |  |  |  | A | 6 |  |  | A | 6
 |  |  |  |  |  |  |  |  | B | 7 |  |  | B | 7
 |  |  |  |  |  |  |  |  | C | 8 |  |  | C | 8
 |  |  |  |  |  |  |  |  | D | 9 |  |  | D | 9
 |  |  |  |  |  |  |  |  | A |  | 56 |  | A |  | 56
 |  |  |  |  |  |  |  |  | Z |  | 8 |  | Z |  | 8
 |  |  |  |  |  |  |  |  | X | d | 8 |  | X | d | 8
 |  |  |  |  |  |  |  |  | 567 |  | p |  | 567 |  | p
 |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | A | 6
 |  |  |  |  |  |  |  |  | B | 7
 |  |  |  |  |  |  |  |  | C | 8
 |  |  |  |  |  |  |  |  | D | 9
 |  |  |  |  |  |  |  |  | A |  | 56
 |  |  |  |  |  |  |  |  | Z |  | 8
 |  |  |  |  |  |  |  |  | X | d | 8
 |  |  |  |  |  |  |  |  | 567 |  | p
Spreadsheet: 05f80a87-1d8f-4476-bc2c-2abf5e8ef7f6
Sheet: Hershey FE

 |  |  | 2014 Delivery Calendar - Hershey Sr. High Rise F.E. + CSFP
 | January |  |  |  |  |  |  |  | February |  |  |  |  |  |  |  | March
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  |  | 1 | 2 | 3 | 4 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1
 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15
 | 19 | 20 | 21 | 22 | 23 | 24 | 25 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22
 | 26 | 27 | 28 | 29 | 30 | 31 |  |  | 23 | 24 | 25 | 26 | 27 | 28 |  |  | 23 | 24 | 25 | 26 | 27 | 28 | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 31
 | April |  |  |  |  |  |  |  | May |  |  |  |  |  |  |  | June
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  | 1 | 2 | 3 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | 8 | 9 | 10 | 11 | 12 | 13 | 14
 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |  | 11 | 12 | 13 | 14 | 15 | 16 | 17 |  | 15 | 16 | 17 | 18 | 19 | 20 | 21
 | 20 | 21 | 22 | 23 | 24 | 25 | 26 |  | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | 22 | 23 | 24 | 25 | 26 | 27 | 28
 | 27 | 28 | 29 | 30 |  |  |  |  | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  | 29 | 30
 | July |  |  |  |  |  |  |  | August |  |  |  |  |  |  |  | September
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  |  | 1 | 2 |  |  | 1 | 2 | 3 | 4 | 5 | 6
 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |  | 10 | 11 | 12 | 13 | 14 | 15 | 16 |  | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 20 | 21 | 22 | 23 | 24 | 25 | 26 |  | 17 | 18 | 19 | 20 | 21 | 22 | 23 |  | 21 | 22 | 23 | 24 | 25 | 26 | 27
 | 27 | 28 | 29 | 30 | 31 |  |  |  | 24 | 25 | 26 | 27 | 28 | 29 | 30 |  | 28 | 29 | 30
 |  |  |  |  |  |  |  |  | 31
 | October |  |  |  |  |  |  |  | November |  |  |  |  |  |  |  | December
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  |  | 1 | 2 | 3 | 4 |  |  |  |  |  |  |  | 1 |  |  | 1 | 2 | 3 | 4 | 5 | 6
 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15 |  | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 19 | 20 | 21 | 22 | 23 | 24 | 25 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22 |  | 21 | 22 | 23 | 24 | 25 | 26 | 27
 | 26 | 27 | 28 | 29 | 30 | 31 |  |  | 23 | 24 | 25 | 26 | 27 | 28 | 29 |  | 28 | 29 | 30 | 31
 |  |  |  |  |  |  |  |  | 30
 |  | Next to last Fridays, monthly.  [NAME] is subject to change.  Call CPFB with questions [PHONE]. Thank you.
 |  | Holidays, Food Bank is Closed |  |  |  |  |  |  |  | Delivery dates to your area
Spreadsheet: aac85278-19a1-4f52-a9cb-88b190368f1a
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0019962 | Unnamed: 3 | Facility Name: | Unnamed: 5 | Berkley & Patton Parks | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | Henderson | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050 | 00310 | 00680 | 00940 | 50060 | 31616 | 00610 | 00620 | 00400 | 00545 | 70295 | 00530 | 00076
Day | ORC Arrival Time | ORC Time On Site | Flow | BOD5 | Total Organic Carbon | Chloride | Total Residual Chlorine | Fecal Coliform | Ammonia | Nitrate | pH | Settleable Solids | Total Dissolved Solids | Total Suspended Solids | Turbidity
 | 24-hr | hrs | GPD | mg/L | mg/L | mg/L | mg/L | #/100 mL | mg/L | mg/L | su | mL/L | mg/L | mg/L | NTU
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
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Recorder | Composite | Grab | Grab | Grab | Grab | Composite | Grab | Grab | Grab | Grab | Composite | Recorder
Monthly Limit: |  |  |  | 10 |  |  |  | 14 | 4 |  |  |  |  | 5
Daily Limit: |  |  |  | 15 |  |  |  | 25 | 6 |  | 6-9 |  |  | 10 | 10
Sample Frequency: |  |  | [NAME] | See Permit | 3 x Year | 3 x Year | 5 x Week | See Permit | See Permit | 3 x Year | 3 x Year | 5 x Week | 3 x Year | See Permit | [NAME]
 |  | Average
 |  | Geomean
 |  | MAX/MIN
Spreadsheet: randall_gay__31455__salary
Sheet: Sheet1

Employee | Position | Salary
[NAME] | Sr. Specialist | 54404
[NAME] | Specialist | 46990
[NAME] | Specialist | 45063
[NAME] | Specialist | 52000
[NAME] | Specialist | 49008
[NAME] | Specialist | 48000
[NAME] | Sr. Specialist | 58000
Jan Sutherland | Sr. Specialist | 60000
Spreadsheet: 131031d1322697089-vlookup-copy-of-december
Sheet: 9

 |  |  |  | 2011-12-09 00:00:00
Newspaper | Price | Quantity | Total
Value | 0.88 |  | 0
Value1 | 0.98 |  | 0
Value2 | 1.22 |  | 0
Value3 | 1.22 |  | 0
Value4 | 0.83 |  | 0
Value5 | 1.01 |  | 0
Value6 | 1.03 |  | 0
Value7 | 1.01 |  | 0
Value8 | 0.8 |  | 0
Value9 | 1.04 |  | 0
Value10 | 1.04 |  | 0
Value11 | 1.04 |  | 0
Total |  |  | 0
 | Grand Total |  | 0
Spreadsheet: 88881d1288707139-conditional-formatting-with-multiple-and-or-criteria-em-example
Sheet: Sheet2

 |  | Air |  | Surface
 |  | Alert | Action | Alert | Action
CR1, 2, 3 | Hood | ≥0.03 | ≥0.09 | ≥1 | ≥3 | Presence of mold=alert for all surface and air samples
 | Room | ≥0.25 | ≥0.5 | N/A | N/A
 | Bins | N/A | N/A | ≥5 | ≥7
 | Floors | N/A | N/A | ≥5 | ≥10
 | Pass-Thrus | N/A | N/A | ≥5 | ≥7
 | Tables | N/A | N/A | ≥3 | ≥5
 | Walls | N/A | N/A | ≥3 | ≥5
 |  | Air |  | Surface
 |  | Alert | Action | Alert | Action
MR1, 2 | Room | ≥1.25 | ≥2.5 | N/A | N/A | Presence of mold=alert for all C=MR surface and air samples
 | Floors | N/A | N/A | ≥10 | ≥20
 | Vault | N/A | N/A | ≥5 | ≥10
 | Walls | N/A | N/A | ≥5 | ≥10
 |  | Air |  | Surface
 |  | Alert | Action | Alert | Action
MR1, 2, 3 | Room | ≥6.25 | ≥12.5 | N/A | N/A
 | Door | N/A | N/A | ≥10 | ≥20 | [NAME] does not elicit an alert in the PR
 | Floors | N/A | N/A | ≥20 | ≥40
 | Walls | N/A | N/A | ≥10 | ≥20
Spreadsheet: 5708e908-e605-4e48-b08d-439bb6fe79a1
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
8686 | 66276 | Arata | Higuchi | JPN | 0 | 00:22:26 | 00:00:00 | 01:03:52 | 00:00:00 | 00:48:04 | 1 | 02:14:22
Spreadsheet: 809139d1670929350-check-to-see-if-two-inputs-share-the-same-data-ex2
Sheet: Sheet1

 |  |  |  |  |  | EXAMPLE A |  |  | EXAMPLE B
 | Category | Data |  |  |  | Input | Output |  | Input | Output
 | 1 | circle | square | triangle |  | 1 | Triangle |  | 1 | Circle, Square, Triangle
 | 2 | oval | rhombus | triangle |  | 2 | Triangle |  | 2 | Triangle
 | 3 | circle | square | sphere |  |  |  |  | 3 | Circle, Square
Spreadsheet: 810812d1672087287-sum-from-a-range-to-the-top-count
Sheet: Sheet1

 |  |  |  | Every time I write a number in column H (which matches one of column A), for example 1729.3, which stands on A16
 |  |  |  | I would like in column J, the sum of all the scores in column C from the position of the number to the top.
 |  |  |  |  |  |  | EXAMPLES
Number | Name | Score |  |  |  |  | Number |  | [NAME]
1684 | [NAME] | 16 |  |  |  |  | 1729.3 | ------>
1702 | Dina | 18 |  |  |  |  | 1659 | ------>
1659 | [NAME] | 43 |  |  |  |  | 1714 | ------>
1699 | [NAME] | 40
1679 | [NAME] | 20
1729 | Kostas | 50 |  |  |  | So for 1729.3 I must sum these
1744.5 | [NAME] | 15.5
1704 | [NAME] | 41
1684 | Stamatia | 20 |  |  | So for 1714.0 I must sum these
1698 | Igor | 14
1714 | [NAME] | 15.5
1729.25 | Vladan | 15.75
1744.625 | [NAME] | 15.375
1729.3 | [NAME] | 14.6875
 |  |  | These numbers are the same, but I want always to count from the first in the column and above