tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 582505d1531917116-active-x-text-box-within-table-active-x-text-box-needs-to-repeat-on-new-row-table-active-x-sample
Sheet: Sheet1

 | Date Created | Client | Supplier | List Price [NAME] | Quote Ref | Location | Postcode | Sale Price | Discount | Gross Profit | Status | Latest Comments | Next Follow Up Date | Required On Site | Comments
 | 2018-07-18 00:00:00 | Test Customer | Supplier 1 | 10000 | 123456789 | London | NW1 | 12000 | 1500 | 2300 | Quote |  | 2018-07-25 00:00:00 | 2019-02-01 00:00:00
 | 2018-07-18 00:00:00 | Test Customer | Supplier 2 | 10000 | 123456789 | London | NW1 | 12000 | 1500 | 2300 | Quote |  | 2018-07-25 00:00:00 | 2019-02-01 00:00:00
 | 2018-07-18 00:00:00 | Test Customer 2 | Supplier 3 | 5000 | 987654321 | London | NW2 | 7000 | 800 | 1200 | Sold | No active x text box auto generated in table |  |  | No active x text box auto generated in table
 | 2018-07-18 00:00:00 | Test customer 3 | Supplier 4 | 50000 | 147852369 | London | NW3 | 65000 | 6000 | 13000 | Possible | No active x text box auto generated in table |  |  | No active x text box auto generated in table
 | 2018-07-18 00:00:00 | Test customer 4 | Supplier 5 | 1000 | 197568492 | London | NW4 | 2000 | 100 | 200 | On Hold | When I enter text within the cell, the cell will expand as the text is wrapped and the row is set to auto adjust and if you look at comments column, it extends the rows accordingly and I want a uniformed look for each row. |  |  | 18/7/18: Update 1 18/7/18: Update 2 18/7/18: Update 3 18/7/18: Update 4 18/7/18: Update 5 18/7/18: Update 6 18/7/18: Update 7 18/7/18: Update 8 18/7/18: Update 9 18/7/18: Update 10 18/7/18: Update 11 18/7/18: Update 12
Spreadsheet: 717643d1612788713-counting-customers-by-the-hour-of-the-day-customer-count-ans
Sheet: Problem

[NAME] | Exit |  |  |  | Row Labels | Active Customers |  |  | TIME | Active Customers
2019-09-01 02:28:00 | 2019-09-01 23:26:00 |  |  |  | 02:00:00 | 1 |  |  | 00:00:00
2019-09-01 07:55:00 | 2019-09-01 14:43:00 |  |  |  | 03:00:00 | 1 |  |  | 01:00:00
2019-09-01 06:46:00 | 2019-09-01 09:34:00 |  |  |  | 04:00:00 | 1 |  |  | 02:00:00
2019-09-01 06:04:00 | 2019-09-01 08:00:00 |  |  |  | 05:00:00 | 1 |  |  | 03:00:00
2019-09-01 04:31:00 | 2019-09-01 05:03:00 |  |  |  | 06:00:00 | 3 |  |  | 04:00:00
2019-09-01 06:02:00 | 2019-09-01 10:04:00 |  |  |  | 07:00:00 | 5 |  |  | 05:00:00
2019-09-01 07:37:00 | 2019-09-01 09:05:00 |  |  |  | 08:00:00 | 5 |  |  | 06:00:00
2019-09-01 12:34:00 | 2019-09-01 16:09:00 |  |  |  | 09:00:00 | 5 |  |  | 07:00:00
2019-09-01 09:26:00 | 2019-09-01 12:00:00 |  |  |  | 10:00:00 | 3 |  |  | 08:00:00
2019-09-01 22:22:00 | 2019-09-02 02:05:00 |  |  |  | 11:00:00 | 2 |  |  | 09:00:00
 |  |  |  |  | 12:00:00 | 3 |  |  | 10:00:00
 |  |  |  |  | 13:00:00 | 2 |  |  | 11:00:00
 |  |  |  |  | 14:00:00 | 2 |  |  | 12:00:00
 |  |  |  |  | 15:00:00 | 1 |  |  | 13:00:00
 | 1 | 2 |  |  | 16:00:00 | 1 |  |  | 14:00:00
 |  |  |  |  | Grand Total | 10 |  |  | 15:00:00
 |  |  |  |  |  |  |  |  | 16:00:00
 |  |  |  |  |  |  |  |  | 17:00:00
 |  |  |  |  |  |  |  |  | 18:00:00
 |  |  |  |  |  |  |  |  | 19:00:00
 |  |  |  |  |  |  |  |  | 20:00:00
 |  |  |  |  |  |  |  |  | 21:00:00
 |  |  |  |  |  |  |  |  | 22:00:00
 |  |  |  |  |  |  |  |  | 23:00:00
