tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 814409d1674355122-incorporating-cash-receipts-in-a-sales-spreadsheet-sumifs-question_revised-dbattista-
Sheet: Sheet1

Sales and Receipts
Date | Invoice # | Project | Customer | Amt Inv | Payor | Ch # | Check amount | Amt Rec to date
2022-01-24 00:00:00 | 12345 | Garden | BA | 1500 | ABC | 8766000 | 200
2022-01-25 00:00:00 | 12346 | Driveway | CD | 250 | DEF | 73886 | 150
2022-01-26 00:00:00 | 12347 | Porch | EF | 550 | KLM | [NAME] | 550
2022-01-28 00:00:00 | 12348 | Backyard | BA | 263 | ABC | 626262 | 35
2022-02-03 00:00:00 | 12346 | Driveway | CD |  | QCD | 23232 | 100
2022-03-04 00:00:00 | 12348 | Backyard | BA |  | STL | 987 | 228
2022-03-04 00:00:00 | 12345 | Garden | BA |  | NYU | 2323 | 350
2022-03-08 00:00:00 | 12354 | Lawn | EF | 750 | ABC | 9876 | 25
2022-04-10 00:00:00 | 12354 | Lawn | EF |  | NYU | 72727 | 150
2022-05-15 00:00:00 | 12851 | Sidewalk | CD | 2000
2022-06-06 00:00:00 | 12345 | Garden | BA |  | CQR | 12121 | 900
Account Receivable List
Customer | Project | Invoice # | Amt Inv | Check amount | Sum of Balance |  | The amount of invoice 12345 is $1500.00
BA | Garden | 12345 | 1500 | 1450 | 50 |  | When  the formula deducts and cumulates the amount received from this invoice, the inv amt is added in the AR list and the balance is erroneous.
 | Backyard | 12348 | 263 | 263 | 0
BA Total |  |  | 1763 | 1713 | 50
CD | Driveway | 12346 | 250 | 250 | 0
 | Sidewalk | 12851 | 2000 |  | 2000 |  | Should the formula in column I above be modified?
CD Total |  |  | 2250 | 250 | 2000
EF | Porch | 12347 | 550 | 550 | 0
 | Lawn | 12354 | 750 | 175 | 575
EF Total |  |  | 1300 | 725 | 575
Grand Total |  |  | 5313 | 2688 | 2625
Spreadsheet: f3703712-1433-4375-b038-db805f51a3dd
Sheet: 15a

Product |  | Transactions
Single - Name* | Corporate | 17623
 | Loans | <100
 | Municipal | <100
 | Recovery | <100
 | Sovereign | 1761
Index Tranche | Asia | <100
 | Europe | <100
 | North America | <100
Index | Asia | 118
 | Europe | 3883
 | North America | 3528
TOTAL |  | 26913
Estimated swap transaction volumes, week ending August 9, by product type (in number of transactions), all tenors and currencies. This table will be expanded to reflect participant type and cleared status as more complete data becomes available.
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 Data Dictionary for product 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: 127656d1320443361-making-vlookup-persistent-sample-1-
Sheet: Dealjacket (Old)

B12800 - (J2853) |  |  |  |  |  | Sold T | a
Cadillac | Deville | 1996 |  |  |  | Addres | a
 |  | 1G6KD52Y3TU304159 |  |  |  | City
132332 |  | White |  |  |  | Phones Res:
 | 2010-06-21 00:00:00 |  |  |  |  | Invoice
 | Automarkit |  |  |  |  | Date S
2550 |  |  |  |  |  | Finance
 |  |  |  |  |  | Trade-In
 |  |  |  |  |  | Pay-Off
Spreadsheet: 192569d1352460317-excel-2010-format-all-the-row-based-on-the-value-color-of-1-cell-test_to-upload
Sheet: BIANNUAL - PAYMENT DATE EOM

start/coupon days | 2012-10-31 00:00:00 | 4 | 3
9 | 2013-04-30 00:00:00 | 10 | 9
Accrual date |  |  | Rate | 30/360 days | interest | Interest accr. | Interest capital.
 |  | 650000 | 0.069 |  |  |  | 0
 |  | 650000
Spreadsheet: f9c24383-60c0-4471-a205-9cce17f5654b
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
AB2GP | Test | AB2GP | Beta-2 Glycoprotein 1 Antibodies, IgA, Serum | Beta 2 GP1 Ab IgA, S | Enzyme-Linked Immunosorbent Assay (ELISA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | <10.0 U/mL (negative) 10.0-14.9 U/mL (borderline) > or =15.0 U/mL (positive) Results are expressed in arbitrary units.  Reference values apply to all ages. | Monday through Saturday; 8 a.m. | Same day/1 day | 6 days | 1 | 86146 |  |  |  |  | Rochester
AB2GP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 21 days
AB2GP | Result | AB2GP | Beta 2 GP1 Ab IgA, S | Beta 2 GP1 Ab IgA, S | Numeric |  |  |  |  | U/mL |  |  |  |  |  |  |  |  |  | 44447-1 | Beta 2 glycoprotein 1 Ab.IgA:ACnc:Pt:Ser:Qn:EIA
Spreadsheet: 16cd829d-e2ec-4083-939e-c555885c8db2
Sheet: Sheet1

Title | Name | Description | Date | Amount
Municipal Judge | [NAME] | Mileage to attend 25th Annual NMML Municipal Day, Santa Fe, NM | 2014-02-12 00:00:00 | 58.76
Municipal Judge | [NAME] | The Lodge at Santa Fe Hotel - NMML Municipal Day | 2014-02-10 00:00:00 | 95.61
Mayor | [NAME] | La Fonda Hotel, Santa Fe, NM  - NMML Municipal Day | 2014-02-11 00:00:00 | 114.04
City Manager | [NAME] | NMML Registration | 2014-01-17 00:00:00 | 75
City Manager | [NAME] | Registration for NAIOP Real Estate Development | 2014-02-07 00:00:00 | 30
City Manager | [NAME] | NMML Registration for Newly Elected Officials | 2014-03-07 00:00:00 | 75
City Manager and City Council Members | Keith Riesberg & 2 Councilors | Rio Rancho Chamber of Commerce "I Love Rio Rancho Day" at NM Legislature | 2014-02-28 00:00:00 | 252
Spreadsheet: 97629d1296753401-cross-sheet-calc-that-would-omit-0-possible-solution-but-am-getting-a-ref-error-2011trending
Sheet: 0107

01/07/11  Performance Data
 |  | 1st Work |  |  |  | QC |  |  | Total Points Earned | Unavailability |  | Actual Processing  Hours | Avg pts per hour
 |  | SURNOT SURNOTACKL MNBENMMIG SURDTHCERT | SURBENCSMG SURFRM SURVALDOD SURCUSFLUP SURSPLIGO SRSPNIGO SURBENSPLT RAIDPS RAIDNP/TAIDIN-IA FAID/FAIDWF IAID/FAIDCO SURINQ | SURBENRSCH SURBENUPDT RAIDPB RAIDAR | SURBENLEGL SURPAYLNPO | MNTBENMMIG SURSPLIGO SURSPNIGO SURBENSPLT RAIDPS FAID | SURBENRSCH (PASS) SURBENUPDT (PASS/FAIL) RAIDPB RAIDAR | SURBENRSCH (FAIL)
 |  |  |  |  |  |  |  |  |  | # of Hrs | Reason?
Team Members | Flint | 9 | 9 | 8 |  |  |  |  | 109 | 1 | board | 6.75 | 16.14814814814815
 | Dustin | 6 | 8 | 10 |  |  |  |  | 116 | 1 | trending/capmgmt | 6.25 | 18.56
 | Sharron | 6 | 9 | 12 |  |  |  |  | 135 |  |  | 9.25 | 14.59459459459459
 | Roxy | 8 | 2 | 8 |  |  |  |  | 86 |  |  | 9 | 9.555555555555555
 | [NAME] |  |  |  |  |  |  |  | 0.01 |  | out of office | 0.01 | 1
 | Ana |  | 11 | 13 |  |  |  |  | 137 | 1 | [NAME] | 7 | 19.57142857142857
 |  |  |  |  |  |  |  |  | 0
 | [NAME] | 6 | 29 | 9 |  |  |  |  | 171 | 0.5 | [NAME] | 8.75 | 19.54285714285714
 | Petra |  |  | 2 |  | 2 | 17 | 13 | 260 | 7.5 | [NAME] | 18 | 14.44444444444444
 | Regina |  |  |  |  |  | 7 |  | 56 | 5 | SWT | 3 | 18.66666666666667
 | Noy |  |  |  |  |  |  |  | 0.01 | 9.25 | SWT | 0.01 | 1
 | [NAME] |  |  |  |  |  |  |  | 0.01 |  | out of office | 0.01 | 1
 | [NAME] |  |  |  |  |  |  |  | 0.01 |  | SME | 0.01 | 1
 | Michelle |  |  |  |  |  |  |  | 0.01 |  | SME | 0.01 | 1
 | Keisha |  | 9 | 6 |  |  |  |  | 75 |  |  | 7.25 | 10.3448275862069
 | [NAME] |  |  |  |  |  |  |  | 0.01 |  | no info | 0.01 | 1
TEAM TOTALS | Pts Earned: | 2 | 3 | 8 | 12 | 2 | 8 | 8 |  |  |  |  | 146.428522709902
 | TASK VOLUME: | 35 | 77 | 68 | 0 | 2 | 24 | 13 | 1145 | 25.25 |  | 75.31000000000003 | 15.20382419333421
 | Pts Earned: | 70 | 231 | 544 | 0 | 4 | 192 | 104
 |  |  |  |  |  |  |  | Average PTS | 71.56625 |  | Total Task Volume |  | 219
 | MID-DAY PPH  no data
Spreadsheet: 815923d1675267752-sick-time-accrual-with-previous-year-carry-over-sick-time-calculator
Sheet: Master Sheet

Sick Time Calculated
Employee Name |  |  |  |  | Date of Hire | 2023 Used Sick Time | Previous Year Carry Over
Master [NAME] |  |  |  |  |  |  | 11
Payroll Week | Sunday-Saturday | Vacation/Sick Time | Holiday | Hours Worked | Yearly Total | [NAME] | Total Accrued Sick | Sick Used | Sick Available
Week Ending | 2023-01-07 00:00:00 |  |  | 25
Week Ending | 2023-01-14 00:00:00 |  |  | 20
Week Ending | 2023-01-21 00:00:00 |  |  | 30
Week Ending | 2023-01-28 00:00:00 |  |  | 15
Week Ending | 2023-02-04 00:00:00
Week Ending | 2023-02-11 00:00:00
Week Ending | 2023-02-18 00:00:00
Week Ending | 2023-02-25 00:00:00
Week Ending | 2023-03-04 00:00:00
Week Ending | 2023-03-11 00:00:00
Week Ending | 2023-03-18 00:00:00
Week Ending | 2023-03-25 00:00:00
Week Ending | 2023-04-01 00:00:00
Week Ending | 2023-04-08 00:00:00
Week Ending | 2023-04-15 00:00:00
Week Ending | 2023-04-22 00:00:00
Week Ending | 2023-04-29 00:00:00
Week Ending | 2023-05-06 00:00:00
Week Ending | 2023-05-13 00:00:00
Week Ending | 2023-05-20 00:00:00
Week Ending | 2023-05-27 00:00:00
Week Ending | 2023-06-03 00:00:00
Week Ending | 2023-06-10 00:00:00
Week Ending | 2023-06-17 00:00:00
Week Ending | 2023-06-24 00:00:00
Week Ending | 2023-07-01 00:00:00
Week Ending | 2023-07-08 00:00:00
Week Ending | 2023-07-15 00:00:00
Week Ending | 2023-07-22 00:00:00
Week Ending | 2023-07-29 00:00:00
Week Ending | 2023-08-05 00:00:00
Week Ending | 2023-08-12 00:00:00
Week Ending | 2023-08-19 00:00:00
Week Ending | 2023-08-26 00:00:00
Week Ending | 2023-09-02 00:00:00
Week Ending | 2023-09-09 00:00:00
Week Ending | 2023-09-16 00:00:00
Week Ending | 2023-09-23 00:00:00
Week Ending | 2023-09-30 00:00:00
Week Ending | 2023-10-07 00:00:00
Week Ending | 2023-10-14 00:00:00
Week Ending | 2023-10-21 00:00:00
Week Ending | 2023-10-28 00:00:00
Week Ending | 2023-11-04 00:00:00
Week Ending | 2023-11-11 00:00:00
Week Ending | 2023-11-18 00:00:00
Week Ending | 2023-11-25 00:00:00
Week Ending | 2023-12-02 00:00:00
Week Ending | 2023-12-09 00:00:00
Week Ending | 2023-12-16 00:00:00
Week Ending | 2023-12-23 00:00:00
Week Ending | 2023-12-30 00:00:00
Spreadsheet: 797588d1663964736-incrementing-columns-in-sumif-formula-projecttimes
Sheet: Sierpień 2022

 |  | =SUMIF(G:G;B32;H:H)+SUMIF(OFFSET(G:G;0;2);B32;OFFSET(H:H;0;2))+SUMIF(OFFSET(G:G;0;4);B32;OFFSET(H:H;0;4))+SUMIF(OFFSET(G:G;0;6);B32;OFFSET(H:H;0;6))
 |  |  |  |  |  | 2020-08-01 00:00:00 |  | 2020-08-02 00:00:00 |  | 2020-08-03 00:00:00 |  | 2020-08-03 00:00:00 |  | 2020-08-03 00:00:00 |  | 2020-08-03 00:00:00 |  | 2020-08-03 00:00:00 |  | 2020-08-03 00:00:00 |  | 2020-08-03 00:00:00 |  | 2020-08-03 00:00:00 |  | 2020-08-03 00:00:00 |  | 2020-08-03 00:00:00 |  | 2020-08-03 00:00:00 |  | 2020-08-03 00:00:00
 | Projekty | [NAME] |  |  | name | Projekt | Hours | Projekt | Hours | Projekt | Hours | Projekt | Hours | Projekt | Hours | Projekt | Hours | Projekt | Hours | Projekt | Hours | Projekt | Hours | Projekt | Hours | Projekt | Hours | Projekt | Hours | Projekt | Hours | Projekt | Hours
 | Project 1 |  |  |  | Person 1 | Project 1 | 8 | Project 1 | 2 | Project 1 | 4 | Project 1 | 10 | Project 1 | 10 | Project 1 | 10 | Project 1 | 10 | Project 1 | 10 | Project 1 | 10 | Project 1 | 10 | Project 1 | 10 | Project 1 | 10 | Project 1 | 10 | Project 1 | 10
 | Project 2 |  |  |  |  | Project 2 | 8 | Project 4 | 3
 | Project 3 |  |  |  |  |  |  | Project 3 |  | Project 2 | 3 | Project 2 |  | Project 2 |  | Project 2 |  | Project 2 |  | Project 2 |  | Project 2 |  | Project 2 |  | Project 2 |  | Project 2 |  | Project 2 |  | Project 2
 | Project 4
 | Project 5
 | Project 6 |  |  |  | Person 2 |  | 9 |  | 8 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5
 | Project 7 |  |  |  |  |  |  |  |  | Project 5 | 3 | Project 5 | 3 | Project 5 | 3 | Project 5 | 3 | Project 5 | 3 | Project 5 | 3 | Project 5 | 3 | Project 5 | 3 | Project 5 | 3 | Project 5 | 3 | Project 5 | 3 | Project 5 | 3
 | Project 8 |  |  |  |  | Project 3 |  | Project 6 | 3
 | Project 9
 | Project 10
 | Project 11 |  |  |  | Person 3 | Project 20 | 9 |  | 8
 | Project 12
 | Project 13 |  |  |  |  |  |  |  |  | Project 5 |  | Project 5 |  | Project 5 |  | Project 5 |  | Project 5 |  | Project 5 |  | Project 5 |  | Project 5 |  | Project 5 |  | Project 5 |  | Project 5 |  | Project 5
 | Project 14
 | Project 15
 | Project 16 |  |  |  | Person 4 |  | 9 |  | 6 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8
 | Project 17
 | Project 18
 | Project 19
 | Project 20
Spreadsheet: 758855d1639126644-dynamic-array-difficulty-lookup-sumif-unique-filter-xlookup-based-on-multiple-criteria-sample-gk
Sheet: GP Import

Base Data |  |  |  |  |  |  | Desired Output, except sum each unique [Item]*[Lot] combination instead of each unique [Lot] (left) or [Item] (right)
STCKCNTID | Item | BIN | Qty | LOT | Item Type |  | STCKCNTID | Item | BIN | Qty | LOT | Item Type | FG Totals | ITEMNMBR | LOCNCODE | BINNMBR | COUNTEDQTY | COUNTDATE | COUNTTIME | Stock_Serial_Lot_Count | VERIFIED | RAW Totals | STCKCNTID | ITEMNMBR | LOCNCODE | BINNMBR | COUNTEDQTY | COUNTDATE | COUNTTIME | Stock_Serial_Lot_Count | VERIFIED
2021 MF RAW YE | RI-2342-MF | YECNT21 | 50 | 112921001D | FG |  |  | RI-2342-MF | YECNT21 |  |  | FG
2021 MF RAW YE | RI-2342-MF | YECNT21 | 50 | 112921002D | FG |  | 2021 MF RAW YE | RI-2342-MF | YECNT21 | 50 | 112921002D | FG |  | RI-2342-MF |  |  |  |  |  |  |  |  |  | RI-2342-MF |  |  |  |  |  |  |  |  | RAW STCKCNTID: | 2021 MF RAW YE
2021 MF RAW YE | RI-2342-MF | YECNT21 | 50 | 112921003D | FG |  | 2021 MF RAW YE | RI-2342-MF | YECNT21 | 50 | 112921003D | FG |  | [NAME] |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | FINISHED STCKCNTID: | 2021 MF FG YE
2021 MF RAW YE | RI-2342-MF | YECNT21 | 16 | 112921004D | FG |  | 2021 MF RAW YE | RI-2342-MF | YECNT21 | 16 | 112921004D | FG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LOCNCODE: | MF
2021 MF RAW YE | RI-2342-MF | YECNT21 | 40 | 102521 | FG |  | 2021 MF RAW YE | RI-2342-MF | YECNT21 | 40 | 102521 | FG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BINNMBR: | YECNT21
2021 MF RAW YE | RI-2342-MF | YECNT21 | 40 | 102521002B | FG |  | 2021 MF RAW YE | RI-2342-MF | YECNT21 | 64 | 102521002B | FG
2021 MF RAW YE | RI-2342-MF | YECNT21 | 36 | 102521003B | FG |  | 2021 MF RAW YE | RI-2342-MF | YECNT21 | 36 | 102521003B | FG
2021 MF RAW YE | RI-2342-MF | YECNT21 | 4 | 102521004B | FG |  | 2021 MF RAW YE | RI-2342-MF | YECNT21 | 4 | 102521004B | FG
2021 MF RAW YE | RI-2342-MF | YECNT21 | 24 | 102521002B | FG |  | 2021 MF RAW YE | RI-2342-MF | YECNT21 | 16 | 1D0098H | FG
2021 MF RAW YE | RI-2342-MF | YECNT21 | 16 | 1D0098H | FG |  | 2021 MF RAW YE | [NAME] | YECNT21 | 80 | 102521004B | FG
2021 MF RAW YE | [NAME] | YECNT21 | 40 | 102521004B | FG |  | 2021 MF RAW YE | RI-144-MF | YECNT21 | 28 | 102521005B | FG
2021 MF RAW YE | [NAME] | YECNT21 | 40 | 102521004B | FG |  | 2021 MF RAW YE | RI-144-MF | YECNT21 | 40 | 102621002B | FG
2021 MF RAW YE | RI-144-MF | YECNT21 | 28 | 102521005B | FG |  | 2021 MF RAW YE | RI-144-MF | YECNT21 | 40 | 102621001B | FG
2021 MF RAW YE | RI-144-MF | YECNT21 | 40 | 102621002B | FG
2021 MF RAW YE | RI-144-MF | YECNT21 | 40 | 102621001B | FG
Spreadsheet: 103029d1300883325-evaluate-expression-in-rc-notation-sample
Sheet: Sheet1

 | 8 | 2 | 7 | 1 | 8 |  | 8 | 2 | 7 | 1 | 8
 | 1 | 7 | 1 | 7 | 0 |  | 1 | 7 | 1 | 7 | 0
 | 7 | 1 | 8 | 2 | 7 |  | 7 | 1 | 8 | 2 | 7
 | 0 | 6 | 0 | 6 | 1 |  | 0 | 6 | 0 | 6 | 1
 | 6 | 0 | 6 | 0 | 6 |  | 6 | 0 | 6 | 0 | 6
 | 2 | 8 | 2 | 8 | 2 |  | 2 | 8 | 2 | 8 | 2
8 | 0 | 6 | 1 | 7 | 0 | 8
1 | 0 | -6 | 0 | -6 | 1 | 1
7 | 0 | 6 | -1 | 5 | 0 | 7
0 | 0 | -6 | 0 | -6 | -1 | 0
6 | 0 | 6 | 0 | 6 | 0 | 6
2 | 0 | -6 | 0 | -6 | 0 | 2
2 | -6 | 0 | -5 | 1 | -6 | 2
7 | 6 | 0 | 6 | 0 | 7 | 7
1 | -6 | 0 | -7 | -1 | -6 | 1
6 | 6 | 0 | 6 | 0 | 5 | 6
0 | -6 | 0 | -6 | 0 | -6 | 0
8 | 6 | 0 | 6 | 0 | 6 | 8
7 | -1 | 5 | 0 | 6 | -1 | 7
1 | 0 | -6 | 0 | -6 | 1 | 1
8 | 1 | 7 | 0 | 6 | 1 | 8
0 | 0 | -6 | 0 | -6 | -1 | 0
6 | 0 | 6 | 0 | 6 | 0 | 6
2 | 0 | -6 | 0 | -6 | 0 | 2
1 | -7 | -1 | -6 | 0 | -7 | 1
7 | 6 | 0 | 6 | 0 | 7 | 7
2 | -5 | 1 | -6 | 0 | -5 | 2
6 | 6 | 0 | 6 | 0 | 5 | 6
0 | -6 | 0 | -6 | 0 | -6 | 0
8 | 6 | 0 | 6 | 0 | 6 | 8
8 | 0 | 6 | 1 | 7 | 0 | 8
0 | -1 | -7 | -1 | -7 | 0 | 0
7 | 0 | 6 | -1 | 5 | 0 | 7
1 | 1 | -5 | 1 | -5 | 0 | 1
6 | 0 | 6 | 0 | 6 | 0 | 6
2 | 0 | -6 | 0 | -6 | 0 | 2
Spreadsheet: 0fda912a-6dbb-487d-8837-aca41cd5ef49
Sheet: 8d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Fixed-Float | 10094 | 3518 | 19242 | 2662
OTHER* | 1085 | 4172 | 197 | 1752
TOTAL | 11179 | 7690 | 19439 | 4414
*OTHER variable includes the following products: Basis, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, FRA,  Inflation, OIS, and Swaption.
Spreadsheet: 818881d1677094211-split-by-certain-value-q_prev_1
Sheet: Hárok1

275 | 100 | -100
285 | 50 | -50
205 | 60 | -60 |  |  | i want to split this
300 | 50 | -50
215 | 30 | -30
285 | 50 | -50
275 | 100 | -100
285 | 50 | -50
205 | 60 | -10
 |  |  |  |  | into this
 |  | TOTAL -160
 |  |  |  |  | when count on C2:C7 reaches -160
205 | 60 | 50
300 | 50 | 50
215 | 30 | 30
285 | 50 | -30
 |  | TOTAL -160
Spreadsheet: 762494d1641577433-dynamic-sort-function-for-data-entries-eh-ss-db_v3
Sheet: Tasks Without ST&end Days

2021-09-01 00:00:00
 |  |  |  |  | Week 1 |  |  | Week 2 |  |  |  |  | Week 3 |  |  |  |  | Week 4 |  |  |  |  | Week 5
TASK NO. | ACTIVITY | PRIORITY | CLIENT (IF APPLICABLE) | HOURS SPENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOTES
Grant
1 | Holiday | N/A |  |  | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5
2 | Training | N/A |  |  | 1
3 | Dropdown | LOW
4 | Dropdown | MEDIUM
5 | Dropdown | HIGH
6 | Dropdown | LOW
7 | Dropdown | MEDIUM
8 | Dropdown | HIGH
9 | Dropdown | LOW
10 | Dropdown | MEDIUM
11 | Dropdown | HIGH
12 | Dropdown | LOW
13 | Dropdown | MEDIUM
14 | Dropdown | HIGH
15 | Dropdown | LOW
16 | Dropdown | MEDIUM
17 | Dropdown | HIGH
18 | Dropdown | LOW
19 | Dropdown | LOW
20 | Dropdown | LOW
[NAME]
1 | Holiday | N/A |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 | Training | N/A
3 | Dropdown | LOW
4 | Dropdown | MEDIUM
5 | Dropdown | HIGH
6 | Dropdown | LOW
7 | Dropdown | MEDIUM
8 | Dropdown | HIGH
9 | Dropdown | LOW
10 | Dropdown | MEDIUM
11 | Dropdown | HIGH
12 | Dropdown | LOW
13 | Dropdown | MEDIUM
14 | Dropdown | HIGH
15 | Dropdown | LOW
16 | Dropdown | MEDIUM
17 | Dropdown | HIGH
18 | Dropdown | LOW
19 | Dropdown | LOW
20 | Dropdown | LOW
Spreadsheet: 948758d5-b7b5-4fff-b6f0-1775850b22af
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Word Records | 80688805821 | Pocket Full Of Rocks | Ever Close To You | 2010-04-06 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | 80688805722 | Pocket Full Of Rocks | Wonderful | 2010-04-06 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | 80688805623 | Pocket Full Of Rocks | Come As You Are | 2010-04-20 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | 80688733421 | Pocket Full Of Rocks | Let The Worshippers Arise (New Version) | 2007-09-25 | Studio Series 3-Key CD Trax | Praise | 9.99 | N | To Be Retired
Word Records | 80688805920 | Pocket Full Of Rocks | Let Our God Be Praised | 2010-04-20 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | 80688721220 | Pocket Full Of Rocks | Take Me There | 2007-07-24 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | 80688721121 | Pocket Full Of Rocks | At The Cross | 2007-08-14 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | 80688721022 | Pocket Full Of Rocks | Water | 2007-08-28 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | 80688701529 | Pocket Full Of Rocks | Welcome Song, The | 2006-08-08 | Studio Series 3-Key CD Trax | Praise | 9.99 | N | To Be Retired
Word Records | 80688654825 | Pocket Full Of Rocks | Worth Everything | 2006-03-14 | Studio Series 3-Key CD Trax | Praise | 9.99 | N | To Be Retired
Word Records | 80688654726 | Pocket Full Of Rocks | Song To The King | 2006-03-14 | Studio Series 3-Key CD Trax | Praise | 9.99 | N | To Be Retired
Word Records | 80688654627 | Pocket Full Of Rocks | More Of You Jesus | 2006-03-14 | Studio Series 3-Key CD Trax | Praise | 9.99 | N | To Be Retired
Word Records | 80688654528 | Pocket Full Of Rocks | Let The Worshippers Arise | 2006-03-14 | Studio Series 3-Key CD Trax | Praise | 9.99 | N | To Be Retired
Word Records | 80688654122 | Pocket Full Of Rocks | Falling | 2006-03-14 | Studio Series 3-Key CD Trax | Praise | 9.99 | N | To Be Retired
Spreadsheet: 853654d1703581516-formula-to-calculate-provisional-tax-dec-qpds
Sheet: QPDs

 | Kindly asking for excel formula to calculate tax payable on quarterly dates using the informaton on transactions sheet, columns I to K.
 | Please not the annual estimated tax due should be revised to update the estimate every quarter.
 | Desired solution
 | Tax payable on Quarterly Payment Dates (QPD)
 | QPD | Due (on or before) | Installment Due (as a % of the annual tax payable) | Amount
 | 1st QPD | 25th March | 0.1 | 93223.08014400008
 | 2nd QPD | 25th June | 0.25 | 277784.5777440001
 |  | Shortfall or refund 1st Quarter |  | 17890.75095359997
 |  | Total Tax payable
 | 3rd QPD | 25th September | 0.3 | 472212.7172639999
 |  | Shortfall or refund 2nd Quarter |  | 162016.4279663997
 |  | Total Tax payable
 | 4th QPD | 20th December | 0.35 | 309663.7916988003
 |  | Shortfall or refund 3rd Quarter |  | -448037.6552027994
 |  | Total Tax payable
 | Annual
Spreadsheet: 53df8e15-4552-4ac8-8425-33af2a546c70
Sheet: County-Hosted Cost

Cost Worksheet - County Hosted
Cost Worksheet Instructions: Provide a cost response for each cost area, based upon system modules for a County-hosted application. The pricing should be based on the detailed functionality that the County requires for each functional area. When a single price may be provided for a group of modules, please provide that cost with a notation. All additional costs should be captured in the respective areas.
Cost Area (Tab No. from Attachment B - Functional and Technical Requirements) | #2 Citizen Self-Service | #3  Planning & Zoning | #4 Permitting &Inspections | #5  Code Enforcement | #6  Special Assessments | Total
One-Time Costs:
[NAME] Costs
Software Customization Costs
Interfaces/Integration Costs
Data Conversion Costs
Professional Service Costs (not including integration and interfaces)
Training Costs
Server Hardware Costs
Web Based Payment
Expenses (miscellaneous)
Total One-Time Costs
Recurring Maintenance Costs:
Annual Maintenance
Custom Modification Maintenance (if applicable)
Additional Maintenance Fees
Total Recurring Maintenance Costs
[NAME]: | Year 1 | Year 2 | Year 3
Rate of Increase over Prior Year (as a percentage)
[NAME] (as a dollar amount)
Additional Costs:
Hourly Rate for Professional Services
Hourly Rate for Custom Programming
Other Costs (if applicable; please specify the nature of these costs)