tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: mary_fischer__25641__111
Sheet: E21.XLS 

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 0111
COMPANY NAME  Pierce Mechanical
LEASE EXPENSE & FUTURE LEASE COMMITMENTS
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-21
+++++INCLUDE all rentals (building, equipment, etc.) regardless of whether it is charged to "rent expense".
+++++EXCLUDE rent allocations from Corporate or other subsidiaries.
Lease Description |  |  |  | Year to Date |  |  |  |  |  | FUTURE LEASE COMMITMENT ( net of sublease , if applicable) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Residual
Property Leased, Term, Lessor |  | *(C) |  | Gross |  | Less: |  | Net Rental |  | 1 Year Ended |  |  |  |  |  |  |  |  |  | 5 Years Ended |  |  |  |  |  | Total Remaining |  | Total |  | Value
*Indicate Capital (C) or Operating (O) Lease |  | or (O) |  | Rentals |  | Subrentals |  | Expense |  | 12-31-2002 |  | 12-31-2003 |  | 12-31-2004 |  | 12-31-2005 |  | 12-31-2006 |  | 12-31-2011 |  | 12-31-2016 |  | 12-31-2021 |  | after 12-31-2021 |  | Commitment |  | Guarantee
Individually list leases w/ an annual rent expense over $1 million.
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other Leases under $1million per year |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-21
Spreadsheet: 681493d1591606386-import-data-from-one-spreadsheet-to-another-example-of-model-codes
Sheet: MFR MODEL CODE

MFR MODEL CODE | MODEL
20901 | AAR AIRLIFT GROUP INC UH-60A
30109 | EXLINE ACE-C ACE-C
003010D | DELEBAUGH P
003010H | DAL PORTO BABY ACE D
003010P | DUNN BABY ACE
003010Z | EMMERT SPECIAL MODIFIED BABY ACE
30115 | HEYER-BARNES BABY ACE
30119 | HILTON ACE A
003011H | FERNANDEZ BABY ACE D
003011J | MATTSON BABY ACE
Spreadsheet: 868820d1715530800-counting-new-record-years-correctly-dividend
Sheet: Sheet1

Dividend | –– | –– | –– | –– | –– | –– | –– | –– | 2.14 | 2.92 | 2.92
Number of years of new high dividend
Spreadsheet: 191b763f-7d2b-4256-936c-ee65b7cdafc2
Sheet: Sheet1

Equality Analysis (EA) [NAME] from January 2012 | Unnamed: 1 | Unnamed: 2 | Directorate Name Environment and Cuture | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Maximum Entries: 209 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
 |  |  |  |  |  |  | Relevant to Equality Duties |  |  |  |  |  |  |  | Action Planning
Service Area/Division | EA Ref. | Responsible Officer & Contact Number | Name of Policy, Strategy or Function  (Title of EA) | Current Status of Policy, Strategy or Function | EA Completion Date | Projected review target date (3 years) | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | Has an Action Plan been created? | Action Plan Progress, Monitoring and Comments Directorate Staff
Bereavement Services/ Leisure & Support Services | ECF&C01 | [NAME]303 0201 | Review of Charges for Bereavement Services | Reviewed | 2012-01-27 00:00:00 | N/A - Initial Screening Only |  |  |  |  |  |  |  |  | No
Bereavement Services/ Leisure & Support Services | ECF&C0212MO | [NAME]              303 0200 | Mortality Contracts F0192 | New | 2012-02-21 00:00:00 | N/A - Initial Screening Only |  |  |  |  |  |  |  |  | No
This Corporate EA Schedule meets the Statutory requirements for publishing EAs
Place your mouse over headings with red corners to see details in comment box or see listing below.
1. Service Area/Division - see page 1 of EA form
2. EA Ref - see page 1 of EA form
3. Responsible Officer  - see page 2 of EA form
4. Name of Policy, Strategy or Function - see page 2 of EA form
5. Current Status - see page 2 of EA form
6. EA Completion Date - see page 1 of EA form
7. This date - 3 year date after completion of EA
8. Relevant to Equality Duties - see page 3 of EA form
9. Action Planning - see page 19 of EA form
Spreadsheet: 760874d1640502815-need-help-with-countif-function-sample
Sheet: Sheet6

