tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 588168d1535526090-formula-for-vlookup-for-next-n-days-book1
Sheet: Sheet1

example 1
Input Date |  |  | Desired results in cell D8
2018-01-04 00:00:00 |  |  | 2018-01-06 00:00:00 | Day 2 in Jan
 |  |  | 2018-01-08 00:00:00 | abc
 |  |  | 2018-01-09 00:00:00 | xyz
 |  |  | 2018-01-11 00:00:00 | info1
example 2
 |  |  | Desired results in cell D17
2018-01-09 00:00:00 |  |  | 2018-01-09 00:00:00 | xyz
 |  |  | 2018-01-11 00:00:00 | info1
 |  |  | 2018-01-15 00:00:00 | pqr
 |  |  | 2018-01-16 00:00:00 | xyaaa
 |  |  | 2018-01-17 00:00:00 | some info
 |  |  | 2018-01-26 00:00:00 | more info
Spreadsheet: 735783d1623172394-different-colour-cells-based-on-input-or-no-input-test-spreadsheet-etaf
Sheet: Sheet1 (2)

Staff Details |  |  | Completion Dates
ID | Surname | First Name | Session A | Session B | Session C | Neonate Assessment | Paediatric Assessment | Adult Assessment |  | [NAME]
pa001 | Blogs | Jo | 8th june 21 |  |  | 8th june 21
pa002 | Thumb | [NAME] | 2021-01-01 00:00:00 | 2021-01-02 00:00:00 | 2021-01-03 00:00:00 | 2021-01-04 00:00:00 | 2021-01-05 00:00:00 | 2021-01-06 00:00:00
pa003 | Cricket | [NAME]
Spreadsheet: 63549d1264447181-multi-formula-conditional-formatting-conditional-issue
Sheet: Sheet1

Prior Year Carry overs |  |  |  | 2010 Original Budget $ | OffSets | 2010 Adjusted Budget with offsets $ | 2010 Current Forecast | Approved $ | Prior Years Spend | Current Year Prior Months Actual() | Current Month Spend in SAP | Remaining Forecast/ Accruals | Total Current Month | YTD Actual (PM + CM Actuals) | Total Spend | Remain'g on Project | CY Proj to complete (should not be Neg) | % Fore- cast vs [NAME] | % Spent vs MAFE Appr
 | TANK | Tank (Abandon) |  |  | 0 |  | 195000 | 717960 | 575043.12 |  | 103056.61 |  | 103056.61 | 103056.61 | 678099.73 | 39860.27000000002 | 91943.39 | 1.072543205749624 | 0.944481210652404
 | TANK | 1024 Tank |  |  | 0 |  | 75000 | 175005 | 161201.12 |  | 167.23 |  | 167.23 | 167.23 | 161368.35 | 13636.64999999999 | 74832.77 | 1.349682123367904 | 0.9220785120425131
 | TANK | 653EOM |  |  |  | 170000 | 168364 | 255200 | 146836.41 |  | 100716.33 | 39283.67 | 140000 | 140000 | 286836.41 | -31636.40999999997 | 28364 | 1.23511132445141 | 1.123967123824451
 |  |  |  |  |  |  | Add individual cells from these 2 coloumns and compare to percentage value in S.
 |  |  |  |  |  |  | If same row H+J >=5,000,001 and S >=110% cell in S should be RED
 |  |  |  |  |  |  | If same row [NAME] is between 25,001 and 5,000,000 and S>=115% cell in S should be RED
 |  |  |  |  |  |  | If same row H+J >=25,000 and S >=120% cell in S should be RED
Spreadsheet: 267351d1380051487-calculate-points-and-divisions-student-exam-score-sheet-1-
Sheet: Lookup Sheet

 | Grade | Points |  | Score | Division
 | a | 1 |  | 7 | Division I
 | b | 2 |  | 18 | Division II
 | c | 3 |  | 22 | Division III
 | d | 4 |  | 26 | Division IV
 | f | 5 |  | 34 | Division 0
Spreadsheet: 762137d1641406316-formula-for-totalling-based-on-a-drop-down-choice-sample-spreadsheet-tg01
Sheet: Sheet1

 | Date
