tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0e7ce6ab-e5d2-4b10-8ef1-6b3562ae904a
Sheet: WebofScience

Web of Knowledge (Thomson)
2009-2010
COUNTER-Compliant?: | Yes
 | 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
BIOSIS Previews
Sessions | 21 | 12 | 45 | 100 | 64 | 18 | 18 | 34 | 41 | 35 | 12 | 19
Queries | 96 | 27 | 101 | 454 | 213 | 152 | 41 | 64 | 85 | 73 | 72 | 42 |  | 27982.5
 | 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
CrossSearch
Sessions | 489 | 463 | 801 | 1052 | 878 | 629 | 719 | 895 | 994 | 1065 | 613 | 600
Queries | 751 | 695 | 744 | 945 | 590 | 737 | 729 | 609 | 847 | 609 | 359 | 369
 | 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
Web of Knowledge
Sessions | 617 | 603 | 1511 | 1204 | 1539 | 1268 | 1298 | 1739 | 2040 | 1687 | 789 | 785
 | 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
Web of Science
Sessions | 411 | 462 | 1232 | 764 | 1276 | 1043 | 1024 | 1456 | 1650 | 1306 | 572 | 556
Queries | 1636 | 1835 | 3414 | 3174 | 3341 | 2546 | 2569 | 3608 | 4186 | 4083 | 2562 | 2057 |  | 106743
 | 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
[NAME]
Logins | 0 | 2 | 12 | 17 | 4 | 10 | 5 | 28 | 3 | 5 | 3 | 18
New Users | 0 | 0 | 2 | 2 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 1
New References | 0 | 17 | 5 | 1 | 0 | 2 | 0 | 1 | 2 | 0 | 0 | 18
Exports | 1 | 2 | 3 | 3 | 0 | 6 | 3 | 4 | 1 | 7 | 3 | 8
Imports | 0 | 0 | 11 | 0 | 0 | 6 | 2 | 1 | 1 | 0 | 0 | 4
Searches | 0 | 0 | 0 | 12 | 3 | 0 | 0 | 1 | 0 | 0 | 0 | 44
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6
CWYW [NAME] | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 42
CWYW Traveling Library | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Pages Served | 1 | 21 | 35 | 35 | 7 | 24 | 10 | 37 | 7 | 12 | 6 | 141
Spreadsheet: 864049d1711385372-if-then-multiple-criteria-help-book2-87-aligw
Sheet: Sheet1

Trade Date (M/D/YYYY) | Trader | Company | Commodity | Contract Month | Contract Year (YYYY) | Direction (B/S) | Lots | EFP | MERC Price | Trade Number | Line | Counterparty | TAS Price | [NAME] | Reported |  | SettlePrice TABLE
2024-03-20 00:00:00 | Justin | xyz | HO | APR | 2024 | S | -25 | EFP | 2024-03-25 00:00:00 | 957341 |  | Aramco |  | good |  |  | 2.7271 | RB
2024-03-20 00:00:00 | Justin | xyz | HO | APR | 2024 | S | -25 | EFP | 2024-03-22 00:00:00 | 957342 |  | [NAME] |  | good |  |  | 2.6688 | HO
Spreadsheet: 680081d1590766016-need-use-of-conditional-formatting-to-identity-budget-threshold-conditionalformatting
Sheet: Sheet1

Budget |  | $ [NAME] | Running Total | [NAME] | [NAME]
1100 |  | 108 |  | A | aa
 |  | 169 |  | B | bb
 |  | 110 |  | C | cc
 |  | 159 |  | D | dd
 |  | 171 |  | E | ee
 |  | 144 |  | F | ff
 |  | 108 |  | G | gg
 |  | 172 |  | H | hh
 |  | 178 |  | I | ii
 |  | 146 |  | J | jj
 |  | 146 |  | K | kk
 |  | 150 |  | L | ll
Spreadsheet: 174484d1345069358-pivot-table-setup-example
Sheet: Sheet2

