tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 113378d1309295616-auto-populate-a-cell-when-3-options-are-selected-all-skus
Sheet: CODES

How to decipher SKU numbers
All SKU numbers can be broken down into 3 parts.  The first 4 numbers (1098, 1198, 1298, etc) represent what the product is (sheet sets, duvet covers, etc).  The 5th and 6th numbers (01-19) represent the size of the product.  The 7th and 8th numbers represent the color of the product.
IE: 10981620 = Sheet Sets (1098) - Queen Size (16) - Ivory Color (20)
Product Type |  |  | Size |  |  | Color
Sheet Sets | 1098 |  | [NAME] | 1 |  | Ivory | 20
Duvet Covers | 1198 |  | Hand Towels | 2 |  | White | 21
[NAME] | 1398 |  | Bath Towels | 3 |  | Sage | 22
Blankets | 1498 |  | Bath Sheets | 4 |  | Blue | 30
Pillowcases | 1598 |  | [NAME] | 7 |  | [NAME] | 31
Shams | 1698 |  | Standard Shams | 8 |  | Plum | 32
Combos | 1998 |  | Decorative Pillows | 9 |  | White / Sage | 23
Towels | 2098 |  | Travel Sizes | 12 |  | White / White | 24
 |  |  | Twin | 13 |  | Mocha / Plum | 33
 |  |  | Twin XL | 14 |  | Mocha / Ivory | 34
 |  |  | Full | 15 |  | Plum / Ivory | 35
 |  |  | Queen | 16 |  | [NAME] | 36
 |  |  | King | 17 |  | Mocha / Sage | 37
 |  |  | [NAME] | 18 |  | Blue / White | 38
 |  |  | [NAME] | 19 |  | Mocha / Blue | 39
 |  |  |  |  |  | [NAME] (KCS) | 50
SKU Generator
Product Type |  |  | Size |  |  | Color |  |  | SKU
Sheet Sets |  |  | Twin |  |  | Ivory
Spreadsheet: 850597d1700976604-overtime-rotation-list-ot-rotation
Sheet: C-crew

Firefighter | Phone | Available? |  | Who Took It?
Employee 1 | [PHONE] | Unavailable |  | Employee 5
Employee 2 | [PHONE] | unavailable
Employee 3 | [PHONE] | Unavailable
Employee 4 | [PHONE]
Employee 5 | [PHONE] | Unavailable
Employee 6 | [PHONE]
Employee 7 | [PHONE]
Employee 8 | [PHONE]
Employee 9 | [PHONE]
Employee 10 | [PHONE] | Unavailable
Employee 11 | [PHONE] | unavailable
Employee 12 | [PHONE] | unavailable
Employee 13 | [PHONE] | unavailable
Employee 14 | [PHONE] | Available
Employee 15 | [PHONE]
 |  | Available
 |  | Unavailable
 |  | Available
 |  | Unavailable
Spreadsheet: 792174d1660760698-use-the-results-from-one-formula-to-find-the-answer-on-a-different-sheet-examplefile-08-17
Sheet: Trailer Plates

