tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 684599d1593452557-formula-on-sheet-1-to-list-only-1-of-values-in-a-column-on-sheet-2-with-some-duplicates-duplicates_formula
Sheet: Overview

 |  | A | B | C |  |  |  | A | B | C
 | 1 | HEADER ROW |  |  |  |  | 1 | HEADER ROW
 | 2 | Dog |  |  |  |  | 2 |  | Dog
 | 3 | Cat |  |  |  |  | 3 |  | Cat
 | 4 | Bull |  |  |  |  | 4 |  | Cat
 | 5 | Cow |  |  |  |  | 5 |  | Cat
 | 6 | Donkey |  |  |  |  | 6 |  | Bull
 | 7 | Horse |  |  |  |  | 7 |  | Cow
 | 8 |  |  |  |  |  | 8 |  | Cow
 | 9 |  |  |  |  |  | 9 |  | Cow
 | 10 |  |  |  |  |  | 10 |  | Donkey
 | 11 |  |  |  |  |  | 11 |  | Horse
 | 12 |  |  |  |  |  | 12 |  | Horse
 | Sheet1 |  |  |  |  |  | Sheet2
 |  | Where duplicates exist in Sheet 2, Column B:B only one of each should be returned to Sheet 1 Column A
Spreadsheet: 788087d1658259110-implementing-a-few-restrictions-on-a-calendar-excel-shared-prototype-1
Sheet: November

 | Absence Type Key | V | Vacation |  |  | P | Personal |  |  | S | Sick |  |  | Custom 1 |  |  |  | Custom 2
 | November | Dates of Absence
 | Employee Name | 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 | Total Days
 | Employee 1
 | Employee 2
 | Employee 3
 | Employee 4
 | Employee 5
Spreadsheet: 756543d1637621366-retrieve-hours-worked-based-on-day-of-week-in-rota-rota
Sheet: January

 | 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 | MON
 | 2021-01-01 00:00:00 | 2021-01-02 00:00:00 | 2021-01-03 00:00:00 | 2021-01-04 00:00:00 | 2021-01-05 00:00:00 | 2021-01-06 00:00:00 | 2021-01-07 00:00:00 | 2021-01-08 00:00:00 | 2021-01-09 00:00:00 | 2021-01-10 00:00:00 | 2021-01-11 00:00:00 | 2021-01-12 00:00:00 | 2021-01-13 00:00:00 | 2021-01-14 00:00:00 | 2021-01-15 00:00:00 | 2021-01-16 00:00:00 | 2021-01-17 00:00:00 | 2021-01-18 00:00:00 | 2021-01-19 00:00:00 | 2021-01-20 00:00:00 | 2021-01-21 00:00:00 | 2021-01-22 00:00:00 | 2021-01-23 00:00:00 | 2021-01-24 00:00:00 | 2021-01-25 00:00:00 | 2021-01-26 00:00:00 | 2021-01-27 00:00:00 | 2021-01-28 00:00:00 | 2021-01-29 00:00:00 | 2021-01-30 00:00:00 | 2021-01-31 00:00:00 |  | Total Hours
[NAME]
Scott
Adam
 | 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 | MON
 | 2021-01-01 00:00:00 | 2021-01-02 00:00:00 | 2021-01-03 00:00:00 | 2021-01-04 00:00:00 | 2021-01-05 00:00:00 | 2021-01-06 00:00:00 | 2021-01-07 00:00:00 | 2021-01-08 00:00:00 | 2021-01-09 00:00:00 | 2021-01-10 00:00:00 | 2021-01-11 00:00:00 | 2021-01-12 00:00:00 | 2021-01-13 00:00:00 | 2021-01-14 00:00:00 | 2021-01-15 00:00:00 | 2021-01-16 00:00:00 | 2021-01-17 00:00:00 | 2021-01-18 00:00:00 | 2021-01-19 00:00:00 | 2021-01-20 00:00:00 | 2021-01-21 00:00:00 | 2021-01-22 00:00:00 | 2021-01-23 00:00:00 | 2021-01-24 00:00:00 | 2021-01-25 00:00:00 | 2021-01-26 00:00:00 | 2021-01-27 00:00:00 | 2021-01-28 00:00:00 | 2021-01-29 00:00:00 | 2021-01-30 00:00:00 | 2021-01-31 00:00:00
