tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 9cb7c880-3ac1-41f9-ba97-4dc1d836ebb9
Sheet: Sheet1

Release: BEA Regions Housing Units Authorized By Building Permits | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=173
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2013-06-19 2:41 AM [NAME]
 | Real-Time | Period
Name: | Start | End
BEA Regions Housing Units Authorized By Building Permits | 2008-07-25 00:00:00 | Current
Link:
http://www.census.gov/const/www/permitsindex.html | 2008-07-25 00:00:00 | Current
Source:
Federal Reserve Bank of St. Louis | 2008-07-25 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2008-07-25 00:00:00
2008-08-26 00:00:00
2008-09-25 00:00:00
2008-10-27 00:00:00
2008-11-26 00:00:00
2008-12-23 00:00:00
2009-01-29 00:00:00
2009-02-26 00:00:00
2009-03-25 00:00:00
2009-04-24 00:00:00
2009-05-27 00:00:00
2009-06-24 00:00:00
2009-07-27 00:00:00
2009-08-26 00:00:00
2009-09-25 00:00:00
2009-10-27 00:00:00
2009-11-25 00:00:00
2009-12-23 00:00:00
2010-01-28 00:00:00
2010-02-25 00:00:00
2010-03-24 00:00:00
2010-04-26 00:00:00
2010-05-26 00:00:00
2010-06-24 00:00:00
2010-07-27 00:00:00
2010-08-25 00:00:00
2010-09-27 00:00:00
2010-10-27 00:00:00
2010-11-24 00:00:00
2010-12-23 00:00:00
2011-01-27 00:00:00
2011-02-25 00:00:00
2011-03-24 00:00:00
2011-04-26 00:00:00
2011-05-25 00:00:00
2011-06-24 00:00:00
2011-07-27 00:00:00
2011-08-24 00:00:00
2011-09-27 00:00:00
2011-10-27 00:00:00
2011-11-28 00:00:00
2011-12-23 00:00:00
2012-01-27 00:00:00
2012-02-27 00:00:00
2012-03-26 00:00:00
2012-04-25 00:00:00
2012-05-24 00:00:00
2012-06-26 00:00:00
2012-07-26 00:00:00
2012-08-24 00:00:00
2012-09-27 00:00:00
2012-10-25 00:00:00
2012-11-29 00:00:00
2012-12-28 00:00:00
2013-01-28 00:00:00
2013-02-27 00:00:00
2013-03-26 00:00:00
2013-04-24 00:00:00
2013-05-24 00:00:00
Spreadsheet: eric_saibi__9843__CrackSpreadOptions
Sheet: Exotica  HEAT

 | Exotica Crack Spread Option:  HEAT