Spreadsheet: 701031d1603470067-data-from-one-form-to-another-example-1
Sheet: Sheet1

 |  | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT
 |  | 2020-11-08 00:00:00 | 2020-11-09 00:00:00 | 2020-11-10 00:00:00 | 2020-11-11 00:00:00 | 2020-11-12 00:00:00 | 2020-11-13 00:00:00 | 2020-11-14 00:00:00 | 2020-11-15 00:00:00 | 2020-11-16 00:00:00 | 2020-11-17 00:00:00 | 2020-11-18 00:00:00 | 2020-11-19 00:00:00 | 2020-11-20 00:00:00 | 2020-11-21 00:00:00
101 | Oregon | Apple | Orange | Apple |  |  | Apple |  |  | Apple | Apple |  |  | Apple
102 | Washington | Grape |  | Grape |  |  | Grape | Grape |  |  | Grape |  | Grape |  | Grape |  | 4
103 | Alaska | Peach |  |  | Peach | Grape | Peach | Peach | Peach |  |  | Peach | Peach |  | Peach
104 | Hawaii | Melon | Apple |  | Melon |  |  | Melon |  |  | Melon |  | Melon | Melon
105 | California | Berries |  | Berries | Berries |  | Berries | Berries | Berries |  |  | Berries | Berries | Berries | Berries
106 | Idaho | Orange |  |  | Orange |  |  |  |  | Orange |  |  |  |  | Orange
107 | Nevada | [NAME] | Berries |  | Apple | Melon | [NAME] |  |  |  | [NAME] | [NAME]
 | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT
 | 2020-11-08 00:00:00 | 2020-11-09 00:00:00 | 2020-11-10 00:00:00 | 2020-11-11 00:00:00 | 2020-11-12 00:00:00 | 2020-11-13 00:00:00 | 2020-11-14 00:00:00 | 2020-11-15 00:00:00 | 2020-11-16 00:00:00 | 2020-11-17 00:00:00 | 2020-11-18 00:00:00 | 2020-11-19 00:00:00 | 2020-11-20 00:00:00 | 2020-11-21 00:00:00
Apple | 101 | 104 | 101 | 107
Grape | 102 |  | 102 |  | 103
Peach | 103 |  |  | 103
Melon | 104 |  |  | 104 | 107
Berries | 105 | 107 | 105 | 105
Orange | 106 | 101 |  | 106
[NAME] | 107
 | Only did Sunday to Thursday as example, but would need entire 2 weeks
Spreadsheet: 11aca687-03c2-4ca6-8d16-5d0b6c0c297d
Sheet: Non-Traditional

APPLICANT: |  |  |  |  |  |  |  |  | LEAD APPLICANT:
IRN (6 digits):
 |  | FY14 | FY14 | FY15 | FY16 | FY17 | FY18 | FY19 | ASSUMPTIONS
Do not alter any of the shaded cells. |  | Financial Baseline  Pre- Requested Straight A Grant  (Current Fiscal Year) | Financial Impact  Post- Requested Straight A Grant  (Current Fiscal Year) | Financial Impact  Post- Requested Straight A Grant  (1st Fiscal Year) | Financial Impact  Post- Requested Straight A Grant  (2nd Fiscal Year) | Financial Impact  Post- Requested Straight A Grant  (3rd Fiscal Year) | Financial Impact  Post- Requested Straight A Grant  (4th Fiscal Year) | Financial Impact  Post- Requested Straight A Grant  (5th Fiscal Year) | Assumptions  Provide detailed notes regarding the financial impact on each line affected by the grant funds.  These notes are critical to the evaluation of the financial sustainability.
OPERATING RECEIPTS |  | FY14 | FY14 | FY15 | FY16 | FY17 | FY18 | FY19
3110, 3211 | State Foundation Payments
1500 | Charges for Services
1600, 1700 | Fees
1830, 1840, 1850, 1860, 1870, 1890, 5100 | Other Operating Receipts
 | Total Operational Receipts
