tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 49228f88-18b4-4a4e-a257-860f2bca1c4f
Sheet: Sheet1

DETENTION OPERATIONS STATISTICS PACKAGE | Unnamed: 1 | Unnamed: 2
as at COB 31 January 2003
Table Content: | Table Number: | Page:
Adults / Minors x Gender by Centre: | 1.1 | 1
Adults / Minors x Gender - Total | 2.1 | 2
Detainees x Centre | 2.2 | 2
Taken into Detention x Centre - 02/03 Financial Year to Date | 2.3 | 2
Detainee Throughput x Centre - 01/02 Financial Year | 2.4 | 2
Detainees x Arrival Type x Centre | 3.1 | 3
Top Ten Nationalities in Detention - Totals & Percentages | 3.2 | 3
Length of Detention - Totals & Percentages | 3.3 | 3
Detainees x Processing Stage - Totals & Percentages | 3.4 | 4
Adults / Minors x Processing Stage | 3.5 | 4
Detainees Awaiting Removal from Australia | 4.1 | 5
Spreadsheet: 752597d1634842708-copy-and-paste-formula-without-changing-the-original-range-selection-sample
Sheet: Sheet1

Record ID | Record Type | Campaign ID | Campaign | Campaign Daily Budget | Portfolio ID | Campaign Start Date | Campaign End Date | Campaign Targeting Type | Ad Group | [NAME] | % sales | [NAME] or Product Targeting | Product Targeting ID | Match Type | SKU | Campaign Status | Ad Group Status | Status | Impressions | Clicks | Spend | Orders | Total Units | Sales | ACoS
1111 | Keyword | 1111 | 1111 |  |  |  |  |  | 1111 | 1 |  | KW 1 |  | x |  | enabled | enabled | enabled | 4543 | 23 | 23.664 | 1 | 1 | 25.99 | 1
1112 | Keyword | 1112 | 1112 |  |  |  |  |  | 1112 | 1 |  | KW 2 |  | x |  | enabled | enabled | enabled | 1232 | 96 | 115 | 2 | 2 | 59.66 | 1
1113 | Keyword | 1113 | 1113 |  |  |  |  |  | 1113 | 1 |  | KW 3 |  | x |  | enabled | enabled | enabled | 1231 | 15 | 23 | 3 | 3 | 79.55 | 1
1114 | Keyword | 1114 | 1114 |  |  |  |  |  | 1114 | 1 |  | KW 4 |  | x |  | enabled | enabled | enabled | 2115 | 79 | 84 | 9 | 9 | 243 | 1
1115 | Keyword | 1115 | 1115 |  |  |  |  |  | 1115 | 1 |  | KW 5 |  | x |  | enabled | enabled | enabled | 1325 | 53 | 56 | 3 | 3 | 89 | 1
Spreadsheet: 800985d1666021073-populate-names-by-comparing-2-columns-of-numbers-populate-supv-names-2
Sheet: Sheet3

REPORTS TO (USE 4 VISIO) | 2.Employee Full Nm | SUPERVISOR NAME |  |  | REPORTS TO (USE 4 VISIO) | SUPERVISOR NAME
91101432 | Employee 1 |  |  |  | 91097308 | Supervisor 1
91101432 | Employee 2 |  |  |  | 91097827 | Supervisor 2
91122759 | Employee 3 |  |  |  | 91101432 | Supervisor 3
91246105 | Employee 4 |  |  |  | 91122759 | [NAME]
91223809 | Employee 5 |  |  |  | 91144732 | Supervisor 5
91246105 | VACANT POSITION |  |  |  | 91145020 | Supervisor 6
91187573 | Employee 6 |  |  |  | 91146561 | Supervisor 7
91248925 | Employee 7 |  |  |  | 91147330 | Supervisor 8
91223809 | Employee 8 |  |  |  | 91158235 | Supervisor 9
91122759 | Employee 9 |  |  |  | 91159859 | Supervisor 10
91101432 | Employee 10 |  |  |  | 91178118 | Supervisor 11
91248925 | Employee 11 |  |  |  | 91183151 | Supervisor 12
91246322 | Employee 12 |  |  |  | 91184881 | Supervisor 13
91197749 | Employee 13 |  |  |  | 91185406 | Supervisor 14
91256870 | Employee 14 |  |  |  | 91187573 | Supervisor 15
91232261 | Employee 15 |  |  |  | 91197749 | Supervisor 16
91264092 | Employee 16
91224368 | Employee 17
91329689 | Employee 18
91147330 | Employee 19
91232261 | Employee 20
91185406 | Employee 21
91144732 | Employee 22 |  |  |  | is it possible to fill-in column C by matching Col. A to Col. F and returning the supervisor name to column C?
91101432 | Employee 23
91339470 | Employee 24
91242009 | Employee 25
91256870 | Employee 26
91247077 | Employee 27
91247077 | Employee 28
91339470 | Employee 29
Spreadsheet: 271815d1382056576-count-xx-and-xxx-count-x
Sheet: Sheet1

 | January |  |  | February |  |  | March |  |  | Total Year X's
 | 1 | 2 | 3 | 1 | 2 | 3 | 1 | 2 | 3 | Total 1 | Total 2 | Total 3
