tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0f880377-be0d-4fa3-821e-21cda48756e8
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
OXYCS | Test | OXYCS | Oxycodone, Serum | Oxycodone, S | Gas Chromatography-Mass Spectrometry Using Selected Ion Monitoring (GC-MS SIM) | Plain, Red-Top Tube: Red |  |  | 5 | mL | Container/Tube: Red top [NAME]: 5 mL | 2.1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Serum gel tube | 10-120 ng/mL | Wednesday, Sunday | 2 days | 6 days | 1 | 83925 |  |  |  |  | Rochester
OXYCS | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
OXYCS | Result | 83654 | Oxycodone, S | Oxycodone, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 3893-5
Spreadsheet: 729650d1619233718-ranking-list-based-on-test-scores-new-hire-testing-2-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I am working on an Excel sheet that places a rank by each person based on their score for a certain part of a hiring test, each section is tested individually and then the average of the rank of each list is used to rank them overall. It will only rank if each all scores are listed, but I would like to to rank regardless of if all section scores are entered and regardless of if each persons scores are entered. If I delete even one score the overall averages go to #value!. Also I may have 30 people testing one time but only 5 people testing the next time so I may not have each cell filled out. I will attach the file for reference.
Name A-Z |  | Written Exam |  | Fintess Eval |  | Interview |  | Average of 3 tests | Overall Rank
Last | First | Score | Place | Score | Place | Score | Place |  |  |  |  | Written Exam Helper 1 | Written Exam Helper 2 | Fitness Eval Helper 1 | Fitness Eval Helper 2 | Interview Helper 1 | Interview Helper 2
 |  | 88 |  | 22 |  | 58
 |  | 100 |  | 88 |  | 90
 |  | 100 |  | 85 |  | 25
 |  | 100 |  | 86 |  | 23
 |  | 100 |  | 87 |  | 24
Spreadsheet: 880247d1727876490-lookup-based-on-row-and-column-number-example-1-
Sheet: Sheet1

Can we do lookup from pivotable base on row and column number?
Count of Partcipant | Column Labels
 | A | B |  | C |  | Grand Total
Row Labels | Excel | Excel | Powerpoint | Power BI | Powerpoint |  |  | Example:
Finance |  |  | 1 | 1 |  | 2 |  | Row | 3
GA | 1 |  |  |  |  | 1 |  | Column | 1
HR | 2 |  |  |  |  | 2 |  | lookup result
Logistics |  |  |  |  | 1 | 1
Sales |  | 1 | 1 |  |  | 2
Grand Total | 3 | 1 | 2 | 1 | 1 | 8
Spreadsheet: 875991d1722621003-lottery-tracker-needed-number-test-1
Sheet: Sheet1

 | Check number | #1 | #2 | #3 | #4 | #5 | #6 |  |  |  | # | [NAME]
 |  | 12 | 3 | 24 | 52 | 16 | 38 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 2
 | Match? | 1 | 2 | 3 | 4 | 5 | 6 |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  | 5
 | Line # | #1 | #2 | #3 | #4 | #5 | #6 | # [NAME] | PB Matched |  | 6
 | 1 | 8 |  |  |  |  | 38 | 1 |  |  | 7
 | 2 |  |  |  |  |  |  |  |  |  | 8
 | 3 |  |  |  |  |  |  |  |  |  | 9
 | 4 |  |  |  |  |  |  |  |  |  | 10
 | 5 |  |  |  |  |  |  |  |  |  | 11
 | 6 |  |  |  |  |  |  |  |  |  | 12
 | 7 |  |  |  |  |  |  |  |  |  | 13
 | 8 |  |  |  |  |  |  |  |  |  | 14
 | 9 |  |  |  |  |  |  |  |  |  | 15
 | 10 |  |  |  |  |  |  |  |  |  | 16
 | 11 |  |  |  |  |  |  |  |  |  | 17
 | 12 |  |  |  |  |  |  |  |  |  | 18
 | 13 |  |  |  |  |  |  |  |  |  | 19
 | 14 |  |  |  |  |  |  |  |  |  | 20
 | 15 |  |  |  |  |  |  |  |  |  | 21
 | 16 |  |  |  |  |  |  |  |  |  | 22 |  |  |  |  |  |  |  |  |  |  |  | n
 | 17 |  |  |  |  |  |  |  |  |  | 23
 | 18 |  |  |  |  |  |  |  |  |  | 24
 | 19 |  |  |  |  |  |  |  |  |  | 25
 | 20 |  |  |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  |  |  |  | 27
 |  |  |  |  |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  |  |  |  | 29
 |  |  | My lottery has 47 numbers (1-47), no special number, or PB. |  |  |  |  |  |  |  | 30
 |  |  | I would like the winning numbers placed in [NAME], and checked if they match. |  |  |  |  |  |  |  | 31
 |  |  | I would like the matched numbers placed in C6 :H6. |  |  |  |  |  |  |  | 32
 |  |  | I would like the M column to show how many times each ball was picked. |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  |  |  |  | 37
 |  |  |  |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  |  | 41
 |  |  |  |  |  |  |  |  |  |  | 42
