tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 158188d1338044292-finding-out-the-pair-of-points-location-with-minimum-distances-closest_points-2-
Sheet: Sheet1

Pt# | X | Y | Nearest Pt# | Nearest Pt# No Dupes
1 | 4 | 1 | 5 | 5 |  |  | 2.23606797749979 | 7.615773105863909 | 3.605551275463989 | 1 | 5.830951894845301 | 4.242640687119285
2 | 5 | 3 | 5 | 5 |  | 2.23606797749979 |  | 5.385164807134504 | 3.16227766016838 | 2 | 5 | 2.23606797749979
3 | 7 | 8 | 7 | 7 |  | 7.615773105863909 | 5.385164807134504 |  | 6.403124237432849 | 7.280109889280518 | 6.324555320336759 | 4
4 | 2 | 4 | 6 | 6 |  | 3.605551275463989 | 3.16227766016838 | 6.403124237432849 |  | 4.242640687119285 | 2.23606797749979 | 5
5 | 5 | 1 | 1 |  |  | 1 | 2 | 7.280109889280518 | 4.242640687119285 |  | 6.403124237432849 | 3.605551275463989
6 | 1 | 6 | 4 |  |  | 5.830951894845301 | 5 | 6.324555320336759 | 2.23606797749979 | 6.403124237432849 |  | 6.324555320336759
7 | 7 | 4 | 2 | 2 |  | 4.242640687119285 | 2.23606797749979 | 4 | 5 | 3.605551275463989 | 6.324555320336759
Spreadsheet: 810579d1671863201-filtering-data-book2test
Sheet: Sheet1

 |  |  | Subject 1 | Subject 2 | Subject 3 | Subject 4 | Subject 5 | Subject 6 | Subject 7 | Subject 8 |  |  |  | Subject A | Subject B | Subject C |  | Result
 |  | Student 1 |  |  | 40 | 47 |  | 43 | 50 | 53 |  |  |  |  |  |  |  | student 1
 |  | Student 2 |  |  | 30 |  |  | 22 |  | 28 |  |  |  |  |  |  |  | student 2
 |  | Student 3 |  |  | 46 |  |  | 65 |  |  |  |  |  |  |  |  |  | student 3
 |  | Student 4 |  |  | 39 |  |  | 43 |  |  |  |  |  |  |  |  |  | student 4
 |  | Student 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 60 |  | student 11
 |  | Student 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | student 12
 |  | Student 7 |  |  |  |  | 50 | 60 |  |  |  |  |  |  |  |  |  | student 13
 |  | Student 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | student 14
 |  | Student 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | student 15
 |  | Student 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | student 16
 |  | Student 11 |  |  | 41 |  |  | 67 | 40 | 50 |  |  |  |  |  |  |  | student 22
 |  | Student 12 |  |  | 17 |  | 22 | 25 |  | 28 |  |  |  |  |  |  |  | student 30
 |  | Student 13 |  |  |  |  | 40 |  |  |  |  |  |  |  |  |  |  | student 34
 |  | Student 14 | 13 | 20 | 10 | 19 | 0 | 15 | 21 | 25 |  |  |  |  |  |  |  | student 35
 |  | Student 15 |  | 71 | 55 |  | 52 | 43 |  |  |  |  |  |  |  |  |  | student 37
 |  | Student 16 |  |  | 50 |  |  |  |  | 41 |  |  |  |  |  |  |  | student 40
 |  | Student 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | student 42
 |  | Student 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | student 43
 |  | Student 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | student 45
 |  | Student 20 |  |  |  |  |  | 70 |  |  |  |  |  |  |  |  |  | student 46
 |  | Student 21 |  |  |  |  |  |  | 55 | 51 |  |  |  |  |  |  |  | student 47
 |  | Student 22 |  |  | 51 |  |  | 39 |  | 51 |  |  |  |  |  |  |  | student 50
 |  | Student 23
 |  | Student 24 |  |  |  |  |  | 50
 |  | Student 25
 |  | Student 26 |  |  | 50 |  |  | 59
 |  | Student 27
 |  | Student 28
 |  | Student 29
 |  | Student 30 |  |  | 40 |  |  | 50
 |  | Student 31
 |  | Student 32 |  |  |  |  |  | 50
 |  | Student 33 |  |  |  |  |  |  |  | 51
 |  | Student 34 |  |  |  |  |  | 21
 |  | Student 35 |  |  | 43 |  | 50 | 44
 |  | Student 36
 |  | Student 37 |  |  | 10 |  |  | 18 |  | 29
 |  | Student 38 |  |  |  |  |  | 79 |  | 67
 |  | Student 39
 |  | Student 40 |  |  | 43
 |  | Student 41
 |  | Student 42 |  |  | 33 |  | 50 | 53 | 48 | 50
 |  | Student 43 |  |  | 52 |  |  | 43 |  | 50
 |  | Student 44
 |  | Student 45 |  |  | 43 |  | 52 | 52 |  | 56
 |  | Student 46 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Student 47 |  |  | 40 |  |  | 52 |  | 50
 |  | Student 48
 |  | Student 49 |  |  |  |  |  | 64
 |  | Student 50 |  |  | 10 |  |  | 31