Company A | x |  |  |  |  |  |  | x |  | 1 | 2 | 0
Company B |  | x |  |  |  |  |  |  |  | 0 | 1 | 0
Company C |  |  | x | x |  |  |  | xx |  | 3 | 0 | 1
Company D |  |  |  |  |  | x |  |  |  | 0 | 0 | 1
Company E |  |  |  | xx | x |  | xxx |  |  | 5 | 1
Spreadsheet: 9c04607c-0313-41cb-a742-58fe7d096245
Sheet: Sheet1

UNIVERSITY OF ARKANSAS AT PINE BLUFF | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Recommendation of Extra Help Personnel Action
Employment
Termination
 |  |  |  |  |  |  |  | SSN
Preferred Title  (Mr., Mrs., Ms., Dr.): |  |  |  |  |  |  |  | ID#
Name (Prospective Employee):
School/Division: |  |  |  |  |  |  | Department:
Reason for Employment/Termination:
Extra Help Title:
Period of Employment:: |  | From |  |  |  |  | To
Approved Hourly Rate |  |  |  |  |  |  | Total Amount To be Paid:
Is this individual employed by another state agency/institution?  (Yes or No)
If yes, an approved Concurrent Employment Request form is required prior to the start of work to be performed.
GL Account Number | Account Name |  |  |  |  |  | % Charged to Acct. |  | Amount to be Paid
 |  |  |  |  | Totals: |  | 0 |  | 0
Requested by:
APPROVALS:
Department Head/Director |  |  | Date |  |  |  | Vice Chancellor |  | Date
[NAME] |  |  | Date |  |  |  | Chancellor |  | Date
Grant Accounting (if applicable) |  |  | Date |  |  |  | Human Resources |  | Date
Budget Office |  |  | Date
Note:  This form must reach the Human Resources Department no later than seven (7) days prior to effective date of action.
Approval must be granted before work is to begin.  Time sheets reflecting the number of hours worked must be submitted to the
Human Resources Department no later than the second business day following the regular pay day.
Spreadsheet: eceacc9a-5047-4d31-afff-d69c4ab12f93
Sheet: Sheet1

Kongsberg International School Calendar 2011-12
 | week number | M | T | W | Th | F | Sat | Sun |  | week number |  | M | T | W | Th | F | Sat | Sun
August | 31 | 1 | 2 | 3 | 4 | 5 | 6 | 7
2011 | 32 | 8 | 9 | 10 | 11 | 12 | 13 | 14 |  | 13 | April |  |  |  |  |  |  | 1
 | 33 | 15 | 16 | 17 | 18 | 19 | 20 | 21 |  | 14 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | 34 | 22 | 23 | 24 | 25 | 26 | 27 | 28 |  | 15 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15
 | 35 | 29 | 30 | 31 |  |  |  |  |  | 16 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22
 |  |  |  |  |  |  |  |  |  | 17 |  | 23 | 24 | 25 | 26 | 27 | 28 | 29
