tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 812089d1672942337-find-last-occurrence-in-a-table-of-specific-text-book2
Sheet: Sheet1

Date | [NAME] | [NAME] | [NAME] | [NAME] | Adam
2023-01-01 00:00:00 | Job 1 | Job 2 | Job 3 | Job 3 | Job 3 |  |  |  | Job 1
2023-01-02 00:00:00 | Job 1 | Job 2 | Job 3 | Job 3 | Job 1 |  |  |  | Job 2
2023-01-03 00:00:00 | Job 2 | Job 2 | Job 3 | Job 1 | Job 1 |  |  |  | Job 3
2023-01-04 00:00:00 | Job 2 | Job 3 | Job 3 | Job 1 | Job 2 |  |  |  | Job 4
2023-01-05 00:00:00 | Job 2 | Job 3 | Job 1 | Job 2 | Job 2 |  |  |  | Job 5
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
Spreadsheet: 5ec9711e-f32d-413a-a9d4-e3963a8f383d
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
EPIP2 | Test | EPIP2 | Epithelia Panel # 2 | Epithelia Panel # 2 | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top	 Acceptable: Serum gel [NAME]: 0.5 mL Additional Information: See Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
EPIP2 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
EPIP2 | Result | EPIP2 | Epithelia Panel # 2 | Epithelia Panel # 2 | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 687018d1594916316-countifs-for-unique-data-book1
Sheet: Sheet1

 | Client | Date |  |  |  | Total Distinct Clients | New Unique Clients |  |  | Comment
 | [NAME] | 2020-04-15 00:00:00 |  |  | To End of April | 3 | 3 |  |  | 3 clients, all unique
 | [NAME] | 2020-04-30 00:00:00 |  |  | To End of May | 6 | 3 |  |  | 8 deals but [NAME] and [NAME] each had 2 deals so 6 DISTINCT. From April, [NAME] and [NAME] are new
 | [NAME] | 2020-04-30 00:00:00 |  |  | To End of June | 7 | 1 |  |  | 7 discint clients, [NAME] was new
 | [NAME] | 2020-05-10 00:00:00
 | [NAME] | 2020-05-10 00:00:00
 | [NAME] | 2020-05-10 00:00:00
 | [NAME] | 2020-05-30 00:00:00
 | [NAME] | 2020-05-30 00:00:00
 | [NAME] | 2020-06-10 00:00:00 |  |  |  | To the extend helpful, these were my formulas
 | [NAME] | 2020-06-15 00:00:00 |  |  |  | Array for total distinct | Arrow for unique
 | [NAME] | 2020-06-30 00:00:00 |  |  |  |  |  |  |  | 7 distinct, only unique clients are [NAME] and [NAME]
 | [NAME] | 2020-06-30 00:00:00
 | [NAME] | 2020-06-30 00:00:00
Spreadsheet: 825932d1681653489-convert-from-a-vertical-list-to-a-horizontal-list-cant-use-transpose-final-version-aligw
Sheet: Sheet2

 | Last Name | First Name | [NAME] | Course
12345 | Smith | [NAME] | [EMAIL] | Test Course 1 | Test Course 2 | Test Course 3 | Test Course 4 | Test Course 5 | Test Course 6 | Test Course 7
32423 | Thomson | [NAME] | [EMAIL] | Test Course 8 | Test Course 9 | Test Course 10 | Test Course 11 | Test Course 12 | Test Course 13 | Test Course 14 | Test Course 15 | Test Course 16 | Test Course 17 | Test Course 18 | Test Course 19
Spreadsheet: 328710d1404036524-how-to-colour-a-cell-based-on-few-conditions-cell-values-of-other-cells-in-the-same-row-example
Sheet: PM