Team 1-1 |  |  |  | Team 1-2 |  |  |  | Team 1-3 |  |  |  |  | Position | Days - TW | Evening - TW | In Office | Grand Total
Name | UserID | Position | Shift | Name | UserID | Position | Shift | Name | UserID | Position | Shift |  | Manager-01 | 0 |  | 0
[NAME] (B) | userid1 | Manager-02 | Days - TW | Maki | userid10 | Manager-02 | Days - TW | Giovanni | userid20 | Manager-03 | SL |  | Manager-02 | 2 | 1 | 0
Andi (B) | userid2 | A/L05(P) | Days - TW | [NAME] | userid11 | A/L05(P) | Days - TW | [NAME] | userid21 | L05(P) | Days - TW |  | Manager-03 | 0 | 0 | 1
Dimitra | userid3 | L04(P) | Days - TW | Rupinderjit | userid12 | L03(P) | Days - TW | Eva | userid22 | L03(T) | Days - TW |  | A/L04(P) | 0 | 1 | 0
Destiny | userid4 | L04(P) | Days - TW | Nicole (B) | userid13 | L03(P) | Days - TW | Eve (B) | userid23 | [NAME]) | Days - TW |  | A/L05(P) | 1 | 0 | 0
[NAME] (B) | userid5 | L04(P) | Days - TW |  |  |  |  |  |  |  |  |  | L01(T) | 0 | 1 | 0
Quinn | userid6 | L04(P) | On Loan |  |  |  |  |  |  |  |  |  | [NAME]) | 1 | 0 | 0
[NAME] | userid7 | L04(P) | Days - TW |  |  |  |  |  |  |  |  |  | L03(P) | 2 | 1 | 0
[NAME] | userid8 | L04(P) | Days - TW |  |  |  |  |  |  |  |  |  | L03(T) | 1 | 4 | 0
Alysia | userid9 | L04(P) | Days - TW |  |  |  |  |  |  |  |  |  | L04(P) | 6 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]) | 0 | 1 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | L05(P) | 2 | 0 | 0
Team 2-1 |  |  |  | Team 2-2 |  |  |  | Team 2-3 |  |  |  |  | TOTAL
Name | UserID | Position | Shift | Name | UserID | Position | Shift | Name | UserID | Position | Shift
[NAME] | userid14 | Manager-01 | Evenings - TW | Gummy | userid24 | Manager-02 | Evenings - TW | Grace | user31 | Manager-03 | In Office |  | Status | Days | Night | Grand Total
Phylis | userid15 | L03(T) | Evenings - TW | [NAME] | userid25 | A/L04(P) | Evenings - TW |  |  |  |  |  | Days - TW | 15 | 0
Ayo | userid16 | L03(T) | Evenings - TW | Sweety | userid30 | L01(T) | Evenings - TW |  |  |  |  |  | Evenings - TW | 0 | 10
[NAME] (B) | userid17 | L03(T) | SL | Rhea | userid26 | L03(P) | Evenings - TW |  |  |  |  |  | VL | 0 | 0
Peace | userid18 | L03(T) | Evenings - TW | [NAME] | userid28 | L03(P) | SL |  |  |  |  |  | SL | 1 | 2
Marichu | userid19 | L03(T) | Evenings - TW | Corrine (B) | userid27 | [NAME]) | Evenings - TW |  |  |  |  |  | On Loan | 1 | 1
 |  |  |  | Anna | userid29 | [NAME]) | On Loan |  |  |  |  |  | In Office | 1 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  | Bilingual | 6 | 1
