tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 648510d1573070617-sumifs-array-formula-ipu-scrap_2019-44
Sheet: Summary

 | Popis | 2019-10-28 00:00:00
1889 | OK celé kusy dle CO
 | OK celé kusy dle reálné ceny
 | SCRAP celé kusy dle CO
 | SCRAP celé kusy dle reálné ceny
 | SCRAP komponenty
 | % SCRAP dle CO
 | % SCRAP dle reálné ceny
2002 | OK celé kusy dle CO
 | OK celé kusy dle reálné ceny
 | SCRAP celé kusy dle CO
 | SCRAP celé kusy dle reálné ceny
 | SCRAP komponenty
 | % SCRAP dle CO
 | % SCRAP dle reálné ceny
2004 | OK celé kusy dle CO
 | OK celé kusy dle reálné ceny
 | SCRAP celé kusy dle CO
 | SCRAP celé kusy dle reálné ceny
 | SCRAP komponenty
 | % SCRAP dle CO
 | % SCRAP dle reálné ceny
 |  | 1889 | 1334 | Cena/kus dle CO
 |  | 2002 | 94.58 | Cena/kus dle CO
 |  | 2004 | 57.62 | Cena/kus dle CO
 |  | EUR | 25 | [NAME] pro 2019
Spreadsheet: john_arnold__15179__SSDSTF Datatables 97 June 00
Sheet: Table 2

TABLE 2
USE A SEPARATE SHEET FOR METRO & COUNTY
LABOR FORCE CHARACTERISTICS
Civilian Labor Force | Year 1 | Year 2 | Year 3 | Year 4 | Year 5
Unemployment Rate (for month & year use most recent information available and seasonally adjusted annual average)
Non-Agricultural Employment Reported by Place of Work | Total Number Employed |  |  |  | % of Total Employed Persons
 | Present Year | Last Year | 1990 | 5 Year Projection | Present Year | Last Year | 1990 | 5 Year Projection
Mining
Construction
Manufacturing
Transportation & Public Utilities
Wholesale Trade
Retail Trade
Finance, Insurance & Real Estate
Service
Government
Total
Resident Employment Reported by Group Occupation | Latest Available Year | 1990
Executive
Professional
Technician
Sales
Administrative/Clerical
Service
Farming & Forestry
Precision Production
Machine Operators
Transportation & Public Utilities
Laborers/Handlers
Private Household
Protected Service
Employed Residents Working in 1990 Outside | Number | Percent
the County Residence
Commute Times | Number | Percent
Less than 15 Minutes
15 - 29 Minutes
Over 30 Minutes
Median
Labor Participation Rate | Percentage (%)
Male
Female
Total
Education & Labor Force | Enrollment | Graduates
High School (Public/Private)
High School Students Enrolling in College |  | N/A
Community College (Full-Time)
4 Year University (Full-Time)
Military Presence | Civilian Employment |  | Military Personnel |  | Annual No. of Military Personnel Discharge |  | No. of Military Dependents
Names of Installations
Total
Spreadsheet: 142517d1329882731-excel-2007-consolidating-different-values-under-different-names-indifferent-tabs-to-master-sheet-varification-doc
Sheet: ROHTASH NAGAR

ROHTASH NAGAR |  |  |  |  |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9 |  |  |  | ROHINI 9
SNO | Part Code | Description | Qty | Qty (As on Date 16th Jan-2012)
Section-V,  Part A, SNO-3, 5 | PE-SV Router, PE-SDN Router |  | 1
Existing Material Redeployment
A | Power System
 | 200 AH Battery |  | 2
Spreadsheet: 880606d1728411492-automated-calendar-with-changing-holidays-vakantie-template-mbv-cadix_2
Sheet: september

 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Opgenomen vakantie | Resterende vakantie
 |  |  | 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
 | Maxime
VPK | [NAME]
 | Cédric
 | Elke
 | Ellen
 | Els
 | Gert
 | Ief
 | [NAME]
 | Joeri
 | [NAME]
 | Kelly
 | [NAME]
 | [NAME]
 | Michel
 | Mirthe
 | Nadia
 | Neslihan
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Aanwezig | 1
 | ADV | A
 | Vakantie | V
 | Ziek | Z
