tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 117070d1312425014-summing-specific-non-zero-rows-in-a-table-sample
Sheet: Case Scenarios

 |  |  |  |  |  |  | Cumm. |  | Cumm | Qtrly
 |  | Randomness |  | No |  |  | Qtr | Qtr | 0
 |  | End of first operating quarter |  |  |  |  | 1 | 4Q11
 |  |  |  |  |  |  |  | 1Q12
 |  | Model Variable #1 |  |  |  |  |  | 2Q12
 |  | Success Rate (out of 10) |  | Return Low | Return High |  |  | 3Q12
 |  | Strong | 3 | 2 | 3 |  |  | 4Q12
 |  | Moderate | 3 | 1.1 | 2 |  |  | 1Q13
 |  | Poor | 1 | 0.8 | 1.1 |  |  | 2Q13
 |  | Fail | 3 | 0 |  |  |  | 3Q13
 |  |  |  |  |  |  |  | 4Q13
 |  |  |  |  |  |  |  | 1Q14
 |  | Model Variable #2 |  |  |  |  |  | 2Q14
 |  | Target Investment Commitment (US$, 000s) |  |  |  |  |  | 3Q14
 |  |  | Annual | Per Qtr |  |  |  | 4Q14
 |  | 2011 | 25000 |  |  |  |  | 1Q15
 |  |  | 30000 |  |  |  |  | 2Q15
 |  |  | 35000 |  |  |  |  | 3Q15
 |  |  | 40000 |  |  |  |  | 4Q15
 |  |  | 45000 |  |  |  |  | 1Q16
 |  | 2016 | 50000 |  |  |  |  | 2Q16
 |  |  |  |  |  |  |  | 3Q16
 |  | Model Variable #3 |  |  |  |  |  | 4Q16
 |  | Per Investment Commitment Limitations (US$, 000s) |  |  |  |  |  | 1Q17
 |  | Min | [NAME] |  |  |  |  | 2Q17
 |  | 1000 | 6000 |  |  |  |  | 3Q17
 |  |  |  |  |  |  |  | 4Q17
 |  | Model Variable #4 |  |  |  |  |  | 1Q18
 |  | Length of Case (Quarters) |  |  |  |  |  | 2Q18
 |  | Min | [NAME] |  |  |  |  | 3Q18
 |  | 6 | 12 |  |  |  |  | 4Q18
 |  |  |  |  |  |  | Potential | Actual | 1
 |  | Case | Commencement | Investment | Length ([NAME]) | Success | Payout | Payout | IRR | 4Q11 | 1Q12 | 2Q12 | 3Q12 | 4Q12 | 1Q13 | 2Q13 | 3Q13 | 4Q13 | 1Q14 | 2Q14 | 3Q14 | 4Q14 | 1Q15 | 2Q15 | 3Q15 | 4Q15 | 1Q16 | 2Q16 | 3Q16 | 4Q16 | 1Q17 | 2Q17 | 3Q17 | 4Q17 | 1Q18 | 2Q18 | 3Q18 | 4Q18
 |  | 1
 |  |  | 0.3 |  | Strong |  | Total Investments in Qtr
 |  |  | 0.4 |  | Moderate |  | Total Receipts
 |  |  | 1.4 |  | Poor |  | Net Qtrly Cash Flows
 |  |  | 0.3 |  | Fail |  | Cummulative Cash Flows
 |  |  |  |  |  |  | Committed Capital
 |  |  |  |  |  |  | Disbursed Capital
 |  |  |  |  |  |  | Negative Cashflow
 |  |  | Investment Allocation
 |  |  | Quarters | 1
 |  |  | 4 | 0.2 | 0.2 | 0.2 | 0.4
 |  |  |  | 0.08 | 0.12 | 0.18 | 0.23 | 0.39
 |  |  |  | 0.05 | 0.1 | 0.15 | 0.15 | 0.2 | 0.35
 |  |  |  | 0.03 | 0.05 | 0.1 | 0.15 | 0.15 | 0.2 | 0.32
 |  |  |  | 0.025 | 0.055 | 0.08 | 0.09 | 0.14 | 0.14 | 0.19 | 0.28
 |  |  |  | 0.021 | 0.039 | 0.06 | 0.09 | 0.1 | 0.12 | 0.15 | 0.17 | 0.25
 |  |  |  | 0.02 | 0.04 | 0.05 | 0.06 | 0.08 | 0.1 | 0.12 | 0.14 | 0.16 | 0.23
 |  |  |  | 0.015 | 0.02 | 0.03 | 0.045 | 0.06 | 0.08 | 0.1 | 0.12 | 0.14 | 0.18 | 0.21
 |  |  |  | 0.005 | 0.015 | 0.025 | 0.035 | 0.05 | 0.065 | 0.08 | 0.105 | 0.12 | 0.15 | 0.16 | 0.19
 |  |  |  | 0.005 | 0.015 | 0.025 | 0.035 | 0.045 | 0.055 | 0.07 | 0.08 | 0.1 | 0.12 | 0.13 | 0.15 | 0.17
 |  |  |  | 0.005 | 0.015 | 0.02 | 0.03 | 0.04 | 0.05 | 0.06 | 0.07 | 0.085 | 0.105 | 0.11 | 0.13 | 0.13 | 0.15