(B) Bilingual
Spreadsheet: bc3f0c91-ae1e-4632-ad0c-556e4211be70
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Wea-Ada | 856658003548 | Worthwhile | Carry On Kid | 2013-08-13 | Compact Disc | Rock | 13.98 | Y | Available
Spreadsheet: 882366d1730735089-ranking-points-for-tied-positions-order-of-merit
Sheet: Leaderboard

 | RANKING | PLAYER | MAJOR | SIGNATURE | OTHER | TOTAL | STABLEFORD BONUS
 | 1 | [NAME]
 | 2 | [NAME]
 | 3 | [NAME]
 | 4 | [NAME]
 | 5 | Justin Derby
 | 6 | [NAME]
 | 7 | [NAME]
 | 8 | [NAME]
 | 9 | [NAME]
 | 10
 | 11
 | 12
Spreadsheet: e6429647-99f7-42ce-99a8-2623d1e337d1
Sheet: September

1
2
3 | National Hummingbird Day | [NAME]
4
5 | Cheese Pizza Day | [NAME]
6 | Read a Book Day | http://www.holidayinsights.com/moreholidays/September/readabook.htm
7
8
9 | Teddy Bear Day | http://www.holidayinsights.com/moreholidays/September/teddybearday.htm
10
11 | Make Your Bed Day | http://www.holidayinsights.com/moreholidays/September/makeyourbedday.htm
12
13
14
15 | Make a Hat Day | http://www.holidayinsights.com/moreholidays/September/makeahatday.htm
16 | National Play-Doh Day | http://www.holidayinsights.com/moreholidays/September/playdohday.htm
17
18
19
20
21 | National Miniature Golf Day | http://www.holidayinsights.com/moreholidays/September/miniaturegolfday.htm
22 | Elephant Appreciation Day | http://www.holidayinsights.com/moreholidays/September/elephantappreciationday.htm
23
24
25 | National Comics Book Day | [NAME]
26 | [NAME] | http://www.holidayinsights.com/moreholidays/March/appleseedday.htm
27
28
29
30
Spreadsheet: 99810d1298385565-how-to-get-a-watermark-with-a-particular-size-font-and-colour-watermark-help
Sheet: Tax-Sheet Replica

 |  |  | Government of India |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ABCDE1234Z
 |  |  | INCOME-TAX DEPARTMENT
 |  |  | ACKNOWLEDGEMENT
 |  |  | Received with thanks from    MR.    SACHIN   RAMESH    TENDULKAR                 a return of income and/or return of fringe benefits in Form No. ITR … for assessment year 2009-10, having the following particulars.
 |  |  | PERSONAL INFORMATION | Name |  |  |  |  |  | PAN
 |  |  |  | Flat/Door/Block No |  |  |  | Name of Premises/Building/Village
 |  |  |  | Road/Street/Post Office |  |  |  | Area/Locality
 |  |  |  | Town/City/District |  |  |  | State |  |  | Status (fill the code)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2
 |  |  |  | Designation of Assessing Officer (Ward/Circle) |  |  |  |  | Original or Revised
 |  |  |  | 1 | Gross Total Income |  |  |  |  | 1
 |  |  | COMPUTATION OF INCOME AND TAX THEREON | 2 | Deductions under Chapter-VI-A |  |  |  |  | 2
 |  |  |  | 3 | Total Income |  |  |  |  | 3
 |  |  |  | 3a | Current Year loss (if any) |  |  |  |  | 3a
 |  |  |  | 4 | Net tax payable |  |  |  |  | 4
 |  |  |  | 5 | Interest payable |  |  |  |  | 5
 |  |  |  | 6 | Total tax and interest payable |  |  |  |  | 6
 |  |  |  | 7 | Taxes paid
 |  |  |  |  | a | Advance Tax | 7a
 |  |  |  |  | b | TDS | 7b
 |  |  |  |  | c | TCS | 7c
 |  |  |  |  | d | Self Assessment Tax | 7d
 |  |  |  |  | e | Total Taxes Paid (7a+7b+7c+7d) |  |  |  | 7e | mistral font
 |  |  |  | 8 | Tax Payable (6-7e) |  |  |  |  | 8
 |  |  |  | 9 | Refund (7e-6) |  |  |  |  | 9
 |  |  | COMPUTATION OF FRINGE BENEFITS AND TAX THEREON | 10 | Value of Fringe Benefits |  |  |  |  | 10
 |  |  |  | 11 | Total fringe benefit tax liability |  |  |  |  | 11
 |  |  |  | 12 | Total interest payable |  |  |  |  | 12
 |  |  |  | 13 | Total tax and interest payable |  |  |  |  | 13
 |  |  |  | 14 | Taxes paid
 |  |  |  |  | a | Advance Tax | 14a
 |  |  |  |  | b | Self Assessment Tax | 7d
 |  |  |  |  | c | Total Taxes Paid (14a+14b) |  |  |  | 14c
 |  |  |  | 15 | Tax Payable (6-7e) |  |  |  |  | 15
 |  |  |  | 16 | Refund (7e-6) |  |  |  |  | 16
 |  |  | Receipt No |  |  |  |  | Seal and Signature of receiving official
 |  |  | Date |  |  |  |  |  | 1634043719 |  |  |  |  |  |  |  |  |  |  |  | bodoni mT post
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rockwell Condensed
Spreadsheet: 135195d1325864819-auto-populating-calendars-using-excel-marketing-purposes-copy-of-2012-budget-for-marketing
Sheet: 2012 Budget for Marketing

