tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 702786d1604523361-change-phrase-to-numbers-sample
Sheet: sample

Course Evaluation Submissions
Survey: Student Online Class - Associate Faculty Evaluation - Number Scaled - Fall 2020
Prepared: Nov 03, 2020 01:38 PM -08:00
Note: High values represent positive responses and low values reflect negative to "not applicable" ones.
 | Term | Course | 1. Ability to use this course to increase my general knowledge and education | 2. [NAME]) and other instructional materials | 3. Amount and types of assigned course work | 4. Explanation of course objectives and grading policies | 5. Timely manner in which the tests and assignments were returned | 6. Knowledge and preparation for online sessions | 7. Ability to motivate student interest and intellectual effort | 8. Encouragement of students to ask questions and participate in online learning activities | 9. Encouragement of individual thinking and differences of opinio | 10. Ability to provide effective online resources | 11. Ability to present ideas and theories clearly | 12. Accessibility for individual communication | 13. Demonstration of sensitivity in working with studetns of diverse racial and ethnic backgrounds sexual orientations, and physical and mental disabilities | 14. Timely manner in which course materials were provided | 15. Please add comments including strengths and/or areas for improvement
 | Fall 2020 Term | ITS101A | 2 Unsatisfactory | 3 Satisfactory | 3 Satisfactory | 3 Satisfactory | 2 Needs Improvement | 5 Excellent | 3 Satisfactory | 2 Needs Improvement | 4 Above Average | 3 Satisfactory | 3 Satisfactory | 2 Needs Improvement | 3 Satisfactory | 2 Needs Improvement | Fair
 | Fall 2020 Term | ITS101A | 2 Needs Improvement | 3 Satisfactory | 1 Unsatisfactory | 2 Needs Improvement | 3 Satisfactory | 5 Excellent | 2 Needs Improvement | 1 Unsatisfactory | 1 Unsatisfactory | 5 Excellent | 4 Above Average | 3 Satisfactory | 2 Needs Improvement | 1 Unsatisfactory | The instructor seems very new at teaching.
 | Fall 2020 Term | ITS101A | 4 Above Average | 4 Above Average | 3 Satisfactory | 3 Satisfactory | 4 Above Average | 4 Above Average | 4 Above Average | 4 Above Average | 2 Needs Improvement | 3 Satisfactory | 4 Above Average | 3 Satisfactory | 4 Above Average | 4 Above Average | Like that my professor is available for tutoring. Only improvement is to update grades faster
 | Fall 2020 Term | ITS101A | 1 Unsatisfactory | 3 Satisfactory | 2 Needs Improvement | 5 Excellent | 5 Excellent | 3 Satisfactory | 2 Needs Improvement | 3 Satisfactory | 1 Unsatisfactory | 4 Above Average | 2 Needs Improvement | 4 Above Average | 1 Unsatisfactory | 3 Satisfactory | N/A
 | Fall 2020 Term | ITS101A | 2 Needs Improvement | 1 Unsatisfactory | 1 Unsatisfactory |  | 5 Excellent | 2 Needs Improvement | 3 Satisfactory | 1 Unsatisfactory | 3 Satisfactory | 4 Above Average | 4 Above Average | 5 Excellent | 2 Needs Improvement | 2 Needs Improvement
Spreadsheet: 844365d1696099435-timesheet-if-hours-worked-is-6-hours-or-more-then-deduct-half-an-hour-workhours-minus-lunch-break
Sheet: Sheet1

Start time | End time | Lunch | Total worktime
 |  |  |  |  | Hit F9 to get new random sample data
Spreadsheet: 55505d1255618507-using-year-and-month-together-example
Sheet: Summary

 | 2009-12-01 00:00:00 |  |  | 2010-01-01 00:00:00 |  |  | 2010-02-01 00:00:00
 | No. of Jobs Opened: | 4 |  | No. of Jobs Opened: | 5 |  | No. of Jobs Opened: | 1
 | No. of Jobs Invoiced: | 0 |  | No. of Jobs Invoiced: | 7 |  | No. of Jobs Invoiced: | 3
 | Percentage of Jobs Invoiced: |  |  | Percentage of Jobs Invoiced: | 1.4 |  | Percentage of Jobs Invoiced: | 3
 | Value of Jobs Invoiced: | 0 |  | Value of Jobs Invoiced: | 90 |  | Value of Jobs Invoiced: | 60
