tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 139354d1328199898-conditional-concatenation-problem-for-badly-organised-data-conditional-joining
Sheet: Example 4 Excel Forum

 |  | SOURCE DATA |  |  |  | REQUIRED RESULT (manually generated)
0 | 0 | Review ID | Question |  |  | Review ID | Question | Answer
1 | 1 | REV001 | Question X | R1, QX, Line 1 | 1-3 | REV001 | Question X | R1, QX, Line 1 | R1, QX, Line 1 R1, QX, Line 2 R1, QX, Line 3
1 | 2 |  |  | R1, QX, Line 2 | 1-3 |  |  | R1, QX, Line 1 R1, QX, Line 2
1 | 3 |  |  | R1, QX, Line 3 | 1-3 |  |  | R1, QX, Line 1 R1, QX, Line 2 R1, QX, Line 3
2 | 1 | [NAME] | QuestionY | R2, QY, Line 1 | 2-4 | [NAME] | QuestionY | R2, QY, Line 1 | R2, QY, Line 1 R2, QY, Line 2 R2, QY, Line 3 R2, QY, Line 4
2 | 2 |  |  | R2, QY, Line 2 | 2-4 |  |  | R2, QY, Line 1 R2, QY, Line 2
2 | 3 |  |  | R2, QY, Line 3 | 2-4 |  |  | R2, QY, Line 1 R2, QY, Line 2 R2, QY, Line 3
2 | 4 |  |  | R2, QY, Line 4 | 2-4 |  |  | R2, QY, Line 1 R2, QY, Line 2 R2, QY, Line 3 R2, QY, Line 4
3 | 1 | [NAME] | Question X | R2, QX, Line 1 | 3-3 | [NAME] | Question X | R2, QX, Line 1 | 0
3 | 2 |  |  | R2, QX, Line 2
3 | 3
 |  | Number of answer lines could be 20 or more |  |  |  | Preference is without the blank lines, but these can be removed by filtering out the blank lines
 |  |  |  |  |  | I'd also settle for all the answer text on one line
Spreadsheet: 475833d1471473685-fil-an-excel-sheet-automatically-ef958_subsid_sheets_to_master
Sheet: Program 2

FULL Program | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | total 2016/2019 | VAR 2016/2019 | VAR 2015/2019 | CAGR 2016/2019
Program 2 - Projet AAA | 0 | 0 | 0.95 | 1.43 | 2.86 | 7.78 | 7.78 | 7.78 | 7.78 | 7.78 | 7.78
Program 2 - Projet CCC | 0 | 0 | 0 | 0.2 | 0.5
Program 2 - Projet DDD | 0 | 0 | 0 | 0.7 | 2
Program 2 - Projet EEE | 0 | 0 | 0 | 0 | 1
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 5.35 | 5.51 | 5.68 | 5.85 | 6.025 | 6.2
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 11.44
 | 0 | 0 | 0 | 0 | 0 | 1
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
Total New Products
Spreadsheet: 103788d1301493868-making-a-spreadsheet-user-friendly-data-entry-form
Sheet: Sheet1

Unique ID | Data 1 | Data 2 | Data 3 | Data 4 | Data 5
1 | Record 1 Data 1 | Record 1 Data 2 | Record 1 Data 3 | Record 1 Data 4 | Record 1 Data 5
2 | Record 2 Data 1 | Record 2 Data 2 | Record 2 Data 3 | Record 2 Data 4 | Record 2 Data 5
3 | Record 3 Data 1 | Record 3 Data 2 | Record 3 Data 3 | Record 3 Data 4 | Record 3 Data 5
4 | Record 4 Data 1 | Record 4 Data 2 | Record 4 Data 3 | Record 4 Data 4 | Record 4 Data 5
5 | Record 5 Data 1 | Record 5 Data 2 | Record 5 Data 3 | Record 5 Data 4 | Record 5 Data 5
Spreadsheet: 808255d1670368118-find-most-recent-date-with-a-positive-cumulative-sum-based-on-criteria-s666-pq-find-most-recent-date-with-a-positive-cumulative-sum-based-on-criteria
Sheet: Sheet1

