tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 719792d1613816476-logic-updates-to-existing-formulas-duplicates-exclusion-lookups-samplep1
Sheet: SHIP

ID |  |  | type | rec count |  | [NAME] |  | [NAME] |  |  | Counts |  |  |  |  | Counts:
1154375 |  |  | Test |  | 4 | No Posting |  |  |  | Test File |  |  |  |  |  |  |  |  |  |  |  | Update 2 -> Can this formula be updated to '-' when not able to calculate (no values to aggregate)
1154375 |  |  | A |  | 4 | No Posting |  | Rp |  |  |  |  |  |  |  |  |  |  |  |  |  | Update 2 -> Can this formula be updated to '-' when not able to calculate (no values to aggregate)
1155626 |  |  | INT |  | 5 | Post 100% |  | Rp
1155626 |  |  | Final | 96849 | 5 | Post 100% |  | C D w/ I |  |  |  |  |  |  |  |  |  |  |  |  |  | Expecting 683,392 final quantity (96,849 + 586,543); formula is currently taking average of these values
1155626 |  |  | A | 50 | 5 | Post 100% |  | A |  |  |  |  |  |  |  |  |  |  |  |  |  | Expecting 683,392 final quantity (96,849 + 586,543); formula is currently taking average of these values
1155626 |  |  | Final | 586543 | 5 | Post 100% |  | C D w/ I |  |  |  |  |  |  |  |  |  |  |  |  |  | Expecting 683,392 final quantity (96,849 + 586,543); formula is currently taking average of these values
1155626 |  |  | Final | 586543 | 5 | Post 100% |  | C D w/o I |  |  |  |  |  |  |  |  |  |  |  |  |  | Expecting 683,392 final quantity (96,849 + 586,543); formula is currently taking average of these values
1162502 |  |  | Final | 81185 | 2 | No Posting |  | C D w/ I |  |  |  |  |  |  |  |  |  |  |  |  |  | Expecting 102,782 final quantity (81,185 + 21,597); formula is currently taking average of these values
1162502 |  |  | Final | 21597 | 2 | Net Down |  | C D w/ I |  |  |  |  |  |  |  |  |  |  |  |  |  | Expecting 102,782 final quantity (81,185 + 21,597); formula is currently taking average of these values
1162502 |  |  | A | 0 | 2 | Net Down |  | A |  |  |  |  |  |  |  |  |  |  |  |  |  | Expecting 102,782 final quantity (81,185 + 21,597); formula is currently taking average of these values
Spreadsheet: louise_kitchen__24127__North America Plan 01-02
Sheet: East - Struct

 | East Power Structuring
 | 2002 Plan
 |  |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 | 2002 |  | % |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast | Plan |  | of Total |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  |  | Compensation | 0
 | Special Pays
 | Analysts & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  |  | Total
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  |  | [NAME] | 33600
ENACONTR | Charitable Contributions |  |  |  |  |  |  |  | [NAME] | 52800
ENARENT | Rent |  |  |  |  |  |  |  | Staff | 54000
ENATECH | Technology |  |  |  |  |  |  |  | Specialist | 63000
ENATRANS | Transportation |  |  |  |  |  |  |  | Sr. Specialist | 78000
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  | Analyst | 66000
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  | Associate | 97200
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  | Manager | 120000
 |  |  |  |  |  |  |  |  | Director | 156000 | 1
 | Headcount |  |  |  |  |  |  |  | Sr. Director | 180000 |  |  | 1
 |  |  |  |  |  |  |  |  | VP | 216000
 | Analyst & Associate Headcount |  |  |  |  |  |  |  | MD | 240000
 | Total Headcount
 |  |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 524067
 |  |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 060f1e81-82d9-4615-b934-8fcbe6763616
Sheet: ETL2

Winter 2008 | TRA1000
Surname | GivenName | StudentNumber | Status | Faculty | [NAME] | ETL2 (50) | ETL2 (20) | %
Surname1 | GivenName1 | 12345 |  | Arts | [EMAIL] | 38
Surname2 | GivenName2 | 23456 |  | Arts | [EMAIL]
Surname3 | GivenName3 | 34567 |  | Arts | [EMAIL]
Surname4 | GivenName4 | 45678 |  | Arts | [EMAIL]
Surname5 | GivenName5 | 56789 |  | Arts | [EMAIL]
Average
Spreadsheet: 145609d1331662409-rank-by-state-sample-9-
Sheet: Sheet7

