tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 58578d1258818700-transfer-data-from-journal-to-ledger-example-for-ritch2
Sheet: journal

 |  |  | COMPANY NAME
[NAME] | DATE | NO. | البيــــــــــــــــــان | total |  | CARS |  | BUILDINGS |  | A/R |  | A/P |  | INVENTORY |  | CASH |  | BANK
 |  |  |  | Debit | credit | Debit | credit | Debit | credit | Debit | credit | Debit | credit | Debit | credit | Debit | credit | Debit | credit
 | 2008-01-01 00:00:00 | 1 |  |  |  |  | 240000 |  |  | 48000 |  |  | 110000 |  |  | 11000 |  |  | 30000
 | 2008-01-01 00:00:00 | 2
 | 2008-01-04 00:00:00 | 3
 | 2008-01-04 00:00:00 | 4
 | 2008-01-05 00:00:00 | 5
 | 2008-01-09 00:00:00 | 6
 | 2008-01-09 00:00:00 | 7
 | 2008-01-12 00:00:00 | 8
 | 2008-01-12 00:00:00 | 9
 | 2008-01-10 00:00:00 | 10
 | 2008-01-14 00:00:00 | 11
 | 2008-01-14 00:00:00 | 12
 | 2008-01-14 00:00:00 | 13
 | 2008-01-14 00:00:00 | 14
 | 2008-01-15 00:00:00 | 15
 | 2008-01-20 00:00:00 | 16
 | 2008-01-20 00:00:00 | 17
 | 2008-01-20 00:00:00 | 18
 | 2008-01-23 00:00:00 | 19
 | 2008-01-23 00:00:00 | 20
 | 2008-01-23 00:00:00 | 21
 | 2008-01-24 00:00:00 | 22
 | 2008-01-30 00:00:00 | 23
 | 2008-01-30 00:00:00 | 24
 | 2008-01-31 00:00:00 | 25
 | 2008-01-31 00:00:00 | 26
 | 2008-01-31 00:00:00 | 27
 | 2008-01-02 00:00:00 | 28
 | 2008-01-29 00:00:00 | 29
 | 2008-01-30 00:00:00 | 30
 | 2008-01-31 00:00:00 | 31
 | 2008-02-01 00:00:00 | 32
 | 2008-02-02 00:00:00 | 33
 | 2008-02-03 00:00:00 | 34
 | 2008-02-04 00:00:00 | 35
 | 2008-02-05 00:00:00 | 36
 | 2008-02-06 00:00:00 | 37
 | 2008-02-07 00:00:00 | 38
 | 2008-02-08 00:00:00 | 39
 | 2008-02-09 00:00:00 | 40
 | 2008-02-10 00:00:00 | 41
 | 2008-02-11 00:00:00 | 42
 | 2008-02-12 00:00:00 | 43
 | 2008-02-13 00:00:00 | 44
 | 2008-02-14 00:00:00 | 45
 | 2008-02-15 00:00:00 | 46
 | 2008-02-16 00:00:00 | 47
 | 2008-02-17 00:00:00 | 48
 | 2008-02-18 00:00:00 | 49
 | 2008-02-19 00:00:00 | 50
 | 2008-02-20 00:00:00 | 51
 | 2008-02-21 00:00:00 | 52
 | 2008-02-22 00:00:00 | 53
 | 2008-02-23 00:00:00 | 54
 | 2008-02-24 00:00:00 | 55
 | 2008-02-25 00:00:00 | 56
 | 2008-02-26 00:00:00 | 57
 | 2008-02-27 00:00:00 | 58
 | 2008-02-28 00:00:00 | 59
 | 2008-02-29 00:00:00 | 60
 | 2008-03-01 00:00:00 | 61
 | 2008-03-02 00:00:00 | 62
 | 2008-03-03 00:00:00 | 63
 | 2008-03-04 00:00:00 | 64
 | 2008-03-05 00:00:00 | 65
 | 2008-03-06 00:00:00 | 66