Name | Date | Points fort that date | Is Date Eligible |  |  | Name | Points | [NAME]
[NAME] | 2022-09-20 00:00:00 | 1 | Yes |  |  | [NAME] | 1 | 2022-09-27 00:00:00
[NAME] | 2022-09-21 00:00:00 | 1 | Yes |  |  | [NAME] | 3 | 2022-09-27 00:00:00
[NAME] | 2022-09-21 00:00:00 | 2 | Yes |  |  | Mark | 2 | 2022-09-27 00:00:00
Mark | 2022-09-21 00:00:00 | -1 | Yes |  |  | [NAME] | 2 | 2022-09-27 00:00:00
[NAME] | 2022-09-21 00:00:00 | 2 | No
[NAME] | 2022-09-21 00:00:00 | -1 | Yes
[NAME] | 2022-09-21 00:00:00 | 2 | Yes
Mark | 2022-09-21 00:00:00 | 1 | Yes
[NAME] | 2022-09-21 00:00:00 | -1 | Yes
[NAME] | 2022-09-27 00:00:00 | 1 | Yes
[NAME] | 2022-09-27 00:00:00 | -1 | Yes
Mark | 2022-09-27 00:00:00 | 2 | No
[NAME] | 2022-09-27 00:00:00 | 1 | No
[NAME] | 2022-09-27 00:00:00 | -1 | Yes
Spreadsheet: 720913d1614357865-project-gantt-with-partial-days-weekends-holidays-and-employee-vactions-taskganttworking
Sheet: Sheet1

State | Feature | [NAME] | Effort | Burn Up | Effort Left | Start | End |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I have MANUALLY colored the Rows to show what I would like to do dynamically
 | TEAM MEMBER NAME |  |  |  |  |  |  | 2021-02-25 00:00:00
In Progress | Parent 1 |  | 2.25 | 1.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Parent States are initially manually changed to "Commited" and then if Burn Up > 0 the State changes to "In Progress"
Work Complete |  | Child 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The State of this Row changes to complete when Effort Left = 0
In Progress |  | Child 2 | 0.75 | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The State of this Row is "In Progress" because the "Feature" Item above is "In Progress" and this Backlog Item has Burn Up > 0
Blocked |  | Child 3 | 0.5 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The State of this Row is manually changed to "Blocked" by a drop down in the "State" column.
Commited |  | Child 4 | 0.25 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The following three Rows are in a "Commited" State because they are the Children of a Parent "In Progress" but the Burn Up of these items are = 0
Commited |  | Child 5 | 0.25 | 0
Commited |  | Child 6 | 0.25 | 0
Approved | Parent 2 |  | 0.25 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | New Feature Items are intially automatically in the "Approved" state when entered into the sheet
Approved |  | Child 1 | 0.25 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | All Child items following the "Approved" Feature are also in the "Approved" state
Approved |  | Child 2 | 0.25 | 0
Approved |  | Child 3 | 0.25 | 0
Spreadsheet: 725438d1616676840-calculate-weighted-percentile-weightedpercentilesample
Sheet: Sheet1

Sample Data
Company | Plant | Production | Cost
A | AA | 150 | 1200 |  |  |  | Weighted avg. Cost | Percentile
A | AV | 2000 | 1515 |  |  | Company A |  | ?
A | AC | 1555 | 1745
B | BE | 851 | 1987
B | BY | 158 | 1212
C | CP | 546 | 1645
C | CI | 658 | 1845
C | CT | 1368 | 1864
D | DI | 987 | 1549
D | DL | 754 | 1843
Spreadsheet: darrell_schoolcraft__7477__imball0202
Sheet: Citizens-Griffith

 | Citizens-Griffith
 | POI 78069 - Citizens Griffith
Day | Measured | Scheduled
1 | -72039 | -57926
2 | -56841 | -58000
3 | -37738 | -45943
4 | -65947 | -57943
5 | -67788 | -64999
6 | -62250 | -64486
7 | -48009 | -54967
8
9
10 | -11316 | -6000
11 | -63764 | -51407
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | 23627.8
2002-02-11 00:00:00
CBS Volume
 |  |  | 14942
Spreadsheet: darrell_schoolcraft__7805__imbalsumm0108
Sheet: Conoco

 | Maljamar |  | Zia |  |  |  |  |  |  |  |  | Avg
