tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_m_love__30077__aaaCredit Report
Sheet: Sheet1

DEAL ORIGINATION REPORT
Deals Input on 3/20/01
PENDING CREDIT ITEMS
Counterparty | Deal Number | Deal Type | Comm | Contact/Action Needed
Arizona Public Service Company | QX9284.1 | F | NG | [NAME]
Community Media Group, Inc. | QX9279.1 | P | NWSP | [NAME]
Contour Energy Ltd. | QY1140.1 QY1141.1 QY1142.1 QY1143.1 QY1144.1 QY1145.1 | F | NG | [NAME]
FMC Corporation | QY1154.1 | F | NG | [NAME]
KCS Energy Marketing Inc. | QY1180.1/2 | F | NG | [NAME]
Mayne & Mertz, Inc. | QX8443.1 | P | NG | [NAME]
New Counterparty | QX9824.1 | F | NG | [NAME]
New Counterparty | QY1215.1 | P | NG | [NAME]
New Counterparty | QX9567.1 | P | ONP | [NAME]
Sempra Energy Europe Ltd. | QX8135.1 QX8137.1 | F | WTI | (EOL deals) [NAME]
Terra International, Inc. | QY1018.1/2 | F | NG | Brant Reves
TransMontaigne Product Service | QY0926.1/2 | F | HO | Brant Reves
[NAME], L.L.C. | [NAME] | P | NG | [NAME]
REBOOK ITEMS
Counterparty | Deal Number | Deal Type | Comm | Rebook To--
AEP Energy Services Ltd. | QX8710.1 QX9807.1 | F | NG | AEP Energy Services, Inc.
Agrium Inc. | [NAME] | F | NG | Agrium Inc. (w/ECC)
BankAmerica Corporation | QY1212.1 | F | NG | Bank of America, National Association
CLENCORE LTD | QY0942.1/2 | F | 63GC | Glencore Ltd.
Coral Energy Canada Inc. | QY0148.1 | F | NG | Coral Energy Holding, L.P.
Duke Energy Marketing Limited | QY0127.1/2 | F | NG | Duke Energy Marketing Limited (w/ECC)
Engage Energy Canada L.P. | QY0562.1 | F | NG | Engage Energy Canada L.P. (w/ECC)
PG&E Energy Services | QX9079.1 | F | NG | PG&E Energy Trading-Gas Corporation
Spreadsheet: chris_stokley__3841__SCL 0900 Flash_042301
Sheet: Total

SCL Final Actualization ISO Activity September 2000
 |  | EPMI Charges To Customers
Trans Type | (All)
 |  |  |  | Data
Customer | ID | Desc. | SchedType | Expense | Revenue | Total | Volume
SCL | 1 | Spinning Reserve due SC | AncSched | -258802.8126999999 | 0 | -258802.8126999999 | 5923.0225
 |  |  | PRA | -0.0014 | 0.0016 | 0.0002 | 0
 | 2 | Non-Spinning Reserve due SC | AncSched | -61594.625375 | 0 | -61594.625375 | 618.75
 |  |  | PRA | 0 | 0.0004 | 0.0004 | 0
 | 51 | Spinning Reserve due SC | AncSched | -4567.237499999999 | 0.218925000000008 | -4567.018574999999 | 353.0925
 |  |  | PRA | -0.0014 | 0 | -0.0014 | 0
 | 141 | No Pay Charge Spinning Reserve | PRA | 0 | 399.84 | 399.84 | -8.33
 | 401 | Supplemental | AncSched | -723602.814742224 | 0 | -723602.814742224 | 2878.595291666667
 |  |  | PRA | -1858.622699999999 | 163763.0165999999 | 161904.3938999998 | 751.3065
 | 405 | Import Deviation | AncSched | 0 | 15101.62128218402 | 15101.62128218402 | -61.55765889999984
 |  |  | PRA | -92422.3717 | 585.5956000000006 | -91836.77609999999 | 430.8073238999997
