tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 885647d1735461208-create-multiple-vertical-lines-programmatically-from-single-cell-mcmxd-sample-workbook-spill-365-aligw
Sheet: Export

Subject | Start date | Start time | End Date | End Time |  |  | Start date | Start time | End date | End time
Days (Wed off) | 2025-02-03 00:00:00 | 07:30:00 | 2023-11-13 00:00:00 | 18:00:00 |  | Days (Wed off) | 2024-02-03 00:00:00 | 7.30 | 2024-02-04 00:00:00 | 17.30
Days (Wed off) | 2025-02-04 00:00:00 | 07:30:00 | 2023-11-13 00:00:00 | 18:00:00 |  | Days (Wed off) | 2024-02-04 00:00:00 | 7.30 | 2024-02-05 00:00:00 | 17.30
Days (Wed off) |  |  |  |  |  | Days (Wed off)
Days (Wed off) | 2025-02-06 00:00:00 | 07:30:00 | 2023-11-13 00:00:00 | 18:00:00 |  | Days (Wed off) | 2024-02-06 00:00:00 | 7.30 | 2024-02-07 00:00:00 | 17.30
Days (Wed off) | 2025-02-07 00:00:00 | 07:30:00 | 2023-11-13 00:00:00 | 18:00:00 |  | Days (Wed off) | 2024-02-07 00:00:00 | 7.30 | 2024-02-08 00:00:00 | 17.30
Days (Wed off) | 2025-02-08 00:00:00 | 07:30:00 | 2023-11-13 00:00:00 | 18:00:00 |  | Days (Wed off)
Days (Wed off) | 2025-02-09 00:00:00 | 07:30:00 | 2023-11-13 00:00:00 | 18:00:00 |  | Days (Wed off)
Days (Fri Off) | 2025-02-10 00:00:00 | 08:30:00 | 2023-11-14 00:00:00 | 19:00:00 |  | Days ([NAME] off) | 2024-02-10 00:00:00 | 7.30 | 2024-02-11 00:00:00 | 17.30
Days (Fri Off) | 2025-02-11 00:00:00 | 09:30:00 | 2023-11-15 00:00:00 | 20:00:00 |  | Days ([NAME] off) | 2024-02-11 00:00:00 | 7.30 | 2024-02-12 00:00:00 | 17.30
Days (Fri Off) | 2025-02-12 00:00:00 | 10:30:00 | 2023-11-16 00:00:00 | 21:00:00 |  | Days ([NAME] off) | 2024-02-12 00:00:00 | 7.30 | 2024-02-13 00:00:00 | 17.30
Days (Fri Off) | 2025-02-13 00:00:00 | 11:30:00 | 2023-11-17 00:00:00 | 22:00:00 |  | Days ([NAME] off) | 2024-02-13 00:00:00 | 7.30 | 2024-02-14 00:00:00 | 17.30
Days (Fri Off) |  |  |  |  |  | Days ([NAME] off)
Days (Fri Off) | 2025-02-15 00:00:00 | 13:30:00 | 2023-11-19 00:00:00 | 1900-01-01 00:00:00 |  | Days ([NAME] off)
Days (Fri Off) | 2025-02-16 00:00:00 | 14:30:00 | 2023-11-20 00:00:00 | 1900-01-01 01:00:00 |  | Days ([NAME] off)
 |  |  |  |  |  | RLEAVE
 |  |  |  |  |  | RLEAVE
 |  |  |  |  |  | RLEAVE
 |  |  |  |  |  | RLEAVE
 |  |  |  |  |  | RLEAVE
 |  |  |  |  |  | RLEAVE
 |  |  |  |  |  | RLEAVE
 |  |  |  |  |  | RLEAVE
 |  |  |  |  |  | RLEAVE
 |  |  |  |  |  | RLEAVE
 |  |  |  |  |  | RLEAVE
 |  |  |  |  |  | RLEAVE
 |  |  |  |  |  | RLEAVE
 |  |  |  |  |  | RLEAVE
Spreadsheet: 437390d1451321187-re-adjusting-rolling-daily-averages-stuck-master-31-day-month
Sheet: Monthly P&L

Weekly Flash P&L |  |  |  |  |  | Month Ending
Only input information in YELLOW cells.
 | Dollars |  |  | %
