tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 723744d1615875352-conditional-formatting-for-dates-within-certain-number-of-days-book1
Sheet: Data2

Plan End Date | Cell A minus 90 days
2022-01-14 00:00:00
2022-02-22 00:00:00
2021-12-24 00:00:00
2021-09-03 00:00:00
2021-06-21 00:00:00
2021-06-01 00:00:00 |  | Cell A Colour should change
2021-06-05 00:00:00 |  | Cell A Colour should change
2021-04-11 00:00:00 |  | Cell A Colour should change
2021-11-30 00:00:00
2021-06-09 00:00:00 |  | Cell A Colour should change
2021-05-27 00:00:00 |  | Cell A Colour should change
2021-05-21 00:00:00 |  | Cell A Colour should change
2022-05-28 00:00:00
2021-07-10 00:00:00 |  | Cell A Colour should change
2024-02-28 00:00:00
2021-03-26 00:00:00 |  | Cell A Colour should change
2021-07-23 00:00:00
2022-02-02 00:00:00
2021-05-20 00:00:00 |  | Cell A Colour should change
2021-05-07 00:00:00 |  | Cell A Colour should change
2022-06-02 00:00:00
2021-12-11 00:00:00
2021-12-24 00:00:00
2021-09-07 00:00:00
2022-02-03 00:00:00
2021-10-08 00:00:00
2021-10-15 00:00:00
Spreadsheet: 140325d1328706501-how-can-the-merge-the-two-cells-data-in-a-single-sheet-book1
Sheet: Master

Item Code | Min | [NAME] | Locator
010-00197 | 12 | 22 | ?
010-00321 | 27 | 37
010-00212 | 5 | 15
010-00329 | 5 | 15
010-00123 | 5 | 15
010-00175 | 5 | 15
010-00162 | 5 | 15
010-00157 | 5 | 15
010-00171 | 5 | 15
010-00272 | 5 | 15
010-00124 | 5 | 15
010-00275 | 5 | 15
010-00144 | 5 | 15
010-00278 | 5 | 15
010-00279 | 5 | 15
010-00277 | 5 | 15
010-00280 | 5 | 15
010-00281 | 5 | 15
010-00276 | 5 | 15
010-00271 | 5 | 15
010-00147 | 5 | 15
010-00274 | 5 | 15
010-00273 | 5 | 15
010-00250 | 5 | 15
010-00299 | 5 | 15
010-00301 | 5 | 15
010-00302 | 5 | 15
010-00260 | 5 | 15
010-00300 | 5 | 15
010-00206 | 5 | 15
010-00251 | 5 | 15
010-00309 | 5 | 15
010-00253 | 5 | 15
010-00249 | 5 | 15
010-00266 | 5 | 15
010-00263 | 5 | 15
010-00195 | 5 | 15
010-00261 | 5 | 15
010-00196 | 5 | 15
010-00198 | 5 | 15
010-00306 | 5 | 15
010-00305 | 5 | 15
010-00304 | 5 | 15
010-00254 | 5 | 15
010-00204 | 5 | 15
010-00200 | 5 | 15
010-00190 | 5 | 15
010-00193 | 5 | 15
010-00328 | 5 | 15
010-00192 | 5 | 15
010-00252 | 5 | 15
010-00326 | 5 | 15
010-00325 | 5 | 15
010-00262 | 5 | 15
010-00194 | 5 | 15
010-00307 | 5 | 15
010-00268 | 5 | 15
010-00269 | 5 | 15
010-00255 | 5 | 15
010-00228 | 5 | 15
010-00235 | 5 | 15
010-00230 | 5 | 15
010-00232 | 5 | 15
010-00138 | 5 | 15
010-00221 | 5 | 15
010-00220 | 5 | 15
010-00202 | 5 | 15
010-00145 | 5 | 15
010-00205 | 5 | 15
010-00224 | 5 | 15
010-00219 | 5 | 15
010-00139 | 5 | 15
010-00223 | 5 | 15
010-00225 | 5 | 15
010-00239 | 5 | 15
010-00290 | 5 | 15
010-00297 | 5 | 15
010-00296 | 5 | 15
010-00242 | 5 | 15
010-00130 | 5 | 15
010-00243 | 5 | 15
010-00244 | 5 | 15
010-00294 | 5 | 15
010-00246 | 5 | 15
010-00245 | 5 | 15
010-00172 | 5 | 15
010-00158 | 5 | 15
010-00122 | 5 | 15
010-00180 | 5 | 15
010-00270 | 5 | 15
010-00227 | 5 | 15
010-00238 | 5 | 15
010-00140 | 5 | 15
010-00222 | 5 | 15
010-00207 | 5 | 15
010-00216 | 5 | 15
010-00217 | 5 | 15
010-00214 | 5 | 15
010-00126 | 5 | 15
010-00215 | 5 | 15
Spreadsheet: 177702d1346405851-division-formula-div
Sheet: Sheet1