Stream | Team | Business request | Priotity | Milestone description | Additional information (Optional) | Jan |  |  |  |  | Feb |  |  |  | March |  |  |  | April |  |  |  |  | May |  |  |  | June |  |  |  | July |  |  |  |  | August |  |  |  | Sep |  |  |  | Oct |  |  |  |  | Nov |  |  |  | Dec
SC |  |  |  |  |  | W1 | [NAME] | W3 | W4 | W5 | W6 | W7 | W8 | W9 | W10 | W11 | W12 | W13 | W14 | W15 | W16 | W17 | W18 | W19 | W20 | W21 | [NAME] | W23 | W24 | W25 | W26 | [NAME] | W28 | W29 | W30 | W31 | W32 | W33 | [NAME] | W35 | W36 | W37 | W38 | W39 | W40 | W41 | W42 | W43 | W44 | W45 | W46 | W47 | [NAME] | [NAME] | W50 | W51 | W52 |  |  |  |  |  |  |  |  | Not started
SC | P2P |  |  |  |  | Done | In progress |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In progress
SC | P2P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Done
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
SC | P2P
Spreadsheet: 686033d1594318410-formula-copying-down-in-table-fuel-tracking
Sheet: Sheet2

 |  |  |  |  |  |  |  | Today
Date | Equipment # | Hours | Gallons |  |  |  |  | Past Days in Period |  | 40
2020-05-03 00:00:00 | 32 | 7500 | 34
2020-05-10 00:00:00 | 45 | 12540 | 50 |  |  |  |  | Equipment # |  | 45
2020-05-17 00:00:00 | 32 | 7645 | 45
2020-05-17 00:00:00 | 45 | 12600 | 75 |  |  |  |  | Beginning Date |  | 2020-06-01 00:00:00
2020-05-24 00:00:00 | 45 | 12702 | 60 |  |  |  |  | Hours on Beginning Date day |  | 12800
2020-05-25 00:00:00 | 17 | 5640 | 24 |  |  |  |  | Gallons on Beginning day |  | 60
2020-05-31 00:00:00 | 32 | 7700 | 61
2020-06-01 00:00:00 | 45 | 12800 | 55
2020-06-03 00:00:00 | 17 | 5700 | 27
2020-06-05 00:00:00 | 32 | 7731 | 34 |  |  |  |  | Ending Date |  | 2020-07-03 00:00:00
2020-06-07 00:00:00 | 45 | 12900 | 47 |  |  |  |  | Hours on ending day |  | 13375
2020-06-12 00:00:00 | 45 | 13134 | 60
2020-06-12 00:00:00 | 32 | 7789 | 29
2020-06-12 00:00:00 | 17 | 5757 | 35 |  |  |  |  | Total Gallons |  | 518
2020-06-18 00:00:00 | 45 | 13200 | 78
2020-06-18 00:00:00 | 32 | 7812 | 15
2020-06-18 00:00:00 | 17 | 5805 | 14
2020-06-22 00:00:00 | 17 | 5834 | 30
2020-06-24 00:00:00 | 45 | 13264 | 59 |  |  |  |  |  | Inputs=>
2020-06-24 00:00:00 | 32 | 7869 | 60
2020-06-29 00:00:00 | 17 | 5867 | 32
2020-07-01 00:00:00 | 45 | 13307 | 34
2020-07-01 00:00:00 | 17 | 5890 | 27
2020-07-02 00:00:00 | 32 | 7900 | 59
2020-07-03 00:00:00 | 45 | 13375 | 65
2020-07-03 00:00:00 | 17 | 5903 | 24
2020-07-05 00:00:00 | 32 | 7960 | 45
2020-07-06 00:00:00 | 17 | 5922 | 27.5
Spreadsheet: 70334d1271116435-if-formula-config-sheet-budget-2011
Sheet: Sep