SCL Total |  |  |  | -1142848.487517224 | 179850.294407184 | -962998.19311004 | 10885.68645666667
Grand Total |  |  |  | -1142848.487517224 | 179850.294407184 | -962998.19311004 | 10885.68645666667
Final amount as actualized |  |  | -962998.19
Payment issued  December 2000 |  |  | -853383.49
Balance Owed to SCL
Spreadsheet: eric_saibi__9744__011502R
Sheet: Salem 02

Owner Name |  | PSEG Power LLC
Station Name |  | Salem Nuclear Power Station
Unit Name |  | Salem 02
NERC Region |  | MAAC
State |  | NJ
Fuel Type |  | Nuclear
Capacity |  | 1,170 MW
Start Date |  | 2002-01-11 00:00:00
End Date |  | 2002-01-18 00:00:00
Prv. Start Date |  | 2002-01-11 00:00:00
Prv. End Date |  | 2002-01-15 00:00:00
Comments |  | [NAME]
SIC |  | 4931
Plant ID |  | 1018459
Unit ID |  | 1004470
Outage ID |  | 19447
Spreadsheet: 759573d1639596985-progressive-sum-totale-progressivo
Sheet: Foglio1

 |  |  |  |  | Gennaio |  |  | [NAME] |  |  | Marzo |  |  | Aprile |  |  | Maggio |  |  | Progressivo A
 |  |  |  | Nome | A | B | C | A | B | C | A | B | C | A | B | C | A | B | C | [NAME] | Feb | Mar | Apr | Mag
 |  |  |  | Pippo | 1 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 5 |  |  | 1 | 3 | 6 | 10 | 15
 |  |  |  | Pluto | 6 |  |  | 7 |  |  | 1 |  |  | 3 |  |  | 9 |  |  | 6 | 13 | 14 | 17 | 26
Spreadsheet: 837882d1690475615-my-excel-file-is-heavy-for-use-journal-2023-07-27
Sheet: Sheet3

TP 2.5 بررسی شود
[NAME] ای که هانت میشود ابتدای آن [NAME] یا انتهای کندل روزانه هانت شده
ویدیوهای مربوط به [NAME] و تیرکس ریکی مشاهده شود
آموزش کامل درباره RSI و واگرایی و همگرایی های مثبت و منفی و [NAME]
به گره های معاملاتی OB - FTC - FTR - FL دقت شود
تمرکز اصلی روی یافتن علت سیگنال های فالس در میانه روند و [NAME] آنها باشد
بحث ZIC و IDM بررسی شود
بازگشت و شرایط لگ BC برای AB بررسی شود "صرف نظر شد"
از طریق معاملات استاپ بررسی شود که برای فعال شدن پندینگ قیمت تا کجا میتواند فاصله بگیرد
شرایط Alternative برای ستاپ استاپ هانت به صورت جداگانه بررسی شود "بیشتر روی موقعیت های استاپ خورده"
سیگنال های استاپ هانتی که خود هانت میشوند هم جداگانه [NAME]
[NAME] های شورت بررسی شود
اِنگلفینگی که هانت انجام داده بعد از 5 کندل در یک [NAME] شود
شرایط Alternative ریزبینانه و [NAME] دقت بررسی شود
در معاملات شورت درنظر گرفتن اسپرد ضروری است
آخرین [NAME] انگلف شده حتی با شدو به عنوان ملاکی برای ترسیم باکس بررسی شود
شدوی بین کندل سیگنال و کندل تایید بررسی شود
[NAME]
به لِگ BC در شرایط Alternative [NAME]
[NAME] تایید بررسی شود
سواپ هم بررسی شود
شکست سقف و کف های روزانه جداگانه بررسی شود
Spreadsheet: 888430d1738926855-excel-sumif-formula-help-fruit-ytd
Sheet: Sheet4

