tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 780747d1652736923-i-want-a-cell-to-reference-a-formula-in-another-cell-not-what-the-formula-evaluates-to-formulasreferencingformulas
Sheet: Company2

 | Intentional Space | Final Score | [NAME] | BalanceSheet Score | Cash In | Cash Out | Accounts Payable Prev Month | Accounts Payable Current Month | Accounts Receivable Prev Month | Accounts Receivable Current Month | Assets | Liabilities
Month-24 |  |  |  |  | 123 | 456 |  |  | 333 | 444 | 567 | 100
Month-23 |  |  |  |  | 246 | 506 |  |  | 333 | 444 | 567 | 100
Month-22 |  |  |  |  | 369 | 556 |  |  | 333 | 444 | 567 | 100
[NAME] |  |  |  |  | 492 | 606 |  |  | 333 | 444 | 567 | 100
Month-20 |  |  |  |  | 615 | 656 |  |  | 333 | 444 | 567 | 100
Month-19 |  |  |  |  | 738 | 706 |  |  | 333 | 444 | 567 | 100
Month-18 |  |  |  |  | 861 | 756 |  |  | 333 | 444 | 567 | 100
Month-17 |  |  |  |  | 984 | 806 |  |  | 333 | 444 | 567 | 100
[NAME] |  |  |  |  | 1107 | 856 |  |  | 333 | 444 | 567 | 100
Month-15 |  |  |  |  | 1230 | 906 |  |  | 333 | 444 | 567 | 100
Month-14 |  |  |  |  | 1353 | 956 |  |  | 333 | 444 | 567 | 100
Month-13 |  |  |  |  | 1476 | 1006 |  |  | 333 | 444 | 567 | 100
[NAME] |  |  |  |  | 1599 | 1056 |  |  | 333 | 444 | 567 | 100
Month-11 |  |  |  |  | 1722 | 1106 |  |  | 333 | 444 | 567 | 100
Month-10 |  |  |  |  | 1845 | 1156 |  |  | 333 | 444 | 567 | 100
Month-9 |  |  |  |  | 1968 | 1206 |  |  | 333 | 444 | 567 | 100
Month-8 |  |  |  |  | 2091 | 1256 |  |  | 333 | 444 | 567 | 100
Month-7 |  |  |  |  | 2214 | 1306 |  |  | 333 | 444 | 567 | 100
Month-6 |  |  |  |  | 2337 | 1356 |  |  | 333 | 444 | 567 | 100
Month-5 |  |  |  |  | 2460 | 1406 |  |  | 333 | 444 | 567 | 100
Month-4 |  |  |  |  | 2583 | 1456 |  |  | 333 | 444 | 567 | 100
Month-3 |  |  |  |  | 2706 | 1506 |  |  | 333 | 444 | 567 | 100
Month-2 |  |  |  |  | 2829 | 1556 |  |  | 333 | 444 | 567 | 100
Month-1 |  |  |  |  | 2952 | 1606 |  |  | 333 | 444 | 567 | 100
Month-0 |  |  |  |  | 3075 | 1656 |  |  | 333 | 444 | 567 | 100
Spreadsheet: 269647d1381240474-need-to-search-2-columns-at-once-and-report-the-results-where-matches-are-found-fruit-search
Sheet: Sheet1

 | List 1 |  |  | List 2 | Palette number | Box number |  | Search term A: | Search Term B: | Search Result for Search term A and Search term B | Search Result for Search term B and Search term A | Both Search term Included i.e. First A and B and after Reverse B and A
 | Apples |  |  | Bananas | 1 | 1 |  | Apples | Bananas
 | Pears |  |  | Bananas | 1 | 2
 | Oranges |  |  | Lemons | 2 | 3
 | Bananas |  |  | Apples | 2 | 3
 | Grapefruits |  |  | Pears | 2 | 5
Spreadsheet: 09b71ca7-988f-47f0-8a83-7dd15887c128
Sheet: Sheet1

