tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 870792d1717233033-sumifs-substitute-2d_spill-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Women
Country X | Bolly
Country X | Pumpkin |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 984
Country X | Chicken |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9582
Country X | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 654
Country X | Apple |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50263
Country X | Mango |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.136
Country X | Tumbaktu |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Country X | Rhodoendron |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25
Country X | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3310
Country X | Pure |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3575
Country X
Country X Total | Total XXXXX
Country Y | Bolly |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 120
Country Y | Pumpkin |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1940
Country Y | Chicken |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11541
Country Y | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57
Country Y | Apple |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3100
Country Y | Mango |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 82
Country Y | Tumbaktu |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Country Y | Rhodoendron |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38021
Country Y | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2083
Country Y | Pure |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1321
Country Y
Country Y Total | Total XXXXX
Spreadsheet: 130dd96f-5b86-46b4-9358-2f046c953f79
Sheet: Sheet1

Table 1--Wheat: U.S. market year supply and disappearance, 9/14/2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Item and unit |  |  | 2006/07 | 2007/08 | 2008/09 | 2009/10 | 2010/11 | 2011/12 | 2012/13
 | Area: Planted | Million acres | 57.3 | 60.5 | 63.2 | 59.2 | 53.6 | 54.4 | 56.0
 | Harvested | Million acres | 46.8 | 51.0 | 55.7 | 49.9 | 47.6 | 45.7 | 48.8
 | Yield | Bushels per acre | 38.6 | 40.2 | 44.9 | 44.5 | 46.3 | 43.7 | 46.5
 | Supply: Beginning stocks | Million bushels | 571.2 | 456.2 | 305.8 | 656.5 | 975.6 | 862.2 | 742.7
 | Production | Million bushels | 1,808.4 | 2,051.1 | 2,499.2 | 2,218.1 | 2,206.9 | 1,999.3 | 2,268.2
 | Imports 1/ | Million bushels | 121.9 | 112.6 | 127.0 | 118.6 | 96.9 | 112.1 | 130.0
 | Total supply | Million bushels | 2,501.5 | 2,619.9 | 2,932.0 | 2,993.2 | 3,279.5 | 2,973.7 | 3,141.0
 | Disappearance: Food use | Million bushels | 937.9 | 947.9 | 926.8 | 918.9 | 925.6 | 941.4 | 950.0
 | Seed use | Million bushels | 81.9 | 87.6 | 78.0 | 69.5 | 70.9 | 76.8 | 73.0
 | Feed and residual use | Million bushels | 117.1 | 16.0 | 255.2 | 149.9 | 131.9 | 163.2 | 220.0
 | Total domestic use | Million bushels | 1,136.8 | 1,051.4 | 1,260.0 | 1,138.2 | 1,128.4 | 1,181.4 | 1,243.0
 | Exports 1/ | Million bushels | 908.5 | 1,262.6 | 1,015.4 | 879.3 | 1,288.8 | 1,049.5 | 1,200.0
 | Total disapperance | Million bushels | 2,045.3 | 2,314.1 | 2,275.4 | 2,017.5 | 2,417.2 | 2,230.9 | 2,443.0
 | Ending stocks | Million bushels | 456.2 | 305.8 | 656.5 | 975.6 | 862.2 | 742.7 | 698.0
 | CCC inventory 2/ | Million bushels | 41.0
 | Stocks-to-use ratio |  | 22.3 | 13.2 | 28.9 | 48.4 | 35.7 | 33.3 | 28.6
 | Loan rate | Dollars per bushel | 2.75 | 2.75 | 2.75 | 2.75 | 2.94 | 2.94 | 2.94
 | Contract/direct payment rate | Dollars per bushel | 0.52 | 0.52 | 0.52 | 0.52 | 0.52 | 0.52 | 0.52
 | Farm price 3/ | Dollars per bushel | 4.26 | 6.48 | 6.78 | 4.87 | 5.70 | 7.24 | 7.50-8.70
 | Government payments | Million dollars | 1,120 | 1,118
 | Market value of production | Million dollars | 7,695 | 13,289 | 16,626 | 10,654 | 12,827 | 14,475 | 18,373
