tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: mary_fischer__25813__ECM Wholesale 2CE 3CE variance analysis
Sheet: CRP

[NAME]
Analysis of 2nd CE to 3rd CE Variances
For the tax year 2000
(in millions)
DR/(CR)
(Income)/Loss
 | 2CE | 3CE | [NAME] |  | Reasons for variance
Net Income Before Tax | -6 | -50 |  |  | See Note 5
Permanent Differences
Dividends | 0 | 0
Equity Earnings | 0 | 0
Foreign Operations | 1 | 2 |  |  | Co. 66S hyperion entry in September
Foreign Taxes | 0 | 0
Gain/Loss On Sale of Stock/Assets | 100 | 100
Other - MTM not on books | 0 | -32 |  |  | See Note 4
Other - NIBT Transfer | 0 | -27 |  |  | See Note 4
Total Permanent Differences
Temporary Differences
Depreciation, Depletion, & Amort. | 0 | 0
Partnership Equity | 1 | -84 |  |  | See Note 2
Gain/Loss On Sale of Stock/Assets | -100 | 0 |  |  | See Note 1
Price Risk Management | 0 | 60 |  |  | See Note 3
Regulatory Contingencies | 0 | 0
Other | 0 | 0
Total Temporary Differences
Total State Taxable Income
Current State Tax Exp/(Bene) | 0 | 0
Total Federal Taxable (Income)/Loss
Current Tax Expense (Benefit)
Federal
State | 0 | 0
Foreign | 0 | 0
Federal Tax Credits | 0 | 0
Other Federal | -2 | 9 |  |  | NOL Allocation
Other State | 0 | 0
Other Foreign | 0 | 0
Total Current Tax Expense (Benefit)
Deferred Tax Expense (Benefit)
Federal | -34 | -9
State | -3 | 1
Foreign | 0 | 0
Federal Tax Credits | 0 | 0
Other Federal | 0 | -9 |  |  | NOL Allocation
Other State | 0 | 0
Other Foreign | 0 | 0
Total Deferred Tax Expense (Benefit)
Total Tax Expense (Benefit)
Net (Income) / Loss
Effective Rate
Additional Notes regarding changes from 2CE to 3CE:
Note 1:  Co. 938 switched the Gain/Loss M-1 to Partnership Equity
Note 2: Harrier and [NAME] were created in October and we reversed everything that was
related to the Deconsolidated entities as partnership equity.
Note 3: Harrier has unrealized MTM in October so we set up deferred taxes
Note 4:  Accounting did not book the unrealized MTM so we had to do a permanent
adjustment to put the MTM on Harrier's books
Note 5: Accounting did not put anything in the 2nd CE for Co. 66S
There were 3 new entities created in 3rd quarter related to Project Raptor which
created additional NIBT of  $17M.
Spreadsheet: 215921d1361541678-sum-of-sum-tableau-entrep-ts
Sheet: B15

Local 15
Nom: | Alain Boire/CC
Numéro de téléphone: | [PHONE]
[NAME]: | 40
Paiement dû le: | 2013-03-15 00:00:00
[NAME]: | 25
Réservé:
Prix: | 140
Payé: | OUI
Mois réservés
Novembre 2011
Décembre 2011
Janvier 2012
Février 2012
Mars 2012
Avril 2012
Mai 2012
[NAME] 2012
Juillet 2012
Août 2012
Septembre 2012
Octobre 2012
Novembre 2012
Décembre 2012
Spreadsheet: 41150d1239662642-coppying-data-from-sheet1-to-sheet2-using-vlookup-nonarraymultiplelookup2
Sheet: Summary

 | Select | Year | Col1 | Col2 | Col3 | Col4
