tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 16307b43-158e-4c6c-9225-ef88ccc11ac3
Sheet: Sheet1

Degree Level, Top 10 Places of Origin | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
for Denmark, 2010-2011
 | Top 10 Places of Origin (Name) | Total Number of International Students | Undergraduate Degree-seeking International Students | (Post-)Graduate Degree-seeking International Students
#1 | Norway | 1989 | 967 | 854
#2 | Germany | 1695 | 490 | 558
#3 | Sweden | 1344 | 522 | 645
#4 | China | 1289 | 619 | 469
#5 | Lithuania | 1039 | 703 | 261
#6 | Poland | 974 | 383 | 321
#7 | Romania | 915 | 594 | 291
#8 | Iceland | 915 | 444 | 408
#9 | France | 838 | 81 | 83
#10 | Bulgaria | 717 | 538 | 176
Total of All Places of Origin | Total | 28892 | 10186 | 9316
These figures only include students studying for a full-degree in Denmark & students who participate in exchange visits at the 8 Danish universities.
Source: Danish Agency for Universities and Internationalisation
Spreadsheet: 678858d1590086436-roc-cut-off-roc-5_20_202
Sheet: Data

Diagnosis | A | B
0 | 7.0677596118112 | 80
0 | 4.707621797253978 | 80
0 | 4.753915653540906 | 80
0 | 5.274548902323136 | 80
0 | 7.965159329726967 | 80
0 | 2.353370574360133 | 80
0 | 4.824582125916008 | 80
0 | 3.210896287313043 | 80
0 | 3.282057055769274 | 80
0 | 5.654084257590199 | 80
0 | 9.446623681794891 | 80
0 | 1.903390526001952 | 80
0 | 3.630869468751314 | 80
0 | 5.04871637464125 | 80
0 | 32.9609122051094 | 80
0 | 5.695400345305649 | 80
0 | 3.0295015522612 | 80
0 | 3.457373943943927 | 80
0 | 4.749299916751074 | 80
0 | 6.948400753791415 | 80
0 | 6.560962804079791 | 160
0 | 6.641500824076207 | 160
0 | 9.418527620326023 | 160
0 | 14.00353752850472 | 160
0 | 6.296709226525181 | 160
0 | 13.24488822229327 | 160
0 | 13.18920750938614 | 160
0 | 10.54524952556151 | 160
0 | 7.674699539712719 | 160
0 | 6.248848331421897 | 160
0 | 6.00993136397223 | 160
0 | 6.314659656529354 | 160
0 | 4.418829972806552 | 160
0 | 13.61103713253297 | 160
0 | 10.23949692073534 | 160
0 | 9.860560120175094 | 160
0 | 6.916373817280348 | 160
0 | 8.849861331482074 | 160
0 | 5.805505173306285 | 160
0 | 11.84318591858851 | 160
1 | 25.62802774965135 | 320
1 | 30.71978628888652 | 320
1 | 15.23719376854521 | 320
1 | 15.55110649815769 | 320
1 | 10.87388023571894 | 320
1 | 10.57143870967842 | 320
1 | 22.83645116671005 | 320
1 | 13.71602826466955 | 320
1 | 9.544302076776152 | 320
1 | 20.45234859901879 | 320
1 | 17.34689217571979 | 320
1 | 14.98115980211334 | 320
1 | 8.120805619931712 | 320
1 | 28.59610677520783 | 320
1 | 14.05127254944544 | 320
1 | 10.77483042898772 | 320
1 | 11.87730673129785 | 320
1 | 17.81909960413879 | 320
1 | 36.8697347448175 | 320
1 | 25.36074397029036 | 320
1 | 29.93029995141832 | 960
1 | 35.18653677087715 | 960
1 | 27.19085501570322 | 960
1 | 33.38353576471377 | 960
1 | 33.25716199351898 | 960
1 | 38.25355090784535 | 960
1 | 88.80101555893467 | 960
1 | 46.41105279036501 | 960
1 | 41.7902839838715 | 960
1 | 21.15313811606593 | 960
1 | 45.13174569188402 | 960
1 | 44.41282169619738 | 960
1 | 41.5582979608063 | 960
1 | 55.78075211444505 | 960
1 | 24.44252723577867 | 960
1 | 46.74189150223461 | 960
1 | 30.1358874370215 | 960
1 | 64.26367897989292 | 960
1 | 34.32587114284328 | 960
1 | 58.55928430765609 | 960
1 | 214.1521904128483 | 2880
1 | 296.8550549578348 | 2880
1 | 106.7774682918236 | 2880
1 | 93.90414498114342 | 2880
1 | 248.9124636344953 | 2880
1 | 517.0150058971658 | 2880
1 | 299.3552143482329 | 2880
1 | 114.9307618309487 | 2880
1 | 164.0772244834602 | 2880
1 | 381.065472397534 | 2880
1 | 209.2375327264787 | 2880
1 | 85.20554286954513 | 2880
1 | 735.019283766107 | 2880
1 | 78.84746348891184 | 2880
1 | 225.3125920889098 | 2880
1 | 795.6735746253821 | 2880
1 | 141.6290725374487 | 2880
1 | 483.4060075236331 | 2880
1 | 93.25314645586683 | 2880
1 | 563.3633042803084 | 2880
Spreadsheet: 743675d1628672166-how-to-add-financial-data-from-one-sheet-to-another-based-on-two-variables-example-2
Sheet: Sheet1