Sep | 35 |  |  |  | 1 | 2 | 3 | 4 |  | 18 |  | 30
 | 36 | 5 | 6 | 7 | 8 | 9 | 10 | 11
 | 37 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  | 18 | May |  | 1 | 2 | 3 | 4 | 5 | 6
 | 38 | 19 | 20 | 21 | 22 | 23 | 24 | 25 |  | 19 |  | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | 39 | 26 | 27 | 28 | 29 | 30 |  |  |  | 20 |  | 14 | 15 | 16 | 17 | 18 | 19 | 20
 |  |  |  |  |  |  |  |  |  | 21 |  | 21 | 22 | 23 | 24 | 25 | 26 | 27
Oct | 39 |  |  |  |  |  | 1 | 2 |  | 22 |  | 28 | 29 | 30 | 31
 | 40 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 | 41 | 10 | 11 | 12 | 13 | 14 | 15 | 16 |  | 22 | June |  |  |  |  | 1 | 2 | 3
 | 42 | 17 | 18 | 19 | 20 | 21 | 22 | 23 |  | 23 |  | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | 43 | 24 | 25 | 26 | 27 | 28 | 29 | 30 |  | 24 |  | 11 | 12 | 13 | 14 | 15 | 16 | 17
 | 44 | 31 |  |  |  |  |  |  |  | 25 |  | 18 | 19 | 20 | 21 | 22 | 23 | 24
Nov | 44 |  | 1 | 2 | 3 | 4 | 5 | 6 |  | 26 |  | 25 | 26 | 27 | 28 | 29 | 30
 | 45 | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | 46 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |  | 26 | July |  |  |  |  |  |  | 1
 | 47 | 21 | 22 | 23 | 24 | 25 | 26 | 27 |  | 27 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | 48 | 28 | 29 | 30 |  |  |  |  |  | 28 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15
 |  |  |  |  |  |  |  |  |  | 29 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22
Dec | 48 |  |  |  | 1 | 2 | 3 | 4 |  | 30 |  | 23 | 24 | 25 | 26 | 27 | 28 | 29
 | 49 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  |  |  | 30 | 31
 | 50 | 12 | 13 | 14 | 15 | 16 | 17 | 18
 | 51 | 19 | 20 | 21 | 22* | 23 | 24 | 25
 | 52 | 26 | 27 | 28 | 29 | 30 | 31
Jan | 52 |  |  |  |  |  |  | 1
2012 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | 2 | 9 | 10 | 11 | 12 | 13 | 14 | 15
 | 3 | 16 | 17 | 18 | 19 | 20 | 21 | 22
 | 4 | 23 | 24 | 25 | 26 | 27 | 28 | 29
 | 5 | 30 | 31 |  |  |  |  |  |  |  |  |  |  | School open
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Closed
Feb | 5 |  |  | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  | Weekend
 | 6 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  |  |  |  |  | School closed, holiday club open
 | 7 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |  |  |  |  |  | Staff Training days: school closed, holiday club open
 | 8 | 20 | 21 | 22 | 23 | 24 | 25 | 26 |  |  |  |  |  | Staff Professional Support days
 | 9 | 27 | 28 | 29 |  |  |  |  |  |  |  | * = ½ day Holiday Club
Mar | 9 |  |  |  | 1 | 2 | 3 | 4
 | 10 | 5 | 6 | 7 | 8 | 9 | 10 | 11
 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18
 | 12 | 19 | 20 | 21 | 22 | 23 | 24 | 25
 | 13 | 26 | 27 | 28 | 29 | 30 | 31
Spreadsheet: 822995d1679636215-leave-calculation-working-days-and-exclude-sunday-leave-calculation-days-working-rqd
Sheet: Sheet1

