tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0ff41e7c-0739-4647-a86e-adf706826342
Sheet: Sheet1

Table 6--Wheat: National average prices received by farmers by class (dollars per bushel), 9/16/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Month | Hard red winter |  | Soft red winter |  | Hard red spring |  | White
 | 2012/13 | 2013/14 | 2012/13 | 2013/14 | 2012/13 | 2013/14 | 2012/13 | 2013/14
June | 6.53 | 7.35 | 6.59 | 6.92 | 7.81 | 7.73 | 6.61 | 7.29
July | 7.74 | 7.04 | 7.84 | 6.55 | 8.41 | 7.29 | 7.76 | 7.19
August | 7.97 |  | 8.3 |  | 8.32 |  | 7.66
September | 8.36 |  | 8.38 |  | 8.42 |  | 7.99
October | 8.43 |  | 8.35 |  | 8.6 |  | 8.1
November | 8.49 |  | 8.34 |  | 8.69 |  | 8.14
December | 8.2 |  | 8.19 |  | 8.5 |  | 7.99
January | 8.02 |  | 7.9 |  | 8.38 |  | 8.03
February | 7.75 |  | 7.78 |  | 8.11 |  | 8.05
March | 7.5 |  | 7.46 |  | 7.94 |  | 8.05
April | 7.49 |  | 7.42 |  | 7.91 |  | 7.71
May | 7.56 |  | 7.31 |  | 7.86 |  | 7.42
Source: USDA, National Agricultural Statistics Service, Agricultural Prices.
Date run: 9/13/2013
Spreadsheet: 676812d1588992391-need-help-to-edit-the-formula-test-how-to-find-the-average-cost-when-i-input-the-new-qty_-calculation-090520
Sheet: averagecost

What will be  the average cost  if I input the new quantity?
EXPECTED AVERAGE PRICE | Rate in which bought first | QTY | CURRENT MKT PRICE | RATE YOU WANT TO AVERAGEOUT | NEW QUANTITY TO BE PURCHASED
? | 10 | 20 | 7 | 8 | 40
 |  |  | A3 | =(C3*B3)+(C3*D3)/F3
 |  |  |  | '=(C3*B3)+(C3*D3)/F3 |  | Gives me   8.50  which is wrong
 |  |  |  |  |  | pls look at the table underneath
 |  |  |  | this formula does not work. How to edit the formula?
 | QTN is based upon this problem.I need a reverse formula.
How many stocks should I purchase afresh to bring down the average cost?
 | Rate in which bought first | QTY | CURRENT MKT PRICE | RATE YOU WANT TO AVERAGEOUT | NEW QUANTITY TO BE PURCHASED
 | 10 | 20 | 7 | 8
 |  |  |  |  | '=C18*(B18-E18)/(E18-D18)
 |  | A3 | =(C3*B3)+(C3*D3)/F3
 |  |  | '=(C3*B3)+(C3*D3)/F3 |  | Gives me   8.50  which is wrong
 |  |  | this formula does not work. How to edit the formula?
Spreadsheet: 164230d1340704589-excel-2007-what-formula-and-how-should-i-use-it-vlookup-or-indext-or-diet-plan-3-aussietommyson2
Sheet: monday 

food name | grams per unit of measure | Alternate grams | Multiplier | grams | Measurements |  | Calories | Protein | Fat | Carbs | Fibre
Quaker,  Oats |  | 54
Quaker,  Oats
Abbott's Bread: Harvest Seeds & Grains |  | 21
Abbott's Bread: Harvest Seeds & Grains
[NAME], Crunchy Oats |  | 6.25
Spreadsheet: 848474d1699208983-how-to-filter-select-specific-strings-from-a-big-database-if-and-or-search-left-example-for-forum-5-nov-2023-cleaned-up
Sheet: Forum (3)

