tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 191542d1352142054-complext-text-manipiulation-a-nesting-problem-book2
Sheet: Sheet1

The lists come in, typically, three forms: starting with the name of the bacteria, or with one of several fixed-text strings preceeding the name of the bacteria.
String | Desired FINAL End result
Suspicion of Listeria monocytogenes in cheese | [NAME] monocytogenes
shigatoxin-producing Escherichia coli in cheese | Escherichia coli
Salmonella typhimurium in cheese | Salmonella typhimurium
I can get the name of the bacterium to the start of the string (using "substitute"), but haven't been able to get a nested equation to cover the three possibilities shown here
String | End result
Suspicion of Listeria monocytogenes in cheese
shigatoxin-producing Escherichia coli in cheese
Salmonella typhimurium in cheese
If I have the name of the bug (always two words) at the start of a string, I can extract both words in a cumbersome way.
 | Firstly, I can extract the first word: | And I can extract the rest of the string | I can extract the NEW first word again | and then join 'em…
String | End result | End result | End result | End result
[NAME] monocytogenes in cheese
Escherichia coli in cheese
Salmonella typhimurium in cheese
I can even do that bit in a single equation
String | End result
[NAME] monocytogenes in cheese
Escherichia coli in cheese
Salmonella typhimurium in cheese
What I really, really want to do is have a single equation (I know stuff-all about VBA) that can delete the leading text string (of which there are only a few variants) and deliver me the name of the bacterium, as shown at the top & as repeated here:                                    I am nearly there... but not quite
String | End result
Suspicion of Listeria monocytogenes in cheese | [NAME] monocytogenes
shigatoxin-producing Escherichia coli in cheese | Escherichia coli
[NAME] monocytogenes in cheese | [NAME] monocytogenes
Spreadsheet: 599353d1542984576-distribute-values-between-two-different-dates-copy-of-loan-calculation-work-sheet-version01-
Sheet: Daily Coll.Branch.Wise Sum.

Collection Updates (Branch Wise) |  |  |  |  |  | Branch Name | Kundasale
 | Branch Information -► |  |  |  |  | Customer Information -► |  |  |  |  | Loan Information -►
Date | Loan Code | Branch Name | Branch Code | Officer Name | Officer Code | Customer Name | NIC Number | Nearest Town | Contact No | Distance to Center(Km) | Date of Loan | Loan Amount (Rs.) | Payment Method | Period (Days) | Effective Interest Rate | Total Interest | Total with Interest | Number of Installments | Loan Instalment | Paid Today
Spreadsheet: 880962d1728848772-formula-from-sheet1-to-sheet-2-if
Sheet: Sheet1

 | Table
 | Item No. | Item  Description | Qty Items/ per/Case | Value/ per/Item | Value/ Case | Weight/ Per/Item Kg | Weight/ Per/Case Kg
 | 1 | Widget A | 3 | 12 |  | 2
 | 2 | Widget B | 5 | 8 |  | 0.4
 | 3 | Widget C | 10 | 13 |  | 0.65
 | 4 | Widget D | 8 | 7 |  | 0.78
 | 5 | Widget E | 41 | 81 |  | 20.4
 | 6 | Widget F | 66 | 52 |  | 12
 | 7 | Widget G | 21 | 8 |  | 8.6
 | 8 | Widget H | 9 | 45 |  | 91.56
 | 9 | Widget I | 3 | 32 |  | 56
 | 10 | Widget J | 4 | 22 |  | 2.8
 | Summary
 | Item No. | Qty of Cases | Item Description | Value/ Sub | Weight/Sub
 | 4 | 24
 | 9 | 15
 |  | I want the formulas in B15:F18 moved to sheet 2 I only want rows 1:13 to remain on sheet 1
