tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 506860d1489450212-regular-ot-and-doubletime-sample-timesheet
Sheet: Portrait

Month: | 2017-03-01 00:00:00 |  |  |  |  | Overtime starts after
Name: | [NAME] |  |  |  |  | 40 | hours |  | Weekly | Reg Hours | Over Hours | Total Hrs worked | TOTAL  PAY
 |  |  |  |  |  |  |  |  | Week of   03/01/17 | 40 | 3.25 | 43.25 | 897.5
[NAME] | 20 |  |  |  |  |  |  |  | Week of   03/06/17 | 0 | 0 | 0 | 0
Overtime rate | 1.5 |  |  |  |  |  |  |  | Week of   03/13/17 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | Week of   03/20/17 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | Week of   03/27/17 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | TOTAL | 40 | 3.25 | 43.25 | 897.5
Week of   03/01/17 | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun
Log In | 09:30:00 | 09:30:00 | 09:30:00 |  | 07:30:00 | 10:45:00 | 11:00:00
[NAME] |  |  |  |  |  | 15:00:00
Lunch Ends |  |  |  |  |  | 17:00:00
Log Out | 14:30:00 | 14:30:00 | 14:30:00 |  | 17:30:00 | 22:30:00 | 19:30:00
Hours Worked | 5 | 5 | 5 | 0 | 10 | 9.749999999999998 | 8.5
 |  | Reg. Hrs. | 40 | Over. Hrs. | 3.25 | Total Hrs. | 43.25
 |  | [NAME]. Pay | 800 | Over. Pay: | 97.5 | Total Pay | 897.5
Week of   03/06/17 | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun
Log In
[NAME]
Lunch Ends
Log Out
Hours Worked | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Reg. Hrs. | 0 | Over. Hrs. | 0 | Total Hrs. | 0
 |  | [NAME]. Pay | 0 | Over. Pay: | 0 | Total Pay | 0
Week of   03/13/17 | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun
Log In
[NAME]
Lunch Ends
Log Out
Hours Worked | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Reg. Hrs. | 0 | Over. Hrs. | 0 | Total Hrs. | 0
 |  | [NAME]. Pay | 0 | Over. Pay: | 0 | Total Pay | 0
Week of   03/20/17 | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun
Log In
[NAME]
Lunch Ends
Log Out
Hours Worked | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Reg. Hrs. | 0 | Over. Hrs. | 0 | Total Hrs. | 0
 |  | [NAME]. Pay | 0 | Over. Pay: | 0 | Total Pay | 0
Week of   03/27/17 | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun
Log In
[NAME]
Lunch Ends
Log Out
Hours Worked | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Reg. Hrs. | 0 | Over. Hrs. | 0 | Total Hrs. | 0
 |  | [NAME]. Pay | 0 | Over. Pay: | 0 | Total Pay | 0
Spreadsheet: 150419d1334519204-tally-number-locations-student-responses-2
Sheet: Sheet1

Date | Student ID Responses |  |  |  | Student IDs | Total Responses | Response Rows
2012-04-16 00:00:00 | 1 | 6 | 9 |  | 1
2012-04-13 00:00:00 | 2 | 6 | 15 |  | 2
2012-04-12 00:00:00 | 1 | 9 | 22 |  | 3
2012-04-11 00:00:00 | 5 | 11 | 21 |  | 4
2012-04-10 00:00:00 | 4 | 15 | 24 |  | 5
2012-04-09 00:00:00 | 3 | 4 | 7 |  | 6
2012-04-06 00:00:00 | 10 | 17 | 19 |  | 7
2012-04-05 00:00:00 | 2 | 12 | 13 |  | 8
2012-04-04 00:00:00 | 8 | 9 | 23 |  | 9
2012-04-03 00:00:00 | 1 | 2 | 14 |  | 10
2012-04-02 00:00:00 | 9 | 12 | 20 |  | 11
2012-03-30 00:00:00 | 2 | 13 | 21 |  | 12
2012-03-29 00:00:00 | 5 | 9 | 24 |  | 13
2012-03-28 00:00:00 | 4 | 10 | 16 |  | 14
2012-03-27 00:00:00 | 1 | 1 | 8 |  | 15
2012-03-26 00:00:00 | 11 | 16 | 20 |  | 16
 |  |  |  |  | 17
 |  |  |  |  | 18
 |  |  |  |  | 19
 |  |  |  |  | 20
 |  |  |  |  | 21
 |  |  |  |  | 22
 |  |  |  |  | 23
 |  |  |  |  | 24