Fruit | Customer | Jan | Feb | Mar | Apr | May | Jun | Jul |  |  |  | Fruit | Orders To Date
Apples | [NAME] | 100 |  | 300 |  | 600 |  |  |  |  |  | Apples
Apples | [NAME] | 200 | 400 |  |  |  | 100 | 50 |  |  |  | Oranges
Oranges | [NAME] | 100 | 50 |  | 200 | 100 | 100 | 100 |  |  |  | Pears
Pears | [NAME] | 50 |  | 50 |  | 100 | 100 |  |  |  |  | Bananas
Bananas | [NAME] | 50 |  |  | 400 |  | 200 |  |  |  |  | Melon
Melon | Rachel | 100 |  | 50 |  | 20
Melon | [NAME] | 100 | 100 |  | 200 |  |  | 200
Bananas | [NAME] |  | 600 |  |  | 50 | 100
Bananas | [NAME] | 20 |  | 100 | 100
Bananas | Rachel |  | 50 |  | 600 |  | 100
Bananas | [NAME] | 100 |  | 200 |  | 100
Pears | [NAME] | 100 | 100 |  | 200
Pears | [NAME] |  | 200 | 100 |  | 100
Pears | Rachel | 50 |  | 50 | 100 |  | 100 | 100
Pears | [NAME] | 100 | 200 |  | 100 | 100 | 200
Oranges | [NAME] |  |  | 100 |  | 100 | 200
Oranges | [NAME] | 200 |  | 50 | 100 | 100
Oranges | Rachel |  | 100 | 20 | 50 | 100 | 50 | 100
Oranges | [NAME] | 100 |  | 100
Apples | Rachel | 100 |  | 300 |  | 700
Spreadsheet: 865840d1712822637-how-to-add-values-in-cells-of-a-table-which-has-specific-text-in-columns-testbook
Sheet: Sheet1

 | SALE | OOP%_FR | PR_FR/SAMPLE | TOT_FR | SALE | OOP%_FR | PR_FR/SAMPLE | TOT_FR | SALE | OOP%_FR | PR_FR/SAMPLE | TOT_FR | SALE | OOP%_FR | PR_FR/SAMPLE | TOT_FR | SALE | OOP%_FR | PR_FR/SAMPLE | TOT_FR | SALE | OOP%_FR | PR_FR/SAMPLE | TOT_FR | SALE | OOP%_FR | PR_FR/SAMPLE | TOT_FR | SALE | OOP%_FR | PR_FR/SAMPLE | TOT_FR | SALE | OOP%_FR | PR_FR/SAMPLE | TOT_FR | SALE | OOP%_FR | PR_FR/SAMPLE | TOT_FR | SALE | OOP%_FR | PR_FR/SAMPLE | TOT_FR | SALE | OOP%_FR | PR_FR/SAMPLE | TOT_FR | SALE | OOP%_FR | PR_FR/SAMPLE | TOT_FR | [NAME] | TOTAL_OOP%_FR
 |  |  |  |  | 16013 | 592 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11976 | 2313 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 136504 | 53648
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9512 | 2344 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 488 | 59
Spreadsheet: 111236d1307650614-too-many-ifs-two-criteria-and-nine-possible-outcomes-toomanyifs
Sheet: Sheet2

 |  | -100 |  | -50 |  | 0 |  | 50 |  | 100
1
2 |  |  |  | S |  |  |  |  |  |  |  |  | What I need the formula in G3 to do:
3 |  | S
4 |  |  |  | S |  |  |  |  |  |  |  | IF E10= | 0 | AND J10= | number other than zero | THEN | "S"
5 |  |  |  | S |  |  |  |  |  |  |  | IF E10= | number other than zero | AND J10= | 0 | THEN | "B"
6 |  |  |  |  |  |  |  |  |  |  |  | IF E10= | 0 | AND J10= | 0 | THEN | "SB"
7 |  |  |  |  |  |  |  |  |  |  |  | IF E10= | the word "Probe" | AND J10= | number other than zero | THEN | "S-Probe"
8 |  | S |  |  |  |  |  |  |  |  |  | IF E10= | number other than zero | AND J10= | the word "Probe" | THEN | "B-Probe"
9 |  | S |  |  |  |  |  |  |  |  |  | IF E10= | the word "Probe" | AND J10= | the word "Probe" | THEN | "SB-Probe"
10 |  |  |  | S |  |  |  |  |  |  |  | IF E10= | 0 | AND J10= | the word "Probe" | THEN | "S,B-Probe"
11 |  |  |  |  |  |  |  |  |  | S |  | IF E10= | the word "Probe" | AND J10= | 0 | THEN | "S-Probe,B"
12 |  |  |  | S |  |  |  |  |  |  |  | IF E10= | number other than zero | AND J10= | number other than zero | THEN | leave cell blank
13
14 |  |  |  |  |  |  |  |  |  | S
15 |  |  |  |  |  |  |  | S
16 |  | S
17
18
19 |  |  |  | S
20
21
22 |  |  |  |  |  |  |  | S
23 |  |  |  |  |  |  |  | S
24 |  |  |  | B |  |  |  | S
25
26 |  |  |  |  |  |  |  |  |  | S
27 |  | S
28 |  |  |  |  |  |  |  | S
29 |  |  |  | S
30
31 |  |  |  |  |  |  |  | S
32
33 |  |  |  |  |  |  |  |  |  | S
Spreadsheet: 92846d1292378066-pivot-table-grand-totals-supply-and-demand-example-model
Sheet: Resources