Product | apple | 50 | 1 | Bin1 | Region10 | Area100 | This is done without array formulas (which slow down larger spreadsheets)
 |  | 60 | 0 | Bin2 | Region11 | Area101 | by adding "key" helper column on your data sheet1. I put it in column A, you could put it anywhere
 |  | 44 | 1 | Bin5 | Region14 | Area104
 |  | 33 | 0 | Bin6 | Region15 | Area105 | As you select from the products in B2, the key will change and renumber
 |  |  |  |  |  |  | to flag the appropriate data rows on that sheet.
 |  |  |  |  |  |  | Then the formulas in the tan section will see if their row # is within the number
 |  |  |  |  |  |  | of valid answers from the key, if so, they will appear. When the row # exceeds
 |  |  |  |  |  |  | the maximum of the current "key", the rows stop showing results and stay blank.
 |  |  |  |  |  |  | This can be worked on a data sheet of virtually any size and stay very fast, almost instantaneously
Spreadsheet: kate_symes__18325__Variances
Sheet: April

Date | Buy/Sell | Del Pt | Deal # | Hrs | Total MWH | Rate | Problem | [NAME] RESPONSE
4/1 | Buy | SP-15 | 566424.1 |  | 341 | 125 | Rate should be $125.73 per [NAME]'s schedule | Rate changed to $125.73
4/1 | Buy | Nepool | 302293.1 |  | 625 | 34 | EES has 575 MWh with hour 2-3 zeroed out for daylight savings | This is an East trade - did not originate from our office/I cannot access it in our system
4/1 | Buy | Nepool | 399863.1 |  | 600 | 24.25 | EES has 575 MWh with hour 2-3 zeroed out for daylight savings | This is an East trade - did not originate from our office/I cannot access it in our system
4/1 | Sell | Nepool | 302297.1 |  | 625 | 35 | EES has 575 MWh with hour 2-3 zeroed out for daylight savings | This is an East trade - did not originate from our office/I cannot access it in our system
4/2 | Buy | SP-15 | 566391.1 | off peak | 416 | 125.73 | Total MWh for 566391.1 and 566426.1 off peak should be 599 per [NAME]'s schedule | [NAME] were cut in the day ahead market - [NAME] and I are researching this
4/2 | Buy | SP-15 | 566426.1 | off peak | 142.8 | 125 | Rate should be $125.73 per [NAME]'s schedule | Rate changed to $125.73
4/2 | Buy | SP-15 | 566391.1 | on peak | 96 | 220.17 | Total MWh for 566391.1 and 566426.1 on peak should be 331 per [NAME]'s schedule | [NAME] were cut in the day ahead market - [NAME] and I are researching this
4/2 | Buy | SP-15 | 566426.1 | on peak | 252.46 | 220 | Rate should be $220.17 per [NAME]'s schedule | Rate changed to $220.17
4/8 | Buy | SP-15 | 573785.1 |  | 115 | 80 | Real time sheet sent to EES has 35 @ $80 | Real Time sheet has been changed to reflect correct hours and volume - total MWH for HE 2 through 6 should be 115
4/8 | Buy | SP-15 | 576512.1 | HE 24 | 17 | 80 | Real time sheet sent to EES has 35 @ $80 | Need clarification on this - I don't see the 35 @ $80 - please see View Actuals in Deal Entry for complete volumes and hours
4/9 | Buy | SP-15 | 576512.1 | HE 2,3,5 | 31 | 80 | Real time sheet sent to EES has 48 @ $80 | Need clarification on this - I don't see the 35 @ $80 - please see View Actuals in Deal Entry for complete volumes and hours
4/9 | Sell | SP-15 | 573862.1 |  | 0.2 | 107 | EES not showing this deal | Spreadsheet changed to reflect 0.2 MW fixed price sale to EES at SP-15 for 4/9/01
4/11 | Buy | SP-15 | 578856.1 |  | 21 | 150 | EES not showing this deal | Spreadsheet changed to reflect 21 MW fixed price buy from EES at SP-15 for 4/11/01
4/13 | Sell | Cinergy | 578969.1 |  | 10 | 40 | EES has 8 @ $40 which ties to the confirm
4/17 | Buy | SP-15 | 583034.1 |  | 62 | 175 | EES not showing this deal
4/17 | Buy | SP-15 | 583034.1 |  | 17 | 165 | EES not showing this deal
4/17 | Buy | SP-15 | 583034.1 |  | 16 | 155 | EES not showing this deal
4/17 | Buy | SP-15 | 583034.1 |  | 56 | 135 | EES not showing this deal
4/17 | Buy | SP-15 | 583034.1 |  | 60 | 57 | EES not showing this deal
Spreadsheet: 5ffa571f-6fdc-43c7-8dc2-f6bdb79f162d
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40869500 | 2014-04-06 15:23:15 | AXIS | 1 | 6 | 2 | 532962 | Sadistic-Inn-Tent | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
40869756 | 2014-04-06 15:44:18 | ALLIES | 0 | 5 | 6 | 532962 | Sadistic-Inn-Tent | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
40930090 | 2014-04-10 19:27:38 | ALLIES | 1 | 6 | 1 | 642023 | [NAME] | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
40968999 | 2014-04-13 12:48:13 | ALLIES | 1 | 6 | 2 | 1004418 | lingfields | 12502 | western | 1944-08-12 |  | Forêt d'Ecouves | La forêt d'Écouves
40969422 | 2014-04-13 13:25:36 | AXIS | 1 | 6 | 3 | 1004418 | lingfields | 12502 | western | 1944-08-12 |  | Forêt d'Ecouves | La forêt d'Écouves
40971074 | 2014-04-13 15:29:38 | ALLIES | 1 | 6 | 3 | 721298 | Frost 1st Para | 6147 | western | 1944-06-06 | 1944-06-06 | First Assault Wave | 1ère vague d'assaut
40971376 | 2014-04-13 15:48:58 | AXIS | 1 | 6 | 2 | 721298 | Frost 1st Para | 6147 | western | 1944-06-06 | 1944-06-06 | First Assault Wave | 1ère vague d'assaut
41003562 | 2014-04-15 18:58:40 | AXIS | 1 | 6 | 3 | 927775 | Blitzkrieg75 | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
41005170 | 2014-04-15 20:37:47 | AXIS | 1 | 6 | 3 | 542819 | Didorapido | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
41005672 | 2014-04-15 21:04:51 | ALLIES | 1 | 6 | 5 | 542819 | Didorapido | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
Spreadsheet: 704453d1605555925-if-formula-with-uk-statutory-redundancy-payout-1-one-to-test
Sheet: x Sheet2

 | STATUTORY REDUNDANCY PAYOUT
 | Name | Date of Birth | [NAME] | In Service | Annual Pay | Stat Weekly Rate | Redundancy Effective Date | Location Redundancy  Payment | Completed Year of Service | Qualification Based on Min. Year of Service | Subject to [NAME]. [NAME] |  | Weeks' Pay Entitlement | Computed Payout | Actual Entitlement |  | Minimum Year of Service |  |  | [NAME] |  |  |  |  | Week's Pay Entitlement
 |  |  |  |  |  |  |  |  |  |  | Year of Service | Weekly Pay |  |  |  |  | Location | Year of Service |  | Location | Year of Service | Weekly Pay | Payout |  | Age Group | Age Factor | Week's Pay
 | O | 1960-02-18 00:00:00 | 57 | 32 | 22260 | 428 | 2016-12-31 00:00:00 | England |  |  |  |  |  |  |  |  | England | 2 |  | England | 20 | 489 | 14670 |  | Under 22 | 0 | 0.5
 | P | 1956-05-24 00:00:00 | 61 | 27 | 22382 | 430 | 2016-12-31 00:00:00 | Northern Ireland |  |  |  |  |  |  |  |  | Northern Ireland | 2 |  | Northern Ireland | 20 | 500 | 15000 |  | 22 to 40 | 22 | 1
 | Q | 1962-12-21 00:00:00 | 54 | 27 | 22740 | 437 | 2016-12-31 00:00:00 | Northern Ireland |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41 or older | 41 | 1.5
 | R | 1964-08-19 00:00:00 | 52 | 32 | 23090 | 444 | 2016-12-31 00:00:00 | Northern Ireland
 | S | 1959-10-27 00:00:00 | 57 | 32 | 23304 | 448 | 2016-12-31 00:00:00 | England
 | T | 1963-05-30 00:00:00 | 54 | 38 | 29740 | 572 | 2016-12-31 00:00:00 | England |  |  |  |  |  |  |  |  | https://www.gov.uk/redundant-your-rights/redundancy-pay |  |  | https://www.gov.uk/redundant-your-rights/redundancy-pay
 | U | 1963-11-08 00:00:00 | 53 | 30 | 30000 | 577 | 2016-12-31 00:00:00 | England
 | V | 1959-02-03 00:00:00 | 58 | 37 | 30210 | 581 | 2016-12-31 00:00:00 | England
 | W | 1962-03-03 00:00:00 | 55 | 32 | 30220 | 581 | 2016-12-31 00:00:00 | England
 | X | 1963-07-14 00:00:00 | 53 | 35 | 30250 | 582 | 2016-12-31 00:00:00 | England
 | Y | 1969-05-10 00:00:00 | 48 | 27 | 31270 | 601 | 2016-12-31 00:00:00 | England
 | Z | 1968-11-27 00:00:00 | 48 | 30 | 31290 | 602 | 2016-12-31 00:00:00 | Northern Ireland
