tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 852232d1702318436-need-to-combine-and-replace-multiple-words-in-col-a-sentence-with-one-string-in-col-b-copy-replace-mutiple-strings-in-cell-with-one-string
Sheet: Sheet1

Original | If Cell contains 3H, Creatinine and Electrolyte, replace  with "Symptom Group 1".
C-Reactive Protein, CRP quantitative, CBC, Creatinine, [NAME], Rajpal kft, Urea, Uric acid
3H, A-one kFT, CBC, Creatinine, Electrolyte, Glucose, Random (RBS), Hepatitis B Surface Antigen (HBsAg) Australia Antigen, Rapid Card, Hepatitis C Total Antibody (Anti HCV), [NAME], HIV 1 & 2 spot test, LFT, Lipid Profile, PTI, Urea, Uric acid
CBC, Creatinine, [NAME], Rajpal kft, SGOT/AST, SGPT/ALT, Urea, Uric acid
3H, A-one kFT, CBC, Creatinine, Culture- urine, Electrolyte, Glucose, Random (RBS), HbA1C, Glycosylated Hemoglobin, Hepatitis B Surface Antigen (HBsAg) Australia Antigen, Rapid Card, Hepatitis C Total Antibody (Anti HCV), [NAME], HIV 1 & 2 spot test, LFT, PTI, Urea, Uric acid, [NAME], Vitamin D
3H, Blood Group ABO & Rh Typing, Blood, CBC, Creatinine, Electrolyte, Hepatitis B Surface Antigen (HBsAg) Australia Antigen, Rapid Card, Hepatitis C Total Antibody (Anti HCV), [NAME], HIV 1 & 2 spot test, [NAME], SGOT/AST, SGPT/ALT, Urea, Uric acid
A-one kFT, CBC, Creatinine, Electrolyte, Urea, Uric acid, [NAME]
CBC, Creatinine, Electrolyte, LFT, Lipid Profile, [NAME], Urea, Uric acid
A-one kFT, CBC, Creatinine, Culture- urine, Electrolyte, Urea, Uric acid, [NAME]
CBC, Creatinine, [NAME], Rajpal kft, Urea, Uric acid, [NAME]
3H, A-one kFT, CBC, Creatinine, Culture- urine, Electrolyte, Glucose, Random (RBS), Hepatitis B Surface Antigen (HBsAg) Australia Antigen, Rapid Card, Hepatitis C Total Antibody (Anti HCV), [NAME], HIV 1 & 2 spot test, LFT, PTI, Urea, Uric acid, [NAME]
3H, A-one kFT, CBC, Creatinine, Culture- urine, Electrolyte, Glucose, Random (RBS), Hepatitis B Surface Antigen (HBsAg) Australia Antigen, Rapid Card, Hepatitis C Total Antibody (Anti HCV), [NAME], HIV 1 & 2 spot test, LFT, PTI, Urea, Uric acid, [NAME]
A-one kFT, CBC, Creatinine, Culture- urine, Electrolyte, Glucose, Random (RBS), LFT, Urea, Uric acid, [NAME], Vitamin D
A-one kFT, CBC, Creatinine, Electrolyte, FSH, Follicle Stimulating Hormone, [NAME], Random (RBS), LFT, Lipid Profile, [NAME], LH, Prolactin, Serum, Testosterone, Urea, Uric acid, [NAME]
A-one kFT, CBC, Creatinine, Culture- urine, Dengue Rapid, Electrolyte, LFT, Urea, Uric acid, [NAME]
A-one kFT, CBC, Creatinine, Electrolyte, Glucose, Random (RBS), LFT, Lipid Profile, Urea, Uric acid, [NAME], Vitamin D
Creatinine, [NAME], Rajpal kft, Urea, Uric acid
Creatinine, [NAME], Rajpal kft, Urea, Uric acid
Amylase, Serum, C-Reactive Protein, CRP quantitative, CBC, Creatinine, Dengue Rapid, Electrolyte, ESR, Erythrocyte Sedimentation Rate, LFT, [NAME], [NAME], Urea, Uric acid, [NAME]
A-one kFT, CBC, Creatinine, Electrolyte, Urea, Uric acid
C-Reactive Protein, CRP quantitative, Creatinine, Electrolyte, HbA1C, Glycosylated Hemoglobin, Lipid Profile, [NAME], Urea, Uric acid
Spreadsheet: 841383d1693566271-automated-table-using-form-results-book1
Sheet: Form1

