tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0a8bce26-c259-4370-9454-3553150f3fae
Sheet: SS

 |  |  | 11-12 |  |  |  | 12-13 |  |  |  | 13-14
Major | [NAME] | CrseNum | No. Students | Average GPA | Min GPA | [NAME] | No. Students | Average GPA | Min GPA | [NAME] | No. Students | Average GPA | Min GPA | [NAME]
Social Studies Educ-Grds 6-12 / History | ECON | 203 | 5 | 3 | 2 | 4 | 3 | 2.666666666666667 | 2 | 3 | 3 | 2.333333333333333 | 2 | 3
 |  | 204 | 3 | 3 | 1 | 4 | 2 | 3.5 | 3 | 4
 | GEOG | 101 | 5 | 2.6 | 2 | 4 | 3 | 3 | 2 | 4 | 3 | 3 | 3 | 3
 |  | 102 | 5 | 3 | 2 | 4 | 3 | 3.333333333333333 | 3 | 4 | 4 | 2.75 | 1 | 4
 |  | 111 | 5 | 2.6 | 0 | 4 | 2 | 3.5 | 3 | 4 | 2 | 3.5 | 3 | 4
 | GOVT | 201 | 7 | 2.714285714285714 | 1 | 4 | 3 | 3.666666666666667 | 3 | 4 | 3 | 3 | 2 | 4
 |  | 301 | 6 | 3.833333333333333 | 3 | 4 | 3 | 3.666666666666667 | 3 | 4 | 2 | 3 | 3 | 3
 | HIST | 101 | 8 | 2.5 | 0 | 4 | 3 | 3 | 3 | 3 | 3 | 2.333333333333333 | 2 | 3
 |  | 102 | 7 | 2.857142857142857 | 0 | 4 | 2 | 3 | 2 | 4 | 1 | 3 | 3 | 3
 |  | 121 | 6 | 3 | 2 | 4 | 3 | 4 | 4 | 4 | 2 | 3.5 | 3 | 4
 |  | 122 | 6 | 3.333333333333333 | 2 | 4 | 2 | 3.5 | 3 | 4 | 3 | 3.666666666666667 | 3 | 4
 |  | 201 | 6 | 3.5 | 2 | 4 | 3 | 3.666666666666667 | 3 | 4 | 3 | 3.333333333333333 | 3 | 4
 |  | 202 | 5 | 3.4 | 2 | 4 | 3 | 3.666666666666667 | 3 | 4 | 3 | 3.333333333333333 | 3 | 4
 |  | 301 | 5 | 3.2 | 2 | 4 | 3 | 3.666666666666667 | 3 | 4 | 5 | 2 | 0 | 4
 |  | 320 | 2 | 4 | 4 | 4
 |  | 330 | 5 | 3.8 | 3 | 4 | 3 | 4 | 4 | 4 | 2 | 3 | 3 | 3
 |  | 342 |  |  |  |  | 1 | 4 | 4 | 4
 |  | 344 | 1 | 3 | 3 | 3 | 1 | 4 | 4 | 4
 |  | 415 | 3 | 3.333333333333333 | 3 | 4 | 2 | 3.5 | 3 | 4
 |  | 416 | 1 | 3 | 3 | 3
 |  | 417 |  |  |  |  |  |  |  |  | 1 | 4 | 4 | 4
 |  | 435 | 2 | 3.5 | 3 | 4 | 1 | 4 | 4 | 4 | 2 | 4 | 4 | 4
 |  | 455 | 1 | 4 | 4 | 4
 | PHIL | 201 | 1 | 1 | 1 | 1