ACCT Number | ST | PLATE | EQUIP | VIN | MAKE | YEAR
Spreadsheet: daren_farmer__5743__Equistar Activity 2001
Sheet: 12

 | EQUISTAR  ACTIVITY for January, 2001 |  |  |  |  |  |  | file name: Equistar Activity 2001.xls
 | Effective 1/1/01
 |  |  |  |  | from | to
 | Meter # |  | Deal # | Price ($) | Volume |  | Matrix
 | 1062 |  | 378904 | Greater of $3.22 or Index - $.10 | 3000 |  | ENA
 | 1334 |  |  |  | 0
 | 1373 |  |  | Greater of $2.64 or Index - $.03 | 0 |  | ENA
 | 1373 |  | 380735 | 4.35 or Index-$.10 | 0 |  | HPLC | expired
 | 1373 |  | 378904 | Greater of $3.22 or Index - $.10 | 0 |  | ENA
 | 1373 |  | 165373 | Greater of $2.15 | 10000 |  | HPLC
 | 1373 |  | 128806 | Greater of $2.05 or Index - $.055 | 4000 | 0 | HPLC
 | 1373 |  | 202387 | $2.21 or Index -$.07 | 0 |  | HPLC
 | 1373 |  | 487588 | $2.68 or Index-$.10 | 0 |  | HPLC
 | 1373 |  |  | Greater of $4.08 or Index - $.20 | 5000
 | 1384 |  | 128806 | Greater of $2.05 or Index - $.055 | 1000 | 5000
 | 1384 |  | 240061 | $2.20 or Index -$.05 | 5000 |  | ENA
 | 1384 |  | 378904 | Greater of $3.22 or Index - $.10 | 0 | 2000
 | 1384 |  | 394489 | Greater of $4.08 or Index - $.20 | 0 |  | ENA
 | 1399 |  | 165372 | $2.11or Index -$.07 | 5000 |  | HPLC
 | 1552 |  | 202387 | $2.21 or Index -$.07 | 5000 |  | HPLC
 | 1552 |  | 487588 | $2.68 or Index-$.10 | 5000 |  | ENA
 | 1552 |  | 394489 | $4.08 or Index-$.20 | 5000 |  | ENA
 | 1553 |  | 378904 | $3.22 or Index-$.10 | 2000 | 0 | ENA
 | 8024 |  | 240061 | $2.20 or Index -$.05 | 5000 |  | ENA
 | 1266/1165 |  |  |  | 0 |  | HPLC
 |  |  |  |  | Less: Phillips {1.500/d}, [NAME] {10.0/d}
 |  |  |  |  | Third Party ( Sempra; 20.0/d )
 | NOTE:  Highlighted rows mean changes.
 |  |  |  |  | Note:   Channel / Syngas :    = 15.0/d
 |  |  |  |  | Mcnic ;  10.0 HPL & 5.0 ENA
Spreadsheet: 863443d1710936199-if-statement-or-alternative-grading-etaf
Sheet: Sheet1

Grading | Business Critical | Critical | Major | Minor | Observation |  | Excellent | There are no Non-Compliance issues and no Observations on this audit. | If each column if blank = Blank
Excellent | 0 | 0 | 0 | 0 | 0 |  | Good | There are no Minor Non-Compliances on this audit. (There is at least one Observation.) | If the score in each column is zero the cell populates "Excellent"
Good | 0 | 0 | 0 | 0 | 1 |  | Fair | There are no Major Non-Compliances on this audit. (There is at least one Minor Non-Compliance.) | Business Critical Column (B9) is 1 or more than 1 the cell in All populates "Fail"
Fair | 0 | 0 | 0 | 1 |  |  | Needs Improvement | There are three or fewer (i.e. between 1 and 3) Major Non-Compliances on this audit. | Critical Column (C9) is 1-3 = "Unsatisfactory"
Needs Improvement |  | 0 | 3 |  |  |  | Unsatisfactory | There are four or more Major Non-Compliances on this audit. | Critical Column (C9) is 4 or more than 4 = "Fail"
Unsatisfactory |  | 3 | 4 |  |  |  |  | There are three or fewer (i.e. between 1 and 3) Critical Non-Compliances on this audit. | Major [NAME] (D9) is 1-3 = "Needs Improvement"
Fail | 1 | 4 |  |  |  |  | Fail | There are four or more Critical Non-Compliances on this audit. | Major [NAME] (D9) is 4 or more than 4 = "Unsatisfactory"
 |  |  |  |  |  |  |  | There are one or more Business Critical Non-Compliances on this audit. | Minor Column (E9) is 1 or more than 1 = "Fair"
