tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: lynn_blair__24484__NNGWKednotes_2001
Sheet: Mar 24 & 25, 2001

NNG WEEKEND NOTES
For cc Mail distribution:  [NAME], [NAME], [NAME], S. January, [NAME], [NAME], [NAME], TMS OnCall
SATURDAY |  |  | 2001-03-24 00:00:00
Mail distribution send to the above listing on Sunday evening.
H:\DATA\Process Guidelines\[NNGWKednotes Template.xls]Dec 25 & 26
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SAT |  |  | No difficulties with the process.  Storage not allocated per N. Callans.
 | 7:00 A.M. Non-grid:
 | Gas Day: | FRI |  |  | No difficulties with the process.
 | 8:00 AM Final Storage
 | Gas Day: | SAT |  |  | No difficulties with the process.
 | 10:00 A.M. Intraday 1:
 | Gas Day: | SAT |  |  | No difficulties with the process.
 | 5:00 P.M. Intraday 2:
 | Gas Day: | SUN |  |  | No difficulties with the process per N. Callans
 | 11:30 A.M. Timely |  |  |  | Storage net withdrawals allocated.
 | Gas Day: | SUN |  |  | No difficulties with the process  RBJ
 | 6:00 P.M. Evening
 | Other Comments:
 | On Call Reps. |  | [NAME] | 6:30 - 3:30
 |  |  | [NAME] | 6:30 - 3:30
 |  |  | [NAME] | 1:00 - 10:00
 |  |  | [NAME] | 1:00 - 10:00
SUNDAY
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SUN |  |  | No difficulties with the process.  Storage not allocated per N. Callans
 | 7:00 A.M. Non-grid:
 | Gas Day: | SAT |  |  | No difficulties with the process.
 | 8:00 AM Final Storage
 | Gas Day: | SUN |  |  | No difficulties with the process.
 | 10:00 A.M. Intraday 1:
 | Gas Day: | SUN |  |  | No difficulties with the process.
 | 5:00 P.M. Intraday 2: |  |  |  | Posted a pop-up at 8:56 pm to notify users that scheduled quantities would be delayed. Did not state
 |  |  |  |  | the reason in the pop-up, but the delay is to hold open the cycle for numbers from El Paso.
 |  |  |  |  | El Paso is having system problems.  A second pop-up was posted when the cycle was
 |  |  |  |  | complete.    [NAME]
 | Gas Day: | MON |  |  | No difficulties with the process per N. Callans
 | 11:30 A.M. Timely |  |  |  | Storage net withdrawals allocated.
 | Gas Day: | MON |  |  | No difficulties with the process.  RBJ
 | 6:00 P.M. Evening
 | Other Comments:
 | On Call Reps: |  | [NAME] | 6:30 - 3:30
 |  |  | [NAME] | 6:30 - 3:30
 |  |  | [NAME] | 1:00 - 10:00
 |  |  | [NAME] | 1:00 - 10:00
Spreadsheet: 109166d1306109355-advanced-filter-with-an-input-box-uniquevalue
Sheet: Sheet2

Name | Pcode | Amount | Date | Clinic | Address | Doctor
xxxxxxx | 001 | 40 | 2011-03-03 00:00:00 | Belus | xyz | [NAME] |  |  | Pcode
Soares | 002 | 65 | 2011-03-04 00:00:00 | [NAME] | cdlp | Chaves R |  |  | 001
[NAME] | 002 | 70 | 2011-03-05 00:00:00 | Ptcl | golf | [NAME] |  |  | Pcode
xxxxxxx | 001 | 60 | 2011-03-06 00:00:00 | gugi | wond | what |  |  | 002
dcdcd | 003 | 70 | 2011-07-03 00:00:00 | Belus | 123zx | [NAME] |  |  | Pcode
fgfgfg | 004 | 80 | 2011-08-03 00:00:00 | Belus | 4444x | [NAME] |  |  | 003
 |  |  |  |  |  |  |  |  | Pcode
 |  |  |  |  |  |  |  |  | 004
Spreadsheet: 37960d1236075148-random-input-random2
Sheet: data

 |  |  |  | childrens names