Spreadsheet: 772394d1647256074-identify-consecutive-number-strings-book1
Sheet: Sheet1

2803
5953
1916
2853
1234
3811
3414
3854
0418
2345
0334
4705
0932
4530
4932
0637
Spreadsheet: 788087d1658259110-implementing-a-few-restrictions-on-a-calendar-excel-shared-prototype-1
Sheet: December

 | Absence Type Key | V | Vacation |  |  | P | Personal |  |  | S | Sick |  |  | Custom 1 |  |  |  | Custom 2
 | December | Dates of Absence
 | Employee Name | 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 | Total Days
 | Employee 1
 | Employee 2
 | Employee 3
 | Employee 4
 | Employee 5
Spreadsheet: 35062d1232548003-countind-dates-on-a-different-xls-file-book1
Sheet: Sheet1

2009-01-01 00:00:00
 |  | how many were created on each date
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-01 00:00:00
2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-02-01 00:00:00
3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-03-01 00:00:00
4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-04-01 00:00:00
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-05-01 00:00:00
6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-06-01 00:00:00
7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-07-01 00:00:00
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-08-01 00:00:00
9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-09-01 00:00:00
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-12-01 00:00:00
Spreadsheet: 145233d1331398447-northwind-the-spreadsheet-northwind-the-ss
Sheet: Payroll

ID | Company | Last Name | First Name | Gross Pay | Insurance | Taxes | etc. Deductions | Net Pay
1 | Northwind Traders | [NAME] | [NAME]
2 | Northwind Traders | [NAME] | [NAME]
3 | Northwind Traders | Kotas | Jan
4 | Northwind Traders | Sergienko | Mariya
5 | Northwind Traders | Thorpe | [NAME]
6 | Northwind Traders | Neipper | [NAME]
7 | Northwind Traders | Zare | [NAME]
8 | Northwind Traders | [NAME] | [NAME]
9 | Northwind Traders | Hellung-Larsen | Anne
Spreadsheet: 132196d1323588490-creating-individual-rosters-from-raw-data-roster-example
Sheet: Central Roster

Emp ID | Emp Name | Manager
1111 | Employee 1 | [NAME]
1112 | Employee 2 | [NAME]
1113 | Employee 3 | [NAME]
1114 | Employee 4 | [NAME]
1115 | Employee 5 | [NAME]
1116 | Employee 6 | [NAME]
1117 | Employee 7 | [NAME]
1118 | Employee 8 | [NAME]
1119 | Employee 9 | [NAME]
1120 | Employee 10 | [NAME]
1121 | Employee 11 | [NAME]
1122 | Employee 12 | [NAME]
1123 | Employee 13 | [NAME]
1124 | Employee 14 | [NAME]
1125 | Employee 15 | [NAME]
Spreadsheet: 846207d1697486126-conditional-formatting-not-consistent-with-min-max-functions-price-comparison
Sheet: Sheet1

 | Size in Ounces/Grams |  |  |  | Price per  can/package |  |  |  | Price per Ounce/Gram
