tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 679113d1590199534-how-can-i-plot-the-correct-line-graph-from-my-data-lines
Sheet: lines

X1 | Y1 | X2 | Y2
577 | 0 | 0 | 849
572 | 0 | 0 | 849
570 | 0 | 0 | 849
0 | 224 | 224 | 282
567 | 0 | 0 | 849
0 | 231 | 231 | 279
563 | 0 | 0 | 849
0 | 204 | 204 | 289
0 | 208 | 208 | 287
0 | 246 | 246 | 274
0 | 195 | 195 | 538
565 | 0 | 0 | 849
147 | 658 | 658 | 166
0 | 197 | 197 | 541
0 | 251 | 251 | 148
0 | 217 | 217 | 284
574 | 0 | 0 | 849
0 | 201 | 201 | 554
0 | 200 | 200 | 550
602 | 111 | 111 | 765
598 | 51 | 51 | 794
312 | 999 | 999 | 825
568 | 0 | 0 | 849
576 | 0 | 0 | 849
0 | 198 | 198 | 545
0 | 235 | 235 | 278
578 | 0 | 0 | 849
0 | 240 | 240 | 276
0 | 220 | 220 | 283
0 | 192 | 192 | 529
0 | 211 | 211 | 286
291 | 999 | 999 | 849
0 | 228 | 228 | 280
303 | 999 | 999 | 849
0 | 189 | 189 | 519
0 | 193 | 193 | 532
297 | 999 | 999 | 849
70 | 159 | 159 | 508
361 | 973 | 973 | 849
309 | 999 | 999 | 849
77 | 413 | 413 | 147
316 | 999 | 999 | 776
320 | 999 | 999 | 710
0 | 190 | 190 | 523
329 | 83 | 83 | 407
0 | 187 | 187 | 515
369 | 971 | 971 | 849
328 | 999 | 999 | 570
323 | 999 | 999 | 655
391 | 450 | 450 | 621
233 | 164 | 164 | 533
427 | 855 | 855 | 483
459 | 835 | 835 | 663
394 | 862 | 862 | 675
331 | 999 | 999 | 515
574 | 541 | 541 | 662
125 | 355 | 355 | 311
448 | 865 | 865 | 556
369 | 664 | 664 | 621
283 | 923 | 923 | 461
629 | 526 | 526 | 696
278 | 447 | 447 | 345
221 | 312 | 312 | 355
309 | 878 | 878 | 559
387 | 653 | 653 | 720
267 | 498 | 498 | 433
436 | 838 | 838 | 581
448 | 641 | 641 | 722
240 | 296 | 296 | 406
362 | 610 | 610 | 415
503 | 359 | 359 | 640
412 | 250 | 250 | 590
385 | 800 | 800 | 574
158 | 292 | 292 | 296
545 | 401 | 401 | 604
403 | 455 | 455 | 598
389 | 808 | 808 | 522
632 | 728 | 728 | 769
311 | 276 | 276 | 465
286 | 839 | 839 | 400
393 | 665 | 665 | 719
280 | 240 | 240 | 385
238 | 701 | 701 | 418
544 | 763 | 763 | 673
523 | 400 | 400 | 646
39 | 232 | 232 | 251
546 | 594 | 594 | 718
206 | 731 | 731 | 289
286 | 233 | 233 | 394
576 | 330 | 330 | 638
144 | 288 | 288 | 204
631 | 719 | 719 | 751
216 | 722 | 722 | 405
362 | 869 | 869 | 433
374 | 409 | 409 | 430
224 | 307 | 307 | 302
561 | 791 | 791 | 634
195 | 467 | 467 | 252
335 | 999 | 999 | 455
255 | 512 | 512 | 350
538 | 544 | 544 | 641
355 | 205 | 205 | 503
490 | 171 | 171 | 544
484 | 836 | 836 | 620
414 | 795 | 795 | 473
295 | 428 | 428 | 358
420 | 402 | 402 | 589
178 | 327 | 327 | 233
485 | 567 | 567 | 639
396 | 200 | 200 | 455
245 | 647 | 647 | 323
171 | 335 | 335 | 247
400 | 602 | 602 | 450
138 | 539 | 539 | 271
230 | 616 | 616 | 288
489 | 228 | 228 | 562
235 | 711 | 711 | 384
445 | 234 | 234 | 505
581 | 342 | 342 | 640
663 | 764 | 764 | 720
446 | 943 | 943 | 849
137 | 535 | 535 | 253
619 | 775 | 775 | 676
446 | 225 | 225 | 516
458 | 85 | 85 | 535
510 | 169 | 169 | 581
350 | 478 | 478 | 543
238 | 116 | 116 | 326
622 | 576 | 576 | 721
132 | 334 | 334 | 235
330 | 279 | 279 | 398
469 | 169 | 169 | 524
508 | 921 | 921 | 813
250 | 701 | 701 | 301
388 | 368 | 368 | 465
413 | 369 | 369 | 468
713 | 849 | 849 | 796
503 | 153 | 153 | 575
683 | 767 | 767 | 737
711 | 847 | 847 | 769
341 | 464 | 464 | 400
766 | 560 | 560 | 790
Spreadsheet: 45d433c8-80f7-4558-bc7c-666b42b5131b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-08-26 09:15:34.160000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.5 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.375 | 101.518 | 101.393 | 101.268 | 100.893
4.25 | 100.555 | 100.43 | 100.305 | 99.93 |  | Note: | Refer To Price [NAME]
4.125 | 99.96 | 99.835 | 99.71 | 99.335 |  |  | For all Price Adjs
4 | 99.458 | 99.333 | 99.208
3.875 | 98.834 | 98.709 | 98.584
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.75 | 101.486 | 101.361 | 101.236 | 100.861
3.625 | 100.952 | 100.827 | 100.702 | 100.327
3.5 | 100.616 | 100.491 | 100.366 | 99.991
3.375 | 100.236 | 100.111 | 99.986 | 99.611
3.25 | 99.678 | 99.553 | 99.428
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-09-09 09:15:34.160000
30 DAY | 2011-09-24 09:15:34.160000
45 DAY | 2011-10-09 09:15:34.160000
60 DAY | 2011-10-24 09:15:34.160000
90 DAY | 2011-11-23 09:15:34.160000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: East - Orig

 | East Gas - Orig
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan
ENACOMP | Compensation |  |  |  |  |  | 624360 | Compensation | 0
 | Special Pays |  |  | 0 |  |  | 0
 | Analyst & Associates |  |  |  |  |  | 0
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  | 128612 | Other
ENAEMPEX | Employee Expense |  |  |  |  |  | 33000
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  | 247500 | Total
ENAOUTSV | Outside Services |  |  |  |  |  | 0
ENASUPP | Supplies Expense |  |  |  |  |  | 22000
ENAMKTEX | Marketing |  |  |  |  |  | 0 | Intern | 33000
ENACONTR | Charitable Contributions |  |  |  |  |  | 5500 | [NAME] | 48400 | 0
ENARENT | Rent |  |  |  |  |  | 0 | Staff | 49500 | 0
ENATECH | Technology |  |  |  |  |  | 22000 | Specialist | 57750 | 0
ENATRANS | Transportation |  |  |  |  |  | 0 | Sr. Specialist | 71500 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  | 6217.2 | Analyst | 60500 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  | 0 | Associate | 89100 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000 | 1
 |  |  |  |  |  |  |  | Director | 143000
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000 | 1
 | A&A Headcount |  |  |  |  |  |  | MD | 220000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: sally_beck__33986__headcount
