tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 160264d1339019682-difficult-transposing-issue-example
Sheet: Sheet1

CUST# | DUP# | PRICE | CUST#E | PRICE1 | PRICE2 | PRICE3 | PRICE4 | PRICE5 | PRICE6 | COUNT | TOTAL
55551 | 1 | 100 | 55551 |  |  |  |  |  |  | 0 | 0
55552 | 1 | 50 | 55552 |  |  |  |  |  |  | 0 | 0
55552 | 2 | 25 | 55553 |  |  |  |  |  |  | 0 | 0
55553 | 1 | 200 | 55554 |  |  |  |  |  |  | 0 | 0
55554 | 1 | 35 | 55555 |  |  |  |  |  |  | 0 | 0
55555 | 1 | 655 | 55556 |  |  |  |  |  |  | 0 | 0
55555 | 2 | 51 | 55557 |  |  |  |  |  |  | 0 | 0
55555 | 3 | 894 | #N/A |  |  |  |  |  |  | 0 | 0
55555 | 4 | 156 | #N/A |  |  |  |  |  |  | 0 | 0
55556 | 1 | 489 | #N/A |  |  |  |  |  |  | 0 | 0
55556 | 2 | 12 | #N/A |  |  |  |  |  |  | 0 | 0
55557 | 1 | 6 | #N/A |  |  |  |  |  |  | 0 | 0
55557 | 2 | 489 | #N/A |  |  |  |  |  |  | 0 | 0
55557 | 3 | 123 | #N/A |  |  |  |  |  |  | 0 | 0
55557 | 4 | 36 | #N/A |  |  |  |  |  |  | 0 | 0
55557 | 5 | 48 | #N/A |  |  |  |  |  |  | 0 | 0
55557 | 6 | 89 | #N/A |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
Spreadsheet: 708023d1607589493-how-to-report-the-top-20-and-bottom-20-of-a-data-table-report-with-2-conditions-dashboard
Sheet: GNI per capita

Country | GNI per capita (current US$) | Level |  | GNI per capita
FRANCE | 42400 |  |  | Low income | 792
SPAIN | 30390 |  |  | Middle income | 5598
PORTUGAL | 23080 |  |  | High income | 45307
ITALY | 34460
GERMANY | 48250
USA | 65760
AUSTRALIA | 54910
NEW-ZEALAND | 42670
DENMARK | 63240
BRAZIL | 9130
POLAND | 15200
ALGERIA | 3970
MOROCCO | 3190
UK | 42370
CANADA | 46370
RUSSIA | 11260
Spreadsheet: 750098d1633262284-finding-and-locating-discrepancies-using-formula-new
Sheet: Sheet1

Item Code | Name | Inv. Qty | Actual Count | Discrepancy |  | No. Of Discrepancies | Locate
1 | A | 10 | 9 |  |  |  |  | >>> | Use "HYPERLINK" function
2 | B | 20 | 20
3 | C | 30 | 30
4 | D | 40 | 38
5 | E | 50 | 50
6 | F | 60 | 60
7 | G | 70 | 70
8 | H | 80 | 75
9 | I | 90 | 86
10 | J | 100 | 98
Spreadsheet: 145878d1331794236-transfer-data-from-one-sheet-to-another-when-specific-value-entered-in-first-sheet-example_2012_file-1-
Sheet: Nov

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 | 2012-11-30 00:00:00 | 2012-12-01 00:00:00 | Hones, [NAME] | 113012-01 | 100 | 114 | Regular | 0.85 |  |  |  | 123456 | 2012-12-15 00:00:00 |  |  |  |  |  |  | Jeanne
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Karisa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 333d7f91-4ce1-4fd6-b4e1-4217aca94d0e
Sheet: Exhibit A - Year 2

Section L - Attachment 7 - Price Schedule
DE-SOL-0003816
Option Year 1 (February 1, 2014 - January 31, 2015)
Total Contract
 | DPLH |  |  | Labor |  |  | Direct Labor Costs |  |  | Fringe Benefits |  |  | [NAME] |  |  | Onsite Overhead |  |  | Onsite | Total Costs
