tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 28636fb2-4c4d-477a-8adf-8f60256ccac2
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | (Discipline) Review Comment Resolution Form | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Disposition Codes | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | Project Name |  |  | Reviewer |  | A - Accept Comment |  | C - Delete Comment
 | Project No. |  |  | Review Date |  | B - Designer to Evaluate |  | D - UDOT to Evaluate
 | Comment No. | Page No. | Comment | Initial Disposition | Response / Clarification | Final Disposition | Response By | Date | Verified
 |  |  | By signing below, I verify that all review comments submitted for this review are resolved.
 |  | Reviewer: |  | Designer:
 |  | Date: |  | Date:
Spreadsheet: 774429d1648474217-vba-dynamic-list-from-same-column-on-multiple-sheets-forrick
Sheet: Vehicles2

 | Vehicles2 List
 | v2123
 | v2124
 | v2125
 | v2126
 | v2127
 | v2128
 | v2129
 | v2130
 | v2131
 | v2132
 | v2133
 | v2134
 | v2135
 | v2136
 | v2137
 | v2138
 | v2139
 | v2140
 | v2141
Spreadsheet: 129469d1321628176-excel-2007-counting-days-between-two-set-dates-days-of-work-with-subtotal
Sheet: Sheet1

 |  |  | 4 | 4 | 7
weeks | months | Dates | mark | mary | [NAME]
46 | 11 | 2011-11-10 00:00:00 | x |  | x
46 | 11 | 2011-11-11 00:00:00 |  | x | x
46 | 11 | 2011-11-12 00:00:00 | x |  | x
47 | 11 | 2011-11-13 00:00:00 |  | x | x
47 | 11 | 2011-11-14 00:00:00 | x |  | x
47 | 11 | 2011-11-15 00:00:00 | x | x | x
47 | 11 | 2011-11-16 00:00:00 | x |  | x
47 | 11 | 2011-11-17 00:00:00 |  | x | x
47 | 11 | 2011-11-18 00:00:00 | x |  | x
47 | 11 | 2011-11-19 00:00:00 |  | x | x
52 | 12 | 2011-12-20 00:00:00 | x |  | x
48 | 11 | 2011-11-21 00:00:00 | x |  | x
48 | 11 | 2011-11-22 00:00:00 | x | x | x
48 | 11 | 2011-11-23 00:00:00 | x |  | x
48 | 11 | 2011-11-24 00:00:00 | x |  | x
Spreadsheet: 683386d1592682555-formula-to-get-data-for-each-material-and-then-sort-the-data-according-to-start-date-leprince
Sheet: Report

 |  |  |  |  | RDF
 | [NAME] | Supplier | Material | Start Date | End Date
Spreadsheet: 673072d1587143917-find-a-value-on-a-row-and-sum-the-values-below-till-a-certain-point-practice
Sheet: Summary

