tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 300986d1393618410-filtering-problem-benchmark-demo
Sheet: Percentages

Thresholds | Call  Processing | [NAME] | Travel | Response | Committed
Lower | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
Upper | 00:05:00 | 00:05:00 | 00:10:00 | 00:20:00 | 02:30:00
Count
Mean
Median
[NAME]
Min
Range
[NAME]
Percentiles
0
0.05
0.1
0.15
0.2
0.25
0.3
0.35
0.4
0.45
0.5
0.55
0.6
0.65
0.7
0.75
0.8
0.85
0.9
0.95
1
Spreadsheet: benjamin_rogers__1194__Calpine version 1
Sheet: IS

INCOME STATEMENT
('000 $)
 |  | 2001-12-31 00:00:00 | 2002-12-31 00:00:00 | 2003-12-31 00:00:00 | 2004-12-31 00:00:00 | 2005-12-31 00:00:00 | 2006-12-31 00:00:00 | 2007-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-12-31 00:00:00 | 2013-12-31 00:00:00 | 2014-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-12-31 00:00:00 | 2017-12-31 00:00:00 | 2018-12-31 00:00:00 | 2019-12-31 00:00:00 | 2020-12-31 00:00:00 | 2021-12-31 00:00:00 | 2022-12-31 00:00:00 | 2023-12-31 00:00:00 | 2024-12-31 00:00:00 | 2025-12-31 00:00:00 | 2026-12-31 00:00:00 | 2027-12-31 00:00:00 | 2028-12-31 00:00:00 | 2029-12-31 00:00:00 | 2030-12-31 00:00:00 | 2031-12-31 00:00:00
Revenue
Capacity Revenue
Energy Revenue
Ancillary Services |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Revenue
Expense
Fuel
Fixed Operating Expenses
Variable Operating Expenses
Major [NAME]
Insurance
SG&A
Start Charge
Property Tax |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Franchise Tax
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Debt Service Reserve [NAME]
Marketing Fee
Administrative Fee
O&M Fees
Total Expense
EBITDA
Depreciation & Amortization
EBIT
Interest Expense
Pretax Book Income
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense)
Net Income
Spreadsheet: 7f4f71ab-4fec-4148-9937-9f21486049fa
Sheet: 15b

Product1 | HY3 | IG | Other | TOTAL
Index/Index Tranche | 32249 | 217699 | 294781 | 544729
OTHER* | 0 | 0 | 6489 | 6489
TOTAL | 32249 | 217699 | 301270 | 551218
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 156086d1337177362-excel-2007-some-sort-of-lookup-on-a-cell-into-an-array-of-data-lookup-using-input-cell-into-array
Sheet: Data

Acc Number | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00
1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
333 | 11 | 22 | 33 | 44 | 55 | 66 | 77 | 88 | 99 | 100 | 110 | 120
544 23223 | 21 | 32 | 43 | 54 | 65 | 76 | 87 | 98 | 109 | 110 | 120 | 130
fdg1515 21236 55 | 23 | 34 | 45 | 56 | 67 | 78 | 89 | 100 | 111 | 112 | 122 | 132
Spreadsheet: 973f6ad1-ecaf-4795-b35b-7acba914df03
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
3169 | 9861 | [NAME] | Fiore | MON | 0 | 00:08:11 | 00:00:27 | [NAME] | 00:00:27 | 00:09:01 | 1 | 00:33:45
3169 | 17262 | Víctor | Navarro | MEX | 0 | 00:09:12 | 00:00:35 | 00:16:18 | 00:00:35 | 00:09:55 | 2 | 00:36:35
3169 | 17233 | Sergio | Díaz | MEX | 0 | 00:12:45 | 00:00:54 | 00:24:20 | 00:02:16 | 00:15:37 | 3 | 00:55:52
Spreadsheet: darrell_schoolcraft__7300__imball0112
Sheet: transcol

 | TransColorado
 | 500632
