tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: sally_beck__35172__MgmtSum-Q3-0928_Global
Sheet: GrossMargin

PLAN2000
[NAME] | ENRON GLOBAL MARKETS
2000-09-01 00:00:00 | 3RD QUARTER 2000 DETAIL OF GROSS MARGIN
M.QTD
ENA
 |  |  |  |  |  |  |  | Actual | Deals | Forecast | Total | Margin
 | Business Team |  | DPR(1) | MPR | Accruals | Other | FTA | Margin | Identified | Margin | Margin | Plan | [NAME]
 | Liquids |  |  | 0 | 0 | -510.078 | 0 |  |  | 0 |  | 20000
COAL | Coal |  | 5770 | -7351.335 | -10.527 | 0 | 0 |  |  | 0
SO2 | Emissions |  | 2982 | 0 | 0 | 0 | 0 |  |  | 0
WEATHER | Weather |  | 3016.856 | 0 | 0 | 0 | 0 |  |  | 0
INSURANCE | Global Risk Markets |  | 0 | 0 | 0 | 0 | 0 |  |  | 0
ECT_INV_IRFX | Equity Trading |  | 15136.895 | 0 | 0 | 0 | 0 |  |  | 0
 | FX / Int Rate Trading |  | 2330 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Soft Commodities Trading |  | -13.122 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Grain Trading |  | -42.377 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Meat Trading |  | -9.11 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Financial Trading
 | Office of the Chairman |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Overview |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 6786
 | Subtotal Gross Margin
 | Other Interest Related Charges |  | 0 | 0 | 0 | -516.832 | 0 |  |  | 0 |  | -538.419
 | EGM Gross Margin
 | (1) Excludes Cap. Charge & Operating Costs
Spreadsheet: 25e91af7-3853-4949-83f7-67d2577d96f7
Sheet: Sheet1

Table 3--Soybean oil:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Supply |  |  |  |  | Disappearance
Year beginning | Beginning | Production | Imports | Total |  | Domestic |  |  | Exports | Total | Ending
October 1 | stocks |  |  |  |  | Total | Biodiesel | Food |  |  | stocks
 | Million pounds
2011/12 | 2425.347 | 19740 | 149.325 | 22314.672 |  | 18310.522 | 4870 | 13440.522 | 1464.15 | 19774.672 | 2540
2012/131 | 2540 | 19820 | 205 | 22565 |  | 18660 | 4600 | 14060 | 2200 | 20860 | 1705
2013/142 | 1705 | 19380 | 250 | 21335 |  | 18550 | 5600 | 12950 | 1150 | 19700 | 1635
1 Estimated.  2 Forecast.
Source: USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates.
Last update: | 2013-11-13 09:21:17.580000
Spreadsheet: 436cf8da-cad4-407d-a46a-ce9355f9ab29
Sheet: LTM Non-GAAP EBITDA

Avis Budget Group, Inc.
Reconciliation of Adjusted EBITDA excluding certain items, amortization of deferred financing fees and stock-based compensation to income before income taxes
($ millions)
 | Trailing twelve months ending Sept. 30, 2011 |  | Trailing twelve months ending June 30, 2011 |  | Trailing twelve months ending March 31, 2011 |  | 2010