Spreadsheet: 742312d1627656532-index-match-only-returning-first-found-from-list-testwb
Sheet: Sheet1

 | Data 1 | Data 2
 |  | Data 4
 | Data 5 | Data 6 |  |  |  |  | <-- E & F should be Data 5 & Data 6 (from cells B5 & C6)
 |  | Data 8
 | Data 9 | Data 10 |  |  |  |  | <-- E & F should be Data 9 & Data 10 (from cells B7 & C7)
 | Data 10 | Data 11 |  |  |  |  | <-- E & F should be Data 10 & Data 11 (from cells B8 & C8)
 | Data 11 | Data 12 |  |  |  |  | <-- E & F should be Data 11 & Data 12 (from cells B9 & C9)
 |  | Data 13
 | Data 13 | Data 14 |  |  |  |  | <-- E & F should be Data 13 & Data 14
 | Data 14 | Data 15 |  |  |  |  | <-- E & F should be Data 14 & Data 15
 |  | Data 16
 | Data 16 | Data 17 |  |  |  |  | …Etc, on all matches to word "Yes" in column D
 | Data 17 | Data 18
 |  | Data 19
 | Data 19 | Data 20
 | Data 20 | Data 21
 |  | Data 22
 | Data 22 | Data 23
 | Data 23 | Data 24
Spreadsheet: 64804d1265642599-amend-crosstab-display-storecodes
Sheet: Sheet1

Code | Store1 | [NAME] | Store3
a | 2.3 | 2.5 | 2.6
b | 2.2 | 2.5 | 2.9
c | 1.8 | 2.4 | 3.1
d | 2 | 2.2 | 2.1
e | 2.1 | 2.3 | 2.7
Store1 | a | 2.3
Store1 | b | 2.2
Store1 | c | 1.8
Store1 | d | 2
Store1 | e | 2.1
[NAME] | a | 2.5
[NAME] | b | 2.5
[NAME] | c | 2.4
[NAME] | d | 2.2
[NAME] | e | 2.3
Store3 | a | 2.6
Store3 | b | 2.9
Store3 | c | 3.1
Store3 | d | 2.1
Store3 | e | 2.7
Spreadsheet: 201584d1356031368-finding-strings-in-vlookup-value-embedded-in-larger-strings-within-the-table-array-vlookups-find-text-from-value-within-cell
Sheet: Sheet1

 | Faces | MB |  |  | Face Filenames | MB | Date
 | Happy Face |  |  |  | C://Local_Folder/Zak/Happy Face | 10 | 2012-01-01 00:00:00
 | Sad Face |  |  |  | C://Local_Folder/James/Sad Face | 13 | 2012-03-01 00:00:00
 | Silly Face |  |  |  | C://MyDocuments/Zak/Silly Face | 14 | 2012-05-01 00:00:00
 | Angry Face |  |  |  | C://Local_Folder/Zak/Angry Face | 5 | 2012-07-01 00:00:00
 | Stupid Face |  |  |  | C://Local_Folder/Ian/Stupid Face | 5 | 2012-09-01 00:00:00
 | Hungry Face |  |  |  | C://Local_Folder/Zak/Hungry Face | 1 | 2012-11-01 00:00:00
 | [NAME] |  |  |  | C://Downloads/Zak/Bald Head | 4 | 2013-01-01 00:00:00
 | Bed Dread |  |  |  | C://Local_Folder/Ian/Bed Dread | 56 | 2013-03-01 00:00:00
 | I need the vlookups in C3:C10 to find the values from B3:B10, within the values from F3:F10
Spreadsheet: 681429d1591565878-count-unique-values-for-a-specific-date-example-data-keebellah-
Sheet: Sheet1

