tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 540974d1507055059-conditional-formatting-with-returns-sample-workbook-for-conditional-formatting-1-
Sheet: Sheet1

All Ratio | All Ratio 1 |  | Growth Ratio | Growth Ratio 1 |  | Activity Ratio | Activity Ratio 1 |  | Profitability Ratio | Profitability Ratio 1 |  | Liquidity Ratio | Liquidity Ratio 1 |  | [NAME] | [NAME]
Sales Growth | -0.2023 |  | Sales Growth | -0.202255616867641 |  | Receivable Turnover | 0.2411030825318958 |  | Profit Margin | 0.9944758270683529 |  | Current Ratio | 3.514816205342137 |  | Debt to Total Assets | 0.2477887971738819
Income Growth | 0.2149290178086301 |  | Income Growth | 0.2149290178086301 |  | Inventory Turnover | 0 |  | Return On Assets | 0.148555299709115 |  | [NAME] | 3.353314924824457
Asset Growth | 6.322026464530071 |  | Asset Growth | 6.322026464530071 |  | Fixed Asset Turnover | 2.280800185572854 |  | Return On Equity | 0.3492352778984828
Receivable Turnover | 0.2411030825318958
Inventory Turnover | 0
Fixed Asset Turnover | 2.280800185572854
Profit Margin | 0.9944758270683529
Return On Assets | 0.148555299709115
Return On Equity | 0.3492352778984828
Current Ratio | 3.514816205342137
[NAME] | 3.353314924824457
Debt to Total Assets | 0.2477887971738819
 |  |  |  | Ratio | Ratio_1 | Count | Ratio | Ratio_1
1 | All Ratio | All Ratio |  |  |  |  |  |  |  | 3
2 | Growth Ratio |  |  |  |  |  |  |  |  | 4
3 | Activity Ratio |  |  |  |  |  |  |  |  | 5
4 | Profitability Ratio |  |  |  |  |  |  |  |  | 6
5 | Liquidity Ratio |  |  |  |  |  |  |  |  | 7
6 | [NAME] |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  | 14
Spreadsheet: 10688e21-50c7-42b3-9f2f-b7d2c537a667
Sheet: I

 | COURSES IN RED ARE GENERAL EDUCATION COURSES FOR FALL 2012 |  |  | PURPLE  J-TERM |  | GREEN BOTH FALL  & J-TERM
International Studies | AOK designation | CAR designation | Comment
INST 245 | SS- International Studies | Non-Western | cross-listed with EVST 245
 | Natural & Mathematical Sciences-Nat Sci w Lab
INST 251 | SS-International Studies
INST 261 | SS-International Studies |  | travel jan 2010
INST 270 | SS-International Studies
INST 321 | SS-International Studies |  | cross-listed with PSCI 321
INST 335 |  | Experiential-Travel
INST 391-392 |  | Experiential-Research
INST 422 |  | Capstone; Experiential-Research
INST 448-449 |  | Capstone
INST 452-453 |  | Capstone
INST 483 |  | Non-Western | Spring 2006; cross-listed with HIST 481
INST 483-484 |  | Capstone
INST 487-488 |  | Experiential-Research
INST 493-494 |  | Capston; Experiential-Research
INST 496-498 |  | Capstone; Experiential-Research
Spreadsheet: 877681d1724491385-conditional-formatting-northernrunner-cf-365-aligw-tms-v2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 |  |  | 1, 11, 21, 31, 41, 51
 |  |  | 2, 12, 22, 32, 42, 52 |  |  |  |  |  |  |  |  |  |  |  |  | True |  |  | True
 |  |  | 3, 13, 23, 33, 43 |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  | #[NAME]!
 |  |  | 4, 14, 24, 34, 44 |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  | #[NAME]!
 |  |  | 5, 15, 25, 35, 45 |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  | #[NAME]!
 |  |  | 6, 16, 26, 36, 46 |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  | #[NAME]!
 |  |  | 7, 17, 27, 37, 47 |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  | #[NAME]!
 |  |  | 8, 18, 28, 38, 48 |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  | #[NAME]!
 |  |  | 9, 19, 29, 39, 49 |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  | #[NAME]!
 |  |  | 10, 20, 30, 40, 50 |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  | #[NAME]!