Spreadsheet: 648915d1573292529-largest-positive-and-smallest-negative-with-multi-conditions-larpos_smallneg
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Largest Positive / Smallest Negative |  |  | Size
 | 1 |  | 22 | 88 | -50 | -78.25 |  |  | 24 | 28 | 41.25 | -80 |  |  |  | 24 | 28 | 41.25 | 80 |  |  |  |  | 28
 | 1 |  | 22 | 88 | -50 | -78.25 |  |  | 99 | 28 | 41.25 | -80 |  |  |  | 24 | 28 | 41.25 | 80 |  |  |  |  | 24
 | 1 |  | 22 | 88 | -50 | -78.25 |  |  | -99 | 28 | 41.25 | -80 |  |  |  | 24 | 28 | 41.25 | 80 |  |  |  |  | 28
 | 1 |  | 22 | 88 | -50 | 88 |  |  | -99 | 28 | 41.25 | -80 |  |  |  | 24 | 28 | 41.25 | 80 |  |  |  |  | 80
 | 1 |  | 22 | 88 | -50 | 88 |  |  | 88 | 28 | 41.25 | -80 |  |  |  | 24 | 28 | 41.25 | 80 |  |  |  |  | 24
 | 1 |  | 88 | 88 | 88 | 88 |  |  | 28 | 28 | 41.25 | -80 |  |  |  | 24 | 28 | 41.25 | 80 |  |  |  |  | 80
 | 0 |  | 52.5 | 68.35 | -100 | 25 |  |  | -100 | 20 | 1 | 5 |  |  |  | 888 | 20 | 1 | 5 |  |  |  |  | 888
 | 1 |  | 0 | 0 | 1 | 5 |  |  | -1 | -1 | -1 | -1 |  |  |  | 1 | 5 | 7 | 0 |  |  |  |  | 0
 | 1 |  | -5 | -5 | -5 | -5 |  |  | -5 | -5 | -5 | -5 |  |  |  | 80 | 50 | 40
 | 1 |  | -5 | -5 | -5 | -5 |  |  | 444 | -5 | -5 | -5 |  |  |  | 777 | 32 | 48.65 |  |  |  |  |  | 777
 | 0 |  | 1 | 0 | -65 | -55 |  |  | 1 | 0 | -65 | 50 |  |  |  | 0 | 2 | 30 | 0 |  |  |  |  | 30
 | 0 |  | 1 | 0 | -65 | -55 |  |  | -85 | 0 | -65 | 50 |  |  |  | 333 | 2 | 30 | 0 |  |  |  |  | 333
 | 1 |  | 20 | 22 | -44 | 22 |  |  | 7 | 8 | 9 | 0 |  |  |  | 7 | 0 | 9 | 999 |  |  |  |  | 999
 | 1 |  | 2 |  | 0
 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0
 | 1 |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 111
Spreadsheet: 223326d1364164523-mix-up-cell-values-book1
Sheet: Sheet1

 | 1 | 15 | 25
 | 2 | 16 | 26
 | 3 | 17 | 27
 | 4 | 18 | 28
 | 5 | 19 | 29
 | 6 | 20 | 30
 | 7 | 21 | 31
 | 8 | 22 | 32
 | 9 | 23 | 33
 | 10 | 24 | 34
Spreadsheet: 22765d1211930104-using-sumproduct-to-find-average-a
Sheet: 1638

Identifier | Type | Start date | End date | Timeliness
[NAME] | J | 2008-05-26 00:00:00 | 2008-05-23 00:00:00 | -3
Venlafaxine | ab | 2008-05-21 00:00:00 | 2008-05-25 00:00:00 | 4
Three-step therapy | mr | 2008-05-16 00:00:00 | 2008-05-20 00:00:00 | 4
Metformin, insulin | mr | 2008-04-14 00:00:00 | 2008-05-01 00:00:00 | 17
Spreadsheet: dutch_quigley__9372__Notional Bid Spread-NYMEX
Sheet: Old

 | NOTIONAL BID SPREADS ONLY!!!!!
 | NYMEX ONLY
 | EFP NOT CONSIDERED
 | As of _Aug 20, 2001
 |  | Less than 10,000/day | 10,000 - 30,000/day | Greater than 30,000/day
 |  | MMBtu | MMBtu | MMBtu
 | Year 1 | -0.015 |  | Must get bid
 | Year 2 | -0.015 | -0.025 | Must get bid |  |  | BID SPREADS ARE YEAR ON YEAR
 | Year 3 | -0.02 | -0.03 | Must get bid |  |  | BID SPREADS ARE NOT CUMILATIVE
 | Year 4 | -0.02 | -0.035 | Must get bid
 | Year 5 | -0.03 |  | Must get bid
 | Year 6 | -0.03 | -0.045 | Must get bid
 | Year 7 | -0.035 |  | Must get bid
 | Year 8 | -0.04 |  | Must get bid
 | Year 9 | -0.05 |  | Must get bid
 | Year 10 | -0.05 |  | Must get bid
 | DO NOT TRANSACT ON THESE NUMBERS!!!!!
 | Prepared by: [NAME]
