tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0a034829-aec3-4140-9f29-4496d63343cd
Sheet: Sheet1

TECHNICAL SERVICES DEPARTMENT | 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
Serials Statistics 2011/2012
COLLECTION METRICS
 | JUL | AUG | SEP | OCT | NOV | DEC | JAN | FEB | MAR | APR | MAY | JUN | YTD
Serial volumes withdrawn | 30 | 2 | 2 | 1 | 1 | 0 | 2 | 0 | 10 | 1 | 2 | 0 | 51 | prc
Serials volumes withdrawn through large weeding projects | 575 (BioAbs, Reference) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ajr
Mform pieces withdrawn | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | prc
Media withdrawn | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | prc
Serial volumes added (total) | 75 | 59 | 235 | 35 | 29 | 58 | 86 | 6 | 197 | 53 | 65 | 153 | 1051
Subscriptions | 0 | 5 | 4 | 5 | 6 | 9 | 8 | 6 | 3 | 10 | 9 | 5 | 70 | jl
Binding | 75 | 54 | 231 | 30 | 23 | 49 | 78 | 0 | 194 | 43 | 56 | 148 | 981 | prc
Gifts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | prc
Mform pieces added (total) | 10 | 2 | 4 | 0 | 2 | 0 | 5 | 3 | 1 | 2 | 0 | 4 | 34
Film | 10 | 2 | 4 | 0 | 2 | 0 | 6 | 3 | 1 | 2 | 0 | 4 | 34 | jl
Fiche | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | jl
PRODUCTIVITY METRICS
[NAME] processed | 817 | 1914 | 2346 | 1320 | 743 | 678 | 755 | 1351 | 1452 | 1904 | 1115 | 1337 | 15732 | sb
[NAME] temp bound / bound in-house | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | prc
[NAME] mended (in-house) | 21 | 8 | 33 | 40 | 14 | 6 | 4 | 27 | 3 | 7 | 11 | 6 | 180 | sb
Claims sent | 20 | 24 | 20 | 17 | 26 | 13 | 2 | 47 | 8 | 21 | 13 | 4 | 215 | jl
Pieces checked in | 421 | 437 | 439 | 364 | 407 | 393 | 352 | 346 | 434 | 350 | 358 | 303 | 4604 | ajr
[NAME] returned from bindery (total) | 339 | 62 | 530 | 37 | 28 | 59 | 98 | 0 | 334 | 84 | 100 | 198 | 1869
Journals and other materials | 75 | 54 | 231 | 30 | 23 | 28 | 78 | 0 | 194 | 43 | 56 | 148 | 960 | prc
Repairs | 172 | 6 | 34 | 7 | 2 | 21 | 20 | 0 | 76 | 31 | 32 | 3 | 404 | prc
Non-Library | 92 | 2 | 265 | 0 | 3 | 10 | 0 | 0 | 64 | 10 | 12 | 47 | 505 | prc
For definitions, see http://uritechserv.pbworks.com/Serials-statistics-terms.
Spreadsheet: 175689d1345617908-pastespecial-multiple-worksheet-into-a-single-workbook-master
Sheet: My_Stats from Wb "ABC" 

School | ABC
Report Date | 2012-08-22 00:00:00
[NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Students |  |  | Reason
 |  |  |  |  | Students 1 | Students 2 | Students 3 | Reason 1 | Reason 2 | Reason 3 | Reason 4 | Reason 5 | Outcome
112694 | 13 | ENGO ARM SPEC | 0 | Yes | 0 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0
205712 | 23 | ADF EOD | 0 | Yes | 0 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0
112963 | 15 | SENIOR EOM | 0 | Yes | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0
111511 | 227 | EO INTRODUCTION | 0 | Yes | 0 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 888823d1739405099-sorting-dates-1900-seh0872-datesort2-tms
Sheet: Sheet1

 |  | 11 Nov 1800 | 1800-11-18 |  | 18 Nov 1800 |  |  |  |  | Column1 | Column2
 |  | Nov 1800 |  |  | Nov 1800 |  | 1800-10-18 |  |  | Jan | 01
 |  | 1800 |  |  | 1800 |  | 1800-11 |  |  | Feb | 02
 |  | 14 Nov 1800 |  |  |  |  | 1800-11-11 |  |  | Mar | 03
 |  | 15 Nov 1800 |  |  |  |  | 1800-11-14 |  |  | Apr | 04
 |  | 16 Nov 1805 |  |  |  |  | 1800-11-15 |  |  | May | 05
 |  | 17 Nov 1803 |  |  |  |  | 1803-11-17 |  |  | Jun | 06
 |  | 18 Oct 1800 |  |  |  |  | 1805-11-16 |  |  | Jul | 07
 |  | 19 Nov 1807 |  |  |  |  | 1807-11-19 |  |  | Aug | 08
 |  |  |  |  |  |  |  |  |  | Sep | 09
 |  |  |  |  |  |  |  |  |  | Oct | 10
 |  |  |  |  |  |  |  |  |  | Nov | 11
 |  |  |  |  |  |  |  |  |  | Dec | 12
Spreadsheet: darrell_schoolcraft__7302__imball0201
Sheet: Duke

Duke Energy Field Services
Contract  24268
2001-12-31 00:00:00 |  | 1537446.14
 |  |  |  |  |  |  |  | Duke Energy Trading and Marketing, L.L.C.
2001-12-31 00:00:00 |  |  |  |  |  |  |  | OBA Balances as of 11/30/01
50895
60874
78169 |  |  |  |  |  |  |  | Contract# | Amount | Description/Points
500235 |  |  |  |  |  |  |  | 24361 |  | Pyote points - fuel is still being delivered causing amount to grow each month
500248 |  |  |  |  |  |  |  | 24693 | 275313.72 | [NAME] plant - hasn't had activity since 12/2000
500251 |  |  |  |  |  |  |  | 21665 | 73449.16 | no activity since 11/98
500254 |  |  |  |  |  |  |  | 22664 | 23612.35 | Grand Valley plant - last activity 4/96
500255
500262
500267
Duke Energy Trading and Marketing
Contract  24693
2001-12-31 00:00:00 |  | 275313.72
2001-12-31 00:00:00
9164
9167
Duke Energy Trading and Marketing |  |  |  | CBS Volume | 24268 | 24693 | 24361
Contract  24361 |  |  |  |  | 381295 | 117857 | 186798
2001-12-31 00:00:00 |  | 841974.51
2001-12-31 00:00:00
500241
500391
500392
Duke Energy Trading and Marketing
21665 | oba | 73445.08 | POI 9109 Mobil Waha Plant |  |  |  | 21665 | 36401
22664 | oba | 23612.35 | POI 59918 Grand Valley Plant |  |  |  | 22664 | 18932
Spreadsheet: 873795d1720364407-creating-a-list-from-between-2-dates-dean-gilgrist-sample-final-with-examples-aligw
Sheet: LIST

Transaction list |  |  | from | 2024-06-14 00:00:00 | to | 2024-06-18 00:00:00
Date | Customer | Reference | Type | Value | VAT | Total
 | [NAME] | Wk 24 | Fit 2 Value | 750 | 150 | 900
2024-06-14 00:00:00 | [NAME] | Utility | Product 2 VALUE | 0 | 0 | 0
2024-06-18 00:00:00 | [NAME] | Utility | Fit 2 Value | 975 | 195 | 1170
2024-06-17 00:00:00 | [NAME] | Media Wall | Product 2 VALUE | 1177 | 235.4 | 1412.4
2024-06-17 00:00:00 | [NAME] | Flooring | Product 2 VALUE | 1228 | 245.6 | 1473.6
2024-06-14 00:00:00 | [NAME] | Media Wall | Product 1 Value | 1562 | 312.4 | 1874.4
2024-06-14 00:00:00 | Paula & David Lang | Master [NAME] | Product 1 Value | 3830 | 766 | 4596
Spreadsheet: darrell_schoolcraft__7824__imbalsumm0110
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 |  | -4180
9238 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
56422 |  | -161110
58710 | -1708 | -488
60921 |  | 122863
78026
500084 |  | -2000
500085
500097 | -151
INDEX
2001-09-30 00:00:00 |  |  | 238887.43
2001-10-02 00:00:00
CBS Volume
 |  |  | 65463
Spreadsheet: 466746d1466428711-workbook-opens-slowly-after-protecting-all-worksheets-sediment-basin-designer
Sheet: Discharge

 |  |  |  |  |  |  | SEDIMENT BASIN DESIGN
 |  |  |  |  |  |  | Project Information
 |  |  |  |  |  |  |  |  | Project Number: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
 |  |  |  |  |  |  |  |  | PI Number: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Designer:
 |  |  |  |  |  |  |  |  | County: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Note:
 |  |  |  |  |  |  | GRAPHICAL PEAK DISCHARGE METHOD
 |  |  |  |  |  |  | Data
 |  |  |  |  |  |  |  |  | 1. Drainage Area (Am) ………………………………………………………………………………………………………………………….
 |  |  |  |  |  |  |  |  | 2. Runoff curve number ……………………………………………………………………………………………………………
 |  |  |  |  |  |  |  |  | 3. Time of Concentration …………………………………………………………………………………………………………….
 |  |  |  |  |  |  |  |  | 4. Rainfall Distribution ……..…………………………………………………………………………………………………………..
 |  |  |  |  |  |  |  |  | 5. Enter % of Total Drainage Area that is Pond and/or Swamp ……………………………..………………………………………………………………………………………………………..
 |  |  |  |  |  |  |  |  | 6. Pond and Swamp Area ……………………………………………………………………………………………………….
 |  |  |  |  |  |  | Discharge Calculations
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Storm 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Storm 2
 |  |  |  |  |  |  |  |  | 1. Frequency …………………………………………………………………………………………………………………….
 |  |  |  |  |  |  |  |  | 2. Rainfall, P (24-hour) ………………………………………………………………………………………………………
 |  |  |  |  |  |  |  |  | 3. Initial Abstraction, Ia (Table 4-1) ………………………………………………………………………………………………………………………….
 |  |  |  |  |  |  |  |  | 4. Ia/P …………….…………………………………………………………………………………………………………………..
 |  |  |  |  |  |  |  |  | 5. Unit [NAME], qu ….……………………………………………………………………………………………………
 |  |  |  |  |  |  |  |  | 6. Runoff, Q ………..…………………………………………………………………………………………………………
 |  |  |  |  |  |  |  |  | 7. Pond and Swamp adjustment factor, FP …………...………..………………………………………………………………………………………………………
 |  |  |  |  |  |  |  |  | 8. Peak Discharge, Qp (Qp = quAmQFP) …………...………..………………………………………………………………………………………………………
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Page 3 of 7
Spreadsheet: 198832d1354905882-display-all-rows-when-condition-is-true-book1
Sheet: Sheet1

 | Result to display:
 | in website but not on esp
 | search by email address
Key | cookieId | email | order | date | amount
Spreadsheet: 0152e851-70b9-4427-b60a-8620d3ca2bc3
Sheet: Project Costs by Quarter

 | HR&A Advisors, Inc.
 | Inner Loop East Reconstruction Project
 | Detailed Construction Costs
 | Quarter | Expenditure (2013 $)
 | Q4 2014:  $2,321,062 | 2321062
 | Q1 2015:  $1,290,255 | 1290255
 | Q2 2015:  $5,161,019 | 5161019
 | Q3 2015:  $5,161,019 | 5161019
 | Q4 2015:  $1,290,255 | 1290255
 | Q1 2016:  $464,212 | 464212
 | Q2 2016:  $4,177,911 | 4177911
 | Q3 2016:  $4,177,911 | 4177911
 | Q4 2016:  $464,212 | 464212
 | Total Project Cost
Spreadsheet: louise_kitchen__24114__KO_Netco Grp _ EEs on 12-19
Sheet: Infras

Infrastructure
GISID | EMPLOYEE_NAME | [NAME] | JOBGROUP
90009170 | ADAMIK, DARREN P | Mgr IT | MGR-ST
90128445 | AUSTIN, CHRISTOPHER | Spec IT | SPEC-ST
90009208 | BALLMER, [NAME] | Consultant Tech IT | MGR-ST
90009173 | BARBER, [NAME] R | Consultant Tech IT | MGR-ST
90009258 | BEHNEY, [NAME] | [NAME] | DIRSR-ST
90126342 | BELT, CEDRIC B | Spec SR IT | SPECSR-ST
90126479 | BEYER, TROY | Spec SR IT | SPECSR-ST
90009257 | BODE, [NAME] | Mgr IT | MGR-ST
90141352 | BRENNAN, RYAN | Spec SR IT | SPECSR-ST
90126287 | BUCKMAN, [NAME] | Spec IT | SPEC-ST
90009536 | BULBES, [NAME] | Spec SR IT | SPECSR-ST
90151007 | BURGESS, SIMON P | Consultant Tech IT | MGR-ST
90012391 | CHENG, [NAME] | Consultant Tech IT | MGR-ST
90143667 | CIOFFI, DIANA R | Spec SR IT HS | SPECSR-ST
90009206 | [NAME], FRANK E | Consultant Tech IT | MGR-ST
90123583 | COX, SUSAN P | Dir IT | DIR-ST
90009182 | CUMMINGS, [NAME] | Spec SR IT | SPECSR-ST
90128738 | DAUGHERTY, SHARI | Staff IT | SPECJR-ST
90009265 | DELEON, ROBERTO | Mgr IT | MGR-ST
90040935 | DEVEREAUX, [NAME] | Staff IT | SPECJR-ST
90014750 | DIETRICH, DANIEL E | Mgr IT | MGR-ST
90146721 | DOLAN, [NAME] T | Spec SR IT HS | SPECSR-ST
90009157 | DZIADEK, KEITH B | [NAME] | DIRSR-ST
90009211 | ELLIOTT, CLAYTON R | Mgr IT | MGR-ST
90007101 | ESTRADA, MERCEDES E | [NAME] | ASSTSR-CS
90009151 | FRANCOIS, YVONNE M | Spec IT | SPEC-ST
90127970 | GICHANA, [NAME] | Spec SR IT | SPECSR-ST
90009230 | GUBSER, MARLIN D | [NAME] | DIRSR-ST
90009232 | HALL, JOSEPH | Spec SR IT HS | SPECSR-ST
90009243 | HALL, MARK C | Spec SR IT HS | SPECSR-ST
90009289 | HARRINGTON, STEPHEN R | Spec SR IT | SPECSR-ST
90123513 | [NAME], MATTHEW E | Spec SR IT HS | SPECSR-ST
90040937 | KNOX, BILL | Spec SR IT | SPECSR-ST
90009244 | LARKIN, BRIAN P | Mgr IT HS | MGR-ST
90131053 | LE, RICK | Spec SR IT | SPECSR-ST
90009181 | LINK, KATHY WAHEED | Mgr IT | MGR-ST
90009191 | MARCINKOWSKI, DANIELLE | Mgr IT | MGR-ST
90008862 | MCAULIFFE, ROBERT H | [NAME] | DIRSR-ST
90009209 | MCNAIR, DARREN B | Consultant Tech IT | MGR-ST
90126786 | MUSCHAR, DANIEL | Spec SR IT | SPECSR-ST
90131211 | NASH, ACEY | Spec IT | SPEC-ST
90153982 | OH, [NAME] | Analyst - Rotation 1 | ANL-C
90127409 | QAVI, FAHEEM | Spec IT | SPEC-ST
90009239 | RAY, EDWARD L | Consultant Tech IT | MGR-ST
90009262 | RHODES, RALEIGH R | Spec SR IT | SPECSR-ST
90008869 | RUB, JEANETTE M | VP IT | VP-ST
90009152 | SHISHIDO, SCOTT T | Spec SR IT HS | SPECSR-ST
90009240 | SHORTT, [NAME] | Spec SR IT HS | SPECSR-ST
90009163 | SHUPAK, JOHN T | Spec SR IT HS | SPECSR-ST
90009222 | SMITH, BRUCE O | Dir IT | DIR-ST
90154278 | STAGGS, [NAME] | Spec SR IT HS | SPECSR-ST
90141384 | STEINER, [NAME] T | Spec SR IT | SPECSR-ST
90009214 | THELEN, TODD M | Spec IT HS | SPEC-ST
90009175 | THOMPSON, BENJAMIN J | Spec SR IT HS | SPECSR-ST
90009241 | TINER, BRENT | Spec SR IT HS | SPECSR-ST
90009176 | URIBE, CARLOS G | Spec SR IT HS | SPECSR-ST
90125756 | VAN ARSDALL, LEAH | Spec IT | SPEC-ST
90009162 | WERNER, JON J | Spec SR IT HS | SPECSR-ST
90126079 | WHITEHURST, [NAME] | Spec IT | SPEC-ST
 |  | Employees
Spreadsheet: 833183d1686829367-mutile-criterai-accross-multiple-ranges-to-return-a-sum-of-matching-values-sumproduct-index-match
Sheet: Sheet1

 |  |  |  |  |  |  | Contract Length |  |  | Contract Scope Cost |  |  |  |  |  |  |  | CRITERIA:  Match F22 in I20:K20 Match F20 in I21:K30 Match F22&F24 in L20:Q20  Return sum of [NAME]:Q30
 |  | Inputs | Contract Length | 3Y |  | Task | Contract 1 | Contract 2 | Contract 3 | Contract1A | Contract1B | Contract2A | Contract2B | Contract3A | Contract3B
 |  |  |  |  |  | Task 1 | 9Y | 9Y | 9Y | 3248 | 5259 | 7339 | 512 | 649 | 487
 |  |  | Contract Type | Contract 3 |  | Task 2 | 9Y | 3Y | 9Y | 131 | 4260 | 7874 | 7268 | 1017 | 989
 |  |  |  |  |  | Task 3 | 3Y | 9Y | 9Y | 3658 | 1975 | 1018 | 2648 | 1017 | 874
 |  |  | Contrac Scope | A |  | Task 4 | 9Y | 9Y | 3Y | 4061 | 6642 | 4376 | 4350 | 426 | 592
 |  |  |  |  |  | Task 5 | 9Y | 9Y | 9Y | 8006 | 6565 | 7703 | 2350 | 405 | 669
 |  |  |  |  |  | Task 6 | 3Y | 3Y | 3Y | 5398 | 3078 | 3399 | 7452 | 1141 | 564
 |  |  |  |  |  | Task 7 | 9Y | 3Y | 9Y | 1832 | 4934 | 136 | 3008 | 424 | 1149
 |  |  |  |  |  | Task 8 | 3Y | 9Y | 9Y | 6537 | 3092 | 7113 | 2999 | 540 | 560
 |  | Output |  |  |  | Task 9 | 9Y | 9Y | 9Y | 5281 | 8492 | 1213 | 7477 | 1047 | 1035
 |  |  |  |  |  | Task 10 | 9Y | 9Y | 3Y | 6783 | 5568 | 7252 | 6037 | 1012 | 593
Spreadsheet: 867006d1713911058-how-to-find-the-no-of-text-values-in-one-column-depending-on-criteria-in-another-column-updated
Sheet: Sheet1

 | PERCENTAGE | RESULT
 | 96.7 | Positive
 | 95 | Negative
 | 98.6 | Negative
 | 92.3 | Positive
 | 88.5 | Negative
 | 86.2 | Invalid
 | 72.3 | Negative
 | PERCENTAGE RANGES | TOTAL NO. SAMPLES | NO. OF VALID (POSITIVES AND NEGATIVES) | NO. OF INVALID
 | 70.1-80
 | 80.1-85
 | 85.1-90
 | 90.1-95
 | 95.1-100
Spreadsheet: 769772d1645683407-pull-similar-from-two-dictionary-pull-similars-kind-a-form
Sheet: Sheet1

Y | FORDONE |  |  | 6982 | DEFNOOR |  | FORDONNE |  |  | 14806 | DEFNNOOR |  | FORDONE |  |  | 6982 | DEFNOOR
 | ARAWANA |  | s | 29335 | AAAANRW |  | ANABAENA |  | s | 33833 | AAAABENN |  | FORDONNE |  |  | 14806 | DEFNNOOR
 | ARAARAS |  |  | 30780 | AAAARRS |  | ANASARCA |  | s | 35147 | AAAACNRS
 | ATAATAS |  |  | 30781 | AAAASTT |  | CARAGANA |  | s | 36517 | AAAACGNR
 | APADANA |  | s | 30925 | AAAADNP |  | CALAMATA |  | s | 39342 | AAAACLMT
 | ATALAYA |  | s | 30926 | AAAALTY |  | AMADAVAT |  | s | 39343 | AAAADMTV
 | BABALAS |  |  | 33079 | AAABBLS |  | JARARACA |  | s | 41123 | AAAACJRR
 | BACCARA |  | st | 33346 | AAABCCR |  | CALABAZA |  | s | 41522 | AAAABCLZ
 | CABBALA |  | hs | 33677 | AAABBCL |  | AQUAFABA |  | s | 41523 | AAAABFQU
 | BACCALA |  | s | 33678 | AAABCCL |  | BAASKAAP |  | s | 41524 | AAAABKPS
 | KABBALA |  | hs | 33965 | AAABBKL |  | CARACARA |  | s | 41531 | AAAACCRR
Spreadsheet: 1e6e3d62-505f-402f-966c-e52a31c5cae3
Sheet: Sheet1

Securities | % of Assets
Veresen Inc. | 3.37%
Canadian Oil Sands Ltd | 3.27%
Capital Power Corp | 3.26%
Crescent Point Energy Crp | 3.06%
Baytex Energy Corp. | 2.93%
BCE Inc. | 2.49%
Inter Pipeline Ltd. | 2.46%
Northland Power Inc | 2.43%
Pembina Pipeline Inc | 2.36%
Cdn Imperial Bk of Commrc | 2.36%
Emera Inc. | 2.33%
Freehold Royalties Ltd | 2.31%
Bank of Montreal | 2.26%
Royal Bank of Canada | 2.24%
Potash Corp of Saskatchwn | 2.23%
Enbridge Income Fund Hld | 2.22%
Sun Life Financial Inc. | 2.16%
National Bank of Canada | 2.13%
TELUS Corp. | 2.05%
Shaw Communicatn Cl B Nvs | 2.04%
Transcontinental Inc Cl A | 2.01%
IGM Financial Inc. | 2.01%
Fortis Inc. | 1.97%
ARC Resources Ltd | 1.94%
[NAME] Cl B Nvs | 1.92%
Power Financial Corp. | 1.89%
Toronto-Dominion Bank | 1.89%
Bank of Nova Scotia | 1.88%
Rogers Communications Inc | 1.87%
Great-West Life Company | 1.80%
Vermilion Energy, Inc. | 1.80%
Wajax Corporation | 1.78%
Keyera Corp | 1.76%
Thomson Reuters Corp | 1.76%
TransCanada Corp. | 1.74%
Power Corporation Canada | 1.73%
Genworth MI Canada Inc | 1.73%
Husky Energy Inc. | 1.72%
AGF Management Ltd Cl B | 1.61%
Mullen Group Ltd. | 1.58%
Enbridge Inc. | 1.57%
Brookfield Office Prop | 1.56%
Cineplex Inc. | 1.55%
Dorel Industries Inc Cl B | 1.34%
Aimia Inc. | 1.21%
Ensign Energy Srvcs Inc | 1.19%
First Capital Realty Inc | 1.19%
CI Financial Corp | 0.99%
Canexus Corporation | 0.89%
Sherritt Intl Corp | 0.78%
Cash | 0.64%
Reitmans (Cda) Ltd Cl A | 0.37%
TransAlta Corp. | 0.34%
Total Holdings in Portfolio | 53
Spreadsheet: 485622d1476979101-count-if-ryan-project-1
Sheet: Oct 1 

Category # | What Happened | My Conclusion | Report # | Firm Name | Stock Symbol | What Issue | Trade Date
1 | insert explation here | what I think | AB123 | Firm A | ABC | Other | 2015-10-01 00:00:00
2 | insert explation here | what I think | [NAME] | Firm B | DEF | B/A | 2015-10-01 00:00:00
Spreadsheet: eric_saibi__9717__010702R
Sheet: Morro Bay 3

Owner Name |  | Duke Energy Morro Bay LLC
Station Name |  | Morro Bay
Unit Name |  | Unit 03
NERC Region |  | WSCC
State |  | CA
Fuel Type |  | Natural Gas
Capacity |  | 359 MW
Start Date |  | 2002-01-06 00:00:00
End Date |  | 2002-01-26 00:00:00
Prv. Start Date |  | 2002-02-04 00:00:00
Prv. End Date |  | 2002-05-17 00:00:00
Comments |  | Could not keep the unit up; had to do pump repairs early.
SIC |  | 4931
Plant ID |  | 1008202
Unit ID |  | 1005162
Outage ID |  | 18322
Spreadsheet: 737589d1624490208-excel-formula-values-for-xlookup-are-not-coming-through-consistently-values-for-xlookup-are-not-coming-through-consistently
Sheet: Vlookup

Month Abbr. | Date | Month Number
Jan | 2021-01-01 00:00:00 | 1 | Jan
Feb | 2021-02-01 00:00:00 | 2 | Feb
Mar | 2021-03-01 00:00:00 | 3 | Mar
Apr | 2021-04-01 00:00:00 | 4 | Apr
May | 2021-05-01 00:00:00 | 5 | May
Jun | 2021-06-01 00:00:00 | 6 | Jun
Jul | 2021-07-01 00:00:00 | 7 | Jul
Aug | 2021-08-01 00:00:00 | 8 | Aug
Sep | 2021-09-01 00:00:00 | 9 | Sep
Oct | 2021-10-01 00:00:00 | 10 | Oct
Nov | 2021-11-01 00:00:00 | 11 | Nov
Dec | 2021-12-01 00:00:00 | 12 | Dec
Spreadsheet: 173893d1344843297-update-master-file-columns-with-columns-from-slave-files-kelvin
Sheet: Kelvin

Date | Customer Name | Contact No. | [NAME] | [NAME] (RM) | Call Back Time | PFM | 1st Attemp | 2nd Attemp | 3rd Attemp | STATUS | Remark | Submission Date | Approval Date | [NAME] case
2012-05-01 00:00:00 | [NAME] | 6016xxxxxxx | [EMAIL] | 6000 | From 8.30am to 5.30pm | [NAME]
2012-05-01 00:00:00 | [NAME] | 6012xxxxxxxx (Mobile) | [EMAIL] | 100000 | From 10am to 12am | [NAME] |  |  |  |  |  | 2012-05-03 00:00:00
Spreadsheet: 152720d1335482713-calculating-of-patients-in-process-by-hour-of-day-patients-in-process
Sheet: Sheet1

 |  |  | Monday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday
 |  |  | Morning |  |  |  |  |  |  |  |  |  |  |  | Afternoon/Evening |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Morning |  |  |  |  |  |  |  |  |  |  |  | Afternoon/Evening
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
Patient ID | Start Hour | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Patient ID | Start hour | Start Hour | [NAME]
1 | 5 | 24 |  |  |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |  | 1 |  | 1 | 4 | x | x | x | x
2 | 12 | 16 |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X | X |  |  |  |  |  |  |  |  |  | 2 | 2 | 2 |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
3 | 5 | 7 |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
4 | 15 | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X | X | X | X |  | 4 |  | 1 | 2 | x | x
5 | 10 | 14 |  |  |  |  |  |  |  |  |  | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  | 5
6 | 8 | 13 |  |  |  |  |  |  |  | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 5 | 5 |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
7 | 3 | 5 |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
8 | 22 | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X |  | 8 |  | 1 | 24 | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
9 | 13 | 16 |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X |  |  |  |  |  |  |  |  |  | 9
10 | 24 | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  | 10 |  | 1
 |  | Hour of Day |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hour of Day
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
# of Patient in Process |  |  | 0 | 0 | 1 | 1 | 3 | 2 | 2 | 2 | 2 | 3 | 3 | 4 | 5 | 4 | 4 | 4 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 4 |  | # of Patient in Process |  |  |  | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
Spreadsheet: darrell_schoolcraft__7306__imball0201
Sheet: SidR

 | [NAME]
 | POI 1190 - Keystone Plant Outlet
Day | Measured | Scheduled
1 | 55927 | 56112
2 | 45352 | 41112
3 | 39348 | 38072
4 | 57516 | 58575
5 | 38360 | 38612
6 | 38227 | 38612
7 | 38252 | 38612
8 | 53083 | 55820
9 | 32289 | 18110
10 | 38336 | 40659
11 | 45961 | 45820
12 | 58658 | 58864
13 | 58648 | 58864
14 | 53073 | 52864
15 | 43337 | 45610
16 | 42964 | 45253
17 | 48358 | 50595
18 | 46348 | 48259
19 | 57495 | 59137
20 | 59012 | 59137
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  | 40735.55
2002-01-20 00:00:00
CBS Volume
 |  |  | 19256
Spreadsheet: 468551d1467352879-lookup-problem-to-excel-forum-010716
Sheet: receipt

 | rdate | [NAME] | Date |  | Particulars | Voucher
M/S M | 2015-05-26 00:00:00 |  | [NAME] | LS/15-16/1315 | 100
M/S E | 2015-05-26 00:00:00 |  | [NAME] | LS/14-15/7939 | 101
M/S C | 2015-05-26 00:00:00 |  | [NAME] | LS/14-15/8000 | 102
M/S C | 2015-05-26 00:00:00 |  | [NAME] | LS/14-15/7772 | 103
M/S C | 2015-05-26 00:00:00 |  | [NAME] | LS/14-15/8008 | 104
formula in c column | INDEX(sales!$A$1:$A$45000,MATCH(1,(sales!$B$1:$B$45000=RECEIPTS!A7862)*(sales!$D$1:$D$45000[NAME]))
formula in h column | [NAME])))
The last figure in ecolumn may differ by 1 or 2  so if idont get result in c colmn I will get in hcolumn
actual data is around 50000 rows