tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: lisa_gang__22289__ENA_PGE_MAY 6_2002
Sheet: JD-MAL OR CPTJK TRANS

From: | EPMI
To: | PGE System Transactions
Date: | 2002-05-06 00:00:00
Total Transmission
HE
ENDING | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | TOTAL
Pacific Prevailing
Time | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | [NAME] USED
(PPT) |  |  |  |  |  |  | Total In To PGE Trans
0100 |  |  |  |  | 0 | 0
0200 | 0 | 0 | 0 | 0 | 0 | 0
0300 | 0 | 0 | 0 | 0 | 0 | 0
0400 | 0 | 0 | 0 | 0 | 0 | 0
0500 | 0 | 0 | 0 | 0 | 0 | 0
0600 | 0 | 0 | 0 | 0 | 0 | 0
0700 | 25 | 25 | 25 | 25 | 25 | 25
0800 | 25 | 25 | 25 | 25 | 25 | 25
0900 | 25 | 25 | 25 | 25 | 25 | 25
1000 | 25 | 25 | 25 | 25 | 25 | 25
1100 | 25 | 25 | 25 | 25 | 25 | 25
1200 | 25 | 25 | 25 | 25 | 25 | 25
1300 | 25 | 25 | 25 | 25 | 25 | 25
1400 | 25 | 25 | 25 | 25 | 25 | 25
1500 | 25 | 25 | 25 | 25 | 25 | 25
1600 | 25 | 25 | 25 | 25 | 25 | 25
1700 | 25 | 25 | 25 | 25 | 25 | 25
1800 | 25 | 25 | 25 | 25 | 25 | 25
1900 | 25 | 25 | 25 | 25 | 25 | 25
2000 | 25 | 25 | 25 | 25 | 25 | 25
2100 | 25 | 25 | 25 | 25 | 25 | 25
2200 | 25 | 25 | 25 | 25 | 25 | 25
2300 | 0 | 0 | 0 | 0 | 0 | 0
2400 | 0 | 0 | 0 | 0 | 0 | 0
 | BPA(G)24711 | BPA(G)24718 | BPA(G)24727 | BPA(G)24771 | BPA(G)24547 | BPA(G)24547
 | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD
 | AEP | AEP | AEP | AEP | AEP | AEP
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | AEP | AEP | AEP | AEP | AEP | AEP
 | CDWR | CDWR | TID | AVISTA | MORGAN | MORGAN
 | ISO(T)MALIN/NP15 | ISO(T)MALIN/NP15 | TID(T)CPJK/TRACEY/WESLEY | DYPM | APX | APX
 | CDWR(L,FS)NP15 (CA) | CDWR(L,FS)NP15 (CA) | TID | MORGAN | ISO(T)MALIN/NP15 | ISO(T)MALIN/NP15
 |  |  | TID(L)WESLEY | WESCO | APX(L,FS)SYS | APX(L,FS)SYS
 |  |  |  | ISO(T)MALIN/NP15
 |  |  |  | WESCO(L,FS)NP15 (CA)
