tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 04ee76f2-efdb-4fc8-a540-8bde2dc353f7
Sheet: 7.2 Fac Prof Demographics

Institution
Indicator 7: Personnel Demographics, Professional Development, Research, and Outcomes
Table 7.2: Faculty, Teaching Staff, and Administrator Professional Demographics / AY 2010-11
Please enter Faculty, Teaching Staff, and Administrator degrees held, salary, and teaching load.
Full Time Faculty, Teaching Staff, and Administrators - Highest Degree Held |  |  |  | AY 2010-11
 |  | American Indian |  | Non-Indian |  | Total
 |  | M | F | M | F
No Degree - Expert in Field |  | 3 | 0 | 1 | 0
Associate |  | 0 | 0 | 0 | 0
Bachelors |  | 5 | 5 | 1 | 0
Masters |  | 5 | 5 | 13 | 22
Doctorate |  | 1 | 0 | 1 | 2
Other |  | 0 | 0 | 0 | 0
Total
Part Time Faculty, Teaching Staff, and Administrators - Highest Degree Held |  |  |  | AY 2010-11
 |  | American Indian |  | Non-Indian |  | Total
 |  | M | F | M | F
No Degree - Expert in Field |  | 4 | 4 | 0 | 0
Associate |  | 1 | 1 | 0 | 0
Bachelors |  | 11 | 21 | 9 | 5
Masters |  | 8 | 14 | 12 | 22
Doctorate |  | 1 | 3 | 5 | 3
Other |  | 0 | 0 | 0 | 0
Total
Teaching Staff Salaries and Teaching Load |  |  |  | AY 2010-11
 |  | American Indian |  | Non-Indian |  | Non Weighted Average
 |  | M | F | M | F
Full Time | Average Salary per academic year* | 42136 | 44168 | 44448 | 42641
 | Average # of courses taught each year | 4 | 4 | 4 | 4
 | Average # of students per course | 11 | 11 | 11 | 11
Part Time | Average Salary per credit hour | 482 | 482 | 482 | 482
 | Average # of courses taught each year | 2 | 2 | 2 | 2
 | Average # of students per course | 11 | 11 | 11 | 11
* Please specify contract duration: |  | 9 | months
Notes:
Spreadsheet: 0a04f73d-5ed4-46f4-a97b-6bac3891733e
Sheet: Sheet1

BlackBerry Statement of Work for Office of Intelligence and Investigative Liaison | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Requirements Needed | Specific ability to meet [NAME] what does vendor provide? List offering details, do not just list that you comply.
Blackberry device service, that features:
Bluetooth
Visual Voice Mail
MS Outlook Application enabled
Hearing Aid Capability = M3, meets FCC SAR limit, manufacturers highest FCC reported SAR 1.43 W/kg at ear, 0.53 W/kg on body, PC.
Mobile Broadband Card service that features:
A mobile connection 7-8 hours a month
Ability to send or receive email with small or no attachments
Light web browsing capability to download or upload small files and must be LTE capable
Coverage shall remain unabated in the below coastal and border areas
§               San Francisco/Oakland/San Jose, CA
§               Los Angeles, CA
§               San Diego, CA
§               Tucson, AZ
§               El Paso, TX
§               [NAME], TX
§               Brownsville, TX
§               Houston, TX
§               Beaumont, TX
§               Baton Rouge, LA
§               New Orleans, LA
§               Mobile, AL
§               Tallahassee, FL
§               Tampa, FL
§               Miami, FL
§               Jacksonville, FL
§               Savannah, GA
§               Charleston, SC
§               [NAME], NC
§               Greenville, NC
§               Norfolk/Newport News/Hampton Roads, VA
§               Washington, DC
§               Baltimore, MD
§               Philadelphia, PA
§               New York, NY
§               Buffalo, NY
§               Newark, NJ
§               Providence, RI
§               Boston, MA
§               Detroit, MI
§               Duluth, MN
§               Fargo, ND
§               Spokane, WA
§               Seattle, WA
§               Portland, OR
QSec-2700 phone service:
Shall provide (NSA Approved QUALCOMM devices)
Type 1 secure voice communications and secure data connectivity up to [NAME],
Shall operate at over 800 MHz and 1900 MHz through commercial wireless networks with a handset that features an embedded security solution that provides end-to-end data connectivity.
Customer interface inquiring into employee capabilities and requisite training to develop/enhance these capabilities
Shall provide CDMA circuit switch data through 2014
Spreadsheet: 22227d1210855238-spread-sheet-formulas-and-drop-down-request-for-orders-mission-sheet
Sheet: Per Diem Chart