chore No, | Chore name |  | kid no. | Monday |  | kid no. | Tuesday |  | kid no. | Wednesday |  | kid no. | Thursday |  | kid no. | Friday
1 | task 1 |  | 1 | child1 |  | 1 | child 1 |  | 1 | child 1 |  | 1 | child 1 |  | 1 | child 1
2 | task 2 |  | 2 | child2 |  | 2 | child 2 |  | 2 | child 2 |  | 2 | child 2 |  | 2 | child 2
3 | task 3 |  | 3 | child3 |  | 3 | child 3 |  | 3 | child 3 |  | 3 | child 3
4 | task 4 |  | 4 | [NAME] |  | 4 | child 4 |  | 4 | child 4 |  | 4 | child 4
5 | task 5 |  | 5 | child5 |  | 5 | child 5 |  | 5 | child 5 |  | 5 | child 5
6 | task 6 |  | 6 | [NAME] |  | 6 | child 6 |  | 6 | child 6 |  | 6 | child 6
7 | task 7 |  | 7 | [NAME] |  | 7 | child 7 |  | 7 | child 7 |  | 7 | child 7
8 | task 8 |  | 8 | child8 |  |  |  |  | 8 | child 8 |  | 8 | child 8
9 | task 9 |  | 9 | child9 |  |  |  |  | 9 | child 9 |  | 9 | child 9
10 | task 10 |  | 10 | child10 |  |  |  |  | 10 | child 10 |  | 10 | child 10
11 | task 11 |  | 11 | child11 |  |  |  |  | 11 | child 11 |  | 11 | child 11
12 | task 12 |  |  |  |  |  |  |  | 12 | child 12 |  | 12 | child 12
13 | task 13 |  |  |  |  |  |  |  | 13 | child 13
14 | task 14 |  |  |  |  |  |  |  | 14 | child 14
15 | task 15 |  |  |  |  |  |  |  | 15 | child 15
16 | task 16 |  |  |  |  |  |  |  | 16 | child 16
17 | task 17 |  |  |  |  |  |  |  | 17 | child 17
18 | task 18 |  |  |  |  |  |  |  | 18 | child 18
19 | task 19
20 | task 20
21 | task 21
22 | task 22
23 | task 23
24 | task 24
25 | task 25
26 | task 26
27 | task 27
28 | task 28
29 | task 29
30 | task 30
Spreadsheet: dc917435-ce60-4b00-8d73-c89d538bc494
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
KIDBN | Test | KIDBN | [NAME] (Red), IgE | [NAME] (Red), IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m. - 8 p.m., Saturday; 8 a.m. - 3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
KIDBN | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
KIDBN | Result | KIDBN | [NAME] (Red), IgE | [NAME] (Red), IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 7129-0
Spreadsheet: 56572d1256744813-cannot-work-out-why-dates-are-different-in-cell-and-formula-bar-workbook1
Sheet: Sheet1

