tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 826364d1681969883-apply-the-interpolation-calculation-if-the-level-is-below-of-certain-value-test-example-2
Sheet: Sheet2

 | tank no.
 |  | [NAME] | cm |  | liters
 | 2 | 1 | 300
 | 33 | 9 | 1194
 | 27 | 2 | 1043
 | 41 | 5 | 102
 | 31 | 5 | 1199
 | 6A | 6 | 1004
TOTAL
Remark 1 : |  |  |  |  |  |  |  | Remark 2 :
Tank 2 should be interpolated if the level  below 200 CM |  |  |  |  |  |  |  | Tank 2 should be interpolated if the level  is between 400 to 500 cm
Tank33  should be interpolated if the level  below 300 CM |  |  |  |  |  |  |  | Tank33  should be interpolated if the level is between 500 to 600 cm
Tank27 should be interpolated if the level  below 250 CM |  |  |  |  |  |  |  | Tank27 should be interpolated if the level  is between 400 to 450 cm
Tank 41 should be interpolated if the level  below 200 CM |  |  |  |  |  |  |  | Tank 41 should be interpolated if the level  is between 600 to 700 cm
Tank 31 should be interpolated if the level  below 150 cm |  |  |  |  |  |  |  | Tank 31 should be interpolated if the level  is  between 550 to 650
Tank 6A should be interpolated if the level  below 400 CM |  |  |  |  |  |  |  | Tank 6A should be interpolated if the level is between 750 to 900 cm
tank no, | level |  |  |  |  |  |  | tank no, | level
2 | 200 |  |  |  |  |  |  |  | from | to
33 | 300 |  |  |  |  |  |  | 2 | 400 | 500
27 | 250 |  |  |  |  |  |  | 33 | 500 | 600
41 | 200 |  |  |  |  |  |  | 27 | 400 | 450
31 | 150 |  |  |  |  |  |  | 41 | 600 | 700
6A | 400 |  |  |  |  |  |  | 31 | 550 | 650
 |  |  |  |  |  |  |  | 6A | 750 | 900
Spreadsheet: 819873d1677743012-excel-formula-for-sorting-a-result-excel-data-1
Sheet: Sheet1

DATA 1 |  |  |  |  |  | DATA 2
2022-02-16 00:00:00 | N07.0002004.00082 | TECO |  |  |  | MATERIAL CODE |  |  |  |  | EXPECTED RESULT IN DATA 2
2022-02-16 00:00:00 | N07.0002004.00143 | TECO |  |  |  | N07.0002004.00082 |  |  |  |  | N07.0002004.00082 | PR PO
2022-03-01 00:00:00 | N07.0002004.00196 | CANCEL |  |  |  | N07.0002004.00143 |  |  |  |  | N07.0002004.00143 | MO
2022-03-03 00:00:00 | N07.0002004.00202 | TECO |  |  |  | N07.0002004.00196 |  |  |  |  | N07.0002004.00196 | PR
2022-04-05 00:00:00 | N12.0007001.00003 | PO |  |  |  | N07.0002004.00202 |  |  |  |  | N07.0002004.00202
2022-05-05 00:00:00 | N15.0006001.00006 | SIV |  |  |  | N12.0007001.00003 |  |  |  |  | N12.0007001.00003 | PO
2022-05-06 00:00:00 | N15.0006001.00008 | TECO |  |  |  | N15.0006001.00006 |  |  |  |  | N15.0006001.00006 | SIV
2022-07-07 00:00:00 | N15.0006001.00025 | PR |  |  |  | N15.0006001.00024 |  |  |  |  | N15.0006001.00024
2022-08-06 00:00:00 | N07.0002004.00082 | PR
2023-01-01 00:00:00 | N07.0002004.00143 | MO
2023-02-03 00:00:00 | N07.0002004.00196 | PR
2023-02-05 00:00:00 | N07.0002004.00082 | PO
Spreadsheet: john_griffith__15969__11_16_01GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 50 | 410 | 500 | 59.2 | 72.3 | 2.07 | 2001-11-16 14:53:00
 | HU F2 | 51 | 730 | 830 | 54.5 | 62 | 1.87 | 2001-11-16 14:53:00
 | HU G2 | 52 | 950 | 1025 | 51.7 | 55.8 | 1.76 | 2001-11-16 14:53:00
 | [NAME] | 53 | 1125 | 1250 | 51.3 | 57 | 1.8 | 2001-11-16 14:53:00
 | [NAME] | 60 | 1350 | 1500 | 48.3 | 53.7 | 1.92 | 2001-11-16 14:53:00
 | [NAME] | 60 | 1450 | 1600 | 46.7 | 51.6 | 1.85 | 2001-11-16 14:53:00
 | [NAME] | 60 | 1500 | 1625 | 44.3 | 48 | 1.74 | 2001-11-16 14:53:00
 | HU N2 |  |  |  | 39.3 | 43.3 | 1.64 | 2001-11-14 11:13:00
 | [NAME] |  |  |  | 36.7 | 41.4 | 1.64 | 2001-11-09 14:53:00
 | HU U2 |  |  |  | 36 | 39.4 | 1.59 | 2001-10-29 14:33:00
 | [NAME] |  |  |  | 32.2 | 36.6 | 1.43 | 2001-10-22 14:23:00
 | [NAME] |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | HU F3
 | [NAME] |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | HU H3
