tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 97844abf-eda1-4a7a-aa6b-5bc25184c53b
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
A1APP | Test | A1APP | Alpha-1-Antitrypsin Phenotype | Alpha-1-Antitrypsin Phenotype | A1AP2/7574: [NAME]: Nephelometry | Plain, Red-Top or serum gel tube: Red |  |  |  |  | Container/Tube:  Preferred: Serum gel Acceptable: Red top [NAME]: 1.25 mL Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.5 mL | Hemolysis	Mild reject; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | ALPHA-1-ANTITRYPSIN 100-190 mg/dL   ALPHA-1-ANTITRYPSIN PHENOTYPE Most normal individuals have the M phenotype (M, M1, or [NAME]). Over 99% of M phenotypes are genotypically MM. In the absence of family studies, the phenotype (M) and quantitative level can be used to infer the genotype (MM). The most common alleles associated with a quantitative deficiency are Z and S. The reports for the rare alleles will indicate whether or not they have been associated with reduced quantitative levels. | Monday through Friday; 9 a.m. | 2 days | 6 days |  | Profile |  |  |  |  | Rochester
A1APP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
A1APP | Component | A1AP2 | Alpha-1-Antitrypsin (A1A) Phenotype | Alpha-1-Antitrypsin Phenotype | [NAME] | Serum Gel Tube: SGT |  |  | 1 | mL |  | 0.5 mL | Specimens Other Than: Anticoagulants Other Than: Hemolysis: Thawing: Lipemia: |  | Monday through Friday; 9 a.m. | 2 days | 6 days | 1 | 82104 |  |  | Yes | No
A1AP2 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
A1AP2 | Result | 8166 | Alpha-1-Antitrypsin Phenotype | Alpha-1-Antitrypsin Phenotype | Alphanumeric |  |  |  |  | bands |  |  |  |  |  |  |  |  |  | 32769-2
A1APP | Component | AATP | Alpha-1-Antitrypsin (A1A), Serum | Alpha-1-Antitrypsin, S | Nephelometry Only orderable as part of a profile. For further information see #26953 "Alpha-1-Antitrypsin Phenotype, Serum." | Serum Gel Tube: SGT |  |  | 1 | mL | Only orderable as part of a profile. For further information see #26953 Alpha-1-Antitrypsin Phenotype, Serum. | 0.5 mL |  | Only orderable as part of a profile. For further information see #26953 "Alpha-1-Antitrypsin Phenotype, Serum." | Monday through Saturday; 3 p.m. | 1 day/same day | 2 days | 1 | 82103 |  |  | Yes | Yes (Order AAT)
AATP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
AATP | Result | AATP | Alpha-1-Antitrypsin, S | Alpha-1-Antitrypsin, S | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 6771-0
Spreadsheet: 840318d1692644654-how-many-steel-bar-do-i-need-jululian
Sheet: Blad1

N | [NAME] |  |  |  |  |  |  |  |  |  |  |  | site | https://www.opticutter.com/linear-cut-list-calculator
M | cut pipes |  |  |  |  |  |  |  |  |  |  |  | manual | https://www.opticutter.com/public/doc/import
K | 3
@ | Length | Quantity
S | 6000
@ | Length | Quantity | Label
P | 3000 | 1 | My pipe 1
P | 1100 | 2 | My pipe 2
P | 1800 | 1 | My pipe 3
P | 5000 | 1 | My pipe 4
Spreadsheet: 52d26a91-5e1e-4e23-9d93-90d6fec646e3
Sheet: Current Flow

Table 2.3.1.  Current Flow Analysis
Complete the cells in gray.  Some cells have pulldown menus.  Please use if present.
I/I Estimation Methodology:
WWTP ADF (gpd):
WWTP Min ADF (gpd) (if applicable):
Percent of LGU in WWTP Service Area:
 | Water ADF | WW ADF
 | (gpd) | (gpd)
