tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 6ed513ca-54da-49c5-b50d-9b252c2f759f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
２４　地方入国管理局管内別　在留資格認定証明書交付申請の受理及び処理人員
 | 地方入国 |  | 受理 |  |  | 既済 |  |  |  | 未済
 | [NAME] |  | 総数 | 旧受 | 新受 | 総数 | 交付 | 不交付 | その他
総数 |  |  | 288616 | 45555 | 243061 | 248523 | 214462 | 29689 | 4372 | 40093
札幌 |  |  | 6226 | 962 | 5264 | 5257 | 4785 | 419 | 53 | 969
仙台 |  |  | 8861 | 1224 | 7637 | 7781 | 6309 | 1339 | 133 | 1080
東京管内 |  |  | 152373 | 26096 | 126277 | 132719 | 114078 | 17084 | 1557 | 19654
 | 東京 |  | 137302 | 24377 | 112925 | 119610 | 104041 | 14129 | 1440 | 17692
 | 横浜 |  | 12246 | 1391 | 10855 | 10422 | 8552 | 1773 | 97 | 1824
 | さいたま |  | 2825 | 328 | 2497 | 2687 | 1485 | 1182 | 20 | 138
名古屋 |  |  | 43874 | 5942 | 37932 | 36815 | 31337 | 5076 | 402 | 7059
大阪管内 |  |  | 35082 | 5272 | 29810 | 29877 | 26028 | 2470 | 1379 | 5205
 | 大阪 |  | 22362 | 3325 | 19037 | 19017 | 16113 | 1645 | 1259 | 3345
 | 神戸 |  | 7018 | 1114 | 5904 | 6034 | 5359 | 617 | 58 | 984
 | 京都 |  | 5702 | 833 | 4869 | 4826 | 4556 | 208 | 62 | 876
広島管内 |  |  | 13969 | 1660 | 12309 | 12323 | 10782 | 1277 | 264 | 1646
 | 広島 |  | 12805 | 1465 | 11340 | 11188 | 9900 | 1079 | 209 | 1617
 | 下関 |  | 1164 | 195 | 969 | 1135 | 882 | 198 | 55 | 29
高松 |  |  | 6587 | 993 | 5594 | 5433 | 5162 | 201 | 70 | 1154
福岡管内 |  |  | 21644 | 3406 | 18238 | 18318 | 15981 | 1823 | 514 | 3326
 | 福岡 |  | 18614 | 2918 | 15696 | 15742 | 13633 | 1644 | 465 | 2872
 | 那覇 |  | 1075 | 125 | 950 | 981 | 885 | 82 | 14 | 94
 | 鹿児島 |  | 1955 | 363 | 1592 | 1595 | 1463 | 97 | 35 | 360
Spreadsheet: joe_parks__14750__ITM Phy 04 Positions
Sheet: Run Query

Daily Hedge Strip
User ID:
Password:
Included Deals | ALL
Today
Days in Month | 31
Day of Month |  |  | Update this cell daily.
PromptMonth | 2002-04-01 00:00:00 | 2002-04-30 00:00:00
StartRange | D4
Enter NYMEX Date:
[NAME] | NXB2 | NX1
2002-03-22 00:00:00 | 2002-03-25 00:00:00 | 2002-03-26 00:00:00
 | Update this cell daily.
Password: | Current Post Id's | Prior Post Id's
Date |  | Column | # | Name | Type | Book Type | Book
Post Ids | 1498407 | 22 | 1 | Price |  | P | ENA-FT-WC-SOCAL-PRC
 | 1498408 | 23 |  | Basis | Basis | D | ENA-FT-WC-SOCAL-BAS
 | 1498409 | 24 |  | Index |  | I | ENA-FT-WC-SOCAL-IDX
 | 1498411 | 28 |  | Gas Daily | [NAME] | M | ENA-FT-WC-SOCAL-GDL
 | 1498412 | 30 |  | GDY | GD Index | Y | ENA-FT-WC-SOCAL-GDI
 | 0 | 7 |  | Physical |  | PHY | ENA-IM-WT-SOCAL-PHY
 | 0 | 15 |  | Price |  | P | FT-WEST-OPT-PRC
 | 0 | 16 | 8 | Basis | Basis | D | FT-WEST-OPT-BAS
 | 0 | 17 | 9 | GDL | [NAME] | M | ENA-FT-WT-SCAN-GDL
 |  |  |  |  |  | PO | FT-WE-XL-OPT-PRC
 |  |  |  |  |  | DO | FT-WE-XL-OPT-BAS