ZK | Annelies
 | Herly
 | Nadia
 | Nele
 | Ranka
 | Sid
 | Aanwezig | 1
 | ADV | A
 | Vakantie | V
 | Ziek | Z
[NAME] | [NAME]
 | [NAME]
 | Hilde
 | Samira
 | Vicky
 | Tyra
 | Aanwezig | 1
 | ADV | A
 | Vakantie | V
 | Ziek | Z
Spreadsheet: 162963d1340126478-total-count-conversion-status-echen-oeldere-
Sheet: Sheet1

Possible Product Conversions:
Converted | Vendor ID | Number of Visible Products
 | 118 | 3
 | 292 | 1
 | 223 | 44
 | 132 | 20
 | 942 | 16
x | 100 | 3
 | 734 | 2 |  |  | count Vendor ID | Kolomlabels
 | 160 | 12 |  |  | Rijlabels | x | Eindtotaal
 | 386 | 1 |  |  | 100 | 1 | 1
 | 129 | 9 |  |  | 120 | 1 | 1
 | 839 | 8 |  |  | 404 | 1 | 1
 | 481 | 1 |  |  | 464 | 1 | 1
 | 115 | 17 |  |  | 756 | 1 | 1
 | 257 | 6 |  |  | Eindtotaal | 5 | 5
 | 113 | 8
 | 164 | 6
 | 802 | 9
x | 464 | 2
 | 352 | 4
 | 39 | 11
 | 922 | 12
x | 120 | 4
 | 765 | 1
 | 322 | 15
 | 383 | 8
 | 1001 | 6
 | 1036 | 1
 | 762 | 14
 | 381 | 3
 | 30 | 7
 | 661 | 2
 | 403 | 6
 | 137 | 11
 | 114 | 7
x | 756 | 9
 | 467 | 3
 | 880 | 2
 | 314 | 6
 | 54 | 1
 | 807 | 9
 | 763 | 1
 | 1002 | 8
 | 887 | 10
 | 387 | 10
 | 370 | 4
 | 767 | 2
 | 240 | 5
 | 630 | 1
 | 427 | 3
 | 548 | 2
 | 738 | 7
 | 787 | 7
 | 108 | 48
 | 473 | 1
 | 650 | 2
 | 808 | 1
 | 662 | 4
 | 402 | 10
 | 474 | 3
 | 299 | 5
 | 429 | 5
 | 933 | 11
 | 62 | 6
 | 76 | 7
 | 399 | 9
 | 277 | 2
 | 940 | 5
 | 680 | 3
 | 459 | 16
 | 256 | 22
 | 651 | 9
 | 889 | 5
 | 452 | 1
 | 195 | 7
 | 25 | 17
 | 414 | 1
 | 78 | 13
 | 348 | 8
 | 850 | 2
x | 404 | 11
 | 278 | 2
 | 856 | 6
 | 881 | 5
 | 398 | 6
 | 1067 | 4
 | 862 | 7
 | 796 | 5
 | 549 | 2
 | 788 | 7
 | 379 | 12
 | 1062 | 9
 | 460 | 6
 | 623 | 5
 | 31 | 7
 | 342 | 17
 | 394 | 8
 | 369 | 12
 | 63 | 4
 | 306 | 9
 | 1074 | 2
 | 785 | 4
 | 847 | 5
 | 179 | 13
Spreadsheet: 141144d1329129416-problem-counting-text-in-excel-example
Sheet: Sheet1

Name | Sale
[NAME] | Yes
[NAME] | Yes
[NAME] | Yes
[NAME] | No
Sue | Yes
[NAME] | Yes
Adam | Yes
[NAME] | Yes
[NAME] | Yes
[NAME] | Yes
[NAME] | Yes
Sue | Yes
[NAME] | Yes
Adam | Yes
[NAME] | No
[NAME] | No
[NAME] | Yes
[NAME] | Yes
[NAME] | Yes
Sue | No
[NAME] | Yes
[NAME] | Yes
[NAME] | Yes
[NAME] | Yes
[NAME] | Yes
[NAME] | No
[NAME] | Yes
Adam | Yes
Adam | Yes
Spreadsheet: 09e6a2e2-2356-4f26-b5a7-d165817acf12
Sheet: IS103A

