tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 814836d1674629814-comapre-2-lists-report-on-whats-not-inclusive-comapre2lists
Sheet: Sheet2

 | MID2 | Exists
 | A | Y
 | C | Y
 | L | Y
 | L | Y
 | M | N
 | G | Y
 | M | N
 | B | Y
 | Q | N
 | G | Y
 | B | Y
 | A | Y
 | K | N
 | X | N
Spreadsheet: 884495d1733724148-excel-formula-specific-time-exportreport_formula
Sheet: Sheet1

Ticket Id | From department | To Department | Created Time (Ticket) | Created Time (Time Entry) | Ticket Closed Time | Expected Result
579 | Customer Support | Onboarding Ops | 05 Dec 2024 02:23 PM | 05 Dec 2024 03:35 PM | 05 Dec 2024 03:37 PM | 0.12
579 | Onboarding Ops | Customer Support | 05 Dec 2024 02:23 PM | 05 Dec 2024 03:33 PM | 05 Dec 2024 03:37 PM | 00:04:00
582 | AML Ops | Customer Support | 05 Dec 2024 04:29 PM | 05 Dec 2024 04:31 PM | 05 Dec 2024 04:37 PM | 00:02:00
582 | Customer Support | Fraud Ops | 05 Dec 2024 04:29 PM | 05 Dec 2024 04:33 PM | 05 Dec 2024 04:37 PM | 00:02:00
582 | Fraud Ops | Credit Ops | 05 Dec 2024 04:29 PM | 05 Dec 2024 04:35 PM | 05 Dec 2024 04:37 PM | 00:02:00
582 | Credit Ops | Customer Support | 05 Dec 2024 04:29 PM | 05 Dec 2024 04:37 PM | 05 Dec 2024 04:37 PM | 1900-01-01 00:00:00
Spreadsheet: 49631d1248978987-how-to-recalculate-with-drop-down-menu-dependentdropboxes
Sheet: Sheet2

 | Option 1 | Option 2 | Option 3 |  | these are three options tjat the drop is made from
Tea | 0.5 | 0.3 | 0.1
Coffee | 0.1 | 0.2 | 0.1 |  | I want these values to be used in sheet 3 calculations -depending
Hot Chocolate | 0.1 | 0.3 | 0.4 |  | on the drop down choice
Milkshake | 0.1 | 0.1 | 0.1
Water | 0.2 | 0.1 | 0.3
Total |  |  |  |  |  | A2:A6 has been named Drinks
 |  |  |  |  |  | B2:[NAME] has been named Option1
 |  |  |  |  |  | C2:C6 has been named Option2
 |  |  |  |  |  | D2:D6 has been named Option3
Spreadsheet: 771993d1646946465-cant-find-the-correct-formula-excel-sample-220310
Sheet: Tables

 |  |  | Color |  |  | Animals |  |  | Size
 |  |  | Red | 10 |  | Lions | 10 |  | Small | 10
 |  |  | Green | 20 |  | Tigers | 20 |  | Medium | 20
 |  |  | Blue | 30 |  | Bears | 30 |  | Large | 30
Spreadsheet: 94874d1294647569-pulling-out-minimum-and-maximum-values-759305_via135
Sheet: aaaa

Weight | Value | Date |  | Weight | Min | Min Date | [NAME] | [NAME]
10 | 1000 | 2011-01-01 00:00:00 |  | 10 | 800 | 2011-02-01 00:00:00 | 1000 | 2011-01-01 00:00:00
20 | 1500 | 2011-01-01 00:00:00 |  | 20 | 1500 | 2011-01-01 00:00:00 | 1600 | 2011-02-01 00:00:00
30 | 2500 | 2011-01-01 00:00:00 |  | 30 | 2000 | 2011-02-01 00:00:00 | 2500 | 2011-01-01 00:00:00
40 | 3000 | 2011-01-01 00:00:00 |  | 40 | 3000 | 2011-01-01 00:00:00 | 3100 | 2011-02-01 00:00:00
50 | 4000 | 2011-01-01 00:00:00 |  | 50 | 3900 | 2011-02-01 00:00:00 | 4000 | 2011-01-01 00:00:00
10 | 800 | 2011-02-01 00:00:00
20 | 1600 | 2011-02-01 00:00:00
30 | 2000 | 2011-02-01 00:00:00
40 | 3100 | 2011-02-01 00:00:00
50 | 3900 | 2011-02-01 00:00:00
Spreadsheet: 72652d1273341216-search-multiple-worksheets-acme-schedules
Sheet: MATRIX 2