Factory Result | 0 | 0 | 0 | 0 | 0 |  |  |  | Observation Column (F9) is 1 or more than 1 = "Good"
 |  |  |  |  |  |  |  |  | fail | OR( B9>=1 , c9>=4, E9>=1 )
 |  |  |  |  |  |  |  |  | Unsatisfactory | OR(AND(C9>=1,C9<=3),D9>=4)
 |  |  |  |  |  |  |  |  | Needs Improvement | AND(D9>=1,D9<=3)
 |  |  |  |  |  |  |  |  | Fair | E9>1
 |  |  |  |  |  |  |  |  | good | F9>=1
 |  |  |  |  |  |  |  |  | Excellent | Sum(B9:F9)=0
 |  |  |  |  |  |  |  |  | BLANK | AND(B9="",C9="",D9="",E9="",F9="")
Spreadsheet: 694237d1599470970-extract-every-2nd-row-data-based-value-not-blank-and-criteria-in-column-headers-sample-_1
Sheet: Desired results

 | Date | Time | W's | Data
 | 2020-09-07 00:00:00 |  |  |  |  | From Data sheet extract the values as per this table, under the following rules: Time should be extracted based on the left side and to be returned in increasing order and then the W above and the matching row header. Time will always be the second row for each row header and W will always be the first row. There may be blanks in time rows, and these should be excluded even if the W's are not blank
Spreadsheet: 854220d1704183006-calculating-manhours-according-date-period-manhours
Sheet: Sheet1

Manpower |  |  |  |  |  | Manhours
 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 |  |  | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00
1 | 12 | 12 |  |  |  | 1 |  |  |  |  |  | Start Date
2 | 12 | 45 |  |  |  | 2 |  |  |  |  |  | 2024-01-01 00:00:00
3 | 12 | 67 |  |  |  | 3 |  |  |  |  |  | End Date
4 | 14 |  |  |  |  | 4 |  |  |  |  |  | 2024-02-12 00:00:00
5 | 15 |  |  |  |  | 5 |  |  |  |  |  | Total Manhours
6 |  |  |  |  |  | 6
7 |  |  |  |  |  | 7
8 |  |  |  |  |  | 8
9 |  |  |  |  |  | 9
10 |  |  |  |  |  | 10
11 |  |  |  |  |  | 11
12 |  |  |  |  |  | 12
13 |  |  |  |  |  | 13
14 |  |  |  |  |  | 14
15 |  |  |  |  |  | 15
16 |  |  |  |  |  | 16
17 |  |  |  |  |  | 17
18 |  |  |  |  |  | 18
19 |  |  |  |  |  | 19
20 |  |  |  |  |  | 20
21 |  |  |  |  |  | 21
22 |  |  |  |  |  | 22
23 |  |  |  |  |  | 23
24 |  |  |  |  |  | 24
25 |  |  |  |  |  | 25
26 |  |  |  |  |  | 26
27 |  |  |  |  |  | 27
28 |  |  |  |  |  | 28
29 |  |  |  |  |  | 29
30 |  |  |  |  |  | 30
31 |  |  |  |  |  | 31
Spreadsheet: 750407d1633440636-i-want-that-appears-0-when-no-information-can-be-found-through-a-vlookup-formula-book1
Sheet: Sheet1

