tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 86337d1286345212-excel-complex-mailto-feature-macro-fix-outlook-attachment-testers
Sheet: FilterExample

 | Note: There is more information on the webpage
 | Mail a row or rows to each person in a range (Attachment)
 | [NAME]
 | We filter the range A17:C? for every unique name in the name column (column A in this example)
 | For every unique name we create a new file with only the data of that person and send it to the
 | mail address it find with the VLookup function in the worksheet "Mailinfo".
 | Important : This example also use the sheet named "MailInfo"
 | Note: Fill in a correct mail address for each name in the name column in the sheet "MailInfo"
 | You find the macro in Module6
Name | Student information | Other Info
[NAME] | [NAME] about [NAME] | Other Info about [NAME]
[NAME] | [NAME] | Other Info about Dave 1
[NAME] | [NAME] about [NAME] | Other [NAME] about [NAME]
[NAME] | [NAME] about [NAME] | Other Info about [NAME]
[NAME] | [NAME] about Dave 2 | Other Info about Dave 2
[NAME] | [NAME] about [NAME] | Other [NAME] about [NAME]
[NAME] | [NAME] about [NAME] | Other Info about [NAME]
[NAME] | [NAME] | Other Info about Dave 3
[NAME] | [NAME] about [NAME] | Other [NAME] about [NAME]
[NAME] | [NAME] about [NAME] | Other Info about [NAME]
[NAME] | [NAME] | Other Info about Dave 4
[NAME] | [NAME] about [NAME] | Other [NAME] about [NAME]
[NAME] | [NAME] about [NAME] | Other Info about Ron 5
[NAME] | [NAME] about Dave 5 | Other Info about Dave 5
[NAME] | [NAME] about [NAME] | Other [NAME] about [NAME]
[NAME] | [NAME] about [NAME] | Other Info about Ron 6
[NAME] | [NAME] | Other Info about Dave 6
[NAME] | [NAME] about [NAME] | Other [NAME] about [NAME]
Spreadsheet: 808559d1670516578-what-formula-to-use-to-show-if-there-is-a-missing-sku-from-a-field-book1
Sheet: Details

 | *Missing SKU Here* If Any, from A3:A55.
 | 5025-000081 | 1
5031-000018 | 5018-000002 | 1
5031-000018 | 5024-000001 | 1
5031-000018 | 5014-000008 | 0.01
5031-000018 | 5022-000001 | 1
5031-000018 | 5018-000004 | 1
5031-000018 | 5009-000175 | 1
5031-000018 | 5024-000003 | 1
5031-000018 | 5009-000003 | 2
5031-000018 | 5009-000176 | 2
5031-000018 | 5024-000002 | 1
5031-000018 | 5018-000023 | 1
5031-000018 | 5009-000185 | 1
5031-000018 | 5008-000134 | 1
5031-000018 | 5024-000012 | 1
5031-000018 | 5008-000221 | 1
5031-000018 | 5009-000148 | 4
5031-000018 | 5017-000007 | 1
5031-000018 | 5009-000212 | 3
5031-000018 | 5009-000171 | 1
5031-000018 | 5010-000003 | 1
5031-000018 | 5013-000026 | 1
5031-000018 | 5018-000006 | 1
5031-000021 | 5006-000084-10 | 1
5031-000021 | 5008-000219-10 | 1
5031-000040 | 5018-000035 | 1
5031-000040 | 5010-000036 | 7
5031-000040 | 5001-000049 | 1
5031-000040 | 5009-000185 | 2
5031-000045 | 5013-000028 | 1
5031-000045 | 5009-000141 | 1
5031-000047 | 5009-000098 | 2
5031-000047 | 5013-000025 | 1
Spreadsheet: 724098d1616008812-omitting-cell-containing-text-in-my-sumproduct-formula-budget-report-2-
Sheet: Budget3

Contractor
Budget
CO
Total
1
2
3 |  |  |  |  |  |  | False
4
5 |  | visa |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
1
2
3 |  |  |  |  |  |  | False
4
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
1
2
3
4
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
1
2
3
4
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
1
2
3
4
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
1
2
3
4
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
1
2
3
4
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
AB
PB
AP
 |  |  |  |  | JOB #: |  |  |  |  |  |  |  |  |  |  |  | SUPERINTENDENT: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 - Invoice Date 2 - Invoice # 3 - Amount 4 - Date Paid 5 - Check # |  |  | AB - Amount Billed PB - Pending Billing AP - Amount Paid
 |  |  |  |  | ADDRESS:
