tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 682738d1592307236-find-a-high-low-avg-price-v3_sales-2020
Sheet: Sheet2

Code | Vessel |  |  |  | Boxes | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BF800 | RELIANCE BF800
BF505 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BF505 | GENESIS BF505
Merchant | Species | Presentation | Grade | Units |  |  | Total (£) | [NAME] | Total (Kg) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PD352 | CEOL NA MARA
 |  |  |  | Boxes | Weight | Cost |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WT | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WC | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HD | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JPL | JPL Shellfish
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BL | Bells Seafood
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PWELL | Pierowall Fish
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ICEW | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WL | Whitelink Seafoods
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CS | Caithness Smoke House
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OT | Fish In Crieff
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CPM | Campbells Prime Meat
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Captains Galley
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NS | Norscot Seafoods
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KB | Kirkwall Bay Shellfish
Spreadsheet: 872426d1718808973-how-to-drop-individual-columns-rows-from-array-in-an-efficient-way-book1
Sheet: Sheet1

 | 5 | 9 | 13 |  |  | 2 |  |  | 13
2 | 6 | 10 | 14 |  |  | 3 |  | 2 | 14
3 | 7 | 11 | 15 |  |  |  |  | 3 | 15
4 | 8 | 12 | 16 |  |  |  |  | 4 | 16
Spreadsheet: 164135d1340655515-re-allocation-of-percentage-allocation_percentage
Sheet: Sheet1

Product | Region | Units Today | Units Yesterday | Sum% | Flag | Current Allocation % | Preferred Allocation | Preferred Allocation Calculated
Product A | LUXEMBOURG | 2000000 | 1500000 |  |  |  | 0.5405405405405406
Product A | NETHERLANDS | 1200000 | 1000000 |  |  |  | 0.3243243243243243
Product A | UNITED KINGDOM | 500000 | 450000 |  |  |  | 0.1351351351351351
Product A | SWITZERLAND | 200000 | 0 |  |  |  | 1
Product B | LUXEMBOURG | 1000000 | 1500000 |  |  |  | 0.08
Product B | NETHERLANDS | 9000000 | 1000000 |  |  |  | 0.72
Product B | UNITED KINGDOM | 2500000 | 450000 |  |  |  | 0.2
Product B | USD | 8000000 | 0 |  |  |  | 1
Spreadsheet: 725738d1616829530-formular-for-access-individual-details-in-sheet-2-wondered
Sheet: Sheet2

 | SERIAL NO | NAME | MATHS | ENGLISH | SCIE | KIS | CIV | SOCIAL | V/SKILLS
 | 1 | BARAKAEL RAPHAEL MSHANA | 65 | 50 | 83 | 68 | 72 | 75 | 90
 |  | [NAME] | 64 | 76 | 86 | 82 | 81 | 83 | 83
 |  | PRAYGOD ESTOMY LUKUMAY | 77 | 84 | 92 | 68 | 94 | 83 | 94
 |  | ANDREW B MREMA | 54 | 80 | 90 | 44 | 74 | 71 | 92
 |  | [NAME] | 75 | 82 | 96 | 70 | 98 | 78 | 94
 |  | SAMWEL THOMAS NDALIO | 83 | 72 | 97 | 66 | 95 | 94 | 96
 |  | ALUTE GODFREY EMMANUEL | 58 | 56 | 68 | 54 | 76 | 63 | 82
 |  | HAMZA ABDISALAMU | 68 | 84 | 94 | 60 | 97 | 81 | 98
 |  | FRANAEL R MBISE | 65 | 64 | 78 | 80 | 79 | 58 | 86
 |  | SHEKINA BARIHEZA TITI | 51 | 60 | 44 | 56 | 56 | 50 | 60
Spreadsheet: 772066d1646992837-auto-fill-filling-with-colour-based-on-variables-golf-final
Sheet: Stats

 | Player | Round 1 Score | Round 2 Score | Round 3 Score | Round 4 Score | Total | Revised | Position | Score | Points | Number of holes in 1
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | Talor Gooch
[NAME] | [NAME] Im
[NAME] | Mackenzie Hughes
[NAME] | [NAME]
Campbell | Jon Rahm
Campbell | Shane Lowry
Campbell | [NAME]
Campbell | [NAME]
Campbell | [NAME]
Campbell | [NAME]
Pearce | [NAME]
Pearce | [NAME]
Pearce | [NAME]
Pearce | [NAME]
Pearce | [NAME]
Pearce | [NAME]
Spreadsheet: 867784d1714575246-network-days-formula-not-handling-cases-when-start-date-is-weekend-calculating-time-duration-in-between-working-hours
Sheet: Start and end times

