tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 763851d1642431804-pick-a-grade-based-on-five-other-grades-sub-cats
Sheet: Sheet1

e.g. | Sub cat 1 | Sub cat 2 | Sub cat 3 | Sub cat 4 | Sub cat 5 |  | If all sub cats are "good" then the overall is "Good"
Ratings | Inadequate | RI | RI | RI | Inadequate |  | If all sub cats are "RI" then the overall is "RI"
Overall Rating | Inadequate |  |  |  |  |  | If all sub cats are "Inadequate" then the overall is "Inadequate"
 |  |  |  |  |  |  | If 4 sub cats are "Good" and one is "RI" then the overall is "Good"
e.g. | Sub cat 1 | Sub cat 2 | Sub cat 3 | Sub cat 4 | Sub cat 5 |  | If any more than 1 sub cats are "RI" then the overall is "RI"
Ratings | Good | Good | Good | Good | RI |  | If more than 2 sub cats are "inadequate" then the it is "inadequate"
Overall Rating | Good
e.g. | Sub cat 1 | Sub cat 2 | Sub cat 3 | Sub cat 4 | Sub cat 5
Ratings | Inadequate | RI | RI | RI | RI
Overall Rating | RI
e.g. | Sub cat 1 | Sub cat 2 | Sub cat 3 | Sub cat 4 | Sub cat 5
Ratings | Good | Good | RI | RI | RI
Overall Rating | RI
Spreadsheet: 849756d1700153047-formula-to-identify-non-alphanumeric-characters-within-a-name-non-alphanumeric-3-
Sheet: Sheet1

Name
[NAME]
[NAME]
John*&^
[NAME]
[NAME]
[NAME]
£"?
-
Hi Lei
[NAME]
Spreadsheet: 163816d1340471327-move-entire-row-to-another-worksheet-based-on-cell-value-test
Sheet: Project Pipeline

Job/Quote # | Client | Description | Location | PM | PO# | Assigned PM | Note
2001 | AIG | Engineering | SOMEWHERE | [NAME] | Hart Telephone Co.
2001 | AIG | BDFB | SOMEWHERE | [NAME] | CCQT078219
2001 | AIG | Core Room | SOMEWHERE | [NAME] | NHQT078289
2001 | AIG | [NAME] | SOMEWHERE | [NAME]
2001 | AIG | BRIX | SOMEWHERE | George | NNWR147598
2001 | AIG | Taps | SOMEWHERE | Greg
2001 | AIG | Taps | SOMEWHERE | [NAME] | NIWM187298
2001 | AIG | SRX | SOMEWHERE | [NAME] | TBD
990300 | VZW | BDFB / EDN Rack Audit | Redmond | Greg
 | VZW | NetScout 7995 | Redmond | Greg
 | VZW | Rocklin Audit Extension | Roclkin | Tim/ [NAME]
 |  | Lambda MTSO Fibers
Spreadsheet: 102404d1300349455-select-worksheet-shorcuts-keyboard
Sheet: KeyNotes

 | Extended Notes on Keyboard Explanation
Key | Alone | Shift | Alt | Ctrl | Note
Down
Enter | Special Condition: With a group of cells selected, this key will cycle through each cell in the selection, allowing data entry in those cells only.
Left
Period |  |  |  | Special Condition: With a group of cells selected, this key will cycle to the corners in the selection, allowing data entry in those cells only.
Right
[NAME] | Special Condition: With a group of cells selected, this key will cycle to the right and then down to the next row through each cell in the selection, allowing data entry in those cells only. | Special Condition: With a group of cells selected, this key will cycle to the left and then down to the next row through each cell in the selection, allowing data entry in those cells only.
Up | Depending on current active cell: [NAME] to top of cell group or top of file. | Same as Alone except that it selects all the cells in the group |  |  | A "group" of cells is any rectangular grouping of cells surrounded by empty cells.
8 |  |  |  | Region Select (Shift-Ctrl) A Region is any group of cells containing data (text, numbers, formulas) that is surrounded by blank cells.
Spreadsheet: 88723d1288595013-find-certain-number-then-copy-it-and-4-other-cells-to-other-worksheet-example
Sheet: Sheet2

