tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 103351d1301079563-losing-formulas-after-live-office-update-post-update-clean-sample
Sheet: Spec Rate Repair Hours

 | Jan Spec Rate Hrs |  | Feb Spec Rate Hrs | [NAME] |  | Apr Spec Rate Hrs |  | May Spec Rate Hrs |  | June Spec Rate Hrs |  | July Spec Rate Hrs |  | Aug Spec Rate Hrs |  | Sept Spec Rate Hrs |  | Oct Spec Rate Hrs |  | Nov Spec Rate Hrs |  | Dec Spec Rate Hrs
Labor Rate | Mo Hours | Labor Rate | Mo Hours | Labor Rate | Mo Hours | Labor Rate | Mo Hours | Labor Rate | Mo Hours | Labor Rate | Mo Hours | Labor Rate | Mo Hours | Labor Rate | Mo Hours | Labor Rate | Mo Hours | Labor Rate | Mo Hours | Labor Rate | Mo Hours | Labor Rate | Mo Hours
74 | 1.6 | 72 | 2.1 | 69 | 1.4 | 74 | 4.7 | 69 | 3.2 | 65 | 7 | 65 | 3.7 | 65 | 6.4 | 59 | 4.5 | 63 | 3 | 59 | 1 | 59 | 5.5
80 | 0.7 | 74 | 6.9 | 81 | 35.7 | 82 | 8.5 | 81 | 9.4 | 74 | 3.8 | 69 | 16.8 | 69 | 5.7 | 63 | 0.3 | 67 | 8.3 | 63 | 2 | 63 | 0.5
81 | 23.3 | 80 | 0.5 | 82 | 4.7 | 96 | 5.7 | 82 | 13.2 | 80 | 2.1 | 74 | 9.9 | 82 | 3.9 | 65 | 19.2 | 70 | 13.4 | 65 | 23.6 | 65 | 23.1
82 | 3.7 | 81 | 96.5 | 92 | 5.7 | 96.3 | 63.5 | 92 | 1 | 81 | 20.1 | 82 | 3.2 | 92 | 2.6 | 69 | 3.7 | 74 | 3 | 69 | 1.4 | 67 | 0.5
94 | 1.9 | 82 | 6.5 | 92.7 | 1 | 103.5 | 143 | 96 | 9.2 | 82 | 5.6 | 92 | 13.1 | 92.7 | 1.5 | 80 | 0.2 | 82 | 3.1 | 70 | 3 | 92 | 1.5
96 | 15.1 | 94 | 2.8 | 96 | 10.4 | 110 | 6.5 | 96.3 | 11.4 | 92 | 1.3 | 96 | 39.6 | 96 | 1.1 | 82 | 9.6 | 96.3 | 68.3 | 82 | 2 | 96 | 99.5
96.3 | 12.7 | 96.3 | 22.4 | 96.3 | 17.8 | 115 | 10.9 | 103.5 | 198 | 96.3 | 25.2 | 96.3 | 51.1 | 96.3 | 31.4 | 92 | 1.3 | 103.5 | 108 | 92 | 4 | 96.3 | 42
103.5 | 136.8 | 103.5 | 118.6 | 103.5 | 162.8 |  |  | 105.09 | 0.1 | 103.5 | 217.6 | 103.5 | 195.3 | 103.5 | 168.8 | 96 | 23.9 | 105.09 | 0.7 | 92.7 | 1.1 | 103.5 | 88.5
110 | 14.6 | 110 | 18.3 | 110 | 12.2 |  |  | 110 | 31.1 | 110 | 35.8 | 110 | 14 | 105.09 | 0.5 | 96.3 | 57.9 | 110 | 26.1 | 96 | 5 | 110 | 19.9
115 | 11 | 115 | 16.4 | 115 | 16.2 |  |  | 115 | 21.1 | 115 | 10.7 | 115 | 40.6 | 110 | 20.1 | 103.5 | 173 | 115 | 42.4 | 96.3 | 33.4 | 115 | 1.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 115 | 5.4 | 105.09 | 1.4 |  |  | 103.5 | 64.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 110 | 29.7 |  |  | 105.09 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 115 | 10 |  |  | 110 | 18.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 115 | 2.7
Spreadsheet: 781209d1653060770-need-help-with-pulling-data-from-one-sheet-to-another-using-index-requiredtraining2022-test
Sheet: Dashboard

Select Supervisor Below | SupervisorList |  | Employee Name | Class1 | Class2 |  | Monday1End | Monday2End | Tuesday1End | Tuesday2End | Wednesday1End | Wednesday2End | Thursday1End | Thursday2End | [NAME] | Friday2End
Supervisor, [NAME] | Supervisor, [NAME] |  | Employee, Mister | 2019-12-09 00:00:00 | 2019-05-08 00:00:00
 | Supervisor, [NAME] |  | Employee, [NAME] | 2020-12-03 00:00:00 | 2018-05-24 00:00:00