A | B | C |  |  | St time | End time |  |  |  |  |  | Holidays
2024-06-23 07:48:30 | 2024-06-24 09:09:11 |  |  |  | 08:00:00 | 18:00:00 |  |  |  |  |  | 2023-05-07 00:00:00
2024-06-22 07:48:30 | 2024-06-22 09:09:11 |  |  |  |  |  |  |  |  |  |  | 2023-08-05 00:00:00
2024-06-27 07:48:30 | 2024-06-29 09:09:11
2024-06-27 07:48:00 | 2024-06-27 09:09:11
2024-06-20 17:48:30 | 2024-06-29 09:09:11
2024-06-18 12:30:00 | 2024-06-23 09:30:00
2024-06-20 12:30:00 | 2024-06-24 09:30:00
2024-01-18 12:33:00 | 2024-01-21 09:30:00
2024-01-20 12:33:00 | 2024-01-21 09:30:00
2024-01-18 12:33:00 | 2024-01-19 09:30:00
2024-06-27 07:48:30 | 2024-06-29 09:09:11
2024-06-27 07:48:30 | 2024-06-29 09:09:11
2024-06-27 07:48:30 | 2024-06-29 09:09:11
2024-06-27 07:48:30 | 2024-06-29 09:09:11
Spreadsheet: 5dc947cd-349a-435e-8b6e-5d104a33f853
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
FGA13 | Test | FGA13 | Galactose-alpha-1,3-galactose (Alpha-Gal) IgE | Galactose-alpha-1,3-galactose IgE | Solid phase immunoassay |  |  |  | 1 | mL | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 1 mL of serum refrigerated in a plastic vial. | 1 mL |  | <[NAME]Previous reports ([NAME] 2009; 123:426-433) have demonstrated that patients with IgE antibodies to galactose-a-1,3-galactose are at risk for delayed anaphylaxis, angioedema, or urticaria following consumption of beef, pork, or lamb.   Test Performed by: Viracor-IBT Laboratories                              1001 NW Technology Dr                              Lee's Summit, MO 64086 | Monday through Friday | 1 - 2 days | 3 - 7 days | 1 | 86003 |  |  |  |  | Viracor-IBT Laboratories
FGA13 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FGA13 | Result | FGA13 | Galactose-alpha-1,3-galactose IgE | Galactose-alpha-1,3-galactose IgE | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: d6a78e6c-5859-4b46-8185-d13c0b3a0d58
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
CURL | Test | CURL | Curvularia lunata, IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For one allergen: 0.3 mL/For mor | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
CURL | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
CURL | Result | CURL | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6094-7 | Curvularia lunata Ab.IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 270928d1381759052-baseball-standing-using-if-function-2013-6u-fall-standings-scores
Sheet: Standings

[NAME] | GB | Team | W | L | T | Win % | Allowed | Scored | Diff | Allow/G | Score/G
 |  | Auburn
 |  | GA Tech
 |  | Arkansas
 |  | Texas A&M
 |  | Kentucky
 |  | Georgia
 |  | UNC
 |  | Miami
 |  | Alabama
 |  |  |  |  |  |  |  |  |  | * | Best Record
 |  |  |  |  |  |  |  |  |  |  | Head to Head
 |  |  |  |  |  |  |  |  |  |  | Runs Allowed
 |  |  |  |  |  |  |  |  |  |  | Run Differential
 |  |  |  |  |  |  |  |  |  |  | Runs Scored
* to view individual game results please click on tab at bottom
Spreadsheet: 216997d1361959527-adding-a-values-from-column-b-which-have-same-values-on-column-a-file
Sheet: T

Valia | 4000
Teresa | 5000 |  |  | Example | [NAME]
[NAME] | 3000 |  | Valia
Martin | 4000 |  | Teresa
Martin | 4650 |  | [NAME]
Carol | 1500 |  | Martin
Valia | 1300 |  | Carol
 |  |  | This is the result I
 |  |  | would like to have
 |  |  | with formulas
 |  |  | And this is my
 |  |  | dificulty