Policy ID | LE | Benefit | Value @ 16% | Total Premiums | Value + Total Premiums | Profit (Benefit - Total Cost) | Average annual premium | Premium % of Face | LE # for Profit to be 0 or less than 0
126694 | 63 | 187500 | 25756.02986646869
127456 | 51 | 100000 | 20804.6675134961
127333 | 66 | 509592.61 | 107169.977939696
119356 | 47 | 200000 | 47250.07480147182
127057 | 71 | 100000 | 25107.62985136141
125266 | 100 | 100583.23 | 29092.4751265517
127516 | 87 | 1000000 | 313593.9968305071
123239 | 75 | 100000 | 31491.15315358627
124948 | 95 | 100000 | 32763.15958452208
126634 | 88 | 490650 | 162114.1997209237
115342 | 87 | 150000 | 51596.54640172246
124722 | 42 | 121450 | 44665.81909037519
127273 | 63 | 100000 | 38062.50614914174
125718 | 43 | 375000 | 147638.9756181938
122916 | 43 | 200000 | 80038.3820688077
125888 | 40 | 650000 | 270408.395570875
126951 | 27 | 100000 | 42247.97119231508
121439 | 48 | 750000 | 329723.5321359504
114774 | 31 | 100000 | 44064.30283534287
106623 | 41 | 500000 | 229544.1076312124
123486 | 54 | 151000 | 70578.1690371495
125778 | 52 | 100000 | 48161.48501113735
125401 | 38 | 100000 | 48933.87176742308
121378 | 54 | 500000 | 248391.9292457983
124613 | 31 | 400000 | 205074.4865510267
124482 | 55 | 100000 | 51460.5146326454
119168 | 56 | 100000 | 51870.41821700431
127188 | 51 | 350000 | 188974.8881441789
125196 | 33 | 137000 | 75583.04773043573
126881 | 31 | 200000 | 116021.189600242
125839 | 45 | 500000 | 293191.8430122429
26666 | 19 | 471311.71 | 278902.7286496315
122702 | 38 | 125000 | 76939.47267672942
114769 | 37 | 700000 | 438904.3795652366
124807 | 33 | 469200 | 295606.2667845979
124200 | 21 | 200000 | 131818.743753186
123985 | 31 | 100000 | 66622.61521665491
68249 | 28 | 1000000 | 705358.0137483685
124292 | 15 | 100000 | 71462.16173263727
121572 | 25 | 100000 | 71993.35413622946
126245 | 17 | 100000 | 77870.17330797584
124338 | 14 | 115985.65 | 92788.52
Spreadsheet: 8c366beb-61e2-48b0-8ef4-236adab184d9
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | EcoCheck Data: Overall Bay for 2010
Indicator | 2010
Chlorophyll a | 21.946
Aquatic Grasses | 36.99928571
[NAME] | 80.81401
[NAME] | 46.7
Water Clarity | 18.457
Phytoplankton Index | 49.5
Water Quality Index | 40.40567
Biotic Index | 44.3997619
Bay Health Index | 42.40271595
Spreadsheet: 176a3ae7-cb08-4af3-a77f-923e815badfb
Sheet: Control Area