Spreadsheet: 844894d1696518404-write-formula-to-compare-planned-amounts-by-vendor-in-one-sheet-to-approved-amounts-by-ven-workbook-sample-for-formula-excelmuch-
Sheet: Project ID TEST1

Project ID | Project ID TEST1
Partner | Total Approved Amount
Partner Type 1
Vendor 1
January
February
March
April
May
June
July
August
September
October
November
December
Totals (Jan-Dec) | 3400
Partner Type 2
Vendor 1
January
February
March
April
May
June
July
August
September
October
November
December
Totals (Jan-Dec) | 24000
Vendor 2
January
February
March
April
May
June
July
August
September
October
November
December
Totals (Jan-Dec) | 5500
Vendor 3
January
February
March
April
May
June
July
August
September
October
November
December
Totals (Jan-Dec) | 7100
Spreadsheet: 836043d1689066063-summary-across-multiple-sheets-and-reference-list-excel-linup-help-game-lineup-2023-07-07
Sheet: G2 - 10 - Oregon

Date: |  | 2023-07-09 00:00:00 |  |  | Field: | 5 |  | Start Time: |  | 10:45:00
Home: |  | SYB 8U All Star Black |  |  | 3rd | Set Up
Visitors: |  | Oregon |  |  | 1st | Clean Up
 |  |  |  |  | Inning
 |  | Player |  |  | Coach Pitch |  |  |  |  |  | Innings on Bench | Innings in Infield | Inninings in Outfield |  | [NAME]
Order |  | First | Last | # | 1 | 2 | 3 | 4 | 5 | 6 |  |  |  |  | First Name | Last Name | Number
1 | 12 | Player | One | 1 | LCF | LCF | LCF | SS | SS | SS |  |  |  |  | Player | One | 1
2 | 11 | Player | Two | 2 | SS | SS | SS | LF | LF | LF |  |  |  |  | Player | Two | 2
3 | 1 | Player | Three | 3 | 1B | 1B | 1B | LCF | LCF | LCF |  |  |  |  | Player | Three | 3
4 | 2 | Player | Four | 4 | X | X | P | 1B | 1B | 1B |  |  |  |  | Player | Four | 4
5 | 4 | Player | Five | 5 | LF | LF | LF | 2B | 2B | 2B |  |  |  |  | Player | Five | 5
6 | 5 | Player | Six | 6 | 2B | 2B | 2B | RCF | RCF | RCF |  |  |  |  | Player | Six | 6
7 | 10 | Player | Seven | 7 | 3B | 3B | 3B | RF | RF | RF |  |  |  |  | Player | Seven | 7
8 | 9 | Player | Eight | 8 | RF | RF | RF | P | C | C |  |  |  |  | Player | Eight | 8
9 | 6 | Player | Nine | 9 | RCF | RCF | RCF | 3B | 3B | 3B |  |  |  |  | Player | Nine | 9
10 | 7 | Player | Ten | 10 | C | C | X | X | P | P |  |  |  |  | Player | Ten | 10
11 | 8 | Player | Eleven | 11 | P | P | C | C | X | X |  |  |  |  | Player | Eleven | 11
Out
 | 9
 | 9
Notes:
 |  |  |  | Players on [NAME]
Spreadsheet: 482014d1474854042-new-empty-table-for-each-element-of-dropdown-list-new-city-example
Sheet: Sheet1

City
 |  | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00 | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | 2016-05-01 00:00:00 | 2016-06-01 00:00:00 | 2016-07-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-01 00:00:00
Electricity
 | Usage
 | invoice
Water
 | Usage
 | Disposal Amount
 | Water Service Charge
Waste
 | Paper and Cardboard
 | General Waste