Sheet: Summ

ENRON GLOBAL MARKETS
 |  |  |  |  |  | Current |  |  |  | Proposed |  |  |  | Year End
COMMERCIAL TEAMS | Commercial | Other | Total |  |  | Trading | Origination | Support | TOTAL | Trading | Origination | Support | TOTAL | TOTAL
Agricultural Trading | 2 | 10
Coal | 15 | 11 |  |  | 30
Convertible Debt Trading | 0 | 1 |  |  | 3
Emissions Technology | 2.5 | 2 |  |  | 10.5
Emissions Trading | 0.5 | 4 |  |  | 6.5
Equity Trading | 6 | 8 |  |  | 19
Finance and Structuring | 4 | 3 |  |  | 8
Global Risk Markets | 8 | 7 |  |  | 42
Crude & Products | 30 | 28 |  |  | 69
LNG | 20 | 13 |  |  | 34
Middle East | 6 | 4 |  |  | 14
Office of the Chairman | 2 | 3 |  |  | 5
Puerto Rico | 2 | 1 |  |  | 4
Rate & Currency Trading | 5 | 3 |  |  | 8
Transportation | 1 | 1 |  |  | 50
Weather | 7 | 10 |  |  | 22
Market Fundamentals
Total Commercial
SUPPORT DEPARTMENTS | Commercial | Other | Total
Energy Ops - Coal, Emissions, Crude & Products |  | 66
Energy Operations - Financial Trading |  | 20
Energy Operations - LNG |  | 2
Energy Operations - Weather |  | 4
Financial Operations |  | 33 |  |  |  |  |  | 33 |  |  |  | 38
VP Operations & CAO |  | 4
Transaction Support
Total Support
IT SUPPORT LOCATED ON TRADE FLOOR |  |  |  |  |  |  |  |  | 8 |  |  |  |  | 8
REGULATORY SUPPORT LOCATED ON TRADE FLOOR |  |  |  |  |  |  |  |  | 2 |  |  |  |  | 2
TOTAL THIRD FLOOR HOUSTON HEADCOUNT |  | #REF! | #REF! | #REF!
TOTAL THIRD FLOOR WORKSPACE |  | TOTAL THIRD FLOOR HOUSTON HEADCOUNT | TOTAL THIRD FLOOR HOUSTON HEADCOUNT | TOTAL THIRD FLOOR HOUSTON HEADCOUNT |  |  |  |  | 449 |  |  |  |  | 449
TOTAL THIRD FLOOR HOUSTON HEADCOUNT
Spreadsheet: 96245d1295638204-countif-separately-based-on-backround-color-nfltest1
Sheet: Sheet2

 |  |  | NFC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AFC
 |  |  | East |  |  |  | South |  |  |  | North |  |  |  | West |  |  |  | East |  |  |  | South |  |  |  | North |  |  |  | West
 |  | 2011 | Redskins | Giants | Eagles | Cowboys | Saints | Panthers | Falcons | Bucs | Vikings | Packers | Lions | Bears | Seahawks | [NAME] | Cardinals | 49ers | Patriots | Jets | [NAME] | Bills | Titans | Texans | [NAME] | Colts | Steelers | Ravens | [NAME] | Bengals | Raiders | Chiefs | Chargers | Broncos