Spreadsheet: 141698d1329404249-create-combined-list-summing-scores-for-individuals-score-eg
Sheet: Combined Leaderboard

 |  |  |  |  |  |  | Combined Leaderboard
 |  | Pts | Make indiv | Sniks | Rank |  |  |  |  |  |  |  |  |  |  | [NAME] | Skin/Skin
Leaderboard 1 | shaggy 1 | 129 | 129.000000003 | 6.5 | 1 |  | 1 | 1 | shaggy 1 | 129 |  |  | Player | Combined skin/snik |  | shag | 6.5 | 5 | 11.5
 | jack 1 | 117 | 117.000000004 | -8.5 | 4 |  | 2 | 21 | rhino 2 | 121 |  |  |  |  |  | [NAME] | -8.5
 | rhino 1 | 101 | 101.000000005 | 5 | 8 |  | 3 | 22 | tam 2 | 118 |  |  |  |  |  | rhin | 5
 | sleepy1 | 83 | 83.000000006 | -6.5 | 9 |  | 4 | 2 | jack 1 | 117 |  |  |  |  |  | slee | -6.5
 | tam 1 | 63 | 63.000000007 | 3.5 | 10 |  | 5 | 23 | sleepy2 | 113 |  |  |  |  |  | tam | 3.5
 |  |  |  |  |  |  | 6 | 24 | shaggy 2 | 108
 |  |  |  |  |  |  | 7 | 25 | jack 2 | 102
 |  |  |  |  |  |  | 8 | 3 | rhino 1 | 101
 |  |  |  |  |  |  | 9 | 4 | sleepy1 | 83
 |  |  |  |  |  |  | 10 | 5 | tam 1 | 63
 |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  | 6 |  |  |  |  | Want to create combined list here
 |  |  |  |  |  |  |  | 6 |  |  |  |  | From Both lists
 |  |  |  |  |  |  |  | 6 |  |  |  |  | this just an eg!
 |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  | 6
[NAME] | rhino 2 | 121 | 121.000000023 | -2.25 | 2 |  |  | 6 |  |  |  |  |  |  |  | rhin | -2.25
 | tam 2 | 118 | 118.000000024 | -11.5 | 3 |  |  | 6 |  |  |  |  |  |  |  | tam | -11.5
 | sleepy2 | 113 | 113.000000025 | 12.5 | 5 |  |  | 6 |  |  |  |  |  |  |  | slee | 12.5
 | shaggy 2 | 108 | 108.000000026 | 5 | 6 |  |  | 6 |  |  |  |  |  |  |  | shag | 5
 | jack 2 | 102 | 102.000000027 | -3.75 | 7 |  |  | 6 |  |  |  |  |  |  |  | [NAME] | -3.75
 |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  | 6
Count |  |  |  |  | 10
Spreadsheet: 7f4f71ab-4fec-4148-9937-9f21486049fa
Sheet: 13b

Product1 | HY6 | IG | Other | TOTAL
Index Tranche | 43580 | 412704 | 407175 | 863459
Europe | 0 | 0 | 401414 | 401414
North America/Asia | 43580 | 412704 | 5761 | 462045
Index | 622241 | 2693862 | 3848537 | 7164640
Asia | 0 | 0 | 116687 | 116687
Europe | 0 | 0 | 3389560 | 3389560
North America | 622241 | 2693862 | 101061 | 3417164
Other | 0 | 0 | 241229 | 241229
OTHER* | 0 | 0 | 402093 | 402093
TOTAL | 665821 | 3106566 | 4657805 | 8430192
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 803556d1667552544-find-rows-via-matrix-formular-example
Sheet: Sheet1

 |  | Type | Subtype | Flag | Note
 |  | A | 1
 |  | A | 2
 |  | A | 3
 |  | A | 4
 |  | A | 5
 |  | A | 6
 |  | B | 1 |  | Flag set on this type
 |  | B | 2 |  | Flag set on this type
 |  | B | 3 | 1 | Flagged
 |  | B | 4 |  | Flag set on this type
 |  | B | 5 |  | Flag set on this type
 |  | B | 6 |  | Flag set on this type
 |  | B | 7 |  | Flag set on this type
 |  | C | 1
 |  | C | 2
 |  | C | 3
 |  | C | 4
 |  | C | 5
 |  | C | 6
 |  | C | 7
 |  | B | 8 |  | Flag set on this type
 |  | B | 9 |  | Flag set on this type
 |  | B | 10 |  | Flag set on this type