January
 | 2019-01-02 00:00:00 | C | O | C
 | 2019-01-09 00:00:00 |  | O | M
 | 2019-01-10 00:00:00 |  | O
 | 2019-01-10 00:00:00 | M | O | C
 | 2019-01-10 00:00:00 | C | O | C
 | 2019-01-11 00:00:00 |  | D | C
 | 2019-01-13 00:00:00 |  | C
 | 2019-01-22 00:00:00 | G | D | O
 | 2019-01-27 00:00:00 | G | C | C
Totals D
Totals O
Totals Others
Total Jobs
Spreadsheet: 783848d1655202804-update-of-iferror-lookup-formula-by-adding-max-formula-test_formula
Sheet: Sheet2

Name | Date | Attendance | EXM 1 | EXM CR1 | Date | Attendance | EXM 2 | EXM CR2 | Date | Attendance | EXM 3 | EXM CR3 | Date | Attendance | EXM4 | EXM CR4 | Final result
[NAME] | 2021-04-21 00:00:00 | Present | 57.5 | 60
Lukas | 2021-04-21 00:00:00 | Present | 55 | 62.5 | 2021-08-13 00:00:00 | Present | 60
Maria | 2021-04-21 00:00:00 | Present | 22.5 | 25 | 2021-08-13 00:00:00 | Present | 45 |  | 2021-12-23 00:00:00 | Excused | n/a |  | 2022-03-10 00:00:00 | Present | 55
[NAME] | 2021-04-21 00:00:00 | Present | 52.5 |  | 2021-08-13 00:00:00 | Present | 60
[NAME] | 2021-04-21 00:00:00 | Present | 57.5 | 65 | 2021-08-13 00:00:00 | Present | 60
[NAME] | 2021-04-21 00:00:00 | Present | 90 | 92.5
Dwayne | 2021-04-21 00:00:00 | Present | 45 |  | 2021-08-13 00:00:00 | Present | 57.5 |  | 2021-12-23 00:00:00 | Present | 62.5
[NAME] | 2021-04-21 00:00:00 | Excused | n/a |  | 2021-08-13 00:00:00 | Present | 45 |  | 2021-12-23 00:00:00 | Excused | n/a |  | 2022-03-10 00:00:00 | Present | 60
Spreadsheet: 794684d1662215154-how-to-identify-reproduce-a-fill-colour-rock-n-roll-bingocd-xx-game-xx-master-document
Sheet: Sheet 5

 | Random No | Songs | Artist
Spreadsheet: 01d72aaa-7fb8-43b2-a773-3c915e9f0b17
Sheet: Sheet1

Note: P=Permanent | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Business Office
Record Series | In Office | Archives | Total Retention Period | Notes
Accounting
Accounts receivable and payable | Tax year+3 years | N/A | Tax year+3 years
Bank deposit slips | Tax year+3 years | N/A | Tax year+3 years
Bank statements and reconciliations | Tax year+3 years | N/A | Tax year+3 years
Budgets | 5 years | N/A | 5 years
Cancelled checks | Tax year+6 years | N/A | Tax year+6 years
Cash disbursements journal | Tax year+6 years | N/A | Tax year+6 years
Cash receipts journal | Tax year+6 years | N/A | Tax year+6 years
Depreciation records | retain in office permanently | N/A | Permanent, in office
Employee expense reports | Tax year+3 years | N/A | Tax year+3 years
Employee payroll records (W-2, W-4) | Tax year+4 years | N/A | Tax year+4 years
Annual Audit reports | 3 years | P | P
Financial statements, interim/internal | 1 year | N/A | 1 year
year-end financial statements | Tax year+3 years | N/A | Tax year+3 years
General journal or ledger | Tax year+6 years | N/A | Tax year+6 years
Inventory lists, except art inventory | Current+2 years | N/A | Current+2 years
Art inventory | Current+2 years | P | P
Invoices | Tax year+3 years | N/A | Tax year+3 years
Payroll register/journal | Tax year+4 years | N/A | Tax year+4 years
Petty cash vouchers | Tax year+3 years | N/A | Tax year+3 years
Pledge documents | Final payment+4 years | N/A | Final payment+4 years
Time cards/sheets | Tax year+4 years | N/A | Tax year+4 years
Payroll authorization forms | 10 years | N/A | 10 years
Insurance
Accident reports | Resolution+2 years |  | Resolution+2 years
Insurance claims | Resolution+2 years |  | Resolution+2 years
Insurance policies | Active+10 years |  | Active+10 years
Tax yeares
Income Tax year returns | Tax year+4 years |  | Tax year+4 years
Payroll Tax year returns | Tax year+4 years |  | Tax year+4 years
Property Tax year returns/filings | Tax year+4 years |  | Tax year+4 years
Sales and use Tax year returns | Tax year+4 years |  | Tax year+4 years
General
Correspondence/notes re:agreements, liabilities, etc. | Life of agreement or 3 years, whichever is longer |  | Life of agreement or 3 years, whichever is longer
Contracts | Completion+10 years |  | Completion+10 years
Bond documents | 20 years |  | 20 years
Contents of safe in CFO's Office | retain in office permanently |  | Permanent, in office
Deeds to Roosevelt property | retain in office permanently |  | Permanent, in office
[NAME] transcript | retain in office permanently |  | Permanent, in office
Spreadsheet: 85288d1285322832-how-can-i-insert-continuous-serial-number-when-only-in-name-exist-in-col-b-namaste
Sheet: Sheet1

