tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: ad0bb91a-399e-40fa-82d3-35843d85a84a
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5056 | 19415 | [NAME] | [NAME] | BRA | 1 | 00:20:04 | 00:00:00 | 01:02:35 | 00:00:00 | 00:37:40 | 1 | 02:00:21
5056 | 35021 | Zach | Britton | USA | 4 | 00:20:07 | 00:00:00 | 01:07:17 | 00:00:00 | 00:38:32 | 2 | 02:05:59
5056 | 31413 | Swaleh | Balala | [NAME] | 5 | 00:26:53 | 00:00:00 | [NAME] | 00:00:00 | 00:43:10 | 3 | [NAME]
5056 | 35018 | Reginald | Lusala | [NAME] | 3 | [NAME] | 00:00:00 | 01:22:41 | 00:00:00 | [NAME] | 4 | 02:54:17
5056 | 35017 | Abdulkadir | Jabanain | [NAME] | 2 | 00:27:05 | 00:00:00 | 01:31:00 | 00:00:00 | 00:57:28 | 5 | 02:55:34
5056 | 35019 | Alexandra | Sio | [NAME] | 0 | 00:31:59 | 00:00:00 | 01:36:52 | 00:00:00 | 01:32:25 | 6 | 03:41:18
Spreadsheet: 68879d1269426123-excel-2007-multiple-conditionals-risk-and-issue-register-example
Sheet: Issue Log

Issues - 24/03/2010
Impact Area Key |  |  |  | [NAME]
ALL - All BTD Sections BS - Business Services PSO - Payment Systems Oversight A&F - Admin & Financial A&S - Architecture & Security SD - Systems Development QA - Quality Assurance IS - Infrastructure Services |  |  |  | High (H) - Critical Path issue. Non-resolution will effect target release dates.
 |  |  |  | Medium (M) - Non-resolution will cause slippage but not an immediate effect on target release dates.
 |  |  |  | Low (L) - Non-resolution will cause slippage/effect quality but will not impact delivery dates.
Log No | [NAME] | Description | Impact Area | Resolution Strategy |  |  | Impact | Owner | Date Identified | Target Resolution Date | Days Exceeded Target Resolution Date | Days Risk Has Been Active | Date Resolved | Status
1 |  | Delay to select a BTD Partner will impact the timeline to complete this project. There will be a series of critical planning as part of the Partner's solution delivery. | ALL | The current delay to conclude the Partner selection process is Jan 31st. This is being closely managed by Project Owner to ensure no slippage. 14th March - Official letter from P&M Dept. Building completion date will be "end of 2011". BTD will interpret this, for our RFP timelines, to be 30th December 2011. The current planning allows for sufficient time for vendor selection process. |  |  | H | AF | 2009-12-15 00:00:00 | 2010-01-31 00:00:00 | 52 | 89 | 2010-03-14 00:00:00 | CLOSED
2 |  | Delay in meeting with Projects & Maintenance department will directly impact the decision making and tasks of the Project Ignite team. | ALL | There is a meeting that will hopefully happen next week which will mitigate future risks and address this issue. |  |  | H | AF | 2009-12-15 00:00:00 | 2010-01-18 00:00:00 | 65 | 89 | 2010-03-14 00:00:00 | CLOSED
3
Spreadsheet: 871102d1717533672-would-like-to-add-automatic-date-and-day-yearly-xda-sickness-file
Sheet: DECEMBER

 | DATE | DAY | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE
 |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours
 | DATE | DAY | STAFF NAME | PAY | TOIL
 |  |  | TOTALS
Spreadsheet: michelle_lokay__26740__imball0203
Sheet: KN_Westar

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract 8289 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
[NAME] | 12353 | WestarCarson | 500168 | Westar Ward |  | 10187-01 | 9089-01 | 10522
 | Measured | Scheduled | Measured | Scheduled |  |  | Del | recpt