Spreadsheet: 792343d1660842860-how-to-use-offset-when-the-reference-is-a-formula-linked-to-another-tab-new-report-log
Sheet: Monthly Totals

Monthly Report Target Monitoring Summary
Month | SACC |  |  |  | JAC |  |  |  | Neuromotor |  |  |  | CDC |  |  |  | Epilepsy |  |  |  | VADA |  |  |  | Downs |  |  |  | Whitefield School |  |  |  | Brookfield School |  |  |  | Neurodevelop-mental |  |  |  | Adoption & Fostering |  |  |  | Immunisations |  |  |  | LAC |  |  |  | SEN |  |  |  | Monthly Summary
 | Total | Met Target | Missed Target | % In Target | Total | Met Target | Missed Target | % In Target | Total | Met Target | Missed Target | % In Target | Total | Met Target | Missed Target | % In Target | Total | Met Target | Missed Target | % In Target | Total | Met Target | Missed Target | % In Target | Total | Met Target | Missed Target | % In Target | Total | Met Target | Missed Target | % In Target | Total | Met Target | Missed Target | % In Target | Total | Met Target | Missed Target | % In Target | Total | Met Target | Missed Target | % In Target | Total | Met Target | Missed Target | % In Target | Total | Met Target | Missed Target | % In Target | Total | Met Target | Missed Target | % In Target | Total | Met Target | Missed Target | % In Target
2022-09-01 00:00:00
2022-10-01 00:00:00
2022-11-01 00:00:00
2022-12-01 00:00:00
2023-01-01 00:00:00
2023-02-01 00:00:00
2023-03-01 00:00:00
2023-04-01 00:00:00
2023-05-01 00:00:00
2023-06-01 00:00:00
2023-07-01 00:00:00
2023-08-01 00:00:00
2023-09-01 00:00:00
2023-10-01 00:00:00
2023-11-01 00:00:00
2023-12-01 00:00:00
2024-01-01 00:00:00
2024-02-01 00:00:00
2024-03-01 00:00:00
2024-04-01 00:00:00
2024-05-01 00:00:00
2024-06-01 00:00:00
2024-07-01 00:00:00
2024-08-01 00:00:00
2024-09-01 00:00:00
2024-10-01 00:00:00
2024-11-01 00:00:00
2024-12-01 00:00:00
2025-01-01 00:00:00
2025-02-01 00:00:00
2025-03-01 00:00:00
2025-04-01 00:00:00
2025-05-01 00:00:00
2025-06-01 00:00:00
2025-07-01 00:00:00
2025-08-01 00:00:00
2025-09-01 00:00:00
2025-10-01 00:00:00
2025-11-01 00:00:00
2025-12-01 00:00:00
Spreadsheet: 356662d1415181655-column-sort-without-chaning-formulae-jc-booking-september-2014
Sheet: 8th

