tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 270575d1381527921-index-match-with-date-range-criteria-tracking-form-need-help
Sheet: Accruals-Pmts

All Accounted For? | GDN | ID1 | ID2 | Active Document | Type |  |  | Transaction Type | Impacted Month | Month Submitted on Accrual | 1 | Name | Total as of Col K end-of-month date | [NAME] | Current (today's) % Complete | % complete at time of accrual | Total Amount to [NAME] | Total [NAME] to [NAME] | Total Exp Amount to [NAME]
 | P512-1 |  |  |  |  |  |  | Accrual | 2013-05-01 00:00:00 | 2013-05-01 00:00:00 |  | Test |  |  |  | 0.6
 | P512-1 |  |  |  |  |  |  | Accrual | 2013-06-01 00:00:00 | 2013-06-01 00:00:00 |  | Test |  |  |  | 0.75
 | P512-1 |  |  |  |  |  |  | Accrual | 2013-07-01 00:00:00 | 2013-07-01 00:00:00 |  | Test |  |  |  | 1
 | P308-128 |  |  |  |  |  |  | Accrual | 2013-05-01 00:00:00 | 2013-05-01 00:00:00 |  | EofE |  |  |  | 1
 | P308-128 |  |  |  |  |  |  | Accrual | 2013-05-01 00:00:00 | 2013-05-01 00:00:00 |  | EofC |  |  |  | 0.5 |  | 0
 | P308-128 |  |  |  |  |  |  | Accrual | 2013-06-01 00:00:00 | 2013-06-01 00:00:00 |  | EofC |  |  |  | 0.7
 | P308-128 |  |  |  |  |  |  | Accrual | 2013-07-01 00:00:00 | 2013-07-01 00:00:00 |  | EofC |  |  |  | 1
 | P308-128 |  |  |  |  |  |  | Accrual | 2013-07-01 00:00:00 | 2013-07-01 00:00:00 |  | EofI |  |  |  | 0.4
 | P308-128 |  |  |  |  |  |  | Accrual | 2013-08-01 00:00:00 | 2013-08-01 00:00:00 |  | EofI |  |  |  | 1
 | P308-128 |  |  |  |  |  |  | Accrual | 2013-09-01 00:00:00 | 2013-09-01 00:00:00 |  | EofW |  |  |  | 1
 | P308-128 |  |  |  |  |  |  | Accrual | 2013-09-01 00:00:00 | 2013-09-01 00:00:00 |  | EofD |  |  |  | 1
Spreadsheet: 139020d1328037420-preparing-an-excel-spreadsheet-for-linking-need-attachments-for-clarification-spreadsheet-a-creek-flow-calc-sheet
Sheet: Blank Calc Template

 |  |  |  |  | flow calculation blank template
 |  | Depth (inches) |  |  |  | Ave Depth | [NAME] |  |  | Time (sec) |  |  | Ave time | Ave Flow | Flow | Flow
 | Depth 1 | Depth 2 | Depth 3 | Depth 4 | Depth 5 | (feet) | (feet) | Time 1 | Time 2 | Time 3 | Time 4 | Time 5 | (sec) | (ft/sec) | CFS | MGD
RW4 |  |  |  |  |  | 0 |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A
RW5 |  |  |  |  |  | 0 |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A
RW7 |  |  |  |  |  | 0 |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A
RW8 |  |  |  |  |  | 0 |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 136071d1326393928-production-and-inventory-adjustment-mra
Sheet: Bullet Recipes

 | .357 Mag | Cost | .38 Special | Cost | 9mm | Cost | .40 cal | Cost | .45 cal | Cost
.357 Case | 1 |  | 0 |  | 0 |  | 0 |  | 0
.38 Case | 0 |  | 1 |  | 0 |  | 0 |  | 0
9mm Case | 0 |  | 0 |  | 1 |  | 0 |  | 0
.40 Case | 0 |  | 0 |  | 0 |  | 1 |  | 0
.45 Case | 0 |  | 0 |  | 0 |  | 0 |  | 1
.357 Bullet | 1 |  | 0 |  | 0 |  | 0 |  | 0
.38 Bullet | 0 |  | 1 |  | 0 |  | 0 |  | 0
9mm Bullet | 0 |  | 0 |  | 1 |  | 0 |  | 0
.40 Bullet | 0 |  | 0 |  | 0 |  | 1 |  | 0
.45 Bullet | 0 |  | 0 |  | 0 |  | 0 |  | 1
[NAME] | 1 |  | 1 |  | 1 |  | 0 |  | 0
[NAME] | 0 |  | 0 |  | 0 |  | 1 |  | 1
Powder | 13 |  | 11 |  | 4.5 |  | 6 |  | 5.5
Total Cost per Bullet
Spreadsheet: 74823d1275379483-counting-unique-combinations-vendor-sales
Sheet: Result

Vendor Code | Numer of part #'s
A0598
I086
B575
R051
T0228
I369
A025
C508
S0393
S0518
C0383
H355
T0260
W047
R471
M256
D322
S0359
A580
A0482
S0254
T585
N0041
W0034
I0196
M0346
G221
M336
W114
M562
M0370
T0194
F0129
S826
H0116
S0117
T171
[NAME]
[NAME]
A853
T0176
I0187
R156
W0049
G0061
S0340
[NAME]
[NAME]
L318
P0014
G471
G0160
K089
F0090
T0178
S593
S0050
A0480
T0193
A0646
V0023
C0544
K0069
P0272
B067
F013
E0173
F0155
I0086
M0431
M630
R0280
S0374
[NAME]
Spreadsheet: 842953d1694944459-keyword-search-for-faqs-spreadsheet-faqs
Sheet: Who is

Who Is - 1 | Number 1
Who Is - 2 | Number 2
Who Is - 3 | Number 3
Who Is - 4 | Number 4
Who Is - 5 | Number 5
Who Is - 6 | Number 6
Who Is - 7 | Number 7
Who Is - 8 | Number 8
Who Is - 9 | Number 9
Who Is - 10 | Number 10
Spreadsheet: 4bf2f2ce-b437-4244-9e31-e6f34a7b1b25
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
[NAME] | Test | [NAME] | Rye Food IgG | Rye Food IgG | Enzyme Immunoassay (FEIA) |  |  |  |  |  | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis:	NA Thawing:	Warm OK; Cold OK Lipemia:	NA Icterus:	NA Other:	NA | <2 mcg/mL  The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.   Test Performed by:	Viracor-IBT Laboratories 			1001 NW Technology Dr.  			Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
[NAME] | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
[NAME] | Result | [NAME] | Rye Food IgG | Rye Food IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: d6d302a8-fc45-42dd-a08a-db0c8c043194
Sheet: Sheet1

High Blood Pressure, Adults Ages 18 Years and Over,  by Year, Maine, 2000, 2001, 2003, 2005, 2007, 2009 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Year | Unweighted Number | Weighted Number |  | % | LCL | UCL
2000 | 1268 | 249765.7116202138 |  | 26.61461226781905 | 24.48591388546243 | 28.74331065017567
2001 | 663 | 242225.9979490753 |  | 25.19314406845278 | 23.34294285226916 | 27.04334528463639
2003 | 660 | 261423.6034899427 |  | 26.01687051866011 | 24.07394775843306 | 27.95979327888716
2005 | 1131 | 264536.8595855006 |  | 25.57763701965091 | 24.03502802169904 | 27.12024601760277
2007 | 2300 | 302832.8881879305 |  | 28.6735692297242 | 27.32995102880095 | 30.01718743064745
2009 | 3094 | 313127.320142808 |  | 30.02023319512849 | 28.78595544107698 | 31.25451094918
Data Source: Behavioral Risk Factor Surveillance System Data is based on the percent of adults who were told by a doctor or other health care professional that they had high blood pressure. % = Weighted percentage of respondents LCL= Lower 95% confidence level of the weighted percentage UCL= Upper 95% confidence level of the weighted percentage
All percentages are weighted to be more representative of the population of Maine and to adjust for non-response.
Spreadsheet: 104873d1302294483-excel-2007-getting-data-from-another-sheet-page-771670-excelforum
Sheet: Disco

Kalkyl för '[NAME]'
--- | Inkomst | Utgift | Kommentar | Summa | Totalt
 | 0 |  | Grossistinköp
Summa
Disco inköp
Pris/kg | Kvant/Kg | Antal | Godis-namn | Summa | Totalt
0.55 | 56 | 1 | Klubbor, 56/fp
5.35 | 24 | 1 | Snickers, 80g, 24/fp
5.35 | 30 | 1 | [NAME], 85g, 30/fp
24.9 | 1.55 | 1 | [NAME], 1,55kg/fp
24.9 | 2.09 | 1 | Godis Lösvikt - Stora Cola Flaskor, 2,09kg/fp
3.75 | 24 | 5 | Läsk Cola/Fanta/Sprite, 33cl, 24/fp
Summa
Spreadsheet: 5cb8fd50-f570-4fcc-bce2-1f751659d235
Sheet: Sheet1

IGSSA HOCKEY TEAM NOMINATIONS 2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
SCHOOL:
Due: | 16th May 2012 |  |  |  | [NAME] | [NAME]
Please number team from 1 - final entry e.g. 1-20
Seniors / Opens |  |  |  | Junior |  |  |  | Year 7
S1 |  | S7 |  | J1 |  | J6 |  | Y7-1
S2 |  | S8 |  | J2 |  | J7 |  | Y7-2
S3 |  | S9 |  | J3 |  | J8 |  | Y7-3
[NAME] |  | S10 |  | J4 |  | J9 |  | Y7-4
S5 |  | S11 |  | J5 |  | J10 |  | Y7-5
S6 |  | S12
TOTAL:
I have obtained a firm commitment from girls wishing to play hockey and see no reason for a change in the number of teams entered.
Approved |  |  |  |  |  |  | Date
Please only provide details of pitches at your school that are available or external venues that you have BOOKED
 |  | No. of Pitches |  | Type of Pitch |  | Address (or best entrance if a school venue)
SCHOOL
EXTERNAL venues booked by you |  |  |  |  |  |  |  |  |  |  |  | Grass
 |  |  |  |  |  |  |  |  |  |  |  | Sand
 |  |  |  |  |  |  |  |  |  |  |  | Synthetic
Example |  | 1 |  | Sand |  | Cnr Smith & Brown Street, [NAME]
Any Restrictions on the use of these venues ?? [NAME]
Spreadsheet: 9060b7ec-ce3d-4b4f-a1f1-5aeebb7d37fe
Sheet: Equipment

EQUIPMENT
Purchased Equipment
1.  List any equipment over $5,000 that you intend to purchase in the upcoming fiscal year and maintain documentation of three bids/quotes and justification of need for each item.  If you are a private organization and plan on purchasing equipment over $100,000, additional procurement steps must be followed (see procurement worksheet in management plan binder).  If you are a public organization, state threshold requirements and procedures must be followed.                                                                                                                                                                                            2.  For all items you intend to purchase later, which are not included here, please provide a written request.  Certain expenditures require specific prior written approval.
Durable Supplies Purchased over $5000
Type of Equipment Purchased |  | Expected Purchase Date | Quanity | Life Expectancy of Equipment (Years) | Cost of Equipment | % of cost allocated to CACFP | Total Annual Cost to CACFP
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
Rented/Leased Equipment
List all rented/leased equipment.  Attach or send copies of all equipment leases.
Type of Equipment Rented/Leased |  | Estimated Total Annual Cost |  | % Allocated to CACFP | Annual Cost to CACFP
 | Sub-Total Rented/Leased Equipment
 |  |  | Total EQUIPMENT
Spreadsheet: 146241d1332001341-monthly-averages-help-acme-incytdfin
Sheet: Sheet1

Job Number | Client | Description | Date Billed | Amount | Date Paid | Total Paid
09-001
09-002
09-003
09-004
09-005
09-006
09-007
09-008
09-009
09-011
09-012
09-013
09-014
09-015
09-016
09-017
09-018
09-019
09-020
09-021
09-022
09-023
09-024
09-025
09-026
09-027
09-028
09-029
09-030
 |  |  |  | Total to Date
 |  |  |  | Monthly Average
 |  |  |  | Projected Yearly
Spreadsheet: 84094d1284089712-date-not-working-in-pivot-table-book1
Sheet: pivot

Sum of Qty | Column Labels
Row Labels | 2010-07-01 00:00:00 | 2010-07-02 00:00:00 | 2010-07-03 00:00:00 | 2010-07-04 00:00:00 | 2010-07-05 00:00:00 | 2010-07-06 00:00:00 | 2010-07-07 00:00:00 | 2010-07-08 00:00:00 | 2010-07-09 00:00:00 | 2010-07-10 00:00:00 | 2010-07-11 00:00:00 | 2010-07-12 00:00:00 | 2010-07-13 00:00:00 | 2010-07-14 00:00:00 | 2010-07-15 00:00:00 | 2010-07-16 00:00:00 | 2010-07-17 00:00:00 | 2010-07-18 00:00:00 | 2010-07-19 00:00:00 | 2010-07-20 00:00:00 | 2010-07-21 00:00:00 | 2010-07-22 00:00:00 | 2010-07-23 00:00:00 | 2010-08-01 00:00:00 | 2010-08-02 00:00:00 | 2010-08-03 00:00:00 | 2010-08-04 00:00:00 | 2010-08-05 00:00:00 | 2010-08-06 00:00:00 | 2010-08-07 00:00:00 | 2010-08-08 00:00:00 | 2010-08-09 00:00:00 | 2010-08-10 00:00:00 | 2010-08-11 00:00:00 | 2010-08-12 00:00:00 | 2010-08-13 00:00:00 | 2010-08-14 00:00:00 | 2010-08-15 00:00:00 | 2010-08-16 00:00:00 | 2010-08-17 00:00:00 | 2010-08-18 00:00:00 | 2010-08-19 00:00:00 | 2010-08-20 00:00:00 | 2010-08-21 00:00:00 | 2010-08-22 00:00:00 | 2010-08-23 00:00:00 | 2010-08-24 00:00:00 | 2010-08-25 00:00:00 | 2010-08-26 00:00:00 | 2010-08-27 00:00:00 | 2010-08-28 00:00:00 | 2010-08-29 00:00:00 | 2010-08-30 00:00:00 | Grand Total
Big W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 20
Kmart |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  | 20
Priceline | 1 | 1 | 1 | 1 | 2 | 2 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
Grand Total | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 3 | 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 | 1 | 1 | 60
Spreadsheet: b876e504-718b-4b1b-9d5e-76f385871e44
Sheet: QTD Recon Q3FY13

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Reconciliation of GAAP to Non-GAAP Unaudited Condensed Consolidated Statements of Operations
(in millions, except per share data)
 | Three Months Ended December 31, 2012
 | GAAP Results |  | Acquisition-related expenses |  | Amortization of debt discount |  | Certain non-recurring litigation expenses | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Gain on strategic investments |  | Restructuring and other |  | Stock-based compensation |  | Income tax adjustments |  | Non-GAAP Results
Net revenue | 922 |  | 0 |  | 0 |  | 0 | 260 |  | 0 |  | 0 |  | 0 |  | 0 |  | 1182
Cost of revenue | 429 |  | -23 |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 406
Gross profit | 493 |  | 23 |  | 0 |  | 0 | 260 |  | 0 |  | 0 |  | 0 |  | 0 |  | 776
Operating expenses:
Marketing and sales | 214 |  | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | -7 |  | 0 |  | 207
General and administrative | 68 |  | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | -7 |  | 0 |  | 61
Research and development | 286 |  | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | -25 |  | 0 |  | 261
Acquisition-related contingent consideration | -45 |  | 45 |  | 0 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -
Amortization of intangibles | 7 |  | -7 |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring and other | 2 |  | 0 |  | 0 |  | 0 | 0 |  | 0 |  | -2 |  | 0 |  | 0 |  | -
Total operating expenses | 532 |  | 38 |  | 0 |  | 0 | 0 |  | 0 |  | -2 |  | -39 |  | 0 |  | 529
Operating income (loss) | -39 |  | -15 |  | 0 |  | 0 | 260 |  | 0 |  | 2 |  | 39 |  | 0 |  | 247
Gain on strategic investments | 14 |  | 0 |  | 0 |  |  | 0 |  | -14 |  | 0 |  | 0 |  | 0 |  | 0
Interest and other income (expense), net | -8 |  | 0 |  | 5 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -3
Income (loss) before provision for income taxes | -33 |  | -15 |  | 5 |  | 0 | 260 |  | -14 |  | 2 |  | 39 |  | 0 |  | 244
Provision for income taxes | 12 |  | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 56 |  | 68
Net income (loss) | -45 |  | -15 |  | 5 |  | 0 | 260 |  | -14 |  | 2 |  | 39 |  | -56 |  | 176
Loss per share |  |  |  |  |  |  |  |  |  |  |  |  |  | Earnings per share
Basic and diluted | -0.15 |  |  |  |  |  |  |  |  |  |  |  |  | Basic |  |  |  | 0.58
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Diluted |  |  |  | 0.57
Number of shares used in computation |  |  |  |  |  |  |  |  |  |  |  |  |  | Number of shares used in computation
Basic and diluted | 304 |  |  |  |  |  |  |  |  |  |  |  |  | Basic |  |  |  | 304
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Diluted |  |  |  | 308
Spreadsheet: 867551d1714393221-find-the-corresponding-numbers-for-english-letters-separately-ex429-aligw
Sheet: Sheet1

 | A | B | C | D | E
 | 1 | 2 | 3 | 4 | 5
AAB
AB | 3
ABC | 6
CDE | 12
EE | 10
Spreadsheet: 12afddd3-6cc3-4239-874a-196ce8bc55bf
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
[NAME] | Test | [NAME] | [NAME], IgE | [NAME], 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
[NAME] | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
[NAME] | Result | [NAME] | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6281-0 | Morus alba [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 475443d1471311908-subtotals-in-an-excel-table-sample-table
Sheet: Overdue Invoices

Overdue Invoices as at 31/07/2016
Customer Name | Invoice # | Gross Amount  (Inc. GST) | Open Amount (Inc. GST) | Invoice Date | Due Date | Closed Date | Days Past Due
ABC123 | 2010779 / RI | 434.01 | 434.01 | 2016-05-11 00:00:00 | 2016-06-10 00:00:00 |  | 51
ABC123 | 2011056 / RI | 96.5 | 96.5 | 2016-05-25 00:00:00 | 2016-06-24 00:00:00 |  | 37
ABC123 | 2011716 / RI | 1050.02 | 1050.02 | 2016-06-27 00:00:00 | 2016-07-27 00:00:00 |  | 4
DEF654 | 2011078 / RI | 8675.23 | 8675.23 | 2016-05-26 00:00:00 | 2016-06-25 00:00:00 |  | 36
DEF654 | 2009916 / RI | 2306.7 | 2306.7 | 2016-03-31 00:00:00 | 2016-05-15 00:00:00 |  | 77
DEF654 | 2010557 / RI | 6235.96 | 6235.96 | 2016-04-29 00:00:00 | 2016-06-15 00:00:00 |  | 46
DEF654 | 2011128 / RI | 29460.2 | 29460.2 | 2016-05-27 00:00:00 | 2016-07-15 00:00:00 |  | 16
DEF654 | 2008553 / RI | 533.5 | 533.5 | 2016-01-27 00:00:00 | 2016-04-26 00:00:00 | 2016-08-01 00:00:00 | 96
DEF654 | 2009337 / RI | 404.25 | 404.25 | 2016-02-25 00:00:00 | 2016-05-25 00:00:00 | 2016-08-01 00:00:00 | 67
DEF654 | 2009506 / RI | 10239.9 | 10239.9 | 2016-03-08 00:00:00 | 2016-06-06 00:00:00 | 2016-08-08 00:00:00 | 55
MNO456 | 2011671 / RI | 2194.5 | 2194.5 | 2016-06-23 00:00:00 | 2016-07-23 00:00:00 | 2016-08-09 00:00:00 | 8
STU987 | 2011217 / RI | 21393.79 | 21393.79 | 2016-05-31 00:00:00 | 2016-07-15 00:00:00 |  | 16
XYZ999 | 2010856 / U1 | 604.95 | 604.95 | 2016-05-13 00:00:00 | 2016-06-12 00:00:00 | 2016-08-01 00:00:00 | 49
XYZ999 | 2010892 / U1 | 285.82 | 285.82 | 2016-05-16 00:00:00 | 2016-06-15 00:00:00 | 2016-08-01 00:00:00 | 46
XYZ999 | 2010893 / U1 | 420.71 | 420.71 | 2016-05-16 00:00:00 | 2016-06-15 00:00:00 | 2016-08-01 00:00:00 | 46
XYZ999 | 2010894 / U1 | 383.88 | 383.88 | 2016-05-16 00:00:00 | 2016-06-15 00:00:00 | 2016-08-01 00:00:00 | 46
XYZ999 | 2010473 / RI | 1239.7 | 1239.7 | 2016-04-27 00:00:00 | 2016-05-30 00:00:00 |  | 62
Spreadsheet: 846873d1698023296-create-a-drop-down-cell-that-brings-information-from-other-sheets-on-click-master-list-of-manuals-elgarnan-
Sheet: Sheet1

ITEM NO. | PROCEDURE NUMBER | PROCEDURE TITLE | REVISION NUMBER | DATE
Security Department
Spreadsheet: 955e8f1e-92c1-4859-98c6-538465924b6d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: Quarterly Summary of State & Local Taxes
 |  | Table 1 - Latest National Totals of State and Local Tax Revenue: U.S. Total
 |  | Not Seasonally Adjusted Total Taxes [Millions of Dollars]
 |  | Period: 1992 to 2012
 |  | Data Extracted on: December 21, 2014 (1:11 pm)
Period | Value
Q1-1992 | 135822
Q2-1992 | 144154
Q3-1992 | 130322
Q4-1992 | 158733
Q1-1993 | 144699
Q2-1993 | 150412
Q3-1993 | 139186
Q4-1993 | 159318
Q1-1994 | 154049
Q2-1994 | 151821
Q3-1994 | 142333
Q4-1994 | 167533
Q1-1995 | 157896
Q2-1995 | 161701
Q3-1995 | 149534
Q4-1995 | 178442
Q1-1996 | 170544
Q2-1996 | 175449
Q3-1996 | 161924
Q4-1996 | 188453
Q1-1997 | 180444
Q2-1997 | 186031
Q3-1997 | 170327
Q4-1997 | 197603
Q1-1998 | 190315
Q2-1998 | 202369
Q3-1998 | 174161
Q4-1998 | 207206
Q1-1999 | 196889
Q2-1999 | 208627
Q3-1999 | 183337
Q4-1999 | 223852
Q1-2000 | 215048
Q2-2000 | 230440
Q3-2000 | 192487
Q4-2000 | 237412
Q1-2001 | 222853
Q2-2001 | 235918
Q3-2001 | 195374
Q4-2001 | 240101
Q1-2002 | 221818
Q2-2002 | 230568
Q3-2002 | 200908
Q4-2002 | 250397
Q1-2003 | 227915
Q2-2003 | 229583
Q3-2003 | 218266
Q4-2003 | 268473
Q1-2004 | 245894
Q2-2004 | 253143
Q3-2004 | 230688
Q4-2004 | 295676
Q1-2005 | 268565
Q2-2005 | 289080
Q3-2005 | 251878
Q4-2005 | 320314
Q1-2006 | 289134
Q2-2006 | 316468
Q3-2006 | 263937
Q4-2006 | 340479
Q1-2007 | 305855
Q2-2007 | 336925
Q3-2007 | 273650
Q4-2007 | 358394
Q1-2008 | 311635
Q2-2008 | 351774
Q3-2008 | 285686
Q4-2008 | 370456
Q1-2009 | 305960
Q2-2009 | 314608
Q3-2009 | 271984
Q4-2009 | 372468
Q1-2010 | 306065
Q2-2010 | 321866
Q3-2010 | 283595
Q4-2010 | 377885
Q1-2011
Q2-2011
Q3-2011
Q4-2011
Q1-2012
Q2-2012
Q3-2012
Q4-2012
Spreadsheet: 221565d1363613684-need-several-values-to-line-up-to-return-a-specific-value-need-formula-help-please-book1
Sheet: Sheet1

Conf.dt. | Conf.t. | Time Between Scans | Team | Day of Week | Shift # | AM or PM |  | Sunday | 1 | 2 |  | Day of Week | Time | AM / PM | Shift #
2013-03-17 00:00:00 | 23:59:56 | 00:00:00 | Red |  |  | PM |  | Monday | 3 | 4 |  | Sunday | 1900-01-03 23:59:56 | PM | 2
2013-03-17 00:00:00 | 23:59:57 |  | Red |  |  | PM |  | Tuesday | 5 | 6 |  | Sunday | 1900-01-02 23:59:57 | PM | 2
2013-03-17 00:00:00 | 23:59:58 |  | Blue |  |  | AM |  | Wednesday | 7 | 8 |  | Sunday | 1900-01-01 23:59:58 | PM | 2
2013-03-17 00:00:00 | 23:59:59 |  | Blue |  |  | AM |  | Thursday | 9 | 10 |  | Sunday | 23:59:59 | PM | 2
2013-03-18 00:00:00 | 00:00:00 |  | Red |  |  | PM |  | Friday | 11 | 12 |  | Monday | 00:00:00 | PM | 2
2013-03-18 00:00:00 | 00:00:01 |  | Red |  |  | PM |  | Saturday | 13 | 14 |  | Monday | 00:00:01 | PM | 2
2013-03-18 00:00:00 | 00:00:02 |  | Blue |  |  | AM |  |  |  |  |  | Monday | 00:00:02 | PM | 2
2013-03-18 00:00:00 | 00:00:03 |  | Blue |  |  | AM |  | Currently, this is the |  |  |  | Monday | 00:00:03 | PM | 2
 |  |  |  |  |  |  |  | table associated to |  |  |  | This list actually lists every second of all 14 shifts
Note that Mar. 17th, 2013 was a Sunday PM shift that started at 1800hrs and so |  |  |  |  |  |  |  | the formula in 'F' |  |  |  | I thought I could figure out a formula using this
should actually be shift 2. But when midnight flips Sunday to Monday, shift # needs to |  |  |  |  |  |  |  | that's returning the |  |  |  | but I'm lost!
remain as shift 2.  the current formula that returns the values in error links to the |  |  |  |  |  |  |  | false values.  I tried
table in I1:K7.  I thought I might be able to figure out a formula that uses the data in |  |  |  |  |  |  |  | to create a new table
the table shown in M1:P9 but my efforts have proven unsuccessful. |  |  |  |  |  |  |  | M:P but can't figure
 |  |  |  |  |  |  |  | out the formula to
 |  |  |  |  |  |  |  | make it work.
Spreadsheet: matthew_lenhart__26075__PG&E
Sheet: Adjustments & Maintanence

 |  | Supply | Demand
 |  |  | 250
 |  |  | 300
 |  |  | 150
 |  | 0 | 50
 |  | 0 | 50
 |  | 0 | 50
 |  | 0 | 50
 |  |  | 0
 |  |  | 50
 |  |  | 50
 |  |  | -250
 |  |  | -300