tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 103517d1301301583-nested-formula-collection_test
Sheet: Data

BKNG Date | Executive | Customer | Address | City | Contact No | Tower | Type | Car Park No | SqFt | Rate | [NAME] | Aprt Cost | SC | TOTAL | Intial Paymnt 25% | Service Cost 6.5% | Total Adv | Balance | Installments | January | Amount | Cheque No | Bank | Status | February | Amount | Cheque No | Bank | Status | March | Amount | Cheque No | Bank | Status | Balance | Due | AGM
2010-12-12 00:00:00 | [NAME] | Mr. [NAME] | Dubai | Dubai | 12431243 | 1 | C | 4 | 1100 | 3000 | 200000 |  |  |  |  |  |  |  | 6 |  | 465937.5 | 132134 | AG Zurich | Cleared |  | 465937.5 | 132134 | AG Zurich | Cleared |  | 465937.5 | 14132 | AG Zurich | Cleared | ?????? | if any payment less than current date then return the due amount | [NAME]
2011-01-09 00:00:00 | [NAME] | Mrs. [NAME] | Jeddah | Jeddah | 23423452 | 1 | B | 8 | 1200 | 2900 | 200000 |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  | 979800 | 3546354 | CITY | Cleared |  | 979800 | 1432132 | CITY | Cleared | ?????? |  | [NAME]
2011-02-01 00:00:00 | [NAME] | Dr. [NAME] | Bahrain | Bahrain | 24352435 | 1 | A | 12 | 1800 | 2750 | 200000 |  |  |  |  |  |  |  | 12 |  |  |  |  |  |  |  |  |  |  |  | 342796.875 | 245325 | HSBC | Cleared | ?????? |  | [NAME]
2011-02-28 00:00:00 | [NAME] | [NAME] | Bahrain | Bahrain | 24352455 | 1 | D | 5 | 1800 | 2750 | 200000 |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  | 514195.3125 | 2435 | YES | Pending | ?????? |  | [NAME]
2011-01-09 00:00:00 | [NAME] | Mrs. [NAME] | Jeddah | Jeddah | 23423452 | 1 | B | 8 | 1200 | 2900 | 200000 |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  | 979800 | 3546354 | CITY | Cleared |  | 979800 | 1432132 | CITY | Cleared | ?????? |  | [NAME]
2011-02-01 00:00:00 | [NAME] | Dr. [NAME] | Bahrain | Bahrain | 24352435 | 1 | A | 12 | 1800 | 2750 | 200000 |  |  |  |  |  |  |  | 12 |  |  |  |  |  |  |  |  |  |  |  | 342796.875 | 245325 | HSBC | Cleared | ?????? |  | [NAME]
2011-02-01 00:00:00 | [NAME] | Dr. [NAME] | Bahrain | Bahrain | 24352435 | 1 | A | 12 | 1800 | 2750 | 200000 |  |  |  |  |  |  |  | 12 |  |  |  |  |  |  |  |  |  |  |  | 342796.875 | 245325 | HSBC | Cleared | ?????? |  | [NAME]
2011-02-01 00:00:00 | [NAME] | Dr. [NAME] | Bahrain | Bahrain | 24352435 | 1 | A | 12 | 1800 | 2750 | 200000 |  |  |  |  |  |  |  | 12 |  |  |  |  |  |  |  |  |  |  |  | 342796.875 | 245325 | HSBC | Cleared | ?????? |  | [NAME]
2011-02-01 00:00:00 | [NAME] | Dr. [NAME] | Bahrain | Bahrain | 24352435 | 1 | A | 12 | 1800 | 2750 | 200000 |  |  |  |  |  |  |  | 12 |  |  |  |  |  |  |  |  |  |  |  | 342796.875 | 245325 | HSBC | Cleared | ?????? |  | [NAME]
Spreadsheet: 3bd7c83c-c262-4d88-9c1d-19c6a93b178c
Sheet: Rate History