Social Studies Educ-Grds 6-12 / History Total |  |  | 95 | 3.094736842105263 | 0 | 4 | 46 | 3.5 | 2 | 4 | 42 | 2.976190476190476 | 0 | 4
Spreadsheet: 123517d1317711796-excel-2007-range-max-range-project_092911
Sheet: Sheet1

 |  | Or if you know alternative way to create the chart 34
 | Week no | Year | Date | Sales |  | Week | MAX | MIN
 |  |  | 2009-12-06 00:00:00 | 53495.19
 |  |  | 2009-12-07 00:00:00 | 53389.55
 |  |  | 2009-12-08 00:00:00 | 53197.31
 |  |  | 2009-12-09 00:00:00 | 53048.48
 |  |  | 2009-12-10 00:00:00 | 52992.38
 |  |  | 2009-12-11 00:00:00 | 52721.42
 |  |  | 2009-12-12 00:00:00 | 52521.69
 |  |  | 2009-12-13 00:00:00 | 52367.81
 |  |  | 2009-12-14 00:00:00 | 52150.98
 |  |  | 2009-12-15 00:00:00 | 51796.74
 |  |  | 2009-12-16 00:00:00 | 51353.21
 |  |  | 2009-12-17 00:00:00 | 50878.88
 |  |  | 2009-12-18 00:00:00 | 50385.45
 |  |  | 2009-12-19 00:00:00 | 49903.66
 |  |  | 2009-12-20 00:00:00 | 49456.19
 |  |  | 2009-12-21 00:00:00 | 48947.93
 |  |  | 2009-12-22 00:00:00 | 48400.52
 |  |  | 2009-12-23 00:00:00 | 48015.29
 |  |  | 2009-12-24 00:00:00 | 47766.66
 |  |  | 2009-12-25 00:00:00 | 47669.86
 |  |  | 2009-12-26 00:00:00 | 47657.38
 |  |  | 2009-12-27 00:00:00 | 47594.53
 |  |  | 2009-12-28 00:00:00 | 47467.12
 |  |  | 2009-12-29 00:00:00 | 47257.53
 |  |  | 2009-12-30 00:00:00 | 47117.89
 |  |  | 2009-12-31 00:00:00 | 47042.82
 |  |  | 2010-01-01 00:00:00 | 46958.41
 |  |  | 2010-01-02 00:00:00 | 46826.73
 |  |  | 2010-01-03 00:00:00 | 46612.5
 |  |  | 2010-01-04 00:00:00 | 46166.74
 |  |  | 2010-01-05 00:00:00 | 45713.29
 |  |  | 2010-01-06 00:00:00 | 45215.29
 |  |  | 2010-01-07 00:00:00 | 44742.36
 |  |  | 2010-01-08 00:00:00 | 44206.42
 |  |  | 2010-01-09 00:00:00 | 43666.43
 |  |  | 2010-01-10 00:00:00 | 43238.99
 |  |  | 2010-01-11 00:00:00 | 42828.07
 |  |  | 2010-01-12 00:00:00 | 42314.65
 |  |  | 2010-01-13 00:00:00 | 41785.93
 |  |  | 2010-01-14 00:00:00 | 41329.62
 |  |  | 2010-01-15 00:00:00 | 40867.87
 |  |  | 2010-01-16 00:00:00 | 40444.48
 |  |  | 2010-01-17 00:00:00 | 40146.6
 |  |  | 2010-01-18 00:00:00 | 39960.71
 |  |  | 2010-01-19 00:00:00 | 39588.49
 |  |  | 2010-01-20 00:00:00 | 39227.08
 |  |  | 2010-01-21 00:00:00 | 38803.12
 |  |  | 2010-01-22 00:00:00 | 38364.95
 |  |  | 2010-01-23 00:00:00 | 37942.33
 |  |  | 2010-01-24 00:00:00 | 37600.01
 |  |  | 2010-01-25 00:00:00 | 37229.03
 |  |  | 2010-01-26 00:00:00 | 36685.84
 |  |  | 2010-01-27 00:00:00 | 36046.16
 |  |  | 2010-01-28 00:00:00 | 35448.93
 |  |  | 2010-01-29 00:00:00 | 34949.98
 |  |  | 2010-01-30 00:00:00 | 34535.46
 |  | much more data