Month | Amount Produced | Amount Signed |  | Month | Amount Produced | Amount Signed
Jun | 405448.98 | 405448.98 |  | Jun
Jul | 157518.5 | 157518.5 |  | Jul
Grand Total | 562967.48 | 562967.48
Spreadsheet: 773209d1647696363-create-a-12-week-roster-12-hour-roster
Sheet: Sheet1

 | Week 1 | SAT | SUN | MON | TUE | WED | THU | FRI | STAFF
 | 1 | 0600-1800 | 0600-1800 | 1800-0600 |  |  |  |  | [NAME]
 | 2 | 0600-1800 | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600 |  |  | Debbie
 | 3 |  |  |  | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600 | Scott
 | 4 |  |  |  |  |  | 0600-1800 | 0600-1800 | [NAME]
 | 5 | 1800-0600 | 1800-0600 |  |  |  |  |  | [NAME]
 | Week 2 | SAT | SUN | MON | TUE | WED | THU | FRI | STAFF
 | 1 | 0600-1800 | 0600-1800 | 1800-0600 |  |  |  |  | [NAME]
 | 2 | 0600-1800 | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600 |  |  | [NAME]
 | 3 |  |  |  | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600 | Debbie
 | 4 |  |  |  |  |  | 0600-1800 | 0600-1800 | Scott
 | 5 | 1800-0600 | 1800-0600 |  |  |  |  |  | [NAME]
 | Week 3 | SAT | SUN | MON | TUE | WED | THU | FRI | STAFF
 | 1 | 0600-1800 | 0600-1800 | 1800-0600 |  |  |  |  | [NAME]
 | 2 | 0600-1800 | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600 |  |  | [NAME]
 | 3 |  |  |  | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600 | [NAME]
 | 4 |  |  |  |  |  | 0600-1800 | 0600-1800 | Debbie
 | 5 | 1800-0600 | 1800-0600 |  |  |  |  |  | Scott
Spreadsheet: lynn_blair__24470__NNGWKednotes_2001
Sheet: November 10 & 11, 2001

NNG WEEKEND NOTES
For cc Mail distribution:  [NAME], [NAME], [NAME], S. January, [NAME], [NAME], [NAME], TMS OnCall
SATURDAY |  |  | 2001-11-10 00:00:00
Mail distribution send to the above listing on Sunday evening.
H:\DATA\Process Guidelines\[NNGWKednotes Template.xls]Dec 25 & 26
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SAT |  |  | No difficulties with this process.
 | 7:00 A.M. Non-grid:
 | Gas Day: | FRI |  |  | No difficulties with this process.
 | 8:00 AM Final
 | Gas Day: | SAT |  |  | No difficulties with this process.
 | 10:00 A.M. Intraday 1:
 | Gas Day: | SAT |  |  | No difficulties with this process.
 | 5:00 P.M. Intraday 2:
 | Gas Day: | SUN |  |  | No difficulties with this process.
 | 11:30 A.M. Timely
 | Gas Day: | SUN |  |  | No difficulties with this process.
 | 6:00 P.M. Evening
 | Other Comments:
 | On Call Reps. |  |  |  |  |  | 6:30 - 3:30
 |  |  |  | [NAME] |  |  | 6:30 - 3:30
 |  |  |  |  |  |  | 1:00 - 10:00
 |  |  |  | [NAME] |  |  | 1:00 - 10:00
SUNDAY
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SUN |  |  | No difficulties with this process.
 | 7:00 A.M. Non-grid:
 | Gas Day: | SAT |  |  | No difficulties with this process.
 | 8:00 AM Final
 | Gas Day: | SUN |  |  | No difficulties with this process.
 | 10:00 A.M. Intraday 1:
 | Gas Day: | SUN |  |  | No difficulties with this process.
 | 5:00 P.M. Intraday 2:
 | Gas Day: | MON |  |  | No difficulties with this process.
 | 11:30 A.M. Timely
 | Gas Day: | MON |  |  | No difficulties with this process.
 | 6:00 P.M. Evening
 | Other Comments:
 | On Call Reps: |  |  |  |  |  | 6:30 - 3:30
 |  |  |  | [NAME] |  |  | 6:30 - 3:30
 |  |  |  |  |  |  | 1:00 - 10:00
 |  |  |  | [NAME] |  |  | 1:00 - 10:00
