tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 751373d1634064090-need-help-with-average-totals-dematic-percent-of-volume
Sheet: FY22

 | PERIOD 2    9/5-10-2
 | WEEK 1   9/5-9/11 |  |  |  |  |  |  | WEEK 2   9/12-9/18 |  |  |  |  |  |  | WEEK 3    9/19-9/25 |  |  |  |  |  |  | WEEK 4    9/26-10/2
Day: | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
OLPN Total: | 136835 | 130241 | 112798 | 151651 | 157093 | 121629 | 36539 | 152264 | 148173 | 111870 | 151614 | 137502 | 114979 | 43266 | 156574 | 154109 | 115845 | 155524 | 132952 | 107390 | 32680 | 160639 | 150969 | 111028 | 138491 | 136605 | 115003 | 41292
DCT Total | 33922 | 31661 | 29766 | 43866 | 43654 | 33748 | 10102 | 40171 | 35792 | 29447 | 46168 | 37987 | 26784 | 8623 | 38274 | 34281 | 30998 | 46905 | 36533 | 26015 | 5722 | 44455 | 38657 | 28534 | 42341 | 36628 | 28235 | 9489
%:
 | PERIOD 3      10/3-10/30
 | WEEK 1    10/3-10/9 |  |  |  |  |  |  | WEEK 2    10/10-10/16 |  |  |  |  |  |  | WEEK 3    10/17-10/23 |  |  |  |  |  |  | WEEK 4    10/24-10/30
Day: | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
OLPN Total: | 159044 | 147432 | 111663 | 148107 | 142852 | 118679 | 35532 | 150362 | 144957
DCT Total | 45389 | 33439 | 28834 | 45518 | 39624 | 31182 | 7854 | 38483 | 33444
%:
 | PERIOD 4      10/31-11/27
 | WEEK 1    10/31-11/6 |  |  |  |  |  |  | WEEK 2    11/7-11/13 |  |  |  |  |  |  | WEEK 3    11/14-11/20 |  |  |  |  |  |  | WEEK 4    11/21-11/27
Day: | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
OLPN Total:
DCT Total
%:
Spreadsheet: 695545d1600271772-countif-consecutive-slots-possible-probability-work-sheet-v3-forum
Sheet: probability work sheet csv

Common | 15 min
Elongated | 30 min
Extra Elongated | 45 min
Super Elongated | 60  min
Morning Session | Blank Slate | Scenario |  | Scenario 1
8:00 AM
08:15:00 |  |  | Elongated
8:30 AM |  |  | Elongated
08:45:00 |  |  |  | Super Elongated
9:00 AM |  |  |  | Super Elongated
09:15:00 |  |  | Common | Super Elongated
9:30 AM |  |  |  | Super Elongated
09:45:00 |  |  |  | Common
10:00 AM |  | IPF BLOCK | IPF BLOCK | IPF BLOCK
10:15:00 |  | IPF BLOCK | IPF BLOCK | IPF BLOCK
10:30:00 |  |  | Extra Elongated
10:45:00 |  |  | Extra Elongated
11:00:00 |  |  | Extra Elongated
11:15:00
11:30:00 |  |  | SDA | SDA
11:45:00 |  |  | SDA | SDA
Open Slots
Blocked slots
Open Access Available
Potential Elongated VT (rounded down)
Sum of Consecutive blank cells
Spreadsheet: 221174d1363388570-need-help-with-countifs-example
Sheet: Sheet1

