tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 701771d1603917016-function-for-column-that-assigns-a-number-increasing-based-on-duplicate-data-sample
Sheet: Sheet1

Date | Sample Number
2019-10-21 00:00:00 | 1
2019-10-22 00:00:00 | 1
2019-12-31 00:00:00 | 1
2020-01-07 00:00:00 | 1
2020-01-08 00:00:00 | 1
2020-01-14 00:00:00 | 1
2020-01-14 00:00:00 | 2
2020-01-18 00:00:00 | 1
2020-01-27 00:00:00 | 1
2019-06-05 00:00:00 | 1
2019-06-19 00:00:00 | 1
2019-08-13 00:00:00 | 1
2019-08-19 00:00:00 | 1
2019-08-20 00:00:00 | 1
2019-09-17 00:00:00 | 1
2019-12-03 00:00:00 | 1
2019-12-03 00:00:00 | 2
2019-12-03 00:00:00 | 3
2019-12-03 00:00:00 | 4
2019-12-17 00:00:00 | 1
2020-01-05 00:00:00 | 1
2020-01-14 00:00:00 | 1
Spreadsheet: 122716d1317100519-black-cells-need-refresh-fnati
Sheet: LOSSES

 |  |  |  |  | Υp |  |  | Δspr(Mpa) |  | PER BOLT
 |  | TOTAL NUMBER OF BOLTS: |  |  | n |  |  | Ac (m2) |  | TOTAL [NAME]
 |  | INITIAL PRESTRESSING (kN): | 700 |  | ψ(t,to) | 2 |  | Ic (m4) |  | TOTAL [NAME]
 |  | FINAL PRESTRESSING (kN): |  |  | εcs |  |  | c | 0.8
 |  |  |  |  | scp(Mpa) |  |  | Ap (m2) |  | TOTAL BOLTS
INNER RING |  |  |  |  |  |  |  | OUTER RING
n | Tperno (MN) | Pi(KN) | DP3(KN) | DPdif (KN) | Pf(KN) | % |  | n | Tperno (MN) | Pi(KN) | DP3(KN) | DPdif (KN) | Pf(KN) | %
Spreadsheet: 795b12b4-c89d-4387-abe7-bca964889009
Sheet: Sheet1

electronica 2010 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (16 Entries):
 | 1 Semiconductors 1.11 ICs, special designs (including ASICs/CSICs) 1.11.2 Active ICs
No. | Company | Country | City | [NAME] | Hall/Booth
1 | Creative Chips GmbH | Germany | Bingen | 55411 | A4.217
2 | Digi International Company | Germany | Dortmund | 44227 | A6.414
3 | ED-V Gesellschaft für Elektronik + Design In mbH | Germany | Mainaschaff | 63814 | A5.301
4 | Elmos Semiconductor AG | Germany | Dortmund | 44227 | A6.320
5 | [NAME]Vertriebs GmbH | Germany | Nagold | 72202 | A5.138
6 | Epson Europe Electronics GmbH | Germany | München | 80992 | A4.224
7 | Express Electronics Ltd. | United Kingdom | Osbaldwick, York | YO10 3JB | A4.553
8 | Fraunhofer-Institut für Mikroelektronische Schaltungen und Systeme (IMS) | Germany | Duisburg | 47057 | A5.139
9 | Future Technology Devices Intl. Ltd. (FTDI) | United Kingdom | [NAME] 1HH |  | A5.351
10 | HMT microelectronic AG | Switzerland | Biel/Bienne | 2503 | A4.459
11 | Initial Electronics Inc. | Canada | Blainville | J7C 0B5 | A6.131/1
12 | RFMD | USA | Greensboro | NC 27409 | A4.136
13 | TRG Components (The Republic Group) | USA | Arlington | VA 22207 | A5.161
14 | UniQuip Plus Inc. | USA | [NAME] | FL 33487 | A5.269
15 | United Sources Industrial Enterprises | Hong Kong | [NAME], N.T. |  | B2.460/3
16 | Virginia Technology Inc. | USA | Arlington | VA 22207 | A5.161
Spreadsheet: 72652d1273341216-search-multiple-worksheets-acme-schedules
Sheet: PACKAGING