Spreadsheet: 588585d1535703715-summing-data-with-multiple-criteria-2-col-and-1-row-sample
Sheet: Sheet1

Data |  |  |  |  |  |  |  |  |  |  |  | Result:
Code | COH | COH | COH | COH | CIB | CIB | AR | AR | CA | CA |  | Code | COH | COH | CIB | CIB
 | dr | cr | dr | cr | dr | cr | dr | cr | dr | cr |  |  | dr | cr | dr | cr
a | 1 | 1 | 5 | 0 | 1 | 1 | 1 | 1 | 1 | 1 |  | a
a | 1 | 1 | 123 | 0 | 1 | 1 | 1 | 1 | 1 | 1 |  | b
a | 1 | 1 | 1 | 0 | 5 | 6 | 1 | 1 | 5 | 4 |  | c
b | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 5 | 1 | 1
b | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
b | 1 | 1 | 1 | 6 | 6 | 1 | 1 | 1 | 3 | 5
c | 1 | 1 | 1 | 1 | 1 | 1 | 6 | 6 | 1 | 1
c | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 888728d1739299077-sum-lookups-across-multiple-tabs-using-dynamic-formulas-demand-planning
Sheet: Demand

 | Master Demand Plan |  |  |  | Current Month |  | 2024-02-01 00:00:00
 |  | Month | Month +1 | Month +2 | Month +3 | Month +4 | Month +5 | Month +6 | Month +7 | Month +8 | Month +9 | Month +10 | Month +11 | Month +12 | Month +13 | Month +14 | Month +15 | Month +16 | Month +17 | Month +18
 | Component 1
 | Component 2
 | Component 3
 | Component 4
 | Component 5
Spreadsheet: 04b53018-f697-4786-b89a-063c18c0134d
Sheet: InterpretingMeans

 |  |  |  | Interpreting the Mean Comparisons Report
Sample |  |  |  |  |  |  |  | Statistical Significance
The Mean Comparisons report is based on information from all randomly selected or census-administered students for both your institution and your comparison institutions. Targeted and locally administered oversamples and other non-randomly selected students are not included. |  |  |  |  |  |  |  | Items with mean differences that are larger than would be expected by chance alone are noted with one, two, or three asterisks, referring to three significance levels (p<.05, p< .01, and p<.001). The smaller the significance level, the smaller the likelihood that the difference is due to chance. Statistical significance does not guarantee the result is substantive or important. Large sample sizes (like those produced by NSSE) tend to generate more statistically significant results even though the magnitude of mean differences may be inconsequential. Consult effect sizes (see below) to judge the practical meaning of the results.
Variables
The items from the NSSE survey appear in the left column in the same order and wording as they appear on the instrument. The name of each variable appears in the second column for easy reference to your data file and the summary statistics at the end of this section. Response options are also provided to help you interpret the statistics.
Benchmark
Items that make up the five “Benchmarks of Effective  Educational Practice” are indicated by the following:
 |  |  |  |  |  |  |  |  |  |  |  | Effect [NAME]
LAC=Level of Academic Challenge |  |  |  |  |  |  |  |  |  |  |  | Effect size indicates the “practical significance” of the mean difference. It is calculated by dividing the mean difference by the pooled standard deviation. In practice, an effect size of .2 is often considered small, .5 moderate, and .8 large. A positive sign indicates that your institution's mean was greater, thus showing an affirmative result for your institution. A negative sign indicates the institution lags behind the comparison group, suggesting that the student behavior or
ACL=Active and Collaborative Learning
SFI=Student-Faculty Interaction
EEE=Enriching Educational Experiences
SCE=Supportive Campus Environment
Mean
The mean is the weighted arithmetic average of student responses on a particular item. Means are provided for your institution and all comparison groups. Additional details
regarding weighting can be found on the NSSE Web site. nsse.iub.edu/links/institutional_reporting |  |  |  |  |  |  | institutional practice represented by the item may warrant attention.  An exception to this interpretation is the “coming to class unprepared” item (item 1f.) where a negative sign is preferred (i.e., meaning fewer students reporting coming to class unprepared).
Class
Results are reported separately for first-year students (FY) and seniors (SR). Institution-reported class ranks are used.
Spreadsheet: 262606d1378217930-open-file-dynamically-and-copy-data-using-advanced-filter-raw
Sheet: Raw