Residential:
Commercial:
Industrial:
Flow Commitments:
Infiltration/Inflow:
Total Estimated ADF (gpd):
aIf the WWTP service area is the entire sewershed service area, then enter 100%.
Spreadsheet: 799023d1664883152-find-match-and-count-test
Sheet: Sheet1

Phone Number | Duration | Desired Result
12345 | 1 | 6
2345324 | 2 | 2
23145 | 3 | 2
1234 |  | SKIP
56432 | 4 | 2
5432 | 5 | etc
12345 | 7 | etc
12345 |  | etc
786543 |  | etc
54678 | 1 | etc
234567 | 2 | etc
23456 | 3 | etc
12345 |  | etc
2345324 | 4 | etc
23145 | 5 | etc
1234 | 7 | etc
56432 | 1 | etc
5432 | 2 | etc
12345 | 3 | etc
12345 |  | etc
786543 | 4 | etc
54678 | 5 | etc
234567 | 7 | etc
23456 |  | etc
Spreadsheet: 145192d1331366205-help-how-to-calculat-profit-for-hundreds-of-items-in-excel-feb2012a
Sheet: Sheet1

 | SALES REPORT
 | DATE |  | INVOICE #
 | 2012-02-01 00:00:00 |  | JL001
 | ID ITEM |  | ITEM NAME |  |  | QTY | UNIT | PRICE | SUBTOTAL |  | ITEM PROFIT
 | DPL025 |  | POLYESTER ALFAGLOS |  |  | 1 | [NAME] | 60 | 60 |  | 3
 | DATE |  | INVOICE #
 | 2012-02-01 00:00:00 |  | [NAME]
 | ID ITEM |  | ITEM NAME |  |  | QTY | UNIT | PRICE | SUBTOTAL |  | ITEM PROFIT
 | NP010 |  | NIPPE EXCLUSIVE GREY |  |  | 2 | KG | 45 | 45 |  | 2
 | DATE |  | INVOICE #
 | 2012-02-01 00:00:00 |  | [NAME]
 | ID ITEM |  | ITEM NAME |  |  | QTY | UNIT | PRICE | SUBTOTAL |  | ITEM PROFIT
 | TC01 |  | TOP COLOR BLACK TT |  |  | 3 | KG | 50 | 50 |  | 2
 | DATE |  | INVOICE #
 | 2012-02-01 00:00:00 |  | [NAME]
 | ID ITEM |  | ITEM NAME |  |  | QTY | UNIT | PRICE | SUBTOTAL |  | ITEM PROFIT
 | [NAME] |  | DEMPUL TAKASHIMURA |  |  | 3 | GLN | 55 | 55 |  | 2
 | DATE |  | INVOICE #
 | 2012-02-01 00:00:00 |  | [NAME]
 | ID ITEM |  | ITEM NAME |  |  | QTY | UNIT | PRICE | SUBTOTAL |  | ITEM PROFIT
 | TC03 |  | TOP COLOR WHITE TT |  |  | 2 | KG | 50 | 50 |  | 2
Spreadsheet: 347ed620-d5bc-4def-b81f-cdbc9cc810a5
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: New Residential Construction
 |  | Housing Units Completed: United States
 |  | Seasonally Adjusted Single-family Units [Thousands of Units]
 |  | Period: 2008 to 2012
 |  | Data Extracted on: September 19, 2014 (8:12 am)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2008
2009
2010
2011
2012
Spreadsheet: 27e1dbf7-f1c1-411a-b889-7c91ea7ccb53
Sheet: 15d

 | Swap Dealers/MSPs4 |  |  | Others
Product1 | HY3 | IG | Other | HY | IG | Other
Index Tranche | 65 | 600 | 2604 | 45 | 2129 | 1099
Index
Europe | . | . | 150608 | . | . | 88970
North America/Asia | 37383 | 152140 | 5461 | 21981 | 85564 | 1866
Other | . | . | 3444 | . | . | 1800
OTHER* | - | - | 30435 | . | . | 22215
TOTAL
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: judy_townsend__17756__TETCOIMB
Sheet: Oct'01

