tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: benjamin_rogers__1007__NYISOLoads ver2
Sheet: DailySummary

Date: | 2001-09-04 00:00:00
 |  |  |  |  |  |  |  |  |  | Zone: |  |  |  |  | Zone: |  |  |  |  | Zone:
 |  |  |  |  |  |  |  |  |  | A | RT | DA |  |  | G | RT | DA |  |  | J | RT | DA
 |  |  |  |  |  |  |  |  |  | MAX | 44.52 | 33 |  |  | MAX | 48.36 | 39.45 |  |  | MAX | 50.07 | 39.82
 |  |  |  |  |  |  |  |  |  | AVG | 30.01 | 27.33 |  |  | AVG | 32.02 | 31.39 |  |  | AVG | 33.12 | 32.43
 |  |  |  |  |  |  |  |  | 2001-09-03 00:00:00 | MAX | 32.55 | 29.97 |  |  | MAX | 35.45 | 35.89 |  |  | MAX | 36.59 | 36.14
 |  |  |  |  |  |  |  |  |  | AVG | 14.01 | 26.21 |  |  | AVG | 15.49 | 30.29 |  |  | AVG | 16.08 | 30.57
 |  |  |  |  |  |  |  |  | 2001-09-02 00:00:00 | MAX | 30.24 | 34.07 |  |  | MAX | 33.12 | 39.35 |  |  | MAX | 34.44 | 39.71
 |  |  |  |  |  |  |  |  |  | AVG | 20.49 | 26.32 |  |  | AVG | 21.89 | 29.73 |  |  | AVG | 23.48 | 30.1
 |  |  |  |  |  |  |  |  | 2001-09-01 00:00:00 | MAX | 76.53 | 33 |  |  | MAX | 83.54 | 39.45 |  |  | MAX | 87.01 | 39.82
 |  |  |  |  |  |  |  |  |  | AVG | 34.9 | 27.33 |  |  | AVG | 38.03 | 31.39 |  |  | AVG | 40.95 | 32.43
 |  |  |  |  |  |  |  |  | 2001-08-31 00:00:00 | MAX | 118.16 | 44.88 |  |  | MAX | 249.5 | 53.68 |  |  | MAX | 466.42 | 57.29
 |  |  |  |  |  |  |  |  |  | AVG | 41.76 | 33.05 |  |  | AVG | 64.93 | 38.11 |  |  | AVG | 118.18 | 44.2
 |  |  |  |  |  |  |  |  | 2001-08-30 00:00:00 | MAX | 48.09 | 42.73 |  |  | MAX | 53.4 | 50.25 |  |  | MAX | 56.66 | 50.71
 |  |  |  |  |  |  |  |  |  | AVG | 31.17 | 32.7 |  |  | AVG | 33.95 | 37.36 |  |  | AVG | 40.69 | 37.9
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
 | Enron Forecast | 15803.5595209191 | 15232.3151791119 | 14920.7111525509 | 14911.0811551509 | 15688.7869883481 | 17212.2956811319 | 19164.9937067298 | 20676.1500353058 | 21776.7770881147 | 22548.2844651929 | 23019.8901544214 | 23245.0432543058 | 23509.4468838488 | 23623.8132133357 | 23633.2680016006 | 23570.1534670894 | 23153.4691368981 | 22279.3353076591 | 22071.3318700713 | 22156.6299368444 | 21390.3573355257 | 19923.1025327455 | 18052.7647644889 | 16710.0090963832
 | Customer Forecast | 16459 | 15903 | 15568 | 15715 | 16434 | 17778 | 20614 | 22333 | 23477 | 24408 | 25018 | 25218 | 25479 | 25498 | 25499 | 25397 | 24936 | 23885 | 23117 | 23166 | 22398 | 20766 | 18462 | 17376
 | Actual Load | 16423 | 15805 | 15442 | 15410 | 16056 | 17363 | 19160 | 20784 | 22039 | 22929 | 23364 | 23558 | 23798 | 23925 | 23954 | 23946 | 23565 | 22579 | 21979 | 22315 | 21429 | 19853 | 18098 | 17437
 | Enron Deviation from Customer
 | Enron Deviation From Actual
