tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 103846d1301515287-multiple-data-pieces-michelley_sample-1-
Sheet: Sheet1

[NAME] | Name | Date | Store | Reminder | Reminder2 | Reminder3 | [NAME]. |  | Sept 2 2010 | CD
[EMAIL] | [NAME] | Sept 2 2010 | 2 | DEC | DEC | NA | AB |  |  |  |  | Sept 2 2010 |  | AB
[EMAIL] | [NAME] | Sept 2 2010 | 2 | DEC | DEC | NA | CD |  |  |  |  | Jan 2 2011 |  | CD
[EMAIL] | Smith | Sept 2 2010 | 2 | DEC | MAY | NA | CD |  |  |  |  | Jul 8 2011 |  | EF
[EMAIL] | [NAME] | Sept 2 2010 | 2 | DEC | DEC | NA | EF
[EMAIL] | [NAME] | Jan 2 2011 | 2 | DEC | NA | NA | AB
[EMAIL] | [NAME] | Jan 2 2011 | 2 | DEC | JAN | NA | EF
[EMAIL] | [NAME] | Jan 2 2011 | 2 | DEC | AUG | NA | CD
[EMAIL] | [NAME] | Jul 8 2011 | 1 | SEP | FEB | SEP | EF
Spreadsheet: 705205d1605925962-averaging-a-set-of-numbers-depending-on-a-condition-manualexample-201121
Sheet: Manual

Round | A | B | SD | HCP-SD | Adjustment | HCP | Comment on HCP | Comment on Adjustment
 | 22 | 10
 | 24 | 13
 | 23 | 12
 | 25 | 14
 | 23 | 15 |  |  |  |  | HCP=Average of 8,11,11
 | 22 | 10 |  |  |  |  | HCP=Average of 8,11,11
 | 21 | 13 |  |  | -1 |  | HCP=Average of 8,8,11
 | 20 | 12 |  |  | -1 |  | HCP=Average of 8,8,8
 | 24 | 14 |  |  | -1 |  | HCP=Average of 8,8,8
 | 25 | 15 |  |  | -1 |  | HCP=Average of 8,8,10
 | 10 | 10 |  |  | -1 | 4.33333333333333 | HCP=Average of -1,7,7 | 8,7-0 >=5 so subract 1 from 5 most recent SDs
 | 23 | 13 |  |  |  | 5 | HCP=Average of -1,7,9
 | 21 | 12 |  |  |  | 5.666666666666667 | HCP=Average of -1,9,9
 | 17 | 14 |  |  | -1 | 3.66666666666667 | HCP=Average of -1,3,9
 | 25 | 15 |  |  | -1 | 3.66666666666667 | HCP=Average of -1,3,9
 | 23 | 10 |  |  | -1 | 7.333333333333333 | HCP=Average of -1,3,9
 | 22 | 13 |  |  | -1 / -1 | 7 | HCP=Average of 3,9,9
 | 6 | 12 |  |  | -1 / -1 | 1 | HCP=Average of -7,2,8 | 7-(-6) >=5 so subract 1 from 5 most recent SDs
 | 20 | 14 |  |  | -1 | 2.333333333333333 | HCP=Average of -7,6,8
 | 10 | 10 |  |  | -1 | -0.333333333333333 | HCP=Average of -7,0,6
 | 5 | 13 |  |  | -1 | -6 | HCP=Average of -9,-8,-1 | -8-(-0,3) >=5 so subract 1 from 5 most recent SDs
 | 26 | 12 |  |  |  | -6 | HCP=Average of -9,-8,-1
 | 25 | 20 |  |  |  | -1.666666666666667 | HCP=Average of -9,-1,5
 | 23 | 22 |  |  |  | -3 | HCP=Average of -9,-1,1
 | 22 | 21 |  |  |  | -2.333333333333333 | HCP=Average of -9,1,1
 | 21 | 19 |  |  |  |  | HCP=Average of 1,1,2
 | 20 | 12 |  |  |  |  | HCP=Average of 1,1,2
