tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 864921d1712063832-weighted-average-formula-excluding-zeros-weighted-average-excluding-zeros
Sheet: Sheet1

10+ | 7 - 9 | 4 - 6 | 3 | 2 | 1 | Less than 1 | 10+ | 7 - 9 | 4 - 6 | 3 | 2 | 1 | Less than 1 | ExcelLogan's [NAME] | Regular Weighted Average Formula
 |  |  |  |  |  |  | 0.6 | 0.6 | 1.8 | 0.6 | 1.4 | 2.8 | 1.6
0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0.6 | 1.4 | 1.4
 |  |  |  |  |  |  | 0.2 | 0.2 | 1.4 | 2.2 | 4 | 6.4 | 5.8
 |  |  |  |  |  |  | 1.4 | 0.8 | 5.6 | 3.6 | 5.6 | 15.8 | 11.2
0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 2.4 | 1.8
 |  |  |  |  |  |  | 0.2 | 0.6 | 0.4 | 1.4 | 1 | 3 | 0.6
 |  |  |  |  |  |  | 1.4 | 1 | 6.4 | 3.2 | 3.6 | 10.6 | 9.8
Spreadsheet: 847567d1698422714-help-with-adding-an-additional-criteria-to-filter-filter
Sheet: Sheet1

Date | 2023-10-26 00:00:00
 |  |  |  | Colour | Date | Cost
 | Number Plate |  |  | Blue | 2023-10-20 00:00:00 | 101
Filter |  |  |  | Red | 2023-10-20 00:00:00 | 24
 | 45 |  |  | Red | 2023-10-19 00:00:00 | 63
 |  |  |  | Blue | 2023-10-20 00:00:00 | 152.9
 |  |  |  | Blue | 2023-10-18 00:00:00 | -40.93
 |  |  |  | Blue | 2023-10-19 00:00:00 | -408.69
 |  |  |  | Blue | 2023-10-26 00:00:00 | 1200
 |  |  |  | Blue | 2023-10-20 00:00:00 | -86.14
 |  |  |  | Blue | 2023-10-23 00:00:00 | -129.77
 |  |  |  | Red | 2023-10-31 00:00:00 | -423.8
 |  |  |  | Blue | 2023-11-02 00:00:00 | 158
 |  |  |  | Blue | 2023-09-20 00:00:00 | 53.21
 |  |  |  | Red | 2023-11-04 00:00:00 | 100
 |  |  |  | Blue | 2023-10-26 00:00:00 | 45
Spreadsheet: 815880d1675248693-sum-if-data-is-in-either-column-journey
Sheet: Sheet1

OurTable |  |  |  |  | ExportedData
Name | Cost |  | Should be |  | Cost | TO | FROM
[NAME] |  |  | 6 |  | 1.5 | [NAME] | [NAME]
[NAME] |  |  | 6 |  | 1.5 |  | [NAME]
[NAME] |  |  | 4.5 |  | 1.5 | [NAME] | [NAME]
 |  |  |  |  | 1.5 |  | [NAME]
 |  |  |  |  | 1.5 |  | [NAME]
 |  |  |  |  | 1.5 | [NAME] | [NAME]
 |  |  |  |  | 1.5 |  | [NAME]
 |  |  |  |  | 1.5 | [NAME]
 |  |  |  |  | 1.5 | [NAME] | [NAME]
 |  |  |  |  | 1.5 | [NAME] | [NAME]
 |  |  |  |  | 1.5 | [NAME] | [NAME]
Spreadsheet: 691579d1597764683-return-site-based-on-client-example1-6-ans
Sheet: Mapping

Client | Site
Apple | AA |  | 1 | Apple
Apple | aaa |  | 2 | [NAME] |  | Unwanted spaces in column A should be removed
Apple | ab |  | 3 | [NAME]
Apple | sssss
Apple | aaaa
Apple | iiouoi
Apple | ddddd
Apple | eeee
Apple | ggggg
Apple | ggffg
[NAME] | bbbb
[NAME] | fggg
[NAME] | wwwww
[NAME] | wrrrrr
[NAME] | qqqqq
[NAME] | tttt
[NAME] | eeee
[NAME] | tttt
[NAME] | uuuu
[NAME] | mmmm
[NAME] | [NAME]
[NAME] | ttttttt
[NAME] | AA
[NAME] | aaa
[NAME] | ab
[NAME] | sssss
[NAME] | aaaa
[NAME] | iiouoi
[NAME] | ddddd
[NAME] | eeee
[NAME] | ggggg
Spreadsheet: 689926d1596745063-formula-to-calculate-time-neryoneil_reva
Sheet: Sheet1