Spreadsheet: 80779d1280973331-counting-based-on-2-criteria-results
Sheet: Sheet1

Date | Q1 | Q2 | Q3 | Q4 | Q5 | Q6 | Q7 | Q8 |  | [NAME] Here => | 2010-08-02 00:00:00
2010-08-02 00:00:00 | 1 | 2 | 3 | 4 | 4 | 4 | 5 | 5
2010-08-02 00:00:00 | 3 | 4 | 4 | 4 | 4 | 4 | 5 | 5
2010-08-02 00:00:00 | 3 | 5 | 4 | 4 | 4 | 5 | 4 | 5 |  | Number of people attending | 7
2010-08-02 00:00:00 | 3 | 5 | 4 | 4 | 4 | 5 | 4 | 5 |  | Number of 5's | 73
2010-08-02 00:00:00 | 3 | 5 | 4 | 4 | 4 | 5 | 4 | 5 |  | Number of 4's
2010-08-02 00:00:00 | 3 | 5 | 4 | 4 | 4 | 5 | 4 | 5 |  | Number of 3's
2010-08-02 00:00:00 |  |  |  |  |  |  |  |  |  | Number of 2's
2010-07-02 00:00:00 | 3 | 5 | 4 | 4 | 4 | 5 | 4 | 5 |  | Number of 1's
2010-07-02 00:00:00 | 3 | 5 | 4 | 4 | 4 | 5 | 4 | 5
2010-07-02 00:00:00 | 3 | 5 | 4 | 4 | 4 | 5 | 4 | 5
2010-07-02 00:00:00 | 3 | 5 | 4 | 4 | 4 | 5 | 4 | 5
2010-07-02 00:00:00 | 3 | 5 | 4 | 4 | 4 | 5 | 4 | 5
2010-07-02 00:00:00 | 3 | 5 | 4 | 4 | 4 | 5 | 4 | 5
2010-07-02 00:00:00 | 3 | 5 | 4 | 4 | 4 | 5 | 4 | 5
2010-07-02 00:00:00
2010-07-02 00:00:00
2010-07-02 00:00:00
2010-05-05 00:00:00 | 3 | 5 | 4 | 4 | 4 | 5 | 4 | 5
2010-05-05 00:00:00 | 3 | 5 | 4 | 4 | 4 | 5 | 4 | 5
2010-05-05 00:00:00 | 3 | 5 | 4 | 4 | 4 | 5 | 4 | 5
2010-05-05 00:00:00 | 3 | 5 | 4 | 4 | 4 | 5 | 4 | 5
2010-05-05 00:00:00 | 3 | 5 | 4 | 4 | 4 | 5 | 4 | 5
2010-05-05 00:00:00 | 3 | 5 | 4 | 4 | 4 | 5 | 4 | 5
2010-05-05 00:00:00 | 3 | 5 | 4 | 4 | 4 | 5 | 4 | 5
2010-05-05 00:00:00 | 3 | 5 | 4 | 4 | 4 | 5 | 4 | 5
2010-05-05 00:00:00 | 3 | 5 | 4 | 4 | 4 | 5 | 4 | 5
2010-05-05 00:00:00 | 3 | 5 | 4 | 4 | 4 | 5 | 4 | 5
2010-05-05 00:00:00 | 3 | 5 | 4 | 4 | 4 | 5 | 4 | 5
2010-05-05 00:00:00 | 3 | 5 | 4 | 4 | 4 | 5 | 4 | 5
Spreadsheet: 240054d1370170448-populate-table-based-on-drop-down-selection-excel_filter
Sheet: Sheet1

filter | a
 |  |  |  |  |  |  | Row Labels | Count of number
 |  |  |  |  |  |  | a | 3
 |  |  |  |  |  |  | b | 2
 |  |  |  |  |  |  | d | 1
 |  |  |  |  |  |  | e | 1
 |  |  |  |  |  |  | f | 2
 |  |  |  |  |  |  | g | 1
 |  |  |  |  |  |  | h | 1
 |  |  |  |  |  |  | Grand Total | 11