Country | Financial ($) | [NAME]
Austria | 580.02 | MARS0001
Austria | 4076.92 | MARS0001
Austria | 5704.47 | MARS0001
Austria | 2669.02 | MARS0001
Austria | 917.08 | MARS0001
Austria | 875.03 | MARS0001
Austria | 818.54 | MARS0001
Austria | 831.24 | MARS0001
Austria | 575.92 | MARS0001
Austria | 121.83 | MARS0001
Austria | 175.84 | MARS0001
Austria | 99.59 | MARS0001
Austria | 19.15 | MARS0001
Austria | 111.2 | MARS0001
Austria | 21.39 | MARS0001
Austria | 1001.01 | MARS0001
Austria | 19244.64 | MARS0001
Austria | 415.9 | MARS0001
Austria | 553.5 | MARS0001
Austria | 1578.96 | MARS0001
Austria | 710.2 | MARS0001
Austria | 4225.67 | MARS0001
Austria | 1984.91 | MARS0001
Austria | 0.01 | MARS0001
Austria | 237.95 | MARS0001
Austria | 111.3 | MARS0001
Austria | 2173.09 | MARS0001
Austria | 1566.85 | MARS0001
Austria | 1844.85 | MARS0001
Czech Republic | 29.79 | MARS0001
Czech Republic | 643.77 | MARS0001
Czech Republic | 643.76 | MARS0001
Czech Republic | 32.38 | MARS0001
Czech Republic | 3.89 | MARS0001
Czech Republic | 7.77 | MARS0001
Czech Republic | 68.64 | MARS0001
Czech Republic | 186.48 | MARS0001
Czech Republic | 472.69 | MARS0001
Czech Republic | 858.6 | MARS0001
Czech Republic | 323.76 | MARS0001
Czech Republic | 3399.45 | MARS0001
Czech Republic | 472.69 | MARS0001
Czech Republic | 349.66 | MARS0001
Czech Republic | 643.77 | MARS0001
Czech Republic | 643.76 | MARS0001
Czech Republic | 165.59 | MARS0001
Czech Republic | 275.19 | MARS0001
Czech Republic | 341.89 | MARS0001
Czech Republic | 196.68 | MARS0001
Czech Republic | 11814.35 | MARS0001
Czech Republic | 647.51 | MARS0001
Czech Republic | 647.51 | MARS0001
Czech Republic | 2012.22 | MARS0001
Czech Republic | 3028.84 | MARS0001
Czech Republic | 2885.52 | MARS0001
Hungary | 11.29 | MARS0001
Spreadsheet: 679540d1590484679-progress-bar-based-on-dates-progress-bar-2-
Sheet: owssvr