Name | From Date | To Date | Leave Output Required
[NAME] | 2023-03-01 00:00:00 | 3023-03-04 00:00:00 | 3.5 |  | Leave Rules for Saturday
Mark | 2023-03-01 00:00:00 | 2023-03-11 00:00:00 | 9.5 |  | Date | Remarks | Working days | Leave
Vijay | 2023-03-16 00:00:00 | 2023-03-20 00:00:00 | 3 |  | 2023-03-04 00:00:00 | 1st Saturday | 0.5 | Half day
[NAME] | 2023-03-24 00:00:00 | 2023-03-28 00:00:00 | 4 |  | 2023-03-11 00:00:00 | 2nd Saturday | 0.5 | Half day
 |  |  |  |  | 2023-03-18 00:00:00 | 3rd Saturday | 0 | Leave
 |  |  |  |  | 2023-03-25 00:00:00 | 4th Saturday | 1 | Full Day
 |  |  |  |  | Sunday will not counted as Leave
Spreadsheet: 711661d1609838927-variable-starting-dates-excelproblem
Sheet: Blad1

 | Starting Year | Cashflow first year | Cashflow second year | Cashflow third year | Cashflow fourth year | Cashflow fifth year | Cashflow sixt year | Cashflow seventh year
Investment 1 | 2021 | 200000 | 300000 | 100000 | 500000 | 600000 | 300000 | 400000
Investment 2 | 2025 | 250000 | 300000 | 500000 | 400000 | 550000 | 600000 | 500000
 |  | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029
 | Investment 1 |  | 200000 | 300000 | 100000 | 500000 | 600000 | 300000 | 400000
 | Investment 2 |  |  |  |  |  | 250000 | 300000 | 500000 | 400000 | 550000
Spreadsheet: 703869d1605200689-random-task-allocation-randomly-assigning-tasks-adamnc-
Sheet: Example Completed

[NAME] |  |  | 17 |  | Letters
Employee | Shift | Hours |  |  | Employee | Shift | Hours
[NAME] | 09:00-17:30 | 08:30:00 |  |  | Percy | 10:00-18:30 | 08:30:00
[NAME] | 11:30-20:00 | 08:30:00 |  |  | [NAME] | 11:30-20:00 | 08:30:00
 |  |  |  |  | Stanley | 09:00-17:30 | 08:30:00
Competition |  |  |  |  | Sales |  |  | 17
Employee | Shift | Hours |  |  | Employee | Shift | Hours
[NAME] | 11:30-20:00 | 08:30:00 |  |  | [NAME] | 11:30-20:00 | 08:30:00
Christian | 09:00-17:30 | 08:30:00 |  |  | Sophie | 09:00-17:30 | 08:30:00
[NAME] | 10:00-18:30 | 08:30:00
Spreadsheet: 840588d1692826312-multiple-lookup-values-in-excel-book1
Sheet: Client

Type | Customer No | [NAME] | [NAME] | [NAME] | [NAME] | Time Zone | [NAME] | [NAME]
Prospect | 002866 | Apple | Canada | aa | ON |  | DOWLING | P0M1R0
Prospect | 002808 | Micrsoft | United States | bb | WA |  | SPOKANE | 992022822
Prospect | 002701 | Amazon | Canada | cc | AB |  | NANTON | T0L1R0
Prospect | 001094 | 3M | United States | dd | MI |  | [NAME] | 49464
Prospect | 001785 | United Airline | Canada | ee | BC |  | KAMLOOPS | V2C6X2
Prospect | 003322 | Air Canada | Canada | ff | AB |  | INNISFAIL | T4G1S7
Prospect | 003322 | Air Canada | Canada | ff | AB |  | INNISFAIL | T4G1S7
Prospect | 002701 | Amazon | Canada | cc | AB |  | NANTON | T0L1R0
Prospect | 002808 | Micrsoft | United States | bb | WA |  | SPOKANE | 992022822
Prospect | 001094 | 3M | United States | dd | MI |  | [NAME] | 49464
Prospect | 001785 | United Airline | Canada | ee | BC |  | KAMLOOPS | V2C6X2
Prospect | 003322 | Air Canada | Canada | ff | AB |  | INNISFAIL | T4G1S7
Prospect | 003322 | Air Canada | Canada | ff | AB |  | INNISFAIL | T4G1S7
Spreadsheet: 92694d1292260354-vlookup-w-3-colums-ex2-1-
Sheet: Sheet1