Target | Achieved | % Achieved
-0.1696494236655516 | -9.489910621875 | -55.93836051328706
-1 | 1 | -1 | Calculation should equate positive 200%
12.73003443010886 | 11.1473208645 | 0.875670912415959
3.009428117205542 | -0.41804655625 | -0.1389122916277477
0.169649423665552 | -9.489910621875 | -55.93836051328693
 |  |  | Need one formula to concider all instances
Spreadsheet: 838867d1691482390-profit-and-loss-calculation-pnl-spreadsheet-sample
Sheet: Sheet1

Share Holdings by Value
Share Code | Platform | Country | Type | Allocation | Date | Qty | Price | Allocation | Date | Qty | Price | Allocation | Date | Qty | Price | Allocation | Date | Qty | Price | Allocation | Date | Qty | Price | Allocation | Date | Qty | Price | Allocation | Date | Qty | Price | Allocation | Date | Qty | Price | Allocation | Date | Qty | Price | Total Holding | Average Price | PnL
A200 | CMC | Australia | ETF | Purchase | 2019-01-23 00:00:00 | 100 | 97.5 | Reinvestment | 2022-10-18 00:00:00 | 1 | 107.595594 | Reinvestment | 2023-01-18 00:00:00 | 1 | 116.51123 | Reinvestment | 2023-04-20 00:00:00 | 1 | 119.339331 | Sale | 2023-08-05 00:00:00 | 25 | 120
A2M | CMC | Australia | Equity | Purchase | 2019-02-05 00:00:00 | 400 | 12 | Purchase | 2019-06-04 00:00:00 | 300 | 13.8
AAPL | CMC | USA | Equity | Purchase
AKE | CMC | Australia | Equity | Purchase | 2021-11-24 00:00:00 | 200 | 9.4 | Purchase | 2022-01-21 00:00:00 | 200 | 10.3 | Purchase | 2022-02-14 00:00:00 | 250 | 9 | Purchase | 2022-03-16 00:00:00 | 100 | 9.45 | Purchase | 2022-04-22 00:00:00 | 70 | 12.75 | Purchase | 2022-05-11 00:00:00 | 200 | 10.83 | Purchase | 2022-09-02 00:00:00 | 74 | 13.2 | Purchase | 2023-04-06 00:00:00 | 48 | 10.96 | Purchase | 2023-07-28 00:00:00 | 50 | 15.01
ALU | CMC | Australia | Equity | Purchase | 2018-11-13 00:00:00 | 250 | 22.14 | Purchase | 2019-05-14 00:00:00 | 150 | 30.36
AMZN | CMC | USA | Equity | Purchase | 2022-06-15 00:00:00 | 10 | 150.517
ARKF | CMC | USA | ETF | Purchase | 2021-08-17 00:00:00 | 50 | 71.1194
ARKQ | CMC | USA | ETF | Purchase | 2022-02-14 00:00:00 | 50 | 91.1206
ASML | CMC | USA | Equity | Purchase | 2019-03-08 00:00:00 | 60 | 256.0872 | Purchase | 2019-03-26 00:00:00 | 60 | 264.4732
BHP | CMC | Australia | Equity | Purchase | 2019-03-05 00:00:00 | 200 | 37.3 | Reinvestment | 2023-03-30 00:00:00 | 5 | 46.5903 | Sale | 2023-07-23 00:00:00 | 100 | 67.5
BRK/B | CMC | USA | Equity | Purchase
BRN | CMC | Australia | Equity | Purchase | 2022-01-25 00:00:00 | 1500 | 1.4 | Sale | 2023-05-29 00:00:00 | -1500 | 0.46
BUG | CMC | USA | ETF | Purchase | 2021-07-08 00:00:00 | 40 | 39.728
COL | CMC | Australia | Equity | Purchase
COST | CMC | USA | Equity | Purchase | 2022-06-02 00:00:00 | 5 | 646.11
CPH | CMC | Australia | Equity | Purchase | 2020-01-31 00:00:00 | 3000 | 0.17
CPHO | CMC | Australia | Equity | Purchase | 2020-02-12 00:00:00 | 1500 | 0.145
GM | CMC | USA | Equity | Purchase | 2021-02-02 00:00:00 | 40 | 66.6808 | Sale | 2023-05-23 00:00:00 | -40 | 33.5
IPL | CMC | Australia | Equity | Purchase | 2023-01-27 00:00:00 | 400 | 3.68 | Sale | 2023-05-03 00:00:00 | -400 | 3.1
IXJ | CMC | Australia | ETF | Purchase | 2019-02-26 00:00:00 | 150 | 85 | Reinvestment | 2023-07-13 00:00:00 | 1 | 126.827328
JNJ | CMC | USA | Equity | Purchase
Spreadsheet: 547883d1510788605-is-it-possible-to-use-index-match-as-well-as-if-and-and-in-a-formula-assistance-with-formula
Sheet: Data

