tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 116029d1311522312-selective-columns-handicap-template-midshires
Sheet: C

[NAME]. Hamon |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 672310d1586826802-combining-cells-with-values-list-of-contract
Sheet: Sample

Name | Cost | Try input data on column A & B | List | Total | Text Output Requested | <-- base on  carlito2002wgn formula | this is the helper column without using index match formula--> | COUNT DUPLICATE | Just Extract 1 if find Dubplicate | Sort duplicate | Show name
Subcontractor A | 25000 | Make sure only number on B
Subcontractor B | 72000 | Data entry until 1000 row
Subcontractor C | 12000
Subcontractor B | 52000
Subcontractor C | 31000
Subcontractor C | 15000
Subcontractor A | 7500
Subcontractor D
Spreadsheet: sara_shackleton__37343__Royal Bank of Canada Isdaswap
Sheet: ANEWSWP2

ISDA SWAP AGREEMENT INFORMATION SHEET
 |  | ATTORNEY: | [NAME]
DATE: |  | DEAL MAKER: | Derek Davies
COUNTERPARTY: | Royal Bank of Canada | CONTACT:
ADDRESS: |  | TITLE:
 |  | PHONE:
 |  | FAX:
Incorporation State |  | S&P Rating | AA-
STRUCTURE | COUNTERPARTY | ECC
GUARANTOR (RATING) |  | Enron Corp. (BBB+)
LIMIT $ MILLIONS |  | 400 | C$
Incorporation State |  | DE
ELEGIBLE SWAP PARTICIPANT
Counterparty | Yes
Guarantor |  | Yes
COLLATERAL  THRESHOLD MATRIX in $ MILLIONS
based on S & P and
Moody's ratings
 | 45 | 45 | C$
Specify Type of Debt: | Senior Unsecured | Senior Unsecured
COLLATERAL TYPE
Letter of Credit | X | X | Weekly margin calls
Cash
Treasuries/Maturity limit
MINIMUM TRANSFER $ | 1 | 1 | C$
COLLATERAL ROUNDING
Delivery Amount | 250000 | 250000 | C$
Return Amount | 250000 | 250000 | C$
HOLDING and USE OF COLLATERAL
Permitted | X | X
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty | X
-Guarantor |  | X
Debt Ratings Change | X | X
-Below = S&P/Moody's | BBB-/Baa3 | BBB-/Baa3
Financial Covenants
-Funded Debt to Worth
-Minimum Net Worth
-EBITDA/Interest Expense
-Funded Debt / EBITDA
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty ($[NAME]) | 100 |  | US$
-Guarantor ($[NAME]) |  | 100 | US$
Change in ownership
SPECIFIED ENTITY
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: | NO:
OTHER COMMENTS:
GLOBAL CREDIT:
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x-3831
Spreadsheet: 96929d1296165226-countif-on-partial-cell-data-book3
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-01-01 00:00:00 | 2010-01-01 00:00:00 | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-01-02 00:00:00 | 2010-02-01 00:00:00 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-01-03 00:00:00 | 2010-03-01 00:00:00 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-01-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-01-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-01-06 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-01-07 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-01-08 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-01-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-01-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-01-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-02-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-02-03 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-02-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-02-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-02-06 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-02-07 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-03-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-03-03 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-03-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-03-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-03-06 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-03-07 00:00:00
Spreadsheet: 749233d1632622331-sales-equation-canada-event-planner-template
Sheet: DISTRICT

 | Event Name: | Canadian Thanksgiving
 | Start Date: | 2021-10-06 00:00:00
 | End Date:
 | DISTRICT TOTALS
 | STORE # | STORE NAME | [NAME] | LY | +/- | TRANS GOAL
 | 309 | Edmonton
 | 351 | Toronto Premium Outlet
 | 352 | Vancouver
 | 353 | Niagara On The Lake
 | 354 | Cookstown
 | 355 | Ottawa
 | 356 | Montreal
 | 361 | Calgary
 | 362 | Winnipeg
 | 364 | Vaughan Mills FOC
 | 366 | [NAME]
 | 365 | Tsawwassen Mills
 | TOTAL