Date | Amount | [NAME] | Cert
2010-07-07 00:00:00 | 5000 | 580
2010-08-08 00:00:00 | 10000 | 340
2010-05-05 00:00:00 | 10000 | 630
2010-09-09 00:00:00 | 12000 | 341
2010-06-06 00:00:00 | 5000 | 420
Spreadsheet: 126c6226-4ae1-4a97-aab0-2a6eb2c57f0c
Sheet: Sheet1

Student's Name |  |  |  |  |  |  |  | Audit Completed by
PowerCampus ID |  |  |  |  |  |  |  | Date
BACHELOR OF SCIENCE IN ELDERCARE ADMINISTRATION (120 Hours) Effective Fall 2013
 |  | Term | Year | School | Grade | Credits |  |  |  | Term | Year | School | Grade | Credits
1. GENERAL EDUCATION REQUIREMENTS (39 hrs) 1 |  |  |  |  |  |  |  | 4. ADDITIONAL REQUIREMENTS (24 hrs)
A. English Composition (6) |  |  |  |  |  |  |  | MGMT 3200 |  |  |  |  |  | 3
ENGL 1001 |  |  |  |  |  | 3 |  | PHIL 2025 |  |  |  |  |  | 3
ENGL 1002 |  |  |  |  |  | 3 |  | PSYC 3001 |  |  |  |  |  | 3
 |  |  |  |  |  |  |  | SOCL 2001 |  |  |  |  |  | 3
B. Social Sciences (6) |  |  |  |  |  |  |  | SOCL 2093 |  |  |  |  |  | 3
PSYC 2000 |  |  |  |  |  | 3 |  | SOCL 4531 |  |  |  |  |  | 3
POLI 2051 |  |  |  |  |  | 3 |  | PSYC 2070 |  |  |  |  |  | 3
 |  |  |  |  |  |  |  | PSYC 3075 |  |  |  |  |  | 3
[NAME] (6)
MATH 1021 |  |  |  |  |  | 3 |  | Notes
MATH/STAT/PSYC 2011 |  |  |  |  |  | 3
 |  |  |  |  |  |  |  | 1 See list of approved courses in the General Education section of the LSUA Catalog.
D. Natural Sciences (9)
BIOL 1001 |  |  |  |  |  | 3
BIOL 1002 |  |  |  |  |  | 3 |  | Requirements for this degree (ücompleted)
CHEM 1001 |  |  |  |  |  | 3
 |  |  |  |  |  |  |  | Students are required to make a grade of "C" or higher in all courses listed under the Major [NAME] section fo the curriculum.
[NAME] (9)
CMST 2060 |  |  |  |  |  | 3
HIST |  |  |  |  |  | 3
HIST |  |  |  |  |  | 3 |  | Requirements for baccalaureate degrees (ücompleted)
F. Computer Literacy |  |  |  |  |  |  |  | 45 hours at the 3000-level or above
CMIS 1000 or |  |  |  |  |  |  |  | 15 hours at the 4000-level
CCE |  |  |  |  |  |  |  | 24 of the last 30 hours are resident hours
[NAME] (3) |  |  |  |  |  |  |  | Requirements for all degrees (ücompleted)
 |  |  |  |  |  | 3
(fine arts, music, theatre) |  |  |  |  |  |  |  | "C" or higher in ENGL 1001, ENGL 1002, & MATH 1021
 |  |  |  |  |  |  |  | Overall GPA of at least 2.0
2. [NAME] REQUIREMENTS (24 hrs) |  |  |  |  |  |  |  | At least 25% of hrs for degree completed at LSUA
BUSN 1001 |  |  |  |  |  | 3
ACCT 2001 |  |  |  |  |  | 2
ACCT 2101 |  |  |  |  |  | 2
CMIS 1150 |  |  |  |  |  | 2
ECON 2010 |  |  |  |  |  | 2
ECON 2020 |  |  |  |  |  | 2
BLAW 3201 |  |  |  |  |  | 2
MKTG 3401 |  |  |  |  |  | 2
3. MAJOR REQUIREMENTS (33 hrs)
HESC 1003 |  |  |  |  |  | 1
HESC 1004 |  |  |  |  |  | 2
HESC 1400 |  |  |  |  |  | 3
FINC  4718 |  |  |  |  |  | 3
ECON 4421 |  |  |  |  |  | 3
MGMT 4620 |  |  |  |  |  | 3
POLI 4012 |  |  |  |  |  | 3
PHIL 3025 |  |  |  |  |  | 3
ECAM 3060 |  |  |  |  |  | 3
ECAM 3061 |  |  |  |  |  | 3
ECAM 4060 |  |  |  |  |  | 3
ECAM 4061 |  |  |  |  |  | 3
Spreadsheet: 811093d1672272281-i-would-like-the-name-that-meets-all-3-rules-to-be-highlighted-in-blue-sample
Sheet: Sheet1

