tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 151638d1335031185-excel-2007-ytd-sales-to-goals-pivot-table-data-1
Sheet: Sheet1

date | dept | rep | sales | opps | closed | % | avg tkt
2012-04-08 00:00:00 | hvac | bb | 1000 | 10 | 4 | 0.4 | 250
2012-04-08 00:00:00 | hvac | xx | 425 | 6 | 5 | 0.5 | 85
2012-04-08 00:00:00 | plum | yy | 300 | 8 | 8 | 0.8 | 37.5
2012-04-08 00:00:00 | plum | zz | 1200 | 9 | 6 | 0.6 | 200
2012-04-08 00:00:00 | plum | aa | 1000 | 4 | 4 | 0.4 | 250
2012-04-08 00:00:00 | elec | cc | 600 | 3 | 2 | 0.2 | 300
2012-04-08 00:00:00 | elec | dd | 800 | 9 | 7 | 0.7 | 114.29
2012-04-15 00:00:00 | hvac | bb | 10000 | 20 | 10 | 1 | 1000
2012-04-15 00:00:00 | hvac | xx | 11000 | 19 | 9 | 0.9 | 1222.22
2012-04-15 00:00:00 | plum | yy | 12000 | 18 | 8 | 0.8 | 1500
2012-04-15 00:00:00 | plum | zz | 13000 | 17 | 7 | 0.7 | 1857.14
2012-04-15 00:00:00 | plum | aa | 14000 | 16 | 6 | 0.6 | 2333.33
2012-04-15 00:00:00 | elec | cc | 15000 | 15 | 5 | 0.5 | 3000
2012-04-15 00:00:00 | elec | dd | 16000 | 14 | 4 | 0.4 | 4000
Spreadsheet: 743343d1628429458-extend-index-and-match-function-data1
Sheet: Leave

ID | Start Date | End Date | Result
S035 | 10-July-2015 | 25-August-2015
S035 | 10-May-2019 | 17-July-2019
S035 | 21-July-2016 | 20-August-2016
S035 | 2-April-2018 | 7-April-2018
S035 | 2-March-2018 | 1-April-2018
S035 | 3-March-2018 | 1-April-2018
S035 | 4-February-2017 | 20-February-2017
Spreadsheet: 48085d1247247788-column-matching-command-example
Sheet: Sheet1

CITY | STATE
AUSTIN | TX
AUSTIN | TX
DELRAN | NJ
DELRAN | NJ
DELRAN | NJ
DELRAN | NJ
MILLVILLE | NJ
EATONTOWN | NJ
EATONTOWN | NJ
WEST LONG BRANCH | NJ
BRICK | NJ
TIMBERLAKE | NC
LAURINBURG | NC
SELMA | NC
OXFORD | NC
LUMBERTON | NC
GARNER | NC
ROXBORO | NC
DURHAM | NC
DURHAM | NC
BELCHERTOWN | MA
[NAME] | MA
SPRINGFIELD | MA
SANDY | UT
CHEROKEE | NC
CHEROKEE | NC
ROBBINSVILLE | NC
SYLVA | NC
SYLVA | NC
SYLVA | NC
SYLVA | NC
SYLVA | NC
SYLVA | NC
SYLVA | NC
SYLVA | NC
Spreadsheet: 58570d1258804708-color-blank-cells-test
Sheet: Sheet1