Rate History |  |  |  |  |  |  |  | Year over Year Change
Fund | Expense per Contact Hour by  Discipline | 2003 | 2002 | 2001 | 2000 | 1999 |  | 2003 | 2002 | 2001 | 2000
1 | Agriculture |  | 7.58 | 7 | 6.669999999999999 | 6.81
2 | Architecture and Precision Production Trades |  | 7.27 | 7.56 | 6.829999999999999 | 6.640000000000001
3 | Biology, Physical Sciences, and Science Technology |  | 6.039999999999999 | 5.9 | 5.69 | 5.51
4 | Business Management, Marketing, and Administrative Services |  | 6.459999999999999 | 6.07 | 6.129999999999999 | 6.22
5 | Career Pilot |  | 11.03 | 16.04 | 19.42 | 18.69
6 | Communications |  | 7.26 | 6.99 | 9.21 | 8.21
7 | Computer and Information Sciences |  | 6.92 | 6.69 | 6.319999999999999 | 5.44
8 | Construction Trades |  | 6.75 | 6.119999999999999 | 6.42 | 5.99
9 | Consumer and Homemaking Education |  | 5.51 | 5.52 | 5.139999999999999 | 5.35
10 | Engineering |  | 8.54 | 11.49 | 9.829999999999998 | 7.640000000000001
11 | Engineering Related |  | 6.889999999999999 | 6.58 | 6.71 | 6.42
12 | English Language, Lit, Philosophy, Humanities, & Interdisciplinary |  | 5.94 | 5.75 | 5.68 | 5.26
13 | Foreign Languages |  | 6.06 | 5.93 | 5.81 | 5.699999999999999
14 | Health Occupations - Dental Assistants, Medical Lab, and [NAME]. Degree Nursing |  | 9.809999999999999 | 9.73 | 8.92 | 9.04
15 | Health Occupations - Dental Hygiene |  | 12.22 | 11.79 | 12.64 | 11.21
16 | Health Occupations - Other |  | 6.549999999999999 | 6.69 | 6.26 | 6.51
17 | Health Occupations - Respiratory Therapy |  | 11.94 | 10.23 | 8.739999999999998 | 8.64
18 | Health Occupations - Vocational Nursing |  | 6.66 | 6.59 | 6.999999999999999 | 5.76
19 | Mathematics |  | 5.549999999999999 | 5.390000000000001 | 5.26 | 4.96
20 | Mechanics and Repairers - Automotive |  | 7.619999999999999 | 7.74 | 7.669999999999999 | 6.49
21 | Mechanics and Repairers - Diesel, Aviation Mechanics, and Transportation Workers |  | 8.76 | 7.41 | 7.819999999999999 | 7.32
22 | Mechanics and Repairers - Electronics |  | 8.36 | 7.41 | 7.329999999999999 | 6.470000000000001
23 | Physical Education and Fitness |  | 7.32 | 6.98 | 6.879999999999999 | 6.21
24 | Protective Services and Public Administration |  | 6.34 | 5.9 | 5.579999999999999 | 4.94
25 | Psychology, Social Sciences, and History |  | 5.319999999999999 | 5.27 | 5.17 | 4.97
26 | Visual and Performing Arts |  | 7.5 | 7.529999999999999 | 7.35 | 7.33
28 | Developmental Education - Math |  | 0 | 0 | 0 | 0
29 | Developmental Education - Reading/Writing |  | 0 | 0 | 0 | 0
 | Average
 | Median
 | Standard Deviation
Spreadsheet: 214602d1360992213-look-up-formula-i-need-to-return-a-score-depending-on-the-value-of-another-cell-xyz
Sheet: Sheet1

Solution I
Hours | Score | X | Y | Z
10
20
30
40
50
Solution II
Hours | Score | X | Y | Z
10
20
30
40
50
Solution III
Hours | Score | X | Y | Z
10 |  |  |  |  |  | Range value base on sheet2
20
30
40
50
Spreadsheet: tracy_geaccone__40292__Cash_Sheets
Sheet: Causey_FundsFlow