Spreadsheet: 0a08d7f4-8c74-4fa2-834b-e1169e580fc7
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
ASFR | Test | ASFR | [NAME], 24 Hour, [NAME] | [NAME], 24 Hr, U | Liquid-Liquid Extraction/Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) | [NAME], 24-hour graduated: 24Urine |  |  | 10 | mL | Collection Container/Tube: Clean, plastic urine container with no metal cap or glued insert. Submission Container/Tube: Plastic, 10-mL urine tube (Supply T068) or clean, plastic aliquot container with no metal cap or glued insert [NAME]: 10 mL Collection Instructions: 1. Collect urine for 24 hours. 2. No preservative. See [NAME] in Special Instructions for multiple collections. 3. Patient should not eat seafood for a 48-hour period prior to start of collection. 4. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. 5. Refrigerate specimen within 4 hours of completion of 24-hour collection. Additional Information: 1. 24-Hour volume is required. 2. High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours.   Urine Preservative Collection Options Ambient	Yes Refrigerated	Preferred Frozen	Yes 6N HCl	Yes 50% Acetic Acid	Yes Na2CO3	No Toluene	Yes 6N HNO3	No Boric Acid	No Thymol	No Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 2 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | INORGANIC ARSENIC 0-24 mcg/specimen  Reference values apply to all ages. | Monday through Friday; 11 a.m. | 2 days | 4 days | 1 | 82175 |  |  |  |  | Rochester
ASFR | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
ASFR | Order Question | TM4 | Collection Duration |  | Plain Text
ASFR | Order Question | VL2 | [NAME] |  | Plain Text
ASFR | Result | 3628 | Inorganic Arsenic (Toxic) | Inorganic Arsenic (Toxic) | Numeric |  |  |  |  | mcg/spec |  |  |  |  |  |  |  |  |  | 53838-9 | Arsenic.inorganic:MRat:24H:Urine:Qn:
ASFR | Result | 3629 | Organic Arsenic (Non-Toxic) | Organic Arsenic (Non-Toxic) | Numeric |  |  |  |  | mcg/spec |  |  |  |  |  |  |  |  |  | 53839-7 | Arsenic.organic:MRat:24H:[NAME]:Qn:
ASFR | Result | TM4 | Collection Duration | Collection Duration | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13362-9 | Collection duration:Time:*:Urine:Qn:
ASFR | Result | VL2 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3167-4 | [NAME] volume:Vol:24H:[NAME]:Qn:
Spreadsheet: 851462d1701699303-extract-multiple-dates-with-different-format-into-a-new-column-sample-date
Sheet: New 

CANCPenOrgDetails | Specimen_Collection_Date
pseudomonas aeruginosa           .05/27/2022 | 2022-05-27 00:00:00
CR-AB, 6/10/22 | 2022-06-10 00:00:00 | 2022/6/10
CRE, CR-PA
MRSA           .11/25/2021 | 2021-11-25 00:00:00 | 2021/11/25
CRE- SPUTUM           .11/26/2021 | 2021-11-26 00:00:00 | 2021/11/26
CRP PSEUDOMONAS           .02/20/2021 | 2021-02-20 00:00:00 | 2021/02/20
Psuedomonas           .02/25/2022 | 2022-02-25 00:00:00 | 2022/02/25
Escherichia coli 10/9/2021 | 2021-10-09 00:00:00 | 2021/10/9
05/10/2022 | 2022-05-10 00:00:00 | 2022/05/10
pseudomonas aeruginosa           .06/14/2022 | 2022-06-14 00:00:00 | 2022/06/14
KPC URINE 6/9/22 | 2022-06-09 00:00:00 | 2022/6/9
pseudomonas aeruginosa           .06/14/2022 | 2022-06-14 00:00:00 | 2022/06/14
[NAME] at Kindred BP
KLEBSIELL APNEUMONIAE           .01/19/2022 | 2022-01-19 00:00:00 | 2022/01/19
CRE           ..
CRAB and PSA CR           .05/04/2022 | 2022-05-04 00:00:00 | 2022/05/04
[NAME]           .06/15/2022 | 2022-06-15 00:00:00 | 2022/06/15
CRAB           .05/10/2022 | 2022-05-10 00:00:00 | 2022/05/10
CRAB and PSA CR           .05/04/2022 | 2022-05-04 00:00:00 | 2022/05/04
CARBAPENEM RESISTANT PSEUDOMONAS AERUGINOSA           .07/26/2022 | 2022-07-26 00:00:00 | 2022/07/26
CRE           .07/23/2022 | 2022-07-23 00:00:00 | 2022/07/23
pseudomonas, 8/3/22 | 2022-08-03 00:00:00 | 2022/8/3
Spreadsheet: juan_hernandez__17548__Presto A&A
Sheet: Sheet1