Title | Status of Project | Programme | Project Manager | [NAME] | Approved Baseline End Date | Initiate Baseline Start Date | Initiate Baseline End Date | Define & Design Baseline Start Date | Define & Design Baseline End Date | Build & Deliver Baseline Start Date | Build & Deliver Baseline End Date | Closure Baseline Start Date | Closure Baseline End Date | Item Type | Path | Estimated End Date | Project End Date | Completion%
TEST 1 | Live |  | t8909 | Amber | 2020-02-29 00:00:00 | 2015-05-15 00:00:00 | 2015-09-30 00:00:00 | 2015-10-01 00:00:00 | 2016-02-29 00:00:00 | 2019-02-28 00:00:00 | 2019-10-31 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | Item |  | 2022-04-05 00:00:00 |  |  |  | Estimated End Date is present, hence used.
 |  |  |  |  |  | 2015-05-15 00:00:00 |  |  |  |  |  |  |  |  |  | 2020-04-05 00:00:00
 |  |  |  |  |  | 2015-05-15 00:00:00 |  |  |  |  |  |  |  |  |  | 2020-07-01 00:00:00
 |  |  |  |  |  | 2015-05-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | Neither date used = blank
 |  |  |  |  |  | 2015-05-15 00:00:00 |  |  |  |  |  |  |  |  |  | 2023-03-31 00:00:00
 |  |  |  |  |  | 2015-05-15 00:00:00 |  |  |  |  |  |  | 2022-01-12 00:00:00 |  |  |  |  |  |  | Estimated End Date missing, hence [NAME] used
 |  |  |  |  |  | 2015-05-15 00:00:00 |  |  |  |  |  |  | 2020-05-12 00:00:00
 |  |  |  |  |  | 2015-05-15 00:00:00
 |  |  |  |  |  | 2015-05-15 00:00:00
 |  |  |  |  |  | 2015-05-15 00:00:00
Spreadsheet: 156563d1337347331-summing-two-fields-mortgage-calculator
Sheet: First Details

Original Mortgage Payment |  |  |  | Enter in your Primary Mortgage amount, [NAME] in Years for the mortgage/loan, the Annual Interest Rate, and Period Begin Date.  The system will calculate out the rest. This is very handy if you are shopping around for loans.
Given the following:
Primary Mortgage
Term in Years
Annual Interest Rate
Original Payment |  |  |  | Interest Paid
 |  |  |  | Total Paid
Period | Year | Balance | Payment | Principal | Interest | Equity | Total Interest | Total Payments
1 | 0
Spreadsheet: 1fbaafda-7640-4a13-9551-073ac8b98b44
Sheet: SW LDS

Grant: |  | Statewide Longitudinal Data System - ARRA |  |  |  |  |  | Statewide Longitudinal Data System - ARRA
CFDA # |  | 84.384A |  |  |  |  |  | FY2012-13
GRANT NUMBER: |  | 7384
FISCAL YEAR: |  | 2012-13
[NAME]: |  | Not allowed on this grant-verify
Question regarding payments: |  | [NAME]   [PHONE] or [EMAIL]
Questions regarding grant: |  | Marti Rodriguez [PHONE] or [EMAIL]
LAST DAY TO SUBMIT REQUESTS FOR THIS GRANT  - October 15, 2013
Code | District Name | School Name | ALLOCATION | PAYMENTS TO DATE | BALANCE | DECEMBER 2012 | JANUARY 2013 | FEBRUARY 2013 | MARCH 2013 | APRIL 2013 | MAY 2013 | JUNE 2013 | JULY 2013 | AUGUST 2013 | SEPTEMBER 2013 | OCTOBER 2013 | NOVEMBER 2013
1420 | Jeffco |  | 100000 |  |  |  |  |  |  |  | 41066 | 15422 | 19564 |  |  | 5160
Spreadsheet: 60543d1261064788-sorting-column-by-contents-of-every-7th-row-sorting-sample
Sheet: Sheet1

A B CONSTRUCTION
3131 BECKMAN ROAD
ATOWN NY 17701
865-2952
A L CONSTRUCTION
4002 MAIN STREET
ERIE , NY 14516
695-1010
[NAME]
RENTAL UNIT LLC
303 LAFAYETTE STREET
ATOWN NY 74701
234-6666
A C EXCAVATING
PO BOX 94
DOCTON NY 14716
761-9951
TC CONTRACTING
605 SECOND STREET
SETYDF  NY 14707
456-3201
Spreadsheet: 235221d1368425873-how-to-use-conditional-formatting-with-logical-operators-present-in-the-excel-sheet-conditional-fomating
Sheet: Sheet2

 | Achievement