Date | Invoice | Count p/Date |  |  | Date | Unique Orders |  | Problem Formula |  | Invoice
2020-02-21 00:00:00 | 15567 |  |  |  | 2020-02-21 00:00:00 | 4 |  |  |  | 15567
2020-02-21 00:00:00 | 15567 |  |  |  | 2020-02-22 00:00:00 | 1 |  |  |  | 55978
2020-02-21 00:00:00 | 15567 |  |  |  | 2020-02-23 00:00:00 | 2 |  |  |  | 35013
2020-02-21 00:00:00 | 55978 |  |  |  | 2020-02-24 00:00:00 | 3 |  |  |  | 67922
2020-02-21 00:00:00 | 35013 |  |  |  | 2020-02-25 00:00:00 | 5 |  |  |  | 15620
2020-02-21 00:00:00 | 67922 |  |  |  |  |  |  |  |  | 73486
2020-02-22 00:00:00 | 15620 |  |  |  |  |  |  |  |  | 17106
2020-02-23 00:00:00 | 73486 |  |  |  |  |  |  |  |  | 97625
2020-02-23 00:00:00 | 17106 |  |  |  |  |  |  |  |  | 8452
2020-02-24 00:00:00 | 97625 |  |  |  |  |  |  |  |  | 15747
2020-02-24 00:00:00 | 97625 |  |  |  |  |  |  |  |  | 15808
2020-02-24 00:00:00 | 8452 |  |  |  |  |  |  |  |  | 15767
2020-02-24 00:00:00 | 15747 |  |  |  |  |  |  |  |  | 68733
2020-02-24 00:00:00 | 15747 |  |  |  |  |  |  |  |  | 15801
2020-02-24 00:00:00 | 15747 |  |  |  |  |  |  |  |  | 15813
2020-02-25 00:00:00 | 15808
2020-02-25 00:00:00 | 15767
2020-02-25 00:00:00 | 68733
2020-02-25 00:00:00 | 68733
2020-02-25 00:00:00 | 68733
2020-02-25 00:00:00 | 15801
2020-02-25 00:00:00 | 15801
2020-02-25 00:00:00 | 15801
2020-02-25 00:00:00 | 15813
Spreadsheet: 119667d1314645049-excel-2007-using-an-if-and-to-drive-vlookup-upload
Sheet: Data

 | Make | Model | Serial Nbr | Hrs per Day | Annualized |  | Serial Nbr | Total Sales Through Service | Service Sales Minus Usage | External | ALL | Standard | OT | Usage | Profit % | COGS $
 | RAYM | EZ-DR30TT | EZ-A-02-25900 | 14.3504273504274 | 5237.90598290598 |  | 830-09-69939 | 2100 | 2100 |  | 2100 | 2100 |  |  | 0.844471428571429 | 326.61
 | HYST | N30XMDR2 | F138N01550V | 14.2923076923077 | 5216.69230769231 |  | EZ-A-94-01302 | 6966.54 | 6966.54 | 1076.4 | 5890.14 | 5890.14 |  |  | 0.527885585062494 | 2780.82
 | RAYM | 840-FRE60L-96 | 840-08-78316 | 14.0427631578947 | 5125.60855263158 |  | 112-02-44745 | 256.91 | 256.91 | 41.75 | 215.16 | 215.16 |  |  | -3.77514407882506 | 1027.42
 | RAYM | EZ-R40TT | EZ-A-94-02279 | 13.9598540145985 | 5095.34671532847 |  | C114V07122R | 3918 | 3918 |  | 3918 | 3918 |  |  | 0.426778968861664 | 2245.88
 | TOYO | 8FGU25 | 19305 | 13.672131147541 | 4990.32786885246 |  | ET-F-09-16636 | 3840 | 3840 |  | 3840 | 3840 |  |  | 0.111924479166667 | 3410.21
 | RAYM | 112TM-FRE60L | 112-12820 | 12.7652173913043 | 4659.30434782609 |  | 112-92-10441 | 1481.64 | 1481.64 |  | 1481.64 | 1481.64 |  |  | 0.586444750411706 | 612.74
 | RAYM | 830-F60L | 830-09-69939 | 0.501831501831502 | 183.168498168498 |  | 112-12820 | 1954 | 1954 | 94 | 1860 | 1860 |  |  | -0.0111989247311829 | 1880.83
 | RAYM | 112TM-FRE60L | 112-92-10441 | 0.494736842105263 | 180.578947368421 |  | 19305 | 9994.17 | 9994.17 | 2590.17 | 7404 | 7404 |  |  | 0.0855983252296057 | 6770.23
 | RAYM | 112TM-FRE60L | 112-02-44745 | 0.483333333333333 | 176.416666666667 |  | EZ-A-94-02252 | 190.1 | 190.1 | 190.1
 | HYST | E30XL | C114V07122R | 0.46875 | 171.09375 |  | EZ-A-94-02279 | 4582.5 | 4582.5 | 182.5 | 4400 | 4400 |  |  | 0.359327272727273 | 2818.96
 |  |  |  |  |  |  | 840-08-78316 | 3597.31 | 3597.31 | 1905.31 | 1692 | 1692 |  |  | -0.506513002364066 | 2549.02
 |  |  |  |  |  |  | F138N01550V | 4190 | 4190 | 230 | 3960 | 3960 |  |  | 0.345217171717172 | 2592.94
 |  |  |  |  |  |  | EZ-A-02-25900 | 4532.77 | 4532.77 | 1472.77 | 3060 | 3060 |  |  | -0.0891633986928104 | 3332.84
 |  |  |  |  |  |  | EZ-A-94-01303 | 8468.05 | 8468.05 | 2577.91 | 5890.14 | 5890.14 |  |  | 0.249218184966741 | 4422.21
