tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1579d451-7ac9-4a64-84f6-e477995e5b3c
Sheet: Sheet1

Unnamed: 0 | State of New Hampshire - General Election | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | Carroll County Offices
Nov. 6, 2012 | Sheriff |  |  | Attorney |  |  | Treasurer
 | Richardi, r&d | Lord, i | [NAME] | Murray, r | Gordon, d | [NAME] | Widmer, r |  | [NAME]
Albany | 309 | 79 | 1 | 131 | 232 |  | 231
[NAME] | 1398 | 292 |  | 684 | 985 |  | 991
[NAME] | 291 | 98 | 2 | 220 | 165 |  | 282 |  | 1
Chatham | 161 | 33 |  | 93 | 96 |  | 125 |  | 1
Conway | 3873 | 819 | 6 | 1752 | 2810 | 4 | 2929 |  | 8
Eaton | 219 | 53 | 2 | 111 | 166 |  | 153
[NAME] | 510 | 220 | 3 | 344 | 370 | 1 | 489
Freedom | 690 | 188 | 3 | 412 | 435 | 2 | 611
Hale's Location | 93 | 16 |  | 86 | 31 |  | 100
Hart's Location | 28 | 5 |  | 10 | 20 |  | 18
[NAME] | 506 | 87 |  | 238 | 365 |  | 367 |  | 1
[NAME] | 1092 | 240 | 4 | 479 | 809 | 2 | 777 |  | 1
Moultonborough | 2097 | 641 |  | 1664 | 1018 |  | 2015
Ossipee | 1285 | 684 | 4 | 921 | 936 |  | 1394 |  | 3
Sandwich | 763 | 151 | 2 | 351 | 558 | 1 | 512 |  | 1
Tamworth | 1164 | 316 | 4 | 516 | 948 |  | 930 |  | 2
Tuftonboro | 1149 | 336 | 13 | 896 | 571 | 2 | 1232 |  | 2
Wakefield | 1936 | 413 | 6 | 1316 | 988 |  | 1698 |  | 4
Wolfeboro | 3073 | 724 | 24 | 2256 | 1599 | 4 | 2835 |  | 2
TOTALS | 20637 | 5395 | 74 | 12480 | 13102 | 16 | 17689 |  | 26
 | Reg. of Deeds |  |  | Reg. of Probate
 | Aiton, r |  | [NAME] | Mock, r |  | [NAME]
Albany | 237 |  |  | 242 |  | 2
[NAME] | 997 |  |  | 1047
[NAME] | 279 |  |  | 279 |  | 1
Chatham | 129 |  | 1 | 131
Conway | 2949 |  | 4 | 3031 |  | 7
Eaton | 157 |  |  | 158
[NAME] | 497 |  |  | 411 |  | 2
Freedom | 601 |  |  | 614
Hale's Location | 99 |  |  | 100
Hart's Location | 20 |  |  | 10
[NAME] | 375 |  |  | 397 |  | 2
[NAME] | 791 |  | 2 | 797 |  | 1
Moultonborough | 2006 |  |  | 1986
Ossipee | 1442 |  | 2 | 1396 |  | 3
Sandwich | 517 |  | 2 | 519 |  | 2
Tamworth | 940 |  | 2 | 949 |  | 4
Tuftonboro | 1187 |  | 1 | 1175 |  | 1
Wakefield | 1705 |  | 4 | 1687 |  | 7
Wolfeboro | 2773 |  | 2 | 2756 |  | 2
TOTALS | 17701 |  | 20 | 17685 |  | 34
 |  | County Commissioners
 | District 1 |  |  | District 2 |  |  | Dist. 3
 | Sorensen, r | Corbett, d | [NAME] | [NAME], Jr., r | [NAME], d | [NAME] | NO ELECTION