Sales (Net + Coupons, Discounts) |  |  |  | 1 |  | VCD Totals
Coupons
Discounts
Promos
Fundraisers
Net Sales |  |  |  | 1
Cost of Sales |  |  |  |  |  | Goals |  | Actual | [NAME]
Food Cost |  |  |  | 0 |  | [NAME] | 0.28
Paper Cost |  | Count | Count | 0 |  | Crew Labor % | 0.205
Total Cost of Sales |  |  |  | 0 |  | IOH | 0
Inventory Variance |  | 0 | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0
Labor Costs |  |  |  |  |  |  | 0
[NAME] |  | Crew Hours |  |  |  |  | 0
Manager [NAME] |  | Manager [NAME] |  |  |  |  | 0
 |  |  |  |  |  | VCD | 0.04
Total Payroll |  | Total Hours
 |  |  |  |  |  | LY SALES
Notes: |  |  |  |  |  | Current Sales
 |  |  |  |  |  | Actual Food
 |  |  |  |  |  | Ideal Food
 |  |  |  |  |  |  |  | % of Net Sales
 |  |  |  |  |  | Over/Short
 |  |  |  |  |  | [NAME]
Spreadsheet: 679320d1590332203-pull-in-top-products-but-not-duplicates-2020-05-24-oeldere-samvince-pt-679317d1590331272-pull-in-top-products-but-not-duplicates-top
Sheet: Blad1

Rijlabels | Som van ROI
X002302CYE | 0.2435714285714286
X002XFX3XQ | 6.34864300626305
X008VMXV26 | 0.2616372391653289
X008XL2ZQW | 1.608235294117647
X00GMM2ZAU | 0.5705263157894738
X00U1ZJUXM | 0.2819106019041471
X01608LX8Y | 0.1317647058823529
X0162AOLGA | 0.6756756756756757
X01872KIGE | 0.4737406216505896
X01C6O62LI | 0.764
X01I8N133S | 0.6793296089385473
X01IM299FG | 0.09357142857142849
[NAME] | 2.2725
X06XP8FLY9 | 0.7174348697394793
X071J11CXT | 0.3764853033145715
X072KHC72S | 0.36
X0776GM3PC | 0.03156708004509596
X078M3FY2T | 0.165938864628821
X07G9P2VVF | 1.808
X07H2LPFNV | 0.1658291457286433
X07M6NS9QX | 0.8841379310344832
X07MNZV828 | 2.19125
X07PJCF8JP | 0.3823088455772115
X07PM8V3VY | 1.818333333333333
X07YX9XMHC | 0.7873684210526316
Eindtotaal | 24.09375972098394
Spreadsheet: 869551d1716163655-formula-to-find-vlookup-or-hlookup-for-values-report-formula
Sheet: AFTER (1)

REPORT FOR MONTH OF |  |  |  |  |  |  |  | January | January 1-31 | January 31 |  | 31 |  | 1
 |  |  |  |  | Monthly report |  |  | February | February 1-28 | February 28 |  | 28 |  | 1 |  |  | LEGEND:
MONTH | YEAR |  |  |  | Start of Project |  |  | March | March 1-31 | March 31 |  | 31 |  | 1
August | 2024 |  |  |  | End of Project |  |  | April | April 1-30 | April 30 |  | 30 |  | 1 |  |  |  | Data needed for input
 |  |  |  |  |  |  |  | May | May 1-31 | May 31 |  | 31 |  | 1 |  |  |  | Generated Data
 | DATE |  |  |  |  |  |  | June | June 1-30 | June 30 |  | 30 |  | 1 |  |  |  | Data source
Monthly report |  |  |  |  |  |  |  | July | July 1-31 | July 31 |  | 31 |  | 1
 |  |  |  |  |  |  |  | August | August 1-31 | August 31 |  | 31 |  | 1
 |  |  |  |  |  |  |  | September | September 1-30 | September 30 |  | 30 |  | 1
 |  |  |  |  |  |  |  | October | October 1-31 | October 31 |  | 31 |  | 1
Report Date Header 1 | August 1-31 |  |  |  |  |  |  | November | November 1-30 | November 30 |  | 30 |  | 1
Report Date Header 2 | August 31 |  |  |  |  |  |  | December | December 1-31 | December 31 |  | 31 |  | 1
 |  | Col 1 | Col 2
 | Monthly report
 | Start of Project
 | End of Project
Spreadsheet: 01339ba7-b6ed-4f35-914c-80c4cc818f58
Sheet: Title Sheet

PROJECT'S COST ESTIMATE
TITLE SHEET
 |  |  |  |  | FILE NO:
PROJECT NAME:
OWNER'S NAME:
ADDRESS:
PHONE #: |  |  | (            )
FAX #: |  |  | (            )
E-MAIL ADDRESS:
ENGINEERING FIRM:
ADDRESS:
CONTACT PERSON:
PHONE #: |  |  | (            )
FAX #: |  |  | (            )
E-MAIL ADDRESS:
FOR SEAL
 |  |  | ENGINEER'S SIGNATURE |  |  |  | DATE
 |  |  | PRINT NAME |  | RCE |  | EXP.
Grading Plan Number:
No. of Sheets:
 |  |  |  |  |  |  |  |  | Grading Plan Total Estimate w/ 15% Contingency
Erosion Control Plan Number:
No. of Sheets:
 |  |  |  |  |  |  |  |  | Erosion Control Estimate w/ 15% Contingency
Improvement Plan Number:
No. of Sheets:
 |  |  |  |  |  |  |  |  | Improvement Plan Estimate w/ 15% Contingency
Earthwork and Drainage
(From Grading Plan Cost Estimate ) |  |  |  |  |  |  |  |  | Total From Sections 1 & 2
APPROVED BY |  |  |  | DATE
Spreadsheet: 494806d1482763607-how-to-format-an-entire-row-based-on-one-cells-value-devices-sample
Sheet: Planilha1

Id | Owner | Device | MAC | IP | Visitor? | Active? | Added
2 | Leo | MainDesktop | 91-3B-A4-30-F4-B6 | 192.168.1.2 | No | Yes | 2012-08-23 00:00:00
3 | Leo | ToshNoteEthernet | 01-33-8B-A3-41-64 | 192.168.1.3 | No | No | 2009-06-26 00:00:00
4 | Leo | ToshNoteWireless | 01-32-FA-A0-D8-C4 | 192.168.1.4 | No | Yes | 2009-06-26 00:00:00
5 | [NAME] | AsusNoteEthernet | 01-34-8C-88-27-E7 | 192.168.1.5 | No | No | 2009-06-27 00:00:00
6 | [NAME] | AsusNoteWireless | 01-32-C3-8D-3F-69 | 192.168.1.6 | No | Yes | 2009-06-27 00:00:00
7 | [NAME] | iPad | 2C-AB-A7-13-59-37 | No reservation | Yes | Yes | 2011-11-01 00:00:00
8 | Leo | Z3 | 44-74-6C-EF-8C-43 | 192.168.1.8 | No | No | 2016-07-05 00:00:00
9 | [NAME] | Z3 | 42-E2-6C-FE-8B-F1 | 192.168.1.9 | No | Yes | 2015-03-01 00:00:00
Spreadsheet: 57223d1257352532-automatic-updates-linked-sources-not-updating-testdata
Sheet: data

Entry Date | Supervisor | Banker | Product | SSN | Call Type | Agent Combiner
 |  | Banker1 | Mortgage |  | [NAME]
 |  | Banker2 | Mortgage |  | [NAME]
 |  | Banker2 | Mortgage |  | [NAME]
 |  | Banker3 | Mortgage |  | [NAME]
 |  | Banker3 | Mortgage |  | [NAME]
 |  | Banker3 | Mortgage |  | [NAME]
 |  | Banker1 | Mortgage |  | [NAME]
 |  | Banker2 | Mortgage |  | [NAME]
 |  | Banker2 | Mortgage |  | [NAME]
 |  | Banker3 | Mortgage |  | [NAME]
 |  | Banker3 | Mortgage |  | [NAME]
 |  | Banker3 | Mortgage |  | [NAME]
 |  | Banker1 | Mortgage |  | [NAME]
 |  | Banker2 | Mortgage |  | [NAME]
 |  | Banker2 | Mortgage |  | [NAME]
 |  | Banker3 | Mortgage |  | [NAME]
Spreadsheet: 214191d1360841658-propagation-of-values-in-a-spreadsheet-example
Sheet: Feuil1

