tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1dc8591a-6fb5-44f0-bd83-51d406b9fd03
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42793055 | 2014-08-19 19:07:27 | AXIS | 1 | 6 | 4 | 27494 | pattonou | 8708 | western | 1944-07-25 | 1944-07-25 | Operation Spring | Opération Spring
42793261 | 2014-08-19 19:22:10 | ALLIES | 0 | 5 | 6 | 27494 | pattonou | 8708 | western | 1944-07-25 | 1944-07-25 | Operation Spring | Opération Spring
Spreadsheet: 268790d1380826905-sumproduct-formula-working-on-all-but-one-worksheet-2012-inpt-mb
Sheet: Oct

October |  |  |  |  |  |  | 10
Expenses | Total Expenses HTG | Total Expenses USD | Inpatient Total HTG | Inpatient Total USD | Outpatient Total HTG | Outpatient Total USD
bongu/juice
formula
patient food
medical supplies
medical services
medication
x-ray
office supplies
photocopy
other transportation
outpatient nurse for injections
employee compensation
school
other expenses
phone list
physical phone
telephone minutes
oxygen
volunteer expenses
patient transportation
Spreadsheet: 118566d1313760156-excel-2007-how-do-i-remove-empty-cells-in-a-range-team-creator-v3
Sheet: Rerolls

 | 5
 | 6
 | 7
 | 5
 | 5
 | 5
 | 6
 | 6
 | 5
 | 5
 | 7
 | 6
 | 7
 | 6
 | 7
 | 7
 | 6
 | 6
 | 7
 | 7
 | 5
 | 7
 | 7
 | 7
 | 7
 | 5
 | 7
 | 7
 | 7
 | 6
Spreadsheet: 798757d1664709781-combination-of-rows-of-data-with-condition-iteme-etaf
Sheet: Sheet1

Code | Title |  | Result Expected
1 | A |  | A-B-C
1 | B |  | A-B-C
1 | C |  | A-B-C
2 | D |  | D-E
2 | E |  | D-E
3 | F |  | F
Spreadsheet: 91634d1291307758-comparing-difference-between-two-columns-compare
Sheet: Sheet1

Column A | Column B | Result should be
A | B | R
B | C | W
C | D | Z
D | E | X
E | F | R
F | F
G | F
A | F
B | R
C | W
D | Z
E | X
F | R
G | A
Spreadsheet: 678753d1590050260-sum-range-across-worksheet-with-transposition-test-sum-range-across-worksheet
Sheet: Sheet1

 | 292 | 297 | 722 | 818 | 167 | 765 | 384 | 195 | 53 | 923 | 664
 | 170 | 660 | 566 | 707 | 79 | 305 | 53 | 404 | 926 | 417 | 663
 | 298 | 61 | 61 | 806 | 518 | 650 | 861 | 41 | 743 | 164 | 949
 | 476 | 563 | 408 | 550 | 457 | 137 | 624 | 466 | 662 | 94 | 539
 | 802 | 529 | 642 | 675 | 654 | 949 | 545 | 459 | 278 | 652 | 937
 | 476 | 188 | 483 | 881 | 286 | 392 | 281 | 490 | 534 | 88 | 655
 | 38 | 242 | 196 | 477 | 199 | 666 | 313 | 53 | 774 | 134 | 214
 | 275 | 882 | 655 | 288 | 928 | 33 | 731 | 681 | 539 | 65 | 843
 | 842 | 549 | 235 | 657 | 691 | 373 | 68 | 818 | 286 | 173 | 560
 | 945 | 264 | 716 | 81 | 502 | 852 | 112 | 164 | 919 | 682 | 227
 | 914 | 581 | 95 | 226 | 177 | 948 | 262 | 845 | 555 | 951 | 350
 | 970 | 285 | 115 | 634 | 708 | 98 | 944 | 452 | 470 | 999 | 875
 | 343 | 171 | 206 | 55 | 148 | 806 | 872 | 571 | 817 | 505 | 482
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: Research1

 | Research
 | 2002 Plan
 |  | 2001-09-01 00:00:00 |  | 2001 | 2002 |  |  |  | Per HC | New HC | Adj Comp |  |  | 2002
 |  | YTD Actual |  | Forecast | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation
 | Analysts & Associates | 0
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense |  |  |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services |  |  |  |  |  |  | Total |  |  |  |  | 1699109
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME]
ENARENT | Rent |  |  |  |  |  |  | Admins | 48000 | 0
ENATECH | Technology |  |  |  |  |  |  | Staff | 49200 | 0
ENATRANS | Transportation |  |  |  |  |  |  | Analysts | 57600 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Associate | 72000 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Specialist | 62400 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Sr Specialst | 74400 | 1
 |  |  |  |  |  |  |  | Managers | 90000 | 1
 | Headcount |  |  | 44 |  |  |  | Directors | 120000 | 1
 |  |  |  |  |  |  |  | Sr Director | 178800 | 0
 | Analysts & Associate Headcount |  |  | 5 | 0 |  |  | Vice President | 216000 | 0
 |  |  |  |  |  |  |  | [NAME] | 312000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | Outside Legal |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses |  |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization
 |  |  |  |  |  | Total Misc Exp |  | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 840419d1692717386-having-issues-with-calculating-dates-days-test