AFC | West | Broncos
 |  | Chargers
 |  | Chiefs
 |  | Raiders
 | North | Bengals
 |  | [NAME]
 |  | Ravens
 |  | Steelers
 | South | Colts
 |  | [NAME]
 |  | Texans
 |  | Titans
 | East | Bills
 |  | [NAME]
 |  | Jets
 |  | Patriots
NFC | West | 49ers
 |  | Cardinals
 |  | [NAME]
 |  | Seahawks
 | North | Bears
 |  | Lions
 |  | Packers
 |  | Vikings
 | South | Bucs
 |  | Falcons
 |  | Panthers
 |  | Saints
 | East | Cowboys
 |  | Eagles
 |  | Giants
 |  | Redskins
Spreadsheet: 108289d1305303311-excel-2007-pivot-table-formulas-with-custom-subtotals-sample
Sheet: data

name | month | year | balance | quantity | tax
[NAME] | 2010-01-01 00:00:00 | 2010 | 10 | 2 | 2
[NAME] | 2010-02-01 00:00:00 | 2010 | 32 | 5 | 2
[NAME] | 2011-01-01 00:00:00 | 2011 | 14 | 2 | 2
[NAME] | 2011-02-01 00:00:00 | 2011 | 24 | 4 | 2
item2 | 2010-01-01 00:00:00 | 2010 | 24 | 3 | 5
item2 | 2010-02-01 00:00:00 | 2010 | 26 | 3 | 6
item2 | 2011-01-01 00:00:00 | 2011 | 52 | 4 | 7
item2 | 2011-02-01 00:00:00 | 2011 | 53 | 4 | 8
item3 | 2010-01-01 00:00:00 | 2010 | 100 | 5 | 22
item3 | 2010-02-01 00:00:00 | 2010 | 102 | 5 | 23
item3 | 2011-01-01 00:00:00 | 2011 | 107 | 5 | 24
item3 | 2011-02-01 00:00:00 | 2011 | 108 | 5 | 25
Spreadsheet: 95788d1295357918-combination-of-assessment-for-a-final-score-assesmet-combination
Sheet: Combination