Date |  |  |  |  |  |  |  |  |  |  |  | DAY SHEET
Job No | Due | Contact | Contact No. | Car | Imax | 13 Pax | 20 Pax | 24 Pax | 29 Pax | 44 Pax | FROM | TO | Retn | Price  $ | Dep  $ | Bal | Mode | Pax | Trailer | Con | Bus | Des | Driver
9197 | 1330 | [NAME] High School | 83048420 |  |  |  |  |  | 1 |  | Marryatville High School | [NAME] Rd Magil | y | 135 | 0 |  | acct | 28 |  |  |  |  | [NAME]
 | 1500 | [NAME] High School | 83048420 |  |  |  |  |  | 1 |  | [NAME] Rd Magil | Marryatville High School | n | 135 | 0 |  | acct | 28 |  |  |  |  | [NAME]
 | 1300 | [NAME] High School | 83048420 |  |  |  |  | 1 |  |  | Marryatville High School | Vertical Reality Climbing Holden Hill | y | 100 | 0 |  | acct | 24 |  |  |  |  | claudio
 | 1500 | [NAME] High School | 83408420 |  |  |  |  | 1 |  |  | Vertical Reality Climbing Holden Hill | Marryatville High School | n | 100 | 0 |  | acct | 24 |  |  |  |  | claudio
 | 1355 | [NAME] | GTA |  | 1 |  |  |  |  |  | QF 668 | Mercure Grosvenor | no | 55.25 | 0 |  | acct | 2 |  |  |  |  | cat
 | 0745 | [NAME] | [PHONE] |  |  | 1 |  |  |  |  | Torrens Rowing Club City | Loreto College | n | 68 | 0 |  | acct | 12 |  |  |  |  | [NAME]
 | 1545 | [NAME] Loreto College 316 Portrush Road ,Marryatville | 83344255/[PHONE] |  |  |  |  |  | 1 |  | Loreto College Marryatville | River Torrens City Rowing Club | n | 145 | 0 |  | acct | 25 |  |  |  |  | [NAME]
 | 1600 | Mr [NAME] x 4 | Virgin 149714 |  | 1 |  |  |  |  |  | [NAME] | Airport | n | 50 | 0 |  | acct | 4 |  |  |  |  | cat
 | 1600 | M/M Mackay | Virgin 149950 |  | 1 |  |  |  |  |  | Grand Chancellor [NAME] | Airport | n | 37.5 | 0 |  | acct | 2 |  |  |  |  | [NAME]
 | 14.55 | Annabelle | [PHONE] |  |  |  |  |  |  |  | QF 722 Alice Springs | 7&9 [NAME] | n | 70 | 70 |  | Paid | 9 |  |  |  |  | cat
 | 0900 | Adelaide High SchoolDanny |  |  |  |  |  |  |  |  | Adelaide High | [NAME] | n | 595 | 0 |  | acct |  |  |  |  |  | Dom
 |  | No School run Cowandilla Student Free Day | ELIZABETH PARK PS AND CHI
 |  |  | Pupil Free Day 08.09.14 at Elizabeth Park. |  |  |  |  |  |  |  | Malaysia 0715  -Apt
 |  |  |  |  |  |  |  |  |  |  | Malaysia 1230 - Hotel
TOTAL
Spreadsheet: 807787d1670053615-changing-cell-that-multiple-formula-use-in-multiple-work-books-file
Sheet: Sheet1

 | Sales Budget | Layaway Goal | MTD New Layaway | (+/-) | Days left in the month | Daily Average needed | MTD %
 |  |  |  |  | 24
District
Commission qualifier |  | 0.55 | MTD
Spreadsheet: 235823d1368616655-baseball-team-standings-softball-league
Sheet: Home and Away

 | Abu Dhabi Softball League
 | - Schedule - Results -
 | SCHEDULE | Umps | Home | Score | Away | Score
 | 2013-05-14 00:00:00 |  | Round 1
 | 19:00:00 | 3 | [NAME] | 22 | Benchwarmers | 4
 | 20:00:00 | 1 | [NAME] | 2 | Millennium Falcons | 9
 | 21:00:00 | 8 | Mother Falcons | 9 | Blue Jays | 7
 | 10:00 PM | 5 | Ballbarians | 14 | Abu Dhabi Mudcrabs | 13
 | 2013-05-21 00:00:00 |  | Round 2
 | 19:00:00
 | 20:00:00
 | 21:00:00
 | 10:00 PM
 | 2013-05-28 00:00:00 |  | Round 3
 | 19:00:00
 | 20:00:00
 | 21:00:00
 | 10:00 PM
 | 2013-06-04 00:00:00 |  | Round 4
 | 19:00:00
 | 20:00:00
 | 21:00:00
 | 10:00 PM
 | 2013-06-11 00:00:00 |  | Round 5
 | 19:00:00
 | 20:00:00
 | 21:00:00
 | 10:00 PM
 | 2013-06-18 00:00:00 |  | Round 6
 | 19:00:00
 | 20:00:00
 | 21:00:00
 | 10:00 PM
 | 2013-06-25 00:00:00 |  | Round 7
 | 19:00:00
 | 20:00:00
 | 21:00:00
 | 10:00 PM
 | 2013-07-02 00:00:00 |  | Round 8
 | 19:00:00
 | 20:00:00
 | 21:00:00
 | 10:00 PM
Spreadsheet: 870819d1717256165-countifs-strange-behaviour-countifs
Sheet: Sheet1

2020-04-09 00:00:00 |  |  |  |  |  |  |  |  |  |  | =COUNTIFS(MONTH(A1:A10),6)
2020-04-10 00:00:00 |  |  |  | #[NAME]! | a range is passed and accepted?
2020-04-29 00:00:00 |  |  |  | #[NAME]! | formula can be entered |  |  |  |  |  | doesn't work because an array is passed, but only a range is accepted
2020-05-05 00:00:00 |  |  |  | #[NAME]! | but why is it not working? |  |  |  |  |  | formula cannot even be entered
2020-05-13 00:00:00 |  |  |  | #[NAME]!
2020-05-23 00:00:00 |  |  |  | #[NAME]!
2020-05-26 00:00:00 |  |  |  | #[NAME]!
2020-06-02 00:00:00 |  |  |  | #[NAME]!
2020-06-05 00:00:00 |  |  |  | #[NAME]!
2020-05-04 00:00:00 |  |  |  | #[NAME]!
Spreadsheet: 43517d1242157453-highlight-entire-row-when-word-is-in-cell-conveyor
Sheet: Sheet1