11 | a1 | b1 | c1 | d1 | 16 | e1 | f1 | g1 | h1 | 30 | i1 | j1 | k1 | l1 | 40 | m1 | n1 | o1 | p1
12 | aa1 | bb1 | [NAME] | dd1 | 17 | ee1 | ff1 | gg1 | hh1 | 31 | ii1 | jj1 | kk1 | ll1 | 41 | [NAME] | nn1 | oo1 | pp1
13 | aaa1 | bbb1 | ccc1 | ddd1 | 18 | eee1 | fff1 | ggg1 | hhh1 | 32 | iii1 | jjj1 | kkk1 | lll1 | 42 | mmm1 | nnn1 | ooo1 | ppp1
14 | aaaa1 | bbbb1 | cccc1 | dddd1 | 19 | eeee1 | ffff1 | gggg1 | hhhh1 | 33 | iiii1 | [NAME] | kkkk1 | llll1 | 43 | mmmm1 | nnnn1 | oooo1 | pppp1
15 | [NAME] | bbbbb1 | ccccc1 | ddddd | 20 | eeeee1 | fffff1 | ggggg1 | hhhhh1 | 34 | iiiii1 | [NAME] | kkkkk1 | [NAME] | 44 | mmmmm1 | nnnnn1 | ooooo1 | ppppp1
Spreadsheet: 29548d1224611631-vlookup-formula-only-returns-ref-or-n-a-test-inventory-tool
Sheet: pal

Qty | Piece of Equipment | Serial Number | Location | Cost | date of Purchase
1 | Starlux Pulsed Light Demo Systems | 15-1109 | [NAME] | 375000 | Purchased from [NAME] in November 2007 for 375k
1 | Starlux Pulsed Light Demo Systems | 15-1338 | Northtown
1 | Starlux Pulsed Light Demo Systems | 15-1344 | Queen Street West
1 | Starlux Pulsed Light Demo Systems | 15-0347 | Vegas
1 | Starlux Pulsed Light Demo Systems | 15-1494 | No Location listed
1 | Starlux Pulsed Light Demo Systems | 15-0558 | Woodfield
 | Total Starlux Units
1 | Yellow H P | 065233 | No Location listed
1 | Yellow H P | 060727 | No Location listed
1 | Yellow H P | 056884-25 | No Location listed
 | Total Yellow Hand Pieces
1 | RS H P | 066534 | No Location listed
1 | RS H P | 061132-6 | No Location listed
1 | RS H P | 070216-7 | No Location listed
1 | RS H P | 062572-8 | No Location listed
1 | RS H P | 070626-3 | No Location listed
 | Total RS Hand Pieces
1 | Green H P | 078287 | No Location listed
1 | Green H P | 061312-7 | No Location listed
1 | Green H P | 054366-12 | No Location listed
1 | Green H P | 063523-4 | No Location listed
1 | Green H P | 069407-20 | No Location listed
1 | Green H P | 069945 | No Location listed
1 | Green H P | 067910 | No Location listed
 | Total Green Hand Pieces
1 | Violet H P | 059014 | No Location listed
 | Total Violet Hand Pieces
1 | 1064 H P | 056865-2 | No Location listed
 | Total 1064 Hand Pieces