Sheet: Sheet1

 | Start date | End date | Type of leave | Days
 | 2021-10-01 00:00:00 | 2021-10-01 00:00:00 | Vacation |  |  | Correct
 | 2021-10-02 00:00:00 | 2021-10-02 00:00:00 | Vacation |  |  | Wrong = 1
 | 2021-09-02 00:00:00 | 2021-09-02 00:00:00 | Half Day |  |  | Wrong = 0.5
 | 2021-09-01 00:00:00 | 2021-09-01 00:00:00 | Half Day |  |  | Wrong = 0.5
 | 2021-08-04 00:00:00 | 2021-08-04 00:00:00 | Vacation |  |  | Correct
 | 2021-07-21 00:00:00 | 2021-07-21 00:00:00 | Vacation |  |  | Correct
 | 2021-07-20 00:00:00 | 2021-07-20 00:00:00 | Vacation |  |  | Correct
 | 2021-05-13 00:00:00 | 2021-05-13 00:00:00 | Vacation |  |  | Correct
 | 2021-08-15 00:00:00 | 2021-08-15 00:00:00 | Vacation |  |  | Wrong = 1
 | 2021-08-08 00:00:00 | 2021-08-08 00:00:00 | Vacation |  |  | Wrong = 1
 | 2021-08-05 00:00:00 | 2021-08-05 00:00:00 | Vacation |  |  | Correct
 | 2021-08-04 00:00:00 | 2021-08-04 00:00:00 | Half Day |  |  | Wrong = 0.5
 | 2021-08-03 00:00:00 | 2021-08-03 00:00:00 | Half Day |  |  | Wrong = 0.5
 | 2021-06-15 00:00:00 | 2021-06-15 00:00:00 | Half Day |  |  | Wrong = 0.5
 | 2021-06-13 00:00:00 | 2021-06-13 00:00:00 | Half Day |  |  | Wrong = 0.5
 | 2023-08-14 00:00:00 | 2023-08-18 00:00:00 | Vacation |  |  | Correct
 | 2023-08-14 00:00:00 | 2023-08-21 00:00:00 | Vacation |  |  | Correct
Spreadsheet: 267863d1380253527-searching-for-same-data-in-a-worksheet-and-copying-answer-into-another-cell-wip
Sheet: New

