tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 148554d1333465437-possible-to-not-display-a-formula-result-if-less-than-say-0-new-new-new-rota-version2
Sheet: DATA (2)

Sunday
 | 00:00:00 | 12:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 02:30:00 | 03:00:00 | 03:30:00 | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00
NAME | am |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | pm
 | 1900-01-01 00:00:00 | 12:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 02:30:00 | 03:00:00 | 03:30:00 | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00 | start time | end time
 | 1900-01-01 00:00:00 | 12:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 02:30:00 | 03:00:00 | 03:30:00 | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00
TOTALS
 | AM | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | PM | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | 1900-01-01 00:00:00 | 12:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 02:30:00 | 03:00:00 | 03:30:00 | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00
 | AM | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | PM | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Spreadsheet: 769951d1645729949-find-lowest-value-from-row-and-match-value-with-header-name-example-of-table-vendor-v-price-
Sheet: Sheet1

 | Item | Vendor A | Vendor B | Vendor C | Vendor D | Winning Bid
 | Plates | 5 | 3 | 21 | 31
 | Cups | 61 | 56 | 24.2 | 24
 | Knife | 12 | 45 | 78 | 62
 | Fork | 12 | 31 | 12.5 | 15
 | Trial | 15 | 15 | 10 | 9
Spreadsheet: 820713d1678265571-formula-help-like-v-lookup-but-multiple-criteria-to-match-freight-tnt-box-size-calculator-2-
Sheet: Product Data

TNT SIZE CALCULATOR
*Only Fill in Blue Cells
* View "Shipping Calculator" sheet on next page for estimate shipping cost
Item | Qty Ordered | Weight | Weight (Total) | [NAME] (Per Piece) | Cubic Weight (Total) | Greater Weight |  | Total Chargeable Weight ([NAME]): | 5.38
CB2 | 5 | 0.06 | 0.3 | 0.057575 | 0.287875 | 0.3
CB3 | 2 | 0.14 | 0.28 | 0.06739200000000001 | 0.134784 | 0.28
CB4 | 20 | 0.24 | 4.8 | 0.1088 | 2.176 | 4.8
Spreadsheet: 329443d1404311041-calculating-percentage-attendance-from-symbols-example-register-with-calcs
Sheet: Sheet1