Spreadsheet: 111983d1308180551-display-only-rows-and-column-a-sort-of-filtering-selector
Sheet: Selector

Offer 1
Offer 1 | Actual #s | [NAME] | #1 offer | #2 offer | #3 offer | #4offer | #5 offer
 | Sent |  | 1634 | 2342 | 2931 | 4326 | 11813
 | Open |  | 760 | 1117 | 1350 | 1555 | 2412
 | Clicks |  | 292 | 383 | 175 | 495 | 627
 | Orders |  | 3 | 45 | 4 | 9 | 22
 | Unsubscribe |  |  | 0 | 3 | 9 | 24
Offer 2 | Actual #s | [NAME] | #1 offer | #2 offer
 | Sent | 4084 | 9788 | 14290
 | Open | 856 | 1802 | 2181
 | Clicks | 226 | 428 | 418
 | Orders | 0 | 3 | 8
 | Unsubscribe | 27 | 50 | 72
Offer 3 | Actual #s | [NAME] | #1 offer
 | Sent |  | 1754
 | Open |  | 446
 | Clicks |  | 56
 | Orders |  | 3
 | Unsubscribe |  | 0
Offer 4 | Actual #s | [NAME] | #1 offer
 | Sent |  | 1754
 | Open |  | 446
 | Clicks |  | 56
 | Orders |  | 3
 | Unsubscribe |  | 0
Offer 5 | Actual #s | [NAME] | #1 offer
 | Sent |  | 1754
 | Open |  | 446
 | Clicks |  | 56
 | Orders |  | 3
 | Unsubscribe |  | 0
Offer 6 | Actual #s | [NAME] | #1 offer
 | Sent |  | 1754
 | Open |  | 446
 | Clicks |  | 56
 | Orders |  | 3
 | Unsubscribe |  | 0
Offer 7 | Actual #s | [NAME] | #1 offer
 | Sent |  | 1754
 | Open |  | 446
 | Clicks |  | 56
 | Orders |  | 3
 | Unsubscribe |  | 0
Spreadsheet: ab8fd009-8e3c-453e-b1de-e1034402f009
Sheet: Merchant Model

Merchant Profit Per Voucher
By Yipit.com
Drivers |  |  | Gross Profit / Voucher
Deal Assumptions |  |  | Existing Customers
Deal Value | 50 |  | Revenue from [NAME]
Deal Discount |  |  | Revenue from Overage
Deal Price | 25 |  | Revenue from Existing Customers
Overage % | 0.135 |  | Less: [NAME]
Commission % | 0.4 |  | Less: Cannibalized Revenue
Cost of Goods Sold % | 0.4 |  | GP from Existing Customers
Credit Card Fee % | 0.025
 |  |  | GP from Breakage
[NAME]
Unredeemed (Breakage) % | 0.2 |  | New Customers
Current Customer % | 0.2 |  | Revenue from [NAME]
New Customer % |  |  | Revenue from Overage
 |  |  | Revenue from New Customers
Repeat Visitor Assumptions |  |  | Less: [NAME]
Conversion to Repeat % | 0.19 |  | GP from New Customers
Repeat Visits | 3
Vouchers per Customer | 1.5 |  | Follow On Visits
Current Customers Already Going | 0.25 |  | Revenue from Repeat Customers
 |  |  | Less: [NAME]
 |  |  | GP from Follow On Visits
 |  |  | Merchant Profit / Voucher
Notes
1. Conversion to Repeat % is a function of non-existing customers who redeemed voucher, i.e., net of Breakage, Existing Customers, and quotient of vouchers per customer
2. Other inputs based on a survey of Yipit's survey 100 small businesses, and industry research.
3. A research report by ThinkEquity LLC estimates 27% of customers spend more than voucher amount. This model assumes additional spend to be 100% of purchase price of voucher.
Spreadsheet: darrell_schoolcraft__7323__imball0202
Sheet: transcol

 | TransColorado
 | 500632
