tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 120550d1315368214-comparing-data-in-2-tabs-data-comparison-1-
Sheet: Sheet1

Contract # | TYPE | AMOUNT
BD00001958 | 32768 | 1200
BD00002138 | 49152 | 70
BD00002138 | 65536 | 300
BD00002138 | 81920 | 300
BD00002288 | 49152 | 70
BD00002288 | 65536 | 280
BD00002289 | 49152 | 70
BD00002289 | 65536 | 280
BD00002487 | 32768 | 280
BD00002489 | 32768 | 140
BD00002489 | 49152 | 70
BD00002489 | 65536 | 280
BD00002637 | 32768 | 320
BD00002681 | 32768 | 600
BD00003051 | 32768 | 1360
BD00000079 | 65536 | 1350
BD00000079 | 81920 | 0
BD00000079 | 98304 | 864
BD00001929 | 32768 | 840
BD00001929 | 49152 | 480
BD00001960 | 32768 | 150
BD00001960 | 49152 | 840
BD00002025 | 32768 | 480
BD00002768 | 32768 | 150
BD00002768 | 49152 | 900
BD00002887 | 32768 | 1500
BD00002887 | 49152 | 0
BD00002887 | 65536 | 960
BD00003027 | 32768 | 960
BD00003027 | 49152 | 540
BD00000851 | 32768 | 4080
BD00000851 | 49152 | 3000
BD00000851 | 65536 | 0
BD00000851 | 81920 | 2799.84
BD00000866 | 32768 | 5040
BD00000962 | 49152 | 420
BD00000962 | 65536 | 210
BD00001047 | 32768 | 1920
BD00001096 | 32768 | 1920
BD00001126 | 32768 | 420
BD00001126 | 49152 | 210
BD00001230 | 65536 | 1710
BD00001230 | 81920 | 798
BD00001230 | 98304 | 399
BD00001230 | 114688 | 0
BD00001230 | 131072 | 1368
BD00001230 | 147456 | 1140
BD00001230 | 163840 | 664.92
BD00001230 | 180224 | 798
BD00001278 | 32768 | 420
Spreadsheet: craig_dean__4353__10_26act
Sheet: EPEData

 | 37286.40208333333
 | NEWMAN 1 ,ECON, 42  , 75  , 35  , 83  , 36  ,1
 | NEWMAN 2 ,ECON, 40  , 77  , 34  , 83  , 39  ,1
 | NEWMAN 3 ,ECON, 68  ,100  , 35  ,103  , 33  ,1
 | NEWMN/GT1,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,UNAV,  0  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,UNAV,  0  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,MANL, 78  ,215  , 86  ,214  ,  0  ,1
 | NEWMAN   ,, 227 ,  467,  190, 483 , 108 ,
 | COPPER   ,[NAME], -0  , 69  , 15  , 69  ,  0  ,1
 | RIOGRAN 6,UNAV,  0  , 47  , 29  , 48  ,  0  ,1
 | RIOGRAN 7,UNAV,  0  , 38  , 32  , 49  ,  0  ,1
 | RIOGRAN 8,MANL, 58  ,100  , 50  ,151  ,  0  ,1
 | RIOGRANDE,,  58 ,  100,   50, 151 ,   0 ,
 | PALOVERDE,MANL,192  ,192  ,192  ,600  ,  0  ,1
 | FOURCRNRS,MANL, 97  , 97  , 97  ,104  ,  0  ,1
 | LAMBDA, 14.25,  640,  640,  227,   -3,    0,14048,4
 | APS     ,STRT    ,FC,  ,   1,   1
 | IID     ,EXCS    ,FC,  ,  50,  50
 | IID     ,FIRM    ,PV,  , 100, 100
 | LDWP    ,ECON    ,PV,  ,  80,  80
 | PGT     ,LOSS    ,PV,  ,  -1,  -1
 | PNM     ,CNTG    ,LC,  ,  11,  11
 | PNM     ,LOSS    ,LC,  ,   2,   2
 | SPS     ,FIRM    ,WM,  ,-103,-103
 | SRP     ,FIRM    ,ED,  ,  25,  25
 | SRP     ,LOSS    ,PV,  ,   1,   1
 | TNP     ,FIRM    ,PV,  ,  25,  25
 | TNP     ,LOSS    ,PV,  ,  -5,  -5
 | WAPA    ,PASS    ,WM,HO,  -1,  -1
