tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 185167d1349533843-third-axis-on-chart-sample-chart_reply-2-
Sheet: Summary (2)

Division | RSA | Beginning 2012 Beds | YTD Bed Loss | Difference | YTD Retention Rate | Revenue
West | Arizona | 12644 | 413 |  |  | 2218432
West | Colorado | 18367 | 725
West | North Texas | 33148 | 1953
West | Northern California | 43566 | 1795
West | Pacific Northwest | 22970 | 282
West | [NAME] | 16585 | 588
West | South Texas | 25213 | 986
West | Arkansas | 9450 | 836
West | Louisiana | 11135 | 242
West | Southern California | 41839 | 4966
West | [NAME] | 18638 | 1692
 | TOTAL |  |  |  |  |  |  |  |  | Revenue = [NAME] and Logarthmic scale on Primary Veritcal Axis.
 |  |  |  |  |  |  |  |  |  | YTD Bed Loss = [NAME].
 |  |  |  |  |  |  |  |  |  | YTD Retention Rate = Secondary Axis and Non Logarithmic scale on Secondary Veritical Axis.
Spreadsheet: 129935d1321979628-formula-to-input-a-fixed-value-based-on-a-fixed-threshold-over-a-variable-trend-copy-of-fill-rate-example-2
Sheet: Sheet1

Example 1
Cells in yellow are variable input cells
Fixed value | 3000
Threshold for Value to apply | 0.2
 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5
Annual fill rate | 0.4 | 0.05 | 0.05 | 0.15 | 0.2
Cumulative fill rate
additional cost |  |  |  |  | 0
 | Should be $6000 |  |  | Should be $3000 | Should be $3000
 |  |  |  | reaching the next 20% threshold | reaching the next 20% threshold
Spreadsheet: darrell_schoolcraft__7324__imball0202
Sheet: WTGmktg

 | /------------------------------------------  contract 22100  --------------------------------------------------------\
 | 10811 |  | 13234 |  | 16540 |  | 500648
 | Follet |  | Oasis Dairy Farms |  | WTG/TW Winker |  | Sum WTG New Mex
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -194 | -143 |  |  | -1253 | -786
2 | -183 | -143 |  |  | -1189 | -786
3 | -164 | -143 |  |  | -1051 | -786
4 | -162 | -143 |  |  | -1329 | -786
5 | -175 | -143 |  |  | -1492 | -786
6 | -165 | -143 |  |  | -1260 | -786
7 | -135 | -143 |  |  | -1019 | -786
8 | -115 | -143 |  |  | -838 | -786
9 | -233 | -143 |  |  | -1113 | -786
10 | -202 | -143 |  |  | -1390 | -786
11 | -154 | -143 |  |  | -1253 | -786
12 | -160 | -143 |  |  | -1211 | -786
13 | -143 | -143 |  |  | -1225 | -786
14 | -133 | -143 |  |  | -933 | -786
15 | -128 | -143 |  |  | -981 | -786
16 | -104 | -143 |  |  | -840 | -786
17 | -98 | -143 |  |  | -951 | -786
18 | -94 | -143 |  |  | -565 | -786
19 | -111 | -143 |  |  | -808 | -786
20 | -89 | -143 |  |  | -700 | -786
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  |  |  |  |  |  |  | -37189.77
2002-02-20 00:00:00
CBS Volume
 |  |  | -4227
Spreadsheet: 787435d1657799220-conditional-formating-or-list-required-to-highlight-values-not-pulled-through-that-should-pricing-review-examples
Sheet: Cost Calculation

Job Data |  |  |  |  |  |  |  |  | main rate | Main rate variable | Main rate variable | Main rate variable | Main rate variable | TMA extra cost | Wash out hydrant | fire hydrant | sluice valves | air valves | non return valve | Pressure reducing valve (install only) | mains branch | Add metres of main/service/comm pipe | Add excavation vol (less than 1.5m depth) | Add excavation volume(1.5m depth or greater) | Add reinstatement | Installation of an additional repair clamp | Materials suitable for use in contaminated ground
 |  |  |  |  |  |  |  |  | rate | rate | rate | rate | rate | Lookup | rate | rate | rate | rate | rate | rate | rate | m | m3 | m3 | m2 | rate | m
Unique Id | SAP order no. | Service Product | Job as promoted | Job as delivered | Description | Final Entry | Error | Audit | A1 | A2 | A3 | A4 | A5 | TM | V1 (a-d) | V2 (a-d) | V3 (a-d) | V4 (a-d) | V5 (a-d) | V6 (a-d) | V7 (a-d) | X1 (a-d) | X3 | X4 | X5 | X6 (a-c) | X8 (a-d)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TM |  |  |  |  |  |  |  |  |  |  |  | X6a
Unique Id | SAP order no. | Service Product | Job as promoted | Job as delivered | Description | Final Entry | Error
Spreadsheet: 171519d1343757017-calculate-percentages-in-columns-forum-july-31-2012a
Sheet: Sheet5

GR | Dist Number | Dist | SChool # | SChool | # of Students | Mean  Developmental SCale SCore | 1 | 2 | 3 | 4 | 5 | PerCentage in AChievement LVLs 3 & Above | VoCabulary | RDG APP | Literary Analysis: FiCtion & NonfiCtion | Informational Text & ResearCh ProCess
GR | Dist Number | Dist | School # | School | # of Students | Mean FcAT Equivalent Developmental Scale Score | Mean FcAT Equivalent Scale Score (100-500) | 1 | 2 | 3 | 4 | 5 | Percent in Achievement LVLs 3 & Above | Vocabulary | RDG APP | Literary Analysis: Fiction & Nonfiction | Informational Text & Research Process
Spreadsheet: 698105d1601747400-criteria-based-ranking-test
Sheet: Test

 |  |  |  |  |  |  |  | 2020-04-15 00:00:00
Item | Price | Category | Date | Except | Rank | Desired Rank
CTR_01 | 3.5 | Urgent | 2020-04-15 00:00:00 | [NAME] |  | 1
[NAME] | 3.2 | Not Urgent | 2020-04-05 00:00:00 |  |  |  |  |  |  | * Rank 1 is to be given for XXX & YYY items (in col. E), then ranking is to be done of only urgent item based on there price and date
CTR_03 | 3.44 | Not Urgent | 2020-04-06 00:00:00
CTR_08 | 3.5 | Urgent | 2020-05-11 00:00:00 |  |  | 2
CTR_18 | 3.44 | Urgent | 2020-04-21 00:00:00 | [NAME] |  | 1
CTR_06 | 3.41 | Urgent | 2020-04-21 00:00:00 |  |  | 3
CTR_07 | 3.2 | Urgent | 2020-04-06 00:00:00
CTR_17 | 3.2 | Urgent | 2020-04-20 00:00:00 | YYY |  | 1
CTR_09 | 3 | Not Urgent | 2020-04-12 00:00:00
CTR_10 | 2.1 | Not Urgent | 2020-04-06 00:00:00 | YYY |  | 1
CTR_11 | 3.4 | Not Urgent | 2020-05-14 00:00:00
CTR_12 | 3.2 | Not Urgent | 2020-04-15 00:00:00
CTR_13 | 3.44 | Not Urgent | 2020-04-16 00:00:00 | YYY |  | 1
CTR_14 | 3 | Not Urgent | 2020-04-17 00:00:00
CTR_15 | 2.1 | Not Urgent | 2020-04-18 00:00:00
CTR_16 | 3.4 | Not Urgent | 2020-04-19 00:00:00
CTR_04 | 3 | Urgent | 2020-04-06 00:00:00
CTR_19 | 3 | Urgent | 2020-04-06 00:00:00
CTR_05 | 2.1 | Urgent | 2020-04-23 00:00:00 |  |  | 4
CTR_20 | 2.1 | Urgent | 2020-04-23 00:00:00 |  |  | 4
Spreadsheet: jeff_dasovich__14164__m010508g
Sheet: Redacted Summary

 |  | PGE [NAME]
 |  | [NAME]
 |  | SDGE [NAME]
 |  | SDGE [NAME]
Spreadsheet: 10d7765e-d7e1-41d0-a7fd-4f9814dc03f9
Sheet: Optional

Total Cost of Equipment above Base Vehicle | Rate Code | Monthly | Mileage
 |  | Rate | Rate
