tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_m_love__30145__200003_OA
Sheet: CE_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  CENTRAL
 |  |  | Total |  | Reclasses |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  |  | -10752 | -39116.89 | 4056 | 11072.88
2 |  | Liquidations |  |  |  |  |  |  |  | 8435262 |  |  |  | -120108.5
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements |  |  |  |  |  |  |  |  |  |  |  |  |  | 12972 |  | 6076.13
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1302551 | 28000 | -1288664 | 38101.77
7 |  | Liquidations |  |  |  |  |  |  |  | 0 |  | -300.34
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | -219959 | -574752.87 |  |  | -1 | -2.61
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind |  |  |  |  |  |  |  |  |  |  |  |  | 207845 | 543098.99 | -10147 | -26514.11 | -16109 | -42092.82
14 |  | Cash Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1
15 |  | Cash In |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6092 | 12194.68 | 7669 | 18237.34
16 |  | Synthetic Storage |  |  |  |  |  |  |  |  |  |  |  |  | 298037 | 0.01
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg) |  |  |  |  |  |  |  |  |  |  |  |  | -610000 | -1593930
18 |  | W/D (Purchase from Stg) |  |  |  |  |  |  |  |  |  |  |  |  | 316663 | 694167.15
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4: |  |  |  |  |  |  |  |  |  |  |  |  |  | 11801 | 30836.1 | -1302551 | -3403565.76 | 1297105 | 3389335.37
23 | Fuel: |  |  |  |  |  |  |  |  |  |  |  |  |  | 219959 | 574752.87 |  |  | 1 | 2.61
 | Transport Expense:
24 |  | Commodity |  |  |  |  |  |  |  |  |  |  |  |  | 4369 | -19195.7 | 18564 | 18356.01 | -17841074 | -59127.61
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  |  |  |  |  |  |  | -3000 |  |  |  | 94546.9
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 113a16d3-2d0d-4aa5-96d5-4ee83b5c8638
Sheet: Corrective Action Report

Produce GAPs Harmonized Food Safety Standard
Post-harvest - USDA Checklist
USDA, AMS, Fruit and Vegetable Program |  |  |  |  | Report #:
Good Agricultural Practice & Good Handling Practices |  |  |  |  |  |  | of
CORRECTIVE ACTION REPORT
Company Name/Farm: |  |  |  |  | Date:
Lead Auditor:
Crop(s):
Description of Non Conformity:
Notified company staff at time of finding non-conformity (Yes or No):
Checklist question number and/or section of auditee food safety plan associated with non-conformity:
Corrective Action Proposed and Time Frame for Implementation:  (Attach separate sheet if necessary)
Company Representative Signature:
Signature affirms statements concerning Non-Conformity, Corrective Action, and Implementation are correct.
Auditor signature for acceptance of proposed corrective action and timetable for implementation:
Top portion for AUDITOR USE ONLY; bottom portion for Company and Auditor use.
Spreadsheet: 104472d1302068513-value-from-hh-mm-format-to-numbers-format-call-duration
Sheet: Sheet1 (3)

SER | Date Time GMT+0 | Called Country | Called No. | USER | Duration(min:sec) | Amount | MY REQUIREMENT FROM COLUMN F
20 | 2010-09-12 09:11:46 | AU | 2154545645 | ABC | 04:00:00 | -0.8364 | 4
21 | 2010-09-12 09:10:12 | AU | 2154545645 | ABC | 01:00:00 | -0.2091 | 1
22 | 2010-09-12 09:09:30 | AU | 2154545645 | ABC | 00:30:00 | -0.2091 | 1
33 | 2010-09-12 07:06:33 | AU | 2154545645 | ABC | 02:30:00 | -0.6273 | 3
69 | 2010-09-09 07:25:35 | AU | 2154545645 | ABC | 1 day, 0:00:00 | -2.1816 | 24
70 | 2010-09-09 06:20:41 | AU | 2154545645 | ABC | 2 days, 12:00:00 | -5.454 | 60
18 | 2010-09-12 10:16:32 | AU | 2154545645 | ABC | 1 day, 6:30:00 | -2.8179 | 31
 |  |  |  | TOTAL
 |  |  |  |  |  |  | TOTAL 124 MINUTES CALLS