0021A | AZZURE | 0 | 0 |  | 0
0021A | AZZURE | 2 | 0 |  | 0
0021A | AZZURE | 4 | 0 |  | 0
0021A | AZZURE | 6 | 0 |  | 0
0021A | AZZURE | 8 | 0 |  | 0
0021A | AZZURE | 10 | 0 |  | 0
0021A | AZZURE | 12 | 0 |  | 0
0021A | AZZURE | 14 | 0 |  | 0
0021A | NAVY | 0 | 0 |  | 0
0021A | NAVY | 2 | 0 |  | 0
0021A | NAVY | 4 | 0 |  | 0
0021A | NAVY | 6 | 0 |  | 0
0021A | NAVY | 8 | 0 |  | 0
0021A | NAVY | 10 | 0 |  | 0
0021A | NAVY | 12 | 0 |  | 0
0021A | NAVY | 14 | 0 |  | 0
0035A | MINK | 0 | 0 |  | 0
0035A | MINK | 2 | 0 |  | 0
0035A | MINK | 4 | 0 |  | 0
0035A | MINK | 6 | 0 |  | 0
0035A | MINK | 8 | 0 |  | 0
0035A | MINK | 10 | 0 |  | 0
0035A | MINK | 12 | 0 |  | 0
0035A | MINK | 14 | 0 |  | 0
0036A | SEABLUE | 0 | 0 |  | 0
0036A | SEABLUE | 2 | 0 |  | 0
0036A | SEABLUE | 4 | 0 |  | 0
0036A | SEABLUE | 6 | 0 |  | 0
0036A | SEABLUE | 8 | 0 |  | 0
0036A | SEABLUE | 10 | 0 |  | 0
0036A | SEABLUE | 12 | 0 |  | 0
0036A | SEABLUE | 14 | 0 |  | 0
0036B | MINK | 16 | 0 |  | 0
0036B | MINK | 18 | 0 |  | 0
0036B | MINK | 20 | 0 |  | 0
0036B | MINK | 22 | 0 |  | 0
0036B | MINK | 24 | 0 |  | 0
0036B | SEABLUE | 16 | 0 |  | 0
0036B | SEABLUE | 18 | 0 |  | 0
0036B | SEABLUE | 20 | 0 |  | 0
0036B | SEABLUE | 22 | 0 |  | 0
0036B | SEABLUE | 24 | 0 |  | 0
Spreadsheet: 117678d1312957839-expanding-sum-based-on-months-excel-upload
Sheet: lookup table

 | No | Column | Month | Acutal | Budget | Column
 | 1 | 3 | JANUARY | January Acutal | January Budget | D:D
 | 2 | 4 | FEBRUARY | February Acutal | February Budget | D:E
 | 3 | 5 | [NAME] | March Acutal | March Budget | D:F
 | 4 | 6 | APRIL | April Acutal | April Budget | D:G
 | 5 | 7 | MAY | May Acutal | May Budget | D:H
 | 6 | 8 | [NAME] | June Acutal | June Budget | D:I
 | 7 | 9 | JULY | July Acutal | July Budget | D:J
 | 8 | 10 | AUGUST | August Acutal | August Budget | D:K
 | 9 | 11 | SEPTEMBER | September Acutal | September Budget | D:L
 | 10 | 12 | OCTOBER | October Acutal | October Budget | D:M
 | 11 | 13 | NOVEMBER | November Acutal | November Budget | D:N
 | 12 | 14 | DECEMBER | December Acutal | December Budget | D:O
Spreadsheet: 60894d1261477495-sum-unique-entries-on-filtered-data-book3
Sheet: pivot

PIVOT TABLE | No of Times Repitition of Dates | No of Unique Dates
Quality | (All)
Finish | (All)
Grade | (All)
Count of Billing da
Billing da | Total
01.12.2009 | 66 | 1
02.12.2009 | 70
03.12.2009 | 132
04.12.2009 | 169
05.12.2009 | 147
06.12.2009 | 150
07.12.2009 | 147
08.12.2009 | 130
09.12.2009 | 211
10.12.2009 | 177
11.12.2009 | 168
12.12.2009 | 217
13.12.2009 | 153
14.12.2009 | 165
15.12.2009 | 148
16.12.2009 | 244
17.12.2009 | 186
18.12.2009 | 311
19.12.2009 | 287
20.12.2009 | 194
21.12.2009 | 239
22.12.2009 | 5
Grand Total | 3716
Spreadsheet: 883698d1732351347-request-for-help-developing-an-excel-solver-model-to-allocate-students-to-courses-student-allocation-pkow-
Sheet: Students

