tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 136006d1326365902-need-a-macro-for-compare-and-copy-data-from-one-sheet-to-another-sheet-in-excel-copydata
Sheet: Sheet3

ID | Name | Title | Comments | Request Type | Impacted Area | Impacted Sub Area | Description | Request Number
1 | aaa | asfd |  | AAA | Core |  | xxxx | 101
2 | bb | sdafdsf |  | AAA | Core |  | xxxx | 102
3 | cc | dsafds |  | AAA | Core |  | xxxx | 103
4 | dd | zfdsf |  | AAA | Core |  | xxxx | 104
5 | ee | sdfsdf |  | BB | Core |  | xxxx | 105
6 | ff | sdfsd |  | VV | Core |  | xxxx | 106
7 | gg | sdafdsf |  | BB | Core |  | xxxx | 107
8 | hh | sdfsd |  | BB | auto |  | xxxx | 108
9 | kk | sdfsd |  | CC | auto |  | xxxx | 109
10 | ll | sdfds |  | DD | auto |  | xxxx | 110
11 | ert | gfdsgdf |  | FF | auto |  | xxxx | 111
12 | dfsgdf | [NAME] |  | GG | auto |  | xxxx | 112
13 | fgfd | fdgdsf |  | FF | auto |  | xxxx | 113
14 | dfghf | fdsgdf |  | GG | auto |  | xxxx | 114
Spreadsheet: 887683d1737992201-find-and-sort-nearest-date-testing
Sheet: Entry

Date | ID | Member [NAME] | Monthly Contribution | Category | Helper |  | 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 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00
2025-01-01 00:00:00 | M001 | Nutan Vishal Bhagare | 500 |  |  | Prev Cash in Hand
2025-01-01 00:00:00 | M002 | Suvarna N Gaikwad | 500 |  |  | Contribution
2025-01-01 00:00:00 | M003 | Rajjaka A Waghmode | 500 |  |  | Intest
2025-01-01 00:00:00 | M004 | Surkekha A Kirgat | 500 |  |  | Late Fee
2025-01-01 00:00:00 | M005 | Kamble | 500 |  |  | Late Intest
2025-01-01 00:00:00 | M006 | [NAME] | 500 |  |  | [NAME]
2025-01-21 00:00:00 | M007 | [NAME] | 500 |  |  | Expencess
2025-01-01 00:00:00 | M008 | Sunita R Madne | 500 |  |  | Total
2025-01-01 00:00:00 | M009 | [NAME] | 500 |  |  | Bank Balance
2025-01-01 00:00:00 | M010 | [NAME] | 500 |  |  | Loan Amount
2025-01-21 00:00:00 | L001 | Nutan Vishal Bhagare | 4282 |  |  | Cash in Hand
2025-01-26 00:00:00 | L001 | Nutan Vishal Bhagare
2025-01-27 00:00:00 | L001 | Nutan Vishal Bhagare
2025-01-01 00:00:00 | Loo1 | Nutan Vishal Bhagare | 200
2025-01-02 00:00:00 | L001 | [NAME]
 | E011
Spreadsheet: 47242d1246227231-formatting-tables-new
Sheet: Sheet1

Table One
 | 4 | 3 | 2 | 1
1000 | 7.5-7.79 | 7.8-8.09 | 8.1-8.24 | >8.25
1200 | 8.7-8.79 | 8.8-9.14 | 9.15-9.29 | >9.3
1400 | 9.5-9.59 | 9.6-9.99 | 10-10.24 | >10.25
1600 | 9.7-9.84 | 9.85-10.29 | 10.3-10.49 | >10.5
1800 | 9.3-9.49 | 9.5-9.64 | 9.65-9.79 | >9.8
2200 | 10.6-10.74 | 10.75-10.99 | 11-11.19 | >11.2
2400 | 10.7-10.89 | 10.9-11.04 | 11.05-11.34 | >11.35
2850 | 11.77-11.79 | 11.8-12.09 | 12.1-12.49 | >12.5
3200 | 11.5-11.59 | 11.6-11.89 | 11.9-12.14 | >12.15
Table Two |  |  |  |  |  |  |  |  |  |  | Table Three
 | 1000 | 1200 | 1400 | 1600 | 1800 | 2200 | 2400 | 2850 | 3200 |  |  | 1000 | 1200 | 1400 | 1600 | 1800 | 2200 | 2400 | 2850 | 3200