Spreadsheet: 269827d1381301455-need-a-column-that-will-specify-how-many-pieces-of-epuipment-are-running-per-month-help-0a227
Sheet: Before

Equipment Name | Date | Number of equipment per Month | Στήλη1
Equipment A | 2013-01-01 00:00:00
Equipment B | 2013-01-01 00:00:00
Equipment C | 2013-01-01 00:00:00
Equipment D | 2013-02-01 00:00:00
Equipment A | 2013-02-01 00:00:00
Equipment A | 2013-02-01 00:00:00
Equipment C | 2013-02-01 00:00:00
Equipment C | 2013-02-01 00:00:00
Equipment D | 2013-03-01 00:00:00
Equipment D | 2013-03-01 00:00:00
Equipment D | 2013-03-01 00:00:00
Equipment A | 2013-04-01 00:00:00
Equipment A | 2013-04-01 00:00:00
Equipment A | 2013-04-01 00:00:00
Equipment B | 2013-04-01 00:00:00
Spreadsheet: 19cdff91-fde9-450a-9919-fe11462fca58
Sheet: Sheet1

analytica 2012 - Aussteller Liste | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Suche über Produkt- und Dienstleistungsverzeichnis (11 [NAME]):
 | 3 Mess-, [NAME] und Qualitätskontrolle 3.10 Materialprüfungen 3.10.1 Zerstörungsfreie Prüfung
