tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_m_love__30657__9911_OA
Sheet: BUG_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  BUG
 |  |  | Total |  | Reclasses |  | November |  | December |  | January |  | February |  | March |  | April
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  | 92472 | 2424306
2 |  | Liquidations
3 |  | Interdesk |  |  |  |  | 28397164 | 76589544 | -18141175 | -48032436
4 |  | Option Premiums
5 |  | Dmd Reimbursements |  |  |  |  |  | 13125565 |  | 1343100
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  |  | -6931794 | -22128826 | 2677 | -592309
7 |  | Liquidations |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0
8 |  | Interdesk |  |  |  |  | -33209597 | -88728638 | 18526538 | 48775926
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind |  |  |  |  | 658164 | 2030436 | -658164 | -2030436
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg) |  |  |  |  | 0 | 0 | -210193 | -2371244
18 |  | W/D (Purchase from Stg) |  |  |  |  | -1709556 | -4155139 | -22753 | -66064
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4: |  |  |  |  |  |  |  | 410598 | 1266695
23 | Fuel: |  |  |  |  |  | 0 | 0 | 0 | 0
 | Transport Expense:
24 |  | Commodity
25 |  | Demand |  |  |  |  | 0 |  | 0
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate |  |  |  |  |  | 0 |  | 0
27 |  | Intrastate |  |  |  |  |  | 0 |  | 0
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 803752d1667663687-text-split-with-no-delimiter-book1
Sheet: 1

 |  |  |  |  |  |  |  |  |  | Mr
 |  |  |  |  |  |  |  |  |  | Ms
DrTsangEric |  |  |  |  |  |  |  |  |  | Mrs
ProfEricTsang |  |  |  |  |  |  |  |  |  | Dr
MaryGoMs |  |  |  |  |  |  |  |  |  | Prof
TomhankMr
Spreadsheet: 41300d1239794881-identify-list-and-sum-2-columns-test-time-sheet
Sheet: OCT 20-25 08

 | NAME: | JON
 |  |  |  |  | TOTAL HRS
DATE | TIME IN | TIME OUT | TOTAL HRS | JOB NO. | FOR DAY | JOB [NAME] |  | OCT. 13-18
2008-10-20 00:00:00 | 06:00:00 | 03:00:00 | 8.5 | SHOP | 8.5 |  |  | SHOP | 21.5
 |  |  |  |  |  |  |  | 28090 | 3.5
2008-10-21 00:00:00 | 06:30:00 | 10:30:00 | 4 | SHOP |  |  |  | 28093 | 2.5
 | 10:30:00 | 02:30:00 | 3.5 | VAC | 7.5 |  |  | 28094 | 10
 |  |  |  |  |  |  |  | 28097 | 6
2008-10-22 00:00:00 | 06:00:00 | 09:30:00 | 3.5 | SHOP |  |  |  |  | 43.5
 | 09:30:00 | 02:30:00 | 4.5 | VAC | 8
2008-10-23 00:00:00 | 06:30:00 | 03:00:00 | 8 | SHOP | 8
2008-10-24 00:00:00 | 06:30:00 | 10:30:00 | 4 | 28094 |  | CNC-P
 | 10:30:00 | 03:00:00 | 4 | SHOP | 8
 |  | SHOP | 28
 |  | VACATION | 8
 |  | 28094 | 4
 |  |  | 40 | TOTAL | 40
Spreadsheet: 3c43ed6e-cc7d-45bf-86d8-ad8aa06a3619
Sheet: Sheet1

