tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 28287d1222345681-vlookup-and-countif-copy-of-sales
Sheet: Sheet1

Sales Rep | Application Value | [NAME]
[NAME] | 250
[NAME] | 100 | 2008-09-01 00:00:00
[NAME] | 600 | 2008-09-05 00:00:00
[NAME] | 520 | 2008-09-06 00:00:00
[NAME] | 120 | 2008-09-05 00:00:00
[NAME] | 328 | 2008-09-09 00:00:00
[NAME] | 365 | 2008-09-08 00:00:00
[NAME] | 278 | 2008-09-03 00:00:00
[NAME] | 956 |  |  | Sum of Application Value | [NAME]
[NAME] | 756 |  |  | Sales Rep | 2008-09-01 00:00:00 | 2008-09-03 00:00:00 | 2008-09-05 00:00:00 | 2008-09-06 00:00:00 | 2008-09-08 00:00:00 | 2008-09-09 00:00:00 | Outstanding | Grand Total
[NAME] | 300 | 2008-09-01 00:00:00 |  | [NAME] |  |  |  |  | 365 |  | 250 | 615
[NAME] | 520 | 2008-09-03 00:00:00 |  | [NAME] |  | 278 | 600 |  |  |  | 956 | 1834
 |  |  |  | [NAME] |  |  | 120 |  |  |  | 756 | 876
 |  |  |  | [NAME] |  |  |  |  |  | 328 |  | 328
Exaple |  |  |  | [NAME] | 400 | 520 |  | 520 |  |  |  | 1440
 |  |  |  | Grand Total | 400 | 798 | 720 | 520 | 365 | 328 | 1962 | 5093