Subject | Weightage | Assessment Scale
A | 0.3 | 0 | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9 | 1
B | 0.25 | 0 | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9 | 1
C | 0.2 | 0 | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9 | 1
D | 0.15 | 0 | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9 | 1
E | 0.1 | 0 | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9 | 1
Total | 1
 | Rating Combination
Final Score | A | B | C | D | E | Check
1 | 1 | 1 | 1 | 1 | 1 | 1
0.99 | 1 | 1 | 1 | 1 | 0.9 | 0.99
0.98 | 1 | 1 | 1 | 1 | 0.8 | 0.98
0.98 | 1 | 1 | 0.9 | 1 | 1 | 0.9800000000000001
0.97 | 1 | 1 | 1 | 1 | 0.7 | 0.97
0.97 | 0.9 | 1 | 1 | 1 | 1 | 0.97
0.97 | 1 | 1 | 1 | 0.8 | 1 | 0.97
0.96 | 1 | 0.9629648152644569 | 0.9703718517700718 | 0.9777788882756866 | 0.785185925885184 | 0.9600009999999999 | Solver solution 1
0.96 | 1 | 1 | 1 | 1 | 0.6000000000001481 | 0.9600000000000148 | Solver solution 2
Spreadsheet: 806988d1669708283-transfer-of-data-from-a-master-sheet-to-other-sheets-quest
Sheet: Pivot

Date | (All)
Sum of  Amount
Inv | Decription | Debit | Credit | Total
1 | rent | Cash In Bank | Cash In Hand | 100
2 | rent | Saleem | Cash In Hand | 300
3 | rent | Cash In Hand | Saleem | 700
4 | rebt | Cash In Bank | Co-Operative Bank | 1000
5 | rett | Cash In Hand | Co-Operative Bank | 500
6 | rent | Shafeeq | Cash In Hand | 10000
Grand Total |  |  |  | 12600
Spreadsheet: 329149d1404216177-solver-not-working-excel-forum-help
Sheet: Calculations

 | II. Calculations
 |  | DATA USAGE
 |  | Split | 161
 |  |  | Count | Upgraded: Yes | Upgraded: No | Entropy | Impurity
 |  | PHONE PRICE
 |  | Split | 594
 |  |  | Count | Upgraded: Yes | Upgraded: No | Entropy | Impurity