Spreadsheet: 169565d1342954135-add-number-before-text-in-each-cell-book1
Sheet: Sheet1

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14 | Column15
Data10 | Data20 | Data30 | Data40 | [NAME] | Data60 | Data70 | Data80 | Data90 | Data100 | Data110 | Data120 | Data130 | Data140 | Data150
Data11 | Data21 | Data31 | Data41 | Data51 | Data61 | Data71 | Data81 | [NAME] | Data101 | Data111 | Data121 | Data131 | Data141 | Data151
Data12 | Data22 | Data32 | Data42 | Data52 | Data62 | Data72 | Data82 | Data92 | Data102 | Data112 |  | [NAME] | Data142 | Data152
Data13 | Data23 | [NAME] | Data43 | Data53 | Data63 |  | Data83 | Data93 | Data103 | Data113 |  | Data133 | Data143 | Data153
Data14 | Data24 | Data34 | Data44 | Data54 | Data64 |  | Data84 | Data94 | Data104 | Data114 |  | Data134 | Data144 | Data154
Data15 | Data25 | Data35 | Data45 | Data55 | Data65 |  | Data85 | Data95 | Data105 | [NAME] |  | Data135 | Data145 | Data155
Data16 | Data26 | Data36 | Data46 | Data56 | Data66 |  | Data86 |  | Data106 | Data116 |  | Data136 | Data146 | [NAME]
[NAME] | [NAME] | Data37 | Data47 | Data57 | Data67 |  | Data87 |  | [NAME] | Data117 |  | Data137 | [NAME] | Data157
Data18 | Data28 | Data38 | Data48 | Data58 | Data68 |  | Data88 |  | Data108 |  |  | [NAME] | Data148 | Data158
Data19 | Data29 | [NAME] | Data49 | Data59 | Data69 |  | Data89 |  | Data109 |  |  | Data139 | Data149 | Data159
Data20 | Data30 |  | [NAME] |  | Data70 |  | Data90 |  | Data110 |  |  | Data140 | Data150 | Data160
Data21 | Data31 |  | Data51 |  | Data71 |  | [NAME] |  |  |  |  |  | Data151 | Data161
Data22 | Data32 |  | Data52 |  | Data72 |  | Data92 |  |  |  |  |  | Data152 | Data162
 | [NAME] |  | Data53 |  | Data73 |  | Data93 |  |  |  |  |  | Data153
 | Data34 |  | Data54
 |  |  | Data55
Spreadsheet: 94459d1294262216-excel-2007-return-max-date-in-column-based-on-lookup-in-adjacent-column-proj-135030-mvsis-dec-10-draft
Sheet: 4-1-2-16 Prior

 | AP Invoice List
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 of 1
 | Job in list 1897, Vendor in list 28371,1339,25915,24585,22491
 | 24761,26576,13166