Spreadsheet: 0566b0bd-88d3-48b2-881f-8ba3939ebc49
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 | Unnamed: 12 | Unnamed: 13
 | Fig. 1.3.2 - Total public expenditure and age-related expenditure as a percentage of GDP. Italy - Years 2005-2060
 | Source: processing by [NAME] on [NAME] dell'Economia e Finanze data
 | Public expenditure on pensions, health, care for the elderly, education and unemployment benefit (% GDP). Italy - Years 2005-2060
 |  | 2005 | 2010 | 2015 | 2020 | 2025 | 2030 | 2035 | 2040 | 2045 | 2050 | 2055 | 2060
 | Total expenditure | 48.2 | 50.6 | 48.1 | 47 | 46.2 | 46.1 | 46.2 | 46.7 | 47 | 46.4 | 45.8 | 45
 | Age-related expenditure | 26.1 | 28.6 | 27.9 | 27.5 | 27.4 | 27.9 | 28.3 | 29 | 29.3 | 28.9 | 28.6 | 28.2
 | Source: processing by [NAME] on [NAME] dell'Economia e Finanze data
Spreadsheet: 66503d1267135602-excel-chart-wont-print-correctly-archart2
Sheet: Graph

Days  -  January  2010
 |  |  |  | Central Ohio
Data Table |  | a | b | c | Other | Total
AR Days |  | 160.3 | 73.7 | 32 | 47.9 | 60.7
AR  $ |  | 274110 | 358743 | 188712 | 244550
 |  |  | 2 | 3 | 4 | 5 | 6
 |  |  |  |  |  |  |  |  | 5 |  | 1
 |  |  |  |  |  |  | DOS |  | Central Ohio
AR Days - Sites |  | 160.3 | 73.7 | 32 | 47.9 | 60.7 |  |  | Miami
AR  Days - Tot |  | 0 | 0 | 0 | 0 | 0 |  |  | Mahoning
 |  |  |  |  |  |  |  |  | Southwest
AR  $ |  | 274110 | 358743 | 188712 | 244550 | 1066115 |  |  | Akron
AR $ |  | 0 | 0 | 0 | 0 | 0 |  |  | Central Ohio
 |  |  |  |  |  |  |  |  | Cleveland
 |  |  |  |  |  |  |  |  | Toledo
 |  |  |  |  |  |  |  |  | Total
Spreadsheet: geir_solberg__11283__12-16act
Sheet: EPEData

 | 37338.44444444445
 | NEWMAN 1 ,UNAV, -0  , 75  , 39  , 83  ,  0  ,1
 | NEWMAN 2 ,ECON, 36  , 77  , 34  , 83  , 41  ,1
 | NEWMAN 3 ,ECON, 36  ,100  , 35  ,103  , 40  ,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,106  ,215  , 86  ,214  ,  0  ,1
 | NEWMAN   ,, 178 ,  392,  155, 400 ,  81 ,
 | COPPER   ,[NAME], -0  , 69  , 15  , 69  ,  0  ,1
 | RIOGRAN 6,MANL, 25  , 47  , 29  , 48  ,  0  ,1
 | RIOGRAN 7,AVAL,  0  , 38  , 32  , 49  ,  0  ,1
 | RIOGRAN 8,UNAV,  0  ,121  , 36  ,151  ,  0  ,1
 | RIOGRANDE,,  25 ,   47,   29,  48 ,   0 ,
 | PALOVERDE,MANL,607  ,599  ,599  ,600  ,  0  ,1
 | FOURCRNRS,MANL, 95  , 95  , 95  ,104  ,  0  ,1
 | LAMBDA, 29.33,  672,  671,  196,    7,    0,12881,75
 | 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: 97147d1296393048-populate-data-based-on-multiple-criteria-data-table-and-summary