Day | Measured | Scheduled
1 | 102067 | 101181
2 | 100541 | 99669
3 | 113331 | 113022
4 | 75301 | 74820
5 | 74993 | 74822
6 | 77697 | 78322
7 | 83890 | 83066
8 | 85931 | 84822
9 | 85552 | 84822
10 | 84996 | 84822
11 | 94818 | 94822
12 | 98459 | 97797
13 | 68836 | 68429
14 | 66878 | 68575
15 | 76399 | 76575
16 | 76819 | 76575
17 | 76614 | 76539
18 | 58698 | 58574
19 | 58681 | 58575
20 | 58988 | 58575
21 | 58588 | 58575
22 | 59551 | 58575
23 | 58617 | 58575
24 | 58997 | 58575
25 | 58287 | 58575
26 | 58305 | 58575
27 | 58994 | 58285
28 | 58721 | 58575
29 | 56221 | 58575
30 | 58990 | 58575
31 | 51940 | 58575
2001-11-30 00:00:00 |  |  | 8908.65
2001-12-31 00:00:00
CBS Volume
 |  |  | -51521
Spreadsheet: 839512-marking-the-range-based-on-multiple-conditions-marking-range-based-on-conditions-solution-
Sheet: Hoja1

202330 | 202331 | 202332 | 202333 | 202334 | 202335 | 202336 | 202337 | 202338 | 202339 | 202340 | 202341
 |  | H | H |  | H | H | H |  | H | H
Start | End
202332 | 202333
202335 | 202337
202339 | 202340
Spreadsheet: 858034d1706822261-how-to-remove-names-text-if-repeated-in-another-cell-work-schedule-revised-1-
Sheet: Template

 |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun
 |  | 2022-01-01 00:00:00
Location 1
Location 2
Location 3 | Class A | Task 1 - Alicia & Krystal | Task 1 - Alicia & Krysta
 | Class B
 | Class C |  |  | Task 4 - Karen & Lori | Task 4 - Karen & Lori | Task 4 - Karen & Lori
 | Class D | Task 2 - Hannah
Location 4
Location 5 |  | Task 3 - Krystal
Location 6
Location 7
Location 8
Location 9
Location 10
Office
 |  | Krystal | Krystal | Krystal | Krystal | Krystal
Names
Alicia
Ally
[NAME]
[NAME]
Krystal
[NAME]
[NAME]
Spreadsheet: 714285d1611160592-custom-time-formatting-paybonusforef
Sheet: Sheet1

Working time | Needed Result | [NAME] | Difference
7:00:00 | 8:00:00
7:30:00 | 8:00:00
8:00:00 | 8:00:00
8:30:00 | 8:45:00
9:00:00 | 9:30:00
9:30:00 | 10:15:00
10:00:00 | 11:00:00
10:30:00 | 11:45:00
11:00:00 | 12:30:00
11:30:00 | 13:15:00
12:00:00 | 14:00:00
Spreadsheet: 752573d1634836046-index-match-formula-to-produce-monthly-payment-schedule-p4-form
Sheet: Payment schedule

