tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 03c5c954-eb1a-4ace-a038-00bdfc7f471c
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
College of Agriculture and Technology
PAYROLL OFFICE - Knapp Hall 123
HOURLY TEMPORARY
PAYROLL VOUCHER
Employee Name:_____________________________ |  |  |  |  | Department Account Number:______________________________________
[NAME]:_________________________________ |  |  |  |  | Department or Office:____________________________________________
Line Item No:________________________________ |  |  |  |  | Office Phone Number: |  |  |  | Bldg. |  | Room #
Pay Period Beginning: |  |  | 2009-06-11 00:00:00 |  |  | Ending: | 2009-06-24 00:00:00 |  |  |  |  | H
(Enter Beginning Date Only--Other Dates are Formula-Driven)
Day | Dates | Record Hours 'In' and 'Out' Daily                                                                                        ([NAME]:  In: 9:15 A  Out: 12:30 P) |  |  |  |  |  | [NAME] (Exclude Lunch) |  |  |  | R
 |  | In | Out | In | Out | In | Out
 |  |  |  |  |  |  |  |  |  |  |  | Y
Thu. | 2009-06-11 00:00:00
Fri. | 2009-06-12 00:00:00
Sat. | 2009-06-13 00:00:00
Sun. | 2009-06-14 00:00:00
Mon. | 2009-06-15 00:00:00
Tue. | 2009-06-16 00:00:00
Wed. | 2009-06-17 00:00:00
Weekly Total
Thu. | 2009-06-18 00:00:00
Fri. | 2009-06-19 00:00:00
Sat. | 2009-06-20 00:00:00
Sun. | 2009-06-21 00:00:00
Mon. | 2009-06-22 00:00:00
Tue. | 2009-06-23 00:00:00
Wed. | 2009-06-24 00:00:00
Total Amount $ |  |  |  |  |  | Weekly Total |  |  | Total Hours Worked:
1. | Record hours "in" and "out" daily. Hours worked must be recorded in quarter hour units (e.g. 9:15 A, 12:30 P) in ink.
2. | All hours worked on a holiday or hours which have been adjusted must be initialed by the supervisor before payment can be made.
3. | A work period cannot extend beyond six hours without taking a lunch break of at least one-half hour, which must be shown on the time sheet.
4. | Employee: Complete ALL blanks, sign and submit to your supervisor when you finish work for the pay period.  Late time sheets cannot be paid until the following pay period.
5. | Supervisor: Review time sheet for accuracy, initial all approved holiday work and corrections made on the time sheet, sign certification and submit only the original copy to the Payroll Office for payment.  See "Pay Schedule" issued by Payroll Office for due dates.
I certify that the days and hours worked as recorded above are correct. |  |  |  |  |  |  | I certify that the days and hours indicated above represent time worked by the employee including any holiday hours noted and initialed by me, and that the employee is entitled to payment thereof.
Employee's Signature |  |  |  | Date |  |  | [NAME]'s Signature |  |  |  |  | Date
Spreadsheet: 683102d1592488301-a-more-efficient-way-to-aggregate-data-using-a-formula-example-of-aggregate-data-formula
Sheet: Sheet1