Spreadsheet: 454191d1459716021-correlation-matrix-for-last-12-cells-ef1133691-correlation-across-indices-last-12
Sheet: Sheet1

 | Date | CCI | PPI | C-S NHPI | NUR | RetSls | Starts | S&P | WMT |  | Index1 Index2 | CCI | PPI | C-S NHPI | NUR | RetSls | Starts | S&P | WMT
 | 2013-01-31 00:00:00 | 58.4 | 192.6 | 144.38 | 8 | 376460 | 58700 | 1498.109985 | 69.95 |  | CCI
 | 2013-02-28 00:00:00 | 68 | 195.2 | 145.22 | 7.7 | 374901 | 66100 | 1514.680054 | 70.78 |  | PPI
 | 2013-03-31 00:00:00 | 61.9 | 194.5 | 148.03 | 7.5 | 422763 | 83300 | 1569.189941 | 74.83 |  | C-S NHPI
 | 2013-04-30 00:00:00 | 69 | 194 | 151.05 | 7.6 | 409414 | 76300 | 1597.569946 | 77.72 |  | NUR
 | 2013-05-31 00:00:00 | 74.3 | 194 | 153.95 | 7.5 | 438038 | 87200 | 1630.73999 | 74.84 |  | RetSls
 | 2013-06-30 00:00:00 | 82.1 | 193.9 | 156.52 | 7.5 | 415748 | 80700 | 1606.280029 | 74.49 |  | Starts
 | 2013-07-31 00:00:00 | 81 | 194 | 158.38 | 7.3 | 423397 | 84000 | 1685.72998 | 77.94 |  | S&P
 | 2013-08-31 00:00:00 | 81.8 | 194.6 | 159.5 | 7.2 | 436029 | 80400 | 1632.969971 | 72.98 |  | WMT
 | 2013-09-30 00:00:00 | 80.2 | 194.3 | 159.78 | 7.2 | 397059 | 78400 | 1681.550049 | 73.96
 | 2013-10-31 00:00:00 | 72.4 | 193.7 | 159.67 | 7.2 | 416487 | 78400 | 1756.540039 | 76.75
 | 2013-11-30 00:00:00 | 70.4 | 192.7 | 159.49 | 7 | 424166 | 83800 | 1805.810059 | 81.01
 | 2013-12-31 00:00:00 | 77.5 | 193.2 | 159.41 | 6.7 | 477278 | 67600 | 1848.359985 | 78.69
 | 2014-01-31 00:00:00 | 79.4 | 194.2 | 159.5 | 6.6 | 383459 | 60700 | 1782.589966 | 74.68
 | 2014-02-28 00:00:00 | 78.3 | 195.2 | 160.01 | 6.7 | 380246 | 65100 | 1859.449951 | 74.7
 | 2014-03-31 00:00:00 | 83.9 | 196.2 | 161.33 | 6.6 | 432827 | 80200 | 1872.339966 | 76.43
 | 2014-04-30 00:00:00 | 81.7 | 197.5 | 163.12 | 6.2 | 431335 | 94900 | 1883.949951 | 79.71
 | 2014-05-31 00:00:00 | 82.2 | 197.2 | 164.84 | 6.3 | 458705 | 92500 | 1923.569946 | 76.77
 | 2014-06-30 00:00:00 | 86.4 | 197.2 | 166.37 | 6.1 | 433388 | 87300 | 1960.22998 | 75.07
 | 2014-07-31 00:00:00 | 90.3 | 197.4 | 167.3 | 6.2 | 443153 | 101000 | 1930.670044 | 73.58
 | 2014-08-31 00:00:00 | 93.4 | 197.4 | 167.61 | 6.1 | 450365 | 86200 | 2003.369995 | 75.5
 | 2014-09-30 00:00:00 | 89 | 196.8 | 167.39 | 5.9 | 420516 | 94200 | 1972.290039 | 76.47
 | 2014-10-31 00:00:00 | 94.1 | 194.8 | 167.07 | 5.7 | 437277 | 92000 | 2018.050049 | 76.27
 | 2014-11-30 00:00:00 | 91 | 192.7 | 166.85 | 5.8 | 437196 | 75800 | 2067.560059 | 87.54
 | 2014-12-31 00:00:00 | 93.1 | 189.1 | 166.69 | 5.6 | 499976 | 73400 | 2058.899902 | 85.88
 | 2015-01-31 00:00:00 | 103.8 | 185 | 166.5 | 5.7 | 396495 | 73000 | 1994.98999 | 84.98
 | 2015-02-28 00:00:00 | 98.8 | 185.4 | 166.86 | 5.5 | 385731 | 61900 | 2104.5 | 83.93
 | 2015-03-31 00:00:00 | 101.4 | 186.3 | 168.21 | 5.5 | 442876 | 79700 | 2067.889893 | 82.25
 | 2015-04-30 00:00:00 | 94.3 | 185.7 | 170.14 | 5.4 | 437160 | 108500 | 2085.51001 | 78.05
Spreadsheet: 63694d1264579318-xl-2008-dynamic-chart-not-acting-dynamically-budget92_08
Sheet: Lists

Name=Account =OFFSET(Lists!$A$3,0,0,COUNTA(Lists!$A:$A),1)
Account | Budget |  | R | Type
Awards | 400 |  |  | Check |  | Account | =OFFSET(Lists!$A$3,0,0,COUNTA(Lists!$A:$A)-2,1)
Degree expense | 200 |  |  | Debit Card |  | AcctWBudget | =OFFSET(Lists!$A$3,0,0,COUNTA(Lists!$A:$A),2)
Demolay | 200 |  |  | Bank Charge |  | input | =[NAME])
Donation - to [NAME] | 150 |  |  | Other Charge |  | type | =OFFSET(Lists!$E$3,0,0,COUNTA(Lists!$E:$E)-1,1)
Donations - from member | 500 |  |  | Deposit
Donations - from others | 100
Donations -to JD | 200
GL Comm Assis. | 700
GL fees | 300
insurance | 150
IORG | 200
JDI | 222
Meals - Regular | 1200
Meals - Special | 500
Office Supplies | 1200
Postage | 500
Printing and Copy | 400
Rent | 1400
Scholarships | 3000
Sec/Treas fee | 750
Spreadsheet: jeff_dasovich__14103__California PJM and NE Tables revised2
Sheet: A26