1 | External Chiller Assembly | 066493-4 | No Location listed
Spreadsheet: 861270d1709198693-taking-weekly-data-and-converting-to-monthly-formula-query-2
Sheet: Summary

 | Opening Cash |  | Cash Flow Summary - Monthly
 | 3573315.55
 | Minimum Cash Balance
 | 100000
 |  |  | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | Total
 | Cash balance at beginning of month
 | Cash Receipts
 | Deposit
 | Reg Fees
 | Advanced Fees
 | Sales Ledger
 | Donation
 | Commercial Activities
 | Trips
 | Commem
 | Investment Income
 | Childcare
 | Intercompany
 | Total Cash Receipts
 | Cash paid out
 | Council Tax
 | Bank Charges
 | Travel
 | TV
 | Management Fees
 | IT
 | Phone
 | Lease
 | Marketing
 | Subscription
 | Adhoc
 | VAT
 | Cleaning Contract
 | Purchase Ledger
 | Insurance
 | Credit Card
 | Loan
 | Water Rates
 | Energy
 | Gas
 | Pension
 | Payroll
 | INLAND
 | Capital Projects
 | Catering
 | Total Cash Paid Out
 | Cash balance at end of month
Spreadsheet: 791401d1660323544-metre-squared-to-lineal-metres-calculator-m2-to-lm-calc
Sheet: Cladding & Lining Calculato (2)

CLADDING & LINING CALCULATOR M2 TO LM
 | Client
 |  | L - Mtrs |  | D - Mtrs |  | m2 |  | Wastage | Total | [NAME] ([NAME]) | Lineal Mtrs |  | Timber [NAME] | Total LM
 | Area 1 | 5 | x | 5 | = |  | + | 0.1 |  | 90
 | Area 2 | 5 | x | 5 | = |  | + | 0.1 |  | 70
 | Area 3 | 4 | x | 5 | = |  | + | 0.1 |  | 50
 | Area 4 | 4 | x | 5 | = |  | + | 0.1 |  | 75
 | Area 5 | 4 | x | 5 | = |  | + | 0.1 |  | 90
 | Area 6 | 3 | x | 5 | = |  | + | 0.1 |  | 75
 | Area 7 | 3 | x | 5 | = |  | + | 0.1 |  | 50
 | Area 8 | 3 | x | 5 | = |  | + | 0.1 |  | 70
 | Area 9 | 2 | x | 5 | = |  | + | 0.1 |  | 75
 | Area 10 | 2.5 | x | 5 | = |  | + | 0.1 |  | 50
Spreadsheet: 875116d1721681145-display-name-not-code-from-a-cell-into-another-cell-example
Sheet: Sheet1

1 | Chocolate B-20240606-CH-0
2 | Chocolate B-20240606-CH-0
3 | Chocolate B-20240606-CH-0
4 | Chocolate B-20240606-CH-0
5 | Chocolate B-20240606-CH-0
6 | Chocolate B-20240606-CH-0
7 | Chocolate B-20240606-CH-0
8 | Chocolate B-20240606-CH-0
9 | [NAME]
10 | [NAME]
11 | [NAME]
12 | [NAME]
13 | [NAME]
14 | [NAME]
15 | [NAME]
16 | [NAME]
17 | [NAME]
Spreadsheet: 846438d1697639376-issue-with-using-countifs-for-non-consecutive-cells-games-demo
Sheet: Games

Date | at/vs | W/L | Score | Winning G | Losing G | Lifetime (H) | Lifetime (A) | Lifetime Total
2019-11-07 00:00:00 | vs Reds | L | 1-3 | [NAME] | [NAME] |  | -
2020-12-03 00:00:00 | at Greens | W | 6-2 | [NAME] | [NAME] | -
2021-02-24 00:00:00 | vs Golds | L | 4-5 | [NAME] | [NAME] | 0-2-0-0 | -
2023-02-07 00:00:00 | at Purples | SOL | 4-5 | [NAME] | [NAME] | - | 0-1-0-1
Spreadsheet: 218395d1362441830-look-up-specific-text-and-return-a-list-of-the-satisfied-text-example
Sheet: Sheet3

