tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 23911d1213793678-recognizing-data-in-a-particular-trial-and-picking-out-a-repeated-number-example
Sheet: Sheet1

Trial | Variable |  | Trial | Most often repeated negative variable
1 | 1 |  | 1 | ?
1 | 1 |  | 2 | ?
1 | 0 |  | 3 | ?
1 | -2
2 | 2
2 | 1
2 | 0
2 | -3
2 | -3
3 | 2
3 | 3
3 | 0
3 | -1
3 | -1
3 | -2
Spreadsheet: mary_fischer__25641__111
Sheet: E12.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 0111
COMPANY NAME  Pierce Mechanical
ANALYSIS OF LONG-TERM DEBT
 |  |  |  |  |  |  |  |  |  |  |  | ** Credit Positive Liability  (Debit Negative Liability) **
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-12
 |  |  |  |  |  |  |  | ORIGINAL |  | BEGINNING BALANCE |  |  |  |  |  |  |  |  |  | OTHER (NON-CASH) |  |  |  | ENDING BALANCE
PAYEE AND [NAME] |  | HYPERION |  | DUE |  | INTEREST |  | AMOUNT |  | CURRENT |  | LONG-TERM |  |  |  | ADDITIONS |  | RETIREMENTS |  | AMOUNT |  | [NAME] |  | CURRENT |  | LONG-TERM
 |  | ACCOUNT |  | DATE |  | RATE |  | AUTHORIZED |  | PORTION |  | PORTION |  | TOTAL |  | DR (CR) |  | DR (CR) |  | DR (CR) |  |  |  | PORTION |  | PORTION |  | TOTAL
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Current:
Current Maturities of Long-Term Debt * |  | 0450 |  |  |  | 0
Notes Payable - Other |  | TOT_NP_OTHER |  | 2001-03-01 00:00:00 |  | 0.085 |  |  |  | 27985 |  |  |  |  |  | 1204
Total Short-Term
Long-Term:
Long-Term Debt (Hyperion Accts. 0705, 0770)
Notes (list by name of payee or issue):
Wells Fargo Bank |  | 705 |  | 2001-03-01 00:00:00 |  | 0.085 |  |  |  |  |  | -21759 |  |  |  |  |  | -4470
Total (Hyperion Accts 0705 & 0770)
Current Maturities of L/T Debt (Contra) * |  | 0775
Unamortized Premium on L/T Debt |  | 0765
Total Long-Term Debt
Total Debt  DR/(CR)
!!DO NOT INCLUDE INTERCOMPANY DEBT!!
*  HYPERION ACCOUNTS 0450 & 0775 MUST BE THE SAME AMOUNT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-12
 |  |  |  |  |  | Note:  [NAME] was repaid timely; however accounting
 |  |  |  |  |  | entries were not made in legacy systems.  Will be
 |  |  |  |  |  | completed for Q3.
 |  |  |  | Income Accts:  (DR)/CR Reverse signs from Hyperion
 |  |  |  |  |  |  | Income Accts: (DR)/CR  Reverse signs from Hyperion
Spreadsheet: 63663d1264547855-sum-only-rows-where-the-product-begins-with-letter-sumallwithh-and-s
Sheet: zz_salesPCM

Product | Top | Bottom | Middle | Back
HA21 | 1 | 6 | 5 | 4 |  | 77
HA32 | 1 | 9 | 5 | 9 |  | 52
HA33 | 1 | 0 | 0 | 0
HA54 | 1 | 4 | 2 | 1
HAL5 | 1 | 0 | 2 | 0
HAL6 | 3 | 6 | 7 | 9
SAR153 | 2 | 14 | 0 | 4
SAR154 | 0 | 6 | 6 | 4
[NAME] | 2 | 2 | 4 | 4
SAR156 | 0 | 2 | 2 | 0
Spreadsheet: 265751d1379390474-conditional-formatting-for-multiple-criteria-cond-format-example
Sheet: Sheet1