OPERATING DISBURSEMENTS |  | FY14 | FY14 | FY15 | FY16 | FY17 | FY18 | FY19
100 | Salaries and Wages
200 | Employee Retirement and Insurance Benefits
400 | Purchased Services
500 | Supplies and Materials
600 | Capital Outlay - New
700 | Capital Outlay - Replacement
800 | Other Operating Disbursements
 | Total Operating Disbursements*
Excess of Operating Receipts Over (Under)  Operating Disbursements
NONOPERATING RECEIPTS/(DISBURSEMENTS) |  | FY14 | FY14 | FY15 | FY16 | FY17 | FY18 | FY19
4000 | Federal Grants
 | Federal Fiscal Stabilization Grant
3200,  except 3211 | State Grants
1820 | Donations
1400 | Interest Income
1900 | Debt Proceeds
 | Debt Principal Retirement
 | Interest and Fiscal Charges
 | Transfers - In
 | Transfers - Out
 | Total Nonoperating Revenues/(Expenses)
Excess of Operating and Nonoperating Receipts Over/(Under) Operating and Nonoperating Disbursements
 |  | FY14 | FY14 | FY15 | FY16 | FY17 | FY18 | FY19
Fund Cash Balance Beginning of Fiscal Year
Fund Cash Balance End of Fiscal Year
Spreadsheet: 681531d1591627685-grouping-continuous-dates-dates-example
Sheet: Sheet1

Tenant | Property | From | To | Tenancy |  | Extracted
A | House1 | 2011-09-01 00:00:00 | 2012-08-31 00:00:00 |  |  | Tenant | Property | From | To | Tenancy
A | House2 | 2012-09-01 00:00:00 | 2013-08-31 00:00:00 |  |  | A | House1 | 2011-09-01 00:00:00 | 2012-08-31 00:00:00
B | House4 | 2012-09-01 00:00:00 | 2013-08-31 00:00:00 |  |  | A | House2 | 2012-09-01 00:00:00 | 2013-08-31 00:00:00
A | House3 | 2014-09-01 00:00:00 | 2015-08-31 00:00:00 |  |  | B | House4 | 2012-09-01 00:00:00 | 2013-08-31 00:00:00
A | House3 | 2016-09-01 00:00:00 | 2017-08-31 00:00:00 |  |  | A | House3 | 2014-09-01 00:00:00 | 2015-08-31 00:00:00
B | House4 | 2016-09-01 00:00:00 | 2017-08-31 00:00:00 |  |  | A | House3 | 2016-09-01 00:00:00 | 2017-08-31 00:00:00
B | House4 | 2017-09-01 00:00:00 | 2018-08-31 00:00:00 |  |  | B | House4 | 2016-09-01 00:00:00 | 2019-08-31 00:00:00
A | House4 | 2018-09-01 00:00:00 | 2019-08-31 00:00:00 |  |  | A | House4 | 2018-09-01 00:00:00 | 2021-08-31 00:00:00
B | House4 | 2018-09-01 00:00:00 | 2019-08-31 00:00:00 |  |  | C | House5 | 2019-09-01 00:00:00 | 2020-08-31 00:00:00
A | House4 | 2019-09-01 00:00:00 | 2020-08-31 00:00:00
C | House5 | 2019-09-01 00:00:00 | 2020-08-31 00:00:00
A | House4 | 2020-09-01 00:00:00 | 2021-08-31 00:00:00
Spreadsheet: 880465d1728263302-formula-for-showing-the-account-balance-of-a-previous-date-rp
Sheet: All Transaction

