tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 673559d1587446079-display-combined-average-of-a-range-with-criteria-in-rows-and-columns-kpi-pack-excel-forum
Sheet: KPI REPORT

 |  | KPI Report |  |  | 2020-01-05 00:00:00 | 2020-01-12 00:00:00 | 2020-01-19 00:00:00 | 2020-01-26 00:00:00 | 2020-02-02 00:00:00 | 2020-02-09 00:00:00
 |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6
 | KPI's
 | INBOUND
 | KPI 1: Dock to Stock (excl returns) - DTS
 |  |  | Target | 0.95 | 0.95 | 0.95 | 0.95 | 0.95 | 0.95 | 0.95
 | QLD
1 | QLD -1 |  |  | % | 1 | 0.97 | 1 | 0.99 | 1 | 0.985
2 | QLD -2 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
3 | QLD -3 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
4 | QLD -4 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
5 | QLD -5 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
6 | QLD -6 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
7 | QLD -7 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
8 | QLD -8 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
9 | QLD -9 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
10 | QLD -10 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
11 | QLD -11 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
12 | QLD -12 |  |  | % | 1 | 1 | 1 | 1 | 0.995 | 1
13 | QLD -13
 |  |  | TOTAL - QLD | %
 | WA
1 | WA -1 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
2 | WA -2 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
3 | WA -3 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
4 | WA -4 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
5 | WA -5 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
6 | WA -6 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
7 | WA -7 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
 |  |  | TOTAL - WA | % | 1 | 1 | 1 | 1 | 1 | 1
 | VIC
1 | VIC -1 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
2 | VIC -2 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
3 | VIC -3 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
4 | VIC -4 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
5 | VIC -5 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
6 | VIC -6 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
7 | VIC -7 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
8 | VIC -8 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
 |  |  | TOTAL - VIC | % | 1
 | NSW
1 | NSW - 1 |  |  | % | 1 | 1 | 0.978 | 1 | 0.994 | 1
2 | NSW - 2 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
3 | NSW - 3 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
4 | NSW - 4 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
5 | NSW - 5 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
6 | NSW - 6 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
7 | NSW - 7 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
8 | NSW - 8 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
9 | NSW - 9 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
10 | NSW - 10 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
11 | NSW - 11 |  |  | % | 1 | 1 | 1 | 0.99 | 0.9623 | 0.964
12 | NSW - 12 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
13 | NSW - 13
 |  |  | TOTAL - NSW | % | 1
 | SA
1 | SA -1 |  |  | % | 1 | 1 | 1 | 0.952 | 0.993 | 0.973
2 | SA -2 |  |  | % | 1 | 1 | 1 | 1 | 1 | 1
 |  |  | TOTAL - SA | %
Spreadsheet: 138647d1327782070-excel-2007-macro-for-inserting-rows-with-formulas-test-populated
Sheet:  170-210

Phase | Task | Description |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Labor Total | Quantity | Unit | Unit Price | Owned Equipment | Rented Equipment | Material | Subs | Other | [NAME] % | [NAME] Cost | Total Cost
 |  |  |  |  |  |  |  |  |  | Hours | Hours | Hours | Hours | Hours | Hours | Hours
 | 10
 |  | Subtotals
 | 20
 |  | Subtotals
 | 30
 |  | Subtotals
 | 40
PHASE 170 - |  | Subtotals
 | 50
 |  | Subtotals
 | 60
 |  | Subtotals
95 |  | Phase 170 Total
 | 10
 |  | Subtotals
 | 20
 |  | Subtotals
 | 30
 |  | Subtotals
 | 40
PHASE 175 - |  | Subtotals
 | 50
 |  | Subtotals
 | 60
 |  | Subtotals
 |  | Phase 175 Total
 | 10
 |  | Subtotals
 | 20
 |  | Subtotals
 | 30
 |  | Subtotals
 | 40
PHASE 180 - |  | Subtotals
 | 50
 |  | Subtotals
 | 60
 |  | Subtotals
 |  | Phase 180 Total
 | 10
 |  | .
 |  | Subtotals
 | 20
 |  | Subtotals
 | 30
 |  | Subtotals
 | 40