Spreadsheet: 712968d1610500335-rotating-column-based-on-date-not-even-sure-what-to-call-it-example-3
Sheet: Sheet1

NAME | Monday | Tuesday | Wednesd. | Thursday | Friday | Saturday | Sunday
Jan 25 2021
Employee 9 | Data | Data | Data | Data | Data | Data | Data
Employee 10 | Data | Data | Data | Data | Data | Data | Data
Employee 1 | Data | Data | Data | Data | Data | Data | Data
Employee 3 | Data | Data | Data | Data | Data | Data | Data
Employee 4 | Data | Data | Data | Data | Data | Data | Data
Employee 5 | Data | Data | Data | Data | Data | Data | Data
Employee 6 | Data | Data | Data | Data | Data | Data | Data
Employee 7 | Data | Data | Data | Data | Data | Data | Data
Employee 8 | Data | Data | Data | Data | Data | Data | Data
Employee 9 | Data | Data | Data | Data | Data | Data | Data
Spreadsheet: 197372d1354310742-if-a-cell-equals-x-then-format-that-many-cells-for-input-bracket-help
Sheet: Sweet 16

 | Total Points
SOUTH | PPG this RD
WEST
EAST
MIDWEST
Spreadsheet: 801009d1666026114-getting-cell-values-based-on-an-different-cells-dont-know-what-formula-to-use-northot-v2-2-
Sheet: Calendar

 |  | FEBRUARY |  | SUNDAY
 | CALENDAR YEAR | CALENDAR MONTH |  | FIRST DAY OF WEEK
Spreadsheet: 1d77cbe9-50e5-4b35-bf43-10dcf5b42f39
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Who is doing What, When and Where (4W) | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Monsoon 2011 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31
1 Row = 1 Cluster + 1 Org + 1 District + 1 Teshil + 1 UC+ 1 Activity Please enter 1 row per activity per UC. If you work in multiple clusters and/or multiple locations, use different rows to enter the information. Please send updates to [EMAIL]
 |  |  |  |  |  |  |  |  |  |  |  | Geographical Location |  |  |  |  | Activity |  |  | Beneficiaries Target |  |  | Beneficiaries UNIT | Beneficiaries Reached |  |  | Contact Details
Donor / Funding Organization | Project Code | Project Title | Project Owner | Project Owner Org. Type | [NAME] (IP) | IP Org. Type | Cluster/ Sub-Cluster | Activity Type | Activity Description | Activity Start Date | Activity End Date | Province | District | [NAME] | Union Council | Camp/Village Name | Target | Unit (Shelter, Tents etc.) | Achieved | Total Target | Female | Children |  | Total Reached | Female | Children | Contact Person Name | Contact Number | E-mail | Comments, if any | Date Data updated as of
DFID | PAK-FL-11/S-NF/43124 | Provision of NFI/ emergency shelter to flood affected families in Sindh, Pakistan | International Organization for Migration | International Organization | Nishat Welfare Organization | NGO | Emergency Shelter and NFIs | Emergency shelter | To provide emergency shelters to 38,500 flood affected families | 2011-09-18 00:00:00 | 2011-12-18 00:00:00 | Sindh | [NAME] | [NAME] | Lowari Sharif |  | 38500 | Tents | 10000 | 269500 |  |  | Households | 10000 | 5000 | 3500 | Mr. [NAME] | [PHONE] | [EMAIL] | Sample Record | 2011-09-27 00:00:00
Spreadsheet: 726990d1617639304-data-entered-a-sheet-need-to-appear-automatically-on-another-sheet-as-per-headings-etc-accounting-module-caracalla-sol-01-
Sheet: Bank Balance