Spreadsheet: 163341d1340281120-transfer-value-from-one-sheet-to-another-where-two-fileds-in-both-are-equal-book1
Sheet: Product3

Date | WO | SO | Line | Product | Customer | Qty
2012-06-21 00:00:00 |  | 10003 | 1 | Prod3 | [NAME] | 5
2012-06-21 00:00:00 |  | 10004 | 1 | Prod3 | [NAME] | 2
2012-06-21 00:00:00 |  | 10004 | 2 | Prod3 | [NAME] | 1
Spreadsheet: louise_kitchen__24216__PR 2002 Plan 091301
Sheet: 01 vs 02

 | E N R O N   N O R T H  A M E R I C A
 | 2 0 0 2   P L A N vs 2 0 0 1 P L A N
 | SAP PROFIT CENTER:
 | PROFIT CENTER OWNER:
 | DEPARTMENT:
 | HEADCOUNT SUMMARY | 2001-01-01 00:00:00 | July hdct | 02 Budget | [NAME]
 | President/CEO |  | 0 | 0
 | Managing Director | 1 | 0 | 0
 | Vice President | 1 | 0 | 0
 | Director | 1 | 1 | 1
 | Manager | 1 | 2 | 3
 | Sr. Specialist | 1 | 2 | 1
 | Specialist | 1 | 3 | 3
 | Real Time Traders | 1 | 0 | 0
 | Administrative Assistants |  | 2 | 2
 | Technical |  | 0 | 0
 | Other |  | 0 | 0
 | Subtotal Headcount
 | Associates |  | 0 | 0
 | Analysts |  | 0 | 0
 | TOTAL HEADCOUNT
SAP COST
ELEMENT | DIRECT EXPENSES |  | 01 Budget | 02 Budget | [NAME]
52000500 | Salaries & Wages |  | 600000
52000500 | Special Pays |  | 0
 | Subtotal Compensation
52001000 | Benefits |  | 98700
59003000 | Payroll Taxes |  | 54000
 | Subtotal Benefits and Payroll Taxes
52003000 | Conferences & Training |  | 0
 | Club Dues |  | 0
52004000 | Employee Memberships & Dues |  | 600
52003000 | Overtime/Working Meals |  | 525000
52503500 | Communications Expense |  | 12000
52004500 | Tuition Reimbursement |  | 0
52002000 | Employee Entertainment |  | 0
52002500 | Other Employee Expenses |  | 124000
 | Subtotal Employee Expenses
 | Travel - Air |  | 0
 | Travel - Lodging |  | 0
 | Travel - Meals |  | 0
 | Travel - Other |  | 54000
 | Client Entertainment |  | 0
 | Customer Meetings |  | 0
 | Subtotal Travel & Entertainment
54005000 | Recruiting |  | 0
 | Relocation Expenses |  | 0
 | Subtotal Recruiting & Relocations
52508000 | Outside Services - Legal |  | 0
52507500 | Outside Services - Audit |  | 0
52508000 | Outside Services - Tax |  | 0
 | Outside Services - IT |  | 0
 | Outside Services - Professional |  | 169000
 | Outside Services - Engineering |  | 0
 | Outside Services - Accounting |  | 0
 | Outside Services - Other |  | 0
 | Subtotal Outside Services
52508500 | Subscriptions & Periodicals |  | 7200
52508100 | Postage & Freight Expense |  | 3000
53600000 | Office Supplies |  | 29100
 | Subtotal Office Supplies
53801000 | Rent - Office, Warehouse, & Tower |  | 0
53800000 | Equipment Rental |  | 1800
 | Subtotal Rent (3rd Party)
52500500 | Advertising & Promotions |  | 435000
52003500 | Charitable Contributions |  | 24000
54000000 | Transportation |  | 0
52502500 | Corporate Rent |  | 325000
54005000 | Analysts and Associates |  | 0
54005000 | Outside Legal |  | 0
54005000 | Outside Tax |  | 0
52004500 | Insurance |  | 0
52504500 | Technology |  | 12000
54005000 | System Development |  | 0
52502000 | Corporate IT |  | 0
52004500 | Controllable Infrastructure |  | 12000
 | Subtotal Controllable Infrastructure