TETCO MAY IMBALANCES
Gas Day | Scheduled Imbalances-oc710 |  |  |  |  | Interconnect Cuts/Judy Imbalances |  |  |  |  | Allocated Imbalances (2 day lag) |  |  |  |  | Total-cb05 |  |  |  |  | Gas Day |  | Transport
 | STX | ETX | WLA | ELA | M1 | STX | ETX | WLA | ELA | M1 | STX | ETX | WLA | ELA | M1 | STX | ETX | WLA | ELA | M1 |  |  | STX | ETX | WLA | ELA
1 | 194 | 144 | -5441 |  |  |  |  |  | -1855 |  | 0 | -996 | 0 | 0 |  |  |  |  |  |  | 1
2 | 872 | 285 | 641 | -4677 |  |  |  |  | 1000 |  | 0 | -1113 | 0 | 0 |  |  |  |  |  |  | 2
3 | 113 | -15 | -525 | 86 |  | 392 |  | 1855 | 1310 | -1 | 0 | -1056 | 0 | 0 |  |  |  |  |  |  | 3
4 | -1025 | -15 | 652 | -138 |  |  | 1 | 3 | -5057 |  | 0 | -973 | 0 | 0 |  |  |  |  |  |  | 4
5 | -1363 | -15 | 283 | 281 |  |  |  | 1 | -298 |  | 0 | 5 | 0 | 0 |  |  |  |  |  |  | 5
6 | -367 | 800 | 715 | 142 |  | -99 |  |  | 129 |  | 333 | -26 | 0 | 0 |  |  |  |  |  |  | 6
7 | -367 | 800 | 715 | 142 |  | -99 |  |  | 129 |  | 1 | -314 | 0 | 0 |  |  |  |  |  |  | 7
8 | -367 | 800 | 715 | 142 |  | -99 |  |  | 129 |  | 1 | 179 | 0 | 0 |  |  |  |  |  |  | 8
9 | 382 | -3889 | -1085 | 328 |  |  |  |  | 81 |  | 0 | -291 | 0 | 0 |  |  |  |  |  |  | 9
10 | 87 |  | 687 | 119 |  |  | -978 |  | -7179 | -1 | 0 | -89 | 0 | 0 |  |  |  |  |  |  | 10
11 | -922 |  | -870 | -589 |  |  | 94 |  | -5664 |  | 0 | -304 | 0 | 0 |  |  |  |  |  |  | 11
12 | 78 | -31 | 78 | -318 |  |  |  | 120 | 1 |  | 0 | -181 | 0 | 0 |  |  |  |  |  |  | 12
13 | -668 | -39 | -113 | -1900 |  |  |  |  | -75 |  | 0 | -102 | -1 | 0 |  |  |  |  |  |  | 13
14 | -668 | -39 | -113 | -1900 |  |  |  |  | -75 |  | 0 | -233 | -1 | 0 |  |  |  |  |  |  | 14
15 | -668 | -39 | -113 | -1900 |  |  |  |  | -75 |  | 0 | 68 | -1 | 0 |  |  |  |  |  |  | 15
16 | -257 | -39 | -972 | -688 |  |  | -714 | -1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 16
17 | -1348 | -515 | 754 | -867 |  | 4 | 1 |  |  | -1 |  |  |  |  |  |  |  |  |  |  | 17
18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21
22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25
26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26
27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27
28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28
29 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29
30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31
FILE NAME:  O:\logistics\capacity\east\ne\TETCOIMB |  |  |  |  |  |  |  |  |  |  |  |  |  | Percentage |  | 0.25 | 0.25 | 1.18 | 0.11
Spreadsheet: 356863d1415224594-average-of-averages-with-if-average-average-gk
Sheet: Team AVG

