tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 66bffee2-e637-471b-b64c-221eb271ed13
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: |  |  | 2014-04-17 12:14:05.350000
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.75 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.625 | 102.286 | 102.161 | 102.036 | 101.661
4.5 | 101.368 | 101.243 | 101.118 | 100.743 |  | Note: | Refer To Price [NAME]
4.375 | 100.523 | 100.398 | 100.273 | 99.898 |  |  | For all Price Adjs
4.25 | 99.958 | 99.833 | 99.708 | 99.083
4.125 | 99.145 | 99.02 | 98.895 | 98.27
4 | 98.147 | 98.022 | 97.897 | 97.272
3.875 | 97.108 | 96.983 | 96.858 | 96.233
3.75 | 96.233 | 96.108 | 95.983 | 95.358
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 102.244 | 102.119 | 101.994 | 101.619
3.75 | 101.888 | 101.763 | 101.638 | 101.263
3.625 | 101.483 | 101.358 | 101.233 | 100.858
3.5 | 100.908 | 100.783 | 100.658 | 100.283
3.375 | 100.153 | 100.028 | 99.903 | 99.278
3.25 | 99.35 | 99.225 | 99.1 | 98.475
3.125 | 98.871 | 98.746 | 98.621 | 97.996 |  | 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 | 2014-05-01 12:14:05.350000
30 DAY | 2014-05-16 12:14:05.350000
45 DAY | 2014-05-31 12:14:05.350000
60 DAY | 2014-06-15 12:14:05.350000
90 DAY | 2014-07-15 12:14:05.350000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 88607d1288383755-filtering-6-numbers
Sheet: Sheet1