Nr. | Firma | Land | Ort | PLZ | Halle/Stand
1 | analyticon instruments gmbh | Deutschland | Rosbach | 61191 | A2.439
2 | Andor Technology plc. | Großbritannien | Belfast | BT12 7AL | A2.144
3 | Bruker Elemental GmbH | Deutschland | [NAME] | 47546 | A2.331/432
4 | FLUXANA GmbH & Co. [NAME] | Deutschland | Bedburg-Hau | 47551 | A2.509
5 | Innov-X Systems Europe B.V. | Niederlande | s&#39;-Hertogenbosch | 5222 AX | A2.534
6 | NIST National Institute of Standards & Technology | USA | Gaithersburg | MD 20899 | A2.409
7 | [NAME] | Deutschland | Waldbronn | 76337 | A2.217
8 | Renishaw GmbH | Deutschland | [NAME] | 72124 | A2.520
9 | RJL Micro & Analytic GmbH | Deutschland | Karlsdorf-Neuthard | 76689 | A1.531B
10 | Roentgenanalytik Systeme GmbH & Co.[NAME] | Deutschland | Taunusstein | 65232 | A2.419
11 | Shimadzu Deutschland GmbH | Deutschland | Duisburg | 47269 | [NAME]
Spreadsheet: 860731d1708717526-how-to-move-desired-rows-to-a-new-worksheet-2024_01_01_transx-1-
Sheet: Consignments