ID | Gender | CourseID | Assessment Score | Distance To… | Mean | Centre 1 | Centre 2 | Centre 3 | Check
S1 | Male | 5 | 11 | 20 |  | 0 | 1 | 0 |  |  | Objective
S2 | Male | 4 | 19 | 25 |  | 1 | 0 | 0 |  |  | Average Distance
S3 | Female | 1 | 1 | 15 |  | 0 | 0 | 1
[NAME] | Female | 5 | 11 | 25 |  | 0 | 1 | 0
S5 | Female | 5 | 11 | 25 |  | 0 | 0 | 1
S6 | Male | 2 | 19 | 25 |  | 0 | 0 | 0
S7 | Female | 3 | 1 | 15 |  | 0 | 0 | 0
S8 | Male | 2 | 1 | 10 |  | 0 | 0 | 0
S9 | Male | 4 | 11 | 20 |  | 0 | 0 | 0
S10 | Male | 1 | 6 | 15 |  | 0 | 0 | 0
S11 | Male | 5 | 11 | 20 |  | 0 | 0 | 0
S12 | Male | 4 | 11 | 20 |  | 0 | 0 | 0
S13 | Female | 3 | 11 | 25 |  | 1 | 0 | 0
S14 | Female | 1 | 11 | 25 |  | 0 | 0 | 0
S15 | Female | 3 | 19 | 30 |  | 0 | 0 | 0
S16 | Female | 4 | 1 | 15 |  | 0 | 0 | 0
S17 | Female | 4 | 19 | 30 |  | 0 | 0 | 0
S18 | Male | 2 | 19 | 25 |  | 0 | 0 | 0
S19 | Male | 5 | 19 | 30 |  | 0 | 0 | 0
S20 | Male | 4 | 11 | 25 |  | 0 | 0 | 1
S21 | Male | 4 | 78 | 16 |  | 0 | 0 | 1
S22 | Male | 4 | 35 | 73 |  | 0 | 0 | 0
S23 | Female | 1 | 10 | 5 |  | 0 | 0 | 1
S24 | Female | 2 | 18 | 46 |  | 0 | 0 | 0
S25 | Female | 5 | 11 | 57 |  | 0 | 0 | 0
S26 | Female | 3 | 41 | 9 |  | 0 | 0 | 1
[NAME] | Female | 5 | 26 | 35 |  | 0 | 0 | 1
S28 | Male | 4 | 57 | 18 |  | 0 | 0 | 1
S29 | Female | 4 | 68 | 11 |  | 0 | 0 | 1
S30 | Female | 4 | 24 | 8 |  | 0 | 0 | 1
S31 | Male | 5 | 78 | 16 |  | 0 | 1 | 0
S32 | Female | 4 | 35 | 73 |  | 0 | 0 | 0
S33 | Male | 4 | 10 | 5 |  | 1 | 0 | 0
S34 | Male | 4 | 18 | 46 |  | 0 | 1 | 0
S35 | Male | 4 | 11 | 57 |  | 0 | 1 | 0
S36 | Male | 5 | 41 | 9 |  | 0 | 1 | 0
S37 | Male | 4 | 26 | 35 |  | 0 | 1 | 0
S38 | Male | 4 | 57 | 18 |  | 0 | 1 | 0
S39 | Male | 3 | 68 | 11 |  | 0 | 1 | 0
S40 | Male | 4 | 24 | 8 |  | 0 | 1 | 0
S41 | Male | 1 | 37 | 70 |  | 0 | 0 | 0
S42 | Female | 4 | 22 | 54 |  | 1 | 0 | 0
S43 | Female | 4 | 55 | 22 |  | 1 | 0 | 0
S44 | Female | 2 | 73 | 64 |  | 1 | 0 | 0
S45 | Female | 4 | 63 | 27 |  | 1 | 0 | 0
S46 | Female | 4 | 48 | 49 |  | 1 | 0 | 0
S47 | Male | 1 | 20 | 67 |  | 1 | 0 | 0
S48 | Female | 4 | 57 | 52 |  | 0 | 0 | 0
S49 | Female | 1 | 11 | 10 |  | 1 | 0 | 0
S50 | Male | 3 | 64 | 51 |  | 0 | 0 | 0
 | Total
 | Diff
Spreadsheet: 90507d1290199080-excel-2007-matching-the-same-value-on-2-sheets-but-some-have-more-wb1
Sheet: INPUT 2

