tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 152450d1335385022-reorganize-data-for-better-analysis-forumsample
Sheet: Sheet1

Case # Date Disposed | Defendant Name  & Disposition | Offense | Fines & Cost
10-10592 | [NAME]
2011-01-03 00:00:00 | [NAME] | No Operators License
 |  |  | 172.5
10-10881 | [NAME]
2011-01-03 00:00:00 | [NAME] | Stealing.
 |  |  | 127.5
10-10944 | CLOSED CHAPTER 610
2011-01-03 00:00:00 | Nolle Prosse | Proof of Insurance-Fail to Provide
 |  |  | 0
10-11184 | [NAME]
2011-01-03 00:00:00 | Guilty - TVB | Stop and yield signs.
 |  |  | 125
10-11269 | CODY L DAILEY
2011-01-03 00:00:00 | [NAME] | Certificate of compliance required; display.
2011-01-03 00:00:00 | [NAME] | Certificate of compliance required; display.
2011-01-03 00:00:00 | [NAME] | Certificate of compliance required; display.
2011-01-03 00:00:00 | [NAME] | Certificate of compliance required; display.
2011-01-03 00:00:00 | [NAME] | Certificate of compliance required; display.
2011-01-03 00:00:00 | [NAME] | Certificate of compliance required; display.
2011-01-03 00:00:00 | [NAME] | Certificate of compliance required; display.
2011-01-03 00:00:00 | [NAME] | Certificate of compliance required; display.
2011-01-03 00:00:00 | [NAME] | Certificate of compliance required; display.
2011-01-03 00:00:00 | [NAME] | Certificate of compliance required; display.
2011-01-03 00:00:00 | Nolle Prosse | Certificate of compliance required; display.
2011-01-03 00:00:00 | Nolle Prosse | Certificate of compliance required; display.
2011-01-03 00:00:00 | Nolle Prosse | Certificate of compliance required; display.
2011-01-03 00:00:00 | Nolle Prosse | Certificate of compliance required; display.
2011-01-03 00:00:00 | Nolle Prosse | Certificate of compliance required; display.
2011-01-03 00:00:00 | Nolle Prosse | Certificate of compliance required; display.
 |  |  | 840
10-11273 | MEGAN E HARRIS
2011-01-03 00:00:00 | [NAME] | Trespass in the second degree.
 |  |  | 150
10-11290 | HANNAH E SMITH
2011-01-03 00:00:00 | [NAME] | Trespass in the second degree.
 |  |  | 150
10-11416 | BRANDY MICHELLE BURKS
2011-01-03 00:00:00 | [NAME] | Stealing.
 |  |  | 127.5
10-11478 | TY-IHONN C RILEY
2011-01-03 00:00:00 | [NAME] | Peace disturbance--Generally.
 |  |  | 100
10-11522 | CLOSED CHAPTER 610
2011-01-03 00:00:00 | Nolle Prosse | Possession of official traffic control devices or railroad signs or signals.
 |  |  | 0
10-11639 | CHAD RICHARD DAVIS
2011-01-03 00:00:00 | [NAME] | Trespass in the second degree.
 |  |  | 220
10-12111 | CLOSED CHAPTER 610
2011-01-03 00:00:00 | Nolle Prosse | [NAME]
2011-01-03 00:00:00 | Nolle Prosse | Seat Belt Violation
 |  |  | 0
Spreadsheet: e14b31d8-3fbf-4fb3-ae20-0cc26834e38c
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Merch | 9781595552686 | Diamond Rio | (See Upc [PHONE]) [NAME], A | 2009-09-04 | Printed Books | Na | 26.99 | Y | To Be Retired
Spreadsheet: 787014d1657604925-linking-two-excel-tables-mappe4-ans3
Sheet: Tabelle1

Table 1 |  |  |  |  |  |  | Table 2
City |  | Number1 | Number2 | Number3 |  |  | Should be |  |  | Number3 | Enter Number in K2
Toronto | Year 1 | 232453 | 34567 | 4542323 |  |  |  |  | City | Year 3 | Enter city in K3
 | Year 2 | 343432 | 2323211 | 1221324 |  | Toronto | 1221324 |  |  |  | Subjected to condition that each city must have the year in the K3 cell
 | Year 3 | 5334211 | 456622 | 9899472 |  | Miami | 1232321