Target | Jan | Feb | Mar | Apr | May
0.1 | -0.1 | 0 | 0.05 | 0.1 | 0.15
>=10% | -0.1 | 0 | 0.05 | 0.1 | 0.15 | Conditional formating does not work when '>=' symbol is used (see cellA6)
Spreadsheet: 117949d1313291219-excel-2007-conditional-formulas-kyles-halo-reach-commendations
Sheet: FIREFIGHT

FIREFIGHT
Commendation | Requires | Current Number | To Next Tier | Iron | [NAME] | Silver | Gold | Onyx | [NAME]
Backup | Assist | 191 |  | 50 | 250 | 750 | 1500 | 3000 | 8000
Dome Inspector | [NAME] | 7174 |  | 50 | 250 | 500 | 4000 | 8000 | 20000
Get Loud | Heavy weapon kill | 4513 |  | 100 | 375 | 750 | 2000 | 4000 | 8000 |  | Iron
Grounded | Destroy enemy vehicle | 52 |  | 50 | 200 | 400 | 2500 | 6000 | 12000 |  | [NAME]
In Command | Leader-class | 3043 |  | 75 | 375 | 750 | 3000 | 6000 | 10000 |  | Silver
Longshot | Precision weapon kill | 8308 |  | 250 | 750 | 4000 | 10000 | 20000 | 32000 |  | Gold
Methodical | Spree | 1351 |  | 25 | 175 | 500 | 2500 | 5000 | 10000 |  | Onyx
Numbers Game | [NAME] | 5229 |  | 25 | 175 | 500 | 2500 | 5000 | 15000 |  | [NAME]
Perfectionist | Round w/out dying | 45 |  | 50 | 250 | 500 | 2000 | 5000 | 8000
Pull the Pin | Grenade kill | 1502 |  | 50 | 250 | 500 | 3000 | 5000 | 9000
[NAME]' Through | Automatic weapon kill | 861 |  | 250 | 750 | 3000 | 10000 | 20000 | 32000
Specialized | Specialist-class enemy | 8611 |  | 175 | 525 | 2000 | 6000 | 10000 | 14000
Target Practice | Infantry-class | 8863 |  | 250 | 750 | 3000 | 7000 | 12000 | 20000
[NAME] | Small arms weapon kill | 3031 |  | 250 | 750 | 3000 | 6000 | 10000 | 16000
Vehicular | Vehicle kill | 853 |  | 200 | 500 | 800 | 3200 | 6400 | 14000
Spreadsheet: 772182d1647050517-find-column-header-for-last-non-empty-cell-in-a-row-find-column-header-for-last-non-empty-cell-in-a-row
Sheet: Sheet1

End Date | 2022-01-25 00:00:00
2022-02-01 00:00:00 |  | 1 | 3 |  |  |  |  | 1
2022-02-02 00:00:00 |  |  | 1 | 1 |  |  |  | 2 | 2
2022-01-28 00:00:00 |  | 1 |  | 2
Above Cell to have formula to show the header for last non empty cell
Spreadsheet: 137441d1327103693-drop-down-list-specified-by-range-drop-down-list-specified-by-range
Sheet: Sheet1

Choice | Start Number | End Number |  | Start # |  |  | B
A | 90.4 | 90.7 |  | End #
B | 92.9 | 93.3 |  | Increment | 0.2
C | 93.5 | 99.8
D | 11.5 | 15.9
Spreadsheet: 270017d1381346160-how-to-convert-rows-in-to-column-by-using-formula-post
Sheet: Sheet 1

