tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 772584d1647373622-conditional-formatting-of-scheduled-times-outside-of-staff-availability-schedule-availability
Sheet: Sheet1

 | Name | Shift Start | Shift End | Availablity Start | Availability End
 | [NAME] | 1900-01-01 05:15:00 | 21:00:00 | 06:00:00 | 1900-01-01 04:30:00
 | [NAME] | 1900-01-01 05:45:00 | 16:30:00 | 06:00:00 | 1900-01-01 04:30:00
 | Norma | 21:00:00 | 1900-01-01 05:00:00 | 06:00:00 | 1900-01-01 04:30:00
 | Effie | 18:00:00 | 1900-01-01 02:00:00 | 18:00:00 | 1900-01-01 04:30:00
 | George | 14:00:00 | 22:00:00 | 06:00:00 | 1900-01-01 04:30:00
Spreadsheet: 838748d1691347332-xlookup-returns-n-a-example-xlookup
Sheet: Tab 2

Row Labels | 2019A - JAN | 2019A - FEB
Client 1
2 | 67739 | 74663
6 | 27927 | 10863
7 | 58015 | 90542
1 | 52876 | 92035
3 | 11485 | 16000
5 | 43658 | 93866
4 | 15983 | 19791
Spreadsheet: 674104d1587661064-how-to-get-formula-to-return-unique-values-copy-of-example-1
Sheet: Source

Project Name | Week End Date | Employee Name
Client1 | 02-29-2020 | [NAME]
Client1 | 02-29-2020 | [NAME]
Client1 | 02-29-2020 | [NAME]
Client1 | 02-29-2020 | [NAME]
Client1 | 03-07-2020 | [NAME]
Client1 | 03-14-2020 | [NAME]
Client1 | 03-21-2020 | [NAME]
Client1 | 03-28-2020 | [NAME]
Spreadsheet: 885506d1735157838-trying-to-match-entries-in-two-different-spreadsheets-please-help-match-co-v-tax
Sheet: Tax

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
Local | P000593540R | CROWN PAINTS KENYA PLC | 45608 | 0020111770000446339 | ETIMS/TIMS purchases |  | 146597.6
Local | P000593540R | CROWN PAINTS KENYA PLC | 45608 | 0020111770000446377 | ETIMS/TIMS purchases |  | 159781.2
Local | P000593540R | CROWN PAINTS KENYA PLC | 45608 | 0020111770000446236 | ETIMS/TIMS purchases |  | 23537.4
Local | P000596247D | BASCO PRODUCTS (K) LTD | 45608 | 0190432540000062860 | ETIMS/TIMS purchases |  | 35648
Local | P051099009C | CLASSIC IRON MONGERS LIMITED | 45608 | 0110164200000039627 | ETIMS/TIMS purchases |  | 517457.5
Local | P051099009C | CLASSIC IRON MONGERS LIMITED | 45608 | 0110164200000039625 | ETIMS/TIMS purchases |  | 517457.5
Local | P000597083J | [NAME] | 45608 | 0040074300000027733 | ETIMS/TIMS purchases |  | 26600
Local | P000613055P | ASSA ABLOY (EAST AFRICA) LIMITED | 45608 | 0040096490000038925 | ETIMS/TIMS purchases |  | 772759.62
Local | P000618782L | [NAME] | 45608 | 0110609580000012103 | ETIMS/TIMS purchases |  | 146000
Local | P000613055P | ASSA ABLOY (EAST AFRICA) LIMITED | 45608 | 0040096490000038915 | ETIMS/TIMS purchases |  | 691603.92
Local | P000605924U | Tononoka [NAME] | 45608 | 0110600340000023189 | ETIMS/TIMS purchases |  | -120858.38
Local | P000605924U | Tononoka [NAME] | 45608 | 0110600340000023190 | ETIMS/TIMS purchases |  | -80866.36
Local | P000593540R | CROWN PAINTS KENYA PLC | 45608 | 0020111770000446369 | ETIMS/TIMS purchases |  | 17741.07
Local | P051394728G | KEEPINGS TRADING LIMITED | 45608 | 0040092980000004823 | ETIMS/TIMS purchases |  | -9375.7
Spreadsheet: 94404d1294237735-formula-to-retrieve-a-value-when-there-are-3-criteria-data-input
Sheet: Sheet1

 |  | 2011-01-04 00:00:00 |  |  |  |  |  | 2011-01-05 00:00:00 |  |  |  |  |  | 2011-01-06 00:00:00
 |  | UNIT 1 |  | UNIT 2 |  | UNIT 3 |  | UNIT 1 |  | UNIT 2 |  | UNIT 3 |  | UNIT 1 |  | UNIT 2 |  | UNIT 3
 | PRODUCT 1 | 6 |  |  |  |  |  | 5 |  |  |  |  |  | 12
 | PRODUCT 2 |  |  | 5 |  |  |  |  |  | 25 |  |  |  |  |  | 24
 | PRODUCT 3 | 8 |  |  |  |  |  | 45 |  |  |  |  |  | 4
 | PRODUCT 4 | 7 |  |  |  |  |  | 65 |  |  |  |  |  | 11
 | PRODUCT 5 |  |  |  |  | 4 |  |  |  |  |  | 5 |  |  |  |  |  | 8
 | PRODUCT 6 |  |  | 8 |  |  |  |  |  | 9 |  |  |  |  |  | 11
 | PRODUCT 7 | 9 |  |  |  |  |  | 4 |  |  |  |  |  | 15
 |  | THIS [NAME] IS FOR USERS TO INPUT DATA IN.