Enron Corp
Funds Flow from Operations
2001 Third Quarter
 |  |  |  |  |  |  | 3rd Quarter 2001
 |  |  | June YTD |  | Current |  | Identified |  |  |  | Sept YTD
 |  |  | Actuals |  | View * |  | Transactions |  | Target ** |  | Estimate
 | Transportation & Distribution
 | Enron Transportation Services |  |  |  |  |  | 0
 | Portland General Group |  |  |  |  |  | 0
 | Wholesale |  |  |  |  |  | 800 | ***
 | Enron Global Assets & Services |  |  |  |  |  | 0
 | Enron Energy Services |  |  |  |  |  | 0
 | Enron Renewable Energy |  |  |  |  |  | 0
 | Corporate & Other |  |  |  |  |  | 0
 | Total
 | Wholesale includes - Americas, Europe, EGM, EIM, ENW, EBS, EIP, EGEP and EE&CC
 | Corp and Other includes - Corp, Azurix and Clean Fuels
 | * Based on view of funds flow without any prepays, overviews or any other major transaction
 | ** Based on full year target of $3,000
 | *** Needed Prepays for 3rd quarter based on $3,000 full year target
 | Corporate & Other
 | Corp & Other
 | ECM Other
 | Azurix
 | Clean Fuels
 | Finance
 | Overview
 | IVEST
 | Eliminations
 | Total
Spreadsheet: 67684d1268246628-conditional-formatting-by-quartile-quartiles-qolor-qoding
Sheet: Sheet1

0.31
0.37
0.56
0.26
0.13
0.08
0.12
0.53
0.55
0.94
0.54
0.5
0.94
0.35
0.84
0.92
0.86
0.96
0.9
0.46
0.1
0.44
Spreadsheet: 827399d1682669823-copying-formula-from-one-spreadsheet-to-another-without-source-reference-example-header-extraction
Sheet: Contents

Page Name | Content 1 | Content 2 | Content 3 | Content 4 | Content 5 | Content 6
AA
AB
AC
AD
AE
Spreadsheet: 525206d1498597773-hlookups-to-manipulate-spreadsheet-data-transformation
Sheet: Data 2