Some examples for strings that occur in the big data sheet (80 columns; 900 rows) |  |  |  |  |  |  |  |  |  | Strings |  | Intro | claiming
All the red CELLS to be excluded from the selection below
Apparatus for controlling a flow of molten source material | Apparatus for controlling something different | A method for controlling a flow |  |  |  |  |  |  |  | Method |  | A | according to claim
A method of improving a measurement of a parameter of interest | A method of improving a measurement of a parameter of interest | A method as claimed in claim 1 |  |  |  |  |  |  |  | A method |  | An | as claimed
A lithographic apparatus | A lithographic apparatus comprising: [NAME] and the processing arrangement of claim XXX. | Exposure apparatus |  |  |  |  |  |  |  | The method |  |  | according to any of the preceeding claim
An apparatus to perform the method of any of claims 1 to 14. | An apparatus | An apparatus, comprising a component
Method for control a flow | Method for controlling a flow according to claim 1 | The method for controlling a flow according to claim 1 or 2
An apparatus according to claim 1 | An apparatus as claimed in claim 1 | An apparatus according to any of the preceding claims
 |  |  |  |  |  |  |  |  |  |  |  |  | Claiming2
Apparatus for controlling a flow of molten source material | Apparatus for controlling something different | A method for controlling a flow |  |  |  |  |  |  |  | Method |  | A | according to claim
A method of improving a measurement of a parameter of interest | A method of improving a measurement of a parameter of interest | A method as claimed in claim 1 |  |  |  |  |  |  |  | A method |  | An | as claimed
A lithographic apparatus | A lithographic apparatus comprising: [NAME] and the processing arrangement of claim XXX. | Exposure apparatus |  |  |  |  |  |  |  | The method |  |  | according to any of the preceeding claim
An apparatus to perform the method of any of claims 1 to 14. | An apparatus | An apparatus, comprising a component
Method for control a flow | Method for controlling a flow according to claim 1 | The method for controlling a flow according to claim 1 or 2
An apparatus according to claim 1 | An optical arrangement as claimed in claim 1 | An apparatus according to any of the preceding claims
Spreadsheet: 138640d1327776032-sum-data-with-criterias-projectsummary_muralidaran
Sheet: Sheet1

 |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue
Bay | Criteria | 2012-01-01 00:00:00 | 2012-01-02 00:00:00 | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 2012-01-05 00:00:00 | 2012-01-06 00:00:00 | 2012-01-07 00:00:00 | 2012-01-08 00:00:00 | 2012-01-09 00:00:00 | 2012-01-10 00:00:00 | 2012-01-11 00:00:00 | 2012-01-12 00:00:00 | 2012-01-13 00:00:00 | 2012-01-14 00:00:00 | 2012-01-15 00:00:00 | 2012-01-16 00:00:00 | 2012-01-17 00:00:00 | 2012-01-18 00:00:00 | 2012-01-19 00:00:00 | 2012-01-20 00:00:00 | 2012-01-21 00:00:00 | 2012-01-22 00:00:00 | 2012-01-23 00:00:00 | 2012-01-24 00:00:00 | 2012-01-25 00:00:00 | 2012-01-26 00:00:00 | 2012-01-27 00:00:00 | 2012-01-28 00:00:00 | 2012-01-29 00:00:00 | 2012-01-30 00:00:00 | 2012-01-31 00:00:00
Bay 1 | Planned | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
Bay 1 | Achieved | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
Bay 2 | Planned | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32
Bay 2 | Achieved | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32
Bay 3 | Planned | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33
Bay 3 | Achieved | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33
 |  |  | Up To 1st Tue |  | From 1st Wed to 2 nd Tue |  | From 2nd Wed to 3rd Tue
 |  |  | 2012-01-01 00:00:00 | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 2012-01-10 00:00:00
 |  |  | Planned | Achieved | Planned | Achieved
 |  | Bay 1 | 6 | 6 | 49 | 49
 |  | Bay 2 | 9 | 9 | 56 | 56
 |  | Bay 3 | 12 | 12 | 63 | 63