table1
customer | date | number
Spreadsheet: 863362d1710869474-adjust-formula-with-blanks-no-blanks-test-15-
Sheet: Sheet2

Countries | Code | 1 | 2 | 3 | 4 | 5 | 6
Afghanistan | AFG | Low income | 1234137 | 0 | 0.0105999994277954
Albania | ALB | Upper middle income | 83227 | 0.692341995239258 | 0.692341995239258
Algeria | DZA | Lower middle income | 988272 | 0 | 0.7907399749755859
American Samoa | ASM | High income | 2327 | 0 | 0.683929901123047
Andorra | AND | High income | 1691 | 0 | 0
Angola | AGO | Lower middle income | 2334213.5 | 0 | 0.396110191345215
[NAME] and [NAME] | ATG | High income | 2104.5 | 0 | 0.7025360107421881
Argentina | ARG | Upper middle income | 1988442.5 | 0 | 0.76186653137207
Armenia | ARM | Upper middle income | 109181 | 0.287847690582275 | 0.287847690582275
Aruba | ABW | High income | 2112.5 | 0 | 1.03520858764648
Australia | AUS | High income | 618596.5 | 0 | 1.60214385986328
Austria | AUT | High income | 258173 | 0 | 1.02857139587402
Azerbaijan | AZE | Upper middle income | 421042 | 0.462895889282227 | 0.462895889282227
Bahamas, The | BHS | High income | 9258 | 0 | 0.397394790649414
Bahrain | BHR | High income | 58957 | 0 | 0.526030311584473
Bangladesh | BGD | Lower middle income | 8772784.5 | 0.3638068771362299 | 0.3638068771362299
Barbados | BRB | High income | 6023 | 0.751266479492188 | 0.751266479492188
Belarus | BLR | Upper middle income | 277425 | 0.9676632690429691 | 0.9676632690429691
High income | 0.837960662841797
Upper middle income | 0.779466094970703
Lower middle income | 0.584978103637695
Low income | 0.201464595794678
World | 0.608573989868164
Spreadsheet: 683188d1592551219-calculating-some-meals-calories-in-convenient-way-kcal
Sheet: Sheet1

 |  |  | PROD1 | PROD2 | PROD3 | PROD4 | PROD5
 |  | cal/100g | 100 | 300 | 200 | 500 | 800
MEAL NAME 1 | [NAME] |  | 50 | 20 | 10 | 30 | 10
 | Sum kcal
MEAL NAME 2 | [NAME] |  | 30 | 50 | 100 | 50 | 10
 | Sum kcal
MEAL NAME 3 | [NAME] |  | 10 | 10 | 10 | 10 | 10
 | Sum kcal
MEAL NAME 4 | [NAME] |  | 20 | 20 | 20 | 20 | 20
 | Sum kcal
MEAL NAME 5 | [NAME] |  | 80 | 40 | 30 | 20 | 10
 | Sum kcal
Spreadsheet: tracy_geaccone__40535__TWOrgPLFormatCORP02
Sheet: FundsFlow vs. 3rd CE

DETAIL OF FUNDS FLOW
(Millions of Dollars)
 |  |  |  |  | 2002
 |  |  |  |  | Plan |  | 3rd C.E. |  | [NAME]
Funds Flow Information
 | Net Income |  |  |  |  |  | 78
 | Depreciation, Depletion & Amortization |  |  |  |  |  | 20.5
 | Deferred Taxes |  |  |  |  |  | 0.2
 | Net (Gain) / Loss from Sale of Assets |  |  |  |  |  | 0.1
 | Price Risk Management Activities |  |  |  |  |  | -0.1
 | Merchant Activities (net)
 |  | Realized (Gains) / Losses on Sales |  |  |  |  | 0
 |  | Proceeds from Sales |  |  |  |  | 0
 |  | Additions |  |  |  |  | 0
 |  | Unrealized (Gains) / Losses |  |  |  |  | 0
 | Equity Earnings |  |  |  |  |  | 0
 | Equity / Partnership Distributions |  |  |  |  |  | 0
 | Dividends on Pref. Securities of Subsidiary Companies |  |  |  |  |  | 0
 | Income Attributable to Minority Interest |  |  |  |  |  | 0
 | Other (Including Transfers & Reclasses)
 |  | Total Funds Flow |  |  |  |  | 113.2