Particulars |  | Money In |  |  |  |  |  |  | Money Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Balance
Date | Ref/Invoice/Cheque No. | Document Charges | Loan Capital Recovery | Loan Interest Recovery | Donations | Other Incomes | Owners Capital | Third Party Loans | Building Rent | Electricity | Fuel | Internet Charges | Mobile Charges | Statationery | Computers | Furniture | Travelling Costs | Marketing/Advertising | Charitables | Sponsorships | Entertainment | Insurance | Water Bill | Car | Motor Bike | Owners Withdrawals | Salaries | Loans Disburesed | Interest Paid | Petty Cash | EPF | ETF | Bonus | Debit | Credit
2021-03-21 00:00:00 | 456798 |  |  |  |  |  |  |  | 35000
2021-04-05 00:00:00 | BA2735 |  | 80000
2021-04-06 00:00:00 | T2345 |  |  | 15000
Spreadsheet: f2f9d024-947f-4620-b6bb-4515f379785d
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40223283 | 2014-02-24 22:47:06 | ALLIES | 1 | 4 | 1 | 1400836 | lycan A-t | 6158 | western | 1944-06-06 | 1944-06-06 | Pegasus Bridge | Pegasus Bridge
40295146 | 2014-03-01 10:44:23 | ALLIES | 1 | 6 | 4 | 1483447 | alexdone | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
40295335 | 2014-03-01 11:05:19 | ALLIES | 0 | 6 | 7 | 1483447 | alexdone | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40295568 | 2014-03-01 11:18:55 | AXIS | 1 | 5 | 2 | 614184 | Commando [NAME] | 7334 | mediterranean | 1941-11-22 | 1941-11-22 | [NAME] | [NAME]
40296224 | 2014-03-01 12:39:40 | AXIS | 1 | 6 | 2 | 1529783 | MSKX | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
40296442 | 2014-03-01 13:05:43 | ALLIES | 1 | 6 | 2 | 1529783 | MSKX | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
40298266 | 2014-03-01 15:36:10 | AXIS | 0 | 2 | 5 | 676026 | JJ HOOVER | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
40298480 | 2014-03-01 15:55:45 | ALLIES | 0 | 4 | 5 | 676026 | JJ HOOVER | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
Spreadsheet: 868482d1715200629-subtract-x-amount-from-top-left-and-bottom-right-sides-of-array-subtract-left-right-side-array
Sheet: Sheet1

 | Original |  |  | 100 | 100 | 0 | 20 | 50 | 0 | 40 | 0
 |  |  |  | -100 | -50 |  |  | -35 |  | -40 | 0
 | Desired Dynamic Array |  |  | 0 | 50 | 0 | 20 | 15 | 0 | 0 | 0
 |  |  |  | Subtract 150 going right till zero |  |  |  |  |  | Subtract 75 going left till zero