1 | 500 |  | 500 | 400 | 400 | 300 | 300 | 300 | 200 | 200 | 200 | 200 | 100 | 100 | 100 | 100 | 100 | 90 | 90 | 90 | 90 | 90 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70
2 | 400
3 | 300
4 | 200 | Will propagate
5 | 100 | this way
5 | 90
10 | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 HORIZONTAL CELLS
10 | 70
5 | 500 |  | 500 | 500 | 500 | 500 | 500 | 400 | 400 | 400 | 400 | 400 | 300 | 300 | 300 | 300 | 300 | 200 | 200 | 200 | 200 | 200 | 100 | 100 | 100 | 100 | 100 | 90 | 90 | 90 | 90 | 90 | 80 | 80 | 80 | 80 | 80 | 70 | 70 | 70 | 70 | 70
5 | 400
5 | 300
5 | 200 | Will propagate
5 | 100 | this way
5 | 90
5 | 80
5 | 70
Spreadsheet: 801093d1666081624-auto-populating-a-reporting-form-test-form
Sheet: Sheet3

 | Block: | 1 |  |  |  | Block area in m2: | 5000
 | Product | Item code | Price | Product size | Desired rate /m2 | Req amount | Value
 | Product 1 |  |  | 5000 | 5
 | Product 2 |  |  | 10000 | 100
 | Product 3 |  |  | 250 | 7
 | Product 4 |  |  | 1000 | 1
 | Block: | 2 |  |  |  | Block area in m2: | 3000
 | Product | Item code | Price | Product size | Desired rate /m2 | Req amount | Value
 | Product 4 |  |  | 1000 | 5
 | Product 5 |  |  | 50 | 7
 | Block: | 3 |  |  |  | Block area in m2: | 2500
 | Product | Item code | Price | Product size | Desired rate /m2 | Req amount | Value
 | Product 2 |  |  | 10000 | 2
 | Product 3 |  |  | 250 | 3
 | Product 4 |  |  | 1000 | 5
 | Product 5 |  |  | 50 | 25
 | Total | Item code | Price | Product size | x | Total
 | Product 1 |  |  | 5000 |  | 5
 | Product 2 |  |  | 10000 |  | 51
 | Product 3 |  |  | 250 |  | 170
 | Product 4 |  |  | 1000 |  | 33
 | Product 5 |  |  | 50 |  | 1670
Spreadsheet: 779273d1651673209-if-row-is-hidden-than-the-hidden-row-is-not-referenced-cell-reference
Sheet: Sheet1

Header 1 | [NAME]
100-12 | 100000
120-15 | 23000
152-418 | 255555
200-56 | 6000000
300-12 | 150000
Total
 |  |  |  |  |  | Header 1 | [NAME]
Spreadsheet: 411e1d74-702d-4e16-a300-df6dc6f3d2db
Sheet: Form

 | Division of School Finance |  | S C H O O L   T A X   A B A T E M E N T                                                                        S I X - M O N T H   S U P P L E M E N T A L   R E P O R T |  |  |  | ED-02124-19
 | 1500 Highway 36 West |  |  |  |  |  | DUE:  [NAME]
 | Roseville, MN  55113-4266
GENERAL INFORMATION AND INSTRUCTIONS: Please read the INSTRUCTIONS FOR COMPLETION on the Instructions tab before completing this report. |  |  |  |  |  | THIS REPORT APPLIES TO: January 1, 2012 - June 30, 2012
NOTE OR COMMENTS BY PREPARER:
I D E N T I F I C A T I O N   A N D   G E N E R A L   I N F O R M A T I O N
District Number and Name |  | County Name | County Auditor's Office Contact Person |  | Telephone Number |  | Date
P A R T   A :   N E T   T A X   C A P A C I T Y
COUNTY NAME | COUNTY NUMBER | (1) | (2) | (3) | (4) | (5) | (6)
 |  | NET TAX CAPACITY ABATED | SCHOOL TAXES ABATED | NET TAX CAPACITY ADDED | SCHOOL TAXES ADDED | NET CHANGE IN NET TAX CAPACITY | NET CHANGES IN SCHOOL TAXES
 |  | (Dollars Only) | (Dollars & Cents) | (Dollars Only) | (Dollars & Cents) | (Columns 1 + 3) | (Columns 2 + 4)
 |  | Enter Negative Amount | Enter Negative Amount
P A R T   B :   R E F E R E N D U M   M A R K E T   V A L U E
COUNTY NAME | COUNTY NUMBER | (1) | (2) | (3) | (4) | (5) | (6)
 |  | REF MKT VALUE ABATED | SCHOOL TAXES ABATED | REF MKT VALUE ADDED | SCHOOL TAXES ADDED | NET CHANGE IN REF MKT VALUE | NET CHANGES IN SCHOOL TAXES
 |  | (Dollars Only) | (Dollars & Cents) | (Dollars Only) | (Dollars & Cents) | (Columns 1 + 3) | (Columns 2 + 4)
 |  | Enter Negative Amount | Enter Negative Amount
TOTAL ALL COUNTIES (Part A and B)
Spreadsheet: 039f8290-a27a-4b0e-be13-e6e79d4b8ce3
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | Table S6. Conservation analysis of the novel miRNAs in seven plant species.
 | Name | miRNA sequence | Location | NSN | SSN | Ratio | Conservation
 | miR1513b | AAAGCCATGACTTACACACGC | 5' |  | 475 |  | gma
 | miR1520s | TTGACCAATCAAAACATGACA | 3' | 35 |  |  | gma
 | miR4357b,c | CAGTCGTGTGATTGTACGGTT | 3' | 22 |  |  | gma
 | miR4416d | ACGGGTCGCTCTCACCTGGAG | 3' | 12 | 79 | 6.58 | gma
 | miR4416c | ATACGGGTCGCTCTCACCTAGG | 3' | 637 | 1881 | 2.95 | gma
 | [NAME] | GCTGGATGTCTTTGAAGGAAC | 3' | 53 |  |  | gma
 | miR1507d | AGAGGTGTTTGGGATGAGAG | 5' | 1068 | 647 | 0.61 | gma
 | miR4405b | ATATTTTCTAAGACGGTTATT | 3' | 68 | 42 | 0.62 | gma
 | miR862d | [NAME] | 3' | 51 |  |  | gma
 | miR5037e | AACCCTCAAAGGCTTCCACTAC | 5' | 31 | 14 | 0.45 | gma,mtr
 | miR398d | TGTGTTCTCAGGTCGCCCCTG | 3' |  | 59 |  | gma,mtr,ath,osa,vvi,ptc
 | miR156aa | CTGACAGAAGATAGAGAGCAC | 5' | 20706 | 34689 | 1.68 | gma,mtr,ath,osa,vvi,ptc,[NAME]
 | miR156ab-ag | ACAGAAGAGAGTGAGCACAC | 5' | 376 | 328 | 0.87 | gma,mtr,ath,osa,vvi,ptc,[NAME]
 | miR164l | TGGAGAAGCAGGGCACATGCT | 5' | 25 | 36 | 1.44 | gma,mtr,ath,osa,vvi,ptc,[NAME]
 | miR167k | TGAAGCTGCCAGCCTGATCTT | 5' |  | 343 |  | gma,mtr,ath,osa,vvi,ptc,[NAME]
 | miR167i | TGAAGCTGCCAGCCTGATCTTA | 5' | 84 |  |  | gma,mtr,ath,osa,vvi,ptc,[NAME]
 | miR393i | TTCCAAAGGGATCGCATTGATC | 5' | 263 | 234 | 0.89 | gma,mtr,ath,osa,vvi,ptc,[NAME]
 | miR396l | ATTCAAGATAGCTGTGGAAAA | 3' | 27 | 29 | 1.07 | gma,mtr,ath,osa,vvi,ptc,[NAME]
 | miR166v,w | TCGGACCAGGCTTCATTCCTC | 3' | 100 | 88 | 0.88 | gma,mtr,pvu,ath,osa,vvi,ptc,[NAME]
 | miR482f | GGAATGGGCTGATTGGGAAGT | 5' | 1497 | 2228 | 1.49 | gma,pvu
 | miR399i | CGCCAAAGAAGATTTGCCCGG | 3' | 9 | 41 | 4.56 | mtr,pvu,ath,osa,vvi,ptc,[NAME]
 | miR399j,k | TGCCAAAGGAGAGCTGCCCTG | 3' | 376 | 1236 | 3.29 | mtr,pvu,ath,osa,vvi,ptc,[NAME]
 | miR399e,f | TGCCAAAGGAGATTTGCCCTG | 3' |  | 163 |  | mtr,pvu,ath,osa,vvi,ptc,[NAME]
 | miR399n,o | TGCCAAAGGAGATTTGCCCT | 3' | 56 |  |  | mtr,pvu,ath,osa,vvi,ptc,[NAME]
 | [NAME] | GCTGGGAACAGGCAGAGCACG | 5' | 46 |  |  | ahy
 | [NAME] | TAATCTGCATCCTGAGGTTT | 5' |  | 187 |  | ath
 | miR2111h,i,g | TAATCTGCATCCTGAGGTTTA | 5' | 82 |  |  | ath
 | miR397c | ATTGAGTGCAGCGTTGATGAA | 5' | 862 | 854 | 0.99 | ath,osa,vvi,ptc
Spreadsheet: 864280d1711499596-find-the-most-recent-buy-value-find_buy_price_example
Sheet: Sheet1