1 |  |  | -29075 | -24972
2 |  |  | -26944 | -25347
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
index
2002-02-28 00:00:00 |  |  |  |  | 316512.05
2002-03-02 00:00:00
CBS Volume
 |  |  | -43147
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: Managemt

 | Management
 | 2002 Plan
 |  |  |  |  |  |  |  | Energy Operations
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % of | 2002 |  | Per HC | New HC | Adj Comp |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | Total Exp | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  | 282857.82
 | Analyst & Associate | 0 |  |  |  |  | 0
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  | 63556.90320000001
ENAEMPEX | Employee Expense |  |  |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  | 0
ENAOUTSV | Outside Services | 0 |  |  |  |  | 237686.4 | Total |  |  |  |  | 36500125
ENASUPP | Supplies Expense |  |  |  |  |  | 4661.2944
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 37500 |  |  |  | 1.25
ENARENT | Rent |  |  |  |  |  | 36973.44 | Admins | 52500
ENATECH | Technology |  |  | 145000 |  |  | 7922.88 | Staff | 56250
ENATRANS | Transportation |  |  |  |  |  |  | Associate | 75000
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Analysts | 60000
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Specialist | 65000
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Sr Specialist | 82500
 |  |  |  |  |  |  |  | Managers | 100000
 | Headcount |  |  | 114 |  |  | 4 | Directors | 145000
 |  |  |  |  |  |  |  | Sr Director | 175000
 | A&A Headcount |  |  | 4 |  |  | 0 | Vice President | 237500
 |  |  |  |  |  |  |  | [NAME] | 312500 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | Outside Legal |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses |  |  |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization
 |  |  |  |  |  |  | Based on information from ENW accounting.
Spreadsheet: 856656d1705860183-getting-number-out-of-a-row-excel-forum-help-2-
Sheet: Sheet3

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35
25 | 17 | 34 | 27 |  | 19 | 13 | 21 | 7.999999999999999 | 11 | 10 |  | 9.999999999999998 | 13 | 9 | 14 |  | 6 |  | 20 | 4 | 17 |  | 5 | 15 | 11 | 12 | 3 | 13 | 5 |  |  | 6 | 14 | 8.999999999999998
 | 17 | 34 | 27 | 45 | 19 | 13 | 21 | 7.999999999999999 | 11 | 10 | 41 | 9.999999999999998 | 13 | 9 | 14 | 31 | 6 | 43 | 20 | 4 | 17 | 31 | 5 | 15 | 11 | 12 | 3 | 13 | 5 | 30 | 36 | 6 | 14 | 8.999999999999998
I had to exclude the S (which is the N in english) from the formulas:
 | 17 | #[NAME]! | 27 | 45 | 19 | 13 | 21 | 7.999999999999999 | 11 | 10 | 41 | 9.999999999999998 | 13 | 9 | 14 | 31 | 6 | 43 | 20 | 4 | 17 | 31 | 5 | 15 | 11 | 12 | 3 | 13 | 5 | 30 | 36 | 6 | 14 | 8.999999999999998
Spreadsheet: 268432d1380635425-if-function-tied-to-dates-claims-made-yr-example
Sheet: Sheet2

 |  |  |  | inception | expiration | inception | expiration
 | key off of | should be | retro dt | 2014-01-01 00:00:00 | 2015-01-01 00:00:00 | 2014-01-01 00:00:00 | 2015-01-01 00:00:00 | match months?