Date | Team RPE Avg | Team HR Avg | HRR (199) | TIME (MIN) |  |  | AVG RPE's | Correlating HR's | HRR (199) |  | RPE AVG | HR's AVG | HRR
 |  |  | 0.75 |  |  |  | > 6.6 | 136.5 | 0.69 |  | 4 |  | 0.68
 |  |  | 0.68 |  |  |  | < 6.6 | 148 | 0.73 |  | 5 |  | 0.72
 |  |  | 0.77 |  |  |  |  |  |  |  | 6 (6) |  | 0.69
 |  |  | 0.58 |  |  |  |  |  |  |  | 7 (3) |  | 0.75
 |  |  | 0.74 |  |  |  |  |  |  |  | 8 ( 3) |  | 0.73
 |  |  | 0.74
 |  |  | 0.7 |  |  |  | Time in PRCT (Min.); 10/21 Two-A-Day
 |  |  | 0.68 |  |  |  | 70 - 95 | 96 - 130 | > 131
 |  |  | 0.67 |  |  |  | 2014-10-07 00:00:00 | 2014-10-06 00:00:00 | 2014-10-03 00:00:00
 |  |  | 0.77 |  |  |  | 2014-10-10 00:00:00 | 2014-10-08 00:00:00 | 2014-10-04 00:00:00
 |  |  | 0.71 |  |  |  | 2014-10-23 00:00:00 | 2014-10-14 00:00:00 | 2014-10-11 00:00:00
 |  |  | 0.63 |  |  |  | 2014-10-27 00:00:00 | 2014-10-21 00:00:00 | 2014-10-13 00:00:00
 |  |  | 0.68 |  |  |  | 2014-10-28 00:00:00 | 2014-10-24 00:00:00 | 2014-10-22 00:00:00
 |  |  | 0.72
 |  |  | 0.72
 |  |  | AVERAGEIF
Spreadsheet: 705200d1605916860-help-with-sumproduct-formula-to-disregard-a-column-if-not-applicable-sample-file-2-bvj-
Sheet: Calculator

Location 1 |  |  |  |  |  |  |  |  |  | Housekeeper |  | Arizona | 15 |  |  |  | Location 1 | Arizona
Arizona |  |  |  |  |  |  |  |  |  | Landscaper |  | Arizona | 32 |  |  |  | Location 2 | Arizona
 |  |  |  |  |  |  |  |  |  | Manager |  | Arizona | 50 |  |  |  | Location 3 | Colorado
 |  |  |  |  |  |  |  |  |  | Housekeeper | Location 1 | Arizona | 15.5 |  |  |  | Location 4 | Colorado
 |  |  |  |  |  |  |  |  |  | Landscaper | Location 1 | Arizona | 28 |  |  |  | Location 5 | Colorado
Job | Start Date | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 |  |  |  |  |  | Manager | Location 1 | Arizona | 52 |  |  |  | Location 6 | Virginia
Housekeeper | 2021-01-01 00:00:00 | 15.5 | 15.5 | 15.5 |  |  |  |  |  | Housekeeper |  | Colorado | 17 |  |  |  | Location 7 | Virginia
Landscaper | 2021-01-01 00:00:00 | 28 | 28 | 28 |  |  |  |  |  | Landscaper |  | Colorado | 29 |  |  |  | Location 8 | Virginia
Manager | 2021-03-01 00:00:00 | 52 | 52 | 52 |  |  |  |  |  | Manager |  | Colorado | 60 |  |  |  | Location 9 | Virginia
 |  |  |  |  |  |  |  |  |  | Housekeeper |  | Virginia | 14
 |  |  |  |  |  |  |  |  |  | Landscaper |  | Virginia | 30
 |  |  |  |  |  |  |  |  |  | Manager |  | Virginia | 55
 |  |  |  |  |  |  |  |  |  | Manager | Location 7 | Virginia | 59
Spreadsheet: 150783d1334678992-combining-table-tab-information-startup-prl
Sheet: Controls

Project Name:
Project Team: |  |  | G.C. Super:
Project Manager:
Mechancial Engineer:
Controls Engineer:
Field Technician (TAB):
 |  |  |  |  | Problem-Resolution Log (PRL) - Controls