Description:
 | The  HEAT() function in Exotica Library finds the premium and risk parameters for an option on the spread between two underlyings.
 | The fundamental assumption is that the two prices evolved as correlated GBM.
 | In this function the strike price K is zero.
 | Inputs:
 |  | Price1 | Forward price of commodity 1
 |  | Price2 | Forward price of commodity 2
 |  | Heat Rate | (Heat Rate)/1000
 |  | IntRt | Interest rate
 |  | Vol1 | Annualized volatility of commodity 1
 |  | Vol2 | Annualized volatility of commodity 2
 |  | Correl | Correlation coefficient of commodity 1 and commodity 2
 |  | ExpDays | Time to option expiration (days
 |  | OptType | 1 = Call,  0 = Put
 | Outputs:
 |  | 0 | Option Premium
 |  | 1 | Delta with respect to commodity 1
 |  | 2 | Delta with respect to commodity 2
 |  | 3 | Gamma with respect to commodity 1
 |  | 4 | Gamma with respect to commodity 2
 |  | 5 | Vega with respect to Vol1
 |  | 6 | Vega with respect to Vol2
 |  | 7 | eta (premium sensitivity to change in correlation)
 |  | 8 | rho
 |  | 9 | theta (annualized)
 |  | 10 | charm for commodity 1
 |  | 11 | charm for commodity 2
 |  | 12 | Cross gamma
Spreadsheet: 672921d1587068248-formula-to-give-schedule-visibility-receipt-schedule-database
Sheet: Time Intervals

 | Time Intervals
 | EDIT TIME TABLE |  |  | Time
 | Start time | 07:00:00
 | Interval | 60 MIN
 | End time | 16:00:00
 | VIEW SCHEDULE
 | Select to View Daily Schedule
 | Select to add a new event
Spreadsheet: mary_fischer__25619__77L
Sheet: E31.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY 77L
COMPANY NAME  PBM Mechanical, Inc
RECONCILIATION OF STOCKHOLDERS' EQUITY AND INVESTMENT IN SUBS
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
 |  |  |  | 12-31-00 Balance |  |  |  | EQUITY IN |  | DIVIDENDS DECLARED |  |  |  | OTHER ACTIVITY
 |  |  |  | DR  (CR) |  | RECLASS 00 NI |  | EARNINGS |  |  |  |  |  |  |  |  |  | DR  (CR)
 |  | Hyp line |  | BEG BALANCE |  | TO BEG RE |  | /LOSSES |  | COMMON |  | PREFERRED |  | DR (CR) |  | (Describe) |  | END BALANCE
Shareholders Equity by Parent |  | Reverse signs from Hyperion
Common Stock |  | 0901 |  | -50000
Paid in Capital |  | 0910
Contribution Received from Parent |  | 0915 |  | 936607
RE - Beg Bal |  | 0920 |  |  |  | -1266113
RE - Net Income |  | 0930 |  | -1266113 |  |  |  | 1738635
RE - Net Income (Fair Value Adjustment) |  | 0931
Dividends Decl - Preferred Stock |  | 0935
Dividends Decl - Common Stock |  | 0941
Invest in Subs Plug Account |  | 0942 |  |  |  |  |  | -1
Total Shareholders' Equity |  | TOT_SHARE_EQU
Net Income |  | NET_INCOME
PARENT'S CO #
Investment in Consol Sub (on Parent Books) |  |  |  | Same signs as Hyperion
Investment in CS |  | 0215
Investment in PIC (contrib by parent) |  | 0216
Investment in Equity earnings of sub |  | 0217
Total Investment in Consol Sub
Equity in Consol Sub |  | 1505
Difference between SE (on sub) and Invest (on parent)
Reasons for Differences
A schedule will need to be prepared for each subsidiary.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
Spreadsheet: 731569d1620413700-help-formula-to-find-a-match-for-cell-and-return-value-of-the-title-of-that-column-league-2
Sheet: XMR

S.N. | Particulars | Bought  Units | Unit or XMR Price | Bought/ Sold Price  ($US) | Bought/ Sold Price (BTC) | Token Unit Price During Txn | Activity  Date | Received Date | Fee  ($US) | Fee (%) | Total Price ($US) | Estimated  Price ($US) | Status | Notes
1 | [NAME] 1 | 6.31667832 | 0.01324448 |  | -0.0838703 | 7468 | 2017-11-08 00:00:00 | 2017-11-08 00:00:00 |  |  |  |  | SOLD
2 | [NAME] | -6.31667832 | 0.01710002 |  | 0.10774535 | 7777 | 2017-11-18 00:00:00
3 | [NAME] 2 | 44.20681297 | 0.02029989 |  | -0.89963731 | 8031.2 | 2017-11-23 00:00:00 | 2017-11-23 00:00:00 |  |  |  |  | SOLD
4 | [NAME] | -34.20681297 | 0.0172683 |  | 0.58921714 | 16885.8 | 2017-12-11 00:00:00
5 | [NAME] 3 | -10 | 0.02728578 |  | 0.27217568 | 16496.9 | 2017-12-20 00:00:00
6 | [NAME] 3 | 6.64330705 | 0.02643676 |  | -0.17606664 | 14781.5 | 2018-01-02 00:00:00 | 2018-01-02 00:00:00
7 | [NAME] | -6.64330705 | 0.02911844 |  | 0.1929592 | 13590 | 2018-01-15 00:00:00
8 | [NAME] | 3.26846869 | 0.02852804 |  | -0.09347612 | 11536 | 2018-01-28 00:00:00 | 2018-01-28 00:00:00
9 | [NAME] | -3.26846869 | 0.02843777 |  | 0.09271563 | 10167.5 | 2018-02-16 00:00:00
10
11
12
13
14
15
 | Next Buy
 | [NAME] in [NAME] | 0
 | [NAME] in Bittrex | 0
 | [NAME] in BitStamp | 0
 | Total Investment Loss/Profit ($US)
 | Website: https://
 | Contract address:
 | Symbol:
 | Decimals:
 | About/Idea
 | Team Members (reputation, prior projects, LinkedIn, social presence)
 | Website Design
 | White Paper
 | ICO Rating
 | www.icoranker.com
 | www.icobench.com
 | www.tokenmarket.net
 | Marketing
 | Twitter
 | Instagram
 | Facebook
 | CEO Presence in the market
 | Roadmap & timeline
 | When are they hitting the exchanges?
Spreadsheet: 815237d1674829315-take-the-qty-out-of-stock-vehicle-parts-pricing
Sheet: Prices

 | Stock Codes
Date Purchased | Part # | Description | UOM | Purchase Price | Quantity in Stock | Vehicle and year | Price | Column1 | Column2 | Column3 | Average Cost |  | Part | Price
2022-07-07 00:00:00 | 14C24 | [NAME] | ea. | 1.92 | 10 | 2005-2022 Frontier driver's side |  |  |  |  |  |  | 14C24
2022-07-07 00:00:00 | 14C18 | [NAME] | ea. | 1.92 | 10 | 2005-2022 Frontier passenger's side |  |  |  |  |  |  | 14C18
2022-07-07 00:00:00 | 5486WS | Air Filter | ea. | 3.72 | 10 | 2005-2021 Engine Air Filter |  |  |  |  |  |  | 5486WS
2022-07-07 00:00:00 | F4683 | Cabin Air Filter | ea. | 4.25 | 10 | 2005-2020 Cabin Air Filter |  |  |  |  |  |  | F4683
2022-07-07 00:00:00 | Shipping |  |  | 15.4 | 2 | Shipping Cost
Spreadsheet: 732702d1621174952-expected-output-based-on-3-dropdowns-sample-workbook-with-multiple-criteria
Sheet: Status

 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | Ownership Filter |  |  | Status Filter
 |  |  |  | [NAME] |  | 1st Drop Down |  |  |  |  |  |  | All |  |  | ALL |  | ALL
 |  |  |  |  |  |  |  |  |  |  |  |  |  | All |  |  | ALL |  | ALL
 |  |  |  | Ownership |  | 2nd Drop Down |  |  |  |  |  |  |  | 0215647 |  |  | ABC |  | RNR
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0213189 |  |  | DEF |  | Complete
 |  |  |  | Status |  | 3rd Drop Down |  |  |  |  |  |  |  |  |  |  | GHI |  | WNS
EXPECTED OUTCOME |  | Unique Names | Unique Names | Count | Count
 |  | Ownership | Reconciler | Status | Approved | Grand Total
Spreadsheet: 699715d1602729342-calendar-for-multi-day-recurring-events-recurring-multiday-events
Sheet: Setup

 |  |  |  | Year: | 2020
 |  |  |  | Week Start: | Wednesday
 |  |  |  | Weekends:
 |  |  |  | Monday | 0
 |  |  |  | Tuesday | 0
 |  |  |  | Wednesday | 0 |  |  |  |  |  |  |  |  |  |  |  |  | Skip# [NAME] how many recurrency units to skip,                 i.e. to get every 3rd month, or every 4th week, or every 2 days
 |  |  |  | Thursday | 0 |  |  | Enter "0" for a work day & "1" for a non-work day
 |  |  |  | Friday | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nth = can be 0 to whatever number is the last day of the month.              A '0/ zero' entry means 'last', so last day of the month or last specified weekday
 |  |  |  | Saturday | 1
 |  |  |  | Sunday | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start Date is calculated,                  Stop Date is entered
 |  |  |  | Highlight? | Yes
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Event/ Activity Entry Table: |  |  |  |  |  |  |  |  |  |  | Events Manager Table: |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | All Dates/Events Vertical:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name | Recurrency | Skip# | Length (Days) | Start Month | Nth/ Last | Day of Week | Start Date | Stop Date | Explanation of example |  | Index | Name | Recurrence | Length (Days) | Skip# | Listed | Total Listings | Stop Date | DOW | Nth | Start Date | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | -> 365 days |  |  |  |  | Index | Date | Event [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Event 1 | Monthly | 4 | 3 | 1 | 0 | 3 |  |  | 3 day event that starts the last Tuesday in January & repeats every 4 months until Dec (no stop date defaults to end of year)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Event 2 | Monthly |  |  | 1 | 25 |  |  | 2020-07-25 00:00:00 | 1 day event on January 25 & repeats monthly until July |  | Nothing coded in here yet, basically it brings in available data from the entry table & calculates other data needed |  |  |  |  |  |  |  |  |  |  | I have coded previous calendars to fill in these dates if the event is: A) Multiple days long, not repeating; B) Single day in length, recurrs accoring to inputed values; I am stuck on how to combine these two functionalities |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Also not coded yet, basically takes the dates from Events Manager & lists them vertically
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Event | Monthly | 3 | 4 | 1 | 3 | 5 |  | 2020-12-10 00:00:00 | 4 day event starts 3rd Thursday of January & repeats every 3 months/ quarterly until Nov (Dec 10 occurs before 3rd Thurs in Dec)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Only used monthly event examples as they have the most variety, but same concepts apply to the other recurrency options
Spreadsheet: 74813d1275357534-multi-range-arguments-book7
Sheet: Sheet1

Item | Sold | Unit Price | Percent |  | price range |  | Maximum in price range
RSA0318 | 0 | 28 | 0 |  | from | 30
RSA0314 | 64 | 32 | 0.0308 |  | to | 35
A0314SS | 0 | 34 | 0
RSA0317 | 0 | 34 | 0
[NAME] | 0 | 40 | 0
RSA0319 | 65 | 65 | 0.0308
Spreadsheet: 210613d1359502936-help-with-excel-solver-2
Sheet: Sheet1

i | Y | V | H | M
1 | 2700 | 15.85 | 3.3e-05 | 14
2 | 27000 | 13.4 | 0.11 | 28
3 | 8000 | 23 | 0.075 | 44
4 | 4000 | 10 | 0.02 | 16
5 | 12000 | 24.9 | 0.75 | 43
6 | 13000 | 19.15 | 0.75 | 30
7 | 20000 | 29.35 | 0.015 | 48.5
Variables
n1 | 1.882942032977778
n2 | 0.06992523976762244
n3 | 0.1083063528695387
n4 | 0
n5 | 0
n6 | 0
n7 | 3.392780852818736
Constraints
M=
V=
Y=
H=
RHO= |  |  |  |  |  | 1.5
T= |  |  |  |  |  | 383
W= |  |  |  |  |  | 0.005
Function
Z=
Spreadsheet: 142886d1330064660-name-concatenate-problem-sample
Sheet: Sheet1

First | Second | Third | Forth | Fifth | Sixth | Final Result
[NAME] | P | Suryavanshi | reddy | bari |  | [NAME]
[NAME] | Suryavashi |  |  |  |  | [NAME]
[NAME] |  | Suryavanshi |  |  |  | [NAME]
[NAME] |  |  | Suryavanshi |  |  | [NAME]
[NAME] |  |  |  | Suryavanshi |  | [NAME]
[NAME] |  |  |  |  | Suryavanshi | [NAME]
[NAME] |  | Suryavanshi | Suryavanshi | Suryavanshi | Sawant | [NAME]
[NAME] | Suryavanshi |  |  |  |  | [NAME]
Spreadsheet: 871950d1718325765-calculating-median-with-several-criteria-median
Sheet: Sheet1

OPU_DATE | EX_PATIENT_AGE | EX_FIRST_STIM
2017-01-09 00:00:00 | 40.52 | 300
2017-01-09 00:00:00 | 28.98 | 300
2017-01-09 00:00:00 | 18.41 | 200 | Median =
2017-01-09 00:00:00 | 34.92 | 150
2017-01-11 00:00:00 | 39.92 | 150
2017-01-13 00:00:00 | 39.45 | 300
2017-01-11 00:00:00 | 32.31 | 250
2017-01-13 00:00:00 | 29.93 | 250
2017-01-13 00:00:00 | 40.21 | 300
2017-01-13 00:00:00 | 33.68 | 150
2017-01-13 00:00:00 | 32.92 | 300
2017-01-18 00:00:00 | 30.06 | 225
2017-01-16 00:00:00 | 41.81 | 375
2017-01-16 00:00:00 | 38.72 | 300
2017-01-16 00:00:00 | 27.67 | 125
2017-01-16 00:00:00 | 27.89 | 150
2017-01-20 00:00:00 | 41.7 | 375
2017-01-20 00:00:00 | 32.47 | 300
2017-01-18 00:00:00 | 32.47 | 250
Spreadsheet: kate_symes__18866__Palo
Sheet: DJ Palo Verde 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-03-16 00:00:00 |  | 195.98 | 16352 | 121.88 | 8832
 | 2001-03-15 00:00:00 |  | 180.19 | 17472 | 98.04 | 5160 | 188.69 | 6005 | 136.45 | 3320
 | 2001-03-14 00:00:00 |  | 162.56 | 17184 | 81.84 | 6960 | 194.59 | 4065 | 117.41 | 1400
 | 2001-03-13 00:00:00 |  | 157.46 | 17840 | 69.39 | 7288 | 171.29 | 4137 | 134.75 | 1330
 | 2001-03-12 00:00:00 |  | 166.55 | 12544 | 91.58 | 6920 | 186.95 | 2928 | 114.77 | 1215
 | 2001-03-11 00:00:00 |  | 163 | 3200 | 90 | 1600 | 104.25 | 1435 | 110.05 | 945 |  | 93.34 | 17760
 | 2001-03-10 00:00:00 |  | 148.73 | 18400 | 66.56 | 5864 | 109.79 | 3007 | 124.99 | 2735
 | 2001-03-09 00:00:00 |  | 148.73 | 18400 | 66.56 | 5864 | 175.73 | 6415 | 122.41 | 1756
 | 2001-03-08 00:00:00 |  | 185.11 | 22848 | 92.66 | 8640 | 191.53 | 4219 | 145.14 | 1004
 | 2001-03-07 00:00:00 |  | 300.27 | 25616 | 169.6 | 6824 | 225.26 | 4337 | 151.01 | 1201
 | 2001-03-06 00:00:00 |  | 309.17 | 20320 | 175.44 | 6728 | 215.32 | 7762 | 192.69 | 3047
 | 2001-03-05 00:00:00 |  | 276.65 | 9792 | 162.76 | 4656 | 215.88 | 4042 | 160.99 | 832
 | 2001-03-04 00:00:00 |  | 240 | 800 | 165 | 0 | 168.1 | 2613 | 141.45 | 365 |  | 163.88 | 14568
 | 2001-03-03 00:00:00 |  | 239.87 | 18240 | 148.58 | 7800 | 188.15 | 5032 | 117.4 | 2417
 | 2001-03-02 00:00:00 |  | 242.68 | 15680 | 149.84 | 6728 | 220.44 | 3332 | 159.56 | 867
 | 2001-03-01 00:00:00 |  | 254.01 | 12752 | 142.32 | 4776 | 234.93 | 3755 | 151.21 | 1609
 | 2001-02-28 00:00:00 |  | 178.77 | 16400 | 103.09 | 5920 | 271.72 | 2187 | 185.29 | 705
 | 2001-02-27 00:00:00 |  | 182.08 | 17920 | 98.83 | 5248 | 173.98 | 1198 | 145.57 | 1235
 | 2001-02-26 00:00:00 |  | 197.33 | 10400 | 128.16 | 4152 | 207.88 | 3693 | 115.94 | 1181
 | 2001-02-25 00:00:00 |  | 150 | 0 | 125 | 0 | 146.95 | 3690 | 109.13 | 1615 |  | 128.16 | 12456
 | 2001-02-24 00:00:00 |  | 183.8 | 14608 | 102.52 | 6472 | 184.67 | 3635 | 150.17 | 855
 | 2001-02-23 00:00:00 |  | 183.8 | 14608 | 102.52 | 6472 | 238.26 | 4340 | 143.66 | 910
 | 2001-02-22 00:00:00 |  | 216.97 | 18320 | 115.4 | 7080 | 206.96 | 2653 | 104.69 | 565
 | 2001-02-21 00:00:00 |  | 218.21 | 20720 | 137.88 | 10600 | 175.48 | 1613 | 94.66 | 1119
 | 2001-02-20 00:00:00 |  | 257.07 | 16960 | 162.15 | 8000 | 139.51 | 4942 | 140.75 | 1333
 | 2001-02-19 00:00:00 |  | 256.44 | 17088 | 163.04 | 8192 | 241.52 | 6020 | 167.98 | 773
 | 2001-02-18 00:00:00 |  | 345 | 400 | 242.5 | 0 | 168.63 | 565 | 156.11 | 1125 |  | 248.98 | 14640
 | 2001-02-17 00:00:00 |  | 317.77 | 5920 | 248.95 | 4888 | 281.44 | 2185 | 224.69 | 964
 | 2001-02-16 00:00:00 |  | 407.5 | 9600 | 255.33 | 3000 | 380.8 | 7853 | 212.12 | 765
 | 2001-02-15 00:00:00 |  | 407.5 | 9600 | 255.33 | 3000 | 429.36 | 8631 | 185.81 | 1490
 | 2001-02-14 00:00:00 |  | 260.6 | 15392 | 165.16 | 6200 | 368.89 | 6205 | 216.82 | 1085
Spreadsheet: 142136d1329678382-summarise-data-from-multiple-sheets-based-on-dates-test-data
Sheet: Area 3

Date | reference | problem |  |  | problem a
 |  |  |  |  | problem b
2012-02-01 00:00:00 | abc657 | [NAME] |  |  | problem c
2012-02-02 00:00:00 | [NAME] | problem a |  |  | [NAME]
2012-02-03 00:00:00 | abc659 | [NAME]
2012-02-04 00:00:00 | abc660 | problem c
2012-02-05 00:00:00 | abc661 | problem b
2012-02-06 00:00:00 | abc662 | problem b
2012-02-07 00:00:00 | abc663 | problem c
2012-02-08 00:00:00 | abc664 | problem a
2012-02-08 00:00:00 | abc665 | problem a
Spreadsheet: 78782d1279105277-excel-2007-count-if-between-dates-book1
Sheet: Order History

Order Date | Product ID | Description | Voucher | Price | Quantity | Total
2010-07-13 00:00:00 | pt0001 | Product 1 | No | 14.99 | 2 | 29.98
2010-07-14 00:00:00 | [NAME] | Product 2 | No | 14.99 | 2 | 29.98
2010-07-15 00:00:00 | pt0003 | Product 3 | No | 14.99 | 2 | 29.98
2010-07-16 00:00:00 | pt0004 | Product 4 | No | 14.99 | 2 | 29.98
2010-07-17 00:00:00 | [NAME] | Product 5 | No | 14.99 | 2 | 29.98
2010-07-18 00:00:00 | pt0006 | Product 6 | No | 14.99 | 2 | 29.98
2010-07-19 00:00:00 | pt0007 | Product 7 | No | 14.99 | 5 | 74.95
2010-07-20 00:00:00 | pt0008 | Product 8 | No | 14.99 | 5 | 74.95
2010-08-01 00:00:00 | pt0009 | Product 9 | No | 14.99 | 5 | 74.95
2010-08-02 00:00:00 | [NAME] | Product 10 | No | 14.99 | 5 | 74.95
2010-08-03 00:00:00 | pt0011 | Product 11 | No | 14.99 | 5 | 74.95
2010-08-04 00:00:00 | pt0012 | Product 12 | No | 14.99 | 5 | 74.95
2010-08-05 00:00:00 | pt0013 | Product 13 | No | 14.99 | 5 | 74.95
Spreadsheet: john_griffith__16142__1_24_02OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HO G2 | 53 | 200 | 300 | 45.1 | 67.8 | 1.88 | 2002-01-24 13:55:00
 | [NAME] | 54 | 580 | 640 | 45.6 | 50.3 | 1.63 | 2002-01-24 13:55:00
 | HO J2 | 54 | 800 | 900 | 46.1 | 51.9 | 1.66 | 2002-01-24 13:55:00
 | HO K2 | 54 | 940 | 1040 | 44.2 | 48.9 | 1.58 | 2002-01-24 13:55:00
 | HO M2 | 54 | 1050 | 1150 | 42.5 | 46.6 | 1.51 | 2002-01-24 13:55:00
 | HO N2 | 55 | 1150 | 1250 | 41.4 | 45 | 1.49 | 2002-01-24 13:55:00
 | HO Q2 | 55 | 1225 | 1325 | 40.4 | 43.7 | 1.45 | 2002-01-24 13:55:00
 | HO U2 | 56 | 1300 | 1400 | 39 | 42 | 1.43 | 2002-01-24 13:55:00
 | [NAME] | 57 | 1325 | 1475 | 36.8 | 41 | 1.39 | 2002-01-24 13:55:00
 | HO X2 | 58 | 1400 | 1550 | 36 | 39.9 | 1.38 | 2002-01-24 13:55:00
 | [NAME] | 59 | 1400 | 1550 | 33.9 | 37.5 | 1.32 | 2002-01-24 13:55:00
 | HO F3 | 59 | 1425 | 1575 | 33.1 | 36.6 | 1.29 | 2002-01-24 13:55:00
 | [NAME] |  |  |  | 33.2 | 36.5 | 1.31 | 2001-12-31 13:18:00
 | HO H3
 | HO J3 |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | [NAME]
Spreadsheet: 867596d1714426095-distribute-amount-in-column-according-to-date-and-duration-test
Sheet: Lists

Setting | Timeline | Cost |  | Adresses (ImmAdr)
No change | 0 | 0 |  | Address 1
Office only | 1 | 1500 |  | Address 2
Full | 3 | 3000 |  | Address 3
? | ? |  |  | Address 4
? | ? |  |  | Address 5
? | ? |  |  | Address 6
 |  |  |  | Address 7
 |  |  |  | Address 8
 |  |  |  | Address 9
 |  |  |  | Address 10
 |  |  |  | Address 11
 |  |  |  | Address 12
 |  |  |  | Address 13
 |  |  |  | Address 14
 |  |  |  | Address 15
 |  |  |  | Address 16
 |  |  |  | Address 17
 |  |  |  | Address 18
 |  |  |  | Address 19
Spreadsheet: 112628d1308690523-subtraction-of-h-mm-perd-ns-e-timesheet
Sheet: E-Time Sheet

Name | BU ID | Main Rate |  | Week Ending
[NAME] | U67140372 | 8.25 |  | 2011-06-19 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Actual Hrs to Pay
 |  | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY |  | SATURDAY |  | SUNDAY |  | Total  Hrs
Position | Notes | Start | Stop | Start | Stop | Start | Stop | Start | Stop | Start | Stop | Start | Stop | Start | Stop |  | CC | Rate | Hrs | Hrs/Min
SSC Counselor |  | 13:30:00 | 14:15:00 | 15:00:00 | 17:45:00 | 14:00:00 | 15:00:00
General Notes
Spreadsheet: 130698d1322521942-amendment-to-if-formula-pauldaddyadams-grouplist
Sheet: Sheet2

Item | Group
10.8mm Optiphon | Stock
10mm Optifloat Clear T | Stock
10mm Optifloat Clear T | Stock
10[NAME] [NAME] | Stock
11.5mm Optilam  Ct | Cut Size
12mm Optifloat Clear T | Stock
4.4mm Optilam Clear Ct | Cut Size
4mm  K Glass T | Stock
4mm [NAME] | Stock
4mm [NAME] | Stock
4mm Cust Own T | Stock
4mm K Glass | Stock
4mm K Glass OW | Stock
4mm K Glass OW T | Stock
4mm Optifloat [NAME] T | Stock
4mm Optifloat Clear | Stock
4mm Optifloat Clear T | Stock
4mm Optifloat Grey T | Stock
4mm Optifloat Opal | Stock
4mm Optifloat Opal T | Stock
4mm Optimirror OW | Stock
4mm Optitherm S3 T | Stock
4mm Optitherm S4 ProT Annealed | Stock
4mm Optiwhite E | Stock
4mm Optiwhite E T | Stock
4mm Optiwhite T | Stock
4mm Oriel Collect Cantebury T | Stock
4mm Sandblast Decorative T | Stock
4mm Textured Arctic | Stock
4mm Textured Arctic T | Stock
4mm Textured Autumn | Stock
4mm Textured Autumn T | Stock
4mm Textured Chantilly T | Stock
4mm Textured Charcoal Sticks | Stock
4mm Textured Contora | Stock
4mm Textured Contora T | Stock
4mm Textured Cotswold | Stock
4mm Textured Cotswold T | Stock
4mm Textured Digital T | Stock
4mm Textured Everglade T | Stock
4mm Textured Flemish | Stock
4mm Textured Flemish T | Stock
4mm Textured Florielle | Stock
4mm Textured Florielle T | Stock
4mm Textured Mayflower | Stock
4mm Textured Mayflower T | Stock
4mm Textured Minster | Stock
4mm Textured Minster T | Stock
4mm Textured Oak | Stock
4mm Textured Oak T | Stock
4mm Textured Pelerine | Stock
4mm Textured Pelerine T | Stock
4mm Textured Stippolyte | Stock
4mm Textured Stippolyte T | Stock
4mm Textured Sycamore T | Stock
4mm Textured Taffeta | Stock
4mm Textured Taffeta T | Stock
4mm Textured Warwick T | Stock
6.4mm Optilam Clear Ct | Cut Size
6.4mm Optilam K Ct | Cut Size
6.4mm Optilam OW | Stock
6.8mm Optiphon Ct | Cut Size
6mm Optifloat [NAME] T | Stock
6mm Optifloat Clear | Stock
6mm Optifloat Clear T | Stock
6mm Optifloat Grey T | Stock
6mm Optifloat Opal T | Stock
6mm Optiwhite E T | Stock
6mm Spandrel Black | Stock
6mm Spandrel [NAME] | Stock
6mm Textured Cotswold T | Stock
6mm Textured Flemish T | Stock
6mm Textured Stippolyte T | Stock
7mm Pyroshield 2 Safety Clear | Stock
7mm Pyroshield 2 Textured | Stock
8.8mm Optiphon Ct PVB | Cut Size
8mm Optifloat Clear T | Stock
Cervoglass (TM) Sun | Domestic IGU
Cervoglass(TM) [NAME] | Domestic IGU
Cervoglass(TM) [NAME] | Domestic IGU
Cervoglass(TM) Sun | Domestic IGU
Cervoglass(TM) Therm | Domestic IGU
energiKare(TM) | Domestic IGU
energiKare(TM) Triple | Domestic IGU
[NAME] | Stock
Insulight Unit | Stock
Insulight Unit Toughened | Toughened
Insulight(TM) | Domestic IGU
Insulight(TM) [NAME] | Domestic IGU
Insulight(TM) [NAME] | Domestic IGU
Insulight(TM) [NAME] | Domestic IGU
Insulight(TM) Protect | Domestic IGU
Insulight(TM) Protect1 | Domestic IGU
Insulight(TM) Sun | Domestic IGU
Insulight(TM) Therm | Domestic IGU
Insulight(TM) Therm Protect | Domestic IGU
Insulight(TM) Triple | Domestic IGU
Pyrodur EW30-104 7mm CS | Stock
Pyrostop EI30-10 15mm CS | Stock
Pyrostop EI30-20 18mm CS | Stock