State | Selected | Contractor | Total Cost | Rank
AL | X | Company 1 | 6294.57 | 2
AL | X | Company 2 | 6200.57 | 1
AL | X | Company 3 | 6528.2 | 3
AR | X | Company 1 | 6285.73 | 1
AR | X | Company 2 | 6441.8 | 2
AR | X | Company 3 | 6991.860000000001 | 3
Spreadsheet: 51920d1251491250-list-to-table-question-list-to-table-question
Sheet: Sheet1

Num | Code
1 | ab
1 | mn |  |  |  | # | Code1 | Code2 | Code3 | Code4 | Code5 | Code6 | Code7 | Code8 | [NAME] | Code10 | Code11 | Code12
1 | hh |  |  |  | 1
2 | mn |  |  |  | 2
2 | hh |  |  |  | 3
3 | ab |  |  |  | 4
4 | gh |  |  |  | 5
4 | kl |  |  |  | 6
4 | rt |  |  |  | 7
4 | tj |  |  |  | 8
4 | qa |  |  |  | 9
4 | sd |  |  |  | 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
Spreadsheet: 174240d1344970754-macro-and-spreadsheet-design-brown-8-7h-daily-reports
Sheet: 8.12.12

Well-site Geology |  | Well Logging, Inc. |  |  |  |  |  |  | OFFICE [NAME]
[NAME] |  | Route 1, Box 111 |  |  |  |  |  |  | MOBILE XXX-XXX-XXXX
 |  | CITY, TX  XXXXX
 |  | Daily Report
 |  |  |  |  |  | Time | 06:00:00
Operator…ENERGY COMPANY |  |  |  |  |  | Date | 2012-08-12 00:00:00 | Spud | 2012-07-15 00:00:00
Well… | BROWN 8-7H |  | SEC 8-BLK 1 /CAMP CCSL SURVEY |  |  | Day No. |  | Days Logging
Location… WHEELER TX |  |  |  |  |  | OPERATION |  | DRILLING
[NAME]…JON DOE….. |  |  |  |  |  | Depth | 11037
Contracter…….. DRILLING COMPANY |  |  |  |  |  | 311 | made in | 22 | HRS / DRLG
Drilling Foreman……. [NAME] ……. |  |  |  |  |  | R.O.P. |  | Ft/Hr
[NAME]… DUSTIN STEWART ………… XXX-XXX-XXXX
BG | 417 - 575 UNITS |  | Flowline | X | Sep |  | Flare |  | Chokes
CG/DTG | 430 - 916 UNITS |  | Flowline | X | Sep |  | Flare |  | Chokes
Trip Gas | N/A |  | Flowline | X | Sep |  | Flare |  | Chokes
Lithology @ 11,020' -- 90% SAND,  10% SHALE
MUD CHECK |  | WOB | 33 | INC | 89.2 | NB # 8 | VAREL VM613P |  | IN AT | 10472
M.D. | 10808 | RPM | 80 | AZI | 359.94 |  | MADE |  | IN | 42
WT | 8.25 | PP | 3200 | MD | 10963 | HOURS | R.O.P. |  | FT./HR.
VIS | 61 | SPM | 140 | TVD | 10212.94 | OB# 7 | MADE | 637 | IN | 33
PV | 20 |  |  |  |  |  | R.O.P. |  | FT/HR.
YP | 21
GEL | 12/17/19 |  | GAS SHOW @
HTHP | 4 |  |  | BEFORE |  | DURING |  | AFTER
CAKE | 0/2 |  | ROP
SOL | 0.037 |  | GAS
OIL | 0.805 |  | LITH:
H2O | 0.135
CL | 51000 |  | ROP
CA | 27880 |  | GAS
LIME | 4.14 |  | LITH:
ES | 848
 |  |  | ROP
 |  |  | GAS
 |  |  | LITH:
REMARKS: |  |  |  |  |  |  |  | [NAME] TOPS
0600 - 1700 -  DRILL 10726-10863 |  |  |  |  |  |  |  | ANYHYDRITE 3,700'
1700 - 1730 -  SURVEY @ 10680, 10712, 10,743, 10775 |  |  |  |  |  |  |  | BROWN DOLO 4,508'
1730 - 1800 -  LUBE RIG |  |  |  |  |  |  |  | PENN SHALE 6,348'
1800 - 2400 -  DRILL 10863-10958 |  |  |  |  |  |  |  | BASE HEEBNER 8,348'
2400 - 0030 -  DEVIATION SURVEY |  |  |  |  |  |  |  | COTTAGE GROVE 9,760'
0030 - 0230 -  DRILL 10958-10990 |  |  |  |  |  |  |  | HOGSHOOTER 10,050'
0230 - 0300 -  DEVIATION TROUBLE SHOOT [NAME] AND SURVEY |  |  |  |  |  |  |  | CALDWELL 11,400'
0300 - 0600 -  DRILL 10990-11037 |  |  |  |  |  |  |  | CHEROKEE 11,480'
 |  |  |  |  |  |  |  | GRANITE WASH A 11,640'
 |  |  |  |  |  |  |  | GRANITE WASH B 11,843'
 |  |  |  |  |  |  |  | LANDING POINT 11,960'
Spreadsheet: 226599d1365448845-help-to-football-website-creating-statistics-worksheet
Sheet: Ark1

 | Home games
 | Date: | Teams |  |  |  |  | Example |  |  |  | Result
 | 2013-03-10 00:00:00 | F.C.K. | Silkeborg IF |  |  |  | The last five years against Silkeborg |  |  | Date | F.C.K. | Silkeborg | Attendance
 | 2013-05-15 00:00:00 | F.C.K. | AC Horsens |  |  |  |  |  |  | 2012-09-23 00:00:00 | 5 | 0 | 10757
 | 2013-04-07 00:00:00 | F.C.K. | OB |  |  |  |  |  |  | 2012-05-23 00:00:00 | 2 | 1 | 19974
 | 2013-04-28 00:00:00 | F.C.K. | AGF |  |  |  |  |  |  | 2011-08-28 00:00:00 | 2 | 1 | 11629
 | 2013-05-12 00:00:00 | F.C.K. | [NAME] |  |  |  |  |  |  | 2011-04-25 00:00:00 | 2 | 0 | 18474
 | 2013-05-20 00:00:00 | F.C.K. | Sønderjyske |  |  |  |  |  |  | 2010-09-11 00:00:00 | 2 | 2 | 13018
 |  |  |  |  |  |  |  |  |  | 2009-10-25 00:00:00 | 1 | 0 | 18383
 |  |  |  |  |  |  |  |  |  | 2009-08-01 00:00:00 | 1 | 1 | 14128
 | Only one game containing date of the game's execution the five years' previous results must be showing.
 | Don't know if I should use a combination box or have i should use it, if this is the case.
Spreadsheet: kate_symes__18191__EESSales_dailyfeb
Sheet: 2-22