Spreadsheet: 809809d1671335244-how-to-only-show-data-on-page-soa-mo-10-lf-there-is-data-in-gl-mo-10-tst-1-
Sheet: Budget vs. Actual 

Budget to Actual YTD
 |  |  |  | Month # | 0
 |  |  |  |  | Cash Beginning of Period
 |  |  | Actuals | Budget | Linear Budget YTD | YTD Actuals
 |  |  | Previous Yr
 |  | Tiendes
 |  | Tiendes
 |  | Tiendes
 |  | Tiendes
 |  | Tiendes
 |  | ekstra
 |  | ekstra
 |  | ekstra
 |  | Total Revenue:
 |  | Uitgawes:
 |  | [NAME] Ds [NAME]
 |  | [NAME] Ds Pieter**
 |  | Lone (Tuinier)(Eric)
 |  | Lone (Skoonmaker)
 |  | Lone (Week 3)
 |  | Lone (Week 4)
 |  | Lone (Week 5)
 |  | Total Expenses:
 | Net : Income Gain / (Loss)
 | Cash End of Period
Spreadsheet: 464967d1465391231-error-while-checking-the-check-boxes-474-checkboxes-and-graph
Sheet: Sheet2

 | Week | Period | Total Blogs | Pageviews | Unique page views | Sessions | Users | Bounce rate | Top blog Link
 | W01 | Jan 28 to Feb 03 |  | 683 | 402 | 230 | 191 | 0.5087
 | W02 | Feb 04 to Feb 10 |  | 571 | 393 | 226 | 198 | 0.4867
 | [NAME] | Feb 11 to Feb 17 |  | 699 | 416 | 235 | 194 | 0.5191
 | W04 | Feb 18 to Feb 24 |  | 813 | 471 | 268 | 237 | 0.5112
 | [NAME] | Feb 25 to Mar 02 |  | 622 | 376 | 225 | 204 | 0.5689
 | W06 | Mar 03 to Mar 09 |  | 880 | 509 | 272 | 226 | 0.5368
 | W07 | [NAME] |  | 831 | 543 | 332 | 293 | 0.5813
 | W08 | Mar 17 to Mar 23 |  | 1108 | 688 | 457 | 407 | 0.5733
 | W09 | [NAME] |  | 854 | 543 | 318 | 294 | 0.5566
 | W10 | Mar 31 to Apr 06 |  | 921 | 564 | 357 | 320 | 0.5994
 | W11 | Apr 07 to Apr 13 |  | 895 | 582 | 317 | 280 | 0.5552
 | W12 | Apr 14 to Apr 20 |  | 965 | 615 | 317 | 280 | 0.5773
 | W13 | Apr 21 to Apr 27 |  | 1078 | 681 | 377 | 341 | 0.5597
 | W14 | Apr 28 to May 04 |  | 810 | 499 | 346 | 318 | 0.6243
 | W15 | May 05 to May 11 |  | 748 | 483 | 313 | 289 | 0.623
 | W16 | May 12 to May 18 |  | 1042 | 620 | 410 | 379 | 0.6341
 | W17 | May 19 to May 25 |  | 736 | 470 | 271 | 256 | 0.5461
 | W18 | May 26 to June 01 |  | 960 | 572 | 354 | 321 | 0.6045