WORK CATEGORY CODES: |  |  |  |  | DIVISION/ [NAME]:
W – WORK           SA – SPECIAL ASSIGNMENT    SL – SICK LEAVE
DO – DAY OFF        HW – HOLIDAY WORKED        AV – ADVANCE |  |  |  |  | STORE 1811
AL – ANNUAL LEAVE   WT – WORK/TRAVEL
 |  | PERIOD COVERED |  |  | SHIFT:
 |  |  |  |  | PACKAGING
 | NAME | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THRUSDAY | FRIDAY | SATURDAY
1 | T. MURIECH |  |  |  |  |  |  |  | T. MURIECH | T. MURIECH | T. MURIECH | T. MURIECH | T. MURIECH | T. MURIECH | T. MURIECH
2 | D. KINS |  |  |  |  |  |  |  | D. KINS | D. KINS | D. KINS | D. KINS | D. KINS | D. KINS | D. KINS
3 | [NAME] |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
4 | R. BURROS |  |  |  |  |  |  |  | R. BURROS | R. BURROS | R. BURROS | R. BURROS | R. BURROS | R. BURROS | R. BURROS
5 | G. COLER |  |  |  |  |  |  |  | G. COLER | G. COLER | G. COLER | G. COLER | G. COLER | G. COLER | G. COLER
6 | [NAME] |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
7 | D. LICK |  |  |  |  |  |  |  | D. LICK | D. LICK | D. LICK | D. LICK | D. LICK | D. LICK | D. LICK
8 | R. PAILIK |  |  |  |  |  |  |  | R. PAILIK | R. PAILIK | R. PAILIK | R. PAILIK | R. PAILIK | R. PAILIK | R. PAILIK
9 | C. DUN |  |  |  |  |  |  |  | C. DUN | C. DUN | C. DUN | C. DUN | C. DUN | C. DUN | C. DUN
10 | D. LALUSK |  |  |  |  |  |  |  | D. LALUSK | D. LALUSK | D. LALUSK | D. LALUSK | D. LALUSK | D. LALUSK | D. LALUSK
11 | S. DINHS |  |  |  |  |  |  |  | S. DINHS | S. DINHS | S. DINHS | S. DINHS | S. DINHS | S. DINHS | S. DINHS
12 | K. ANDERSEN |  |  |  |  |  |  |  | K. ANDERSEN | K. ANDERSEN | K. ANDERSEN | K. ANDERSEN | K. ANDERSEN | K. ANDERSEN | K. ANDERSEN
13 | J. PESS |  |  |  |  |  |  |  | J. PESS | J. PESS | J. PESS | J. PESS | J. PESS | J. PESS | J. PESS
14 | T. POOR |  |  |  |  |  |  |  | T. POOR | T. POOR | T. POOR | T. POOR | T. POOR | T. POOR | T. POOR
15 | B. SMITH |  |  |  |  |  |  |  | B. SMITH | B. SMITH | B. SMITH | B. SMITH | B. SMITH | B. SMITH | B. SMITH
16 | E. SULIE |  |  |  |  |  |  |  | E. SULIE | E. SULIE | E. SULIE | E. SULIE | E. SULIE | E. SULIE | E. SULIE
17 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
18 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
19 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
20 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
21 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
22 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
23 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
24 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TOTAL SOT:
 | CITIES TO:
 | CITIES FROM:
 | TEMPS:
PREPARED BY |  |  |  |  | SIGNATURE
BRAD PITT |  |  |  |  | [NAME]
Spreadsheet: andy_zipper__287__Mar Apr straddle spread
Sheet: 45 vol payoff matrix

 | April Strike | 2.25
 | [NAME] | 2.25
 | Apr Vol | 0.65
 | 0.2