Day | Measured | Scheduled
1 | 75695 | 78800
2 | 94691 | 93799
3 | 94498 | 93799
4 | 94115 | 93799
5 | 111473 | 110461
6 | 94006 | 93799
7 | 94007 | 93799
8 | 96300 | 96299
9 | 94782 | 93799
10 | 95002 | 93799
11 | 93951 | 93799
12 | 90782 | 90776
13 | 95014 | 93799
14 | 94012 | 93799
15 | 94013 | 93799
16 | 103917 | 91798
17 | 91468 | 91798
18 | 89759 | 91798
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | 28675
2002-02-18 00:00:00
CBS Volume
 |  |  | -42160
Spreadsheet: 125016d1318814420-excel-2007-multiply-if-statements-and-sumifs-volume-sells
Sheet: Main

 | Type | Error | Stock | Expected Answer
1 | PC | Harddrive |  | 2
2 | MAC | Harddrive |  | 2
3 | PC | Monitor |  | 2
4 | MAC | Monitor |  | 1
5 | PC | Keyboard |  | 2
6 | PC | Touchpad |  | 3
7 | PC | Sound |  | NA
Spreadsheet: 724570d1616244109-how-to-combine-a-sum-of-a-range-with-countif-of-the-same-range-t-and-a-01apr21-31mar22
Sheet: Holiday 4FEB21 - 31MAR21

NAME | REMAIN | TAKEN | SICK | 2021-02-04 00:00:00 | 2021-02-05 00:00:00 | 2021-02-06 00:00:00 | 2021-02-07 00:00:00 | 2021-02-08 00:00:00 | 2021-02-09 00:00:00 | 2021-02-10 00:00:00 | 2021-02-11 00:00:00 | 2021-02-12 00:00:00 | 2021-02-13 00:00:00 | 2021-02-14 00:00:00 | 2021-02-15 00:00:00 | 2021-02-16 00:00:00 | 2021-02-17 00:00:00 | 2021-02-18 00:00:00 | 2021-02-19 00:00:00 | 2021-02-20 00:00:00 | 2021-02-21 00:00:00 | 2021-02-22 00:00:00 | 2021-02-23 00:00:00 | 2021-02-24 00:00:00 | 2021-02-25 00:00:00 | 2021-02-26 00:00:00 | 2021-02-27 00:00:00 | 2021-02-28 00:00:00 | 2021-03-01 00:00:00 | 2021-03-02 00:00:00 | 2021-03-03 00:00:00 | 2021-03-04 00:00:00 | 2021-03-05 00:00:00 | 2021-03-06 00:00:00 | 2021-03-07 00:00:00 | 2021-03-08 00:00:00 | 2021-03-09 00:00:00 | 2021-03-10 00:00:00 | 2021-03-11 00:00:00 | 2021-03-12 00:00:00 | 2021-03-13 00:00:00 | 2021-03-14 00:00:00 | 2021-03-15 00:00:00 | 2021-03-16 00:00:00 | 2021-03-17 00:00:00 | 2021-03-18 00:00:00 | 2021-03-19 00:00:00 | 2021-03-20 00:00:00 | 2021-03-21 00:00:00 | 2021-03-22 00:00:00 | 2021-03-23 00:00:00 | 2021-03-24 00:00:00 | 2021-03-25 00:00:00 | 2021-03-26 00:00:00 | 2021-03-27 00:00:00 | 2021-03-28 00:00:00 | 2021-03-29 00:00:00 | 2021-03-30 00:00:00 | 2021-03-31 00:00:00
[NAME] |  |  |  | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 |  |  | H | H | H | H | H |  |  |  |  |  |  |  |  |  | H | H | H
[NAME] |  |  |  | N/A | N/A |  |  | 8 | 9 | 9 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 |  |  | 9 | 9 | 9 | HD | H |  |  | 9 | 9 | 9 | 9 | 9 |  |  |  |  |  |  | H
Dale |  |  |  | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 |  |  | HD | 9 | 9 | 9 | HD |  |  | 9 | H | H | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9
[NAME] |  |  |  | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 |  |  | H | 9 | 9 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 |  |  |  | HD | H | H
[NAME] |  |  |  | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 |  |  | 9 | 9 | 7 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9
KEY
H | HOLIDAY
HD | HALF DAY
S | SICK
NAME | Total Hrs Worked
[NAME]
[NAME]
Dale
[NAME]
[NAME]
Spreadsheet: kate_symes__18321__Deal Correction 4-20
Sheet: 4-20