Funds Flow Variance Analysis
 | Funds Flow - 2001 Third Current Estimate
 |  | Net Income Change
 |  | Regulatory Assets Change (Additional AFUDC Gross-Up) |  |  |  |  | -1.1
 |  | Reserve Activity Change |  |  |  |  | -12.5
 |  | Lower Income Taxes |  |  |  |  | 4.6
 |  | Others, Net
 | Funds Flow - 2002 Operating Plan
Spreadsheet: 789805d1659371052-help-with-extracting-info-in-a-single-cell-and-outputting-in-a-different-format-book2
Sheet: Sheet1

17" Alloy Wheels, Climate Control, CO2 Emissions - 91 g/km, [NAME]) - 2, Last Srvc - 01/22 9k, Leather Trim, Navigation System, [NAME]), S Inf - 1 service, Sunroof, Vehicle Location - Walsall
17" Alloy Wheels, Climate Control, CO2 Emissions - 109 g/km, DVSA Mileage - 18k, [NAME]) - 2, Last Srvc - 06/22 18k, [NAME], Navigation System, [NAME]), [NAME], S Inf - 3 services, Vehicle Location - Thurleigh
18" Alloy Wheels, Change of Registration, Climate Control, CO2 Emissions - 179 g/km, DVSA Mileage - 12k 14k, [NAME]) - 2, Last Srvc - 01/22 14k, MOT Expiry - 12/02/2023, Navigation System, Panoramic Roof, [NAME]), [NAME], S Inf - 4 services, Vehicle Location - Preston
[NAME], Alloy Wheels, CO2 Emissions - 116 g/km, DVSA Mileage - 0k 8k 8k, [NAME]) - 2, Last Srvc - 04/19 7k, [NAME], Navigation System, NOx Emissions - 0.003 g/km, [NAME]), [NAME] srvc, Vehicle Location - Measham Cars
Alloy Wheels, Climate Control, CO2 Emissions - 148 g/km, DVSA Mileage - 20k 25k 30k 33k 33k, [NAME]) - 2, Last Srvc - 08/21 33k, Leather Trim, [NAME], Navigation System, S Inf - 4 services, Vehicle Location - Bridgwater
17" Alloy Wheels, Change of Registration, Climate Control, CO2 Emissions - 119 g/km, DVSA Mileage - 14k 18k 22k 27k 30k 41k, [NAME]) - 2, Last Srvc - 07/20 30k, [NAME], [NAME] g/km, [NAME]), S Inf - 7 services, [NAME] srvc, Vehicle Location - Brighouse
Alloy Wheels, Change of Registration, Climate Control, CO2 Emissions - 128 g/km, DVSA Discrepancy, DVSA Mileage - 13k 16k 20k 23k 23k 23k, [NAME]) - 2, Last Srvc - 03/22 23k, Leather Trim, [NAME], Panoramic Roof, [NAME]), [NAME], S Inf - 5 services, Vehicle Location - Thurleigh
17" Alloy Wheels, Cherished Plate - not guaranteed, Climate Control, CO2 Emissions - 145 g/km, [NAME]) - 2, Last Srvc - 05/16 3k, [NAME]), S Inf - 2 services, Vehicle Location - Manchester
[NAME], Alloy Wheels, CO2 Emissions - 111 g/km, DVSA Mileage - 19k 23k, [NAME]) - 2, MOT Expiry - 26/04/2023, [NAME]), Vehicle Location - Bedford
* Manual CAP Value Calc.*, 18" Alloy Wheels, Climate Control, CO2 Emissions - 175 g/km, DVSA Mileage - 14k 17k 20k 21k 22k, [NAME]) - 2, Last Srvc - 01/21 22k, Leather Trim, [NAME], Navigation System, Panoramic Roof, [NAME]), [NAME], S Inf - 6 services, Vehicle Location - Thurleigh
17" Alloy Wheels, Air Conditioning, Climate Control, CO2 Emissions - 150 g/km, DVSA Mileage - 29k 39k 47k, [NAME]) - 2, Last Srvc - 03/22 47k main dlr, [NAME], [NAME], Navigation Media, NOx Emissions - 0.011 g/km, [NAME], [NAME]), [NAME], [NAME] srvc 5 main dlr, Vehicle Location - Newcastle
Alloy Wheels, Climate Control, CO2 Emissions - 94 g/km, DVSA Mileage - 39k 45k 46k, [NAME]) - 2, Last Srvc - 04/20 44k, [NAME], [NAME] g/km, [NAME]), S Inf - 11k,23k,37k,39k, [NAME] srvc, Vehicle Location - Bham - Perry Barr
Spreadsheet: 759966d1639851464-formula-to-calculate-savings-efficiency-ability-sheet-v2
Sheet: Sheet1

