tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 836155d1689132862-assistance-with-countifs-for-two-values-accident-review-spreadsheet-v2
Sheet: Data Tab

types of accident | locations - suburbs
Driver At Fault (Moving Obj) | [NAME]
Driver At Fault (Stationary Obj) | Albanvale
Third Party At Fault | Albion
Contributory | Braybrook
Non-Accident Incident | Burnside
Other | Cairnlea
 | [NAME]
 | Charter - Long Distance
 | Charter - Metro
 | Charter - Rural
 | Charter - Souther Cross Station
 | Deanside
 | Deer Park
 | Delahey
 | Footscray
 | Fraser Rise
 | Kealba
 | Keilor
 | [NAME]
 | Keilor East
 | [NAME]
 | Kingsville
 | Maidstone
 | Maribyrnong
 | Seddon
 | St Albans
 | Sunshine
 | Sydenham
 | Taylors Hill
 | Taylors Lakes
 | West Footscray
 | Yarraville
Spreadsheet: 544862d1509067586-join-sheet-in-excel-2007-test
Sheet: Compile

Sheet 1 |  |  |  |  |  |  |  | Sheet 2 |  |  |  |  |  |  |  | Sheet 3
No. | Username | [NAME] | [NAME] | Gender | [NAME] | [NAME] |  | No. | Username | [NAME] | [NAME] | Gender | [NAME] | [NAME] |  | No. | Username | [NAME] | [NAME] | Gender | [NAME] | [NAME]
test 1 |  |  | test 1 | test 1 | test 1 | test 1 |  | test 1 |  |  | test 1 | test 1 | test 1 | test 1 |  | test 1 |  |  | test 1 | test 1 | test 1 | test 1
test 2 |  |  | test 2 | test 2 | test 2 | test 2 |  | test 2 |  |  | test 2 | test 2 | test 2 | test 2 |  | test 2 |  |  | test 2 | test 2 | test 2 | test 2
test 3 |  |  | test 3 | test 3 | test 3 | test 3 |  | test 3 |  |  | test 3 | test 3 | test 3 | test 3 |  | test 3 |  |  | test 3 | test 3 | test 3 | test 3
test 4 |  |  | test 4 | test 4 | test 4 | test 4 |  | test 4 |  |  | test 4 | test 4 | test 4 | test 4 |  | test 4 |  |  | test 4 | test 4 | test 4 | test 4
test 5 |  |  | test 5 | test 5 | test 5 | test 5 |  | test 5 |  |  | test 5 | test 5 | test 5 | test 5 |  | test 5 |  |  | test 5 | test 5 | test 5 | test 5
test 6 |  |  | test 6 | test 6 | test 6 | test 6 |  | test 6 |  |  | test 6 | test 6 | test 6 | test 6 |  | test 6 |  |  | test 6 | test 6 | test 6 | test 6
test 7 |  |  | test 7 | test 7 | test 7 | test 7 |  | test 7 |  |  | test 7 | test 7 | test 7 | test 7 |  | test 7 |  |  | test 7 | test 7 | test 7 | test 7
test 8 |  |  | test 8 | test 8 | test 8 | test 8 |  | test 8 |  |  | test 8 | test 8 | test 8 | test 8 |  | test 8 |  |  | test 8 | test 8 | test 8 | test 8
test 9 |  |  | test 9 | test 9 | test 9 | test 9 |  | test 9 |  |  | test 9 | test 9 | test 9 | test 9 |  | test 9 |  |  | test 9 | test 9 | test 9 | test 9
test 10 |  |  | test 10 | test 10 | test 10 | test 10 |  | test 10 |  |  | test 10 | test 10 | test 10 | test 10 |  | test 10 |  |  | test 10 | test 10 | test 10 | test 10
Spreadsheet: 129145d1321469226-excel-2007-date-formula-to-maitain-data-location-upload-sample
Sheet: DATA

 | start
 | end
 |  | Serial Nbr | Extended Price |  | Serial Nbr | Extended Price |  | Serial Nbr | Extended Price
 |  | 1A309577 | 555.54 |  | 445-11-10321 | 47 |  | 102-07-09784 | 866.56
 |  | 111-05-61559 | 285.13 |  | 445-11-10355 | 208.67 |  | 102-07-09786 | 340.96
 |  | 112-04-51474 | 364.94 |  | 540-06-C02949 | 217.94 |  | 111-05-61559 | 285.13
 |  | 440-09-10763 | 541.68 |  | 740-08-CB12895 | 548.1 |  | 112-04-51474 | 364.94
 |  | 740-09-CB13508 | 692.94 |  | 740-08-CB12902 | 296.5 |  | 440-09-10763 | 541.68
 |  | 740-09-CB15299 | 185.8 |  | 740-08-CB12908 | 2613.25 |  | 740-09-CB13508 | 692.94
 |  |  |  |  | 740-08-CB12914 | 551 |  | 740-09-CB15299 | 185.8
 |  |  |  |  | 740-11-CB22997 | 660.2
 |  |  |  |  | 840-08-79257 | 230.5
