tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 181fd2d5-b923-45f2-ba3d-dbbd79badfa3
Sheet: 2006-07

Table Q
Full Time Affiliate Student numbers
Department | Undergraduate |  |  | Graduate |  |  | Total
 | Home | Overseas | Total | Home | Overseas | Total
Anthropology | 0 | 5 |  | 0 | 0
Institute of Archaeology | 0 | 5 |  | 0 | 0
Bartlett School of Graduate Studies | 0 | 0 |  | 0 | 1
Bartlett School of Planning | 1 | 3 |  | 3 | 2
Biochemical Engineering | 3 | 0 |  | 0 | 0
Biochemistry and Molecular Biology | 2 | 0 |  | 1 | 0
Biology | 0 | 8 |  | 0 | 0
Centre for Intercultural Studies | 0 | 0 |  | 1 | 0
Chemical Engineering | 6 | 6 |  | 4 | 0
Chemistry | 3 | 4 |  | 0 | 0
Institute of Child Health | 0 | 4 |  | 0 | 0
Civil and Environmental Engineering | 0 | 2 |  | 0 | 1
Faculty of Clinical Sciences | 1 | 0 |  | 0 | 0
Computer Science | 6 | 6 |  | 1 | 0
[NAME] and Literature | 4 | 1 |  | 1 | 0
Earth Sciences | 1 | 2 |  | 0 | 0
Eastman Dental Institute | 0 | 0 |  | 13 | 4
Economics | 0 | 55 |  | 2 | 1
Electronic and Electrical Engineering | 1 | 4 |  | 0 | 0
English Language and Literature | 0 | 41 |  | 1 | 0
European Social and Political Studies | 3 | 0 |  | 0 | 0
Slade School of Fine Art | 3 | 11 |  | 0 | 0
French | 24 | 9 |  | 1 | 0
Geography | 12 | 7 |  | 0 | 1
Geomatic Engineering | 1 | 0 |  | 0 | 0
German | 18 | 3 |  | 0 | 0
Greek and Latin | 2 | 3 |  | 1 | 0
Hebrew and Jewish Studies | 0 | 6 |  | 2 | 0
History | 5 | 30 |  | 6 | 2
History of Art | 3 | 14 |  | 0 | 0
Italian | 24 | 0 |  | 5 | 0
Language Centre (Affiliates) | 9 | 137 |  | 0 | 0
Laws | 50 | 2 |  | 0 | 46
Mathematics | 1 | 7 |  | 0 | 0
Mechanical Engineering | 0 | 3 |  | 0 | 0
Medical Physics | 1 | 0 |  | 0 | 0
Philosophy | 0 | 17 |  | 0 | 0
Phonetics and [NAME] | 2 | 3 |  | 0 | 0
Physics and Astronomy | 6 | 7 |  | 0 | 0
Political Science | 0 | 29 |  | 0 | 0
Psychology | 2 | 43 |  | 3 | 0
Scandinavian Studies | 4 | 2 |  | 0 | 0
School of Slavonic and E. European Stds | 19 | 4 |  | 3 | 2
Science and Technology Studies | 0 | 1 |  | 0 | 0
Spanish and Latin American Studies | 7 | 1 |  | 0 | 0
Statistical Science | 3 | 0 |  | 0 | 0
Total
Faculty | Undergraduate |  |  | Graduate |  |  | Total
 | Home | Overseas | Total | Home | Overseas | Total | Male
Arts and Humanities | 98 | 231 |  | 12 | 0
Biomedical Sciences | 1 | 4 |  | 13 | 4
Built Environment | 1 | 3 |  | 3 | 3
Engineering Sciences | 18 | 21 |  | 5 | 1
Laws | 50 | 2 |  | 0 | 46
Life Sciences | 6 | 54 |  | 4 | 0
Mathematical and Physical Sciences | 14 | 21 |  | 0 | 0
Social and Historical Sciences | 39 | 149 |  | 11 | 6
Total
As figures relate to the official HEFCE census date, 1 December, affiliate students who start in January are not included.
Spreadsheet: 177c6bf1-b764-4cfd-9332-4d346013bfa8
Sheet: Advising

 | Group | Advisor | [NAME] | Total Advised | Pending Graduation | [NAME] | Transferring | Not Returning | Not Advised | Semester Total | Registered for next sem
Fall 2010 | 194 | - | 55 |  | 37 | - | - | - | - | 480 | -
Spring 2011 | 172 | 123 | 53 |  | 47 | 9 | 10 | 6 | 17 |  | -
Fall 2011 | 197 | 115 | 50 |  | 53 | 13 | 6 | 4 | 9 |  | -
Spring 2012 | 134 | - | 51 |  | 47 | - | - | - | - | 405 | -
Fall 2012 | 153 | 141 | 57 |  | 38 | 2 | 1 | 2 | 15 |  | -
Spring 2013 | 123 | 96 | 35 |  | 62 | 7 | 6 | 11 | 11 |  | 203
*Reports used for adivisng are pulled from COGNOS when advising begins (they may not match [NAME] numbers due to students changing majors throughout the semester)
*Fall 2010 First full semester with staff advisor data tracking processes were still in planning stage
*Spring 2012 data incomplete due to staff advisor being on leave
Spreadsheet: 204912d1357676993-sorting-groups-as-block-depending-on-there-header-title-groupsorting
Sheet: Sheet1

Student ID | Course Name | Room Number | Start Date | End Date
122555666 | Course Name | Room Number | 2012-12-10 00:00:00 | 2013-06-19 00:00:00
122555666 | Math | 505 | 2012-12-10 00:00:00 | 2012-12-28 00:00:00
122555666 | English | 606 | 2013-01-12 00:00:00 | 2013-02-10 00:00:00
122555666 | History | 101 | 2013-02-11 00:00:00 | 2013-03-29 00:00:00
122555666 | Geography | 308 | 2013-03-15 00:00:00 | 2013-06-19 00:00:00
136878926 | Course Name | Room Number | 2012-11-10 00:00:00 | 2013-05-17 00:00:00
136878926 | Math | 104 | 2012-11-10 00:00:00 | 2012-11-28 00:00:00
136878926 | English | 202 | 2013-02-12 00:00:00 | 2013-03-10 00:00:00
136878926 | History | 704 | 2013-04-11 00:00:00 | 2013-05-02 00:00:00
136878926 | Geography | 801 | 2013-05-15 00:00:00 | 2013-05-17 00:00:00
254995627 | Course Name | Room Number | 2013-02-10 00:00:00 | 2013-09-19 00:00:00
254995627 | Math | 106 | 2013-02-10 00:00:00 | 2012-02-28 00:00:00
254995627 | English | 702 | 2013-02-12 00:00:00 | 2013-03-10 00:00:00
254995627 | History | 505 | 2013-04-11 00:00:00 | 2013-05-29 00:00:00
254995627 | Geography | 104 | 2013-05-15 00:00:00 | 2013-09-19 00:00:00
Spreadsheet: 691960d1597973810-how-make-excel-automatically-choose-from-a-list-off-missing-items-excel-forum-attachment-sample
Sheet: Sheet1

 | designs they already have (have=1;don't have=0) |  |  |  |  |  |  |  |  |  | next design to send
name | peacock | rose | daisy | cleopatra | [NAME] | butterfly | bunny | reign | coral | feline
[NAME] | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Rachel | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
Mandy | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0
[NAME] | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Zena | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0
all available designs | priority
peacock | 1
rose | 2
daisy | 3
cleopatra | 4
[NAME] | 5
butterfly | 6
bunny | 7
reign | 8
coral | 9
feline | 10
Spreadsheet: 856700d1705920155-pivot-table-from-different-sheets-not-in-a-nice-large-data-table-attendance-missed-session-catch-up-log-test
Sheet: Learner15

 | Attendance |  |  |  | Additional support plans
Name | P3 | P6 | P9 | P12 | Declared but Declined | University Learning Support Plan from DDSS | Departmental Support plan | Return to Learning Support Plan | Functional Skills training and progress
Learner15
Session missed | Module | Tutor(s) | How missed work was caught up |  |  | Auto completed by Att spreadsheet
2023-09-06 00:00:00 | MGT61102 | Tutor 2 | Resources on blackboard |  |  | PS to link
 |  |  |  |  |  | PS to complete
 |  |  |  |  |  | tutor to complete
Spreadsheet: 747675d1631638146-counting-text-across-multiple-rows-and-columns-sample2
Sheet: SUMMARY

Location | Department | Floor | Held Sessions
Location A | URGENT CARE | 1
Location A | CARDIOLOGY | 1
Location A | GENERAL SURGERY | 1
Location A | NEUROLOGY | 2
Location A | PEDIATRICS | 2
Spreadsheet: 140511d1328793903-alternative-to-vlookup-bookah
Sheet: Sheet1

 |  | Mean is:
 |  | 0.5 | 1 | 1.5 | 2 | 2.5 | 3 | 3.5 | 4 | 4.5 | 5 | 6 | 7 | 8 | 9
 |  | 0 | 0 | 6 | 12 | 29 | 19 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 |  | I want to find the [NAME] value in row c5 :p5 then display the corresponding value from row c4 :p4 in F3
 |  | The lookup doesn’t work because the numbers will not be in ascending order, also the values in row 4 can be changed by the user.
 |  |  | Thanks
Spreadsheet: 138666d1327804998-automation-of-roster-spreadsheet-roster-spreadsheet
Sheet: Sheet1

 |  |  |  |  |  |  | OVERTIME
 | Date | IN | OUT | TOTAL | Actual | WORK | BALANCE
THU | 1 | 7.55 | 21.13 |  |  | 12 | 1
FRI | 2 | 8.03 | 20.09 |  |  | 12
SAT | 3 | 8 | 17.04 |  |  | 9
SUN | 4
MON | 5 | 6 | 19.03 |  |  | 12 | 1
TUE | 6 | 5.55 | 19.26 |  |  | 12 | 1
WED | 7 | 5.55 | 18 |  |  | 12
THU | 8 | 5.55 | 18 |  |  | 12
FRI | 9 | 5.57 | 18.03 |  |  | 12
SAT | 10 | 5.53 | 15.01 |  |  | 9
SUN | 11
MON | 12 | 8.04 | 20.14 |  |  | 12
TUE | 13 | 7.58 | 23 |  |  | 12 | 1 | 2
WED | 14 | 8.03 | 20.53 |  |  | 12 | 0.5
THU | 15 | 7.56 | 20.12 |  |  | 12 | 0.5
FRI | 16 | 7.58 | 23 |  |  | 12
SAT | 17 | 7.53 | 17.05 |  |  | 9
SUN | 18
MON | 19 | 5.55 | 18 |  |  | 12
TUE | 20 | 5.57 | 18.01 |  |  | 12
WED | 21 | 5.57 | 18.09 |  |  | 12 | 0.5
THU | 22 | 5.58 | 18.23 |  |  | 12 | 0.5
FRI | 23 | 5.47 | 21.05 |  |  | 12 | 1 | 2.5
SAT | 24 | 5.58 | 17.12 |  |  | 9 | 1 | 1.5
SUN | 25 | 7.59 | 16.07 |  |  | 9 | 1 | 7
MON | 26
TUE | 27
WED | 28 | 7.58 | 22.57 |  |  | 12 | 0.5 | 2
THU | 29 | 7.56 | 20.04
FRI | 30
SAT | 31
Spreadsheet: 57265d1257378695-sumif-or-countif-licensingtest
Sheet: Sheet1

User | Department |  | Total Overall |  | Department | Total by Department | Total open Licenses
user 1 | 001 Executive |  |  |  | 001 Executive |  | 2
user 2 | 013 Counsel |  |  |  | 002 Govt
user 3 | 001 Executive |  |  |  | 013 Counsel
open | 001 Executive |  |  |  | 014 Collateral
open | 001 Executive |  |  |  | 024 VP/Audit
 |  |  |  |  | 030 Market
 |  |  |  |  | 040 Credit
 |  |  |  |  | 042 Lending Srv
 |  |  |  |  | 043 Wholesale Lending
 |  |  |  |  | 050 Chief Financial Off
 |  |  |  |  | 062 Treasury
 |  |  |  |  | 063 Controllers
 |  |  |  |  | 065 Support Services
 |  |  |  |  | 070 ISG Admin
 |  |  |  |  | 071 ISG Tech
 |  |  |  |  | 073 ISG IT Client
 |  |  |  |  | 075 ISG App
 |  |  |  |  | 078 ISG Comp Op
 |  |  |  |  | 082 Insurance
 |  |  |  |  | 089 Bank HR
 |  |  |  |  | 090 HR VP
 |  |  |  |  | 092 HR Foundation
 |  |  |  |  | 093 Admin Service
 |  |  |  |  | 095 HR Meetings
 |  |  |  |  | 098 Travel
 |  |  |  |  | 099 Workforce
 |  |  |  |  | 100 ITU
 |  |  |  |  | 662 Treasury Op
 |  |  |  |  | 663 Financial Reporting
 |  |  |  |  | 762 Investments
 |  |  |  |  | 763 [NAME]
 |  |  |  |  | 850 Business Planning
 |  |  |  |  | 862 A/L Risk
 |  |  |  |  | 863 Corp Tax
 |  |  |  |  | 898 Minerals
 |  |  |  |  | 962 Deriv Mkt
Spreadsheet: chris_dorland__1612__Forwards Detail-ZARGON_JAN17
Sheet: Results (2)

CAD/GJ
 |  |  |  |  |  |  |  |  | Totals
 |  | Phy/ |  |  | Monthly | PV | Discount | Mid | Fixed |  | Mid
Counterparty | Deal Num | Fin | Pub Code | Period | Quantity | Quantity | Factor | Price | Price | Cash | Value | POST ID
ZARGONOILGAS | Y16576.1 | F | NGMR-AECO/C | 01-APR-2002 | 30000 | 29872.5464 | 0.9957515473172199 | 2.83275701 | 3.94 | 0 | -33076.1675 | 1467836
ZARGONOILGAS | Y16576.1 | F | NGMR-AECO/C | 01-MAY-2002 | 31000 | 30816.5174 | 0.994081206248708 | 2.93712043 | 3.94 | 0 | -30905.2559 | 1467836
ZARGONOILGAS | Y16576.1 | F | NGMR-AECO/C | 01-JUN-2002 | 30000 | 29769.1951 | 0.992306503452686 | 3.02908367 | 3.94 | 0 | -27117.246 | 1467836
ZARGONOILGAS | Y16576.1 | F | NGMR-AECO/C | 01-JUL-2002 | 31000 | 30707.3675 | 0.990560242908222 | 3.14380128 | 3.94 | 0 | -24449.1668 | 1467836
ZARGONOILGAS | Y16576.1 | F | NGMR-AECO/C | 01-AUG-2002 | 31000 | 30649.9259 | 0.9887072858141319 | 3.21410352 | 3.94 | 0 | -22248.6733 | 1467836
ZARGONOILGAS | Y16576.1 | F | NGMR-AECO/C | 01-SEP-2002 | 30000 | 29604.8874 | 0.9868295798252651 | 3.21551428 | 3.94 | 0 | -21448.3183 | 1467836
ZARGONOILGAS | Y16576.1 | F | NGMR-AECO/C | 01-OCT-2002 | 31000 | 30532.2709 | 0.984911965686998 | 3.28553318 | 3.94 | 0 | -19982.3583 | 1467836
ZARGONOILGAS | Y39286.1 | F | NGMR-AECO/C | 01-APR-2002 | 30000 | 29872.5464 | 0.9957515473172199 | 2.83275701 | 3.86 | 0 | -30686.3638 | 1467836
ZARGONOILGAS | Y39286.1 | F | NGMR-AECO/C | 01-MAY-2002 | 31000 | 30816.5174 | 0.994081206248708 | 2.93712043 | 3.86 | 0 | -28439.9345 | 1467836
ZARGONOILGAS | Y39286.1 | F | NGMR-AECO/C | 01-JUN-2002 | 30000 | 29769.1951 | 0.992306503452686 | 3.02908367 | 3.86 | 0 | -24735.7104 | 1467836
ZARGONOILGAS | Y39286.1 | F | NGMR-AECO/C | 01-JUL-2002 | 31000 | 30707.3675 | 0.990560242908222 | 3.14380128 | 3.86 | 0 | -21992.5774 | 1467836
ZARGONOILGAS | Y39286.1 | F | NGMR-AECO/C | 01-AUG-2002 | 31000 | 30649.9259 | 0.9887072858141319 | 3.21410352 | 3.86 | 0 | -19796.6792 | 1467836
ZARGONOILGAS | Y39286.1 | F | NGMR-AECO/C | 01-SEP-2002 | 30000 | 29604.8874 | 0.9868295798252651 | 3.21551428 | 3.86 | 0 | -19079.9273 | 1467836
ZARGONOILGAS | Y39286.1 | F | NGMR-AECO/C | 01-OCT-2002 | 31000 | 30532.2709 | 0.984911965686998 | 3.28553318 | 3.86 | 0 | -17539.7766 | 1467836
Spreadsheet: 91871d1291572327-how-to-make-a-single-number-equal-a-dollar-amount-in-next-cell-city-contract-billing-form-revised-12-4-10-sample-
Sheet: Sheet1

CODE: |  |  |  | BUILDING ADDRESS:
OCEAN AIR ENTERPRISES CORP |  |  |  |  | BILLING / WORK ORDER
 | A/C # | DATE | ROOM # | WORK DONE | ITEM | AMOUNT | NAME / SIGNATURE
1 | 58468 | 2010-12-03 00:00:00 | 7118 | Uncover | 7 | 70 | [NAME]
 |  |  |  | Top Window | 11 | 100
2 | 764563 | 2010-12-04 00:00:00 | 517 | Uncover | 7 | 70 | [NAME]
 |  |  |  | Top Window | 11 | 100
3 | 536777 | 2010-12-05 00:00:00 | 618 | Service | 5 | 25 | [NAME]
 |  |  |  | Compressor | 17 | 80
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
 |  |  |  | PAGE TOTAL
Spreadsheet: 41288d1239788689-grabbing-data-from-a-cell-on-another-worksheet-if-book1
Sheet: Day 2

Probate Valuation Worksheet
Holding | Sort | SEDOL | Security | Price (p) | Value (£) | Income/  Interest (£) | Country |  | 1/4 up Low | 1/4 up High | Trade Low | Trade High |  | Bid | Offer | Single |  | Buyer | [NAME] | Single
10000 | 1 | 3278592 | UNITED KINGDOM(GOVERNMENT OF) 4% STK 07/03/2009 GBP100 | 100.3695 | 1003695 | 47.34 | E&W | DOL: | 100.359 | 100.361 | 100.2 | 100.5 | Unit Trusts: |  |  |  | Overseas: |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 2
5800 | 1 | 0309019 | ELECTRIC & GENERAL INV TST PLC ORD GBP0.05 | 305.5 | 1771900 | 0 | E&W | DOL: | 296.5 | 297 | 295.87 | 302.5 | Unit Trusts: |  |  |  | Overseas: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
5300 | 5 | 3018408 | FIRST STATE INVESTMENTS(UK) ASIA PACIFIC B ACC NAV | 369.56 | 1958668 | 0 | E&W | DOL: | 492.641 | 493.639 | 491.54 | 504.5 | Unit Trusts: |  |  | 356.02 | Overseas: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
250 | 2 | 1123245 | PEARSONS PLC | 301.7 | 75425 | 0 | E&W | DOL: | 688.782 | 690.278 | 687.21 | 706.5 | Unit Trusts:
5610 | 3 | 23123123 | TRUMAN CO | 301 | 1688610 | 0 | E&W | DOL: | 884.923 | 886.917 | 882.88 | 908.5 | Unit Trusts:
Spreadsheet: andy_zipper__189__Broker detail 5-22-01
Sheet: FAILED DEALS SUMMARY

Failed Transactions:
LIFE TO DATE
FAILED TRANSACTION COUNT |  | Commodity
Broker | Failed Reason | Natural Gas | Power | Grand Total
APB Energy, Inc. | FAILURE: counterparty exceeded credit limit | 1 |  | 1
 | [NAME]: counterparty has no bid access to product | 1 | 6 | 7
 | [NAME]: counterparty has no offer access to product |  | 2 | 2
 | FAILURE: Limit price violated |  | 12 | 12
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 6 |  | 6
 | FAILURE: Volume not available for base product of hedge | 1 |  | 1
 | FAILURE: Order pended due to limit price violation | 11 | 2 | 13
APB Energy, Inc. Total |  | 20 | 22 | 42
Natsource LLC | FAILURE: counterparty exceeded credit limit |  | 5 | 5
 | [NAME]: counterparty has no bid access to product | 1 | 3 | 4
 | [NAME]: counterparty has no offer access to product |  | 5 | 5
 | FAILURE: Limit price violated | 1 | 12 | 13
 | [NAME]: product violates counterparty term limit |  | 3 | 3
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 1 | 8 | 9
 | FAILURE: Base product not active for hedge | 1 |  | 1
Natsource LLC Total |  | 4 | 36 | 40
Power Merchants Groupas Corporation | [NAME]: product violates counterparty term limit | 1 |  | 1
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 1 |  | 1
Power Merchants Groupas Corporation Total |  | 2 |  | 2
Power Merchants Group, LLC | FAILURE: counterparty exceeded credit limit | 1 |  | 1
 | [NAME]: counterparty has no offer access to product | 1 |  | 1
 | FAILURE: Limit price violated | 10 |  | 10
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 2 |  | 2
 | FAILURE: Order pended due to limit price violation | 3 |  | 3
Power Merchants Group, LLC Total |  | 17 |  | 17
Power Merchants Grouping & Trading Inc. | [NAME]: counterparty has no offer access to product | 1 |  | 1
Power Merchants Grouping & Trading Inc. Total |  | 1 |  | 1
Amerex Natural Gas I, Ltd. | FAILURE: Limit price violated | 1 |  | 1
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 3 |  | 3
Amerex Natural Gas I, Ltd. Total |  | 4 |  | 4
Amerex Power, Ltd. | [NAME]: counterparty has no access to product |  | 1 | 1
Amerex Power, Ltd. Total |  |  | 1 | 1
Grand Total |  | 48 | 59 | 107
Spreadsheet: 216904d1361916437-subtotal-max-min-with-if-urgent-help-required-apple-orange-banana-filter-example
Sheet: Sheet1

AutoFilter Field | Criteria Field | Value Field
Orange | X | 2
Apple | X | 10
[NAME] | Y | 12
Orange | X | 24
Apple | Z | 13
[NAME] | Z | 14
[NAME] | X | 16
Apple | Z | 18
Orange | Y | 20
 | Count | Total | Min | [NAME]
X
Y
Spreadsheet: 114813d1310518789-sum-and-vlookup-vlookup_gpi
Sheet: Summary_lookup

Name of Account manager | Hub ID | Total-All(royal, excellent, retail) of Mortgage Life Opp | Total-All(royal, excellent, retail) of Mortgage Life Disability Opp
[NAME] | 9211 | 269 | 220
Jona smith | jona | 209 | 137
[NAME] | tina | #N/A | #N/A
 |  | supposed formula (not work)
 | tina | #N/A | #N/A
Spreadsheet: 2166cd6b-0b3d-46a0-b2bf-3b8b89140504
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
261677 | 72708 | Arnaud | Grandjean | FRA |  | 00:18:15 | 00:01:06 | [NAME] | 00:01:38 | 00:09:30 | 1 | 01:05:15
261677 | 72682 | Arnaud | Savio B1 | FRA | 0 | 00:19:30 | 00:01:05 | 00:36:44 | 00:01:27 | 00:09:05 | 2 | 01:07:49
261677 | 72709 | [NAME] | Paradoux | FRA |  | 00:18:54 | 00:00:40 | 00:39:27 | 00:01:11 | 00:09:17 | 3 | 01:09:26
261677 | 56297 | [NAME] | Bocchi | ITA | 0 | 00:22:58 | 00:00:50 | 00:39:42 | 00:01:24 | 00:11:16 | 4 | 01:16:07
261677 | 11536 | [NAME] | Rieb | FRA | 0 | 00:23:36 | 00:00:59 | [NAME] | 00:01:35 | 00:11:30 | 5 | 01:24:27
Spreadsheet: 111954d1308170580-vlookup-multiple-instances-of-lookup-value-super-vlookup2
Sheet: Sheet1

 | ORIGINAL DATABASE |  |  |  |  |  | NEW DATABASE
 | [NAME] | First name | Surname | Course |  |  | [NAME] | Name | Surname | Street
 | 27052825 | Matthews | [NAME] | NVQ in [NAME] |  |  | 27061733
 | 27061733 | [NAME] | Sindi | Key Skills in Application of Number - level 1 |  |  | 28058793
 | 28056792 | bob | [NAME] | NVQ in [NAME] |  |  | 28064165
 | 28058793 | [NAME] | [NAME] | Key Skills in Application of Number - level 1 |  |  | 28070572
 | 28064165 | Stevie | [NAME] | Key Skills in Application of Number - level 2
 | 28070572 | [NAME] | La | Key Skills in Application of Number - level 2
 | 28070572 | Nick | Davies | Key Skills in Application of Number - level 2
 | 28071961 | [NAME] | Chapman | NVQ in [NAME]
COLUMNS($A$1:B$1) simply results in a number.. the number of columns within the range Identified.
This is a technique used to replace the Index Column Number hard coding, so that you can copy the
formula across and have it automatically increase the column index number for the vlookup automatically.
So COLUMNS($A$1:B$1) results in 2 (column 2)
when you copy across this over to next columns it becomes COLUMNS($A$1:C$1) which results in 3 so it will now look in 3rd column.. and so on.
the Columns() function only counts the number of columns between the specified range.
It does not matter if they are empty or not... It has nothing to do with the data in the columns.
See the Column and Columns functions (Also Row and Rows) in Excel help for more.
Spreadsheet: phillip_m_love__30648__9908_OA
Sheet: TX-EGM-GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  TEXAS
 |  |  | Total |  | Reclasses |  | August |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations |  |  |  |  |  |  |  | 0
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  | 0 |  | 978000
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
FT-South Texas
 |  | Current Month MTM |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Financial Liquidations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Originations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: 65178d1265895404-print-range-of-cells-factory-kpis-2010-2011new
Sheet: DSA

DELIVERY SCHEDULE ADHERENCE
 |  |  |  |  |  |  |  | * denotes an input cell
 |  |  |  |  | FAILURE CATEGORIES
Date | Planned despatch | On Time to Despatch | Percentage Complete | Failures | Short lead time | Paperwork | Other
Plan
2010-05-03 00:00:00 | 0 | 0 | #N/A | 0
2010-05-10 00:00:00 | 0 | 0 | #N/A | 0
2010-05-17 00:00:00 | 0 | 0 | #N/A | 0
2010-05-24 00:00:00 | 0 | 0 | #N/A | 0
2010-05-31 00:00:00 | 0 | 0 | #N/A | 0
Month end | 0 | 0 | #N/A | 0
2010-06-07 00:00:00 | 0 | 0 | #N/A | 0
2010-06-14 00:00:00 | 0 | 0 | #N/A | 0
2010-06-21 00:00:00 | 0 | 0 | #N/A | 0
2010-06-28 00:00:00 | 0 | 0 | #N/A | 0
Month end | 0 | 0 | #N/A | 0
2010-07-05 00:00:00 | 0 | 0 | #N/A | 0
2010-07-12 00:00:00 | 0 | 0 | #N/A | 0
2010-07-19 00:00:00 | 0 | 0 | #N/A | 0
2010-07-26 00:00:00 | 0 | 0 | #N/A | 0
Month end | 0 | 0 | #N/A | 0
2010-08-02 00:00:00 | 0 | 0 | #N/A | 0
2010-08-09 00:00:00 | 0 | 0 | #N/A | 0
2010-08-16 00:00:00 | 0 | 0 | #N/A | 0
2010-08-23 00:00:00 | 0 | 0 | #N/A | 0
2010-08-30 00:00:00 | 0 | 0 | #N/A | 0
Month end | 0 | 0 | #N/A | 0
2010-09-06 00:00:00 | 0 | 0 | #N/A | 0
2010-09-13 00:00:00 | 0 | 0 | #N/A | 0
2010-09-20 00:00:00 | 0 | 0 | #N/A | 0
2010-09-27 00:00:00 | 0 | 0 | #N/A | 0
Month end | 0 | 0 | #N/A | 0
2010-10-04 00:00:00 | 0 | 0 | #N/A | 0
2010-10-11 00:00:00 | 0 | 0 | #N/A | 0
2010-10-18 00:00:00 | 0 | 0 | #N/A | 0
2010-10-25 00:00:00 | 0 | 0 | #N/A | 0
Month end | 0 | 0 | #N/A | 0
2010-11-01 00:00:00 | 0 | 0 | #N/A | 0
2010-11-08 00:00:00 | 0 | 0 | #N/A | 0
2010-11-15 00:00:00 | 0 | 0 | #N/A | 0
2010-11-22 00:00:00 | 0 | 0 | #N/A | 0
2010-11-29 00:00:00 | 0 | 0 | #N/A | 0
Month end | 0 | 0 | #N/A | 0
2010-12-06 00:00:00 | 0 | 0 | #N/A | 0
2010-12-13 00:00:00 | 0 | 0 | #N/A | 0
2010-12-20 00:00:00 | 0 | 0 | #N/A | 0
2010-12-27 00:00:00 | 0 | 0 | #N/A | 0
Month end | 0 | 0 | #N/A | 0
2011-01-03 00:00:00 | 0 | 0 | #N/A | 0
2011-01-10 00:00:00 | 0 | 0 | #N/A | 0
2011-01-17 00:00:00 | 0 | 0 | #N/A | 0
2011-01-24 00:00:00 | 0 | 0 | #N/A | 0
2011-01-31 00:00:00 | 0 | 0 | #N/A | 0
Month end | 0 | 0 | #N/A | 0
2011-02-07 00:00:00 | 0 | 0 | #N/A | 0
2011-02-14 00:00:00 | 0 | 0 | #N/A | 0
2011-02-21 00:00:00 | 0 | 0 | #N/A | 0
2011-02-28 00:00:00 | 0 | 0 | #N/A | 0
Month end | 0 | 0 | #N/A | 0
2011-03-07 00:00:00 | 0 | 0 | #N/A | 0
2011-03-14 00:00:00 | 0 | 0 | #N/A | 0
2011-03-21 00:00:00 | 0 | 0 | #N/A | 0
2011-03-28 00:00:00 | 0 | 0 | #N/A | 0
Month end | 0 | 0 | #N/A | 0
2011-04-04 00:00:00 | 0 | 0 | #N/A | 0
2011-04-11 00:00:00 | 0 | 0 | #N/A | 0
2011-04-18 00:00:00 | 0 | 0 | #N/A | 0
2011-04-25 00:00:00 | 0 | 0 | #N/A | 0
Month end | 0 | 0 | #N/A | 0