Team | [NAME] | Set | PPG | PPB | 15PG
Copley A | South Range Academic Challenge | IS103A | 382.5 | 21.32
[NAME] | South Range Academic Challenge | IS103A | 237.5 | 16.98
East Palestine | South Range Academic Challenge | IS103A | 99.2 | 12.59 | 0
LaBrae | South Range Academic Challenge | IS103A | 145.8 | 16.36 | 1
Lisbon | South Range Academic Challenge | IS103A | 33.3 | 8.18
Lowellville | South Range Academic Challenge | IS103A | 145 | 14.86
[NAME] B | South Range Academic Challenge | IS103A | 278.3 | 17.1
[NAME] C | South Range Academic Challenge | IS103A | 179.2 | 16.46 | 1
Solon A | South Range Academic Challenge | IS103A | 535.8 | 23.55
Solon B | South Range Academic Challenge | IS103A | 235.8 | 18.4
Solon C | South Range Academic Challenge | IS103A | 120.8 | 13.12
TCTC | South Range Academic Challenge | IS103A | 54.2 | 11.25
[NAME] | South Range Academic Challenge | IS103A | 535.8 | 25.58
Western Reserve | South Range Academic Challenge | IS103A | 76.7 | 11.9
Spreadsheet: 856567d1705768845-retrieving-and-moving-transferring-data-latest-problem-tashface-
Sheet: Feb Wk2

 | Main Total
2 | Week | Month | Year | Value
Spreadsheet: 770447d1646074535-vlookup-or-index-match-possibly-book1
Sheet: Data

Revenue |  | COS |  | SG&A
Spreadsheet: larry_campbell__21072__expense report SAP 8-2000
Sheet: Meals and Ent Sup

Employee Expense Report
Meals and Entertainment Supplement |  |  |  |  |  |  |  |  |  |  | Page
LAST NAME |  |  |  | FIRST NAME, INITIAL |  |  | TITLE |  |  |  | EMPLOYEE NUMBER
MEALS AND ENTERTAINMENT - Enter the cost of all meals (including food charges from hotel receipts) and entertainment.  Attach guest list for entertainment expense.  Meal: B = Breakfast,
L = Lunch, D = Dinner, R = Refreshments, T = Travel Status.  Assign a reference symbol for each accounting classification to be used.  Charges to be allocated do not require a reference symbol.
REF | Date | Meal |  | Location and Business Purpose |  |  |  | Guests |  |  | Cost/Qty | Rate | $ [NAME]
05 | 2000-08-03 00:00:00 | B,D | [NAME]. Remediatioin |  |  |  |  |  |  |  | 7.94 | 1
05 | 8/3/00 | L | [NAME]. Remediatioin |  |  |  |  | 7 members Laguna Team 3 members Tribe |  |  | 98.84 | 1
05 | 2000-08-07 00:00:00 | B,L,D | [NAME], Eunice Team |  |  |  |  |  |  |  | 13.7 | 1
05 | 2000-08-08 00:00:00 | B | [NAME], C/S No. 5, Thoreau |  |  |  |  |  |  |  | 3.78 | 1
05 | 2000-08-14 00:00:00 | B,L | Env. Team, Interim Review |  |  |  |  |  |  |  | 10.65 | 1
05 | 2000-08-16 00:00:00 | B | Env. Team, Interim Review |  |  |  |  |  |  |  | 24.33 | 1
05 | 2000-08-16 00:00:00 | D | Env. Team, Interim Review |  |  |  |  | Env. Team |  |  | 124.86 | 1
05 | 2000-08-18 00:00:00 | B,L,D | Env. Team, Interim Review |  |  |  |  |  |  |  | 2.87 | 1
05 | 2000-08-20 00:00:00 | D | [NAME] |  |  |  |  |  |  |  | 6.19 | 1
05 | 2000-08-21 00:00:00 | L | [NAME] |  |  |  |  | 11 Team Members |  |  | 93.58 | 1
05 | 2000-08-21 00:00:00 | B | [NAME] |  |  |  |  |  |  |  | 2.34 | 1
05 | 2000-08-21 00:00:00 | D | EOTT Pipeline Due Diligence |  |  |  |  | R.Loveless |  |  | 64.92 | 1
05 | 2000-08-22 00:00:00 | B | EOTT Pipeline Due Diligence |  |  |  |  |  |  |  | 5.01 | 1
05 | 2000-08-23 00:00:00 | L,D | EOTT Pipeline Due Diligence |  |  |  |  |  |  |  | 18.98 | 1
05 | 2000-08-24 00:00:00 | L,D | EOTT Pipeline Due Diligence |  |  |  |  |  |  |  | 6.97 | 1
 |  |  |  |  | Expense allocation |  |  |  | Allocated amount: |  | TOTAL
 |  |  |  |  | Enter an allocation factor next to each account receiving allocated |  |  |  |  | Total travel expense must be shown on Page 1,
 |  |  |  |  | charges.  Lines not assigned an allocation factor will not |  |  |  |  | Employee Expense Report Short Form.
 |  |  |  |  | receive an allocation; lines without a REF code will be allocated.
 |  |  |  |  | The total of all allocation factors must equal 1.