Spreadsheet: larry_campbell__21441__AssociateAnalystDarts
Sheet: Game Chart

 | Associate/Analyst Darts Tournament
 | Players |  | Round One Winners |  | Round Two Winners |  | Round Three Winners |  | Round Four Winners |  | Final Round
 | [NAME] |  | Game 1
 | Game 1
 | [NAME] |  |  |  | Game 9
 | [NAME] |  | Game 2
 | Game 2
 | [NAME] |  |  |  |  |  |  |  | Game 14
 | Kendell Sprott |  | Game 3
 | Game 3
 | [NAME] |  |  |  | Game 10
 |  |  |  |  |  |  |  |  |  |  | Winner:
 | [NAME] |  | Game 4
 | Game 4
 | [NAME] |  |  |  |  |  |  |  |  |  | Game 16
 | [NAME] |  | Game 5
 | Game 5
 | [NAME] |  |  |  | Game 11
 | [NAME] |  | Game 6
 | Game 6
 | [NAME] |  |  |  |  |  |  |  | Game 15
 | [NAME] |  | Game 7
 | Game 7
 | [NAME] |  |  |  | Game 12
 | [NAME] |  | Game 8
 | Game 8
 | Heath Kendall |  |  |  |  |  | Game 13
 | [NAME]
 | Board One: |  | Monday, November 6th |  | Tuesday, November 7th |  | Wednesday, November 8th
 |  |  | 11:30 - 12:00 - Game 1 |  | 11:30 - 12:00 - Game 9 |  | 11:30 - 12:00 - Game 14
 |  |  | 12:00 - 12:30 - Game 2 |  | 12:00 - 12:30 - Game 10
 |  |  | 12:30 - 1:00 - Game 3
 |  |  | 1:00 - 1:30 - Game 4
 | Board Two: |  | Monday, November 6th |  | Tuesday, November 7th |  | Wednesday, November 8th
 |  |  | 11:30 - 12:00 - Game 5 |  | 11:30 - 12:00 - Game 11 |  | 11:30 - 12:00 - Game 15
 |  |  | 12:00 - 12:30 - Game 6 |  | 12:00 - 12:30 - Game 12 |  | 12:00 - 12:30 - Game 16
 |  |  | 12:30 - 1:00 - Game 7 |  | 12:30 - 1:00 - Game 13
 |  |  | 1:00 - 1:30 - Game 8
Spreadsheet: 679912d1590682486-dynamically-alter-table-header-and-dropdown-list-test-report
Sheet: CIS Report

 | Print CIS record
 |  |  | Index no
 | Staff | Name 1
Date | Invoice | CIS | Pay
Spreadsheet: 08e736d3-d14f-4c5e-9e9e-b525fe43f80f
Sheet: Sheet1

Rectal Cancer (C19-C20 and C21.8): 1971-2007 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Age-Standardised Ten-Year Relative Survival Rates, England and Wales 1971-1995 and Predicted** 2007, England 1996-2003
 |  | Relative Survival (%)