name | address | DOB | month | data | data | data | data | data | data | data | letter/visit
[NAME] |  |  | jan
pete smith |  |  | jan
pete smith |  |  | feb |  |  |  |  |  |  |  | L
[NAME] |  |  | feb |  |  |  |  |  |  |  | L
pete smith |  |  | feb
[NAME] |  |  | feb |  |  |  |  |  |  |  | L
[NAME] |  |  | feb
pete smith |  |  | [NAME]
pete smith |  |  | apr
pete smith |  |  | may
[NAME] |  |  | may
[NAME] |  |  | may
[NAME] |  |  | jun
[NAME] |  |  | jul
[NAME] |  |  | aug
[NAME] |  |  | aug
[NAME] |  |  | sept |  |  |  |  |  |  |  | V
[NAME] |  |  | oct
Each month ther are new and old names added to col A
In the second month, smith, jones and blogs have letters sent and so an L added in col L
All thurn amber for all occurrences of their name
In Sept, blogs has a visit as shown in col [NAME] His names than all turn blue
This is so then the boss filters by month, ha can still see who had visits or letters
He only wants the actual month when a letter or visit happened to show L or V
Spreadsheet: kevin_presto__20061__EOL_Prices(Markets)_v1
Sheet: Daily Peak Curve

 | PEAK Power Curves
 | NEPOOL | [NAME] | NY Z-A | NY Z-G | NY Z-J | CINERGY | COMED | TVA | SOCO | ENTERGY | ERCOT
11/27/2001 | 35 | 21.8 | 26.16 | 32.49 | 33.65 | 19.21 | 16.06 | 17.51 | 20 | 19.25 | 19.25
11/28/2001 | 35 | 21.8 | 25.5 | 31.65 | 33.05 | 20.65 | 18.65 | 18.25 | 21 | 18.25 | 19.25
11/29/2001 | 35 | 21.8 | 25.5 | 31.65 | 33.05 | 20.65 | 18.65 | 18.25 | 21 | 18.25 | 19.25
11/30/2001 | 35 | 21.8 | 25.5 | 31.65 | 33.05 | 20.65 | 18.65 | 18.25 | 21 | 18.25 | 19.25
12/03/2001 | 36 | 26.65 | 28.2 | 35.5 | 38.8 | 24 | 22.5 | 22.6 | 24.6 | 22.65 | 23
12/04/2001 | 36 | 26.65 | 28.2 | 35.5 | 38.8 | 24 | 22.5 | 22.6 | 24.6 | 22.65 | 23
12/05/2001 | 36 | 26.65 | 28.2 | 35.5 | 38.8 | 24 | 22.5 | 22.6 | 24.6 | 22.65 | 23
12/06/2001 | 36 | 26.65 | 28.2 | 35.5 | 38.8 | 24 | 22.5 | 22.6 | 24.6 | 22.65 | 23
12/07/2001 | 36 | 26.65 | 28.2 | 35.5 | 38.8 | 24 | 22.5 | 22.6 | 24.6 | 22.65 | 23
12/10/2001 | 36 | 26.65 | 28.2 | 35.5 | 38.8 | 24 | 22.5 | 22.6 | 24.6 | 22.65 | 23.004
12/11/2001 | 36 | 26.65 | 28.2 | 35.5 | 38.8 | 24 | 22.5 | 22.6 | 24.6 | 22.65 | 23.004
12/12/2001 | 36 | 26.65 | 28.2 | 35.5 | 38.8 | 24 | 22.5 | 22.6 | 24.6 | 22.65 | 23.004
12/13/2001 | 36 | 26.65 | 28.2 | 35.5 | 38.8 | 24 | 22.5 | 22.6 | 24.6 | 22.65 | 23
12/14/2001 | 36 | 26.65 | 28.2 | 35.5 | 38.8 | 24 | 22.5 | 22.6 | 24.6 | 22.65 | 23
12/17/2001 | 36 | 26.65 | 28.2 | 35.5 | 38.8 | 24 | 22.5 | 22.6 | 24.6 | 22.65 | 23
12/18/2001 | 36 | 26.65 | 28.2 | 35.5 | 38.8 | 24 | 22.5 | 22.6 | 24.6 | 22.65 | 23
12/19/2001 | 36 | 26.65 | 28.2 | 35.5 | 38.8 | 24 | 22.5 | 22.6 | 24.6 | 22.65 | 23
12/20/2001 | 36 | 26.65 | 28.2 | 35.5 | 38.8 | 24 | 22.5 | 22.6 | 24.6 | 22.65 | 23
12/21/2001 | 36 | 26.65 | 28.2 | 35.5 | 38.8 | 24 | 22.5 | 22.6 | 24.6 | 22.65 | 23
12/24/2001 | 36 | 26.65 | 29.2 | 35.5 | 38.8 | 24 | 22.5 | 22.6 | 24.6 | 22.65 | 21.304
12/26/2001 | 36 | 26.65 | 29.2 | 35.5 | 38.8 | 24 | 22.5 | 22.6 | 24.6 | 22.65 | 21.304
12/27/2001 | 36 | 26.65 | 28.2 | 36.75 | 38.8 | 24 | 22.5 | 22.6 | 27.25 | 22.65 | 23
Spreadsheet: 118620d1313791379-excel-2007-specifying-how-vlookup-searches-a-column-test
Sheet: Sheet1