Tarrif ID | Carrier Code | Service | Div | Origin Zone | OZ Desc | Destination Zone | DZ Desc | Rate Code | Charge Code | [NAME] | Range To | [NAME] Amt | Base Charge | Minimum Charge | Equipment Type | [NAME] | Tariff Status
31420 | abc | LTL | 2 | PQC00003 | South Quebec | PON00017 | GTA, Toronto, Mississauga, Scarborough | 110560 | WGT1 | LTLJ | 499 | 22.46 | 0 | 0 | *DFT | ACTIVE | ACTIVE
32299 | sde | LTLR | 1 | PQC00011 | South Quebec | P-QCC-DC | ALL PROVIGO QUEBEC CITY DC'S | MTL-QC | WGT1 | LTL1 | 9999999.9999 | 0 | 0 | 45 | REF | ACTIVE | ACTIVE
32273 | PROVSFRA | TLR | 1 | PQC00015 | South Quebec | P-MTL-DC | ALL PROVIGO MONTREAL DC'S | 75.0 | FLAT | UNPU |  |  | 75 | 0 | REF | ACTIVE | ACTIVE
32302 | ase | TLR | 1 | PQC00017 | South Quebec | P-MTL-DC | ALL PROVIGO MONTREAL DC'S | 160.0 | FLAT |  |  |  | 160 | 0 | REF | [NAME] | ACTIVE
31653 | wer | LTL | 1 | [NAME] | South Quebec | PQC00064 | Montreal | 110055 | WGT1 | LTLJ | 499 | 7.65 | 0 | 38.25 | *DFT | ACTIVE | ACTIVE
31223 | qas | TL2X | 2 | PQC00031 | ST. AUGISTINE | PON00030 | Sudbury | 1350.0 | FLAT |  |  |  | 1350 | 0 | TL2X | ACTIVE | ACTIVE
11925 | [NAME] | TL | 1 | PQC00051 | Hull, QC | P-MTL-DC | ALL PROVIGO MONTREAL DC'S | 350.0 | FLAT |  |  |  | 350 | 0 | TL | ACTIVE | ON HOLD
31420 | k;km | LTL | 1 | PQC00054 | Rouyn Noranda, QC | PQC00064 | Montreal | 110300 | WGT1 | LTLJ | 499 | 24.29 | 0 | 0 | *DFT | ACTIVE | ACTIVE
32299 | ppo | LTL | 1 | PQC00058 | [NAME], QC | P-MTL-DC | ALL PROVIGO MONTREAL DC'S | TRO-MT | PALT | PLTS | 9 | 25 | 0 | 65 | LTL | ACTIVE | ACTIVE
31653 | [NAME] | LTL | 1 | PQC00059 | Joliette, PQ | PQC00064 | Montreal | 110351 | WGT1 | LTLJ | 499 | 8.43 | 0 | 42.15 | *DFT | ACTIVE | ACTIVE
Spreadsheet: 787771d1658036270-work-hours-calculation-timesheet-aligw
Sheet: Sheet1

 | Time Sheet
 |  | In | Out | Hours
 | Monday | 08:00:00 | 18:18:00
 | Tuesday | 08:00:00 | 18:18:00
 | Wednesday | 08:00:00 | 18:18:00
 | Thursday | 08:00:00 | 18:18:00
 | Friday | 08:00:00 | 18:18:00
 |  |  | Total
 |  | How I can get the total hours right?
 |  | and how I can get the round up.. 10:18 hrs, should count as 10 hours
Spreadsheet: 274093d1383008145-lookup-based-on-multiple-tables-3-tables
Sheet: Sheet1

Criteria :
Blue | 2000
Result :
Sales
Region
Red
Region | Qty | Sales
North | 1000 | 1500
South | 2000 | 2000
West | 3000 | 2500
East | 4000 | 3000
Green
Region | Qty | Sales
North | 1000 | 4000
South | 2000 | 4500
West | 3000 | 5000
East | 4000 | 5500
Blue
Region | Qty | Sales
North | 1000 | 6000
South | 2000 | 6500
West | 3000 | 7000
East | 4000 | 7500
Spreadsheet: 653763eb-604d-4d2e-b686-17eeb9425a43
Sheet: Basic

Table 2 - Reported Claim Development Triangle ($000)
AY | 12
2002 | 12811 | 20370 | 26656 | 37667 | 44414 | 48701 | 48169
 | 9651 | 16995 | 30354 | 40594 | 44231 | 44373
 | 16995 | 40180 | 58866 | 71707 | 70288
 | 28674 | 47432 | 70340 | 70655
 | 27066 | 46783 | 48804
 | 19477 | 31732
 | 18632
Table 3 - Paid Claim Development Triangle ($000)
AY | 12
2002 | 2318 | 7932 | 13822 | 22095 | 31945 | 40629 | 44437
 | 1743 | 6240 | 12683 | 22892 | 34505 | 39320
 | 2221 | 9898 | 25950 | 43439 | 52811
 | 3043 | 12219 | 27073 | 40026
 | 3531 | 11778 | 22819
 | 3529 | 11865
 | 3409
Table 8 - Reported Claim Count Development Triangle
AY | 12
2002 | 1342 | 1514 | 1548 | 1557 | 1549 | 1552 | 1554
 | 1373 | 1616 | 1630 | 1626 | 1629 | 1629
 | 1932 | 2168 | 2234 | 2249 | 2258
 | 2067 | 2293 | 2367 | 2390
 | 1473 | 1645 | 1657
 | 1192 | 1264
 | 1036
Table 9 - Closed Claim Count Development Triangle (Excludes closed non-pay (CNP))
AY | 12
2002 | 203 | 607 | 841 | 1089 | 1327 | 1464 | 1523
 | 181 | 614 | 941 | 1263 | 1507 | 1568
 | 235 | 848 | 1442 | 1852 | 2029
 | 295 | 1119 | 1664 | 1946
 | 307 | 906 | 1201
 | 329 | 791
 | 276