Product | Store 1 | Store 2 | Store 3 | Store 4 | Store 1 | Store 2 | Store 3 | Store 4 | Store 1 | Store 2 | Store 3 | Store 4
Tomatoes - Whole | 28 | 28 | 14.5 | 28 | 1.54 | 2.04 | 0.81 | 3.1
Black Beans | 27 | 15.5 | 16 | 15.5 | 1.64 | 1.64 | 1.85 | 1.48
[NAME] | 16 | 17.6 | 16 | 16 | 1.44 | 1.97 | 1.71 | 1.23
Tuna | 5 | 5 | 5 | 5 | 2.06 | 2.58 | 2.58 | 1.02
Chicken | 12.5 | 4.5 | 10 | 5 | 4.14 | 2.26 | 2.89 | 1.96
Sardines | 3.75 | 3.75 | 3.75 | 3.75 | 1.02 | 1.02 | 1.33 | 1.33
Salmon | 14.75 | 2.6 | 14.75 | 5 | 4.36 | 2.37 | 10.38 | 2.23
Spam | 12 | 12 | 7 | 2.5 | 3.1 | 2.89 | 2.58 | 1.58
Chili | 15 | 15 | 7.5 | 15 | 2.37 | 2.16 | 1.96 | 2.03
Soup - Tomato | 10.5 | 31.4 | 26 | 15.5 | 1.23 | 8.3 | 3 | 6.22
Soup - Clam Chowder | 18.8 | 16 | 15 | 18.8 | 2.35 | 5.5 | 3.4 | 2.35
[NAME] | 7 | 4 | 4 | 4 | 1.75 | 2.68 | 1.41 | 2.27
Pears - canned | 16 | 15.25 | 15 | 15.25 | 1.54 | 2.54 | 2.06 | 2.54
Peaches - canned | 8 | 8.25 | 15 | 15 | 1.23 | 1.23 | 2.54 | 2.54
Pumpkin | 15 | 15 | 15 | 29 | 2.6 | 3.1 | 2.72 | 4.41
Coconut Milk | 64 | 13.5 | 13.66 | 64 | 3.52 | 2.58 | 3.62 | 4.45
Bread flour | 80 | 80 | 80 | 9 | 6.22 | 3.83 | 5.08 | 7.88
All Purpose [NAME] | 48 | 80 | 16 | 32 | 10.38 | 6.22 | 7.26 | 3.1
Butter | 16 | 16 | 16 | 45 | 4.97 | 4.97 | 6.22 | 4.87
Milk | 128 | 64 | 128 | 64 | 3.7 | 4.14 | 6.22 | 2.04
Orange Juice | 52 | 89 | 59 | 128 | 3.93 | 6.53 | 4.14 | 6.22
Bananas | 1 | 1 | 0.75 | 1.5 | 0.44 | 0.74 | 1.02 | 3.41
[NAME] | 80 | 80 | 32 | 32 | 8.2 | 3.47 | 3.41 | 4.08
Spreadsheet: 108516d1305573368-consolidate-data-sample
Sheet: Sheet2

Exam ID | Exam Name | Question Number | Question Text | Choice Number | Choice Text | Choice Number | Choice Text | Choice Number | Choice Text | Choice Number | Choice Text | Choice Number | Choice Text
1 | Test1 | 1 | Question 1 | A | Choice A | B | Choice B | C | Choice C | D | Choice D | E | Choice E
1 | Test1 | 2 | Question 2 | A | Choice A | B | Choice B | C | Choice C | D | Choice D | E | Choice E
Spreadsheet: 864525d1711653229-count-instances-or-frequency-multiple-sheets-counting-position-appearances-in-baseball-excel-help-forum-roster-template-2024-03-22-mattg-
Sheet: Game 3

Date: |  | 2024-05-01 00:00:00 |  |  | Field: |  |  | Start Time: |  | 18:00:00
Home: |  |  |  |  | 3rd | Set Up
Visitors: |  |  |  |  | 1st | Clean Up
 |  |  |  |  | Inning
 |  | Player |  |  | Coach Pitch |  |  |  |  |  | Innings on Bench | Innings in Infield | Inninings in Outfield |  |  |  | [NAME]