Spreadsheet: 881275d1729275987-number-of-months-in-a-given-fiscal-year-according-to-end-date-classeur2
Sheet: Feuil1

 |  |  |  |  |  |  |  | Number of months | End date
 |  |  |  |  |  |  |  | 7 | 2025-09-20 00:00:00
Note: | Year starts on April 1st and ends on March 31st
 |  |  | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033
 |  |  | 2024-04-01 00:00:00 | 2025-04-01 00:00:00 | 2026-04-01 00:00:00 | 2027-04-01 00:00:00 | 2028-04-01 00:00:00 | 2029-04-01 00:00:00 | 2030-04-01 00:00:00 | 2031-04-01 00:00:00 | 2032-04-01 00:00:00 | 2033-04-01 00:00:00
 |  |  | How many months in 2024 (from April 1st 2024 to March 31st 2025), according to the end date in J2 and the number of months in I2? | How many months in 2025 (from April 1st 2025 to March 31st 2026), according to the end date in J2 and the number of months in I2? | Etc. | Etc. | Etc. | Etc. | Etc. | Etc. | Etc. | Etc.
 | Result should be : |  | 1 | 6
Spreadsheet: 692570d1598436010-look-up-between-2-table-for-match-data-with-no-order-test
Sheet: table1

CODE | Text
[PHONE]/000 | A conserver au réfrigérateur (0-8°C). A consommer de préférence avant le : voir sur le couvercle
[PHONE]/000 | Naturellement riche en Oméga 3
[PHONE]/000 | Sans huile de palme
[PHONE]/000 | Sans lait et sans lactose
[PHONE]/000 | Une texture onctueuse unique, sans huile de palme, grâce aux huiles de karité et de coco
[PHONE]/000 | [NAME] pression d'un mélange de graines de tournesol, [NAME], colza
[PHONE]/000 | Sans arômes artificiels
[PHONE]/000 | Sans conservateur
[PHONE]/000 | 100% végétal
[PHONE]/000 | Convient aux végétaliens
[PHONE]/000 | Sans lactose
[PHONE]/000 | Sans gluten
Spreadsheet: 409cd771-764d-4726-826b-98b04012b5d3
Sheet: Sheet1

Global X Brazil Financials ETF | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  |  |  | Fund Holdings Data as of 5/24/2013
% of Net Assets | Name | Identifier | Market Price($) | Shares Held | Market Value($)
11.05 | ITAU UNIBANCO BANCO ADR | 465562106 | 16 | 27690.3 | 443044.8
10.59 | BANCO BRADESCO SPON ADR | 59460303 | 16.75 | 25344 | 424512
10.03 | BANCO SANTANDER ADR | 05967A107 | 7.42 | 54162 | 401882.04
5.62 | BANCO DO BRASIL | 2328595 | 13.05 | 17253 | 225106.77
5.11 | CIELO SA | B614LY3 | 26.43 | 7748 | 204750.36
4.98 | BANCO BTG PACTUAL SA | B7MBV73 | 16.18 | 12337 | 199568.68
4.89 | BM&F BOVESPA SA | B2RHNV9 | 6.96 | 28166 | 195895.61
4.84 | SUL AMERICA SA | B27WYK0 | 7.21 | 26910.3991 | 193983.09
4.62 | CYRELA BRAZIL REALTY | 2189855 | 9.21 | 20085 | 185015.96
4.53 | CETIP SA-MERCADOS COM NPV | B55DVB6 | 11.99 | 15154 | 181692.9
4.44 | MULTIPLAN EMPREENDIMENTOE | B23DZG0 | 28.51 | 6248 | 178114.06
3.73 | BR MALLS PARTICIPACOES SA | B1RYG58 | 11.54 | 12974 | 149674.46
3.72 | BR PROPERTIES SA | B1FLW42 | 10.68 | 13974 | 149224
3.68 | PDG REALTY SA | B1N9YL9 | 1.29 | 114322 | 147656.05
3.2 | BANCO ESTADO RIO GRANDE | B23F8S9 | 8.24 | 15558 | 128149.24
2.79 | PORTO SEGURO SA | B0498T7 | 13.15 | 8511 | 111959.01
2.54 | MRV ENGENHARIA | B235JN1 | 3.78 | 26869 | 101622.24
2.17 | EVEN CONSTRUTORA E INC | B1VD2Z3 | 4.45 | 19529 | 86901.31
1.69 | EZ TEC EMPREENDIMENTOS E | B1YW5V4 | 15.14 | 4485 | 67917.12
1.16 | BANCO PANAMERICANO SA | B2940Z1 | 3.21 | 14471 | 46479.29
1.15 | IGUATEMI EMP DE | B1NXMK6 | 12.96 | 3544 | 45929.07
0.94 | BRASIL BROKERS PARTICI | B28XFX2 | 3.37 | 11234 | 37834.5
0.79 | BANCO ABC BRASIL SA | B23DMP8 | 7.39 | 4299 | 31764.51
0.61 | ROSSI RESIDENCIAL SA | B0WPDR0 | 1.9 | 12974 | 24597.96
0.57 | [NAME] | B1FY4S9 | 0.97 | 23683 | 22970.23
0.23 | CASH | CASH | 0.64 | 14478.93 | 9261.46
0 | CETIP SA-RTS | B976ND7 | 0.41 | 9 | 3.73
Spreadsheet: darrell_schoolcraft__7825__imbalsumm0109
Sheet: EPFS

 | El Paso/TW Eddy Rec
 | 78093