SN | Name | Address | Plot | Area
1 | A | Kathmandu | 1 | 45 | 1
 |  |  | 2 | 55
2 | B | Kathmandu | 1 | 22 | 2
 | Chainage 454654xcfvxcvxvxcvzv |  | 2 | 33
 |  |  | 3 | 33
3 | C | Kathmandu | 1 | 66 | 3
4 | D | Kathmandu | 1 | 44 | 4
 | Chainage [PHONE]
5 | E | Kathmandu | 1 | 45 | 5
 |  |  | 2 | 55
6 | F | Kathmandu | 1 | 22 | 6
 | Chainage 454654dfsdfsdfsdr |  | 2 | 33
 |  |  | 3 | 33
7 | G | Kathmandu | 1 | 66 | 7
8 | H | Kathmandu | 1 | 44 | 8
 |  | How can I insert serial number when only in Name exist in col B? and [NAME] the Section line too.
Spreadsheet: 42853d1241498942-hours-demographic-hours-demographic
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Qty | PxQ
 |  |  | Apples
 |  |  |  |  |  |  |  |  |  | Apples |  |  |  | 5 | 20
 |  |  |  |  |  |  |  |  |  | Apples |  |  |  | 8 | 32
 |  |  |  |  |  |  |  |  |  | Apples |  |  |  | 4 | 22
 |  |  |  |  |  |  |  |  |  | Apples |  |  |  | 3 | 15
 |  |  | Total Apples |  |  |  |  |  |  |  |  |  |  |  | 89
 |  |  | Oranges
 |  |  |  |  |  |  |  |  |  | Oranges |  |  |  | 4 | 101
 |  |  |  |  |  |  |  |  |  | Oranges |  |  |  | 5 | 120
 |  |  |  |  |  |  |  |  |  | Oranges |  |  |  | 6 | 131
 |  |  | Total Oranges |  |  |  |  |  |  |  |  |  |  |  | 352
 |  |  | Beets
 |  |  |  |  |  |  |  |  |  | Beets |  |  |  | 1 | 5
 |  |  |  |  |  |  |  |  |  | Beets |  |  |  | 2 | 19
 |  |  | Total Beets |  |  |  |  |  |  |  |  |  |  |  | 24
 |  |  | Carrots |  |  |  |  |  |  | Carrot |  |  |  | 2 | 24
Spreadsheet: 877601d1724405294-function-like-if-function-needed
Sheet: Sheet1

 | Grade 1 | [NAME] | [NAME] | [NAME]
 | 3 | 1 | 1 | 2
 | 3 | 3 | 3 | 3
 | 1 | 4 | 2 | 3
 | 1 | 1 | 4 | 3 |  | as the average of thes row is 2.25, but we also have 4 grade so we need the averiage of B5:E5 get 3
 | 1 | 3 | 3 | 2
 | 1 | 4 | 3 | 2
 | 4 | 3 | 3 | 4
 | 4 | 4 | 1 | 3
 | 2 | 3 | 1 | 1
 | 1 | 1 | 4 | 4
 | 1 | 3 | 1 | 4
 | 1 | 1 | 3 | 1
 | 1 | 1 | 1 | 3
 | 1 | 3 | 3 | 2
 | 1 | 4 | 4 | 2
 | 1 | 3 | 4 | 4
 | 3 | 1 | 1 | 4
 | 1 | 1 | 1 | 2