ACCOUNT [NAME]
Show the total amount for each accounting classification referenced above.
REF | GL Acct      Asset | GL Co Tr Ptr |  | Cost Center                           WBS Element |  |  | Order                                      Network |  | Material       Activity | Plant                      Func Area | ALLOC FACTOR |  | Amount
05 | 52003000 | 0060 | 111102 |  |  |  |  |  | 9000060
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Spreadsheet: 96649d1295990248-matching-columns-alphabetically-aardvarks
Sheet: Sheet1

aardvark | aardvark |  |  | aardvark | deer
bear |  |  |  | camel | llama
camel | camel |  |  | zebra | [NAME]
deer |  | deer
llama |  | llama
wildebeest
[NAME]
zebra | zebra
To make values constant (remove formulas), copy columns B and C and selecting B1  Paste Special>Values
Spreadsheet: 713338d1610652250-bulding-a-schedule-index-aggregate-dexter2-
Sheet: Summary

Vehicle | Start | End | # of Service Trips | Service | Break | Deadhead | Duration | Service Miles | [NAME] | Total Mileage
101 | 05:25:00 | 09:27:00 | 5 | 3:30:00 |  | 0:20:00 |  | 25 | 2.25
102 | 05:55:00 | 18:57:00 | 15 | 10:30:00 |  | 0:20:00 |  | 75 | 2.25
103 | 06:10:00 | 09:17:00 | 4 | 2:48:00 |  | 0:10:00 |  | 20 | 1.5
104 | 06:15:00 | 18:27:00 | 14 | 9:48:00 |  | 0:30:00 |  | 70 | 3
105 | 06:25:00 | 18:32:00 | 14 | 9:48:00 |  | 0:10:00 |  | 70 | 1.5
106 | 06:40:00 | 23:02:00 | 18 | 12:36:00 |  | 0:10:00 |  | 90 | 1.5
107 | 15:10:00 | 23:47:00 | 10 | 7:00:00 |  | 0:10:00 |  | 50 | 1.5
108 | 15:15:00 | 21:32:00 | 7 | 4:54:00 |  | 0:20:00 |  | 35 | 2.25
Totals
Spreadsheet: 213983d1360711456-searchability-of-excel-start1
Sheet: M6.13