Spreadsheet: 859259d1707721399-rank-and-count-values-in-a-range-from-the-same-range-across-multiple-sheets-rank-and-count-dj
Sheet: 4

Rep
Tom5
Abigail1
Holden
Persephone
Beckett
Thalia
Rhys
Callista
Dax
Isolde
Sawyer
Marigold
Phoenix
Zephyr
Gideon
Elara
Cassius
[NAME]
Apollo
Bob2
Spreadsheet: 145497d1331622221-excel-2007-multi-layered-list-multi-layered-list
Sheet: Complete list

EAF
France Cluster
Mayotte
Longoni
Reunion
Port Reunion
[NAME]
Kenya
Mombasa
Nairobi
Thika
Rwanda
Kigali
Tanzania, United Republic Of
Dar Es Salaam
Shinyanga
[NAME]
Zanzibar
Uganda
Kampala
Mauritius Cluster
Comoros
Mutsamudu
Madagascar
Antananarivo
Antsiranana
Mahajanga
Nosy Be Hell Ville
Toamasina (Tamatave)
Tolanaro (Fort Dauphin)
Toliara
[NAME]
Port Louis
Seychelles
Victoria
SAF
[NAME]
[NAME]
Blantyre
Lilongwe City
Mozambique
Beira
Maputo
Nacala
Pemba
Quelimane
Zambia
Lusaka
Zimbabwe
Bulawayo, Condep
Gweru
Harare
Mutare
South Africa Cluster
Botswana
Gaborone City Centre
[NAME]
Maseru City Centre
Namibia
Luderitz
Walvis Bay
South Africa
[NAME]
Cape Town
Durban
East London
Johannesburg
Port Elizabeth
Pretoria
Richards Bay
Swaziland
Matsapha, [NAME]
WAF
Angola Cluster
Angola
[NAME]
[NAME]
Luanda
Namibe
Soyo
[NAME]
Cameroon
Douala
Ngaoundere
Equatorial Guinea
Bata
Malabo
Gabon
Libreville
[NAME]
Sao Tome
Sao Tome
CWA Cluster
Benin
Cotonou
[NAME]
[NAME]
Ouagadougou
Ghana
Kumasi
Takoradi
Tema
Nigeria
Apapa
Onne
Tin Can Island - PTML
Tin Can Island - Sifax
Tin Can Island - TICT
Togo
Lome
Dem Republic of Congo Cluster
Congo
[NAME]
Congo, Democratic Republic Of
Boma
Kinshasa
Matadi
[NAME]
Guinea
Conakry
Liberia
Monrovia
Sierra Leone
Freetown
Ivory Coast Cluster
[NAME]
Abidjan
[NAME]
Senegal Cluster
Cape Verde
[NAME]
Praia
Gambia
Banjul
Guinea-Bissau
[NAME]
[NAME]
Bamako
Mauritania
Nouadhibou
[NAME]
Senegal
[NAME]
Africa
Spreadsheet: 04cf6079-2572-440f-8027-56a1ae1977db
Sheet: T14

الجدول 14: السكان في فلسطين بحسب [NAME] (1)
Table 14: Population of Palestine by age groups, 1997 census (1)
 | Nationals | المواطنون | Non-nationals | [NAME] | Urban | حضر | Rural | ريف | Total |  | المجموع