1 |  | TABTOUCH  BETTER YOUR BET MAIDEN [22,500]
 |  | Type : 2U MDN
13:20 |  | 2100m, TURF S(5)
[NAME] | Horse | BP | EST | PP | Form L3 | DLR
1 | MAGIC WHISTLE | 8 | 29.5 | 4.5 | x63 | 15
2 | SHABALALA | 10 | 25.0 | 10.0 | x06 | 7
3 | [NAME] | 5 | 30.5 | 4.5 | 572 | 14
4 | AMMISHADDAI | 7 | 29.0 | 5.5 | 7x4 | 14
5 | RUN TEDDY RUN | 3 | 25.5 | 3 | 321 | 7 |  | ok we see here [NAME] teddy is highlighted because (DLR is less than 8),(Form L3 ends in either 1 or 2) and (PP is lowest or second lowest)
6 | ASARKA | 1 | 24.0 | 41.0 | 906 | 18
7 | ZANZIBAR | 4 | 25.5 | 6.5 | 5 | 18 |  | I would like to load each meeting onto a saved excel sheet with formula embedded so automatically gives me answers.
8 | MAKIN PROPHETS | 2 | 30.5 | 5.5 | 643 | 14
9 | BORN TO BE LUCKY | 6 | 25.0 | 26.0 | 003 | 10 |  | The problem is each meeting is different and number of starters in each race changes day to day?
10 | WHAT SHOUT | 9 | 26.5 | 34.0 | 305 | 14
2 |  | GLENROY CHAFF MAIDEN [22,500]
 |  | Type : 2U MDN
13:57 |  | 1650m, TURF S(5)
[NAME] | Horse | BP | EST | PP | Form L3 | DLR
1 | ZOOROPA | 4 | 25.0 | 2.6 | 5x5 | 18
2 | KESEM | 5 | 26.0 | 10.0 | [NAME] | 14
3 | PLAINLY SPOKEN | 8 | 29.0 | 10.0 | 65 | 25
4 | PRINCE I THINK | 7 | 28.5 | 4.5 | x33 | 14
5 | ROCK 'N' TALES | 1 | 29.0 | 13.0 | x35 | 12
6 | GRECE LIGHTNING | 2 | 25.0 | 1.4 | x32 | 5
7 | DELTA ANNE | 6 | 30.0 | 14.0 | 238 | 12
8 | JE M'APPELLE BELLE | 3 | 7.0 | 151.0 | 87x | 196
9 | SHEER MAGNUM | 9 | 31.0 | 5.5 | 34 | 14
Spreadsheet: 311e848c-fc4e-440f-8701-d5e97e551d16
Sheet: Sheet1

2010년 전국 시·도별 축제총괄표 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  | (단위 : 개)
서울 | 부산 | 대구 | 인천 | 광주 | 대전 | 울산 | 경기 | 강원 | 충북 | 충남 | 전북 | 전남 | 경북 | 경남 | 제주 | 합계
69 | 44 | 24 | 23 | 13 | 16 | 21 | 93 | 93 | 51 | 76 | 62 | 34 | 51 | 112 | 31 | 813
※ 본 자료는 2010. 3. 5 현재 16개 시도에서 제출한 지역축제 자료를 종합한 것임.
Spreadsheet: 874238d1720796503-vlookup-via-searching-text-in-cell-char-limit-sample-document-v2
Sheet: SAMPLE