DRAWING | DRAWING PLC-PT. | DRAW. TAG | PLANT NAME | O&M NAME | O&M LOCATION | Part NUMBER | Part NAME | MFG. | MODEL | S/N# | LEVEL | GENERAL AREA | ELE | SPECIFIC LOCATION | SERVICE LINE# | AREA SERVED | CONNECTION LINE# | BYPASS CONNECTION |  | TREND INFOR | MISC |  |  | CONDITION
M8.21 |  | T-12 | STEAM TRAP |  | Vol 5, Tab-(15522.2.01.G) | 032-789 | STEAM TRAP #CAU4-01 | ARM | 800 | N/A | R | [NAME] | 1' | ROOF CAU#4 HEATING COMPARTMENT | LPS | [NAME] | 2-1/2"-LPS-320 | 1 |  |  |  |  |  | NEW
M6.09 | M6.22 | FIT-1138 | XMITTER |  | Vol 6, Tab-(15900.2.0 ) | 032-150 | METER, #B1-06 FLOW GAS | ROSEMOUNT | 8800-DF020SA1N1D1M5Q4 | 165775 | 1 | BOILER-1 | 6' | EAST SIDE OF B1 (FUEL TRAIN) | LG | BOILER#1 | CPS-SP-LG-515
Spreadsheet: 88881d1288707139-conditional-formatting-with-multiple-and-or-criteria-em-example
Sheet: Sheet1

Sample Type | Location | Area | Date Sampled | Sample Name | Technician In Hood (If applicable) | CFU/FT3 | [NAME]? | If Yes, qty | Alert/ Action
Surface | CR1 | Floors | 2010-07-23 00:00:00 | 1SCF2 | N/A | 7 | No | 0
Surface | CR1 | Floors | 2010-08-05 00:00:00 | 1SCF2 | N/A | 6 | No | 0
Surface | CR1 | Floors | 2010-08-31 00:00:00 | 1SCF2 |  | 5 | No | 0
Surface | CR1 | Floors | 2010-09-10 00:00:00 | 1SCF2 |  | 6 | No | 0
Surface | CR1 | Floors | 2010-09-13 00:00:00 | 1SCF2 |  | 6 | Yes | 1
Air | CR1 | Room | 2010-07-16 00:00:00 | 1AC6 | N/A | 0.03 | Yes | 1
Air | PR1 | Room | 2010-07-19 00:00:00 | 1AP1 | N/A | 0.09 | No | 0
Air | MR1 | Room | 2010-07-19 00:00:00 | 1AM1 | N/A | 0.09 | Yes | 2
Air | CR1 | Hood | 2010-07-23 00:00:00 | 1AH9 | Not In Use | 0.03 | No | 0
Air | CR1 | Hood | 2010-07-26 00:00:00 | 1AH9 | Not In Use | 0.09 | No | 0
Surface | CR1 | Hood | 2010-09-23 00:00:00 | 1SCH8 | Empty | 3 | No | 0
Surface | MR1 | Floors | 2010-07-26 00:00:00 | 1SMF1 | N/A | 3 | No | 0
Surface | CR1 | Floors | 2010-07-26 00:00:00 | 1SCF1 | N/A | 3 | No | 0
Surface | PR1 | Floors | 2010-07-19 00:00:00 | 1SPF3 | N/A | 1 | Yes | 1
Surface | PR1 | Door | 2010-08-02 00:00:00 | 1SPD1 | N/A | 2 | No | 0
Surface | CR1 | Bins | 2010-09-08 00:00:00 | 1SCB1 | N/A | 0 | No | 0
Surface | CR1 | Pass-Thrus | 2010-07-22 00:00:00 | 1SCP2 | N/A | 1 | No | 0
Surface | CR1 | Tables | 2010-07-23 00:00:00 | 1SCT2 | N/A | 11 | Yes | 11
Surface | MR1 | Vault | 2010-08-17 00:00:00 | 1SMV1 | N/A | 0 | No | 0
Surface | CR1 | Walls | 2010-07-22 00:00:00 | 1SCW2 | N/A | 6 | Yes | 1
Spreadsheet: 121058d1315816605-highlight-lowest-10-entries-out-of-latest-20-entries-hc
Sheet: Sheet1