[NAME] | Type | Vendor | [NAME] | Media | Costs | Expense Month | # Mos | Final Month | Monthly Cost | Invoice Rec'd (Y/N)
2012-01-09 00:00:00 | ADV | EPBJ | Job Growth - 3.50% | Newspaper | 1300 | 2012-01-01 00:00:00 | 1 | 2012-01-01 00:00:00 | 1300 | N
2012-01-01 00:00:00 | ADV | MCALL | New Year's Wishes | Newspaper | 1992.06 | 2012-01-01 00:00:00 | 1 | 2012-01-01 00:00:00 | 1992.06 | N
2012-01-01 00:00:00 | ADV | EPBJ | Job Growth - 3.50% | Newspaper | 1000 | 2012-01-01 00:00:00 | 1 | 2012-01-01 00:00:00 | 1000 | N
Spreadsheet: 841264d1693464265-find-most-occuring-value-and-sort-the-top-3-book1
Sheet: Sheet1

WO Description | Start Date | Finish date | Total Downtime | Work Type
BRAKE SYSTEM FIXED | 2022-04-15 10:00:00 | 2022-04-15 13:00:00 | 3 | BD
SAFETY INSPECTION | 2022-04-18 08:10:00 | 2022-04-18 09:10:00 | 0.9999999999417923 | INS
SAFETY INSPECTION | 2022-05-02 10:30:00 | 2022-05-02 11:30:00 | 0.9999999999417923 | INS
HEAD [NAME] REPLACED | 2022-05-04 15:05:00 | 2022-05-04 15:43:00 | 0.6333333334769122 | BD
REAR BRAKE FIXED | 2022-05-09 13:00:00 | 2022-05-09 16:00:00 | 3 | BD
SAFETY INSPECTION &REAR BRAKE REPAIRED | 2022-05-21 11:00:00 | 2022-05-21 14:00:00 | 3 | INS
INSPECTION+BRAKE SYSTEM REPAIR | 2022-06-13 07:50:14 | 2022-06-13 11:50:14 | 3.999999999941792 | INS
SAFETY INSPECTION | 2022-09-05 09:00:00 | 2022-09-05 10:00:00 | 0.9999999999417923 | INS
SAFETY INSPECTION | 2022-09-19 10:00:00 | 2022-09-19 11:30:00 | 1.5 | INS
Spreadsheet: 861132d1709102481-single-cell-formula-to-create-a-dynamic-array-dynamicarray
Sheet: Sheet1