Albany | 178 | 176 |  | 144 | 226
[NAME] | 758 | 914 |  | 726 | 916
[NAME] | 228 | 137 |  | 239 | 139
Chatham | 114 | 71 |  | 99 | 87
Conway | 2323 | 2200 | 6 | 1955 | 2573 | 6
Eaton | 190 | 84 | 1 | 126 | 146
[NAME] | 352 | 299 |  | 364 | 308 | 4
Freedom | 515 | 321 |  | 482 | 356
Hale's Location | 94 | 27 |  | 85 | 30
Hart's Location | 13 | 17 |  | 10 | 19
[NAME] | 284 | 322 | 1 | 258 | 343
[NAME] | 669 | 609 | 1 | 569 | 714 | 1
Moultonborough | 1737 | 912 |  | 1667 | 979
Ossipee | 1147 | 687 | 1 | 1208 | 700
Sandwich | 437 | 460 |  | 397 | 514
Tamworth | 786 | 620 | 3 | 691 | 735 | 3
Tuftonboro | 944 | 481 |  | 934 | 511
Wakefield | 1416 | 870 | 3 | 1352 | 928 | 4
Wolfeboro | 2314 | 1394 | 2 | 2341 | 1447
TOTALS | 14499 | 10601 | 18 | 13647 | 11671 | 18
Spreadsheet: 205915d1357934292-count-of-employees-at-any-given-time-count-of-employees-at-any-given-time-nickmessick1-oeldere2-
Sheet: copy

 |  |  |  |  |  |  |  |  |  |  |  | day | (Alles)
GROUP | Supervisors | Employees | Date Start | Time Start | Date End | Time End | time | day | month | year
1 | [NAME] | girl | 2013-01-11 00:00:00 | 14:00:00 | 2013-01-12 00:00:00 | 00:00:00 | 8 |  |  |  |  |  | Waarden
2 | [NAME] | boy | 2013-01-11 00:00:00 | 22:30:00 | 2013-01-12 00:00:00 | 08:30:00 | 7.5 |  |  |  |  | Rijlabels | Som van time | count
3 | [NAME] | girl | 2013-01-12 00:00:00 | 07:00:00 | 2013-01-12 00:00:00 | 17:00:00 | 2.5 |  |  |  |  | 1 | 15.5 | 3
4 | [NAME] | baby | 2013-01-12 00:00:00 | 13:15:00 | 2013-01-12 00:00:00 | 23:15:00 | 5 |  |  |  |  | [NAME] | 15.5 | 3
1 | [NAME] | girl | 2013-01-11 00:00:00 | 14:00:00 | 2013-01-12 00:00:00 | 00:00:00 | 4 |  |  |  |  | girl | 15.5 | 3
2 | [NAME] | boy | 2013-01-11 00:00:00 | 22:30:00 | 2013-01-12 00:00:00 | 08:30:00 | 8 |  |  |  |  | 2 | 19.5 | 3
3 | [NAME] | girl | 2013-01-11 00:00:00 | 07:00:00 | 2013-01-12 00:00:00 | 17:00:00 | 2 |  |  |  |  | [NAME] | 19.5 | 3
4 | [NAME] | baby | 2013-01-11 00:00:00 | 13:15:00 | 2013-01-12 00:00:00 | 23:15:00 | 6 |  |  |  |  | boy | 19.5 | 3
1 | [NAME] | girl | 2013-01-11 00:00:00 | 14:00:00 | 2013-01-12 00:00:00 | 00:00:00 | 3.5 |  |  |  |  | 3 | 10.5 | 3
2 | [NAME] | boy | 2013-01-11 00:00:00 | 22:30:00 | 2013-01-12 00:00:00 | 08:30:00 | 4 |  |  |  |  | [NAME] | 10.5 | 3
3 | [NAME] | girl | 2013-01-12 00:00:00 | 07:00:00 | 2013-01-12 00:00:00 | 17:00:00 | 6 |  |  |  |  | girl | 10.5 | 3
4 | [NAME] | baby | 2013-01-12 00:00:00 | 13:15:00 | 2013-01-12 00:00:00 | 23:15:00 | 7 |  |  |  |  | 4 | 39 | 6
4 | [NAME] | girl | 2013-01-12 00:00:00 | 13:15:00 | 2013-01-12 00:00:00 | 23:15:00 | 7 |  |  |  |  | [NAME] | 39 | 6
4 | [NAME] | boy | 2013-01-12 00:00:00 | 13:15:00 | 2013-01-12 00:00:00 | 23:15:00 | 7 |  |  |  |  | girl | 7 | 1
4 | [NAME] | child | 2013-01-12 00:00:00 | 13:15:00 | 2013-01-12 00:00:00 | 23:15:00 | 7 |  |  |  |  | boy | 7 | 1
 |  |  |  |  |  |  |  |  |  |  |  | baby | 18 | 3
 |  |  |  |  |  |  |  |  |  |  |  | child | 7 | 1
 |  |  |  |  |  |  |  |  |  |  |  | Eindtotaal | 84.5 | 15