Issue No. | Date Entered | Entered By: | Equipment or System | Description of Issue | Action By | Progress | Date Corrected | Corrected By: | Date Approved | Resolved by | [NAME] | Approved By:
1 | 2012-04-10 00:00:00 | EM | [NAME] | Damper actuator is not springing closed.  Sanil w/ CE will address issue during his startup on 4/11.  We will re-verify during balancing.
 | 2012-04-10 00:00:00 | EM | 24th FL. RF's | Damper actuator's are not mounted properly.  Sanil w/ CE will correct during his startup by 4/13.  We will re-verify during balancing.
 | 2012-04-10 00:00:00 | EM | FTU-2406 | Discharge air sensor is not installed.
 | 2012-04-10 00:00:00 | EM | FTU-2402, 2403, 2404, 2405, 2406, 2415, 2425 | Temp sensors not installed.  CE will be installing them and we will re-verify during Balancing.
 | 2012-04-10 00:00:00 | EM | Variable speed, Co2 and Occ controlled boxes | Occ sensors will arrive in May.  Temps sensors have been approved and are on order.
 | 2012-04-10 00:00:00 | EM | 24th FCU's | Mixed air sensors not installed properly. | PSF | Fixed by [NAME] | 2012-04-09 00:00:00 | PS
 | 2012-04-11 00:00:00 | EM | 23rd & 24th IDF Rooms | Temps sensors not yet installed.  Sensors are on order and will be installed by CE | CE | Will reverify when installed.
 | 2012-04-11 00:00:00 | EM | RF-241 | Damper actuator is installed incorrectly.  CE will fix during their startup. | CE | We will re-verify during balancing.
 | 2012-04-11 00:00:00 | EM | [NAME] | Mixing air damper actuator is not springing closed. | CE | CE will fix during their startup and we will re-verify during balancing.
 | 2012-04-11 00:00:00 | EM | FCU-2304 | Mixing air damper actuator is not springing closed. | CE | CE will fix during their startup and we will re-verify during balancing.
Spreadsheet: 873460d1719952109-table-column-header-is-year-i-want-to-use-that-to-pull-data-from-that-table-to-another-book1
Sheet: Sheet2

PropID | 2025 | 2026 | 2027 |  | PropID | Year | Value
1 | 100 | 200 | 300 |  | 1 | 2025
2 | 150 | 250 | 350 |  | 2 | 2026
3 | 400 | 450 | 500 |  | 3 | 2027
Spreadsheet: 757515d1638302125-looking-for-a-formula-that-will-display-the-name-of-the-employee-available-shift-schedule-project
Sheet: Sheet1

Employee Shift Schedule
Insert Company Name Here
 |  |  |  |  |  |  |  |  |  |  |  | Date | 09:00:00
Week Beginning: | 2021-12-18 00:00:00 |  |  |  |  |  |  |  |  |  |  | Time | 2021-12-18 00:00:00
 | 09:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hours
Employee
Name 1
Name 2
Name 3
Name 4
Name 5
Name 6
Name 7
Name 8
Name 9
Name 10
Name 11 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No | No | No | No | No | No | No | No | No | No | No | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
Name 12
Name 13
Name 14
Name 15
Name 16
Name 17 | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No
Name 18
Name 19
Name 20
Name 21
Name 22
 | 09:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hours
Employee
Name 1
Name 2
Name 3
Name 4
Name 5
Name 6
Name 7
Name 8
Name 9
Name 10
Name 11
Name 12
Name 13
Name 14
Name 15
Name 16
Name 17
Name 18
Name 19
Name 20
Name 21
Name 22
 | 09:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hours
Employee
 | 09:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hours
Employee
 | 09:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hours
Employee
 | 09:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hours
Employee
 | 09:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hours
Employee
Spreadsheet: 267936d1380297542-index-match-error-hc-upload
Sheet: Avg Anaplan

 |  | FY14 Budget
 |  |  | Proc Management | Proc men | Proc support | Processing Distribution employees | HC PROCESSING TOTAL | Service Management | Servicemen | Quality Control / Technical | HC SERVICE TOTAL | Sales Management | Salesmen | Telesales | National Account Sales | HC SALESMEN TOTAL | Marketing Mgt | General Management | [NAME] | Prog Office | FD & Management | General Accounting | ITGeneral | HR Management | HC OTHER TOTAL | HC TOTAL
 | 180 |  | #N/A |  |  |  | #N/A |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 0 | #N/A
 | 181 |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 0 | 0
 | 182 |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 0 | 0
 | 183 |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 0 | 0
 | 184 |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 0 | 0
 | 185 |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 0 | 0
 | 186 |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 0 | 0
 | 640 |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 0 | 0
 | 664 |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 0 | 0
Spreadsheet: 203425d1357118667-how-to-avoid-duplicate-entry-in-excel-from-list-entries-commercial-list
Sheet: Live

TAP Code | Country | Region | Operator | IMSI | IRA Date | Direction | GSM |  |  |  | GPRS |  |  |  | CAMEL |  |  |  | 3G
 |  |  |  |  |  |  | Inbound |  | Outbound |  | Inbound |  | Outbound |  | Inbound |  | Outbound |  | Inbound | Outbound
AFGEA |  |  |  |  |  | Dir | Live | 2008-12-16 00:00:00 | Live | 2008-12-16 00:00:00 | Live | 2011-09-29 00:00:00 | Live | 2011-09-29 00:00:00 | Live | 2012-01-30 00:00:00 | Live | 2012-01-30 00:00:00
AFGAW |  |  |  |  |  | Dir | Live | 2010-07-06 00:00:00 | Live | 2010-07-06 00:00:00 | Live | 2010-10-12 00:00:00 | Live | 2010-10-12 00:00:00 |  |  | Live | 2012-02-16 00:00:00
AFGTD |  |  |  |  |  | Dir | Live | 2010-09-02 00:00:00 | Live | 2010-09-02 00:00:00 | Live | 2012-08-02 00:00:00 | Live | 2012-08-02 00:00:00
AFGAR |  |  |  |  |  | Dir | Live | 2010-05-27 00:00:00 | Live | 2010-02-10 00:00:00 | Live | 2012-03-12 00:00:00 | Live | 2012-03-12 00:00:00 |  |  | Live | 2010-02-14 00:00:00 | 2012-10-15 00:00:00 | 2012-10-15 00:00:00
Spreadsheet: 145522d1331634186-about-column-chart-818613c
Sheet: 3

data | [NAME] | frquency | %
0.4747765192177438 | 0.1
0.2368296949413358 | 0.2 | 3
0.8029807100895727 | 0.3 | 1
0.4586084257227299 | 0.4 | 0
0.5260953931122121 | 0.5 | 7
0.122167220516036 | 0.6 | 2
0.4701451170543325 | 0.7 | 1
0.940842112000909 | 0.8 | 2
0.4702137045887462 | 0.9 | 3
0.4752698020103026 | 1 | 1
0.1661522285227299
0.728783673306717
0.4087543367812358
0.8115954071871174
0.8594223761163091
0.6519699014015607
0.4002621682814311
0.7215366767367675 |  |  |  | R
0.5939157954989271
0.1741168973511673
Spreadsheet: 216995d1361958794-calculating-ytd-of-monthly-averages-ytdcalculations
Sheet: Sheet1

 | 2012-01-01 00:00:00 |  | 2012-02-01 00:00:00 |  | 2012-03-01 00:00:00 |  | 2012-04-01 00:00:00 |  | 2012-05-01 00:00:00 |  | 2012-06-01 00:00:00 |  | 2012-07-01 00:00:00 |  | 2012-08-01 00:00:00 |  | 2012-09-01 00:00:00 |  | 2012-10-01 00:00:00 |  | 2012-11-01 00:00:00 |  | 2012-12-01 00:00:00 |  |  | 2012-01-01 00:00:00 |  | 2012-02-01 00:00:00 |  | 2012-03-01 00:00:00 |  | 2012-04-01 00:00:00 |  | 2012-05-01 00:00:00 |  | 2012-06-01 00:00:00 |  | 2012-07-01 00:00:00 |  | 2012-08-01 00:00:00 |  | 2012-09-01 00:00:00 |  | 2012-10-01 00:00:00 |  | 2012-11-01 00:00:00 |  | 2012-12-01 00:00:00
 | Monthly |  | Monthly |  | Monthly |  | Monthly |  | Monthly |  | Monthly |  | Monthly |  | Monthly |  | Monthly |  | Monthly |  | Monthly |  | Monthly |  |  | Teams |  | Teams |  | Teams |  | Teams |  | Teams |  | Teams |  | Teams |  | Teams |  | Teams |  | Teams |  | Teams |  | Teams