Table 5--Wheat: National average price received by farmers (dollars per bushel) 1/, 2/12/2014 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Month | All wheat |  | Winter |  | Durum |  | Other spring
 | 2012/13 | 2013/14 | 2012/13 | 2013/14 | 2012/13 | 2013/14 | 2012/13 | 2013/14
June | 6.7 | 7.32 | 6.55 | 7.18 | 8.31 | 8.26 | 7.78 | 7.72
July | 7.89 | 6.93 | 7.76 | 6.85 | 8.67 | 8.17 | 8.39 | 7.29
August | 8.04 | 6.87 | 7.92 | 6.81 | 7.76 | 7.76 | 8.27 | 6.97
September | 8.27 | 6.8 | 8.25 | 6.79 | 7.77 | 7.9 | 8.38 | 6.71
October | 8.38 | 7 | 8.33 | 7.07 | 7.61 | 7.12 | 8.56 | 6.84
November | 8.47 | 6.85 | 8.38 | 6.96 | 8.11 | 6.75 | 8.65 | 6.7
December | 8.3 | 6.73 | 8.15 | 6.84 | 8.31 | 6.96 | 8.48 | 6.56
January | 8.12 | 6.31 | 8.01 | 6.29 | 8.24 | 6.68 | 8.34 | 6.3
February | 7.97 |  | 7.85 |  | 8.19 |  | 8.11
March | 7.79 |  | 7.63 |  | 8.12 |  | 7.95
April | 7.71 |  | 7.52 |  | 8.01 |  | 7.9
May | 7.68 |  | 7.49 |  | 8.06 |  | 7.84
1/ Preliminary mid-month, weighted-average price for current month. Source: USDA, National Agricultural Statistics Service, Agricultural Prices.
Date run: 2/11/2014
Spreadsheet: 730384d1619684484-extracting-and-arranging-data-salary-1-ans-4
Sheet: Data

 | [NAME] (Salary) |  |  |  |  | JVN0711 | 3821.45
 | [NAME] (Pf) |  |  |  |  | JVN0711 | 518.21
 | [NAME] (Gt) |  |  |  |  | JVN0711 | 215.83 |  | Helper columns C and D are used
 | Md Pintu [Salary] |  |  |  |  | JVN0711 | 3620.32
 | Md Pintu [Pf] |  |  |  |  | JVN0711 | 490.94
 | Md Pintu [Gt] |  |  |  |  | JVN0711 | 204.47
 | [NAME] [Salary] |  |  |  |  | JVN0711 | 2815.81
 | [NAME] [Pf] |  |  |  |  | JVN0711 | 381.84
 | [NAME] [Gt] |  |  |  |  | JVN0711 | 159.04
 | [NAME].[NAME] [Salary] |  |  |  |  | JVN0711 | 1206.77
 | [NAME].[NAME] [Pf] |  |  |  |  | JVN0711 | 136.65
 | [NAME].[NAME] [Gt] |  |  |  |  | JVN0711 | 68.16
 | Amit Choudhary (Salary) |  |  |  |  | JVN0084 | 12067.74
 | Amit Choudhary (PF) |  |  |  |  | JVN0084 | 1636.45
 | Amit Choudhary (Gratuity) |  |  |  |  | JVN0084 | 681.58
Spreadsheet: 207675d1358526630-all-permutation-and-combinations-of-4-letters-and-4-numbers-ef327_combinations
Sheet: Numbers

