tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 107181d1304417058-how-to-automatically-find-unique-ranges-in-one-column-to-sum-in-another-test-1-_rhysspinner-
Sheet: Sheet1

TIME of DAY | CONSISTENCY | Weight | Sum of Col B for each separate time of day | Min value of Col C for each unique time of day | Helper  Column
2.00 | 0.08923229350904018 | 6 |  |  | 2
2.00 | 0.03571428571428571 | 5
2.00 | 0.04166666666666666 | 6 |  |  |  |  | Problem is that column D isnt a separate sum for each different time of day
2.00 | 0.08333333333333333 | 7
2.00 | 0.06451612903225806 | 3
2.00 | 0.07836702015343627 | 3
2.00 | 0.0625 | 3
2.00 | - | 3
2.00 | 0.07836702015343627 | 4
2.00 | 0.07836702015343627 | 2
2.00 | 0.06060606060606061 | 5
2.00 | 0.03566912320825261 | 1.5
2.00 | - | 1.2
2.00 | 0.02083333333333333 | 2 | 0.7291722858635393 | 0.02083333333333333
2.10 | 0.2205850529371894 | 4 |  |  | 16
2.10 | 0.1466607652629311 | 5
2.10 | 0.1466607652629311 | 4
2.10 | 0.119047619047619 | 2
2.10 | 0.05555555555555555 | 3
2.10 | - | 4
2.10 | 0.02 | 7
2.10 | 0.06425729533702874 | 7 | 0.7291722858635393 | 0.02
2.15 | - | 7 |  |  | 24
2.15 | 0.09989037633760761 | 8
2.15 | 0.07501192055920194 | 2
2.15 | 0.07501192055920194 | 3
2.15 | 0.07501192055920194 | 8
2.15 | 0.02083333333333333 | 8
2.15 | 0.05882352941176471 | 1.1
2.15 | 0.008333333333333333 | 2.3
2.15 | 0.03333333333333333 | 3
2.15 | 0.05314495556609689 | 4.5
2.15 | - | 4.2
2.15 | 0.05314495556609689 | 2
2.15 | 0.05314495556609689 | 2
2.15 | 0.01 | 3
2.15 | 0.006666666666666667 | 4 | 0.7291722858635393 | 0.006666666666666667
 |  |  |  |  | 39
Spreadsheet: 08309c3a-e586-405e-bb2d-a80c26a2801e
Sheet: 3Replace Costs-Results 6-10

Table 5.2.24.  Replacement Costs (Years 6 to 10)
 |  |  |  | EPA Discount Rate:
 |  |  |  | Present Value of Replacement Costs in Year:
Component | Unit Cost | Unit | Quantity | 6 | 7 | 8 | 9 | 10
 |  |  | Total Present Value of Replacement Costs (Years 6 to 10):
Spreadsheet: 1541d59d-e8ae-459b-b597-f4f7e8971cf4
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Rhino | 706301667620 | Chanticleer | Wondrous Love: A World Folk Song Collection | 2008-07-01 | Compact Disc | Classical | 16.99 | N | To Be Retired
Rhino | 745099087821 | Chanticleer | Where The Sun Will Never Go Down: Spituals And Traditional Gospel Music | 2008-07-01 | Compact Disc | Classical | 16.99 | N | To Be Retired
Rhino | 809274855626 | Chanticleer | Our American Journey | 2008-07-01 | Compact Disc | Classical | 17.99 | N | To Be Retired
Spreadsheet: 827644d1682933393-excel-formula-to-get-the-lowest-value-with-a-condition-sample
Sheet: Sheet1

PRODUCT | PRICE | STATE |  | PRODUCT | LOWEST PRICE
PRODUCT A | 200 | JAPAN |  | PRODUCT A | 150 | I WANT THE LOWEST PRICE OF PRODUCT WITH FORMULA.
PRODUCT A | 300 | US |  | PRODUCT B | 120
PRODUCT A | 400 | ITLY |  | PRODUCT C | 140
PRODUCT A | 150 | CHINA
PRODUCT B | 250 | JAPAN
PRODUCT B | 120 | US
PRODUCT B | 545 | ITLY
PRODUCT B | 200 | CHINA
PRODUCT B | 130 | FRANCE
PRODUCT B | 300 | GEMRMANY
PRODUCT C | 501 | JAPAN
PRODUCT C | 300 | US
PRODUCT C | 200 | ITLY
PRODUCT C | 150 | CHINA
PRODUCT C | 200 | RUSSIA
PRODUCT C | 140 | PARIS
PRODUCT C | 260 | FRANCE
PRODUCT C | 350 | INDIA
Spreadsheet: 726044d1617026916-pulling-data-at-the-end-of-a-business-day-sample
Sheet: MARIA