xxx | 30000 |  | 20000 |  | 21000 |  | 20000 |  | 25000 |  | 26000 |  | 36000 |  | 40000 |  | 27000 |  | 25800 |  | 28000 |  | 34000 |  |  | 25 |  | 30 |  | 25 |  | 25 |  | 25 |  | 26 |  | 24 |  | 28 |  | 29 |  | 21 |  | 23 |  | 20
 | SELECT DATE |  | YTD | YTD per Team
 | 2012-05-01 00:00:00
 |  |  |  |  | If the month chosen is April then we should have a formula that calculates as follows:   = (30000/25)+(20000/30)+(21000/25)+(20000/25)  Note : that this is a simple example and that my dates go back a few years and not just in 2012 Note2 :
 | 2012-01-01 00:00:00
 | 2012-02-01 00:00:00
 | 2012-03-01 00:00:00
 | 2012-04-01 00:00:00
 | 2012-05-01 00:00:00
 | 2012-06-01 00:00:00
 | 2012-07-01 00:00:00
 | 2012-08-01 00:00:00
 | 2012-09-01 00:00:00
 | 2012-10-01 00:00:00
 | 2012-11-01 00:00:00
 | 2012-12-01 00:00:00
Spreadsheet: 540378d1506670820-sum-two-cells-from-two-different-tables-excel-help-example
Sheet: Total

 |  |  |  |  |  |  |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | TOT | AVG
 |  |  |  |  |  |  | Total days
 |  |  |  |  |  |  | Work hours
 |  |  |  |  |  |  | Vacation
 |  |  |  |  |  |  | Sickness
 |  |  |  |  |  |  | Bank holyday
Not-uniqe | Not-uniqe2 | Cost Center | AVG % p/m | Time spent | AVG Time p/m | Comment
FDASD |  | 1
FDASD |  | 2
 |  | 3
ASD |  | 4
ASD |  | 5 |  |  |  |  |  |  | FIND SOLUTION TO AUTOSUM FROM THE OTHER TABLES, ATM NOT POSSIBLE…
 |  | 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
 |  | 32
 |  | 33
 |  | 34
 |  | 35
 |  | 36
 |  | 37
 |  | 38
 |  | 39
Total
Spreadsheet: 746842d1631067620-rank-by-column-q-data-first-then-by-column-l-data-then-by-column-k-data-to-break-ties-book-2
Sheet: Printable Report

1ST [NAME]
Portfolio
Rank | [NAME] | Score | Ribbon | Points
1
2
3
4
5
6
7
8
9
10
2ND ATTEMPT
Portfolio
Rank | [NAME] | Score | Ribbon | Points
1
2
3
4
5
6
7
8
9
10
3RD ATTEMPT
Portfolio
Rank | [NAME] | Score | Ribbon | Points
1
2 |  |  |  |  |  | Should be Indee Scott
3 |  |  |  |  |  | Should be [NAME]
4
5
6
7
8
9 |  |  |  |  |  | Should be [NAME]
10
4th ATTEMPT
Portfolio
Rank | [NAME] | Score | Ribbon | Points
1
2
3
4
5
6
7
8
9
10