tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 474939d1470978676-dynamic-calendar-test-calendar
Sheet: MONTHLY CALENDAR

 |  |  | 2016
 | 12
 |  |  |  |  |  |  |  |  |  | CONTEXT AND [NAME]:  General enrollment days are entered in CHILDCARE ENROLLMENT tab  However, there are days when a child cannot attend due to illness or when a child changes childcare providers in the middle of the month.   I would like to be able to input specific changes that are also dynamic (i.e. the calendar refreshes for a new month)  Changes like those above impact the monthly costs of childcare, is there a way to create a yearly calendar off the back of this dynamic spreadsheet for all months?
 |  | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY
modified testing
Spreadsheet: 213152d1360355394-countif-function-data-sum-product
Sheet: Baseline Count Rec %

RAE | Total Surveys | Yes | No | N/A | % | 1 | 2 | Average Score
[NAME]
Spreadsheet: 187416d1350453517-help-with-look-up-functions-example17th
Sheet: Sheet4

Number | Box Number
824 | 87
457 | 4
422 | 665
774 | 317
550 | 590
709 | 761
342 | 633
652 | 309
938 | 575
675 | 172
820 | 459
267 | 10
102 | 406
1 | 473
635 | 179
671 | 183
156 | 31
634 | 411
28 | 82
998 | 753
407 | 747
663 | 703
198 | 434
487 | 652
577 | 644
818 | 76
860 | 11
527 | 605
746 | 446
Spreadsheet: 818106d1676589958-if-and-or-q-and-d-feb-with-summary-end
Sheet: 3rd

1 | Defect ID | Unit ID | Unit Date | Prod Date | Act Date | Shift | Year | Serial | z | ID #1 | ID #2 | ID #3 | Product | Color #1 | Color #2 | Part | Location | Concern | [NAME] | Rank | Grid Label | Responsible Area | Responsible Cell | Recording User | Recording Area | Recording Cell | Recording Station | Defect Status | Root Cause | Root Cause User | Comments | sequence no | 1st | 2nd | 3rd | Date
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
Spreadsheet: 683026d1592444618-combining-3-array-formulas-to-one-sample
Sheet: HO

 | Name | Date order Received | [NAME] | Disc £ ea | Balance | Paid | Product | Age | Notes/ Special Reqs | Status | Collection Date | Collection Time
 | pete |  | 12 |  |  |  | 6f |  |  |  | 2020-06-23 00:00:00 | 14:00:00
 | [NAME] |  | 1 |  |  |  | 5f |  |  |  | 2020-06-21 00:00:00 | 08:00:00
 | [NAME] |  | 4 |  |  |  | 14f |  |  |  | 2020-06-23 00:00:00 | 07:00:00
Spreadsheet: 847427d1698349949-help-with-subtotal-sumproduct-and-avoiding-n-as-book1
Sheet: weighted avg

 |  | *include zeroes - do not include n/a's.
1 | 20000 | 0.21
2 | 22000 | 0.05
3 | 21000 | 0
4 | 25000 | 0.1
5 | 25000 | 0.025
6 | 10000 | 0.06
7 | 0
8 | 0
9 | 5000 | 0
10 | 1000 | 0
Spreadsheet: 066d3c03-82ef-4226-984c-1aebfd5028b4
Sheet: Sheet1

Unnamed: 0 | Cash Flow Forecast - 12 Months (1 Year) | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
 | Month: | Pre-Start | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Totals
 | Receipts
 | Cash sales |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Collections from credit sales |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | New equity inflow |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Loans received |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Other |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Total Receipts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Payments
 | Cash purchases |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Payments to creditors |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Salaries and wages |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Employee benefits |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Payroll taxes |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Rent |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Utiltities |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Repairs and maintenance |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Insurance |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Travel |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Telephone |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Postage |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Office supplies |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Advertising |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Marketing/promotion |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Professional fees |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Training and development |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Bank charges |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Miscellaneous |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Owner's drawings |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Loan repayments |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Tax payments |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Capital purchases |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Other |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Total Payments | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Cashflow Surplus/Deficit (-) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Cummulative Cash Flow | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Opening Cash Balance | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Closing Cash Balance | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 164392d1340743272-excel-2007-help-in-creating-a-pivot-custom-formula-sum-of-collections-count-of-accounts-smple
Sheet: Sheet1

Name | Account | Sale
[NAME] | abs2 | 100
[NAME] | abs3 | 100
[NAME] | abs2 | 100
[NAME] | abs4 | 100
[NAME] | abs2 | 100
[NAME] | abs4 | 100
[NAME] | abs5 | 100
[NAME] | abs3 | 100
[NAME] | abs5 | 100
Spreadsheet: e9daf9f4-330d-44e0-b28f-4401d8669664
Sheet: 017Btrans

PROPERTY CUSTODIAN DELEGATION OF AUTHORITY
FORM SPO-017Btransmittal
TO: |  |  |  |  |  |  | STATE PROCUREMENT OFFICE (SPO)
FROM:
SUBJECT: |  |  |  |  |  |  | TRANSMITTAL FOR PROPERTY CUSTODIAN DELEGATION OF AUTHORITY
 |  |  |  |  |  |  | For Fiscal Year Ended:
The attached form(s) SPO-017B, Annual Summary of Inventories Report, are for the employees listed below.
[NAME] form(s) SPO-017Btransmittal and SPO-017B to [EMAIL].
Questions pertaining to these delegations may be directed to:
Contact Person: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Phone:
 | Full Name |  |  |  |  |  |  |  |  |  |  |  |  |  | Title |  |  |  |  |  |  |  |  |  |  |  |  |  | Organization Code |  |  |  |  |  |  |  |  |  |  |  |  | Location Code
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
Designation of a property custodian should be based on their expertise, knowledge and proficiency to carry out inventory management duties.     Careful consideration should be taken when designating a property custodian because this person will be responsible for the proper care and maintenance of assets purchased with public funds.
I hereby delegate inventory management authority for the care, custody, or control (including but not limited to sign for: disposal applications, annual physical inventory certifications and transfer of properties), and responsibility for the accountability, protection, maintenance, and proper use of all state property pertaining to the stated organization and location code(s) to the person named on the list above, as the designated Property Custodian.  This delegation of authority does not relieve my other responsibilities as head of the department or chief procurement officer (CPO).
Department Head/CPO Name (Print) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Department Head/CPO Signature |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date
SPO-017Btransmittal (8/13)
Spreadsheet: 754166d1635976459-extract-only-specified-values-from-a-table-index-match-with-helper-extraction-on-constr
Sheet: Sheet1

Construction | Item | Quantity | Helper | Quantity of constructions |  |  | Constructions | 301
301 | Pak.1 Kensal MR Sideboard | 4800 |  | 110 |  |  | 1 | 301
301 | [NAME] | 9800 |  | 201 |  |  | 2 | 301
409 | Furn.pak. Kensal MR Sideboard | 7800 |  | 301 |  |  | 3 | 301
301 | Pak. NewEst Desk with Drawers | 9200 |  | 409 |  |  | 4 | 301
301 | Pak. NewEst Shoe Shoe Cabinet 3D | 18600 |  | 410 |  |  | 5 | 301
409 | Furn.pak. NewEst Shoe Cabinet 3D | 2600 |  |  |  |  | 6 | 301
301 | Pak. Northgate Settle  Bench (KD) | 1800 |  |  |  |  | 7 | 301
410 | Furn. Pak. [NAME] (KD) | 3000 |  |  |  |  | 8 | 301
301 | Pak. Farsta Wall mounted [NAME] (RA) | 19400 |  |  |  |  | 9 | 301
110 | Lp-vaheleht | 16000 |  |  |  |  | 10 | 301
301 | Pak. [NAME]  (KD) | 9800 |  |  |  |  | 11 | 301
409 | Furn. Pak. [NAME]  (KD) | 13000 |  |  |  |  | 12 | 301
301 | Pak.1  Stripe Sideboard KD | 8200
201 | Pak.2 Stipe [NAME] | 2200
201 | [NAME] Sideboard KD | 4000
409 | Furn.pak. Stripe Sideboard KD | 12400
301 | Pak.2 Rayburn [NAME] | 1200
301 | Pak.1 [NAME] | 18000
301 | Pak.1 Avon MR [NAME] | 15200
301 | Pak.2 Avon Sideboard Set  (KD) | 16000
409 | Furn.pak. Avon MR Sideboard  KD | 10800
Spreadsheet: 746364d1630663388-statement-by-name-and-by-date-older-to-newer-2-statment
Sheet: Folha1

 |  | BOOKS
 |  | 1 quarter |  |  |  |  |  |  |  |  |  | 2 quarter |  |  |  |  |  |  |  |  |  | 3 quarter |  |  |  |  |  |  |  |  |  | 4 quarter
 |  | date | value | date | value | date | value | date | value |  |  | date | value | date | value | date | value | date | value |  |  | date | value | date | value | date | value | date | value |  |  | date | value | date | value | date | value | date | value
 | A | 2021-01-01 00:00:00 | 102 | 2021-03-03 00:00:00 | 58 |  |  |  |  |  |  | 2021-04-04 00:00:00 | 47.5 | 2021-06-26 00:00:00 | 148 |  |  |  |  |  |  | 2021-07-03 00:00:00 | 70 | 2021-09-15 00:00:00 | 23.5 |  |  |  |  |  |  | 2021-12-12 00:00:00 | 55.5
 | B
 | C | 2021-01-04 00:00:00 | 25 | 2021-02-02 00:00:00 | 25 |  |  |  |  |  |  | 2021-04-07 00:00:00 | 12.5 |  |  |  |  |  |  |  |  | 2021-07-04 00:00:00 | 48 | 2021-08-04 00:00:00 | 48 |  |  |  |  |  |  | 2021-12-01 00:00:00 | 150
 | D
 | E
 | F
 | G
Spreadsheet: eb76c2e2-fb3b-4720-9d72-c03a95ca4507
Sheet: 24

 |  | Transactions
Product Type |  | Cleared** | Uncleared
Total Metals* | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Energy | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Agricultural | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Index | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Other*** | Exotic
 | Option
 | Spot/Forward
 | Swap
TOTAL |  | N/A**** | N/A
Estimated swap dollar volumes, week ending February 15, by product type and cleared status (value of all trades in millions of USD), all participant types, tenors, and currencies. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***Environment, Freight, Multi-Commodity Exotic
****N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 153355d1335883664-auto-filter-and-summaries-training-master-sheet
Sheet: Info Sheet

 | NOTES
 | The idea of this Database is to show as clearly as possible the dates last attended and the dates due of all members of staff according to the renewal time frame for NBT Mandatory Training, whilst also identifying those that are out-of-date/non compliant.
 | This database requires you to input only on the "FHY" and "SMD" worksheets
 | Data is automatically calculated at the bottom of each sheet. This will normally be hidden so that formulas canot be changed.
 | The Main Summary Sheet is where all the information from each sheet is linked. As each sheet is updated the Main Summary updates automatically.
 | Under no circumtances is anyone to input data directly into the Main Summary Sheet.
 | "FHY" & "SMD" Sheets
 | When you enter the latest date which a member of staff has attended training, the "Due Date" column will automatically generate the next date the staff member is due to update whether its 1, 2 or 3 years ahead.
 | There is "Date Booked to Attend" to show if staff are close to being out-of-date, then a date is expected to be in that column.
 | Each sheet will show the Contract, Start Date, First & Last Name, DOB and Current Status of each member of staff for each site.
 | All Dates must be entered in the same format. For Example: __ /__ /____.
 | [NAME]
 | The Rag Rating is as follows:
 | If the staff members [NAME] is due in 90 days the Date/Cell will go Amber
 | If the staff members [NAME] is due in 45 days the Date/Cell will go Red
 | If the staff member is out-of-date by todays date and less then the Date/Cell will go Black
 | Main Summary Sheet
 | Any and all information required for reporting should be available from the Main Summary Sheet only
 | Should you wish to look in depth into a particular member of staff training then that info will be on the "FHY" and "SMD" sheets.
 | Please note that this is still a working document and is undergoing further improvements. Please feel free to make suggestions that could assist you further and I'll see what I can do!
Spreadsheet: 170492d1343300731-dependent-lists-but-one-with-a-condition-test
Sheet: Sheet1

Nr. FPO | Articol | Cantitate | Data | Status | Operatie inventar
[NAME] |  |  |  |  |  |  |  |  | FPO NO | Item No_ | Description | Unit of Measure Code | Expected Quantity | REPLESNIHMENT
 |  |  |  |  |  |  |  |  | RC46285 | BA379955 D-07 OLD | TEAVA D42x3,25 - S235 | PCES | 53 | 0
 |  |  |  |  |  |  |  |  | RC46285 | BA379955 D-08 | OTEL 8    -    S235 JR | PCES | 53
 |  |  |  |  |  |  |  |  | RC46285 | BA379955 D-09 | TEAVA 30x30x2 - S235 | PCES | 53 | 0
 |  |  |  |  |  |  |  |  | RC46285 | BA379955 D-10 | OTEL 2    -    S235 JR | PCES | 53
 |  |  |  |  |  |  |  |  | RC46285 | BA379955 D-11 | OTEL 5    -    S235 JR | PCES | 53
 |  |  |  |  |  |  |  |  | RC46285 | BA379955 D-12 | TEAVA 30x30x2 - S235 | PCES | 53
 |  |  |  |  |  |  |  |  | FPO31942 | BA487341 D-01 | OTEL 3   -    S235 JR | PCES | 50
 |  |  |  |  |  |  |  |  | [NAME] | BA387602 D-01 | OTEL 4    -    S235 JR | PCES | 30 | 0
 |  |  |  |  |  |  |  |  | [NAME] | BA387602 D-02 | OTEL 4    -    S235 JR | PCES | 30 | 0
 |  |  |  |  |  |  |  |  | [NAME] | BA387602 [NAME] | OTEL 8    -    S235 JR | PCES | 60
 |  |  |  |  |  |  |  |  | [NAME] | BA387602 D-04 | OTEL 8    -    S235 JR | PCES | 60
 |  |  |  |  |  |  |  |  | RC0330911 | CN54660 H-30 | OTEL 5    -    CREUSABRO | PCES | 8
 |  |  |  |  |  |  |  |  | RC2190311 | CN54658 D-08 | BARA 60x30 | PCES | 9 | 0
 |  |  |  |  |  |  |  |  | RC2190311 | CN54658 D-16 | OTEL 8    -    S235 JR | PCES | 3
 |  |  |  |  |  |  |  |  | RC0310911 | TABLA 080 | OTEL 8    -    S235 JR | MP | 0.033
 |  |  |  |  |  |  |  |  | RC0310911 | TABLA 080 | OTEL 8    -    S235 JR | MP | 0.151
Spreadsheet: 493922d1481972805-how-to-count-if-a-cell-contains-a-number-which-is-between-2-numbers-score-based-on-if-between-two-times-2-
Sheet: Sheet1

Person | 2016-12-01 00:00:00 | 2016-12-02 00:00:00 | 2016-12-03 00:00:00 | 2016-12-04 00:00:00 | 2016-12-05 00:00:00 | Score |  | [NAME] demonstration
[NAME] | 00:04:00 | 00:10:00 | 00:05:01 | 00:31:00 | 00:00:05 |  |  | For each date is True (1) or [NAME] (0) that [NAME] time is greater or equal than
[NAME] | 00:03:00 | 00:00:36 | 02:35:25 | 00:59:59 | 00:00:48 |  |  | each time on table Score:
 |  |  |  |  |  |  |  | >= | 2016-12-01 00:00:00 | 2016-12-02 00:00:00 | 2016-12-03 00:00:00 | 2016-12-04 00:00:00 | 2016-12-05 00:00:00
 |  |  |  |  |  |  |  | 0 |  | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  | 00:05:00 | 0 | 1 | 1 | 1 | 0
 |  |  |  |  |  |  |  | 00:15:00 | 0 | 0 | 0 | 1 | 0
 |  |  |  |  |  |  |  | 00:30:00 | 0 | 0 | 0 | 1 | 0
 |  |  |  |  |  |  |  | 01:00:00 | 0 | 0 | 0 | 0 | 0
 | Times | not needed | Score
 | 0 |  | 0 |  |  |  |  | For each date is True (1) or [NAME] (0) that [NAME] time is less than
 | 00:05:00 | 0.00347222222222222 | 1 |  |  |  |  | each time on table Score:
 | 00:15:00 | 0.0104166666666667 | 2 |  |  |  |  | < | 2016-12-01 00:00:00 | 2016-12-02 00:00:00 | 2016-12-03 00:00:00 | 2016-12-04 00:00:00 | 2016-12-05 00:00:00
 | 00:30:00 | 0.0208333333333333 | 3 |  |  |  |  | 00:05:00 |  | 0 | 0 | 0 | 1
 | 01:00:00 | 0.0416666666666666 | 6 |  |  |  |  | 00:15:00 | 1 | 1 | 1 | 0 | 1
 | 1e+99 |  |  |  |  |  |  | 00:30:00 | 1 | 1 | 1 | 0 | 1
 |  |  |  |  |  |  |  | 01:00:00 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  | 1e+99 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUMPRODUCT
 |  |  |  |  |  |  |  | For each date is True (1) or [NAME] (0) that [NAME] time verify both condition:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | is true
 |  |  |  |  |  |  |  | * (AND) | 2016-12-01 00:00:00 | 2016-12-02 00:00:00 | 2016-12-03 00:00:00 | 2016-12-04 00:00:00 | 2016-12-05 00:00:00 |  | times | score
*) -- convert true in 1 and false in 0 |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 1
the same if you use 0+ |  |  |  |  |  |  |  | 00:05:00 | 0 | 1 | 1 | 0 | 0 |  |  | 2
 |  |  |  |  |  |  |  | 00:15:00 | 0 | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  |  |  | 00:30:00 | 0 | 0 | 0 | 1 | 0 |  |  | 3
 |  |  |  |  |  |  |  | 01:00:00 | 0 | 0 | 0 | 0 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]:
Spreadsheet: 270269d1381426143-counting-and-summing-only-one-instance-of-a-record-issue-counting-recprds-that-appear-multiple-times-smls-oeldere-
Sheet: Sheet1

number | date | value | duplicate | choise |  | combine |  |  |  |  |  |  | duplicate | 1
188965 | 2013-04-08 00:00:00 | -300
188965 | 2013-04-18 00:00:00 | -300 |  |  |  |  |  | Should return |  |  |  |  |  | Waarden
188965 | 2013-05-08 00:00:00 | -300 |  |  |  |  |  |  | Positive balances |  |  |  | Rijlabels | Som van value | Aantal van choise
188965 | 2013-06-09 00:00:00 | -300 |  |  |  |  |  |  | Negative Balances |  |  |  | 0 | 0 | 1
639869 | 2013-08-13 00:00:00 | 500 |  |  |  |  |  |  | Total Negative Records | 2 |  |  | negative | -375 | 2
325652 | 2013-09-18 00:00:00 | 25 |  |  |  |  |  |  | Total Postive Records | 4 |  |  | positive | 1125 | 4
799092 | 2013-07-01 00:00:00 | 0 |  |  |  |  |  |  | Total Zero Balance Records | 1 |  |  | Eindtotaal | 750 | 7
355023 | 2013-07-04 00:00:00 | 400
470911 | 2013-06-16 00:00:00 | -75 |  |  |  |  |  |  | -10000 | negative
643196 | 2013-09-21 00:00:00 | 200 |  |  |  |  |  |  | 0 | 0
639869 | 2013-05-15 00:00:00 | 500 |  |  |  |  |  |  | 1 | positive
799092 | 2013-05-14 00:00:00 | 0
799092 | 2013-09-30 00:00:00 | 0
Spreadsheet: 32502d1228721951-autosum-or-update-of-another-worksheet-abc-co-1
Sheet: Sales

ABC Co., Ltd
Weekly Sales for Nov 2008
Customer | Customer PO No. | D/O No. | Date | Week # | [NAME] | Amount
Solectron | 3138/08 | AVT-R294 | 2008-11-03 00:00:00 | 2 | 154 | 6909.39 |  |  | 0 | 128791.78
Solectron | 3986/08 | AVT-R295 | 2008-11-03 00:00:00 | 2 | 319 | 9902.53
Solectron | 4206/08 | AVT-R296 | 2008-11-03 00:00:00 | 2 | 83 | 3544.63
Solectron | 3346/08 | AVT-R297 | 2008-11-03 00:00:00 | 2 | 311 | 10825.8
Solectron | 4108/08 | AVT-R298 | 2008-11-03 00:00:00 | 2 | 236 | 5414.67
Solectron | 3607/08 | AVT-R299 | 2008-11-03 00:00:00 | 2 | 1074 | 34833.45
Solectron | 1286/08 | AVT-R300 | 2008-11-03 00:00:00 | 2 | 340 | 26268.72
Solectron | 3106/08 | AVT-R301 | 2008-11-03 00:00:00 | 2 | 240 | 8233.06
Solectron | 1241/08 | AVT-R302 | 2008-11-03 00:00:00 | 2 | 289 | 20237.09
Solectron | 3039/08 | AVT-R303 | 2008-11-03 00:00:00 | 2 | 100 | 622.44
Dage | 08I0005 | AVT-R304 | 2008-11-04 00:00:00 | 2 | 5 | 1486
K&S | 24966 | AVT-R305 | 2008-11-04 00:00:00 | 2 | 4 | 1780
K&S | FA | AVT-R306 | 2008-11-04 00:00:00 | 2 | 6 | 200
Solectron | 3039/08 | AVT-R307 | 2008-11-05 00:00:00 | 2 | 10 | 2000
K&S | 24966 | AVT-R308 | 2008-11-05 00:00:00 | 2 | 2 | 300
Flextronic | 139I00908 | AVT-R309 | 2008-11-06 00:00:00 | 2 | 2 | 166
Flextronic | 139I00906 | AVT-R310 | 2008-11-06 00:00:00 | 2 | 2 | 26.8
Flextronic | 139I00909 | AVT-R311 | 2008-11-06 00:00:00 | 2 | 1 | 195
[NAME] | 54398 | AVT-1595 | 2008-11-12 00:00:00 | 3 | 20 | 1409.64
[NAME] | 54399 | AVT-1596 | 2008-11-10 00:00:00 | 3 | 10 | 2502.4
[NAME] | 54398 | AVT-1597 | 2008-11-10 00:00:00 | 3 | 20 | 2349.4
 |  |  |  |  | 3228 | 139207.02
Spreadsheet: 774895d1648715007-return-single-value-out-of-several-matching-values-get-uniques-ans
Sheet: Sheet1

name | rn | cl | m | A |  |  |  |  |  | name | rn | cl | m | A
a | 2 | c1 | j | 100
b | 3 | c2 | j | 200
c | 4 | c2 | m | 300
a | 2 | c1 | f | 400
b | 3 | c2 | m | 500
a | 2 | c1 | m | 600
Spreadsheet: 330515d1404772135-summing-across-multiple-sheets-by-specific-name-vlookup-june_template-trivia-scorecard
Sheet: Week4

TEAM NAME: | 1 | 2 | 3 | 4 | 5 | 6 | 7 | TOTAL |  |  |  | Cumulative
Danites | 4 | 3 | 3 | 2 | 5 | 7 | 24 |  |  |  |  | Stepdads | 160 | 49.5
Stepdads | 5 | 2 | 3 | 4 | 5 | 6 | 9 |  |  |  |  | [NAME] | 117.5 | 42
Quechee Quirks | 1 | 1 | 4 | 5 | 6 | 2 | 2 |  |  |  |  | The Wolves | 86.75
[NAME] | 2 |  |  |  |  |  |  |  |  |  |  | The Three Woods | 17
 |  |  |  |  |  |  |  |  |  |  |  | Team Team | 43
 |  |  |  |  |  |  |  |  |  |  |  | Rowdy's Raiders | 26
 |  |  |  |  |  |  |  |  |  |  |  | Naughty Neighbor | 5.5
Spreadsheet: c24828da-d053-4c3b-8c30-31b813da127d
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
VRERP | Test | VRERP | Vancomycin-Resistant Enterococcus, Molecular Detection, PCR | VRE PCR | Real-Time Polymerase Chain Reaction (PCR) (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | Culture transport swab: CUTS |  |  |  | Varies | Specimen Type: Perianal, perirectal, rectal Container/Tube: Culture transport swab [NAME] Volume: Swab Additional Information: Specimen source is required. Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	E-swab, calcium alginate swab, cotton-tipped swab, swab sent in gel transport medium, swab sent in viral or universal transport medium, frozen swab | Not applicable | Monday through Friday | 1 day | 4 day | 1 | 87500 |  |  |  |  | Rochester
VRERP | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
VRERP | Order Question | SRC60 | Specimen source |  | Plain Text
VRERP | Result | SRC60 | Specimen source | Specimen source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2
VRERP | Result | 84406 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 203573d1357167008-dropdown-menu-help-data-example-solution
Sheet: Product Comparison

 |  | F1DA104Z | 4SV1000-001 | CS4 | CS9134
 | Company
 | Category
 | P/N #
 | Product Name
 | # of Ports
 | Target I/O Type (KVM Side)
 | Target I/O Type (Server Side)
 | Target Cables Included
 | Cat Distance ([NAME])
 | # of Local Users
 | Console I/O Type
 | # of Monitors Supported
 | [NAME]
 | Aspect [NAME]
 | Contrast Ratio
 | Brightness Value
 | [NAME]
 | Viewing Angle
 | Rail System
 | Optical Drive
 | nVidia 3D Support
 | IP Support
 | # of Remote Users
 | [NAME]
 | [NAME]. # of Targets via [NAME]
 | Rack Mountable
 | Includes [NAME]
 | Unit (U) Height
 | Built-In USB Hub
 | CAC Support
 | VM Support
 | [NAME]
 | Dedicated Processors
 | Memory Buffer
 | Secure EDID Channels
 | Restricted USB
 | High-Retention USB Ports
 | Audio Support
 | Audio Channel
 | Microphone Support
 | Push Button Support
 | OSD Support
 | Hotkey Switching
 | Password Protection
 | [NAME]
 | PC Support
 | [NAME]
 | [NAME]
 | Sun Support (USB)
 | Height
 | [NAME]
 | Length (Depth)
 | Weight
 | Operating Temp
 | Storage Temp
 | Operating Humidity
 | Operating Voltage
 | Input Power
 | Video Resolution ([NAME])
 | Compliance/Certification
 | [NAME]
 | Protection Profile
 | TAA Compliant
 | Warranty