Spreadsheet: darrell_schoolcraft__7346__imball0201
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 | -5234 | -5000 |  | -21274 |  | -14149 | -6
2 | -5328 | -5000 |  | -21274 |  | -21280 | -6
3 |  |  |  | -11843 |  | -12124 | -106
4 |  |  |  | -23304 |  | -3519 | -19999 | 1
5 |  |  |  | -14046 |  | 0 | -14568
6 |  |  |  | -14442 |  | 0 | -10070 | 4
7 |  |  |  | -14046 |  | -18440 | 0
8 |  |  |  | -40692 |  | -4423 | -1
9 |  |  |  | -15474 |  |  | 0
10 |  |  |  | -15473 |  |  | -28
11 |  |  |  | -25367 |  |  | -25154
12 |  |  |  | -5474 |  |  | -8
13 |  |  |  | -5474 |  |  | -11554
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
index
2001-12-31 00:00:00 |  |  |  |  | 417969.39
2002-01-12 00:00:00
CBS Volume
 |  |  | 5124
Spreadsheet: 88441d1288267644-importance-score-calculation-matrix
Sheet: Sheet1

Critiria | A | B | Importance
Light weight | + | - | 1
Long life | - | + | 2
Low cost | S | + | 3
Faster to produce | + | - | 3
Investment | + | S | 2
Total + | 6 | 5
Total - | 2 | 4
Total S | 3 | 2
Spreadsheet: 92901fc9-4f05-469c-98ad-e2ad434bb048
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
D2F | Test | D2F | Fungal Sequencing Identification | D2 Fungal Sequencing Identification |  |  |  |  |  |  | This test is for Billing Purposes Only.  This is not an orderable test. |  |  |  |  |  |  | 1 | 87153 |  |  |  |  | Rochester
D2F | [NAME] | VARIES | Varies |  |  |  | See instructions
Spreadsheet: 1bb6078b-085d-43e5-944e-4d1a1511cf07
Sheet: Sheet1

GENERAL | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
 | Brief Title |  | Approval Deadline |  | Reason
 | Funding for Indigent Health |  |  |  | Continuation of support for health care services
 | Care Providers
Details |  |  |  |  | Positions/Recommendations
 | Reason for Legislation |  |  |  | Sponsor |  |  |  | Health Department
 |  |  |  |  | Programs,
 |  |  |  |  | Departments, |  |  |  | Health Department
 |  |  |  |  | or Groups
 |  |  |  |  | Affected
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  |  |  |  |  | _________ Department
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  |  |  | _________ Department
 |  |  |  |  |  |  |  |  | _________ Department
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  |  |  | None Known
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  | X |  | For
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or
 |  |  |  |  | Commission |  | By
 |  |  |  |  | Recommendation
 |  |  |  |  |  |  |  |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 |  |  |  |  | Committee |  |  |  | Do pass
 |  |  |  |  | Actions
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on reverse side)
Details |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  | X |  | No |  |  |  | Yes
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections --
 |  |  |  |  | Including Indirect
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact
 |  |  |  |  | Fund Source (s) |  | 19__ Budget, Page ___
 |  |  |  |  | and Appropriation |  | Unbudgeted, Appropriation
 |  |  |  |  | Account Codes |  | ________________ Fund
 |  |  |  |  | (Use this space for further discussion, if necessary)
Applicable Dates:
 | May 1, 2009 through April 30, 2010
Fact Sheet Prepared by:
 | Fiscal Staff |  | Date 4/20/09
Reviewed by:
 | Name |  | Date