1111
1112
1113
1114
1121
1122
1123
1124
1131
1132
1133
1134
1141
1142
1143
1144
1211
1212
1213
1214
1221
1222
1223
1224
1231
1232
1233
1234
1241
1242
1243
1244
1311
1312
1313
1314
1321
1322
1323
1324
1331
1332
1333
1334
1341
1342
1343
1344
1411
1412
1413
1414
1421
1422
1423
1424
1431
1432
1433
1434
1441
1442
1443
1444
2111
2112
2113
2114
2121
2122
2123
2124
2131
2132
2133
2134
2141
2142
2143
2144
2211
2212
2213
2214
2221
2222
2223
2224
2231
2232
2233
2234
2241
2242
2243
2244
2311
2312
2313
2314
2321
2322
2323
2324
2331
2332
2333
2334
2341
2342
2343
2344
2411
2412
2413
2414
2421
2422
2423
2424
2431
2432
2433
2434
2441
2442
2443
2444
3111
3112
3113
3114
3121
3122
3123
3124
3131
3132
3133
3134
3141
3142
3143
3144
3211
3212
3213
3214
3221
3222
3223
3224
3231
3232
3233
3234
3241
3242
3243
3244
3311
3312
3313
3314
3321
3322
3323
3324
3331
3332
3333
3334
3341
3342
3343
3344
3411
3412
3413
3414
3421
3422
3423
3424
3431
3432
3433
3434
3441
3442
3443
3444
4111
4112
4113
4114
4121
4122
4123
4124
4131
4132
4133
4134
4141
4142
4143
4144
4211
4212
4213
4214
4221
4222
4223
4224
4231
4232
4233
4234
4241
4242
4243
4244
4311
4312
4313
4314
4321
4322
4323
4324
4331
4332
4333
4334
4341
4342
4343
4344
4411
4412
4413
4414
4421
4422
4423
4424
4431
4432
4433
4434
4441
4442
4443
4444
1111
1112
1113
1114
1121
1122
1123
1124
1131
1132
1133
1134
1141
1142
1143
1144
1211
1212
1213
1214
1221
1222
1223
1224
1231
1232
1233
1234
1241
1242
1243
Spreadsheet: 883832d1732560361-class-wise-attendance-need-to-calculate-sample
Sheet: Sheet2

Class | Student Name | 2024-11-01 00:00:00 | 2024-11-02 00:00:00 | 2024-11-03 00:00:00 | 2024-11-04 00:00:00 | 2024-11-05 00:00:00 | 2024-11-06 00:00:00 |  |  |  |  |  | Class | Total Present | Total Leaves | Total
1A | XYZ | P | L | P | P | P | P |  |  |  |  |  | 1A | 20 | 4 | 24
2B | ABC | P | P | P | L | P | P |  |  |  |  |  | 2B | 24 | 6 | 30
3B | GFC | P | P | P | P | P | P |  |  |  |  |  | 3B | 25 | 5 | 30
3B | NOP | L | P | P | P | P | P |  |  |  |  |  | 4D | 23 | 7 | 30
3B | HIJ | P | P | P | P | P | P
4D | EFG | P | P | L | L | P | P
2B | KLM | P | P | P | P | P | P
2B | QRS | P | L | L | P | P | P
2B | TUV | P | P | P | P | P | P
1A | DSP | P | P | L | L | L | P
1A | PQR | P | P | P | P | P | P
1A | WGA | P | P | P | P | P | P
4D | FIHJ | P | P | P | P | P | L
4D | SOP | P | P | P | P | P | P
4D | DCB | P | L | L | L | L | P
4D | DCP | P | P | P | P | P | P
2B | DOC | P | P | P | L | L | L
3B | POC | P | P | P | P | P | P
3B | ETC | L | L | L | L | P | P
Spreadsheet: 162338d1339801572-no-idea-how-to-title-this-some-sort-of-referencing-trucking-master-1-
Sheet: Sheet1

Trucking Report for Wednessday January 2, 2012 San Antonio
 | 231 J&M | 232 J&M | 276 J&M | 277 J&M | 225 J&M |  | 11 SORIANO'S
NAME | ISHMEAL | ALFREDO | ALVARO | MUNDO | [NAME] |  | [NAME]
JH# | JMT6618 | JMT2644 | JMT0941 | JMT8413 |  |  | [NAME]
TOTAL HOURS
STANDBY HOURS
REGULAR HOURS
MILLING LOADS
HOTMIX [NAME]
TOTAL TONS
[NAME] LOAD
AVRG LOADS HOUR
HOURLY RATE
DOLLARS PER TON
DOLLARS PER LOAD
 |  |  | Hours |  |  |  | Loads
 | NAME | JH# | TOTAL | STANDBY | REGULAR | HOURLY RATE | MILLING | HOTMIX | TOTAL TONS | [NAME] LOAD | AVRG LOADS HOUR | DOLLARS PER TON | DOLLARS PER LOAD