Supply/Demand | Resource | Project | Wave | 2010-12-06 00:00:00 | 2010-12-13 00:00:00 | 2010-12-21 00:00:00
Demand | [NAME] | Triathlon | Data Collection | 1 | 1.5 | 1
Supply | [NAME] | Triathlon | Data Collection | 0.5 | 1 | 1
Spreadsheet: 170805d1343413253-subtotal-formula-book1
Sheet: Provider budget Template1

 | Input
 | 2013 Budget
Primary_Specialty | Est. Clinic Hrs/Week
INTERNAL MEDICINE | 36
FAMILY MEDICINE | 36
INTERNAL MEDICINE | 36
FAMILY MEDICINE | 36
PODIATRY | 36
OBSTETRICS/GYNECOLOGY | 36
FAMILY MEDICINE | 0.64
INTERNAL MEDICINE | 0.09
EMERGENCY MEDICINE | 0.21
FAMILY MEDICINE | 0.63
URGENT CARE | 0.01
DERMATOLOGY | 0.06
FAMILY MEDICINE | 0.01
 |  | <--Correct
INTERNAL MEDICINE | 1.03
FAMILY MEDICINE | 1.12
PEDIATRICS | 0.16
PEDIATRICS | 0.19
PEDIATRICS | 0.8
#N/A | 0.03
PEDIATRICS | 1.04
 |  | <<--not working should be 4.37
OBSTETRICS/GYNECOLOGY | 0.83
OBSTETRICS/GYNECOLOGY | 0.55
OBSTETRICS/GYNECOLOGY | 1.09
OBSTETRICS/GYNECOLOGY | 0.87
PEDIATRICS | 0.79
PEDIATRICS | 0.23
PEDIATRICS | 1.02
OBSTETRICS/GYNECOLOGY | 0.09
OBSTETRICS/GYNECOLOGY | 0.44
INTERNAL MEDICINE | 0.22
URGENT CARE | 0.9
URGENT CARE | 0.31
URGENT CARE | 0.01
URGENT CARE | 0.42
URGENT CARE | 0.01
FAMILY MEDICINE | 0.16
INTERNAL MEDICINE | 1.24
FAMILY MEDICINE | 1.18
FAMILY MEDICINE | 0.94
FAMILY MEDICINE | 0.9299999999999999
INTERNAL MEDICINE | 1.06
ORTHOPEDICS | 0.03
FAMILY MEDICINE | 1.44
FAMILY MEDICINE | 1.21
OBSTETRICS/GYNECOLOGY | 0.01
FAMILY MEDICINE | 0.41
URGENT CARE | 0.15
URGENT CARE | 0.27
URGENT CARE | 0.01
URGENT CARE | 1.22
URGENT CARE | 0.88
URGENT CARE | 0.46
ORTHOPEDICS | 0.08
URGENT CARE | 0.62
FAMILY MEDICINE | 0.56
FAMILY MEDICINE | 0.01
FAMILY MEDICINE | 0.1
URGENT CARE | 0.03
FAMILY MEDICINE | 0.32
URGENT CARE | 0.32
PODIATRY | 0.02
OBSTETRICS/GYNECOLOGY | 0.01
URGENT CARE | 0.01
Spreadsheet: 724947d1616454779-employee-service-milestones-and-vacation-entitlement-datedif-and-index-and-match-vacation_entitlement_report_for-sharing-v2
Sheet: Vacation Entitlement

Vacation Entitlement |  |  |  | Vacation Entitlement Upon Hire |  |  |  | Vacation Entitlement Upon Hire
Service Milestones | Hours |  |  | Job Category | Hours |  |  | Job Categories | Hours
5 | 140 |  |  | All other employee groups | 105 |  |  | Admin - 1-Admin - 1 | 105
10 | 175 |  |  | Management (level management-3 and above) | 140 |  |  | Admin - 2-Admin - 2 | 105
20 | 210 |  |  | Director (level Exec-2) | 210 |  |  | Admin - 3-Admin - 3 | 105
 |  |  |  |  |  |  |  | Admin - 4-Admin - 4 | 105
 |  |  |  |  |  |  |  | Entry-Entry | 105
 |  |  |  |  |  |  |  | Exec - 1-Exec - 1 | 105
 |  |  |  |  |  |  |  | Exec - 2-Exec - 2 | 210
 |  |  |  |  |  |  |  | Mgt - 1-Mgt - 1 | 105
 |  |  |  |  |  |  |  | Mgt - 2-Mgt - 2 | 105
 |  |  |  |  |  |  |  | Mgt - 3-Mgt - 3 | 140
 |  |  |  |  |  |  |  | Mgt - 4-Mgt - 4 | 140
 |  |  |  |  |  |  |  | Other-Other | 105
 |  |  |  |  |  |  |  | Prof/Tech - 2-Prof/Tech - 2 | 105
 |  |  |  |  |  |  |  | Prof/Tech - 3-Prof/Tech - 3 | 105
 |  |  |  |  |  |  |  | Prof/Tech - 4-Prof/Tech - 4 | 105
 |  |  |  |  |  |  |  | Prof/Tech - 4-Prof/Tech - 4 | 105
 |  |  |  |  |  |  |  | Prof/Tech - 5-Prof/Tech - 5 | 105
 |  |  |  |  |  |  |  | Prof/Tech - 6-Prof/Tech - 6 | 105
Spreadsheet: john_griffith__16032__2_5_02ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG H2 | 210 | 25.5 | 26.5 | 65.2 | 67.7 | 8.77 | 2002-02-05 14:49:00
 | NG J2 | 215 | 34.5 | 35.5 | 55.8 | 57.4 | 7.65 | 2002-02-05 14:49:00
 | NG K2 | 225 | 40.5 | 42 | 49 | 50.8 | 7.06 | 2002-02-05 14:49:00
 | NG M2 | 230 | 45 | 47 | 44.9 | 46.9 | 6.64 | 2002-02-05 14:49:00
 | NG N2 | 235 | 52 | 53.5 | 45.6 | 46.9 | 6.83 | 2002-02-05 14:49:00
 | NG Q2 | 245 | 60 | 62 | 45.9 | 47.4 | 7.19 | 2002-02-05 14:49:00
 | NG U2 | 240 | 63 | 66 | 45.4 | 47.6 | 7.02 | 2002-02-05 14:49:00
 | NG V2 | 245 | 69.5 | 71.5 | 46.1 | 47.4 | 7.2 | 2002-02-05 14:49:00
 | NG X2 | 265 | 80 | 83 | 46 | 47.8 | 7.81 | 2002-02-05 14:49:00
 | [NAME] | 290 | 92 | 94 | 46.3 | 47.3 | 8.53 | 2002-02-05 14:49:00
 | NG F3 | 300 | 102 | 103 | 47.5 | 48 | 9.01 | 2002-02-05 14:49:00
 | NG G3 | 290 | 103 | 106 | 47.4 | 48.8 | 8.77 | 2002-02-05 14:49:00
 | NG H3 | 285 | 96 | 99 | 43.5 | 44.9 | 7.92 | 2002-02-05 14:49:00
 | NG M3 | 280 | 87.5 | 90 | 36.7 | 37.8 | 6.56 | 2002-02-05 14:49:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG M4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: 861294d1709209069-help-needed-to-convert-table-to-sumif-by-period-convert-table-to-by-month-and-total
Sheet: Sheet1