Spreadsheet: michelle_lokay__26574__imbalsumm0012
Sheet: CIG

 | Tumbleweed
 | 9198
Day | Measured | Scheduled
1 | 17996 | 25998
2 | 27242 | 40000
3 | 30344 | 39999
4 | 29336 | 38306
5 | 23080
6 | 31559 | 38450
7 | 30721 | 31076
8 | 25834 | 26000
9 | 26005 | 26000
10 | 25879 | 26000
11 | 27732 | 26000
12 | 33840 | 26000
13 | 28685 | 29986
14 | 30565 | 35963
15 | 24896 | 25999
16 | 24310 | 26000
17 | 24306 | 26000
18 | 24583 | 26000
19 | 24273 | 31000
20 | 24703 | 25999
21 | 24285 | 30999
22 | 23418 | 26000
23 | 25841 | 26000
24 | 25222 | 26000
25 | 25295 | 26000
26 | 25149 | 26000
27 | 24300 | 26000
28 | 28905 | 30999
29 | 29346 | 31000
30 | 30448 | 31000
31 | 30278 | 29877
2000-11-30 00:00:00 |  |  | -557795.86
2000-12-31 00:00:00
Spreadsheet: 4db1a23b-8d33-4a4a-90ff-c7777d66453b
Sheet: Sheet1