Reference Numbers
Spreadsheet: 24264636-3cf6-4806-ac27-55541f7c5212
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | รายการหนังสือเรียนชั้น อนุบาล 1 ปีการศึกษา 2556 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
ที่ | ชื่อหนังสือ | สำนักพิมพ์ | จำนวน(เล่ม) | ราคา/หน่วย | จำนวนเงิน
1 | คัดไทยอนุบาล 1 | ปสม. | 10 | 40 | 400
2 | แบบฝึกเขียนตัวเลขอารบิค | ปสม. | 10 | 40 | 400
3 | ศิลปปฐมวัย อนุบาล 2 เล่ม 1 | อจท. | 10 | 38 | 380
4 | ศิลปปฐมวัย อนุบาล 2 เล่ม 2 | อจท. | 10 | 38 | 380
5 | [NAME] | อจท. | 10 | 34 | 340
 | รวมเงิน |  |  | 190 | 1900
 |  | 200
Spreadsheet: 680123d1590786558-batch-and-expire-sample
Sheet: Hoja1

DATE | CODE | [NAME] | MOV | QTY | BATCH | EXPIRE DATE
2020-05-28 00:00:00 | 6403005 | X | IN | 630 | A27050S | 2022-05-01 00:00:00
2020-05-28 00:00:00 | 6401005 | Y | IN | 630 | A23050S | 2022-05-01 00:00:00
2020-05-28 00:00:00 | 6401005 | Y | IN | 607 | A26050S | 2022-05-01 00:00:00
2020-05-28 00:00:00 | 70520 | Z | IN | 16 | A210501 | 2020-11-17 00:00:00
2020-05-28 00:00:00 | 1545824 | F | IN | 57 | A190501 | 2020-11-15 00:00:00
2020-05-28 00:00:00 | 1545824 | F | IN | 57 | A200501 | 2020-11-16 00:00:00
2020-05-28 00:00:00 | 7303307 | D | IN | 2 | A190501 | 2020-11-15 00:00:00
2020-05-28 00:00:00 | 7303307 | D | IN | 2 | A210501 | 2020-11-17 00:00:00
2020-05-28 00:00:00 | 1705201 | E | IN | 1 | A210501 | 2020-11-17 00:00:00
2020-05-28 00:00:00 | 1545801 | DE | IN | 1 | A190501 | 2020-11-15 00:00:00
2020-05-28 00:00:00 | 7303307 | D | IN | 2 | A200501 | 2020-11-16 00:00:00
2020-05-28 00:00:00 | 1545801 | DE | IN | 1 | A200501 | 2020-11-16 00:00:00
2020-05-28 00:00:00 | 7303307 | D | IN | 1 | A250401 | 2020-10-22 00:00:00
2020-05-28 00:00:00 | 70520 | Z | IN | 40 | A210501 | 2020-11-17 00:00:00
2020-05-29 00:00:00 | 7541.61 | I | OUT | -1 | [NAME]
2020-05-29 00:00:00 | 240081 | II | OUT | -12 | 1212520129
2020-05-29 00:00:00 | 46960 | PP | IN | 24 | A090301 | 2022-02-27 00:00:00
2020-05-29 00:00:00 | 1513401 | AC | IN | 4 | A280501 | 2021-05-23 00:00:00
2020-05-29 00:00:00 | 1469671 | SSD | IN | 1 | A181192 | 2021-11-07 00:00:00
2020-05-29 00:00:00 | 1445111 | RY | IN | 1 | A280501 | 2020-09-25 00:00:00
2020-05-29 00:00:00 | 1715707 | TT | OUT | -1 | A100401 | 2020-08-08 00:00:00
2020-05-29 00:00:00 | 1705201 | E | OUT | -1 | [NAME] | 2020-10-20 00:00:00
2020-05-29 00:00:00 | 70520 | Z | OUT | -15 | A210301 | 2020-11-17 00:00:00
2020-05-29 00:00:00 | 1513401 | AC | OUT | -3 | A220401 | 2021-04-11 00:00:00
2020-05-29 00:00:00 | 1684906 | ANS | OUT | -2 | A110301 | 2020-11-06 00:00:00
2020-05-29 00:00:00 | 1681706 | FEW | OUT | -2 | A170301 | 2021-03-12 00:00:00
2020-05-29 00:00:00 | 1513401 | AC | OUT | -2 | A220401 | 2021-04-11 00:00:00
2020-05-29 00:00:00 | 1514204 | E | OUT | -5 | A160501 | 2020-11-12 00:00:00
2020-05-29 00:00:00 | 1691204 | HC | OUT | -6 | A270401 | 2021-04-22 00:00:00
2020-05-29 00:00:00 | 1752005 | TOP | OUT | -2 | A210501 | 00:00:00
2020-05-29 00:00:00 | 71880 | U | OUT | -3 | A260501 | 2021-05-21 00:00:00
2020-05-29 00:00:00 | 1445112 | GB | OUT | -1 | [NAME] | 2020-08-12 00:00:00
2020-05-29 00:00:00 | 59950 | BB | OUT | -1 | A240201 | 2021-02-23 00:00:00
2020-05-29 00:00:00 | 1445114 | MM | OUT | -2 | A280401 | 2020-08-26 00:00:00
2020-05-29 00:00:00 | 707 | RR | IN | 180 | A26050S | 2022-05-01 00:00:00
2020-05-29 00:00:00 | 707 | RR | IN | 852 | A27050S | 2022-05-01 00:00:00
Spreadsheet: 783541d1654888672-skip-duplicate-value-in-countif-2022-06-10-oeldere-hixtori-skip-duplicate-value-in-countif-v2
Sheet: PT