Title of Book | Read | Submitted By
I love [NAME] | No | [NAME]
I love [NAME] | Yes | Alicia
I love [NAME] | Yes | [NAME]
I love [NAME] | Yes | Christy
Dogs Rule | Yes | [NAME]
Dogs Rule | No | Betty
Dogs Rule | Yes | Alicia
Dogs Rule | Yes | Christy
Dogs Rule | Yes | [NAME]
*Doritos Are Fantastic* | No | Alicia
*Doritos Are Fantastic* | Yes | [NAME]
*Doritos Are Fantastic* | Yes | [NAME]
Spreadsheet: 126104d1319529716-complex-nested-if-statement-that-uses-and-ors-and-other-conditions-and_or_nested_if
Sheet: Sheet1

DATE | FROM | TO | WAYBILL NUMBER |  | DEDICATED WEIGHT |  | TOTAL WEIGHT |  | MINIMUM WEIGHT |  | MINIMUM CHARGE | CHARGE WEIGHT |  | RATE PER KILO |  | NUMBER OF BOXES |  | RATE PER BOX |  | SUB TOTAL | FUEL LEVY % | FUEL LEVY VALUE | TOTAL AMOUNT
40836 |  |  | 1 |  |  |  | 1000 | [NAME] | 30 | [NAME] | 50 | 970 | [NAME] | 1.3 |  |  | box |  |  | 1261 |  | 0 | 1261 | MINIMUM WEIGHT
40836 |  |  | 1 |  |  |  |  | [NAME] |  | [NAME] |  | 0 | [NAME] | 0 |  | 0 | box | 0 |  | 0 |  | 0 | 0 | UNDER R100  WEIGHT
40836 |  |  | 1 |  |  | [NAME] | 1000 | [NAME] | 30 | [NAME] | 50 | 970 | [NAME] | 1.3 |  |  | box |  |  | 1261 | 0.1 | 126.1 | 1387.1 | DEDICATED WEIGHT
40836 |  |  | 1 |  |  |  | 1000 | [NAME] |  | [NAME] |  | 1000 | [NAME] | 1.3 |  |  | box |  |  | 1300 |  | 0 | 1300 | NORMAL WEIGHT
NOTE THE GREEN BLOCK
Spreadsheet: 149988d1334238335-performance-rating-based-on-percentages-rating-example
Sheet: Rank

 |  | Criteria | [NAME]
 |  | Top 20% | AAA
 |  | Between 10% and 80% | AA
 |  | Less than 10% | A