Date | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  |  |  |  |  |  |  | Week | Reasons for absence
Time | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | / | E | U | A | L | Total
2013-09-02 00:00:00 | / | A |  |  |  |  |  |  | / | / |  |  |  |  |  |  |  |  | / | Attended
2013-09-09 00:00:00 | / | / |  |  |  |  |  |  | / | / |  |  |  |  |  |  |  |  |  | Educated offsite
2013-09-16 00:00:00 | / | / |  |  |  |  |  |  | / | / |  |  |  |  |  |  |  |  | E | Explained absence
2013-09-23 00:00:00 | / | / |  |  |  |  |  |  | / | / |  |  |  |  |  |  |  |  | U | Unauthorised Absence
2013-09-30 00:00:00 | / | / |  |  |  |  |  |  | / | / |  |  |  |  |  |  |  |  | A | Authorised Absence
2013-10-07 00:00:00 | / | / |  |  |  |  |  |  | / | / |  |  |  |  |  |  |  |  | L | Late
2013-10-14 00:00:00 | / | / |  |  |  |  |  |  | / | / |  |  |  |  |  |  |  |  |  | Holiday
2013-10-21 00:00:00 | / | / |  |  |  |  |  |  | / | /
2013-10-28 00:00:00
2013-11-04 00:00:00 | / | / |  |  |  |  |  |  | / | /
2013-11-11 00:00:00 | / | / |  |  |  |  |  |  | / | /
2013-11-18 00:00:00 | / | / |  |  |  |  |  |  | / | /
2013-11-25 00:00:00 | / | / |  |  |  |  |  |  | / | /
2013-12-02 00:00:00 | / | / |  |  |  |  |  |  | / | /
2013-12-09 00:00:00 | / | / |  |  |  |  |  |  | / | /
2013-12-16 00:00:00 | A | / |  |  |  |  |  |  | / | / |  |  |  |  |  |  |  | Planning meeting
2013-12-23 00:00:00
2013-12-30 00:00:00
2014-01-06 00:00:00 | / | / |  |  |  |  |  |  | / | /
2014-01-13 00:00:00 | / | / |  |  |  |  |  |  | / | /
2014-01-20 00:00:00 | / | / |  |  |  |  |  |  | / | /
2014-01-27 00:00:00 | / | A |  |  |  |  |  |  | / | / |  |  |  |  |  |  |  | Medical appointment
2014-02-03 00:00:00 | / | / |  |  |  |  |  |  | / | /
2014-02-10 00:00:00 | / | / |  |  |  |  |  |  | / | /
2014-02-17 00:00:00
2014-02-24 00:00:00 | / | / |  |  |  |  |  |  | / | /
2014-03-03 00:00:00 | / | / |  |  |  |  |  |  | / | /
2014-03-10 00:00:00 | / | / |  |  |  |  |  |  | / | /
2014-03-17 00:00:00 | / | / |  |  |  |  |  |  | / | /
2014-03-24 00:00:00 | / | / |  |  |  |  |  |  | / | /
2014-03-31 00:00:00 | / | / |  |  |  |  |  |  | / | /
2014-04-07 00:00:00 | / | / |  |  |  |  |  |  | / | /
2014-04-14 00:00:00
2014-04-21 00:00:00
2014-04-28 00:00:00 | / | A | / | / | / | / | / | / | / | / |  |  |  |  |  |  |  | Hospital appointment
2014-05-05 00:00:00 |  |  | / | / | / | / | / | / | / | /
2014-05-12 00:00:00 | / | / | / | / | / | / | / | / | / | /
2014-05-19 00:00:00 | / | / | / | / | / | / | / | / | / | /
2014-05-26 00:00:00
2014-06-02 00:00:00 | / | / | / | / | / | / | / | / | / | /
2014-06-09 00:00:00 | / | / | / | / | / | / | / | / | / | /
2014-06-16 00:00:00 | / | / | / | / | / | / | / | / | / | /
2014-06-23 00:00:00 | / | / | / | / | / | / | / | / | / | /
2014-06-30 00:00:00 | / | / | / | / | / | A |  |  |  |  |  |  |  |  |  |  |  | Medical appointment
2014-07-07 00:00:00
2014-07-14 00:00:00
2014-07-21 00:00:00
2014-07-28 00:00:00
 |  |  |  |  |  |  |  | Total Attendance
Spreadsheet: 855381d1704970012-if-with-averageifs-returning-value-sample-data-29-aligw
Sheet: Sample for Pete_UK

Month | Project Name | Cash Out Periodic | Forecast Cash Out 3 months rolling | Forecast Cash Out - 3 months rolling YTD |  | AliGW
January | HVAC OEM Support | 100 |  |  |  |  |  | If the value in C is 0 I want to the 3 above 3 cells in D.
February | HVAC OEM Support | 100 |  |  |  |  |  | Further, I want to include the project name as there are multiple project names in the column and I only want average for the project mentioned on the row I type the formula.
March | HVAC OEM Support | 100
April | HVAC OEM Support | 100
May | HVAC OEM Support | 100 |  |  |  |  |  | I don't understand why cell D13 is returning #[NAME].
June | HVAC OEM Support | 100 |  |  |  |  |  | In my opinion it should take average of the 3 cells above.
July | HVAC OEM Support | 100
August | HVAC OEM Support | 100
September | HVAC OEM Support | 100
October | HVAC OEM Support | 100
November | HVAC OEM Support | 100
December | HVAC OEM Support | 100
January | Ninja | 4990
February | Ninja | 576
March | Ninja | 0
April | Ninja | 18445
May | Ninja | 20783
June | Ninja | 53402
July | Ninja | 3127
August | Ninja | 8919
September | Ninja | 53512
October | Ninja | 78109
November | Ninja | 70641
December | Ninja | 0
Spreadsheet: d3db9784-0fb8-4e27-91aa-14c7261fa51f
Sheet: Sheet1