Republican | First Congressional District | Unnamed: 2 | Unnamed: 3
2000-09-12 00:00:00 | [NAME], r | [NAME], d | [NAME]
Albany | 58 | 1 | 0
Alton | 553 | 1 | 2
Auburn | 459 | 2 | 1
[NAME] | 477 | 2 | 2
Barnstead | 345 | 0 | 2
[NAME] | 286 | 0 | 0
Bedford | 1950 | 2 | 7
Belmont | 455 | 2 | 7
Brentwood | 300 | 0 | 0
[NAME] | 98 | 0 | 0
Candia | 510 | 0 | 0
Center Harbor | 173 | 0 | 0
Chatham | 35 | 0 | 0
Chester | 333 | 0 | 0
Conway | 710 | 6 | 7
Danville | 235 | 0 | 1
[NAME] | 415 | 0 | 2
[NAME] | 1716 | 0 | 0
[NAME] | 251 | 0 | 0
[NAME] | 123 | 4 | 1
[NAME] | 307 | 1 | 2
[NAME] | 315 | 1 | 1
[NAME] | 219 | 2 | 1
[NAME] 6 | 233 | 0 | 0
[NAME] | 375 | 2 | 4
East Kingston | 176 | 0 | 0
Eaton | 44 | 0 | 1
[NAME] | 86 | 0 | 0
Epping | 387 | 1 | 4
[NAME] | 410 | 1 | 5
Exeter | 1134 | 3 | 0
Farmington | 285 | 0 | 1
Freedom | 212 | 0 | 1
Fremont | 275 | 0 | 0
Gilford | 801 | 1 | 2
Gilmanton | 337 | 2 | 3
Goffstown | 1354 | 1 | 5
Greenland | 299 | 0
Hale's Location | 22 | 0 | 0
Hampstead | 680 | 0 | 2
Hampton | 995 | 1 | 3
[NAME] | 258 | 0 | 0
Hart's Location | 13 | 0 | 0
[NAME] | 1005 | 1 | 3
[NAME] | 127 | 0 | 0
Kensington | 126 | 0 | 1
Kingston | 620 | 0 | 9
[NAME] | 419 | 1 | 1
[NAME] | 273 | 0 | 0
[NAME] 3 | 272 | 0
[NAME] | 212 | 1 | 1
[NAME] | 160 | 0 | 1
[NAME] 6 | 271 | 0 | 1
[NAME] | 285 | 0 | 1
[NAME] | 1376 | 3 | 4
Madbury | 122 |  | 2
[NAME] | 226 | 0 | 0
[NAME] | 963 | 0 | 2
[NAME] | 698 | 1 | 3
[NAME] 3 | 415 | 0 | 1
[NAME] | 386 | 0 | 4
[NAME] | 279 | 0 | 0
[NAME] 6 | 682 | 0 | 3
[NAME] | 426 | 0 | 3
[NAME] 8 | 633 | 0 | 2
[NAME] 9 | 483 | 2 | 1
[NAME] 10 | 566 | 1 | 3
[NAME] 11 | 329 | 0 | 2
[NAME] 12 | 621 | 0 | 9
Meredith | 683 | 0 | 1
Merrimack | 1875 | 2 | 12
[NAME] | 80 | 0 | 0
Milton | 191 | 0 | 1
Moultonborough | 759 | 1 | 1
New Castle | 247 | 2 | 0
New Durham | 172 | 1 | 0
New Hampton | 200 | 0 | 0
Newfields | 145 | 0 | 0
Newington | 141 | 0 | 0
Newmarket | 381 | 1 | 3
Newton | 201 | 0 | 1
[NAME] | 423 | 4 | 4
Northwood | 305 | 0 | 1
[NAME] | 313 | 0 | 1
Ossipee | 280 | 0 | 1
Pittsfield | 353 | 0 | 2
Plaistow | 455 | 4 | 1
Portsmouth Ward 1 | 155 | 1 | 0
Portsmouth Ward 2 | 171 | 5 | 1
Portsmouth Ward 3 | 156 | 2 | 0
Portsmouth Ward 4 | 335 | 5 | 0
Portsmouth Ward 5 | 228 | 5 | 7
[NAME] | 679 | 0 | 4
Rye | 715 | 1 | 5
Rochester Ward 1 | 296 | 0 | 1
[NAME] | 295 | 1 | 0
[NAME] 3 | 323 | 1 | 1
Rochester Ward 4 | 266 | 0
Rochester Ward 5 | 236 | 1 | 2
[NAME] | 153 | 1 | 1
Sandown | 274 | 0 | 1
Sandwich | 186 | 1 | 0
Seabrook | 430 | 0 | 4
[NAME] | 128 | 0 | 0
[NAME] | 84 | 0 | 1
[NAME] 3 | 86 | 0 | 0
[NAME] | 90 | 1 | 1
[NAME] 5 | 55 | 1 | 1
[NAME] | 59 | 0 | 1
[NAME] | 282 |  | 2
Stratham | 528 | 0 | 0
Tamworth | 211 | 0 | 2
Tuftonboro | 370 | 3 | 1
Wakefield | 331 | 0 | 0
Wolfeboro | 798 | 0 | 0
Totals | 45798 | 90 | 189
Spreadsheet: 703088d1604749712-use-index-match-with-an-isblank-excel-problem
Sheet: Sheet1

 | Sheet 1 |  |  | Sheet 2
 | Item Code | Add-in Code |  | Add-in Code | Item Code |  | Item Code (Wanted Result)
 | A100 | S100 |  | S100 |  |  | A100
 |  | S101 |  | S101 |  |  | A100
 |  | S102 |  | S102 |  |  | A100
 | B100 | R101 |  | R101 |  |  | B100
 |  | R102 |  | R102 |  |  | B100
 |  | R103 |  | R103 |  |  | B100
