tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 731915d1620672906-formatting-large-numbers-to-3-figures-example2370
Sheet: Sheet1

 |  |  |  | £0.00,"ᴷ" | £0.0,"ᴷ" | £0,"ᴷ" | £[NAME]" | £0.0,,"ᴹ" | £0,,"ᴹ" | £0.00,,,"ᴮ" | £0.0,,,"ᴮ" | £0,,,"ᴮ" | £0.00,,,,"ᵗ" | £0.0,,,,"ᵗ" | £0,,,,"ᵗ" |  | [<9995]£0.00,"ᴷ"; [<99950]£0.0,"ᴷ"; £0,"ᴷ"
 | BMV
1234
12345
123456
1234567
12345678
123456789
1234567890
12345678901
123456789012
1234567890123
12345678901234
123456789012345
9994
9995
99949
99950
999499
999500
Spreadsheet: 823298d1679884911-formula-countif-with-multiple-criteria-occurence-by-criteria-name-vs-number
Sheet: Sample

 |  |  |  |  |  |  |  | Result should be
AA No | Step | Designation | Name | PFNo | BeginDate | EndDate | Occurrence | Occurrence with number per column "A" & "Column D"
LOC1/64230/2023/4906 | STPEA5 | Regional Retail Approving Manager | [NAME] | 980080 | 2023-03-02 15:36:24 | 2023-03-03 15:36:25 |  | 1st AA
LO10/60036/2023/2215 | STPEA5 | Regional Retail Approving Manager | [NAME] | 15651 | 2023-03-06 12:14:06 | 2023-03-06 19:50:48 |  | 1st AA
LOC1/64342/2023/5667 | STPEA5 | Regional Retail Approving Manager | [NAME] | 15698 | 2023-03-09 15:37:31 | 2023-03-09 16:30:09 |  | 1st AA
LO10/60036/2023/2215 | STPEA5 | Regional Retail Approving Manager | [NAME] | 980193 | 2023-03-09 12:18:01 | 2023-03-09 19:33:16 |  | 1st AA
LO10/60036/2023/2215 | STPEA5 | Regional Retail Approving Manager | [NAME] | 980193 | 2023-03-10 15:19:52 | 2023-03-12 13:08:32 |  | 2nd AA
LOC1/64342/2023/5667 | STPEA5 | Regional Retail Approving Manager | [NAME] | 15698 | 2023-03-15 10:46:31 | 2023-03-15 10:48:17 |  | 2nd AA
LOC1/64230/2023/4906 | STPEA5 | Regional Retail Approving Manager | [NAME] | 980080 | 2023-03-16 16:18:36 | 2023-03-16 16:44:10 |  | 2nd AA
LOC1/64342/2023/5667 | STPEA5 | Regional Retail Approving Manager | [NAME] | 15698 | 2023-03-15 18:50:09 | 2023-03-16 19:42:16 |  | 3rd AA
LOC1/64230/2023/4906 | STPEA5 | Regional Retail Approving Manager | [NAME] | 980080 | 2023-03-16 18:27:15 | 2023-03-19 16:53:23 |  | 3rd AA
LOC1/64342/2023/5667 | STPEA5 | Regional Retail Approving Manager | Thurga Thevi A/P Palanisamy | 80881 | 2023-03-20 09:59:19 | 2023-03-20 10:09:01 |  | 1st AA
LOC1/64230/2023/4906 | STPEA5 | Regional Retail Approving Manager | [NAME] | 95064 | 2023-03-20 15:05:46 | 2023-03-20 15:49:54 |  | 1st AA
LOC1/64342/2023/5667 | STPEA5 | Regional Retail Approving Manager | Thurga Thevi A/P Palanisamy | 80881 | 2023-03-20 19:01:41 | 2023-03-21 07:24:33 |  | 5th AA
LOC1/64230/2023/4906 | STPEA5 | Regional Retail Approving Manager | [NAME] | 95064 | 2023-03-21 08:00:55 | 2023-03-21 08:33:42 |  | 2nd AA
LOC1/64230/2023/4906 | STPEA5 | Regional Retail Approving Manager | [NAME] | 95064 | 2023-03-21 15:48:53 | 2023-03-21 16:35:38 |  | 3rd AA
LOC1/64342/2023/5667 | STPEA5 | Regional Retail Approving Manager | Thurga Thevi A/P Palanisamy | 80881 | 2023-03-21 18:19:37 | 2023-03-21 19:30:33 |  | 6th AA
Spreadsheet: 67224d1267805912-formula-to-handle-more-than-seven-possible-errors-doc-count-test
Sheet: Sheet1

 | Loan Number | Note | Deed of Trust/Mortgage | Loan Agreement | Guaranty | Appraisal | Borrower Approval | Critical Action Report | Criticized Asset Report | File Maintenance Loan Data Sheets | Loan Committee Approval | Loan Review | Loan Review - Annual | Loan Review - Quarterly | SAC Reports | Special Assets Committee Report
 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | 0 | #N/A | 0 | 0 | 0 | #N/A | 0 | #N/A
 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | 0 | #N/A | 0 | 0 | 0 | #N/A | 0 | #N/A
 | 4 | 0 | 0 | 0 | 0 | 1 | 0 | #N/A | 0 | #N/A | 8 | 0 | 0 | #N/A | 0 | #N/A
 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | 0 | #N/A | 0 | 0 | 0 | #N/A | 0 | #N/A
 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | 0 | #N/A | 1 | 0 | 0 | #N/A | 0 | #N/A
 | 7 | 0 | 0 | 0 | 0 | 1 | 5 | #N/A | 0 | #N/A | 2 | 0 | 0 | #N/A | 0 | #N/A
 | 8 | 11 | 6 | 0 | 2 | 15 | 0 | #N/A | 0 | #N/A | 15 | 3 | 0 | #N/A | 0 | #N/A
 | 9 | 0 | 0 | 0 | 0 | 1 | 0 | #N/A | 0 | #N/A | 2 | 2 | 0 | #N/A | 0 | #N/A
 | 10 | 1 | 0 | 0 | 2 | 3 | 0 | #N/A | 1 | #N/A | 6 | 0 | 0 | #N/A | 0 | #N/A
 | 11 | 0 | 0 | 0 | 0 | 4 | 0 | #N/A | 0 | #N/A | 1 | 3 | 0 | #N/A | 0 | #N/A
 | 12 | 0 | 0 | 0 | 0 | 4 | 0 | #N/A | 0 | #N/A | 7 | 0 | 0 | #N/A | 0 | #N/A
 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | 0 | #N/A | 13 | 0 | 0 | #N/A | 0 | #N/A
 | 14 | 0 | 0 | 0 | 0 | 3 | 2 | #N/A | 0 | #N/A | 4 | 1 | 0 | #N/A | 0 | #N/A
 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | 0 | #N/A | 2 | 0 | 0 | #N/A | 0 | #N/A
 | 16 | 0 | 0 | 0 | 0 | 1 | 0 | #N/A | 0 | #N/A | 6 | 3 | 0 | #N/A | 0 | #N/A
 | 17 | 0 | 0 | 0 | 0 | 2 | 0 | #N/A | 0 | #N/A | 0 | 0 | 0 | #N/A | 0 | #N/A
 | 18 | 5 | 1 | 1 | 3 | 5 | 0 | #N/A | 0 | #N/A | 10 | 0 | 0 | #N/A | 0 | #N/A
 | 19 | 2 | 1 | 0 | 2 | 2 | 0 | #N/A | 0 | #N/A | 3 | 0 | 0 | #N/A | 0 | #N/A
 | 20 | 3 | 3 | 1 | 4 | 6 | 0 | #N/A | 0 | #N/A | 4 | 3 | 0 | #N/A | 0 | #N/A
 | 21 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | 0 | #N/A | 0 | 0 | 0 | #N/A | 0 | #N/A
 | 22 | 0 | 1 | 0 | 0 | 2 | 0 | #N/A | 0 | #N/A | 11 | 0 | 0 | #N/A | 0 | #N/A