[NAME] | ذكور | إناث | ذكور | إناث | ذكور | إناث | ذكور | إناث | ذكور | إناث | [NAME]
Age group | Male | Female | Male | Female | Male | Female | Male | Female | Male | Female | Both sexes
0-4 | 245122 | 233541 | 53 | 56 | … | … | … | … | 245175 | 233597 | 478772
5-9 | 216547 | 206207 | 52 | 45 | … | … | … | … | 216599 | 206252 | 422851
10-14 | 165224 | 156222 | 71 | 56 | … | … | … | … | 165295 | 156278 | 321573
15-19 | 140675 | 132372 | 72 | 232 | … | … | … | … | 140747 | 132604 | 273351
20-24 | 122181 | 113814 | 136 | 525 | … | … | … | … | 122317 | 114339 | 236656
25-29 | 98766 | 91456 | 196 | 485 | … | … | … | … | 98962 | 91941 | 190903
30-34 | 86044 | 78840 | 151 | 328 | … | … | … | … | 86195 | 79168 | 165363
35-39 | 64317 | 59112 | 108 | 233 | … | … | … | … | 64425 | 59345 | 123770
40-44 | 44303 | 44046 | 81 | 238 | … | … | … | … | 44384 | 44284 | 88668
45-49 | 34793 | 33307 | 87 | 164 | … | … | … | … | 34880 | 33471 | 68351
50-54 | 26018 | 29800 | 73 | 107 | … | … | … | … | 26091 | 29907 | 55998
55-59 | 17545 | 24314 | 53 | 72 | … | … | … | … | 17598 | 24386 | 41984
60-64 | 18741 | 23053 | 45 | 64 | … | … | … | … | 18786 | 23117 | 41903
65-69 | 14728 | 19652 | 27 | 42 | … | … | … | … | 14755 | 19694 | 34449
70-74 | 10925 | 13971 | 16 | 36 | … | … | … | … | 10941 | 14007 | 24948
75+ | 14364 | 16376 | 25 | 57 | … | … | … | … | 14389 | 16433 | 30822
غير محدد    Not stated | 695 | 545 | 30 | 37 | … | … | … | … | 725 | 582 | 1307
المجموع    Total | 1320988 | 1276628 | 1276 | 2777 | … | … | … | … | 1322264 | 1279405 | 2601669
(1) Data don't include that part of jerusalem which was annexed forcefully by Israel in 1967. |  |  |  |  |  |  |  |  |  |  | (1) البيانات لا تشمل ذلك الجزء من محافظة القدس الذي ضمته [NAME] بعد احتلالها للضفة الغربية عام 1967.
Spreadsheet: john_griffith__15668__05_11_01ON
Sheet: Sheet1

N
Commodity: | ON - NAT. GAS OPTS.
Month | STRIKE | BID | OFFER | Volatility | Future
M01-P/C | 425 | 33 | 36
N01-P/C | 435 | 62 | 66
Q01-P/C | 440 | 83.5 | 84.5
U01-P/C | 440 | 99 | 104
V01-P/C | 445 | 115 | 118
X01-P/C | 465 | 134 | 138
[NAME]-P/C | 475 | 152 | 155
F02-P/C | 485 | 166 | 170
G02-P/C | 470 | 170 | 174
H02-P/C | 455 | 157 | 162
J02-P/C | 425 | 116 | 126
K02-P/C | 415 | 109 | 119
M02-P/C | 420 | 112 | 122
U02-P/C | 425
Spreadsheet: 64257d1265132910-search-tabs-and-return-results-kc-environmental-aspects-and-impacts-worksheet-questions
Sheet: Process - Activity 14

Operating Condition | Process Evaluated |  | Date |  |  |  |  | Team
 | Aspect | Impact | NR | RD | KC | L&R | Total Score | Significant? | Objective and Target? | Operational Controls
Normal | Polymer [NAME] | Resource Preservation | 3 | 3 | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
Spreadsheet: 801598d1666269053-formula-to-give-all-the-possible-combinations-s666-pq-data-eduardo_v1
Sheet: Sheet1