Period of Diagnosis | Geography | Male | Female
1971-1975* | England and Wales | 23 | 25
1976-1980* | England and Wales | 26 | 28
1981-1985* | England and Wales | 30 | 31
1986-1990 | England and Wales | 31.3 | 34.5
1991-1995 | England and Wales | 35 | 40.3
1996-2000 | England | 41.4 | 46.3
2001-2003 | England | 47.2 | 50.2
2007** | England and Wales | 47.3 | 52.1
*Survival rates are not age-standardised from 1971-1985
**Ten year survival rates have been predicted for patients diagnosed in 2007 (using the hybrid approach)
*Survival rates are not age-standardised from 1971-1985
**Ten year survival rates have been predicted for patients diagnosed in 2007 (using the hybrid approach)
Note: Survival rates for 1971-1995 and for 2007 are for England and Wales, all other data is for England only
Prepared by Cancer Research UK - http://info.cancerresearchuk.org/cancerstats/
Original data sources:
1971-1995
Cancer Research UK (2004). CancerStats report – Survival – England and Wales, Cancer Research UK.
http://publications.cancerresearchuk.org/cancerstats/statssurvival/survival2009.html
1996-2003
[NAME], [NAME], et [NAME]. (2009). ‘Population-based cancer survival trends in England and Wales up to 2007’, [NAME], 10, 351-69. Age-standardised relative survival rates were provided by the authors on request.
http://www.ncbi.nlm.nih.gov/pubmed/19303813
2007
[NAME]. M. P et al (2010), Research commissioned by Cancer Research UK, London School of Hygiene and Tropical Medicine
http://www.lshtm.ac.uk/eph/ncde/cancersurvival/
Spreadsheet: 84864d1284977280-extract-data-from-cells-budget-tracking-2003
Sheet: Budget

Project Name: | Service Desk Tool Implementation
Project Manager:
 |  |  |  |  |  | Total Budget | 200000
 |  |  | Project Phase | % | start | End | Planned Budget
 |  |  | Pre-Initiation (10%) | 10 | 2010-09-01 00:00:00 | 2010-09-25 00:00:00 | 20000
 |  |  | Initiation (10%) | 10 | 2010-09-26 00:00:00 | 2010-10-10 00:00:00 | 20000
 |  |  | Planning (15%) | 15 | 2010-10-11 00:00:00 | 2010-11-11 00:00:00 | 30000
 |  |  | Execution (60%) | 60 | 2010-11-11 00:00:00 | 2011-02-01 00:00:00 | 120000
 |  |  | Closeout (5%) | 5 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 10000
 |  |  | 2010 |  |  |  | 2011
 |  |  | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4
Planned Budget |  |  | 0 | 0 | 20000 | 50000
Planned work (%) |  |  | 0 | 0 | 10 | 25
Planned work Cumulative
Actual Work
Actual Work Cumulative
Actual Cost
Actual Cost Cumaltive
PV
EV
SPI
CPI
Spreadsheet: michelle_lokay__26792__imball0203
Sheet: WTGmktg

 | /------------------------------------------  contract 22100  --------------------------------------------------------\
 | 10811 |  | 13234 |  | 16540 |  | 500648
 | Follet |  | Oasis Dairy Farms |  | WTG/TW Winker |  | Sum WTG New Mex
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -269 | -120 |  |  | -966 | -644
2 | -225 | -120 |  |  | -1612 | -644
3 | -138 | -120 |  |  | -1479 | -644
4 | -120 | -120 |  |  | -1283 | -644
5 | -120 | -120 |  |  | -962 | -481
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  |  |  |  |  |  |  | -28064
2002-03-05 00:00:00
CBS Volume
 |  |  | 98
Spreadsheet: 66689d1267364297-chart-line-cannot-be-copied-bse-new
Sheet: Sheet1

20 | 17474
21 | 17051
22 | 16860
25 | 16780
27 | 16290
28 | 16307
29 | 16358
1 | 16356
2 | 16163
3 | 16496
4 | 16225
5 | 15791
8 | 15936
9 | 16042
10 | 15922
11 | 16153
15 | 16038
16 | 16227
17 | 16429
18 | 16328
19 | 16192
22 | 16237
23 | 16286
24 | 16256
25 | 16254
26 | 16430
Spreadsheet: 95370d1294954733-dynamic-data-validation-and-the-indirect-function-data-validation-indirect-function
Sheet: DD Application

 |  |  |  | Excel is fun 698 |  | search sumproduct data validation
 | Unique Count | Formula For Defined Name |  |  | Unique Count | Formula For Defined Name
 | Return Unique Items | [NAME] for Defined Name FOR DV List |  |  | Return Unique Items | [NAME] for Defined Name FOR DV List
 |  | Owners Select From Drop Down: |  |  |  | Team Select From Drop Down:
 |  | [NAME] |  |  |  | Sharks