Spreadsheet: 2a012306-7b94-4f6e-9fdb-cec57c039d16
Sheet: Sheet1

 |  | Metabochip PAGE AA index tagSNP
Index tagSNP | Number of mchip SNPs with MAF>1% | N | beta | se beta | p(bAA=0) | p(same beta)
rs28927680 | 449 | 5550 | 0.0137 | 0.0123 | 0.2667 | 1.16e-18
rs9989419* | 84
rs4420638* | 46
rs599839 | 551 | 5490 | 2.1578 | 0.9035 | 0.01693 | 0.000505
rs780094 | 1779 | 5543 | 0.0391 | 0.0116 | 0.0007361 | 0.0461
rs16996148 | 740 | 5487 | 1.3022 | 1.1095 | 0.2405 | 0.00119
rs17145738 | 429 | 5551 | -0.0495 | 0.0156 | 0.001505 | 0.123
rs9939609 | 1296 | 5813 | 0.1436 | 0.1111 | 0.1962 | 0.241
rs5219 | 349 | 5790 | 0.0261 | 0.1074 | 0.808 | 0.402
rs3764261* | 84
rs2954029 | 166 | 5543 | 0.0109 | 0.0095 | 0.2498 | 0.014
* These three tagSNPs failed to genotype on the metabochip, so direct analysis was not possible
Spreadsheet: 614777d1552127717-find-rows-groups-with-unique-values-and-return-species-solution-1
Sheet: Sheet1

 |  |  | Table 1.
 |  |  | Groups | species
 |  |  | Group[ 0 ] | Olea_europaea | Olea_europaea
 |  |  | Group[ 1 ] | Codium_arabicum | Codium_arabicum
 |  |  | Group[ 2 ] | Codium_duthieae | Codium_duthieae | Codium_arabicum*
 |  |  | Group[ 3 ] | Rhazya_stricta
 |  |  | * odd species in this group
 |  |  | Table 2.
 |  |  | Species list | Comment (Result) | My Result
 |  |  | Codium_arabicum | AMBIGIOUS
 |  |  | Codium_duthieae | INCORRECT
 |  |  | Olea_europaea | True
 |  |  | Rhazya_stricta | SINGLETON
 |  |  | If Same species are grouped together and not found in any other group then : TRUE
 |  |  | If Same species are grouped together but also found in other group then : [NAME]
 |  |  | If Multiple species are grouped together then : INCORRECT
 |  |  | If only one individual of representative species, this species in not in any other group then : SINGLETON