Spreadsheet: 693280d1598893932-sumifs-with-index-match-test1
Sheet: Hours

Year |  | 2020
Period |  | 1 | 1 | 1 | 1 | P1 | 2 | 2 | 2 | 2 | P2 | 3 | 3 | 3 | 3 | P3 | 4 | 4 | 4 | 4 | P4 | 5 | 5 | 5 | 5 | P5 | 6 | 6 | 6 | 6 | P6 | 7 | 7 | 7 | 7 | P7 | 8 | 8 | 8 | 8 | P8 | 9 | 9 | 9 | 9 | P9 | 10 | 10 | 10 | 10 | P10 | 11 | 11 | 11 | 11 | P11 | 12 | 12 | 12 | 12 | P12 | 13 | 13 | 13 | 13 | P13 | YTD
Week |  | 1 | 2 | 3 | 4 | Total | 1 | 2 | 3 | 4 | Total | 1 | 2 | 3 | 4 | Total | 1 | 2 | 3 | 4 | Total | 1 | 2 | 3 | 4 | Total | 1 | 2 | 3 | 4 | Total | 1 | 2 | 3 | 4 | Total | 1 | 2 | 3 | 4 | Total | 1 | 2 | 3 | 4 | Total | 1 | 2 | 3 | 4 | Total | 1 | 2 | 3 | 4 | Total | 1 | 2 | 3 | 4 | Total | 1 | 2 | 3 | 4 | Total | Total
Digging |  | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1
Spreadsheet: 780263d1652366307-monthly-task-schedule-that-repeats-dates-on-weekends-and-holidays-monthly-schedule_we-holidays
Sheet: Sheet 2

Day | Date (Mock results) |  |  | # Times to repeat |  |  |  | Holidays
 | 2022-04-01 00:00:00 | static date |  | 2019-12-22 00:00:00 | 3 |  | Fri | 2022-01-03 00:00:00
 |  | formula |  | 2019-12-23 00:00:00 | 1 |  | Fri | 2022-04-15 00:00:00
 |  | formula |  | 2019-12-24 00:00:00 | 1 |  | Mon | 2022-04-18 00:00:00
 |  | formula |  | 2019-12-25 00:00:00 | 1 |  | Mon | 2022-05-03 00:00:00
 |  | formula |  | 2019-12-26 00:00:00 | 1 |  | Thu | 2022-06-02 00:00:00
 |  | formula |  | 2019-12-27 00:00:00 | 1 |  | Fri | 2022-06-03 00:00:00
 |  | formula |  | 2019-12-28 00:00:00 | 4 |  | Mon | 2022-08-29 00:00:00
 |  | formula |  |  |  |  | Mon | 2022-12-26 00:00:00
 |  | formula |  |  |  |  | Tue | 2022-12-27 00:00:00
 |  | formula
 |  | formula
 |  | formula
 |  | formula
 |  | formula
 |  | formula
 |  | formula
 |  | formula
 |  | formula
 |  | formula
 |  | formula
Spreadsheet: 877224d1723973917-only-use-filtered-data-in-formula-blocks-to-destination-problem01
Sheet: Sheet1

