tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 62377d1263327263-excel-2007-graphing-switching-x-and-y-axis-book1
Sheet: Sheet1

Weight
 | Case 1 | Case 2 | Case 3
1.7 | 0.54 | 0.35 | 0.21 | 1.7
2.9 | 0.92 | 0.6 | 0.36 | 2.9
3.4 | 1.1 | 0.71 | 0.43 | 3.4
4.7 | 1.5 | 0.98 | 0.59 | 4.7
5.6 | 1.8 | 1.2 | 0.7 | 5.6
6.8 | 2.2 | 1.4 | 0.85 | 6.8
8.1 | 2.6 | 1.7 | 1 | 8.1
9.3 | 2.8 | 1.9 | 1.2 | 9.3
 |  | 0.21 | #N/A | #N/A | 1.7
 |  | 0.35 | #N/A | 1.7 | #N/A
 |  | 0.36 | #N/A | #N/A | 2.9
 |  | 0.43 | #N/A | #N/A | 3.4
 |  | 0.54 | 1.7 | #N/A | #N/A
 |  | 0.59 | #N/A | #N/A | 4.7
 |  | 0.6 | #N/A | 2.9 | #N/A
 |  | 0.7 | #N/A | #N/A | 5.6
 |  | 0.71 | #N/A | 3.4 | #N/A
 |  | 0.85 | #N/A | #N/A | 6.8
 |  | 0.92 | 2.9 | #N/A | #N/A
 |  | 0.98 | #N/A | 4.7 | #N/A
 |  | 1 | #N/A | #N/A | 8.1
 |  | 1.1 | 3.4 | #N/A | #N/A
 |  | 1.2 | #N/A | 5.6 | 9.3
 |  | 1.2 | #N/A | 5.6 | 9.3
 |  | 1.4 | #N/A | 6.8 | #N/A
 |  | 1.5 | 4.7 | #N/A | #N/A
 |  | 1.7 | #N/A | 8.1 | #N/A
 |  | 1.8 | 5.6 | #N/A | #N/A
 |  | 1.9 | #N/A | 9.3 | #N/A
 |  | 2.2 | 6.8 | #N/A | #N/A
 |  | 2.6 | 8.1 | #N/A | #N/A
 |  | 2.8 | 9.3 | #N/A | #N/A
Spreadsheet: d5f57222-7807-4cc7-9ece-e62111059436
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
FBUS | Test | FBUS | Buspirone ([NAME]) | Buspirone ([NAME]) | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) |  |  |  | 3 | mL | Submit only 1 of the following specimens:   Plasma Draw blood in a green-top (sodium heparin) tube(s), plasma gel tube is 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 serum buspirone concentrations in patients taking recommended daily dosages: up to 10.00 ng/mL.      Test performed by: Medtox Laboratories, Inc.                              402 W. County Road D                              St. Paul, MN 55112 | Monday through Sunday | 5 days | 7 - 9 days | 1 | 82542 |  |  |  |  | Medtox Laboratories, Inc.
FBUS | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 14 days
FBUS | Result | Z1186 | Buspirone | Buspirone | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 377323d1423895843-tricky-problem-trying-to-find-data-in-the-furthest-right-cell-excel-question
Sheet: Complex