Round | Date | Score
31 | 2011-09-08 00:00:00 | 20
30 | 2011-09-07 00:00:00 | 90
29 | 2011-09-06 00:00:00 | 96 | 10th lowest
28 | 2011-09-05 00:00:00 | 108
27 | 2011-09-04 00:00:00 | 97
26 | 2011-09-03 00:00:00 | 89
25 | 2011-09-02 00:00:00 | 107
24 | 2011-09-01 00:00:00 | 83
23 | 2011-08-31 00:00:00 | 90
22 | 2011-08-30 00:00:00 | 92
21 | 2011-08-29 00:00:00 | 84
20 | 2011-08-28 00:00:00 | 104
19 | 2011-08-27 00:00:00 | 98
18 | 2011-08-26 00:00:00 | 96 | 10th lowest
17 | 2011-08-25 00:00:00 | 101
16 | 2011-08-24 00:00:00 | 96 | 10th lowest
15 | 2011-08-23 00:00:00 | 100
14 | 2011-08-22 00:00:00 | 95
13 | 2011-08-21 00:00:00 | 103
12 | 2011-08-20 00:00:00 | 94
11 | 2011-08-19 00:00:00 | 93
10 | 2011-08-18 00:00:00 | 109
9 | 2011-08-17 00:00:00 | 91
8 | 2011-08-16 00:00:00 | 86
7 | 2011-08-15 00:00:00 | 102
6 | 2011-08-14 00:00:00 | 87
5 | 2011-08-13 00:00:00 | 106
4 | 2011-08-12 00:00:00 | 110
3 | 2011-08-11 00:00:00 | 88
2 | 2011-08-10 00:00:00 | 99
1 | 2011-08-09 00:00:00 | 85
Spreadsheet: 724628d1616262509-randbetween-without-repeat-in-column-rand-with-no-repeats
Sheet: Answer

Name | Rand | RandNoRepeat |  |  | To do Random without repeats:
Name1 |  |  |  |  | Do a Rand() and then a Rank of those Rand()
[NAME]
Name3 |  |  |  |  | Press F9 a few times to see it recalc.
Name4
Name5
Name6
Name7
Name8
Name9
Name10
Name11
Name12
Name13
Name14
Name15
[NAME]
Name17
Name18
Spreadsheet: 728969d1618839265-anniversary-start-date-to-reset-employees-sick-leave-and-vacation-time-employee-attendance-record-thespa88-
Sheet: Company Holidays

 | Company Holidays
 | Company Holidays | Description
 |  | New Year's Day
 |  | President's Day
 |  | Independence Day
 |  | Thanksgiving
 |  | Thanksgiving
 |  | Christmas Eve
 |  | Christmas Day
 |  | Labor Day
 |  | New Year's Eve
Spreadsheet: 166194d1341498212-need-to-create-a-dependant-drop-down-controlled-through-2-prior-drop-downs-electrical-price-list-testing-sheet
Sheet: Calculation Sheet

Item No. | Category | Manufacturer | Item | Recommendation for Purchase | Recommended Price | No. of Items | Total Purchase Price |  |  |  | Cable | Manufacturers
 |  |  |  |  |  |  |  |  |  |  | Cable_Accessories | Wylex
1 | Lighting | Wylex | IP65 Round HF Polycarb Bulkhead  2D 16w Black/Opal Dia: 200 x 80mm |  |  | 13 |  |  |  |  | Lighting | Volex
2 | Lighting | Telco | IP65 Round HF Polycarb Bulkhead  2D 28w Black/Prismatic Dia: 200 x 80mm |  |  | 1 |  |  |  |  | Conduit | MK Logic Plus
3 | Lighting | Telco | IP65 Round HF Polycarb Bulkhead  2D 28w White/Prismatic Dia: 200 x 80mm |  |  | 4 |  |  |  |  | Distribution_Control_Gear | Telco
4 | Lighting | Telco | IP65 Square HF Polycarb Bulkhead  2D 28w White/Prismatic Dia: 200x200x80mm |  |  | 12 |  |  |  |  | Bits_and_Bobs | Generic
5 | Conduit | Generic | 20mm Four way |  |  | 3 |  |  |  |  | Wiring_Accessories
6 | Conduit | Generic | 20mm 'Y' Three way |  |  | 1
7 | Conduit | Generic | 20mm Conduit Couplings |  |  | 44
8 | Conduit | Generic | 20mm Adapter [NAME] |  |  | 49
9 | Conduit | Generic | 20mm Adapter Male Thread |  |  | 0
10 | Conduit | Generic | 20mm PVC 1G 32mm [NAME] |  |  | 8
11 | Conduit | Generic | PVC Blank Plate 1 Gang |  |  | 3
12 | Conduit | Generic | 20mm PVC 2G 32mm [NAME] |  |  | 16
13 | Conduit | Generic | PVC Blank Plate 2 Gang |  |  | 4
14 | Conduit | Generic | 20mm Inspection Tee |  |  | 4
15 | Conduit | Generic | Adaptable Box 75x75x41[NAME] |  |  | 3
16 | Conduit | Generic | 20mm Inpection Elbow |  |  | 7
17 | Conduit | Generic | 20mm Quick fit Inspection Bend |  |  | 13
18 | Conduit | Generic | 20mm slip bend |  |  | 1
19 | Conduit | Generic | 20mm [NAME] |  |  | 1
20 | Conduit | Telco | 20mm Quickfit spacer Saddle (100) |  |  | 1
Spreadsheet: 072799b0-6577-4f00-bb02-d40825262259
Sheet: EXP-Home