Miami | Year 1 | 89393939 | 2323112 | 2323111 |  | Montreal | 23131
 | Year 2 | 232321 | 2323231 | 1232321 |  | Boston | 232111
 | Year 3 | 232311 | 232311 | 132321 |  | [NAME] | 132312312
Montral | Year 1 | 123131 | 132321 | 2312312 |  | London | 434322
 | Year 2 | 1231231 | 1323131 | 23131
 | Year 3 | 132311 | 1323121 | 232131
Boston | Year 1 | 2323211 | 232321 | 23123122
 | Year 2 | 232311 | 323232 | 232111
 | Year 3 | 2323211 | 2323131 | 232131
[NAME] | Year 1 | 12312312 | 1231231 | 3123131
 | Year 2 | 3132222 | 231311 | 132312312
 | Year 3 | 3123121 | 2313222 | 3231444
London | Year 1 | 44423213 | 1231244 | 5454545
 | Year 2 | 213412312 | 4241312 | 434322
 | Year 3 | 321312 | 1231231 | 123123444
Spreadsheet: 47083e28-26b3-41bf-b218-7d4a03d6bb0b
Sheet: Sheet1

Tissues | Time series | q-value(JTK_CYCLE) | q-value(HAYSTACK) | #Circadian genes
WT mouse liver (ad libitum feeding) | Every 1 hour between CT 18 and CT 65 | q<0.001 | q<0.001 | 1888
 |  | q<0.05 | q<0.01 | 3129a
WT mouse liver (restricted feeding) | Every 1 hour between CT 24 and CT 47 under temporally restricted feeding | q<0.05 | q<0.01 | 2397a
WT mouse liver (fasting) | Every 2 hours between CT 2 and CT 10, plus between CT 36 and CT 46 under fasting | q<0.1 | q<0.05 | 554a
WT mouse pituitary | Every 1 hour between CT 18 and CT 65 | q<0.05 | q<0.01 | 353b
WT [NAME] cells | Every 1 hour between CT 20 and CT 67 | q<0.05 | q<0.01 | 46b
WT mouse adrenal gland | Every 4 hours between CT 38 and CT 82 with one replicate at each time point | q<0.1 | q<0.05 | 1348c
a: Circadian genes were mainly used for strictly defining non-circadian genes and non-liver circadian genes.
b: Circadian genes were mainly used for studying the dualistic features of murine circadian genes.
c: Circadian genes identified from JTK_CYCLE and HAYSTACK were further selected as mentioned in Materials and Methods, and were used for identifying divergently-paired circadian genes in adrenal glands.
Spreadsheet: 886259f8-d249-41ef-b2c3-b6d6514bac6e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5302.0 Balance of Payments and International Investment Position, Australia
 | TABLE 33. EXCHANGE RATES - QUARTER
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
United States Dollar ;  Period average ; |  |  | Original | A3534045L | 1959-09-01 00:00:00 | 2014-03-01 00:00:00 | 219 | $ | INDEX | Quarter | 3
United Kingdom Pound ;  Period average ; |  |  | Original | [NAME] | 1959-09-01 00:00:00 | 2014-03-01 00:00:00 | 219 | $ | INDEX | Quarter | 3
Euro ;  Period average ; |  |  | Original | A3534046R | 1959-09-01 00:00:00 | 2014-03-01 00:00:00 | 219 | $ | INDEX | Quarter | 3
[NAME] ;  Period average ; |  |  | Original | A3534042F | 1959-09-01 00:00:00 | 2014-03-01 00:00:00 | 219 | $ | INDEX | Quarter | 3
Special Drawing Rights ;  Period average ; |  |  | Original | A3534047T | 1959-09-01 00:00:00 | 2014-03-01 00:00:00 | 219 | $ | INDEX | Quarter | 3
United States Dollar ;  End of period ; |  |  | Original | A3533870V | 1959-09-01 00:00:00 | 2014-03-01 00:00:00 | 219 | $ | INDEX | Quarter | 3
United Kingdom Pound ;  End of period ; |  |  | Original | A3533869K | 1959-09-01 00:00:00 | 2014-03-01 00:00:00 | 219 | $ | INDEX | Quarter | 3
Euro ;  End of period ; |  |  | Original | A3533871W | 1959-09-01 00:00:00 | 2014-03-01 00:00:00 | 219 | $ | INDEX | Quarter | 3
[NAME] ;  End of period ; |  |  | Original | A3533867F | 1959-09-01 00:00:00 | 2014-03-01 00:00:00 | 219 | $ | INDEX | Quarter | 3
Special Drawing Rights ;  End of period ; |  |  | Original | A3533872X | 1959-09-01 00:00:00 | 2014-03-01 00:00:00 | 219 | $ | INDEX | Quarter | 3
Trade Weighted Index ;  Period average ; |  |  | Original | A3534043J | 1959-09-01 00:00:00 | 2014-03-01 00:00:00 | 219 | Index Numbers | INDEX | Quarter | 3
Trade Weighted Index ;  End of period ; |  |  | Original | A3533868J | 1959-09-01 00:00:00 | 2014-03-01 00:00:00 | 219 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2014
Spreadsheet: c26adf74-b7ab-41dd-a1fb-c8f5e097f865
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
 |  | U.S. Census Bureau
 |  | Source: Manufacturers' Shipments, Inventories, and Orders
 |  | Total Manufacturing: U.S. Total
 |  | Seasonally Adjusted Value of Shipments [Millions of Dollars]
 |  | Period: 1992 to 2013
 |  | Data Extracted on: May 22, 2013 (9:44 pm)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