Spreadsheet: phillip_m_love__30490__arnold pos 2001
Sheet: 05-29-01

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NYMEX Equivalent Gas Position |  |  |  |  | 7 |  |  | 600
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POSITION   REPORT
TIME BUCKET/KEY: |  | 1 |  |  |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14
(Positions in Cont. [NAME].)     From: |  |  |  | June |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total ECT |  | Prior Day |  |  |  | CHECK LINKS
To: |  |  |  | Index |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Change |  | to HEDGESTRIPS
[NAME]
NYMEX Price
NYMEX NG-MM
NG PR CAN
NG-Long Term Exotic
NG LTX  Hedge-Basis Notional
NG LTX  Hedge-Basis Equivalent
Exotic Options
Exotic Options-Basis Notional
Exotic Options-Basis Equivalent
NG EOL Basis
NG EOL Basis Equivalent
NYMEX-Gas Daily
NG-GDL
TOTAL: |  |  |  | 0
Previous Day Change
Spreadsheet: 740538d1626367788-vlookup-where-lookout-values-are-between-2-columns-2vlookup
Sheet: Sheet1

Input (area)Location | Input(area2)Location2? | Output(area)Location | Output(area2)Location2 | Group
(1)A1
(1)A7
(1)A8
(1)A9
 | (1)1
 | (1)7
 | (1)8
 | (1)9
Spreadsheet: 599357d1542988193-distribute-values-between-two-different-dates-copy-of-loan-calculation-work-sheet-version01-
Sheet: Payment Plan

Customer Payment Plan
Loan Code | Customer Name | Officer Name | Date of Loan | Loan Amount with Interest | Payment Method | Loan Period(Dys) | Inst Amount | No Of Inst | Concession Days | Payment Start | Last Payment | 2018-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018-12-06 00:00:00
 |  |  |  |  |  |  |  |  |  | 2018-09-25 00:00:00
 |  |  |  |  |  |  |  |  |  | 2018-09-25 00:00:00
 |  |  |  |  |  |  |  |  |  | 2018-09-24 00:00:00
 |  |  |  |  |  |  |  |  |  | 2018-09-26 00:00:00
 |  |  |  |  |  |  |  |  |  | 2018-09-27 00:00:00
 |  |  |  |  |  |  |  |  |  | 2018-09-28 00:00:00
 |  |  |  |  |  |  |  |  |  | 2018-09-29 00:00:00
 |  |  |  |  | Monthly |  | 100 | 4 |  | 2018-09-29 00:00:00
Spreadsheet: 807164d1669783701-googlesheets-schedule-checker-2023-1st-semester-schedule-bundang
Sheet: JANE

 | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY |  | BOOKS/PREPS
 | _ |  | _ |  | _ |  | _ |  | _ |  | 1st Grade |  |  |  | 4th Grade
 | ADMIN |  | ADMIN |  | ADMIN |  | ADMIN |  | ADMIN
 |  |  |  |  |  |  |  |  |  |  | 2nd Grade
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5th Grade
 |  |  |  |  |  |  |  |  |  |  | 3rd Grade
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6th Grade
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  | WRITING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  | . |  |  |  | .
Spreadsheet: 45720d1244546874-sum-based-on-partial-contents-of-cells-in-another-collumn-book1
Sheet: Sheet1

Project | Expenses | Employees
1 | 465 | [NAME], [NAME], [NAME], [NAME]
2 | 3245 | [NAME]
3 | 345 | [NAME], [NAME] |  |  | Total Expenses for projects involving [NAME]:
4 | 758756 | [NAME], [NAME], [NAME], [NAME] |  |  | 6772357
5 | 568567 | [NAME], [NAME]
6 | 6886586 | [NAME], [NAME]
7 | 6765867 | [NAME]
8 | 657865 | [NAME], [NAME], [NAME], [NAME]
9 | 2345 | [NAME], [NAME], [NAME]
10 | 2534 | [NAME], [NAME]
11 | 2354 | [NAME], [NAME], [NAME], [NAME]
12 | 465 | [NAME], [NAME], [NAME], [NAME]
13 | 3245 | [NAME]
14 | 345 | [NAME], [NAME]
15 | 758756 | [NAME], [NAME], [NAME]
16 | 568567 | [NAME], [NAME]
17 | 6886586 | [NAME], [NAME]
18 | 6765867 | [NAME]
19 | 657865 | [NAME], [NAME], [NAME], [NAME]
20 | 2345 | [NAME], [NAME]
21 | 2534 | [NAME]
22 | 2354 | [NAME], [NAME], [NAME], [NAME]
Spreadsheet: 107424d1304599166-need-formula-for-a-macro-function-example
Sheet: 1