Spreadsheet: 824293d1680467225-data-flow-from-main-sheet-to-another-tab-data-flow-from-main-sheet-to-other-tab-according-to-the-name-of-the-tab-1-
Sheet: Active

SR NO | ORDER DATE | AGEING | ORDER STATUS | CLIENT NAME | COUNTRY | CATEGORY | QTY | TOTAL order received | BALANCE order TO SOURCE | DELHI | CHD | CHENNAI | DLC | MUM CNF | PSK | TOTAL order received | BALANCE order TO SOURCE
Spreadsheet: 873665d1720178755-if-function-with-sumifs-if-statement-and-sumif
Sheet: Result

 | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12
 | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | YTD Total
Financial Year |  |  |  |  |  |  |  |  |  |  |  |  | ACTUAL | FORECAST
Cost 1
Cost 2
Cost 3
Cost 4
Cost 5
Cost 6
Cost 7
Cost 8
Cost 9
Total
Exepected Results
 | ACTUAL | ACTUAL | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | Total
Cost 1 | 10000 |  |  |  | 18000 |  | 25000 |  | 25000
Cost 2
Cost 3
Cost 4
Cost 5 |  | 28000 |  |  | 12000 |  |  | 63000
Cost 6
Cost 7
Cost 8
Cost 9
Total
HI team
Could someone please assist to help me pull through the actual or forecast for specific  month on my expected result-so at any time when the actual or forecast changes by moving the cell from the source data my result tab will update
On the if statement formular my value if criteria should only pick the sum of forecast for specific month if it is not actual.
Spreadsheet: c81ec5fb-a68d-4ae5-9291-c9535408aff0
Sheet: Sheet1