Sheet: Number of Incidents by Outlet

 |  |  |  | 2010-01-01 00:00:00
 |  |  |  | 2010-12-31 00:00:00
 | Channel | Train Station
 | Time Frame | Oct 2010 to Dec 2010
 | Incident Type | Channel | Outlet/Kiosk | No of Incident
 | Outlet Opening / Closure | Train Station | Houston | 2
 | Ploan Commission | Train Station | Lewisville | 1
 | Compromised ID | Train Station | Dallas | 1
Spreadsheet: 850735d1701117923-formula-help-vlookup-example
Sheet: Week 2

Employee | Employee Identifier | Medical - Week 2 | Dental - Week 2 | Vision - Week 2
[NAME] | 101-6 | 0.5 | 5 | 1
[NAME] | 101-5 | 0.7 | 10 | 2
[NAME] | 101-2 | 0.5 | 5 | 3
[NAME] Beta | 101-4 | 0.7 | 10 | 5
[NAME] | 101-3 | 0.7 | 10 | 10
Spreadsheet: 134119d1325021831-formulas-break-because-new-rows-are-inserted-in-the-tab-that-does-the-calculations-a_raw
Sheet: Conversion

 | 5
 | 4 |  |  |  |  |  |  |  |  |  |  | Table | Table value
 | 3 |  |  |  |  |  |  |  |  |  |  | Excellent | 5
 | 2 |  |  |  |  |  |  |  |  |  |  | Good | 4
 | 1 |  |  |  |  |  |  |  |  |  |  | Adequate | 3
 | 0 |  |  |  |  |  |  |  |  |  |  | Poor | 2
 | 4 |  |  |  |  |  |  |  |  |  |  | Unacceptable | 1
 | 3
 | 2
 | 1
 | 5
 | 4
 | 3
 | 2
 | 1
 | 5
 | 4
 | 3
 | 2
 | 1
 | 5
 | 4
 | 3
 | 2
 | 1
 | 5
 | 4
 | 3
 | 2
 | 1
 | 5
 | 4
 | 3
 | 2
 | 1
 | 5
 | 4
 | 3
 | 2
 | 1
 | 2
 | 2
 | 1
 | 1
 | 1
 | 1
 | 4
 | 5
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
Spreadsheet: 220377d1363134219-copy-data-from-other-sheets-by-typing-in-unique-identifier-from-them-example
Sheet: Juice

FOOD | MAIN INGREDIENT | WEIGHT | UNIQUE CODE | PRICE
Orange juice | Orange | 2.3 | Juice01 | 3
Apple juice | Apple | 4 | Juice02 | 4
Mango juice | Mango | 3 | Juice03 | 3.2
Coconut juice | Coconut | 2.2 | Juice04 | 2.2
Spreadsheet: 858957d1707425668-index-match-mmult-fomula-not-working-properly-formula-help-update
Sheet: Current Formula (2)

ID # | data 1 | data2 | data3 | data4 | data5 | [NAME]
1000 | 2 | 3 | 5 | 449
1001 | 91 | 92 | 93 | 94 | 95
1002 | 96 |  |  |  |  |  |  | expected result- Column A should search if any cells in its row matches any cells in higher rows. If yes, index to ID# of the matching Column A. if not, add  new next numeric ID#
1003 | 97 | 98 | 99 | 100 | 101
1004 | 105 | 106 | 107 | 108 | 466
1005 | 102 | 104 | 417
1006 | 145 | 105 | 455
1005 | 102 | 103 | 104 | 417
1003 | 97 | 98 | 99 | 100 | 101
1007 | 109
1004 | 105 | 106 | 107 | 108 | 466
1008 | 110 | 111 | 112 | 415
1009 | 113 | 114 | 115 | 116 | 420
1008 | 112
1009 | 113 | 114 | 115 | 116 | 420
1010 | 125 | 126 | 127 | 461
1008 | 110 | 111 | 112 | 415
1009 | 115 | 116 | 420
1009 | 113 | 114 | 115 | 116 | 420
1011 | 128 | 129 | 130 | 459
Spreadsheet: 723362d1615650447-conditional-formatting-and-color-cells-with-formula-testname-6
Sheet: Blad1