Date of Inquiry | Adjustment date | Date of applied calc | Deal Date | Desk Involved | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
 | 2001-04-20 00:00:00 | 2001-04-20 00:00:00 | 2001-04-19 00:00:00 | STCA | KS | KS | N/A | Added price in EES sale |  | 586422 | NP-15 | 2001-04-20 00:00:00 | On | Shaped | 205.88 | EES
 | 2001-04-19 00:00:00 | 2001-04-20 00:00:00 | 2001-04-19 00:00:00 | STCA | CF | CF | N/A | Price: from 262 to 262.50 | Traders in dispute over deal terms | 576274 | SP-15 | May'01 | On | 15 | 262.5 | ARCO
 |  |  |  | Grand Count
Spreadsheet: 51924d1251495976-drag-fill-skipping-a-lot-of-rows-updated-psp-outreach-report-template-08-25-09-fs
Sheet: Paste Logs Here

Student Name | Entry Date | Entry
[NAME] | 2009-09-10 00:00:00 | Has not done any homework and has spent all day sitting out in the sun.
[NAME] | 2009-09-20 00:00:00 | Still refuses to do homework and enter the house.
PowerSchool Dude | 2009-09-10 00:00:00 | This is a test of the emergency broadcast system.
[NAME] | 2009-09-10 00:00:00 | Has gone green.
[NAME] | 2009-09-30 00:00:00 | Was visibly upset over the phone due to an altercation with a visitor who called her "cheap".
[NAME] | 2009-09-21 00:00:00 | Was suspended for slapping a sandwich.
PowerSchool Dude | 2009-09-20 00:00:00 | If this was an actual emergency, run quickly to the nearest restroom to change your underwear.
[NAME] | 2009-09-28 00:00:00 | Served her suspension and wrote a letter of apology to the sandwich.
[NAME] | 2009-10-31 00:00:00 | Served Detention
[NAME] | 2009-09-21 00:00:00 | Expressed a strange fear of supermarkets, especially the produce section.
Spreadsheet: 786620d1657303978-if-and-formula-listing-unwanted-values-excel-forum-file-220709
Sheet: Sheet1

COL 1 | COL 2 | COL 3 | COL 4 | COL 5
1 | 5
2 | 3.7 | 1 |  | 5
3 | 9.5
4 | 51 |  |  | 5
5 | 17
6 | 6 | 3
7 | 7.5
8 | 3.7 | 2
9 | 0
10 | 3.7 | 1 |  | 5
11 | 6 | 2
12 | 5
13 | 7 |  |  | 5
14 | 19
15 | 26
16 | 3.4 | 3
17 | 26
18 | 4.6 | 2
19 | 26
Spreadsheet: 768983d1645223521-missing-the-amount-needed-to-reach-a-max-cell-value-cf-reaching-cap-aligw
Sheet: Sheet1

2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 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 | Total
3000 | 4000 | 5700 | 3800 | 4800 | 2500 | 3600 | 2700 | 1800 | 2900 | 2500 | 3800
Spreadsheet: 889673d1740578601-using-if-formula-for-each-instance-in-sumproduct-table_test
Sheet: Helligdage