231 J&M | ISHMEAL | JMT6618 | 1
232 J&M | ALFREDO | JMT2644 | 2
276 J&M | ALVARO | JMT0941 | 3
277 J&M | MUNDO | JMT8413 | 4
225 J&M | [NAME] |  | 5
11 SORIANO'S | [NAME] | [NAME] | 6
276 J&M | ALVARO | JMT0941 | 3
277 J&M | MUNDO | JMT8413 | 4
225 J&M | [NAME] |  | 5
11 SORIANO'S | [NAME] | [NAME] | 6
276 J&M | ALVARO | JMT0941 | 3
277 J&M | MUNDO | JMT8413 | 4
225 J&M | [NAME] |  | 5
11 SORIANO'S | [NAME] | [NAME] | 6
Spreadsheet: richard_shapiro__32601__Accomplishment-june5th2001-Masteredit
Sheet: EUROPE

Accomplishment for the Period November 2000 to April 2001
No. | Accomplishments | Customer | Value | Area |  |  |  |  | Methodology
 | (description) | (B. Unit) | ($) | Deal Support | Origination | Risk Management | [NAME] | Other
EUROPE
[NAME]
1 | NETA: kept the Pooling and Settlement Agreement alive to prevent the contract terminating. | Yorkshire Electricity CFD | several £million
2 | Competition Act case against a service provider to one of our businesses. |  | £millions
3 | NETA go-live.  We expressed serious concerns about the NETA start date because of problems with the central systems. | NETA | Value here is uncertain but substantial (a single error can cost hundreds of thousands)
4 | Secured changes to the calculation of NETA imbalance prices. |  | Value is difficult to quantify
5 | Ofgem - Market Abuse Licence Condition failing to secure would have injected significant additional regulatory risk | Ofgem | Value is difficult to quantify
6 | I secured exempt status for our distribution network at Wilton on Teesside | Wilton on Teesside | Value is difficult to quantify
7 | I got Enron Direct's customer complaint statistics removed from Ofgem's website. | Enron Direct | Value is intangible, but has avoided ongoing attrition to Enron brand (through news stories etc)
[NAME] |  | Region/Country:    Europe |  |  | Primary Activity:   EBS Europe |  | Secondary Activity:    EBS Asia Pacific
1 | Licenses for EBS Activity in following markets (Belgium, Germany, Italy, Switzerland, The Netherlands, Sweden, Spain, UK) | EBS
2 | Support for EBS Asia Pacific for Pioner Tax Status in Singapore, Secured SBO License in Singapore | EBS Asia Pacific
3 | General [NAME] for The Enron Online Offering on behalf of Enron Europe | Enron Europe
4 | Presentation of EBS in front of national regulatory bodies (France, Singapore) and internationally (European Commission) | EBS
5 | Downsizing of the EBS licensing budget to 15 % of its original through rectifying licensing targets | EBS | US$ 800,000
Spreadsheet: 2d492183-e9ab-42ed-9a0e-6762aff26d50
Sheet: IS_GAAP

 | ADVANCED MICRO DEVICES, INC.
 | CONSOLIDATED STATEMENTS OF OPERATIONS
 | (Millions except per share amounts and percentages)
 |  |  |  | Quarter Ended
 |  |  |  | Apr. 2, | Dec. 25, | Mar. 27,
 |  |  |  | 2011 | 2010 | 2010
 | Net revenue |  |  | 1613 | 1649 | 1574
 | Cost of sales |  |  | 922 | 906 | 833
 | Gross margin |  |  | 691 | 743 | 741
 | Gross margin % |  |  | 0.43 | 0.45 | 0.47
 | Research and development |  |  | 367 | 352 | 323
 | Marketing, general and administrative |  |  | 261 | 250 | 219
 | Legal settlement |  |  | 0 | -283 | 0
 | Amortization of acquired intangible assets |  |  | 9 | 11 | 17
 | Operating income |  |  | 54 | 413 | 182
 | Interest income |  |  | 3 | 2 | 3
 | Interest expense |  |  | -48 | -39 | -49
 | Other income (expense), net |  |  | 11 | 14 | 304
 | Income before equity income (loss) and dilution gain in investee and income taxes |  |  | 20 | 390 | 440
 | Provision for income taxes |  |  | 2 | 42 | 0
 | Equity income (loss) and dilution gain in investee, net |  |  | 492 | 27 | -183
 | Net income |  |  | 510 | 375 | 257
 | Net income per common share
 |  | Basic |  | 0.71 | 0.52 | 0.36
 |  | Diluted |  | 0.68 | 0.5 | 0.35
 | Shares used in per share calculation
 |  | Basic |  | 720 | 717 | 707
 |  | Diluted |  | 764 | 758 | 754