Owners | Projects | Date | End date | Price | Priority
[NAME] | Prj1 | 2013-12-04 00:00:00 | 2014-12-05 00:00:00 | 12000 | low
[NAME] | Prj1 | 2014-12-05 00:00:00 | 2015-12-02 00:00:00 | 5000 | High
[NAME] | Prj1 | 2013-10-05 00:00:00 | 2014-10-05 00:00:00 | 5000 | High
[NAME] | Prj1 | 2013-10-05 00:00:00 | 2014-10-05 00:00:00 | 5000 | High
[NAME] | Prj1 | 2013-10-05 00:00:00 | 2014-10-05 00:00:00 | 5000 | High
[NAME] | Prj2 | 2014-10-05 00:00:00 | 2015-10-05 00:00:00 | 12000 | High
[NAME] | Prj3 | 2016-10-05 00:00:00 | 2017-10-05 00:00:00 | 18000 | High
[NAME] | Prj1 | 2013-10-05 00:00:00 | 2014-10-05 00:00:00 | 5000 | High
Yuan | Prj2 | 2014-10-05 00:00:00 | 2015-10-05 00:00:00 | 12000 | High
[NAME] | Prj2 | 2014-10-05 00:00:00 | 2015-10-05 00:00:00 | 12000 | High
[NAME] | Prj1 | 2013-10-05 00:00:00 | 2014-10-05 00:00:00 | 5000 | High
[NAME] | Prj2 | 2014-10-05 00:00:00 | 2015-10-05 00:00:00 | 12000 | High
[NAME] | Prj1 | 2013-10-05 00:00:00 | 2014-10-05 00:00:00 | 6000 | Low
[NAME] | Prj3 | 2016-10-05 00:00:00 | 2017-10-05 00:00:00 | 18000 | High
[NAME] | Prj2 | 2014-10-05 00:00:00 | 2015-10-05 00:00:00 | 12000 | High
[NAME] | Prj1 | 2013-10-05 00:00:00 | 2014-10-05 00:00:00 | 5000 | High
[NAME] | Prj2 | 2014-10-05 00:00:00 | 2015-10-05 00:00:00 | 18000 | Low
[NAME] | Prj3 | 2016-10-05 00:00:00 | 2017-10-05 00:00:00 | 18000 | High
[NAME] | Prj3 | 2016-10-05 00:00:00 | 2017-10-05 00:00:00 | 12000 | Low
Spreadsheet: 292492d1390612905-conditional-drop-down-list-sample
Sheet: Sheet1

A | A1
B | A2
C | A3
D | A4
E | A5
F | A6 |  |  | If any A1:A7 is in E9 I want dropdown in F9to show values B1:B7 and if  any A9:A15 is in E9 I want dropdown in F9 to show values B9:B15
G | A7
AA | AA1
BB | AA2
CC | AA3
DD | AA4
EE | AA5
FF | AA6
GG | AA7
Spreadsheet: 525748d1498863989-split-cells-data-into-specific-columns-formula
Sheet: Sheet1