ID | Period | Rate |  |  |  | 2024 | 2025
A001 | 2023 | 100
A002 | 2023 | 200 |  | A002
A003 | 2023 | 300 |  | A003
A004 | 2023 | 400 |  | A004
A001 | 2024 | 105
A002 | 2024 | 210
A003 | 2024 | 315
A004 | 2024 | 420
A001 | 2025 | 110
A002 | 2025 | 220
A003 | 2025 | 330
A004 | 2025 | 440
Spreadsheet: 828777d1683729821-nested-xlookup-formula-returns-value-error-copyplantmeasurements2023-v2-aligw
Sheet: LateCurve6_5in

Sell Week
Weeks To Flower | 8.5
Average Height at Pinch (In) | 6
[NAME] lower limit (In) | 15
[NAME] upper limit (In) | 17
Time (%) | Weeks (X-value) | Height (% taken from growth curve) | Lower height limit (in) (y-value) | Upper Height Limit (In) (y-value)
0 |  | 0
10 |  | 5
20 |  | 15
30 |  | 30
40 |  | 45
50 |  | 60
60 |  | 75
70 |  | 85
80 |  | 92
90 |  | 97
100 |  | 100
Spreadsheet: 0305e2f4-4099-4794-9aaa-f24e989d2544
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 6302.0 Average Weekly Earnings, Australia
 | TABLE 12G. Average Weekly Earnings, Northern Territory (Dollars) - Seasonally Adjusted
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Earnings; [NAME]; Full Time; Adult; Ordinary time earnings ;  Northern Territory ; |  |  | Seasonally Adjusted | A2773021W | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; [NAME]; Full Time; Adult; Total earnings ;  Northern Territory ; |  |  | Seasonally Adjusted | A2773024C | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; [NAME]; Total earnings ;  Northern Territory ; |  |  | Seasonally Adjusted | A2773030X | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Females; Full Time; Adult; Ordinary time earnings ;  Northern Territory ; |  |  | Seasonally Adjusted | A2773022X | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Females; Full Time; Adult; Total earnings ;  Northern Territory ; |  |  | Seasonally Adjusted | A2773025F | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Females; Total earnings ;  Northern Territory ; |  |  | Seasonally Adjusted | A2773031A | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Persons; Full Time; Adult; Ordinary time earnings ;  Northern Territory ; |  |  | Seasonally Adjusted | A2773023A | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Persons; Full Time; Adult; Total earnings ;  Northern Territory ; |  |  | Seasonally Adjusted | A2773026J | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Persons; Total earnings ;  Northern Territory ; |  |  | Seasonally Adjusted | A2773032C | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
© Commonwealth of Australia  2013
Spreadsheet: 330185d1404589437-extract-year-for-other-formula-extract-date-test
Sheet: Monthly Summary

Select the Appropriate                                        Wellness Program |  |  |  |  | Enter Date Range |  |  |  |  |  |  |  |  |  |  |  | Total of Overall Programs          Based On Dates Selected
 |  |  |  |  | Start Year |  |  |  | End Year
PILATES |  |  |  |  | 2014-01-01 00:00:00 |  |  | To | 2016-07-07 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Program | Volume | Revenue
Packages | Price List | 2014-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Volume | REVENUE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL BODY FITNESS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FIT FOR LIFE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PILATES
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FITNESS TRAINING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RUNNING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BIKE FIT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MESSAGE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GOLF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ALTER G
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 | Volume
 | Revenue
Spreadsheet: 804404d1668066810-conditional-format-to-highlight-row-when-all-cells-in-row-have-yes-in-them-book2
Sheet: Sheet1

Name | Theory Test | Practical Test | Oral Test
[NAME]
[NAME]
Watson
[NAME]
Parker
This is what I want the formatting to do
Name | Theory Test | Practical Test | Oral Test
[NAME] | Yes | Yes | Yes
[NAME] |  | Yes
Watson | Yes |  | Yes
[NAME] | Yes | Yes | Yes
Parker |  | Yes | Yes
Spreadsheet: 789055d1658863151-index-between-dates-index_betweendates
Sheet: MainData