Spreadsheet: 704679d1605695761-how-to-match-multiple-criteria-to-get-value-job-work-production-tracking-drop-down-2
Sheet: desire result

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TO
PARTY NAME | P.O. NO. | FABRIC | DAILY PRODUCTION REPORT |  |  |  |  |  |  |  |  | NOVEMBER |  |  |  |  |  |  |  |  |  | TO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ORDER | ORDER DATE | LEAD TIME | TOTAL | DIFFERENCE | DAILY EXPECTED | EXPECTED COMPLETION DATE | EXTENDED DATE | EXTENDED DAYS
BHARTI UDYOG | 4090 | CELTIC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 | 6553 | CELTIC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70
 | 4089 | GEO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 90
BHARTI UDYOG | 4163 | GEO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
SHAKTI EXPORT | 4163 | GEO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50
SHAKTI EXPORT | 4163/4164 | FLEUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 115
SHIV EXPORT | 4163/4164 | FLEUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 95
SHAKTI EXPORT | 4163/4164 | PAISLEY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100
BHARTI UDYOG | 4163/4164 | FLEUR
SHAKTI EXPORT | 4090 | CELTIC
Spreadsheet: 855605d1705119459-get-data-from-1-sheet-to-other-sheets-depending-on-drop-down-list-christmas-comp-trial-for-extra-species
Sheet: Flathead

FLATHEAD
Angler # | Length (mm) | Angler Name | Age Group
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
Spreadsheet: kimberly_watson__20635__010802Al
Sheet: LetterSizeRegionLoc 

ETS Planned And Unplanned Outages - January 1, 2001 Through December, 2001
Albuquerque Region Only - Sorted By Region/Location
The information provided is tentative and may be changed without further notice.  Northern Natural Gas, [NAME] and Florida Gas Transmission are not responsible for any reliance on this information.
Data Extracted August 2, 2001 |  |  |  |  |  |  |  |  |  |  | Est. Flow | Est. Vol. |  |  | Act. | Act. | Act.
No. | ID# | Location | Units | Title | EstStart | EstComp | Duration | Line | Proj. Mgr | W.O. # | Affected | Affected | DescOfWork | DescOfWork2 | Start | Compl. | [NAME]. | P/U | Pub | Ver
 |  |  |  |  |  |  |  |  |  |  | (Mmcfd) | (Mmcf)
1 | 17204 | ATOKA 2 | 843 | LOST THE BEARINGS | 2001-07-31 17:00:00 | 2001-08-05 16:00:00 | 2 |  | OPS |  | 0 | 0 | They plan to exchange the unit. It's a small unit so the flow affect is minimal. Unit 794 is down as well due to 843 being down. It can't buck the higher pressure. |  | 2001-07-31 17:00:00 |  | 0 | U | N | N
2 | 16194 | STATION 1 | 102 | SAFETY DEVICES | 2001-09-18 08:00:00 | 2001-09-20 16:00:00 | 2.3 |  | OPS |  | 50 | 116.7 | Safety devices. |  |  |  | 0 | P | N | N
3 | 16195 | STATION 1 | 101 | SAFETY DEVICES | 2001-09-25 08:00:00 | 2001-09-27 16:00:00 | 2.3 |  | OPS |  | 50 | 116.7 | Safety devices. |  |  |  | 0 | P | N | N
4 | 17090 | STATION 2 | MAINLINE | RED ROCK TIE-IN | 2001-10-22 08:00:00 | 2001-10-26 16:00:00 | 4.3 |  | OPS |  | 130 | 563.3 | New block and side valve assemblies for new compressor and scrubbers will be installed on the suction side main and loop lines at each station. The tie-in will entail isolating a line segment within the plant yard. |  |  |  | 0 | P | N | N
5 | 17091 | STATION 2 | LOOP LINE | RED ROCK TIE-IN | 2001-11-05 08:00:00 | 2001-11-07 16:00:00 | 2.3 |  | OPS |  | 130 | 303.3 | New block and side valve assemblies for new compressor and scrubbers will be installed on the sucton side main and loop lines at each station. The tie-in will entail isolating a line segment within the plant yard. |  |  |  | 0 | P | N | N
6 | 16900 | STATION 8 | MAINLINE | MAINLINE BLOCK | 2001-08-28 08:00:00 | 2001-08-31 16:00:00 | 3.3 |  | OPS |  | 0 | 0 | Remove 1 section of mainline from service for 4 days.  Block pipeline for 2 hours to use station compression to lower section pressure by transferring gas from mainline west of station to mainline east of station  then reestablish bypass conditions. |  |  |  | 0 | P | N | N
7 | 16752 | STATION 8 | 802 | AUTOMATION | 2001-09-04 08:00:00 | 2001-10-31 16:00:00 | 57.3 |  | OPS |  | 0 | 0 | Station 8 automation project. 8000 HP |  |  |  | 0 | P | N | N
Spreadsheet: 800587d1665746660-listing-the-top-10-values-of-a-range-and-their-matching-titles-cant-get-rid-of-duplicates-sample-for-excel-forum-top-10-aligw
Sheet: Sheet1

