tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 209692d1359160842-need-a-cells-ouput-to-be-copyable-and-protected-example
Sheet: Sheet1 (2)

 | CONTEXTUAL LINKS
 |  | URL |  | ANCHOR TEXT |  | ANCHOR TEXT |  | URL |  | ANCHOR TEXT |  | COPY NEW LINK
 | {<a href=" | PASTE | "> | PASTE | </a>|<a title=" | PASTE | "href=" | PASTE | " target={_blank|self}"> | PASTE | </a>}
 | PICTURE LINKS
 |  | PIC URL'S |  | ANCHOR TEXT |  | ANCHOR TEXT |  | PIC URL'S |  | PIC URL'S |  | ANCHOR TEXT |  | COPY NEW LINK
 | <img {src=" | PASTE | "{alt=" | PASTE | "|} border={0|1|2}" align="{left|right|center}"|alt=" | PASTE | "border={0|1|2}" src=" | PASTE | "align={left|right|center}"|border="{0|1|2}" align="{left|right|center}"src=" | PASTE | " {alt=" | PASTE | "|}}></img>
Spreadsheet: 712392d1610192561-rolling-12-week-total-or-average-formula-test
Sheet: Sheet1

cust | date | cases | lines | week | Packed on time? |  |  |  |  | cust | Orders | cases | lines | pass | fail | On Time %
123 | 2020-12-09 00:00:00 | 100 | 10 | 50 | Pass |  |  |  |  | 123
abc | 2020-12-15 00:00:00 | 10 | 1 | 51 | Fail |  |  |  |  | abc
def | 2020-12-24 00:00:00 | 2000 | 100 | 51 | Fail |  |  |  |  | def
123 | 2021-01-01 00:00:00 | 10 | 10 | 52 | Pass
abc | 2021-01-08 00:00:00 | 150 | 15 | 1 | Pass
def | 2021-01-15 00:00:00 | 250 | 10 | 2 | Fail
def | 2021-01-21 00:00:00 | 100 | 10 | 3 | Fail
123 | 2020-08-01 00:00:00 | 100 | 10 | 40 | Pass
123 | 2020-08-02 00:00:00 | 100 | 10 | 40 | Pass
123 | 2020-08-03 00:00:00 | 100 | 10 | 40 | Pass
123 | 2020-08-04 00:00:00 | 100 | 10 | 40 | Pass
Spreadsheet: 877576d1724387582-reverse-search-reverse-search
Sheet: Sheet1

Reverse Search
 |  |  |  |  |  |  |  |  | Expected Result
Outlet | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 |  | Top | Value | Outlet | Month
1 | 8632 | 1719 | 7166 | 8908 | 4673 |  | 1 |  | 2 | 2024-01-01 00:00:00
2 | 9553 | 7818 | 7983 | 3247 | 3519 |  | 2 |  | 4 | 2024-02-01 00:00:00
3 | 8039 | 8710 | 6913 | 5827 | 5868 |  | 3 |  | 1 | 2024-04-01 00:00:00
4 | 4043 | 9111 | 6654 | 4104 | 4122
5 | 1096 | 5074 | 8876 | 1657 | 6644
Spreadsheet: 788966d1658825555-collate-data-from-other-sheets-by-list-selection-sample
Sheet: Master

 |  | Hours Actual | Hours Target | Contract Actual | Contract Target |  |  |  |  |  |  | Outs Training | Outs Other
 | Store
 | Store 1
 | Store 2
 | Store 3
 | Store 4
 | Store 5
 | Store 6
 | Store 7
 | Store 8
 | Store 9
 | Store 10
 | Store 11
 | Store 12
 | Store 13
 | Store 14
 | Store 15
 | Store 16
 | Store 17
 | Area Total
Spreadsheet: 83054d1283101999-creating-text-combinations-given-two-base-texts-sample
Sheet: Sheet1

[NAME] | Bailey | [NAME]
 |  | [NAME]
 |  | A Bailey
 |  | [NAME]
 |  | Bailey A
 |  | Bailey
 |  | [NAME]
 |  | [NAME]
 |  | Ba Alex
 |  | [NAME]
 |  | [NAME]
 |  | Bailey
First name | Surname name
[NAME] | Bailey
[NAME] | [NAME]
[NAME] | West
Spreadsheet: a60d3247-bfe4-4dbd-b540-b2a5b7029279
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
LPAWS | Test | LPAWS | [NAME] (a) Cholesterol, Serum | Lp(a) Cholesterol, S | Electrophoresis, Enzyme Staining, and [NAME] |  |  |  |  | mg/dL | Collection Container/Tube:  Preferred: Red top Acceptable: Serum gel Submission Container/Tube: Plastic vial [NAME]: 0.4 mL Collection Instructions: Fasting (8 hours) | 0.4 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | Lp(a) CHOLESTEROL Normal: <3 mg/dL Suggests increased risk of coronary artery disease: > or =3 mg/dL  LpX Undetectable | Monday through Friday; 10 a.m. | 2 days (not reported on Saturday or Sunday) | 5 days | 1 | 82664 |  |  |  |  | Rochester
LPAWS | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
LPAWS | Result | 2849 | Lp(a) Cholesterol | Lp(a) Cholesterol | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 10835-7 | [NAME] (little a):MCnc:Pt:Ser/Plas:Qn:
LPAWS | Result | 23924 | LpX | LpX | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42178-4 | [NAME].X:ACnc:Pt:Ser/Plas:[NAME]:
LPAWS | Result | 23937 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59462-2
Spreadsheet: larry_campbell__20958__EOTT tanks tx NM
Sheet: Stations from EOTT Map

 | Facility | Legal
 | Addison Station |  |  | The highlighted facilities are not shown on the
 | Beeson Station |  |  | Texas/New Mexico spreadsheet.
 | [NAME] | Sec 20 T18S-R36E
 | Canfield
 | Caprock Station | Sec 1  T17S-R32E
 | Culwin
 | [NAME] | Sec 12 T22S-R38E
 | [NAME] | Sec 15 T15S-R37E
 | [NAME] | Sec 11 T26S-R36E
 | [NAME]
 | [NAME] | Sec 27 T21S-R36E
 | [NAME]
 | Hugh Station | Sec 15 T22S-R37E
 | Junction Station | Sec 27 T16S-R36E
 | Kemnitz Station | Sec 18 T16S-R34E
 | Kimbro Station | Sec 22  T17S-R37E
 | [NAME] | Sec 31 T13S-R32E
 | Lazy "J" Station | Sec 2  T14S-R33E
 | [NAME] | Sec 19 T20S-R37E
 | [NAME]
 | Loco Hills
 | [NAME] | Sec 11 T18S-R32E
 | Loving Yard Station
 | [NAME] | Sec 1  T16S-R36E
 | [NAME] | Sec 6  T17S-R37E
 | [NAME] | Sec 6  T20S-R32E
 | Lynch Station | Sec 1  T21S-R33E
 | [NAME] | Sec 31 T18S-R32E
 | [NAME] | Sec 27 T16S-R33E
 | Manning Station
 | Masteller Station
 | McKee Station | Sec 11  T21S-R37E
 | Poker Lake Station
 | Sanders Station | Sec 22 T13S-R33E
 | [NAME] | Sec 5  T18S-R35E
 | Shipp Station | Sec 3  T16S-R37E
 | Shugart Station
 | [NAME]
 | Townsend Station | Sec 11 T16S-R35E
 | [NAME] | Sec 35 T18S-R37E
 | Young Deep Station | Sec 9  T19S-R32E
Spreadsheet: 169603d1342976755-how-do-i-make-e-mail-groups-to-auto-populate-a-new-e-mail-ready-for-me-to-fill-in-body-and-my-incident-log-matrix-draft
Sheet: Incident Calls

Date: |  |  |  | Time: |  |  |  |  |  |  |  |  |  | From: |  |  |  |  |  |  |  |  |  |  |  |  | Time:
To |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Description
drop down box
 |  | Incident Email Group |  |  |  | e-mail group |  |  |  | CEO |  |  |  | Vice president |  |  |  | Marketing Dept |  |  |  | Finance Dept |  |  |  | Employee Relations |  |  |  | Staff
Notify:
Time Notified:
Initials:
 |  | [NAME] AFSD-Inspections Cell: 758-0305 |  |  |  | Manager Head |  |  |  | Assnt. Mngr> |  |  |  | Engineering Sup |  |  |  | Engineering staff |  |  |  | Houston Executive Staff |  |  |  | Huston CEO |  |  |  | Distribution Center Head
Notify:
Time Notified:
Initials:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IR Summary
 |  | MKE Airport OPS 747-5325 (see comment)
Notify:
Time Notified:
Initials:
Notify:
Time Notified:
Initials:
CC Officers:
Sensitive Security Information WARNING: This record contains Sensitive Security Information that is controlled under 49 CFR parts 15 and 1520. No part of this record may be disclosed to persons without a “need to know”, as defined in 49 CFR parts 15 and 1520, except with the written permission of the Administrator of the Transportation Security Administration or the Secretary of Transportation. Unauthorized release may result in civil penalty or other action. For U.S. government agencies, public disclosure is governed by 5 U.S.C. 552 and 49 CFR parts 15 and 1520.
Date: |  |  |  | Time: |  |  |  |  |  |  |  |  |  |  |  |  | Incident Location: |  |  |  |  |  |  |  |  |  | IR #:
Incident Timeline
Time | Actions and Significant Information |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Initials
CC Officers(s):
Sensitive Security Information WARNING: This record contains Sensitive Security Information that is controlled under 49 CFR parts 15 and 1520. No part of this record may be disclosed to persons without a “need to know”, as defined in 49 CFR parts 15 and 1520, except with the written permission of the Administrator of the Transportation Security Administration or the Secretary of Transportation. Unauthorized release may result in civil penalty or other action. For U.S. government agencies, public disclosure is governed by 5 U.S.C. 552 and 49 CFR parts 15 and 1520.
Spreadsheet: 67685d1268246693-excel-2007-how-to-add-only-positive-numbers-in-my-sumif-statement-test3-10
Sheet: Processing

Qty | OrderItemIdentifier | Model No. - Description | ModelPart | SerialNumber | Date RX'ed | Received By | Notes | Date P/U | Picked Up By
1 | [PHONE]--1 | xyz | 1234 | 456asd4561 | 2010-03-03 00:00:00
1 | [PHONE]--5 | XPR6350 | AAH55TDC9LA1 | 555GGG5555 | 2010-03-03 00:00:00
1 | [PHONE]--2 | ABC | 4567 | 111AAA3333 | 2010-03-03 00:00:00
1 | [PHONE]--3 | CP200 | AAH50RDC9AA1 - CP200  UHF  4CH | 222SSS3333 | 2010-03-03 00:00:00
500 | [PHONE]--4 | COAX | LMR400 | 0 | 2010-03-03 00:00:00
15 | [PHONE]--6 | BATTERY | [NAME] | 0 | 2010-03-03 00:00:00
-5 | [PHONE]--6 | BATTERY | [NAME] | 0 |  |  |  | 2010-03-04 00:00:00
500 | [PHONE]--4 | COAX | LMR400 | 0 | 2010-03-04 00:00:00
-500 | [PHONE]--4 | COAX | LMR400 | 0 |  |  |  | 2010-03-04 00:00:00
-10 | [PHONE]--6 | BATTERY | [NAME] | 0 |  |  |  | 2010-03-04 00:00:00
Spreadsheet: 122117d1316620519-using-sumif-to-show-win-loss-when-1-team-plays-4-others-nfl-example4
Sheet: Sheet1

 | Table 1 is ok |  |  |  |  |  |  |  | These columns will run to include the whole season
Table 1 |  | Wins | Loss | Home Win | Home Loss | Road Win | Road Loss
 |  |  |  |  |  |  |  |  | Week 3
 | Jacksonville | 3 | 1 | 1 | 1 | 2 | 0 |  | Jacksonville | 24 | 21 | Carolina
 | Tampa Bay | 3 | 1 | 2 | 1 | 1 | 0 |  | Tampa Bay | 28 | 7 | Cincinatti
 | Atlanta | 4 | 0 | 1 | 0 | 3 | 0 |  | Atlanta | 30 | 16 | Buffalo
 | Denver | 0 | 4 | 0 | 3 | 0 | 1 |  | Denver | 3 | 9 | New Orleans
 | Carolina | 2 | 2 | 1 | 1 | 1 | 1
 | Cincinatti | 0 | 4 | 0 | 2 | 0 | 2 |  | Week 12
 | Buffalo | 2 | 2 | 0 | 1 | 2 | 1 |  | Carolina | 20 | 10 | Cincinatti
 | New Orleans | 2 | 2 | 2 | 0 | 0 | 2 |  | Jacksonville | 42 | 35 | Tampa Bay
 |  |  |  |  |  |  |  |  | Buffalo | 19 | 22 | New Orleans
 |  |  |  |  |  |  |  |  | Atlanta | 13 | 9 | Denver
 |  |  |  |  |  |  |  |  | Week 16
 |  |  |  |  |  |  |  |  | Atlanta | 6 | 3 | Jacksonville
 |  |  |  |  |  |  |  |  | Cincinatti | 28 | 35 | Tampa Bay
 |  |  |  |  |  |  |  |  | New Orleans | 19 | 22 | Carolina
 |  |  |  |  |  |  |  |  | Buffalo | 13 | 9 | Denver
 | In table 2 I just want to pick out the wins and losses where Jacksonville and Carolina play each other |  |  |  |  |  |  |  | Week 17
 |  |  |  |  |  |  |  |  | New Orleans | 6 | 10 | Jacksonville
Table 2 | Table 2 is ok |  |  |  |  |  |  |  | Cincinatti | 28 | 35 | Tampa Bay
 |  |  |  |  |  |  |  |  | Carolina | 19 | 22 | Atlanta
 |  |  |  |  |  |  |  |  | Buffalo | 13 | 9 | Denver
 | Carolina | Wins | Loss
 | Jacksonville | 1 | 0
Table 3 | As table 2 but Jacksonville need to play Atlanta, New Orleans, Tampa Bay & Carolina. So table 3 should read like this
 | Atlanta
 | New Orleans
 | Tampa Bay
 | Carolina | Wins | Loss
 | Jacksonville | 2 | 2
Spreadsheet: 491988d1480738149-pulling-a-value-on-several-sheets-based-on-name-of-the-sheet-and-another-variable-book
Sheet: Rankings

 | Y/P
Arizona
Atlanta
Baltimore
Buffalo
Carolina
Chicago
Cincinnati
Cleveland
Dallas
Denver
Detroit
Green Bay
Houston
Indianapolis
Jacksonville
Kansas City
Los Angeles
Miami
Minnesota
New England
New Orleans
New York Giants
New York Jets
Oakland
Philadelphia
Pittsburgh
San Diego
San Francisco
Seattle
Tampa Bay
Tennessee
Washington
Spreadsheet: 728808d1618664664-lookup-value-to-see-if-it-exists-within-a-range-and-use-for-formatting-test-location
Sheet: Test devices

ANTENNAS
DEVICES | DISTANCE IN METRES
Device1 | 100 - 500 | 100 | 500
Device2 | 501 - 1200 | 501 | 1200
Device3 | 501 - 1200 | 501 | 1200
Device4 | 1500 - 4000 | 1500 | 4000
Device5 | 1210 - 8000 | 1210 | 8000
Device6 | 1210 - 8000 | 1210 | 8000
Device7 | 8100 + | 8100 | 1e+47
Device8 | 10000 | 1000 | 1e+47
Spreadsheet: 129637d1321769928-vlookup-vlookupwork
Sheet: list

PC-Market
 | Product ID |  |  |  |  |  | Product ID | Type | Model | Price | Quantity | Shipping | Shipping Cost
 | 1050
 |  |  |  |  |  |  | 1050 | ISDN | samsung | 100 | 4 | asd | 2
 |  |  |  |  |  |  | 1051 | DSL | samesung | 200 | 5 | dfg | 5
 |  |  |  |  |  |  | 1052 | ISDN/DSL | sesamesung | 300 | 6 | ghj | 6
 | Type | Model | Price | Quantity
FORMULAS
Spreadsheet: 84713d1284720751-find-out-the-grand-total-from-different-sheets-on-a-summary-sheet-book1
Sheet: Sheet5

OIL ENGINE 10 W 30 - SJ GRADE | 1100661 | 115
COVER CYLINDER HEAD | 12301-GB6-9000 | 116
COVER R CYLINDER HEAD SIDE | 12331-GB0-9100 | 117
GASKET CYLINDER HD L SIDE COVER | 12394-GW8-6810 | 121
GASKET CYLINDER HD R SIDE COVER | 12395-GW8-6810 | 122
SPARK PLUG | 98056-57718-01 | 123
NUT CAP 7MM | 90201-GF6-0000 | 124
WASHER SEALING 7 MM | 90442-GF6-0000 | 125
Spreadsheet: 168257d1342350897-conditional-format-condtional-formats
Sheet: Soution

RANK | RATEE | Assigned To | Date Assigned | Days in your Que | Dates due to Mgt | Days due to CSS | CLOSE OUT
Superintendent | [NAME] | [NAME] | 2012-05-01 00:00:00 |  |  |  | 2012-07-12 00:00:00
[NAME] | [NAME] | [NAME] | 2012-05-20 00:00:00 |  |  |  | 2012-07-25 00:00:00
 | RED | =E3<50
 | YELLOW | =AND(E3>50,E3<=60)
 | GREEN | =E3>60
I ve changed th formula and now condiotnal formula check trhe Day in your que! I think it will solve the problem or ???
So here, I have a [NAME] and a Super…  Foremam:  the report was assined to [NAME] on 20 Jun 2012.  It has been in her que for 25 days.  The report wil close out on 25 August.  So if today's date is 50 days or less then the close out date, the cell will turn red. And for superintendent will turn red if today's date is within 45 days of the closeout date.                   Do we need a cell that has (TODAY) - the Close out date???
 |  |  |  |  |  |  |  | Foreman 50 & 40
 |  |  |  |  |  |  |  | Super 45 & 35
Spreadsheet: andy_zipper__164__DYNEGY-ICE VOL Apr5
Sheet: ICE-EPM

Enron Power Marketing
Activity on ICE
UOM | Deals | Volume
MWhs
 |  |  |  |  |  |  | START | END
Enron Power Marketing, Inc.
Commodity Type:  All
Instruments:  All
Trade Dates:  Apr-5-01 thru Apr-5-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
Apr-05-01 | 188764350 |  | Sold | Firm-LD Peak | Mid C | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | Morgan Stanley Capital Group, Inc. | 320 | USD / MWh | 25 | Hourly | 10400 | MWhs | Motley, M
Apr-05-01 | 901190242 |  | Sold | Firm-LD Peak | Mid C | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | Morgan Stanley Capital Group, Inc. | 320 | USD / MWh | 25 | Hourly | 10400 | MWhs | Motley, M
Apr-05-01 | 772847138 |  | Bought | Firm-LD Peak | Palo | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | El Paso Merchant Energy L.P. | 295 | USD / MWh | 25 | Hourly | 10400 | MWhs | Fischer, M
Apr-05-01 | 118649089 |  | Bought | Firm-LD Peak | Palo | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | El Paso Merchant Energy L.P. | 296.5 | USD / MWh | 25 | Hourly | 10400 | MWhs | Fischer, M
Apr-05-01 | 186654527 |  | Bought | Firm-LD Peak | Palo | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | El Paso Merchant Energy L.P. | 301 | USD / MWh | 25 | Hourly | 10400 | MWhs | Motley, M
Apr-05-01 | 138035625 |  | Bought | Firm-LD Peak | Cin | Next Week | Apr-09-01 | Apr-13-01 |  |  |  | El Paso Merchant Energy L.P. | 48.75 | USD / MWh | 50 | Hourly | 4000 | MWhs | Dorland , C
Apr-05-01 | 269403924 |  | Bought | Firm-LD Peak | TVA | Next Day | Apr-09-01 | Apr-09-01 |  |  |  | Reliant Energy Services, Inc. | 55.5 | USD / MWh | 50 | Hourly | 800 | MWhs | Carson , M
Apr-05-01 | 187494366 |  | Sold | Firm-LD Peak | Cin | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | Aquila Energy Marketing Corp | 51.1 | USD / MWh | 500 | Hourly | 176000 | MWhs | [NAME], R
Apr-05-01  Deals
Spreadsheet: 124448d1318422667-find-case-and-diacritics-insensitive-duplicates-in-one-column-sortdiacriticinsensitive
Sheet: Sheet1

bear | itger | BEAR | 2
best | fdkl | BEST | 1
Best | dfjkl | BEST | 1
BEST | ghfjkl | BEST | 1
bést | djk | BEST | 1
bright | hgjkl | BRIGHT | 2
fretiller | gfjkl | FRETILLER | 1
FRETILLER | ggdf | FRETILLER | 1
frétiller | jhj | FRETILLER | 1
Frétiller | fhf | FRETILLER | 1
near | trhn | NEAR | 2
SHINE | ghfjkl | SHINE | 1
shine | gfd | SHINE | 1
[NAME] | [NAME] | SHINE | 1
Spreadsheet: michelle_lokay__26563__imbalsumm0012
Sheet: NW

 | LaPlata Recpt |  | LaPlata Delivery
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly |  | Monthly
Day | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56419 | 500516 | 500535 | 500539 | [NAME] | Index | Dollars
1 | 105467 |  |  | 77908 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-02-01 00:00:00 |  |  |  |  |  | 1.57
2 | 131083 |  |  | 45263 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-03-01 00:00:00 |  |  |  |  |  | 1.84
3 | 134074 | 161714 |  | 31644 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-04-01 00:00:00 |  |  |  |  |  | 1.91
4 | 147980 | 162355 |  | 16460 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-05-01 00:00:00 |  |  |  |  |  | 2.21
5 | 145971 | 164906 |  | 22551 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-06-01 00:00:00 |  |  |  |  |  | 1.67
6 | 127718 |  |  | 45207 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-07-01 00:00:00 |  |  |  |  |  | 1.8
7 | 172839 |  |  | 8766 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-08-01 00:00:00 |  |  |  |  |  | 1.88
8 | 168553 |  |  | 21417 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-09-01 00:00:00 |  |  |  |  |  | 2.02
9 | 147907 |  |  | 28501 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-10-01 00:00:00 |  |  |  |  |  | 1.81
10 | 156409 |  |  | 11318 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-11-01 00:00:00 |  |  |  |  |  | 1.79
11 | 123568 | 164677 |  | 40741 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-12-01 00:00:00 |  |  |  |  |  | 2.28
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-01-01 00:00:00 |  |  |  |  |  | 1.94
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-02-01 00:00:00 |  |  |  |  |  | 2.2
14
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-04-01 00:00:00 |  |  |  |  |  | 1.74
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-05-01 00:00:00 |  |  |  |  |  | 1.58
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-06-01 00:00:00 |  |  |  |  |  | 1.6
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2000-11-30 00:00:00 |  |  |  | -75432
 | 2000-12-11 00:00:00
Spreadsheet: 45305f14-a3ef-499d-a190-cc6fa9962f1b
Sheet: Sheet1

Release: BEA Regions Housing Units Authorized By Building Permits | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=173
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-04-19 1:03 AM [NAME]
 | Real-Time | Period
Name: | Start | End
BEA Regions Housing Units Authorized By Building Permits | 2008-07-25 00:00:00 | Current
Link:
http://www.census.gov/const/www/permitsindex.html | 2008-07-25 00:00:00 | Current
Source:
Federal Reserve Bank of St. Louis | 2008-07-25 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2008-07-25 00:00:00
2008-08-26 00:00:00
2008-09-25 00:00:00
2008-10-27 00:00:00
2008-11-26 00:00:00
2008-12-23 00:00:00
2009-01-29 00:00:00
2009-02-26 00:00:00
2009-03-25 00:00:00
2009-04-24 00:00:00
2009-05-27 00:00:00
2009-06-24 00:00:00
2009-07-27 00:00:00
2009-08-26 00:00:00
2009-09-25 00:00:00
2009-10-27 00:00:00
2009-11-25 00:00:00
2009-12-23 00:00:00
2010-01-28 00:00:00
2010-02-25 00:00:00
2010-03-24 00:00:00
2010-04-26 00:00:00
2010-05-26 00:00:00
2010-06-24 00:00:00
2010-07-27 00:00:00
2010-08-25 00:00:00
2010-09-27 00:00:00
2010-10-27 00:00:00
2010-11-24 00:00:00
2010-12-23 00:00:00
2011-01-27 00:00:00
2011-02-25 00:00:00
2011-03-24 00:00:00
2011-04-26 00:00:00
2011-05-25 00:00:00
2011-06-24 00:00:00
2011-07-27 00:00:00
2011-08-24 00:00:00
2011-09-27 00:00:00
2011-10-27 00:00:00
2011-11-28 00:00:00
2011-12-23 00:00:00
2012-01-27 00:00:00
2012-02-27 00:00:00
2012-03-26 00:00:00
2012-04-25 00:00:00
2012-05-24 00:00:00
2012-06-26 00:00:00
2012-07-26 00:00:00
2012-08-24 00:00:00
2012-09-27 00:00:00
2012-10-25 00:00:00
2012-11-29 00:00:00
2012-12-28 00:00:00
2013-01-28 00:00:00
2013-02-27 00:00:00
2013-03-26 00:00:00
2013-04-24 00:00:00
2013-05-24 00:00:00
2013-06-26 00:00:00
2013-07-25 00:00:00
2013-08-26 00:00:00
2013-09-26 00:00:00
2013-11-27 00:00:00
2013-12-24 00:00:00
2014-01-28 00:00:00
2014-02-27 00:00:00
2014-03-26 00:00:00
Spreadsheet: 885119d1734539378-help-with-timesheet-overtime-and-night-calculation-example-timesheet
Sheet: AFTER

Current |  |  |  |  |  |  | NEW
Date | 1st Shift |  | 2nd Shift |  | Lunch Dinner Break | Total Worked | OT | Normal Night hours | OT  Night hours
 | Time in | Time out | Time out | Time out
1 | 19:00:00 | 1900-01-01 00:00:00 | 00:00:00 | 07:00:00 | 01:00:00 |  |  |  |  |  | Yellow is the desired Thank you!
2 | 05:00:00 | 15:00:00 |  |  | 01:00:00
3 | 07:00:00 | 17:00:00 |  |  | 00:30:00
4 | 08:00:00 | 16:30:00 |  |  | 00:30:00
5 |  |  |  |  | 00:30:00
6 |  |  |  |  | 00:30:00
7 |  |  |  |  | 00:30:00
8 |  |  |  |  | 00:30:00
9 |  |  |  |  | 00:30:00
10 |  |  |  |  | 00:30:00
11 |  |  |  |  | 00:30:00
12 |  |  |  |  | 00:30:00
13 |  |  |  |  | 00:30:00
14 |  |  |  |  | 00:30:00
15 |  |  |  |  | 00:30:00
16 |  |  |  |  | 00:30:00
17 |  |  |  |  | 00:30:00
18 |  |  |  |  | 00:30:00
19 |  |  |  |  | 00:30:00
20 |  |  |  |  | 00:30:00
21 |  |  |  |  | 00:30:00
22 |  |  |  |  | 00:30:00
23 |  |  |  |  | 00:30:00
24 |  |  |  |  | 00:30:00
25 |  |  |  |  | 00:30:00
26 |  |  |  |  | 00:30:00
27 |  |  |  |  | 00:30:00
28 |  |  |  |  | 00:30:00
29 |  |  |  |  | 00:30:00
30 |  |  |  |  | 00:30:00
31 |  |  |  |  | 00:30:00
TOTAL
Spreadsheet: 872001d1718366098-selecting-and-moving-specific-data-new-microsoft-excel-worksheet-14-aligw
Sheet: Sheet1

date | amount
2023-04-01 00:00:00 | 12,899.24(Cr) |  |  | all (Cr) amounts should be transferred to column C while (Dr) amounts will remain in column B
2023-04-01 00:00:00 | 20,000.00(Dr)
2023-04-02 00:00:00 | 52,892.12(Cr)
2023-04-02 00:00:00 | 100,000.00(Dr)
2023-04-02 00:00:00 | 20,000.00(Cr)
2023-04-02 00:00:00 | 30,000.00(Cr)
2023-04-02 00:00:00 | 9,999.00(Cr)
2023-04-03 00:00:00 | 60,052.89(Cr)
2023-04-03 00:00:00 | 70,000.00(Dr)
2023-04-04 00:00:00 | 30,000.00(Dr)
2023-04-04 00:00:00 | 30,000.00(Cr)
2023-04-05 00:00:00 | 20,265.00(Cr)
2023-04-05 00:00:00 | 20,000.00(Dr)
2023-04-06 00:00:00 | 47,576.64(Cr)
2023-04-06 00:00:00 | 10,320.00(Dr)
2023-04-06 00:00:00 | 40,000.00(Dr)
2023-04-07 00:00:00 | 11,187.83(Cr)
2023-04-07 00:00:00 | 10,000.00(Dr)
2023-04-08 00:00:00 | 11,889.30(Cr)