Resignations | 2021-03-26 00:00:00
Campus | # of Resignations | # of Resignations | # of Resignations | # of Resignations | # of Resignations | # of Resignations | # of Resignations | # of Resignations | # of Resignations | # of Resignations | # of Resignations | # of Resignations | # of Resignations | # of Resignations | # of Resignations | # of Resignations | # of Resignations | # of Resignations | # of Resignations | # of Resignations | # of Resignations | # of Resignations
School 1 | 2 | 1
School 2 | 5 | 2
School 3 | 3 | 2
School 4 | 6 | 9
School 5 | 8 | 2
School 6 | 1 | 3
School 7 | 9 | 4
School 8 | 2 | 6
School 9 | 3 | 8
School 10 | 4 | 6
School 11 | 6 | 1
School 12 | 8 | 6
School 13 | 6 | 2
School 14 | 1 | 2
School 15 | 6 | 6
School 16 | 2 | 5
School 17 | 2 | 9
School 18 | 6 | 4
School 19 | 5 | 1
School 20 | 9 | 1
School 21 | 4 | 3
School 22 | 1 | 5
School 23 | 1 | 8
TOTAL
Total Number of Employees |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-07-10 00:00:00
Campus | # of Employees | # of Employees | # of Employees | # of Employees | # of Employees | # of Employees | # of Employees | # of Employees | # of Employees | # of Employees | # of Employees | # of Employees | # of Employees | # of Employees | # of Employees | # of Employees | # of Employees | # of Employees | # of Employees | # of Employees | # of Employees | # of Employees
School 1 | 67
School 2 | 67
School 3 | 117
School 4 | 20
School 5 | 116
School 6 | 104
School 7 | 122
School 8 | 73
School 9 | 117
School 10 | 136
School 11 | 114
School 12 | 115
School 13 | 70
School 14 | 56
School 15 | 110
School 16 | 16
School 17 | 115
School 18 | 114
School 19 | 114
School 20 | 6
School 21 | 116
School 22 | 115
School 23 | 20
TOTAL
Vacancies | 2020-02-14 00:00:00 | 2020-02-21 00:00:00 | 2020-02-28 00:00:00 | 2020-03-06 00:00:00 | 2020-03-13 00:00:00 | 2020-03-20 00:00:00 | 2020-03-27 00:00:00 | 2020-04-03 00:00:00 | 2020-04-10 00:00:00 | 2020-04-17 00:00:00 | 2020-04-24 00:00:00 | 2020-05-01 00:00:00 | 2020-05-08 00:00:00 | 2020-05-15 00:00:00 | 2020-05-22 00:00:00 | 2020-05-29 00:00:00 | 2020-06-05 00:00:00 | 2020-06-12 00:00:00 | 2020-06-19 00:00:00 | 2020-06-26 00:00:00 | 2020-07-03 00:00:00 | 2020-07-10 00:00:00
Campus | # of Vacancies | # of Vacancies | # of Vacancies | # of Vacancies | # of Vacancies | # of Vacancies | # of Vacancies | # of Vacancies | # of Vacancies | # of Vacancies | # of Vacancies | # of Vacancies | # of Vacancies | # of Vacancies | # of Vacancies | # of Vacancies | # of Vacancies | # of Vacancies | # of Vacancies | # of Vacancies | # of Vacancies | # of Vacancies
School 1 | 2
School 2 | 12
School 3 | 0
School 4 | 2
School 5 | 3
School 6 | 2
School 7 | 2
School 8 | 1
School 9 | 11
School 10 | 2
School 11 | 2
School 12 | 1
School 13 | 2
School 14 | 4
School 15 | 1
School 16 | 2
School 17 | 5
School 18 | 2
School 19 | 1
School 20 | 3
School 21 | 1
TOTAL
Spreadsheet: 805677d1668822528-conditional-formatting-time-hours-and-min-greater-than-or-less-than-time-in-another-cell-conditional-formatting-time-hours-and-min-greater-than-or-less-than-time-hours-and-min-in-another
Sheet: Teacher Aide 8

Teacher Aide Timetable and Work Pattern Calculator
Name: | Teacher Aide 8
Start Date: | 2023-02-03 00:00:00
Finish Date: | 2023-12-01 00:00:00
 | Monday | Tuesday | Wednesday | Thursday | Friday
Period 1 | 08:40:00 | 08:40:00 | 08:40:00 | 08:40:00 | 08:40:00
 | 09:40:00 | 09:40:00 | 09:40:00 | 09:40:00 | 09:40:00