Day | Measured | Scheduled
1 | 35974 | 36623
2 | 35392 | 33797
3 | 33223 | 35432
4 | 31492 | 36700
5 | 35052 | 36700
6 | 36108 | 36700
7 | 35863 | 32076
8 | 36319 | 36700
9 | 35937 | 36700
10 | 35688 | 36700
11 | 29460 | 36700
12 | 41778 | 36700
13 | 41979 | 33000
14 | 28295 | 32700
15 | 36955 | 33000
16 | 36326 | 33000
17 | 33412 | 33000
18 | 35087 | 33000
19 | 35961 | 33000
20 | 35534 | 34732
21 | 37450 | 36000
22 | 36078 | 40000
23 | 36669 | 40000
24
25
26
27
28
29
30
31
2001-08-31 00:00:00 |  |  | -36028.7
2001-09-23 00:00:00
CBS Volume
 |  |  | -1370
Spreadsheet: 813154d1673586579-cost-allocation-schedule-once-trigger-engaged-sample-cost-allocation_v2
Sheet: Sheet1

 |  | Challenge: | I want the cost of the project to begin allocating the project cost ($1m) in the month the project starts (March 2023).
 |  | Project cost: | 1000000
 |  | Month | Cost Allocation |  |  |  | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00 | 2025-08-01 00:00:00 | 2025-09-01 00:00:00 | 2025-10-01 00:00:00 | 2025-11-01 00:00:00 | 2025-12-01 00:00:00
 |  | 1 | 0.02
 |  | 2 | 0.05 |  |  | First project starts |  |  | 1
 |  | 3 | 0.05 |  |  | Subtotal of first project started
 |  | 4 | 0.08
 |  | 5 | 0.12 |  |  | Second project starts |  |  |  |  | 1
 |  | 6 | 0.165 |  |  | Subtotal of second project started
 |  | 7 | 0.165
 |  | 8 | 0.12 |  |  | DESIRED OUTPUT
 |  | 9 | 0.08
 |  | 10 | 0.05
 |  | 11 | 0.05
 |  | 12 | 0.05
 |  | Total
Spreadsheet: 3c5f68f8-6362-44ea-a30a-2c6dc2268aef
Sheet: Sheet1

Release: Harmonized Indices of Consumer Prices (HICP) | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=251
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-10-22 3:59 AM CDT
 | Real-Time | Period
Name: | Start | End
Harmonized Indices of Consumer Prices (HICP) | 2012-06-15 00:00:00 | Current
Link:
http://epp.eurostat.ec.europa.eu/portal/page/portal/hicp/data/main_tables | 2012-06-15 00:00:00 | Current
Source:
Eurostat | 2012-06-15 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2012-06-15 00:00:00
2012-07-15 00:00:00
2012-08-16 00:00:00
2012-09-14 00:00:00
2012-10-16 00:00:00
2012-11-15 00:00:00
2012-12-14 00:00:00
2013-01-16 00:00:00
2013-02-28 00:00:00
2013-03-15 00:00:00
2013-04-16 00:00:00
2013-05-16 00:00:00
2013-06-14 00:00:00
2013-07-16 00:00:00
2013-08-16 00:00:00
2013-09-16 00:00:00
2013-10-16 00:00:00
2013-11-15 00:00:00
2013-12-20 00:00:00
2014-01-21 00:00:00
2014-02-24 00:00:00
2014-03-17 00:00:00
2014-04-21 00:00:00
2014-05-16 00:00:00
2014-06-16 00:00:00
2014-07-17 00:00:00
2014-08-14 00:00:00
2014-09-17 00:00:00
2014-10-21 00:00:00
Spreadsheet: 883658d1732289168-stuck-filtering-table-data-and-forcing-automatic-updates-emp_test
Sheet: M

Emoloyee ID | Office | Name | Mon Hours
643 | ACC | Smith, [NAME] | 4
443 | LOG | [NAME], Pam | 6
236 | FIN | Jones, [NAME] | 8
976 | FIN | [NAME], Greg | 8
*This is a manual copy and paste effort. I need the data from EmpHours to feed into here and auto update if change s
Spreadsheet: 119655d1314640558-divide-shipping-between-line-items-sample
Sheet: Sheet1

 | Type | Date | Ship Date | Num | Item | Qty | Sales Price | Online Shipping | Online Discount
18471 | Invoice | 2010-03-16 00:00:00 | 2010-03-18 00:00:00 | 100054 | 4212CC10-MYS-6 | 1 | 68 | 9.95 | -9.95
18472 | Invoice | 2010-03-16 00:00:00 | 2010-03-18 00:00:00 | 100054 | 4207CC10-MYS-6 | 1 | 110 | 9.95 | -9.95
19811 | Invoice | 2010-03-17 00:00:00 | 2010-03-17 00:00:00 | 100055 | 4201CC10-MYS-16 | 1 | 110 | 9.95 | -9.95
19184 | Invoice | 2010-03-17 00:00:00 | 2010-03-18 00:00:00 | 100056 | 4208CC-ONX-12 | 1 | 68 | 4.95 | -4.95
21146 | Invoice | 2010-03-18 00:00:00 | 2010-03-18 00:00:00 | 100057 | 4208CC-IND-14 | 0 | 64.6 | 4.95 | -4.95
21147 | Invoice | 2010-03-18 00:00:00 | 2010-03-18 00:00:00 | 100057 | 4208CC-ONX-14 | 1 | 64.6 | 4.95 | -4.95
22655 | Invoice | 2010-03-18 00:00:00 | 2010-03-19 00:00:00 | 100059 | 4207CC10-WHT-6 | 1 | 110 | 9.95 | -9.95
22656 | Invoice | 2010-03-18 00:00:00 | 2010-03-19 00:00:00 | 100059 | 4207CC10-MYS-6 | 1 | 110 | 9.95 | -9.95
23415 | Invoice | 2010-03-19 00:00:00 | 2010-03-23 00:00:00 | 100062 | 4204CC10-MYS-10 | 1 | 110 | 9.95 | -9.95
24133 | Invoice | 2010-03-20 00:00:00 | 2010-03-22 00:00:00 | 100063 | 4601S-BLKS-M | 1 | 68 | 14.95 | -14.95
24134 | Invoice | 2010-03-20 00:00:00 | 2010-03-22 00:00:00 | 100063 | 4601S-BLKS-L | 1 | 68 | 14.95 | -14.95
24135 | Invoice | 2010-03-20 00:00:00 | 2010-03-22 00:00:00 | 100063 | 4201CC19-RVR-8 | 1 | 110 | 14.95 | -14.95
24136 | Invoice | 2010-03-20 00:00:00 | 2010-03-22 00:00:00 | 100063 | 4208CC-ONX-10 | 1 | 68 | 14.95 | -14.95
24137 | Invoice | 2010-03-20 00:00:00 | 2010-03-22 00:00:00 | 100063 | 4604S-BLKS-M | 1 | 68 | 14.95 | -14.95
24138 | Invoice | 2010-03-20 00:00:00 | 2010-03-22 00:00:00 | 100063 | 4604PDIT-BLK_3-M | 1 | 68 | 14.95 | -14.95
Spreadsheet: 140288d1328686213-formula-to-calculate-criteria-and-sum-results-in-cell-forum-test
Sheet: 24-feb