Spreadsheet: 735985d1623303989-help-adding-if-function-to-existing-sumif-function-chemical-inventory-control-in-progress
Sheet: Warehouse 2

 | Chemical Inventory Levels
 | WAREHOUSE 2
 | Product | 2021-05-26 00:00:00 |  | Packaging & Cost |  |  |  |  | Do not edit |  |  | Notes/Comments
 |  | Last Stock Take | Unit | Packaging | Unit of Packaging | Qty of Packaging | Price per Packaging | Total (R) |  | Current Stock | Unit
 | Product 1 | 0 | Lt | 1 | Lt |  | 704 |  |  |  | Lt
 | Product 2 | 24 | Kg | 1 | Kg |  | 2031 |  |  |  | Kg
 | Product 3 | 0 | Kg | 25 | Kg |  | 26 |  |  |  | Kg
 | Product 4 | 0 | Lt | 1 | Lt |  | 1249.28 |  |  |  | Lt
 | Product 5 | 10 | Kg | 5 | Kg |  | 105 |  |  |  | Kg
 | Product 6 | 1 | Kg | 1 | Kg |  | 4920 |  |  |  | Kg
 | Product 7 | 40 | Kg | 5 | Kg |  | 150 |  |  |  | Kg
 | Product 8 | 40 | Lt | 5 | Lt |  | 471 |  |  |  | Lt
 | Product 9 | 16 | Lt | 1 | Lt |  | 1447 |  |  |  | Lt
 | Product 10 | 3 | Lt | 1 | Lt |  | 683 |  |  |  | Lt
 | Product 11 | 25 | Lt | 5 | Lt |  | 438 |  |  |  | Lt
 | Product 12 | 0 | Kg | 1 | Kg |  | 6621 |  |  |  | Kg
 | Product 13 | 0 | Lt | 5 | Lt |  | 500 |  |  |  | Lt
 | Product 14 | 20 | Lt | 5 | Lt |  | 487 |  |  |  | Lt
 | Product 15 | 0 | Kg | 1 | Kg |  | 3300 |  |  |  | Kg
 | Product 16 | 1 | Lt | 1 | Lt |  | 1550 |  |  |  | Lt
 |  |  |  |  | Total Stock in the Warehouse in Rand Value:
Spreadsheet: 221079d1363362095-locking-data-together-big-excel-for-forum-help-updated
Sheet: Site Expenses

Site ID |  | CV305 | CV309 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PO # |  | 22 | 33 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Description |  | Civil | Tower | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PO Amount |  | 200 | 300 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sub Accepted Price |  | 20 | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Materials
Home Depot CC
Hotels
Crane
[NAME].
Transportation
Expense Report
Petty Cash
Labor Cost
Change Orders
Gross Profit With 5% Material Mark Up
% Profit
Spreadsheet: 772011d1646960743-vlookup-xlookup-idk-pls-help-help
Sheet: Data AFTER Formulas

Product Title | List of Makes | List of Models | Car Make if product title (A) contains a Make from entire Col. B | Car Model if product title (A) contains a Model from entire Col. C
Audi R8 Lights | Audi | R8 | Audi | R8
Chevy Camaro Lights | Chevy | Camaro | Chevy | Camaro
[NAME] | Ford | Mustang | Audi | R8
Chevy [NAME] | Toyota | Supra | Chevy | Camaro
Toyota [NAME] |  |  | Toyota | Supra
Ford [NAME] |  |  | Ford | Mustang
BMW M4 Wing |  |  | N/A | N/A
[NAME] |  |  | Audi | R8
 |  |  | ^ COLUMN D NEEDS FORMULA ^ | ^ COLUMN E NEEDS FORMULA ^