Transition | 09:40:00 | 09:40:00 | 09:40:00 | 09:40:00 | 09:40:00
 | 09:45:00 | 09:45:00 | 09:45:00 | 09:45:00 | 09:45:00
Period 2 | 09:45:00 | 09:45:00 | 09:45:00 | 09:45:00 | 09:45:00
 | 10:45:00 | 10:45:00 | 10:45:00 | 10:45:00 | 10:45:00
[NAME] | 10:45:00 | 10:45:00 | 10:45:00 | 10:45:00 | 10:45:00
 | 11:05:00 | 11:05:00 | 11:05:00 | 11:05:00 | 11:05:00
Interval | 11:05:00 | 11:05:00 | 11:05:00 | 11:05:00 | 11:05:00
 | 11:25:00 | 11:25:00 | 11:25:00 | 11:25:00 | 11:25:00
Period 3 | 11:25:00 | 11:25:00 | 11:25:00 | 11:25:00 | 11:25:00
 | 12:25:00 | 12:25:00 | 12:25:00 | 12:25:00 | 12:25:00
[NAME] | 12:25:00 | 12:25:00 | 12:25:00 | 12:25:00 | 12:25:00
 | 12:40:00 | 12:40:00 | 12:40:00 | 12:40:00 | 12:40:00
Period 4 | 12:40:00 | 12:40:00 | 12:40:00 | 12:40:00 | 12:40:00
 | 13:40:00 | 13:40:00 | 13:40:00 | 13:40:00 | 13:40:00
Break | 13:40:00 | 13:40:00 | 13:40:00 | 13:40:00 | 13:40:00
 | 14:15:00 | 14:15:00 | 14:15:00 | 14:15:00 | 14:15:00
Period 5 | 14:15:00 | 14:15:00 | 14:15:00 | 14:15:00 | 14:15:00
 | 15:15:00 | 15:15:00 | 15:15:00 | 15:15:00 | 15:15:00
Total (Hours:Mins)
10/20 Minute Paid Break for Less/More Than 5 Hours
Total for Week
Spreadsheet: 97453d1296626126-pivot-tables-gallinski-pivot-table-data-test
Sheet: Report

 | Data
Client | Sum of STEEL | Sum of TIMBER | Sum of GENERAL | Sum of BUTTER | Sum of COCOA | Sum of CAR | Sum of SEAFOOD | Sum of EQUIPMENT | Sum of EMPTY
ALLISON | 26 | 52 | 78 | 104 | 130 | 156 | 182 | 234 | 208
ANDREW | 3 | 29 | 55 | 81 | 107 | 133 | 159 | 211 | 185
[NAME] | 12 | 38 | 64 | 90 | 116 | 142 | 168 | 220 | 194
CHRIS | 6 | 32 | 58 | 84 | 110 | 136 | 162 | 214 | 188
CLAIRE | 7 | 33 | 59 | 85 | 111 | 137 | 163 | 215 | 189
ELVIS | 18 | 44 | 70 | 96 | 122 | 148 | 174 | 226 | 200
GRAHAM | 13 | 39 | 65 | 91 | 117 | 143 | 169 | 221 | 195
IAN | 10 | 36 | 62 | 88 | 114 | 140 | 166 | 218 | 192
JACK | 14 | 40 | 66 | 92 | 118 | 144 | 170 | 222 | 196
[NAME] | 23 | 49 | 75 | 101 | 127 | 153 | 179 | 231 | 205
[NAME] | 21 | 47 | 73 | 99 | 125 | 151 | 177 | 229 | 203
JOSH | 15 | 41 | 67 | 93 | 119 | 145 | 171 | 223 | 197
MARK | 2 | 28 | 54 | 80 | 106 | 132 | 158 | 210 | 184
[NAME] | 1 | 27 | 53 | 79 | 105 | 131 | 157 | 209 | 183
MICK | 4 | 30 | 56 | 82 | 108 | 134 | 160 | 212 | 186
NICK | 22 | 48 | 74 | 100 | 126 | 152 | 178 | 230 | 204
PAT | 11 | 37 | 63 | 89 | 115 | 141 | 167 | 219 | 193
PAUL | 16 | 42 | 68 | 94 | 120 | 146 | 172 | 224 | 198
SARAH | 19 | 45 | 71 | 97 | 123 | 149 | 175 | 227 | 201
[NAME] | 9 | 35 | 61 | 87 | 113 | 139 | 165 | 217 | 191
STEVE | 5 | 31 | 57 | 83 | 109 | 135 | 161 | 213 | 187
SUZIE | 8 | 34 | 60 | 86 | 112 | 138 | 164 | 216 | 190
TASH | 20 | 46 | 72 | 98 | 124 | 150 | 176 | 228 | 202
TERRY | 24 | 50 | 76 | 102 | 128 | 154 | 180 | 232 | 206
VICKI | 25 | 51 | 77 | 103 | 129 | 155 | 181 | 233 | 207
WILL | 17 | 43 | 69 | 95 | 121 | 147 | 173 | 225 | 199
Grand Total | 351 | 1027 | 1703 | 2379 | 3055 | 3731 | 4407 | 5759 | 5083
Spreadsheet: 776098d1649499362-insert-decimal-and-multiply-multiply
Sheet: Sheet1