N° ORDEN |  | ESTADO | [NAME] | AÑO | EMPRESA | ORDEN
E15001 |  | E | 2014-12-30 00:00:00 | 2015 | CB | WI14092 |  |  |  |  |  | E15001
E15002 |  | E | 2014-12-30 00:00:00 | 2015 | CB | WI14094
E15003 |  | E | 2015-01-05 00:00:00 | 2015 | CB | TJ-001-2015
E15004 |  | E |  | 2015 | CB | S/N
E15005 |  | E | 2015-01-15 00:00:00 | 2015 | CB | TJ002-2015
E15006 |  | E | 2015-01-21 00:00:00 | 2015 | CB | N° 1
E15007 |  | E | 2015-01-21 00:00:00 | 2015 | WTDF | 10242014PO-CF-R
E15008 |  | E | 2015-01-26 00:00:00 | 2015 | CB | S/N
E15009 |  | E | 2015-01-21 00:00:00 | 2015 | CB | CH 012415- SPA
E15010 |  | E | 2015-01-21 00:00:00 | 2015 | CB | PO 5697
I want a formula in column M that adds the next number only when it appears in column A
Because the number has an E in the front I had to use the SUBSTITUTE() formula to make the addition
My problem is that I have E15011 in column M while it is not typed in column A. I want that nothing appears there
Spreadsheet: 273236d1382643338-transferring-data-from-one-worksheet-to-another-combined-20planners-1-
Sheet: Mon Meeting

 | Monday Meeting Attenance |  |  |  |  |  |  | Date | 2013-11-04 00:00:00
Attendance | No | Postion | Name
 | 1234 | Senior Manager | Topping
 | 5678 | Planner | Smith
 | 7685 | Planner | Jones
 | 5764 | Advisor | [NAME]
 | 8572 | Advisor | English
 | 1234 | Senior Manager | Pritchard
 | 5678 | Planner | Davison
 | 7685 | Planner | McGinley
 | 5764 | Advisor | Tyrrell
 | 8572 | Advisor | [NAME]
Spreadsheet: 883616d1732238090-how-to-avoid-circular-references-in-a-user-input-auto-fill-table-components-lookup-jt-
Sheet: Sheet1

 | [NAME] of Materials |  |  |  |  |  |  |  |  |  |  | Production
 | Qty | Item | Qty | Component | Qty | Component | Qty | Component | Qty | Component |  | Desired Volume | Item | Computer | Circuit Board | Electrode | Wire | Copper | Plastic | Gold | Solder | Ore | [NAME] | Total
 | 1 | Computer | 10 | Circuit Board |  | Plastic |  |  |  |  |  | 2 | Computer
 |  |  |  |  |  | Copper |  | Ore
 |  |  |  |  |  | Gold
 |  |  |  |  |  | Solder
 |  |  | 4 | Electrode |  | Wire |  | Copper |  | Ore
 |  |  |  |  |  | Copper |  | Ore
 |  |  |  |  |  | [NAME]
 |  |  | 12 | Wire |  | Copper |  | Ore
 |  |  | 17 | Copper |  | Ore
 |  |  | 5 | Plastic
 | 1 | Circuit Board | 5 | Plastic |  |  |  |  |  |  |  | 1 | Circuit Board
 |  |  | 3 | Copper |  | Ore
 |  |  | 1 | Gold
 |  |  | 2 | Solder
 | 1 | Electrode | 2 | Wire |  | Copper |  | Ore |  |  |  | 0 | Electrode
 |  |  | 3 | Copper |  | Ore
 |  |  | 1 | [NAME]
 | 1 | Wire | 2 | Copper |  | Ore |  |  |  |  |  | 0 | Wire
 | 1 | Copper | 1 | Ore |  |  |  |  |  |  |  | 0 | Copper
 |  |  |  | = Input field
Spreadsheet: 92564d1292121905-displaying-current-day-inventory-in-report-in-store-inventory-test
Sheet: December 2010