Name | Score | Incident Efficiency vs Average Score |  | Rating
TEAM MEMBER 1 | 4.077683470878077 | 1.402028035266133
TEAM MEMBER 2 | 4.035640000398126 | 1.387572248117926
TEAM MEMBER 3 | 3.939916620102461 | 1.354659722228302
TEAM MEMBER 4 | 3.924627217936893 | 1.349402774102809
TEAM MEMBER 5 | 3.688623449410776 | 1.268257706746509
TEAM MEMBER 6 | 3.607877874715811 | 1.240494992878569
TEAM MEMBER 7 | 3.549422132919845 | 1.220396182020508
TEAM MEMBER 8 | 3.515818157332042 | 1.20884214252554
TEAM MEMBER 9 | 3.400964351754473 | 1.169352011296183
TEAM MEMBER 10 | 3.353036860103357 | 1.152873123850715
TEAM MEMBER 11 | 3.340352490707715 | 1.14851186294624
TEAM MEMBER 12 | 3.327771712698234 | 1.144186219820499
TEAM MEMBER 13 | 3.28318036508876 | 1.128854397248867
TEAM MEMBER 14 | 3.199680633270069 | 1.100144722801821
TEAM MEMBER 15 | 3.161375354027493 | 1.086974236230134
TEAM MEMBER 16 | 3.156409499322467 | 1.085266828687291
TEAM MEMBER 17 | 3.15362732280176 | 1.084310234211788
TEAM MEMBER 18 | 3.057530604880929 | 1.051269343817946
TEAM MEMBER 19 | 3.052100496997044 | 1.049402312317806
TEAM MEMBER 20 | 3.048932354764677 | 1.048313011428904
TEAM MEMBER 21 | 3.030019562325899 | 1.041810234689682
TEAM MEMBER 22 | 3.016057479010882 | 1.037009657995052
TEAM MEMBER 23 | 2.883803616494194 | 0.9915368731786522
TEAM MEMBER 24 | 2.879865256341645 | 0.9901827486159482
TEAM MEMBER 25 | 2.828397948227493 | 0.972486767701524
TEAM MEMBER 26 | 2.807579250835198 | 0.9653286845373509
TEAM MEMBER 27 | 2.731288050686555 | 0.9390975162241654
TEAM MEMBER 28 | 2.728005265969807 | 0.9379687978625039
TEAM MEMBER 29 | 2.727819047658741 | 0.9379047705061239
TEAM MEMBER 30 | 2.720295808766868 | 0.9353180587327016
TEAM MEMBER 31 | 2.627853266568823 | 0.9035335818995787
TEAM MEMBER 32 | 2.542080288789191 | 0.8740422983376874
TEAM MEMBER 33 | 2.508319334901198 | 0.8624342850658527
TEAM MEMBER 34 | 2.472929132388389 | 0.85026608798752
TEAM MEMBER 35 | 2.433177697432171 | 0.8365983703609055
TEAM MEMBER 36 | 2.390037138646548 | 0.8217653718443567
TEAM MEMBER 37 | 2.354330904819188 | 0.8094885138642677
TEAM MEMBER 38 | 2.268338038804587 | 0.7799216262315221
TEAM MEMBER 39 | 2.192736938115923 | 0.7539277344987585
TEAM MEMBER 40 | 2.177230938905701 | 0.7485963139108667
TEAM MEMBER 41 | 2.121593739630083 | 0.7294666012332647
TEAM MEMBER 42 | 1.935273635859955 | 0.6654042455146234
TEAM MEMBER 43 | 1.928197261088161 | 0.662971178826402
TEAM MEMBER 44 | 1.893899244734527 | 0.651178507613632
TEAM MEMBER 45 | 1.805106864297433 | 0.6206490642225749
Spreadsheet: 9082c711-ec19-41e3-8825-b7f1854050a9
Sheet: Sheet1

[NAME], Maine, 1999-2009, by Year | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Year | Number of Deaths | Crude Rate |  | Age-adjusted Rate
 |  | Rate | 95% CI | Rate | 95% CI