Spreadsheet: 864875d1712010338-n-a-wont-go-away-despite-iferror-ifna-filters-book1
Sheet: Sheet1

 | NICK (S) | NICK/T16 |  |  | NICK/T3 | NICK/T16 |  |  | NICK-100
 | LEROY (S) | LEROY/T11 | LEROY/T11 |  |  | LEROY/T11 |  |  | QUANDEL-28
 | [NAME] (S) |  |  |  |  |  |  |  | ERIC-96
 | JON (s) |  | JON/T13 |  |  | JON/T11 |  |  | ANDRE-15
 | ANDRE (s) | ANDRE/T11 |  |  | ANDRE/T2 |  |  | ANDRE/T11 | JON-14
 |  |  |  |  |  |  |  |  | JOHN-15
 | [NAME] (A) |  |  |  |  |  |  |  | JORDAN-150
 | QUANDEL (A) | QUANDEL/T12 | QUANDEL/T11 |  |  | QUANDEL/T14 |  |  | DAVE-65
 | [NAME] (a) |  |  |  |  |  |  |  | LEROY-64
 | [NAME] (a) |  |  |  |  |  |  | DAVE/T13
 |  | False |  |  | ANDRE-15
 |  | False
 |  | False
Spreadsheet: 822354d1679300811-merge-tables-and-sum-in-different-sheets-book1
Sheet: Feb

 |  |  |  |  |  |  |  |  |  |  | Result |  |  |  |  |  |  |  |  | Jan
PRODUCT | 10 | 20 | 30 | 40 | 50 | 60 | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  | Feb
A |  | 1 |  | 1 |  | 11 |  |  |  |  | PRODUCT | 10 | 20 | 30 | 40 | 50 | 60 | TOTAL
B |  |  |  |  |  | 1 |  |  |  |  | A
C | 1 |  |  | 1 | 1 |  |  |  |  |  | B
D |  | 1 |  |  |  | 1 |  |  |  |  | C
E | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  | D
F |  |  |  |  |  | 1 |  |  |  |  | E
G |  | 1 | 1 | 123 |  |  |  |  |  |  | F
H | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  | G
I |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  | H
 |  |  |  |  |  |  |  |  |  |  | I
PRODUCT | 10 | 20 | 30 | 40 | 50 | 60 | TOTAL
H |  |  |  |  |  | 1
I | 1
Spreadsheet: 113032d1308958920-attempting-to-create-a-formula-code-to-have-excel-automatically-move-a-column-over-scratchers-form_before
Sheet: Sheet1

LOTTERY SALES |  |  |  |  | This is the before, with some random numbers to simulate what this worksheet will be used for
BOX | PREVIOUS DAY | TODAY | # [NAME] | $ [NAME]
1 | 28 | 34 | 6 | 6
2 | 12 | 13 | 1 | 1
3 | 212 | 215 | 3 | 3
4 | 114 | 116 | 2 | 2
5 | 49 | 50 | 1 | 2
6 | 48 | 54 | 6 | 12
7 | 19 | 19 | 0 | 0
8 | 55 | 56 | 1 | 2
9 | 12 | 17 | 5 | 15
10 | 36 | 39 | 3 | 9
11 | 73 | 77 | 4 | 12
12 | 95 | 95 | 0 | 0
13 | 75 | 78 | 3 | 15
14 | 6 | 17 | 11 | 55
15 | 19 | 20 | 1 | 5
16 | 12 | 16 | 4 | 20
 |  | Scratcher Sales = |  | 159
 |  | Lottery Sales = |  | 208
 |  | Actual Sales = |  | 367
 |  | Report Sales = |  | 358
 |  | Over/Short = |  | -9
Closing Date | 2011-06-23 00:00:00
Spreadsheet: 153369d1335886410-populating-info-from-pivot-table-example1
Sheet: Pivot