Fast |  | 8.98 |  | 10.29 |  | 11.24 | 11.45 | 12.42 |  |  | Fast
Firm |  |  | 9.95 | 10.18 | 9.64 | 11.24 | 11.45 | 12.42 |  |  | Firm
Good | 7.66 | 8.95 |  |  |  |  | 11.16 | 12.05 |  |  | Good
Yield |  |  |  |  |  |  | 10.84 |  |  |  | Yield
Mud |  |  | 9.72 |  |  |  | 11.22 | 12.18 |  |  | Mud
Soft |  | 8.97 | 9.72 | 10.12 |  | 11.13 | 11.32 | 12.35 |  |  | Soft
The above charts are what i currently have, and below is the type of thing i am looking for if possible.
Thanks
G
Table Two |  |  |  |  |  |  |  |  |  |  | Table Three
 | 1000 | 1200 | 1400 | 1600 | 1800 | 2200 | 2400 | 2850 | 3200 |  |  | 1000 | 1200 | 1400 | 1600 | 1800 | 2200 | 2400 | 2850 | 3200
Fast |  | 8.98 |  | 10.29 |  | 11.24 | 11.45 | 12.42 |  |  | Fast |  | 3 |  | 3 |  | 1 | 1 | 2
Firm |  |  | 9.95 | 10.18 | 9.64 | 11.24 | 11.45 | 12.42 |  |  | Firm |  |  | 3 | 3 | 3 | 1 | 1 | 2
Good | 7.66 | 8.95 |  |  |  |  | 11.16 | 12.05 |  |  | Good | 4 | 3 |  |  |  |  | 2 | 3
Yield |  |  |  |  |  |  | 10.84 |  |  |  | Yield |  |  |  |  |  |  | 4
Mud |  |  | 9.72 |  |  |  | 11.22 | 12.18 |  |  | Mud |  |  | 3 |  |  |  | 2 | 2
Soft |  | 8.97 | 9.72 | 10.12 |  | 11.13 | 11.32 | 12.35 |  |  | Soft |  | 3 | 3 | 3 |  | 2 | 2 | 2
Spreadsheet: 130265d1322145657-pivot-grand-total-book1
Sheet: Sheet1

Original data
Year | Spend
2010 | 25
2010 | 26
2010 | 27 |  |  |  |  |  | Column Labels
2011 | 28 |  |  |  |  |  | 2011 | 2010 | Grand Total
2011 | 29 |  |  |  |  | Sum of Spend | 87 | 78 | 165 | Change 165 to a difference between 2011 and 2010.
2011 | 30
My solution
Year | Spend | 2010 | 2011 |  |  | Sum of 2011 | Sum of 2010 | Difference
2010 | 25 | 25 |  |  |  | 87 | 78 | 9 | Calculated field to get the difference
2010 | 26 | 26
2010 | 27 | 27
2011 | 28 |  | 28
2011 | 29 |  | 29
2011 | 30 |  | 30
Spreadsheet: 863032d1710594602-how-to-insert-row-and-keep-all-the-data-together-sample
Sheet: Sheet2

 |  |  | Color |  |  |  |  |  |  | [NAME] | Blue
 |  |  |  |  |  |  |  |  |  | [NAME] | Gray
 |  |  |  |  |  |  |  |  |  | Michelle | [NAME]
 |  |  |  |  |  |  |  |  |  | [NAME] | Green
 |  |  |  |  |  |  |  |  |  | [NAME] | Pink