nachrichtID | nachrichtTitel | sprache | land | datum | kurzBeschreibung | timeStamp | kurzMeldung | newsletter | quartalsUebersicht | verfallsDatum | email | url | status | user
1 | Buch: [NAME]: Krieg und Welt | ungarisch | [NAME] | 12.07.2012 [NAME] | Übersetzung | 11.19.2004 10:51:47 | Ja | [NAME] |  | 11.22.2222 [NAME] | [EMAIL] | www.doml.at | [NAME] | 1
2 | Literatur aktuell | deutsch | Albanien | 12.11.1111 00:00:00 | test | 11.19.2004 10:41:03 | [NAME] | [NAME] | [NAME] | 11.22.2222 [NAME] | [EMAIL] | www.doml.at | [NAME]
3 | Buchmesse in Warschau | polnisch | [NAME] | 11.29.2004 00:00:00 | Monika [NAME] und [NAME] ([NAME]) [NAME] über die XV Buchmesse in Warschau | 11.30.2004 12:46:43 | Ja | [NAME] | [NAME] | 01.01.2005 00:00:00 | 1 | [NAME] | [NAME]
4 | "Trufle" von Jan Grzegorczyk | polnisch | [NAME] | 11.29.2004 00:00:00 | Neuer Roman des Autors  "Adieu. Przypadki ksi&#281;dza Grosera" | 11.30.2004 13:21:33 | Ja | [NAME] | [NAME] | 01.01.2005 00:00:00 | 1 | http://serwisy.gazeta.pl/kultura/1,34169,2419159.html | [NAME]
5 | Zwei neue Bücher über Czes&#322;aw Mi&#322;osz | polnisch | [NAME] | 11.29.2004 00:00:00 | "W ogrodzie ziemskim. [NAME] i "Czes&#322;aw Mi&#322;osz in memoriam" | 11.30.2004 15:06:29 | Ja | [NAME] | [NAME] | 01.01.2005 00:00:00 | 1 | [NAME] | [NAME]
6 | [NAME] | polnisch | [NAME] | 11.28.2005 00:00:00 | Antologie der ukrainischen Poesie der Gegenwart auf Polnisch | 11.30.2004 13:34:40 | Ja | [NAME] | [NAME] | 01.01.2005 00:00:00 | 1 | http://serwisy.gazeta.pl/kultura/1,34169,2417320.html | [NAME]
7 | Ulitzkaja: „Russland wird zivilisiert – [NAME]!“ | deutsch | Albanien | 10.19.2012 00:00:00 | Ulitzkaja im [NAME] | 10.19.2012 00:00:00 | Ja | [NAME] | [NAME] | 04.19.2013 00:00:00 |  | http://diepresse.com/home/kultur/literatur/1302962/Ulitzkaja_Russland-wird-zivilisiert-oder-schreckl | [NAME]
8 | [NAME] | deutsch | Finnland | 11.09.2013 00:00:00 | Camus zum 100. Geburtstag | 11.09.2013 00:00:00 | [NAME] | [NAME] | [NAME] | 02.09.2014 00:00:00 |  |  | [NAME]
9 | Theaterpremieren | Slowakisch | Belgien | 11.09.2013 00:00:00 | [NAME] | 11.09.2013 00:00:00 | Ja | [NAME] | [NAME] | 02.09.2014 00:00:00 |  | http://www.univie.ac.at/doml/_db/literaturnachrichtenadd.php | [NAME]
10 | [NAME] wir schon genug | tschechisch | [NAME] | 11.23.2013 00:00:00 | [NAME] heurigen Preisträger des Goncourt | 11.23.2013 00:00:00 | [NAME] | [NAME] | [NAME] | 04.23.2014 00:00:00 |  | http://www.advojka.cz/archiv/2013/24/avantgard-uz-jsme-meli-dost | [NAME]
11 | ??? ??????????? ? ??????? ?????????? | russisch | Großbritannien | 11.25.2013 00:00:00 | Dostojewskij und [NAME] | 11.25.2013 00:00:00 | [NAME] | [NAME] | [NAME] | 01.25.2014 00:00:00 |  | http://www.novayagazeta.ru/arts/61099.html | [NAME]
Spreadsheet: 2221c500-1a35-40aa-b8bc-d710e0f6acb9
Sheet: 9c

Product | AUD** | CAD | CHF | DKK | KRW | NOK | NZD | SEK | ZAR | TOTAL
Basis* | 63417 | 52563 | 138103 | <1,000 |  |  |  |  |  | 254083
FRA |  |  | 379137 | 111483 |  | 268251 |  | 743268 |  | 1502139
IRS- [NAME] | 2040357 | 2058584 | 1305359 | 97167 |  | 244978 | 431202 | 818184 | 396425 | 7392256
OIS |  | 171523 | 73771 |  |  |  |  |  |  | 245294
VNS
Zero Coupon |  | <1,000 |  |  |  |  |  | <1,000 |  | <1,000
TOTAL | 2103775 | 2282670 | 1896370 | 208650 |  | 513229 | 431202 | 1561452 | 396425 | 9393773
Estimated gross notional amount outstanding, December 21 weekly snapshot, by product type and supermajor currency (millions of USD), cleared swaps only, all participant types and tenors. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for currency descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: lindy_donoho__21972__TW2010ProjCap&Rev
Sheet: Summary Ctrc's & Resubscription

 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010