Name | Date | IN | Out-lunch | In-from-lunch | OUT | [NAME] time | Overtime | Total
 | Mon | 02:00:00 | 11:30:00 | 12:30:00 | 21:00:00
 | Tue | 06:00:00 | 11:30:00 | 12:30:00 | 17:00:00
 | Wed | 06:00:00 | 11:30:00 | 12:30:00 | 17:00:00
 | Thu | 06:00:00 | 11:30:00 | 12:30:00 | 17:00:00
 | Fri | 06:00:00 | 11:30:00 | 12:30:00 | 17:00:00
 |  |  |  |  | TOTALs:
Spreadsheet: 770798d1646255683-using-columns-searching-of-mins-and-maxs-number-and-using-them-in-a-formula-allocate-points-v2
Sheet: Sheet1

Given HCP |  |  |  | Use this col. |  |  |  |  |  |  |  |  | Score (after HCP) minus Par | Points
-2 | Hole HCP -> | 17 | 15 | 1 | 5 | 13 | 7 | 3 | 11 | 9 |  |  | Hole in 1 | 12
Par |  | 4 | 4 | 4 | 4 | 4 | 5 | 3 | 5 | 3 | score |  | -4 or better | 6
Score |  | 4 | 6 | 5 | 3 | 2 | 5 | 4 | 6 | 3 |  |  | -3 | 6
 |  |  |  |  |  |  |  |  |  |  | Total points |  | -2 | 4
Points |  |  |  |  |  |  |  |  |  |  |  |  | -1 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 0
Given HCP |  | Use this col. | Use this col.
4 | Hole HCP -> | 17 | 15 | 1 | 5 | 13 | 7 | 3 | 11 | 9
Par |  | 4 | 4 | 4 | 4 | 4 | 5 | 3 | 5 | 3 | score
Score |  | 4 | 5 | 5 | 3 | 2 | 5 | 4 | 6 | 3
 |  |  |  |  |  |  |  |  |  |  | Total points
Points
Spreadsheet: shelley_corman__38749__Cashinoutmajorityminority
Sheet: Summary

Florida Gas Transmission
Summary of Cash In/Out Statistics
for  Majority Due Shippers  vs  Minority Due Shippers
and Majority Due FGT vs Minority Due FGT
Based on the NUMBER of shippers due FGT or due shipper
 | Majority |  | Minority
Prod. Month | Due Shippers | Due FGT | Due Shippers | Due FGT
2000-08-01 00:00:00 | 26 |  |  | 20
2000-09-01 00:00:00 | 28 |  |  | 26
2000-10-01 00:00:00 |  | 26 | 19
2000-11-01 00:00:00 | 22 |  |  | 14
2000-12-01 00:00:00 | 21 |  |  | 19
2001-01-01 00:00:00 | 26 |  |  | 15
2001-02-01 00:00:00 | 22 |  |  | 17
2001-03-01 00:00:00 |  | 34 | 4
2001-04-01 00:00:00 |  | 21 | 18
2001-05-01 00:00:00 |  | 21 | 19
2001-06-01 00:00:00 | 27 |  |  | 18
2001-07-01 00:00:00 |  | 24 | 14
*Oct 00, Nov 00, and April 01 were the only months having imbalance
volume greater on the Minority numbers of shippers than on the Majority
numbers of shippers.
Spreadsheet: 231772d1367223286-how-to-sort-information-based-on-date-in-a-header-row-excel-schedule
Sheet: Feb

 |  |  |  | 6 | 7 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | 2 | 3 | 4 | 5 | 6
 | 2013-01-01 00:00:00 |  | F | e | b | r | u | a | r | y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M
No. | Activity | Start Date | 2013-02-01 00:00:00 | 2013-02-02 00:00:00 | 2013-02-03 00:00:00 | 2013-02-04 00:00:00 | 2013-02-05 00:00:00 | 2013-02-06 00:00:00 | 2013-02-07 00:00:00 | 2013-02-08 00:00:00 | 2013-02-09 00:00:00 | 2013-02-10 00:00:00 | 2013-02-11 00:00:00 | 2013-02-12 00:00:00 | 2013-02-13 00:00:00 | 2013-02-14 00:00:00 | 2013-02-15 00:00:00 | 2013-02-16 00:00:00 | 2013-02-17 00:00:00 | 2013-02-18 00:00:00 | 2013-02-19 00:00:00 | 2013-02-20 00:00:00 | 2013-02-21 00:00:00 | 2013-02-22 00:00:00 | 2013-02-23 00:00:00 | 2013-02-24 00:00:00 | 2013-02-25 00:00:00 | 2013-02-26 00:00:00 | 2013-02-27 00:00:00 | 2013-02-28 00:00:00 | 2013-03-01 00:00:00
 |  | [NAME] | 2013-02-01 00:00:00 | 2013-02-02 00:00:00 | 2013-02-03 00:00:00 | 2013-02-04 00:00:00 | 2013-02-05 00:00:00 | 2013-02-06 00:00:00 | 2013-02-07 00:00:00 | 2013-02-08 00:00:00 | 2013-02-09 00:00:00 | 2013-02-10 00:00:00 | 2013-02-11 00:00:00 | 2013-02-12 00:00:00 | 2013-02-13 00:00:00 | 2013-02-14 00:00:00 | 2013-02-15 00:00:00 | 2013-02-16 00:00:00 | 2013-02-17 00:00:00 | 2013-02-18 00:00:00 | 2013-02-19 00:00:00 | 2013-02-20 00:00:00 | 2013-02-21 00:00:00 | 2013-02-22 00:00:00 | 2013-02-23 00:00:00 | 2013-02-24 00:00:00 | 2013-02-25 00:00:00 | 2013-02-26 00:00:00 | 2013-02-27 00:00:00 | 2013-02-28 00:00:00 | 2013-03-01 00:00:00
1
2
2.1
2.2
2.3
2.4
2.5
3
3.1
3.2
4
4.1
4.2
4.3
5
5.1
5.2
5.3
6
6.1
6.2
6.3
6.4
7
7.1
7.2
7.3
7.4
7.5
8
8.1
8.2
8.3
8.4
8.5
8.6
Spreadsheet: 39902d1238149607-vlookup-query-index-match-amended-pricing-sheet
Sheet: Price Book

ITEM | ITEM COST | LABOUR RATE
413 | 5.56 | 0.15
751 | 95.08 | 0.25
753 | 125.79 | 0.25
15A GPO | 15.99 | 0.15
1G | 6.05 | 0.15
221/20 | 2.63 | 0.06
2G | 9.78 | 0.15
3G | 16.75 | 0.15
4G | 25.62 | 0.15
5G | 36.5 | 0.2
6G | 42.55 | 0.2
750WPR | 126.07 | 0.25
BATTON HLD | 4.77 | 0.25
COND BOX | 7.55 | 0.06
[NAME] | 12.89 | 0.15
DIMMER | 51.36 | 0.2
DWP GPO | 43.82 | 0.25
EX FAN | 39.63 | 0.35
HOB SW | 19.08 | 0.45
HW SW | 31 | 0.45
M BLOCK | 5.63 | 0.15
MISC | 100 | 0.5
SGPO | 8.04 | 0.15
SMOKIE | 88.37 | 0.25
SWP GPO | 25.56 | 0.25
TL | 1.02 | 0.06
WALL BOX | 2.22 | 0.06
WALL PLATE | 1.23 | 0.1
WHS | 59 | 0.4
WHT | 71 | 0.4
Spreadsheet: 87648d1287528124-generating-combinations-of-text-scratch
Sheet: Item

Cum: | 2304 | 1152 | 576 | 144 | 72 | 24 | 8 | 4 | [NAME] columns to left as needed
Cnt: | 2 | 2 | 4 | 2 | 3 | 3 | 2 | 4
 | Bin1 | Bin2 | Bin3 | Bin4 | Bin5 | Bin6 | Bin7
 | Deliver | Full | Equities | Domestic | Gifted | ACAT | Retransmission | Type 1 | No interspersed blanks
 | Receive | Partial | Mutual Funds | International | Inherited | Manual | First Transmission | Type 2
 |  |  | Fixed Income |  | TOA | Non-ACAT |  | Type 3
 |  |  | Options |  |  |  |  | Type 5
# | Permutations |  |  |  |  |  |  |  | [NAME] rows above as needed
1 | Deliver | Full | Equities | Domestic | Gifted | ACAT | Retransmission | Type 1
2 | Deliver | Full | Equities | Domestic | Gifted | ACAT | Retransmission | Type 2
3 | Deliver | Full | Equities | Domestic | Gifted | ACAT | Retransmission | Type 3
4 | Deliver | Full | Equities | Domestic | Gifted | ACAT | Retransmission | Type 5
5 | Deliver | Full | Equities | Domestic | Gifted | ACAT | First Transmission | Type 1
6 | Deliver | Full | Equities | Domestic | Gifted | ACAT | First Transmission | Type 2
7 | Deliver | Full | Equities | Domestic | Gifted | ACAT | First Transmission | Type 3
8 | Deliver | Full | Equities | Domestic | Gifted | ACAT | First Transmission | Type 5
9 | Deliver | Full | Equities | Domestic | Gifted | Manual | Retransmission | Type 1
10 | Deliver | Full | Equities | Domestic | Gifted | Manual | Retransmission | Type 2 | << drag formulas down to see more
Spreadsheet: 478634d1472925672-if-clause-speedo-chart-v2
Sheet: Sheet3

From | To | Cell Value needed
0 | 1.65 | 10 |  |  | Cell Value
1.66 | 1.76 | 20 |  |  | 1.85
1.77 | 1.87 | 30
1.88 | 1.98 | 40
1.99 | 2.09 | 50 |  | Required | 10,20,30,40,50
2.1 | 2.2 | 60
2.21 | 2.31 | 70
2.32 | 2.42 | 80
2.43 | 2.53 | 90
2.54 | Any Value | 100
Spreadsheet: 861198d1709140940-sort-two-columns-so-that-matching-numbers-line-up-in-rows-realistic-data
Sheet: INITIAL Combined

INITIAL Combined
44794830
44794831
44794833
44794835
44794838
44794843
44794848
44795360
44795361
44795362
44795364
44795366
44795370
44795374
44795375
44795376
44795377
44795379
44795387
44795388
44795390
44795391
44795392
44795393
44795396
44795397
44795398
44795399
44795403
44795406
44795408
44795410
44795412
44795417
44795427
44795431
44795438
44795447
44795448
44795449
44795450
44795452
44795455
44795457
44795459
44795460
44795462
44795463
44795464
44795465
44795467
44795469
44795470
44795474
44795476
44795479
44795483
44795495
44795497
44795504
44795507
44795510
44795511
44795512
44795514
44795516
44795519
44795520
44795521
44795526
44795531
44795895
44795896
44795898
44795900
44795901
44795902
44795904
44795906
44795907
44795908
44795924
44795925
44795926
44796234
44796235
44796236
44796237
44796238
44796239
44796240
44796241
44796242
44796243
44796244
44796245
44796246
44796247
44796248
44796250
44796251
44796252
44796254
44796255
44796256
44796257
44796258
44796259
44796260
44796261
44796262
44796263
44796264
44796265
44796266
44796267
44796268
44796269
44796275
44796281
44796283
44796285
44796286
44796295
44796296
44796298
44796299
44798717
44798718
44798719
44798721
44798724
44798727
44798796
44798798
44798799
44798803
44798804
44798816
44798822
44798828
44798831
44798837
44798841
44798845
44798849
44798852
44798855
44798859
44798870
44798875
44798880
44798891
44798899
44798906
44798909
44798916
44798919
44798923
44798928
44817829
44817830
44817831
44817832
44817833
44817834
44817835
44817836
44817838
44817839
44817840
44817841
44817846
44817850
44817853
44817855
44817858
44817860
44817863
44817865
44817961
44817962
44817963
44817964
44817974
44817977
44817979
44817983
44817985
44817990
44818084
44818091
44818094
44819130
44819133
44819134
44819140
44819211
44819224
44819225
44819226
44819228
44819231
44819242
44819250
44819254
44819259
44833390
44833391
44833395
44833396
44833397
44833398
44833400
44833402
44833404
44833406
44833409
44833411
44833413
44833414
44833415
44833416
44833417
44833418
44833420
44833426
44833427
44833428
44834491
44834492
44834493
44834494
44834496
44834497
44834500
44834501
44834502
44834503
44834504
44834506
44834510
44834513
44834514
44834528
44834529
Spreadsheet: 135234d1325875887-data-validation-list-testing
Sheet: Data Ref Tab

[NAME]
 | Chart_MH_Sizes = B4 thru C45 |  |  |  | Chart_Pipe_Sizes = H2 thru M50
 |  | STANDARD PLATE SEWER-1001 |  |  |  | STANDARD PLATE SEWER-4001 & SEWR-4002 | STANDARD PLATE SEWER-4006 | STANDARD PLATE SEWER-4007 | STANDARD PLATE SEWER-4015 | Standard NONE |  | Casting List |  | Remarks List
 | MH I.D. (in) | Wall Thickness (in) |  |  | [NAME] | RCP | [NAME] | VCP | PVC SDR 26 | DIP
 | 30 | 5 |  |  | 4 |  |  | 0.625 | 0.173 |  |  | A-1 |  | REPLACE CASTING (A-1)
 | 48 | 5 |  |  | 5 |  |  |  | 0.214 |  |  | A-2 |  | REPLACE CASTING (A-1)
 | 54 | 6 |  |  | 6 |  |  | 0.8125 | 0.255 |  |  | B-1 |  | REPLACE CASTING (A-1)
 | 60 | 6 |  |  | 8 |  |  | 1 | 0.332 |  |  | B-2 |  | REPLACE CASTING (A-1)
 | 72 | 7 |  |  | 10 |  |  | 1.1875 | 0.413 |  |  | C-1 |  | REPLACE CASTING (A-1)
 | 78 | 8 |  |  | 12 | 2.75 |  | 1.375 | 0.49 |  |  | C-2 |  | REMOVE
 | 84 | 8 |  |  | 14 |  |  |  | 0.538 |  |  | A-8D |  | REMOVE BY OTHERS
 | 92 | 8 |  |  | 15 | 3 |  | 1.8125 |  |  |  | B-13 |  | BY OTHERS
 | 96 | 9 |  |  | 16 |  |  |  | 0.615 |  |  |  |  | RELOCATE
 | 106 | 8 |  |  | 18 | 3.25 |  | 2.125 | 0.692 |  |  |  |  | RELOCATE BY OTHERS
 | 108 | 10 |  |  | 20 |  |  |  | 0.769 |  |  |  |  | RECONSTRUCT
 | 120 | 11 |  |  | 21 | 3.5 |  | 2.625 |  |  |  |  |  | CASTING A-1
 | 132 | 12 |  |  | 22 |  | 2.5 |  |  |  |  |  |  | LEAVE AS IS
 |  |  |  |  | 24 | 3.75 |  | 2.9375 | 0.923 |  |  |  |  | SEE NOTE
 |  |  |  |  | 27 | 4 |  | 3.25
 |  |  |  |  | 28.5 |  | 3.5
 |  |  |  |  | 30 | 4.25 |  | 3.3125
 |  |  |  |  | 33 | 4.5 |  | 3.25
 |  |  |  |  | 36 | 4.75 |  | 3.5
 |  |  |  |  | 36.25 |  | 4
 |  |  |  |  | 42 | 5.25 |  | 4.25
 |  |  |  |  | 43.75 |  | 4.5
 |  |  |  |  | 48 | 5.75
 |  |  |  |  | 51.125 |  | 4.5
 |  |  |  |  | 54 | 6.25
 |  |  |  |  | 58.5 |  | 5
 |  |  |  |  | 60 | 6.75
 |  |  |  |  | 65 |  | 5.5
 |  |  |  |  | 66 | 7.25
 |  |  |  |  | 72 | 7.75
 |  |  |  |  | 73 |  | 6
 |  |  |  |  | 78 | 8.25
 |  |  |  |  | 84 | 8.75
 |  |  |  |  | 88 |  | 7
 |  |  |  |  | 90 | 9.25
 |  |  |  |  | 96 | 9.75
 |  |  |  |  | 102 | 10.25 | 8
 |  |  |  |  | 108 | 10.75
 |  |  |  |  | 115.5 |  | 8.5
 |  |  |  |  | 122.375 |  | 9
 |  |  |  |  | 138.5 |  | 10
 |  |  |  |  | 154 |  | 11
 |  |  |  |  | 168.75 |  | 10
Spreadsheet: 844117d1695907756-totalling-columns-from-one-sheet-onto-another-monthly-business-for-help
Sheet: TOTALS

2022 - 2023 |  |  | 2023 - 2024
OCTOBER |  |  | OCTOBER
NOVEMBER | this needs to total up the potential% figures from the Oct 2022 - Sept 2023 sheet for the month of event: November |  | NOVEMBER
DECEMBER | this needs to total up the potential% figures from the Oct 2022 - Sept 2023 sheet for the month of event: December |  | DECEMBER
JANUARY |  |  | JANUARY
FEBRUARY |  |  | FEBRUARY
[NAME] |  |  | [NAME]
APRIL |  |  | APRIL
MAY |  |  | MAY
[NAME] |  |  | [NAME]
JULY |  |  | JULY
AUGUST |  |  | AUGUST
SEPTEMBER |  |  | SEPTEMBER
YTD potential |  |  | YTD potential
YTD actual |  |  | YTD actual
Spreadsheet: 118117d1313466103-excel-2007-how-to-categorise-into-hours-book1
Sheet: Sheet1

Start Date | End Date | 5:00-5:59pm | 6:00-6:59pm | 7:00-7:59pm | 8:00-8:59pm | 9:00-9:59pm | 10:00-10:59pm | 11:00-11:59pm
2011-03-01 17:30:00 | 2011-03-01 20:30:00 | 30 | 60 | 60 | 30
2011-03-01 17:30:00 | 2011-03-01 18:00:00 | 30
2011-03-01 18:00:00 | 2011-03-01 18:30:00 |  | 30
2011-03-01 18:00:00 | 2011-03-01 18:45:00 |  | 45
2011-03-01 20:00:00 | 2011-03-01 21:00:00 |  |  |  | 60
2011-03-01 20:30:00 | 2011-03-01 21:15:00 |  |  |  | 30 | 15
2011-03-01 21:00:00 | 2011-03-01 23:00:00 |  |  |  |  | 60 | 60
2011-03-01 22:00:00 | 2011-03-01 23:00:00 |  |  |  |  |  | 60
2011-03-01 23:00:00 | 2011-03-01 23:45:00 |  |  |  |  |  |  | 45
2011-03-02 17:00:00 | 2011-03-02 20:00:00 | 60 | 60 | 60
2011-03-02 17:30:00 | 2011-03-02 19:10:00 | 30 | 60 | 10
Spreadsheet: 1b7d2162-557e-4600-8263-119138aed484
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | SCHEDULE OF HOME SUPPORT INVOICE DUE DATES 2013 - 2014
 | SCHEDULE NO. | INVOICE PERIOD | INVOICE TO BE RECEIVED IN AP BY | PAYMENT TO BE PROCESSED BY AP BY
 | 14/01 | 18.03.2013 - 14.04.2013 | 29.04.2013 | 24.05.2013
 | 14/02 | 15.04.2013 - 12.05.2013 | 27.05.2013 | 21.06.2013
 | 14/03 | 13.05.2013 - 09.06.2013 | 24.06.2013 | 19.07.2013
 | 14/04 | 10.06.2013 - 07.07.2013 | 22.07.2013 | 16.08.2013
 | 14/05 | 08.07.2013 - 04.08.2013 | 19.08.2013 | 13.09.2013
 | 14/06 | 05.08.2013 - 01.09.2013 | 16.09.2013 | 11.10.2013
 | 14/07 | 02.09.2013 - 29.09.2013 | 14.10.2013 | 08.11.2013
 | 14/08 | 30.09.2013 - 27.10.2013 | 11.11.2013 | 06.12.2013
 | 14/09 | 28.10.2013 - 24.11.2013 | 09.12.2013 | 03.01.2014
 | 14/10 | 25.11.2013 - 22.12.2013 | 06.01.2014 | 31.01.2014
 | 14/11 | 23.12.2013 - 19.01.2014 | 03.02.2014 | 28.02.2014
 | 14/12 | 20.01.2014 - 16.02.2014 | 03.03.2014 | 28.03.2014
 | 14/13 | 17.02.2014 - 16.03.2014 | 31.03.2014 | 25.04.2014
 | ALL INVOICES MUST BE ISSUED IN LINE WITH THE PERIOD DATES SHOWN ABOVE.
 | INVOICES NOT ISSUED IN LINE WITH THESE PERIOD DATES WILL BE RETURNED.
 | All Invoices must identify the relevant Contract reference number.
 | Invoice address :  Home Support Payments Team, PO Box 13969, [NAME].
 | Invoice E-mail address : [EMAIL]
 | Telephone enquiries : [PHONE]
 | Fax number : [PHONE]
Spreadsheet: harry_arora__12209__Digital
Sheet: Digital

 | Digital (Cash or Nothing) Option Pricing
 | Function: Digital
 | EffDt | 1996-02-28 00:00:00
 |  | INPUTS |  |  |  |  |  | OUTPUTS
 |  |  |  |  |  |  |  | 0 | 1 | 2 | 3 | 4 | 5
Cash | Fwd Price | Strike | Ann.IntRt | Yield | Ann.Vol | ExpDt | Call=1/Put=0 | Price | Delta | Gamma | Vega | Rho | Theta
2 | 20 | 10 | 0.06 | 0 | 0.2 | 1996-12-20 00:00:00 | 1
2 | 20 | 15 | 0.06 | 0 | 0.2 |  | 1
2 | 20 | 20 | 0.06 | 0 | 0.2 |  | 1
2 | 20 | 25 | 0.06 | 0 | 0.2 |  | 1
2 |  |  |  |  |  |  | 0
2 |  |  |  |  |  |  | 0
2 |  |  |  |  |  |  | 0
2 |  |  |  |  |  |  | 0
Spreadsheet: 2bf6b8c7-4397-4a71-8462-269bb844f2e9
Sheet: EPR 1X CQY

Reconciliations of GAAP to Non-GAAP Adjusted Financial Measures
(In millions, except EPS)
First Quarter Ended December 31, 2012
 |  |  |  |  | Continuing Operations
 | Revenue | Cost of  Revenues | Operating Expenses | Operating Income | Net Earnings (a) | Diluted EPS
GAAP measures | 530.3000000000001 | 220.8 | 191.1 | 118.4000000000001 | 65.30000000000008 | 0.24
% of revenue |  |  | 0.3603620592117669 | 0.2232698472562702
Acquisition related charges: (b)
Contingent retention & earn-out | 0 | 0 | -17.5 | 17.5 | 11.5 | 0.04
Amortization of intangibles | 0 | -2.3 | -4.4 | 6.7 | 4.4 | 0.02
Royalty settlement | -5 | 0 | 0 | -5 | -5 | -0.02
Total non-GAAP adjustments | -5 | -2.3 | -21.9 | 19.23620592117669 | 10.9 | 0.03999999999999999
Adjusted measures | 525.3000000000001 | 218.5 | 169.2 | 137.6362059211768 | 76.20000000000007 | 0.28
% of revenue |  |  | 0.3190646803696021 | 0.2595440428458924
(a) Adjustments tax effected at 34%, except no tax effect on royalty settlement
(b) Primarily related to DoubleDown
Spreadsheet: 842714d1694709216-how-to-exclude-zero-from-data-sample-data-for-exclude-zero
Sheet: Sheet1

ID | Expected Answer
RCLU0000016057 | RCLU16057
RCLU0000016043 | RCLU16043
RCLU0000022026 | RCLU22026
CPPU0000237333
RCLU0000021014
RCLU0000021064
CPPU0000731206
CPPU0000236652
CPPU0000533216
RCLU0000022055
CPPU0000237205
CPPU0000236848
RCLU0000016015
RCLU0000022067
CPPU0000234164
CPPU0000534154
CPPU0000238383
RCLU0000022075
RCLU0000016061
RCLU0000022108
CPPU0000234736
CPPU0000236255
CPPU0000832181
CPPU0000532544
RCLU0000016100
Spreadsheet: 768780d1645118291-keeping-a-formula-constant-after-adding-columns-to-the-right-excel-test1
Sheet: Sheet1