1992 | 227828 | 228996 | 238626 | 239967 | 243854 | 245814 | 245328 | 242758 | 244778 | 243172 | 246823 | 248163
1993 | 247811 | 249596 | 250461 | 248715 | 252004 | 253438 | 248636 | 249078 | 252602 | 256306 | 255110 | 255979
1994 | 259912 | 261247 | 261983 | 263591 | 266722 | 268152 | 270888 | 273690 | 272839 | 276174 | 279601 | 286819
1995 | 286427 | 288548 | 284826 | 289703 | 285723 | 288559 | 287557 | 289766 | 295391 | 292579 | 291653 | 300523
1996 | 286951 | 282216 | 294410 | 295434 | 299710 | 303327 | 299895 | 301708 | 305118 | 301400 | 308668 | 307100
1997 | 306944 | 314243 | 315307 | 317890 | 315481 | 319891 | 323121 | 322356 | 323548 | 322342 | 328461 | 326215
1998 | 321231 | 329311 | 328066 | 324438 | 325437 | 319456 | 316161 | 323738 | 325659 | 327640 | 327934 | 328564
1999 | 328634 | 332122 | 328719 | 330297 | 334856 | 333782 | 334443 | 340153 | 338548 | 343156 | 343247 | 344376
2000 | 352080 | 340138 | 349258 | 354902 | 349873 | 354799 | 351171 | 347434 | 355694 | 348767 | 346933 | 350674
2001 | 342474 | 346303 | 340222 | 330407 | 338621 | 331066 | 327584 | 330649 | 321532 | 320527 | 319696 | 322146
2002 | 320210 | 319921 | 321147 | 326689 | 328712 | 327982 | 325897 | 329880 | 330850 | 330305 | 330709 | 324433
2003 | 329389 | 333022 | 335537 | 325799 | 328431 | 332311 | 336848 | 332698 | 340183 | 340877 | 340244 | 340850
2004 | 339808 | 340028 | 352980 | 350819 | 352770 | 356357 | 356223 | 362024 | 363589 | 369755 | 373243 | 375655
2005 | 382013 | 382807 | 383855 | 390937 | 388203 | 391168 | 389346 | 400060 | 404738 | 406590 | 408612 | 413984
2006 | 415368 | 414806 | 416993 | 412083 | 423176 | 422375 | 416950 | 426361 | 413359 | 411032 | 416166 | 427393
2007 | 418874 | 427918 | 433613 | 436289 | 444035 | 442994 | 445883 | 447733 | 446468 | 453197 | 463550 | 460258
2008 | 466808 | 462772 | 460152 | 474797 | 476301 | 483326 | 487114 | 471548 | 453748 | 431223 | 399561 | 380029
2009 | 366106 | 368542 | 357984 | 353510 | 353385 | 362350 | 363563 | 369376 | 375257 | 378656 | 384922 | 389942
2010 | 393487 | 392368 | 400225 | 404564 | 402668 | 401947 | 410189 | 412315 | 416524 | 417900 | 423677 | 432464
2011 | 440049 | 441053 | 457331 | 455758 | 455632 | 458333 | 464174 | 466076 | 463638 | 465411 | 467060 | 469881
2012 | 473046 | 473877 | 477673 | 475592 | 477594 | 466816 | 475210 | 476102 | 481499 | 481887 | 482241 | 482478
2013 | 483044 | 489470 | 483001
Spreadsheet: 145799d1331746147-formatting-time-workbook2
Sheet: Sheet1