$101 -   $500 | A | 5 | N/C
501 –  1,000 | B | 8 | N/C
1,001 –  1,500 | C | 16 | N/C
1,501 -  2,000 | D | 23 | N/C
2,001 –  2,500 | E | 35 | N/C
2,501 –  3,500 | F | 40 | N/C
3,501 –  5,000 | G | 52 | N/C
5,001 –  7,500 | H | 75 | N/C
7,501 – 10,000 | I | 115 | N/C
10,000 – 15,000 | J | 144 | 0.01
15,001 – 20,000 | K | 219 | 0.015
20,000 – 25,000 | L | 288 | 0.02
25,001 – 30,000 | M | 374 | 0.025
30,001 – 35,000 | N | 431 | 0.03
35,001 – 40,000 | P | 518 | 0.035
40,001 – 50,000 | R | 633 | 0.04
50,001 – 75,000 | S | 748 | 0.05
75,001 and above | T | 1035 | 0.05
Customer Owned Equipment | Y | N/C | 0.015
Deduct for rehab in lieu of replacement (medium/heavy trucks, special equipment) | Z | Deduct 10% from listed monthly rate for the affected vehicle | Deduct 10% from listed monthly rate for the affected vehicle
Note: “N/C” means no charge
Spreadsheet: dan_hyvl__4704__Total Updated TQ List
Sheet: April Updates

EOL Product Type | EOL Location | TQ Product Name | Token (If applicable) | Replaced Product ID | March Product ID | April Product ID
US Gas Basis | [NAME] | Basis IF | Prompt Month | 36159  TRP | 35835 | 38906
US Gas Basis | GD/D HSC-HHub | Basis GD/D | Prompt Month | 36173  TRP | 34510 | TRP OK
US Gas Basis | GD/D TCO P-HHub | Basis GD/D | Prompt Month | 36193  TRP | 35521 | TRP OK
US Gas Basis | GD/D TZ6NY-HHub | Basis GD/D | Prompt Month | 36201  TRP | 35526 | TRP OK
US Gas Basis | GD/M Michcon | Basis GD/M | Prompt Month | 36207  TRP | 32925 | 37795
US Gas Basis | HSC | Basis IF | Prompt Month | 36113  TRP | 33203 | 33997
US Gas Basis | NGI Chicago | Basis NGI | Prompt Month | 36100  TRP | 30528 | 33703
US Gas Basis | NGI Socal | Basis NGI | Prompt Month | 36213  TRP | 35836 | 38908
US Gas Basis | NWPL RkyMtn | Basis IF | Prompt Month | 36135  TRP | 35873 | 38932
US Gas Basis | TCO Pool | Basis IF | Prompt Month | 36161  TRP | 35528 | TRP OK
US Gas Basis | [NAME] NY | Basis IF | Prompt Month | 36169  TRP | 35531 | TRP OK
US Gas Daily | HHub | [NAME]/D | Prompt Month | 36181  TRP | 33519 | TRP OK
US Gas Daily | [NAME] NY | [NAME]/D | Prompt Month | 36624 | 43502 TRP |  | Product number changed
US Gas Daily | NYMEX | FFF NYMEX |  | 36346 | 34401 | 38922 | NYMEX Product will not be Tokenized
US Gas Phy | [NAME] | [NAME] | Day Ahead | N/A | 43788 |  | New product.  Added to EOL 02/27/01
 |  |  | Original Number | Tokenized Product | March Number | April Product ID | For the products to the left only!!!
US [NAME] | CAISO NP15 Peak | [NAME] | 33528 | 36699 | 33529 | 33530 | The original spreadsheet number was
US [NAME] | CAISO SP15 Peak | [NAME] | 33533 | 36704 | 33534 | 33535 | incorrect.  The Tokenized product will be
 |  |  |  |  |  |  | used once the Non-Tokenized months roll
US Pwr Phy Firm | COB N/S Peak | [NAME] | 33748 | 36464 | 33750 | TRP OK | off.  The numbers to be used for April
US Pwr Phy Firm | [NAME] | [NAME] | 33287 | 36462 | 26113 | 26114 | are listed in the "April Number" column.
US Pwr Phy Firm | Entergy Peak | [NAME] | 33292 | 36466 | 33293 | 33294
US Pwr Phy Firm | MID-C Peak | [NAME] | 33756 | 36468 | 33757 | 33758
US Pwr Phy Firm | NEPOOL Peak | [NAME] | 7469 | 36470 | 7470 | 7471
US Pwr Phy Firm | PALVE Peak | [NAME] | 31668 | 36472 | 31669 | 31670
US Pwr Phy Firm | PJM-W Peak | [NAME] | 33308 | 36483 | 32887 | 32888
US Pwr Phy Firm | TVA Peak | [NAME] | 33311 | 36494 | 33312 | 33313
Spreadsheet: 760646d1640357529-convert-raw-age-to-proper-time-format-time-conversion-question-sample
Sheet: Sheet1