Data | Aggregating it
0.0009611142623054138
0.0009846925073851939
0.001020691045641271
0.009002770083102494
0.04054054054054054
1
0.005825242718446601
0.09090909090909091
0.5
0.01612903225806452
1
0.1666666666666666
0
0
0.01
0.1
0.11
0.2
0.21
Spreadsheet: 069e9432-6128-49ac-9493-5b885932c03e
Sheet: Shamokin Mobile

 |  |  |  |  |  |  | 2013 Shamokin Mobile
 | January |  |  |  |  |  | February |  |  |  |  |  | March
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  |  |  |  |  | 1
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 4 | 5 | 6 | 7 | 8
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 11 | 12 | 13 | 14 | 15
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 18 | 19 | 20 | 21 | 22
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 |  |  | 25 | 26 | 27 | 28 | 29
 | April |  |  |  |  |  | May |  |  |  |  |  | June
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  | 1 | 2 | 3
 | 8 | 9 | 10 | 11 | 12 |  | 6 | 7 | 8 | 9 | 10 |  | 3 | 4 | 5 | 6 | 7
 | 15 | 16 | 17 | 18 | 19 |  | 13 | 14 | 15 | 16 | 17 |  | 10 | 11 | 12 | 13 | 14
 | 22 | 23 | 24 | 25 | 26 |  | 20 | 21 | 22 | 23 | 24 |  | 17 | 18 | 19 | 20 | 21
 | 29 | 30 |  |  |  |  | 27 | 28 | 29 | 30 | 31 |  | 24 | 25 | 26 | 27 | 28
 | July |  |  |  |  |  | August |  |  |  |  |  | September
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  |  | 1 | 2 |  | 2 | 3 | 4 | 5 | 6
 | 8 | 9 | 10 | 11 | 12 |  | 5 | 6 | 7 | 8 | 9 |  | 9 | 10 | 11 | 12 | 13
 | 15 | 16 | 17 | 18 | 19 |  | 12 | 13 | 14 | 15 | 16 |  | 16 | 17 | 18 | 19 | 20
 | 22 | 23 | 24 | 25 | 26 |  | 19 | 20 | 21 | 22 | 23 |  | 23 | 24 | 25 | 26 | 27
 | 29 | 30 | 31 |  |  |  | 26 | 27 | 28 | 29 | 30 |  | 30
 | October |  |  |  |  |  | November |  |  |  |  |  | December
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  | 2 | 3 | 4 | 5 | 6
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 9 | 10 | 11 | 12 | 13
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 16 | 17 | 18 | 19 | 20
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 23 | 24 | 25 | 26 | 27
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 | 29 |  | 30 | 31
 | 1st & 3rd Tuesdays.  [NAME] is subject to change.  Call CPFB with questions [PHONE]. Thank you.
 |  |  | Holiday closures. |  |  |  |  | Deliveries. |  |  |  | Inventory - warehouse closures.
Spreadsheet: 668412d1584805949-extracting-by-area-code-ca-areacode
Sheet: Sheet1

LA- | 213
LA- | 310
LA- | 424
LA- | 323
LA | 341
[NAME] | 626
Anaheim | 714
San Jose- | 408
SF- | 415
SF- | 424
SF- | 442
Oakland | 510
Long Beach- | 562
San Diego- | 619
San Diego- | 858
Santa Rosa- | 707
Santa Barbara- | 805
Monterey- | 831
[NAME] | 916
Concord | 925
Spreadsheet: 45088d1243870017-using-boolean-to-compile-knowledge-flags-send_alt
Sheet: Summary

 | Country | Sent | Received | Location | Contact | Notes |  |  |  | Areas