ID | Start time | Completion time | Are You Joining or Leaving the Tea Bar? | First Name
1 | 8/30/23 7:14:08 | 8/30/23 7:14:42 | Leaving | [NAME]
2 | 8/31/23 7:17:46 | 8/31/23 7:17:56 | Joining | Louis
3 | 8/31/23 7:37:33 | 8/31/23 7:38:24 | Joining | [NAME]
Spreadsheet: 144605d1331055286-using-multiple-if-and-vlookup-functions-sample-excel-problem_alt
Sheet: Patient Input

 | Name | Fruit | Vegetable | Do you Drink? | Do you Smoke? | Do you Exercise? | How Healthy you are
 | [NAME] | Apple | Potato | No | No | Yes |  | <-- Need a formula here which can calculate the health status based on the entries from Column C to G and referring to Tab "Health Status - Fixed" for giving the status
 | [NAME] | Mango | Potato | Yes | No | Yes
 | [NAME]
 |  | Fruit | Vegetable | Do you Drink? | Do you Smoke? | Do you Exercise?
 |  | Apple | Potato | Yes | Yes | Yes
 |  | Mango | Tomato | No | No | No
Spreadsheet: 777373d1650356520-return-values-text-from-one-sheet-into-multiple-sheets-by-comparing-three-columns-book1gk
Sheet: John

Commission |  |  |  | [NAME]
 |  | Full | Discounted
Item | ID | 15 | 10 | Total
Spreadsheet: 850604d1700995461-excel-formula-with-inflow-and-outflow-inflow
Sheet: Tabelle4

Datum | Start | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00
Tage |  |  | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31 | 31
kum Tage
Backlog | 100
Inflow |  | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
Dropout | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
Dauer | 80
[NAME]
Spreadsheet: darrell_schoolcraft__7321__imball0202
Sheet: Dominion

 | Dominion Gas Ventures
 | POI 12354 - Dominion Gas/Tule Lake
Day | Measured | Scheduled
1 |  | 150
2 | 309 | 150
3 | 285 | 150
4 | 252 | 150
5 | 300 | 150
6 | 31 | 150
7 | 4 | 150
8 | 303 | 150
9 | 289 | 150
10 | 146 | 150
11 | 52 | 150
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | 174593.14
2002-02-11 00:00:00
CBS Volume
 |  |  | 76390
Spreadsheet: 677983d1589642889-help-with-a-date-formula-please-2020-05-16-oeldere-majornoms-677972d1589640335-help-with-a-date-formula-please-dummy
Sheet: Sheet1

Date | Payee | Sub-Category | Category | R? | Withdrawl, Payment (-) | Deposit, Credit (+) | Balance | value | Year | Month |  | Transaction Count, by Month
2020-01-01 00:00:00 | Work | Income |  | c |  | 2489.95 |  |  |  |  |  | Month | Count | Average
2020-02-01 00:00:00 | Resturant | Food |  | c | 11.5 |  |  |  |  |  |  | January
2020-02-01 00:00:00 | Resturant | Food |  | c | 12.07 |  |  |  |  |  |  | Feburary
 |  |  |  | Som van value | Kolomlabels
 |  |  |  | Rijlabels | 1 | 2 | Eindtotaal
 |  |  |  | Food |  | -23.57 | -23.57
 |  |  |  | Income | 2489.95 |  | 2489.95
 |  |  |  | Eindtotaal | 2489.95 | -23.57 | 2466.38
Spreadsheet: 695624d1600311969-reference-name-and-date-move-data-to-other-sheet-test-leydet4-
Sheet: Last dates

Name | Station 1
Mason
[NAME]
Atkins
[NAME]
Noye
Chapel
Name | Station 2
Morris
Blanchard
[NAME]
[NAME]
Murphy
Quick
Grey
Name | Station 4
[NAME]
Parsons
Mccoy
Pouns
Shoop
[NAME]
[NAME]
Englund
Name | Station 14
Draper
Soliven
[NAME]
Cromwell
Weiler
Shepard
Spreadsheet: 700173d1603033386-want-to-count-information-in-visable-rows-after-sorting-sample
Sheet: Sheet1