Row Labels | Sum of Balance
[NAME] | 485
1 | 143
2 | 149
3 | 193
Boston | 574
1 | 168
2 | 179
3 | 227
Dallas | 459
1 | 170
2 | 146
3 | 143
Miami | 498
1 | 197
2 | 157
3 | 144
New York | 495
1 | 168
2 | 152
3 | 175
San Francisco | 629
1 | 202
2 | 227
3 | 200
(blank)
Grand Total | 3140
Spreadsheet: 93201d1292802387-whole-numbers-in-a-range-whole-numbers-in-a-range
Sheet: Sheet1

 |  |  | 96 | 120 | 144 | 168 | 192
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 144
 |  | 84
 |  | 96
 |  | 840
 |  | 432
 |  | 672
Spreadsheet: 648699d1573153977-conditional-formatting-traffic-light-system-conditional-formatting-cells-traffic-light-system
Sheet: Sheet1

Ag/Hort | 2019 | 2020
Materials & Resources | 2350 | 2610
Printing | 300 | 350
Professional/M-ship Fees | 30 | 30
Other Expenses | 300 | 305
Dept Small Items < $1000 | 750 | 700
Dept Travel | 122 | 130
Total
Spreadsheet: 88218d1288106877-conversion-within-sum-calculated-rates2
Sheet: Sheet1

 |  |  | eur-usd | 0.712708
 |  |  | gbp-usd | 0.636127
 |  |  |  |  |  |  |  |  |  |  | total
 |  | usd | 1 | gbp | 2 | gbp | 30 | usd | incl |  | 51.30442034373639 | usd
 |  | gbp | incl | usd | incl | usd | 10 | usd | 10 |  | 12.72254 | gbp
Spreadsheet: 746918d1631111417-creating-a-list-from-table-matches-sample
Sheet: Sheet1

 |  |  | MON | TUE | WED | THUR | FRI | SAT
 | Llangristiolus | [NAME] | L24 | L24 | L24 | L24 | DAY OFF | L24
 | Malltraeth | [NAME] | A/L | A/L | A/L | A/L | A/L | DAY OFF
 | [NAME] | [NAME] 6
 | Llanfaelog | [NAME] | [NAME] | [NAME] | DAY OFF | [NAME] | [NAME] | [NAME]
 | Llangwyfan | [NAME] | L20 | L20 | [NAME] | DAY OFF | DAY OFF | DAY OFF
 | Llangwyfan | [NAME] | DAY OFF | DAY OFF | DAY OFF | L20 | L20 | L20
 | [NAME] | [NAME] | Day Off | [NAME] | L12 | L22 | L24 | L12
 | Leave reserve (35) | [NAME] | L15 | L6 | L20 | L6 | L6 | Day Off
Spreadsheet: 355808d1414787513-move-a-row-to-a-new-sheet-based-on-a-cells-value-job-requisition-workbook
Sheet: FALLS CITY

Falls City Healthcare Community |  |  |  | Administrator: [NAME] DON: [NAME] |  | EEO: Phone: [PHONE]
Requisition # | Job Title | Department | [NAME] | Position Open | Offer Accepted | Shift | Reason for Opening | Days Open | Satus
FALLS14001 | LPN | Nursing | $13.00+ | 2014-10-30 00:00:00 |  | FT NIGHT | [NAME].
Spreadsheet: 138566d1327720230-advancing-arrays-based-on-value-shedule_example
Sheet: DAILYSTF

DAILY STAFFING
 | 2012-01-09 00:00:00 | 2012-01-09 00:00:00 | 1 | Day ID
SHIFT |  | LEAVE/TRAINING
0800 - 1600 | Person 8
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
0800 - 2115 | #N/A
 | #N/A
 | #N/A
 | #N/A
1045 - 2400 | Person 7
 | #N/A
 | #N/A
 | #N/A
 | #N/A
1600-2400 | Person 5
 | Person 6
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | Location 2
0900-1700 | Person 9
 | SUPERINTENDENT