Expense Exhibit |  |  |  |  |  | EXP-Home
Insurance Company: | Insert Company Name
Form: | [NAME]
Expense Category | Expense Ratio  (% Premium) |  |  |  | Territory | Percent of Total Written Premium
(Add/Delete rows as needed) | Fixed | Variable | Total
Commissions |  |  |  |  | Wind Pool Zone 1 (with [NAME])
Taxes, Licenses, & Fees |  |  |  |  | Wind Pool Zone 2 (with [NAME])
Other Acquisition Expenses |  |  |  |  | Remainder
General Expenses |  |  |  |  | Total
Reinsurance Expenses
Other Expenses
Other Income
Profit and Contingencies
Total Expense and Profit Ratio
Permissible Loss and Fixed Expense Ratio
Insurer Notes:
Notes:
1.  Provide a copy of the actual Insurance Expense Exhibit as submitted with the Annual Statement
2.  Explain and support any significant variances between the expenses reported in this exhibit and the Insurance Expense Exhibit
3. Reinsurance Expenses should be net cost of reinsurance; a supporting exhibit showing the calculation of the provision is needed
4.  If "Other Expenses" or "Other Income" provisions included, then define (selected expense provisions should be reduced for anticipated fee income)
4a. When including a dividend provision, the company's dividend payment history, the company's current dividend practice, whether dividends are related to loss experience, the capitalization of the company, and other factors affecting the payment of dividends should be taken into account
5.  Profit and Contingencies percentage may not exceed 5.0% unless writing heavily on the coast with wind coverage
6.  [NAME] exhibit for each Form being filed
Spreadsheet: 833587d1687107472-complex-subtract-complex-subtract
Sheet: Sheet1

 | strike price | price |  | ANSWER
 | 17500 | 27.75
 | 17550 | 26.95
 | 17600 | 25.7
 | 17500 | -27.78 |  | 0.03
 | 17550 | 26.88
 | 17600 | 25.85
 | 17500 | 27.56
 | 17550 | 26.67
 | 17600 | 25.53
 | 17500 | 0 |  | 0
 | 17550 | 26.55
 | 17600 | 25.53
 | 17500 | 27.43
 | 17550 | 26.52
 | 17600 | 25.38
 | 17500 | 27.22
 | 17550 | 26.31
 | 17600 | 25.17
 | 17500 | 27.06
 | 17550 | 26.25
 | 17600 | 25.01
 | 17500 | 27.02
 | 17550 | 26.21
 | 17600 | 25.07
 | 17500 | 0 |  | 0
 | 17550 | 26.2
 | 17600 | 25.06
 | 17500 | 27.37
 | 17550 | 26.45
 | 17600 | 25.2
 | 17500 | 27.42
 | 17550 | 26.61
 | 17600 | 25.36
 | 17500 | 27.73
 | 17550 | 26.92
 | 17600 | 25.78
 | 17500 | 27.51
 | 17550 | 26.81
 | 17600 | 25.67
 | 17500 | 27.6
 | 17550 | 26.91
 | 17600 | 25.66
 | 17500 | 27.63
 | 17550 | 26.83
 | 17600 | 25.79