S.no | Date | Name | Bank name | Cr | Dr | Bal | Description
 | 2024-10-05 00:00:00 | a | BoA Bank | 87875.88 | 0 |  | Bal. Carried forward
 | 2024-10-05 00:00:00 | a | CC Bank | 2773.63 | 0 |  | Bal. Carried forward
 | 2024-10-05 00:00:00 | s | BT Bank | 6600.28 | 0 |  | Bal. Carried forward
 | 2024-10-05 00:00:00 | d | BoA Bank | 10070 | 0 |  | Bal. Carried forward
 | 2024-10-06 00:00:00 | f | BoA Bank | 0 | 5475
 | 2024-10-06 00:00:00 | f | BoA Bank | 0 | 5705
 | 2024-10-06 00:00:00 | g | BoA Bank | 0 | 5000
 | 2024-10-06 00:00:00 | g | BoA Bank | 0 | 2500
 | 2024-10-06 00:00:00 | fe | BoA Bank | 0 | 9500
 | 2024-10-06 00:00:00 | fr | BoA Bank | 0 | 23233
 | 2024-10-06 00:00:00 | rb | BoA Bank | 0 | 9500
 | 2024-10-06 00:00:00 | a | CC Bank | 0 | 80
 | 2024-10-06 00:00:00 | s | CC Bank | 0 | 40
 | 2024-10-06 00:00:00 | d | CC Bank | 0 | 385
 | 2024-10-06 00:00:00 | f | CC Bank | 0 | 140
 | 2024-10-06 00:00:00 | f | CC Bank | 0 | 60
 | 2024-10-06 00:00:00 | g | CC Bank | 0 | 250
 | 2024-10-06 00:00:00 | g | CC Bank | 0 | 300
 | 2024-10-06 00:00:00 | fe | CC Bank | 0 | 302
 | 2024-10-06 00:00:00 | fr | BT Bank | 0 | 550
 | 2024-10-06 00:00:00 | rb | Cash | 0 | 5000
 | 2024-10-06 00:00:00 | g | Cash | 0 | 1500
 | 2024-10-06 00:00:00 | fe | Cash | 0 | 4000
 | 2024-10-06 00:00:00 | fr | Cash | 0 | 7900
Spreadsheet: 879547d1727122776-count-data-exclude-duplicates-sample-count
Sheet: Sheet1

Location | Store Count
Hong Kong | 1
NY | 1
NY | 1
LA | 1
Portland | 1
NY | 1
Dallas | 1
London | 1
Sao Paolo | 1
Amsterdam | 1
Amsterdam | 1
Spreadsheet: 871659d1718087623-filter-unique-value-and-sort-from-filtered-data-in-multiple-sheet-consolidated-ledger-report-2024-25
Sheet: Final List of DR & CR

Sl. No. | Name | Amtt. DR | Amtt. CR | Balance | Ledger
 | [NAME]
 | [NAME] (Caterer)
 | [NAME]
 | [NAME]
 | Amit Dwivedi
 | Anand Tripathi
 | [NAME] (Contractor)
 | [NAME]
 | [NAME]
 | Arvind Chaudhary
 | [NAME]
 | Ashwani Chaudhary
 | [NAME] (Inspector)
 | B L Yadav
 | [NAME]
 | [NAME]
 | [NAME]
 | Cash Sales
 | Deepak [NAME] ([NAME])
 | Devraj
 | Dinesh Pandey (Volkswagen)
 | Guddu (Tile Mistri)
 | [NAME] (Kukku)
 | [NAME]
 | [NAME]
 | M/s A B Home Decore
 | M/s Abhilasha Enterprises,Rudrapur (Abhinav Mishra AGL)
 | M/s Anjneya Construction ([NAME])
 | M/s Apex Sanitary Ware
 | M/s Asian Granitoindia Ltd
 | M/s Competent Medical System (India)
 | M/s Indian Builder-Vikki
 | M/s M.S.Product & Services
 | M/s Narmit Distributors Pvt. Ltd.
 | M/s Om Sai Builders
 | M/s Prabha Marbles
 | M/s Prabha Marbles
 | M/s R A Enterprises
 | M/s Rassian Contractor
 | M/s Redbeam Industries Pvt. Ltd.
 | M/s Redbeam Indutries India Pvt. Ltd
 | M/s Rosette Interior Designers ([NAME])
 | M/s Rosette Interior Designers ([NAME])
 | M/s Shambhavi Infotech
 | M/s SYFA Traders
 | [NAME]
 | [NAME] Associate
 | [NAME]
 | O P Tiwari
 | [NAME]
 | [NAME]
 | Pratyam Bajpai (Dinesh Pandey)
 | Praveen
 | [NAME] (Ananya Associates)
 | [NAME]
 | Raju Prasad (Masterji)
 | Rakesh Dubey
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Ravindra Chaudhary (Vidhayakji)
 | S K Saxena
 | [NAME]
 | [NAME] (Jitu)
 | Shailu
 | Shiv Vardan ([NAME])
 | [NAME]
 | [NAME]
 | [NAME]
 | UPRNN
 | Uttam Singh
 | [NAME]
 | [NAME] (Surat Construction)
 | [NAME]
 | [NAME]
 | [NAME]