1 | 0 |  |  |  |  |  |  | Output:
0 | 1 |  |  |  | Source: | Destination: | Number of Occurances in a row: | Counts the number of occurances of within Blocks Dug where MJ/99/0/NROM5 has been sent to MJ/99/0/SIZRJ >=2 times in a row.
 |  |  |  |  | MJ/99/0/NROM5 | MJ/99/0/SIZRJ | 2
 |  |  |  |  |  |  |  |  | MJ/99/0/SIZRJ
Source | Destination | Row |  |  |  |  |  | MJ/99/0/NROM5 | MJ/99/0/SIZRJ
MJ/99/0/NROM5 | MJ/99/0/SIZRJ | 1 |  |  |  |  |  | 3 | MJ/99/0/SIZRJ
MJ/99/0/NROM5 | MJ/99/0/SIZRJ |  |  |  |  |  |  | MJ/99/0/NROM5 | MJ/99/0/SIZRJ
3 | MJ/99/0/SIZRJ |  |  |  |  |  |  | MJ/99/0/NROM5 | MJ/99/0/SIZRJ
MJ/99/0/NROM5 | A |  |  |  | MJ/99/0/NROM5 | MJ/99/0/SIZRJ | 2 | MJ/99/0/NROM5 | MJ/99/0/SIZRJ
MJ/99/0/NROM5 | A |  |  |  | 3 | MJ/99/0/SIZRJ | 3
2 | a |  |  |  | MJ/99/0/NROM5 | MJ/99/0/SIZRJ | 4
MJ/99/0/NROM5 | A |  |  |  | MJ/99/0/NROM5 | MJ/99/0/SIZRJ | 5
MJ/99/0/NROM5 | MJ/99/0/SIZRJ |  |  |  | MJ/99/0/NROM5 | MJ/99/0/SIZRJ | 6
MJ/99/0/NROM5 | MJ/99/0/SIZRJ |  |  |  |  |  | 7
MJ/99/0/NROM5 | a |  |  |  |  |  | 8
MJ/99/0/NROM5 | MJ/99/0/SIZRJ |  |  |  |  |  | 9
 |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | False
Spreadsheet: 485091d1476703625-look-in-2d-named-range-and-return-the-row-column-number-of-a-reference-cell-value-sample-13
Sheet: Before

 |  |  |  |  |  |  |  |  | Named List = List1 |  |  |  |  |  | GROUP 2 |  |  |  | GROUP 3 |  |  |  | GROUP 4 |  |  |  | GROUP 5 |  |  |  | GROUP 6
 |  |  |  |  |  |  |  |  | Named Range Table = Table1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vlv DN100
 |  |  |  |  |  |  |  |  | Named Range For each Group
 |  |  |  |  |  |  |  |  | Groups 1 to 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vlv DN80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vlv DN200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vlv DN8400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GROUP 1 |  |  |  | GROUP 7 |  |  |  | GROUP 8 |  |  |  | GROUP 9 |  |  |  | GROUP 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TABLE 2
 |  |  |  |  |  |  |  |  | Dynamic List of Valves (List1) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Group | Row | Column
 |  |  |  |  |  |  |  |  | Dis Joint DN 80 |  |  |  |  |  | I've hidden as many rows and columns as possible.
 |  |  |  |  |  |  |  |  | Vlv DN80 |  |  |  |  |  | Each name in the yellow list is unique, so there is no chance to repeat itself on the Table1.
 |  |  |  |  |  |  |  |  | Vlv DN100 |  |  |  |  |  | The position of names in Table1 don't have pattern and may change randomly
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | Vlv DN200 |  |  |  |  |  | I need to determine the 3 values(Group, Row, Column) that define the location of each Name in Table1
 |  |  |  |  |  |  |  |  | Vlv DN8400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In the After-Tab, I've filled TABLE 2 by hand, to show a way the results could appear