Spreadsheet: 85081d1285153273-count-instances-of-a-value-across-multiple-sheets-book1
Sheet: Linc 123

Product | Type | Key
a | 1 | JHYU918-9187-088
b | 2 | JHYU918-9187-088
c | 3 | JHYU414-234H-876
d | 4 | JHYU414-234H-877
a | 1 | JHYU414-234H-878
b | 2 | JHYU414-234H-879
c | 3 | JHYU414-234H-880
d | 4 | JHYU414-234H-881
a | 5 | JHYU414-234H-882
b | 6 | JHYU414-234H-883
c | 7 | JHYU414-234H-884
d | 8 | JHYU414-234H-885
a | 9 | JHYU414-234H-886
b | 10 | JHYU414-234H-887
c | 11 | JHYU414-234H-888
d | 12 | JHYU918-9187-088
a | 13 | JHYU918-9187-088
c | 11 | JHYU414-234H-876
Spreadsheet: 772749d1647451557-task-list-to-auto-populate-into-a-calendar-with-12-entries-bi-weekly-calendar_multi_lookup
Sheet: Activities

Ref | Date | Activity
 | 2021-01-01 00:00:00 | Project start |  | [NAME] in column A already copied down to A1000 - copy further as required
 | 2021-01-05 00:00:00 | Identify site
 | 2021-01-05 00:00:00 | Enter in database
 | 2021-01-03 00:00:00 | Contact project leader
 | 2021-02-15 00:00:00 | Sign lease
 | 2021-01-03 00:00:00 | Organise temporary phones |  | Some test data - replace with your own
 | 2021-01-03 00:00:00 | Arrange offices |  | Some test data - replace with your own
 | 2021-01-04 00:00:00 | Assemble team |  | Some test data - replace with your own
 | 2021-01-03 00:00:00 | Contact utilities |  | Some test data - replace with your own
 | 2021-09-17 00:00:00 | [NAME]
Spreadsheet: 274736d1383211679-return-a-value-in-a-second-table-for-more-cells-after-a-lookup-value-excel
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Status
JOB1 | 2013-10-23 00:00:00 | Process Engineer | Allstates Technical Services, Inc. | Houston, TX | AN | 2013-10-23 00:00:00 |  |  | [NAME] |  | Submitted |  | JOB1
 |  |  |  |  | RZ | 2013-10-23 00:00:00 |  |  |  |  | [NAME]:Already sent
[NAME] | 2013-10-23 00:00:00 | Senior Pressure Vessel Engineer | Jacobs | Houston, TX | ZW | 2013-10-23 00:00:00 |  |  | [NAME] |  | Submitted
 |  |  |  |  | <> Submitted | Submitted
JOB1 |  |  |  |  | 1 | 1
[NAME] |  |  |  |  | 1 | 1
Spreadsheet: 49156d1248394254-help-on-pivottable-hamburglar
Sheet: Data

Opportunity Name | Stage | Competitor 1 | Competitor 2 | Competitor 3
Hamburglar | Won | Arby's | Burger King | White Castle
[NAME] | Lost | McDonald's | [NAME]'s Jr.
Mustard | Won | Burger King
Pickles | Won | [NAME]'s Jr. | Arby's
Spreadsheet: 767952d1644754534-problem-in-countifs-with-date-field-criteria-trade-log-sample
Sheet: Monthly Summary

Day | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00
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
Total
Total Trades |  | 28
Profit Trades
%
[NAME]
%
[NAME] in Points
[NAME] in Points
Spreadsheet: 852294d1702384534-bring-projects-based-on-conditions-exc
Sheet: Sheet5

year | mionth | Comanda / firma leasing | Nume si prenume | Functie | Norma lucru | SPV | projects
2022 | 1 | Smartree Romania - Telekom Bacau | [NAME] Mihaela | Operator [NAME] prin telefon | 4 | [NAME] | Enel
2022 | 2 | Smartree Romania - Telekom Bacau | [NAME] Mihaela | Operator [NAME] prin telefon | 6 | [NAME] | Enel
2022 | 3 | Smartree Romania - Telekom Bacau | Cristea Bianca Petronela | Agent Servicii Client | 4 | [NAME] | Enel
2023 | 4 | Smartree Romania - Telekom Bacau | Balauru [NAME] | Agent Servicii Client | 8 | [NAME] | Enel
Spreadsheet: 54122d1254151635-updating-a-league-table-from-a-master-spreadsheet-britsnwhelp
Sheet: Master report