Table
Chair
TV
Conveyor
Table
Chair
TV
Conveyor
Table
Chair
TV
Conveyor
Table
Chair
TV
Conveyor
Table
Chair
TV
Conveyor
Table
Chair
TV
Conveyor
Table
Chair
TV
Conveyor
Table
Chair
TV
Conveyor
Table
Chair
TV
Conveyor
Table
Chair
TV
Conveyor
Table
Chair
TV
Conveyor
Table
Chair
TV
Spreadsheet: 83207d1283247107-if-or-match-problem-match-or-if
Sheet: Sheet1

Product | d1 | d2 | d3 | d4 | d5 |  |  |  | Product | d1 | d2 | d3 | d4 | d5
4 |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
5 |  |  |  |  |  |  |  |  | 2 | 3 | 2 | 2 | 1 | 1
11 |  |  |  |  |  |  |  |  | 3 | 2 | 3 | 3 | 2 | 1
14 |  |  |  |  |  |  |  |  | 4 | 1 | 1 | 2 | 1 | 1
16 |  |  |  |  |  |  |  |  | 5 | 1 | 1 | 1 | 1 | 2
17 |  |  |  |  |  |  |  |  | 6
21 |  |  |  |  |  |  |  |  | 7 | 1 | 2 | 1 | 2 | 1
25 |  |  |  |  |  |  |  |  | 8 | 2 | 1 | 2 | 3 | 2
27 |  |  |  |  |  |  |  |  | 9 | 1 | 3 | 3 | 3 | 2
29 |  |  |  |  |  |  |  |  | 10 | 1 | 2 | 2 | 2 | 2
30 |  |  |  |  |  |  |  |  | 11 | 1 | 2 | 2 | 1 | 1
36 |  |  |  |  |  |  |  |  | 12 | 3 | 3 | 2 | 1 | 2
41 |  |  |  |  |  |  |  |  | 13 | 2 | 1 | 3 | 1 | 2
11 |  |  |  |  |  |  |  |  | 14 | 3 | 3 | 3 | 2 | 3
12 |  |  |  |  |  |  |  |  | 15 | 3 | 3 | 2 | 3 | 2
14 |  |  |  |  |  |  |  |  | 16 | 1 | 1 | 1 | 1 | 3
17 |  |  |  |  |  |  |  |  | 17 | 2 | 2 | 3 | 2 | 3
19 |  |  |  |  |  |  |  |  | 18 | 3 | 2 | 2 | 2 | 3
20 |  |  |  |  |  |  |  |  | 19 | 3 | 2 | 3 | 3 | 1
23 |  |  |  |  |  |  |  |  | 20 | 1 | 2 | 2 | 2 | 3
27 |  |  |  |  |  |  |  |  | 21 | 1 | 1 | 1 | 3 | 1
28 |  |  |  |  |  |  |  |  | 22 | 3 | 2 | 2 | 3 | 2
34 |  |  |  |  |  |  |  |  | 23 | 1 | 1 | 1 | 3 | 3
36 |  |  |  |  |  |  |  |  | 24 | 3 | 3 | 3 | 2 | 1
41 |  |  |  |  |  |  |  |  | 25 | 2 | 2 | 3 | 3 | 1
42 |  |  |  |  |  |  |  |  | 26 | 1 | 3 | 3 | 1 | 1
3 |  |  |  |  |  |  |  |  | 27 | 2 | 1 | 3 | 2 | 3
 |  |  |  |  |  |  |  |  | 28 | 1 | 2 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  | 29 | 1 | 3 | 2 | 1 | 2
 |  |  |  |  |  |  |  |  | 30 | 2 | 2 | 2 | 3 | 3
 |  |  |  |  |  |  |  |  | 31 | 3 | 2 | 3 | 1 | 3
 |  |  |  |  |  |  |  |  | 32 | 2 | 2 | 2 | 2 | 2
 |  |  |  |  |  |  |  |  | 33 | 2 | 2 | 1 | 1 | 2
 |  |  |  |  |  |  |  |  | 34 | 1 | 1 | 1 | 2 | 1
 |  |  |  |  |  |  |  |  | 35 | 2 | 2 | 1 | 2 | 1
 |  |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  |  | 37 | 2 | 2 | 1 | 2 | 2
 |  |  |  |  |  |  |  |  | 38 | 2 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  | 39 | 2 | 1 | 2 | 2 | 2
 |  |  |  |  |  |  |  |  | 40 | 2 | 3 | 3 | 1 | 3
 |  |  |  |  |  |  |  |  | 41 | 3 | 3 | 3 | 3 | 3
 |  |  |  |  |  |  |  |  | 42 | 2 | 1 | 1 | 3 | 3
 |  |  |  |  |  |  |  |  | 43 | 2 | 3 | 2 | 3 | 2
 |  |  |  |  |  |  |  |  | 44 | 1 | 1 | 3 | 1 | 2
 |  |  |  |  |  |  |  |  | 45 | 1 | 1 | 1 | 2 | 2
