tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 732241d1620838687-matriculation-worksheet-stuck-sample1
Sheet: Sheet1

 |  |  | Months from Opening
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  | # of Clients | 7.68 | 15 | 23.04 | 30 | 30 | 30 | 30 | 40 | 40 | 50 | 50 | 50
 |  | New Clients | 0
CENTER 1 |  | 0 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-21 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00
Census |  |  |  | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1
Spreadsheet: 840698d1692905273-complex-fiscal-year-date-calculations-template-for-excel-website
Sheet: Sheet1

DATE | 2023-07-31 00:00:00
Reason | Date Vacant | Date Filled | Days Vacant THROUGH 7/31/23 | Days Vacant FY24 | Total Days Vacant
Retirement | 2022-09-30 00:00:00 |  | 31 | 67 | 328
Resignation | 2022-12-23 00:00:00
Resignation | 2022-12-24 00:00:00 | 2023-03-01 00:00:00 | 0 | 0 | 67
Promotion | 2023-01-01 00:00:00
Retirement | 2023-01-02 00:00:00
Promotion | 2023-03-04 00:00:00 | 2023-05-01 00:00:00 | 0 | 0 | 58
Termination | 2023-06-30 00:00:00 | 2023-07-05 00:00:00 | 4 | 4 | 5
Retirement | 2023-07-01 00:00:00 | 2023-07-10 00:00:00 | 9 | 9 | 9
resignation | 2023-07-01 00:00:00 |  | 31 | 67 | 67
Resignation | 2023-07-05 00:00:00
Resignation | 2023-07-06 00:00:00
Promotion | 2023-07-07 00:00:00
Retirement | 2023-08-01 00:00:00
Retirement | 2023-08-04 00:00:00
Promotion | 2023-08-16 00:00:00
Promotion | 2023-08-25 00:00:00
Retirement | 2023-09-10 00:00:00
Retirement | 2023-10-01 00:00:00
Spreadsheet: 116023d1311506325-selective-columns-marcol
Sheet: bd

Baxter. [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: darrell_schoolcraft__7334__imball0203
Sheet: crosstex

Crosstexx Energy Services |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
 | contr 21571 - poi 56935 |  | contr 23994 - poi 58444
 | Integrated Services DP |  | I.S.I. Farm Tap- [NAME]
 | Measured | Scheduled | Measured | Scheduled
1 | -2089 | -1963 | -2500 | -2000
2 | -2301 | -1963 | -860 | -2000
3 | -2292 | -1963 | -955 | -2000
4 | -2253 | -1963 | -2405 | -2000
5 | -1124 | -1963 | -2271 | -2000
6 | -2011 | -1963 | -2203 | -2000
7 | -2399 | -1963 | -2160 | -2000
8 | -2198 | -1963 | -1864 | -2000
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
index
2002-02-28 00:00:00 |  |  |  |  |  |  | 713.49
2002-03-08 00:00:00
CBS Volume |  |  |  |  |  |  | 2808
Spreadsheet: 761033d1640610657-cumulative-retentions-example
Sheet: Sheet1

 |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 |  |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 |  |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6
 | Month | Customers |  |  |  |  |  |  | Month | Cumulative Customers |  |  |  |  |  |  | Month | [NAME]
 | 1 | 9.469594345284632 | 37.30675590574082 | 20.53634767027444 | 30.78872309134697 | 14.23116046352917 | 15.29580281810527 |  | 1 |  |  |  |  |  |  |  | 1 | 1
 | 2 | 25.4626870173209 | 79.13554283035933 | 42.55469981159961 | 62.51043779152265 | 28.63395301305065 | 30.77607762999675 |  | 2 |  |  |  |  |  |  |  | 2
 | 3 | 29.48311128321368 | 83.93163633522958 | 44.09017867078104 | 63.45756563684873 | 28.80662006639568 | 30.96166201771531 |  | 3 |  |  |  |  |  |  |  | 3
 | 4 | 34.13833938056321 | 89.01840217372833 | 45.68106140632467 | 64.4190439040737 | 28.98032832810259 | 31.14836550726937 |  | 4 |  |  |  |  |  |  |  | 4
 | 5 | 39.52860349328372 | 94.41345685092398 | 47.32934712717143 | 65.39509002383237 | 29.15508407681476 | 31.33619484701169 |  | 5 |  |  |  |  |  |  |  | 5
 | 6 | 45.76996193959169 | 100.1354845388588 | 49.03710707505907 | 66.38592472116316 | 29.33089362903675 | 31.52515682598864 |  | 6 |  |  |  |  |  |  |  | 6
 | 7 | 55.65995371548336 | 106.2043017836381 | 50.80648722725193 | 67.39177206542321 | 29.5077633393626 | 31.71525827418555 |  | 7 |  |  |  |  |  |  |  | 7
 | 8 | 61.53361717289619 | 112.6409261341617 | 52.63971099318369 | 68.41285952095991 | 29.68569960070548 | 31.9065060627736 |  | 8 |  |  |  |  |  |  |  | 8
 | 9 | 68.0271144624983 | 119.4676489301714 | 54.53908200840165 | 69.44941799855022 | 29.86470884452883 | 32.09890710435817 |  | 9 |  |  |  |  |  |  |  | 9
 | 10 | 41.36322035156932 | 63.3540562508485 | 28.25349351466167 | 35.25084095380958 | 15.02239877053938 | 16.14623417661434 |  | 10 |  |  |  |  |  |  |  | 10
 | 11 | 45.72818330324247 | 67.19369602362721 | 29.27294946622163 | 35.78494460462487 | 15.11298609980896 | 16.24359840280497 |  | 11 |  |  |  |  |  |  |  | 11
 | 12 | 50.5537704859967 | 71.26604123718037 | 30.32918991087911 | 36.32714073499796 | 15.20411968433042 | 16.34154974995757 |  | 12 |  |  |  |  |  |  |  | 12
Spreadsheet: 808614d1670534867-referencing-multiple-tables-named-ranges-variable-column-retrieval-mock-up-for-formula-for-excel
Sheet: Sheet1

Name | Class | SEND | SEN NEED | Photo | PP | Target | T-Initial | Block | Block Target | Overall | Practical | Listening | Listening - Grade |  |  | HHR |  | F | I | A |  | MA |  | F | I | A
SurnameA, FirstA | 8A1 |  |  | Yes | ✕ | Foundation |  | HHR |  |  | S | 10 | E |  |  | 22 | A+ | E | E | E |  | 22 | A+ | X | X | X
SurnameB, FirstB | 8A1 |  |  | Yes | ✕ | Intermediate |  | HHR |  |  | S | 10 | M |  |  | 21 | A+ | E | E | E |  | 21 | A+ | X | X | X
SurnameC, FirstC | 8A1 |  |  | Yes | ✕ | Advanced |  | HHR |  |  | S | 10 | S |  |  | 20 | A | E | E | M |  | 20 | A | X | X | Y
SurnameD, FirstD | 8A1 |  |  | Yes | ✕ | Advanced |  | HHR |  |  | S | 15 | M |  |  | 19 | A | E | E | M |  | 19 | A | X | X | Y
SurnameE, FirstE | 8A1 |  |  | Yes | ✕ | Foundation |  | MA |  |  | S | 10 | X |  |  | 18 | A | E | E | M |  | 18 | A | X | X | Y
SurnameF, FirstF | 8A1 |  |  | Yes | ✕ | Intermediate |  | MA |  |  | S | 10 | Y |  |  | 17 | A | E | E | M |  | 17 | A | X | X | Y
SurnameG, FirstG | 8A1 |  |  | Yes | ✕ | Advanced |  | MA |  |  | S | 10 | Z |  |  | 16 | A | E | E | M |  | 16 | A | X | X | Y
SurnameH, FirstH | 8A1 |  |  | Yes | ✕ | Advanced |  | MA |  |  | S | 15 | Y |  |  | 15 | A | E | E | M |  | 15 | A | X | X | Y
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | I | E | M | S |  | 14 | I | X | Y | Z
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | I | E | M | S |  | 13 | I | X | Y | Z
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | I | E | M | S |  | 12 | I | X | Y | Z
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | I | E | M | S |  | 11 | I | X | Y | Z
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | I | E | M | S |  | 10 | I | X | Y | Z
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | I | E | M | S |  | 9 | I | X | Y | Z
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | F | M | S | D |  | 8 | F | Y | Z | U
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | F | M | S | D |  | 7 | F | Y | Z | U
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | F | M | S | D |  | 6 | F | Y | Z | U
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | F | M | S | D |  | 5 | F | Y | Z | U
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | U | S | D | D |  | 4 | U | Z | U | U
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | U | S | D | D |  | 3 | U | Z | U | U
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | U | S | D | D |  | 2 | U | Z | U | U
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | U | S | D | D |  | 1 | U | Z | U | U
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | U | S | D | D |  | 0 | U | Z | U | U
Spreadsheet: 42992d1241611234-creating-a-drop-down-list-from-another-table-of-data-book1a
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] as Range Set Rng = Range(Range("A1"), Range("A" & Rows.Count).End(xlUp))
Suppliers | Manager |  | Q1
Supplier 1 | [NAME] |  | Supplier 1 | Jan | Feb | Mar | Apr | May | Jun | July | Aug | Sept | Oct | Nov | Dec
Supplier 2 | [NAME] |  | Supplier 2
Supplier 3 | [NAME] |  | Supplier 3
Supplier 4 | [NAME] |  | Supplier 4
Supplier 5 | [NAME] |  | Supplier 5
Supplier 6 | [NAME] |  | Supplier 6
Supplier 7 | [NAME] |  | Supplier 7
Supplier 8 | [NAME] |  | Supplier 8
Supplier 9 | [NAME] |  | Supplier 9
Supplier 10 | [NAME]
Supplier 11 | [NAME]
Supplier 12 | [NAME]
Supplier 13 | [NAME]
Supplier 14 | [NAME]
Supplier 15 | [NAME]
Supplier 16 | [NAME]
Supplier 17 | [NAME]
Supplier 18 | [NAME]
Supplier 19 | [NAME]
Supplier 20 | [NAME]
Supplier 21 | Emma
Supplier 22 | Emma
Supplier 23 | [NAME]
Supplier 24 | [NAME]
Supplier 25 | [NAME]
Supplier 26 | [NAME]
Supplier 27 | [NAME]
Supplier 28 | [NAME]
Supplier 29 | [NAME]
Supplier 30 | [NAME]
Supplier 31 | [NAME]
Supplier 32 | [NAME]
Supplier 33 | [NAME]
Supplier 34 | [NAME]
Supplier 35 | [NAME]
Supplier 36 | [NAME]
Supplier 37 | [NAME]
Supplier 38 | [NAME]
Supplier 39 | [NAME]
Supplier 40 | Rachel
Supplier 41 | Rachel
Supplier 42 | [NAME]
Supplier 43 | [NAME]
Supplier 44 | [NAME]
Supplier 45 | [NAME]
Supplier 46 | [NAME]
Supplier 47 | [NAME]
Supplier 48 | [NAME]
Supplier 49 | [NAME]
Supplier 50 | [NAME]
Supplier 51 | [NAME]
Supplier 52 | [NAME]
Supplier 53 | [NAME]
Supplier 54 | [NAME]
Supplier 55 | [NAME]
Supplier 56 | [NAME]
Supplier 57 | [NAME]
Supplier 58 | [NAME]
Supplier 59 | [NAME]
Supplier 60 | [NAME]
Supplier 61 | [NAME]
Supplier 62 | [NAME]
Supplier 63 | [NAME]
Supplier 64 | [NAME]
Supplier 65 | [NAME]
Supplier 66 | [NAME]
Supplier 67 | [NAME]
Supplier 68 | [NAME]
Supplier 69 | [NAME]
Supplier 70 | [NAME]
Supplier 71 | Template
Supplier 72 | Unknown
Supplier 73 | Unknown
Supplier 74 | Unknown
Supplier 75 | Unknown
Spreadsheet: 46574d1245420613-num-error-copy-of-savings-and-spending-plan5test
Sheet: Savings & Spending Plan

 | See how you can pay off your debts faster
 | Enter your       Credit Cards         & Loans | Enter current interest rate - % | Enter what you owe (Update monthly) | Enter the minimum payment | Enter the due date | How many months will it take you to pay off if you paid the minimum payment | Enter how much you are able to pay monthly.    Must be more than the minimum payment |  | How many months will it take you to pay off if you are able to pay that amount
 | Sample Credit Card | 0.07 | 40000 | 230 |  | 121 | 233 |  | 71
 |  | 0.07 | 40000 | 200 |  | 133 | 234 |  | 74
 | Total |  | 80000 | 430 |  |  | 467
Spreadsheet: 220601d1363201375-need-formula-to-figure-out-federal-tax-on-worksheet-john-h-7
Sheet: Tax table Sheet

Single Amount | Single Percent | Married Amount | Married Percent | Federal W/H Allowance
2650 | 0.1 | 8000 | 0.1 | 94
9800 | 0.15 | 22600 | 0.15
31500 | 0.25 | 66200 | 0.25
69750 | 0.28 | 120750 | 0.28
151950 | 0.33 | 189600 | 0.33
328250 | 0.35 | 333250 | 0.35
9000000 | 0.35 | 9000000 | 0.35
Spreadsheet: 05b1e1b7-63ea-4603-a837-b4193f07c3ab
Sheet: Sheet1

Revenues, State Totals | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18
By Division - Source:  [NAME] created, probably from AEA annual reports
Major Program | 1989 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001
Special Education Support | 81098137 | 91902246 | 97904059 | 102484149 | 110517556 | 114765450 | 119015776 | 122009924 | 128701245 | 140257302
Media Services | 12679538 | 14854660 | 15745534 | 16351912 | 17240444 | 17790375 | 18501870 | 19948451 | 21961645 | 22728024
Education Services | 20378717 | 20575168 | 22500815 | 23713588 | 25752614 | 26610266 | 30569248 | 31736336 | 34231149 | 35137885
Controlled Funding - Source:  Aid and Levy State Totals
 | 1989 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006
Special Education Support | 66001316 | 67449877 | 72402113 | 76288066 | 79237211 | 81796629 | 84464318 | 88277543 | 92444404 | 96381311 | 100332319 | 103382454 | 107245598 | 111026348 | 104834144 | 107015031 | 97484247 | 113350055
Media Services | 12022593 | 12303416 | 13270809 | 13998499 | 14778997 | 15190099 | 15683971 | 16320417 | 16990907 | 17588405 | 18164970 | 18608679 | 19184863 | 19731031 | 19728417 | 20026904 | 20282059 | 20989508
Education Services | 13344754 | 13647499 | 14719203 | 15439204 | 16297614 | 16751174 | 17299531 | 18004539 | 18742111 | 19405663 | 20042454 | 20534743 | 21167941 | 21771047 | 21767366 | 22137629 | 22418300 | 23196793
Spreadsheet: 4f1d76ab-eef0-4ad9-8cc4-b265cfd1fb46
Sheet: Sheet1

2008-09-09 00:00:00 | CONGRESSIONAL DISTRICT NO. 1 - DEMOCRATIC | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | Shea-Porter, d | Bradley, r | [NAME], r | [NAME], r | Stephen, r | [NAME]
Albany | 46
Alton | 98 | 3 |  |  |  | 2
Auburn | 138 | 3 |  |  | 1 | 1
[NAME] | 259 | 1 |  |  | 1
Barnstead | 138 | 1
[NAME] | 115
Bedford | 497 | 5 |  |  | 4 | 2
Belmont | 107 | 4
Brentwood | 91
[NAME] | 45 | 2 |  |  | 2
Candia | 114 | 2 |  |  |  | 2
Center Harbor | 17
Chatham | 14
Chester | 83
Conway | 278 | 1 |  |  |  | 3
Danville | 101 | 1 |  |  | 1
[NAME] | 147
[NAME] | 512
[NAME] | 149 | 3 |  |  |  | 1
[NAME] | 167 |  |  |  | 1 | 2
[NAME] | 251 | 2
[NAME] | 253 | 1 |  |  | 1 | 1
[NAME] | 180 | 2 |  |  | 1
[NAME] 6 | 194
[NAME] | 515 | 1 |  |  |  | 2
East Kingston | 74
Eaton | 28 | 1
[NAME] | 87 | 1
Epping | 144 |  |  |  |  | 1
Exeter | 609 | 1
Farmington | 168
Freedom | 80 |  |  |  | 1
Fremont | 47
Gilford | 193 | 3 |  |  | 2
Gilmanton | 79 | 1
Goffstown | 491 | 8 |  |  | 5
Greenland | 102
Hale's Location | 3
Hampstead | 167 | 1 |  |  | 1
Hampton | 627 | 1 |  |  | 3 | 3
[NAME] | 51
Hart's Location | 7
[NAME] | 296 | 4 |  |  | 7 | 1
[NAME] | 84
Kensington | 88
Kingston | 118 | 1
[NAME] | 74 | 1 |  |  | 1 | 1
[NAME] | 93 | 2 |  |  | 1
[NAME] 3 | 84
[NAME] | 49 | 1
[NAME] | 64
[NAME] 6 | 68
[NAME] | 217 |  |  |  |  | 1
[NAME] | 421 | 4 |  |  | 2 | 5
Madbury | 132 | 1
[NAME] | 108
[NAME] | 593 | 4 |  |  | 9 | 1
[NAME] | 439 | 1 |  |  | 10 | 3
[NAME] 3 | 260 | 1 |  |  | 4 | 2
[NAME] | 285 | 4 |  |  | 3 | 5
[NAME] | 239 | 1 |  |  | 1 | 2
[NAME] 6 | 394 | 5 |  |  | 7 | 2
[NAME] | 332 | 4 |  |  | 4 | 2
[NAME] 8 | 403 | 2 |  |  | 6 | 3
[NAME] 9 | 382 | 7 | 1 |  | 11 | 5
[NAME] 10 | 419 | 2 |  |  | 8 | 2
[NAME] 11 | 256 |  |  |  | 5 | 2
[NAME] 12 | 388 | 3 |  |  | 6 | 3
Meredith | 165 | 3 |  |  |  | 1
Merrimack | 491 | 2 |  |  | 2 | 6
[NAME] | 68 | 1 |  |  | 1
Milton | 133 | 3 |  |  | 2
Moultonborough | 115
New Castle | 79
New Durham | 86
New Hampton | 73 | 2
Newfields | 59 | 1
Newington | 39
Newmarket | 296 | 4 |  |  |  | 1
Newton | 69 | 1 |  |  |  | 1
[NAME] | 164
Northwood | 127 | 1 |  |  |  | 2
[NAME] | 95 | 1
Ossipee | 154 | 1 |  |  | 2
Plaistow | 130 |  |  |  |  | 2
Portsmouth Ward 1 | 236 |  |  |  |  | 2
Portsmouth Ward 2 | 321 | 2 |  |  | 1 | 1
Portsmouth Ward 3 | 120 | 1 |  |  |  | 2
Portsmouth Ward 4 | 248 | 2
Portsmouth Ward 5 | 320 | 1 |  |  | 2
[NAME] | 163 | 2 |  |  |  | 3
Rye | 261 | 1
Rochester Ward 1 | 203
[NAME] | 165 | 4 |  |  |  | 2
[NAME] 3 | 148
Rochester Ward 4 | 165
Rochester Ward 5 | 158
Rochester Ward 6 | 155
[NAME] | 142 | 4 |  |  | 2
Sandown | 66 | 1
Sandwich | 148
Seabrook | 116 | 1 |  |  | 2 | 1
[NAME] | 121 | 3 |  |  |  | 1
[NAME] | 79
[NAME] 3 | 80 | 1
[NAME] | 116 | 5
[NAME] 5 | 69 | 2
[NAME] | 30
[NAME] | 126 |  |  |  | 3
Stratham | 245 | 1 |  |  | 1 | 1
Tamworth | 185 |  |  |  |  | 3
Tuftonboro | 104 | 6
Wakefield | 148 | 1
Wolfeboro | 306 | 7
Totals | 20839 | 162 |  |  | 127 | 89
Spreadsheet: 686041d1594321651-retrieve-data-from-another-sheet-based-on-date-example
Sheet: River height

date | min_level | avg_level | max_level
2019-10-09 00:00:00 | 0.9 | 0.924 | 0.936
2019-10-10 00:00:00 | 0.873 | 0.885 | 0.899
2019-10-11 00:00:00 | 0.877 | 1.192 | 1.406
2019-10-12 00:00:00 | 1.264 | 1.293 | 1.314
2019-10-13 00:00:00 | 1.201 | 1.237 | 1.3
2019-10-14 00:00:00 | 1.072 | 1.127 | 1.201
2019-10-15 00:00:00 | 0.989 | 1.028 | 1.069
2019-10-16 00:00:00 | 0.938 | 0.964 | 0.988
Spreadsheet: 707385d1607242234-running-balance-based-on-customer-code-balance-based-on-customer-code
Sheet: Sheet1

I am kindly asking for the formula to calculate balance (Column H) based on customer code
Desired Outcome
Customer Code | Customer Name | Date | Invoice | Receipt | Debit | Credit | Balance
1 | [NAME] | 2020-01-01 00:00:00 | C001 |  | 1400 |  | 1400
1 | [NAME] | 2020-01-10 00:00:00 | C001 | R105 |  | 1400 | 0
4 | [NAME] | 2020-04-10 00:00:00 | C0029 |  | 132 |  | 132
4 | [NAME] | 2020-04-12 00:00:00 | [NAME] |  | 1300 |  | 1432
4 | [NAME] | 2020-12-01 00:00:00 | C0029 | R107 |  | 40 | 1392
4 | [NAME] | 2020-12-12 00:00:00 | [NAME] | R108 |  | 100 | 1292
4 | [NAME] | 2020-12-13 00:00:00 | C0031 |  | 3000 |  | 4292
10 | Forna | 2020-02-16 00:00:00 | C0027 |  | 200 |  | 200
2 | [NAME] | 2020-01-12 00:00:00 | C0022 |  | 1020 |  | 1020
3 | [NAME] | 2020-01-14 00:00:00 | C0022 | R102 |  | 1200 | -180
Customer Code | Customer Name | Date | Invoice | Receipt | Debit | Credit | Balance
1 | [NAME] | 2020-01-01 00:00:00 | C001 |  | 1400
1 | [NAME] | 2020-01-10 00:00:00 | C001 | R105 |  | 1400
4 | [NAME] | 2020-04-10 00:00:00 | C0029 |  | 132
4 | [NAME] | 2020-04-12 00:00:00 | [NAME] |  | 1300
4 | [NAME] | 2020-12-01 00:00:00 | C0029 | R107 |  | 40
4 | [NAME] | 2020-12-12 00:00:00 | [NAME] | R108 |  | 100
4 | [NAME] | 2020-12-13 00:00:00 | C0031 |  | 3000
10 | Forna | 2020-02-16 00:00:00 | C0027 |  | 200
2 | [NAME] | 2020-01-12 00:00:00 | C0022 |  | 1020
3 | [NAME] | 2020-01-14 00:00:00 | C0022 | R102 |  | 1200
Spreadsheet: 789697d1659295726-automatically-choose-values-from-range-to-find-the-closest-sums-example
Sheet: Sheet1

 |  |  |  |  | Table 1
 | V1 | 5846 |  |  | V1 | 5846 | V21 | 3562 | V41 | 3019
 | V2 | 5261 |  |  | V2 | 5261 | V22 | 3512 | V42 | 3007
 | V3 | 5116 |  |  | V3 | 5116 | V23 | 3487 | V43 | 2983
 | V4 | 4655 |  |  | V4 | 4655 | V24 | 3442 | [NAME] | 2979
 | V5 | 4547 |  |  | V5 | 4547 | V25 | 3415 | V45 | 2953
 | V6 | 4496 |  |  | V6 | 4496 | V26 | 3396 | V46 | 2947
 | V7 | 4343 |  |  | V7 | 4343 | V27 | 3364 | V47 | 2924
 | V8 | 4248 |  |  | V8 | 4248 | V28 | 3350 | V48 | 2901
 | V9 | 4245 |  |  | V9 | 4245 | V29 | 3301 | V49 | 2861
 | V10 | 4141 |  |  | V10 | 4141 | V30 | 3298 | V50 | 2843
 | V11 | 4102 |  |  | V11 | 4102 | V31 | 3287 | V51 | 2801
 | V12 | 4092 |  |  | V12 | 4092 | V32 | 3253 | V52 | 2758
 | V13 | 4041 |  |  | V13 | 4041 | V33 | 3230 | V53 | 2679
 | V14 | 3890 |  |  | V14 | 3890 | V34 | 3225 | V54 | 2671
 | V15 | 3833 |  |  | V15 | 3833 | V35 | 3175 | V55 | 2647
 | V16 | 3814 |  |  | V16 | 3814 | V36 | 3128 | V56 | 2629
 | V17 | 3780 |  |  | V17 | 3780 | V37 | 3115 | V57 | 2626
 | V18 | 3710 |  |  | V18 | 3710 | V38 | 3078 | V58 | 2620
 | V19 | 3656 |  |  | V19 | 3656 | V39 | 3065 | V59 | 2585
 | V20 | 3647 |  |  | V20 | 3647 | V40 | 3059 | V60 | 2583
 | V21 | 3562
 | V22 | 3512
 | V23 | 3487 |  |  | Table 2
 | V24 | 3442 |  |  | V1 | 5846 | V8 | 4248 | V41 | 3019
 | V25 | 3415 |  |  | V2 | 5261 | V9 | 4245 | V42 | 3007
 | V26 | 3396 |  |  | V3 | 5116 | V10 | 4141 | V43 | 2983
 | V27 | 3364 |  |  | V4 | 4655 | V11 | 4102 | [NAME] | 2979
 | V28 | 3350 |  |  | V5 | 4547 | V12 | 4092 | V45 | 2953
 | V29 | 3301 |  |  | V6 | 4496 | V13 | 4041 | V46 | 2947
 | V30 | 3298 |  |  | V7 | 4343 | V14 | 3890 | V47 | 2924
 | V31 | 3287 |  |  | V28 | 3350 | V15 | 3833 | V48 | 2901
 | V32 | 3253 |  |  | V29 | 3301 | V16 | 3814 | V49 | 2861
 | V33 | 3230 |  |  | V30 | 3298 | V17 | 3780 | V50 | 2843
 | V34 | 3225 |  |  | V31 | 3287 | V18 | 3710 | V51 | 2801
 | V35 | 3175 |  |  | V32 | 3253 | V19 | 3656 | V52 | 2758
 | V36 | 3128 |  |  | V33 | 3230 | V20 | 3647 | V53 | 2679
 | V37 | 3115 |  |  | V34 | 3225 | V21 | 3562 | V54 | 2671
 | V38 | 3078 |  |  | V35 | 3175 | V22 | 3512 | V55 | 2647
 | V39 | 3065 |  |  | V36 | 3128 | V23 | 3487 | V56 | 2629
 | V40 | 3059 |  |  | V37 | 3115 | V24 | 3442 | V57 | 2626
 | V41 | 3019 |  |  | V38 | 3078 | V25 | 3415 | V58 | 2620
 | V42 | 3007 |  |  | V39 | 3065 | V26 | 3396 | V59 | 2585
 | V43 | 2983 |  |  | V40 | 3059 | V27 | 3364 | V60 | 2583
 | [NAME] | 2979
 | V45 | 2953
 | V46 | 2947
 | V47 | 2924
 | V48 | 2901
 | V49 | 2861
 | V50 | 2843
 | V51 | 2801
 | V52 | 2758
 | V53 | 2679
 | V54 | 2671
 | V55 | 2647
 | V56 | 2629
 | V57 | 2626
 | V58 | 2620
 | V59 | 2585
 | V60 | 2583
Spreadsheet: daren_farmer__5395__hpl0801
Sheet: Sheet1

HPLN0801XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  [NAME]  (TU ELECTRIC)
 |  |  |  |  |  | ** Tuesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-08-01 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL
 |  |  |  |  | 0 to 60  0900hrs | 0 to 60  0900hrs
 |  |  |  |  | 60  to 0 2100hrs | 60  to 0 2100hrs
 |  | Firm Summary
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
Empire (Enron) |  | TOG 3 |  | Empire | 1.4 | 0
Empire (Enron) |  | [NAME]. |  | Empire | 8 | 8
Empire (Enron) |  | Oasis Turbine |  | Empire | 0 | 10
Empire (Enron) |  | Sandhills |  | Empire | 3.6 | 0
Empire (Enron) |  | Sterling Plant |  | Empire | 5 | 0
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher