tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 776640d1649841547-countif-using-index-and-match-example
Sheet: Sheet1

Contract | Yes/No | Count "Yes"
1 | Yes | 2
1 | Yes | 2
2 | No | 2
2 | Yes | 2
2 | Yes | 2
3 | No | 0
3 | No | 0
4 | Yes | 3
4 | No | 3
4 | No | 3
4 | Yes | 3
4 | Yes | 3
5 | No | 1
5 | Yes | 1
Spreadsheet: 687072d1594938296-min-max-calc-for-financial-projection-fm-mhc-model-excelforum-
Sheet: DebtSupport

 |  | Loan 1 | Loan 2 | Loan 3
Shows | [NAME]
 | [NAME]
 | Fund Method
 | Fund Date
 | Amount
 | Fund %
 | Fund Points
 | Show Rate
 | Show Spread
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
[NAME] | Funding Amount
 | Value
 | LTV%
 | Term
 | IO
 | Amort
 | Maturity
 | Rate
Calcs | Start
 | Term
 | Maturity
 | Draw Period
 | IO Period
 | [NAME]
 | Amort
 | End
 | IsRefied
 | IsPrepaid
 | [NAME]
 | Refi2
 | Initial Balance
 | Year
Spreadsheet: stacey_white__38828__nimo
Sheet: Sheet1

DEAL # | EOL # | COUNTERPARTY | DEAL DATE | FLOW START | FLOW END | PRICE | VOLUME | TRADER | DELIVERY POINT | DEAL TYPE | CATEGORY | BUY/SALE | PHYSICAL/FINANCIAL | FIRMNESS
335880.1 |  | [NAME] | 2000-05-08 00:00:00 | 2001-01-01 00:00:00 | 2001-12-31 00:00:00 | 48.5 | 102000 | [NAME] | NEPOOL PTF | FORWARD | CMDTY | B | P | Firm
335926.1 |  | [NAME] | 2000-05-08 00:00:00 | 2001-01-01 00:00:00 | 2001-12-31 00:00:00 | 49 | 102000 | [NAME] | NEPOOL PTF | FORWARD | CMDTY | B | P | Firm
339931.1 |  | [NAME] | 2000-05-15 00:00:00 | 2001-01-01 00:00:00 | 2001-12-31 00:00:00 | 50 | 102000 | [NAME] | NEPOOL PTF | FORWARD | CMDTY | B | P | Firm
340369.1 |  | [NAME] | 2000-05-16 00:00:00 | 2001-01-01 00:00:00 | 2001-12-31 00:00:00 | 26 | 117000 | [NAME] | NEPOOL PTF | FORWARD | CMDTY | B | P | Firm
340677.1 |  | [NAME] | 2000-05-16 00:00:00 | 2001-01-01 00:00:00 | 2001-12-31 00:00:00 | 51 | 102000 | [NAME] | NEPOOL PTF | FORWARD | CMDTY | B | P | Firm
341253.1 |  | [NAME] | 2000-05-17 00:00:00 | 2001-01-01 00:00:00 | 2001-12-31 00:00:00 | 52.5 | 102000 | [NAME] | NEPOOL PTF | FORWARD | CMDTY | B | P | Firm
341615.1 |  | [NAME] | 2000-05-18 00:00:00 | 2001-01-01 00:00:00 | 2001-12-31 00:00:00 | 26.5 | 117000 | [NAME] | NEPOOL PTF | FORWARD | CMDTY | B | P | Firm
403169.1 |  | [NAME] | 2000-08-30 00:00:00 | 2001-01-01 00:00:00 | 2001-12-31 00:00:00 | 54 | 204000 | [NAME] | NEPOOL PTF | FORWARD | CMDTY | S | P | Firm
420794.1 |  | [NAME] | 2000-09-25 00:00:00 | 2001-01-01 00:00:00 | 2001-12-31 00:00:00 | 69.5 | 204000 | [NAME] | NEPOOL PTF | FORWARD | CMDTY | S | P | Firm
446014.1 |  | [NAME] | 2000-10-30 00:00:00 | 2002-01-01 00:00:00 | 2002-12-31 00:00:00 | 1.4 | 219000 | [NAME] | NEPOOL ICAP | FORWARD | CPCTY | B | P | Installed Capability
470702.1 |  | [NAME] | 2000-11-30 00:00:00 | 2001-01-01 00:00:00 | 2001-12-31 00:00:00 | 20.35 | 234000 | [NAME] | PJM-Western Hub | FORWARD | CMDTY | B | P | Firm
590982.1 |  | [NAME] | 2001-04-24 00:00:00 | 2002-01-01 00:00:00 | 2002-12-31 00:00:00 | 2 | 219000 | [NAME] | NEPOOL ICAP | FORWARD | CPCTY | S | P | Installed Capability
Spreadsheet: 36059d1233820793-creating-a-scoresheet-creating-a-scoresheet
Sheet: Main

