tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 862421d1710160493-how-do-i-create-polynomial-coefficients-for-a-table-with-2-variable-inputs-polynomial-generation-v2
Sheet: Sheet1

 |  |  | Fan Speed
 |  |  | 1 | 0.8 | 0.6 | 0.4 | 0.2
 | Density Ratio | 0.2 | 0.5602681786444155 | 0.5242592146626477 | 0.4862250698137789 | 0.4459899534174349 | 0.4033571231574961
 |  | 0.4 | 0.7690471505528507 | 0.7462019507305976 | 0.7220719135659387 | 0.6965455120173826 | 0.6694979266780862
 |  | 0.6 | 0.8813066990653233 | 0.8688018306703822 | 0.8555936757206858 | 0.8416211872134858 | 0.8268160422508499
 |  | 0.8 | 0.9516895842186365 | 0.9464433274230571 | 0.9409020157935861 | 0.9350400378449242 | 0.9288287295834818
 |  | 1 | 1 | 1 | 1 | 1 | 1
 |  | 1.2 | 1.035229615944395 | 1.039166939513177 | 1.043325702175934 | 1.047725125390672 | 1.052386721527437
 |  | 1.4 | 1.062063465303166 | 1.069054263945055 | 1.076438232233882 | 1.084249498262037 | 1.092526257683161
 |  | 1.6 | 1.083185696627049 | 1.092609524244377 | 1.102563357540156 | 1.113093202310873 | 1.124250547560015
 |  |  |  | Fan Speed = | 0.5
 |  |  |  | Density Ratio = | 0.9
 |  |  |  | Result =
Spreadsheet: 33a75332-01a3-4772-bc19-d548a9d53806
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: |  |  | 2013-11-19 09:39:44.120000
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.875 | 102.625 | 102.5 | 102.375 | 102 |  | and are added to price quote
4.75 | 102.506 | 102.381 | 102.256 | 101.881
4.625 | 102.316 | 102.191 | 102.066 | 101.691 |  | Note: | Refer To Price [NAME]
4.5 | 101.961 | 101.836 | 101.711 | 101.336 |  |  | For all Price Adjs
4.375 | 101.069 | 100.944 | 100.819 | 100.194
4.25 | 100.466 | 100.341 | 100.216 | 99.591
4.125 | 99.698 | 99.573 | 99.448 | 98.823
4 | 98.739 | 98.614 | 98.489 | 97.864
3.875 | 97.723 | 97.598 | 97.473 | 96.848 |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 102.625 | 102.5 | 102.375 | 102
3.75 | 102.591 | 102.466 | 102.341 | 101.966
3.625 | 102.186 | 102.061 | 101.936 | 101.561
3.5 | 101.671 | 101.546 | 101.421 | 101.046
3.375 | 100.918 | 100.793 | 100.668 | 100.043
3.25 | 100.195 | 100.07 | 99.945 | 99.32
3.125 | 99.228 | 99.103 | 98.978 | 98.353 |  | 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 | 2013-12-03 09:39:44.120000
30 DAY | 2013-12-18 09:39:44.120000
45 DAY | 2014-01-02 09:39:44.120000
60 DAY | 2014-01-17 09:39:44.120000
90 DAY | 2014-02-16 09:39:44.120000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 219069d1362660983-auto-populate-a-sheet-from-data-on-another-sheet-0a1
Sheet: Employee 1

Employee 1 | PROJECTS
DEPT | SEASON | TASK | DUE DATE | START DATE | WEEK 2 | WEEK 3 | WEEK 4 | WEEK 5 | WEEK 6 | WEEK 7 | WEEK 8 | STATUS | PROJECT LEAD | NOTES
Dept. 1 | Summer 2013 | Task 1 | 2013-05-01 00:00:00 | 2013-04-01 00:00:00 | 2013-04-08 00:00:00 | 2013-04-15 00:00:00 | 2013-04-22 00:00:00 | 2013-04-29 00:00:00 | 2013-05-06 00:00:00 | 2013-05-13 00:00:00 | 2013-05-20 00:00:00 | Completed | Employee 1 | 0
Dept. 2 | Summer 2013 | Task 4 | 2013-05-01 00:00:00 | 2013-04-01 00:00:00 | 2013-04-08 00:00:00 | 2013-04-15 00:00:00 | 2013-04-22 00:00:00 | 2013-04-29 00:00:00 | 2013-05-06 00:00:00 | 2013-05-13 00:00:00 | 2013-05-20 00:00:00 | Completed | Employee 1 | 0
Spreadsheet: 648035d1572854411-fill-in-some-cells-on-the-right-on-the-spreadsheet-based-on-the-values-on-the-left-simplifiednew
Sheet: Sheet1

 | ID | Land cover code | % Area |  |  |  |  |  | Land Cover Code
 | 242 | 2 | 0.4568468502657684 |  |  |  |  | ID | 1 | 2 | 10 | 50 | 1000
 | 242 | 10 | 1.216526495532143 |  |  |  |  | 242 |  | 0.4568468502657684 | 1.216526495532143
 | 243 | 2 | 1.397453682610225 |  |  |  |  | 243 |  | 1.397453682610225 | 4.445956560342132
 | 243 | 10 | 4.445956560342132 |  |  |  |  | 244 |  | 0.3059825137746268 | 9.740988013616573
 | 244 | 2 | 0.3059825137746268 |  |  |  |  | 245 |  | 3.785455156193662 | 10.47160395389068
 | 244 | 10 | 9.740988013616573 |  |  |  |  | 246 |  | 0.3904610464177835 | 17.94489393331057
 | 245 | 2 | 3.785455156193662 |  |  |  |  | 247 |  |  | 17.70276664024997 | 4.999971265960443
 | 245 | 10 | 10.47160395389068 |  |  |  |  | 248 |  |  | 12.02863742108334 | 14.90978434213281
 | 246 | 50 | 0.140681023951422 |  |  |  |  | 249 |  |  | 2.212629555635569 | 27.17561282670725
 | 246 | 2 | 0.3904610464177835 |  |  |  |  | 250
 | 246 | 10 | 17.94489393331057 |  |  |  |  | 251
 | 247 | 50 | 4.999971265960443 |  |  |  |  | 252
 | 247 | 10 | 17.70276664024997 |  |  |  |  | 253
 | 248 | 10 | 12.02863742108334 |  |  |  |  | 254
 | 248 | 50 | 14.90978434213281 |  |  |  |  | 255
 | 249 | 1000 | 1.793933705895907 |  |  |  |  | 302
 | 249 | 10 | 2.212629555635569 |  |  |  |  | 303
 | 249 | 50 | 27.17561282670725 |  |  |  |  | 304
 | 250 | 50 | 35.43648963613957 |  |  |  |  | 305
 | 251 | 1000 | 0.6759422746281205 |  |  |  |  | 306
 | 251 | 50 | 39.02009644821429 |  |  |  |  | 307
 | 252 | 10 | 7.681563893460766 |  |  |  |  | 308
 | 252 | 50 | 36.28388855324521 |  |  |  |  | 309
 | 253 | 50 | 48.24271018271166 |  |  |  |  | 310
 | 254 | 50 | 52.52908952112593 |  |  |  |  | 311
 | 255 | 50 | 21.87392884264985 |  |  |  |  | 312
 | 302 | 50 | 7.09436336111898 |  |  |  |  | 313
Spreadsheet: kevin_presto__20237__Product Type Totals by Quarter and Tenor
Sheet: chart data - power

COMMODITY | DEAL TYPE | QUARTER | Daily avg LT1M Qty | Daily avg 1M Qty | Daily avg GT1M Qty
Power | Capacity Forward | Q4 2001 | 0 | 51.02727272727273 | 139.3636363636363
Power | Forward | Q4 1999 | 0 | 0 | 0
Power | Forward | Q1 2000 | 35.50876119402985 | 337.2231940298508 | 148.4050149253731
Power | Forward | Q2 2000 | 53.96392537313433 | 256.4995970149254 | 590.9651641791045
Power | Forward | Q3 2000 | 92.34668656716418 | 554.1840149253732 | 1075.27547761194
Power | Forward | Q4 2000 | 181.2305970149254 | 1008.485955223881 | 2045.329149253731
Power | Forward | Q1 2001 | 451.7983582089552 | 1557.10847761194 | 1063.574582089552
Power | Forward | Q2 2001 | 546.8102537313433 | 1914.333 | 2601.574283582089
Power | Forward | Q3 2001 | 593.5098059701493 | 2864.488328358209 | 5314.539835820896
Power | Forward | Q4 2001 | 678.5726818181818 | 2844.237340909091 | 7439.395159090909
Power | Index Forward | Q1 2000 | 0.4964626865671641 | 1.649373134328358 | 0
Power | Index Forward | Q2 2000 | 0.01534328358208955 | 2.741044776119403 | 10.5890447761194
Power | Index Forward | Q3 2000 | 0.08186567164179104 | 2.471358208955224 | 12.23908955223881
Power | Index Forward | Q4 2000 | 0.2353731343283582 | 4.198313432835821 | 0
Power | Index Forward | Q1 2001 | 0.08186567164179104 | 0.3172388059701493 | 0
Power | Index Forward | Q2 2001 | 0 | 0 | 1.568746268656716
Power | Index Forward | Q3 2001 | 0 | 3.315611940298507 | 0
Power | Index Forward | Q4 2001 | 0.7167954545454545 | 4.293 | 0
Power | Option | Q2 2001 | 0 | 0.003194029850746269 | 0
Power | Option | Q3 2001 | 0 | 7.227746268656716 | 0
Power | Option | Q4 2001 | 0 | 5.089136363636364 | 0.005409090909090909
Power | Spread | Q2 2000 | 0 | 0 | 8.473208955223882
Power | Swap | Q3 2000 | 1.159507462686567 | 3.350641791044776 | 3.47
Power | Swap | Q4 2000 | 10.72546268656716 | 16.01144776119403 | 46.32919402985075
Power | Swap | Q1 2001 | 21.87916417910448 | 55.85867164179104 | 51.46089552238806
Power | Swap | Q2 2001 | 56.66649253731343 | 116.8812686567164 | 149.7444029850746
Power | Swap | Q3 2001 | 89.75658208955224 | 134.4176567164179 | 340.5861194029851
Power | Swap | Q4 2001 | 298.0390909090909 | 322.3600681818182 | 715.9905681818183
Spreadsheet: 869939d1716471294-formula-filter-test
Sheet: Results

Topic: | Early Learning
Number |  |  |  |  |  |  |  |  |  | 1 | No | **In theory what I want column A to show for this category, Early Learning, is just the ones in red which are the Yes. It would filter out the projects that say No.
 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  | Yes
 |  |  |  |  |  |  |  |  |  |  | Yes
 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  | Yes
 |  |  |  |  |  |  |  |  |  |  | Yes
 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  | Yes
 |  |  |  |  |  |  |  |  |  |  | Yes
 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  | Yes
 |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  | No
Spreadsheet: 0beb41b6-1ae5-4757-8554-6b73f7f667b1
Sheet: Sheet1

Description | AUN | County | District | Library | Municipalities | 2000 pop. | 2010 pop. | % change
PA0385 | 926510006 | PHILADELPHIA | PHILADELPHIA | FREE LIBRARY OF PHILADELPHIA | Philadelphia | 1517550 | 1526006 | 0.005572139303482587
PA0385 Total |  |  |  |  |  | 1517550 | 1526006 | 0.005572139303482587
Spreadsheet: 683655d1592872735-source-gets-auto-highlights-when-click-from-target-hyperlink
Sheet: Target

 | No | Customer
 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =IF(Source!C3="","",HYPERLINK(CONCATENATE("#","Source!C"&ROW()),Source!C3))
 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF: To make the Target blank, until something is entered
 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HYPERLINK: to create linkage from Source to Target
 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LINK LOCATION: CONCATENATE: To tell link it’s a local workbook (#) & combination to ROW()
 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CONCATENATE: ROW: Use the row & C (without specific cell, since this formula will be copied down) will point to the correct cell.
 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HYPERLINK: Friendly Name, use back the name as we entered from the source
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
Spreadsheet: 73409d1274077307-summarize-numbers-by-month-expenses
Sheet: Summary

Visas 2010
Name | Spouse | Childen | Centre | Date | Cost |  |  |  |  |  | Main | Spouse
aa | wife | 1 | LP | 2010-06-01 00:00:00 | 757 |  |  |  |  |  | 1 | 1
bb |  |  | VLC | 2010-08-01 00:00:00 | 357 |  |  |  |  |  | 1 | 0
cc | [NAME] | 3 | VLC | 2010-08-10 00:00:00 | 1000 |  |  |  |  |  | 1 | 1
dd | [NAME] | 1 | VLC | 2010-08-17 00:00:00 | 757 |  |  |  |  |  | 1 | 1
ee |  |  | Pakse | 2010-09-09 00:00:00 | 357 |  |  |  |  |  | 1 | 0
ff | Anna | 1 | Skills | 2010-09-15 00:00:00 | 757 |  |  |  |  |  | 1 | 1
gg | [NAME] | 3 | LP | 2010-09-15 00:00:00 | 1157 |  |  |  |  |  | 1 | 1
hh | Danika | 1 | LP | 2010-09-25 00:00:00 | 757 |  |  |  |  |  | 1 | 1
ii | Nicole | 1 | LP | 2010-09-15 00:00:00 | 757 |  |  |  |  |  | 1 | 1
jj |  |  | VLC | 2010-11-01 00:00:00 | 357 |  |  |  |  |  | 1 | 0
kk | [NAME] | 1 | Pakse | 2010-12-15 00:00:00 | 757 |  |  |  |  |  | 1 | 1
ll |  |  | VLC | 2011-01-01 00:00:00 | 357 |  |  |  |  |  | 1
[NAME] |  |  | Skills | 2011-01-25 00:00:00 | 357 |  |  |  |  |  | 1 | 0
nn |  |  | LP | 2011-01-26 00:00:00 | 357 |  |  |  |  |  | 1 | 0
oo |  |  | LP | 2011-01-26 00:00:00 | 357 |  |  |  |  |  | 1 | 0
pp | Lyne | 1 | VLC | 2011-03-03 00:00:00 | 757 |  |  |  |  |  | 1 | 1
qq | Charlene |  | Skills | 2011-04-25 00:00:00 | 557 |  |  |  |  |  | 1 | 1
rr |  |  | VLC | 2011-05-03 00:00:00 | 200 |  |  |  |  |  | 1 | 0
 |  |  |  |  | 10712
 |  | 2010 |  | 2011
 |  | 7770 |  | 2942
Spreadsheet: 105904d1303166785-drop-down-lists-prototype
Sheet: Sheet2

[NAME] for the first drop down list
...
Chapter_Master
Captain
[NAME]
Chaplain
Master_of_the_Forge
[NAME] for second drop down list with relivant numeric values by there side
Chapter Master
Column1 | Column2
Power armour | 0
[NAME] armour | 15
Terminator armour | 40
Captain [NAME]
Column1 | Column2
Power armour | 5
[NAME] armour | 20
Terminator armour | 15
[NAME]
Column1 | Column2
Power armour | 0
Terminator armour | 50
Chaplain Armour
Column1 | Column2
Power armour | 10
Terminator armour | 30
Master_of_the_Forge
Column1 | Column2
[NAME] armour | 15
Spreadsheet: 143443d1330425209-referecing-worksheets-and-returning-areas-eol_checker_new_angusdn
Sheet: caracal

Consistency check
GLO: HP Printer final assembly (DfX)
 | Inputs | Outputs | Outputs - Inputs
Technical quantities
Mass [kg] | 0,787 | 0,787 | 0
1 Steel and iron materials
Steel and iron materials (unspecified) [kg] | 0,0837 | 0,0837 | 0
5 Polymer materials
Plastics in packaging [kg] | 0,00364 | 0,00364 | 0
Polymer materials (unspecified) [kg] | 0,216 | 0,216 | 0
1.1 Steels / cast steel / sintered steel
Steels / cast steel / sintered steel (unspecified) [kg] | 0,269 | 0,269 | 0
2.1 Aluminium and aluminium alloys
Aluminium and aluminium alloys (unspecified) [kg] | 0,00189 | 0,00189 | 0
3.1 Copper
Copper (unspecified) [kg] | 0,00513 | 0,00513 | 0
3.4 Zinc alloys
Zinc alloys (unspecified) [kg] | 0,00483 | 0,00483 | 0
5.2 Thermoplastic elastomers
Thermoplastic elastomers (unspecified) [kg] | 7,52E-005 | 7,52E-005 | 0
5.3 Elastomers / elastomeric compounds
Elastomers / elastomeric compounds (unspecified) [kg] | 0,00154 | 0,00154 | 0
5.5 Polymeric compounds
[NAME] compounds (unspecified) [kg] | 0,00091 | 0,00091 | 0
5.1b Thermoplaste unfilled
Thermoplaste unfilled (unspecified) [kg] | 0,0403 | 0,0403 | 0
7.1 Modified organic natural materials
Modified organic natural materials (unspecified) [kg] | 0,0394 | 0,0394 | 0
7.2 Ceramic / glass
Ceramic / glass (unspecified) [kg] | 0,000831 | 0,000831 | 0
8.1 Electronics
Electronics (unspecified) [kg] | 0,00265 | 0,00265 | 0
Material declaration electronics
Aluminum (E) [kg] | 0,000148 | 0,000148 | 0
Aluminum oxide (Al2O3) (E) [kg] | 0,000105 | 0,000105 | 0
Antimony oxide ([NAME] trioxide) (Sb2O3) (E) [kg] | 5,23E-006 | 5,23E-006 | 0
Copper (E) [kg] | 0,00749 | 0,00749 | 0
Copper in alloy (E) [kg] | 0,00323 | 0,00323 | 0
Electrolyte (E) [kg] | 5,14E-005 | 5,14E-005 | 0
[NAME] resin (E) [kg] | 0,000415 | 0,000415 | 0
Ferrites (E) [kg] | 0,000102 | 0,000102 | 0
Glas (E) [kg] | 1,14E-007 | 1,14E-007 | 0
Gold (E) [kg] | 2,55E-005 | 2,55E-005 | 0
Inorganic flame retardants (E) [kg] | 1,27E-008 | 1,27E-008 | 0
Lead (E) [kg] | 2,5E-007 | 2,5E-007 | 0
Natural rubber (NR) (E) [kg] | 6,72E-005 | 6,72E-005 | 0
Nickel (E) [kg] | 4,93E-006 | 4,93E-006 | 0
Palladium in alloy (E) [kg] | 1,23E-005 | 1,23E-005 | 0
Paper (E) [kg] | 1,95E-005 | 1,95E-005 | 0
Phenol-Formaldehyde-Resin (PF) (E) [kg] | 9,03E-006 | 9,03E-006 | 0
Polyamide 6 (PA6) (E) [kg] | 7,8E-005 | 7,8E-005 | 0
Polybutylene terephthalate (PBT) (E) [kg] | 0,000451 | 0,000451 | 0
[NAME] sulfide (PPS) (E) [kg] | 3,08E-005 | 3,08E-005 | 0
Polyurethane (E) [kg] | 5,27E-005 | 5,27E-005 | 0
[NAME] chloride (PVC) (E) [kg] | 1,65E-006 | 1,65E-006 | 0
Silicon (E) [kg] | 1,47E-005 | 1,47E-005 | 0
Silicon dioxide (SiO2) (E) [kg] | 0,000525 | 0,000525 | 0
Silver (E) [kg] | 0,000164 | 0,000164 | 0
Silver in alloy (E) [kg] | 1,68E-005 | 1,68E-005 | 0
Tetrabromobisphenol A (TBBA) (E) [kg] | 4,83E-006 | 4,83E-006 | 0
Tin (E) [kg] | 3,11E-007 | 3,11E-007 | 0
Tin in alloy (E) [kg] | 8,79E-005 | 8,79E-005 | 0
Unalloyed steel (Fe-C) (E) [kg] | 1,11E-005 | 1,11E-005 | 0
Zinc (E) [kg] | 1,65E-008 | 1,65E-008 | 0
Spreadsheet: andy_zipper__192__DYNEGY-ICE VOL May22
Sheet: DD-Lookup

Dynegy DIrect
User Lookup
ENA |  |  | EPM |  |  | EGL |  |  | Count of Transaction ID
User Name | Real Name |  | User Name | Real Name |  | User Name | Real Name |  | Units | Total | DELIVERY | CONV
AFAIRLEY | [NAME] |  | CDEANEPM | [NAME] |  | AGROSSPHY | [NAME] |  | Barrel | 8 | Monthly
AGOSALIA | [NAME] |  | DBAUGHMANPHY | [NAME] |  | EGLSTHOM | [NAME] |  | Barrel per day | 1
AGROSS | [NAME] |  | EMETOYEREPM | [NAME] |  | LJACKSONPHY | [NAME] |  | Barrel per month | 206 | Monthly
AZIPPER | [NAME] |  | ENAPDADAM | [NAME] |  | WWHICKSPHY | Wade Hicks |  | [NAME] | 1
BGUILMINO | [NAME] |  | ENAPJLAVO | [NAME] |  | 0 | No Activity |  | [NAME] | 24 | Monthly | 42
BHENDRY | Brent Hendry |  | ENAPRHERN | [NAME] |  |  |  |  | GJ | 203
CDEANENA | [NAME] |  | ENAPSHAN | [NAME] |  |  |  |  | IPE mt | 10
CPENNIX | [NAME] |  | ENPSTHOM | [NAME] |  |  |  |  | LME Registered 20 mt LOT | 24
[NAME] | [NAME] |  | ESAIBIEPM | [NAME] |  |  |  |  | LME Registered 25 mt Lot | 530
DBAUGHMAN_PHY | [NAME] |  | GGUPTA_PHY | [NAME] |  |  |  |  | LME Registered 5 mt LOT | 6
DHYVL1 | [NAME] |  | JKINGEPM | [NAME] |  |  |  |  | LME Registered 6 mt Lot | 30
DSAMUELS | [NAME] |  | JSTEPENO_PHY | [NAME] |  |  |  |  | MMBtu | 2865
EMETOYER | [NAME] |  | KTHOMPSONEPM | [NAME] |  |  |  |  | MMBtu/Lots (Options) | 52 |  | 10000
ENECGERMANY | [NAME] |  | MCARSONEPM | [NAME] |  |  |  |  | mt | 1
ENECUILLA | [NAME] |  | NMISRA_PHY | Narsimha Misra |  |  |  |  | MWh | 867
ENEDADAM | [NAME] |  | PMAKKAIEPM | [NAME] |  |  |  |  | MWh (Canada) | 12
[NAME] | [NAME] |  | RSTALFORD_PHY | [NAME] |  |  |  |  | therm | 104
ENEHENDR | [NAME] |  | SPIWETZEPM | [NAME] |  |  |  |  | Thousand Board Feet | 1
ENEJARNO | [NAME] |  | TMAY_PHY | [NAME] |  |  |  |  | (blank)
ENEJMCKA | [NAME] |  | 0 | No Activity |  |  |  |  | [NAME]/month | 1 | Monthly
ENEJOLAV | [NAME] |  |  |  |  |  |  |  | IPE Barrels | 1
ENEJSHAN | [NAME] |  |  |  |  |  |  |  | Emission allowance | 1
ENEJTOWNSEND | [NAME] |  |  |  |  |  |  |  | Grand Total | 4948
ENEJUNEK | [NAME]
ENEMCKAY | [NAME]
ENEPEREI | [NAME]
ENERHERN | [NAME]
ENERING | [NAME]
ENESANDRA | [NAME]
ENESTHOM | [NAME]
ENETHUR | Patrice Mims-Thurston
ENEVVERS | [NAME]
ENEkelli | [NAME]
ESAIBIENA | [NAME]
GGUPTA_FIN | [NAME]
GWHALLEY | [NAME]
JARNOLD | [NAME]
[NAME] | [NAME]
JBELL1 | [NAME]
JKING1 | [NAME]
JLAVORATO | [NAME]
JMASSEY | [NAME]
JMASSEY1 | [NAME]
JSHANKMAN | [NAME]
JSTEPENO_FIN | [NAME]
JTHOME | [NAME]
KMCGOWAN | [NAME]
KTHOMPSON | [NAME]
LHANSEN | [NAME]
LJACKSON | [NAME]
LKITCHEN | [NAME]
MBRIDGES | [NAME]
MCARSONENA | [NAME]
MNETTEL | [NAME]
NMISRA_FIN | Narsimha Misra
PMAKKAIENA | [NAME]
PTHOMASENA | [NAME]
RHERNDON | [NAME]
RJAFRY | [NAME]
RSTALFORD_FIN | [NAME]
RTOMASKI | [NAME]
SPIWETZ | [NAME]
SSEVER | [NAME]
SSHACKLE | [NAME]
TJONES | [NAME]
TKUYKENDALL | Tori Kuykendall
TMAY_FIN | [NAME]
WGRESHAM | [NAME]
WWHICKSFIN | Wade Hicks
ENESTOREY | [NAME]
0 | No Activity
Spreadsheet: 195745d1353628062-dynamic-table-sizes-sales-report-2
Sheet: Sales Report

Sales Report
2012-09-14 00:00:00
Grouped by [NAME]
From 9/1/12 to Last
 |  |  |  |  |  | Sales %
 | Qty | Sales | Cost | Margin | Margin % | of Total
 | ----- | ------------ | ------------ | ------------ | -------- | --------
adn | 24 | 2630.96 | 806.54 | 1824.42 | 69.34 | 1.425
BAM | 8 | 692.99 | 201.01 | 491.98 | 70.99 | 0.375
BWD | 12 | 896.38 | 402.07 | 494.31 | 55.15 | 0.485
CSA | 22 | 1936.96 | 139.41 | 1797.55 | 92.8 | 1.049
HOUSE | 37 | 3990.35 | 4524.82 | -534.47 | -13.39 | 2.161
JDK | 24 | 4469.55 | 2774.67 | 1694.88 | 37.92 | 2.42
JFC | 17 | 1468.92 | 296.56 | 1172.36 | 79.81 | 0.795
JFC/SAF | 4 | 2799.96 | 2341.87 | 458.09 | 16.36 | 1.516
JMR | 9 | 654.96 | 206.7 | 448.26 | 68.44 | 0.355
[NAME] | 213 | 45439.96 | 38538.4 | 6901.56 | 15.19 | 24.604
JTF | 12 | 1018.88 | 185.92 | 832.96 | 81.75 | 0.552
JWT | 23 | 2987.81 | 2693.05 | 294.76 | 9.87 | 1.618
LMH | 2 | 144.99 | 13.85 | 131.14 | 90.45 | 0.079
rdr | 168 | 30165.44 | 25464.21 | 4701.23 | 15.58 | 16.334
RDR/JPG | 1 | 1199.99 | 1091.97 | 108.02 | 9 | 0.65
RDR/SMB | 9 | 3060.91 | 2711.75 | 349.16 | 11.41 | 1.657
RJM | 30 | 2096.3 | 391.24 | 1705.06 | 81.34 | 1.135
RVR | 44 | 3957.67 | 1152.57 | 2805.1 | 70.88 | 2.143
SAF | 259 | 31783.28 | 26801.11 | 4982.17 | 15.68 | 17.21
SAF/RDR | 2 | 3169.98 | 2736.77 | 433.21 | 13.67 | 1.716
SMB | 183 | 36414.29 | 30793.84 | 5620.45 | 15.43 | 19.717
SMB/RDR | 3 | 239.97 | 204.09 | 35.88 | 14.95 | 0.13
SML | 48 | 3461.42 | 1107.53 | 2353.89 | 68 | 1.874
 | 1154 | 184681.92 | 145579.95 | 39101.97 | 21.17
Spreadsheet: 774039d1648175848-excel-formula-using-concat-excel-example
Sheet: Sheet1

input | CONCATENATE | result
987456 | 0 | 9874560
12345 | 1 | 9874561
67890 | 2 | 9874562
 | 3 | 9874563
 | 4 | 9874564
 | 5 | 9874565
 | 6 | 9874566
 | 7 | 9874567
 | 8 | 9874568
 | 9 | 9874569
 |  | 123450
 |  | 123451
 |  | 123452
 |  | 123453
 |  | 123454
 |  | 123455
 |  | 123456
 |  | 123457
 |  | 123458
 |  | 123459
 |  | 678900
 |  | 678901
 |  | 678902
 |  | 678903
 |  | 678904
 |  | 678905
 |  | 678906
 |  | 678907
 |  | 678908
 |  | 678909
Spreadsheet: 823411d1679948503-minimize-formula-too-long-for-a-cell-excelforum
Sheet: Sheet1

 |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | Food cost
 |  |  |  |  |  |  |  |  | This is a copy of my bank statement
 |  |  |  |  |  |  |  |  | I want to add all the food market expenses for January in the correpondent cell [NAME]
 |  | 2023-04-01 00:00:00 | FRESH CAFE HAMILTON ON |  | -2.89
 |  | 2023-04-01 00:00:00 | FRESH CAFE HAMILTON ON |  | -61.29
 |  | 2023-05-01 00:00:00 | THE HOME DEPOT #7007 ANCASTER ON |  | -49.31
 |  | 2023-05-01 00:00:00 | THE HOME DEPOT #7007 ANCASTER ON |  | 22.58 |  |  |  | The formula that I'm using works but it is too long. Imagine If I go to another 5 supermarkets
 |  | 2023-06-01 00:00:00 | FOOD BASICS 687 HAMILTON ON |  | -39.44 |  |  |  | SUMIFS(R16C8:R50C8,R16C6:R50C6,"*"&"food"&"*")+SUMIFS(R16C8:R50C8,R16C6:R50C6,"*"&"farm"&"*")+SUMIFS(R16C8:R50C8,R16C6:R50C6,"*"&"metro"&"*")
 |  | 2023-08-01 00:00:00 | Amazon.ca Prime [NAME] |  | -11.29
 |  | 2023-08-01 00:00:00 | FOOD BASICS 836 HAMILTON ON |  | -57.75 |  |  |  | My questions are:
 |  | 2023-08-01 00:00:00 | ESSO CIRCLE K HAMILTON ON |  | -70.66
 |  | 2023-08-01 00:00:00 | FARM BOY #16 HAMILTON ON |  | -23.9 |  |  |  | 1) Can I write the the formula in one cell and call it. For example
 |  | 2023-09-01 00:00:00 | CDN TIRE STORE #00177 HAMILTON ON |  | -158.37
 |  | 2023-09-01 00:00:00 | BEACH ROAD STEEL SALES |  | -63.88 |  |  |  | SUMIFS(R16C8:R50C8,R16C6:R50C6 |  |  |  | Write this on cell R21C10 so my original formula becomes
 |  | 2023-09-01 00:00:00 | VALUE VILLAGE # 2045 HAMILTON ON |  | -30.43
 |  | 2023-10-01 00:00:00 | METRO 208 HAMILTON ON |  | -29.32 |  |  |  | R21C10,"*"&"food"&"*")+R21C10,"*"&"farm"&"*")+R21C10,"*"&"metro"&"*")
 |  | 2023-11-01 00:00:00 | MANCHU WOK WOK037 GRIMSBY ON |  | -15.42
 |  | 2023-11-01 00:00:00 | FOOD BASICS 836 HAMILTON ON |  | -37 |  |  |  | 2) Can I write the supermakets on array typ in one cell and call it. For Example
 |  | 1/13/2023 | BEACH ROAD STEEL |  | -28.1
 |  | 1/14/2023 | FOOD BASICS 836 |  | -95.87 |  |  |  | {food,farm,metro}   or |  | food
 |  | 1/14/2023 | VALUE VILLAGE # 2045 |  | -81.3 |  |  |  |  |  | farm
 |  | 1/17/2023 | ESSO CIRCLE K |  | -73.88 |  |  |  |  |  | metro
 |  | 1/18/2023 | LA LUNA RESTAURANT |  | -29.99
 |  | 1/19/2023 | TELEPHONE |  | -207.92 |  |  |  | 3) If 1 or 2 are possible, can I combine them
 |  | 1/20/2023 | FOOD BASICS 687 HAMILTON ON |  | -38.92