project | datum | nr vlist | nr defensie | vertrek | tijd | aankomst | aantal | wie NL | wie D | inkoop NL | inkoop D | verkoop NL | verkoop D
5154 | 2021-03-18 00:00:00 | 20404500 | 17NLD102 | Loheide | 22:00:00 | de lutte | 1 | nl |  |  |  |  |  |  | uren inkoop |  |  | km inkoop
5154 | 2021-03-18 00:00:00 | 20404500 | 17NLD102 | Loheide | 22:00:00 | de lutte | 1 |  | nl |  |  |  |  |  | [NAME] |  |  | km verkoop
5155 | 2021-03-18 00:00:00 | 20404757 | 18NLD104 | amersfoort | 20:00:00 | Loheide | 2 | ik | ics |  |  |  |  |  | [NAME] |  |  | [NAME]
5155 | 2021-03-18 00:00:00 | 20404757 | 18NLD104 | amersfoort | 20:00:00 | Loheide | 2 | nl | ics
5155 | 2021-03-18 00:00:00 | 20404757 | 18NLD104 | amersfoort | 20:00:00 | Loheide | 2 |  | ics |  |  |  |  |  | Inkoop NL |  |  | Inkoop D
5156 | 2021-03-18 00:00:00 | 20404797 | 18NLD103 | Loheide | 22:30:00 | de lutte | 1 |  | ast |  |  |  |  |  | [NAME] |  |  | Verkoop D
5156 | 2021-03-18 00:00:00 | 20404797 | 18NLD103 | Loheide | 22:30:00 | de lutte | 1 |  | ast |  |  |  |  |  | [NAME] |  |  | Verschil D
5156 | 2021-03-18 00:00:00 | 20404797 | 18NLD103 | Loheide | 22:30:00 | de lutte | 1 |  | ast
5157 | 2021-03-18 00:00:00 | 20404793 | 17NLD105 | Loheide | 22:45:00 | de lutte | 1 |  | nl |  |  |  |  |  | Totaal inkoop |  |  | proj nl in
5157 | 2021-03-18 00:00:00 | 20404793 | 17NLD105 | Loheide | 22:45:00 | de lutte | 1 |  | nl |  |  |  |  |  | Totaal verkoop |  |  | proj nl ver
5158 | 2021-03-18 00:00:00 | 20404798 | 17NLD107 | Loheide | 23:30:00 | de lutte | 1 |  | nl |  |  |  |  |  | totaal [NAME] |  |  | [NAME] in
5158 | 2021-03-18 00:00:00 | 20404798 | 17NLD107 | Loheide | 23:30:00 | de lutte | 1 |  | nl |  |  |  |  |  |  |  |  | [NAME] ver
5159 | 2021-03-19 00:00:00 | 20404799 | 17NLD108 | Loheide | 00:00:00 | darp | 2 | rene | rene
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | projrct [NAME] |  | project [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | search code | aantal beg | inkoop NL | inkoop D | verkoop NL | verkoop D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5155
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | per begeleider
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | customer | amount
Spreadsheet: 854483d1704342949-how-to-calculate-number-of-headcount-needed-using-erlang-formula-in-call-center-erlang-formula-spreadsheet
Sheet: Factorials

Factorials
 | Number | Factorial
 | N | N!
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 | 31
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
 | 61
 | 62
 | 63
 | 64
 | 65
 | 66
 | 67
 | 68
 | 69
 | 70
 | 71
 | 72
 | 73
 | 74
 | 75
 | 76
 | 77
 | 78
 | 79
 | 80
 | 81
 | 82
 | 83
 | 84
 | 85
 | 86
 | 87
 | 88
 | 89
 | 90
 | 91
 | 92
 | 93
 | 94
 | 95
 | 96
 | 97
 | 98
 | 99
 | 100
 | 101
 | 102
 | 103
 | 104
 | 105
 | 106
 | 107
 | 108
 | 109
 | 110
 | 111
 | 112
 | 113
 | 114
 | 115
 | 116
 | 117
 | 118
 | 119
 | 120
 | 121
 | 122
 | 123
 | 124
 | 125
 | 126
 | 127
 | 128
 | 129
 | 130
 | 131
 | 132
 | 133
 | 134
 | 135
 | 136
 | 137
 | 138
 | 139
 | 140
 | 141
 | 142
 | 143
 | 144
 | 145
 | 146
 | 147
 | 148
 | 149
 | 150
 | 151
 | 152
 | 153
 | 154
 | 155
 | 156
 | 157
 | 158
 | 159
 | 160
 | 161
 | 162
 | 163
 | 164
 | 165
 | 166
 | 167
 | 168
 | 169
 | 170
 | 171
 | 172
 | 173
 | 174
 | 175
 | 176
 | 177
 | 178
 | 179
 | 180
 | 181
 | 182
 | 183
 | 184
 | 185
 | 186
 | 187
 | 188
 | 189
 | 190
 | 191
 | 192
 | 193
 | 194
 | 195
 | 196
 | 197
 | 198
 | 199
 | 200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | © Call Centre Helper 2017
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | https://www.callcentrehelper.com
Spreadsheet: 186336d1349991647-i-need-help-with-auto-summing-unique-groups-and-formatting-automatically-myworkbook
Sheet: Sheet1

location | client | first name | last name | time | date | Amount
AZ | test one | Name | Name | [NAME] | 2012-10-01 00:00:00 | 10
AZ | test one | Name | Name | [NAME] | 2012-10-02 00:00:00 | 10
TX | test one | Name | Name | [NAME] | 2012-10-03 00:00:00 | 10
CA | test two | Name | Name | [NAME] | 2012-10-04 00:00:00 | 20
CA | test two | Name | Name | [NAME] | 2012-10-05 00:00:00 | 20
NM | test two | Name | Name | [NAME] | 2012-10-06 00:00:00 | 20
NM | test three | Name | Name | [NAME] | 2012-10-07 00:00:00 | 30
NY | test three | Name | Name | [NAME] | 2012-10-08 00:00:00 | 30
NY | test three | Name | Name | [NAME] | 2012-10-09 00:00:00 | 30
NY | test three | Name | Name | [NAME] | 2012-10-10 00:00:00 | 30
PA | test four | Name | Name | [NAME] | 2012-10-11 00:00:00 | 40
PA | test four | Name | Name | [NAME] | 2012-10-12 00:00:00 | 40
 |  |  |  |  |  |  | The first sheet is how it is now. The second sheet is what I have been able to do. The third sheet is what I am trying to acomplish automatically.
Spreadsheet: 89312d1289071958-how-to-go-about-copying-values-updating-lists-public-rush
Sheet: Submit Info

Day | Wednesday
Shift | AM
Position | Employee | Hour 1 | Hour 2 | Hour 3 | Hour 4
Position 1 | [NAME] | 1 | 0 | 1 | 1 | 1
Position 1 | [NAME] | 5 | 3 |  |  | 5
Position 2 | [NAME] | 11 | 5 |  |  | 11
Position 2 | [NAME] | 1 | 27 |  |  | 1
Position 3 | [NAME] | (Window Time from Screens) |  |  | 00:07:56 | 0.005509259259259259
Position 3 | [NAME] |  |  |  | 00:18:50 | 0.0130787037037037
Position 4 | [NAME] | 3 | 5 |  |  | 3
Position 4 | [NAME] | 7 | 8 |  |  | 7
Position 5 | [NAME] | 12 | 100 | 0 | 12 | 8
Spreadsheet: 151984d1335204024-need-vlookup-help-sample_data
Sheet: CLEAN

Store # | 2012-02-26 00:00:00 |  | 2012-03-04 00:00:00 |  | 2012-03-11 00:00:00 |  | 2012-03-18 00:00:00 |  | 2012-03-25 00:00:00
1 | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory
MODEL 1
MODEL 2
MODEL 3
MODEL 4
MODEL 5
MODEL 6
2 | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory
MODEL 1
MODEL 2
MODEL 3
MODEL 4
MODEL 5
MODEL 6
3 | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory
MODEL 1
MODEL 2
MODEL 3
MODEL 4
MODEL 5
MODEL 6
4 | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory
MODEL 1
MODEL 2
MODEL 3
MODEL 4
MODEL 5
MODEL 6
5 | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory
MODEL 1
MODEL 2
MODEL 3
MODEL 4
MODEL 5
MODEL 6
6 | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory
MODEL 1
MODEL 2
MODEL 3
MODEL 4
MODEL 5
MODEL 6
7 | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory
MODEL 1
MODEL 2
MODEL 3
MODEL 4
MODEL 5
MODEL 6
8 | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory
MODEL 1
MODEL 2
MODEL 3
MODEL 4
MODEL 5
MODEL 6
9 | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory
MODEL 1
MODEL 2
MODEL 3
MODEL 4
MODEL 5
MODEL 6
10 | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory
MODEL 1
MODEL 2
MODEL 3
MODEL 4
MODEL 5
MODEL 6
11 | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory
MODEL 1
MODEL 2
MODEL 3
MODEL 4
MODEL 5
MODEL 6
12 | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory
MODEL 1
MODEL 2
MODEL 3
MODEL 4
MODEL 5
MODEL 6
13 | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory
MODEL 1
MODEL 2
MODEL 3
MODEL 4
MODEL 5
MODEL 6
14 | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory
MODEL 1
MODEL 2
MODEL 3
MODEL 4
MODEL 5
MODEL 6
15 | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory
MODEL 1
MODEL 2
MODEL 3
MODEL 4
MODEL 5
MODEL 6
16 | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory
MODEL 1
MODEL 2
MODEL 3
MODEL 4
MODEL 5
MODEL 6
17 | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory
MODEL 1
MODEL 2
MODEL 3
MODEL 4
MODEL 5
MODEL 6
18 | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory | Sales | Inventory
MODEL 1
MODEL 2
MODEL 3
MODEL 4
MODEL 5
MODEL 6
Spreadsheet: 48797d1248103819-need-to-delete-gaps-in-cells-postcodes-radio-stations
Sheet: Aire

Area: Radio Station - 96.3 Radio Aire FM
Postcode
BD 3 0
BD 3 7
BD 3 8
BD 3 9
BD 4 0
BD 11 1
BD 11 2
BD 19 3
BD 19 4
BD 19 5
BD 19 6
LS 1 2
LS 1 3
LS 1 4
LS 1 5
LS 1 6
LS 1 7
LS 1 8
LS 2 3
LS 2 7
LS 2 8
LS 2 9
LS 3 1
LS 4 2
LS 5 2
LS 5 3
LS 6 1
LS 6 2
LS 6 3
LS 6 4
LS 7 1
LS 7 2
LS 7 3
LS 7 4
LS 8 1
LS 8 2
LS 8 3
LS 8 4
LS 8 5
LS 9 0
LS 9 6
LS 9 7
LS 9 8
LS 9 9
LS 10 1
LS 10 2
LS 10 3
LS 10 4
LS 11 0
LS 11 5
LS 11 6
LS 11 7
LS 11 8
LS 11 9
LS 12 1
LS 12 2
LS 12 3
LS 12 4
LS 12 5
LS 12 6
LS 13 1
LS 13 2
LS 13 3
LS 13 4
LS 14 1
LS 14 2
LS 14 3
LS 14 5
LS 14 6
LS 15 0
LS 15 4
LS 15 5
LS 15 7
LS 15 8
LS 15 9
LS 16 5
LS 16 6
LS 16 7
LS 16 8
LS 16 9
LS 17 5
LS 17 6
LS 17 7
LS 17 8
LS 18 4
LS 18 5
LS 19 6
LS 19 7
LS 20 8
LS 20 9
LS 25 1
LS 25 2
LS 25 7
LS 26 0
LS 26 8
LS 26 9
LS 27 0
LS 27 7
LS 27 8
LS 27 9
LS 28 5
LS 28 6
LS 28 7
LS 28 8
LS 28 9
WF 1 1
WF 1 2
WF 1 3
WF 1 4
WF 1 5
WF 2 0
WF 2 6
WF 2 7
WF 2 8
WF 2 9
WF 3 1
WF 3 2
WF 3 3
WF 3 4
WF 4 1
WF 4 3
WF 4 5
WF 4 6
WF 5 0
WF 5 8
WF 5 9
WF 6 1
WF 6 2
WF 7 5
WF 7 6
WF 7 7
WF 8 1
WF 8 2
WF 8 4
WF 9 1
WF 9 4
WF 9 5
WF 10 1
WF 10 2
WF 10 3
WF 10 4
WF 10 5
WF 11 0
WF 11 8
WF 11 9
WF 12 0
WF 12 7
WF 12 8
WF 12 9
WF 13 1
WF 13 2
WF 13 3
WF 13 4
WF 14 0
WF 14 8
WF 14 9
WF 15 6
WF 15 7
WF 15 8
WF 16 0
WF 16 9
WF 17 0
WF 17 5
WF 17 6
WF 17 7
WF 17 8
WF 17 9
Households & Population: 2001 Census, Small Area Statistics (Crown Copyright)
Spreadsheet: 81710d1281839585-how-to-check-if-multiple-conditions-exist-and-give-1-of-3-answers-phases
Sheet: Sheet2

 |  |  |  |  |  |  | Name | Length | Start Date | Phase
 |  |  |  |  |  |  | [NAME] | 30 | 2010-03-01 00:00:00 | Phase 1
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Sue
Length | Phase 1 | Phase 2 | Phase 3 |  |  |  | Doug
12 | 0 | 3 | 7
18 | 0 | 4 | 9
24 | 0 | 5 | 11
30 | 0 | 6 | 13
36 | 0 | 7 | 15
42 | 0 | 8 | 17
48 | 0 | 9 | 19 |  | Each colored section is a named range.  Those named ranges are used in the
60 | 0 | 10 | 21 |  | formula in column K to compare today's date with the correct program, then
 |  |  |  |  | how many months have passed.
 |  |  |  |  | Edit the Gray and Green ranges to indicate the MONTH NUMBER that starts each phase.
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: Canada A&A-Orig

 | Canada Analyst & Associate
 | 2002 Plan
 |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2002 |  | 2002 |  |  |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | Plan |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  | 0 | Compensation | 0
 | Special Pays |  |  |  |  | 0
 | Analysts & Associates | 0 |  | 0
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  | Total
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  | [NAME] | 33600 | 0
ENACONTR | Charitable Contributions |  |  |  |  |  | [NAME] | 52800 | 0
ENARENT | Rent |  |  |  |  |  | Staff | 54000 | 0
ENATECH | Technology |  |  |  |  |  | Specialist | 63000 | 0
ENATRANS | Transportation |  |  |  |  |  | Sr. Specialist | 78000 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  | Analyst | 66000 | 3
ENATAXES | Taxes Other than Income |  |  |  |  |  | Associate | 97200 | 1
ENATOTDR | Total Direct Expenses |  |  |  |  |  | Manager | 120000 | 0
 |  |  |  |  |  |  | Director | 156000 | 0
 | Headcount |  |  |  |  |  | Sr. Director | 180000 | 0
 |  |  |  |  |  |  | VP | 216000 | 0
 | Analyst & Associate Headcount |  |  |  |  |  | CEO | 240000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | *  Analysts and Associates are billed through normal payroll for Canada. |  |  |  |  | Other Expense Calculation
ENAOUTTX
ENAINSUR |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
ENASYSDV
ENACORIT
ENACORRN
ENAOTHAL
ENADEPR