1999 | 3035 | 239.6 | 231.1 - 248.3 | 214.4 | 206.8 - 222.2
2000 | 3070 | 240.4 | 231.9 - 249.0 | 212.7 | 205.2 - 220.3
2001 | 3045 | 237 | 228.7 - 245.6 | 208.2 | 200.9 - 215.8
2002 | 3206 | 247.8 | 239.3 - 256.5 | 215 | 207.6 - 222.6
2003 | 3120 | 239.4 | 231.1 - 248.0 | 205.9 | 198.7 - 213.3
2004 | 3124 | 238.8 | 230.5 - 247.3 | 202.6 | 195.6 - 209.9
2005 | 3218 | 245.3 | 236.9 - 254.0 | 205.8 | 198.7 - 213.1
2006 | 3089 | 234.9 | 226.7 - 243.3 | 194.5 | 187.6 - 201.5
2007 | 3112 | 236.2 | 228.0 - 244.7 | 191.4 | 184.7 - 198.3
2008 | 3093 | 234.4 | 226.2 - 242.8 | 186.3 | 179.7 - 193.1
US 2009 |  |  |  | 175.8 | 175.3 - 176.2
Data Source: Surveillance, Epidemiology, and End Results (SEER )Program, National Cancer Institute, Underlying mortality data provided by National Center for Health Statistics. [NAME]: Deaths with malignant cancer as the underlying cause of death. Cancer: SEER Cause of Death Recode: 20010-37000 (which include 1999-2009: ICD-10 codes C00-C97; 1993-1998: ICD-9 codes 140-208, 238.6). Crude rates are deaths per 100,000 population. Age-adjusted rates are deaths per 100,000 population age-adjusted to the U.S. 2000 standard population. 95% CI: 95% confidence interval of the rate. Rates are calculated using SEER*Stat Version 7.0.5 NA = Not available
Spreadsheet: 690832d1597313485-simple-warehouse-location-management-template-my-sample-wms
Sheet: Rack

Item Code | [NAME] | Quantity | [NAME]
CK1 | CK1 | 9 | A1
CK2 | CK2 | 12 | A1
CK3 | CK3 | 3 | A1
CK4 | CK4 | 54 | A1
CK5 | CK5 | 32 | A1
CA1 | CA1 | 4 | A2
CA2 | CA2 | 231 | A2
CK1 | CK1 | 28 | C2
CK3 | CK3 |  | A2
CA5 | CA5 | 121 | A2
DK1 | DK1 | 12 | B1
DK2 | DK2 | 45 | B1
DK3 | DK3 | 78 | B1
CK3 | CK3 | 44 | B1
DK5 | DK5 | 69 | B1
CK3 | CK3 | 32 | B2
DD2 | DD2 | 47 | B2
DD3 | DD3 | 66 | B2
DD4 | DD4 | 12 | B2
DD5 | DD5 | 79 | B2
CK3 | CK3 | 456 | C1
EK2 | EK2 | 1028 | C1
EK3 | EK3 | 4 | C1
EK4 | EK4 | 63 | C1
EK5 | EK5 | 99 | C1
ED1 | ED1 | 36 | C2
ED2 | ED2 | 62 | C2
ED3 | ED3 | 34 | C2
ED4 | ED4 | 51 | C2
CK3 | CK3 | 71 | C2
CK3 | CK3 | 555 | [NAME]
Spreadsheet: 886969d1737050476-index-match-headaches-test-index-match
Sheet: Oregon

OR ID | Vineyard | Varietal | Type | Date Produced | Manager | Status | OR Specific 1 | OR Specific 2 | OR Specific 3
OR 00017 | Highland | Rose | French | 2024-05-07 02:23:02 | Martin | Completed | [NAME] | Winter | Crushed
OR 00121 | Mad Hippie | Chardonnay | French | 2024-05-08 00:00:00 | Luther | Overdue | [NAME] | Winter | Pressed
OR 00023 | Spitfire | Pinot Noir | American | 2024-05-09 00:00:00 | [NAME] | Completed | Steel | Fall | Pressed
OR02109 | Columbia | [NAME] | German | 2024-05-10 00:00:00 | [NAME] | Completed | Whiskey [NAME] | Summer | Pressed
Spreadsheet: 697027d1601111548-display-multiple-data-in-one-cell-without-summing-whilst-also-excluding-0s-excel-example-for-various-pan
Sheet: Sheet1

 | R | 3 | 7
School 1 | 30 | 0 | 0
School 2 | 30 | 34 | 0
School 3 | 30 | 0 | 240
School 4 | 0 | 0 | 60
School 5 | 0 | 34 | 0
Spreadsheet: 680455d1591029812-searchable-drop-down-list-graph-with-no-data-fortimepoints-assayovertime
Sheet: Metrics