[NAME]
Scott
Adam
Spreadsheet: 851854d1701972565-need-help-converting-a-google-sheets-formula-to-excel-scheduling-test1
Sheet: Cut Only

T1 | 37.63 | Total hours |  |  |  |  | 2023-11-30 00:00:00 |  | 11:59:19
Time to Print | Job # | Line # | Customer | QTY | H | W | Material | Sides to Print | [NAME] | Due Date | Est. usage | PRESS | Notes
 | 242111 | 1 | Caleres | 4050 | 28 | 47 | PAP-SO-1374 - FOAMCORE 3/16IN WHITE 48X96 | 2 | 4 Pass | 2024-01-15 00:00:00 |  | CUT ONLY | For production quote- [NAME]
Spreadsheet: 270157d1381405480-combining-two-excel-formulas-sample
Sheet: Sheet1

Formula A
[NAME]
Date | Project e.g. HFI | Task Number | CR/INFRA number | Task Description | CR Client | Assigned to | [NAME] (QA) | Expected Delivery from Dev to QA (i.e. [NAME] plus 1 day) | QA Target Completion Date (from Dev Plan QA Finish Date) to meet planned delivery deadline PRIORITY | "R" Ready for Testing | Task Status | Helper Column To Fetch CR Number Below formula is array formula after any change hold control and shift then hit enter | Column For Counting Unique Values which can be hidden after words
2009-09-29 00:00:00 | IF Only |  | CR1954 |  |  |  |  |  |  | R | P
2009-04-13 00:00:00 |  |  | INT006 |  |  |  |  |  |  | R | ON HOLD
2010-02-01 00:00:00 | IF Only |  | INT016 |  |  |  |  |  |  |  | P
2010-02-01 00:00:00 | IF only |  | INT019 |  |  |  |  |  |  | R | ON HOLD
 | IF |  | INT062 |  |  |  |  |  |  |  | P
2010-06-22 00:00:00 | WS |  | INT062 |  |  |  |  |  |  | R | P
2011-01-10 00:00:00 | BO |  | INT062 |  |  |  |  |  |  | R | P
2010-10-04 00:00:00 | BO/IF |  | INT062 |  |  |  |  |  |  |  | P
2009-10-13 00:00:00 | ENC | Encore | ENC0013 |  |  |  |  |  |  | R
2009-11-12 00:00:00 | ENC | Encore | ENC0010 |  |  |  |  |  |  |  | P
2009-11-12 00:00:00 | ENC |  | ENC0012 |  |  |  |  |  |  | ? See comments
2011-08-01 00:00:00 | BO/IF |  | R172233 |  |  |  |  |  |  | R | P
2011-10-13 00:00:00 | WS |  | LSR-INT-030 |  |  |  |  |  |  |  | P
2012-01-17 00:00:00 |  |  | CR160 |  |  |  |  |  |  |  | P
2012-02-08 00:00:00 | IF |  | CR160 |  |  |  |  |  |  |  | P
2012-03-16 00:00:00 |  |  | CR160 |  |  |  |  |  |  |  | P
 |  |  |  |  |  |  |  |  |  |  | Results--->
Spreadsheet: bf8f1a65-f017-4f46-b5bb-e48d13f57702
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
3163 | 8205 | [NAME] | Britton | CAN | 0 | 00:08:22 | 00:00:27 | 00:15:34 | 00:00:32 | 00:09:44 | 1 | [NAME]
3163 | 13178 | Kerry | [NAME] | USA | 0 | 00:08:48 | 00:00:27 | 00:15:22 | 00:00:32 | 00:09:37 | 2 | 00:34:46
3163 | 17239 | Trevor | [NAME] | USA | 0 | 00:08:36 | 00:00:21 | 00:16:44 | 00:00:30 | [NAME] | 3 | 00:35:05
3163 | 17240 | Ramses | Ambrozio | MEX | 0 | 00:09:16 | 00:00:22 | 00:15:32 | 00:00:30 | 00:10:14 | 4 | 00:35:54
3163 | 17241 | [NAME] | Vargas | MEX | 0 | 00:08:44 | 00:00:30 | 00:18:31 | 00:00:42 | 00:10:32 | 5 | 00:38:59
3163 | 17242 | [NAME] | [NAME] | MEX | 0 | 00:12:54 | 00:00:54 | 00:21:13 | [NAME] | 00:11:49 | 6 | 00:47:43
Spreadsheet: 753267d1635337600-process-pipeline-example
Sheet: 工作表1

Input | process1 | process2 | process3 | Output |  | Func1 | if(value>100,value*2,value)
 | A10 | Func1 | 10 |  |  | Func2 | power(value,3)
10 |  | 5126 | 51260 | 51260 |  | Func3 | value*3.14+18
3
Spreadsheet: phillip_m_love__30151__9906_OA
Sheet: WE-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 25709008 | 52991795
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 21934545 | 46926648
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 47643553 | 99918443
 | Purchases:
6 |  | 3rd Party / Inter Enron | -24975750 | -50478903
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -22817932 | -48452350
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 295007 | 597680
 | Total Purchases: |  | -47498675 | -98333573
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 | Imbalances:
13 |  | In Kind | 117016 | 236652
14 |  | Cash Out | -187316 | -375003
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | -70300 | -138351
 | Storage:
17 |  | Injection (Sales to Stg) | 48029 | 92436
18 |  | W/D (Purchase from Stg) | -83901 | -160416
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -83901 | -160416
 | Total Storage: |  | -35872 | -67980
20 | Linepack: |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
22 | UA4: |  | -38706 | -80494.02376637961
23 | Fuel: |  | -295007 | -597680
 | Transport Expense:
24 |  | Commodity | 0 | -172911.24
25 |  | Demand | 0 | -1321394.46
 | Total Transport Expense: |  | 0 | -1494305.7
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | 2029682
31 |  | Prior Month Book Balance | 0 | -1493590
 |  | Total MTM Income | 0 | 536092
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 20312
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | -23097
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 51876
 |  | TOTAL INTRA-MTH
FT-West
 |  | Current Month MTM | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Financial Liquidations | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Originations | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 267280d1380033687-calculating-the-finishing-time-based-where-order-exceeds-1-working-shift-working-hours-calculation
Sheet: Sheet1

Standard Start/End Times |  | START |  | FINISH |  | Breaks | Total Hrs Worked | Estimated Duration in Minutes | Estimated Completion Date
Start | End | Date | Time | Date | Time
08:00:00 | 16:30:00 | 2013-08-01 00:00:00 | 08:00:00 | 2013-08-05 00:00:00 | 16:30:00 | 01:00:00 |  | 640
Spreadsheet: a80776ba-9b4d-40ad-b2c4-503dc1586649
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
KUR | Test | KUR | Potassium, [NAME] | Potassium, U | Potentiometric, Indirect Ion-Selective Electrode | [NAME], 24-hour graduated: 24Urine |  |  | 5 | mL | Container/Tube: Plastic, 6-mL tube (Supply T465) [NAME]: 5 mL Collection Instructions: 1. Collect urine for 24 hours. 2. Add 25 mL of 50% acetic acid as preservative at start of collection. Additional Information: 1. 24-Hour volume is required. 2. [NAME] collected with toluene urine collected with no preservative if kept refrigerated continuously is acceptable. 3. See [NAME] in Special Instructions for multiple collections.   Urine Preservative Collection Options   Ambient	Yes Refrigerated	Preferred Frozen	Yes 6N HCl	Yes 50% Acetic Acid	Yes Na(2)CO(3)	Yes Toluene	Yes 6N HNO(3)	Yes Boric Acid	Yes Thymol	Yes | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 17-77 mmol/24 hours | Monday through Sunday Varies | Same day/1 day | 2 days | 1 | 84133 |  |  |  |  | Rochester
KUR | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
KUR | Order Question | TM28 | Collection Duration |  | Plain Text
KUR | Order Question | VL26 | [NAME] |  | Plain Text
KUR | Result | KURU | Potassium, 24 Hr, U | Potassium, 24 Hr, U | Numeric |  |  |  |  | mmol/24 h |  |  |  |  |  |  |  |  |  | 51720-1 | Potassium:MRat:24H:Urine:Qn:
KUR | Result | TM28 | Collection Duration | Collection Duration | Numeric |  |  |  |  | h |  |  |  |  |  |  |  |  |  | 13362-9 | Collection duration:Time:*:Urine:Qn:
KUR | Result | VL26 | [NAME] | [NAME] | Numeric |  |  |  |  | mL |  |  |  |  |  |  |  |  |  | 3167-4 | [NAME] volume:Vol:24H:[NAME]:Qn:
KUR | Result | K_CN | Potassium Concentration | Potassium Concentration | Numeric |  |  |  |  | mmol/L |  |  |  |  |  |  |  |  |  | 21476-7 | Potassium:SCnc:24H:[NAME]:Qn:
Spreadsheet: 181886d1348180912-choosing-min-max-of-references-with-multiple-occurence-minmaxexamplebb
Sheet: Sheet1

