tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 28a986c4-b236-4620-a690-68587a8b7b79
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | BLOOD BROTHERS RECEIPTS
2006-10-25 00:00:00 | TJMaxx | jeans, tshirts | 44.97 | bbros | sp
2006-10-26 00:00:00 | Hatcap exch | milkman hat | 47 | bbros | sp
2006-10-26 00:00:00 | JCPenney | brett suit (-return) | 254.63 | bbros | sp
2006-10-25 00:00:00 | goodwill | clothes | 7.5 | bbros | lf
2006-10-14 00:00:00 | [NAME] | [NAME] dresses | 162.14 | bbros | lf
2006-10-14 00:00:00 | textile fabric | mrs L skirt wool | 59.96 | bbros | lf
2006-10-18 00:00:00 | macy's | shaper--Ashlee | 52 | bbros | lf
2006-10-16 00:00:00 | fashion fabrics | swatches | 6.69 | bbros | lf
2006-10-21 00:00:00 | baer fabric | [NAME] wedding, [NAME] | 38.03 | bbros | lf
2006-10-17 00:00:00 | bazar fabric | dupioni--Mrs L | 66 | bbros | cb
2006-10-26 00:00:00 | payless | shoes
2006-10-31 00:00:00 | Hatcrafters | [NAME] | 163 | bbros | sp
2006-10-30 00:00:00 | payless | shoes | 20.99 | bbros | lf
2006-10-26 00:00:00 | macys | sweaters, jeans--TAX! (-ret)!!! | 45.88 | bbros | lf
2006-10-28 00:00:00 | sears | jeans | 44.97 | bbros | lf
2006-10-28 00:00:00 | sears | shoes-mrs L | 40 | bbros | lf
2006-11-04 00:00:00 | Kohls |  | 17.99 | bbros | lf
2006-11-03 00:00:00 | kohls | shoes | 34.99 | bbros | lf
2006-11-06 00:00:00 | kmart | swirt, [NAME] | 28.17 | bbros | lf
2006-11-01 00:00:00 | kmart | locket, shorts | 30.99 | bbros | lf
2006-10-31 00:00:00 | Walmart | [NAME] | 67.5 | bbros | lf
2006-10-31 00:00:00 | target | [NAME] | 73.86 | bbros | lf
2006-11-06 00:00:00 | payless | shors | 29.99 | bbros | lf
2006-11-04 00:00:00 | kohls | shoe | 7.49 | bbros | lf
2006-10-28 00:00:00 | tjmaxx | [NAME] | 77.97 | bbros | sp
2006-10-28 00:00:00 | jcpenney | colin suit, [NAME] | 266.95 | bbros | sp
2006-10-30 00:00:00 | hancock | [NAME] notions | 43.87 | bbros | sp
2006-10-28 00:00:00 | [NAME] | suit-mrs L | 100.8 | bbros | sp
2006-11-07 00:00:00 | kmart | [NAME] | 28.96 | bbros | sp
2006-11-07 00:00:00 | target | sox, sweater | 23.98 | bbros | sp
2006-11-07 00:00:00 | [NAME] | paint | 47.78 | bbros | sp
2006-10-26 00:00:00 | payless | saddle shoes | 284.61 | bbros | lf
2006-10-24 00:00:00 | [NAME] | green cardigans | 253.19 | bbros | lf
 |  | total | 2472.85
Spreadsheet: 792930d1661238242-want-to-make-simple-dynamic-dashboard-example-1-
Sheet: Report

Sl no. | [NAME] | Valid
1 | [EMAIL] | True |  |  | Total emails:
2 | [EMAIL] | True |  |  | Valid emails:
3 | [EMAIL] | False |  |  | Invalid emails:
4 | [EMAIL] | True
5 | [EMAIL] | False
6 | [EMAIL] | True
7 | [EMAIL] | True
8 | [EMAIL] | True
9 | [EMAIL] | True
10 | [EMAIL] | True
11 | [EMAIL] | False
12 | [EMAIL] | True
13 | [EMAIL] | False
14 | [EMAIL] | True
Spreadsheet: 34384d1231605166-excel-search-marcus-czerny-losas
Sheet: Caso 3b

1 | 1.05 | 1.1 | 1.15 | 1.2 | 1.25 | 1.3 | 1.35 | 1.4 | 1.45 | 1.5 | 1.55 | 1.6 | 1.8 | 2
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
0.04 | 0.94 | 0.85 | 0.77 | 0.7 | 0.64 | 0.59 | 0.54 | 0.49 | 0.45 | 0.41 | 0.38 | 0.35 | 0.35 | 0.35
0.37 | 0.32 | 0.27 | 0.22 | 0.18 | 0.14 | 0.1 | 0.07 | 0.05 | 0.03 | 0.02 | 0.01 | 0.01 | 0.01 | 0.01
1 | 1.05 | 1.1 | 1.15 | 1.2 | 1.25 | 1.3 | 1.35 | 1.4 | 1.45 | 1.5 | 1.55 | 1.6 | 1.8 | 2
63.3 | 56.4 | 50.7 | 46.1 | 42.5 | 39.5 | 37 | 34.9 | 33.2 | 31.8 | 30.6 | 29.5 | 28.6 | 26.3 | 25
35.1 | 35.6 | 36.2 | 37 | 38 | 39.2 | 40.6 | 42.2 | 44 | 46 | 48.2 | 50.6 | 53.1 | 66.2 | 84.8
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
14.3 | 14.1 | 14 | 13.9 | 13.8 | 13.8 | 13.9 | 13.9 | 14 | 14.1 | 14.2 | 14.4 | 14.7 | 15.7 | 16.8
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 863733d1711119183-highlighting-a-row-if-its-overdue-student-leases-demo-aligw
Sheet: Device Leases

 | Today's Date: |  |  |  |  |  | Student Device Leases [DEMO]
 | Student Information |  |  |  |  |  |  | Miscellaneous |  | Loan Information (Example of ALL Statuses) |  |  |  | Device Information
 | Student ID | Last Name | First Name | Age Group | Tutor | CAM Area | Course | Form Sent? | Notes | Issue Date | Due Date | Status | Returned? | Device Name | Checked? | Date Checked
 | 756248 | Smith | [NAME] | 16 - 18 Bursery | [NAME] | [NAME] |  | Y |  | 2023-11-03 00:00:00 | 2024-03-20 00:00:00 |  | - | ACAD-LEASE40 | Y
 | 654387 | Doe | [NAME] | 19+ Bursery | [NAME] | Cat Pennells |  | N/A |  | 2023-01-08 00:00:00 | 2024-10-01 00:00:00 |  | Y | ACAD-LEASE254 | In Repair
 | 963277 | Doe | [NAME] | 16 - 18 | [NAME] | Cat Pennells |  | N |  | 2023-02-25 00:00:00 | 2023-12-30 00:00:00 |  | - | ACAD-LEASE88 | Outstanding
 | 358423 | Last | First | 19+ | [NAME] | [NAME] |  | N/A |  | 2023-01-09 00:00:00 |  |  | - | ACAD-LEASE187 | Y
Spreadsheet: 757323d1638192120-why-v-lookup-is-not-showing-the-result-yarn-received-2021-22
Sheet: Sheet3

 |  | 2021-11-08 17:52:38
 |  | 2021-11-08 17:52:39
 |  | 2021-11-15 13:28:38
 |  | 2021-11-15 11:28:20
 |  | 2021-11-01 15:33:47
 |  | 2021-11-01 15:33:49
 |  | 2021-11-01 15:33:49
 |  | 2021-11-01 15:47:14
 |  | 2021-11-01 15:47:15
 |  | 2021-11-01 15:47:15
 |  | 2021-11-15 11:31:38
 |  | 2021-11-15 11:31:40
 |  | 2021-11-02 16:50:00
 |  | 2021-11-02 16:50:01
 |  | 2021-11-02 17:39:06
 |  | 2021-11-12 17:11:07
 |  | 2021-11-12 17:11:09
 |  | 2021-11-12 17:11:09
 |  | 2021-11-12 17:11:09
 |  | 2021-11-08 17:17:16
 |  | 2021-11-08 17:17:17
 |  | 2021-11-08 17:17:17
 |  | 2021-11-15 11:41:07
 |  | 2021-11-15 11:41:09
 |  | 2021-11-12 17:00:03
 |  | 2021-11-12 17:00:06
 |  | 2021-11-12 17:00:06
Spreadsheet: 817458d1676249894-negative-amount-and-summation-issue-2023-commission-for-designers-sample
Sheet: Abby

ABBY | January | February | March | April | May | June | July | August | September | October | November | December |  | Sales | Bonus | Class
Sales Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
Bonus adjustment |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
Subtotal after bonus adjustment |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
Damage and Loss |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
D&L Allowed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
Sub Allowed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
Open Inv - 120 D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
Bonus Expectation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
Bonus Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
 | ` |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
 | `
Spreadsheet: mary_fischer__25610__32D-2001
Sheet: E14.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032D
COMPANY NAME  Enron Building Services, Inc.
ANALYSIS OF OTHER DEFERRED CREDITS
FOR THE 3 MONTHS ENDED 3-31-2001
PREPARED BY:[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | E-14
EXTENSION:[PHONE]
 |  | 12-31-2000 Balance |  |  |  | Charged to |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash (Pd) / Rec'd |  | Income Statement |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(1)  PROVIDE DETAIL OF INDIVIDUAL ITEMS IN EXCESS OF $200,000
(2)  USE COMMENTS SECTION TO PROVIDE AN EXPLANATION OF WHY ANY REVENUE
ITEMS ARE DEFERRED AND WHAT EVENT WILL CAUSE REVENUE RECOGNITION
OTHER DEFERRED CREDITS:
 |  | 0
Total (Hyperion line 0860)
Asset/Expense Accts:  DR/(CR)
Reverse signs from Hyperion
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-14
Spreadsheet: 32470d1228665895-filter-data-surveytest
Sheet: ARH

ARH
 |  | CUSTOMER SCORE CRITERIA |  |  |  | AVERAGE PERFORMANCE BY REP
 |  | 1 - 4 | Worse Than our competitor |  |  | 1 - 4.99 | Worse Than our competitor
 |  | 5 -6 | Equal to level of service |  |  | 5 -6.99 | Equal to level of service
 |  | 7 - 8 | Exceeding our competitors service |  |  | 7 - 8.99 | Exceeding our competitors service
 |  | 9 - 10 | Excellent |  |  | 9 - 10 | Excellent
 | Company | SI REP | Price | Stock Availability | Delivery Performance | Quality of Product | Packing | Handling of rejects | Staff Response & reliabilty | Website Opinion Score | Indvidual Account Manager/Rep Score | Overall Perception of SI asa Business | SI Performance Average
 | Company 1 | ARH | 8 | 8 | 10 | 10 | 8 | 10 | 8 | 9 | 8 | 8 | 8.7
 | Company 2 | ARH | 7 | 7 | 8 | 9 | 8 | 10 | 9 | 9 | 8 | 9 | 8.4
 | Company 3 | ARH | 8 | 10 | 9 | 9 | 8 | 10 | 9 | 9 | 10 | 9 | 9.1
 | Company 4 | ARH | 7 | 8 | 8 | 8 | 9 | 8 | 6 | 8 | 8 | 8 | 7.8
 | Company 5 | ARH | 6 | 5 | 7 | 6 | 8 | 7 | 7 | 7 | 7 | 8 | 6.8
 | Company 6 | ARH | 9 | 7 | 9 | 9 | 8 | 10 | 9 | 8 | 8 | 8 | 8.5
 | Company 7 | ARH | 8 | 7 | 6 | 8 | 8 | 10 | 7 | 7 | 6 | 7 | 7.4
 | Company 8 | ARH | 8 | 7 | 8 | 8 | 9 | 10 | 9 | 9 | 9 | 9 | 8.6
 | Company 9 | ARH | 6 | 4 | 9 | 8 | 7 | 7 | 5 | 9 | 9 | 7 | 7.1
 | Company 10 | ARH | 7 | 7 | 8 | 8 | 8 | 10 | 8 | 9 | 8 | 8 | 8.1
 | Company 11 | ARH | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
 | Company 12 | ARH | 6 | 6 | 6 | 6 | 8 | 6 | 5 | 6 | 5 | 6 | 6
 | Company 13 | ARH | 6 | 5 | 9 | 6 | 6 | 10 | 4 | 8 | 7 | 7 | 6.8
 | Company 14 | ARH | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6
 | Company 15 | ARH | 8 | 8 | 8 | 10 | 10 | 10 | 7 | 9 | 8 | 8 | 8.6
 | Company 16 | ARH | 7 | 7 | 8 | 8 | 8 | 10 | 8 | 8 | 8 | 8 | 8
 | Company 17 | ARH | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6
 | Company 18 | ARH | 6 | 6 | 8 | 8 | 8 | 10 | 6 | 8 | 8 | 7 | 7.5
 | Company 19 | ARH | 7 | 7 | 9 | 8 | 8 | 10 | 8 | 8 | 8 | 8 | 8.1
 | Company 20 | ARH | 6 | 4 | 7 | 6 | 6 | 8 | 6 | 7 | 8 | 7 | 6.5
 | Company 21 | ARH | 9 | 9 | 9 | 9 | 10 | 10 | 10 | 9 | 9 | 9 | 9.3
 | Company 22 | ARH | 8 | 8 | 9 | 8 | 8 | 10 | 8 | 8 | 8 | 8 | 8.3
 | Company 23 | ARH | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7
 | Company 24 | ARH | 8 | 8 | 9 | 9 | 9 | 9 | 10 | 10 | 10 | 10 | 9.2
 | Company 25 | ARH | 8 | 8 | 8 | 10 | 10 | 10 | 7 | 9 | 8 | 8 | 8.6
 | Customer Count: 25 |  | 7.08 | 6.8 | 7.84 | 7.8 | 7.84 | 8.76 | 7.2 | 7.92 | 7.68 | 7.64 | 7.655999999999999
Spreadsheet: 0364a73e-8bcc-4010-af7e-8cb4a01ce5e4
Sheet: Sheet1

PLEASE COMPLETE GRAY AREAS. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
NAIC Code:
or WV File Number:
Assessment Year: |  |  |  |  |  |  | Due on or before:
 |  |  |  |  |  |  | July 1
Company Name:
Contact Person:
Telephone Number: | ( |  |  | ) |  |  |  |  |  | Extension:
E-Mail Address:
 | CONTINUE TO NEXT TAB                                                         Exam Assessment Payment Form
 | ↓     ↓     ↓
Spreadsheet: 0e37d577-76ef-413c-9fc8-3cbfbe1dadcc
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | State of Delaware | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 |  |  |  |  |  | Office of State Court Collections Enforcement
 |  |  |  |  |  | 97-A Parkway Circle
 |  |  |  |  |  | New Castle, DE 19720 |  | (302) 323-5356
Affidavit and
Defendant's Financial Statement
 |  |  |  | Defendant
Name: (First, Middle, Last) |  |  |  |  | Nickname, [NAME]:
Social Security No: |  | Date of Birth: |  | Age: | Student: |  |  | College/University/School:
 |  |  |  |  | ___Part time | ___Full Time | ___N/A
Current Address: |  | ___House | ___Apt./Bldg. # ____ |  | ___Mobile Home Lot # ___ |  | ___Other |  | How Long?
Previous Address: |  |  |  |  |  |  |  |  | How Long?
Permanent Mailing Address: (if student, list parent's name and address)
Home Phone No: |  | Work Phone No: |  | Message Phone No: |  | Languages Spoken:
 |  |  |  |  |  | ___English | ___Spanish | ___Other_______________
Driver's License No: |  | State: | Expiration Date: |  | [NAME]:
 |  |  |  |  | ___Single | ___Married | ___Divorced | ___Separated |  | ___Widow or Widower
No. of Dependants: |  |  |  |  |  |  |  |  | Total Dependants:
___Spouse |  | ___[NAME] (ages)________________ |  |  |  | ___Other(Relationship_________
Employer: (Name and Address) |  |  |  |  | Supervisor's Name: |  |  | Phone No:
How Long? | Your Title: |  | Hours per Week: |  | [NAME] | Pay Schedule: |  |  | Date of Next Check:
 |  |  |  |  |  | __Weekly | __[NAME] | __Other
Payroll Deductions: |  |  |  | If [NAME]: |  | Are you seeking employment? |  | How long have you been unemployed?
__Health Ins. | ___Savings |  | __Garnishments
__Life Ins. | ___Child Support |  | __Other_________ | Your Trade__________ |  | ___Yes | ___No |  | ___________Weeks
Military: (Branch) |  | Rank: |  | ___Active |  | Years: |  | Meal Card:
 |  |  |  | ___Reserves
 |  |  |  | ___National Guard |  |  |  | ___Yes | ___No
Company/Unit assigned to: |  |  |  | First Sgt.: |  | Phone No.: |  | Serial No.:
 |  |  |  | Spouse
Name: (First, Middle, Last) |  |  |  |  | Nickname, [NAME]:
Social Security No: |  |  | Employer: (Name and Address) |  |  |  | Sup. Name: |  | Phone No.:
How Long? | Title: |  | Hours per Week: |  | [NAME] | Pay Schedule |  |  | Date of Next Check
 |  |  |  |  |  | __Weekly | __[NAME] | __Other
File Attachment #1
Spreadsheet: 808d753d-3e1f-4bed-b53f-9789d7043fc7
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
PALB | Test | PALB | Prealbumin (PAB), Serum | Prealbumin (PAB), S | Nephelometry | Serum, [NAME] |  |  | 1 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 1 mL Additional Information: This is an immunologic protein measurement. For thyroxine-binding measurement of prealbumin, see TBPE / Thyroxine-Binding Protein Electrophoresis, Serum. | 0.5 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | 19-38 mg/dL | Monday through Saturday; Continuously until 3 p.m. | 1 day | 2 days | 1 | 84134 |  |  |  |  | Rochester
PALB | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
PALB | Result | PALB | Prealbumin (PAB), S | Prealbumin (PAB), S | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 46130-1 | Prealbumin:MCnc:Pt:Ser/Plas:Qn:Nephelometry
Spreadsheet: phillip_m_love__30071__aaaCredit Report
Sheet: Sheet1

DEAL ORIGINATION REPORT
Deals Input on 3/1/01
PENDING CREDIT ITEMS
Counterparty | Deal Number | Deal Type | Comm | Contact/Action Needed
Elk River Public Utility District | [NAME] | P | NG | [NAME]
NGTS LLC | QU7809.1 | F | NG | [NAME]
Octagon Resources, Inc. | QU8419.1 | F | NG | [NAME]
REBOOK ITEMS
Counterparty | Deal Number | Deal Type | Comm | Rebook To--
Amerada Hess Commodities, A Division.. | QU8190.1 | F | WTI | Hess Energy Trading Company LLC
Aquila Energy Marketing Corporation | QU7532.1 QU7545.1 | F | NG | Aquila Risk Management Corporation
Bank of America International | QU6400.1 QU6401.1 | F | NG | Bank of America, National Association
CMS Energy Corporation | QU8089.1 | F | NG | CMS Marketing, Services and Trading
Coral Energy Resources, LP | QU6602.1 | F | NG | Coral Energy Holding, LP
El Paso Gas Marketing Company | QU8122.1 | F | NG | El Paso Merchant Energy, LP
Engage Energy Canada L.P. | QU7934.1 | F | NG | Engage Energy Canada LP (w/ECC)
Enterprise Products Company | QU8410.1 | F | NG | Enterprise Products Operating Company
J. Aron & Company (Singapore) | QU7834.1 | F | NG | J. Aron & Company
Paribas | QU8353.1 | F | NG | BNP Paribas
TransCanada Energy Financial Products | QU7804.1 | F | NG | TransCanada Energy Financial Products (w/ECC)
.
Spreadsheet: 538901d1505861748-how-to-use-dates-as-reference-in-allocation-of-a-certain-amount-based-on-different-forecasting-claims
Sheet: Sheet1

Pre Construction | 0 | 119
Council Approved | 0.05 | 7
Slab | 0.15 | 28
Frame | 0.25 | 21
Enclosed | 0.3 | 49
Fixing | 0.15 | 28
Practical Completion | 0.1 | 56
Total
Job Number | Client Name | Total Claim | Start Date | Pre Construction | Council | Base | Frame | [NAME] | Fix | PCI | 2017-09-18 00:00:00
24086 | Villareal | 536580 | 2016-11-29 00:00:00
24121 | Prado | 845457 | 2016-12-22 00:00:00
24165 | Suñiga | 616326 | 2016-12-15 00:00:00
Spreadsheet: 214927d1361197938-if-date-is-not-less-than-list-of-dates-test
Sheet: Arrivals

Дата приходу | [NAME] | [NAME] номер/ID модуля/МАС адреса/Номер смарт карти | Встановлено
 |  |  | [NAME]
2012-08-31 00:00:00 | [NAME] BR-6228nS | BR6228NS21CB02421
2012-08-31 00:00:00 | [NAME] BR-6228nS | BR6228NS21CB05378
2012-08-31 00:00:00 | [NAME] BR-6228nS | BR6228NS22CC03292
2012-08-31 00:00:00 | [NAME] BR-6228nS | BR6228NS21CB03616
2012-08-31 00:00:00 | [NAME] BR-6228nS | BR6228NS21CB03618
2012-08-31 00:00:00 | Модем Thomson TCM470 | 002624DA1F68
2012-08-31 00:00:00 | Модем Thomson TCM470 | 002624DAB568
2012-08-31 00:00:00 | Модем Thomson TCM470 | 002624DA6382
2012-08-31 00:00:00 | Модем Thomson TCM470 | 002624DA3742
2012-08-31 00:00:00 | Модем Thomson TCM470 | 002624DA7860
2012-08-31 00:00:00 | Модем Thomson TCM470 | 002624B08726
2012-08-31 00:00:00 | Модем Thomson TCM470 | 002624B0859C
2012-08-31 00:00:00 | Модем Thomson TCM470 | 002624B087BC
2012-08-31 00:00:00 | Модем Thomson TCM470 | 002624B08716
2012-08-31 00:00:00 | Модем Thomson TCM470 | 002624B08584
2012-08-31 00:00:00 | Модем Thomson TCM470 | 002624DAB588
2012-08-31 00:00:00 | Модем Thomson TCM470 | 002624B08606
2012-08-31 00:00:00 | Модем Thomson TCM470 | 002624DA1F1E
2012-08-31 00:00:00 | Модем Thomson TCM470 | 002624DAB584
2012-08-31 00:00:00 | Модем Thomson TCM470 | 002624DA3758
2012-08-31 00:00:00 | Модем Thomson TCM470 | 002624B08758
2012-08-31 00:00:00 | Модем Thomson TCM470 | 002624B08510
2012-08-31 00:00:00 | Модем Thomson TCM470 | 002624DAB59E
2012-08-31 00:00:00 | Модем Thomson TCM470 | 002624DA3756
2012-08-31 00:00:00 | Модем Scientific Atlanta D/EPC2100R2 | 001E6B12245A
2012-08-31 00:00:00 | Модем Scientific Atlanta D/EPC2100R2 | 001CEA3Cfcf8
2012-08-31 00:00:00 | Модем Scientific Atlanta D/EPC2100R2 | [NAME]
2012-08-31 00:00:00 | Модем Scientific Atlanta D/EPC2100R2 | 0016925e7f06
2012-08-31 00:00:00 | Модем Scientific Atlanta D/EPC2100R2 | 001ac310ef0a
2012-08-31 00:00:00 | Модем Scientific Atlanta D/EPC2100R2 | 0016925e4a54
2012-08-31 00:00:00 | Модем Scientific Atlanta D/EPC2100R2 | 0016925e3016
2012-08-31 00:00:00 | Модем Scientific Atlanta D/EPC2100R2 | 001cea2c51d4
2012-08-31 00:00:00 | Модем Scientific Atlanta D/EPC2100R2 | 001AC310E3F2 |  | Should be Installed. Was installed later than 31.08.2012 - on 06.09.2012
2012-09-30 00:00:00 | Модем Scientific Atlanta D/EPC2100R2 | 001AC310E3F2 |  | Should be Installed. Was installed later than 30.09.2012 - on 06.10.2012
2013-03-01 00:00:00 | Модем Scientific Atlanta D/EPC2100R2 | 001AC310E3F2 |  | Should be Not Installed, because there is no modem with 001AC310E3F2 serial installed on or after 01.03.2013
Spreadsheet: 876540d1723238918-sumproduct-with-countif-sample
Sheet: Sheet1

 |  | cow
 |  | ball
 |  | bat
 |  | red
 |  | song
 |  | sing
 |  | marvel
 |  | yellow
 |  | cow
 |  | ball
 |  | bat
 |  | red
 |  | song
 |  | sing
 |  | marvel
 |  | yellow
 |  | cow
 |  | ball
 |  | bat
 |  | red
 |  | song
 |  | sing
 |  | marvel
 |  | yellow
 |  | cow
 |  | ball
 |  | bat
 |  | red
 |  | song
 |  | sing
 |  | marvel
 |  | yellow
 |  | cow
 |  | ball
 |  | bat
 |  | red
 |  | song
 |  | sing
 |  | marvel
 |  | yellow
 |  | cow
 |  | ball
 |  | bat
 |  | red
 |  | song
 |  | sing
 |  | marvel
 |  | yellow
 |  | cow
 |  | ball
 |  | bat
 |  | red
 |  | song
 |  | sing
 |  | marvel
 |  | yellow
 |  | cow
 |  | ball
 |  | bat
 |  | red
 |  | song
 |  | sing
 |  | marvel
 |  | yellow
 |  | cow
 |  | ball
 |  | bat
 |  | red
 |  | song
 |  | sing
 |  | marvel
 |  | yellow
 |  | cow
 |  | ball
 |  | bat
 |  | red
 |  | song
 |  | sing
 |  | marvel
 |  | yellow
 |  | cow
 |  | ball
 |  | bat
 |  | red
 |  | song
 |  | sing
 |  | marvel
 |  | yellow
 |  | cow
 |  | ball
 |  | bat
 |  | red
 |  | song
 |  | sing
 |  | marvel
 |  | yellow
 |  | cow
 |  | ball
 |  | bat
 |  | red
 |  | song
 |  | sing
 |  | marvel
 |  | yellow
 |  | cow
 |  | ball
 |  | bat
 |  | red
 |  | song
 |  | sing
 |  | marvel
 |  | yellow
 |  | cow
 |  | ball
 |  | bat
 |  | red
 |  | song
 |  | sing
 |  | marvel
 |  | yellow
 |  | cow
 |  | ball
 |  | bat
 |  | red
 |  | song
 |  | sing
 |  | marvel
 |  | yellow
 |  | cow
Spreadsheet: 780115d1652291798-formula-to-identify-which-records-are-our-teams-records-records-
Sheet: glossary

[NAME] | Blue Team List
[NAME], [NAME] | [NAME] (485953)
Wood, [NAME] R | [NAME] (800495)
Jones | [NAME] (26751)
[NAME], [NAME] | [NAME] (2856)
May, [NAME] | [NAME] (215698)
May, [NAME] | [NAME] (215647)
[NAME], [NAME] | [NAME] (215632)
Jones, [NAME] | [NAME] (1307)
Wood, [NAME] | [NAME] (722654)
Spreadsheet: e6429647-99f7-42ce-99a8-2623d1e337d1
Sheet: January

Date | Name | Activity
1 | New Years Day | http://www.holidayinsights.com/other/newyears.htm
2
3
4
5 | National Bird Day | http://www.holidayinsights.com/other/birdday.htm
6 | Bean Day | http://www.holidayinsights.com/other/beanday.htm
7
8 | Bubble Bath Day | http://www.holidayinsights.com/other/bubblebathday.htm
9
10
11 | Step in Puddle and Splash Your Friends Day | http://www.holidayinsights.com/other/puddle.htm
12
13
14 | National Dress Up Your Pet Day | http://www.holidayinsights.com/other/dresspet.htm
15 | National Hat Day | http://www.holidayinsights.com/other/hatday.htm
16 | [NAME] | http://www.holidayinsights.com/other/mlk.htm
17
18 | [NAME] the Pooh Day | http://www.holidayinsights.com/moreholidays/January/winniepoohday.htm
19
20 | Penguin Awareness Day | http://www.altiusdirectory.com/Society/penguin-awareness-day.php
21 | [NAME] | http://www.holidayinsights.com/moreholidays/January/squirrelappreciation.htm
22
23
24 | Opposite Day | http://www.holidayinsights.com/moreholidays/January/oppositeday.htm
25
26
27
28 | National Kazoo Day | http://www.nationalkazooday.com/
29 | National Puzzle Day | http://www.holidayinsights.com/moreholidays/January/puzzleday.htm
30
31 | [NAME] | http://www.holidayinsights.com/moreholidays/January/backwardday.htm
 | Hobby Month | http://www.ehow.com/how_2020108_national-hobby-month.html
Spreadsheet: 863167d1710763558-create-dynamic-list-based-on-blank-cells-list-based-on-blank-cells
Sheet: Desired output

Employee Number | First Name | Surname | [NAME] | GDPR Completion date :opt_field1 | CSA Completion date :opt_field2 | DSE Completion date :opt_field3 | Cyber Security Awareness :course6428 | Display Screen Equipment :[NAME] | GDPR Enhanced :[NAME] | GDPR Basic :[NAME] | GDPR Enhanced :course3629 | GDPR Basic :course3627 | Job Title | GDPR Module | Has Expired | Location | [NAME]
74540084 | Daveon | Collazo | [EMAIL] |  |  | 2024-03-31 00:00:00 |  |  |  |  |  |  | Warehouse Section Leader | GDPR Enhanced |  | Site 4 |  | Grade 13
74537721 | Brock | Shanahan | [EMAIL] | 2023-06-30 00:00:00 |  |  |  |  |  |  |  |  | Customer Service Coordinator | GDPR Enhanced |  | Site 2 |  | Grade 13
74504103 | Ramsey | Driscoll | [EMAIL] |  |  | 2024-01-31 00:00:00 |  |  |  |  |  |  | [NAME] | GDPR Basic |  | Site 8 |  | Non banded
74540636 | [NAME] | Winkler | [EMAIL] |  |  |  |  |  |  |  |  |  | Service & Operations Manager | GDPR Enhanced |  | Site 10 |  | Grade 17
74508553 | Daquan | Foote | [EMAIL] | 2023-10-31 00:00:00 |  |  |  |  |  |  |  |  | Modelling Lead | GDPR Enhanced |  | Site 3 | Transport | [NAME]