Qty/Assy | Assy/Part | Fill | Strand | Total Qty
1 | X | 2 | 1 | 2
1 | a |  |  | 2
1 | b |  |  | 2
1 | c |  |  | 2
1 | X | 2 | 1 | 2
1 | a |  |  | 2
2 | b |  |  | 4
2 | c |  |  | 4
1 | X | 2 | 1 | 2
2 | a |  |  | 4
2 | b |  |  | 4
1 | c |  |  | 2
1 | X | 2 | 1 | 2
1 | a |  |  | 2
1 | b |  |  | 2
2 | c |  |  | 4
2 | Y | 2 | 1 | 4
1 | a |  |  | 2
1 | b |  |  | 2
1 | c |  |  | 2
2 | X | 2 | 1 | 4
1 | a |  |  | 4
2 | b |  |  | 8
2 | c |  |  | 8
Spreadsheet: 088100c9-e431-4a64-92ff-ae64ee6245d5
Sheet: AP Class Determination

Complete and file for virtual school students enrolled in an advanced placement class.
Virtual School
Advanced Placement Class
Student’s Name: __________________________________________________
Student’s Address: ______________________________________ City: _________________________
Student’s Resident School District Name: ____________________________________ USD #______
Virtual School Name: ____________________________________________________ USD #______
Advanced Placement Class Name _____________________________________________________
Semester Enrolled: Fall _________ [NAME] __________
QUESTION 1
Does student’s resident district offer this Advanced Placement class? YES____ NO____
If YES, STOP, this student is not eligible for Advanced Placement weighting.
If NO, continue to QUESTION 2:
2(a) Is student’s Resident District enrollment FTE less than 260.0? YES______ NO____
2(b) Is student’s Resident District less than 200 square miles in size? YES______ NO____
If Yes to both 2(a) and 2(b), student does not qualify for Advanced Placement Weighting.
Advanced Placement Weighting
In KIDS, each virtual education student must be identified with a code in Field D18 to determine whether
they are eligible for Advanced Placement weighting. Based on the answers given to the questions above,
enter the applicable code shown below:
Cell D18
Enter 1 for Virtual Education Student
Enter 3 for Virtual Education Student eligible for additional Advanced Placement weighting (.08)
KEEP THIS FORM on file to make available for KSDE Auditor.
Spreadsheet: 173198ca-c77a-4b2f-ab47-fecda49f7fbc
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 6345.0 Labour Price Index, Australia
 | Hourly Rates of Pay Including Bonuses: Sector, Original (Quarterly Index Numbers)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Quarterly Index ;  Ordinary time hourly rates of pay including bonuses ;  Australia ;  Private ;  All industries ; |  |  | Original | A2626979V | 1997-09-01 00:00:00 | 2010-06-01 00:00:00 | 52 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Ordinary time hourly rates of pay including bonuses ;  Australia ;  Public ;  All industries ; |  |  | Original | A2627929R | 1997-09-01 00:00:00 | 2010-06-01 00:00:00 | 52 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Ordinary time hourly rates of pay including bonuses ;  Australia ;  Private and Public ;  All industries ; |  |  | Original | A2627549L | 1997-09-01 00:00:00 | 2010-06-01 00:00:00 | 52 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay including bonuses ;  Australia ;  Private ;  All industries ; |  |  | Original | A2615009A | 1997-09-01 00:00:00 | 2010-06-01 00:00:00 | 52 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay including bonuses ;  Australia ;  Public ;  All industries ; |  |  | Original | A2615959F | 1997-09-01 00:00:00 | 2010-06-01 00:00:00 | 52 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay including bonuses ;  Australia ;  Private and Public ;  All industries ; |  |  | Original | A2615579C | 1997-09-01 00:00:00 | 2010-06-01 00:00:00 | 52 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2010
