tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 886285d1736326332-summing-sales-data-for-individual-component-parts-summing-sales-data-for-individual-component-parts
Sheet: Sales

 |  |  |  |  |  |  |  |  |  |  |  |  | SUM | Use BYROW
SKU | Sales |  | Component |  |  |  | [NAME] |  |  |  | Convert to 1 col |  | each SKU | to fill SUM
SK-0001 | 5 |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
SK-0002 | 10 |  | SK-0002 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 |  | 20 | 20
SK-0003 | 15 |  | SK-0003 | 0 | 0 | 0 | 15 | 0 | 0 | 0 | 0 | 0 |  | 25 | 25
SK-0004 | 20 |  | SK-0004 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0 |  | 30 | 30
BOM-0001 | 5 |  | SK-0001 | SK-0002 | SK-0003 | SK-0004 | 5 | 5 | 5 | 5 | SK-0002 | 10 |  | 0 | 0
BOM-0002 | 5 |  | SK-0001 | SK-0003 | 0 | 0 | 5 | 5 | 0 | 0 | 0 | 0 |  | 0 | 0
BOM-0003 | 5 |  | SK-0002 | SK-0004 | 0 | 0 | 5 | 5 | 0 | 0 | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | SK-0003 | 15
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | SK-0004 | 20
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | SK-0001 | 5
 |  |  |  |  |  |  |  |  |  |  | SK-0002 | 5
 |  |  |  |  |  |  |  |  |  |  | SK-0003 | 5
 |  |  |  |  |  |  |  |  |  |  | SK-0004 | 5
 |  |  |  |  |  |  |  |  |  |  | SK-0001 | 5
 |  |  |  |  |  |  |  |  |  |  | SK-0003 | 5
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | SK-0002 | 5
 |  |  |  |  |  |  |  |  |  |  | SK-0004 | 5
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
Spreadsheet: 881599d1729706418-help-with-vlookup-formula-using-partial-matches-and-reference-table-example-for-excel-issue
Sheet: Sheet1

[NAME] | What the formula needs to give me | Line description |  | KEYWORD | CATEGORY
 | Per Diem | November 2023 Per Diem Invoice |  | Per Diem | Per Diem
 | Per Diem | SAW Cash Dep Reclass |  | Late | Late
 | Dispute | TBD-No remit |  | Damage | Damage
 | Dispute | SP |  | Dispute | Dispute
 | Per Diem | September 2024 Per Diem Invoice |  | Misc | Damage
 | Damage | 3RD PTY Invoice |  | CMS Misc 3RD Party | Damage
 | Dispute | $13790 paid 3/13/24 |  | SP | Dispute
 |  |  |  | paid | Dispute
 |  |  |  | pd | Dispute
 |  |  |  | applied | Dispute
 |  |  |  | overp | Dispute
 |  |  |  | 3RD PTY Invoice | Damage
 |  |  |  | Short Pay | Dispute
 |  |  |  | TBD | Dispute
 |  |  |  | reclass | Per Diem