Spreadsheet: 736448d1623655610-formula-indirect-and-array-suddenly-stopped-working-book3
Sheet: Sheet3

 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030
Income | 0 | 5 | 10 | 15 | 20 | 25 | 30 | 35 | 40 | 45
Spreadsheet: 50842d1250345402-date-formatting-dates20
Sheet: Sheet3

2008-10-25 13:30:45 | 25/10/2008  13:30:45 | 2008-10-25 00:00:00
25.10.2009 | 25.10.2009 | 2009-10-25 00:00:00
25.10.09 | 25.10.09 | 2009-10-25 00:00:00
2009-08-10 00:00:00 | 10/08/2009 | 2009-10-08 00:00:00
2008-10-25 13:30:45 | 25/10/2008  13:30:45 | 2008-10-25 00:00:00
2009-08-10 00:00:00 | 10/08/2009 | 2009-10-08 00:00:00
25.10.2009 | 25.10.2009 | 2009-10-25 00:00:00
25.10.09 | 25.10.09 | 2009-10-25 00:00:00
original | converted with text to columns as text | finish
Spreadsheet: 139716d1328402672-vlookup-from-multiple-pages-test-lookup-different-page-values
Sheet: Jan

TABLE
[NAME] | CODE | BUILDING | $
LABOR | 45 | 1 | 23344.5
SUPPLIES | 46 | 2 | 2332
RENTAL | 47 | 3 | 0
EQUIPMENT | 48 | 4 | 0
MISC | 49 | 5 | 2300
IT | 50 | 6 | 0
Spreadsheet: 706324d1606635598-powerquery-data-extraction-from-website-question-pq-all-parameter-industry-screener
Sheet: Sheet1