Full Name | Assessment 1 | Effort 1 | Trackin 1 | Assessment 2 | Effort 2 | [NAME] | Assessment 3 | Effort 3 | Trackin 3 | Assessment 4 | Effort 4 | [NAME] | Assessment 5 | Effort 5 | Trackin 5 | Assessment 6 | Effort 6 | Trackin 6 | Most Recent Assessment |  |  |  |  |  |  | Full Name | Assessment 1 | Assessment 2 | Assessment 3 | Assessment 4 | Assessment 5 | Assessment 6 | Most Recent Assessment
Student 1 | 4c | 0 | Y | 5C | 0 | Y | 5b | 1 | Y |  |  |  |  |  |  |  |  |  |  | Using the same formula here doesn't work |  |  |  |  |  | Student 1 | 4c | 5b | 6c |  |  |  |  | Using "=LOOKUP(REPT("z",255),B2:G2))
Student 2 | 4b | 0 | Y | 5B | 1 | Y | 5B | 1 | Y |  |  |  |  |  |  |  |  |  |  | I only want the most recent Assessment result |  |  |  |  |  | Student 2 | 4b | 5B | 5B |  |  |  |  | This one [NAME] when there is no extra
Student 3 | 4a | 0 | Y | 5A | 1 | Y | 5A | 1 | Y |  |  |  |  |  |  |  |  |  |  | I.e. the ones in the 1st, 4th, 7th, columns |  |  |  |  |  | Student 3 | 4c | 5A | 5A |  | 6C |  |  | information in between
Student 4 | 5c | 1 | Y | 6B | 2 | Y | 6B | 2 | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Student 4 | 4b | 6B | 6B |  | 7B
Student 5 | 5c | 1 | Y | 6B | 2 | Y | 6B | 2 | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Student 5 | 4a | 6B | 6B
Student 6 | 4a | 1 | Y | 6B | 1 | Y | 6B | 1 | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Student 6 | 5c | 6B | 6B
Student 7 | 3c | 0 | Y | 5B | 2 | Y | 5B | 1 | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Student 7 | 4b | 5B | 5B | 6C
Student 8 | 5c | 1 | Y | 5C | 0 | N | 5C | 0 | N | 5a | 0 | Y |  |  |  |  |  |  |  |  |  |  |  |  |  | Student 8 | 5c | 5C | 5C
Student 9 | 6a | 1 | Y | 5A | 1 | Y | 5A | 0 | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Student 9 | 4a | 5A | 5A
Student 10 | 5c | 1 | Y | 5B | 1 | Y | 5B | 2 | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Student 10 | 4c | 5B | 5B
Spreadsheet: 713893d1610996009-cycle-through-dates-covid-assignments
Sheet: Sheet1

name | date | date | date | date | date | date | date | date | date | date | date | date | date | date | date | date | date | date | date | date | date | date | date | date | date | date | date | date | date | date
nurse 1 | variable "n" is typed then replace "n" to current date
nurse 2 | 2020-01-02 00:00:00 | 2020-06-02 00:00:00
nurse 3 | 2020-02-02 00:00:00
nurse 4
nurse 5 | 2020-01-05 00:00:00
nurse 6 | 2020-01-03 00:00:00
nurse 7 | 2020-02-03 00:00:00
nurse 8 | 2020-01-12 00:00:00 | 2020-03-05 00:00:00
nurse 9 | 2020-06-05 00:00:00
nurse 10 | 2020-06-07 00:00:00
nurse 11 | 2020-04-02 00:00:00
nurse 12 | 2020-03-06 00:00:00 | 2020-06-02 00:00:00
nurse 13 | 2020-09-05 00:00:00
nurse 14 | 2020-05-09 00:00:00
nurse 15 | 2020-07-12 00:00:00
nurse 16 | 2020-03-15 00:00:00
 | 2020-06-20 00:00:00
 | Command line
 | =if(b3="n",b3,"true") // so if b3 is ="n" then replace with today() date then if no then leave blank, B16
 | loop if statement =if b3 to b18 find blank date such as nurse 4 , then will check if a name is present, if present then display name on b26 , if name is blank but with date example b19 then skip if example nurse4 does have a date then will go to the next column c3 to c18 and so on.
 | I am hoping this can work with excel and not require vb. thank you all
 | nurse4 _____is next to take care of covid patient
Spreadsheet: 713917d1611004848-rehearsal-plan-example
Sheet: Tabelle1