Original Content | Text Description | gr | [NAME]
SEMIQ. NAC. [NAME]mm | SEMIQ. NAC. | 150 | 740 | EXAMPLE
SEMIQ. NAC. 150gr 0960[NAME] | SEMIQ. NAC. | 150 | 960
SEMIQ. NAC. PLUS 170gr 0760[NAME] |  |  |  | I need formula in column B, C and column D, when I put the data in column A the data automtacally split into columns
SEMIQ. NAC. PLUS [NAME]
SEMIQ. NAC. PLUS 170gr 0960[NAME]
SEMIQ. NAC. PLUS 180gr 0680mm
SEMIQ. NAC. PLUS 180gr 0780[NAME]
SEMIQ. NAC. PLUS 190gr 0660[NAME]
SEMIQ. NAC. PLUS 190gr 0710mm
SEMIQ. NAC. PLUS 190gr 1000mm
FLUTING 095gr 0660[NAME]
FLUTING 095gr 0690[NAME]
FLUTING 095gr 0840[NAME]
SEMIQ. NAC. [NAME][NAME]
SEMIQ. NAC. [NAME][NAME]
SEMIQ. NAC. 120gr 0710[NAME]
SEMIQ. NAC. [NAME][NAME]
TL1 KRAFT REC. 170gr 0600mm
TL1 KRAFT REC. [NAME] 0620[NAME]
TL1 KRAFT REC. [NAME]
TL1 KRAFT REC. [NAME][NAME]
TL1 KRAFT REC. 170gr 0680mm
TL1 KRAFT REC. 170gr 0700mm
TL1 KRAFT REC. [NAME] 0760[NAME]
TL1 KRAFT REC. [NAME] 1120mm
TL1 KRAFT REC. [NAME] 1170[NAME]
TL2 120gr 0720[NAME]
TL2 [NAME][NAME]
TL2 120gr 1050[NAME]
TL2 [NAME] 1050[NAME]
TL2 140gr 1180[NAME]
TL2 160gr 0660[NAME]
TL2 160gr 0810[NAME]
TL2 160gr 0830mm
TL2 160gr 0900mm
TL2 160gr 1120mm
TL2 170gr 0710[NAME]
TL2 [NAME][NAME]
TL2 170gr 1120[NAME]
SEMIQ. NAC. [NAME][NAME]
SEMIQ. NAC. [NAME][NAME]
SEMIQ. NAC. [NAME]mm
SEMIQ. NAC. [NAME] 1040[NAME]
SEMIQ. NAC. 120gr 1070[NAME]
TL1 KRAFT REC. [NAME] 1070mm
TL1 KRAFT REC. 195gr 0740[NAME]
TL1 KRAFT REC. 195gr 0760[NAME]
TL1 KRAFT REC. 195gr 1170[NAME]
TL2 160gr 1040[NAME]
TL2 170gr 0840[NAME]
SEMIQ. NAC. PLUS 180gr 1330[NAME]
Any text 190gr More text 1330mm
Spreadsheet: 754604d1636373420-how-to-type-a-word-and-fill-some-cells-with-numeric-values-associated-fill-text-aligw
Sheet: Plan1

F | A | K | E |  | 1° STEP |  |  |  |  |  | LETTERS | VALUE | COUNT
 |  |  |  |  |  |  |  |  |  |  | F | 1
 |  |  |  |  |  |  |  |  |  |  | A | 2
 |  |  |  |  |  |  |  |  |  |  | K | 3
 |  |  |  |  |  |  |  |  |  |  | E | 4
 |  |  |  |  | 2° STEP
2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034
Spreadsheet: 825950d1681675877-help-ranking-data-with-same-values-ranking-test1
Sheet: Sheet1

 | PP# | Rating | Rank |  | Rating | Rank | Quartile |  | [NAME] |  |  | Top Half |  | Top Rank
 | 1 | 67 |  |  |  |  |  |  |  | 1
 | 2 | 22 |  |  | 67 | 2 |  |  | 2nd Qrt
 | 3 | 68 |  |  | 67 | 2 |  |  |  | 2
 | 0 | 0 |  |  | 66 | 4 |  |  | 3rd Qrtile
 | 5 | 41 |  |  | 66 | 4 |  |  |  | 3
 | 6 | 47 |  |  | 47 | 6 |  |  | Bottom
 | 7 | 66 |  |  | 41 | 7 |  |  |  | 4
 | 8 | 28 |  |  | 39 | 8
 | 9 | 66 |  |  | 30 | 9
 | 10 | 30 |  |  | 28 | 10
 | 11 | 67 |  |  | 22 | 11
 | 12 | 39
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
Spreadsheet: 83573d1283531914-count-if-multiple-criteria-match-across-multiple-columns-ovc_forum-question_worksheet
Sheet: Sheet1

 |  | Name of Constituency where child lives |  |  |  |  | What is the child's OVC status?
 |  | Epukiro | Gobabis | Otjinene | Otjombinde | Name of Village where child lives | Single Orphan | Double Orphan | Vulnerable Child
 |  | True | False | False | False | Epukiro | True | False | False
 |  | False | True | False | False | [NAME] | False | True | False
 |  | True | False | False | False | Talismanus | False | True | False
 |  | False | False | True | False | Epukiro | False | False | True
 |  | False | False | False | True | Epukiro | True | False | False
 |  | True | False | False | False | Talismanus | False | False | True
Spreadsheet: 889875d1740862685-advanced-transpose-on-daily-shift-with-eleven-position-per-month-book1schedule
Sheet: DATA SOURCE