Full-Time Associates | Allocated To | Assigned to: | Supervisor | Orientation Start Date | Business Unit Start Date:
[NAME] | ENA | [NAME] | [NAME] | 2001-08-06 00:00:00 | TBC | F
[NAME] | ENA | [NAME] | [NAME] | 2001-08-06 00:00:00 | TBC
[NAME] | ENA | [NAME] | [NAME] | 2001-08-06 00:00:00 | TBC
[NAME] | ENA | [NAME] | [NAME] | 2001-08-06 00:00:00 | TBC
[NAME] | ENA | [NAME] | [NAME] | 2001-08-06 00:00:00 | TBC
[NAME] | ENA | [NAME] | [NAME] | 2001-08-06 00:00:00 | TBC
[NAME] | ENA | [NAME] | [NAME] | 2001-08-06 00:00:00 | TBC
[NAME] | ENA | [NAME] | [NAME] | 2001-08-06 00:00:00 | TBC
[NAME] | ENA | [NAME] | [NAME] | 2001-08-06 00:00:00 | TBC
[NAME] | ENA | [NAME] | [NAME] | 2001-08-06 00:00:00 | TBC
Lua Boon | ENA | [NAME] | [NAME] | 2001-08-06 00:00:00 | TBC
Philippov Maxim | ENA | [NAME] | [NAME] | 2001-08-06 00:00:00 | TBC
Young Julia | ENA | [NAME] | [NAME] | 2001-08-06 00:00:00 | TBC
[NAME] | ENA | [NAME] | [NAME] | 2001-08-06 00:00:00 | TBC
[NAME] | ENA | [NAME] | [NAME] | 2001-08-06 00:00:00 | TBC
Marquez Mauricio | ENA | [NAME] | [NAME] | 2001-08-06 00:00:00 | TBC
[NAME] | ENA | [NAME] | [NAME] | 2001-08-06 00:00:00 | TBC
Full-time Analysts | Allocated to | Lead | Supervisor | Orientation Start Date | Business Unit Start Date
[NAME] | ENA | [NAME] | [NAME] | 2001-07-16 00:00:00 | TBC
[NAME] | ENA | [NAME] | [NAME] | 2001-07-16 00:00:00 | TBC
[NAME] | ENA | [NAME] | [NAME] | 2001-07-16 00:00:00 | TBC
[NAME] | ENA | [NAME] | [NAME] | 2001-07-16 00:00:00 | TBC
[NAME] | ENA | [NAME] | [NAME] | 2001-07-16 00:00:00 | TBC
[NAME] | ENA | [NAME] | [NAME] | 2001-07-16 00:00:00 | TBC
[NAME] | ENA | [NAME] | Tricoli Carol | 2001-07-16 00:00:00 | TBC
Horne Jonathan | ENA | [NAME] | Tricoli Carol | 2001-07-16 00:00:00 | TBC
Inman Zachary | ENA | [NAME] | Tricoli Carol | 2001-07-16 00:00:00 | TBC
[NAME] | ENA | [NAME] | Tricoli Carol | 2001-07-16 00:00:00 | TBC
[NAME] | ENA | [NAME] | [NAME] | 2001-07-16 00:00:00 | TBC
[NAME] | ENA | [NAME] | [NAME] | 2001-07-16 00:00:00 | TBC
Puntumapanitch [NAME] | ENA | [NAME] | [NAME] | 2001-07-16 00:00:00 | TBC
Raque Michele | ENA | [NAME] | [NAME] | 2001-07-16 00:00:00 | TBC
[NAME] | ENA | [NAME] | [NAME] | 2001-07-16 00:00:00 | TBC
[NAME] | ENA | [NAME] | [NAME] | 2001-07-16 00:00:00 | TBC
[NAME] | ENA | [NAME] | [NAME] | 2001-07-16 00:00:00 | TBC
[NAME] | ENA | [NAME] | [NAME] | 2001-07-16 00:00:00 | TBC
Intern Associates | Allocated To | Lead | Supervisor | Start Date
Smith Raiford | ENA | [NAME] | [NAME] | 2001-06-04 00:00:00
[NAME] | ENA | [NAME] | [NAME] | 2001-05-21 00:00:00
[NAME] | ENA | [NAME] | [NAME] | 2001-06-04 00:00:00
Finger [NAME] | ENA | [NAME] | [NAME] | 2001-05-21 00:00:00
[NAME] | ENA | [NAME] | [NAME] | 2001-05-21 00:00:00
Wolfe [NAME] | ENA | [NAME] | [NAME] | 2001-05-21 00:00:00
Summer Analysts | Allocated to | Lead | Supervisor | Start Date
Spector [NAME] | ENA | [NAME] | [NAME] | 2001-06-04 00:00:00
[NAME] | ENA | [NAME] | [NAME] | 2001-05-21 00:00:00
[NAME] [NAME] | ENA | [NAME] | [NAME] | 2001-05-21 00:00:00
Woods Bejamin | ENA | [NAME] | [NAME] | 2001-05-21 00:00:00
Spreadsheet: 849038d1699608034-unique-count-function-test-2-1-
Sheet: Sheet1

 | Fund 1 | Fund 2 |  |  |  |  | Product Name | Name | Sector