Cost Element |  |  |  | Straight | Over | Double | Straight | Over | Double |  |  |  |  |  |  |  |  |  | Overhead
 | Straight | Over | Double | Time | Time | Time | Time | Time | Time | Straight | Over | Double | Straight | Over | Double | Straight | Over | Double |  | Straight | Over | Double | Total
 | Time | Time | Time | Rate | Rate | Rate | Costs | Costs | Costs | Time | Time | Time | Time | Time | Time | Time | Time | Time | Rate | Time | Time | Time | Costs
Cost Plus Fixed Fee (CPFF) Tasks
**Prime Contractor Labor
Bargaining Employee:
Mechanic | 3630 | 100 | 60 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Mobile Crane Inspector | 120
Laborer | 5625 | 150 | 90
Heavy Equipment Operator | 5625 | 150 | 90
Truck Driver | 5625 | 150 | 90
(Itemize each additional position)
Non-Bargaining Employees:
Program Manager | 1775 | 0
Operations & Maintenance Manager | 1775 | 0
Administrative Support | 1775
Shop Manager | 1775 | 0
Supply Technician | 1775 | 20
Construction Technician | 0 | 0 | 0
(Itemize each additional position)
Subtotal (Provide Subtotals for Each) |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Subcontractor Labor (If Applicable)
(Itemize for Each Position)
Subtotal (Provide Subtotals for Each) | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Subtotal CPFF Labor Related Costs | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  |  |  |  | 0
Other Direct Costs:
Material |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500000
Construction |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500000
Subtotal CPFF Costs | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  |  |  |  | 0
G&A (Identify G&A Rate)
Total CPFF Proposed Costs
Reserve Fee
Total  Proposed CPFF Fee
Total [NAME] | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  |  |  |  | 0
A 3% increase to be added to all labor for the following options.  (All hours and material/subcontracts remain the same)
*Note:  Fuel - Contractor shall not charge in excess of $.10 per gallon surcharge for sold fuel applicable to reservation activities.  No additional G&A, handling fee, or other direct or indirect charges will apply to this cost.
**The labor categories and hours may be adjusted at the discretion of the offeror in order to comply with the offeror's position in meeting the requirements of the solicitation.
Spreadsheet: 0bcd5ad7-934f-4994-970e-0b8702bcabb7
Sheet: 5

 | Apr 26 | May 3 | May 10 | May 17 | May 24
Total Interest Rate | 84500 | 84500 | 84500 | 84500 | 84500
Cleared** | N/A*** | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | 3500 | 3500 | 3500 | 3500 | 3500
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Credit | 105000 | 105000 | 105000 | 105000 | 105000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equity | 25000 | 25000 | 25000 | 25000 | 25000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | 105000 | 105000 | 105000 | 105000 | 105000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | 323000 | 323000 | 323000 | 323000 | 323000
Weekly total, estimated swap event volumes by asset class and cleared status (in number of events), all products, tenors, and participant types.
Estimates of weekly event volumes are derived from data published in the 2012 ISDA Operations Benchmarking Survey, which defines an "event" as a new trade, confirmable amendment, partial or full termination, increase, decrease, or novation.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 885401d1734951619-pivot-table-issue-resend-log-copyv3
Sheet: Sheet3

Sku / Product Items | (All)
Month | (All)
Row Labels | Sum of Value of resent products £
Carrier Damaged | 60219.42000000004
[NAME] | 19028.24
Incorrect Item Received | 25559.147
[NAME] from Order | 11812.86999999998
Lost in Transit | 21852.58999999999
Order processed but not shipped | 29144.56000000001
Other (please add to comments) | 8968.68
Product Issue - Colour Match | 8827.059999999994
Product Issue - Damaged | 4666.469999999998
Product Issue - Fault | 5091.069999999999
was not sent out | 287.96
(blank)
Customer Service Issue | 365.98
Customer Error | 2427.72
Damage | 179.98
Grand Total | 198431.747
Sku / Product Items | (All)
Reason for Resend | (All)
Row Labels | Sum of Value of resent products £ | Count of Orders
May | 12861.05999999999 | 65
Grand Total | 12861.05999999999 | 65
Sku / Product Items | (All)
Week | 28
Reason for Resend | Sum of Value of resent products £ | Count of Orders
Carrier Damaged | 373.95 | 3
[NAME] | 213.75 | 1
Incorrect Item Received | 35.97 | 2
Order processed but not shipped | 204 | 1
Grand Total | 827.6700000000001 | 7
Sku / Product Items | (All)
Reason for Resend | [NAME] from Order
Row Labels | Sum of Value of resent products £ | Count of Orders
Jan | 301.45 | 3
Feb | 69.94 | 2
May | 944.26 | 9
Grand Total | 1315.65 | 14
Row Labels | Sum of Value of resent products £
[NAME] | 31205.64
DHL | 0
Royal Mail | 21.94
UPS | 39.98
(blank) | 121050.5870000003
Parcel Force | 6690.229999999997
Parcel Force | 189.98
Royal Mail | 2.99
Grand Total | 159201.3470000003
Spreadsheet: 810358d1671715781-take-and-last-dates-by-group-date-by-rev-etaf
Sheet: POData