Spreadsheet: 200132d1355423953-look-up-across-several-columns-same-row-and-return-value-in-another-cell-lookup-test-file
Sheet: Region

 |  |  |  |  |  | WA
Product Segment | Category | Supplier | Contract ID | Start | End | Spend | Tier
Anesthesia | [NAME] | Vendor 1 | MS60261 | 2007-01-01 00:00:00 | 2011-12-31 00:00:00 | 177.92
Anesthesia | [NAME] | Vendor 2 | MS60262 | 2007-01-01 00:00:00 | 2011-12-31 00:00:00 | 43030.8
Anesthesia | [NAME] | Vendor 3 | MS60263 | 2007-01-01 00:00:00 | 2011-12-31 00:00:00 | 85606.86
Anesthesia | Anesthesia Machines | Vendor 4 | CE91091 | 2009-08-01 00:00:00 | 2014-07-31 00:00:00 | 4502.58
Anesthesia | Anesthesia Machines | Vendor 5 | CE91092 | 2009-08-01 00:00:00 | 2014-07-31 00:00:00 | 39943.94
Anesthesia | Anesthesia Masks | Vendor 6 | MS0293 | 2012-01-01 00:00:00 | 2014-12-31 00:00:00 | 174949.02
Anesthesia | Anesthesia Masks | Vendor 7 | MS0292 | 2012-01-01 00:00:00 | 2014-12-31 00:00:00
Anesthesia | Anesthesia Masks | Vendor 8 | MS0351N | 2012-01-01 00:00:00 | 2014-12-31 00:00:00 | 2082
Anesthesia | Anesthesia Masks | Vendor 9 | MS60401 | 2007-01-01 00:00:00 | 2011-12-31 00:00:00
Anesthesia | Anesthesia Masks | Vendor 10 | MS0291 | 2012-01-01 00:00:00 | 2014-12-31 00:00:00 | 441.12
Anesthesia | Anesthesia Masks | Vendor 11 | MS0294 | 2012-01-01 00:00:00 | 2014-12-31 00:00:00 | 117992.66
Anesthesia | Anesthesia Masks | Vendor 12 | MS60402 | 2007-01-01 00:00:00 | 2011-12-31 00:00:00 | 5916.56
Anesthesia | [NAME] | Vendor 13 | MS11161 | 2011-03-01 00:00:00 | 2014-02-28 00:00:00 | 225215.42
Anesthesia | [NAME] | Vendor 14 | MS11162 | 2011-03-01 00:00:00 | 2014-02-28 00:00:00 | 35332.96
Spreadsheet: 202502d1356610559-text-to-function-myob-sample-data
Sheet: Sheet1 (2)