Kindly asking for index and match formula to produce monthly payment schedule as shown in the desired solution. Please note that
the schedule only includes employees whose employee number starts with S.
Monthly Payment Schedule of Employees: |  |  | 2021-09-01 00:00:00
Desired Solution
Employee No. | Employee Name | Period | Age | Basic Salary | Amount
SA1 | Ginger | 9 | 31 | 9578 | 862.02
SA2 | DIET | 9 | 34 | 7800 | 702
SA4 | COKE | 9 | 25 | 7392 | 665.28
[NAME] | Nust | 9 | 46 | 7800.32 | 702.0287999999999
SA11 | Free | 9 | 45 | 7800.32 | 702.0287999999999
Spreadsheet: 777076d1650123502-pull-data-from-multiple-sheets-floor-stock-sheets-template
Sheet:  Wound Care 2004244

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Service Units
Item | Price | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu
Lemon Lime- Soda | 0.25
Diet Lemon Lime- Soda | 0.25
Cola- Soda | 0.25
Diet Cola- Soda | 0.25
Hydrolyte Honey Water | 0.32
Hydrolyte Honey tea | 0.37
Hydrolyte Nectar Water | 0.32
Hydrolyte Nectar Tea | 0.35
Ensure | 0.13
Crackers, [NAME] | 0.08
[NAME] ea | 0.05
Peanut Butter Crackers | 0.25
[NAME] | 0.28
[NAME] | 1.13
Pudding-Vanilla | 0.27
Diet Vanilla Pudding | 0.28
Applesauce Ind. | 0.32
Juice Orange | 0.23
Juice Cranberry | 0.23
Juice Apple | 0.23
Honey | 0.07
Jam/Jelly ea | 0.06
[NAME] | 0.02
Mayo | 0.06
Mustard | 0.02
[NAME] | 0.16
Salt/Pepper | 0.02
[NAME] | 0.11
[NAME] | 0.11
Milk- Skim | 0.25
2% Milk | 0.25
Coffee Decaf instant- Prepack cs. | 37.84
Coffee, [NAME]. cs. | 95.11
Tea Bags | 0.03
[NAME] | 1.47
Creamer, non dairy box | 0.03
Sugar | 0.02
Sweetner-Equal | 26.73
Sweetner-Sweet N Low | 17.58
Sweetner-Splenda | 30.44
Plastic Ware (fork,spoon knife) | 0.03
ensure | 0.14
Glucerna | 0.4
Jevity | 0.35
Nepro | 1.03
[NAME] | 15.6
Osmolite | 0.25
Perative | 1.39
Promote | 0.23
Pulmocare | 0.44
Refrigerator Thermometer (reg.)
Broth, [NAME] pkt. | 0.1
[NAME]-pkts. | 2.4
cups | 0.25
Plates | 0.03
[NAME] | 1.75
Cereal-Cheerios | 0.39
Ice Cream-Vanilla | 0.41
Ice Cream- Diet-Vanilla | 0.43
Diet Popsicles | 0.25
Popcicles | 0.2
Monthly Total
Spreadsheet: 57619d1257842779-macro-for-auto-report-in-excell-general-ledger
Sheet: 1004

 | 1004 - SALARIES
 | DATE | A/C NAME | A/C NO | REF# | PARTICULARS | DR. | CR. | DR./ CR. | BALANCE |  |  |  |  | BANK | 1001
 | Opening Balance |  |  |  |  |  |  | - | 0 |  |  |  |  | CASH | 1002
 | 2009-11-04 00:00:00 | SALARIES | 1004 | 4590 | SAL JAN-09 MICHLE | 50 |  | - | 0 |  |  |  |  | LOAN | 1003
 | 2009-11-08 00:00:00 | SALARIES | 1004 | 4594 | [NAME] | 20 |  | Cr. | -65
 | 2009-11-13 00:00:00 | SALARIES | 1004 | 4599 | [NAME] | 250 |  | Cr. | -250
 | 2009-11-14 00:00:00 | SALARIES | 1004 | 4599 | SALRY | 250 |  | - | 0
 |  |  |  |  |  |  |  | - | 0
 |  |  |  |  | TOTAL | 570 | 0 | Dr. | 570
Spreadsheet: 714811d1611383571-google-sheets-countifs-and-sumif-formulas-returning-0-copy-of-terrenos-familia-3-
Sheet: Jorge

 | JORGE |  |  | Renta
 |  |  |  | Meses rentados |  |  | Gastos
 |  |  |  | Ingresos |  |  | Ingresos
 |  |  |  |  |  |  | [NAME]
 | Fecha de pago | Propriedad | Persona | Descripcion | [NAME] | Monto | Recibo/Factura | Comentarios
Spreadsheet: 368fa2bb-8984-4e95-8b7f-605217408886
Sheet: Sheet1

F/Y 2014 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Justice of the Peace Authorized Bail Bond Agencies
Bail Bond Agencies | Address | Telephone  Number | Counties | Registered Agents | Authorized Agents to Pick Up Refunds
1st Choice Bail Bonds | 2800 Lancaster Avenue, Suite 4 | [PHONE] | All | [NAME] | [NAME]
 | [NAME], DE  19805