PONUM | Order Date | PartNum | RevisionNum
55564 | 2022-07-25 00:00:00 | 100-101-039 | PJ01SB
55650 | 2022-09-15 00:00:00 | 100-101-041 | ZF01JA
55653 | 2023-09-16 00:00:00 | 100-101-058 | EU02SE
55671 | 2022-09-26 00:00:00 | 100-101-039 | PJ02SB
55715 | 2022-10-07 00:00:00 | 100-101-058 | EU03SE
55726 | 2022-10-12 00:00:00 | 100-101-058 | EU04SE
55779 | 2022-11-11 00:00:00 | 100-101-058 | EU05SE
55801 | 2022-11-15 00:00:00 | 100-101-058 | EU06SE
55845 | 2022-12-21 00:00:00 | 100-101-041 | ZF0JA
Spreadsheet: louise_kitchen__22829__Headct Reconcile_020102
Sheet: Sum with Desk Chgs

Desk | # Budgeted | # Signed | # Verbal | # Open | Offers Signed or [NAME]
Texas Gas Trading | 4 | 3 | 0 | 0
West Gas Trading | 9 | 10 | 0 | 0
Gas Outsourcing | 3 | 0 | 0 | 1
West Gas Origination | 5 | 4 | 0 | 0
Ercot Power Trading | 4 | 3 | 0 | 0
Northeast Power Trading | 6 | 4 | 0 | 1
Southeast Power Trading | 3 | 2 | 0 | 0
East Options Trading | 3 | 2 | 0 | 0
Southeast Power Origination - Robinson | 4 | 3 | 0 | 0
Southwest Power Trading | 3 | 0 | 0 | 0
Southwest Power Origination | 2 | 3 | 0 | 0
Northwest Power Origination | 3 | 4 | 0 | 0
Western Canada Gas and Power Origination | 8 | 6 | 0 | 1
Eastern Canada Gas and Power Trading | 2 | 0 | 0 | 3
Operations Management | 0 | 2 | 0 | 0
Gas Risk Management | 25 | 24 | 0 | 0
Gas Logistics | 25 | 23 | 1 | 0
Gas Settlements | 6 | 7 | 0 | 0
Power Volume Management | 8 | 7 | 0 | 0
Power Logistics | 14 | 11 | 0 | 0
Documentation and Databases | 23 | 22 | 0 | 0
Power Real Time | 19 | 18 | 0 | 0
IT Development, Operations, and [NAME] | 117 | 124 | 0 | 1
Accounting and Transaction Support | 36 | 36 | 0 | 1
Cash Operations | 3 | 4 | 0 | 0
Regulatory Affairs | 8 | 4 | 0 | 1
Structuring | 3 | 0 | 0 | 2
Weather | 5 | 1 | 0 | 1
Market Risk | 3 | 1 | 1 | 0
Research | 2 | 3 | 0 | 0
Legal | 18 | 18 | 1 | 0
Canada Support | 30 | 27 | 0 | 1
TOTALS
Spreadsheet: 776350d1649692425-irrigation-schedule-start-and-end-times-irrigation-schedule
Sheet: Sheet1

 | Irrigation Schedule
 |  |  |  |  |  |  |  | Zones  >>>
 | Zone Delay |  | Schedules | Day 1 | Day 2 | Day 3 | Day 4 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
 | 45 Minutes |  | 1 | Monday |  |  |  | x | x | x | x | x | x | x | x | x |  | x | x | x
 |  |  | 2
 | End Time |  | 3
 | 07:00:00 |  | 4
 |  |  | 5
 |  |  |  |  |  |  |  |  |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday
 |  |  |  |  |  |  | Description | Zones | Run Time | Start Time | End Time | Start Time | End Time | Start Time | End Time | Start Time | End Time | Start Time | End Time | Start Time | End Time | Start Time | End Time
 |  |  |  |  |  |  | Lawn | 1 | 30
 |  |  |  |  |  |  | Lawn | 2 | 30
 |  |  |  |  |  |  | Lawn | 3 | 30
 |  |  |  |  |  |  | Lawn | 4 | 30
 |  |  |  |  |  |  | Lawn | 5 | 30
 |  |  |  |  |  |  | Lawn | 6 | 30
 |  |  |  |  |  |  | Lawn | 7 | 30
 |  |  |  |  |  |  | Lawn | 8 | 30
 |  |  |  |  |  |  | Lawn | 9 | 30
 |  |  |  |  |  |  | Shrubs | 10 | 30
 |  |  |  |  |  |  | Lawn | 11 | 30
 |  |  |  |  |  |  | Lawn | 12 | 30
 |  |  |  |  |  |  | Lawn | 13 | 30
 |  |  |  |  |  |  | Roses | 14 | 30
 |  |  |  |  |  |  | Fruit Trees | 15
 |  |  |  |  |  |  | Garden | 16 | 30