[NAME]'s total sales
[NAME]'s sales processed (with dates)
[NAME]'s sales not processed
Spreadsheet: 162794d1340067969-how-many-moves-to-be-adjacent-to-all-nodes-on-an-ordered-directed-tree-with-criteria-book1
Sheet: Sheet2

 | ORDER | NODE | [NAME] | # | PARENT | LEVEL |  |  |  | CRIT1 | CRIT2 | CRIT3 |  |  |  | 0 (27 root) = 0
 | 0 | root | 0 | 27 |  | 0 |  |  |  | A | 1 |  |  |  |  | 1 (28 internal) = 0
 | 1 | internal | 0 | 28 | 27 | 1 |  |  |  |  |  |  |  |  |  | 2 (29 internal) = 0
 | 2 | internal | 0 | 29 | 28 | 2 |  |  |  |  |  | Z |  |  | 2.1.1 (39 branch) = 1 |  | 2.2 (32 branch) = 1
 | 2.1.1 | branch | 1 | 39 | 29 | 3 |  |  |  | A | 0 |  |  |  | 2.1.2 (40 branch) = |  |  | 2.2.1 (635 terminal) = 2
 | 2.2 | branch | 1 | 32 | 29 | 3 |  |  |  |  |  |  |  |  | 2.1.3 (812 branch) = |  |  | 2.2.2 (33 branch) = 2
 | 3 | internal | 1 | 30 | 29 | 3 |  |  |  |  |  |  |  |  | 2.1.4 (813 terminal) = |  |  |  | 2.2.2.1 (775 terminal) = 3
 | 4 | internal | 4 | 9 | 30 | 4 |  |  |  |  |  | Z |  |  |  |  |  |  | 2.2.2.2 (34 branch) = 3
 | 2.2.1 | terminal | 2 | 635 | 32 | 4 |  |  |  | A | 0 |  |  |  |  |  |  |  |  | 2.2.2.2.1 (35 terminal) =
 | 2.2.2 | branch | 2 | 33 | 32 | 4 |  |  |  |  |  | Z |  |  |  |  |  |  |  | 2.2.2.2.2 (36 terminal) =
 | 2.1.2 | branch |  | 40 | 39 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.2.2.2.3 (37 terminal) =
 | 5 | internal | 5 | 11 | 9 | 5 |  |  |  |  |  |  |  |  |  | 3 (30 internal) = 1
 | 2.2.2.1 | terminal | 3 | 775 | 33 | 5 |  |  |  | A | 1 |  |  |  |  | 4 (9 internal) = 4
 | 2.2.2.2 | branch | 3 | 34 | 33 | 5 |  |  |  |  |  | Z |  |  |  | 5 (11 internal) = 5
 | 2.1.3 | branch |  | 812 | 40 | 5 |  |  |  |  |  |  |  |  |  |  | 5.1.1 (828 branch) = 6
 | 5.1.1 | branch | 6 | 828 | 11 | 6 |  |  |  |  |  | Z |  |  |  |  | 5.12 (829 terminal) = 7
 | 6 | internal | 6 | 12 | 11 | 6 |  |  |  |  |  |  |  |  |  | 6 (12 internal) = 6
 | 2.2.2.2.1 | terminal |  | 35 | 34 | 6 |  |  |  |  |  | Z |  |  | 6.1.1 (781 branch) = 8
 | 2.2.2.2.2 | terminal |  | 36 | 34 | 6 |  |  |  |  |  | Z |  |  | 6.1.2 (784 branch) = 9
 | 2.2.2.2.3 | terminal |  | 37 | 34 | 6 |  |  |  |  |  | Z |  |  | 6.1.3(782 branch) = 10
 | 2.1.4 | terminal |  | 813 | 812 | 6 |  |  |  |  |  |  |  |  | 6.1.4 (783 branch) = 11
 | 6.1.1 | branch | 8 | 781 | 12 | 7 |  |  |  | A | 1 |  |  |  | 6.1.5 (785 terminal) = 12
 | 7 | internal | 8 | 13 | 12 | 7 |  |  |  |  |  |  |  |  |  | 7 (13 internal) = 8
 | 5.1.2 | terminal | 7 | 829 | 828 | 7 |  |  |  |  |  |  |  |  |  | 8 (14 internal) = 14
 | 8 | internal | 14 | 14 | 13 | 8 |  |  |  |  |  |  |  |  |  | 9 (15 internal) = 15
 | 6.1.2 | branch | 9 | 784 | 781 | 8 |  |  |  |  |  |  |  |  |  | 10 (16 internal) = 16
 | 9 | internal | 15 | 15 | 14 | 9 |  |  |  |  |  |  |  |  |  |  | 10.1 (601 terminal) = 17
 | 6.1.3 | branch | 10 | 782 | 784 | 9 |  |  |  |  |  |  |  |  |  | 11 (17 internal) = 17
 | 10 | internal | 16 | 16 | 15 | 10 |  |  |  |  |  |  |  |  |  | 12 (18 internal) = 18
 | 6.1.4 | branch | 11 | 783 | 782 | 10 |  |  |  |  |  |  |  |  |  | 13 (19 final) = 19
 | 10.1 | terminal | 17 | 601 | 16 | 11 |  |  |  | A | 0
 | 11 | internal | 17 | 17 | 16 | 11
 | 6.1.5 | terminal | 12 | 785 | 783 | 11
 | 12 | internal | 18 | 18 | 17 | 12
 | 13 | final | 19 | 19 | 18 | 13
Spreadsheet: 166288d1341520758-summary-sheet-help-game-stats
Sheet: Union Park 6-30-12 

 | 1st | 2nd | 3rd | 4th | 5th | AB'S | QAB'S | QAB % | # of Innings | # of Batters | 1st Pitch Strike | Stikes | Balls | # of Pitches | Walks | [NAME] | Quality Inning | % Strikes | 1st Inning |  |  |  | 2nd Inning |  |  |  | 3rd Inning |  |  |  | 4th Inning |  |  |  | 5th Inning |  |  |  | 6th Inning