Spreadsheet: 214464d1360923518-conditional-formatting-based-on-in-other-cell-conditional-formatting-based-on-
Sheet: Sheet2

 | Phase 1 | Phase 2 |  |  |  | Forecast deviation from Budget & Baseline (Phase 2)
 | 88000 | 731250 |  | > +/- 10%
 | 367125 | 756000 |  | +/- 6-10%
 | n/a | 744000 |  | +/- 5% |  | $
 | n/a | 625500
 | 455125 | 2856750
 | 88000 | 171000
 | 367125 | 96000
 | n/a | 0
 | n/a | 0
 | 455125 | 267000
 | 88000 | 917250
 | 367125 | 772000
 | n/a | 801000
 | n/a | 625500
 | 455125 | 3115750
Spreadsheet: 585959d1534108590-number-of-animals-with-no-invalid-measurements-book1
Sheet: Sheet1

id | measurement
13123315 | 7253
13123315 | 7594
13123315 | 11011
13099547 | 6730
13099547 | 6784
13099547 | 1601
13099547 | 7068
13099547 | 7244
13099547 | 6813
13095501 | 6366
13095501 | 6747
13095501 | 0
13095501 | 4401
13095501 | 3262
13095501 | 4441
13095501 | 1674
13095501 | 5051
13095501 | 3635
13095501 | 5448
13095501 | 8386
13095501 | 5889
13095501 | 8664
13095501 | 1246
13095501 | 3575
13095501 | 2732
13095501 | 4557
13095501 | 5868
13095501 | 5320
13095501 | 4858
13095501 | 4442
13095501 | 6655
13095501 | 8815
13095501 | 5434
13095501 | 6086
13095501 | 0
13095501 | 5031
13095501 | 4777
13095501 | 7819
12948107 | 7869
12948107 | 2700
12948107 | 5047
12948107 | 3412
12948107 | 2975
12948107 | 5785
12948107 | 3526
12948107 | 5923
12948107 | 4774
12948107 | 4743
12948107 | 6228
12948107 | 6048
12948107 | 4898
12948107 | 6437
12948107 | 6186
12948107 | 7437
12948107 | 5311
12948107 | 6716
12948107 | 7203
12948107 | 8693
12948107 | 8530
12948107 | 4834
12948107 | 4728
12948107 | 5767
12948107 | 5504
12948107 | 7752
Spreadsheet: 122911d1317237376-drop-down-menu-need-a-choice-added-project1
Sheet: workbook