54005000 | Other Expenses
 | Company Membership & Dues |  | 0
 | Subtotal Other
57200000 | Depreciation |  | 0
57000000 | Amortization |  | 0
 | Subtotal Noncash Expenses
59099900 | Taxes Other than Income |  | 0
 | TOTAL DIRECT EXPENSES
Spreadsheet: 468714d1467474048-graph-formula-excelforum
Sheet: Sheet10

 |  |  | y=26x-x2
1 | 25
2 | 48
3 | 69
4 | 88
5 | 105
6 | 120
7 | 133
8 | 144
9 | 153
10 | 160
11 | 165
Spreadsheet: 847919d1698761754-expense-amortization-calculation-while-adding-expenses-over-time-tucker-customs
Sheet: Excel Amortization Schedule

 | MORTGAGE AMORTIZATION SCHEDULE
 |  | ENTER VALUES |  |  |  | LOAN SUMMARY
 |  | Loan amount |  |  |  | Scheduled payment
 |  | Interest rate |  | 0.075 |  | Scheduled number of payments
 |  | Loan term in years |  | 5 |  | Actual number of payments
 |  | Payments made per year |  | 12 |  | Years saved off original loan term
 |  | Loan repayment start date |  | 2023-11-01 00:00:00 |  | Total early payments
 |  |  |  |  |  | Total interest
 |  | Optional extra payments |  | 0 |  | LENDER NAME | Your Bank
 | PMT NO | PAYMENT DATE | BEGINNING BALANCE | SCHEDULED PAYMENT | EXTRA PAYMENT (+) OR 'EXTRA EXPENSE (-) | TOTAL PAYMENT | PRINCIPAL | INTEREST | ENDING BALANCE | CUMULATIVE INTEREST
Spreadsheet: 11f603ba-2ed4-43d5-b05b-4c22fd98e8d1
Sheet: Sheet1