open | Medical | 2001-01-01 00:00:00 |  |  | 2001-01-01 00:00:00 | Open | Re-Open | Closed
closed | Medical | 2001-01-01 00:00:00 |  |  | 2001-02-01 00:00:00
re-open | Medical-CAE | 2001-02-01 00:00:00 |  |  | 2001-03-01 00:00:00
closed | Medical | 2001-04-01 00:00:00 |  |  | 2001-04-01 00:00:00
open | Indemnity | 2001-05-01 00:00:00 |  |  | 2001-05-01 00:00:00
open | Indemnity | 2001-05-01 00:00:00
open | Disabilty | 2001-03-01 00:00:00
closed | Disabilty | 2001-05-01 00:00:00
open | Pending | 2001-01-01 00:00:00
re-open | Duplicate Claim | 2001-01-01 00:00:00
2001-01-01 00:00:00
Open and Re-Opened Claims
Closed Claims
Spreadsheet: 785197d1656244669-consolidate-sheets-into-one-master-book1-1-
Sheet: Consolidated

 |  | Sheet 1 and sheet 2 consolidated into this tab like this:
 |  | Also to put into age descending order automatically if possible |  |  |  | First Name | Sir [NAME] | Age | Start Date | Finish Date
 |  |  |  |  |  | [NAME] | Smith | 66 | 1999-01-01 00:00:00 | 2020-06-07 00:00:00
 |  |  |  |  |  | [NAME] | Wayne | 68 | 2010-11-07 00:00:00 | 2021-08-01 00:00:00
 |  |  |  |  |  | Elvis | Presley | 71 | 1998-05-04 00:00:00 | 2005-11-15 00:00:00
 |  |  |  |  |  | [NAME] | Travolta | 51 | 1999-01-01 00:00:00 | 2020-06-07 00:00:00
 |  |  |  |  |  | [NAME] | [NAME] | 68 | 2010-11-07 00:00:00 | 2021-08-01 00:00:00
 |  |  |  |  |  | Elvis | Presley | 71 | 1998-05-04 00:00:00 | 2005-11-15 00:00:00
 |  |  |  |  |  | [NAME] | [NAME] | 75 | 2000-12-15 00:00:00 | 2006-03-03 00:00:00
 |  |  |  |  |  | Ringo | [NAME] | 73 | 1988-09-10 00:00:00 | 2004-07-15 00:00:00
 |  |  |  |  |  |  | [NAME] | 75 | 2000-12-15 00:00:00 | 2006-03-03 00:00:00
 |  |  |  |  |  | Ringo | [NAME] | 73 | 1988-09-10 00:00:00 | 2004-07-15 00:00:00
 |  |  |  |  |  | Elvis | Presley | 71 | 1998-05-04 00:00:00 | 2005-11-15 00:00:00
 |  |  |  |  |  | Elvis | Presley | 71 | 1998-05-04 00:00:00 | 2005-11-15 00:00:00
 |  |  |  |  |  | [NAME] | [NAME] | 68 | 2010-11-07 00:00:00 | 2021-08-01 00:00:00
 |  |  |  |  |  | [NAME] | Wayne | 68 | 2010-11-07 00:00:00 | 2021-08-01 00:00:00
 |  |  |  |  |  | [NAME] | Smith | 66 | 1999-01-01 00:00:00 | 2020-06-07 00:00:00
 |  |  |  |  |  | [NAME] | [NAME] | 64 | 2001-03-15 00:00:00 | 2006-03-03 00:00:00
 |  |  |  |  |  | [NAME] | Travolta | 51 | 1999-01-01 00:00:00 | 2020-06-07 00:00:00
Spreadsheet: lisa_gang__22325__ENA_PGE_JUNE_21_22_2002
Sheet: JD-MAL OR CPTJK TRANS

