tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 145878d1331794236-transfer-data-from-one-sheet-to-another-when-specific-value-entered-in-first-sheet-example_2012_file-1-
Sheet: May

Reporter | Date Rec. | Date Comp. | Witness | Description | Pages Rec | Pages Rtn | Job Type | Rate | Total | Tithe Amount | Tithed | Invoice # | Invoice Date | Date Paid | Monthly Tithe | Tithed MTD | Left to Tithe | Total | Amount Received | Total By Reporter | Amount Due | Amount Received
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jeanne
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Karisa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 764703d1642898924-top-5-customers-with-a-condition-excel-help
Sheet: Sheet 1

 | Customer Number | Customer Name | Billing | Profitability | Rank | Rank the Rank |  | 5 |  |  |  |  |  |  | 5
 | 1 | AA | 146305.69 | 0.64 | 20 |  |  |  | BG | 2500 | 0.84 |  |  |  |  | AT | 13000 | 0.01 | 45 | 41
 | 4 | BB | 94374.5 | 0.54 | 24 |  |  | 70 | BA | 6000 | 0.82 | 2 | 1 |  | 62 | AS | 14000 | 0.04 | 44 | 40
 | 7 | FF | 73172.43 | 0.52 | 28 |  |  | 47 | AC | 29000 | 0.81 | 3 | 2 |  | 61 | AR | 15000 | 0.11 | 43 | 39
 | 6 | CC | 64185.09 | 0.65 | 15 |  |  | 50 | AG | 26500 | 0.81 | 3 | 2 |  | 68 | AY | 8000 | 0.13 | 42 | 38
 | 18 | HD | 55885.1 | 0.66 | 14 |  |  | 49 | AF | 27000 | 0.8 | 5 | 4 |  | 55 | AL | 21000 | 0.14 | 41 | 37
 | 38 | GS | 44840 | 0.6 | 23
 | 2 | GF | 42741.5 | 0.76 | 8
 | 9 | FS | 36146.6 | 0.7 | 11
 | 11 | AE | 36030.99 | 0.75 | 9
 | 3 | GK | 34143.59 | 0.75 | 9
 | 85 | JU | 32831.03 | 0.65 | 15
 | 82 | GI | 32807.54 | 0.65 | 15
 | 64 | SW | 31919 | 0.78 | 7
 | 71 | ER | 31769.72 | 0.79 | 6
 | 78 | WE | 31200.03 | 0.65 | 15
 | 46 | QU | 30557.5 | 0.63 | 21
 | 47 | AC | 29000 | 0.81 | 3
 | 48 | AD | 28000 | 0.7 | 11
 | 49 | AF | 27000 | 0.8 | 5
 | 50 | AG | 26500 | 0.81 | 3
 | 51 | AH | 25000 | 0.54 | 24
 | 52 | AI | 24500 | 0.67 | 13
 | 53 | AJ | 23000 | 0.54 | 24
 | 54 | AK | 22000 | 0.62 | 22
 | 55 | AL | 21000 | 0.14 | 41
 | 56 | AM | 20000 | 0.21 | 38
 | 57 | AN | 19000 | 0.23 | 36
 | 58 | AO | 18000 | 0.34 | 33
 | 59 | AP | 17000 | 0.65 | 15
 | 60 | AQ | 16000 | 0.23 | 36
 | 61 | AR | 15000 | 0.11 | 43
 | 62 | AS | 14000 | 0.04 | 44
 | 63 | AT | 13000 | 0.01 | 45
 | 64 | AU | 12000 | 0.43 | 30
 | 65 | AV | 11000 | 0.32 | 34
 | 66 | AW | 10000 | 0.45 | 29
 | 67 | AX | 9000 | 0.54 | 24
 | 68 | AY | 8000 | 0.13 | 42
 | 69 | AZ | 7000 | 0.18 | 40
 | 70 | BA | 6000 | 0.82 | 2
 | 71 | BC | 5500 | 0.38 | 31
 | 72 | BD | 4000 | 0.19
 | 73 | BE | 3500 | 0.37
 | 74 | BF | 3000 | 0.26
 | 75 | BG | 2500 | 0.84
Spreadsheet: 1188c176-cf72-4ad8-aedd-2d61716f7b54
Sheet: Input Data