Hour | Min | Sec |  | Formatted
 | 1 | 2
 | 2 | 18
 | 3 | 45
 | na | na
 | 8 | 1
 | 8 | 11
 | 11 | 12
 | 12 | 15
Spreadsheet: 160327d1339053646-lookups-in-excel-2007-book1
Sheet: Sheet1

draft | [NAME] | 2011-12-01 00:00:00 | Book 1 in Law
draft | [NAME] | 2011-12-01 00:00:00 | Book 2 in Law
to be drafted | Sandra | 2011-12-01 00:00:00 | Autobiography
no | [NAME] | 2011-11-01 00:00:00 | Sample 1
no | [NAME] | 2011-11-01 00:00:00 | Sample 2
Note: if A:A contains the word "draft", I would like to pull the contents of B, C and D into sheet 2?
Spreadsheet: 732449d1620966029-formula-that-sums-the-2-far-left-numbers-in-a-given-range-than-the-2nd-most-left-and-so-on-stock-short-term-comparison-4
Sheet: Sheet1

patt analysis 1 |  |  |  |  |  |  |  |  |  |  |  |  | patt analysis 2 |  |  |  |  |  |  |  |  |  |  |  |  | resulting analysis
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
1 |  | -1 | -1 | 0 |  | -1 | 0 |  |  |  |  |  |  | -1 | 1 | 1 |  | 0 | 1 | -1 |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
0 |  |  | 1 | 0 |  | -1 |  |  |  |  |  |  |  | 0 |  |  | -1 | 0 |  | 1 | -1 |  |  |  |  | 0 | 0 | 0 | 0 | -1
0 |  | 0 |  | 0 | -1 |  |  |  |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 1 | -1 |  |  |  | 0 | 0 | 0 | 0 | -1
1 | 1 |  | -1 |  |  |  |  |  |  |  |  |  | -1 | -1 | 1 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
1 | -1 | -1 |  | 0 | 0 | 0 |  | 0 |  |  |  |  | -1 | 1 | 0 | 0 |  | 0 |  |  | 0 |  |  |  |  | 0 | 0 | -1 | 0 | 0 | 0 | 0
1 |  |  | 1 | 0 |  | -1 | 0 |  |  |  |  |  | -1 |  | -1 | 0 |  |  | 1 | -1 |  | 0 |  |  |  | 0 | 0 | 0 | 0 | -1
1 |  | 1 | 1 | -1 |  | 1 | -1 |  |  |  |  |  | -1 |  | -1 | -1 |  | 1 | -1 |  |  | 1 |  |  |  | 0 | 0 | 0 | 0 | 0
-1 | 1 | 1 |  |  | -1 |  |  |  |  |  |  |  | 1 | 1 | -1 |  | -1 |  |  |  |  |  |  |  |  | 0 | 2 | 0 | -2
1 np (quasi) |  |  |  |  |  |  |  |  |  |  |  |  | 1 np (quasi) |  |  |  |  |  |  |  |  |  |  |  |  | 1 np (quasi)
4c (or vs) |  |  |  |  |  |  |  |  |  |  |  |  | 4c (or vs) |  |  |  |  |  |  |  |  |  |  |  |  | 4c (or vs)
Spreadsheet: 386425d1427789219-index-and-match-formula-not-function-testing-6-gk
Sheet: Report A

Report Entity | Document Number | Tax Account | Reconciliation
A | 20000 | GLA | unreconcile
A |  | GLA | unreconcile
A |  | GLA | unreconcile
A |  | GLA | unreconcile
A |  | GLA | unreconcile
A |  | GLA | unreconcile
A |  | GLA
A |  | GLA | unreconcile
A |  | GLA | unreconcile
A |  | GLA | unreconcile
A |  | GLA | unreconcile
A |  | GLA | unreconcile
A |  | GLA | unreconcile
A |  | GLA | unreconcile
A |  | GLA | unreconcile
Spreadsheet: 149460d1333981495-changing-sum-if-left-formula-cf
Sheet: Summary

 |  | Balance | 2012-04-06 00:00:00 | 2012-04-13 00:00:00 | 2012-04-20 00:00:00 | 2012-04-27 00:00:00 | 2012-05-04 00:00:00 | 2012-05-11 00:00:00 | 2012-05-18 00:00:00 | 2012-05-25 00:00:00 | 2012-06-01 00:00:00 | 2012-06-08 00:00:00 | 2012-06-15 00:00:00 | 2012-06-22 00:00:00 | 2012-06-29 00:00:00