Industry |  |  | No. | Ticker | Market [NAME] | P/E | Fwd P/E | PEG | P/S | P/B | P/C | P/FCF | EPS this Y | EPS next Y | EPS past 5Y | EPS next 5Y | Sales past 5Y | Price | Change | Volume
stocksonly |  |  | 1 | A | 35.25B | 49.50 | 27.63 | 5.32 | 6.60 | 7.08 | 25.96 | 77.83 | 0.261 | 0.1241 | 0.375 | 9.30% | 5.00% | 114.09 | -0.0023 | 983054
 |  |  | 2 | AA | 3.79B | - | 102.4 | - | 0.41 | 1.12 | 2.18 | 15.65 | -5.597 | 1.135 | -0.341 | - | -4.50% | 20.48 | 0.0054 | 3738648
 |  |  | 3 | AACG | 40.30M | - |  | - | 1.72 | 1.09 | 2.37 | - | -0.377 |  | -0.48 | 25.00% | -22.50% | 1.24 | -0.0236 | 34515
 |  |  | 4 | [NAME] | 720.88M | - |  | - | - |  | - | - |  |  |  | - | - | 9.95 | 0.003 | 50212
 |  |  | 5 | AAIC | 110.59M | - | 12.06 | - | 61.44 | 0.57 | 12.43 | 5.22 | 1.098 | 0.0863 | -0.039 | - | 8.00% | 3.34 | 0.0091 | 136783
 |  |  | 6 | AAL | 9.04B | - |  | - | 0.37 |  | 1.09 | - | 0.252 | 0.722 | -0.007 | - | 1.40% | 14.98 | 0.0027 | 66015730
 |  |  | 7 | AAMC | 36.87M | - |  | - | 8.99 |  | 1.20 | 6.58 | 0.742 |  | -0.158 | - | -48.20% | 22.76 | 0.0071 | 622
 |  |  | 8 | AAME | 42.11M | 62.30 |  | - | 0.22 | 0.33 | 4.73 | 8.96 | 0.287 |  | -0.171 | - | 3.60% | 2.06 | -0.0039 | 4480
 |  |  | 9 | AAN | 4.35B | - | 12.69 | - | 1.04 | 2.66 | 9.26 | 10.10 | -0.835 | -0.0089 | -0.157 | 16.00% | 7.90% | 64.67 | 0.0036 | 322602
 |  |  | 10 | AAOI | 193.73M | - |  | - | 0.84 | 0.7 | 4.14 | - | -0.105 | 0.463 | -0.688 | 13.00% | 7.90% | 8.14 | -0.0344 | 527500
 |  |  | 11 | AAON | 3.44B | 45.78 | 50.71 | 3.81 | 6.61 | 9.99 | - | 56.69 | 0.27 | -0.0877 | 0.051 | 12.00% | 5.70% | 65.92 | 0.0008 | 58072
 |  |  | 12 | AAP | 10.14B | 21.81 | 15.84 | 1.83 | 1.03 | 2.75 | 9.49 | 16.41 | 0.211 | 0.1035 | 0.004 | 11.90% | -0.30% | 149.93 | 0.0035 | 459782
 |  |  | 13 | AAPL | 1972.72B | 35.69 | 26.99 | 2.82 | 7.19 | 30.44 | 21.69 | 33.28 | 0.102 | 0.0928 | 0.073 | 12.64% | 3.30% | 116.59 | 0.0048 | 46679104
 |  |  | 14 | AAT | 1.84B | 47.90 | 41.92 | 15.97 | 5.07 | 1.41 | 11.83 | - | 1.015 | 0.3846 | 0.105 | 3.00% | 7.10% | 30.18 | -0.0102 | 97451
 |  |  | 15 | AAU | 132.50M | - |  | - | - | 2.22 | 49.07 | - | -0.032 |  | 0.317 | - | - | 1.02 | 0.0241 | 210706
 |  |  | 16 | AAWW | 1.54B | - | 6.52 | - | 0.51 | 0.73 | 2.15 | 1.88 | -2.186 | -0.2891 | -0.361 | 10.00% | 8.80% | 56.33 | 0.0057 | 152944
 |  |  | 17 | [NAME] | 8.12B | - | 97.33 | - | 12.95 | 8.9 | 16.02 | - | -0.971 | 0.1622 | -0.474 | 18.80% | 26.40% | 125.55 | -0.0171 | 271779
 |  |  | 18 | AB | 3.07B | 11.76 | 10.64 | 1.07 | 10.40 | 2.09 | - | - | -0.007 | 0.1284 | 0.064 | 11.01% | 5.80% | 32.36 | 0.0147 | 105105
 |  |  | 19 | ABB | 57.69B | 119.28 |  | 8.17 | 2.22 | 3.37 | 6.68 | 32.85 | -0.279 |  | -0.153 | 14.60% | -6.80% | 26.6 | 0.0019 | 1018290
 |  |  | 20 | ABBV | 183.96B | 22.93 | 8.61 | 2.47 | 4.53 | 12.15 | 23.14 | 22.66 | 0.423 | 0.1633 | 0.368 | 9.27% | 10.80% | 104.89 | 0.0066 | 4415827
Spreadsheet: 0573e495-84c1-4d0e-b025-2cd05b9abca2
Sheet: 2-Cover Page