ID | In | Out |  |  | MIN | MAX
31 | 2012-09-05 00:04:23 | 2012-09-07 00:11:19 |  | 31
31 | 2012-09-06 00:15:21 | 2012-09-06 00:20:22 |  | 86
31 | 2012-09-05 23:58:06 | 2012-09-06 00:05:20
86 | 2012-09-05 11:37:12 | 2012-09-05 11:44:14
86 | 2012-09-05 11:49:17 | 2012-09-05 11:54:14
86 | 2012-09-05 11:44:17 | 2012-09-05 11:49:14
31 | 2012-09-06 00:10:22 | 2012-09-06 00:15:18
Spreadsheet: darrell_schoolcraft__7776__imbalsumm0106
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 |  | -34845
9238 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
56422 |  | -1863018
58710 | -35707 | -6114
60921 |  | 1280106
78026 | 5896 | 54373
500084 |  | -19000
500085
500097
INDEX
2001-05-31 00:00:00 |  |  | 597578.71
2001-06-19 00:00:00
Spreadsheet: 681615d1591669405-trouble-with-custom-sort-excel-sort-category
Sheet: Sorted Outcome

A | W
 | D | 7 | 5 | 5 | 3
 | S | 6 | 5 | 3 | 2
 | DB | 0,0,1,0,0,0,0 | 0,0,0,0,0,0 | 1,0,0,1 | 0,0,1
A | L
 | D | 0 | 1 | 3 | 4 | 2 | 2 | 1
 | S | 0 | 1 | 1 | 0 | 1 | 0 | 0
 | DB | 0 | 0,0 | 0,2 | 0 | 0,1 | 0 | 0
A | SL
 | D | 1 | 8 | 1 | 3 | 4 | 1 | 1 | 3 | 5 | 1
 | S | 0 | 5 | 1 | 2 | 2 | 0 | 1 | 1 | 1 | 1
 | DB | 0 | 0,0,0,0,3,0 | 0,0 | 0,0,1 | 0,0,2 | 0 | 0,0 | 2,0 | 2,2 | 0,0
C | W
 | D | 4 | 11 | 6 | 6 | 5
 | S | 1 | 2 | 2 | 2 | 2
 | DB | 1,2 | 3,1,5 | 1,2,1 | 0,1,3 | 0,3,0
C | L
 | D | 3 | 1 | 1 | 4 | 0 | 2 | 0 | 1 | 3
 | S | 0 | 1 | 1 | 2 | 0 | 1 | 0 | 1 | 0
 | DB | 0 | 0,0 | 0,0 | 1,0,1 | 0 | 0,1 | 0 | 0 | 0
C | SL
 | D | 0 | 1 | 1 | 0 | 1 | 0 | 2
 | S | 0 | 0 | 0 | 0 | 0 | 0 | 2
 | DB | 0 | 0 | 0 | 0 | 0 | 0 | 0,0
J | W
 | D | 3 | 5 | 10 | 4 | 2
 | S | 2 | 2 | 7 | 2 | 1
 | DB | 0,0,1 | 0,2,1 | 0,1,0,1,1,0,0,0 | 0,2,0 | 0,1
J | L
 | D | 1 | 3 | 0 | 1 | 0 | 1 | 2
 | S | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | DB
J | SL
 | D | 2 | 1 | 3 | 1 | 0 | 1 | 4 | 4 | 2 | 1 | 0
 | S | 2 | 0 | 2 | 0 | 0 | 0 | 2 | 2 | 2 | 1 | 0
 | DB | 0,0,0 |  | 0,1,0 |  |  |  | 0,1,1 | 1,1,0 | 0,0,0 | 0,0
L | W
 | D | 6 | 1 | 10 | 3 | 5 | 4 | 6 | 3
 | S | 3 | 1 | 2 | 1 | 0 | 2 | 4 | 1
 | DB | 1,0,0,2 | 0,0 | 2,1,4 | 1,1 | 0 | 1,0,1 | 0,0,0,0,0,1 | 0,2
L | L
 | D | 2 | 3 | 0 | 2 | 1 | 5 | 1 | 3 | 1 | 0 | 1 | 5 | 3 | 2
 | S | 0 | 0 | 0 | 1 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 0
 | DB | 0 | 0 | 0 | 1,0 | 0,0 | 1,1,1 | 0 | 0 | 0 | 0 | 0 | 2,1,0 | 0,2 | 0
L | SL
 | D | 1 | 0 | 1 | 1 | 1 | 0
 | S | 1 | 0 | 0 | 1 | 0 | 0
 | DB | 0,0 | 0 | 0 | 0,0 | 0 | 0
Spreadsheet: 746120d1630513308-getting-value-instead-of-result-book1
Sheet: Cheque Nums

Please insert date | 2021-01-22 00:00:00
Example | 1500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D/D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14444
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 67654
Spreadsheet: 0ec3e80b-b959-4c15-82ef-e03af2b3817f
Sheet: HNW case

Paul & Patty
Large Estate - Trusts A/B/C Allocations
 |  |  |  |  |  | A | B | C
 |  | Joint | [NAME]'s | [NAME]'s |  | [NAME]'s | Bypass | [NAME]
 |  | Value | 50% of Jt. | Separate |  | Trust | Trust | Trust
Primary Residence |  | 2000000
Rental 1 |  | 1600000
Rental 2 |  |  |  | 1000000
45% Interest in Son's House |  |  |  | 800000
Cash Accounts |  | 200000
Brokerage Accounts |  | 600000 |  | 1000000
Wells Fargo Stock |  |  |  | 200000
Loans to Children |  | 200000
Municipal Bond Mutual Funds |  | 1000000
Life Insurance on Husband (to Wife) |  | 1200000
401(k)-Husband (to Wife) |  | 800000
IRA-Husband (to Wife) |  | 300000
Personal Property |  | 100000
Totals
Target Allocations |  |  |  |  | 4000000 | 4000000 | 5000000 | 2000000
 |  |  | Out-of-balance
Liquidity for Patty
Spreadsheet: 65548d1266273456-find-a-value-across-multiple-sheets-in-another-workbook-sales-orders_2010
Sheet: SalesJun

Expected Sales Proceeds For JANUARY 2010
 |  |  |  |  |  |  | FX | 0.9135
 | INVOICE | INVOICE DATE | CUSTOMER | PRODUCT | Quantity | PRICE        USD / MT | AMOUNT (USD) | AMOUNT (AUD)
EXPORT
 | 100606 | 2010-06-12 00:00:00 | Customer1 | Product1 | 10000 | 0.1555 | 1555 | 1702.24411603722
 | 100607 | 2010-06-13 00:00:00 | Customer2 | Product2 | 20000 | 0.12775 | 2555 | 2796.934865900383
 | 100608 | 2010-06-14 00:00:00 | Customer3 | Product3 | 30000 | 0.1185 | 3555 | 3891.625615763547
 | 100609 | 2010-06-15 00:00:00 | Customer4 | Product4 | 40000 | 0.113875 | 4555 | 4986.316365626711
 | 100610 | 2010-06-16 00:00:00 | Customer5 | Product5 | 50000 | 0.1111 | 5555 | 6081.007115489874
 | 100611 | 2010-06-17 00:00:00 | Customer6 | Product6 | 60000 | 0.10925 | 6555 | 7175.697865353038
 | 100612 | 2010-06-18 00:00:00 | Customer7 | Product7 | 70000 | 0.1079285714285714 | 7555 | 8270.388615216201
 | 100613 | 2010-06-19 00:00:00 | Customer8 | Product8 | 80000 | 0.1069375 | 8555 | 9365.079365079366
 | 100614 | 2010-06-20 00:00:00 | Customer9 | Product9 | 90000 | 0.1061666666666667 | 9555 | 10459.77011494253
DOMESTIC
Spreadsheet: 869534d1716127564-empty-row-after-every-group-of-data-book1-gk-v2
Sheet: Sheet1

 |  | User Enter three columns |  |  |  |  |  |  |  |  |  |  |  | Count of Product
 |  | Region | Employee | Product |  |  |  |  |  |  |  |  |  | Region | Employee | Pro-1 | Pro-2 | Pro-3 | Pro-4
 |  | REG-1 | Emp-1 | Pro-1 |  |  |  |  |  |  |  |  |  | REG-1 | Emp-1 | 1 | 0 | 0 | 0
 |  | REG-1 | Emp-2 | Pro-2 |  |  |  |  |  |  |  |  |  |  | Emp-2 | 0 | 1 | 0 | 0
 |  | REG-1 | Emp-3 | Pro-4 |  |  |  |  |  |  |  |  |  |  | Emp-3 | 0 | 0 | 0 | 1
 |  | REG-1 | Emp-4 | Pro-2 |  |  |  |  |  |  |  |  |  |  | Emp-4 | 0 | 1 | 0 | 0
 |  | REG-1 | Emp-5 | Pro-1 |  |  |  |  |  |  |  |  |  |  | Emp-5 | 1 | 0 | 0 | 0
 |  | REG-1 | Emp-6 | Pro-2 |  |  |  |  |  |  |  |  |  |  | Emp-6 | 0 | 1 | 0 | 0
 |  | [NAME] | Emp-1 | Pro-3 |  |  |  |  |  |  |  |  |  | REG-1 Total |  | 0.3333333333333333 | 0.5 | 0 | 0.1666666666666667
 |  | [NAME] | Emp-2 | Pro-2 |  |  |  |  |  |  |  |  |  | [NAME] | Emp-1 | 0 | 0 | 1 | 0
 |  | [NAME] | Emp-3 | Pro-3 |  |  |  |  |  |  |  |  |  |  | Emp-2 | 0 | 1 | 0 | 0
 |  | [NAME] | Emp-4 | Pro-2 |  |  |  |  |  |  |  |  |  |  | Emp-3 | 0 | 0 | 1 | 0
 |  | REG-3 | Emp-1 | Pro-3 |  |  |  |  |  |  |  |  |  |  | Emp-4 | 0 | 1 | 0 | 0
 |  | REG-3 | Emp-2 | Pro-2 |  |  |  |  |  |  |  |  |  | REG-2 Total |  | 0 | 0.5 | 0.5 | 0
 |  | REG-3 | Emp-3 | Pro-3 |  |  |  |  |  |  |  |  |  | REG-3 | Emp-1 | 0 | 0 | 1 | 0
 |  | REG-3 | Emp-4 | Pro-2 |  |  |  |  |  |  |  |  |  |  | Emp-2 | 0 | 1 | 0 | 0
 |  | REG-4 | Emp-1 | Pro-3 |  |  |  |  |  |  |  |  |  |  | Emp-3 | 0 | 0 | 1 | 0
 |  | REG-4 | Emp-2 | Pro-1 |  |  |  |  |  |  |  |  |  |  | Emp-4 | 0 | 1 | 0 | 0
 |  | REG-4 | Emp-3 | Pro-3 |  |  |  |  |  |  |  |  |  | REG-3 Total |  | 0 | 0.5 | 0.5 | 0
 |  | REG-4 | Emp-4 | Pro-2 |  |  |  |  |  |  |  |  |  | REG-4 | Emp-1 | 0 | 0 | 1 | 0
 |  | REG-5 | Emp-5 | Pro-1 |  |  |  |  |  |  |  |  |  |  | Emp-2 | 1 | 0 | 0 | 0
 |  | REG-5 | Emp-6 | Pro-3 |  |  |  |  |  |  |  |  |  |  | Emp-3 | 0 | 0 | 1 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Emp-4 | 0 | 1 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | REG-4 Total |  | 0.25 | 0.25 | 0.5 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | REG-5 | Emp-5 | 1 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Emp-6 | 0 | 0 | 1 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | REG-5 Total |  | 0.5 | 0 | 0.5 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total |  | 0.2 | 0.4 | 0.35 | 0.05
