tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 859523d1707898576-formula-help-for-isolating-two-columns-based-on-no-match-test-excel
Sheet: PRICING ANALYZER

Pulled Sales History SIM List | SIM Description | Sell Contract | SPA Cost | SPA Name | 2610 Standard Cost | 2610 WTT Cost | [NAME] | Loaded Margin | [NAME] Months | QTY Sold - Revenue | [NAME] Cost | [NAME]
 | a | f | f | s | x | s | s | s | g | h | v | v
[PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
[PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
[PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
[PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
[PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
[PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
Spreadsheet: 112656d1308707402-cash-flow-pivot-table-cash-flow-example
Sheet: DailySetup

Sum of Amount | AccountInfo | Class
 | 1Income |  |  |  |  | 2Expense |  |  |  |  |  |  |  | Grand Total
Date | IC | JP | OS | SX | WA | CC | EQ | IC | JP | OS | SC | SX | WA
2011-01-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | -8048 |  | -8048
2011-01-19 00:00:00 |  |  |  |  |  | -2988 |  |  |  |  |  |  |  | -2988
2011-01-21 00:00:00 |  |  |  |  |  |  |  |  |  | -7900 |  |  |  | -7900
2011-03-10 00:00:00 |  |  |  |  |  |  |  |  | -2306 |  |  |  |  | -2306
2011-03-25 00:00:00 |  |  |  |  | 13605 |  |  |  |  |  |  |  |  | 13605
2011-04-09 00:00:00 |  |  |  |  |  |  |  |  |  | -9337 |  |  |  | -9337
2011-06-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | -4496 | -4496
2011-06-14 00:00:00 |  |  |  |  |  |  | -1381 |  |  |  |  |  |  | -1381
2011-06-15 00:00:00 |  |  |  |  |  |  |  | -7614 |  |  |  |  |  | -7614
2011-07-18 00:00:00 |  |  |  |  |  |  |  |  |  |  | -9257 |  |  | -9257
2011-07-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | -3042 |  | -3042
2011-08-04 00:00:00 |  |  |  | 19947 |  |  |  |  |  |  |  |  |  | 19947
2011-08-22 00:00:00 |  |  |  |  |  | -9425 |  |  |  |  |  |  |  | -9425
2011-09-19 00:00:00 | 16068 |  |  |  |  |  |  |  |  |  |  |  |  | 16068
2011-09-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | -7832 | -7832
2011-09-26 00:00:00 |  |  | 12309 |  |  |  |  |  |  |  |  |  |  | 12309
2011-09-30 00:00:00 |  |  |  |  |  |  | -4538 |  |  |  |  |  |  | -4538
2011-10-14 00:00:00 |  | 15650 |  |  |  |  |  |  |  |  |  |  |  | 15650
2011-12-20 00:00:00 |  |  |  |  |  |  |  |  |  |  | -2341 |  |  | -2341
Grand Total | 16068 | 15650 | 12309 | 19947 | 13605 | -12413 | -5919 | -7614 | -2306 | -17237 | -11598 | -11090 | -12328 | -2926
Spreadsheet: 54617d1254668316-cell-inputting-book1
Sheet: Sheet1

FB | [NAME] |  |  |  |  |  |  |  |  |  |  | CB | [NAME]
im | [NAME] |  |  |  |  |  |  |  |  |  |  | FB | [NAME]
 | #N/A |  |  |  |  |  |  |  |  |  |  | IB | I Bee
 | #N/A |  |  |  |  |  |  |  |  |  |  | IM | [NAME]
 | #N/A |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
 | #N/A
 | #N/A
 | #N/A
Spreadsheet: 23786d1213541237-linking-data-to-the-web-hyperlinks-using-cell-contents
Sheet: Sheet1

cintra park london | search google maps
the mall westmimster london | search google maps
[NAME] london | search google maps
[NAME] Louisville | search google maps
buckingham palace | show map
central park | show map
Wembley canada | show map
[NAME] | show map
Wembley stadium | show map
se19 uk | show map
Spreadsheet: 48791d1248100572-make-sumif-only-appear-in-first-row-copy-of-sample2
Sheet: Current

ID | Name | Code | Date | Daily Value | TOTALS
111111111 | Doe, [NAME] | B | 2001-01-01 00:00:00 | 27.15 | 30.52
111111111 |  | A | 2001-01-01 00:00:00 | 0.52
111111111 |  | F | 2001-01-01 00:00:00 | 2.85
167827365 |  |  |  | 41.64 | 6433.84
167827365 |  |  |  | 5741.32
167827365 |  |  |  | 68.21
167827365 |  |  |  | 95.35
167827365 |  |  |  | 487.32
136257845 |  |  |  | 658.23 | 1509.97
136257845 |  |  |  | 325.36
136257845 |  |  |  | 358.14
136257845 |  |  |  | 168.24
365218569 |  |  |  | 235.01 | 2188.97
365218569 |  |  |  | 485.07
365218569 |  |  |  | 105.98
365218569 |  |  |  | 463.25
365218569 |  |  |  | 468.57
365218569 |  |  |  | 162.35
365218569 |  |  |  | 268.74
OK everything above appears on the report EXCEPT the totals column.
In order to get a total now I have to  click the cell where I want the value and then highlight the daily values and click again to put it in.  Sometimes there is one row some times up to 7 rows.
I wanted to see if that totals row can be added up without manually doing this.  The only thing I think is why cant it do it by emplid number.
if its the same emplid add all the values under "daily value" and put to first total line.  Does that make sense or have i absolutely confused you!.  Thanks for your help.
Spreadsheet: 122014d1316551995-indirect-erep_1gb-tigrovi_bkp
Sheet: figuar_zg

Ambient on/off
eRepublik – Online Strategy Game
Sep20 Day 1,400 of the New World
Home
My Land
Wars
Market
Marketplace
Job market
Monetary market
Companies for sale
Community
World Map
News
My Party
Elections
Military Unit
Country administration
Invite friends
Badges
Get Gold & Extras
[NAME]
[NAME]
27
60
Eat food
Gold2.24 Gold
BAM411 BAM
HRK1625 HRK
Missions
X
You don't have enough Gold to complete the task Get Gold
Completed!
2011-10-03 00:00:00
2011-10-03 00:00:00
2011-10-03 00:00:00
Reward
Ok
Congratulations, your rank is now
Rank Bonus on attack +5%
Energy bar
Ok
Strength
Experience points
Health
Rank points
Gold
Energy bar
[NAME]
Free Lands
Scope
Bazooka
Weapons
Weapons
Weapons
Food units
Food units
Food units
Grain Farms
0 0
Logout
Experience level: 27
Experience points: 10027
Next level at: 15000
• Working, training and fighting decreases health
[NAME], health boxes, food, hospitals restore health.
This action restores as much health as possible by eating Food from your Storage.
You can recover up to: 450 / 450 Health
100 more recoverable Health in: 00:59:59
Food limit reached
You have reached your food consumption limit.
You can recover 100 health every hour.
100 more recoverable Health in: [NAME]
Buy health kit Close
figuar_zg
offlinefiguar_zg
Add as a friend Send message Donate
Experience level 30
28,764 / 30,000
Location: CroatiaCroatia, North Dalmatia Citizenship: CroatiaCroatia
eRepublik birthday
[NAME]
National rank: 178
Party Member
[NAME] eHrvatskeSavez Komunista eHrvatske Far-left Wing
Member
HV 1.GB Tigrovi HV 1.GB Tigrovi
Press director
Analysis
Friends(692)
broc
[NAME]
BeDva
Plese [NAME]
igor loncar
dSoKre
DominionHR
N  I  K  A  N
mlatonja
view all
Land of figuar_zg: 60 buildings
Visit
About me
Wiki page
eCroatian Minister of Economy
eCroatian Media Mogul
Achievements
hard worker
13
Hard Worker
Worked 30 days in a row
congressman
2
Congress Member
Won the Congress elections
president
Country President
Win the Presidential elections
media mogul
1
Media Mogul
Reached 1000 subscribers to your newspaper
battle hero
1
Battle Hero
Reach the highest war influence in a battle
campaign hero
Campaign hero
Reach the highest war influence in a campaign
resistance hero
Resistance Hero
Start a resistance war and liberate that region
super soldier
18
Super Soldier
Advance 250 strength points
society builder
Society Builder
Invite 10 people to eRepublik and help them reach level 10
mercenary
Mercenary
Defeat 25 enemies for 50 different countries
Coming soon
Coming soon
Military Skills
Strength
4,592.48
Super soldier:4,592 / 4,750
Rank
Supreme Marshal Supreme Marshal
Rank points:
2,587,487 / 3,000,000
Forum   |   [NAME]   |   Blog   |   Press   |   Contact   |   [NAME]   |   Terms of Service   |   Privacy  |   Affiliates  |   [NAME]
Follow us: FacebookFacebook TwitterTwitter
Copyright © 2007-2011 eRepublik
Spreadsheet: 851217d1701442722-formulas-not-calculating-debt-payoff-crich368-
Sheet: SSL

 | Credit Card Info
 | Current Balance | 5000
 | Interest Rate | 0.14
 | Interest-Only Payment
 | A. Calculate Months to Payoff |  |  | Months | Payment | Interest
 | Monthly Payment | 250 |  | 12
 | (Needs to be greater than the interest-only payment) |  |  | 18
 |  |  |  | 24
 | Months to Payoff |  |  | 30
 | Total Interest |  |  | 36
 |  |  |  | 42
 | B. Calculate Monthly Payment |  |  | 54
 | Payoff Goal (Months) | 36 |  | 60
 | Monthly Payment
 | Total Interest
Spreadsheet: 8dc2eeb0-2d65-4e64-85d6-5ca5e80a05de
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6792 | 51322 | Dawn | Werneck | BRA | 674 | 00:21:03 | 00:03:31 | 00:46:52 | [NAME] | 00:28:11 | 1 | 01:42:09
6792 | 8115 | Janice | Iredale | AUS | 673 | 00:20:02 | 00:03:15 | 00:51:34 | 00:02:21 | [NAME] | 2 | 01:57:04
6792 | 41190 | Georgina | Jennings | GBR | 669 | 00:18:32 | 00:03:50 | [NAME] | 00:03:06 | 00:34:36 | 3 | 01:58:06
6792 | 51931 | [NAME] | Mitchell | GBR | 670 | 00:28:10 | [NAME] | 00:54:55 | 00:03:13 | 00:28:06 | 4 | 01:58:20
6792 | 32939 | Carol | [NAME] | AUS | 672 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DQ | 00:00:00
6792 | 29316 | [NAME] | Heysoon | USA | 671 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DQ | 00:00:00
Spreadsheet: 47071d1245964558-sumif-multiple-worksheets-add-all-cells-adjacent-to-cell-w-value-matching-query-kor-cart-quotas
Sheet: UOFA - 1A3-22 DAY SURGICAL

K-BRO LINEN SYSTEMS - EDMONTON  PLANT
1A3-22 DAY SURGICAL
FACILITY: | UNIVERSITY OF ALBERTA HOSPITAL
Date:
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | STATS
DELIVERY DAYS: |  | X |  | X |  | X
** If more/less linen required please fax in this order by 9:30 a.m. (FAX # (780) 451-5125)
[NAME] |  |  |  | PACK # |  | QUOTA | SHELF | REC | +/-/HOLD
100-HUCK TOWEL |  |  |  | BP0010 |  | 1
5-ISO GOWN GREEN |  |  |  | GL0010 |  | 12
UPDATED:
June 17th 2009
Spreadsheet: 3bb5aaeb-56f6-4926-99bc-0ed0d9c53c69
Sheet: Sheet1

UNIVERSITY OF MARY WASHINGTON
BIWEEKLY PAYROLL
For the period beginning |  |  |  |  |  | and ending
 |  | WEEKLY [NAME] |  |  |  |  |  |  |  |  | WEEKLY [NAME] |  |  |  |  |  |  |  |  | TOTAL | HOURLY | AMOUNT
 | NAME | MON | TUE | WED | THU | FRI | SAT | SUN | TOTAL |  | MON | TUE | WED | THU | FRI | SAT | SUN | TOTAL |  | HOURS | RATE | EARNED
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
I certify that the foregoing payroll contains the names of persons employed in the Service of the State under my direction
or supervision during the period stated and that the accounts shown are in accordance with duly authorized rates of compensation.
TITLE: |  |  |  |  |  |  |  |  |  |  | SIGNATURE:
DEPARTMENT: |  |  |  |  |  |  |  |  |  |  | PRINTED NAME:
Spreadsheet: 87669d1287562788-help-in-sumifs-sumifs
Sheet: Sheet1

 |  | LP | 35
 |  |  | SMS
 |  |  | 3250
 |  | LO | 40
 |  |  | WRN
 |  |  | 6492
 |  | LN | 20
 |  |  | SDS
 |  |  | 7135
 |  | MP | 31
 |  |  | SDS
 |  |  | 333
 |  | MO | 11
 |  |  | WRN
 |  |  | 99
 |  | MN | 35
 |  |  | WRN
 |  |  | 1100
 | 1 | Sum, How many records in column D is >=100 and started with L in column C (The Result should be =16,877).
 | 2 | Sum, How many records in column D is>=100 and started with M in column C (The Result should be =1,433)
Spreadsheet: 0bbff19d-7640-4484-88cf-f2c9b8ac6ff2
Sheet: 5 YEARS

Form PR-B ORSP BUDGET WORKSHEET    Must be completed and initialed by ORSP Staff
 | MUID |  |  |  | ACCT
Prepared by
Last Modified on
PI |  |  |  |  | DEPT
Project Title
Sponsor
 | Budget Period
 | Increase Annually By | 1.03
 |  |  |  |  |  | PERIOD 1 |  |  | PERIOD 2 |  |  | PERIOD 3 |  |  | PERIOD 4 |  |  | PERIOD 5 |  |  | TOTAL
 | BUDGET ITEM | Name or Comment |  |  |  | GRANT | Cost Share | TOTAL | GRANT | Cost Share | TOTAL | GRANT | Cost Share | TOTAL | GRANT | Cost Share | TOTAL | GRANT | Cost Share | TOTAL | GRANT | Cost Share | TOTAL
A. | PERSONNEL
6000 | PI Acad. Year
6000 | Co-I Acad Year
6000 | Co-I Acad Year
6000 | Other Professional
6000 | Total Professional
6007 | PI Summer
6007 | Co-I Summer
6007 | Co-I Summer
6007 | Total Sumr Salaries
6008 | Post Doc/Fellow Full-Time
6012 | Clinical/Lab Staff Full-Time
6013 | Clinical/Lab Staff Part-Time
6020 | Full-Time Hourly Staff
6035 | Part-Time Hourly Staff
6050 | Undergraduate Students
6024 | GRA-Academic Year | #: |  | Biweekly $:
6024 | GRA-Summer | #: |  | Biweekly $:
6024 | Total GRA
6195 | Fringe FT |  |  |  | 0.285
6195 | [NAME] |  |  |  | 0.16
6195 | Fringe PT & Summer Students |  |  |  | 0.08
6195 | Total Fringes
 | TOTAL PERSONNEL
B. | NONPERSONNEL
6200 | Office Expenses
6235 | Lab Supplies
6247 | Equipment > $5000
6265 | Computer Software
6505 | Consulting Fees
6602 | Student Stipends
6900 | Domestic Travel
6900 | Domestic Travel
6900 | Total Domestic Travel
6930 | Foreign Travel
7010 | Publications
7225 | Tuition
 | TOTAL NONPERSONNEL
 | TOTAL DIRECT COSTS
 | MTDC BASE
7520 | F&A Costs |  |  |  | 0.51
 | TOTAL PROJ COSTS
Spreadsheet: 677403d1589344868-averageifs-with-multiple-criteria-sample1234ab
Sheet: Sheet1

Type of Material | Quantities | Sales for 2018 | Sales for 2019
Silk | 20 | 456090 | 366322
Silk/Deim | 50 | 326555 | 890000
Cotton/Silk | 80 | 672222
Polyester | 30
Wool | 20 |  | 652300
Cotton/Wool | 60 | 35690
Criteria |  | [NAME]
Silk |  |  | ----> Array Formula
Spreadsheet: 211632d1359845771-ordinal-ranking-in-excel-2010-kpk1
Sheet: Sheet1

prdct key | feature | option
B265 | [NAME] attachement | 1' | 1 | B265hose attachement | once done copy /paste special/ values
B265 | [NAME] attachement | 2' | 2 | B265hose attachement | over itself col d    then delete/clear column e
B265 | [NAME] attachement | 3' | 3 | B265hose attachement
B265 | wheels | 3 | 1 | B265wheels
B265 | wheels | 4 | 2 | B265wheels
B265 | color | black | 1 | B265color
B265 | color | blue | 2 | B265color
B265 | color | green | 3 | B265color
A936 | [NAME] attachement | 1' | 1 | A936hose attachement
A936 | [NAME] attachement | 2' | 2 | A936hose attachement
A936 | [NAME] attachement | 3' | 3 | A936hose attachement
A936 | wheels | 3 | 1 | A936wheels
A936 | wheels | 4 | 2 | A936wheels
A936 | color | black | 1 | A936color
A936 | color | blue | 2 | A936color
A936 | color | green | 3 | A936color
Spreadsheet: 5b5c1888-7bdd-43bb-9b83-af2e137962a6
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
43676700 | 2014-10-21 15:32:42 | ALLIES | 1 | 6 | 5 | 1658483 | [NAME] | 7364 | mediterranean | 1941-11-25 | 1941-11-25 | Dug in at [NAME] | Retranchés à [NAME]
Spreadsheet: 112140d1308270869-excel-email-distribution-list-help-me-avoid-1-000-copy-pastes-example
Sheet: Pee-Wee B

PEE-WEE B
Équipe | [NAME] | Entraîneur |  | Numéro de téléphone |  | Adresse courriel
 |  | Chef | Assis | Maison | Cellulaire
team_name | coach_name | x |  | [PHONE] | [PHONE] | [EMAIL]
 | coach_name |  | x | [PHONE]
team_name | coach_name | x |  | [PHONE] | [PHONE] | [EMAIL]
 | coach_name |  | x | [PHONE] | [PHONE]
 | coach_name |  | x | [PHONE] | [PHONE] | [EMAIL]
team_name | coach_name | x |  | [PHONE] | [PHONE] | [EMAIL]
 | coach_name |  | x | [PHONE] | [PHONE] | [EMAIL]
 | coach_name |  | x | [PHONE] | [PHONE] | [EMAIL]
team_name | coach_name | x |  | [PHONE] | [PHONE] | [EMAIL]
 | coach_name |  | x | [PHONE] | [PHONE] | [EMAIL]
 | coach_name |  | x | [PHONE] | [PHONE] | [EMAIL]
 | coach_name |  | x | [PHONE] | [PHONE] | [EMAIL]
team_name | coach_name | x |  | [PHONE] | [PHONE] | [EMAIL]
 | coach_name |  | x | [PHONE] | [PHONE] | [EMAIL]
 | coach_name |  | x | [PHONE] | [PHONE] | [EMAIL]
 | coach_name |  | x | [PHONE] | [PHONE] | [EMAIL]
team_name | coach_name | x |  | [PHONE] | [PHONE] | [EMAIL]
 | coach_name |  | x | [PHONE] | [PHONE] | [EMAIL]
team_name | coach_name | x |  | [PHONE] | [PHONE] | [EMAIL]
 | coach_name |  | x | [PHONE] | [PHONE] | [EMAIL]
 | coach_name |  | x |  |  | [EMAIL]
team_name | coach_name | x |  | [PHONE] | [PHONE] | [EMAIL]
 | Please send your assisstant coach's contact info to [EMAIL]
team_name | coach_name | x |  | [PHONE] | [PHONE] | [EMAIL]
 | coach_name |  | x | [PHONE] |  | [EMAIL]
 | coach_name |  | x | [PHONE] | [PHONE]
 | coach_name |  | x | [PHONE] | [PHONE] | [EMAIL]
team_name | coach_name | x |  | [PHONE] | [PHONE] | [EMAIL]
 | coach_name |  | x | [PHONE] |  | [EMAIL]
 | coach_name |  | x | [PHONE]
Spreadsheet: 864606d1711707760-please-help-to-create-accounting-sheet-accounts-follow-up-list-2024
Sheet: Purchase Orders

Purchase Orders
Name: | Company: | PO Number: | Description: | Opening Balance: | Remaining balance: | Complete: | Comments:
SS | Company 1 | PO00001 | The PO number should be shown in drop down menue in invoice tab. As on invoice tab I used this PO0001 3 times for 700 + 200 + 100 = 1000, zero remaining balance remaining. | 1000 | 0
SS | Company 2 | PO00002 | The PO number should be shown in d;rop down menue in invoice tab. | 1000 | 1000
SS | Company 3 | PO00003 | The PO number should be shown in d;rop down menue in invoice tab. | 1000 | 1000
Spreadsheet: 6e9491e6-ec14-43fa-999a-eb098645fb4f
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Quelle: http://ergebnisse.vimentis.ch/
Frage:
Das Tragen einer Burka und anderen [NAME] wird im öffentlichen [NAME] verboten.
 | Alter:
Antwort | 15-24 | 25-34 | 35-44 | 45-54 | 55-64 | [NAME] 65
[NAME] | 0.59 | 0.59 | 0.7 | 0.74 | 0.8 | 0.83
Neutral / Weiss nicht | 0.13 | 0.15 | 0.12 | 0.1 | 0.09 | 0.08
[NAME] | 0.28 | 0.26 | 0.18 | 0.15 | 0.12 | 0.1
Angaben zu den [NAME]
Erhebungsjahr | 2011
Stichprobengrösse | 30565
Erhebungszeitraum | 05.11.2011 bis: 30.12.2011
[NAME] | [NAME]
Methodik / Repräsentativität
Um soziodemographische Verzerrungen [NAME], wurden sämtliche [NAME] nach [NAME], Alter, Bildung und Region gemäss der wahren [NAME] älter als 15 Jahre gewichtet. Es bleibt eine psychographische Verzerrung wegen
der [NAME] über das Internet, welche nicht korrigiert [NAME]. Diese Verzerrung wird anhand einzelner [NAME] für jede [NAME] abgeschätzt. Demnach sind [NAME] auf dieser Seite angegebenen [NAME] mit einer
Präzision von &plusmn;2% [NAME].
[NAME] und [NAME] auf dieser Seite dürfen unter Angabe der Quelle weiterverwendet werden.
Spreadsheet: 140419d1328737809-excel-2007-ranking-based-on-three-criteria-rank-example
Sheet: Sheet1

Rep | Rank | % Revenue | % Margin | Date Hired | Should Be Ranked
Rep A |  | 0 | 0 | 2012-01-01 00:00:00 | 5
Rep B |  | 0 | 0 | 2012-02-01 00:00:00 | 4
Rep C |  | 0.8 | 0.2 | 2011-11-01 00:00:00 | 3
Rep D |  | 1 | 0.2 | 2011-05-01 00:00:00 | 2
Rep E |  | 1 | 0.3 | 2011-01-01 00:00:00 | 1
Spreadsheet: 6166cedb-93b7-4131-b7aa-9549cf478ff8
Sheet: Sheet1

Bib | Firstname | Lastname | City | State | TeamName | Age | Gender | AgeGroup | [NAME] | Run | Finish | AG Place | OverAll | Order | Masters | Penalty
8 | [NAME] | [NAME] | Lockridge | IA |  | 28 | F | F21-30 | -- | 00:20:19.310000 | 00:20:19.310000 | 3 | 3 | 14
4 | [NAME] | Boatright | Fairfield | IA |  | 31 | F | F31-40 | -- | 00:23:32.730000 | 00:23:32.730000 | 1 | 4 | 18
1 | Angie | Atwood | Fairfield | IA |  | 32 | F | F31-40 | -- | 00:23:57.390000 | 00:23:57.390000 | 2 | 5 | 20
5 | Jodi | [NAME] | Fairfield | IA |  | 38 | F | F31-40 | -- | 00:23:58.200000 | 00:23:58.200000 | 3 | 6 | 22
9 | Amanda | [NAME] | Fairfield | IA |  | 34 | F | F31-40 | -- | 00:24:15.040000 | 00:24:15.040000 | 4 | 7 | 24
10 | Kristy | [NAME] | Birmingham | IA |  | 42 | F | F41-50 | -- | 00:24:48.840000 | 00:24:48.840000 | 1 | 8 | 26
13 | Cathy | Durflinger | Cantril | IA |  | 33 | F | F31-40 | -- | 00:25:07.870000 | 00:25:07.870000 | 5 | 9 | 27
16 | [NAME] | [NAME] | Stockport | IA |  | 42 | F | F41-50 | -- | 00:26:22.500000 | 00:26:22.500000 | 2 | 10 | 29
7 | [NAME] | Bunnell | Ottumwa | IA |  | 32 | F | F31-40 | -- | 00:26:48.730000 | 00:26:48.730000 | 6 | 11 | 32
41 | Michelle | Rauscher | Fairfield | IA |  | 40 | F | F31-40 | -- | 00:27:36.710000 | 00:27:36.710000 | 7 | 12 | 33
61 | [NAME] | Lampman | Marshalltown | IA |  | 31 | F | F31-40 | -- | 00:28:25.560000 | 00:28:25.560000 | 8 | 13 | 36
59 | [NAME] | Herrick | Mount Pleasant | IA |  | 26 | F | F21-30 | -- | 00:30:35.390000 | 00:30:35.390000 | 4 | 14 | 39
14 | Shannon | [NAME] | Ottumwa | IA |  | 23 | F | F21-30 | -- | 00:30:57.670000 | 00:30:57.670000 | 5 | 15 | 40
38 | Teresa | Nguyen | Oskaloosa | IA |  | 24 | F | F21-30 | -- | 00:30:57.840000 | 00:30:57.840000 | 6 | 16 | 41
45 | Leah | Shields | West Des Moines | IA |  | 22 | F | F21-30 | -- | 00:30:59.420000 | 00:30:59.420000 | 7 | 17 | 42
30 | Michelle | Lauderman | Fairfield | IA |  | 39 | F | F31-40 | -- | 00:31:21.160000 | 00:31:21.160000 | 9 | 18 | 43
52 | [NAME] | Weeks | Ottumwa | IA |  | 39 | F | F31-40 | -- | 00:31:21.430000 | 00:31:21.430000 | 10 | 19 | 44
62 | [NAME] | Lisk | Fairfield | IA |  | 37 | F | F31-40 | -- | 00:33:14.350000 | 00:33:14.350000 | 11 | 20 | 45
58 | [NAME] | Ferrel | Fairfield | IA |  | 37 | F | F31-40 | -- | 00:33:14.420000 | 00:33:14.420000 | 12 | 21 | 46
55 | [NAME] | Angstead | Fairfield | IA |  | 42 | F | F41-50 | -- | 00:33:16.110000 | 00:33:16.110000 | 3 | 22 | 47
51 | Tish | Webb | [NAME] | MO |  | 32 | F | F31-40 | -- | 00:33:32.660000 | 00:33:32.660000 | 13 | 23 | 48
22 | Karrie | Hempstead | Central City | IA |  | 34 | F | F31-40 | -- | 00:34:24.710000 | 00:34:24.710000 | 14 | 24 | 49
Spreadsheet: 779596d1651887393-formula-to-calculate-top-80-top-selling-customers-top-80-
Sheet: Sheet1

Top 80% Customers
Scenario 1
No | Customer | Sales | % | Cumulative %
1 | ABC | 1000
2 | DEF | 900
3 | GHI | 800
4 | JKL | 700
5 | MNO | 600
Scenario 2
No | Customer | Sales | % | Cumulative %
1 | ABC | 1000
2 | DEF | 1000
3 | GHI | 1000
4 | JKL | 1000
5 | MNO | 1000
Spreadsheet: 34584d1231892321-drop-down-displayed-in-another-cel-rootcause
Sheet: Sheet1

REF # | DATE SUBMITTED | SUBMITTED BY | DEPARTMENT | SUGGESTION (CATEGORY) | Root Cause | TITLE | ASSIGNED TO | O & R | STATUS | Time Frame |  |  |  |  | Billing
SUG-7947 | 2009-01-06 00:00:00 | [NAME] | Customer Care | Product or Service Improvement |  |  | emily tam | received email from Angie | Closed - Actioned |  | View / Ed |  |  |  | Improvement of tools or resources |  |  | Pricing
[NAME] | 2009-12-30 00:00:00 | [NAME] | Customer Care | Policy or Process Improvement |  |  | emily tam |  | Closed - Not Actioned |  | View / Edit |  |  |  | IVR |  |  | Credit/Adj | 1 Day
SUG-7844 | 2009-12-30 00:00:00 | [NAME] | Customer Care | Products or Service Improvement |  |  | emily tam | email [NAME] | In Progress |  | View / Edit |  |  |  | Policy or Process Improvement |  |  | V21 | 2 Days
SUG-7845 | 2009-12-30 00:00:00 | [NAME] dykstra | Customer Care | Improvement of Tools or Resources |  | AGT | emily tam |  | Closed - Actioned |  | View / Edit |  |  |  | Product or Service Improvement |  |  | SGI | 3 Days
SUG-7846 | 2009-12-30 00:00:00 | [NAME] | Customer Care | Products or Service Improvement |  |  | emily tam | add in Cable spreadsheet | In Progress |  | View / Edit |  |  |  |  |  |  | rogers.com | 4 Days
SUG-7847 | 2009-12-30 00:00:00 | [NAME] | Customer Care | Products or Service Improvement |  |  | emily tam |  | Closed - Actioned |  | View / Edit |  |  |  |  |  |  | ICM | 5 Days
SUG-7849 | 2009-12-30 00:00:00 | [NAME] | Customer Care | Products or Service Improvement |  |  | emily tam |  | Closed - Actioned |  | View / Edit |  |  |  |  |  |  | Promotion
SUG-7670 | 2009-12-17 00:00:00 | [NAME] | Rogers Retail | Products or Service Improvement |  | AGT | emily tam |  | Closed - Actioned |  | View / Edit |  |  |  |  |  |  | HUP
SUG-7755 | 2009-12-22 00:00:00 | [NAME] | Rogers Retail | Products or Service Improvement |  | AGT | emily tam |  | Closed - Actioned |  | View / Edit |  |  |  |  |  |  | Coverage
SUG-7851 | 2009-12-30 00:00:00 | candice Simeon | Customer Care | Products or Service Improvement |  | AGT | emily tam |  | Closed - Actioned |  | View / Edit |  |  |  |  |  |  | Escalation