Spreadsheet: 688613d1595867458-update-formula-in-a-different-sheet-while-adding-rows-test
Sheet: Sheet1

 | Y
183.6404625
183.6404625
1064.419687499999
-8.659800000000004
10.7971875
-40
-40
-40
-40
183.6404625
183.6404625
-40
813.4440000000001
96.14046249999998
725.9440000000004
96.14046249999998
96.14046249999998
96.14046249999998
96.14046249999998
96.14046249999998
934.0419625
96.14046249999998
96.14046249999998
-127.5
-96.1598
931.96017375
931.96017375
7115.723953124999
-30.75542999999996
29.82670312499997
-121
-121
-121
-121
931.96017375
931.96017375
-121
5471.833200000002
 | X
183.6404625
656.1254137500001
-8.659800000000004
-8.659800000000004
-40
2.756624999999993
-20.8125
-40
-40
939.5609250000002
706.4940348799997
-17.26950272000001
813.4440000000001
7067.851806250001
725.9440000000004
1070.40234375
852.0609250000002
568.6254137500001
618.9940348799998
96.14046249999998
96.14046249999998
1070.40234375
568.6254137500001
-127.5
-96.1598
931.96017375
4197.577565250002
-30.75542999999996
-30.75542999999996
-121
8.269874999999956
-72.28125
-121
-121
6444.908197500002
4696.611524975998
-57.61613248
5471.833200000002
 | Z
-9.938046875000005
-20.8125
-40
284.4999999999999
1330.33725
1229.8959
882.2399999999997
1057.841015625
1168.028549999999
2.756624999999993
-40
284.4999999999999
-40
-97.438046875
-97.438046875
-97.438046875
148.3359999999998
43.28217187499996
-97.438046875
970.3410156249997
181.0600000000001
196.9999999999999
794.74
2882.569750000002
970.3410156250002
-32.8703359375
-72.28125
-121
1536
9542.902612500005
8898.310889999997
5968.584000000003
7566.887109375
8398.626277500003
8.269874999999956
-121
1536
-121
 | X
802.7000000000003
656.1254137500001
-8.659800000000004
-8.659800000000004
-40
-40
-20.8125
-9.938046875000005
-40
183.6404625
706.4940348799997
-17.26950272000001
813.4440000000001
715.2000000000003
2169.872500000001
715.2000000000003
715.2000000000003
1833.526549999999
1940.849284479999
715.2000000000003
715.2000000000003
96.14046249999998
568.6254137500001
-97.438046875
100.34285
5443.62
4197.577565250002
-30.75542999999996
-30.75542999999996
-121
-121
-72.28125
-32.8703359375
-121
931.96017375
4696.611524975998
-57.61613248
5471.833200000002
 | X
-9.938046875000005
-20.8125
-40
284.4999999999999
284.4999999999999
1229.8959
882.2399999999997
1057.841015625
1168.028549999999
2.756624999999993
-17.26950272000001
943.4951020799998
-40
-97.438046875
-97.438046875
-97.438046875
148.3359999999998
43.28217187499996
60.50631687999993
970.3410156249997
-97.438046875
196.9999999999999
794.74
2882.569750000002
970.3410156250002
-32.8703359375
-72.28125
-121
1536
1536
8898.310889999997
5968.584000000003
7566.887109375
8398.626277500003
8.269874999999956
-57.61613248
6618.866449247999
-121
Spreadsheet: 586327d1534322735-report-and-email-automation-button-report-aging-aug-2018
Sheet: Batam

POSM Monitoring Data
Today
Region | Area | Material Code | Description | Brand | Brand Family | User Channel | Dept | Category | Program | PIC | UoM | Received Date | Recent Transactions Date | Balance (Qty) | Indicator | STATUS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GOOD | BAD | QUARANTINE
 |  |  |  |  |  |  |  | Category terdapat di CPT |  |  | Indicator = current date - received date (days)
 |  |  |  |  |  |  |  | Category tidak ada di CPT |  |  | 1 | < 90 days
 |  |  |  |  |  |  |  | (data di area/perhitungan) |  |  | 92 | >= 90 days dan < 180 days
 |  |  |  |  |  |  |  |  |  |  | 185 | >= 180 days dan < 365 days
 |  |  |  |  |  |  |  |  |  |  | 400 | >= 365 days