Attributes |  |  |  |  |  | Mapped Value 1 | Mapped Value 2 | Mapped Value 3 | Mapped Value 4 | Mapped Value 5 | Mapped Value 6 | Mapped Value 7 | Mapped Value 8 | Mapped Value 9 | Mapped Value 10 | Mapped Value 11 | Mapped Value 12 | Mapped Value 13 | Mapped Value 14 | Mapped Value 15 | Mapped Value 16 | Mapped Value 17 | Mapped Value 18 | Mapped Value 19
Attribute 1 | Attribute 2 | Attribute 3 | Attribute 4 | Attribute 5 | Attribute 6 |  |  |  |  |  |  | x
Attribute 1a | Attribute 2a | Attribute 3a | Attribute 4a | Attribute 5a | Attribute 6a | x |  |  |  |  |  |  |  |  | x
Attribute 1b | Attribute 2b | Attribute 3b | Attribute 4b | Attribute 5b | Attribute 6b | x |  |  |  |  |  |  |  |  |  |  | x |  |  | x |  | x
Spreadsheet: 811738d1672766743-copy-whole-rows-if-condition-is-fulfilled-example-file-1-1-2-
Sheet: Sheet1

 |  |  | Start | Starts at | End | Ends at | All-day event | Reminder on/off | Reminder on | Reminder at | Organizer | Mandatory participants | Optional participants | Ressources | Information | Description | Categories | Location | Priority | Private | Kilometers | Vertraulichkeit | Show as | Duration | Day | Month | Year | Calendar week
 |  | Appointment 1 | 2023-03-06 00:00:00 | 09:00:00 | 2023-03-06 00:00:00 | 18:00:00 | Off | On | 2023-03-06 00:00:00 | 08:45:00 | 0 | 0 | 0 | 0 | 0 | 0 | Blue | 0 | Normal | Off | 0 | Normal | 2 | 9:00:00 | Monday | March | 2023 | 10
 |  | Appointment 2 | 2023-03-06 00:00:00 | 11:00:00 | 2023-03-06 00:00:00 | 12:00:00 | Off | On | 2023-03-06 00:00:00 | 10:45:00 | 0 | 0 | 0 | 0 | 0 | 0 | Yellow | 0 | Normal | Off | 0 | Normal | 2 | 1:00:00 | Monday | March | 2023 | 10
 |  | Appointment 3 | 2023-03-07 00:00:00 | 08:30:00 | 2023-03-08 00:00:00 | 09:00:00 | Off | On | 2023-03-07 00:00:00 | 16:30:00 | 0 | 0 | 0 | 0 | 0 | 0 | Green | 0 | Normal | Off | 0 | Normal | 2 | 1 day, 0:30:00 | Tuesday | March | 2023 | 10
 |  | Appointment 3 | 2023-03-08 00:00:00 | 08:30:00 | 2023-03-08 00:00:00 | 09:00:00 | Off | On | 2023-03-07 00:00:00 | 16:30:00 | 0 | 0 | 0 | 0 | 0 | 0 | Green | 0 | Normal | Off | 0 | Normal | 2 | 1 day, 0:30:00 | Tuesday | March | 2023 | 10
 |  | Appointment 4 | 2023-03-08 00:00:00 | 08:00:00 | 2023-03-08 00:00:00 | 10:30:00 | Off | On | 2023-03-08 00:00:00 | 07:30:00 | 0 | 0 | 0 | 0 | 0 | 0 | Red | 0 | Normal | Off | 0 | Normal | 2 | 2:30:00 | Wednesday | March | 2023 | 10
Spreadsheet: 727274d1617813446-remove-filterxml-from-formula-roster-vs-schedule-example
Sheet: Names

Student Name | System | System 2 | Site
Student 1 | System 1 | System 2 | Site 1 (existing)
Student 2 | System 6 | System 5 | Site 2
Student 3 | System 7 |  | Site 3 |  |  |  | True
Student 4 | System 5 | System 4 | Site 1 |  |  |  | True
Student 5 | System 8 |  | Site 2 (existing) |  |  |  | True
Student 6 | System 2 | System 1 | Site 3 |  |  |  | False
Student 7 | System 7 |  | Site 1 |  |  |  | True
Student 8 | System 3 |  | Site 2 |  |  |  | True
Student 9 | No System | System 7 | Site 3 |  |  |  | True
Student 10 | System 8 |  | Site 1 |  |  |  | True
Student 11 | System 3 |  | Site 2 |  |  |  | True
Student 12 | System 10 | System 2 | Site 3 |  |  |  | True
Student 13 | System 9 | System 4 | Site 1 |  |  |  | True
Student 14 | System 5 |  | Site 2 |  |  |  | True
Student 15 | No System |  | Site 3 |  |  |  | True
Student 16 | System 8 | System 1 | Site 1 |  |  |  | True
Student 17 | System 9 | System 7 | Site 2 |  |  |  | True
Student 18 |  |  | Site 3 |  |  |  | True
Student 19 |  |  | Site 1 |  |  |  | True
[NAME] |  |  | Site 2 |  |  |  | True
 |  |  |  |  |  |  | True
Spreadsheet: 7816a2be-8681-43e1-9ab8-c8472a4a650d
Sheet: Sheet1

 | First Name | Last Name | City | Country | club