Spreadsheet: 161399d1339512395-breakdown-hours-formula-overtime-tracker
Sheet: June IDP

 |  | 2012-06-02 00:00:00
 | PST | [NAME] | Actual Hrs | [NAME] | Actual Hrs
 | 03:00:00
 | 03:30:00 | 0 | 0 | 0 | 0
 | 04:00:00 | 0 | 0 | 0 | 0
 | 04:30:00 | 0 | 0 | 0 | 0
 | 05:00:00 | 0 | 0 | 0 | 0
 | 05:30:00 | 0 | 0 | 0 | 0
 | 06:00:00 | 0 | 0 | 0 | 0
 | 06:30:00 | 0 | 0 | 0 | 0
 | 07:00:00 | 0 | 0 | 0 | 0
 | 07:30:00 | 0 | 0 | 0 | 0
 | 08:00:00 | 0 | 0 | 0 | 0
 | 08:30:00 | 0 | 0 | 0 | 0
 | 09:00:00 | 5 | 5 | 0 | 0
 | 09:30:00 | 7 | 7 | 0 | 0
 | 10:00:00 | 2 | 2 | 0 | 0
 | 10:30:00 | 0 | 0 | 0 | 0
 | 11:00:00 | 0 | 0 | 0 | 0
 | 11:30:00 | 0 | 0 | 0 | 0
 | 12:00:00 | 0 | 0 | 0 | 0
 | 12:30:00 | 0 | 0 | 0 | 0
 | 13:00:00 | 0 | 0 | 0 | 0
 | 13:30:00 | 0 | 0 | 0 | 0
 | 14:00:00 | 0 | 0 | 0 | 0
 | 14:30:00 | 0 | 0 | 0 | 0
 | 15:00:00 | 0 | 0 | 0 | 0
 | 15:30:00 | 0 | 0 | 0 | 0
 | 16:00:00 | 0 | 0 | 0 | 0
 | 16:30:00 | 0 | 0 | 0 | 0
 | 17:00:00 | 0 | 0 | 0 | 0
 | 17:30:00 | 0 | 0 | 0 | 0
 | 18:00:00 | 0 | 0 | 0 | 0
 | 18:30:00 | 0 | 0 | 0 | 0
 | 19:00:00 | 0 | 0 | 0 | 0
 | 19:30:00 | 0 | 0 | 0 | 0
 | 20:00:00 | 0 | 0 | 0 | 0
 | 20:30:00 | 0 | 0 | 0 | 0
 | 21:00:00 | 0 | 0 | 0 | 0
 | 21:30:00 | 0 | 0 | 0 | 0
 | Total Hrs
Spreadsheet: 356662d1415181655-column-sort-without-chaning-formulae-jc-booking-september-2014
Sheet: 15th

Date |  |  |  |  |  |  |  |  |  |  |  | DAY SHEET
Job No | Due | Contact | Contact No. | Car | Imax | 13 Pax | 20 Pax | 24 Pax | 29 Pax | 44 Pax | FROM | TO | Retn | Price  $ | Dep  $ | Bal | Mode | Pax | Trailer | Con | Bus | Des | Driver
9386 | 0830 | [NAME] | 82721455/[PHONE] |  |  | 1 |  |  |  |  | Unley High School meet around the back outside [NAME] to  attach cage trailer here | Craigburn Farm Mountain Bike Park near Blackwood ,will direct driver leave trailer here | Y | 99 | 0 |  | acct | 13 |  |  |  |  | cat
 | 12.00 | [NAME] | 82721455/[PHONE] |  |  | 1 |  |  |  |  | Craigburn Farm Mountain Bike Park near Blackwood attach cage trailer here | Unley High School disconnect cage trailer here | n | 99 | 0 |  | acct | 13 |  |  |  |  | cat
 | 0745 | [NAME] | [PHONE] |  |  | 1 |  |  |  |  | Torrens Rowing Club City | Loreto College | n | 68 | 0 |  | acct | 12 |  |  |  |  | cat
 | 1545 | [NAME] Loreto College 316 Portrush Road ,Marryatville | 83344255/[PHONE] |  |  |  |  |  | 1 |  | Loreto College Marryatville | River Torrens City Rowing Club | n | 145 | 0 |  | acct | 25 |  |  |  |  | [NAME]
 | 0730 | Maria Underwood Global Intertrade Pty Ltd PO Box 1917 SA 5001 | [PHONE] or  [PHONE] |  |  |  | 1 |  |  |  | Quest Apts [NAME] | Tafe Regency Pk | y | 95 | 0 |  | acct | 21 |  |  |  |  | [NAME]
 | 1700 | Maria Underwood Global Intertrade Pty Ltd PO Box 1917 SA 5001 | M0437653165 or  T0411229640 |  |  |  | 1 |  |  |  | Tafe Regency Pk | Quest Apts [NAME] | n | 95 | 0 |  | acct | 21 |  |  |  |  | [NAME]
 | 0900 | Adelaide High | [NAME] |  |  |  | 1 |  |  |  | Adelaide High | [NAME] | y | 120 | 0 |  | acct | 17 |  |  |  |  | [NAME] c
 | 1430 | Adelaide High | [NAME] |  |  |  | 1 |  |  |  | [NAME] | Adelaide High | n | 120 | 0 |  | acct | 17 |  |  |  |  | [NAME] c
 |  |  |  |  |  |  |  |  |  |  | Malaysia 0715  -Apt
 |  |  |  |  |  |  |  |  |  |  | Malaysia 1230 - Hotel