City | [NAME] | Meals
Overland Park | 103 | 44
Kansas City | 103 | 44
Wichita | 80 | 49
Salina | 30 | 36
Topeka | 70 | 36
[NAME] | 70 | 36
Ottawa | 70 | 36
Iola | 70 | 36
Fort Riley | 70 | 36
Manhattan | 70 | 36
Atchinson | 70 | 36
Dodge City | 70 | 36
Garden City | 70 | 36
Liberal | 70 | 36
Great Bend | 70 | 36
Hays | 70 | 36
Hutchinson | 70 | 36
Spreadsheet: kate_symes__18091__Deal Correction 12-1
Sheet: Prior Day

Adjustment date | Date of applied calc | Deal Date | Desk | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
2000-11-30 00:00:00 | 2000-11-30 00:00:00 | 2000-11-30 00:00:00 | STCA | CM | Houston |  | Killed deal with wrong counterparty name |  | 470094 | SP-15 | 12/1/00-12/2/00 | [NAME] | 25 | 106 | Coral
 |  |  | CM Count
2000-11-30 00:00:00 | 2000-11-30 00:00:00 | 2000-10-30 00:00:00 | STNW | DS | Houston |  | Deleted strip in one deal (445955) which replicated another (445956) |  | 445956/445955 | Mid-C | X-00 | [NAME] | 58 | Index + .12 | PGE
 |  |  | DS Count
2000-11-30 00:00:00 | 2000-11-30 00:00:00 | 2000-11-30 00:00:00 | STCA | CM | Houston |  | Counterparty: from Transalta Corp to Transalta Energy Marketing (US) |  | 470841 | SP-15 | Z-00 | [NAME] | 25 | 120 | Transalta
 |  |  | CM Count
 |  |  | Grand Count
Spreadsheet: 0a8791de-84e4-4eb4-bfac-22483612972b
Sheet: Business Certificates 1

BUSINESS
Certificates
Students Name:
ID #
Accounting | Semester | Grade
Required
___ ACC 201 (3) Financial Accounting
OR ACT 101 (3) Fundamentals of Accounting I
AND ACT 102 (3) Fundamentals of Accounting II
___ ACC 202 (3) Managerial Accounting
Choose 12 hours from the following Technical Courses.  Students may select other courses as approved
by the Business Administration Systems Program Coordinator.
___ ACT 196 (3) Payroll Accounting
___ ACT 277 (3) Managerial Accounting Topics
___ ACT 279 (3) Computerized Accounting Systems
___ ACT 281 (3) Individual Taxation
___ ACT 286 (3) Financial Accounting Topics
___ ACT 290 (1-3) Selected Topics in Accounting (topic)
___ ACT 295 (3) Corporate and Partnership Taxation
___ [NAME] (3) Personal Finance
___ [NAME] (3) Introduction to Financial Management
___ CIT 234 (3) Advanced Productivity Software
Accounting Record Keeping Specialist
Required
___ ACC 201 (3) Financial Accounting
OR ACT 101 (3) Fundamentals of Accounting I
AND ACT 102 (3) Fundamentals of Accounting II
___ ACT 196 (3) Payroll Accounting
___ ACT 279 (3) Computerized Accounting Systems
___ ACT 281 (3) Individual Taxation
___ ACT 286 (3) Financial Accounting Topics
___ CIT 105 (3) Introduction to Computers OR ___ IC3 Computer Literacy Exam
OR ___ OST 105 (3) Introduction to Informational Systems
Business Transfer
Required
___ ACC 201 (3) Financial Accounting
___ ACC 202 (3) Managerial Accounting
___ ECO 201 (3) Principles of Microeconomics
___ ECO 202 (3) Principles of Macroeconomics
___ STA 220 (3) Statistics
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: 776348d1649691367-comparing-dates-in-two-columns-to-get-overdue-status-sla-dates
Sheet: Sheet1

 |  |  |  | Column A vs. Column B | Column C vs. Column D