Site | MON | TUE | WED | THU | FRI | SAT | SUN | TOTAL |  | top 5
Daventry | 3 | 20 | 10 | 10 | 5 | 2 | 1 | 51
Widnes | 14 | 11 | 6 | 14 | 2 | 0 | 3 | 50 |  | Widnes
Crawley | 8 | 1 | 2 | 8 | 1 | 2 | 2 | 24 |  | Crawley
Nursling One | 6 | 6 | 2 | 4 | 2 | 1 | 0 | 21 |  | Nursling One
Snodland | 1 | 5 | 2 | 5 | 2 | 0 | 3 | 18 |  | Snodland
Wakefield | 3 | 1 | 5 | 3 | 3 | 0 | 0 | 15 |  | Wakefield
Apex | 2 | 2 | 0 | 4 | 3 | 0 | 1 | 12 |  | Apex
Enfield | 0 | 1 | 3 | 5 | 1 | 1 | 1 | 12 |  | Enfield
Doncaster | 2 | 3 | 2 | 3 | 1 | 0 | 0 | 11 |  | Doncaster
Aylesford | 2 | 2 | 1 | 2 | 1 | 2 | 1 | 11 |  | Aylesford
Spreadsheet: vkaminski__40692__lng5
Sheet: EcoElectrica

ECOELECTRICA LNG SUPPLY AGREEMENT
 |  | CABOT (Purchase Commitment) |  | EcoElectrica (Sales Commitment)
Annual Quantity MMTA |  | 0.55 MMTA |  | 0.55 MMTA + 1 Cargo LNG or 2 Cargo LPG
Lot Size |  | 119,000 m^3 or 55,000 MT |  | 119,000 m^3 or 55,000 MT
USD/MMBTU Contract Price |  | [NAME] |  | [NAME]
Contract Life Years |  | 20 Years - July 1st, 1999 - September 30, 2019 |  | 22 Year - 1/1/99 - June 2020
USD Value Annual
USD Value Contract Life
Take or PAY |  | Yes with relief if seller fails to deliver within 50 days (8.1 b) or Force Majeure 12.1 |  | No Clear mention of Take or Pay
Licenses / Permissions |  | N/A |  | Article 6.6 & Article 9
Alternative Delivery Ports |  | Not Mentioned |  | N/A
Transmission Lines Failure |  | Force Majeure clause eliminates Take or Pay obligation (12.1) |  | Contract relief under Force Majeure (17.2)
Delay in Transmission Line |  | Demurrage 6.8 |  | No Mention
Generator Failure |  | Take or Pay with relief under Force Majeure (12.1) |  | Contract relief under Force Majeure (17.2)
Seller Pipeline Failure Upstream Facilities |  | Take or Pay with relief under Force Majeure (12.1) |  | Contract relief under Force Majeure (17.2)
Seller LNG Terminal Failure |  | Take or Pay with relief under Force Majeure (12.1) |  | Contract relief under Force Majeure (17.2)
Seller LNG Ship Failure |  | Take or Pay with relief under Force Majeure (12.1) |  | Contract relief under Force Majeure (17.2)
Buyer LNG Terminal Failure |  | Take or Pay with relief under Force Majeure (12.1) |  | Contract relief under Force Majeure (17.2)
Buyer Pipeline Failure |  | Take or Pay with relief under Force Majeure (12.1) |  | Contract relief under Force Majeure (17.2)
War |  | Take or Pay with relief under Force Majeure (12.1) |  | Contract relief under Force Majeure (17.2)
Government Action |  | Force Majeure (12.1) on Vessel if not up to Coast guard specs. |  | Contract relief under Force Majeure (17.2)
Termination of Shipping |  | Buyers right to cancel 7.4 |  | No Mention
Spreadsheet: 231504d1367098248-two-misaligned-cells-16-team-planning-bracket
Sheet: 195

az195 | Aztec | 1
bl195 | Bloomfield
cib195 | Cibola
cle195 | Cleveland
far195 | Farmington
gal195 | Gallup
grt195 | Grants | 8
kc195 | [NAME]
miy195 | Miyamura | 5
new195 | Newcomb
pv195 | Piedra Vista
rr195 | Rio Rancho
sf195 | Santa Fe
ship195 | Shiprock
vv195 | [NAME] | 4
win195 | Wingate
 |  | 3