Ven# | Vendor | Invoice # | Invoice Date |  | Description | Amount Paid |  | Total | Retention | Invoice Net | LookupAmt
1339 | Concrete Cutting Unlimited Inc | 54969 | 09/27/10 |  | 1897/Subcontracted | 43142.4 |  | 55200 | 5520 | 0
1339 | Concrete Cutting Unlimited Inc | 54969 | 09/27/10 |  | 1897/Subcontracted | 773.6 |  | 55200 | 5520 | 0
1339 | Concrete Cutting Unlimited Inc | 54969 | 09/27/10 |  | 1897/Subcontracted | 5764 |  | 55200 | 5520 | 0
22491 | Pac-Con Construction, Inc | 9901178 | 09/30/10 |  | 1897/Subcontracted | 22554 |  | 25060 | 2506 | 0
22491 | Pac-Con Construction, Inc | 9901181 | 10/25/10 |  | 1897/Subcontracted | 40915.8 |  | 45462 | 4546.2 | 0
22491 | Pac-Con Construction, Inc | 9901183 | 11/26/10 |  | 1897/Subcontracted | 0 |  | 55987.67 | 5598.77 | 50388.9
24585 | Sapphire Electric Inc. | CO1 1897 | 09/30/10 |  | 1897/Subcontracted/CO 1 | 139.5 |  | 155 | 15.5 | 0
24585 | Sapphire Electric Inc. | 564207 | 10/20/10 |  | 1897/Subcontracted | 7380.36 |  | 8200.4 | 820.04 | 0
26576 | Terra West, Inc | 1002101 | 06/15/10 |  | 1897/Subcontracted | 1070 |  | 1070 | 0 | 0
28371 | Vic Salazar Communications | 103 | 07/31/10 |  | 1897/Subcontracted | 1890 |  | 2100 | 210 | 0
Spreadsheet: 272050d1382169650-if-cell-has-data-the-look-up-value-example-list-rovert7-191013
Sheet: Order List

Colour | 1st charm | 1st Letter | 2nd Charm | 2nd Letter | 3rd Charm | 3rd Letter | 3rd Letter | BOX | PILLOW | Price
grey | b'fly | M |  |  |  |  |  | box
aubergine | note | J |  |  |  |  |  | box | pillow
navy | heart | F |  | A |  | K
red | b'fly | M
hot pk | b'fly | N
Spreadsheet: 730728d1619877517-date-formatting-book1-3_wd
Sheet: Sheet1

1 | 2 | 3 | 4 | 5
Activity name | Duration | Start Date | Finish Date | [NAME]
Pour 1 | 6w 3d | 2021-04-13 00:00:00 | 2021-04-26 00:00:00
Pour 2 | 2w | 2021-04-22 00:00:00 | 2021-04-28 00:00:00
Pour 3 | 1w | 2021-04-26 00:00:00 | 2021-04-30 00:00:00
Pour 4 | 1w | 2021-04-29 00:00:00 | 2021-05-06 00:00:00
Pour 5 | 1w | 2021-05-05 00:00:00 | 2021-05-11 00:00:00
Pour 6 | 1w | 2021-05-07 00:00:00 | 2021-05-13 00:00:00
Spreadsheet: 765387d1643299814-lookup-first-and-last-instance-of-text-in-range-and-return-column-heading-data-power-query-to-produce-lookup-table-for-start-and-end-dates-runner101-
Sheet: Sheet1

Name | 1/29/2022 | [NAME] | 1/31/2022 | 2/1/2022 | 2/2/2022 | 2/3/2022
[NAME] | C3265 | D101 | D101 (finish off) | Finish C3265 | L0944 | L0944
[NAME] | C3265 | C3265 | C3265 | Annual leave | Annual leave | Annual leave
Trevor | F565 (half day) | F565 | F565 | L1012 | L1012 | L1012 (& half day)
[NAME] | Half day and L1012 | L1012 | L1012 | L1012 | L1012 | L1012
Rebecca | M324A | M324B | M324C | S657 | B1016 | B1016, L1012
 |  |  |  |  |  |  |  | Name | Attribute | Value.1 | Value.2 | Custom
 |  |  |  |  |  |  |  | [NAME] | 1/29/2022 | C3265 |  | C3265
Lookup required (normally resides on another worksheet) |  |  |  |  |  |  |  | [NAME] | [NAME] | D101 |  | D101
 |  |  |  |  |  |  |  | [NAME] | 1/31/2022 | D101 (finish off) |  | D101
Task number | Start date [lookup] | End date [lookup] |  |  |  |  |  | [NAME] | 2/1/2022 | Finish C3265 |  | C3265
D101 | 2022-01-30 00:00:00 | 2022-01-31 00:00:00 |  |  |  |  |  | [NAME] | 2/2/2022 | L0944 |  | L0944
F565 | 2022-01-29 00:00:00 | 2022-01-31 00:00:00 |  | Output required from formula |  |  |  | [NAME] | 2/3/2022 | L0944 |  | L0944
B1016 | 2022-02-02 00:00:00 | 2022-02-03 00:00:00 |  |  |  |  |  | [NAME] | 1/29/2022 | C3265 |  | C3265
L1012 | 2022-01-29 00:00:00 | 2022-02-03 00:00:00 |  |  |  |  |  | [NAME] | [NAME] | C3265 |  | C3265
 |  |  |  |  |  |  |  | [NAME] | 1/31/2022 | C3265 |  | C3265
Task number |  |  |  |  |  |  |  | [NAME] | 2/1/2022 | Annual leave |  | leave
D101 |  |  |  |  |  |  |  | [NAME] | 2/2/2022 | Annual leave |  | leave
F565 |  |  |  |  |  |  |  | [NAME] | 2/3/2022 | Annual leave |  | leave
B1016 |  |  |  |  |  |  |  | Trevor | 1/29/2022 | F565 (half day) |  | F565
L1012 |  |  |  |  |  |  |  | Trevor | [NAME] | F565 |  | F565
 |  |  |  |  |  |  |  | Trevor | 1/31/2022 | F565 |  | F565
 |  |  |  |  |  |  |  | Trevor | 2/1/2022 | L1012 |  | L1012
 |  |  |  |  |  |  |  | Trevor | 2/2/2022 | L1012 |  | L1012
 |  |  |  |  |  |  |  | Trevor | 2/3/2022 | L1012 (& half day) |  | L1012
 |  |  |  |  |  |  |  | [NAME] | 1/29/2022 | Half day and L1012 |  | L1012
 |  |  |  |  |  |  |  | [NAME] | [NAME] | L1012 |  | L1012
 |  |  |  |  |  |  |  | [NAME] | 1/31/2022 | L1012 |  | L1012
 |  |  |  |  |  |  |  | [NAME] | 2/1/2022 | L1012 |  | L1012
 |  |  |  |  |  |  |  | [NAME] | 2/2/2022 | L1012 |  | L1012
 |  |  |  |  |  |  |  | [NAME] | 2/3/2022 | L1012 |  | L1012
 |  |  |  |  |  |  |  | Rebecca | 1/29/2022 | M324A |  | M324A
 |  |  |  |  |  |  |  | Rebecca | [NAME] | M324B |  | M324B
 |  |  |  |  |  |  |  | Rebecca | 1/31/2022 | M324C |  | M324C
 |  |  |  |  |  |  |  | Rebecca | 2/1/2022 | S657 |  | S657
 |  |  |  |  |  |  |  | Rebecca | 2/2/2022 | B1016 |  | B1016
 |  |  |  |  |  |  |  | Rebecca | 2/3/2022 | B1016 | L1012 | B1016
Spreadsheet: phillip_allen__29919__Profit_sharing
Sheet: version 1

Costs |  | 10300000
Equity
Loan
Appraised Value |  | 12000000
LTV % |  | 0.8
Permanent Loan
Permanent Equity |  |  |  |  |  |  |  | 0.15
 |  |  |  |  |  |  |  | Cumulative
 |  |  |  |  |  |  | Cash Avail | Priority | Cash after | Unfunded | Distrib. of Cash after Priority