NP15 | 2001-02-22 00:00:00 |  |  |  |  |  | SP15 |  |  |  |  |  |  | ZP26
Fixed Peak | 269.53 | Fixed Off Peak | 191.67 |  |  |  | Fixed Peak | 232.45 |  | Fixed Off Peak | 162 |  |  | Fixed Peak | 232.45 | Fixed Off Peak | 162
Index Peak |  | Index [NAME] |  |  |  |  | Index Peak |  |  | Index [NAME] |  |  |  | Index Peak |  | Index [NAME]
HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var
1 | 0 | 0 | -9.27 | -9.27 |  |  | 1 | -122.55 | 0 | -54 | -124.55 |  |  | 1 | -2 | 0 | 0 | -2
2 | 0 | 0 | -8.38 | -8.38 |  |  | 2 | -123.02 | 0 | -54 | -117.02 |  |  | 2 | -1.96 | 0 | 0 | -1.96
3 | 0 | 0 | -7.97 | -7.97 | 0 |  | 3 | -123.09 | 0 | -44 | -113.09 |  |  | 3 | -1.94 | 0 | 0 | -1.94
4 | 0 | 0 | -7.9 | -7.9 |  |  | 4 | -124.14 | 0 | -44 | -114.14 |  |  | 4 | -1.93 | 0 | 0 | -1.93
5 | 0 | 0 | -8.22 | -8.22 |  |  | 5 | -123.07 | 0 | -44 | -121.07 |  |  | 5 | -1.94 | 0 | 0 | -1.94
6 | 0 | 0 | -10.63 | -10.63 |  |  | 6 | -120.8 | 0 | -54 | -140.8 |  |  | 6 | -2.04 | 0 | 0 | -2.04
7 | 0 | 0 | -14.5 | -14.5 |  |  | 7 | -165.23 | 0 | -54 | -141.23 |  |  | 7 | -2.21 | 0 | 0 | -2.21
8 | 0 | 0 | -16.79 | -16.79 |  |  | 8 | -162.32 | 0 | -54 | -159.32 |  |  | 8 | -2.31 | 0 | 0 | -2.31
9 | 0 | 0 | -17.07 | -17.07 |  |  | 9 | -162.31 | 0 | -54 | -175.31 |  |  | 9 | -2.31 | 0 | 0 | -2.31
10 | 0 | 0 | -16.2 | -16.2 |  |  | 10 | -162.92 | 0 | -54 | -184.92 |  |  | 10 | -2.28 | 0 | 0 | -2.28
11 | 0 | 0 | -16.12 | -16.12 |  |  | 11 | -162.81 | 0 | -54 | -189.81 |  |  | 11 | -2.28 | 0 | 0 | -2.28
12 | 0 | 0 | -17.38 | -17.38 |  |  | 12 | -162.2 | 0 | -54 | -189.2 |  |  | 12 | -2.33 | 0 | 0 | -2.33
13 | 0 | 0 | -17.31 | -17.31 |  |  | 13 | -162.14 | 0 | -54 | -190.14 |  |  | 13 | -2.33 | 0 | 0 | -2.33
14 | 0 | 0 | -16.88 | -16.88 |  |  | 14 | -160.28 | 0 | -54 | -190.28 |  |  | 14 | -2.31 | 0 | 0 | -2.31
15 | 0 | 0 | -16.41 | -16.41 |  |  | 15 | -162.51 | 0 | -54 | -188.51 |  |  | 15 | -2.29 | 0 | 0 | -2.29
16 | 0 | 0 | -16.57 | -16.57 |  |  | 16 | -162.41 | 0 | -54 | -185.41 |  |  | 16 | -2.29 | 0 | 0 | -2.29
17 | 0 | 0 | -16.84 | -16.84 |  |  | 17 | -162.8 | 0 | -54 | -178.8 |  |  | 17 | -2.3 | 0 | 0 | -2.3
18 | 0 | 0 | -18.31 | -18.31 |  |  | 18 | -161.13 | 0 | -54 | -178.13 |  |  | 18 | -2.37 | 0 | 0 | -2.37
19 | -0.28 | 0 | -20 | -20.28 |  |  | 19 | -159.02 | 0 | -54 | -175.02 |  |  | 19 | -2.45 | 0 | 0 | -2.45
20 | 0 | 0 | -18.9 | -18.9 |  |  | 20 | -159.77 | 0 | -54 | -167.77 |  |  | 20 | -2.4 | 0 | 0 | -2.4
21 | 0 | 0 | -17.53 | -17.53 |  |  | 21 | -161.52 | 0 | -54 | -163.52 |  |  | 21 | -2.34 | 0 | 0 | -2.34
22 | 0 | 0 | -16.12 | -16.12 |  |  | 22 | -163.06 | 0 | -54 | -151.06 |  |  | 22 | -2.28 | 0 | 0 | -2.28
23 | 0 | 0 | -13.72 | -13.72 |  |  | 23 | -117.86 | 0 | -54 | -155.86 |  |  | 23 | -2.18 | 0 | 0 | -2.18
24 | 0 | 0 | -11.18 | -11.18 |  |  | 24 | -120.04 | 0 | -54 | -139.04 |  |  | 24 | -2.07 | 0 | 0 | -2.07
Spreadsheet: 04715533-f45f-4f68-8163-aa0956cf8fa9
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Name | Unnamed: 22 | ALPHA-CHLORDANE SEDIMENT,DRY WT,BOTTOM DEP   UG/KG | Unnamed: 24 | Unnamed: 25 | GAMMA-CHLORDANE, DRY WEIGHT, SEDIMENT UG/KG | Unnamed: 27 | Unnamed: 28 | HEPTACHLOR EPOXIDE SEDIMENT,DRY,WT,UG/KG | Unnamed: 30 | Unnamed: 31 | HEPTACHLOR IN BOT. DEP. (UG/KILOGRAM DRY SOLIDS) | Unnamed: 33 | Unnamed: 34 | HEXACHLOROBENZENE SEDIMENT,DRY,WT,UG/KG | Unnamed: 36 | Unnamed: 37
 | No Organo-chlorinated Pesticide in Sediment samples were analyzed in SFY2012! |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pgc Spc Parameter Code |  | 50784 |  |  | 50966 |  |  | 75045 |  |  | 39413 |  |  | 75042
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Uncensored Value | Value | Com Code | Uncensored Value | Value | Com Code | Uncensored Value | Value | Com Code | Uncensored Value | Value | Com Code | Uncensored Value | Value | Com Code
[NAME] | Lv1 Code | Lv3 Code | Station ID | Cbp Name | Stream Name | Station Description | Lat Deg | Lat Min | [NAME] | Lon Deg | Lon Min | [NAME] | HUC Code | Wqm Water Shed Code | FIPS County | Region Code | Collection Date/Time | Depth | Lab Num | Lcc Parm Group Cd | Container Id Desc
Spreadsheet: 5aee4355-2722-48c4-9c47-51f9c2f78f8e
Sheet: CF

