tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 453948d1459531248-sumif-returning-0-formatting-sumif_problem
Sheet: Dashboard

Part Number | SUMIF Formula
11‐55
11‐67
12‐45
12‐55
12‐65
12‐75
12‐85
13‐45
13‐55
13‐65
13‐75
13‐85
15‐45
15‐55
15‐65
15‐75
16‐45
16‐55
16‐65
16‐75
16‐85
50‐10
50‐35
50‐40
50‐45
50‐50
50‐70
61‐55
61‐65
61‐75
63‐55
63‐65
63‐75
69‐45
69‐55
69‐65
69‐75
71‐55
71‐65
71‐75
75‐55
75‐65
18‐12
18‐12
18‐12
Spreadsheet: 831324d1685548640-break-up-text-example111
Sheet: Sheet1

 | Full Item | Item Type | Colour
 | Nike Shoes (Blue)
 | Addidas Shirt (Green)
 | Nike Jumper (Red)
 | Nike Trousers (Blue)
 | Full Item | Item Type | Colour
 | Nike Shoes (Blue) | Nike Shoes | (Blue)
 | Addidas Shirt (Green) | [NAME] | (Green)
 | Nike Jumper (Red) | Nike Jumper | (Red)
 | Nike Trousers (Blue) | Nike Trousers | (Blue)
Spreadsheet: 134826d1325655413-help-match-or-vlookup-with-most-recently-updated-price-and-with-multiple-conditions-book1
Sheet: Orders & Delivery

Orders |  |  |  |  |  | Price List
Date | Customer | Product | Price | Result should be |  | Date | Customer | Product | Price List
2011-11-01 00:00:00 | [NAME] | Rock | ??? |  |  | 2011-10-31 00:00:00 | [NAME] | Rock | 1
2011-11-02 00:00:00 | [NAME] | Paper | ??? |  |  | 2011-11-16 00:00:00 | [NAME] | Rock | 2
2011-11-05 00:00:00 | [NAME] | Rock | ??? |  |  | 2011-11-03 00:00:00 | [NAME] | Rock | 4
2011-11-10 00:00:00 | [NAME] | Paper | ??? |  |  | 2011-11-05 00:00:00 | [NAME] | Paper | 3
2011-11-06 00:00:00 | [NAME] | Rock | ??? |  |  | 2011-11-02 00:00:00 | [NAME] | Rock | 6
2011-11-04 00:00:00 | [NAME] | Rock | ??? |  |  | 2011-11-01 00:00:00 | [NAME] | Paper | 7
 |  |  |  |  |  | 2011-11-04 00:00:00 | [NAME] | Paper | 5
Spreadsheet: 02307648-d959-4ebf-9d16-fa25c9daee34
Sheet: EXAMPLE-set aside calculations

FEDERAL SUPPLEMENTAL FUNDING SOURCE | TOTAL LEA ALLOCATION | 5% MINIMUM SET ASIDE | 15% MAXIMUM SET ASIDE | TOTAL SET ASIDE AMOUNT AT LEA LEVEL | FUNDING SOURCES AND AMOUNTS THAT EQUAL TOTAL SET ASIDE
Title I-A | 900000 |  |  | 90000 | all from Title I-A
Title II-A | 275000
Title III | 150000 |  |  | 20000 | 50% Title III, 50% Title III
IDEA | 900000 |  |  | 80000 | all from IDEA
Spreadsheet: e9082b18-9981-40c7-8467-5b6ec12836e8
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
GING | Test | GING | Ginger, IgE | Ginger, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
GING | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
GING | Result | GING | Ginger, IgE | Ginger, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 7335-3 | [NAME] officinale Ab.IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: fdc4d85b-fdeb-49e0-be5b-48940d777dc1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | U.S. Census Bureau
 |  | Source: Quarterly Services Survey
 |  | 51: Information: U.S. Total
 |  | Seasonally Adjusted Total Revenue [Millions of Dollars]
 |  | Period: 2003 to 2013
 |  | Data Extracted on: December 18, 2014 (8:49 pm)
Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter
2003 | X | X | X | 229371
2004 | 229646 | 233241 | 235336 | 237875
2005 | 242085 | 244136 | 247183 | 247443
2006 | 250954 | 254990 | 258328 | 262731
2007 | 263776 | 266272 | 270025 | 272054
2008 | 276019 | 278206 | 280691 | 273572
2009 | 267266 | 267665 | 268736 | 271174
2010 | 273058 | 275612 | 279685 | 281383
2011 | 283078 | 290271 | 293177 | 293795
2012 | 297910 | 301286 | 303811 | 309614
2013 | 311650 | 314808 | 320413 | 326348
Spreadsheet: 168165d1342274721-excel-find-starting-and-finishing-time-starting-and-end-time-of-task
Sheet: Sheet1