prior to | 2014-06-30 00:00:00 | 1 | 2014-01-10 00:00:00
after | 2014-07-01 00:00:00 | 1 | 2014-07-20 00:00:00
prior to | 2013-06-30 00:00:00 | 2 | 2013-01-10 00:00:00
after | 2013-07-01 00:00:00 | 1 | 2013-07-20 00:00:00
prior to | 2012-06-30 00:00:00 | 3 | 2012-01-10 00:00:00
after | 2012-07-01 00:00:00 | 2 | 2012-07-20 00:00:00
prior to | 2011-06-30 00:00:00 | 4 | 2011-01-10 00:00:00
after | 2011-07-01 00:00:00 | 3 | 2011-07-20 00:00:00
prior to | 2010-06-30 00:00:00 | 5 | 2010-01-10 00:00:00
after | 2010-07-01 00:00:00 | 4 | 2010-07-20 00:00:00
prior to | 2009-06-30 00:00:00 | 5 | 2009-01-10 00:00:00
after | 2010-07-01 00:00:00 | 5 | 2009-07-20 00:00:00
prior to | 2014-06-30 00:00:00 | 1 | 2014-01-01 00:00:00
after | 2014-07-01 00:00:00 | 1 | 2014-07-01 00:00:00
prior to | 2013-06-30 00:00:00 | 2 | 2013-01-01 00:00:00
after | 2013-07-01 00:00:00 | 1 | 2013-07-01 00:00:00
prior to | 2012-06-30 00:00:00 | 3 | 2012-01-01 00:00:00
after | 2012-07-01 00:00:00 | 2 | 2012-07-01 00:00:00
prior to | 2011-06-30 00:00:00 | 4 | 2011-01-01 00:00:00
after | 2011-07-01 00:00:00 | 3 | 2011-07-01 00:00:00
prior to | 2010-06-30 00:00:00 | 5 | 2010-01-01 00:00:00
after | 2010-07-01 00:00:00 | 4 | 2010-07-01 00:00:00
prior to | 2009-06-30 00:00:00 | 5 | 2009-01-01 00:00:00
after | 2010-07-01 00:00:00 | 5 | 2009-07-01 00:00:00
prior to | 2014-06-30 00:00:00 | 1 | 2014-01-20 00:00:00
after | 2014-07-01 00:00:00 | 1 | 2014-07-25 00:00:00
prior to | 2013-06-30 00:00:00 | 2 | 2013-01-20 00:00:00
after | 2013-07-01 00:00:00 | 1 | 2013-07-25 00:00:00
prior to | 2012-06-30 00:00:00 | 3 | 2012-01-20 00:00:00
after | 2012-07-01 00:00:00 | 2 | 2012-07-25 00:00:00
prior to | 2011-06-30 00:00:00 | 4 | 2011-01-20 00:00:00
after | 2011-07-01 00:00:00 | 3 | 2011-07-25 00:00:00
prior to | 2010-06-30 00:00:00 | 5 | 2010-01-20 00:00:00
after | 2010-07-01 00:00:00 | 4 | 2010-07-25 00:00:00
prior to | 2009-06-30 00:00:00 | 5 | 2009-01-20 00:00:00
after | 2010-07-01 00:00:00 | 5 | 2009-07-25 00:00:00
prior to | 2014-06-30 00:00:00 | 1 | 2014-02-28 00:00:00
after | 2014-07-01 00:00:00 | 1 | 2014-11-01 00:00:00
prior to | 2013-06-30 00:00:00 | 2 | 2013-01-27 00:00:00
after | 2013-07-01 00:00:00 | 1 | 2013-07-31 00:00:00
prior to | 2012-06-30 00:00:00 | 3 | 2012-01-31 00:00:00
after | 2012-07-01 00:00:00 | 2 | 2012-07-31 00:00:00
prior to | 2011-06-30 00:00:00 | 4 | 2011-01-31 00:00:00
after | 2011-07-01 00:00:00 | 3 | 2011-07-31 00:00:00
prior to | 2010-06-30 00:00:00 | 5 | 2010-01-31 00:00:00
after | 2010-07-01 00:00:00 | 4 | 2010-07-31 00:00:00
prior to | 2009-06-30 00:00:00 | 5 | 2009-01-31 00:00:00
after | 2010-07-01 00:00:00 | 5 | 2009-07-31 00:00:00
Spreadsheet: 821565d1678796217-additional-criteria-to-a-maxifs-formula-last-checked-example-workbook
Sheet: Last checked

 |  | Check 1 | Check 2 | Check 3 | Check 4
 | Name | Check 1 - latest completed | Check 2 - latest completed | Check 3 - latest completed | Check 4 - latest completed
 | [NAME]
 | [NAME]
 | [NAME]
Spreadsheet: 739404d1625675787-sumifs-and-if-else-condition-sample_if
Sheet: Summary

 |  | Actual Months | 3
 |  |  |  |  |  |  | Forecast Starts
 |  | GL ACCT | GL Desc | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Total
 |  | 6000 | Benefits
 |  | 7000 | Labor
 |  | 8000 | Overhead
 |  | 9000 | Other
Spreadsheet: 187201d1350377747-totalling-after-filtering-sample-customer-spreadsheet
Sheet: Customers

 |  |  |  |  | Total Boxes
 |  |  |  |  | 4