December 2010 | 2010-12-05 00:00:00 | 2010-12-06 00:00:00 | 2010-12-07 00:00:00 | 2010-12-08 00:00:00 | 2010-12-09 00:00:00 | 2010-12-10 00:00:00 | 2010-12-11 00:00:00 | 2010-12-12 00:00:00 | 2010-12-13 00:00:00 | 2010-12-14 00:00:00 | 2010-12-15 00:00:00 | 2010-12-16 00:00:00 | 2010-12-17 00:00:00 | 2010-12-18 00:00:00 | 2010-12-19 00:00:00 | 2010-12-20 00:00:00 | 2010-12-21 00:00:00 | 2010-12-22 00:00:00 | 2010-12-23 00:00:00 | 2010-12-24 00:00:00 | 2010-12-25 00:00:00 | 2010-12-26 00:00:00 | 2010-12-27 00:00:00 | 2010-12-28 00:00:00 | 2010-12-29 00:00:00 | 2010-12-30 00:00:00 | 2010-12-31 00:00:00
[NAME] ([NAME], 5 per box) | 5 | 29 | 27 | 21 | 15 | 11 | 19
Chocolate Powder ([NAME], 5 per box) | 8 | 7 | 6 | 5 | 4 | 3 | 0
[NAME] ([NAME], 5 per box) | 33 | 33 | 32 | 32 | 32 | 32 | 31
Pomegranate Powder ([NAME], 5 per box) | 9 | 8 | 8 | 8 | 7 | 6 | 6
[NAME] ([NAME], 5 per box) | 10 | 10 | 9 | 9 | 9 | 8 | 7
[NAME] ([NAME], 5 per box) | 13 | 13 | 13 | 13 | 13 | 13 | 13
[NAME] ([NAME], 5 per box) | 3 | 8 | 7 | 7 | 6 | 6 | 4
[NAME] ([NAME], 4 per box) | 9 | 9 | 8 | 8 | 7 | 6 | 6
Cookies & Cream Powder ([NAME]) | 1.5 | 5.5 | 5.5 | 5.5 | 5.5 | 5.5 | 5
White Chocolate Powder (per box) | 0.75 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5
[NAME] (Bag) | 14.5 | 14.5 | 14.5 | 14.5 | 13.5 | 13.5 | 13.5
[NAME]  (Bag) | 9.5 | 9.5 | 9.5 | 9.5 | 9.5 | 9.5 | 9.5
[NAME] (Bag) | 15 | 15 | 15 | 15 | 15 | 15 | 15
[NAME] (Bottles, 12 per box) | 1.5 | 13 | 13 | 13 | 12.5 | 11.5 | 11.5
[NAME] (Bottles, 12 per box) | 7.5 | 7 | 7 | 7 | 6.5 | 6.5 | 6
[NAME] (Bottles, 12 per box) | 0.5 | 11.75 | 11.25 | 11 | 10.5 | 9.5 | 8
[NAME] (Bottles) | 6.5 | 6.5 | 6.5 | 6.5 | 6.5 | 6.5 | 6.5
[NAME] (Bottles) | 3.5 | 3.5 | 3.5 | 3.5 | 3 | 3 | 3
[NAME] (Bottles) | 7.5 | 7.5 | 7.5 | 7.5 | 6.5 | 6.5 | 6.5
[NAME] (Bottles, 12 per box) | 8 | 8 | 8 | 7 | 6.5 | 6.5 | 6
[NAME] (Bottles, 12 per box)
Pumpkin Syrup (Bottles, 12 per box) | 5 | 5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5
16 oz Cups (box, 500 cups per box) | 0 | 4 | 3 | 2 | 2 | 1 | 3
24 oz Cups (box, 400 cups per box) | 1 | 1 | 1 | 0 | 0 | 0 | 0
16 oz Cup Lids (sleeves, 10 per box) | 0 | 9.5 | 8 | 8 | 8 | 8 | 7.5
Spoons (per box, 1000 per box) | 6 | 5.5 | 5.25 | 4 | 4 | 3.8 | 2.9
[NAME] (Jar) | 7 | 5 | 5 | 5 | 4 | 3 | 2
Instant Coffee (Jar) | 6.5 | 6.5 | 6.5 | 6.5 | 6.5 | 6.5 | 6.5
Funfetti [NAME] (Box) | 18 | 18 | 16 | 14 | 12 | 10 | 6
[NAME] ([NAME], 4 jars per box) | 5 | 4.5 | 4.5 | 4 | 3.5 | 2.5 | 2.25
Milk ([NAME]) |  |  | 82 | 68 | 46 | 96 | 60
Spreadsheet: 198719d1354877518-compare-2-worksheets-show-differences-cmpare-jsts
Sheet: Results