Spreadsheet: 714177d1611131031-mark-cell-with-colour-with-largest-deviation-excel_deviation
Sheet: Tabelle1

 |  |  |  |  | Specification Value |  |  | Measurement Results
 |  | IQS Pos no. | DRW grid square | Cavity no. | Nominal  Value | Upper Tolerance | Lower Tolerance | [NAME] | Values myself |  | test
 |  | 16 |  | 1 / 1 | 73.6 | 73.75 | 73.44999999999999 | 73.069
 |  | 16 |  | 1 / 2 | 73.6 | 73.75 | 73.44999999999999 | 73.071
 |  | 16 |  | 1 / 3 | 73.6 | 73.75 | 73.44999999999999 | 73.072
 |  | 16 |  | 2 / 1 | 73.6 | 73.75 | 73.44999999999999 | 73.094
 |  | 16 |  | 2 / 2 | 73.6 | 73.75 | 73.44999999999999 | 73.091
 |  | 16 |  | 2 / 3 | 73.6 | 73.75 | 73.44999999999999 | 73.097
 |  | 18
 |  | 18
 |  | 18
Spreadsheet: 840552d1692809484-solver-with-intermediate-formula-steps-not-working-solver-not-working-2308
Sheet: Answer Report 1

Microsoft Excel 16.0 Answer Report
Worksheet: [Solver not working 2308.xlsx]Sheet1
Report Created: 23/08/2023 17:38:54
Result: Solver found a solution.  All Constraints and optimality conditions are satisfied.
Solver Engine
 | Engine: GRG Nonlinear
 | Solution Time: 0 Seconds.
 | Iterations: 0 Subproblems: 0
Solver Options
 | [NAME],  Iterations Unlimited, Precision 0.000001, Use Automatic Scaling
 | Convergence 0.0001, Population Size 100, Random Seed 0, Derivatives Forward, Require Bounds
 | Max Subproblems Unlimited, [NAME], [NAME] 1%, Assume NonNegative
Objective Cell ([NAME])
 | Cell | Name | Original Value | Final Value
 | $F$5 | Cell to maximise | 1 | 1
Variable Cells
 | Cell | Name | Original Value | Final Value | [NAME]
 | $D$5 | Variable to change | 2 | 2 | [NAME]
Constraints
 | NONE
Spreadsheet: 49f5dd0f-70c4-4b23-82d0-d779d1b5e247
Sheet: Sheet1

Unnamed: 0 | Tên quỹ | FTSE VIETNAM INDEX ETF | Unnamed: 3
 | [NAME] đến ngày | 25/5/2012
 | Tên | Mã CK | %
1 | Tập đoàn Bảo Việt | BVH | 3.4219
2 | Công ty [NAME] phần [NAME] Hạ tầng Kỹ thuật | IJC | 1.7525
3 | Công ty [NAME] phần [NAME] | DRC | 1.0418
4 | [NAME] ty [NAME] phần [NAME] tư Phát triển Xây dựng | DIG | 1.2626
5 | Công ty [NAME] phần [NAME] hiệp Vận chuyển | GMD | 1.4061
6 | Công ty [NAME] phần [NAME] | HAG | 7.6873
7 | Công ty Cổ phần Tập đoàn Hòa [NAME] | HPG | 4.931
8 | Ngân hàng [NAME] phần Ngoại thương Việt Nam | VCB | 6.6831
9 | Công ty [NAME] phần [NAME] tư và Kinh doanh Nhà Khang Điền | KDH | 0.4438
10 | Công ty [NAME] phần [NAME] | KDC | 2.4836
11 | [NAME] ty Phát triển Đô thị Kinh Bắc - CTCP | KBC | 1.9698
12 | Công ty Cổ phần Tập đoàn [NAME] | MSN | 8.5541
13 | Công ty Cổ phần Tập đoàn [NAME] | OGC | 1.8213
14 | [NAME] ty [NAME] bón và Hoá chất [NAME] khí | DPM | 6.0741
15 | Công ty [NAME] phần Khoan và Dịch vụ [NAME] | PVD | 4.5501
16 | Tổng Công ty Tài chính cổ phần [NAME] Việt nam | PVF | 2.7747
17 | [NAME] ty [NAME] phần Dịch vụ [NAME] Dầu khí | PET | 0.5011
18 | Công ty [NAME] phần Nhiệt điện [NAME] | PPC | 1.6866
19 | Công ty [NAME] | PNJ | 1.4607
20 | Công ty [NAME] phần Quốc [NAME] | QCG | 2.2557
21 | Công ty [NAME] phần [NAME] lạnh | REE | 9.388
22 | Công ty [NAME] phần [NAME] tư Phát triển Đô thị và Khu công nghiệp [NAME] | SJS | 2.144
23 | Công ty [NAME] phần [NAME] tư và Công nghiệp Tân Tạo | ITA | 1.9568
24 | Công ty [NAME] phần [NAME] triển đô thị Từ Liêm | NTL | 0.7981
25 | Ngân hàng [NAME] phần Công Thương Việt Nam | CTG | 7.1131
26 | Công ty [NAME] phần Vincom | VIC | 14.415
27 | Công ty [NAME] | VSH | 1.4218
Spreadsheet: 775149d1648841025-extract-data-from-1st-column-while-skipping-blanks-sold-hours
Sheet: Sheet2