Spreadsheet: 92455d1292005284-excel-2007-sum-formula-timesheet-r-
Sheet: WE010110

Express Employment Professional
 |  |  |  |  |  |  |  |  |  |  | Week Ending: 01/01/2010
 |  |  | 2009-12-29 00:00:00 |  |  | 2009-12-30 00:00:00 |  |  | 2009-12-31 00:00:00
Employee Name | Hr Days |  | Monday | Reg | OT | Tuesday | Reg | OT | Wednesday | Reg | OT | Thursday | Reg | OT | Friday | Reg | OT | WeeklyTotal | Overtime
[NAME] | 10 | Start | 05:00:00 |  |  | 05:00:00
 |  | L.O. | 11:15:00 |  |  | 11:15:00
 |  | L.I. | 11:45:00 |  |  | 11:45:00
 |  | End | 16:00:00 | 10 | 0.4999999999999982 | 16:30:00 | 10 | 1 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 20 | 1.499999999999998
 | 10 | Start
 |  | L.O.
 |  | L.I.
 |  | End |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 | 10 | Start
 |  | L.O.
 |  | L.I.
 |  | End |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 | 8 | Start
 |  | L.O.
 |  | L.I.
 |  | End |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 | 8 | Start
 |  | L.O.
 |  | L.I.
 |  | End |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 | 8 | Start
 |  | L.O.
 |  | L.I.
 |  | End |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 | 8 | Start
 |  | L.O.
 |  | L.I.
 |  | End |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 | 8 | Start
 |  | L.O.
 |  | L.I.
 |  | End |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | Total Regular Hours: |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  | Total O.T. | 1.499999999999998
Manager [NAME]: |  |  |  |  |  |  | Date:
Spreadsheet: 0e7ce6ab-e5d2-4b10-8ef1-6b3562ae904a
Sheet: Cochrane

[NAME] ([NAME])
2009-2010
COUNTER-Compliant?: | No
 | 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 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | Total | 2009-2010 Price | Price per unit
[NAME]
User Sessions | 80 | 30 | 141 | 199 | 278 | 90 | 51 | 200 | 266 | 291 | 46 | 74
Searches (Total) | 19 | 8 | 127 | 66 | 102 | 10 | 8 | 19 | 62 | 60 | 6 | 8 |  | 3241
Full-Text (Total) | 33 | 27 | 52 | 145 | 211 | 56 | 28 | 62 | 176 | 215 | 38 | 62 |  | 3241
Access Denied | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 139 | 0 | 0 | 0 | 0
Spreadsheet: 887723d1738054705-merging-data-from-multiple-workbooks-sorting-alphabetically-creating-new-workbooks-master-list-example
Sheet: P2 Tricky Words

Rm | Surname | First Name | Tricky Words Read / Locate |  |  |  |  | Correct / 5
 |  |  | the | to | I | no | go