2020 Assay Timeframe
 | Assay | Column
 |  |  |  |  |  | Month | Time (Wks) | Min | [NAME] | Average
 |  |  |  |  |  | 2020-01-01 00:00:00
 |  |  |  |  |  | 2020-02-01 00:00:00
 |  |  |  |  |  | 2020-03-01 00:00:00
 |  |  |  |  |  | 2020-04-01 00:00:00
 |  |  |  |  |  | 2020-05-01 00:00:00
 |  |  |  |  |  | 2020-06-01 00:00:00
 |  |  |  |  |  | 2020-07-01 00:00:00
 |  |  |  |  |  | 2020-08-01 00:00:00
 |  |  |  |  |  | 2020-09-01 00:00:00
 |  |  |  |  |  | 2020-10-01 00:00:00
 |  |  |  |  |  | 2020-11-01 00:00:00
 |  |  |  |  |  | 2020-12-01 00:00:00
Spreadsheet: 868806d1715509289-custom-calendar-help-dynamic-calendar
Sheet: JAN

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | B | C | D
 |  | C |  | B |  | B |  | B |  | B |  | D
 |  | D |  | A |  | A |  | A |  | A |  | C
D |  | D |  | D |  | A |  | A |  | A |  | A
C |  | C |  | C |  | B |  | B |  | B |  | B
C |  | C |  | C |  | C |  | B |  | B |  | B
D |  | D |  | D |  | D |  | A |  | A |  | A
B |  | D |  | D |  | D |  | D |  | A |  | A
A |  | C |  | C |  | C |  | C |  | B |  | B
A |  | A |  | C |  | C
B |  | B |  | D |  | D
Spreadsheet: mary_fischer__25717__Consolidated of 890 20Q 20R 1572
Sheet: May

Enron Energy Services
MTM Summary
Company 890
 |  |  |  | Beginning |  |  |  | Ending
Date |  | Account MSA/SAP |  | Balance |  | Change |  | Balance
2001-05-01 00:00:00 |  | 1740-310/2106-0000 |  | 50493145 |  |  |  | 22635921
2001-05-01 00:00:00 |  | 1860-310/2510-0000 |  | 587035369 |  |  |  | 669839169
2001-05-01 00:00:00 |  | 1860-330/2510-0100 |  | -55096987 |  |  |  | -125234340
2001-05-01 00:00:00 |  | 1860-320/2510-0200 |  | 831595 |  |  |  | -7503969
2001-05-01 00:00:00 |  | 2420-310/3030-0000 |  | -448393114 |  |  |  | -372449169
2001-05-01 00:00:00 |  | 2530-310/3310-0000 |  | -115116482 |  |  |  | -358013988
 |  |  |  |  |  | Ending
Date |  | Account |  |  |  | Balance
2001-05-01 00:00:00 |  | 4923-999/4200-0000 |  |  |  | 170479902
 |  | Difference
Spreadsheet: db60df3c-f8db-49c5-bd03-da82512d9490
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
2839 | 15564 | Josiah | Middaugh | USA | 0 | 00:29:46 | 00:00:43 | 00:52:22 | [NAME] | 00:33:45 | 1 | 01:57:29
2839 | 8278 | [NAME] | [NAME] | USA | 0 | 00:30:44 | 00:01:12 | 00:53:25 | 00:01:21 | 00:35:09 | 2 | 02:01:51
2839 | 15567 | Lars | Finanger | USA | 0 | 00:31:22 | 00:01:04 | 00:51:13 | [NAME] | 00:37:28 | 3 | 02:02:34
2839 | 15602 | [NAME] | [NAME] | USA | 0 | 00:36:57 | 00:01:58 | 01:05:19 | 00:03:08 | 00:55:39 | 4 | [NAME]
Spreadsheet: 255d1d53-7ccd-4a35-bf07-699b18e73cc7
Sheet: 9c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Fixed-Float | 328080 | 15316 | 93750 | 195741 | 603602 | 346099 | 163612 | 28762 | 1774962
OTHER* | 166539 | 215323 | 271221 | 220872 | 85225 | 38364 | 46418 | 6564 | 1050526
TOTAL | 494619 | 230639 | 364971 | 416613 | 688827 | 384463 | 210030 | 35326 | 2825488
*OTHER variable includes the following products: FRA, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, Inflation, OIS, Swaption, and Basis.
Spreadsheet: 112182d1308310683-dynamic-charts-in-excel-create-chart-with-the-last-12-entries-example_charting_4_using_offsets
Sheet: Summary_Indexing_Offset