TASK | Starting Time | Finishing Time | TEST
[NAME] | 11:15:00 | 11:26:00
[NAME] | 11:31:00 | 11:40:00 | BREAK
Reagendamentos | 11:41:00 | 11:45:00
Reagendamentos | 11:46:00 | 11:49:00
Reagendamentos | 11:50:00 | 11:54:00 | BREAK
[NAME] | 15:03:00 | 15:12:00
[NAME] | 15:13:00 | 15:21:00
[NAME] | 15:22:00 | 15:34:00 | BREAK
Confirmacoes Comercials | 16:07:00 | 16:08:00
Confirmacoes Comercials | 16:20:00 | 16:41:00 | BREAK
[NAME] | 19:00:00 | 19:10:00
[NAME] | 19:36:00 | 19:46:00
[NAME] | 19:47:00 | 20:02:00 | BREAK
Spreadsheet: 679905d1590678977-conditional-formatting-formula-for-kpi-to-complete-by-due-date-copy-of-ops-management
Sheet: Weekly Input (Forecast) 

 |  | May | June | July | August | September | October | November | December | [NAME]
Parts OTD (Line Items ) | Forecast | 50 | 50 | 60 | 76 | 45 | 50 | 30 | 20
 | AS is till date | 20 | 10 | 50
[NAME] trending - Core Sercices |  |  | 0.1 | 0.1 | 0.2 | 0.1 | 0.1 | 0.1 | 0.2
% of customer feedback closed within 60 days |  |  | 0.1 | 0.1 | 0.2 | 0.1 | 0.1 | 0.1 | 0.2 | 0.2
OTD % - Core Service (Complete)
Outages
Past Due Receivables |  | 4 | 3 | 4 | 3 | 3 | 3 | 3 | 2
Cash Collection |  | 13 | 19 | 8 | 12 | 11 | 12 | 18 | 25
Billing |  | 22 | 8 | 12 | 11 | 12 | 15 | 24 | 19
Service orders
Service Upgrade orders
Service core orders
Service Orders as Sold CCM%
Service Upgrades as Sold CCM%
Service core  Orders as Sold CCM%
Spreadsheet: 688231d1595637652-using-data-validation-to-link-data-to-different-locations-excel-help-2
Sheet: Financing Structure & Fees Ass.

Financing Structure
 | Structure
Sources of Funds | Structure 1 | Structure 2 | Structure 3 | Structure 4 | Status Quo
Revolving Credit Facility Size | 250 | 250 | 250 | 250
Revolving Credit Facility Draw
Term Loan A |  | 500
Term Loan B | 2150 | 1650 | 2100 | 1750
Term Loan C
2nd [NAME]
Senior Notes | 1500 | 1500 | 700 | 1000
Senior Suboridinate Notes |  |  | 700 | 1000
Senior Bridge Facility
Senior Subordinate Bridge Facility
Equity Contribution | 2100 | 2100 | 2250 | 2250
Rollover Equity
Cash and Cash Equivalents | 250 | 250 | 250
Total Sources of Funds
Uses of Funds
Equity Purchase Price | 4350 | 4350 | 4350 | 4350 | 4350
Existing Bank Debt | 1000 | 1000 | 1000 | 1000 | 1000
Existing Bond Debt | 500 | 500 | 500 | 500 | 500
Existing Mezzanine Debt | 0 | 0 | 0 | 0 | 0
Tender / Call Premiums | 20 | 20 | 20 | 20 | 20
Deferred Financing Fees | 90 | 90 | 90 | 90 | 90
Other Fees and Expenses | 40 | 40 | 40 | 40 | 40
Total Use of Funds
Financing Fees
 |  | Fees
 | Structure 1 | Size | (%) | ($)