Player | HITTING |  |  |  |  |  |  |  | PITCHING |  |  |  |  |  |  |  |  |  | Pos | 7/13 | E | GP | Pos | 7/13 | E | GP | Pos | 7/13 | E | GP | Pos | 7/13 | E | GP | Pos | 7/13 | E | GP | Pos | 7/13 | E | GP | E's | GP's
Preston | 61 | 5 | 6 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  | 5 |  |  |  | 5 |  |  |  | 7
[NAME] | 2 | 1 | 61 | 2 |  |  |  |  | 1 | 3 | 1 | 8 | 6 |  | 0 | 1 | 1 |  | 7 | ✔ |  |  | 8 | ✔ |  |  | 8 | ✔ |  |  | 1 | ✔
MA | 0 | 61 | 6 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 1 | 6 |  |  |  | 6 |  |  |  | 6
Brighton | 615 | 0 | 615 |  |  |  |  |  | 0.6666666666666666 | 2 | 1 | 3 | 1 |  | 0 | 0 | 1 |  | 5 |  |  |  | 2 | ✔ |  |  | 3 | ✔ |  |  | 8
[NAME] | 4 | 61 | 72 |  |  |  |  |  | 2.333333333333333 | 9 | 4 | 18 | 15 |  | 2 | 3 | 2 |  | 1 | ✔ |  |  | 1 | ✔ |  |  | 1 |  |  |  | 2
[NAME] | 16 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  | 1
Aiden | 16 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | ✔ |  |  | 3 |  |  |  |  |  |  |  | 3
[NAME] | 61 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  | 5 | ✔
[NAME] | 2 | 65 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  |  |  |  |  | 9
Tanner K | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  | 9 | ✔
Tanner B | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  |  |  | 7
[NAME] | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  | 4 | ✔
Tyler | 0 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | ✔ |  |  |  |  |  |  |  |  |  |  | 4 | ✔
TOTALS
Date | 2012-06-30 00:00:00
Opponent | Union Park
Result | W 14-0
B.A.S.E.2 CHECKLIST
 | B. | A. | S. | E. | 2 | TOTAL
 | 1 |  | 1 | 1
"Team Goal Oriented"
QUALITY AT BATS
1. Hit Ball Hard
2. Walk
3. Hit By Pitch
4. Move Runners with ≤ 1 Out
5. Score [NAME] from 3rd with < [NAME]
6. Base Hit
7. Six Pitch AB Not Ending in Strikeout
8. Nine Pitch AB Even Ending in Strikeout
9. Catcher Interference
Spreadsheet: f21fc503-87a4-493e-9ab1-73cd0ff23cb2
Sheet: Sheet1

2209 609 Dabas–Ócsa–Felsőpakony–Gyál | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
(Érvényes: 2011. december 11-től)
 |  |  |  |  | 641 | 641 | 609
Km | Km | Km | Km | VOLÁNBUSZ Zrt. | 2 | 4 | 2
 |  |  |  |  | I | I | I
0 | .. | .. | .. | Dabas, gimnázium | 06:49:00 |  | 14:45:00
1 | .. | .. | .. | Dabas, Martinovics tér | S |  | 14:47:00
2.4 | .. | .. | .. | Dabas, [NAME]. Szki. | S |  | 14:50:00
5.7 | .. | .. | .. | Dabas, Sári okmányhivatal | 07:01:00 | [NAME] | 14:55:00
6.1 | .. | .. | .. | Dabas, Sári iskola |  |  | 14:56:00
16.9 | .. | .. | .. | Ócsa, kh. | [NAME] | 13:51:00 | 15:09:00
17.2 | .. | .. | .. | Ócsa, [NAME] templom | [NAME] | 13:52:00 | 15:11:00
17.8 | .. | .. | .. | Ócsa, Bolyai J. Gimnázium | 07:19:00 | 13:53:00 | 15:12:00
18.2 | .. | .. | .. | Ócsa, vá. | 07:20:00 | 13:55:00 | 15:14:00
19.6 | .. | .. | .. | Ócsa, Martinovics u. 2. |  |  | 15:16:00
19.9 | .. | .. | .. | Ócsa, [NAME] |  |  | 15:17:00
24 | .. | .. | .. | [NAME]. |  |  | 15:21:00
30.8 | .. | 0 | .. | Felsőpakony, elág.
S | .. | 2.1 | .. | Felsőpakony, óvoda |  |  | 15:35:00
S | .. | 2.7 | .. | Felsőpakony, aut. ford. |  |  | 15:37:00
S | .. | 2.1 | .. | Felsőpakony, óvoda |  |  | 15:39:00
30.8 | .. | 0 | .. | Felsőpakony, elág.
34.8 | .. | .. | .. | Gyál, [NAME] |  |  | 15:48:00
35.4 | .. | .. | .. | Gyál, [NAME]
35.8 | .. | .. | .. | Gyál, Ady E. u. |  |  | 15:51:00
36.3 | .. | .. | .. | Gyál, Rákóczi u. |  |  | 15:53:00
36.7 | .. | .. | .. | Gyál, Széchenyi u. |  |  | 15:54:00
37.1 | .. | .. | .. | Gyál, [NAME]
37.7 | .. | .. | .. | Gyál, [NAME] u. |  |  | 15:57:00
38.1 | .. | .. | .. | Gyál, Vecsési út |  |  | 15:58:00
38.4 | .. | .. | .. | Gyál, [NAME] |  |  | 15:59:00
38.8 | .. | .. | .. | Gyál, Nagykőrösi út |  |  | 16:00:00
[NAME]:
I | tanítási napokon
 | a járat érinti a megállóhelyet, de nem áll meg