Year | Start Balance | Deposit | Efficiency | Inflation | Efficiency amount | End amount | After inflation |  |  | Total ability
2020 |  | 1200 | 0.06 | 0.021
2021 |  | 1500 | 0.05 | 0.022
2022 |  | 1500 | 0.07 | 0.022
2023
2024
2025
2026
2027
2028
2029
2030
2031
2032
2033
2034
2035
2036
2037
2038
2039
2040
2041
2042
2043
2044
2045
2046
2047
2048
2049
2050
2051
2052
2053
2054
2055
2056
2057
2058
Spreadsheet: 62067d1262962035-using-date-differences-to-format-cell-colors-sample-roster
Sheet: Sheet1

Current Date: |  | 2010-01-08 00:00:00
Date Format: Day Month Year
Member | [NAME] (exp) | ATFP (exp)
xxxx | 2010-01-31 00:00:00 | 2010-06-11 00:00:00
xxxx | 2010-11-30 00:00:00 | 2010-07-09 00:00:00
xxxx | 2010-04-30 00:00:00 | 2010-04-23 00:00:00
xxxx | 2010-09-30 00:00:00 | 2010-11-23 00:00:00
xxxx | 2010-04-30 00:00:00 | 2010-11-24 00:00:00
xxxx | 2010-02-28 00:00:00 | 2010-11-18 00:00:00
xxxx | 2010-04-30 00:00:00 | 2010-11-18 00:00:00
xxxx | 2010-02-28 00:00:00 | 2010-02-10 00:00:00
xxxx | 2009-12-31 00:00:00 | 2010-07-23 00:00:00
Spreadsheet: 0d75e650-ebc8-482b-976c-fcd31ce65e69
Sheet: Docket

JURIS | TICKET | VIOL | OCCUR | NAME | VIOLATION | FINE AMT | COST AMT | REST AMT | TOTAL AMT | TIME SERVED | PAID AMT | BALANCE | OFFENSE DT | ATTORNEY | BOND POSTED | COMPLAINANT
DPD | 1021079 | 2244 | 0 | HAMILTON,EZEKIEL JOSEPH | SPEEDING | 81 | 105.1 | 0 | 186.1 | 0 | 0 | 186.1 | 2013-02-21 00:00:00 |  | 0 | R ALLSTOT
DPD | 1018688 | 4031 | 0 | MACKEY,[NAME] | PARKING-HANDICAPPED-COUNTERFEIT/ALTERED | 500 | 72 | 0 | 572 | 0 | 0 | 572 | 2013-04-14 00:00:00 |  | 0 | J R ZIHLMAN
DPD | 1020092 | 5740 | 0 | MARTIN,[NAME] | [NAME] | 281 | 72 | 0 | 353 | 0 | 0 | 353 | 2013-04-12 00:00:00 |  | 0 | [NAME]
DPD | 1003249 | 1200 | 0 | RAMIREZ,LUIS ANTONIO | DL-NO DRIVER'S LICENSE IN POSSESSION | 95 | 229.23 | 0 | 324.23 | 0 | 0 | 324.23 | 2012-04-24 00:00:00 | KATRINA ANDERSON | 0 | C M COBB
DPD | 1003249 | 1209 | 0 | RAMIREZ,LUIS ANTONIO | DL-EXPIRED OPERATOR'S LICENSE | 95 | 229.23 | 0 | 324.23 | 0 | 0 | 324.23 | 2012-04-24 00:00:00 | KATRINA ANDERSON | 0 | C M COBB
DPD | 1003249 | 1231 | 0 | RAMIREZ,LUIS ANTONIO | DL-DWLI - FIRST OFFENSE - SUSPENDED | 252 | 276.33 | 0 | 528.33 | 0 | 0 | 528.33 | 2012-04-24 00:00:00 | A BRADLEY ANDERSON | 0 | C M COBB
DPD | 1003249 | 2244 | 0 | RAMIREZ,LUIS ANTONIO | SPEEDING | 77 | 223.83 | 0 | 300.83 | 0 | 0 | 300.83 | 2012-04-24 00:00:00 | A BRADLEY ANDERSON | 0 | C M COBB
DPD | 1021676 | 2210 | 0 | WADE,[NAME] | SPEEDING - CONSTRUCTION ZONE - WORKERS PRESENT | 146 | 105.1 | 0 | 251.1 | 0 | 0 | 251.1 | 2013-03-15 00:00:00 |  | 0 | K JORDAN
Spreadsheet: 53e536d9-b850-4f97-a23e-c08dadc26bce
Sheet: Sheet1