x | x | x | x | x | x | 115 x 55 cms | 1 | x
x | x | x | x | x | x | 110 x 620 cms | 1 | x
x | x | x | x | x | x | 110 x 210 cms | 1 | x
x | x | x | x | x | x | 52 x 24 cms | 1 | x
x | x | x | x | x | x | 52 x 24 cms | 1 | x
x | x | x | x | x | x | 128 x 710 cms | 1 | x
x | x | x | x | x | x | 128 x 420 cms | 1 | x
x | x | x | x | x | x | 120 x 625 cms | 3 | x
x | x | x | x | x | x | 100 x 60 cms | 1 | x
x | x | x | x | x | x | 120 x 245 cms | 3 | x
Spreadsheet: 22222bd0-fbd5-4ca6-95ec-cc5e549ff3b5
Sheet: Sheet1

Newspaper Audience 2012 by Gender & Age Group | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Market/Release: Scarborough USA+ 2012 Release 1 Total (Feb 2011 - Mar 2012)
 |  | Base Total Adults | Men | Women | Adults 18 - 34 | Adults 35 or older | Adults 55 or older
Base Total Adults 18+ | Target Pop | 236610692 | 114775845 | 121834847 | 70234396 | 166376296 | 79878186
 | Target % | 1 | 1 | 1 | 1 | 1 | 1
Newspaper Print/E-Edition/Website - Avg. Issue/Yesterday | Target Pop | 101439080 | 51730414 | 49708666 | 20831799 | 80607281 | 44697404
 | Target % | 0.429 | 0.451 | 0.408 | 0.297 | 0.484 | 0.56
Sunday-Print or E-edition | Target Pop | 104109136 | 49092419 | 55016717 | 21571629 | 82537507 | 45773688
 | Target % | 0.44 | 0.428 | 0.452 | 0.307 | 0.496 | 0.573
Newspaper-Print/E-Edition 5 Weekday Cume | Target Pop | 128448217 | 64075079 | 64373138 | 30542018 | 97906199 | 53081884
 | Target % | 0.5429999999999999 | 0.5579999999999999 | 0.528 | 0.435 | 0.588 | 0.665
Past Week Newspaper Print | Target Pop | 147118528 | 71492924 | 75625604 | 36099501 | 111019027 | 58639343
 | Target % | 0.622 | 0.623 | 0.621 | 0.514 | 0.667 | 0.7340000000000001
Past Week Newspaper Print or E-edition | Target Pop | 148089873 | 72027481 | 76062392 | 36455953 | 111633920 | 58810916
 | Target % | 0.626 | 0.628 | 0.624 | 0.519 | 0.6709999999999999 | 0.736
Past 7 Days: Print/E-edition/Website | Target Pop | 160238898 | 78446339 | 81792559 | 40849063 | 119389835 | 60862810
 | Target % | 0.677 | 0.6829999999999999 | 0.6709999999999999 | 0.5820000000000001 | 0.718 | 0.762
[NAME] or Newspaper Mobile source Used in Past 30 Days combined with Newspaper Past Week Print/E-Edition | Target Pop | 168610455 | 82459155 | 86151300 | 45197380 | 123413075 | 61740880
 | Target % | 0.713 | 0.718 | 0.7070000000000001 | 0.644 | 0.742 | 0.773
Prepared by: Newspaper Association of America
Spreadsheet: sally_beck__33739__Metrics 0727
Sheet: Coal

E N R O N   N O R T H   A M E R I C A - H O T  L I S T  M E T R I C S |  |  |  |  |  |  |  |  |  |  |  |  | Team: | Coal Origination & Finance
Results based on Activity through July 27, 2000 |  |  |  |  |  |  |  |  |  |  |  |  | Week | 4
 |  | Weekly Summary - 2Q00 through 2Q01
 |  | # of Transactions
 |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13
 |  | 2000-07-07 00:00:00