Country | Month | Accounts Payable | Accounts RA | Accounts PR |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
United States | 8 | 200 | 241 | 123 |  |  |  | Accounts Payable |  |  |  |  | 100 | 150 | 170 | 200 | 130 | 125
United States | 5 | 100 | 201 | 133 |  |  |  | Accounts RA |  |  |  |  | 201 | 198 | 167 | 241 | 180 | 150
United States | 6 | 150 | 198 | 144 |  |  |  | Accounts PR |  |  |  |  | 133 | 144 | 155 | 123 | 166 | 177
United States | 7 | 170 | 167 | 155
United States | 9 | 130 | 180 | 166
United States | 10 | 125 | 150 | 177
Spreadsheet: 285393d1387567551-need-to-have-excel-rank-items-in-column-k-from-highest-to-bottom-with-corresponding-in-j-rvt
Sheet: Sheet1

2 | 8 | 2 | 8 | 4 | 5 | 4 |  |  | Item | Score | Rating
4 | 7 | 7 | 7 | 2 | 4 | 1 |  |  | 1
8 | 2 | 4 | 2 | 1 | 2 | 6 |  |  | 2
1 | 4 | 1 |  | 6 | 1 | 5 |  |  | 3
7 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  | 3
Spreadsheet: 23758d1213474298-sorting-cells-sort-colum
Sheet: Sheet1

Input =================================================================> |  |  |  |  |  |  |  | Ola | [NAME] | Tami | Fareed | Ami | [NAME] | Lina | [NAME] | Noor
I would like to see these names sorted alphabetically as following ============> |  |  |  |  |  |  |  | Ami | [NAME] | Fareed | [NAME] | Lina | [NAME] | Noor | Ola | Tami
Spreadsheet: 267348d1380050808-returning-matching-keywords-answer1
Sheet: Sheet1

Title | Result |  |  |  | Keyword
CEO | 1 |  |  |  | Chief
CEO | 1 |  |  |  | Vice
CEO | 1 |  |  |  | Director
Chief Executive Officer | 1 |  |  |  | Manager
Director | 1 |  |  |  | General
Director | 1 |  |  |  | CEO
Director | 1 |  |  |  | CFO
Executive | False |  |  |  | COO
Managing Director | 1 |  |  |  | CTO
Owner | False
Senior Partner | False
Spreadsheet: 98916d1297723525-creating-a-hierarchy-from-equipment-list-copy-of-parentlocation
Sheet: Sheet1

EQUIPMENT | [NAME] | PARENTLOCATION
50D1 | CRUDE DESALTER | 605000
 | Desired Data Output
50P1A | CRUDE PUMP | 50D1
50PM1A | CRUDE PUMP MOTOR | 50P1A
50PBV001 | SUCTION VALVE FOR 50P1A | 50P1A
50PBV002 | DISCHARGE VALVE FOR 50P1A | 50P1A
50PBV003 | DISCHARGE CHECK VALVE FOR 50P1A | 50P1A
 | Current Data Format
50P1A | CRUDE PUMP | 50D1
50PM1A | CRUDE PUMP MOTOR | 50P1A
50PBV001 | SUCTION VALVE FOR 50P1A | 50P1A
50PBV002 | DISCHARGE VALVE FOR 50P1A | 50P1A
50PBV003 | DISCHARGE CHECK VALVE FOR 50P1A | 50P1A
Spreadsheet: 8630408a-d4ad-4e73-b449-ec7141aab6a5
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FANBF | Test | FANBF | Anti-Nuclear Ab (FANA), [NAME] | ANA, BF | Immunofluorescence Assay (IFA) |  |  |  | 1 | mL | 1 mL body fluid. [NAME] refrigerate.   Required: 1.	[NAME] source 2.	CSF - Reference value is different, order ZW164 | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	CSF | ANA Titer: <1:10 ANA Pattern: No Pattern   Test Performed by: RDL Reference Laboratory, Inc.                             10755 Venice Boulevard                              Los Angeles, CA 90034 | Daily | 1-2 days | 3 - 4 days | 1 | 86038 |  |  |  |  | RDL Reference Laboratory, Inc.
FANBF | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
FANBF | Order Question | Z2563 | ANA Specimen Type |  | Plain Text
FANBF | Result | Z2563 | ANA Specimen Type | ANA Specimen Type | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FANBF | Result | Z2413 | ANA Titer | ANA Titer | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14613-4 | Nuclear Ab:Titr:Pt:Body fld:Qn:
FANBF | Result | Z2414 | ANA Pattern | ANA Pattern | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13067-4 | Nuclear Ab pattern:Imp:Pt:Body fld:Nom:IF
Spreadsheet: 768184d1644871463-creating-a-dynamic-list-that-pulls-from-one-tab-to-another-based-on-a-criteria-cohort-tracking-consolidated
Sheet: Sheet1