Spreadsheet: 852119d1702215987-excel-formula-to-extract-data-from-salary-sheet-to-payslip-match-payslip-4-
Sheet: Payslip

 | Kindly asking for excel formula to extract data on the salary sheet to the Payslip sheet as
 | shown below. Where there is no amount the formula should leave out the naration e.g. Pension
 | on Doroth salary there is zero and pension is not included in the payslip. Thank you.
 | NB Select month and Employee name from the drop down list
 | Desired solution
 | PAYSLIP
 | 2023-12-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | January
 |  |  |  |  |  |  |  |  |  |  |  |  | February
 | Month | January |  |  |  |  |  |  |  |  |  |  | March
 |  |  |  |  |  |  |  |  |  |  |  |  | April
 |  |  |  |  |  |  |  |  |  |  |  |  | May
 | Employee Name | Thums |  |  |  |  |  |  |  |  |  |  | June
 |  |  |  |  |  |  |  |  |  |  |  |  | July
 |  |  |  |  |  |  |  |  |  |  |  |  | August
 | Eearnings | USD | ZWL |  |  | Deductions | USD | ZWL |  |  |  |  | September
 |  | 100 | 450000 |  |  |  | 0 |  |  |  |  |  | October
 | Over time |  | 0 |  |  | NEC | 0 |  |  |  |  |  | November
 | Benefits |  | 0 |  |  | PAYE | 8.745435757078383 | 39354.46090685273 |  |  |  |  | December
 | Bonus |  | 0 |  |  | Aids Levy | 0.2623630727123515 | 1180.633827205582
 |  |  |  |  |  | Net Pay | 90.99220117020927 | 409464.9052659417
 | Total |  |  |  |  | Total
Spreadsheet: 687586d1595297455-populate-a-cell-based-on-values-example-
Sheet: Shop 1 

Fuji
 | S | 36
 | M | 38
 | L | 38
Gala
 | S | 40
 | M | 40
 | L | 40
Gold Del
 | S
 | M
 | L
Granny
 | S | 32
 | M | 32
 | L | 32
Spreadsheet: 08309c3a-e586-405e-bb2d-a80c26a2801e
Sheet: 6Replace Costs - Results 1-5

Table 5.2.53.  Replacement Costs (Years 1 to 5)
 |  |  |  | EPA Discount Rate:
 |  |  |  | Present Value of Replacement Costs in Year:
Component | Unit Cost | Unit | Quantity | 1 | 2 | 3 | 4 | 5
 |  |  | Total Present Value of Replacement Costs (Years 1 to 5):