14 | [NAME] | Scotland & Northern Ireland
5 | Una O'Kane | Merseyside
4 | [NAME] | West Lancashire
4 | [NAME] | South Lancashire
4 | [NAME] | West Lancashire
4 | [NAME] | Scotland & Northern Ireland
4 | Debbie Clayton-Prie | South Manchester
3 | [NAME] | East Lancashire
3 | [NAME] Thorpe | West Yorkshire
3 | Nicola Manley | Merseyside
3 | [NAME] | East Lancashire
3 | [NAME] | Merseyside
3 | [NAME] | Merseyside
3 | [NAME] | North West, S & Ni Rural Team
2 | [NAME] | West Lancashire
2 | [NAME] | East Lancashire
2 | [NAME] | West Lancashire
2 | [NAME] | South Manchester
2 | [NAME] | Merseyside
2 | Nicola Hayes | West Yorkshire
2 | [NAME] | East Lancashire
2 | Nadim Najib | West Yorkshire
2 | [NAME] | East Lancashire
2 | [NAME] | North West, S & Ni Rural Team
2 | [NAME] | North Manchester
2 | [NAME] | South Lancashire
2 | [NAME] | North Manchester
2 | [NAME] | South Manchester
2 | [NAME] | West Lancashire
2 | [NAME] | Merseyside
2 | [NAME] | Merseyside
2 | [NAME] | West Yorkshire
2 | [NAME] | Cumbria
1 | [NAME] | Cumbria
1 | [NAME] | South Manchester
1 | [NAME] | West Yorkshire
1 | [NAME] | Merseyside
1 | [NAME] | South Manchester
1 | [NAME] | South Lancashire
1 | [NAME] | North Manchester
1 | [NAME] | South Lancashire
1 | [NAME] | West Yorkshire
1 | [NAME] | West Lancashire
1 | [NAME] | Cumbria
1 | [NAME] | North Manchester
1 | [NAME] | East Lancashire
1 | [NAME] | Merseyside
1 | [NAME] | Cumbria
1 | [NAME] | North Manchester
1 | [NAME] | East Lancashire
1 | [NAME] | South Manchester
1 | [NAME] | South Lancashire
1 | [NAME] | North West, S & Ni Rural Team
1 | [NAME] | South Lancashire
1 | [NAME] | West Yorkshire
1 | [NAME] | North Manchester
1 | [NAME] | West Lancashire
1 | [NAME] | Cumbria
1 | [NAME] | North Manchester
1 | [NAME] | West Lancashire
1 | [NAME] | South Lancashire
1 | [NAME] | Merseyside
1 | [NAME] | East Lancashire
1 | [NAME] | West Lancashire
1 | [NAME] | Cumbria
1 | [NAME] | South Manchester
Spreadsheet: 59253d1259752144-combining-several-columns-of-data-example
Sheet: Sheet 1

What I have
 | A | A |  | B | B |  | C | C
ID | Used | Free | ID | Used | Free | ID | Used | Free
Example 1 | 0 | 1 | Example 1 | 1 | 0 | Example 1 | 1 | 0
Example 2 | 11 | 21 | Example 2 | 1 | 0 | Example3 | 1 | 0
Example 4 | 1 | 2 |  |  |  | Example 4 | 3 | 3
What I would Like
 | A | A | B | B | C | C
ID | Used | Free | Used | Free | Used | Free
Example 1 | 0 | 1 | 1 | 0 | 1 | 0
Example 2 | 11 | 21 | 1 | 0
Example3 |  |  |  |  | 1 | 0
Example 4 | 1 | 2 |  |  | 3 | 3
Spreadsheet: larry_campbell__21028__PTE Calcs
Sheet: Tanks

TANK EMISSIONS
 |  |  | Annual | Maximum | Working | Standing | Annual | [NAME] | Ozone
 |  |  | Throughput | [NAME] | Losses | Losses | Emissions | Emissions | Emissions