Status | Active |  |  | 1 |  |  | Group Discussion - Intro & Schedule
 | Withdrawn |  |  | 2 |  |  | DG - Clarify Values
 | Hold |  |  | 3 |  |  | [NAME]
 | Extension |  |  | 4 |  |  | DG - The Power of Purpose
 |  |  |  | 5 |  |  | DG - How Great Leaders Inspire Action
 | Yes |  |  | 6 |  |  | DG -  Reaching Your Potential
 | No |  |  | 7 |  |  | DG -  Receiving Feedback
 |  |  |  | 8 |  |  | DG - PCL Executive Speech on Development  Planning
 |  |  |  | 9 |  |  | [NAME] in the Real World
Progress | Completed |  |  | 10
 | Inprogress
 | Extension
Withdrawal | No longer PCL
 | Life Changes Hold
 | Personal Demands |  |  |  |  |  | Australia
 | Workload Demands |  |  |  |  |  | Atlantic Canada
 | LA Withdrew |  |  |  |  |  | BC Region
 |  |  |  |  |  |  | Calgary
 |  |  |  |  |  |  | [NAME]
 | AECRM |  |  |  |  |  | Montreal
 | ASD |  |  |  |  |  | Ottawa
 | ASD - Adv |  |  |  |  |  | Regina
 |  |  |  |  |  |  | Saskatoon
 |  |  |  |  |  |  | Toronto
 |  |  |  |  |  |  | Winnipeg
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Resources
 |  |  |  |  |  |  | Edmonton Energy
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Edmonton Industrial Management
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | California Buildings
 |  |  |  |  |  |  | Denver
 |  |  |  |  |  |  | Hawaii
 |  |  |  |  |  |  | Minneapolis
 |  |  |  |  |  |  | Orlando
 |  |  |  |  |  |  | Seattle
 |  |  |  |  |  |  | Civil Infastructure
 |  |  |  |  |  |  | Resources
 |  |  |  |  |  |  | US Head Office
 |  |  |  |  |  |  | Bakersfield
 |  |  |  |  |  |  | US PICCO
Spreadsheet: andy_zipper__650__11_21_01OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HO Z1 | 54 | 230 | 330 | 41.6 | 59.7 | 1.72 | 2001-11-21 14:24:00
 | HO F2 | 55 | 700 | 800 | 51.7 | 59.1 | 1.92 | 2001-11-21 14:24:00
 | HO G2 | 56 | 1025 | 1125 | 53.6 | 58.9 | 1.98 | 2001-11-21 14:24:00
 | [NAME] | 55 | 1160 | 1250 | 52.2 | 56.3 | 1.88 | 2001-11-21 14:24:00
 | HO J2 | 55 | 1200 | 1300 | 47.7 | 51.7 | 1.72 | 2001-11-21 14:24:00
 | HO K2 | 54 | 1250 | 1350 | 45.4 | 49.1 | 1.6 | 2001-11-21 14:24:00
 | HO M2 | 55 | 1300 | 1450 | 42.4 | 47.3 | 1.55 | 2001-11-21 14:24:00
 | HO N2 | 55 | 1350 | 1500 | 41.2 | 45.8 | 1.5 | 2001-11-21 14:24:00
 | HO Q2 | 56 | 1400 | 1550 | 39.3 | 43.6 | 1.46 | 2001-11-21 14:24:00
 | HO U2 |  |  |  | 36.9 | 40.9 | 1.37 | 2001-11-16 14:52:00
 | [NAME] |  |  |  | 38.4 | 42.2 | 1.42 | 2001-11-15 14:53:00
 | HO X2 |  |  |  | 37.9 | 40.3 | 1.38 | 2001-11-15 14:53:00
 | [NAME] |  |  |  | 33.3 | 36.6 | 1.32 | 2001-11-07 14:56:00
 | HO F3
 | [NAME] |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | HO H3