Spreadsheet: 213631d1360598302-i-would-like-to-click-once-on-a-cell-ordering-automation
Sheet: Sheet1

 |  |  |  |  |  | [NAME]
 | Item | # on Hand | [NAME] | Min Stock |  | Current Order | Units Neded
Spreadsheet: 858369d1707088527-how-to-remove-blank-rows-when-formula-spills-unique-count-sample
Sheet: Sheet1

Name |  |  |  |  |  |  | Name | Yes | No |  |  |  |  |  |  |  | [NAME]
[NAME] | yes |  |  |  |  |  |  | 2 | 0 |  |  |  |  |  |  |  | [NAME]
[NAME] | yes |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME] | 0 | 2 |  |  |  |  |  |  |  | [NAME]
[NAME] |  | no |  |  |  |  | Julian | 2 | 0 |  |  |  |  |  |  |  | Julian
Julian | yes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  | no |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Julian | yes
Spreadsheet: 7f06a627-bfef-454b-9923-d09a27d26b40
Sheet: Sheet1

MCPI--Implementation Grant Review Work Group | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | NAME |  | AFFILIATION | [NAME]
1 | [NAME] | Cary-Kothera | NOAA Coastal Services Center | Charleston, SC
2 | [NAME] | Connors | State Planning Office, Coastal Program | Augusta, ME
3 | [NAME] | Owsley | Land Trust Alliance | Topsham, ME
4 | Danielle | [NAME] | NOAA Coastal Services Center | Charleston, SC
5 | [NAME] | Shore | Maine Coast Heritage Trust | Topsham, ME
 | Tin | Smith | Wells NERRS | Wells, ME
6 | [NAME] | Winter | U.S. Fish and Wildlife Service | Falmouth, ME
Spreadsheet: 74387d1274901123-find-sum-with-multiple-criteria-ranges-example-1-
Sheet: Sheet1

 |  | %,[NAME],[NAME],FACCOUNTING_PERIOD,B | %,[NAME],[NAME],FACCOUNT,B | %,[NAME],[NAME],FMONETARY_AMOUNT,B |  | %,[NAME],[NAME],FBUDGET_REF,B
 | I want find sum of the Monetary Amounts for each account by month (October = 1, November =2, etc)
 |  | October (Period 1) | November Period 2 | December Period 3
 | Expense:
 | Reg Staff Payroll (5121) | 5 | 7 | 10
 | FL-Staff (5123) | 1 | 2 | 3
 | Benefits (5129) | 7 | 7 | 11
 | Operation (5200-6500)
 | Total Expense: | 13 | 16 | 24 | 1
 |  |  |  |  | 6500