student | student 1 | student 2 | student 3 | student 4 | student 5 | student 6 | student 7 | student 8
scene
scene 1 | x | x
scene 2 | x |  | x |  |  |  |  | x
scene 3 |  | x | x
scene 4 |  |  | x | x
scene 5 | x |  |  |  |  |  |  | x
scene 6 | x |  | x | x
scene 7 | x | x | x |  |  |  |  | x
scene 8 | x | x |  |  | x |  | x
scene 9 |  |  | x | x | x |  |  | x
[NAME] 10 |  | x |  |  | x
scene 11 |  |  |  | x |  | x
scene 12 |  | x |  | x
scene 13 | x |  |  | x
scene 14 | x |  |  |  | x
scene 15 |  |  | x |  |  | x
scene 16 | x |  | x | x
Spreadsheet: 95d36f74-6531-4bf7-917c-df3ee84e0cf7
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
ACHE_ | Test | ACHE_ | Acetylcholinesterase, [NAME] (AChE-AF), [NAME] | Acetylcholinesterase, AF | Polyacrylamide Electrophoresis | [NAME], leak proof vial: ScwLkPf |  |  | 1 | mL | Container/Tube: Amniotic fluid container [NAME]: 1 mL Collection Instructions:  1. A specimen from the 14 to 18 week gestational period of pregnancy is preferred. Amniotic fluid from the 14 to 21 week gestational period is acceptable. 2. Do not centrifuge.  Additional Information:  1. Gestational age at amniocentesis is required. 2. If chromosome studies are also requested, see AF/8426 Chromosome Analysis, [NAME]. The specimen for acetylcholinesterase testing, when requested with chromosome analysis, cannot be frozen. Forms:  1. Second Trimester Maternal Screening Alpha-Fetoprotein (AFP)/QUAD Screen Patient Information Sheet (Supply T595) is required; see Special Instructions.  2. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 3. If not ordering electronically, please submit the following forms with the specimen: -Cytogenetics/AFP Congenital Disorders Request Form (Supply T238) -Biochemical Genetics Request Form (Supply T439) | 0.3 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	NA Icterus	Mild OK; [NAME] OK Other	NA | Negative (reported as negative [normal] or positive [abnormal] for inhibitable acetylcholinesterase) Reference values were established in conjunction with alpha-fetoprotein testing and include only amniotic fluids from pregnancies between 14 and 21 weeks gestation. | Tuesday, Thursday; 8 a.m. (not reported on Saturday and Sunday) | 4 days | 8 days | 1 | 82013 |  |  |  |  | Rochester
ACHE_ | [NAME] | AMNIOTIC | Amniotic Fld |  |  |  | Refrigerated | 365 days
ACHE_ | Order Question | GACHE | Gestational Age (ACHE) |  | Plain Text
ACHE_ | Result | 9287 | Acetylcholinesterase, AF | Acetylcholinesterase, AF | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30106-9 | [NAME]:ACnc:Pt:Amnio fld:[NAME]:
ACHE_ | Result | GACHE | Gestational Age (ACHE) | Gestational Age (ACHE) | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18185-9 | Gestational age:Time:Pt:^Fetus:Qn:
Spreadsheet: 714408d1611220803-sort-out-the-trades-in-sequence-test50
Sheet: Sheet1

Date | Price | Trade Running | Trade Signal
2012-10-01 00:00:00 | 10 | 0
2012-10-02 00:00:00 | 12 | 0
2012-10-03 00:00:00 | 9 | 0
2012-10-04 00:00:00 | 12 | 0
2012-10-05 00:00:00 |  | 0
2012-10-08 00:00:00 |  | 0
2012-10-09 00:00:00 |  | 1 | Buy
2012-10-10 00:00:00 |  | 1
2012-10-11 00:00:00 |  | 1
2012-10-12 00:00:00 |  | 1
2012-10-15 00:00:00 |  | 1
2012-10-16 00:00:00 |  | 0 | Sell
2012-10-17 00:00:00 |  | 0
2012-10-18 00:00:00 |  | 0
2012-10-19 00:00:00 |  | 0
2012-10-22 00:00:00 |  | 1 | Buy
2012-10-23 00:00:00 | 23 | 0 | Sell
2012-10-24 00:00:00 |  | 0
2012-10-25 00:00:00 |  | 0
2012-10-30 00:00:00 |  | 0
2012-10-31 00:00:00 |  | 1 | Buy
2012-11-01 00:00:00 |  | 1
2012-11-02 00:00:00 |  | 1
2012-11-05 00:00:00 |  | 1
2012-11-06 00:00:00 |  | 1
2012-11-07 00:00:00 |  | 1
2012-11-08 00:00:00 |  | 0 | Sell
Spreadsheet: 49281d1248572138-count-if-2-criteria-met-formula-rollbook-2009
Sheet: Jul 09

Room 1 ROLLBOOK
Designation | NAME | INITIALS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOTES
 |  |  |  |  |  |  |  | MONTH |  |  |  |  | JULY |  |  |  |  |  |  |  | YEAR |  |  | 2009
 |  |  | 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
