tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 671260d1586331961-update-defining-exact-length-of-string-for-istext-within-aggregate-function-00-wages-template-for-tests
Sheet: 10 WEDNESDAY

DAY: |  | WEDNESDAY |  | DATE:
No. |  | NAME |  |  |  | FROM | TO | Wh | VL | SL | OT | F/L | Hr | F/L | Hr | F/L | Hr | F/L | Hr | JOBS | Hr | GR/WS | Hr | CHECK |  | JOBS BREAKDOWN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
12 | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  | [NAME] |  |  | GROUPAGE
11 | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  | DRIVERS |  |  | DRIVERS
14 | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  | PART TIMERS |  |  | PART TIMERS
33 | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  | WELDERS |  |  | WELDERS
37 | W
27 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS
53 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS | HR | WD | PT | DR
54 | W
50 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
30 | P
31 | P
32 | P
51 | P
52 | P
55 | P
15 | P
23 | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REPAIRS MT
26 | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS | HR | WD | PT | DR
6 | D
10 | D
47 | D
[NAME] |  |  |  |  | GROUPAGE |  |  | IDLE TIME |  |  |  |  | JOBS |  |  |  | REPAIRS MT |  |  |  | WORKSHOP WS
JOBS |  |  | HR |  | JOBS | HR |  | JOBS |  |  | HR |  | JOBS |  | HR |  | JOBS |  | HR |  | JOBS |  | HR
TOTAL |  |  |  |  | TOTAL |  |  | TOTAL |  |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL
 |  |  |  |  | Hours Calculator |  |  |  |  |  |  |  |  |  |  | TOTAL 2 |  |  |  |  | TOTAL 1
Spreadsheet: 7b3e9882-6541-4ad4-878c-2e5d1fc52193
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7071 | 47908 | [NAME] | Filipovic | SRB | 56 | 00:13:12 | 00:02:08 | 00:34:15 | 00:01:00 | 00:22:44 | 1 | 01:13:19
7071 | 47259 | [NAME] | Riaño | ESP | 57 | 00:18:16 | 00:02:26 | 00:33:49 | 00:01:17 | 00:25:23 | 2 | 01:21:09
7071 | 17485 | Alberto | Ceriani B1 | ITA | 55 | 00:15:08 | 00:02:59 | 00:38:47 | [NAME] | 00:27:32 | 3 | 01:26:13
7071 | 40957 | Iain | Dawson | GBR | 54 | 00:12:00 | 00:02:26 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 878554d1725637414-need-formula-to-sum-the-number-of-times-a-specific-instance-is-called-for-over-time-countif
Sheet: Sheet1

Date1 | Date2 | Date3 |  |  | TOC | total
1 | 2 | 3 |  |  | 1
5 | 4 | 4 |  |  | 2
7 | 6 | 5 |  |  | 3
8 | 8 | 9 |  |  | 4
9 | 9 | 11 |  |  | 5
11 | 15 | 14 |  |  | 6
 |  |  |  |  | 7
 |  |  |  |  | 8
 |  |  |  |  | 9
 |  |  |  |  | 10
 |  |  |  |  | 11
 |  |  |  |  | 12
 |  |  |  |  | 13
 |  |  |  |  | 14
 |  |  |  |  | 15
Spreadsheet: 42543d1241086673-dual-condition-lookup-over-20000-rows-copy-of-ph4-sample
Sheet: Sheet1

Part Number | Location | Quantity
12345 | PH4 | 100
12345 | PH4 | 0
12345 | PH4 | 27
12345 | PH5 | 71
54321 | OUT | 135
54321 | OUT | 15
54321 | PH4 | 82
54321 | PH4 | 54
54231 | PH5 | 156
54321 | PH5 | 68
54321 | PH5 | 24
67890 | PH4 | 54
67890 | PH4 | 0
67890 | PH5 | 87
Spreadsheet: 547141d1510352411-calculate-loan-interest-paid-declining-balance-and-months-to-payoff-loan
Sheet: Sheet1