Spreadsheet: 216923d1361920367-help-with-conditional-formatting-duplicate-values-duplicate-value-example
Sheet: Sheet1

00650 | 00605
00650 | 00605
00660 | 00606
00660 | 00606
00661 | 00607
00660 | 00607
00662 | 00608
00700 | 00700
00700 | 00700
00700 | 00700
00700 | 00700
00700 | 00700
00700 | 00700
00700 | 00700
00700 | 00700
00700 | 00700
00700 | 00700
00700 | 00700
00700 | 00700
00700 | 00700
01951 | 00701
00800 | 00800
00800 | 00800
00800 | 00800
Spreadsheet: michelle_lokay__26697__imball0111rev
Sheet: EOG

 | 500249 |  | 500260 |  | 500646 |  | 500598
 | Pronghorn |  | Pitchfork Ranch |  | Tristi Draw |  | EOG/TW Eddy
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 15108 | 15200 | 9741 | 8900 | 7654 | 4100
2 | 15355 | 13218 | 9038 | 7447
3 | 14971 | 12096 | 9348 | 6815
4 | 14927 | 14200 | 9225 | 8000 |  |  | 244
5 | 14715 | 14200 | 8325 | 8000 |  |  | 49
6 | 14510 | 13499 | 9284 | 7605
7 | 14591 | 12779 | 8671 | 7390
8 | 14662 | 11937 | 6125 | 6902
9 | 14430 | 14700 | 6883 | 8500
10 | 14276 | 14239 | 6321 | 8234
11 | 14081 | 14436 | 8551 | 8348
12 | 14210 | 13033 | 9100 | 7536
13 | 13787 | 14700 | 9248 | 7500
14 | 13693 | 14392 | 9481 | 7343
15 | 14259 | 13768 | 9277 | 7700
16 | 14530 | 11487 | 8828 | 6425
17 | 11934 | 14000 | 8902 | 7830
18 | 14146 | 14000 | 8193 | 7830
19 | 9475 | 14000 | 6359 | 7830 |  |  | 918
20 | 8968 | 14000 | 8637 | 7830
21 | 13882 | 11361 | 8160 | 6660
22 | 13913 | 14000 | 8103 | 8200
23 | 13842 | 14000 | 8582 | 8200
24 | 14020 | 14000 | 8720 | 8200
25 | 13888 | 14000 | 9432 | 8200
26 | 13865 | 14000 | 9779 | 8200
27 | 10105 | 14000 | 8113 | 8200
28 | 12328 | 14000 | 8213 | 8200
29 | 13900 | 14000 | 7571 | 8200
30 | 13952 | 13942 | 8824 | 8166
31
2001-10-31 00:00:00 |  |  |  |  |  |  |  |  | 8858.28
2001-11-30 00:00:00
CBS Volume
 |  |  | -121451
Spreadsheet: 201170d1355903846-sales-mix-model-test
Sheet: Sheet1

 | Order Type | Brand | Design | Index | Coating | Process Type
 | Rx | A | [NAME] | Low Index | HC | Conventional
 | FSV | B | Prog | Hi-Index | Uncoated | Free-form
 | All | C | SV | All | ARC | All
 |  | All | All |  | All
 | Order Type | Mix %
 | RX | 0.4
 | FSV | 0.6
 | Brand | Mix %
 | A | 0.2
 | B | 0.6
 | C | 0.2
 | Design | Mix %
 | [NAME] | 0.58
 | Prog | 0.07
 | SV | 0.35
 | Index | Mix %
 | Low Index | 0.9
 | Hi-Index | 0.1
 | Coating | %
 | Uncoated | 0.2
 | HC | 0.3
 | ARC | 0.5
 | Process Type | Mix %
 | Low Index | 0.9
 | Hi-Index | 0.1
 | Output
 | Gross Margin | %
Spreadsheet: 181170d1347953190-help-with-personal-finance-template-fianance-spreadsheet
Sheet: oct12

