tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 5661fabc-ef50-4404-beea-95c4da1a3035
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Curb Records | 715187891722 | [NAME] | Best Of Bj [NAME], The | 2005-07-12 | Compact Disc | Insp | 5.99 | N | To Be Retired
Warner Alliance Atlantic (Word | 93624595229 | [NAME] | Precious Memories | 2002-04-01 | Compact Disc | Na | 17.99 | N | To Be Retired
Spreadsheet: 780091d1652286351-cumulative-dynamic-array-per-nth-column-cumulative-sum-per-nth-column
Sheet: Sheet1

10 | 15 | 66 | 79 | 7 | 55 | 45 | 3 | 12 | 8
 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Moving Columns |  | 4
Desired Result per 4 (cell C5) columns
Spreadsheet: 196840d1354120908-spreadsheet-to-show-the-results-of-golf-competitions-golf-league-table-including-reults
Sheet: RUTLAND

 |  | THE CROWN GOLF SOCIETY ANSTEY LEICESTER
 |  |  | RESULT RUTLAND COUNTY G.C 2012
 | PLAYER | HANDICAP | POINTS SCORED | LEADERBOARD POINTS
1ST | Mick |  |  | 30
2ND | MALC |  |  | 29
3RD | SEAN |  |  | 28
4TH |  |  |  | 27
5TH |  |  |  | 26
6TH |  |  |  | 25
7TH |  |  |  | 24
8TH |  |  |  | 23
9TH |  |  |  | 22
10TH |  |  |  | 21
11TH |  |  |  | 20
12TH |  |  |  | 19
13TH |  |  |  | 18
14TH |  |  |  | 17
15TH |  |  |  | 16
16TH |  |  |  | 15
17TH |  |  |  | 14
18TH |  |  |  | 13
19TH |  |  |  | 12
20TH |  |  |  | 11
21ST |  |  |  | 10
22ND |  |  |  | 9
23RD |  |  |  | 8
24TH |  |  |  | 7
25TH |  |  |  | 6
26TH |  |  |  | 5
27TH |  |  |  | 4
28TH |  |  |  | 3
29TH |  |  |  | 2
30TH |  |  |  | 1
31st |  |  |  | 0
32nd |  |  |  | 0
33rd |  |  |  | 0
34th |  |  |  | 0
35th |  |  |  | 0
36th |  |  |  | 0
37th |  |  |  | 0
38th |  |  |  | 0
39th |  |  |  | 0
40th |  |  |  | 0
41st |  |  |  | 0
42nd |  |  |  | 0
43rd |  |  |  | 0
44th |  |  |  | 0
45th |  |  |  | 0
46th |  |  |  | 0
47th |  |  |  | 0
48th |  |  |  | 0
49th |  |  |  | 0
50th |  |  |  | 0
 | LONGEST DRIVE |  |  | 31ST MARCH 2012
 | NEAREST PIN
Spreadsheet: 722454d1615280340-match-the-debits-and-credits-in-one-column-that-match-0-and-highlight-them-debits-and-credits-in-one-colour-to-hilight-the-ones-that-match-to-0
Sheet: Sheet3

Year | Period | Account | Local amount 1 | LC 1
2021 | 1 | 675020 | -1282.86 | USDAO |  |  |  | Match the debits and credits in one column that match 0 and highlight them
2020 | 12 | 675020 | 1282.86 | USDAO |  |  |  | Dear all, i look to match the debits and credits that match to 0, and highlight them. The goal is to see the unmatched ones, but with ought removing the matched ones. Adding to these i want that they have the same GL account. So we can have the same value in different gls.
2020 | 12 | 675020 | 4502 | USDAO
2020 | 11 | 675020 | -4502 | USDAO |  |  |  | Here is an example.
2020 | 10 | 775020 | 14535.5 | USDAO |  |  |  | Account |  | Local amount 1 | LC 1
2020 | 8 | 775020 | -4502 | USDAO |  |  |  | 775021 |  | 20.27 | USDAO
2020 | 10 | 775020 | -14535.5 | USDAO |  |  |  | 775021 |  | 49.65 | USDAO
2020 | 10 | 775020 | -4502 | USDAO |  |  |  | 775021 |  | USDAO
2020 | 7 | 675020 | -4502 | USDAO |  |  |  | 775021 |  | 0 | USDAO
2020 | 10 | 675022 | -3403.07 | USDAO
2020 | 10 | 775020 | 4502 | USDAO
2020 | 10 | 775020 | -3403.07 | USDAO
2021 | 2 | 775022 | 5.4 | USDAO
2021 | 1 | 775022 | -5.4 | USDAO
2020 | 11 | 775022 | 5304.04 | USDAO
2020 | 11 | 775022 | -5304.04 | USDAO
2021 | 1 | 675020 | 14535.5 | USDAO
2020 | 8 | 775022 | -1494.53 | USDAO
2020 | 7 | 675022 | -3403.07 | USDAO
2020 | 10 | 775020 | 3403.07 | USDAO
2020 | 10 | 775020 | -3403.07 | USDAO
2021 | 2 | 675022 | 3403.07 | USDAO
2020 | 8 | 775020 | 3403.07 | USDAO
2021 | 2 | 675022 | -3403.07 | USDAO
2020 | 8 | 775022 | 1494.53 | USDAO
2019 | 12 | 775021 | -402.72 | USDAO
2019 | 12 | 775021 | 484.59 | USDAO
2019 | 12 | 775021 | -523.54 | USDAO
2019 | 12 | 775021 | 372.76 | USDAO
2019 | 12 | 775021 | -372.76 | USDAO
2019 | 12 | 775021 | -484.59 | USDAO
2020 | 1 | 775021 | -372.76 | USDAO
2020 | 1 | 775021 | -484.59 | USDAO
2020 | 12 | 775021 | -49.65 | USDAO
2020 | 12 | 775021 | 49.65 | USDAO
2020 | 12 | 775021 | -128.21 | USDAO
2020 | 12 | 775021 | 3109.8 | USDAO
2020 | 12 | 775021 | -68.84 | USDAO
2020 | 12 | 775021 | -178.79 | USDAO
2020 | 12 | 775021 | -4663.6 | USDAO
2021 | 1 | 775021 | 372.76 | USDAO
Spreadsheet: mary_fischer__25635__31R
Sheet: E36.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031R
COMPANY NAME    Limbach Company Holding Company
EQUITY INVESTEE'S SUMMARIZED INFORMATION
 |  |  |  | E-36
NAME OF INVESTEE:
% OF OWNERSHIP:
THIS E-SCHEDULE IS REQUIRED FOR ALL OWNED EQUITY INVESTEES.
Please note the relationship and the differences between the E-3 (Analysis of Investment in Unconsolidated Equity Subsidiaries) and the E-36 (Equity
Investee's Summarized Information).  The E-3 seeks details of the Enron consolidating subsidiaries' (i.e. the investor) investment account.  The E-36
seeks summarized income statement and balance sheet information of the unconsolidated subsidiary (i.e. the investee).
If an E-3 has been prepared for an equity investment, then an E-36 for the related in investee needs to be completed.
Include all investees, regardless of Enron's ownership interest.
PLEASE PROVIDE THE FOLLOWING SUMMARIZED FINANCIAL INFORMATION AS IT
WOULD APPEAR IN THE INVESTEE'S FINANCIAL STATEMENTS (100%).
 |  |  |  | BALANCE AT
BALANCE SHEET (100%) |  |  |  | END OF QUARTER
CURRENT ASSETS |  |  |  | 0
PROPERTY, PLANT AND EQUIPMENT, NET. |  |  |  | 0
OTHER NONCURRENT ASSETS |  |  |  | 0
CURRENT LIABILITIES |  |  |  | 0
LONG-TERM DEBT |  |  |  | 0
ADVANCES FROM ENRON COMPANIES |  |  |  | 0
OTHER NON-CURRENT LIABILITIES |  |  |  | 0
OWNERS' EQUITY |  |  |  | 0
Memo:
AMOUNT RECEIVABLE FROM ENRON (included above) |  |  |  | 0
AMOUNT PAYABLE TO ENRON (included above) |  |  |  | 0
INVESTMENT IN UNCONSOLIDATED
EQUITY INVESTEE
(must tie to Hyperion acct TOT_INVEST_SUBS & E-3) |  | 0
Asset/Expense Accts:  DR/(CR)
INCOME STATEMENT (100%) |  |  |  | YEAR-TO-DATE
OPERATING REVENUES |  |  |  | 0
OPERATING EXPENSES |  |  |  | 0
GROSS INTEREST EXPENSE (3rd Party Only) |  |  |  | 0
OTHER INCOME & DEDUCTIONS |  |  |  | 0
INCOME TAXES |  |  |  | 0
NET INCOME
INVESTMENT IN NET INCOME
(must tie to Hyperion acct TOT_EQEARN_OTH & E-3) |  | 0
Income Accts:  DR/(CR)
Memo:
CAPITALIZED INTEREST |  |  |  | 0
RENTAL EXPENSE |  |  |  | 0
 |  |  |  | E-36
Spreadsheet: 1db288c6-3e3d-4f48-ba79-c203104e9f22
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-05-18 09:13:15.540000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.875 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.75 | 101.071 | 100.946 | 100.821 | 100.446
4.625 | 100.16 | 100.035 | 99.91 | 99.535 |  | Note: | Refer To Price [NAME]
4.5 | 99.689 | 99.564 | 99.439 | 99.064 |  |  | For all Price Adjs
4.375 | 99.079 | 98.954 | 98.829
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.25 | 101.875 | 101.75 | 101.625 | 101.25
4.125 | 101.081 | 100.956 | 100.831 | 100.456
4 | 100.76 | 100.635 | 100.51 | 100.135
3.875 | 100.367 | 100.242 | 100.117 | 99.742
3.75 | 99.797 | 99.672 | 99.547
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-06-01 09:13:15.540000
30 DAY | 2011-06-16 09:13:15.540000
45 DAY | 2011-07-01 09:13:15.540000
60 DAY | 2011-07-16 09:13:15.540000
90 DAY | 2011-08-15 09:13:15.540000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: errol_mclaughlin_jr__10046__0204 Global Data Setup AND transactions
Sheet: 0204 Scenarios

Test # | Type of Transaction                 (xxxxx- deal entry) | Buy/ Sell | Product | Internal Entity | External Entity | Trade Date | Date Range
POWER
1 | Power Financial Swap - EnPower | S | Financial | TBD | TBD
2 | Power Forward Sale - EnPower |  | Physical | TBD | TBD
3 | Power Forward Sale - EnPower | S/ Intercompany | Physical | TBD | TBD
4 | Power Index [NAME] |  | Physical | TBD | TBD
GAS
1 | Gas Financial Swap - TAGG |  | Financial | TBD | TBD
 | Gas Financial Option - TAGG |  | Financial | TBD | TBD
 | Gas Financial Option - TDS |  | Financial | TBD | TBD
 | Gas Financial Exchange - TAGG |  | Financial | TBD | TBD
 | Gas Term Purchase - SITARA | B | Physical | TBD | TBD
 | Gas Term Sale - TDS |  | Physical | TBD | TBD
 | Gas Term Sale - TDS | S/ Intercompany | Physical | TBD | TBD
 | Gas Transport Capacity - SITARA |  | Physical | TBD | TBD
 | Gas Storage Capacity - SITARA |  | Physical | TBD | TBD
 | Gas Spot Sale - SITARA |  | Physical | TBD | TBD
 | Gas Transport Usage - SITARA |  | Physical | TBD | TBD
 | Gas Agency Deal - SITARA |  | Physical | TBD | TBD
 | Canada Spot Buy |  | Physical | TBD | TBD
 | Power Financial Option - EOL |  | Financial
 | Power Financial Exchange - EOL |  | Financial
Not scheduled, or awaiting EOL confirmation of what transaction types they will be sending
1 | Power Financial Option - EOL |  | Financial
 | Power Financial Exchange - EOL |  | Financial
 | Power Auto Hedge (EOL to Infinity) |  | Financial
 | Gas Financial Swap - EOL |  | Financial
 | Gas Financial Option - EOL |  | Financial
 | Gas Financial Exchange - EOL |  | Financial
 | Gas Auto Hedge (EOL to Infinity) |  | Financial
 | Canada Fixed Price Swap |  | Financial
 | [NAME] |  | Physical
 | Gas Term Sale - SITARA |  | Physical
 | Gas Agency Deal - SITARA |  | Physical
 | Canada Spot Buy |  | Physical
Omitted test candidates
1 | Gas Financial Desk to Desk - TDS |  | Financial
 | Power Financial Desk to Desk - EnPower |  | Financial
 | Power Financial Exchange - EnPower |  | Financial
 | Power Financial Option - EnPower |  | Financial
 | Power Financial Desk to Desk - EOL |  | Financial
 | Gas Financial Desk to Desk - EOL |  | Financial
 | Gas Financial Desk to Desk - TAGG |  | Financial
 | Gas Financial Swap - TDS |  | Financial
 | Gas Financial Exchange - TDS |  | Financial
 | Gas Spot Purchase - SITARA |  | Physical
 | AEP |  | Physical
 | Bridgeline |  | Physical
Spreadsheet: 542170d1507735802-complex-formula-using-countifs-and-sumifs-to-derive-a-value-across-tabs-simms7400
Sheet: QuarterMaster_Matrix (2)

 | Number of Nights | 4
 | [NAME]
 | [NAME] | 250
 | [NAME]
 | Food Input - Total | 250
 | Food Inflation Rate | 0.05
 | [NAME] Day | 15
 | Tip - Total
 | Person | Day 1 | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 | Day 7 | Day 8 | Day 9 | Day 10 | Dinner $ | FIR | FIR $ Total | Lodging - Total | Food - Total | Incidentals |  | Participant | #people
 | [NAME] |  |  | 1 | 1
 | [NAME] | 1 | 1 | 1
 | Buddy | 1 | 1 | 1 | 1
 | [NAME] | 1 | 1 | 1
 | [NAME] | 1 | 1 | 1 | 1
 | Mark | 1 | 1 | 1 | 1
 | Lodging - Per Day PP
 | Food - Per Day PP
Spreadsheet: 107261d1304458967-car-mileage-expenses-expenses-register-april-2011-modified-
Sheet: Sheet1

Date | Purpose | Start | Finish | [NAME] |  | Category |  | CAVA | Parish | Diocese
 |  | 100 | 110 |  |  | CAVA
 |  | 110 | 111 |  |  | CAVA
 |  | 111 | 135 |  |  | Parish
 |  | 135 | 205 |  |  | Parish |  |  |  |  |  |  |  |  |  | CAVA
 |  | 205 | 220 |  |  | Diocese |  |  |  |  |  |  |  |  |  | Parish
 |  | 220 | 350 |  |  | Diocese |  |  |  |  |  |  |  |  |  | Diocese
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mileage Rate | 0.4
 |  |  |  |  |  |  |  | Claim | Parish
 |  |  |  |  |  |  |  |  | Diocese
 |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 143376d1330385158-excel-2007-finding-values-from-one-table-to-record-in-another-test-land-mix-5
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31
LAND MIX SUPPLEMENT
S 1/2 SW 1/4 1-19-4
 |  |  |  |  |  |  | SALE # | 1
SALE |  |  |  |  |  |  |  |  | SUBJECT
Category | Sale Ac |  |  | $Sale/Ac |  |  | $Total |  | Category | Subject Ac |  |  | $Value/Ac |  |  | $Total
Crop | 55 | Ac | x | 2250 | /Ac | = |  |  | Crop | 122.9 | Ac | x |  | /Ac | =
Pasture | 21.3 | Ac | x | 1500 | /Ac | = |  |  | Pasture | 20 | Ac | x |  | /Ac | =
Rds&wste | 3.7 | Ac | x |  | /Ac | = |  |  | Meadow | 10 | Ac | x | 1200 | /Ac | =
 |  | Ac | x |  | /Ac | = |  |  | Bldg site | 5 | Ac | x | 2000 | /Ac | =
 |  | Ac | x |  | /Ac | = |  |  | Rds&wste | 2.1 | Ac | x | 100 | /Ac | = | 210
TOTAL |  | Ac | x |  | /Ac | = |  |  | TOTAL |  | Ac | x |  | /Ac | =
LAND ADJUSTMENT SALE # |  |  |  |  |  |  |  | = |  | /Acre
 |  |  |  |  |  |  | SALE # | 2
SALE |  |  |  |  |  |  |  |  | SUBJECT
Category | Sale Ac |  |  | $Sale/Ac |  |  | $Total |  | Category | Subject Ac |  |  | $Value/Ac |  |  | $Total
Crop | 62 | Ac | x | 1875 | /Ac | = |  |  | Crop | 122.9 | Ac | x | 1875 | /Ac | =
Shltrblt | 12.8 | Ac | x | 750 | /Ac | = |  |  | Pasture | 20 | Ac | x | 1000 | /Ac | =
Bldg site | 3.4 | Ac | x | 1800 | /Ac | = |  |  | Meadow | 10 | Ac | x | 1000 | /Ac | =
Rds&wste | 1.8 | Ac | x | 100 | /Ac | = | 180 |  | Bldg site | 5 | Ac | x | 1800 | /Ac | =
 |  | Ac | x |  | /Ac | = |  |  | Rds&wste | 2.1 | Ac | x | 100 | /Ac | = | 210
TOTAL |  | Ac | x |  | /Ac | = |  |  | TOTAL |  | Ac | x |  | /Ac | =
LAND ADJUSTMENT SALE # |  |  |  |  |  |  |  | = |  | /Acre
 |  |  |  |  |  |  | SALE # | 3
SALE |  |  |  |  |  |  |  |  | SUBJECT
Category | Sale Ac |  |  | $Sale/Ac |  |  | $Total |  | Category | Subject Ac |  |  | $Value/Ac |  |  | $Total
Crop | 142 | Ac | x | 2100 | /Ac | = |  |  | Crop | 122.9 | Ac | x | 2100 | /Ac | =
Waterway | 3.6 | Ac | x | 500 | /Ac | = |  |  | Pasture | 20 | Ac | x | 950 | /Ac | =
Pasture | 10 | Ac | x | 950 | /Ac | = |  |  | Meadow | 10 | Ac | x | 750 | /Ac | =
Rd | 4.4 | Ac | x | 100 | /Ac | = | 440 |  | Bldg site | 5 | Ac | x | 2000 | /Ac | =
 |  | Ac | x |  | /Ac | = |  |  | Rds&wste | 2.1 | Ac | x | 100 | /Ac | = | 210
TOTAL |  | Ac | x |  | /Ac | = |  |  | TOTAL |  | Ac | x |  | /Ac | =
LAND ADJUSTMENT SALE # |  |  |  |  |  |  |  | = |  | /Acre
 |  |  |  |  |  |  | SALE # | 4
SALE |  |  |  |  |  |  |  |  | SUBJECT
Category | Sale Ac |  |  | $Sale/Ac |  |  | $Total |  | Category | Subject Ac |  |  | $Value/Ac |  |  | $Total
CRP | 120 | Ac | x | 1875 | /Ac | = |  |  | Crop | 122.9 | Ac | x | 2300 | /Ac | =
Crop | 27.8 | Ac | x | 2300 | /Ac | = |  |  | Pasture | 20 | Ac | x | 100 | /Ac | =
Shltrblt | 5.2 | Ac | x | 500 | /Ac | = |  |  | Meadow | 10 | Ac | x | 900 | /Ac | =
Waterway | 6.6 | Ac | x | 750 | /Ac | = |  |  | Bldg site | 5 | Ac | x | 2000 | /Ac | =
Rd | 0.4 | Ac | x | 100 | /Ac | = | 40 |  | Rds&wste | 2.1 | Ac | x | 100 | /Ac | = | 210
TOTAL |  | Ac | x |  | /Ac | = |  |  | TOTAL |  | Ac | x |  | /Ac | =
LAND ADJUSTMENT SALE # |  |  |  |  |  |  |  | = |  | /Acre
Spreadsheet: 839583d1692100091-cell-formatting-causing-vlookup-issues-lookup-fails
Sheet: Sheet3

 | 575020001 |  | 10042057
 | 575024035 |  | 57507001
 | 575024036 |  | 575010001
 | 575024402 |  | 575020001
 | 575030005 |  | 575024035
 | 575030006 |  | 575024036
 | 575030006 |  | 575024402
 | 575030015 |  | 575030005
 | 575030016 |  | 575030006
 | 575030018 |  | 575030006
 | 575030034 |  | 575030015
 | 575030035 |  | 575030016
 | 575030038 |  | 575030018
 | 575030042 |  | 575030034
 | 575030044 |  | 575030035
 | 575032002 |  | 575030038
 | 575032004 |  | 575030042
Spreadsheet: 760528d1640269526-improve-formula-to-check-for-dates-within-a-range-leave-sample
Sheet: StaffName

STAFF ANNUAL LEAVE CARD
Name: |  | Staff Name |  |  | Tuesday - Thursday
 |  |  |  |  | Friday
Site: |  | Site 1 |  |  | Saturday
Entitlement (hours): 1 Jan - 31 Dec |  | 0
Leave C/F (hours): |  | 0 | TOTAL LEAVE: |  | REMAINING:
Date From | Date To | No. of working hours | Type of Leave | Balance Due | Approved By | Date Approved
2022-01-03 00:00:00 | 2022-01-06 00:00:00 |  | Annual Leave
2022-01-22 00:00:00 | 2022-01-22 00:00:00 |  | Annual Leave
2022-01-14 00:00:00 | 2022-01-15 00:00:00 |  | Annual Leave
2022-01-29 00:00:00 | 2022-02-03 00:00:00 |  | Annual Leave
Spreadsheet: 725145d1616563999-how-can-i-limit-the-max-int-value-of-2nd-drop-down-box-based-on-int-value-of-first-drop
Sheet: Sheet1

 |  |  |  |  | OPTION 1 |  |  |  | OPTION 2
1 |  |  |  |  | Manual input |  |  |  | Pick value
 |  |  |  |  | Input 1 | 2 |  |  | Input 1 | 59
 |  |  |  |  | Input 2 | 98 |  |  | Input 2
Spreadsheet: 0bf2dd1a-3f7d-4a8d-a5ff-f3a0675cebb5
Sheet: Sheet1

OPERATING/PROGRAMMATIC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | 9056 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Approving contracts with various agencies in the total of $955,971.00 for events and projects
 | from the Neighborhood Tourist and Dvelopment Fund.
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  | x | No |  |  | Yes
 | If yes, please identify in  which Fund these revenues will be deposited (e.g. General, Sales Tax)
 | and provide the following revenue information:
 | Revenue Detail |  |  |  | FY 2011-2012 |  |  | FY 2011-2012
 | General Fund
 | Special Revenue
 | Enterprise
 |  |  | Total: | $ | 0 |  | $ | 0
 | (Please detail type of revenue (fees, grants, tax) and change that will occur as a result of this legislation.  Provide multi-year
 | estimates if known, or if grant revenue please identify source of funds (federal or state) and duration of grant support)
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  | X | No |  |  | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY 2011-11 |  |  | FY 2011-12
 | General Fund
 | Special Revenue |  |  |  | 0 |  |  | 0
 | Enterprise/Other
 |  |  | Total: | $ | 0 |  | $ | 0
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  | x | No |  |  | Yes
 | (Please detail estimate number of people to be served, who is delivering services currently to that population, service
 | performance expectations, and if grant supported, provisions for support if grant support ends.
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  | x | No |  |  | Yes
 | (If yes, please detail the purpose and source for that mandate).
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date
Spreadsheet: 128936d1321365577-grand-total-without-row-pivot-column-excel-2003-sample_pivot_data
Sheet: Pivot

 | Data
Agent | Top Surveys | Total Surveys | Top % | Grand Total Without Agent | Grand Total of All - Grand Total Without Agent (Could be positive or negative)
Agent 1 | 4 | 6 | 0.6666666666666666 | 0.4624 | 0.01230000000000003
Agent 10 | 6 | 10 | 0.6
Agent 2 | 5 | 11 | 0.4545454545454545
Agent 3 | 3 | 10 | 0.3
Agent 4 | 7 | 15 | 0.4666666666666667
Agent 5 | 5 | 9 | 0.5555555555555556
Agent 6 | 3 | 9 | 0.3333333333333333
Agent 7 | 5 | 8 | 0.625
Agent 8 | 4 | 9 | 0.4444444444444444
Agent 9 | 5 | 12 | 0.4166666666666667
Grand Total | 47 | 99 | 0.4747474747474748
Top % = Top Surveys/Total Surveys
Spreadsheet: 194033d1353014829-change-multiple-rows-to-multiple-columns-with-one-row-data-example
Sheet: Needs to be formatted to

Clock | Employee Last Name | Employee First Name | SSN | Date of Birth | Gender | Job Title | Street 1 | Street 2 | City | State | Zip Code | ADD | Base Life | Short term disability | Long Term Disability | EE Life | Spouse Life | Child Life
0001 | Doe | [NAME] | 111-11-1111 | 1901-01-01 00:00:00 | M | Employee I | 123 Main St |  | Normal | IL | 61761 | 50000 | 50000 | 1102 | 4000 | 90000 | 30000 | 15000
0002 | Doe | [NAME] | 999-99-9999 | 1902-01-01 00:00:00 | M | Manager | 124 Veterans Parkway |  | Normal | IL | 61761 | 50000 | 50000 | 12000 | 5000 | 500000
Spreadsheet: 804667d1668205058-if-statment-help-testn
Sheet: Data Events

ANLYS_EVNT_ID | evnt_fscl_yr | EVNT_NM | Short_Name | PROD_LVL_NBR | SKU_DESC | SVP_DESC | SUB_DEPT_NBR | SUB_DEPT_DESC | CLASS_NBR | CLASS_DESC | Avg_Normal_Price | Avg_Sale_Price | Gross_Sales | Gross_Units | Markdown | Discount_Percent | Quarter | Discount | YEAR | UI |  | PP |  |  |  |  |  | Quartile 1
 |  |  |  |  |  |  |  |  |  |  | 11.5462149783906 | 6.39829828587845 |  | 96726 |  | 0.44585318237594 |  |  | 2018 | SPRING PHASE I |  |  |  |  |  |  |  | Quartile 2
 |  |  |  |  |  |  |  |  |  |  | 8.90329264582881 | 5.861841394783 |  | 52596 |  | 0.341609713623277 |  |  | 2018 | SPRING PHASE I |  |  | Price Category | Price Point |  |  |  | Quartile 3
 |  |  |  |  |  |  |  |  |  |  | 8.84220942961598 | 5.95277664112201 |  | 132455 |  | 0.32677723950036 |  |  | 2018 | SPRING PHASE I |  |  | 1 | 5 |  |  |  | Quartile 4
 |  |  |  |  |  |  |  |  |  |  | 19.813929297499 | 14.883022895532 |  | 469262 |  | 0.248860603463914 |  |  | 2018 | SPRING PHASE I |  |  | 2 | 7
 |  |  |  |  |  |  |  |  |  |  | 8.44934411287507 | 6.55033961025909 |  | 54857 |  | 0.224751705842147 |  |  | 2018 | SPRING PHASE I |  |  | 3 | 40
 |  |  |  |  |  |  |  |  |  |  | 6.92769023784126 | 456 |  | 212576 |  | 0.215115154700882 |  |  | 2018 | SPRING PHASE I |  |  | 4 | 100
 |  |  |  |  |  |  |  |  |  |  | 12.9850703758901 | 45 |  | 24156 |  | 0.193468647805751 |  |  | 2018 | SPRING PHASE I
 |  |  |  |  |  |  |  |  |  |  | 9.54078766610225 | 25 |  | 46733 |  | 0.14811946263307 |  |  | 2018 | SPRING PHASE I
Spreadsheet: 53024d1252941988-vlookup-or-hloookup-or-other-valuestreamproductlist
Sheet: Sheet2

SDC | DES | POBA | SES | PTA | PCT | MCT | R&D
Taxus Liberte | Taxus Express | Maverick | [NAME] | Blue Max 20/New Bluemax - BMQ | Magic | Express | [NAME]
Liberte Bare | Taxus Express II | Viva | Smash | UT Diamond - UDT | [NAME] | Liberte
Promus Element |  | Apex | Gazelle | Uromax Ultra Balloon/ U2Q | Flamingo | Element
 |  |  |  | UT Diamond Glidex - DG
 |  |  |  | XXL Balloon Catheter - XXL
 |  |  |  | Nephromax/Kits
 |  |  |  | [NAME]
 |  |  |  | UTSDS
 |  |  |  | Synergy
 |  |  |  | Express LD Vascular/Billary
 |  |  |  | Symmetry
 |  |  |  | Maxforce TTS - MFTTS
 |  |  |  | Passport
Spreadsheet: 847554d1698417615-gather-information-across-multiple-sheets-where-the-info-may-be-in-different-cells-sample-workbook-2-
Sheet: SUMMARY

 | SO# | INSTALL DATE | MODEL | SERIAL NUMBER
sheet1
sheet2