CF | CS | SS | PO | D
Name 1 | Name 3 | Name 6 | Name 8 | Name 26
Name 13 | Name 20 | Name 24 | Name 44 | Name 37
Name 17 | Name 33 | Name 63 | Name 77 | Name 56
Name 29 | Name 50 | Name 85 | Name 137 | Name 73
Name 40 | Name 61 | Name 107 | Name 164 | Name 87
Name 54 | Name 70 | Name 134 | Name 178 | Name 100
Name 66 | Name 95 | Name 152 | Name 190 | Name 117
Name 75 | Name 111 | Name 182 |  | Name 140
Name 89 | Name 122 | Name 200 |  | Name 145
Name 103 | Name 127 |  |  | Name 166
Name 114 | Name 142 |  |  | Name 176
Name 131 | Name 159 |  |  | Name 186
Name 147 | Name 174 |  |  | Name 196
Name 155 | Name 198
Name 162
Name 169
Name 180
Name 194
Spreadsheet: 685149d1593762178-create-summary-page-referencing-multiple-sheets-loading-schedule-example-2-
Sheet: C

Device Name/Number | Device Type | Location | MAC Address | Serial Number | IP Address | [NAME]
Print Server | Windows Server | IDF Room | f4:f6:g4:6j:8c:9n | 12345 | 10.10.10.9 | Switch-a
File Server | Windows Server | IDF Room | s4:6v:8s:c6:8g:fd | 67890 | 10.10.10.10 | Switch-b
Spreadsheet: 820256d1677956944-sort-mixed-data-from-1-sheet-to-other-tabs-bol-a
Sheet: Feb

c | Name | date | del/pic | AM/PM | BOL | on/off
 | karen | 00:00:00 | 2023-02-01 00:00:00 | del | am | 49
gie44960 | maggie | 00:00:00 | 2023-02-03 00:00:00 | pic | am | 50
[NAME] | peggy | 00:00:00 | 2023-02-05 00:00:00 | del | pm | 51
ald44963 | [NAME] | 00:00:00 | 2023-02-06 00:00:00 | pic | am | 52
[NAME] | meggan | 00:00:00 | 2023-02-07 00:00:00 | pic | pm | 53
ood44967 | atwood | 00:00:00 | 2023-02-10 00:00:00 | pic | pm | 54
ren44972 | karen | 00:00:00 | 2023-02-15 00:00:00 | pic | pm | 55
ggy44985 | peggy | 00:00:00 | 2023-02-28 00:00:00 | pic | am | 56
Spreadsheet: 761610d1641103892-dynamic-column-reference-in-filter-command-filter-fomrula-example
Sheet: formula

Gender | Male |  |  |  |  |  |  |  | Setup
DOW | WED |  |  | [NAME] Here: |  |  |  |  | Select your "Gender"
 |  |  |  |  |  |  |  |  | Select your "DOW" (day of week)
 |  |  |  | Mutt
 |  |  |  | [NAME]
 |  |  |  | Mark
 |  |  |  |  |  |  |  |  | What should happen
 |  |  |  |  |  |  |  |  | The "FILTER" formula should reference B3 to determine which column should be evaluated from the "data" tab, table1.
 |  |  |  |  |  |  |  |  | Sample "Formula" that does not work
 |  |  |  |  |  |  |  |  | =FILTER(Table1[First Name],(Table1[Gender]=$B2)*(Table1[&"B3"&]="Y"))
 |  |  |  |  |  |  |  |  | Examples with results
 |  |  |  |  |  |  |  |  | Gender: [NAME]: WED = [NAME], [NAME]
 |  |  |  |  |  |  |  |  | Gender: [NAME]: SUN = Cathy
 |  |  |  |  |  |  |  |  | Gender: [NAME]: SAT = [NAME]
Spreadsheet: 864829d1711973930-formula-to-work-out-the-invoice-due-date-sample-data
Sheet: Data

Supplier Code | [NAME] | Blanket Agreement | Type | Doc. No. | Instal. No. | Invoice Date | Balance Due | Payment Terms | Invoice Due Date
S100134 | AA |  | PU | 57639 | 1 | 2023-12-08 00:00:00 | -401.34 | 90 days EOM
S100134 | AA |  | PU | 58589 | 1 | 2024-01-22 00:00:00 | -776.1 | 90 days EOM
S101445 | CC |  | PU | 58233 | 1 | 2023-12-19 00:00:00 | -7158.26 | 75 Days
S102866 | DD |  | PU | 59151 | 1 | 2024-02-07 00:00:00 | -8479.37 | 28 Days
S104867 | EE |  | PU | 57466 | 1 | 2023-11-30 00:00:00 | -11609.63 | 120 Days EOM
S104867 | EE |  | PU | 57544 | 1 | 2023-12-06 00:00:00 | -176.4 | 120 Days EOM
S105099 | MM |  | PU | 59001 | 1 | 2024-01-25 00:00:00 | -778.8 | 30 Days
S105655 | FF |  | PU | 59023 | 1 | 2024-01-23 00:00:00 | -2540 | 30 Days
S106244 | GG |  | PU | 57555 | 1 | 2023-12-05 00:00:00 | -340.08 | 60 Days EOM
S106244 | GG |  | PU | 59075 | 1 | 2024-02-02 00:00:00 | -121.74 | 60 Days EOM
S106623 | HH |  | PU | 58821 | 1 | 2024-01-26 00:00:00 | -453.8 | 30 days EOM
S106623 | HH |  | PU | 59404 | 1 | 2024-02-23 00:00:00 | -778.57 | 30 days EOM
S106655 | TT |  | PU | 59407 | 1 | 2024-02-27 00:00:00 | -4679.76 | 60 Days
S107877 | JJ |  | PU | 59218 | 1 | 2024-01-31 00:00:00 | -4930.1 | 60 Days
Spreadsheet: 728164d1618342403-sum-active-subscription-by-date-active-subscriptions
Sheet: Active_Subsc.

Day | Subscritions
2020-11-17 00:00:00
2020-11-18 00:00:00
2020-11-19 00:00:00
2020-11-20 00:00:00
2020-11-21 00:00:00
2020-11-22 00:00:00
2020-11-23 00:00:00
2020-11-24 00:00:00
2020-11-25 00:00:00
2020-11-26 00:00:00
2020-11-27 00:00:00
2020-11-28 00:00:00
2020-11-29 00:00:00
2020-11-30 00:00:00
2020-12-01 00:00:00
2020-12-02 00:00:00
2020-12-03 00:00:00
2020-12-04 00:00:00
2020-12-05 00:00:00
2020-12-06 00:00:00
2020-12-07 00:00:00
2020-12-08 00:00:00
2020-12-09 00:00:00
2020-12-10 00:00:00
2020-12-11 00:00:00
2020-12-12 00:00:00
2020-12-13 00:00:00
2020-12-14 00:00:00
2020-12-15 00:00:00
2020-12-16 00:00:00
2020-12-17 00:00:00
2020-12-18 00:00:00
2020-12-19 00:00:00
2020-12-20 00:00:00
2020-12-21 00:00:00
2020-12-22 00:00:00
2020-12-23 00:00:00
2020-12-24 00:00:00
2020-12-25 00:00:00
2020-12-26 00:00:00
2020-12-27 00:00:00
2020-12-28 00:00:00
2020-12-29 00:00:00
2020-12-30 00:00:00
2020-12-31 00:00:00
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
2021-01-07 00:00:00
2021-01-08 00:00:00
2021-01-09 00:00:00
2021-01-10 00:00:00
2021-01-11 00:00:00
2021-01-12 00:00:00
2021-01-13 00:00:00
2021-01-14 00:00:00
2021-01-15 00:00:00
2021-01-16 00:00:00
2021-01-17 00:00:00
2021-01-18 00:00:00
2021-01-19 00:00:00
2021-01-20 00:00:00
2021-01-21 00:00:00
2021-01-22 00:00:00
2021-01-23 00:00:00
2021-01-24 00:00:00
2021-01-25 00:00:00
2021-01-26 00:00:00
2021-01-27 00:00:00
2021-01-28 00:00:00
2021-01-29 00:00:00
2021-01-30 00:00:00
2021-01-31 00:00:00
2021-02-01 00:00:00
2021-02-02 00:00:00
2021-02-03 00:00:00
2021-02-04 00:00:00
2021-02-05 00:00:00
2021-02-06 00:00:00
2021-02-07 00:00:00
2021-02-08 00:00:00
2021-02-09 00:00:00
2021-02-10 00:00:00
2021-02-11 00:00:00
2021-02-12 00:00:00
2021-02-13 00:00:00
2021-02-14 00:00:00
2021-02-15 00:00:00
2021-02-16 00:00:00
2021-02-17 00:00:00
2021-02-18 00:00:00
2021-02-19 00:00:00
2021-02-20 00:00:00
2021-02-21 00:00:00
2021-02-22 00:00:00
2021-02-23 00:00:00
2021-02-24 00:00:00
2021-02-25 00:00:00
2021-02-26 00:00:00
2021-02-27 00:00:00
2021-02-28 00:00:00
2021-03-01 00:00:00
2021-03-02 00:00:00
2021-03-03 00:00:00
2021-03-04 00:00:00
2021-03-05 00:00:00
2021-03-06 00:00:00
2021-03-07 00:00:00
2021-03-08 00:00:00
2021-03-09 00:00:00
2021-03-10 00:00:00
2021-03-11 00:00:00
2021-03-12 00:00:00
2021-03-13 00:00:00
2021-03-14 00:00:00
2021-03-15 00:00:00
Spreadsheet: 100181d1298593551-conditional-formatting-test_master-sheet2
Sheet: Measures -December 2010

 | MEASURES DASHBOARD- MASTER
 |  |  |  |  | 2011-02-01 00:00:00
 |  | Measure | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | Target | % Var From Target | Traffic light | Notes - Explanation / Mitigation | Historical Chart
 |  | Area - CUSTOMER
 |  | Percentage of projects reporting green status
 |  | All projects | 0.72 | 0.77 | 0.8 | -0.03750000000000003 | Y | 0 |  |  |  |  |  | 0
 |  |  | 0.72 | 0.77
Spreadsheet: 105346d1302722607-lookup-match-formula-match-lookup
Sheet: Sheet2

DOB | Plan Code
 | 4WY
 | 1CG
Return all 3 on the next sheet ---> | 1CL
 | 1EB
 | 1GR
 | 1GV
 | 1KH
 | 1LR
 | 1LZ
 | 1QQ
 | 1QZ
 | 1RF
 | 14B
 | 5PL
 | 5TJ
 | 5TN
 | 7K1
Return both on data sheet----> | 7K5
 | 9D2
 | 9P8
 | 9T6
 | 8M8
 | 1CH
 | 1CM
 | 1GN
 | 1GS
 | 1JG
 | 1KJ
 | 1LS
 | 1MB
 | 1QT
 | 1RB
 | 1RK
 | 24C
 | 5PM
 | 5TK
 | 7J7
 | 7K2
 | 9Q3
 | 9P5
 | 9P9
 | 9T7
 | 1LL
 | 1CJ
 | 1CN
 | 1GP
 | 1GT
 | 1JJ
 | 1LM
 | 1LT
 | 1MC
 | 1QU
 | 1RC
 | 1RL
 | 24D
 | 5PN
 | 5TL
 | 7J8
 | 7K3
 | 9C9
 | 9P6
 | 9Q1
 | 9TP
 | 1CF
 | 1CK
 | 1DY
 | 1GQ
 | 1GU
 | 1KG
 | 1LQ
 | 1LY
 | 1QP
 | 1RD
 | 1RM
 | 5PK
 | 5TH
 | 5TM
 | 7J9
 | 7K4
 | 9D1
 | 9PK
 | 9Q2
 | 9U1