S | a járat nem érinti a megállóhelyet, [NAME]
Spreadsheet: 146812d1332358513-vlookup-and-choose-excel-forum-test
Sheet: Sheet2

 | jan | feb | [NAME] | apr | may | jun | jul | aug | sep | oct | nov | dec
1234567891011 | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100 | 110 | 120
1234567891012 | 20 | 40 | 60 | 80 | 100 | 120 | 140 | 160 | 180 | 200 | 220 | 240
1234567891013 | 30 | 60 | 90 | 120 | 150 | 180 | 210 | 240 | 270 | 300 | 330 | 360
1234567891014 | 40 | 80 | 120 | 160 | 200 | 240 | 280 | 320 | 360 | 400 | 440 | 480
1234567891015 | 50 | 100 | 150 | 200 | 250 | 300 | 350 | 400 | 450 | 500 | 550 | 600
1234567891016 | 60 | 120 | 180 | 240 | 300 | 360 | 420 | 480 | 540 | 600 | 660 | 720
1234567891017 | 70 | 140 | 210 | 280 | 350 | 420 | 490 | 560 | 630 | 700 | 770 | 840
1234567891018 | 80 | 160 | 240 | 320 | 400 | 480 | 560 | 640 | 720 | 800 | 880 | 960
1234567891019 | 90 | 180 | 270 | 360 | 450 | 540 | 630 | 720 | 810 | 900 | 990 | 1080
1234567891020 | 100 | 200 | 300 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200
1234567891021 | 110 | 220 | 330 | 440 | 550 | 660 | 770 | 880 | 990 | 1100 | 1210 | 1320
1234567891022 | 120 | 240 | 360 | 480 | 600 | 720 | 840 | 960 | 1080 | 1200 | 1320 | 1440
1234567891023 | 130 | 260 | 390 | 520 | 650 | 780 | 910 | 1040 | 1170 | 1300 | 1430 | 1560
1234567891024 | 140 | 280 | 420 | 560 | 700 | 840 | 980 | 1120 | 1260 | 1400 | 1540 | 1680
1234567891025 | 150 | 300 | 450 | 600 | 750 | 900 | 1050 | 1200 | 1350 | 1500 | 1650 | 1800
1234567891026 | 160 | 320 | 480 | 640 | 800 | 960 | 1120 | 1280 | 1440 | 1600 | 1760 | 1920
Spreadsheet: f62b2917-47dd-4831-8fe3-30b5c1ec8117
Sheet: Sheet1

The NASDAQ OMX Group, Inc. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Condensed Consolidated Statements of Income
(in millions, except per share amounts)
(unaudited)
 |  | Three Months Ended
 |  |  |  |  |  |  |  | Pro Forma
 |  | September 30, |  | June 30, |  | September 30, |  | September 30,
 |  | 2009 |  | 2009 |  | 2008 |  | 2008