Spreadsheet: 4264ec0d-f848-403a-b4a4-f3aa4ea93e88
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 34. LEASE FINANCE COMMITMENTS, By Purpose: State (SA), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1 . . . [NAME] ; |  |  | Original | A2413927F | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413929K | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413930V | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413931W | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413932X | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413933A | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413934C | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413935F | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413936J | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | Number | FLOW | Month | 1
1.3.5 . . . . . . . - trailers, buses, coaches, other MVs ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413938L | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413939R | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413940X | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413941A | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413942C | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: 106402d1303642380-military-rank-formula-military-rank-example-workbook
Sheet: HHD

HHD
Rank | Last Name | First Name | [NAME] | Duty Status | Remarks |  |  |  | Head Count | 47
MSG |  |  |  | PDY | Assigned | E | Ass
CSM |  |  |  | PDY | Assigned | E | Ass |  | TOTAL OFFICERS | 8
PV2 |  |  |  | PDY | Assigned | E | Ass |  | TOTAL WARRANTS | 2
1LT |  |  |  | PDY | Assigned | O | Ass |  | TOTAL ENLISTED | 37
SSG |  |  |  | PDY | Assigned | E | Ass |  | GRAND TOTAL | 47
SPC |  |  |  | PDY | Assigned | E | Ass
SGT |  |  |  | PDY | Assigned | E | Ass |  | TOTAL ASSIGNED | 32
LTC |  |  |  | PDY | Assigned | O | Ass |  | TOTAL ATTACHED | 13
2LT |  |  |  | PDY | Assigned | O | Ass |  | TOTAL DETACHED | 2
SPC |  |  |  | PDY | Assigned | E | Ass |  | GRAND TOTAL | 47
MAJ |  |  |  | PDY | Assigned | O | Ass
PFC |  |  |  | PDY | Assigned | E | Ass
SFC |  |  |  | PDY | Assigned | E | Ass
SPC |  |  |  | PDY | Assigned | E | Ass
CW2 |  |  |  | PDY | Assigned | W | Ass
SGT |  |  |  | PDY | Assigned | E | Ass
SSG |  |  |  | PDY | Assigned | E | Ass
SFC |  |  |  | PDY | Assigned | E | Ass
CPT |  |  |  | PDY | Assigned | O | Ass
SGT |  |  |  | PDY | Assigned | E | Ass
SFC |  |  |  | PDY | Assigned | E | Ass
SSG |  |  |  | OLV | Assigned | E | Ass
SGT |  |  |  | PDY | Assigned | E | Ass
MAJ |  |  |  | PDY | Assigned | O | Ass
SFC |  |  |  | PDY | Assigned | E | Ass
SFC |  |  |  | PDY | Assigned | E | Ass
SPC |  |  |  | PDY | Assigned | E | Ass
SSG |  |  |  | PDY | Assigned | E | Ass
SSG |  |  |  | PDY | Assigned | E | Ass
CPT |  |  |  | PDY | Assigned | O | Ass
SFC |  |  |  | PDY | Assigned | E | Ass
SGT |  |  |  | PDY | Assigned (Temp) | E | Ass
SSG |  |  |  | PDY | Attached  (56) | E | Att
PV2 |  |  |  | PDY | Attached (228) | E | Att
SSG |  |  |  | PDY | Attached (228) | E | Att
SSG |  |  |  | PDY | Attached (228) | E | Att
SGT |  |  |  | PDY | Attached (228) | E | Att
SPC |  |  |  | PDY | Attached (228) | E | Att
SFC |  |  |  | PDY | Attached (519) | E | Att
SSG |  |  |  | PDY | Attached (519) | E | Att
SPC |  |  |  | PDY | Attached (519) | E | Att
CW4 |  |  |  | PDY | Attached (56) | W | Att
2LT |  |  |  | PDY | Attached (581) | O | Att
SFC |  |  |  | PDY | Attached (581) | E | Att
SSG |  |  |  | PDY | Attached (C Co 151) | E | Att
SGT |  |  |  | PDY | Detached (BDE) | E | [NAME]
PFC |  |  |  | PDY | Detached (BDE) | E | [NAME]
Spreadsheet: 817518d1676294447-all-data-pulled-from-different-sheet-to-main-consolidated-sheet-s666-pq-amit-agency-savings-task
Sheet: AMH

 | [NAME]
 | Name | Employee no. | Position | Contract Hours | Softworks Start Date | Softworks Total worked hours | Approx. Savings rate | Worked weeks holiday pro-rated | Home
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | AMH
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | AMH
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | AMH | who dis?
 | Kajalben Dhaduk |  | Care Assistant | 44 |  |  | 3.75 |  | AMH | who dis?
 |  |  |  |  |  |  |  |  | AMH
 |  |  |  |  |  |  |  |  | AMH
 |  |  |  |  |  |  |  |  | AMH
 |  |  |  |  |  |  |  |  | AMH
 |  |  |  |  |  |  |  |  | AMH
 |  |  |  |  |  |  |  |  | AMH
 |  |  |  |  |  |  |  |  | AMH
 |  |  |  |  |  |  |  |  | AMH
 |  |  |  |  |  |  |  |  | AMH
 |  |  |  |  |  |  |  |  | AMH
 |  |  |  |  |  |  |  |  | AMH
 |  |  |  |  |  |  |  |  | AMH
 |  |  |  |  |  |  |  |  | AMH
 |  |  |  |  |  |  |  |  | AMH
 |  |  |  |  |  |  |  |  | AMH
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | AMH | who dis?
 | TOTAL
 |  |  |  |  |  | LESS Immigration cost
 |  |  |  |  |  | Total Savings
 | GMR | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours
 | Month | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00
 | Agency Care - Regular | 376.25 | 528.5 | 651 | 430.75 | 270.75 | 329.75 | 269 | 224.25 | 257.5 | 247.5
Spreadsheet: 4c179f12-3ee5-4048-b7d7-8680a98b7146
Sheet: Sheet1

Table 9--Wheat:  U.S. exports, [NAME] and export sales comparison (1,000 metric tons) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | 2011/12 |  | 2012/13 |  | 2013/14 (as of 1/2/14)
Importing |  |  |  |  |  | Out-
country |  |  |  |  | Shipments | standing | Total
Data |  | Export |  | Export | Export
source | Census 1/ | sales 2/ | Census 1/ | sales 2/ | sales 2/
Country:
China | 541.5 | 534.3 | 883.4 | 742.7 | 3838.2 | 298.4 | 4136.599999999999
Japan | 3513.4 | 3512.1 | 3638.5 | 3544 | 1603.5 | 292 | 1895.5
Mexico | 3794.3 | 3495.9 | 2906.6 | 2760 | 1704.2 | 603.5 | 2307.7
Nigeria | 3227.8 | 3248 | 3031.4 | 3002 | 1525.9 | 614.8 | 2140.7
Philippines | 2050 | 2038.6 | 1850.3 | 1965 | 1146.2 | 271.5 | 1417.7
Korean Rep. | 2132.9 | 1983 | 1311.4 | 1385 | 590.3 | 375.8 | 966.0999999999999
Egypt | 915.5 | 949.8 | 1736.8 | 1678 | 58.1 | 165 | 223.1
Taiwan | 893.2 | 887.9 | 1064.7 | 1038 | 578.9 | 156.6 | 189.4
Indonesia | 794 | 830 | 488.2 | 534 | 626.7 | 105 | 731.7
Venezuela | 642.2 | 593.5 | 631.6 | 631.4 | 330.9 | 132.8 | 463.7
Iraq | 571.8 | 571.8 | 208.9 | 208.9 | 0 | 0 | 0
EU-27 | 1186.3 | 1228.1 | 1322.8 | 970.8 | 422.1 | 108.6 | 530.7
Total grain | 27950.6 | 26627.3 | 26836.6 | 26348.1 | 19441.3 | 5148.8 | 24590.1
Total (including
products) | 28563 | 26812.5 | 27115.6 | 26410.1 | 19479.4 | 5153.2 | 24632.6
USDA forecast
of Census |  |  |  | 27416 |  |  | 30617
1/ Source:  U.S. Department of Commerce, U.S. Census Bureau
2/ Source:  USDA, Foreign Agricultural Service, U.S. Export Sales.
Spreadsheet: 273323d1382672584-sum-adjacent-cell-to-a-reference-throughout-workbook-sample-orders
Sheet: COSTINGS

 | Costing | YTD 2014 | WE 05.01.14 | WE 12.01.14 | WE 19.01.14 | WE 26.01.14
 | [NAME] (below)
1A | Grease / oils / paints / lubricants / turps / etc | 0
1B | Elec. stock /Switchroom R&M/ contractors /etc. | 0
1C | General R&M stock (inc's steel) + contractors. | 0
1D | [NAME]. | 0
1E | Welding: Cons/services/repairs ([NAME]. Gases) | 0
1F | Abrasives: Cut/Grind/Flap/Buff discs, ETC. | 0
1G | Tools/Repairs/Parts (Ex. Capital & Weld.) | 0
1H | Strapper spare parts (ALL areas) & maint. | 0
 | Weekly Totals - (YTD) calendar year | 0 | 0 | 0 | 0 | 0
I need the pink highlight cell to search the entire workbook for the contents in cell "A3" add the accumulated total of the adjacent (right) cell.
So everywhere the workbook finds the text 1A I need it to add the value of the cell to the right throughout the workbook so I can easily see how much I have spent on "grease/oils" for the week.
I can you the style from the WE 5th & 12th Jan or the style from 19th Jan if that makes it easier?
Spreadsheet: 95897d1295421700-how-to-make-a-formula-to-take-value-in-database-to-store-as-history-make-history-record
Sheet: Sheet2

No | Name | Status | Month
1 | [NAME] | New | January
2 | Danold | New | January
3 | Gray | New | January
4 | Irwans | New | January
Spreadsheet: 767308d1644403894-need-help-to-get-the-count-based-on-criteria-sample-1
Sheet: Sheet10

 | Status | Count of Status
 | Didn't join after selection | 1
 | Duplicate | 6
 | In Progress | 1
 | No Show | 11
 | Not Interested | 17
 | Not Suitable | 21
 | Not Yet Scheduled | 0
 | Offer Accepted | 1
 | [NAME] | 3
 | Rejected (1st) | 39
 | Rejected (2nd) | 5
 | Scheduled | 1
 | Grand Total | 106
Spreadsheet: 746478d1630743726-problem-with-number-of-nested-ifs-excel-quitting-calculation-after-45-ertm-sample-_jt-1-
Sheet: Sheet2

EMD | 10/0.1
ES | 12.5/0.25
GC | 10/0.1
GE | 12.5/0.005
HE | 10/0.00025
HG | 12.5/0.0005
LE | 10/0.00025
NK | 2021-05-25 00:00:00 | 25 | 5
NQ | 5/0.25
PL | 44201 | 5 | 1
SI | 25/0.005
TF | 10/0.1
YM | 2021-01-05 00:00:00 | 5 | 1
ZB | 31.25/0.3125
ZC | 12.5/0.25
ZF | 7.8125/0.0078125
ZN | 15.625/0.015625
ZS | 12.5/0.25
ZT | 7.8125/0.0078125)
Spreadsheet: 108388d1305441711-if-a-cell-in-a-column-in-any-worksheet-x-copy-entire-row-budget_update
Sheet: Food

Food
 |  |  |  |  | Total Food Budget | Spent So Far | Total Remaining
 |  |  |  |  | 100 | 80 | 20
Date | Location | Memo | Method | Amount
2011-05-10 00:00:00 | Smiths |  | DISC | 25
2011-05-11 00:00:00 | Dans |  | DISC | 35
2011-05-12 00:00:00 | Ridleys |  | AMEX | 10
2011-05-12 00:00:00 | Ridleys |  | AMEX | 10
Spreadsheet: 790290d1659627755-filter-xmatch-formulas-with-wildcard-text-revenuelist-copy
Sheet: Sheet1

 |  |  |  |  |  | *Need wildcard to locate any ClientLedger names with text containing the ClientInvoiceName string |  | Possible Matches: |  |  |  | Is there a way to add the clientinvoice name it found a match to?
ClientLedger | CustomerNumber | RevenueCategory | LastUsed |  | ClientInvoiceName | *Client* |  | ClientLedger | CustomerNumber | RevenueCategory | LastUsed | ClientInvoiceName
Wendys America | 1 | 2880 | 2019-01-17 00:00:00 |  | Wendys |  |  |  | 1 | 2880 | 43482 | Wendys
Eastern McDonalds | 2 | 2680 | 2022-05-14 00:00:00 |  | McDonalds |  |  | Eastern McDonalds | 2 | 2680 | 44695 | Mdonalds
California Arbys | 3 | 2480 | 2022-04-22 00:00:00 |  | Arbys |  |  | California Arbys | 3 | 2480 | 44673 | Arbys
West Sonic | 4 | 2280 | 2022-03-06 00:00:00 |  | Sonic |  |  | West Sonic | 4 | 2280 | 44626 | Sonic
Banana Avenue | 5 | 2080 | 2021-05-17 00:00:00 |  | Kentucky |  |  | Sonic of NA | 8 | 1480 | 44244 | Sonic
[NAME] | 6 | 1880 | 2021-04-17 00:00:00 |  |  |  |  | Corporate KFC (Kentucky Fried Chicken) | 9 | 1280 | 44213 | Kentucky
Orange Place | 7 | 1680 | 2021-03-11 00:00:00 |  |  |  |  | Wendys Incorporated | 11 | 880 | 44767 | Wendys
Sonic of NA | 8 | 1480 | 2021-02-17 00:00:00 |  |  |  |  | McDonalds Inc | 12 | 680 | 44766 | McDonalds
Corporate KFC (Kentucky Fried Chicken) | 9 | 1280 | 2021-01-17 00:00:00 |  | Objective- | I am working a backlog of establishing new revenue categories by client, but we have hundreds whose names aren't consistent with what we have on our systems or haven't been set up yet. I need a method to review potential matches.
[NAME] | 10 | 1080 | 2021-12-17 00:00:00
Wendys Incorporated | 11 | 880 | 2022-07-25 00:00:00
McDonalds Inc | 12 | 680 | 2022-07-24 00:00:00
Spreadsheet: 714970d1611489678-return-text-from-a-sheet-which-would-be-positive-negative-or-void-by-looking-up-using-dob-sample-dob-lookup-aligw
Sheet: Sheet1

Name of test subject (the person undertaking the test) | Date of birth  (or equivalent unique test subject identifier) | Test result (positive/negative/void) | Date of test
[NAME] | 1976-10-06 00:00:00
[NAME] | 1983-07-22 00:00:00
[NAME] | 1973-02-05 00:00:00
[NAME] | 1972-12-07 00:00:00
Jo | 1991-03-02 00:00:00
Spreadsheet: 693073d1598737505-how-do-i-add-data-to-a-sheet-without-messing-up-the-formatting-for-the-whole-workbook-new-crew-hours
Sheet: Master

 |  | Total | Sep |  |  | Oct |  |  | Nov |  |  | Dec
Last | First | Due | + | - | = | + | - | = | + | - | = | + | - | =
Smith | [NAME] |  | 65 |  |  |  | 0
Wilson | [NAME] |  | 120
[NAME] | [NAME] |  | 10
Pardon | Dolly |  | 80
[NAME] | Anne |  | 64
Smith | [NAME] |  | 80
Gonzales | George |  | 120
[NAME] | George |  | 200
Spreadsheet: 869574d1716189546-incorrect-time-counting-incorrect-time-counting
Sheet: Sheet1

 | When Issued (Z time) | Product expired (Z time) | Product Issued in CST | Product Expiration in CST | Length of Warning | Length of Warning in Minutes |  |  | Time | Time | # [NAME] | Correct # of Warnings
 | 1986-04-25T22:24:00Z | 1986-04-25T23:05:00Z |  |  |  |  |  |  |  |  |  | 0
 | 1986-04-25T22:40:00Z | 1986-04-25T23:20:00Z |  |  |  |  |  |  |  |  |  | 1
 | 1986-04-25T22:42:00Z | 1986-04-25T23:35:00Z |  |  |  |  |  |  |  |  |  | 4
 | 1986-04-25T22:50:00Z | 1986-04-25T23:50:00Z |  |  |  |  |  |  |  |  |  | 8
 | 1986-04-26T00:15:00Z | 1986-04-26T00:30:00Z |  |  |  |  |  |  |  |  |  | 5
 | 1986-04-26T00:15:00Z | 1986-04-26T01:15:00Z |  |  |  |  |  |  |  |  |  | 0
 | 1986-04-26T00:45:00Z | 1986-04-26T01:15:00Z |  |  |  |  |  |  |  |  |  | 0
 | 1986-04-26T02:35:00Z | 1986-04-26T03:30:00Z |  |  |  |  |  |  |  | 01:59:00 |  | 0
 | 1986-04-27T05:00:00Z | 1986-04-27T06:00:00Z
 | 1986-04-27T05:00:00Z | 1986-04-27T06:00:00Z |  |  |  |  |  |  | Incorrect Values
 | 1986-06-16T03:43:00Z | 1986-06-16T04:45:00Z
 | 1986-06-23T22:10:00Z | 1986-06-23T22:45:00Z
 | 1986-06-23T23:07:00Z | 1986-06-24T00:00:00Z
 | 1986-06-26T23:40:00Z | 1986-06-27T00:30:00Z
 | 1986-06-27T02:08:00Z | 1986-06-27T02:57:00Z
 | 1986-06-27T02:08:00Z | 1986-06-27T03:00:00Z
 | 1986-07-05T00:03:00Z | 1986-07-05T01:00:00Z
 | 1986-07-05T00:03:00Z | 1986-07-05T01:00:00Z
Spreadsheet: 223380d1364192973-help-with-comparing-2-tables-list-compare
Sheet: asa

ASA no gap | cost | shortdescription
605101500 | 21.64 | Book SOSO Sign On - Sign Off Attendance
635600600 | 3.11 | Envelopes Pay PPL Printed
130025001 | 2.18 | USB Drive Wallet 01001 Black
605401500 | 1.85 | Book PVLB Vehicle Log & Record Pocket
605501100 | 7 | Book CBD5 Carbonless Restaurant Docket Duplicate
605501200 | 10.25 | Book CBT5 Carbonless Restaurant Docket Triplicate
735030900 | 1967.84 | Whiteboard Electronic 4 Screen UB7325, 65"
640020000 | 35.57 | Film Carbon Whiteboard UG-6001, 50m
220010600 | 11.61 | Coat Hook Single Wood/Metallic 120W x 120D x 265H mm
047181201 | 61.4 | Toner T2320 Black
047181301 | 68.3 | Toner T2340D Black
045017101 | 146.75 | Toner 44028201 Black
045017201 | 120.4 | Developer Kit 44028101 Black
Spreadsheet: 119438d1314386202-league-tables-nhl-2011-2012-schedule
Sheet: Dummy Table

Rank | Team | Ranking |  |  |  |  | All Games |  |  |  |  |  |  |  |  |  |  |  | Home |  |  |  |  |  |  |  |  |  | Road
 |  | Pts | GP | ROW | H2H | [NAME] | P | W | L | OT-W | OT-L | SO-W | SO-L | ROW | GF | GA | [NAME] | Pts | P | W | L | OT-W | OT-L | SO-W | SO-L | GF | GA | Pts | P | W | L | OT-W | OT-L | SO-W | SO-L | GF | GA | Pts
2 | [NAME] | 1 | 0 | 1 |  | 0 | 4 | 3 | 1 | 1 | 0 | 2 | 0 | 1 | 8 | 7 | 1 | 6 | 2 | 1 | 1 | 1 | 0 | 0 | 0 | 3 | 4 | 2 | 2 | 2 | 0 | 0 | 0 | 2 | 0 | 5 | 3 | 4
5 | Buffalo Sabres | 4 | 0 | 0 |  | 1 | 4 | 1 | 3 | 0 | 0 | 0 | 0 | 1 | 6 | 12 | -6 | 2 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 3 | 7 | 2 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 3 | 5 | 0
1 | Montreal Canadiens | 1 | 0 | 0 |  | 0 | 4 | 3 | 1 | 0 | 0 | 0 | 0 | 3 | 13 | 6 | 7 | 6 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 3 | 0 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 11 | 3 | 6
3 | Ottawa Senators | 3 | 0 | 0 |  | 0 | 4 | 2 | 2 | 0 | 0 | 1 | 0 | 1 | 8 | 8 | 0 | 4 | 2 | 1 | 1 | 0 | 0 | 1 | 0 | 4 | 4 | 2 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 4 | 4 | 2
4 | Toronto Maple Leafs | 4 | 0 | 0 |  | 0 | 4 | 1 | 3 | 0 | 0 | 0 | 0 | 1 | 6 | 8 | -2 | 2 | 3 | 1 | 2 | 0 | 0 | 0 | 0 | 5 | 6 | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 2 | 0
Spreadsheet: 52515d1252320040-countif-nested-if-troubles-698531_creed1101
Sheet: Sheet1

Take up | Yes
Pending? | No
Count of  School | Term
School | Autumn | Spring | Grand Total
A | 2 |  | 2
B |  | 1 | 1
Grand Total | 2 | 1 | 3
Spreadsheet: 881533d1729610192-help-needed-with-filter-function-for-dynamic-status-report-in-excel-project-status-report_test
Sheet: Status Report

 | COMPLETED ACTIVITIES
 | Milestone / Deliverable | End Date | Comments
 | PENDING ACTIVITIES
 | Task Name | End Date | Comments | Status | Progess (%)
 | Milestone 3 | 2024-12-06 00:00:00 | Milestone not started | Not Started | 0
 | Milestone 4 | 2024-12-13 00:00:00 |  |  |  | Information isn't showing up here
Spreadsheet: 0bfc69b3-f491-47ca-b9fd-e657de8271b4
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
ORDER
貨品條碼Product NO. | 貨品名稱Product | 單價unit price | 數量qty. | 合計Cost
總計Cost |  |  | 0 | 0
航空郵寄airmail
總計金額Total | 0
支付款項(Total Cost) : 新台幣NT$_________________(Please fill in the amount of, thank you!)
□1.信用卡線上刷卡Payment via Credit Card：
請由我的Please deduct via my, □VISA　　　□MASTER　　　□JCB　　　□AMEX 繳付
信用卡有效期限Please [NAME] on Credit Card：__ __月(M) __ __年(Y)止
簽名處條碼後三碼The 3 numbers after the Authorized Signature：__ __ __
卡號 Credit Card No.：________-________-________-________
簽名Authorized Signature：______________________________ (同信用卡上簽名 Same Signature on Credit Card)
□2.Bank Transfer：Taipei, Taiwan  Chinatrust Commercial Bank(Remittances from abroad U.S. $ 25 surcharge fee)
Bank Code：822  Account ：5435-4999-9993　Username：National Palace Museum
Account name：NATIONAL PALACE MUSEUM
Name of the bank：Chinatrust Commercial Bank
Address：1F.,No.9, Songgao Rd., Sinyi District, Taipei City 110, Taiwan
Location of bank：Shinfu Branch
Country：Taiwan,Taipei
Bank Key/Code：822
Bank Account number：5435-4999-9993
Swift / BIC number：CTCBTWTP543
Currency/Currencies：US$
Make sure and guarantee that you sign up in person, equals you understand and agree the credit card transaction is established legally.
我需要I'd like the □二聯式發票 2 copies receipts
姓名Name:  first name_________________ last name __________________  □Mr.先生　□Miss小姐　□Mrs.女士
電話phone no.：_____________________手機cell no.：_______________________________________
e-mail adress：_______________________________________________傳真fax no.：_______________
地址adress：____________________________________________________________________________
郵遞區號post code_____________
Please fax to +886-2-2883-8929, or scan the file and e-mail to [EMAIL] after complete this form,Welcome to contact us by calling +886-2-2881-2021#8977, Mr. [NAME], if you are inquiring, National Palace Museum is available 9:00~18:00, from Mon to Fri.
Spreadsheet: 774173d1648267152-count-date-based-on-month-book1
Sheet: OSDefect_M

ID | Car | Defective | Since | Clear | Year | Month
1 | 28 | Test 1 | 2022-02-01 00:00:00
1 | 14 | Test 2 | 2022-03-25 00:00:00
2 | 3 | Test 3 | 2022-03-02 00:00:00
1 | 2 | Test 4 | 2022-04-04 00:00:00
2 | 4 | Test 5 | 2022-04-25 00:00:00
3 | 1 | Test 6 | 2022-04-30 00:00:00
3 | 1 | Test 7 | 2022-03-26 00:00:00
1 | 1 | Test 8 | 2023-02-15 00:00:00