2nd Chance Bail Bonds | 25675 Covert Street |  | Kent | [NAME] | [NAME]
 | Seaford, DE  19973 | [PHONE] | Sussex
A Bail Bond by Resto & Co. | 1200 Northeast Boulevard, Unit B | [PHONE] | All | [NAME], [NAME], [NAME] | [NAME], [NAME], [NAME]
 | [NAME], DE  19802 |  |  | [NAME], Crystal DuPree | [NAME], Crystal DuPree
 |  |  |  | Krystal Pagan | Krystal Pagan
Above and Beyond Bail Bonds | 94A Quigley Boulevard
 | New Castle, DE  19720-4150 | [PHONE] | All | [NAME] | [NAME]
 |  |  |  | [NAME] | [NAME]
Absolute Bail Bonds | 104 [NAME] | [PHONE] | Kent | [NAME] | [NAME]
 | Milford, DE  19963 |  | Sussex
Ace Bail Bonds | 475 Bowers Beach Road | [PHONE] | Kent | [NAME] | [NAME]
 | Frederica, DE  19946
All Star Bail Bonds, LLC | 2915 Lancaster Avenue | [PHONE] | All | [NAME], Sr. | [NAME], Sr.
 | [NAME], DE  19805 |  |  | [NAME], Jr. | [NAME], Jr.
American Funding Services Corp. | 2062 New Castle Ave, Suite A |  |  | [NAME], [NAME], | [NAME]
CASH ONLY | New Castle, DE  19720 | [PHONE] | All | [NAME], [NAME] | [NAME]
Axe Bail Bonds | 977 Lochmeath Way
 | Dover, DE  19901 | [PHONE] | All | [NAME] | [NAME]
 |  |  |  | Trinity Goldsborough | Trinity Goldsborough
Bail Bond Agency, Inc. | 102 Larch Avenue, Suite 302 | [PHONE] | All | [NAME] | [NAME]
 | Newport, DE  19804 |  |  | Khyon Church
Bovell Bail Bond, Inc. | 1900 W. 4th Street | [PHONE] | All | [NAME], [NAME], | [NAME]
 | [NAME], DE  19805 |  |  | Gregory Dennis II (Kent and New Castly only)
Bruny's Bail Bonds | 1927 W. 4th Street | [PHONE] | All | Brunilda Mercado | Brunilda Mercado
 | [NAME], DE  19805
Cutting Edge Bail Bonds, LLC | 315 South State Street
 | Dover, DE  19901 | [PHONE] | All* | [NAME] | [NAME]
 |  |  | *Cannot post in JP 7
 |  |  |  | [NAME] | [NAME]
Dale's Bail Bonds LLC | 11 E. Market Street, Suite 1 | [PHONE] | Kent | R. [NAME] | R. [NAME]
 | Georgetown, DE  19947 | [PHONE] | Sussex | [NAME] | [NAME]
[NAME], Jr. Bail Bonds | 411 S. Queen Street | [PHONE] | Kent | [NAME], Jr. | [NAME], Jr.
 | Apt. 213
 | Dover, DE  19904
Fast Bail Bonds LLC | 1224 [NAME] | [PHONE] | All* | [NAME] | [NAME]
 | [NAME], DE  19801 |  | *Cannot post in JP 7
Lorenzo's Bail Bonds, Inc. | 5 E. Market Street | [PHONE] | Kent | [NAME] | [NAME]
 | Georgetown, DE  19947 |  | Sussex | [NAME]
Paragon Associates of Delaware | 583 N. Commerce Street | [PHONE] | Kent
 | Townsend, DE  19734 |  | Sussex | [NAME] | [NAME]
[NAME]'s Bail Bonds, LLC | 424 S. State Street | [PHONE] | Kent | [NAME] | [NAME]
 | Dover, DE  19901
T&H Bail Bond, Inc. | 625 [NAME] | [PHONE] | All | [NAME], [NAME], [NAME], [NAME] | [NAME], [NAME], [NAME], [NAME]
 | [NAME], DE  19801