%,OH | Period | Acct | Monetary Amount
%,OA | 1 | 5351 | 1
 | 1 | 5129 | 1
 | 1 | 5129 | 1
 | 1 | 5129 | 1
 | 1 | 5121 | 1
 | 1 | 5121 | 1
 | 1 | 5129 | 1
 | 1 | 6500 | 1
 | 1 | 5121 | 1
 | 1 | 5123 | 1
 | 1 | 5129 | 1
 | 1 | 5121 | 1
 | 1 | 5129 | 1
 | 1 | 5250 | 1
 | 1 | 5250 | 1
 | 1 | 5121 | 1
 | 1 | 5129 | 1
 | 1 | 5338 | 1
 | 1 | 5334 | 1
 | 1 | 5351 | 1
 | 1 | 4458 | 1
 | 1 | 5365 | 1
 | 2 | 5121 | 1
 | 2 | 5121 | 1
 | 2 | 5121 | 1
 | 2 | 5121 | 1
 | 2 | 5129 | 1
 | 2 | 5129 | 1
 | 2 | 5129 | 1
 | 2 | 5129 | 1
 | 2 | 5371 | 1
 | 2 | 5333 | 1
 | 2 | 5250 | 1
 | 2 | 5123 | 1
 | 2 | 5123 | 1
 | 2 | 5129 | 1
 | 2 | 5129 | 1
 | 2 | 5121 | 1
 | 2 | 5121 | 1
 | 2 | 5121 | 1
 | 2 | 5129 | 1
 | 2 | 5213 | 1
 | 2 | 5338 | 1
 | 2 | 5334 | 1
 | 2 | 5365 | 1
 | 2 | 5351 | 1
 | 2 | 5351 | 1
 | 2 | 4458 | 1
 | 2 | 4458 | 1
 | 3 | 5121 | 1
 | 3 | 5121 | 1
 | 3 | 5121 | 1
 | 3 | 5121 | 1
 | 3 | 5129 | 1
 | 3 | 5129 | 1
 | 3 | 5129 | 1
 | 3 | 5129 | 1
 | 3 | 5371 | 1
 | 3 | 5333 | 1
 | 3 | 5129 | 1
 | 3 | 5129 | 1
 | 3 | 5129 | 1
 | 3 | 5129 | 1
 | 3 | 5121 | 1
 | 3 | 5121 | 1
 | 3 | 5121 | 1
 | 3 | 5250 | 1
 | 3 | 5371 | 1
 | 3 | 5129 | 1
 | 3 | 5129 | 1
 | 3 | 5129 | 1
 | 3 | 5123 | 1
 | 3 | 5121 | 1
 | 3 | 5121 | 1
 | 3 | 5121 | 1
 | 3 | 5123 | 1
 | 3 | 5123 | 1
 | 3 | 5334 | 1
 | 3 | 5338 | 1
 | 3 | 5351 | 1
 | 3 | 5351 | 1
 | 3 | 6431 | 1
 | 3 | 4458 | 1
 | 3 | 4458 | 1
 | 4 | 5333 | 1
 | 4 | 5129 | 1
 | 4 | 5129 | 1
 | 4 | 5121 | 1
 | 4 | 5129 | 1
 | 4 | 5121 | 1
 | 4 | 5129 | 1
 | 4 | 5121 | 1
 | 4 | 5121 | 1
 | 5 | 5121 | 1
 | 5 | 5121 | 1
 | 5 | 5121 | 1
 | 5 | 5121 | 1
 | 5 | 5129 | 1
 | 5 | 5129 | 1
 | 5 | 5129 | 1
 | 5 | 5129 | 1
 | 5 | 5129 | 1
 | 5 | 5371 | 1
 | 5 | 5121 | 1
 | 5 | 5121 | 1
 | 5 | 5121 | 1
 | 5 | 5129 | 1
 | 5 | 5121 | 1
 | 5 | 5129 | 1
 | 5 | 5129 | 1
 | 5 | 5129 | 1
 | 5 | 5129 | 1
 | 6 | 5129 | 1
 | 6 | 5333 | 1
 | 6 | 5333 | 1
 | 6 | 5371 | 1
 | 6 | 5129 | 1
 | 6 | 5129 | 1
 | 6 | 5129 | 1
 | 6 | 5129 | 1
 | 6 | 5121 | 1
 | 6 | 5121 | 1
 | 6 | 5121 | 1
 | 6 | 5121 | 1
 | 6 | 5121 | 1
 | 6 | 5129 | 1
 | 6 | 5351 | 1
 | 6 | 5351 | 1
 | 6 | 5334 | 1
 | 6 | 5338 | 1
 | 6 | 5365 | 1
 | 6 | 5213 | 1
 | 6 | 4458 | 1
 | 6 | 4458 | 1
 | 6 | 5129 | 1
 | 6 | 5121 | 1
 | 7 | 5129 | 1
 | 7 | 5121 | 1
 | 7 | 5121 | 1
 | 7 | 5121 | 1
 | 7 | 5129 | 1
 | 7 | 5121 | 1
 | 7 | 5129 | 1
 | 7 | 5129 | 1
 | 7 | 5351 | 1
 | 7 | 5351 | 1
 | 7 | 4458 | 1
 | 7 | 4458 | 1
 | 8 | 5121 | 1
 | 8 | 5121 | 1
 | 8 | 5129 | 1
 | 8 | 5129 | 1
 | 8 | 5129 | 1
 | 8 | 5129 | 1
 | 8 | 5129 | 1
Spreadsheet: 723657d1615822989-if-isnumber-formula-update-cells-with-character-depending-on-dates-actygation-holiday-forms-2021
Sheet: Colleague 2