Month | Yld1 | Target | Yld2 | Length
2010-04-01 00:00:00 | 29897 | 0.95 |  | 12
2010-05-01 00:00:00 | 35192 | 0.95 | 0.9721546961325966
2010-06-01 00:00:00 | 35365 | 0.95 | 0.98
2010-07-01 00:00:00 | 28803 | 0.95 | 0.98
2010-08-01 00:00:00 | 28013 | 0.95 | 0.98
2010-09-01 00:00:00 | 27343 | 0.95 | 0.97
2010-10-01 00:00:00 | 30088 | 0.95 | 0.97
2010-11-01 00:00:00 | 28295 | 0.95 | 0.97
2010-12-01 00:00:00 | 32194 | 0.95 | 0.95
2011-01-01 00:00:00 | 31690 | 0.95 | 0.98
2011-02-01 00:00:00 | 28039 | 0.95 | 0.98
2011-03-01 00:00:00 | 33277 | 0.95 | 0.92
2011-04-01 00:00:00 | 31114 | 0.95 | 0.9788198238734974
2011-04-01 00:00:00 | 30455 | 0.95 | 0.9788198238734974
2011-05-01 00:00:00 | 15 | 0.15 | 0.84
2011-06-01 00:00:00 | 30455 | 0.15 | 0.84
2011-07-01 00:00:00 | 30455 | 0.15 | 0.84
2011-05-01 00:00:00 | 30455 | 0.15 | 0.84
2011-09-01 00:00:00 | 30455 | 0.2 | 0.95
2011-09-01 00:00:00 | 30455 | 0.2 | 0.95
 |  |  |  |  |  |  |  | SERIES(Summary_Indexing_Offset!$B$1,Summary_Indexing_Offset!chtcats,[NAME])
 |  |  |  |  |  |  |  | SERIES(Summary_Indexing_Offset!$c$1,Summary_Indexing_Offset!chtcats,Summary_Indexing_Offset!chtvalb,2)
 |  |  |  |  |  |  |  | SERIES(Summary_Indexing_Offset!$d$1,Summary_Indexing_Offset!chtcats,Summary_Indexing_Offset!chtvalc,3)
 |  |  |  |  |  | chtcats |  | OFFSET(Summary_Indexing_Offset!$A$1,COUNTA(Summary_Indexing_Offset!$A:$A)-1,0,-MIN(Summary_Indexing_Offset!chtlen,COUNTA(Summary_Indexing_Offset!$A:$A)-1),1)
 |  |  |  |  |  | chtlen |  | Summary_Indexing_Offset!$e$2
 |  |  |  |  |  | [NAME] |  | OFFSET(Summary_Indexing_Offset!chtcats,0,1)
 |  |  |  |  |  | chtvalb |  | OFFSET(Summary_Indexing_Offset!chtcats,0,2)
 |  |  |  |  |  | chtvalc |  | OFFSET(Summary_Indexing_Offset!chtcats,0,3)
Spreadsheet: 33300d1229608730-copying-subtotals-subt
Sheet: Sheet1

