tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 763923d1642457390-dax-question-summing-a-value-field-for-each-unique-identifier-field-test-data
Sheet: Sheet1

 | Input |  |  |  |  |  |  |  | Expected Output
 | SKU | SKU Description | Element Data | Source Name | Portion | Element Quantity |  |  | SKU | SKU Description | Portion | Element Quantity
 | SKU1000 | Choco Loco | [PHONE]/[NAME]* | X100 | 200 | 22000 |  |  | SKU1000 | Choco Loco
 | SKU1000 | Choco Loco | [PHONE]/[NAME]* | X100 | 350 | 22000 |  |  | SKU2000 | [NAME]
 | SKU1000 | Choco Loco | [PHONE]/STCK* | X100 | 850 | 41000
 | SKU1000 | Choco Loco | [PHONE]/STCK* | X200 | 300 | 41000
 | SKU1000 | Choco Loco | [PHONE]/STCK* | X200 | 800 | 41000
 | SKU1000 | Choco Loco | [PHONE]/STCK* | X300 | 650 | 41000 |  |  | Output
 | SKU1000 | Choco Loco | [PHONE]/[NAME]* | X300 | 800 | 30000 |  |  | SKU | SKU Description | Sum of Portion | DAX Field Here for "Element Quantity"
 | SKU1000 | Choco Loco | [PHONE]/[NAME]* | X400 | 250 | 30000 |  |  | SKU1000 | Choco Loco | 4800 | 109000
 | SKU1000 | Choco Loco | [PHONE]/[NAME]* | X400 | 150 | 30000 |  |  | SKU2000 | [NAME] | 800 | 180000
 | SKU1000 | Choco Loco | [PHONE]/[NAME] | X500 | 450 | 16000 |  |  | Grand Total |  | 5600
 | SKU2000 | [NAME] | [PHONE]/STCK* | X100 | 50 | 80000
 | SKU2000 | [NAME] | [PHONE]/STCK* | X200 | 150 | 80000
 | SKU2000 | [NAME] | [PHONE]/ZI01 | X300 | 300 | 100000
 | SKU2000 | [NAME] | [PHONE]/ZI01 | X100 | 100 | 100000
 | SKU2000 | [NAME] | [PHONE]/ZI01 | X100 | 200 | 100000
Spreadsheet: 124550d1318455106-excel-2007-invoice-data-lookup-order-template-wip
Sheet: BodyCare

Body Care
[NAME] | 2 in 1 Body Wash & Shave Gel | 14 | [NAME]
[NAME] | Hydrating Lotion | 14
[NAME] | [NAME] for feet and legs | 10
[NAME] | Limited Edition Pedicure Set | 22
Eau de Toilette Shower Gel | Limited Edition Deluxe Pedicure Set | 46
Eau de Toilette Sugar Scrub | [NAME] | 34 | [NAME]
 | Peach | 34
 | [NAME] | 10 | [NAME]
 | Peach | 10
 | Exotic Passionfruit | 15 | [NAME]
 | [NAME] | 15
 | Simply Cotton | 15
 | Warm Amber | 15
 | Exotic Passionfruit | 15 | Eau de Toilette Shower Gel
 | [NAME] | 15
 | Simply Cotton | 15
 | Warm Amber | 15
 | Exotic Passionfruit | 15 | Eau de Toilette Sugar Scrub
 | [NAME] | 15
 | Simply Cotton | 15
 | Warm Amber | 15
Spreadsheet: 0741b571-4047-44f4-b12d-50602b8ca216
Sheet: Sheet1