CNJC 2012 Show-n-Sell Cases Only Order Form | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Contact Name |  |  |  |  | District |  | Your Show-N-Sell order can not exceed more than 5% retail of your total 2011 Show-N-Sell and [NAME].  You can get that number from your District Executive.  If you are ordering Chocolate products you must sign the non-returnable waiver form.
E-mail |  |  |  |  | Pack #
Phone |  |  |  |  | Troop #
[NAME] |  |  |  |  | Crew #
 |  |  |  |  | Team # |  | Print order form and fax to (732) 823-1472 no later than:  August 27th.
Please refer to www.cnjcscouting.org for Council's Check Return Policy.
 | [NAME] |  |  | # [NAME]'s in Case |  | CASE Qty Needed |  |  |  | Cost Per Case | Retail Cost
 | Chocolate Lovers Collection Tin* |  |  | 1 |  |  |  | Reminder - you are entering the number of CASES you are ordering on this form! |  | 55
 | Sweet & Savory* |  |  | 1 |  |  |  |  |  | 40
C | Cheese Lover's |  |  | 1 |  |  |  |  |  | 30
 | White Chocolatey Pretzels Tin* |  |  | 6 |  |  |  |  |  | 150
 | Kettle Corn 18-Pack |  |  | 6 |  |  |  |  |  | 132
 | 18-Pack Unbelieveable Butter |  |  | 6 |  |  |  |  |  | 108
 | 18-Pack Butter Light |  |  | 6 |  |  |  |  |  | 108
 | Chocolate Triple Delight* |  |  | 8 |  |  |  |  |  | 144
 | Caramel Corn Almond/Cashew/Pecan |  |  | 8 |  |  |  |  |  | 144
 | 7 oz Cheddar Cheese Corn |  |  | 8 |  |  |  |  |  | 96
 | 11 oz. Caramel Corn |  |  | 12 |  |  |  |  |  | 120
*Chocolate Product Not Returnable/You must submit signed waiver. |  |  |  |  |  |  |  | Total Retail Cost
For Office Staff Only |  |  |  | Entered on |  |  |  |  | Entered by
 | Areas in grey are not necessary to complete to place order.  However, they will populate if you enter data in Excel.