Revolving Credit Facility Size |  |  | 0.015
Term Loan A |  |  | 0.015
Term Loan B |  |  | 0.015
Term Loan C |  |  | 0.015
2nd [NAME] |  |  | 0.0225
Senior Notes |  |  | 0.0225
Senior Suboridinate Notes |  |  | 0.0225
Senior Bridge Facility |  | 1500 | 0.01
Senior Subordinate Bridge Facility |  | 0 | 0.01
Other Financing Fees & Expense |  |  |  | 5.3
Total Financing Fees
Amortization of Financing Fees
 | Term | Year 1 2013 | Year 2 2014 | Year 3 2015 | Year 4  2016 | Year 5 2017 | Year 6  2018 | Year 7  2019 | Year 8 2020 | Year 9  2021 | Year 10 2022
Revolving Credit Facility Size | 6
Term Loan A
Term Loan B | 7
Term Loan C
2nd [NAME]
Senior Notes | 8
Senior Suboridinate Notes
Senior Bridge Facility | 8
Senior Subordinate Bridge Facility
Other Financing Fees & Expense | 8
Annual Amortization
Spreadsheet: james_steffes__12781__LI QSE26
Sheet: North

QSE | Operating Day | Interval | Zone | [NAME] | Actual [NAME] | (SL-AML)/AML | MCPE | Settlement for Load Imbalance
26 | 2001-08-01 00:00:00 |  | N | 682.5 | 0.1698000000000001 | 4018.434628975262 |  | -16736.857583
26 | 2001-08-02 00:00:00 |  | N | 190 | 0.2687 | 706.1082992184591 |  | -3841.006317999999
26 | 2001-08-03 00:00:00 |  | N | 415 | 0.4025999999999999 | 1029.799801291605 |  | 57278.34760600002
26 | 2001-08-04 00:00:00 |  | N | 1300 | 0.4416 | 2942.840579710145 |  | -42998.405826
26 | 2001-08-05 00:00:00 |  | N
26 | 2001-08-06 00:00:00 |  | N | 236.5 | 0.5218999999999998 | 452.151944817015 |  | -15614.661731
26 | 2001-08-07 00:00:00 |  | N | 154 | 0.5015 | 306.0787637088735 |  | -11776.992455
26 | 2001-08-08 00:00:00 |  | N | 606 | 0.5628999999999998 | 1075.567774027359 |  | -31332.798141
26 | 2001-08-09 00:00:00 |  | N | 170 | 0.8945999999999997 | 189.0290632685 |  | -7432.477854
26 | 2001-08-10 00:00:00 |  | N | 825 | 0.9713000000000004 | 848.3771234428083 |  | -66204.81534100002
26 | 2001-08-11 00:00:00 |  | N | 300 | 0.9879 | 302.6744609778318 |  | -11522.694624
26 | 2001-08-12 00:00:00 |  | N | 10 | 1.0449 | 8.570293808019905 |  | -187.456969
26 | 2001-08-13 00:00:00 |  | N | 825 | 0.9609 | 857.5700905401186 |  | -40691.23888099998
26 | 2001-08-14 00:00:00 |  | N | 1330 | 0.9412999999999998 | 1411.939551683842 |  | -452228.6288470001
26 | 2001-08-15 00:00:00 |  | N | 2500 | 0.9789000000000002 | 2552.88701603841 |  | -803561.2091229999
26 | 2001-08-16 00:00:00 |  | N | 1810 | 0.8595999999999999 | 2104.630525825966 |  | -37229.080886
26 | 2001-08-17 00:00:00 |  | N | 2310 | 0.7341 | 3145.710257458112 |  | -55279.58249100002
26 | 2001-08-18 00:00:00 |  | N | 169.75 | 0.8593999999999998 | 196.5215266464976 |  | -29401.79941600002
26 | 2001-08-19 00:00:00 |  | N | 925 | 0.9640999999999998 | 958.4440410745774 |  | -197580.416412
26 | 2001-08-20 00:00:00 |  | N | 1970 | 1.0788 | 1825.103077493512 |  | -179278.617527
26 | 2001-08-21 00:00:00 |  | N | 2540 | 2.0154 | 1259.295722933413 |  | -208336.8229379999
26 | 2001-08-22 00:00:00 |  | N | 2863 | 2.3153 | 1235.556817691012 |  | -372176.898736
26 | 2001-08-23 00:00:00 |  | N | 3825 | 2.7125 | 1409.138248847926 |  | -274604.9138019999
26 | 2001-08-24 00:00:00 |  | N | 2710 | 2.8298 | 956.6648526397626 |  | -48313.71866200002
26 | 2001-08-25 00:00:00 |  | N | 300 | 3.216400000000001 | 92.27198109687848 |  | -8144.655231999996
26 | 2001-08-26 00:00:00 |  | N | 0 | 2.661599999999998 | -1 |  | 51.42250099999998
26 | 2001-08-27 00:00:00 |  | N | 170 | 2.3592 | 71.05832485588336 |  | 9714.569153000002
26 | 2001-08-28 00:00:00 |  | N | 350 | 2.224499999999998 | 156.3387278040011 |  | -12894.54497099999
26 | 2001-08-29 00:00:00 |  | N
26 | 2001-08-30 00:00:00 |  | N | 490 | 2.2189 | 219.830141060886 |  | -12544.265618
26 | 2001-08-31 00:00:00 |  | N | 1530 | 2.5391 | 601.5757158048127 |  | -27125.902873
Spreadsheet: john_griffith__15775__10_18_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL X1 | EXP |  |  | 63.1 | 74 | 0.95 | 2001-10-16 14:40:00
 | CL Z1 | 21.5 | 265 | 272 | 57 | 58.5 | 0.78 | 2001-10-18 14:44:00
 | CL F2 | 22 | 366 | 376 | 53.2 | 54.6 | 0.75 | 2001-10-18 14:44:00
 | CL G2 | 22 | 430 | 438 | 49.9 | 50.9 | 0.7 | 2001-10-18 14:44:00
 | CL H2 | 22 | 466 | 476 | 47.2 | 48.3 | 0.66 | 2001-10-18 14:44:00
 | CL J2 | 22 | 485 | 500 | 44.2 | 45.6 | 0.62 | 2001-10-18 14:44:00
 | CL K2 | 22 | 505 | 525 | 41.9 | 43.5 | 0.59 | 2001-10-18 14:44:00
 | CL M2 | 22 | 520 | 530 | 40.2 | 40.9 | 0.56 | 2001-10-18 14:44:00
 | CL N2 | 22 | 525 | 538 | 37.9 | 38.8 | 0.53 | 2001-10-18 14:44:00
 | CL Q2 | 22 | 530 | 540 | 36.3 | 37 | 0.51 | 2001-10-18 14:44:00
 | CL U2 | 22 | 535 | 545 | 34.9 | 35.6 | 0.49 | 2001-10-18 14:44:00
 | [NAME] | 22 | 535 | 548 | 33.3 | 34.1 | 0.47 | 2001-10-18 14:44:00
 | [NAME] | 21.5 | 545 | 552 | 32.3 | 32.7 | 0.44 | 2001-10-18 14:44:00
 | CL M3 | 21.5 | 540 | 560 | 27.2 | 28.2 | 0.37 | 2001-10-18 14:44:00
 | CL Z3 | 21.5 | 540 | 565 | 24.3 | 25.4 | 0.34 | 2001-10-18 14:44:00