TOTAL
Spreadsheet: 39226d1237407479-transposing-data-from-multiple-rows-into-single-rows-and-multiple-columns-response-transpose-with-variable-cols
Sheet: Record Numbers

1 | AQ | 1 | 1 | 4 | 2 | AQ | AW | AR
1 | AW | 2 | 3 | 4 | 1 | AR
2 | AR | 3 | 4 | 9 | 5 | AR | AT | AW | FD | FS
3 | AR | 4 | 9 | 12 | 3 | AT | AX | AR
3 | AT | 5 | 12 | 13 | 1 | AW
3 | AW
3 | FD
3 | FS
4 | AT
4 | AX
4 | AR
5 | AW
 |  | To analyse as required:
 |  | Prepare list of unique record codes and place in Column C (eg use Data, Filter, Advanced)
 |  | Enter formula in col D and E and copy down
 |  | Replace last cell in column E with formula as shown
 |  | Enter formula in F and copy down. Use this to find the [NAME] cols required in next step (eg as in F6)
 |  | Enter formula in F1, copy right to the maximum needed
 |  | Copy this range down as required.
 |  | In this example columns G:I represent the result and could be copied and pasted as values to another worksheet,
 |  | then saved as a csv file
Spreadsheet: 703775d1605171093-changing-a-single-point-of-data-into-a-row-of-data-merging-identical-items-into-total-forum-hlp-sht
Sheet: Pallet report

Part code | Production line | Full Part Number | Pallet [NAME] contents |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 |  | TOTAL
6000 | 32 | MpXX34-222222XC | 600 |  | 340 | 340 | 340 | 21 | 300 | 56
6000L | 32 | MpWE23-343434XC | 600 |  | 165 | 165 | 165 | 165 | 165 | 165 | 165 | 165 | 165
2001 | 32 | MpQW23-343421CR | 120 |  | 200 | 200 | 200 | 34
2016 | 32 | PPP8P4-343422DR | 500 |  | 266 | 266 | 266 | 266 | 266
This clm filled via [NAME] from linked sheet |  | This clm filled via [NAME] from linked sheet | This clm filled via [NAME] from linked sheet
 |  |  |  |  |  |  |  | Could be over 70 pallets for each part (22 put here for brevity)
 |  | Could be 300+ rows below these each with different parts
Spreadsheet: 21948d1210184669-time-formatting-excel-help-1
Sheet: Test file

00:00:00 |  | Can u sum or average these numbers?
00:00:06
00:02:22
[NAME]
00:01:25
00:25:21
00:10:02
00:02:13
[NAME]
00:07:06
00:08:35
00:41:25
00:04:23
00:34:56
00:28:51
00:12:28
[NAME]
00:28:15
[NAME]
00:28:10
00:26:02
[NAME]
00:01:40
Spreadsheet: 836825d1689674975-find-several-values-separated-by-a-comma-and-return-a-value-with-no-duplicates-search-dataset-1-
Sheet: Blad3