Spreadsheet: 599739d1543288352-budget-array-formula-lookup-pulling-transactions-in-wrong-order-budget-array-formula-lookup-pulling-transactions-in-wrong-order
Sheet: Budget

 |  | Fortnightly Budget
 |  |  | Income |  |  |  | Expenses |  |  |  | Bills
 |  |  |  | Primary | 1702.5 |  |  | Groceries | 200 |  |  | Rent | 780
 |  |  |  | Secondary | 586.11 |  |  | Savings | 200 |  |  | ZipPay | 200
 |  |  |  | Meal Card | 100 |  |  | Going out | 200 |  |  | Fines | 150
 |  |  |  |  |  |  |  | Shopping | 100 |  |  | Tax Debt | 100
 |  |  |  |  |  |  |  | Transport | 15 |  |  | Internet | 39.975
 |  |  |  |  |  |  |  |  |  |  |  | Electricity
 |  |  |  |  |  |  |  |  |  |  |  | Water
 |  |  |  |  |  |  |  |  |  |  |  | Gas
 |  |  |  |  |  |  |  |  |  |  |  | Phone | 4
 |  |  |  |  |  |  |  |  |  |  |  | AfterPay | 0
 |  |  |  | Total |  |  |  | Total |  |  |  | Total
 |  |  | Top 5 Expenses this fortnight
 |  |  |  |  |  |  |  |  |  |  | If sorted by amount, this row should be 3rd
 |  |  |  |  |  |  |  |  |  |  | and this one should be 4th
 |  | Fortnightly Pay & Expenses Summary
 |  |  | Week Begin | Week End | Income | Expenses | Groceries | Transport | Going Out | Savings | Shopping | Bills
 |  |  |  | 2018-10-25 00:00:00 | 2398.23 | -862.51 | -312.47 | -15 | -310.04 | -200 | -25 | -1536.71
 |  |  |  |  | 2775.29 | -1681.21 | -139.67 | -30 | -741.7200000000003 | -200 | -569.82 | -1321.17
 |  |  |  |  | 2398.23 | -631.7800000000001 | -22.65 | -35 | -349.13 | -150 | -75 | -1295.99
Spreadsheet: 851408d1701649862-extract-multiple-dates-with-different-format-into-a-new-column-sample-date
Sheet: New 

CANCPenOrgDetails | Specimen_Collection_Date |  | CANCPenOrgDetails | [NAME]
pseudomonas aeruginosa           .05/27/2022 | 2022-05-27 00:00:00 |  | pseudomonas aeruginosa           .05/27/2022 | 2022-05-27 00:00:00
CR-AB, 6/10/22 | 2022-06-10 00:00:00 |  | CR-AB, 6/10/22 | 2022-06-10 00:00:00
CRE, CR-PA |  |  | CRE, CR-PA
MRSA           .11/25/2021 | 2021-11-25 00:00:00 |  | MRSA           .11/25/2021 | 2021-11-25 00:00:00
CRE- SPUTUM           .11/26/2021 | 2021-11-26 00:00:00 |  | CRE- SPUTUM           .11/26/2021 | 2021-11-26 00:00:00
CRP PSEUDOMONAS           .02/20/2021 | 2021-02-20 00:00:00 |  | CRP PSEUDOMONAS           .02/20/2021 | 2021-02-20 00:00:00
Psuedomonas           .02/25/2022 | 2022-02-25 00:00:00 |  | Psuedomonas           .02/25/2022 | 2022-02-25 00:00:00
Escherichia coli 10/9/2021 | 2021-10-09 00:00:00 |  | Escherichia coli 10/9/2021 | 2021-10-09 00:00:00
05/10/2022 | 2022-05-10 00:00:00 |  | 05/10/2022 | 2022-05-10 00:00:00
pseudomonas aeruginosa           .06/14/2022 | 2022-06-14 00:00:00 |  | pseudomonas aeruginosa           .06/14/2022 | 2022-06-14 00:00:00
KPC URINE 6/9/22 | 2022-06-09 00:00:00 |  | KPC URINE 6/9/22 | 2022-06-09 00:00:00
pseudomonas aeruginosa           .06/14/2022 | 2022-06-14 00:00:00 |  | pseudomonas aeruginosa           .06/14/2022 | 2022-06-14 00:00:00
[NAME] at Kindred BP |  |  | [NAME] at Kindred BP
KLEBSIELL APNEUMONIAE           .01/19/2022 | 2022-01-19 00:00:00 |  | KLEBSIELL APNEUMONIAE           .01/19/2022 | 2022-01-19 00:00:00
CRE           .. |  |  | CRE           ..
CRAB and PSA CR           .05/04/2022 | 2022-05-04 00:00:00 |  | CRAB and PSA CR           .05/04/2022 | 2022-05-04 00:00:00
[NAME]           .06/15/2022 | 2022-06-15 00:00:00 |  | [NAME]           .06/15/2022 | 2022-06-15 00:00:00
CRAB           .05/10/2022 | 2022-05-10 00:00:00 |  | CRAB           .05/10/2022 | 2022-05-10 00:00:00
CRAB and PSA CR           .05/04/2022 | 2022-05-04 00:00:00 |  | CRAB and PSA CR           .05/04/2022 | 2022-05-04 00:00:00
CARBAPENEM RESISTANT PSEUDOMONAS AERUGINOSA           .07/26/2022 | 2022-07-26 00:00:00 |  | CARBAPENEM RESISTANT PSEUDOMONAS AERUGINOSA           .07/26/2022 | 2022-07-26 00:00:00
CRE           .07/23/2022 | 2022-07-23 00:00:00 |  | CRE           .07/23/2022 | 2022-07-23 00:00:00
pseudomonas, 8/3/22 | 2022-08-03 00:00:00 |  | pseudomonas, 8/3/22 | 2022-08-03 00:00:00
Spreadsheet: 91643d1291313639-formula-to-change-sheet-number-when-dragged-master-list-template-
Sheet: D282