Spreadsheet: 3f190b49-f3c1-4ce6-a860-fed9c2e0a7bd
Sheet: 18

Product* | December 27 | January 3 | January 10 | January 17 | January 24
Total** | 31450000 | 31450000 | 31450000 | 31450000 | 31450000
Non-Deliverable Forwards | N/A | N/A | N/A | N/A | N/A
Options | N/A | N/A | N/A | N/A | N/A
Forwards | N/A | N/A | N/A | N/A | N/A
Swaps | N/A | N/A | N/A | N/A | N/A
OTHER | N/A | N/A | N/A | N/A | N/A
TOTAL
Gross notional amount outstanding, January 24 weekly snapshot, by product type, all participant types, tenors and currencies.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**These numbers are estimates.
***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: louise_kitchen__22533__3base329c
Sheet: R3 258 NP

[NAME]
Face | 259212085 |  | Today |  | Principle
Interest | 0.0725 |  | Last Pymt Date |  | Accrued Interest
 |  |  | Interest Days
 |  |  | Principle |  | Cum. Int. Exp.
Date | Beg. Bal | Payment | Interest | Principle | End Bal | [NAME]
2000-09-27 00:00:00
Spreadsheet: 28edd9bb-ba73-4940-8e20-af1b7e7cbb1e
Sheet: 8. Printable Project Summary

NON-POTABLE WATER CALCULATOR
Project Summary Sheet
1. Project Location and Contact Information
 | Project Name: |  |  |  | update |  |  |  |  | Project Date: |  |  |  | update
 | Project Address: |  |  |  | update |  |  |  |  | Project Contact: |  |  |  | update
 | Assessor's Block & Lot No. / APN: |  |  |  | update
2. Building Information Summary
 | Building Type: |  |  |  | update |  |  | Impervious Surface Above Grade: |  |  |  | ft2 |  | update
 | Total Building Size (gross square footage or GSF): |  | ft2 |  | update |  |  | Impervious Surface Below Grade: |  |  |  | ft2 |  | update
 | Total Lot Size (ft2): |  | ft2 |  | update |  |  | Landscaped Area: |  |  |  | ft2 |  | update
 | Number of Residential Units: |  | residential units |  | update |  |  | Site Location (Zone): |  |  |  |  |  | update
 |  |  |  |  |  |  |  | Compliant with State's Maximum Applied Water Allowance? |  |  |  |  |  | source
3. Summary of Nonpotable Demands and Supplies for the Project
 | Alternate Water Sources Estimates |  |  |  |  |  |  | Non-Potable Applications Estimates
 | On-site Alternate Water Source Supplies | Water Quantity (gpy) | Notes |  |  | Update Links |  | On-Site Non-potable Application Demands |  |  | Water Quantity (gpy) | Notes |  | Update Links
 | [NAME]: |  |  |  |  | update |  | Toilets/Urinals: |  |  |  |  |  | update
 | Stormwater: |  |  |  |  | update |  | Irrigation: |  |  |  |  |  | update
 | Graywater: |  |  |  |  | update |  | Decorative Fountains: |  |  |  |  |  | update
 | Foundation Drainage: |  |  |  |  | update |  | [NAME]: |  |  |  |  |  | update
 | Blackwater: |  |  |  |  | update |  | Other |  |  |  |  |  | update
 | TOTAL1: |  |  |  |  |  |  | Total:
 | 1 If there are other sources not listed in the Sources Estimates table, those sources need to be manually included in this summary or other document
 | Make-up Water Requirements
 | Month | Make-up Water Required (gal)
 | January
 | February
 | March
 | April
 | May
 | June
 | July
 | August
 | September
 | October
 | November
 | December
 | Total