RTTT Early Childhood
[NAME]
Accreditation Program for Trainers - Teaching Strategies - Gold Grant
YEAR ONE-July 1, 2014 - Sept 30, 2015, YEAR TWO-July 1 1, 2015 thru Sept 30, 2016, YEAR THREE-July 1, 2016 thru Sept 30, 2016
 | CFDA:  84-365 |  |  | STATE GRANT CODE:  5365
 | Agency Name:
 | Agency DUNS #: |  | REQUIRED
 | Is Agency Active on SAM.gov |  | REQUIRED
 | Budget Report:
 | Revision number:
 | Date:
 | Name of person completing this information
 | Name:
 | Phone No.:
 | E-mail:
 | SUBMIT THE INITIAL RFP BUDGET TO: |  | [EMAIL]
 | Submit this Excel file to: | [EMAIL]
 | Grants Fiscal Staff Contact | Phone No.      E-mail Address
 | Marti Rodriguez | [PHONE] [EMAIL]
 |  | 1314v2
Spreadsheet: 356662d1415181655-column-sort-without-chaning-formulae-jc-booking-september-2014
Sheet: 9th

Date |  |  |  |  |  |  |  |  |  |  |  | DAY SHEET
Job No | Due | Contact | Contact No. | Car | Imax | 13 Pax | 20 Pax | 24 Pax | 29 Pax | 44 Pax | FROM | TO | Retn | Price  $ | Dep  $ | Bal | Mode | Pax | Trailer | Con | Bus | Des | Driver
9224 | 1145 | [NAME] College Rosewater | [PHONE] |  |  |  |  | 1 |  |  | Mt Carmel College Rosewater | St Clair Rec Centre Woodville | y | 99 | 0 |  | acct | 22 |  |  |  |  | [NAME]
 | 1250 | [NAME] College Rosewater | [PHONE] |  |  |  |  | 1 |  |  | St Clair Rec Centre Woodville | Mt Carmel College Rosewater |  | 99 | 0 |  | acct | 22 |  |  |  |  | [NAME]
 | 0730 | [NAME] Mt Carmel College Rosewater |  |  |  |  | 1 |  |  |  | Mt Carmel College Rosewater | West Lakes Aquatic Centre | y | 88 | 0 |  | acct | 18 |  |  |  |  | Cat
 | 0940 | [NAME] Mt Carmel College Rosewater |  |  |  |  | 1 |  |  |  | West Lakes Aquatic Centre | Mt Carmel College Rosewater |  | 88 | 0 |  | acct | 18 |  |  |  |  | Cat
 | 0900 | [NAME] Christian School 4 Crowle Rd Paradise | 83372966 |  |  |  | 1 |  |  |  | Sunrise Christian School 4 Crowle Rd Paradise | Birwood Museum | y | 145 | 0 |  | acct | 19 |  |  |  |  | Dom
 | 1400 | [NAME] Christian School 4 Crowle Rd Paradise | 83372966 |  |  |  | 1 |  |  |  | Birwood Museum | Sunrise Christian College |  | 145 | 0 |  | acct | 19 |  |  |  |  | Dom
 | 1500 | Georgina | [PHONE] |  |  | 1 |  |  |  |  | Mitcham Girls High | Gleninga High | n | 66 | 0 |  | acct |  |  |  |  |  | Cat
 |  |  |  |  |  |  |  |  |  |  | Malaysian Airlines CXLD for today | No Transfers
 |  |  |  |  |  |  |  |  |  |  | Air Asia x - 0800 Hotel
 |  |  |  |  |  |  |  |  |  |  | Air Asia x - 0900 Apt
TOTAL
Spreadsheet: 479789d1473587200-auto-numbering-column-with-sort-m_to_do_list
Sheet: To-Do-List

To-Do List
Nr. | Detected on | Detected by | Topic | Status | Responsible | Due Date | Due in Days | Finished Date
 | 2016-09-02 00:00:00 | 1-M | Test | in Arbeit |  | 2016-09-08 00:00:00
 | 2016-09-02 00:00:00 | 2-KJS | Prüfe | in Arbeit |  | 2016-09-22 00:00:00
 | 2016-09-02 00:00:00 | 3-LKU | Telefon | in Arbeit |  | 2016-09-06 00:00:00
 | 2016-09-02 00:00:00 | 4-UWP | Auto | Offen |  | 2016-09-12 00:00:00