Latest market year is projected; previous market year is estimated. Totals may not add due to rounding. 1/ Includes flour and selected other products expressed in grain-equivalent bushels. 2/ Stocks owned by USDA's Commodity Credit Corporation (CCC). Most CCC-owned inventory is in the Bill Emerson Humanitarian Trust.
3/ U.S. season-average price based on monthly prices weighted by monthly marketings. Prices do not include an allowance for loans outstanding and government purchases. Source: USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates and supporting materials.
Date run: 9/17/2012
Spreadsheet: 212558d1360166108-change-cell-color-when-cell-value-matches-a-listing-of-cells-drf1
Sheet: Sheet1

POWERBALL CHECKER
Winning Numbers
1 | 2 | 6 | 30 | 31 | 10
Your Numbers
33 | 6 | 33 | 12 | 5 | 8 |  | cf in a7 copied to a1:e51
36 | 12 | 38 | 27 | 12 | 10
16 | 49 | 26 | 23 | 32 | 1
43 | 13 | 5 | 8 | 21 | 2 |  | cf in f7 copied to  f7:f51
47 | 10 | 33 | 24 | 33 | 1 |  | is
29 | 29 | 40 | 17 | 47 | 2 |  | cell value equal to  =$f$4
26 | 41 | 19 | 2 | 4 | 10
15 | 33 | 17 | 23 | 14 | 1 |  | look in conditional format manage rules to see it
29 | 42 | 14 | 21 | 20 | 5
34 | 36 | 44 | 30 | 26 | 5
11 | 32 | 33 | 5 | 6 | 4
13 | 4 | 7 | 8 | 37 | 9
25 | 9 | 18 | 49 | 5 | 10
14 | 47 | 3 | 46 | 45 | 3
11 | 10 | 32 | 23 | 39 | 1
7 | 42 | 8 | 13 | 48 | 4
31 | 14 | 43 | 23 | 16 | 8
37 | 16 | 41 | 25 | 3 | 4
35 | 16 | 49 | 39 | 25 | 4
15 | 11 | 6 | 8 | 22 | 3
14 | 16 | 47 | 34 | 4 | 1
41 | 6 | 42 | 23 | 37 | 5
41 | 44 | 7 | 25 | 12 | 4
4 | 28 | 20 | 29 | 26 | 8
43 | 11 | 44 | 20 | 32 | 3
33 | 9 | 42 | 47 | 41 | 3
48 | 41 | 45 | 33 | 45 | 5
42 | 47 | 30 | 28 | 19 | 5
23 | 36 | 3 | 21 | 42 | 3
44 | 8 | 39 | 41 | 32 | 8
36 | 19 | 5 | 31 | 43 | 7
30 | 20 | 47 | 20 | 24 | 7
41 | 1 | 28 | 46 | 47 | 3
25 | 13 | 37 | 15 | 46 | 7
5 | 48 | 28 | 16 | 19 | 7
27 | 36 | 1 | 35 | 43 | 2
38 | 49 | 36 | 33 | 16 | 7
20 | 3 | 8 | 16 | 38 | 5
46 | 9 | 9 | 47 | 14 | 2
23 | 35 | 26 | 40 | 46 | 6
16 | 19 | 8 | 19 | 38 | 1
27 | 43 | 44 | 11 | 23 | 6
22 | 15 | 43 | 15 | 43 | 1
29 | 48 | 22 | 30 | 36 | 1
22 | 42 | 7 | 47 | 43 | 2
Spreadsheet: benjamin_rogers__1306__site_visit_schedule for Jeff Keenan
Sheet: Confirm - PECO

 |  | Company | PECO Energy
 |  | Company Contact & Number | [NAME](610) 765-5925
 |  | Site or Sites | Wheatland
 |  | Site Visit Date | Tuesday October 24th
 |  | Directions to Hotels/Site | See DealBench - Due Diligence List/Plant Pictures Section
 |  | Meeting Time/Place | Tuesday Morning
 |  |  | 480 North Hall Road
 |  |  | Wheatland, Indiana
 |  | Enron Site Visit Coordinator | [NAME]
 |  |  | Work: (713) 345-3364 / (713) 858-8262
 |  |  | [NAME]
 |  |  | Work: (713) 853-4205  Cell: (713) 851-6810
 |  |  | Wheatland - [NAME] (Plant Manager)
 |  |  | Work (812) 321-2510
 |  | Company Site Visit Team