Filter By Resource |  |  |  |  |  |  |  |  |  |  | 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
QC Resource | Project/Task | TDL | Resource Type | Notes | DM&EA Delivery Organization | Start Date | End Date | Total Effort In Hours | % Allocated | Hours Allocated/Week | 2009-09-07 00:00:00 | 2009-09-14 00:00:00 | 2009-09-21 00:00:00 | 2009-09-28 00:00:00 | 2009-10-05 00:00:00 | 2009-10-12 00:00:00 | 2009-10-19 00:00:00 | 2009-10-26 00:00:00 | 2009-11-02 00:00:00 | 2009-11-09 00:00:00 | 2009-11-16 00:00:00 | 2009-11-23 00:00:00 | 2009-11-30 00:00:00 | 2009-12-07 00:00:00 | 2009-12-14 00:00:00 | 2009-12-21 00:00:00 | 2009-12-28 00:00:00 | 2010-01-04 00:00:00 | 2010-01-11 00:00:00 | 2010-01-18 00:00:00 | 2010-01-25 00:00:00 | 2010-02-01 00:00:00 | 2010-02-08 00:00:00 | 2010-02-15 00:00:00 | 2010-02-22 00:00:00 | 2010-03-01 00:00:00 | 2010-03-08 00:00:00 | 2010-03-15 00:00:00 | 2010-03-22 00:00:00 | 2010-03-29 00:00:00
Spreadsheet: darrell_schoolcraft__7327__imball0202
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 4835 | 5511 | 5 | 6 | 825 | 581 | 1458 | 895
2 | 5871 | 5511 | 20 | 6 | 860 | 581 | 1510 | 895
3 | 5772 | 5511 | 9 | 6 | 927 | 581 | 1471 | 895
4 | 5788 | 5511 | 29 | 6 | 944 | 581 | 1445 | 895
5 | 5337 | 5511 | 3 | 6 | 925 | 581 | 1425 | 895
6 | 5250 | 6011 | 142 | 6 | 913 | 581 | 1797 | 895
7 | 5202 | 6011 | 41 | 6 | 915 | 581 | 1586 | 895
8 | 5313 | 6011 | 1 | 6 | 912 | 581 | 1516 | 895
9 | 5045 | 6011 | 1 | 6 | 911 | 581 | 1472 | 895
10 | 5435 | 6011 | 1 | 6 | 861 | 581 | 1437 | 895
11 | 5574 | 6011 |  | 6 | 929 | 581 | 1452 | 895
12 | 5251 | 6011 |  | 6 | 942 | 581 | 1480 | 895
13 | 5369 | 6011 |  | 6 | 659 | 581 | 1401 | 895
14 | 5384 | 6011 |  | 6 | 987 | 581 | 1701 | 895
15 | 5372 | 6011 |  | 6 | 850 | 581 | 1457 | 895
16 | 5268 | 6011 |  | 6 | 918 | 581 | 1341 | 895
17 | 5278 | 6011 |  | 6 | 420 | 581 | 1428 | 895
18 | 5501 | 6011 |  | 6 | 988 | 581 | 1330 | 895
19 | 5670 | 6011 |  | 6 | 1027 | 581 | 1661 | 895
20 | 5708 | 6011 |  | 6 | 1021 | 581 | 1535 | 895
21 | 5756 | 6011 |  | 6 | 751 | 581 |  | 895
22 | 5775 | 6011 |  | 6 | 416 | 581 | 747 | 895
23 | 5749 | 6011 |  | 6 | 1054 | 581 | 1960 | 895
24 | 5781 | 6011 |  | 6 | 833 | 581 | 1714 | 895 |  |  | 377
25 | 5256 | 6011 |  | 6 | 621 | 581 | 1587 | 895 |  |  | 725
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  |  |  |  |  |  |  | 341278
2002-02-25 00:00:00
CBS Volume
 |  |  | 135419
Spreadsheet: 1dfcf055-6c85-4a49-8f09-1cfbccd41b79
Sheet: Final Qrt 3 2011

Community Education  Personal Interest
 |  |  |  | Spring and [NAME] 2013
 |  | Place mouse over Course Title for course description.
CONTACT:  (210) 486-4428
GED Prep
CRN | COURSE |  | QTR | START | END | COURSE  TITLE | FEE | DAY | TIME | ROOM
20527 | LIT | 1001 | 2 | 2013-01-28 00:00:00 | 2013-02-01 00:00:00 | GED PREP | 89 | M-F | 9:00AM-2:00PM | MLH
20528 | LIT | 1001 | 2 | 2013-03-18 00:00:00 | 2013-03-22 00:00:00 | GED PREP | 89 | M-F | 9:00AM-2:00PM | MLH
20529 | LIT | 1001 | 3 | 2013-05-20 00:00:00 | 2013-05-24 00:00:00 | GED PREP | 89 | M-F | 9:00AM-2:00PM | MLH
20530 | LIT | 1001 | 4 | 2013-08-19 00:00:00 | 2013-08-23 00:00:00 | GED PREP | 89 | M-F | 9:00AM-2:00PM | MLH
Cooking A to Z
CRN | COURSE |  | QTR | START |  | COOKING A TO Z | FEE | DAY | TIME | ROOM
20531 | FAB | 1001 | 2 | 2013-01-26 00:00:00 |  | COOKING A TO Z | 72 | S | 1:00PM-4:00pm | HH 113
20532 | FAB | 1001 | 2 | 2013-02-23 00:00:00 |  | COOKING A TO Z | 72 | S | 1:00PM-4:00pm | HH 113
20533 | FAB | 1001 | 2 | 2013-03-23 00:00:00 |  | COOKING A TO Z | 72 | S | 8:00AM-12:00PM | HH 113
20534 | FAB | 1001 | 2 | 2013-04-20 00:00:00 |  | COOKING A TO Z | 72 | S | 1:00PM-4:00pm | HH 113
20535 | FAB | 1001 | 3 | 2013-05-18 00:00:00 |  | COOKING A TO Z | 72 | S | 1:00PM-4:00pm | HH 113
20536 | FAB | 1001 | 4 | 2013-08-24 00:00:00 |  | COOKING A TO Z | 72 | S | 8:00AM-12:00PM | HH 113
Mariachi
20537 | MUS | 1000 | 2 | 2013-01-22 00:00:00 | 2013-05-18 00:00:00 | MARIACHI | 300 | S | 9:00AM-12:00PM | PCA107
TO REGISTER - CLICK HERE
Spreadsheet: 2a6a17cb-db31-4379-97bb-e5f6affc0b83
Sheet: Sheet1