Target Attendance Date | Actual Attendance Date | Target Completion Date | Actual Completion Date | Attend Status | [NAME]
2022-04-09 08:17:45.560000 | 2022-04-08 00:00:00 | 2022-04-10 08:17:45.560000 | 2022-04-08 00:00:00 | Within SLA | Within SLA | MANUAL EXAMPLE
2022-04-15 09:03:37.560000 |  | 2022-04-22 09:03:37.560000 |  | Date TBC | Date TBC
2022-04-09 09:10:58.750000 | 2022-04-10 00:00:00 | 2022-04-10 09:10:58.750000 | 2022-04-11 00:00:00 | Past SLA | Past SLA
2022-04-09 09:15:07.430000 | 2022-04-08 00:00:00 | 2022-04-10 09:15:07.430000 | 2022-04-08 00:00:00 |  |  | CURRENT FORMULA
Spreadsheet: 758181d1638724216-vlookup-across-multiple-sheets-kod195-129-commercial-road
Sheet: V (6)

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Instructed
 |  | Variations |  |  |  |  |  |  |  |  |  |  |  | Cost Provided
Item | Column2 | Description | Qty | Unit | Rate | Extension |  |  |  |  |  |  |  | Subcontractor Only |  |  |  |  |  |  | Column1 | Column2 | Column3 | Column4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Cancelled
 | Variations
Item | Description |  | Qty | Unit | Rate | Extension
 |  |  |  |  |  |  |  | HOME TO VARIATIONS
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SUBCONTRACTOR OUTPUT SECTION |  |  | [NAME] CONSTRIUCTION SECTION
Item | Description |  | Qty | Unit | Rate | Extension |  | Subcontractor | Status | Rate | Extension | Margin % | Margin £/p | Provided | Sub Only | Instructed | Provided | Sub Only | Instructed
Note
V
*
6.01
6.02
6.03
6.04 |  |  |  |  |  |  |  |  |  | 0
6.05 |  |  |  |  |  |  |  |  |  | 0
6.06 |  |  |  |  |  |  |  |  |  | 0
6.07 |  |  |  |  |  |  |  |  |  | 0
6.08 |  |  |  |  |  |  |  |  |  | 0
6.09 |  |  |  |  |  |  |  |  |  | 0
6.1 |  |  |  |  |  |  |  |  |  | 0
6.11 |  |  |  |  |  |  |  |  |  | 0
6.12 |  |  |  |  |  |  |  |  |  | 0
6.13 |  |  |  |  |  |  |  |  |  | 0
6.14 |  |  |  |  |  |  |  |  |  | 0
6.15 |  |  |  |  |  |  |  |  |  | 0
6.16 |  |  |  |  |  |  |  |  |  | 0
6.17 |  |  |  |  |  |  |  |  |  | 0
6.18 |  |  |  |  |  |  |  |  |  | 0
6.19 |  |  |  |  |  |  |  |  |  | 0
6.2 |  |  |  |  |  |  |  |  |  | 0
6.21 |  |  |  |  |  |  |  |  |  | 0
6.22 |  |  |  |  |  |  |  |  |  | 0
6.23 |  |  |  |  |  |  |  |  |  | 0
6.23999999999999 |  |  |  |  |  |  |  |  |  | 0
6.24999999999999 |  |  |  |  |  |  |  |  |  | 0
6.25999999999999 |  |  |  |  |  |  |  |  |  | 0
6.26999999999999 |  |  |  |  |  |  |  |  |  | 0
6.27999999999999 |  |  |  |  |  |  |  |  |  | 0
6.28999999999999 |  |  |  |  |  |  |  |  |  | 0
6.29999999999999 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  | To Collection
Spreadsheet: 42702d1241257628-updating-a-formula-based-on-multiple-sheets-demo1
Sheet: 4

 | Estimated | No.Sold | Diff | Remarks
Apple | 26 | 24 | 2
Mango | 27 | 30 | 3 | Free
[NAME] | 28 | 19 | 9
Pine Apple | 28 | 20 | 8
Kiwi | 30 | 17 | 13
Spreadsheet: 135231d1325875196-countif-with-certain-criteria-no-duplicates-copy_portfolio-management-report
Sheet: Details