Date | Time | Time Zone | Category | Item | Qty | Income Dept | SKU | Modifiers Applied | Gross Sales | Discounts | Net Sales | Tax | Transaction ID | Payment ID | Device Name | Notes | Details | Event Type | Location | Dining Option | Customer ID | Customer Name | Customer Reference ID | Unit | Count | Itemization Type | Commission | Employee | Fulfillment Note
 | 18:48:48 | Pacific Time (US & Canada) | Consignment | VMC 421 | 1 | Consignment | 0 | 0 | 14 | 0 | 14 | 0.66 | 45ThAy2lqT8zh9RoO3b4C4yeV | Tv9h8vpRNpgQzwKD3KcZRaUFuaB | 0 | 0 | https://squareup.com/dashboard/sales/transactions/45ThAy2lqT8zh9RoO3b4C4yeV/by-unit/LEA1S1KDPSGEG | Payment | [NAME] | 0 | 0 | 0 | 0 | ea | 1 | Physical Item | 0 | Midge Jambor | 0
2024-01-01 00:00:00 | 18:48:48 | Pacific Time (US & Canada) | Consignment | [NAME] MM Print Onomea Morn | 1 | Consignment | 0 | 0 | 29 | 0 | 29 | 1.37 | M3vSqpqdmJWJj589RC6zg4reV | Lf9SXvglS0W0tWl6dsLnwzklvaB | 0 | 0 | https://squareup.com/dashboard/sales/transactions/M3vSqpqdmJWJj589RC6zg4reV/by-unit/LEA1S1KDPSGEG | Payment | [NAME] | 0 | B9W7PW7J5D95CKF2B9C02D5DM4 | [NAME] | 0 | ea | 1 | Physical Item | 0 | Midge Jambor | 0
2024-01-01 00:00:00 | 12:28:17 | Pacific Time (US & Canada) | Consignment | [NAME] of Refuge Weaving | 1 | Consignment | 0 | 0 | 30 | 0 | 30 | 1.41 | gTuFoeiXAwNlFUhbyHxBKD6eV | Jo262Tz5yQgzSYy1cYYiwYUbuaB | 0 | 0 | https://squareup.com/dashboard/sales/transactions/gTuFoeiXAwNlFUhbyHxBKD6eV/by-unit/LEA1S1KDPSGEG | Payment | [NAME] | 0 | 0MBJ0T4HERA6K0Z7CGNZQ9DMZ8 | [NAME] | 0 | ea | 1 | Physical Item | 0 | Midge Jambor | 0
Spreadsheet: 155570d1336967444-pivot-table-only-sums-the-first-group-of-records-pivot-amounts-on-pets
Sheet: table2 (C)

[NAME] | Cr
Sum of AMOUNT |  |  | month
GROUP | 40 LIST | AMOUNT | Jan | Feb | Grand Total
Adoptions | Dog Adoption | 250 |  | 250 | 250
 | Dog Adoption Total |  |  | 250 | 250
 | Guinea Pig Adoption | 20 | 20 |  | 20
 | Guinea Pig Adoption Total |  | 20 |  | 20
 | Kitten Adoption | 60 | 60 |  | 60
 | Kitten Adoption Total |  | 60 |  | 60
Adoptions Total |  |  | 80 | 250 | 330
Recoup from error | Missdirected EFTPOS | 46 |  | 46 | 46
 | Missdirected EFTPOS Total |  |  | 46 | 46
Recoup from error Total |  |  |  | 46 | 46
Shop Donation Tin | Corner Store | 131 |  | 131 | 131
 | Corner Store Total |  |  | 131 | 131
Shop Donation Tin Total |  |  |  | 131 | 131
Grand Total |  |  | 80 | 427 | 507
Spreadsheet: 266469d1379620825-use-selections-from-two-data-validation-lists-to-lookup-and-return-a-combined-result-state-county-fips-codes
Sheet: SOUTH DAKOTA-40

 | COUNTY | CODE
 | [NAME] | 3
 | Beadle
 | [NAME]
 | [NAME]
 | Brookings
 | [NAME]
 | [NAME]
 | Buffalo
 | [NAME]
 | Campbell
 | [NAME]
 | [NAME]
 | Clay
 | Codington
 | [NAME]
 | Custer
 | Davison
 | Day
 | [NAME]
 | Dewey
 | [NAME]
 | Edmunds
 | Fall River
 | Faulk
 | Grant
 | Gregory
 | Haakon
 | [NAME]
 | Hand
 | Hanson
 | [NAME]
 | Hughes
 | Hutchinson
 | Hyde
 | [NAME]
 | Jerauld
 | Jones
 | Kingsbury
 | Lake
 | [NAME]
 | Lincoln
 | [NAME]
 | McCook
 | McPherson
 | [NAME]
 | Meade
 | Mellette
 | Miner
 | Minnehaha
 | Moody
 | Pennington
 | Perkins
 | Potter
 | [NAME]
 | Sanborn
 | Shannon
 | Spink
 | Stanley
 | Sully
 | Todd
 | Tripp
 | Turner
 | Union
 | Walworth
 | Yankton | 135
 | Ziebach | 137
Spreadsheet: 115866d1311343635-conditional-formatting-book1
Sheet: Sheet1

1
2
3
4
5
6
7
8
9
0
11
2
22
33
44
55
66
77
88
99
0
Spreadsheet: 846585d1697730722-generate-a-number-of-names-from-a-list-without-repetition-help-random-list-
Sheet: Sheet1

SOURCE |  | RESULT
[NAME] |  | [NAME]
@dinozzabrr |  | @rlirabbii9 @dinozzabrr @JaxxZay
@danickteklilm |  | @MorakeDimpho @Andrespulgars @Veis389
@MorakeDimpho
@RayJomark
@Courtneyd223
@theRealQuizzy
@quisjourney
@purgajjianuy
@mamatosona
@EvaGemmers
@olaoiirobq
@Taeneverkared
@JaxxZay
@KodaShama
@romilamindij
@Andrespulgars
@jigscasm
[NAME]
@rlirabbii9
@MicheleFubas
@Leomustafi
@egnekuleba3
@Aidaalex33
@DreadheadCris
@thatpinkspot
@karayeradiseh
@nedithheaphyh
@TAIRAC85
@Veis389
Spreadsheet: 356485fc-a6c9-41e8-9657-8cf84fc09fe0
Sheet: ZNF280BY

Additional file 2.    Analyses of the ZNF280BY containing BACs.
ZNF280BY active homologs | BAC containing active ZNF280BY | Type | cDNA cluster# | Culster of protein isoform
1 | AC175430 | A | 1 | 1
2 | AC213441,AC225911 | A | 2
3 | AC213708,AC229802 | A
4 | AC225840,AC232757 | A
5 | AC225843,AC232758 | A
6 | AC232930 | A
7 | AC232931 | A
8 | AC233175 | A
9 | AC234147 | A
10 | AC213538 | A
11 | AC213701 | A | 3
12 | AC213709 | A
13 | AC216718 | A | 4
14 | AC217148,AC226427 | A | 5
15 | AC226193 | A
16 | AC213443 | A | 6* | 2
17 | AC213716 | A | 7
18 | AC213448,AC213715,AC216909 | A | 8 | 3
19 | AC216752,AC233223,AC233687 | A
20 | AC232283 | A
21 | AC234573 | A | 9
22 | AC165011 | A | 10 | 4
23 | AC213721,AC225949 | A | 11 | 5
24 | AC216712 | A
25 | AC231395 | A | 12 | 6
26 | AC232928 | A
27 | AC213445 | A | 13 | 7
28 | AC225934,AC232284 | A
29 | AC213451 | A | 14* | 8
30 | AC226099 | A
31 | AC233552 | A
32 | AC229803,AC232994 | A | 15 | 9
33 | AC231447 | A
34 | AC226433 | A | 16 | 10
35 | AC213722 | A | 17 | 11
36 | AC226000,AC233168 | A
37 | AC229881 | A
38 | AC233798 | A | 18 | 12
39 | AC235984 | A
40 | AC231446 | A | 19 | 13
41 | AC234324 | A
42 | AC164336 | A | 20 | 14
43 | AC213714,AC232313 | A | 21
44 | AC225846 | A
45 | AC226436 | A
46 | AC233686 | A
47 | AC235955 | A
48 | AC177810,AC225841 | A | 22* | 15
49 | AC216983 | A | 23* | 16
50 | AC213447,AC213450,AC216714 | A | 24* | 17
51 | AC215667,AC217070 | A | 25*
52 | AC157133,AC216720 | A | 26 | 18
53 | AC229869, AC232932 | A
54 | AC234146 | A
55 | AC213707 | A | 27 | 19
56 | AC232983,AC234101 | A
57 | AC226430,AC233217 | A | 28
58 | AC213449 | A | 29* | 20
59 | AC169218,AC175544 | A | 30 | 21
60 | AC213442,AC226022 | A
61 | AC216830,AC216980 | A
62 | AC213704 | A | 31*
63 | [NAME] | A
64 | AC231867 | A | 32
65 | AC216977,AC226028 | A | 33* | 22
66 | AC166505,AC233689 | A | 34* | 23
67 | AC214856,AC216832 | A | 35 | 24
68 | AC216761 | A
69 | AC233222 | A
70 | AC226192 | A | 36 | 25
71 | AC226424 | A
72 | AC232286 | A
73 | AC232881 | A
74 | AC172950 | A | 37* | 26
75 | AC161642,AC169344 | A | 38* | 27
76 | AC217001,AC217072,AC217073 | B | 39 | 28
77 | AC232280,AC232285 | C | 40 | 29
78 | AC213711 | A | 41 | 30
79 | AC225912,AC234909 | A | 42 | 31
80 | AC229799 | A
81 | AC232939 | A
82 | AC234951 | A
# cDNA cluster that have been confirmed by Sanger sequencing results except for those clusters with an asterisk that were not proved by the Sanger sequencing.
Spreadsheet: 861034d1709036871-excess-counting-logic-help-incentive-calculation
Sheet: Sheet1

Loans | Loans Conversion | Cards | Target | Total Achievement | Eligible for incentive? | Excess Loan |  | Excess Card | 0-10 | 11-15 | 16-20 | 21+
635500 |  | 10 | 8 |  |  |  |  |  |  |  |  |  | this the formula you gave me which needs some ammendment
Only "Cards" should be counting on slabs after the "Target" but based on the total "Achievement"
Examples:
Loans | Loans Conversion | Cards | Target | Total Achievement | Eligible for incentive? | Excess Loan |  | Excess Card | 0-10 | 11-15 | 16-20 | 21+
635500 |  | 10 | 8 |  |  |  |  |  | 0 | 3 | 5 | 2 | since total achievement is 22.71 and target is 8, I need to count the 10 cards after the 12.71 loans so 13th onwards as per slab
500000 |  | 4 | 6 |  |  |  |  |  | 0 | 4 | 0 | 0 | since total achievement is 14 and target is 6, I need to count the 4 cards as 11th,12th,13th,14th
250000 |  | 6 | 5 |  |  |  |  |  | 5 | 1 | 0 | 0
175000 |  | 2 | 7 |  |  |  |  |  | 0 | 0 | 0 | 0 | total achievement is less than target so all slabs should be zero
654987 |  | 9 | 11 |  |  |  |  |  | 0 | 2 | 5 | 2
789654 |  | 5 | 16 |  |  |  |  |  | 0 | 0 | 4.79 | 0
Spreadsheet: 146198d1331970886-calculation-of-betas-of-a-multiple-regression-rolling-window-multiple-regression
Sheet: Multiple regression

Date | Return | X1 | X2 | X3 | X4 | X5
1975-11-30 00:00:00 | 0.04338637277991565 | 0.0179 | 15.9 | 0.0554 | 0.007117437722419903 | 0.002620866424777569
1975-12-31 00:00:00 | -0.02149655326173015 | 0.0189 | 14.6 | 0.052 | 0.00353356890459369 | 0.01246813419252103
1976-01-31 00:00:00 | 0.03204243742928258 | 0.0175 | 15.7 | 0.0473 | 0.003521126760563305 | 0.01464534252999886
1976-02-29 00:00:00 | -0.03307168081731783 | 0.0188 | 14.6 | 0.05 | 0.003508771929824611 | 0.009508246472050688
1976-03-31 00:00:00 | 0.02298002207667653 | 0.0179 | 14.6 | 0.04969999999999999 | 0 | 0.001040611602125662
1976-04-30 00:00:00 | -0.004038614255871554 | 0.0179 | 14.6 | 0.0491 | 0.006993006993006968 | 0.005756685332002778
1976-05-31 00:00:00 | -0.01641156749238457 | 0.0186 | 14.1 | 0.0549 | 0.003472222222222271 | 0.004706233634985414
1976-06-30 00:00:00 | -0.02282373449704601 | 0.0195 | 12.7 | 0.0537 | 0.00692041522491347 | 6.629647325632045e-05
1976-07-31 00:00:00 | 0.01823886922194974 | 0.0186 | 13.3 | 0.0517 | 0.003436426116838536 | 0.005762838946824578
1976-08-31 00:00:00 | 0.01693893871062664 | 0.0232 | 13.9 | 0.0509 | 0.006849315068493126 | 0.006932149034385725 |  |  | intercept | b1 | b2 | b3 | b4 | [NAME]
1976-09-30 00:00:00 | 0.03903725759230302 | 0.0212 | 14.4 | 0.05060000000000001 | 0.003401360544217615 | 0.002907258892758674
1976-10-31 00:00:00 | -0.005051318594596297 | 0.0214 | 14.3 | 0.0489 | 0.003389830508474624 | 0.0007517155544352414
1976-11-30 00:00:00 | 0.001215431540637672 | 0.0213 | 14.4 | 0.0442 | 0.003378378378378426 | 0.01480262048213095
1976-12-31 00:00:00 | 0.005216336297357372 | 0.0211 | 13.8 | 0.0434 | 0.003367003367003295 | 0.01014331841864408
1977-01-31 00:00:00 | -0.04272602050373696 | 0.0231 | 12.6 | 0.0472 | 0.00671140939597313 | -0.005789693073868488
1977-02-28 00:00:00 | -0.01321837730307184 | 0.0235 | 12.3 | 0.047 | 0.01000000000000002 | 0.01482442609964004
1977-03-31 00:00:00 | -0.02056279694093769 | 0.0246 | 11.2 | 0.0454 | 0.006600660066006577 | 0.01242473727355958
1977-04-30 00:00:00 | 0.007373314044300716 | 0.0306 | 11.5 | 0.0469 | 0.006557377049180421 | 0.009697102467123188
1977-05-31 00:00:00 | -0.005855282426457731 | 0.0308 | 11.4 | 0.0503 | 0.006514657980456002 | 0.008325569325148248
1977-06-30 00:00:00 | 0.01738680385012852 | 0.0296 | 11.2 | 0.0498 | 0.00647249190938509 | 0.007463631147264312
1977-07-31 00:00:00 | 0.01209499623551703 | 0.0287 | 11.5 | 0.05400000000000001 | 0.003215434083601332 | 0.001501350587348449
1977-08-31 00:00:00 | 0.0269834896855935 | 0.0269 | 12.3 | 0.0556 | 0.003205128205128136 | 0.0004495208943583262