Date | ID# |  |  |  | Total unique dates that are visible:
2020-01-02 00:00:00 | 8
2020-01-02 00:00:00 | 19
2020-01-02 00:00:00 | 114
2020-01-03 00:00:00 | 12
2020-01-03 00:00:00 | 266
2020-01-03 00:00:00 | 327
2020-01-03 00:00:00 | 337
2020-01-03 00:00:00 | 366
2020-01-06 00:00:00 | 12
2020-01-06 00:00:00 | 19
2020-01-06 00:00:00 | 21
2020-01-06 00:00:00 | 328
2020-01-06 00:00:00 | 337
2020-01-06 00:00:00 | 349
2020-01-07 00:00:00 | 14
2020-01-07 00:00:00 | 19
2020-01-07 00:00:00 | 20
2020-01-07 00:00:00 | 43
2020-01-07 00:00:00 | 50
Spreadsheet: 202694d1356695635-hyperlink-opening-problems-book1
Sheet: Sheet1

58 | 74 | File - Regular | 238 | 74 | KALPANABEN MISTRY |  |  |  |  | Uploaded | 2012-09-25 00:00:00 | 2012-10-20 00:00:00 | YES | YES | YES | YES | YES
61 | 77 | File - Regular | 238 | 77 | MUKESHBHAI MISTRY |  |  |  |  | Uploaded | 2012-09-25 00:00:00 | 2012-10-30 00:00:00 | YES | YES | YES | YES | YES
63 | 79 | File - Regular | 238 | 79 | SURESHBHAI MISTRY |  |  |  |  | Uploaded | 2012-09-25 00:00:00 | 2012-10-30 00:00:00 | YES | YES | YES | YES | YES
65 | 81 | File - Regular | 238 | 81 | BHAVANBHAI MISTRY |  |  |  |  | Uploaded | 2012-09-25 00:00:00 | 2012-10-30 00:00:00 | YES | YES | YES | YES | YES
66 | 82 | File - Regular | 238 | 82 | [NAME] |  |  |  |  | Uploaded | 2012-07-30 00:00:00 | 2012-10-10 00:00:00 | YES | YES | YES | YES | YES
Spreadsheet: 275056d1383319950-summary-table-from-input-data-best-way-to-proceed-book8
Sheet: Sheet1

Raw Input Data |  |  |  |  |  |  |  |  | Summary Data
Product | Currency | Value | Frequency | F 1m | B 1m | F 3m | B 3m |  | Product | Currency | Value | Rel 1m | Rel 3m
AAA | USD | 100 | Non-Lagged | 1 | 2 | 3 | 1 |  | AAA | USD | 100
BBB | GBP | 120 | Lagged | 2 | 3 | 2 | 2.5 |  | CCC | EUR | 140
CCC | EUR | 140 | Non-Lagged | 3 | 4 | 1 | 3
Spreadsheet: ddcfa34f-2e33-44cf-9b66-ac736fcb02bc
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Daywind Rec | 614187140529 | Lordsong | Soul Food | 2004-09-28 | Compact Disc | [NAME] | 13.99 | N | To Be Retired
Spreadsheet: 101183d1299308360-data-segregation-ex
Sheet: Raw data