Spreadsheet: john_arnold__15329__Arnold_Results_4-4-00
Sheet: Time Vs. Greeks Overall

 | 1 Days | 2 Days | 3 Days | 4 Days | 5 Days | 6 Days | 7 Days | 14 Days | 21 Days | 31 Days
Delta | 9043557 | 8510162 | 8137299 | 5393826 | 7414248 | 7069326 | 6739936 | 4468147 | 40240876 | 44771113
Gamma | 44520084 | 47293777 | 50278503 | 53501198 | 56994696 | 60799718 | 64967745 | 113191241 | 29522524 | 33625577
Vega | -664116 | -664914 | -665841 | -666911 | -668138 | -669538 | -671127 | -690092 | -762817 | -802820
Theta | -87149 | -91309 | -95779 | -100598 | -105815 | -111490 | -117699 | -189471 | -64166 | -71615
Rho | -364541 | -364952 | -365366 | -365784 | -366205 | -366630 | -367060 | -370213 | -373813 | -374752
[NAME]. P/L | -83274 | -170604 | -262288 | -358655 | -459997 | -566688 | -679240 | -1698234 | -3657020 | -4326097
Spreadsheet: 88411d1288239765-finding-values-in-a-range-based-on-criteria-and-listing-them-consecutively-consecutivelistquestion
Sheet: Sheet1

 | Source Table
 | AmusinglyUnrelatedThings | SomeNonsensicalValues
 | Helicopter | Contrary
 | Book | Blue
 | Watch | Under
 | Ringtone | Blue
 | Somalia | Under
 | Desk | Apathetic
 | Sanity | Contrary
 | Flytrap | Blue
 |  | Using Index/Match only returns the first instance: |  |  | Pseudo-Excellish fantasy formula describing what I'm looking to do: |  |  |  |  |  |  |  | Results List that I would like to generate:
 |  | RESULTS LIST |  |  |  |  |  |  |  |  |  |  | RESULTS LIST I WANT
 |  |  |  | =index(AmusinglyUnrelatedThings,match(FIRST_INSTANCEOF"BLUE",SomeNonsensicalValues,0) |  |  |  |  |  |  |  |  | Book
 |  |  |  | =index(AmusinglyUnrelatedThings,match(NEXT_INSTANCEOF"BLUE",SomeNonsensicalValues,0) |  |  |  |  |  |  |  |  | Ringtone
 |  |  |  | =index(AmusinglyUnrelatedThings,match(NEXT_INSTANCEOF"BLUE",SomeNonsensicalValues,0) |  |  |  |  |  |  |  |  | Flytrap
 |  |  |  | Etc…
 |  |  |  | …preferably all preceded by the equivalent of:   =if(NO_"BLUE"_LEFT_IN_THIS_COLUMN,"",
 |  |  |  |  |  |  |  |  |  |  |  |  | I would like this list to be independently sortable (as in, sort without disturbing the source table)
Spreadsheet: 64901d1265727664-trouble-in-sum-of-daily-inventory-help
Sheet: Sheet1

Inventory
2010-01-02 00:00:00 | Stock box |  | 2010-01-03 00:00:00 | Stock box
[NAME] (6:12) | 12 |  | RoastBeef (1:2) | 30
ChickenGarlic (10:2) | 10 |  | Steak/Beef (5:10) | 10
ChickenRoasted (2:3) | 20 |  | [NAME] (12:20) | 12
ChickenStrips (1:6) | 10 |  | ChickenGarlic (2:3) | 10
Chicken/bacon (4:8) | 25 |  | ChickenRoasted (4:8) | 20
HAM (3:6) | 20 |  | ChickenStrips (2:10) | 10
HAM&Beef (3:2) | 25 |  | Chicken/bacon (3:9) | 25
RoastBeef (1:2) | 30 |  | HAM (3:7) | 20
Steak/Beef (5:1) | 10 |  | HAM&Beef (4:5) | 25
Total Weekly Inventory Stock
RoastBeef | 2 | <<< This number suppose to be  60
Steak/Beef
Chicken
ChickenGarlic
ChickenRoasted
ChickenStrips
Chicken/bacon
HAM
HAM&Beef