Spreadsheet: 275063d1383320822-count-unique-ids-unique-id
Sheet: Unique ID'S

Date | ID
2013-10-28 00:00:00 | 1
2013-10-28 00:00:00 | 2
2013-10-28 00:00:00 | 3 |  |  |  | Unique ID total:
2013-10-28 00:00:00 | 4 |  |  |  | Unique ID 28.10:
2013-10-29 00:00:00 | 5 |  |  |  | Unique ID 29.10:
2013-10-29 00:00:00 | 5 |  |  |  | Unique ID 30.10:
2013-10-29 00:00:00 | 5
2013-10-29 00:00:00 | 6
2013-10-29 00:00:00 | 7
2013-10-29 00:00:00 | 7
2013-10-29 00:00:00 | 8
2013-10-30 00:00:00 | 9
Spreadsheet: 236659d1368912124-display-daily-shift-from-monthly-schedule-on-another-sheet-practice-schedule
Sheet: Monthly Schedule

13 |  |  | JUN/JULY 2013
UPDATED |  |  | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14
Name |  |  | S | S | M | T | W | H | F | S | S | M | T | W | H | F | S | S | M | T | W | H | F | S | S | M | T | W | H | F | S | S
 | [NAME] |  | CSA |  | 1 | A | 1 | C |  |  |  | C |  | 1 | 1 | 1 |  | CSU |  | 1 |  | C |  |  |  | 1 | 1 | 1 | 1 | 1
 | [NAME] |  |  | CSU |  | 1 | LV | LV | LV | LV | LV | 1 | TDY | TDY | TDY | TDY |  |  | 1 | 1 | 1 |  | CF |  |  | C |  | 1 | 1 | CF
 | [NAME]
 | [NAME] |  | TL | TL | TL | TL | TL | TL | TL | TL | TL | TL | TL | TL | TL | TL | TL | TL | TL | TL | TL | TL | TL | TL | TL
 | [NAME]
 | [NAME] |  | TDY | TDY | LV | LV | LV | LV | LV |  | CSU |  | 1 | 1 | 1 | CF |  |  | 1 | 1 | C |  |  |  |  | 1 | C |  | 1 | 1
 | Greg |  |  |  | C |  | 1 | 1 | 1 | TOR | TOR | 1 | 1 | 1 | 1 | 1 | CSA |  | 1 | C |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | CSA
 | [NAME]
 | [NAME] |  |  |  | 1 | C |  | 1 | 1 | CSA |  | 1 | 1 | 1 | C |  |  |  | C |  | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  | CSU
Spreadsheet: 85836d1285864994-a-complicated-sort-sotest
Sheet: Result

