tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 863763d1711141302-count-instances-or-frequency-multiple-sheets-counting-position-appearances-in-baseball-excel-help-forum-roster-template-dj
Sheet: Game 1

Date: |  | 2024-05-01 00:00:00 |  |  | Field: |  |  | Start Time: |  | 18:00:00 |  |  |  |  | #[NAME]!
Home: |  |  |  |  | 3rd | Set Up
Visitors: |  |  |  |  | 1st | Clean Up
 |  |  |  |  | Inning
 |  | Player |  |  | Coach Pitch |  |  |  |  |  | Innings on Bench | Innings in Infield | Inninings in Outfield |  |  |  | [NAME]
Order |  | First | Last | # | 1 | 2 | 3 | 4 | 5 | 6
1 | 12 | [NAME] |  |  | 1B (3) | 1B (3) | 1B (3) | LF (7) | LF (7) | LF (7) |  |  |  |  | P (1) |  |  | [NAME] | 44
2 | 11 | Ty |  |  | 2B (4) | 2B (4) | 2B (4) | RF (9) | RF (9) | RF (9) |  |  |  | 6 | C (2) |  | Ty | Cobb | 2
3 | 1 | [NAME] |  |  | 3B (5) | 3B (5) | 3B (5) | LCF () | LCF () | LCF () |  |  |  | 6 | 1B (3) |  | [NAME] | Gehrig | 4
4 | 2 | [NAME] |  |  | LF (7) | LF (7) | LF (7) | 1B (3) | 1B (3) | 1B (3) |  |  |  | 6 | 2B (4) |  | [NAME] | Henerson | 22
5 | 4 | [NAME] |  |  | P (1) | P (1) | P (1) | [NAME] () | [NAME] () | [NAME] () |  |  |  | 6 | 3B (5) |  | [NAME] | Mantle | 7
6 | 5 | Willie |  |  | X | RF (9) | RF (9) | 3B (5) | 3B (5) | 3B (5) |  |  |  | 6 | SS (6) |  | Willie | Mays | 24
7 | 10 | [NAME] |  |  | RF (9) | X | SS (6) | SS (6) | C (2) | C (2) |  |  |  | 6 | LF (7) |  | [NAME] | Musial | 6
8 | 9 | [NAME] |  |  | SS (6) | SS (6) | X | 2B (4) | 2B (4) | 2B (4) |  |  |  | 6 | CF (8) |  | [NAME] | [NAME] | 20
9 | 6 | Babe |  |  | LCF () | LCF () | LCF () | X | SS (6) | SS (6) |  |  |  | 6 | RF (9) |  | Babe | [NAME] | 3
10 | 7 | [NAME] |  |  | C (2) | C (2) | [NAME] () | P (1) | X | P (1) |  |  |  | 6 | SF (10) |  | [NAME] | [NAME] | 20
11 | 8 | [NAME] |  |  | [NAME] () | [NAME] () | C (2) | C (2) | P (1) | X |  |  |  | 6 | EH () |  | [NAME] | [NAME] | 9
12 | 8 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | LCF ()
13 | 8 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | [NAME] ()
Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Roster pulled from list on roster tab
 | 9
 | 9
Notes:
 |  |  |  | Players on [NAME]
 |  | Only pull a players first name from the drop down
Spreadsheet: 800542d1665733406-offset-function-in-dropdown-list-not-working-after-closing-and-opening-the-file-test-data
Sheet: user sheet

 |  |  |  |  | Offset function used in data validation not working after closing and reopening the file |  | same Offset function used below in col 'H' works fine
 | # | Set | Area | Question | Options
 | 1 | Group 1 | A | Question 1 | Very Much
 | 2 | Group 1 | A | Question 2 | No
 | 3 | Group 1 | A | Question 3 | Vegetables
 | 4 | Group 1 | B | Question 1 | Green
 | 5 | Group 1 | B | Question 2
 | 6 | Group 1 | B | Question 3
 | 7 | Group 1 | C | Question 1 | 5
 | 8 | Group 1 | C | Question 2
 | 9 | Group 1 | C | Question 3 | 6 months to 1 year
 | 10 | Group 2 | A | Question 1 | Good
 | 11 | Group 2 | A | Question 2
 | 12 | Group 2 | A | Question 3
 | 13 | Group 2 | B | Question 1
 | 14 | Group 2 | B | Question 2 | Average
 | 15 | Group 2 | B | Question 3 | 5 years or more
 | 16 | Group 2 | C | Question 1 | Yes
 | 17 | Group 2 | C | Question 2
 | 18 | Group 2 | C | Question 3 | 1-3 years