Staff | White | P | L | L | L
Staff | Adams | A | P | P | P
Staff | Bells | U | S | S | S
Senior | Carmine | M | L | L | L
Senior | [NAME] | F | P | P | P
Senior | French | E | S | S | S
Junior | Gates | F | L | L | L
Junior | Hill | M | P | P | P
Junior | English | W | S | S | S
Number on Parade |  |  | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Signature of Roll Marker
Signature of Roll Keeper
Room 2 ROLLBOOK
Designation | NAME | INITIALS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOTES
 |  |  |  |  |  |  |  | MONTH |  |  |  |  | JULY |  |  |  |  |  |  |  | YEAR |  |  | 2009
 |  |  | 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
Staff | Jones | P | L | L | L
Staff | [NAME] | A | P | P | P
Staff | Smith | U | S | S | S
Senior | Yates | M | L | L | L
Senior | Bond | F | P | P | P
Senior | Doe | E | S | S | S
Junior | [NAME] | F | L | L | L
Junior | [NAME] | M | P | P | P
Junior | Wilson | W | S | S | S
Number Present |  |  | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Signature of Roll Marker
Signature of Roll Keeper
Staff | Present |  | If column A = Staff, count if column D = P
 | Leave |  | If column A = Staff, count if column D = L
 | Sick |  | If column A = Staff, count if column D = S
Senior | Present |  | If column A = Senior, count if column D = P
 | Leave |  | If column A = Senior, count if column D = L
 | Sick |  | If column A = Senior, count if column D = S
Junior | Present |  | If column A = Junior, count if column D = P
 | Leave |  | If column A = Junior, count if column D = L
 | Sick |  | If column A = Junior, count if column D = S
Spreadsheet: 839304d1691810597-excel-formula-to-calculate-stock-transaction-sample
Sheet: Ref

Stock Category | Transaction Category | REIT Category | Price [NAME] | USD to SGD
Dividend | Buy | Hospitality | 0.02 | 1.3521
Growth | Sell | Industrial
Special Situation | Div | Healthcare
Value | Split | Apartment
Watch | Fee | Commercial
 |  | Retail
Spreadsheet: 490999d1480248381-creating-a-pivot-table-participants-by-month-when-i-only-have-the-start-and-end-dates-help_needed_example-prc
Sheet: Sheet1