1st |  |  |  | 8th |  |  |  | 15th |  |  |  | 22nd |  |  |  |  |  |  |  |  |  |  |  | Income
Income |  |  |  | Income |  |  |  | Income |  |  |  | Income |  |  |  | Income |  |  |  | Income |  |  |  | Transfer
Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Birthday
Savings Balance |  | 0 |  | Savings Balance |  |  |  | Savings Balance |  |  |  | Savings Balance |  |  |  | Savings Balance |  |  |  | Savings Balance |  |  |  | Clothing
Subtract from Savings |  | 0 |  | Subtract from Savings |  | 0 |  | Subtract from Savings |  | 0 |  | Subtract from Savings |  | 0 |  | Subtract from Savings |  | 0 |  | Subtract from Savings |  | 0 |  | Entertainment
Previous |  |  |  | Previous |  |  |  | Previous |  |  |  | Previous |  |  |  | Previous |  |  |  | Previous |  |  |  | Fast Food
 |  |  |  |  |  |  |  |  |  | 100 |  |  |  | 100 |  |  |  | 100 |  |  |  | 100 |  | Fee
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Food
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gas
Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Insurance
Expenses |  |  |  | Expenses |  |  |  | Expenses |  |  |  | Expenses |  |  |  | Expenses |  |  |  | Expenses |  |  |  | Loan
Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Category | Item | Amount |  | Misc
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Smokes
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Utilities
Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total
Left Over |  |  |  | Left Over |  |  |  | Left Over |  |  |  | Left Over |  |  |  | Left Over |  |  |  | Left Over
Savings |  |  |  | Savings |  |  |  | Savings |  |  |  | Savings |  |  |  | Savings |  |  |  | Savings
Spreadsheet: 100666d1298969713-sumifs-on-multiple-work-sheets-seatigerorderworksheet-1-
Sheet: SalesByMonth

Month | Style | Description | Color | Size | Sold
Sep | 1873 | W BAILEY | BLK | 5 | 1
Sep | 1873 | W BAILEY | BLK | 6 | 2
Sep | 1873 | W BAILEY | BLK | 7 | 1
Oct | 1873 | W BAILEY | BLK | 5 | 1
Oct | 1873 | W BAILEY | BLK | 6 | 0
Oct | 1873 | W BAILEY | BLK | 7 | 3
Nov | 1873 | W BAILEY | BLK | 5 | 1
Nov | 1873 | W BAILEY | BLK | 6 | 0
Nov | 1873 | W BAILEY | BLK | 7 | 3
Dec | 1873 | W BAILEY | BLK | 5 | 1
Dec | 1873 | W BAILEY | BLK | 6 | 0
Dec | 1873 | W BAILEY | BLK | 7 | 3
Spreadsheet: 153798d1336057961-change-information-in-one-sheet-and-automtically-also-in-other-sheets-keis386
Sheet: Sheet1

a | b | c | d | e | f | g | h |  | Sheet1
4 | 5 | 2 | 23 | 2 | 3 | 2 |  |  | Sheet3
5 | 4 | 2 | 4 | 9 | 2 | 3
2 | 2 | 2 | 2 | 1 | 32 | 2
6 | 2 | 2 | 2 | 8 | 7 | 2
7 | 4 | 222 | 1 | 7 | 8 | 1
2 | 4 | 5 | 5 | 3 | 5 | 1
6 | 2 | 4 | 1 | 3 | 1 | 2
8 | 2 | 2 | 2 | 2 | 6 | 7
2 | 78 | 3 | 4 | 5 | 3 | 3
68 | 5 | 3 | 1 | 4 | 4 | 0
13 | 13 | 3 | 4 | 9 | 8 | 9
Spreadsheet: 491649d1480586228-sort-array-formula-results-in-descending-order-sort-array-formula-results-in-descending-order
Sheet: PS_TRANSPORT PLAN

 | TRANSPORT PLAN
 |  |  |  |  |  |  |  |  |  |  | Date | 2017-02-22 00:00:00 |  | ←1) Enter Date
 |  |  |  |  |  |  |  |  |  |  | Vehicle | Vehicle 2 |  | ←2) [NAME]
I would like these rows to be ordered as ↓ | DELIVERY ORDER | DRIVER | T/PORT | P/CODE | ADDRESS | CLIENT/CUSTOMER | CONTACT NAME | PHONE NO. | [NAME] | QTY | DELIVERY TYPE | DELIVERY RESTRICTIONS | TIME
 | PLEASE RING CUSTOMER BEFORE DELIVERY / COLLECTION
1
1
2
2
3
4
5
Spreadsheet: 854202d1704171119-closest-date-with-criteria-with-maxifs-formula-closestdate
Sheet: Sheet1

Date | Symbol | Closest RS Date |  |  |  | Date | Symbol | [NAME]
2023-08-11 00:00:00 | MULN |  |  |  |  | 2023-05-04 00:00:00 | MULN | 1 for 10
2023-12-05 00:00:00 | ABC |  |  |  |  | 2023-08-11 00:00:00 | MULN | 1 for 20
2023-12-06 00:00:00 | ABC |  |  |  |  | 2023-12-04 00:00:00 | SYTA | 1 for 10
2023-12-07 00:00:00 | ABC |  |  |  | Desired date in cell C2-> | 2023-12-21 00:00:00 | MULN | 1 for 50
2024-01-03 00:00:00 | MULN |  |  |  | Desired date in cell C6 -> | 2023-12-30 00:00:00 | MULN | 1 for 10
Spreadsheet: 141208d1329151525-moving-data-from-one-worksheet-to-another-based-on-certain-values-vlookup01
Sheet: Tab1

Employee_ID | Name | Other Data | Day1 | Day2 | Day3 | Day4 | Day5 | Day6 | Day7 | Day8 | Day9 | Day10 | Day11 | Day12 | Day13 | Day14 | Day15 | Day16
12345 | J Bloggs | t
321665 | J Smith | f
125432 | J Jones | c
444 | C [NAME] | s
454 | T [NAME] | a
Spreadsheet: 90249d1290005346-data-validation-ensuring-a-blank-employeeslist_temp-nov-16-ef
Sheet: EmployeesList_20101116_2

Dim1: Function Group | Dim2: Function | Dim3: Sub-Function | Job Type | Level | Job Step
Research | R&D, Research Analytics, Modelling | Modelling | RRDM | L3 | G3SV
Research | Product Design & Management
 | Data Entry & Scanning | Partnering | RCMP
Support | Personnal Assistants | Personnal Assistants | SPAA
 | Data Entry & Scanning | Data Entry & Scanning | ODEE
Research | Research Management | Qualitative Field Supervision
 | Product Design & Management | Product Management | RPMP
Operations | Data Processing | Coding | OCOC
 | Qualitative Moderator | Personnal Assistants | SPAA
Research | Qualitative Moderator | Personnal Assistants | SPAA
 | Qualitative Moderator | Personnal Assistants | SPAA
Spreadsheet: 845441d1696958058-pivot-with-multiple-tabs-as-range-forecasts-and-orders-10102023
Sheet: CFO

Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI |  | Order Date | PO | Description | Item Code | Qty
CFORCE WATER 12/1L | 09753
CFORCE WATER 12/700ML | 09754
CFORCE WATER 6/1.5L | 09755
CFORCE WATER 4/3L | 10762
Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI
CFORCE WATER 12/1L | 09753
CFORCE WATER 12/700ML | 09754
CFORCE WATER 6/1.5L | 09755
CFORCE WATER 4/3L | 10762
Spreadsheet: 147310d1332723866-aggregating-time-series-data-test-data
Sheet: Driving

 |  | 00:00:00 | 01:00:00 | 02:00:00 | 03:00:00 | 04:00:00 | 05:00:00 | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00
UID | 00:00:00 | 01:00:00 | 02:00:00 | 03:00:00 | 04:00:00 | 05:00:00 | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00 | 1900-01-01 00:00:00
A | 1 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1
A | 2 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1
B | 1 |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1 |  |  | 1
B | 2 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1
 | Drive Count
 | Total
 | % Driving
Spreadsheet: 772047d1646971846-vba-how-to-automatically-update-data-range-in-a-chart-automatically-update-range
Sheet: Sheet1

 | Start year | 2015
 | End year | 2022
sales | 250 | 220 | 300 | 220 | 340 | 250 | 220 | 200
cost
profits
Spreadsheet: 762461d1641567397-find-and-mark-values-in-another-cell-cf-find-values-aligw
Sheet: Sheet1

keyword | name
gun | vvv rere gun
Satellite | vvv rere tytytyyt
Satellite Phone | ffdf scope gfgfgf
Scope | gfgfgfgf
stun gun | gfgssf satellite phone
stungun | hghghghg
Thermal | ghghgfh767676 satellite
 | ggfggfdfdf
 | [NAME]
 | erere
 | fdfd
 | erere
 | erere
 | 54545454dfdfd
 | stun gfgf
 | Thermal
 | Scope fgfgf