id | Driver | Race 1 | Race 2
1 | [NAME] | 1 | 5
2 | [NAME] | 5 | 10
3 | [NAME] | 10 | 1
4 | [NAME] | 3 | 3
Spreadsheet: 72d955bd-94d4-4d0c-afc7-d6ed931ca8ce
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
FQUET | Test | FQUET | Quetiapine (Seroquel) | Quetiapine (Seroquel), Serum | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) | Green-Top Tube (Sodium Heparin): GrnNaHp Plain, Red-Top Tube: Red |  |  | 3 | mL | Submit only 1 of the following specimens:  Plasma Draw blood in a green-top (sodium heparin) tube(s), plasma gel tube not acceptable. Spin down and send 3 mL sodium heparin plasma refrigerated in a plastic vial.   Serum Draw blood in a plain red-top tube(s), serum gel tube is not acceptable. Spin down and send 3 mL of serum refrigerated in a plastic vial. | 0.6 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | Units:	ng/mL   Therapeutic and toxic ranges have not been established. Expected steady-state Quetiapine plasma levels in patients receiving recommended daily dosages: 100 - 1000 ng/mL.   Test Performed By:	Medtox Laboratories 402 W. County Road D St. Paul, MN  55112 | Monday through Sunday | 5 days | 7 - 9 days | 1 | 82491 |  |  |  |  | Medtox Laboratories, Inc.
FQUET | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
FQUET | Result | Z1216 | Quetiapine (Seroquel), Serum | Quetiapine (Seroquel), Serum | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 828512d1683558734-search-a-list-with-multiple-values-s666-pq-search-a-list-with-multiple-values
Sheet: Text

ID | Line | Display
21 | 1 | Line 21 AA
21 | 2 | Line 21 BB
21 | 3 | Line 21 CC
33 | 1 | Line 33 A
33 | 2 | Line 33 B
33 | 3 | Line 33 C
33 | 4 | Line 33 D
33 | 5 | Line 33 E
45 | 1 | Line 44 AAA
Spreadsheet: 575539d1527584233-help-with-formulas-to-perform-indexation-to-rental-income-on-annual-semi-annual-etc-dummy-file-1-ans2
Sheet: Sheet1

 |  |  | Analysis start date | 2017-12-31 00:00:00
 |  |  | Inflation
 |  |  | Year | 2018
 |  |  |  | 0.01 | 0.02 | 0.03 | 0.02 | 0.05
 |  |  | Tenant | Annual rent | Indexation
 |  |  | 1 | 1 | annual | 1
 |  |  | 2 | 1 | Every 2nd year | 2
 |  |  | 3 | 1 | every third year | 3
 |  |  |  |  |  |  |  |  |  | Rent income exc. Indexation
 |  |  |  |  |  |  |  |  |  | Year | 2018
 |  |  |  |  |  |  |  |  |  | Tenant 1
 |  |  |  |  |  |  |  |  |  | [NAME] | 1000
 |  |  |  |  |  |  |  |  |  | Tenant 3 | 1500
 |  |  |  |  |  |  |  |  |  | End result
 |  |  |  |  |  |  |  |  |  | Rent income inc. Indexation
 |  |  |  |  |  |  |  |  | Year | Annual rent | 2018 | 2019 | 2020 | 2021 | 2022
 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  | End result
 |  |  |  |  |  |  |  |  |  | Rent income inc. Indexation
 |  |  |  |  |  |  |  |  |  | Year | 2018 | 2019 | 2020 | 2021 | 2022
 |  |  |  |  |  |  |  |  |  | Tenant 1 | 1010 | 1030.2 | 1061.106 | 1082.32812 | 1136.444526
 |  |  |  |  |  |  |  |  |  | [NAME] | 1000 | 1030.2 | 1030.2 | 1082.32812 | 1082.32812
 |  |  |  |  |  |  |  |  |  | Tenant 3 | 1500 | 1500 | 1591.659 | 1591.659 | 1591.659