item
8
9
33 |  |  |  |  |  | Sum by date sheet "house", items that start with numbers in column A
Spreadsheet: 866793d1713713748-auto-filter-rows-to-hide-columns-with-zero-0-value-excel-forum-sample-sheet
Sheet: Pending Order List Sheet

 |  | Item | Size |  | P.O. Qty | UOM | Total  kg |  | URGENT QTY |  | P.O. by | Rate | Amount
 | . |  |  |  | . |  | .
 | PENDING ORDERS LIST as on |  |  |  |  |  |  |  | ↕
 | .
 |  |  | Size-1
 |  |  | Size-2
 |  |  | Size-3
 |  |  | Size-4
 |  |  | Size-5
 |  |  | Size-6
 |  |  | Size-7
 |  |  | Size-8
 |  |  | [NAME]
 |  |  | Size-10
 |  |  | Size-11
 |  |  | Size-12
 |  |  | Size-13
 |  |  | Size-14
 |  |  | Size-15
 |  |  | Size-16
 |  |  | Size-17
 |  |  | Size-18
 |  |  | Size-19
 |  |  | Size-20
 |  |  | Size-21
 |  |  | Size-22
 |  |  | Size-23
 |  |  | Size-24
 |  |  | Size-25
 |  |  | Size-26
 |  |  | Size-27
 |  |  | Size-28
 |  |  | Size-29
 |  |  | Size-30
 |  |  | Size-31
 |  |  | Size-32
 |  |  | Size-33
 |  |  | Size-34
 | . |  |  |  | .
 | . |  | GRAND TOTAL, kg |  |  | [NAME]
 | .
 | . |  |  |  |  |  | .
Spreadsheet: 769513d1645568544-unique-count-average-percentage-and-weekly-breakdown-member-check-ins-average-check-ins-testing
Sheet: Average Checkins per Age Group

Starting Age | Ending Age | Average Checkins
13 | 19 |  |  | IS THERE AN EASIER WAY TO DO THIS, RATHER THAN JUST DIVIDING THE TWO VALUES?
20 | 29 |  |  | IT WOULD BE THE UNIQUE NUMBER OF MEMBERS DIVIDED BY THE TOTAL NUMBER OF VISITS
30 | 39 |  |  | FOR 13-19 IT WOULD BE "2 / 9", SO 22.22%.
40 | 49 |  |  | FOR 20-29 IT WOULD BE "1 / 2", SO 50%.
50 | 59
60 | 69
70 | 79 |  |  | IS THERE A WAY TO SHOW 0, INSTEAD OF THE ERROR, IF NO CHECK INS EXIST FOR THAT AGE GROUP?
80 | 89
90 | 99999
Spreadsheet: kate_symes__18895__NP 15 pages
Sheet: DJ NP15

 |  |  | Firm | Volume | Firm | Volume | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-03-21 00:00:00 |  | 406.47 | 10320 | 234.87 | 5400
 | 2001-03-20 00:00:00 |  | 391.63 | 25920 | 261.33 | 9000
 | 2001-03-19 00:00:00 |  | 362.59 | 19760 | 274.08 | 10440
 | 2001-03-18 00:00:00 |  |  |  |  |  | 262.23 | 32520
 | 2001-03-17 00:00:00 |  | 237.03 | 39120 | 176.44 | 8200
 | 2001-03-16 00:00:00 |  | 238.66 | 44720 | 176.44 | 8200
 | 2001-03-15 00:00:00 |  | 190.53 | 14720 | 144.42 | 7600
 | 2001-03-14 00:00:00 |  | 177.21 | 17120 | 139.11 | 8840
 | 2001-03-13 00:00:00 |  | 178.33 | 18000 | 141.6 | 9400
 | 2001-03-12 00:00:00 |  | 207.12 | 14000 | 167.55 | 6200
 | 2001-03-11 00:00:00 |  |  |  |  |  | 167.57 | 18000
 | 2001-03-10 00:00:00 |  | 189.97 | 30000 | 155.94 | 17200
 | 2001-03-09 00:00:00 |  | 189.87 | 30000 | 155.94 | 17200
 | 2001-03-08 00:00:00 |  | 229.83 | 26400 | 158.24 | 4200
 | 2001-03-07 00:00:00 |  | 340.07 | 30160 | 231.96 | 15000
 | 2001-03-06 00:00:00 |  | 362.98 | 29744 | 264.17 | 13200
 | 2001-03-05 00:00:00 |  | 340.79 | 20544 | 261.21 | 8664
 | 2001-03-04 00:00:00 |  |  |  |  |  | 261.21 | 25992
 | 2001-03-03 00:00:00 |  | 271.59 | 21456 | 238.52 | 8664
 | 2001-03-02 00:00:00 |  | 271.59 | 21456 | 238.52 | 8664
 | 2001-03-01 00:00:00 |  | 282.13 | 32240 | 216.41 | 12640
 | 2001-02-28 00:00:00 |  | 210.95 | 35888 | 157.73 | 17224
 | 2001-02-27 00:00:00 |  | 212.87 | 43088 | 151.44 | 17224
 | 2001-02-26 00:00:00 |  | 213.28 | 12320 | 160.3 | 8024
 | 2001-02-25 00:00:00 |  |  |  |  |  | 160.3 | 24072
 | 2001-02-24 00:00:00 |  | 215.99 | 50624 | 158.85 | 20624
 | 2001-02-23 00:00:00 |  | 215.99 | 50624 | 158.85 | 20624
 | 2001-02-22 00:00:00 |  | 253.56 | 46656 | 179.33 | 2824
 | 2001-02-21 00:00:00 |  | 268.77 | 33504 | 198.68 | 16040
 | 2001-02-20 00:00:00 |  | 286.26 | 8880 | 216.91 | 3224
 | 2001-02-19 00:00:00 |  | 288.65 | 24912 | 233.15 | 15840