Spreadsheet: 689708d1596609820-if-function-exceeding-8000-character-limit-need-help-on-shorter-formula-au-and-nz-vendor-margin-analysis-fy20-ytd-test
Sheet: February NZ

Margin and Sales by Vendor - February 2020
Vendor | Sales | Margin $ | Margin %
F5 | 1 | 1
Tenable | 1 | 1
NetApp | 1 | 1
MobileIron | 1 | 1
Palo Alto Networks | 1 | 1
Ribbon | 1 | 1
Infoblox | 1 | 1
FireEye | 1 | 1
Riverbed | 1 | 1
Extreme Networks | 1 | 1
Arista | 1 | 1
Cylance | 1 | 1
Nutanix | 1 | 1
Channel Services | 1 | 1
CS Vendors | 1 | 1
Avaya | 1 | 1
Grand Total
Spreadsheet: 113535d1309414800-calculate-shifts-remaining-variation_calc
Sheet: Raw Parts

Average Parts Per Shift |  |  |  |  |  |  |  |  |  | Average Parts Per Shift
 | (Monday) |  |  |  |  |  |  |  |  |  | (Monday)
Shift | Line |  |  |  |  |  |  |  |  | Shift | Line
1 | IEC109-1 | IEC109-2 | IEC109-3 | IEC109-4 |  |  |  |  |  | 1 | IEC110-1 | IEC110-2 | IEC110-3 | IEC110-4
Shift | Line |  |  |  |  |  |  |  |  | Shift | Line
2 | IEC109-1 | IEC109-2 | IEC109-3 | IEC109-4 |  |  |  |  |  | 2 | IEC110-1 | IEC110-2 | IEC110-3 | IEC110-4
Shift | Line |  |  |  |  |  |  |  |  | Shift | Line
3 | IEC109-1 | IEC109-2 | IEC109-3 | IEC109-4 |  |  |  |  |  | 3 | IEC110-1 | IEC110-2 | IEC110-3 | IEC110-4
 | Shifts: |  | #REF!
 | Time:
 | Current Time: |  |  |  | 109-1 | 109-2 | 109-3 | 109-4 |  |  |  |  |  |  | 110-1 | 110-2 | 110-3 | 110-4
 | End Time |  | 06:00:00
 | Difference:
 | Coefficient