Owner Name | Account | Engagement # | POD Dial Result
Rep 1 | Train Inc | 2 | Engagement
Rep 1 | Train Inc | 7 | Merchant requested no future calls (DNC)
Rep 1 | Train Inc | 6 | Merchant refused to talk to AXP
Rep 1 | Train Inc | 1 | Left voicemail
Rep 1 | Train Inc | 3 | Scheduled callback
Rep 1 | Train Inc | 4 | Unreachable
Rep 1 | Train Inc | 5 | Language barrier
Rep 2 | ACME CO | 1 | Left voicemail
Rep 2 | ACME CO | 2 | Left voicemail
Rep 2 | ACME CO | 3 | Scheduled callback
Rep 2 | ACME CO | 4 | Engagement
Rep 3 | ABC Company | 1 | Left voicemail
Rep 3 | ABC Company | 2 | Engagement
Rep 3 | ABC Company | 3 | Merchant requested no future calls (DNC)
Rep 4 | Motor Inc | 1 | Engagement
Rep 4 | Motor Inc | 2 | Scheduled callback
Rep 4 | Motor Inc | 3 | Left voicemail
Rep 4 | Motor Inc | 4 | Engagement
Rep 5 | XYZ Incorporated | 1 | Engagement
Rep 1 | TIDE CO | 1 | Left voicemail
Rep 1 | TIDE CO | 2 | Engagement
Spreadsheet: 805264d1668608190-days-past-due-if-not-closed-formula-days-past-due-help
Sheet: Sheet1

Date Initiated | Submit Date | Stakeholder Receive Date | [NAME] | Days ECR Open | EC Status
9/23/2022 | 2022-02-18 00:00:00 | 2022-09-27 00:00:00 | 2022-10-03 00:00:00 |  | Closed
9/29/2022 | 2022-02-21 00:00:00 | 2022-09-08 00:00:00 | 2022-09-14 00:00:00 |  | Closed
2022-10-06 00:00:00 | 2022-02-18 00:00:00 | 2022-09-27 00:00:00 | 2022-10-03 00:00:00 |  | Elaborate | If EC Status is NOT "Closed", populate "Days ECR Open" past [NAME]
10/4/2022 | 2022-02-18 00:00:00 | 2022-09-27 00:00:00 | 2022-10-03 00:00:00 |  | Closed
9/28/2022 | 2022-02-18 00:00:00 | 2022-09-27 00:00:00 | 2022-10-03 00:00:00 |  | Execute | If EC Status is NOT "Closed", populate "Days ECR Open" past [NAME]
2022-11-04 00:00:00 | 2022-02-18 00:00:00 | 2022-09-27 00:00:00 | 2022-10-03 00:00:00 |  | Execute | If EC Status is NOT "Closed", populate "Days ECR Open" past [NAME]
2022-11-10 00:00:00 | 2022-02-18 00:00:00 | 2022-09-27 00:00:00 | 2022-10-03 00:00:00 |  | [NAME] | If EC Status is NOT "Closed", populate "Days ECR Open" past [NAME]
2022-11-09 00:00:00 | 3/2/2022 | 2022-10-15 00:00:00 | 2022-10-20 00:00:00 |  | Closed
Spreadsheet: 768387d1644943789-xml-help-is-requested-urgently-xml-format
Sheet: GEN SEG

PART A |  |  |  | TRADERS INFO |  |  |  | DECLARANT |  |  | Ctry of Export
Office | Type | Regime |  | EXP CODE | EXP NAME | IMP CODE | IMP NAME | DECLARANT CR |  |  | CoX
2101 | IM | 4 |  |  | MOHSIN | 007108-01 |  | 038729-01
Vessel Identity |  |  |  | INVOICE |  |  |  | Delivery Terms |  |  | POL
Name | Nationality |  |  | Invoice value | 1000 | USD |  | Code | Place |  | Code | Name
X-PRESS | 101 |  |  | Freight [fcy] |  |  |  | CFR | BH |  | CNSHA | SHANGHAI
 |  |  |  | Insurance
 |  |  |  | Other costs |  |  |  | CAP
 |  |  |  | Grand Total