1622
Name | Amount
Name 1 | 116
Name 2 | 179
Name 3 | 144
Name 2 | 117
Name 2 | 193
Name 1 | 144
Name 3 | 173
Name 1 | 118
Name 1 | 192
Name 2 | 140
Name 1 | 141
Name 3 | 152
Name 1 | 140
Name 1 | 134
Name 1 | 184
Name 1 | 163
Name 2 | 191
Name 1 | 106
Name 2 | 134
Name 2 | 112
Name 2 | 127
Name 2 | 134
Name 2 | 134
Name 1 | 184
Name 2 | 118
Spreadsheet: 854115d1704098455-cubesetcount-function-filtrando-f-rmulas-com-slicer
Sheet: Dados

Slicer |  |  | Orçamento |  |  |  | Atual
Lista | Incluir |  | Data | Item | valor |  | Data | Item | valor
Alpha |  |  | 2022-10-01 00:00:00 | Golf | 60 |  | 31/10/2022 | Alpha | 320
Bravo |  |  | 2022-10-01 00:00:00 | Bravo | 63 |  | 31/10/2022 | Bravo | 250
[NAME] |  |  | 2022-10-01 00:00:00 | Bravo | 51 |  | 31/10/2022 | [NAME] | 130
Delta |  |  | 2022-10-01 00:00:00 | Alpha | 55 |  | 31/10/2022 | Delta | 320
Echo |  |  | 2022-10-01 00:00:00 | Bravo | 59 |  | 31/10/2022 | Echo | 220
Foxtrot |  |  | 2022-10-01 00:00:00 | Alpha | 63 |  | 31/10/2022 | Foxtrot | 200
Golf |  |  | 2022-10-01 00:00:00 | Alpha | 50 |  | 31/10/2022 | Golf | 150
Hotel |  |  | 2022-10-01 00:00:00 | Alpha | 61 |  | 31/10/2022 | Hotel | 120
 |  |  | 2022-10-01 00:00:00 | [NAME] | 61
 |  |  | 2022-10-01 00:00:00 | Delta | 66
 |  |  | 2022-10-01 00:00:00 | [NAME] | 53
 |  |  | 2022-10-01 00:00:00 | Echo | 62
 |  |  | 2022-10-01 00:00:00 | Foxtrot | 68
 |  |  | 2022-10-01 00:00:00 | Foxtrot | 55
 |  |  | 2022-10-01 00:00:00 | Delta | 57
 |  |  | 2022-10-01 00:00:00 | Echo | 70
 |  |  | 2022-10-01 00:00:00 | Echo | 50
 |  |  | 2022-10-01 00:00:00 | Echo | 67
 |  |  | 2022-10-01 00:00:00 | Hotel | 51
 |  |  | 2022-10-01 00:00:00 | [NAME] | 69
 |  |  | 2022-10-01 00:00:00 | Golf | 52