Spreadsheet: 2149bd30-35da-4fe0-8b10-7309cacdd6f4
Sheet: Rambouillet

Marker1 | Marker2 | D' | r^2
OAR1_185953850 | OAR1_186779231 | 0.358 | 0.121
OAR13_26084492 | OAR13_56607666 | 0.026 | 0
OAR15_78598295 | s31340 | 0.93 | 0.513
OAR17_5388531 | s19031 | 0.154 | 0
OAR18_5646940 | OAR18_5701234 | 1 | 1
OAR18_5646940 | OAR18_9395406 | 0.045 | 0.001
OAR18_5701234 | OAR18_9395406 | 0.045 | 0.001
OAR20_19572554 | s65956 | 0.247 | 0.037
DU231007_156 | OAR3_108176200 | 0.563 | 0.016
DU231007_156 | OAR3_144283427 | 0.063 | 0.001
DU231007_156 | OAR3_144414855 | 0.019 | 0
DU231007_156 | s23946 | 0.003 | 0
OAR3_108176200 | OAR3_144283427 | 0.18 | 0.006
OAR3_108176200 | OAR3_144414855 | 0.127 | 0.003
OAR3_108176200 | s23946 | 0.554 | 0.063
OAR3_144283427 | OAR3_144414855 | 1 | 0.888
s23946 | OAR3_144283427 | 0.062 | 0.003
s23946 | OAR3_144414855 | 0.099 | 0.008
OAR5_93280925 | OAR5_94009731 | 0.136 | 0.007
s27054 | OAR5_93280925 | 0.098 | 0.001
s27054 | OAR5_94009731 | 0.064 | 0.004
OAR8_73555614 | OAR8_88021348 | 0.008 | 0
s27979 | OAR8_73555614 | 0.032 | 0.001
s27979 | OAR8_88021348 | 0.037 | 0.001
OAR9_10735564 | OAR9_10749779 | 1 | 0.398
OAR9_10735564 | OAR9_35880400 | 0.146 | 0.004
OAR9_10735564 | s48118 | 0.822 | 0.157
OAR9_10749779 | OAR9_35880400 | 0.2 | 0.003
OAR9_10749779 | s48118 | 1 | 0.092
s48118 | OAR9_35880400 | 0.105 | 0.01
Spreadsheet: 718461d1613145345-lookup-month-in-col-a-and-if-col-h-on-same-sheet-x-display-x-otherwise-blank-staff-changes-by-month-example
Sheet: Jan

Staff Transferred Out |  |  |  |  |  |  |  |  |  | Jan
Spreadsheet: 33d99626-b41f-4e03-993f-9b9417bbd9c4
Sheet: Code Sheet