Spreadsheet: 842261d1694406324-trying-to-reference-same-cell-from-different-sheets-using-indirect-function-indirect-issue
Sheet: 2

 | 5401 Biddulph
 |  | 1
 |  | 2023-01-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Annual
 | Starting Balance | 6193.68
 | Income
 | Rent Up | 925 | 925 | 925 | 925 | 925 | 925 | 925 | 925 | 925 | 925 | 925 | 925
 | Rent Down
 | Security Deposit | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total Income
 | Expenses
 | Water
 | Insurance | 0 | 0
 | Repairs |  |  |  |  | -170.78
 | CAPEX | 0
 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total Expenses
 | Debt Service | -560
 | Cash Flow
 | Ending Balance
 | Itemized Repairs & CAPEX
 | Jan
Jan
 | Feb
 | March
 | April
 | Landscaping
 | HD Tools
 | May
 | Leo AC repair | -170.78
Spreadsheet: 754397d1636135146-lookup-formula-does-not-work-lookup-problem
Sheet: Spec Sheet

No | Chest | A. Chest | Waist | Bottom | Length | [NAME] | [NAME] | [NAME] | [NAME] | Sh. Slope | Armhole P-Sh | Arm Length | [NAME] | [NAME]. | [NAME] | A. Back | Back Neck D. | [NAME] | Arm B. | Bot. B.
1
2
3
4
5
6
7
Spreadsheet: 789096d1658907088-return-a-value-when-searching-for-a-text-string-within-a-cell-example
Sheet: EXPECTED

Item Number | Supplier Price(this is the cost price)
7P29022NVLM12 | 50
7WFBP29022 | 50
7WFBP29022 : 7WFBP29022BKFL12 | 50
7WFBP29022 : 7WFBP29022BKLI10 | 50
7WFBP29022 : 7WFBP29022BKLI12 | 50
7WFBP29022 : 7WFBP29022BKLI14 | 50
7WFBP29022 : 7WFBP29022BKLI16 | 50
7WFBP29022 : 7WFBP29022BKLI8 | 50
7WFBP29022 : 7WFBP29022GYOR10 | 50
7WFBP29022 : 7WFBP29022GYOR12 | 50
7WFBP29022 : 7WFBP29022GYOR14 | 50
7ZP29022 | 50
7ZP305LS | 40
7ZP305LS : 7ZP305LSBK12 | 40
7ZP305LS : 7ZP305LSBK14 | 40
7ZP305LS : 7ZP305LSBK16 | 40
7WF14015 | 100
7WF14015 : 7WF14015NV10 | 100
7WF14015 : 7WF14015NV14 | 100
7WF14015 : 7WF14015NV18 | 100
7WF14015 : 7WF14015NV22 | 100
7WFBCL955LL | 10
7WFBCL955LL : 7WFBCL955LLBK10 | 10
7WFBCL955LL : 7WFBCL955LLBK12 | 10
7WFBCL955LL : 7WFBCL955LLBK14 | 10
7WFBCL955LL : 7WFBCL955LLBK16 | 10
Spreadsheet: 266859d1379788340-help-with-sumif-forumula-lakewestassessment
Sheet: Section 5

 | Instructor:  [NAME] | Wilson