Spreadsheet: 811737d1672766686-conditional-formatting-with-checks-of-multiple-dates-exc-etaf
Sheet: Sheet1

 |  |  |  | GEN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEB
 | A 1 | A 2 | A 3 | 2023-01-01 00:00:00 | 2023-01-02 00:00:00 | 2023-01-03 00:00:00 | 2023-01-04 00:00:00 | 2023-01-05 00:00:00 | 2023-01-06 00:00:00 | 2023-01-07 00:00:00 | 2023-01-08 00:00:00 | 2023-01-09 00:00:00 | 2023-01-10 00:00:00 | 2023-01-11 00:00:00 | 2023-01-12 00:00:00 | 2023-01-13 00:00:00 | 2023-01-14 00:00:00 | 2023-01-15 00:00:00 | 2023-01-16 00:00:00 | 2023-01-17 00:00:00 | 2023-01-18 00:00:00 | 2023-01-19 00:00:00 | 2023-01-20 00:00:00 | 2023-01-21 00:00:00 | 2023-01-22 00:00:00 | 2023-01-23 00:00:00 | 2023-01-24 00:00:00 | 2023-01-25 00:00:00 | 2023-01-26 00:00:00 | 2023-01-27 00:00:00 | 2023-01-28 00:00:00 | 2023-01-29 00:00:00 | 2023-01-30 00:00:00 | 2023-01-31 00:00:00 | 2023-02-01 00:00:00 | 2023-02-02 00:00:00 | 2023-02-03 00:00:00 | 2023-02-04 00:00:00 | 2023-02-05 00:00:00 | 2023-02-06 00:00:00 | 2023-02-07 00:00:00 | 2023-02-08 00:00:00 | 2023-02-09 00:00:00 | 2023-02-10 00:00:00 | 2023-02-11 00:00:00 | 2023-02-12 00:00:00 | 2023-02-13 00:00:00 | 2023-02-14 00:00:00 | 2023-02-15 00:00:00 | 2023-02-16 00:00:00 | 2023-02-17 00:00:00 | 2023-02-18 00:00:00 | 2023-02-19 00:00:00 | 2023-02-20 00:00:00 | 2023-02-21 00:00:00 | 2023-02-22 00:00:00 | 2023-02-23 00:00:00 | 2023-02-24 00:00:00 | 2023-02-25 00:00:00 | 2023-02-26 00:00:00 | 2023-02-27 00:00:00 | 2023-02-28 00:00:00
EX 1 | 2023-01-19 00:00:00 | 2023-02-02 00:00:00 | 2023-02-16 00:00:00 |  |  |  |  | Example of what should happen->
EX 2 | 2023-01-10 00:00:00 | 2023-01-31 00:00:00 | 2023-02-21 00:00:00
EX 3 | 2023-01-16 00:00:00 | 2023-02-06 00:00:00 | 2023-02-21 00:00:00
EX 4 | 2023-01-09 00:00:00 | 2023-01-24 00:00:00 | 2023-02-08 00:00:00
EX 5 | 2023-01-17 00:00:00 | 2023-01-31 00:00:00 | 2023-02-14 00:00:00
EX 6 | 2023-01-10 00:00:00 | 2023-02-02 00:00:00 | 2023-02-13 00:00:00
EX 7 | 2023-01-11 00:00:00 | 2023-02-25 00:00:00 | 2023-02-15 00:00:00
EX 8 | 2023-01-10 00:00:00 | 2023-01-24 00:00:00 | 2023-02-14 00:00:00
EX 9 | 2023-01-11 00:00:00 | 2023-02-07 00:00:00 | 2023-02-22 00:00:00
EX 10 | 2023-01-18 00:00:00 | 2023-02-07 00:00:00 | 2023-02-23 00:00:00
EX 11 | 2023-01-11 00:00:00 | 2023-01-25 00:00:00 | 2023-02-22 00:00:00
Spreadsheet: 856972d1706103588-help-with-vstack-formula-kansas-scheduler-v2-
Sheet: Press Date Calculation