Upfront Reduction (not appr) | Invoice # | Service Date | Product Number
BATCHID: | 02/07/2011EC
Third Party
Trans #: | 76529 | Check#: [PHONE] | Payment:
Account #: | 3133 | NJM INS WC*
Patient Name: | WERWINSKI, NICHOLAS
276579-[PHONE] | 2010-12-20 00:00:00 | COMB0001 | 0
276579-[PHONE] | 2010-12-20 00:00:00 | SKIN0001 | 0
276579-[PHONE] | 2010-12-20 00:00:00 | LOTI0001 | 0
276579-[PHONE] | 2010-12-20 00:00:00 | ELEC0002 | 0
276579-[PHONE] | 2010-12-20 00:00:00 | BATT0002 | 0
276579-[PHONE] | 2010-12-20 00:00:00 | LEAD0001 | 0
276579-[PHONE] | 2010-12-20 00:00:00 | CHAR0001 | 0
276579-[PHONE] | 2010-12-20 00:00:00 | DELI0001 | 0
276579-[PHONE] | 2010-12-20 00:00:00 | SHOU0001 | 0
Carrier Totals: | 0 | 2963.15 | 2963.15
Totals: | 0 | 2963.15 | 2963.15
Trans #: | 76979 | Check#: [PHONE] | Payment:
Account #: | 1945 | MAGNACARE GRP*
Patient Name: | GINI, ADRIANA
241181-[PHONE] | 2010-11-19 00:00:00 | FLET0001 | 0
241181-[PHONE] | 2010-11-19 00:00:00 | SKIN0001 | 0
241181-[PHONE] | 2010-11-19 00:00:00 | LOTI0001 | 0
241181-[PHONE] | 2010-11-19 00:00:00 | ELEC0001 | 0
241184-[PHONE] | 2010-11-30 00:00:00 | BACK0001 | 0
Carrier Totals: | 0 | 2045.59 | 2045.59
Totals: | 0 | 2045.59 | 2045.59
Trans #: | 77062 | Check#: [PHONE] | Payment:
Account #: | 2499 | HORIZON CASUALTY SERVICES WC*
Patient Name: | HOLECZ, CHRISTINA
197298-[PHONE] | 2010-09-22 00:00:00 | FLET0001 | 0
197298-[PHONE] | 2010-09-22 00:00:00 | SKIN0001 | 0
197298-[PHONE] | 2010-09-22 00:00:00 | LOTI0001 | 0
197298-[PHONE] | 2010-09-22 00:00:00 | ELEC0001 | 0
197298-[PHONE] | 2010-09-22 00:00:00 | BATT0004 | 0
197298-[PHONE] | 2010-09-22 00:00:00 | DELI0001 | 0
197308-[PHONE] | 2010-10-22 00:00:00 | SKIN0001 | 0
197308-[PHONE] | 2010-10-22 00:00:00 | LOTI0002 | 0
197308-[PHONE] | 2010-10-22 00:00:00 | ELEC0001 | 0
197308-[PHONE] | 2010-10-22 00:00:00 | BATT0004 | 0
197308-[PHONE] | 2010-10-22 00:00:00 | DELI0001 | 0
197308-[PHONE] | 2010-10-22 00:00:00 | BIOI0001 | 0
Spreadsheet: 705171d1605899202-trouble-creating-formula-to-find-lowest-date-sample2
Sheet: Sheet1

Q1 | DATE1 | Q2 | DATE2 | Q3 | DATE3 | Q4 | DATE4 | Q5 | DATE5 | Q6 | DATE6 | Date + 6 months | Expiration Date
cat1 | 2007-07-07 00:00:00 | cat2 | 2003-03-03 00:00:00 | cat3 | 2010-10-10 00:00:00 | cat4 | 2006-06-06 00:00:00 | cat5 | 2004-04-04 00:00:00 | cat6 | 2011-11-11 00:00:00 | 2008-08-08 00:00:00
Spreadsheet: 004456cc-57a0-4443-87cf-59b327eeac79
Sheet: Internal

