tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 32357200-1d50-4f4d-99a9-2582768de8a6
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
PBORR | Test | PBORR | Lyme Disease (Borrelia burgdorferi), Molecular Detection, PCR | Lyme Disease PCR | Real-Time Polymerase Chain Reaction (PCR)/DNA [NAME] (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | [NAME], leak proof vial: ScwLkPf |  |  | 1 | mL | Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen.  [NAME] source is required.   Submit only 1 of the following specimens:   Specimen Type: Spinal fluid Container/Tube: Sterile vial [NAME]: 1 mL Collection Instructions: Label specimen as spinal fluid.   Specimen Type: Synovial fluid Container/Tube: Sterile vial [NAME]: 1 mL Collection Instructions: Label specimen as synovial fluid.   Specimen Type: Tissue (fresh only)  Sources: Skin or synovial biopsy Container/Tube: Sterile container with normal saline  [NAME]: Approximately 4 mm(3)  Collection Instructions:  1. Submit only fresh tissue. 2. Skin biopsies: [NAME] biopsy site with an antiseptic soap. Thoroughly rinse area with sterile water. Do not use alcohol or iodine preparations. A local anesthetic may be used.  [NAME] specimens are best taken by [NAME] to include full thickness of dermis. 3. Label specimen with source of tissue. | Spinal Fluid or Synovial Fluid: | Hemolysis	NA Thawing	Warm OK - note to lab; Cold OK Lipemia	NA Icterus	NA Other	Green-top (heparin) tube, yellow-top (ACD) tube, blood, or plasma | Negative | Monday through Saturday (June through November) Monday through Friday (December through May) | 1 day | 4 days | 1 | 87476 |  |  |  |  | Rochester
PBORR | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
PBORR | Order Question | SRC71 | [NAME] |  | Plain Text
PBORR | Result | SRC71 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
PBORR | Result | 23635 | Lyme Disease PCR | Lyme Disease PCR | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4991-6 | Borrelia burgdorferi DNA:ACnc:Pt:[NAME]:[NAME]:Probe.amp.tar
Spreadsheet: 485956d1477212945-moving-every-second-row-into-the-row-above-book1
Sheet: Sheet1

Column A | Column B |  |  | Column A | Column B |  | Column A | Column B | Column C
2015-09-19 00:00:00 | [NAME], [NAME]
2015-09-25 00:00:00 | [NAME], [NAME]
 | 51.78 Regular
2016-09-08 00:00:00 | Ngapuhi Service Station, Kaikohe
 | 27.46 Regular
2015-08-02 00:00:00 | BP 2GO WAIPAPA
2015-08-20 00:00:00 | BP 2GO WAIPAPA
 | 32.71 Unleaded
2015-07-31 00:00:00 | [NAME], [NAME]
 | 26.49 Regular
2015-08-22 00:00:00 | Caltex Western Hills Drive, [NAME]
 | 32.37 Regular
2015-08-26 00:00:00 | Ngapuhi Service Station, Kaikohe
 | 24.73 Regular
Spreadsheet: 293694d1391066052-drop-down-list-dec-2013
Sheet: Q 7 till 26      

King Fahad Medical City
Pediatric Intensive Care Department
Involvement of ICU Nurses in DNR decision
What do you think is the most important factor to consider in determining the DNR status of the patient? | Column1
Current Prognosis
Quality of life
Reversibility of disease
Current Prognosis
Patient/Family wish
Quality of life
Quality of life
Missing
Patient/Family wish
Patient suffering
Patient/Family wish
Current Prognosis
Patient suffering
Current Prognosis
Current Prognosis
Patient suffering
Religion (Fatwa)
Current Prognosis
Reversibility of disease
Patient suffering
Reversibility of disease
Current Prognosis
Current Prognosis
Missing
Patient/Family wish
Patient suffering
Current Prognosis
Reversibility of disease
Reversibility of disease
Current Prognosis
Reversibility of disease
Current Prognosis
Reversibility of disease
Reversibility of disease |  |  |  | Value 12 | Value
Physicians opinion |  |  |  | Patient/Family wish | 1
Patient suffering |  |  |  | Quality of life | 2
 |  |  |  | Current Prognosis | 3
Current Prognosis |  |  |  | Reversibility of disease | 4
 |  |  |  | Physicians opinion | 5
Reversibility of disease |  |  |  | Religion (Fatwa) | 6
Patient/Family wish |  |  |  | Availability of resources | 7
Patient suffering |  |  |  | Patient suffering | 8
Patient/Family wish |  |  |  | Other | 9
Patient/Family wish |  |  |  | Missing | 0
Current Prognosis
Missing
Patient/Family wish
Current Prognosis
Current Prognosis
Quality of life
Quality of life
Patient suffering
Patient suffering
Patient suffering
Patient/Family wish
Current Prognosis
Current Prognosis
Quality of life
Patient/Family wish
Quality of life
Current Prognosis
Patient/Family wish
Reversibility of disease
Current Prognosis
Quality of life
Quality of life
Current Prognosis
Patient/Family wish
Patient suffering
Current Prognosis
Current Prognosis
Current Prognosis
Reversibility of disease
Quality of life
Current Prognosis
Current Prognosis
Spreadsheet: 855050d1704773034-need-help-with-formulas-to-return-name-from-roster-on-calendar-resource-tracker
Sheet: Dec

 |  |  |  |  |  | CALENDAR MONTH | DECEMBER
 |  |  |  |  |  | CALENDAR YEAR
 |  |  |  |  |  | 1ST DAY OF WEEK | MONDAY
daily notes
daily notes
daily notes
daily notes
daily notes
 |  |  | Notes
daily notes
Spreadsheet: 100896d1299105353-excel-2007-conditional-formatting-multiple-conditions-demo-customer-leads-template
Sheet: Agent 2

Lead Id | Lead Type Id | First Name | Last Name | Address | City | State | Zip | [NAME] | Phone | Inquiry Type Id | DateTimeCreated | DateTimeUpdated | Inquiry Type Name
210597 | 2 | Customer | Last Name | 140 main st | Florissant | CO | 80816 |  |  | 7 | 2011-02-26 00:00:00 | 2011-02-26 00:00:00 | Work from Home (telecommuter)
Spreadsheet: c11a33cb-d27e-4073-878e-66b222fd2f13
Sheet: New Table 2

Table 2
Market Update:  U.S. Origins to Export Position Price Spreads ($[NAME])
Commodity | Origin--Destination
Corn | IL--Gulf
Corn | NE--Gulf
Soybean | IA--Gulf
HRW | KS--Gulf
HRS | ND--Portland
Note:  nq = no quote
Source:  Transportation & Marketing Programs/AMS/USDA
Spreadsheet: 09e6a2e2-2356-4f26-b5a7-d165817acf12
Sheet: DAFT

Team | [NAME] | Set | PPG | PPB | 15PG
Bate | DAFT | DAFT | 56.7 | 8
Bergen A | St. Joseph's DAFT mirror | DAFT | 197 | 13.78 | 1.8
Bergen B | St. Joseph's DAFT mirror | DAFT | 144 | 10.56 | 1.5
Bergen C | St. Joseph's DAFT mirror | DAFT | 81.5 | 8.54 | 0.5
Charter A | St. Joseph's DAFT mirror | DAFT | 246 | 17.39 | 1.5
Charter B | St. Joseph's DAFT mirror | DAFT | 145.5 | 11.52 | 1.3
Charter C | St. Joseph's DAFT mirror | DAFT | 77 | 6.2 | 0.5
Charter D | St. Joseph's DAFT mirror | DAFT | 44 | 5.81 | 0.3
Danville | DAFT | DAFT | 267.1 | 14.54
DCC A | DAFT | DAFT | 567.5 | 22.45
DCC B | DAFT | DAFT | 332.9 | 16.94
GDS | St. Joseph's DAFT mirror | DAFT | 430.5 | 21.34 | 6.4
GNS A | St. Joseph's DAFT mirror | DAFT | 177 | 13.99 | 1.7
GNS B | St. Joseph's DAFT mirror | DAFT | 48 | 8 | 0.2
[NAME] A | DAFT | DAFT | 329 | 17.75
High Tech A | St. Joseph's DAFT mirror | DAFT | 337 | 20.51 | 4.6
High Tech B | St. Joseph's DAFT mirror | DAFT | 173 | 11.84 | 1.9
High Tech C | St. Joseph's DAFT mirror | DAFT | 111.5 | 11.07 | 1.6
Hunter A | St. Joseph's DAFT mirror | DAFT | 476.5 | 22.39 | 7.8
[NAME] | St. Joseph's DAFT mirror | DAFT | 461 | 23.28 | 7.2
[NAME] | St. Joseph's DAFT mirror | DAFT | 349 | 20.23 | 6
[NAME] | St. Joseph's DAFT mirror | DAFT | 99.5 | 9.81 | 0.4
Kellenberg | St. Joseph's DAFT mirror | DAFT | 139 | 11.97 | 1.6
Manual A | DAFT | DAFT | 274.2 | 17.8
Manual B | DAFT | DAFT | 85 | 10.93
Millburn A | St. Joseph's DAFT mirror | DAFT | 216.5 | 13.26 | 2.6
Millburn B | St. Joseph's DAFT mirror | DAFT | 162 | 10.88 | 1.1
Millburn C | St. Joseph's DAFT mirror | DAFT | 93 | 9.79 | 1.3
Piarist A | DAFT | DAFT | 194 | 14.76
Piarist B | DAFT | DAFT | 68.3 | 10.45
Ridgewood A | St. Joseph's DAFT mirror | DAFT | 155.5 | 12.43 | 1
Ridgewood B | St. Joseph's DAFT mirror | DAFT | 81 | 7.5 | 0.2
Ridgewood C | St. Joseph's DAFT mirror | DAFT | 54 | 5.28 | 0.1
Seton Hall A | St. Joseph's DAFT mirror | DAFT | 120 | 8.75 | 0.5
SJHS Green | St. Joseph's DAFT mirror | DAFT | 189 | 12.26 | 1.7
SJHS White | St. Joseph's DAFT mirror | DAFT | 173 | 13.15 | 1.9
Wissahicken | St. Joseph's DAFT mirror | DAFT | 274.5 | 18.79 | 4
Woodford A | DAFT | DAFT | 162.9 | 13.65
Woodford B | DAFT | DAFT | 97.5 | 9.06
Woodford C | DAFT | DAFT | 44.3 | 5.45
Woodford D | DAFT | DAFT | 20.8 | 0.83 | 0
Woodford Middle | DAFT | DAFT | 52.5 | 7.37
Spreadsheet: 840273d1692619961-returning-range-of-student-names-from-a-list-how-to-fix-error-marking-schedule-f2023
Sheet: Sample Sheet

Lab Marking Group Numbers |  |  |  |  |  |  |  |  |  |  |  | Names to Grade
Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  |  | Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
Sheldon | 1
TA 1 | 2
TA 2 | 3
TA 3 | 4
TA 4 | 5
Number of Reports to Grade
 | 72
Misscalenous
Group | Names
1
2
3
4
5
72 labs
16
20
20
8
8
Student Names
[NAME] | 1
Boland | 2
[NAME] | 3
Dunphy | 4
Ezekiel | 5
Forrester | 6
[NAME] | 7
Huelin | 8
Ingram | 9
Jones | 10
[NAME] | 11
[NAME] | 12
Manuel | 13
[NAME] | 14
Octos | 15
Philpott | 16
Quilty | 17
Robinsons | 18
Shelly | 19
Tobin | 20
Urchin | 21
Valley | 22
Wall | 23
Xavier | 24
Young | 25
Zhang | 26
august | 27
Boland | 28
[NAME] | 29
Dunphy | 30
Ezekiel | 31
Forrester | 32
[NAME] | 33
Huelin | 34
Ingram | 35
Jones | 36
[NAME] | 37
[NAME] | 38
Manuel | 39
[NAME] | 40
Octos | 41
Philpott | 42
Quilty | 43
Robinsons | 44
Shelly | 45
Tobin | 46
Urchin | 47
Valley | 48
Wall | 49
Xavier | 50
Young | 51
Zhang | 52
august | 53
Boland | 54
[NAME] | 55
Dunphy | 56
Ezekiel | 57
Forrester | 58
[NAME] | 59
Huelin | 60
Ingram | 61
Jones | 62
[NAME] | 63
[NAME] | 64
Manuel | 65
[NAME] | 66
Octos | 67
Philpott | 68
Quilty | 69
Robinsons | 70
Shelly | 71
Tobin | 72
Urchin | 73
Valley | 74
Wall | 75
Xavier | 76
Young | 77
Zhang | 78
Spreadsheet: 389663d1429224450-using-sumifs-and-edate-to-retrieve-business-model-info-excel-forum-question
Sheet: Sheet2

 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2012 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2014
California Revenue |  |  |  | 5 | 5 | 5 | 10 | 10 | 10 | 10 | 10 | 10 |  | 10 | 10 | 10 | 10 | 10 | 10 | 15 | 15 | 15 | 15 | 15 | 15 |  | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15
Virginia Revenue |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 |  | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | Calfornia Year 1 |  |  |  |  |  |  |  |  |  |  |  |  | California Year 2
 |  |  |  |  |  |  |  |  |  |  |  |  | SUM    (E3:M3,O3:Q3) |  |  |  |  |  |  |  |  |  |  |  |  | SUM    (R3:Z3,AB3:AD3)
 |  |  |  |  |  |  |  |  |  |  |  |  | Virginia Year 1 |  |  |  |  |  |  |  |  |  |  |  |  | Virginia Year 2
 |  |  |  |  |  |  |  |  |  |  |  |  | SUM   (N5,P5:Z5) |  |  |  |  |  |  |  |  |  |  |  |  | SUM   (AA5,AC5:AM5)
= | I need these formulas to be dynamic, calculating the start of the "year 1" on the first month that revenue begin, then I need this logic to hold up, where "year 2" begins the month after "Year 1" ends
Spreadsheet: 783199d1654659978-finding-the-middle-value-in-a-row-finding-the-middle-value-in-a-row-v2
Sheet: Sheet1

Product name | Amazon | HN | Catch | Costco | DJ | THX | H | KWH | MBX | MMX | MY | POK | VB | Min | Mid |  | Helper | Mid 1 | Mid 2
Item 1 | 67.2 |  | 59.95 |  | 0 |  |  |  |  | 37.82
Item 2 | 70.37 |  | 59.95 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 70.37
Item 3 | 17.5 |  |  |  |  |  | 8.99 | 8.95 |  |  |  | 0 | 8.95 |  |  |  |  |  | 8.99
Item 4 | 68.88 |  |  |  |  |  |  |  |  |  |  | 0
Item 5 | 91.82 |  |  |  | 76 |  |  | 84.95
Item 6 | 24 |  |  | 16 |  |  |  |  |  | 18 |  | 18 | 19.95
Spreadsheet: 772701d1647436828-counting-names-with-check-boxes-avgo-checkbox-test
Sheet: Sheet1

 |  | PRESENT |  |  | PRESENT
 | NAME 1 | False |  | NAME 1 | False
 | [NAME] 2 | True |  | NAME 3 | True
 | NAME 3 | False |  | NAME 4 | False
 |  |  |  | NAME 5 | True
 |  |  | ABSENT
 | NAME 1
 | [NAME] 2
 | NAME 3
 | NAME 4
 | NAME 5
Spreadsheet: 598594d1542620307-formula-used-in-weekly-reduction-of-work-hours-test-workbook-tms
Sheet: SAL

 | Mar - 01st | Mar - 05th | Mar - 12th | Mar - 19th | [NAME] | Monthly | Hours | Burn
 | Mar - 04th | Mar - 11th | Mar - 18th | Mar - 25th | Mar - 31st | Totals | Balance | Rate
DS Authorized Hours
DS Billable Hours
[NAME] Authorized
[NAME]
[NAME]
[NAME]
[NAME]
CSO Authorized
CSO Billable Hours
CSO Non-Billable Hours
CSO Billable OT
CSO Non-Billable OT
Burn Rate
 | Mar - 01st | Mar - 05th | Mar - 12th | Mar - 19th | [NAME] | Monthly | Hours | Burn
 | Mar - 04th | Mar - 11th | Mar - 18th | Mar - 25th | Mar - 31st | Totals | Balance | Rate
[NAME] Authorized
[NAME]
[NAME]
[NAME]
[NAME]
CSO Authorized
CSO Billable Hours
CSO Non-Billable Hours
CSO Billable OT
CSO Non-Billable OT
Burn Rate
 | Mar - 01st | Mar - 05th | Mar - 12th | Mar - 19th | [NAME] | Monthly | Hours | Burn
 | Mar - 04th | Mar - 11th | Mar - 18th | Mar - 25th | Mar - 31st | Totals | Balance | Rate
[NAME] Authorized
[NAME]
[NAME]
[NAME]
[NAME]
CSO Authorized
CSO Billable Hours
CSO Non-Billable Hours
CSO Billable OT
CSO Non-Billable OT
Burn Rate
Spreadsheet: 05165766-85cd-47cb-b777-4f9fa87172f3
Sheet: 18

Product* | November 22 | November 29 | December 6 | December 13 | December 20
Total** | 31450000 | 31450000 | 31450000 | 31450000 | 31450000
Non-Deliverable Forwards | N/A | N/A | N/A | N/A | N/A
Options | N/A | N/A | N/A | N/A | N/A
Forwards | N/A | N/A | N/A | N/A | N/A
Swaps | N/A | N/A | N/A | N/A | N/A
OTHER | N/A | N/A | N/A | N/A | N/A
TOTAL
Gross notional amount outstanding, December 20 weekly snapshot, by product type, all participant types, tenors and currencies.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**These numbers are estimates.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 812092d1672943250-find-last-occurrence-in-a-table-of-specific-text-s666-pq-find-last-occurrence-in-a-table-of-specific-text
Sheet: Sheet1

Date | [NAME] | [NAME] | [NAME] | [NAME] | Adam |  | Value | [NAME]
2023-01-01 00:00:00 | Job 1 | Job 2 | Job 3 | Job 3 | Job 3 |  | Job 1 | 2023-01-15 00:00:00
2023-01-02 00:00:00 | Job 1 | Job 2 | Job 3 | Job 3 | Job 1 |  | Job 2 | 2023-01-15 00:00:00
2023-01-03 00:00:00 | Job 2 | Job 2 | Job 3 | Job 1 | Job 1 |  | Job 3 | 2023-01-10 00:00:00
2023-01-04 00:00:00 | Job 2 | Job 3 | Job 3 | Job 1 | Job 2 |  | Job 4 | 2023-01-15 00:00:00
2023-01-05 00:00:00 | Job 2 | Job 3 | Job 1 | Job 2 | Job 2 |  | Job 5 | 2023-01-14 00:00:00
2023-01-06 00:00:00 | Job 2 | Job 3 | Job 1 | Job 2 | Job 2
2023-01-07 00:00:00 | Job 3 | Job 3 | Job 2 | Job 2 | Job 4
2023-01-08 00:00:00 | Job 3 | Job 1 | Job 2 | Job 4 | Job 4
2023-01-09 00:00:00 | Job 3 | Job 1 | Job 2 | Job 4 | Job 4
2023-01-10 00:00:00 | Job 3 | Job 2 | Job 4 | Job 4 | Job 1
2023-01-11 00:00:00 | Job 1 | Job 2 | Job 4 | Job 1 | Job 5
2023-01-12 00:00:00 | Job 1 | Job 2 | Job 4 | Job 5 | Job 5
2023-01-13 00:00:00 | Job 2 | Job 4 | Job 1 | Job 5 | Job 5
2023-01-14 00:00:00 | Job 2 | Job 4 | Job 1 | Job 5 | Job 2
2023-01-15 00:00:00 | Job 2 | Job 4 | Job 1 | Job 2 | Job 2
Job 1 | 2023-01-15 00:00:00
Job 2 | 2023-01-15 00:00:00
Job 3 | 2023-01-10 00:00:00
Job 4 | 2023-01-15 00:00:00
Job 5 | 2023-01-14 00:00:00
Spreadsheet: 292825d1390806369-how-to-check-if-a-year-in-a-cell-is-a-leap-year-feb
Sheet: MAR

 |  | SAT |  | SUN |  | MON |  | TUE |  | WED |  | THU |  | FRI
 | Date: | Days | Nights | Days | Nights | Days | Nights | Days | Nights | Days | Nights | Days | Nights | Days | Nights
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  | SAT |  | SUN |  | MON |  | TUE |  | WED |  | THU |  | FRI
 | Date: | Days | Nights | Days | Nights | Days | Nights | Days | Nights | Days | Nights | Days | Nights | Days | Nights
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  | SAT |  | SUN |  | MON |  | TUE |  | WED |  | THU |  | FRI
 | Date: | Days | Nights | Days | Nights | Days | Nights | Days | Nights | Days | Nights | Days | Nights | Days | Nights
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  | SAT |  | SUN |  | MON |  | TUE |  | WED |  | THU |  | FRI
 | Date: | Days | Nights | Days | Nights | Days | Nights | Days | Nights | Days | Nights | Days | Nights | Days | Nights
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  | SAT |  | SUN |  | MON |  | TUE |  | WED |  | THU |  | FRI
 | Date: | Days | Nights | Days | Nights | Days | Nights | Days | Nights | Days | Nights | Days | Nights | Days | Nights
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Spreadsheet: 117949d1313291219-excel-2007-conditional-formulas-kyles-halo-reach-commendations
Sheet: CAMPAIGN

CAMPAIGN
Commendation | Requires | Current Number | To Next Tier | Iron | [NAME] | Silver | Gold | Onyx | [NAME]
[NAME] | Infantry-class enemy | 4204 |  | 250 | 750 | 3000 | 7000 | 12000 | 20000
[NAME] | Complete mission | 58 |  | 9 | 18 | 81 | 135 | 270 | 540
Flawless Cowboy | H. or L. w/out dying | 3 |  | 5 | 10 | 25 | 50 | 150 | 300 |  | Iron
Leadership Element | Leader-class enemy | 1476 |  | 100 | 375 | 750 | 3000 | 6000 | 10000 |  | [NAME]
Nice Arm | Grenade kill | 806 |  | 50 | 250 | 500 | 4000 | 8000 | 13000 |  | Silver
Pinpoint | [NAME] | 1995 |  | 50 | 250 | 500 | 4000 | 8000 | 20000 |  | Gold
Precisely | Precision weapon kill | 1876 |  | 250 | 750 | 4000 | 10000 | 20000 | 32000 |  | Onyx
Right of Way | Destroy enemy vehicle | 530 |  | 50 | 200 | 1000 | 2400 | 4800 | 7200 |  | [NAME]
Small Arms | Small arms weapon kill | 926 |  | 250 | 750 | 3000 | 6000 | 10000 | 16000
SpecOps | Specialist-class enemy | 4109 |  | 175 | 525 | 2100 | 6000 | 10000 | 14000
Splash Damage | Heavy weapon kill | 4043 |  | 100 | 375 | 750 | 1500 | 3000 | 6000
Standard Issue | Automatic weapon kill | 834 |  | 250 | 750 | 3000 | 6000 | 10000 | 15000
Super Soldier | Spree | 740 |  | 25 | 175 | 500 | 2000 | 5000 | 9000
Support Role | Assist | 85 |  | 100 | 375 | 750 | 1500 | 3000 | 6000
Walking Tank | [NAME] | 4360 |  | 25 | 175 | 500 | 2000 | 5000 | 9000
War Machine | Vehicle kill | 571 |  | 200 | 500 | 800 | 3200 | 6400 | 14000
Spreadsheet: 808181d1670338144-multiple-replace-of-partial-texts-sample-5-
Sheet: Sample

Input | Output |  | Replace | WITH
XX FIAT | AA FIAT |  | XX | AA
XX GM | [NAME] |  | YY | BB
[NAME] | [NAME] |  | ZZ | CC
YY FIAT | BB FIAT
YY GM | BB GM
YY HONDA | [NAME]
FIAT ZZ | FIAT CC
GM ZZ | GM CC
HONDA ZZ | HONDA CC
TEST | TEST
Spreadsheet: 681329d1591479462-selective-delete-duplicate-rows-based-on-a-match-across-3-columns-example
Sheet: Sheet3

Example
Title | Artist | Version
Good Times | [NAME] | Single
Good Times | [NAME] | Album
Good Times | [NAME] | Single | <<< Duplicate with row 2 & 8 so excel should delete
Good Times | [NAME] | Single
Le Freak | [NAME] | 12"
Le Freak | [NAME] | 12"
Good Times | [NAME] | Single | <<< Duplicate with row 4 & 8 so excel should delete
It is not essential that Excel does not delete Row 2, it could delete row 2 & 4 leaving row 8, The important thing is that Excel deletes
all but one of the duplates leaving one unique record in the spreadsheet.
The Result
Title | Artist | Version
Good Times | [NAME] | Single
Good Times | [NAME] | Album
Good Times | [NAME] | Single
Le Freak | [NAME] | 12"
Le Freak | [NAME] | 12"
Spreadsheet: 61467d1262333467-lookup-item-that-may-be-in-one-of-multiple-columns-display-from-one-column-excel-sam2045-helpsheet
Sheet: Input Sheet

 | Expense
 |  | 5100000 · Personnel Expenses
 |  |  | 5110000 · Compensation
 |  |  |  | 5111000 · Payroll
 |  |  |  |  | 5111100 · Bonus | 100
 |  |  |  |  | 5111201 · Bonus - Fund I | 101
 |  |  |  |  | 5111202 · Bonus - Fund II | 102
 |  |  |  |  | 5111300 · Salary | 103
 |  |  |  | Total 5111000 · Payroll |  | 406
 |  |  |  | 5112000 · Payroll Taxes
 |  |  |  | 5112100 · Employer FICA |  | 100
 |  |  |  | 5112200 · Employer FUTA |  | 100
 |  |  |  | 5112300 · Employer SUI |  | 100
 |  |  |  | Total 5112000 · Payroll Taxes |  | 300
Spreadsheet: rick_buy__32663__Rac allocations budget pack 29 Nov
Sheet: template

Plan 2001
 | Total
Spreadsheet: 36388d1234275108-if-formula-to-add-the-sum-to-multiple-lines-invoicesum
Sheet: Sheet1

User ID | Invoice Number | Amount | Total
1 | 1 | 25
2 | 2 | 50
3 | 3 | 25
3 | 4 | 25
3 | 5 | 100
4 | 6 | 75
5 | 7 | 50
5 | 8 | 25
5 | 9 | 125
6 | 10 | 50
7 | 11 | 25
8 | 12 | 75
8 | 13 | 100
8 | 14 | 75
9 | 15 | 25
10 | 16 | 50
 | Create a formula for column D that adds all the invoice amounts for the same user
This is the way I would like it to look
User ID | Invoice Number | Amount | Total
1 | 1 | 25 | 25
2 | 2 | 50 | 50
3 | 3 | 25 | 150
3 | 4 | 25 | 150
3 | 5 | 100 | 150
4 | 6 | 75 | 75
5 | 7 | 50 | 200
5 | 8 | 25 | 200
5 | 9 | 125 | 200
6 | 10 | 50 | 50
7 | 11 | 25 | 25
8 | 12 | 75 | 250
8 | 13 | 100 | 250
8 | 14 | 75 | 250
9 | 15 | 25 | 25
10 | 16 | 50 | 50
Spreadsheet: 727835d1618143371-year-to-date-profit-and-loss-excel-formula-year-to-date-profit-and-loss-1
Sheet: Monthly Profit and Loss

ZWL |  | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | YTD
Revenue
School Fees |  | 2000 | 2000 | 2200
Other Income
Bus Fares |  | 300 | 300 | 300
Swimmnig |  | 120 | 120 | 120
Donations |  | 0
Total Other Income
Expenses
Accounting Fees |  | 20 | 20 | 25
Advertising & Marketing |  | 0 | 0 | 0
Cleaning |  | 7 | 7 | 7
Rental - Knight frank |  | 100 | 100 | 0
[NAME] |  | 30 | 30 | 0
Electricity |  | 10 | 10 | 0
Fuel & Oils |  | 12 | 14 | 0
Insurance & Licence |  | 0 | 0 | 0
Miscellaneous |  | 55 | 40 | 0
Printing & Stationery |  | 0 | 0 | 0
Salaries & Wages |  | 100 | 100 | 300
Security - Fawcett |  | 0 | 0 | 0
Property Repairs & Maintenance |  | 27 | 23 | 90
Motor Vehicles Repairs and Maintenance |  | 0 | 0 | 0
Feeding Programme |  | 0 | 0 | 0
Telephone & Internet |  | 50 | 45 | 30
Water & Rates |  | 0 | 0 | 0
Board Members Allowance |  | 0 | 0 | 0
Subscriptions |  | 0 | 0 | 0
Workshops & Conferances |  | 0 | 100 | 0
Total Expenses
Profit