DATE | ITEM TYPE | AMOUNT | REFERENCE 1 | REFERENCE 2 | REFERENCE 3 | REFERENCE 4
2009-11-21 00:00:00 | [NAME] BOOKS | 2500 | LIB | 0 | 0
2009-11-21 00:00:00 | COMPUTERS | 15000 | 0 |  | COM
2009-11-21 00:00:00 | [NAME] BOOKS | 1500 | LIB | 0 | 0
2009-11-21 00:00:00 | [NAME] BOOKS | 250 | LIB | 0 | 0
2009-11-21 00:00:00 | COMPUTERS | 150 | 0 | 0 | COM
2009-11-21 00:00:00 | COMPUTERS | 350 | 0 | 0 | COM
2009-11-21 00:00:00 | COMPUTERS | 281 | 0 | 0 | COM
2009-11-21 00:00:00 | NEWSPAPERS | 75 | 0 | NEWS | 0
2009-11-21 00:00:00 | COMPUTERS | 600 | 0 | 0 | COM
2009-11-21 00:00:00 | [NAME] BOOKS | 450 | LIB | 0 | 0
2009-11-21 00:00:00 | DVDS | 100 | 0 | 0 | 0 | DVD
2009-11-21 00:00:00 | DVDS | 1470 | 0 | 0 | 0 | DVD
2009-11-21 00:00:00 | NEWSPAPERS | 25 | 0 | NEWS | 0 | 0
2009-11-21 00:00:00 | COMPUTERS | 3500 | 0 | 0 | COM | 0
Spreadsheet: f0c632eb-48e0-4425-bea4-e9abae20058a
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
2409 | 7030 | Miek | Vyncke | BEL | 0 | 00:38:39 | 00:00:00 | 01:14:28 | 00:00:00 | 00:38:39 | 1 | [NAME]
2409 | 12176 | [NAME] | Horak | RSA | 0 | 00:19:22 | 00:00:00 | 01:16:17 | 00:00:00 | 00:19:22 | 2 | 02:13:09
2409 | 7827 | [NAME] | Hogan | CAN | 0 | 00:36:51 | 00:00:00 | 01:19:27 | 00:00:00 | 00:36:51 | 3 | 02:23:09
2409 | 11514 | [NAME] | Sauks | CAN | 0 | 00:19:52 | 00:00:00 | 00:00:00 | 00:00:00 | 00:19:52 | DNF | 00:00:00
Spreadsheet: 837430d1690180725-incremental-numbers-in-one-cell-office-2016-increment-number
Sheet: Sheet1

 | 7 |  | 105
 | 14 |  | 161
 | 21
 | 28
 | 35
 | 42 |  |  |  | I am using office 2016
 | 49 |  |  |  | please help formula for cell F2 & F3
 | 56
 | 63
 | 70
 | 77
 | 84
 | 91
 | 98
 | 105
 | 112
 | 119
 | 126
 | 133
 | 140
 | 147
 | 154
 | 161
 | 168
 | 175
 | 182
 | 189
 | 196
 | 203
 | 210
 | 217
 | 224
 | 231
 | 238
 | 245
 | 252
 | 259
 | 266
 | 273
 | 280
 | 287
 | 294
Spreadsheet: eb76c2e2-fb3b-4720-9d72-c03a95ca4507
Sheet: 23

 |  | Transactions
Product Type |  | Cleared** | Uncleared
Total Metals* | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Energy | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Agricultural | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Index | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Other*** | Exotic
 | Option
 | Spot/Forward
 | Swap
TOTAL |  | N/A**** | N/A
Estimated swap transaction volumes, week ending February 15, by product type, participant type, and cleared status (in number of transactions), all tenors, currencies, and deliveries. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***Environment, Freight, Multi-Commodity Exotic
****N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 708233d1607684765-create-an-advanced-report-to-show-average-price-per-brand-sorted-by-country-cat-of-item-dashboard
Sheet: GERMANY

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: e47f7a14-61e8-4762-819d-dfe4524a3207
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
38762221 | 2013-11-29 21:53:52 | AXIS | 1 | 8 | 6 | 1010208 | Marsouin | 12446 | western | 1944-07-25 |  | [NAME] | [NAME]
38762564 | 2013-11-29 22:21:36 | ALLIES | 1 | 8 | 4 | 1010208 | Marsouin | 12446 | western | 1944-07-25 |  | [NAME] | [NAME]
38764561 | 2013-11-30 00:43:11 | AXIS | 0 | 5 | 6 | 188507 | WiredNun | 11593 | eastern | 1945-02-13 | 1945-05-06 | [NAME]
38764794 | 2013-11-30 01:03:53 | ALLIES | 1 | 6 | 2 | 188507 | WiredNun | 11593 | eastern | 1945-02-13 | 1945-05-06 | [NAME]
Spreadsheet: 814385d1674335318-alternative-to-vlookup-when-data-cant-be-ordered-sorted-without-errors-occuring-lookup
Sheet: Sheet1