Unnamed: 0
miRNA ID
let-7g-5p
miR-101a-3p
miR-125a-5p
miR-125b-5p
miR-126-3p
miR-126-5p
miR-132-3p
[NAME]
miR-136-5p
miR-139-5p
miR-140-5p
miR-145-5p
[NAME]
miR-146b-5p
miR-150-5p
miR-188-5p
miR-191-5p
miR-19a-3p
miR-19b-3p
miR-218-5p
miR-222-3p
miR-24-3p
miR-26a-5p
miR-26b-5p
miR-29a-3p
miR-29c-3p
miR-301a-3p
miR-301b-3p
[NAME]
miR-30d-5p
miR-331-3p
miR-342-3p
miR-344-3p
miR-34b-3p
miR-376c-3p
miR-379-5p
miR-384-5p
miR-410-3p
miR-433-3p
miR-434-3p
miR-484
miR-495-3p
miR-497-5p
miR-92a-3p
Spreadsheet: 328523d1403934058-how-to-link-drop-down-list-to-table-groups-tracker-by-month
Sheet: ABS

July
Century Park, Jakarta - Groups Tracker
Group Name | Sales | Event | [NAME] | Departure Date | Total Room | Rate Offered | Rate Accepted | Cut Off Date | Inclusions | Total Revenue | Status | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Please Select
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Tentative
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Approved
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Not Approved
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Confirm
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Guarantee
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Cancel
Spreadsheet: 57899d1258119828-excel-2007-having-problems-adding-up-times-roster-hours
Sheet: Sheet1

Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Friday |  |  | Saturday |  |  | Sunday
12:00-10:00 |  |  | 12:00-10:00 |  |  | 12:00-10:00 |  |  | 12:00-11:00 |  |  | 12:00-11:00 |  |  | 12:00-11:00 |  |  | 12:00-10:00
Start | Finish | Hours | Start | Finish | Hours | Start | Finish | Hours | Start | Finish | Hours | Start | Finish | Hours | Start | Finish | Hours | Start | Finish | Hours
 |  |  | 09:00:00 | 14:00:00 |  | 11:00:00 | 20:00:00 |  |  |  |  | 15:30:00 | 23:30:00 |  | 11:00:00 | 20:00:00 |  | 15:30:00 | 22:30:00
Spreadsheet: 788380d1658425331-index-match-from-dropdown-test_data
Sheet: bill

 | केशव सृष्टी भाजीगट ओशिवरा गोरेगाव पश्चिम
 | ऑर्डर क्र | July-1-2022
 | सभासद
 | Sr No | Vegetables/Fruits | Quantity | Unit Price [NAME] | Total
 |  | Curlyflower | 500 | 56
 |  | Brinjal | 500 | 44
 |  | Beans | 1 | 15
 |  | Greens | 1 | 15
 |  | Veg.Leavs | 1 | 15
 |  | Red beans | 1 | 20
 |  | [NAME] | 1 | 20
 |  | [NAME] | 5 | 10
 |  | Mint | 1 | 20
 |  | [NAME] | 6 | 60
 |  | Sapling | 1 | 30
 |  | Total
Spreadsheet: 215384d1361365563-sorting-the-data-in-excel-with-particular-requirement-example
Sheet: Sheet1

Name | Company | Employee | Position | Comments
[NAME] | [NAME] | [NAME] crain | Manager | To contact and to book an meeting
 |  | Amie Geen | Sales Consultant | To set up relationship
 |  | [NAME] | Payroll specialist | To contact and to book an meeting
 |  | [NAME] | Designer | To contact and to book an meeting
 |  | [NAME] | Assitant | To contact and to book an meeting
 |  | [NAME] | Director | To set up relationship
[NAME] | Jakemans | [NAME] | HR director | To set up relationship
 |  | [NAME] | Sales Consultant | To call this Monday
 |  | Lesley Lave | Executive direcor | To call this Monday
 |  | [NAME] | Manager | To set up relationship
[NAME] | [NAME] | [NAME] crain | Manager | To contact and to book an meeting
 |  | Amie Geen | Sales Consultant | To set up relationship
 |  | [NAME] | Payroll specialist | To contact and to book an meeting
 |  | [NAME] | Designer | To contact and to book an meeting
 |  | [NAME] | Assitant | To contact and to book an meeting
 |  | [NAME] | Director | To set up relationship
Spreadsheet: daren_farmer__5423__hpl0819
Sheet: Sheet1