AMCE SERVICES
PERIOD COVERED: |  |  |  | SHIFT:
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY
MANAGER
SA 61A
SA 61B
CLERK
SA 61/1
TRANSPORT
SA 62A
SA 62B
STORAGE
SA 63
LEAD
RON
PREPARED BY: |  |  |  | SIGNATURE:
MANAGER |  |  |  | [NAME]
Spreadsheet: 790407d1659695774-my-countifs-formula-doesnt-work-always-showing-0-titip-aligw
Sheet: Sheet1

Date | Unknown | Event Start | Event End | Name | [NAME] | Class | Level | Subjects | Material | 1st Class | 2nd Class | Class- Subject | Rating | Rating Comment | Presenter | Master Teacher | Teacher Assistant
 |  | 19 Jul 2021, 15:45:00 | 19 Jul 2021, 10:53:28 | [NAME] | [EMAIL] |  |  |  |  |  |  | 3 SD-Tema 1: Ciri Ciri [NAME] (Bagian 1) Jadwal 1) | 5 | uwah uwah | Kak Wendy & Kak Ade
 |  | 19 Jul 2021, 15:45:00 | 19 Jul 2021, [NAME] | [NAME] | [EMAIL] |  |  |  |  |  |  | 4 SD-IPA Terpadu: Tema 1 - Indahnya Kebersamaan (Jadwal 1) | 5 | tebak [NAME] lucu | Kak Monic & [NAME]
 |  | 19 Jul 2021, 15:45:00 | 19 Jul 2021, 16:10:27 | [NAME] | [EMAIL] |  |  |  |  |  |  | 7 SMP-Matematika: [NAME] (Jadwal 1) | 5 | [NAME] ka [NAME] interaksi sama brainist <333 | Kak Rani & Kak Puji
 |  | 19 Jul 2021, 15:45:00 | 19 Jul 2021, 15:45:16 | [NAME] | [EMAIL] |  |  |  |  |  |  | 7 SMP-Matematika: [NAME] (Jadwal 1) | 5 |  | Kak Rani & Kak Puji
 |  | 19 Jul 2021, 16:15:00 | 19 Jul 2021, 16:21:56 | Febrino ell xaverino johan baho | [EMAIL] |  |  |  |  |  |  | 10 SMA IPA-Fisika: [NAME] (Jadwal 1) | 5 | [NAME] dipahami | Kak Wachid & [NAME]
 |  | 19 Jul 2021, 16:15:00 | 19 Jul 2021, 16:16:53 | [NAME] | [EMAIL] |  |  |  |  |  |  | 10 SMA IPA-Fisika: [NAME] (Jadwal 1) | 5 | membantu | Kak Wachid & [NAME]
 |  | 19 Jul 2021, 16:15:00 | 19 Jul 2021, 16:15:23 | [NAME] | [EMAIL] |  |  |  |  |  |  | 10 SMA IPS-Geografi: [NAME] [NAME] (Part 1) Jadwal 1) | 5 | Entertaining, easy explanation, fun intercation. thank you kak 😄 | Kak Nindya & [NAME]
 |  | 19 Jul 2021, 16:15:00 | 19 Jul 2021, [NAME] | BakerMan | [EMAIL] |  |  |  |  |  |  | 10 SMA IPS-Geografi: [NAME] [NAME] (Part 1) Jadwal 1) | 5 | cara ngajarnya asik | Kak Nindya & [NAME]
Mata Pelajaran | Jenjang
 |  |  |  |  |  | Notes : I need to know why the countifs on "SMA IPA" and "SMA IPS" doesn't work while the countif formula on "SD" and "SMP" works well.
Spreadsheet: a98305a2-1d48-404a-aac6-33c34cf4dd12
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
3542 | 7713 | [NAME] | [NAME] | AUT | 79 | 00:16:08 | 00:00:31 | 00:17:55 | 00:00:36 | 00:21:06 | 1 | 00:56:19
3542 | 10294 | Reinhardt | [NAME] | GER | 0 | 00:18:28 | 00:01:27 | 00:22:47 | [NAME] | 00:24:19 | 2 | 01:08:47
Spreadsheet: 676232d1588711495-can-not-sum-with-multiple-criteria-including-date-zeszyt4
Sheet: Sheet1

Date | Name | Amount | Status |  |  |  |  |  |  |  | 2019 |  |  | 2020
2019-10-03 00:00:00 | [NAME] | 100 | Approved |  |  |  |  |  |  | NAME | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00
2019-10-03 00:00:00 | [NAME] | 200 | Pending |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | <-----Need to fill this form
2019-10-03 00:00:00 | [NAME] | 150 | Approved |  |  |  |  |  |  | [NAME]
2019-10-03 00:00:00 | [NAME] | 400 | Approved |  |  |  |  |  |  | [NAME]
2019-10-03 00:00:00 | [NAME] | 500 | Pending |  |  |  |  |  |  | [NAME]
2019-11-04 00:00:00 | [NAME] | 50 | Pending |  |  |  |  |  |  | [NAME]
2019-11-04 00:00:00 | [NAME] | 60 | Approved
2019-11-04 00:00:00 | [NAME] | 80 | Approved
2019-11-04 00:00:00 | [NAME] | 20 | Pending
2019-11-04 00:00:00 | [NAME] | 90 | Approved
2019-12-05 00:00:00 | [NAME] | 80 | Approved
2019-12-05 00:00:00 | [NAME] | 75 | Approved
2019-12-05 00:00:00 | [NAME] | 50 | Approved
2019-12-05 00:00:00 | [NAME] | 55 | Approved |  |  |  |  |  |  | Status | Approved
2019-12-05 00:00:00 | [NAME] | 60 | Pending
2020-01-05 00:00:00 | [NAME] | 500 | Approved |  |  |  |  |  |  | Suma z Amount | Etykiety kolumn
2020-01-05 00:00:00 | [NAME] | 35 | Approved |  |  |  |  |  |  |  | 2019 |  |  | 2020
2020-01-05 00:00:00 | [NAME] | 85 | Pending |  |  |  |  |  |  | Etykiety wierszy | paź | lis | gru | sty | lut | [NAME]
2020-01-05 00:00:00 | [NAME] | 420 | Pending |  |  |  |  |  |  | [NAME] | 400 |  | 55 |  | 20
2020-01-05 00:00:00 | [NAME] | 500 | Approved |  |  |  |  |  |  | [NAME] | 150 |  | 50 | 500 | 80
2020-02-05 00:00:00 | [NAME] | 50 | Approved |  |  |  |  |  |  | [NAME] | 100 | 80 | 80
2020-02-05 00:00:00 | [NAME] | 60 | Pending |  |  |  |  |  |  | [NAME] |  | 60 | 75 | 35 |  | 10
2020-02-05 00:00:00 | [NAME] | 80 | Approved |  |  |  |  |  |  | [NAME] |  | 90 |  | 500 | 95
2020-02-05 00:00:00 | [NAME] | 20 | Approved
2020-02-05 00:00:00 | [NAME] | 45 | Approved
2020-03-08 00:00:00 | [NAME] | 70 | Pending
2020-03-08 00:00:00 | [NAME] | 10 | Approved
Spreadsheet: 4d077891-a594-4a62-96bc-f445287164b6
Sheet: page3

Section 8 |  |  |  | NOTES AND LOANS PAYABLE TO OTHERS (EXCLUDED REAL ESTATE)
 |  |  |  |  |  |  |  | How Payable
Payable To |  | Address |  | Collateral | Person(s) Liable |  | Maturity Date | $ per month | Balance Due
 |  |  |  |  |  |  |  | Totals
Section 9 |  |  |  | ACCOUNTS AND BILLS PAYABLE (Including Bank Cards)
 |  | Payable to |  | Account Number |  | Person (s) Liable | How Payable $ per month |  | Balance Due
Bank charge cards
Bank charge cards
Open & Revolving Accts
Open & Revolving Accts
Other
 |  |  |  |  |  |  |  | Total
Section 10 |  |  |  | OTHER LIABILITIES
Payable To |  | Person(s) Liable |  | Collateral |  | How Payable per Month |  | Balance Due
APPLICANT INFORMATION
Social Security Number |  |  | Employer |  | Salary |  | Occupation |  |  | No of Years
Alimony, child support or separate maintenance payment income need not be revealed if you do not wish to have it considered as a basis for repaying this obligation.
Alimony - Do you have alimony payments?( yes/no) |  |  |  |  |  | Amount?
Have you established a trust?  (yes/no)
Have you made a will? (yes/no) |  |  |  |  |  |  |  | Have you guaranteed or endorsed the notes of any other person ?  (yes/ no)
Have any actions or suits been filed against you or are there any unsatisfied judgements or decrees entered against
you, or have you ever been adjudged bankrupt or made any assigments for creditors? (yes/no) |  |  |  |  |  |  |  | If answered "Yes", please explain:
Explanation:
CO-APPLICANT INFORMATION
Social Security Number |  |  | Employer |  | Salary |  | Occupation |  |  | No of Years
Alimony, child support or separate maintenance payment income need not be revealed if you do not wish to have it considered as a basis for repaying this obligation.
Alimony - Do you have alimony payments?( yes/no)
Have you established a trust?  (yes/no)
Have you made a will? (yes/no) |  |  |  |  |  |  |  | Have you guaranteed or endorsed the notes of any other person ?  (yes/ no)
Have any actions or suits been filed against you or are there any unsatisfied judgements or decrees entered against
you, or have you ever been adjudged bankrupt or made any assigments for creditors? (yes/no) |  |  |  |  |  |  |  | If answered "Yes", please explain:
Explanation:
SIGNATURES
I authorize lender to make inquiries as necessary to verify the accuracy of the statements made and to determine my creditworthiness.  I certify the above and the
statements contained in the attachments are true and accurate as of the stated date(s).  I understand that Premier Community Bank is relying on this statement
of my financial condition in making loan(s).  Premier Community Bank may disclose to any other interested party Lender's experience with this account.
I agree to inform the Lender immediately of any matter which will cause any significant change in my financial condition.  I understand that Lender will retain this
financial statement whether or not credit is granted.
 | Applicant's Signature |  |  | Date |  | Co-Applicant's Signature |  |  | Date
 | Yes
 | No
Spreadsheet: 2b29464f-3873-4151-aabc-5157c7994f77
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259844 | 78200 | Malte | Plappert | GER | 103 | 00:14:04 | [NAME] | 00:55:11 | 00:00:38 | [NAME] | 1 | 01:33:49
259844 | 78442 | Johannes | Hinterseer | GER | 207 | 00:17:07 | 00:00:46 | 00:59:21 | [NAME] | 00:24:22 | 2 | 01:42:16
259844 | 74191 | Vass | Benedek | HUN | 206 | 00:14:37 | 00:01:27 | 01:12:20 | 00:00:54 | 00:24:14 | 3 | 01:53:34
Spreadsheet: 49613d1248969286-creating-sheets-while-referencing-a-new-row-in-some-cells-sample-data4
Sheet: Sheet1

Name | Jan |  |  |  |  |  |  | Sheet #: | 1
Address | Feb |  |  |  |  |  |  |  | Jan
 | Mar | Apr | May |  |  |  |  |  | Feb
 | city | state | zip |  |  |  |  |  | Mar
Historical Data Period: | 2008-06-01 00:00:00 | through | 2009-05-31 00:00:00 |  | amount 1 | Sep |  |  | Apr
Expected Period: | 2009-11-01 00:00:00 | through | 2010-10-31 00:00:00 | (12 months) | amount 2 | Oct |  |  | May
account | Jun |  |  |  | amount 3 | Nov |  |  | Jun
id# | Jul |  |  |  | amount 4 | Dec |  |  | Jul
 |  |  |  |  | amount 5 | Jan |  |  | Aug
 |  |  |  |  | amount 6 | Feb |  |  | Sep
type | Aug |  |  |  | amount 7 | Mar |  |  | Oct
percentage | 0.01 |  |  |  | amount 8 | Apr |  |  | Nov
 |  |  |  |  | amount 9 | May |  |  | Dec
 |  |  |  |  | amount 10 | Jun |  |  | Jan
 |  |  |  |  |  |  |  |  | Feb
 |  |  |  |  |  |  |  |  | Mar
 |  |  |  |  |  |  |  |  | Apr
 |  |  |  |  |  |  |  |  | May
 |  |  |  |  |  |  |  |  | Jun
 |  |  |  |  |  |  |  |  | 0.01
Spreadsheet: 865473d1712560644-countif-formula-to-count-number-of-times-specific-word-is-used-test-154-aligw
Sheet: Export

Categorisation | Collective | Stage | Project Name | Short Description | Project Outcomes | Benefits | Sponsor | Decision Maker | External Suppliers | Baseline Start Date | Baseline End Date | [NAME]
 |  | Closed
 |  | Discovery
 |  | Approved Pipeline
 |  | Paused
 |  | Service Improvement
 |  | Closed - completed
 |  | Closed
 |  | Paused
 |  | Closed - early
 |  | Delivery
 |  | Closed
 |  | Approved Pipeline
 |  | Approved Pipeline
 |  | Stopped - rescoping
 |  | Approved Pipeline
 |  | Closed - completed
 |  | Closed - completed
 |  | Closed - benefits realisation
 |  | Delivery
 |  | Closed - completed
 |  | Discovery
 |  | Approved Pipeline
 |  | Discovery
 |  | Closed - completed
 |  | Delivery
 |  | Closed
 |  | Closed
 |  | Closed - benefits realisation
 |  | Delivery
 |  | Delivery
 |  | Closed
 |  | Initial Assessment
 |  | Discovery
 |  | Closed - completed
 |  | Discovery
 |  | Delivery
 |  | Discovery
 |  | Closed - completed
 |  | Discovery
 |  | Paused
 |  | Delivery
 |  | Initial Assessment
 |  | Initial Assessment
 |  | Closed
 |  | Initial Assessment
 |  | Service Improvement
 |  | Discovery
 |  | Approved Pipeline
 |  | Stopped - rescoping
 |  | Initial Assessment
 |  | Discovery
 |  | Delivery
 |  | Closed
 |  | Discovery
 |  | Closed
Spreadsheet: dana_davis__4473__CANADA - 28C
Sheet: E5.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 28C
COMPANY NAME ECT - CANADA ACCOUNTING ENTRY
ANALYSIS OF GOODWILL
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-5
 |  |  |  | 12-31-99 Balance
 |  |  |  | BEGINNING |  |  |  |  |  |  |  |  |  | 12-31-2000
[NAME] OR ENTITY |  | AMORTIZATION |  | BALANCE |  |  |  |  |  | OTHER |  |  |  | BALANCE
 |  | PERIOD (Yrs.) |  | DR. (CR.) |  | ADDITIONS |  | AMORTIZATION** |  | AMOUNT |  | (DESCRIBE) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Goodwill* |  |  |  |  |  |  |  |  | ** |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 0344 | Same signs as Hyperion
**MUST TIE TO HYPERION ACCOUNT 1418 | Reverse signs from Hyperion
Spreadsheet: 871186d1717590414-countif-with-a-range-an-criteria-declared-in-a-let-statement-countspill
Sheet: Sheet1 (2)

 |  |  |  |  |  |  |  |  |  | Result | Result
 |  |  | ItemList |  | Name | Item |  | [NAME] | Count Error |  | xmatch | Count using helper
 |  |  | A |  | [NAME] | A | [NAME]
 |  |  | B |  | [NAME] | B |  | #N/A | #[NAME]! | C | F | 0
 |  |  | C |  | [NAME] | C |  | 2 | #[NAME]! | D | G | 1
 |  |  | D |  | [NAME] | D |  | 3 | #[NAME]! | E | H | 1
 |  |  | E |  | [NAME] | D |  | 7 | #N/A |  |  | 1
 |  |  | F |  | [NAME] | D |  | #N/A | #N/A |  |  | 0
 |  |  | G |  | [NAME] | A |  | #N/A | #N/A |  |  | 0
 |  |  | H |  | [NAME] | E |  | #N/A | #N/A |  |  | 0
 |  |  |  |  | [NAME] | D
 |  |  |  |  | [NAME] | D
 |  |  |  |  | [NAME] | D
 |  |  |  |  | [NAME] | A
 |  |  |  |  | [NAME] | E
Spreadsheet: 792205d1660771450-excel-formula-for-pulling-specific-names-from-fields-sample-new
Sheet: Sheet3

JOURNAL_LINE_DESCRIPTION | BATCH_NAME | Vendor
AAC-ADOBE ZONES ELA Jan22 | 28-1217 CES ADOBE Spreadsheet A 300000198949144 8179076 N | ADOBE
001-Agilsys Inc Reclass Inv#[PHONE] | Agilsys Inc Reclass Spreadsheet A 300000485468973 10055443 N | AGILYSYS INC
AA-Cisco maintenance accrue 3 mo | 24-1139c IT Mailbox Accruals - Final Close Spreadsheet A 300000276264114 8893057 N | CISCO
008-D-Coforge 26467954 Identity and Management Apr-22 | 26-1061 R-Adj Reclass Spreadsheet A 300000451929744 9976123 N | COFORGE INC
AEF-Compuware USA-2024051 Dynatrace May 22-Jun 22 | 26-1101 PPD Amortization - CES Spreadsheet A 300000218270390 10508804 N | COMPUWARE
AAP-Digital designs 24273 Doc Agent | 26-1116 PPD New Invoices Amort (EXP TO PPD) - CES Spreadsheet A 300000218270390 10672660 N | DIGITAL DESIGNS INC
AAF-EMC 75023362 Prosupport-HW | 26-1114 PPD New Invoices Amort (PPD TO EXP) - CES Spreadsheet A 300000218270390 10013786 N | EMC CORPORATION
AAA-FEDERAL EXPRESS-764393586 | 02-1007 Freight accrual Spreadsheet A 300000147941216 8153125 N | FEDERAL EXPRESS
AG-Granite-[PHONE]/10/01 RCL | 24-1140 Spreadsheet A 300000008018018 7333586 N | GRANITE
010-E-IBM 1206259 Reclass of reversed SAT | 26-1061 R-Adj Reclass Spreadsheet A 300000451929744 9182442 N | IBM
A64-Kronos 11796593 Workforce Dimensions Self Assess (Tax) | 6633 Spreadsheet A 300000218270390 6884559 N | KRONOS INC
LEXISNEXIS RISK SOLUTIONS GA INC.-1544975-20220630 | 02-1008 ROLLBACK ACCRUAL JULY 2022 Spreadsheet A 300000008027168 10621712 N | LEXISNEXIS
AAH-Lumen-5CLPMFRCH-2021/08/01 | CES Misc Reclass Spreadsheet A 300000218270390 8867946 N | LUMEN
ABU-Microstrategy #21103646 [NAME] Oct-21 thru Sep-22 | 26-1101 PPD Amortization - CES Spreadsheet A 300000218270390 10508804 N | MICROSTRATEGY SERVICES CORP
012-F-Oracle 100202593 RightNow Dec21-Feb22 | 26-1061 R-Adj Reclass Spreadsheet A 300000451929744 9182442 N | ORACLE AMERICA INC
 |  | ORACLE AMERICA INC
Spreadsheet: 858888d1707392819-help-sumif-multiple-tabs-example2
Sheet: March

Name | NHS | 1st | 2nd | 3rd | Seen | Comments |  |  | Month Summary
Name 27
Name 28
Name 29 |  |  |  |  |  |  |  |  | Done Totals
Name 30 |  |  |  |  |  |  |  |  | Outstanding Totals
Name 31
Name 32
Name 33
Name 34
Name 35
Name 36
Name 37
Name 38
Spreadsheet: 107189d1304419791-if-car-reg-is-inputted-3-times-you-get-notification-test
Sheet: Sheet1

DATE | REGISTRATION
2011-05-01 00:00:00 | HU51KUB
2011-05-01 00:00:00 | AL60UJS
2011-05-01 00:00:00 | AZ56HSP
2011-05-01 00:00:00 | XL53HHH
2011-05-01 00:00:00 | AL11JKD
2011-05-01 00:00:00 | LE05BUE
DATE | REGISTRATION
2011-05-02 00:00:00 | SO07JDD
2011-05-02 00:00:00 | [NAME]
2011-05-02 00:00:00 | AL60UJS
2011-05-02 00:00:00 | [NAME]
2011-05-02 00:00:00 | CP57PEH
2011-05-02 00:00:00 | GH02HWI
2011-05-02 00:00:00 | LL09PEO
2011-05-02 00:00:00 | HL54HJS
DATE | REGISTRATION
2011-05-03 00:00:00 | PE09ISK
2011-05-03 00:00:00 | DL52HSD
2011-05-03 00:00:00 | KS60KSL
2011-05-03 00:00:00 | VP53JSL
2011-05-03 00:00:00 | AL60UJS
2011-05-03 00:00:00 | LD56ALC
2011-05-03 00:00:00 | DP06HLL
Spreadsheet: 693853d1599185172-matching-dates-with-visit-s-example
Sheet: Sheet1

Charge Date | Visit # | Type of Transaction | Payment | Transaction Date
2017-01-01 00:00:00 | 1234 | Charge | 12
2018-05-03 00:00:00 | 1234 | Adjustment | -1
2018-04-05 00:00:00 | 1234 | Adjustment | -3
2019-04-11 00:00:00 | 1234 | Payment | 5 | 2019-04-17 00:00:00 | *I need a formula that will change the charge date on the payment date to the charge date on the charge type
2018-01-01 00:00:00 | 5678 | Charge | 10
2018-05-03 00:00:00 | 5678 | Adjustment | -2
2018-04-05 00:00:00 | 5678 | Adjustment | -1
2019-05-11 00:00:00 | 5678 | Payment | 9 | 2019-05-17 00:00:00 | *I need a formula that will change the charge date on the payment date to the charge date on the charge type
*cell A10 should be 1/1/2018, but none of the other dates should change
Spreadsheet: 716354d1612184284-rent-spreadsheet-formulas-functions-assistance-please-rent-spread-sheet-gk2
Sheet: Summary

Rent Pay Records
Tenant | Rental period (d) | Amount payable per period | Rent LAST paid | Next Due Date | Last Amount Paid | Total paid to date | Rental payments made | ARREARS3 | ARREARS2
1 | 7 | 335 | 2020-02-02 00:00:00 |  | 335 |  | 1
2 | 7 | 335 | 2020-02-09 00:00:00 |  | 335 |  | 1
3 | 7 | 300
4 | 7 | 400
2020-02-01 00:00:00 | Pay $335
2 | 2020-02-08 00:00:00 |  | Pay $335
3 | 2020-02-15 00:00:00 |  | Pay $335
4 | 2020-02-22 00:00:00 |  | Pay $335
5 | 2020-02-29 00:00:00 |  | Pay $335
6 | 2020-03-07 00:00:00 |  | Pay $335
7 | 2020-03-14 00:00:00 |  | Pay $335
8 | 2020-03-21 00:00:00 |  | Pay $335
9 | 2020-03-28 00:00:00 |  | Pay $335
10 | 2020-04-04 00:00:00 |  | Pay $335
11 | 2020-04-10 00:00:00 |  | Pay $335
12 | 2020-04-17 00:00:00 |  | Pay $335
13 | 2020-04-24 00:00:00 |  | Pay $335
14 | 2020-05-01 00:00:00 |  | Pay $335
15 | 2020-05-08 00:00:00 |  | Pay $335
16 | 2020-05-15 00:00:00 |  | Pay $335
17 | 2020-05-22 00:00:00 |  | Pay $335
18 | 2020-05-29 00:00:00 |  | Pay $335
19 | 2020-06-05 00:00:00 |  | Pay $335
20 | 2020-06-12 00:00:00 |  | Pay $335
21 | 2020-06-19 00:00:00 |  | Pay $335
22 | 2020-06-26 00:00:00 |  | Pay $335
23 | 2020-07-03 00:00:00 |  | Pay $335
24 | 2020-07-10 00:00:00 |  | Pay $335
25 | 2020-07-17 00:00:00 |  | Pay $335
26 | 2020-07-24 00:00:00 |  | Pay $335
27 | 2020-07-31 00:00:00 |  | Pay $335
28 | 2020-08-07 00:00:00 |  | Pay $335
29 | 2020-08-14 00:00:00 |  | Pay $335
30 | 2020-08-21 00:00:00 |  | Pay $335
31 | 2020-08-28 00:00:00 |  | Pay $335
32 | 2020-09-04 00:00:00 |  | Pay $335
33 | 2020-09-11 00:00:00 |  | Pay $335
34 | 2020-09-18 00:00:00 |  | Pay $335
35 | 2020-09-25 00:00:00 |  | Pay $335
36 | 2020-10-02 00:00:00 |  | Pay $335
37 | 2020-10-10 00:00:00 |  | Pay $335
38 | 2020-10-17 00:00:00 |  | Pay $335
39 | 2020-10-24 00:00:00 |  | Pay $335
40 | 2020-10-31 00:00:00 |  | Pay $335
41 | 2020-11-07 00:00:00 |  | Pay $335
42 | 2020-11-14 00:00:00 |  | Pay $335
43 | 2020-11-21 00:00:00 |  | Pay $335
44 | 2020-11-28 00:00:00 |  | Pay $335
45 | 2020-12-05 00:00:00 |  | Pay $335
46 | 2020-12-12 00:00:00 |  | Pay $335
47 | 2020-12-19 00:00:00 |  | Pay $335
48 | 2020-12-26 00:00:00 |  | Pay $335
Spreadsheet: 157716d1337854270-matrix-problem-simone
Sheet: simone

1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | birthyear | RESULT
0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1998 | 0
0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1998 | 0
0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1996 | 2
0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1996 | 2
0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1998 | 0
0 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1998 | 1
0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1998 | 0
0 | 0 | 1 | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1998 | 0
0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1998 | 0
0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1998 | 0
0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1998 | 0
0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1998 | 0
0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1999 | 0
0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1999 | 0