Art 1 | RS | #
27001:2022 4
27001:2022 4.1 | 6.48 | 147
27001:2022 4.2 | 6.01, 6.02, 6.09, 6.10, 6.11, 6.49, 6.50
27001:2022 4.3 | 6.51
27001:2022 4.4 | 6.45, 6.46, 6.47, 6.48, 6.49, 6.50, 6.51
27001:2022 5
27001:2022 5.1 | 6.33, 6.45 | 1, 52, 56, 57, 58, 99
27001:2022 5.2 | 6.46
27001:2022 5.3 | 6.41, 6,47 | 1, 54, 55
27001:2022 6
27001:2022 6.1
27001:2022 6.1.1 | 6.52 | 134, 145
27001:2022 6.1.2 | 6.38 | 4, 5, 135, 136
27001:2022 6.1.3 | 6.52 | 93, 137, 138
27001:2022 6.2 | 6.48 | 52, 145
27001:2022 6.3 | 6.38, 6,41 | 20
27001:2022 7
27001:2022 7.1 | 6.33 | 145
27001:2022 7.2 | 6.34 | 43, 55, 112
27001:2022 7.3 | 6.14, 6.15, 6.17, 6.18, 6.19, 6.20, 6.21, 6.22, 6.23, 6.24, 6.25, 6.41, 6.42 | 56, 57, 58
27001:2022 7.4 | 6.53 | 12
27001:2022 7.5
27001:2022 7.5.1 | 6.38 | 20, 57, 99
27001:2022 7.5.2 | 6.46, 6,54
27001:2022 7.5.3 | 6.55 | 57, 99
27001:2022 8
27001:2022 8.1 | 6.56 | 139
27001:2022 8.2 | 6.57 | 136
27001:2022 8.3 | 6.58 | 93
27001:2022 9
27001:2022 9.1 | 6.58, 6,59 | 2, 52, 94, 145
27001:2022 9.2
27001:2022 9.2.1 | 6.60 | 140
27001:2022 9.2.2 | 6.60 | 141
27001:2022 9.3
27001:2022 9.3.1 | 6.61 | 52
27001:2022 9.3.2 | 6.61 | 93, 136, 140, 145
27001:2022 9.3.3 | 6.61 | 134, 145
27001:2022 10
27001:2022 10.1 | 6.62 | 139
27001:2022 10.2 | 6.63 | 8, 29, 50, 62
Spreadsheet: mark_taylor__24725__ClickInTradingProducts
Sheet: Coal

Short Description Boxes: |  |  |  |  |  |  |  |  |  |  |  |  |  | FOR OPTIONS
Coal Physical |  | Specifications |  | Location |  | Term |  | Currency |  | Units |  | Option Type |  | Option Strike |  | Expiration Date
Physical Delivery |  | Steam Coal 1 |  | ARA (CIF) |  | Q3-1999 |  | USD |  | mt |  | Call
Option on Physical Delivery |  | Steam Coal 2 |  |  |  | Q4-1999 |  | GBP |  |  |  | Put
 |  | Steam Coal 3 |  |  |  | Q1-2000 |  | EUR |  |  |  | Quartely Calls
 |  | Rejection |  |  |  | Q2-2000 |  |  |  |  |  | Quartely Puts
 |  |  |  |  |  | Q3-2000
 |  |  |  |  |  | Q4-2000
Notes: | Physical only trading and non-standardised deals => not for Internet trading for another 6 mth-1year.
Long Descriptions
Specifications
Steam Coal 1 | Typical Specifications |  | NCV 6,000 kcal/kg | -- Calorific value, net as received
 |  |  | [NAME]  [1]% | -- Percent by weight of [NAME], dry
 |  |  | [NAME] [14.5]% | -- Percent by weight of Ash, dry
 |  |  | [NAME] [5-8]% | -- Percent by weight of Moisture, as received
 | Reject Specifications |  | NCV <5,500 kcal/kg
 |  |  | [NAME]1%
 |  |  | [NAME]20%
 |  |  | [NAME]10%
 | Non-spec Price Adjustments | [NAME] | -- Ratio of NCV delivered coal to NCV contract coal.  The Contract Base Price is
 |  |  | multiplied by this ratio to determine the Final Price, not including
 |  |  | any adjustment required for out of spec Ash or [NAME].
 |  | Ash | -- $[1] per [0.1]% greater than maximum specification
 |  | [NAME] | -- $[1] per [0.1]% greater than maximum specification