Customer | Boxes ordered (£1.25 per box) | No delivery due to vacation this wk? (any character = 'yes') | Delivery due this week? (1,2,3,4 = weekly; 1,3 and 2,4 = fortnightly, etc. in 4-week cycle)
Customer 1 | 1.25 |  | 1,2,3,4
Customer 2 |  |  | 2,4
Customer 3 | 1.25 |  | 1,2,3,4
Customer 4 | 1.25 | 1 | 1,2,3,4
Customer 5 |  |  | 1,3
Customer 6 |  |  | 1,3
Customer 7 |  |  | 1
Customer 8 | 2.5 | 2 | 1,2,3,4
Customer 9 |  |  | 1,3
Customer 10 | 1.25 | 1 | 1,2,3,4
Customer 11 |  |  | 2,4
Customer 12 |  |  | 1,3
Customer 13 |  | 1 | 1,3
Customer 14 |  |  | 1,2,3,4
Customer 15 |  |  | 1,3
Customer 16 |  |  | 1,2,3,4
Customer 17 |  |  | 2,4
Customer 18 | 1.25 | 5 | 1,2,3,4
Customer 19 | 2.5 |  | 1,3
Customer 20 | 1.25 | 2 | 1,2,3,4
Spreadsheet: 45120d1243892119-creating-a-list-of-selected-items-from-an-order-sheet-sample
Sheet: Sheet1

UPC | PK | SIZE | ITEM | CASE PACK | Movement | Cost | Order
8265733412 | 270 | 3 LITER | DEER PARK 3 LTR | 1 | 50.95 | 1.25
8265763111 | 1 | 700 ML | DEER PARK SPORTS  CAP | 28 | 20.45 | 7.99 | 2
8265750406 | 1 | 16.9 OZ | DEER PARK SPRING WATER | 24 | 16.6 | 4.29
8265755561 | 1 | 16.9 OZ. | DEER PARK SPRING WATER | 32 | 144.3 | 5.39 | 1
8265750560 | 1 | GAL | DEER PARK SPRING WATER | 6 | 23.8 | 6.49
8265771002 | 1 | 700 ML | DEER PARK SPRING WATER | 24 | 70.1 | 7.49
8265750562 | 1 | 1.5LTR | DEER PARK SPRING WATER | 12 | 8.2 | 8.75 | 3
8265791439 | 1 | 1 LITER | DEER PARK WATER 1 LITER | 18 | 22.45 | 9.45
Spreadsheet: 136129d1326418088-only-copy-cell-contents-with-a-date-format-dummy-file
Sheet: Formula Sheet

Name |  | Company | Purpose | Start Date | End Date
Date | Payee | Type of Expense | Purpose | Individuals/Companies | Amount
I CERTIFY THAT THE ABOVE EXPENSES HAVE BEEN INCURRED BY ME ONLY ON BEHALF OF THE COMPANY AND HAVE NOT BEEN PREVIOUSLY PAID OR REIMBURSED BY THE COMPANY. |  |  |  | Balance Due Employee:
 |  |  |  | Balance Due Company:
Signature of Employee |  |  |  | Date
Approval by Immediate Supervisor |  |  |  | Date
Spreadsheet: 776420d1649732451-check-from-the-source-table-to-list-subjects-below-the-required-marks-by-name-412
Sheet: Sheet1

suject | math | language | Chemical | English | physics
Pass requirement >= | 90 | 90 | 60 | 80 | 70
Name1 | 60 | 100 | 70 | 70 | 55
[NAME] | 100 | 60 | 50 | 99 | 80
Name3 | 30 | 100 | 60 | 100 | 40
Name4 | 80 | 50 | 90 | 120 | 80
Name5 | 100 | 80 | 100 | 80 | 90
Name6 | 88 | 90 | 99 | 70 | 99
 |  |  |  | Samples are for reference only and have no meaning (E11:O22 does not exist and will be deleted later)