999 Tech,Sublet |  | -0.5 |  |  | -0.5
231469 Abdo,Hany |  | 132.6 |  | 231469 Abdo,Hany | 132.6
 |  |  |  | 231482 Bishop,[NAME] | 268.8
 |  |  |  | 231486 Broyles,Ana | 163.7
 |  |  |  | 231491 [NAME],[NAME] | 246.1
 |  |  |  | 231498 Fevrier,Shane | 214
 |  |  |  | 231501 Fry,Chase | 236.7
 |  |  |  | 231507 Guagenti,[NAME] | 220.65
 |  |  |  | 231508 Guardado Flore | 284.5
 |  |  |  | 231510 Haase,[NAME] | 15.3
 |  |  |  | 231514 Heflin,[NAME] | 267.51
 |  |  |  | 231515 Hicks,Christop | 227.5
 |  |  |  | 231517 Hwang,Sukhun | 327.1
 |  |  |  | 231519 Khataev,Anzor | 297.88
 |  |  |  | 231520 Le,Thoai | 473.3
 |  |  |  | 231531 MENDEZ,[NAME] | 330.05
 |  |  |  | 231535 [NAME],[NAME] | 258.2
 |  |  |  | 231544 SHAWN,MASON | 362.7
 |  |  |  | 231545 Shepherd,[NAME] | 189.55
 |  |  |  | 231550 Vallejo Coello | 183.7
 |  |  |  | 231553 WHONGPHAIBOONK | 478.3
 |  |  |  | [NAME],[NAME] | 205.5
 |  |  |  | 231562 Mercado,Diego | 419
 |  |  |  | 231566 Petty,Christop | 383
 |  |  |  | 231595 Salins,[NAME] | -1.7
 |  |  |  | 239031 BARDEN,JONATHA | 238.7
 |  |  |  | 241743 GREGORY,TRAVIS | 302.58
 |  |  |  | 242341 JIMENEZ,CARLOS | 343.21
 |  |  |  | 244609 OLIVA,BRADLEY | 216.55
 |  |  |  | 245376 OLSON,RYAN | 169.55
 |  |  |  | 247681 WALLER,MATTHEW | 12.5
 |  |  |  | 248428 GALINDO,[NAME] | 87.8
 |  |  |  | 248844 MATTHIEU,GERAR | 62.6
 |  |  |  | 250174 BRANNON,BRUCE | 211.1
 |  |  |  | 250423 AHMED,ABDULLAH | 70.2
 |  |  |  | 250496 FEDORYKA,DAMIA | 212.23
 |  |  |  | 250700 ROWE,WYLIE | 162.9
 |  |  |  | S1 | 8273.36
 |  |  |  | GRAND | 8273.36
Spreadsheet: 816130d1675388300-allocating-the-most-repeated-text-and-sorting-it-in-a-specific-cell-example-2-
Sheet: Tabelle1

What | Missed points |  |  |  |  |  | Check In | Check out | Rooming
Check In | a | b | c | d
Check In | b | c | d | f |  |  | d | be | ad
Rooming | ab | ac | ad | ae |  |  | b | bc | af
Check Out | ba | bc | bb | be
Rooming | ac | ad | ae | af
Check Out | bc | bb | be | bf
Check Out | bb | be | bf | bg
Check In | c | d | f | g
Rooming | ad | ae | af | ag
Rooming | ae | af | ag | ah
Spreadsheet: 330068d1404503613-problem-with-indirect-when-i-try-to-link-data-to-multiple-worksheets-indirect-statements-nc
Sheet: Final driver sheet - index

 |  |  |  |  |  | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025