4. Additional Site Information
 | Comparison of Supplies to Demands
 |  |  | Quantity (gpy) | % of Total Water Demand
 | Demands Met by Non-Potable Supply for Project
Spreadsheet: 840990d1693243664-copying-only-certain-items-to-separate-sheet-based-on-if-formula-master-2
Sheet: Food Delivery

 | Date
Time | Room | Drinks | Food | Quanity | Game Cards/Attractions | Party Add-Ons
13:00:00 |  | Coke/Sp/LM | Cheese Pizza | 5 | $10 Game Card | wristbands
13:00:00 |  |  | Pepperoni Pizza | 5 | 2 Hours Attractions
13:00:00 |  |  | Taco Bar | 25
14:00:00 | 3 | S/F/FP | Cookies | 30
14:00:00 | 3 |  | Chips | 30
Spreadsheet: 90334d1290082217-how-to-create-a-rolling-month-formula-rolling-month
Sheet: Sheet1

 | Target | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar
Area 1 | 0.53 | 0.79 | 0.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -0.04000000000000004
 | I have a formula to work out the diference between the last 2 month performance in this case May v's April in cell O2
 | Is there a formulae for cell [NAME] that will work out the performance for June v's May but only when Mays data is entered.
 | I ultimatley want it to look at only the last 2 months where data is available.
 | Thanks
Spreadsheet: 386515d1427823182-if-and-statement-maybe-conditional-formating-for-all-three-fail
Sheet: Sheet1

2014-12-31 00:00:00 | 2014-09-30 00:00:00 | 2014-06-30 00:00:00
Fail | Fail | Fail |  | *How to get column "D" to show an "X" if all three rows A,B,C say [NAME] and an Okay if they are not ALL Fail?
Fail | Fail | Fail
Fail | Fail | Fail
Fail | Fail | Fail
Fail | Fail | Fail
Fail | Pass | Pass
Fail | Fail | Pass
Fail | Fail | Pass
Fail | Pass | Pass
Fail | Pass | Pass
Fail | Fail | Pass
Pass | Pass | Pass
Pass | Pass | Pass
Pass | Pass | Pass
Pass | Pass | Pass
Pass | Pass | Pass
Spreadsheet: 543905d1508664747-powerpivot-not-working-as-intended-question
Sheet: Consultants

Consultant ID | Consultant Name
CID001 | [NAME]
CID002 | [NAME]
CID003 | [NAME]
CID004 | Tessa
CID005 | [NAME]
CID006 | [NAME]
CID007 | [NAME]
CID008 | [NAME]
CID009 | Rose
CID010 | [NAME]
CID011 | [NAME]
CID012 | Satan
CID013 | Cock
CID014 | [NAME]
CID015 | [NAME]
Spreadsheet: 786056d1656949422-large-numbers-of-criteria-and-relevant-formula-test-file-1
Sheet: Sheet1

Inspector [NAME] | AOM
JOHN MISKIEWICZ | [NAME]
[NAME] | [NAME]
RAYMOND HARRISON | [NAME]
RAYMOND HARRISON | [NAME]
[NAME] | [NAME]
[NAME]
MATTHEW HAYNES
[NAME]
[NAME]
MARC BULLETT
[NAME]
[NAME]
[NAME]
ALEX NEVES
[NAME] TOBIN
[NAME]
[NAME]
PAUL MCQUEEN
MATTHEW HAYNES
ALEX NEVES
Spreadsheet: 683852d1592987995-finding-matching-info-in-2-excel-tables-00_invoices-follow-up
Sheet: Overview

 | SALES |  |  | OPEN INVOICES
 |  | DE |  |  | DE
 |  | IT |  |  | IT
 |  | TOTAL |  |  | TOTAL
 | COOP |  |  | TOTAL | % SALES
 | DE | MKT | 0.1
 |  | DAMAGE
 | IT | MKT | 0.1
 |  | DAMAGE