Rijlabels | Sum Criteria
apples | 3
apricots | 1
avocados | 1
bananas | 3
blueberries | 2
grapefruits | 1
honeydew | 1
kiwifruit | 1
limes | 1
nectarines | 2
oranges | 2
peaches | 3
pears | 1
plums | 2
raspberries | 2
rockmelons | 2
strawberries | 1
tomatoes | 4
watermelons | 2
Eindtotaal | 35
Spreadsheet: 106560d1303827209-vlookup-and-if-and-wages
Sheet: SUMMARY

Date Due | Amount Due | Paid | Overdue
Spreadsheet: 138137d1327525172-data-extraction-help-please-pivot-table-data-extraction
Sheet: Sheet1

NAME | LIKES |  |  | Count of LIKES | Column Labels
Name1 | Bread |  |  | Row Labels | Bread | Soup | Spaghetti | Grand Total
[NAME] | Bread |  |  | Name1 | 1 |  | 1 | 2
Name3 | Spaghetti |  |  | [NAME] | 1 |  |  | 1
Name4 | Bread |  |  | Name3 |  |  | 1 | 1
Name1 | Spaghetti |  |  | Name4 | 1 |  |  | 1
Name5 | Soup |  |  | Name5 |  | 1 | 1 | 2
Name5 | Spaghetti |  |  | Grand Total | 3 | 1 | 3 | 7
 |  |  |  | LIKES | Spaghetti
 |  |  |  | Row Labels
 |  |  |  | Name1
 |  |  |  | Name3
 |  |  |  | Name5
 |  |  |  | Grand Total
Spreadsheet: phillip_m_love__30139__200006_OA
Sheet: EAST-MKT-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  LRC
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 65293826 | 295459076
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 8679509 | 39511966
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 73973335 | 334971042
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -60041053 | -271749316
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -15310495 | -69724975
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 113651 | 503435
 | Total Purchases: |  | -75237897 | -340970856
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | 62465 | 282829
14 |  | Cash Out | 208 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 248589 | 1404828
 | Total Imbalances: |  | 311262 | 1687657
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 1058782 | 220712
18 |  | W/D (Purchase from Stg) | -1000000 | -10
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -1000000 | -10
 | Total Storage: |  | 58782 | 220702
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | 894518 | 4034276.18
 |  |  | 0 | 0
23 | Fuel: |  | -113651 | -503435
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -341659
25 |  | Demand | 0 | -320894.12
 | Total Transport Expense: |  | 0 | -662553.12
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | 1198403.767599999
31 |  | Prior Month Book Balance | 0 | -6919988
 |  | Total MTM Income | 0 | -5721584.232400001
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 6805714
34 |  | Originations | 0 | 18346.42
35 |  | Broker Fees | 0 | -504
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | -38551
 |  | TOTAL INTRA-MTH