Principle | 7453
Int Rate | 0.0525
Payment | 51.8
Term
Month | Balance | Payment | Principle | Interest | Adj Balance
1 | 7453
2
3
4
5
6
7
8
9
10
11
12
Spreadsheet: 267403d1380065646-array-formula-question-division-of-payment
Sheet: Sheet1

 | Primary | % of payment allocated | Secondary | % of payment allocated | Monthly payment
 | GL code | primary code | GL code | secondary code | Jan | Feb | Mar | Apr
 | 123 | 0.25 | 456 | 0.75 | 12 | 55 | 65 | 85
 | 123 | 1 |  |  | 445 | 10 | 588 | 1
 | 123 | 1 |  |  | 654 | 5 | 4 | 98
 | 456 | 1 |  |  | 890 | 47 | 78 | 32
 | 456 | 0.4 | 123 | 0.6 | 45 | 78 | 65 | 54
 | 456 | 0.5 | 123 | 0.5 | 12 | 54 | 880 | 14
 |  |  |  | Total for month:
 |  |  |  | Total for codes:
 |  |  |  | 123
 |  |  |  | 456
Spreadsheet: 798172d1664351210-separate-text-of-8-elements-into-different-cells-sample
Sheet: Tabelle1

 |  | Sample of inputs:
 | 1 | 7228R Scheinwerf.kpl. re 1029 textA MIR 1 K4 30
 | 2 | 9472L Scheinwerf.kpl. [NAME] 3124 textB, textC HM 2 X4 20 |  |  |  |  | red elements: only elements that i really need
 | 3 | 2839L Scheinwerf.kpl. [NAME] 3015 textD M 1 T2 10
 |  | How i want them to be separated:
 | 1 | 7228R | Scheinwerf.kpl. re | 1029 | textA | MIR | 1 | K4 | 30
 | 2 | 9472L | Scheinwerf.kpl. [NAME] | 3124 | textB, textC | HM | 2 | X4 | 20
 | 3 | 2839L | Scheinwerf.kpl. [NAME] | 3015 | textD | M | 1 | T2 | 10
 |  | =TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(" "& $C4,". ","."),", ",",")," ",REPT(" ",100)),COLUMNS($A:A)*100,100))
 |  | =TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(" "& $C4:$C6,". ","."),", ",",")," ",REPT(" ",100)),COLUMN(A:A)*100,100))
 |  | 9472L | Scheinwerf.kpl.li | 3124 | textB,textC | HM | 2 | X4 | 20
 |  | 2839L | Scheinwerf.kpl.li | 3015 | textD | M | 1 | T2 | 10
Spreadsheet: 158166d1338025602-finding-out-the-pair-of-points-location-with-minimum-distances-closest_points
Sheet: Sheet1

Pt# | X | y | Nearest Pt#
1 | 4 | 1 | 5 |  |  | 2.23606797749979 | 7.615773105863909 | 3.605551275463989 | 1 | 5.830951894845301 | 4.242640687119285
2 | 5 | 3 | 5 |  | 2.23606797749979 |  | 5.385164807134504 | 3.16227766016838 | 2 | 5 | 2.23606797749979
3 | 7 | 8 | 7 |  | 7.615773105863909 | 5.385164807134504 |  | 6.403124237432849 | 7.280109889280518 | 6.324555320336759 | 4
4 | 2 | 4 | 6 |  | 3.605551275463989 | 3.16227766016838 | 6.403124237432849 |  | 4.242640687119285 | 2.23606797749979 | 5
5 | 5 | 1 | 1 |  | 1 | 2 | 7.280109889280518 | 4.242640687119285 |  | 6.403124237432849 | 3.605551275463989
6 | 1 | 6 | 4 |  | 5.830951894845301 | 5 | 6.324555320336759 | 2.23606797749979 | 6.403124237432849 |  | 6.324555320336759
7 | 7 | 4 | 2 |  | 4.242640687119285 | 2.23606797749979 | 4 | 5 | 3.605551275463989 | 6.324555320336759
Spreadsheet: 34586d1231894795-overdue-late-completion-completed-tasks-book1
Sheet: Sheet1