Adjusted EBITDA excluding certain items, amortization of deferred financing fees and stock-based compensation |  |  | 588 |  | 493 |  | 450
Amortization of deferred financing fees | 24 |  | 23 |  | 24 |  | 25
Stock-based compensation | 17 |  | 17 |  | 15 |  | 15
Adjusted EBITDA excluding certain items |  |  | 548 |  | 454 |  | 410
Less:  Non-vehicle related depreciation and amortization | 85 |  | 88 |  | 90 |  | 90
Interest expense related to corporate debt, net | 161 |  | 161 |  | 161 |  | 162
Income before income taxes, excluding certain items |  |  | 299 |  | 203 |  | 158
Less certain items:
Transaction-related expenses | 109 |  | 48 |  | 16 |  | 14
Acquisition-related interest | 30 |  | 22 |  | 15 |  | 8
Restructuring charges | 3 |  | 8 |  | 10 |  | 11
Early extinguishment of debt | 12 |  | 12 |  | 12 |  | 52
Litigation costs | - |  | - |  | 1 |  | 1
Income before income taxes | 201 |  | 209 |  | 149 |  | 72
Spreadsheet: 71654d1272394904-league-table-updates-leaguedata
Sheet: Sheet1 (2)

 |  | Champions League |  |  |  |  | Week:
 |  | Standing | Team | GW | New | HD | [NAME] | RSG | Points
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  | 11
 |  | 12
 |  | Championship |  |  |  |  |  | Week:
 |  | Standing | Team | GW | New | HD | [NAME] | RSG | Points
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  | 11
 |  | 12
 |  | Blue Square League |  |  |  |  |  | Week:
 |  | Standing | Team | GW | New | HD | [NAME] | RSG | Poins
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  | 11
 |  | 12
 |  | Under 7s Girls League |  |  |  |  |  | Week:
 |  | Standing | Team | GW | New | HD | [NAME] | RSG | Points
 |  | 1
 |  | 2
 |  | 3
 |  | 4
Spreadsheet: 843466d1695290598-calculate-amounts-depending-on-working-days-sample-etaf
Sheet: Sheet1

 | NAME | 2023-10-01 00:00:00 | 2023-10-02 00:00:00 | 2023-10-03 00:00:00 | 2023-10-04 00:00:00 | 2023-10-05 00:00:00 | 2023-10-06 00:00:00 | 2023-10-07 00:00:00 |  | NAME | [NAME]
Department 1 | TEST1 | 1 | 1 | 1 | 1 |  | 1 | 1 |  | TEST1 | 4500
 | TEST2 | 1 |  |  | 1 |  |  |  |  | TEST2 | 4500
 | TEST3 | 1 | 1 | 1 | 1 | 1 |  |  |  | TEST3 | 4350
Department 2 | TEST4 | 1 | 1 | 1 | 1 | 1 |  | 1 |  | TEST4 | 3800
 | TEST5 | 1 | 1 | 1 |  | 1 |  | 1 |  | TEST5 | 5620
 | TEST6 | 1 | 1 |  | 1 |  | 1 |  |  | TEST6 | 4380
Depatrtment 3 | TEST7 | 1 |  | 1 | 1 | 1 |  | 1 |  | TEST7 | 2287
 | TEST8 | 1 | 1 |  | 1 |  |  | 1 |  | TEST8 | 9684
 | TEST9 | 1 | 1 | 1 | 1 |  | 1 |  |  | TEST9 | 3987
 | TEST10 | 1 |  | 1 | 1 | 1 | 1 | 1 |  | TEST10 | 6842
Spreadsheet: 76907d1277378683-caculating-a-running-average-based-on-several-criteria-nfp-chart
Sheet: Sheet2

Sensations: | Discharge:
Dry | Full | Full |  |  |  |  |  | Temp: | 98.1 | 97.2 | 97.6 | 97.2 | 97.2 | 97.2 | 97.2 | 96.8 | 97.1 | 96.9 | 97 | 97.2 | 97 | 97.2 | 97 | 97.6 | 97.6 | 97.7 | 98.1 | 97.7 | 97.7 | 97.7 | 97.7 | 98.3 | 98.1 | 98.3 | 98.3 | 98 | 0 | 0 | 0
Wet | Slight | Slight |  |  |  |  |  | Zero? | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0
[Wet] | Y | Y- Opaque, [NAME], White Non-Stretchy |  |  |  |  |  | T.S. |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 97.6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | L | L- Clear, Watery, Smooth, Slippery |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 97.6 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | [L] | [L]- [NAME]
 | T | T- [NAME], Tacky
 | SR | SR- Seminal Residue |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 817209d1676052823-finding-and-returning-the-text-of-the-cell-to-the-right-of-a-value-in-a-dynamic-array-excelquestion1