1 | Botswana | Yes | 0 | 0 | 0 | 0 |  |  |  | Africa
2 | Ghana | Yes | 0 | 0 | 0 | 0 |  |  |  | Asia & The Pacific
3 | Seychelles | Yes | 0 | 0 | 0 | 0 |  |  |  | Europe
4 | Hong Kong (2) | Yes | 0 | 0 | 0 | 0 |  |  |  | LAMCAR
5 | Pakistan (2) | Yes | 0 | 0 | 0 | 0 |  |  |  | USA & Canada
6 | Thailand | Yes | 0 | 0 | 0 | 0
7 | Belgium | Yes | 0 | 0 | 0 | 0
8 | Israel | Yes | 0 | 0 | 0 | 0
9 | Cuba | Yes | 0 | 0 | 0 | 0
10 | Canada | Yes | 0 | 0 | 0 | 0
11 | USA | Yes | 0 | 0 | 0 | 0
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Spreadsheet: 119022d1314140462-complex-if-formula-to-search-for-text-volume-rebate-template-dummy-file
Sheet: Volume Rebate Template

 | Month : | June, 2011
 | Total Rebate : | #N/A
 | Distribution Centre | Order Activity | Invoice Date | Invoice Number | Customer ID | State | Post Code | Code | Our Code | Description | UOM | Sell Price Per UOM | Qty Shipped | Total Sale Ex GST | Volume Allowance % | Total Rebate
 | Melb | Direct | 20/06/2011 | 123456789 | 123456 | VIC | 3000 | 1872365 | 872365 | Food 125gm Cat Whiskas | P20 | 20 | 33 | 660 | .13 | 85.8
 | Melb | Direct | 20/06/2011 | 123456789 | 123456 | VIC | 3000 | 1872365 | 872365 | Food Dog 150gm Pal | P20 | 15 | 28 | 420 | .12 | 50.4
 | Melb | Direct | 20/06/2011 | 123456789 | 123456 | VIC | 3000 | 1872365 | 872365 | Hay Bail 1kg Horse | P20 | 21.5 | 19 | 408.5 | .12 | 49.02
 | Melb | Direct | 20/06/2011 | 123456789 | 123456 | VIC | 3000 | 1872365 | 872365 | Food 125gm Pig | P20 | 63.8 | 57 | 3636.6 |  | #N/A
 | Melb | Direct | 20/06/2011 | 123456789 | 123456 | VIC | 3000 | 1872365 | 872365 | Food Monkey 150gm Pal | P20 | 91.5 | 3 | 274.5 |  | #N/A
 | Melb | Direct | 20/06/2011 | 123456789 | 123456 | VIC | 3000 | 1872365 | 872365 | Hay Bail 1kg Cow | P20 | 88 | 94 | 8272 | .14 | 1158.08
 | Melb | Direct | 20/06/2011 | 123456789 | 123456 | VIC | 3000 | 1872365 | 872365 | Food 125gm Chicken | P20 | 12 | 105 | 1260 | .8 | 1008
 | Melb | Direct | 20/06/2011 | 123456789 | 123456 | VIC | 3000 | 1872365 | 872365 | Food elephant [NAME] | P20 | 85 | 8 | 680 |  | #N/A
 | Melb | Direct | 20/06/2011 | 123456789 | 123456 | VIC | 3000 | 1872365 | 872365 | Hay Bail 1kg Donkey | P20 | 3 | 76 | 228 |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
Spreadsheet: 855165d1704834325-need-to-know-how-to-reference-a-specific-month-and-or-year-sum-month-year
Sheet: Sheet1

Date | Sales |  |  |  |  | 2023-03-01 00:00:00 | 2023-03-31 00:00:00
2023-02-01 00:00:00 | 10 |  |  | Sum March ignoring year
2023-03-02 00:00:00 | 20 |  |  | Sum March and Year 2023
2023-03-03 00:00:00 | 30 |  |  | Sum  Year 2024 (ignoring months)
2023-03-04 00:00:00 | 40 |  |  | Sum March and Year 2023 | SUMIFS does not allow use of MONTH or YEAR functions
2023-02-05 00:00:00 | 50 |  |  | Sum March and Year 2023 | SUMIFS does not allow use of MONTH or YEAR functions
2024-02-06 00:00:00 | 60 |  |  | Sum March and Year 2023 | SUMIFS does not allow use of MONTH or YEAR functions
2024-03-07 00:00:00 | 70
2024-02-08 00:00:00 | 80
2024-02-09 00:00:00 | 90
2024-02-10 00:00:00 | 100
Spreadsheet: 826252d1681897098-extracting-month-in-mmm-format-from-a-mmm-yy-date-book1
Sheet: Sheet1