Eurpoean date styles
Today | 2009-01-15 00:00:00
Task | Date due | Date completed |  | Perfromacne rated
Task 1 | 2009-01-12 00:00:00 | 2009-01-12 00:00:00 |  | OK,  complete
Task 2 | 2009-01-12 00:00:00 | 2009-01-13 00:00:00 |  | Late, compete
Task 3 | 2009-01-12 00:00:00 |  |  | Overdue, not complete
Task 4 | 2009-01-15 00:00:00 | 2009-01-10 00:00:00 |  | OK,  complete
Task 5 | 2009-01-16 00:00:00 |  |  | OK, Open
Task 6 | 2009-01-12 00:00:00 | 2009-01-15 00:00:00 |  | Late, complete
Task 7 | 2009-01-19 00:00:00 |  |  | OK, Open
As at 15/01/09
Total Completed | ?
Open and Late | ?
Completed Late | ?
Open but OK | ?
Without using a helper column (E), is it possible to populate cells B13:B16?
Spreadsheet: 1e4542ee-c066-4ad1-bfd1-21916e624271
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
4082 | 20867 | [NAME] | Schloss | USA | 0 | 00:14:45 | 00:01:02 | 00:27:29 | 00:02:00 | 00:17:20 | 1 | 01:02:36
4082 | 8093 | [NAME] | [NAME] | USA | 0 | 00:15:17 | 00:01:04 | 00:28:46 | 00:01:52 | 00:18:00 | 2 | 01:04:59
4082 | 25207 | [NAME] | Cuellar | MEX | 0 | 00:15:27 | 00:01:14 | 00:36:13 | 00:02:18 | 00:17:57 | 3 | 01:13:09
Spreadsheet: 706002d1606404979-finding-reference-cells-from-a-range-project-13058
Sheet: OTHER COSTS

[NAME] | PRICE | QUANTITY | TOTAL QUANTITY | NOTE
SCZZ003 TRASPORTO SHANGHAI DIANBA | 2628.96 | 1 |  | FOR VENTANA SERRA SPA
SCZZ003 TRASPORTO VIA AEREA | 1500 | 1 |  | FOR YASKAWA ITALIA SRL
TRASPORTO -DHL EXPRESS | 1 | 15
TOTAL PRICE FOR TRANSPORTATION
COMMISSION OF INFRADIAMBA |  |  | 17640
LABOR COST | 35 | 471.83
EXTRAS
70,0243.51 COPERCHIO | 22 | 1 |  | PUOZZO OFFICINA MECCANICA
70.0403.124 FORI SPAZZOLA | 0.84 | 113 |  | PUOZZO OFFICINA MECCANICA
TOTAL PRICE FOR [NAME]
TOTAL [NAME]
Spreadsheet: 81101d1281370662-return-event-based-on-date-example
Sheet: Sheet1

Event | Start Date | End Date | Location
Action 1 | 2010-10-01 00:00:00 | 2010-10-04 00:00:00 | North | South | East | West
Action 2 | 2010-10-02 00:00:00 | 2010-10-04 00:00:00 | North | South | East
Action 3 | 2010-10-05 00:00:00 | 2010-10-05 00:00:00 | South | West | East
Function | 2010-10-06 00:00:00 | 2010-10-20 00:00:00 | North | South
Clean-up | 2010-10-21 00:00:00 | 2010-10-22 00:00:00 | North | East
Transport | 2010-10-22 00:00:00 | 2010-10-22 00:00:00 | East | South
Transition | 2010-10-23 00:00:00 | 2010-10-24 00:00:00 | North | West
Storage | 2010-10-25 00:00:00 | 2010-11-01 00:00:00 | West | East | North
Enter Date | 2010-10-03 00:00:00
Event | Location
Action 1 | North | South | East | West
[NAME] | North | South | East
Spreadsheet: 790320d1659639557-remove-characters-from-a-cell-based-on-values-in-another-sheet-sample_a
Sheet: Computers