HPLN0819XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  [NAME]  (TU ELECTRIC)
 |  |  |  |  |  | ** Sat./Sun. | ** Friday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 8/19-8/20 | 2000-08-18 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs. | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL
 |  |  |  |  | 0 to 40  0900hrs | 0 to 40  0900hrs | 0 to 40  0900hrs
 |  |  |  |  | 40  to 0 2100hrs | 40  to 0 2100hrs | 40  to 0 2100hrs
 |  | Firm Summary
Enron (S) |  | Oasis Sealy |  | ENA | 0 | 0 | 0
Enron (S) |  | Oasis Turbine |  | ENA | 0 | 0 | 0
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 267539d1380106652-look-up-first-and-last-instance-example
Sheet: Sheet2

Name | Username1 | StartDate1 | EndDate1
Aaronh | User1 | 2013-09-02 21:01:28 | 2013-09-02 22:00:10
Aaronh | User1 | 2013-09-02 22:21:38 | 2013-09-02 23:18:31
Aaronh | User1 | 2013-09-02 23:39:56 | 2013-09-03 02:25:31
Aaronh | User1 | 2013-09-03 03:17:47 | 2013-09-03 03:45:28
Aaronh | User1 | 2013-09-03 03:51:36 | 2013-09-03 05:30:39
Aaronh | User1 | 2013-09-03 20:58:05 | 2013-09-03 23:45:57
Aaronh | User1 | 2013-09-03 23:56:28 | 2013-09-04 02:12:45
Aaronh | User1 | 2013-09-04 03:07:58 | 2013-09-04 04:58:51
Aaronh | User1 | 2013-09-04 05:09:13 | 2013-09-04 05:30:37
Aaronh | User1 | 2013-09-04 21:08:15 | 2013-09-04 22:27:31
Spreadsheet: 25692d1217170702-counting-duplicates-within-a-date-range-exampledate1
Sheet: Sheet4

Date | Time | City
2008-07-26 00:00:00 | 04:55:12 | Reno | 1
2008-07-26 00:00:00 | 05:12:00 | Phoenix | 1
2008-07-26 00:00:00 | 19:00:00 | Phoenix | 2
2008-07-27 00:00:00 | 02:25:10 | Phoenix | 3
2008-07-27 00:00:00 | 06:05:00 | Reno | 1
Spreadsheet: 22048d1210438152-validation-data-example
Sheet: Sheet2

hosam | 1
nasser | 5
khaled | 3
nasser
hosam | 2 |  | the Input data
hany
tamer
hany
khaled | 7
[NAME] | 8
Class A
hosam | 3
khaled | 18
Class B
tamer
nasser | 5
 |  |  |  | The Output Data
Class C
hany
shady
[NAME]
Spreadsheet: 802855d1667083101-formula-to-estimate-the-date-of-project-completion-estimated_completion_date-copy
Sheet: Sheet1

 | Date Completed
Item 1 | 2022-11-04 00:00:00
Item 2 | 2022-11-15 00:00:00
Item 3 | 2022-11-24 00:00:00
Item 4 | 2022-11-27 00:00:00
Item 5 | 2022-12-02 00:00:00
Item 6 | 2022-12-14 00:00:00
Item 7 | 2022-12-27 00:00:00
Item 8 | 2023-01-03 00:00:00
Item 9
Item 10
Item 11
Item 12
Item 13
Item 14
Item 15
Item 16
Item 17
Item 18
Item 19
Item 20
Item 21
Item 22
Item 23
Item 24
Item 25
Item 26
Item 27
Item 28
Item 29
Item 30
Item 31
Item 32
Item 33
Item 34
 | [NAME] to estimate Item 34 date of completion assuming each remaining item will take 7 days to complete from the "lastest entry date"
 | Item 34 date needs to automatically update according to latest entry. (i.e. If Item 12 is 01/27/23, then Item 34 would now be 06/13/23)
Spreadsheet: 144258d1330859075-sum-values-by-month-from-dates-02032012_jpr73
Sheet: PT

Somme de Value | Années | Date
 | 2011 |  |  | 2012 |  | Total général