Spreadsheet: 802834d1667058703-aggregate-function-problem-in-expenses-spreadshhet-expenses
Sheet: Results required

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | those
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Emma
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The blue formula will look up the green code in the report to produce a vertical list of only the results that match the green codes in line 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The pink formula would have to look up the code (ie AAA111) and the description (ie in column AU) to het the totals for column AV
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IFERROR(INDEX(Report!AA:AA,AGGREGATE(15,6,ROW(Report!$AA$5:$AA$2000)/(COUNTIF(Report!$AA$5:$AA$2000,Report!$AA$5:$AA$200)=AU25),1)),"")
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This is th [NAME] I cant make work in AU2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | There are hundreds of green codes - so the final result will be a very wide spreadsheet
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | There us average of about 5000 lines of expenses
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Each individual expense is then printed below line 25 for each code- that bit I have had not trouble with - I just cant create the summary at the top
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AAA111 |  |  |  |  | AAA222 |  |  |  |  | BBB111 |  |  |  |  | CCC111
Spreadsheet: 222822d1363957380-data-label-assistance-909256
Sheet: PE

MONTH | 2013 Actual - RFA | 2013 Actual - EHP | 2013 Actual - EHSQ | 2013 Actual - WHP | Total Days Available | Percentage Usage
December |  |  |  |  | 132
November |  |  |  |  | 126
October |  |  |  |  | 138
September |  |  |  |  | 126
August |  |  |  |  | 132
July |  |  |  |  | 138
June |  |  |  |  | 120
May |  |  |  |  | 138
April |  |  |  |  | 121
March |  |  |  |  | 105
February | 42 | 26.5 | 9.5 |  | 78
January | 40.5 | 39 | 3.5 |  | 110
MONTH | 2013 Forecast - RFA | 2013 Forecast - EHP | 2013 Forecast - EHSQ | 2013 Forecast - WHP | Total Days Available | Percentage Usage
December | 20 | 55 | 20 |  | 132
November | 20 | 55 | 20 |  | 126
October | 40 | 65 | 20 |  | 138
September | 80 | 65 | 20 |  | 126
August | 80 | 65 | 20 |  | 132
July | 102 | 55 | 20 |  | 138
June | 82 | 60 |  |  | 120
May | 92 | 60 |  |  | 138
April | 74 | 44 |  |  | 121
March | 50 | 54 | 7 |  | 105
February |  |  |  |  | 78
January |  |  |  |  | 110
MONTH | 2013 Combined - RFA | 2013 Combined - EHP | 2013 Combined - EHSQ | 2013 Combined - WHP | Total Days Available | Percentage Usage
December |  |  |  |  | 132
November |  |  |  |  | 126
October |  |  |  |  | 138
September |  |  |  |  | 126
August |  |  |  |  | 132
July |  |  |  |  | 138
June |  |  |  |  | 120
May |  |  |  |  | 138
April |  |  |  |  | 121
March |  |  |  |  | 105
February |  |  |  |  | 78
January |  |  |  |  | 110
Spreadsheet: 769898d1645719748-lookup-based-on-a-partial-text-string-coding-maybe-an-if-statment
Sheet: Sheet1