Name |  | Desired Result | Primary Removals | Optional Removals
3A0100-01mac26 |  | 3A0100-01
3A0115-01 |  | 3A0115-01
3A0116-01 |  | 3A0116-01
3A1100-SR |  | 3A1100-SR
3E2105A-01 |  | 3E2105A-01
3E2107A-INS |  | 3E2107A-INS
3E3120-ACDC1 |  | 3E3120
3E3120-MOBILE1 |  | 3E3120
3E3126-01 |  | 3E3126-01
3E3126-02 |  | 3E3126-02
3E3126-LT07 |  | 3E3126
3E3126-PLC09 |  | 3E3126
6A214-LTRACK1 |  | 6A214
6A215-01 |  | 6A215-01
CT250-STAFF01 |  | CT250
DS-3G3174-01 |  | DS-3G3174-01
XCH246-01 |  | XCH246-01
WIN10AUL-002 |  | WIN10AUL-002
6A318mac01 |  | 6A318
6A318mac03 |  | 6A318
6A318mac05 |  | 6A318
CH253macbook01 |  | CH253
[NAME]
Optional Removals
Name |  | Desired Result
DS-3G3174-01 |  | 3G3174-01
XCH246-01 |  | CH246-01
Spreadsheet: 183424d1348827670-super-tricky-lookup-problem-attempt-1-
Sheet: Sheet1

Ad Name | My attempt | Desired Output | My Try
xxxxBSE_01_4TH_CA_AND_HS_WIN_FishFoodies_0yyy |  | BSE_01_4TH_CA_AND_HS_WIN_FishFoodies_0
fdsgdfsgBSE_01_ADF_CA_AND_v2.2_WIN_FishFoodies_0dfgd |  | BSE_01_ADF_CA_AND_v2.2_WIN_FishFoodies_0
BSE_01_GOO_CA_AND_v2.2_WIN_FishFoodies_0333332 |  | BSE_01_GOO_CA_AND_v2.2_WIN_FishFoodies_0
LOOKUP TABLE
BSE_01_4TH_CA_AND_HS_WIN_FishFoodies_0
BSE_01_ADF_CA_AND_v2.2_WIN_FishFoodies_0
BSE_01_GOO_CA_AND_v2.2_WIN_FishFoodies_0
Spreadsheet: darrell_schoolcraft__7297__imball0112
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 | 262214 | 273995
500232 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500238 |  | 268727 |  |  |  |  |  |  |  |  | lunch | 7.6
500239 | 301638 | 292058 |  | 2001-11-03 00:00:00
500293 |  | 162120
500302 |  | 2152
500303 |  | 88713
500305 | 466709 | 350454
500307 |  | 17024
500313 |  | 808
500314
500655
500657 |  | 44197
INDEX
2001-11-30 00:00:00 |  |  | 75814.32
2001-12-08 00:00:00
CBS Volume
 |  |  | 50255
Spreadsheet: 329659d1404378732-collate-data-problem-solving-sample-work-book
Sheet: Tab 5

 |  |  |  |  |  |  |  | Price [NAME]
 | Labour | Grade | Cost | Personnel | Days | Hr/Day
 | Travel and Subsistence | Basis
 | Materials and Subcontract | Basis | Cost
 | Pricing
 | Total labour
 | Total T&S
 | Total materials
Spreadsheet: cbc9c50c-1671-4185-83d6-d2a5aa23f1ca
Sheet: CC

CHANGE IN CAPITAL STATEMENT
 |  | for the period from |  | 2011-01-01 00:00:00 | to | 2011-03-31 00:00:00