Spreadsheet: 827439d1682694306-compare-two-dates-for-a-specific-value-the-same-value-in-2-sheets-sample
Sheet: Sheet2

Company | Number | Name | Ent | Ent 2 | Tid | Tid backup | Serial | Start Date IGO | End Date IGO
Apple Inc | 45819 | Cable | Care | Tho | 12 | 365 | 10179FC | 2023-08-11 | 2023-12-31
Apple Inc | 45820 | Cable | Care | Tho | 12 | 365 | 10179FA | 2021-01-05 | 2025-10-30 | N
Spreadsheet: kate_symes__18177__MidC 2-26
Sheet: DJ Mid-C Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-02-26 00:00:00 |  | 245.45 | 11424 | 227.06 | 6928
 | 2001-02-25 00:00:00 |  | 240 | 800 | 210 | 0 | 173.83 | 962 | 159.04 | 584 |  | 227.06 | 20784
 | 2001-02-24 00:00:00 |  | 194.5 | 20624 | 152.04 | 7328 | 186.82 | 2727 | 184.22 | 870
 | 2001-02-23 00:00:00 |  | 194.65 | 20624 | 152.04 | 7328 | 278.92 | 300 | 186.49 | 208
 | 2001-02-22 00:00:00 |  | 253.75 | 17824 | 217.96 | 5880 | 190.34 | 576 | 143.24 | 795
 | 2001-02-21 00:00:00 |  | 291.88 | 11824 | 261.34 | 6928 | 295 | 50 | 220.57 | 485
 | 2001-02-20 00:00:00 |  | 326.7 | 22224 | 310.97 | 5328 | 275 | 78 | 222.94 | 375
 | 2001-02-19 00:00:00 |  | 326.67 | 22624 | 310.97 | 5328 | 335.35 | 174 | 259.78 | 115
 | 2001-02-18 00:00:00 |  | 325 | 800 | 310 | 0 | 275.26 | 476 | 266.22 | 555 |  | 336.69 | 11784
 | 2001-02-17 00:00:00 |  | 349.98 | 15824 | 336.58 | 3800 | 347.69 | 281 | 332.5 | 0
 | 2001-02-16 00:00:00 |  | 460.66 | 15248 | 410.94 | 5160 | 397.28 | 230 | 350 | 40
 | 2001-02-15 00:00:00 |  | 460.66 | 15248 | 410.94 | 5160 | 348.8 | 1693 | 398.23 | 784
 | 2001-02-14 00:00:00 |  | 327.05 | 15664 | 314.82 | 3928 | 479.05 | 452 | 472.12 | 165
 | 2001-02-13 00:00:00 |  | 335.68 | 13424 | 322.6 | 4728 | 386.38 | 1053 | 330 | 0
 | 2001-02-12 00:00:00 |  | 302.64 | 12624 | 279.2 | 4528 | 271.84 | 1346 | 324.32 | 544
 | 2001-02-11 00:00:00 |  | 285 | 0 | 270 | 0 | 312.37 | 316 | 326.04 | 96 |  | 278.81 | 12600
 | 2001-02-10 00:00:00 |  | 276.16 | 15824 | 238.78 | 3328 | 322.06 | 790 | 309.3 | 328
 | 2001-02-09 00:00:00 |  | 276.16 | 15824 | 238.78 | 3328 | 341.87 | 3340 | 307.19 | 1050
 | 2001-02-08 00:00:00 |  | 381.43 | 15120 | 316.79 | 3376 | 341.12 | 2521 | 320.97 | 373
 | 2001-02-07 00:00:00 |  | 274.49 | 8688 | 253.14 | 4024 | 294.97 | 2143 | 251.02 | 216
 | 2001-02-06 00:00:00 |  | 213.71 | 10784 | 195.79 | 4096 | 259.92 | 63 | 196.16 | 307
 | 2001-02-05 00:00:00 |  | 200.43 | 11824 | 196.63 | 3968 | 204.52 | 1904 | 179.61 | 727
 | 2001-02-04 00:00:00 |  | 200 | 0 | 185 | 0 | 181.95 | 1513 | 175.11 | 1100 |  | 196.25 | 10704
 | 2001-02-03 00:00:00 |  | 222.8 | 15824 | 195.9 | 7648 | 185 | 35 | 199.94 | 233
 | 2001-02-02 00:00:00 |  | 222.8 | 15824 | 195.9 | 7648 | 203.95 | 380 | 200 | 48
 | 2001-02-01 00:00:00 |  | 355.71 | 7984 | 306.05 | 3728 | 255.73 | 1202 | 198.09 | 315
 | 2001-01-31 00:00:00 |  | 409.15 | 12656 | 342.56 | 3280 | 313.68 | 3766 | 275 | 70
 | 2001-01-30 00:00:00 |  | 468.99 | 11456 | 403.48 | 2872 | 383.47 | 304 | 351 | 25
 | 2001-01-29 00:00:00 |  | 420.48 | 19824 | 407.62 | 3832 | 383.33 | 4070 | 304.86 | 1442
 | 2001-01-28 00:00:00 |  | 450 | 800 | 350 | 0 | 488.38 | 355 | 460.46 | 416 |  | 408.68 | 12240
 | 2001-01-27 00:00:00 |  | 294.85 | 19024 | 254.41 | 4032 | 456.54 | 845 | 457.01 | 236
 |  |  |  |  |  | ..
Spreadsheet: 673811d1587551839-is-there-a-way-to-simplify-sumif-formulas-across-multiple-sheets-home-finance-2020
Sheet: MonAvg

 | Expenses
 | Addis Savings | Alcohol | Amusement | Anniversary | Auto Ins | [NAME] | Bathroom Supplies | Birthday Supplies | Birthdays | Books | Cards | CC Interest | Charity | Christmas | Clothes | Coffee | Cosmetics | Deploy
 | Diapers | Dine In | Electric | Electronics | Eye Ins | Fast Food | Fees | Flights | Fuel | Furnishing | Games | Groceries | Hair | Hobbies | Holiday Décor | Holiday Wrapping | Home Supplies | Hotels
 | Hygiene | Improvements | International Fees | Internet | IRA | KClothes | KHygiene | [NAME] | KMedical | KShoes | KSupplies | Laundry | Life Ins | Markets | Medicine | Misc | Movies | Music
 | Nails | Natural Gas | NEX Markets | Office Supplies | Oil Supplies | Oils | Outdoors | Parking | Parts | Phone | Public Trans | Registration | Rent | Renters Ins | Road Tax | School Supplies | Service | Shipping
 | Shoes | Souveniers | Sports | Subscriptions | Tips | Tolls | Toys | Trust | Tuition | Uniform | WD Euros | Wipes
 | Income
 | ATM Rebates | Checks | Dividends | Other Inc | Paycheck | Tax Return
Spreadsheet: 165071d1341001503-trying-to-find-sums-with-n-a-involved-excel-forum
Sheet: Sheet2

Acct. # |  | Month |  | Account Name
521278 |  | 0 |  | RAM IND LBR-PHYS INV CNT
521279 |  | 0 |  | RAM IND LBR-R&M/MACHINES
521280 |  | 0 |  | RAM IND LBR-R&M/TOOLS,FIX
521281 |  | 0 |  | RAM IND LBR-CUST DEMO
521282 |  | 0 |  | RAM IND LBR-TRAIN/IN HSE
521283 |  | 0 |  | RAM IND LBR-SHIP & RECV
522900 |  | #N/A |  | #N/A
522950 |  | 0 |  | LOST TIME - GEN
522960 |  | 0 |  | LOST TIME - FLT
522970 |  | 0 |  | LOST TIME - RAM
Various |  |  |  | Various Total
521300 |  | 0 |  | IND LABOR - SHIP & REC
521400 |  | 23266.92 |  | OVERTIME PREMIUM
521500 |  | 0 |  | NIGHT SHIFT PREMIUM
521600 |  | 4526.16 |  | PAID HOLIDAY COMPENSATION
521700 |  | 1000 |  | VACATION PROVISION
521800 |  | 0 |  | [NAME],BEREAVMT&SICK PAY
 |  |  |  | Payroll Subtotal
526500
526550
526560
Various |  |  |  | Various Total
527100
527200
527300
527305
527310
527700
 |  |  |  | Other SubTotal
 |  |  |  | Total
Spreadsheet: 17f32386-7065-4f8f-81d4-b5b6ec158ad1
Sheet: Sheet1

TE name | class | full length TE species distribution | germline vs. somatic | Ago3/Aub dependency
OSVALDO | LTR | D. melanogaster only |  | group I (Ago3/Aub dependent)
GYPSY | LTR | D. melanogaster only | somatic follicle | group III (Ago3/Aub independent)
Gypsy5 | LTR | shared | somatic follicle | group III (Ago3/Aub independent)
MDG3 | LTR | shared | germline | group I (Ago3/Aub dependent)
Transpac | LTR | shared | germline and somatic follicle | group I (Ago3/Aub dependent)
412 | LTR | shared | germline and somatic follicle | group III (Ago3/Aub independent)
Blood | LTR | shared | germline and somatic follicle | group III (Ago3/Aub independent)
DIVER | LTR | shared | germline | group I (Ago3/Aub dependent)
Tabor | LTR | shared | somatic follicle | group III (Ago3/Aub independent)
Opus | LTR | shared | germline | group I (Ago3/Aub dependent)
TOM | LTR | neither
Burdock | LTR | shared | germline | group I (Ago3/Aub dependent)
FLEA | LTR | shared | germline | group I (Ago3/Aub dependent)
Gypsy12 | LTR | D. melanogaster only | germline | group I (Ago3/Aub dependent)
Ninja | LTR | neither
Gypsy8 | LTR | D. melanogaster only | germline | group I (Ago3/Aub dependent)
MDG1 | LTR | shared | germline and somatic follicle | group III (Ago3/Aub independent)
Invader1-I_AG | LTR | neither
176 | LTR | D. melanogaster only | germline | group III (Ago3/Aub independent)
Invader2 | LTR | shared | germline | group I (Ago3/Aub dependent)
BS | Non_LTR | D. melanogaster only | germline | group I (Ago3/Aub dependent)
J1 | Non_LTR | shared | germline | group I (Ago3/Aub dependent)
DOC6 | non_LTR | D. melanogaster only | germline | group I (Ago3/Aub dependent)
I | non_LTR | shared | germline | group I (Ago3/Aub dependent)
IVK | Non_LTR | D. melanogaster only | germline | group I (Ago3/Aub dependent)
G7 | Non_LTR | D. melanogaster only
R1 | Non_LTR | shared | germline | group I (Ago3/Aub dependent)
FW | Non_LTR | shared | germline | group I (Ago3/Aub dependent)
Agam.110.111..centroid | Satellite | neither
BARI1 | TIR | shared | germline | group I (Ago3/Aub dependent)
dana.group.25 | TIR | neither
dmoj.group3 | TIR | neither
Spreadsheet: 71451d1272185900-draw-rules-draw-rules
Sheet: Sheet1

Date Today | Deposit Date | Amount  $ | Balance | Total Deposits Days | Total Chances
 | 2010-04-07 00:00:00 | 250
 | 2010-04-11 00:00:00 | 4821
 | 2010-04-14 00:00:00 | 550
 | 2010-04-18 00:00:00 | 379
 | The Draw Rules
 | 1)-If any Customer deposit any amount >=50$ he will be eligible to enter the draw
 | 2)-If the deposit amount stay in the account between [7 & 60 days], then he will be eligible for one chance draw for each 50$.
 | 3)-Any additional 60 days added to the deposit date will increase the draws chances 1 more, for example if the deposit amount stay in account 120days, the customer will be eligible for 2 chances, 180 will be eligible 3 chances….etc. The longer the investment period, the more chances to win.
 | What I need
 | 1)-In Cell F3:F6 I need to know for each 50$ deposit how many chances this customer can get?