1 | [NAME] | [NAME] | LInton | United Kingdom
2 | Sylvie | Bertrand | Pessac | France
3 | Sophie | [NAME] | moussan | France
4 | CLAUDINE | DURERO | ANTIBES | France
5 | Norma | Goggin | Waterford | Ireland
6 | Helen | Hall | Amersham | United Kingdom
7 | Siobhan | [NAME] | Waterford | Ireland
8 | Christine | MARCO | NARBONNE | France
9 | [NAME] | [NAME] | Como | Australia
10 | [NAME] | Pileggi | Fair Haven | United States
11 | Carol | [NAME] | Karlslunde | Denmark
12 | Siv. B. | [NAME] | Hafrsfjord | Norway
13 | MAYO | TANI | Tokyo | Japan
14 | SINKO | [NAME] | Nice | France
15 | [NAME] | Vanessse | roux | Belgique
 | 15 | 15 | 15 | 15
Spreadsheet: 263970d1378742128-retrieve-matching-value-from-another-worksheet-data1
Sheet: Result Should look like this

Sl | Vendor Description | Drawing No. | Vend_Rev | DOCUMENT NUMBER | CLIENT DESCRIPTION | CLIENT REVISION NUMBER | DATE              Received fm Vendor | DATE Submited to Consultnt | Transmittal No. | Date comments from consultnt | Date of submission to Client | Transmittal no | Client Comment | STATUS
1 | Project / Production Schedule | M3FS-0-00-0002 | 0 | [NAME] | Project ProductionSchedule | 0 | 2013-07-19 00:00:00
2 | Process Flow Diagram (PFD) Flares 6A-X-0001 | M3FS-6-55-0001 | 0 | VEN-3475-KHGA-6-52-0100 | Process Flow Diagram (PFD) Flares 6A-X-0001 | 0 | 2013-07-16 00:00:00 | 2013-07-17 00:00:00 |  | 2013-07-22 00:00:00
3 |  |  |  | VEN-3475-KHGB-6-52-0100 | Process Flow Diagram (PFD) Flares 6B-X-0001 | 0 |  | 2013-07-17 00:00:00 |  | 2013-07-22 00:00:00
Spreadsheet: 110401d1307066229-easy-count-of-fields-nsrawdata051811-1-
Sheet: Sheet2