2021-11-01 00:00:00 | Nov
2021-12-01 00:00:00 | Dec
2022-01-01 00:00:00 | Jan
2022-02-01 00:00:00 | Feb
2022-03-01 00:00:00 | Mar
2022-04-01 00:00:00
2022-05-01 00:00:00
2022-06-01 00:00:00
2022-07-01 00:00:00
2022-08-01 00:00:00
2022-09-01 00:00:00
2022-10-01 00:00:00
2022-11-01 00:00:00
2022-12-01 00:00:00
2023-01-01 00:00:00
2023-02-01 00:00:00
2023-03-01 00:00:00
2023-04-01 00:00:00
Spreadsheet: e59c99b4-ef71-4ceb-865d-397926432b6f
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
CORTU | Test | CORTU | Cortisol, Free, [NAME] | Cortisol, Free, U | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | [NAME], 24-hour graduated: 24Urine |  |  | 5 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) [NAME]: 5 mL Collection Instructions: 1. Collect urine for 24 hours. 2. Add 10 g of boric acid as preservative at start of collection. Additional Information: 1. 24-Hour volume is required. 2. See [NAME] in Special Instructions for multiple collections.   Urine Preservative Collection Options Ambient	No Refrigerated	Yes Frozen	Yes 6N HCl	No 50% Acetic Acid	Yes Na2CO3	Yes Toluene	Yes 6N HNO3	No Boric Acid	Preferred Thymol	Yes Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 3 mL | Hemolysis	NA Thawing	Warm OK if preservative added; Cold OK Lipemia	NA Icterus	NA Other	NA | 0-2 years: not established 3-8 years: 1.4-20 mcg/24 hours 9-12 years: 2.6-37 mcg/24 hours 13-17 years: 4.0-56 mcg/24 hours > or =18 years: 3.5-45 mcg/24 hours   Use the factor below to convert from mcg/24 hours to nmol/24 hours:   Conversion factor [NAME]: mcg/24 hours x 2.76=nmol/24 hours (molecular weight=362.5) | Monday through Friday, Sunday; 1 p.m. | 2 days (not reported on Sundays) | 5 days | 1 | 82530 |  |  |  |  | Rochester
CORTU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
CORTU | Order Question | TM93 | Collection Duration |  | Plain Text
CORTU | Order Question | VL47 | [NAME] |  | Plain Text
CORTU | Result | 8546 | Cortisol, U | Cortisol, U | Numeric |  |  |  |  | mcg/24 h |  |  |  |  |  |  |  |  |  | 14158-0 | Cortisol:MRat:24H:[NAME]:Qn:
CORTU | Result | TM93 | Collection Duration | Collection Duration | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13362-9 | Collection duration:Time:*:Urine:Qn:
CORTU | Result | VL47 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19153-6 | [NAME] volume:Vol:XXX:[NAME]:Qn:
Spreadsheet: 82831d1282837521-highlighting-when-stock-is-low-if-there-are-several-entries-batches-of-same-product-sample-stock-sheet
Sheet: Sheet1

 | Description | Product No. | Batch No. | Location | Opened | Min. Qty. | Qty. | Total Qty. | Status | Retest / Expiry | Comments | Low Stock
 | Approved Materials
 | Apples | 001 | B00132 | Warehouse | Yes | 5 | 95 | 95 | A | 2010-11-25 00:00:00 | None | No
 | Oranges | 002 | B00273 | Warehouse | Yes | 60 | 5 | 55 | A | 2010-10-05 00:00:00 | None | Yes
 | Oranges | 002 | B00295 | Warehouse | Yes | 60 | 50 | 55 | A | 2010-12-05 00:00:00 | None | Yes
 | Pears | 003 | B00198 | Shop | Yes | 20 | 10 | 130 | A | 2011-01-15 00:00:00 | None | No
 | Pears | 003 | B00328 | Shop | No | 20 | 120 | 130 | A | 2011-05-25 00:00:00 | None | No