Spreadsheet: 772809d1647469091-combining-vlookup-and-counta-functions-in-a-single-formula-excel-formulas-bvj-
Sheet: Analysis

1
2
4 | [NAME]
5 | Shaded =  Stock Owned | Symbol |  | Number Of Daily 'U' Results | Number Of Daily "D" Results | [NAME] | Time Period àà | 2022-02-09 00:00:00
6
7 | Allegheny Technologies Inc (0) | ATI
31 | Chevron Corporation Common Stock (4) | CVX
51 |  | PFE
Spreadsheet: 0e7ce6ab-e5d2-4b10-8ef1-6b3562ae904a
Sheet: SciFinderScholar

SciFinder Scholar
2009-2010
COUNTER-Compliant?: | No
 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | Total | 2009-2010 Price | Price per unit
SciFinder Scholar
# Successful | 257 | 190 | 273 | 342 | 257 | 242 | 221 | 290 | 364 | 274 | 215 | 225
Activities | 759 | 480 | 753 | 781 | 631 | 554 | 526 | 692 | 966 | 570 | 503 | 475 |  | 32670
Busy | 60 | 30 | 139 | 145 | 121 | 89 | 42 | 119 | 174 | 72 | 37 | 47
Simultaneous users | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 883794d1732508652-returning-1-when-it-should-be-0-rows-unique-filter-function-sample-1
Sheet: Backend

Company | 3 |  |  | Company |  | Department |  | Training Topics |  | Month
Department | 1
Training Topics | 1
Month | 1
Total Participant per month |  |  |  |  |  |  |  |  | Problem:
 | February | April | June | July | August | September | October |  | if I choose the month [NAME], how to show Jan-June?
124 | 22 | 20 | 4 | 49 | 24 | 67 | 17 |  | also how to show the Mar: 0, May: 0, which not on rawdata?
Total topic by skill type
 | January |  | Problem:
[NAME] | 1 |  | if I choose Company Z, Dept ALL, Topics ALL, Month January --> Hardskill 1 which should be 0
Hard Skill | 1 |  | if I choose company Z, Dept ANS --> #[NAME]?
Spreadsheet: 71138d1271857766-trying-to-return-a-value-in-a-table-based-on-quantity-entered-qty-table-lookup-problem
Sheet: Sheet1

 |  |  |  |  | LABOR HOURS PER 100 PIECES
 |  |  |  |  | QTY | A | B | B w/ holes | C | E | F
 |  |  |  |  | 10-50 | 3 | 6 | 7.5 | 3.5 | 3 | 3.5
 |  |  |  |  | 51-75 | 2.8 | 6 | 7.5 | 3.2 | 3 | 3.2
STYLE | B | Style of tube shield |  |  | 76-99 | 2.8 | 6 | 7.5 | 3.2 | 3 | 3.2
QTY | 100 | Quantity of shields |  |  | 100-199 | 2.7 | 4.5 | 6 | 3 | 2.9 | 3
 |  |  |  |  | 200-299 | 2.4 | 4.5 | 6 | 2.7 | 2.6 | 2.7
 |  |  |  |  | 300-499 | 2 | 3.5 | 4.5 | 2.3 | 2.2 | 2.3
LABOR FACTOR |  | Hours per 100 pieces |  |  | 500-699 | 1.8 | 3.2 | 4.2 | 2.2 | 2 | 2.2
 |  |  |  |  | 700+ | 1.5 | 2.8 | 3.8 | 1.8 | 1.7 | 1.8