[NAME] |  |  | Short String | LOOKUP RESULT
ABC123-WE |  |  | ABC123 |  | =VLOOKUP("*"&E2&"*",A2:A5,1,FALSE)
ABC123IB |  |  | ABC123IB
BCD455UI |  |  | BCD455
BCD455 |  |  | BCD455UI
Short String |  |  | [NAME] | LOOKUP RESULT
ABC123 |  |  | ABC123-WE |  | =IFERROR(INDEX($A$9:$A$12,AGGREGATE(15,6,MATCH("*"&$A$9:$A$12&"*",$D9,0)*(ROW($A$9:$A$12)-ROW(A$9)+1),1)),"")
ABC123IB |  |  | ABC123IB
BCD455 |  |  | BCD455UI
BCD455UI |  |  | BCD455
Spreadsheet: 167032d1341872827-vlookup-if-lookup_value-is-not-found-book1
Sheet: Sheet1

BRAND | 1st QTR | 2nd QTR |  |  | BRAND | 1st QTR | 2nd QTR
A | 2 | 7 |  |  | A | 2 | 7
B | 1 | 0 |  |  | B | 1 | 0
C | 4 | 5 |  |  | C | 4 | 5
 |  |  |  |  | D | #N/A | #N/A
E | 2 | 9 |  |  | E
F | 10 | 4 |  |  | F |  |  |  | I need these to result in 0.
 |  |  |  |  | G
H | 17 | 24 |  |  | H
Spreadsheet: 134692d1325589291-conditional-formatting-for-a-row-expense-record
Sheet: Master Formulas

Master [NAME]
Date Created: | 2011-07-02 00:00:00
In use from July 2011 onwards! |  |  |  | DENOTES KEY CELLS
Credit Cards |  |  |  | Monthly Summaries
[NAME] |  | FF Point Earn |  | Purchase Accounts |  | Expense Accounts | Description |  | Net Position
ANZ Amex Platinum |  | 1.5 pts/$ |  |  |  | [Car-Fuel] CF | Car Fuel Expense |  | Amex Ultimate
ANZ Visa Platinum |  | 0.5 pts/$ |  |  |  | [Car-General] CG | Car General Expenses |  | Citibank Visa
Amex Premium |  | 1.25 pts/$ |  |  |  | [Car-Insurance] CI | Car Insurance |  | WOW Master
WOW MasterCard |  | 1 pt/$ |  |  |  | [Car-Repairs] CR | Car Repairs |  | ANZ Amex Plat
Citibank Visa |  | 1 pt/$ |  |  |  | [Clothes] CL
Westpac Amex |  | 1 pt/$ |  |  |  | [Comm] CM | Communications
Amex Ultimate |  | 1.5 pts/$ |  |  |  | [Credit Card Fees] CCF | Credit Card Fees
ANZ Amex |  | 1 pt/$ |  |  |  | [Donations] DN
[NAME] |  | 0.5 pts/$ |  |  |  | [Drinks-Alcohol] DA
AMEX Discovery |  | 1 pt/$ |  |  |  | [Drinks] DR | Non-alcoholic drink purchases
Citibank MasterCard |  | Own Program |  |  |  | [Ent-Recreation] ER | Entertainment & Recreation
Temporary Account |  |  |  | Frequent [NAME] Earnt |  | [Ent-Tickets] ET | Entertainment Tickets
 |  |  |  |  |  | [Fees] FE | General Fees
 |  |  |  |  |  | [Food-Eating Out] FO
 |  |  |  |  |  | [Food-General] FG