Beregning af påskesøndag |  |  |  |  |  |  |  | Helligdage
T betegner årstallet. | T |  |  |  |  |  | Nytårsdag
a er resten ved divisionen T/19. | a |  |  |  |  |  | Palmesøndag
b er resten ved divisionen T/4, | b |  |  |  |  |  | Skærtorsdag
c er resten ved divisionen T/7, | c |  |  |  |  |  | Langfredag
k er årstallets to første cifre (hundredtallet) | k |  |  |  |  |  | Påskedag
p er kvotienten af divisionen (13+8k)/25 [NAME] resten, | p |  |  |  |  |  | 2. [NAME]
q er kvotienten af divisionen [NAME] resten, | q |  |  |  |  |  | [NAME]
M er resten ved divisionen (15-p+k-q)/30, (For årene 1900 til 2099 er M = 24, og for 1800 til 1899 var M = 23) | M |  |  |  |  |  | Pinsedag
N er resten ved divisionen (4+k-q)/7. (For årene 1900 til 2099 er N = 5, og for 1800 til 1899 var N = 4) | N |  |  |  |  |  | 2. pinsedag
d er resten ved divisionen (19a+M)/30, | d |  |  |  |  |  | juleaften
e er resten ved divisionen (2b+4c+6d+N)/7, | e |  |  |  |  |  | julesdag
[NAME]! Nu har vi [NAME]. |  |  |  |  |  |  | 2. juledag
Formlen for påskedag lyder: |  |  |  |  |  |  | nytårsaften
påskedag = den (22+d+e). marts eller den (d+e-9). april, dog med følgende undtagelser:
1. Hvis d = 29 og e = 6, er påskedag ikke den 26., men den 19. april.
2. Hvis d = 28 og e = 6 og desuden a > 10, er påskedag ikke den 25., men den 18. april.
 |  | dato | måned
Påskesøndag:
Spreadsheet: 803341d1667400605-date-and-time-string-text-to-actual-date-time-sample-110-aligw
Sheet: Sheet1

Order Date Time String | Order Date Time | Hour
Jan  21 2022 12:30AM
Jan  1 2022 12:42AM
Jan  1 2022 12:42AM
Jan  1 2022  1:03AM
Jan  1 2022  5:15AM
Jan  1 2022  5:34AM
Jan  1 2022  5:34AM
Jan  1 2022  5:54AM
Jan  1 2022  5:54AM
Jan  1 2022  6:00AM
Jan  1 2022  6:27AM
Jan  1 2022  6:27AM
Jan  1 2022  6:27AM
Jan  1 2022  6:27AM
Jan  1 2022  6:27AM
Jan  1 2022  6:27AM
Jan  1 2022  6:27AM
Jan  1 2022  6:27AM
Jan  1 2022  6:27AM
Spreadsheet: 161489d1339529474-difficult-problem-function-that-considers-the-contents-of-several-cells-example
Sheet: Sheet1

Upcoming Deadlines
Policy Name | Review Date | Policy | Description | Type | Division | Author | Approval | Comments | Date Approved | Review by
 |  | Policy name |  |  |  |  |  |  | 2012-02-02 00:00:00 | 2014-02-01 00:00:00
 |  | Policy name |  |  |  |  |  |  | 2011-11-29 00:00:00 | NA
 |  | Policy name |  |  |  |  |  |  | 2012-03-06 00:00:00 | 2014-03-06 00:00:00
 |  | Policy name |  |  |  |  |  |  | 2012-05-30 00:00:00 | 2013-02-07 00:00:00
 |  | Policy name |  |  |  |  |  |  | 2012-04-03 00:00:00 | 2013-04-03 00:00:00
Spreadsheet: lisa_gang__22226__EPE_MARCH_2002
Sheet: MARCH(17)

To: El Paso Marketing   -  fax # [PHONE]
El Paso Generation   -  fax # [PHONE]
 | 2002-03-17 00:00:00
HR ENDING | HR ENDING | FOUR CORNERS | FOUR CORNERS |  | PALO VERDE | PALO VERDE | PALO VERDE
Pacific | Mountain | SALE | SALE |  | PURCHASE | PURCHASE | PURCHASE
Standard | Standard | EPMI | EPMI |  | AEP | AEP | AEP
Time | Time | 22.25 | 22.25
 |  | CARRY OVER FROM 3/16 | ON GOING DAILY |  | SUNDAY ONLY | SUNDAY ONLY | FOR THE DAY
 |  | 3/1/02-3/31/02 | 3/1/02-3/31/02 |  | 3/17/02-3/17/02 | 3/17/02-3/17/02 | 3/17/02-3/18/02
 |  | EPMI TAG#41484 | EPMI TAG#41506 |  | AEP TAG#7137 | AEP TAG#7135 | AEP TAG#7138 |  | TOTAL NET | NET PALO VERDE | NET FOUR CORNERS | NET EDDY