October 2012
 | Commbank Credit Card |  | Bal: |  |  |  |  | This Months Budget
 | Date | Description | In/Out | Balance | Type | More Info |  | Item | Actual | Allocated
 |  |  |  |  |  |  |  | Clothing |  | 0
 |  |  |  |  |  |  |  | Electronics |  | 0
 |  |  |  |  |  |  |  | Entertainment |  | 0
 |  |  |  |  |  |  |  | Food |  | 0
 |  |  |  |  |  |  |  | Games |  | 0
 |  |  |  |  |  |  |  | Misc |  | 0
 |  |  |  |  |  |  |  | One-off |  | 0
 |  |  |  |  |  |  |  | Other |  | 0
 |  |  |  |  |  |  |  | Petrol |  | 0
 |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  | Salary
 |  |  |  |  |  |  |  | Savings
 |  |  |  |  |  |  |  | Expenditure
 | Date | Description | Cash Out | Balance | Type | More Info
 | Totals
Spreadsheet: jeffrey_a_shankman__13934__MgmtSum-Q401-Global-111601
Sheet: GM-WeeklyChnge

ENRON GLOBAL MARKETS
4th QUARTER 2001 DETAIL OF GROSS MARGIN - WEEKLY CHANGE
 |  |  |  |  | Accrual / |  | Actual | Deals | Forecast | Total
Business Team |  | DPR(1) | MPR | Accruals | Other | FTA | Margin | Identified | Margin | Margin
Crude & Products |  |  |  |  |  | 0 |  | 0
Coal / Emissions |  |  |  |  |  | 0 |  | 0
Vessel Trading |  |  |  |  |  | 0 |  | 0
Emissions |  |  |  |  |  | 0 |  | 0
Weather |  |  |  |  |  | 0 |  | 0
Insurance Risk Markets |  |  |  |  |  | 0 |  | 0
Equity Trading |  |  |  |  |  | 0 |  | 0
Convertible Trading |  |  |  |  |  | 0 |  | 0
FX / Int Rate Trading |  |  |  |  |  | 0 |  | 0
Soft Commodities Trading |  |  |  |  |  | 0 |  | 0
Grain Trading |  |  |  |  |  | 0 |  | 0
Meat Trading |  |  |  |  |  | 0 |  | 0
Financial Trading
Freight Markets |  |  |  |  |  | 0 |  | 0
LNG |  |  |  |  |  | 0 |  | 0
Puerto Rico |  |  |  |  |  | 0 |  | 0
Japan
Drift
Finance and Structuring |  |  |  |  |  | 0 |  | 0
Office of the Chairman |  |  |  |  |  | 0 |  | 0
Overview |  |  |  |  |  | 0 |  | 0
Subtotal Gross Margin Change
Other Interest Related Charges |  |  |  | 0 |  | 0 |  | 0
Change in EGM Pre-tax Income
(1) Excludes Cap. Charge & Operating Costs
Spreadsheet: 24628d1215197498-working-with-if-cmd-ver-banki-lur
Sheet: Verðbanki

 | Verðbanki Ölur 2008
 |  |  |  |  |  |  | Gerð
 | [NAME]. |  | Stærðir |  |  |  | [NAME] | [NAME] | Spónlagt | Sprautað |  | Fjöldi |  | Samtals
NR. | Heiti |  | X | Y | Z |  | Einingarverð | Einingarverð | Einingarverð | Einingarverð |  | Stk. |  | kr
1 | Eldhús
1.1 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tegund Innréttingar
 | [NAME] |  | 30 | 70 | 30 |  | 7000 | 8000 | 9000 | 10000 |  | 3 |  |  |  | [NAME]
 | [NAME] |  |  |  |  |  | 8000 | 9000 | 10000 | 11000 |  | 5 |  |  |  | [NAME]
 | [NAME] 3 |  |  |  |  |  | 9000 | 10000 | 11000 | 12000 |  | 2 |  |  |  | Spónlagt | X
 | [NAME] |  |  |  |  |  | 10000 | 11000 | 12000 | 13000 |  | 5 |  |  |  | Sprautað
 | [NAME] 5 |  |  |  |  |  | 11000 | 12000 | 13000 | 14000 |  | 1
 | [NAME] 6 |  |  |  |  |  | 12000 | 13000 | 14000 | 15000 |  | 3 |  | 150000
 | [NAME] 7 |  |  |  |  |  | 13000 | 14000 | 15000 | 16000 |  | 3
 | [NAME] 8 |  |  |  |  |  | 14000 | 15000 | 16000 | 17000 |  | 1
 | [NAME] 9
 | [NAME] 10
 | [NAME] 11
 | [NAME] 12
 | [NAME] 13
 | [NAME] 14
 | [NAME] 15
 | [NAME] 16
 | Samtals |  |  |  |  |  |  |  |  |  |  |  |  | 150000