ID | Course start date | Start | Course end date | Finish | Days | Course outcome
17 | 2012-06-27 00:00:00 |  | 2013-01-17 00:00:00 |  |  | started but didn't finish
18 | 2012-07-15 00:00:00 |  | 2013-01-17 00:00:00 |  |  | finished
8 | 2012-08-21 00:00:00 |  | 2012-10-03 00:00:00 |  |  | finished
9 | 2012-08-26 00:00:00 |  | 2012-10-03 00:00:00 |  |  | finished
1 | 2012-08-28 00:00:00 |  | 2012-10-02 00:00:00 |  |  | refused
2 | 2012-09-04 00:00:00 |  | 2012-10-02 00:00:00 |  |  | finished
10 | 2012-09-04 00:00:00 |  | 2012-10-03 00:00:00 |  |  | started but didn't finish
11 | 2012-09-04 00:00:00 |  | 2012-10-03 00:00:00 |  |  | finished
12 | 2012-09-09 00:00:00 |  | 2012-10-03 00:00:00 |  |  | finished
13 | 2012-09-09 00:00:00 |  | 2012-10-03 00:00:00 |  |  | started but didn't finish
3 | 2012-09-30 00:00:00 |  | 2012-10-02 00:00:00 |  |  | finished
19 | 2012-09-30 00:00:00 |  | 2013-01-17 00:00:00 |  |  | started but didn't finish
4 | 2012-10-02 00:00:00 |  | 2012-10-02 00:00:00 |  |  | refused
5 | 2012-10-02 00:00:00 |  | 2012-10-02 00:00:00 |  |  | finished |  |  | `
6 | 2012-10-02 00:00:00 |  | 2012-10-02 00:00:00 |  |  | finished
7 | 2012-10-02 00:00:00 |  | 2012-10-02 00:00:00 |  |  | started but didn't finish
14 | 2013-01-13 00:00:00 |  | 2013-01-16 00:00:00 |  |  | refused
15 | 2013-01-13 00:00:00 |  | 2013-01-16 00:00:00 |  |  | refused
16 | 2013-01-13 00:00:00 |  | 2013-01-16 00:00:00 |  |  | finished
Spreadsheet: darrell_schoolcraft__7827__imbalsumm0110
Sheet: NS Steel

 | North Star Steel
 | POI 500383 - North Start Steel IC
Day | Measured | Scheduled
1 |  | -2139
2 |  | -2139
3 |  | -2139
4 |  | -2139
5 |  | -2139
6 |  | -2139
7
8 |  |  |  |  |  |  |  |  |  |  | Avg
9 |  |  |  |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
10
11 |  |  |  |  |  |  | 2001-01-01 00:00:00 | -50582 | -68700 |  | 8.21
12 |  |  |  |  |  |  | 2001-02-01 00:00:00 | -54068 | -70278 |  | 5.62
13 |  |  |  |  |  |  | 2001-03-01 00:00:00 | -58719 | -82564 |  | 4.98
14 |  |  |  |  |  |  | 2001-04-01 00:00:00 | -52309 | -39370 |  | 4.87
15 |  |  |  |  |  |  | 2001-05-01 00:00:00 | -57841 | -49325 |  | 3.82
16 |  |  |  |  |  |  | 2001-06-01 00:00:00 | -50325 | -65214 |  | 3.2
17 |  |  |  |  |  |  | 2001-07-01 00:00:00 | -43678 | -59252 |  | 2.77
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-09-30 00:00:00 |  |  | -448576
2001-10-06 00:00:00
CBS Volume
 |  |  | -92166
Spreadsheet: 845864d1697191100-pulling-specific-customer-data-froma-lookup-sheet-into-another-sheet-how-to-excel-book
Sheet: DATA SHEET

 | 1
 | Security  Code | Maturity Date | Customer Name | CCY | Issue Date | Face Value of Investment | Tenor | Profit | TOTAL PROFIT | CUSTOMER A/C # | No. of | PROFIT JUN 23 | Profit | No. of | PROFIT JUL 23 | Profit | No. of | PROFIT AUG 23 | Profit | No. of | PROFIT Sep 23 | Profit | No. of | PROFIT Oct 23
 |  |  |  |  |  |  |  |  |  |  |  | 2023-06-01 00:00:00 |  |  | 2023-07-01 00:00:00 |  |  | 2023-08-01 00:00:00 |  |  | 2023-09-01 00:00:00 |  |  | 2023-10-01 00:00:00
 |  |  |  |  |  |  |  | Rate % |  |  | Days | 2023-06-30 00:00:00 | Rate % | Days | 2023-07-31 00:00:00 | Rate % | Days | 2023-08-31 00:00:00 | Rate % | Days | 2023-09-30 00:00:00 | Rate % | Days | 2023-10-31 00:00:00
 |  |  |  |  |  |  |  | 2023-06-01 00:00:00 | TO DATE |  | 2023-06-01 00:00:00 |  | 2023-07-01 00:00:00 | 2023-07-01 00:00:00 |  | 2023-08-01 00:00:00 | 2023-08-01 00:00:00 |  | 2023-09-01 00:00:00 | 2023-09-01 00:00:00 | 30 | 2023-10-01 00:00:00 | 2023-10-01 00:00:00 | 31
 | 371200-865 | 2023-10-06 00:00:00 | [NAME] | USD | 2022-10-06 00:00:00 | 5000 | 1-Year | 0.0651 |  | 3901413000004587 | 0 |  | 0.0651 | 0 |  | 0.0649 | 0 |  | 0.065 | 0 |  | 0.065 | 31
 | 371200-857 | 2023-10-25 00:00:00 | [NAME] | USD | 2023-07-25 00:00:00 | 300000 | 3-Months | 0.1051 |  | 3902413000000140 | 0 |  | 0.1051 | 7 |  | 0.1051 | 31 |  | 0.155 | 31 |  | 0.155 | 24
 | 371200-857 | 2024-02-16 00:00:00 | [NAME] | USD | 2023-08-16 00:00:00 | 5000 | 6-Months | 0.0651 |  | 3903415000009094 | 0 |  | 0.0651 | 0 |  | 0.0649 | 16 |  | 0.065 | 31 |  | 0.065 | 31
 | 372200-767 | 2026-02-11 00:00:00 | [NAME] | USD | 2023-02-11 00:00:00 | 9000 | 3-Year | 0.0651 |  | 3903415000001799 | 30 |  | 0.0651 | 31 |  | 0.0649 | 31 |  | 0.065 | 31 |  | 0.065 | 31
 | 373100-582 | 2028-01-06 00:00:00 | Natasha | USD | 2023-01-06 00:00:00 | 5000 | 5-Year | 0.0651 |  | 3098413000003823 | 30 |  | 0.0651 | 31 |  | 0.0649 | 31 |  | 0.065 | 31 |  | 0.065 | 31
 |  | Before going any further I recommend you move columns W:X BEFORE column H if you want to add further monthly profit details after column V:
 |  | otherwise you will need constantly change the range of any formula required to do the column W calculation.
 |  | For Customer "lookup", you need to use Data Validation based on a dynamic named range[list ]of your customers. You can then use VLOOKUP/INDEX match (or similar) to retrieve the required data.
 |  | If that takes care of your original question, please select [NAME] from the menu link above and mark this thread as SOLVED.
Spreadsheet: 161079d1339407311-macro-to-update-database-without-overwriting-existing-data-book1
Sheet: Sheet2

match cell for criteria cell in sheet 1 | current data 1 | current data 2 | current data 3
a | ("hello" is inserted here if this cell is originally empty) | ("how" is inserted here if this cell is originally empty) | ("are you" is inserted here if this cell is originally empty)
 | ("hello" is inserted here if the cell above is filled) | ("how" is inserted here if the above cell is filled) | ("are you" is inserted here if the above cell is filled)
 | ("hello" is inserted here if the cell above is filled) | ("how" is inserted here if the above cell is filled) | ("are you" is inserted here if the above cell is filled)
 | … | … | …
b | aaa | bbb | aaa
c | bbb | aaa | bbb
Spreadsheet: 171347d1343690644-automatic-setting-of-check-boxes-based-on-other-check-boxes-newpricing-unmarked
Sheet: FooBar

 | Pricing Worksheet |  |  |  |  |  | Mailbox Count: | 200
1 |  | Base Product |  |  |  |  | Installation: | 950
 |  |  |  |  |  |  | Annual Support: | 400
 | Upgrades |  | First | Next | Next | Next
 |  |  | 250 Mailboxes | 250 Mailboxes | 500 Mailboxes | 1500 Mailboxes | [NAME] | License Cost
0 |  | Option 1 | 9 | 7 | 5 | 4 | 2 | 0
0 |  | Option 2 | 11 | 9 | 7 | 4 | 2 | 0
0 |  | Option 3 | 11 | 9 | 5 | 3 | 1.5 | 0
0 |  | Option 4 | 8 | 6 | 4 | 3 | 1.5 | 0
0 |  | Option 5 | 6 | 5 | 4 | 3 | 1.5 | 0
0 |  | Option 6 | 6 | 5 | 4 | 3 | 1.5 | 0
 |  | units | 200 | 0 | 0 | 0 | 0
0 |  |  |  |  |  | All Options Discount: |  | 0
 |  |  |  |  |  | Total Options License: |  | 0
 |  |  |  |  |  | Annual Option Support: |  | 0
 |  |  |  |  |  |  | Option Installation and Configuration: | 0
 |  |  |  |  |  |  | Total License Price: | 0
 |  |  |  |  |  |  | Total Support Price: | 400
 |  |  |  |  |  |  | Total Installation: | 950
 |  |  |  |  |  |  | Grand Total: | 1350
 | Pricing
0 |  | OnDemand Pricing |  |  |  |  | 30 day License: | 0
Spreadsheet: jeffrey_a_shankman__13796__DEAL BREAKDOWN ANALYSIS 10-18-00 EM
Sheet: PHYSICAL

ENRON North American Gas - EOL vs NON-EOL Analysis
PHYSICAL
LTD
REGION |  |  |  | % OF TOTAL DEAL COUNT |  | % OF TOTAL VOLUME |  | % OF TOTAL NOTIONAL VALUE
 | TOTAL
 | TOTAL
 | TOTAL
 | TOTAL
G-DAILY-EST | EOL
 | NON-EOL
 | TOTAL
 | TOTAL
 | TOTAL
 | TOTAL
TOTAL | EOL
 | NON-EOL
 | TOTAL
Spreadsheet: kate_symes__18111__Deal Correction 1-11
Sheet: Prior Day

Adjustment date | Date of applied calc | Deal Date | Desk | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
2001-01-08 00:00:00 | 2001-01-09 00:00:00 | 2001-01-08 00:00:00 | STNW | DS | Houston | Prebon | Broker: from APB to Prebon |  | 491593 | Mid-C | 2001-01-09 00:00:00 | On peak | 25 | 160 | Morgan
 |  |  | DS Count
2001-01-09 00:00:00 | 2001-01-09 00:00:00 | 2001-01-09 00:00:00 | STCA | CM | Houston | APB | Broker: from none to APB |  | 492562 | NP-15 | 2001-01-10 00:00:00 | On peak | 25 | 175 | SMUD
 |  |  | CM Count
2001-01-09 00:00:00 | 2001-01-09 00:00:00 | 2001-01-08 00:00:00 | STNW | SC | Houston | N/A | Deleted strip that duplicated Deal #491916 |  | 491893 | Tacoma System Border | BOM | Off peak | 5 | 200 | City of Tacoma
 |  |  | SC Count
2001-01-09 00:00:00 | 2001-01-09 00:00:00 | 2001-01-09 00:00:00 | LTCA | BB | Houston | Natsource | Price: from 160.05 to 225.05 |  | 492699 | Palo Verde | M-01 | On peak | 25 | 225.05 | EES
 |  |  | BB Count
 |  |  | Grand Count
Spreadsheet: 819823d1677703082-vlookup-variable-sample_vlookup
Sheet: Log

Name | Type
Apple
Apple, Fuji
Gala Apple
Apple, Golden Delicious
[NAME]
[NAME]
Cavendish Banana
The Red Banana
[NAME]
[NAME]
[NAME]
Cabbage
Savoy cabbage
Cabbage, Red
broad beans
Beans, garbanzo OR Chickpea
green beans
kidney beans
Spreadsheet: 740668d1626445399-sum-of-values-in-a-column-between-2-dates-as-shown-in-required-data-required
Sheet: Sheet2

 | From Date | 2021-07-01 00:00:00 |  | To Date | 2021-07-14 00:00:00 |  |  |  | 2021-07-01 00:00:00
 |  |  |  |  |  |  |  |  | 2021-07-02 00:00:00
 |  |  |  |  |  |  |  |  | 2021-07-10 00:00:00
 | Total Revenue |  |  |  |  | I want Total Revenue, Total Cost between date selected in "From Date" to "To date" from "Sheet1" |  |  | 2021-07-03 00:00:00
 | Total Cost |  |  |  |  |  |  |  | 2021-07-09 00:00:00
 | Total Margin |  |  |  |  |  |  |  | 2021-07-04 00:00:00
 |  |  |  |  |  |  |  |  | 2021-07-05 00:00:00
 |  |  |  |  |  |  |  |  | 2021-07-06 00:00:00
 | Result Required |  |  |  |  |  |  |  | 2021-07-07 00:00:00
 | Total Revenue | 14134480 |  |  |  |  |  |  | 2021-07-08 00:00:00
 | Total Cost | 14367512 |  |  |  |  |  |  | 2021-07-11 00:00:00
 | Total Margin | 1029066 |  |  |  |  |  |  | 2021-07-12 00:00:00
 |  |  |  |  |  |  |  |  | 2021-07-13 00:00:00
 |  |  |  |  |  |  |  |  | 2021-07-14 00:00:00
 |  |  |  |  |  |  |  |  | 2021-07-15 00:00:00
 |  |  |  |  |  |  |  |  | 2021-06-27 00:00:00
 |  |  |  |  |  |  |  |  | 2021-06-28 00:00:00
 |  |  |  |  |  |  |  |  | 2021-06-29 00:00:00
 |  |  |  |  |  |  |  |  | 2021-06-30 00:00:00