From: | EPMI
To: | PGE System Transactions
Date: | 6/21-22/02
Total Transmission
HE
ENDING | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | TOTAL
Pacific Prevailing
Time | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | [NAME] USED
(PPT) |  |  |  |  |  |  | Total In To PGE Trans
0100 | 0 | 0 | 0 | 0 | 0 | 0
0200 | 0 | 0 | 0 | 0 | 0 | 0
0300 | 0 | 0 | 0 | 0 | 0 | 0
0400 | 0 | 0 | 0 | 0 | 0 | 0
0500 | 0 | 0 | 0 | 0 | 0 | 0
0600 | 0 | 0 | 0 | 0 | 0 | 0
0700 | 50 | 25 | 25 | 25 | 25 | 25
0800 | 50 | 25 | 25 | 25 | 25 | 25
0900 | 50 | 25 | 25 | 25 | 25 | 25
1000 | 50 | 25 | 25 | 25 | 25 | 25
1100 | 50 | 25 | 25 | 25 | 25 | 25
1200 | 50 | 25 | 25 | 25 | 25 | 25
1300 | 50 | 25 | 25 | 25 | 25 | 25
1400 | 50 | 25 | 25 | 25 | 25 | 25
1500 | 50 | 25 | 25 | 25 | 25 | 25
1600 | 50 | 25 | 25 | 25 | 25 | 25
1700 | 50 | 25 | 25 | 25 | 25 | 25
1800 | 50 | 25 | 25 | 25 | 25 | 25
1900 | 50 | 25 | 25 | 25 | 25 | 25
2000 | 50 | 25 | 25 | 25 | 25 | 25
2100 | 50 | 25 | 25 | 25 | 25 | 25
2200 | 50 | 25 | 25 | 25 | 25 | 25
2300 | 0 | 0 | 0 | 0 | 0 | 0
2400 | 0 | 0 | 0 | 0 | 0 | 0
 | BPA(G)24966 | BPA(G)24966 | BPA(G)24661 | BPA(G)24661 | BPA(G)24718 | BPA(G)SLICE12041
 | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | EWEB
 | AEP | AEP | AEP | AEP | AEP | BCPD
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | BPA(T)SYS/JD
 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | EWEB
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | AEP
 | AEP | AEP | AEP | AEP | AEP | EPMI(PSE)
 | MORGAN | SNCL | AVISTA | AVISTA | SDGE | PGE(T)JD/MAL5
 | SNCL | ISO(T)CPJK/NP15 | SDGE | MIRANT | ISO(T)MALIN/SP15 | EPMI(PSE)
 | ISO(T)CPJK/NP15 | SNCL(L)NP15 | ISO(T)MALIN/SP15 | ISO(T)MALIN/NP15 | SDGE(L)SP15 | AEP
 | SNCL(L)NP15 |  | SDGE(L)SP15 | MIRANT(L)NP15 |  | AVISTA
 |  |  |  |  |  | SMUD
 |  |  |  |  |  | SMUD(T)MALIN/RACHO-SECO
 |  |  |  |  |  | SMUD
 |  |  |  |  |  | APX
 |  |  |  |  |  | SMUD(T)RANCHO-SECO/SMUDSYS
 |  |  |  |  |  | APX
 |  |  |  |  |  | SMUD
 |  |  |  |  |  | [NAME]
Spreadsheet: 443ae951-f2ef-4f85-a16d-cde2aa339751
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
5411 | 15774 | [NAME] | Toftdahl | NOR | 63 | 00:27:12 | [NAME] | 00:28:50 | 00:01:18 | 00:23:11 | 1 | 01:21:23
5411 | 15775 | [NAME] | Sveum | NOR | 61 | 00:31:56 | 00:00:48 | 00:27:24 | 00:01:06 | 00:26:51 | 2 | [NAME]
5411 | 39165 | Anna | Evseeva | RUS | 62 | 00:28:07 | [NAME] | 00:31:12 | 00:01:08 | 00:28:30 | 3 | 01:29:38
5411 | 28246 | Emma | Skjærstad | NOR | 65 | [NAME] | 00:00:48 | 00:29:57 | 00:01:06 | 00:27:02 | 4 | 01:32:25
5411 | 39166 | Tatiana | [NAME] | RUS | 64 | 00:31:23 | 00:00:45 | [NAME] | 00:01:13 | 00:27:20 | 5 | 01:40:00
Spreadsheet: tracy_geaccone__40463__2002 1N9 Forecast
Sheet: Corp Note 1

Enron Leasing Partners, LP & Associated Entities
Interest Income/Expense Calculation
On Note From Enron Corp (011)
To Enron Pipeline Company (1N9) (1)
Principal |  | 82139733.47
Accrued But Unpaid Dividends |  | 282606.3171133889
Principal Payment |  | 0
Ending Principal
Days In Year |  | 360
Days In Month |  | 30
Rate |  | 1 Month LIBOR
Original Spread |  | 0.0025
Penalty Spread |  | 0.005
Due Date: |  | Demand or 12/31/2003
 |  |  | Monthly Rate
Month | Principal | Month | LIBOR | Adjustment | Total | Daily Rate | Interest
January |  |  | 0.04
February |  |  | 0.04
March |  |  | 0.04
April |  |  | 0.04
May |  |  | 0.04
June |  |  | 0.04
July |  |  | 0.04
August |  |  | 0.04
September |  |  | 0.04
October |  |  | 0.04
November |  |  | 0.04
December |  |  | 0.04
YTD Total
Note 1.  Note issued by Enron Corp (0011) to Enron Pipeline Company (1N9) in exchange for Enron Pipeline Company's preferred
stock in Enron Pipeline Holding Company (0332).  Effective date = 11/22/99.
Spreadsheet: 012e8d62-4303-4276-9b65-bedcb781e84c
Sheet: Data

 |  |  |  | Instructional SCH |  |  | Lab SCH
 |  |  |  | Undergrad | Graduate |  | Undergrad | Graduate |  |  |  | USTD 1101 is fee based course
 | Budget Division | 2009-10 Credits | 2010-11 Credits | 2011-12 SCH | 2011-12 SCH | total | 2011-12 HC | 2011-12 HC |  | Total |  | USTD 1201 is tuition based