[NAME] 'U' |  | 203 Auburn [NAME]
Product | Qty | Product | Qty | Difference
J21407 | 6 | J21407 | 7
J31409 | 1
 |  | J21410 | 2
[NAME] text in column B | 15 | [NAME] text in column B | 14
J21403 Without text in column B | 1 | J21403 Without text in column B | 6
Spreadsheet: 855241d1704888024-concerting-time-to-degrees-time-and-degrees-aligw
Sheet: Sheet1

TIME | DEGREE | [NAME] | Format
18:00:00 | 0
20:00:00 | 30
21:00:00 | 45 |  |  | 24 | HOURs
22:00:00 | 60 |  |  | 360 | DEGREES
22:48:00 | 72
00:00:00 | 90 |  |  |  | DEGRESS/HOUR
02:00:00 | 120
03:00:00 | 135
03:36:00 | 144
04:00:00 | 150
06:00:00 | 180
08:00:00 | 210
08:24:00 | 216
09:00:00 | 225
10:00:00 | 240
12:00:00 | 270
13:12:00 | 288
14:00:00 | 300
15:00:00 | 315
16:00:00 | 330
18:00:00 | 360
Spreadsheet: 287577d1388869963-locking-2-rows-then-sorting-by-column-book3
Sheet: Logic

 | Customer | Year | Sales | Total Sales | Rank | Rank All
 | AAA | 2010 | 4000
 | AAA | 2011 | 4500
 | BBB | 2010 | 9000
 | BBB | 2011 | 9200
 | CCC | 2010 | 3200
 | CCC | 2011 | 9100
Spreadsheet: louise_kitchen__22553__Hot List Update 07-17-01 - Management
Sheet: Compression -50

Deal Description Sheet - 7/17/01
Compression Services
Project Name | Lead Originator | Counterparty | Description | Potential Valuation | Last Customer Contact | Probability | Expected Closing (Month/Year) | Weekly Updates / Comments
Project Seebreeze Phase II B | [NAME] | TBD | Additional gas procurement into NGL system benefiting Enron net profit interest. | $3.00 MM | N/A | 0.25 | 2001-08-01 00:00:00 | Negotiating with counterparites for wellhead contracts.
Bay Gas | [NAME] ([NAME]) | Bay Gas Storage Co. | 13,000 HP storage facility expansion. | $1.20 MM | 2001-07-11 00:00:00 | 0.25 | 2001-08-01 00:00:00 | Working with customer on terms and conditions.
Cross Timbers | [NAME] | Cross Timbers | 6,200 HP of Gathering Compression | $500 M (early) | 2001-07-16 00:00:00 | 0.25 | 2001-09-01 00:00:00 | Developing proposal.  Meeting with client week of 7/23.
[NAME] | [NAME] ([NAME]) | Duke Energy Field Services | 20,000 HP NGL processing plant retrofit. | $0.81 MM | 2001-07-06 00:00:00 | 0.25 | 2001-09-01 00:00:00 | Met with Duke on 6/6 and presented additional options.  Gathering additional information for detailed proposal.Waiting on CA return.
Project Chile | [NAME] ([NAME]) | ENAP | Chilean field redevelopment - 30,000 + HP. | $2.00 MM | 2001-06-20 00:00:00 | 0.25 | 2001-10-01 00:00:00 | Received revised scope.  Developing proposal.
Kinder Morgan New Caney | [NAME] | Kinder Morgan New Caney | 13,000 HP | $500 M (early) | 2001-06-22 00:00:00 | 0.1 | 2001-10-01 00:00:00 | Waiting on RFP.
Red Cedar Gathering | [NAME] ([NAME]) | Red Cedar | 6,000 HP | $500 M (early) | 2001-07-10 00:00:00 | 0.1 | 2001-11-01 00:00:00 | Met with customer on 7/10.  Developing strategy.
Kinder Morgan CO2 | [NAME] | [NAME] | 34,000 HP | $500 M (early) | 2001-07-13 00:00:00 | 0.1 | 2001-11-01 00:00:00 | Developing strategy.  Meeting with customer on 7/23.
Unocal | [NAME] (Meyer) | Unocal | 7,000 HP grass roots station. | $0.50 MM | 2001-06-25 00:00:00 | 0.25 | 2001-12-01 00:00:00 | Customer is reviewing proposal.  Unocal recently received gas driven compression proposals and is in the process of doing comparative evaluation.
Explorer P/L Expansion | [NAME] | Explorer P/L | Explorer P/L expansion. | $500 M (early) | 2001-06-26 00:00:00 | 0.1 | 2001-12-01 00:00:00 | Developing strategy.  Flowserve setting meeting. Working on power pricing & structure via EGM.
Citgo Lakemont P/L | [NAME] | Citgo Lakemont P/L | Lake Charles 1,500 HP; Port Arthur 1,000 HP; Houston 1,000 HP | $500 M (early) | 2001-06-26 00:00:00 | 0.1 | 2001-12-01 00:00:00 | Developing strategy.
MCN Belle River Mills | Meyer | MCN / DTE | Storage facility upgrade and expansion 10,000 HP | $500 M (early) | 2001-07-12 00:00:00 | 0.1 | 2001-12-01 00:00:00 | Initial proposal sent 7/12/01.
TECO Eagle/Downing Stations | Meyer | TECO Eagle Station | Proposed HP to support proposed FP&L plant.  6,000 HP to 12,000 HP | $500 M (early) | 2001-07-09 00:00:00 | 0.1 | 2001-12-01 00:00:00 | HP addition predicated on Marcus Hooks (FP&L) plant.  Initial proposal sent.
( ) = Denotes Backup/Oversight Role
Spreadsheet: 94444d1294257405-sumif-formula-book1
Sheet: January

Method In-Bound |  | Customer | Lot Number | Date Received | Date Complete | Material | Size | Comments (Wet, Dry, Etc.) | [NAME] (Lbs) | [NAME] (Lbs) | Reported [NAME] (Lbs) | Reported Gain (Lbs) | Reported Loss (Lbs) | Reported Loss Percentage | Actual Gain (Lbs) | Actual Loss (Lbs) | Actual Loss Percentage
 |  |  |  |  |  |  |  |  |  | 323520 | 322520 |  | 1000
 | BARGE
 | CONTAINERS
 | PROCESSING |  |  |  |  |  |  |  |  | 323520 | 324520 | 1000
 | RAIL
 | TRUCK
Spreadsheet: 2bc73bd0-2bc4-410c-b8f2-f696ec39c4a2
Sheet: Sheet1

Table ST1 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Cumulative SAGE tag total in all 12 retinal libraries | Total tags | Total unknown tags | Fraction unknown
1 or greater | 119781 | 42549 | 0.3552232824905452
2 or greater | 43839 | 4367 | 0.09961449850589657
3 or greater | 26633 | 1549 | 0.05816092817181692
4 or greater | 19864 | 828 | 0.04168344744260975
5 or greater | 16216 | 551 | 0.03397878638381845
6 or greater | 13837 | 404 | 0.0291970802919708
7 or greater | 12124 | 320 | 0.02639392939623886
8 or greater | 10796 | 265 | 0.02454612819562801
9 or greater | 9779 | 221 | 0.02259944779629819
10 or greater | 8945 | 185 | 0.02068194522079374
Total tags | 651759
Spreadsheet: 99101d1297859126-linking-or-grabbing-data-from-400-workbooks-branch2
Sheet: Sheet1

OFFICE | TO / FROM | P01 | P02
Branch2 | 786 | 987 | 546
Branch2 | 5 | 98 | 6
Branch2 | 78 | 79 | 54
Branch2 | 6 | 879 | 6
Branch2 | 57 | 7 | 64
Branch2 | 687 | 54 | 6
Branch2 | 87 | 0 | 546
Branch2 | 5 | 4 | 3543
Branch2 | 8787 | 4 | 786
Branch2 | 87 | 35 | 8
Branch2 | 98 | 3 | 5687
Branch2 | 98 | 5 | 56
Branch2 | 9 | 5 | 75
Branch2 | 87 | 1 | 2
Branch2 | 4 | 786 | 1
Branch2 | 42 | 76 | 1
Branch2 | 5 | 86 | 87
Branch2 | 4125 | 5 | 1
Branch2 | 0 | 54 | 21
Branch2 | 8 | 6 | 21
Spreadsheet: af90bf15-5176-4296-80b0-e161f68613db
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7249 | 5410 | Jessica | [NAME] | FRA | 21 | 00:19:10 | 00:00:32 | 01:07:55 | 00:00:50 | 00:37:27 | 1 | 02:05:51
7249 | 5539 | Carole | Peon | FRA | 23 | 00:19:10 | 00:00:33 | 01:07:55 | 00:00:49 | 00:37:27 | 2 | 02:05:52
7249 | 7781 | Rebecca | Robisch | GER | 24 | 00:21:02 | [NAME] | 01:12:38 | [NAME] | 00:36:13 | 3 | 02:11:21
7249 | 11141 | [NAME] | Charayron | FRA | 22 | 00:21:03 | 00:00:32 | 01:13:54 | 00:00:55 | 00:39:22 | 4 | 02:15:44
Spreadsheet: 240139d1370232786-text-to-column-help-need-for-inconsistent-seperator-number-text-separate
Sheet: Sheet1

Original Data | Number | Text
10 Capital and reserves1 | 10 | Capital and reserves1
101 Capital1 | 101 | Capital1
1011 Subscribed capital not paid | 1011 | Subscribed capital not paid
1012 Subscribed capital paid | 1012 | Subscribed capital paid
1015 [NAME] (autonomous public sector entities) | 1015 | [NAME] (autonomous public sector entities)
1016 Public patrimony2 | 1016 | Public patrimony2
104 Premium related to capital | 104 | Premium related to capital
1041 Share premium | 1041 | Share premium
1042 Merger premium | 1042 | Merger premium
1043 Share premium contribution in kind | 1043 | Share premium contribution in kind
1044 Debenture conversion premium | 1044 | Debenture conversion premium
105 Revaluation reserve | 105 | Revaluation reserve
106 Reserves | 106 | Reserves
1061 Legal reserve | 1061 | Legal reserve
1063 Statutory or contractual capital reserve | 1063 | Statutory or contractual capital reserve
1064 Fair value reserve3 | 1064 | Fair value reserve3
1065 Reserve representing the revaluation reserve surplus | 1065 | Reserve representing the revaluation reserve surplus
1067 Reserves from foreign exchange differences in respect to a net investment in a foreign [NAME] | 1067 | Reserves from foreign exchange differences in respect to a net investment in a foreign [NAME]
1068 Other reserves | 1068 | Other reserves
107 Conversion reserve4 | 107 | Conversion reserve4
108 Minority interest5 | 108 | Minority interest5
1081 Minority interest - profit (loss) for the period | 1081 | Minority interest - profit (loss) for the period
1082 Minority interests – other own capital | 1082 | Minority interests – other own capital
109 Own shares | 109 | Own shares
1091 Short-term own shares | 1091 | Short-term own shares
1092 Long-term own shares | 1092 | Long-term own shares
1095 Shares of the absorbing entity owned by the entity absorbed | 1095 | Shares of the absorbing entity owned by the entity absorbed
11 Retained earnings | 11 | Retained earnings
117 Retained earnings | 117 | Retained earnings
1171 Profit/loss carried forward | 1171 | Profit/loss carried forward