Summary of Failed Items
Name1 | math | 60 |  | [NAME] | math |  |  | Name3 | math | 30 |  | Name4 | math | 80
 | language |  |  |  | language | 60 |  |  | language |  |  |  | language | 50
 | Chemical |  |  |  | Chemical | 50 |  |  | Chemical |  |  |  | Chemical
 | English | 70 |  |  | English |  |  |  | English |  |  |  | English
 | physics | 55 |  |  | physics |  |  |  | physics | 40 |  |  | physics
 |  |  |  | Name5 | math |  |  | Name6 | math | 88
 |  |  |  |  | language | 80 |  |  | language
 |  |  |  |  | Chemical |  |  |  | Chemical
 |  |  |  |  | English |  |  |  | English | 70
 |  |  |  |  | physics |  |  |  | physics
Spreadsheet: 5ac4f523-7381-4b57-809e-3cf7660bbff5
Sheet: 1.7 Industrial disputes

1.7 Industrial disputes
Quarter | 2010–11 | 2011–12 | 2012–13 | 2013–14 | 2014–15
Working days lost – '000
September | 46.6 | 101.3 | 110 | 23 | 24.6
December | 27.2 | 54.3 | 25.7 | 36.1
March | 19.7 | 35.8 | 52.1 | 9.7
June | 66.2 | 101.7 | 19.8 | 20.2
Annual (a) | 159.8 | 293.1 | 207.6 | 88.9
Working days lost per '000 employees
September | 4.7 | 10.1 | 10.8 | 2.2 | 2.4
December | 2.7 | 5.3 | 2.5 | 3.5
March | 2 | 3.5 | 5 | 0.9
June | 6.5 | 9.9 | 1.9 | 1.9
 |  |  |  |  |  |  |  | Update
(a) 12 months ended June. |  |  |  |  |  |  |  | 2015-03-12 00:00:00
Source: ABS, Industrial disputes, Cat. no. 6321.0.55.001
Spreadsheet: 585579d1533831991-data-validation-for-multiple-conditions-reimbursements
Sheet: Reimbursement form

Expenses
Purchase
 | testing | 2018-06-01 00:00:00
Mileage
 | testing | 2018-06-01 00:00:00
Other
 | testing | 2018-06-01 00:00:00
Per Diem
 | testing | 2018-06-01 00:00:00
Spreadsheet: 49843d1249279570-sum-values-in-a-dynamic-range-contiguous-cells-in-a-table-example
Sheet: 5

Actuals
Account | ID# | Src | Date | Memo/Payee | Debit | Credit | Code | Job No. | Comments | Job comments
TOTALS |  |  |  |  | 107793 |  | TOTALS
 |  |  |  |  | 80 |  | 5
 |  |  |  |  | 8913 |  | 5
 |  |  |  |  | 899 |  | 5
 |  |  |  |  | 3536 |  | 5
 |  |  |  |  | 2749 |  | 5
 |  |  |  |  | 2950 |  | 5
 |  |  |  |  | 5862 |  | 5
 |  |  |  |  | 1699 |  | 5
 |  |  |  |  | 328 |  | 5
 |  |  |  |  | 8601 |  | 5
 |  |  |  |  | 8693 |  | 5
 |  |  |  |  | 3582 |  | 5
 |  |  |  |  | 2346 |  | 5
 |  |  |  |  | 2807 |  | 5
 |  |  |  |  | 2434 |  | 5
 |  |  |  |  | 690 |  | 5
 |  |  |  |  | 1286 |  | 5
 |  |  |  |  | 8588 |  | 5
 |  |  |  |  | 9819 |  | 5
 |  |  |  |  | 186 |  | 5
 |  |  |  |  | 6709 |  | 5
 |  |  |  |  | 8095 |  | 5
 |  |  |  |  | 646 |  | 5
 |  |  |  |  | 3527 |  | 5
 |  |  |  |  | 5860 |  | 5
 |  |  |  |  | 6908 |  | 5
Spreadsheet: 770434d1646065681-dependent-array-doesnt-drop-down-after-loading-hvb-eg
Sheet: Reporting

 |  | Brand | ET | Advisor | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Brand | Advisors
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ET | [NAME]
 | Client ID | Clients | Enqs | Quotes | Bookings | Booked Rev | Booked with Alt |  |  |  |  |  |  |  |  |  | RB | [NAME]
 | 3 | A | 2 | 2 | 2 | 42290 | 0 |  |  |  |  |  |  |  |  |  | RT | [NAME]
 | 4 | A | 1 | 1 | 1 | 1300 | 0 |  |  |  |  |  |  |  |  |  | SP
 | 5 | A | 2 | 2 | 2 | 64480 | 0 |  |  |  |  |  |  |  |  |  | UK
 | 6 | A | 2 | 2 | 2 | 38180 | 0 |  |  |  |  |  |  |  |  |  | PC
 | 7 | A | 1 | 1 | 1 | 4390 | 0
 | #N/A |  | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 474284d1470707070-copy-multiple-columns-to-another-workbook-master