1.2 | Neðri skápar
Spreadsheet: 116437d1311837335-vlookup-based-on-two-criteria-sale-1-
Sheet: A

Inv | Date | [NAME] | Batch | quantity
1 | 2011-04-01 00:00:00 | WHITE | 8414 | 151.4 |  | 0
2 | 2011-04-01 00:00:00 | YELLOW | 828 | 175 |  | 0
3 | 2011-04-01 00:00:00 | RED | 840 | 191.4 |  | 840
4 | 2011-04-01 00:00:00 | GREEN | C041 | 107.3 |  | 0
5 | 2011-04-02 00:00:00 | WHITE | 851 | 75 |  | 851
6 | 2011-04-04 00:00:00 | WHITE | 8541 | 4000 |  | 8541
7 | 2011-04-04 00:00:00 | BLACK | 8534 | 8520 |  | 8534
7 | 2011-04-04 00:00:00 | BLACK | 8423 | 1500 |  | 8534
8 | 2011-04-04 00:00:00 | BLACK | 8531 | 9000 |  | 8531
990001 | 2011-04-04 00:00:00 | NAVY BLUE | 8530 | 279.1 |  | 8530
990002 | 2011-04-04 00:00:00 | GREY | 8518 | 1274.4 |  | 0
9 | 2011-04-05 00:00:00 | WHITE | 8439 | 500 |  | 0
10 | 2011-04-05 00:00:00 | YELLOW | 8523 | 100.6 |  | 0
11 | 2011-04-05 00:00:00 | YELLOW | 8551 | 25 |  | 0
12 | 2011-04-05 00:00:00 | MAGENTA | 8438 | 324.4 |  | 8438
13 | 2011-04-05 00:00:00 | BEIGE | 842 | 100.5 |  | 842
Spreadsheet: 108285d1305301694-auto-create-hyperlinks-to-files-on-list
Sheet: Sheet1

DOCUMENT NUMBER | REV | DOCUMENT TITLE | DISCIPLINE | ISSUE | PKG 1 | PKG 2 | PKG 3 | PKG 4
A1.1.1 PROCESS
A1.1.1.1 PROCESS DESCRIPTION
AD159-S00000-D-RPT-01231 | 0DRAFT | PROCESS DESCRIPTION | 225 |  |  | [ 2 ]
A1.1.1.2 DESIGN BASIS CRITERIA
AD159-S00000-D-RPT-01227 | 0B | BASIC ENGINEERING DESIGN DATA | 225 | 2011-02-05 00:00:00
AD159-S00000-D-RPT-01230 | A | ZIRKU ISLAND PROCESS DESIGN BASIS | 225 | 2010-06-23 00:00:00
AD159-S00000-D-RPT-01232 | 0 | PROCESS INSTRUMENT AND UTILITY AIR SYSTEM DESIGN BASIS | 225 | 2011-01-25 00:00:00
AD159-S00000-D-RPT-01233 | 0 | PROCESS REPORT - FLARE SYSTEMS PROCESS DESIGN BASIS | 225 | 2011-02-21 00:00:00
AD159-S00000-D-RPT-01234 | 0 | PROCESS REPORT - FUEL GAS SYSTEM DESIGN BASIS | 225 | 2011-02-05 00:00:00
AD159-S00000-D-RPT-01235 | 0 | NITROGEN SYSTEM DESIGN BASIS | 225 | 2011-02-10 00:00:00
AD159-S00000-D-RPT-01236 | 0 | DIESEL SYSTEM DESIGN BASIS | 225 | 2011-01-24 00:00:00
AD159-S00000-D-RPT-01237 | 0 | PROCESS REPORT - HYDRAULIC POWER SYSTEM DESIGN BASIS | 225 | 2011-01-24 00:00:00
AD159-S00000-D-RPT-01238 | 0 | SANITARY WASTE DESIGN BASIS | 225 | 2011-02-10 00:00:00
AD159-S00000-D-RPT-01239 | 0 | POTABLE AND UTILITY WATER DESIGN BASIS | 225 | 2011-02-21 00:00:00
AD159-S00000-D-RPT-01240 | 0 | COOLING WATER DESIGN BASIS | 225 | 2011-01-25 00:00:00
AD159-S00000-D-RPT-01241 | 0 | WASTEWATER DESIGN BASIS | 225 | 2011-02-17 00:00:00
AD159-S00000-D-RPT-01242 | 0 | REPORT - ARTIFICIAL ISLAND PROCESS DESIGN BASIS | 225 | 2011-01-25 00:00:00
AD159-S00000-D-RPT-01243 | 0 | HOT OIL SYSTEM DESIGN BASIS | 225 | 2011-01-25 00:00:00
AD159-S00000-D-RPT-01244 | 0 | PROCESS REPORT - PRODUCED WATER TREATMENT DESIGN BASIS | 225 | 2011-02-10 00:00:00
AD159-S00000-D-RPT-01246 | 0 | SEAWATER AND  WATER TREATMENT DESIGN BASIS | 225 | 2011-02-17 00:00:00
AD159-S00000-D-RPT-01247 | 0 | FIREWATER SUPPLY SYSTEM DESIGN BASIS | 225 | 2011-02-17 00:00:00
AD159-S00000-D-RPT-01248 | 0 | INJECTION WATER PLANT PROCESS DESIGN BASIS | 225 | 2011-02-15 00:00:00
AD159-S00000-D-RPT-01251 | 0 | SEAWATER REVERSE OSMOSIS DESIGN BASIS | 225 | 2011-02-07 00:00:00
A1.1.1.3 PROCESS STUDIES & REPORTS
AD159-S00000-D-RPT-01229 | 0 | INJECTION GAS QUALITY REPORT | 225 | 2011-02-05 00:00:00
AD159-S00000-D-RPT-01245 | B | COMMISSIONING AND STARTUP UP FUEL | 225 | 2011-04-25 00:00:00
AD159-S00000-D-RPT-01249 | A | PROCESS SIMULATION REPORT | 225 | 2011-03-03 00:00:00
AD159-S00000-D-RPT-01250 | A | PROCESS SIMULATION BASIS | 225 | 2010-07-15 00:00:00
Spreadsheet: 133455d1324402781-search-for-a-word-in-a-cell-example
Sheet: Change Log