Desired Output: |  |  |  | Debit | Credit
Sale Number: 9977 | Customer: Special, Nobody | Recorded Sale Date: 01/20/2010 12:00:00 AM | 1451-20 |  | 110
Sale Number: 9977 | Customer: Special, Nobody | Recorded Sale Date: 01/20/2010 12:00:00 AM | 4251-10 |  | 5.5
Sale Number: 9977 | Customer: Special, Nobody | Recorded Sale Date: 01/20/2010 12:00:00 AM | 1451-50 |  | 80
Sale Number: 9977 | Customer: Special, Nobody | Recorded Sale Date: 01/20/2010 12:00:00 AM | 4251-10 |  | 16.1
Sale Number: 9977 | Customer: Special, Nobody | Recorded Sale Date: 01/20/2010 12:00:00 AM | 1451-10 |  | 242
Sale Number: 9977 | Customer: Special, Nobody | Recorded Sale Date: 01/20/2010 12:00:00 AM | 1451-50 |  | 37
Sale Number: 9977 | Customer: Special, Nobody | Recorded Sale Date: 01/20/2010 12:00:00 AM | 1451-30 |  | 108
Sale Number: 9977 | Customer: Special, Nobody | Recorded Sale Date: 01/20/2010 12:00:00 AM | 4251-10 |  | 7.25
Sale Number: 9978 | Customer: Doe, [NAME] | Recorded Sale Date: 01/20/2010 12:00:00 AM | 1451-30 |  | 108
Sale Number: 9978 | Customer: Doe, [NAME] | Recorded Sale Date: 01/20/2010 12:00:00 AM | 4251-10 |  | 5.4
Sale Number: 9979 | Customer: [NAME], [NAME] | Recorded Sale Date: 01/22/2010 12:00:00 AM | 4290-11 | 200
Sale Number: 9979 | Customer: [NAME], [NAME] | Recorded Sale Date: 01/22/2010 12:00:00 AM | 1451-20 |  | 200
Sale Number: 9980 | Customer: [NAME], [NAME] | Recorded Sale Date: 01/22/2010 12:00:00 AM | 4290-11 | 200
Sale Number: 9980 | Customer: [NAME], [NAME] | Recorded Sale Date: 01/22/2010 12:00:00 AM | 1451-20 |  | 200
 |  |  |  | *Note that the numbers for 'debit' on the other sheet are actually in row C but the title is in row D
Spreadsheet: phillip_m_love__30086__aaaCredit Report
Sheet: Sheet1

DEAL ORIGINATION REPORT
Deals Input on 3/27/01
PENDING CREDIT ITEMS
Counterparty | Deal Number | Deal Type | Comm | Contact/Action Needed
Diamond Shamrock Refining & Marketing | QZ5185.1 | F | NG | Brant Reves
Hall-Houston Oil Company | QZ6108.1 | F | NG | [NAME]
Ledco, LLC | QZ4390.1 | F | NG | [NAME]
Linder Energy Company | QZ6154.1 | F | NG | Credit Previously Provided
Louisiana General Oil Company | QZ6154.2 | F | NG | Credit Previously Provided
Jonan Gas Marketing Ltd. | QZ3007.1 | P | NG | [NAME]
Millenium Fibers Inc. | QZ5837.1 | P | OCC | [NAME]
Mississippi Valley Gas Company | QZ3393.1 | P | NG | [NAME]
Municipal Gas Authority of Georgia | QZ2053.2 QZ5961.1 | P | NG | [NAME]
NGL Supply, Inc. dba Premier Energy | QZ4933.1 | F | C3GC | Credit Previously Provided
National Fuel Marketing Company | QZ2894.1 | P | NG | Letter of Credit Required
New Counterparty | QZ5222.1 | F | NG | [NAME]
New Counterparty | QZ5676.1 | P | OCC | [NAME]
New Counterparty | QZ5763.1 | P | OCC | [NAME]
New Counterparty | QZ3989.1 | P | NG | [NAME]
PG&E Core | QZ4072.1 QZ4074.1 QZ4727.1 QZ4752.1 QZ5637.1 QZ5640.1 | F | NG | [NAME]
PG&E Energy Trading-Gas Corp. | QZ4373.1 | F | NG | [NAME]
Pacific Gas & Electric Company | QZ6399.1 | F | NG | [NAME]
Peltz Group, Inc. | QZ3191.1 | P | OCC | [NAME]
Pioneer Energy Marketing Company | QZ4408.1 | F | NG | [NAME]
Shoreline Gas Inc. | QZ4069.1 | P | NG | [NAME]
Smith Barney AAA Fund | QZ5215.1 | F | NG | [NAME]
Southern Company Services, Inc. | QZ4992.1 | F | 61NY | Brant Reves
Summit Natural  Gas, LLP | [NAME] | P | NG | [NAME]
Terra Industries, Inc. | QZ6143.1/2 | F | NG | [NAME]
Terra Resources, Inc. | QZ5942.1 | P | NG | [NAME]
Texakota Oil Company | QZ4041.1/2 | P | NG | [NAME]
The Fiber Resource Group, Inc. | QZ2325.1 | P | NBSK | [NAME]
Tidewater Fibre Corp. | QZ2472.1 QZ3566.1 | P | ONP/OCC | [NAME]
Ultramar Inc. | QZ4794.1 QZ4014.1 | F | NG | [NAME]
Weirton Steel Corporation | QZ2383.1 | P | NG | [NAME]
REBOOK ITEMS
Counterparty | Deal Number | Deal Type | Comm | Rebook To--
Aquila Energy Marketing Corporation | QZ4290.1/2 QZ4366.1/2 | F | NG | Aquila Risk Management Corp.
Louis Dreyfus Natural Gas Holdings | QZ5188.1 QZ5189.1 QZ5223.1 | F | NG | Louis Dreyfus Natural Gas Corp.
PanCanadian Energy Inc. | QZ3705.1 | F | NG | PanCanadian Energy Services Inc.
Richardon Products Company | QZ5093.1 QZ5098.1 | F | NG | Richardson Products II, Ltd.
Total Energy Company Ltd. | QZ4592.1 | P | NG | TotalFinaElf Gas & Power North America
TransCanada Energy Financial Products | QZ5208.1 QZ5209.1 | F | NG | TransCanada Energy Financial Products
Unocal Energy Trading, Inc. | QZ3511.1 QZ5224.1 | F | NG | Union Oil Company of California
Utilicorp United Inc. | QZ6419.1 | F | NG | Aquila Risk Management Corp.
Spreadsheet: gerald_nemec__11310__Bay2-23termsheet
Sheet: Cost of Service

Customer Cost of Service Analysis |  |  |  |  | Enron Price Premises
$000, except per unit
ASSUMPTIONS |  |  | GAS | ELECTRIC
Capacity - (HP)  x 1000
Heat Rate (Btu/HP-HR)
On Peak Hours
Off-Peak Hours
Average Load Factor
Term
Capital Cost
Maintenance - ($/HP-Yr)
Annual O&M Expense
Annual Charge |  |  | 0
Lease Income to Customer |  |  | 0
Ad Valorem Tax Rate
Discount Rate |  |  | 0.1 | 0.1
Escalation |  |  | 0 | 0
 |  |  | Today's Date |  | 1
 |  | Mid-Year Convention
COST OF SERVICE
 | FGT Z3 Delivery Point | as of 12/07/00
Cost of Service - Gas
Investment |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Ad Valorem Tax |  |  |  | 0
Fuel Opportunity Value (gas burned) |  |  |  | 0
O&M Expense |  |  |  | 0
 |  | Total Annual COS | 0
 | Annual Hp*hrs = |  |  | $/Hp*hr =
 | Annual Load Factor =
Cost of Service -  Electric
Lease Income from ECS
Investment |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Ad Valorem Tax |  |  |  | 0
Fuel Opportunity Value (gas burned) |  |  |  | 0
O&M Expense (included in Annual Charge) |  |  |  | 0 | 0
Annual Charge |  |  |  | 0
 |  | Total Annual COS | 0
 |  |  |  | $/Hp*hr =
 |  | Savings per Year
Project Matrix (NPV) |  |  | Gas COS | Electric COS | Savings
Discount Rate
10-Year Value to Customer
15-Year Value to Customer
20-Year Value to Customer
Project Matrix - NPV of $/MMCFD of injection volume
10-Year NPV/(Consumed Hp*hr x 70.25 hp/mmcfd)
15-Year NPV/(Consumed Hp*hr x 70.25 hp/mmcfd)
20-Year NPV/(Consumed Hp*hr x 70.25 hp/mmcfd)
Spreadsheet: 169451d1342857832-conditional-formatting-for-staff-roster-enhanced-staff-roster-2-
Sheet: Roster

 | Weekly Schedule |  |  |  |  |  |  |  | Weekly Schedule
Staff | 1 | 2 | 3 | 4 | 5 | 6 | 7 |  | 8 | 9 | 10 | 11 | 12 | 13 | 14 |  | 15 | 16 | 17 | 18 | 19 | 20 | 21 |  | 22 | 23 | 24 | 25 | 26 | 27 | 28 |  | 29 | 30 | 31
 | Mon | Tue | Wed | Thu | Fri | Sat | Sun |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun
Goldie | E | M | E | M | E | M | D |  | DO | N | N | N | N | M | E |  | D | O | E | DO | D | E | N |  | N | N | SD | E | D | E | DO |  | E | N | N
[NAME] | N | N | E | E | M | DO | E |  | E | MR | DO | M | E | E | N |  | D | E | D | DO | E | N | N |  | N | SD | D | DO | E | D | E |  | N | N | N
[NAME] | E | E | M | DO | DR | M | M |  | O | E | E | M | M | N | N |  | DO | N | N | N | SD | D | E |  | D | E | DO | N | N | N | SD |  | M | D | DO
[NAME] | N | SD | DO | N | N | N | SD |  | D | MR | DO | M | M | E | M |  | E | DO | E | D | N | N | N |  | SD | DO | N | N | N | SD | D |  | E | DO | N
Sheryl | SD | DO | D | M | E | E | M |  | M | D | N | N | N | E | DO |  | N | N | N | SD | D | DO | E |  | D | E | M | D | DO | O | N |  | N | N | SD
 | D=6am-2pm |  |  | E=2pm-9pm |  | N=8.30pm-8am |  |  | D=6am-2pm |  |  | E=2pm-9pm |  | N=8.30pm-8am
 | SD=Sleeping Day |  |  | DO=Day Off |  | O=Others |  |  | SD=Sleeping Day |  |  | DO=Day Off |  | O=Others
 | M=7am-2.30pm |  |  |  |  |  |  |  | M=7am-2.30pm
 |  |  |  |  |  |  |  | If adjacent cell (B4:D4) has 3 consecutive "N", and E4=SD. OK
 | This is a staff roster
1 |  | If any row has 3 consecutive "N",  the next cell must ="SD", otherwise conditional format the whole row to RED
 |  | Eg: [NAME] - must have a "SD" on the 2nd as he did duty on 30th & 31st of the previous month
 |  | Eg: [NAME] - must have a "SD" on the 3rd as he did duty on 31st of the previous month and 1st and 2nd of current month
2 |  | If "DO" does not appear once in any row (eg J6:P6), conditional format the whole row (J6:P6) to red
Spreadsheet: 186176d1349950905-sla-spreadsheet-calculate-ticket-times
Sheet: Sheet1

End Time Date | Start Time/Date | Business Hours |  | Day | Start | End | Hrs in Day
2012-08-01 09:34:11 | 2012-08-01 13:09:21 |  |  | 1900-01-01 00:00:00 | 09:00:00 | 17:30:00
2012-08-01 08:27:50 | 2012-08-06 08:54:03 |  |  | 1900-01-02 00:00:00 | 08:30:00 | 18:30:00
2012-08-01 08:27:50 | 2012-08-06 08:54:03 |  |  | 1900-01-03 00:00:00 | 08:30:00 | 18:30:00
2012-08-01 08:30:25 | 2012-08-01 09:06:17 |  |  | 1900-01-04 00:00:00 | 08:30:00 | 18:30:00
2012-08-01 08:32:03 | 2012-08-01 11:31:59 |  |  | 1900-01-05 00:00:00 | 08:30:00 | 18:30:00
2012-08-01 08:52:38 | 2012-08-01 09:46:18 |  |  | 1900-01-06 00:00:00 | 08:30:00 | 18:30:00
2012-08-01 08:53:58 | 2012-08-01 13:41:30 |  |  | 1900-01-07 00:00:00 | 08:30:00 | 17:30:00
2012-08-01 09:13:13 | 2012-08-01 09:14:10
2012-08-01 09:18:55 | 2012-08-02 10:23:36
2012-08-01 09:31:36 | 2012-08-01 09:31:49
2012-08-01 09:34:11 | 2012-08-01 13:09:21
Spreadsheet: 768869d1645181006-a-formula-to-rank-in-descendant-order-if-it-is-greater-than-another-cell-value-rank-if-greater-than-another-cell-value
Sheet: Sheet1

 |  | 2