650623 | 377288 | ihawkins | 2011-05-18 17:09:19
650866 | 375436 | ihawkins | 2011-05-18 19:37:30
650868 | 377303 | ihawkins | 2011-05-18 19:37:52
650883 | 375598 | ihawkins | 2011-05-18 19:45:22
650884 | 375582 | ihawkins | 2011-05-18 19:45:54
650894 | 375096 | ihawkins | 2011-05-18 19:53:38
650913 | 377407 | ihawkins | 2011-05-18 19:59:35
650942 | 377483 | ihawkins | 2011-05-18 20:19:15
651007 | 377206 | ihawkins | 2011-05-18 20:54:53
651010 | 377153 | ihawkins | 2011-05-18 20:56:45
651024 | 372325 | ihawkins | 2011-05-18 21:04:11
651065 | 376645 | ihawkins | 2011-05-18 21:37:10
651085 | 377475 | ihawkins | 2011-05-18 21:50:52
651090 | 377476 | ihawkins | 2011-05-18 21:52:55
651092 | 377477 | ihawkins | 2011-05-18 21:53:22
651201 | 377533 | ihawkins | 2011-05-18 23:10:35
651207 | 377548 | ihawkins | 2011-05-18 23:12:08
651299 | 375101 | ihawkins | 2011-05-19 00:07:03
651300 | 375122 | ihawkins | 2011-05-19 00:08:06
651302 | 373462 | ihawkins | 2011-05-19 00:08:41
651303 | 376586 | ihawkins | 2011-05-19 00:09:26
651336 | 377688 | ihawkins | 2011-05-19 00:36:34
651352 | 376548 | ihawkins | 2011-05-19 00:46:56
651353 | 375813 | ihawkins | 2011-05-19 00:47:48
651359 | 376621 | ihawkins | 2011-05-19 00:50:17
651360 | 377190 | ihawkins | 2011-05-19 00:50:57
651376 | 377337 | ihawkins | 2011-05-19 01:15:53
651379 | 374487 | ihawkins | 2011-05-19 01:17:35
651400 | 377629 | ihawkins | 2011-05-19 02:06:31
651404 | 377172 | ihawkins | 2011-05-19 02:17:35
651416 | 377550 | ihawkins | 2011-05-19 02:31:26
651418 | 377253 | ihawkins | 2011-05-19 02:31:51
651421 | 376107 | ihawkins | 2011-05-19 02:37:40
651424 | 377644 | ihawkins | 2011-05-19 02:49:52
651428 | 377666 | ihawkins | 2011-05-19 03:00:17
651429 | 377687 | ihawkins | 2011-05-19 03:00:56
651430 | 377013 | ihawkins | 2011-05-19 03:01:44
Spreadsheet: chris_germany__2129__FebCohCHOICE-ENA
Sheet: Feb 11

 | CES/NPC COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2001-02-11 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | Upstream K# | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 1332 |  | 1375 |  | 67694 |  |  |  |  |  |  | 24 | 1 | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | 2 | 23
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 12478 |  | 12478 |  | 67694 |  |  |  |  |  |  | 25 | 3 | 25
 |  |  |  |  |  |  |  |  | 3000 |  | 3000 |  | 68918 | 103722 | 0 |  |  |  |  | 24 | 4 | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 | 5 | 28
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 3168 |  | 3290 |  | 67694 |  |  |  |  |  |  | 27 | 6 | 27
 |  |  |  |  |  |  |  |  | 2000 |  | 2000 |  | 68915 | 103722 | 0 |  |  |  |  | 24 | 7 | 23
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69148 |  | 0 |  |  |  |  | 29 | 8 | 28
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69693 |  | 0 |  |  |  |  | 27 | 9 | 28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33 | 15 | 32
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 21619 |  | 21619 |  | 67694 |  |  |  |  |  |  | 25 | 35 | 26
 |  |  |  |  |  |  |  |  | 25 |  | 25 |  | 68917 | 103722 | 0 |  |  |  |  | 24 | 39 | 24
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69149 |  | 0
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69693 |  | 0
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 2429 |  | 2429 |  | 67694 |  |  |  |  |  |  | %
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Storage
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 2060 |  | 2060 |  | 67694 |  |  |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 68916 | 103722 | 0 |  |  |  |  | 1
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 17812 |  | 17812 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 4037 |  | 4037 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 3986 |  | 4100 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 5735 |  | 5595 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 1610 |  | 1534 |  | 67694
 |  |  |  |  |  |  |  |  | 257 |  | 257 |  | 69708 | 53858 | 0
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 53858 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 45 |  | 45 |  | 67694 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20606 | FOM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20500 | Pull from ENA Pool to NPC Pool
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: 09940b71-3699-4b77-8c71-df1e399ffc45
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 47. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (TAS), Original (Number, $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
1. . . [NAME] ; |  |  | Original | A2413748X | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413749A | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413750K | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413751L | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413752R | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413753T | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413754V | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | A2413755W | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413756X | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413757A | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413758C | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 706078d1606458935-excel-formula-to-compare-multiple-columns-comparing-test
Sheet: Sheet1

Sno | Name | Code | Description | Types | Amount | Date | Code | Description | Description Full | Amount | Types | Date | Output Result
1 | CLR1 | 1001 | Description 1 | Type 1 | 50 | 2011-12-05 00:00:00 | 1001 | Description 1 |  | 50 | Type 11 | 2011-12-03 00:00:00 |  |  | Type is Not Matching
2 | CLR1 | 1005 | Description 2 | Type 2 | 30 | 2011-12-05 00:00:00 | 1001 | Description 2 |  | 50 | Type 2 | 2011-12-05 00:00:00 |  |  | Description is Not Matching
3 | CLR1 | 1016 | Description 3 | Type 3 | 50 | 2011-12-05 00:00:00 | 1005 | Description 3 |  | 30 | Type 3 | 2011-12-03 00:00:00 |  |  | Correct
4 | CLR1 | 2001 | Description 4 | Type 4 | 90 | 2011-12-05 00:00:00 | 1005 | Description 40 |  | 30 | Type 40 | 2011-12-05 00:00:00 |  |  | Description is Not Matching, Type is Not Matching
5 | CLR1 | 2002 | Description 5 | Type 5 | 30 | 2011-12-05 00:00:00 | 1016 | Description 5 |  | 50 | Type 5 | 2011-12-03 00:00:00 |  |  | Date is Not Matching
6 | CLR1 | 2003 | Description 6 | Type 6 | 30 | 2011-12-05 00:00:00 | 1016 | Description 6 |  | 50 | Type 6 | 2011-12-05 00:00:00 |  |  | Correct
7 | CLR1 | 2004 | Description 7 | Type 7 | 30 | 2011-12-05 00:00:00 | 2001 | Description 7 |  | 90 | Type 7 | 2011-12-03 00:00:00 |  |  | Correct
8 | CLR1 | 2005 | Description 8 | Type 8 | 30 | 2011-12-05 00:00:00 | 2001 | Description 118 |  | 190 | Type 811 | 2011-12-12 00:00:00 |  |  | Description is Not Matching, Type is Not Matching, [NAME] is Not Matching, Amount #is Not Matching
9 | CLR1 | 2006 | Description 9 | Type 9 | 50 | 2011-12-05 00:00:00 | 2002 | Description 9 |  | 30 | Type 9 | 2011-12-03 00:00:00 |  |  | Correct
10 | CLR1 | 2007 | Description 10 | Type 10 | 50 | 2011-12-05 00:00:00 | 2002 | Description 10 |  | 30 | Type 10 | 2011-12-05 00:00:00 |  |  | Correct
11 | CLR1 | 2008 | Description 11 | Type 11 | 30 | 2011-12-05 00:00:00 | 2003 | Description 11 |  | 30 | Type 11 | 2011-12-03 00:00:00 |  |  | Correct
12 | CLR1 | 2009 | Description 12 | Type 12 | 20 | 2011-12-05 00:00:00 | 2003 | Description 12 |  | 30 | Type 12 | 2011-12-05 00:00:00 |  |  | Correct
 |  |  | Description 12 | Type 12 | 20 | 2011-12-05 00:00:00 |  | Description 12 |  | 20 | Type 12 | 2011-12-05 00:00:00
Spreadsheet: 84321d1284383224-index-match-problem-for-multiple-matches-index
Sheet: Sheet2

Date | Code | Interval | Min | Comments |  | Look up |  |  | Names
 |  |  |  |  |  | [NAME] |  |  | [NAME]
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 238425d1369553215-4-digit-code-for-similar-product-new-product-unique-code-unclejemima-example-2
Sheet: Sheet1

 | Product | Product #
1 | Apple | 4499
1 | Apple | 4499 |  | Note the slightly different formulas in cell A2 and the rest of that column.  This is just to force 1 for the first entry
1 | Apple | 4499 |  | and then increasing numbers further down the column.
2 | Orange | 7525
2 | Orange | 7525 |  | There is a randonmly ordered list of 9999 numbers on Sheet 2.
3 | [NAME] | 2908 |  | The formula in column C will check the values in column A and feed in the relevant 4digit code based on the row
1 | Apple | 4499 |  | number of the list on Sheet 2.
4 | Pear | 5002
4 | Pear | 5002 |  | You just need to copy the formulas down as necessary
2 | Orange | 7525
5 | Cherries | 4000 |  |  | Hope that's of help.
6 | Tomato | 2489
1 | Cherries | 4499
1 | Cherries | 4499
1 | apple | 4499
1 | [NAME] | 4499
6 | Tomato | 2489