Paste Value - CTRL-N
 |  | 6
 |  | 7
 |  | 2
Spreadsheet: 800517d1665694618-how-to-group-values-together-where-each-group-is-or-a-specific-total-grouped-runs
Sheet: Sheet1

RUN# | RUN WATTAGE | Group Wattage | Group | Percent | Smallest
 | A |  | 0
1 | 24
2 | 64
3 | 40
4 | 72
5 | 57
6 | 20
7 | 16
8 | 38
9 | 52
10 | 74
11 | 27
12 | 10
13 | 16
14 | 44
15 | 50
16 | 32.5
17 | 55.5
18 | 18
19 | 17.5
20 | 41.1
21 | 35
22 | 20.5
23 | 77
Spreadsheet: 105105d1302565433-identifying-number-associated-with-most-recent-unique-id-sample-worksheet
Sheet: Sheet1

Unique ID | Activities | Total Number of Activities |  |  | Check ID
JANUARY |  |  |  |  | 7
1 | 1
2 | 1
3 | 1
4 | 1
FEBRUARY
1 | 1
2 | 1
3 | 1
4 | 1
5 | 1
6 | 1
7 | 1
[NAME]
1 | 1
2 | 1
3 | 1
4 | 1
7 | 1
8 | 1
9 | 1
Spreadsheet: 167134d1341913368-comparing-and-mark-data-from-two-different-worksheet-prototaip
Sheet: Submitted

Prod. Order | Opn. Number | Document type | LPI | MPI | Visual | UT
112290809 | 2900
112321376 | 2400
112471897 | 0800
112471898 | 0800
112471899 | 0800
112471900 | 0800
112418150 | 0900
112318928 | 3800
112408947 | 0600
112408968 | 0600
112440296 | 0800
112450719 | 0900
112450721 | 0900
112419492 | 2200
Spreadsheet: 64486d1265319657-two-matches-to-return-a-result-example-1-
Sheet: Example

Ref # | SITE_NO | GL_CODE | Milestone | Commitment milestone | Commitment Date | Month & Year
73038 | A0001 | 912100 | MERCS | PREFC |  | Mar-10
73038 | A0001 | 916240 | RFI | SAE |  | Dec-09
73038 | A0001 | 916250 | RFI | SAE |  | Dec-09
73038 | A0001 | 919570 | PREFC | REL |  | Jul-09
78894 | A0001 | 916240 | RFI | SAE |  | Aug-09
81169 | A0001 | 916240 | RFI | SAE |  | Dec-09
81169 | A0001 | 916250 | RFI | SAE |  | Dec-09
81169 | A0001 | 919570 | PREFC | REL |  | Sep-09
81169 | A0001 | 912100 | MERCS | PREFC |  | Mar-10
81731 | A0001 | 916240 | RFI | SAE |  | Nov-09
83209 | A0001 | 916250 | RFI | SAE |  | Dec-09
83209 | A0001 | 916240 | RFI | SAE |  | Dec-09
72454 | A0002 | 916240 | RFI | SAE |  | May-09
79154 | A0002 | 916240 | RFI | SAE |  | Aug-09
81360 | A0002 | 916240 | RFI | SAE |  | Nov-09
Spreadsheet: 47541d1246568997-formula-to-recognize-consecutive-entries-samplesched
Sheet: Sheet1

Shitfs | 2009-07-27 00:00:00 | 2009-07-28 00:00:00 | 2009-07-29 00:00:00 | 2009-07-30 00:00:00 | 2009-07-31 00:00:00 | 2009-08-01 00:00:00 | 2009-08-02 00:00:00 | 2009-08-03 00:00:00 | 2009-08-04 00:00:00 | 2009-08-05 00:00:00 | 2009-08-06 00:00:00 | 2009-08-07 00:00:00 | 2009-08-08 00:00:00 | 2009-08-09 00:00:00
 | S | M | T | W | T | F | S | S | M | T | W | T | F | S | 5 In A Row Pass/Fail