Location | ARA | Amsterdam-Rotterdam-Antwerp port area
Delivery Terms | CIF | Cost, Insurance and Freight as defined by Incoterms 1990
Units | mt | metric tonne [1000 kg]
Examples:
 | Physical Delivery, Steam Coal 1 at ARA (CIF), Q3-1999
 | This is a contract for Physical Delivery of steam coal meeting the specifications of Steam Coal 1, to be delivered
 | at ARA (CIF) during Q3-1999.
Spreadsheet: darrell_schoolcraft__7774__imbalsumm0106
Sheet: Calpine

 | Calpine So. Point Power Del
 | 78113
Day | Measured | Scheduled
1 | -52917 | -37500
2 | -38872 | -40000
3 | -34322 | -40000
4 | -44422 | -29550
5 | -41682 | -45983
6 | -60431 | -68633
7 | -62347 | -50000
8 | -65929 | -79625
9 | -52330 | -64819
10 | -42397 | -50000
11 | -61555 | -49841
12 | -55007 | -65300
13 | -63094 | -65300
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-05-31 00:00:00 |  |  | -357096.85
2001-06-13 00:00:00
Spreadsheet: 3c294a5e-8d69-4568-88c2-a55f5707a99e
Sheet: ChemOffice1

Entry | Structure | Compound ID | Primary Screening Activity 10.2µM (%) | Retested? | Retest IC50 T.b.brucei (µM) | Restest IC50 HEK (µM) | Estimated Selectivity Index
1 | C17H10ClN3O3 | WEHI-0055195 | 100 | Yes, parent compound | 0.169 | >41.7 | 246
2 | C16H14ClN3O2 | WEHI-0069265 | 99 | Yes, did not pass medicinal chemistry analysis | 0.8508 | 41.67
3 | C18H13N3O3 | WEHI-0069824 | -2 | No
4 | C19H13ClN2O3 | WEHI-0076299 | 2 | No
5 | C19H12ClN3O3 | WEHI-0079330 | 32 | No
6 | C19H11ClFN3O2 | WEHI-0079813 | 100 | Yes,  did not reconfirm | 18% at 10.4µM | NA | NA
7 | C20H14ClN3O3 | WEHI-0082839 | 0 | No
8 | C18H12BrN3O2 | [NAME] | 16 | No
9 | C22H19N3O4 | WEHI-0085569 | 12 | No
10 | C21H16ClN3O3 | WEHI-0086989 | 15 | No
11 | C19H12BrN3O2 | WEHI-0087051 | 10 | No
12 | C20H14ClN3O2S | [NAME] | -4 | No
13 | C18H11N3O5S | WEHI-0105326 | 30 | No
14 | C18H11BrN2O4 | WEHI-0105334 | -3 | No
15 | C20H15N3O2 | WEHI-0105383 | 2 | No
16 | C19H12N4O4 | WEHI-0105455 | 4 | No
17 | C20H13ClN4O4 | WEHI-0105456 | 6 | No
18 | C20H14ClN3O3 | WEHI-0105462 | 0 | No
19 | C20H11FN4O2 | WEHI-1193373 | 0 | No
Spreadsheet: 789602d1659216056-top-3-test-sheet
Sheet: Sheet1

 |  |  |  | TOP 3 Highest tracking Codes
 | Company | Tracking Code |  | Rank | Company |  | Transporter ID
 | 1TXC | A2VN9G8H5ES4N0 |  | 1 | RRS |  | OMW727A430497F1
 | CKU | OMWBC57C629DB7B |  | 2 | CKU |  | OMWBC57C629DB7B
 | RRS | OMW727A430497F1 |  | 3 | RRS |  | A3MA075FNMGQP
 | RRS | A3MA075FNMGQP
 | RRS | A3MA075FNMGQP
 | CKU | OMWBC57C629DB7B
 | RRS | OMW727A430497F1
 | RRS | OMW727A430497F1
 | RRS | OMW727A430497F1
 | CKU | OMWBC57C629DB7B