Spreadsheet: 348774d1412097361-list-box-list-box-for-dbuff
Sheet: Sheet1

 |  |  |  |  |  |  |  | lookups
list |  |  |  |  |  |  | 2
davey [NAME] | 15 bottom of sea drive | Ocean, MD | 21212 |  |  |  | 1 | davey [NAME]
[NAME] | 17 somewhere ave | Detroit, MI | 17171 |  |  |  | 2 | [NAME]
where you want everything
Spreadsheet: 766547d1643926846-nested-if-function-problem-book1
Sheet: Sheet1

Name | PT ID | Payer |  | Outcome | Attempted formula
Some Name | 1234 | Private Pay |  | No note
Some Name | 2345 | [NAME] |  | Note
 |  |  |  | Blank (literally blank)
Some Name | 3456 | Self Pay |  | No note
Some Name | 5678 | Aetna |  | Note
Some Name | 7900 | No insurance |  | No note
 |  | OPT |  | No note
 |  | MCR-S |  | No note
 |  | MCR-M |  | No note
 |  | Dependent |  | No note
Spreadsheet: 155797d1337054970-excel-2007-sorting-out-to-different-worksheets-and-updating-name-sorting
Sheet: A-G

Last Name | First Name | Document Type | School/Recommender Name | Date Recieved | Row Ref
BROWN | [NAME] | Type_C | School_2 / DEF | 2012-05-11 00:00:00 | 5
DAVIS | RICHARD | Type_A | School_1 / ABC | 2012-05-12 00:00:00 | 8
[NAME] | [NAME] | Type_A | School_2 / DEF | 2012-05-15 00:00:00 | 9
[NAME] | DANIEL | Type_B | School_2 / DEF | 2012-05-08 00:00:00 | 13
GONZALEZ | KEVIN | Type_B | School_1 / ABC | 2012-05-15 00:00:00 | 24
CLARK | MATTHEW | Type_B | School_1 / ABC | 2012-05-12 00:00:00 | 26
ALLEN | SCOTT | Type_B | School_1 / ABC | 2012-05-15 00:00:00 | 33
GREEN | GREGORY | Type_C | School_2 / DEF | 2012-05-12 00:00:00 | 38
[NAME] | [NAME] | Type_B | School_1 / ABC | 2012-05-15 00:00:00 | 39
ADAMS | JERRY | Type_B | School_2 / DEF | 2012-05-08 00:00:00 | 40
CAMPBELL | PETER | Type_C | School_2 / DEF | 2012-05-12 00:00:00 | 44
[NAME] | HENRY | Type_C | School_1 / ABC | 2012-05-12 00:00:00 | 47
EVANS | ARTHUR | Type_A | School_1 / ABC | 2012-05-11 00:00:00 | 49
COLLINS | JUAN | Type_B | School_1 / ABC | 2012-05-12 00:00:00 | 53
EDWARDS | JACK | Type_A | School_2 / DEF | 2012-05-15 00:00:00 | 54
FLORES | [NAME] | Type_A | School_1 / ABC | 2012-05-12 00:00:00 | 56
COOK | SAMUEL | Type_A | School_2 / DEF | 2012-05-07 00:00:00 | 61
COOPER | NICHOLAS | Type_C | School_2 / DEF | 2012-05-12 00:00:00 | 65
BAILEY | BENJAMIN | Type_B | School_2 / DEF | 2012-05-08 00:00:00 | 67
BELL | BRUCE | Type_B | School_1 / ABC | 2012-05-12 00:00:00 | 68
GOMEZ | BRANDON | Type_C | School_2 / DEF | 2012-05-11 00:00:00 | 69
COX | WAYNE | Type_C | School_2 / DEF | 2012-05-03 00:00:00 | 73
DIAZ | BILLY | Type_C | School_1 / ABC | 2012-05-12 00:00:00 | 74
BROOKS | [NAME] | Type_B | School_1 / ABC | 2012-05-15 00:00:00 | 78
BENNETT | RANDY | Type_C | School_2 / DEF | 2012-05-04 00:00:00 | 79
GRAY | HOWARD | Type_B | School_1 / ABC | 2012-05-12 00:00:00 | 80
CRUZ | [NAME] | Type_A | School_1 / ABC | 2012-05-12 00:00:00 | 83
FOSTER | PHILLIP | Type_A | School_2 / DEF | 2012-05-07 00:00:00 | 88
GUTIERREZ | CHRIS | Type_C | School_1 / ABC | 2012-05-05 00:00:00 | 97
BUTLER | EARL | Type_C | School_1 / ABC | 2012-05-15 00:00:00 | 99
BARNES | JIMMY | Type_C | School_2 / DEF | 2012-05-03 00:00:00 | 100
FISHER | ANTONIO | Type_C | School_1 / ABC | 2012-05-12 00:00:00 | 101
Spreadsheet: 732690d1621165901-comparing-unsorted-lists-across-multiple-sheets-fortune-500-problem-example
Sheet: 2010