Year |  | Equity | NOI(3%) | Debt Service | Cash Flow | Reserve | to Partners | Return | priority | priority | PA & KH | CIS
1
2 |  |  | 1100000 | -785867
3 |  |  |  | -785867
4 |  |  |  | -785867
5 |  |  |  | -785867
6 |  |  |  | -785867
7 |  |  |  | -785867
8 |  |  |  | -785867
9 |  |  |  | -785867
10 |  |  |  | -785867
11 |  |  |  | -785867
12 |  |  |  | -785867
Spreadsheet: 328256d1403842839-counting-entries-countif-unique-try-2
Sheet: Sheet 1

 |  |  |  |  |  |  |  | Helper | expected
26/06/2014 | CRN 018573 | DCL | 216.031.05 | BOTTLE TRAP PLASTIC 1.50" 40mm WITH | 1 | Return | 12:07:12 | 1 | 1
26/06/2014 | CRN 018574 | DCL | 241.000.46 | SILVANO DOUBLE SPIRAL COOKER SL-03 | 1 | Return | 12:15:17 | 2 | 2
26/06/2014 | CRN 018574 | DCL | 241.000.04 | TOASTER STAINLESS 2 SLICE SL-1002 | 1 | Return | 12:15:23 | 2 | 2
26/06/2014 | CRN 018575 | DCL | 223.000.30 | [NAME] = MC-202 ( 10 PACK ) | 2 | Return | 12:16:41 | 3 | 3
26/06/2014 | CRN 018576 | DCL | 106.001.83 | MIRROR YJ-550 = [NAME] | 1 | Return | 12:19:21 | 4 | 4
26/06/2014 | CRN 018577 | DCL | 241.000.32 | ELECTRIC BBQ SL-3050 | 1 | Return | 12:24:29 | 5 | 5
26/06/2014 | CRN 018578 | DCL | 252.000.02 | 7 Pcs PAMS STORAGE GIFT BOX ( CA/118 ) | 1 | Return | [NAME] | 6 | 6
26/06/2014 | CRN 018579 | DCL | 216.031.13 | [NAME] KITCHEN SINK SB/SD - WHITE | 1 | Return | 12:29:29 | 7 | 7
26/06/2014 | CRN 018580 | DCL | 106.000.42 | DOUBLE TOWEL BAR 24" NO.8648 WOOD | 1 | Return | 12:34:34 | 8 | 8
 | Notes: [NAME] on shaded to count enries , note crn 018574 needs to be counted once since appearing twice
Spreadsheet: 0f05b788-4497-4e9e-a8d7-71ed8a579a37
Sheet: 9b

Product | EUR** | GBP | [NAME] | USD | TOTAL
Basis* | 160413 | 1002343 | 669499 | 5551832 | 7384087
FRA | 15502607 | 3061400 | 19780 | 14396723 | 32980510
IRS- [NAME] | 48045119 | 8202004 | 15892511 | 32209928 | 104349562
OIS | 12112991 | 4296463 |  | 4334391 | 20743845
VNS | 1478 | <1,000 |  | 1414 | 2892
Zero Coupon | 93270 | 33668 | 36406 | 59390 | 222734
TOTAL | 75915878 | 16596399 | 16618195 | 56553677 | 165684150
Estimated gross notional amount outstanding, November 30 weekly snapshot, by product type and supermajor currency (millions of USD), cleared swaps only, all participant types and tenors. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for currency descriptions.
***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: 676755d1588955484-match-with-wildcard-match-with-wildcard
Sheet: Data

Customer | Exclude (Yes/no) | Manual
[NAME] (staff) |  | Yes
([NAME]) Davis Financial Services |  | No
Modima Place Properties CC |  | No
Dems Autoglass |  | No
BTK Panelbeaters |  | No
Jasons Tyre Centre |  | No
[NAME].Solutions |  | Yes
Abacus Management |  | Yes
Abacus Management |  | Yes
Abacus Management |  | Yes
Abacus Management |  | Yes
Abcacus Management Sol |  | Yes
[NAME] |  | Yes
Peter Jones Insurance |  | No
BR1 HEAD OFFICE |  | Yes
[NAME] |  | Yes
BTM Man services |  | Yes
CRT Services |  | Yes
Spreadsheet: 876152d1722846252-need-formula-for-tier-incentive-calculation-calculation-doing-formula
Sheet: Dr. Riad Abi Saleh