Spreadsheet: 777716d1650561145-auto-populate-cells-from-data-on-other-tabs-2022-trading-journal
Sheet: April

Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Weekly Totals
 |  |  |  |  |  |  |  |  |  | 2022-04-01 00:00:00 |  | 2022-04-02 00:00:00
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
2022-04-03 00:00:00 |  | 2022-04-04 00:00:00 |  | 2022-04-05 00:00:00 |  | 2022-04-06 00:00:00 |  | 2022-04-07 00:00:00 |  | 2022-04-08 00:00:00 |  | 2022-04-09 00:00:00
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
2022-04-10 00:00:00 |  | 2022-04-11 00:00:00 |  | 2022-04-12 00:00:00 |  | 2022-04-13 00:00:00 |  | 2022-04-14 00:00:00 |  | 2022-04-15 00:00:00 |  | 2022-04-16 00:00:00
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
2022-04-17 00:00:00 |  | 2022-04-18 00:00:00 |  | 2022-04-19 00:00:00 |  | 2022-04-20 00:00:00 |  | 2022-04-21 00:00:00 |  | 2022-04-22 00:00:00 |  | 2022-04-23 00:00:00
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
2022-04-24 00:00:00 |  | 2022-04-25 00:00:00 |  | 2022-04-26 00:00:00 |  | 2022-04-27 00:00:00 |  | 2022-04-28 00:00:00 |  | 2022-04-29 00:00:00 |  | 2022-04-30 00:00:00
Spreadsheet: 160851d1339249940-numbers-from-text-text-to-collumn-oeldere-
Sheet: Blad1

See below for a sample of the data I'm looking at.....
Cell1A | - | - | - | #N/A | & | BELL | 2012-04-01 00:00:00 | X | .028 | X | 12070 | L---- | Want | to | extract | the | 12070 |  |  |  |  |  | 12070
Cell | 2A | - | - | - | SAW | CUT | 2012-04-01 00:00:00 | x | .030 | x | 12500 | +/-.030 | LONG | ---- | Want | to | extract | the | 12500 |  |  |  | 12500
Cell3A | - | - | - | #N/A | CUT | 2008-01-01 00:00:00 | x | .050 | x | 32075 | ---- | Want | to | extract | the | 32075 |  |  |  |  |  |  | 32075
There are about 1200 rows and I really don't want to manually extract. Is there a way to extract the numbers I want?
Spreadsheet: 689708d1596609820-if-function-exceeding-8000-character-limit-need-help-on-shorter-formula-au-and-nz-vendor-margin-analysis-fy20-ytd-test
Sheet: July