Revenues
Market Services revenues |  | 691 |  | 768 |  | 869 |  | 882
Cost of revenues:
Liquidity rebates |  | -329 |  | -381 |  | -484 |  | -485
Brokerage, clearance and exchange fees |  | -132 |  | -141 |  | -107 |  | -107
Total cost of revenues |  | -461 |  | -522 |  | -591 |  | -592
Total Market Services revenues less liquidity rebates,
brokerage, clearance and exchange fees |  | 230 |  | 246 |  | 278 |  | 290
Issuer Services revenues |  | 80 |  | 82 |  | 89 |  | 89
Market Technology revenues |  | 36 |  | 36 |  | 29 |  | 29
Other revenues |  | 3 |  | 3 |  | 3 |  | 3
Total revenues less liquidity rebates, brokerage,
clearance and exchange fees |  | 349 |  | 367 |  | 399 |  | 411
Operating Expenses
Compensation and benefits |  | 99 |  | 105 |  | 106 |  | 110
Marketing and advertising |  | 3 |  | 3 |  | 7 |  | 7
Depreciation and amortization |  | 27 |  | 27 |  | 28 |  | 30
Professional and contract services |  | 20 |  | 17 |  | 17 |  | 17
Computer operations and data communications |  | 14 |  | 14 |  | 16 |  | 17
Occupancy |  | 19 |  | 18 |  | 19 |  | 19
Regulatory |  | 10 |  | 10 |  | 7 |  | 7
Merger expenses |  | 5 |  | 3 |  | 9 |  | 9
General, administrative and other |  | 21 |  | 11 |  | 18 |  | 19
Total operating expenses |  | 218 |  | 208 |  | 227 |  | 235
Operating income |  | 131 |  | 159 |  | 172 |  | 176
Interest income |  | 3 |  | 2 |  | 9 |  | 9
Interest expense |  | -26 |  | -25 |  | -29 |  | -32
Dividend and investment income |  | 1 |  | 1 |  | 2 |  | 2
Debt conversion expense |  | -25 |  | 0 |  | 0 |  | 0
Loss from unconsolidated investees, net |  | 0 |  | -18 |  | 0 |  | 0
Loss on foreign currency contracts, net |  | 0 |  | 0 |  | -51 |  | -51
Loss on sale of investment security |  | 0 |  | -5 |  | 0 |  | 0
Asset impairment charges |  | 0 |  | 0 |  | -7 |  | -7
Income before income taxes |  | 84 |  | 114 |  | 96 |  | 97
Income tax provision |  | 25 |  | 46 |  | 38 |  | 38
Net income |  | 59 |  | 68 |  | 58 |  | 59
Net expense attributable to noncontrolling interests |  | 1 |  | 1 |  | 0 |  | 0
Net income attributable to NASDAQ OMX |  | 60 |  | 69 |  | 58 |  | 59
Basic and diluted earnings per share:
Basic |  | 0.3 |  | 0.34 |  | 0.29 |  | 0.29
Diluted |  | 0.28 |  | 0.33 |  | 0.27 |  | 0.28
Weighted-average common shares outstanding
for earnings per share:
Basic |  | 203 |  | 202 |  | 200 |  | 200
Diluted |  | 215 |  | 214 |  | 214 |  | 214
(1)
Spreadsheet: 167928d1342160204-ranking-problems-2012-2-kimbap-hoping
Sheet: Student info

 | Class number | é | 1 |  |  | Student Information |  |  |  |  |  |  |  |  |  |  |  |  |  | ✂                                       ✂
 |  |  |  | No. |  | 학부 (Dept) | 학년 (Year) | 학번 (I.D.) | 이름 (name) | 소속학과 (?) | E-Mail | 전화번호 | 수강상태 (?) |  | 학본                    (Student number) |  | English name
 |  |  |  |  |  |  | 1 |  | lik
 |  |  |  | 2 |  | 제약공학과 | 1 | sunshinekate | 김기화 | 제약공학과 | [EMAIL] | 010-6251-4110 | 수강중 |  | 2 |  | b
 |  |  |  | 3 |  | 영어학과 | 3 | nornor1027 | 김성엽 | 영어학과 | [EMAIL] | 010-7553-6223 | 수강중 |  | 3 |  | c
 |  |  |  | 4 |  | 시각디자인학과 | 1 | ksy931203 | 김수연 | 시각디자인학과 | [EMAIL] | 010-6412-2065 | 수강중 |  | 4 |  | d
 |  |  |  | 5 |  | 신소재공학과 | 1 | asdfyo | 김영훈 | 신소재공학과 | [EMAIL] | 010-8996-9320 | 수강중 |  | 5 |  | e
 |  |  |  | 6
 |  |  |  | 7 |  | 신소재공학과 | 1 | ktm1397 | 김태민 | 신소재공학과 | [EMAIL] | 010-3364-6763 | 수강중 |  |  |  | g
 |  |  |  | 8 |  | 기초과학부 | 1 | rampb78 | 박은민 | 기초과학부 | [EMAIL] | 010-3179-4278 | 수강중 |  |  |  | h
 |  |  |  | 9 |  | 제약공학과 | 1 | jihye1415 | 박지혜 | 제약공학과 | [EMAIL] | 010-4613-7021 | 수강중 |  |  |  | i
 |  |  |  | 10 |  | 제약공학과 | 1 | dnlwogml93 | 위재희 | 제약공학과 | [EMAIL] | 010-3606-7583 | 수강중 |  |  |  | j
 |  |  |  | 11 |  | 시각디자인학과 | 1 | thdus314 | [NAME] | 시각디자인학과 | [EMAIL] | 010-3008-5061 | 수강중 |  |  |  | k
 |  |  |  | 12 |  | 제약공학과 | 1 | kain832 | 이우행 | 제약공학과 | [EMAIL] | 010-2997-9312 | 수강중 |  |  |  | l
 |  |  |  | 13
 |  |  |  | 14 |  | 시각디자인학과 | 1 | ekrcy99 | 최민지 | 시각디자인학과 | [EMAIL] | 010-3944-5117 | 수강중 |  |  |  | n
 |  |  |  | 15 |  | 역사학과 | 1 | [NAME] | 최서영 | 역사학과 | [EMAIL] | 010-5434-9022 | 수강중 |  |  |  | o
 |  |  |  | 16 |  | 사회복지학과 | 1 | cic2093 | 최소은 | 사회복지학과 | [EMAIL] | 010-8211-2093 | 수강중 |  |  |  | p
 |  |  |  | 17 |  | 간호학과 | 1 | [NAME] | 최원진 | 간호학과 | [EMAIL] | 010-7659-3007 | 수강중 |  |  |  | q
 |  |  |  | 18 |  | 시각디자인학과 | 1 | houng1993 | 홍주리 | 시각디자인학과 | [EMAIL] | 010-8879-0281 | 수강중 |  |  |  | r
 |  |  |  | 19
 |  |  |  | 20
 |  |  |  |  |  | é | é | é | é | é | é | é | é |  | é |  | é
 |  | é |  |  |  | to get this information: |  |  |  |  |  |  |  |  | to get this information: |  | Type in manually
 |  | é
 |  | é |  |  |  | 1. lms.sunmoon.ac.kr |  |  |  |  |  |  |  |  | 1.  lms.sunmoon.ac.kr
 |  | é |  |  |  | 2. Choose a class number then 수강생관리 (11th menu option) |  |  |  |  |  |  |  |  | 2. to be completed
 |  | é |  |  |  | 3. 엑셀다운 |  |  |  |  |  |  |  |  | 3
 |  | é |  |  |  | 4. Copy and paste ('values' only) |  |  |  |  |  |  |  |  | 4
 |  | é
 | Check the online attendance webpage to see who has unregistered.  Remove their data from this worksheet (do not delete the row). Otherwise, the averages in the Final Grades and Averages worksheets will be incorrect.  Please also remove test, participation, and homework scores.   However, make sure there are at least 10 "1's" on the attendance worksheet to take the score down to "0".