[NAME]
Date |  | 2012-04-16 00:00:00
Project Name |  | Sample project |  |  |  |  |  | PIN |  | 99999
Estimate Date |  | 2011-07-01 00:00:00 |  |  |  |  |  | Submit for Ad Date:
Last Review Date
Project Manager |  |  |  |  |  |  |  | Phone #
Current Cost Est. ($M) |  |  |  |  | Cost Input Comments |  |  | Current Schedule Duration (Mo.) |  |  |  |  | [NAME]
Proj Phase: | Design | RW | Const |  |  |  |  | Proj Phase: | Design | R/W | Const | Other
 | 2.3 | 7.2 | 53.6 |  |  |  |  |  | 30 | 24 | 36
Cost Impact |  |  |  |  | Likelihood |  |  | Schedule Impact
Proj Phase: | Design | R/W | Const | Other | Probability |  |  | Proj Phase: | Design | R/W | Const | Other
 | 0 | 0 | 0 |  |  | 0 |  |  | 0 | 0 | 0
 | 10 | 0.1 | 0.25 |  |  | 0.1 |  |  | 7 | 7 | 10
 | 30 | 0.25 | 0.5 |  |  | 0.35 |  |  | 14 | 14 | 30
 | 50 | 0.5 | 0.75 |  |  | 0.65 |  |  | 21 | 21 | 60
 | 90 | 1 | 1 |  |  | 0.9 |  |  | 30 | 30 | 90
Comments
 | LOOKUPS, DO NOT TOUCH!!!!!!
 |  |  |  |  | activity impacted |  | Type | Functional Area
 | Active |  | Threat |  |  |  | Avoid | Construction
 | Inactive |  | Opportunity |  | DESIGN |  | Transfer | Contracting & Procurement
 | Retired |  |  |  | R/W |  | Mitigate | Design / PS&E
 |  |  |  |  | CONST |  | Accept | Environmental & Hydraulics
 |  |  |  |  |  |  |  | Maintenance
 |  |  |  |  |  |  |  | Management / Funding
 |  |  |  |  |  |  |  | Project Management
 |  |  |  |  |  |  |  | Right of Way
 |  |  |  |  |  |  |  | Structures
 |  |  |  |  |  |  |  | Geotech
 |  |  |  |  |  |  |  | Traffic Management
 |  |  |  |  |  |  |  | Utilities and Railroads
 |  |  | Active |  |  |  |  | Threat |  |  |  |  |  |  |  |  | PE
 |  |  | Inactive |  |  |  |  | Opportunity |  |  |  |  |  |  |  |  | R/W
 |  |  | Retired |  |  |  |  |  |  |  |  |  |  |  |  |  | CN
Spreadsheet: 0d5641d9-80f9-4b2f-be7b-df4d6e90add2
Sheet: Sheet1

Agency Postpayment Audit Submissions
Account (month/year):
Agency:
Agency Location Code:
Address:
City:
State:
ZIP Code:
Point of Contact:
[NAME]: |  | Phone Number:
Enter number of paid invoices and total dollar amount for each mode that is being submitted in the space provided below.
Modes | # of paid invoices | Amount
Air Cargo
Domestic Household Goods
Foreign Household Goods
Motor
Passenger
Rail
Steamship
For Paper submissions add the number of boxes mailed:
Spreadsheet: 867484d1714362598-condtional-format-excel-list-dv-
Sheet: Sheet1

List 1 | List 2 | List 3 | List 4 | List 5 | List 6 |  |  |  | My dependent lists that I can copy around the sheet | List 1
A | AA | AAA | AAAA | AAAAA | AAAAAA |  |  |  |  | B
B | BB | BBB | BBBB | BBBBB | BBBBBB
C | CC | CCC | CCCC | CCCCC | CCCCCC
D | DD | DDD | DDDD | DDDDD | [NAME]
E | EE | EEE | EEEE | EEEEE | EEEEEE |  |  |  |  |  |  |  | copy 1:
F | FF | FFF | FFFF | FFFFF | FFFFFF |  |  |  |  |  |  |  | List 3
 |  |  |  |  |  |  |  |  |  |  |  |  | DDD
 |  |  |  |  |  |  |  |  |  |  |  | copy 2:
 |  |  |  |  |  |  |  |  |  |  |  | List 3
 |  |  |  |  |  |  |  |  |  |  |  | BBB
Spreadsheet: 159591d1338766298-excel-2007-top-ten-and-adjacent-cell-sum-book1
Sheet: Sheet1

25 | 35 | 40 | 45 | 45 | 50 | 45 | 50 | 35 | 30 | 25 | 20 | Grades
45 | 50 | 40 | 30 | 25 | 60 | 65 | 45 | 60 | 65 | 50 | 40 | Values
 |  |  |  |  |  |  |  |  |  |  |  | Rank
 |  |  |  |  |  |  |  |  |  |  | Top 8