Spreadsheet: c531f083-37f6-439d-ba13-a99646d2dff8
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
STER | Test | STER | Sterols, Plasma | Sterols, P | Gas Chromatography-Mass Spectrometry (GC-MS)/Gas Chromatography-Flame Ionization Detection (GC-FID) | Green-Top Tube (Sodium Heparin): GrnNaHp |  |  | 0.4 | mL | Collection Container/Tube:  Preferred: Green top (sodium heparin) Acceptable: EDTA Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions:  1. Fasting (12 hours or more, infants just before next feeding).  2. Spin down within 45 minutes of draw.  Additional Information: Patient's age and sex are required. Forms: 1. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 2. If not ordering electronically, submit a Biochemical Genetics Request Form (Supply T439) with the specimen. | 0.2 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK - refreeze - note to lab Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | DESMOSTEROL 0.0-5.0 mg/L  LATHOSTEROL 0.0-7.0 mg/L  CAMPESTEROL 0.0-7.0 mg/L  SITOSTEROL 0.0-5.0 mg/L | Varies; 2 p.m. | 2 days | 9 days | 1 | 82542 |  |  |  |  | Rochester
STER | [NAME] | PLASMA | Plasma |  |  |  | Frozen | 30 days
STER | Result | 29936 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2
STER | Result | 29937 | [NAME] | [NAME] | Alphanumeric
STER | Result | 29938 | Source | Source | Alphanumeric
STER | Result | 29939 | Order Date | Order Date | Alphanumeric
STER | Result | 29940 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1
STER | Result | 29941 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
STER | Result | 50499 | Desmosterol | Desmosterol | Numeric |  |  |  |  | mg/L |  |  |  |  |  |  |  |  |  | In Process
STER | Result | 50500 | Lathosterol | Lathosterol | Numeric |  |  |  |  | mg/L |  |  |  |  |  |  |  |  |  | In Process
STER | Result | 50501 | Campesterol | Campesterol | Numeric |  |  |  |  | mg/L |  |  |  |  |  |  |  |  |  | In Process
STER | Result | 50502 | Sitosterol | Sitosterol | Numeric |  |  |  |  | mg/L |  |  |  |  |  |  |  |  |  | In Process
STER | Result | 29942 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59462-2
STER | Result | 29943 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
STER | Result | 29944 | Reviewed By | Reviewed By | Numeric
STER | Result | 29945 | Release Date | Release Date | Alphanumeric
Spreadsheet: ec31c538-2cad-42b0-8d7d-32403dfde722
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7740 | 44693 | [NAME] | Yerofeyeva | KAZ | 21 | [NAME] | 00:00:24 | 00:55:48 | 00:00:33 | 00:37:16 | 1 | 01:53:53
7740 | 5555 | Yekaterina | Shatnaya | KAZ | 22 | 00:22:26 | 00:00:22 | 00:56:50 | 00:00:34 | 00:37:45 | 2 | 01:57:57
7740 | 41842 | Karolina | Solovyova | KAZ | 23 | 00:22:25 | 00:00:23 | [NAME] | 00:00:30 | [NAME] | 3 | 02:00:01
7740 | 39400 | [NAME] | Radziyevskaya | KAZ | 25 | 00:23:43 | [NAME] | 01:02:51 | 00:00:36 | 00:43:39 | 4 | 02:11:19
7740 | 46527 | Zukhra | Vakhitova | UZB | 24 | 00:25:43 | 00:00:38 | 01:00:39 | 00:00:41 | 00:51:49 | 5 | 02:19:32
Spreadsheet: 769413d1645529706-if-and-function-gives-value-error-counting-not-summing-aligw
Sheet: Sheet1

Region | Client type | Ranking
EMEA | B | 4
APAC | A | 7
APAC | A | 7
APAC | A | 10
EMEA | A | 7
EMEA | C | -1
EMEA | A | 9
EMEA | A | 9
EMEA | A | 10
EMEA | B | 8
EMEA | B | 9
EMEA | A | 8
EMEA | B | -1
AMERICAS | A | 10
APAC | D | 10
EMEA | A | 8 |  |  |  |  |  |  |  |  |  |  |  | ENTER PARAMETERS HERE:
EMEA | E | -1
APAC | A | -1 |  |  |  |  |  |  |  |  |  |  |  | Region: | EMEA
APAC | F | 8 |  |  |  |  |  |  |  |  |  |  |  | Client Type: | A
APAC | A | 8 |  |  |  |  |  |  |  |  |  |  |  | Ranking from: | 7 | to: | 8
Total
 |  |  |  |  |  |  |  |  |  |  | "A" | RESULT:
 |  |  |  |  |  |  |  |  |  | >8
 |  |  |  |  |  |  |  |  |  | 7, 8