Age | Output ([NAME]:dd:hh:[NAME])
3d 3h | 00:03:03:00
16h 3m | 00:00:16:03
14h 6m | 00:00:14:06
1d 20h
7d 13h
12h 36m
8h 48m
1mo 7d
16h 52m
3d 13h
2mo 1d
12h 53m
21h 55m
5d 13h
5d 19h
20h 54m
17h 30m
21h 22m
19h 49m
4d 12h
Spreadsheet: 257f2829-e596-4d22-a19c-f3e2b53b2a8e
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5206 | 30389 | [NAME] | Noordzij | NED | 0 | 00:27:01 | 00:01:54 | 01:14:46 | 00:01:15 | 00:38:45 | 1 | 02:23:42
5206 | 13699 | [NAME] | Averesch | GER | 0 | 00:33:31 | 00:01:47 | 01:12:58 | 00:01:47 | 00:36:41 | 2 | 02:26:45
5206 | 30688 | [NAME] | Smith | GBR | 0 | 00:37:48 | 00:02:06 | 01:19:41 | 00:01:44 | 00:40:28 | 3 | [NAME]
5206 | 12645 | Santos | Caballero | ESP | 0 | 00:40:37 | 00:02:01 | 01:28:37 | 00:02:06 | 01:07:50 | 4 | 03:21:11
Spreadsheet: 140324d1328706085-extract-text-from-date-date-lookup
Sheet: Sheet1

Date | Week No | Month | Year
2009-01-01 00:00:00 | 1 | Jan | 2009
2009-01-02 00:00:00 | 1 | Jan | 2009
2009-01-03 00:00:00 | 1 | Jan | 2009
2009-01-04 00:00:00 | 2 | Jan | 2009
2009-01-05 00:00:00 | 2 | Jan | 2009
2009-01-06 00:00:00 | 2 | Jan | 2009
2009-01-07 00:00:00 | 2 | Jan | 2009
2009-01-08 00:00:00 | 2 | Jan | 2009
2009-01-09 00:00:00 | 2 | Jan | 2009
2009-01-10 00:00:00 | 2 | Jan | 2009
2009-01-11 00:00:00 | 3 | Jan | 2009
2009-01-12 00:00:00 | 3 | Jan | 2009
2009-01-13 00:00:00 | 3 | Jan | 2009
2009-01-14 00:00:00 | 3 | Jan | 2009
Spreadsheet: 833837d1687273575-calculator-with-inputs-and-outputs-in-same-cells-fermentation-salt-calculator
Sheet: Sheet1