Press Time Totals by Date
↓Date↓ |  | ↓Tauro↓ | ↓3R↓ | ↓HP↓ | ↓HS↓ | ↓GS↓ | ↓Indigo↓ | ↓Cut Only↓ | ↓Fabrivue↓ | ↓TOTALS↓
2024-01-23 00:00:00 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
Spreadsheet: kate_symes__18431__MidC
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-01-08 00:00:00 |  | 147.54 | 22800 | 130.49 | 6480
 | 2001-01-07 00:00:00 |  | 140 | 0 | 130 | 0 | 119.61 | 888 | 82.66 | 800 |  | 130.49 | 19440
 | 2001-01-06 00:00:00 |  | 146.05 | 22800 | 135.85 | 3616 | 103.18 | 1305 | 98.34 | 1325
 | 2001-01-05 00:00:00 |  | 146.05 | 22800 | 135.85 | 3616 | 134.44 | 1345 | 120.8 | 1155
 | 2001-01-04 00:00:00 |  | 152.95 | 20280 | 139.1 | 5544 | 143.03 | 190 | 127.53 | 415
 | 2001-01-03 00:00:00 |  | 175.7 | 14400 | 163.68 | 3800 | 156.14 | 485 | 127.71 | 648
 | 2001-01-02 00:00:00 |  | 185.67 | 14400 | 176.33 | 3000 | 142.46 | 2097 | 126.6 | 1453
 | 2001-01-01 00:00:00 |  | 187.5 | 0 | 175 | 0 | 111.05 | 95 | 110 | 300 |  | 176.33 | 9000
 | 2000-12-31 00:00:00 |  | 167.5 | 0 | 157.5 | 0 | 150.12 | 2630 | 110 | 450 |  | 164.5 | 19440
 | 2000-12-30 00:00:00 |  | 171.7 | 19408 | 160.7 | 5608 | 146.38 | 705 | 145.32 | 1175
 | 2000-12-29 00:00:00 |  | 217.65 | 10992 | 169.05 | 3208 | 214.02 | 1107 | 166.68 | 674
 | 2000-12-28 00:00:00 |  | 217.65 | 10992 | 169.05 | 3208 | 190.98 | 1381 | 158.36 | 802
 | 2000-12-27 00:00:00 |  | 394.68 | 12400 | 267.17 | 3320 | 165.54 | 2855 | 159.35 | 1123
 | 2000-12-26 00:00:00 |  | 451.15 | 10624 | 428.32 | 2712 | 182.26 | 2772 | 177.14 | 934
 | 2000-12-25 00:00:00 |  | 410 | 32 | 315 | 200 | 201.38 | 12441 | 207.74 | 775 |  | 377.09 | 5160
 | 2000-12-24 00:00:00 |  |  |  | 315 | 200 | 225.8 | 1588 | 225.35 | 855 |  | 377.09 | 5160
 | 2000-12-23 00:00:00 |  | 462.41 | 8224 | 382.64 | 1912 | 325.41 | 4915 | 244.19 | 2400
 | 2000-12-22 00:00:00 |  | 463 | 8624 | 382.94 | 1712 | 349.16 | 4653 | 309.33 | 2630
 | 2000-12-21 00:00:00 |  | 463 | 8624 | 384.75 | 2112 | 425 | 150 | 350 | 50
 | 2000-12-20 00:00:00 |  | 463.54 | 9424 | 386.4 | 1912 | 411.71 | 1117 | 365.63 | 240
 | 2000-12-19 00:00:00 |  | 471.25 | 7824 | 408.97 | 312 | 547.65 | 3749 | 506.72 | 1005
 | 2000-12-18 00:00:00 |  | 372.89 | 7600 | 321.88 | 1600 | 378.62 | 360 | 328.33 | 150
 | 2000-12-17 00:00:00 |  |  |  |  |  | 368.41 | 1404 | 355.96 | 663 |  | 321.88 | 4800
 | 2000-12-16 00:00:00 |  | 317.57 | 11504 | 272.19 | 1112 | 374.92 | 642 | 339.88 | 168
 | 2000-12-15 00:00:00 |  | 317.59 | 11424 | 272.19 | 1112 | 364.78 | 598 | 477.91 | 763
 | 2000-12-14 00:00:00 |  | 459.34 | 7024 | 342.87 | 1712 | 380.91 | 1574 | 283 | 1890
 | 2000-12-13 00:00:00 |  | 700.87 | 7824 | 485.4 | 1712 | 391.35 | 1561 | 349.97 | 318
 | 2000-12-12 00:00:00 |  | 956.16 | 9024 | 636.87 | 2712 | 526.56 | 322 | 355.87 | 412
 | 2000-12-11 00:00:00 |  | 3322.42 | 5744 | 2166.67 | 600 | 1285.47 | 695 | 451.85 | 621
 | 2000-12-10 00:00:00 |  |  |  |  |  | 595.02 | 1607 | 516.15 | 975 |  | 2125 | 2400
 | 2000-12-09 00:00:00 |  | 781.79 | 10896 | 449.75 | 808 | 423.26 | 1913 | 496.71 | 380
 |  |  |  |  |  | ..