Spreadsheet: 37748d1235760196-flowing-month-data-into-a-chart-based-on-weeks-projectmanhours
Sheet: Project 2

 |  | Project |  | Example
 |  | Project Number |  | 1234500
 |  | Project Duration: |  | 41 |  |  |  |  |  |  |  |  |  |  |  |  | January
 |  | Project Start: |  | 2009-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | February
 |  | Procurement Duration: |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  | March
 |  | Equipment Item Total: |  | 126 |  |  |  |  |  |  |  |  |  |  |  |  | April
 |  | Requisition Total: |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  | May
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | June
 |  | Project Phase Ratio: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | July
 |  |  |  | PHASE |  | WEEKS |  | MH RATIO |  | TOTAL |  |  |  |  |  |  | August
 |  |  |  | Proposal |  | 4 |  | 0 |  | 0 |  |  |  |  |  |  | Septe
 |  |  |  | Estimate |  | 2 |  | 0.5 |  | 40
 |  |  |  | FEED |  | 12 |  | 1 |  | 480
 |  |  |  | DD |  | 6 |  | 0.5 |  | 120
 |  |  |  | Proc |  | 15 |  | 0.25 |  | 150
 |  |  |  | CloseOut |  | 2 |  | 0.12 |  | 9.6
 |  |  |  |  |  | 41 |  |  |  | 799.6
 |  |  |  |  |  |  |  |  |  | REQ Man Hours: |  |  | 750
 |  | [NAME] |  |  |  |  |  |  |  | Phase Man Hours: |  |  | 799.6
 |  | Calculated Fields |  |  |  |  |  |  |  | Delta: |  |  | -0.06613333333333336
 |  |  |  |  |  |  |  |  |  | ADMIN Man Hours: |  |  | 119.94
 |  |  |  |  |  |  |  | TOTAL MAN HOURS: |  |  |  |  | 919.54
 |  |  |  |  |  | January |  | 0
 |  |  |  |  |  | February |  | 0.5
 |  |  |  |  |  | March |  | 1
 |  |  |  |  |  | April |  | 0.5
 |  |  |  |  |  | May |  | 0.25
 |  |  |  |  |  | June |  | 0.12
Spreadsheet: dcb7ad63-a60b-42fe-8e8a-891f30340da7
Sheet: 1.6 ANZ job advertisements

1.6 ANZ job advertisements
Month | 2010–11 | 2011–12 | 2012–13 | 2013–14 | 2014–15
Advertisements (a) (b) – number
July | 164513.969 | 172505.081 | 156683.074 | 128155.313 | 133765.041
August | 168282.509 | 171443.587 | 153133.384 | 127176.539 | 134937.165
September | 172023.668 | 170305.943 | 149209.948 | 126538.968 | 136111.02
October | 175327.078 | 169183.021 | 145372.89 | 126204.165 | 137122.222
November | 177997.756 | 168062.206 | 142085.419 | 126453.614
December | 179613.783 | 167022.666 | 139599.123 | 127260.366
January | 179855.717 | 166221.216 | 137835.809 | 128399.802
February | 178945.305 | 165358.568 | 136466.753 | 129589.679
March | 177434.684 | 164356.071 | 135039.043 | 130628.71
April | 175826.513 | 163172.097 | 133290.604 | 131477.541
May | 174465.192 | 161650.684 | 131349.564 | 132166.516
June | 173418.498 | 159542.494 | 129544.918 | 132851.047
Annual average | 174808.7226666667 | 166568.6361666667 | 140800.8774166667 | 128908.5216666667
Annual change (b) – per cent
July | 34.78285736467112 | 4.857406364075985 | -9.171907811805271 | -18.20730234077486 | 4.377288673158641
August | 37.31256600133459 | 1.878435268635084 | -10.68001627847416 | -16.95048089579212 | 6.102246578671246
September | 37.8884832194288 | -0.9985399218437812 | -12.38711616775464 | -15.1940137396201 | 7.564509298036946
October | 36.33730540583277 | -3.504340042671561 | -14.07359370891007 | -13.1859007549482 | 8.651106720606263
November | 33.24438085829311 | -5.581840031736124 | -15.45665002159975 | -11.00169539564084
December | 29.23857346155858 | -7.010106234441929 | -16.41905476469883 | -8.83870667296384
January | 24.78988351656163 | -7.580799335947708 | -17.07688566061266 | -6.845831332553074
February | 20.26202324660375 | -7.592675873781653 | -17.47222133660471 | -5.039376880316039
March | 16.13412018215174 | -7.370945017717061 | -17.83750841792756 | -3.265968790966623
April | 12.66673901113064 | -7.197103431153183 | -18.31286938722128 | -1.360233163922038
May | 9.93531961501603 | -7.345022725220743 | -18.74481397183571 | 0.6219678049330944
June | 7.446515713268943 | -8.001455531001074 | -18.80224838405748 | 2.552110149160761
Annual average | 25.00323063298764 | -4.620582209400312 | -15.53624049262517 | -8.059619334450323
(a) Average total number of newspaper and internet job advertisements per week. |  |  |  |  |  |  |  | Update
(b) Monthly figures are trend. Annual figures are from the original series. |  |  |  |  |  |  |  | 2014-12-08 00:00:00
Source: ANZ Banking Group, Job advertisements series
Spreadsheet: 77854d1278353952-excel-2007-averaging-no-blanks-and-no-zeros-over-several-sheets-test-monthly
Sheet: WK2 Tue

 | Monthly Total
 | Desktop |  | Network |  |  |  | Install | Add |  |  | Total
 | Opened |  | Opened
 | Closed |  | Closed
 | Backlog |  | Backlog
 | Frozen |  | Frozen
 | Active Install Tickets
 | Install Tickets Frozen
 | Install Tickets in Responded
 |  |  |  |  |  | Total Team
 |  |  |  |  |  | Team Averade