Spreadsheet: 783018d1654525112-query-the-first-sales-specification-and-the-last-specification-f6-6
Sheet: Sheet1

 |  |  | sales start | end of sale | 2021Q1 | 2021Q2 | 2021Q3 | 2021Q4 | 2022Q1 | 2022Q2 | 2022Q3 | 2022Q4
 |  | product1 |  | 2022Q1 |  |  | S | S | S
 |  | product2 |  | 2022Q2 |  | S | S | S | S | S
 |  | product3 |  | 2022Q3 |  |  |  | S | S | S | S
Spreadsheet: gerald_nemec__11549__Purchase Confirmation Apr 01
Sheet: Phillips

CONFIRMED |  |  | FIRST OF MONTH SCHEDULED VOLUME
PURCHASER: |  |  |  | SELLER:
Enron North America Corp. |  |  |  | Phillips Petroleum
1200 17th Street, [NAME] 2750 |  |  |  | [NAME]
Denver, Colorado  80202 |  |  |  | Houston, TX 77251
Attention:  [NAME] |  |  |  | Attention:   [NAME]
Phone:  (303) 575-6485 |  |  |  | Phone:  (713) 669-3493
Fax:  (303) 534-0552 |  |  |  | Fax:  (713) 669-7358
E-mail Address:  [EMAIL] |  |  |  | E-mail Address:  [EMAIL]
Flow Month: | 2001-04-01 00:00:00 |  |  |  | Effective Date: | 2001-04-01 00:00:00
 |  |  |  |  | (start date for flow)
Contract #: | 96028454
 |  | [NAME] factor: | 0.943 | Effective 3/1/01
 |  | [NAME] factor: | 0.94 | Effective 3/1/01
DELIVERY POINTS: |  | Bear Paw Btu factor: | 0.969
 | Meter # | [NAME] | Expected Volume Mcf/d | Expected Volume MMBtu/d | # of Days | Total MMBtu/for Month
 | 0814035 | Palomino Screw #1 | 0 | 0
 |  | (47N 72W 5 Sec)
 | 0814036 | Palomino Screw #2 | 0 | 0
 |  | (47N 72W 5 Sec)
 |  | Bear Paw | 0 | 0
 | 0814032 | Clydesdale Screw #1 | 0 | 0
 |  | (48N 73W 30 Sec)
 | 0814033 | Clydesdale Screw #2 | 0 | 0
 |  | (48N 73W 29 Sec)
 | 0814034 | Clydesdale Screw #3 | 0 | 0
 |  | (48N 73W 29 Sec)
 |  | TOTAL PURCHASE: | 12500 |  | 30
 | Total Delivery Volume:
Spreadsheet: 754082d1635937636-date-range-on-master-sheet-to-populate-month-sheets-following-sample-comm-sheet
Sheet: Feb21

NAME | ROLE | CLIENT | START DATE | END DATE | DAYS WORKED | RESOURCE RATE | SECOND RATE | SELL RATE | TOTAL VALUE FOR IDPP PER MONTH | COMM EARNED PER PROJECT | 2020-02-01 00:00:00 |  | 2020-03-01 00:00:00 |  | 2020-04-01 00:00:00 |  | 2020-05-01 00:00:00 |  | 2020-06-01 00:00:00 |  | 2020-07-01 00:00:00 |  | 2020-08-01 00:00:00 |  | 2020-09-01 00:00:00 |  | 2020-10-01 00:00:00 |  | 2020-11-01 00:00:00 |  | 2020-12-01 00:00:00 |  | 2021-01-01 00:00:00 |  | 2021-02-01 00:00:00 |  | 2021-03-01 00:00:00 |  | 2021-04-01 00:00:00 |  | 2021-05-01 00:00:00 |  | 2021-06-01 00:00:00 |  | 2021-07-01 00:00:00 |  | 2021-08-01 00:00:00 |  | 2021-09-01 00:00:00 |  | 2021-10-01 00:00:00 |  | 2021-11-01 00:00:00
COMM. CALCULATION
[NAME] | Service Desk Analyst | The Company | 2021-01-01 00:00:00 | 2021-03-30 00:00:00 | 20 | 135 | 160 | 180 |  |  | 1
Spreadsheet: 129282d1321536600-drop-down-based-on-multiple-validation-lists-dependent-selection-lists
Sheet: Sheet1

 | 111 | 222 | 333
 | Company1 | Company5 | Company8
 | Company2 | Company6 | Company9
 | Company3 | Company7 | Company10
 | 111
 | 222
 | 333
 | Company2
 | Company2
 | Company3
 | Company5
 | Company6
 | Company7
Spreadsheet: 120187d1315058280-extract-model-nos-from-cells-and-take-related-data-with-them-model-no-separate
Sheet: Model No to columns

Description | Model, Unit Type | Part Number | Alt Part Number
Widget xyz | 9111-285 | 03N5280* | 80P3163**
Widget xyz | 9111-285 | 03N5280* | 80P3163**
Widget xyz | 9115-505 | 03N5280* | 80P3163**
Widget xyz | 9110-510 | 03N5280* | 80P3163**
Widget xyz | 9110-51A | 03N5280* | 80P3163**
Widget xyz | 9110-52A | 03N5280* | 80P3163**
Widget xyz | 9405-520 | 03N5280* | 80P3163**
Widget xyz | 9406-520 | 03N5280* | 80P3163**
 | Pulled some of Models from cell to show what result I need.
Spreadsheet: 834095d1687441453-populate-a-table-by-searching-multiple-columns-test-file-june-2023-version-2-ksherley2204-
Sheet: Max CountIf test

 | Field ID | Depth | Sulphate
 | 22-BH14:2.0 | 2 | 256
 | 22-BH14:4.0 | 4 | 655 |  |  |  | Sulphate
 | 22-BH15:0.6 | 0.6 | 11 |  |  | Depth | BH01 | BH02 | BH03 | BH04 | BH05 | BH08 | BH12 | BH13 | BH14 | BH15 | BH16
 | 22-BH15:1.4 | 1.4 | 17.8 |  |  | 0.3
 | 22-BH16:0.3 | 0.3 | 16 |  |  | 0.6
 | 22-BH16:1.0 | 1 | 23 |  |  | 1
 | 22-BH01:0.6 | 0.6 | 336 |  |  | 1.4
 | 22-BH01:1.0 | 1 | 368 |  |  | 2
 | 22-BH01:1.4 | 1.4 | 1290 |  |  | 2.5
 | 22-BH01:2.5 | 2.5 | 167 |  |  | 2.9
 | 22-BH02:1.0 | 1 | 25.5 |  |  | 3.5
 | 22-BH02:2.0 | 2 | 25.8 |  |  | 4
 | 22-BH02:2.9 | 2.9 | 73.3 |  |  | 4.5
 | 22-BH03:0.6 | 0.6 | 288 |  |  | 5
 | 22-BH03:1.0 | 1 | 746 |  |  | 5.5
 | 22-BH03:2.5 | 2.5 | 1580 |  |  | 6
 | 22-BH03:3.5 | 3.5 | 370
 | 22-BH04:0.6 | 0.6 | 88.6
 | 22-BH04:1.0 | 1 | 14
 | 22-BH04:2.0 | 2 | 39.1
 | 22-BH04:2.9 | 2.9 | 199
 | 22-BH05:0.6 | 0.6 | 16
 | 22-BH05:2.0 | 2 | 1930
 | 22-BH05:4.0 | 4 | 1910
 | 22-BH08:2.0 | 2 | 904
 | 22-BH12:0.3 | 0.3 | 42.3
 | 22-BH12:1.4 | 1.4 | 10
 | 22-BH13:2.0 | 2 | 19.1
Spreadsheet: ece87568-2979-4198-b55a-f405b8820464
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26
Primary Layout Report Date: | (mm/dd/yyyy)
This spreadsheet and the accompanying instructions do not constitute, and should not be considered a substitute for, legal advice.  The rules governing the proper tax characterization of distributions by mutual funds can be complex.  Each fund should cons
Please list Securities in [NAME] (Skip Rows Between Entries)
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27
 |  |  |  |  |  |  |  |  |  | Year Included in Shareholders' Income |  |  |  |  |  | Box 1a Total | Box 1b Total | Box 2a | Box 2b | Box 2c | Box 2d | Box 3 | Box 6 | Box 8 | Box 9