Winners Bracket | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | Spartans
 | 8:30   F9
 | (2
 | IDK
 |  | (15
 | WMD Elite | 1:20   F10
 | 8:30   F10
 | (3
 | Showtime |  |  |  |  | 17 TEAMS
 |  |  | (23
 | Unleashed |  | 4:50   F9 |  |  | UE
 | 9:45   F8 |  |  |  |  | BIG  10  SERIES
 | (4 |  |  |  |  | DOUBLE POINTS
 | Diamondbacks
 |  | (16
 | Nouveau | 2:30   F8
 | 9:45   F9
 | (5
 | P Rods
 |  |  |  | (29
 | [NAME] |  |  | 8:20   F8
 | 9:45   F10
 | (6
 | Hammerface
Legit |  | (17
8:30   F8 |  | 2:30   F9
(1 | 11:00  F8
CCD | (9
 | RTS
 |  |  | (24
 | Woodstock Merchants |  | 4:50   [NAME]
 | 11:00   F9
 | (7
 | NWF |  |  |  |  |  | (32
 |  | (18 |  |  |  |  | 10:30  F10
 | Players Only | 2:30   F10
 | 11:00   F10
 | (8
 | Southland
 | Loser's | Bracket |  |  |  | [NAME]
 | L-9 |  |  | L-23
[NAME] | 1:20   F8
12:10   F8 | (14 | 4:50   F8 |  | 7:10   F8
(10 |  | (22 |  | (27 |  | (31 |  | (33
L-2 |  | L-18 |  |  |  | 09:30:00
 | L-4 |  | (25 |  |  | [NAME] |  | 11:30:00
 | 12:10   F9 |  | 6:00   F8 |  |  |  |  | F10
 | (11 | 3:40  F9 |  |  |  |  |  | IF  GAME
 | [NAME] | (21 |  |  | (30
 |  | L-17 |  |  | 8:20   F10
 | L-6 |  |  | L-24
 | 12:10   F10
 | (12 | 3:40  F8 |  | 7:10   F10
 | L-1 | (20 |  | (28
 |  | [NAME]
 | L-7 |  | (26
 | 1:20   F9 |  | 6:00   F10 |  |  |  |  | L-32
 | (13 | 3:40  F10
 | L-8 | (19
 |  | L-15
Spreadsheet: 865169d1712226288-conditional-formatting-of-partial-rows-formatting1-ans
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sick |  | Range applied |  | $B$3:$N$1000
 | gang 1 |  |  |  |  |  |  | gang 2 |  |  |  |  |  |  | Other
 | name | date | start | finish | rate | total |  | name | date | start | finish | rate | total |  | Test |  | for p1 | =OR(AND(COLUMN(B3)>=COLUMN($B3),COLUMN(B3)<=COLUMN($G3),$F3=$P$1),AND(COLUMN(B3)>=COLUMN($I3),COLUMN(B3)<=COLUMN($N3),$M3=$P$1))
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | for P2 | =OR(AND(COLUMN(B3)>=COLUMN($B3),COLUMN(B3)<=COLUMN($G3),$F3=$P$2),AND(COLUMN(B3)>=COLUMN($I3),COLUMN(B3)<=COLUMN($N3),$M3=$P$2))
 | bob | 2024-03-31 00:00:00 |  |  | sick |  |  | gary | 2024-03-31 00:00:00 |  |  |  |  |  |  |  | for P3 | =OR(AND(COLUMN(B3)>=COLUMN($B3),COLUMN(B3)<=COLUMN($G3),$F3=$P$3),AND(COLUMN(B3)>=COLUMN($I3),COLUMN(B3)<=COLUMN($N3),$M3=$P$3))
 | [NAME] | 2024-03-31 00:00:00 |  |  |  |  |  | [NAME] | 2024-03-31 00:00:00 |  |  | Sick
 | [NAME] | 2024-03-31 00:00:00 |  |  | other |  |  | grant | 2024-03-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] and apply formulas.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Adjust range applies to.
 | gang 1 |  |  |  |  |  |  | gang 2
 | name | date | start | finish | rate | total |  | name | date | start | finish | rate | total
 | bob | 2024-03-31 00:00:00 |  |  |  |  |  | gary | 2024-03-31 00:00:00 |  |  | test
 | [NAME] | 2024-03-31 00:00:00 |  |  |  |  |  | [NAME] | 2024-03-31 00:00:00 |  |  | other
 | [NAME] | 2024-03-31 00:00:00 |  |  | test |  |  | grant | 2024-03-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | test
Spreadsheet: 044aa192-1a62-484e-96c0-6ec346c93213
Sheet: PAG 9 - Table 1

CSD&Nanc Brazil results |  |  | Currency Translation | Organic Growth |  | % As | %
R$ million | 3Q10 | Scope |  |  | 3Q11 | Reported | Organic
Volume ('000 hl) | 6950.196751987385 | 0 | 0 | 441.4987580435209 | 7391.695510030906 | 0.06352320283843405 | 0.06352320283843414
Net revenue | 675.4820000000001 | 0 | 0 | 51.89699999999993 | 727.379 | 0.07682958243150817 | 0.07682958243150806
Net revenue/hl | 97.1889032935432 | 0 | 0 | 1.215988928127672 | 98.40489222167089 | 0.01251160252786265 | 0.01251160252786242
[NAME] | -299.184 | -6.572000000000001 | 0 | -11.74799999999999 | -317.504 | 0.06123322102786233 | 0.03926680571153535
[NAME]/hl | -43.0468389135098 | -0.945584741629176 | 0 | 1.038273342922942 | -42.95415031221604 | -0.002153203432196049 | -0.02411961874852303
Gross profit | 376.2980000000001 | -6.572000000000001 | 0 | 40.14899999999994 | 409.8750000000001 | 0.08922981254218709 | 0.1066946940988257
Gross margin | 0.5570807216180447 | 0 | 0 | 0 | 0.563495784178537 | 60 | 150
SG&A excl. deprec.&amort. | -124.756 | 0 | 0 | -19.43299999999996 | -144.189 | 0.155768059251659 | 0.155768059251659
SG&A deprec.&amort. | -24.726 | -2.328 | 0 | 1.632000000000002 | -25.422 | 0.02814850764377574 | -0.06600339723368123
SG&A total | -149.482 | -2.328 | 0 | -17.80099999999996 | -169.611 | 0.1346583535141352 | 0.1190845720554981
Other operating income | 34.47 | 0 | 0 | 3.073000000000008 | 37.54300000000001 | 0.08914998549463315 | 0.08914998549463324
Normalized EBIT | 261.2860000000001 | -8.900000000000002 | 0 | 25.42099999999999 | 277.8070000000001 | 0.06322956453847506 | 0.0972918564331804
Normalized EBIT margin | 0.3868141564097934 | 0 | 0 | 0 | 0.381928815651813 | -50 | 70
Normalized EBITDA | 312.3439999999999 | 0 | 0 | 19.13600000000019 | 331.4800000000001 | 0.06126578387931314 | 0.06126578387931319
Normalized EBITDA margin | 0.4624016628126285 | 0 | 0 | 0 | 0.4557184081476096 | -70 | -70
Spreadsheet: 0620635e-b1aa-449c-a703-d635df42f29a
Sheet: options

Options
Please select a calculation option.
I would like Excess Cost  for my district to be calculated on a per capita basis.
I would like Excess Cost for my district to be calculated on an individual student basis.
Disability Type
Please select a disability condition.
Category 1. Speech and Language Impairments  (Disability condition 05)
Category 2. Specific Learning Disabilities  (Disability condition 10)
Category 2. Cognitive Disabilities (formerly [NAME]) (Disability condition 09)
Category 2. Other health impairment, minor (Disability condition 15)
Category 3. Deafness (Hearing Impairment) (Disability condition 03)
Category 3. Visual Impairments (Disability condition 04)
Category 3. Emotional Disturbance (SBH)  (Disability condition 08)
Category 4. Orthopedic Impairments (Disability condition 06)
Category 4. Other health impairment, major (Disability condition 14)
Category 5. Multiple Disabilities (other than Deaf-Blind)  (Disability condition 01)
Category 6. Deaf-Blindness (Disability condition 02)
Category 6. Autism  (Disability condition 12)
Category 6. Traumatic Brain Injury (TBI)  (Disability condition 13)
Placement
Please select a placement explanation.
Insitution, non-court ordered (How Received Code=T)
Foster care or placed by court with a relative (How Received Code=C)
ALL court ordered institutional placements other than foster care (How Received Code=P)
Non-resident – Attending under Title I Public School Choice (How Received Code=W)
Inter-District Open Enrollment (How Received Code=9)
Non-resident student attending special ed program (including coop) (How Received Code=B)
Spreadsheet: 860406d1708513394-splitting-names-in-a-cell-and-take-corresponding-values-testbook
Sheet: data

Site | Year | Month | Quarter | Total Stories
Green | 2022 | Jan | Q1 | 1539
Green | 2022 | Feb | Q1 | 1333
Green | 2022 | Mar | Q1 | 1516
Green | 2022 | Apr | Q2 | 1509
Green | 2022 | May | Q2 | 1578
Green | 2022 | Jun | Q2 | 1474
Green | 2022 | Jul | Q3 | 1434
Green | 2022 | Aug | Q3 | 1515
Green | 2022 | Sep | Q3 | 1457
Green | 2022 | Oct | Q4 | 1473
Green | 2022 | Nov | Q4 | 1450
Green | 2022 | Dec | Q4 | 1489
Green | 2023 | Jan | Q1 | 1501
Green | 2023 | Feb | Q1 | 1423
Green | 2023 | Mar | Q1 | 1531
Green | 2023 | Apr | Q2 | 1448
Green | 2023 | May | Q2 | 1462
Green | 2023 | Jun | Q2 | 1472
Green | 2023 | Jul | Q3 | 1393
Green | 2023 | Aug | Q3 | 1403
Green | 2023 | Sep | Q3 | 1359
Green | 2023 | Oct | Q4 | 1219
Green | 2023 | Nov | Q4 | 1195
Green | 2023 | Dec | Q4 | 1201
Blue | 2022 | Jan | Q1 | 2220
Blue | 2022 | Feb | Q1 | 2215
Blue | 2022 | Mar | Q1 | 2572
Blue | 2022 | Apr | Q2 | 2295
Blue | 2022 | May | Q2 | 2152
Blue | 2022 | Jun | Q2 | 2005
Blue | 2022 | Jul | Q3 | 1887
Blue | 2022 | Aug | Q3 | 1910
Blue | 2022 | Sep | Q3 | 1938
Blue | 2022 | Oct | Q4 | 2128
Blue | 2022 | Nov | Q4 | 2028
Blue | 2022 | Dec | Q4 | 2018
Blue | 2023 | Jan | Q1 | 2076
Blue | 2023 | Feb | Q1 | 1370
Blue | 2023 | Mar | Q1 | 1214
Blue | 2023 | Apr | Q2 | 1303
Blue | 2023 | May | Q2 | 1276
Blue | 2023 | Jun | Q2 | 1404
Blue | 2023 | Jul | Q3 | 1418
Blue | 2023 | Aug | Q3 | 1269
Blue | 2023 | Sep | Q3 | 1153
Blue | 2023 | Oct | Q4 | 1359
Blue | 2023 | Nov | Q4 | 1380
Blue | 2023 | Dec | Q4 | 1555
Red | 2022 | Jan | Q1 | 615
Red | 2022 | Feb | Q1 | 561
Red | 2022 | Mar | Q1 | 564
Red | 2022 | Apr | Q2 | 567
Red | 2022 | May | Q2 | 559
Red | 2022 | Jun | Q2 | 558
Red | 2022 | Jul | Q3 | 603
Red | 2022 | Aug | Q3 | 604
Red | 2022 | Sep | Q3 | 613
Red | 2022 | Oct | Q4 | 553
Red | 2022 | Nov | Q4 | 540
Red | 2022 | Dec | Q4 | 557
Red | 2023 | Jan | Q1 | 561
Red | 2023 | Feb | Q1 | 505
Red | 2023 | Mar | Q1 | 547
Red | 2023 | Apr | Q2 | 461
Red | 2023 | May | Q2 | 500
Red | 2023 | Jun | Q2 | 526
Red | 2023 | Jul | Q3 | 515
Red | 2023 | Aug | Q3 | 534
Red | 2023 | Sep | Q3 | 519
Red | 2023 | Oct | Q4 | 498
Red | 2023 | Nov | Q4 | 481
Red | 2023 | Dec | Q4 | 522
Spreadsheet: 40197d1238513274-list-book1_mar31
Sheet: Sheet1

 | Helper |  | Count | Pivot Points
1 |  |  | 3 | 6
2 |  |  |  | 0
3 |  |  |  | 5
4
5
6 | 6
4
2
1
0 | 0
3
4
5 | 5
Spreadsheet: 46097d1244936835-percentages-grouping
Sheet: Sheet1

AABB | AABb | AaBB | AaBb | AABb | 0.125 |  | method 1
AABb | AAbb | AaBb | [NAME] | AABB | 0.0625 |  | combines values from lower grid to make top one |  |  | #N/A
AaBB | AaBb | aaBB | aaBb | aabb | 0.0625
AaBb | [NAME] | aaBb | aabb | aaBb | 0.125
 |  |  |  | aaBB | 0.0625
 |  |  |  | [NAME] | 0.125
 |  |  |  | AAbb | 0.0625
 |  |  |  | AaBB | 0.125
 |  |  |  | AaBb | 0.25
 |  |  |  |  |  |  |  | method 2 uses existing grid
 |  |  |  |  |  |  |  | yellow area cannot contain any values from grid or formula refering to grid
AA | BB | AA | Bb | Aa | BB | Aa | Bb |  | AA | Bb | 0.125
AA | Bb | AA | bb | Aa | Bb | Aa | bb |  | AA | BB | 0.0625
Aa | BB | Aa | Bb | aa | BB | aa | Bb |  | aa | bb | 0.0625
Aa | Bb | Aa | bb | aa | Bb | aa | bb |  | aa | Bb | 0.125
 |  |  |  |  |  |  |  |  | aa | BB | 0.0625
 |  |  |  |  |  |  |  |  | Aa | bb | 0.125
 |  |  |  |  |  |  |  |  | AA | bb | 0.0625
 |  |  |  |  |  |  |  |  | Aa | BB | 0.125
 |  |  |  |  |  |  |  |  | Aa | Bb | 0.25
Spreadsheet: 0ebfdf86-d435-4ad6-902d-89382d9d0325
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
OYST | Test | OYST | Oyster, IgE | Oyster, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in 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
OYST | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
OYST | Result | OYST | Oyster, IgE | Oyster, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 7558-0 | Ostrea edulis [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 5585a5de-b59d-4fdc-8bcc-04abd0506c58
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Name | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  | Learner ID
 |  |  |  | School/College/University
Agriculture, Food and Natural Resources: Environmental Service Systems
Career Pathway Plan of Study for ►Learners ►Parents ►Counselors ►Teachers/Faculty
This Career Pathway Plan of Study (based on the Environmental Service Systems Pathway of the Agriculture, Food and Natural Resources Career Cluster) can serve as a guide, along with other career planning materials, as learners continue on a career path. Courses listed within this plan are only recommended coursework and should be individualized to meet each learner’s educational and career goals. *This Plan of Study, used for learners at an educational institution, should be customized with course titles and appropriate high school graduation requirements as well as college entrance requirements.
EDUCATION | LEVELS | GRADE | [NAME] | Math | Science | Social Studies/ Sciences | Other Required Courses Other Electives Recommended       Electives                         Learner Activities | *Career and Technical Courses                    and/ or Degree Major Courses for               Environmental Service Systems Pathway | SAMPLE                                   Occupations Relating                            to This Pathway
 |  | Interest Inventory Administered and Plan of Study Initiated for all Learners
[NAME] |  | 9 |  |  |  |  |  |  | Occupations Requiring Postsecondary Education ►Environmental Compliance -                   .   Assurance Manager ►Environmental Sampling and                  .   Analysis Scientist/Technician ►Hazardous Materials Handler ►Hazardous Materials Technician ►Health and Safety Sanitarian ►Pollution Prevention and Control             .   Technician ►Recycler ►[NAME]                                                    .                                                      Occupations Requiring Baccalaureate Degree ►Agricultural Educator ►Chemical Engineer ►Environmental Engineer ►Pollution Prevention and Control                  .   Manager ►Solid Waste Manager ►Toxicologist ►Water Environment Manager ►Water Quality Manager
 |  | 10
 |  | 11
 |  | College Placement Assessments-Academic/Career Advisement Provided
 |  | 12
 |  | Articulation/Dual Credit Transcripted-Postsecondary courses may be taken/moved to the secondary level for articulation/dual credit purposes.
POSTSECONDARY |  | Year 13
 |  | Year14
 |  | Year 15
 |  | Year 16
 |  |  |  |  |  | Project funded by the U.S. Department of Education (VO51B020001)
Spreadsheet: 83159d1283205787-sorting-rows-and-moving-columns-in-a-locked-sheet-alloy
Sheet: Titainium

Serial Number | Grade | Al | C | Cr | Cu | Fe | H | Mn | Mo | N | Nb | Ni | O | S | Si | Sn | V | W | Zr
174a | Ti. CP-4 | 0.013 | 0.009 | (<0.01) | (<0.01) | 0.15 | 0.0057 | (<0.01) | (<0.01) | 0.0089 |  |  | 0.3 |  | (<0.01) | (<0.01) |  |  | (<0.01)
 |  | -0.0044 |  |  |  | -0.006 | -0.0007 |  |  | -0.0016 |  |  | -0.025
175b | Ti 6-4 | 6.16 | 0.031 | 0.003 | 0.002 | 0.153 | 0.008 | 0.001 | 0.004 | 0.006 |  | 0.002 | 0.165 | <0.003 | 0.011 | 0.019 | 4
 |  | -0.04 | -0.001 | -0.001 | -0.001 | -0.003 | -0.002 | -0.0005 | -0.001 | -0.001 |  | -0.001 | -0.004 |  | -0.002 | -0.002 | -0.03
177b | Ti 6.2.4.2 | 6.04 | 0.008 | <0.005 | 0.005 | 0.031 | 0.014 | -0.001 | 1.93 | 0.0033 |  | 0.003 | 0.098 |  | 0.083 | 1.95 | 0.006
 |  | -0.02 | -0.001 |  | -0.002 | -0.002 | -0.001 |  | -0.02 | -0.0006 |  | -0.001 | -0.003 |  | -0.002 | -0.02 | -0.001
178b | Ti 6-6-2 | 5.58 | 0.03 | 0.015 | 0.51 | 0.56 | 0.0028 | 0.003 | 0.008 | 0.008 |  | 0.017 | 0.157 | -0.001 | 0.025 | 2 | 5.56 |  | 0.004
 |  | -0.03 | -0.001 | -0.001 | -0.01 | -0.01 | -0.0002 | -0.001 | -0.001 | -0.0005 |  | -0.001 | -0.001 |  | -0.002 | -0.02 | -0.03 |  | -0.001
269a | Ti 8-1-1 | 7.79 | 0.015 | 0.01 | 0.003 | 0.133 | 0.0059 | -0.001 | 1.02 | 0.0039 | <0.005 | 0.01 | 0.104 | -0.002 | 0.08 | -0.01 | 1 |  | 0.001
 |  | -0.03 | -0.002 | -0.001 | -0.001 | -0.002 | -0.0002 |  | -0.02 | -0.0005 |  | -0.002 | -0.003 |  | -0.004 |  | -0.02 |  | -0.0004
Spreadsheet: c5547ffa-0b3e-4356-bea1-bdf6de9b6c4c
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6522 | 30174 | Martina | Donner | AUT | 140 | 00:19:52 | 00:00:58 | 01:18:45 | 00:00:41 | 00:44:32 | 1 | 02:24:52
6522 | 50316 | Hana | Bergh | AUT | 139 | 00:26:00 | 00:00:43 | 01:31:09 | 00:00:54 | 00:47:48 | 2 | 02:46:39
Spreadsheet: 223320d1364162606-file-size-swells-after-macro-function-fileforsubtotals
Sheet: Auxiliar

These are 17 rows sorted by account, or column B
Date | Code Number | Description | Debit | Credit
2013-02-01 00:00:00 | Capital | Paid to firm | 4000
2013-02-11 00:00:00 | Bank-2 | From bank 1 to  bank 2 | 150
2013-02-01 00:00:00 | Bank-1 | [NAME] | 778.32
2013-02-01 00:00:00 | Bank-1 | [NAME] | 722.13
2013-02-01 00:00:00 | Bank-1 | [NAME] | 722.13
2013-02-01 00:00:00 | Bank-1 | For extra work | 300
2013-02-01 00:00:00 | Bank-1 | Paid to firm |  | 4000
2013-02-05 00:00:00 | Bank-1 | [NAME] G23345 |  | 103.57
2013-02-09 00:00:00 | Bank-1 | [NAME] |  | 4.9
2013-02-11 00:00:00 | Bank-1 | [NAME] |  | 150
2013-02-05 00:00:00 | Food | [NAME] G23345 | 103.57
2013-02-09 00:00:00 | Food | [NAME] | 4.9
2013-02-11 00:00:00 | Medics | [NAME] | 16.5
2013-02-01 00:00:00 | Salaries | [NAME] |  | 778.32
2013-02-01 00:00:00 | Salaries | [NAME] |  | 722.13
2013-02-01 00:00:00 | Salaries | [NAME] |  | 722.13
2013-02-01 00:00:00 | Services | For extra work |  | 300
And here, the same after the function DATA/SUBTOTALS, finding
and showing the totals of all the rows with the same account
Date | Code Number | Description | Debit | Credit |  | And the trouble is that  sometimes at this stage the file increases its size  3 or more times  what it was before this step. The unwanted material does not appear anywhere
2013-02-01 00:00:00 | 11800 | Paid to firm | 4000
 | Total 11800 |  | 4000 | 0
2013-02-11 00:00:00 | Bank-2 | From bank 1 to  bank 2 | 150
 | Total 57000 |  | 150 | 0
2013-02-01 00:00:00 | Bank-1 | [NAME] | 778.32
2013-02-01 00:00:00 | Bank-1 | [NAME] | 722.13
2013-02-01 00:00:00 | Bank-1 | [NAME] | 722.13
2013-02-01 00:00:00 | Bank-1 | For extra work | 300
2013-02-01 00:00:00 | Bank-1 | Paid to firm |  | 4000
2013-02-05 00:00:00 | Bank-1 | [NAME] G23345 |  | 103.57
2013-02-09 00:00:00 | Bank-1 | [NAME] |  | 4.9
2013-02-11 00:00:00 | Bank-1 | [NAME] |  | 150
 | Total 57201 |  | 2522.58 | 4274.969999999999
2013-02-05 00:00:00 | Food | [NAME] G23345 | 103.57
2013-02-09 00:00:00 | Food | [NAME] | 4.9
 | Total 60101 |  | 108.47 | 0
2013-02-11 00:00:00 | Medics | [NAME] | 16.5
 | Total 60251 |  | 16.5 | 0
2013-02-01 00:00:00 | Salaries | [NAME] |  | 778.32
2013-02-01 00:00:00 | Salaries | [NAME] |  | 722.13
2013-02-01 00:00:00 | Salaries | [NAME] |  | 722.13
 | Total 70500 |  | 0 | 2222.58
2013-02-01 00:00:00 | Services | For extra work |  | 300
 | Total 70505 |  | 0 | 300
 | Total general |  | 6797.549999999999 | 6797.549999999999
Spreadsheet: 46150d1245055660-if-or-lookup-to-return-different-value-book2
Sheet: Sheet1

Employeee Type | [NAME] | Hours Worked | Total Cost
Site Specialist |  | 5 | 0
Sales Rep. |  | 8 | 0
Sales Rep. |  | 7 | 0
Engineer |  | 12 | 0
Sales Rep. |  | 23 | 0
Sales Manager |  | 432 | 0
Engineer |  | 45 | 0
Consultant |  | 76 | 0
Site Specialist |  | 45 | 0
Site Specialist |  | 23 | 0
Engineer |  | 23 | 0
Site Specialist |  | 54 | 0
Site Specialist |  | 67 | 0
Site Specialist |  | 356 | 0
Technician |  | 67 | 0
Site Specialist |  | 5 | 0
Sales Rep. |  | 8 | 0
Sales Rep. |  | 7 | 0
Engineer |  | 12 | 0
Sales Rep. |  | 23 | 0
Sales Manager |  | 432 | 0
Engineer |  | 45 | 0
Consultant |  | 76 | 0
Site Specialist |  | 45 | 0
Site Specialist |  | 23 | 0
Engineer |  | 23 | 0
Site Specialist |  | 54 | 0
Site Specialist |  | 67 | 0
Site Specialist |  | 356 | 0
Technician |  | 67 | 0
Spreadsheet: 853658d1703583765-search-from-two-sheet-two-different-column-in-two-seach-box-search_revised_hans
Sheet: Sheet2

CNT | TGNo | RTO | Date | Category | [NAME] | Party Name | Item Name | Process | Person | J S (From) | J S (To) | JRT(From) | JRT(To) | SW (cmr) | TW(|Pound) | 1st Sub | W1 | FM1 | MSG | aa | ab | 1st Sub IN | 2nd Sub | [NAME] | FM2 | MSG | aa | ab | 2nd Sub IN | ac | ad | Oqty | #RLS | ai | aj | al | am | aam | atj | hue | [NAME] | dc | BAM | BL | LBAL | XE | ITC | IT | YTQ | LAB | CodeM | TC | OCT | LAB | ?SC | Code
 | DAC-X/4 |  | 2023-09-12 00:00:00 | MCX-2 | TC-44 | Indian Jones | Avatar | XAB | [NAME] |  |  |  |  |  |  | DLC | 636 | 25 | 63 |  |  | 456 | 256 |  |  |  |  |  |  |  |  | 636 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6356
 | MC-34/36 |  | 2023-09-13 00:00:00 | MCX-3 | AB/663 | Microsoft Corp | Lumia | DAC | [NAME] |  |  |  |  |  |  | MSC | 36 | 19 | 63 |  |  | 776 | 36 |  |  |  |  |  | LD-45 |  |  | 75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9423
 | TC-46/6 |  | 2023-09-13 00:00:00 | DCV-25 | A/658 | Apple Inc | Apple 13 | MAC | Hapkins |  |  |  |  |  |  | POS | 44 | 12 | 1 |  |  | 684 | 44 |  |  |  |  |  | MS6 |  |  | 336 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 462
 | AB-463/8 |  | 2023-09-13 00:00:00 | DC-14 | J-44 | Edward Co. Pvt | [NAME] | STIGMA | Tabla |  |  |  |  |  |  | CCS | 96 | 40 | 2 |  |  | 634 | 63 |  |  |  |  |  | PET |  |  | 124 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 142
 | MC-test-36 |  | 2023-09-13 00:00:00 | MAX-12 | LS-63 | Google | [NAME] | MA-C | JAS |  |  |  |  |  |  | MSCX | 102 | 35 | 3 |  |  |  | 634 |  |  |  |  |  | POLY |  |  | 63 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 63
 | TC-46/6 |  | 2023-09-14 00:00:00 | DCV-25 | A/658 | Apple | Iphone 16 | LAS | [NAME] |  |  |  |  |  |  | MC | 26 | 736 | 1 |  |  | 256 | 12 |  |  |  |  |  | MET |  |  | 4123 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 216