Reference |  | number | just as an exemple - Translation from Column I to Column G.
TDE |  | TJB 73894 | if it starts with TJ in column C, I would like to see TODX in column B
TXDC |  | TJH 76063 | if it starts with TJ in column C, I would like to see TODX in column B |  |  |  |  | The blue arrows are just exemple
TODO |  | TJC 96559 | if it starts with TJ in column C, I would like to see TODX in column B
TODQ |  | TJF 10198 | if it starts with TJ in column C, I would like to see TODX in column B |  |  |  |  | translation of a po numbe to where it belongs
TODT |  | TJN 17214 | if it starts with TJ in column C, I would like to see TODX in column B |  |  |  |  | PO number TJB XXXX belongs to TODX, but so do also TJH XXX, so if I could get all the ones in column C and just the 2 first digit.
TODX |  | TJN 17214 | if it starts with TJ in column C, I would like to see TODX in column B |  |  |  |  | to translate to the reference in column A and then get the result in Column B.
TODC |  | TJC 96290 | if it starts with TJ in column C, I would like to see TODX in column B
OTKA |  | TJC 97309 | if it starts with TJ in column C, I would like to see TODX in column B |  |  |  |  | The 2 first digits in column C tells what reference that needs to be in column B
TATL |  | T!R 75258 | if it starts with T! I want to see TDE in column B |  |  |  |  | TJ = | TODX
TEXU |  | TJB 73894 | if it starts with TJ in column C, I would like to see TODX in column B |  |  |  |  | T! = | TDE
TXC |  | TJH 76063 | if it starts with TJ in column C, I would like to see TODX in column B |  |  |  |  | TX = | XXST
TDD |  | TJC 96559 | if it starts with TJ in column C, I would like to see TODX in column B
TDK |  | TJF 10198 | if it starts with TJ in column C, I would like to see TODX in column B
MIDX |  | TJN 17214 | if it starts with TJ in column C, I would like to see TODX in column B
[NAME] |  | TJN 17214 | if it starts with TJ in column C, I would like to see TODX in column B
XQIE |  | TJC 96290 | if it starts with TJ in column C, I would like to see TODX in column B
XXST |  | TJC 97309 | if it starts with TJ in column C, I would like to see TODX in column B
 |  | T!R 75258 | if it starts with T! I want to see TDE in column B
 |  | TJB 73894 | if it starts with TJ in column C, I would like to see TODX in column B
 |  | TJH 76063 | if it starts with TJ in column C, I would like to see TODX in column B
 |  | TJC 96559 | if it starts with TJ in column C, I would like to see TODX in column B
 |  | TJF 10198 | if it starts with TJ in column C, I would like to see TODX in column B
 |  | TJN 17214 | if it starts with TJ in column C, I would like to see TODX in column B
 |  | TXJN 17214 | if it starts with TX in column C, I would like to see XXST in column B
 |  | TJC 96290 | if it starts with TJ in column C, I would like to see TODX in column B
 |  | TJC 97309 | if it starts with TJ in column C, I would like to see TODX in column B
 |  | T!R 75258 | if it starts with T! I want to see TDE in column B
Spreadsheet: 812430d1673138768-averageif-using-a-sum-of-two-columns-as-the-criterion-example-grosses-1-
Sheet: Sheet1