SAMPLE DATA |  |  |  |  |  |  |  | Lookup | Return
FIELD | MISC FIELD | MISC FIELD2 | [NAME] | Test Output |  | TEST #1 | GOAL | CG508 | C123
8140-14-1.0 8140-14-1.5 8140-14-2.3 8140-14-2.5 8140-18-1.7 8140-20-2.0 |  |  |  | A123 |  |  | Current | CG508 |  | <-issue right here
8100-12LV 8100-14LV 8100-16LV 8100-18 8100-20 8100-22 8100-24 8100-28 |  |  |  | B123
[NAME] CG405 CG406 CG407 CG408 CG409 CG410 CG411 CG412 CG413 CG414 CG415 CG416 CG417 CG430 CG431 CG432 CG501 CG502 CG503 CG504 CG505 CG506 CG507 CG508 CG509 CG510 CG511 CG512 CG513 CG514 CG515 CG516 CG521 CG418 CG433 CG434 CG435 [NAME] CG441 CG442 |  |  |  | C123 |  |  |  | Lookup | Return
LXMC13 LXMC14 LXMC15 LXMC16 LXMC17 |  |  |  | D123 |  | TEST #2 | GOAL | 8100-24 | B123
LXMC13x LXMC14x LXMC15x [NAME] LXMC14x LXMC15x [NAME] LXMC14x LXMC15x [NAME] LXMC14x LXMC15x [NAME] LXMC14x LXMC15x [NAME] LXMC14x LXMC15x [NAME] LXMC14x LXMC15x [NAME] LXMC17a |  |  |  | CHAR TEST 1 |  |  | Current | 8100-24 |  | <-works here
LXMC13x LXMC14x LXMC15x [NAME] LXMC14x LXMC15x LXMC16x LXMC17b |  |  |  | CHAR TEST 2
 |  |  |  |  |  |  |  | Lookup | Return
 |  |  |  |  |  | TEST #3 | GOAL | LXMC17 | D123
 |  |  |  |  |  |  | Current | LXMC17 |  | <-works here
 |  |  |  |  |  |  |  | Lookup | Return
 |  |  |  |  |  | HIGH CHAR TEST | GOAL | [NAME] | C123
 |  |  |  |  |  |  | Current | LXMC17a |  | <-issue right here
 |  |  |  |  |  |  |  | Lookup | Return
 |  |  |  |  |  | HIGH CHAR TEST | GOAL | [NAME] | C123
 |  |  |  |  |  |  | Current | LXMC17b |  | <-works here
Spreadsheet: 81215d1281458483-help-with-condition-need-to-make-ranking-problemup
Sheet: Hárok1

Name | COST | TYPE | RANK | Actual points | Total points VP | Temporary points CP
Name1 | 100000 | INP |  |  |  | 200
[NAME] | 200000 | IZP |  |  |  | 2000
Name1 | 31000 | UV |  |  |  | 5000
Name3 | 25000 | IZP |  |  |  | 34000
Spreadsheet: 720772d1614281542-aggregate-multiple-account-running-balances-without-matching-date-entries-cumulative-running-accounts-test
Sheet: Acount 2

DATE | ACCOUNT 2 BALANCE
2001-01-21 00:00:00 | 1000
2001-01-21 00:00:00 | 1500
2001-01-21 00:00:00 | 2000
2001-10-21 00:00:00 | 1500
2001-10-21 00:00:00 | 1000
01/25/21 | 2000
2002-01-21 00:00:00 | 2500
02/25/21 | 3000
02/25/21 | 3500
Spreadsheet: 122868d1317218530-help-needed-with-complex-multi-criteria-sorting-and-seacrhing-solution-v1
Sheet: Sheet1

 |  |  |  |  |  |  | A
 |  | Date | Name | # of shares |  |  | Date | Price of shares | A | Total B
 |  | 1 | A | 5 |  |  | 1 | 2
 |  | 2 | A | 5 |  |  | 11 | 2
 |  | 3 | A | 10 |  |  | 12 | 2
 |  | 4 | A | 10 |  |  | 13 | 2
 |  | 5 | B | 5 |  |  | 14 | 2
 |  | 6 | B | 5 |  |  | 15 | 2
 |  | 7 | A | 10 |  |  | 16 | 2
 |  | 8 | A | 10 |  |  | 17 | 2
 |  | 9 | A | 15 |  |  | 18 | 2
 |  | 10 | A | 20 |  |  | 19 | 2
 |  |  | <= returns value of dates match
 |  |  | <=returns # of shares if name matches
 |  |  |  | =IF(IFERROR(VLOOKUP([Date],Table3,5,),0)=0,D270,IFERROR(VLOOKUP([Date],Table3,5,),0))
 |  |  | <= returns zero if dates don't match