Spreadsheet: 734101d1621972575-intersection-of-many-data-book1
Sheet: Sheet1

 |  |  | 100 Meters
 | Class G | 1 | Time 1 | Time 2 | Time 3 | Mark
F | Baima | Meggie
M | Baudino | [NAME] | 14.72 | 15.37 |  |  |  |  |  | M | 1° 2° 3° |  |  | M | 4° 5°
 |  |  |  |  |  |  |  |  |  | Time | Mark |  |  | Time | Mark
 |  |  |  |  |  |  |  |  |  | 13 | 10 |  |  | 12.5 | 10
 |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  | 7 |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  | 6 |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  | 5
 |  |  |  |  |  |  |  |  |  | F | 1° 2° 3° |  |  | F | 4° 5°
 |  |  |  |  |  |  |  |  |  | Time | Mark |  |  | Time | Mark
 |  |  |  |  |  |  |  |  |  |  | 10 |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  | 7 |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  | 6 |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  | 5
Spreadsheet: 115793d1311286763-if-date-then-sample
Sheet: DATA

Case IDs | Date | Completed By | Time Taken
267792 | 2011-01-01 12:19:38 | [NAME] | 22h 46m 10s
564897 | 2011-01-02 12:19:38 | [NAME] | 22h 39m 18s
3546871 | 2011-01-01 12:19:38 | [NAME] | 22h 37m 2s
4975176 | 2011-01-01 12:19:38 | [NAME] | 21h 45m 47s
2100073 | 2011-01-02 12:19:38 | [NAME] | 1h 33m 6s
Spreadsheet: 804251d1667969805-googlesheets-result-based-on-unique-and-countif-formula-new-microsoft-excel-worksheet-12-
Sheet: Sheet1

A | B | C | D | RESULT
2206 | AB | UNIQUE(B2:B11) | COUNTIF(A:A,B2) | 2206
2206 | CD | UNIQUE(B2:B11) | COUNTIF(A:A,B2) | 2206 , 2207
2206 | EF | UNIQUE(B2:B11) | COUNTIF(A:A,B2) | 2206 , 2207
2207 | CD | UNIQUE(B2:B11) | COUNTIF(A:A,B2) | 2208 ,2209
2207 | AB | UNIQUE(B2:B11) | COUNTIF(A:A,B2) | 2208
2207 | EF | UNIQUE(B2:B11) | COUNTIF(A:A,B2) | 2208
2208 | GH
2208 | HI
2208 | JK
2209 | GH
Spreadsheet: 728041d1618263372-arrange-top-5-items-from-a-list-in-decreasing-order-book2
Sheet: Risk Register

 |  | Estimated cost of residual risk