Data 1 | Data 2 | Count | Sum |  |  | Data 1 | Data 3 | Count | Sum |  |  | Data 2 | Data 3 | Count | Sum |  |  | Data 1 | Data 2 | Data 3 | Count | Sum
A | D | 20 | -929.08 |  |  | A | G | 23 | -1068.95 |  |  | D | G | 23 | -1068.95 |  |  | A | D | G | 23 | -1068.95
A | E | 18 | -811.46 |  |  | A | H | 12 | -516.0600000000001 |  |  | D | H | 12 | -516.0600000000001 |  |  | A | D | H | 12 | -516.0600000000001
A | F | 27 | -1301.12 |  |  | A | I | 30 | -1452.65 |  |  | D | I | 30 | -1452.65 |  |  | A | D | I | 30 | -1452.65
B | D | 20 | -929.08 |  |  | B | G | 23 | -1068.95 |  |  | E | G | 23 | -1068.95 |  |  | A | E | G | 23 | -1068.95
B | E | 18 | -811.46 |  |  | B | H | 12 | -516.0600000000001 |  |  | E | H | 12 | -516.0600000000001 |  |  | A | E | H | 12 | -516.0600000000001
B | F | 27 | -1301.12 |  |  | B | I | 30 | -1452.65 |  |  | E | I | 30 | -1452.65 |  |  | A | E | I | 30 | -1452.65
C | D | 20 | -929.08 |  |  | C | G | 23 | -1068.95 |  |  | F | G | 23 | -1068.95 |  |  | A | F | G | 23 | -1068.95
C | E | 18 | -811.46 |  |  | C | H | 12 | -516.0600000000001 |  |  | F | H | 12 | -516.0600000000001 |  |  | A | F | H | 12 | -516.0600000000001
C | F | 27 | -1301.12 |  |  | C | I | 30 | -1452.65 |  |  | F | I | 30 | -1452.65 |  |  | A | F | I | 30 | -1452.65
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | D | G | 23 | -1068.95
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | D | H | 12 | -516.0600000000001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | D | I | 30 | -1452.65
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | E | G | 23 | -1068.95
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | E | H | 12 | -516.0600000000001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | E | I | 30 | -1452.65
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | F | G | 23 | -1068.95
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | F | H | 12 | -516.0600000000001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | F | I | 30 | -1452.65
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | D | G | 23 | -1068.95
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | D | H | 12 | -516.0600000000001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | D | I | 30 | -1452.65
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | E | G | 23 | -1068.95
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | E | H | 12 | -516.0600000000001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | E | I | 30 | -1452.65
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | F | G | 23 | -1068.95
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | F | H | 12 | -516.0600000000001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | F | I | 30 | -1452.65
Spreadsheet: 0a79ebd9-8598-4cb7-9783-28c8e909ede4
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
 | Time Series Workbook
 | 9314.0 Sales of New Motor Vehicles, Australia
 | Table 1: New Motor Vehicles Sales by Type, All series
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Aust. ;  Passenger vehicles ; |  |  | Original | A367169W | 1994-01-01 00:00:00 | 2012-11-01 00:00:00 | 227 | Number | FLOW | Month | 1
Aust. ;  Sports utility vehicles ; |  |  | Original | A367214W | 1994-01-01 00:00:00 | 2012-11-01 00:00:00 | 227 | Number | FLOW | Month | 1
Aust. ;  Other vehicles ; |  |  | Original | A367259A | 1994-01-01 00:00:00 | 2012-11-01 00:00:00 | 227 | Number | FLOW | Month | 1
Aust. ;  Total vehicles ; |  |  | Original | A367304A | 1994-01-01 00:00:00 | 2012-11-01 00:00:00 | 227 | Number | FLOW | Month | 1
Aust. ;  Passenger vehicles ; |  |  | Seasonally Adjusted | A367170F | 1994-01-01 00:00:00 | 2012-11-01 00:00:00 | 227 | Number | FLOW | Month | 1
Aust. ;  Sports utility vehicles ; |  |  | Seasonally Adjusted | A367215X | 1994-01-01 00:00:00 | 2012-11-01 00:00:00 | 227 | Number | FLOW | Month | 1
Aust. ;  Other vehicles ; |  |  | Seasonally Adjusted | A367260K | 1994-01-01 00:00:00 | 2012-11-01 00:00:00 | 227 | Number | FLOW | Month | 1
Aust. ;  Total vehicles ; |  |  | Seasonally Adjusted | A367305C | 1994-01-01 00:00:00 | 2012-11-01 00:00:00 | 227 | Number | FLOW | Month | 1
Aust. ;  Passenger vehicles ; |  |  | Trend | A367171J | 1994-01-01 00:00:00 | 2012-11-01 00:00:00 | 227 | Number | FLOW | Month | 1
Aust. ;  Sports utility vehicles ; |  |  | Trend | A367216A | 1994-01-01 00:00:00 | 2012-11-01 00:00:00 | 227 | Number | FLOW | Month | 1
Aust. ;  Other vehicles ; |  |  | Trend | A367261L | 1994-01-01 00:00:00 | 2012-11-01 00:00:00 | 227 | Number | FLOW | Month | 1
Aust. ;  Total vehicles ; |  |  | Trend | A367306F | 1994-01-01 00:00:00 | 2012-11-01 00:00:00 | 227 | Number | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 876684d1723406681-how-to-link-or-import-data-between-two-excel-workbooks-with-very-different-formats-daily-sheets
Sheet: 06.25.24

 | AM SHIFT REPORT
 |  |  |  | 2024-06-25 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 6 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 18 | 0 | 3 | 0 | 1 | 0 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 18 | 0 | 4 | 2 | 0 | 0 | 0 | 2 | 0
 | ABC | 27 | 18 | 20 | 0 | 5 | 0 | 2 | 0 | 0 | 3 | 0
 | MNO | 12 | 6 | 4 | 0 | 2 | 1 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 2 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds AM | N/A | N/A | 0 | 0 | 6 | 1 | 0 | 1 | 0 | 2 | 0
 | Total Holds MID |  |  | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 1 | 0
 | Total House Census
 | PM SHIFT REPORT
 |  |  |  | 2024-06-25 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 9 | 0 | 2 | 1 | 0 | 1 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 21 | 0 | 4 | 1 | 0 | 0 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 21 | 0 | 4 | 0 | 3 | 0 | 0 | 1.5 | 0
 | ABC | 27 | 18 | 21 | 0 | 5 | 0 | 2 | 0 | 0 | 3 | 0
 | MNO | 12 | 6 | 5 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 2 | 0 | 3 | 0 | 1 | 0 | 1 | 1 | 0
 | Total MAT
 | Total Holds PM | N/A | N/A | 0 | 0 | 5 | 2 | 0 | 1 | 0 | 2 | 0
 | Total House Census