Spreadsheet: 105942d1303216776-index-indirect-match-help-projbudg
Sheet: ActualResourceDays

 |  |  |  | 2009 |  |  |  |  |  |  |  |  |  |  |  | 2010
 |  |  | [NAME] | J | F | M | A | M | J | J | A | S | O | N | D | J | F | M | A | M | J | J | A | S | O | N | D |  | [NAME]
ACTIVITIES & TIMELINE: |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | Total Days | Cost
Working Days: |  |  |  |  |  |  | 19 | 19 | 22 | 23 | 19 | 22 | 23 | 21 | 20
IBM Consultancy |  | Ext | 0
Delivery/QA Manager |  | Ext | 0
Project Manager-Rod Bull |  | Int | 0
Legal Review |  | Ext | 0
Project Manager | Rod Bull | PM | 0
Project Manager | Rod Bull | PM | 0
[NAME] | [NAME] | BPD | 0
Agresso HR/Payroll Consultant | Thalia Pais | OIF | 0
[NAME] Manager | [NAME] | IS | 0
[NAME] | [NAME] | IS | 0
[NAME] (Post 1/2) | [NAME] | IS | 0
[NAME] HR Consultant | [NAME] | IS | 0
[NAME] (Post 1/2) | [NAME] | IS | 0
[NAME] | [NAME] | IS | 0
[NAME] (Post 1/2) | [NAME] | IS | 0
[NAME] | [NAME] | IS | 0
[NAME] | [NAME] | IS | 0
[NAME] | [NAME] | IS | 0
Agresso PCB Consultant (Post 1/2) | [NAME] | IS | 0
Agresso Technical Consultant | [NAME] | Tech | 0
Agresso Technical Trainer | [NAME] | TR | 0
Agresso Technical Consultant | [NAME] | Tech | 0
[NAME] | [NAME] | TR | 0
[NAME] | [NAME] | TR | 0
[NAME] | [NAME] | TR | 0
[NAME] | [NAME] | TR | 0
KCS Data Migration | [NAME] | DM | 0
Infor Data Migration | [NAME] | DM | 0
Infor Interface Analyst | [NAME] | IF | 0
Infor Interface Analyst | [NAME] | IF | 0
ImageNow Consutltant | [NAME] | OIF | 0
Agresso Technical Consultant | [NAME] | OIF | 0
[NAME] | [NAME] | RP | 0
[NAME] | [NAME] | RP | 0
External Agresso Report Consultant | [NAME] | RP | 0
External Agresso Data Migration | [NAME] | DM | 0
External Agresso Data Migration | [NAME] | IF | 0
Agresso Customisation Consultant | [NAME] | CU | 0
[NAME] | [NAME] | IF | 0
[NAME] | [NAME] | OIF | 0
[NAME] | [NAME] | RP | 0
Agresso Security /Excelerator Consultant | [NAME] / [NAME] | TR | 0
Agresso Technical Consultant | [NAME] | Tech | 0
[NAME] HR/PY Migration Consultant | [NAME] | DM | 0
[NAME] | [NAME] | IF | 0
[NAME] | [NAME] | IF | 0
[NAME] HR report consultant | [NAME] | RP | 0
Business Implementation Support consultant | Thalia Pais | BIS | 0
AW Data migration | [NAME] | DM | 0
Procedures developer | [NAME] | PR | 0
Totals
Expenses |  |  | 125
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Spreadsheet: ece2f356-783b-4417-96cb-308f19315a4b
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
[NAME] | Test | [NAME] | [NAME] (Beta-Quantification), Serum | [NAME] (Beta-Quant), S | Ultracentrifugation/Selective Precipitation/Enzymatic Colorimetry (Beta-Quantification) | Serum, [NAME] |  |  | 3 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 3 mL Collection Instructions: Patient must not consume any alcohol for 24 hours before the specimen is drawn. Additional Information: Indicate patient's age and sex. | <2 years: 1 mL;   > or =2 years: | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; Gross reject Other	NA | The National Cholesterol Education Program (NCEP) has set the following guidelines for LDL-C in adults (ages 18 years and up): Optimal: <100 mg/dL* Near optimal: 100-129 mg/dL Borderline high: 130-159 mg/dL High: 160-189 mg/dL Very high: > or =190 mg/dL *In patients with a history of heart disease and/or diabetes an LDL-C goal of <70 mg/[NAME] should be considered   The National Cholesterol Education Program (NCEP) has set the following guidelines for LDL-C in children and adolescents (ages 2-17 years): Desirable: <110 mg/dL Borderline high: 110-129 mg/dL High: > or =130 mg/dL | Monday through Thursday, Saturday; 3 p.m. | 2 days (not reported on Saturday or Sunday) | 6 days | 1 | 83701 |  |  |  |  | Rochester
[NAME] | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 10 days
[NAME] | Result | LDLC | [NAME] (Beta-Quantification), S | [NAME] (Beta-Quantification), S | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 2089-1 | Cholesterol.in LDL:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 126718d1319832879-running-average-productivity-2011adam
Sheet: Aug