Table 1--U.S. cotton supply and use estimates | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  |  | 2011/12
Item | 2010/11 |  | Aug. |  | Sep. |  | Oct.
 | Million acres
Upland:
Planted | 10.77 |  | 13.436 |  | 14.431 |  | 14.431
Harvested | 10.497 |  | 9.379 |  | 9.562 |  | 9.562
 | Pounds
Yield/harvested acre | 805 |  | 809 |  | 794 |  | 797
 | Million 480-lb. [NAME]
Beginning stocks | 2.929 |  | 2.839 |  | 2.572 |  | 2.572
Production | 17.6 |  | 15.817 |  | 15.819 |  | 15.871
Total supply   1/ | 20.531 |  | 18.661 |  | 18.396 |  | 18.448
[NAME] use | 3.874 |  | 3.77 |  | 3.775 |  | 3.775
Exports | 13.881 |  | 11.65 |  | 11.325 |  | 10.825
Total use | 17.755 |  | 15.42 |  | 15.1 |  | 14.6
Ending stocks  2/ | 2.572 |  | 3.232 |  | 3.33 |  | 3.83
 | Percent
Stocks-to-use ratio | 14.5 |  | 21 |  | 22.1 |  | 26.2
 | 1,000 acres
Extra-long staple:
Planted | 204.2 |  | 289 |  | 289 |  | 289
Harvested | 201.7 |  | 287.5 |  | 287.5 |  | 287.5
 | Pounds
Yield/harvested acre | 1200 |  | 1231 |  | 1231 |  | 1231
 | 1,000 480-lb. [NAME]
Beginning stocks | 18 |  | 11 |  | 28 |  | 28
Production | 504 |  | 737 |  | 737 |  | 737
Total supply   1/ | 529 |  | 748 |  | 770 |  | 770
[NAME] use | 26 |  | 30 |  | 25 |  | 25
Exports | 495 |  | 650 |  | 675 |  | 675
Total use | 521 |  | 680 |  | 700 |  | 700
Ending stocks  2/ | 28 |  | 68 |  | 70 |  | 70
 | Percent
Stocks-to-use ratio | 5.4 |  | 10 |  | 10 |  | 10
1/ Includes imports.  2/ Includes unaccounted.
Last update:  10/13/11.
Sources: USDA, World Agricultural Outlook Board; and USDC,
U.S. Census Bureau.
Spreadsheet: 811647d1672731870-similars-where-last-3-letters-equal-to-first-3-match-three
Sheet: Sheet2

KAFILAS
SIFAKAS
FANTAIL
TAILFAN
ALFAQUI
INFANTA
Spreadsheet: 46858d1245784469-creating-league-tables-rank-tiebreaking
Sheet: MultipleSecondaryScores

Player | Score | [NAME] | [NAME] | Rank |  |  | Winners | Rank | Player | High is best
Player # 1 | 10 | 56 | 28 | 14 |  |  |  | 1 | Player # 14
Player # 2 | 20 | 14 | 14 | 12 |  |  |  | 2 | Player # 7
Player # 3 | 30 | 2 | 38 | 10 |  |  |  | 3 | Player # 13
Player # 4 | 40 | 46 | 99 | 7 |  |  |  | 4 | Player # 6
Player # 5 | 50 | 25 | 64 | 5 |  |  |  | 5 | Player # 5
Player # 6 | 60 | 53 | 61 | 4 |  |  |  | 6 | Player # 12
Player # 7 | 70 | 34 | 3 | 2 |  |  |  | 7 | Player # 4
Player # 8 | 10 | 21 | 61 | 13 |  |  |  | 8 | Player # 11
Player # 9 | 20 | 29 | 77 | 11 |  |  |  | 9 | Player # 10
Player # 10 | 30 | 32 | 63 | 9 |  |  |  | 10 | Player # 3
Player # 11 | 40 | 26 | 24 | 8 |  |  |  | 11 | Player # 9
Player # 12 | 50 | 20 | 43 | 6 |  |  |  | 12 | Player # 2
Player # 13 | 60 | 57 | 84 | 3 |  |  |  | 13 | Player # 8
Player # 14 | 70 | 34 | 26 | 1 |  |  |  | 14 | Player # 1
 |  |  |  |  |  |  | This method extends the idea from the first sheet.
 |  |  |  |  |  |  | Each new tiebreaker score adds another SUMPRODUCT() level.