Order |  | First | Last | # | 1 | 2 | 3 | 4 | 5 | 6
1 | 12 | [NAME] |  |  | 1B (3) | 1B (3) | 1B (3) | LF (7) | LF (7) | LF (7) |  |  |  |  | P (1)
2 | 11 | Ty |  |  | 2B (4) | 2B (4) | 2B (4) | RF (9) | RF (9) | RF (9) |  |  |  |  | C (2)
3 | 1 | [NAME] |  |  | 3B (5) | 3B (5) | 3B (5) | LCF () | LCF () | LCF () |  |  |  |  | 1B (3)
4 | 2 | [NAME] |  |  | LF (7) | LF (7) | LF (7) | 1B (3) | 1B (3) | 1B (3) |  |  |  |  | 2B (4)
5 | 4 | [NAME] |  |  | P (1) | P (1) | P (1) | [NAME] () | [NAME] () | [NAME] () |  |  |  |  | 3B (5)
6 | 5 | Willie |  |  | X | RF (9) | RF (9) | 3B (5) | 3B (5) | 3B (5) |  |  |  |  | SS (6)
7 | 10 | [NAME] |  |  | RF (9) | X | SS (6) | SS (6) | C (2) | C (2) |  |  |  |  | LF (7)
8 | 9 | [NAME] |  |  | SS (6) | SS (6) | X | 2B (4) | 2B (4) | 2B (4) |  |  |  |  | CF (8)
9 | 6 | Babe |  |  | LCF () | LCF () | LCF () | X | SS (6) | SS (6) |  |  |  |  | RF (9)
10 | 7 | [NAME] |  |  | C (2) | C (2) | [NAME] () | P (1) | X | P (1) |  |  |  |  | SF (10)
11 | 8 | [NAME] |  |  | [NAME] () | [NAME] () | C (2) | C (2) | P (1) | X |  |  |  |  | EH ()
12 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | LCF ()
13 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ()
Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Roster pulled from list on roster tab
 | 9
 | 9
Notes:
 |  |  |  | Players on [NAME]
 |  | Only pull a players first name from the drop down
Spreadsheet: 19d5a455-7173-4d8f-8354-fd5d5500cdf7
Sheet: Sheet1

ONLINE PROPERTY AUCTION SERVICE MAILING LIST
A.W. Real Estate Investments, LLC
Contact: [NAME]
551 E. 120th Street
Cleveland, OH 44108
Phone: [PHONE]
Type: CSB/MBE/FBE/LPE
Expiration Date: Jan 06, 2013
Real Estate: purchase, own, lease, manage, appraisers, and operate real estate properties. Rehab properties through third party contractor(s).
American Family Title Agency, Inc.
Contact: [NAME] Rivera
3101 West 25th Street, Suite 203
Cleveland, OH 44109
Phone: [PHONE]
Type: CSB/FBE/LPE
Expiration Date: May 31, 2013
Real estate and title agency.
Don Koo & Associates Ltd.
Contact: Donny Gamble
588 Bishop Road
Highland Heights, OH 44143
Phone: [PHONE]
Type: CSB/MBE/LPE
Expiration Date: Feb 03, 2013
General contractor specializing in demolition, rehab, painting, plumbing, cleanup/cleanout; and real estate.
Urban Living Contractors, LLC
Contact: [NAME]
2303 Oak Park Avenue
Cleveland, OH 44109
Phone: [PHONE]
Type: CSB/MBE/LPE
Expiration Date: Oct 25, 2012
Real estate professional and construction management consultant
Outside Vendors
Proxibid, Inc
Contact: None provided
4411 South 96th St
Omaha, NE 68127
Phone: [PHONE]
Online property auction service
Property Room
Contact: [NAME]
25571 Marguerite Parkway
[NAME]
[NAME], CA 92691
Phone: [PHONE]
Online property auction service
Seized Property Auctions
Contact: [NAME]
Federal Asset Recovery Services
1990 N.W. 44th St
Pompano Beach, FL 33064
Phone: [PHONE]
Online property auction service
Ubid
Contact: Account Management
740 [NAME]
Itasca, IL 60143
Phone: [PHONE]
Online property auction service
Municibid
Contact: [NAME]
200 Barr Harbor Drive
Suite 4 PMB 4105
West Conshohocken, PA 19428
Phone: [PHONE] ext 703
Online property auction service
Liberty Auction House
Contact: None provided
500 North Michigan Avenue
Ste 300
Chicago, IL 60611
Phone: [PHONE]
Online property auction service
Spreadsheet: 142345d1329781549-auto-populate-data-from-sheet-1-to-specific-places-in-multiple-other-worksheets-2012-fastasy-golf-final
Sheet: RBC Heritage

 |  | WEEK 2 RBC Heritage
 |  | Total Earnings |  |  |  | Rankings Through Week 2 | Total
 |  |  |  | YTD
 | Total
 | Total
 | Total
 | Total
 | Total
 | Total
 | Total
 | Total
 | Total
 | Total
 | Total
 | Total
 | Total