August Valet Totals
PIPER |  |  |  |  | MAIN |  |  |  |  | TOTAL
Average Wait Time |  |  |  |  | Average Wait Time |  |  |  |  | Average Wait Time
Average Storage Length |  |  |  |  | Average Storage Length |  |  |  |  | Average Storage Length
 | Total Parked/            Returned | Average/hour | Scheduled Productive Hours |  |  | Total Parked/            Returned | Average/hour | Scheduled Productive Hours |  |  | Total Parked/            Returned | Average/hour | Scheduled Productive Hours
5:00am-5:59am | 135 | 5.9 | 1 |  | 5:00am-5:59am | 0 | 0 | 0 |  | 5:00am-5:59am | 135 | 2.95 | 1
6:00am-6:59am | 198 | 8.6 | 2 |  | 6:00am-6:59am | 0 | 0 | 0 |  | 6:00am-6:59am | 198 | 4.3 | 2
7:00am-7:59am | 435 | 18.9 | 3.5 |  | 7:00am-7:59am | 66 | 2.9 | 2 |  | 7:00am-7:59am | 501 | 10.9 | 5.5
8:00am-8:59am | 663 | 28.8 | 5 |  | 8:00am-8:59am | 208 | 9 | 2 |  | 8:00am-8:59am | 871 | 18.9 | 7
9:00am-9:59am | 970 | 42.2 | 5.5 |  | 9:00am-9:59am | 285 | 12.4 | 2 |  | 9:00am-9:59am | 1255 | 27.3 | 7.5
10:00am-10:59am | 973 | 42.3 | 5 |  | 10:00am-10:59am | 412 | 17.9 | 3 |  | 10:00am-10:59am | 1385 | 30.1 | 8
11:00am-11:59am | 936 | 40.7 | 5 |  | 11:00am-11:59am | 424 | 18.8 | 3 |  | 11:00am-11:59am | 1360 | 29.75 | 8
12:00pm-12:59pm | 858 | 37.3 | 5 |  | 12:00pm-12:59pm | 421 | 18.3 | 2 |  | 12:00pm-12:59pm | 1279 | 27.8 | 7
1:00pm-1:59pm | 805 | 35 | 5 |  | 1:00pm-1:59pm | 369 | 16 | 2 |  | 1:00pm-1:59pm | 1174 | 25.5 | 7
2:00pm-2:59pm | 746 | 32.4 | 4.5 |  | 2:00pm-2:59pm | 416 | 18.1 | 3 |  | 2:00pm-2:59pm | 1162 | 25.25 | 7.5
3:00pm-3:59pm | 634 | 27.6 | 3.5 |  | 3:00pm-3:59pm | 334 | 14.5 | 3 |  | 3:00pm-3:59pm | 968 | 21.05 | 6.5
4:00pm-4:49pm | 380 | 16.5 | 1.5 |  | 4:00pm-4:49pm | 190 | 8.3 | 2 |  | 4:00pm-4:49pm | 570 | 12.4 | 3.5
5:00pm-5:59pm | 280 | 12.2 | 1 |  | 5:00pm-5:59pm | 134 | 5.8 | 2 |  | 5:00pm-5:59pm | 414 | 9 | 3
6:00pm-6:59pm | 157 | 6.8 | 1 |  | 6:00pm-6:59pm | 130 | 5.7 | 2 |  | 6:00pm-6:59pm | 287 | 6.25 | 3
7:00pm-8:00pm | 0 | 0 | 0 |  | 7:00pm-8:00pm | 73 | 3.2 | 2 |  | 7:00pm-8:00pm | 73 | 1.6 | 2
 | 8170 | 23.68 | 48.5 |  |  | 3462 | 10.06 | 30 |  |  | 11632 | 16.87 | 78.5