PHASE 185 - |  | Subtotals
 | 50
 |  | Subtotals
 | 60
 |  | Subtotals
 |  | Phase 185 Total
 | 10
 |  | .
 |  | Subtotals
 | 20
 |  | Subtotals
 | 30
 |  | Subtotals
 | 40
PHASE 190 - |  | Subtotals
 | 50
 |  | Subtotals
 | 60
 |  | Subtotals
 |  | Phase 190 Total
 | 10
 |  | .
 |  | Subtotals
 | 20
 |  | Subtotals
 | 30
 |  | Subtotals
 | 40
PHASE 195 - |  | Subtotals
 | 50
 |  | Subtotals
 | 60
 |  | Subtotals
 |  | Phase 195 Total
 | 10
 |  | .
 |  | Subtotals
 | 20
 |  | Subtotals
 | 30
 |  | Subtotals
 | 40
PHASE 200 - |  | Subtotals
 | 50
 |  | Subtotals
 | 60
 |  | Subtotals
 |  | Phase 200 Total
 | 10
 |  | .
 |  | Subtotals
 | 20
 |  | Subtotals
 | 30
 |  | Subtotals
 | 40
PHASE 205 - |  | Subtotals
 | 50
 |  | Subtotals
 | 60
 |  | Subtotals
 |  | Phase 205 Total
 | 10
 |  | .
 |  | Subtotals
 | 20
 |  | Subtotals
 | 30
 |  | Subtotals
 | 40
PHASE 210 - |  | Subtotals
 | 50
 |  | Subtotals
 | 60
 |  | Subtotals
 |  | Phase 210 Total
 |  | Page Totals
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Page Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total (excluding markup)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Percentage
Spreadsheet: darrell_schoolcraft__7477__imball0202
Sheet: DEFS

 | 23995 |  | 22051
 | 59687 |  | 10703
Day | Measured | Scheduled | Measured | Scheduled | Totals
1 |  |  | 34592 | 34133
2 |  |  | 34669 | 34133
3 |  |  | 34620 | 33692
4 |  |  | 34664 | 34133
5 |  |  | 34596 | 34133
6 |  |  | 34635 | 33999
7 |  |  | 34649 | 34133
8 |  |  | 34575 | 34133
9 |  |  | 34720 | 34133
10 |  |  | 34749 | 34133
11 |  |  | 34735 | 34133
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30 |  |  |  |  |  |  | CBS Volume | 23995 | 22051
31 |  |  |  |  |  |  |  | -183967 | -149923
2002-01-31 00:00:00 | Balance | -1035385.61 |  | -616208.42
2002-02-11 00:00:00 | Balance
 |  |  |  | Contract #
 |  |  |  | 22864 | 0 | Zia |  |  | 22864
 |  |  |  | 20379 | -51695.87 | Grayco/Artesia |  |  | 20379 | 2979
 |  |  |  | 26357 |  | [NAME] |  |  | 26357
 |  |  |  | 21544 | 61340.16 | [NAME], [NAME] |  |  | 21544 | 36108
 |  |  |  | 24532 | -1167820 | 500211,500212,500219,500230 - Coburn points |  |  | 24532 | -154244
 |  |  |  | Duke
20379
24532
21544
26357
22864
23995
22051
21665
22664
24361
26393
24268
Spreadsheet: 298308d1392755557-find-a-value-in-a-table-with-multiple-values-test-excel-data-search-sheet
Sheet: ON-6

Date | PO # | Buyer | Division Line | Model | Trailer Description | Serial # | Build Location | Line # | Est. Delivery Date | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 2014-01-01 00:00:00
Spreadsheet: 041d257f-f5a9-4ca5-b431-641572128420
Sheet: Reported - New Web

THOMSON REUTERS CORPORATION
BUSINESS AND SEGMENT INFORMATION (UNAUDITED)
(millions of U.S. dollars, except as otherwise indicated and except for per share data)
ONGOING BUSINESSES - REPORTED
 |  | 2010 |  | 2011 |  | 2012
 |  | Full Year |  | Full Year |  | Q1 | Q2 | Q3 | Q4 |  | Full Year
Revenues:
Trading |  | 3400 |  | 3537 |  | 859 | 840 | 816 | 830 |  | 3345
Investors |  | 2432 |  | 2472 |  | 603 | 608 | 604 | 601 |  | 2416
Marketplaces |  | 997 |  | 1134 |  | 298 | 292 | 303 | 320 |  | 1213
Governance, Risk & Compliance |  | 73 |  | 154 |  | 51 | 52 | 55 | 61 |  | 219
Financial & Risk
Legal |  | 3027 |  | 3221 |  | 777 | 818 | 830 | 861 |  | 3286
Tax & Accounting |  | 907 |  |  |  | 310 | 283 | 262 | 351 |  | 1206
Intellectual Property & Science |  | 789 |  | 852 |  | 209 | 216 | 219 | 250 |  | 894
Corporate & Other (includes Media) |  | 324 |  | 336 |  | 82 | 83 | 79 | 87 |  | 331
Eliminations |  | -12 |  | -13 |  | -2 | -3 | -3 | -3 |  | -11
Revenues from ongoing businesses
 |  |  | 1419
Adjusted EBITDA:
Financial & Risk |  | 1790 | 0 | 1972 |  | 459 | 460 | 440 | 483 |  | 1842
Legal |  |  | 545 | 1210 |  | 270 | 319 | 327 | 327 |  | 1243
Tax & Accounting |  | 284 |  | 332 |  | 96 | 84 | 65 | 131 |  | 376
Intellectual Property & Science |  | 263 |  | 296 |  | 72 | 75 | 72 | 84 |  | 303
Corporate & Other (includes Media) |  |  |  |  |  | -72 | -46 | -40 | -77 |  | -235
Integration programs expenses |  | -463 |  | -215 |  | 0 | 0 | 0 | 0 |  | 0
Adjusted EBITDA
Depreciation and amortization of computer software:
Financial & Risk
Legal
Tax & Accounting
Intellectual Property & Science
Corporate & Other (includes Media)
Depreciation and amortization from ongoing businesses
Underlying Operating Profit:
Financial & Risk |  |  | 0 |  |  | 302 | 306 | 283 | 324 |  | 1215
Legal |  |  | 0 | 941 |  | 200 | 251 | 256 | 257 |  | 964
Tax & Accounting |  | 203 |  |  |  | 68 | 56 | 34 | 103 |  | 261
Intellectual Property & Science |  | 209 |  | 237 |  | 55 | 59 | 55 | 66 |  | 235
Corporate & Other (includes Media) |  |  |  |  |  | -80 | -55 | -43 | -92 |  | -270
Underlying Operating Profit
Underlying Operating Profit margin %
Adjusted earnings
Underlying Operating Profit
Adjustments:
Integration programs expenses |  |  |  |  |  | 0 | 0 | 0 | 0
Interest expense |  | -383 |  | -396 |  | -114 | -91 | -90 | -95 |  | -390
Income tax |  |  |  |  |  | -53 | -63 | -38 | -49 |  | -203
Non-controlling interests |  | -24 |  | -38 |  | -12 | -13 | -12 | -16 |  | -53
Dividends declared on preference shares |  | -3 |  | -3 |  | -1 | -1 | 0 | -1 |  | -3
Adjusted earnings from continuing operations
Adjusted earnings per share from continuing operations
Weighted average shares (in millions) |  | 836.4 |  | 835.8 |  | 830.3 | 830.7 | 828.4 | 829.2 |  | 829.6
Adjusted EBITDA  margin summary:
Financial & Risk
Legal
Tax & Accounting
Intellectual Property & Science
Adjusted EBITDA Margin
Underlying Operating Profit margin summary:
Financial & Risk
Legal
Tax & Accounting
Intellectual Property & Science
Underlying Operating Profit margin
Spreadsheet: 882594d1730979870-all-my-data-are-disapper-in-my-sheet-kmch-hvac-duct-surface-area-04
Sheet: abs

SL. No. | Description | Area | Unit | Area
1 | Duct Area  For Ground Floor | GF!M302 |  | 644.7727973264689
2 | Duct Area  For First Floor | '01'!M155 |  | 372.2753994213882
3 | Duct Area  For Second Floor | '02'!M167 |  | 335.8393457788785
4 | Duct Area  For Third Floor | '03'!M270 |  | 531.791983686059
5 | Duct Area  For Fourth Floor | '04'!M271 |  | 520.6170953148587
6 | Duct Area  For Fifth Floor | '05'!M171 |  | 556.4252950253617
7 | Duct Area  For Sixth Floor | '06'!M148 |  | 512.5959100604981
 | Total Quantity |  | M2 | 3474.317826613513
Spreadsheet: 75564d1276110742-make-a-letter-have-a-value-to-add-it-together-system-win-percentage
Sheet: System 3

 | Date | Team | [A] | [B] | [C] | Record
1 | 2010-04-12 00:00:00 | Cleveland | L | L | W | 1-0
2 | 2010-04-19 00:00:00 | Arizona | L | W | X | 2-0
3 | 4/29/210 | Los Angeles | L | W | X | 3-0
4 | 2010-05-17 00:00:00 | Texas | W | X | X | 4-0
5 | 2010-06-04 00:00:00 | Philly | W | X | X | 5-0
6
7
8
 |  | Win % | 0.4 | 0.67 | 1
Spreadsheet: 525458d1498739019-is-it-possible-to-auto-update-a-worksheet-while-saving-data-on-another-worksheet-inv
Sheet: Inv

Inv No |  | INVOICE
1 | Etihad
 | Bldg 3
 | Street 3
1 | Abudhabi |  |  | Date | 2017-09-28 00:00:00
 | Bldg 3 |  |  | Inv No | 1
1 | UAE |  |  | Due Date | 2017-10-28 00:00:00
Inv No | Item Code | Item Description | Qty | Rate | Amount
1 | LeReve-005 | [NAME] | 12 | 9.5 | 114
1 | LeReve-002 | Adore | 5 | 9.5 | 47.5
1 | LeReve-003 | Bloom | 22 | 9.5 | 209
1 | LeReve-004 | Cheer | 3 | 9.5 | 28.5
1 | LeReve-006 | Clean | 6 | 9.5 | 57
1 | LeReve-007 | Crush | 10 | 9.5 | 95
1
1
1
1
1
1
1
1
 |  |  |  | Sub Total | 551
 |  |  | 2.5 | Discount | 13.775
 |  |  |  | Net Total | 537
 |  | INVOICE
2 | Emirates Airline
 | [NAME]
 | Street 2
2 | Dubai |  |  | Date | 2017-09-29 00:00:00
 | [NAME] |  |  | Inv No | 2
2 | UAE |  |  | Due Date | 2017-10-29 00:00:00
Inv No | Item Code | Item Description | Qty | Rate | Amount
2 | LeReve-005 | [NAME] | 12 | 9.5 | 114
2 | LeReve-002 | Adore | 5 | 9.5 | 47.5
2 | LeReve-003 | Bloom | 22 | 9.5 | 209
2 | LeReve-004 | Cheer | 3 | 9.5 | 28.5
2 | LeReve-006 | Clean | 6 | 9.5 | 57
2 | LeReve-007 | Crush | 10 | 9.5 | 95
2
2
2
2
2
2
2
2
 |  |  |  | Sub Total | 551
 |  |  | 2.5 | Discount | 13.775
 |  |  |  | Net Total | 537
Spreadsheet: 165450d1341236933-creating-a-formula-that-extracts-duration-of-time-between-inputs-total-cal
Sheet: Sheet1

Number | Parts | Qty | Job Type | Job Added | Job Added | total time with pm | To Planning | To Planning | total time with planners | To Prepress | To Prepress | total time in prepress | Out on Proof | Out on Proof | total time to proof | Proof OK | Proof OK | total time with client | Date Plated | Time Plated
888328 |  | 280 | A-DIGMONO | 2012-06-04 00:00:00 | 06:37:40 |  | 2012-06-04 00:00:00 | 12:42:26 |  | 2012-06-06 00:00:00 | 05:25:20 |  |  |  |  | 2012-06-06 00:00:00 | 09:23:03
888329 | 1 | 30000 | A-BROCHRE | 2012-06-04 00:00:00 | 08:37:52 |  | 2012-06-04 00:00:00 | 10:12:50 |  | 2012-06-05 00:00:00 | 10:24:45 |  | 2012-06-05 00:00:00 | 11:46:07 |  | 2012-06-05 00:00:00 | 13:59:42 |  | 2012-06-12 00:00:00 | 02:43:37
888330 | 2 | 100 | A-BOOKSTI | 2012-06-04 00:00:00 | 09:10:21 |  | 2012-06-06 00:00:00 | 20:45:24 |  | 2012-06-06 00:00:00 | 20:07:40 |  |  |  |  | 2012-06-08 00:00:00 | 15:59:53
888331 | 1 | 500 | A-BUSCARD | 2012-06-04 00:00:00 | 09:13:46 |  |  |  |  | 2012-06-04 00:00:00 | 09:38:48 |  |  |  |  | 2012-06-04 00:00:00 | 10:47:00
Spreadsheet: 859166d1707634802-rank-and-count-values-in-a-range-from-the-same-range-across-multiple-sheets-sample
Sheet: Review