Security |  |  |  |  |  |  |  |  | Total |  |  |  |  |  | Foreign | Ordinary |  |  | Unrecap |  |  |  | Foreign | Cash | Noncash | Exempt
Description |  | Ticker | Estimated | Reclass | Corrected | Record | Ex-Dividend | Payable | Distribution | 2004 | 2006 | 2005 | Income | Short-term | Tax | Dividends | Qualified | Total Capital | Sec. 1250 | Section 1202 | Collectibles | Nontaxable | Tax | Liquidation | Liquidation | Interest
(Fund Name) | CUSIP | Symbol | (E) | (R) | (C) | Date | Date | Date | Per Share | (Prior Year) | (Next Year) | (Current Year) | Dividends | Capital  Gain | Paid | (col. 14+15+16) | Dividends | [NAME]. | Gain | Gain | (28%) Gain | Distributions | Paid | Distr | Distr | Dividends
[NAME] | 008273104 | ARC |  |  |  | 2005-03-31 00:00:00 |  | 2005-04-15 00:00:00 | 0.3125 |  |  | 0.3125 |  |  |  |  |  |  |  |  |  | 0.3125
[NAME] | 008273104 | ARC |  |  |  | 2005-06-30 00:00:00 |  | 2005-07-15 00:00:00 | 0.1875 |  |  | 0.1875 |  |  |  |  |  |  |  |  |  | 0.1875
TOTALS |  |  |  |  |  |  |  |  | 0.5 |  |  | 0.5 |  |  |  |  |  |  |  |  |  | 0.5
ARC Preferred A | 008273203 | ARCpA |  |  |  | 2005-01-15 00:00:00 |  | 2005-01-31 00:00:00 | 0.5156 |  |  | 0.5156 |  |  |  |  |  |  |  |  |  | 0.5156
ARC Preferred A | 008273203 | ARCpA |  |  | Corrected | 2005-04-15 00:00:00 |  | 2005-04-29 00:00:00 | 0.515625 |  |  | 0.515625 |  |  |  |  |  |  |  |  |  | 0.515625
ARC Preferred A | 008273203 | ARCpA |  |  | Corrected | 2005-07-15 00:00:00 |  | 2005-07-29 00:00:00 | 0.515625 |  |  | 0.515625 |  |  |  |  |  |  |  |  |  | 0.515625
ARC Preferred A | 008273203 | ARCpA |  |  | Corrected | 2005-10-15 00:00:00 |  | 2005-10-30 00:00:00 | 0.515625 |  |  | 0.515625 |  |  |  |  |  |  |  |  |  | 0.515625
ARC Preferred A | 008273203 | ARCpA |  |  | Corrected | 2006-01-13 00:00:00 |  | 2006-01-30 00:00:00 | 0.515625 |  | 0.515625
TOTALS |  |  |  |  |  |  |  |  | 2.5781 |  | 0.515625 | 2.062475 |  |  |  |  |  |  |  |  |  | 2.062475
Spreadsheet: 44016d1242693190-sort-array-based-on-criteria-from-drop-down-book1
Sheet: Sheet1

Problem: Sort the data based on Column E data
 | Select sort criteria: | Condition 1
 | Secondary criteria: | Condition 5
 |  |  |  | Condition 1 | Condition 2 | Condition 3 | Condition 4 | Condition 5 | Condition 6 | Condition 7
 |  |  |  | Item A | 11 | 81 | 29 | 5 | 100 | 38
 |  |  |  | Item A | 54 | 18 | 16 | 48 | 7 | 88
 |  |  |  | Item A | 46 | 45 | 30 | 80 | 39 | 47
 |  |  |  | Item A | 98 | 91 | 93 | 97 | 26 | 15
 |  |  |  | Item B | 41 | 70 | 59 | 66 | 20 | 23
 |  |  |  | Item B | 83 | 24 | 8 | 74 | 12 | 85
 |  |  |  | Item B | 32 | 78 | 67 | 75 | 101 | 34
 |  |  |  | Item C | 61 | 55 | 2 | 35 | 57 | 27
 |  |  |  | Item C | 89 | 52 | 79 | 44 | 17 | 64
 |  |  |  | Item C | 90 | 3 | 13 | 50 | 4 | 56
 |  |  |  | Item C | 71 | 21 | 60 | 96 | 22 | 68
 |  |  |  | Item D | 33 | 77 | 72 | 6 | 86 | 10
 |  |  |  | Item D | 51 | 43 | 82 | 25 | 40 | 73
 |  |  |  | Item D | 95 | 58 | 37 | 36 | 62 | 28
 |  |  |  | Item D | 1 | 76 | 53 | 63 | 9 | 87
 |  |  |  | Item D | 65 | 69 | 94 | 92 | 49 | 84
 |  |  |  | [NAME] | 14 | 19 | 99 | 42 | 31 | 102