Spreadsheet: 835557d1688655723-search-and-return-multiple-results-example-search-aligw
Sheet: Blad1

# | [NAME] |  | AliGW
5.01 | Search for value A2 in 'column C' on 'sheet2' and return the corresponding value located in 'column A' on 'sheet2'. If multiple values are found, they will be concatenated together.
5.02
5.03
5.04
5.05
5.06
5.07
5.08
5.09
5.10
5.11 | Code of Conduct
5.12
5.13
6.01 | Code of Conduct
6.02 | Code of Conduct
6.03
6.04
6.05 | Code of Conduct,  Policy - Compliance
6.06
6.07
6.08
6.09
6.10
6.11
6.12
6.13
6.14
6.15
6.16
6.17
6.18
6.19
6.20
6.21
6.22
6.23
6.24
6.25
6.26
6.27
6.28
6.29
6.30
6.31
6.32
6.33
6.34
6.35
6.36
6.37
6.38
6.39
6.40
6.41 | Policy - Signatures and Approval Limits
6.42
6.43
6.44
7.01
7.02
7.03
7.04
7.05
7.06
7.07
7.08
7.10
8.01
8.02
8.03
8.04
8.05
8.06
8.07
9.01
9.02
9.03 | Code of Conduct
9.04
9.05
Spreadsheet: 202562d1356629138-offset-match-vs-index-match-example
Sheet: FINAL

 | First American Home Buyers Protection Corp
 | Rolling Forecast Template model
 | Profit level rollup
 |  | Quarter | 1 | 1 | 1 | 2 | 2 | 2
 |  | Month | 1 | 2 | 3 | 4 | 5 | 6
 |  | Year | 2010 | 2010 | 2010 | 2010 | 2010 | 2010
 |  | Actual/estimate | Actual | Actual | Actual | Actual | Actual | Actual
S | R |  | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00
[NAME] | 1 | Total Openings 000s
 | 1.01 | West Division (Kathy)
 | 1.21 | Eastern Division (Trae)
 | 1.22 | FAHWC (Trae)
 | 1.23 | Subtotal Eastern Div'n (Trae) incl. FAHWC
 | 1.4 | Central Division (Suzan)
 | 1.55 | W/MW/NW Division (Myrna)
 | 1.56 | Alliance (Myrna)
 | 1.57 | Subtotal Myrna
 | 1.6 | House accounts, other
Spreadsheet: 760988d1640591187-formula-to-perform-match-and-if-condition-exists-to-insert-hyphen-between-two-last-names-example
Sheet: Sheet1

[NAME] | Full name
Parkersmith | last name
Wanted Result Below:
[NAME] | Full name
Jordanrandall | last name
Wanted Result Below:
[NAME] | Full name
Doe | last name
Wanted Result  Below
[NAME]
Doe Dea Da
Wanted Result  Below
Spreadsheet: cfebcfa6-3339-4948-92f8-b3b6613a0a98
Sheet: Sheet1

Successful BSW Course Planning | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
1.  Complete ENGL 1301 & 1302, MATH 1301 or 1302, POLS 2311, SOCI 1311, SOCW 2311 & 2313, PSYC 1315.
 | Once a total of 40 credit hours are completed including the above mentioned courses,
 | you can apply to the BSW program.
2.  To be accepted into the BSW program:
 | *  Complete 40 credit hours including the above listed courses (at least 12 hrs in residency at UTA)
 | *  Keep your overall GPA at 2.5 or better (UTA courses).
 | *  Receive a 'C' or better in SOCW 2311 & 2313.
 | *  See your advisor and request application for BSW program.