AI Eval # | AI # | MDCR # | TER # | DAJIC # | QA Audit Finding # | Orig. Dept | Subject/Project Name/Comments/Update Information | Product Line | Affected Manual(s) | ATA Code | Section | Task No. | Submitter Name | Submitter Phone # | [NAME] | Submission Year | Submission Date | Date Rec'd | Date Reviewed | MDCR Level 1 - 2 - 3 (TOPP 20-40-05) | Unacceptable (STOP) | Acceptable (GO) | Date to WPR Task List | Date Reassigned | Task Owner | EA # | EA REV | Date to Approver | Date to ORT | ORT Approval Date | MDCR Approval Date By [NAME] | ER/A Approval Date / MDCR Approval Date from Tech Pubs | WPR Completion Date | Request QTY | Completed QTY | Not Completed QTY |  | No. Days Submission to WPR Inbox | No. Days WPR Inbox to Review | No. Days Review to Task List Entry | No. Days Task List Entry to Re-assignment | No. Days Re-assignment to Approver | No. Days Approver to ORT Review | No. Days ORT Review to Approval | No. Days MDCR Approval by [NAME] | No. Days ER/A Approval / MDCR Approval from Tech Pubs | No. Days Approval to WPR Completion | No. Days submit for approval to Completion | No. Days WPR Inbox to WPR Completion | No. Days Submission to WPR Completion | Inbox to  Reassignment | Submit for Approval to Completion
Entry Rows
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | No ORT | No ORT | 0 | 0 | not complete | not complete | 0 | 0 | 0 | not submitted for approval
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | No ORT | No ORT | 0 | 0 | not complete | not complete | 0 | 0 | 0 | not submitted for approval
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | No ORT | No ORT | 0 | 0 | not complete | not complete | 0 | 0 | 0 | not submitted for approval
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | No ORT | No ORT | 0 | 0 | not complete | not complete | 0 | 0 | 0 | not submitted for approval
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | No ORT | No ORT | 0 | 0 | not complete | not complete | 0 | 0 | 0 | not submitted for approval
282 Tasks
2011 | Task List
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | No ORT | No ORT | 0 | 0 | not complete | not complete | 0 | 0 | 0 | not submitted for approval
2011 | Task Status |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA
Spreadsheet: 41179d1239707317-change-x-axis-to-y-axis-and-vice-versa-book2
Sheet: Sheet1

Month | 1 hr | 2 hr | 3 hr
jan | 23 | 23 | 54
feb | 45 | 35 | 4
[NAME] | 56 | 56 | 23
apr | 67 | 67 | 456
may | 78 | 78 | 78
Spreadsheet: 865503d1712581180-hash-with-sha256-email-and-phone-list-test_hash
Sheet: TEST

[NAME] | Phone Number | Conversion Name | Conversion Time | Conversion Value | Conversion Currency | Ad User Data | Ad Personalization
[EMAIL] | 755466212 |  | 2024-02-26 11:31:54 | 0 | RON | Granted | Granted
[EMAIL] | 755466213 |  | 2024-02-26 11:31:54 | 0 | RON | Granted | Granted
[EMAIL] | 755466214 |  | 2024-02-26 11:31:54 | 0 | RON | Granted | Granted
Spreadsheet: 139423d1328233313-need-an-equation-to-index-match-based-on-a-criteria-within-another-equation-index-plus-percent
Sheet: Sheet1

Dollars | w/ Benefit | Week # | Final Cost |  |  |  |  |  | Week |  | Bonus
450 | 535.5 | 1 | 596.1111111111111 |  |  |  |  |  |  |  | Bonus By Week | Bonus PP
450 | 535.5 | 1 | 585 |  |  |  |  |  | Week | 1 | 250 | 5
450 | 535.5 | 2 | 585 |  |  |  |  |  | Week | 2 | 1000 | 15
450 | 535.5 | 2 | 585 |  |  |  |  |  | Week | 3 | 500 | 7.5
450 | 535.5 | 3 | 585 |  |  |  |  |  | Week | 4 | 750 | 10
450 | 535.5 | 3 | 585 |  |  |  |  |  | Week | 5 | 1000 | 15
324 | 385.56 | 4 | 421.2 |  |  |  |  |  | Week | 6 | 250 | 5
324 | 385.56 | 4 | 421.2
324 | 385.56 | 5 | 421.2
324 | 385.56 | 5 | 421.2
324 | 385.56 | 6 | 421.2
Spreadsheet: 864866d1711995712-sum-single-vs-combined-cell-values-test
Sheet: Master

 |  |  | These  columns pull data in from another sheet so there's technically no "blank" cells where cells are empty
 | Tag | Tag Number | Group |  | Room |  |  |  |  |  |  |  |  |  |  | Area/room | Area/Group
 | ABC-XX- |  | Column pulling in from another spreadsheet |  | Column pulling in from another spreadsheet |  |  |  |  |  |  |  |  |  |  | Column pulling in from another spreadsheet | sums based off the rooms in the group, column D | in the summary tab, I want to see the green highlighted cells and not the red all in one column based off column C (concat tag)
 | 1 |  | [NAME] |  | RR 1 |  |  |  |  |  |  |  |  |  |  | 100
 | 5 |  | C1 |  | Bed 1 |  |  |  |  |  |  |  |  |  |  | 200
B7 remains blank unless a user inputs a value |  |  |  |  | Bed 2 |  |  |  |  |  |  |  |  |  |  | 250
 | 2 |  | G20 |  | Patio |  |  |  |  |  |  |  |  |  |  | 500
 | 3 |  | G9 |  | Living |  |  |  |  |  |  |  |  |  |  | 300
 | 15 |  | B9 |  | Dining |  |  |  |  |  |  |  |  |  |  | 300
B14 remains blank unless a user inputs a value |  |  |  |  | Powder |  |  |  |  |  |  |  |  |  |  | 50
B15 remains blank unless a user inputs a value |  |  |  |  | Kitchen |  |  |  |  |  |  |  |  |  |  | 350
 | 4 |  | G21 |  | Study |  |  |  |  |  |  |  |  |  |  | 150
 | 6 |  | A4 |  | Dining |  |  |  |  |  |  |  |  |  |  | 300