Day | Measured | Scheduled | Measured | Scheduled |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
1 | 36395 | 35310 | 30665 | 30355
2 | 36109 | 35970 | 30760 | 30926 |  |  | 2001-03-01 00:00:00 |  |  |  | 4.98
3 | 34935 | 35968 | 31613 | 30922 |  |  | 2001-04-01 00:00:00 |  |  |  | 4.87
4 | 35129 | 38500 | 32705 | 33450 |  |  | 2001-05-01 00:00:00 |  |  |  | 3.82
5 | 36992 | 38491 | 29785 | 33441 |  |  | 2001-06-01 00:00:00 |  |  |  | 3.2
6 | 37536 | 31999 | 30106 | 29000 |  |  | 2001-07-01 00:00:00 |  |  |  | 2.77
7 | 30804 | 36000 | 34261 | 30950
8 | 28957 | 36000 | 32502 | 30950
9 | 33886 | 35956 | 29962 | 30912
10 | 33528 | 32935 | 31738 | 33878
11 | 33647 | 35767 | 29418 | 30749
12 | 33412 | 30764 | 30321 | 30269
13 | 33711 | 30302 | 29868 | 30731
14 | 34265 | 30374 | 30207 | 30804
15 | 34973 | 30417 | 27096 | 30847
16 | 33442 | 30517 | 31103 | 30950
17 | 33295 | 30517 | 28744 | 30950
18 | 37922 | 30402 | 30834 | 30834
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  | 612678.27 |  | 0
2001-08-18 00:00:00
CBS Volume
 |  |  | 95131
Spreadsheet: 89c978ca-b254-4747-baaa-8e43afea64d5
Sheet: Asset LSCPR Charges

Day Ahead Net Commitment Period Compensation Settlement Summary Report
SR_DANCPCSTLSUM_<customer id>_<settlement date>_<version>.CSV
<[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mi:ss> GMT
 | Day-ahead LSCPR Charges
Reliability Region | Total Asset Day Ahead LSCPR Credits per Reliability Region | Day Ahead Load Obligation per Reliability Region | Total Day Ahead Load Obligation per Reliability Region | Participant Day Ahead LSCPR Charge | External Sale Load Obligation MW (CETICZ or FCA Cleared Export) | Participant Daily NCPC Day Ahead Load Obligation | Total Daily NCPC Day Ahead Load Obligation
Number | $ | MWh | MWh | $ | MWh | MWh | MWh
Spreadsheet: michelle_lokay__26617__imbalsumm0102
Sheet: EOG

 | 500249 |  | 500260 |  | 500646 |  | 500598
 | Pronghorn |  | Pitchfork Ranch |  | Tristi Draw
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 33193 | 30049 | 10503 | 10000 | 23795 | 25000
2 | 33037 | 33666 | 10371 | 10000 | 24097 | 25000
3 | 32947 | 33000 | 10032 | 10000 | 24103 | 24718
4 | 32791 | 33000 | 10136 | 10000 | 23820 | 24718
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
2001-01-31 00:00:00 |  |  |  |  |  |  |  |  | -341460
2001-02-03 00:00:00
 |  |  | 516.78
 |  |  | 212.08
 |  |  | 58.33
 |  |  | 25
Spreadsheet: 1fe98130-b1a4-471d-85f9-88d59326acaf
Sheet: 10a

Product1 | Cleared2 | Uncleared | TOTAL
Cross-Currency Basis | 0 | 14553831 | 14553831
Cross-Currency Fixed-Fixed | 0 | 425899 | 425899
Cross-Currency Fixed-Float | 0 | 1285335 | 1285335
TOTAL | -
Spreadsheet: 847193d1698238683-how-to-add-the-content-of-cell-to-the-next-empty-cell-if-cell-contains-a-specifc-string-example-for-excel-forum
Sheet: Sheet1

Current dataset about 900 rows => | Up to 90 columns => |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Preferred result
 | [EN] CLAIMS 1. An end-effector for handling a substrate, comprising: XXX | 2. The end-effector of claim 1, [NAME] | 3. The end-effector of claim 1 or 2, [NAME] | 4. The end-effector of claim 3, [NAME] | 5. The end-effector of claims 3 or 4, [NAME] | 6. The end-effector of claims 3 to 5, [NAME] | 7. The end-effector of any of the previous claims, [NAME] | 8. The end-effector of any of the previous claims, [NAME] | 9. The end effector of any of the previous claims, [NAME] | 10. The end-effector of any of the previous claims, [NAME] | 11. The end-effector of claim 10, [NAME] | 12. The end-effector of claim 11, XXX | 13. The end-effector of one of the previous claims, the XXX | 14. An apparatus comprising the end-effector according to one of claims 1 to 13. | 15. A method of using an end-effector for handling a substrate, XXX | 16. The method of claim 15, [NAME] | 17. The method of claim 15 or 16, [NAME] | 18. The method of one of claims 15 to 17, [NAME] | 19. The method of one of claims 15 to 18, comprising XXX | 1 | End-effector | 14 | An apparatus | 15 | A method …
 | [EN] 1. A method for ordering and/or selection [NAME] | 2. A method as claimed in claim 1, [NAME] | 3. A method as claimed in claim 1 or 2, [NAME] | 4. A method as claimed in any preceding claim, [NAME] | 5. A method as claimed in any preceding claim, [NAME] | 6. A method as claimed in any preceding claim, [NAME] | 7. A method as claimed in any preceding claim, [NAME] | 8. A method as claimed in claim 7, [NAME] | 9. A method as claimed in any preceding claim, [NAME] | 10. A method as claimed in any preceding claim, [NAME] | 11. A method as claimed in any preceding claim, [NAME] | 12. A method as claimed in claim 11, [NAME] | 13. A method as claimed in any preceding claim, comprising XXX | 14. A method as claimed in any preceding claim, [NAME] | 15. An apparatus configured to XXX to perform the method of any of claims 1 to 14. |  |  |  |  | 1 | A method for ordering and/or selection | 15 | An apparatus
Spreadsheet: 97f13084-9a22-471c-b095-43be22932167
Sheet: Sheet1

Release: Financial Soundness Indicators | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=238
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-09-30 12:38 PM [NAME]
 | Real-Time | Period
Name: | Start | End
Financial Soundness Indicators | 2011-11-01 00:00:00 | Current
Link:
http://fsi.imf.org/ | 2011-11-01 00:00:00 | Current
Source:
International Monetary Fund | 2011-11-01 00:00:00 | Current
Notes:
The Financial Soundness Indicators (FSIs) were developed by the IMF, | 2011-11-01 00:00:00 | Current
together with the international community, with the aim of supporting
macroprudential analysis and assessing strengths and vulnerabilities
of financial systems.
The website, hosted by the Statistics Department of the IMF,
disseminates data and metadata on selected FSIs provided by
participating countries. For a description of the various FSIs, as
well as the consolidation basis, consolidation adjustments, and
(http://fsi.imf.org/misc/FSI%20Concepts%20and%20Definitions.pdf). The
Statistics Department will steadily increase the number of countries
reporting FSIs for dissemination on this site.
Reporting countries compile FSI data presented on this website by
using different methodologies, which may also vary for different
points in time for the same country. Users are advised to consult the
accompanying [NAME] (http://fsi.imf.org/CountryList.aspx) to conduct
more meaningful cross-country comparisons or to assess the evolution
of a given FSI for any of the countries. For a customized search of
the database please use the the query builder
(http://elibrary-data.imf.org/QueryBuilder.aspx?s=322&key=1445284&f=1&ts=1&ys=2002&ye=2011&ms=1&me=12&ds=1&de=31&did=323&id=195)
in IMF eLibrary Data.
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2011-11-01 00:00:00
2012-02-08 00:00:00
2012-03-01 00:00:00
2012-04-02 00:00:00
2012-05-01 00:00:00
2012-06-01 00:00:00
2012-06-29 00:00:00
2012-08-02 00:00:00
2012-10-01 00:00:00
2012-11-15 00:00:00
2012-12-03 00:00:00
2013-01-02 00:00:00
2013-02-01 00:00:00
2013-03-01 00:00:00
2013-04-01 00:00:00
2013-05-01 00:00:00
2013-06-03 00:00:00
2013-07-01 00:00:00
2013-08-01 00:00:00
2013-09-03 00:00:00
2013-10-01 00:00:00
2013-11-01 00:00:00
2013-12-02 00:00:00
2014-01-01 00:00:00
2014-02-03 00:00:00
2014-03-03 00:00:00
2014-04-01 00:00:00
2014-05-01 00:00:00
2014-06-02 00:00:00
2014-07-01 00:00:00
2014-08-01 00:00:00
2014-09-02 00:00:00
Spreadsheet: 695504d1600249456-optimise-use-of-different-pack-size-example
Sheet: Sheet1

 |  | Optimal mix of pack size
 | Dose | 100mg | 160mg
Drug A order 1 | 260 | 1 | 1
Drug A order 2 | 200 | 2 | 0
Drug A order 3 | 240 | 1 | 1
Drug A order 4 | 240 | 1 | 1
Drug A order 5 | 280 | 3 | 0
Drug A order 6 | 280 | 3 | 0
 | Total
Spreadsheet: 386413d1427784352-sumifs-two-criterias-from-different-columns-book100
Sheet: Monthly Summary

MONTH |  | Trade Debtors Summary |  |  |  |  | Revenue |  |  |  | Trade Debtors Summary - BUDGET
2014-10-01 00:00:00
Sector |  | 0 to 30 Days | 31 to 60 Days | 61 Days + | Total |  |  |  |  |  | Total | Description
[NAME]
TOLL
Tox Free
VIP Packaging
Toyota
Viva
Yates
[NAME]
Westcon
VIP Drum
Transpacific
TradeCom
GRAND TOTAL
Spreadsheet: 37150d1235084785-vlookup-data-and-return-results-on-multiple-entries-attended-list-mock
Sheet: Sheet1

 | Events Attended List |  | Colour Index | 1 | 2 | 3 and above
Acct | First Name | Attended To Date | Event Attended | Event Attended | Event Attended | Event Attended | Event Attended | Event Attended | Event Attended
123 | [NAME] | 3 | Event1 | Event4 | Event6
234 | [NAME] | 3 | Event2 | Event3 | Event8
456 | [NAME] | 2 | Event5 | Event7
Spreadsheet: 728917d1618802258-if-a-cell-contains-a-specific-word-return-pre-defined-string-for-that-word-help
Sheet: Sheet1

 |  |  |  |  | result
text | contains the word one | text | text | numbers |  |  |  |  |  |  |  | one | this is one
text | contains the word two | text | text | numbers |  |  |  |  |  |  |  | two | this is two
text | contains the word three | text | text | numbers |  |  |  |  |  |  |  | three | this is three
text | contains the word four | text | text | numbers |  |  |  |  |  |  |  | four | this is four
text | contains the word five | text | text | numbers |  |  |  |  |  |  |  | five | this is five
text | contains the word six | text | text | numbers |  |  |  |  |  |  |  | six | this is six
text | contains the word seven | text | text | numbers |  |  |  |  |  |  |  | seven | this is seven
 |  |  |  |  |  |  | IFERROR(1/(1/SUMPRODUCT(IF(ISNUMBER(SEARCH($M$2:$M$8,B2)),$N$2:$N$8,0))),""&"")
Spreadsheet: 716070d1612008221-tiered-payments-with-multiple-variables-sample-workbook
Sheet: Sheet2

 | C1.1.1 | 0 | 3
 | C2.1.1 | 3 | 6
 | [NAME] | 6 | 12
 | C4.1.1 | 12 | 24
 | C5.1.1 | 24 | 999999
 | C1.1.2 | 0 | 3
 | C2.1.2 | 3 | 6
 | C3.1.2 | 6 | 12
 | C4.1.2 | 12 | 24
 | C5.1.2 | 24 | 999999
 | C1.2.1 | 0 | 3
 | C2.2.1 | 3 | 6
 | C3.2.1 | 6 | 12
 | C4.2.1 | 12 | 24
 | C5.2.1 | 24 | 999999
 | C1.2.2 | 0 | 3
 | C2.2.2 | 3 | 6
 | C3.2.2 | 6 | 12
 | [NAME] | 12 | 24
 | C5.2.2 | 24 | 999999
Spreadsheet: d71d34da-ed9f-43a3-848f-d359203e4d29
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | 1. sz. [NAME] | Unnamed: 5
[NAME] Jogú [NAME]
bevételeinek 2007. [NAME]. [NAME]
 |  | [NAME] | Eredeti előriányzat | Módosított előirányzat | Teljesítés
 |  |  | előirányzat
I. | 1 | Állami hozzájárulás
 |  | - Normatív állami támogatás és normatív
 |  | alapon elosztott SZJA | 4355174 | 4418066 | 3519274
 |  | - Tűzoltóság támogatása | 458554 | 458554 | 373228
 |  | - Címzett és céltámogatás | 641563 | 786575 | 739491
 |  | - [NAME] előirányzat és [NAME]
 |  | támogatás | 2560 | 151305 | 273496
II. | 2 | [NAME] bevétel
 |  | [NAME] | 191542 | 191542 | 141603
 |  | [NAME]
III. | 3 | Átengedett bevételek
 |  | - SZJA helyben maradó része | 871545 | 871545 | 685035
IV. | 4 | Gépjárműadó | 420000 | 420000 | 415257
V. |  | Saját bevételek
 | 5 | [NAME] adók | 4608000 | 4608000 | 4127502
 |  | - iparűzési adó | 3640000 | 3640000 | 3189572
 |  | - építményadó | 790000 | 790000 | 774657
 |  | - idegenforgalmi adó | 15000 | 15000 | 14092
 |  | - kommunális adó | 132000 | 132000 | 126574
 |  | - egyéb | 31000 | 31000 | 22607
 | 6 | Illetékek | 500000 | 500000 | 344515
 | 7 | Átvett pénzeszközök | 254289 | 265975 | 162236
 | 8 | Telek-, ingatlanértékesítés | 650000 | 692877 | 43111
 | 9 | Egyéb saját bevétel
 |  | - közterület hasznosítás | 19785 | 19785 | 23700
 |  | - nem lakás c. helyiségek bérleti díja | 64680 | 64680 | 49829
 |  | - osztalék, bérlet, stb. | 20000 | 20000 | 20000
 |  | - szakfeladatok bevételei | 350000 | 351000 | 292613
 |  | - egyéb saját bevétel | 25000 | 25000 | 4390
 |  | - lakbér bevétel | 36500 | 36500 | 18452
 | 10 | ÁFA befizetés és visszaigénylés | 142494 | 147806 | 49011
 | 11 | Pénzmaradvány
 |  | - Kisebbségi Önkormányzat |  | 1783 | 927
 |  | - intézményi | 376825 | 390752 | 386126
 |  | - Polgármesteri Hivatal |  | 193225 | 193225
 | 12 | Intézményi bevételek | 761403 | 842466 | 783193
 | 13 | Veszprém és Térsége Szennyvízelvezetési
 |  | és Kezelési [NAME] | 4530245 | 4545209 | 1120015
 |  | bevétel | 4530245 | 4480354 | 1039374
 |  | pénzmaradvány |  | 14964 | 14964
 |  | [NAME] állami támogatás |  | 49891 | 65677
 | 14 | Észak-Balatoni Térség Regionális Települési
 |  | [NAME] | 326083 | 326083 | 91288
 |  | bevétel | 326083 | 239679 | 47948
 |  | pénzmaradvány |  | 86404 | 43340
 |  | [NAME]: | 19606242 | 20328728 | 13857517
VI. |  | Lakásalap | 35631 | 245535 | 268420
 |  | bevétel | 35631 | 148018 | 266172
 |  | pénzmaradvány |  | 97517 | 2248
 |  | [NAME]: | 19641873 | 20574263 | 14125937
 |  | Hitelfelvétel
 |  | - munkabérhitel |  |  | 692070
 |  | - rövid lejáratú [NAME] | 1200000 | 1200000 | 0
 |  | - beruházási hitel | 1000000 | 1000000 | 0
 |  | - előző évi hitelszerződésen alapuló |  | 582644 | 558240
 |  | Bevétel összesen: | 21841873 | 23356907 | 15376247
 |  | [NAME], függő, átfutó bevételek
 |  | - Polgármesteri Hivatal |  |  | -338485
 |  | - Intézmények |  |  | -499170
 |  | [NAME]: | 21841873 | 23356907 | 14538592
Spreadsheet: lisa_gang__22238__ENA_PGE_MARCH_27_2002
Sheet: SYS-JD OR GRIZZ BR

From: | EPMI
To: | PGE System Transactions
Date: | 2002-03-27 00:00:00
HE
ENDING |  |  |  |  | SINK | SINK | SINK | SINK | SINK
Pacific Prevailing
Time | SYS/SYS OUT AT GRIZZLY | SYS | PGE LOSSES | PGE LOSSES | EPMI COB S/N | PGE LOSSES | TO GRIZZLY | TO SYS | TO [NAME] | BUY/RESALE
(PPT) |  |  |  |  | LOSS RETURN |  |  |  |  | [NAME]
0100 |  |  | 2 |  |  | -2
0200 |  |  | 2 |  |  | -2
0300 |  |  | 2 |  |  | -2
0400 |  |  | 2 |  |  | -2
0500 |  |  | 2 |  |  | -2
0600 |  |  | 2 |  |  | -2
0700 |  |  |  | 2 |  | -2
0800 |  |  |  | 2 |  | -2
0900 |  |  |  | 2 |  | -2
1000 |  |  |  | 2 |  | -2
1100 |  |  |  | 2 |  | -2
1200 |  |  |  | 2 |  | -2
1300 |  |  |  | 2 |  | -2
1400 |  |  |  | 2 |  | -2
1500 |  |  |  | 2 |  | -2
1600 |  |  |  | 2 |  | -2
1700 |  |  |  | 2 |  | -2
1800 |  |  |  | 2 |  | -2
1900 |  |  |  | 2 |  | -2
2000 |  |  |  | 2 |  | -2
2100 |  |  |  | 2 |  | -2
2200 |  |  |  | 2 |  | -2
2300 |  |  | 2 |  |  | -2
2400 |  |  | 2 |  |  | -2
 |  |  | BPA(G) | AVISTA(G) CHELAN |  |  |  |  |  | SHOULD BE ZERO
 |  |  | AVISTA(PSE) | EPMI(PSE) | EPMI COB S/N | PGE LOSSES | TO COB' | TO COB' | TO COB'
 |  |  | EPMI(PSE) | SNPD(T) MIDC/PGE SYS | LOSS RETURN |  | SEE COB SHEET | SEE COB SHEET | SEE COB SHEET
 |  |  | SNPD(T) BPAP/PGE SYS | EPMI(PSE)
 |  |  | EPMI(PSE) | PGE@SYS   LOSSES
 | PGE(L,R)SYS/SYS OUT AT GRIZZLY | PGE(L,R)SYS   SYSTEM SALE | PGE@SYS   LOSSES
 |  | NOT A BUY/RESALE
Spreadsheet: 136541d1326716591-named-ranges-and-functions-problem-teo150112
Sheet: Sheet1

NAME | AGE | ID | [NAME] | CHILDREN
a | 45 | a1 | 15000 | 5
b | 48 | b1 | 15000 | 2
c | 52 | n1 | 15000 | 2
d | 30 | g1 | 10000 | 2
f | 25 | r1 | 15000 | 1
g | 15 | e1 | 12000 | 0
 |  | Result
 |  | 2
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 4 March 2012

Daily Morning Staff |  |  |  |  | Sunday
 | 07:30-14:30 |  | 2012-03-04 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Ralation Supervisor | 07:30:00 | 14:30:00 | EFS
Sheikha [NAME] | 2120 | Reservation Officer | 07:30:00 | 14:30:00 | TOPS
Syed Sultan | 2888 | Supervisor | 07:30:00 | 14:30:00 | EFS
[NAME] | 4143 | Aircraft Team Leader | 07:30:00 | 14:30:00 | EFS
Jalil Nushadi | 1889 | Driver | 05:45:00 | 14:30:00 | EFS
[NAME] | 624 | Driver | 07:30:00 | 14:30:00 | EFS
Soud Sharar | 2097 | [NAME] Officer | 07:30:00 | 14:30:00 | [NAME]
[NAME] | 1897 | Manager | 07:30:00 | 14:30:00 | EFS | Sick leave
[NAME] | 4440 | Attendant | 07:30:00 | 14:30:00 | EFS
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS
Spreadsheet: 4c6d7e3a-2596-4859-b1fc-bfb21bdbf0be
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Oppføringer fra [NAME]
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
[NAME] |  | 9147 | [NAME]
Stenvoll Transport AS Konkursbo | Einebakkvegen 36 | 9147 | [NAME]
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/