tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 115750d1311264872-sumif-and-lookups-based-on-months-sample
Sheet: Sheet2

Dollar Values
 | January | February | March | April | May | June | July | August | September | October | November | December | Total
2012
2013
2014
 |  |  |  | Dollar Values
 |  |  |  |  | 2012 | 2013 | 2014
 |  |  |  | January
 |  |  |  | February
 |  |  |  | March
 |  |  |  | April
 |  |  |  | May
 |  |  |  | June
 |  |  |  | July
 |  |  |  | August
 |  |  |  | September
 |  |  |  | October
 |  |  |  | November
 |  |  |  | December
 |  |  |  | Total
Spreadsheet: ade9b324-3756-48bc-b2f2-163c251daf39
Sheet: Table III - ribosomal proteins

uc007atf.2
uc007bkv.2
uc007gcn.2
uc007hno.2
uc007leu.2
uc007lfk.2
uc007low.2
uc011ymh.1
uc007nrs.2
uc007shr.1
uc007sra.1
uc007vcs.2
uc007vlq.2
uc007wmt.2
uc007wvb.2
uc007yzv.2
uc007zlv.2
uc008aih.1
uc008axy.2
uc008ayb.2
uc008bpi.1
uc008bqp.2
uc008bzs.2
uc008cak.1
uc008cuj.1
uc008fay.2
uc008fpw.2
uc008uic.1
uc008vhr.1
uc008wah.1
uc008xnp.2
uc008ziq.3
uc008iwf.1
uc008jnz.1
uc008oiq.1
uc008ois.1
uc008ouf.1
uc008prc.2
uc009anl.2
uc009djc.1
uc009ewa.1
uc009eys.1
uc009fep.2
uc009fqs.1
uc012fgr.1
uc009gtk.1
uc009gww.1
uc009ibv.1
uc009ilr.1
uc009jdr.1
uc009jjn.1
uc009klf.1
uc012gkb.1
uc009pzt.1
uc009qbn.1
uc009qfm.1
uc008zrg.1
uc009scd.2
uc009scf.1
uc009scr.1
uc009syc.1
uc009tod.2
uc009tym.1
uc009ugf.2
uc007bee.2
uc007ihh.1
uc007ihg.1
uc007ksn.2
uc007ogm.2
uc008ayf.2
uc012bkg.1
uc009krv.1
uc009lfx.1
uc009ucx.1
uc007avm.2
uc007epx.2
uc007joi.1
uc007nrp.2
uc008rwn.1
uc009rjo.1
uc007osu.1
uc007ebh.2
uc011xbb.1
uc011xlj.1
Spreadsheet: 698886d1602225072-trying-to-generate-a-report-based-on-time-sheet-groups-by-earn-codes-sample-results-v2
Sheet: Sheet1

UserID | Name | Period | EarnCode | Hours
10 | [NAME] | 1/5/2018-1/18/2018 | Regular | 31.88
10 | [NAME] | 1/5/2018-1/18/2018 | Lunch | 0
16 | [NAME] | 1/5/2018-1/18/2018 | Regular | 32.63
16 | [NAME] | 1/5/2018-1/18/2018 | Lunch | 0
20 | Goege Fly | 1/5/2018-1/18/2018 | Regular | 68.9
20 | Goege Fly | 1/5/2018-1/18/2018 | Lunch | 0
5 | [NAME] | 1/5/2018-1/18/2018 | Regular | 39.35
5 | [NAME] | 1/5/2018-1/18/2018 | Lunch | 0
6 | [NAME] | 1/5/2018-1/18/2018 | Regular | 63.13
6 | [NAME] | 1/5/2018-1/18/2018 | Lunch | 10.33
8 | [NAME] | 1/5/2018-1/18/2018 | Regular | 67.67
8 | [NAME] | 1/5/2018-1/18/2018 | Lunch | 0
10 | [NAME] | 1/19/2018-2/1/2018 | Regular | 31.92
10 | [NAME] | 1/19/2018-2/1/2018 | Lunch | 0
16 | [NAME] | 1/19/2018-2/1/2018 | Regular | 62.45
16 | [NAME] | 1/19/2018-2/1/2018 | Lunch | 8.85
20 | Goege Fly | 1/19/2018-2/1/2018 | Regular | 79.32
20 | Goege Fly | 1/19/2018-2/1/2018 | Lunch | 0
21 | [NAME] | 1/19/2018-2/1/2018 | Regular | 7.57
21 | [NAME] | 1/19/2018-2/1/2018 | Lunch | 0
6 | [NAME] | 1/19/2018-2/1/2018 | Regular | 75.18
6 | [NAME] | 1/19/2018-2/1/2018 | Lunch | 8.68
8 | [NAME] | 1/19/2018-2/1/2018 | Regular | 76.48
8 | [NAME] | 1/19/2018-2/1/2018 | Lunch | 0
Spreadsheet: 697078d1601153269-compare-lists-on-two-tables-compare_lists
Sheet: Contracts_Awarded_Dec_2019

Contracts Awarded from 1 July 2018 to 31 December 2019
Contract Number | Contract Value (Excl. GST) | File Number
[PHONE].0840 | 135033476.24 | SF2018/206586
[PHONE].2059 | 13616035.68 | SF2018/236714
[PHONE].1417 | 20682727.91 | SF2018/255880
[PHONE].0319 | 100038443.71 | SF2018/255915
[PHONE].1661 | 33435161.4 | SF2018/261232
[PHONE].0373 | 6725897.09 | SF2018/296979
[PHONE].0549 | 166662103.88 | SF2018/302865
[PHONE].0138 | 71119459.6 | SF2018/306170
[PHONE].0837 | 123734243.12 | SF2018/318834
[PHONE].0242 | 100491735.8 | SF2018/324331
[PHONE].1222 | 6065945.88 | SF2018/325525
[PHONE].0766 | 8780255 | SF2018/329603
[PHONE].1304 | 9035599.2 | SF2018/356379
[PHONE].1405 | 24560930.55 | SF2018/364708
[PHONE].1419 | 9671154.96 | SF2018/364394
[PHONE].1365 | 9754720.23 | SF2018/366885
[PHONE].1113 | 5535183.54 | SF2018/366902
[PHONE].1616 | 7234461.22 | SF2018/370953
[PHONE].0527 | 34915192.36 | SF2018/373919
[PHONE].2159 | 107846593.95 | SF2019/033005
[PHONE].1322 | 8945550.83 | SF2019/045689
[PHONE].0923 |  | SF2019/140201
[PHONE].1371 | 2870493.18 | SF2019/147317
[PHONE].1187 | 10297412.12 | SF2019/178884
[PHONE].0815 | 5947137.85 | SF2019/187541
[PHONE].1444 | 12117831.5 | SF2019/202606
Spreadsheet: 12fec4dd-e919-4f80-913c-54598e071180
Sheet: DZ

Table | Algeria |  | North Africa
 | Grain | Root | Commercial | Food aid |  | Aggregate
Year | production | production | imports | receipts |  | availability
 |  | (grain equiv.) | (grains) | (grain equiv.) |  | of all food
 |  |  | ---1,000 tons ---
2002 | 1953.125 | 336.8266931865655 | 8590.17729 | 63.12998200000001 |  | 12379.20549603581
 | 4266.166 | 476.0897060406738 | 6930.911197 | 10.312287 |  | 12757.28933991963
 | 4033.028 | 480.174627024205 | 7013.854933 | 52.516175 |  | 13020.7033764931
 | 3527.634 | 546.3448429434465 | 8273.391921 | 41.64860700000001 |  | 13090.74659332309
 | 4017.945 | 551.439227446568 | 7414.583738 | 25.955153 |  | 13444.86298761442
 | 3589.87 | 380.5806390235289 | 7337.582726 | 28.575485 |  | 13868.23528142268
 | 1974.7 | 551.1795457938669 | 8843.644993 | 37.951178 |  | 14107.00495665254
 | 5252.7 | 669.2316372693604 | 7529.590904 | 24.043022 |  | 14355.66603329329
2010(e) | 4486.7 | 529.7271781013817 | 7848.908481626443 | 30.189895 |  | 14723.20499445723
Projections |  |  |  | Food gaps*
 |  |  |  | NG | DG
2011 | 3822.454069169861 | 540.3009154437354 | 7513.557404955558 | 0 | 0 | 13684.53234083685
 | 4357.242578666455 | 595.0190229596053 | 8143.608697373676 | 0 | 0 | 15153.96581729884
 | 4879.280938688914 | 652.8748498465699 | 8601.434206759692 | 0 | 0 | 16371.36532847385
Source: Economic Research Service, using data from FAOSTAT (grain and root and tuber production and imports), and the World Food Program (food aid).
*NR stands for nutritional requirements and describes the amount of grain equivalent needed to support nutritional standards on
a national average level. DG stands for distributional gap and it describes that amount of grain equivalent needed to allow each
income quintile to reach the nutrional requirement.
Spreadsheet: 80429d1280642396-formula-or-macro-needed-to-calculate-tat-and-aht-after
Sheet: mis

sno | name | [NAME] | recddatetime | ordertype | tat | aht
1 | sairaj | 1221 | 31/07/2010 10:30 | wlr | 1.1 | 0.15
2 | sairaj | 1222 | 31/07/2010 10:40 | wlr | 1.2 | 0.55
3 | sairaj | 1223 | 31/07/2010 10:45 | wlr | 1.3 | 0.56
4 | sairaj | 1224 | 31/07/2010 10:50 | wlr1 | 1.4 | 0.58
5 | sairaj | 1225 | 31/07/2010 10:55 | wlr1 | 1.5 | 1.15
6 | sairaj | 1226 | 31/07/2010 11:00 | wlr1 | 1.6 | 1.2
7 | sairaj | 1227 |  | wlr1 | 0.5 | 1.3
8 | sairaj | 1228 |  | wlr1 | 0.6 | 1.4
9 | sairaj | 1229 |  | wlr1 | 0.7 | 1.5
10 | sairaj | 1330 |  | wlr1 | 0.8 | 1.6
Spreadsheet: 97056d1296248064-how-to-exclude-2-choices-from-being-subtracted-copy-of-adding-depending-on-cells
Sheet: Past due loans

 | Name | Account Number | DPD | Amt. | [NAME]? | Cost Center Name |  |  |  |  |  |  |  |  | YES
 | [NAME] | 12345 | 18 | 9867.97 | YES | [NAME] |  |  |  |  |  |  |  |  | NO
 | [NAME] | 67890 | 29 | 890 | YES | Harlingen |  |  |  |  |  |  |  |  | MAYBE
 | [NAME] | 56789 | 64 | 765.09 | MAYBE | [NAME]
 | [NAME] | 21354 | 8 | 45675 | YES | [NAME]
 | [NAME] | 57985 | 5 | 478546.12 | NO | Edinburg South
 | [NAME] | 24895 | 24 | 98.21 | YES | Edinburg
 | [NAME] | 58963 | 12 | 5001.02 | MAYBE | Mission Main
 | [NAME] | 54897 | 48 | 9954.2 | YES | [NAME] Main
 | [NAME] | 57007 | 18 | 2018.02 | NO | McAllen South
 |  | Amount that will hit |  | 486330.2500000001
 |  |  |  |  |  |  |  |  |  | [NAME] | Harlingen | Edinburg | Mission
 |  |  |  |  |  |  |  |  | Amount that will hit for city | 19822.17 | 890 | 45773.21 | 0
Spreadsheet: 600286d1543589756-select-a-number-of-a-certain-type-from-one-of-4-cells-book1
Sheet: Sheet1

G/L Account No. | G/L Account - Name | Posting Date | Document No. | Amount | Businesstype Code | Contracts Code | Supply/market Code | Entry No. | Enquiry ID | External Document No. | Sales Invoice Header - External Document No. | Purch. Cr. [NAME] Enquiry No. | Purch. Inv. [NAME]. | [NAME].[NAME] Document No. | Customers Code | Vendors Code | Sales Invoice Header - Sell-to Customer Name | [NAME].[NAME]-to Customer Name | Purch. Inv. [NAME] Name | Purch. Cr. [NAME] Name
50100 | Sales | 2018-10-01 00:00:00 | Inv 1 | -31153.18 | TRADING | 0 | XYZ | 2227937 |  | RB-754781 | 10345619 |  |  |  |  |  | AN Other
Spreadsheet: andy_zipper__154__ICE - Mar28 Power & Gas VOL
Sheet: Enron Activity - Dynegy Direct

DYNEGY DIRECT
Transactions and Notional Volume
By Enron Entity, Commodity, and [NAME]
Note: Total Activity for Dynegy Direct is not available, therefore Enron's percentage can not be calculated
Enron North America - Dynegy Direct |  |  |  |  | Enron Power Marketing - Dynegy Direct |  |  |  |  | Enron Global Liquids - Dynegy Direct
 |  | Data |  |  |  |  | Data |  |  |  |  | Data
Major Commodity | Enron Trader | Transactions | Notional Volume |  | Major Commodity | Enron Trader | Transactions | Notional Volume |  | Major Commodity | Enron Trader | Transactions | Notional Volume
Coal | [NAME] | 1 | 460 |  | Power | [NAME] | 1 | 24000 |  | Natural Gas Liquids | Wade Hicks | 1 | 25000
 | [NAME] | 3 | 1380 |  |  | [NAME] | 1 | 800 |  | Natural Gas Liquids Total |  | 1 | 25000
Coal Total |  | 4 | 1840 |  | Power Total |  | 2 | 24800 |  | Grand Total |  | 1 | 25000
US Natural Gas | [NAME] | 3 | 25000 |  | Grand Total |  | 2 | 24800
 | [NAME] | 2 | 10000
 | [NAME] | 2 | 10000
 | Patrice Mims-Thurston | 1 | 10000
 | [NAME] | 1 | 5000
US Natural Gas Total |  | 9 | 60000
Grand Total |  | 13 | 61840
Spreadsheet: 115568d1311141885-summing-numbers-test
Sheet: Jan

 |  |  | TREASURER'S REPORT
 |  |  | January 2011
 |  |  | CHECKING ACCOUNT
BALANCE ON HAND |  |  |  |  |  | 0
Date |  | Name | Purpose | Method of payment | Amount | receipt? | Category
2011-07-03 00:00:00 |  | Income | Collection | Cash | 22 | no | Money Collected
2011-07-03 00:00:00 |  | Expense | nosh | cash | -16 | Yes | Refreshments |  | TOTALS by Categories for January:
2011-07-03 00:00:00 |  | Expense | Books | Cashq | -63 | No | Books |  | Books |  |  | Money Collected
2011-07-03 00:00:00 |  | Income | Loan | Check | 125 | Yes | Loans |  | -63 |  |  | 65
2011-07-10 00:00:00 |  | Income | Collection | Cash | 31 | No | Money Collected |  | Refreshments |  |  | Copies
2011-07-10 00:00:00 |  | Expense | To Buy coines for meeting | Cash | -22 | Yes | [NAME] |  | -30 |  |  | -6
2011-07-10 00:00:00 |  | Expense | Paper for copies | Cash | -6 | Yes | copies |  | Coines |  |  | [NAME]
2011-07-10 00:00:00 |  | Expense | Paper Plates | Cash | -4 | Yes | Supplies |  | -22 |  |  | 0
2011-07-10 00:00:00 |  | Expense | payback loan | Cash | -20 | No | loans |  | Loans |  |  | Supplies
2011-07-17 00:00:00 |  | Income | Money Collected | Cash | 12 | no | Money Collected |  | 105 |  |  | -4
2011-07-17 00:00:00 |  | Expense | refreshments | Cash | -14 | No | Refreshments
2011-07-24 00:00:00 |  | Expense | [NAME] for the room | Cash | -9 | Yes | [NAME]
 |  |  |  |  |  |  |  |  | Total
 |  | TOTAL EXPENSES | -154
 |  | TOTAL INCOME | 190
Spreadsheet: 4bfd0b23-0c25-453e-aed2-6c5d580e3315
Sheet: Sheet1

VICE-PRESIDENT OF THE UNITED STATES | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Libertarian Presidential Primary
1996-02-20 00:00:00
Summary By
Counties | Browne | [NAME] | Keyes | Schiff
Belknap | 0 | 4 | 0 | 1
Carroll | 2 | 1 | 0 | 2
Cheshire | 0 | 3 | 0 | 8
Coos | 0 | 0 | 0 | 0
[NAME] | 2 | 2 | 0 | 4
Hillsborough | 8 | 5 | 6 | 3
Merrimack | 4 | 4 | 1 | 2
Rockingham | 5 | 4 | 7 | 8
[NAME] | 4 | 2 | 1 | 6
[NAME] | 0 | 0 | 1 | 4
Totals | 25 | 25 | 16 | 38
There were no libertarian candidates for Vice President. The above table shows
the candidates who received write-in votes for Vice President in alphabetical order.
The following candidates received 11 or fewer write-in votes: Alexander-2. Buchanan-11. Bush-1. Clinton-1. Dole-3.
Forbes-7. Gramm-1. Kemp-2. Luce-9. Lugar-1. [NAME]. Nader-4. Powell-11. Taylor-1.
Spreadsheet: 1c0b1762-c300-4da9-869e-76b6e7e7789e
Sheet: Sheet1

Unnamed: 0 | State of New Hampshire - General Election | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | State Representative - SULLIVAN County
District No. 1 (2) | Ward, r | Walker, r | [NAME], d | Lefebvre, d |  | [NAME]
Cornish | 387 | 369 | 513 | 506
Grantham | 738 | 677 | 1065 | 1005
Plainfield | 429 | 401 | 831 | 817 |  | 1
Springfield | 324 | 333 | 310 | 297
TOTALS | 1878 | 1780 | 2719 | 2625
District No. 2 (1) | Bowers, r | Gottling, d | [NAME]
Croydon | 205 | 205
Sunapee | 798 | 1138 | 3
TOTALS | 1003 | 1343
District No. 3 (1) | Picano, r | O'Hearne, d | [NAME]
Claremont Ward 1 | 586 | 920 | 5
District No. 4 (1) | Lovett, r | [NAME], d | [NAME], i | [NAME]
Claremont Ward 2 | 862 | 1138 |  | 3
District No. 5 (1) | Madigan, i&r | Gagnon, d | [NAME], ind | [NAME]
Claremont Ward 3 | 573 | 975 | 122 | 1
District No. 6 (2) | Rollins, r | Rodeschin, r | Irwin, d | Franklin, d | [NAME]
Newport | 1571 | 1076 | 1254 | 783
Unity | 345 | 309 | 298 | 280
TOTALS | 1916 | 1385 | 1552 | 1063
District No. 7 (1) | Grenier, r | [NAME], d | [NAME]
Acworth | 241 | 273
Goshen | 238 | 147 | 3
Langdon | 164 | 186
Lempster | 371 | 181 | 1
Washington | 356 | 193
TOTALS | 1370 | 980
District No. 8 (1) | Laware, r | Sweeney, d | [NAME]
Charlestown | 924 | 1183 | 1
District No. 9 (1)FL | Howard, r | Tanner, d | [NAME]
Cornish | 398 | 560
Croydon | 249 | 162 | 1
Grantham | 738 | 1088
Newport | 1301 | 1244 | 1
Plainfield | 456 | 867
Springfield | 343 | 359
Sunapee | 951 | 896 | 4
Unity | 323 | 349
TOTALS | 4759 | 5525
District No. 10 (1)FL | LaCasse, Sr., r | Cloutier, d | [NAME]
Claremont Ward 1 | 606 | 925 | 5
Claremont Ward 2 | 817 | 1168 | 4
Claremont Ward 3 | 721 | 972 | 1
TOTALS | 2144 | 3065
District No. 11 (1)FL | Smith, r | Recount | Boland, d | Recount
Acworth | 228 | 228 | 277 | 280
Charlestown | 1010 | 1009 | 1059 | 1060
Goshen | 230 | 230 | 151 | 151
Langdon | 175 | 176 | 177 | 177
Lempster | 288 | 289 | 231 | 231
Washington | 271 | 271 | 285 | 283
TOTALS | 2202 | 2203 | 2180 | 2182
Spreadsheet: 108b44d9-e0df-42e3-820c-48167d679004
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | TGA4532-SM evaluation board BOM
Ref Des | Value | Description | Manufacturer | Part Number
C1, C2, [NAME], C4 | 100 pF | [NAME], 0402, 50V, 5%, NPO | various
C5, C6, C7 | 1 uF | [NAME], 0603, 50V, 5%, COG | various
R1 | 15 Ohms | [NAME], 0402, 1/16W, 5%, SMD | various
Spreadsheet: 52951d1252854749-formula-for-add-numbers-in-cell-arshabi-game
Sheet: Sheet1

Very intelligent game
 |  |  |  |  |  |  | 0 | This row includes the "space"
 |  |  |  |  |  | a | 1
word |  |  | total Numbers |  |  | b | 2
hand |  |  |  |  |  | c | 3
cat |  |  |  |  |  | d | 4
animal |  |  |  |  |  | e | 5
lizard |  |  |  |  |  | f | 6
parrot |  |  |  |  |  | g | 7
nose |  |  |  |  |  | h | 8
kneecap |  |  |  |  |  | j | 9
brain |  |  |  |  |  | i | 10
 |  |  |  |  |  | k | 11
 |  |  |  |  |  | l | 12
 |  |  |  |  |  | m | 13
dog pound |  |  |  | example of |  | n | 14
 |  |  |  | multi word |  | o | 15
 |  |  |  |  |  | p | 16
 |  |  |  |  |  | q | 17
 |  |  |  |  |  | r | 18
 |  |  |  |  |  | s | 19
 |  |  |  |  |  | t | 20
 |  |  |  |  |  | u | 21
 |  |  |  |  |  | v | 22
 |  |  |  |  |  | w | 23
 |  |  |  |  |  | x | 24
 |  |  |  |  |  | y | 25
 |  |  |  |  |  | z | 26
Spreadsheet: 768783d1645118692-keeping-a-formula-constant-after-adding-columns-to-the-right-excel-test-1-
Sheet: Sheet1

Check |  |  | ID | SUM | ID | SUM
 | AAPL | 150 | AAPL | 129.53 | AAPL | 146.32
 | bp | 20 | ABBV | 114.38 | ABBV | 115.5
 | c | 100 | ABUS | 7 | ABUS | 7
 |  |  | ACB | 9.7 | ACB | 10.37
 |  |  | AMZN | 3737.88 | ALEC | 34.83
 |  |  | [NAME] | 10.17 | AMZN | 4016.71
 |  |  | ARE | 184.33 | [NAME] | 10.17
 |  |  | BA | 235.47 | ARE | 184.33
 |  |  | BGS | 30.25 | AVGO | 454.5
 |  |  | BIP | 53.75 | BA | 230.5
 |  |  | BIPC | 76 | BFT | -
 |  |  | BMY | 72.82 | BIP | 54.75
 |  |  | BP | 26 | BMY | 73.09
 |  |  | C | 75.93 | BP | 26.13
 |  |  | CAG | 38 | C | 75.83
 |  |  | CCI | 181.67 | CAG | 38
 |  |  | CDTAF | - | CCI | 180.58
 |  |  | CGC | 23.46 | CDTAF | -
Spreadsheet: 100180d1298593551-conditional-formatting-test_data-owner-ha2
Sheet: Measures - HA 

Measures for Data Owner - HA
For Year: 2010 |  |  |  | For Year: 2011
 | Measure | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Target | % Var From Target for Jan | Traffic light for Jan | Mitigation for Jan
 | Percentage of projects reporting green status | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 1 | 2
 | All Projects | 0.48 | 0.72 | 0.77 |  |  |  |  |  |  |  |  |  |  |  | 0.8 | -0.03750000000000003 | Y
Spreadsheet: 789284d1659023656-what-should-be-a-text-return-is-coming-up-a-date-pm-status-help-sgtkling
Sheet: UNPIVOTED_MILEAGE

Asset | Attribute | Value
Asset | Attribute | Value
145 | 2021-01-01 00:00:00 | 179694
132 | 2021-01-01 00:00:00 | 195771
133 | 2021-01-01 00:00:00 | 188072
132 | 2021-01-02 00:00:00 | 195771
145 | 2021-01-02 00:00:00 | 179694
133 | 2021-01-02 00:00:00 | 188072
132 | 2021-01-03 00:00:00 | 195771
133 | 2021-01-03 00:00:00 | 188072
145 | 2021-01-03 00:00:00 | 179910
133 | 2021-01-04 00:00:00 | 188303
132 | 2021-01-04 00:00:00 | 195771
145 | 2021-01-04 00:00:00 | 180091
145 | 2021-01-05 00:00:00 | 180091
132 | 2021-01-05 00:00:00 | 195771
133 | 2021-01-05 00:00:00 | 188520
132 | 2021-01-06 00:00:00 | 195771
133 | 2021-01-06 00:00:00 | 188732
145 | 2021-01-06 00:00:00 | 180091
133 | 2021-01-07 00:00:00 | 188969
132 | 2021-01-07 00:00:00 | 195771
145 | 2021-01-07 00:00:00 | 180091
145 | 2021-01-08 00:00:00 | 180091
133 | 2021-01-08 00:00:00 | 189198
132 | 2021-01-08 00:00:00 | 195771
132 | 2021-01-09 00:00:00 | 195771
145 | 2021-01-09 00:00:00 | 180091
Spreadsheet: 654402d1576671001-equation-for-averaging-cells-that-include-signs-new-excel-help
Sheet: Sheet1

Sample ID | Bottle # | ml's Sample Used | Volume of Polyseed Used (mL) | Initial D.O. | Final D.O. | Depletion | Seed Correction Factor | Net Depletion | Result (mg/L)
 | 3 | 200 | 4 | 8 | 7.9 |  | 0.7
 | 4 | 150 | 4 | 7 | 6.5 |  | 0.7
 | 5 | 180 | 4 | 6 | 2 |  | 0.7
 |  |  |  |  | Final D.O. must be >1mg/L | Depletion must be >2mg/L | Average:
Sample ID | Bottle # | ml's Sample Used | Volume of Polyseed Used (mL) | Initial D.O. | Final D.O. | Depletion | Seed Correction Factor | Net Depletion | Result (mg/L)
 | 3 | 200 | 4 | 8 | 7.9 |  | 0.7
 | 4 | 180 | 4 | 8 | 6.5 |  | 0.7
 | 5 | 150 | 4 | 8 | 7 |  | 0.7
 | 6 | 125 | 4 | 8 | 7.5 |  | 0.7
 |  |  |  |  | Final D.O. must be >1mg/L | Depletion must be >2mg/L | Average:
Spreadsheet: 729900d1619434417-rankif-function-which-can-take-formulas-giving-dynamic-ranges-as-arguments-rankif
Sheet: RANKIF

Category | Numbers to be ranked | Last 15 digits from numbers to be ranked | Rank
15022505 | 100000000000421730 |  |  |  |  |  |  | Considerations:
15022505 | 100000000000421731 | 421731 | 2 | 2
15022505 | 100000000000421731 | 421731 | 2 | 2 |  |  |  | 1. A descending "RANKIF" of column B with respect to column A is needed.
15022505 | 100000000000421731 | 421731 | 2 | 2 |  |  |  | 2. Numbers (in text format) to be ranked consists of 18 digits, but Excel only keeps the 15 first digits, while turning the rest into zeroes except when the string is kept as text format.
15022505 | 100000000000421732 | 421732 | 5 | 5 |  |  |  | 3. There is no need for all the digits for the proposed use, so a workaround is to create a column which extracts only the 15 last digits and turns them into numbers.
15022505 | 100000000000421732 | 421732 | 5 | 5 |  |  |  | 4. Functions like COUNTIFS, RANK and SUMPRODUCT cannot take calculation of dynamic ranges as arguments, e.g.: NUMBERVALUE(RIGHT(B2:B33;15))
15022505 | 100000000000421732 | 421732 | 5 | 5 |  |  |  | 5. Therefore, a formula to calculate the rank of these numbers must be entered in yet another separate column.
15022505 | 100000000000421733 | 421733 | 8 | 8
15022505 | 100000000000421733 | 421733 | 8 | 8 |  |  |  | Need:
15022505 | 100000000000421733 | 421733 | 8 | 8
15022505 | 100000000000421734 | 421734 | 11 | 11 |  |  |  | [NAME] to calculate rank directly without helper column and with a dynamic array as output. (The LET function is unfortunately not available in my version of Excel yet).
15022505 | 100000000000421734 | 421734 | 11 | 11
15022505 | 100000000000421734 | 421734 | 11 | 11
15022507 | 100000000000421864 | 421864 | 1 | 1
15022507 | 100000000000421865 | 421865 | 2 | 2
15022507 | 100000000000421865 | 421865 | 2 | 2
15022507 | 100000000000421865 | 421865 | 2 | 2
15022507 | 100000000000421866 | 421866 | 5 | 5
15022507 | 100000000000421866 | 421866 | 5 | 5
15022507 | 100000000000421866 | 421866 | 5 | 5
15022507 | 100000000000421866 | 421866 | 5 | 5
15022507 | 100000000000421867 | 421867 | 9 | 9
15022507 | 100000000000421867 | 421867 | 9 | 9
15022507 | 100000000000421867 | 421867 | 9 | 9
15022507 | 100000000000421867 | 421867 | 9 | 9
15022507 | 100000000000421868 | 421868 | 13 | 13
15022507 | 100000000000421868 | 421868 | 13 | 13
15022507 | 100000000000421868 | 421868 | 13 | 13
15022507 | 100000000000421868 | 421868 | 13 | 13
15022507 | 100000000000421869 | 421869 | 17 | 17
15022507 | 100000000000421869 | 421869 | 17 | 17
15022507 | 100000000000421869 | 421869 | 17 | 17
Spreadsheet: darrell_schoolcraft__7783__imbalsumm0107
Sheet: SoCal

 | 10487 |  | 56697
Day | Measured | Scheduled | Measured | Scheduled
1 | -681864 | -671501 | -49417 | -50000
2 | -793585 | -805600 | -24999 | -25000
3 | -803904 | -807198 | -24995 | -25000
4 | -774286 | -766773 | -25002 | -25000
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
2001-06-30 00:00:00 |  |  |  |  | 123509
2001-07-04 00:00:00
Spreadsheet: 843095d1695053627-use-up-2-balances-dummy-countdown-aligw
Sheet: Sheet1

 |  |  |  |  | 2024 | 2025 | 2026 | 2027
 | Taxable income |  |  | 1.1 | 2.8 | 4.5 | 6.4 | 7.2
 | Balance of IDD |  | 6.8
 | Balance of tax losses |  | 6.1