Item |  |  |  |  |  |  |  | EDP | Previous period | Current period
1 |  |  |  |  |  |  |  | 2 | 3 | 4
1. Subscribed capital |  |  |  |  |  |  |  | 1 | 28200700 | 28200700
2. Capital reserves |  |  |  |  |  |  |  | 2 | 194354000 | 194354000
3. Profit reserves |  |  |  |  |  |  |  | 3
4. Retained profit or loss carried forward |  |  |  |  |  |  |  | 4 | -553595946 | -619250046
5. Profit or loss of the current year |  |  |  |  |  |  |  | 5 | -65654100 | -14554790
6. Revaluation of fixed tangible assets |  |  |  |  |  |  |  | 6
7. Revaluation of intangible assets |  |  |  |  |  |  |  | 7
8. Revaluation of financial  property available for sale |  |  |  |  |  |  |  | 8
9. Other revaluation |  |  |  |  |  |  |  | 9
10. Total capital and reserves (EDP 001 through 009) |  |  |  |  |  |  |  | 10
11. Foreign exchange differences from net investments in foreign operations |  |  |  |  |  |  |  | 11
12. Current and deferred taxes (part) |  |  |  |  |  |  |  | 12
13. Cash flow protection |  |  |  |  |  |  |  | 13
14. Changes in accounting policies |  |  |  |  |  |  |  | 14
15. Correction of significant mistakes from the previous period |  |  |  |  |  |  |  | 15
16. Other equity changes |  |  |  |  |  |  |  | 16
17. Total increase or decrease of capital (EDP  011 through  016) |  |  |  |  |  |  |  | 17
17 a. Assigned to holders of parent company's capital |  |  |  |  |  |  |  | 18
17 b. Assigned to minority interest |  |  |  |  |  |  |  | 19
Items that reduce capital entered with a negative sign Data under EDP codes 001-009 to be input balance sheet as at date
Spreadsheet: 99223d1297937903-cell-insertion-in-paste-special-index
Sheet: Sheet1

 |  | ID Number | WOC Number | Location and Description
 | R8 |  | .xls
 | 21071.xls | 21071 | 2223334 | SEFH ETH STH
 | 4646.xls | 4646 | #N/A | #N/A
 | 32434.xls | 32434 | #N/A | #N/A
 | 568567.xls | 568567 | #N/A | #N/A
 | 5456.xls | 5456 | #N/A | #N/A
Spreadsheet: 199842ba-39ce-43bb-8feb-511af7a46f1d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | US Defensive Fund
 | Monthly Performance History
 | Inception Date | 2012-07-09 00:00:00
 |  | Class I | Class N | Russell 1000
 | Date | AUEIX | AUENX | Index
* | 2012-07-31 00:00:00 | 0.008000000000000007 | 0.008000000000000007 | 0.01762653187170171
 | 2012-08-31 00:00:00 | 0.005952380952380931 | 0.004960317460317443 | 0.02428149135217317
 | 2012-09-30 00:00:00 | 0.0177514792899407 | 0.01776900296150052 | 0.02572240785636382
 | 2012-10-31 00:00:00 | -0.01453488372093026 | -0.01454898157129003 | -0.01688263308870652
 | 2012-11-30 00:00:00 | 0.008849557522123908 | 0.009842519685039353 | 0.007944537508500105
 | 2012-12-31 00:00:00 | -0.002501283252926423 | -0.004026875333574154 | 0.01037066665316533
 | 2013-01-31 00:00:00 | 0.0531496062992125 | 0.05309734513274345 | 0.05423379650857152
 | 2013-02-28 00:00:00 | 0.02429906542056104 | 0.0242763772175536 | 0.0134352092795873
 | 2013-03-31 00:00:00 | 0.04197080291970789 | 0.0419325432999087 | 0.03860552126564576
 | 2013-04-30 00:00:00 | 0.02014010507880926 | 0.02012248468941391 | 0.01805859441151569
 | 2013-05-31 00:00:00 | 0.004291845 | 0.003430532 | 0.02224397
 | 2013-06-30 00:00:00 | -0.001709401709401592 | -0.0008547008547008517 | -0.01362827968381131
 | 2013-07-31 00:00:00 | 0.04880136986301364 | 0.04875962360992303 | 0.05350791407164568
 | 2013-08-31 00:00:00 | -0.03428571428571414 | -0.03507340946166393 | -0.02758241840840636
 | 2013-09-30 00:00:00 | 0.0312764159 | 0.0304311074 | 0.03486933
 | 2013-10-31 00:00:00 | 0.0450819672 | 0.04511895 | 0.044019845
 | 2013-11-30 00:00:00 | 0.0235294117647058 | 0.02354788069073765 | 0.02805706685098341
 | 2013-12-31 00:00:00 | 0.014287108 | 0.014757763 | 0.026977807
 | 2014-01-31 00:00:00 | -0.02593440122044244 | -0.02667682926829262 | -0.0319385965192972
 | 2014-02-28 00:00:00 | 0.04620203602193 | 0.04620203602193 | 0.04746582917621
 | 2014-03-31 00:00:00 | 0.004491017964 | 0.004491017964 | 0.0063694752
 | * partial month return, inception date 7/9/2012
 | US Defensive Fund
 | [NAME]
 | Month-end Returns as of | Class I | Class N | Russell 1000
 | March 31, 2014 | AUEIX | AUENX | Index
 | 1 Year | 0.1864655623307356 | 0.184165555464638 | 0.2241406693861232
 | 3 Years
 | 5 Years
 | 10 Years
 | Since Inception Cumulative Return | 0.3648572767684286 | 0.3599805027120109 | 0.4540361353273812
 | Since Inception Annualized Return | 0.1974705165419641 | 0.1949897303485777 | 0.2421967636851112
 | Since Inception Annualized Monthly Volatility | 0.08349127332636208 | 0.08407109108996913 | 0.08566119848434779
 | Quarter-end Returns as of | Class I | Class N | Russell 1000
 | March 31, 2014 | AUEIX | AUENX | Index
 | 1 Year | 0.1864655623307356 | 0.184165555464638 | 0.2241406693861232
 | 3 Years
 | 5 Years
 | 10 Years
 | Since Inception Cumulative Return | 0.3648572767684286 | 0.3599805027120109 | 0.4540361353273812
 | Since Inception Annualized Return | 0.1974705165419641 | 0.1949897303485777 | 0.2421967636851112