Sheet: ParkFit Range

Product Code | Product Description
A3000S-S-X | ParkFit Aerobic Walker
A3036S-S-X | ParkFit Back Extension
A3001S-S-X | ParkFit Bench Press
A3041S-S-X | ParkFit Body Twist
[NAME] | ParkFit Butterfly Press
A3045S-S-X | [NAME]
A3042S-S-X | [NAME]
A3051S-S-X | ParkFit Hand Cycle (Standard)
A3053S-S-X | [NAME] (Standard+Wheelchair)
A3052S-S-X | ParkFit Hand Cycle (Wheelchair)
[NAME] | [NAME]
A3033S-S-X | Parkfit Handstand Wall
Spreadsheet: a907c153-4fc0-4cf1-be00-e8efee93038e
Sheet: Sheet1

Enclosure 1 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Reporting period: |  |  |  | 1 Jan 2011 |  | to | 30 Jun 2011
Quarterly Financial Report-TFI-POD
Tax Number (MB): |  | 0820431
Registration Number ([NAME]): |  | 040035070
Personal Identification Number (OIB): |  | [PHONE]
Issuer: |  | OT-OPTIMA TELEKOM d.d.
Postal Code and Location: |  | 10010 |  |  | BUZIN
Street and number: |  | BANI 75A
e-mail address: |  | [EMAIL]
Internet address: |  | www.optima.hr
Code and name for municipality/city |  | 133
Code and name for county |  | 21 |  |  |  |  | Number of employees | 375
 |  |  |  |  |  |  | (at the year's end)
Consolidated Report |  | YES |  |  |  | Business activity code: |  | 6110
Entities in consolidation (according to IFRS) |  |  |  | Registered seat: |  |  | Tax number (MB):
OPTIMA DIRECT d.o.o. |  |  |  | Buje |  |  | 03806014
[NAME]. |  |  |  | Koper, [NAME] |  |  | 02236133
Book-keeping firm
Contact person |  | [NAME]
 |  | (unosi se samo prezime i ime osobe za kontakt)
Telephone |  | 01/5492 027 |  |  |  | Telefaks: | 01/5492 019
e-mail address |  | [EMAIL]
Surname and name |  | MATIJA MARTIĆ, JADRANKA SURUČIĆ
 |  | (osoba ovlaštene za zastupanje)
 | Documents for publication
 | 1. [NAME] (balance sheet, profit and loss account, cash flow statement, change in capital statement
 | and notes
 | 2. Management report
 | 3. Statements for persons responsible for composing financial statements
 |  |  |  | M.P. |  | (signature of authorized person)
Spreadsheet: 35131d1232644065-conditional-summing-example-conditional-sums
Sheet: Sheet1

 |  |  |  |  | I am trying to sum values in column C, if:
 |  |  |  |  |  | Column A is unique
 |  |  | Min | [NAME] |  | Column B = Factor1  (or [NAME], or [NAME]…)
Org01 | factor1 | 25 | 25 | 25 |  | In most cases, the number in column C will be the same for the corresponding "Org" variable. However, there are cases where it differs.
Org01 | [NAME] | 25 |  |  |  | In these cases I would like to be able to take the min (or the [NAME]) number.
Org01 | [NAME] | 25
Org01 | [NAME] | 24 | 24 | 25 |  | so, sum for "factor1" would be the sum of those in yellow
Org01 | factor4 | 25 | 25 | 25 |  | the sum for "[NAME]" would be those in green (if I were to go with the [NAME]).
Org01 | factor5 | 25 | 25 | 25
Org01 | factor6 | 25 | 25 | 25 |  | this data may not be in any particular order.
Org02 | factor1 | 30 | 30 | 30
Org02 | [NAME] | 30 |  |  |  | the "Factor" variable may occur several times for various org's...
Org02 | [NAME] | 28 | 28 | 30 |  |  | Min | [NAME]
Org02 | factor4 | 30 | 30 | 30 |  | factor1 | 80 | 80
Org03 | factor1 | 25 | 25 | 25 |  | [NAME] | 77 | 80
Org03 | [NAME] | 25 | 25 | 25 |  | [NAME] | 25 | 25
Org03 | [NAME] | 25 |  |  |  | factor4 | 55 | 55
Org03 | [NAME] | 25 | 25 | 25 |  | factor5 | 50 | 50
Org03 | factor5 | 25 | 25 | 25 |  | factor6 | 50 | 50
Org03 | factor6 | 25 | 25 | 25 |  | factor7 | 25 | 25
Org03 | factor7 | 25 | 25 | 25 |  | factor8 | 25 | 25
Org03 | factor8 | 25 | 25 | 25
Spreadsheet: 794194d1661937996-cell-reference-automatic-row-based-on-other-cells-value-countif-ask-automatic-row
Sheet: Sheet1

 |  |  |  |  |  | SumProduct
 |  |  |  | Qty | LONDON | Automatic Row | Manual Row
London | Apple | 100
London | Grape | 200
London | Durian | 300
London | Apple | 100
London | Grape | 200
London | Grape | 200
London | Durian | 300
London | Apple | 100
London | Grape | 200
London | Grape | 200
Spreadsheet: 125914d1319380583-excel-2007-cell-data-mileage
Sheet: Sheet1

 |  |  | BUSINESS MILEAGE LOG
DATE | TIME |  | PURPOSE | START | FINISH | MILEAGE
2011-10-22 00:00:00 | 07:30:00 |  | service calls | 10000 | 10500 | 500
2011-10-23 00:00:00 | 07:00:00 |  | service calls | 10550 | 10600 | 50
 |  |  |  |  |  | 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
 |  |  | START MILEAGE | 10000
 |  |  | END MILEAGE | 0
 |  |  | TOTAL MILEAGE THIS PERIOD | 550
 |  |  | BUISNESS MILEAGE THIS PERIOD | 550
 |  |  | PRIVATE MILEAGE THIS PERIOD
Spreadsheet: 23f4eab8-5b1f-420d-be7b-e921892a506e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
Lighting Retrofit Bid Results
Bidder | Base Bid (PWC+VMB) | Alt. #1       (VH) | Alt. #2         (Exit Signs) | Unit Cost Socket | Warranty (years) | Weeks    to Start | DepositAmount | Addendums - Forms | References | Cut Sheets | Meets DCEO Specifications | Total of All Options
[NAME], Inc. | 17100 | 8250 | 3300 | 12 | 3 | 2 | 855 | Yes | Yes | No | No cuts sheets included | 28650
Eco Lighting Services | 16349.87 | 9076.85 | No Bid | 5 | 1 | 6 | 817.5 | Yes | Yes | No | No cuts sheets included | 25426.72
Nissi Group, Inc. | 17983 | 11133 | 5845 | 6 | 1 | 1 | 900 | Yes | Yes | Yes | Yes | 34961
J. Hamilton Electric Co. | 20552 | 9800 | 2600 | 15 | 1 | 1 | 1027.6 | Yes | Yes | Yes | Yes | 32952
Imperial Lighting Maint. | 15637.24 | 9647.18 | 2352.93 | 12.5 | 1/3/5 | 2 | 781.86 | Yes | Yes | Yes | Yes | 27637.35
RMR Electric Inc. | 25622 | 15430 | 5000 | 20 | 1 | 3-4 | 2302.6 | Yes | Yes | Yes | Yes | 46052
Spreadsheet: 14a6a830-835b-4a81-9440-3389ef828f66
Sheet: 22

 |  | Net Notional Outstanding
Product Type |  | Cleared** | Uncleared
Total Metals* | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Energy | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Agricultural | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Index | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Other*** | Exotic
 | Option
 | Spot/Forward
 | Swap
TOTAL |  | N/A**** | N/A
Estimated net notional amount outstanding, November 23 weekly snapshot, by product type and cleared status (millions of USD), all participant types, tenors, and currencies.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***Environment, Freight, Multi-Commodity Exotic
****N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].