Postings Rollforward:
Beginning |  | 19
+ Entrances |  | 0 | 3 | 0 | 4
- Exits |  | 0 | 3 | 0 | 3
- Executions |  | 0 | 0 | 0 | 2
Ending
Postings Rollforward:
Beginning
+ Entrances
- Exits
+/- [NAME]
- Executions
Ending
Average Deal Size
 |  | Quarterly Summary ($ millions)
 |  |  |  |  |  |  |  | Forward Quarters
 | YTD |  |  | Current Quarter |  | Per |  |  |  |  | Total Year
 | 2000 |  |  | 3Q00 |  | Hot List |  | 4Q00 |  |  | 2000 |  |  | 1Q01 |  |  | 2Q01
 | # | $ |  | # | $ |  |  | # | $ |  | # | $ |  | # | $ |  | # | $
Executions |  |  |  | 2 | 0.25 | 0.25 |  | 0 | 0 |  |  |  |  | 0 | 0 |  | 0 | 0
DPR/MPR |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  | 0
Postings |  |  |  | 8 | 103.25 |  |  | 7 | 12 |  |  |  |  | 3 | 35 |  | 0 | 0
Identified Margin
Budget |  | 6.212
$ Coverage
Spreadsheet: 155849d1337083895-question-query-re-repeating-numbers-in-rows-book1
Sheet: Sheet1

Year | 2012 |  |  |  |  | List for data Validation in B2
10001-12 |  |  |  |  |  | 2005
10002-12 |  |  |  |  |  | 2006
10003-12 |  |  |  |  |  | 2007
10004-12 |  |  |  |  |  | 2008
10005-12 |  |  |  |  |  | 2009
10006-12 |  |  |  |  |  | 2010
10007-12 |  |  |  |  |  | 2011
10008-12 |  |  |  |  |  | 2012
10009-12 |  |  |  |  |  | 2013
10010-12 |  |  |  |  |  | 2014
 |  |  |  |  |  | 2015
Spreadsheet: 808497d1670498505-how-to-calculate-result-by-skipping-blank-cells-book1
Sheet: Sheet1

STUDENT NO | ENGLISH | PHYSICS | CHEMISTRY | MATHS | BIO | IT | YOGA | RESULT
1 | 34 | 33 | 45 |  | 33
2 | 45 | 31 | 32 | 33 |  | 21
3 | 31 | 45 | 34 | 23 |  | 37
4
Spreadsheet: 737415d1624403166-coefficients-for-a-logarithmic-curve-log_function
Sheet: Threshold_Days (2)

Determine Average Rainfall Days
Mean number of days of rain
Station 1 | Station 2 | Rainfall ([NAME]) | Days
55 | 57 | 1
29 | 20 | 10 |  |  | Coefficient
14 | 9 | 25
Spreadsheet: 843078d1695046542-looking-for-a-formula-to-exclude-rows-from-a-filtered-table-workqueue-template-colbyjackqueso-
Sheet: Month YYYY

ID | Beneficiary ID | Last Name | First Name | DOB | Contract Num | State Code | County Code | TRC | TRC Short Name | File Name | 154 | 85 | Keep
25 | RAND0M1D-085/154/305 | JONES | MIKE | 19630226 | CONTRACT | SC | 0CC | 085 | NEW SCC | EFTO.RH6328.DTRRD.D230901
26 | RAND0M1D-085/154/306 | JONES | MIKE | 19630226 | CONTRACT | SC | 0CC | 154 | OUT OF AREA | EFTO.RH6328.DTRRD.D230901
27 | RAND0M1D-085/154/307 | JONES | MIKE | 19630226 | CONTRACT | SC | 0CC | 305 | ZIP CD CHANGE | EFTO.RH6328.DTRRD.D230901
57 | TH1515ANMB1-305 | DUCK | [NAME] | 19510915 | CONTRACT | SC | 0CC | 305 | ZIP CD CHANGE | EFTO.RH2171.DTRRD.D230902
87 | B3N3F1C1@RY-085/154/305 | [NAME] | MICKEY | 19500205 | CONTRACT | SC | 0CC | 085 | NEW SCC | EFTO.RH6328.DTRRD.D230907
88 | B3N3F1C1@RY-085/154/306 | [NAME] | MICKEY | 19500205 | CONTRACT | SC | 0CC | 154 | OUT OF AREA | EFTO.RH6328.DTRRD.D230907
89 | B3N3F1C1@RY-085/154/307 | [NAME] | MICKEY | 19500205 | CONTRACT | SC | 0CC | 305 | ZIP CD CHANGE | EFTO.RH6328.DTRRD.D230907
107 | RUNN1NG0UT-305 | [NAME] | MINNIE | 19560804 | CONTRACT | SC | 0CC | 305 | ZIP CD CHANGE | EFTO.RH2171.DTRRD.D230907
161 | 2M0R3EXMPL5-085/305 | JACOB | [NAME] | 19701008 | CONTRACT | SC | 0CC | 085 | NEW SCC | EFTO.RH2171.DTRRD.D230912
163 | 2M0R3EXMPL5-085/305 | JACOB | [NAME] | 19701008 | CONTRACT | SC | 0CC | 305 | ZIP CD CHANGE | EFTO.RH2171.DTRRD.D230912
164 | [NAME] | WOMAN | WONDER | 19551108 | CONTRACT | SC | 0CC | 085 | NEW SCC | EFTO.RH2171.DTRRD.D230912
166 | [NAME] | WOMAN | WONDER | 19551108 | CONTRACT | SC | 0CC | 305 | ZIP CD CHANGE | EFTO.RH2171.DTRRD.D230912
Spreadsheet: 145497d1331622221-excel-2007-multi-layered-list-multi-layered-list
Sheet: Levels