Direct Banking |  |  |  |  |  | [Gifts] GI
[NAME] | Description | FF Point Earn |  |  |  | [Groceries] GR
Cash Withdrawl | [NAME] | N/A |  |  |  | [Holiday-Flights] HFL
BPAY Transfer | Cash transfer via BPAY | N/A |  |  |  | [Holiday-Food] HFO
Direct Transfer | Direct BSB Transfer | N/A |  |  |  | [Holiday-General] HG
 |  |  |  |  |  | [Interest] IN | Interest Charges
 |  |  |  |  |  | [Investments] IST
 |  |  |  |  |  | [IT] IT | IT & Computer Expenses
 |  |  |  |  |  | [Medical] MD
 |  |  |  |  |  | [Misc] MS | Miscellaneous expenses
 |  |  |  |  |  | [Movie-Tickets] MT | Movie Tickets
 |  |  |  |  |  | [Movie] MO | Movie Purchases
 |  |  |  |  |  | [Music] MU | Music Purchases
 |  |  |  |  |  | [Personal-Care] PC
 |  |  |  |  |  | [Social] SO
 |  |  |  |  |  | [Sport] SP | Recreational activities
 |  |  |  |  |  | [Toys] TO | I.e. cameras, equipment etc
 |  |  |  |  |  | [Transport] TS | E.g. public transport, tolls
 |  |  |  |  |  | [Travel] TRV
Spreadsheet: 707935d1607540420-auto-populate-cells-based-on-a-drop-down-list-selection-tacking-sheet
Sheet: Sheet 2 

San Francisco
Banking Center | Building System | Equip. Type | Equip. Location | Date Replaced | Opp. Life | PM Replacement Year | Est. Budget
Spreadsheet: 89146d1288894543-vlookup-2-sheets-and-return-values-in-rows-vlookup-3-sheets
Sheet: Sheet1

LOOKUP VALUE | RESULT AFTER VLOOKUP ACROSS MULTIPLE SHEETS
R1 | A | A1 | A2
R2 | B | B1 | B2
R3 | C | C1 | C2
R4 | D | D1 | D2
R5 | E | E1 | E2
R6 | F | F1 | F2
R7 | G | [NAME] | G2
R8 | H | H1 | H2
R9 | I | I1 | I2
R10 | J | J1 | J2
C1 | A | A1 | A2
C2 | B | B1 | B2
[NAME] | C | C1 | C2
C4 | D | D1 | D2
C5 | E | E1 | E2
C6 | F | F1 | F2
C7 | G | [NAME] | G2
C8 | H | H1 | H2
C9 | I | I1 | I2
C10 | J | J1 | J2
Spreadsheet: 736318d1623498220-spill-error-for-index-aggregate-function-test-file
Sheet: Budget Tracking

Säljare
AA
[NAME] lookup
ABC101
ABC102
ABC103
ABC104
ABC105
ABC107
ABC110
ABC116
ABC117
ABC130
ABC136
ABC137
[NAME]
ABC146
ABC147
ABC148
ABC153
ABC156
ABC157
ABC175
ABC176
ABC177
ABC178
ABC179
ABC180
ABC186
Spreadsheet: 750993d1633770172-searching-for-a-figure-from-a-column-matching-a-name-order-of-merit-par3-2022
Sheet: Order of Merit

 | MEMBER | [NAME] |  |  | Clacton | The Shire | Harleyford | Cardrona | Cold Ashby | [NAME] | Ullesthorpe |  | Ramsey |  |  | TOTAL | WINS
No |  | Memorial | Pairs | ReUnion | Essex | [NAME] | Bucks | European | Northants | Beds | Weekender | Leics | Cambs | Masters | Last Chance
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
Spreadsheet: 719542d1613723425-would-like-to-create-a-sliding-model-for-choosing-proportion-of-2-different-calculations-scenario-building-dummy-data
Sheet: Scenario B - New customers