Spreadsheet: 166747d1341767626-football-prediction-spreadsheet-empty-master-forecast-sheet
Sheet: Results

 | HOME |  |  | AWAY
hvalue | DERBY SCORE | OPPONENT SCORE | OPPONENT | OPPONENT SCORE | DERBY SCORE | avalue
 |  |  | BARNSLEY
 |  |  | BIRMINGHAM CITY
 |  |  | BLACKBURN
 |  |  | BLACKPOOL
 |  |  | BOLTON
 |  |  | BRIGHTON
 |  |  | BRISTOL CITY
 |  |  | BURNLEY
 |  |  | CARDIFF CITY
 |  |  | CHARLTON
 |  |  | CRYSTAL PALACE
 |  |  | HUDDERSFIELD TOWN
 |  |  | HULL CITY
 |  |  | IPSWICH TOWN
 |  |  | LEEDS UNITED
 |  |  | LEICESTER CITY
 |  |  | MIDDLESBOROUGH
 |  |  | MILLWALL
 |  |  | NOTTINHAM FOREST
 |  |  | PETERBOROUGH UTD
 |  |  | SHEFFIELD WED
 |  |  | WATFORD
 | 4 | 4 | WOLVERHAMPTON | 4 | 0
Spreadsheet: e90171b4-b95c-4db7-905e-33f7b4ad1e4f
Sheet: Sheet1

IUA Professional Lines Underwriting Group: Professional Liability Data Template (2011) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Item Number | Description | Format | Notes
1* | Row number | Number | Arbitrary number sequence to aid identification of individual risks
2* | Insured | Text
3* | Domicile | Text
4* | Class | Text
5* | Profession/trade | Text
6 | Original rating base | Text | Example: Fee income, asset size, turnover (including currency description)
7 | Original rating base amount | Number
8 | Lloyd's Risk Code | Text | Example: BB, D4, D5, F2, F3
9* | Stacking Code | Text or Number | Links all risks which would be exposed vertically to the same loss
10 | Unique Market Reference | Text or Number | Standard market format
11 | Policy identification | Text | If open market use OM, if declaration from a lineslip/binder use DEC
12* | TreatyYear | Date
13* | Inception | Date
14* | [NAME] | Date
15 | Policy type | Text | If period greater than 18 months, please indentify if Single project, LTA, Extended reporting/Run-off period
16* | Currency of Limit and Excess | Text | Three letter currency code, no symbols
17* | 100% Limit | Number | Gross 100% limit
18 | Limit indicator 1 | Text | "Aggregate" or "any one claim" basis
19 | Limit indicator 2 | Text | "Costs in addition" or "Costs inclusive"
20* | 100% Excess | Number | Gross 100% excess
21 | Excess indicator | Text | "Aggregate" or "any one claim" basis
22 | Self Insured Retention / Original Deductible | Number | Original currency
23 | SIR/Orig deductible indicator | Text | "Aggregate" or "any one claim" basis
24* | Original Premium Currency | Text | Three letter currency code, no symbols
25* | 100% Premium | Number | Gross 100% Premium
26* | Premium currency | Text | Three letter currency code, no symbols
27* | 100% Premium | Number | Gross 100% Premium
28* | Original deductions and commissions | Number | Percentage expressed between 0 and 100 (and not formatted as a Percentage between 0 and 1)
29* | Written Line | Number | Percentage expressed between 0 and 100
30* | [NAME] (Final Share of Whole) | Number | Percentage expressed between 0 and 100
31* | Applicable Agreement Currency | Text | Three letter currency code, no symbols
32* | Reinsured's net liability | Number | Converted to Applicable Agreement Currency NET of inuring reinsurance
33* | Reinsured's premium | Number | Applicable to this reinsurance NET of inuring facultative reinsurance. This premium should be on an identical basis to the treaty income adjustment base.
34 | Layer Lead | Text
NOTE | If any lineslip/binder exposes this reinsurance and individual declarations cannot be provided then please
 | supply a separate list of all such lineslip/binders with the [NAME]'s line size and full year income estimate.
 | Ideally a separate per insured profile should be supplied for each such lineslip/binder
 | * DENOTES A MANDATORY FIELD