A | B | C | D | E | F | >3 Odd | >3 Even | >2 Cons
440 | 441 | 442 | 824 | 825 | 842 | 0 | 1 | 1
293 | 702 | 719 | 962 | 857 | 43 | 1 | 0 | 0
320 | 145 | 62 | 779 | 117 | 588 | 0 | 0 | 0
660 | 548 | 119 | 718 | 97 | 184 | 0 | 1 | 0
677 | 221 | 772 | 946 | 287 | 893 | 1 | 0 | 0
272 | 710 | 269 | 609 | 55 | 125 | 1 | 0 | 0
92 | 571 | 731 | 308 | 952 | 459 | 0 | 0 | 0
678 | 519 | 386 | 979 | 114 | 943 | 0 | 0 | 0
213 | 659 | 298 | 837 | 481 | 168 | 1 | 0 | 0
197 | 949 | 676 | 747 | 671 | 362 | 1 | 0 | 0
400 | 253 | 225 | 538 | 53 | 398 | 0 | 0 | 0
510 | 797 | 47 | 845 | 245 | 131 | 1 | 0 | 0
384 | 260 | 605 | 664 | 138 | 429 | 0 | 1 | 0
444 | 325 | 662 | 769 | 781 | 819 | 1 | 0 | 0
622 | 7 | 374 | 783 | 618 | 620 | 0 | 1 | 0
471 | 226 | 960 | 362 | 890 | 721 | 0 | 1 | 0
42 | 162 | 558 | 766 | 789 | 4 | 0 | 1 | 0
155 | 847 | 920 | 760 | 372 | 511 | 0 | 0 | 0
841 | 378 | 361 | 497 | 663 | 825 | 1 | 0 | 0
898 | 239 | 994 | 711 | 599 | 373 | 1 | 0 | 0
690 | 494 | 479 | 880 | 29 | 570 | 0 | 1 | 0
876 | 771 | 875 | 278 | 741 | 503 | 1 | 0 | 0
272 | 822 | 443 | 924 | 952 | 558 | 0 | 1 | 0
988 | 815 | 315 | 352 | 201 | 51 | 1 | 0 | 0
753 | 863 | 312 | 155 | 839 | 436 | 1 | 0 | 0
60 | 737 | 754 | 241 | 832 | 830 | 0 | 1 | 0
937 | 647 | 499 | 784 | 125 | 291 | 1 | 0 | 0
441 | 724 | 101 | 423 | 749 | 732 | 1 | 0 | 0
762 | 719 | 772 | 738 | 68 | 694 | 0 | 1 | 0
124 | 999 | 561 | 817 | 495 | 809 | 1 | 0 | 0
515 | 327 | 687 | 575 | 785 | 292 | 1 | 0 | 0
974 | 742 | 891 | 719 | 548 | 178 | 0 | 1 | 0
41 | 544 | 771 | 820 | 102 | 655 | 0 | 0 | 0
911 | 442 | 523 | 838 | 596 | 989 | 0 | 0 | 0
637 | 138 | 56 | 45 | 382 | 399 | 0 | 0 | 0
78 | 762 | 1000 | 346 | 91 | 674 | 0 | 1 | 0
555 | 595 | 414 | 927 | 779 | 164 | 1 | 0 | 0
553 | 606 | 463 | 84 | 253 | 178 | 0 | 0 | 0
699 | 602 | 595 | 249 | 614 | 617 | 1 | 0 | 0
812 | 588 | 781 | 932 | 431 | 641 | 0 | 0 | 0
85 | 292 | 351 | 497 | 489 | 489 | 1 | 0 | 0
107 | 749 | 947 | 829 | 465 | 860 | 1 | 0 | 0
536 | 858 | 500 | 10 | 285 | 546 | 0 | 1 | 0
667 | 721 | 237 | 355 | 561 | 936 | 1 | 0 | 0
522 | 661 | 426 | 551 | 517 | 767 | 1 | 0 | 0
247 | 71 | 238 | 139 | 184 | 139 | 1 | 0 | 0
520 | 684 | 377 | 824 | 778 | 706 | 0 | 1 | 0
974 | 685 | 685 | 103 | 934 | 878 | 0 | 0 | 0
624 | 917 | 589 | 352 | 986 | 89 | 0 | 0 | 0
257 | 520 | 19 | 649 | 11 | 891 | 1 | 0 | 0
898 | 394 | 197 | 565 | 68 | 896 | 0 | 1 | 0
671 | 878 | 552 | 699 | 300 | 276 | 0 | 1 | 0
45 | 149 | 202 | 877 | 22 | 201 | 1 | 0 | 0
581 | 851 | 552 | 784 | 266 | 358 | 0 | 1 | 0
86 | 361 | 573 | 1000 | 383 | 586 | 0 | 0 | 0
341 | 45 | 484 | 420 | 232 | 77 | 0 | 0 | 0
339 | 487 | 362 | 441 | 69 | 792 | 1 | 0 | 0
693 | 415 | 28 | 624 | 496 | 480 | 0 | 1 | 0
460 | 520 | 150 | 740 | 910 | 713 | 0 | 1 | 0
183 | 265 | 213 | 96 | 847 | 81 | 1 | 0 | 0
Spreadsheet: 137030d1326915911-count-occurence-of-value-over-multiple-sheets-using-row-and-column-header-es-qa-weekly-testing-execution-summary
Sheet: M

 | Passed | Not Completed | N/A | Failed
10/01/11-10/07/11 | 0 | 0 | 1 | 0
10/08/11-10/14/11 | 71 | 2 | 0 | 0
10/15/11-10/21/11 | 10 | 1 | 0 | 0
10/22/11-10/28/11 | 805 | 3 | 0 | 5
10/29/11-11/04/11 | 913 | 7 | 3 | 5
11/05/11-11/11/11 | 207 | 2 | 8 | 6
11/12/11-11/18/11 | 299 | 4 | 7 | 9
11/19/11-11/25/11 | 1426 | 10 | 1 | 9
11/26/11-12/02/11 | 864 | 7 | 19 | 11
12/03/11-12/09/11 | 76 | 3 | 2 | 6
12/10/11-12/16/11 | 1 | 0 | 0 | 0
Spreadsheet: 777110d1650176847-count-no-of-cases-based-on-a-given-date-range-excelforum_countnocase-2
Sheet: Defect

 | S/No | Car | Defect | WO/JR No. | Since | Status | Clear | >3 | No of Case | >7
 | 1 | 28 |  | NA | 2021-12-01 00:00:00 | Pending Investigation | 2021-12-10 00:00:00
 | 2 | 16 |  | NA | 2021-12-08 00:00:00 | Pending Investigation | 2021-12-31 00:00:00
 |  | 5 |  |  | 06-12-21