Spreadsheet: 796552d1663345065-combining-two-formulas-sample-vacation-hrs
Sheet: SAMPLE

Accrued Vacation | Used Vacation | Total Vacation | Reason | 6.5 hr - 1-10 yr 10 hr - after 10 yr
 |  |  |  | Max 160
Vacation |  |  |  | 3 days, 6:00:00
 | 1 day, 13:45:00 | 7/17-7/20
6:30:00 | 8:30:00 | 8/1
10:00:00 | 12:15:00 | 9/1 & 9/5
10:00:00 | 8:41:00 | 10/11 & 11M (10/20)
10:00:00 | 8:41:00 | 11/5 & 11M (11/17)
 | 3:45:00 | 12/1
 | 0:11:00 | 2/16
 | 8:48:00 | 8M (3/9), 10M (3/12) & 8H30M (3/29)
 | 1 day, 5:15:00 | 4/3-4/6
 | 9:34:00 | 4M (5/4) & 9H30M (5/29)
 | 1 day, 6:15:00 | 19H (6/4-6/5), 5H30M (6/6) & 5H45M (6/7)
Spreadsheet: 862907d1710480374-stockhistory-source-data-aud-vs-usd
Sheet: AUD-USD

 | #[NAME]! |  |  |  |  | Start | 2024-02-26 00:00:00
 |  |  |  |  |  | End | 2024-03-15 00:00:00
 |  |  |  | https://www.federalreserve.gov/releases/h10/hist/dat00_al.htm
Spreadsheet: 723213d1615561055-search-or-index-formula-needed-testalles-2-
Sheet: Blad1

project | wie NL | wie D | inkoop NL | inkoop D | verkoop NL | verkoop D
 |  |  |  |  |  |  |  | uren inkoop |  |  | km inkoop
 |  |  |  |  |  |  |  | [NAME] |  |  | km verkoop
 |  |  |  |  |  |  |  | [NAME] |  |  | [NAME]