TABLE A26   IMPACT OF PRICE SPIKES AND CAPS IN THE PJM REAL-TIME ENERGY MARKET ON HYPOTHETICAL 100% AND 50% LOAD FACTOR CUSTOMERS
IMPACT OF PRICE SPIKES BETWEEN FY 00/99 AND FY 99/98 ON HYPOTHETICAL 100% AND 50% LOAD FACTOR CUSTOMERS
 | 100% Load Factor Customer |  | 50% Load Factor Customer
 | FY 00/99 | FY 99/98 | FY 00/99 | FY  99/98
Total [NAME] | 207601.291386 | 250690.6405200001 | 148575.1432422565 | 189432.1589750005
Average Bill | 23.63402679713115 | 28.61765302739727 | 33.82858452692544 | 43.24935136415537
% Increase FY 00/99 over FY99/98
IMPACT OF $250 PRICE CAP ON HYPOTHETICAL 100% AND 50%  LOAD FACTOR CUSTOMERS DURING FY 00/99
 | 100% Load Factor Customer |  | 50% Load Factor Customer
 | NO CAP | CAP | NO CAP | CAP
Total [NAME] | 207601.291386 | 205780.5442550001 | 148575.1432422565 | 146754.3961112565
Average Bill | 23.63402679713115 | 23.42674684141622 | 33.82858452692544 | 33.41402461549557
% Decrease in FY 00/99 With Price [NAME]
IMPACT OF $250 PRICE CAP ON HYPOTHETICAL 100% AND 50%  LOAD FACTOR CUSTOMERS DURING FY 99/98
 | 100% Load Factor Customer |  | 50% Load Factor Customer
 | NO CAP | CAP | NO CAP | CAP
Total [NAME] | 250690.6405200001 | 210364.2129790001 | 189432.1589750005 | 149105.7314339998
Average Bill | 28.61765302739727 | 24.0141795638128 | 43.24935136415537 | 34.04240443698625
% Decrease in FY 99/98 With Price [NAME]
FY 00/99: 8/16/1999-8/15/2000
FY 99/98: 8/16/1998-8/15/1999
Spreadsheet: 860429d1708528806-need-to-work-out-occupancy-rates-test-etaf5
Sheet: Sheet1

Occupancy | Woodland View | [NAME] | Silver Birch | HOME | MONTH |  |  | days Occupied | days in month | rooms | Available
 | 11 | 13 | 8 | [NAME] | 2024-02-01 00:00:00