Name | 2014-04-09 00:00:00 | 2014-04-23 00:00:00
Aponte, Juan
Bettis, Sharda
Bubb, [NAME]
[NAME], Aida
[NAME], [NAME]
Mauschbaugh, [NAME]
Mauschbaugh, Zach
McReynolsd, Blake
Wilson, [NAME] (replacement^)
Pippin, Tyler
Porter, [NAME]
Rhodes, [NAME]
[NAME], [NAME]
Walker, Kandace
[NAME], [NAME]
Dobbs, [NAME]
Hilkey, Julia
[NAME], Ava
[NAME], [NAME]
[NAME], [NAME]
Ebelhar, [NAME]
[NAME], Grant
Hobbs, [NAME]
[NAME], [NAME]
Horton, [NAME]
Isbell, [NAME]
[NAME], [NAME]
[NAME], [NAME]
Price, [NAME]
Survant, [NAME]
[NAME], Samantha
Stoll, Memory (replacement^) |  | x
[NAME], Samantha
Benson, [NAME] |  | x
[NAME], [NAME]
Bloodworth, Alexandra | x
Bourne, [NAME]
Bowles, Christian | x | x
Brennan, Rebecca
Brooks, Kaitlyn
Buskey, Emily
[NAME], Katheryn (replacement^) | x | x
Coughlin, [NAME]
Haner, [NAME] (replacement^)
Dunaway, [NAME]
[NAME], [NAME] | x | x
Easterling, [NAME]
Franklin, [NAME]
Futrell, [NAME] | x
[NAME], [NAME]
[NAME], [NAME] | x | x
Haner, [NAME]
Hartley, Kayla | x
Hooks, [NAME]
Johnston, [NAME]
King, [NAME] | x
Koechner, [NAME] | x
Leach, Danice | x | x
MacAllister, Shannon
Lewis, [NAME] (replacement^) | x | x
Madewell, [NAME] | x | x
Mathis, [NAME] | x | x
[NAME], [NAME]
Mitchem, Shannon (Replacement^)
Pille, Sara (replacement^) | x | x
McNichols, Nathan
Mills, Tommy
[NAME] (Replacement^) | x
Murphy, Sean
Myers, [NAME] |  | x
Nucklolls, [NAME]
Oldham, Tyler |  | x
Payne, Nathan | x
[NAME], Tiffany | x
Plunkett, [NAME]
Powers, Lindsey | x | x
Reed, [NAME] | x
[NAME], Ashely | x | x
Scaturro, Chelsea
Schloss, [NAME] | x | x
Shaughnessy, [NAME]
Smith, [NAME] | x | x
Straney, [NAME]
Tanksley, Brandon
Parker, Blake (replacement^)
[NAME], [NAME] | x | x
White, Sierra | x | x
Morgan, [NAME]
Spreadsheet: 672664d1586954707-formula-converting-hours-into-working-days-showing-error-with-specific-number-of-hours-formula_example
Sheet: Configuration

 |  |  | Leave Card Configuration
 |  |  |  |  |  |  |  | hr:min | decimal
 |  |  | Name |  |  | Standard day length |  | 7:24:00
 |  |  |  |  |  |  |  |  |  |  |  |  | Time Calculator
 |  |  | Section |  |  | Leave entitlement |  | 7 days, 17:00:00 |  |  |  |  | 1 days leave
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 days leave
 |  |  | Team |  |  | Leave start date |  |  |  |  |  |  | 3 days leave
 |  |  |  |  |  |  |  |  |  |  |  |  | 4 days leave
 |  |  | Service |  |  | Leave end date |  |  |  |  |  |  | 5 days leave
 |  |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  | Directorate |  |  | Leave carried forward |  |  |  |  |  |  | Time Converter
 |  |  |  |  |  | From previous sheet |  |  |  |  |  |  | Days to hours
 |  |  | CONFIGURATION |  |  |  |  |  |  |  |  |  | Days |  | Hours
 |  |  | Before first use, enter your name and select details of your service area, etc. Enter the length of your working day in the format hh:[NAME] |  |  |  |  |  |  |  |  |  | 25 | =
 |  |  | For full time employees this will usually be 7:24, but may vary for those who work part time. The Time Calculator and Time Converter
 |  |  | on the right will calculate and convert between hours and working days for you (this is why you need to enter the length of your work
 |  |  | day on this page). |  |  |  |  |  |  |  |  |  | Hours to days
 |  |  | Hover over the boxes for more information on their purpose and the format to enter information in. |  |  |  |  |  |  |  |  |  | Hours |  | Days
 |  |  |  |  |  |  |  |  |  |  |  |  | 7 days, 19:00:00 | =
 |  |  |  |  |  |  |  |  |  |  |  |  | NB: You MUST enter the length of your work day on this page for the Time Calculator and Time Converter to work, otherwise they will have no idea of the length of your work day and will display 0!
Spreadsheet: 759747d1639698382-error-trapping-if-and-multiple-cells-must-all-have-error-sample-12-1-1-
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  |  |  |  |  |  |  |  |  | IF(SUMPRODUCT(--(ISNA(A4:H4)))=8,"ERROR","")
5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 |  |  | row works with all values
5 | 5 | 5 | 5 | 5 |  | 5 | 5 |  |  | row works with values and errors
 |  |  |  |  | asdf | 5 |  |  |  | row works with values, errors and blanks
 |  |  |  |  |  |  |  |  |  | row works with all errors
 |  |  |  |  |  |  |  |  |  | row does not work with errors and blanks
 |  |  |  |  |  |  |  |  |  | IF(ISERROR(IF(TEXTJOIN(,TRUE,A14:H14)/1=0,"",""))=FALSE,"ERROR","")
asdf | asdf | asdf | asdf | asdf | asdf | asdf | asdf |  |  | row works with all values
asdf | asdf | asdf | af | adf | 0 | asdf | asdf |  |  | row works with values and errors
0 | 0 | 0 | 0 | 0 | 0 | asdf |  |  |  | row works with values, errors and blanks
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | row works with all errors
0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | row does not work with errors and blanks
0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 |  |  | this wouldn't work with all #'s, but that'll never happen in our scenario
Spreadsheet: 681431d1591568431-flagging-matching-unmatching-customer-date-of-births-field-i-want-2-
Sheet: Sheet1