Student Number | Major | Classification | Q1 | Q2 | Q3 | Q4 | Q5 | Q6 | Q7 | Q8 | Q9 | Q10
81 | MRKT | Senior | a | c | d | b | a | b | c | c | e | a
82 | MNGT | Sophomore | a | d | e | b | a | b | c | c | e | a
83 | MNGT | Junior | d | c | d | b | a | b | c | c | e | a
84 | MRKT | Freshman | a | d | c | b | a | b | c | c | e | a
85 | FIN | Sophomore | a | c | d | b | a | c | c | c | e | a
86 | ACCT | Sophomore | a | c | d | c | a | b | c | c | d | c
87 | MIS | Freshman | a | c | d | b | a | b | c | c | a | b
88 | MIS | Sophomore | a | c | d | b | a | b | c | c | d | d
89 | MIS | Sophomore | a | c | d | b | a | c | c | e | e | a
90 | FIN | Sophomore | a | c | d | d | a | c | c | c | e | a
91 | MIS | Freshman | a | c | d | b | a | b | c | c | e | a
92 | ACCT | Junior | c | c | d | b | c | b | c | c | e | a
93 | MNGT | Sophomore | c | c | e | b | a | b | c | c | e | a
94 | FIN | Sophomore | a | c | d | d | a | b | c | c | e | a
95 | ACCT | Sophomore | a | d | e | b | a | b | c | c | e | a
96 | MRKT | Junior | a | c | d | d | a | b | c | c | e | a
97 | MIS | Freshman | a | c | d | b | a | b | c | c | e | a
98 | ECON | Freshman | a | c | d | b | a | d | c | c | e | a
99 | ECON | Freshman | a | c | d | b | a | b | c | c | e | a
100 | ECON | Sophomore | a | c | d | d | a | b | c | c | e | a
Spreadsheet: 864431d1711597865-array-formula-but-with-different-formula-inbetween-column-a-v-b
Sheet: Actual

Description |  | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00
Sales-Toy | 4099 | 4698 | 4491 | 4998 | 4240 | 4844 | 4341 | 5159 | 4109 | 4304 | 5236 | 5861
Sales-Food | 2042 | 2102 | 2143 | 1910 | 2109 | 2053 | 2132 | 1972 | 1902 | 2164 | 2076 | 1921
Sales-Furniture | 3885 | 4246 | 3780 | 4160 | 3628 | 3235 | 4198 | 3399 | 2885 | 2553 | 3893 | 4120
Sales-Foreign | 150 |  | 750 | 1100 | 600 |  | 600 |  |  | 500 | 1200
Spreadsheet: 273b6b81-5121-4348-a562-319be0aee87b
Sheet: Rev Mix by Geographic Region

 | [NAME], INC. AND SUBSIDIARIES
 | FINANCIAL INFORMATION
 | (Amounts in millions)
 |  |  |  | Q3(i) | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2
 |  |  |  | CY08 | CY08 | CY09 | CY09 | CY09 | CY09 | CY10 | CY10 | CY10 | CY10 | CY11 | CY11
 | GAAP Net Revenues by Geographic Region
 |  | North America |  | 295 | 903 | 524 | 557 | 378 | 759 | 703 | 567 | 406 | 734 | 748 | 580
 |  | Europe |  | 348 | 660 | 392 | 408 | 287 | 710 | 524 | 337 | 281 | 600 | 594 | 467
 |  | Asia Pacific |  | 62 | 75 | 64 | 73 | 38 | 88 | 81 | 63 | 58 | 93 | 107 | 99
 |  | Total net revenues core operations
 |  | Activision Blizzard’s non-core exit operations |  | 6 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total consolidated GAAP net revenues
 | Change in Deferred Net Revenues 1
 |  | North America
 |  | Europe
 |  | Asia Pacific
 |  | Total changes in net revenues
 | Activision Blizzard’s non-core exit operations 1 |  |  |  | -1 | -1
 | Non-GAAP Net Revenues by Geographic Region
 |  | North America |  |  | 1346 | 374 | 392 | 404 | 1287 | 391 | 375 | 447 | 1361 | 365 | 331
 |  | Europe |  |  | 901 | 293 | 339 | 309 | 1081 | 270 | 258 | 334 | 1040 | 323 | 286
 |  | Asia Pacific |  |  | 96 | 57 | 70 | 42 | 127 | 53 | 50 | 76 | 147 | 67 | 82
 |  | Total non-GAAP net revenues 2
 |  | 1 We provide net revenues including (in accordance with GAAP) and excluding (non-GAAP) the impact of changes in deferred net revenues.
 |  | 2 Total non-GAAP net revenues presented also represents our total operating segment net revenues.
 |  | (i) Results of Activision Blizzard for the period from July 9, 2008 (commencement of the Business Combination) to September 30, 2008 and Vivendi Games for period from
 |  | July 1, 2008 to July 8, 2008.