PRODUCTION PLAN |  |  |  | SKU'S / CASE | KG / CASE | WSTAGE CALC | CASES / HOUR
 | CYCLE BEGINNING |  |  |  |  |  |  |  |  | Lots of columns
 |  |  |  |  |  |  |  |  | Fri
 |  |  |  |  |  |  |  |  | 2012-02-24 00:00:00
Line 1 | 1.0KG | Prod Number 1 | Description | 5 | 5 | 1.02 | 126 | TYPE 1 | 270
 | 1.0KG | Prod Number 2 | Description | 5 | 5 | 1.02 | 1426 | TYPE 2 | 0
 | 1.0KG | Prod Number 3 | Description | 5 | 5 | 1.02 | 126 | TYPE 3 | 0
 | 1.0KG | Prod Number 4 | Description | 5 | 5 | 1.02 | 105 | TYPE 1 | 400
 | 200 G | Prod Number 5 | Description | 12 | 1.2 | 1.02 | 62 | TYPE4 | 0
 | 100 G | Prod Number 6 | Description | 36 | 3.6 | 1.02 | 46 | TYPE 3 | 0
 | TOTAL HOURS FOR LINE 1
 | 250 G | Prod Number 9 | Description | 12 |  | 1.02 | 90 | TYPE 1 | 270
Line 2 | 250 G | Prod Number 10 | Description | 12 |  | 1.02 | 90 | TYPE 4 | 0
 | 1.0KG | Prod Number 11 | Description | 6 | 6 | 1.02 | 148 | TYPE 5 | 0
 | 1.0KG | Prod Number 12 | Description | 6 | 6 | 1.02 | 148 | TYPE 2 | 0
 | 1.0KG | Prod Number 13 | Description | 6 | 6 | 1.02 | 148 | TYPE 3 | 0
 | 1.0KG | Prod Number 14 | Description | 6 | 6 | 1.02 | 148 | TYPE 3 | 0
 | 1.0KG | Prod Number 15 | Description | 6 | 6 | 1.02 | 148 | TYPE 1 | 0
 | 1.0KG | Prod Number 16 | Description | 6 | 6 | 1.02 | 148 | TYPE 2 | 0
 | 1.0KG | Prod Number 17 | Description | 6 | 6 | 1.02 | 148 | TYPE 4 | 230
 | 250 G | Prod Number 18 | Description | 12 | 3 | 1.02 | 90 | TYPE 1 | 0
 | TOTAL HOURS FOR LINE 2
 | Type 1
 | Type 2
 | Type 3
 | Type 4
 |  |  |  |  |  |  |  |  | Here is where I am asking for a formula
Spreadsheet: 0d0f66dd-dd49-439d-93ee-c9d7d3824f9e
Sheet: SectorPart1

Industrial Stormwater Discharge Monitoring Report - 1200-Z Permit
Permittee Legal Name: |  |  |  |  |  | ODEQ File No./Facility ID:
Facility Common Name: |  |  |  |  |  | Reporting Period: |  | July 1, |  | to | June 30,
Facility Location: |  |  |  |  |  | Laboratory Name:
County: |  |  |  |  |  | ORELAP# |  |  |  | SIC Code(s):
Sector Specific Benchmark Sampling: 4 times per year, every year
Please refer to the permit assignment letter to determine if sector specific benchmark sampling is required.
Name or Number of Sampling Point(s) (group data per sampling point) |  | Sample Date | Iron, Total | Aluminum, Total | Nitrate + Nitrite Nitrogen | COD | BOD5 | Ammonia | Phosphorus, Total | Arsenic, Total | Cadmium, Total | Mercury, Total | Nickel, Total
 |  |  | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L
Geometric Mean
Geometric Mean
Geometric Mean
Geometric Mean
Permit Benchmark |  |  | 1 | 0.75 | 0.68 | 120 | 30 | 2.14 | 2 | 0.15 | 0.001 | 0.0014 | 0.5
Page 3
Spreadsheet: 887290d1737526812-schedule-calendar-cover-school-copy-of-absence-timetable-v1
Sheet: Sal

Period | Time | Monday | Tuesday | Wednesday | Thursday | Friday
Period 1 | 0800 -0830 | Drayke 2.3 (Literacy) |  | Drayke 2.3 (Literacy) | Drayke 2.3 (Maths) | 7:45 ALN Dept Meeting
 | 0830-0900 |  | BN.1 outdoors |  |  | BN.1 outdoors