Spreadsheet: 22bf7fc6-cfee-42f6-8601-8123690997c5
Sheet: 2014

CLE Sponsor Name | CLE Sponsor Acronym | CLE Name | CLE Start Date | CLE End Date | CLE Location/ CLE Type | Approved Federal CLE Hours | Iowa Activity ID | Alternate Iowa Activity ID(s) | Notes | Submitted By | Submitted Date
National Business Institute | NBI | Social Security Offsets in Workers' Compensation | 2014-01-08 00:00:00 | 2014-01-08 00:00:00 | Telephone | 1.5 | 119097 |  |  | Cassi Gruber | 2013-10-08 00:00:00
Spreadsheet: 85148d1285202188-array-formula-or-pivot-table-test-file
Sheet: Sheet5

Raw data
Retrieved from an external database
Cons Unit | Partner Unit | Item | Amt
10 | 15 | 11800000 | -272.27
10 | 15 | 47300000 | 261513401.17
10 | 17 | 11800000 | 48957613.76
10 | 17 | 47300000 | 766213.74
10 | 20 | 11800000 | 2449716.09
10 | 21 | 11800000 | -100
44 | 22 | 11800000 | -527073.75
44 | 22 | 47300000 | -9419418.92
44 | 23 | 11800000 | 561690.62
200 | 25 | 11800000 | 1081239.75
200 | 25 | 47300000 | -8938860.19
200 | 30 | 11800000 | -257101814
200 | 30 | 11800010 | 105023650.44
200 | 30 | 47300000 | -7153762792.75
Result wanted
If subtotal by Cons Unit/Partner Unit is a negative number, show total only:
Cons Unit | Partner Unit | Amt
10 | 21 | -100
44 | 22 | -9946492.67
200 | 25 | -7857620.439999999
200 | 30 | -7305840956.31
Spreadsheet: 219672d1362870859-count-occurrences-in-several-rows-sample-workbook
Sheet: datatable

txtLFMname | dealer | DateLoaded | Driver1ID | Driver2ID | Driver3ID | Driver4ID
Adams, Mark |  | 2013-03-04 00:00:00 | Harris, Scotty | Adams, Mark
 |  | 2013-03-05 00:00:00 | Harris, Scotty | Adams, Mark
[NAME], [NAME] |  | 2013-03-04 00:00:00 | [NAME], [NAME] | Leuven, Ruben
 |  | 2013-03-04 00:00:00 | [NAME], [NAME] | Leuven, Ruben
 |  | 2013-03-04 00:00:00 | [NAME], [NAME] | Leuven, Ruben | [NAME], [NAME]
 |  | 2013-03-05 00:00:00 | [NAME], [NAME] | [NAME], [NAME]
Harris, Scotty |  | 2013-03-04 00:00:00 | Harris, Scotty | Adams, Mark
 |  | 2013-03-05 00:00:00 | Harris, Scotty | Adams, Mark
 |  | 2013-03-07 00:00:00 | Harris, Scotty | Phillips, [NAME] | [NAME], [NAME]
Leuven, Ruben |  | 2013-03-04 00:00:00 | [NAME], [NAME] | Leuven, Ruben
 |  | 2013-03-04 00:00:00 | [NAME], [NAME] | Leuven, Ruben
 |  | 2013-03-04 00:00:00 | [NAME], [NAME] | Leuven, Ruben | [NAME], [NAME]
Spreadsheet: 013099c0-71bb-4a5e-b72d-2436d999e953
Sheet: Figure 5

 |  | Statewide District | Statewide Charter
Percentage of stuents eligible for free or reduced price lunch |  | 0.271 | 0.594
Percentage of schools eligible for Title 1 |  | 0.407 | 0.875
Percent of students by school type
 | Primary (K-5) | 0.479 | 0.516
 | Middle (6-8) | 0.207 | 0.316
 | High (9-12) | 0.307 | 0.168
 | Other (K-12,K-8, etc.) | 0.008 | 0