Spreadsheet: mary_fischer__25726__20R MTM Summary
Sheet: June

Enron Energy Services
MTM Summary
Company 20R
 |  |  |  | Beginning |  |  |  | Ending
Date |  | Account MSA/SAP |  | Balance |  | Change |  | Balance
 |  | 2106-0000 Asset-C |  | 31910438 |  |  |  | 2
 |  | 3030-0000 Liab-C |  | 0 |  |  |  | 0
 |  | 2510-0200 Prudency |  | 0 |  |  |  | 0
 |  | 2510-0300 Prudency |  | 0 |  |  |  | 0
 |  | 2510-0100 Credit Reserve
 |  | 2510-0000 Asset-NC |  | 0 |  |  |  | 0
 |  | 3310-0000 Liab-NC |  | 0 |  |  |  | 0
 |  | 2003-2500 Liquidation |  | 0 |  |  |  | 0
 |  | Recorded on co# 1572 |  | 0 |  |  |  | 56249878
 |  |  |  |  |  | Ending
Date |  | Account |  |  |  | Balance
 |  | 4200-0000 MTM Rev |  |  |  | -24339442
 |  | 42106010- Fair Value Hedge
 |  | 42006020- Fair Value Hedge
 |  | 42006030 - Fair Value Hedge
 |  | 42006040- Fair Value Hedge
 |  | 42006050- Fair Value Hedge
 |  | 42006060- Cash Flow Hedge
 |  | 42006070- Cash Flow Hedge
 |  | 42006080- Cah Flow Hedge
 |  | 42006090- Cash Flow Hedge
 |  | Difference