Spreadsheet: cara_semperger__1454__ENA_PGE_DEC18_2001
Sheet: LOSSES

From: | EPMI
To: | PGE System Transactions
Date:
HE
ENDING | TOTAL |  | TOTAL
Pacific
Prevailing
Time | NO SCHEDULE POSTED
(PPT)
0100 |  | 2
0200 |  | 2
0300 |  | 2
0400 |  | 2
0500 |  | 2
0600 |  | 2
0700 |  | 3
0800 |  | 3
0900 |  | 3
1000 |  | 3
1100 |  | 3
1200 |  | 3
1300 |  | 3
1400 |  | 3
1500 |  | 3
1600 |  | 3
1700 |  | 3
1800 |  | 3
1900 |  | 3
2000 |  | 3
2100 |  | 3
2200 |  | 3
2300 |  | 2
2400 |  | 2
 | PGE | PGE | PGE
 | REAL POWER LOSSES | PGE LOSSES | [NAME] [NAME]
 | PGE | PGE | PGE
 | 640902
 | 640903
 | NEW COLUMN
Spreadsheet: 0db8fa5f-684a-4969-b425-e5e098aca213
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-11-04 09:43:03.950000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.5 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.375 | 101.671 | 101.546 | 101.421 | 101.046
4.25 | 100.982 | 100.857 | 100.732 | 100.357 |  | Note: | Refer To Price [NAME]
4.125 | 100.477 | 100.352 | 100.227 | 99.852 |  |  | For all Price Adjs
4 | 100.022 | 99.897 | 99.772 | 99.147
3.875 | 99.486 | 99.361 | 99.236 | 98.611
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 101.528 | 101.403 | 101.278 | 100.903
3.75 | 101.101 | 100.976 | 100.851 | 100.476
3.625 | 100.743 | 100.618 | 100.493 | 100.118
3.5 | 100.395 | 100.27 | 100.145 | 99.77
3.375 | 99.996 | 99.871 | 99.746 | 99.121
3.25 | 99.507 | 99.382 | 99.257 | 98.632
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-11-18 09:43:03.950000
30 DAY | 2011-12-03 09:43:03.950000
45 DAY | 2011-12-18 09:43:03.950000
60 DAY | 2012-01-02 09:43:03.950000
90 DAY | 2012-02-01 09:43:03.950000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 04fcb7af-ba11-4524-b39b-44ca564e37be
Sheet: Sheet1