Cust Number | DOB | DOB Check
0010002R | 1942-07-11 00:00:00 | 0
0010002R | 1942-07-11 00:00:00 | 0
0010002R | 1943-07-11 00:00:00 | 0
0010002R | 1942-08-11 00:00:00 | 0
0050002M | 2000-04-08 00:00:00 | 1
0050002M | 2000-04-08 00:00:00 | 1
0030007T | 1973-03-10 00:00:00 | 0
0030007T | 1974-03-10 00:00:00 | 0
0060007D | 1959-03-11 00:00:00 | 0
Spreadsheet: 58823d1259083472-excel-2007-how-to-add-items-to-a-dropdown-list-dynamically-by-typing-in-the-dropdown-list-cell-tanf_-_requirement_gathering_template_-final-
Sheet: Reactivation

 |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name | Case Management (Undercare)
Activity Name | Reactivation
Activity Description / Purpose | The process of re-establishing eligibility for an erroneously closed or discontinued case.
 |  |  | Activity Predecessor | Activity [NAME] | Activity Input | Activity Output | Activity Successors
Steps | Tasks A task is any action that is being performed to complete a step | What unit does this? (SU) | Who does this? (W) | Applications used / System Interfaces / Tools Is there an automated system supporting the activity? | What happens before this? (P) | What causes the activity to happen (T) | Additional Information that is needed (I) | Is anything produced? (O) | What happens next ? (S) | V | Comments |  |  |  | Questions | Workarounds | Constraints/ Issues | Opportunities | Policy Considerations | Best Practices | Follow-Up | Comments
Complete full data entry into WMS
Write payment lines
Correct 'fatal' errors
Process eligibility in WMS
Accounting | Case Closure
Add Program/Person | Case Management (Undercare)
AFIS | Caseload Management
Agency Conference | Client Services/Benefits Delivery
Application Registration | Eligibility Determination
Authorization | Fair-Hearings & Appeals
[NAME] | Intake
Budget | Referrals
Case Assignment | Screening
Case Closure | Verification
Case Review
[NAME]
CBIC
Change
Clearance
Data Entry
DV-D-A Screen
Emergency Benefits
Expedited
Hearings
Interview
Investigation
Managed Care
Mass Changes
Monitor Activities
Notice
[NAME]
Plan Review
Pre-Screening
Reactivation
Reception
Records Management
Recoupment-Supplemental
Re-Determination-Renewal-Recert
Referral
Sanctions
Service Plan
Verify
Vouchers
Withdraw Application
Other
Spreadsheet: 49724d1249045310-check-all-fire_extinguisher_mstr_test_ron
Sheet: Sheet3

 |  | January |  | 2009 | 1 | 1
5lb |  | February |  | 2010 | 2 | 2
10lb |  | March |  | 2011 | 3 | 3
15lb |  | April |  | 2012 | 4 | 4
20lb |  | May |  | 2013 | 5 | 5
 |  | June |  | 2014 | 6 | 6
 |  | July |  | 2015 | 7 | 7
 |  | August |  | 2016 | 8 | 8
 |  | September |  | 2017 | 9 | 9
 |  | October |  | 2018 | 10 | 10
 |  | November |  | 2019 | 11 | 11 |  | Name
 |  | December |  | 2020 | 12 | 12 |  | Name
 |  |  |  | 2021 | 13 | 13 |  | Name
 |  |  |  | 2022 | 14 | 14 |  | Name
 |  |  |  | 2023 | 15 | 15 |  | Name
 |  |  |  | 2024 | 16 | 16 |  | Empty
 |  |  |  | 2025 | 17 | 17 |  | Empty
 |  |  |  |  | 18 | 18 |  | Empty
 |  |  |  |  | 19 | 19
 |  |  |  |  | 20 | 20
 |  |  |  |  | 21 | 21
 |  |  |  |  | 22 | 22
 |  |  |  |  | 23 | 23
 |  |  |  |  | 24 | 24
 |  |  |  |  | 25 | 25
 |  |  |  |  | 26 | 26
 |  |  |  |  | 27 | 27
 |  |  |  |  | 28 | 28
 |  |  |  |  | 29 | 29
 |  |  |  |  | 30 | 30
 |  |  |  |  | 31 | 31