customer | Brand | case date | Product code | case1 | case2 | [NAME] | action2 | Part use1 | part use2 | Part No1 | Part No2 | parts maker | part serial | part model | Date In | Date Out | TAT | Status
ABC | TP100 | 2010-09-09 00:00:00 | GB1234 | A1 |  | X1 |  | RH001 | RH332 | 9000-10sy | 7800-11ad | KT System |  | BY10200002 | 2010-11-17 00:00:00 | 2011-01-04 00:00:00 | 49 | SHIPPED TO BUFFER
Pull donw selection - select from Data Range D in tab-pulldown list | Pull donw selection - select from Data Range C in tab-pulldown list | manual input | pull down selection, select from data range C in [NAME] pulldown list | pull down selection , select from data range A in [NAME] pulldown list |  | pull down selection , select from data range B in [NAME] pulldown list |  | pull down selection, if D4=[NAME], pulldown display below for selection | pull down selection, same as I4 | copy from data range B3 when parts maker selected from [NAME] | pull down selection, same as K4 | pull down selection, select from tab - data range in Part list | manual input | copy from range B3 when parts maker selected from tab - Part list | manual input | manual input | calculate from Q2 - P2 | Pull down selection
 |  |  |  |  |  |  |  | part | part number |  |  | parts maker | part model
 |  |  |  |  |  |  |  | NA | NA |  |  | NA | NA
 |  |  |  |  |  |  |  | RH001 | 9000-10sy |  |  | KT System | BY10200002
 |  |  |  |  |  |  |  | RH332 | 7800-11ad |  |  | KT System | BT02101000
 |  |  |  |  |  |  |  |  |  |  |  | Rogers Co | RT90034
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | ED469010
customer | Brand | case date | Product code | case1 | case2 | [NAME] | action2 | Part use1 | part use2 | Part No1 | Part No2 | parts maker | part serial | part model | Date In | Date Out | TAT | Status
ABC | TP200 | 2010-10-01 00:00:00 | GB1235 | A2 |  | Y1 |  | BR4532 |  | 7800-11ad
BCC | TP200 | 2010-10-01 00:00:00 | GB1235 | A1 |  | X1 |  | NA |  | NA
Spreadsheet: 846618d1697754042-add-remove-text-from-table-after-the-cell-is-filled-with-that-text-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | Employee 1
 |  |  | SHIFT SCHEDULE EMPLOYEE (by week) |  |  |  |  |  |  |  |  |  | Employee 2
 |  |  |  |  |  |  |  |  |  |  |  |  | Employee 3
 |  |  |  |  |  |  |  |  |  |  |  |  | Employee 4
 |  |  |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday |  |  | Employee 5
 |  |  | Department 1 | Employee 1 |  |  |  |  |  |  |  |  | Employee 6
 |  |  | Department 2 |  |  |  |  |  |  |  |  |  | Employee 7
 |  |  | Department 3 |  |  |  |  |  |  |  |  |  | Employee 8
 |  |  | Department 4 |  | Employee 2
 |  |  | Department 5 |  |  |  |  | Employee 4
 |  |  | Department 6 |  |  |  |  |  | Employee 5
 |  |  | Department 7
 |  |  | Department 8
Spreadsheet: 777643d1650534850-index-and-match-to-return-specific-rows-of-data-only-example-workbook
Sheet: Sheet1

Employee Number | Date | Blank Column | Reference | Currency | Indicator | Percentage 1 | Percentage 2
Sub Ref | Sub Ref | Sub Ref | Sub Ref | Sub Ref | Sub Ref | Sub Ref | Sub Ref
Employee 1 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 15
Employee 2 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 15
Employee 3 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 15
Employee 4 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 15 |  |  |  |  |  |  |  | 2022-02-28 00:00:00
Employee 5 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 15 |  |  |  | Employee |  |  |  | Date |  |  |  |  | Percentage
Employee 6 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 15
Employee 7 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 15
Employee 8 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 15
Employee 9 | 2022-02-28 00:00:00 |  | FL5 | USD | X |  | 15
Employee 10 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 15
Employee 11 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 15
Employee 12 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 15
Employee 13 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 11
Employee 14 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 11
Employee 15 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 25
Employee 16 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 11
Employee 17 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 11
Employee 18 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 15
Employee 18 | 2023-12-31 00:00:00 |  | FL6 | USD | X | 11.00
Employee 19 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 17
Employee 20 | 2022-02-28 00:00:00 |  | FL5 | USD | X |  | 15
Employee 21 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 15
Employee 22 | 2022-02-28 00:00:00 |  | FL5 | USD | X |  | 15
Employee 23 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 11
Employee 24 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 15
Employee 24 | 2023-12-31 00:00:00 |  | FL6 | USD | X | 17.00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Percentage
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
Spreadsheet: 117961d1313300952-vlookup-test
Sheet: Sheet1