Customer Number | Revenue Given | Total Revenue | Penetration
2925637 | 0 | 16334552
548065 | 0 | 4936664
2057165 | 0 | 10113526
2699911 | 0 | 8397925 |  |  |  | Scenario B |  |  |  | What penetration? | 0.045
2817540 | 0 | 15774571 |  |  |  | [NAME]
71664 | 0 | 14209276 |  |  |  | Revenue Generated
2844098 | 0 | 6803213 |  |  |  |  |  |  |  | TO HIT | 25000000
244118 | 0 | 2444944
1712225 | 0 | 12617426 |  |  |  | Increase in avg penetration | Additional revenue driven
1444341 | 0 | 14835581 |  |  |  | 0.005
202617 | 0 | 12855292
1047098 | 0 | 8161753
641818 | 0 | 6272206
750254 | 0 | 11615781
2926463 | 0 | 6979377
1068372 | 0 | 2108637
123114 | 0 | 4167810
414413 | 0 | 3771160
553461 | 0 | 7781239
2842658 | 0 | 5396039
1843411 | 0 | 16164401
292126 | 0 | 9436025
2446185 | 0 | 13898688
1989859 | 0 | 12782909
2240133 | 0 | 9154825
1289743 | 0 | 10251259
2293376 | 0 | 15148786
1977076 | 0 | 5774536
1966340.5 | 0 | 16214145
1969108.2 | 0 | 13444514.6666667
1971875.9 | 0 | 13977194.1666667
1974643.6 | 0 | 14509873.6666667
1977411.3 | 0 | 15042553.1666667
1980179 | 0 | 15575232.6666667
1982946.7 | 0 | 16107912.1666667
1985714.4 | 0 | 6640591.6666667
1988482.1 | 0 | 17173271.1666667
1991249.8 | 0 | 17705950.6666667
1994017.5 | 0 | 18238630.1666667
1996785.2 | 0 | 18771309.6666667
1999552.9 | 0 | 19303989.1666667
2002320.6 | 0 | 19836668.6666667
2005088.3 | 0 | 9505445
2007856 | 0 | 4388720
2010623.7 | 0 | 8341517
2013391.4 | 0 | 4932925
2016159.1 | 0 | 2673246
2018926.8 | 0 | 3583000
2021694.5 | 0 | 7912316
2024462.2 | 0 | 5277430
2027229.9 | 0 | 2677958
2029997.6 | 0 | 7854361
2032765.3 | 0 | 13070602
2035533 | 0 | 9458831
2038300.7 | 0 | 3096191
2041068.4 | 0 | 15152745
2043836.1 | 0 | 10621041
2046603.8 | 0 | 9807246
2049371.5 | 0 | 9772558
2052139.2 | 0 | 5814528
2054906.9 | 0 | 9466291
2057674.6 | 0 | 8425535
2060442.3 | 0 | 2760803
2063210 | 0 | 2644837
2065977.7 | 0 | 9578061
Spreadsheet: 815825d1675223617-consolidating-data-s666-pq-consolidating-data
Sheet: Sheet1

EXAM
NAME | OTHER* | KIDS | STUDENTS | ADULTS | SENIORS | PRICE
 | X
 |  |  |  | X
 |  |  |  | X
 |  |  |  | X
 |  |  |  |  | X
 |  |  |  |  | X
 |  |  |  |  | X
 | X
 |  |  |  | X
 |  |  |  | X
 |  |  |  |  | X
 |  |  |  | X
 |  |  |  | X
 |  |  |  |  | X
 |  |  |  | X
 |  |  | X
 |  |  |  |  | X
 |  |  |  | X
 |  |  |  |  | X
 |  |  |  |  | X
 |  |  |  |  | X
 |  |  |  | X
 |  |  |  |  | X
 |  |  |  | X
 |  |  |  |  | X
 |  |  |  | X
 |  |  |  | X
 |  |  |  |  | X
 |  |  |  |  | X
 |  |  |  | X
 |  |  |  | X