Spreadsheet: 754449d1636209773-linking-two-tables-and-selecting-highest-ranking-names-using-pivot-table-sxaubagne-
Sheet: Tab B

 | Names | Number | Select
 | [NAME] |  | x
 | Jonah |  | x
 | [NAME] |  | x
 | Jonah |  | x
 | [NAME]
 | [NAME]
 | [NAME]
Spreadsheet: darron_c_giron__8010__EMW0831a
Sheet: NSS2

 | ENRON MIDWEST DESK - PHYSICAL |  |  |  |  |  |  |  | [NAME] | $ | Volume | Variance Impact
 |  |  |  |  |  |  |  |  | West to West:
 |  |  |  | TOTAL |  |  |  |  |  |  | TOTAL
 | THIRD PARTY SALES |  | TOTAL $'s | MMBTU | WASP |  |  | THIRD PARTY PURCHASES |  | TOTAL $'s | MMBTU | WACOG
1 | Sales |  |  |  |  |  | 6 | Purchases
 | AFFILIATE & |  |  | TOTAL |  |  |  | AFFILIATE & |  |  | TOTAL
 | INTERDESK SALES |  | TOTAL $'s | MMBTU | AVG PRICE |  |  | INTERDESK PURCHASES |  | TOTAL $'s | MMBTU | AVG PRICE
3 | BUG Desk |  |  |  |  |  | 8 | BUG Desk
3 | Central |  |  |  |  |  | 8 | Central
3 | ECT |  |  |  |  |  | 8 | ECT
3 | SITHE |  |  |  |  |  | 8 | SITHE
1 | HPLR-Texas Desk |  |  |  |  |  | 6 | HPLR-Texas Desk
1 | LGM-LRC |  |  |  |  |  | 6 | LGM-LRC
3 | Market East |  |  |  |  |  | 8 | Northeast
3 | Northeast |  |  |  |  |  | 16 | CPR Pipeline Exchange
16 | CPR Pipeline Exchange |  |  |  |  |  | 18
17 | Storage Desk |  |  |  |  |  | 8 | Texas-ECT
3 | Texas-ECT |  |  |  |  |  | 15 | CPR Cash Out
14 | CPR Cash Out |  |  |  |  |  |  | CPR Fuels
10 | CPR Fuels |  |  |  |  |  | 13 | CPR Imbalance
13 | CPR Imbalance |  |  |  |  |  | 6 | Ontario
3 | Ontario |  |  |  |  |  | 18 | CPR Storage
17 | CPR Storage |  |  |  |  |  |  | Transport Book
 | Transport Book |  |  |  |  |  |  | Gross Affilliate Purchases
 | [NAME] Sales |  |  |  |  |  |  | TOTAL PURCHASES
 | TOTAL SALES
 |  |  | 0 |  |  |  |  | This line is used exclusively for calculating Unaccounted For
31 | PHYSICAL MTM VALUE |  | 0 |  |  |  |  | Long Term Firm WACOG
30 | PROMPT MONTH VALUE |  | 0
31 | PHYSICAL REVERSAL |  | 0
Spreadsheet: andy_zipper__171__DYNEGY-ICE VOL Apr18
Sheet: ICE-ECC

Enron Canada Corporation
Activity on ICE
UOM | Deals | Volume
 |  |  |  |  |  |  | START | END