Spreadsheet: 216b5582-e0fa-4d61-a484-83297a184095
Sheet: SF-424A (16)

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. | Previous Projects | 10.17
2.
3.
4.
5. | Totals
Section B - Budget Categories
6. | Object Class Categories |  | Grant Program, Function or Activity |  |  |  | Total (5)
 |  |  | Previous Projects | (47) | (48) | (49)
 | [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: 5f7a1c6e-ce70-439e-96cf-d97b8fc27515
Sheet: V+PRON+P+DET+N

 |  | Condition
[NAME] | FORM | TAG | FEATURES
(2:3:2:1) | yu&ominu | V | STEM|POS:V|IMPF|(IV)|LEM:'aAmana|ROOT:Amn|3MP
(2:3:2:2) | wna | PRON | SUFFIX|PRON:3MP
(2:3:3:1) | bi | P | PREFIX|bi+
(2:3:3:2) | [NAME] | DET | PREFIX|Al+
(2:3:3:3) | gayobi | N | STEM|POS:N|LEM:gayob|ROOT:gyb|M|GEN
(2:11:5:1) | tufosidu | V | STEM|POS:V|IMPF|(IV)|LEM:>afosadu|ROOT:fsd|2MP|MOOD:JUS
(2:11:5:2) | wA@ | PRON | SUFFIX|PRON:2MP
(2:11:6:1) | fiY | P | STEM|POS:P|LEM:fiY
(2:11:7:1) | [NAME] | DET | PREFIX|Al+
(2:11:7:2) | >aroDi | N | STEM|POS:N|LEM:>aroD|ROOT:ArD|F|GEN
(2:27:15:2) | yufosidu | V | STEM|POS:V|IMPF|(IV)|LEM:>afosadu|ROOT:fsd|3MP
(2:27:15:3) | wna | PRON | SUFFIX|PRON:3MP
(2:27:16:1) | fiY | P | STEM|POS:P|LEM:fiY
(2:27:17:1) | [NAME] | DET | PREFIX|Al+
(2:27:17:2) | >aroDi | N | STEM|POS:N|LEM:>aroD|ROOT:ArD|F|GEN
(2:31:6:1) | EaraDa | V | STEM|POS:V|PERF|LEM:EaraDa|ROOT:ErD|3MS
(2:31:6:2) | humo | PRON | SUFFIX|PRON:3MP
(2:31:7:1) | EalaY | P | STEM|POS:P|LEM:EalaY`
(2:31:8:1) | [NAME] | DET | PREFIX|Al+
(2:31:8:2) | mala`^}ikapi | N | STEM|POS:N|LEM:malak|ROOT:mlk|MP|GEN
(2:34:2:1) | qulo | V | STEM|POS:V|PERF|LEM:qaAla|ROOT:qwl|1P
(2:34:2:2) | naA | PRON | SUFFIX|PRON:1P
(2:34:3:1) | [NAME] | P | PREFIX|l:P+
(2:34:3:2) | lo | DET | PREFIX|Al+
(2:34:3:3) | mala`^}ikapi | N | STEM|POS:N|LEM:malak|ROOT:mlk|MP|GEN
(2:35:16:2) | takuwna | V | STEM|POS:V|IMPF|LEM:kaAna|ROOT:kwn|SP:kaAn|2D|MOOD:SUBJ
(2:35:16:3) | A | PRON | SUFFIX|PRON:2D
(2:35:17:1) | mina | P | STEM|POS:P|LEM:min
(2:35:18:1) | {l | DET | PREFIX|Al+
(2:35:18:2) | Z~a`limiyna | N | STEM|POS:N|ACT|PCPL|LEM:ZaAlim|ROOT:Zlm|MP|GEN
Spreadsheet: chris_germany__1840__DPLcapacitybymonth
Sheet: 7-99

DAYTON CAPACITY FOR JULY 1999
 |  |  |  |  |  | [NAME] | TOTAL
PIPE | RECEIPT | DELIVERED | DELIVERY POINT | FUEL | COMMODITY | DEL CHARGE | VARIABLE
ANR |  | 0 |  | 0.0458 | 0.0147 | 0 | 0.101
PEPL |  | 1436 | Pool to DPL gate or other point (milage) | 0.0554 | 0.0498 | 0 | 0.155
TXG |  | 2493 | zn SL or zn 1 to DPL gate in zn 4 | 0.0287 | 0.0409 | 0 | 0.094
TCO |  | 0 | Leach / Lebanon | 0.0223 | 0.0246 | 0 | 0.066
TRUNK |  | 12029 | ELA or WLA to TETCO or [NAME] | 0.0227 | 0.0174 | 0 | 0.059
TETCO |  | 11560 | Receipt from Trunkline to Market | 0.039 | 0.0871 | 0 | 0.163
Trunk |  | 0 | Bourbon / Tuscola | 0.0227 | 0.0174 |  | 0.059
Pepl |  | 0 | Gas City / Tetco / Lebanon | 0.009 | 0.0075 |  | 0.24
Tetco |  | 0 | Farmersville / Lebanon | 0.0043 | 0.0871 |  | 0.163
Trunk |  | 0 | Bourbon / Tuscola | 0.0227 | 0.0174 |  | 0.059
Pepl |  | 0 | [NAME] or Tco Maumee | 0.0135 | 0.01 |  | 0.035
 |  |  | 282 Miles