Spreadsheet: 97fdc932-fcbd-4320-97d0-2dab2061e320
Sheet: Page 10

DIVISION OF WATER RESOURCES TAX CERTIFICATION & EXEMPTION APPLICATION |  |  |  |  |  |  |  |  |  | PAGE 10
Waste Treatment Systems & Equipment:  Waste treatment systems & equipment must be used exclusively for the abatement of water pollution |  |  |  |  |  |  |  |  |  | Rev 09/01/2013
For County Use Only |  | For DWR Use Only "A" Approved "D" Disapproved | Description of Waste Treatment Systems or Equipment | Was asset listed in the permit (Yes/No)           * | Asset Number, Vehicle Identification Number (VIN) | How is this equipment used for pollution abatement? | % of Use for Pollution Abatement | Year of Acquisition | Original Historical Cost** | Is this asset replacing a prior asset?
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
Attach additional pages if necessary
*   If the asset is listed in the DWR permit, the description must be identical as listed on the current permit.  If the asset is not specifically listed in the DWR permit, the applicant must attach detailed information as to why the asset should qualify for Tax Certification.
** When certifying systems or equipment, DENR is not certifying the cost of the equipment or the year of acquisition.
Applicant |  |  |  |  | Title: |  |  | Date:
Signature |  |  |  |  | Of:
 |  |  | (print name also) |  |  | (Name of Applicant Business Entity)                                                                                                                                                             TC-WQ
NOTICE:  The penalty for false statement, representation or certification                              herein includes imprisonnment and/or the assessment of civil penalties.
Spreadsheet: 77405d1277897276-removing-paranthesis-from-text-in-a-cell-formatting
Sheet: Sheet1