ADVANCED MICRO DEVICES, INC.
CONSOLIDATED STATEMENT OF CASH FLOWS
(Millions)
 | Quarter Ended |  | Six Months Ended
 | Jul. 2, |  | Jul. 2,
 | 2011 |  | 2011
Cash flows from operating activities:
Net income | 61 |  | 571
Adjustments to reconcile net income to net cash provided by operating activities:
Equity income and dilution gain in investee | 0 |  | -492
Depreciation and amortization | 80 |  | 168
Compensation recognized under employee stock plans | 20 |  | 47
Non-cash interest expense | 6 |  | 11
Other | -1 |  | 9
Changes in operating assets and liabilities:
Accounts receivable | 2 |  | -187
Inventories | 6 |  | -10
Prepaid expenses and other current assets | 47 |  | 36
Other assets | -9 |  | 1
Accounts payable to GLOBALFOUNDRIES | -10 |  | -88
Accounts payable, accrued liabilities and other | -28 |  | -60
Net cash provided by operating activities | 174 |  | 6
Cash flows from investing activities:
Purchases of property, plant and equipment | -67 |  | -105
Purchases of available-for-sale securities | -559 |  | -952
Proceeds from sale and maturity of available-for-sale securities | 396 |  | 830
Other | 0 |  | -17
Net cash used in investing activities | -230 |  | -244
Cash flows from financing activities:
Proceeds from borrowings, net of issuance cost | 5 |  | 170
Net proceeds from foreign grants | 3 |  | 10
Proceeds from issuance of AMD common stock | 6 |  | 15
Repayments of debt and capital lease obligations | -4 |  | -5
Other | -2 |  | -4
Net cash provided by financing activities | 8 |  | 186
Net decrease in cash and cash equivalents | -48 |  | -52
Cash and cash equivalents at beginning of period | 602 |  | 606
Cash and cash equivalents at end of period | 554 |  | 554
Spreadsheet: 688247d1595662004-using-sumifs-to-categorize-expenditures-monthly-example1
Sheet: Pivot

Sum of Amount | Column Labels
Row Labels | יונ | יול | Grand Total
Advertising |  | 305 | 305
Customer Repair |  | 160 | 160
Food |  | 700 | 700
Gas | 70 | 560 | 630
Lawn Equipment Purchases | 110 | 390 | 500
Lawn Equipment Supplies |  | 1220 | 1220
Lawn Oil/Gas |  | 890 | 890
License | 60 | 270 | 330
Oil/Gas |  | 330 | 330
Truck Expense | 120 | 730 | 850
Grand Total | 360 | 5555 | 5915
Spreadsheet: 109587d1306410097-automatic-remote-entry-lookup640
Sheet: Sheet1