Spreadsheet: tracy_geaccone__40449__UpsidesDownsides
Sheet: UpDown

 | ETS Operations
 | Upsides/(Downsides)
 | ($ millions)
 | Business Unit | Description | Person Responsible | Probability H/M/L | Q1 | Q2 | Q3 | Q4 | Total 2001 | Future Years
 | NNG | DOT User Fees (paid 12/2000) | [NAME]/Dave | H | 0.3 | 0.3 | 0.3 | 0.4
 | TW | DOT User Fees (paid 12/2000) | [NAME] | H | 0.1 | 0 | 0.1 | 0
 | NBPL | DOT User Fees (paid 12/2000) | [NAME] | H | 0 | 0.1 | 0 | 0
 | TW | Accelerated Overhaul Costs into 2000 | [NAME] | H | 0 | 0.3 | 0 | 0
 | FGT | 2001 Overhaul Amortization Exp (12/2000) | [NAME] | H | 0.1 | 0.1 | 0.1 | 0.1
 | ETS | Additional Stretch Target | [NAME] | H | 0 | 0 | 0 | 0.8
 |  | Sub-Total - Items that will be added to 1st CE
 | NNG | Deferral of Gain on Cooper Inventory Sale | All | H | ? | ? | ? | ? | 2 | 2.5
 | TW | Overhaul Deferral due to Red Rock Expansion | [NAME] | H | 0 | 0.3 | 0.71 | 0
 | TW | Recoup of expenses re: Burlington Train Derailment | [NAME] | H | ? | ? | ? | ? | ?
 | ETS | Excess Emission Credits | [NAME] | M | 0 | 0 | ? | ? | 5
 | ETS | Rebates: | [NAME]
 |  | Cooper |  | H | 0 | 0.165 | ? | ?
 |  | Chrysler | [NAME] | H | 0.2 | ? | ? | ?
 |  | Valves |  | H | 0.021 | ? | ? | ?
 | ETS | EOTT Relocation Costs (~20 X $40k per person) | All | H | -0.1 | -0.5 | -0.2 | 0
 | ETS | Stranded Costs if EOTT is sold | All | ? | 0 | 0 | -0.1 | -0.2
 | HPL | Items Related to HPL Sale:
 |  | Stranded Costs | [NAME] | H | -0.2 | -0.2 | -0.2 | -0.2 |  | -0.8
 |  | Incremental [NAME] | [NAME] | H | 0.2 | 0.1 | 0 | 0
 |  | Incentive Pay | [NAME] | H | 0.2 | 0 | 0 | 0
 |  | HPL Allocation | [NAME] | H | 0.2 | 0.1 | 0 | 0
 |  | Total Operations
Spreadsheet: 49337d1248698700-using-if-for-entire-column-buttontemp
Sheet: Sheet1

 | FORKLIFT [NAME]
2009-07-23 00:00:00
2009-07-24 00:00:00
2009-07-25 00:00:00
2009-07-26 00:00:00
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
2009-08-10 00:00:00
Spreadsheet: 792634d1661020612-i-want-to-use-sumproduct-with-subtotal-for-long-range-of-cells-sample-file
Sheet: Sheet1

 |  |  | FORMULA TO USE SUMPRODUCT WITH SUBTOTAL
 |  |  | ABC |  |  | 100 |  | to sum the active cell with date only
 |  |  | RUI |  |  | 30
 |  |  | DESCRIP | AMOUNT |  | DATE
 |  |  | ABC | 50 |  | 2022-08-20 00:00:00
 |  |  | DAF | 60
 |  |  | RUI | 30 |  | 2022-08-21 00:00:00
 |  |  | ARO | 24
 |  |  | FDS | 87
 |  |  | RUI | 15
 |  |  | ABC | 50 |  | 2022-07-15 00:00:00
 |  |  | ABC | 10
Spreadsheet: 809595d1671177448-convert-values-in-multiple-rows-to-single-column-book1
Sheet: Sheet1

Q | W | E
1 | 2 | 3
4 | 5 | 6
7 | 8 | 9
Spreadsheet: 692819d1598589546-creating-a-list-with-2-criteria-and-allowing-duplicate-return-values-sample
Sheet: -DATA-