[NAME] remains blank unless a user inputs a value | 13 |  |  |  | Powder |  |  |  |  |  |  |  |  |  |  | 50
B21 remains blank unless a user inputs a value | 12 |  |  |  | Kitchen |  |  |  |  |  |  |  |  |  |  | 350
in this case, 13 and 12 were assigned because it was decided that this group of rooms should be broken up into 3 tag numbers instead of 1 but still be in the same group A4  therefor in the summary sorted tab, instead of showing me the area of the group, it should show me the area per room in this group
Spreadsheet: 220043d1363038876-help-extracting-certain-portion-of-a-cell-pendingtransactions-template
Sheet: Transactions

Pending Deposits
Printed: 07 March 2013
Date Range: 06/03/2013 and 06/03/2013.
Report filtered for all records
Date | Customer | Tender ID | Details |  | Amount
Card Payment
06/03/2013 | Hawkins, [NAME] | 28300 | [NAME]  (06/2015) |  | 117.6
06/03/2013 | [NAME], [NAME] | 28339 | Delta Number - 4567 2701 9878 8364  (11/2013) |  | 72
06/03/2013 | Sweeney, [NAME] | 28355 | Delta Number - 5420 1138 3444 2425  (04/2014) |  | 90
06/03/2013 | [NAME], [NAME] | 28340 | VISA Number - 4929 5556 4171 9999  (03/2017) |  | 219.6
Spreadsheet: 258501d1376687545-complex-vacation-accural-formula-script-needed-vacation-master-log-3-
Sheet: Allocations

Employee | Hire Date | Years at Company | Number of Vacation Days  This Year | Number of Weeks This Year | email | Holiday year start | Requested | Remaining | 2013-10-16 00:00:00 | Comparison Date Ctrl + ; = today
A Daza | 2005-11-11 00:00:00 |  |  |  | [EMAIL]
A [NAME] | 2006-12-01 00:00:00 |  |  |  | [EMAIL]
B Ghazi | 2012-10-29 00:00:00 |  |  |  | [EMAIL]
B [NAME] | 2012-11-05 00:00:00 |  |  |  | [EMAIL]
D King | 2012-01-12 00:00:00 |  |  |  | [NAME]
D Kosen | 1994-04-01 00:00:00 |  |  |  | [EMAIL]
[NAME] | 2012-05-14 00:00:00 |  |  |  | [EMAIL]
J [NAME] | 2013-01-07 00:00:00 |  |  |  | [EMAIL]
[NAME] | 2013-02-25 00:00:00 |  |  |  | [NAME]
L Farris | 2012-01-09 00:00:00 |  |  |  | [EMAIL]
P Soh | 1996-06-01 00:00:00 |  |  |  | [EMAIL]
P [NAME] | 2011-07-11 00:00:00 |  |  |  | [EMAIL]
S Wachtel | 1997-03-01 00:00:00 |  |  |  | [EMAIL]
T Ghazalie | 1995-07-01 00:00:00 |  |  |  | [EMAIL]
T Newton | 2008-05-19 00:00:00 |  |  |  | [EMAIL]
T Santoso | 2003-10-01 00:00:00 |  |  |  | [EMAIL]
I [NAME] | 2009-10-03 00:00:00 |  |  |  | [EMAIL]
Spreadsheet: 04088f62-96ee-4e4e-937f-a372049b318b
Sheet: Travel Claim Form

 |  |  |  |  |  |  |  |  |  |  | FOAPAL INFORMATION
 |  | Tennessee Tech University |  |  |  |  |  |  |  |  | COAS CODE:
 |  |  |  |  |  |  |  |  |  |  | INDEX CODE:
 |  | Claim For Traveling Expenses |  |  |  |  |  |  |  |  | FUND CODE:
 |  |  |  |  |  |  |  |  |  |  | ORGAN CODE:
 |  |  |  |  |  |  |  |  |  |  | ACCT CODE:
 |  |  | For Period From: |  |  | To |  |  |  |  | PROGRAM CODE:
 |  |  |  |  |  |  |  |  |  |  | ACTIVITY CODE:
 |  |  |  |  |  |  |  |  |  |  | Requisition Number:
Please Note: This claim must be prepared in accordance with the Tennessee Tech General Travel Policies and Procedures.  You should be able to obtain a copy of these policies and procedures from your respective
Administrative Officer, [NAME], Department Chair, or Director.
 |  |  |  |  | Transportation |  |  | Subsistence |  |  |  | Other Expenses
 |  | Time |  | Time |  | Mileage | Ticket |  | [NAME]
Date | Place Left | Left | Place Arrived | Arrived | [NAME] | Amount | Amount | Hotel | fast | Lunch | Dinner | Itemize and Explain |  | TOTAL
List trip related Procard transactions below ----------These are not listed in the total for reimbursement
Date | P card Vendor | Description |  |  | Amount |  |  | Reallocated to Travel
 |  |  |  |  |  |  |  | Yes   /   No |  |  |  | Do Not Carry Procard Charges to this Section
 |  |  |  |  |  |  |  | Yes   /   No |  |  |  | Procard Charges are not Reimbursed
 |  |  |  |  |  |  |  | Yes   /   No
 |  |  |  |  |  |  |  | Yes   /   No
 |  |  |  |  |  |  |  | Yes   /   No
Total Procard Charges on Trip
 |  |  |  |  |  |  |  |  | I certify that the expenses claimed were for a business purpose and to the best of my knowledge, comply with TBR Travel Policy.
Purpose of trip:
 |  |  |  |  |  |  |  |  | Claimant                          T-Number/Banner ID |  |  |  | Position
If accompanied by university employee, please list
 |  |  |  |  |  |  |  |  | Approved:
Method of Travel |  |  |  |  |  |  |  |  | Administrative Officer/Dean of College or School
 |  | University Car - Personal Car - Bus - Plane
 |  |  |  |  |  |  |  |  | Vice President for Business and Fiscal Affairs
Spreadsheet: 125eee9e-a660-4a34-af0f-4637e8d95f59
Sheet: Main

 | This Excel Sheet will be available on the ITS Online site after the demo
Paste Special
 | Where to find [NAME] Special | Home --> Paste (click down arrow underneath)
 | Paste Special Preview
 | Formats | for copying format into another cell
 | Values | for pasting values instead of formulas
 | Transpose | for rotating your entire table 90 degrees
 | Picture | for pasting into Outlook messages or Word docs
 | Linked Picture | for maintaing formatting and staying updated (same file)
 | Divide | for converting numbers | 95 | 100
 | Add | for a column of numbers stored as text | 1234
Data Entry Time Saving Tips
 | Select all | Ctrl+A, Ctrl+A (TWICE!)
 | Change column and cell widths | Double-click column and row borders
 | Moving up and down quickly | Ctrl + arrow key
 | Selecting ranges | Ctrl + Shift + Arrow key
 | Switch between sheets in same file | Ctrl + PageUp
 |  | Ctrl + PageDown
 | F2 key - edit  active cell | https://goat.law.upenn.edu/cf/lawdirectory/select.cfm?sort=name
 | F2 key twice - arrow keys
 | F2 key - numbers stored as text | 1,015,800
 | F2+ F9 - formula leaves just value
 | All excel keyboard shortcuts | [NAME]
Printing
 | Page [NAME]
 | Page Layout View | View -> Page Layout OR Bottom right corner
 | Headers and Footers
 | Page Break Preview - 100% zoom | Drag page borders, set custom borders
 | Orientation
 | Margins
 | Scale (try 80%)
 | Columns to print at left
 | Center on Page Horizontally / Vertically
 | Rows to print at top
Survey Responses Example
Tasks
 | Count the number of rows with responses, subtract 1 for header
 | Count the number of responses in one column
 | Count the number of responses in more than one column
 | Average only if greater than zero
 | Filtering, Sorting and Conditional Formatting
Mailing List Example
 | Hyperlink to another sheet | Penn Law Directory | Right click or Ctrl-K to edit
Tasks
 | Removing duplicate records (key value) | Data --> Remove Duplicates
 | Split one column into two | Data --> Text to Columns
 | Combining text |  | ="david " & "likes " & "excel "
 | Combining text and formulas |  | ="the weather this winter was great " & 95/100 &"% of the time"
 | Combining with Concatenate formula |  | =CONCATENATE("christine agrees that ",[NAME])