0 | 639 |  | 0.028 | 640
640 | 675 | 0.028
676 | 740 | 0.054
741 | 805 | 0.075
806 | 870 | 0.093
871 | 935 | 0.109
936 | 1000 | 0.123
1001 | 1065 | 0.135
1066 | 1125 | 0.145
1126 | 1195 | 0.155
Spreadsheet: 40342d1238638625-formula-to-count-highest-number-of-continuous-cells-w-data-in-a-range-and-their-sum-row-blanks-count-sum
Sheet: Sheet1

 | Values | 10 | MAX Count | 110 | [NAME] |  | 110
 |  | 0 |  | 0
 |  | 0 |  | 0
 | 1 | 1 |  | 1
 | 3 | 2 |  | 4
 | 5 | 3 |  | 9
 | 7 | 4 |  | 16
 | 9 | 5 |  | 25
 |  | 0 |  | 0
 | 2 | 1 |  | 2
 | 4 | 2 |  | 6
 | 6 | 3 |  | 12
 | 8 | 4 |  | 20
 | 10 | 5 |  | 30
 | 12 | 6 |  | 42
 | 14 | 7 |  | 56
 | 16 | 8 |  | 72
 | 18 | 9 |  | 90
 | 20 | 10 |  | 110
 |  | 0 |  | 0
 |  | 0 |  | 0
 |  | 0 |  | 0
 |  | 0 |  | 0
 |  | 0 |  | 0
 | 2 | 1 |  | 2
 | 4 | 2 |  | 6
 | 6 | 3 |  | 12
 | 8 | 4 |  | 20
 |  | 0 |  | 0
 |  | 0 |  | 0
 |  | 0 |  | 0
 |  | 0 |  | 0
 | 2 | 1 |  | 2
 | 4 | 2 |  | 6
 | 6 | 3 |  | 12
 | 8 | 4 |  | 20
 | 10 | 5 |  | 30
 | 12 | 6 |  | 42
 | 14 | 7 |  | 56
 | 16 | 8 |  | 72
 | 18 | 9 |  | 90
Spreadsheet: 99718d1298309270-count-until-a-condition-is-met-dummydata2
Sheet: Sheet1

Number | Name | Status | Countif | Address | $[NAME]
1 | Apple | Yes | 1 | Goal = | 6
2 | Beets | No | 2 | Number Yes= | 4
3 | Grapes | Never | 2 | Number No = | 2
4 | Apricots | Maybe | 2
5 | Tangerine | Yes | 3
6 | Plums | No | 4
7 | Lemons | Yes | 5
8 | Limes | Yes | 6
9 | Stawberry | Yes | 7
10 | Peas | Yes | 8
Spreadsheet: 141190d1329146263-trying-to-display-information-from-multiple-sheets-onto-1-summary-sheet-copy-of-production-scheduler-2-
Sheet: Summary

Summary Field
I want to be able to type all the information in this summary field so that it is filtered into the date tabs below
Status | Date Submitted | Job No | Site | Customer | Project Engineer / Manager | Scope of work | Min No of Persons | Budgeted Hours | Field of work | Start Date | Finish Date | Comments / Additional Information | Special Tools
[NAME] | 2011-02-02 00:00:00 | A***** | O**** | ***** | ***** | **** | *** | **** | **** | 2012-03-28 00:00:00 | 2012-03-29 00:00:00 | **** | **** |  | All of this should be visible in the march tab
Spreadsheet: 49411d1248774283-v-hlookup-for-certain-text-string-with-if-example
Sheet: Sheet1

 |  | in this sheet the name of the company will appear only once in A column
 | UK | France | Spain | etc
4m | test3 | test3
ever | test4 | test4 | here in these cells all values should appear that were found matching these two criteria
company1 | test1 | test1
company2 | test2 | test2
 | test1 | test1 | <<< | it's blank in A1 these values should not appear or should be "N/A"
 | test1 | test1
Spreadsheet: 801252d1666144169-sorting-of-rows-belonging-to-one-of-four-hierarchical-levels-sorting-of-four-levels2
Sheet: Sorting