Spreadsheet: 96518d1295901958-time-spanning-midnight-as-minutes-not-hh-mm-sample-problem
Sheet: Sheet1

User ID | User Name | Stations Filled | Time Finish | Time  Start | Transactions | Date | Total Refill Time | lines per hour | time per station | lines per station | time per line per station
E37700 | [NAME], George | 11 | 06:57 | 01:21 | 273 | 01/24/11 | 336.0000000000001 | 48.74999999999999 | 30.54545454545455 | 24.81818181818182 | 1.230769230769231
E18766 | Curry, Christine | 8 | 07:16 | 03:08 | 224 | 01/24/11 | 248 | 54.19354838709678 | 31 | 28 | 1.107142857142857
E38440 | [NAME], [NAME] | 16 | 06:27 | 02:39 | 211 | 01/24/11 | 228 | 55.52631578947368 | 14.25 | 13.1875 | 1.080568720379147
E37982 | [NAME] | 3 | 09:06 | 06:41 | 145 | 01/24/11 | 145 | 60.00000000000001 | 48.33333333333332 | 48.33333333333334 | 0.9999999999999997
E38205 | Appleton, [NAME] | 3 | 07:26 | 05:53 | 138 | 01/24/11 | 93.00000000000003 | 89.0322580645161 | 31.00000000000001 | 46 | 0.6739130434782611
E30527 | Culler, Josephine M | 5 | 06:23 | 05:33 | 70 | 01/24/11 | 50.00000000000002 | 83.99999999999997 | 10 | 14 | 0.7142857142857145
E35223 | Wilson, Leroy | 3 | 08:20 | 08:01 | 42 | 01/24/11 | 19.00000000000001 | 132.6315789473683 | 6.333333333333338 | 14 | 0.4523809523809527
E17682 | [NAME], [NAME] | 9 | 23:13 | 00:54 | 184 | 01/06/11, 01/07/11
E38440 | [NAME], [NAME] | 22 | 06:16 | 02:11 | 168 | 01/07/11
E37700 | [NAME], George | 8 | 23:17 | 00:44 | 154 | 01/06/11, 01/07/11
E37982 | [NAME] | 3 | 08:05 | 06:33 | 109 | 01/07/11
E35223 | Wilson, Leroy | 2 | 07:44 | 07:14 | 94 | 01/07/11
E18766 | Curry, Christine | 5 | 04:34 | 02:01 | 82 | 01/07/11
E30527 | Culler, Josephine M | 5 | 08:06 | 05:26 | 55 | 01/07/11
E39176 | Flores, [NAME] | 2 | 05:10 | 05:05 | 21 | 01/07/11
Spreadsheet: 827502d1682755204-rearranging-set-of-data-from-rows-to-columns-rearranging-data-aligw
Sheet: Sheet1

Data Available as follows |  |  | Data Required as follows
a |  |  | a | 10 |  |  |  | 10
10 |  |  | b | 11 |  |  | b | 11
 |  |  | c | 12 |  |  | c | 12
b |  |  | d | 13 |  |  | d | 13
11
c
12
d
13
Spreadsheet: 680627d1591115195-one-line-formula-structured-reference-to-column-header-with-line-breaks-use-structured-references-in-excel-table-formulas
Sheet: Sheet1

[NAME] | Region | Sales Amount | % Commission | Commission Amount
[NAME] | North | 260 | 0.1
Ashely Woodward | South | 660 | 0.15
[NAME] | East | 940 | 0.15
[NAME] | West | 410 | 0.12
Paki Clark | North | 800 | 0.15
[NAME] | South | 900 | 0.15
Spreadsheet: 679351d1590343678-pull-in-top-products-but-not-duplicates-top-25-porducts-sample
Sheet: DASHBOARD

 |  |  |  |  |  |  |  |  |  | ROI Percentage |  |  | No. Products
 |  |  |  |  |  |  |  |  |  | 50% + | 0.5
 |  |  |  |  |  |  |  |  |  | 49%-30% | 0.49 | 0.3
 |  |  |  |  |  |  |  |  |  | Below 30% | 0.3