PST | MST | DIRECT BILL | DIRECT BILL |  | DIRECT BILL | DIRECT BILL | DIRECT BILL
2400 | 0100 | 25 | 0 |  | 0 | 0 | 0
0100 | 0200 | 0 | 25 |  | 0 | 0 | -25
0200 | 0300 | 0 | 25 |  | 0 | 0 | -25
0300 | 0400 | 0 | 25 |  | 0 | 0 | -25
0400 | 0500 | 0 | 25 |  | 0 | 0 | -25
0500 | 0600 | 0 | 25 |  | 0 | 0 | -25
0600 | 0700 | 0 | 25 |  | 0 | 0 | -25
0700 | 0800 | 0 | 25 |  | -25 | -25 | -25
0800 | 0900 | 0 | 25 |  | -25 | -25 | -25
0900 | 1000 | 0 | 25 |  | -25 | -25 | -25
1000 | 1100 | 0 | 25 |  | -25 | -25 | -25
1100 | 1200 | 0 | 25 |  | -25 | -25 | -25
1200 | 1300 | 0 | 25 |  | -25 | -25 | -25
1300 | 1400 | 0 | 25 |  | -25 | -25 | -25
1400 | 1500 | 0 | 25 |  | -25 | -25 | -25
1500 | 1600 | 0 | 25 |  | -25 | -25 | -25
1600 | 1700 | 0 | 25 |  | -25 | -25 | -25
1700 | 1800 | 0 | 25 |  | -25 | -25 | -25
1800 | 1900 | 0 | 25 |  | -25 | -25 | -25
1900 | 2000 | 0 | 25 |  | -25 | -25 | -25
2000 | 2100 | 0 | 25 |  | -25 | -25 | -25
2100 | 2200 | 0 | 25 |  | -25 | -25 | -25
2200 | 2300 | 0 | 25 |  | -25 | -25 | -25
2300 | 2400 | 0 | 25 |  | 0 | 0 | -25
2400 | 0100 | 0 | 25 |  | 0 | 0 | -25
 | MST Total |  |  |  |  |  |  |  |  |  |  |  | Today's Scheduled MWh
 |  |  |  | TOTAL SALES |  |  |  | TOTAL PURCHASES
 | PST TOTAL
 |  | EPE(G)4C | EPE(G)4C |  | SRP(G)PV | IID(G)PV | IID(G)SANJUAN
 |  | EPMI | EPMI |  | CORAL | IID(T)PV5/PV5 | TEP(T)SANJUNA/WW/PV
 |  | AZPS(T)FC3/PPD2 | AZPS(T)FC3/PPD2 |  | AEP | IID | IID
 |  | WALC(T)PPD2/COOLIDGE | WALC(T)PPD2/COOLIDGE |  | EPE | AEP | IPC
 |  | CRSP(L)COOLIDGE | CRSP(L)COOLIDGE |  | EPMI | EPE | AEP
 |  |  |  |  | EPE | EPMI | EPE
 |  |  |  |  | EPE(T)PV/WW | EPE | EPMI
 |  |  |  |  | TEP(T)WW/SP3 | EPE(T)PV/WW | EPE
 |  |  |  |  | EPE(T)SP3/LUNA | TEP(T)WW/SP3 | EPE(T)PV/WW
 |  |  |  |  | EPE(L)LUNA | EPE(T)SP3/LUNA | TEP(T)WW/SP3
 |  |  |  |  |  | EPE(L)LUNA | EPE(T)SP3/LUNA
 |  |  |  |  |  |  | EPE(L)LUNA
Spreadsheet: 856748d1705940492-lookup-4000-lines-to-40-columns-look
Sheet: forum

 |  |  |  | Code | CodeGroup | CodeType | Description | Field1 | LineColour | LineForce | LineLayer | LineLTScale | LinePOWCommit | LinePWClose | LineStyle | LineThick | PointColour | PointLayer | PointModel | PointNoUpload | PointPtRotate | PointSize | [NAME] | ShapeColour | ShapeLayer | ShapeLTScale | ShapeStyle | ShapeThick | SymbolLayer | SymbolName | SymbolSize | TextAlign | TextBlanksOK | TextColour | TextLayer | TextReadable | TextString | TextStyle | TextXOffset | TextYOffset | Transfer