Visitor Roaming
Spreadsheet: bill_williams_iii__1393__EES July Dailies
Sheet: Blank

POSITIVE [NAME] = LONG POSITION
NEGATIVE VARIANCE = SHORT POSITION
NP15 | 2001-06-01 00:00:00 | Flow Day |  |  |  |  | SP15 |  |  |  |  |  |  |  |  | ZP26
Fixed Peak Long |  | Fixed Off Peak Long |  |  |  |  | Fixed Peak Long |  |  |  | Fixed Off Peak Long |  |  |  |  | Fixed Peak Long |  |  | Fixed Off Peak Long
Fixed Peak Short Pos |  | Fixed Off Peak Short |  |  |  |  | Fixed Peak Short |  |  |  | Fixed Off Peak Short |  |  |  |  | Fixed Peak Short |  |  | Fixed Off Peak Short
Index Peak |  | Index [NAME] |  |  |  |  | Index Peak |  |  |  | Index [NAME] |  |  |  |  | Index Peak |  |  | Index [NAME]
HE | Fixed | Transmission from SP | Other EnPower | Load | var |  | HE | Fixed | Transmission to NP/ZP | Other Deals | Other EnPower | Load | var |  |  | HE | Fixed | Transmission from SP | Other EnPower | Load | var
1 |  |  |  |  |  |  | 1 | 0 |  |  |  |  |  |  |  | 1 | 0 |  | 0
2 |  |  |  |  |  |  | 2 | 0 |  |  |  |  |  |  |  | 2 | 0 |  | 0
3 |  |  |  |  |  |  | 3 | 0 |  |  |  |  |  |  |  | 3 | 0 |  | 0
4 |  |  |  |  |  |  | 4 | 0 |  |  |  |  |  |  |  | 4 | 0 |  | 0
5 |  |  |  |  |  |  | 5 | 0 |  |  |  |  |  |  |  | 5 | 0 |  | 0
6 |  |  |  |  |  |  | 6 | 0 |  |  |  |  |  |  |  | 6 | 0 |  | 0
7 |  |  |  |  |  |  | 7 | 0 |  |  |  |  |  |  |  | 7 | 0 |  | 0
8 |  |  |  |  |  |  | 8 | 0 |  |  |  |  |  |  |  | 8 | 0 |  | 0
9 |  |  |  |  |  |  | 9 | 0 |  |  |  |  |  |  |  | 9 | 0 |  | 0
10 |  |  |  |  |  |  | 10 | 0 |  |  |  |  |  |  |  | 10 | 0 |  | 0
11 |  |  |  |  |  |  | 11 | 0 |  |  |  |  |  |  |  | 11 | 0 |  | 0
12 |  |  |  |  |  |  | 12 | 0 |  |  |  |  |  |  |  | 12 | 0 |  | 0
13 |  |  |  |  |  |  | 13 | 0 |  |  |  |  |  |  |  | 13 | 0 |  | 0
14 |  |  |  |  |  |  | 14 | 0 |  |  |  |  |  |  |  | 14 | 0 |  | 0
15 |  |  |  |  |  |  | 15 | 0 |  |  |  |  |  |  |  | 15 | 0 |  | 0
16 |  |  |  |  |  |  | 16 | 0 |  |  |  |  |  |  |  | 16 | 0 |  | 0
17 |  |  |  |  |  |  | 17 | 0 |  |  |  |  |  |  |  | 17 | 0 |  | 0
18 |  |  |  |  |  |  | 18 | 0 |  |  |  |  |  |  |  | 18 | 0 |  | 0
19 |  |  |  |  |  |  | 19 | 0 |  |  |  |  |  |  |  | 19 | 0 |  | 0
20 |  |  |  |  |  |  | 20 | 0 |  |  |  |  |  |  |  | 20 | 0 |  | 0
21 |  |  |  |  |  |  | 21 | 0 |  |  |  |  |  |  |  | 21 | 0 |  | 0
22 |  |  |  |  |  |  | 22 | 0 |  |  |  |  |  |  |  | 22 | 0 |  | 0
23 |  |  |  |  |  |  | 23 | 0 |  |  |  |  |  |  |  | 23 | 0 |  | 0
24 |  |  |  |  |  |  | 24 | 0 |  |  |  |  |  |  |  | 24 | 0 |  | 0
Spreadsheet: 182026d1348240915-requesting-critique-of-my-retirement-spreadsheet-retire-calc3-send
Sheet: results

 | FACTS |  |  |  | OUTCOME
 | life expectancy | 90
 | retirement age | 65 |  |  | total available  at retirement
 | age now | 31
 | years lived post retire |  |  |  | inflation adjusted
 | expence ratio | 0.002 |  |  | total available  at retirement
 | inflation rate | 0.03
 |  |  |  |  | inflation adjusted
 | combined income |  |  |  | yearly "income" after retirement
 | age | income |  |  | monthly "income" after retirement
 | 30-35 | 100000
 | 36-40
 | 41-45
 | 46-50
 | 51-55
 | 56-60
 | 61-65
 | graduated contributions
 | % of pre tax income | 0.07
 | age
 | 30-35
 | 36-40
 | 41-45
 | 46-50
 | 51-55
 | 56-60
 | 61-65
 | graduated investment rate
 | age
 | 30-35 | 0.09
 | 36-40 | 0.08
 | 41-45 | 0.08
 | 46-50 | 0.07
 | 51-55 | 0.07
 | 56-60 | 0.06
 | 61-65 | 0.06
 | average
 | investment rate post retire | 0.05