Mfg Itm ID | ID | USED | Expiration |  | Active List | Expiring | Expiring2 | Expiring3 | Expiring4 | Expiring5 | Expiring6 | Expiring7 | Expiring8 | Expiring9 | Expiring10 | Expiring11 | Expiring12 | Expiring13 | Expiring14 | Expiring15
5950020 | 2674 | True | 2020-12-01 00:00:00 |  | 0115311
0115311 | 2452 | True | 2020-12-01 00:00:00
TEM1208GL | 1399 | False | 2021-01-07 04:51:01
TEM1208GR | 2048 | True | 2021-02-01 00:00:00
5950009 | 5015 | False | 2021-02-01 00:00:00
0115310 | 6569 | True | 2021-04-01 00:00:00
0115320 | 8659 | True | 2021-04-01 00:00:00
5950040 | 1273 | True | 2021-04-01 00:00:00
TEM1208GL | 4589 | False | 2021-06-01 00:00:00
5950007 | 8309 | True | 2021-06-01 00:00:00
TEM1208GR | 2073 | True | 2021-06-01 00:00:00
5950009 | 6613 | True | 2021-06-01 00:00:00
5950008 | 6053 | True | 2021-08-01 00:00:00
0115310 | 142 | True | 2021-09-01 00:00:00
5950008 | 5611 | True | 2021-09-01 00:00:00
5950020 | 4966 | False | 2021-09-01 00:00:00
0117311 | 450 | True | 2021-10-01 00:00:00
5950040 | 5790 | True | 2021-10-01 00:00:00
UML1 | 4875 | True | 2021-11-01 00:00:00
5950009 | 1936 | False | 2021-11-01 00:00:00
TEM1208GR | 1371 | True | 2021-12-01 00:00:00
TEM1208GL | 4311 | False | 2022-02-01 00:00:00
UML1 | 3112 | True | 2022-03-01 00:00:00
0115320 | 2438 | True | 2022-04-01 00:00:00
UML1 | 8316 | True | 2022-04-01 00:00:00
5950007 | 4966 | False | 2022-05-01 00:00:00
0117311 | 593 | True | 2022-07-01 00:00:00
0112720 | 6212 | True | 2023-02-01 00:00:00
0117311 | 1598 | False | 2023-02-01 00:00:00
0115311 | 7638 | False | 2023-03-01 00:00:00
0117321 | 4416 | False | 2023-03-01 00:00:00
0115311 | 1563 | False | 2023-03-01 00:00:00
0117311 | 3323 | False | 2023-06-01 00:00:00
0117311 | 2329 | False | 2023-07-01 00:00:00
0115321 | 2618 | False | 2023-08-01 00:00:00
0117321 | 1211 | False | 2023-11-01 00:00:00
0115311 | 6533 | False | 2024-03-01 00:00:00
0112760 | 7903 | True | 2024-04-01 00:00:00
0112770 | 7175 | False | 2024-06-01 00:00:00
0112720 | 7749 | True | 2024-06-01 00:00:00
0112680 | 6966 | True | 2024-10-01 00:00:00
0112760 | 5661 | False | 2024-10-01 00:00:00
0112680 | 5937 | True | 2024-12-01 00:00:00
0112640 | 1038 | True | 2025-01-01 00:00:00
0112720 | 13 | True | 2025-01-01 00:00:00
0112770 | 3762 | True | 2025-02-01 00:00:00
0115321 | 2648 | True | 2025-04-01 00:00:00
0112770 | 1543 | True | 2028-06-01 00:00:00
0115311 | 2345 | False | 2028-07-01 00:00:00
Spreadsheet: 2740f1c5-df17-4d6a-bff8-2db2d8393329
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
40339778 | 2014-03-03 21:24:08 | AXIS | 0 | 4 | 6 | 901544 | manu76 | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
40340239 | 2014-03-03 21:44:15 | ALLIES | 0 | 1 | 6 | 901544 | manu76 | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
40356358 | 2014-03-04 21:28:11 | AXIS | 0 | 4 | 6 | 757054 | Bulldoz44 | 9596 | western | 1944-06-06 | 1944-06-06 | Gold Beach | Gold Beach
40356758 | 2014-03-04 21:48:52 | ALLIES | 1 | 6 | 5 | 757054 | Bulldoz44 | 9596 | western | 1944-06-06 | 1944-06-06 | Gold Beach | Gold Beach
40372238 | 2014-03-05 21:21:58 | ALLIES | 1 | 5 | 3 | 1239735 | Vaillants | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
40372509 | 2014-03-05 21:46:22 | AXIS | 0 | 4 | 5 | 1239735 | Vaillants | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
40387602 | 2014-03-06 21:22:08 | AXIS | 0 | 4 | 6 | 1210418 | [NAME] | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
40387891 | 2014-03-06 21:47:37 | ALLIES | 0 | 4 | 6 | 1210418 | [NAME] | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
40431928 | 2014-03-09 16:07:14 | AXIS | 1 | 7 | 3 | 954304 | Aurelie in wonderland | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40432283 | 2014-03-09 16:22:24 | ALLIES | 0 | 2 | 7 | 954304 | Aurelie in wonderland | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40464925 | 2014-03-11 17:56:53 | ALLIES | 1 | 10 | 5 | 867821 | b.kuntscher | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40465235 | 2014-03-11 18:25:27 | AXIS | 1 | 10 | 7 | 867821 | b.kuntscher | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 771484d1646695586-want-to-get-the-results-of-mavb-for-invoices-and-counts-and-sorted-smallest-to-largest-export-detail-ms-test-kisiji-
Sheet: ODF (P)