Reference | Cause, trigger or issue | Minimum $ | Most Likely $ | Maximum $
3 | 1. Delay to REF determination which is required prior to AHIP application to [NAME] 2. Excessive review timeframes from [NAME] | 60000 | 120000 | 300000 |  |  | Top 5 risk items | Most Likely Values
4 | Residential noise treatments required not previously identified by pre-construciton noise modelling | 50000 | 100000 | 150000 |  | 1
5 | 1. Poor exisiting pavement may trigger addional costs for insitu stabilisation. | 100000 | 145000 | 480000
10 | Clearing of EECs and habitat for threatened species. Triggered by vegetation clearing. | 100000 | 200000 | 600000
16 | Encountering legacy contamination during construction including:  1. Coal tar (in pavement) 2. Asbestos  3. Other | 24000 | 48000 | 96000
26 | 1. Potential seasonal restrictions to road closures, lane configurations (e.g. school holidays, [NAME]) 2. Not willing to provide comment on likely ROL conditions until actual ROL submitted by contractor- uncertainty remains | 100000 | 200000 | 400000
27 | 1. Competition with large pipeline of work currently in NSW | 250000 | 625000 | 1250000
28 | 1. Lack of appropriately skilled contractors available  2. Competition with large pipeline of work | 78000 | 156000 | 312000
35 | 1. Limited ancillary site locations are available.  2. Sites identified wihtin REF have various contraints (overhead power lines etc) 3. Preferred site not yet secured, pending agreement from Ausgrid | 40000 | 60000 | 100000
37 | 1. Existing tree roots preventing installation of temporary sheet piling. | 5000 | 72500 | 195000
46 | 1. PSC specifications ambiguous 2. Work by others impacts on deliverables 3. Additional / unanticipated investogation required | 50000 | 100000 | 150000
47 | Aboriginal find during construction | 10000 | 20000 | 250000
52 | Unforeseen / unknown utilities at time of preparing concept design | 40000 | 100000 | 500000
54 | Bushfire in the surrounding areas (National Parks, [NAME]) | 60000 | 100000 | 200000
71 | Unanticipated construction conctract claims above and beyond the allowances made within this RA. | 125000 | 312500 | 625000
73 | Excavation for pavement foundations and/or retaining wall foundations encourter unanticipated (poor) ground conditions | 3600 | 14300 | 31500
Spreadsheet: 43113fbd-ac04-478f-be12-cdeb6a2ed10b
Sheet: 8b

Product1 | EUR3 | GBP | [NAME] | USD | AUD | CAD | OTHER | TOTAL
Basis | 4 | 10 | - | 56 | 2 | 1 | 3 | 76
Cap/Floor | - | 9 | - | 199 | - | - | - | 208
Debt Option | - | - | - | - | - | - | - | -
Exotic | - | - | - | - | - | - | - | -
Fixed-Fixed | - | 12 | - | 13 | 1 | - | 7 | 33
Fixed-Float | 1039 | 1627 | 442 | 8431 | 1192 | 258 | 1137 | 14126
FRA | 33 | 5 | - | 95 | 25 | 4 | 48 | 210
Inflation | 153 | 16 | - | 25 | - | - | - | 194
OIS | 33 | 10 | 3 | 25 | 7 | 24 | 128 | 230
Swaption | 208 | 88 | 50 | 614 | 26 | 2 | 56 | 1044
TOTAL | 1470 | 1777 | 495 | 9458 | 1253 | 289 | 1379 | 16121
Spreadsheet: 274613d1383161877-skipping-rows-when-filling-down-and-right-test
Sheet: Sheet1

 |  |  | Location 1
 |  |  | Location 1 P
 |  |  | Location 1 C | 35 |  | 15 | 15
 |  |  | Location 2
 |  |  | Location 2 P
 |  |  | Location 2 C | 61 |  | 38 | 38
 |  |  | Location 3
 |  |  | Location 3 P
 |  |  | Location 3 C | 43 |  | 41 | 41
 |  |  | Location 4
 |  |  | Location 4 P
 |  |  | Location 4 C | 6
 |  |  | Location 5
 |  |  | Location 5 P
 |  |  | Location 5 C | 45 |  | 26 | 26