Spreadsheet: 160733d1339177448-excel-2007-look-up-question-lookup-from-multiple-tabs
Sheet: 198

Attendance Rules: 5 – 5.75   NoCorrective Action 6 – 7.00  No Corrective Action taken; Notice of Attendance Record 7.25 – 7.75   Verbal Warning 8 – 8.75  Written Warning 9 – 9.75  Final Written Warning with 120-day probation Next Point (10) - Review for Termination |  | Occurrence Rules: **Occurrences stay on the record for a rolling one year. **Occurrences stay on until an Approved FMLA letter is issued from UNUM. A doctors excuse does not remove an Occurrence. 8-15 minutes tardy, early departure or shift interruption~.25 16 or more minutes tardy, early departure or shift interruption ~ .50 3 hours or more absent when scheduled to work ~ 1 2 consecutive work days absent (10 hours for part-time)~2 3 or more consecutive days absent (15 hours for part-time)~2.25 Call-off or no-show for scheduled & communicated overtime~1 |  |  |  |  |  |  |  | 0 | n/a
 |  |  |  |  |  |  |  |  |  | 1 | Applied for
 |  |  |  |  |  |  |  |  |  | 0.25 | Approved
 |  |  |  |  |  |  |  |  |  |  | Denied
Tech Name | [NAME] | Total Occurrences
Tech Number | 198 | Corrective Action Step
Date | Occurrence Issued | FMLA   Applied for/ Approved/Denied | Comments
2011-12-20 00:00:00 | 1 | n/a
2012-01-26 00:00:00 | 1 | n/a
2012-01-27 00:00:00 | 1 | n/a
2012-02-21 00:00:00 | 1 | n/a
2012-02-22 00:00:00 | 1 | n/a
2012-04-24 00:00:00 | 1 | n/a
Quit
Spreadsheet: 827350d1682619233-retrive-value-left-of-keyword-in-a-string-retreve-value-left-of-keyword
Sheet: Sheet1

 |  |  |  |  |  | seems easy to spellout the formula but not easy to apply it:(
 |  | Data | Desired Result | TMS Formula | [NAME]
 |  |  |  |  |  | If data contayins Keyword "YES" or "NO" then get all numbers to its left before the preceding space
 |  | Day 00Days (Weeklys) 24 APR 20 11.5 PUT | 10 |  |  | and if there are none than blank
 |  | not Available GN230616P11 GN 4080 Put -1 0.99 great day | 4080
 |  | Unavailable GN230616P12 GN 12 NO -2 1.97 | 12
 |  | Word GN230915P11 GN 11 NO -1 1.3 | 11
 |  | Retest GN230915P12 GN 4075 NO -1 1.73 | 4075
 |  | GN231215P10 GN 3980 YES -1 1.12 Great Great | 3980
 |  | [NAME] GN 12 YES -1 2.02 Great? | 12
 |  | GN240119P10 GN 10 YES -2 1.71 | 10
 |  | [NAME] 2.82
 |  | GN240119P20 @EtW3N  YES -1 10.35
 |  | GN250117P10 @EtW3N  NO -1 3.1
 |  | GN250117P12 @EtW3Q 3980 YES -1 3.15 | 3980
 |  | GN250117P20 @EtW3Q 20 NO -1 11 | 20
 |  | IM230616P6 @EtS 4575.75 NO -1 0.3 | 4575.75
 |  | IM230616P7 @EtW3J 7 YES -1 1.2 | 7
 |  | IM230915P7 IM 7 YES -1 1.37 | 7
 |  | IM240119P5 IM 289 YES -2 0.625 | 289
 |  | IM240119P8 IM 8 NO -1 2.2 | 8
 |  | IM250117P7 @Et5DH23 1546 NO -2 2.15 | 1546
 |  | IM250117P10 @Et5DH23  NO -1 3.97
 |  | [NAME] 20 YES -2 2.135 | 20
 |  | S230616P22.5 @Et5DH 122.5 NO -4 2.2 | 122.5
 |  | [NAME]NO -2 1.75
 |  | S230915P22.5 S 22.5 NO -4 2.7875 | 22.5
 |  | WO230616P16 WO  NO -1 2
 |  | WO230915P17 WO 325.6 YES -2 1.625 | 325.6
 |  | WO230915P18 WO 18 NO -1 1.95 | 18
 |  | WO240119P15 WO 15 NO -2 2.15 | 15
 |  | WO240119P20 WO 4115 YES -1 5 | 4115
 |  | E230721P11 E  NO -1 1.08
 |  | E231020P12 E 4115 YES -1 0.72 | 4115
 |  | E240119P10 E 3800 NO -1 1.17 | 3800
 |  | E240621P10 E 10 NO -1 1.54 | 10
 |  | E250117P10 E 7.8 NO -1 2.01 | 7.8
 |  | IEP230519P50 IEP  YES -1 1.3
 |  | IEP230616P50 IEP 3875.5 NO -5 3.34 | 3875.5
 |  | IEP230616P55 IEP 55 NO -1 5.3 | 55
 |  | IEP230915P50 IEP 50.5 YES -3 2.75 | 50.5
 |  | IEP230915P55 @Et1J23 55 NO -2 6.855 | 55
 |  | IEP240119P50 @EtS23 50 NO -4 6.025 | 50
 |  | IEP240119P55 @EtSZ23  YES -2 7.95
 |  | IEP250117P50 @EtS23 50 NO -2 10.6 | 50
 |  | IEP250117P55 @Et1DJ23  YES -2 14.05
 |  | RI230519P12.5 @EtW3J23 12.5 YES -4 1.2025 | 12.5
 |  | RI230818P10 @EtW3J23 45.75 NO -1 0.9 | 45.75
 |  | RI231020P12.5 @Et2J23 12.5 NO -1 1.65 | 12.5
 |  | RI231020P15 @EtW3J23  YES -1 3.95
 |  | NLY230519P20 NLY 3305.25 YES -1 1.99 | 3305.25
 |  | NLY230519P22 NLY 22 NO -3 1.65 | 22
 |  | NLY230721P20 NLY 20 NO -1 2.66 | 20
Spreadsheet: 0d559763-5d18-41d8-aacd-eba6e073d806
Sheet: Modifieds

Modifieds
Place | Car # | Name | 2014-04-12 00:00:00 | 2014-04-19 00:00:00 | Total Points
1 | 5H | Braedon Hand | 40 | 39 | 79
2 | 1M | [NAME] | 38 | 40 | 78
3 | 11X | [NAME] | 34 | 37 | 71
4 | SW | [NAME] | 39 |  | 39
5 | 27 | [NAME] |  | 38 | 38
6 | 25 | [NAME] | 37 |  | 37
7 | 49 | [NAME] | 36 |  | 36
8 | 11 | [NAME] |  | 36 | 36
9 | 47 | [NAME] | 35 |  | 35
10 | 85 | [NAME] |  | 35 | 35
11 | 9 | [NAME] |  | 34 | 34
12 | 68 | [NAME] | 33 |  | 33
13 | 85 | [NAME] | 32 |  | 32
14 | 73 | [NAME] | 31 |  | 31
15 | ZERO | Dustin Comer | 30 |  | 30
Spreadsheet: 869647d1716246911-converting-a-table-to-another-table-table-help
Sheet: Sheet1

Source.Name | Column2 | Column6
10C0104_A23A Scour Evaluation Final Report.xlsx | Item 61 | 7
10C0104_A23A Scour Evaluation Final Report.xlsx | Item 71 | 8
10C0104_A23A Scour Evaluation Final Report.xlsx | Item 113 | 8
10R0159_A23A Scour Evaluation Final Report.xlsx | Item 61 | 6
10R0159_A23A Scour Evaluation Final Report.xlsx | Item 71 | 7
10R0159_A23A Scour Evaluation Final Report.xlsx | Item 113 | 5
10XX140_A23A Scour Evaluation Final Report.xlsx | Item 61 | 7
10XX140_A23A Scour Evaluation Final Report.xlsx | Item 71 | 7
10XX140_A23A Scour Evaluation Final Report.xlsx | Item 113 | 8
10XX159_A23A Scour Evaluation Final Report.xlsx | Item 61 | 5
10XX159_A23A Scour Evaluation Final Report.xlsx | Item 71 | 6
10XX159_A23A Scour Evaluation Final Report.xlsx | Item 113 | 8
10XX233_A23A Scour Evaluation Final Report.xlsx | Item 61 | 5
10XX233_A23A Scour Evaluation Final Report.xlsx | Item 71 | 6
10XX233_A23A Scour Evaluation Final Report.xlsx | Item 113 | 7