Ingredient mass (grams)
Desired salt percentage
Ingredient | Sodium % | Salt % | grams
Salt | 0.388 | 1
MSG | 0.123 | --
ingt 1 |  |  | 0 |  | <<<FIRST, I'D LIKE THE USER TO BE ABLE TO FILL IN EITHER THE SODIUM OR SALT % FOR HOWEVER MANY OF THESE 5 INGREDIENTS THEY ARE USING
ingt 2 |  |  | 0
ingt 3 |  |  | 0
ingt 4 |  |  | 0
ingt 5 |  |  | 0
Ingredient mass (grams)
Desired salt percentage
Ingredient | Sodium % | Salt % | grams
Salt | 0.388 | 1
MSG | 0.123 | --
Soy sauce |  | 0.23 |  |  | <<<SO, LET'S SAY THE PERSON IS USING SOY SAUCE THAT SHOWS A SALT  % OF 23%, AND  A FISH SAUCE THAT SHOWS A SODIUM  PERCENTAGE OF 11%
Fish sauce | 0.11
ingt 3 |  |  | 0
ingt 4 |  |  | 0
ingt 5 |  |  | 0
Ingredient mass (grams) |  | 1210
Desired salt percentage |  | 0.02
Ingredient | Sodium % | Salt % | grams
Salt | 0.388 | 1 | 6.05
MSG | 0.123 | -- | 19.08
Soy sauce |  | 0.23 | 26.3 |  | <<<NOW, I'D LIKE IT TO CALCULATE HOW MUCH OF EACH INGREDIENT IS NECESSARY TO ACHIEVE THE DESIRED 2% SALT IN 1210 [NAME], AND DISPLAY THESE AS 4 EQUAL AMOUNTS
Fish sauce | 0.11 |  | 21.34
ingt 3 |  |  | 0 |  |  |  | 2.0% OF 1210 IS 24.2 GRAMS
ingt 4 |  |  | 0 |  |  | EACH INGREDIENT SHOULD THEREFORE SUPPLY THE EQUIVELENT OF 6.05G OF SALT, AND WOULD BE SHOWN AS SUCH
ingt 5 |  |  | 0
Ingredient mass (grams) |  | 1210
Desired salt percentage |  | 0.02
Ingredient | Sodium % | Salt % | grams
Salt | 0.388 | 1 | # | <<newly calculated number
MSG | 0.123 | -- | 10 | <<my new input
Soy sauce |  | 0.23 | # | <<newly calculated number | <<<BUT I'D LIKE TO BE ABLE TO OVERRIDE ANY OF THEM. SO SAY I  ONLY WANT TO ADD 10g OF MSG, I CAN PUT 10 IN THAT CELL AND THE REST WOULD BE RE-CALCULATED
Fish sauce | 0.11 |  | # | <<newly calculated number
ingt 3 |  |  | 0
ingt 4 |  |  | 0
ingt 5 |  |  | 0
Ingredient mass (grams) |  | 1210
Desired salt percentage |  | 0.02
Ingredient | Sodium % | Salt % | grams
Salt | 0.388 | 1 | 10 | <<my new input
MSG | 0.123 | -- | 10 | <<my new input
Soy sauce |  | 0.23 | # | <<newly calculated number | <<<AND SAY I WANT ALSO 10G OF SALT, THE REMAINING 2 WOULD AGAIN BE RE-CALCULATED
Fish sauce | 0.11 |  | # | <<newly calculated number
ingt 3 |  |  | 0
ingt 4 |  |  | 0
ingt 5 |  |  | 0
Spreadsheet: 770410d1646055327-lookup-value-across-multiple-sheets-and-count-number-of-matching-occurrences-vlookupcount_sample
Sheet: Sheet1

NAME | "On Time" Count |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sheet2
[NAME] | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sheet3
Arran |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sheet4
Conagh |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sheet5
[NAME]
[NAME]
Mark
[NAME]
Mick
[NAME]
Adam
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Janice
[NAME]
[NAME]
[NAME]
Spreadsheet: 31559ac0-01a9-4104-aa06-cae8f0d3e783
Sheet: Sheet1

Table 2--Soybean meal:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | Supply |  |  |  |  | Disappearance
Year beginning | Beginning |  |  |  |  |  |  |  | Ending
October 1 | stocks | Production | Imports | Total |  | Domestic | Exports | Total | stocks
 | 1,000 short tons
2011/12 | 350 | 41025 | 215.807 | 41590.807 |  | 31548.155 | 9742.652 | 41290.807 | 300
2012/131 | 300 | 39875 | 244.912843584927 | 40419.91284358493 |  | 29030.73884358493 | 11114.174 | 40144.91284358493 | 275
2013/142 | 275 | 40110 | 215 | 40600 |  | 29400 | 10900 | 40300 | 300
1 Estimated.  2 Forecast.
Source: USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates.
Last update: | 2014-03-11 21:11:30.020000
Spreadsheet: 791411d1660326310-parsing-out-data-from-a-cel-book1
Sheet: End

Hostname | PluginID | CVE | PluginName | Path | Installed version | Fixed version
 |  |  |  | : /auto/he3nas503a39/usr/java/jdk1.8.0_31/ | Installed version : 1.8.0_31 | Fixed version : Upgrade to version 8.0.341 or greater
 |  |  |  | : /fmac/fir/src_repos/jim_testing/gerrit/jdk1.7.0_71/ | Installed version : 1.7.0_71 | Fixed version : Upgrade to version 7.0.351 or greater
 |  |  |  | : /pkgs/JDK/jdk170_55/ | Installed version : 1.7.0_55 / build 7.0.55 | Fixed version : Upgrade to version 7.0.351 or greater
Spreadsheet: d4f53ed2-42ab-4c33-a67a-b0daa07af55e
Sheet: Sheet1

3310 Gödöllő helyi: 10 sz. vonal Vásártér–[NAME] u.–Autóbusz-állomás | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
(Érvényes: 2011. december 11-től)
Km | Km | Km | Km | VOLÁNBUSZ Zrt. | 2
 |  |  |  |  | I
0 | .. | .. | .. | Gödöllő, [NAME]. major | 07:45:00
0.4 | .. | .. | .. | Gödöllő, [NAME] u. | 07:46:00
0.7 | .. | .. | .. | Gödöllő, [NAME] u. | 07:47:00
1 | .. | 0 | 0 | Gödöllő, Faiskola u. | 07:48:00
1.1 | .. | S | S | Gödöllő, Török Ignác u. | 07:49:00
S | .. | 0.8 | 0.8 | Gödöllő, Tanárképzö Főiskola | S
S | .. | 1.2 | 1.2 | Gödöllő, [NAME]. | S
.. | .. | .. | 1.6 | Gödöllő, Erzsébet park | S
1.7 | .. | 2.2 | 3 | Gödöllő, Szabadság tér | 07:51:00
2.2 | .. | 2.7 | .. | Gödöllő, aut. áll. | 07:52:00
[NAME]:
I | tanítási napokon
S | a járat nem érinti a megállóhelyet, [NAME]
Spreadsheet: 114720d1310458724-compare-values-multiple-columns-example-data-compare-highest
Sheet: Sheet1

name | visits mar | name | visits apr | name | visits may | name | visits jun
A | 7 | C | 15 | B | 12 | M | 6
C | 6 | D | 12 | C | 8 | H | 4
F | 3 | Y | 9 | F | 6 | G | 2
D | 2 | G | 9 | U | 4 | A | 2
E | 1 | A | 8 | M | 3 | U | 1
G | 1 | M | 6 | A | 1 | C | 1
Spreadsheet: 864799d1711948868-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record
Sheet: Gum Rosan

Raw Material |  | Gum Rosan
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00 |  |  |  |  |  | 5539
Total
Spreadsheet: 874159d1720726080-setting-continues-date-to-identify-as-a-week-number-sample
Sheet: Sheet1

Date | Week number
2024-01-07 00:00:00
2024-01-07 00:00:00
2024-01-07 00:00:00
2024-01-07 00:00:00
2024-01-07 00:00:00
2024-01-07 00:00:00
2024-02-07 00:00:00
2024-02-07 00:00:00
2024-02-07 00:00:00
2024-02-07 00:00:00
2024-02-07 00:00:00
2024-02-07 00:00:00
2024-02-07 00:00:00
2024-02-07 00:00:00
2024-02-07 00:00:00
2024-02-07 00:00:00
2024-02-07 00:00:00
2024-02-07 00:00:00
2024-02-07 00:00:00
2024-02-07 00:00:00
2024-03-07 00:00:00
2024-03-07 00:00:00
2024-03-07 00:00:00
2024-03-07 00:00:00
2024-03-07 00:00:00
2024-03-07 00:00:00
2024-03-07 00:00:00
2024-03-07 00:00:00
2024-03-07 00:00:00
2024-03-07 00:00:00
2024-03-07 00:00:00
2024-03-07 00:00:00
2024-03-07 00:00:00
2024-03-07 00:00:00
2024-03-07 00:00:00
2024-03-07 00:00:00
2024-03-07 00:00:00
2024-03-07 00:00:00
2024-03-07 00:00:00
2024-03-07 00:00:00
2024-03-07 00:00:00
2024-03-07 00:00:00
2024-03-07 00:00:00
2024-05-07 00:00:00
2024-05-07 00:00:00
2024-05-07 00:00:00
2024-05-07 00:00:00
2024-05-07 00:00:00
2024-05-07 00:00:00
2024-05-07 00:00:00
2024-05-07 00:00:00
2024-05-07 00:00:00
2024-08-07 00:00:00
2024-08-07 00:00:00
2024-08-07 00:00:00
2024-08-07 00:00:00
2024-08-07 00:00:00
2024-08-07 00:00:00
2024-08-07 00:00:00
2024-08-07 00:00:00
2024-08-07 00:00:00
2024-08-07 00:00:00
2024-08-07 00:00:00
2024-08-07 00:00:00
2024-08-07 00:00:00
2024-08-07 00:00:00
2024-08-07 00:00:00
2024-08-07 00:00:00
2024-08-07 00:00:00
2024-08-07 00:00:00
2024-08-07 00:00:00
2024-08-07 00:00:00
2024-08-07 00:00:00
2024-08-07 00:00:00
2024-08-07 00:00:00
Spreadsheet: 701297d1603701726-power-query-conditional-column-example
Sheet: Table

CSORNADR1 | Customer Name
Customer 1 | Client 1
Customer 2
Customer 3 | Client 2
Customer 4
Customer 5
Customer 6 | Client 3
Customer 7
Customer 8
Customer 9
Customer 10
Customer 11 | Client 4
Customer 12 | Client 5
Customer 13
Customer 14
Customer 15
Customer 16
Customer 17
Customer 18
Customer 19 | Client 6
Customer 20
Customer 21 | Client 7
Spreadsheet: 765914d1643664474-percentage-based-on-age-will-distrabution
Sheet: Sheet1

 | 290000
 |  | Name | Birth | Age | Parent | % | Amount |  |  |  |  | Pot for grandkids
 |  | [NAME] | 2010-08-12 00:00:00 |  | [NAME] |  |  | Based on pot for grandkids |  |  |  | Pot for kids
 |  | [NAME] | 2012-01-26 00:00:00 |  | [NAME] |  |  | Based on pot for grandkids |  |  |  | Total Pot
 |  | Mathew | 2007-03-16 00:00:00 |  | [NAME] |  |  | Based on pot for grandkids
 |  | [NAME] |  |  | [NAME] |  |  | Based on pot for grandkids
 |  | Tyler TJ |  |  | [NAME] |  |  | Based on pot for grandkids
 |  | [NAME] | 2015-09-12 00:00:00 |  | [NAME] |  |  | Based on pot for grandkids
 |  | [NAME] | 1995-05-26 00:00:00 |  | Shannon |  |  | Based on pot for grandkids
 |  | Nathen | 1999-04-20 00:00:00 |  | Shannon |  |  | Based on pot for grandkids
 |  | Hayden | 2009-04-22 00:00:00 |  | Shannon |  |  | Based on pot for grandkids
 |  | [NAME] | 1997-04-05 00:00:00 |  | [NAME] |  |  | Based on pot for grandkids
 |  | Carlyann | 2019-04-23 00:00:00 |  | [NAME] |  |  | Based on pot for grandkids
 | Great Grandchild | Madalyn |  |  | [NAME] |  |  | Based on pot for grandkids
 |  | Shannon | 1974-08-31 00:00:00 |  | [NAME] |  |  | Based on pot for kids
 |  | [NAME] | 1974-07-22 00:00:00 |  | [NAME] |  |  | Based on pot for kids
 |  | [NAME] | 1978-12-04 00:00:00 |  | [NAME] |  |  | Based on pot for kids
 |  | [NAME] | 1979-08-08 00:00:00 |  | [NAME] |  |  | Based on pot for kids
I have a total pot of B1, I want to take a % of that L3 and divide it up amongst my grandchildren based on their age by a percentage otherwise [NAME] would receive the most and Madyln would receive the least. So for example [NAME] would receive "[NAME] and [NAME] would receive "y" % as well as the rest based on the age percentage.
Aso L4 would be handeled the same based on the same but with the kids
Spreadsheet: 8805e318-627b-4844-bb32-a0fc9ef79545
Sheet: Drug doses used in X-QTL

 | Crosses
Condition | [NAME] | BYxYJM | BYxYPS | RMxYJM | RMxYPS | YJMxYPS
4-NQO | 1 ug/ml | 1 ug/ml | 1 ug/ml | 1 ug/ml | 1 ug/ml | 1.75 ug/ml
Benomyl | 1.3 mg/ml | 2 mg/ml | 2 mg/ml | 2 mg/ml | 2 mg/ml | 2 mg/ml
Cadmium chloride | 500 uM | 400 uM | 500 uM | 450 uM | 600 uM | 600 uM
Chlorpromazine | 80 uM | 70 uM | 80 uM | 70 uM | 70 uM | 70 uM
Copper sulfate | 12.5 mM | 12.5 mM | 12.5 mM | 6.5 mM | 8 mM | 9.5 mM
Cycloheximide | 50 ng/ml | 25 ng/ml | 50 ng/ml | 50 ng/ml | 50 ng/ml | 25 ng/ml
Diamide | 2 mM | 1.5 mM | 2 mM | 2 mM | 3 mM | 2.5 mM
Hydrogen peroxide | 15 mM | 15 mM | 15 mM | 14 mM | 14 mM | 14 mM
LY83583 | 70 uM | 90 uM | 70 uM | 90 uM | 70 uM | 100 uM
Paraquat | 2 mM | 2 mM | 4 mM | 1 mM | 4 mM | 2 mM
SDS | 0.001 | 0.001 | 0.001 | 0.001 | 0.00125 | 0.001
Tunicamycin | 3 uM | 3.5 uM | 3 uM | 2.5 uM | 2.5 uM | 3 uM
Zeocin | 30 ug/ml | 35 ug/ml | 20 ug/ml | 35 ug/ml | 35 ug/ml | 30 ug/ml
Spreadsheet: benjamin_rogers__1109__contact numbers
Sheet: Lincoln Ctr

 | Lincoln Center Generating Plant
 | 27155 South Kankakee Road, Manhattan, IL 60442
 | General Phone Numbers |  |  | Plant Personnel
 | Control Room 1 | [PHONE] |  | Name | Title | Office | Cellular | Home | [NAME]
 | Control Room 2 | [PHONE] |  | [NAME] | Plant Manager | [PHONE] | [PHONE] | [PHONE]
 | Control Room Fax | [PHONE] |  | N/A | Maintenance Manager | N/A | N/A | N/A
 | On Call Pager 1 |  |  | Brent Colbert | Plant Supervisor | [PHONE] | [PHONE] | [PHONE]
 | On Call Pager 2 |  |  | [NAME] | Admin. [NAME]. |  | [PHONE] | [PHONE]
 | Field Cellular | [PHONE] |  | [NAME] | Tech III | [PHONE] | [PHONE] | [PHONE]
 |  |  |  | [NAME] | Tech III | [PHONE] | N/A | [PHONE]
 |  |  |  | [NAME] | Tech II | [PHONE] | N/A | [PHONE]
 | Neighboring Control Areas |  |  | [NAME] | Tech II | [PHONE] | [PHONE] | 815 478  4555
 | ComEd Generation | [PHONE] |  | [NAME] | Tech II | [PHONE] | N/A | [PHONE]
 | ComEd Interchange | [PHONE] |  | Damian [NAME] | Tech II | [PHONE] | [PHONE] | [PHONE]
 | ComEd Merchant | [PHONE]
 | Northern Borders Gas Pipeline |  |  |  | Emergency Numbers
 | System Control | [PHONE] |  |  | Fire | [PHONE]
 |  |  |  |  | Police | [PHONE]
 | Alarm Detection Systems, Inc.. |  |  |  | Ambulance
 | Central Station | [PHONE] |  |  | Silver Cross Hospital | [PHONE]
 | Service | [PHONE]
Spreadsheet: 8516ed0c-9b27-4b54-82a7-e75941aac70d
Sheet: Table 10

Table 10
[NAME] (1,000 tons)
Week ending 12/13/2014 | Corn | Wheat | Soybeans | Other | Total
Mississippi River
Rock Island, IL (L15) |  | 0 |  | 0
Winfield, MO (L25) |  | 0
Alton, IL (L26)
Granite City, IL (L27)
Illinois River (L8) |  | 0 |  | 0
Ohio River (L52) |  |  |  |  |  | n/a
Arkansas River (L1)
Weekly total - 2014
Weekly total - 2013
2014 YTD1
2013 YTD
2014 as % of 2013 YTD
Last 4 weeks as % of 20132
Total 2013
1 Weekly total, YTD (year-to-date) and calendar year total includes Miss/27, [NAME], and Ark/1; "Other" refers to oats, barley, sorghum, and rye.
2 As a percent of same period in 2013.
Note:  Total may not add exactly, due to rounding
Source:  U.S. Army Corps of Engineers