Enron Canada Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:  Apr-18-01 thru Apr-18-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
Spreadsheet: lindy_donoho__21965__lindylivingexpsest
Sheet: Buy House & Buy 1 Condo

425000 | sell house
-189000 | pay-off mortgage
-50000 | pay-off cars
-10000 | pay-off line of credit
-125000 | purchase $125,000 house
-20000 | pay-off condo
 | balance
17000 | net bonus
0 | Don't buy 2 other condo's
 | $$ in the bank
Monthly |  |  |  |  |  | Annually
 | [NAME]'s gross income/month (assumes 25% tax bracket)
 | [NAME]'s gross income/month (pre-tax or tax deductible)
 | Required gross income/month |  |  |  |  |  | [NAME]'s gross income/year
 |  |  |  |  |  | 8400 | Rental income/year
After-tax expenses
0 | no monthly payment on house
700 | income from condo1 |  |  |  |  | Tax Deductions
0 | income from condo2 |  |  |  |  | House:
0 | income from condo3 |  |  |  |  | No Interest
-1125 | child support |  |  |  |  | Property Taxes
 | health insurance |  |  |  |  | [NAME]'s:
-50 | cable (TV, internet) |  |  |  |  | Property Taxes
-75 | phone |  |  |  |  | Maintenance Fees
-125 | electricity
-40 | gas
-45 | water/garbage
-150 | cell phone
-100 | lawn
-100 | house insurance
-100 | car insurance (2)
-100 | life insurance |  |  |  |  | Estimated 2001 Galveston County property taxes:
-100 | flood insurance |  |  |  |  | 118000 | 0.005326
 | 401(k) & savings |  |  |  |  | 118000 | 0.01585
 | property taxes house |  |  |  |  | 118000 | 0.006385
 | condo's maint. fees |  |  |  |  | 118000 | 0.00155
 | property taxes condo's |  |  |  |  | 118000 | 0.000124
-600 | groceries
-400 | clothes, gifts, entertainment
-100 | golf (2)
-75 | haircut/color
Pre-tax/tax deductible expenses
-400 | health insurance
-400 | 401(k) & savings
-145 | condo's maint. fees (1 @ $145/mo.)
 | property taxes condo's (1 @ $1,000/yr.)
 | property taxes house ($3,450/yr.)