Top 25 Products | ASIN | Product Name | ROI |  | 25 Worst Products | ASIN | Product Name | ROI
1 |  |  |  |  | 1
2 |  |  |  |  | 2
3 |  |  |  |  | 3
4 |  |  |  |  | 4
5 |  |  |  |  | 5
6 |  |  |  |  | 6
7 |  |  |  |  | 7
8 |  |  |  |  | 8
9 |  |  |  |  | 9
10 |  |  |  |  | 10
11 |  |  |  |  | 11
12 |  |  |  |  | 12
13 |  |  |  |  | 13
14 |  |  |  |  | 14
15 |  |  |  |  | 15
16 |  |  |  |  | 16
17 |  |  |  |  | 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
Spreadsheet: 109551d1306378989-index-match-newassist-ss-sample-w-dsum
Sheet: DSUM

 |  |  |  |  |  |  |  |  | You can hide these 4 rows
 |  | Col # in Data
 |  |  | OI CY BLC |  |  |  |  |  | [NAME] |  |  |  |  |  | OI CY WP
 |  |  | BSS |  | CT |  | BP |  | BSS |  | CT |  | BP |  | BSS |  | CT |  | BP
 | Orange | Assist | CY | PY | CY | PY | CY | PY | CY | PY | CY | PY | CY | PY | CY | PY | CY | PY | CY | PY
 |  | Total
 |  | Win
 |  | Loss
 |  | CA
 |  | Qual
 | NA-US | Total
 | NA-US | Win
 | NA-US | Loss
 | NA-US | CA
 | NA-US | Qual
 | NA-CA | Total
 | NA-CA | Win
 | NA-CA | Loss
 | NA-CA | CA
 | NA-CA | Qual
 | NE-ALP | Total
 | NE-ALP | Win
 | NE-ALP | Loss
 | NE-ALP | CA
 | NE-ALP | Qual
 | NE-GER | Total
 | NE-GER | Win
 | NE-GER | Loss
 | NE-GER | CA
 | NE-GER | Qual
 | NE-NOR | Total
 | NE-NOR | Win
 | NE-NOR | Loss
 | NE-NOR | CA
 | NE-NOR | Qual
 | SW-ITL | Total
 | SW-ITL | Win
 | SW-ITL | Loss
 | SW-ITL | CA
 | SW-ITL | Qual
 | SW-FRA | Total
 | SW-FRA | Win
 | SW-FRA | Loss
 | SW-FRA | CA
 | SW-FRA | Qual
 | GMU-GCG | Total
 | GMU-GCG | Win
 | GMU-GCG | Loss
 | GMU-GCG | CA
 | GMU-GCG | Qual
 | GMU-A/NZ | Total
 | GMU-A/NZ | Win
 | GMU-A/NZ | Loss
 | GMU-A/NZ | CA
 | GMU-A/NZ | Qual
 | GMU-CEE
Spreadsheet: 93607d1293194854-difference-in-time-hours-mins-betwn-2-dates-excluding-holidays-leaves-wkoffs-overtime-time-difference-between-two-dates
Sheet: Holiday_List

Sr.No | Public Holidays | Date | Day
1 | New Year's Day | 2010-01-01 00:00:00
2 | Good Friday | 2010-03-21 00:00:00
3 | Easter Monday | 2010-03-24 00:00:00
4 | [NAME] | 2010-05-19 00:00:00
5 | Canada Day | 2010-07-01 00:00:00
6 | Labour Day | 2010-09-01 00:00:00
7 | Thanksgiving Day | 2010-10-13 00:00:00
8 | Remembrance Day | 2010-11-11 00:00:00
9 | Christmas | 2010-12-25 00:00:00
10 | Boxing Day | 2010-12-31 00:00:00