HOLIDAY FORM 2021
NAME: |  |  |  | 2021 BANK HOLIDAY DATES | TAKEN Y/N (IF NO ADD LIEU DAY TO TABLE)
2021 HOLIDAY ENTITLEMENT |  |  |  | 01/01/2021 (New Years Day) | Y
To be completed - |  |  |  | 02/04/2021 (Good Friday) | N
2021 ENTITLEMENT |  | 25 |  | 05/04/2021 (Easter Monday) | N
CARRIED OVER FROM 2020 |  | 4 |  | 03/05/2021 (May Bank Hol) | N
LIEU DAYS |  | 0 |  | 31/05/2021 (May Bank Hol) | N
BOUGHT HOLIDAYS FOR 2021 |  | 0 |  | 30/08/2021 (Aug Bank Hol) | N
OTHER ENTITLEMENT (PLEASE ADD DETAILS) |  | 0 |  | 27/12/2021 (Xmas Day) | N
Reason: |  |  |  | 28/12/2021 (Xmas BH Day) | N
TOTAL FOR 2021:
HOLIDAY BOOKING PROCESS
1) | Send a request for holiday dates to your line manager
2) | Once approval is gained, issue a meeting invite to your line manager and direct team so they are aware of holiday dates
2) | Update this holiday form yourself and re-save on the network once approved
FROM | TO | DAYS | DAYS | AUTHORISED | DATE OF APPROVAL
 | (INCLUSIVE) | TAKEN | LEFT | BY
Date (dd/mm/yyyy) | Date (dd/mm/yyyy) | 0 |  | Add line manager name | Add date (dd/mm/yyyy)
Spreadsheet: 77164d1277668285-creating-a-future-reminder-date-and-hiding-it-until-due-excel-forum-cf-due-dates
Sheet: Sheet1

Date | Name | Qualification | Date Awarded | [NAME] | Alerts
2010-06-27 20:45:46 | [NAME] | Plumbing | 2009-03-13 00:00:00 | 2010-07-13 00:00:00 | Renewal Due by 13th July 10 | Renewal Due by 13 July 10 | << CF applied to this as white text until 18 days before due
2010-06-27 20:45:46 | [NAME] | Driving Licence | 2010-04-02 00:00:00 | 2010-07-02 00:00:00 | Renewal Due  by  2nd July 10 | Renewal Due by 02 July 10 | << CF applied to this as white text until 18 days before due
2010-06-27 20:45:46 | [NAME] | Pilots licence | 2010-05-04 00:00:00 | 2010-07-04 00:00:00 | Renewal Due by   4th July 2010 | Renewal Due by 04 July 10 | << CF applied to this as white text until 18 days before due
2010-06-27 20:45:46 | [NAME] | medical | 2010-02-22 00:00:00 | 2010-12-22 00:00:00 | 22/12/2010 | Renewal Due by 22 December 10 | << CF applied to this as white text until 18 days before due
OldChippy
Thank you in advance for taking the time to help.
I'm tryng to get Column, 'F' to pickup the dates from column 'E' so it automatically work out the expiry date and gives an alert. If there is an easier way I would appreciate knowing how to do it
Thanks
[NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | internet | to | try | to | get | it | to | work
creating a future reminder date and hiding it until due - Excel Help Forum
Spreadsheet: 66127d1266844262-pulling-info-that-meets-certain-criteria-on-to-another-sheet-super-clean
Sheet: LIST

Equipment Category | Can = for Equipment Type | Can = for CS | Cannot = for  CM | Can ONLY = for CM
VLV | GV | LL | Y
 | NV | V
 | [NAME]
 | Orbit
 | Butterfly
 | [NAME]
 | Globe
PRV | PRV | LL
 |  | V
CON | FLG | LL
 | TEE | V
 | ELB
 | RDCR
 | TC
 | TF
 | UN
 | CK
 | PLG
 | CAP
 | COLLAR
 | BONNET
 | SEAL
PMP | PMP | LL |  | M
CVS | VLV | V
 | CON
 | PRV
Spreadsheet: phillip_m_love__30142__9912_OA
Sheet: TX-CON-GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM) / HPL
REGION:  TEXAS
 |  |  | Total |  | Reclasses |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
FT-South Texas
 |  | Current Month MTM
 |  | Financial Liquidations
 |  | Originations
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL