tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 7865779a-f4e0-4a0b-8c5d-3071d6973419
Sheet: Zone 9-12

Permit No.: |  |  | WQ0002284 |  |  | Facility Name: |  | [NAME] |  |  |  |  |  | County: | Dare |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | A1A |  | Field Name: |  | A1B |  | Field Name: |  | A2A |  | Field Name: |  | A2B
 |  |  |  |  |  | Area (acres): |  | 0.85 |  | Area (acres): |  | 0.59 |  | Area (acres): |  | 0.23 |  | Area (acres): |  | 0.18
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.3 |  | [NAME] (in): |  | 0.3 |  | [NAME] (in): |  | 0.3 |  | [NAME] (in): |  | 0.3
 |  |  |  |  |  | Annual Rate (in): |  | 161.2 |  | Annual Rate (in): |  | 161.2 |  | Annual Rate (in): |  | 161.2 |  | Annual Rate (in): |  | 161.2
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 142517d1329882731-excel-2007-consolidating-different-values-under-different-names-indifferent-tabs-to-master-sheet-varification-doc
Sheet: VINOD NAGAR

VINOD NAGAR |  |  |  |  |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK |  |  |  | SOUTH BLOCK
SNO | Part Code | Description | Qty | Qty (As on Date 16th Jan-2012)
Section-V,  Part A, SNO-3, 5 | PE-SV Router, PE-SDN Router |  | 1
Existing Material Redeployment
A | Power System
 | 1000 AH Battery |  | 2
Spreadsheet: 69c18e55-e27f-44eb-bcdd-5c83af0e68be
Sheet: Sheet1

Release: ADP National Employment Report | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=194
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-04-16 8:21 AM [NAME]
 | Real-Time | Period
Name: | Start | End
ADP National Employment Report | 2011-02-02 00:00:00 | Current
Link:
http://www.adpemploymentreport.com/ | 2011-02-02 00:00:00 | Current
Source:
Automatic Data Processing, Inc. | 2011-02-02 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:
2011-02-02 00:00:00
2011-03-02 00:00:00
2011-03-30 00:00:00
2011-05-04 00:00:00
2011-06-01 00:00:00
2011-07-07 00:00:00
2011-08-03 00:00:00
2011-08-31 00:00:00
2011-10-05 00:00:00
2011-11-02 00:00:00
2011-11-30 00:00:00
2012-01-05 00:00:00
2012-02-01 00:00:00
2012-03-07 00:00:00
2012-04-04 00:00:00
2012-05-02 00:00:00
2012-05-31 00:00:00
2012-07-05 00:00:00
2012-08-01 00:00:00
2012-09-06 00:00:00
2012-10-03 00:00:00
2012-10-24 00:00:00
2012-11-01 00:00:00
2012-12-05 00:00:00
2013-01-03 00:00:00
2013-01-30 00:00:00
2013-03-06 00:00:00
2013-04-03 00:00:00
2013-05-01 00:00:00
2013-06-05 00:00:00
2013-07-03 00:00:00
2013-07-31 00:00:00
2013-09-05 00:00:00
2013-10-02 00:00:00
2013-10-30 00:00:00
2013-12-04 00:00:00
2014-01-08 00:00:00
2014-02-05 00:00:00
2014-03-05 00:00:00
2014-04-02 00:00:00
Spreadsheet: 875803d1722436130-combining-consolidating-information-from-multiple-rows-shawnkey
Sheet: Sheet1

Name | Entry | Amount |  |  |  |  | Name | Entry | Amount |  | Name and Entry | Amount |  | Name | Entry
B&K Distributing | A - costs received! | 350 |  |  |  |  | B&K Distributing | A - costs received! | 450
B&K Distributing | B - expense@ | 3 |  |  |  |  | B&K Distributing | B - expense@ | 35
B&K Distributing | B - expense@ | 2 |  |  |  |  | [NAME] | A - costs received! | 350
B&K Distributing | B - expense@ | 2 |  |  |  |  | [NAME] | B - expense@ | 209
B&K Distributing | B - expense@ | 22 |  |  |  |  | [NAME] | B - expense@ | 88
B&K Distributing | A - costs received! | 100 |  |  |  |  | [NAME] | E - payment# | 1300
B&K Distributing | B - expense@ | 4 |  |  |  |  | [NAME] | H - profit$ | 320
B&K Distributing | B - expense@ | 2 |  |  |  |  | [NAME] | J - remit$ | 995
[NAME] | B - expense@ | 195
[NAME] | B - expense@ | 3
[NAME] | B - expense@ | 11
[NAME] | A - costs received! | 350
[NAME] | B - expense@ | 50
[NAME] | B - expense@ | 18
[NAME] | B - expense@ | 20
[NAME] | E - payment# | 1300
[NAME] | H - profit$ | 320
[NAME] | J - remit$ | 995
Spreadsheet: 861857d1709687879-vlookup-to-subtract-using-indirect-and-column-functions-vlookup-indirect-column-formula
Sheet: Sheet6