Assetnum level |  | parent | assetnum
1 |  |  | A66.0001
2 |  | A66.0001 | A66.0006
3 |  | A66.0006 | A66.0006ARM
4 |  | A66.0006ARM | A11.0085
3 |  | A66.0006 | A66.0006INS
4 |  | A66.0006INS | W53.0002
4 |  | A66.0006INS | Z32.0017
4 |  | A66.0006INS | Z32.0034
4 |  | A66.0006INS | Z32.0037
4 |  | A66.0006INS | Z32.0041
3 |  | A66.0006 | A66.0006VAL
4 |  | A66.0006VAL | X31.1412
4 |  | A66.0006VAL | X31.1413
4 |  | A66.0006VAL | X31.1414
4 |  | A66.0006VAL | X31.1415
4 |  | A66.0006VAL | [NAME]
4 |  | A66.0006VAL | X31.1425
4 |  | A66.0006VAL | X32.0144
4 |  | A66.0006VAL | X32.0145
4 |  | A66.0006VAL | X36.1038
4 |  | A66.0006VAL | X36.1039
4 |  | A66.0006VAL | X36.1040
4 |  | A66.0006VAL | X36.1041
4 |  | A66.0006VAL | X36.1042
4 |  | A66.0006VAL | X37.0077
4 |  | A66.0006VAL | X38.0170
4 |  | A66.0006VAL | X38.0171
4 |  | A66.0006VAL | [NAME]
4 |  | A66.0006VAL | X38.0173
4 |  | A66.0006VAL | [NAME]
4 |  | A66.0006VAL | X38.0182
4 |  | A66.0006VAL | X38.0183
4 |  | A66.0006VAL | X38.0186
4 |  | A66.0006VAL | X38.0187
4 |  | A66.0006VAL | X38.0200
4 |  | A66.0006VAL | X38.0202
4 |  | A66.0006VAL | X38.0203
3 |  | A66.0006 | W12.0008
3 |  | A66.0006 | W12.0009
2 |  | A66.0001 | A66.0007
3 |  | A66.0007 | A66.0007ARM
4 |  | A66.0007ARM | A13.0085
3 |  | A66.0007 | A66.0007INS
4 |  | A66.0007INS | W54.0002
4 |  | A66.0007INS | Z33.0017
4 |  | A66.0007INS | Z33.0034
4 |  | A66.0007INS | Z33.0037
4 |  | A66.0007INS | Z33.0041
3 |  | A66.0007 | A66.0007VAL
4 |  | A66.0007VAL | X40.1412
4 |  | A66.0007VAL | X40.1413
4 |  | A66.0007VAL | X40.1414
4 |  | A66.0007VAL | X40.1415
4 |  | A66.0007VAL | X40.1424
4 |  | A66.0007VAL | X40.1425
4 |  | A66.0007VAL | X32.0144
4 |  | A66.0007VAL | X32.0145
4 |  | A66.0007VAL | X42.1038
4 |  | A66.0007VAL | X42.1039
4 |  | A66.0007VAL | X42.1040
4 |  | A66.0007VAL | [NAME]
4 |  | A66.0007VAL | X42.1042
4 |  | A66.0007VAL | X37.0077
4 |  | A66.0007VAL | X43.0170
4 |  | A66.0007VAL | X43.0171
4 |  | A66.0007VAL | [NAME]
4 |  | A66.0007VAL | X43.0173
4 |  | A66.0007VAL | X43.0174
4 |  | A66.0007VAL | X43.0182
4 |  | A66.0007VAL | X43.0183
4 |  | A66.0007VAL | X43.0186
4 |  | A66.0007VAL | X43.0187
4 |  | A66.0007VAL | X43.0200
4 |  | A66.0007VAL | X43.0202
4 |  | A66.0007VAL | X43.0203
3 |  | A66.0007 | W14.0008
3 |  | A66.0007 | W14.0009
Spreadsheet: 033d305d-cff9-418e-ab1e-33c6d7c1f9be
Sheet: 6. HighCost_Students

Colorado Department of Education
Maintenance of Effort Workbook
34 CFR §300.204(c)
Worksheet to Document Departure of High Cost Students
Instructions:  The first 100 are prepopulated with the State [NAME] and the [NAME] formula.  Numbers after 30 are hidden.  Unhide to get numbers 31 -100.  Add additional rows as needed and copy the threshold amount in column E and the formula in column F down into the appropriate columns of the additional rows, or you can contact [NAME] to add rows for you.  Do not report the same student on multiple lines.  See the Instructions tab under High Cost Students for more detailed instructions and allowable reasons for departure of high cost students.  For monitoring purposes, maintain your calculations of student costs and back up for reasons for leaving, but do not submit to CDE with this document, unless requested.
 |  |  | Total | State
 |  |  | State & Local | Threshold | Allowable
 |  |  | Program | for MOE High | Exception