Spreadsheet: 133874d1324737335-excel-2007-automatically-group-rows-in-text-only-table-book1
Sheet: base data

 | [NAME] | desc | warehouse | qty
 | product 1 | description a | warehouse 1 | 6
 | product 1 | description a | warehouse 2 | 2
 | product 1 | description a | warehouse 3 | 4
 | product 1 | description a | warehouse 4 | 6
 | product 1 | description a | warehouse 5 | 8
 | product 2 | description b | warehouse 1 | 8
 | product 2 | description b | warehouse 2 | 2
 | product 2 | description b | warehouse 3 | 2
 | product 2 | description b | warehouse 4 | 8
 | product 3 | description c | warehouse 1 | 2
 | product 3 | description c | warehouse 2 | 6
 | product 3 | description c | warehouse 3 | 4
 | product 3 | description c | warehouse 4 | 5
 | product 3 | description c | warehouse 5 | 5
 | product 4 | description d | warehouse 1 | 5
 | product 5 | description e | warehouse 1 | 5
 | product 5 | description e | warehouse 2 | 4
 | product 5 | description e | warehouse 3 | 6
 | product 5 | description e | warehouse 4 | 8
Spreadsheet: elizabeth_sager__9513__California Exposure 010119a
Sheet: Edison Int'l 

RAC - Risk Assessment & Control
Exposure as of
 |  |  | Financial | Physical | Sales | Purchases |  | Net Physical | Enron's Net | Counterparty's