Contract Terms (*)
 |  | 1- Revenue Target | Commission
 |  | Tier 1 - 50,000 to 150,000 | 0.2
 |  | [NAME] to 250,000 | 0.25
 |  | Tier 5 - 250,001 and above | 0.3
Doctor Calculation
 |  | From 23 April TO 29 April 2024 |  |  | From 01 Feb To 6 Feb 2023
 |  | Gross Revenue |  |  | Gross Revenue | 0
 |  | Procedures Revenue | 6473.5 |  | Procedures Revenue | 0
 |  | Consumables | 748.89 |  | Consumables | 0
 |  | Net Revenue |  |  | Net Revenue
 |  | Amount to be Paid |  |  | Amount to be Paid
 |  | OR in Clinic Revenue | 0 |  | OR in Clinic Revenue | 0
 |  | OR Fees | 0 |  | OR Fees | 0
 |  | Impant Consumables | 0 |  | Impant Consumables | 0
 |  | Net Revenue |  |  | Net Revenue
 |  | Amount to be Paid |  |  | Amount to be Paid
 |  | OR Outside Clinics | 0 |  | OR Outside Clinics | 0
 |  | Hosp. Fees | 0 |  | Hosp. Fees | 0
 |  | Net Revenue | 0 |  | Net Revenue | 0
 |  | Amount to be Paid | 0 |  | Amount to be Paid | 0
 |  | Lab Revenue 10% | 995 |  | Lab Revenue 10% | 0
 |  | Lab Share (65%) |  |  | Lab Share (65%)
 |  | Clinics Share (35%) |  |  | Clinics Share (35%)
 |  | Amount to be paid |  |  | Amount to be paid
 |  | Total Amount to be Paid |  |  | Total Amount to be Paid
 |  | Total Amount to be Paid
Prepared By …................. |  |  | CFO  ....................... |  | CFO:
Spreadsheet: 3e33c322-441f-4552-8bf3-f27337791563
Sheet: Sheet1

Division of Water Quality | Unnamed: 1 | Unnamed: 2 | Project No.________________ | Unnamed: 4
Infrastructure Finance Section
Period Covered by this Report - From ________ To ________ |  |  | SRF - Federal, ARRA
 |  |  | SEL,SRL,SRG,-State
Recipient Organization
Name: |  |  | Payment No.______________
Address: |  |  | Page No._______ of _______
City, State & Zip:
 |  | Reimbursement Form
Please Label Each Column Use separate column for each contract. | Example Column Labels
Add a column if needed. | Engineer | Contractor | [NAME].
Classification of | A | B | C | Total
Admin & Legal |  |  |  | 0
Land Costs |  |  |  | 0
 |  |  |  | 0
Design Fees (Allowance) |  |  |  | 0
Engr's Fees Admin |  |  |  | 0
Inspection Fees |  |  |  | 0
 |  |  |  | 0
Construction Cost |  |  |  | 0
Equipment |  |  |  | 0
[NAME]. |  |  |  | 0
Deductions (income) |  |  |  | 0
Total Cumulative to date | 0 | 0 | 0 | 0
Previous Received
Amount Requested | 0 | 0 | 0 | 0
Percent Complete
Certification
I certify that to the best of my knowledge and belief the billed costs or disbursements
are in accordance with terms of the project and that the request for payment
represents the monies due which have not been previously requested and that
an inspection has been performed and all work is in accordance with the terms of the
award.
I further certify that the ________________________________ will expend all of the
requisitioned loan proceeds for the purpose of paying costs of the project within
three (3) banking days after receipt of such funds from the state.
Further, I certify that [NAME] have been met (if applicable),
and that Certified Payroll records are being submitted by the contractor and kept
on file by engineer and owner.
Recipient |  | Signature of Authorized Representative |  | Date
 | Type or Print Name and Title