[NAME] | 4 |  | [NAME]
[NAME] | 4 |  | [NAME]
[NAME] | 2 |  | [NAME]
[NAME] | 2 |  | [NAME]
[NAME] | 5 |  | [NAME]
Sandy | 1 |  | [NAME]
[NAME] | 0 |  | [NAME]
[NAME] | 3
[NAME] | 5
Spreadsheet: 703974d1605278339-if-data-in-colmun-a-is-true-it-counts-data-in-column-d-working
Sheet: Sheet1

[NAME] | Last Name | First Name | Appt Made Date
5N1B | SMITH | TOM | 2020-10-28 16:30:00
5N1B | JONES | MIKE
5N1C | THOMPSON | FRED
5N1C | THOMAS | SARAH
5N1C | BAR | MIKE
5N1D | FLINTSTON | FRED | 2020-10-27 11:58:00
5N1D | RUBBLE | BARNEY | 2020-11-10 15:36:00
5N1D | BANNON | STEVE
5N1D | SANDERS | SARAH
5N1J | CLINTON | WILLIAM | 2020-10-29 11:55:00
5N1J | BINDEN | [NAME] | 2020-10-13 10:02:00
5N1J | [NAME] | [NAME] | 2020-10-06 14:59:00
Spreadsheet: b9c87429-5cfc-4548-9dcd-8d7bf0de0d73
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
44495039 | 2014-12-18 13:10:23 | AXIS | 0 | 3 | 5 | 417473 | aikobo | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
Spreadsheet: darrell_schoolcraft__7414__imball0201
Sheet: PEPL

 | Hansford
 | 8042
Day | Measured | Scheduled
1 | -175
2
3 |  | -2000
4
5 |  | -16528
6 | -31547 | -16528
7 | -17414 | -16528
8 | -10189 | -10500
9 | -17552 | -15935
10 | -9962 | -15500
11 | -70735 | -71187
12 | -58208 | -59296
13 | -57826 | -59296
14 | -57796 | -59296
15 | -24830 | -25514
16 | -29576 | -21882
17 | -28848 | -30000
18 | -53049 | -55009
19 | -42986 | -43709
20 | -42941 | -43709
21 | -42980 | -43709
22 | -16682 | -7709
23
24 |  | -305
25 | -4405 | -3000
26
27
28
29 | -29998 | -19327
30
31
2001-12-31 00:00:00 |  |  | -14315
2002-01-29 00:00:00
CBS Dollars
 |  |  | 163235
Spreadsheet: 838380d1690975347-pairing-variables-and-coding-the-output-sample-dataset-v4-solution-1-
Sheet: Sheet02