Spreadsheet: 821913d1678984611-count-cells-with-multiple-entries-test3
Sheet: Sheet1

 | Current
 | 01-Jan | 02-Jan | 03-Jan |  | UK | US
 | UK | UK/US | US
 | Required |  |  |  |  |  | Helper
 | 01-Jan | 02-Jan | 03-Jan |  | UK | US | UK/US
 | UK | UK/US | US
Spreadsheet: 818c1411-2661-41f4-8901-6f4a4c66eba9
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
AFBIL | Test | AFBIL | Bilirubin, Amniotic Fluid | [NAME], AF | Spectrophotometric Scan | Plastic vial: PlV |  |  | 3.5 | mL | Collection Container/Tube: Amniotic fluid container Submission Container/Tube: Opaque, amber vial (Supply T192) [NAME]: 3.5 mL Collection Instructions:  1. Centrifuge, separate supernatant, and send both supernatant and sediment in separate opaque, amber vials to protect from light. 2. Label specimens as sediment and supernatant. Additional Information: Gestational age at time of amniocentesis is required. | 1.7 mL | Hemolysis	NA Thawing	Warm reject; Cold OK Note in order comments Lipemia	NA Icterus	Mild OK; [NAME] OK Other	NA | Interpretation of fetal risk is dependent upon gestational age. [NAME] to either the Queenan Curve (gestational age <27 weeks) or the Liley Chart (gestational age >27 weeks) listed under Delta OD of Bilirubin in Amniotic Fluid in Special Instructions. | Monday through Saturday; Continuously | Same day | 1 day | 1 | 82247 |  |  |  |  | Rochester
AFBIL | [NAME] | AMNIOTIC | Amniotic Fld |  |  |  | Frozen | 70 days
AFBIL | Order Question | GSTN | Gestation |  | Plain Text
AFBIL | Result | AMBL | Amniotic Fluid | Amniotic Fluid | Numeric |  |  |  |  | delta OD |  |  |  |  |  |  |  |  |  | 12476-8
AFBIL | Result | AFCMT | Other Information | Other Information | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
AFBIL | Result | GSTN | Gestation | Gestation | Alphanumeric |  |  |  |  | wk |  |  |  |  |  |  |  |  |  | 18185-9
Spreadsheet: 296281d1392044037-copy-data-from-one-cell-to-another-cell-in-different-worksheet-depends-on-dates-and-names-template
Sheet: Dates

 |  | Summary |  |  | Drops
 |  | Total days |  |  | [NAME] | Component | Including | [NAME] | QA Start Date | QA Due Date | Days | Assigned To | Comments
 |  |  |  |  | 1 | component 1 |  | 2014-01-18 00:00:00 | 2014-01-19 00:00:00 | 2014-01-19 00:00:00 |  | Lior
 |  | Holidays |  |  | 1 | component 2 |  | 2014-01-18 00:00:00 | 2014-01-20 00:00:00 | 2014-01-21 00:00:00 |  | Lior
 |  | Eve of Passover A | 2014-04-14 00:00:00
 |  | Passover A | 2014-04-15 00:00:00 |  | 2 | component 3 |  | 2014-01-19 00:00:00 | 2014-01-20 00:00:00 | 2014-01-21 00:00:00 |  | Avi
 |  | Eve of Passover B | 2014-04-20 00:00:00 |  | 2 | component 4 |  | 2014-01-19 00:00:00 | 2014-01-22 00:00:00 | 2014-01-23 00:00:00 |  | Lior, Avi
 |  | Passover B | 2014-04-21 00:00:00
 |  | Eve of independence day | 2014-05-05 00:00:00 |  | 3
 |  | Independence day | 2014-05-06 00:00:00 |  | 3
 |  | Eve of shavout | 2014-06-03 00:00:00 |  | 3
 |  | Shavout | 2014-06-04 00:00:00 |  | 3
 |  | Eve of new year | 2014-09-24 00:00:00 |  | 3
 |  | New year | 2014-09-25 00:00:00 |  | 3
 |  | New year | 2014-09-26 00:00:00
 |  | Eve of yom kippur | 2014-10-03 00:00:00 |  | 3.5
 |  | [NAME] | 2014-10-04 00:00:00 |  | 3.5
 |  | Eve of sokkut A | 2014-10-08 00:00:00 |  | 3.5
 |  | Sokkut A | 2014-10-09 00:00:00 |  | 3.5
 |  | Eve of sokkut B | 2014-10-15 00:00:00 |  | 3.5
 |  | Sokkut B | 2014-10-16 00:00:00 |  | 3.5
 |  |  |  |  | 3.5
 |  | Test environments |  |  | 3.5
 |  |  |  |  | 3.5
 |  |  |  |  | 3.5
 |  |  |  |  | 4
 |  |  |  |  | 4
 |  |  |  |  | 4
 |  |  |  |  | 4
 |  |  |  |  | 4
 |  |  |  |  | 4
 |  |  |  |  | 5
 |  |  |  |  | 5
 |  |  |  |  | 6
 |  |  |  |  | 6
 |  |  |  |  | 6
Spreadsheet: f5fb917e-719f-4442-aa8b-4702dc1c264d
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
LYZKM | Test | LYZKM | Lysozyme (LYZ) Gene, Known Mutation | [NAME], Known Mutation | Polymerase Chain Reaction (PCR) Followed by DNA Sequence Analysis (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | VACUTAINER: VAC |  |  | 3 | mL | This test can only be performed if a mutation has previously been identified in a family member of this individual.   [NAME] must arrive within 96 hours of draw.   [NAME] blood Container/Tube: Preferred: Lavender top (EDTA) or yellow top (ACD) Acceptable: Any anticoagulant [NAME]: 3 mL Collection Instructions: 1. Invert several times to mix blood. 2. Send specimen in original tube. Forms: 1. Molecular Genetics-Congenital Inherited Diseases Patient Information Sheet (Supply T521) in 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. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	Plasma or serum | An interpretive report will be provided. | Tuesday; 10 a.m. | 10 days | 16 days | 1 | 81479 |  |  |  |  | Rochester
LYZKM | [NAME] | VARIES | Varies |  |  |  | Ambient
LYZKM | Result | 33437 | [NAME] | [NAME] | Alphanumeric
LYZKM | Result | 33438 | [NAME] | [NAME] | Alphanumeric
LYZKM | Result | 33439 | Source | Source | Alphanumeric
LYZKM | Result | 33440 | Order Date | Order Date | Alphanumeric
LYZKM | Result | 33441 | Reason For Referral | Reason For Referral | Alphanumeric
LYZKM | Result | 33442 | Method | Method | Alphanumeric
LYZKM | Result | 33443 | Result | Result | Alphanumeric
LYZKM | Result | 33444 | Interpretation | Interpretation | Alphanumeric
LYZKM | Result | 33445 | Amendment | Amendment | Alphanumeric
LYZKM | Result | 33446 | Reviewed By | Reviewed By | Alphanumeric
LYZKM | Result | 33447 | Release Date | Release Date | Alphanumeric
Spreadsheet: 07133943-08f0-4586-8c19-2499d33210ca
Sheet: Sheet1

WID#: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | WA STATE WORK STUDY | Unnamed: 8 | Unnamed: 9
POSTION: |  |  |  |  |  |  | **Please mark the box above if you are WA state work study
GL ACCT#:
Student Employee's Name (Print) |  |  |  |  |  |  | ATTENTION EMPLOYERS
 |  |  |  |  |  | Type or complete in ink all items requested.  Verify the information for accuracy.  An incorrect or blank item may delay reimbursement.  This time sheet MUST be received by the student's college/university within 15 DAYS from the end of the current pay period or REIMBURSEMENT MAY BE DENIED.  Once the institution submits the time sheet to the Higher Education Coordinating board, you should receive your reimbursement check within 3-6weeks if no corrections are needed.  At the end of the state's fiscal year, it may be 1 or 2 weeks longer.
1
 | Last |  | First
2
 | Student's Social Security Number
3 | WHITMAN COLLEGE
 | Student's College/University
4
 | Student's Job Title
5 | First Day Hours Were Worked:
 |  |  |  | [NAME]/dd/yy
6 | Last Day Hours Were Worked: |  |  |  |  | 11 | [NAME] of Pay | $
 |  |  |  | [NAME]/dd/yy |  | 12 | Gross Compensation | $ | 0
7 | Record of Actual Hours Worked (Decimals for partial hours) |  |  |  |  | PAYROLL OFFICE TO COMPLETE:
 |  |  |  |  |  | 13 | FICA | $
 | 09 |  | 24 |  |  | 14 | Other Deductions | $
 | 10 |  | 25 |  |  | 15 | Net Earnings | $
 | 11 |  | 26 |  |  | 16 | Whitman College
 | 12 |  | 27 |  |  |  | Name of Employing Business or Organization
 | 13 |  | 28 |  |  | 17 | 91-0567740
 | 14 |  | 29 |  |  |  | Firm's Federal I.D. Number | Suffix
 | 15 |  | 30
 | 16 |  | 31 |  |  |  | "This time sheet is a true and correct statement of the time worked by this student.  The student has completed the assignment satisfactorily, continues to have work study eligibility, and has been paid by check the amount of net earnings as shown.  I hereby certify, UNDER PENALTY OF PERJURY under the laws of the State of Washington, that the foregoing is true and correct" (must be signed and dated on or after last day student worked).
 | 17 |  | 01
 | 18 |  | 02
 | 19 |  | 03
 | 20 |  | 04
 | 21 |  | 05
 | 22 |  | 06
 | 23 |  | 07
 |  |  | 08
8 | Total Hours Worked: |  | 0
PAYROLL OFFICE USE ONLY: |  |  |  |  |  | 18
WA STATE WORKSTUDY ONLY |  |  |  |  |  |  | [NAME]'s Signature
 | (76 hours WS limit) |  | 76
Total hours over WS Limit |  |  |  | 0 |  |  | [NAME]
**Pay hours over limit as federal then regular wages |  |  |  |  |  | 19
 |  |  |  |  |  |  | Date Signed (on or after last day worked)
 | "I hereby certify that this time sheet is a true and correct statement of hours worked by me and that I do have work study eligibility to cover my gross earnings." |  |  |  |  | 20 | Date Received by College/University
 |  |  |  |  |  | 21 | Received and Authorized by
 |  |  |  |  |  | 22 | Institution Code
 |  |  |  |  |  | 23 | Position Number
9 |  |  |  |  |  | 24 | Reimbursement Rate: 60%___40%___Other___
 | Student's Signature
10
 | Date Signed (on or after last day worked)
Spreadsheet: 756132d1637295672-combining-two-sets-of-data-example-6-
Sheet: Sheet1

 |  |  |  |  |  | 1 |  |  |  |  | 1
 |  |  |  |  | 2 |  |  |  |  |  | 2 |  |  |  | 2
 |  |  |  |  |  | 3 |  |  |  |  | 3 |  |  |  | 3
 |  |  |  |  | 4 |  |  |  |  |  | 4 |  |  |  | 4
 |  |  |  |  |  | 5 |  | <-- this should become this --> |  |  | 5 |  |  |  | 5
 |  |  |  |  | 6 |  |  |  |  |  | 6 |  |  |  | 6
 |  |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  | 7
 |  |  |  |  | 8 |  |  |  |  |  | 8 |  |  |  | 8
 |  |  |  |  |  | 9 |  |  |  |  | 9 |  |  |  | 9
Spreadsheet: 03697dc9-9647-437c-bd03-2ba367256ac3
Sheet: Sheet1

Course Title | Course Code | German Title | Loyola Equivalency | Student Credited
Aesthetic Practice of Photography |  |  | PT275 | [NAME],[NAME]
Catholic Theology |  | Katholische Theologie | TH3, TH2 | Cisz, [NAME]
Catholicism: Man and Conflict |  |  | TH319 | [NAME].[NAME]
Cognition & Personality |  |  | PY 3** | [NAME]
English Comedies |  |  | EN361 | Cisz, [NAME]
Europe: Middle Ages - Present |  |  | [NAME] | Dunn
German Experience |  |  | GR 3** | Hanley, [NAME], [NAME], Hansell, Fyer, Dunn
German History: 1918-1945 |  |  | [NAME] | Fryer
German Language for Foreigners |  | Sprachkurs für ausländische Studierende | GR*3 | Eimer
German Translation I |  |  | GR 2** | Cutler
German Translation II |  |  | GR*3 | [NAME],[NAME],Hansell, Dunn, Eimer
History of German Language |  |  | GR*3 | Hanley
History of [NAME] in the Middle Ages |  |  | HS3, GR3 | Shannon
History of the Womens Movement |  |  | [NAME] | Hanley
Linguistics, an Introduction to |  | Einführung in die Sprachwissenschaft | GR*3 | Eimer
Literature of the 19th Century |  | Eblgische Literaturgeschichte | EN 360 | Cutler
Literature, an Introduction to |  | Einführung in die Literaturwissenschaft | GR*3 | Eimer
Male & Female Languages |  |  | GR*3 | Hanley
Monastic Life and Folk Piety in the Old Church |  | Mönchtum und Volksfrömigkeit in der alten Kirche | GR*3 / TH 347 | Eimer
[NAME] Opera [NAME] |  |  | [NAME], MU200 | [NAME],[NAME]
Philosophical Ethics |  | Philosophical Ethics | PL 3** | Cutler
Philosophy |  |  | PL3, PL20 | Cisz, [NAME]
Protestant Theology |  |  | TH2 | [NAME], Shannon
Soil & Water Pollution |  |  | EH000 | Dunn
Synoptic Gospels |  |  | TH*3 | [NAME]
Spreadsheet: 41107d1239633719-pivot-table-help-sales
Sheet: Canopy

Shelters Division - Year to date [NAME]
April 2009
 |  | March 2007 | March 2008 | [NAME] | [NAME] | YTD | YTD | [NAME] | [NAME]
 | Area Sales Manager | Actual | Actual | CY v LY (£) | CY v LY (%) | 2007/08 | 2008/09 | CY v LY (£) | CY v LY (%)
 | [NAME] | 96415.51 | 16055.9 | -80359.60999999999 | -0.8334718138191666 | 144713.39 | 213245.27 | 68531.88 | 0.4735697228846619
 | [NAME] | 191620.63 | 72763.61 | -118857.02 | -0.620272566685539 | 669726.9399999996 | 432765.93 | -236961.0099999996 | -0.3538173483061615
 | [NAME] | 96879.44999999998 | 37814.16 | -59065.28999999999 | -0.6096782134910964 | 358182.54 | 220428.9699999999 | -137753.57 | -0.3845904102416607
Canopy | Cloakroom NI/Export | 297427.44 | 426555.4200000001 | 129127.9800000001 | 0.4341495189549427 | 898293.8199999998 | 1145996.65 | 247702.8300000005 | 0.2757481176927173
Division | [NAME] | 387719.02 | 700274.81 | 312555.7900000001 | 0.806139946397265 | 1518838.52 | 3439727.830000001 | 1920889.310000001 | 1.264709371474198
 | [NAME] | 308768.28 | 280339 | -28429.27999999997 | -0.09207318834693762 | 826765.5899999999 | 1143812.66 | 317047.0700000001 | 0.3834787923382251
 | [NAME] | 149127.4 | 245698.38 | 96570.98000000001 | 0.6475736853187276 | 729130.1699999999 | 945999.8599999999 | 216869.6899999999 | 0.2974361765883312
 | [NAME] | 88225.09 | 83425.84999999999 | -4799.240000000005 | -0.05439767757675289 | 599814.6 | 291921.61 | -307892.99 | -0.5133135972348789
 | NI/Export | 2919.9 | 1075.69 | -1844.21 | -0.6316003972738793 | 9634.4 | 4754 | -4880.4 | -0.50655982728556
Month Totals |  | 1619102.72 | 1864002.82 | 244900.1000000003 | 0.15 | 5755099.969999999 | 7838652.780000002 | 2083552.810000003 | 0.3620359022190892
Running Total - This year (to date) compared to Last financial year
 | Area Sales Manager | Last year (Total Sales 2007/2008) | Current Year (Total Sales) | [NAME] | [NAME] | 2008/2009 Target | 2008/2009 Target
 |  | 2007/2008 | 2008/2009 | (£) | (%) | (07/08 + 23%) | (£ To Do)
 | [NAME] | 520558.6200000001 | 213245.27 | -307313.35 | -0.5903530134608087 | 640287 | -427041.73
 | [NAME] | 1682021.109999999 | 432765.93 | -1249255.179999999 | -0.7427107618167764 | 2068885 | -1636119.07
 | [NAME] | 1104203.31 | 220428.97 | -883774.3399999999 | -0.8003728407588273 | 1358170 | -1137741.03
 | Cloakroom NI/Export | 3480715.52 | 1145996.65 | -2334718.870000001 | -0.6707583129344624 | 4281280 | -3135283.35
 | [NAME] | 5163909.469999997 | 3439727.83 | -1724181.639999997 | -0.3338907566092552 | 6351608 | -2911880.17
 | [NAME] | 2676543.499999997 | 1143812.660000001 | -1532730.839999997 | -0.5726530654181403 | 3292148 | -2148335.339999999
 | [NAME] | 2150876.779999998 | 945999.8600000006 | -1204876.919999997 | -0.560179425992036 | 2645578 | -1699578.139999999
 | [NAME] | 1481113.350000001 | 291921.61 | -1189191.74 | -0.802903937095699 | 1821769 | -1529847.39
 | NI/Export | 164834.84 | 4879.690000000001 | -159955.15 | -0.970396488994681 | 202746 | -197866.31
 |  | 18424776.49999999 | 7838778.470000002 | -10585998.02999999 | -0.57 | 22662471 | -14823692.53
Spreadsheet: 780047d1652270105-help-with-summary-tables-using-average-index-and-match-sample_model
Sheet: Output

Q1 2022 | Average | Median | Min | [NAME]
New orders | 18
Total revenue
Gross profit
Net profit
Q2 2022 | Average | Median | Min | [NAME]
New orders
Total revenue
Gross profit
Net profit
FY 2022 | Average | Median | Min | [NAME]
New orders
Total revenue
Gross profit
Net profit
FY 2025 | Average | Median | Min | [NAME]
New orders
Total revenue
Gross profit
Net profit
Spreadsheet: 291495d1390314613-copying-code-down-a-column-without-all-cell-references-updating-corrected-messy-formula-rj-tms
Sheet: Sheet1

Select Price Group: | PG1
Search Items
Code | Description | Price | Qty | Total
[NAME] |  |  | 1
B6DP2D |  |  | 2
B6DP1D3S
Spreadsheet: 727488d1617907165-averaging-formula-with-datedif-test-file
Sheet: Sheet1

START DATE | END DATE
2018-02-20 00:00:00 | 2018-08-23 00:00:00
2018-02-20 00:00:00 | 2018-08-23 00:00:00
2019-08-18 00:00:00 | 2019-11-06 00:00:00
2019-11-25 00:00:00 | 2020-03-24 00:00:00
2019-12-09 00:00:00 | 2020-05-20 00:00:00
2020-03-17 00:00:00 | 2020-06-02 00:00:00
2020-01-21 00:00:00 | 2020-03-11 00:00:00
2020-02-03 00:00:00 | 2020-07-21 00:00:00
2020-03-02 00:00:00 | 2021-05-05 00:00:00
2020-05-25 00:00:00 | 2021-01-14 00:00:00
2020-06-08 00:00:00 | 2020-10-05 00:00:00
2020-08-04 00:00:00
2020-11-10 00:00:00
2021-02-01 00:00:00
Spreadsheet: 138996d1328032514-excel-2008-bypassing-the-3-conditional-formatting-limit-in-office-08-mac_vacation_planner_final
Sheet: July

Week #
 |  |  | 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
 | Total January