Show | Type | Theatre | #Prev | #Perf | Grosses | Grosses Prev. Week | Attend | Attend Prev Week |  | Average Grosses =8 Perf
& JULIET | Musical | [NAME] | 0 | 8 | 1639788 | 927233 | 9249 | 6927
1776 - 2022 | Musical | American Airlines | 0 | 8 | 326223 | 130242 | 4883 | 2657
A BEAUTIFUL NOISE, THE NEIL DIAMOND MUSICAL | Musical | Broadhurst | 0 | 8 | 1425882 | 788207 | 8722 | 5351
A CHRISTMAS CAROL 2022 | Play | Nederlander | 0 | 8 | 522424 | 729574 | 5815 | 5962
A STRANGE LOOP | Musical | Lyceum | 0 | 8 | 731420 | 283086 | 6947 | 3138
ALADDIN | Musical | New Amsterdam | 2 | 6 | 2849723 | 1642298 | 15531 | 11911
ALMOST FAMOUS | Musical | Jacobs | 0 | 8 | 1055042 | 651161 | 7919 | 5687
BEETLEJUICE 2022 | Musical | [NAME] | 0 | 8 | 2462831 | 1394443 | 14537 | 10778
BETWEEN RIVERSIDE AND CRAZY | Play | [NAME] | 0 | 8 | 260085 | 131019 | 4456 | 3063
CHICAGO | Musical | Ambassador | 0 | 8 | 1299404 | 721865 | 9844 | 7076
DEATH OF A SALESMAN 2022 | Play | Hudson | 0 | 8 | 624507 | 330890 | 7004 | 4454
FUNNY GIRL 2022 | Musical | August Wilson | 3 | 5 | 2405901 | 1895185 | 10228 | 8501
HADESTOWN | Musical | [NAME] | 0 | 8 | 1279810 | 760630 | 8361 | 6463
HAMILTON | Musical | [NAME] | 0 | 9 | 2740599 | 2656102 | 10767 | 10691
HARRY POTTER AND THE CURSED CHILD | Play | Lyric | 0 | 8 | 2671191 | 1993974 | 12976 | 12768
INTO THE WOODS 2022 | Musical | St. James | 0 | 8 | 1892625 | 876396 | 14043 | 8259
KIMBERLY AKIMBO | Musical | Booth | 0 | 7 | 674356 | 510827 | 5816 | 4578
LEOPOLDSTADT | Play | Longacre | 0 | 8 | 915701 | 655269 | 7929 | 5619
MIKE BIRBIGLIA: THE OLD MAN & THE POOL | Play | [NAME] | 0 | 8 | 619469 | 341950 | 7718 | 4956
MJ THE MUSICAL | Musical | [NAME] | 0 | 8 | 2223069 | 1840567 | 11138 | 11107
MOULIN ROUGE! THE MUSICAL | Musical | [NAME] | 0 | 8 | 1975132 | 1159957 | 11691 | 8756
OHIO STATE MURDERS | Play | [NAME] | 0 | 8 | 311893 | 182502 | 4731 | 2682
SIX | Musical | [NAME] | 0 | 8 | 1649206 | 1274284 | 8265 | 7960
SOME LIKE IT HOT | Musical | Shubert | 1 | 8 | 1176786 | 543368 | 11044 | 5295
TAKE ME OUT 2023 | Play | [NAME] | 0 | 7 | 537589 | 224363 | 6307 | 3473
THE BOOK OF MORMON | Musical | [NAME] | 0 | 8 | 1680124 | 1084164 | 9768 | 7078
THE COLLABORATION | Play | Friedman | 0 | 8 | 248590 | $ | 3374
THE LION KING | Musical | [NAME] | 0 | 8 | 4315264 | 2590306 | 15147 | 11437
THE MUSIC MAN 2022 | Musical | Winter Garden | 0 | 9 | 3971531 | 2617660 | 13896 | 10316
THE PHANTOM OF THE OPERA | Musical | Majestic | 0 | 8 | 2788017 | 1921572 | 14690 | 11397
THE PIANO LESSON 2022 | Play | Ethel Barrymore | 0 | 8 | 1140437 | 639201 | 8835 | 5393
TOPDOG / UNDERDOG 2022 | Play | Golden | 0 | 7 | 345567 | 200630 | 3913 | 2642
WICKED | Musical | Gershwin | 2 | 6 | 3152679 | 2362930 | 17334 | 15120
Spreadsheet: 182080d1348254093-how-do-i-set-up-a-worksheet-within-a-spreadsheet-that-can-be-used-to-find-specific-data-sample-data
Sheet: AMC