Item # | Model | File | Affected Event/Gate | Details of Change | Comments | Resp. Engr. | Date
1 | rev.0 | MODEL | UN_76_RTE | Added OR gate LLLDR3XX__0000000 | Added to incorporate Stuff | YMB | 2010-11-17 00:00:00
2 | rev.0 | MODEL | UN_76_RTS | Added existing XXX_0_YMTABLP66 and OR gate GGGLI0TT_0126666 | Added to incorporate Stuff | YMB | 2010-11-17 00:00:00
3 | rev.0 | MODEL | UN_76_RTS | Added existing XXX_0_Y4445BLP66 and OR gate LRTLT00CHGA7775689 | Added to incorporate Stuff | YMB | 2010-11-17 00:00:00
4 | rev.0 | MODEL | UN_76_RTS | Removed Gate PPPLI0TT_0126666 | Removed to incorporate Stuff | YMB | 2010-11-17 00:00:00
5 | rev.0 | MODEL | UN_76_RTS | Added existing XXX_0_YMTABLP66 and OR gate GGGLI0TT_0126666 | Added to incorporate Stuff | YMB | 2010-11-17 00:00:00
6 | rev.0 | MODEL | LLLDR3XX__0000000 | Added Events LLLDR3XX__0000001, LLLDR3XX__0000002, LLLDR3XX__0000003, LLLDR3XX__0000004, LLLDR3XX__0000005, LLLDR3XX__0000006, LLLDR3XX__0000007, and LLLDR3XX__0000008 | Added to incorporate Stuff | YMB | 2010-11-17 00:00:00
Spreadsheet: 817279d1676089851-span-time-calculation-span-time-calculation
Sheet: Sheet1

Milestone | Start Date/Time | Man-Hours Span | Skip Days | Day Start | Day End | Hrs |  | Hours in Start Date | Hours Span > 17 | Sum | Hours [NAME] 17 in Days | Hours < 17 | Target End Date/Time | Combined Formula | Combined [NAME] using LET function | Assign names for LET function
Milestone 1 |  |  | 2023-03-03 00:00:00 | 06:00:00 | 23:00:00 | 17 |  |  |  |  |  |  |  |  |  | J2: a,MOD(A2,1)*24+MOD(B2,17)
Milestone 2 |  |  | 2023-03-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | K2: b,QUOTIENT(a,17)
Milestone 3 |  |  | 2023-03-15 00:00:00
Milestone 4 |  |  | 2023-04-15 00:00:00
Milestone 5 |  |  | 2023-05-01 00:00:00
 |  |  |  |  |  |  |  | Span Time Calculation
 |  |  |  |  | Total Hrs |  |  | https://www.excelforum.com/excel-formulas-and-functions/1399330-span-time-calculation.html#post5789915
 |  |  |  |  | Difference
 |  |  | For Milestone 1
 |  |  | Date | Start Time | End Time | Hrs
 |  | Start Date should not fall on Skip Days >