Spreadsheet: 717403d1612632008-combine-table-with-dsum-function-and-data-table-tool-color
Sheet: Sheet1

Product | Color | Sell |  | Product | Color | Sell
A | Blue | 100 |  |  |  |  |  |  | Please, without VBA & helper colomns
B | Green | 200 |  |  |  |  |  |  | I mean you can use range(E2:G2)
A | Blue | 300 |  |  | A | B | C
A | Blue | 400 |  | Blue | 800 | 0 | 100
B | Green | 500 |  | Green | 1400 | 700 | 0
A | Green | 600
C | Blue | 100
A | Green | 800 |  | Colored rang(F5:H6) is My Result
 |  |  |  | Tbl | =Sheet1!$A$1:$C$9
Spreadsheet: 8d9cfa03-4381-4d33-9125-6f3862643505
Sheet: Sheet1

HASIL PENILAIAN PLPG TAHAP 5-8 TAHUN 2011
NO | NOMOR PESERTA | NAMA PESERTA | ASAL SEKOLAH | KAB/KOTA | STATUS
1 | 11032006310526 | SUNTARI | SMP N 1 BANGSRI | Kab. Jepara | MENGULANG UJIAN TULIS
2 | 11032022010424 | AGUNG TAVIP BUDHIARTO | SD N KELING 03 | Kab. Jepara | LULUS
3 | 11032022010434 | ALI MUID | SD N BLINGOH 05 | Kab. Jepara | LULUS
4 | 11032022010527 | SUGITO | SMP N 1 BATEALIT | Kab. Jepara | LULUS
5 | 11032022010529 | MUNIF | SMP N 1 JEPARA | Kab. Jepara | LULUS
6 | 11032022010221 | DIMYATI | SD N LEBAK 04 | Kab. Jepara | LULUS
7 | 11032022010493 | BAMBANG SETYADI | SD N NGASEM 05 | Kab. Jepara | LULUS
8 | 11032022010442 | HIDAYATUN JUMADI | SD N KARANGNONGKO 02 | Kab. Jepara | LULUS
9 | 11032022010200 | NINIK SUSILO PURWATI | SD N KELET 01 | Kab. Jepara | MENGULANG UJIAN TULIS
Spreadsheet: 865075d1712154698-vlookup-column-index-problem-vlookup-problem
Sheet: Sheet1

 |  |  |  |  |  | Minnesota Twins | [NAME]
Spreadsheet: 220859d1363283243-lookup-problem-test-doc
Sheet: INFO SHEET TO RETRIEVE ADDRESSE

NUM | NAME | ADDRESS
1 | Doe, [NAME] | 540 Wilson Street, Boston, MA
2 | [NAME], [NAME] | 120 Astor Avenue, New York, NY
3 | Barnes, [NAME] | 550 Wilkins Place, Philadelphia , PA
4 | Doe, [NAME] | 220 Primrose Lane, Savannah, GA
5 | Jones, [NAME] | 115 Wyatt Road, Miami, FL
6 | [NAME], [NAME] | 1189 Belmont Circle, Washington, DC
7 | Doe, [NAME] | 2151 Cincinnati Place, Cincinnati , OH
8 | Jones, [NAME] | 550 Tremont Ave, Bronx, NY
9 | Walters, [NAME] | 440 Madison Avenue, New York, NY
10 | Ally, Rebecca | 1215 Peppermint Row, Indianapolis, MN
11 | [NAME], [NAME] | 1313 Melancoly Circle, Los Angeles, CA
12 | Barnes, [NAME] | 850 Wintergreen Row, [NAME]