SUBSCRIBED
WEST
System Capacity | 1160000 | 1210000 | 1210000 | 1210000 | 1210000 | 1210000 | 1210000 | 1210000 | 1210000
Subscribed Volume | 1126842 | 1083283 | 999783 | 846533 | 477033 | 262658 | 184117 | 101033 | 98700
Contractual Average Rate
Revenue | 120550803 | 124112524 | 120044973 | 104371463 | 52847205 | 27357003 | 18651674 | 13343910 | 13216230
EAST
System Capacity | 688827 | 688827 | 688827 | 688827 | 688827 | 688827 | 688827 | 688827 | 688827
Subscribed Volume | 619809 | 220196 | 74363 | 72218 | 35500 | 667 | 0 | 0 | 0
Contractual Average Rate |  |  |  |  |  |  | 0 | 0 | 0
Revenue | 8066199 | 3764821 | 1853421 | 1802132 | 948480 | 12160 | 0 | 0 | 0
IGNACIO TO BLANCO
System Capacity
Subscribed Volume | 652000 | 555000 | 262917 | 252500 | 63542 | 55000 | 0 | 0 | 0
Contractual Average Rate |  |  |  |  |  |  | 0 | 0 | 0
Revenue | 10777651 | 7563885 | 2580960 | 2352960 | 59280 | 0 | 0 | 0 | 0
SAN JUAN (BL TO TH)
System Capacity | 850000 | 850000 | 850000 | 850000 | 850000 | 850000 | 850000 | 850000 | 850000
Subscribed Volume | 841863 | 843929 | 807333 | 698000 | 433500 | 156000 | 93083 | 10000 | 10000
Contractual Average Rate
Revenue | 21688947 | 22489926 | 21748403 | 18943578 | 12409949 | 1745021 | 0 | 0 | 0
TOTAL SUBSCRIBED REVENUE
UNSUBSCRIBED (at Risk)
WEST
System Capacity | 1160000 | 1210000 | 1210000 | 1210000 | 1210000 | 1210000 | 1210000 | 1210000 | 1210000
ReSubscribed Volume | 33158 | 126717 | 210217 | 363467 | 732967 | 947342 | 1025883 | 1108967 | 1111300
Historical Average Rate | 0.2565 | 0.2565 | 0.2565 | 0.2565 | 0.2565 | 0.2565 | 0.2565 | 0.2565 | 0.2565
Revenue
EAST
System Capacity | 688827 | 688827 | 688827 | 688827 | 688827 | 688827 | 688827 | 688827 | 688827
ReSubscribed Vol - Cases 1 & 3 | 69018 | 468631 | 614464 | 616609 | 653327 | 688160 | 688827 | 688827 | 688827
Resubscribed Vol - Case 2
Historical Average Rate | 0.0591 | 0.0591 | 0.0591 | 0.0591 | 0.0591 | 0.0591 | 0.0591 | 0.0591 | 0.0591
Revenue
IGNACIO TO BLANCO
System Capacity | 681000 | 681000 | 681000 | 681000 | 681000 | 681000 | 681000 | 681000 | 681000
ReSubscribed Vol - Cases 1 & 3 | 29000 | 126000 | 418083 | 428500 | 617458 | 626000 | 681000 | 681000 | 681000
Resubscribed Vol - Case 2
Historical Average Rate | 0.0428 | 0.0428 | 0.0428 | 0.0428 | 0.0428 | 0.0428 | 0.0428 | 0.0428 | 0.0428
Revenue
SAN JUAN (BL TO TH)
System Capacity | 850000 | 850000 | 850000 | 850000 | 850000 | 850000 | 850000 | 850000 | 850000
ReSubscribed Volume | 8137 | 6071 | 42667 | 152000 | 416500 | 694000 | 756917 | 840000 | 840000
Historical Average Rate | 0.1043 | 0.1043 | 0.1043 | 0.1043 | 0.1043 | 0.1043 | 0.1043 | 0.1043 | 0.1043
Revenue
TOTAL UNSUBSCRIBED REVENUE
TOTAL REVENUE
Spreadsheet: 0eb76dc4-6453-4ce0-a89b-3f4c79d3606f
Sheet: Table I.20

Table I.20 الجدول
Hybrid accounts for supply and use of water, Egypt, 2009 (Billions Egyptian Pounds, MCM)
[NAME] لإمدادات المياه واستخدامها، مصر، 2009 (مليار جنيه مصري،  مليون متر مكعب)
 | Industries (by ISIC categories) |  |  |  |  |  |  |  | Rest of the world | Taxes less subsidies on products, trade and transport margins | Actual final consumption |  | Capital Formation | Total
 | ISIC | ISIC 5-33, 41-43 | ISIC 35 |  | ISIC 36 | ISIC 37 | ISIC 38,39, 45-99 | Total industry |  |  | Households | Government
 | 2011-03-01 00:00:00 |  | Total | of which: Hydro
1. Total output and supply (Billions EP) | 137.6 | 749 | 22.1 | 3.3 | 1.7 | 9 | 367 | 1286.4 | 363 | 70 |  |  |  | 1719.4
of which:
1.a. Natural water (CPC 1800) | - | - | - | - | 1.7 | - | - | 1.7 | - | -0.1 |  |  |  | 1.6
1.b. Sewerage services (CPC 941) | - | - | - | - | - | 9 | - | 9 | - | - |  |  |  | 9
2. Total intermediate consumption and use (Billions EP) | 72.9 | 419.4 | 9.9 | 1.1 | 1.1 | 1.7 | 157.8 | 664 | 403 |  | 452.8 | 53.6 | 146 | 1719.4
of which:
2.a. Natural water (CPC 1800) | - | - | - | - | - | - |  |  | - |  | - | -
2.b. Sewerage services (CPC 941) | - | - | - | - | - | - |  |  | - |  | 0.1 | -
3. Total value added (gross) (= 1-2) (Billions EP) | 64.7 | 329.5 | 12.2 | 1.8 | 0.6 | 7.3 | 209.2 | 622.4 | - |  |  |  |  | 622.4
4. Gross fixed capital formation (Billions EP) | 6.6 | 65.7 | 13.1 |  | 11.8 | 10.5 | 23.7 | 131.4 |  |  |  |  |  | 131.4
of which:
4.a. for water supply |  | - |  |  | 11.8 | 0 |  | 11.8 |  |  |  |  |  | 11.8
4.b. for water sanitation |  | - |  |  |  | 10.5
5. Stocks of fixed assets for water supply (Billions EP) |  | - |  |  | 197.1 | 0
6. Stocks of fixed assets for water sanitation (Billions EP) |  | - |  |  |  | 132.5
7. Total use of water (Millions m3) | 61.6 | 1.4 | 8.6 | - | 8.2 | 4.4 |  |  | - |  | 5.8 | -
7.a. (U1) Total Abstraction | 61.6 | 0.7 | 8.6 | - | 8.2 | - |  |  |  |  | - | -
of which: 7.a.1- Abstraction for own use | - | - | 8.6 | - | - | - |  |  |  |  | 10.8 | -
7.b. Use of water received from other economic units | - | 0.7 | 0 | - | - | 4.4 |  |  | - |  | 5.8 | -
8. Total supply of water (Millions m3) | 27 | 0.7 | 8.6 | - | 8.2 | 4.4 |  | 235.9 | - |  | 4.1 | - |  | 240
8.a. Supply of water to other economic units | - | 0.7 | - | - | 5.7 | - |  | 6.4 | - |  | 3.7 | - |  | 10.1
8.b. Total returns | 27 | - | 8.6 | - | 2.5 | 4.4 |  | 229.5 |  |  | 0.4 | - |  | 229.9
9. Total (gross) emissions of COD (Thousand of tons) | 1026.8 | 27.7 | 157.2 |  | 95 | - |  |  |  |  | 366.7
Source: | Technical Mission Report to Egypt, April 2010, ESCWA.
Spreadsheet: 782453d1654065172-calculate-working-hours-with-different-work-shifts-sample
Sheet: Sheet1

Data |  |  |  |  |  |  | Special Case (lead to miscalculation) |  | Expected Results (Working Hours) |  |  |  | Working Hours per shift
Department | Staff ID | Name | Shift | Date | Time | Type |  |  | Department | Staff ID | Name | Shift | 2022-03-26 | 2022-03-27 | 2022-03-28 | 2022-03-29 | 2022-03-30 | 2022-03-31
Production Line | 0005 | Staff A | Night | 2022-03-26 | 23:03 | Start Work |  |  | Production Line | 0005 | Staff A | Night | 9.97 | 10.18 | 9.82 | 0 | 0 | *ALERT*
Production Line | 0005 | Staff A | Night | 2022-03-27 | 09:01 | Off Work |  |  | Office | 0006 | Staff B | Day | 10.17 | 0 | 9.82 | *ALERT* | 9.1 | 9.33
Production Line | 0005 | Staff A | Night | 2022-03-27 | 22:50 | Start Work |  |  | Packaging | 0010 | Staff C | Mid | 8.2 | 0 | 7.329999999999999 | 8.2 | *ALERT* | 4.5
Production Line | 0005 | Staff A | Night | 2022-03-28 | 09:01 | Off Work
Production Line | 0005 | Staff A | Night | 2022-03-28 | 23:12 | Start Work
Production Line | 0005 | Staff A | Night | 2022-03-29 | 09:01 | Off Work
Production Line | 0005 | Staff A | Night | 2022-03-31 | 22:41 | Start Work | <- Incomplete Data, without "Off Work" record
Office | 0006 | Staff B | Day | 2022-03-26 | 07:53 | Start Work
Office | 0006 | Staff B | Day | 2022-03-26 | 18:03 | Off Work
Office | 0006 | Staff B | Day | 2022-03-28 | 08:02 | Start Work
Office | 0006 | Staff B | Day | 2022-03-28 | 17:51 | Off Work
Office | 0006 | Staff B | Day | 2022-03-29 | 08:48 | Start Work
Office | 0006 | Staff B | Day | 2022-03-29 | 17:52 | Start Work | <-Wrongly punched lead to miscalculation, Should be "Off Work"
Office | 0006 | Staff B | Day | 2022-03-30 | 08:52 | Start Work
Office | 0006 | Staff B | Day | 2022-03-30 | 17:58 | Off Work
Office | 0006 | Staff B | Day | 2022-03-31 | 08:45 | Start Work
Office | 0006 | Staff B | Day | 2022-03-31 | 18:05 | Off Work
Packaging | 0010 | Staff C | Mid | 2022-03-26 | 08:53 | Start Work
Packaging | 0010 | Staff C | Mid | 2022-03-26 | 12:00 | Check In
Packaging | 0010 | Staff C | Mid | 2022-03-26 | 13:00 | Check In
Packaging | 0010 | Staff C | Mid | 2022-03-26 | 18:05 | Off Work
Packaging | 0010 | Staff C | Mid | 2022-03-28 | 08:54 | Start Work
Packaging | 0010 | Staff C | Mid | 2022-03-28 | 12:08 | Check In
Packaging | 0010 | Staff C | Mid | 2022-03-28 | 13:05 | Check In
Packaging | 0010 | Staff C | Mid | 2022-03-28 | 17:11 | Off Work
Packaging | 0010 | Staff C | Mid | 2022-03-29 | 08:50 | Start Work
Packaging | 0010 | Staff C | Mid | 2022-03-29 | 12:03 | Check In
Packaging | 0010 | Staff C | Mid | 2022-03-29 | 13:02 | Check In
Packaging | 0010 | Staff C | Mid | 2022-03-29 | 18:01 | Off Work
Packaging | 0010 | Staff C | Mid | 2022-03-30 | 09:00 | Start Work | <-Forgot to punch out "Off Work" lead to miscalculation
Packaging | 0010 | Staff C | Mid | 2022-03-31 | 09:00 | Start Work
Packaging | 0010 | Staff C | Mid | 2022-03-31 | 13:30 | Off Work
Spreadsheet: 715844d1611878049-sum-if-across-multiple-sheets-tabs-excel-donation-eba
Sheet: January

Donation Month | Pallet ID | Quantity | Weight (lbs) | Value ($) | Date Submitted to GM | Date Submitted to C-Ops | Approved by GM and C-Ops | PDF Created | [NAME] sent to Organization | Moved Pallets in Waste Tracker | Scheduled Pick-Up Date | Scheduled Pick-Up Time | Pallet Off-Site | Manifest Created | Manifest Closed | Organization
JAN | [NAME] | 416 | 688.53 | 8071.88 | 2021-01-25 00:00:00 | 2021-01-25 00:00:00 | Yes | Yes | Yes | Yes | 2021-01-28 00:00:00 | 10:00:00 |  |  |  | St. Mary's Food Bank
JAN | paXRLKvY27Z | 594 | 1176.72 | 9827.48 | 2021-01-22 00:00:00 | 2021-01-25 00:00:00 | Yes | Yes | Yes | Yes | 2021-01-28 00:00:00 | 10:00:00 |  |  |  | St. Mary's Food Bank
JAN | paXRLKDMZsD | 287 | 796.58 | 5597.41 | na | na | Yes | Yes | Yes | Yes | 2021-01-28 00:00:00 | 10:00:00 |  |  |  | St. Mary's Food Bank
JAN | paXRLKN5Q22 | 83 | 249 | 1571.19 | na |  | Yes | Yes | Yes | Yes | 2021-01-28 00:00:00 | 10:00:00 |  |  |  | St. Mary's Food Bank
Spreadsheet: 17475282-2e28-4a6a-9d7f-8c4212ef7b02
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-04-18 09:38:32.010000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.857 | 102.732 | 102.607 | 102.232 |  | and are added to price quote
4.625 | 102.113 | 101.988 | 101.863 | 101.488
4.5 | 101.195 | 101.07 | 100.945 | 100.57 |  | Note: | Refer To Price [NAME]
4.375 | 100.287 | 100.162 | 100.037 | 99.662 |  |  | For all Price Adjs
4.25 | 99.722 | 99.597 | 99.472 | 98.847
4.125 | 98.909 | 98.784 | 98.659 | 98.034
4 | 97.911 | 97.786 | 97.661 | 97.036
3.875 | 96.873 | 96.748 | 96.623 | 95.998
3.75 | 95.998 | 95.873 | 95.748 | 95.123
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 102.256 | 102.131 | 102.006 | 101.631
3.75 | 101.888 | 101.763 | 101.638 | 101.263
3.625 | 101.483 | 101.358 | 101.233 | 100.858
3.5 | 100.908 | 100.783 | 100.658 | 100.283
3.375 | 100.153 | 100.028 | 99.903 | 99.278
3.25 | 99.35 | 99.225 | 99.1 | 98.475
3.125 | 98.902 | 98.777 | 98.652 | 98.027 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-05-02 09:38:32.010000
30 DAY | 2014-05-17 09:38:32.010000
45 DAY | 2014-06-01 09:38:32.010000
60 DAY | 2014-06-16 09:38:32.010000
90 DAY | 2014-07-16 09:38:32.010000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: benjamin_rogers__1192__test model from Erin
Sheet: CSHFLO

Cash Flow
Project Revenues:
Project Operating Expenses:
Fuel Charges
O&M Expenses
Working Capital Changes
Return of Maintenance Reserve
Operating Cash Flow
Debt Service:
Interest Payments
Principal Payments
LC Charge on DSRF
Interest Income
Total Debt Service
Federal Income Taxes
NET A-T CASH FLOW | -86000
Debt Service Coverage Ratios
Debt Life
Long Term Debt
Interest
Principal
Long Term Debt Service
TOTAL DEBT SERVICE
DSC Ratios:
Long Term DSCR
Average
Minimum
Average Life
Total Debt Coverage Ratio
 |  | 0.5 | 1.5 | 2.5 | 3.5 | 4.5 | 5.5 | 6.5 | 7.5 | 8.5 | 9.5 | 10.5 | 11.5 | 12.5 | 13.5 | 14.5 | 15.5
Spreadsheet: 553538d1514393843-drop-down-list-populate-an-entry-sample-file-bsb-
Sheet: Sheet1

 |  |  | sdf
 | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | blue | green | blue | red |  | [NAME]
[NAME] | yellow | green | blue | red |  | [NAME]
[NAME] | red | green | yellow | blue
[NAME] | green | red | blue | blue
Spreadsheet: 0e6fa6ad-3538-471e-a497-0c0ae081b9cb
Sheet: Sheet1

Forms | Link in this workbook
A | Form A
B | Form B
C | Form C
D | Form D
E | Form E
F1 | Form F1
F2 | Form F2
G | Form G
H | Form H
I | Form I
J | Form J
K | Form K
L | Form L
M | Form M
N | Form N
Crosswalk of prior templates | Crosswalk of prior templates
Worksheets | Link in this workbook
A1 | A1
A2 | A2
A3 | A3
A4 | A4
A5 | A5
A6 | A6
A7 | A7
A8 | A8
A9 | A9
B1 | B1
B2 | B2
B3 | B3
B4 | B4
B5 | B5
B6 | B6
B7 | B7
D1 | D1
D2 | D2
E1 | E1
F1a | F1a
[NAME] | [NAME]
G2 | G2
H1 | H1
M1 | M1
Spreadsheet: 876308d1722989377-formula-to-multiply-cells-by-percentage-if-they-meet-2-conditions-if-and-formula-query-rev1
Sheet: Sheet1

 |  |  |  | 0.1 | 21 Enterprise
 |  |  |  | 0.2 | 22 Channar
 |  |  |  | 0.3 | 23 Lofty
1 | 21 Enterprise | 500 | 500 | 500
2 | 22 Channar | 700 | 700 | 700
3 | 23 Lofty | 900 | 900 | 900
4 | 21 Enterprise | 20 | 20 | 20
1 | 21 Enterprise |  |  |  |  | MULTIPLY C7 (no 1 ref in column A) BY 10% by looking up grey table "21 Enterprise"
2 | 22 Channar | 140 | 140 | 140 |  | MULTIPLY C8 (no 2 ref in column A) BY 20% by looking up grey table "22 Channar"
3 | 23 Lofty | 270 | 270 | 270 |  | MULTIPLY C9 (no 3 ref in column A) BY 30% by looking up grey table "23 Lofty"
4 | 21 Enterprise | 2 | 2 | 2 |  | MULTIPLY C10 (no 4 ref in column A) BY 10% by looking up grey table "21 Enterprise"
 |  | ^
 |  | Answer I want
Spreadsheet: 115816d1311308577-small-cross-worksheet-calculation-error-transaction-record-updated-
Sheet: Jay's Monthly

Month | Date | Amount ($) | Description |  | Total: | 931.59
1 | 2011-01-01 00:00:00 | 0 | Owed more than $200
1 | 2011-01-01 00:00:00 | 0 | Owed more than $200
2 | 2011-02-08 00:00:00 | 236.59 | Balanced the books up to today's date
3 | 2011-03-07 00:00:00 | 200 | Monthly
4 | 2011-04-01 00:00:00 | 295 | monthly + repaying EDP
5 | 2011-05-05 00:00:00 | 200 | monthly