Spreadsheet: 726893d1617574242-countif-multiple-functions-countif-trouble
Sheet: Daily Hour Breakdown

CMH52 CORE HOURS | US9605737 | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Hours |  |  | [NAME]
Account Manager | 40 | 8
Supervisor | 168 | 24 | 24 | 24 | 24 | 24 | 24 | 23.25 | 24 | 24 | 24 | 24 | 24 | 24 | 22.75 | 24 | 24 | 24 | 24 | 24 | 24 | 23.5 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24
VMO | 80 | 15 | 16 | 16 | 16 | 16 | 0 | 0 | 15 | 16 | 16 | 16 | 16 | 0 | 0 | 16 | 16 | 16 | 16 | 16 | 0 | 0 | 8.25 | 16 | 16 | 16 | 16 | 0 | 0 | 16 | 8 | 11
Front Gate | 168 | 23.75 | 23.75 | 24 | 23.75 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 23 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 23.75 | 24 | 24 | 24 | 23.5 | 23 | 24
Rover/Patrol | 168 | 19.25 | 21 | 24 | 20.5 | 21.25 | 24 | 19 | 12.75 | 19 | 22 | 21 | 24 | 20.75 | 19.5 | 20 | 12.25 | 21 | 23.25 | 21.5 | 18.5 | 21.75 | 18.5 | 17.25 | 17.75 | 18.5 | 24 | 24 | 24 | 18 | 16.75 | 24
Perimeter | 168 | 16 | 18.25 | 24 | 24 | 24 | 24 | 15 | 10.75 | 17 | 24 | 19.75 | 24 | 20 | 18.5 | 3 | 8.25 | 20 | 16.25 | 16 | 18.25 | 8.25 | 14 | 16.5 | 18 | 9 | 16.25 | 11 |  | 8.5 | 2.25 | 8
Interior | 168 | 24 | 20.5 | 24 | 23.25 | 24 | 24 | 23.75 | 24 | 19.75 | 23 | 24 | 24 | 24 | 23 | 21 | 8 | 24 | 24 | 24 | 24 | 24 | 15.25 | 18.75 | 16 | 20.25 | 24 | 24 | 24 | 15 | 2 | 16.25
C-1 | 80 | 16 | 16 | 16 | 16 | 16 |  |  |  | 16 | 16 | 16 |  |  |  | 16 | 16 | 16 | 16 | 16 |  |  | 16 | 16 | 16 |  |  |  |  |  | 16 | 16
C-2 | 40 |  |  |  | 1 |  |  |  | 1.5 |  |  | 4.75 |  |  |  |  |  |  | 4.75 | 7.75 |  |  |  |  |  |  |  |  |  |  | 1 | 1
IGLOO | 168 | 24 | 17.25 | 20.75 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24
Metrics Manager | 40
 | [NAME]
 | HEA
Spreadsheet: 005956c3-71ab-4052-8df1-ef941c8cd3ec
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | How Much Do You Know About Protein?
 |  | Answer the following questions as "True" or"False" to test your knowledge of protein.       A score below 50% indicates additional education about protein is needed.
 |  |  |  |  | Click on red box to enter True or False
 |  | 1.  Protein supplements are necessary to gain muscle mass when weight lifting. | 1
 |  | 2.  Protein supplements are better than real food for gaining muscle mass. | 1
 |  | 3.  Protein from animal sources is usually better than protein from grains. | 1
 |  | 4.  Protein supplements are a good source of energy. | 1
 |  | 5.  Eating large amounts of protein may be harmful. | 1
 |  | 6.  Protein supplements prevent the gain of unwanted "fat". | 1
 |  | 7.   Most Warfighters do not eat enough protein. | 1
 |  | 8.  Protein supplements increase fluid requirements. | 1
 |  | 9.  Service members should use protein supplements to maintain muscle mass. | 1
 |  | 10. Eating small amounts of protein after a workout is important. | 1
 |  | FINAL SCORE | 10
Spreadsheet: 88623d1288395168-eliminating-0-values-for-blank-filtered-records-generate-records-meeting-criteria
Sheet: Sheet1

 |  |  |  | Unique List
 | Item | Price | Sub |  |  |  |  | Unique List | I3:I7
 | CAB | 321 | SD5 |  |  |  |  | CAB
 | DENT | 15 | SD8R |  |  |  |  | DENT
 | CAB | 452 | SDR5 |  |  |  |  | BIN |  |  | Address of Range Containing Data in Range "UniqueList"
 | BIN | 111 | GTY |  |  |  |  | SUB
 | SUB | 10005 | BHK |  |  |  |  | [NAME]
Source | BIN | 5436 | MNJ
 | [NAME] | 123 | DS1E2
 | CAB | 0
 | [NAME] | 7 | D24R
 | DENT | 895 | 5W5D
 | [NAME] | 569 | T651
 | CAB | 54
 |  |  |  |  | Inset>Name>Define: Name:UniqueListValidation; Refer:=Indirect($J$2)
Lookup records for |  | CAB |  |  | Data>Validation: Allow as List, Source:=UniqueListValidation
 |  | Price | Sub
 |  | 321 | SD5
 |  | 452 | SDR5
 |  | 0 | 0
 |  | 54 | 0
Spreadsheet: 288882d1389332259-merging-rows-based-on-column-contents-orders-demo
Sheet: Output

Order Number |  |  |  |  |  |  |  | Order Number | Item Ordered
1889 |  |  |  |  |  |  |  | 1889 | Ruler
2001 |  |  |  |  |  |  |  | 2001 | Eraser
2456 |  |  |  |  |  |  |  | 2001 | Pencil
2555 |  |  |  |  |  |  |  | 2001 | Stapler
3890 |  |  |  |  |  |  |  | 2456 | Flashlight
4455 |  |  |  |  |  |  |  | 2555 | Ruler
 |  |  |  |  |  |  |  | 3890 | Staple Remover
 |  |  |  |  |  |  |  | 3890 | Stapler
 |  |  |  |  |  |  |  | 4455 | Pencil
Spreadsheet: 593706d1539281994-extracting-a-subarray-from-a-larger-array-issue-book1
Sheet: Sheet1

 | Data |  |  |  |  |  |  | Expected Results
 | Order | WO Status | Description | Priority Level | Changes Made By |  |  | WO Status | Description | Priority Level | Changes Made By
 | 0 | Complete | HI | 1 | [NAME] |  |  | Grave     →     Days | HI | 1 | [NAME]
 | 0 | Complete | HI | 3 | [NAME] |  |  | Days     →     Swing | HI | 1 | [NAME]
 | 0 | Complete | HI | 4 | Sussie |  |  | Grave     →     Days | hello | 1 | Sussie
 | 0 | Complete | HI | 1 | [NAME] |  |  | Swing     →     Grave | hello | 2 | [NAME]
 | 0 | Complete | HI | 2 | [NAME] |  |  | Grave     →     Days | hola | 3 | Jennie
 | 0 | Complete | HI | 1 | [NAME]
 | 0 | Complete | HI | 1 | Jennie
 | 0 | Complete | HI | 1 | Jennie |  |  |  | Original Array |  | [NAME] by zero |  | SubArray
 | 9 | Grave     →     Days | HI | 1 | [NAME] |  |  |  | 0
 | 10 | Days     →     Swing | HI | 1 | [NAME] |  |  |  | 0
 | 0 |  | Time on WO Allocated: | 1 | Jennie |  |  |  | 0
 | 0 | Complete | hello | 1 | [NAME] |  |  |  | 0
 | 0 | Complete | hello | 1 | [NAME] |  |  |  | 0
 | 0 | Complete | hello | 1 | [NAME] |  |  |  | 0
 | 15 | Grave     →     Days | hello | 1 | Sussie |  |  |  | 0
 | 0 | Complete | hello | 1 | Sussie |  |  |  | 0
 | 0 | Complete | hello | 2 | [NAME] |  |  |  | 0
 | 0 | Complete | hello | 3 | [NAME] |  |  |  | 0
 | 0 | Complete | hello | 4 | [NAME] |  |  |  | 1
 | 20 | Swing     →     Grave | hello | 2 | [NAME] |  |  |  | 0
 | 0 | Complete | hello | 3 | [NAME] |  |  |  | 3
 | 0 |  | Time on WO Allocated: | 3 | Sussie |  |  |  | 0
 | 0 | Complete | hola | 3 | [NAME] |  |  |  | 0
 | 24 | Grave     →     Days | hola | 3 | Jennie |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  | 234
 |  |  |  |  |  |  |  |  | 56
 |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  | 0
Spreadsheet: 715429d1611698554-sum-n-count-of-values-in-rows-sum-first-5-numbers
Sheet: Sheet1

Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Column 7 | Column 8 | Column 9 | Column 10 | Column 11 | Column 12 | Column 13 | Column 14 | Column 15 | Column 16 | Column 17 | Column 18 | Column 19 | Column 20 | [NAME] in this column to sum first 5 values in each row.
1 |  | 2 |  | 5 |  | 8 | 8 | 7 | 8 |  | 5 |  |  | 6 |  | 5 |  | 8 | 1
5 | 2 |  | 4 |  | 7 | 8 |  | 2 | 2 | 2 |  |  | 8 |  | 3 | 1 | 1 |  | 7
 |  | 8 |  |  |  | 2 | 8 |  | 3 |  | 3 |  | 7 |  |  | 9 |  | 4
5 |  |  | 8 | 7 | 8 |  | 5 | 5 |  |  | 8 | 7 | 8 |  | 5
 | 7 | 8 |  | 2 | 2 | 2 |  |  | 7 |  |  | 2 | 2 | 2 |  |  | 5 | 5
 |  | 2 | 8 |  | 3 |  | 3 |  |  | 2 | 8 |  | 3 |  | 3 | 2 |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 8 | 7 | 8 |  | 5
 |  |  |  |  | 7 | 8 |  | 2 | 2 | 2 |  |  | 8
 |  |  |  |  |  | 2 | 8 |  |  |  | 3 |  | 2 | 2 | 8 |  | 5 | 5
 |  |  |  |  | 5 |  | 8 | 8 |  | 8 |  | 5 | 3 |  | 2 | 2 |  |  | 7
 |  |  |  |  | 5 |  |  | 8 | 7 | 8 |  | 5 |  |  | 3 |  | 3
 |  |  |  |  |  | 7 | 8 |  | 2 | 2 | 2 |  | 8
 |  |  |  |  |  |  | 2 | 8 |  | 3 |  | 3 | 2 | 2 | 8 |  | 5 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 2 | 2 |  |  | 7
5 |  | 8 | 8 | 7 |  |  |  |  |  |  |  |  |  |  | 3 |  | 3
 | 7 |  |  | 2
Spreadsheet: 809642d1671195623-how-to-change-all-data-in-new-page-when-copied-from-old-one-tst
Sheet: Budget vs. Actual 

Budget to Actual YTD
 |  |  |  | Month # | 0
 |  |  |  |  | Cash Beginning of Period
 |  |  | Actuals | Budget | Linear Budget YTD | YTD Actuals
 |  |  | Previous Yr
 |  | Tiendes
 |  | Tiendes
 |  | Tiendes
 |  | Tiendes
 |  | Tiendes
 |  | ekstra
 |  | ekstra
 |  | ekstra
 |  | Total Revenue:
 |  | Uitgawes:
 |  | [NAME] Ds [NAME]
 |  | [NAME] Ds Pieter**
 |  | Lone (Tuinier)(Eric)
 |  | Lone (Skoonmaker)
 |  | Lone (Week 3)
 |  | Lone (Week 4)
 |  | Lone (Week 5)
 |  | Total Expenses:
 | Net : Income Gain / (Loss)
 | Cash End of Period
Spreadsheet: 486849d1477694668-case-report-analysis-formula-rc-practice
Sheet: DATA

[NAME] | Customer No | Status | Project | Media Type | Visibilty | Subject | Description | Created By | Created Date | Assigned To | Assigned Date | Closed By | Closed Date | Last Activity | Number of Attatchements | Number of Follow Ups | Code | [NAME] Direction | Days to [NAME] | Days since Last Activity | Department
[EMAIL] | 957801 | Closed | Default | [NAME] | Internal | RE: Your Quote | Text about a random quote to a customer | Customer ([NAME]) | 2016-08-10 00:00:00 | [NAME] | 2016-08-10 00:00:00 | [NAME] | 2016-08-11 00:00:00 | 2016-08-11 00:00:00 | 1 | 0 | Quote
[EMAIL] | 967802 | Closed | Default | [NAME] | Internal | System Issues | Text about a random system issue | Customer ([NAME]) | 2016-08-15 00:00:00 | [NAME] | 2016-08-15 00:00:00 | [NAME] | 2016-08-15 00:00:00 | 2016-08-15 00:00:00 | 0 | 0 | Billing
[EMAIL] | 977803 | Unassigned | Default | [NAME] | Internal | System Issues | Text about a random system issue | AJ [NAME] | 2016-08-20 00:00:00 | [NAME] | 2016-08-20 00:00:00 |  |  | 2016-10-10 00:00:00 | 0 | 1 | Null
[NAME] | 987804 | Closed | Default | [NAME] | Internal |  | Random text about [NAME] stuff | Customer ([NAME]) | 2016-09-10 00:00:00 | [NAME] | 2016-09-15 00:00:00 | [NAME] | 2016-10-10 00:00:00 | 2016-10-10 00:00:00 | 0 | 3 | Billing
[EMAIL] | 997805 | Unassigned | Default | [NAME] | Internal | What happened today? | Random text about office gossip | [NAME] | 2016-09-15 00:00:00 |  |  |  |  |  | 0 |  | Null
[EMAIL] | 1007806 | Unassigned | Default | [NAME] | Internal | Welcome! | Text to welcome a random customer | Automail | 2016-09-20 00:00:00 |  |  |  |  |  | 1 |  | Null
[NAME] | 1017807 | Closed | Default | [NAME] | Internal | FW: | A forwarded email with no real subject | [NAME] | 2016-09-25 00:00:00 | [NAME] | 2016-09-25 00:00:00 | [NAME] | 2016-10-05 00:00:00 |  | 1 | 0 | Sales
 | 1027808 | Open | Default | [NAME] | Internal | System Issues | Text about a random system issue |  | 2016-10-10 00:00:00 | [NAME] | 2016-10-10 00:00:00 |  |  | 2016-10-20 00:00:00 | 0 | 2 | Billing
[NAME] | 1037809 | Closed | Default | [NAME] | Internal | Copy of Sales | Text with a file included on forecasted sales | Helly Hansen | 2016-10-15 00:00:00 | [NAME] | 2016-10-15 00:00:00 | [NAME] | 2016-10-25 00:00:00 | 2016-10-25 00:00:00 | 2 | 1 | Sales
Spreadsheet: 539388d1506092331-how-to-indirect-value-reference-zeszyt2
Sheet: Name