n/a | n/a | SFY 2014 UNREIMBURSABLE NONFEDERAL  ADSIS EXPENDITURES CODE SHEET
SFY 2014 STATE EDRS-UFARS codes crosswalk
UFARS Finance Dimensions (FIN) to EDRS Funding Source Codes (FSC)
UFARS FIN | EDRS FSC | [NAME]
740 | b | Unreimbursable Nonfederal ADSIS Expenditures
line left blank intentionally
UFARS Object Codes to EDRS Service Codes
UFARS OBJECT CODE | EDRS SERVICE CODE | [NAME]
110/170 | A | Payroll Personnel (Salaries Only)
305 | b | Contracted Personnel/Agency Services for Staff
365/366 | F | Travel & Travel Chargeback (use with Activity Code Z)
369 | f | Field Trip Admissions'
430 | h | Non-Individualized Instructional Supplies
401 | I | Office Supplies and Materials
320 | K | Electronic Communication Services
195-280,299,397 | L | Fringe Benefits
329 | M | Dissemination
530 | O | Equipment for Office Supervision/ Management
820 | R | Dues/Membership (use with Activity Code V)
396 | U | Purchase of Services (salaried personnel from other districts)
401/430 | u | Purchase of Instrictional Supplies/Material
line left blank intentionally
UFARS Object Codes to EDRS Personnel Type Code
Payroll Personnel - SERVICE CODE A
UFARS OBJECT CODE | EDRS PTC | [NAME]
110 | 9 | Director of Special Education
110 | 10 | Assistant Director/Supervisor
170 | 22 | Secretary
line left blank intentionally
UFARS Object Codes to EDRS Personnel Type Code
Contracted Services - SERVICE CODE b
UFARS OBJECT CODE | EDRS PTC | [NAME]
305 | 9 | Director of Special Education
305 | 10 | Assistant Director/Supervisor
305 | 22 | Secretary
line left blank intentionally
UFARS Object Codes to EDRS Personnel Type Code
Purchase of Services (Salaried Personnel from other Districts) - SERVICE CODE U
UFARS OBJECT CODE | EDRS PTC | [NAME]
396 | 9 | Director of Special Education
396 | 10 | Assistant Director/Supervisor
396 | 22 | Secretary
line left blank intentionally
UFARS Program Code to EDRS Disability Code
UFARS PROGRAM CODE | EDRS DISABILITY CODE | [NAME]
422 | 422 | Non-Disabled (no IEP/IFSP/IIIP) (use FSC C and FSC N only)
line left blank intentionally
n/a | EDRS Activity Codes
n/a | Activity code | [NAME]
n/a | V | Professional Membership/Dues Expenses (use with Service Code R)
n/a | Z | Travel, Mileage (use with Service Code F)
line left blank intentionally
n/a | EDRS Time Unit Type Codes
n/a | Time Unit Type Codes | [NAME]
n/a | D | Days Worked
n/a | H | Hours Worked
end of worksheet
Spreadsheet: 231504d1367098248-two-misaligned-cells-16-team-planning-bracket
Sheet: 182

[NAME] | Aztec | 1
bl182 | Bloomfield
cib182 | Cibola
cle182 | Cleveland
far182 | Farmington
gal182 | Gallup
grt182 | Grants | 8
kc182 | [NAME]
miy182 | Miyamura | 5
new182 | Newcomb
[NAME] | Piedra Vista
[NAME] | Rio Rancho
[NAME] | Santa Fe
ship182 | Shiprock
[NAME] | [NAME] | 4
win182 | Wingate
 |  | 3
Paste Value - CTRL-N
 |  | 6
 |  | 7
 |  | 2
Spreadsheet: 33641d1230116772-string-multiple-text-per-conditions-example
Sheet: Sheet1

dog |  |  | Dog | Cat | Sheep | Cow
dog |  |  | dog, dog, dog, dog | cat, cat | sheep, sheep, sheep, sheep, sheep, sheep, sheep | cow, cow, cow, cow
dog
dog
cat
cat
sheep
sheep
sheep
sheep
sheep
sheep
sheep
sheep
cow
cow
cow
cow
Spreadsheet: 51734d1251360758-formulae-not-referencing-when-sorting-ssr
Sheet: A

334 | 8 | 326
34 | 328 | 140
34 | 83 | 130
6 | 25 | 682
5 | 86 | 152
8 | 85 | 37162
5 | 7432 | 432
1 | 46 | 2674
2 | 64 | 11154
3 | 46 | 2824
9 | 36 | 48
Spreadsheet: 777860d1650642537-formula-to-automatically-update-cell-entry-based-on-whether-other-cells-are-empty-or-not-example-status-workbook
Sheet: Sheet1

Project | Status | Stage 1 | Stage 2 | Stage 3 | Stage 4 | Stage 5
Collection 1 | Stage 4 | Yes | Yes | Yes
Collection 2 | Complete | Yes | Yes | Yes | Yes | Yes
Collection 3 | Stage 3 | Yes | Yes
Spreadsheet: d914bd89-2161-457e-adb1-e7dcd32b6087
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Third Party Entity Merch | 679143054197 | Son Of God | Ladies Son Of God [NAME] | 2014-01-28 | T-Shirt | Na | 18.99 | N | Available
Third Party Entity Merch | 679143054180 | Son Of God | Ladies Son Of God Adult Large Tee | 2014-01-28 | T-Shirt | Na | 18.99 | N | Available
Third Party Entity Merch | 679143054173 | Son Of God | Ladies Son Of God Adult Medium Tee | 2014-01-28 | T-Shirt | Na | 18.99 | N | Available
Third Party Entity Merch | 679143054166 | Son Of God | Unisex Son Of God [NAME] | 2014-01-28 | T-Shirt | Na | 18.99 | N | Available
Third Party Entity Merch | 679143054159 | Son Of God | Unisex Son Of God Adult Large Tee | 2014-01-28 | T-Shirt | Na | 18.99 | N | Available
Third Party Entity Merch | 679143054142 | Son Of God | Unisex Son Of God Adult Medium Tee | 2014-01-28 | T-Shirt | Na | 18.99 | N | Available
Spreadsheet: 718664d1613271093-transposing-multiple-columns-into-unique-rows-transposing-solution
Sheet: RAW DATA

KEY | ITEM | SHOP 1 | SHOP 2 | SHOP 3 | SHOP 4
ABC1 | Apple | 2.2 | 2.13 | 1.9 | 1.9
[NAME] | Orange | 1.7 | 1.9 | 2.13 | 1.6
ABC3 | [NAME] | 1.5 | 2 | 2.2 | 2.13
[NAME] | Pineapple | 2.2 | 1.9 | 1.9 | 2.13
ABC5 | [NAME] | 2.5 | 2.13 | 1.99 | 2
ABC6 | Kiwi | 2 | 1.9 | 2.5 | 2.13
ABC7 | Pear | 1.2 | 1.8 | 1.9 | 1.5
ABC8 | Grapes | 2.7 | 2.13 | 2.3 | 2
ABC9 | Lemon | 1.4 | 1.3 | 1.6 | 1.5
ABC10 | Lime | 1.9 | 2.13 | 1.9 | 2
Spreadsheet: 1868c2a1-a91b-4246-b201-90718ada1396
Sheet: Patient Business Associate

 | Outboarding matrix for UNCH Admin Associate or Admin Specialist
 | Employee Name:
 | PID: | Department Name:
 | Date of Hire: | Department Number:
 | Date for Departure: | Date of Exit:
 | The following checklist is provided to assist all UNC-Chapel Hill employees with the exit process.  Employees leaving the University should be aware of their benefits and rights.  In addition, departing employees have an obligation to return all University property assigned to them and to settle any outstanding accounts.  Please contact your HR Facilitator if you have any questions during the exit process.  (Items on checklist may not apply to all employees.) You should review the package entitled "Leaving the University" before making any decisions.
 | Employee Responsibilities |  | Done | N/A
 | Provide written notice of departure |  | Self
 | Return keys |  | Self
 | Return pager |  | Self
 | Return ID badge |  | Self
 | Return UNC OneCard |  | Self
 | Return parking permit to Transportation & Parking |  | Self
 | Return any other University property |  | Self
 | ▪ |  | Self
 | ▪ |  | Self
 | ▪ |  | Self
 | ▪ |  | Self
 | Provide mailing address for final paycheck to HR Facilitator |  | Self
 | Confirm that home address is correct in online directory before leaving |  | Self
 | Settle any miscellaneous debts or fines |  | Self
 | Decide what actions to take regarding benefits termination or continuation and initiate necessary requirements within stated deadlines |  | Self
 | Clearance form |  | Click here for form
 | HR Facilitator's Responsibilities
 | Complete Clearform |  | HR Facilitator
 | Remove employee's name from authorized signature lists |  | HR Facilitator
 | Terminate access to University systems |  | HR Facilitator
 | ▪  WebCIS |  | HR Facilitator
 | ▪  CITRIX |  | HR Facilitator
 | ▪  Report2Web - Hospital |  | HR Facilitator
 | ▪  Report2Web - P&A |  | HR Facilitator
 | ▪  [NAME] ([NAME]) |  | HR Facilitator
 | ▪  REGEWSBAR |  | HR Facilitator
 | ▪  LMS |  | HR Facilitator
 | ▪  A2K (Siemens) |  | HR Facilitator
 | ▪  LDAP and/or UNCH email |  | HR Facilitator
 | Audit leave balances (vacation, sick, bonus, compensatory time) |  | HR Facilitator
 | Clinic Coordinator's Responsibilities
 | Terminate access to IMC systems
 | ▪  CSW |  | [NAME]
 | Updates
 | ▪  Distribution lists |  | [NAME]