Spreadsheet: 227172b9-ed9d-4812-9ae4-3a69bdd4b94f
Sheet: Language

Language | Titles | Percent
French | 67
German | 57
Spanish | 56
Italian | 35
Japanese | 28
Swedish | 26
Arabic | 25
Russian | 20
Chinese | 16
Portuguese | 14
Norwegian | 11
Icelandic | 10
Polish | 10
Danish | 8
Turkish | 6
Catalan | 5
Dutch | 4
Finnish | 4
Greek | 4
Hebrew | 4
Hungarian | 4
Romanian | 4
Serbian | 4
Various | 4
Czech | 3
Korean | 3
Macedonian | 3
Estonian | 2
Persian | 2
Slovenian | 2
Ukrainian | 2
Vietnamese | 2
Afrikaans | 1
Basque | 1
Croatian | 1
Flemish | 1
Georgian | 1
Hindi | 1
Urdu | 1
Spreadsheet: 168814d1342596152-summing-a-cf-range-testcf
Sheet: 300412

KPI = 5 bus days | Proposed Weight calculations = 21. 48
KPI as of | 2012-04-30 00:00:00
Volumes per day' cells automatically assign colours based on the criteria, below.
 | Not meeting 5 work days
 | Equal to 5 work days - requires immediate action
 | Better than 5 work days
Assessment Forms
Date received | Volumes per day
2012-04-04 00:00:00 | 10
2012-04-05 00:00:00 | 10
2012-04-20 00:00:00 | 10
2012-04-23 00:00:00 | 10
Total Work on Hand to date | 40 | % inside KPI
Total work on hand within KPI |  | 0
Spreadsheet: 832011d1686060588-map-values-dynamic-arrays-color
Sheet: Feuil1

color (ignore) |  | color (ignore) | abbreviation (ignore) |  |  | color | abbreviation |  | color |  | abbreviation (expected result, as spilling array)
black white |  | black | B |  |  |  |  |  |  |  | BW
yellow |  | yellow | Y |  |  | yellow | Y |  | yellow |  | Y
yellow blue |  | white | W |  |  | white | W |  | yellow blue |  | YB
 |  | blue | B |  |  | blue | B
Spreadsheet: 718261d1613061433-list-of-values-based-on-a-specific-criteria-porfolio-1-
Sheet: In Progress

 | Project Name |  |  | Project
 |  |  |  | Project 6
 |  |  |  | Project 9
 |  |  |  | Project 10
 |  |  |  | Project 11
 |  |  |  | Project 13
 |  |  |  | Project 15
 |  |  |  | Project 16
 |  |  |  | Project 28
 |  |  |  | Project 30
 |  |  |  | Project 32
 |  |  |  | Project 34
 |  |  |  | Project 44
 |  |  |  | Project 46
 |  |  |  | Project 53
 |  |  |  | Project 55
 |  |  |  | Project 56
 |  |  |  | Project 62
 |  |  |  | Project 65
 |  |  |  | Project 68
 |  |  |  | Project 69
 |  |  |  | Project 70
 |  |  |  | Project 72
 |  |  |  | Project 73
 |  |  |  | Project 74
 |  |  |  | Project 75
 |  |  |  | Project 77
 |  |  |  | Project 78
 |  |  |  | Project 80
 |  |  |  | Project 82
 |  |  |  | Project 83
 |  |  |  | Project 84
 |  |  |  | Project 85
 |  |  |  | Project 86
 |  |  |  | Project 87
 |  |  |  | Project 89
 |  |  |  | Project 91
 |  |  |  | Project 92
 |  |  |  | Project 96
 |  |  |  | Project 97
 |  |  |  | Project 98
Spreadsheet: 455655d1460454050-formula-for-ratio-trial
Sheet: Sheet1