Spreadsheet: 97d260f1-e9f0-4f00-99a8-a2db9f848575
Sheet: Sheet1

Gæsteliste - frokost Gammel Estrup | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Statsforvaltningsdirektør, stiftamtmand | Torben Sørensen | [NAME]
Regionsrådsformand | [NAME] | Region Midtjylland | [NAME]
Politidirektør | [NAME] | [NAME] | Bente Ilum
Biskop | [NAME] | Stiftskontoret | Birthe Elgaard Holm
Provst | Anders Holt | Provstikontoret, [NAME] | Else Holt
Retspræsident | [NAME] | [NAME] | [NAME]
Chefen for totalforsvarsregion Midtjylland, oberst | [NAME] | Skive Kaserne | [NAME]
Chefen for beredskabsstyrelsen Midtjylland, kolonnechef | [NAME] |  | [NAME]
Kommunaldirektør | [NAME] | [NAME] | [NAME]
Sekretariatschef | [NAME] | [NAME] | [NAME]
Borgmester | [NAME] | [NAME] | [NAME]
Viceborgmester | Torben Jensen |  | [NAME]
Formand for kultur- og udviklingsudvalget | [NAME]
Formand for voksen- og plejeudvalget | [NAME]
Formand for arbejdsmarkedsudvalget | [NAME] [NAME]
Kommunalbestyrelsesmedlem | [NAME]
Kommunalbestyrelsesmedlem | [NAME]
Kommunalbestyrelsesmedlem | Else Søjmark
Kommunalbestyrelsesmedlem | Pia Bjerregaard
Kommunalbestyrelsesmedlem | [NAME]
Kommunalbestyrelsesmedlem | [NAME]
Kommunalbestyrelsesmedlem | [NAME]
Formand for børne og ungdomsudvalget | [NAME]
Kommunalbestyrelsesmedlem | [NAME]
Kommunalbestyrelsesmedlem | [NAME]
Kommunalbestyrelsesmedlem | [NAME] Jensen
Kommunalbestyrelsesmedlem | [NAME]
Kommunalbestyrelsesmedlem | Berit [NAME]
Kommunalbestyrelsesmedlem | [NAME]
Kommunalbestyrelsesmedlem | [NAME]
Kommunalbestyrelsesmedlem | [NAME]
Kommunalbestyrelsesmedlem | [NAME]
Kommunalbestyrelsesmedlem | [NAME]
Formand for miljø og teknikudvalget | [NAME]
Kommunalbestyrelsesmedlem | Lars Sørensen
Kommunalbestyrelsesmedlem | [NAME]
Kommunalbestyrelsesmedlem | [NAME]
Havnedirektør | [NAME] | [NAME] | Anne Dorte [NAME]
Formand for havnebestyrelsen [NAME] | [NAME] | [NAME] | [NAME]
Formand | [NAME] | [NAME]
Formand | [NAME] | Auning Handelscenter
Formand | [NAME] | [NAME]
Næstformand | [NAME] | [NAME] Norddjurs
Formand | [NAME] | Djurslands Landboforening
Chefen for Gardehusarregimentet, oberst | [NAME] | [NAME]
Økonomidirektør | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
Servicedirektør | Anders [NAME] | [NAME]
Kommunikationsmedarbejder | Mathilde [NAME] | [NAME]
Fuldmægtig | [NAME] | [NAME]
Fuldmægtig | [NAME] | [NAME]
Fuldmægtig | [NAME] | [NAME]
Fuldmægtig | [NAME] | [NAME]
Vej- og parkchef | [NAME] | [NAME]
Museumsdirektør | [NAME] | Gammel Estrup Herregårdsmuseum
Museumsdirektør | [NAME] | [NAME]
Rektor | [NAME] | [NAME]
Forstander | Lars Ry Jørgensen | Viden Djurs
Spreadsheet: 163083d1340188755-changing-a-formula-in-a-cell-by-entering-a-number-in-another-cell-is-it-possible-0rhrp-demo
Sheet: RHRP