Student List | 2022-07-25 00:00:00 | 2022-07-26 00:00:00 | 2022-07-27 00:00:00 | 2022-07-28 00:00:00 | 2022-07-29 00:00:00
A | x | x | x | x | x
B | x | x | x | x | x
C | x | x | x | x | x
D | x | x | x | x | x
E | x | x | x | x | x
Spreadsheet: 878034d1725002130-xlookup-columns-based-on-random-text-search-book2
Sheet: Sheet1

Invested In | STOCK_NO | I need to [NAME] G based on Column A & E value |  | Stock Name | I need to X ookup the Stock_No
HDFC Bank Ltd | 1 |  |  | HDFC Bank Ltd. |  | HDFCBANK
Reliance Industries Ltd | 2 |  |  | Reliance | 1 | RELIANCE
ICICI Bank Ltd | 3 |  |  | ICICI Bank | 1 | ICICIBANK
Infosys Ltd | 4 |  |  | Infosys Ltd. | 4 | INFY
Larsen & Toubro Ltd | 5 |  |  | Toubro | 1 | LT
ITC Ltd | 6 |  |  | ITC Ltd. | 6 | ITC
Tata Consultancy Services Ltd | 7 |  |  | Tata Consultancy Services Ltd. | 7 | TCS
Bharti Airtel Ltd | 8 |  |  | Bharti Airtel | 1 | BHARTIARTL
Axis Bank Ltd | 9 |  |  | Axis Bank Ltd. | 9 | AXISBANK
State Bank of India | 10 |  |  | State Bank of India | 10 | SBIN
Spreadsheet: 684553d1593439329-which-timing-is-more-sale-is-happened-with-category-need-formula-sekar-time-slots-aligw
Sheet: Sheet1

Date format |  |  |  |  | Time Period
2020-01-01 07:03:00 |  |  |  | 06:00:00 | 6 am to 9 am
2020-01-01 11:09:00 |  |  |  | 09:00:01 | 9.01 am to 12 pm
2020-01-01 13:10:00 |  |  |  | 12:00:01 | 12.01 pm to 3 pm
2020-01-01 15:43:00 |  |  |  | 15:00:01 | 3.01 pm to 6 pm
2020-01-01 18:49:00 |  |  |  | 18:00:01 | 6.01 pm to 9 pm
2020-01-01 23:45:00 |  |  |  | 21:00:01 | 9.01 pm to 12 pm
Spreadsheet: 878334d1725412226-weekly-updating-excel-from-new-data-dump-week-ahead-schedule-testing_basic-data
Sheet: Current Works

 |  |  |  |  |  |  | 2024-09-09 00:00:00