Top 20
Bob2 | <---- | All manually entered
Carmen3 | <----
Marge | <----
Abigail1
[NAME]
[NAME]
[NAME]
[NAME]
Ernie
[NAME]
[NAME]
Priya
[NAME]
Tom5
[NAME]
Mark4
Elaine
Maria
[NAME]
[NAME]
EXPECTED OUTCOME
Abigail1 (10) | <------Formulas in here |  | that checks for the names entered into A2:A21 against the other 12 sheets
Bob2 (8) |  |  | and results in the name in the range that matched the most with the number
Carmen3 (7) |  |  | of times it matched in parenthesis.
Mark4 (6)
Tom5 (5) |  |  | The formula should account for the possibility of blank cells.
Spreadsheet: 780863d1652824551-counting-two-different-values-in-a-column-and-retuning-the-count-of-that-value-excel-count-issue
Sheet: Sheet1

Row # |  | Flat/INC |  |  |  |  |  |  |  | Flat | Inc
1 |  |  |  |  |  |  |  |  |  | 1
2 |  |  |  |  |  |  |  |  |  | 1 | 1
3 |  |  |  |  |  |  |  |  |  |  | 1
4 |  |  |  |  |  |  |  |  |  |  | 1
5 |  |  |  |  |  |  |  |  |  | 1
6 |  |  |  |  |  |  |  |  |  |  | 1
7 |  |  |  |  |  |  |  |  |  | 1
8 |  |  |  |  |  |  |  |  |  | 1
9 |  |  |  |  |  |  |  |  |  | 1
10 |  |  |  |  |  |  |  |  |  | 1
11 |  |  |  |  |  |  |  |  |  |  | 1
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
Spreadsheet: 803819d1667725548-how-to-do-fast-replacing-of-row-number-accross-different-columns-copy-of-baza-nova-verzija-racuni-1-
Sheet: R20

Ime artikla
Spreadsheet: 840020d1692364267-sum-product-with-merged-cells-sumproduct-merged-cell-1-
Sheet: Expected Result

 | [NAME] |  |  | McDonaldtrut Ellie |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | Myerstrut [NAME] |  |  | [NAME] |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | Okpevbatrut Victor |  |  |  |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  |  |  |  | Norristrut Robert |  |  | [NAME] |  |  | Mairtrut Ruairidh |  |  | [NAME] |  |  | [NAME]
 | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time