Spreadsheet: 184342d1349220259-need-assistance-calculating-statistics-help
Sheet: Sheet1

 | Player1 | Player1Team | Character 1 | Player2 | Player2Team | Character 2 | Player 3 | Player3Team | Character 3 | Player4 | Player4Team | Character 4 | Activity | Winning Team
 | [NAME] | Red | Dog | [NAME] | Blue | Cannon | [NAME] | Red | [NAME] | [NAME] | Blue | Thimble | Monopoly | Blue
 | [NAME] | Blue | Professor [NAME] | [NAME] | Blue | Miss [NAME] | [NAME] | Red | [NAME] | [NAME] | Red | Colonel Mustard | Clue | Red
 | [NAME] | Red | Mr Green | [NAME] | Blue | Mrs Peacock | Jessica | Red | Miss [NAME] | [NAME] | Blue | Colonel Mustard | Clue | Blue
 | [NAME] | Red | Blue | [NAME] | Red | Red | [NAME] | Blue | White | [NAME] | Blue | Orange | Life | Blue
 | [NAME] | Blue | [NAME] | [NAME] | Red | Mr Green | [NAME] | Blue | Professor [NAME] | [NAME] | Red | Miss [NAME] | Clue | Blue
 | [NAME] | Red | Racecar | [NAME] | Blue | Iron | [NAME] | Red | Thimble | [NAME] | Blue | Battleship | Monopoly | Red
 | Jessica | Blue | Dog | [NAME] | Red | [NAME] | [NAME] | Red | Wheelbarrow | [NAME] | Blue | Battleship | Monopoly | Red
 |  |  |  |  |  |  |  | Winning Percentage
 |  |  | Times Played | Winning Percentage
 |  | [NAME] |  |  |  |  | [NAME] | Monopoly | Clue | Life
 |  | [NAME] |  |  |  |  | [NAME]
 |  | [NAME] |  |  |  |  | [NAME]
 |  | [NAME] |  |  |  |  | [NAME]
 |  | [NAME] |  |  |  |  | [NAME]
 |  | [NAME] |  |  |  |  | [NAME]
 |  | [NAME] |  |  |  |  | [NAME]
 |  | [NAME] |  |  |  |  | [NAME]
 |  | Jessica |  |  |  |  | Jessica
 |  | [NAME] |  |  |  |  | [NAME]
Spreadsheet: richard_shapiro__32601__Accomplishment-june5th2001-Masteredit
Sheet: Other

Name: | [NAME] | Region/Country: |  | South America | Primary Activity: | Electricity and Gas | Second. Activity: | Telecommunications
No. | Accomplishments | Customer | Value | Area |  |  |  |  | Methodology
 | (description) | (B. Unit) | ($) | Deal Support | Origination | Risk Mgment | [NAME] | Other