AG | Agriculture |  | 4578
AM | Art & Music |  | 7193
BIO | Biology |  | 10665
[NAME] | Chemistry & Biochemistry |  | 4606 |  | 6
CMMT | Communication, Mass Media, & Theatre |  | 9749
EML | English & Modern Langagues
POLS | [NAME] |  | 10161
HIP | History |  | 9732
MCS | Mathematics & Computer Science
PHYS | Physics
AEF | Accounting, Economics, & Finance |  | 8826
AS | Aerospace Studies |  | 514
MM | Management & marketing |  | 7130
SSCJ | Security Studies & Criminal Justice |  |  |  | 459
ED | Teacher Education |  | 7017
CI | Curriculum & Instruction |  | 5412
KIN | Kinesiology |  | 6400
NRS | Nursing |  | 10078
 | Athletic Training
 | Physical Therapy |  | 1101 |  | 586
PSS | Psychology, Sociology & Social Work |  | 13689
HONR/USTD | Academic Affairs
 | Total Credits
Spreadsheet: 01ad79bd-64bf-47ed-9748-e5e5d834d2cb
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31 | Unnamed: 32 | Unnamed: 33 | Unnamed: 34 | Unnamed: 35 | Unnamed: 36
 |  |  |  |  |  |  |  | Složený zlomek 2
 |  |  |  |  |  | 6 |  |  |  |  | NE |  |  |  | NE |  |  |  |  | NE |  |  |  | NE |  |  |  | NE |  |  |  | 0 | 0 | 0 | 0 | 0
 | 1) |  |  |  |  | 5 |  |  | = |  |  |  | : |  |  |  | = |  |  |  |  | • |  |  |  | =
 |  |  |  |  |  | 5
 |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  | NE |  |  |  | NE |  |  |  |  | NE |  |  |  | NE |  |  |  | NE |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | 3 |  |  |  |  | NE |  |  |  | NE |  |  |  |  | NE |  |  |  | NE |  |  |  | NE |  |  |  | 0 | 0 | 0 | 0 | 0
 | 2) |  |  |  |  | 7 |  |  | = |  |  |  | : |  |  |  | = |  |  |  |  | • |  |  |  | =
 |  |  |  |  |  | 5
 |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  | NE |  |  |  | NE |  |  |  |  | NE |  |  |  | NE |  |  |  | NE |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | 5 |  |  |  |  | NE |  |  |  | NE |  |  |  |  | NE |  |  |  | NE |  |  |  | NE |  |  |  | 0 | 0 | 0 | 0 | 0
 | 3) |  |  |  |  | 8 |  |  | = |  |  |  | : |  |  |  | = |  |  |  |  | • |  |  |  | =
 |  |  |  |  |  | 7
 |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  | NE |  |  |  | NE |  |  |  |  | NE |  |  |  | NE |  |  |  | NE |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | 2 |  |  |  |  | NE |  |  |  | NE |  |  |  |  | NE |  |  |  | NE |  |  |  | NE |  |  |  | 0 | 0 | 0 | 0 | 0
 | 4) |  |  |  |  | 9 |  |  | = |  |  |  | : |  |  |  | = |  |  |  |  | • |  |  |  | =
 |  |  |  |  |  | 5
 |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  | NE |  |  |  | NE |  |  |  |  | NE |  |  |  | NE |  |  |  | NE |  |  |  | 0 | 0 | 0 | 0 | 0
[NAME] materiálu a všech jeho částí, není-li uvedeno jinak, je Mgr. [NAME]
Dostupné z Metodického portálu www.rvp.cz, ISSN: 1802-4785, financovaného z ESF a [NAME] ČR.
Provozováno Výzkumným ústavem pedagogickým v Praze.
Spreadsheet: 853266d1703154528-populate-a-table-via-conditions-conditions-1-
Sheet: Feuil1

code | valuea | valueb | valuec | valued | valuer | expected_result
A | d | fbd | lj | 500 | 102
B | vb | fq | yk | 215 | 48
C | ff | yk | fh | 365 | 95
A | gh | r | fh | 95 | 148
A | gh | r | iuh | 485 | 150
conditions
code | valuea | valueb | valuer | message
A | d+gh | * | <150 | message1
B | * | * | <50 | message2
A | * | fbd | 102 | message3
A | * | r | >=150 | message4
C | * | * | <50 | message5
Spreadsheet: 750859d1633696615-search-row-for-2-matches-and-sum-collumn-below-excel-forum-main-sheet-2-
Sheet: Forecast

 |  | Select Period: | May 2026 |  |  | 🔽
`
`
 |  | Forecast
 |  |  |  |  | Month 1 | 2026 | Month 2 | 2026 | Month 3 | 2026 | Month 4 | 2026 | Month 5 | 2026 | Month 6 | 2026 | Month 7 | 2026 | Month 8 | 2026 | Month 9 | 2027 | Month 10 | 2027 | Month 11 | 2027 | Month 12 | 2027
 |  | Franchise Revenue | YearStart- | 2026 | June | % | June | % | July | % | August | % | September | % | October | % | November | % | December | % | January | % | February | % | March | % | April | %
 |  | Net Income | 0
Spreadsheet: 753580d1635532358-index-and-match-but-matching-on-first-5-digits-of-zip-code-zip-forum
Sheet: Sheet1

House zip | House Zone | Zip Code | Zone
14612 | ZONE 1 | 14445 | ZONE 2
14616-2917 | ZONE 1 | 14450 | ZONE 3
14626 | ZONE 3 | 14464 | ZONE 2
14624-3017 | ZONE 3 | 14467 | ZONE 2
 |  | 14468 | ZONE 2
 |  | 14470 | ZONE 3
 |  | 14502 | ZONE 3
 |  | 14506 | ZONE 2
 |  | 14514 | ZONE 3
 |  | 14519 | ZONE 3
 |  | 14526 | ZONE 2
 |  | 14534 | ZONE 2
 |  | 14559 | ZONE 2
 |  | 14568 | ZONE 3
 |  | 14580 | ZONE 2
 |  | 14589 | ZONE 3
 |  | 14605 | ZONE 1
 |  | 14606 | ZONE 1
 |  | 14607 | ZONE 1
 |  | 14608 | ZONE 1
 |  | 14609 | ZONE 1
 |  | 14610 | ZONE 2
 |  | 14611 | ZONE 1
 |  | 14612 | ZONE 1
 |  | 14613 | ZONE 1
 |  | 14615 | ZONE 1
 |  | 14616 | ZONE 1
 |  | 14617 | ZONE 1
 |  | 14618 | ZONE 2
 |  | 14619 | ZONE 1
 |  | 14620 | ZONE 2
 |  | 14621 | ZONE 1
 |  | 14622 | ZONE 1
 |  | 14623 | ZONE 2
 |  | 14624 | ZONE 3
 |  | 14625 | ZONE 2
 |  | 14626 | ZONE 3
Spreadsheet: c4d3e629-e5b3-41e0-ac4f-924a7ddb47ac
Sheet: Sheet1

Securities | % of Assets
Alimentatn Couche-Tard B | 4.48%
Bell Aliant Inc | 4.01%
Metro Inc. | 3.76%
Fairfax Financial Holding | 3.71%
Dollarama Inc. | 3.67%
BCE Inc. | 3.63%
Cdn Utilities Cl A NVS | 3.16%
Pembina Pipeline Inc | 3.00%
Emera Inc. | 2.93%
Weston(George) Ltd. | 2.85%
Empire Company Cl A NVS | 2.85%
Inter Pipeline Ltd. | 2.80%
Tim Hortons Inc. | 2.76%
Franco-Nevada Corp | 2.68%
Keyera Corp | 2.67%
Loblaw Companies Ltd. | 2.62%
RioCan REIT | 2.55%
Enbridge Inc. | 2.52%
Canadian REIT | 2.51%
Open Text Corp. | 2.47%
ATCO Ltd Class I | 2.45%
TELUS Corp. | 2.43%
AltaGas Ltd | 2.40%
TransCanada Corp. | 2.32%
Saputo Inc. | 2.21%
Fortis Inc. | 2.19%
Valeant Pharmaceuticals | 2.09%
Shaw Communicatn Cl B Nvs | 2.04%
Intact Financial Corp | 2.04%
Rogers Communications Inc | 1.95%
CGI Group Inc Cl A | 1.85%
Catamaran Corporation | 1.79%
CAE Inc. | 1.69%
Canadian Tire Corp Cl A | 1.67%
West Fraser Timber Co Ltd | 1.61%
H&R REIT | 1.60%
Thomson Reuters Corp | 1.49%
TransAlta Corp. | 1.47%
CI Financial Corp | 1.28%
IGM Financial Inc. | 1.25%
Cash | 0.56%
Total Holdings in Portfolio | 41
Spreadsheet: 845835d1697169568-max-if-formula-dynamic-dropdown-test_101223
Sheet: RiskScore

No. | Product | Type | API | Potency (mg) | API  Solubility in Water (mg/ml) | Solubility Score | TD (mg) | MDD (mg) | Potency Score | Cleanability | Cleanability Score | ADE (µg/day) | ADE Score | Risk Score
 | A 1mg Capsules | Capsules | API A | 1 |  | 8 | 1 | 240 |  | Difficult |  | 5
 | A 2mg Capsules | Capsules | API A | 2 |  | 8 | 1 | 240 |  | Difficult |  | 5
 | A 3mg Capsules | Capsules | API A | 3 |  | 8 | 1 | 240 |  | Difficult |  | 5
 | A 4mg Capsules | Capsules | API A | 4 |  | 8 | 1 | 240 |  | Difficult |  | 5
 | F 75mg F.C Tablets | Tablets | API F | 0.1 |  | 8 | 75 | 450 |  | Difficult |  | 5
 | F 75mg Capsules | Capsules | API F | 75 |  | 8 | 75 | 450 |  | Difficult |  | 5
 | H 14mg F.C Tablets | Tablets | API H | 14 |  | 7 | 14 | 150 |  | Difficult |  | 5
 | B 10mg Capsules | Capsules | API B | 10 |  | 5 | 5 | 300 |  | Medium |  | 10
 | B 15mg Capsules | Capsules | API B | 15 |  | 5 | 5 | 300 |  | Medium |  | 10
 | B 20mg Capsules | Capsules | API B | 20 |  | 5 | 5 | 300 |  | Medium |  | 10
 | B 25mg Capsules | Capsules | API B | 25 |  | 5 | 5 | 300 |  | Medium |  | 10
 | K 250mg F.C. Tablets | Tablets | API K | 250 |  | 8 | 250 | 2860 |  | Medium |  | 80
Equipment Name | Surface Area (m2) | A 1mg Capsules | A 2mg Capsules | A 3mg Capsules | A 4mg Capsules | F 75mg F.C Tablets | F 75mg Capsules | H 14mg F.C Tablets | B 10mg Capsules | B 15mg Capsules | B 20mg Capsules | B 25mg Capsules | K 250mg F.C. Tablets
 | Type | Capsules | Capsules | Capsules | Capsules | Tablets | Capsules | Tablets | Capsules | Capsules | Capsules | Capsules | Tablets
Eq1 | 1.22 |  | Y | Y | Y |  |  | Y | Y | Y | Y |  | Y
Eq2 | 0.1 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y
Eq3 | 5.206 |  |  | Y | Y |  |  | Y | Y | Y | Y | Y
Eq4 | 4.11 |  |  | Y | Y |  |  | Y | Y | Y | Y |  | Y
Eq5 | 2.23 |  |  |  |  |  |  |  |  | Y |  | Y
Eq6 | 0.2686 | Y | Y |  |  | Y | Y
Eq7 | 0.0016 | Y | Y | Y | Y | Y | Y |  |  | Y | Y | Y
 | Total Area