Staff Name | Amount | Period |  |  | 0
[NAME] | 10000 | 2024-01-31 00:00:00 |  | [NAME] | 20300 |  |  | Total | Jan'24 | Feb'24
[NAME] | 8000 | 2024-01-31 00:00:00 |  | [NAME] | 16100 |  | [NAME] | 22000 | 11000 | 11000
[NAME] | 8000 | 2024-01-31 00:00:00 |  | [NAME] | 16000 |  | [NAME] | 20300 | 10000 | 10300
[NAME] | 11000 | 2024-01-31 00:00:00 |  | [NAME] | 22000 |  | [NAME] | 16100 | 8000 | 8100
[NAME] | 10300 | 2024-02-29 00:00:00 |  | [NAME] | 5000 |  | [NAME] | 16000 | 8000 | 8000
[NAME] | 8100 | 2024-02-29 00:00:00 |  |  |  |  | [NAME] | 5000 | 0 | 5000
[NAME] | 8000 | 2024-02-29 00:00:00 |  | *What I do…. Stuck      =( |  |  | Total | 79400 | 37000 | 42400
[NAME] | 11000 | 2024-02-29 00:00:00
[NAME] | 5000 | 2024-02-29 00:00:00
 |  |  |  | Staff Name | Total | 2024-01-31 00:00:00 | 2024-02-29 00:00:00
 |  |  |  | [NAME] | 20300 | 10000 | 10300
 |  |  |  | [NAME] | 16100 | 8000 | 8100
 |  |  |  | [NAME] | 16000 | 8000 | 8000
 |  |  |  | [NAME] | 22000 | 11000 | 11000
 |  |  |  | [NAME] | 5000 |  | 5000
 |  |  |  | Total
 |  |  |  | *What I want
Spreadsheet: 809486d1671113681-how-to-count-specified-text-from-a-table-region-tally
Sheet: Sheet1

Region 1 | Region 2 | Region 3
Bradford | Hull | Leeds
Huddersfield | Wakefield | Newcastle
Leeds | Bradford | Berwick
Newcastle | Wakefield | Leeds
Leeds | Berwick | Doncaster
Wakefield | Newcastle | Bradford
Bradford | Hull | Doncaster
Newcastle | Huddersfield | Leeds
Leeds | Huddersfield | Berwick
Leeds | Hull | Berwick
Newcastle | Newcastle | Berwick
Bradford | Bradford | Huddersfield
Huddersfield | Wakefield | Doncaster
Berwick | Newcastle | Leeds
Hull | Hull | Berwick
Newcastle | Leeds | Wakefield
Bradford | Wakefield | Newcastle
Wakefield | Huddersfield | Wakefield
Leeds | Huddersfield | Bradford
Bradford | 8
Hull | 5
Leeds | 10
Huddersfield | 7
Wakefield | 8
Berwick | 7
Newcastle | 9
Doncaster | 3
[NAME] | 0
Spreadsheet: 35245d1232795939-lookup-or-index-problem-pledges
Sheet: pledges

 | Player |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assists |  | Hatricks | Goals against top 4 |  | Clean Sheets | Own Goals | Cup wins | Cup Goals | League Away Win | Beat Scum
 | Pavlyuchenko | Bentley | Bent | Bale | Gio | Huddlestone | [NAME] | King | Woodgate | Hutton | O'Hara | taarabt | Dawson | Jenas | [NAME] | Campbell | [NAME] | Palacios | Modric | Defoe | Bentley | Modric |  | Pavlyuchenko | Bent
[NAME] | 1
[NAME] |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
[NAME] |  |  | 1
rwools 167 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 2 |  |  |  | 1
Jo1981 |  |  |  | 1
WHEYAYEMAN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
[NAME] | 1
[NAME] |  |  |  |  | 1 | 1 | 1
muffwah |  |  | 2
tedmundo |  |  |  |  |  |  |  | 1 | 1 | 1 | 1
spurs spudhead |  | 1 |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
greavsie | 1
rsvp | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  | 1
tosh |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
OAOG |  |  |  |  |  |  |  |  |  |  |  | 1
yidontsay |  |  |  |  |  |  |  |  |  |  |  |  | 1
bear |  | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 | 1
spursmurph |  |  |  |  | 1
StatesideSpurs |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
scottdayid |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
palmtop |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
RemingtonSpur | 1
tbaac |  | 1 |  |  | 1 | 1 | 1 |  |  |  | 1 | 1 |  | 1 |  |  | 1 | 1 | 1
DeadlyLedley |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 0.5 | 3
[NAME] |  | 1 | 1 | 1
Arkwright |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 1 |  | 5
carlmeadows |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
joethfc |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  | 1
PV999 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x2 | 1
since1982 |  |  | 1
iain79 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Spreadsheet: 187019d1350318443-conditional-formatting-with-formula-wt-and-cg
Sheet: Sheet1

 |  |  |  | Wt | CG
 |  |  |  | 3200 | 3.8
 |  |  |  | 3250 | 3.8
 |  |  |  | 3300 | 3.8
 |  |  |  | 3350 | 3.8
 |  |  |  | 3400 | 3.8
 |  |  |  | 3450 | 3.8
 |  |  |  | 3500 | 3.8
 |  |  |  | 3550 | 3.8
 |  |  |  | 3600
 |  |  |  | 3650
 |  |  |  | 3700
 |  |  |  | 3750
 |  |  |  | 3800
 |  |  |  | 3850
 |  |  |  | 3900
 |  |  |  | 3950
 |  |  |  | 4000
 |  |  |  | 4050
 |  |  |  | 4100
 |  |  |  | 4150
 |  |  |  | 4200
 |  |  |  | 4250
 |  |  |  | 4300
Spreadsheet: 31222d1227022352-if-statement-and-list-excel
Sheet: Sheet1

File Ref. | 2008 Report | 2008 Report & Stage
104-5955 | Yes | AP
610300-00118 | No
6610300-02020 | Yes | AP
2350-17 | Yes | MA
10938-0007 | Yes | AP
364507 | Yes | AP
341306 | #N/A | #N/A
378151 | Yes | MA
390863 | Yes | MA
121483.001 | Yes | AP
388431 | Yes | AP
391168 | Yes | MA
10938-0036 | Yes | LP
374047 | Yes | LP
260695 | Yes | MA
194621 | Yes | AP
377335 | Yes | MA
384635 | Yes | MA
338324 | #N/A | #N/A
385900 | Yes | MA
10957-0008 | Yes | AP
6610300-01765 | Yes | MA
2350-22 | Yes | MA
305065 | Yes | MA
2350-25 | Yes | MA
322626 | Yes | AP
02047-00246 | Yes | PC
104-5887 | Yes | AP
355407 | Yes | MA
6610300-01788 | Yes | PC
Spreadsheet: 518662d1495031330-how-to-trigger-alert-for-7-consecutive-dates-with-data-on-cell-voong-consecutive-days-worked-ignore-weekends
Sheet: Sample

Name | Designation | Emp No | 2017-05-20 00:00:00 | 2017-05-21 00:00:00 | 2017-05-22 00:00:00 | 2017-05-23 00:00:00 | 2017-05-24 00:00:00 | 2017-05-25 00:00:00 | 2017-05-26 00:00:00 | 2017-05-27 00:00:00 | 2017-05-28 00:00:00 | 2017-05-29 00:00:00 | 2017-05-30 00:00:00 | 2017-05-31 00:00:00 | TOTAL | Accumulate Work Days Alert
 |  |  | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED
[NAME] | General Worker | 111 |  |  | 7 | 7 | 7 | 7 | 7 |  |  | 7 |  |  |  |  |  | Holidays
OTx1.5(Hr) |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  | 2017-05-01 00:00:00
OTx2.0(Hr) |  |  |  |  |  |  |  |  |  |  | OFF |  |  |  |  |  |  | 2017-05-10 00:00:00
YYY | General Worker | 222 |  |  |  | 7 | 7 | 7 | 7 |  |  | 7 | 7 |  |  |  |  | Holidays
OTx1.5(Hr) |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  | 2017-05-01 00:00:00
OTx2.0(Hr) |  |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  | 2017-05-10 00:00:00
Spreadsheet: 835986d1689012016-how-many-employees-were-there-in-that-month-last-year-book3
Sheet: Sheet1

 |  | START DATE | LEAVING DATE |  |  |  | Number of people employed at the end of this month | [NAME] | [NAME] | [NAME] | Adapted Sol A
 |  | 2020-12-01 00:00:00 |  |  |  | 2021-01-01 00:00:00 | 3
 |  | 2020-12-01 00:00:00 |  |  |  | 2021-02-01 00:00:00 | 5
 |  | 2021-01-10 00:00:00 | 2021-06-07 00:00:00 |  |  | 2021-03-01 00:00:00 | 6
 |  | 2021-02-10 00:00:00 | 2021-10-01 00:00:00 |  |  | 2021-04-01 00:00:00 | 6
 |  | 2021-02-22 00:00:00 |  |  |  | 2021-05-01 00:00:00 | 5
 |  | 2021-03-14 00:00:00 | 2021-05-02 00:00:00 |  |  | 2021-06-01 00:00:00 | 6
 |  | 2021-06-03 00:00:00 |  |  |  | 2021-07-01 00:00:00 | 7
 |  | 2021-06-05 00:00:00 |  |  |  | 2021-08-01 00:00:00 | 7
 |  | 2021-07-04 00:00:00 |  |  |  | 2021-09-01 00:00:00 | 7
 |  |  |  |  |  | 2021-10-01 00:00:00 | 6
 |  |  |  |  |  | 2021-11-01 00:00:00
 |  |  |  |  |  | 2021-12-01 00:00:00
 |  |  |  |  |  | 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
 |  |  |  |  |  | 2023-01-01 00:00:00
 |  |  |  |  |  | 2023-02-01 00:00:00
 |  |  |  |  |  | 2023-03-01 00:00:00
 |  |  |  |  |  | 2023-04-01 00:00:00
 |  |  |  |  |  | 2023-05-01 00:00:00
 |  |  |  |  |  | 2023-06-01 00:00:00
Spreadsheet: 587703d1535188914-extract-dates-out-of-a-table-and-sort-chronologically-reminder-tracking
Sheet: Status on 03.03.2018

Tracking of reminders
Current date: | 2018-03-03 00:00:00
Case No | Due Date | Information received | Due Date | Information received | Due Date | Information received | Due Date | Information received | Due Date | Information received
 | Reminder 1 | (based on reminder 1) | Reminder 2 | (based on reminder 2) | Reminder 3 | (based on reminder 3) | Reminder 4 | (based on reminder 4) | Reminder 5 | (based on reminder 5)
C-2018-01 | 2018-01-14 00:00:00 | yes
C-2018-02 | 2018-01-19 00:00:00 | no | 2018-02-19 00:00:00 | no | 2018-03-19 00:00:00
C-2018-03 | 2018-02-27 00:00:00 | no | 2018-03-27 00:00:00
C-2018-04 | 2018-03-19 00:00:00
C-2018-05 | 2018-03-29 00:00:00
C-2018-06 | 2018-04-03 00:00:00
Intended table:
Upcoming reminders (chronologic)
Date | Case | ToDo
2018-03-19 00:00:00 | C-2018-02 | Reminder 3
2018-03-19 00:00:00 | C-2018-04 | Reminder 1
2018-03-27 00:00:00 | C-2018-03 | Reminder 2
2018-03-29 00:00:00 | C-2018-05 | Reminder 1
2018-04-03 00:00:00 | C-2018-06 | Reminder 1
Spreadsheet: 873590d1720098595-filter-array-range-determined-by-index-match-digitalpeon-filter-example-2-aligw
Sheet: Sheet1

Supervisor | Randal
Name | Age | Height | Supervisor |  |  | Name | Age
[NAME] | 24 | 150 | Randal |  |  |  | 24
[NAME] | 46 | 110 | [NAME] |  |  | [NAME] | 10
[NAME] | 15 | 90 | [NAME]
[NAME] | 10 | 130 | Randal
I would like to change cell H3 to "Height" and have H4 change to 150 and so on
Ideally, I would like the row to dynamically set. So, it would be B4:B7 now, but adding 3 individuals and changing H3 to "Height" would result in C4:C10