Spreadsheet: 778572d1651157148-average-data-to-transfer-from-one-cell-to-another-book1-2-
Sheet: Sheet1

Date | Number
2021-02-04 00:00:00 | 12 |  |  | 2021-01-01 00:00:00
2021-02-05 00:00:00 | 12 |  |  | 2021-02-01 00:00:00
2021-02-06 00:00:00 | 12 |  |  | 2021-03-01 00:00:00
2021-03-07 00:00:00 | 22
2021-02-08 00:00:00 | 12
2021-02-09 00:00:00 | 12
2021-02-10 00:00:00 | 12
2021-02-11 00:00:00 | 12
2021-01-04 00:00:00 | 34
2021-01-05 00:00:00 | 34
2021-01-06 00:00:00 | 34
2021-01-07 00:00:00 | 34
2021-01-08 00:00:00 | 34
2021-01-09 00:00:00 | 34
2021-01-10 00:00:00 | 34
2021-01-11 00:00:00 | 34
Spreadsheet: 37643d1235675339-grouping-duplicates-example-25
Sheet: Sheet2

 | mick | frad
car | 3 | 100
bus | 4 | 200
[NAME] | 5 | 300
car | 6 | 400
bus | 7 | 500
[NAME] | 8 | 600
car | 9 | 700
bus | 10 | 800
[NAME] | 11 | 900
car | 12 | 1000
bus | 13 | 1100
Spreadsheet: 788632d1658592521-finding-sections-of-a-string-of-variable-length-plate-size-proxy-file-v2-cmot-dibbler-
Sheet: Job Items