Date | Day | TH1 | TH2 | JB1 | JB2 | JGW | RIM | RI | IGM | IGD | ICU | RSD
1 | Saturday | dr. Prima | dr. [NAME] | dr. [NAME] | dr. Ajik | dr. Eirin | dr. Hudi | dr. Kinan | dr. Wita | dr. Aryo | dr. Dody | dr. Medi
 |  | dr. Cokro |  | dr. Anggi | dr. [NAME] | dr. Kresna | dr. [NAME] |  | dr. Windy
 |  |  |  |  |  | dr. Intan
2 | Sunday | dr. Satri | dr. Maja | dr. Cliff | dr. Sasa | dr. Gaby | dr. Ciwi | dr. Wicak | dr. Vania | dr. Relly | dr. [NAME] | dr. Reza
 |  | dr. Nathali |  | dr. Lidia | dr. Hans | dr. Ian | dr. [NAME] |  | dr. [NAME]
 |  |  |  |  |  | dr. Dika
3 | Monday | dr. [NAME] | dr. Tia | dr. Valen | dr. Rama | dr. [NAME] | dr. [NAME] | dr. Dody | dr. [NAME] | dr. Ronny | dr. Gede | dr. Nitha
 |  | dr. [NAME] | dr. Herna | dr. [NAME] | dr. [NAME] | dr. [NAME] | dr. [NAME] |  | dr. Karin
 |  |  |  |  |  | dr. [NAME] |  |  | dr. [NAME]
4 | Tuesday | dr. PWednesday | dr. [NAME] | dr. Anto | dr. Yerli | dr. [NAME] | dr. Zeska | dr. Aryo | dr. Akhta | dr. [NAME] | dr. Kinan | dr. Irwan
 |  | dr. [NAME] | dr. Cokro | dr. Tari | dr. Yusi | dr. Yohan | dr. [NAME] |  | dr. Rendi
 |  |  |  |  |  | dr. [NAME] |  |  | dr. [NAME]
5 | Wednesday | dr. Ella | dr. Maja | dr. Darto | dr. Nico | dr. [NAME] | dr. Hidayat | dr. [NAME] | dr. [NAME] | dr. [NAME] | dr. [NAME] | dr. Kurnia
 |  | dr. [NAME] | dr. Satri | dr. [NAME] | dr. Desi | dr. Febri | dr. [NAME] |  | dr. Yoga
 |  |  |  |  |  | dr. Indri |  |  | dr. Jery
6 | Thursday | dr. Radhit | dr. Nathali | dr. Lidia | dr. Adrian | dr. Alda | dr. [NAME] | dr. Rio | dr. Windy | dr. [NAME] | dr. Mila | dr. Reza
 |  | dr. [NAME] | dr. Ibtisam | dr. Kresna | dr. Fadel | dr. Fefe | dr. Bagus |  | dr. [NAME]
 |  |  |  |  |  | dr. [NAME] |  |  | dr. Wita
7 | Friday | dr. Laili | dr. Abi | dr. Gaby | dr. Farih | dr. [NAME] | dr. Amalia | dr. Tri | dr. Amanda | dr. Wicak | dr. Gede | dr. [NAME]
 |  | dr. Adhan | dr. Prima | dr. Cliff | dr. Intan | dr. Sasa | dr. [NAME] |  | dr. [NAME]
 |  |  |  |  |  | dr. Etri |  |  | dr. [NAME]
Spreadsheet: 704379d1605526342-trying-to-generate-monthly-employee-costs-with-lookup-functions-forum-post
Sheet: Allocation_Month

 |  |  | Department
 | [NAME] | Employee Name | Sep-20 | Oct-20 | Nov-20 | Dec-20
 | 1 | [NAME] | Dep-1 | Dep-2 | Dep-1 | Dep-2
 | 2 | Gone | Dep-2 | Dep-3 | Dep-2 | Dep-3
 | 3 | Come | Dep-3 | Dep-4 | Dep-3 | Dep-4
 | 4 | Bye | Dep-4 | Dep-1 | Dep-4 | Dep-1
 | 5 | Hello | Dep-1 | Dep-2 | Dep-1 | Dep-2
Spreadsheet: darrell_schoolcraft__7321__imball0202
Sheet: SoCal

 | 10487 |  | 56697
Day | Measured | Scheduled | Measured | Scheduled
1 | -612464 | -611587
2 | -602028 | -603119
3 | -605205 | -615801
4 | -600868 | -601843
5 | -593916 | -602338
6 | -575011 | -571740
7 | -669282 | -667521
8 | -671065 | -664800
9 | -571431 | -572711
10 | -571738 | -572576
11 | -563485 | -560934
12 | -581906 | -589362
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 |  |  |  |  | 94012
2002-02-12 00:00:00
CBS Dollars
 |  |  | 310268
Spreadsheet: 551287d1512825365-align-two-tables-by-row-based-on-common-column-copy-of-sample-alignment-jdaich-
Sheet: Sheet3

 | List Number 2
 | Account | January | feburary | march | april | may
 | 30001-702 | 0 | 0 | 0 | 0 | 0
 | 30001-703 | 0 | 0 | 0 | 0 | 0
 | 30001-705 | 0 | 0 | 0 | 0 | 0
 | 30001-708 | 0 | 0 | 0 | 0 | 0
 | 30001-709 | 0 | 0 | 0 | 0 | 0
 | 30001-712 | 0 | 0 | 0 | 0 | 0
 | 30002-702 | 0 | 0 | 0 | 0 | 0
 | 30002-703 | 0 | 0 | 0 | 0 | 0
 | 30002-705 | 0 | 0 | 0 | 0 | 0
 | 30002-708 | 0 | 0 | 0 | 0 | 0
 | 30002-709 | 0 | 0 | 0 | 0 | 0
 | 30002-710 | 0 | 0 | 0 | 0 | 0
 | 30002-712 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 789293d1659027631-formulas-required-total-based-on-multiple-criteria-excel-help-280722-1-
Sheet: Summary

 |  | No. of Sites | Monthly Price | No. of Sites | Monthly Price | No. of Sites | Monthly Price | No. of Sites | Monthly Price | No. of Sites | Monthly Price
 |  | HOS0000503 | HOS0000503 | PHA0000501 | PHA0000501 | PSC0000504 | PSC0000504 | PSC0001004 | PSC0001004 | BRO0000507 | BRO0000507
U_BillToID | [NAME]
HQ000001 | x |  |  |  |  |  |  |  |  |  |  | need formula here in yellow that looks at the raw data tab
HQ000002 | xx
HQ000006 | xxx
HQ000007 | xxxx
HQ000008 | xxxxx
HQ000009 | xxxxxx
HQ000010 | xxxxxxx
 | xxxxxxxx
Spreadsheet: 120959d1315676183-excel-2007-distinguish-between-text-and-numbers-then-move-text-number-worksheet-2-
Sheet: Existing Format

Property Name | Property Name
Amount | Amount
JACLIN CORP 25-1
4731
BELL 20-1
11994
DAVIS BROS 8-3 ALT
8051
LA MINERALS 7-8 ALT
3268
DAVIS BROS 32-1
8396
HODDE 22-5 ALT
5248
DAVIS BROS 20A-1
5825
SWIM 21-1 ALT
7299
DAVIS BROS 29-12 ALT
14454
STEWART HARRISON 20-2 ALT
7353
DAVIS BROS 26A-3 ALT
7363
DAVIS LUMBER 10-5 ALT
11291
T K GIDDENS ET AL 12-2 ALT
4596
DAVIS HEIRS 12-2 ALT
6553
[NAME] HARRISON 30-5 ALT
14674
[NAME] HARRISON 30-6 ALT
14738
PATTERSON ESTATE 5-ALT
4845
ARLISS BARR 12-2 ALT
4684
[NAME]
1545
EDWIN SOUR ET AL 7-3 ALT
1367
[NAME] HARRISON 30-7 ALT
20241
DAVIS BROS 17B-1 ALT
6756
DAVIS BROS 18A-1 ALT
6953
[NAME] 12-3 ALT
6055
[NAME] HARRISON 30-3 ALT
19109
DAVIS HEIRS 19-1 ALT
1531
DAVIS BROS J-12 ALT
1719
CAUSEY 14-2 ALT
2701
MCCONNELL ESTATE 15-2 ALT
5912
MCCONNELL ESTATE 14-3 ALT
8868
LA MINERALS 18-2 ALT
4740
LA MINERALS 18-3 ALT
7234
DAKIN 21-4 ALT
4409
DAVIS BROS 30-8 ALT
13017
OXFORD 3 ALT
5583
WEYERHAEUSER 11-2 ALT
6417
DAVIS BROS G-4 ALT
2159
T K GIDDENS ET AL 12-4 ALT
4726
DAVIS BROS 14C-1 ALT
5120
SIMONTON ETAL 12-2 ALT
5115
PATTERSON ESTATE 6-ALT
439
MCCONNELL ESTATE 14-4 ALT
8715
ARLISS BARR 18-2 ALT
6551
DAVIS BROS Q-8 ALT
6092
DAVIS BROS 8-2 ALT
4965
LA MINERALS 18A-2 ALT
4982
ANADARKO ET AL 20-1 ALT
7295
OXFORD 5 ALT
9801
DAVIS BROS 13-6 ALT
4995
DAVIS BROS 13-5 ALT
7802
LA MINERALS 7-5 ALT
9643
LA MINERALS 7-6 ALT
10493
DAVIS BROS 28-7 ALT
8882
DAVIS BROS 13-4 ALT
6908
DAVIS BROS 28-8 ALT
6284
LA MINERALS 7-7 ALT
8081
DAVIS BROS 17 C-1 ALT
2852
WILLAMETTE 1-2 ALT
5442
DAVIS LUMBER 11-4 ALT
9765
DAVIS BROS 19A-1 ALT
10628
EWING 19-1 ALT
1049
ARLISS BARR 12-3 ALT
2824
STEWART HARRISON 20-1 ALT
9596
STEWART HARRISON 34-2
358
Spreadsheet: 107c6c0c-4af8-4d53-8fa8-aa847df29798
Sheet: Sheet1

The NASDAQ OMX Group, Inc. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Condensed Consolidated Statements of Income
(in millions, except per share amounts)
(unaudited)
 |  | Three Months Ended
 |  | Mar. 31, |  | Dec. 31, |  | Mar. 31,
 |  | 2009 |  | 2008 |  | 2008
Revenues
Market Services revenues |  | 784 |  | 901 |  | 722
Cost of revenues:
Liquidity rebates |  | -455 |  | -528 |  | -385
Brokerage, clearance and exchange fees |  | -71 |  | -94 |  | -151
Total cost of revenues |  | -526 |  | -622 |  | -536
Total Market Services revenues less liquidity rebates,
brokerage, clearance and exchange fees |  | 258 |  | 279 |  | 186
Issuer Services revenues |  | 79 |  | 85 |  | 77
Market Technology revenues |  | 29 |  | 35 |  | 13
Other revenues |  | 3 |  | 4 |  | 2
Total revenues less liquidity rebates, brokerage,
clearance and exchange fees |  | 369 |  | 403 |  | 278
Operating Expenses
Compensation and benefits |  | 97 |  | 106 |  | 73
Marketing and advertising |  | 2 |  | 6 |  | 2
Depreciation and amortization |  | 24 |  | 27 |  | 16
Professional and contract services |  | 18 |  | 19 |  | 14
Computer operations and data communications |  | 15 |  | 13 |  | 8
Occupancy |  | 17 |  | 17 |  | 12
Regulatory |  | 9 |  | 7 |  | 8
Merger expenses |  | 8 |  | 10 |  | 1
General, administrative and other |  | 13 |  | 18 |  | 11
Total operating expenses |  | 203 |  | 223 |  | 145
Operating income |  | 166 |  | 180 |  | 133
Interest income |  | 5 |  | 7 |  | 10
Interest expense |  | -27 |  | -35 |  | -10
Dividend and investment income |  | 0 |  | 3 |  | 0
Income (loss) from unconsolidated investees, net |  | -2 |  | 0 |  | 27
Gain (loss) on foreign currency contracts |  | 0 |  | -47 |  | 35
Asset impairment charge |  | 0 |  | -35 |  | 0
Income before income taxes |  | 142 |  | 73 |  | 195
Income tax provision |  | 48 |  | 38 |  | 74
Net income |  | 94 |  | 35 |  | 121
Net (income) expense attributable to noncontrolling interests |  | 0 |  | 0 |  | 0
Net income attributable to NASDAQ OMX |  | 94 |  | 35 |  | 121
Basic and diluted earnings per share:
Basic |  | 0.47 |  | 0.17 |  | 0.75
Diluted |  | 0.44 |  | 0.17 |  | 0.69
Weighted-average common shares outstanding
for earnings per share:
Basic |  | 202 |  | 201 |  | 161
Diluted |  | 214 |  | 214 |  | 176