H1 | Tot |  |  |  | H1 | Tot |  | H1 | Tot
aa | 1 |  |  |  |  |  |  | aa Total | 4
aa | 2 |  |  |  |  |  |  | bb Total | 12
aa | 1 |  |  |  |  |  |  | Grand Total | 16
aa Total | 4
bb | 3
bb | 5
bb | 4
bb Total | 12
Grand Total | 16
Spreadsheet: 60536a3a-c329-4998-9851-6b0171c56271
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | URGENT Requests Require Division AVP/VP Approval:________________________________ | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21
PUBLIC WORKS Requisition
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date Requested: | 2012-05-21 00:00:00
VENDOR |  | Name and Address:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Originator:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Department:
 |  | Project Contact: |  |  |  |  |  |  |  |  |  |  |  |  |  | Phone:
 |  | Phone: |  |  |  |  |  |  |  | Fax:
 |  | E-Mail: |  |  |  |  |  |  |  |  |  |  |  |  |  | E-Mail:
 | Payment Terms:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CMA Project Contact:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Procurement Office Use Only
 | Risk Analysis: |  |  |  |  |  |  |  |  |  |  |  |  | Date Received:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Vendor #:
 | Insurance Requirements:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PO #:
 | Scope of Work / Specifications
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Warranty (if applicable): |  |  |  |  |  |  |  |  |  |  |  |  | NTE: |  | 500
 |  | Requisition Request Over $5,000:
 |  |  |  | If yes,   Project Flow Chart Attached |  |  |  |  |  |  |  |  | (Requisition over 5k, allow 8 weeks for Advertising and Selection)
 |  | Services Dates: |  |  |  |  |  | Start Date: |  |  |  |  |  | End Date:
 |  | List of Deliverables:
 |  |  | Are any deliverables taxable?
 |  |  |  |  |  |  |  |  |  | Facilities and or University Planner Signature
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Split |  | Accounting Approval
 | Account |  |  |  |  | Fund |  |  |  | Dept ID |  |  | Class |  | % | $ [NAME] | Initials |  | Date
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | REQUIRED FOR ALL REQUISITIONS:
 |  | I certify that the goods & services requested are necessary for the operation of the department, that there are sufficient funds to cover the expense, and that I am authorized to approve such expenses.
 |  | Authorized Dept/Unit Head Signature |  |  |  |  |  |  |  |  |  |  |  | VP Approval (as needed)
Spreadsheet: 586635d1534490448-select-rows-between-blank-rows-using-power-query-sample
Sheet: FINAL Placement 1

Placement 1
Size | Click URL | ID Col | Source | Method | Desc Spot | StartDate | EndDate | Rot | Notes
1x1 | Site.com | 456 |  | Upload | [NAME] | 2018-08-02 00:00:00 | 2018-10-31 00:00:00 | 100
1x1 | Site.com | 456 |  | Upload | [NAME] | 2018-08-02 00:00:00 | 2018-10-31 00:00:00 | 100
Spreadsheet: 165293d1341147424-repeat-a-combination-of-rows-and-columns-ok-this-one-then
Sheet: Sheet2

A | 1000
A | ABCD
A | X
A | rty
A | ghj
B | 1000
B | ABCD
B | X
B | rty
B | ghj
C | 1000
C | ABCD
C | X
C | rty
C | ghj
DF | 1000
DF | ABCD
DF | X
DF | rty
DF | ghj
123 | 1000
123 | ABCD
123 | X
123 | rty
123 | ghj
m | 1000
m | ABCD
m | X
m | rty
m | ghj
t | 1000
t | ABCD
t | X
t | rty
t | ghj
Spreadsheet: 218642d1362519663-multiple-nested-and-functions-in-an-if-statement-objectives-and-competencies-3-
Sheet: Sheet1

Objective | Competences | Comment
1 | Achieved | comment A
2 | Exceed | comment B
3 | Achieved | comment C
4 | Some Development Needs | comment D
5 | Underperformed | comment E
6 | Exceed | comment F
7 | Achieved | comment G
8 | Some Development Needs | comment H
9 | Underperformed | comment I
10 | Achieved | comment J
11 | Achieved | comment K
12 | Some Development Needs | comment L
13 | Underperformed | comment M
14 | Underperformed | comment N
15 | Underperformed | comment O
16 | Underperformed | comment P
Objective | 9
Competence
Comment
Exceed
Achieved
Some Development Needs
Underperformed
Spreadsheet: 186420d1350036886-search-beers
Sheet: N

Brewery |  | Beer
Nethergate ([NAME]) |  | Old [NAME]
 |  | [NAME]
 |  | [NAME]
Newale |  | [NAME]
Nevadd Arms |  | [NAME]
[NAME] |  | [NAME]
[NAME] |  | Two Henry’s Bitter
 |  | THAT
[NAME] |  | Erasimus Dark
 |  | Flying Herbert
 |  | [NAME]
Northumberland |  | County
 |  | Holy Shit
 |  | Bucking Fastard