S/N | INV# | DATE | PO | PARTY | FIN NAME | FIN# | FIN# | BAL | TO | ADRESS | COUNTRY | MOBILE# | DIS | DETAIL | QTY | VAL | T-VAL | VIA | TERM | TRACKING | TRA | TRA | WEBOC | TRA | INVOICE
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
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
Spreadsheet: 472527d1469628288-getpivotdata-formula-with-two-variables-month-and-country-example-file2
Sheet: PivotTable

CurrentDate
Country | MonthName | Sum of Traffic
Australia | January | 20
 | February | 20
 | March | 20
 | April | 20
 | May | 20
 | June | 20
 | July | 100
Australia Total |  | 220
France | January | 10
 | February | 10
 | March | 10
 | April | 10
 | May | 10
 | June | 10
 | July | 300
France Total |  | 360
US | January | 50
 | March | 50
 | April | 50
 | May | 50
 | June | 50
 | July | 200
 | Feburary | 50
US Total |  | 500
Grand Total |  | 1080
Spreadsheet: 862476d1710195032-exclude-holidays-in-total-holiday-sample
Sheet: Feb

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday Count | Weekdays Count | Weekend Count | Entitlement | Total Taken | Balance
 |  |  |  | 2017-02-02 00:00:00 | 2017-02-03 00:00:00 | 2017-02-04 00:00:00 | 2017-02-05 00:00:00 | 2017-02-06 00:00:00 | 2017-02-07 00:00:00 | 2017-02-08 00:00:00 | 2017-02-09 00:00:00 | 2017-02-10 00:00:00 | 2017-02-11 00:00:00 | 2017-02-12 00:00:00 | 2017-02-13 00:00:00 | 2017-02-14 00:00:00 | 2017-02-15 00:00:00 | 2017-02-16 00:00:00 | 2017-02-17 00:00:00 | 2017-02-18 00:00:00 | 2017-02-19 00:00:00 | 2017-02-20 00:00:00 | 2017-02-21 00:00:00 | 2017-02-22 00:00:00 | 2017-02-23 00:00:00 | 2017-02-24 00:00:00 | 2017-02-25 00:00:00 | 2017-02-26 00:00:00 | 2017-02-27 00:00:00 | 2017-02-28 00:00:00 |  |  |  |  |  |  |  |  | 10
 |  |  |  | 2017-02-02 00:00:00 | 2017-02-03 00:00:00 | 2017-02-04 00:00:00 | 2017-02-05 00:00:00 | 2017-02-06 00:00:00 | 2017-02-07 00:00:00 | 2017-02-08 00:00:00 | 2017-02-09 00:00:00 | 2017-02-10 00:00:00 | 2017-02-11 00:00:00 | 2017-02-12 00:00:00 | 2017-02-13 00:00:00 | 2017-02-14 00:00:00 | 2017-02-15 00:00:00 | 2017-02-16 00:00:00 | 2017-02-17 00:00:00 | 2017-02-18 00:00:00 | 2017-02-19 00:00:00 | 2017-02-20 00:00:00 | 2017-02-21 00:00:00 | 2017-02-22 00:00:00 | 2017-02-23 00:00:00 | 2017-02-24 00:00:00 | 2017-02-25 00:00:00 | 2017-02-26 00:00:00 | 2017-02-27 00:00:00 | 2017-02-28 00:00:00
 |  | 2017-02-01 00:00:00 | 1 | 1 | 1 | 1 | 1