Job Num | Job Name | Status | Customer | Site | Project Mgr | Tech | Week 1 | Week 2 | Week 3 | Est. Hrs | Week 1a | Week 2a | Week 3a | Works / Notes | Actual Hours | Scheduled | Scheduling Issues
16743 |  |  |  |  |  |  | 0
18123
18135 |  |  |  |  |  |  | 0
18137
18138 |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
18139 |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
18140 |  |  |  |  |  |  | 0 |  |  |  | 0 | 0
18141 |  |  |  |  |  |  | 0
18142 |  |  |  |  |  |  | 0
18143 |  |  |  |  |  |  | 0
18202 |  |  |  |  |  |  | 0
17561
18213 |  |  |  |  |  |  | 0
18214 |  |  |  |  |  |  | 0
18216 |  |  |  |  |  |  | 0
18217 |  |  |  |  |  |  | 0
18218 |  |  |  |  |  |  | 0
18219 |  |  |  |  |  |  | 0
18220 |  |  |  |  |  |  | 0
18221 |  |  |  |  |  |  | 0
18222 |  |  |  |  |  |  | 0
18223 |  |  |  |  |  |  | 0
17731
18224 |  |  |  |  |  |  | 0
18227 |  |  |  |  |  |  | 0
18233 |  |  |  |  |  |  | 0
18247 |  |  |  |  |  |  |  |  |  |  | 49 | 0
18259 |  |  |  |  |  |  | 0
18278 |  |  |  |  |  |  | 0
18283
18340 |  |  |  |  |  |  | 0
18348
17927
18352 |  |  |  |  |  |  | 38
18365 |  |  |  |  |  |  | 0
18367
18369
18370
18372
18374 |  |  |  |  |  |  | 4
18377 |  |  |  |  |  |  | 0
18379
18380
17999 |  |  |  |  |  |  | 0
18386 |  |  |  |  |  |  | 0
18391
18393
18398 |  |  |  |  |  |  | 0
18401
18404 |  |  |  |  |  |  | 38
18405
18406 |  |  |  |  |  |  | 0
18409 |  |  |  |  |  |  |  |  |  |  | 0 | 0
18031 |  |  |  |  |  |  | 0
18412
18413
18416
18420
18422
18423
18426
18427
18429
18432
18035 |  |  |  |  |  |  | 0
18435
18436
18437
18438 |  |  |  |  |  |  |  |  |  |  | 0 | 0
18091
Q11117
Petbarn |  |  |  |  |  |  | 0
Gen Test
Q10990?
Spreadsheet: 885103d1734529984-how-to-use-function-change-blank-to-special-wording-convert-blank-to-
Sheet: data

First Name | Last Name |  |  | Result
 | Nok |  |  | -Nok
 | Logistic |  |  | -Logistic
 | [NAME] |  |  | -Gerschwitz
 | Palin |  |  | -Palin
 | Phakamas |  |  | -Phakamas
 | Suwarid |  |  | -Suwarid
aaa | bbb |  |  | -bbb
 | bbb |  |  | -bbb
Spreadsheet: 678718d1590033540-getting-the-syntax-right-in-an-if-function-sample
Sheet: Sheet1

Example 1
 | Job level | Hospitalization | Premium |  | Current Unit | New Unit | TOTAL
Permanent | Trainee | 1250 | 100 |  | 0 | 1 |  |  | formula is done in the work book | =IF($L$28>=0,$L$28*$Q$10
Contract | - | - | -
Example 2
 | Job level | Hospitalization | Premium |  | Current Unit | New Unit | TOTAL
Permanent | Trainee | 1250 | 100 |  | 0 | -1 |  |  | formula is done in the work book | =IF(AND($L$28<0,$H$19<>""),$L$28*$H$19
Contract | - | - | -
Example 3
 | Job level | Hospitalization | Premium |  | Current Unit | New Unit | TOTAL |  | formula is done in the work book | =,IF($L$28<=0,$L$28*$H$20,"")
Permanent |  |  |  |  | 0 | -1
Contract | Hr Assistant | 1000 | 100
Example 4
 | Job level | Hospitalization | Premium |  | Current Unit | New Unit | TOTAL
Permanent | Trainee | 1250 | 100 |  | 3 | -1 | should be blank |  | that means that he/she has more than enough to get him covered, we will just minus off manually from the master file that he/she uses 1 to get him covered
Contract | - | - | -
Example 5
 | Job level | Hospitalization | Premium |  | Current Unit | New Unit | TOTAL |  | that means he/she short of 1 unit to get him covered and he has to pay for that short of 1 unit based on the hospitalization value
Permanent | Trainee | 1250 | 100 |  | 3 | -4 |  |  | * hospitalization value - depending if the person is permanent or contract employee
Contract | - | - | -
Spreadsheet: 440232d1452703404-vacation-tracking-from-an-anniversary-date-from-year-to-year-vacation-tracking-2016
Sheet: June

Employee Absence Schedule
June | Dates of Absence
Employee Name | 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 | 28 | 29 | 30 |  | Total Hours
A
B
C
D
E
F
G
H
J
K
L
N
O