Counterparty | Enron Entity | Entity Code | Mark-to-Market | Mark-to-Market | (A/R) | (A/P) | (A/R - A/P) | (Cash + Phys) | Exposure | Net Exposure
Southern California Edison Company | EPMI | ENA | 0 | -51642494 | 8112000 | 0 | 8112000 | -43530494 | 0 |  | Master Power Contract; forward exposure relating to EPMI fixed power supply out to 2005
Southern California Edison Company | Portland General | PGE | 0 | 0 | 58000000 | 0 |  |  |  | 0 | PGE exposure relating to an annuity stream (23 remaining monthly pmts of $2,667,000) for the termination of a long-term power sales agreement 3 years ago.
Southern California Edison Company | EES | EES | 0 | 70424000 | 53000000 | 0 |  |  |  | 0 | [NAME] due to EES | (a)
Southern California Edison Company | EEMC | EES | 0 | 135810000 | 40800000 | 0 |  |  |  | 0 | [NAME] due EEMC | (a)
Southern California Edison Company | Enron Wind | EWC | 0 | 0 |  | 0 |  |  |  | 0 | $4.4MM due December 30, 2000 assumes A/R accrues $213,807 per day through January 30, 2001.
Total Utility Exposure
Edison First Power Limited | ECT Resources Int. | EEL | -10800 | 0 | 0 | 0 | 0 | 0 | 0 |  | Per London. Power Swaps
Edison First Power Limited | ECT Resources Ltd. | EEL | 0 | -6594028 | 2149211 | 0 | 2149211 | -6594028 | 0 |  | Per London, [NAME] sleeves for ECT Resources under one coal contract; ($4.4MM) is aggregate exposure under contract.
Edison Mission Energy | ENA Corp. | ENA | 0 | 0 | 12185756 | -294750 | 11891006 | 11891006 | 11891006 | 0
Edison Mission Energy - First Hydro | ECT Resources Int. | EEL | -348929 | 0 | 0 | 0 |  |  |  |  | Per London. Financial swap settles weekly.
Edison Mission Marketing & Trading | ENA Corp. | ENA | 27271643 | 0 | 0 | 0 | 0 | 0 |  | 0 | ENA has a $35MM inc gty from Edison Mission Energy for (4) specific swaps and a $15MM inc gty from Edison Mission Midwest Holdings for the remaining swap portfolio.
Edison Mission Marketing & Trading | EPMI | ENA | 0 | -18942697 | 81187282 | -73355760 | 7831522 | -11111175 | 0 |  | EPMI has a $20MM inc gty from Edison Mission Energy and a $5MM inc letter of credit.
Subtotal Non-Utility Exposure
Total Exposure to Non-Utility Subsidiaries |  |  |  |  |  |  |  |  |  |  |  | (b) |  | With Master Set-Off
Total Relationship Exposure
 |  |  |  |  |  |  |  |  |  |  |  | ('c) |  | With Master Set-Off
Notes:
(a) Physical MTM = Forward Exposure assumed to be [NAME] exposure in Risk Books at NP15/SP15 curves.
(b) Total Exposure to Non-Utility Subsidiaries will reduce to $23.2MM with Master [NAME].
('c) Total Relationship Exposure to EIX will reduce to $346.1MM with [NAME].
 |  |  |  |  |  |  | CHECK
Spreadsheet: 819776d1677686285-adding-a-select-drop-down-filter-calendar-doc
Sheet: Calendar

 |  |  |  |  |  |  |  | CB Mobile Activity Calendar |  |  |  |  |  |  | Sales Channel
Date: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | March
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start Day:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1:Sun,2:Mon
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Legend
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Events/Training/Huddles
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unhide rows to list up to 10 items per day
 |  |  |  |  |  |  |  |  | Product/System Update
 |  |  |  |  |  |  |  |  | Events/Training/Huddles
 |  |  |  |  |  |  |  |  | Promotions
 |  |  |  |  |  |  |  |  | Incentives
 |  |  |  |  |  |  |  |  | mySource Comms
 |  |  |  |  |  |  |  |  | Demand Gen
Spreadsheet: 544493d1508924804-vlookup-from-a-vlookup-book-vlookuptrim-aligw
Sheet: Sheet2

 |  |  | Student Name
 |  | BOB12323256 | [NAME]
 |  | BOB12324045 | [NAME]
 |  | BOB12324651 | [NAME] 3
 |  | BOB12325711 | [NAME] 4
 |  | [NAME] | [NAME] 5
 |  | [NAME] | [NAME] 6
 |  | [NAME] | [NAME] 7
 |  | BOB12328220 | [NAME] 8
 |  | BOB12328221 | [NAME] 9
 |  | BOB12328375 | [NAME] 10
 |  | BOB12328491 | [NAME] 11
 |  | BOB12328498 | [NAME] 12
 |  | [NAME] | [NAME] 13
 |  | BOB12329132 | [NAME] 14
 |  | BOB12329134 | [NAME] 15
 |  | BOB12329183 | [NAME] 16
 |  | BOB12329301 | [NAME] 17
 |  | BOB12329357 | [NAME] 18
 |  | BOB12329449 | [NAME] 19
 |  | BOB12329472 | [NAME] 20
 |  | [NAME] | [NAME] 21
 |  | [NAME] | [NAME] 22
 |  | BOB12329922 | [NAME] 23
 |  | [NAME] | [NAME] 24
Spreadsheet: 866107d1713048770-index-and-matching-sample
Sheet: Sheet1

 |  |  | Cat | [NAME] | Bear | Sheep | Cow | Donkey
 |  | Research & Development
 |  | 2023-12-01 00:00:00
 |  | 2022-12-01 00:00:00
 |  | 2021-12-01 00:00:00
 |  | 2020-12-01 00:00:00
 |  | 2019-12-01 00:00:00
 |  | 2018-12-01 00:00:00
 |  | 2017-12-01 00:00:00
 |  | 2016-12-01 00:00:00
 |  | 2015-12-01 00:00:00
 |  | 2014-12-01 00:00:00
Spreadsheet: 881233d1729185455-count-by-customer-in-date-range-olander-tooling-qtr3-job-sample
Sheet: CUSTOMER REPORT

2024 ALL QUARTER CUSTOMER REPORT
Customer Name | # OF JOBS | TOTAL ESTIMATED HOURS | TOTAL ACTUAL HOURS | TOTAL SALES | TOTAL PROFIT | OAL % OF ESTIMATE
TOTALS
Spreadsheet: 870713d1717170867-i-have-a-problem-with-solving-a-matrix-matrix_rg
Sheet: Sheet1

A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B
x1 |  | [NAME] |  | x5 | x6 |  | [NAME] | x9 | x10
-1 | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1 | 0 | -2 | 0 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1 | 0 | 1 | 0 | -4 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20
1 | 0 | 1 | 0 | 1 | -4 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1 | 0 | 1 | 0 | 1 | 1 | 0 | -4 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20
1 | 0 | 1 | 0 | 1 | 1 | 0 | 1 | -4 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20
1 | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 1 | -4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Relevant Data
A |  |  |  |  |  |  |  |  | A-1 |  |  |  |  |  |  |  | X = A-1 × B |  | Check
x1 | [NAME] | x5 | x6 | [NAME] | x9 | x10 | B
 |  |  |  |  |  |  |  |  |  | 0.2 | 0.12 | 0.12 | 0.12 | 0.12 | 0.12 |  |  | x1
1 | -2 | 1 | 1 | 1 | 1 | 1 | 20 |  | 0.2000000000000001 | -0.2 | 0.08000000000000006 | 0.08000000000000003 | 0.08 | 0.07999999999999999 | 0.08000000000000002 |  | 8.000000000000004 | [NAME]
1 | 1 | -4 | 1 | 1 | 1 | 1 | 20 |  | 0.12 | 0.08 | -0.152 | 0.048 | 0.048 | 0.04799999999999999 | 0.04799999999999999 |  | 4.8 | x5
1 | 1 | 1 | -4 | 1 | 1 | 1 | 20 |  | 0.12 | 0.08 | 0.04799999999999999 | -0.152 | 0.048 | 0.04799999999999999 | 0.04799999999999999 |  | 4.8 | x6
1 | 1 | 1 | 1 | -4 | 1 | 1 | 20 |  | 0.12 | 0.08 | 0.04799999999999999 | 0.04799999999999999 | -0.152 | 0.04799999999999999 | 0.04799999999999999 |  | 4.8 | [NAME]
1 | 1 | 1 | 1 | 1 | -4 | 1 | 20 |  | 0.12 | 0.08 | 0.04799999999999999 | 0.04799999999999999 | 0.04799999999999999 | -0.152 | 0.04799999999999999 |  | 4.8 | x9
1 | 1 | 1 | 1 | 1 | 1 | -4 | 20 |  | 0.12 | 0.08 | 0.048 | 0.048 | 0.048 | 0.04799999999999999 | -0.152 |  | 4.8 | x10
Spreadsheet: 885172d1734606340-tracker-to-be-populated-the-data-based-on-frequency-count-frequency-tracker
Sheet: Sheet1

 |  | Frequency | Frequency Count | Start Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  | HY | 6 | Apr
 |  | HY | 6 | Jan
 |  | Q | 3 | JUN
 |  | M | 1 | Jan
 |  | Y | 12 | Jan
 |  | Expected Result
 |  | Frequency | Frequency Count | Start Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  | HY | 6 | Apr |  |  |  | HY |  |  |  |  |  | HY
 |  | HY | 6 | Jan | HY |  |  |  |  |  | HY
 |  | Q | 3 | Jun |  |  |  |  |  | Q |  |  | Q |  |  | Q
 |  | M | 12 | Jan | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y
 |  | Y | 1 | Jan | Y
Spreadsheet: 103859d1301525499-dynamic-data-filter-onto-new-sheets-golfdnradvfilter
Sheet: SunilTailor9

[NAME] | Date | Competition | Golf Course | Holes | Par | Team | Hcap | Total Score | Par Total | Player | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Front Par | Score Front | Par Front | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | Back Par | Score Back | Par Back
 |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] | Date | Competition | Golf Course | Holes | Par | Team | Hcap | Total Score | Par Total | Player | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Front Par | Score Front | Par Front | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | Back Par | Score Back | Par Back
1 | 2010-08-08 00:00:00 | Gypsy Cup 1 | [NAME] | 9 | 27 | Team T-C |  | 34 | 7 | [NAME] | 4 | 3 | 5 | 4 | 4 | 5 | 3 | 4 | 2 | 27 | 34 | 7
2 | 2010-08-22 00:00:00 | Gypsy Cup 2 | [NAME] | 9 | 27 | Team T-C |  | 34 | 7 | [NAME] | 4 | 4 | 4 | 4 | 4 | 3 | 3 | 4 | 4 | 27 | 34 | 7
3 | 2010-10-03 00:00:00 | Gypsy Cup 3 | [NAME] | 9 | 27 | Team T-C |  | 34 | 7 | [NAME] | 4 | 4 | 5 | 4 | 3 | 4 | 3 | 3 | 4 | 27 | 34 | 7
4 | 2010-10-17 00:00:00 | Gypsy Cup 4 | [NAME] | 9 | 27 | Team T-C |  | 36 | 9 | [NAME] | 4 | 5 | 4 | 5 | 4 | 4 | 3 | 4 | 3 | 27 | 36 | 9
5 | 2010-10-31 00:00:00 | Gypsy Cup 5 | [NAME] | 9 | 27 | Team T-C |  | 29 | 2 | [NAME] | 3 | 3 | 2 | 3 | 4 | 3 | 4 | 4 | 3 | 27 | 29 | 2
6 | 2010-11-21 00:00:00 | Gypsy Cup 6 | [NAME] | 9 | 27 | Team T-C |  | 33 | 6 | [NAME] | 4 | 4 | 4 | 5 | 4 | 3 | 3 | 3 | 3 | 27 | 33 | 6
7 | 2010-11-28 00:00:00 | Gypsy Cup 7 | [NAME] | 9 | 27 | Team T-C |  | 36 | 9 | [NAME] | 4 | 3 | 4 | 4 | 4 | 3 | 5 | 5 | 4 | 27 | 36 | 9
8 | 2011-02-20 00:00:00 | Gypsy Cup 8 | [NAME] | 9 | 27 | Team T-C |  | 38 | 11 | [NAME] | 4 | 4 | 4 | 3 | 6 | 4 | 5 | 5 | 3 | 27 | 38 | 11
9 | 2011-03-27 00:00:00 | Gypsy Cup 9 | Brent Valley | 18 | 67 | Team T-C | 8 | 79 | 12 | [NAME] | 5 | 5 | 5 | 3 | 5 | 5 | 3 | 4 | 4 | 34 | 39 | 5 | 5 | 4 | 4 | 3 | 5 | 4 | 5 | 5 | 5 | 33 | 40 | 7
Spreadsheet: 1023c1de-22ea-4937-a81a-414a361bc3dc
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 3. COMMERCIAL AND LEASE FINANCE COMMITMENTS By Lender: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Commercial Finance - Banks ; |  |  | Original | A2413463V | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Commercial Finance - Money market corporations ; |  |  | Original | A2413464W | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Commercial Finance - Finance companies ; |  |  | Original | A2413465X | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Commercial Finance - Other lenders ; |  |  | Original | A2413466A | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Commercial Finance - Total ; |  |  | Original | A2413467C | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Lease Finance - Banks ; |  |  | Original | A2413468F | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Lease Finance - Finance companies ; |  |  | Original | A2413469J | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Lease Finance - General financiers ; |  |  | Original | A2413470T | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Lease Finance - Other lessors ; |  |  | Original | A2413471V | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Lease Finance - Total ; |  |  | Original | A2413472W | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 91458d1291202106-vlookup-with-drop-down-selections-excel-help
Sheet: Sheet1

Property Ref
[NAME]
CUSTOMER
LE DATE
Date
From: | To:
2001-01-12 00:00:00 | 2010-02-13 00:00:00
 |  | 109
Monthly Bus Rate Cost
Monthly SVcg Cost
EXAMPLE:
If some one enters | 3355
on Property Ref :
then it should have a drop down list on demise list
of 6 possibilities as follows
Ground Floor Shop
Bsmt
[NAME], 80 Mortimer St
1st Flr
2nd Flr
3rd Flr
Then depending on which demise you select from above choice
the corresponding Customer and LE Date should populate itself..
Spreadsheet: 28517d1222808502-automatic-decimal-format-control-dynamicrounding
Sheet: Sheet1

 | s | 1.456 | 1.46 |  |  |  | nametable
 |  |  |  |  |  |  | q | 3
 |  |  |  |  |  |  | w | 2
 |  |  |  |  |  |  | e | 1
 |  |  |  |  |  |  | r | 0
 |  |  |  |  |  |  | m | 3
 |  |  |  |  |  |  | s | 2
 |  |  |  |  |  |  | t | 0
 |  |  |  |  |  |  | f | 1
Spreadsheet: 029fdfae-1275-41e1-8ad1-4eab146bb436
Sheet: Sheet1

Unnamed: 0 | ARTISTIC PAINTING COMPANY | PHILLIPS MAY | CONCORD COMMERCIAL SERVICES | MYELYN [NAME] | JNA PAINTING | JONSCO INC. | TARRANT PAINT & STAIN | PETERS CONTRACTING SERVICES
CITY HALL | 39850 | 79973 | 43054 | 57700 | 14800 | 40845 | 32000 | 19900
FIRE STATION #1 | 24950 | 13170 | 8372 | 12257.65 | 5400 | 5515 | 7000 | 6000
FIRE STATION #2 | 11980 | 19800 | 13369 | 18142.65 | 7250 | 8243 | 8500 | 9000
SOUTH SERVICE CENTER | 12980 | 18390 | 16480 | 20597.95 | 14350 | 18168 | 37500 | 9900
TOTAL | 89760 | 131333 | 81275 | 108698.25 | 41800 | 72771 | 85000 | 44800
BOND OR CHECK? | C | B | B | B | B | B | B | C
 | Alternates noted
No Bid: Integrated Painting
Spreadsheet: 81518d1281654846-sort-a-group-of-names-based-on-the-group-total-sort-by-group-total
Sheet: Data (3)

 |  |  |  |  |  | Hide this column
Group Name | Client Name | Account No. | Amount | sorted total
CVB | [NAME] | SD1 | 25 | 91 |  | Sum of Amount
CVB | [NAME] | SD2 | 1 | 91 |  | sorted total | Group Name | Client Name | Account No. | Total
CVB | [NAME] | SD5 | 65 | 91 |  | 1349 | [NAME] | [NAME] | TG1 | 1321
[NAME] | [NAME] | TG1 | 1321 | 1349 |  |  |  |  | TG3 | 12
[NAME] | [NAME] | TG2 | 12 | 1349 |  |  |  |  | TG2 | 12
[NAME] | [NAME] | TG3 | 12 | 1349 |  |  |  |  | TG5 | 3
[NAME] | [NAME] | TG4 | 1 | 1349 |  |  |  |  | TG4 | 1
[NAME] | [NAME] | TG5 | 3 | 1349 |  |  | JKH2 Total |  |  | 1349
RM01 | [NAME] | FR1 | 52 | 169 |  | 639 | XVDO | [NAME] | A3 | 475
RM01 | [NAME] | FR2 | 63 | 169 |  |  |  |  | A2 | 123
RM01 | [NAME] | FR4 | 9 | 169 |  |  |  |  | A4 | 15
RM01 | [NAME] | FR5 | 45 | 169 |  |  |  |  | A5 | 12
TWO | [NAME] | GV1 | 125 | 189 |  |  |  |  | A1 | 12
TWO | [NAME] | GV2 | 12 | 189 |  |  |  |  | A6 | 2
TWO | [NAME] | GV3 | 2 | 189 |  |  | XVDO Total |  |  | 639
TWO | [NAME] | GV4 | 5 | 189 |  | 189 | TWO | [NAME] | GV1 | 125
TWO | [NAME] | GV5 | 45 | 189 |  |  |  |  | GV5 | 45
XVDO | [NAME] | A1 | 12 | 639 |  |  |  |  | GV2 | 12
XVDO | [NAME] | A2 | 123 | 639 |  |  |  |  | GV4 | 5
XVDO | [NAME] | A6 | 2 | 639 |  |  |  |  | GV3 | 2
XVDO | [NAME] | A3 | 475 | 639 |  |  | TWO Total |  |  | 189
XVDO | [NAME] | A4 | 15 | 639 |  | 169 | RM01 | [NAME] | FR2 | 63
XVDO | [NAME] | A5 | 12 | 639 |  |  |  |  | FR1 | 52
 |  |  |  |  |  |  |  |  | FR5 | 45
 |  |  |  |  |  |  |  |  | FR4 | 9
 |  |  |  |  |  |  | RM01 Total |  |  | 169
 |  |  |  |  |  | 91 | CVB | [NAME] | SD5 | 65
 |  |  |  |  |  |  |  |  | SD1 | 25
 |  |  |  |  |  |  |  |  | SD2 | 1
 |  |  | 70 |  |  |  | CVB Total |  |  | 91
 |  |  |  |  |  | Grand Total |  |  |  | 2437
Spreadsheet: d6361e60-cc00-4046-826f-f84686354b11
Sheet: Sheet1

Unnamed: 0 | MEALS, REFRESHMENTS AND ACCOMMODATIONS REPORT | 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
 |  |  | EMPLOYEE MUST ATTACH THE BA2 FORM TO THIS REPORT IF REQUESTING REIMBURSEMENT.
 |  |  | Event date: |  |  |  |  | Page ____  of ____ including attachments. |  |  |  |  |  | FORM BA 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Revised 11-09
NAME OF EMPLOYEE HOSTING MEETING OR MEAL |  |  |  |  |  |  |  |  | EMPLOYEE HOST TITLE / PROCARD HOLDER (IF APPLICABLE)
Account Distribution Summary (Use back of sheet if additional lines are needed.) |  |  |  |  |  |  |  |  | Operating Unit title (College or System Ofice Title) and  WORK LOCATION
[NAME] and Contact Information:
 | SECTION 1 - EMPLOYEE WORKING MEAL - Please see Business Procedures 1.13 for details.
 | TYPE OF MEAL
 |  |  | [NAME] |  |  |  |  | [NAME] |  |  |  |  | Dinner Meeting
 | - Employee Breakfast Meetings must begin no later than 8 AM and end no earlier than 9:30 AM - Individual meal cost cannot exceed $10.00 per person.
 | - Employee Lunch Meetings must begin no later than 11 AM and end no earlier than 1:30 PM - Individual meal cost cannot exceed $10.00 per person.
 | - Employee Dinner meetings require prior written approval of KCTCS System Director of Business Services - Attach approval to this report -  Individual meal cost cannot exceed $18.00 per person
 |  |  |  | Number of Attendees |  |  |  |  | $ |  |  |  | Total Cost
 | Time of this [NAME] was  From  ____________   To ____________
 | Bona Fide Business Purpose of Meeting and Working Meal (Benefit to KCTCS and why was a working meal necessary? )
 | A list of employee attendees must be attached.  The meeting coordinator/host must specify those employees on overnight travel status.
 | SECTION 2 - MEAL FOR OFFICIAL GUESTS / STUDENTS - Please see Business Procedure 1.14 for details.
 | Bona Fide Business Purpose of Meeting and Working Meal (Benefit to KCTCS and why was a working meal necessary? )
 |  |  | Number of KCTCS employees |  |  |  |  |  |  | Number of Official Guests / Students
 | A list of employee attendees must be attached.  The meeting coordinator/host must specify those employees on overnight travel status.
 | LIST NAMES OF [NAME] AND CO-HOSTS |  |  |  |  |  |  |  | LIST NAMES OF GUESTS
 | SECTION 3 - REFRESHMENTS - Please see Business Procedure 1.13 for details.
 |  | Number of EMPLOYEES |  |  |  | Number of STUDENTS |  |  |  | Number of GUESTS |  |  |  | $ | Cost
 | Bona Fide Business Purpose for Refreshments
 | [NAME]
 | Bona Fide Business Purpose for Meeting Room/Accomodations (Benefit to KCTCS)
Person Making Expenditure                                           Date |  |  |  |  |  |  |  |  |  | Approval Signature |  |  |  |  | Date
[NAME] (Procard ONLY)                                          Date |  |  |  |  |  |  |  |  |  | President/CEO Approval |  |  |  |  | Date
 |  |  |  |  |  |  |  |  |  |  | (As Required)
Spreadsheet: 109943d1306756482-create-a-column-of-ones-excelforum
Sheet: Hoja1

 |  |  | dummy | inicio | final | ???
 | a | 1970 | 1 | 1975 | 1992
 | a | 1971 | 0
 | a | 1972 | 0
 | a | 1973 | 0
 | a | 1974 | 0
 | a | 1975 | 0
 | a | 1976 | 0
 | a | 1977 | 1 | 1977 | 1992
 | a | 1978 | 0
 | a | 1979 | 0
 | a | 1980 | 0
 | a | 1981 | 0
 | a | 1982 | 0
 | a | 1983
 | a | 1984
 | a | 1985
 | a | 1986
 | a | 1987
 | a | 1988
 | a | 1989
 | a | 1990
 | a | 1991
 | a | 1992
 | a | 1993
 | a | 1994
 | a | 1995
 | a | 1996
 | a | 1997
 | a | 1998
 | a | 1999
 | a | 2000
 | a | 2001