Period 2 | 0900-0930 | N/C | N/C | N/C | N/C | N/C
 | 0930-1000 | N/C | [NAME] |  | [NAME] | [NAME]
Period 3 | 1000-1030 | DUTY - Infant Area | BREAK | BREAK | DUTY - Central Playground | BREAK
 | 1030-1100
Period 4 | 1100-1130 | BN.1 Infant playground | [NAME] | BN.1 Infant playground
 | 1130-1200 | N/C | N/C | N/C | N/C | N/C
Spreadsheet: 552167d1513337840-sorting-multiple-columns-with-linked-data-logins-sample
Sheet: Sheet1

WEBSITE | BRANCH | USERNAME | PASSWORD
[NAME] | [NAME] | 12345 | password
 | Shotton | 5878 | password2
 | Penyffordd | 1248 | password3
NVS | [NAME] | 2316354 | password4
 | Shotton | 365498745 | password5
 | Penyffordd | 3416546 | password6
Spreadsheet: 218635d1362518934-finding-the-most-relevant-value-based-on-set-of-criteria-book1
Sheet: Sheet1

PROPERTY | ELECTRIC STRUCTURE | WATER STRUCTURE | ASSET TYPE | PARKING STRUCTURE | SHUTTLE STRUCTURE | DOUBLE OCCUPANCY | YEAR OF CONSTRUCTION | BEDS | FOOD SERVICE
CAMPUS PARK | 40 | RESIDENTS PAY | GARDEN | OPEN | NONE | NO | 2000 | 564 | NO
CAMPUS PARK AT THE RIDGE | RESIDENTS PAY | RESIDENTS PAY | GARDEN | OPEN | PROPERTY OWNED | NO | 2000 | 644 | NO
CAMPUS PARK CINCINNATTI | 40 | PROPERTY PAYS | MID-RISE | GARAGE | PROPERTY PAYS | NO | 2006 | 442 | NO
CAMPUS PARK AT TENN. ST. | 35 | PROPERTY PAYS | GARDEN | OPEN | NONE | NO | 2000 | 624 | NO
CAMPUS PARK AT FRESNO STATE | RESIDENTS PAY | PROPERTY PAYS | MID-RISE | OPEN | NONE | NO | 2006 | 460 | NO
TOWERS AT UNIVERSITY TOWN CENTER | 20 | PROPERTY PAYS | HIGH-RISE | GARAGE | PROPERTY PAYS | NO | 2006 | 910 | NO
UNIVERSITY APARTMENTS AT ETTRICK | 95 | PROPERTY PAYS | GARDEN | OPEN | PROPERTY PAYS | YES | 2006 | 504 | NO
GATEWAY AT COLUMBIA | RESIDENTS PAY | RESIDENTS PAY | GARDEN | OPEN | PROPERTY PAYS | NO | 2006 | 450 | NO
THE ELEMENT |  |  | GARDEN |  |  |  | 2004 | 792 | NO
COOPER GLEN |  |  | GARDEN |  |  |  | 1998 | 480 | NO
FORUM AT DENTON STATION | 35 | 10 | GARDEN | OPEN | NONE | NO | 2009 | 1044 | NO
FORUM AT SAM HOUSTON | 30 | PROPERTY PAYS | GARDEN | OPEN | PROPERTY OWNED | YES | 2011 | 450 | NO
FORUM AT STATESBORO |  |  | GARDEN |  |  |  | 2012 | 780 | NO
THE VILLAS ON GUADALUPE |  |  | MID-RISE |  |  |  | 2003 | 343 | NO
THE VENUE ON GUADALUPE |  |  | MID-RISE |  |  |  | 2007 | 146 | NO
THE ENCLAVE |  |  | GARDEN |  |  |  | 1994 | 538 | NO
THE ZONE |  |  | GARDEN |  |  |  | 2000 | 588 | NO
JEFFERSON AT BERRY |  |  | GARDEN |  |  |  | 2008 | 552 | NO
RIO WEST |  |  | MID-RISE |  |  |  | 2006 | 388 | NO
433 MIDVALE |  |  | MID-RISE |  |  | YES | 2004 | 198 | NO
BURNHAM 310 |  |  | HIGH-RISE |  |  |  | 2008 | 430 | NO
NAISMITH HALL |  |  | DORM HALL |  |  | YES | 1965 | 505 | YES
CAMPUS COURT |  |  | GARDEN |  |  |  | 1986 | 647 | NO
 | ELECTRIC STRUCTURE | RESIDENTS PAY
 | WATER STRUCTURE | PROPERTY PAYS
 | ASSET TYPE | GARDEN
 | PARKING STRUCTURE | OPEN
 | SHUTTLE STRUCTURE | PROPERTY PAYS
 | DOUBLE OCCUPANCY | NO
 | YEAR OF CONSTRUCTION | 2004
 | BEDS | 500
 | FOOD SERVICE | NO