STATE OF WEST VIRGINIA | Unnamed: 1 | Unnamed: 2
OFFICES OF THE INSURANCE COMMISSIONER
RISK PURCHASING GROUPS
STATEMENT OF PREMIUMS
MAILING ADDRESS: | Due on or before: | LOCATION:
[NAME] 50542 | February 28 | 1124 Smith Street, Room 100
Charleston, WV   25305-0542 |  | Charleston,  WV   25301
ANNUAL FILING REQUIREMENTS:
As of June 7, 2002, the State of West Virginia licenses non-resident surplus lines licensees.  Therefore, if a Risk Purchasing Group is doing business through a surplus lines company, please contact our Agents Licensing Section at (304) 558-0610 to obtain a non-resident surplus lines broker license.
Risk Purchasing Groups Statement of Premiums for the year ending December 31, is due on or before the close of business February 28.  This  statement must be completed, signed and notarized.
Complete Section A, B, C, or D of premiums paid for liability risks resident, situated, or located in the State of West Virginia, including policy and membership fees.
Name of Risk Purchasing Group (PG) |  | For Calendar Year Ending:
Mail Address (No. & Street) | City, State & Zip Code | Organized Under the Laws of:
Contact Person: | Phone Number: | E-Mail Address:
A.  PLACEMENT OF COVERAGE WITH AUTHORIZED INSURERS
Name of Insurer | NAIC Code Number | [NAME]
TOTAL |  | 0
[NAME] LICENSED W.VA. SURPLUS LINES BROKER
Name of Insurer and NAIC Code | Name of WV Surplus Lines Broker and License Number | [NAME]
TOTAL |  | 0
[NAME]
Name of Risk Retention Group | NAIC Code | [NAME]
TOTAL |  | 0
D.  PLACEMENT OF COVERAGE WITH ANY OTHER SOURCE
Name of Insurer | NAIC Code | [NAME]
TOTAL |  | 0
STATE OF _____________________________________________
COUNTY OF ___________________________________________
________________________________________________, BEING DULY SWORN, STATES THAT HE/SHE IS THE __________________________________ OF THE ABOVE NAMED RISK PURCHASING GROUP, AND THAT THE FOREGOING IS A FULL, TRUE AND CORRECT STATEMENT OF ALL PREMIUMS AND FEES RECEIVED ON LIABILITIES INSURED WITHIN THE STATE OF WEST VIRGINIA BY SAID RISK PURCHASING GROUP DURING THE YEAR ENDING DECEMBER 31, ___________, AND INCLUDES ALL POLICIES WHEREVER WRITTEN ACCORDING TO THE BEST OF HIS/HER KNOWLEDGE, INFORMATION AND BELIEF.
______________________________________________________
(Officer's Signature)
SUBSCRIBED AND SWORN TO BEFORE ME THIS ___________ DATE OF ___________________, 20________.
_____________________________________________________
(Notary's Signature)
MY COMMISSION EXPIRES: _____________________________________________________
Spreadsheet: 179669d1347350763-transfer-some-particular-information-to-particular-column-in-another-sheet-book1
Sheet: Control

 |  | CONTROL
 | 1 | Customer: | Customer A |  |  |  |  |  |  |  |  | 2 | Customer: | Customer B |  |  |  |  |  |  |  |  | 3 | Customer: | Customer C
The received date and part no are refer to the incoming sheet while others are just type in. The blue rows are the value that will transfer to the master sheet. |  | No | Date |  | In (pcs) |  | Out (pcs) |  | Balance | Status |  |  | No | Date |  | In (pcs) |  | Out (pcs) |  | Balance | Status |  |  | No | Date |  | In (pcs) |  | Out (pcs) |  | Balance | Status
 |  |  | Received | Deliverery | Part No | Qty | Deliver no | Qty |  |  |  |  |  | Received | Deliverery | Part No | Qty | Deliver no | Qty |  |  |  |  |  | Received | Deliverery | Part No | Qty | Deliver no | Qty
 |  | 1 | 2012-09-10 00:00:00 | 2012-09-11 00:00:00 | 12345 | 4 | 678 | 2 |  | Pending |  |  | 1 | 2012-09-07 00:00:00 | 2012-09-08 00:00:00 | 5678 | 2 | 678 | 2 |  | Complete |  |  | 1 | 2012-09-04 00:00:00 | 2012-09-05 00:00:00 | 987 | 3 | 123 | 2 |  | Complete
 |  | 2 |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  | 2 |  | 2012-09-06 00:00:00 |  |  | 123(1) | 1
 |  | 3 |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  | 3
 |  | 4 |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  | 4
 |  | 5 |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  | 5
 |  | Total |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  |  |  |  | Total
 |  | 1 | 2012-09-12 00:00:00 | 2012-09-13 00:00:00 | 123 | 1 | 567 | 1 |  | Complete |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 1 | 2012-09-05 00:00:00 | 2012-09-06 00:00:00 | 7654 | 5 | 234 | 3 |  | Deliver
 |  | 2 |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  | Pending
 |  | 3 |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  | 3
 |  | 4 |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  | 4
 |  | 5 |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  | 5
 |  | Total |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  |  |  |  | Total
 |  | 1 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 1 | 2012-09-11 00:00:00 | 2012-09-12 00:00:00 | 2567 | 1 | 345 | 1 |  | Complete
 |  | 2 |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  | 2
 |  | 3 |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  | 3
 |  | 4 |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  | 4
 |  | 5 |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  | 5
 |  | Total |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  |  |  |  | Total
Spreadsheet: daren_farmer__6672__egmnom-May
Sheet: EGM 60

 | Nomination Change
 | ATTN: Transportation Specialist
HOUSTON PIPE LINE COMPANY
HPL Contract # |  | 012-27106-02-010
Shipper: | Entex Gas Marketing | Effective Dates:
Nominator: | Troy Benoit | Start:
Telephone: | (713)207-3376 | 2000-05-01 00:00:00
Fax: | (713)207-0054 | Stop:
 |  | 2000-05-31 00:00:00
RECEIPTS |  |  | May | May | May | May | May | May
METER # | [NAME] | SUPPLIER | 1
644 | LONE STAR KATY 27,600 1934; 2400 | DUKE
644 | LONE STAR KATY | RICHARDSON
4132 | EXXON KATY - MIDCON 92155 | AQUILLA | 0 | 0 | 0 | 0 | 0 | 4000
4132 | EXXON KATY 101566 | [NAME] | 4000 | 4000 | 4000 | 4000 | 4000 | 4000
4132 | EXXON KATY Brazos | Mitchell | 5000 | 5000 | 5000 | 5000 | 5000 | 5000
4132 | EXXON KATY | Amoco
6780 | Oasis [NAME] | Tenaska
XXXX | IMBALANCE | ENTEX/HPL
 |  | RECEIPT TOTAL
DELIVERIES
METER # | [NAME] | MARKET
72 | [NAME]
713 | Georgia Gulf Pasadena
1019 | [NAME]
1031 | Exxon Baytown
1057 | Reynolds Metal
1060 | Shell Deer Park
1063 | [NAME] Deer Park
1188 | [NAME]
1281 | Air Products La Port
1306 | [NAME] Park
1373 | [NAME] | MORGAN STANLEY
1394 | HILL PETRO | DYNEGY
1418 | Air Products Pasadena
1444 | [NAME]
1485 | OXY BATTLEGROUND | OXY | 15000 | 15000 | 15000 | 15000 | 15000 | 15000
1505 | DEER PARK | DUPONT
1506 | RHOM & HAAS DEER PARK | RHOM & HAAS
1511 | Port Arthur - Clark | [NAME]
1563 | COGEN | DYNEGY
8001 | AIR LIQUIDE Bayport Big 3 | AIR LIQUIDE
8020 | Petro Lite Pasadena
XXXX | IMBALANCE | ENTEX/HPL
 |  | DELIVERY TOTAL
Spreadsheet: 856241d1705563336-date-challenge-transform-effective-date-range-to-day-time-series-date-challenge-transform-to-time-series2
Sheet: Source Data

Source data:
Dep time | Arr time | Day | Effective | Elapsed Time | Flight No
18-30 | 20-30 | 5 | 16.04-29.10 | 02-00 | AB-352
07-40 | 09-20 | 1346 | 01.04-26.10 | 2024-10-02 00:00:00 | CD-982
Maximum effective date range:
01.03-31.10
Spreadsheet: 67393d1268046340-excel-2007-can-you-have-more-than-1-number-in-a-cell-and-still-have-formulas-work-dummy
Sheet: Sheet1

PRODUCT CODE | PRODUCT DESCRIPTION | QTY PER PACK/BOX | CURRENT STOCK LEVEL | COST PRICE (£) | RETAIL PRICE (£) | QUANTITY SOLD | TOTAL PROFIT (£)
40001 | Rotadex Steel Bookends | 2 |  |  | 6.99
40002 | Strong Metal Bookends | 2 |  |  | 7.99
40003 | Stackable Letter Trays | 1 |  |  | 1.59
40003A | Stackable Letter Trays | 6 |  |  | 7.74
40004 | Avery Standard Letter Trays | 1 |  |  | 1.59
40005 | Extendable Letter Trays | 1 |  |  | 19.99
Spreadsheet: 220710d1363244293-adding-rows-automatically-in-two-separate-worksheets-examplev17
Sheet: Liabilities

Liabilities
Non-current liabilities
Debt | 21610
Loan | 51950
Current liabilities
Trade payables | 5196
Payable taxes | 1165 | 5566 | 1991 | 2955 | 6510 | 2955
Payable salary | 2982 | 5566 | 1991 | 1955 | 6510 | 2955
Spreadsheet: 0bcd5ad7-934f-4994-970e-0b8702bcabb7
Sheet: 11b

Product | EUR** | GBP | [NAME] | USD | TOTAL
Basis* | <100 | 234 | 172 | 222 | 628
FRA | 4358 | 1162 |  | 2800 | 8320
IRS- [NAME] | 9888 | 2412 | 4042 | 14011 | 30353
OIS | 698 | 202 |  | 206 | 1106
VNS |  |  |  | <100 | <100
Zero Coupon | <100 | <100 |  | <100 | <100
TOTAL | 14944 | 4010 | 4214 | 17239 | 40407
Estimated swap transaction volumes, week ending May 24, by product type and supermajor currency (number of trades), all participant types, cleared and uncleared.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Data Dictionary for supermajor currency descriptions.
***N/A indicates that data are not currently available.
Note: Transaction volumes currently include house and client trades by FCMs in the interest rate asset class.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 85f9edeb-7446-4bab-b027-a64808689988
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
PARV | Test | PARV | Parvovirus B19 Antibodies, IgG and IgM, Serum | Parvovirus [NAME], IgG and IgM, S | Enzyme Immunoassay (EIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | IgG: <0.9 IgM: <0.9 | Monday through Saturday; 11 a.m. | Same day/1 day | 2 days |  | Profile |  |  |  |  | Rochester
PARV | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
PARV | Component | PAIG | Parvovirus B19 Antibodies, IgG, Serum | Parvovirus [NAME], IgG, S | Only orderable as part of a profile. For further information see PARV / Parvovirus B19 Antibodies, IgG and IgM, Serum. |  |  |  |  |  | Only orderable as part of a profile. For further information see PARV / Parvovirus B19 Antibodies, IgG and IgM, Serum. |  |  | Only orderable as part of a profile. For further information see PARV / Parvovirus B19 Antibodies, IgG and IgM, Serum. |  |  |  | 1 | 86747 |  |  | Yes | No
PAIG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
PAIG | Result | PAIG | Parvovirus [NAME], IgG, S | Parvovirus [NAME], IgG, S | Numeric |  |  |  |  | index |  |  |  |  |  |  |  |  |  | 7983-0 | Parvovirus B19 Ab.IgG:ACnc:Pt:Ser:Qn:
PARV | Component | PAIM | Parvovirus B19 Antibodies, IgM, Serum | Parvovirus B19 Ab, IgM, S | Only orderable as part of a profile. For further information see PARV / Parvovirus B19 Antibodies, IgG and IgM, Serum. | Serum Gel Tube: SGT |  |  | 0.5 | mL | Only orderable as part of a profile. For further information see PARV / Parvovirus B19 Antibodies, IgG and IgM, Serum. |  |  | Only orderable as part of a profile. For further information see PARV / Parvovirus B19 Antibodies, IgG and IgM, Serum. |  |  |  | 1 | 86747 |  |  | Yes | No
PAIM | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
PAIM | Result | PAIMS | Parvovirus B19 Ab, IgM, S | Parvovirus B19 Ab, IgM, S | Numeric |  |  |  |  | index |  |  |  |  |  |  |  |  |  | 7984-8 | Parvovirus B19 Ab.IgM:ACnc:Pt:Ser:Qn:
PAIM | Result | INT20 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59464-8
Spreadsheet: 850324d1700680413-conditional-formatting-formula-based-on-multiple-criteria-sample-workbook
Sheet: PostB

[NAME] | Year | Status | Training | Start Date
10015 | 2010-2011 | In Progress | ASD 403123 | 2010-09-20 00:00:00
10015 | 2010-2011 | In Progress | FortitudeX989 | 2011-02-22 00:00:00
10015 | 2011-2012 | In Progress | ASD 403124 | 2011-04-22 00:00:00
10015 | 2013-2014 | In Progress | ASD 403124 | 2013-08-01 00:00:00
10015 | 2013-2014 | Completed | ASD 403123 | 2013-11-01 00:00:00
10018 |  | Required to Discontinue | ADD 42 | 2014-10-01 00:00:00
10022 |  | In Progress | ASD 403939 | 2015-10-01 00:00:00
10022 |  | In Progress | ADD 40 | 2016-09-01 00:00:00
10089 | 2023-2024 | In Progress | ADD 40 | 2016-09-01 00:00:00
10101 | 2010-2011 | In Progress | FortitudeX989 | 2011-02-22 00:00:00
10101 | 2022-2023 | In Progress | ASD 403124 | 2011-04-22 00:00:00
… | … | … | … | …
Desired Result: | Highlight rows that meet the below objective as in sample table above
Objective: | Include conditional formatting formula to highlight rows containing Mechanic IDs having "in progress" status in their most recent year (registration date) except do not highlight if the yaer in progress is the current year (i.e., max year, 2023-2024(
Note: Data (20,000 rows) is sorted in order of priority as follows:
[NAME]
Year
Start Date
Spreadsheet: 199325d1355177155-compare-match-and-sort-multi-columns-sort
Sheet: Sheet1

Data |  |  |  |  |  |  | Sorted
1 | 2 | 3 | 4 | 5 |  |  | 1 | 2 | 3 | 4 | 5
2222 | 4444 | 1111 | 3333 | 2222 |  | 1111
7777 | 8888 | 5555 | 7777 | 9999 |  | 2222
1111 | 1111 |  |  |  |  | 3333
3333 |  |  |  |  |  | 4444
8888 |  |  |  |  |  | 5555
 |  |  |  |  |  | 6666
 |  |  |  |  |  | 7777
 |  |  |  |  |  | 8888
 |  |  |  |  |  | 9999