Spreadsheet: 881838d1730055520-worksheet-with-month-drop-down-sheet-changes-based-on-month-help-bills
Sheet: Receipts

 | Receipts & Purchases
 | Date Sorted | Date Trans
 | 2024-10-26 00:00:00 | 2024-10-26 00:00:00
 |  |  |  | Gavin |  |  | [NAME] |  |  |  | Owed
 | Gavin's Cards |  |  | Shop | [NAME] | Adjusted | Shop | [NAME] | Adjusted |  | G to J | J to G
 | 1731 | 4322 |  | asda | 33.7 | 27 | aldi |  | 16.58 |  | 30 | 2
 | 2724 |  |  | ms |  | 20.42 | range |  | 7.99 |  | 0 | 36
 | 8309 | 4713 |  | costc |  | 13.48 | tesco |  | 16.17 |  | 0 | 0
 | 2946 | 3433 |  | tesco |  | 20.4 | amazon |  | 9.49 |  | 0 | 0
 |  | 5088 |  | bq |  | 30 | cost |  | 6.98 |  | 0 | 0
 | Jack's Cards |  |  |  |  | 12 | sains |  | 17 |  | 0 | 0
 | 0231 | 2154 |  | aldi | 7.92 | 6.93 |  |  | 5.1 |  | 0 | 0
 | 7377 |  |  |  | 13.64 | 9.66 | shop |  | 6.79
 |  |  |  |  | 10.92 | 5.94 |  |  | 7.99
 |  |  |  |  | 19.31 | 17.33 |  |  | 13.58
 |  |  |  |  |  | 31.35 |  |  | 4.45
 |  |  |  |  | 10.32 | 8.34 |  |  | 7.69
 |  |  |  |  | 11.43 | 9.48 |  |  | 13.58
 |  |  |  |  |  | 24.29 |  |  | 4.85
 |  |  |  |  |  | 20.73 |  |  | 13.58
 |  |  |  |  |  | 9.27 | wow |  | 4.33
 |  |  |  |  |  | 20.95 | uber |  | 13.43
 |  |  |  | sains |  | 37.72 | shop |  | 4
 |  |  |  |  | 10.64 | 5.64 |  |  | 6.79
 |  |  |  |  |  | 18.97 |  |  | 13.58
 |  |  |  |  |  | 17 | disn |  | 10.99
 |  |  |  |  |  | 10.94 | shop |  | 7.99
 |  |  |  |  |  | 17.24 |  |  | 6.79
 |  |  |  |  |  | 32.34 |  |  | 6.75
 |  |  |  |  |  | 35.93 | doms |  | 16.98
 |  |  |  |  | 27.39 | 23 | pet ins |  | 42.34
 |  |  |  |  | 20.84 | 10.5 | shop |  | 5.65
 |  |  |  |  |  | 35.17 | shop | card | 13.58
 |  |  |  |  |  | 21.97 |  |  | 7.78
 |  |  |  |  |  | 28.94 |  |  | 7.09
 |  |  |  | fuel |  | 30 |  |  | 6.79
 |  |  |  | netflix |  | 10.99 |  |  | 6.79
 |  |  |  | miosc |  | 15 |  |  | 6.79
 |  |  |  | [NAME] |  | 14.45 |  |  | 6.79
 |  |  |  | ebay |  | 2.62 |  |  | 6.79
 |  |  |  | ebay |  | 21 |  |  | 6.79
 |  |  |  | [NAME] |  | 10 |  |  | 13.58
 |  |  |  | [NAME] |  | 13.58
 |  |  |  |  |  | 10
 |  |  |  | pet shop |  | 21.44
 |  |  |  | hm |  | 71.96
 |  |  |  | tk |  | 18.18
 |  |  |  | magnolia |  | 27.95
 |  |  |  | xx | xx | xx | xx | xx
 |  |  |  |  | Totals
 |  |  |  |  | After Bills |  |  | After Bills
 |  |  |  |  | To Gavin |  |  | To Jack
 |  |  |  |  | Transfer to Gavin |  | Transfer to [NAME]
Spreadsheet: 80759d1280952598-formula-errors-when-using-set-bounds-mock-spreadsheet-for-help
Sheet: Payout Totals

Name | Level | Friday [NAME] | Saturday Attendance | Sunday Attendance | Total Pay |  | Money Earned | 0
 |  |  |  |  |  |  | Money Set Aside | 0
 |  |  |  |  |  |  | Total Pay for Friday | 0
 |  |  |  |  |  |  | Total Pay for Saturday | 0
 |  |  |  |  |  |  | Total Pay for Sunday | 0
 |  |  |  |  |  |  | Base pay for Friday
 |  |  |  |  |  |  | Base pay for Saturday
 |  |  |  |  |  |  | Base pay for Sunday
Spreadsheet: 709798d1608563354-calculating-total-time-sample
Sheet: Sheet1

Appointment Date | Appointment Start Time | Appointment End Time | Appointment Duration (in mins) |  |  |  | Results
12/31/20 | 4:00:00 PM | 16:30:00 | 30 |  |  |  | Date | Range | Availability
12/31/20 | 4:15:00 PM | 16:45:00 | 30 |  |  |  | 12/31/20 | 4:00 PM - 5:00 PM | 60 minutes
12/31/20 | 4:30:00 PM | 17:00:00 | 30 |  |  |  | 01/07/21 | 3:00 PM - 4:00 PM | 60 minutes
01/07/21 | 3:00:00 PM | 15:30:00 | 30 |  |  |  | 01/14/21 | 10:00 AM - 11:00 AM | 30 minutes
01/07/21 | 3:15:00 PM | 15:45:00 | 30 |  |  |  | 01/14/21 | 2:00 PM - 3:00 PM | 45 minutes
01/07/21 | 3:30:00 PM | 16:00:00 | 30
01/07/21 | 3:45:00 PM | 16:15:00 | 30
01/14/21 | 10:30:00 AM | 11:00:00 | 30
01/14/21 | 11:15:00 AM | 11:45:00 | 30
01/14/21 | 2:15:00 PM | 14:45:00 | 30
01/14/21 | 2:30:00 PM | 15:00:00 | 30
01/14/21 | 2:45:00 PM | 15:15:00 | 30
01/14/21 | 3:00:00 PM | 15:30:00 | 30
01/14/21 | 4:00:00 PM | 16:30:00 | 30
01/14/21 | 4:15:00 PM | 16:45:00 | 30
01/21/21 | 1:45:00 PM | 14:15:00 | 30
01/21/21 | 2:00:00 PM | 14:30:00 | 30
01/21/21 | 2:15:00 PM | 14:45:00 | 30
01/21/21 | 2:30:00 PM | 15:00:00 | 30
01/21/21 | 2:45:00 PM | 15:15:00 | 30
01/21/21 | 3:45:00 PM | 16:15:00 | 30
01/21/21 | 4:00:00 PM | 16:30:00 | 30
01/21/21 | 4:15:00 PM | 16:45:00 | 30
01/21/21 | 4:30:00 PM | 17:00:00 | 30
Spreadsheet: 1726fd9d-53cf-45f8-a948-ac522262a057
Sheet: Sheet1