Sheet: Sheet1

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 |  |  | Value | Custom
1 | A |  |  | 4 | G |  |  |  |  |  |  |  |  | 1 | A
 |  |  |  |  |  |  |  |  |  | 3 | F |  |  | 2 | B
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | F
 |  |  |  |  |  | 7 | T |  |  |  |  |  |  | 4 | G
 |  |  | 2 | B |  |  |  |  |  |  |  |  |  | 5 | Q
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | L
 |  |  |  |  |  |  |  | 6 | L |  |  |  |  | 7 | T
 |  | 5 | Q
What letter is next to # x?
1
2
3
4
5
6
7
Spreadsheet: 139671d1328374086-please-help-me-with-this-chart-not-sure-where-to-start-machine-problem
Sheet: Pivot Data

 | Daily Problems |  |  |  |  |  |  | Weekly Problems |  |  |  |  |  |  | Montly Problems
 |  | Values |  |  |  |  |  |  | Values |  |  |  |  |  |  | Values
 | Row Labels | Sum of Die problem | Sum of material problem | Sum of conveyor problem | Sum of glued pin problem | Sum of weighing problem |  | Row Labels | Sum of Die problem | Sum of material problem | Sum of conveyor problem | Sum of glued pin problem | Sum of weighing problem |  | Row Labels | Sum of Die problem | Sum of material problem | conveyor problem | Sum of glued pin problem | Sum of weighing problem
 | 2012 | 2 | 3 | 2 | 2 | 2 |  | 2012 | 6 | 6 | 6 | 5 | 5 |  | 2012 | 6 | 6 | 6 | 5 | 5
 | 1 |  | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  | Feb | 6 | 6 | 6 | 5 | 5
 | 2012-02-01 00:00:00 |  | 1 |  |  |  |  | 5 | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 | 1
 | 2012-02-02 00:00:00 |  |  |  |  |  |  | 2 | 1 |  | 1 | 1 | 1 |  | 2 | 1 |  | 1 | 1 | 1
 | 2 | 1 |  | 1 |  |  |  | 5 | 1 |  | 1 | 1 | 1 |  | 3 | 1 | 2 | 1 | 1 | 1
 | 2012-02-01 00:00:00 |  |  |  |  |  |  | 3 | 1 | 2 | 1 | 1 | 1 |  | 4 |  | 1 |  | 1 | 1
 | 2012-02-02 00:00:00 | 1 |  | 1 |  |  |  | 5 | 1 | 2 | 1 | 1 | 1 |  | 5 | 2 | 1 | 2 | 1
 | 3 | 1 |  | 1 |  | 1 |  | 4 |  | 1 |  | 1 | 1 |  | 6 | 1 | 1 | 1 |  | 1
 | 2012-02-01 00:00:00 | 1 |  | 1 |  |  |  | 5 |  | 1 |  | 1 | 1 |  | Grand Total | 6 | 6 | 6 | 5 | 5
 | 2012-02-02 00:00:00 |  |  |  |  | 1 |  | 5 | 2 | 1 | 2 | 1
 | 4 |  |  |  | 1 | 1 |  | 5 | 2 | 1 | 2 | 1
 | 2012-02-01 00:00:00 |  |  |  |  | 1 |  | 6 | 1 | 1 | 1 |  | 1
 | 2012-02-02 00:00:00 |  |  |  | 1 |  |  | 5 | 1 | 1 | 1 |  | 1
 | 5 |  | 1 |  | 1 |  |  | Grand Total | 6 | 6 | 6 | 5 | 5
 | 2012-02-01 00:00:00 |  |  |  | 1
 | 2012-02-02 00:00:00 |  | 1
 | 6 |  | 1
 | 2012-02-01 00:00:00 |  | 1
 | 2012-02-02 00:00:00
 | Grand Total | 2 | 3 | 2 | 2 | 2
Spreadsheet: 57052d1257231185-data-from-multiple-arrays-multiple-table-lookup
Sheet: Sheet1

 | A | B | C
X | 1 | 4 | 7
Y | 2 | 5 | 8
Z | 3 | 6 | 9
Table | A
Row | X |  | 4
Column | B
Spreadsheet: 814158d1674193279-annual-price-increase-annual-price-increase-reporting
Sheet: Leap Year 