c | n
a1 | b1
a2 | b2
a3 | b3
a4 | b4
a5 | [NAME]
a6 | b6
a7 | b7
[NAME] | b8
a9 | b9
a10 | b10
Spreadsheet: 138489d1327681030-excel-2007-referencing-a-hyperlink-tlc-client-progress
Sheet: Home

Course | Client | Student |  | Initial Contact | Details on database | Evaluation | Eval Report Received | Follow Up  with Parent | Course O/view  Made | Teacher  Confirmed | Teacher Availability  Updated | Sent out  T&Cs/Welcome Pack | Add lessons to database | Send [NAME]to JF |  | Follow Up  1st class | Follow ups? | 1st  Follow up | 2nd  Follow up | 3rd  Follow up | Initial  Band Score | 1st  Follow Up | 2nd  Follow up
 | B1 | B3 |  |  | B8 | B10 | B12 | B14 | B16 | C18 | [NAME]
Santiago
[NAME]
Spreadsheet: 783423d1654796153-summarize-and-total-data-from-another-sheet-2022-06-09-oeldere-lichldo-sample-excel
Sheet: Oeldere

Stage / Description | Hours | Work | criteria
Video Phase |  | Video Phase
Copy Editing |  | Video Phase
- Copywriting | 16 | Video Phase
Creative Design |  | Video Phase
- Creative Senior -Art Direction | 20 | Video Phase
- Creative Director - Concepts | 2 | Video Phase
- Production Manager | 1 | Video Phase
Design Development |  | Video Phase
- Creative Mid - Design & Amends | 16 | Video Phase
Artwork |  | Video Phase
- Creative Artworker | 12 | Video Phase
- Production Manager | 1 | Video Phase
Project Management |  | Video Phase
- Account Director | 7 | Video Phase
- Project Manager Senior | 13 | Video Phase
PDF Phase |  | PDF Phase
Creative Design |  | PDF Phase
- Creative Senior -Art Direction | 12 | PDF Phase
- Creative Director - Concepts | 2 | PDF Phase
- Production Manager | 1 | PDF Phase
Design Development |  | PDF Phase
- Creative Mid - Design & Amends | 8 | PDF Phase
Artwork |  | PDF Phase
- Creative Artworker | 8 | PDF Phase
Project Management |  | PDF Phase
- Account Director | 4 | PDF Phase
- Project Manager Senior | 8 | PDF Phase
Webpage Phase |  | Webpage Phase
Copywriting |  | Webpage Phase
- Creative Director - Concepts | 2 | Webpage Phase
- Copywriter Senior |  | Webpage Phase
INK Copywriting for Webpage |  | Webpage Phase
Copy Editing |  | Webpage Phase
- Copywriter Senior | 4 | Webpage Phase
Creative Design |  | Webpage Phase
- Creative Senior -Art Direction |  | Webpage Phase
- Creative Director - Concepts |  | Webpage Phase
- Creative Director - Concepts |  | Webpage Phase
Design Development |  | Webpage Phase
- Creative Mid - Design & Amends |  | Webpage Phase
Artwork |  | Webpage Phase
- Creative Artworker | 4 | Webpage Phase
Project Management |  | Webpage Phase
- Account Director | 4 | Webpage Phase
- Group Account Director |  | Webpage Phase
- Project Manager Senior | 7.5 | Webpage Phase
Spreadsheet: 808040d1670253362-countifs-where-closed-date-is-less-than-or-equal-to-open-date-7-example-data
Sheet: INCDATA