Tank ID | Contents | Capacity (gals) | (gal/yr) | (gals/hr) | (lb/yr) | (lb/yr) | (tpy) | (lb/hr) | (lb/day)
TANK-1 | Condensate | 500 |  | 2500 | 8.4 | 50.95
TOTAL
Notes:
1. Maximum fill rate is conservatively estimated.
2. Maximum hourly emission rate estimated as: (working losses)*(hourly throughput)/(annual throughput) + (standing losses/8760)
3. Ozone emissions (lb/day) based on annualized emissions (tpy).
4. Annual throughput conservatively estimated.
Spreadsheet: 734649d1622342943-trying-to-vlookup-from-separate-workbook-based-on-a-value-in-a-column-main-workbook
Sheet: Sheet1

EE Number | Payroll Number | Name | Department
100 | 1000
200 | 1000
300 | 1000
400 | 1000
500 | 2000
600 | 2000
700 | 2000
800 | 2000
Spreadsheet: 160081d1338967784-id-number-arranged-by-dates-example-id-number-arranged-by-dates
Sheet: גיליון1

ID Number | Date | Value | other fields
10566 | 2011-10-10 00:00:00 | 1
10566 | 2011-10-11 00:00:00 | 2
10566 | 2011-10-12 00:00:00 | 6
903456 | 2011-10-10 00:00:00 | 4
903457 | 2012-04-21 00:00:00 | 5
903457 | 2012-04-10 00:00:00 | 8
903457 | 2012-04-15 00:00:00 | 5
55478 | 2012-09-12 00:00:00 | 4
106457 | 2012-09-15 00:00:00 | 5
106457 | 2012-10-14 00:00:00 | 6
106457 | 2012-10-13 00:00:00 | 5
106457 | 2012-10-12 00:00:00 | 4
1020145 | 2012-10-17 00:00:00 | 8
1020145 | 2012-10-18 00:00:00 | 4
Spreadsheet: 134363-fill-series-automatically-in-certain-cells-across-columns-by-formula-examination-seat-plan
Sheet: Room 01

National University Admission Test 2011
University Test Center - 1
Seat Plan
Room No. 01
 |  | Roll Range 12101 - 12194
 |  | Total Candidate - 90
[NAME] A |  |  |  | [NAME] |  |  |  | [NAME]
12101 | 12112 | 12122 |  | 12133 | 12143 | 12153 |  | 12163 | 12175 | 12185
12102 | 12113 | 12123 |  | 12134 | 12144 | 12154 |  | 12164 | 12176 | 12186
12103 | 12114 | 12124 |  | 12135 | 12145 | 12155 |  | 12165 | 12177 | 12187
12104 | 12115 | 12125 |  | 12136 | 12146 | 12156 |  | 12166 | 12178 | 12188
12105 | 12116 | 12126 |  | 12137 | 12147 | 12157 |  | 12167 | 12179 | 12189
12106 | 12117 | 12127 |  | 12138 | 12148 | 12158 |  | 12168 | 12180 | 12190
12107 | 12118 | 12128 |  | 12139 | 12149 | 12159 |  | 12169 | 12181 | 12191
12108 | 12119 | 12129 |  | 12140 | 12150 | 12160 |  | 12170 | 12182 | 12192
12109 | 12120 | 12130 |  | 12141 | 12151 | 12161 |  | 12171 | 12183 | 12193
12110 | 12121 | 12131 |  | 12142 | 12152 | 12162 |  | 12172 | 12184 | 12194
 |  | Explanation: The room is rectangular in shape. There are three columns of benches, 10 benches in each column. So we can accommodate 90 candidates here. The Roll/Registration No. starts from 12101 and ends with 12194. 4 Candidates will not appear in this exam: 12111, 12132, 12173, 12174. Is there any formula that we write the first roll (or roll ranges) and all other cells will be filled in automatically.
Spreadsheet: 144542d1331034791-how-to-simplify-nested-if-function-copy-of-such-a-long-if-formula
Sheet: How to Reduce