Spreadsheet: 672918d1587066870-comparing-2-columns-to-see-if-it-is-duplicated-book2
Sheet: Sheet1

 |  |  |  | Match formula is what I am trying to get at.
 |  |  |  | It has to have the same name in column 1 and column 2
 |  | Company 1 | Company 2 | Match | Match with trim |  |  | helper column |  |  | helper column with trim
 |  | Apple | Facebook |  |  | <-- [NAME] here?
 |  | Microsoft | Yahoo
 |  | Apple | Facebook
 |  | Microsoft | Facebook
 |  | Apple | Microsoft
 |  | Microsoft | Yahoo
Spreadsheet: geir_solberg__11269__10_15act
Sheet: Economics

 | Commodity Revenue (Cost) | Demand Charge | Total | Total Volume | $/Mwhr Commodity Cost | $/Mwhr Total Cost
Purchases
[NAME]. Cost Est. |  |  |  |  | 20 | 0
Incremental Purchases
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
SPS Pre
Artesia Balancing
Artesia Realtime
Sales
Incremental Sales
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
[NAME]
Artesia Balancing
Artesia Realtime
 |  |  |  |  |  |  | Heat | Fuel
Generation |  |  |  |  |  |  | Rate | Cost
4 Corners Unit 4 |  |  |  |  |  |  | 10.0576 | 1.3
4 Corners Unit 5 |  |  |  |  |  |  | 10.0576 | 1.3
PV Unit 1 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 2 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 3 |  |  |  |  |  |  | 10.16 | 0.6
Newman 1
Newman 2
Newman 3
GT 1
GT 2
GT1+ST1
GT2+ST1
Newman 4 |  |  |  |  |  |  |  | 1.96
Copper
Rio Grande 6
Rio Grande 7
Rio Grande 8
Total
Spreadsheet: 454749d1459960559-inserting-decimal-point-into-existing-column-of-numbers-example-for-cantosh
Sheet: Sheet1

Listing
0031
0223
0270
0271
0380
0380
0380
0380
0380
0382
0383
0388
0388
0388
0389
1125
03810
03811
03811
03812
03812
03819
03840
03841
03842
03843
03844
03849
6380
6390
09889
63400
63401
63402
63500
63501
63502
67020
67022
67024
77181
77181
77181
77181
77181
77181
77181
77181
77181
77181
78552
99591
99591
99591
99591
99591
99591
99591
99591
99591
99591
99591
99591
99591
99591
99591
99591
99591
99591
99591
99591
99591
99591
99591
99591
99591
99591
99591
99591
99592
99592
Spreadsheet: 865259d1712308385-place-individual-digits-from-a-number-into-seperate-cells-sample
Sheet: Sheet1

Number
1 |  |  |  |  | 1
234 |  |  | 2 | 3 | 4
4567 |  | 4 | 5 | 6 | 7
98765 | 9 | 8 | 7 | 6 | 5
123 |  |  | 1 | 2 | 3
Spreadsheet: 802036d1666612560-if-count-and-results-without-empty-spaces-formula-count-result-without-empty-cells
Sheet: Sheet1

 |  | expected results | incomplete formula
14 | 3 | 14
 | 14 | 23
23 |  | 1
 | 27
1 | 23
 | 6
 | 1
 | 17
 | 5
Spreadsheet: 769924d1645724646-return-blank-depending-on-another-cell-ex1
Sheet: Sheet1

Smith | 123 | 423 | New York | 45 | Paid | 9822 | X | X | X
Russo | 456 | 342 | Chicago | 32 |  | 9125 | X | X | X |  | Should not show up (nothing on Column F)
White | 365 | 963 | Chicago | 46 | Paid | 9672 | X | X | X
Spreadsheet: 736315d1623496379-calculating-running-average-cost-example_avg_cost
Sheet: Sheet1 (2)

Limits:
Trade Symbol | Transaction | Date | [NAME] | Quantity | Price | Total Cost | Buy Fees | Sell Fees | Running Qty | [NAME] | Current Balance (FIFO) | Sales Only -  Separated for RAW data |  | Gain (Loss) P & L
 | Buy | 2021-02-22 00:00:00 |  | 3.514923 | 14.21 |  | 0 | 0
 |  |  |  | 1.95554 | 12.8 |  | 0 | 0
 | Buy | 2021-02-23 00:00:00 |  | 2.121327 | 11.78 |  | 0 | 0
 | Buy | 2021-03-24 00:00:00 |  | 374.242645 | 13.45 |  | 0 | 0
 | Sell | 2021-03-29 00:00:00 | Short | -381.834442 | 13.34 |  | 0 | 0
 | Buy | 2021-04-17 00:00:00 |  | 13.380624 | 37.72 |  | 0 | 0
 |  |  |  | 12.706329 | 39.39 |  | 0 | 0
 | Buy | 2021-04-27 00:00:00 |  | 28.600846 | 35.18 |  | 0 | 0
 | Buy | 2021-05-04 00:00:00 |  | 74.626678 | 67.52 |  | 0 | 0
 |  |  |  | 270.208195 | 74.56 |  | 0 | 0
 | Sell | 2021-05-04 00:00:00 | Short | -399.522672 | 78.52 |  | 0 | 0
 | Buy | 2021-05-04 00:00:00 |  | 179.734944 | 84.04 |  | 0 | 0
 |  | 2021-05-05 00:00:00 |  | 49.622456 | 101.4 |  | 0 | 0
 |  |  |  | 246.20782 | 102.55 |  | 0 | 0
 |  |  |  | 165.37101 | 103.4 |  | 0 | 0
 | Sell | 2021-05-05 00:00:00 | Short | -640.93623 | 104.18 |  | 0 | 0
 | Buy | 2021-05-05 00:00:00 |  | 30.301633 | 99.03 |  | 0 | 0
 |  | 2021-05-06 00:00:00 |  | 276.819944 | 145.41 |  | 0 | 0
 | Sell | 2021-05-06 00:00:00 | Short | -307.121577 | 168.49 |  | 0 | 0
 | Buy | 2021-05-06 00:00:00 |  | 277.1079 | 182.23 |  | 0 | 0
 |  |  |  | 138.149505 | 182.77 |  | 0 | 0
 | Sell | 2021-05-08 00:00:00 | Short | -107.381606 | 127.43 |  | 0 | 0
Totals:
Average Price:
Spreadsheet: 211034d1359639932-simple-filter-g_r_n_2013-2014
Sheet: Sheet2

Date | Item | unit | issue
21-12-12 | knife | pcs | 4
21-12-12 | piller | pcs | 2
21-12-12 | Belna | pcs | 2
21-12-12 | Lighter | pcs | 1
21-12-12 | Chopper | pcs | 2
21-12-12 | Grater | pcs | 1
21-12-12 | [NAME] | pcs | 1
21-12-12 | plastic jar | pcs | 18
21-12-12 | [NAME] | pcs | 12
21-12-12 | [NAME] | pcs | 18
21-12-12 | [NAME] | pcs | 1
21-12-12 | chakni | pcs | 1
21-12-12 | Tea chakni | pcs | 1
21-12-12 | Mixi | pcs | 1
21-12-12 | water glass | pcs | 9
21-12-12 | [NAME] | pcs | 2
21-12-12 | bowl | pcs | 12
21-12-12 | [NAME] | pcs | 1
21-12-12 | Dabbu | pcs | 2
21-12-12 | Spoon (big & small) | pcs | 4
21-12-12 | Tea Swaspan | pcs | 2
21-12-12 | pressure [NAME] | pcs | 1
21-12-12 | chanta | pcs | 2
21-12-12 | Indian Frypan | pcs | 2
21-12-12 | Balti | pcs | 1
21-12-12 | Handi | pcs | 5
21-12-12 | [NAME] | pcs | 7
21-12-12 | Tray | pcs | 6
 |  | pcs
Spreadsheet: 59340d1259835968-macro-to-find-and-delete-re-inspection-tracker
Sheet: Data

Date Complaint Open | Date Complaint Came To Department | Date Re-Inspection Requested | Date Of Review | How many Working Days Has The Complaint Been Open | Date Complaint Open Ref | Todays Date Ref | complaint total | [NAME] | Policy Number | Work Type
 |  |  |  | #N/A | #N/A | 235 | 1
2009-11-03 00:00:00 | 2009-11-13 00:00:00 | 2009-11-13 00:00:00 | 2009-12-03 00:00:00 | 22 | 213 | 235 | 1 | AH67 | 4500756302 | Verbal Complex
2009-11-17 00:00:00 | 2009-11-18 00:00:00 | 2009-11-27 00:00:00 | 2009-12-04 00:00:00 | 12 | 223 | 235 | 1 | HW12 | 39221611 | Verbal Complex
2009-11-12 00:00:00 | 2009-11-16 00:00:00 | 2009-11-20 00:00:00 | 2009-12-03 00:00:00 | 15 | 220 | 235 | 1 | HW12 | 4925291100 | Verbal Complex
2009-11-24 00:00:00 | 2009-11-27 00:00:00 | 2009-12-02 00:00:00 | 2009-12-03 00:00:00 | 7 | 228 | 235 | 1 | HEEK | 4434285200 | Verbal Complex
2009-10-27 00:00:00 | 2009-10-28 00:00:00 | 2009-11-10 00:00:00 | 2009-12-04 00:00:00 | 27 | 208 | 235 | 1 | TYGR | 2941213301 | Verbal Standard
2009-11-13 00:00:00 | 2009-11-17 00:00:00 | 2009-11-19 00:00:00 | 2009-12-04 00:00:00 | 14 | 221 | 235 | 1 | HW12 | 3645742601 | Verbal Complex
2009-10-30 00:00:00 | 2009-11-12 00:00:00 | 2009-11-16 00:00:00 | 2009-12-04 00:00:00 | 24 | 211 | 235 | 1 | SPP3 | 3944435501 | Verbal Complex
2009-11-16 00:00:00 | 2009-11-23 00:00:00 | 2009-11-24 00:00:00 | 2009-12-07 00:00:00 | 13 | 222 | 235 | 1 | SPP3 | 4028124601 | Verbal Complex
2009-11-04 00:00:00 | 2009-11-20 00:00:00 | 2009-11-26 00:00:00 | 2009-11-04 00:00:00 | 21 | 214 | 235 | 1 | HW12 | 4108747500 | Verbal Complex
2009-11-25 00:00:00 | 2009-11-30 00:00:00 | 2009-11-30 00:00:00 | 2009-12-04 00:00:00 | 6 | 229 | 235 | 1 | HEEK | 4133674201 | Verbal Complex
2009-11-24 00:00:00 | 2009-11-25 00:00:00 | 2009-11-27 00:00:00 | 2009-11-03 00:00:00 | 7 | 228 | 235 | 1 | HW12 | 4211328900 | Verbal Complex
2009-11-13 00:00:00 | 2009-11-19 00:00:00 | 2009-11-19 00:00:00 | 2009-12-03 00:00:00 | 14 | 221 | 235 | 1 | HW12 | 4832375300 | Verbal Standard
2009-11-19 00:00:00 | 2009-11-20 00:00:00 | 2009-11-30 00:00:00 | 2009-12-07 00:00:00 | 10 | 225 | 235 | 1 | AD78 | 3706131800 | Verbal Standard
2009-11-19 00:00:00 | 2009-11-20 00:00:00 | 2009-11-30 00:00:00 | 2009-12-07 00:00:00 | 10 | 225 | 235 | 1 | AD78 | test | Verbal Standard
Spreadsheet: 706261d1606573894-create-unique-list-from-multiple-columns-using-unique-course-test-ans
Sheet: Sheet1

 | Course 1 | Course 2 | Course 3 | Course 4 | Course 5
 | Python for Engineers | Ground Improvement Training | Airphoto Interpretation | Flow3D | GeoStudio Training
 | Facilitation Training | [NAME] | Feedback Training | Other | Other
 | Python for Engineers | Televiewer Data Interpretation | Drilling 201 | Construction Monitor Training | Project Management
 | Civil Geotech Training | Drilling 101 | Glacial Deposition | GeoStudio Training | Drilling 201
 | Speak Like a Leader [NAME] | Python for Engineers | [NAME]
 | Drilling 101 | [NAME] | Construction Monitor Training | [NAME] | Glacial Deposition
 | HEC-RAS 1D & 2D | [NAME] | [NAME] | GeoStudio Training | Glacial Deposition
 | Python for Engineers | Dams 101 | [NAME] | GeoStudio Training
 | Glacial Deposition | Pipeline Lead Inspector Training | Civil Geotech Training | Speak Like a Leader [NAME] | Airphoto Interpretation
 | Airphoto Interpretation | Drilling 101 | Pipeline New Inspector Training | Construction Monitor Training | Hydrogeology 101
 | Glacial Deposition | Structural Geology | [NAME] | Pipeline Construction and Geotechnical Field Support | Drilling 101
 | Speak Like a Leader [NAME] | Leadership Foundation | Python for Engineers | HEC-RAS 1D & 2D | Flow3D
Sl No | Course Names
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
Spreadsheet: 787893d1658140036-kpi-tracking-with-smile-cry-kpi-tacking-file
Sheet: KPI

 |  | Description | Target | YTD |  | Jan | Feb | Mar | Apr | May | Jun
 | 1 | [NAME] | 90 |  |  | N/A | N/A | N/A | N/A | N/A |  | This activities, we consider to take the last result as acheivement, and actual KPI will do only 1 time per year in Jun)
 | 2 | Sugar | 80 |  |  | 80 | 100 | 40 | 90
 | 3 | Candy | 100 |  |  | 100 | 100 | 20 | 100
 | 4 | Water | 50 |  |  | N/A | N/A | N/A | N/A | N/A |  | This activities, we consider to take the last result as acheivement
 | 5 | Electricity | 50 |  |  | N/A | N/A | N/A | N/A | 50 | 60 | This activities, we consider to take the last result as acheivement
Spreadsheet: 108102d1305203446-worksheet-text-consolidation-invitee-list-sample
Sheet: Evan Feily

First Name | Last Name | Title (VP,SVP, DIR, MGR) | Functional Area | Location City | Location State
[NAME] | Sirisky | VP, Assistant [NAME] | Controllers Group | NY | NY
Erika | [NAME] | Director | PRC, SOX | NY | NY
[NAME] | Tran | Director | Corpororate Accounting | Houston | TX
Cathy | Schmiedel | Director | Financial Planning and Analysis | NY | NY
[NAME] | Yaniro | Manager | SEC Reporting | NY | NY
Lana | Tsalyuk | Manager | Financial Reporting | NY | NY
Vessi | Nikiforova | Sr. Manager | Technical Accounting and Polices | NY | NY
[NAME] | Terrell | Manager | PRC, SOX | NY | NY
Anisa | [NAME] | Manager | PRC, SOX | NY | NY
Tomiko | Chavis | Manager | Corporate Accounting | Houston | TX
Kaye | [NAME] | Manager | Corporate Accounting | Houston | TX
Curtis | Walker | Manager | Corporate Accounting | Houston | TX
Spreadsheet: 36477d1234361412-moving-rows-to-anoter-worksheet-based-on-certain-criteria-kpi-1-
Sheet: Steve

Address Book Entry | Close Date | Number of Analyzers required | Total Capital | Annual Number of Cartridges | Annual Cartridge Revenue | Status | Confidence Rating | Revenue
 |  | 0 | 0 |  | 0 |  | 0 | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Spreadsheet: 268425d1380634035-vlookup-help-me-piston1
Sheet: Sheet2

BH |  |  |  |  |  |  |  |  | BHIPL
ID | ØD1 |  |  |  |  |  |  |  | ID | ØD1
20 | 28 |  |  |  |  |  |  |  | 20 | 30
25 | 33 |  |  |  |  |  |  |  | 25 | 40
30 | 38 |  |  |  |  |  |  |  | 30 | 42
40 | 48 |  |  |  |  |  |  |  | 40 | 48
50 | 58 |  |  |  |  |  |  |  | 50 | 66
60 | 70 |  |  |  |  |  |  |  | 60 | 75
63 | 73 |  |  |  |  |  |  |  | 63 | 80
Spreadsheet: 161364d1339508524-car-ratings-excel-assignment-e03m1autos-xlsx-e03m1autos_santosclaudia
Sheet: Data

Mid-Sized Passenger Car Ratings
Model | Efficiency | Affordability | Appearance | Durability | Acceleration | Overall Rating | Ratings
Matador | 8.2 | 9 | 7 | 8 | 8.4
Imperial | 7.5 | 8.5 | 6.5 | 7.5 | 8
Reliance | 6.7 | 6.8 | 6.3 | 5.5 | 7.5
Captivator | 9 | 7.5 | 8.2 | 9.2 | 8.3
Overall Category
Spreadsheet: 127116d1320169286-return-last-text-value-in-same-row-in-excel-book1_mdispbee
Sheet: Sheet1

ITEM (text) | NOTES (text) | LAST REVIEW RESULT | WEEK 1 | WEEK 2 | WEEK 3 | WEEK 4 | WEEK 5 | WEEK 6 | WEEK 7 | WEEK 8 | WEEK 9 | WEEK 10
Item 1 | Note 1 | abc10 | abc1 | abc2 | abc3 |  | [NAME] | abc6 | [NAME] | abc8 |  | abc10
Item 2 | Note 2 | abc9 | abc1 | abc2 | abc3 | abc4 | [NAME] | abc6 | [NAME] | abc8 | abc9
Item 3 |  | abc3 | abc1 | abc2 | abc3
Item 4 |  | [NAME] | abc1 | abc2 | abc3 | abc4 | [NAME] | abc6 | [NAME]
Item 5 |  | abc10 | abc1 | abc2 | abc3 | abc4 | [NAME] | abc6 | [NAME] | abc8 | abc9 | abc10
Item 6 | Note 6 | abc1 | abc1
Item 7 |  | abc9 | abc1 | abc2 | abc3 |  |  |  |  | abc8 | abc9
Item 8 | Note 8 | abc10 |  |  |  |  |  |  |  | abc8 | abc9 | abc10
 |  |  |  |  |  |  |  |  |  |  | abc9
Spreadsheet: 108862d1305815057-auto-fill-data-from-from-worksheet-to-another-student_payment_log_test
Sheet: PG vlookup

721030200000 | Eng. GSRA Fee Payment |  | 114469
721030200001 | Eng. GSRA Fee Payment |  | 114469
722400000025 | Regent's Fellowship | U001823 | 114552
722400000026 | Regent's Fellowship | U001823 | 114552
722400000030 | Rackham Fellowship | U001829 | 114630
722400000031 | Rackham Fellowship | U001829 | 114630
722400000041 | [NAME] | U001832 | 114862
722400000042 | [NAME] | U001832 | 114862
722400000116 | Supplemental Instruction | U004454 | 170003
722400000125 | Named & Deans Fellowship | U001833 | 308536
722400000126 | Named & Deans Fellowship | U001833 | 308536
722400000190 | NR-Rosina | [NAME] | 49578
722400000300 | Penner Discretionary | C182106 | 182106
722400000301 | Penner Discretionary | C182106 | 182106
722400000306 | [NAME] | U015705 | 178159
722400000327 | [NAME] start-up | U017770 | 179109
722400000392 | Steiner start-up | [NAME] | 179107
722400000431 | GSRP Gershman | F023071 | 61626
722400000440 | McDunn Fellowship | F023646 | 149683
722400000442 | McDunn Fellowship | F023646 | 149683
722400000446 | NESSF Zhao | F023543 | 62162
722400000450 | Andronova Student Award | U021844 | 315837
722400000451 | Andronova Student Award | U021844 | 315387
722400000455 | McDunn Fellowship | F023646 | 62295
722400000460 | NR-GSRP Gershman | F023071 | 149598
722400000465 | NR-GSRP Raines | F023184 | 149622
722400000470 | NR-NESSF Zhao | F023543 | 149673
722400000480 | NR-Misra NESSF | F021111 | 59379
722400000481 | Misra NESSF | F021111 | 59379
722400000511 | Communications | U013335 | 176838
722400000535 | NR-GSRP Kroodsma | F025544 | 64562
722400000536 | GSRP Kroodsma | F025544 | 64562
722400000536 | GSRP Raines | F023184 | 61759
722400000540 | NR-GSRP Feldt | F025503 | 64511
722400000541 | GSRP Feldt | F025503 | 64511
722400000547 | Lepri Discretionary | U017040 | 178714
722400000550 | NR-GSRP Gruesbeck | F025615 | 115829
722400000556 | GSRP Gruesbeck | F023071 | 64646
722400000560 | NR - NASA - Katus | F025502 | 64509
722400000561 | NASA - Katus | F025502 | 64509
722400000562 | NR-NASA - Katus | F025502 | 64509
722400000565 | NR - NASA - Curry | F025527 | 64543
722400000566 | NASA - Curry | F025502 | 64509
722400000567 | NR - NASA - Curry | F025502 | 64509
722400000571 | NSF - Fan | F026012 | 65079
722400000572 | NR - NSF - Fan | F026012 | 65079
722400000585 | Roesler DoE Fellowship | U030644 | 186761
722400000590 | Reed DoE Fellowship | [NAME] | 186815
722400000601 | Rood Discretionary | U017778 | 179105
722400000605 | Nagy Discretionary | C103728 | 103728
722400000682 | Zurbuchen Discretionary | U003809 | 169813
722400000682 | Zurbuchen Discretionary | U003809 | 169813
722450001066 | Rood Startup | U015704 | 178158
722450001190 | Nagy Discretionary | C103728 | 103728
722450001190 | Najib Fellowship | F018324 | 148485
722450001195 | Najib Fellowship | F018324 | 56211
722450001202 | Fisk discretionary | C136890 | 136890
 | Reed DoE Fellowship | [NAME] | 186815
Spreadsheet: 732513d1621001451-multiple-match-data-excel-exampleindexandaggregate
Sheet: Sheet2

Table A |  |  |  |  |  | Table B
ID | AMOUNT |  |  | dif |  | ID | AMOUNT
A100 | -50 |  |  |  |  | A100 | -100
C100 | 300 |  |  |  |  | C100 | 300
B100 | -200 |  |  |  |  | B100 | 300
D100 | -87 |  |  |  |  | A100 | -50
E100 | 1020 |  |  |  |  | C100 | -200
 |  |  |  |  |  | B100 | -200
 |  |  |  |  |  | D100 | 667
 |  |  |  |  |  | D100 | -1300
 |  |  |  |  |  | D100 | -87
 |  |  |  |  |  | E100 | -1020
 |  |  |  |  |  | E100 | 1020
 |  |  |  |  |  | E100 | 6000