Right Hours Right Place |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.379
 | 0800-1300 |  |  | 1300-1700 |  |  | 1700-2200 |  |  | 2200-0800 |  |  |  | Totals |  |  |  | 0.485
 | Scheduled Hours | Optimum Hours | [NAME] | Scheduled Hours | Optimum Hours | [NAME] | Scheduled Hours | Optimum Hours | [NAME] | Scheduled Hours | Optimum Hours | [NAME] |  | Total Hours | Total Variance |  |  | 0.56
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Total
 | Total Scheduled Hours
 | Total Optimum Hours
 | [NAME]
 | 0800-1300 |  |  | 1300-1700 |  |  | 1700-2200 |  |  | 2200-0800
Ideal Split | 0.43 |  |  | 0.04 |  |  | 0.04 |  |  | 0.49
Actual Split
 |  | look here in CF rules.
Spreadsheet: darrell_schoolcraft__7325__imball0202
Sheet: Dominion

 | Dominion Gas Ventures
 | POI 12354 - Dominion Gas/Tule Lake
Day | Measured | Scheduled
1 |  | 150
2 | 309 | 150
3 | 285 | 150
4 | 252 | 150
5 | 300 | 150
6 | 31 | 150
7 | 4 | 150
8 | 303 | 150
9 | 289 | 150
10 | 146 | 150
11 | 52 | 150
12 | 315 | 150
13 | 201 | 150
14 | 186 | 150
15 | 164 | 150
16 | 142 | 150
17 | 227 | 150
18 | 197 | 150
19 | 226 | 150
20 | 242 | 150
21 | 264 | 150
22 | 25 | 150
23 | 180 | 150
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | 174593.14
2002-02-23 00:00:00
CBS Volume
 |  |  | 76390
Spreadsheet: 61097d1261724941-conditional-formatting-highlight-conditionalformat
Sheet: Sheet1

 | Name | Time
Colleagues | [NAME] | 0.01
 | OFFY | 0.05
 | IMPAC | 0.02
 | VBL | 0.8
 | Subtotal | 0.88
Close friends | Home | 0.02
 | College | 0.5
 | Social | 0.25
 | Subtotal | 0.77
Spreadsheet: 1acbc5b5-eba7-43ce-aba6-394b78c6d600
Sheet: ECON

 | PROGRAM LEVEL | # | SLOs | # | ASSESSMENT METHOD DEFINED | # | ASSESSED COURSE | # | DISCUSSION/ IMPROVEMENT | #
 | A.A. Degree Economics | 1 | X | 1 | X | 1 | X | 1 | X | 1
 | TOTAL
 | PERCENTAGE
 | COURSE
1 | ECON 100 | 1 | X | 1 | X | 1 | 2 | 1 | 2 | 1
1 | ECON 200 | 1 | X | 1 | X | 1 | 2 | 1 | 1 | 1
1 | ECON 201 | 1 | X | 1 | X | 1 | 2 | 1 | 1 | 1
 | TOTAL
 | PERCENTAGE
Spreadsheet: 162784d1340060664-copy-of-managers-clients-info-from-master-list-database-example
Sheet: Pivot Table TFA