Spreadsheet: 696489d1600853321-cashflow-formula-needed-for-partial-paymen-base-on-date-book2-4-
Sheet: CF

Sponser | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 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
Spreadsheet: 172927d1344369881-too-many-if-statements-causing-my-excel-workbook-to-be-too-large-and-slow-test-new-revenue-summary
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-01 00:00:00
 | RF | CP | JU | MB | CS | BP | Cross | Slim | Natl 3 | Natl 4 | Misc | Sanderfield | Griego | Ejelonu | Block | Fasce | Rivera | [NAME] | Smith | Bloom | [NAME] | Merritt | [NAME] | Pigott | [NAME] | [NAME] | Hively | King | Kyne | [NAME] | Local20 | Local21 | Local22 | Local23 | Local24 | Local25 | Local26 | Total
Spreadsheet: 882401d1730795450-index-for-multiple-criteria-with-multiple-result-sample
Sheet: Data

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Name of Signatories
 |  |  | Name of Signatories |  |  |  |  |  |  |  | Formula Area |  |  | Manager |  | Executive
No | PIC | Date of Detection | Manager | Executiive | AA No. | Name of Borrower | x | Property Location (residential area, town) | Primary / Secondary Market | Agency Name | Region | Branch Code | Branch / SME Zone Name | Name | PF No. Manager | Name | PF No.Exec | Range | [NAME]
187 | Zambrose | 2015-08-27 00:00:00 | Manager 5 | Exec 5 | AA5 | Borrower 5 |  | Niagra | Secondary Market |  | SEL/NS | 62740 | [NAME] | Rozy | 6058 | [NAME] | 56749 | Within 12 months
398 | Zambrose | 2019-07-26 00:00:00 | Manager 1 | Exec 1 | AA 1 | Borrower 1 |  | Location 1 | Primary Market | Testing 1 | SEL/NS | 62740 | [NAME] | Lincon | 10193 | Adam | 130883 | Within 12 months
520 | Zambrose | 2021-03-02 00:00:00 | Manager 4 | Exec 4 | AA 4 | Borrower 4 |  | Niagra | Secondary Market |  | SEL/NS | 62740 | [NAME] | Vincent | 92630 | [NAME] | 135572 | Above 12 months
615 | Zambrose | 2022-08-25 00:00:00 | Manager 3 | Exec 3 | AA 3.1 | Borrower 3.1 |  | Kajang | Secondary Market |  | SEL/NS | 62674 | [NAME] | [NAME] | 20400 | Adam | 91597 | Above 12 months
805 | Zambrose | 2024-09-27 00:00:00 | Manager 2 | Exec 2 | AA 1 | Borrower 2.1 |  | London | Secondary Market | Pending | SEL/NS | 62508 | [NAME] | [NAME] | 980863 | [NAME] binti Shahrulazlar | 135135 | Within 12 months
812 | Zambrose | 2024-10-08 00:00:00 | Manager 2 | Exec 2 | AA 2 | Borrower 2.2 |  | Britain | N/A | A1 | SEL/NS | 62740 | [NAME] | [NAME] | 980863 | [NAME] binti Shahrulazlar | 135135 | Within 12 months
822 | Zambrose | 2024-10-18 00:00:00 | Manager 2 | Exec 2 | AA 3 | Borrower 2.3 |  | Canada | N/A | Pending | SEL/NS | 62508 | [NAME] | [NAME] | 980863 | [NAME] binti Shahrulazlar | 135135 | Within 12 months
X | X | X | x | x | X | X |  | X | X |  | X |  | X | X | X | X | X | X
Spreadsheet: 773884d1648101561-calculate-daily-totals-sample
Sheet: Sheet1

Hotel | Date |  |  |  | Date | Earnings
New York | 2022-01-01 00:00:00 |  |  |  | 2022-01-01 00:00:00 | 6
Chicago | 2022-01-01 00:00:00 |  |  |  | 2022-01-02 00:00:00 | 4
Dallas | 2022-01-01 00:00:00 |  |  |  | 2022-01-03 00:00:00 | 1
New York | 2022-01-02 00:00:00
Dallas | 2022-01-02 00:00:00
Dallas | 2022-01-03 00:00:00
Spreadsheet: 110010d1306821805-how-to-sum-categeory-wise-test_budget
Sheet: Daily_Spendings

Date | Details | Categeory | Amount
2011-01-05 00:00:00 | Petrol Bike | Petrol | 500
2011-01-10 00:00:00 | Gas Car | Gas | 1000
2011-01-15 00:00:00 | Gas Cylender | Gas | 300
2011-01-21 00:00:00 | College Bus | Transportation | 500
2011-02-05 00:00:00 | House Rent | Rent | 4500
Spreadsheet: c732527d-2abd-4f04-8ea5-f77feb1b16ba
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
FBCGG | Test | FBCGG | Bean Coffee Green IgG | Bean Coffee Green IgG | Enzyme Immunoassay (FEIA) | Plain, Red-Top Tube: Red |  |  |  |  | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | <23 mcg/mL   The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.   Test Performed by:	Viracor-IBT Laboratories 			1001 NW Technology Dr. 			Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FBCGG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FBCGG | Result | FBCGG | Bean Coffee Green IgG | Bean Coffee Green IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 848765d1699397853-shift-some-rows-up-then-delete-the-empty-rows-between-data-copy-of-shift-some-rows-up-then-delete-the-empty-rows
Sheet: Sheet1

That What I Have |  |  |  |  |  |  |  |  | That What I Want
# | Invoice Number | Invoice Type | Date | Selling Price | Cost | Discount / Additional | Profit |  | # | Invoice Number | Invoice Type | Date | Selling Price | Cost | Discount / Additional | Profit
1 | 5537 | POS1 | 2023-11-01 00:00:00 | 6 | 3.248 | 0 | 2.752 |  | 1 | 5537 | POS1 | 2023-11-01 00:00:00 | 6 | 3.248 | 0 | 2.752
3 | 5538 | POS1 | 2023-11-01 00:00:00 | 10 | 5.6 | 0 | 4.4 |  | 4 | 5538 | POS1 | 2023-11-01 00:00:00 | 10 | 5.6 | 0 | 4.4
4 | 5539 | POS1 | 2023-11-01 00:00:00 | 5 | 2.681 | 0 | 2.319 |  | 8 | 5539 | POS1 | 2023-11-01 00:00:00 | 5 | 2.681 | 0 | 2.319
7 | 5540 | POS2 | 2023-11-01 00:00:00 | 5 | 2.352 | 0 | 2.648 |  | 12 | 5540 | POS2 | 2023-11-01 00:00:00 | 5 | 2.352 | 0 | 2.648
8 | 5541 | POS2 | 2023-11-01 00:00:00 | 8 | 4.093 | 0 | 3.907 |  | 15 | 5541 | POS2 | 2023-11-01 00:00:00 | 8 | 4.093 | 0 | 3.907
11 | 5542 | POS2 | 2023-11-01 00:00:00 | 3 | 1.505 | 0 | 1.495 |  | 19 | 5542 | POS2 | 2023-11-01 00:00:00 | 3 | 1.505 | 0 | 1.495
12 | 5543 | POS1 | 2023-11-01 00:00:00 | 2.5 | 1.176 | 0 | 1.324 |  | 22 | 5543 | POS1 | 2023-11-01 00:00:00 | 2.5 | 1.176 | 0 | 1.324
14
15
18
19
21
22
24
Spreadsheet: 208491d1358849539-simple-sum-statement-or-is-it-more-pivot
Sheet: Sheet1

Column1 | Column2 |  |  | Row Labels | Sum of Column2
A | 1 |  |  | A | 17
A | 9 |  |  | B | 16
A | 7 |  |  | C | 24
B | 2 |  |  | D | 21
B | 1 |  |  | Grand Total | 78
B | 5
B | 8
C | 9
C | 5
C | 4
C | 6
D | 3
D | 7
D | 4
D | 4
D | 3