athletes_idAthletes | Rk | Nation | Date of Birth | ID Number | Last Name | First Name | Total Pts | Fenc | Swim | Ride | Comb | Swim time
1778 | 1 | GER | 11/04/86 | W001778 | SCHONEBORN | [NAME] | 5412 | 1040 | 1152 | 1200 | 2020 | 2:17.59
5097 | 2 | HUN | 12/03/91 | [NAME] | KOVACS | Sarolta | 5368 | 920 | 1236 | 1200 | 2012 | 2:10.59
2025 | 3 | RUS | 29/01/88 | W002025 | RIMSAITE | Donata | 5332 | 960 | 1112 | 1200 | 2060 | 2:20.66
2054 | 4 | LTU | 28/02/84 | W002054 | ASADAUSKAITE | [NAME] | 5308 | 800 | 1168 | 1120 | 2220 | 2:16.32
3881 | 5 | USA | 07/10/91 | W003881 | ISAKSEN | Margaux | 5292 | 920 | 1124 | 1200 | 2048 | 2:19.78
1734 | 6 | UKR | 18/02/82 | W001734 | TERESHUK | Victoria | 5256 | 720 | 1224 | 1160 | 2152 | 2:11.35
39969 | 7 | BLR | 20/09/85 | W039969 | PROKOPENKO | Anastasiya | 5240 | 800 | 1064 | 1180 | 2196 | 2:24.97
871 | 8 | RUS | 09/12/82 | W000871 | GRETCHICHNIKOVA | [NAME] | 5236 | 1000 | 1084 | 1200 | 1952 | 2:23.03
4159 | 9 | RUS | 21/08/89 | W004159 | KHURASKINA | Ekaterina | 5220 | 1040 | 1064 | 1100 | 2016 | 2:24.87
1201 | 10 | GER | 19/06/82 | W001201 | TRAUTMANN | Eva | 5172 | 720 | 1144 | 1200 | 2108 | 2:18.13
2210 | 11 | CZE | 01/01/89 | W002210 | DIANOVA | [NAME] | 5168 | 760 | 1176 | 1200 | 2032 | 2:15.47
95 | 12 | LAT | 23/03/76 | W000095 | RUBLEVSKA | Elena | 5148 | 920 | 1060 | 1200 | 1968 | 2:25.18
3945 | 13 | GER | 03/04/90 | W003945 | SCHLEU | Annika | 5140 | 840 | 1100 | 1200 | 2000 | 2:21.87
3944 | 14 | RUS | 23/02/90 | W003944 | FAKHRUTDINOVA | Alise | 5136 | 920 | 1160 | 1200 | 1856 | 2:16.72
40275 | 15 | KAZ | 12/05/84 | [NAME] | KOLEGOVA | Yuliya | 5100 | 720 | 1192 | 1160 | 2028 | 2:14.16
38065 | 16 | RUS | 10/03/91 | W038065 | LEBEDEVA | [NAME] | 5068 | 840 | 1200 | 1180 | 1848 | 2:13.65
1575 | 17 | GBR | 03/03/83 | W001575 | FELL | Heather | 5028 | 720 | 1144 | 1180 | 1984 | 2:18.06
37925 | 18 | HUN | 22/04/86 | W037925 | GYENESEI | [NAME] | 4992 | 560 | 1264 | 1200 | 1968 | 2:08.09
39970 | 19 | RUS | 10/08/89 | W039970 | PUCHKOVA | Elizaveta | 4960 | 760 | 1088 | 1200 | 1912 | 2:22.75
1941 | 20 | CZE | 27/02/90 | W001941 | KODEDOVA | [NAME] | 4812 | 680 | 1072 | 1120 | 1940 | 2:24.13
39469 | 21 | FRA | 14/01/89 | W039469 | CLOUVEL | Elodie | 4680 | 720 | 1148 | 1156 | 1656 | 2:17.94
2020 | 22 | RUS | 29/10/87 | W002020 | SAVCHENKO | Anna | 4368 | 720 | 1104 | 744 | 1800 | 2:21.63
1997 | 23 | FIN | 09/04/87 | W001997 | SALMINEN | [NAME] | 4244 | 600 | 1184 | 536 | 1924 | 2:14.66
39968 | 24 | BLR | 07/09/83 | W039968 | YELIZAROVA | [NAME] | 2156 | 880 | 1096 | 180 | 0 | 2:22.13
Spreadsheet: john_griffith__16101__1_18_02OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HO G2 | 52 | 330 | 390 | 48.1 | 56.8 | 1.71 | 2002-01-18 13:22:00
 | [NAME] | 52 | 670 | 870 | 50.3 | 65.3 | 1.89 | 2002-01-18 13:22:00
 | HO J2 | 52 | 870 | 970 | 49.7 | 55.5 | 1.72 | 2002-01-18 13:22:00
 | HO K2 | 52 | 1030 | 1080 | 48.8 | 51.2 | 1.63 | 2002-01-18 13:22:00
 | HO M2 | 53 | 1130 | 1230 | 45.5 | 49.6 | 1.58 | 2002-01-18 13:22:00
 | HO N2 | 54 | 1180 | 1280 | 42.5 | 46.1 | 1.5 | 2002-01-18 13:22:00
 | HO Q2 | 55 | 1240 | 1340 | 40.3 | 43.6 | 1.45 | 2002-01-18 13:22:00
 | HO U2 | 55 | 1325 | 1425 | 40 | 43 | 1.43 | 2002-01-18 13:22:00
 | [NAME] | 56 | 1325 | 1450 | 37 | 40.5 | 1.36 | 2002-01-18 13:22:00
 | HO X2 | 57 | 1375 | 1525 | 35.6 | 39.6 | 1.35 | 2002-01-18 13:22:00
 | [NAME] | 57 | 1375 | 1550 | 34.1 | 38.5 | 1.3 | 2002-01-18 13:22:00
 | HO F3 | 58 | 1400 | 1550 | 32.8 | 36.3 | 1.26 | 2002-01-18 13:22:00
 | [NAME] |  |  |  | 33.2 | 36.5 | 1.31 | 2001-12-31 13:18:00
 | HO H3
 | HO J3 |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | [NAME]
Spreadsheet: 791245d1660223357-selection-of-a-specific-payment-method-from-a-list-of-different-categories-excelforum
Sheet: CashSales

ACRYLON PAINTS (PTY) LTD
CASH SALES
Month: | 2022-07-01 00:00:00 |  | MoP | C | S | T
Date | Document Number | Customer Name | Category | Manufactured Paint | Brought In Products | Accessories | Cash Sale Amount
2022-08-01 00:00:00 | 01 | [NAME] | s | 1005
2022-08-02 00:00:00 | 02 | [NAME] | c |  |  | 500
2022-08-03 00:00:00 | 03 | [NAME] | t |  |  | 200
2022-08-04 00:00:00 | 04 | Martin | t | 1500
2022-08-05 00:00:00 | 05 | [NAME] | s |  | 2000
2022-08-06 00:00:00 | 06 | [NAME] | c
2022-08-07 00:00:00 | 07 | Denver | s
Spreadsheet: 58813d1259075312-split-data-into-ranges-708485_mmandel
Sheet: Sheet2