Row Labels | Count of Name
Emergency Supplies | 3
1 | 2
American Mail and Parcel | 1
Verizon | 1
2 | 1
Anne Murphy Reimbursement | 1
Moving Costs | 2
3 | 2
Public Storage | 1
Public Storage Inc. #22326 | 1
Rent/Fee | 86
1 | 62
American Gold Star Manor | 4
[NAME] | 1
[NAME] | 1
[NAME] | 1
Baltimore Hotel | 1
[NAME] | 1
Buenaventura Reyes | 1
Cloudbreak Inglewood LLC | 7
[NAME] | 1
[NAME] | 3
ECL One, LP | 3
[NAME] | 1
Fred Leeds Property Management | 1
Graziano Family Trust | 1
[NAME] | 1
Hagai Payes | 1
Infinity Partners Group | 2
[NAME] | 2
[NAME] | 1
[NAME] | 2
Marlborough Apartments, LLC | 3
[NAME] | 4
[NAME] | 1
[NAME] | 1
[NAME], LLC | 1
Studio Point Apartments | 1
Superior Place | 1
Superior Place, LP | 1
[NAME], LP | 4
[NAME] | 2
Verte & Co., LLC | 2
Vineland Properties, LLC | 1
Woodgreen Apartments | 4
2 | 14
20NM, LLC | 1
Ardiem, Inc | 1
Cloudbreak Inglewood LLC | 7
Mario and [NAME] | 1
Unity Income Investment Ltd. | 1
Ventura Terrace | 1
[NAME], LLC | 1
Whispering Fountains at Lakewood | 1
3 | 10
Archstone | 2
Cloudbreak Inglewood LLC | 1
Coki, LLC | 2
Ming Tree Apartments | 5
Security Deposit | 84
1 | 6
American Gold Star Manor | 1
[NAME] | 1
[NAME], LP | 1
Infinity Partners Group | 1
[NAME] and [NAME] | 1
[NAME] | 1
2 | 71
1000 East Acacia, LLC | 1
20NM, LLC | 1
5460-5470 San Vicente Blvd, LLC | 1
5525 [NAME], LLC | 2
941 S. Grandview LLC | 2
AJK Investments, Inc | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 2
Cloudbreak Inglewood LLC | 5
Curtis Phillips | 1
[NAME] | 2
Downey West Investors, LLC | 2
[NAME] | 4
[NAME] | 2
Forward Progress Management Real Estate Fund III, LLC | 1
Golden Estate Management, Inc. | 1
[NAME] and [NAME] | 1
[NAME] | 1
LA Harvard Property, LLC | 3
Lockwood Investors, LLC | 3
[NAME] | 1
[NAME] | 1
[NAME] | 1
Manhattan Place Partnership | 1
Mario and [NAME] | 1
[NAME] | 2
[NAME], LLC | 1
Mojen Investments, LLC | 1
[NAME] | 1
[NAME] | 1
[NAME] | 2
[NAME] | 1
Santa Rosalia Court Apts | 2
[NAME] | 2
Unity Income Investment Ltd. | 2
Vanowen Ltd., LLC | 1
Ventura Terrace | 3
[NAME], LLC | 1
Warner Garden Apts., LLC | 2
Watson | 1
Wellman Property Mgmt | 1
[NAME] | 1
(blank) | 1
3 | 7
Archstone | 1
Cloudbreak Inglewood LLC | 2
Coki, LLC | 1
Ming Tree Apartments | 1
[NAME] | 1
[NAME] | 1
Transportation | 1
1 | 1
Anne Murphy Reimbursement | 1
Utility Deposit | 9
1 | 1
LADWP | 1
2 | 7
LADWP | 6
The Gas Company | 1
3 | 1
Southern California Edison | 1
Utility/Fee | 13
1 | 13
LADWP | 7
Southern California Edison | 1
The Gas Company | 5
Grand Total | 198
Spreadsheet: 32980d1229172620-summary-of-cells-on-main-sheet-summary
Sheet: Sheet1

4 Digit | 1 | 2 | 3 | 4
 | - | - | - | -
 | - | - | - | -
 | - | - | - | -
D6543 | 1 | X | 2 | X
 | - | - | - | -
 | - | - | - | -
 | - | - | - | -
F6541F | 2 | 2 | X | X
 | - | - | - | -
 | - | - | - | -
 | - | - | - | -
 | - | - | - | -
 | - | - | - | -
 | - | - | - | -
 | - | - | - | -
 | - | - | - | -
Spreadsheet: 889039d1739714474-rank-top-x-values-in-target-table-based-on-multiple-criteria-excel-rank-example
Sheet: Sheet1

SOURCE TABLE
ID | Criteria1 | Criteria2 | Criteria3 | Value
1234 | A1 | P1 | SegA | 1000
2341 | A1 | P3 | SegA | 25 | <== should appear in target table based on criteria 1-3
3411 | A3 | P4 | SegB | 75
1155 | A1 | P3 | SegA | 250 | <== should appear in target table based on criteria 1-3
2367 | A4 | P1 | SegB | 400
7891 | A1 | P1 | SegC | 33
Criteria
Criteria1: | A1
Criteria2: | P3
Criteria3: | SegA
Top | 3 | <== preferably dynamic, so could also be 5 or 10
TARGET/RESULT TABLE (the header of the table will be there and column names "ID" and "Value" are same as in source table)
ID | Value
 | 250 | <== value ranked from high to low
2341 | 25
n/a | n/a | <== since there are only 2 matches in source table, this 3rd preferably shows "n/a"