Occupancy Rate | Rooms Occupied | Date Only | Week Commencing | Home | Month
 | 3 | 12/02/2024 | Monday 12/02/2024 | [NAME] | 2024-02-01 00:00:00
 | 4 | 25/09/2023 | Monday 25/09/2023 | Silver Birch | 2023-09-01 00:00:00
 | 2 | 01/11/2023 | Wednesday 01/11/2023 | Silver Birch | 2023-11-01 00:00:00
 | 4 | 13/10/2023 | Friday 13/10/2023 | Silver Birch | 2023-10-01 00:00:00
 | 2 | 16/09/2023 | Saturday 16/09/2023 | Silver Birch | 2023-09-01 00:00:00
 | 8 | 24/02/2023 | Friday 24/02/2023 | Silver Birch | 2023-02-01 00:00:00
 | 1 | 22/02/2023 | Wednesday 22/02/2023 | Silver Birch | 2023-02-01 00:00:00
 | 2 | 19/02/2023 | Sunday 19/02/2023 | Silver Birch | 2023-02-01 00:00:00
 | 2 | 20/12/2023 | Wednesday 20/12/2023 | Woodland View | 2023-12-01 00:00:00
 | 10 | 24/11/2023 | Friday 24/11/2023 | Woodland View | 2023-11-01 00:00:00
 | 2 | 20/11/2023 | Monday 20/11/2023 | Woodland View | 2023-11-01 00:00:00
 | 10 | 24/11/2023 | Friday 24/11/2023 | Woodland View | 2023-11-01 00:00:00
 | 2 | 21/11/2023 | Tuesday 21/11/2023 | Woodland View | 2023-11-01 00:00:00
 | 11 | 17/11/2023 | Friday 17/11/2023 | Woodland View | 2023-11-01 00:00:00
 | 2 | 13/11/2023 | Monday 13/11/2023 | Woodland View | 2023-11-01 00:00:00
 | 5 | 06/10/2023 | Friday [NAME] | Woodland View | 2023-10-01 00:00:00
 | So in B2, the formula is =IF(E4="Douglas Road", COUNTIF(D:D, D4), IF(E4="Silver Birch", COUNTIF(D:D, D4), IF(E4="Woodland View", COUNTIF(D:D, D4), 0)))
 | In C2 it is =RIGHT(D4,LEN(D4)-FIND(" ",D4))
 | In D2 it is =CHOOSE(WEEKDAY(H4), "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday") & " " & TEXT(H4, "dd/mm/yyyy") (H4 is part of my master file)
 | in E2 it is =IF(M4="Douglas Road", "Douglas Road", IF(M4="Silver Birch", "Silver Birch", IF(M4="Woodland View", "Woodland View", "Other"))) (AGAIN E2 is in my Master File)
 | In F2 it is =IF(H4<>"", TEXT(H4, "mmmm"), "") (H4 is in part ofmy master file)
Spreadsheet: 82007d1282079392-matching-rows-in-excel-and-finding-out-duplicate-rows-contacts_records-2-
Sheet: Sheet3

Company Name | First Name | Last Name | Job Title | Address 1 | Phone | Website
Desired Output
In sheet 3 i want those records (with complete row i.e. all fields) FROM sheet 2 that matches WITH records in sheet 1 (matching will be based on First Name, Last Name & CompanyName)
Second req: When we are matching rows of sheet2 with sheet 1,
if row from sheet2 matched with row from sheet 1, address, website and job title will be updated on bases of sheet1 with I think currently your formula is doing good
Company Name | First Name | Last Name | Job Title | Address 1 | Phone | Website
Spreadsheet: 852243d1702328879-power-query-get-dynamic-headers-from-another-table-and-vlookup-pq-headerstoexistingtable
Sheet: Sheet1

tblSales |  |  |  | tblCost |  |  |  | tblCategory |  |  |  | Desired Result
ID | Buyer | Sales Amount |  | ID | Cost Code | Amount |  | Category | Cost Code |  |  | ID | Buyer | Sales Amount | General | Mechanical | Inspection
[NAME] | [NAME] | 1000 |  | [NAME] | 1510.1000 | 128 |  | General | 1510.3000 |  |  | [NAME] | [NAME] | 1000
A102 | [NAME] | 1500 |  | [NAME] | 1510.1100 | 97 |  | General | 1510.3100 |  |  | A102 | [NAME] | 1500
A103 | [NAME] | 2500 |  | [NAME] | 1510.2000 | 747 |  | Mechanical | 1510.3200 |  |  | A103 | [NAME] | 2500
A104 | Doe | 3000 |  | [NAME] | 1510.2100 | 161 |  | Mechanical | 1510.3300 |  |  | A104 | Doe | 3000
 |  |  |  | [NAME] | 1510.3000 | 204 |  | Inspection | 1510.3400
 |  |  |  | [NAME] | 1510.3100 | 119 |  | Inspection | 1510.3500
 |  |  |  | [NAME] | 1510.3200 | 830
 |  |  |  | [NAME] | 1510.3300 | 178
 |  |  |  | [NAME] | 1510.3400 | 112
 |  |  |  | [NAME] | 1510.3500 | 597
 |  |  |  | A102 | 1510.1000 | 333
 |  |  |  | A102 | 1510.1100 | 169
 |  |  |  | A102 | 1510.2000 | 492
 |  |  |  | A102 | 1510.2100 | 282
 |  |  |  | A102 | 1510.3000 | 468
 |  |  |  | A102 | 1510.3100 | 383
 |  |  |  | A102 | 1510.3200 | 433
 |  |  |  | A102 | 1510.3300 | 261
 |  |  |  | A102 | 1510.3400 | 351
 |  |  |  | A102 | 1510.3500 | 201
 |  |  |  | A103 | 1510.1000 | 703
 |  |  |  | A103 | 1510.1100 | 592
 |  |  |  | A103 | 1510.2000 | 315
 |  |  |  | A103 | 1510.2100 | 660
 |  |  |  | A103 | 1510.3000 | 341
 |  |  |  | A103 | 1510.3100 | 352
 |  |  |  | A103 | 1510.3200 | 190
 |  |  |  | A103 | 1510.3300 | 756
 |  |  |  | A103 | 1510.3400 | 513
 |  |  |  | A103 | 1510.3500 | 85
 |  |  |  | [NAME] | 1510.1000 | 56
 |  |  |  | [NAME] | 1510.1100 | 212
 |  |  |  | [NAME] | 1510.2000 | 406
 |  |  |  | [NAME] | 1510.2100 | 72
 |  |  |  | [NAME] | 1510.3000 | 412
 |  |  |  | [NAME] | 1510.3100 | 497
 |  |  |  | [NAME] | 1510.3200 | 375
 |  |  |  | [NAME] | 1510.3300 | 381
 |  |  |  | [NAME] | 1510.3400 | 402
 |  |  |  | [NAME] | 1510.3500 | 399
 |  |  |  | A102 | 1510.1000 | 282
 |  |  |  | A102 | 1510.1100 | 106
 |  |  |  | A102 | 1510.2000 | 447
 |  |  |  | A102 | 1510.2100 | 497
 |  |  |  | A102 | 1510.3000 | 37
 |  |  |  | A102 | 1510.3100 | 174
 |  |  |  | A102 | 1510.3200 | 145
 |  |  |  | A102 | 1510.3300 | 49
 |  |  |  | A102 | 1510.3400 | 30
 |  |  |  | A102 | 1510.3500 | 329
 |  |  |  | A103 | 1510.1000 | 196
 |  |  |  | A103 | 1510.1100 | 218
 |  |  |  | A103 | 1510.2000 | 52
 |  |  |  | A103 | 1510.2100 | 150
 |  |  |  | A103 | 1510.3000 | 247
 |  |  |  | A103 | 1510.3100 | 399
 |  |  |  | A103 | 1510.3200 | 484
 |  |  |  | A103 | 1510.3300 | 317
 |  |  |  | A103 | 1510.3400 | 197
 |  |  |  | A103 | 1510.3500 | 465
Spreadsheet: 93212d1292816437-selecting-particular-text-from-sentence-murarihyd_selecting_particular_text-1-
Sheet: Sheet2

TEAM
TL Wk 1 | TL Wk 2 | TL Wk 3 | TL Wk 4 | TL Wk 5 | TL Wk 6
GEORGE | ARRY | FERNANDES | GOVINDAN | MADHU | SUB | 12 | 2152 | 2536
MUTHU | MANU | MADHAN | JOSEPHIN | DONI | MUNIANAN | 2356 | 2312 | 458 | 2858
LARENCE | MEGAN | JASMINE | FERSTLY | HUDSON | PETERSON | 4582 | 5852 | 7585 | 2548
Spreadsheet: 966f4e45-99ba-4591-b6bd-a0131333b642
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5208 | 30439 | Joleen | Hakker B1 | NED | 0 | 00:34:12 | 00:03:15 | 01:17:00 | 00:02:19 | 00:43:56 | 1 | 02:40:43
5208 | 30795 | Sara | Butler | GBR | 0 | 00:28:38 | 00:01:29 | 01:27:04 | 00:01:43 | 00:46:08 | 2 | 02:45:02
Spreadsheet: 755184d1636713816-how-to-averageifs-last-n-values-based-on-date-and-product-avg-example-data
Sheet: Sheet1

Product | Week | [NAME]
BC0002 | 10/10/2021 | 21000 |  | BC0002
BC0006 | 03/10/2021 | 90000 |  | BC0006
BC0006 | 17/10/2021 | 1000 |  | BC0022
BC0006 | 31/10/2021 | 0 |  | BC0086
BC0006 | 07/11/2021 | 82000 |  | BC0109
BC0022 | 03/10/2021 | 81000
BC0022 | 10/10/2021 | 80000
BC0022 | 17/10/2021 | 100000
BC0022 | 24/10/2021 | 59000
BC0022 | 31/10/2021 | 81000
BC0022 | 07/11/2021 | 33000
BC0086 | 03/10/2021 | 82090
BC0086 | 07/11/2021 | 57600
BC0109 | 03/10/2021 | 111725
BC0109 | 10/10/2021 | 105000
BC0109 | 17/10/2021 | 185950
BC0109 | 24/10/2021 | 158975
BC0109 | 31/10/2021 | 161325
BC0109 | 07/11/2021 | 219000
Spreadsheet: 0406beb6-b986-42b1-99d1-2f2dab134c09
Sheet: Sheet1

Supplementary table 3: Differential expression results for microarray compared to qRT-PCR
 | CG9897 |  |  | CG18628 |  |  | CG17239
 | Microarray | qRT-PCR |  | Microarray | qRT-PCR |  | Microarray | qRT-PCR
ST3 - STV | -0.147899280041841 | -0.0401437305668475 |  | -1.56882880225895 | -3.862170791595957 |  | 0.4982448211791 | 3.63
ST6 - STV | -0.0722198005456427 | 0.2987941291564296 |  | -0.482840196247771 | -0.1173885045177663 |  | 0.441565965238294 | 3.06
SR3 - SRV | 0.75294062477854 | -1.151143067792473 |  | 0.0693969339163854 | 0.8548190605953181 |  | 1.93846684958683 | 2.345258860238503
SR6 - SRV | -2.85836145966387 | -1.398141097695721 |  | 0.033534484501839 | -0.2567448616903913 |  | -1.65158213892671 | 1.452321310548665
STV - SRV | 3.85206986233282 | 3.745772832771427 |  | -3.72202258474968 | -3.424948251650165 |  | 2.29183658892735 | 4.97
ST3 - SR3 | 3.12420331069553 | 4.856772169997052 |  | -4.53998858562548 | -8.14193810384144 |  | 0.742620250598518 | 6.270700485676866
ST6 - SR6 | 6.73733380963542 | 5.442708059623577 |  | -3.39673817311065 | -3.28559189447754 |  | 4.915250519291 | 6.593388917425916
The resulting log2 fold change for differential gene expression calculated using microarray and RT-PCR data. Gene expression data from RT-PCR was normalized using rp49 prior to the calculation of fold change. FC is reported as relative to the first category in the listed comparison, for example in the comparison of ST3 - STV, [NAME] is down-regulated in ST3 relative to STV.  ST = spermathecae, SR = Seminal receptacle, V = virgin, 3 = 3 hours post-mating, 6 = 6 hours post-mating.
Spreadsheet: 537476d1505120954-get-content-or-numbers-from-a-list-according-date-book
Sheet: Φύλλο1

 |  |  |  | dates | number | name |  |  |  | here I insert a date from list dates.
 |  |  |  | 2017-01-01 00:00:00 | 345 | [NAME] |  |  |  | 2017-01-02 00:00:00
 |  |  |  | 2017-01-01 00:00:00 | 46 | george
 |  |  |  | 2017-01-01 00:00:00 | 235 | [NAME]
 |  |  |  | 2017-01-01 00:00:00 | 2345 | [NAME] |  |  |  | and here I need all content according K10 date
 |  |  |  | 2017-01-01 00:00:00 | 45 | mairy |  |  |  | number | name
 |  |  |  | 2017-01-02 00:00:00 | 345 | [NAME]
 |  |  |  | 2017-01-02 00:00:00 | 46 | george
 |  |  |  | 2017-01-02 00:00:00 | 235 | [NAME]
 |  |  |  | 2017-01-03 00:00:00 | 345 | [NAME]
 |  |  |  | 2017-01-03 00:00:00 | 46 | george
 |  |  |  | 2017-01-03 00:00:00 | 235 | [NAME]
 |  |  |  | 2017-01-03 00:00:00 | 2345 | [NAME]
 |  |  |  | 2017-01-03 00:00:00 | 45 | mairy
 |  |  |  | 2017-01-04 00:00:00 | 345 | [NAME]
 |  |  |  | 2017-01-04 00:00:00 | 46 | george
 |  |  |  | 2017-01-04 00:00:00 | 235 | [NAME]
 |  |  |  | 2017-01-04 00:00:00 | 2345 | [NAME]
 |  |  |  | 2017-01-04 00:00:00 | 45 | mairy
 |  |  |  | 2017-01-05 00:00:00 | 345 | [NAME]
 |  |  |  | 2017-01-05 00:00:00 | 46 | george
 |  |  |  | 2017-01-05 00:00:00 | 235 | [NAME]
 |  |  |  | 2017-01-05 00:00:00 | 2345 | [NAME]
 |  |  |  | 2017-01-05 00:00:00 | 45 | mairy
Spreadsheet: 455609d1460431447-how-do-i-set-up-my-recipe-so-that-my-ingredients-and-costs-transfer-over-doggie-delights-inventory-and-sales
Sheet: Peanut Butter Bites

 | Recipe
 | Number of Bags |  |  | Cost |  |  |  | Selling Price
 |  |  |  | Cost per Bag |  |  |  | Food Cost
 |  |  |  | Cost per Recipe |  |  |  | Non-Food Costs
 |  |  |  |  |  |  |  | Total Cost Per Bag
 | Ingredients | Quantity |  | Measurement | Cost |  |  | Selling Price |  | 4
 | Baking Powder | 1 |  | tsp |  |  |  | Total Profit
 |  |  |  | Total
 | Directions
Spreadsheet: c1d16a91-8625-4dd3-8f21-947253a1ea64
Sheet: Sheet1

First Name | Last Name | Title | Organization | [NAME] | Phone | Nominated By
[NAME] | [NAME] | Superintendent | Derby - USD 260 | [EMAIL] | [PHONE] | [NAME]
Destry | [NAME] | Superintendent | Pittsburg - USD 250 | [EMAIL] | [PHONE] | [NAME]
[NAME] | Dakotas | Retired Art Teacher |  | [EMAIL] | [PHONE] | [NAME]
[NAME] | Berblinger | Principal | Buhler High School | [EMAIL] | [PHONE] | [NAME]
[NAME] | Hutton | Library Media Specialist | Lansing High School | [EMAIL] | [PHONE] | [NAME]
Duke | Palmer | Retired Principal |  | [EMAIL] | [PHONE] | [NAME]
Brent | Evans | PE Teacher | Liberal - USD 480 | [EMAIL] | [PHONE] | [NAME]
[NAME] | Dunn | [NAME] of [NAME]. | Newman University | [EMAIL] | [PHONE] X 2251 | [NAME]
Shelby | Muha | Teacher | Riley County High School - USD 378 | [EMAIL] | [PHONE] | [NAME]
[NAME] | Colvin | Middle School/Union Leader | Cherokee | [EMAIL] | [PHONE] | KEEP Pilot 1
Scott | Kickhaefer | Teacher (art) | Topeka | [NAME] | [PHONE] | KEEP Pilot 1
Beverly | Mortimer | Superintendent | Concordia - USD 333 | [EMAIL] | [PHONE] | KEEP Pilot 1
Rose | [NAME] | Superintendent | [NAME] | [EMAIL] | [PHONE] | KEEP Pilot 1
Kelly | Gentry | Curriculum/Instruction | Council Grove - USD 417 | [EMAIL] | [PHONE] | KEEP Pilot 1
[NAME] | Pingel | Special Education Coop. Director | Concordia - USD 333 | [EMAIL] | [PHONE] | KEEP Pilot 1
[NAME] | Super | Teacher | Maize High School - USD 266 | [EMAIL] | [PHONE] | KEEP Pilot 2
Doug | [NAME] | Teacher | [NAME] | [EMAIL] | [PHONE] | KEEP Pilot 2
Sheryl | Townson | Teacher | [NAME] 394 | [EMAIL] | [PHONE] | KEEP Pilot 2
Eileen | [NAME] | Teacher | Geary County - USD 475 | EileenHackley2usd475.org | [PHONE] | KEEP Pilot 2
[NAME] | [NAME] | Director, QPA | Olathe - USD 233 | [EMAIL] | [PHONE] | [NAME]
[NAME] | Wiscombe | Assistant Director of Academic Affairs | Kansas State Board of Regents (KSBOR) | [EMAIL] | [PHONE] | [NAME]
[NAME] | Jordan | Director, Leadership Services | KASB | [EMAIL] | [PHONE] | [NAME]
Dayna | Richardson | Chair-Elect | KLFA
[NAME] | Dunlap | Director of Instructional Advocacy | [NAME] | [EMAIL] | [PHONE] | [NAME]
[NAME] | [NAME] | Principal | [NAME] | [EMAIL] | [PHONE] | [NAME] (KAESP)
[NAME] | Heatherly | Principal | Girard Middle School - USD 248 | [EMAIL] | [PHONE] | [NAME] (KAMSA)
[NAME] | Hall | Superintendent | Salina - USD 305 | [EMAIL] | [PHONE] | [NAME] (KSSA)
[NAME] | [NAME] | Director | ANW Special Education Interlocal 603 | [EMAIL] | [PHONE] | [NAME] (KASEA)
[NAME] | Vinduska | Principal | Seaman HS - USD 345 | [EMAIL] | [PHONE] | [NAME] (KASSP)
[NAME] | Everson | Associate Professor, Educational Leadership & H.E. | St. Louis University | [EMAIL] | [PHONE] | Facilitator
Scott | Myers | Director, Teacher Education & Licensure | KSDE | [EMAIL] | [PHONE]
[NAME] | [NAME] | Commissioner of Education | KSDE | [EMAIL]
Spreadsheet: 883075d1731565537-partial-matching-of-two-cells-nooredein-partial-matching-1-365-aligw
Sheet: Sheet1

 |  | A | B |  |  | Month A | Year A | Month B | Year B
 |  | 2023-04-11 00:00:00 | 7617-11-23
 |  | 21/10/2023 | 7618-10-23
 |  | 27/4/2023 | 916-04-23
 |  | 27/4/2023 | 915-04-23
 |  | 2024-06-04 00:00:00 | 5541-04-24
Spreadsheet: 889972d1741061480-interest-calculation-based-on-fifo-clearing-interest-cal-based-on-fifo-clearing-sharad2025-
Sheet: Interest Cal

Posting Date | Customer | [NAME] | Invoice No. | Amount (Rs.) | Due Date | Desired Result Interest Amount | Remarks
2025-01-01 00:00:00 | A | RV | 101 | 100 | 2025-01-03 00:00:00 |  | Rs. 40 Adjusted against FIFO basis Against RV 101 with 1 day delay & Rs. 60 Adjusted against FIFO basis against RV 101 & balance Re 1 out of Rs. 61 payment adjusted against Next RV 102 Rs. 200
2025-01-02 00:00:00 | A | RV | 102 | 200 | 2025-01-04 00:00:00 |  | Re 1 balance out of Rs 61 payment adjusted against Rs. 200 RV 102 and next out of Rs. 300 payment only 199 rupees to be adjusted based on FIFO basis.
2025-01-04 00:00:00 | A | DZ | - | -40 | 2025-01-04 00:00:00 |  | Only in front of RV/Billing interest need to be caculated.
2025-01-05 00:00:00 | A | DZ | - | -61
2025-01-06 00:00:00 | A | DZ | - | -300
2025-01-03 00:00:00 | B | RV | 201 | 150 | 2025-01-05 00:00:00 |  | Customer B Rs. 100 received adjusted against RV 201 based on FIFO with 1 day delay & balance Rs. 50 remains outstanding till today calculated accordingly.
2025-01-06 00:00:00 | B | DG | - | -100 | 2025-01-06 00:00:00 |  | Only in front of RV/Billing interest need to be caculated.
 | B | DG | - | -100
Note
1. Positive Balance is Billing to Customer. (Denoted via RV)
2. Negative Balance is Amount/Payment received from Customer. (Denoted via DZ or [NAME] or TE)
3. Billing (RV) sorted based on Due Date (If 2nd RV due date was before 1st RV due date then RV 2 adjusted against first payment received from customer.
4. Payment received from customer sorted based on posting date.
5. Payment received from Customer is not tagged with RV, they just send the payment and based on FIFO and Due date of RV it got adjusted by us.
6. Interest Rate 10% considered for interest caculation.
7. Payment adjustment done on customer wise only means Customer A payment adjusted against Customer A billing only.
8. If partial payment received from customer then based on FIFO first RV settled first and till exhaust of first RV or balance left after first RV adjustment, secound RV comes into picture and balance left if any from 1st RV excess payment adjusted against secound RV, like/eg Re 1 excess received on dated 05 Jan 2025 above to be adjusted agaisnt next RV.
Spreadsheet: 214408d1360895477-how-to-filter-data-based-on-a-column-criteria-in-another-sheet-example-excel
Sheet: Desired Result

Name | Class | Pay date | Pay rate | Hours
[NAME], [NAME] | 1 | 2011-01-01 00:00:00 | 5 | 1
Lopez, Marissa | 2 | 2011-01-01 00:00:00 | 6 | 1
[NAME], [NAME] | 1 | 2011-02-01 00:00:00 | 5 | 1
Lopez, Marissa | 2 | 2011-02-01 00:00:00 | 6 | 1