Symbol | DESCO |  | DESCO | Count Result
Posting Date | 2011-08-07 00:00:00 |  | 2011-08-07 00:00:00 | 2 | <---- ??? | How to count this?
Symbol | DESCO
Posting Date | 2011-08-07 00:00:00
Symbol | APEXSPINN
Posting Date | 2011-08-07 00:00:00
Symbol | DESCO
Posting Date | 2011-08-06 00:00:00
Symbol | GLOBALINS
Posting Date | 2011-08-05 00:00:00
Spreadsheet: 196664d1354061915-read-the-top-three-items-from-a-goods-list-top-3
Sheet: Sheet1

 |  |  |  | Objects
 |  |  |  | 1 | Apple
 |  |  |  | 2 | Pear
 |  |  |  | 3 | Orange
 |  |  |  | 4 | [NAME]
 |  |  |  | 5 | Grape
 |  |  |  | 6 | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | The first column is populated by randomly reading datae from the objects list.
 |  |  |  |  | The 1st, 2nd and 3rd cells then read the top 3 items in the list from the pivot table on sheet two
 |  |  |  |  | However, they do not update when the sheet is calculated. Updating the pivot table, updates the data
 |  |  |  |  | but the only way to have the 1st 2nd and 3rd cells update is to recalc the sheet which in turn recalcs the info in th first column
1st | 2nd | 3rd
Spreadsheet: 100334d1298692155-monthly-return-data-quiksilver6505_hba1c_return-1-
Sheet: Sheet1

DATA |  |  |  | RETURN
Klinik | Hba1c |  |  | NT | Normal | 4
nt | 10 |  |  | NT | Abnormal | 2
bp | 6 |  |  | BP | Normal | 4
bp | 3.5 |  |  | BP | Abnormal | 1
sa | 7 |  |  | T4 | Normal | 0
[NAME] | 9 |  |  | T4 | Abnormal | 3
[NAME] | 12.5 |  |  | SA | Normal | 2
nt | 5 |  |  | SA | Abnormal | 4
nt | 4 |  |  | IA | Normal | 1
sa | 8 |  |  | IA | Abnormal | 3
sa | 7
sa | 6.8
sa | 5.9
[NAME] | 12
[NAME] | 12
[NAME] | 15
bp | 7
bp | 4.5
bp | 5
nt | 5
nt | 4.6
sa | 6
[NAME] | 8
[NAME] | 5
nt | 10
Spreadsheet: 875704d1722324150-using-formula-to-calculate-weighted-average-by-getting-numbers-from-multiple-sheets-weighted-average-revised
Sheet: Consolidated

 |  | Month |  | 2024-06-01 00:00:00 | 30 | days |  |  |  |  | Month |  | 2024-06-01 00:00:00 | 30 | 30 | 30 | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DIV A | DIV B | DIV C | Consolidated
 |  | Clients (Funded) |  |  |  |  |  |  |  |  | Clients (Funded) |  |  | 24 | 27 | 28
 |  | Weekly Avg Fees Achieved (Funded) |  |  |  | Weighted Average |  |  |  |  | Weekly Avg Fees Achieved (Funded) |  |  | 450 | 375 | 550
 |  | Clients non Funded |  |  |  |  |  |  |  |  | Clients non Funded |  |  | 17 | 15 | 22
 |  | Weekly Avg Fees Achieved (Private) |  |  |  | Weighted Average |  |  |  |  | Weekly Avg Fees Achieved (Private) |  |  | 900 | 850 | 750
 |  | Total Clients |  |  |  |  |  |  |  |  | Total Clients |  |  | 41
 |  | Fee Billed - Funded |  |  |  |  |  |  |  |  | Fee Billed - Funded
 |  | Fee Billed - non Funded |  |  |  |  |  |  |  |  | Fee Billed - non Funded
 |  |  |  |  |  |  |  |  |  |  | Check
 |  |  |  |  |  |  |  |  |  |  | Fee Billed - Funded
 |  |  |  |  |  |  |  |  |  |  | Fee Billed - non Funded