-1 | -2 | -3 | -4 | -5 | -6 | -7 | -8 | -9 | -10
1 | Debt Collection - Calife. Municipalities in arrears for more than three years. Largest item is public lighting. Drafted legislation to charge customers directly and avoid debt continue to grow, evaluated assets to swap for debt, lobbyied to transfer debt | Enron Venezuela | US $800.000 |  |  |  |  | Commercial / Asset support | Quantify actual debt from company's books. The amount is US $8 Million (still ongoing). Standard collection fee is 10%
2 | Upgrade of transmission and distribution network serving Calife. Regulatory due-diligence analyzing regulatory assumptions of valuation model, highlight regulatory risks and include language in contract to mitigate them, including provisions when wholesal | Enron Venezuela | US $1.5 Million | X |  | X |  |  | Full CAPEX of US $15 Million considered to be the exposure. Subjective probability of 10% estimated to be regulatory exposure mitigated in contract
3 | [NAME]  $ 250 MM JV with PDVSA to build a national dark fiber ring. Performed regulatory due-diligence analysis | Enron Venezuela/ EBS | Still in the development stages | X |  | X |  |  | Value added difficult to determine at this stage of development
4 | Anaco-Jose Pipeline. Represented an opportunity to increase value of [NAME] project by controlling gas pipeline that feeds the LNG plant. Performed regulatory due-diligence, lobbied for modification of Terms and Conditions of the JV Agreement and Transp | Enron Venezuela | The project was cancelled | X |  | X
5 | [NAME]. 2.1 MM ton gas liquification plant for export to US East Coast. Performed political and economic environment analysis for RAC, lobbied/educated regulators on the benefits for Venezuela and the dynamics of the LNG market worldwide | Enron Global Markets, Atlantic LNG |  |  |  |  | X |  | Since the completion of  this  project is still highly uncertain, it is difficult to quantify impact of effort.
Spreadsheet: 04e6701f-b620-4202-905b-021b29fe5040
Sheet: Fall 2011

Fall 2011
 | Percent of Students | Percent of Students | Percent of Students | Percent of Students
 | Exceeding Expectations | Meeting Expectations | Below Expectations | Unable to Evaluate
Knowledge of Problem Solving. | 1
Knowledge of Reasoning and Proof. | 1
Knowledge of Mathematical Communication. | 1
Knowledge of Mathematical Connections. | 1
Knowledge of Mathematical Representation. | 1
Knowledge of Technology. | 1
Dispositions. | 1
Knowledge of Mathematics Pedagogy. | 1
Knowledge of Number and Operations. | 1
Knowledge of Different Perspectives on Algebra. | 1
Knowledge of Geometries. | 1
Knowledge of Calculus. | 1
Knowledge of Discrete Mathematics. | 1
Knowledge of Data Analysis, Statistics, and Probability. | 1
Knowledge of Measurement. | 1
Spreadsheet: 85371d1285391985-vlookup-with-multi-values-xl0000000
Sheet: Sheet1

Option-1
Home Number | Office Number | Mobile No. | Staff Name
900xxxx | 24xxxxxx | 00xxxx | [NAME]
Option-2
Home Number | Office Number | Mobile No. | Report Purpose | Staff Name
900xxxx | 24xxxxxx | 00xxxx | 900xxxx24xxxxxx00xxxx | [NAME]
 |  |  | [NAME]
Spreadsheet: errol_mclaughlin_jr__10849__week9
Sheet: Sheet1

2001 NFL POOL
WEEK NINE
VISITOR |  |  |  | HOME |  | POINTS
Sunday 11/4/01
Baltimore |  | at |  | Pittsburgh |  | 4
Carolina |  | at |  | Miami |  | 13
Cleveland |  | at |  | Chicago |  | 10
Dallas |  | at |  | NY Giants |  | 14
Jacksonville |  | at |  | Tennessee |  | 6
New England |  | at |  | Atlanta |  | 5
Tampa Bay |  | at |  | Green Bay |  | 8
Detroit |  | at |  | San Francisco |  | 15
Philadelphia |  | at |  | Arizona |  | 11
Indianapolis |  | at |  | Buffalo |  | 7
Kansas City |  | at |  | San Diego |  | 12
Seattle |  | at |  | Washington |  | 3
NY Jets |  | at |  | New Orleans |  | 9
Monday 11/5/01
Denver |  | at |  | Oakland |  | 2
OPEN:
Cincinnati
Minnesota
St. Louis
Submit picks by 11:00 AM Sunday
14 Games:  Rank games 2 to 15 (Total Points = 119)
NAME:  [NAME]
Spreadsheet: 840128d1692454131-get-number-of-repetative-duplicate-2-digits-from-10-digit-number-sample-workbook
Sheet: Sheet1

