tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 91545d1291237761-excel-2007-formula-for-cell-counting-excel-sheet-sheet-count
Sheet: % Complete

 | DH Coordinator |  | DH Plan |  | Task Force Organization |  | Resource for Database Management
REGION 1
Bay
[NAME]
Escambia
Gulf
[NAME]
[NAME]
Okaloosa
Santa Rosa
[NAME]
Washington
Percent Complete
REGION 2
Columbia
Dixie
Franklin
[NAME]
[NAME]
[NAME]
Lafayette
[NAME]
Liberty
[NAME]
[NAME]
[NAME]
Wakulla
Percent Complete
REGION 3
Alachua
[NAME]
Bradford
Clay
Duval
Flagler
Gilchrist
[NAME]
Marion
Nassau
Putnam
[NAME]
Union
Percent Complete
REGION 4
Citrus
Hardee
Hernando
Hillsborough
Pasco
Pinellas
Polk
Sumter
Percent Complete
REGION 5
Brevard
Indian River
Lake
Martin
Orange
Osceola
Seminole
St Lucie
Volusia
Percent Complete
REGION 6
Charlotte
Collier
DeSoto
Glades
Hendry
Highlands
[NAME]
Manatee
Okeechobee
Sarasota
[NAME]
Percent Complete
REGION 7
Broward
Miami-Dade
Monroe
Palm Beach
Percent Complete
Progress
[NAME] (designee's)
Spreadsheet: 201900d1356197153-assign-formula-to-a-name-vlookup
Sheet: Sheet1

ACCOUNT NO | OUTSTANDING
31260722767 | 4614
31263124823 | 40543
31276861147 | 40018
31284715061 | 3818
31298662408 | 35376
31298689453 | 36570
31311092490 | 26310
31317540947 | 42883
31321472844 | 42862
Spreadsheet: 453813d1459452480-take-oldest-date-based-on-name-yrs-and-months
Sheet: Sheet1

[NAME], [NAME] | 2016-03-01 00:00:00 | a
[NAME], [NAME] | 2016-02-01 00:00:00
[NAME], [NAME] | 2015-01-01 00:00:00
Doe, [NAME] | 2015-04-01 00:00:00
Doe, [NAME] | 2014-09-01 00:00:00
[NAME], [NAME] | 2014-09-01 00:00:00
[NAME], [NAME] | 2014-06-01 00:00:00
Bunyon, [NAME] | 2014-05-01 00:00:00
Bunyon, [NAME] | 2013-02-01 00:00:00
Spreadsheet: f25cbbe8-6465-40ad-a122-8fb47ec6263c
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
40310048 | 2014-03-02 04:54:01 | AXIS | 1 | 7 | 2 | 1514635 | piersbp | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40329906 | 2014-03-03 05:54:56 | AXIS | 1 | 7 | 4 | 385172 | Brode Warrior | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40330172 | 2014-03-03 06:11:08 | ALLIES | 0 | 0 | 7 | 385172 | Brode Warrior | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40330336 | 2014-03-03 06:37:35 | ALLIES | 1 | 7 | 5 | 385172 | Brode Warrior | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40363769 | 2014-03-05 07:06:20 | ALLIES | 1 | 10 | 4 | 1022086 | Mishgan | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40363953 | 2014-03-05 07:34:13 | AXIS | 1 | 10 | 7 | 1022086 | Mishgan | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 48760d1248064656-search-and-highlight-only-containing-text-search-engine-new
Sheet: SEARCH-ENGINE

 | SEARCH CRITERIA
 | ITEM# | VENDOR NAME | ERP PART NUMBER | ERP VENDOR CODE | NIMS PART #
 |  | *WORKS*
 | SEARCH RESULT
 | ITEM# | VENDOR NAME | ERP PART NUMBER | ERP VENDOR CODE | NIMS PART #
 | 605776 | SADIQ ENGINEERING WORKS | 28409B79500P | 30251001 | 28409-79500
 | 606045 | SAEED METAL WORKS | 65205B79601P | 30258001 | 65205-79601
 | 606046 | SAEED METAL WORKS | 65206B79501P | 30258001 | 65206-79501
 | 606048 | SAEED METAL WORKS | 65215B79501P | 30258001 | 65215-79501
 | 622021 | SADIQ ENGINEERING WORKS | 61515B84001P | 30251001 | 61515-84001
 | 650372 | ZAIB ENGINEERING WORKS | 62300B76G13P | 30294001 | 62300-76G13
 | 650466 | BADAR-E-TAUSIF ENGINEERING WORKS | 63312B77G00P | 30062001 | 63312-77G00
 | 650467 | BADAR-E-TAUSIF ENGINEERING WORKS | 63712B77G00P | 30062001 | 63712-77G00
 | 650495 | ZAIB ENGINEERING WORKS | 61190B76G00P | 30294001 | 61190-76G00
 | 650496 | JAVED STEEL MANUFACTURING WORKS | 61530B76G01P | 30129001 | 61530-76G01
 | 650496 | SHAHEEN ENGINEERING WORKS | 61530B76G01P | 30233001 | 61530-76G01
 | 650497 | JAVED STEEL MANUFACTURING WORKS | 61536B76G01P | 30129001 | 61536-76G01
 | 650497 | SHAHEEN ENGINEERING WORKS | 61536B76G01P | 30233001 | 61536-76G01
Spreadsheet: fa76a93f-63e4-4875-b2b2-7c80e2edc115
Sheet: Sheet1

PROG ID | ATHLETE ID | TEAM FIRST | TEAM LAST | NATIONALITY | START NUMBER | LEG 1 | LEG 2 | LEG 3 | LEG 4 | POSITION | TOTAL TIME
5417 | 14078 | Team I | Norway | NOR | 0 | 00:25:55 | 00:00:00 | 00:22:56 | 00:00:00 | 1 | 01:10:37
Spreadsheet: louise_kitchen__24097__NEWCO HEADCOUNT NAMES1
Sheet: Admins

Admins | ok
[NAME] | Financial | [NAME] |  | 7000
[NAME] | Derivitives | [NAME] |  | 2500
[NAME] | Central/East | [NAME] |  | 5000
[NAME] | Central/East | [NAME] |  | 1500
Amanda Hubble | West | [NAME] |  | 1500
[NAME] | Structuring/Fundys | [NAME] |  | 2500
[NAME] | Texas | [NAME] |  | 2500
[NAME] | Chicago | [NAME] |  | 1500
[NAME] | Clerk/Runner | [NAME] |  | 2000
[NAME] | Weather | [NAME] |  | 4000
[NAME] | Logistics | [NAME] |  | 3000
[NAME] | Mexico | [NAME] | 12 | 3000
Spreadsheet: 744062d1628893052-array-formula-help-sample-budget-etaf-1
Sheet: Sheet1

 |  |  |  | JAN | FEB | MAR | APR | MAY | JUN | JUL
Total Sales | Product 1 | [NAME]
 | Product 2 | Racket
 | Product 3 | Net
 | Product 4 | Gloves
 | Product 5 | Shoes
 | Product 6 | Bicycle
 |  |  |  | QTY BUDGET IN UNITS
 |  | ITEM | Price ea | JAN | FEB | MAR | APR | MAY | JUN | JUL
Store 1 | Product 1 | [NAME] | 5 | 50 | 51
 | Product 2 | Racket | 4 | 10 | 15
 | Product 3 | Net | 5 | 5 | 8
 | Product 4 | Gloves
 | Product 5 | Shoes
 | Product 6 | Bicycle
Store 2 | Product 1 | [NAME] | 6 | 8 | 3
 | Product 2 | Racket | 3 | 52 | 25
 | Product 3 | Net
 | Product 4 | Gloves | 2 | 32
 | Product 5 | Shoes
 | Product 6 | Bicycle
Store 3 | Product 1 | [NAME] | 8 | 54 | 50
 | Product 2 | Racket
 | Product 3 | Net | 5 | 55 | 20
 | Product 4 | Gloves | 5 | 21 | 15
 | Product 5 | Shoes
 | Product 6 | Bicycle
Store 4 | Product 1 | [NAME] | 1 | 5 | 8
 | Product 2 | Racket
 | Product 3 | Net | 5 | 66 | 10
 | Product 4 | Gloves | 3 | 20 | 15
 | Product 5 | Shoes | 3 | 1
 | Product 6 | Bicycle | 2 | 25 | 30
Spreadsheet: 3e42bcac-f219-46d3-b4c3-22f616a3dd94
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
OPATM | Test | OPATM | Opiate Confirmation, Meconium | Opiate Confirmation, M | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) |  |  |  | 5 | g | Chain of custody is recommended for this test. Chain-of-Custody Meconium Kit (Supply T653) is available upon request.   Container/Tube: Stool container (Supply T288) [NAME]: 1 g (approximately 1 teaspoon) Collection Instructions: Collect entire random meconium specimen. Additional Information:  1. For chain-of-custody information, see Chain-of-Custody Meconium Kit (Supply T653). 2. Specimen that arrives with a broken seal does not meet the chain-of-custody requirements. 3. The laboratory recommends sending chain-of-custody specimens by overnight shipment. | 0.3 g (approximately 1/4 teaspoo | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	Grossly bloody reject; Pink OK | Negative Positives are reported with a quantitative LC-MS/MS result. [NAME] concentrations Codeine by LC-MS/MS: >50 ng/mL Hydrocodone by LC-MS/MS: >50 ng/mL Hydromorphone by LC-MS/MS: >50 ng/mL [NAME] by LC-MS/MS: >50 ng/mL Oxycodone by LC-MS/MS: >50 ng/mL Oxymorphone by LC-MS/MS: >50 ng/mL | Monday through Friday, Sunday; Varies | 2 days | 3 days | 1 | 83925 |  |  |  |  | Rochester
OPATM | [NAME] | [NAME] | Meconium |  |  |  | Frozen | 14 days
OPATM | Result | 31848 | [NAME] | [NAME] | Numeric |  |  |  |  | ng/g |  |  |  |  |  |  |  |  |  | 26860-7 | Morphine:MCnt:Pt:Meconium:Qn:
OPATM | Result | 31850 | Oxymorphone | Oxymorphone | Numeric |  |  |  |  | ng/g |  |  |  |  |  |  |  |  |  | 69028-9 | Oxymorphone:MCnt:Pt:Meconium:Qn:Confirm
OPATM | Result | 31849 | Hydromorphone | Hydromorphone | Numeric |  |  |  |  | ng/g |  |  |  |  |  |  |  |  |  | 26862-3 | Hydromorphone:MCnt:Pt:Meconium:Qn:
OPATM | Result | 31847 | Codeine | Codeine | Numeric |  |  |  |  | ng/g |  |  |  |  |  |  |  |  |  | 26865-6 | Codeine:MCnt:Pt:Meconium:Qn:
OPATM | Result | 31852 | Oxycodone | Oxycodone | Numeric |  |  |  |  | ng/g |  |  |  |  |  |  |  |  |  | 26869-8 | Oxycodone:MCnt:Pt:Meconium:Qn:
OPATM | Result | 31851 | Hydrocodone | Hydrocodone | Numeric |  |  |  |  | ng/g |  |  |  |  |  |  |  |  |  | 26863-1 | Hydrocodone:MCnt:Pt:Meconium:Qn:
OPATM | Result | 31868 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69050-3
OPATM | Result | 31869 | Chain of Custody | Chain of Custody | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 785404d1656395041-some-cells-wont-highlight-with-colour-with-conditional-formatting-cf-testing-doc-for-conditional-formatting-aligw
Sheet: Sheet1

 | Address and Phone List |  |  |  |  |  | Last updated:
 | Legend | Connected | Left a voicemail | No answer | Unavailable | To assign colour to cell; click on drop-down (at right of the selected cell)
 | Street Number | Street Name | Suburb | Owner | Contact number | Contact Date | Contacted? | Comments
 | 1-5 |  | Maroochy River |  |  |  | Connected
 | 19-23 |  | Maroochy River
 | 25-29 |  | Maroochy River |  |  |  | Connected
 | 31-41 |  | Maroochy River
 | 1-9 |  | Maroochy River
 | 11 |  | Maroochy River
 | 21-33 |  | Maroochy River
 | 26-32 |  | Maroochy River
 | 34 |  | Maroochy River
 | 35-41 |  | Maroochy River
 | 36-40 |  | Maroochy River
Spreadsheet: 184330d1349212976-need-to-convert-time-to-decimal-testbook
Sheet: Sheet1

Start Date | Start Time | Stop Date | Stop Time | Duration
2012-01-02 00:00:00 | 03:25:00 | 2012-01-02 00:00:00 | 05:20:00 |  |  | I need 1:55 to become 1.92
2012-01-04 00:00:00 | 11:35:00 | 2012-01-04 00:00:00 | 13:35:00 |  |  | 2:00=2.0
2012-01-02 00:00:00 | 03:30:00 | 2012-01-02 00:00:00 | 22:40:00 |  |  | 19:10= 19.167
2012-01-04 00:00:00 | 23:10:00 | 2012-01-05 00:00:00 | 00:00:00
2012-01-05 00:00:00 | 23:30:00 | 2012-01-06 00:00:00 | 19:20:00
2012-01-04 00:00:00 | 12:45:00 | 2012-01-05 00:00:00 | 15:00:00
2012-01-04 00:00:00 | 21:00:00 | 2012-01-05 00:00:00 | 02:10:00
2012-01-06 00:00:00 | 06:20:00 | 2012-01-06 00:00:00 | 10:05:00
2012-01-07 00:00:00 | 04:35:00 | 2012-01-07 00:00:00 | 05:05:00
2012-01-05 00:00:00 | 17:55:00 | 2012-01-05 00:00:00 | 18:00:00
2012-01-22 00:00:00 | 05:05:00 | 2012-01-22 00:00:00 | 05:10:00
2012-01-20 00:00:00 | 17:05:00 | 2012-01-20 00:00:00 | 17:10:00
2012-01-04 00:00:00 | 13:35:00 | 2012-01-04 00:00:00 | 14:20:00
2012-01-06 00:00:00 | 05:30:00 | 2012-01-06 00:00:00 | 06:00:00
2012-01-07 00:00:00 | 09:00:00 | 2012-01-07 00:00:00 | 16:40:00
2012-01-05 00:00:00 | 16:15:00 | 2012-01-06 00:00:00 | 08:00:00
2012-01-09 00:00:00 | 03:00:00 | 2012-01-09 00:00:00 | 04:15:00
2012-01-07 00:00:00 | 05:30:00 | 2012-01-07 00:00:00 | 05:30:00
2012-01-09 00:00:00 | 17:40:00 | 2012-01-09 00:00:00 | 20:25:00
2012-01-10 00:00:00 | 13:00:00 | 2012-01-10 00:00:00 | 21:35:00
2012-01-11 00:00:00 | 08:10:00 | 2012-01-11 00:00:00 | 09:35:00
2012-01-11 00:00:00 | 21:30:00 | 2012-01-11 00:00:00 | 21:45:00
2012-01-13 00:00:00 | 12:45:00 | 2012-01-13 00:00:00 | 13:15:00
2012-01-16 00:00:00 | 17:35:00 | 2012-01-16 00:00:00 | 19:20:00
2012-01-11 00:00:00 | 16:55:00 | 2012-01-11 00:00:00 | 18:20:00
2012-01-18 00:00:00 | 11:15:00 | 2012-01-18 00:00:00 | 12:50:00
2012-01-16 00:00:00 | 14:55:00 | 2012-01-16 00:00:00 | 17:05:00
2012-01-11 00:00:00 | 18:50:00 | 2012-01-11 00:00:00 | 20:30:00
2012-01-17 00:00:00 | 11:05:00 | 2012-01-17 00:00:00 | 18:00:00
2012-01-19 00:00:00 | 10:00:00 | 2012-01-19 00:00:00 | 23:00:00
Spreadsheet: 780786d1652781868-automatically-populating-vehicle-selling-price-based-on-make-model-trim-infos-sample-sheet-by-eternallysnow88-gregb11
Sheet: Sheet1

YEAR | MAKE | MODEL | TRIM | SELLING PRICE
2022 | Genesis | [NAME] | 2.5T Advanced AWD
2022 | Genesis | GV70 | 2.5T Advanced AWD
2022 | Genesis | [NAME] | 3.3T Sport AWD
2023 | Genesis | [NAME] | 2.5T Advanced AWD
Spreadsheet: 713165d1610572786-pivot-summarize-services-for-client-and-net-profits-calculation-example
Sheet: Amended PVT

Row Labels | Sum of Original WIP Value EC | Sum of Fee | Sum of Subtract
Customer A | 981.0400000000001 | 1650 | -668.96
Amended Tax Return | 132.54 | 500 | -367.46
[NAME] (PoA/Ablagen/Mails/etc) | 33.32 | 0 | 33.32
Tax Assessment | 39.6 | 150 | -110.4
Tax Return | 775.58 | 1000 | -224.42
Customer B | 954.3 | 1150 | -195.7
[NAME] / cannot be allocated | 73.5 | 0 | 73.5
Tax Assessment | 78.08 | 150 | -71.92
Tax Return | 802.72 | 1000 | -197.28
Customer C | 487.9 | 1200 | -712.1
OOSC | 87.84 | 0 | 87.84
Tax Meeting | 307.34 | 200 | 107.34
Tax Return | 92.72 | 1000 | -907.28
Customer D | 474.1 | 1150 | -675.9
[NAME] / cannot be allocated | 137.94 | 0 | 137.94
[NAME] (PoA/Ablagen/Mails/etc) | 26.4 | 0 | 26.4
OOSC | 57.04 | 0 | 57.04
Tax Assessment | 197.52 | 150 | 47.51999999999998
Tax Return | 55.2 | 1000 | -944.8
Grand Total | 2897.34 | 5150 | -2252.660000000001
Spreadsheet: 95898d1295425661-how-to-make-a-formula-to-take-value-in-database-to-store-as-history-history
Sheet: Pivot Table

Month | January
Count of Name | Status
Name | New | Old | Grand Total
[NAME] | 1 |  | 1
Bani |  | 1 | 1
Cech |  | 1 | 1
Danold | 1 |  | 1
Eagle |  | 1 | 1
Foxes |  | 1 | 1
Gray | 1 |  | 1
Hayward |  | 1 | 1
Irwans | 1 |  | 1
Jenova |  | 1 | 1
Grand Total | 4 | 6 | 10
Spreadsheet: 72198d1272907979-index-function-based-on-year-pdgvalueproposition
Sheet: Sheet2

 | 2010 |  |  |  | Annual Total | 2011 |  |  |  | Annual Total | 2012 |  |  |  | Annual Total | 2013 |  |  |  | Annual Total | 2014 |  |  |  | Annual Total
Medicare Supplement | 1 | 2 | 3 | 4 |  | 1 | 2 | 3 | 4 |  | 1 | 2 | 3 | 4 |  | 1 | 2 | 3 | 4 |  | 1 | 2 | 3 | 4
Gerber | 12 | 12 | 12 | 12 |  | 12 | 12 | 12 | 12 |  | 9 | 9 | 9 | 9 |  | 6 | 6 | 6 | 6 |  | 3 | 3 | 3 | 3
Sentinel | 0 | 4 | 7 | 7 |  | 7 | 7 | 7 | 7 |  | 6 | 6 | 6 | 6 |  | 5 | 5 | 5 | 5 |  | 4 | 4 | 4 | 4
Forethought | 0 | 0 | 0 | 2 |  | 3 | 5 | 5 | 5 |  | 6 | 6 | 6 | 6 |  | 4 | 4 | 4 | 4 |  | 4 | 2 | 2 | 2
Pan American | 0 | 0 | 0 | 0 |  | 2 | 3 | 5 | 5 |  | 5 | 6 | 6 | 6 |  | 6 | 4 | 4 | 4 |  | 4 | 2 | 2 | 2
National Health | 0 | 0 | 0 | 0 |  | 0 | 2 | 3 | 5 |  | 5 | 5 | 6 | 6 |  | 6 | 6 | 4 | 4 |  | 4 | 4 | 2 | 2
Total
Life | 1 | 2 | 3 | 4 |  | 1 | 2 | 3 | 4 |  | 1 | 2 | 3 | 4 |  | 1 | 2 | 3 | 4 |  | 1 | 2 | 3 | 4
Forethought | 0 | 0 | 0 | 0 |  | 0.5 | 0.75 | 0.75 | 0.75 |  | 1 | 1.25 | 1.25 | 1.5 |  | 1.25 | 1 | 1 | 0.75 |  | 0.5 | 0.5 | 0.5 | 0.5
NWL | 0 | 0 | 0 | 0 |  | 0.5 | 0.5 | 0.5 | 0.5 |  | 0.5 | 0.5 | 0.5 | 0.5 |  | 0.5 | 0.5 | 0.5 | 0.5 |  | 0.5 | 0.5 | 0.5 | 0.5
Total
Annuities | 1 | 2 | 3 | 4 |  | 1 | 2 | 3 | 4 |  | 1 | 2 | 3 | 4 |  | 1 | 2 | 3 | 4 |  | 1 | 2 | 3 | 4
Phoenix | 0 | 0 | 4 | 5 |  | 5 | 7 | 9 | 10 |  | 10 | 10 | 10 | 10 |  | 10 | 10 | 10 | 10 |  | 10 | 10 | 10 | 10
Symetra | 0 | 0 | 0 | 1 |  | 5 | 7.5 | 7.5 | 10 |  | 10 | 10 | 10 | 10 |  | 10 | 10 | 10 | 10 |  | 10 | 10 | 10 | 10
Fidelity Security | 0 | 0 | 0 | 0 |  | 0 | 5 | 7.5 | 7.5 |  | 7.5 | 10 | 10 | 10 |  | 10 | 10 | 10 | 10 |  | 10 | 10 | 10 | 10
Forethought | 0 | 0 | 1 | 3 |  | 7.5 | 10 | 11.25 | 11.25 |  | 11.25 | 11.25 | 11.25 | 11.25 |  | 11.25 | 11.25 | 11.25 | 11.25 |  | 11.25 | 11.25 | 11.25 | 11.25
Forethought LTC | 0 | 0 | 0 | 0 | 0 | 5 | 10 | 20 | 20 |  | 20 | 20 | 20 | 20 |  | 20 | 20 | 20 | 20 |  | 20 | 20 | 20 | 20
Total
LTC | 1 | 2 | 3 | 4 |  | 1 | 2 | 3 | 4 |  | 1 | 2 | 3 | 4 |  | 1 | 2 | 3 | 4 |  | 1 | 2 | 3 | 4
Medamerica | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
LifeSecure | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
Company 3 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
Company 4 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
Company 5 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
Company 6 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
Total
Spreadsheet: 800788d1665871210-add-total-prize-help-with-formula-example
Sheet: Planilha1

Player | Amount Bet | Game | Result
[NAME] | 10 | Game 1 | won |  |  |  | Game | Game 1 |  |  | Player | [NAME]
[NAME] | 8 | Game 1 | won |  |  |  | Amount Bet |  |  |  | Amount Bet
[NAME] | 10 | Game 1 | Lost |  |  |  | Winners |  |  |  | Total win | ???
[NAME] | 6 | Game 2 | Lost
[NAME] | 6 | Game 2 | Lost
[NAME] | 10 | Game 3 | Lost |  |  | 1 | Winners
[NAME] | 5 | Game 3 | won |  |  | 2 | Player | Amount Bet | Award
[NAME] | 9 | Game 5 | won |  |  | 3
[NAME] | 8 | Game 5 | Lost |  |  | 4
[NAME] | 6 | Game 5 | won |  |  | 5
[NAME] | 5 | Game 5 | won |  |  | 6
[NAME] | 9 | Game 6 | Lost |  |  | 7
 |  |  |  |  |  | When I select the dropdown in M3, I need to get the total that the [NAME] has won in all games.  The prize of each player varies in percentage according to the amount of his bet.
Spreadsheet: 605751d1547247668-count-cells-that-are-a-perfect-multiple-of-adjacent-cell-countif-whole-number
Sheet: Sheet1

Absolute Quantity | LEQ | Qty/LEQ | Count if "C" Column is a whole number | Desired Result
14 | 48 |  |  | 0
1 | 1 |  |  | 1
66 | 72 |  |  | 0
720 | 72 |  |  | 1
648 | 72 |  |  | 1
18 | 72 |  |  | 0
216 | 36 |  |  | 1
12 | 36 |  |  | 0
Spreadsheet: 471632d1469117294-copying-a-single-column-in-multiple-excel-files-into-one-excel-file-english-workbook
Sheet: Sheet1

Name_EN
Large 'Never too late’ patches
Small keyrings (set of 3)
Large 'I love weekend’ patches
BSK braided college bag
Saffian tote bag
'Washed’ bandana
Mid-length transparent pink and black socks (set)
Multicolour ankle socks (set of 5)
BSK perforated bowling bag
Embroidery and patches beanie
BSK beads and stitch detail belt
Coral and grey socks (set of 2)
Transparent multicolour flames iPhone 6/6s case
Rose gold palm tree iPhone 5/5s case
Rose gold palm tree iPhone 6/6s case
Minimal backpack
Credit card holder
Sports bag
Reversible [NAME]
Keyring wallet with pocket chain
Chains (set of 2)
Keyring with pocket chain
[NAME] and chain bracelets (set of 2)
Embossed wallet
Triangle pendant
Maxi metallic watch
Watch with wood effect strap
Spreadsheet: 880284d1727901801-getting-employee-data-from-another-sheet-employee_assignments
Sheet: Sheet1

Employee List
ID | Name | Job Title | Org | Driver
4039197 | [NAME] | Handler | 80D01 | N
5907743 | [NAME] | Handler | 80D01 | N
784425 | [NAME] | DG Agent | 80D01 | Y
4672909 | [NAME] | DG Agent | 80D01 | N
3785673 | Joel | Material Handler | 80D01 | Y
4899619 | [NAME] | Material Handler | 80D01 | N
6255263 | Camia | Handler | 80D01 | N
3581435 | [NAME] | Handler | 80D01 | N
Spreadsheet: darrell_schoolcraft__7797__imbalsumm0107
Sheet: CIG

 | Tumbleweed
 | 9198
Day | Measured | Scheduled
1 | 0 | 0
2 | 0 | 0
3 | 0 | 0
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
2001-06-30 00:00:00 |  |  | 326755
2001-07-28 00:00:00
Spreadsheet: 176810d1346113403-auto-populating-shift-schedule-help-3
Sheet: Data

 | JDW | WTS | JLR | DLA | [NAME] | JTB | NWC | CGM | PEP | TME | DWJ
2012-08-01 00:00:00 | TM1 | T-SCHOOL | OFF | TM2 | VAC | YM2 | OFF | YM3 | TM3 | YM1 | OFF
2012-08-02 00:00:00 | TM1 | T-SCHOOL | OFF | TM2 | OFF | YM2 | OFF | YM3 | TM3 | YM1 | OFF
2012-08-03 00:00:00 | OFF | T-SCHOOL | TM1 | TM2 | OFF | YM2 | TM3 | OFF | YM3 | YM1 | VAC
2012-08-04 00:00:00 | OFF | PD | TM 7A-7P | OFF | PD | YM2 | TM 7P-7A | OFF | YM3 | YM1 | VAC
2012-08-05 00:00:00 | TM1 | OFF | YM1 | OFF | TM2 | YM2 | TM3 | PD | OFF | YM3 | VAC
2012-08-06 00:00:00 | T-SCHOOL | OFF | YM1 | TM 7A-7P | YM2 | OFF | TM 7P-7A | YM3 | OFF | OFF | VAC
2012-08-07 00:00:00 | T-SCHOOL | YM1 | TM1 | TM2 | YM2 | OFF | TM3 | YM3 | CHECK | OFF | VAC
2012-08-08 00:00:00 | T-SCHOOL | YM1 | OFF | TM1 | TM2 | YM2 | OFF | YM3 | TM3 | CHECK | OFF
2012-08-09 00:00:00 | T-SCHOOL | YM1 | OFF | TM1 | OFF | YM2 | OFF | TM3 | TM2 | YM3 | OFF
2012-08-10 00:00:00 | T-SCHOOL | YM1 | TM1 | TM2 | OFF | YM2 | CHECK | OFF | TM3 | YM3 | TRAIN YM3
2012-08-11 00:00:00 | OFF | YM1 | TM1 | OFF | TM2 | YM2 | TM3 | OFF | YM3 |  | TRAIN YM3
2012-08-12 00:00:00 | OFF | OFF | TM1 | OFF | TM2 | YM2 | TM3 | YM3 | OFF | YM1 | TRAIN YM3
2012-08-13 00:00:00 | TM1 | OFF | YM1 | TM2 | YM2 | OFF | TM3 | YM3 | OFF | OFF | TRAIN YM3
2012-08-14 00:00:00 | CHECK | YM1 | TM1 | TM2 | YM2 | OFF | TM3 | CHECK | YM3 | OFF | TRAIN YM3
2012-08-15 00:00:00 | TM1 | YM1 | OFF | CHECK | TM2 | YM2 | OFF | TM3 | CHECK | YM3 | OFF
2012-08-16 00:00:00 | TM1 | YM1 | OFF | TM2 | OFF | YM2 | OFF | YM3 | TM3 | TRAIN TM3 | OFF
2012-08-17 00:00:00 | OFF | YM1 | TM1 | TM2 | OFF | YM2 | TM3 | OFF | YM3 | TRAIN TM3
2012-08-18 00:00:00 | OFF | YM1 | TM1 | OFF | TM2 | YM2 | TM3 | OFF | YM3 | TRAIN TM3
2012-08-19 00:00:00 | PD | OFF | TM1 | OFF | TM2 | YM2 | TM3 | YM1 | OFF | YM3
2012-08-20 00:00:00 | TM1 | OFF | YM1 | TM2 | YM2 | OFF | TM3 | YM3 | OFF | OFF
2012-08-21 00:00:00 | TM1 | CHECK | YM1 | TM2 | YM2 | OFF | TM3 | CHECK | YM3 | OFF
2012-08-22 00:00:00 | TM1 | YM1 | OFF | TM2 | CHECK | VAC | OFF | YM2 | TM3 | YM3 | OFF
2012-08-23 00:00:00 | TM1 | YM1 | OFF | TM2 | OFF | VAC | OFF | YM2 | TM3 | YM3 | OFF
2012-08-24 00:00:00 | OFF | YM1 | TM1 | TM2 | OFF | VAC | VAC | OFF | TM3 | YM3 | YM2
2012-08-25 00:00:00 | OFF | YM1 | TM 7A-7P | OFF | TM 7P-7A | VAC | VAC | OFF | PD | YM3 | YM2
2012-08-26 00:00:00 | VAC | OFF | YM1 | OFF | TM 7P-7A | VAC | VAC | TM 7A-7P | OFF | YM3 | YM2
2012-08-27 00:00:00 | TM1 | OFF | YM1 | TM2 | YM2 | OFF | VAC | TM3 | OFF | OFF | YM3
2012-08-28 00:00:00 | TM1 | YM1 | CHECK | TM2 | YM2 | OFF | VAC | TM3 | VAC | OFF | YM3
2012-08-29 00:00:00 | TM1 | YM1 | OFF | TM2 | YM2 | CHECK | OFF | TM3 | VAC | YM3 | OFF
2012-08-30 00:00:00 | TM1 | YM1 | OFF | TM2 | OFF | YM2 | OFF | TM3 | VAC | YM3 | OFF
2012-08-31 00:00:00 | OFF | YM1 | TM1 | TM2 | OFF | YM2 | TM3 | OFF | VAC | YM3 | CHECK
Spreadsheet: 775197d1648904314-help-with-bring-the-value-of-whichever-cell-has-value-currency-format-aligw
Sheet: Sheet1

B.USD | B.EUR | B.STR | B. | AliGW
15
 | 4521
 |  | 252
 |  | 300
 |  | 210
 | 7000
23
50
12
 | 3200
 |  | 152
 |  | 721
 | 2300
 | 2500
 | 1500
50
30
45
Spreadsheet: 160604d1339137866-finding-player-and-avg-top-3-scores-copy-of-ringer-percent-experiment3
Sheet: Sheet2

 |  |  |  |  |  | bc canstat
card # | Name |  | Prov | Div | ringer avg | best 3 avg | events
614111 | Smith | [NAME] | bc |  | 43.85714285714285 | 51.66666666666666 | 7
614112 | Cole | [NAME] | bc |  | 2.4 | 4 | 5
614016 | Moffat | [NAME] | bc |  | 1.375 | 3.666666666666667 | 8
Spreadsheet: ae97275f-f37e-4a00-864c-d7d0f343c3b1
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
RNAP | Test | RNAP | RNA Polymerase III Antibodies, IgG, Serum | RNA Polymerase [NAME], IgG, S | Enzyme-Linked Immunosorbent Assay (ELISA) |  |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Cold OK; Warm reject Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | <20.0 U (negative) 20.0-39.9 U (weak positive) 40.0-80.0 U (moderate positive) >80.0 U (strong positive) | Wednesday; Evening | 1 day | 7 days | 1 | 83520 |  |  |  |  | Rochester
RNAP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 21 days
RNAP | Result | RNAP | RNA Polymerase [NAME], IgG, S | RNA Polymerase [NAME], IgG, S | Numeric |  |  |  |  | U |  |  |  |  |  |  |  |  |  | In Process