Margin and Sales by Vendor - July 2020
Vendor | Sales | Margin $ | Margin %
Palo Alto Networks | 1 | 1
F5 | 1 | 1
NetApp Aust | 1 | 1
Hewlett Packard Enterprise | 1 | 1
ForeScout | 1 | 1
Infoblox | 1 | 1
Tenable | 1 | 1
Riverbed | 1 | 1
Pure Storage | 1 | 1
Channel Services | 1 | 1
Broadcom Solutions | 1 | 1
Sophos | 1 | 1
Arista | 1 | 1
Extreme Networks | 1 | 1
Gigamon | 1 | 1
Cohesity | 1 | 1
Microsoft | 1 | 1
CS Vendors | 1 | 1
Cylance | 1 | 1
FireEye | 1 | 1
[NAME] | 1 | 1
[NAME] | 1 | 1
Avaya | 1 | 1
MobileIron | 1 | 1
Amazon Web Services | 1 | 1
Ribbon | 1 | 1
Mellanox | 1 | 1
AlgoSec | 1 | 1
Nutanix | 1 | 1
[NAME] | 1 | 1
Centrify | 1 | 1
Check Point | 1 | 1
Symantec | 1 | 1
BitTitan | 1 | 1
Grand Total
Spreadsheet: 5ded1b79-889c-4ccf-8b53-9437e9c7ec48
Sheet: Sheet1

Attorney General - DEM (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Downloaded at 5/19/2013 4:26:51 AM
Precincts Reporting: 505/505 - Total Ballots Cast: 102066
2010 Primary Election - OFFICIAL RESULTS
Precinct | [NAME] | write-in | TOTALS
Precinct 01 | 84 | 0 | 84
Precinct 02 | 18 | 0 | 18
Precinct 03 | 18 | 0 | 18
Precinct 04 | 22 | 0 | 22
TOTAL | 142 | 0 | 142
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 100046d1298521401-convert-pivot-table-data-to-regular-format-demand-1-
Sheet: Sheet1

 | Values
Row Labels | Sum of product | Sum of quality | Sum of wad number | Sum of quality number |  | Row Labels | Sum of product | Sum of quality | Sum of wad number | Sum of quality number
1 | 231129 | 23317 | 281.0429999999998 | 7110.350999999993 |  | 1 | 231129 | 23317 | 281.0429999999998 | 7110.350999999993
2 | 190638 | 19471 | 226.5759999999999 | 5731.499999999998 |  | 2 | 190638 | 19471 | 226.5759999999999 | 5731.499999999998
3 | 172313 | 17839 | 208.0559999999997 | 5369.719999999997 |  | 3 | 172313 | 17839 | 208.0559999999997 | 5369.719999999997
4 | 155590 | 15514 | 173.3149999999997 | 4597.037999999993 |  | 4 | 155590 | 15514 | 173.3149999999997 | 4597.037999999993
5 | 115750 | 11629 | 141.0930000000001 | 3497.306999999998 |  | 5 | 115750 | 11629 | 141.0930000000001 | 3497.306999999998
6 | 110205 | 11139 | 128.865 | 3313.229 |  | 6 | 110205 | 11139 | 128.865 | 3313.229
7 | 84208 | 8617 | 96.53999999999999 | 2652.029999999997 |  | 7 | 84208 | 8617 | 96.53999999999999 | 2652.029999999997
8 | 48725 | 5042 | 60.01699999999999 | 1485.977 |  | 8 | 48725 | 5042 | 60.01699999999999 | 1485.977
9 | 48901 | 5064 | 59.96400000000004 | 1535.784999999999 |  | 9 | 48901 | 5064 | 59.96400000000004 | 1535.784999999999
10 | 26879 | 2743 | 31.96599999999999 | 859.3870000000003 |  | 10 | 26879 | 2743 | 31.96599999999999 | 859.3870000000003
(blank) |  |  |  |  |  | (blank)
Grand Total | 1184338 | 120375 | 1407.434999999999 | 36152.32399999998 |  | Grand Total | 1184338 | 120375 | 1407.434999999999 | 36152.32399999998
 |  |  |  |  |  |  | Copy the yellow and paste using values and fomatting