Date | Signal | Price | #[NAME] | Value | Profit
2014-03-27 00:00:00 | Buy | 184.58
2014-03-28 00:00:00 | Ignore | 185.49
2014-03-31 00:00:00 | Sell | 187.01
2014-08-28 00:00:00 | Buy | 200.14
2014-08-29 00:00:00 | Sell | 200.71
2014-09-30 00:00:00 | Buy | 197.02
2014-10-01 00:00:00 | Ignore | 194.35
2014-10-02 00:00:00 | Ignore | 194.38
2014-10-03 00:00:00 | Sell | 196.52
2014-12-31 00:00:00 | Buy | 205.54
2015-01-02 00:00:00 | Ignore | 205.43
2015-01-05 00:00:00 | Ignore | 201.72
2015-01-06 00:00:00 | Ignore | 199.82
2015-01-07 00:00:00 | Ignore | 202.31
2015-01-08 00:00:00 | Sell | 205.9
Calculate the Profit = Current "Sell" Value - Previous "Buy" Value
Note that distance between the Buy and Sell Rows are not constant
Only F4 is correct, the other are wrong.
The problem is to find the most recent buy value
Spreadsheet: 834856d1688123753-auto-populate-cell-based-on-criteria-with-date-range-sample-worksheet
Sheet: Sheet1

 | PRICE |  | Effective Date of Price
 | PRODUCT | CATEGORY | 04/15/2023 | 06/28/2023
 | PEN | OFFICE SUPPLIES | 5 | 7
 | PENCIL | OFFICE SUPPLIES | 5 | 8
 | PAPER | OFFICE SUPPLIES | 2 | 3
 | ALCOHOL | CLINIC SUPPLIES | 100 | 120
 | FACE MASK | CLINIC SUPPLIES | 10 | 20
 | SALES
 | DATE | PRODUCT | PRICE
 | 2023-04-20 00:00:00 | PEN
 | 2023-06-30 00:00:00 | ALCOHOL
Spreadsheet: 677469d1589371153-amortization-with-annual-repayment-escalations-as-well-as-deferred-payments-template-for-deferred-payment
Sheet: Deferred Payment

 | ASSET FINANCE CALCULATOR
 | Capital |  | 400000 |  |  | [NAME] |  |  | ARREARS
 | Interest Rate |  | 0.1 |  |  | Escalation |  | outstanding | No
 | Term in Years |  | 5 |  |  | Escalation Period |  | outstanding
 | Total Periods |  |  |  |  | Escalation Rate |  | outstanding | 0.1
 | Periods Per Year |  | 12 |  |  | Number of Payments Skipped |  |  | 3
 | Residual Value |  | 100000 |  |  | Total Repayment (excl residual)
 | Month | Opening Bal | Interest | Payment | Capital | [NAME]
 | 0
Spreadsheet: louise_kitchen__23044__CFs by Industry and Erating Update
Sheet: Energy Marketers

Energy Marketer Cash Flows
Sorted by E Rating
E rating | Data | Total
1 | Sum of Total CF | 45782828.85710002
 | Sum of Positive CF | 63939752.55230002
 | Sum of Negative CF | -18156923.6952
2 | Sum of Total CF | 28171485.93588001
 | Sum of Positive CF | 137863824.02946
 | Sum of Negative CF | -109692338.09358
3 | Sum of Total CF | -499627136.5973302
 | Sum of Positive CF | 486687266.5670399
 | Sum of Negative CF | -986314403.16437
4 | Sum of Total CF | 136009832.3410801
 | Sum of Positive CF | 1477757385.094359
 | Sum of Negative CF | -1341747552.75328
5 | Sum of Total CF | -413246300.2990199
 | Sum of Positive CF | 366006519.00757
 | Sum of Negative CF | -779252819.3065902
6 | Sum of Total CF | 136054983.7301599
 | Sum of Positive CF | 796490360.2897601
 | Sum of Negative CF | -660435376.5595999
7 | Sum of Total CF | 25503841.08128002
 | Sum of Positive CF | 52284686.07904001
 | Sum of Negative CF | -26780844.99776
8 | Sum of Total CF | 51298731.53921
 | Sum of Positive CF | 74002074.18729
 | Sum of Negative CF | -22703342.64808
9 | Sum of Total CF | 78650931.42210001
 | Sum of Positive CF | 109377392.28952
 | Sum of Negative CF | -30726460.86742
10 | Sum of Total CF | 63850856.54644001
 | Sum of Positive CF | 75822201.10507001
 | Sum of Negative CF | -11971344.55863
11 | Sum of Total CF | 15220513.19966
 | Sum of Positive CF | 23023348.84220999
 | Sum of Negative CF | -7802835.64255
12 | Sum of Total CF | -1747997.0628
 | Sum of Positive CF | 187976.819
 | Sum of Negative CF | -1935973.8818
Total Sum of Total CF |  | -334077429.3062401
Total Sum of Positive CF |  | 3663442786.862619
Total Sum of Negative CF |  | -3997520216.16886
Spreadsheet: eric_saibi__9837__100401
Sheet: South Texas 02

Owner Name |  | Reliant-Houston Lighting and Power Company
Station Name |  | South-Texas Project Electric Generating Station
Unit Name |  | South Texas 02
NERC Region |  | ERCOT
State |  | TX
Fuel Type |  | Nuclear
Capacity |  | 1,354 MW
Start Date |  | 2001-10-03 00:00:00
End Date |  | 2001-10-06 00:00:00
Comments |  | Valve Repair
SIC |  | 4911
Plant ID |  | 1000057
Unit ID |  | 1004003
Outage ID |  | 18581
Spreadsheet: 870059d1716563208-currency-mutiplied-by-the-exhange-rate-of-the-period-excel-forum-exchange-rates
Sheet: wk918

Date | Total price in Eur | Converted price in USD
2024-01-06 00:00:00 | 36887.73234200743 |  | should not give a price, since no exchange rate available for 06-01
2024-02-08 00:00:00 | 40000
2024-03-05 00:00:00 | 46000
2024-04-10 00:00:00 | 12000
 | Exchange rate
 | 2024-01-05 00:00:00 | 1.0876
 | 2024-02-08 00:00:00
 | 2024-01-11 00:00:00 | 1.09123
 | 2024-02-03 00:00:00 | 1.0653
 | 2024-03-05 00:00:00 | 1.0745
Spreadsheet: 827933d1683125512-need-help-with-a-formula-that-uses-multiple-criteria-with-a-date-range-to-output-price-sample-excel
Sheet: Sheet1

PO Number | [NAME] | Supplier Code | Line Item Number | Part No | Unit Price | Effective Date | Expiration Date | Note | PO Check | Part Check | Date Check | [NAME]
5xxxxx | Mill Steel of xxxxx | Mill Steel | 1 | 22377 | 0.393 | 2020-10-01 00:00:00 | 12/31/2020 | [NAME]
5xxxxx | Mill Steel of xxxxx | Mill Steel | 1 | 22377 | 0.5129 | 01/01/2021 | 02/01/2021 | Q1 CRU
5xxxxx | Mill Steel of xxxxx | Mill Steel | 1 | 22377 | 0.7212 | 04/01/2021 | 06/30/2021 | Q2 CRU 2021
5xxxxx | Mill Steel of xxxxx | Mill Steel | 1 | 22377 | 0.729 | 02/02/2021 | 03/31/2021 | Last Spot Buy Price
5xxxxx | Mill Steel of xxxxx | Mill Steel | 1 | 22377 | 0.8909 | 07/01/2021 | 09/30/2021
5xxxxx | Mill Steel of xxxxx | Mill Steel | 1 | 22377 | 1.0989 | 10/01/2021 | 12/31/2021 | [NAME] 2021 - Customer is Quote Each Time
 |  |  |  |  | PO | PART | DATE | WANT THE PRICE
 |  |  |  |  | 53188 | 22377 | 01/01/2021
 |  |  |  |  |  |  | Where the Date is Greater then or = to Eff Date and is less then or equipt to Exp Date
Spreadsheet: 80966d1281214513-transfer-columns-and-corresponding-data-to-row-format-example-origin-destination-table-bvj-
Sheet: output

Origin | Destination | Distance
a | Destination1 | 10
b | Destination1 | 3
c | Destination1 | 4
d | Destination1 | 1
a | Destination2 | 3
b | Destination2 | 2
c | Destination2 | 20
d | Destination2 | 2
a | Destination3 | 3
b | Destination3 | 4
c | Destination3 | 65
d | Destination3 | 10
Spreadsheet: 209759d1359209798-sum-of-unique-values-doesnt-match-sum-of-full-list-vespasian_solution
Sheet: Sheet1

Product description | Cost | Unique Product | Sum
[NAME] | 1000 | [NAME] | 2000
Nut | 2000 | Nut | 2000
Glue | 3000 | Glue | 3000
Axle | 1000 | Axle | 1000
Propshaft | 2000 | Propshaft | 4000
Differential | 3000 | Differential | 3000
[NAME] | 1000
Propshaft | 2000
Spreadsheet: 719248d1613575042-use-check-boxes-to-create-a-new-list-transfer-tora-v1-
Sheet: Sheet2

MR# | Patient Name | Location of Death | Date of Inactive | Inactive Type
Spreadsheet: 696126d1600647011-list-starters-and-leavers-on-separate-sheet-company-list-start-leave
Sheet: Sheet2

Company | Name | Department | Start Date | End Date
South | [NAME], [NAME] | Sales | 2020-10-01 00:00:00
South | Myers, [NAME] | Operator | 2019-03-15 00:00:00
South | Scaves, [NAME] | [NAME] | 2020-11-03 00:00:00
North | Jones, [NAME] | Finance | 2016-01-02 00:00:00
North | [NAME], [NAME] | [NAME] | 2020-10-15 00:00:00
North | Cruise, [NAME] | Operator | 2012-11-03 00:00:00 | 2020-10-12 00:00:00
South | Finnaghan, [NAME] | Sales | 2018-05-01 00:00:00 | 2020-10-29 00:00:00
Spreadsheet: 765101d1643169884-aggregate-data-into-one-row-based-on-date-and-id-book1-78-ans
Sheet: Sheet1

 |  |  |  |  |  |  | NOTE: Format Column H for Date
CURRENT |  |  |  |  |  | FORMULA RESULT |  |  |  |  |  |  | DESIRED
ID | Date | info 1 | info 2 | info 3 |  | ID | Date | info 1 | info 2 | info 3 |  |  | ID | Date | info 1 | info 2 | info 3
12345 | 2021-01-01 00:00:00 | a | b | c |  |  |  |  |  |  |  |  | 12345 | 2021-01-01 00:00:00 | a d g | b e h | c f i
12345 | 2021-01-01 00:00:00 | d | e | f |  |  |  |  |  |  |  |  | 12345 | 2021-09-01 00:00:00 | j | k | l
12345 | 2021-01-01 00:00:00 | g | h | i |  |  |  |  |  |  |  |  | 67890 | 2021-09-01 00:00:00 | m | n | o
12345 | 2021-09-01 00:00:00 | j | k | l |  |  |  |  |  |  |  |  | 67890 | 2021-01-01 00:00:00 | p s | q t | r u
67890 | 2021-09-01 00:00:00 | m | n | o
67890 | 2021-01-01 00:00:00 | p | q | r
67890 | 2021-01-01 00:00:00 | s | t | u
Spreadsheet: 26fa231d-28a7-472a-9774-723f068adbcb
Sheet: Sheet1

BRC002
BRC004
BRC005
[NAME]
BRC009
BRC011
BRC012
BRC024
BRC026
BRC027
BRC028
BRC030
BRC033
BRC034
BRC035
BRC043
BRC045
BRC046
BRC047
BRC048
BRC051
BRC052
BRC056
BRC065
BRC069
BRC070
BRC071
BRC072
BRC073
[NAME]
BRC079
BRC080
BRC082
BRC086
BRC089
BRC090
BRC091
BRC095
BRC096
BRC098
BRC099
BRC100
BRC101
BRC102
BRC105
BRC109
BRC113
BRC114
BRC115
[NAME]
BRC123
BRC125
BRC127
BRC130
BRC132
BRC135
BRC136
BRC138
BRC140
BRC146
BRC151
BRC160
BRC161
BRC167
BRC168
BRC169
BRC170
BRC179
BRC186
BRC188
BRC189
BRC190
BRC192
BRC194
BRC195
BRC197
BRC199
BRC201
BRC202
BRC204
BRC205
BRC209
BRC210
BRC211
BRC220
BRC224
BRC226
BRC227
BRC228
BRC229
[NAME]
BRC237
BRC242
BRC244
BRC247
BRC249
BRC250
BRC253
BRC254
BRC259
BRC262
BRC264
BRC268
BRC270
BRC271
BRC275
BRC276
BRC280
BRC281
BRC283
BRC288
BRC291
BRC292
BRC293
BRC294
BRC296
BRC300
BRC303
BRC305
BRC306
BRC307
BRC308
[NAME]
BRC318
BRC321
BRC323
BRC328
BRC329
BRC330
[NAME]
BRC334
BRC336
BRC338
BRC339
BRC340
BRC341
BRC343
BRC344
BRC346
BRC347
BRC348
BRC350
BRC351
BRC355
BRC356
BRC358
BRC360
BRC361
BRC362
BRC363
BRC365
BRC370
BRC372
BRC373
BRC376
BRC378
BRC382
BRC383
BRC384
BRC398
BRC408
BRC412
BRC413
BRC415
BRC416
BRC417
BRC418
BRC421
BRC422
BRC424
BRC425
BRC428
BRC430
BRC432
BRC433
BRC436
BRC441
[NAME]
BRC453N
BRC454P
BRC458
BRC461