Forward Capacity Auction Result Report
SP_FCARESULT_<customer id>_<commitment period begin>_<version>.CSV
<[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
 | Control Area Information |  |  |  | Capacity Supply Obligation Details
Commitment Period | Installed Capacity Requirement | HQICC | Net Installed Capacity Requirement | Capacity Supply Obligation | RTEG Capacity Supply Obligation | RTEG Utilization Ratio | Self-Supply Obligation | Import Capacity Supply Obligation
Date | MW | MW | MW | MW | MW | Number | MW | MW
Spreadsheet: 136071d1326393928-production-and-inventory-adjustment-mra
Sheet: Overview

General Overview
Bullets on Hand |  |  | Materials on Hand
 | Amount | Value |  | Amount | Value
.357 Mag | 0 | 0 | .357 Mag Case | 0
9mm | 366 |  | 9mm Case | 0
.38 Special | 0 |  | .38 Special Case | 0
.40 cal | 0 |  | .40 cal Case | 0
.45 cal | 50 |  | .45 cal Case | 301
 |  |  | .357 Mag Bullet | 0
 |  |  | 9mm Bullet | 0
 |  |  | .38 Special Bullet | 0
 |  |  | .40 cal Bullet | 0
 |  |  | .45 cal Bullet | 0
 |  |  | Small Primers | 0
 |  |  | [NAME] | 0
 |  |  | Gun Powder | 7000
Totals: |  |  | Totals:
Total Assets
Bullet and Material Value
Equipment
Capitol Investments
Total:
Purchases:
Sales:
Profit/Loss:
Spreadsheet: 215000d1361221050-formula-to-return-an-offset-value-depending-on-a-condition-report-looking-right-first-column
Sheet: Class Stats

 | Date | Graph Data | Graph Data
 |  | Start | Current
 | Wa
 | Wb
 | Wc
Count | 1a
 | 1b
 | 1c
 | 2a
 | 2b
 | 2c
 | 3a
 | 3b
 | 3c
 | 4a
 | 4b
 | 4c
 | 5a
 | 5b
 | 5c
 |  | No of Writes
 |  | Scored
Spreadsheet: sally_beck__33713__MgmtSum-Q2-0623 version a
Sheet: Headcount

PLAN2000 | ENRON NORTH AMERICA
TOT_COM_HC | 2ND QUARTER 2000 HEADCOUNT
TOT_NC_HC
2000-03-01 00:00:00
2000-04-01 00:00:00
M.QTD |  |  | Actuals - April Team Report |  |  |  | Plan - April |  |  |  | Variance to Plan
ENA | Business Team |  | Commercial | Other | Total |  | Commercial | Other | Total |  | Commercial | Other | Total
[NAME] | Gas Trading
[NAME] | Power Trading
IR_FX | Financial Drift
[NAME] | Financial Trading
CANADA | Canada Trading
COAL | Coal-Trading
WEATHER | GRM -  Weather
SO2 | Emissions
INSURANCE | GRM - New Products
 | Total Trading & Risk Management
E_ORG | East Midstream
W_ORIG | West Midstream
DWNSTRM_IND_ORIG | Industrial Downstream - Paper
MDSTRM_IPP_ORIG | Midstream IPP
 | Coal Origination & Trading
 | Canada Origination & Finance |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
MEXICO | Mexico
 | Total Origination
N_BS_DEV | Generation Investments
ASST_ORIG | ENA Upstream Assets
ASST_TRD | ENA Upstream Assets - Trading
 | Total Assets |  |  |  |  |  |  |  |  |  |  | Trading | 5000
EQUITY | Principal Investing
PROD_FIN | Energy Capital Resources
ASST_MGT_AND_RESTRCT | Special Assets
CTG_ASSETS | CTG Assets
 | CTG Assets
 | Total Investing
CTG | Commercial Transactions Group
OF_CHAIR | Office of the Chairman
 | Total Commercial
GROUP | Group
GROUP
ACTUAL | Total
Spreadsheet: d1ebf0fd-ad9b-456b-9624-3c704d4fdfba
Sheet: Scoring

Scoring
Sort White Cells by: | 1.  Name (Lowest - Highest) |  |  |  |  |  |  |  |  | Seeding Weights
 | 2.  Term Code (lowest- highest) |  |  |  |  |  |  |  |  | Term 1 | 60
 | 3.  Term 1 (highest - lowest) |  |  |  |  |  |  |  |  | Term 2 | 40
Delete: | 1.  Pilots without Comp Code C contest |  |  |  |  |  |  |  |  | Total
 | 2.  Teams
Section 1 Keep: | Best result with Term Code = 1 AND Country Code = C, W or P
Section 2 cut&paste: | Next best result. If Section 1 is not Country Code C, then Section 2 must be Country Code C.
Delete: | Remaining contest results |  |  |  |  |  |  |  |  | FAI
Cleanup: | Section 3 by Copy&Paste of the "Seed Formatting" line to the rest of the pink section |  |  |  |  |  |  |  |  | Club
 |  |  |  |  |  |  |  |  |  | ERROR: No Can Nats
Section 1 |  |  |  |  | Section 2 |  |  |  | Section 3
 |  |  |  | Term 1 |  |  |  | Term 2 |  | SEEDING GROUP | Seeding Points
Seed Formatting
Spreadsheet: 135522d1326111549-lookup-help-staff-planner-test
Sheet: PLANNER 

ID | First name | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F
 |  | 2013-02-01 00:00:00 | 2013-02-02 00:00:00 | 2013-02-03 00:00:00 | 2013-02-04 00:00:00 | 2013-02-05 00:00:00 | 2013-02-06 00:00:00 | 2013-02-07 00:00:00 | 2013-02-08 00:00:00 | 2013-02-09 00:00:00 | 2013-02-10 00:00:00 | 2013-02-11 00:00:00 | 2013-02-12 00:00:00 | 2013-02-13 00:00:00 | 2013-02-14 00:00:00 | 2013-02-15 00:00:00
1 | sean |  |  |  |  |  |  |  |  |  | hh | hh | h
2 | [NAME] | h |  | h |  | h | h | h | h | h
3 | [NAME]
4 | wayne | h | h | h | h | h | h |  |  | h | h | h | h
5 | bob
6 | [NAME]
7 | Mark |  |  | hh |  |  | h |  |  |  | hh |  |  |  | hh
8 | [NAME]
9 | [NAME] |  |  |  | h | h |  | h |  |  | h | h
10 | [NAME]
11 | Stuart |  |  |  |  |  |  | h | h | h | h | hh | h
12 | [NAME] |  |  |  | h
13 | [NAME]
14 | [NAME] |  |  |  |  |  | h |  |  | hh |  |  | h
15 | Reece
16 | Stand
 | enter id no |  |  | total days holiday booked
 |  |  |  |  | 10
 | 4 | 01-02-2013/02-02-2013/03-02-2013/04-02-2013/ 05-02-2013/06-02-2013/09-02-2013/10-02-2013/ 11-02-2013/12-02-2013/
Spreadsheet: 877904d1724846480-search-for-partial-matches-in-a-list-nunez100-example-v2-tms
Sheet: Sheet1 (Original)

 | Sample edited to cause issue identified
Result | Input Data |  |  |  | Return Values | Search Term
[NAME] | BANK GIRO CREDIT REF Parson |  |  |  | [NAME] | Parson
Nikita Smith | Transfer fia faster payment to Smith 465 |  | Nikita Smith |  | Nikita Smith | Smith
[NAME] | BANK GIRO CREDIT REF Henry 143 |  | [NAME] |  | [NAME] | [NAME]
Nikita Smith | BANK GIRO CREDIT REF Smith |  | Nikita Smith |  | [NAME] | [NAME]
[NAME] | Transfer via faster payment to [NAME] |  | [NAME] |  | Jacinta [NAME] | [NAME]
[NAME] | BANK GIRO CREDIT REF [NAME] |  | *** check *** |  | [NAME] | [NAME]
Jacinta [NAME] | BANK GIRO CREDIT REF Uppham 29 |  | Jacinta [NAME] |  | [NAME] | [NAME]
[NAME] | BANK GIRO CREDIT REF Maguire 463 |  | [NAME] |  | [NAME] | Maguire
[NAME] | Direct Debit Payment to Perry 453 |  | [NAME]
[NAME] | BANK GIRO CREDIT REF Howie 309654 |  | [NAME]
[NAME] | BANK GIRO CREDIT REF Howie 309654 |  | [NAME]
[NAME] | Direct Debit Payment to Parson |  | [NAME]
[NAME] | BANK GIRO CREDIT REF Maguire 463 |  | [NAME]
[NAME] | Transfer via faster payment to [NAME] |  | [NAME]
Jacinta [NAME] | BANK GIRO CREDIT REF Uppham 29 |  | Jacinta [NAME]
[NAME] | Direct Debit Payment to Maguire 463 |  | [NAME]
[NAME] | BANK GIRO CREDIT REF [NAME] |  | [NAME]
 |  |  | Original formula:
 |  |  | Nikita Smith
 |  |  | [NAME]
 |  |  | Nikita Smith
 |  |  | [NAME]
 |  |  | [NAME],[NAME]
 |  |  | Jacinta [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | Jacinta [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
Spreadsheet: 170638d1343337920-separating-cells-containing-values-separated-by-commas-while-keeping-the-rows-columns-samplebook-modified-by-tigeravatar-
Sheet: Sheet1

WHAT THE SHEET LOOKS LIKE NOW"
category | performer | country | profession | sex | 0
Baseball | [NAME], [NAME], [NAME], [NAME] | America | athlete | male
music | mariah carey, [NAME], [NAME], lady gaga | America | singer | female
WHAT THE SHEET NEEDS TO LOOKS LIKE:
category | performer | country | profession | sex
Spreadsheet: 726052d1617029405-convert-data-from-skills-matrix-into-analyzable-data-model-by-employees-skills-in-rows-sample-original-data-and-desired-result
Sheet: Desired result

Team | Employee | Background | Country | Skill | Level
X | employee 1 | Art | Germany | Hardware A | EXPERT
X | employee 1 | Art | Germany | Hardware B | EXPERT
X | employee 1 | Art | Germany | Hardware C | EXPERT
X | employee 1 | Art | Germany | Hardware D | EXPERT
X | employee 1 | Art | Germany | Hardware E | EXPERT
X | employee 1 | Art | Germany | Hardware F | EXPERT
X | employee 1 | Art | Germany | Software A | EXPERT
X | employee 1 | Art | Germany | Software B | EXPERT
Y | employee 2 | Science | France | Hardware A | ADVANCED
Y | employee 2 | Science | France | Hardware B | ADVANCED
Y | employee 2 | Science | France | Hardware C | EXPERT
Y | employee 2 | Science | France | Hardware D | EXPERT
Y | employee 2 | Science | France | Hardware E | EXPERT
Y | employee 2 | Science | France | Hardware F | EXPERT
Y | employee 2 | Science | France | Software A | ADVANCED
Y | employee 2 | Science | France | Software B | ADVANCED
Z | employee 3 | Enginieer | Belgium | Hardware A | ADVANCED
Z | employee 3 | Enginieer | Belgium | Hardware B | ADVANCED
Z | employee 3 | Enginieer | Belgium | Hardware C | EXPERT
Z | employee 3 | Enginieer | Belgium | Hardware D | EXPERT
Z | employee 3 | Enginieer | Belgium | Hardware E | EXPERT
Z | employee 3 | Enginieer | Belgium | Hardware F | EXPERT
Z | employee 3 | Enginieer | Belgium | Software A | ADVANCED
Z | employee 3 | Enginieer | Belgium | Software B | ADVANCED
Spreadsheet: b5ae3b12-efe7-4cee-aa72-7492535eb4a8
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | Name: |  |  | Vorname:
 | Strasse: |  |  | Plz + Ort
 | Tel./Handy: |  |  | [NAME].:
 | E-Mail:
 | Bestellung:
 | Art. Nr. | Beschrieb |  | Farbe | Grösse | Menge | Preis /Stk. | Total
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 | Datum, Unterschrift: |  |  |  |  | Total excl. Porto: |  | 0
 | Bitte die Bestellkarte an folgende Adresse schicken: Ombretta Rüsch, 1188 St. George, [EMAIL]
Spreadsheet: 481710d1474612610-add-new-data-to-correct-column-481704d1474608619-add-new-data-to-correct-column-sample-1
Sheet: Validation Data

xxxxx
[NAME]
As a new
 | Type
 | AAAA
 | AAAB
 | AAAC
 | AAAD
 | DAAA
Spreadsheet: 9da89c53-59ed-4f13-8709-d4a5282d2bc6
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
[NAME] | Test | [NAME] | Respiratory Syncytial Virus (RSV), Molecular Detection, PCR | Respiratory Syncytial Virus, PCR | [NAME] (RT-PCR) |  |  |  |  |  | Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen.  [NAME] source is required.   Submit only 1 of the following specimens:   Preferred: [NAME]: Nasal or nasopharyngeal aspirate Container/Tube: Sterile container [NAME]: 0.5 mL   Specimen Type: Nasopharyngeal or throat  Container/Tube: Nasopharyngeal swab (rayon mini-tip swab) or throat swab [NAME] Additional Information: Swab may be placed in M5 media for transport.   Acceptable: [NAME]: Nasopharyngeal washing, bronchial washing, bronchial brushing, or bronchoalveolar lavage Container/Tube: Sterile container [NAME]: 0.5 mL | Bronchial washing, bronchoalveol | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	Calcium alginate-tipped swab, wood swab, or transport swab containing gel | Not applicable | Monday through Sunday | Same day/1 day | 2 days | 1 | 87798 |  |  |  |  | Rochester
[NAME] | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
[NAME] | Order Question | SRC77 | RSV Source |  | Plain Text
[NAME] | Result | SRC77 | RSV Source | RSV Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
[NAME] | Result | 32286 | Respiratory Syncytial Virus, PCR | Respiratory Syncytial Virus, PCR | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40988-8 | Respiratory syncytial virus RNA:ACnc:Pt:[NAME]:[NAME]:Probe.amp.tar
Spreadsheet: 878699d1725953553-formula-so-that-excell-takes-in-consideration-a-value-before-calculating-airfreight-calculator
Sheet: Sheet2

 |  | Airport of destination | Carrier | Currency | Min Charges | <45KG | 45kg | 100kg | 300kg | 500kg | 1000kg | FSC | Screening | Handling | FOB | Actual weight |  | FOB PRICE |  | AIRFREIGHT PRICE |  | TOTAL PRICE
 |  | Abidjan | LH | EUR | 110 | 6.17 | 4.7 | 2.8 | 2.7 | 2.6 | 2.5 | 1 | 0,13€/KG (min 55€) | Base 20 EUR + 0.12 EUR/kg | 92 EUR
 |  | Abidjan | AF | EUR | 170 | 6.86 | 5.04 | 4.76 | 4.6 | 4.43 | 4.3 | 0 | 0,13€/KG (min 55€) | Base 20 EUR + 0.12 EUR/kg | 92 EUR
 |  | Accra | LH | EUR | 110 | 5.89 | 5.44 | 4.1 | 4.1 | 4.1 | 3.35 | 1 | 0,13€/KG (min 55€) | Base 20 EUR + 0.12 EUR/kg | 92 EUR
 |  | Conakry | LH | EUR | 110 | 9.06 | 6.24 | 5.1 | 5.1 | 5.1 | 5.1 | 1 | 0,13€/KG (min 55€) | Base 20 EUR + 0.12 EUR/kg | 92 EUR
 |  | Douala | LH | EUR | 110 | 6.88 | 5.7 | 4.1 | 3.8 | 3.8 | 3.8 | 1 | 0,13€/KG (min 55€) | Base 20 EUR + 0.12 EUR/kg | 92 EUR
 |  | Douala | TK | EUR | 170 | 7.42 | 6.68 | 6.03 | 5.73 | 5.67 | 5.5 | 0 | 0,13€/KG (min 55€) | Base 20 EUR + 0.12 EUR/kg | 92 EUR
 |  | Freetown | LH | EUR | 110 | 10.2 | 9.3 | 7.58 | 7.23 | 6.73 | 6.73 | 1 | 0,13€/KG (min 55€) | Base 20 EUR + 0.12 EUR/kg | 92 EUR
 |  | Kinshasa | 4W | EUR | / | 4.95 | 4.95 | 4.95 | 4.95 | 4.95 | 4.95 | 0.5 | 0,13€/KG (min 55€) | Base 20 EUR + 0.12 EUR/kg | 92 EUR
 |  | Kinshasa | LH | EUR | 110 | 5.2 | 4.21 | 3.5 | 3.3 | 3.1 | 3.1 | 1 | 0,13€/KG (min 55€) | Base 20 EUR + 0.12 EUR/kg | 92 EUR
 |  | Lagos | QR | EUR | 175 | 4.75 | 4.3 | 4.2 | 4.1 | 4 | 3.8 | 0 | 0,13€/KG (min 55€) | Base 20 EUR + 0.12 EUR/kg | 92 EUR
 |  | Lagos | LH | EUR | 80 | 6.16 | 5.07 | 4.47 | 4.27 | 4.25 | 4 | 1 | 0,13€/KG (min 55€) | Base 20 EUR + 0.12 EUR/kg | 92 EUR
 |  | Lubumbashi | BU | EUR | 195 | 7 | 6 | 5.8 | 5.4 | 5.3 | 4.95 | 0 | 0,13€/KG (min 55€) | Base 20 EUR + 0.12 EUR/kg | 92 EUR
 |  | Monrovia | LH | EUR | 80 | 9.1 | 7.66 | 6.73 | 6.42 | 5.92 | 5.92 | 1 | 0,13€/KG (min 55€) | Base 20 EUR + 0.12 EUR/kg | 92 EUR
 |  | Sao Tome | LH | EUR | 35 | 5.85 | 5.5 | 5.4 | 5.25 | 5 | 4.5 | 0.35 | 0,13€/KG (min 55€) | Base 20 EUR + 0.12 EUR/kg | 92 EUR
Spreadsheet: 186858d1350262210-countif-function-across-columns-worksheets-countifs-that-get-bigger-and-bigger
Sheet: Sheet1

[NAME] | ADM_YR | ADM_MTH | AGE_GRP | SEX | IND_STATUS | LOS | PD | OD_1 | OD_2 | OD_3 | OD_4 | EX_C | activity_code | Selected_Facility | Selected_Area
A | 1995 | 4 | 0 | 1 | 9 | 8 | 185 | 9973 | 4281 | 5990 | 417 |  | None | Selected Fac | Selected Area
A | 1995 | 5 | 4 | 2 | 9 | 3 | 185 |  |  |  |  |  | None | Selected Fac | Selected Area
A | 1995 | 7 | 2 | 1 | 9 | 30 | 185 | 1985 | 5990 |  |  |  | None | Selected Fac | Selected Area
A | 1995 | 11 | 7 | 1 | 4 | 2 | 185 |  |  |  |  |  | None | Other Facility | Selected Area
A | 1995 | 9 | 54 | 2 | 4 | 5 | 185 | 5990 |  |  |  | 88507 | None | Selected Fac | Selected Area
A | 1995 | 8 | 68 | 2 | 4 | 1 | 185 | V73313 |  |  |  |  | None | Selected Fac | Selected Area
A | 1995 | 12 | 85+ | 2 | 9 | 1 | 185 | 1990 | 4140 |  |  |  | None | Selected Fac | Selected Area
A | 1995 | 2 | 24 | 1 | 9 | 4 | 185 |  |  |  |  |  | None | Selected Fac | Selected Area
A | 1995 | 1 | 64 | 1 | 9 | 3 | 185 | 1990 |  |  |  |  | None | Selected Fac | Other Area
A | 1995 | 1 | 25 | 2 | 4 | 2 | 185 | 416 |  |  |  |  | None | Selected Fac | Selected Area
B | 1995 | 8 | 34 | 2 | 4 | 2 | 185 | 417 | 4011 |  |  |  | None | Selected Fac | Selected Area
B | 1995 | 10 | 85+ | 1 | 4 | 30 | 185 |  |  |  |  |  | None | Selected Fac | Selected Area
C | 1995 | 12 | 0 | 2 | 9 | 30 | 185 |  |  |  |  |  | None | Other Facility | Selected Area
C | 1995 | 11 | 0 | 2 | 9 | 30 | 185 |  |  |  |  |  | None | Selected Fac | Selected Area
C | 1995 | 6 | 1 | 1 | 4 | 6 | 185 |  |  |  |  |  | None | Selected Fac | Other Area
C | 1995 | 5 | 52 | 2 | 9 | 8 | 185 | 4140 |  |  |  |  | None | Selected Fac | Selected Area
C | 1995 | 8 | 74 | 1 | 4 | 6 | 185 |  |  |  |  |  | None | Selected Fac | Selected Area
185 = what code equals
1995 PD 185
 | A | B | C
Number of cases (total)
Male - 1
Female - 2
0 |  |  |  |  | So for the ages listed along column A (e.g., A26, A27, A28, A29, etc. - I need to either go through all of the age groups
Male - 1 |  |  |  |  | and see if areas A, B, and C come up as 0 for all counts - then I can delete OR I have to go through column D to see
Female - 2 |  |  |  |  | which ages I need to list out that have case counts
1
Male - 1
Female - 2
etc | etc
etc
Spreadsheet: 219804d1362960097-calculating-time-on-site-from-a-24-hour-clock-example-excel-file
Sheet: Sheet1

Date | Client Name | Time | Onsite | Offsite | Time On Site | Actual Time On Site | Docket_No | Job_Line_No | Response_Unit
 |  |  | 0218 | 0243 | 0.01736111111111112 | 25
 |  |  | 0430 | 0437 | 0.004861111111111122 | 7
 |  |  | 0053 | 0101 | 0.00555555555555555 | 8
 |  |  | 0752 | 0758 | 0.004166666666666652 | 6
 |  |  | 1927 | 1940 | 0.009027777777777857 | 13
 |  |  | 2257 | 2318 | 0.01458333333333339 | 21
 |  |  | 0025 | 0124 | 0.04097222222222222 | 59
Spreadsheet: 833213d1686837924-how-to-count-a-number-of-oscilating-cells-in-excell-how-to
Sheet: Sheet1

# | Values | Diff | positive Negative | Number | sum
1 | 0
2 | 2
3 | 5
4 | 12
5 | 16
6 | 18 |  |  |  |  | I want excel to sum 5 "positive" cells
7 | 11
8 | 9 |  |  |  |  | I want excel to sum 2 "positive" cells
9 | 13
10 | 16
11 | 22
12 | 27 |  |  |  |  | I want excel to sum 4 "positive" cells
13 | 25
14 | 19
15 | 15 |  |  |  |  | I want excel to sum 3 "positive" cells
Spreadsheet: 557b6bfd-16a3-42cf-b211-45e235af6aa4
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
261354 | 22133 | Mohamed | Lahna | MAR | 41 | [NAME] | 00:02:09 | 00:40:36 | [NAME] | 00:24:04 | 1 | 01:18:38
261354 | 7986 | [NAME] | Perkins | USA | 40 | 00:12:20 | [NAME] | 00:43:25 | [NAME] | 00:26:17 | 2 | 01:27:15
261354 | 7987 | Grant | [NAME] | CAN | 42 | 00:11:34 | 00:03:46 | 00:48:48 | 00:02:17 | 00:33:19 | 3 | 01:39:43
Spreadsheet: 52269d1251981674-cant-unhide-cells-and-got-hidden-formulas-personal-account
Sheet: Categories

 | CATEGORIES
1 | Food
2 | Cleaning Materials
3 | Eating Out
4 | Take Away
5 | Bank Charges
6 | Dining
7 | Electric
8 | Gas
9 | Water
10 | Council Tax
11 | House Insurance
12 | Car - Fuel
13 | Car - Insurance
14 | Car - Repair
15 | Car - Servicing & MOT
16 | Car - Tax
17 | Bike - Fuel
18 | Bike - Insurance
19 | Bike - Repair
20 | Bike - Servicing & MOT
21 | Bike - Tax
22 | Credit Card - Gold
23 | Credit Card - Virgin
24 | Credit Card - Tesco
25 | Bath Loan
26 | Bank Charges
27 | Bank Interest
28
29 | Income - Salary
30 | Income - Other
31 | Refund
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200