tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 87475d1287371311-looking-up-data-in-a-sql-database-using-each-item-in-a-column-as-a-parameter-example
Sheet: Sheet1

Ashfield | SELECT PRODUCTNAME FROM TABLE WHERE SUBURB = 'Ashfield' UNION ALL
Ashfield | SELECT PRODUCTNAME FROM TABLE WHERE SUBURB = 'Ashfield' UNION ALL
Auburn | SELECT PRODUCTNAME FROM TABLE WHERE SUBURB = 'Auburn' UNION ALL
Bankstown | SELECT PRODUCTNAME FROM TABLE WHERE SUBURB = 'Bankstown' UNION ALL
Bexley | SELECT PRODUCTNAME FROM TABLE WHERE SUBURB = 'Bexley' UNION ALL
Bonnyrigg Heights | SELECT PRODUCTNAME FROM TABLE WHERE SUBURB = 'Bonnyrigg Heights' UNION ALL
Burwood | SELECT PRODUCTNAME FROM TABLE WHERE SUBURB = 'Burwood' UNION ALL
Caringbah | SELECT PRODUCTNAME FROM TABLE WHERE SUBURB = 'Caringbah' UNION ALL
Casula | SELECT PRODUCTNAME FROM TABLE WHERE SUBURB = 'Casula' UNION ALL
Cronulla | SELECT PRODUCTNAME FROM TABLE WHERE SUBURB = 'Cronulla' UNION ALL
Cronulla | SELECT PRODUCTNAME FROM TABLE WHERE SUBURB = 'Cronulla' UNION ALL
[NAME] | SELECT PRODUCTNAME FROM TABLE WHERE SUBURB = '[NAME] UNION ALL
Eastwood | SELECT PRODUCTNAME FROM TABLE WHERE SUBURB = 'Eastwood' UNION ALL
Engadine | SELECT PRODUCTNAME FROM TABLE WHERE SUBURB = 'Engadine' UNION ALL
Fairfield | SELECT PRODUCTNAME FROM TABLE WHERE SUBURB = 'Fairfield' UNION ALL
Five Dock | SELECT PRODUCTNAME FROM TABLE WHERE SUBURB = 'Five Dock' UNION ALL
Five Dock | SELECT PRODUCTNAME FROM TABLE WHERE SUBURB = 'Five Dock' UNION ALL
[NAME] | SELECT PRODUCTNAME FROM TABLE WHERE SUBURB = 'Glebe' UNION ALL
Hinchinbrook | SELECT PRODUCTNAME FROM TABLE WHERE SUBURB = 'Hinchinbrook' UNION ALL
[NAME] | SELECT PRODUCTNAME FROM TABLE WHERE SUBURB = '[NAME] UNION ALL
Hurstville | SELECT PRODUCTNAME FROM TABLE WHERE SUBURB = 'Hurstville' UNION ALL
Kensington | SELECT PRODUCTNAME FROM TABLE WHERE SUBURB = 'Kensington' UNION ALL
Kingsgrove | SELECT PRODUCTNAME FROM TABLE WHERE SUBURB = 'Kingsgrove' UNION ALL
Lakemba | SELECT PRODUCTNAME FROM TABLE WHERE SUBURB = 'Lakemba' UNION ALL
Lewisham | SELECT PRODUCTNAME FROM TABLE WHERE SUBURB = 'Lewisham' UNION ALL
Liverpool | SELECT PRODUCTNAME FROM TABLE WHERE SUBURB = 'Liverpool' UNION ALL
Liverpool | SELECT PRODUCTNAME FROM TABLE WHERE SUBURB = 'Liverpool' UNION ALL
[NAME] | SELECT PRODUCTNAME FROM TABLE WHERE SUBURB = 'Marrickville' UNION ALL
Menai | SELECT PRODUCTNAME FROM TABLE WHERE SUBURB = 'Menai' UNION ALL
Spreadsheet: 102d42e0-b453-4384-824e-48a35ad7ed2a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20
INDICE DE PRECIOS A L CONSUMIDOR CORDOBA
Nivel General y Capitulos
Base 2003=100
Período | Nivel General | % | Alimentos y Bebidas | % | Indumentaria | % | [NAME]. Básicos | % | Equipamiento y [NAME]. del Hog. | % | Atencion medica y gs.p/ la salud | % | Transporte   y   Comunicaciones | % | Esparcimiento | % | Educacion | % | Otros bienes y servicios | %
 |  |  |  |  |  |  | [NAME] |  |  |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME]
PROMEDIO
GENERAL
AÑO 2005
ENE
FEB
MAR
ABR
MAY
JUN
JUL
AGO
SET
OCT | 114.58 | 0.7 | 117.49 | 0.7 | 116.27 | 1.2 | 108.83 | 0 | 115.42 | 1 | 110.8 | 0.1 | 110.66 | 0.4 | 114.7 | 1.2 | 124.17 | 3.7 | 117.43 | 0.1
NOV | 115.94 | 1.186943620178042 | 119.7 | 1.881011149885097 | 117.73 | 1.255697944439675 | 109.36 | 0.4869980703850132 | 116.44 | 0.883728989776472 | 111.51 | 0.640794223826731 | 110.92 | 0.2349539128863256 | 116.84 | 1.865736704446391 | 126.2 | 1.634855440122408 | 118.07 | 0.5450055352124679
DIC | 117.4 | 1.259272037260658 | 120.46 | 0.6349206349206327 | 118.69 | 0.81542512528668 | 109.56 | 0.1828822238478409 | 116.73 | 0.2490553074544977 | 112.92 | 1.264460586494479 | 111.58 | 0.5950234403173482 | 127.56 | 9.174940089010605 | 125.88 | -0.2535657686212431 | 118.83 | 0.6436859490132889
Fuente: I.N.D.E.C.
Spreadsheet: 856111d1705485795-find-the-index-of-last-zero-after-which-the-entries-start-increasing-help-with-formula-aligw
Sheet: Sheet1

 | 0 | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100 | 110 | 120 | 125 | 130 | 135 | 140 | 141 | 142 | 143 | 144 | 145 | 146 | 147 | 148 | 149 | 150 | Determined Index
Series 1 | 20 | 20 | 20 | 16 | 18 | 17 | 15 | 18 | 15 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20
series 2 | 20 | 20 | 20 | 19 | 18 | 18 | 19 | 19 | 17 | 18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 70
 | In series 1, there is a value 16 at index 30 which is below 18, so in this case, i would like to return 20 as the index.
Spreadsheet: 862903d1710476448-count-two-variables-from-a-table-including-a-monthly-drop-down-demo1
Sheet: Sheet1

 | Product Vs Location |  |  |  |  |  |  | Database |  |  |  |  | Data Validation
 | January | East | West | South | North | Central |  | # | Date | Location | Product |  | January
 | Trains | 2 |  |  |  | 1 |  | 165 | 2024-01-01 00:00:00 | East | Trains |  | February
 | Planes | 1 |  | 1 |  |  |  | 169 | 2024-01-15 00:00:00 | South | Planes |  | March
 | Automobiles |  |  |  |  |  |  | 170 | 2024-01-10 00:00:00 | Central | Trains |  | April
 | Bike |  |  |  |  |  |  | 171 | 2024-01-20 00:00:00 | East | Planes |  | May
 |  |  |  |  |  |  |  | 172 | 2024-01-28 00:00:00 | East | Trains |  | June
 |  |  |  |  |  |  |  | 173 | 2024-03-15 00:00:00 | South | Bike |  | July
 |  |  |  |  |  |  |  | 174 | 2024-03-15 00:00:00 | Central | Tranes |  | August
 |  |  |  |  |  |  |  |  |  |  |  |  | September
 |  |  |  |  |  |  |  |  |  |  |  |  | October
 |  |  |  |  |  |  |  |  |  |  |  |  | November
 |  |  |  |  |  |  |  |  |  |  |  |  | December
Spreadsheet: 773677d1647991032-take-duplicate-cells-with-different-results-and-place-on-one-line-excel-example-server-with-multiple-apps-defined
Sheet: Sheet1

 | Excel Example
 | Application | Server | Aux | Apps by Server
 | App1 | Server1
 | App2 | Server2
 | App3 | Server3
 | App4 | Server1
 | App5 | Server4
 | App6 | Server5
 | App7 | Server1
 | App8 | Server6
 | App9 | Server5
 |  | Server7
Spreadsheet: 186022d1349898610-running-toatal-in-more-then-1-cell-running-total-quicksnot-oeldere-
Sheet: Sheet1

week | Player | wins total | losses total | wins this week | losses this week
1 | [NAME] | 0 | 3 | 0 | 3 |  |  |  | Looking for a formula that will keep a running total in colum B and C every week colum D and E will change
1 | [NAME] | 1 | 2 | 1 | 2
1 | [NAME] | 2 | 1 | 2 | 1
1 | [NAME] | 3 | 0 | 3 | 0
2 | [NAME] | 0 | 3 | 0 | 3 |  |  | Value
2 | [NAME] | 1 | 2 | 1 | 2 |  | Rowlabels | Sum  wins total | Sum losses total | count wins total
2 | [NAME] | 2 | 1 | 2 | 1 |  | [NAME] | 9 | 0 | 3
2 | [NAME] | 3 | 0 | 3 | 0 |  | [NAME] | 6 | 3 | 3
3 | [NAME] | 0 | 3 | 0 | 3 |  | [NAME] | 3 | 6 | 3
3 | [NAME] | 1 | 2 | 1 | 2 |  | [NAME] | 0 | 9 | 3
3 | [NAME] | 2 | 1 | 2 | 1 |  | Eindtotal | 18 | 18 | 12
3 | [NAME] | 3 | 0 | 3 | 0
Spreadsheet: 821291d1678593213-percentage-of-lumpsum-shipment-cost-per-item-based-on-shipment-percentage-of-shipping-version-3
Sheet: Sheet1 (Manual Values)

Item # | Shipment # | Total Cost of Item | Percentage of Lumpsum Shipment Cost (Col E) per Shipment # (Col B) EXPECTED RESULT | Lumpsum Shipment Cost per item (Col D x Co I) | Total cost of item including the prorata share of the shipment cost in Col I (Col C + Col E) |  | Shipment # | Total Lumpsum Shipment Cost
1 | 12832613 | 5039 | 0.09194919893434546 |  |  |  | 12832613 | 16800
2 | 12832613 | 40763 | 0.7438232181307252 |  |  |  | 12855295 | 17500
3 | 12832613 | 2800 | 0.05109302580197803 |  |  |  | 12855296 | 20600
4 | 12855295 | 4100 | 0.1416724257083621 |  |  |  | 13001545 | 11000
5 | 12855295 | 3200 | 0.110573600552868 |  |  |  | 13079770 | 35000
6 | 12832613 | 1800 | 0.03284551658698587
7 | 12855295 | 14200 | 0.4906703524533518
8 | 12855296 | 6108 | 0.279811260250126
9 | 12832613 | 4400 | 0.08028904054596547
10 | 12855295 | 2620 | 0.09053213545266067
11 | 12855295 | 4820 | 0.1665514858327574
12 | 12855296 | 901 | 0.04127536763021668
13 | 12855296 | 7620 | 0.3490769160291355
14 | 13001545 | 3420 | 0.09216838247183744
15 | 12855296 | 3600 | 0.1649182280452609
16 | 12855296 | 3600 | 0.1649182280452609
17 | 13001545 | 15846 | 0.4270468387861801
18 | 13001545 | 1220 | 0.03287877971217593
19 | 13079770 | 1888 | 0.1173837353892067
20 | 13001545 | 14340 | 0.3864604107152482
21 | 13079770 | 2568 | 0.1596617756776921
22 | 13079770 | 1888 | 0.1173837353892067
23 | 13001545 | 2280 | 0.06144558831455829
24 | 13079770 | 2600 | 0.1616513305147973
25 | 13079770 | 7140 | 0.4439194230290973
Spreadsheet: 873776d1720347490-how-to-find-total-of-working-hours-from-a-single-cell-kvemperor-working-hours-shop-aligw
Sheet: ΠΡΟΣΩΠΙΚΟ

 |  | ΣΚΦ |  |  | ΦΑΙΔΡΑ
 |  | YAKIMIDI OLESSYA |  |  | SULTANOVA ZULFIΙA
 | 2 | [NAME] ΡΑΦΑΕΛΑ |  | 2 | YAKIMIDI OLESSYA
 | 3 | KROSHKINA MARIA |  | 3 | ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ
 | 4 | ΒΛΑΧΟΥ ΠΑΝΑΓΙΩΤΑ |  | 4 | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ
 | 5 | ΚΑΛΛΟΥ ΓΕΩΡΓΙΑ
 | 6 | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ
 | 7 | ΟΙΚΟΝΟΜΟΥ ΒΑΡΒΑΡΑ
 | 8 | ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ
 | 9 | ΚΟΝΙΣΣΗ ΙΟΥΛΙΑΝΗ
Spreadsheet: 684328d1593294836-counting-formula-in-descending-order2-countif-example
Sheet: Sheet4

CLASS | NAME | Custom.Index
A | AMY | 1
A | AMY | 2
A | AMY | 3
A | AMY | 4
A | AMY | 5
A | AMY | 6
A | AMY | 7
A | AMY | 8
A | AMY | 9
A | AMY | 10
A | AMY | 11
B | [NAME] | 1
B | [NAME] | 2
B | [NAME] | 3
B | [NAME] | 4
B | [NAME] | 5
B | [NAME] | 6
B | [NAME] | 7
B | AMY | 1
B | AMY | 2
B | AMY | 3
B | AMY | 4
B | AMY | 5
B | AMY | 6
B | AMY | 7
B | AMY | 8
B | AMY | 9
B | AMY | 10
C | MARY | 1
C | MARY | 2
C | MARY | 3
C | MARY | 4
C | MARY | 5
C | MARY | 6
C | MARY | 7
A | MARY | 1
A | MARY | 2
A | MARY | 3
A | MARY | 4
A | MARY | 5
A | MARY | 6
A | MARY | 7
A | MARY | 8
A | MARY | 9
A | MARY | 10
A | MARY | 11
A | MARY | 12
D | MARY | 1
D | MARY | 2
D | MARY | 3
D | MARY | 4
D | MARY | 5
D | MARY | 6
D | MARY | 7
A | STEVE | 1
A | STEVE | 2
A | STEVE | 3
A | STEVE | 4
A | STEVE | 5
A | STEVE | 6
C | STEVE | 1
C | STEVE | 2
C | STEVE | 3
C | STEVE | 4
C | STEVE | 5
Spreadsheet: 4f1af8bc-f38e-4d35-a6f6-cc2350798b7b
Sheet: (C) Gene lists

Identically enriched in ♂ supporting and interstitial cells
E12.5 |  | E13.5
Transcript cluster ID | Gene name | Transcript cluster ID | Gene name
10427049 | 6030408B16Rik | 10427049 | 6030408B16Rik
10350840 | Angptl1 | 10466304 | Dtx4
10497920 | Ankrd50 | 10507612 | Lepre1
10448925 | [NAME] | 10494595 | Notch2
10469581 | Etl4 | 10582649 | Pgbd5
10353192 | Eya1
10585398 | Gldn
10345065 | Gsta3
10403229 | Itgb8
10372028 | Plxnc1
10410039 | Ptch1
10506254 | Raver2
10533145 | Tpcn1
10441497 | Tulp4
10410931 | Vcan
10524878 | Vsig10
10346878 | Zdbf2
Identically enriched in ♀ supporting and stromal cells
E12.5 |  | E13.5
Transcript cluster ID | Gene name | Transcript cluster ID | Gene name
10584595 | 2610203C20Rik | 10584595 | 2610203C20Rik
10433709 | 2900011O08Rik | 10404376 | Agtr1a
10455919 | Adamts19 | 10485643 | AI314831
10485643 | AI314831 | 10502050 | Alpk1
10586865 | Aldh1a2 | 10600180 | Atp2b3
10439612 | Boc | 10439612 | Boc
10435948 | Ccdc80 | 10469404 | Cacnb2
10513190 | D630039A03Rik | 10503416 | Calb1
10464400 | E330013P04Rik | 10540359 | Cntn4
10559179 | E330027M22Rik | 10453747 | Colec12
10428912 | Fam84b | 10445544 | Crip3
10491732 | Fat4 | 10464400 | E330013P04Rik
10560481 | Fosb | 10559179 | E330027M22Rik
10453857 | Gata6 | 10568436 | Fgfr2
10347277 | Igfbp2 | 10530421 | Gabra4
10536611 | Kcnd2 | 10522324 | Gabrb1
10472034 | Lypd6 | 10453857 | Gata6
10519913 | Magi2 | 10438891 | Gm1968
10437885 | Myh11 | 10564237 | Gm9801
10578649 | Odz3 | 10442829 | Gng13
10498018 | Pcdh18 | 10580577 | Irx3
10400170 | Prkd1 | 10536611 | Kcnd2
10519717 | Sema3a | 10529937 | Kcnip4
10583242 | Sesn3 | 10522075 | Klhl5
10344897 | [NAME] | 10446928 | Ltbp1
10460057 | Tshz1 | 10472034 | Lypd6
10543306 | Tspan12 | 10519913 | Magi2
10431017 | [NAME] | 10531370 | Naaa
10548163 | Tulp3 | 10529656 | Nsg1
 |  | 10468869 | Prdx3
 |  | 10519717 | Sema3a
 |  | 10359161 | [NAME]
 |  | 10571567 | Sorbs2
 |  | 10344897 | [NAME]
 |  | 10443089 | Syngap1 §
 |  | 10443095 | Syngap1 §
 |  | 10413542 | Tkt
 |  | 10460057 | Tshz1
 |  | 10509273 | Wnt4
 |  | 10456756 | [NAME]
 |  | 10490777 | Zfhx4
 |  | 10559790 | Zim1
"§" indicates genes considered "♀ E13.5 over-expressed in all cell types."
Identically enriched in ♂ interstitial and germ cells
E12.5 |  | E13.5
Transcript cluster ID | Gene name | Transcript cluster ID | Gene name
--- |  | 10355403 | Fn1
 |  | 10571601 | Pdlim3
Identically enriched in ♀ stromal and germ cells
E12.5 |  | E13.5
Transcript cluster ID | Gene name | Transcript cluster ID | Gene name
--- |  | ---
Identically enriched in ♂ supporting and germ cells
E12.5 |  | E13.5
Transcript cluster ID | Gene name | Transcript cluster ID | Gene name
10467420 | Pdlim1 | 10410302 | E130120F12Rik
10489484 | Sdc4 | 10516994 | Fam76a
 |  | 10523674 | Nudt9
 |  | 10442057 | Riok2
 |  | 10580274 | Rnaseh2a
 |  | 10436945 | Slc5a3
 |  | 10566326 | Trim12
 |  | 10393098 | Wbp2
Identically enriched in ♀ supporting and germ cells
E12.5 |  | E13.5
Transcript cluster ID | Gene name | Transcript cluster ID | Gene name
--- |  | 10401267 | Dcaf5
 |  | 10570437 | Fbxo25
 |  | 10502240 | Npnt
Spreadsheet: 874900d1721405250-formula-that-will-concatenate-data-from-other-cells-test-07192024
Sheet: Sheet1

Press | SchedTime | Due Date | Job# | Line# | Customer | Master [NAME] | QTY | H | W | Material | Sides | PrintMode
[NAME] |  | 2024-07-19 00:00:00 | 234445 | 2 | SAVE | =IFERROR(F9& " "&D9& " "&E9& " ["&DAY(Table1[@[Due Date]])& "]",) | 10 | 30 | 30 | PAP-  444450 - 48X96 30PT STYRENE | 1 | Backlit
[NAME] |  | 2024-07-19 00:00:00 | 12333 | 1 | HHGJ | HHGJ 12333 1 [19] | 10 | 24 | 24 | ART-  4960 - ABERDEEN 6653 FABRIC BANNER SOFT | 1 | [NAME]
fabrivue.25 |  | 2024-07-20 00:00:00 | 149900 | 1-5 | BLST | BLST 149900 1-5 [20] | 100 | 30 | 30 | PAP- SO-  0017 - 50X99 20PT DEAD WHITE | 1 | [NAME]
Spreadsheet: 59886d1260404740-vlookup-to-remove-words-substitute-example-1-
Sheet: Sheet1

#1 Remove City from Team Name |  |  |  | count of words in col a
[NAME] | Desired Output |  | sort by length
New Orleans Saints | Saints | Saints | 6 | 3
New England Patriots | Patriots | Patriots | 8 | 3
[NAME] | [NAME] | [NAME] | 4 | 3
San Francisco 49ers | 49ers | 49ers | 5 | 3
New York Jets | Jets | Jets | 4 | 3
New Your Giants | Giants | Giants | 6 | 3
Tampa Bay Bucaneers | Bucaneers | Bucaneers | 9 | 3
Geen Bay Packers | Packers | Packers | 7 | 3
San Diego Chargers | Chargers | Chargers | 8 | 3
#1 Remove Team Name from City |  |  |  | 6
[NAME] | Desired Output |  |  | 2
New Orleans Saints | New Orleans | New Orleans | 11 | 3
New England Patriots | New England | New England | 11 | 3
[NAME] | St. Louis | St Louis | 8 | 3
San Francisco 49ers | San Francisco | San Francisco | 13 | 3
New York Jets | New York | New York | 8 | 3
New Your Giants | New York | New Your | 8 | 3
Tampa Bay Bucaneers | Tampa Bay | Tampa Bay | 9 | 3
Geen Bay Packers | Green Bay | Geen Bay | 8 | 3
San Diego Chargers | San Diego | San Diego | 9 | 3
3 Questions:
1. Can you sort by number of words/ length of string in Excel?
2. Can you use the same formula for 2 columns at the same time?
Spreadsheet: 785441d1656421117-returning-array-data-filtered-and-in-a-specific-format-sample-14-ans
Sheet: Sheet1

DATA_ARRAY |  |  |  |  |  |  |  |  |  | FORMULAS
 | Alpha | [NAME]
 | Beta
 | Gamma | [NAME] | Kiwi | Orange
 | Delta
 | Tau | Lemon | Grape
RETURNED
 | Alpha | [NAME]
 | Beta
 | Gamma | [NAME]
 | Gamma | Kiwi
 | Gamma | Orange
 | Delta
 | Tau | Lemon
 | Tau | Grape
Spreadsheet: 455727d1460475157-storage-tank-formula-issues-new-gallons_-barrels-strapping-chart-test-2-
Sheet: S3

 |  |  |  |  |  |  |  | STRAPPING TABLE |  |  |  |  |  |  |  | JOB REFERENCE #
 |  |  |  |  |  |  | FRACTIONS 1/16 (INCHES)
 |  |  | 1/16 |  | 3/16 |  | 5/16 |  | 7/16 |  | 9/16 |  | 11/16 |  | 13/16 |  | 15/16
 |  |  | 1/8 |  | 1/4 |  | 3/8 |  | 1/2 |  | 5/8 |  | 3/4 |  | 7/8 |  | 1
 | NAME PLATE INFORMATION |  |  |  |  | [NAME] |  |  |  | FT. |  | IN. |  | DECIMAL |  | NOMINAL/GALLONS |  |  |  | VOLUME
 | YEAR TANK BUILT |  |  |  |  | TANK SHELL HEIGHT |  |  |  |  |  |  |  |  |  | BOTTOM TO SHELL
 | MANUFACTER |  |  |  |  | DIAMTER OF TANK |  |  |  |  |  |  |  |  |  | CONE DEPTH BELOW 0'-0"
 | YEAR MODIFIED |  |  |  |  | HIGH LIQUID LEVEL
 | CLASSIFICATION |  |  |  |  | CONE DEPTH BELOW 0'-0" |  |  |  |  |  |  |  |  |  | SUMP RESIVOR/GALLONS
 | EDITION |  |  |  |  | CENTER COLUMN DIA. Φ |  |  |  |  |  |  |  |  |  |  |  | DEPTH
 | APPENDIX |  |  |  |  | INTERMEDIATE COLUMN Φ |  |  |  |  |  |  |  |  |  |  | FT. |  | FT.
 | MATERIAL (SHELL) |  |  |  |  | NUMBER OF COLUMNS |  |  |  |  |  |  |  |  |  |  | IN. |  | IN.
 | FT |  | FT |  | FT |  | FT |  | FT |  | FT |  | FT |  | FT |  | FT |  | FT
 | IN |  | IN |  | IN |  | IN |  | IN |  | IN |  | IN |  | IN |  | IN |  | IN
 | 40 |  | 42 |  | 44 |  | 46 |  | 48 |  | 50 |  | 52 |  | 54 |  | 56 |  | 58
 | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1
 | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2
 | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3
 | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4
 | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5
 | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6
 | 7 |  | 7 |  | 7 |  | 7 |  | 7 |  | 7 |  | 7 |  | 7 |  | 7 |  | 7
 | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8
 | 9 |  | 9 |  | 9 |  | 9 |  | 9 |  | 9 |  | 9 |  | 9 |  | 9 |  | 9
 | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10
 | 11 |  | 11 |  | 11 |  | 11 |  | 11 |  | 11 |  | 11 |  | 11 |  | 11 |  | 11
 | 41 |  | 43 |  | 45 |  | 47 |  | 49 |  | 51 |  | 53 |  | 55 |  | 57 |  | 59
 | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1
 | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2
 | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3
 | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4
 | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5
 | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6 |  | 6
 | 7 |  | 7 |  | 7 |  | 7 |  | 7 |  | 7 |  | 7 |  | 7 |  | 7 |  | 7
 | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 8
 | 9 |  | 9 |  | 9 |  | 9 |  | 9 |  | 9 |  | 9 |  | 9 |  | 9 |  | 9
 | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10
 | 11 |  | 11 |  | 11 |  | 11 |  | 11 |  | 11 |  | 11 |  | 11 |  | 11 |  | 11
Spreadsheet: 91722d1291390118-copy-cell-value-as-history-into-another-cell-cell_history
Sheet: Sheet1

 | Sallary 1: | 4000 |  | Money remained on card on 16th: | #N/A |  |  |  | Today: | 2010-12-24 00:00:00
 | Sallary 2: | 3000 |  | Money remained on card on 30th: | 1600 |  |  |  |  | 24
I do not want that column | Expends: |  |  | Grand total: | 5400
2010-11-01 00:00:00 | Gas | 100 |  | Intermediary total calculated on 16th: | ?????
2010-11-02 00:00:00 | Loan | 200
2010-11-10 00:00:00 | Rent | 300
2010-11-11 00:00:00 | Daycare | 400
2010-11-14 00:00:00 | product 5 | 500
2010-11-15 00:00:00 | product 6 | 600
2010-11-18 00:00:00 | product 7 | 700
2010-11-20 00:00:00 | product 8 | 800
2010-11-24 00:00:00 | product 9 | 900
2010-11-28 00:00:00 | product 10 | 900
Spreadsheet: 877024d1723715722-add-two-columns-for-all-combinations-lamlam28-add-for-combinations-365-aligw
Sheet: V2

 | Raw Data |  |  |  | Step 1 |  |  |  | Step 2 |  |  |  |  |  |  |  |  |  |  |  | Step 3
 | Same as V1 |  |  |  | Same as V1 |  |  |  | The steps are the same as V1, except we include the following condition for the add up the numbers in Column F and H for all possible combinations: |  |  |  |  |  |  |  |  |  |  |  | Same as V1
 |  |  |  |  |  |  |  |  | Number in Column F < Number in Column H
 |  |  |  |  | [NAME] for Column B |  | [NAME] for Column D
 |  |  |  |  | 30 |  | 50
 | 1 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No. to match | Return if exist in result per step 2
 | 3 |  | 6 |  | 3
 | 5 |  | 7 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 | 9 |  | 8 |  | 9 |  | 8 |  | 9 | 11 | 13 |  |  |  |  |  |  |  |  |  | 17 | Not Found
 | 11 |  | 10 |  | 11 |  | 10 |  | 11 | 13 | 15 | 19 |  |  |  |  |  |  |  |  | 23 | Not Found
 | 13 |  | 13 |  |  |  | 13 |  | 14 | 16 | 18 | 22 | 24 |  |  |  |  |  |  |  | 46 | 46
 | 14 |  | 17 |  | 14 |  | 17 |  | 18 | 20 | 22 | 26 | 28 |  | 31 |  |  |  |  |  | 54 | Not Found
 | 18 |  | 19 |  | 18 |  | 19 |  | 20 | 22 | 24 | 28 | 30 |  | 33 | 37 |  |  |  |  | 63 | 63
 | 22 |  | 21 |  | 22 |  | 21 |  | 22 | 24 | 26 | 30 | 32 |  | 35 | 39
 | 24 |  | 26 |  | 24
 | 27 |  | 27 |  | 27
 | 32 |  | 28 |  |  |  | 28 |  | 29 | 31 | 33 | 37 | 39 |  | 42 | 46 | 50 | 52 | 55
 | 33 |  | 32
 | 45 |  | 33 |  |  |  | 33 |  | 34 | 36 | 38 | 42 | 44 |  | 47 | 51 | 55 | 57 | 60
 | 48 |  | 37 |  |  |  | 37 |  | 38 | 40 | 42 | 46 | 48 |  | 51 | 55 | 59 | 61 | 64
 | 55 |  | 41 |  |  |  | 41 |  | 42 | 44 | 46 | 50 | 52 |  | 55 | 59 | 63 | 65 | 68
 | 56 |  | 43
 | 57 |  | 44 |  |  |  | 44 |  | 45 | 47 | 49 | 53 | 55 |  | 58 | 62 | 66 | 68 | 71
 | 61 |  | 52
Spreadsheet: 889621d1740501902-converting-decimals-to-dice-rolls-dice-limits_2
Sheet: Sheet1

 | 0.5477926779041045 | 0.4367489902157193 | 0.3466226332217783 | 0.5303073754276612 | 0.2491469340337321 | 0.6463583564874866 | 0.513186270935622 | 0.7792890097239141 | 0.5373486366995378 | 0.5805956467306749
formula | 42 | 34 | 26 | 41 | 23 | 45 | 36 | 53 | 41 | 42
s/b | 42 | 34 | 26 | 41 | 23 | 45 | 36 | 54 | 41 | 43
 |  |  |  |  |  |  | 1e dice |  | 2e dice
 |  | 0.027555555 | 11 |  |  |  | 1 | 1 | 1 | 1 |  |  | 0.2491469340337321 | 23
 |  | 0.05555555555555555 | 12 |  |  |  | 1 | 2 | 2 | 2
 |  | 0.08333333333333333 | 13 |  |  |  | 1 | 3 | 3 | 3
 |  | 0.1111111111111111 | 14 |  |  |  | 1 | 4 | 4 | 4
 |  | 0.1388888888888889 | 15 |  |  |  | 1 | 5 | 5 | 5
 |  | 0.1666666666666667 | 16 |  |  |  | 1 | 6 | 0 | 6
 |  | 0.1944444444444444 | 21 |  |  |  | 2 | 7 | 1 | 1
 |  | 0.2222222222222222 | 22 |  |  |  | 2 | 8 | 2 | 2
 |  | 0.25 | 23 |  |  |  | 2 | 9 | 3 | 3
 |  | 0.2777777777777778 | 24 |  |  |  | 2 | 10 | 4 | 4
 |  | 0.3055555555555556 | 25 |  |  |  | 2 | 11 | 5 | 5
 |  | 0.3333333333333333 | 26 |  |  |  | 2 | 12 | 0 | 6
 |  | 0.3611111111111111 | 31 |  |  |  | 3 | 13 | 1 | 1
 |  | 0.3888888888888889 | 32 |  |  |  | 3 | 14 | 2 | 2
 |  | 0.4166666666666667 | 33 |  |  |  | 3 | 15 | 3 | 3
 |  | 0.4444444444444444 | 34 |  |  |  | 3 | 16 | 4 | 4
 |  | 0.4722222222222222 | 35 |  |  |  | 3 | 17 | 5 | 5
 |  | 0.5 | 36 |  |  |  | 3 | 18 | 0 | 6
 |  | 0.5277777777777778 | 41 |  |  |  | 4 | 19 | 1 | 1
 |  | 0.5555555555555556 | 42 |  |  |  | 4 | 20 | 2 | 2
 |  | 0.5833333333333334 | 43 |  |  |  | 4 | 21 | 3 | 3
 |  | 0.6111111111111112 | 44 |  |  |  | 4 | 22 | 4 | 4
 |  | 0.6388888888888888 | 45 |  |  |  | 4 | 23 | 5 | 5
 |  | 0.6666666666666666 | 46 |  |  |  | 4 | 24 | 0 | 6
 |  | 0.6944444444444444 | 51 |  |  |  | 5 | 25 | 1 | 1
 |  | 0.7222222222222222 | 52 |  |  |  | 5 | 26 | 2 | 2
 |  | 0.75 | 53 |  |  |  | 5 | 27 | 3 | 3
 |  | 0.7777777777777778 | 54 |  |  |  | 5 | 28 | 4 | 4
 |  | 0.8055555555555556 | 55 |  |  |  | 5 | 29 | 5 | 5
 |  | 0.8333333333333334 | 56 |  |  |  | 5 | 30 | 0 | 6
 |  | 0.8611111111111112 | 61 |  |  |  | 6 | 31 | 1 | 1
 |  | 0.8888888888888888 | 62 |  |  |  | 6 | 32 | 2 | 2
 |  | 0.9166666666666666 | 63 |  |  |  | 6 | 33 | 3 | 3
 |  | 0.9444444444444444 | 64 |  |  |  | 6 | 34 | 4 | 4
 |  | 0.9722222222222222 | 65 |  |  |  | 6 | 35 | 5 | 5
 |  | 1 | 66 |  |  |  | 6 | 0 | 0 | 6