Product | oct | nov | déc | janv | févr
Product 1 | 115 | 36 | 12 | 50 | 36 | 249
Product 2 | 7 | 12 |  |  | 2 | 21
Product 3 | 4 | 7 | 4 | 3 | 1 | 19
Product 4 | 4 | 1 | 2 |  | 3 | 10
Product 5 | 233 | 60 | 74 | 110 | 123 | 600
Product 6 | 146 | 40 | 2 | 43 | 56 | 287
Product 7 | 281 | 97 | 100 | 160 | 147 | 785
Product 8 | 6 | 6 | 6 | 6 | 6 | 30
Product 9 | 124 | 68 | 46 | 50 | 104 | 392
Product 10 |  | 6 |  | 6 |  | 12
Product 11 | 141 | 42 | 30 | 51 | 68 | 332
Product 12 | 2 | 1 |  | 4 | 2 | 9
Product 13 | 475 | 204 | 162 | 252 | 317 | 1410
Product 14 | 12 | 8 | 14 | 6 |  | 40
Product 15 | 12 | 5 | 13 | 2 | 11 | 43
Product 16 | 28 | 20 | 15 | 28 | 26 | 117
Product 17 |  |  | 1 |  |  | 1
Product 18 | 2 | 2 | 1 | 5 | 5 | 15
Product 19 | 6 | 7 | 4 | 10 | 4 | 31
Product 20 | 13 | 16 | 2 | 7 | 2 | 40
Product 21 |  | 1 |  |  | 1 | 2
Product 22 |  |  |  | 1 | 1 | 2
Product 23
Product 24 | 22 | 20 | 5 | 15 | 14 | 76
Product 25 | 21 | 42 | 15 | 34 | 41 | 153
Product 26 | 37 | 26 | 18 | 8 | 17 | 106
Product 27
Product 28 | 4 | 10 | 11 | 16 |  | 41
Product 29 | 7 | 2 | 2 | 1 | 16 | 28
Product 30 | 1 | 1 |  | 3 | 2 | 7
Product 31 | 10 | 4 | 1 | 3 | 5 | 23
Product 32 | 2 | 1 | 5 | 3 | 3 | 14
Product 33 | 5 | 9 | 1 | 5 | 4 | 24
Product 34 | 27 | 9 | 12 | 11 | 18 | 77
Product 35 | 20 | 15 | 8 | 12 | 4 | 59
Product 36 | 1 | 2 | 1 | 2 | 3 | 9
Product 37 | 13 | 25 | 3 | 8 | 9 | 58
Product 38 | 4 | 14 | 2 | 7 | 7 | 34
Product 39 | 2 | 1 | 1 | 2 | 3 | 9
Product 40 | 2 | 1 | 5 | 3 | 4 | 15
Product 41 | 2 | 5 | 1 | 4 | 1 | 13
Product 42 | 5 | 3 | 6 | 7 | 3 | 24
Product 43 | 20 | 19 | 23 | 9 | 15 | 86
Product 44 | 5 | 7 | 1 | 3 | 7 | 23
Product 45 |  | 1 |  |  |  | 1
Product 46 |  | 6 |  |  | 1 | 7
Product 47 | 3 | 4 | 2 | 1 | 3 | 13
Product 48 | 4 | 2 | 2 | 1 |  | 9
Product 49 | 5 |  | 2 | 1 |  | 8
Product 50 | 1 |  |  |  | 1 | 2
Product 51 | 3 | 2 | 2 |  | 2 | 9
Product 52 | 2 | 1 | 2 |  |  | 5
Product 53 |  | 1 |  |  |  | 1
Product 54 | 3 | 10 |  | 1 | 2 | 16
Product 55 |  | 1 |  |  | 1 | 2
Product 56 | 66 | 36 | 32 | 42 | 31 | 207
Product 57 | 155 | 109 | 1 | 90 | 99 | 454
Product 58 | 117 | 209 | 108 | 136 | 192 | 762
Product 59 | 720 | 448 | 455 | 507 | 518 | 2648
Product 60 | 484 | 579 | 212 | 335 | 402 | 2012
Product 61 | 546 | 826 | 172 | 527 | 652 | 2723
Product 62 | 68 | 12 |  | 12 | 18 | 110
Product 63 | 163 | 72 | 2 | 25 | 61 | 323
Product 64 | 48 |  | 12 | 6 | 7 | 73
Product 65 |  | 2 | 1 | 2 | 2 | 7
Product 66 | 10 | 11 | 4 | 6 | 10 | 41
Product 67 | 11 | 9 | 6 | 17 | 5 | 48
Product 68 |  | 14 |  | 6 | 6 | 26
Product 69 |  | 3 |  | 2 |  | 5
Product 70 | 1 | 1 |  |  |  | 2
Product 71 | 5 | 2 | 4 | 2 | 4 | 17
Product 72 | 96 | 112 | 48 | 86 | 74 | 416
Product 73 | 2 |  |  | 2 | 1 | 5
Product 74 | 180 | 90 | 50 | 85 | 109 | 514
Product 75 | 2 | 3 | 2 | 3 | 1 | 11
Product 76 | 97 | 12 | 6 | 12 |  | 127
Product 77
Product 78 | 38 | 30 | 24 | 18 | 25 | 135
Product 79 | 3 |  |  |  | 2 | 5
Product 80
Total général | 4654 | 3463 | 1758 | 2875 | 3320 | 16070
Spreadsheet: 181203d1347963621-the-row-number-of-the-first-occurence-of-any-item-in-a-table-sample-worksheet
Sheet: Sheet1