Spreadsheet: matt_motley__26376__LA_deal_sum
Sheet: LA_11-13-01

 |  | Start | End
Deal | Counter | Date | Date | Delivery | Swap Vol | Deal Vol | MTM P/L
Number | Party | MM/DD/YY | MM/DD/YY | Point | [NAME] | [NAME] | Total Mid
--------- | ------------------ | -------- | -------- | ------------------------------ | ------------ | ------------ | ------------
867350 | LOSANGELWATPOW | 2001-11-18 00:00:00 | 2002-12-31 00:00:00 | Mead-230KV | -6515 | -6608 | 3258
867350 | LOSANGELWATPOW | 2001-11-18 00:00:00 | 2002-12-31 00:00:00 | Mead-230KV | -13031 | -13216 | 6515
867350 | LOSANGELWATPOW | 2001-11-18 00:00:00 | 2002-12-31 00:00:00 | Financial Deal - SW | 6515 | 6608 | -11042
867350 | LOSANGELWATPOW | 2001-11-18 00:00:00 | 2002-12-31 00:00:00 | Financial Deal - SW | 13031 | 13216 | -44131
Spreadsheet: 07bfbe1a-dd58-4cde-af2e-bd6255b5c44b
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5952 | 45619 | [NAME] | Montenegro | BRA | 0 | 01:08:19 | 00:00:00 | [NAME] | 00:00:00 | [NAME] | 1 | 04:38:29
5952 | 9108 | [NAME] | Pimentel Júnior | BRA | 0 | [NAME] | 00:00:00 | 02:16:03 | 00:00:00 | 01:35:41 | 2 | [NAME]
5952 | 45467 | [NAME] | Picanço | BRA | 0 | 01:15:00 | 00:00:00 | 02:38:22 | 00:00:00 | 01:59:45 | 3 | 05:53:07
Spreadsheet: 765899d1643655814-find-words-with-letter-interchange-vowel-exchange-makinmomb-
Sheet: Sheet1

NOTAIRE |  | s | 1 | AEINORT
OTARINE |  |  | 2 | AEINORT
ETAERIO |  | s | 3 | AEEIORT
ANEROID |  | s | 4 | ADEINOR
AILERON | t | s | 5 | AEILNOR
ALERION |  | s | 6 | AEILNOR
ALIENOR |  | s | 7 | AEILNOR
ELATION | dgr | s | 8 | AEILNOT
TOENAIL |  | s | 9 | AEILNOT
ERASION |  | s | 10 | AEINORS
ATONIES |  |  | 11 | AEINOST
OARIEST | hr |  | 12 | AEIORST
OTARIES | [NAME] |  | 13 | AEIORST
ROASTIE |  | s | 14 | AEIORST | NEW IN CSW15
SKREIGH |  | s | 21463 | EGHIKRS
SKRIEGH |  | s | 21464 | EGHIKRS
[NAME]
TRAINEE
Spreadsheet: 08a6716d-e8ea-4445-babe-1e4e3ca313e4
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5896 | 19335 | [NAME] | Hatelt | CAN | 1009 | 00:16:59 | 00:03:53 | 00:43:38 | [NAME] | 00:44:39 | 1 | 01:54:23
5896 | 14221 | [NAME] | Wedgerfield | CAN | 1010 | 00:17:43 | [NAME] | 00:49:09 | [NAME] | 00:49:16 | 2 | 02:04:32
Spreadsheet: 41369d1239825582-advanced-sumproduct-example
Sheet: Data Sheet