Level 1 | Level 2 | Level 3 | Level 4
EAF
 | France Cluster
 |  | Mayotte
 |  |  | Longoni
 |  | Reunion
 |  |  | Port Reunion
 | [NAME]
 |  | Kenya
 |  |  | Mombasa
 |  |  | Nairobi
 |  |  | Thika
 |  | Rwanda
 |  |  | Kigali
 |  | Tanzania, United Republic Of
 |  |  | Dar Es Salaam
 |  |  | Shinyanga
 |  |  | [NAME]
 |  |  | Zanzibar
 |  | Uganda
 |  |  | Kampala
 | Mauritius Cluster
 |  | Comoros
 |  |  | Mutsamudu
 |  | Madagascar
 |  |  | Antananarivo
 |  |  | Antsiranana
 |  |  | Mahajanga
 |  |  | Nosy Be Hell Ville
 |  |  | Toamasina (Tamatave)
 |  |  | Tolanaro (Fort Dauphin)
 |  |  | Toliara
 |  | [NAME]
 |  |  | Port Louis
 |  | Seychelles
 |  |  | Victoria
SAF
 | [NAME]
 |  | [NAME]
 |  |  | Blantyre
 |  |  | Lilongwe City
 |  | Mozambique
 |  |  | Beira
 |  |  | Maputo
 |  |  | Nacala
 |  |  | Pemba
 |  |  | Quelimane
 |  | Zambia
 |  |  | Lusaka
 |  | Zimbabwe
 |  |  | Bulawayo, Condep
 |  |  | Gweru
 |  |  | Harare
 |  |  | Mutare
 | South Africa Cluster
 |  | Botswana
 |  |  | Gaborone City Centre
 |  | [NAME]
 |  |  | Maseru City Centre
 |  | Namibia
 |  |  | Luderitz
 |  |  | Walvis Bay
 |  | South Africa
 |  |  | [NAME]
 |  |  | Cape Town
 |  |  | Durban
 |  |  | East London
 |  |  | Johannesburg
 |  |  | Port Elizabeth
 |  |  | Pretoria
 |  |  | Richards Bay
 |  | Swaziland
 |  |  | Matsapha, [NAME]
WAF
 | Angola Cluster
 |  | Angola
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | Luanda
 |  |  | Namibe
 |  |  | Soyo
 | [NAME]
 |  | Cameroon
 |  |  | Douala
 |  |  | Ngaoundere
 |  | Equatorial Guinea
 |  |  | Bata
 |  |  | Malabo
 |  | Gabon
 |  |  | Libreville
 |  |  | [NAME]
 |  | Sao Tome
 |  |  | Sao Tome
 | CWA Cluster
 |  | Benin
 |  |  | Cotonou
 |  | [NAME]
 |  |  | [NAME]
 |  |  | Ouagadougou
 |  | Ghana
 |  |  | Kumasi
 |  |  | Takoradi
 |  |  | Tema
 |  | Nigeria
 |  |  | Apapa
 |  |  | Onne
 |  |  | Tin Can Island - PTML
 |  |  | Tin Can Island - Sifax
 |  |  | Tin Can Island - TICT
 |  | Togo
 |  |  | Lome
 | Dem Republic of Congo Cluster
 |  | Congo
 |  |  | [NAME]
 |  | Congo, Democratic Republic Of
 |  |  | Boma
 |  |  | Kinshasa
 |  |  | Matadi
 | [NAME]
 |  | Guinea
 |  |  | Conakry
 |  | Liberia
 |  |  | Monrovia
 |  | Sierra Leone
 |  |  | Freetown
 | Ivory Coast Cluster
 |  | [NAME]
 |  |  | Abidjan
 |  |  | [NAME]
 | Senegal Cluster
 |  | Cape Verde
 |  |  | [NAME]
 |  |  | Praia
 |  | Gambia
 |  |  | Banjul
 |  | Guinea-Bissau
 |  |  | [NAME]
 |  | [NAME]
 |  |  | Bamako
 |  | Mauritania
 |  |  | Nouadhibou
 |  |  | [NAME]
 |  | Senegal
 |  |  | [NAME]