NODE | X | Y | HEADU
363574 | 623750 | 7156250 | 560.09
363575 | 625250 | 7156250 | 586.8925
363576 | 628250 | 7156250 | 590.3536
363577 | 629750 | 7156250 | 609.9778
Spreadsheet: 193716d1352920847-multiple-formulas-needed-in-one-cell-to-create-a-value-in-a-new-cell-media-tracking-percentage-comparison1-ver2
Sheet: Tables - Avg Daily Campaign

Avg Daily Sales (Avg)
 |  |  |  |  |  |  |  |  |  | Vlookup Table
Medium |  |  |  |  |  |  |  |  |  | Points Score |  |  | Campaing - excluding Sales
 | TV | Radio |  |  |  |  |  |  |  | -100 | 1 |  | Avg daily Campaigns compared to all Compaigns
Brisbane |  |  |  |  |  |  |  |  |  | -0.3 | 2 |  |  | Low | High | Pts
Adelaide |  |  |  |  |  |  |  |  |  | -0.1 | 2.5 |  |  | 1 | + | 5
Perth |  |  |  |  |  |  |  |  |  | 0.1 | 3 |  |  | 0.3 | 1 | 4
Sydney |  |  |  |  |  |  |  |  |  | 0.3 | 4 |  |  | 0.1 | 0.3 | 3
Melbourne |  |  |  |  |  |  |  |  |  | 1 | 5 |  |  | -0.1 | 0.1 | 2.5
Newcastle |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.3 | -0.1 | 2
Gold Coast |  |  |  |  |  |  |  |  |  |  |  |  |  | + | -0.3 | 1
ACT
TV Station
 | Seven Network | Nine Network | Network Ten | Prime7 | NBN | SCA | WIN
Brisbane
Adelaide
Perth
Sydney
Melbourne
Newcastle
Gold Coast
ACT
Radio Station
 | ATN | 97.3 | Triple M | Beat 105 | Nova | Sea FM | Gold FM | Hot Tomato | 2DAY | Mix | WSFM | FOX FM | 92.9 | 96FM | NXFM | KOFM | SAFM | 104.7
Brisbane
Adelaide
Perth
Sydney
Melbourne
Newcastle
Gold Coast
ACT
TV Reach % |  |  |  |  |  |  | TV Frequency %
 | 0-50% | 50-60% | 60-70% | 70-80% | 80-100% |  |  | 0-40% | 40-50% | 50-60% | 60-70% | 70-100%
Brisbane |  |  |  |  |  |  | Brisbane
Adelaide |  |  |  |  |  |  | Adelaide
Perth |  |  |  |  |  |  | Perth
Sydney |  |  |  |  |  |  | Sydney
Melbourne |  |  |  |  |  |  | Melbourne
Newcastle |  |  |  |  |  |  | Newcastle
Gold Coast |  |  |  |  |  |  | Gold Coast
ACT |  |  |  |  |  |  | ACT
Radio Reach % |  |  |  |  |  |  | Radio Frequency %
 | 0-50% | 50-60% | 60-70% | 70-80% | 80-100% |  |  | 0-40% | 40-50% | 50-60% | 60-70% | 70-100%
Brisbane |  |  |  |  |  |  | Brisbane
Adelaide |  |  |  |  |  |  | Adelaide
Perth |  |  |  |  |  |  | Perth
Sydney |  |  |  |  |  |  | Sydney
Melbourne |  |  |  |  |  |  | Melbourne
Newcastle |  |  |  |  |  |  | Newcastle
Gold Coast |  |  |  |  |  |  | Gold Coast
ACT |  |  |  |  |  |  | ACT
Spreadsheet: 490280d1479773612-extracting-multiple-unique-values-from-a-table-based-on-a-single-criterion-sample_extract_unique
Sheet: Sheet1

 |  | DATABASE
 |  | Code | Description | Cases | Round | Invoice | Acc. number | Customer
 |  | 1231 | Product A | 1 | X0001 | 2477 | 12358 | A
 |  | 342 | Product B | 4 | [NAME] | 0485 | 51456 | B
 |  | 345 | Product C | 1 | X0011 | 2557 | 43218 | C
 |  | 756 | Product D | 1 | X0011 | 2559 | 886 | D
 |  | 3838 | Product E | 1 | X0013 | 0503 | 545 | E
 |  | 890 | Product F | 1 | X0014 | 2396 | 55412 | F
 |  | 664 | Product G | 1 | X0015 | 2397 | 15165 | G
 |  | 22 | Product H | 1 | X0017 | 2572 | 88 | H
 |  | 6547 | Product J | 1 | X0017 | 2642 | 55 | I
 |  |  | Sample 1
 |  | Round | X0011
 |  | Code | Description | Cases | Customer
 |  | 345 | Product C | 1 | C
 |  | 756 | Product D | 1 | D
 |  |  | Sample 2
 |  | Round | X0014
 |  | Code | Description | Cases | Customer
 |  | 890 | Product F | 1 | F
Spreadsheet: 771784d1646845091-sort-in-pivot-table-working-in-wrong-order-sort-problem
Sheet: Data

A/D | Date
A | 2021-01-01 00:00:00
D | 2021-01-01 00:00:00
A | 2021-01-01 00:00:00
D | 2021-01-01 00:00:00
A | 2021-01-01 00:00:00
D | 2021-01-01 00:00:00
D | 2021-01-02 00:00:00
A | 2021-01-02 00:00:00
D | 2021-01-02 00:00:00
Spreadsheet: 746500d1630773598-sum-data-from-different-columns-based-on-the-dates-selected-workfile
Sheet: Sheet1

Date From | 1 | Sep | 2021
Date To | 31 | Sep | 2021
Total |  |  |  |  | I am looking for a sumif formula based on the above dates.
Cumulative
Year | 2021 |  |  |  |  |  |  |  |  | 2022
Date
 | 2021-04-01 00:00:00
Cumulative | 1302580 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jan
Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Feb
1 | 8150 | 8890 | 9790 | 10270 | 10050 | 10540 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar
 | 3675 | 9000 | 9820 | 2800 | 10070 | 10510 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr
 | 8200 | 9040 | 9920 | 10310 | 10070 | 5020 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May
 | 8200 | 8970 | 4665 | 10250 | 10020 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jun
 | 8210 | 9060 | 9960 | 10170 | 10050 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jul
 | 8180 | 9030 | 10000 | 10160 | 4805 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aug
 | 8320 | 4215 | 9950 | 9980 | 10080 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sep
 | 8260 | 9140 | 10000 | 9980 | 10080 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Oct
 | 7820 | 9190 | 9980 | 4880 | 10120 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nov
 | 8380 | 9190 | 9980 | 10000 | 10180 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dec
 | 8440 | 9250 | 4795 | 10000 | 10190
 | 8480 | 9250 | 9960 | 10100 | 5115
 | 8430 | 0 | 9960 | 10040 | 945
 | 8500 | 3100 | 9960 | 10040 | 10140
 | 8600 | 9300 | 9960 | 8760 | 10260
 | 4040 | 9280 | 9960 | 4435 | 10230
 | 8450 | 9170 | 9970 | 10090 | 10290
 | 8470 | 9040 | 4795 | 10070 | 10410
 | 8570 | 9170 | 9970 | 10070 | 10430
 | 8510 | 9170 | 9970 | 0 | 5070
 | 8530 | 4390 | 9970 | 9210 | 10490
 | 8540 | 9160 | 10150 | 10110 | 10490
 | 3925 | 9240 | 10080 | 4960 | 10390
 | 8530 | 9420 | 10250 | 10170 | 10390
 | 8550 | 9510 | 4865 | 10120 | 10350
 | 8640 | 9510 | 10270 | 10120 | 10370
 | 8670 | 9530 | 10300 | 10000 | 4990
 | 8690 | 4570 | 10300 | 10020 | 10520
 | 8830 | 9750 | 10290 | 10140 | 10560
 | 4155 | 9840 | 10290 | 4910 | 10560
 | 0 | 9840 | 0 | 10010 | 10560
Spreadsheet: 832484d1686357063-a-column-that-sums-other-columns-data-but-it-adds-only-from-the-3th-to-the-5th-value-a-column-that-sums-other-columns-data-but-it-adds-only-from-the-3th-to-the-5th-value
Sheet: Sheet1

 |  |  |  | Here: |  |  |  |  |  |  |  | =BYCOL(E4:I17,LAMBDA(z,MATCH(1,--ISNUMBER(z),0)+2))
 |  | Year | Sum | Product1 | Product2 | Product3 | Product4 | Product5
 |  | 1 | 0 | 10
 |  | 2 | 0 | 10 | 10
 |  | 3 |  | 5 | 10 |  |  |  |  | 3rd
 |  | 4 |  | 5 | 5 |  |  |  |  | 4th
 |  | 5 |  | 2 | 5 | 10 |  |  |  | 5th
 |  | 6 |  | 2 | 2 | 10
 |  | 7 |  | 1 | 2 | 5 | 10
 |  | 8 |  |  | 1 | 5 | 10 | 10
 |  | 9 |  |  |  | 2 | 5 | 10
 |  | 10 |  |  |  | 2 | 5 | 5
 |  | 11 |  |  |  | 1 | 2 | 5
 |  | 12 |  |  |  |  | 2 | 2
 |  | 13 | 0 |  |  |  | 1 | 2
 |  | 14 | 0 |  |  |  |  | 1
Spreadsheet: 114245d1310040422-divide-cell-amounts-between-cells-equally-sample
Sheet: Sheet1

13.78125 |  |  | 16.295
15.235 |  |  | 21.168
22.743 |  |  | 29.092
26.84 |  |  | 35.418
32.09765 |  |  | 40.711
37.02 |  |  | 49.84100000000001
44.59545 |  |  | 57.5795
49.5844 |  |  | 62.05394999999999
 | the above works perfectly as your suggestion
 |  |  |  |  |  | 450x597 | 490x597 | 570x397 | 570x447 | 570x497 | 570x597 | 715x297 |  |  |  |  |  |  |  |  |  |  |  |  | 715x397 | 715x447 | 715x497 | 715x597 | 895x297 | 895x397 | 895x447 | 895x497 | 895x597 | 980x597 | 1245x297 | 1245x397 | 1245x497 | 1245x597 | 1965x297 | 1965x397 | 1965x497 | 1965x597
 |  |  |  |  |  | 17.1465 | 18.003825 | 13.78125 |  |  | 16.295 | 13.98075 |  |  |  |  |  |  |  |  |  |  |  |  | 15.52
 |  |  |  |  |  | 20.44 | 21.462 | 15.235 |  |  | 21.168 | 15.2735 |  |  |  |  |  |  |  |  |  |  |  |  | 18.288
 |  |  |  |  |  | 28.623 | 30.05415 | 22.743 |  |  | 29.092 | 23.891 |  |  |  |  |  |  |  |  |  |  |  |  | 25.543
 |  |  |  |  |  | 33.278 | 34.9419 | 26.84 |  |  | 35.418 | 28.3965 |  |  |  |  |  |  |  |  |  |  |  |  | 31.344
 |  |  |  |  |  | 35.931 | 37.72755 | 32.09765 |  |  | 40.711 | 33.43105 |  |  |  |  |  |  |  |  |  |  |  |  | 36.61199999999999
 |  |  |  |  |  | 45.61199999999999 | 47.89259999999999 | 37.02 |  |  | 49.84100000000001 | 37.932 |  |  |  |  |  |  |  |  |  |  |  |  | 43.494
 |  |  |  |  |  | 55.79375 | 58.5834375 | 44.59545 |  |  | 57.5795 | 42.522 |  |  |  |  |  |  |  |  |  |  |  |  | 50.36409999999999
 |  |  |  |  |  | 62.05394999999999 | 65.15664749999999 | 49.5844 |  |  | 62.05394999999999 | 48.054 |  |  |  |  |  |  |  |  |  |  |  |  | 55.99715
Spreadsheet: kevin_ruscitti__20379__CESVOL
Sheet: March 00

[NAME]
JOBIE - 402/758-6120
Deal #100883 | 2000-03-01 00:00:00
MUST GIVE BY 10:00 | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | [NAME] | Wed | Thur | fri
Nigas 9258 | 5977 | 5977 | 5977 |  |  |  |  | 5927 | 5917 | 917 |  |  |  |  |  |  |  |  | 571 | 504 | 504 | 504
Pglc 909285 | 3847 | 3847 |  |  |  |  |  |  |  | 9807 |  |  |  |  |  |  |  |  |  |  | 20831
N.Shore 9254
Ill. Power 909999 | 10 | 10
Nipsco 909260 | 1797 | 1797 | 1797 | 6797 | 6797 | 6797 | 6797 | 6797 | 6797 | 6797 |  | 1797 | 1797 | 1797 | 1797 | 1797 | 1797 | 1797 | 1797 | 1797 | 1797
Nipsco 10552 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 11000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 |  |  | ALWAYS GIVE JOBIE TOTAL @ NIPSCO
IES 25250 | 326 | 326
Wsc 909294 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500
Wsc 907112 | 690 | 690 |  |  |  |  |  | 670 | 680 | 680 |  |  |  | 750 |  |  | 620 | 490 | 540 | 720 | 735 | 660 | 625 | 570 | 455 | 500 | 670 | 670 | 670 | 670
Mid Amr.10568 | 12855 | 12855 | 735 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 986 | 1068 | 1069
E Joliet 904758
CIPS 25500
Total
Deal #125241
NIPSCO 909260 | 2203 | 2203 | 2203 | 2203 | 2203 | 2203 | 2203 | 2203 | 2203 | 2203 | 2203 | 2203 | 2203 | 2203 | 2203 | 2203 | 2203 | 2203 | 2203 | 2203 | 2203 | 2203 | 2203 | 2203 | 2203 | 2203 | 2203 | 2203 | 2203 | 2203 | 2203
MW 25400 | 812 | 812 | 812 | 812 | 812 | 812 | 812 | 812 | 812 | 812 | 812 | 812 | 812 | 812 | 812 | 812 | 812 | 812 | 812 | 812 | 812 | 812 | 812 | 812 | 812 | 812 | 812 | 812 | 812 | 812 | 812
TOTAL
GRAND TOTAL
NIPSCO 909260 TOTAL
Spreadsheet: 819911d1677762613-count-range-with-dates-not-working-copy-1-
Sheet: SUMMARY

 | SUMMARY
 | Any date range | From | All | To | All
 | Name | TOTAL ID COUNT | Date AET to do dropped | [NAME]
 | ACTON |  |  | 9
 | EALING |  |  | 17
 | FULHAM |  |  | 5
 | HARLESDEN |  |  | 14
 | HARROW |  |  | 10
 | HAYES |  |  | 4
 | HOUNSLOW |  |  | 17
 | KINGSTON |  |  | 5
 | SHEPHERDSBUSH |  |  | 3
 | TWICKENHAM |  |  | 3
 | UXBRIDGE |  |  | 5
 | WANDSWORTH |  |  | 2
 | WEMBLEY |  |  | 7
 | TOTAL |  |  | 101
Spreadsheet: 145136d1331314696-countif-function-help-climate-station-2012-1-
Sheet: JanDiary

 | Am | Pm
2012-01-01 00:00:00 | Rain showers cooler | occ hail showers
2012-01-02 00:00:00 | Hail showers o/n, thin cover | Occ shrs hail and rain
2012-01-03 00:00:00 | Rain o/n. Gale V V Windy | V V Windy,fence damaged occ shrs
2012-01-04 00:00:00 | Rain o/n and am | Spells of Rain V V Windy eve Gale
2012-01-05 00:00:00 | Rain o/n windy | Dry sunny day cold eve
2012-01-06 00:00:00 | Dry frosty | Occ light rain shrs eve
2012-01-07 00:00:00 | Rain o/n shrs am | Occ light rain shrs
2012-01-08 00:00:00 | Dry Cloudy | Occ drizzle and light rain
2012-01-09 00:00:00 | Rain o/n Cloudy becoming sunny | Dry sunny day
2012-01-10 00:00:00 | Dry | Occ drizzle
2012-01-11 00:00:00 | Dry cloudy | Windy late eve
2012-01-12 00:00:00 | [NAME] overnight | Sunny all day frosty late eve
2012-01-13 00:00:00 | Cold clear frosty | Frost persisting
2012-01-14 00:00:00 | Some cloud frosty | Frost persisting
2012-01-15 00:00:00 | Dry frosty | Frost persisting
2012-01-16 00:00:00 | Dry frosty | Dry sunny day, light frost
2012-01-17 00:00:00 | Cold and cloudy | Shower 3pm, sunny spells
2012-01-18 00:00:00 | Rain o/n and am | Mainly dry, sunny spells
2012-01-19 00:00:00 | Cool cloudy | Occ shws pm cool
2012-01-20 00:00:00 | Occ shws, snow on hills | Cold light rain
2012-01-21 00:00:00 | Rain o/n showers | Occ showers, cool windy
2012-01-22 00:00:00 | Rain o/n shws heavy | Dry day sunny periods, showers eve
2012-01-23 00:00:00 | Dry light frost | Light shower Pm frost
2012-01-24 00:00:00 | Rain from 3am | occ rain and drizzle
2012-01-25 00:00:00 | Drizzle overnight | Dry am cloudy
2012-01-26 00:00:00 | Rain overnight, turned icy | occ showers sleet/hail later
2012-01-27 00:00:00 | Occ sleet/snow shrs | Occ sleet, mainly dry pm
2012-01-28 00:00:00 | Frosty | Frost persisting
2012-01-29 00:00:00 | Fells white | Light shower later
2012-01-30 00:00:00 | Frosty mainly cloudy | Snow flurry 1830
2012-01-31 00:00:00 | Occ snow grains | Occ snow grains
Spreadsheet: 857848d1706719451-sum-hours-based-on-date-range-and-id-and-then-summarize-on-a-separate-tab-eot-sample-v2
Sheet: COSTA

Name | ID |  |  |  |  | CHARGE MONTH: |  |  |  | PAYROLL WORKSHEET
COSTA |  |  |  |  |  | 2023-11-01 00:00:00 |  |  |  | Schedule: | Weekly |  |  | Mo. [NAME]: |  |  |  | Hrly [NAME].: |  |  |  | Position: | Officer
 |  |  |  |  |  |  |  |  |  | Shift: | Grave |  |  | Stipends/UA |  |  |  | Bi-Wk Equiv.: |  |  |  | Union: | R08
LEAVE USAGE
TYPE | V | S | SF | CTO | HC | IH | PH |  |  |  |  |  | Hours Worked
DATE |  |  |  |  |  |  |  |  |  | Period # | Start | End | Regular | Holiday | Overtime | CTO | Total | Swing | S Due | Grave | G Due | Total Comp | OT Rate
 |  |  |  |  |  |  |  |  |  | 1 | 2023-10-22 00:00:00 | 2023-11-04 00:00:00 | 80
 |  |  |  |  |  |  |  |  |  | 2 | 2023-11-05 00:00:00 | 2023-11-18 00:00:00 | 80
 |  |  |  |  |  |  |  |  |  | 3 | 2023-11-19 00:00:00 | 2023-12-02 00:00:00 | 80
 |  | NO TIME TAKEN |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  | Total All OT Worked:
TOTAL |  |  |  |  |  |  |  |  |  |  |  |  | OT Reported by Dept:
 |  |  |  |  |  |  |  |  |  |  |  |  | Less Holiday RDO:
OVERTIME AUTHORIZED
REASON | DATE | FROM | TO | HOURS | EARN ID | PAY CODE | SWING | GRAVE |  |  |  |  |  | Difference:
FOOTBALL VS BOISE | 2023-11-04 00:00:00 | 1500 | 2330 | 8.5 | OTPR | 871-425P |  | 1.5
BOARD OF TRUSTEE MEETINGS | 2023-11-06 00:00:00 | 900 | 1330 | 4.5 | OTPR | 213-425P
BOARD OF TRUSTEE MEETINGS | 2023-11-07 00:00:00 | 700 | 2000 | 13 | CTO | 213-425P
BOARD OF TRUSTEE MEETINGS | 2023-11-08 00:00:00 | 700 | 1700 | 10 | HOL(W) | 213-425P
VETERANS DAY - REG SHIFT | 2023-11-10 00:00:00 |  |  | 12 | HG6 | 213-425HP
FOOTBALL VS NEW MEXICO | 2023-11-18 00:00:00 | 1600 | 2345 | 7.8 | OTPR | 871-425P |  | 1.75
THANKSGIVING DAY - REG SHIFT | 2023-11-23 00:00:00 |  |  | 12 | HG6 | 213-425HP
Total
 |  |  |  | Regular Shift Differential Hours: |  |  |  | 180
 |  |  |  | Total Shift Differential Hours to Pay:
Spreadsheet: d95fb0da-d0e1-48c2-a450-8c6849130763
Sheet: Sheet1

Table S2. Gene fusions identified in the Mexico A genome. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Affected ORFs according to the SS14 genome (GenBank acc. no CP000805.1) | Type of change | Fused ORFs | ORF annotated in the Mexico A genome (GenBank acc. no. CP003064.1)
TPASS_0006 | in (1 bp) | TP0006 and TP0008 | TPAMA_0006
TPASS_0013 | in (2 bp) | TP0013 and TP0014 | TPAMA_0013
TPASS_0018 | 3 in (1 bp) | TP0018 and TP0019 | TPAMA_0018
TPASS_0172, TPASS_0173 | in (1 bp) del (1 bp) | TP0172 and TP0173 | TPAMA_0172
TPASS_0174, TPASS_0175, TPASS_0176 | 2 del (1 bp) in (1 bp) | TP0174, TP0175 and TP0176 | TPAMA_0174
TPASS_0180 | in (2 bp) | TP0179 and TP0180 | TPAMA_0179
TPASS_0284 | in (1 bp) | [NAME] and TP0285 | TPAMA_0284
TPASS_0286 | in (1 bp) | TP0286 and TP0287 | TPAMA_0286
TPASS_0288 | del (1 bp) | TP0288 and TP0289 | TPAMA_0288
TPASS_0299 | in (1 bp) | TP0299 and TP0300 | TPAMA_0299
TPASS_0324 | in (1 bp) | TP0324 and TP0325 | TPAMA_0324
TPASS_0377 | in (1 bp) | TP0377 and TP0378 | TPAMA_0377
TPASS_0419 | del (1 bp) | TP0419 and TP0420 | TPAMA_0419
TPASS_0462 | del (1 bp) | TP0462 and TP0463 | TPAMA_0462
TPASS_0481 | in (1 bp) | TP0481 and TP0482 | TPAMA_0481
TPASS_0588 | in (1 bp) | TP0587 and TP0588 | TPAMA_0587
TPASS_0703 | in (1 bp) | TP0702 and TP0703 | TPAMA_0702
TPASS_0782 | del (1 bp) | TP0781 and TP0782 | TPAMA_0781
TPASS_0859 | del (1 bp) | TP0859 and [NAME] | TPAMA_0859
TPASS_0899 | in (1 bp) | TP0899 and TP0900 | TPAMA_0899
[NAME] | in (1 bp) | TP0928 and TP0929 | TPAMA_0926
Spreadsheet: 63000d1263981385-sum-columns-based-on-cell-reference-sample1
Sheet: Sheet1

Period | 8
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | Spend to Year End
115.3846153846154 | 115.3846153846154 | 115.3846153846154 | 115.3846153846154 | 115.3846153846154 | 115.3846153846154 | 115.3846153846154 | 115.3846153846154 | 115.3846153846154 | 300 | 100 | 250 | 115.3846153846154
[NAME]
IF B2 says 8 I only want cell N7 to be the total of columns I - M (9-13) with a total of £880.77 |  |  |  |  |  |  |  |  | and so on
IF B2 says 9 I only want cell N7 to be the total of columns J - M (10-13) with a total of £765.38
The figures in row 7 may change and therefore can not be a formula.