YARD: |  |  |  |  | [NAME] :
CONTAINER DETAILS
SNO. | CONTAINER NOS. |  | SEAL NOS. |  | APP. WT | WT. ADJ. |  | [NAME] | ORIGINAL WT. | ADJ. WT.
1 | ABCD | 123456 | 123456 |  | 26800 |  |  | Less than 23.7
2 | ABCD | 123456 | 123456 |  | 25500 |  |  | Less than 27.7
3 | ABCD | 123456 | 123456 |  | 26620
4 | ABCD | 123456 | 123456 |  | 25460
5 | ABCD | 123456 | 123456 |  | 24220
6 | ABCD | 123456 | 123456 |  | 24440
7 | ABCD | 123456 | 123456 |  | 25000
8 | ABCD | 123456 | 123456 |  | 24440
Spreadsheet: 842222d1694325776-extracting-all-non-zero-values-in-multiple-rows-of-a-worksheet-to-a-single-column-pq-single-column
Sheet: Sheet1

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 |  | Value
1 | 1 | 1 | 0 | 0 | 0 |  | 1
2 | 2 | 2 | 0 | 0 | 0 |  | 1
3 | 3 | 3 | 0 | 0 | 0 |  | 1
0 | 0 | 0 | 0 | 0 | 0 |  | 2
0 | 0 | 0 | 0 | 0 | 0 |  | 2
0 | 0 | 0 | 0 | 0 | 0 |  | 2
0 | 0 | 0 | 0 | 0 | 0 |  | 3
0 | 0 | 0 | 0 | 0 | 0 |  | 3
0 | 0 | 0 | 0 | 0 | 0 |  | 3
0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 739733d1625903965-formula-needed-to-transfer-information-from-one-sheet-to-another-demo
Sheet: Sheet2

A | B | C | D
1 | text 1 | text 1 | text 1
2 | text 2 | text 2 | text 2
3 | text 3 | text 3 | text 3
4 | text 4 | text 4 | text 4
5 | text 5 | text 5 | text 5
6 | text 6 | text 6 | text 6
7 | text 7 | text 7 | text 7
8 | text 8 | text 8 | text 8
9 | text 9 | text 9 | text 9
10 | text 10 | text 10 | text 10
11 | text 11 | text 11 | text 11
Spreadsheet: 05268627-fff7-47c7-b11f-b5ed550c946d
Sheet: Sheet1

TABLE OF CONTENTS | Unnamed: 1 | Unnamed: 2
1 |  | KATS
2 |  | TEK Systems
3 |  | ProTech
4 |  | IBM
5 |  | GIS Services
6 |  | ExecuTrain of Kansas
7 |  | CENTRIQ FOSS
8 |  | New Horizons
9 |  | Altiva Software
10 |  | [NAME]
11 |  | Knowledge Base Consulting Group
12 |  | [NAME] and Associates
13 |  | Center for Business & Technology - Johnson County Community College
14 |  | DebTech International
15 |  | Ummel Group
16 |  | Software Engineering Services
17 |  | Interskill Learning
18 |  | Element K
19 |  | Maverick Solutions
20 |  | GISEDGE
21 |  | Premier Knowledge Solutions
22 |  | Global Knowledge Training
23 |  | Persimmon Group
24 |  | Quilogy
25 |  | Connect Integration
Spreadsheet: 7b535165-518a-4229-b126-10515583749b
Sheet: Sheet1

PARKER HANNIFIN CORPORATION | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
ORDER RATES
 |  |  | TOTAL PARKER | IND'L  NO. AMER | IND'L INT'L | AERO | CIC
 |  |  |  | Fiscal 2010
 |  | September | -25 | -27 | -25 | -23 | -17
 |  | December | -7 | -3 | 0 | -27 | 6
 |  | March | 23 | 30 | 42 | -22 | 38
 |  | June | 35 | 46 | 46 | -3 | 35
 |  |  | Fiscal 2011
 |  | September | 29 | 31 | 34 | 16 | 23
 |  | December | 29 | 26 | 29 | 37 | 26
 |  | March | 24 | 20 | 22 | 44 | 14
 |  | June | 15 | 11 | 18 | 27 | 1
 |  |  | Fiscal 2012
 |  | September | 9.4 | 16.1 | 4.1 | 13.7 | -4.1
 |  | December | 2.7 | 7.6 | 0.8 | 0.3 | -5.4
 |  | March | 2 | 7 | -1 | 4 | -6
 |  | June | -1 | 4 | -9 | 7 | 1
 |  | Percentage change calculated as a 3-month year-over-year average of total
 |  | Order dollars (except [NAME]). Aerospace is calculated using a 12-month
 |  | rolling average year-over-year comparison. Total Parker is a weighted average
 |  | of the percent changes as calculated for 3 months or 12-months rolling, as
 |  | above. Any impact from acquisitions or currency has been eliminated from the
 |  | calculations.