No. | SASID | Reason for Decrease in Cost | Amount | Cost Program | Amount
1 |  |  |  | 7250
2 |  |  |  | 7250
3 |  |  |  | 7250
4 |  |  |  | 7250
5 |  |  |  | 7250
6 |  |  |  | 7250
7 |  |  |  | 7250
8 |  |  |  | 7250
9 |  |  |  | 7250
10 |  |  |  | 7250
11 |  |  |  | 7250
12 |  |  |  | 7250
13 |  |  |  | 7250
14 |  |  |  | 7250
15 |  |  |  | 7250
16 |  |  |  | 7250
17 |  |  |  | 7250
18 |  |  |  | 7250
19 |  |  |  | 7250
20 |  |  |  | 7250
21 |  |  |  | 7250
22 |  |  |  | 7250
23 |  |  |  | 7250
24 |  |  |  | 7250
25 |  |  |  | 7250
26 |  |  |  | 7250
27 |  |  |  | 7250
28 |  |  |  | 7250
29 |  |  |  | 7250
30 |  |  |  | 7250
31 |  |  |  | 7250
32 |  |  |  | 7250
33 |  |  |  | 7250
34 |  |  |  | 7250
35 |  |  |  | 7250
36 |  |  |  | 7250
37 |  |  |  | 7250
38 |  |  |  | 7250
39 |  |  |  | 7250
40 |  |  |  | 7250
41 |  |  |  | 7250
42 |  |  |  | 7250
43 |  |  |  | 7250
44 |  |  |  | 7250
45 |  |  |  | 7250
46 |  |  |  | 7250
47 |  |  |  | 7250
48 |  |  |  | 7250
49 |  |  |  | 7250
50 |  |  |  | 7250
51 |  |  |  | 7250
52 |  |  |  | 7250
53 |  |  |  | 7250
54 |  |  |  | 7250
55 |  |  |  | 7250
56 |  |  |  | 7250
57 |  |  |  | 7250
58 |  |  |  | 7250
59 |  |  |  | 7250
60 |  |  |  | 7250
61 |  |  |  | 7250
62 |  |  |  | 7250
63 |  |  |  | 7250
64 |  |  |  | 7250
65 |  |  |  | 7250
66 |  |  |  | 7250
67 |  |  |  | 7250
68 |  |  |  | 7250
69 |  |  |  | 7250
70 |  |  |  | 7250
71 |  |  |  | 7250
72 |  |  |  | 7250
73 |  |  |  | 7250
74 |  |  |  | 7250
75 |  |  |  | 7250
76 |  |  |  | 7250
77 |  |  |  | 7250
78 |  |  |  | 7250
79 |  |  |  | 7250
80 |  |  |  | 7250
81 |  |  |  | 7250
82 |  |  |  | 7250
83 |  |  |  | 7250
84 |  |  |  | 7250
85 |  |  |  | 7250
86 |  |  |  | 7250
87 |  |  |  | 7250
88 |  |  |  | 7250
89 |  |  |  | 7250
90 |  |  |  | 7250
91 |  |  |  | 7250
92 |  |  |  | 7250
93 |  |  |  | 7250
94 |  |  |  | 7250
95 |  |  |  | 7250
96 |  |  |  | 7250
97 |  |  |  | 7250
98 |  |  |  | 7250
99 |  |  |  | 7250
100 |  |  |  | 7250
 |  |  | Total:
Spreadsheet: 845915d1697210807-highlight-the-top-value-in-one-column-dependent-on-the-value-of-a-second-column-example
Sheet: Sheet1

 |  |  | Team | Player | Points
 |  |  | Orange | A | 6
 |  |  | Orange | B | 5
 |  |  | Orange | C | 7
 |  |  | Green | D | 8
 |  |  | Green | E | 2
 |  |  | Green | F | 4
 |  |  | Blue | G | 5
 |  |  | Blue | H | 7
 |  |  | Blue | I | 8
 |  |  | Red | J | 7
 |  |  | Red | K | 6
 |  |  | Red | L | 4