Employee 1 | a | b | c |  | e | f | g | h |  |  | k | l | m | n
Employee 2 | d |  |  | d | r | u | i |  | s | j | r | k | l | l
Employee 3 | a | b | c |  | e | f | g | h |  |  | k | l | m | n
Employee 4 | d |  |  | d | r | u | i |  | s | j | r | k | l | l
Employee 5 | a | k | c |  | e | f | g | h |  |  | k | l | m | n
Employee 6 | d |  |  | d | r | u | i |  | s | j | r | k | l | l
Employee 7 | a | n | c | l | e | s | g | h | a |  | k | l | m | n
Employee 8 | d |  |  | d | r | u | i |  | s | j | r | k | l | l
Employee 9 | a | b | c |  | e | f | g | h |  |  | k | l | m | n
Employee 10 | d |  |  | d | r | c | i | u | a | j | p | k | l | l
Employee 11 | a | b | c |  | e | r | g | h |  |  | k | l | m | n
Employee 12 | d |  |  | d | r | u | i |  | s | j | r | k | l | l
Employee 13 | a | b | c |  | e | f | g | h |  |  | k | l | m | n
Spreadsheet: 488181d1478543291-complex-formula-based-on-wbs-formula-gantt-chart-template-2
Sheet: Formulas

LEVEL
 | [ Level 1 Task ]
 | . [ Level 2 Task ]
 | . . [ Level 3 Task ]
 | . . . [ Level 4 Task ]
 | . . . . [ Level 5 Task ]
 | . . . . . [ Level 6 Task ]
WBS
 | [ Level 1 Task ]
 | . [ Level 2 Task ]
 | . . [ Level 3 Task ]
 | . . . [ Level 4 Task ]
 | . . . . [ Level 5 Task ]
 | . . . . . [ Level 6 Task ]
Spreadsheet: 69242d1269792074-excel-2007-auto-sum-and-fill-in-prem3
Sheet: Sheet1

Spurs | Prediction | Result | Man City | Prediction | Result | [NAME] | Prediction | Result | Liverpool | Prediction | Result
Portsmouth | W | W | Everton | D | L | Sunderland | W | D | Sunderland | W
Sunderland | W |  | [NAME] | W |  | Chelsea | L | L | Birmingham | D
Arsenal | L |  | Burnley | W |  | [NAME] | W |  | Fulham | W
Chelsea | L |  | Birmingham | W |  | Everton | D |  | West Ham | W
Man United | L |  | Man United | L |  | Portsmouth | D |  | Burnley | D
[NAME] | W |  | Arsenal | L |  | Hull | W |  | Chelsea | L
Man City | D |  | [NAME] | D |  | Birmingham | D |  | Hull | W
Burnley | W |  | Spurs | D |  | Man City | D
 |  |  | West Ham | W |  | [NAME] | W
Total Points |  |  | Total Points |  |  | Total Points |  |  | Total Points
 | +/- |  |  | +/- |  |  | +/- |  |  | +/-
 | 0 |  |  | -1 |  |  | -2 |  |  | 0
Spreadsheet: 3c4b5ca7-90c8-4bf4-9251-22a8f9823a33
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
40864260 | 2014-04-06 05:52:17 | ALLIES | 0 | 2 | 6 | 691774 | player691774 | 6152 | western | 1944-12-20 | 1944-12-22 | [NAME] | St. Vith
40864417 | 2014-04-06 06:08:33 | AXIS | 1 | 6 | 1 | 691774 | player691774 | 6152 | western | 1944-12-20 | 1944-12-22 | [NAME] | St. Vith
40875935 | 2014-04-06 22:12:48 | AXIS | 1 | 7 | 3 | 1554097 | 3rdAD | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
40876279 | 2014-04-06 22:30:40 | ALLIES | 1 | 7 | 4 | 1554097 | 3rdAD | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
40892325 | 2014-04-07 23:50:54 | AXIS | 1 | 7 | 3 | 67493 | [NAME] | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
40892490 | 2014-04-08 00:07:14 | ALLIES | 1 | 7 | 2 | 67493 | [NAME] | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
41017686 | 2014-04-16 17:39:45 | ALLIES | 1 | 6 | 3 | 769112 | puller | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
41017984 | 2014-04-16 17:57:05 | AXIS | 0 | 2 | 6 | 769112 | puller | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
41035837 | 2014-04-17 22:34:01 | ALLIES | 0 | 3 | 5 | 1542223 | guy.warmoes | 7334 | mediterranean | 1941-11-22 | 1941-11-22 | [NAME] | [NAME]
41035964 | 2014-04-17 22:43:24 | AXIS | 1 | 5 | 3 | 1542223 | guy.warmoes | 7334 | mediterranean | 1941-11-22 | 1941-11-22 | [NAME] | [NAME]