Africa
Spreadsheet: 464740d1465300357-vlookup-issue-ukx-lines-of-least-resistance
Sheet: Summary

 | 101 |  | 151 |  | 201 |  | 251 |  | 301 |  | 351 |  |  | 100-150 |  | 151-200 |  | 201-250 |  | 251-300 |  | 301-350 |  | 351-400
 | 102 |  | 152 |  | 202 |  | 252 |  | 302 |  | 352
 | 103 |  | 153 |  | 203 |  | 253 |  | 303 |  | 353
 | 104 |  | 154 |  | 204 |  | 254 |  | 304 |  | 354
 | 105 |  | 155 |  | 205 |  | 255 |  | 305 |  | 355
 | 106 |  | 156 |  | 206 |  | 256 |  | 306 |  | 356
 | 107 |  | 157 |  | 207 |  | 257 |  | 307 |  | 357
 | 108 |  | 158 |  | 208 |  | 258 |  | 308 |  | 358
 | 109 |  | 159 |  | 209 |  | 259 |  | 309 |  | 359
 | 110 |  | 160 |  | 210 |  | 260 |  | 310 |  | 360
 | 111 |  | 161 |  | 211 |  | 261 |  | 311 |  | 361
 | 112 |  | 162 |  | 212 |  | 262 |  | 312 |  | 362
 | 113 |  | 163 |  | 213 |  | 263 |  | 313 |  | 363
 | 114 |  | 164 |  | 214 |  | 264 |  | 314 |  | 364
 | 115 |  | 165 |  | 215 |  | 265 |  | 315 |  | 365
 | 116 |  | 166 |  | 216 |  | 266 |  | 316 |  | 366
 | 117 |  | 167 |  | 217 |  | 267 |  | 317 |  | 367
 | 118 |  | 168 |  | 218 |  | 268 |  | 318 |  | 368
 | 119 |  | 169 |  | 219 |  | 269 |  | 319 |  | 369
 | 120 |  | 170 |  | 220 |  | 270 |  | 320 |  | 370
 | 121 |  | 171 |  | 221 |  | 271 |  | 321 |  | 371
 | 122 |  | 172 |  | 222 |  | 272 |  | 322 |  | 372
 | 123 |  | 173 |  | 223 |  | 273 |  | 323 |  | 373
 | 124 |  | 174 |  | 224 |  | 274 |  | 324 |  | 374
 | 125 |  | 175 |  | 225 |  | 275 |  | 325 |  | 375
 | 126 |  | 176 |  | 226 |  | 276 |  | 326 |  | 376
 | 127 |  | 177 |  | 227 |  | 277 |  | 327 |  | 377
 | 128 |  | 178 |  | 228 |  | 278 |  | 328 |  | 378
 | 129 |  | 179 |  | 229 |  | 279 |  | 329 |  | 379
 | 130 |  | 180 |  | 230 |  | 280 |  | 330 |  | 380
 | 131 |  | 181 |  | 231 |  | 281 |  | 331 |  | 381
 | 132 |  | 182 |  | 232 |  | 282 |  | 332 |  | 382
 | 133 |  | 183 |  | 233 |  | 283 |  | 333 |  | 383
 | 134 |  | 184 |  | 234 |  | 284 |  | 334 |  | 384
 | 135 |  | 185 |  | 235 |  | 285 |  | 335 |  | 385
 | 136 |  | 186 |  | 236 |  | 286 |  | 336 |  | 386
 | 137 |  | 187 |  | 237 |  | 287 |  | 337 |  | 387
 | 138 |  | 188 |  | 238 |  | 288 |  | 338 |  | 388
 | 139 |  | 189 |  | 239 |  | 289 |  | 339 |  | 389
 | 140 |  | 190 |  | 240 |  | 290 |  | 340 |  | 390
 | 141 |  | 191 |  | 241 |  | 291 |  | 341 |  | 391
 | 142 |  | 192 |  | 242 |  | 292 |  | 342 |  | 392
 | 143 |  | 193 |  | 243 |  | 293 |  | 343 |  | 393
 | 144 |  | 194 |  | 244 |  | 294 |  | 344 |  | 394
 | 145 |  | 195 |  | 245 |  | 295 |  | 345 |  | 395
 | 146 |  | 196 |  | 246 |  | 296 |  | 346 |  | 396
 | 147 |  | 197 |  | 247 |  | 297 |  | 347 |  | 397
 | 148 |  | 198 |  | 248 |  | 298 |  | 348 |  | 398
 | 149 |  | 199 |  | 249 |  | 299 |  | 349 |  | 399
 | 150 |  | 200 |  | 250 |  | 300 |  | 350 |  | 400