Transaction No | Customer ID | Date (DD/MM/YYYY) | Apple | Pepper | [NAME] | Blueberry | [NAME] | [NAME] | Peach | Grape
1 | 111181 | 2021-08-20 00:00:00
2 | 111182 | 2021-08-20 00:00:00
3 | 111203 | 2021-08-23 00:00:00
4 | 111111 | 2021-08-16 00:00:00
5 | 111143 | 2021-08-13 00:00:00 |  |  |  |  |  |  |  |  |  |  | Data Legend
6 | 111112 | 2021-08-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | Label | Coding
7 | 111151 | 2021-08-16 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME] | 1
8 | 111192 | 2021-08-22 00:00:00 |  |  |  |  |  |  |  |  |  |  | Red Apple | 2
9 | 111158 | 2021-08-17 00:00:00 |  |  |  |  |  |  |  |  |  |  | Green Pepper | 3
10 | 111111 | 2021-08-09 00:00:00 |  |  |  |  |  |  |  |  |  |  | Red Pepper | 4
11 | 111116 | 2021-08-02 00:00:00 |  |  |  |  |  |  |  |  |  |  | Orange Pepper | 5
12 | 111112 | 2021-08-17 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME] | 6
13 | 111122 | 2021-08-07 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME] | 7
14 | 111128 | 2021-08-10 00:00:00 |  |  |  |  |  |  |  |  |  |  | Blueberry | 8
15 | 111181 | 2021-08-21 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME] | 9
16 | 111136 | 2021-08-11 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME] | 10
17 | 111133 | 2021-08-20 00:00:00 |  |  |  |  |  |  |  |  |  |  | Peach | 11
18 | 111177 | 2021-08-19 00:00:00 |  |  |  |  |  |  |  |  |  |  | Grape | 13
19 | 111209 | 2021-08-28 00:00:00
20 | 111191 | 2021-08-23 00:00:00
21 | 111119 | 2021-08-05 00:00:00
22 | 111111 | 2021-08-01 00:00:00
23 | 111133 | 2021-08-11 00:00:00
24 | 111112 | 2021-08-16 00:00:00
25 | 111114 | 2021-08-02 00:00:00
26 | 111209 | 2021-08-29 00:00:00
27 | 111136 | 2021-08-11 00:00:00
28 | 111187 | 2021-08-20 00:00:00
29 | 111171 | 2021-08-19 00:00:00
30 | 111209 | 2021-08-30 00:00:00
31 | 111204 | 2021-08-23 00:00:00
32 | 111206 | 2021-08-24 00:00:00
33 | 111197 | 2021-08-22 00:00:00
34 | 111194 | 2021-08-22 00:00:00
35 | 111162 | 2021-08-18 00:00:00
36 | 111167 | 2021-08-18 00:00:00
37 | 111155 | 2021-08-17 00:00:00
38 | 111165 | 2021-08-18 00:00:00
39 | 111173 | 2021-08-19 00:00:00
40 | 111203 | 2021-08-23 00:00:00
Spreadsheet: 219409d1362752629-formula-for-selecting-value-in-cell-using-multiple-criteria-example
Sheet: Duration Summary

Day | Date | Time | Room 001 | Bry 002 | etc..
Mon | 2013-02-18 00:00:00 | 09:00:00
 |  | 10:00:00
 |  | 11:00:00
 |  | 12:00:00
 |  | 13:00:00
 |  | 14:00:00
 |  | 15:00:00
 |  | 16:00:00
[NAME] | 2013-02-19 00:00:00 | 09:00:00
 |  | 10:00:00
 |  | 11:00:00
 |  | 12:00:00
 |  | 13:00:00
 |  | 14:00:00
 |  | 15:00:00
 |  | 16:00:00
Weds | 2013-02-20 00:00:00 | 09:00:00
 |  | 10:00:00
 |  | 11:00:00
 |  | 12:00:00
 |  | 13:00:00
 |  | 14:00:00
 |  | 15:00:00
 |  | 16:00:00
Thurs | 2013-02-21 00:00:00 | 09:00:00
 |  | 10:00:00
 |  | 11:00:00
 |  | 12:00:00
 |  | 13:00:00
 |  | 14:00:00
 |  | 15:00:00
 |  | 16:00:00
Fri | 2013-02-22 00:00:00 | 09:00:00
 |  | 10:00:00
 |  | 11:00:00
 |  | 12:00:00
 |  | 13:00:00
 |  | 14:00:00
 |  | 15:00:00
 |  | 16:00:00
Spreadsheet: 14230806-3e62-4a63-a4eb-32e8b9dfd495
Sheet: Sheet1

[NAME] Cost Calculator | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | Two Quick Conversions | Enter Below | Ounces
 |  | Liters to Ounces: | 10 | 338.1
 |  | [NAME] to Ounces: | 10 | 1537
 |  |  | Only enter numerical amounts (e.g. 65.35 or 3.00)
 |  |  | Enter vendor quoted price: | 22
 |  |  | Enter the total number of ounces you will be getting for that price: | 128
 |  |  | Enter the ounce(s) of product added to a gallon of  water: | 0.25
 |  |  | For less than an ounce per gallon... ¼,½, or ¾ , enter .25, .5, or .75…..
Your washing or mopping solution will cost you 4.3 ¢ per gallon.
You will be able to make up 512 gallons of washing/mopping solution.
[NAME] has a detailed floor finish cost evaluation analysis…
Call us for Cost Evaluation details.
Gabriel First Corp. - East Rochester, NY 14445-0191 - [PHONE] - [PHONE]
www.gabrielfirst.com - [EMAIL] - FAX: [PHONE]