Cleaning up a Worksheet You have Received
Tasks
 | Unmerge Cells
 | Double-click column and row borders
 | Drag wider and taller, then double click borders (if doesn't work 1st time)
Other Tips
 | Bad CAPS |  | =PROPER(B75)
 | LOWERCASE |  | =LOWER(B76)
 | Extra spaces |  | =TRIM(B77)
 | force  multiline cells | Text then alt+enter Other text
Other [NAME]
 | Vlookup | [NAME] |  | =VLOOKUP(C83,Survey!A:C,3,FALSE)
 | Index and Match | [EMAIL] |  | =INDEX(Survey!A:C,MATCH(Main!C84,Survey!C:C,0),1)
 | Dates
 | Now + Today |  | =NOW()
 | Number of days until June 30 |  | ="06/30/2013"-C88
 | Portion of year (today to june 30) / 365 |  | =("06/30/2013"-NOW())/365
 | Week Number (of 52 weeks) |  | =WEEKNUM(NOW(),1)
Survey Example |  |  | [NAME]
Spreadsheet: benjamin_rogers__1221__UAE latest O&M costs from Scott
Sheet: Contract_Staff

Contract & Opns Support Staffing Plan
(US$)
PERMANENT CONTRACT LABOR:
 |  |  | INDIVIDUAL | TOTAL ANNUAL | TOTAL
 | STAFFING | GRADE | [NAME] | SALARIES | BENEFITS | TOTAL
SECURITY GUARDS | 0 | 9
JANITORS | 0 | 10
GROUNDS/GENERAL WORKS | 0 | 10
WAREHOUSE HELPER | 0 | 10
O&M TRAINEES/HELPERS | 0 | 10
CHEMIST HELPER | 0 | 10
TOTAL CONTRACT STAFF
OPERATIONS SUPPORT (duration of 6 months after COD):
 |  | PAYROLL, |  | HOME LEAVE
 | STAFFING | TAX PROT. | PER DIEM | TRAVEL | TOTAL
OPNS SUPPORT PERSONNEL (EXPATS) | 2
TOTAL OPNS SUPPORT STAFF
Spreadsheet: 215754d1361468849-sum-values-between-two-dates-with-certain-criteria-test
Sheet: Sheet1

 | DATE | NAME | VALUE |  |  | GRAND TOTAL
 | 2013-02-01 00:00:00 | Orange | 1 |  |  | Apple
 | 2013-02-01 00:00:00 | Apple | 1 |  |  | Orange
 | 2013-02-15 00:00:00 | Orange | 1 |  |  | Pear
 | 2013-02-18 00:00:00 | Apple | 1
 | 2013-02-20 00:00:00 | Orange | 1 |  |  | TOTAL IN FEB
 | 2013-02-27 00:00:00 | Pear | 1 |  |  | Apple
 | 2013-02-28 00:00:00 | Apple | 1 |  |  | Orange
 | 2013-03-05 00:00:00 | Orange | 1 |  |  | Pear
 | 2013-03-10 00:00:00 | Apple | 1
 | 2013-03-15 00:00:00 | Pear | 1 |  |  | TOTAL IN MAR
 | 2013-04-01 00:00:00 | Orange | 1 |  |  | Apple
 |  |  |  |  |  | Orange
 | DATE |  |  |  |  | Pear
 | FROM | TO | TOTAL
 |  |  |  |  |  | TOTAL IN APR
 |  |  |  |  |  | Apple
 |  |  |  |  |  | Orange
 |  |  |  |  |  | Pear
Spreadsheet: 795820d1662970942-how-to-concatenate-a-range-of-cells-based-on-another-column-book1
Sheet: Sheet1

mankind | i am me
mankind | I am ok
mankind | I am yours
mankind | today is
mankind | work it out
earth | this is great
earth | thanks for all
earth | this is great
earth
earth | this is great
people | they are what
people | who said that
people | lets do it
people | ok you are right