Spreadsheet: 58278d1258556384-payment-days-table-payment-days-table
Sheet: Sheet3

 |  | UNIT A |  |  | UNIT B |  |  | SUMMARIZE
 |  | p1 |  |  | p1 |  |  | p1
 |  | CAD | 83513.4 |  | CAD | 139189 |  | CAD | 222702.4
 |  | CHF | 0 |  | CHF | 5 |  | CHF | 5
 |  | EUR | 7740277.4 |  | SGD | 7 |  | DKK | 7740284.4
 |  | GBP | 42128.8 |  | USD | 1275654.916666667 |  | EUR | 1317783.716666667
 |  | SEK | 3 |  |  |  |  | GBP | 42128.8
 |  | SGD | 0 |  |  |  |  | [NAME] | 0
 |  | USD | 765392.95 |  |  |  |  | SEK | 0
 |  |  |  |  |  |  |  | SGD | 0
 |  |  |  |  |  |  |  | USD | 2041047.866666667
 |  | p2 |  |  | p2 |  |  | p2
 |  | AUD | 56265 |  | DKK | 4658 |  | CAD | 0
 |  | CHF | 5 |  | EUR | 14295901.05 |  | CHF | 5
 |  | [NAME] | 1560684 |  | GBP | 469574.2 |  | DKK | 4658
 |  | SGD | 4578 |  | SGD | 5.689 |  | EUR | 14295901.05
 |  | USD | 290016.84 |  | USD | 483361.4 |  | GBP | 469574.2
 |  |  |  |  |  |  |  | [NAME] | 1560684
 |  |  |  |  |  |  |  | SEK | 0
 |  |  |  |  |  |  |  | SGD | 4583.689
 |  |  |  |  |  |  |  | USD | 773378.24
 |  |  |  |  |  |  |  | Unit | (All)
 | Period | Unit | Cur | Amount
 | 1 | A | EUR | 7740277.4 |  |  |  | Sum of Amount
 | 1 | B | USD | 1275654.916666667 |  |  |  | Period | Cur | Total
 | 1 | A | USD | 765392.95 |  |  |  | 1 | CAD | 222702.4
 | 1 | B | CAD | 139189 |  |  |  |  | CHF | 5
 | 1 | A | CAD | 83513.4 |  |  |  |  | EUR | 7740277.4
 | 1 | A | GBP | 42128.8 |  |  |  |  | GBP | 42128.8
 | 1 | B | SGD | 7 |  |  |  |  | SEK | 3
 | 1 | B | CHF | 5 |  |  |  |  | SGD | 7
 | 1 | A | SEK | 3 |  |  |  |  | USD | 2041047.866666667
 | 2 | B | EUR | 14295901.05 |  |  |  | 1 Total |  | 10046171.46666667
 | 2 | A | [NAME] | 1560684 |  |  |  | 2 | AUD | 56265
 | 2 | B | USD | 483361.4 |  |  |  |  | CHF | 5
 | 2 | B | GBP | 469574.2 |  |  |  |  | DKK | 4658
 | 2 | A | USD | 290016.84 |  |  |  |  | EUR | 14295901.05
 | 2 | A | AUD | 56265 |  |  |  |  | GBP | 469574.2
 | 2 | B | DKK | 4658 |  |  |  |  | [NAME] | 1560684
 | 2 | A | SGD | 4578 |  |  |  |  | SGD | 4583.689
 | 2 | B | SGD | 5.689 |  |  |  |  | USD | 773378.24
 | 2 | A | CHF | 5 |  |  |  | 2 Total |  | 17165049.179
 |  |  |  |  |  |  |  | Grand Total |  | 27211220.64566667