Item | value | Item | value | Item | value |  | Required: The row number  of the first occurence of any item in the table. For example, 7 is the row no. of the first occurence of "m"'                          8 is the row no. Of the first occurence of "g",  and so on.
x | 50
 |  | y | 30 | y | 12
m | 65 | m | 45
g | 25 |  |  | x | 40
 |  | m | 50
 |  |  |  | g | 20
y | 15 | x | 37
Spreadsheet: chris_germany__1832__DecCohCHOICE-ENA
Sheet: Dec 2

 | COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2000-12-02 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 1471 |  | 1429 |  | 67694 |  |  |  |  |  | 25 | 1 | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 2 | 24
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 5788 |  | 6110 |  | 67694 |  |  |  |  |  | 25 | 3 | 26
 |  |  |  |  |  |  |  |  | 5000 |  | 5000 |  | 68918 | 0 |  |  |  |  | 24 | 4 | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 | 5 | 26
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 2136 |  | 2264 |  | 67694 |  |  |  |  |  | 26 | 6 | 24
 |  |  |  |  |  |  |  |  | 1535 |  | 1535 |  | 68915 | 0 |  |  |  |  | 25 | 7 | 24
 |  |  |  |  |  |  |  |  | 1540 |  | 1540 |  | 69693 | 0 |  |  |  |  | 27 | 8 | 27
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 9 | 25
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 15074 |  | 15074 |  | 67694 |  |  |  |  |  | 30 | 15 | 31
 |  |  |  |  |  |  |  |  | 673 |  | 673 |  | 69149 | 0 |  |  |  |  | 26 | 35 | 24
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 68915 | 0 |  |  |  |  | 24 | 39 | 21
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 68918 | 0
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 1651 |  | 1551 |  | 67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 1373 |  | 1606 |  | 67694 |  |  |  |  |  | Storage
 |  |  |  |  |  |  |  |  | 1915 |  | 1915 |  | 68916 | 0 |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 14768 |  | 14768 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 2136 |  | 2345 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 4379 |  | 4379 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 5756 |  | 5756 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 976 |  | 1133 |  | 67694 | 1
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 47 |  | 51 |  | 67694 | 1
 |  |  |  |  |  |  |  | x | 1.Nom to COH |  | 1. Email to COH |  |  |  |  |  |  | FOM
 |  |  |  |  |  |  |  | x | 2.Email to ENA |  | 2. Email to ENA |  |  |  |  |  |  | Buy/(Sell) NPC (from/to) ENA
Spreadsheet: 45539d1244274989-lookup-eot3
Sheet: Sheet1

Date | jun | month
 | 30 | day |  | 44125 |  | I need a lookup table on sheet 1
location | 153 | deg |  |  |  | to point to this formula
 | 1 | min |  |  |  | not copy this formula 365 times
Standard | 150
Meridian
 | 12 | hr | A plumb bob will cast a shadow on the north/south line
 | 15 | min
 | 25 | sec
 |  |  |  |  |  | perhaps we don't need this lookup table
 |  | Mins | Secs |  |  |  | test