1 | Code | [SCAN]
2 | Description | GPR Scan
3 | Transfer
4 | CodeGroup
5 | CodeType | 0x0000000b
6 | PointLayer | FPS-UG-GPR_SCAN
7 | [NAME] | Dot
8 | PointColour | 122
9 | PointSize | 6
10 | PointModel | 0
11 | LineLayer | FPS-UG-GPR_SCAN
12 | LineStyle | GPR Scan
13 | LineColour | 122
14 | LineThick | 0.09
15 | LineLTScale | 0.1
16 | TextLayer | FPS-UG-GPR_SCAN
17 | TextStyle | Feature Text
18 | TextColour | 122
19 | TextAlign | 4
20 | TextString | %I1%\n%REM%
21 | Field1 | I1,"Scan No.",2,
22 | Code | [PFRL]
23 | Description | Flat Roof Level
24 | Transfer
25 | CodeGroup
26 | CodeType | 0x00000009
27 | PointLayer | FPS-BUILDING
28 | [NAME] | Plus
29 | PointSize | 2
30 | PointModel | 0
31 | TextLayer | FPS-LEVELS
32 | TextStyle | Feature Text
33 | TextColour | 7
34 | TextString | Flat Roof\n%.2PZ%
Spreadsheet: 725385d1616663763-overtime-hours-between-two-datetimes-relative-to-custom-weekly-schedule-overtime
Sheet: Overtime

Table 1
Day of week | WEEKDAY | Work time start | Work time end | Standard hours worked
Monday | 1
Tuesday | 2
Wednesday | 3
Thursday | 4
Friday | 5
Saturday | 6
Sunday | 7
Holidays | 2021-03-30 00:00:00
Holidays | 2021-03-31 00:00:00
Table 2 |  |  |  |  |  | Table 3
Start datetime | Stop datetime | Total hours worked | Standard hours worked | Overtime hours worked |  | Total hours worked | Standard hours worked | Overtime hours worked
2021-03-23 05:00:00 | 2021-03-25 06:00:00 |  | 32
2021-03-23 05:00:00 | 2021-03-25 08:00:00 |  | 33.5
2021-03-23 05:00:00 | 2021-03-25 23:00:00 |  | 48
2021-03-22 22:00:00 | 2021-03-25 23:00:00 |  | 48.50000000011642
2021-03-25 22:00:00 | 2021-03-27 14:30:00 |  | 17.5
2021-03-26 03:00:00 | 2021-03-26 16:30:00 |  | 9
2021-03-26 07:00:00 | 2021-03-29 06:30:00 |  | 8.5
2021-03-29 07:00:00 | 2021-03-31 16:30:00 |  | 15.5
Spreadsheet: 63622d1264519289-using-vlookup-command-example
Sheet: Sheet1

Last Name | First Name | Date of Birth | Last, First | Last, First Imported
[NAME] | [NAME] | 1993-03-02 00:00:00 |  | [NAME], [NAME]
[NAME] | Kaitlyn | 1995-02-21 00:00:00 |  | Attles, [NAME]
[NAME] | [NAME] | 1995-06-22 00:00:00 |  | [NAME], [NAME]
[NAME] | Victoria | 1995-08-29 00:00:00 |  | [NAME], [NAME]
Aston | [NAME] | 1994-12-12 00:00:00 |  | [NAME], [NAME]
Attles | Morgan | 1994-11-01 00:00:00 |  | Boostah, [NAME]
Avrey | Mohamed | 1994-05-19 00:00:00 |  | Bowser, [NAME]
Spreadsheet: 853911d1703861818-material-run-out-plan-plan-materialv3
Sheet: Sheet1

 |  | material stock type 1 kg | 800
 |  | Material On Order | 0
 |  | part | 1358 |  |  | 1356 |  |  | 1360
 |  | run qty | 600 |  |  | 200 |  |  | 600
 |  | Weight kg each | 0.8 |  |  | 0.5 |  |  | 0.7
 |  | rate per 16hr day | 50 |  |  | 20 |  |  | 60
 |  | date start | 2023-10-31 08:00:00 |  |  | 2023-11-04 08:00:00 |  |  | 2023-11-08 08:00:00
 |  | Date | Qty/Day | [NAME] |  | Qty/Day | [NAME] |  | Qty/Day | [NAME]
 |  | 2023-10-30 08:00:00