3.  To remain in good standing in the BSW program:
 | *  Before you take SOCW 3304, complete all 1000 & 2000 level courses including SOCW 2311 & SOCW 2313,
 | and 3000 level courses including SOCW 3301 and either 3302 or 3303.
 | *  Keep your overall GPA at 2.5 or better (UTA courses), with a 2.5 average in all SOCW
 | courses, and no SOCW course grade lower than a C.
4.  Field Placement (SOCW 4251 & 4451, 4252 & 4452):
 | *  Attend a field placement ingormation meeting one semester prior to beginning your placement.
 | *  SOCW 4251 & 4451 are taken the same semester; 4252 & 4452 are taken the following.
 | semester.
 | *  You should enroll in Field your last two semesters at UTA.  You will be providing 240 hours
 | per semester in a social service agency, along with attending a weekly  2 hour Field Seminar
 | class at UTA.
 | *   If you are on a child welfare stipend, you will do a Block Placement (combining 4251, 4451, 4252 & 4452)
 | your LAST semester at UTA.  This is done only through the Child Welfare Office.  It is training for
 | CPS work.
 | Suggested Course Sequence:
 |  |  |  | First Year
 | First Semester |  | ENGL 1301; HIST 1311; BIOL 1433; SOCI 1311; MATH 1301, or MATH 1302
 |  |  | Total Credit 16 hours
 | Second Semester |  | ENGL 1302; HIST 1312; BIOL 1434; PSYC 1315;
 |  |  | MATH 1308 - total Credit 16 hours
 |  |  |  | Second Year
 | First Semester |  | ENGL 3 hours; POLS 2311; SPAN 1441; FINE ARTS 3 hours;
 |  |  | SOCW 2311; Total Credit 16 hours
 | Second Semester |  | SOCW 2313; ENGL 3 hours; POLS 2312; SPAN 1442; SPCH 1301;
 |  |  | Total Credit 16 hours |  | (Apply for major this semester)
 |  |  |  | Third Year
 | First Semester |  | SOCW 3301; SOCW 3303; SOCW 3304; SPAN 2313;
 |  |  | Any 3 hr. ECON course (ECON 2337 recommended) - Total Credit 15 hours
 | Second Semester |  | ANTH 3 hours; SOCW 3302; SOCW 3305; SOCW 3306; Any upper
 |  |  | level (3000+) PSYC course  - Total Credit 15 hours
 |  |  |  | Fourth Year
 | First Semester |  | SOCW 3317; SOCW 4251 and 4451; Any 3 hr. Technology course.
 |  |  | Electives 3 hrs. Total Credit 15 hours
 | Second Semester |  | SOCW 4252 AND 4452; Electives 5 hours;
 |  |  | Total Credit 11 hours
School of Social Work Program
Box 19129, Arlington, Texas  76019-0129
phone: (817) 272-3647
email:  [EMAIL]
homepage:  http://www2.uta.edu/ssw/bsw
Spreadsheet: 09e510b1-0709-4ed0-99c3-87e72129b0ad
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | 2013-14 GSHOM Registrar's Summary Form | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17
 | Area Number: |  |  |  |  |  | Area Registrar: |  |  |  |  |  |  |  | Date:
 |  |  |  |  |  |  |  | Troop Summary
 | Date | Receipt # | Troop # | # of Girls | X $25 | # of Adults | X $15 | Total Owed |  | [NAME] | Subtotal | Contributions | Total  Enclosed | Cash | Checks | Credit Cards | Total  Enclosed
 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Totals | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | revised 4/19/13 tm
Spreadsheet: 860579d1708617537-using-if-and-vlookup-vlookup-if-statment
Sheet: Sheet1

1 | 1
2 | 2
3 | 3
4 | 30
5 | 31
6 | 32
7 | 33
8 | 34
9 | 35
10 | 36
11 | 37
12 | 38
13 | 10
14 | 15
15 | 17
16 | 99
17 | 555