Spreadsheet: dc088b15-d527-4001-9471-8ee480d2d09f
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
42653818 | 2014-08-09 18:45:27 | AXIS | 0 | 2 | 6 | 1443685 | david.kahn | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42654093 | 2014-08-09 19:09:19 | ALLIES | 0 | 4 | 6 | 1443685 | david.kahn | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42659541 | 2014-08-10 03:32:18 | AXIS | 0 | 3 | 6 | 384175 | ssegrubnad | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42659645 | 2014-08-10 03:47:49 | ALLIES | 0 | 2 | 6 | 384175 | ssegrubnad | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42711032 | 2014-08-13 21:09:06 | AXIS | 0 | 5 | 6 | 565556 | Phidaone | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42711256 | 2014-08-13 21:27:40 | ALLIES | 1 | 6 | 2 | 565556 | Phidaone | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42771991 | 2014-08-18 05:38:37 | AXIS | 1 | 6 | 4 | 1620635 | [NAME] | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42772486 | 2014-08-18 06:06:11 | ALLIES | 0 | 3 | 6 | 1620635 | [NAME] | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42785225 | 2014-08-19 03:55:33 | AXIS | 0 | 4 | 6 | 1602528 | player1602528 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42785509 | 2014-08-19 04:16:41 | ALLIES | 1 | 6 | 2 | 1602528 | player1602528 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
Spreadsheet: 6cbdaa25-83e9-4701-8549-c9bc85869edc
Sheet: EPR 1X CQY

Reconciliations of GAAP to Non-GAAP Adjusted Financial Measures
(In millions, except EPS)
Second Quarter Ended March 31, 2013
 |  |  |  |  | Continuing Operations
 | Revenue | Cost of  Revenues | Operating Expenses | Operating Income | Net Earnings (a) | Diluted EPS
GAAP measures | 600 | 258.7 | 212 | 129.3 | 78.21000000000001 | 0.29
% of revenue |  |  | 0.3533333333333333 | 0.2155
Acquisition related charges: (b)
Contingent retention & earn-out | 0 | 0 | -21.9 | 21.9 | 14.6 | 0.06
Amortization of intangibles | 0 | -2.3 | -4.5 | 6.8 | 4.5 | 0.02
Proxy fees | 0 | 0 | -3.9 | 3.9 | 2.6 | 0.01
Alabama Note impairment | 0 | 0 | -1.6 | 1.6 | 1.1 | 0
Certain discrete tax items (benefits) | 0 | 0 | 0 | 0 | -5.9 | -0.02
Total non-GAAP adjustments | 0 | -2.3 | -31.9 | 34.2 | 16.9 | 0.06999999999999999
Adjusted measures | 600 | 256.4 | 180.1 | 163.5 | 95.11000000000001 | 0.36
% of revenue |  |  | 0.3001666666666666 | 0.2725
Six Months Ended March 31, 2013
 |  |  |  |  | Continuing Operations
 | Revenue | Cost of  Revenues | Operating Expenses | Operating Income | Net Earnings (a) | Diluted EPS
GAAP measures | 1130.2 | 479.5000000000001 | 403 | 247.6999999999999 | 143.4999999999999 | 0.54
% of revenue |  |  | 0.3565740576889046 | 0.2191647496018403
Acquisition related charges: (b)
Contingent retention & earn-out | 0 | 0 | -39.3 | 39.3 | 26.2 | 0.1
Amortization of intangibles | 0 | -4.6 | -8.9 | 13.5 | 9 | 0.03
Proxy fees | 0 | 0 | -3.9 | 3.9 | 2.6 | 0.01
Alabama Note impairment | 0 | 0 | -1.6 | 1.6 | 1.1 | 0
Royalty settlement | -5 | 0 | 0 | -5 | -5 | -0.02
Certain discrete tax items (benefits) | 0 | 0 | 0 | 0 | -5.9 | -0.02
Total non-GAAP adjustments | -5 | -4.6 | -53.7 | 53.3 | 28 | 0.1
Adjusted measures | 1125.2 | 474.9 | 349.3 | 300.9999999999999 | 171.4999999999999 | 0.64
% of revenue |  |  | 0.3090603433020704 | 0.2663245443284374
(a) Adjustments tax effected at 34%, except no tax effect on royalty settlement
(b) Primarily related to DoubleDown
Spreadsheet: 849835d1700218216-filter-for-group-name-filter
Sheet: Sheet1

Identification | Unit | SN
RACK 1 | L1 server | 37498374987
 | Cisco switch | 9872987843
 | QSFP switch | 970974
 | Cisco switch 2 | 394203984
 | PMDU | 9238409
 | PMDU cable 1 | 9283409
 | Pmdu cable 2 | 3284
RACK 2 | L1 server | 23598
 | Cisco switch | 3843085
 | QSFP switch | 89084395
 | Cisco switch 2 | 8983095
 | PMDU | 843850958
 | PMDU cable 1 | 433589
 | Pmdu cable 2 | 3048