Spreadsheet: 839083d1691650655-sumif-formula-help-financial-report-2023-season-financial-report-2-
Sheet: May

Date | Transaction | Withdrawals | Deposits | Balance | Code | Comments
Opening balance |  |  |  | 9159.69
2023-05-01 00:00:00 | INTEREST |  | 0.06 | 9159.75 | INT
2023-05-01 00:00:00 | DIRECT CREDIT  PLAYHQCOM_NoP6hT1t PLAYHQCOM            [PHONE] |  | 65.8 | 9225.55 | PLAYHQ
2023-05-01 00:00:00 | DIRECT CREDIT SQUARE AU PTY LT    [PHONE] |  | 661.18 | 9886.73 | SQ
2023-05-01 00:00:00 | OSKO PAYMENT   Ashlee M Craig Coles & woollies canteen stoc> | 102.16 |  | 9784.57 | REIMB
2023-05-01 00:00:00 | OSKO PAYMENT   Midland Sports Wareh Tackle bag remaining payment | 28.8 |  | 9755.77 | UNI
2023-05-02 00:00:00 | DIRECT CREDIT  175149 DLGSC EFT            [PHONE] |  | 115 | 9870.77 | KID
2023-05-05 00:00:00 | DIRECT CREDIT SQUARE AU PTY LT    [PHONE] |  | 323.34 | 10194.11 | SQ
2023-05-08 00:00:00 | OSKO PAYMENT   [NAME] restock | 201.05 |  | 9993.06 | REIMB
2023-05-08 00:00:00 | OSKO PAYMENT   [NAME] lasagna [NAME] dinn> | 81.75 |  | 9911.31 | REIMB
2023-05-08 00:00:00 | OSKO PAYMENT   Midland Trophies 2022 medals/trophies and hono> | 1901 |  | 8010.31 | TRO
2023-05-08 00:00:00 | OSKO PAYMENT   [NAME] Pattie’s 27/4 | 52.5 |  | 7957.81 | REIMB
2023-05-08 00:00:00 | DIRECT CREDIT  PLAYHQCOM_Nr14q4uE PLAYHQCOM            [PHONE] |  | 98.7 | 8056.51 | PLAYHQ
2023-05-11 00:00:00 | DIRECT CREDIT  175986 DLGSC EFT            [PHONE] |  | 115 | 8171.51 | KID
2023-05-12 00:00:00 | DIRECT CREDIT KIRSTI WILSON |  | 50 | 8221.51 | OTH+ | Dayman family fees payment
2023-05-12 00:00:00 | OSKO PAYMENT Lollies INV-2395 | 143.4 |  | 8078.11 | OTH- | Lollies for canteen (Route 66)
2023-05-12 00:00:00 | OSKO PAYMENT   Midland Sports Wareh SG58329/01 balls & field mark> | 364.65 |  | 7713.46 | UNI
2023-05-12 00:00:00 | OSKO PAYMENT   [NAME] butcher hamburger [NAME] | 61.25 |  | 7652.21 | REIMB
2023-05-12 00:00:00 | OSKO PAYMENT   [NAME] canteen stock | 183.06 |  | 7469.15 | REIMB
2023-05-12 00:00:00 | OSKO PAYMENT Bread rolls | 24.5 |  | 7444.65 | REIMB
2023-05-12 00:00:00 | DIRECT CREDIT SQUARE AU PTY LT |  | 226.33 | 7670.98 | SQ
2023-05-15 00:00:00 | DIRECT CREDIT SQUARE AU PTY LT |  | 571.14 | 8242.12 | SQ
2023-05-18 00:00:00 | OSKO PAYMENT   Ashlee M Craig Coles shop weekend canteen | 55.84 |  | 8186.28 | REIMB
2023-05-18 00:00:00 | OSKO PAYMENT Coles shop | 53.55 |  | 8132.73 | REIMB
2023-05-18 00:00:00 | OSKO PAYMENT Coles | 55.6 |  | 8077.13 | REIMB
2023-05-19 00:00:00 | DIRECT CREDIT SQUARE AU PTY LT |  | 207.33 | 8284.46 | SQ
2023-05-25 00:00:00 | DIRECT CREDIT KIRSTI WILSON |  | 50 | 8334.46 | OTH+ | Dayman family fees payment
2023-05-26 00:00:00 | DIRECT CREDIT SQUARE AU PTY LT |  | 239.31 | 8573.77 | SQ
Transaction totals / Closing balance |  | 3309.11 | 2723.19 | 8573.77
Spreadsheet: 802496d1666883160-formula-to-return-value-depending-on-the-cell-text-and-how-many-instalments-specified-calc-test
Sheet: calc test