Check |  |  | ID | SUM |  | ID | SUM
 | [NAME] | 120 | AAPL | 129.53 |  | AAPL | 146.32
 | aapl | 135 | ABBV | 114.38 |  | ABBV | 115.5
 | acb | 7 | ABUS | 7 |  | ABUS | 7
 | xyz |  | ACB | 9.7 |  | ACB | 10.37
 |  |  | AMZN | 3737.88 |  | ALEC | 34.83
 |  |  | [NAME] | 10.17 |  | AMZN | 4016.71
 |  |  | ARE | 184.33 |  | [NAME] | 10.17
 |  |  | BA | 235.47 |  | ARE | 184.33
 |  |  | BGS | 30.25 |  | AVGO | 454.5
 |  |  | BIP | 53.75 |  | BA | 230.5
 |  |  | BIPC | 76 |  | BFT | -
 |  |  | BMY | 72.82 |  | BIP | 54.75
 |  |  | BP | 26 |  | BMY | 73.09
 |  |  | C | 75.93 |  | BP | 26.13
 |  |  | CAG | 38 |  | C | 75.83
 |  |  | CCI | 181.67 |  | CAG | 38
 |  |  | CDTAF | - |  | CCI | 180.58
 |  |  | CGC | 23.46 |  | CDTAF | -
Spreadsheet: 43703d1242319717-multi-layer-drop-down-boxes-three-datavalidationlist
Sheet: Sheet1

 |  |  |  | First | Second | Third
 |  |  |  | Azerbaijan | Baku | Yasamal
 |  |  |  |  |  |  |  |  |  |  | Azerbaijan | Georgia | Russia | USA | Canada | Ukraine | France | Spain
 |  |  |  |  |  |  |  |  |  |  | Baku | Tbilisi | Moscow | New-York | Ottawa | Kharkov | Paris | Madrid
 |  |  |  |  |  |  |  |  |  |  | Qusar | Batumi | Petesburg | Washington | Montreal | Kyiv | Marselle | Barcelona
 |  |  |  |  |  |  |  |  |  |  | Yevlakh | [NAME] | Volqoqrad | Las-Angeles | Some on | Lvov | Nant | Athletico
 |  |  |  |  |  |  |  |  |  |  | Imishli | Marneuli | Stalingrad | San-Diego | On some | Dnepr | S-Etien | Bilbao
 |  |  |  |  |  |  |  |  |  |  | Baku | Qusar
 |  |  |  |  |  |  |  |  |  |  | Khatai | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Yasamal | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Mikh
Spreadsheet: 877742d1724608531-uninterruptable-power-supply-load-calculation-seems-complex-ups_-hydr-
Sheet: 2880W

Total power | sw1 | sw2 | [NAME] | sw4
2880 | 1055 | 559 | 270 | 252 |  | wasted | node level
Spreadsheet: 07840d5a-1acb-48d8-8b7a-e47c8f557438
Sheet: Template

 |  | STAR/CROSS-AGE FIRST ACCOUNTABILITY FORM (DIBELS ORF) 2013-2014
DISTRICT: |  |  |  | COORDINATOR NAME:
SCHOOL: |  |  |  | PHONE:
CLASSROOM TEACHER | Tutor | USE STUDENT  ID #  OR FIRST NAME ONLY | GRADE | # OF 30 MINUTE SESSIONS | Fall DIBELS ORF Score or DRA Score | Spring DIBELS ORF Score or DRA Score | BEG. READING LEVEL | ENDING READING LEVEL | DID THE STUDENT REACH BENCHMARK? | NOTES:
Example: Teacher Name | Tutor Name | [NAME] | 1 | 38 | 37 | For Second Accountability Report in the Spring | A | For Second Accountability Report in the Spring | For Second Accountability Report in the Spring | EXAMPLE
* The data currently populating the spreadsheet is for demonstrative purposes and is to be overwritten with the school's DIBELs data. Additionally, as many additional
rows as needed may be added.