Spreadsheet: darrell_schoolcraft__7256__saledoc02_14TW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Astra Power
Deal Date: |  |  | 2002-02-13 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 2/14/2002 |  |  | FAX Number:
Total Quantity |  |  | 20000 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | 2.19
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
2/14/2002 | 2002-02-14 00:00:00 | 20000 |  | 20000 |  | 20000
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
WT Pool |  |  | 58646 |  | 20000 |  |  |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
[NAME] [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: 825053d1681081751-formula-if-for-my-result-manual-result
Sheet: Sheet1

 | In | Out | Indicator (A or B) | Indicator (C or D) | Date Indicator C | Manual Result |  | A | C
 | 2023-04-01 00:00:00 | 2023-04-30 00:00:00 | A | C | 2023-04-09 00:00:00 | 14 |  | B | D
 | 2023-04-01 00:00:00 | 2023-04-30 00:00:00 | A | D |  | 19
 | 2023-04-01 00:00:00 | 2023-04-30 00:00:00 | B | C | 2023-04-09 00:00:00 | 16
 | 2023-04-01 00:00:00 | 2023-04-30 00:00:00 | B | D |  | 21
 |  |  |  |  |  | 1st argument
 |  |  |  |  |  | If Indicator A = Result (-1)
 |  |  |  |  |  | If Indicator B = Result (+1)
 |  |  |  |  |  | +
 |  |  |  |  |  | 2nd argument
 |  |  |  |  |  | If Indicator C = Result (Date Indicator C - Out)
 |  |  |  |  |  | If Indicator D = Result (same result as 1st argument)
Spreadsheet: darrell_schoolcraft__7323__imball0202
Sheet: Lonestar

 | 57245 |  | 500154
 | [NAME] |  | Pecos Del
Day | Measured | Scheduled | Measured | Scheduled
1 |  |  | -12545 | -12020
2 | -10540 | -10000 | -48006 | -47537
3 | -11307 | -10000 | -48201 | -47537
4 | -10040 | -10000 | -47983 | -47537 |  |  |  |  |  | [NAME] |  | Pecos Del |  |  | Cumulative
5 | -10313 | -10000 | -25316 | -25163 |  |  |  |  | Month | Measured | Scheduled | Measured | Scheduled | Imbalance | Balance
6 | -10601 | -10000 | -109993 | -109606 |  |  |  |  | 2000-12-01 00:00:00 | Balance as of 12/31/00 |  |  |  |  | -7752
7 | -10815 | -10000 | -37521 | -37520 |  |  |  |  | 2001-01-01 00:00:00 | -231248 | -57416 | -97420 | -261633
8 | -12723 | -10000 | -34718 | -35326 |  |  |  |  | 2001-02-01 00:00:00 | -21620 | -15000 | 0 | -5000
9 | -10791 | -10000 | -56402 | -56224 |  |  |  |  | 2001-03-01 00:00:00 | -162976 | 0 | -266 | -160000
10 | -9867 | -10000 | -55769 | -56224 |  |  |  |  | 2001-04-01 00:00:00 | -796190 | -10000 | -33222 | -771924
11 | -9990 | -10000 | -60296 | -60215 |  |  |  |  | 2001-05-01 00:00:00 | -893146 | -43184 | 0 | -842284
12 |  |  | -36347 | -35020 |  |  |  |  | 2001-06-01 00:00:00 | -652748 | -31034 | -332106 | -946401
13 |  | -10000 | -91575 | -94020 |  |  |  |  | 2001-07-01 00:00:00 | -1299468 | -656709 | -734846 | -1410580
14 | -29326 | -20000 | -70014 | -70020 |  |  |  |  | 2001-08-01 00:00:00 | -1826791 | -534941 | -305444 | -1560630
15 | -9961 | -10000 | -51748 | -52020 |  |  |  |  | 2001-09-01 00:00:00 | -1552478 | -728692 | -117048 | -943957
16 | -10005 | -10000 | -22475 | -22428 |  |  |  |  | 2001-10-01 00:00:00 | -1139380 | -196498 | -307336 | -1322794
17 | -10110 | -10000 | -22158 | -22428 |  |  |  |  | 2001-11-01 00:00:00 | -144119 | -155994 | -1349971 | -1325152
18 | -10370 | -10000 | -22832 | -22428 |  |  |  |  | 2001-12-01 00:00:00 | -379245 | -376245 | -721032 | -724604
19 |  |  |  |  |  |  |  |  | 2002-01-01 00:00:00 | -279779 | -271068 | -1831943 | -1808648 |  |  | estimated
20
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00
2002-02-18 00:00:00
CBS $
 |  |  | 71928.96
Spreadsheet: 841962d1694077861-how-to-prevent-repeating-count-across-columns-inputconfiguration
Sheet: Sheet1

 | Input Configuration | In1 | In2 | In3 | In4 | TOTAL |  | DIN_TBA
 | DIN_CONFIG0 | DIN_TBA
 | DIN_CONFIG1 |  |  |  | DIN_TBA
 | DIN_CONFIG2 |  | DIN_TBA
 | DIN_CONFIG3
 | [NAME] |  |  | DIN_TBA | DIN_TBA
 | DIN_CONFIG5 | DIN_TBA
 | This is how I would like to present the data
 | Input Configuration | In1 | In2 | In3 | In4 | TOTAL
 | DIN_CONFIG0 | DIN_TBA |  |  |  | DIN_CONFIG0
 | DIN_CONFIG1 |  |  |  | DIN_TBA | DIN_CONFIG1
 | DIN_CONFIG2 |  | DIN_TBA |  |  | DIN_CONFIG2
 | DIN_CONFIG3
 | [NAME] |  |  | DIN_TBA | DIN_TBA | [NAME]
 | DIN_CONFIG5 | DIN_TBA |  |  |  | DIN_CONFIG5
Spreadsheet: 766375d1643877006-merge-description-base-on-2-column-sample22
Sheet: Sheet1

GENE | RAL LEDGER | ANT STATEMENT | REPORT | 2022-03-02 11:19:18
POST DAT | E EFF  DAT | /C | TRANS AMT | BALANCE | NOTE
ACCT NO. | : 00000470 | KAIAN LISTRIK | ,AIR,GAS
2022-01-01 00:00:00 | 2022-01-01 00:00:00 | 10 | 9706155470 | 0 |  | RESULT SHOULD BE (merge from coloumn "G"
2022-07-01 00:00:00 | 2022-07-01 00:00:00 | 81 | 198500 | 198500 | Tagihan Air PIB | Tagihan Air PIB Banyumanik (SEM)  up/00081/22
 |  |  |  |  | Banyumanik (SEM)  up/00081/22
2022-07-01 00:00:00 | 2022-07-01 00:00:00 | 81 | 502500 | 701000 | Token ATM CLG C | Token ATM CLG C ity Square  up/00080/22 |  | I want to combine the information in column "F" into 1 description (not separated) in view of column "E" which has a value.
 |  |  |  |  | ity Square  up/00080/22
2022-10-01 00:00:00 | 2022-10-01 00:00:00 | 81 | 645750 | 1346750 | PLN ATM Botanic | PLN ATM Botanic a 21NOv-20Des21/P3SRSS Botanic a  up/00111/22
 |  |  |  |  | a 21NOv-20Des21/P3SRSS Botanic
 |  |  |  |  | a  up/00111/22
2022-10-01 00:00:00 | 2022-10-01 00:00:00 | 81 | 22267021 | 23613771 | 4 ID PALYJA&3 I | 4 ID PALYJA&3 I D PLN Jan22 (U:De21)  up/00132 /22
 |  |  |  |  | D PLN Jan22 (U:De21)  up/00132
 |  |  |  |  | /22
Spreadsheet: 476989d1472097307-sorting-addresses-sorting-addresses
Sheet: Sheet1

Name | Address | Subscribe
Person 6 | 835 north 200 west | No
Person 4 | 845 north 200 west | Yes
Person 9 | 855 north 200 west | Yes
Person 2 | 865 north 200 west | No
Person 3 | 840 north 200 west | Yes
Person 14 | 850 north 200 west | Yes
Person 1 | 860 north 200 west | Yes
Person 13 | 835 north 300 west | No
Person 10 | 845 north 300 west | Yes
Person 12 | 855 north 300 west | Yes
Person 7 | 865 north 300 west | No
Person 11 | 840 north 300 west | No
Person 8 | 850 north 300 west | Yes
Person 5 | 860 north 300 west | No
Spreadsheet: 701232d1603636685-count-office-and-non-office-hour-between-dates-excel-example_v6-ans
Sheet: Sheet1

To calculate the no. of Office Hours (and Non-Office Hours) excluding the defined office hours (Mon-Fri, 09:00-18:00, Sat 09:00-13:00), Sunday and Public Holidays
 |  |  |  |  | FORMULAS |  | CORRECT ANSWERS
 | Engineer Onsite Date | Engineer Onsite Time | Engineer Offsite Date | Engineer Offsite Time | No of Office Hours * | No of Non-Office Hours * | No of Office Hours * | No of Non-Office Hours * |  | Office Hour Definition | In | out
Example 1 - Sep 5 is Weekend (SAT) | 2020-09-05 00:00:00 | 09:00:00 | 2020-09-05 00:00:00 | 10:00:00 |  |  | 1 | 0 |  | Monday to Friday, 09:00 - 18:00 | 09:00:00 | 18:00:00
Example 2 - Oct 1 is Public Holiday | 2020-10-01 00:00:00 | 16:00:00 | 2020-10-01 00:00:00 | 17:30:00 |  |  | 0 | 1.5 |  | Saturday | 09:00:00 | 13:00:00
Example 3 - Across Weekdays & Weekend | 2020-09-25 00:00:00 | 17:00:00 | 2020-09-28 00:00:00 | 02:30:00 |  |  | 5 | 52.5
Example 4 - Across Weekdays, Public Holidays, Weekend | 2020-09-30 00:00:00 | 16:30:00 | 2020-10-05 00:00:00 | 13:00:00 |  |  | 9.5 | 107 |  | Non Office Hour Definition
 |  |  |  |  |  |  |  |  |  | Monday to Saturday, other than above working hours
 |  |  |  |  |  |  |  |  |  | Anytime in Sunday
 |  |  |  |  |  |  |  |  |  | Public Holiday as below:
 |  |  |  |  |  |  |  |  |  | Jan 1, 2020 | 2020-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  | Jan 25, 2020 | 2020-01-25 00:00:00
 |  |  |  |  |  |  |  |  |  | Jan 26, 2020 | 2020-01-26 00:00:00
 |  |  |  |  |  |  |  |  |  | Jan 27, 2020 | 2020-01-27 00:00:00
 |  |  |  |  |  |  |  |  |  | Jan 28, 2020 | 2020-01-28 00:00:00
 |  |  |  |  |  |  |  |  |  | Apr 4, 2020 | 2020-04-04 00:00:00
 |  |  |  |  |  |  |  |  |  | Apr 10, 2020 | 2020-04-10 00:00:00
 |  |  |  |  |  |  |  |  |  | Apr 11, 2020 | 2020-04-11 00:00:00
 |  |  |  |  |  |  |  |  |  | Apr 13, 2020 | 2020-04-13 00:00:00
 |  |  |  |  |  |  |  |  |  | Apr 30, 2020 | 2020-04-30 00:00:00
 |  |  |  |  |  |  |  |  |  | May 1, 2020 | 2020-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  | Jun 25, 2020 | 2020-06-25 00:00:00
 |  |  |  |  |  |  |  |  |  | Jul 1, 2020 | 2020-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  | Oct 1, 2020 | 2020-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  | Oct 2, 2020 | 2020-10-02 00:00:00
 |  |  |  |  |  |  |  |  |  | Oct 26, 2020 | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  |  |  | Dec 25, 2020 | 2020-12-25 00:00:00
 |  |  |  |  |  |  |  |  |  | Dec 26, 2020 | 2020-12-26 00:00:00
Spreadsheet: 1e6cce0b-2348-4966-bb3f-8a6a81c01091
Sheet: Home

 | To navigate to the  worksheet you want to see, click the worksheet name button in the Worksheet column.
 | To return to this Home worksheet, click the Home button                       in the top left cell.
 | Worksheet | Rule Type | Description
 |  | Cell value | Find specific numbers, dates, and text in a list of products
 |  | Cell value (with formula) | See a dynamically changed number or text value in a list of products
 |  | Top/bottom values Above/below average | Identify top, bottom, and above average values in a recent  book tour report
 |  | Top/bottom values | Determine who are the top two students in the class
 |  | Unique/duplicate | Find duplicate rows in a list of customers
 |  | Icon set | Quickly see revenue status and trends from one quarter to the next
 |  | Icon set | Compare different product criteria by using a rating scale
 |  | Icon set | Examine profit trends from month to month
 |  | Icon set | Identify regional sales below $900,000
 |  | Data bars | Compare heights of the tallest mountains
 |  | 3  color scale | Examine overall sales distributions in key product categories
 |  | [NAME]-based | Shade alternate rows in a range
 |  | [NAME]-based | Compare data in a cell outside the conditionally formatted range of cells
 |  | [NAME]-based | Shade an entire row where several criteria must be true
 |  | [NAME]-based | Shade an entire row if the row is a unique value