Month | jun | -3 | -21 |  | 0 | 0 | 0 | slow
Date | 30
 |  | 201 |  |  |  |  |  |  |  |  | 12 | hour
 |  | -1 |  |  |  |  |  |  |  |  | 43200 | sec
 |  | -201 | sec | slow
 |  |  |  |  |  | Equation
 |  |  |  |  |  | of Time
 |  |  |  |  |  |  |  |  |  |  | 44125 | sec
 |  |  |  |  |  |  |  |  |  |  | 12.25694444444444
 |  |  |  |  |  |  |  |  |  |  | 12 | hr
 |  |  |  |  |  |  |  |  |  |  | 43200
 |  |  |  |  |  |  |  |  |  |  | 925
 |  |  |  |  |  |  |  |  |  |  | 15.41666666666667
 |  |  |  |  |  |  |  |  |  |  | 15 | min
 |  |  |  |  |  |  |  |  |  |  | 900
 |  |  |  |  |  |  |  |  |  |  | 25 | sec
 | deg | min |  |  |  |  |  |  |  |  |  |  | to sheet 2
Standard | 150 | 9000
Meridian
 |  |  |  |  | longitudinal difference
longitude | 153 | deg | 9180
 | 1 | min | 1
 | 9181 | min (deg)
 | 181
 | 12.06666666666667 | min (time)
 | 724 | seconds (time)
11 | hr
51 | min | convert
39 | sec | h:m:s
 |  | to sec
39600
3060 |  | then
39 |  | sec
42699 | sec | to h:m:s
11.86083333333333
11 | hr
39600
3099
51.65
51 | min
3060
39 | sec
Spreadsheet: 169447d1342851160-reorganizing-raw-data-into-a-report-example-sales-report
Sheet: Raw Data

Sales Report
Grouped by [NAME]
 |  |  |  | Margin
 |  |  |  | ------------
JMR |  |  |  | 200
BWW |  |  |  | 507.07
JTF |  |  |  | 790.86
JDK |  |  |  | 1068.33
RJM |  |  |  | 1565.55
JFC |  |  |  | 1609.69
BAM |  |  |  | 1764.58
RVR |  |  |  | 2017.49
SML |  |  |  | 2212.25
CSA |  |  |  | 2305.53
adn |  |  |  | 3174.38
Spreadsheet: 489999d1479554512-football-predictions-football-predictions
Sheet: League Table

Player | Total Points |  |  | League Table
[NAME] |  |  |  | Position | Player | Pts
[NAME] |  |  |  | 1 | [NAME] | 165 |  |  | Point Scoring
[NAME] |  |  |  | 2 | [NAME] | 162
[NAME] |  |  |  | 3 | [NAME] | 154 |  |  | Correct Result | 2
[NAME] |  |  |  | 4 | [NAME] | 151 |  |  | Correct Score | 5
[NAME] |  |  |  | 5 | [NAME] | 142
[NAME] |  |  |  | 6 | Damian West | 142
[NAME] |  |  |  | 7 | [NAME] | 142
Damian West |  |  |  | 8 | [NAME] | 140
[NAME] |  |  |  | 9 | [NAME] | 137
[NAME] |  |  |  | 10 | [NAME] | 136
[NAME] |  |  |  | 11 | [NAME] | 130
[NAME] |  |  |  | 12 | [NAME] | 126
[NAME] |  |  |  | 13 | [NAME] | 125
[NAME] |  |  |  | 14 | [NAME] | 125
[NAME] |  |  |  | 15 | [NAME] | 124
[NAME] |  |  |  | 16 | [NAME] | 124
[NAME] |  |  |  | 17 | [NAME] | 117
[NAME] |  |  |  | 18 | [NAME] | 114
[NAME] |  |  |  | 19 | [NAME] | 112
 |  |  |  | 20 | [NAME] | 102
 |  |  |  | 21
 |  |  |  | 22
 |  |  |  | 23
 |  |  |  | 24
 |  |  |  | 25
 |  |  |  | 26
 |  |  |  | 27
 |  |  |  | 28
 |  |  |  | 29
 |  |  |  | 30