5129 | ik | nl | 4 | 256 | 4.5 | 271
5129 | ernst | nl | 4.5 | 261 | 5 | 270 |  | Inkoop NL |  |  | Inkoop D
5129 | willem | nl | 4 | 264 | 4.5 | 269 |  | [NAME] |  |  | Verkoop D
5130 | jan | ics | 3 | 290 | 3.5 | 293 |  | [NAME] |  |  | Verschil D
5130 | klaas | ics | 3.5 | 289 | 4 | 292
5131 | willem | nl | 7 | 600 | 7.5 | 620 |  |  | Totaal inkoop
5132 | b | v | 3 | 250 | 6 | 260 |  |  | Totaal verkoop
5132 | b | v | 3 | 250 | 6 | 260 |  |  | totaal [NAME]
5132 | b | v | 3 | 250 | 6 | 260
5132 | b | v | 3 | 250 | 6 | 260 |  | search code | count cell B and C | inkoop NL | inkoop D | verkoop NL | verkoop D
5132 | b | v | 3 | 250 | 6 | 260 |  | 5129
5132 | b | v | 3 | 250 | 6 | 260
5132 | b | v | 33 | 250 | 6 | 260
5133 | b | v | 3 | 250 | 6 | 260
5133 | b | v | 3 | 250 | 6 | 260
5134 | bb | v | 3 | 250 | 6 | 260
5134 | b | v | 3 | 250 | 6 | 260
5134 | b | v | 3 | 250 | 6 | 260
Spreadsheet: 139154d1328107541-excel-2007-getting-data-from-other-worksheets-2011-stats
Sheet: Drivers

[NAME] | Red Bull Racing | GER
[NAME] | [NAME] | GBR
[NAME] | Red Bull Racing | AUS
[NAME] | Ferrari | ESP
[NAME] | [NAME] | GBR
[NAME] | Ferrari | BRA
[NAME] | Mercedes | GER
[NAME] | Mercedes | GER
[NAME] | Force India | GER
[NAME] | Lotus-Renault GP | RUS
[NAME] | Lotus-Renault GP | GER
[NAME] | [NAME] | JAP
[NAME] | Force India | GBR
[NAME] | Toro Rosso | ESP
Sebastien Buemi | Toro Rosso | SUI
[NAME] | [NAME] | MEX
[NAME] | [NAME] | BRA
[NAME] | Lotus-Renault GP | BRA
Pastor Maldonado | [NAME] | VEZ
[NAME] | [NAME] | ESP
Jarno [NAME] | Team Lotus | ITA
[NAME] | Team Lotus | FIN
[NAME] | Hispania | ITA
[NAME] | [NAME] | BEL
[NAME] | [NAME] | GER
Narain Karthikeyan | Hispania | IND
[NAME] | Hispania | AUS
Karun Chandhok | Team Lotus | IND
Spreadsheet: 153787d1336054093-search-value-and-return-a-set-of-values-in-the-row-weatherdata_sample
Sheet: InsertIntoTable

BROWNSVILLE |  | TX
Average Solar Radiation based on NREL Data
kWh/m^2/day | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Mount0
Mount1
Mount2
Mount3
Mount5
Mount6
Mount7
Mount8
Mount9
Spreadsheet: 825927d1681649980-convert-from-a-vertical-list-to-a-horizontal-list-cant-use-transpose-final-version
Sheet: Sheet2

 | Last Name | First Name | [NAME] | Course
12345 | Smith | [NAME] | [EMAIL] | Test Course 1 | Test Course 2 | Test Course 3 | Test Course 4 | Test Course 5 | Test Course 6 | Test Course 7
32423 | Thomson | [NAME] | [EMAIL] | Test Course 8 | Test Course 9 | Test Course 10 | Test Course 11 | Test Course 12 | Test Course 13
Spreadsheet: 789892d1659357157-getting-date-and-time-from-different-date-notations-within-strings-different-date-time-formats
Sheet: Before