Total Days |  | 4 | 4 | 0.2 | 13 | 12.6 | 1.2 | 3 | 3.2 | 3 | 1 | 4 | 5 | 9 | 12 | 1.1 | 7 | 7.3 | 2.5 | 2 | 4.5 | 2.1 | 3 | 3.1 | 0 | 23 | 23 | 0 | 1 | 1 | 6.4 | 5 | 7.4 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 12.5 | 12.5 | 0 | 11 | 11 |  |  |  | 2.5 | 6 | 6.5 | 0 | 5 | 5 | 0 | 2 | 2 |  |  |  | 0 | 7.5 | 5.2 | 9 | 15 | 15 | 8 | 9 | 11 | 0 | 1 | 1 | 0 | 12 | 10
Days X Rate | 1000 | 400 | 400 | 12.2 | 793 | 768.6000000000001 | 64.8 | 162 | 172.8 | 243 | 81 | 324 | 150 | 270 | 360 | 48.40000000000001 | 308 | 321.2 | 240 | 192 | 432 | 79.8 | 114 | 117.8 | 0 | 874 | 874 | 0 | 80 | 80 | 147.2 | 115 | 170.2 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 225 | 225 | 0 | 726 | 726 |  |  |  | 170 | 408 | 442 | 0 | 475 | 475 | 0 | 100 | 100 |  |  |  | 0 | 442.5 | 306.8 | 684 | 1140 | 1140 | 256 | 288 | 352 | 0 | 79 | 79 | 0 | 360 | 300
Spreadsheet: d2390013-b197-4836-af38-fac6f1dfc42d
Sheet: 3. Dashboard

 |  |  |  |  |  |  |  |  |  |  |  |  | Digital metrics report
 |  |  |  |  |  |  |  |  |  |  |  |  | 2013-06-01 00:00:00
 | Highlights
 | (Summary of the results of the digital activity for this month)
 |  |  | visits |  |  | Pages/visit |  |  |  | registered users |  |  |  | comments
 | Prev. month |  |  |  | Prev. month |  |  |  | Prev. month |  |  |  | Prev. month
 | Prev. year |  |  |  | Prev. year |  |  |  | Prev. year |  |  |  | Prev. year
 |  |  |  |  |  |  |  |  | Most viewed artworks |  |  | Most viewed artists
 |  |  |  |  |  |  |  |  | Artwork |  | Views |  | Artist |  | Views
 |  |  |  |  |  |  |  |  | Ophelia |  | 2000 |  | JMW Turner |  | 4000
 |  |  |  |  |  |  |  |  | Weeping Woman |  | 1800 |  | LS Lowry |  | 3800
 |  |  |  |  |  |  |  |  | Fountain |  | 1700 |  | [NAME] |  | 3600
 |  |  |  |  |  |  |  |  | Whaam |  | 1600 |  | [NAME] |  | 3400
 |  |  |  |  |  |  |  |  | The lady of [NAME] |  | 1500 |  | [NAME] |  | 3200
 |  |  |  |  |  |  |  |  | The snail |  | 1400 |  | [NAME] |  | 3000
 |  |  |  |  |  |  |  |  | The passing winter |  | 1300 |  | [NAME] |  | 2800
 |  |  |  |  |  |  |  |  | A bigger splash |  | 1200 |  | [NAME] |  | 2600
 |  |  |  |  |  |  |  |  | [NAME] |  | 1100 |  | [NAME] |  | 2400
 |  |  |  |  |  |  |  |  | Lopster telephone |  | 1000 |  | [NAME] |  | 2200
 |  | Followers |  |  | % Engaged users |  |  |  |  | Apps |  |  | Email subscribers
 |  |  |  |  |  |  |  |  | Downloads |  |  |  | Main
 |  |  |  |  |  |  |  |  | Revenue |  |  |  | Members
Spreadsheet: robert_badeer__33066__CALILT Fax
Sheet: VaR

POWER-CALI-LT
 |  |  | Portfolio | V@R |  |  |  |  |  |  |  |  | Portfolio | V@R
 |  |  |  |  |  |  | [NAME] VaR Limit |  |  | 2400000
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Average Daily VaR |  |  | 1300000
 |  |  |  |  |  |  | IDEA?
 |  |  |  |  |  | Correlation Matrix
 |  |  | Total |  |  |  |  |  |  |  |  |  | Total
 |  |  | Analysis:
 |  |  | 1 | VaR Change =
 |  |  | 2 | In the current portfolio, the long positions are adding to the risk.
 |  |  | 3 | ZP26, Palo, and NP 15 are risk-increasing; [NAME], SP-15 and COB are risk-reducing.
,
 |  |  | ,
Spreadsheet: 456888d1461101027-rank-samplebook
Sheet: Sheet1