Transaction Activity Report
SD_DATRANSACT_<customer id>_<settlement date>_<version>.CSV
<[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
 | Transaction Identifiers |  |  |  | Location
Trading Interval | Transaction Number | Reference ID | Transaction Type | Other Party | Settlement Location ID | Location Name | Location Type | Amount | Impacts Marginal Loss Revenue Allocation
Hour End | Number | String | String | Number | Number | String | String | MWh | Flag
Spreadsheet: matthew_lenhart__26317__West Daily Prices1022-01
Sheet: Sun Curve Sum Backup

 | R7 | R8 | R9 | R10 | R11 | B4 |  | R12 |  |  |  |  |  |  |  |  | R21
1 | 2 | 3 | 4 | 5 | 6 | 7 |  | 9 |  |  |  |  |  |  |  |  | 18
 | WEST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ALBERTA
 | Palo Verde | COB | MID-COLUMBIA | NP15 | SP15 | Mead |  | ZP26 |  |  |  |  |  |  |  |  | ALBERTA
Spreadsheet: 03e0038e-6299-49a6-a6e9-d5d1c2b12b0f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | 2007-2008 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 | JUL | AUG | SEPT | OCT | NOV | DEC | JAN | FEB | MAR | APR | MAY | JUN | YTD
Bibliographic Records
New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Updates | 632 | 965 | 786 | 516 | 599 | 699 | 792 | 798 | 540 | 746 | 369 | 1030 | 8472
Deletions | 7 | 3 | 4 | 8 | 17 | 3 | 6 | 9 | 1 | 6 | 5 | 4 | 73
Item Records
New | 250 | 218 | 225 | 205 | 195 | 294 | 12 | 49 | 1 | 34 | 2 | 3 | 1488
Updates | 273 | 625 | 244 | 587 | 313 | 587 | 454 | 368 | 500 | 685 | 367 | 387 | 5390
Deletions | 13 | 6 | 1 | 7 | 2 | 1 | 11 | 1 | 2 | 1 | 4 | 2 | 51
Order Records
New | 219 | 400 | 368 | 264 | 269 | 307 | 754 | 777 | 881 | 959 | 395 | 825 | 6418
Updates | 329 | 564 | 517 | 412 | 656 | 511 | 802 | 1054 | 1070 | 1577 | 1095 | 894 | 9481
Deletions | 33 | 0 | 0 | 1 | 13 | 1 | 1 | 0 | 3 | 0 | 1 | 1 | 54
Spreadsheet: 695749d1600370271-check-if-date-occurs-within-recurring-timespan-kids-planning
Sheet: Kids planning

Reference period |  |  | Reference period
Start of weekend | 2020-09-17 00:00:00 |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun
End of weekend | 2020-09-21 00:00:00
Recurrence | 14 |  | - | - | - | As of 17:30 | Ful day | Ful day | Ful day | Till 18:30 | - | - | - | 13:00 - 18:30 | - | -
Special day | Date | Kids with me? |  | Vacation | Starting Mon | [NAME] | 2020-09-14 00:00:00 | 2020-09-15 00:00:00 | 2020-09-16 00:00:00 | 2020-09-17 00:00:00 | 2020-09-18 00:00:00 | 2020-09-19 00:00:00 | 2020-09-20 00:00:00
Fictief | 2020-12-18 00:00:00 |  |  | Fictief | 2020-09-14 00:00:00
Kerstdag 1 | 2020-12-25 00:00:00 |  |  | [NAME] wk 1 | 2020-12-21 00:00:00
Kerstdag 2 | 2020-12-26 00:00:00 |  |  | [NAME] wk 2 | 2020-12-28 00:00:00
Vaderdag | 2020-06-21 00:00:00 |  |  | Herfst 2020 | 2020-10-19 00:00:00
Eerste kerstdag | 2020-12-25 00:00:00 |  |  | Kerst 2020 | 2020-12-21 00:00:00
Tweede kerstdag | 2020-12-26 00:00:00 |  |  | Voorjaar 2021 | 2021-02-22 00:00:00
Oudjaar | 2020-12-31 00:00:00 |  |  | Mei 2021 | 2021-05-03 00:00:00
Nieuwjaarsdag | 2021-01-01 00:00:00 |  |  | Zomer 2021 | 2021-07-19 00:00:00
Goede vrijdag | 2021-04-02 00:00:00 |  |  | Herfst 2021 | 2021-10-18 00:00:00
Eerste paasdag | 2021-04-04 00:00:00 |  |  | Kerst 2021 | 2021-12-27 00:00:00
Tweede paasdag | 2021-04-05 00:00:00 |  |  | Voorjaar 2022 | 2022-02-28 00:00:00
Koningsdag | 2021-04-27 00:00:00 |  |  | Mei 2022 | 2022-05-02 00:00:00
[NAME] | 2021-05-05 00:00:00 |  |  | Zomer 2022 | 2022-07-11 00:00:00
Spreadsheet: 273187d1382632416-look-for-a-list-of-strings-in-sentence-and-if-found-return-a-value-lookup-from-a-list-2-ways-sumprod-and-lookup
Sheet: Sheet1

 |  | or if rows 9, 11 are a match |  | or | or
xxx AAA ppp |  |  | AAA
yyy AAA |  |  | BB
zz BB [NAME]
zz CC pp
zz 99 pp
[NAME]
aaaa bb
aaaa bbbbb
rrr ddd vvv bb
yyyxxxxxxxyieuAAAppppo
yyy xxxxxxx yieu AAA ppppo
Spreadsheet: 811569d1672658284-sort-and-formula-sample-2-1-1-
Sheet: גיליון1

name | num |  |  | name | num |  |  | formula
a | 4 |  |  | tht | 78 |  |  |  |  |  |  |  | Row Labels |  |  |  |  |  |  | Row Labels
b | 5 |  |  | th | 132 |  |  |  |  |  |  |  | d |  |  |  |  |  |  | a
c | 6 |  |  | ryty | 56 |  |  |  |  |  |  |  | e |  |  |  |  |  |  | b
ad | 56 |  |  | f | 3 |  |  |  |  |  |  |  | f |  |  |  |  |  |  | c
[NAME] | 8 |  |  | e | 2 |  |  |  |  |  |  |  | dg |  |  |  |  |  |  | ad
fgf | 65 |  |  | dg | 34 |  |  |  |  |  |  |  | ryty |  |  |  |  |  |  | [NAME]
[NAME] | 84 |  |  | d | 1 |  |  |  |  |  |  |  | tht |  |  |  |  |  |  | fgf
[NAME] | 843 |  |  |  |  |  |  |  |  |  |  |  | th |  |  |  |  |  |  | [NAME]
Spreadsheet: 71047d1271789809-excel-2007-return-an-item-from-an-invoice-book2
Sheet: Owners

ID | Last name | First name | Address | State
1 | Bauer | [NAME] | Los Angeles | CA
2 | [NAME] | Minnie | Orlando | FL
3 | Kent | [NAME] | [NAME] | NY
4 | Bauer | [NAME] | Washington | DC
5 | Mason | [NAME] | Los Angeles | CA
6 | [NAME] | [NAME] | Orlando | FL
7 | Probst | [NAME] | Los Angeles | CA
8 | Walters | [NAME] | New York City | NY
9 | Couric | [NAME] | New York City | NY
10 | [NAME] | [NAME] | Los Angeles | CA
11 | [NAME] | Betty | Brooklyn | NY
12 | [NAME] | [NAME] | Chicago | IL
13 | VanDeCamp | Bree | Los Angeles | CA
14 | Clooney | George | Los Angeles | CA
15 | [NAME] | Whoopi | New York City | NY
16 | [NAME] | Morgan | Los Angeles | CA
17 | Streep | Meryl | Los Angeles | CA
18 | Ford | [NAME] | Los Angeles | CA
19 | Newman | [NAME] | Westport | CT
20 | Hanks | [NAME] | Los Angeles | CA
Spreadsheet: 700369d1603166412-need-help-to-have-formula-to-ignore-cells-with-no-dates-multiple-cells-in-a-row-playing-with-timeline
Sheet: Sheet3

 |  | Mutual | Sign Disclosures | [NAME] | [NAME] | Processing Review | Submit to Underwriting | KOT Initial | Conditional Approval | [NAME] | Submit for Condo Approval | [NAME] | KOT Resubmit | Submit Conditions | CD | Final Approval | [NAME] CD | Docs Out | Signing | Close Date
Smith | Target | 2020-09-25 00:00:00
 | Completed |  | 2020-10-05 00:00:00 | 2020-10-07 00:00:00
[NAME] | Target | 2020-09-25 00:00:00
 | Completed
Loo | Target | 2020-09-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-10-15 00:00:00
 | Completed |  | 2020-10-01 00:00:00 | 2020-10-08 00:00:00 | 2020-10-20 00:00:00
Pizza | Target | 2020-10-01 00:00:00
 | Completed
 |  | Mutual | Sign Disclosures |  | [NAME] | [NAME] | Processing Review | Submit to Underwriting | KOT Initial | Conditional Approval | [NAME] | Submit for Condo Approval | [NAME] | KOT Resubmit | Submit Conditions | CD | Final Approval | [NAME] CD | Docs Out | Signing | Close Date
 |  |  | Target | Complete
Smith |  | 2020-09-25 00:00:00 |  | 2020-10-01 00:00:00
[NAME] |  | 2020-09-25 00:00:00
Loo |  | 2020-09-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-10-15 00:00:00
Pizza |  | 2020-10-01 00:00:00
Spreadsheet: louise_kitchen__24114__KO_Netco Grp _ EEs on 12-19
Sheet: Gas Trad

Gas Trading
GISID | EMPLOYEE_NAME | [NAME] | JOBGROUP
90012898 | ALLEN, PHILLIP K | Mng Dir Trading | MD-C
90127729 | AMES, CHARLES H | Trading Analyst- Rotation 2 | ANL-C
90012742 | [NAME], JOHN D | VP Trading | VP-C
90007572 | BASS, [NAME] | Associate - Rotation 2 | ASSOC-C
90012755 | BLACK, [NAME] | VP Trading & Orig | VP-C
90010055 | BRAWNER, SANDRA F | Dir Trading | DIR-C
90128098 | CHU-YANG-HEU, MOG C | Trading Analyst- Rotation 2 | ANL-C
90005562 | CUILLA, MARTIN L | Mgr Trading | MGR-C
90010076 | ERMIS, FRANK J | Dir Trading | DIR-C
90041305 | GRIFFITH, [NAME] | Mgr Trading | MGR-C
90010078 | [NAME], [NAME] | VP Trading | VP-C
90010079 | HOLST, KEITH A | Dir Trading | DIR-C
90009904 | KEAVEY, [NAME] | Mgr Trading | MGR-C
90011685 | KUYKENDALL, TORI D | Mgr Trading | MGR-C
90025741 | LENHART, MATTHEW F | Sr Analyst - Rotation 1 | ANL-C
90010070 | LEWIS, ANDREW H | Dir Trading | DIR-C
90125232 | LIGUMS, JOHN E | Spec Trading Supt | SPEC-CS
90041267 | MAGGI, [NAME] | Dir Trading | DIR-C
90011523 | MAHMASSANI, SOUAD | Spec SR Logistics | SPECSR-CS
90013063 | MARTIN, THOMAS A | VP Trading | VP-C
90040978 | MAY, [NAME] | Dir Trading | DIR-C
90010061 | MCKAY, BRADLEY T | Dir Trading | DIR-C
90106487 | MCKAY, [NAME] | Dir Trading | DIR-C
90012895 | NEAL, SCOTT M | VP Trading | VP-C
90005798 | QUIGLEY, [NAME] | Associate - Rotation 1 | ASSOC-C
90005803 | REITMEYER, [NAME] | Associate - Rotation 1 | ASSOC-C
90010051 | RING, [NAME] | Dir Trading | DIR-C
90007370 | RUSCITTI, KEVIN | Mgr Trading | MGR-C
90014932 | SCHWIEGER, [NAME] | VP HPL | VP-C
90012278 | SCOTT, SUSAN M | Analyst - Rotation 2 | ANL-C
90012897 | SHIVELY, HUNTER | VP Trading | VP-C
90011696 | SIMPSON, [NAME] | Mgr Orig Wholesale | MGR-C
90128653 | SMITH, MATHEW D | Trading Associate- Rotation 2 | ASSOC-C
90009907 | STOREY, GEOFFREY C | Dir Trading | DIR-C
90010073 | THOLT, [NAME] | Dir Trading | DIR-C
90010060 | TOWNSEND, [NAME] | Mgr Trading | MGR-C
90041142 | WELDON, [NAME] | Associate - Rotation 3 | ASSOC-C
90012489 | [NAME], [NAME] | Spec SR Logistics | SPECSR-CS
90127789 | WOLFE, [NAME] | Trading Analyst- Rotation 2 | ANL-C
90123477 | ZIPPER, ANDREW A | VP Trading | VP-C
 |  | Employees
Spreadsheet: 765147d1643196458-working-time-with-varied-day-lengths-excluding-weekends-and-holidays-elapsed-day-and-time-ans
Sheet: Sheet1

Start Date | Start Time | End Date | End Time | Elapsed time (days) | hours | minutes |  | Mon-Fri | SAT
2021-01-21 00:00:00 | 09:14:00 | 2021-02-08 00:00:00 | 17:23:00 |  |  |  |  | 06:00:00 | 06:00:00
2021-03-03 00:00:00 | 06:21:00 | 2021-04-16 00:00:00 | 19:37:00 |  |  |  |  | 22:00:00 | 16:00:00
2021-08-06 00:00:00 | 08:03:00 | 2021-09-15 00:00:00 | 21:32:00
Holidays |  | It is assumed that Start day and end days are working days and Timings are within working hours always.
Christmas day | 2021-12-25 00:00:00
Boxing day | 2021-12-26 00:00:00
New years day | 2022-01-01 00:00:00
Spreadsheet: 682147d1591920819-how-to-split-up-text-and-format-into-dates-example-2-
Sheet: Time Details

Employee | Date | Date Range
[NAME] | 2020-05-27 00:00:00
[NAME] | 2020-05-27 00:00:00
[NAME] | 2020-05-28 00:00:00
[NAME] | 2020-05-28 00:00:00
[NAME] | 2020-05-29 00:00:00
[NAME] | 2020-05-29 00:00:00
[NAME] | 2020-06-01 00:00:00
[NAME] | 2020-06-01 00:00:00
[NAME] | 2020-06-02 00:00:00
[NAME] | 2020-06-02 00:00:00
[NAME] | 2020-06-03 00:00:00
[NAME] | 2020-05-26 00:00:00
[NAME] | 2020-05-26 00:00:00
[NAME] | 2020-05-27 00:00:00
[NAME] | 2020-05-27 00:00:00
[NAME] | 2020-05-28 00:00:00
[NAME] | 2020-05-28 00:00:00
[NAME] | 2020-05-29 00:00:00
[NAME] | 2020-05-24 00:00:00
[NAME] | 2020-05-26 00:00:00
[NAME] | 2020-05-26 00:00:00
[NAME] | 2020-05-27 00:00:00
[NAME] | 2020-05-27 00:00:00
[NAME] | 2020-05-28 00:00:00
[NAME] | 2020-05-28 00:00:00
[NAME] | 2020-05-29 00:00:00
[NAME] | 2020-05-29 00:00:00
Spreadsheet: 105610d1302902221-locate-a-value-in-a-horizontal-range-and-return-the-value-next-to-it-example-exel2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | ABC | DEF | GHI
 | YL123456D | ABC | 254.24 | DEF | 87.2 | GHI | 52.27 | JKL | 876.11
 | WE123456C | DEF | 32.87 | GHI | 12.9 | JKL | 87.87 | ABC | 7654.21
Spreadsheet: 775972d1649422691-too-many-cells-have-determining-factors-how-to-use-the-ones-with-products-sheet-shared
Sheet: Net Random

Green Forest Industries
Net Random width cost |  |  | 1.65
Thickness |  | 1
[NAME] |  | 6
Margin |  | 0.9
Set up |  | 50
Run Charge |  | 0.55
Knife Charge |  | 85
Freight Charge |  | 0.8
Freight Cost |  | 0
[NAME] |  | Glue | 30 |  |  | list all items used to calculate this total
Footage |  | 25
Footage + |  | 28
Total footage
Sub total |  |  |  |  |  | 0
Added cost or tax etc.. |  |  |  |  |  | 0
Sell Price
Spreadsheet: 51723352-5a37-4b82-ab81-2089875d26e9
Sheet: Sheet1

Unnamed: 0 | North Carolina Department of Environment and Natural Resources | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | Division of Air Quality (DAQ)
 | Title V Annual Compliance Certification Forms(1)
Facility Name:                                                                                                                       .
Facility Location:                                                                                                                     .
Facility ID Number:                                                           ([NAME] to first page of Title V Permit)
Title V Permit Number:                                                      ([NAME] to first page of Title V Permit)
Start of Reporting Period:                                                                              (Month, Day, Year)
End of Reporting Period:                                                                                (Month, Day, Year)
 |  |  |  |  |  |  |  |  |  | Revision 2.9