Spreadsheet: 130402d1322245751-array-formula-to-pull-multiple-numbers-based-on-test-dummy-ot-more-than-1-code-v3
Sheet: P21-2011 Oct 5 - Oct 18

 |  | Pay Period 20 September 21, 2011 - October 4, 2011
 |  | OT Straight Time | OT  Other | OT  Acting Captain | OT  Acting P/C | Stat Holiday | Acting Captain | Acting  P/C | STAT Acting Captain | STAT Acting P/C | Fire Calls | Meetings | TAPP C | Replace WSIB | Replace Bereavement | Replace Sick | Replace Manpower | Replace Parental Leave | Replace Long Term Disability | Replace Education | Replace Suspension | Replace Long Term Sick | Time Owing (P/C Only) | OT Tech - Auto Extrication | OT Tech - HAZMAT | OT Tech - Rope | OT Tech - MSA | OT Tech - Other, Not Listed | OT A/C Tech - Auto Extrication | OT A/C Tech - HAZMAT | OT A/C Tech - Rope | OT A/C Tech - MSA | OT A/C Tech - Other, Not Listed
 |  | ST | OTH | OTAC | OTAPC | STAT | AC | APC | ACST | APCST | FC | MT | TAP | WSIB | B | S | M | PL | LTD | ED | SUSP | LTS | TO | AT | HT | RT | MSAT | OTT | ACAT | ACHT | ACRT | ACMSAT | ACOTT
EMP# | Employee 1 | 0 | 2.75 | 0 | 0 | #N/A | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EMP# | Employee 2 | 0 | 1.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EMP# | Employee 3 | 0 | 1.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EMP# | Employee 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EMP# | Employee 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EMP# | Employee 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EMP# | Employee 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EMP# | Employee 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EMP# | Employee 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Totals |  | 0 | 6.25 | 0 | 0 | #N/A | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0
Spreadsheet: 416226d1440774211-how-to-build-auto-fill-calendar-on-excel-ef804_project_calendar
Sheet: Calendar

 |  | IT Projects - Calendar for July 2015, showing items 1 - 10 |  |  |  |  |  |  |  |  |  |  |  | 1 - 10 | Add further ranges as required at the bottom of column O
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 - 20 | then adjust Data Validation list in M5
 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |  |  |  |  |  |  | 21 - 30
 |  |  |  | 2015-07-01 00:00:00 | 2015-07-02 00:00:00 | 2015-07-03 00:00:00 | 2015-07-04 00:00:00 |  |  | July |  | RANGE |  | 31 - 40