Spreadsheet: 842333d1694447134-sum-with-inconsistant-date-formats-month-and-year-tms
Sheet: Summary

2023-06-01 00:00:00 |  |  |  | Sample Output
 | Month |  |  |  | Month | Jan-Apr |  | ="Jan-" & TEXT(A1,"mmm")
White |  |  |  | White |  |  |  | =INDEX(Table2[[Jan.22]:[Sep.23]],MATCH(Summary!$A3,Table2[Description],0),MATCH(Summary!$A$1,Data!$B$2:$W$2,0))
Red |  |  |  | Red | 3 | 10 |  | =SUM(INDEX(Table2[[Jan.22]:[Sep.23]],MATCH(Summary!$A3,Table2[Description],0),MATCH(DATE(YEAR(Summary!$A$1),1,1),Data!$B$2:$W$2,0)):INDEX(Table2[[Jan.22]:[Sep.23]],MATCH(Summary!$A3,Table2[Description],0),MATCH(Summary!$A$1,Data!$B$2:$W$2,0)))
Blue |  |  |  | Blue |  | 9
Orange |  |  |  | Orange | 2 | 7
In [NAME], I have date in DDMMYY format and in "Data" Sheet, months are in MMMYY format (unable to change since it is a table)
Need a simplest formula to get Month and Jan-Apr for the year shown in A1
Spreadsheet: 1dfedd12-1f41-44b4-8c16-135b6840306f
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
261661 | 56301 | [NAME] | Bozzato | ITA | 12 | 00:12:00 | [NAME] | 00:34:04 | 00:00:00 | 00:24:43 | 1 | 01:12:42
261661 | 47258 | [NAME] | Ubeda Salmeron | ESP | 15 | 00:10:45 | 00:02:07 | 00:35:22 | 00:00:00 | 00:25:19 | 2 | 01:13:31
261661 | 56294 | Alessandro | Colombo | ITA | 11 | 00:13:10 | [NAME] | 00:31:46 | 00:00:00 | 00:27:42 | 3 | 01:14:34
261661 | 72734 | [NAME] | Pascual Valls | ESP | 16 | 00:15:44 | 00:03:15 | 00:34:02 | 00:00:00 | 00:26:12 | 4 | 01:19:12
261661 | 49383 | Valeriano | [NAME] | ESP | 14 | 00:16:07 | 00:02:18 | 00:41:27 | 00:00:00 | 00:33:13 | 5 | 01:33:03
Spreadsheet: 878601d1725724461-fixing-time-sheet-timesheet-wolfin2010-
Sheet: Sheet1 (2)

 | Date | Start Time | Finish Time | Hours
 | 2024-06-30 00:00:00
 |  | 10:00:00 | 23:30:00
 |  | 08:00:00 | 16:00:00
 |  | 02:00:00 | 18:00:00
 |  | 05:00:00 | 17:00:00
 |  | 04:30:00 | 14:00:00 |  |  |  |  | After hour timing
 |  | 06:00:00 | 12:00:00 |  |  |  |  | Monday - Friday 5 PM - 5 AM
 |  |  |  |  |  |  |  | Weekend
 |  | 03:00:00 | 12:00:00
 |  | 12:00:00 | 23:00:00
 |  | 07:00:00 | 17:00:00
 |  | 06:00:00 | 15:00:00
 |  | 07:00:00 | 17:30:00
 |  | Total Hours
 |  | After Hour Work
 | Date | Start Time | Finish Time | Hours
 |  | Total After Hour Work
Spreadsheet: 163992d1340593870-count-number-of-repeat-stays-repeat2-copy
Sheet: Sheet3