Spreadsheet: 842800d1694778182-problems-with-appending-columns-to-new-tables-combine_column-aligw_dl_edit
Sheet: CombinedSignals

Signal Type | Signal Name |  |  |  |  |  |  |  | Signal Type | Signal Name
 | ctrl_valve_interlk0 | But this is NOT how the Signal Name column should appear. |  |  |  |  |  |  | 28v_IN0 | ctrl_valve_interlk0 | This is how the Signal Name column should appear.
28v_IN1 | ctrl_valve_interlk1 |  |  |  |  |  |  |  | 28v_IN1 | ctrl_valve_interlk1
28v_IN2 |  |  |  |  |  |  |  |  | 28v_IN2
5v_IN0 | lvl_sch0 |  |  |  |  |  |  |  | 5v_IN0 | lvl_sch0
5v_IN1 |  |  |  |  |  |  |  |  | 5v_IN1
Analog_IN0 | eng_temp0 |  |  |  |  |  |  |  | Analog_IN0 | eng_temp()
Analog_IN1 |  |  |  |  |  |  |  |  | Analog_IN1
Analog_IN2 |  |  |  |  |  |  |  |  | Analog_IN2
28v_OUT0 | ctrl_valve_pos0 |  |  |  |  |  |  |  | 28v_OUT0 | ctrl_valve_pos0
28v_OUT1 | ctrl_valve_pos1 |  |  |  |  |  |  |  | 28v_OUT1 | ctrl_valve_pos1
28v_OUT2 |  |  |  |  |  |  |  |  | 28v_OUT2
5v_OUT0 | eng_alm0 |  |  |  |  |  |  |  | 5vOUT0 | eng_alm0
5v_OUT1 |  |  |  |  |  |  |  |  | 5vOUT1
PWM_0 | [NAME] |  |  |  |  |  |  |  | PWM_0 | [NAME]
Spreadsheet: 21906d1210096165-concatenate-between-entries-letter-test
Sheet: Warning Letters

Year | Mo | Letter Date | New Entry | 09/2005, 10/2005, 11/2005
2005 | 9 | 2006-02-01 00:00:00 | 2005-09-01 00:00:00
2005 | 10 | 2006-02-01 00:00:00 | 2005-10-01 00:00:00
2005 | 11 | 2006-02-01 00:00:00 | 2005-11-01 00:00:00
RptYr | RptMo | LtrDate | New Entry | 09/2005, 10/2005, 11/2005
2005 | 9 | 2006-03-01 00:00:00 | 2005-09-01 00:00:00
2005 | 10 | 2006-03-01 00:00:00 | 2005-10-01 00:00:00
2005 | 11 | 2006-03-01 00:00:00 | 2005-11-01 00:00:00
RptYr | RptMo | LtrDate | New Entry
2005 | 9 | 2006-04-03 00:00:00 | 2005-09-01 00:00:00
2005 | 10 | 2006-04-03 00:00:00 | 2005-10-01 00:00:00
2005 | 11 | 2006-04-03 00:00:00 | 2005-11-01 00:00:00
RptYr | RptMo | LtrDate | New Entry
2006 | 6 | 2006-10-02 00:00:00 | 2006-06-01 00:00:00
2006 | 7 | 2006-10-02 00:00:00 | 2006-07-01 00:00:00
RptYr | RptMo | LtrDate | New Entry
2006 | 6 | 2006-11-01 00:00:00 | 2006-06-01 00:00:00
2006 | 7 | 2006-11-01 00:00:00 | 2006-07-01 00:00:00
rptyr | rptmo | ltrdate | New Entry
2006 | 9 | 2007-01-02 00:00:00 | 2006-09-01 00:00:00
2006 | 10 | 2007-01-02 00:00:00 | 2006-10-01 00:00:00
rptyr | rptmo | ltrdate | New Entry
2006 | 12 | 2007-04-02 00:00:00 | 2006-12-01 00:00:00
2007 | 1 | 2007-04-02 00:00:00 | 2007-01-01 00:00:00
rptyr | rptmo | ltrdate | New Entry
2007 | 3 | 2007-07-02 00:00:00 | 2007-03-01 00:00:00
2007 | 4 | 2007-07-02 00:00:00 | 2007-04-01 00:00:00
rptyr | rptmo | ltrdate | New Entry
2007 | 3 | 2007-08-01 00:00:00 | 2007-03-01 00:00:00
2007 | 4 | 2007-08-01 00:00:00 | 2007-04-01 00:00:00
2007 | 5 | 2007-08-01 00:00:00 | 2007-05-01 00:00:00
rptyr | rptmo | ltrdate | New Entry
2007 | 4 | 2007-09-04 00:00:00 | 2007-04-01 00:00:00
2007 | 5 | 2007-09-04 00:00:00 | 2007-05-01 00:00:00
2007 | 6 | 2007-09-04 00:00:00 | 2007-06-01 00:00:00
Spreadsheet: david_delainey__8099__Market Data Costs 11-9
Sheet: Proposed Budget Detail

 | PROPOSED 2001 MARKET DATA BUDGET
 | 2000 Estimate |  | 2001 Proposed |  | Year to Year Change