orderID | quantity | unit cost | total cost |  |  | OrderID | UnitCost | name
10567 |  | <4 |  |  | 10567 | 10567 | 7 | a
 |  |  |  |  | a | 10568 |  | a
orderid | quantity | unit cost | total cost |  |  | 10569 |  | b
10567 | 2 | 3.5 | 7 |  |  | 10570 |  | a
10569 | 5 | 5 | 25 |  |  | 1571 |  | b
10570 | 3 | 7.23 | 21.69
10571 | 12 | 2.99 | 35.88
 |  |  |  |  |  |  | if row A = Row B
ABOVE |  |  |  |  |  |  | then return row c at same position
 |  | type= "orderid" AND "unit cost"
 |  |  |  |  |  |  |  |  |  | find a + find id
 |  |  |  |  |  |  |  |  |  | if both equal
 |  |  |  |  |  |  |  |  |  | Return unit cost
 |  |  |  |  |  |  |  |  |  | all in one
Date | Transaction | Current Total of Security | Security Name | Symbol | Comission | Purchase price | Purchase Cost | Currency of security | Type of security | Sector | a
2011-09-16 00:00:00 | 15 | 150 | AB Volvo (ADR) | VOLVY | 4.95 | 11.35 |  | US | C Stock | Automotive | a
2011-09-22 00:00:00 | 15 | 300 | AB Volvo (ADR) | VOLVY | 4.95 | 9.97 |  | US | C Stock | Automotive | a
2011-09-26 00:00:00 | 15 | 150 | Suncor Energy Inc | SU | 4.95 | 25.77 |  | CAN | C Stock | Energy | a
 |  |  | NAME
Date | Total | # | VOLVY | SU | n/a |  |  |  |  |  |  | VLV | MATCH($D$81,E73:E76,)
2011-09-16 00:00:00 |  |  | 11.32 |  |  |  |  |  |  |  |  | DTE | MATCH(A82,A73:A76,)
2011-09-19 00:00:00 |  |  | 10.89 |  |  |  |  |  |  |  |  | VAL | IF(L82=L81,INDEX(C73:C76,L82,),"none")
2011-09-20 00:00:00 |  |  | 10.96 |  |  |  |  |  |  |  |  | TGT
2011-09-21 00:00:00 |  |  | 10.53
2011-09-22 00:00:00 |  |  | 9.92 |  |  |  |  |  |  |  | match date, then at date match symbol
2011-09-23 00:00:00 |  |  | 9.52
2011-09-26 00:00:00 |  |  | 9.77 | 27.66
 |  |  |  |  |  |  |  |  |  |  |  |  | DTE POS | MATCH(A82,A73:A76)
 |  |  |  |  |  |  |  |  |  |  |  |  | POS VAL | INDEX(E73:E76,M89,1)
 |  |  |  |  |  |  |  |  |  |  |  |  | POS # | INDEX(C73:C76,M89,1)
 |  |  |  |  |  |  |  |  |  |  |  |  | # MATCH | IF(M90=D81,M91,"none")
Spreadsheet: 175967d1345679554-convert-column-of-apparent-dates-to-actual-date-values-datemystery
Sheet: Sheet1

2012-05-31 00:00:00
2012-04-28 00:00:00
2012-06-07 00:00:00
2012-06-05 00:00:00
2012-03-15 00:00:00
2012-03-23 00:00:00
2012-04-30 00:00:00
2012-05-28 00:00:00
2012-06-05 00:00:00
2012-01-27 00:00:00
23/03/2012
13/02/2012
23/04/2012
29/05/2012
07/03/2012
23/03/2012
29/03/2012