State | Opened | Closed |  | Date Maths | State Count
New | 2022-11-01 04:57:39
Closed | 2022-11-01 05:05:17 | 2022-11-01 11:06:06 |  | 1
Closed | 2022-11-01 05:13:38 | 2022-11-04 21:40:19 |  | 1
Closed | 2022-11-01 05:25:20 | 2022-11-09 22:32:17 |  |  |  | Need to count only if the State column is Closed AND the date math line up. Closed in '7 days or less'
Closed | 2022-11-01 05:25:38 | 2022-11-04 21:40:21 |  | 1
Closed | 2022-11-01 06:20:07 | 2022-11-07 21:44:35 |  | 1
Closed | 2022-11-01 06:24:05 | 2022-11-03 05:01:37 |  | 1
Resolved | 2022-11-01 06:32:49 |  |  | 1
In Progress | 2022-11-01 06:45:43 |  |  | 1
Closed | 2022-11-01 06:45:50 | 2022-11-10 21:43:29
Closed | 2022-11-01 06:49:18 | 2022-11-07 21:44:38 |  | 1
Closed | 2022-11-01 06:58:56 | 2022-11-02 08:20:08 |  | 1
Closed | 2022-11-01 07:06:32 | 2022-11-04 21:40:20 |  | 1
Closed | 2022-11-01 07:09:28 | 2022-11-04 12:38:49 |  | 1
Canceled | 2022-11-01 07:12:10 | 2022-11-01 07:20:54 |  | 1
Closed | 2022-11-01 07:14:06 | 2022-11-03 06:23:38 |  | 1
On Hold | 2022-11-01 07:37:21 |  |  | 1
Closed | 2022-11-01 07:40:16 | 2022-11-04 21:40:17 |  | 1
Closed | 2022-11-01 07:44:25 | 2022-11-09 22:32:10
Closed | 2022-11-01 07:55:55 | 2022-11-08 21:41:04
Closed | 2022-11-01 08:05:07 | 2022-11-08 21:41:02
Closed | 2022-11-01 08:09:12 | 2022-11-10 21:43:38
Closed | 2022-11-01 08:09:14 | 2022-11-09 22:32:10
Closed | 2022-11-01 08:14:47 | 2022-11-07 21:44:35 |  | 1
Closed | 2022-11-01 08:33:46 | 2022-11-07 21:44:40 |  | 1
Closed | 2022-11-01 08:36:29 | 2022-11-08 21:41:10
Closed | 2022-11-01 08:38:06 | 2022-11-07 21:44:45 |  | 1
Closed | 2022-11-01 08:44:38 | 2022-11-17 21:41:08
Closed | 2022-11-01 08:53:45 | 2022-11-04 21:40:19 |  | 1
Spreadsheet: 854365d1704275932-checking-each-field-taking-data-from-latest-field-and-adding-to-one-specific-cell-dummy
Sheet: W10

IDs (Week 8 data (Week 15 since letter)) |  |  |  |  |  |  |  |  |  | IDs (Week 6 data (Week 17 since letter)) |  |  |  |  |  |  |  |  |  | IDs (Week 4 data (Week 19 since letter))
Group 1 | Group 2 |  |  |  | Group 3 |  |  |  |  | Group 1 | Group 2 |  |  |  | Group 3 |  |  |  |  | Group 1 | Group 2 |  |  |  | Group 3
No Contact | IDs | Date SMS Scheduled | SMS Status | Opted out? | IDs | Date call made | Was Call Successful? | Was call rescheduled? | Opted out of receiving calls? | No Contact | IDs | Date SMS Scheduled | SMS Status | Opted out? | IDs | Date call made | Was Call Successful? | Was call rescheduled? | Opted out of receiving calls? | No Contact | IDs | Date SMS Scheduled | SMS Status | Opted out? | IDs | Date call made | Was Call Successful? | Was call rescheduled? | Opted out of receiving calls? | Total Scheduled | Total Delivered | TotaloOpted out | Total Clicks | Total calls made | Total Successful | Total Rescheduled | Total Opt out of calls
 |  |  |  |  | 6761582522 | 2023-11-15 00:00:00 |  |  |  |  |  |  |  |  | 4616409551 | 2024-11-17 00:00:00 |  |  |  |  |  |  |  |  | 9615639148 | 2024-11-19 00:00:00