Header 1 | [NAME] |  | Nick
2017-04-19 22:50:14:380 | 2017-04-19 22:50:14.000
2017-04-19 22:50:19:419 | 2017-04-19 22:50:19.000
2017-04-19 22:50:19:421 | 2017-04-19 22:50:19.000
2017-04-19 22:50:19:430 | 2017-04-19 22:50:19.000
2017-04-19 22:50:53:074 | 2017-04-19 22:50:53.000
2017-04-19 22:50:53:199 | 2017-04-19 22:50:53.000
2017-04-19 22:50:53:210 | 2017-04-19 22:50:53.000
2017-04-29 16:17:59:505 | 2017-04-29 16:17:59.000
2017-04-29 16:18:01:476 | 2017-04-29 16:18:01.000
2017-04-29 16:18:01:488 | 2017-04-29 16:18:01.000
03/Aug/2018:09:02:21 | 2018-08-03 09:02:21.000
03/Aug/2018:09:07:03 | 2018-08-03 09:07:03.000
10-12-2019 02:22:09:065
10-12-2019 02:22:09:612
10-12-2019 02:22:09:620
10-12-2019 02:22:13:578
10-12-2019 02:22:14:287
10-12-2019 02:22:14:555
10-12-2019 02:22:14:562
10-12-2019 02:22:38:234
10-12-2019 02:22:38:242
10-12-2019 02:22:49:318
10-12-2019 02:22:49:327
10-12-2019 02:22:49:396
10-12-2019 02:22:49:396
10-12-2019 02:22:49:407
Spreadsheet: 3c1d7c40-150d-42ea-9a43-a9e9123011e5
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
PBHA | Test | PBHA | Lead, Hair | Lead, Hair | Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) | Varies: Var |  |  | 0.5 | g | Container/Tube: Hair and Nails Collection Kit (Supply T565) [NAME]: 0.500 g Collection Instructions: 1. Prepare and transport specimen per the instructions in the kit or see [NAME] and Nails Instruction Sheet for Metals Testing in Special Instructions. 2. At least 0.500 g of hair. Typically, this is a sample of hair comprised of strands 1 cm long and enough strands to be 0.5 cm in diameter when gathered together. Additional Information: If known, indicate source of hair (axillary, head, or pubic). | 0.1 g | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 0.0-3.9 mcg/g of hair Reference values apply to all ages. | Tuesday, Friday; 5 p.m. | 2 days | 7 days | 1 | 83655 |  |  |  |  | Rochester
PBHA | [NAME] | HAIR | Hair |  |  |  | Ambient
PBHA | Order Question | PBHSC | [NAME] |  | Answer List
PBHA | Option | PBHSC-1 | Head
PBHA | Option | PBHSC-2 | Pubic
PBHA | Option | PBHSC-3 | Axillary
PBHA | Result | 31898 | Lead, Hair | Lead, Hair | Numeric |  |  |  |  | mcg/g |  |  |  |  |  |  |  |  |  | 5673-9
PBHA | Result | PBHSC | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2
Spreadsheet: barry_tycholiz__856__Q3SoftTargets
Sheet: summary

Enron North America
Third Quarter 2001 Soft Targets
 |  |  | Market Transactions |  |  |  | EOL Transactions |  |  |  | New EOL Customers
 |  |  | Actual | Target | Fav/(Unfav) |  | Actual | Target | Fav/(Unfav) |  | Actual | Target | Fav/(Unfav)
Canada
 | Gas |  | 170 | 180 |  |  | 788 | 660 |  |  | 3 | 5
 | Eastern Power |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0
 | Alberta Power |  | 9 | 20 |  |  | 45 | 27 |  |  | 1 | 8
U.S. Natural Gas
 | Central |  | 186 | 0 |  |  | 2628 | 3873 |  |  | 3 | 3
 | East |  | 543 | 38 |  |  | 2754 | 1950 |  |  | 9 | 5
 | West |  | 152 | 38 |  |  | 1484 | 1320 |  |  | 2 | 4
 | Texas |  | 1 | 31 |  |  | 365 | 240 |  |  | 0 | 6
 | Derivatives |  | 986 | 400 |  |  | 0 | 0 |  |  | 0 | 0
 | Financial |  | 0 | 0 |  |  | 2176 | 3408 |  |  | 4 | 0
East Power Trading
 | ERCOT |  | 5 | 13 |  |  | 0 | 60 |  |  | 0 | 6
 | Southeast |  | 7 | 25 |  |  | 396 | 300 |  |  | 2 | 3
 | Midwest |  | 23 | 50 |  |  | 548 | 390 |  |  | 2 | 6
 | Northeast |  | 15 | 38 |  |  | 979 | 750 |  |  | 7 | 10
West Power |  |  | 26 | 125 |  |  | 1143 | 300 |  |  | 4 | 5
Gas Assets |  |  | 2 | 0 |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
HPL- Transport |  |  | 0 | 0 |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
Asset Marketing |  |  | 0
Energy Capital Resources |  |  | 1 | 0 |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
Mexico |  |  | 38 | 0 |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | Total