[NAME] | Exhibitor | Theatre ID | Theatre | 2012-09-28 00:00:00 | 2012-10-05 00:00:00 | 2012-10-12 00:00:00 | 2012-10-19 00:00:00 | 2012-10-26 00:00:00 | 2012-11-02 00:00:00 | 2012-11-09 00:00:00 | 2012-11-16 00:00:00 | 2012-11-23 00:00:00 | 2012-11-30 00:00:00 | 2012-12-07 00:00:00 | 2012-12-14 00:00:00 | 2012-12-21 00:00:00 | 2012-12-28 00:00:00 | 2013-01-04 00:00:00 | 2013-01-11 00:00:00 | 2013-01-18 00:00:00 | 2013-01-25 00:00:00 | 2013-02-01 00:00:00 | 2013-02-08 00:00:00 | 2013-02-15 00:00:00 | 2013-02-22 00:00:00 | 2013-03-01 00:00:00 | 2013-03-08 00:00:00 | 2013-03-15 00:00:00 | 2013-03-22 00:00:00 | 2013-03-29 00:00:00 | 2013-04-05 00:00:00 | 2013-04-12 00:00:00 | 2013-04-19 00:00:00 | 2013-04-26 00:00:00 | 2013-05-03 00:00:00 | 2013-05-10 00:00:00 | 2013-05-17 00:00:00 | 2013-05-24 00:00:00 | 2013-05-31 00:00:00 | 2013-06-07 00:00:00 | 2013-06-14 00:00:00 | 2013-06-21 00:00:00 | 2013-06-28 00:00:00 | 2013-07-05 00:00:00 | 2013-07-12 00:00:00 | 2013-07-19 00:00:00 | 2013-07-26 00:00:00 | 2013-08-02 00:00:00 | 2013-08-09 00:00:00 | 2013-08-16 00:00:00 | 2013-08-23 00:00:00 | 2013-08-30 00:00:00 | 2013-09-06 00:00:00 | 2013-09-13 00:00:00 | 2013-09-20 00:00:00 | 2013-09-27 00:00:00 | 2013-10-04 00:00:00 | 2013-10-11 00:00:00 | 2013-10-18 00:00:00 | 2013-10-25 00:00:00 | 2013-11-01 00:00:00 | 2013-11-08 00:00:00 | 2013-11-15 00:00:00 | 2013-11-22 00:00:00 | 2013-11-29 00:00:00 | 2013-12-06 00:00:00 | 2013-12-13 00:00:00 | 2013-12-20 00:00:00 | 2013-12-27 00:00:00
[NAME] | AMC | AMC1 | Movie 1
Filbey | AMC | AMC2 | Movie 2 | Client 1
Long | AMC | AMC3 | Movie 3 | Client 2
Filbey | AMC | AMC4 | Movie 4
Filbey | AMC | AMC5 | Movie 5 |  |  | Client 3
Shiller | AMC | AMC6 | Movie 6
Spreadsheet: faf5bcb9-aa5c-4a13-bad0-ab99abe1ef7d
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
HBL | Test | HBL | Chromosome Analysis, [NAME], Blood | Chromosomes, [NAME], Blood | Includes 2 banded karyograms, analysis of 20 or more metaphases, and other banding techniques when required. | Green-Top Tube (Sodium Heparin): GrnNaHp |  |  | 7 | mL | Provide a reason for referral with each specimen. The laboratory will not reject testing if this information is not provided, but appropriate testing and interpretation may be compromised or delayed.   Container/Tube: Green top (sodium heparin) [NAME]: 5-10 mL	 Collection Instructions:  1. Invert several times to mix blood.  2. Other anticoagulants are not recommended and are harmful to the viability of the cells.  Forms: If not ordering electronically, please submit the following forms with the specimen: -Hematopathology/Molecular Oncology Request Form (Supply T241) -Cytogenetics Hematologic Disorders Request Form (Supply T607) | 3 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | 46,XX or 46,XY. No apparent chromosome abnormality. An interpretative report will be provided. | Samples processed Monday through Sunday. Results reported Monday through Friday, 8 a.m.-5 p.m. CST. | 10 days | 11 days |  | Profile |  |  |  |  | Rochester
HBL | [NAME] | WBNAH | WB Sodium Heparin |  |  |  | Ambient
HBL | Order Question | G_540 | Reason For Referral |  | Plain Text
HBL | Result | 16059 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2
HBL | Result | 16328 | [NAME] | [NAME] | Alphanumeric
HBL | Result | 16783 | Source | Source | Alphanumeric
HBL | Result | 16060 | Order Date | Order Date | Alphanumeric
HBL | Result | G_540 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1
HBL | Result | 16064 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
HBL | Result | 50467 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62359-5
HBL | Result | 16066 | Results | Results | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29770-5
HBL | Result | 16067 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69965-2
HBL | Result | 16068 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
HBL | Result | 16069 | Consultant | Consultant | Alphanumeric
HBL | Result | 16070 | Report Date | Report Date | Alphanumeric
Spreadsheet: 785898d1656812668-search-table-for-each-type-of-service-and-concatenate-the-corresponding-notes-notes-concatenation
Sheet: 2022 H