Spreadsheet: 43274d1241869935-auto-updating-of-copied-cells-calendar
Sheet: Emma

 | May |  |  |  |  |  |  |  |  | June |  |  |  |  |  |  |  |  | July |  |  |  |  |  |  |  |  | Working Days
 | M | [NAME] | W | Th | F | S | Su |  |  | M | [NAME] | W | Th | F | S | Su |  |  | M | [NAME] | W | Th | F | S | Su
 |  |  |  |  | 1 | 2 | 3 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 |  |  |  |  | 1 | 2 | 3 | 4 | 5 |  |  | Emma
 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  |  | 8 | 9 | 10 | 11 | 12 | 13 | 14 |  |  | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | 11 | 12 | 13 | 14 | 15 | 16 | 17 |  |  | 15 | 16 | 17 | 18 | 19 | 20 | 21 |  |  | 13 | 14 | 15 | 16 | 17 | 18 | 19
 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  |  | 22 | 23 | 24 | 25 | 26 | 27 | 28 |  |  | 20 | 21 | 22 | 23 | 24 | 25 | 26 |  |  | Holidays
 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  |  | 29 | 30 |  |  |  |  |  |  |  | 27 | 28 | 29 | 30 | 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bank Holiday
 | August |  |  |  |  |  |  |  |  | September |  |  |  |  |  |  |  |  | October |  |  |  |  |  |  |  |  | Emma
 | M | [NAME] | W | Th | F | S | Su |  |  | M | [NAME] | W | Th | F | S | Su |  |  | M | [NAME] | W | Th | F | S | Su
 |  |  |  |  |  | 1 | 2 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 |  |  |  |  |  | 1 | 2 | 3 | 4
 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  |  | 7 | 8 | 9 | 10 | 11 | 12 | 13 |  |  | 5 | 6 | 7 | 8 | 9 | 10 | 11
 | 10 | 11 | 12 | 13 | 14 | 15 | 16 |  |  | 14 | 15 | 16 | 17 | 18 | 19 | 20 |  |  | 12 | 13 | 14 | 15 | 16 | 17 | 18
 | 17 | 18 | 19 | 20 | 21 | 22 | 23 |  |  | 21 | 22 | 23 | 24 | 25 | 26 | 27 |  |  | 19 | 20 | 21 | 22 | 23 | 24 | 25
 | 24 | 25 | 26 | 27 | 28 | 29 | 30 |  |  | 28 | 29 | 30 |  |  |  |  |  |  | 26 | 27 | 28 | 29 | 30 | 31
 | 31
 | November |  |  |  |  |  |  |  |  | December |  |  |  |  |  |  |  |  | January
 | M | [NAME] | W | Th | F | S | Su |  |  | M | [NAME] | W | Th | F | S | Su |  |  | M | [NAME] | W | Th | F | S | Su
 |  |  |  |  |  |  | 1 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 |  |  |  |  |  |  | 1 | 2 | 3
 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  |  | 7 | 8 | 9 | 10 | 11 | 12 | 13 |  |  | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | 9 | 10 | 11 | 12 | 13 | 14 | 15 |  |  | 14 | 15 | 16 | 17 | 18 | 19 | 20 |  |  | 11 | 12 | 13 | 14 | 15 | 16 | 17
 | 16 | 17 | 18 | 19 | 20 | 21 | 22 |  |  | 21 | 22 | 23 | 24 | 25 | 26 | 27 |  |  | 18 | 19 | 20 | 21 | 22 | 23 | 24
 | 23 | 24 | 25 | 26 | 27 | 28 | 29 |  |  | 28 | 29 | 30 | 31 |  |  |  |  |  | 25 | 26 | 27 | 28 | 29 | 30 | 31
 | 30
Spreadsheet: 729685d1619257993-pull-the-content-of-the-last-cell-of-a-column-from-multiple-sheets-to-a-master-front-sheet-example-31-ans
Sheet: Worksheet

[NAME] | Start Date and Time | [NAME] |  | [NAME] | Finish Date and time | [NAME] |  |  | Finish Date and time | [NAME]
043 |  |  |  | 043
044 |  |  |  | 044
045 |  |  |  | 045
046 |  |  |  | 046
047 |  |  |  | 047
Spreadsheet: 110092d1306866056-calculating-times-ranges-tiathlon3
Sheet: Sheet1

Category | Start Time | Fastest |  |  |  |  |  |  | 90% Slowest
Youth Super Sprint (M+F) | 11:00:00
Male Super Sprint | 11:10:00
Female Super Sprint | 11:20:00
Olympic Team Relay (M+F) | 11:30:00
Olympic Team Relay (M+F) | 12:15:00
Corporate Olympic | 12:45:00
[NAME] (M+F) incl Team Relay | 13:00:00
Sprint Team Relay (M+F) | 13:30:00
Corporate Sprint (M+F) | 14:00:00
Female Sprint | 14:30:00
Female Sprint | 15:00:00
[NAME] | 15:30:00
[NAME] | 16:00:00
[NAME] | 16:30:00
[NAME] | 17:00:00
 | Start Time