[NAME] to determine whether leap year or not
Year | Leap Year ((Yes or No)
2018 |  | 365
2019 |  | 365
2020 |  | 366
2021 |  | 365
2022 |  | 365
2023 |  | 365
2024 |  | 366
2025 |  | 365
2026 |  | 365
Spreadsheet: 95312d1294929567-auto-numbers-to-invoices-generateandautonumber_newinvoice
Sheet: TEMPLATE

Company logo
 |  |  |  |  |  |  |  | SALES INVOICE |  |  |  |  | SALES TAX INVOICE
 |  |  |  |  |  |  |  |  |  |  |  |  | SALES INVOICE
 |  |  |  | Number |  |  |  |  | Date |  |  |  | [NAME]
Innovative Invoice: |  |  |  | LS
Client Purchase Order:
Innovative Delivery Chalan:
 |  |  | Supplier |  | Buyer
Address
Tel:
ST Registration No:
NTN No:
DO NOT DEDUCT TAX AT SOURCE FROM THIS INVOICE |  |  |  |  |  |  | Value - Rs.
This Invoice is in respect  of goods  imported by us on which we have paid tax under  section 148,  these goods fall under the provisions of sub section 5 of section 153 of  Income Tax Ordinance 2001 under this section no tax deductions are applicable at the time of Payment. |  |  |  |  |  |  | Sales Tax Exclusive
 |  |  |  |  |  |  |  |  | Sales Tax Payable | Total Incl. Sales Tax
Sr. # | Qty | Descrption of Goods |  |  | Sales  Tax % |  | Unit | Total
 |  |  |  |  | 16 |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | Total: | 0
Sales Tax Rs. |  |  | 0 |  |  |  |  |  | Paid: | 0
 |  |  |  |  |  |  |  |  | Balance: | 0
IC Representative |  |  |  | Goods Issued by |  |  |  |  | Goods Received by
Spreadsheet: tracy_geaccone__40319__Plan Dates
Sheet: bullet points

ENRON CORP
2000 - 2002 OPERATING & STRATEGIC PLAN
Targets
 | Income Targets
 |  | Set Net Income & Pre-tax targets
 | Other Objectives
 |  | Return on Investment
 |  | Cash Return on Capital Deployed
 |  | Pre-Tax Earnings on Capital Deployed
 |  | After-Tax Earnings on Capital Deployed
 | Funds Flow - no targets
 | Quarter vs Full Year targets
 |  | Quarter percentage growth same as total year percentage growth
Presentations
 | Free form as in prior years
 | [NAME]
 |  | 1st Page
 |  | Pre-Tax Earnings, Net Income
 |  | Capital Deployed Ratios, Total Expenses
 |  | Headcount
 |  | Prior Year Information & Quarterly Information
 | Global Functions - presentations
Key Dates
 | Summary
 | Budget Review Schedule - Time Allotment
Plan for 2001 and 2002
 | Amount of Emphasis
 | Targets for 2001 and 2002
 |  | Work with Corporate Group
Spreadsheet: phillip_m_love__30488__central basis curves
Sheet: Sheet1

 | Central Basis Curves
CGPR-DAWN
CGPR-PARKWAY
CGPR-WADDING
CGPR-NIAGARA
CGPR-EMERSONUSA
CGPR-CARLTON
CGPR-FARWELL
CGPR-CHIPPAWA
CGPR-ST.CLAIR
CGPR-OJIBWAY
CGPR-CORNWALL
CONSUMERS_CDA
MICH-ST.CLAIR
CGPR-IROQ
CGPR-SPUR
UNION_CDA
GDM-DAWN
GDM-NIAGARA
GDM-WADDINGTON
ANR/ML7-GDM
IF-MONCHY
MICH/CONS
MICH_CG-GD
ML7/CG
NGI/CHI. GATE
NGI/CHI./NIPSCO
NGI/CHI./WILLCO
ALLIANCE
ST.CLAIR (US$)
IF-ANR/JOLIET
DAWN-GDM
CGPR-CHIP-TRANS
CGPR-EMPRESS-US
MICH_EOL-GD
MICH/CONS-EOL
EOL-DAWN
IF-HARPER
NGI/CHI./PEOPLE
MICH/CONSP-GDM
CHI./N/BORDER
BELL_RIVER
IF-NBPL/VENT
IF-ANR/OK
IF-ONG/OKLAHOMA
IF-PAN/TX/OK
IF-WNG/TOK
IF-NNG/DEMARCAT
IF-NNG/TOK
IF-NNG/VENT
IF-IOWA_IL
IF-NGPL/MIDCON
NGPL/PER/1ST-GD
IF-NGPL/OK-NW
NGPL/AMARILO-GD
NGPL/IA-IL-GDM
IF-NGPL/HARPER
IF-NORAM/WEST
IF-NGPL/GAGE(W)
IF-TRUNKL/WLA
IF-ANR/LA
IF-ANR/LA_ONSHO
IF-ANR/LA_OFFSH
IF-ANR/HIOS
NGI-NGPL/ETXG7
NGI-NGPL/TX_G2
IF-NGPL/STX
IF-NGPL/LA
IF-NGPL/TX
IF-ARKLA/ARK-OK
IF-NORAM/EAST
MRT-GDM
IF-NGPLTXOK
IF-TRUNK/AVG
IF-TRUNKL/LA
IF-TRUNKL/TX
IF-TRUNKL/FLDZN
TRUNKL/WLA-GD
IF-NORAM/NPOOL
TRUNKL/WLA
Spreadsheet: 720171d1614049222-need-help-with-dates-incremented-by-25-days-and-excluding-weekends-taskgantt
Sheet: Sheet2

 |  |  |  |  | 2021-02-22 00:00:00
FEATURE | BACKLOG ITEM | Effort | Start Date | End Date | M |  |  |  | T |  |  |  | W |  |  |  | T |  |  |  | F |  |  |  | T |  |  |  | W |  |  |  | T |  |  |  | F
Parent Task |  | 5.25 | 2021-02-22 00:00:00
Spreadsheet: 80932d1281172123-conditional-retrieve-data-loss-hierachy
Sheet: problems

ID | MACHINE | MAN | MTC
TOTAL ID | FIC001 | A | 1,2,3…
 |  | B | …
 | FIC002 | C | …
 |  | D | …
 | FIC003 | E
 |  | F
 | FIC004 | G
 |  | H
 | FIC005 | I
 |  | J
 | FIC004 | K
 |  | L |  |  |  | - | Currently, there's only one sheet, including beside information
 | FIC007 | M |  |  |  | - | Each square is a chart
 |  | N |  |  |  |  |  | level 1 | one chart ( distribution) >> frequency function
 | FIC008 | O |  |  |  |  |  | level 2 | machine <=12 charts
 |  | P |  |  |  |  |  | level 3 | Man <=24 charts
 | FIC009 | Q |  |  |  |  |  | level 4 | MTC….
 |  | S |  |  |  | - | how can they be retrieved?
 | FIC010 | T
 |  | U
 | FIC011 | V
 |  | X
 | FIC012 | Y
 |  | Z
Spreadsheet: 199843d1355337595-division-of-a-single-cell-excel-question
Sheet: Sheet1

Name | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | Total |  | Pallets |  | Correct | Wrong | Wrong | Wrong | Wrong | Wrong | Wrong | Wrong | Wrong | Wrong
A | 750791 | 750791 | 750791 | 750791 | 750791 | 750791 | 750791 | 750791 | 750791 | 750791 | 750791 | 750791 | 9009492 |  | 2700
B | 295455 | 295455 | 590909 | 590909 | 590909 | 590909 | 590909 | 590909 | 590909 | 590909 | 590909 | 590909 | 6500000 |  | 2880
C | 0 | 240000 | 180000 | 240000 | 300000 | 360000 | 300000 | 360000 | 300000 | 360000 | 300000 | 360000 | 3300000 |  | 1680
D | 69120 | 92160 | 46080 | 69120 | 46080 | 115200 | 46080 | 46080 | 115200 | 46080 | 92160 | 0 | 783360 |  | 900
E | 0 | 34302 | 16404 | 0 | 0 | 0 | 0 | 17712 | 29472 | 0 | 50000 | 0 | 147890 |  | 792
F | 12319.3274226111 | 11670.9367261104 | 12967.6989569314 | 15561.2425807538 | 12967.6989569314 | 11670.9367261104 | 13616.089653432 | 9725.7837987887 | 12319.3274226111 | 11617.1293236878 | 9293.6957940781 | 8645.1326379543 | 142375.0000000005 |  | 1400
Spreadsheet: 692198d1598168395-speed-calculator-calculate-average-speed
Sheet: Sheet1

Total Miles | Start time | End Time | Total time taken | Total Miles/hour
29.5 | 04:00:00 | 06:00:00
45 | 16:00:00 | 19:00:00
31 | 15:00:00 | 18:30:00
23 | 05:00:00 | 07:20:00
58 | 03:30:00 | 07:30:00
Spreadsheet: 841713d1693896782-index-match-functions-with-multiple-values-and-empty-cells-arbeitsmappe1
Sheet: Tabelle1

3 | A
5 | B
2 | C
 | D
1 | E
 | F
0 | G
1 | H
3 | I
3 | J
Spreadsheet: 294664d1391462359-find-the-month-and-year-dates
Sheet: Sheet1

DueDateStart | Year: | Month of: | Count | Day | Weekday |  |  |  |  |  |  |  |  |  |  | Jan | 1 | Sunday
2014-Feb-06 06:35:00 PM |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | Feb | 2 | Monday
2014-Jan-31 05:01:00 PM |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | Mar | 3 | Tuesday
2014-Feb-10 04:07:00 PM |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | Apr | 4 | Wednesday
2014-Feb-10 04:04:00 PM |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | May | 5 | Thursday
2014-Feb-04 04:01:00 PM |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | Jun | 6 | Friday
2014-May-05 03:12:00 PM |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | Jul | 7 | Saturday
2014-Jan-28 03:03:00 PM |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | Aug | 8
2014-Feb-06 03:07:00 PM |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | Sep | 9
2014-Jan-28 03:07:00 PM |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | Oct | 10
2014-Jan-28 01:21:00 PM |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | Nov | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dec | 12
Spreadsheet: 855238d1704886550-concerting-time-to-degrees-time-and-degrees
Sheet: Sheet1

TIME | DEGREE
18:00:00 | 0
20:00:00 | 30
21:00:00 | 45 |  |  | 24 | HOURs
22:00:00 | 60 |  |  | 360 | DEGREES
22:48:00 | 72
00:00:00 | 90 |  |  |  | DEGRESS/HOUR
02:00:00 | 120
03:00:00 | 135
03:36:00 | 144
04:00:00 | 150
06:00:00 | 180
08:00:00 | 210
08:24:00 | 216
09:00:00 | 225
10:00:00 | 240
12:00:00 | 270
13:12:00 | 288
14:00:00 | 300
15:00:00 | 315
16:00:00 | 330
18:00:00 | 360
Spreadsheet: 374221d1422727351-conditional-formatting-groups-of-rows-bookexample2
Sheet: Desired Formatting

 |  |  |  |  |  |  |  |  |  |  |  |  | Below is the formatting I would like to create using a formula with conditional formatting.  The only reliable indicator of the beginning of a new set of rows is the first column, Date.
Date | Header2 | Data | MoreData |  |  |  |  |  |  |  |  | Date | Header2 | Data | MoreData
2094-10-25 00:00:00 | Item1 | Text |  |  |  |  |  |  |  |  |  | 2094-10-25 00:00:00 | Item1 | Text
 |  | Text1
2094-10-25 00:00:00 | Item2 | Text7 | 10.08 |  |  |  |  |  |  |  |  | 2094-10-25 00:00:00 | Item2 |  | 10.08
 |  | Text8
2094-10-24 00:00:00 | Item3 | Text9 | 0.02 |  |  |  |  |  |  |  |  | 2094-10-24 00:00:00 | Item3 |  | 0.02
 |  | Text10
2094-10-27 00:00:00 | Item4 | Text11 |  |  |  |  |  |  |  |  |  | 2094-10-27 00:00:00 | Item4
 | It's possible there could be text here… | [NAME] |  |  |  |  |  |  |  |  |  |  | It's possible there could be text here…
 | …so only the date is a reliable indicator. | Text13 | 238 |  |  |  |  |  |  |  |  |  | …so only the date is a reliable indicator. |  | 238
 |  | Text14 | 24 |  |  |  |  |  |  |  |  |  |  |  | 24
 |  | Text15 | 2423 |  |  |  |  |  |  |  |  |  |  |  | 2423
 |  | Text16
2094-10-27 00:00:00 | Item5 | Text17 | 232 |  |  |  |  |  |  |  |  | 2094-10-27 00:00:00 | Item5 |  | 232
 |  | Text18 | 2 |  |  |  |  |  |  |  |  |  |  |  | 2
2094-10-28 00:00:00 | Item6 | Text19 | 23 |  |  |  |  |  |  |  |  | 2094-10-28 00:00:00 | Item6 |  | 23
 |  | Text20 | 23 |  |  |  |  |  |  |  |  |  |  |  | 23
2094-10-29 00:00:00 | Item7 | Text21 | 23.27 |  |  |  |  |  |  |  |  | 2094-10-29 00:00:00 | Item7 |  | 23.27
 |  | Text22 | 12 |  |  |  |  |  |  |  |  |  |  |  | 12
 |  | Text23 | 1000 |  |  |  |  |  |  |  |  |  |  |  | 1000
2094-10-29 00:00:00 | Item8 | Text24 | 124 |  |  |  |  |  |  |  |  | 2094-10-29 00:00:00 | Item8 |  | 124
 |  | Text25
2094-10-29 00:00:00 | Item9 | Text26 | 4222 |  |  |  |  |  |  |  |  | 2094-10-29 00:00:00 | Item9 |  | 4222
 |  | Text27
 |  | Text28 | 424 |  |  |  |  |  |  |  |  |  |  |  | 424
 |  | Text29 | 32 |  |  |  |  |  |  |  |  |  |  |  | 32
2094-10-30 00:00:00 | Item11 | Text30 | 2 |  |  |  |  |  |  |  |  | 2094-10-30 00:00:00 | Item11 |  | 2
 |  | Text31 | 2 |  |  |  |  |  |  |  |  |  |  |  | 2
Spreadsheet: 63972d1264809785-vlookup-and-sum-call-logs-template-work1
Sheet: Tuesday

Public Que
8am - 12pm
Agent |  | Calls Answered | Calls Placed | Total Calls - All | Time on Calls Inbound | Time on Calls Outbound | Time on Calls - All | Avg. Call Inbound | Avg. Call Outbound | Avg. Call - All
Holder | [NAME]
[NAME] | Justin
Bellar | Marcus
[NAME] | Adam
[NAME] | [NAME]
Hicks | Rachel
[NAME] | Emily
Daily Total |  |  | 0 |  |  | 00:04:10 |  |  | 00:01:02
Totals
12 - 5pm
Agent |  | Calls Answered | Calls Placed | Total Calls - All | Time on Calls Inbound | Time on Calls Outbound | Time on Calls - All | Avg. Call Inbound | Avg. Call Outbound | Avg. Call - All
Packard | [NAME] |  |  |  |  |  |  |  | 00:00:00
Hirschi | Evin |  |  |  |  |  |  |  | 00:00:00
Kinney | Damon |  |  |  |  |  |  |  | 00:00:00
Way | Lindsey |  |  |  |  |  |  |  | 00:00:00
Eberspacher | [NAME] |  |  |  |  |  |  |  | 00:00:00
Thompson | [NAME] |  |  |  |  |  |  |  | 00:00:00
[NAME] | [NAME] |  |  |  |  |  |  |  | 00:00:00
Daily Totals |  |  | 0 |  |  | 00:06:20 |  |  | 00:02:07
Totals
Inbound Que
8am - 12pm
Agent |  | Calls Answered | Calls Placed | Total Calls - All | Time on Calls Inbound | Time on Calls Outbound | Time on Calls - All | Avg. Call Inbound | Avg. Call Outbound | Avg. Call - All
Holder | [NAME] |  |  |  |  |  |  |  | 00:00:00
[NAME] | Justin |  |  |  |  |  |  |  | 00:00:00
Bellar | Marcus |  |  |  |  |  |  |  | 00:00:00
[NAME] | Adam | 10 |  |  |  |  |  |  | 00:00:00
[NAME] | [NAME] |  |  |  |  |  |  |  | 00:00:00
Hicks | Rachel |  |  |  |  |  |  |  | 00:00:00
[NAME] | Emily |  |  |  |  |  |  |  | 01:00:00
Daily Totals |  |  | 0 |  |  | 00:00:00 |  |  | 00:00:00
Totals
12pm - 5pm
Agent |  | Calls Answered | Calls Placed | Total Calls - All | Time on Calls Inbound | Time on Calls Outbound | Time on Calls - All | Avg. Call Inbound | Avg. Call Outbound | Avg. Call - All
Packard | [NAME] |  |  |  |  |  |  |  | 00:00:00
Hirschi | Evin |  |  |  |  |  |  |  | 00:00:00
Kinney | Damon |  |  |  |  |  |  |  | 00:00:00
Way | Lindsey |  |  |  |  |  |  |  | 00:00:00
Eberspacher | [NAME] |  |  |  |  |  |  |  | 00:00:00
Thompson | [NAME] |  |  |  |  |  |  |  | 01:00:00
[NAME] | [NAME] |  |  |  |  |  |  |  | 02:00:00
Daily Totals |  |  | 0 |  |  | 00:00:00 |  |  | 00:00:00
Totals
Spreadsheet: joe_stepenovitch__15102__schedule
Sheet: Sheet1

Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
2001-12-10 00:00:00 | 2001-12-11 00:00:00 | 2001-12-12 00:00:00 | 2001-12-13 00:00:00 | 2001-12-14 00:00:00 | 2001-12-15 00:00:00 | 2001-12-16 00:00:00
 |  | [NAME] | Willis | Willis
 |  | [NAME] | [NAME] | [NAME]
 |  | [NAME] | [NAME] | [NAME]
 |  | [NAME] | [NAME] | [NAME]
Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
2001-12-17 00:00:00 | 2001-12-18 00:00:00 | 2001-12-19 00:00:00 | 2001-12-20 00:00:00 | 2001-12-21 00:00:00 | 2001-12-22 00:00:00 | 2001-12-23 00:00:00
[NAME] | [NAME] | Willis | [NAME] | Willis
Willis | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | Willis | [NAME] | Willis | [NAME]
 | [NAME]
Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
2001-12-24 00:00:00 | 2001-12-25 00:00:00 | 2001-12-26 00:00:00 | 2001-12-27 00:00:00 | 2001-12-28 00:00:00 | 2001-12-29 00:00:00 | 2001-12-30 00:00:00
Willis |  | [NAME] | [NAME] | [NAME]
 |  | Willis | [NAME] | Willis
 |  | [NAME] | Willis | [NAME]
Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
2001-12-31 00:00:00 | 2002-01-01 00:00:00 | 2002-01-02 00:00:00 | 2002-01-03 00:00:00 | 2002-01-04 00:00:00 | 2002-01-05 00:00:00 | 2002-01-06 00:00:00
[NAME] |  | [NAME] | [NAME] | [NAME]
Willis |  | [NAME] | [NAME] | Willis
[NAME] |  | Willis | [NAME] | [NAME]
 |  | [NAME] | [NAME] | [NAME]
Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
2001-01-07 00:00:00 | 2001-01-08 00:00:00 | 2001-01-09 00:00:00 | 2001-01-10 00:00:00 | 2001-01-11 00:00:00 | 2001-01-12 00:00:00 | 2001-01-13 00:00:00
 | home | cell
[NAME] | [PHONE] | [PHONE] |  | a.m. schedule
[NAME] | [PHONE] |  |  | 7:30 - 11:30
[NAME] | [PHONE] |  |  | p.m. schedule
[NAME] | [PHONE] | [PHONE] |  | 11:30 - 3:30
Willis | [PHONE]