DATA
MEMBERSHIP_CARD_NO | MEMBERSHIP_LEVEL | RESORT | DEPARTURE_DATE | NUMBER_NIGHTS | MONTH | YEAR
9251 | GOLD | DPS | 2010-09-08 00:00:00 | 14 |  |  |  | Members with [NAME] in year 2010 & 2011 per Tier |  |  |  | Resort with Most no. of repeat stay per year
7061 | PLATINUM | CGK | 2012-08-01 00:00:00 | 5 |  |  |  | Gold |  |  |  |  | Resort | Count
2045 | BLACK | PVG | 2011-08-01 00:00:00 | 2 |  |  |  | Platinum |  |  |  | 2010
2761 | RED | CGK | 2010-08-02 00:00:00 | 3 |  |  |  | Black |  |  |  | 2011
7061 | PLATINUM | DPS | 2012-06-01 00:00:00 | 4 |  |  |  | Red |  |  |  | 2012
7061 | PLATINUM | MNL | 2012-06-01 00:00:00 | 4
9251 | GOLD | DPS | 2011-12-08 00:00:00 | 14 |  |  |  | Members with [NAME] in year 2010,2011,2012 per Tier
9251 | GOLD | DPS | 2012-11-08 00:00:00 | 14 |  |  |  | Gold
2761 | RED | CGK | 2011-08-02 00:00:00 | 3 |  |  |  | Platinum
2733 | GOLD | MNL | 2011-08-10 00:00:00 | 3 |  |  |  | Black
 |  |  |  |  |  |  |  | Red
No. Stay Count |  |  |  |  |  | Per Resort |  |  |  | Per Tier
Count of NUMBER_NIGHTS | Column Labels |  |  |  |  | Row Labels | Count of NUMBER_NIGHTS | Sum of YEAR |  | Row Labels | Count of NUMBER_NIGHTS
Row Labels | 2010 | 2011 | 2012 | Grand Total |  | 2045 | 1 | 2011 |  | 2045 | 1
2045 |  | 1 |  | 1 |  | PVG | 1 | 2011 |  | BLACK | 1
2733 |  | 1 |  | 1 |  | 2733 | 1 | 2011 |  | 2733 | 1
2761 | 1 | 1 |  | 2 |  | MNL | 1 | 2011 |  | GOLD | 1
7061 |  |  | 3 | 3 |  | 2761 | 2 | 4021 |  | 2761 | 2
9251 | 1 | 1 | 1 | 3 |  | CGK | 2 | 4021 |  | RED | 2
Grand Total | 2 | 4 | 4 | 10 |  | 7061 | 3 | 6036 |  | 7061 | 3
 |  |  |  |  |  | CGK | 1 | 2012 |  | PLATINUM | 3
 |  |  |  |  |  | DPS | 1 | 2012 |  | 9251 | 3
 |  |  |  |  |  | MNL | 1 | 2012 |  | GOLD | 3
 |  |  |  |  |  | 9251 | 3 | 6033 |  | Grand Total | 10
 |  |  |  |  |  | DPS | 3 | 6033
 |  |  |  |  |  | Grand Total | 10 | 20112
Spreadsheet: 24831224-627d-466d-8f42-16ced77f8298
Sheet: Fred U15-U18 - Dec 15

Saturday December 15th
Home Club: | Loudoun |  | Locations: | Loudoun Soccer Park
[NAME]: | [NAME] |  | Field Directions:
Loudoun Soccer wears Red shirts, Black shorts, Red socks |  |  | http://www.loudounsoccer.com/Default.aspx?tabid=193688
Loudoun Soccer Park #1
U15/16 (40 mins x2) + U17/U18 (45 mins x2)
 | Time | Teams
 | 9am | U18B
 | 11am | U17B
 | 1pm | U17G
 | 3pm | [NAME]
Loudoun Soccer Park #2
U15/16 (40 mins x2) + U17/U18 (45 mins x2)
 | Time | Teams
 | 9am | U15B
 | 11am | U16G
 | 1pm | U15G
 | 3pm | U16B
Spreadsheet: 108388d1305441711-if-a-cell-in-a-column-in-any-worksheet-x-copy-entire-row-budget_update
Sheet: Mortgage

Mortgage
 |  |  |  |  | Total Mortgage Budget | Spent So Far | Total Remaining
 |  |  |  |  | 100 | 150 | -50
Date | Location | Memo | Method | Amount
2011-05-14 00:00:00 | Wells Fargo |  | VISA | 75
2011-05-14 00:00:00 | Wells Fargo |  | VISA | 75