Old | 2012-01-08 00:00:00 | 2012-01-15 00:00:00 | 2012-02-05 00:00:00 | 2012-02-19 00:00:00 | 2012-03-04 00:00:00 | 2012-03-11 00:00:00 | Receiving By 1 | Receiving Qty 1 | Reference | Receiving By 2 | Receiving Qty 2 | Summary | Ref. | When is Shortage
351 | 171 | 171 | 171 | 171 | 146 | 146 | 2011-12-05 00:00:00 | 300
66 | 66 | 66 | 66 | 66 | 66 | 36 | 2011-12-05 00:00:00 | 120
10 | -26 | -26 | -26 | -26 | -26 | -26 | 2011-12-26 00:00:00 | 50
0 | -100 | -100 | -280 | -280 | -280 | -460 | 2011-12-30 00:00:00 | 100 |  | TBA | 500
0 | -300 | -300 | -600 | -600 | -600 | -750 | 2011-12-30 00:00:00 | 300 |  | TBA | 500
-5 | -30 | -55 | -55 | -55 | -55 | -80 | 2012-01-03 00:00:00 | 40 |  | TBA | 65
28 | -2 | -2 | -2 | -47 | -47 | -47 | 2012-01-03 00:00:00 | 94
4 | -36 | -36 | -76 | -116 | -116 | -156 | 2012-01-05 00:00:00 | 100 |  | 2012-01-07 00:00:00 | 200
136 | -44 | -44 | -44 | -44 | -69 | -69 | 2012-01-05 00:00:00 | 100
-636 | -1383 | -1433 | -2063 | -2363 | -2448 | -3103 | 2012-01-08 00:00:00 | 1576 |  | TBA | 2818 |  | E
7 | -23 | -48 | -78 | -78 | -78 | -108 | 2012-01-10 00:00:00 | 48 |  | 2012-03-20 00:00:00 | 48
-19 | -19 | -19 | -19 | -19 | -19 | -19 | 2012-01-10 00:00:00 | 120
-342 | -542 | -542 | -942 | -942 | -1342 | -1342 | 2012-01-10 00:00:00 | 2000 |  |  |  |  | E
668 | -359 | -409 | -1339 | -1639 | -1724 | -2679 | 2012-01-10 00:00:00 | 72 |  | 25 Jan,  3 Feb | 414, 1242
-4 | -94 | -119 | -209 | -209 | -209 | -389 | 2012-01-10 00:00:00 | 90 |  | 28 Jan, 15 Mar | 270, 180
-115 | -140 | -140 | -190 | -190 | -290 | -390 | 2012-01-13 00:00:00 | 336
3281 | 2881 | 2881 | 2081 | 2081 | 481 | -1119 | 2012-02-27 00:00:00 | 1344 |  |  |  |  | T
1483 | 1483 | -217 | -217 | -217 | -642 | -2937 | IGI | 9000
0 | -30 | -30 | -30 | -75 | -75 | -75 | NR | 0
0 | -30 | -30 | -30 | -75 | -75 | -75 | NR | 0
4296 | 3896 | 3896 | 3096 | 3096 | 1496 | -104 | ST | 1000
-235 | -385 | -385 | -835 | -1135 | -1135 | -1535
-235 | -385 | -385 | -835 | -1135 | -1135 | -1535
Spreadsheet: 98620d1297464871-weighted-average-of-time-cstime
Sheet: Sheet1

[NAME] | M | T | W | TH | F
In | 07:30:00 | 07:30:00 | 07:30:00 | 07:30:00 | 07:30:00
Out | 12:00:00 | 12:00:00 | 12:00:00 | 12:00:00 | 12:00:00 |  | WT
In | 12:30:00 | 12:30:00 | 12:30:00 | 12:30:00 | 12:30:00 |  | LUNCH
Out | 16:00:00 | 16:00:00 | 16:00:00 | 16:00:00 | 16:00:00 |  | WT
 |  |  |  |  |  |  | TOTAL LOGIN
 |  |  |  |  | % BREAK
[NAME] | M | T | W | TH | F
In | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00
Out | 12:00:00 | 12:00:00 | 12:00:00 | 12:00:00 | 12:00:00 |  | WT
In | 13:00:00 | 13:00:00 | 13:00:00 | 13:00:00 | 13:00:00 |  | LUNCH
Out | 17:00:00 | 17:00:00 | 17:00:00 | 17:00:00 | 17:00:00 |  | WT
 |  |  |  |  |  |  | TOTAL LOGIN
 |  |  |  |  | % BREAK
[NAME] | M
In | 07:30:00
Out | 12:00:00 |  | WT
In | 12:30:00 |  | LUNCH
Out | 16:00:00 |  | WT
 |  |  | TOTAL LOGIN
 | % BREAK
[NAME] | M
In | 08:00:00
Out | 12:00:00 |  | WT
In | 13:00:00 |  | LUNCH
Out | 17:00:00 |  | WT
 |  |  | TOTAL LOGIN
 | % BREAK