Month | Semi-monthly | Start Date | Client | Service | Notes |  | Results Desired
 | 2HJun 2022 | 2022-06-23 00:00:00 | Client X | Blast |  |  | Client | Service | Concatenated Notes
 | 2HJun 2022 | 2022-06-30 00:00:00 | Client X | Blast |  |  | Client X | Board | Board meeting prep and reminder. 30 60 90. Board reminder #2
 | 2HJun 2022 | 2022-06-22 00:00:00 | Client X | Board | Board meeting prep and reminder |  | Client X | Grant | Emails. Review A's photos. Photos.
 | 2HJun 2022 | 2022-06-22 00:00:00 | Client X | Board | 30 60 90 |  | Client X | Marketing | Worked on adding P to sm accounts
 | 2HJun 2022 | 2022-06-28 00:00:00 | Client X | Board |  |  | Client X | Office [NAME] | Staff mtg. Cleaned up todos. Processed email, vmail & website comments.
 | 2HJun 2022 | 2022-06-28 00:00:00 | Client X | Board | Board reminder #2 |  | Client X | Programs | Budget & attendance report for K. Public Safety meeting coordination.
 | 2HJun 2022 | 2022-06-28 00:00:00 | Client X | Grant |  |  | Client Y | Data Entry | Created formulas
 | 2HJun 2022 | 2022-06-28 00:00:00 | Client X | Grant |  |  | Client Z | Office [NAME] | [NAME]
 | 2HJun 2022 | 2022-06-29 00:00:00 | Client X | Grant | Emails
 | 2HJun 2022 | 2022-06-29 00:00:00 | Client X | Grant | Review A's photos
 | 2HJun 2022 | 2022-06-29 00:00:00 | Client X | Grant | Photos
 | 2HJun 2022 | 2022-06-22 00:00:00 | Client X | Marketing | Worked on adding P to sm accounts
 | 2HJun 2022 | 2022-06-21 00:00:00 | Client X | Office [NAME] | Staff mtg
 | 2HJun 2022 | 2022-06-21 00:00:00 | Client X | Office [NAME]
 | 2HJun 2022 | 2022-06-22 00:00:00 | Client X | Office [NAME] | Cleaned up todos. Processed email, vmail & website comments.
 | 2HJun 2022 | 2022-06-22 00:00:00 | Client X | Programs | Budget & attendance report for K
 | 2HJun 2022 | 2022-06-22 00:00:00 | Client X | Programs
 | 2HJun 2022 | 2022-06-22 00:00:00 | Client X | Programs
 | 2HJun 2022 | 2022-06-29 00:00:00 | Client X | Programs | Public safety meeting coordination
 | 2HJun 2022 | 2022-06-13 00:00:00 | Client Y | Data Entry | Created formulas
 | 2HJun 2022 | 2022-06-13 00:00:00 | Client Y | Data Entry
 | 2HJun 2022 | 2022-06-18 00:00:00 | Client Z | Office [NAME] | [NAME]
Spreadsheet: 768849d1645164733-if-cell-contains-a-certain-letter-then-i-need-to-divide-my-formula-by-2-or-50-light-and-ventilation-calculator-example
Sheet: Sheet1

Room | Floor Area (Sqm) | Window / Door Type | Window / Door (H) | Window / Door (W) |  | Total Opening Area | Light 10% | Ventilation
 |  |  |  |  |  |  |  | Fans 12.5% | No Fans 15% | Bathroom 5%
Lounge | 55 | SW | 1.2 | 1.8
 |  | LW | 1.8 | 1.8
 |  | SD | 2.1 | 2.1
 |  | FD | 2.1 | 2.1
EXAMPLES
Spreadsheet: 866517d1713447074-conditional-formatting-to-highlights-duplicate-date-from-yesterdays-date-conditional-formatting
Sheet: Sheet1

 |  |  |  |  | Date | Number | Color
 |  |  |  |  | 2024-04-17 00:00:00 | 1 | Blue
 |  |  |  |  | 2024-04-17 00:00:00 | 2 | Yellow
 |  |  |  |  | 2024-04-17 00:00:00 | 3 | Red
 |  |  |  |  | 2024-04-17 00:00:00 | 4 | Violet
 |  |  |  |  | 2024-04-17 00:00:00 | 5 | Blue
 |  |  |  |  | 2024-04-17 00:00:00 | 6 | Yellow
 |  |  |  |  | 2024-04-17 00:00:00 | 7 | Red
 |  |  |  |  | 2024-04-17 00:00:00 | 8 | Violet
 |  |  |  |  | 2024-04-17 00:00:00 | 6 | Yellow
 |  |  |  |  | 2024-04-18 00:00:00 | 17 | Blue
 |  |  |  |  | 2024-04-19 00:00:00 | 17 | Blue
 |  |  |  |  | 2024-04-17 00:00:00 | 20 | Red