Profit Center | GL Account | Account Description | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
2010 | 161000 | [NAME] | -21509.61 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -45945.89
2110 | 161000 | [NAME] | -30740.46 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -66492.1
2010 | 161200 | ACC DEP - BUILDINGS - EXP | 19441.61 | -1655 | -1655 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -21509.61
2110 | 161200 | ACC DEP - BUILDINGS - EXP | 27784.46 | -2365 | -2365 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -30740.46
Spreadsheet: 93598d1293180618-stat-sheet-taking-breaks-out-issues-help-stats
Sheet: Sheet1

 | Start Shift | 09:00:00 |  | Break 1 (15) | 10:00:00 |  | Task | Time Started | Time In Task | Code | stat req
 | End Shift | 17:00:00 |  | Lunch (30) | 12:00:00 |  | Writing Letters | 09:00:00 | 00:30:00 | WR | 03:00:00
 |  |  |  | Break 2 (15) | 14:00:00 |  | Vetting Letters | 09:30:00 | 01:10:00 | VE | 11:40:00
 |  |  |  |  |  |  | Writing Letters | 10:40:00 | 02:00:00 | WR | 12:00:00
Code | Task | Required per hour |  |  |  |  | Making Calls | 12:40:00 | 00:20:00 | MA | 02:40:00
WR | Writing Letters | 6 |  |  |  |  | Taking Calls | 13:00:00 | 01:00:00 | TA | 05:00:00
VE | Vetting Letters | 10 |  |  |  |  | Writing Letters | 14:00:00 | 01:30:00 | WR | 09:00:00
MA | Making Calls | 8 |  |  |  |  | Vetting Letters | 15:30:00 | 01:00:00 | VE | 10:00:00
TA | Taking Calls | 5 |  |  |  |  | Taking Calls | 16:30:00 | 00:30:00 | TA | 02:30:00
 | Finished |  |  |  |  |  | Finished | 17:00:00
 |  | dilemma is that to take out the breaks
 |  | from stats required I need a huge
 |  | IF statement and also if its during this and
 |  | this time then display that ammt of stats
 |  | Also as there are 4 tasks, the if statement
 |  | needs to run those 4 tasks, the time
 |  | for each task, then take off the appropriate
 |  | [NAME] of stats.
 |  | the other thing is if you say "writing letters"
 |  | from 9:00 - 13:00 then it needs to have a
 |  | if statement to add both those breaks and
 |  | take stats out accordingly for each task
 |  | same as if they do one task all day
 |  | FRUSTRATING…
Spreadsheet: 848029d1698840040-can-we-add-if-condition-in-another-column-and-get-result-in-another-column-test_1
Sheet: Sheet1

Stop |  |  |  | Question
Stop |  |  |  | add a formula in "C" column, If "A" column cells value is "Stop" then add "Ok" in the "B" Column
In
Stop |  |  |  | Expected Result-
In |  |  |  | Stop | Ok
 |  |  |  | Stop | Ok
 |  |  |  | In
 |  |  |  | Stop | Ok
 |  |  |  | In
Spreadsheet: 212355d1360101023-autopoulate-a-workbook-from-another-workbook-book-b
Sheet: Sheet1

# | Name | title | Date recorded | Type a | Type b | Type c | Type d | Type e | Type f | Type g | Priority | Area | Desctription | Who to solve | How to solve | Who really did | Due | Outstanding | Complete
1001 | Person A | Normal guy | 2011-10-21 00:00:00 |  |  |  |  |  | X |  | A | 3 | [NAME] blah | Normal guy | Clean | Person A | 2011-10-25 00:00:00 |  | 2011-10-25 00:00:00
1002 | Person B | Normal guy | 2011-10-21 00:00:00 |  |  |  |  |  | X |  | C | 3 | [NAME] | Better guy | Replace | Person B | 2011-12-21 00:00:00 |  | 2011-11-08 00:00:00
1003 | Person B | Normal guy | 2011-10-21 00:00:00 |  |  |  | X | X |  |  | C | 3 | Yakkity Schmakkitty | Normal guy | Investigate options | Person C | 2011-12-21 00:00:00 |  | 2011-10-25 00:00:00
Spreadsheet: e7b6de47-4994-4f6a-bbd9-38008e8ed539
Sheet: Balance Sheet