Top Bail Surety, Inc. | 2800 Lancaster Avenue, Suite 4 | [PHONE] | All | [NAME], [NAME] | [NAME]
 | [NAME], DE  19805 |  |  |  | [NAME]
Spreadsheet: 741251d1626936702-need-your-help-on-this-thanks-might-save-life-i-dont-know-some-functions-here-sample
Sheet: FiscalYearLookUp

Month | Quarter
October | Q1
November | Q1
December | Q1
January | Q2
February | Q2
March | Q2
April | Q3
May | Q3
June | Q3
July | Q4
August | Q4
September | Q4
Spreadsheet: 766477d1643902277-vba-compare-copy-and-delete-compare
Sheet: Rawdata

Company A | Street | PO | City | Country | Phone | Mail | www | Text |  |  |  | All with Excists are lines which are in Total, and they shouls be copied into a line below this one
Company K |  |  |  |  |  |  |  |  |  |  |  | All with New means that they are not in Total
Company B |  | PO | City | Country | Phone
Company L |  | PO | City | Country | Phone | Mail | www | Text
Company D | Street
Company F |  | PO | City | Country | Phone | Mail | www | Text
Company M | Street | PO | City | Country | Phone | Mail | www | Text
Company H | Street | PO | City |  | Phone
Company N |  |  | City |  | Phone | Mail |  | Text
Company I |  |  | City |  | Phone | Mail |  | Text
Company J |  | PO | City |  | Phone | Mail |  | Text
Company O | Street | PO | City | Country | Phone | Mail |  | Text
Spreadsheet: 875458d1722012929-multiple-if-or-statements-data-1
Sheet: Sheet1

Data 1 | Data 2 | Data 3 | Data 4 | Return
A | A1 | 01 | A
H | A2 | 01 | A
A | A3 | 01 | W
G | 3 | - | -
A | B1 | 03 | C
A | C1 | 08 | Z
D | A2 | 05 | Y
D | D3 | 01 | W
K | D9 | 11 | H
Spreadsheet: 48011d1247185325-using-a-pivottable-to-calculate-total-rejection-percentage-pivot_table_percent_rejects
Sheet: Sheet1

Supplier | Product | Received | Rejected | Rejected %
A | Chocolate | 100 | 5 | 0.05
A | Chocolate | 200 | 10 | 0.05
C | Ice Cream | 100 | 4 | 0.04
C | Ice Cream | 100 | 8 | 0.08
A | Sugar | 300 | 9 | 0.03
C | Chewing Gum | 200 | 0 | 0
C | Chewing Gum | 100 | 4 | 0.04
B | Chocolate | 200 | 0 | 0
B | Chocolate | 100 | 1 | 0.01
A | Sugar | 300 | 6 | 0.02
A | Ice Cream | 100 | 1 | 0.01
Sum of Percent Rejected
Supplier | Product | Total
A
 | Chocolate | 0.05
 | Ice Cream | 0.01
 | Sugar | 0.025
A Total |  | 0.031
B
 | Chocolate | 0.003333333333333334
B Total |  | 0.003333333333333334
C
 | Ice Cream | 0.06
C Total |  | 0.06
Spreadsheet: 870173d1716732936-required-multilevel-sequence-serial-numbers-gk-final
Sheet: Sheet1

 | DONE GK |  | DONE GK
 | C Index | C-Title | M-Index | M-Title | CM Index | CM Title |  |  |  | Desired result for F |  | Is it right?
 |  | Area-1 |  | Topic-1 |  | Statement-1 |  |  |  | [NAME]
 |  |  |  |  | CM-1.1.2 | Statement-2 |  |  |  | CM-1.1.2
 |  |  |  |  | CM-1.1.3 | Statement-3 |  |  |  | CM-1.1.3
 |  |  | M - 1.2 | Topic-2 | CM-1.2.1 | Statement-4 |  |  |  | CM-1.2.1
 |  |  |  |  | [NAME] | Statement-5 |  |  |  | [NAME]
 |  |  |  |  | CM-1.2.3 | Statement-6 |  |  |  | CM-1.2.3
 |  |  |  |  | CM-1.2.4 | Statement-7 |  |  |  | CM-1.2.4
 |  |  | M - 1.3 | Topic-3 | CM-1.3.1 | [NAME] |  |  |  | CM-1.3.1
 |  |  |  |  | CM-1.3.2 | Statement-9 |  |  |  | CM-1.3.2
 | C - 2 | Area-2 | M - 2.1 | Topic-A | [NAME] | Statement-10 |  |  |  | [NAME]
 |  |  |  |  | CM-2.1.2 | Statement-11 |  |  |  | CM-2.1.2
 |  |  |  |  | CM-2.1.3 | Statement-12 |  |  |  | CM-2.1.3
 |  |  |  |  | CM-2.1.4 | Statement-13 |  |  |  | CM-2.1.4
 |  |  | M - 2.2 | Topic-B | CM-2.2.1 | Statement-14 |  |  |  | CM-2.2.1
 |  |  |  |  | [NAME] | Statement-15 |  |  |  | [NAME]
 |  |  |  |  | CM-2.2.3 | [NAME] |  |  |  | CM-2.2.3
 |  |  |  |  | CM-2.2.4 | Statement-17 |  |  |  | CM-2.2.4
 |  |  |  |  | CM-2.2.5 | Statement-18 |  |  |  | CM-2.2.5
 |  |  |  |  | CM-2.2.6 | [NAME] |  |  |  | CM-2.2.6
 |  |  | M - 2.3 | Topic-C | CM-2.3.1 | Statement-20 |  |  |  | CM-2.3.1
 |  |  |  |  | CM-2.3.2 | Statement-21 |  |  |  | CM-2.3.2
 |  |  |  |  | CM-2.3.3 | Statement-22 |  |  |  | CM-2.3.3
 | C - 3 | Area-3 | M - 3.1 | Topic-X1 | CM-3.1.1 | Statement-23 |  |  |  | CM-3.1.1
 |  |  |  |  | CM-3.1.2 | Statement-24 |  |  |  | CM-3.1.2
 |  |  |  |  | CM-3.1.3 | Statement-25 |  |  |  | CM-3.1.3
 |  |  |  |  | CM-3.1.4 | Statement-26 |  |  |  | CM-3.1.4
 |  |  |  |  | CM-3.1.5 | Statement-27 |  |  |  | CM-3.1.5
 |  |  | M - 3.2 | Topic-X2 | CM-3.2.1 | Statement-28 |  |  |  | CM-3.2.1
 |  |  |  |  | CM-3.2.2 | Statement-29 |  |  |  | CM-3.2.2
 |  |  |  |  | CM-3.2.3 | Statement-30 |  |  |  | CM-3.2.3
 |  |  |  |  | CM-3.2.4 | Statement-31 |  |  |  | CM-3.2.4
 |  |  | M - 3.3 | Topic-X3 | CM-3.3.1 | Statement-32 |  |  |  | CM-3.3.1
 |  |  |  |  | CM-3.3.2 | [NAME] |  |  |  | CM-3.3.2
 |  |  |  |  | CM-3.3.3 | Statement-34 |  |  |  | CM-3.3.3
 |  |  |  |  | CM-3.3.4 | Statement-35 |  |  |  | CM-3.3.4
 |  |  |  |  | CM-3.3.5 | Statement-36 |  |  |  | CM-3.3.5
 |  |  |  |  | CM-3.3.6 | Statement-37 |  |  |  | CM-3.3.6
 |  |  | M - 3.4 | Topic-X4 | CM-3.4.1 | Statement-38 |  |  |  | CM-3.4.1
 |  |  |  |  | CM-3.4.2 | Statement-39 |  |  |  | CM-3.4.2
 |  |  |  |  | CM-3.4.3 | Statement-40 |  |  |  | CM-3.4.3
 |  |  |  |  | CM-3.4.4 | Statement-41 |  |  |  | CM-3.4.4
 |  |  |  |  | CM-3.4.5 | Statement-42 |  |  |  | CM-3.4.5
 |  |  |  |  | CM-3.4.6 | Statement-43 |  |  |  | CM-3.4.6
 | C - 4 | Area-4 | M - 4.1 | Topic-A-1 | CM-4.1.1 | Statement-44 |  |  |  | CM-4.1.1
Spreadsheet: 0a17f1c2-54da-4b87-a370-c654e4bca848
Sheet: Sheet1

Applicant Name: |  |  |  | Award Number:
Budget Information - Non Construction Programs
OMB Approval No. 0348-0044
Section A - Budget Summary
 | Grant Program Function or Activity | Catalog of Federal Domestic Assistance Number | Estimated Unobligated Funds |  | New or Revised Budget
 |  |  | Federal | Non-Federal | Federal | Non-Federal | Total
 | (a) | (b) | (c ) | (d) | (e) | (f) | (g)
1.
2.
3.
4.
5. | Totals
Section B - Budget Categories
6. | Object Class Categories |  | Grant Program, Function or Activity |  |  |  | Total (5)
 |  |  | (1) | (2) | (3) | (4)
 | [NAME]
 | [NAME]
 | c.  Travel
 | d.  Equipment
 | e.  Supplies
 | f.  Contractual
 | g.  Construction
 | h.  Other
 | i.  Total Direct Charges (sum of 6a-6h)
 | j.  Indirect Charges
 | k.  Totals (sum of 6i-6j)
7. | Program Income
 |  |  |  |  |  |  | SF-424A (Rev. 4-92)
Previous Edition Usable |  |  |  |  |  | Prescribed by OMB Circular A-102
Authorized for Local Reproduction
Section C - Non-Federal Resources
 | (a) Grant Program |  |  | (b) Applicant | (c ) State | (d) Other Sources | (e) Totals
8.
9.
10.
11.
12. | Total (sum of lines 8 - 11)
Section D - Forecasted Cash Needs
 |  |  | Total for 1st Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th quarter
13. | Federal
14. | Non-Federal
15. | Total (sum of lines 13 and 14)
Section E - Budget Estimates of Federal Funds Needed for Balance of the Project
(a) Grant Program |  |  |  | Future Funding Periods (Years)
 |  |  |  | (b) First | (c ) Second | (d) Third | (e) Fourth
16.
17.
18.
19.
20. | Total (sum of lines 16-19)
Section F - Other Budget Information
21. Direct Charges |  |  |  | 22. Indirect Charges
23.  [NAME]
 |  |  |  |  |  |  | SF-424A (Rev. 4-92)
Previous Edition Usable |  |  |  |  |  |  | Prescribed by OMB Circular A-102
 |  | Authorized for Local Reproduction
Spreadsheet: 888640d1739212422-alternative-to-rate-formula-loan-coverage-analysis
Sheet: Loan Coverage Analysis

 | Loan Coverage Analysis
 | Key Assumptions
 | Loan Balance |  | 50000000
 | [NAME] |  | 0.05
 | Spread over [NAME] |  | 0.03
 | Amortization Period (Yrs.) |  | 30
 | Cash Flow Before Debt Service |  | 5000000
 | Previous Formula/Output (INCORRECT)
 | RATE Calculation |  |  |  | <<< Problem: RATE formula is not precise, will return value that is (a) within 0.000001 of prev. guess or (b) after 20 iterations, whichever occurs first.
 | New Formula/Output
 | Total Interest Rate Stress |  | [FORMULA] |  | <<< New formula input
 | Interest Rate Sensitivity (Check Answer)
 | Period | Base Year | Stressed Year
 | [NAME] |  | 0.06338273448770983 |  | <<< Check your [FORMULA] output here (prev. formula pasted for reference)
 | Spread over [NAME]
 | Total Interest Rate
 | Cash Flow Before Debt Service
 | Debt Service
 | Net Cash Flow After Debt Service |  |  |  | <<< Net Cash Flow after Debt Service should equal $0
 | Debt Service Coverage Ratio |  |  |  | <<< Debt Service Coverage Ratio should equal 1.00
Spreadsheet: 769861d1645711928-automation-for-dso-countback-methods-copie-de-debtor-days-countback-method
Sheet: Sheet1

 |  | 2020-06-30 00:00:00 | 2020-07-31 00:00:00 | 2020-08-31 00:00:00 | 2020-09-30 00:00:00 | 2020-10-31 00:00:00 | 2020-11-30 00:00:00 | 2020-12-31 00:00:00 | 2021-01-31 00:00:00 | 2021-02-28 00:00:00 | 2021-03-31 00:00:00 | 2021-04-30 00:00:00 | 2021-05-31 00:00:00 | 2021-06-30 00:00:00
Consolidated End of month debtor figures |  | 4017106.819999999 | 5568591.020000003 | 4500863.300000002 | 3987836.84 | 5123407.559999999 | 4477310.779999997 | 3630932.5 | 4508182.110000001 | 3316858.13 | 0 | 0 | 0 | 0
Consolidated Monthly billed amounts |  | 1785212.019999999 | 3599806.620000002 | 1389666.899999999 | 1463391.529999999 | 3372573.970000001 | 1442446.29 | 1567970.35 | 3138848.049999999 | 1567080.98 | 0 | 0 | 0 | 0
Debtor Days
Number of days in the month |  | 30 | 31 | 31 | 30 | 31 | 30 | 31 | 31 | 28 | 31 | 30 | 31 | 30
Count Back DSO
 |  |  | turnover | oustanding amount | nbr days | dso | Calcul
 |  | June |  | 4017106.819999999 | 30 |  |  |  | 30
 |  | July |  | 5568591.020000003 | 31 |  |  |  | 31
 |  | August |  | 4500863.300000002 | 31 |  |  |  | 31
 |  | September |  | 3987836.84 | 30 |  |  |  | 30
 |  | October |  | 5123407.559999999 | 31 |  |  |  | 31
 |  | November |  | 4477310.779999997 | 30 |  |  |  | 30
 |  | December |  | 3630932.5 | 31 |  |  |  | 31
 |  | January |  | 4508182.110000001 | 31 |  |  |  | 31
 |  | February |  | 3316858.13 | 28
Spreadsheet: 862650d1710317607-need-a-formula-that-searches-criteria-tri-and-returns-yes-or-no-sample63
Sheet: Sheet1

Column1 | Column2 |  | Column1 | Column2
2024-01-01 00:00:00 | Tri |  | 2024-01-01 00:00:00 | Yes
2024-01-05 00:00:00 | Double |  | 2024-02-01 00:00:00 | No
2024-01-25 00:00:00 | Double |  | 2024-03-01 00:00:00 | Yes
2024-01-28 00:00:00 | Double |  | 2024-04-01 00:00:00
2024-02-03 00:00:00 | Double |  | 2024-05-01 00:00:00
2024-02-05 00:00:00 | Double |  | 2024-06-01 00:00:00
2024-02-17 00:00:00 | Double |  | 2024-07-01 00:00:00
2024-02-21 00:00:00 | Double |  | 2024-08-01 00:00:00
2024-03-02 00:00:00 | Double |  | 2024-09-01 00:00:00
2024-03-09 00:00:00 | Tri |  | 2024-10-01 00:00:00
2024-03-11 00:00:00 | Double |  | 2024-11-01 00:00:00
2024-03-15 00:00:00 | Double |  | 2024-12-01 00:00:00
2024-03-19 00:00:00 | Double
Spreadsheet: 695039d1599994457-allocate-based-on-start-date-and-apply-annual-inflationary-uplift-example-2
Sheet: Summary

 |  |  |  |  | 1 | 2 | 3 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
Client | Start | Income | YoY % |  | 2020.21 | 2021.22 | 2022.23 |  | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00
1 | 2020-08-01 00:00:00 | 5000 | 0.05
2 | 2020-10-01 00:00:00 | 5000 | 0.1
3 | 2022-06-01 00:00:00 | 1000 | 0.33
4 | 2022-04-01 00:00:00 | 4356 | 0.45