Spreadsheet: 349050d1412187556-using-drop-down-lists-to-retrieve-group-of-cells-forum-example-ndm
Sheet: Sheet1

Country1 | Country2 | Country3
City1 | City1 | City1
City2 | City2 | City2
City3 | City3 | City3
City4 | City4 | City4
City5 | City5 | City5
Country1City1 | Country1City2 | Country1City3 | Country1City4 | Country1City5 | Country2City1 | Country2City2 | Country2City3 | Country2City4 | Country2City5 | [NAME] | Country3City2 | Country3City3 | Country3City4 | Country3City5
3 | 3 | 5 | 1 | 6 | 12 | 95 | 1 | 6 | 21 | 5 | 98 | 9 | 8 | 6
4 | 6 | 2 | 2 | 6 | 36 | 35 | 23 | 23 | 36 | 55 | 2 | 2 | 88 | 15
8 | 3 | 99 | 8 | 2 | 48 | 15 | 9 | 48 | 8 | 10 | 15 | 15 | 94 | 3
1 | 44 | 1 | 9 | 33 | 55 | 87 | 48 | 9 | 14 | 15 | 1 | 1 | 15 | 5
9 | 7 | 9 | 4 | 65 | 9 | 22 | 15 | 10 | 8 | 6 | 8 | 3 | 75 | 7
Spreadsheet: 587564d1535096439-lowest-average-of-student-and-return-student-name-find-lowest-student
Sheet: Sheet1

ID | Subject | score
1000 | Math | 80
1001 | English | 45
1002 | Math | 60
1002 | English | 87 |  |  |  | This solution needs to be a formula that must be within one cell and needs to be dynamic(e.g changes).
1001 | English | 50
1000 | Chem | 54 |  |  |  | Q.
1001 | Math | 71 |  |  |  | Return the 2nd letter for the name of a student with the lowest average score?
1002 | Chem | 83
 |  |  |  |  |  | answer in C18, value should be o as [NAME] has the lowest average
ID | Name | Age
1000 | [NAME] | 14
1001 | [NAME] | 15
1002 | [NAME] | 16
 | Answer
Spreadsheet: 693255d1598885642-fomula-to-consolidate-month-total-grosstotal
Sheet: Store1

 |  |  |  |  |  |  | Gross
 |  |  |  |  |  | 2020-01-15 00:00:00 | 6561.25
 |  |  |  |  |  | 2020-01-31 00:00:00 | 6816.479999999999
 |  |  |  |  |  | 2020-02-15 00:00:00 | 6749.199999999999
 |  |  |  |  |  | 2020-02-29 00:00:00 | 6821.27
 |  |  |  |  |  | 2020-03-15 00:00:00 | 7119.15
 |  |  |  |  |  | 2020-03-31 00:00:00 | 6967.709999999999
 |  |  |  |  |  | 2020-04-15 00:00:00 | 5912.53
 |  |  |  |  |  | 2020-04-30 00:00:00 | 7938.83
 |  |  |  |  |  | 2020-05-15 00:00:00 | 7425.030000000002
 |  |  |  |  |  | 2020-05-31 00:00:00 | 9194.369999999999
 |  |  |  |  |  | 2020-06-07 00:00:00 | 4724.88
 |  |  |  |  |  | 2020-06-21 00:00:00 | 9088
 |  |  |  |  |  | 2020-07-05 00:00:00 | 9714.01
 |  |  |  |  |  | 2020-07-19 00:00:00 | 9346.6
 |  |  |  |  |  | 2020-08-02 00:00:00 | 8566.12
 |  |  |  |  |  | 2020-08-16 00:00:00 | 8959.66
 |  |  |  |  |  | 2020-08-30 00:00:00 | 7476.84