Acct# | Account Name | Beginning Balance |  | Number conversion
1-1100 | General Cheque Account | 13787.93
1-1120 | Drawing Account | $3,043.50cr |  | -3043.5
1-1130 | Cash Register Drawer | 16793
1-1140 | Petty Cash | $20,677.80cr
1-1150 | Undeposited Funds | 278
1-1200 | Trade Debtors | 65224.5
1-3220 | Motor Vehicles Accum.[NAME] | 0
1-3310 | Equipment & Computers (at cost | 5909.09
1-3320 | Equip. & Comp. [NAME].[NAME] | 0
1-4300 | Goodwill | 160000
1-4400 | Franchise Fees | 45000
2-1100 | Trade Creditors | $19,614.90cr
2-1210 | PAYG Withholding Tax Payable | $93,133.00cr
2-1220 | Superannuation Payable | $3,863.07cr
2-1230 | Payroll Deductions Payable | $25.00cr
2-3360 | Import Duty Payable | 1381.12
2-3361 | Customs Clearance GST | 3208.58
2-3380 | ABN Withholding Payable | 0
2-3390 | Luxury Car Tax Payable | 0
 | Total:
 |  | [NAME] |  | True value
Spreadsheet: 110455d1307107485-adjusting-coding-for-new-criteria-workbook41
Sheet: Sheet1

DOUBLE |  | 1111
 |  | 9116 |  |  |  | Highlighted are the numbers NOT picked up - what would the coding revision need to be to do this?  I'm wanting to pickup any multiple of numbers (2 or more).
 |  | 9117
 |  | 9118
 |  | 9119
 |  | 9123
 |  | 9125
 |  | 22
 |  | 23
 |  | 122
 |  | 9129
 |  | 9132
 |  | 9133
 |  | 9135
 |  | 9136
 |  | 9137
 |  | 9138
 |  | 9139
 |  | 9142
 |  | 9143
 |  | 9145
 |  | 9146
 |  | 9147
 |  | 9148
 |  | 9149
 |  | 9152
 |  | 9155
 |  | 9156
 |  | 9157
 |  | 9158
 |  | 9159
 |  | 9162
 |  | 9166
 |  | 9167
 |  | 9168
 |  | 9169
 |  | 9177
 |  | 9333
 |  | 9335
 |  | 9336
 |  | 9337
 |  | 9338
 |  | 9339
 |  | 9343
 |  | 9345
 |  | 9346
 |  | 9347
 |  | 9348
 |  | 9349
Spreadsheet: 781094d1652979281-powerquery-return-value-in-one-column-if-certain-values-appear-in-another-formula-help
Sheet: Sheet1

Install_Status_By_Instruction | Instruction_Install_Date
ReSubmittedComplete | 2022-05-10 00:00:00 | FORMULA: IF A Contains either "ReSubmittedComplete", or "ReSubmitted" or "Complete", then return the Date in column B, else return Blank.
ReSubmittedComplete | 2022-05-10 00:00:00
ReSubmittedComplete | 2022-05-10 00:00:00
ReSubmitted | 2022-04-13 00:00:00
ReSubmitted | 2022-04-13 00:00:00
ReSubmitted | 2022-04-13 00:00:00
ReSubmitted | 2022-04-13 00:00:00
ReSubmitted | 2022-04-13 00:00:00
On-Site | 2022-04-22 00:00:00
On-Site | 2022-04-22 00:00:00
On-Site | 2022-04-22 00:00:00
Completed | 2022-04-19 00:00:00
Completed | 2022-04-19 00:00:00
Completed | 2022-04-25 00:00:00
Cancelled | 2022-05-12 00:00:00
Appointment Booked | 2022-05-30 00:00:00
Appointment Booked | 2022-05-30 00:00:00
Appointment Booked | 2022-05-30 00:00:00
Access Denied | 2022-04-28 00:00:00
Spreadsheet: 594647d1539880215-index-match-question-test1-1
Sheet: Sheet1

Date | Item |  | High | Low | Low1 |  | TEST1 |  |  |  |  | TEST2 |  |  |  |  | TEST3
2013-01-02 00:00:00 | TEST1 |  | 5 | 4 | 3
2013-01-03 00:00:00 | TEST3 |  | 100 | 99 | 98
2013-01-04 00:00:00 | TEST8 |  | 50 | 49 | 48
2013-01-04 00:00:00 | TEST1 |  | 10 | 9 | 8
2013-01-04 00:00:00 | TEST4 |  | 20 | 19 | 18
2013-01-04 00:00:00 | TEST1 |  | 10 | 9 | 8
2013-01-10 00:00:00 | TEST8 |  | 50 | 49 | 48
2013-01-11 00:00:00 | TEST8 |  | 10 | 9 | 8
2013-01-15 00:00:00 | TEST3 |  | 20 | 19 | 18
2013-01-15 00:00:00 | TEST1 |  | 30 | 29 | 28
2013-01-15 00:00:00 | TEST9 |  | 40 | 39 | 38
2013-01-16 00:00:00 | TEST1 |  | 50 | 49 | 48
2013-01-17 00:00:00 | TEST2 |  | 5 | 4 | 3
2013-01-17 00:00:00 | TEST7 |  | 6 | 5 | 4
2013-01-17 00:00:00 | TEST3 |  | 8 | 7 | 6
2013-01-18 00:00:00 | TEST8 |  | 10 | 9 | 8
2013-01-22 00:00:00 | TEST1 |  | 100 | 99 | 98
2013-01-24 00:00:00 | TEST2 |  | 90 | 89 | 88
2013-01-25 00:00:00 | TEST3 |  | 80 | 79 | 78
2013-01-28 00:00:00 | TEST8 |  | 70 | 69 | 68
2013-01-28 00:00:00 | TEST7 |  | 60 | 59 | 58
2013-01-29 00:00:00 | TEST4 |  | 50 | 49 | 48
2013-01-30 00:00:00 | TEST2 |  | 40 | 39 | 38
2013-01-30 00:00:00 | TEST1 |  | 30 | 29 | 28
2013-01-31 00:00:00 | TEST3 |  | 20 | 19 | 18
Spreadsheet: 715541d1611760583-need-help-setting-up-item-locations-with-forecast-pick-sequence
Sheet: Pick Lists

Level 4 |  |  |  |  |  |  | Level 3 |  |  |  |  |  |  | Level 2 |  |  |  |  |  |  | Level 3 |  |  |  |  |  |  | Order
Even/Odd | Aisle | Bay | Level | Location ID | [NAME] |  | Even/Odd | Aisle | Bay | Level | Location ID | [NAME] |  | Even/Odd | Aisle | Bay | Level | Location ID | [NAME] |  | Even/Odd | Aisle | Bay | Level | Location ID | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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
Spreadsheet: 183087d1348690981-sum-up-multiple-sheets-in-same-workbook-book2
Sheet: Tom

NAME | AMOUNT
[NAME] | 1302.4
[NAME] | 953.2
[NAME] | 845.3
Ericka Mooney | 661.9
[NAME] | 268.5
[NAME] | 97.5
[NAME] | 148
[NAME] | 447.75
[NAME] | 743.5
[NAME] | 5468.050000000001
Spreadsheet: 61595d1262537005-sum-formatting-problem-example1
Sheet: 130050

FLIGHT LOG - N908DH
 |  |  |  |  |  |  |  |  |  |  | GR-1040 INC |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 130050
 |  |  |  |  |  |  |  |  |  |  | 5151 Mitchelldale, Suite B-2 |  |  |  |  |  |  |  |  |  |  |  |  |  | LOG NO:
 |  |  |  |  |  |  |  |  |  |  | Houston, [NAME]
PIC: | SCOTT VAN KESTEREN |  |  |  |  |  |  |  |  |  | (818) 807-6408 / Fax:  (818) 883-6165 |  |  |  |  |  |  |  |  |  |  |  |  |  | Return Date:
SIC: | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dept Date:
F/A: | CHRISTY HOLT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Days:
IRP: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RON's:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Previous  Log Closed:
[NAME] |  |  |  |  |  |  | CLA TIME |  |  |  | CURRENCY |  |  |  |  | FUEL |  |  |  | PER DIEM |  |  |  |  | ZULU
LEG | DATE | B/P/C | PF | FROM | TO |  | T.O. | FLIGHT | LDG |  | NIGHT | D/N | P/N/V | HOLD |  | OUT | IN | TOTAL |  | HOURS |  | RATE | $ |  | T.O. | LDG
1 | 2009-10-14 00:00:00 | C | MG | TEB | VNY | 15:32:00 | 14:26:00 | 05:55:00 |  |  | 02:55:00 | N | V | 0 |  | 23600 | 4650 |  |  |  |  | 2.25
2 |  |  |  | 0 | 0 |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  | 0
3 |  |  |  |  | 0 |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  | 0
4 |  |  |  | 0 | 0 |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  | 0
5 |  |  |  |  | 0 |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  | 0
6 |  |  |  |  | 0 |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  | 0
7 |  |  |  |  | 0 |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  | 0
8 |  |  |  |  | 0 |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  | 0
9 |  |  |  |  | 0 | 3 | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  | 0
 | PST | 8:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ` |  |  | Closed
 | DST | 7:00:00
 | Today |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Per Diem Add - Fwd from previous [NAME]. Log only |  |  |  |  |  | 0
 |  |  |  |  | HOURS |  |  | CYCLES |  |  |  |  |  |  |  |  |  |  |  | Per Diem Add
 | ACTT Forwarded
 | Total this Log |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Adjusted Total
 | Totals to Date
Spreadsheet: 1acbc5b5-eba7-43ce-aba6-394b78c6d600
Sheet: ANTHRO

 | PROGRAM LEVEL | # | SLOs | # | ASSESSMENT METHOD  DEFINED | # | ASSESSED COURSE | # | DISCUSSION/ IMPROVEMENT | #
 | A.A. Degree Anthropology | 1 | X | 1
 | TOTAL
 | PERCENTAGE
 | COURSE
5 | ANTHRO 100 | 1
3 | ANTHRO 102 | 1 | X | 1 | X | 1
3 | ANTHRO 106 | 1 | X | 1 | X | 1
5 | ANTHRO 107 | 1
5 | ANTHRO 110 | 1
 | TOTAL
 | PERCENTAGE
Spreadsheet: 839083d1691650655-sumif-formula-help-financial-report-2023-season-financial-report-2-
Sheet: March

Date | Transaction | Withdrawals | Deposits | Balance | Code | Comments
Opening balance |  |  |  | 10435.65
2023-03-01 00:00:00 | INTEREST |  | 0.08 | 10435.73 | INT
2023-03-02 00:00:00 | DIRECT CREDIT  PLAYHQCOM-V7dQuISd PLAYHQCOM            [PHONE] |  | 96.73 | 10532.46 | PLAYHQ
2023-03-03 00:00:00 | DIRECT CREDIT  PLAYHQCOM-lTz1SfKw PLAYHQCOM            [PHONE] |  | 96.73 | 10629.19 | PLAYHQ
2023-03-07 00:00:00 | OSKO PAYMENT   Zacks Commercial Art Playing jumpers x 2 sets | 3216.5 |  | 7412.69 | UNI
2023-03-08 00:00:00 | DIRECT CREDIT  PLAYHQCOM-6fKS1ktU PLAYHQCOM            [PHONE] |  | 32.9 | 7445.59 | PLAYHQ
2023-03-09 00:00:00 | OSKO PAYMENT   [NAME] for rego day | 106.54 |  | 7339.05 | REIMB
2023-03-09 00:00:00 | DIRECT CREDIT  PLAYHQCOM_NUXZKWgL PLAYHQCOM            [PHONE] |  | 193.46 | 7532.51 | PLAYHQ
2023-03-10 00:00:00 | DIRECT CREDIT  PLAYHQCOM_NUuoq8Km PLAYHQCOM            [PHONE] |  | 96.73 | 7629.24 | PLAYHQ
2023-03-13 00:00:00 | DIRECT CREDIT SQUARE AU PTY LT    [PHONE] |  | 225.6 | 7854.84 | SQ
2023-03-16 00:00:00 | DIRECT CREDIT  PLAYHQCOM-8idXfQ7c PLAYHQCOM            [PHONE] |  | 65.8 | 7920.64 | PLAYHQ
2023-03-17 00:00:00 | DIRECT CREDIT  PLAYHQCOM_NXX1on1a PLAYHQCOM            [PHONE] |  | 96.73 | 8017.37 | PLAYHQ
2023-03-21 00:00:00 | DIRECT CREDIT  172335 DLGSC EFT            [PHONE] |  | 345 | 8362.37 | KID
2023-03-22 00:00:00 | DIRECT CREDIT  PLAYHQCOM_NZPfwGUg PLAYHQCOM            [PHONE] |  | 96.73 | 8459.1 | PLAYHQ
2023-03-24 00:00:00 | OSKO PAYMENT   [NAME] rolls for rego day - Ar> | 60 |  | 8399.1 | REIMB
2023-03-24 00:00:00 | OSKO PAYMENT   WAFC INV14950 Affiliation fee | 110 |  | 8289.1 | WAFC
2023-03-27 00:00:00 | DIRECT CREDIT  PLAYHQCOM_NbHG8NHg PLAYHQCOM            [PHONE] |  | 65.8 | 8354.9 | PLAYHQ
2023-03-27 00:00:00 | DIRECT CREDIT  PLAYHQCOM_NbHUPFq9 PLAYHQCOM            [PHONE] |  | 193.46 | 8548.36 | PLAYHQ
2023-03-28 00:00:00 | OSKO PAYMENT   Route 94 Canteen supplies | 275.53 |  | 8272.83 | OTH-
2023-03-29 00:00:00 | DIRECT CREDIT  PLAYHQCOM_Nc2Bd1AL PLAYHQCOM            [PHONE] |  | 193.46 | 8466.29 | PLAYHQ
2023-03-30 00:00:00 | DIRECT CREDIT  PLAYHQCOM_NcPFh4Ze PLAYHQCOM            [PHONE] |  | 96.73 | 8563.02 | PLAYHQ
Transaction totals / Closing balance
Spreadsheet: 084158a4-cec5-42a0-a7dd-64fda6640d74
Sheet: Sheet1

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

Month | Project Name | Cash Out Periodic | Forecast Cash Out 3 months rolling
January | HVAC OEM Support | 100
February | HVAC OEM Support | 100
March | HVAC OEM Support | 100
April | HVAC OEM Support | 100
May | HVAC OEM Support | 100
June | HVAC OEM Support | 100
July | HVAC OEM Support | 100
August | HVAC OEM Support | 100
September | HVAC OEM Support | 100
October | HVAC OEM Support | 100
November | HVAC OEM Support | 100
December | HVAC OEM Support | 100
January | Ninja | 4990
February | Ninja | 576
March | Ninja | 0 |  | Important this formula does only include project on same row
April | Ninja | 18445
May | Ninja | 20783
June | Ninja | 53402
July | Ninja | 3127
August | Ninja | 8919
September | Ninja | 53512
October | Ninja | 78109
November | Ninja | 70641
December | Ninja | 0