Olympic Plus | 06:30:00
Male Olympic Age Group (30 - 34) | 07:00:00
Male Olympic Age Group (35-39) | 07:30:00
Male Olympic Age Group (40-44) | 08:00:00
[NAME] 17 – 55+ | 08:30:00
[NAME] Sub 2:30 | 09:10:00
[NAME] 2:30 | 09:13:00
Male Junior Elite | 10:10:00
Female Junior Elite | 10:15:00
Elite Female | 10:20:00
Elite Male | 10:45:00
[NAME] | 11:50:00
[NAME] 17 – 55+ Start 2 | 12:10:00
Male Open Olympic | 12:40:00
Male Open Olympic | 13:10:00
Male Open Olympic | 13:40:00
Male Open Olympic | 14:10:00
Male Olympic Age Group (45 +) | 14:40:00
Male Olympic Age Group (17-24) | 15:10:00
Male Olympic Age Group (25-29) | 15:40:00
Spreadsheet: 745910d1630358912-help-with-sumproduct-formula-that-contains-text-and-numbers-over-multiple-tables-index-match-multiple-column-table
Sheet: STAFF ROOMS

HOUSE | TYPE | ROOM | PRICE |  |  |  |  | House | Type | 1 | 2 | 3 | 4 | 5
Kirkwood | Single | 4 |  |  |  |  |  | Compston | Single | 70 | 80 | 90 | 100 | 110
 |  |  |  |  |  |  |  | Compston | Double | 75 | 76 | 77 | 78 | 79
 |  |  |  |  |  |  |  | Kirkwood | Single | 70 | 80 | 90 | 100 | 110
 |  |  |  |  |  |  |  | Kirkwood | Double | 75 | 76 | 77 | 78 | 79
 |  |  |  |  |  |  |  | Brinwood | Single | 70 | 80 | 90 | 100 | 110
 |  |  |  |  |  |  |  | Brinwood | Double | 80 | 90 | 91 | 92 | 93
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Compston | Kirkwood | Brinwood
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Basement | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ground | 2 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 3 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 4 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 5 | 5
Spreadsheet: 213590d1360587252-show-data-based-on-selected-parameters-table5
Sheet: MAIN

SelectMonth |  | JANUARY 2013 |  |  |  | Populate Numbers from the data sheet based on the selected month.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JANUARY 2013
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEBRUARY 2013
GHA BRAND | Hotel1 | Hotel2 | Hotel3 | Hotel4 | Hotel5 | Hotel6 | Hotel7 | Hotel8 | Hotel9 | Hotel10 | Hotel11 | Hotel12 | Hotel13 | Hotel14 | Hotel15 | Hotel16 | Hotel17 | Hotel18 | Hotel19 | Hotel20 | Hotel21 | Hotel22 | Hotel23 | Hotel24 | Grand Total |  |  |  |  |  |  | MARCH 2013
Brand1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | APRIL 2013
Brand2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAY 2013
Brand3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JUNE 2013
Brand4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JULY 2013
Brand5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AUGUST 2013
Brand6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SEPTEMBER 2013
Brand7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OCTOBER 2013
Brand8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOVEMBER 2013
Brand9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DECEMBER 2013
Brand10
Brand11
Brand12
Brand13
Grand Total
Spreadsheet: 457c5d77-31ce-44a6-bc8e-7844acc96feb
Sheet: Sheet1

Journal Name | Springer Journal number | Domaine | Commentaires
Acta endoscopica | 10190 | Endoscopie digestive
JAHG (Journal africain d'hépatogastro-entérologie) | 12157 | Hépato-gastoentérologie
Obésité | 11690 | Endocrinologie
Côlon&rectum | 11725 | Proctologie
Andrologie | 12610 | Urologie
[NAME] pathologie exotique | 13149 | Médecine tropicale
Médecine Périnatale | 12611 | Pédiatrie
La lettre de médecine physique et de réadaptation | 11659 | Médecine de réadaptation
Médecine et chirurgie du pied | 10243 | Orthopédie
BioTribune magazine | 11834 | Biologie
Les cahiers de l'année gérontologique | 12612 | Gériatrie
Oncologie | 10269 | Oncologie
Douleur&Analgésie | 11724 | Médecine de la douleur
Phytothérapie | 10298 | Phytothérapie
Journal africain du cancer (JAC) | 12558 | Oncologie
Psycho-oncologie | 11839 | Psyco-oncologie
[NAME] d'urgence | 13341 | Médecine d'urgence
Réanimation | 13546 | Réanimation - soins intensifs