Code | Contact Name | Balance | Payment Method |  | NOV DD | DEC DD | JAN DD | FEB DD | INSTALMENTS TOTALS | OTHER PMT METHOD | CREDIT BALANCE | TOTALS CORRECT
0001 | [NAME] | 2403.91 | 3 Month DD |  | 801.3 | 801.3 | 801.31 | 0 |  |  |  |  |  |  |  |  | 3 month DD | 3
0002 | [NAME] mum | 7.57 | CHQ Cash/Chq/STO |  | 0 | 0 | 0 | 0 |  | 7.57 |  |  |  |  |  |  | 4 month DD | 4
0003 | [NAME] dad | 216.45 | 4 month dd |  | 54.1125 | 54.11 | 54.11 | 54.12 |  |  |  |  |  |  |  |  | DD | 1
0004 | [NAME] sister | 2288 | dd |  | 2288 | 0 | 0 | 0
0005 | [NAME] brother | 2653.33 | 4 month dd |  | 663.3325 | 663.33 | 663.33 | 663.34
0006 | [NAME] nan | 2695.75 | 4 month dd |  | 673.9375 | 673.94 | 673.94 | 673.93
0007 | [NAME] grandad | 2695.75 | 3 Month DD |  | 898.5833333333334 | 898.58 | 898.59 | 0
0008 | [NAME] pal | 2800.75 | 3 Month DD |  | 933.5833333333334 | 933.58 | 933.59 | 0
0009 | [NAME] neighbour | 685.63 | dd |  | 685.63 | 0 | 0 | 0
 |  |  | DD total
 |  |  | 3 month total
 |  |  | 4 month total
 |  |  | Bank Export |  | 6998.48
 |  |  | [NAME]
Spreadsheet: 273636d1382808649-solved-ignoring-error-cells-in-final-sum-formula-product-table-dbz-err
Sheet: OBJEKT

PRODUCT | NUMBER OF PRODUCTS ON SHELF | PERCENTAGE OF  TAKEN SHELVES | POINTS | SPACE TAKEN BY PACKAGES IN STOREHOUSE (m²) | PERCENTAGE OF TAKEN SPACE IN STOREHOUSE | P      O        I        N       T        S | HAS CONTENT  I. | P      O        I        N       T        S | PRICE | P      O        I        N       T        S | HAS CONTENT  II. | P       O        I        N        T        S | HAS CONTENT III. | P      O        I        N       T        S | T     O     T      A     L
TOTAL
PRODUCT A | 0 |  |  | 0 |  |  | YES |  | 6.79 |  | [NAME],bla |  | bla, no, yes
PRODUCT B | 0 |  |  | 0 |  |  | NO |  | 6.79 |  | NOT YET BUT…
PRODUCT C | 0 |  |  | 0 |  |  | NOT YET |  | 5.29 |  |  |  | YES
PRODUCT D | 0 |  |  | 0 |  |  |  |  | 2.99 |  | YES
PRODUCT E | 0 |  |  | 0 |  |  | YES |  | 2.99 |  |  |  | No
PRODUCT F | 0 |  |  | 0 |  |  | YES |  | 4.49 |  |  |  | yes
PRODUCT G | 0 |  |  | 0 |  |  |  |  | 4.45
How to give points:
PERCENTAGE OF  TAKEN SHELVES                      (D column)
PERCENTAGE OF TAKEN SPACE IN STOREHOUSE  (G column)
HAS [NAME] (I column)
PRICE  (K column)
HAS CONTENT II.   (M column)
HAS CONTENT III.   (O column)