Spreadsheet: 470790d1468659879-ref-error-when-inserting-row-into-table-precious-metals-template
Sheet: Gold (Inventory)

 |  | TOTAL P/L |  |  |  | TOTALS
 | Year | Description | Mint | Purchase Date | Units | Weight (oz) | Total Weight | Purchase Price | Spot Value | Premium | P/L ($) | P/L (%)
Totals
Spreadsheet: 128093d1320783126-excel-2007-help-with-if-and-various-other-formulas-for-a-prepayment-schedule-prepayment-query
Sheet: Sheet1

Supplier | Invoice Value | Start | Finish | Life | Previous | 2011-01-31 00:00:00 | 2011-02-28 00:00:00 | 2011-03-31 00:00:00 | 2011-04-30 00:00:00 | 2011-05-31 00:00:00 |  | Period Total
ABC | 1200 | 2010-07-01 00:00:00 | 2011-06-30 00:00:00
BCA | 1200 | 2011-01-01 00:00:00 | 2011-12-31 00:00:00
CBA | 1200 | 2011-03-10 00:00:00 | 2011-05-09 00:00:00
ABBC | 1200 | 2011-01-10 00:00:00 | 2011-04-10 00:00:00
 |  | Total Monthly Movement
ABBC not received until February so need to put backdated amounts in february column.
Spreadsheet: fletcher_sturm__10912__Daily Basis Example
Sheet: Sheet1

Example of    SELLING    GD/D Pepl-Hhub
Assumptions:
 |  |  |  |  | NX1 |  |  |  |  | NX1
IF Hub basis          BID | 0 |  | Pepl |  |  |  |  |  |  |  |  |  | Hub
IF vs GD/D Hub index          BID | -0.0025 |  | Basis |  |  |  |  | E |  |  |  |  | Basis
IF Pepl basis     OFFER | -0.1125 |  | Swap |  | IF Pepl |  |  | N |  | IF Hub |  |  | Swap
IF vs GD/D Pepl index     OFFER | 0.0025 |  |  |  |  |  |  | R
 |  |  |  |  |  |  |  | O
 |  |  |  |  |  |  |  | N
Daily Basis sale price calculation:
 |  |  |  |  |  |  |  | T
Net Basis |  |  |  |  |  |  |  | r
Net Index |  |  |  |  |  |  |  | a
 |  |  |  |  | GD/D Pepl |  |  | d |  | GD/D Hub
Receive GD/D Hub |  |  | Pepl |  |  |  |  | e |  |  |  |  | Hub
Pay GD/D Pepl |  |  | Index |  |  |  |  | r |  |  |  |  | Index
 |  |  | Swap |  | IF Pepl |  |  |  |  | IF Hub |  |  | Swap
Example of    BUYING    GD/D Pepl-Hhub
Assumptions:
 |  |  |  |  | NX1 |  |  |  |  | NX1
IF Hub basis          OFFER | 0.0025 |  | Pepl |  |  |  |  |  |  |  |  |  | Hub
IF vs GD/D Hub index          OFFER | 0.0025 |  | Basis |  |  |  |  | E |  |  |  |  | Basis
IF Pepl basis               BID | -0.115 |  | Swap |  | IF Pepl |  |  | N |  | IF Hub |  |  | Swap
IF vs GD/D Pepl index               BID | 0 |  |  |  |  |  |  | R
 |  |  |  |  |  |  |  | O
 |  |  |  |  |  |  |  | N
Daily Basis buy price calculation:
 |  |  |  |  |  |  |  | T
Net Basis |  |  |  |  |  |  |  | r
Net Index |  |  |  |  |  |  |  | a
 |  |  |  |  | GD/D Pepl |  |  | d |  | GD/D Hub
Pay GD/D Hub |  |  | Pepl |  |  |  |  | e |  |  |  |  | Hub
Receive GD/D Pepl |  |  | Index |  |  |  |  | r |  |  |  |  | Index
 |  |  | Swap |  | IF Pepl |  |  |  |  | IF Hub |  |  | Swap