Table 6--Wholesale corn milling product and byproduct prices, 8/14/2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Mkt year and month 1/ | Corn meal, yellow,  Chicago, IL (dollars per cwt) |  | Corn meal, yellow,  New York, NY (dollars per cwt) |  | Corn starch,  Midwest 3/ (dollars per cwt) |  | Dextrose,  Midwest (cents per pound) |  | High-fructose corn syrup (42%),  Midwest (cents per pound)
 | 2010/11 | 2011/12 | 2010/11 | 2011/12 | 2010/11 | 2011/12 | 2010/11 | 2011/12 | 2010/11 | 2011/12
Sep | 20.339 | 27.9925 | 22.644 | 30.2975 | 15.43 | 23.25999999999999 | 31.2 | 30.85 | 17.375 | 21.375
Oct | 22.42 | 26.7825 | 24.725 | 29.0875 | 16.87 | 22.62999999999999 | 30.85 | 30.85 | 20.375 | 21.375
Nov | 22.435 | 26.8975 | 24.74 | 29.2025 | 18.28 | 20.04999999999999 | 30.85 | 30.85 | 21.375 | 21.375
Dec | 23.125 | 25.74 | 25.43 | 28.045 | 18.61 | 20.88999999999999 | 30.85 | 30.85 | 21.375 | 21.375
Jan | 24.0375 | 24.855 | 24.29 | 26.555 | 18.94 | 19.89999999999999 | 30.85 | 34.85 | 21.375 | 23.375
Feb | 26.94625 | 26.39833333333333 | 29.25125 | 30.37 | 20.23 | 21.39999999999999 | 30.85 | 33.85 | 21.375 | 23.375
Mar | 27.51 | 26.1675 | 29.815 | 27.92 | 21.48999999999999 | 21.78999999999999 | 30.85 | 35.85 | 21.375 | 23.375
Apr | 28.47125 | 25.5175 | 30.77625 | 27.545 | 21.31 | 22.08999999999999 | 30.85 | 34.85 | 21.375 | 23.375
May | 27.48833333333333 | 24.485 | 29.79333333333333 | 26.7675 | 22.72 | 21.33999999999999 | 30.85 | 34.85 | 21.375 | 23.375
Jun | 27.465 | 24.295 | 29.77 | 25.995 | 22.56999999999999 | 21.24999999999999 | 30.85 | 34.85 | 21.375 | 23.375
Jul | 28.24 | 28.345 | 30.545 | 30.045 | 23.31999999999999 | 20.64999999999999 | 30.85 | 35.35 | 21.375 | 23.375
Aug | 28.775 |  | 31.08 |  | 22.14999999999999 |  | 30.85 |  | 21.375
Mkt year 2/ | 25.60436111111111 |  | 27.73831944444444 |  | 20.16 |  | 30.87916666666667 |  | 20.95833333333333
1/ September-August. Latest month is preliminary. 2/ Simple average of monthly prices for the marketing year. 3/ Bulk-industrial, unmodified. Source: Milling and Baking News, except for corn starch which is from private industry.
Date run: 8/12/2012