Spreadsheet: 583655d1532561967-vlookup-using-2-columns-stocktake
Sheet: Data Entry

UniqueItemCode | EAN | ItemDescription |  | Qty
IS106 |  | LAVISH TOILET BOWL CLEANER 5 LITRE |  |  |  |  |  |  |  | UniqueItemCode |  | Input Data
[NAME] | 5707283538538 | HANDI WIPES |  |  |  |  |  |  |  | EAN |  | Input Data
IS108 | 79814382802127 | DUST PAN
IS109 |  | STEEL WOOL
IS216 | 8805806400786 | PRINTEC BARCODE LABELS 30UPS 150448
IS217 | 6935834003948 | NAME STAND 150 x 80mm
IS218 |  | PO170 POST FIJI SUMMARY PAD
IS219 |  | PF DELIVERY BOOK
IS220 |  | RUBBISH BIN C-706
IS222 |  | TAG RED - AV 8
IS223 |  | CLEAR PLASTIC BAGS - REGISTERED ARTICLES LG-48.5x54x250PCS
IS224 |  | CLEAR PLASTIC BAGS- REGISTERED ARTICLES M-25.5x43x500PCS
IS225 |  | SS26 KWNEW STAPLER
IS226 | 7899050528786 | SCISSORS CHN 8 INCH JNTY
Spreadsheet: 828157d1683265649-consolidated-report-in-one-page-excel-forum-pnl
Sheet: Total

Financial Row | Jan | Feb | Mar
600101 - Sales | 100000 | 120000 | 130000
600105 - Sales Discount / Discount Allowed | -10000 | -12000 | -13000
Total - Revenue
700101 - Cost of Goods Sold | -30000 | -36000 | -39000
700105 - Purchase Discount / Discount Received | 300 | 360 | 390
Total - Cost of Goods Sold
Gross Profit
710101 - Directors' Remuneration | -10000 | -10000 | -10000
710107 - Salary & Bonus | -30000 | -30000 | -30000
710133 - Staff Welfare | -1500 | -1500 | -1500
710135 - Medical Fee | -500 | -500 | -500
Total - Employee Benefit Cost
Nett Profit
Spreadsheet: 732221d1620828596-excel-multiple-column-matching-problem-excelquestion_5-12-21
Sheet: Sheet1

Inout |  |  |  |  | Desired Output
Fruit | New_Old | Number |  |  | Apple | New | 2
Apple | New | 1 |  |  | Apple | Old | 1
Apple | New | 2 |  |  | Pear | New | 1
Apple | Old | 1 |  |  | Orange | Old | 1
Pear | New | 1 |  |  | Plum | Old | 2
Orange | Old | 1 |  |  | Plum | New | 1
Plum | Old | 1
Plum | Old | 2
Plum | New | 1 |  |  | Number
 |  |  |  |  | Fruit | New_Old | Total
 |  |  |  |  | Apple | New | 2
 |  |  |  |  |  | Old | 1
 |  |  |  |  | Orange | Old | 1
 |  |  |  |  | Pear | New | 1
 |  |  |  |  | Plum | New | 1
 |  |  |  |  |  | Old | 2
 |  |  |  |  | Grand Total |  | 8
Spreadsheet: 837230d1689950050-show-different-sheets-on-one-page-according-to-dropdown-selection-test_workbook
Sheet: May

Month | CW | First Name | Last Name | Hours driven | hours parked (in h) | Activities | Comments | Comments 2
May
May | 18 | [NAME] | Smith | 18.5
 |  | [NAME] | [NAME] | 32
 |  | [NAME] | [NAME] | 32
 |  | [NAME] | Bauer | 27
 |  | [NAME] | Parker | 32
May | 19 | [NAME] | Smith | 7 |  |  |  | Test
 |  | [NAME] | [NAME] | 32 |  |  |  | Test2
 |  | [NAME] | [NAME] | 40
 |  | [NAME] | Bauer | 31.5
 |  | [NAME] | Parker | 38.75
May | 20 | [NAME] | Smith | 16
 |  | [NAME] | [NAME] | 40 | 28 | Accident
 |  | [NAME] | [NAME] | 16 |  |  |  | ill
 |  | [NAME] | Bauer | 40
 |  | [NAME] | Parker | 0
May | 21 | [NAME] | Smith | 27.25 | 4 | Sick
 |  | [NAME] | [NAME] | 32 | 1 | Nothing |  | Holiday
 |  | [NAME] | [NAME] | 0
 |  | [NAME] | Bauer | 32
 |  | [NAME] | Parker | 40 | 12 | Service
May | 22 | [NAME] | Smith | 12 | 1 | Service |  | Workshop
 |  | [NAME] | [NAME] | 24
 |  | [NAME] | [NAME] | 16
 |  | [NAME] | Bauer | 20
 |  | [NAME] | Parker | 16 | 16 | Service
Total May |  | [NAME] | Smith
 |  | [NAME] | [NAME]
 |  | [NAME] | [NAME]
 |  | [NAME] | Bauer
 |  | [NAME] | Parker
Spreadsheet: gstorey__12015__TC Turnback March 2001 w April
Sheet: Methods

 | 1. Using the ACE program in Acrobat, extract the ODE tables (both domestic and export = near 400 lines) from [NAME] website into the 6 pages.
 | 2. Paste these pages into the next tab (RAW DATA)
 | 3. Sort out anything that doesn't have EMPRESS as the receipt point
 | ie. | CENTRA GAS ONTARIO INC. | 19980420 | 19981101 | 20081031 | FT | 1944 | 1944 | Empress | WDA
 |  | COCHRANE POWER CORPORATION | 19881201 | 19891201 | 20091130 | FT | 6089 | 6089 | Empress | NDA
 |  | DOMTAR INC. | 19981201 | 19981201 | 20081031 | FT | 3391 | 3391 | Empress | WDA
 | 4. Paste the values into the Data to Date tab carefully (ie don't overwrite the yellow section, which coverts the numbers to usable dates)
 | 5. Paste to Date Ready tab
 | 6. Fix Fuels on Data Ready tab (ie sort by Destination first).
Spreadsheet: 109214d1306153735-indirect-help-777051-indirect-help
Sheet: March

February
Account Number | Account Name | Country | Total Market Value | Cash Value | % Cash
111 | Murphy | UK | 3110 | 70 | 0.022508038585209
222 | Jones | US | 3300 | 200 | 0.06060606060606061
333 | Smith | SCO | 3500 | 150 | 0.04285714285714286
Spreadsheet: 130894d1322648488-concatenation-of-text-in-arrays-with-reference-cells-book3
Sheet: Sheet3

Digits | Frutis | Desired Result
1 | Apple | Apple,Orange,Pine
1 | Apple | Apple
3 | Orange | Orange,Peach
4 | Pine | Pine,Peach
5 | Peach | Peach
6 | Peach | Peach
2 | Pine | Pine
3 | Peach | Orange,Peach
4 | Peach | Pine,Peach
1 | Orange | Pine,Peach
1 | Pine | Pine,Peach
Spreadsheet: 727652d1617997672-formula-for-highest-number-in-3-columns-doc-with-item
Sheet: SD01

Document | Item | SLNo | A formula here that hides all that is strikethrough
3010010577 | 10 | 1
3010010577 | 10 | 2
3010010578 | 10 | 1
3010010578 | 10 | 2 | Would like to only see the highest Slno for each document and Item
3010010579 | 10 | 1
3010010579 | 10 | 2
3010010579 | 20 | 1
3010010579 | 20 | 2
3010010579 | 30 | 1
3010010579 | 30 | 2
3010010612 | 10 | 1
3010010612 | 10 | 2
3010010613 | 10 | 1
3010010613 | 10 | 2
3010010614 | 10 | 3
3010010614 | 10 | 2
3010010614 | 10 | 1
3010010614 | 20 | 2
3010010614 | 20 | 3
3010010614 | 20 | 1
3010010614 | 30 | 2
3010010614 | 30 | 3
3010010614 | 30 | 1
3010010636 | 10 | 1
3010010636 | 10 | 2
3010010636 | 20 | 1
3010010636 | 20 | 2
3010010638 | 10 | 1
3010010638 | 10 | 2
3010010638 | 20 | 1
3010010638 | 20 | 2
Spreadsheet: 118104d1313447486-how-can-i-hide-columns-that-have-no-data-autohide_columns
Sheet: Sheet1

 | EXAM |  |  |  |  | EXAM |  |  |  | EXAM
 | F11 | J10 | [NAME] | J09 | F09 | J08 | F08 | J07 | F07 | J06 | F06 | [NAME] | F05 | J04 | F04 | J03 | F03 | [NAME]
 | SCALE | SCALE | SCALE | SCALE | SCALE | SCALE | SCALE | SCALE | SCALE | SCALE | SCALE | SCALE | SCALE | SCALE | SCALE | SCALE
 | 98.36 | 121.488 | 65.156 | 135.8744 | 52.3 | 123.1 | 80.8 | 82.3 | 79.78455844 | 119.639 | 48.30526316 | 101.8592593 | 24.57241379 | 115.3594793 | 61.1563253 | 80.21972281
 | SPREAD | SPREAD | SPREAD | SPREAD | SPREAD | SPREAD | SPREAD | SPREAD | SPREAD | SPREAD | SPREAD | SPREAD | SPREAD | SPREAD | SPREAD | SPREAD
 | 0.111746 | 0.116107 | 0.11893 | 0.114517 | .11961 | 0.11825 | 0.115563457 | 0.124644 | 0.1145041965 | 0.1167837243 | 0.1221052632 | 0.119074074 | 0.126206897 | 0.115189357 | 0.118483767 | 0.122941143
 | NYMC | NYMC
 | 283.9 | 330 | 276.8 | 267.8 | 319.5 | 267.4 | 300.12 | 269.4 | 330.3 | 280.9 | 287 | 313.95 | 284.9 | 331.9 | 285.98 | 346.39 |  | 322.43
 | 13.4 | 10.9 | 13.6 | 13.4 | 11.75 | 13.2 | 12.98 | 13.9 | 11.82 | 12.88 | 13.47 | 13.25 | 13.25 | 11.9 | 13.97 | 11.25 |  | 13.91
 | F11 | J10 | [NAME] | J09 | F09 | J08 | F08 | J07 | F07 | J06 | F06 | [NAME] | F05 | J04 | F04 | J03 | Feb 2003 | July 2002
 | 55.86 | 38.05 | 47.11 |  | 45.87 | 37.9 | 45.51 | 51.84 |  | 38.76 | 48.64 | 32.76 | 53.5 | 46.36
 | 58.66 | 29.05 | 52.67 |  | 50.88 | 46.66 | 43.57 | 46.08 |  | 42.44 | 63.44 | 47.37 | 53.26 | 44.13
Spreadsheet: 41339d1239811751-identify-list-and-sum-2-columns-test-time-sheet
Sheet: NOV 3-8 08

 | NAME: | JON
 |  |  |  |  | TOTAL HRS
DATE | TIME IN | TIME OUT | TOTAL HRS | JOB NO. | FOR DAY | JOB [NAME] |  |  | OCT. 13-18 |  | OCT. 20-25
2008-11-03 00:00:00 | 05:45:00 | 02:00:00 | 7.75 | SHOP |  |  |  | SHOP | 21.5 |  | SHOP | 28
 | 02:00:00 | 03:00:00 | 1 | 28094 | 8.75 | CNC-P |  | 28090 | 3.5 |  | VACATION | 8
 |  |  |  |  |  |  |  | 28093 | 2.5 |  | 28094 | 4
2008-11-04 00:00:00 | 06:15:00 | 09:00:00 | 2.75 | 28070A |  | CNC-M |  | 28094 | 10 |  | TOTAL | 40
 | 09:00:00 | 03:00:00 | 5.5 | SHOP | 8.25 |  |  | 28097 | 6
 |  |  |  |  |  |  |  | TOTAL | 43.5
2008-11-05 00:00:00 | 06:30:00 | 03:00:00 | 8 | SHOP | 8
 |  |  |  |  |  |  |  |  | OCT. 27-NOV 1
2008-11-06 00:00:00 | 06:30:00 | 03:00:00 | 8 | SHOP | 8 | COMPUTER TROUBLE |  | SHOP | 29.25
 |  |  |  |  |  |  |  | 28070A | 5.75
2008-11-07 00:00:00 | 05:30:00 | 06:30:00 | 1 | 28092 |  | ROBOT - DRILL CASTING |  | 28093 | 2.5
 | 06:30:00 | 07:30:00 | 1 | 28070A |  | CNC-M |  | 28094 | 2.5
 | 07:30:00 | 03:00:00 | 7 | SHOP | 9 |  |  | TOTAL | 40
 |  |  |  |  |  |  |  | VACATION 72.5 HRS
 |  | SHOP | 36.25
 |  | 28094 | 1
 |  | 28070A | 3.75
 |  | 28092 | 1
 |  | JOB #
 |  |  | 42 | TOTAL | 42