Spreadsheet: 708072d1607608577-simplifying-a-very-old-worksheet-bourn
Sheet: Bromley

hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | INDEX 1 | INDEX 2 | INDEX 3 | points | handicap | handicap | HANDICAPPING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 763101d1641993803-consecutive-dates-to-from-and-to-sickness-report
Sheet: Sheet1

RAW DATA |  |  |  |  |  | Expected Data
Name | Shift | Date |  |  |  | Name | From | To
AAB | Sick | 09/12/2021 |  |  |  | AAB | 2021-12-09 00:00:00 | 2021-12-12 00:00:00
AAB | OffDay | 2021-12-10 00:00:00 |  |  |  | AAB | 2021-12-16 00:00:00 | 2021-12-21 00:00:00
AAB | OffDay | 2021-12-11 00:00:00 |  |  |  | AP | 2021-12-29 00:00:00 | 2021-12-29 00:00:00
AAB | Sick | 2021-12-12 00:00:00 |  |  |  | AP | 2021-12-15 00:00:00 | 2021-12-15 00:00:00
AAB | Sick | 16/12/2021 |  |  |  | AR | 2021-12-16 00:00:00 | 2021-12-18 00:00:00
AAB | Sick | 17/12/2021 |  |  |  | AR | 2021-12-20 00:00:00 | 2021-12-21 00:00:00
AAB | Sick | 18/12/2021 |  |  |  | AR | 2021-12-23 00:00:00 | 2021-12-23 00:00:00
AAB | Sick | 19/12/2021 |  |  |  | AR | 2021-12-25 00:00:00 | 2021-12-25 00:00:00
AAB | Sick | 20/12/2021 |  |  |  | AF | 2021-12-18 00:00:00 | 2021-12-24 00:00:00
AAB | Sick | 21/12/2021 |  |  |  | AS | 2021-12-08 00:00:00 | 2021-12-11 00:00:00
AP | Sick | 29/12/2021 |  |  |  | AS | 2021-12-26 00:00:00 | 2021-12-26 00:00:00
AP | Sick | 15/12/2021 |  |  |  | AS | 2021-12-28 00:00:00 | 2021-12-28 00:00:00
AR | Sick | 16/12/2021 |  |  |  | AS | 2021-12-12 00:00:00 | 2021-12-12 00:00:00
AR | OffDay | 2021-12-17 00:00:00
AR | Sick | 2021-12-18 00:00:00
AR | Sick | 20/12/2021
AR | Sick | 21/12/2021
AR | Sick | 23/12/2021
AR | Sick | 25/12/2021
AF | Sick | 18/12/2021
AF | Sick | 19/12/2021
AF | Sick | 20/12/2021
AF | Sick | 21/12/2021
AF | Sick | 22/12/2021
AF | Sick | 23/12/2021
AF | Sick | 24/12/2021
AS | Sick | 08/12/2021
AS | Sick | 09/12/2021
AS | OffDay | 2021-12-10 00:00:00
AS | Sick | 11/12/2021
AS | Sick | 26/12/2021
AS | Sick | 28/12/2021
AS | Sick | 12/12/2021
Spreadsheet: 488816f6-e1e2-46f6-af16-14bb2965e01b
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
263451 | 40922 | Francesc | Sola Garcia | ESP | 61 |  |  |  |  |  | 1 | 1:06:37