Row Labels | Count of Number
1-5 | 2
6-10 | 2
11-15 | 4
16-20 | 10
21-25 | 7
26-30 | 3
31-35 | 1
36-40 | 4
41-45 | 5
46-50 | 7
51-55 | 7
56-60 | 2
61-65 | 7
66-70 | 4
71-75 | 8
76-80 | 10
81-85 | 6
86-90 | 2
91-95 | 4
96-100 | 4
Grand Total | 99
Spreadsheet: 003fdd0d-c64a-4805-9564-a2cd5f9d1613
Sheet: Activites codes

n/a | SFY 2014 FEDERAL CODE SHEET
SFY 2014 FEDERAL EDRS-SERVS-UFARS codes crosswalk
n/a | n/a
EDRS Activity codes | n/a
n/a | n/a
Activity Code | [NAME]
J | Assessment (Consultant Only)
K | Coursework Registration, Tuition or Fee
L | [NAME] (Personnel Development only)
M | Special Education Curriculum Development
N | Special Education Program Evaluation
O | IEP Planning Development, Review Due Process
S | Advisory Committee Activities
T | Conference/Workshop Expenses
V | Professional Membership/Dues Expenses
W | Family Events
X | Interagency Activities
Z | Travel, Mileage, Meals and Lodging
Team Teaching Required for Personnel Type Code 1 Teacher
+ | Team Teaching Model - Regular Class
* | Team Teaching Model - Resource Room
# | Team Teaching Model - Separate Class
Required for Personnel Type Code 12 Cultural Liaison
t | American Indian
u | Bilingual
v | African American
w | Other
Required for CEIS Services FSC Z and M/CEIS Services FSC z
s | Special Education Teacher
R | Regular Education Teacher
Required for Personnel Type Code 62 Extracurricular Activities Staff Only
a | Interpreter Services
b | Assistive Technology Services
c | Para/PCA Services
d | Nursing Services
e | Vision Services
f | Other IEP Specified Services
end of worksheet
Spreadsheet: 67356d1267987551-formula-for-calculating-markup-and-vat-costmarkupvat
Sheet: Sheet1

% [NAME] | % VAT
35 | 8
Cost | Cost + Markup + VAT
50 | 72.9
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
Total | 72.9
Spreadsheet: 686871d1594842356-create-dynamic-list-with-blank-rows-in-the-data-dynamic-list-example-file-updated
Sheet: Data file

Information:
Account numbers are in text format. Account names are in the cells below the account numbers.
The number of blank cells in column A between accounts will vary.
The entire list will contain about 250 accounts that span about 3000 rows. The rows will usually contain data in other columns (not shown in this example).
For each account, the data needed to make the dynamic list will on the same row as the account number.
Goals:
1) Create a dynamic list containing the account number, account name, and balance for all accounts with a balance greater than zero.
1) Create a dynamic list containing the account number, account name, and status for all accounts with a status of "No".
Account Number Account Name | Balance | On Time
1001 | 200 | No
[NAME]
1002 | 0
[NAME]
1003 | 0 | No
Carrie
1004 | 150 | No
[NAME]
1005 | 25
Ellie
1006 | 68
[NAME]
1007 | 164
Gretchen
1008 | 0
Helen
1009 | 0
[NAME]
1010 | 12
[NAME]
Spreadsheet: 00d9c308-757c-4b3b-96b2-422a09123dad
Sheet: Grade 8 Math

2013 Minnesota Test of Academic Skills (MTAS)
2013 MTAS Grade 8
Grade 8 Mathematics MTAS-III
Raw Score | Scale Score** | Level
0 | 119 | D
1 | 132 | D
2 | 140 | D
3 | 146 | D
4 | 150 | D
5 | 155 | D
6 | 159 | D
7 | 165 | D
8 | 171 | D
9 | 178 | D
10 | 184 | D
11 | 190 | P
12 | 192 | P
13 | 195 | P
14 | 197 | P
15 | 199 | P
16 | 200 | M
17 | 202 | M
18 | 204 | M
19 | 205 | M
20 | 207 | E
21 | 209 | E
22 | 211 | E
23 | 213 | E
24 | 216 | E
25 | 220 | E
26 | 226 | E
27 | 237 | E
Notes:
*2007 and 2008/2009/2010/2011  MTAS scale metrics are not comparable
**2011/2012 and 2008/2009/2010  Grades 3-8 Mathematics MTAS scale metrics are not comparable
***2012 and 2008/2009/2010/2011 Science MTAS metrics are not comparable
****2013 and 2008/2009/2010/2011/2012  Reading MTAS scale metrics are not comparable
End of Worksheet