Spreadsheet: 866575d1713484987-not-transferring-employee-names-to-main-sheets-employee-absence-schedule
Sheet: January

 | Employee absence schedule
 | January
 | Absence type key | V | Vacation |  |  | P | Personal |  |  | S | Sick |  |  | Custom 1 |  |  |  | Custom 2
 |  | Dates of absence
 | Employee name | 1 | 2 | 3 | 4 | 5 | 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 | Total days
 | [NAME] |  |  | V | V | V | V |  |  |  |  |  |  | V
 | [NAME] |  |  |  |  | S | S |  |  |  |  | P |  |  |  |  |  |  |  |  | S |  |  |  |  | V | V | V
 | Asaf Karten |  |  | P |  |  |  |  |  |  |  |  |  |  | S |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S
 | [NAME] |  |  |  |  |  |  | P |  |  |  |  |  |  |  |  |  |  |  | V | V | V
 | [NAME] |  |  |  | S | V | V |  |  |  |  |  |  |  |  |  |  | S |  |  |  |  |  |  | S |  |  |  |  |  |  | V
Spreadsheet: 109406d1306270830-auto-generate-reports-from-another-worksheet-sample
Sheet: Plantilla S.A. -DBM

Item No./                        Unique Item No.                  FY-2011                     Personal Services Itemization and/or          Plantilla of Personnel          (1) | Position Title                                  (2) | Salary Grade      (3) | [NAME](4) | Actual            Monthly             Basic Salary           as of May 31,          2011                          (5) | Adjusted Monthly            Basic Salary Effective          June 1, 2011      (6) | Monthly    Salary Adjustment Effective      June 1, 2011; (6) - (5)               (7) | Name of Incumbent                                        (8)
OFFICE OF THE DIRECTOR
SJUA- DIR4-1-1998 | DIRECTOR IV | 28 | 1 |  |  |  | JONES, [NAME]
SJUA-DIR-3-1-1998 | DIRECTOR III | 27 | 1 |  |  |  | REAVIS, GREGORY KENT
SJUA-SUPP-1-1998 | SUPERINTENDENT OF PRINTING | 26 | 1 |  |  |  | FORSTER, [NAME]
SJUA-ASPR-1-1998 | ASST. SUPERINTENDENT OF PRINTING | 25 | 1 |  |  |  | VACANT
SJUA-LEGO4-1-1998 | LEGAL OFFICER IV | 23 | 1 |  |  |  | VACANT
SJUA-ADAS3-1-2009 | ADMINISTRATIVE ASSISTANT III | 9 | 1 |  |  |  | CLINTON, SMITH BILLY
SJUA-ADAS3-6-2005 | ADMINISTRATIVE ASSISTANT III | 9 | 1 |  |  |  | MURESAN, [NAME]
ADMINISTRATIVE DIVISION
SJUA-CADOF-6-2005 | CHIEF AMINISTRATIVE OFFICER | 24 | 3 |  |  |  | JORDAN, [NAME]
SJUA-SADOF-8-2005 | SUPERVISING ADMINISTRATIVE OFFICER | 22 | 3 |  |  |  | STRAHOVSKI, [NAME]
SJUA-ADOF5-9-2005 | ADMINISTRATIVE OFFICER V | 18 | 1 |  |  |  | CARLMICHAEL, [NAME]
SJUA-ADOF5-10-2005 | ADMINISTRATIVE OFFICER V | 18 | 2 |  |  |  | CASEY, [NAME]
SJUA-ADOF5-11-2005 | ADMINISTRATIVE OFFICER V | 18 | 3 |  |  |  | AGRON, DIANNA MICHELLE
SJUA-ADOF5-12-2005 | ADMINISTRATIVE OFFICER V | 18 | 1 |  |  |  | NGUYEN, [NAME]
Spreadsheet: 36748d1234671641-using-2-variables-to-return-multiple-items-from-multiple-sheets-2-variables-no-array
Sheet: List Sheet

Product |  | Supply
A |  | 0
B |  | 10
C |  | 20
D |  | 30
E |  | 40
F |  | 50
G |  | 60
H |  | 70
I |  | 80
J |  | 90
K |  | 100
Spreadsheet: 456199d1460671256-improve-offset-and-concatenation-exemplar-1
Sheet: Sheet1

 |  | a | b | c | d | e | f |  |  |  | a | 1
Mr X |  | x |  | x | x |  | x |  |  |  | b | 2
 |  |  |  |  |  |  |  |  |  |  | c | 3
 |  |  |  |  |  |  |  |  |  |  | d | 4
 |  |  |  |  |  |  |  |  |  |  | e | 5
 |  |  |  |  |  |  |  |  |  |  | f | 6
Spreadsheet: 163893d1340532805-formula-to-return-values-for-timetable-sampletimetable
Sheet: Sheet1

Staff code | Allocation | Y2 | Y3 | Y4 |  |  | Code | Subject | Staff | Periods
ABC | 26 |  |  |  |  |  | Y2 | A | JKL | 6
DEF | 24 |  |  |  |  |  | Y2 | B | MNO | 5
GHI | 9 |  |  |  |  |  | Y2 | C | GHI | 3
JKL | 25 |  |  |  |  |  | Y2 | D | DEF | 6
MNO | 11 |  |  |  |  |  | Y2 | A | ABC | 5
 |  |  |  |  |  |  | Y3 | B | JKL | 4
 |  |  |  |  |  |  | Y3 | B | MNO | 4
 |  |  |  |  |  |  | Y3 | B | GHI | 4
 |  |  |  |  |  |  | Y3 | B | DEF | 4
 |  |  |  |  |  |  | Y3 | B | ABC | 4
 |  |  |  |  |  |  | Y3 | B | JKL | 6
 |  |  |  |  |  |  | Y3 | B | MNO | 6
 |  |  |  |  |  |  | Y3 | B | GHI | 6
 |  |  |  |  |  |  | Y4 | C | DEF | 6
 |  |  |  |  |  |  | Y4 | C | ABC | 6
 |  |  |  |  |  |  | Y4 | C | JKL | 3
 |  |  |  |  |  |  | Y4 | C | MNO | 4
 |  |  |  |  |  |  | Y4 | C | GHI | 5
 |  |  |  |  |  |  | Y4 | C | DEF | 3
Spreadsheet: 877716d1724551851-formula-to-create-alert-based-on-a-key-word-telford-forklift-truck-pre-shift-inspection-checklist
Sheet: Repairs

Id | Date of Inspection | Question Needing Repair | Comments
 |  |  |  |  | Id in A1:
 |  |  |  |  | =IF(IFERROR(AGGREGATE(15,6,OfficeForms.Table[Id]/(OfficeForms.Table="Repair"),ROW(Inspections!$A1)),"")="","",IFERROR(AGGREGATE(15,6,OfficeForms.Table[Id]/(OfficeForms.Table="Repair"),ROW(Inspections!$A1)),""))
 |  |  |  |  | Date of Inspection in B1:
 |  |  |  |  | =IF(IFERROR(AGGREGATE(15,6,OfficeForms.Table[Date of Inspection]/(OfficeForms.Table="Repair"),ROWS(Inspections!$A$1:$A1)),"")="","",IFERROR(AGGREGATE(15,6,OfficeForms.Table[Date of Inspection]/(OfficeForms.Table="Repair"),ROWS(Inspections!$A$1:$A1)),""))
 |  |  |  |  | Question Needing Repair in C1:
 |  |  |  |  | =IF(IFERROR(INDEX(OfficeForms.Table[#Headers],,AGGREGATE(15,6,COLUMN(OfficeForms.Table[#Headers])/(INDEX(OfficeForms.Table,MATCH($A2,OfficeForms.Table[Id],0),0)="Repair"),COUNTIF($B$2:$B2,$B2))),"")="","",IFERROR(INDEX(OfficeForms.Table[#Headers],,AGGREGATE(15,6,COLUMN(OfficeForms.Table[#Headers])/(INDEX(OfficeForms.Table,MATCH($A2,OfficeForms.Table[Id],0),0)="Repair"),COUNTIF($B$2:$B2,$B2))),""))
 |  |  |  |  | Comments in D1:
 |  |  |  |  | =IF(IFERROR(INDEX(OfficeForms.Table,$A2,AGGREGATE(15,6,COLUMN(OfficeForms.Table[#Headers])/(INDEX(OfficeForms.Table,MATCH($A2,OfficeForms.Table[Id],0),0)="Repair"),COUNTIF($B$2:$B2,$B2))+1),"")="","",IFERROR(INDEX(OfficeForms.Table,$A2,AGGREGATE(15,6,COLUMN(OfficeForms.Table[#Headers])/(INDEX(OfficeForms.Table,MATCH($A2,OfficeForms.Table[Id],0),0)="Repair"),COUNTIF($B$2:$B2,$B2))+1),""))