American Stock Exchange | 39084 |  | 45026
Autex | 22000 |  | 26793
Bloomberg | 0 |  | 1852894
Circuit Fees (SW Bell, MCI) | 0 |  | 25000
Bridge (Telerate Plus) | 418186 |  | 919000
Canadian Enerdata | 22367 |  | 22367
CQG | 319511 |  | 832200
Cyber Tech, Inc | 0 |  | 3000
Dow Jones Interactive Service | 675000 |  | 675000
Dow Jones News on Telerate | 37677 |  | 50400
DTN | 14851 |  | 18408
Energy Intell. Group | 71915 |  | 47880
FACTSET | 116045 |  | 95000
Financial Times Energy | 85610 |  | 190000
First Call Data | 27518 |  | 37728
Freese/Notis Weather | 23940 |  | 24897
IBES Int'l. | 57000 |  | 86840
IHS Energy Group/Dwights LLC | 239903 |  | 249499
Instinet | 2400 |  | 24960
Intelligence Press | 86066 |  | 89504
[NAME] | 0 |  | 271320
McGraw Hill S&P Compustat | 40092 |  | 42186
Merrick | 36780 |  | 38251
NASDAQ Exchange | 27192 |  | 31217
New York Stock Exchange | 57121 |  | 65803
Oil & Gas Information Systems | 2704 |  | 2704
OPRA | 21087 |  | 38184
Primark (Disclosure) | 130000 |  | 161610
RDI | 157411 |  | 190596
Reuters | 1678073 |  | 2301760
Ried, Thumberg & Co.(telerate) | 3744 |  | 3893
Stockval | 36588 |  | 36588
Telerate | 1200000 |  | 500000
Toronto Stock Exchange | 24544 |  | 32700
Trac Data | 32423 |  | 48880
Utility Data Institute(UDI) | 14926 |  | 14926
Miscellaneous | 200000 |  | 200000
Totals
LIM | 593543 |  | 593543
CMAI | 23205 |  | 32000
DRI - LIM | 121000 |  | 160000
ICIS LOR | 23930 |  | 23930
S & P Platt's | 330600 |  | 400000
Petroleum  Argus | 70000 |  | 207480
UGC/OPIS | 22368 |  | 50700
Seapac Services | 10816 |  | 11248
Total for [NAME] and LIM
Note that the Reuters and Bloomberg numbers are for North America Only.
Grand Total
(
Spreadsheet: 761369d1640862191-sum-up-values-across-columns-in-table-sumifsexample
Sheet: Sheet1

 |  |  | Deployment | Name | Result
 |  |  | Dep1 | Name1 | 0
 |  |  | Dep1 | [NAME] | 1
 |  |  | Dep1 | Name3 | 0
 |  |  | Dep1 | Name4 | 2 |  |  | Expected result = 3 (Name1 + Name4 where Deployment = Dep1)
 |  |  | Dep2 | Name5 | 2
 |  |  | Dep2 | Name6 | 4