Gold | 10 Gm | 9520 (8900) | 9609 (9094) | 7873 (10012) | 8636 (10715) | 3785 (36587) | 3877 (37213) | 365.23 (3289.98) | 374.22 (3346.88) | 465450 | 43428.48
Silver | 1 Kg | 20198 (19700) | 19786 (20148) | 76740 (352470) | 255540 (423960) | 178440 (1935360) | 360030 (2028900) | 357.72 (3859.66) | 739.21 (4048.50) | 21181350 | 42759.63
Copper | 1 Kg | 330.70 (281.20) | 326.75 (292.80) | 7263 (5405) | 7756 (9049) | 655 (8932) | 688 (13847) | 21.45 (261.00) | 22.54 (406.10) | 177197 | 5547.04
Zinc | 1 Kg | 145.20 (139.65) | 152.70 (162.00) | 8575 (3780) | 9670 (6315) | 1025 (9025) | 1250 (17445) | 15.70 (141.52) | 19.20 (279.99) | 210555 | 3333.09
Crude oil | Barrel | 3232 (3140) | 3239 (3241) | 75961.80 (61023.19) | 84774.8 9 (68021.8 2) | 4556.61 (129140.51) | 6057.29 (134447.4 7) | 10.84 (305.20) | 14.51 (317.92) | 1300818.55 | 3147.73
Soy Oil | 10 Kg | 415.40 (400.10) | 422.45 (409.70) | 14400 (20400) | 24750 (23700) | 19270 (31350) | 29620 (33170) | 81.47 (128.20) | 126.43 (135.72) | 315280 | 1305.24
Urad | 100 Kg | 3200 (3261) | 3152 (3278) | 4440 (1950) | 15220 (19800) | 790 (2480) | 1340 (43710) | 2.49 (7.87) | 4.18 (136.34) | 308660 | 951.26
Spreadsheet: f7af6f06-d2fe-4da2-baf6-b78a114c71ca
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
43053298 | 2014-09-07 04:45:40 | AXIS | 1 | 6 | 4 | 1383343 | papouduck | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
43053528 | 2014-09-07 05:07:45 | ALLIES | 1 | 6 | 3 | 1383343 | papouduck | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
43206713 | 2014-09-18 05:35:44 | AXIS | 0 | 1 | 5 | 1630836 | OneEyedMonkey | 6156 | western | 1944-09-17 | 1944-09-19 | [NAME] | [NAME]
43218925 | 2014-09-19 04:27:57 | AXIS | 1 | 6 | 2 | 1636296 | player1636296 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
Spreadsheet: 122877d1317220869-calc-median-over-a-date-range-median_values_of_date_range
Sheet: Raw_Data