Trunk |  | 0 | Bourbon / Tuscola | 0.0227 | 0.0174 |  | 0.059
Pepl |  | 0 | MichCon / Consumers / Union | 0.018 | 0.0125 |  | 0.047
 |  |  | 347 - 350 Miles
 |  |  |  | 31 | Days | July '99
 |  |  | APPROMIMATE SST AVAILABLE FOR CES USE Daily:
 |  |  |  | 120000 | Daily SST |  | Monthly SST
 |  |  |  |  | Daily DPL | 950000 | Monthly DPL
Spreadsheet: 99563d1298175508-count-by-month-count_by_month-1-
Sheet: Sheet2

 |  | 2010-11-10 00:00:00 | 2010-12-10 00:00:00 | 2011-01-11 00:00:00 | 2011-02-11 00:00:00 | 2011-03-11 00:00:00 | 2011-04-11 00:00:00 | 2011-05-11 00:00:00 | 2011-06-11 00:00:00 | 2011-07-11 00:00:00 | 2011-08-11 00:00:00 | 2011-09-11 00:00:00 | 2011-10-11 00:00:00 | 2011-11-11 00:00:00 | 2011-12-11 00:00:00
Activity1 | Planned
 | Actual
Spreadsheet: 756777d1637770011-sumifs-to-sum-month-data-at-a-decreasing-rate-nov-sep-then-dec-sept-jan-sep-help-example1
Sheet: Sheet1 (2)

Org | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep
DA | 0.3333333333333333 | 0 | 0 | 1 | 0 | 0.3333333333333333 | 0.3333333333333333 | 0 | 0 | 1 | 0 | 0
DC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DF | 0.3333333333333333 | 0 | 0 | 0 | 0 | 0 | 0.3333333333333333 | 0 | 0.3333333333333333 | 0 | 0 | 0
DG | 0 | 0.3333333333333333 | 0.3333333333333333 | 0.3333333333333333 | 0 | 0 | 0 | 0 | 0.3333333333333333 | 0 | 0 | 0
DH | 0 | 0.3333333333333333 | 1 | 0.3333333333333333 | 0 | 0 | 1 | 0.3333333333333333 | 0 | 0 | 0.3333333333333333 | 0
Org | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep
DA
DC
DF
DG
DH
 | Colors illustrate what I'm trying to achieve: Bottom table - cell B14 outlined in Red, want to [NAME] top table's Row 4 (DA) of months Nov-Sep,
 | Cell C14 outlined in Blue, want to [NAME] top table's Row 4 (DA) of months Dec-Sep,
 | Cell D14 outline in [NAME], want to [NAME] top table's Row 4 (DA) of months Jan-Sep
 | NOTES: Months will always stay constant, always start at Oct, finish with Sep.  Thank you.
Spreadsheet: chris_stokley__3940__EES sensitivity reconciliation
Sheet: Sheet1

 |  | Book value |  |  |  |  |  | Sensitivities
Scenario | Delivery Date | Curve Price | Contract Price | Volume | Book value | Change in value |  | Curve shift | Value of new position | Total change
1 | 2001-08-31 00:00:00 | 40 | 35 | -10 |  | 0 |  | 0 | 0 | 0
2 | 2001-08-31 00:00:00 | 38 | 35 | -10
3 | 2001-08-31 00:00:00 | 38 | 35 | -5
4 | 2001-08-31 00:00:00 | 40 | 35 | -10
5 | 2001-08-31 00:00:00 | 50 | 35 | -8
6 | 2001-08-31 00:00:00 | 32 | 35 | -1
7 | 2001-08-31 00:00:00 | 43 | 35 | -5
8 | 2001-08-31 00:00:00 | 51 | 35 | -15
9 | 2001-08-31 00:00:00 | 58 | 35 | -10
10 | 2001-08-31 00:00:00 | 28 | 35 | -12
[NAME]:
Curve shift |  | [(prior contract price - current curve price) X prior volume] - prior day value
New position value |  | (current contract price - current curve price) X (current volume - prior volume)
Spreadsheet: 768382d1644943250-help-with-this-test-buy-random_test_v3
Sheet: Locations

A# | A.Name | Location | Stock
567 | Adios | zcxz | 3
568 | Adios | abcd | 5
569 | Adios | asdvasd | 2
570 | Adios | asdvxccx | 1
571 | Adios | [NAME] | 4
234 | Bye | wer | 4
6423234 | Cinco | pafyup23hyu | 23567
12498570 | Cuatro | 0987dvsaih | 341245
678 | Day | xcvvx | 43
890 | [NAME] | dfdzs34 | 0
654 | Dos | ndsvjknahr2h | 423342
654 | Dos | asd1313 | 123
987 | Eight | 2354halsfhlh3124 | 0
5678 | Five | 564lflzfn | 32
4567 | Four | 42pjhlfahslh | 6
4568 | Four | 42pjhlfahslh | 7
4569 | Four | 42pjhlfahslh | 8
4570 | Four | 42pjhlfahslh | 9
4571 | Four | 42pjhlfahslh | 10
345 | Goodbye | ert | 0
123 | Hi | qwe | 2
456 | Hola | asd | 32
210 | Lluvia | u4uwsafb | 124455
654 | Luna | oinasdf32 | 12345
876 | [NAME] | 098jsa | 543
321 | Nieve | vnxcnvlsd | 123123
789 | Night | 34fsed | 222
98 | Noche | sad4 | 123
1234 | One | 2[4jhpqsfhal | 1
432 | Rain | adbnln1 | 0
1235566234 | Seis | 09ugdwsoihpoi23h4r | 123
7890 | Seven | 054jlslshlt23 | 56234
6789 | Six | 69usdflsh | 231
543 | Snow | jbndlsn | 435
765 | Sol | 32fsdfv | 0
987 | Sun | cvcgh | 42
3456 | Three | 5wefzxclnkl23 | 5
418798471 | Tres | [NAME] | 1235678
2345 | Two | 143pjhashif1 | 3
986554 | Uno | 08isdjr | 123
Spreadsheet: c04d3444-64f2-47fd-b7c9-228b355c4a6d
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: |  |  | 2012-08-27 09:23:30.410000
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 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.875 | 101.59 | 101.465 | 101.34 | 100.965
3.75 | 101.424 | 101.299 | 101.174 | 100.799 |  | Note: | Refer To Price [NAME]
3.625 | 101.012 | 100.887 | 100.762 | 100.387 |  |  | For all Price Adjs
3.5 | 100.375 | 100.25 | 100.125 | 99.5
3.375 | 99.5 | 99.375 | 99.25 | 98.625
3.25 | 98.543 | 98.418 | 98.293 | 97.668
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | TIB Annual Mortgage Conference
 |  |  |  |  |  | October 3rd thru 5th
 |  |  |  |  |  | Register Now!!!
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.375 | 101.991 | 101.866 | 101.741 | 101.366
3.25 | 101.633 | 101.508 | 101.383 | 101.008
3.125 | 101.293 | 101.168 | 101.043 | 100.668
3 | 100.965 | 100.84 | 100.715 | 100.34
2.875 | 100.334 | 100.209 | 100.084 | 99.459
2.75 | 99.634 | 99.509 | 99.384 | 98.759
 |  |  |  |  |  | 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 | 2012-09-10 09:23:30.410000
30 DAY | 2012-09-25 09:23:30.410000
45 DAY | 2012-10-10 09:23:30.410000
60 DAY | 2012-10-25 09:23:30.410000
90 DAY | 2012-11-24 09:23:30.410000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 486094d1477322028-variable-lookup-of-data-across-different-tabs-while-skipping-blanks-sample-box-numbering-for-multi-station-process-10-23-16
Sheet: Station A

Station A
Product | Quantity | Expiration Date | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
SKU1 | 15 | 2017-10-10 00:00:00 | 5
SKU2 | 15 | 2017-10-20 00:00:00 | 2 |  | 2
SKU3 | 15 | 2017-10-30 00:00:00 |  |  | 5
[NAME] | 15
[NAME] | 15 | 2017-11-20 00:00:00 |  | 6
Spreadsheet: 629525d1561393917-help-with-a-string-of-if-statements-sample
Sheet: Borrower Grading

 | Borrower |  |  |  |  | Raw score | Weighting | Weighted
 | Property |  |  |  |  |  | factor | score
 | Financial Strength |  |  |  |  |  | 4
a | Base Case ICR≥1.50x (-1); ICR≥1.75x (0); ICR≥2.00x (+1); ICR≥2.25x (+2) |  |  |  |  | 1 | 2
b | LTV≤75% (-1); LTV≤70% (0); LTV≤62.5% (+1); LTV≤55% (+2) |  |  |  |  | 1 | 2
c | Downside Case DSCR cannot debt service (-1);Downside Case DSCR services IO (0); Downside Case DSCR services IO and partial principal (+1); Downside Case DSCR fully services (+2) |  |  |  |  | 1 | 1
d | Refinance limited cash equity (-1); Asset purchase limited cash equity (0); Refinance cash equity (+1); Asset Purchase cash equity (+2) |  |  |  |  | -1 | 1
 | Cashflow sustainability |  |  |  |  |  | 2.5
a | Average Tenant Grading <0 (-1); Average Tenant Grading ≥0 (0); Average [NAME] (+1); Average Tenant Grading ≥1.0 (+2) |  |  |  |  | 2 | 1
b | WAULT < maturity (-1); WAULT = maturity (0); WAULT >maturity + 2 years (+1); WAULT >maturity + 5 years (+2) |  |  |  |  | -1 | 2
c | Rent ≥110% ERV (-1); Rent = ERV (0); Rent ≤105% ERV (+1); Rent ≤110% ERV (+2) |  |  |  |  | 0 | 2
d | No Tenant Diversity (-1); [NAME] allows debt service with smaller tenant default (0); [NAME] allows debt service with largest tenant defaulted (+1); Tenants are investment grade (+2) |  |  |  |  | 2 | 1
 | Asset quality |  |  |  |  |  | 2
a | Poor demand dynamics (-1); Satisfactory demand dynamics (0); Good demand dynamics (+1); Superior demand dynamics (+2) |  |  |  |  | 1 | 2
b | Poor condition (-1); Satisfactory condition (0); Good condition (+1); Superior condition (+2) |  |  |  |  | 2 | 1
c | VPV ≤70% MV (-1); VPV ≤85% MV (0); VPV =MV (+1); VPV ≥MV (+2) |  |  |  |  | 0 | 1
 | Quality of Promoter |  |  |  |  |  | 1.5
a | No experience (-1); Limited experience (0); Good experience (+1); Superior experience (+2) |  |  |  |  | 2 | 2
b | No recourse (-1); Top sliced recourse (0); Full recourse HFWW (+1); Full recourse with worth (+2) |  |  |  |  | -1 | 1
c | ICB poor(-1); ICB no history (0); ICB interuption, but satisfactory explanation (+1); ICB strong (+2) |  |  |  |  | 0 | 1
d | Negative NW (-1); Minimal NW (0); Reasonable NW (+1); Superior NW (+2) |  |  |  |  | 0 | 1
e | Personal overall debt servicing ability : Weak (-1);  Adequate (0); Comfortable (+1); Strong (+2) |  |  |  |  | 1 | 2
 | Overall weighted borrower grade
 | Additional comments:
 | GRADE IS INDICATIVE UNTIL FINALISED VIA DRAWDOWN PROCESS AND UPDATED CREAC SHEET
 | Grading |  | Origination
 | Desriptor | Grade | Appetite |  | Borrower Grade
 | Strong | ≥1 | Positive |  | [NAME]
 | Good | ≥0.5 | Positive |  | Origination Appetite
 | Satisfactory | ≥0 | Cautious |  | Prepared by: |  | [NAME]
 | Weak | <0 | Negative |  | Date: |  | 2018-04-17 00:00:00
 | Default | Defaulted | Negative
Spreadsheet: 687577d1595283535-populate-a-spread-sheet-based-on-data-that-is-structured-differently-example-workbook-
Sheet: Data Collection 

Rejections
Assessment Date | Assessed By | Product | Type/Variety | Class | Packed On | Receival Temp | Qty Received | Qty Rejected | Unit Of Measure | Defect | Major Defect | Minor Defect | No Of Products With Defect Major | No Of Products With Defect Minor | Total Units Assessed | Total % Out Of Spec Major | Total Units Out of spec Minor | No. Ctns Used For Assessment | Qty Rejected | Supplier | Response
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BEEGEE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rose
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Verra
Spreadsheet: 742945d1628140426-input-date-calculate-in-condition-format-date-josephteh-1-
Sheet: Sheet3

Count of DATE |  |  |  |  |  |  |  | RESULT
NAME | DATE | Total |  |  |  |  |  | NAME | DATE | Total
AAA | 01/02/2021 | 1 |  |  |  |  |  | AAA | 01/02/2021 | 1
AAA | 01/03/2021 | 1 |  |  |  |  |  |  | 01/03/2021 | 1
AAA | 02/02/2021 | 1 |  |  |  |  |  |  | 02/02/2021 | 1
AAA | 03/02/2021 | 1 |  |  |  |  |  |  | 03/02/2021 | 1
AAA | 05/04/2021 | 1 |  |  |  |  |  |  | 05/04/2021 | 1
AAA | 06/05/2021 | 1 |  |  |  |  |  |  | 06/05/2021 | 1
AAA | 08/02/2021 | 1 |  |  |  |  |  |  | 08/02/2021 | 1
AAA | 08/03/2021 | 1 |  |  |  |  |  |  | 08/03/2021 | 1
AAA | 12/04/2021 | 1 |  |  |  |  |  |  | 12/04/2021 | 1
AAA | 15/03/2021 | 1 |  |  |  |  |  |  | 15/03/2021 | 1
AAA | 22/02/2021 | 1 |  |  |  |  |  |  | 22/02/2021 | 1
AAA | 22/03/2021 | 1 |  |  |  |  |  |  | 22/03/2021 | 1
AAA | 29/03/2021 | 1 |  |  |  |  |  |  | 29/03/2021 | 1
AAA | 30/07/2021 | 1 |  |  |  |  |  |  | 30/07/2021 | 1
BBB | 04/05/2021 | 1 |  |  |  |  |  | BBB | 04/05/2021 | 1
BBB | 09/07/2021 | 1 |  |  |  |  |  |  | 09/07/2021 | 1
BBB | 16/04/2021 | 1 |  |  |  |  |  |  | 16/04/2021 | 1
CCC | 07/07/2021 | 1 |  |  |  |  |  | CCC | 07/07/2021 | 1
DDD | 01/02/2021 | 1 |  |  |  |  |  | DDD | 01/02/2021 | 1
Grand Total |  | 19 |  |  |  |  |  | Grand Total |  | 19
Spreadsheet: 818148d1676622522-how-concatenate-cells-in-range-based-on-value-in-other-cell-range-question-how-concatenate-cells-in-range-based-on-value-in-other-cell-range
Sheet: Sheet1 (2)

Item# | Article 1 | Article 2 |  |  |  |  |  |  |  | Article # | Items
Item 1 | x | x |  |  |  |  |  |  |  |  |  | ◄ The result from the formula should be like the two cells G2:G3 (which is now static text)
Item 2 | x
Item 3 | x
Item 4 | x
Item 5 |  | x
Item 6
Item 7 |  | x
Spreadsheet: 814942d1674665083-pull-data-based-on-column-a-report-builder-sample
Sheet: DATA

 | Service Month |  | Service Year |  | Alameda County Office of Education | School, SARB, SART |  | [P64]-American Indian/Alaska Native | Am Indian/AK Nat. |  |  |  | African-American
 | January |  | 2023 |  | Alameda County Probation | General Supervision |  | [P64]-Chinese | Asian/Pacific Is. |  |  |  | White/Caucasian
 | February |  | 2024 |  | [NAME] | School, SARB, SART |  | [P64]-Japanese | Asian/Pacific Is. |  |  |  | Latino/Hispanic
 | March |  | 2024 |  | Centro De Servicios | Other |  | [P64]-Filipino | Asian/Pacific Is. |  |  |  | Asian/Pacific Is.
 | April |  | 2025 |  | City of Fremont Youth and Family Services | Other |  | [P64]-Korean | Asian/Pacific Is. |  |  |  | Afghan/Middle E.
 | May |  | 2026 |  | Conley-Caraballo High School | School, SARB, SART |  | [P64]-Vietnamese | Asian/Pacific Is. |  |  |  | Am Indian/AK Nat.
 | June |  | 2027 |  | Estrada (Delfina) Household | Family/Self |  | [P64]-Asian Indian | Asian/Pacific Is. |  |  |  | [NAME]
 | July |  | 2028 |  | Filipino Advocates for Justice | Other |  | [P64]-Laotian | Asian/Pacific Is. |  |  |  | Other/Unknown
 | August |  | 2029 |  | FLY Fresh Lifeliness for Youth | Other |  | [P64]-Cambodian | Asian/Pacific Is.
 | September |  | 2030 |  | [NAME] ([NAME]) and [NAME] ([NAME]) Household | Family/Self |  | [P64]-Other (Asian) | Asian/Pacific Is.
 | October |  | 2031 |  | Grand | ????? |  | [P64]-Black or African American | African-American
 | November |  | 2032 |  | [NAME] | School, SARB, SART |  | [P64]-Hispanic, Latino, or Spanish | Latino/Hispanic
 | December |  | 2033 |  | [NAME] | School, SARB, SART |  | [P64]-Middle Eastern/North African | Afghan/Middle E.
 |  |  |  |  | MidPen Housing Services | Other |  | [P64]-Native Hawaiian | Asian/Pacific Is.
 |  |  |  |  | NHUSD New Haven Unified School District | School, SARB, SART |  | [P64]-Guamanian | Asian/Pacific Is.
 |  |  |  |  | OLR Our Lady Of The Rosary Church | Other |  | [P64]-Samoan | Asian/Pacific Is.
 |  |  |  |  | Searles Elementary School | School, SARB, SART |  | [P64]-Other ([NAME]. Is) | Asian/Pacific Is.
 |  |  |  |  | UCFC Union City Family Center | Other |  | [P64]-White | White/Caucasian
 |  |  |  |  | UCPD Union City Police Department | Law Enforcement |  | [P64]-Other identified ethnic origin, ethnicity, or race | Other/Unknown
 |  |  |  |  |  |  |  | [P64]-Decline to state | Other/Unknown
 |  |  |  |  |  |  |  | [P64]-Multi-ethnic origin, ethnicity or race that includes American Indian/Alaska Native | [NAME]
 |  |  |  |  |  |  |  | [P64]-Multi-ethnic origin, ethnicity or race that does not include American Indian/Alaska Native | [NAME]
 |  |  |  |  |  |  |  | [P64]-Unknown | Other/Unknown
Spreadsheet: 166038d1341435603-count-if-problem-i-think-07-july-for-web
Sheet: AE01 Data Input Sheet

AE 01 ENGINE ASSEMBLY REPAIR RECORDS
Date | Engine Number |  | QTY | Part name
2012-07-02 00:00:00 | 0 | 0 | 0 | 0 | 0
Cause | [NAME] | W.L.T | O.L.T | F.L.T | Repaired By | Shipped ok by
0 | 0 | 0 | 0 | 0 | 0 | 0
Resp Area | [NAME] | Resp Shift | Where found | Viewed by | Associate informed | Training Level Judgement
0 | 0 | 0 | 0 | 0 | 0 | 0
Process Number (If AE resp') | Time Taken | If MC number | If DC Cast Date
0 | 0 | 0 | 0