1 |  |  |  | Prepare project idea for data migration | Gain approval from board |  |  |  | Month | 7 |  | 1 - 10 |  | 41 - 50
2 |  |  |  |  |  |  |  |  | Year | 2015 |  |  |  | 51 - 60 | Add more years as required to Data Validation list in K5
3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 61 - 70
4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 71 - 80
5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 81 - 90
6 |  |  |  |  |  |  |  |  |  |  |  |  |  | 91 - 100
7
8
9
10
 | 2015-07-05 00:00:00 | 2015-07-06 00:00:00 | 2015-07-07 00:00:00 | 2015-07-08 00:00:00 | 2015-07-09 00:00:00 | 2015-07-10 00:00:00 | 2015-07-11 00:00:00
1 | Contact IT setup team |  |  | Preliminary proposal | Produce Gantt chart
2 | Contact equities team |  |  |  | Create project baseline
3 | Contact fixed income team |  |  |  | Assign teams to deadlines and objectives
4 | Contact system development team
5 | Collect data
6 | Identify project scope
7 | Coordinate deadlines within teams
8 | Backup system copy
9 | Communicate with tax team on potential effects
10 | Set success criteria
 | 2015-07-12 00:00:00 | 2015-07-13 00:00:00 | 2015-07-14 00:00:00 | 2015-07-15 00:00:00 | 2015-07-16 00:00:00 | 2015-07-17 00:00:00 | 2015-07-18 00:00:00
1 |  | Begin data migration process |  | Complete phase 1 of migration process |  |  | Complete phase 2 of migration process
2
3
4
5
6
7
8
9
10
 | 2015-07-19 00:00:00 | 2015-07-20 00:00:00 | 2015-07-21 00:00:00 | 2015-07-22 00:00:00 | 2015-07-23 00:00:00 | 2015-07-24 00:00:00 | 2015-07-25 00:00:00
1 |  | Complete final phase of migration process |  |  |  |  | Verify stability of data migration, correct if necessary
2
3
4
5
6
7
8
9
10
 | 2015-07-26 00:00:00 | 2015-07-27 00:00:00 | 2015-07-28 00:00:00 | 2015-07-29 00:00:00 | 2015-07-30 00:00:00 | 2015-07-31 00:00:00
1 |  |  |  |  |  | Project completion
2
3
4
5
6
7
8
9
10
1
2
3
4
5
6
7
8
9
10
Spreadsheet: 89262d1289000858-data-vaildation-with-cell-changes-building-lookup
Sheet: Sheet2

 | Building |  |  |  |  | Feet | Building | Value
Feet | A | B | C | D |  | 25 | C
0-15 | 0.32 | 0.57 | 0.85 | 1.03
20 | 0.36 | 0.62 | 0.9 | 1.08
25 | 0.39 | 0.66 | 0.94 | 1.12
30 | 0.42 | 0.7 | 0.98 | 1.16
40 | 0.47 | 0.76 | 1.04 | 1.22
50 | 0.52 | 0.81 | 1.09 | 1.27
60 | 0.55 | 0.85 | 1.13 | 1.31
70 | 0.59 | 0.89 | 1.17 | 1.34
80 | 0.62 | 0.93 | 1.21 | 1.38
90 | 0.65 | 0.96 | 1.24 | 1.4
100 | 0.68 | 0.99 | 1.26 | 1.43
120 | 0.73 | 1.04 | 1.31 | 1.48
140 | 0.78 | 1.09 | 1.36 | 1.52
160 | 0.82 | 1.13 | 1.39 | 1.55
180 | 0.86 | 1.17 | 1.43 | 1.58
200 | 0.9 | 1.2 | 1.46 | 1.61
250 | 0.98 | 1.28 | 1.53 | 1.68
300 | 1.05 | 1.35 | 1.59 | 1.73
350 | 1.12 | 1.41 | 1.64 | 1.78
400 | 1.18 | 1.47 | 1.69 | 1.82
450 | 1.24 | 1.52 | 1.73 | 1.86
500 | 1.56 | 1.56 | 1.77 | 1.89
Feet | Building | Amount
80 | C