No. of Holdings |  | 3 |  |  |  |  | Fund 1 | Apple | A
Answer should be | 5 | 3 |  |  |  |  | Fund 1 | Apple | A
 |  |  |  |  |  |  | Fund 1 | Alphabet | B
 |  |  |  |  |  |  | Fund 1 | Alphabet | B
 |  |  |  |  |  |  | Fund 1 | Alphabet | B
 |  |  |  |  |  |  | Fund 1 | TSMC | A
 |  |  |  |  |  |  | Fund 1 | TSMC | A
 |  |  |  |  |  |  | Fund 1 | AON | C
 |  |  |  |  |  |  | Fund 1 | Tesla | D
 |  |  |  |  |  |  | Fund 1 | Bond | Cash
 |  |  |  |  |  |  | Fund 2 | Meta | B
 |  |  |  |  |  |  | Fund 2 | Meta | B
 |  |  |  |  |  |  | Fund 2 | Microsoft | A
 |  |  |  |  |  |  | Fund 2 | Bond | Cash
 |  |  |  |  |  |  | Fund 2 | Bond | Cash
 |  |  |  |  |  |  | Fund 2 | Mastercard | C
 |  |  |  |  |  |  | Fund 2 | Mastercard | C
Spreadsheet: 268658d1380725701-how-to-get-true-or-false-based-on-2-conditions-task
Sheet: Sheet1

 | Product
Store | A | B | C | D
1 | 1 | 1 | 0 | 1
2 | 1 | 0 | 1 | 0
3 | 0 | 1 | 0 | 0
4 | 0 | 1 | 0 | 0
5 | 0 | 0 | 0 | 0
6 | 0 | 0 | 1 | 0
7 | 1 | 0 | 0 | 0
Spreadsheet: 113018d1308949896-countif-column-range-equals-any-other-cell-in-same-range-sample-30readmit
Sheet: Sheet1