Rank | Company | Revenues ($ millions) | Profits ($ millions) | Ticker symbol
1 | Wal-Mart Stores | 408214 | 14335 | WMT
2 | #[NAME]! | 284650 | 19280
3 | #[NAME]! | 163527 | 10483
4 | #[NAME]! | 156779 | 11025
5 | #[NAME]! | 150450 | 6276
6 | #[NAME]! | 139515 | 4858
7 | AT&T | 123018 | 12535 | T
8 | #[NAME]! | 118308 | 2717
9 | J.P. Morgan Chase & Co. | 115632 | 11728 | JPM
10 | Hewlett-Packard | 114552 | 7660 | HPQ
11 | [NAME] | 112493 | 8055 | BRK.A
12 | Citigroup | 108785 | -1606 | C
13 | Verizon Communications | 107808 | 3651 | VZ
14 | #[NAME]! | 106632 | 823
15 | #[NAME]! | 104589 | N.A.
16 | #[NAME]! | 103189 | -10949
17 | #[NAME]! | 99612.9 | 1151.6
18 | CVS Caremark | 98729 | 3696 | CVS
19 | #[NAME]! | 98636 | 12275
20 | #[NAME]! | 95758 | 13425
Spreadsheet: 5da58c14-1802-4fb9-836f-01310af3c767
Sheet: Report

Unit | Unit Priority | Objective Name | Strategic Direction | Impact Type | Resource Id | Resource Name | Resource Type | Year 1 Cost | Year 1 Savings | Year 2 Cost | Year 2 Savings | Year 3 Cost | Year 3 Savings | Year 4 Cost | Year 4 Savings
Printing Services | 3 | Continue to maintain four color press through annual maintenance and service. | None | -- Pick One -- | 2.1.r1 | Ryobi 524 | OnGoing | 18000 | 0 | 20000 | 0 | 22000 | 0 | 0 | 0
Spreadsheet: 54714d1254769528-flagging-the-most-recent-entry-in-a-list-previous_donation
Sheet: Sheet1

Requester | Decision | Fiscal Year | Quarter | Previous Donation |  | Rating Grid
Group A | Yes | FY08 | Q1 | N/A |  | FY08Q1 | 1
Group B | Yes | FY08 | Q1 | N/A |  | FY08Q2 | 2
Group C | Yes | FY08 | Q1 | N/A |  | FY08Q3 | 3
Group A | No | FY09 | Q2 | FY08Q1 |  | FY08Q4 | 4
Group B | Yes | FY09 | Q3 | FY08Q1 |  | FY09Q1 | 5
Group A | Yes | FY10 | Q2 | FY08Q1 |  | FY09Q2 | 6
Group D | Yes | FY10 | Q2 | N/A |  | FY09Q3 | 7
Group B | No | FY10 | Q3 | FY09Q3 |  | [NAME] | 8
Group C | Yes | FY10 | Q3 | FY08Q1 |  | FY10Q1 | 9
 |  |  |  |  |  | FY10Q2 | 10
 |  |  |  |  |  | [NAME] | 11
 |  |  |  |  |  | FY10Q4 | 12