Section |  |  |  |  |  |  |  |  |  | [NAME] | Quantiy | Total Off |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plate size | Repetative Plates (Gus, Fin) | Plates (end Plates) | Plates Loose | Total Fin Plates | Total End Plates | Loose fin plates | loose end plates |  |  |  |  | Holes of different sizes/types |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total plate cost
plates |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100x100x10 | 4 | 4 | 0 |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 1 | 1
plates |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100x200x10 | 3 | 4 | 0 | 4 |  |  |  |  |  |  |  | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100x200x30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <<<    my old code with none of the fluff, yours should give the same value for the same size plate
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100x200x30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <<<   your code
Spreadsheet: 188159d1350710679-retrieve-player-names-from-another-sheet-having-a-database-of-duplicate-team-names-excelforum-_solution_2
Sheet: Pivot2

 |  |  | Values
Team | Name | Age | Sum of Score | Sum of Tries
Team 1 | Ally | 23 | 75 | 2
 | Kerry | 21 | 45 | 1
 | Mark | 22 | 85 | 1
Team 2 | [NAME] | 24 | 55 | 1
Team 3 | [NAME] | 24 | 100 | 3
 | [NAME] | 23 | 75 | 2
 | [NAME] | 25 | 99 | 3
Team 4 | [NAME] | 26 | 78 | 2
 | [NAME] | 22 | 45 | 1
Team 5 | [NAME] | 28 | 83 | 1
 | Hank | 24 | 3 | 1
 | [NAME] | 29 | 87 | 2
Grand Total |  |  | 830 | 20
Spreadsheet: 110485d1307121522-adding-multiple-rows-based-on-column-info-adding-multiple-rows-based-on-column-info
Sheet: Sheet2

Need an Unique header | MAX Value
Spreadsheet: 792971d1661247817-if-formula-to-return-no-value-if-a-cell-is-blank-but-contains-a-formula-eh_values-if
Sheet: Values

key | status | type |  |  |  |  |  |  | copy list here |  |  |  | key | status | type
22 | 0 | 201 Gm |  |  |  |  |  |  | 201 Gm
28 | 0 | 710 Ml |  |  |  |  |  |  | 710 Ml |  |  |  |  |  | 168 Gm
43 | 0 | 940 Gm |  |  |  |  |  |  | 940 Gm |  |  |  |  |  | 201 Gm
111 | 0 | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  | 222 Gm
112 | 0 | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  | 404 Gm
116 | 0 | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  | [NAME]
122 | 0 | 404 Gm |  |  |  |  |  |  | 404 Gm |  |  |  |  |  | 422 Gm
142 | 0 | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  | 690 Gm
147 | 0 | 222 Gm |  |  |  |  |  |  | 222 Gm |  |  |  |  |  | 710 Ml
164 | 0 | 168 Gm |  |  |  |  |  |  | 168 Gm |  |  |  |  |  | [NAME]
184 | 0 | 422 Gm |  |  |  |  |  |  | 422 Gm |  |  |  |  |  | [NAME]
207 | 0 | 950 Gm |  |  |  |  |  |  | 950 Gm |  |  |  |  |  | [NAME]
304 | 0 | 852 Gm |  |  |  |  |  |  | 852 Gm |  |  |  |  |  | 852 Gm
353 | 0 | 690 Gm |  |  |  |  |  |  | 690 Gm |  |  |  |  |  | 940 Gm
364 | 0 | 1136 Gm |  |  |  |  |  |  | 1136 Gm |  |  |  |  |  | 950 Gm
378 | 0 | 97 Gm |  |  |  |  |  |  | 97 Gm |  |  |  |  |  | 97 Gm
495 | 0 | 11 Ml
501 | 0 | 581 Gm
503 | 0 | 210 Ml
512 | 0 | 384 Gm
513 | 0 | 568 Ml
515 | 0 | 341 Ml