Spreadsheet: 0811344f-579d-490e-83b7-eb50d3063618
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5302.0 Balance of Payments and International Investment Position, Australia
 | TABLE 112. GOODS AND SERVICES: IMPLICIT PRICE DEFLATORS - ORIGINAL (INDEX) - QUARTER
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Goods and Services credits ; |  |  | Original | A3538781J | 1959-09-01 00:00:00 | 2012-09-01 00:00:00 | 213 | Index Numbers | INDEX | Quarter | 3
Goods credits ; |  |  | Original | A3534669K | 1959-09-01 00:00:00 | 2012-09-01 00:00:00 | 213 | Index Numbers | INDEX | Quarter | 3
Services credits ; |  |  | Original | A3534725T | 1959-09-01 00:00:00 | 2012-09-01 00:00:00 | 213 | Index Numbers | INDEX | Quarter | 3
Goods and Services debits ; |  |  | Original | A3538782K | 1959-09-01 00:00:00 | 2012-09-01 00:00:00 | 213 | Index Numbers | INDEX | Quarter | 3
Goods debits ; |  |  | Original | A3534693K | 1959-09-01 00:00:00 | 2012-09-01 00:00:00 | 213 | Index Numbers | INDEX | Quarter | 3
Services debits ; |  |  | Original | A3534628R | 1959-09-01 00:00:00 | 2012-09-01 00:00:00 | 213 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2012
Spreadsheet: louise_kitchen__22667__ena cost allocation detail
Sheet: Sheet1

Enron Global Markets
Rate & Currency - Total
CO/PC/CC - XXXXXX
G&A Expense Worksheet
2002 Plan
 |  |  | 2001
 |  |  | Plan | Estimated | [NAME] |  | Total Plan | 02 Plan vs. 01 Est.
 |  |  | 2001 | 2001 | 2001 |  | 2002 | [NAME]
Headcount Summary |  |  |  | (FTE)
 | Pres./CEO |  | 0 | 0 | 0 |  | 0 | 0
 | [NAME]. |  | 0 | 0.5 | -0.5 |  | 0.5 | 0
 | Vice-Pres. |  | 2 | 0 | 2 |  | 0 | 0
 | Sr. Dir./Dir. |  | 2 | 3 | -1 |  | 3 | 0
 | Manager |  | 8 | 3 | 5 |  | 3 | 0
 | Sr. Spec. |  | 0 | 1 | -1 |  | 1 | 0
 | Specialist |  | 0 | 0 | 0 |  | 0 | 0
 | Admin. |  | 4 | 3.5 | 0.5 |  | 3.5 | 0
 | Tech. |  | 0 | 0 | 0 |  | 0 | 0
 | Other |  | 0 | 0 | 0 |  | 0 | 0
 | Subtotal |  | 16 | 11 | 5 |  | 11 | 0
 |  |  |  |  |  |  |  | 0
 | Associate |  | 3 | 1 | 2 |  | 2 | -1
 | 3rd Yr. Analyst |  | 0 | 0 | 0 |  | 0 | 0
 | Analyst |  | 0 | 0 | 0 |  | 0 | 0
 | Tax Analyst |  | 0 | 0 | 0 |  | 0 | 0
 | [NAME]. |  | 0 | 0 | 0 |  | 0 | 0
 | Summer Analyst |  | 0 | 0 | 0 |  | 0 | 0
 | Subtotal |  | 3 | 1 | 2 |  | 2 | -1
Total Headcount |  |  | 19 | 12 | 7 |  | 13 | -1
 |  |  |  |  |  |  |  |  |  | ENA Allocation
 |  |  |  |  |  |  |  |  |  | Percentage
 |  |  |  |  |  |  |  |  |  | 0.4065831454004888