Spreadsheet: 123198d1317397969-values-upto-a-specified-date-example
Sheet: Sheet1

 | Shop | 2010-03-07 00:00:00 | 2010-03-14 00:00:00 | 2010-03-21 00:00:00 | 2010-03-28 00:00:00 | 2010-04-04 00:00:00 | 2010-04-11 00:00:00 | 2010-04-18 00:00:00 | 2010-04-25 00:00:00 | 2010-05-02 00:00:00 | 2010-05-09 00:00:00 | 2010-05-16 00:00:00 | 2010-05-23 00:00:00 | 2010-05-30 00:00:00 | 2010-06-06 00:00:00 | 2010-06-13 00:00:00 | 2010-06-20 00:00:00 | 2010-06-27 00:00:00 | 2010-07-04 00:00:00 | 2010-07-11 00:00:00 | 2010-07-18 00:00:00 | 2010-07-25 00:00:00 | 2010-08-01 00:00:00 | 2010-08-08 00:00:00 | 2010-08-15 00:00:00
 | A | 30 | 30 | 30 | 18 | 12 | 2.58 | 5.17 | 5.17 | 7.75 | 17.9 | 16.23 | 13.3 | 13.3 | 10.7 | 12.7 | 2 |  |  |  | 10 | 10 | 14 | 8 | 20
 | B | 30 | 30 | 30 | 30 | 24 | 2.58 | 5.17 | 7.75 | 7.75 | 11.2 | 11.2 | 28 | 37.3 | 16 | 11
 | C |  |  |  |  |  |  |  |  |  |  | 13.87 |  | 9 | 12.5 | 19 | 18 | 40 |  | 10 |  | 19 | 11 | 19 | 30
 | D | 30 | 30 |  | 30 | 24 | 0 | 0 | 0 | 0 | 0 | 16 |  | 40 |  | 4.8 |  |  |  |  |  | 11 |  | 19.5
 | E |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | 22.5 | 22.5 | 15 | 22.5 | 22.5 | 18
 | F |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  | 11 | 8 | 8 | 4
 | G | 3 | 8.25 |  | 4.5 | 9 | 0.65 | 0 | 1.62 | 0 | 13 | 22 | 17.3 | 33.7 | 16 | 9.3 |  | 12 | 21 | 24.67 | 22.5 | 18.67 |  | 20 | 22
 | How many have been sold upto
 | 2010-06-13 00:00:00
Spreadsheet: 23ef793f-84d3-4481-b085-86662f25116d
Sheet: Budget Summaries 5

Construction, Debt Payment & Trust Funds - Budgeted Expenditures
 |  |  | Capital | Special
Description | Bond | Non-Voter | Projects | Building & | Trust/ | Foundation/ | Net
 | Redemption | Approved Debt | Building | Technology | Agency | Component | Total
 | Fund | Fund | Fund | Fund | Funds | Units | (OTHER FUNDS)
Direct Instruction
Instructional Support Services
School Management
Subtotal
District Wide Support Services
District Management
Plant Operations & Maintenance
Pupil Transportation
Food Services
Other Support Services
District Wide Support Services Subtotal
Community Services
Debt Services
Other Expenditures
Total Budgeted Expenditures
Estimated Funded Pupil Count
Budgeted Expenditures Per Funded Pupil
TABOR Amendment Reserves |  |  |  |  | Not Required | Not Required
Other Appropriated Reserves
Non-appropriated Reserves
Spreadsheet: michael_maggi__26456__NYMEXWEEKLY
Sheet: ho

Week Ending: | 2001-11-16 00:00:00
 | Futures Settlement Prices
 | HEATING OIL |  |  |  |  | Contract Symbol:  HO
 | Contract | Monday | Tuesday | Wednesday | Thursday | Friday | Open
 | Month | 2001-11-12 00:00:00 | 2001-11-13 00:00:00 | 2001-11-14 00:00:00 | 2001-11-15 00:00:00 | 2001-11-16 00:00:00 | Interest
 | 2001-12-01 00:00:00 | 0.601 | 0.6093 | 0.5612 | 0.5109 | 0.5218 | 35678
 | 2002-01-01 00:00:00 | 0.61 | 0.6183 | 0.5713 | 0.5212 | 0.5316 | 36494
 | 2002-02-01 00:00:00 | 0.612 | 0.6203 | 0.5753 | 0.5257 | 0.5366 | 17785
 | 2002-03-01 00:00:00 | 0.6035 | 0.6113 | 0.5683 | 0.5202 | 0.5321 | 19663
 | 2002-04-01 00:00:00 | 0.5945 | 0.6013 | 0.5613 | 0.5152 | 0.5281 | 14272
 | 2002-05-01 00:00:00 | 0.5835 | 0.5903 | 0.5528 | 0.5087 | 0.5226 | 6070
 | 2002-06-01 00:00:00 | 0.582 | 0.5883 | 0.5533 | 0.5112 | 0.5256 | 9054
 | 2002-07-01 00:00:00 | 0.587 | 0.5928 | 0.5588 | 0.5177 | 0.5321 | 4015
 | 2002-08-01 00:00:00 | 0.593 | 0.5983 | 0.5653 | 0.5252 | 0.5396 | 3062
 | 2002-09-01 00:00:00 | 0.6005 | 0.6053 | 0.5733 | 0.5337 | 0.5486 | 3050
 | 2002-10-01 00:00:00 | 0.6085 | 0.6128 | 0.5813 | 0.5422 | 0.5571 | 2233
 | 2002-11-01 00:00:00 | 0.616 | 0.6198 | 0.5888 | 0.5502 | 0.5656 | 1918
 | Total Weekly Volume |  |  |  | Total Open Interest |  | 162274
 |  |  |  | *Weekly volume and open interest reflects all traded months.
 | Historial Volatility-Spot Month Futures
 |  |  |  | Heating Oil
 | 5 Day Hist. Vol. |  |  | 0.9861
 | 20 Day Hist. Vol. |  |  | 0.5884
 | Implied Volatility-Options |  |  | Heating Oil
 | At the Money Call & Put |  |  | 0.5867
 | MON | TUE | WED | THUR | FRI | Total
Volume | 34477 | 37240 | 52735 | 60677 | 37642
Spreadsheet: 09e6a2e2-2356-4f26-b5a7-d165817acf12
Sheet: IMSANITY2

Team | [NAME] | Set | PPG | PPB | 15PG
Bloomington A | BMI | IMSANITY 2 | 207.8 | 16.34 | n/a
[NAME] | BMI | IMSANITY 2 | 128.9 | 9.66 | n/a
Carbondale | BMI | IMSANITY 2 | 470.9 | 23.64 | n/a
Champaign Centennial A | BMI | IMSANITY 2 | 297.8 | 20.45 | n/a
Champaign Centennial B | BMI | IMSANITY 2 | 95.7 | 7.18 | n/a
Crete-Monee A | TRIUMVIR | IMSANITY 2 | 35 | 6.32 | n/a
Crete-Monee B | TRIUMVIR | IMSANITY 2 | 51.9 | 6.25 | n/a
Danville A | BMI | IMSANITY 2 | 101.1 | 9.78 | n/a
Danville B | BMI | IMSANITY 2 | 57.1 | 10 | n/a
Dunlap | BMI | IMSANITY 2 | 175.6 | 13.24 | n/a
Fenton | TRIUMVIR | IMSANITY 2 | 217.7 | 17.11 | n/a
Fieldcrest | BMI | IMSANITY 2 | 107.1 | 9.23 | n/a
Glenbard East A | TRIUMVIR | IMSANITY 2 | 140 | 12.33 | n/a
Glenbard East B | TRIUMVIR | IMSANITY 2 | 51.1 | 6.43 | n/a
Glenwood A | BMI | IMSANITY 2 | 184.4 | 15.94 | n/a
Glenwood B | BMI | IMSANITY 2 | 124.4 | 9.14 | n/a
[NAME] | BMI | IMSANITY 2 | 124.3 | 12.31 | n/a
Loyola A | TRIUMVIR | IMSANITY 2 | 468.6 | 25.97 | n/a
Loyola B | TRIUMVIR | IMSANITY 2 | 312.3 | 18.72 | n/a
Loyola C | TRIUMVIR | IMSANITY 2 | 151.8 | 11.01 | n/a
Macomb A | BMI | IMSANITY 2 | 505.5 | 25.19 | n/a
[NAME] | BMI | IMSANITY 2 | 172.2 | 11.83 | n/a
Metea Valley | TRIUMVIR | IMSANITY 2 | 228.6 | 14.86 | n/a
New Trier | TRIUMVIR | IMSANITY 2 | 412.3 | 22.64 | n/a
Normal Community A | BMI | IMSANITY 2 | 122.9 | 9.77 | n/a
Normal Community B | BMI | IMSANITY 2 | 88.6 | 10 | n/a
PORTA A | BMI | IMSANITY 2 | 164.4 | 12.42 | n/a
PORTA B | BMI | IMSANITY 2 | 41.4 | 6.11 | n/a
Somonauk | TRIUMVIR | IMSANITY 2 | 37.5 | 4.17 | n/a
Springfield A | BMI | IMSANITY 2 | 312.2 | 18.38 | n/a
Springfield B | BMI | IMSANITY 2 | 128.6 | 9.57 | n/a
St. Viator A | TRIUMVIR | IMSANITY 2 | 205.9 | 14.48 | n/a
St. Viator B | TRIUMVIR | IMSANITY 2 | 203.2 | 12.35 | n/a
Stevenson A | TRIUMVIR | IMSANITY 2 | 297.3 | 19.31 | n/a
Stevenson B | TRIUMVIR | IMSANITY 2 | 250.5 | 16.51 | n/a
[NAME] A | TRIUMVIR | IMSANITY 2 | 165 | 13.81 | n/a
[NAME] B | TRIUMVIR | IMSANITY 2 | 75 | 9.74 | n/a
Wauconda A | TRIUMVIR | IMSANITY 2 | 259.5 | 17.12 | n/a
[NAME] | TRIUMVIR | IMSANITY 2 | 158.6 | 14.38 | n/a
Wheaton North A | TRIUMVIR | IMSANITY 2 | 247.7 | 17.92 | n/a
Wheaton North B | TRIUMVIR | IMSANITY 2 | 221.8 | 15.72 | n/a
Whitney Young | TRIUMVIR | IMSANITY 2 | 216.4 | 15.89 | n/a
WWS A | TRIUMVIR | IMSANITY 2 | 276.4 | 19.4 | n/a
WWS B | TRIUMVIR | IMSANITY 2 | 73.5 | 10.61 | n/a
Spreadsheet: 777766d1650594259-auto-populate-cells-from-data-on-other-tabs-2022-trading-journal
Sheet: January 

Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Weekly Totals
 |  |  |  |  |  |  |  |  |  |  |  | 2022-01-01 00:00:00
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
2022-01-02 00:00:00 |  | 2022-01-03 00:00:00 |  | 2022-01-04 00:00:00 |  | 2022-01-05 00:00:00 |  | 2022-01-06 00:00:00 |  | 2022-01-07 00:00:00 |  | 2022-01-08 00:00:00
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
2022-01-09 00:00:00 |  | 2022-01-10 00:00:00 |  | 2022-01-11 00:00:00 |  | 2022-01-12 00:00:00 |  | 2022-01-13 00:00:00 |  | 2022-01-14 00:00:00 |  | 2022-01-15 00:00:00
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
2022-01-16 00:00:00 |  | 2022-01-17 00:00:00 |  | 2022-01-18 00:00:00 |  | 2022-01-19 00:00:00 |  | 2022-01-20 00:00:00 |  | 2022-01-21 00:00:00 |  | 2022-01-22 00:00:00
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
2022-01-23 00:00:00 |  | 2022-01-24 00:00:00 |  | 2022-01-25 00:00:00 |  | 2022-01-26 00:00:00 |  | 2022-01-27 00:00:00 |  | 2022-01-28 00:00:00 |  | 2022-01-29 00:00:00
Spreadsheet: 674025d1587638127-issue-with-excel-solver-for-optimizing-smoothning-constant-in-winthers-forecasting-model-forecasting-case-thomas
Sheet: Plastic Case Data

 |  | Black Plastic | Clear Plastic
Year | Quarter | Demand | Demand
1 | 1 | 2250 | 3200
 | 2 | 1737 | 7658
 | 3 | 2412 | 4420
 | 4 | 7269 | 2384
2 | 5 | 3514 | 3654
 | 6 | 2143 | 8680
 | 7 | 3459 | 5695
 | 8 | 7056 | 1953
3 | 9 | 4120 | 4742
 | 10 | 2766 | 13673
 | 11 | 2556 | 6640
 | 12 | 8253 | 2737
4 | 13 | 5491 | 3486
 | 14 | 4382 | 13186
 | 15 | 4315 | 5448
 | 16 | 12045 | 3485
5 | 17 | 5648 | 7728
 | 18 | 3696 | 16591
 | 19 | 4843 | 8236
 | 20 | 13097 | 3316