Patient ID# | REG# | discharge date |  | counter | id+count | days since last admission
208623 | E00034205310 | 2010-01-14 00:00:00
208623 | E00032161408 | 2010-05-19 00:00:00
208623 | E00032400442 | 2010-09-01 00:00:00
208623 | E00032639080 | 2010-09-24 00:00:00
208851 | E00033702549 | 2010-05-04 00:00:00 |  |  |  |  |  |  | Instances of 30-day re-admissions
208972 | E00033898446 | 2010-07-15 00:00:00 |  |  |  |  |  |  | # patients that have been re-admitted within 30 days |  |  |  | ?
208972 | E00033959040 | 2010-08-30 00:00:00
208972 | E00033996083 | 2010-09-23 00:00:00
209085 | E00034454488 | 2009-12-28 00:00:00
209085 | E00034482380 | 2010-03-19 00:00:00
209706 | E00031985989 | 2010-03-16 00:00:00
219002 | E00032774721 | 2010-04-03 00:00:00
219002 | E00033585902 | 2010-09-29 00:00:00
219326 | E00034305938 | 2009-12-30 00:00:00
220069 | E00034394767 | 2010-01-04 00:00:00
220114 | E00033785049 | 2009-12-25 00:00:00
220114 | E00033460072 | 2010-09-13 00:00:00
220704 | E00033849910 | 2009-12-17 00:00:00
220984 | E00034028183 | 2009-11-03 00:00:00
220984 | E00032300030 | 2009-12-02 00:00:00
Spreadsheet: 680487d1591043668-assessment-report-result-formulas-20200-06-01-oeldere-mariyav-1041000-assessment-report-result-formulas-measures-assessment
Sheet: Requirements

 | Requirement | Answer | Result | [NAME] | [NAME] answer NA
 |  | Fully compliant |  | 10
 |  | Not applicable |  | 10
 |  | Partially compliant |  | 10
 |  | Not applicable |  | 10
 |  | Fully compliant |  | 10
 |  | Fully compliant |  | 10
 |  | Fully compliant |  | 10
 |  | Fully compliant |  | 10
 |  | Fully compliant |  | 10
 |  | Fully compliant |  | 10
 |  | Total
 | I need your help. I have a report file with requirements (deleted because are not in english) and i have to assess each. The possible answers are: fully compliant, partially compliant, not implemented and not applicable. When i choose the answers "not applicable" i want to not decrease the total result. With these formulas i used it is possible if only have answers ''fully" and ''NA". Could you please help me with formulas?
 | When i choose the answers "not applicable" i want to not decrease the total result. With these formulas i used it is possible if only have answers ''fully" and ''NA". Could you please help me with formulas?
Spreadsheet: 287069d1388617259-generating-custom-timeline-on-separate-tab-help_example_2
Sheet: Daily Log

Date | State | Org | Truck Type | ID | F/ID | Null | Activity 1 | Activity 2 | Operation 1 | Location
2013-09-18 00:00:00 | IL | AWS | Mack | 119 |  |  |  |  | x | 1900
2013-09-18 00:00:00 | IL | AWS | Ford | 104 |  |  |  |  |  | 2100
2013-09-18 00:00:00 | WI | CLE | Peterbuilt | 66
2013-09-18 00:00:00 | WI | CLE | [NAME] | 69
2013-09-18 00:00:00 | MD | WM | Freightliner | 556 |  |  |  |  |  | 1456
2013-09-18 00:00:00 | VA | WM | Freightliner | 1573 |  |  | x
2013-09-18 00:00:00 | VA | KWS | Chevy | 2146 |  |  | x
2013-09-18 00:00:00 | WI | CLE | [NAME] | 69 |  | y
 |  |  |  |  |  | x
2013-09-19 00:00:00 | IL | AWS | Ford | 104 |  |  |  |  |  | 1409
2013-09-19 00:00:00 | WI | CLE | Peterbuilt | 2166 | 66
2013-09-19 00:00:00 | WI | CLE | [NAME] | 69
2013-09-19 00:00:00 | MD | WM | Freightliner | 556 |  |  |  |  |  | 1875
2013-09-19 00:00:00 | VA | WM | Freightliner | 1573 |  |  | x | x
2013-09-19 00:00:00 | VA | KWS | Chevy | 2146 |  |  | x | x
 |  |  |  |  |  | x
2013-09-20 00:00:00 | IL | AWS | Ford | 104 |  |  |  |  |  | 2343
2013-09-20 00:00:00 | WI | CLE | Peterbuilt | 2166 | 66
2013-09-20 00:00:00 | MD | WM | Freightliner | 590 |  |  |  |  |  | 2231
2013-09-20 00:00:00 | VA | KWS | Chevy | 2366
 |  |  |  |  |  | x
Spreadsheet: 851397d1701640484-how-to-organize-raw-data-fields-for-maximum-extrapolation-calendar
Sheet: Sheet1

2023-11-01 00:00:00
Sun | Mon | Tue | Wed | Thu | Fri | Sat |  |  | Search | Count
2023-11-01 00:00:00 | 2023-11-02 00:00:00 | 2023-11-03 00:00:00 | 2023-11-04 00:00:00 | 2023-11-05 00:00:00 | 2023-11-06 00:00:00 | 2023-11-07 00:00:00 |  |  | NTE
2023-11-08 00:00:00 | 2023-11-09 00:00:00 | 2023-11-10 00:00:00 | 2023-11-11 00:00:00 | 2023-11-12 00:00:00 | 2023-11-13 00:00:00 | 2023-11-14 00:00:00
2023-11-15 00:00:00 | 2023-11-16 00:00:00 | 2023-11-17 00:00:00 | 2023-11-18 00:00:00 | 2023-11-19 00:00:00 | 2023-11-20 00:00:00 | 2023-11-21 00:00:00
2023-11-22 00:00:00 | 2023-11-23 00:00:00 | 2023-11-24 00:00:00 | 2023-11-25 00:00:00 | 2023-11-26 00:00:00 | 2023-11-27 00:00:00 | 2023-11-28 00:00:00
2023-11-29 00:00:00 | 2023-11-30 00:00:00
Spreadsheet: 732980d1621345144-gantt-chart-test_data_excel
Sheet: Gantt

Project | Client Name | Windows | Cement | Doors
1.2 Franklin | [NAME] | 2021-05-03 00:00:00 | 2021-07-11 00:00:00 | 2021-07-05 00:00:00
12.3 [NAME] | [NAME], | 2021-08-01 00:00:00 | 2021-10-07 00:00:00 | 2021-10-01 00:00:00
2.3 [NAME] | Mark | 2021-06-03 00:00:00 | 2021-07-12 00:00:00 | 2021-07-06 00:00:00
43.4 maple | [NAME] | 2021-07-14 00:00:00 | 2021-09-22 00:00:00 | 2021-09-16 00:00:00
44 Walnut | Miason | 2021-08-03 00:00:00 | 2021-11-07 00:00:00 | 2021-11-01 00:00:00
53.3 Franks | [NAME] | 2021-07-09 00:00:00 | 2021-09-07 00:00:00 | 2021-09-01 00:00:00
Grand Total
Project | Client
1.2 Franklin | [NAME]
12.3 [NAME] | [NAME],
2.3 [NAME] | Mark
43.4 maple | [NAME]
44 Walnut | Miason
53.3 Franks | [NAME]
 |  | 5/3/2021                      6/1/2021 | 7/2/2021 | 8/1/2021       9/7/2021
Spreadsheet: 190329d1351615556-can-pivot-tables-count-individula-records-dummy
Sheet: Sheet1

Account Num
9999
9999
9999
9999
9999
9999
88888
88888
88888
88888
88888
88888
88888
88888
88888
88888
101010
101010
101010
101010
101010
101010
101010
101010
101010
101010
123456
123456
123456
123456
123456
123456
123456
123456
123456
123456
7777777
7777777
7777777
7777777
7777777
7777777
7777777
7777777
7777777
7777777
Spreadsheet: 870852d1717316351-countif-conditional-formatting-lotto-bingo2-aligw
Sheet: List

A | 5 | 11 | 20 | 26 | 30 | 37 | 40 | 50 | 53 | 59
B | 3 | 9 | 11 | 14 | 15 | 29 | 31 | 39 | 44 | 58
C | 7 | 18 | 27 | 28 | 29 | 34 | 37 | 43 | 48 | 55
D | 5 | 6 | 9 | 15 | 37 | 38 | 39 | 42 | 52 | 58
E | 8 | 10 | 19 | 29 | 31 | 39 | 44 | 47 | 51 | 57 |  |  | Column L calculates how many numbers each user has, but it is counting repeated numbers. Is it possible to count the cells that are formatted yellow
F | 5 | 12 | 16 | 21 | 22 | 27 | 30 | 43 | 53 | 55
G | 3 | 4 | 11 | 14 | 20 | 24 | 44 | 45 | 52 | 57
H | 5 | 12 | 20 | 22 | 23 | 29 | 30 | 38 | 54 | 56
I | 3 | 10 | 11 | 24 | 33 | 37 | 42 | 46 | 55 | 59
J | 4 | 7 | 11 | 15 | 21 | 26 | 31 | 33 | 34 | 43
K | 8 | 14 | 19 | 21 | 35 | 49 | 51 | 54 | 56 | 59
L | 9 | 12 | 23 | 33 | 34 | 36 | 38 | 40 | 54 | 55
M | 6 | 11 | 17 | 23 | 27 | 29 | 35 | 38 | 48 | 57
N | 2 | 6 | 14 | 20 | 23 | 24 | 29 | 37 | 47 | 49
O | 9 | 11 | 16 | 21 | 23 | 25 | 29 | 52 | 56 | 59
P | 2 | 3 | 7 | 8 | 18 | 26 | 30 | 31 | 36 | 53
Q | 2 | 5 | 16 | 18 | 19 | 26 | 49 | 54 | 55 | 59
R | 12 | 14 | 15 | 16 | 28 | 40 | 42 | 49 | 51 | 52
S | 4 | 7 | 12 | 21 | 28 | 34 | 39 | 42 | 47 | 52
T | 8 | 12 | 17 | 26 | 33 | 34 | 35 | 36 | 38 | 59
U | 1 | 8 | 10 | 42 | 43 | 47 | 56 | 57 | 58 | 59
V | 4 | 8 | 28 | 31 | 39 | 41 | 43 | 44 | 45 | 58
W | 6 | 8 | 12 | 16 | 20 | 32 | 52 | 56 | 57 | 58
X | 7 | 10 | 22 | 23 | 31 | 38 | 41 | 42 | 54 | 57
Y | 2 | 7 | 13 | 14 | 16 | 19 | 25 | 51 | 54 | 59
 | 3 | 11 | 28 | 29 | 32 | 34 | 42 | 47 | 54 | 58
Z | 6 | 8 | 13 | 27 | 40 | 44 | 45 | 46 | 55 | 58
 | 2 | 6 | 12 | 14 | 15 | 24 | 30 | 32 | 44 | 45
AA | 4 | 6 | 10 | 11 | 23 | 24 | 42 | 43 | 52 | 58
 | 8 | 15 | 16 | 18 | 20 | 32 | 33 | 49 | 53 | 57
Spreadsheet: e2377323-facf-4cc5-8d30-1ace6d160b83
Sheet: Sheet1

Release: Housing Units Authorized By Building Permits (Seasonally Adjusted) | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=246
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-04-23 1:26 PM CDT
 | Real-Time | Period
Name: | Start | End
Housing Units Authorized By Building Permits (Seasonally Adjusted) | 2011-12-23 00:00:00 | Current
Link:
http://www.census.gov/construction/bps/ | 2011-12-23 00:00:00 | Current
Source:
Federal Reserve Bank of St. Louis | 2011-12-23 00:00:00 | Current
Notes:
Census data seasonally adjusted by the Federal Reserve Bank of Saint | 2011-12-23 00:00:00 | Current
Louis.
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:
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: 53877d1253801060-vlookup-or-index-match-book2
Sheet: Total

PART | QTY Needed | QTY On hand | QTY Purchase
100 | 1 | 1 | 0
101 | 3 | 3 | 0
102 | 4 | 3 | 1
103 | 55 | 0 | 55
104 | 8 | 2 | 6
105 | #N/A | #N/A | #N/A