Salaries & Wages |  |  | 2863532 | 1421414.571428571 | 1442117.428571429 |  | 1401485.5 | 19929.07142857136
Benefits & Payroll Taxes |  |  | 514694 | 145800 | 368894 |  | 310714 | -164914
Employee Expenses |  |  | 676980 | 394000 | 282980 |  | 485000 | -91000
Outside Services |  |  | 263988 | 405000 | -141012 |  | 445000 | -40000
Supplies Expense |  |  | 62004 | 36898.28571428572 | 25105.71428571428 |  | 49000 | -12101.71428571428
Marketing Expense |  |  | 2004 | 2634.857142857143 | -630.8571428571431 |  | 2600 | 34.85714285714312
Charitable Contributions |  |  | 0 | 0 | 0 |  | 0 | 0
Rent |  |  | 130500 | 114565.1428571429 | 15934.85714285714 |  | 30000 | 84565.14285714286
Technology |  |  | 122004 | 217000 | -94996 |  | 321000 | -104000
Corporate IT |  |  | 459996 | 655000 | -195004 |  | 630000 | 25000
Corporate Rent |  |  | 192996 | 211500 | -18504 |  | 228000 | -16500
Other Expenses |  |  | 892972.08 | 294748.8571428572 | 598223.2228571429 |  | 346400 | -51651.14285714284
Cash Expenses |  |  | 0 | 144 | -144 |  | 0 | 144
Depreciation Expense |  |  | 68004 | 161000 | -92996 |  | 350000 | -189000
Total Direct Expenses |  |  | 6249674.08 | 4059705.714285715 | 2189968.365714286 |  | 4599199.5
Indirect Expenses
 | EGM Alloc |  |  | 1381900 |  |  | 2081400
 | Corp |  |  | 541200 |  |  | 506600
 | Enron Europe |  |  | 458700 |  |  | 337800
 | EAs |  |  | 948500 |  |  | 772200
 | ENWs |  |  | 1984000 |  |  | 2841600
 | Total Indirects (estimate) |  |  |  |  |  | 55000
Total Expenses Equity Trading
Spreadsheet: 152725d1335487585-automatically-transfer-data-from-master-sheet-to-others-example-book-1
Sheet: Tu Kotahi

 | No | Name | Flat | Address | Contact 1 | Contact 2 | CSC | Referred | Assessor | Assess Date | Install Date | Completed | Comments
[NAME] | 1 | Name 1 |  | Address 126 | 02222221 |  | YES | [NAME] | Assessor 1 | 2012-02-08 00:00:00 | 2012-02-22 00:00:00 | 2012-02-24 00:00:00
[NAME] | 2 | Name 2 |  | Address 139 | 02222222 | 04999991 | NO | [NAME] | Assessor 1 | 2012-02-13 00:00:00 | 2012-02-29 00:00:00 | 2012-02-29 00:00:00
[NAME] | 3 | Name 3 |  | Address 152 | 02222223 | 04999992 | YES | [NAME] | Assessor 1 | 2012-02-13 00:00:00
[NAME] | 4 | Name 4 |  | Address 165 | 02222224 |  | EXPIRED | [NAME] | Assessor 1 | 2012-02-13 00:00:00 |  |  | "Not able to insulate"
[NAME] | 5 | Name 5 |  | Address 178 | 02222225 |  | UNKNOWN | [NAME] | Assessor 1 | 2012-02-13 00:00:00
[NAME] | 6 | Name 6 |  | Address 110 | 02222226 | 04999993 | YES | [NAME] | Assessor 1 | 2012-02-16 00:00:00 | 2012-03-09 00:00:00 | 2012-02-12 00:00:00
[NAME] | 7 | Name 7 |  | Address 123 | 02222227 | 04999994 | NO | [NAME] | Assessor 2 | 2012-02-17 00:00:00 |  |  | No CSC
[NAME] | 8 | Name 8 |  | Address 136 | 02222228 |  | UNKNOWN | [NAME] | Assessor 1 | 2012-02-18 00:00:00 |  |  | No Record
[NAME] | 9 | Name 9 |  | Address 149 | 02222229 |  | UNKNOWN | [NAME] | Assessor 1 | 2012-02-19 00:00:00 |  |  | No Record
[NAME] | 10 | Name 10 |  | Address 162 | 02222230 | 04999995 | YES | [NAME] | Assessor 1 | 2012-02-24 00:00:00 | 2012-04-17 00:00:00 | 2012-04-18 00:00:00
Spreadsheet: 80ee5e37-a979-4561-8ec7-15eeece079fd
Sheet: Sheet1