Month Reported | Year | Date Score Card Review Completed | Overall Percent
May | 2010 | 2010-04-12 00:00:00 | 0.8857142857142857
May | 2010 | 2010-05-10 00:00:00 | 0.9117647058823529
May | 2010 | 2010-05-10 00:00:00 | 0.8823529411764706
May | 2010 | 2010-05-11 00:00:00 | 0.7941176470588235
May | 2010 | 2010-05-12 00:00:00 | 0.9411764705882353
May | 2010 | 2010-05-12 00:00:00 | 0.8823529411764706
May | 2010 | 2010-05-13 00:00:00 | 0.9411764705882353
May | 2010 | 2010-05-18 00:00:00 | 0.9411764705882353
May | 2010 | 2010-05-25 00:00:00 | 0.7352941176470589
May | 2010 | 2010-05-27 00:00:00 | 0.8235294117647058
July | 2010 | 2010-07-22 00:00:00 | 0.9117647058823529
July | 2010 | 2010-07-29 00:00:00 | 0.9705882352941176
July | 2010 | 2010-08-03 00:00:00 | 1
July | 2010 | 2010-08-17 00:00:00 | 0.7058823529411765
Aug | 2010 | 2010-08-24 00:00:00 | 0.9411764705882353
Aug | 2010 | 2010-08-31 00:00:00 | 0.9705882352941176
Aug | 2010 | 2010-08-31 00:00:00 | 0.9117647058823529
Oct | 2010 | 2010-10-25 00:00:00 | 0.9117647058823529
Oct | 2010 | 2010-10-25 00:00:00 | 0.8529411764705882
Oct | 2010 | 2010-11-10 00:00:00 | 0.2352941176470588
Nov | 2010 | 2010-11-30 00:00:00 | 0.8529411764705882
Nov | 2010 | 2010-12-02 00:00:00 | 0.9705882352941176
Dec | 2010 | 2010-12-21 00:00:00 | 0.8823529411764706
Nov | 2010 | 2010-12-22 00:00:00 | 0.9852941176470589
Dec | 2010 | 2011-01-11 00:00:00 | 1
Apr | 2011 | 2011-04-14 00:00:00 | 0.9558823529411765
Apr | 2011 | 2011-04-26 00:00:00 | 0.8676470588235294
Apr | 2011 | 2011-04-28 00:00:00 | 0.8823529411764706
May | 2011 | 2011-05-19 00:00:00 | 0.9411764705882353
May | 2011 | 2011-05-19 00:00:00 | 0.9117647058823529
May | 2011 | 2011-05-20 00:00:00 | 0.9117647058823529
June | 2011 | 2011-06-17 00:00:00 | 0.9852941176470589
June | 2011 | 2011-06-21 00:00:00 | 1
June | 2011 | 2011-06-22 00:00:00 | 1
July | 2011 | 2011-07-22 00:00:00 | 0.9852941176470589
July | 2011 | 2011-07-22 00:00:00 | 0.9558823529411765
July | 2011 | 2011-07-25 00:00:00 | 0.9338235294117647
August | 2011 | 2011-08-24 00:00:00 | 1
August | 2011 | 2011-08-26 00:00:00 | 0.9632352941176471
August | 2011 | 2011-08-29 00:00:00 | 0.9852941176470589
Spreadsheet: 769795d1645689845-array-formula-for-multiple-savings-multiply
Sheet: Sheet1

 | Startvalue | 100
 | 1 |  | 2 |  | array formula for this yellow area needed.
 | 2 |  | 2
 | 3 |  | 2 |  |  | 100 | My try, start value is fixed
 |  |  |  |  |  |  |  |  |  | 98
 |  |  |  |  |  | 98 |  |  |  | 96.03999999999999
 |  |  |  |  |  | 98 |  |  |  | 94.11919999999999
Spreadsheet: 55526d1255629503-formula-to-count-multiple-ifs-and-take-an-average-703475_sam_d
Sheet: Sheet2

Month | EPC | Submission Lag Time | Overal Company Lag Time | Lag Time Per Rejection | Internal Process Time
2009-05-01 00:00:00 | Company A | 0
 | Company B | 6
 | Company C | 0
2009-06-01 00:00:00 | Company A | 13
 | Company B | 0
 | Company C | 8.5
2009-07-01 00:00:00 | Company A | 10.90909090909091
 | Company B | 4
 | Company C | 4.444444444444445
2009-08-01 00:00:00 | Company A | 1.5
 | Company B | 0
 | Company C | 0
2009-09-01 00:00:00 | Company A | 12
 | Company B | 0
 | Company C | 0
2009-10-01 00:00:00 | Company A | 0
 | Company B | 0
 | Company C | 0
2009-11-01 00:00:00 | Company A | 0
 | Company B | 0
 | Company C | 0
2009-12-01 00:00:00 | Company A | 0
 | Company B | 0
 | Company C | 0
Spreadsheet: 879655d1727213493-shared-return-based-on-hours-worked-server-tokes-example-001
Sheet: BEVERAGE SERVER

 | REVENUE SALES
 | TOTAL REVENUE : |  |  |  |  |  |  |  | 222.05
 | (OTHER): |  |  |  |  |  |  |  | 0
 | SALES (TOTAL REVENUE LESS OTHER):
 | BARTENDER TOKE OUT
 | NAME/EMP # |  |  |  | HRS WORKED |  |  |  | TOKE OUT
 |  |  |  |  | 4 |  |  |  |  |  |  | All amounts here should add up the toke out below.
 |  |  |  |  | 4 |  |  |  |  |  |  | It is based on 10 % of sales from J15
 |  |  |  |  |  |  |  |  |  |  |  | Most of the time it is fine, but in cases like this, the toke out is off a penny.
 | TOKE OUT (10% SALES):
 | [NAME]
 | TOTAL TOKES: |  |  |  |  |  |  |  | 271.95
 | TOKE OUT:
 | HELD (PAYROLL): |  |  |  |  |  |  |  | 0
 | TOKES TAKEN HOME:
 | PAID IN: