tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: daren_farmer__5248__BMSPT051
Sheet: BMSPT066

BAMMEL STORAGE ACTIVITY
VOLUME SPLIT BY Counterparties
2001-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | SWING CONTRACT VOLUMES |  |  |  |  | ECT LONG/(SHORT) |  |  |  | LONG/(SHORT)
 |  | HPL INDEX |  |  | HPL FIXED PRICE |  |  |  |  | TOTAL | HL&P | CP&L | TUFCO | TOTAL |  | ECT FIRST OF THE MONTH | TUFCO/ HL&P/ CP&L SWING VOLUME | ECT LONG OR (SHORT) |  | ECT TOTAL | HPLC Excluding 3rd Party | Net LONG/ (SHORT)
 |  | MTD Adjustment | CURRENT DAY | Total | MTD Adjustment | CURRENT DAY | Total | 3rd Party | HPLC Total |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  | Reinject Fees
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Injected Volume | Value
Beginning Balance
1 | Scheduled |  |  |  |  |  |  |  |  |  | 0 | 0
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Estimated
 | Estimated
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Index: | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fuel: | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fuel Rate:
Ending Balance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prod.[NAME]:
Variances:
Total Projected
April 28 thru May 4
May 5 thru May 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Previous Position: |  | 924765
May 12 thru May 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]:
May 19 thru May 25
Spreadsheet: 864940d1712068714-need-to-query-specific-data-from-2-tables-test-timeline-v1-newtonus_prime-
Sheet: Complete Timeline DIG+FAB

 |  |  | DO NOT EDIT THIS SHEET- IT IS A REFERENCE SHEET!  DATA IS PULLED HERE FROM DIGITAL AND FABRIC TABS.
 |  |  |  |  | Total Press Time
 |  |  |  |  | Total Pieces
Press | SchedTime | Due Date | Job# | Line# | Master [NAME] | QTY | H | W | Material | Sides | PrintMode | Kitting | #OfKits | Notes | DateRecieved | SqFt | LinearFT
Spreadsheet: 851339d1701544358-i-need-to-populate-data-in-cells-when-option-is-selected-sample_jt
Sheet: Sheet1

IT Dept |  |  |  | Fire Dept |  |  |  | HR Dept |  |  |  | IT Dept
1 | [NAME] | 34 |  | 10 | Yunus [NAME] | 34 |  | 20 | [NAME] | 33
2 | Lukas George | 35 |  | 11 | [NAME] | 21 |  | 21 | [NAME] | 32
3 | [NAME] | 23 |  | 12 | [NAME] | 19 |  | 22 | [NAME] | 29
Spreadsheet: b250f8e1-ae55-41ac-9361-88106a2111a7
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
10/31/2014 | Women's Basketball | Wheeling Jesuit (exhibition) | 07:00 PM | W, 87-49
11/15/2014 | Women's Basketball | Eastern Kentucky (Preseason WNIT) | 07:00 PM | W, 67-42
11/17/2014 | Women's Basketball | [NAME] (Preseason WNIT) | 07:00 PM | W, 89-87
11/20/2014 | Women's Basketball | at Mississippi State (Preseason WNIT Semifinals) | 08:00 PM | L, 74-61
11/26/2014 | Women's Basketball | Evansville | 07:00 PM | W, 83-39
11/29/2014 | Women's Basketball | Fairfield | 02:00 PM | W, 67-53
12/03/2014 | Women's Basketball | at Fairleigh Dickinson | 07:00 PM | W, 80-52
12/06/2014 | Women's Basketball | Coppin State | 04:00 PM | W, 83-43
12/10/2014 | Women's Basketball | Duquesne | 07:00 PM | W, 79-60
12/13/2014 | Women's Basketball | IPFW | 04:00 PM | W, 82-48
12/20/2014 | Women's Basketball | vs. [NAME] (Chesapeake Energy Capital Classic) | 04:00 PM | W, 69-56
12/22/2014 | Women's Basketball | at Ohio State | 02:00 PM
12/29/2014 | Women's Basketball | [NAME] (Pa.) | 07:00 PM
01/04/2015 | Women's Basketball | at Oklahoma * | 04:30 PM
01/07/2015 | Women's Basketball | at Texas * | 08:00 PM
01/10/2015 | Women's Basketball | Baylor * | 03:00 PM
[NAME] | Women's Basketball | Texas Tech * | 07:00 PM
01/17/2015 | Women's Basketball | at Oklahoma State * | 02:30 PM
01/21/2015 | Women's Basketball | Kansas State * | 07:00 PM
01/24/2015 | Women's Basketball | at Kansas * | 02:00 PM
01/28/2015 | Women's Basketball | at Texas Tech * | 08:00 PM
02/01/2015 | Women's Basketball | Oklahoma * | 02:00 PM
02/04/2015 | Women's Basketball | TCU * | 07:00 PM
02/07/2015 | Women's Basketball | at Iowa State * | 07:00 PM
02/10/2015 | Women's Basketball | Kansas * | 07:00 PM
02/15/2015 | Women's Basketball | at Baylor * | 05:00 PM
02/18/2015 | Women's Basketball | Oklahoma State * | 07:00 PM
02/21/2015 | Women's Basketball | Iowa State * | 12:00 PM
02/24/2015 | Women's Basketball | at TCU * | 08:00 PM
03/01/2015 | Women's Basketball | Texas * | 01:00 PM
03/03/2015 | Women's Basketball | at Kansas State * | 08:00 PM
Spreadsheet: d9bcf891-1a6f-4026-a852-112c7fb4ea5f
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
TWRP | Test | TWRP | Tropheryma whipplei, Molecular Detection, PCR | Tropheryma whipplei PCR | Rapid Polymerase Chain Reaction (PCR) (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | EDTA (lavender-top) tube: EDTA OR [NAME], sterile container: SrwStlCont OR |  |  | 5 | [NAME] | Specimens grossly contaminated with blood may inhibit the PCR and produce false-negative results.   The high sensitivity of amplification by PCR requires the specimen to be processed in an environment in which contamination of the specimen by [NAME] whipplei DNA is not likely.   Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen.   Submit only 1 of the following specimens:   Specimen Type: Biopsy Sources:  Preferred: Small intestine tissue (duodenum, ileum, or [NAME]) Acceptable: Tissue or biopsy specimen of brain, gastrointestinal tissue, heart valve, lymph node, small intestine, synovial tissue, or other visceral tissue fixed in a paraffin block Container/Tube: Sterile container [NAME]: Entire collection Collection Instructions: Collect fresh tissue specimen. Specimen Stability Information: Frozen (preferred)/Refrigerated <48 hours   Specimen Type: Fluid Sources: Spinal, synovial, or vitreous humor  Container/Tube: Sterile vial [NAME]: 0.5 mL Specimen Stability Information: Refrigerated (preferred)/Frozen | Spinal Fluid, Synovial Fluid, or | Hemolysis	NA Thawing	Warm OK; Cold OK-note to lab Lipemia	NA Icterus	NA Other	Green top (heparin) tube | Not applicable | Monday, Wednesday, Friday; 8 a.m. | 2 days | 7 days | 1 | 87798 |  |  |  |  | Rochester
TWRP | [NAME] | VARIES | Varies |  |  |  | See instructions
TWRP | Order Question | SRC56 | [NAME] |  | Plain Text
TWRP | Result | SRC56 | Specimen source | Specimen source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
TWRP | Result | 22302 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42602-3 | Tropheryma whippelii DNA:ACnc:Pt:[NAME]:Ord:Probe.amp.tar
Spreadsheet: 828929d1683798282-search-a-text-from-an-array-of-values-s666-pq-search-a-text-from-an-array-of-values
Sheet: Data

Text | Find Object | Cheese | Expected Result
1.  Hours and [NAME] (P311221) |  |  | P311221
1. RMA Revisions - P400511 (ZJDE0001) |  |  | P400511
6. Preference Profile (R40400) |  |  | R40400
12. Specify P4113 version to use (Recognize blank LOTS) custom PO's from P4113 to hold TO_LOCATION lot status even though it is blank.   Note - this option is used inline with above PO option value -1.    Default - ZJDE0001 |  |  | P4113
2. Enter Version for R04110ZA |  |  | R04110ZA
1. Enter Version for R47011 : |  |  | R47011
3.  Enter the version for [NAME] (cvt to .txt) to call.       Blank = Version XBX0002 with the country        code defined here. |  |  | [NAME]
12. P42101 [NAME] |  |  | P42101
1. R42565 Version |  |  | R42565
3. Test Results Revisions (P3711) |  |  | P3711
3.  [NAME] (P43512) |  |  | P43512
8. Tickler Version [P5900088] |  |  | P5900088
Spreadsheet: 759894d1639785800-how-to-check-two-columns-for-conditions-return-info-from-another-table-unique-value-multiple-column-sample
Sheet: Manual table

Unique value | Owner
C | [NAME]
D | [NAME]
FE | George
G | [NAME]
I | [NAME]
JK | Sean
LOI | [NAME]
MJ | [NAME]
N | [NAME]
BP | [NAME]
Y | [NAME]
Q | Sean
Spreadsheet: 649072d1573463173-help-in-filtering-some-data-and-group-them-test-classes
Sheet: Sheet1

 |  |  |  |  | First |  |  | Second
 | status | Name | year |  | D-Hour-1 | Court | Coach | D-hour-2 | Court | Coach
 | active | [NAME] | 2019 | 2 | Mo 18-19 | Blue | Kets John | Tue 20-21 | Blue | Kets John
 | active | Ray | 2019 | 2 | Mo 18-19 | Blue | Kets John | Sat 11-12 | Green | [NAME]
 | active | [NAME] | 2019 | 1 | Tue 20-21 | Blue | [NAME]
 | active | [NAME] | 2019 | 2 | Fr 16-17 | Green | Roz Pri | Sat 11-12 | Green | [NAME]
 | active | Nck | 2018 | 1 | Fr 16-17 | Blue
 | active | [NAME] | 2019 | 2 | Mo 18-19 | Blue | Kets John | Tue 20-21 | Blue | Kets John
 | active | Helen | 2019 | 2 | Tue 20-21 | Blue | [NAME]
 | active | [NAME] | 2018 | 3 | Fr 16-17 | Blue | Roz Pri | Sat 11-12 | Green | [NAME]
 |  | DATA I WANT TO SHOW
 |  | Mo 18-19 | Blue | Tue 20-21 | Blue | Fr 16-17 | Green | Sat 11-12 | Green
 |  |  |  | [NAME] |  | [NAME] |  | Ray
 |  |  |  | Helen |  | Nck |  | [NAME]
 |  |  |  | [NAME] |  | [NAME] |  | [NAME]
 | WRONG |  |  | [NAME]
 |  | I USE             =INDEX(C5:C12;MATCH("Mo 18-19";F5:F12;0))
 |  | In this example my problems are that :
 | 1 | In    Mo 18-19      the names are only the first three    Bob,[NAME],[NAME]   and it shows again the last name. It doesn’t stop showing
 | 2 | How to make it 'grab' names from the second row too that I use ( D-hour-2). In the example for the    Tue 20-21
Spreadsheet: 1364d387-3504-4681-a05e-076ee2ab9424
Sheet: Start Here - Data Entry 

 |  |  |  |  |  |  | - Enter in White Cells -
 | School Name |  | Ashley ES
 |  |  |  |  |  |  |  | Step 1 - Build your school
 | School Type |  |  | 1 |  |  |  | Enter student and school demographics in the white cells.
 | (Scroll in Drop [NAME]) |  |  |  |  |  |  | It's imporant to be as thorough as possible to ensure Student
 |  |  |  |  |  |  |  | Based Budget (SBB) Revenue is calculated appropriately.
 | Multiple Pathways Center |  |  | no
 | (Select From Down Box)
 |  |  |  |  | YEAR 0 | YEAR 1 | YEAR 2 | YEAR 3 | YEAR 4 | YEAR 5
 |  | Salary Growth |  |  | 0 | 0.015 | 0.02 | 0.015 | 0.01 | 0.01
 |  | Free and Reduced Lunch Percentage |  |  | NA | 0.96 | 0.94 | 0.92 | 0.9 | 0.89
 |  | Are you currently an SPF red school? |  |  | 2 | 2 | 2 | 2 | 2 | 2
 |  | SPF Rating Growth from prior year |  |  | 3 | 4 | 6 | 6 | 6 | 5
 |  | (Scroll in Drop [NAME])
 |  | Spanish Speaking Students |  |  | NA | 222 | 235 | 225 | 245 | 275
 |  | If a 6-12 school, # of grades 6-8 |  |  | NA | 0 | 0 | 0 | 0 | 0
 |  | If a 6-12 school, # of grades 9-12 |  |  | NA | 0 | 0 | 0 | 0 | 0
 |  | CELA 1, 2 and 3 Students |  |  | NA | 165 | 170 | 175 | 180 | 185
 |  | ECE Enrollment |  |  | NA | 32 | 32 | 32 | 32 | 32
 |  | Kinder Enrollment |  |  | NA | 84 | 84 | 84 | 84 | 84
 |  | Grades 1 - 5 Enrollment |  |  | NA | 300 | 324 | 348 | 372 | 396
 |  | Grades 6 - 8 Enrollment |  |  | NA | 0 | 0 | 0 | 0 | 0
 |  | Grades 9 - 12 Enrollment |  |  | NA | 0 | 0 | 0 | 0 | 0
 |  | Total Enrollment |  |  | NA
 |  | Number of Center Programs |  |  | NA | 2 | 2 | 2 | 2 | 2
 |  | GT Enrollment (input only grades K-8) |  |  | NA | 30 | 30 | 30 | 38 | 38
 |  | Mild Moderate Enrollment |  |  | NA | 29 | 30 | 32 | 33 | 35
 |  | ECE Slots |  |  | NA | 2 | 2 | 2 | 2 | 2
 |  | Kinder Slots |  |  | NA | 3 | 3 | 3 | 3 | 3
 |  | yes
 |  | no
Spreadsheet: 268810d1380832724-sumproduct-formula-working-on-all-but-one-worksheet-2012-inpt-mb
Sheet: July

July |  |  |  |  |  |  | 7
Expenses | Total Expenses HTG | Total Expenses USD | Inpatient Total HTG | Inpatient Total USD | Outpatient Total HTG | Outpatient Total USD
bongu/juice
formula
patient food
medical supplies
medical services
medication
x-ray
office supplies
photocopy
other transportation
outpatient nurse for injections
employee compensation
school
other expenses
phone list
physical phone
telephone minutes
oxygen
volunteer expenses
patient transportation
Spreadsheet: 768557d1645025036-how-to-skip-blank-or-n-a-in-vlookup-skip-vlookup
Sheet: Stock Accessories

 | Item | Qty | Remaining | Expected Result
 | HDMI Cable | 30 |  | 25
 | USB Headset | 30 |  | 6
 | [NAME] | 30 |  | 2
 | USB-C -> VGA | 30
 | USB-C Power Adapter | 30 |  | 29
Spreadsheet: 678474d1589907963-text-with-fixed-length-test
Sheet: Sheet1

 |  |  |  |  | Required LINEUP Number
Sarojben | 9 |  |  |  | Sarojben                         9
Hema | 6 |  |  |  | Hema                              6
Charmi | 21 |  |  |  | Charmi                          21
[NAME] | 6 |  |  |  | [NAME]6
[NAME] | 3 |  |  |  | [NAME]
Krinal | 11 |  |  |  | Krinal                             11
Jignesh | 8 |  |  |  | Jignesh                            8
Spreadsheet: 868966d1715672271-combine-rank-and-sumif-to-rank-stores-by-total-sales-rank
Sheet: Sheet1

Store number | Product code | Total Sales | Total store sales | Store Rank | Store Rank
1 | A | 1 |  |  | 4
1 | B | 9 |  |  | 4
1 | D | 3 |  |  | 4
2 | F | 1 |  |  | 5
2 | A | 1 |  |  | 5
2 | B | 3 |  |  | 5
3 | C | 6 |  |  | 1
3 | B | 8 |  |  | 1
3 | A | 10 |  |  | 1
4 | E | 5 |  |  | 2
4 | D | 5 |  |  | 2
4 | A | 5 |  |  | 2
5 | B | 5 |  |  | 2
5 | D | 5 |  |  | 2
5 | C | 5 |  |  | 2
Spreadsheet: 526205d1499184805-need-copy-data-according-to-other-value-in-other-cell-trial
Sheet: Sheet1

Pppp | GERY
Date | 2017-07-05 00:00:00
No. | 111111
Shift | SH#2
RUN time | 1St
Status | XED |  |  |  |  |  |  |  | Date
me | Pppp | No. | Date | Shift | Run Time | Status |  |  | 2017-07-04 00:00:00 | 2017-07-05 00:00:00 | 2017-07-06 00:00:00
 |  |  |  |  |  |  |  | AAA1 | Present | Present
 |  |  |  |  |  |  |  | AAA2 | Present | Present
 |  |  |  |  |  |  |  | AAA3 | Absent | Present
 |  |  |  |  |  |  |  | AAA4 | Present | Present
 |  |  |  |  |  |  |  | AAA5 | Present | Present
 |  |  |  |  |  |  |  | AAA6 | Present | Present
 |  |  |  |  |  |  |  | AAA7 | Present | Absent
 |  |  |  |  |  |  |  | AAA8 | Present | Present
 |  |  |  |  |  |  |  | AAA9 | Present | Absent
 |  |  |  |  |  |  |  | AAA10 | Present | Present
 |  |  |  |  |  |  |  | AAA11 | Present | Present
 |  |  |  |  |  |  |  | AAA12 | Present | Present
 |  |  |  |  |  |  |  | AAA13 | Present | Present
Result needed no AAA3 because its absent
me | Pppp | No. | Date | Shift | Run Time | Status
Spreadsheet: 585907d1534070864-time-vlookup-error-rad
Sheet: Sheet3

 | Time | Decay Factor
 | 00:00:00 | 1
 |  | 0.981
 |  | 0.962
 |  | 0.944
 |  | 0.926
 |  | 0.908
 |  | 0.891
 |  | 0.872
 |  | 0.857
 |  | 0.841
 |  | 0.825
 |  | 0.809
 |  | 0.794
 |  | 0.778
 |  | 0.764
 |  | 0.749
 |  | 0.735
 |  | 0.721
 |  | 0.707
 |  | 0.693
 |  | 0.68
 |  | 0.667
 |  | 0.655
 |  | 0.642
 |  | 0.63
 |  | 0.618
 |  | 0.606
 |  | 0.595
 |  | 0.583
 |  | 0.572
 |  | 0.561
 |  | 0.55
 |  | 0.54
 |  | 0.53
 |  | 0.519
 |  | 0.509
Spreadsheet: 724398d1616146638-count-with-filter-applied-test
Sheet: Dati

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Under 1,5 2H - Un 0,5 1H | Under 2,5 2H - Un 0,5 1H
 |  |  |  |  | PRONOSTICO |  |  |  |  |  |  |  |  |  |  |  |  | CASA 1T | OSP 1T | CASA F | OSP F
 |  |  |  |  | UNDER 2,5 |  |  |  |  |  |  |  |  |  |  |  | - | 0 | 1 | 0 | 1
 |  |  |  |  | UNDER 3,5 |  |  |  |  |  |  |  |  |  |  |  | - | 0 | 1 | 0 | 1
 |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | - | 0 | 2 | 2 | 2
 |  |  |  |  | UNDER 3,5 |  |  |  |  |  |  |  |  |  |  |  | - | 3 | 0 | 5 | 1
 |  |  |  |  | DISPARI |  |  |  |  |  |  |  |  |  |  |  | - | 3 | 0 | 5 | 1
 |  |  |  |  | GOL |  |  |  |  |  |  |  |  |  |  |  | - | 0 | 0 | 1 | 0
 |  |  |  |  | OVER 2,5 |  |  |  |  |  |  |  |  |  |  |  | - | 0 | 0 | 1 | 0
 |  |  |  |  | MULTIGOL 3-6 |  |  |  |  |  |  |  |  |  |  |  | \ | 0 | 0 | 1 | 0
 |  |  |  |  | DISPARI |  |  |  |  |  |  |  |  |  |  |  | - | 1 | 1 | 2 | 1
 |  |  |  |  | GOL |  |  |  |  |  |  |  |  |  |  |  | - | 0 | 0 | 0 | 0
 |  |  |  |  | GOL |  |  |  |  |  |  |  |  |  |  |  | - | 0 | 0 | 0 | 0
 |  |  |  |  | OVER 2,5 |  |  |  |  |  |  |  |  |  |  |  | - | 0 | 0 | 0 | 0
 |  |  |  |  | OVER 1,5 |  |  |  |  |  |  |  |  |  |  |  | - | 0 | 0 | 0 | 0
 |  |  |  |  | 1X + GOL |  |  |  |  |  |  |  |  |  |  |  | \ | 0 | 0 | 0 | 0
 |  |  |  |  | X2 + GOL |  |  |  |  |  |  |  |  |  |  |  | \ | 0 | 0 | 0 | 0
 |  |  |  |  | HOME SCORE |  |  |  |  |  |  |  |  |  |  |  | - | 0 | 0 | 0 | 0
 |  |  |  |  | X2 |  |  |  |  |  |  |  |  |  |  |  | - | 1 | 3 | 1 | 4
 |  |  |  |  | GOL |  |  |  |  |  |  |  |  |  |  |  | - | 1 | 3 | 1 | 4
 |  |  |  |  | GOL |  |  |  |  |  |  |  |  |  |  |  | - | 1 | 1 | 3 | 1
Spreadsheet: 46618fa4-67bc-4d91-b819-4178a792cb87
Sheet: Sheet1

Table 2--World cotton supply and use estimates | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  |  |  |  |  | 2012/13
Item | 2011/12 |  | June |  | July |  | Aug.
 | Million 480-lb. [NAME]
Supply:
Beginning stocks--
World | 49.52 |  | 67.32 |  | 66.68 |  | 67.8
Foreign | 46.92 |  | 64.12 |  | 63.38 |  | 64.5
Production--
World | 122.67 |  | 115.29 |  | 113.81 |  | 114.11
Foreign | 107.1 |  | 98.29 |  | 96.81 |  | 96.46
Imports--
World | 44.33 |  | 36.97 |  | 37.39 |  | 37.2
Foreign | 44.31 |  | 36.97 |  | 37.39 |  | 37.19
Use:
[NAME] use--
World | 105.38 |  | 109.01 |  | 108.98 |  | 108.16
Foreign | 102.08 |  | 105.51 |  | 105.58 |  | 104.76
Exports--
World | 44.34 |  | 36.95 |  | 37.39 |  | 37.21
Foreign | 32.62 |  | 25.15 |  | 25.29 |  | 25.11
Ending stocks--
World | 67.8 |  | 74.51 |  | 72.39 |  | 74.67
Foreign | 64.5 |  | 69.61 |  | 67.59 |  | 69.17
 | Percent
Stocks-to-use ratio:
World | 64.3 |  | 68.4 |  | 66.4 |  | 69
Foreign | 63.2 |  | 66 |  | 64 |  | 66
 | 3
Last update: 08/13/12.
Source: USDA, World Agricultural Outlook Board.
Spreadsheet: 725964d1617001994-need-help-to-simplify-the-formula-eosb-computation-v2-1-
Sheet: EOSB Computation 

 | Nature of Leaving | Basic Salary per month | Joining Date | Leaving Date | Years of Service | Calculated EOSB
 | Termination | 5000 | 2019-11-01 00:00:00
 |  |  |  |  | JT formula |  | JT result based on 1st formula provided
Row # | Nature of Leaving | Year of Service | Entitlement
A9 | Termination | upto 1 Year | No end of service benefits |  | Service | Entitlement | [NAME] | Term
A10 | Termination | 1 to 5 Years | 21 days of salary for every completed years of service |  | 0 | 0 | 1 | 0
A11 | Termination | 5 years and above | 31 days of salary for every completed years of service |  | 1 | 21 | 1 | 0.3333333333333333
A12 |  |  |  |  | 3 | 21 | 1 | 0.6666666666666666 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Resignation
A13 | Resignation | upto 1 Year | No end of service benefits |  | 5 | 31 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Termination
A14 | Resignation | 1 to 3 Years | One third of total entitlement computed as per above slabs ([NAME] and A11)
A15 | Resignation | 3 to 5 Years | Two third of total entitlement computed as per above slabs (Rows 9,10 and 11)
A16 | Resignation | 5 years and above | Full entitlement as per the computation done in accordance with above slabs ([NAME] and A11)
 | Term | Salary per month | Days for computation | Years of Service | Termination | Resignation
 | 1-5 years | 5000 | 21
 | 5 and above Years | 5000 | 31
 |  | Annual Salary | Entitlement days
 |  | New formula |  | Old formula
 |  |  |  | [NAME]
 |  |  |  | JT
Spreadsheet: 2123dfe1-2e96-4ba4-af22-efce0955762f
Sheet: Sheet1

Figure 11.13 Impact of invasive alien species on species at EU level | Unnamed: 1 | Unnamed: 2
Source: IUCN,2009, 2010
 | Threatened | Non-Threatened
 | B | B
Amphibians | 22.22222222222222 | 45.3125
Reptiles | 33.33333333333333 | 8.24742268041237
Terrestrial Mammals | 20 | 6.25
Marine Mammals | 16.66666666666666 | 0
Butterflies | 26.7 | 0.8
Dragonflies | 9.1 | 0
All | 22.4 | 6.8
Spreadsheet: 275744d1383632043-concatenate-a-range-based-on-cell-values-concatenate-until-round-trip
Sheet: Sheet1

Given | Out put desired (Using Formula)
ADDKRT
[NAME]
Round Trip | ADDKRTADD
ADDJNB
JNBDAR
DARADD
Round Trip | ADDJNBDARADD
ADDHKG
HKGMAAADD
Round Trip | ADDHKGMAAADD
-
HKGMAAADD
Round Trip | HKGMAAADD
ADDCAIBRU
BRUDXBHKG
HKGMAAADD
Round Trip | ADDCAIBRUDXBHKGMAAADD
ADDCAILGG
LGGLUXPNR
PNRADD
Round Trip | ADDCAILGGLUXPNRADD
ADDCAILGG
LGGBRUDXB
DXBHKG
HKGMAAADD
Round Trip | ADDCAILGGBRUDXBHKGMAAADD
ADDLGG
LGGLOS
LOSLGG
LGGACCLOSLGG
LGGADD
Round Trip | ADDLGGLOSLGGACCLOSLGGADD
Spreadsheet: 807870d1670120439-transpose-a-table-into-column-vstack-tocol-reversed
Sheet: sample1

 | [NAME] |  |  |  |  | [NAME] | Ibrahim | [NAME] | [NAME] | Isobelle
 | [NAME] |  |  |  |  | [NAME] | Kirsten | Edna | [NAME] | Lina
 | Alistair |  |  |  |  | Callum | Agnes | Maksymilian | Shannon | [NAME]
 | Barney |  |  |  |  | Hiba | Barney | Alistair | [NAME] | [NAME]
 | Hiba |  |  |  |  |  |  |  |  |  |  | Helper Array below:
 | [NAME] |  |  |  |  | [NAME] | Ibrhim | [NAME] | [NAME] | Isobelle
 | Shannon |  |  |  |  | [NAME] | Kirsten | Edna | [NAME] | Lina
 | Maksymilian |  |  |  |  | Callum | Agnes | Marksymillan | Shannon | [NAME]
 | Agnes |  |  |  |  | Hiba | Barney | Alistair | [NAME] | [NAME]
 | Callum
 | Lina
 | [NAME] |  |  |  |  | [NAME]
 | Edna |  |  |  |  | Alistair
 | Kirsten |  |  |  |  | Barney
 | [NAME] |  |  |  |  | Hiba
 | Isobelle |  |  |  |  | [NAME]
 | [NAME] |  |  |  |  | Shannon
 | [NAME] |  |  |  |  | Marksymillan
 | Ibrahim |  |  |  |  | Agnes
 | [NAME] |  |  |  |  | Callum
 |  |  |  |  |  | Lina
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Edna
 |  |  |  |  |  | Kirsten
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Isobelle
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Ibrhim
 |  |  |  |  |  | [NAME]
Spreadsheet: 888653d1739222042-change-format-of-data-diabetes-27-apr-2017-to-23-april-2018
Sheet: Table 11

00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Mon 17 Jul Glucose mmol/L
 |  |  |  |  |  | 8.1 6.6
Tue 18 Jul Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Wed 19 Jul Glucose mmol/L
Thu 20 Jul Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
 |  |  |  |  |  | 6.8
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Fri 21 Jul Glucose mmol/L
Sat 22 Jul Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
 |  |  |  |  | 6.7 |  | 7.9 | 8.2 | 7.6
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Sun 23 Jul Glucose mmol/L
Legend          High Glucose (>13.3)            Low Glucose (<3.9)
Mon 24 Jul Glucose mmol/L