Foxwood | [NAME] | 18.15 |  |  |  |  |  |  | [NAME]
Foxwood | [NAME] | 18.08
Foxwood | [NAME] | 16.85
Foxwood | [NAME] | 18.53
Foxwood | [NAME] | 11.86
Foxwood | [NAME] | 19.75
Foxwood | [NAME] | 17.37
Foxwood | [NAME] | 15.24
Foxwood | [NAME] | 16.49
Foxwood | [NAME] | 13.47
Foxwood | [NAME] | 19.14
Birchdon | [NAME] | 15.62
Birchdon | [NAME] | 16.05
Birchdon | [NAME] | 15.22
Birchdon | [NAME] | 18.98
Birchdon | [NAME] | 17.32
Birchdon | [NAME] | 16.38
Birchdon | [NAME] | 19.47
Birchdon | [NAME] | 16.42
Birchdon | [NAME] | 12.34
Birchdon | [NAME] | 19.38
Birchdon | [NAME] | 16.23
Birchdon | [NAME] | 12.8
[NAME] | [NAME] | 16.39
[NAME] | [NAME] | 16.83
[NAME] | Billy Price | 17.85
[NAME] | [NAME] | 17.39
[NAME] | [NAME] | 10.52
[NAME] | [NAME] | 14.28
[NAME] | [NAME] | 20.25
[NAME] | [NAME] | 26.92
[NAME] | [NAME] | 16.07
[NAME] | [NAME] | 13.46
[NAME] | [NAME] | 20
[NAME] | [NAME] | 18.66
[NAME] | [NAME] | 10.9
[NAME] | [NAME] | 18.47
[NAME] | [NAME] | 9.78
[NAME] | [NAME] | 22.22
[NAME] | [NAME] | 15
[NAME] | [NAME] | 10.25
[NAME] | [NAME] | 0
Hopford | [NAME] | 12.9
Hopford | [NAME] | 19.82
Hopford | [NAME] | 30.3
Hopford | [NAME] | 27.27
Hopford | [NAME] | 53.33
Hopford | [NAME] | 22.22
Hopford | [NAME] | 19.04
Hopford | [NAME]
Spreadsheet: 757480d1638284604-get-results-from-large-data-in-excel-book2_3
Sheet: Sheet1

DUMMY WORKBOOK
Incidents assigned to | [NAME]
Short description | Symptom | Number | Created | Assignment group
Problem Tickets
Short description | Symptom | Number | Created | Assignment group
Spreadsheet: 480639d1474010600-pivot-table-calculated-field-book1-6-
Sheet: Sheet5

 | Values
Row Labels | Sum of Hours Worked | Average of Average Hours | Difference
[NAME] | 29 | 36
[NAME] | 27 | 40
[NAME] | 55 | 50
(blank)
Grand Total | 111 | 42.18181818181818
Spreadsheet: 52374d1252069089-a-kind-of-reverse-vlookup-matches
Sheet: Sheet1

 | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q |  |  | Match | Team 1 | Team 2
A |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A |  | 1
B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B |  | 2
C |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | C |  | 3
D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D |  | 4
E |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  | E |  | 5 | J | I
F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F |  | 6
G |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  | G |  | 7
H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H |  | 8
I |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  | I |  | 9
J |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J |  | 10
K |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  |  |  |  | K |  | 11
L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L |  | 12
M |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  |  |  | M |  | 13
N |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N |  | 14
O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | O |  | 15
P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P |  | 16
Q |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q |  | 17
 | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q
Spreadsheet: eric_saibi__9861__101201R
Sheet: Lake Cogen 02 CTHRSG 

Owner Name |  | GPU International Inc.
Station Name |  | Lake Cogen
Unit Name |  | Unit 02 CT/HRSG
NERC Region |  | FRCC
State |  | FL
Fuel Type |  | Natural Gas
Capacity |  | 49 MW
Start Date |  | 2001-10-26 00:00:00
End Date |  | 2001-10-30 00:00:00
Prv. Start Date |  | 2001-10-11 00:00:00
Prv. End Date |  | 2001-10-15 00:00:00
Comments
SIC |  | 4931
Plant ID |  | 1012710
Unit ID |  | 1012059
Outage ID |  | 18412
Spreadsheet: 55890d1256052830-spreading-values-across-a-time-frame-book2
Sheet: Sheet1

 |  | Beginning Year |  | End Year |  | Value |  |  | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016
 |  | 2010 |  | 2011 |  | 100000
 |  | 2010 |  | 2010 |  | 100000 |  |  | 100000
 |  | 2012 |  | 2015 |  | 400000 |  |  |  |  | 100000 | 100000 | 100000 | 100000