Ergebnisse 1. [NAME] A - 20.12.2011 | Unnamed: 1 | Unnamed: 2
Name | [NAME] | Grammatik
[NAME] | 18/30 | 19/30
[NAME] | 24/30 | 23/30
Camilletti Mattia | 23/30 | 20/30
[NAME] | 18/30 | insuff.
D'Ignazio Yasmin | 24/30 | 20/30
[NAME] | 23/30 | 20/30
[NAME] | 28/30 | 20/30
[NAME] | 25/30 | 23/30
Guercioni Marika | 22/30 | 23/30
[NAME] | 21/30 | 20/30
Izzotti Annalisa | 29/30 | 27/30
[NAME] | 18/30 | 18/30
Manetta [NAME] | 26/30 | 26/30
[NAME] | 18/30 | 20/30
Minnozzi Francesca | 25/30 | 27/30
[NAME] | 18/30 | insuff.
[NAME] | 26/30 | 25/30
Pasquali Ursula Francesca | 27/30 | 27/30
[NAME] | 18/30 | insuff.
Pizzuti Fabrizia | 27/30 | 27/30
[NAME] | 24/30 | 22/30
[NAME] | 20/30 | 21/30
[NAME] | 18/30 | 18/30
Radatti Rosapia | 22/30 | insuff.
[NAME] | 26/30 | 28/30
[NAME] | 24/30 | 22/30
[NAME] | 27/30 | 25/30
Tidei Giulia | 18/30 | insuff.
[NAME] |  | insuff.
[NAME] | 25/30 | 20/30
Gli studenti che non hanno superato una parte d'esame possono [NAME].
Spreadsheet: 117793d1313019748-using-data-validation-to-specify-cell-selection-cb-test
Sheet: Date

2011-08-08 00:00:00
2011-08-15 00:00:00
2011-08-22 00:00:00
2011-08-29 00:00:00
2011-09-05 00:00:00
2011-09-12 00:00:00
2011-09-19 00:00:00
2011-09-26 00:00:00
2011-10-03 00:00:00
2011-10-10 00:00:00
2011-10-17 00:00:00
2011-10-24 00:00:00
2011-10-31 00:00:00
2011-11-07 00:00:00
2011-11-14 00:00:00
2011-11-21 00:00:00
2011-11-28 00:00:00
2011-12-05 00:00:00
2011-12-12 00:00:00
2011-12-19 00:00:00
2011-12-26 00:00:00
2012-01-02 00:00:00
2012-01-09 00:00:00
2012-01-16 00:00:00
2012-01-23 00:00:00
2012-01-30 00:00:00
2012-02-06 00:00:00
2012-02-13 00:00:00
2012-02-20 00:00:00
2012-02-27 00:00:00
2012-03-05 00:00:00
2012-03-12 00:00:00
2012-03-19 00:00:00
2012-03-26 00:00:00
2012-04-02 00:00:00
2012-04-09 00:00:00
2012-04-16 00:00:00
2012-04-23 00:00:00
2012-04-30 00:00:00
2012-05-07 00:00:00
2012-05-14 00:00:00
2012-05-21 00:00:00
2012-05-28 00:00:00
2012-06-04 00:00:00
2012-06-11 00:00:00
2012-06-18 00:00:00
2012-06-25 00:00:00
2012-07-02 00:00:00
2012-07-09 00:00:00
2012-07-16 00:00:00
2012-07-23 00:00:00
2012-07-30 00:00:00
2012-08-06 00:00:00
2012-08-13 00:00:00
2012-08-20 00:00:00
2012-08-27 00:00:00
2012-09-03 00:00:00
2012-09-10 00:00:00
2012-09-17 00:00:00
2012-09-24 00:00:00
2012-10-01 00:00:00
2012-10-08 00:00:00
2012-10-15 00:00:00
2012-10-22 00:00:00
2012-10-29 00:00:00
2012-11-05 00:00:00
2012-11-12 00:00:00
2012-11-19 00:00:00
2012-11-26 00:00:00
2012-12-03 00:00:00
2012-12-10 00:00:00
2012-12-17 00:00:00
2012-12-24 00:00:00
2012-12-31 00:00:00
Spreadsheet: 837303d1690018402-lookup-by-multiple-conditions-jch-7-science
Sheet: Comments

StudentName | Student 3
Row Labels | Sum of Percent
Phases of the Moon | 1
Earth Axis | 1
[NAME] | 1
Earth Rotation | 1
[NAME] | 1
Earth Satelitte | 1
Label Eclipse | 1
Labelling Earth | 1
[NAME] | 0.875
Seasons | 0.5
Moon Cycles | 0.5
Revoultion and Rotation | 0.3333333333333333
Orbit | 0
Solar Years | 0
Grand Total | 0.8292682926829268