Number | Splitting number in 2 digits |  |  |  |  | Unique 2 digits numbers | Total [NAME] (Most imp column)
6357965796 | 63 | 57 | 96 | 57 | 96 | 63, 57, 96 | 3
6357985798 | 63 | 57 | 98 | 57 | 98 | 63, 57, 98 | 3
6357995798 | 63 | 57 | 99 | 57 | 98 | 63, 57, 99, 98 | 4
8832705612 | 88 | 32 | 70 | 56 | 12 | 88, 32, 70, 56, 12 | 5
9689899689 | 96 | 89 | 89 | 96 | 89 | 96, 89 | 2
8080807060 | 80 | 80 | 80 | 70 | 60 | 80, 70, 60 | 3
6574859674 | 65 | 74 | 85 | 96 | 74 | 65, 74, 85, 96, 74 | 5
Spreadsheet: 785361d1656356641-xlookup-that-returns-only-one-value-payment-type
Sheet: All Payments

Payment Business Unit | Payment Type | Payment Method | Payment Amount | Amount Allocated | Credit Remaining | Batch Number | Payment Status | Transaction Status | Payment Date | Customer Name
HVAC Service | Cash | Cash | 99 | 99 | 0 |  | Pending | Successful | 2022-06-06 00:00:00 | Customer 1
HVAC Service | Cash | Cash | 49 | 49 | 0 |  | Pending | Failed | 2022-06-08 00:00:00 | Customer 2
Drains | Cash | Cash | 89 | 89 | 0 |  | Pending | Successful | 2022-06-09 00:00:00 | Customer 3
Drains | Cash | Cash | 99 | 99 | 0 |  | Pending | Failed | 2022-06-12 00:00:00 | Customer 4
Drains | Cash | Cash | 99 | 99 | 0 |  | Pending | Failed | 2022-06-13 00:00:00 | Customer 5
Spreadsheet: 819586d1677590785-countif-with-let-function-error-st
Sheet: Sheet1

 |  | formula | Expected result
 |  |  | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 |  |  | 6 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 1 | 0 | 0
 |  |  | 5 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0
 |  |  | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 1
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  | Calculation
 |  |  |  |  | 12 | 10 | 7
 |  |  |  |  | 0 | 6 | 7 | 2 | 0 | 0 | 0 | 4 | 1 | 1 | 0 | 2
 |  |  |  |  | 1 | 1 | 1 | 0 | 2 | 0 | 0 | 3 | 0 | 4 | 7 | 0 | 3
 |  |  |  |  | 4 | 7 | 0 | 2 | 0 | 2 | 7 | 3 | 1
 |  |  |  |  | 1 | 2 | 0 | 5 | 3 | 0 | 1 | 1 | 1 | 2 | 0
Spreadsheet: 807085d1669733876-calculate-sum-each-month-based-on-two-variables-sales-team-goals-asm-commission-calculator-2023
Sheet: vlookup1

Quota per rep | 1650 |  |  | Quota per rep | 1650
# of Reps | 4 |  |  | # of Reps | 3
Monthly Team Quota |  |  |  | Monthly Team Quota
% of Team Goal Achieved | $6600 Monthly Quota | Monthly Payout |  | % of Team Goal Achieved | $6600 Monthly Quota | Monthly Payout
125% + | $8250 or more | 2500 |  | 125% + | $6188 or more | 2500
100 - 124.99% | $6600 - $8249 | 1667 |  | 100 - 124.99% | $4950 - $6187 | 1667
75 - 99.99% | $4950 - $6599 | 1250 |  | 75 - 99.99% | $3713 - $4949 | 1250
50 - 74.99% | $3300 - $4949 | 850 |  | 50 - 74.99% | $2475 - $3712 | 850
0-49% | $3299 or less | 0 |  | 0-49% | $2474 or less | 0
$6600 Quota (4 reps x $1650) |  |  |  | $4950 Quota (3 reps x $1650)
Starting % Attainment | Payout |  |  | Starting % Attainment | Payout
0 | 0 |  |  | 0 | 0
0.5 | 850 |  |  | 0.5 | 850
0.75 | 1250 |  |  | 0.75 | 1250
1 | 1667 |  |  | 1 | 1667
1.25 | 2500 |  |  | 1.25 | 2500