Netflix, Inc.
Consolidated Balance Sheets
(unaudited)
(in thousands)
 |  |  |  |  |  | As of |  |  |  | As of |  |  |  | As of
 |  |  |  |  |  | March 31, | June 30, | September 30, | December 31, | March 31, | June 30, | September 30, | December 31, | March 31,
 |  |  |  |  |  | 2010 | 2010 | 2010 | 2010 | 2011 | 2011 | 2011 | 2011 | 2012
Assets
Current assets:
 |  | Cash and cash equivalents |  |  |  | 79861 | 107327 | 113108 | 194499 | 150419 | 175207 | 159199 | 508053 | 395992
 |  | Short-term investments |  |  |  | 186469 | 171758 | 143705 | 155888 | 192302 | 201200 | 206573 | 289758 | 408534
 |  | Current content library, net |  |  |  | 55566 | 93123 | 138389 | 181006 | 265933 | 499434 | 705398 | 919709 | 1155443
 |  | Prepaid content |  |  |  | 31704 | 33837 | 59322 | 62217 | 74597 | 59811 | 77146 | 56007 | 53013
 |  | Other current assets |  |  |  | 25938 | 35173 | 37723 | 43621 | 34201 | 30287 | 41797 | 57330 | 45759
 |  |  |  |  | Total current assets
Non-current content library, net |  |  |  |  |  | 109431 | 94666 | 120047 | 180973 | 197554 | 425246 | 570210 | 1046934 | 1226274
Property and equipment, net |  |  |  |  |  | 127165 | 123292 | 125057 | 128570 | 134800 | 136948 | 143993 | 136353 | 128197
Other non-current assets |  |  |  |  |  | 32159 | 34796 | 32932 | 35293 | 40382 | 42560 | 57242 | 55052 | 67247
 |  |  |  |  | Total assets
Liabilities and Stockholders' Equity
Current liabilities:
 |  | Content liabilities |  |  |  | 69909 | 88344 | 129128 | 174791 | 241559 | 478417 | 684905 | 935036 | 1163839
 |  | Accounts payable |  |  |  | 39939 | 41246 | 46960 | 54129 | 67829 | 65583 | 73759 | 86992 | 83119
 |  | Accrued expenses |  |  |  | 35019 | 29130 | 33033 | 32476 | 37885 | 35772 | 48373 | 54231 | 49106
 |  | Deferred revenue |  |  |  | 100109 | 101419 | 102986 | 127183 | 143045 | 146937 | 160929 | 148796 | 150602
 |  |  |  |  | Total current liabilities
Long-term debt |  |  |  |  |  | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000
Long-term debt due to related party |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 200000 | 200000
Non-current content liabilities |  |  |  |  |  | 5297 | 4929 | 12933 | 48179 | 67119 | 251302 | 348182 | 739628 | 908188
Other non-current liabilities |  |  |  |  |  | 51285 | 52264 | 53268 | 55145 | 57029 | 58648 | 57058 | 61703 | 62203
 |  |  |  |  | Total liabilities
Stockholders' equity:
 | Common stock |  |  |  |  | 52 | 52 | 52 | 53 | 52 | 53 | 53 | 55 | 55
 | Additional paid-in capital |  |  |  |  | 0 | 0 | 0 | 51622 | 0 | 0 | 0 | 219119 | 243424
 | Accumulated other comprehensive income |  |  |  |  | 487 | 802 | 1279 | 750 | 590 | 884 | 588 | 706 | 1577
 | Retained earnings |  |  |  |  | 146196 | 175786 | 190644 | 237739 | 275080 | 333097 | 387711 | 422930 | 418346
 |  |  |  |  | Total stockholders' equity
 |  |  |  |  | Total liabilities and stockholders' equity