tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 219187d1362679444-automatically-updating-multiple-sheets-to-a-master-sheet-master-test
Sheet: 3.

Test |  |  |  |  |  |  | Target |  | Actual |  |  |  |  | 2011 |  |  |  |  |  |  |  |  |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014
Activity | Core | Stream | Task | Milestone | Accountable | External | Start | End | Actual | Actual End Date | Status | Funding | Notes/Location | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
3 | Main Title
3
3.1 | Title
3.1
3.1
3.1
3.1
3.1 | Title
3.1
3.1
3.2 | Title
3.2
3.2
3.2
3.2
3.2
3.2
3.2
3.2
3.3 | Title
3.3
3.3
3.3
3.3
3.3
3.3
3.3
3.4 | Title
3.4
3.4
3.4
3.4
3.4
3.4
3.4
3.5 | Title
3.5
3.5
3.5
3.5
3.5
3.5
3.5
3.5
3.6 | Title
3.6
3.7 | Title
3.7
3.7
3.7
3.7
3.7
3.7
3.8 | Title
3.8
3.8
3.8
3.8
3.9 | Title
3.9
3.9
3.9
3.9
3.9
3.9
3.1 | Title
3.1
3.1
3.1
3.1
3.11 | Title
3.11
3.11
3.11
3.11
3.11
3.11
3.11
3.11
3.11
3.11
3.11
3.11
3.11
3.11
3.11
3.11
3.11
3.11
3.11
3.12 | Title
3.12
3.12
3.12
3.12
3.13 | Title
3.13
3.13
3.14 | Title
3.14
3.14
Spreadsheet: 631403d1562662236-distance-between-coordinates-shown-in-a-sorted-list-distance_between_locations_dummy
Sheet: Desired Result

 | Location ID
 | PL122 | Example: Here is the site that should be compared to all the others.
 |  |  | Location ID | Coordinate X | Coordinate Y | Distance (m) |  | Here is the sorted list. Comparing all the other sites from the Data sheet to PL122 and then sorting them by their distance to PL122
 |  |  | PG343 | 646860 | 248249 | 5 |  | Obviously if I put another ID in B3, then the list should change accordingly.
 |  |  | [NAME] | 647150 | 249980 | 6.4 |  | Thank you so much again! :)
 |  |  | KO420 | 665069 | 259111 | 7
 |  |  | OL942 | 656550 | 256150 | 8
 |  |  | PY492 | 643443 | 237911 | 10
 |  |  | PT940 | 643443 | 237911 | 10
 |  |  | HY675 | 655820 | 257720 | 11
 |  |  | [NAME] | 656260 | 249240 | 11.2
 |  |  | KH387 | 648322 | 246675 | 11.5
 |  |  | UB482 | 655642 | 247923 | 11.9
 |  |  | HF029 | 653510 | 246900 | 12.5
 |  |  | RH392 | 653510 | 246900 | 12.5
 |  |  | LN392 | 671310 | 243990 | 12.5
 |  |  | ES492 | 650560 | 236088 | 15
 |  |  | NJ111 | 656622 | 232628 | 46.1
 |  |  | LK392 | 656622 | 232628 | 50.5
 |  |  | KL329 | 635070 | 236500 | 62.8
 |  |  | GF329 | 635070 | 236500 | 70
 |  |  | DF392 | 633251 | 239845 | 73.5
 |  |  | DR029 | 638611 | 263271 | 79.7
 |  |  | SD932 | 637023 | 261981 | 86.6
 |  |  | WE942 | 637023 | 261981 | 87.3
 |  |  | DE902 | 668849 | 245006 | 91.7
 |  |  | [NAME] | 665580 | 258800 | 94.8
 |  |  | RH992 | 665580 | 258800 | 94.9
 |  |  | LR012 | 645850 | 249150 | 94.9
 |  |  | [NAME] | 665470 | 258450 | 99.6
 |  |  | OR654 | 668855 | 245017 | 100.9
Spreadsheet: 160365d1339067114-excel-2007-text-boxes-and-pictures-will-not-print-tried-lots-of-things-to-no-avail-copy-of-recipe-sheet-v5
Sheet: Site Sheet

 |  |  |  |  |  |  |  |  |  | Job Ref
 |  |  |  |  |  |  |  |  |  |  |  | Mix Information for
•SureSet UK Ltd • 32 Deverill Road Trading Estate • Sutton Veny • Warminster • BA12 7BZ Tel Ph 02 4297 6943 E [EMAIL] W www.sureset.co.uk
MIX DETAILS |  |  |  |  |  |  |  |  |  | Hints & Tips
Supply of Materials Only
Job No
Customer
Site Details
Area |  | Depth |  | # [NAME] |  | Coverage
 |  | Please check the aggregate and resin to the delivery note
AGGREGATE PER BATCH
Size | Type |  | Kg in mix | [NAME] | No of Bags per mix | Total Tonnage | Total No. of [NAME]
SPRINKLE
IMPORTANT NOTES
Catalyst Guidance
[NAME] |  | Amt of T40 /batch
Cold, less than 50C
Cool, 5-100C
Normal, 10-200C
Warm, 20-250C
Hot, Higher than 250C
T3 = 1/10 dilution T2 in white spirit
 |  |  |  |  |  |  |  |  |  | The material as above should only be used on this project, and the resin must be used with 30 days of receiving delivery.
 |  | [NAME]
[NAME] |  | Cold | Cool | Normal | Warm | Hot
Ambient temp’ |  | less than 5 0 C | 5 – 10 0 C | 10-20 0 C | 20 – 25 0 C | higher than 25 0 C
0-1 kg |  | 5 ml T3 | 4 ml T3 | 3 ml T3 | 1 ml T3 | 1 ml T3
1-2 kg |  | 1½ ml | 1 ml | 8 ml T3 | 3 ml T3 | 2 ml T3
2-3 kg |  | 3ml | 2ml | 1 ml | 5 ml T3 | 3 ml T3
3-4 kg |  | 4 ml | 3 ml | 1½ ml | 7 ml T3 | 4 ml T3
4-5 kg |  | 5 ml | 3ml | 2 ml | 1 ml | 5 ml T3
5-6 kg |  | 6ml | 4 ml | 2½ ml | 1 ml | 6 ml T3
6-7 kg |  | 7ml | 5 ml | 3 ml | 1½ ml | 7 ml T3
7-8 kg |  | 8ml | 6 ml | 3½ ml | 1½ ml | 8 ml T3
8-9 kg |  | 9 ml | 6 ml | 4 ml | 2 ml | 9 ml T3
Spreadsheet: darrell_schoolcraft__7804__imbalsumm0108
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 | -19535 | -11416
9238 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
56422 | -856632 | -969494
58710 | -13460 | -352
60921 | -724990 | -756488
78026 |  | 17700
500084 | -4549 | -8000
500085
500097 | -11
INDEX
2001-07-31 00:00:00 |  |  | 296780.47
2001-08-08 00:00:00
CBS Volume
 |  |  | 67620
Spreadsheet: 154854d1336581765-hai-frds-please-help-me-to-solve-this-prob-date-count
Sheet: Sheet1

plan date | achievement date
2012-05-01 00:00:00 | 2012-05-03 00:00:00 |  |  |  | may |  | june |  | july |  | august
2012-05-03 00:00:00 | 2012-05-04 00:00:00 |  |  |  | w1 |  | w2 |  | w3 |  | w4
2012-05-20 00:00:00 | 2012-05-05 00:00:00 |  |  |  | 2012-05-01 00:00:00 | 2012-05-07 00:00:00 | 2012-05-08 00:00:00 | 2012-05-14 00:00:00 | 2012-05-15 00:00:00 | 2012-05-21 00:00:00 | 2012-05-22 00:00:00 | 2012-05-31 00:00:00
2012-05-07 00:00:00 | 2012-05-09 00:00:00 |  |  |  | plan | achivement | plan | achivement | plan | achivement | plan | achivement
2012-05-09 00:00:00
2012-05-11 00:00:00
2012-05-28 00:00:00
2012-05-15 00:00:00 | 2012-05-17 00:00:00
2012-05-26 00:00:00 | 2012-05-19 00:00:00
2012-05-17 00:00:00 | 2012-05-21 00:00:00
2012-05-18 00:00:00
2012-05-19 00:00:00 | 2012-05-25 00:00:00
2012-05-24 00:00:00 | 2012-05-27 00:00:00
2012-05-21 00:00:00 | 2012-05-29 00:00:00
2012-05-22 00:00:00
2012-05-23 00:00:00
2012-05-24 00:00:00
2012-05-25 00:00:00
2012-05-26 00:00:00
2012-05-27 00:00:00
2012-05-28 00:00:00
2012-05-29 00:00:00
2012-05-30 00:00:00 | 2012-06-16 00:00:00
2012-05-31 00:00:00 | 2012-06-18 00:00:00
Spreadsheet: 849442d1699921671-help-with-bankroll-stats-from-different-sheets-to-be-calculated-copy-of-mtt-brm-template
Sheet: Tournaments

Current Bankroll: |  |  |  |  |  |  | [NAME]. Buy In: |  |  |  |  | Brought to you by |  |  | Summary Data
Overall Stats |  |  |  |  | Finish Positions |  |  |  |  | Buy-ins |  |  |  |  | Gathers information to be used in the 'Bankroll Summary Spreadsheet'
Total Profit |  |  |  |  | ITM % |  | Late % |  |  | Suggested BI |  |  |  |  | Bankroll
Total Time |  |  |  |  | 1st |  | Mid Late % |  |  | Allowable BI |  |  |  |  | Starting Bankroll
[NAME] |  |  |  |  | 2nd |  | Midde % |  |  | [NAME] (not recc'd) |  |  |  |  | Profit
ROI |  |  |  |  | 3rd |  | Early Mid % |  |  | Average BI |  |  |  |  | ROI
[NAME] ROI |  |  |  |  | 4 - 10 |  | Early % |  |  | Sugg BIs Avail. |  |  |  |  | Buy-in ROI
$/Hr |  |  |  |  |  |  |  |  |  | Allow BIs Avail. |  |  |  |  | Total Time
$/Tournament |  |  |  |  |  |  |  |  |  | [NAME]. |  |  |  |  | $/hr
# | Date | Start Time | Finish Time | Size | Total Buy-in | Place Finished | Prize | Profit | Length | Placed % | ROI | $/Hr | Bankroll | BI % of BR | Profit % of BR | Tournament | Bankroll
0
 | 2010-01-01 00:00:00 | 09:30:00 | 10:45:00 | 2000 | -25.68 | 1224 | 0
 | 2010-01-01 00:00:00 | 09:30:00 | 10:45:00 | 2000 | 10.8 | 1685 | 0
 | 2010-01-01 00:00:00 | 09:30:00 | 10:45:00 | 2000 | 0.8 | 725
 | 2010-01-01 00:00:00 | 09:30:00 | 10:45:00 | 2000 | -1.16 | 300
 | 2010-01-01 00:00:00 | 09:30:00 | 10:45:00 | 2000 | 30.4 | 10
 |  |  |  |  | 37.35 |  | 23
 |  |  |  |  | 4.97
 |  |  |  |  | 32.1
 |  |  |  |  | -13.4
 |  |  |  |  | 200
 |  |  |  |  | 1.33
 |  |  |  |  | 3.21
 |  |  |  |  | 21.6
 |  |  |  |  | 28.2
 |  |  |  |  | -1.16 |  | 4.37
 |  |  |  |  | 9.53
 |  |  |  |  | 49.72
 |  |  |  |  | 50.36 |  | 37.5
 |  |  |  |  | 9.93 |  | 48.3
 |  |  |  |  | 3.5 |  | 9
 |  |  |  |  | 2.16 |  | 0.5
 |  |  |  |  | -4.73
 |  |  |  |  | -0.17 |  | 94.61
 |  |  |  |  | 32.1 |  | 7.5
 |  |  |  |  | 11.98
 |  |  |  |  | 11.68
 |  |  |  |  | 60.11
 |  |  |  |  | 11.98
 |  |  |  |  | 31.23
 |  |  |  |  | 12.55 |  | 6
 |  |  |  |  | 1.39 |  | 1.25
 |  |  |  |  | 15.89 |  | 43.61
 |  |  |  |  | 23
 |  |  |  |  | 25
 |  |  |  |  | 3.21
 |  |  |  |  | 2.35 |  | 25.83
 |  |  |  |  | 51.81
 |  |  |  |  | 52.6
 |  |  |  |  | 10.8
 |  |  |  |  | -1.16 |  | 1.25
 |  |  |  |  | 50.36
 |  |  |  |  | -5.38
 |  |  |  |  | 52.46
 |  |  |  |  | -2.32
 |  |  |  |  | 1.08 |  | 3.21
 |  |  |  |  | -1.16 |  | 8.12
 |  |  |  |  | -11.61
 |  |  |  |  | -0.46
 |  |  |  |  | -0.85
 |  |  |  |  | 24.73 |  | 7.5
 |  |  |  |  | -1.16 |  | 2.5
 |  |  |  |  | -1.08 |  | 25.83
 |  |  |  |  | -1.7
 |  |  |  |  | 24.06
 |  |  |  |  | 9.5
 |  |  |  |  | 5.5
 |  |  |  |  | 12.8 |  | 92
 |  |  |  |  | 298.4
 |  |  |  |  | -1.16 |  | 17.75
 |  |  |  |  | -1.89
 |  |  |  |  | -1.14
 |  |  |  |  | 5.86
 |  |  |  |  | 1
Spreadsheet: 737817d1624621043-multiple-formulas-in-one-cell-calc-test-3
Sheet: Projections

Fuel Inflation |  |  | 0.051 | ONS CPI 2008 - 2020 |  |  | Generation (SAP) |  | 3259
Gas Inflation |  |  | 0.033 | ONS CPI 2008 - 2020 |  |  | Solar Self Consumption |  | 0.5
 |  |  |  |  |  |  | Battery Self Consumption |  | 0.3
 |  |  |  |  |  |  | Export
Unit Rate |  |  | 0.16 | From [NAME]
Gas Annual Use (kWh) |  |  | 12000 | From [NAME] |  |  | System Cost |  | 8000
Elec. Annual Use (kWh) |  |  | 2000 | From [NAME] |  |  | Deposit |  | 2000
Export Tariff |  |  | 0.055 | Available Tariff |  |  | Payment Type |  | Cash
 |  |  |  |  |  |  | Annual Interest Rate
 |  |  |  |  |  |  | Payment Terms (years) |  | 10
Panel Degradation |  |  | 0.00925 |  |  |  | Annual Loan Repayment
Year | [NAME] | Export | SC Savings | Solar Total | Rep | Monthly Payment | Total Yearly Payment | Annual Benefit | Net Position
1
2
3
4
5
 |  |  |  |  | 1500
 |  |  |  |  | 1000
Spreadsheet: 377182d1423833758-how-to-sum-x-number-of-cells-oeldere-377175d1423832844-how-to-sum-x-number-of-cells-example-template
Sheet: Sheet1

TIME | RESULT
1 | 65
2 | 5651231
3 | 1561
4 | 5161
5 | 51518
6 | 213
7 | 35548
8 | 884
9 | 8411
10 | 35511651
11 | 3132
12 | 551
13 | 51165
14 | 51651
15 | 5616516
16 | 58888
17 | 489
18 | 84984
19 | 845313
20 | 56513
Example: The function should find number 15 in column A, and then automatically sum the 5 previous cells in column B (including cell B:16) | RESULT HERE
15
Spreadsheet: mary_fischer__25640__31W - 2001
Sheet: E-6.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031W
COMPANY NAME    Harper Mechanical Corp.
ANALYSIS OF PROPERTY, PLANT AND EQUIPMENT
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-6
 |  | 12-31-2000 Balance |  |  |  |  |  | CHARGED TO I/S
 |  | DR/(CR.) |  |  |  | SALES AND OTHER |  |  |  |  |  |  |  | DETAIL OF |  | ENDING
[NAME] |  | BEGINNING |  | ADDITIONS |  | RETIREMENTS |  | DEPR |  | DEPL |  | OTHER |  | OTHER CHANGES |  | BALANCE
 |  | BALANCE |  | DR/(CR) |  | DR/(CR) |  | 1415 |  | 1416 |  | (List Below-A) |  | (List Below-B) |  | DR/(CR)
Natural Gas Transmission
Electric Generation & Distribution
Construction In Process
O & G Properties
Other |  | 2138420 |  | 121200
Gross PP & E
Accumulated DD & A |  | -1299569 |  |  |  |  |  | -52519 |  |  |  | -48000 |  | 222988
Net PP & E |  |  | * |  | ** |  | ** |  |  |  |  |  |  |  |  |  | *
 |  |  |  |  | ** Pertains to amounts related to normal |  |  |  |  |  |  | (A) |  | (B) | * | [NAME] TO
 |  |  |  |  | operations.  Unusual amounts should be shown |  |  |  |  |  |  |  |  |  |  | HYPERION LINE
 |  |  |  |  | under "Other Changes" with appropriate explanations. |  |  |  |  |  |  |  |  |  |  | NET_TOT_PPE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Asset/Exp  DR/(CR)
 |  |  |  |  |  |  | DETAIL OF OTHER CHANGES     (B)
 |  |  |  |  |  |  |  |  |  |  |  | PP & E |  | ACCUM |  | NET
CHARGED TO OTHER I/S ACCTS     (A) |  |  |  |  |  |  | KEY: |  |  |  |  | DR/(CR) |  | DR/(CR) |  | DR/(CR)
[NAME] |  | HYP ACCT CHGD |  | DR/(CR) |  |  | (PROVIDE DETAIL OF INDIVIDUAL ITEMS
 |  |  |  |  |  |  | IN EXCESS OF $200,000.)
Depr Charged to Jobs |  | 1150 |  | -48000 |  |  | (1) Reclassification between property
 |  |  |  |  |  |  | accounts (should net to -0-)
 |  |  |  |  |  |  | (2) Intercompany transfer
 |  |  |  |  |  |  | (list companies):
 |  | TOTAL
 |  |  |  |  |  |  | (3) Acquisition (disposition)
 |  |  |  |  |  |  | of business
 |  |  |  |  |  |  | (4) Foreign currency
 |  |  |  |  |  |  | translation adjustment
 |  |  |  |  |  |  | (5) Lease impairments -
 |  |  |  |  |  |  | Oil & Gas
 |  |  |  |  |  |  | (6) Other (detail):
 |  |  |  |  |  |  |  | Reclass from [NAME] 0280 |  |  |  |  |  | 222988 |  | 222988
 |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-6
Spreadsheet: 809036d1670852393-using-string-in-table-to-decide-if-a-value-should-be-taken-from-table-header-2022-12-12-1
Sheet: Sheet2

Exemple | [NAME]
 |  | Apple | Orange | Pear | [NAME]
 | Apple | - | o | o | o
 | Orange | x | - | x | o |  |  |  |  |  |  | Apple, Pear
 | Pear | x | o | - | x |  |  |  |  |  |  | Apple, Banana
 | [NAME] | x | x | o | -
Solution 1
 |  | Apple | Orange | Pear | [NAME] |  | Apple | Orange | Pear | [NAME] |  | Result
 | Apple | - | o | o | o
 | Orange | x | - | x | o
 | Pear | x | o | - | x
 | [NAME] | x | x | o | -
Solution 2
 |  | Apple | Orange | Pear | [NAME] |  | Apple | Orange | Pear | [NAME] |  | Result
 | Apple | - | o | o | o
 | Orange | x | - | x | o |  |  |  | Pear
 | Pear | x | o | - | x |  |  |  |  | [NAME]
 | [NAME] | x | x | o | - |  |  | Orange
Spreadsheet: 867755d1714552752-i-am-trying-to-pull-data-from-a-cell-based-on-another-cells-value-beginner-help-forum-test-sheet-v1-worksheet
Sheet: Vehicle Booking Sheet

REG | SIZE | LOAD 1 | LOAD 2 | LOAD 3
TEST 1 | 8W
TEST 2 | 8W
TEST 3 | 8W
TEST 4 | 8W
Spreadsheet: 649061d1573457921-run-time-error-in-macro-time-series-upper-aquifer-qw-spreadsheet
Sheet: Well 17

Well | Date | pH | EC | Ca | [NAME] | Na | Alk as CaCO3 | HCO3  as  CaCO3 | CO3  as  CaCO3 | SO4 | Cl | TDS | SAR | SARadj | B | NO3-N | Cu | Fe | Mn | Zn | L.I. |  | Sum cat | [NAME] | % dif
 | Sampled | unit | dS/m | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | mg/L |  |  | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | Calc
17 | 2007-02-20 00:00:00 | 7.4 | 2.93 | 17.3 | 6.1 | 8.4 | 4.4 |  |  |  | 24.5 |  | 3.472972568497837 | 3.5 | 0.1 | 9 |  |  |  |  | 0.8
MTTRWell 17A  1200gpm | 2012-03-29 00:00:00 | 7.6 | 3.55 | 18.38 | 6.68 | 8.3 | 3 |  |  | 1 | 28.9 |  | 2.3 | 6 | 0.03 | 4.5 |  | <0.01 | <0.01 |  | 0.8
Well #17 | 2013-10-11 00:00:00 | 7.2 | 3.71 | 17.21 | 6.07 | 7.8 | 3 |  |  | 1.1 | 32.1 |  | 2.3 | 5.9 | 0.03 | 3.4 |  | <0.10 | <0.02 |  | 0.4
Well - 17 | 2014-01-27 00:00:00 | 7.7 | 4.03 | 21.3 | 7.94 | 10.7 | 2.8 |  |  | 1.1 | 36.4 |  | 2.8 | 7.3 | 0.03 | 3.7 |  | <0.10 | <0.02 |  | 0.9
Well 17 | 2016-04-01 00:00:00 | 7.7 | 4.764 | 25.53 | 9.28 | 11.5 | 2.819518823435377 | 2.819518823435377 | 0 | 1.26 | 49.105 | 3046.4 | 2.76 | 6.97 | 0.013 | 3.6502 | 0.043 | 0.012 | 0.002 | 0.067
Well 17 | 2017-05-03 00:00:00 | 7.44 | 4.663 | 27 | 9.63 | 11.5 | 2.703620813683958 | 2.703620813683958 | 0 | 1.79 | 25.656 | 2984 | 2.69 | 6.8 | 0.022 | 5.3322 | 0 | 0.05 | 0 | 0.097
W17 | 2018-05-29 00:00:00 | 7.6 | 4.954 | 29.1 | 10.5 | 13.8 |  | 2.783550475581489 | 0 | 2.19 | 0.844 | 3170.56 |  |  | 0.052 | 3.937 | 0.103 | 0 | 0 | 0.014
Spreadsheet: 880434d1728164557-index-match-needs-one-more-qualifier-test-sheet
Sheet: AR History

Lookup | Date | Ins Charged | Ins Adj | Ins Paid | [NAME] | Date2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Patient Resp | Patient Payment | Outstanding Amt
FrogKermit | 2024-07-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 10
BuffettJimmy | 2024-07-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2
BuffettJimmy | 2024-07-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2.5
CrowCheryl | 2024-07-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 40
CrowCheryl | 2024-07-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 40
CrowCheryl | 2024-07-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 40
CrowCheryl | 2024-07-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 40
Spreadsheet: 67dfd2ee-06e8-450d-846d-a4da42d80848
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42407749 | 2014-07-22 16:13:14 | ALLIES | 1 | 6 | 4 | 1523772 | rice dolar | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
42407991 | 2014-07-22 16:41:31 | AXIS | 0 | 2 | 6 | 1523772 | rice dolar | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
42419116 | 2014-07-23 10:51:42 | ALLIES | 1 | 6 | 3 | 1604857 | BreakerMorant | 7663 | pacific | 1944-07-21 | 1944-07-21 | Guam Landings | Débarquement à Guam
42419220 | 2014-07-23 11:19:08 | AXIS | 1 | 6 | 5 | 1604857 | BreakerMorant | 7663 | pacific | 1944-07-21 | 1944-07-21 | Guam Landings | Débarquement à Guam
42421944 | 2014-07-23 16:48:05 | ALLIES | 1 | 6 | 3 | 1607258 | player1607258 | 7663 | pacific | 1944-07-21 | 1944-07-21 | Guam Landings | Débarquement à Guam
42422080 | 2014-07-23 16:59:18 | AXIS | 0 | 2 | 6 | 1607258 | player1607258 | 7663 | pacific | 1944-07-21 | 1944-07-21 | Guam Landings | Débarquement à Guam
42445451 | 2014-07-25 09:48:33 | ALLIES | 1 | 4 | 0 | 1588103 | meidan.dror | 6158 | western | 1944-06-06 | 1944-06-06 | Pegasus Bridge | Pegasus Bridge
42445500 | 2014-07-25 10:00:26 | AXIS | 0 | 2 | 4 | 1588103 | meidan.dror | 6158 | western | 1944-06-06 | 1944-06-06 | Pegasus Bridge | Pegasus Bridge
42447472 | 2014-07-25 14:47:20 | ALLIES | 1 | 6 | 0 | 1388575 | Shocking Blue | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
Spreadsheet: 111318d1307706970-get-data-rows-from-another-sheet-than-copy-it-data-p
Sheet: Summary

company | info1 | info2 | [NAME] | [NAME] | info5 | info6 | [NAME] | info8 | info9 | info10 | info11 | info12 | info13 | info14 | info15 | info16
Company_1
Company_2
Company_3
Company_4
Company_5
Company_6
Company_7
Company_8
Company_9
Company_10
Company_11
Company_12
Company_13
Spreadsheet: 769915d1645723501-return-blank-depending-on-another-cell-ex1
Sheet: Sheet1

Smith | 123 | 423 | New York | 45 | Paid | 9822 | X | X | X
Russo | 456 | 342 | Chicago | 32 |  | 9125 | X | X | X |  | Should not show up (nothing on Column F)
White | 365 | 963 | Chicago | 46 | Paid | 9672 | X | X | X
Spreadsheet: 211670d1359880524-pattern-matching-within-a-dynamic-data-set-position_spreadsheet-copy
Sheet: 9Mth_Fly

 |  | Fly | Mar13Jun13Sep13 | Jun13Sep13Dec13 | Sep13Dec13Mar14 | [NAME] | Mar14Jun14Sep14 | [NAME] | Sep14Dec14Mar15 | Dec14Mar15Jun15 | Mar15Jun15Sep15 | [NAME]
 | Position
[NAME] |  | Spread | Mar13 [NAME] | [NAME] | [NAME] | Dec13 Mar14 | [NAME] | [NAME] Sep14 | Sep14 Dec14 | Dec14 Mar15 | Mar15 [NAME] | [NAME]
2013-03-18 00:00:00 | 6
2013-06-17 00:00:00 | 0
2013-09-16 00:00:00 | 0
2013-12-16 00:00:00 | -12
2014-03-17 00:00:00 | 0
2014-06-16 00:00:00 | 0
2014-09-15 00:00:00 | 6
2014-12-15 00:00:00 | 0
2015-03-16 00:00:00 | 0
2015-06-15 00:00:00 | 0
2015-09-14 00:00:00 | 0
2015-12-14 00:00:00 | 0
2016-03-14 00:00:00 | 0
2016-06-13 00:00:00 | 0
2016-09-19 00:00:00 | 0
Spreadsheet: 756133d1637296568-turn-a-count-formula-into-a-spilled-array-formula-book-dj
Sheet: Test Example

 |  |  |  |  |  |  |  |  |  | COUNT(IF(AND(Table13[@[Column 2]:[Column 7]]=""),1,""))
Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Column 7
x | x |  |  |  |  |  |  |  |  | =MMULT((Table13="x")*SEQUÊNCIA(ROW(Table13[Column 7]),1,1,0),{1;1;1;1;1;1;1})
 |  |  |  |  |  |  |  | 0 | 0 | =MMULT((Table13="x")*ROW(Table13[Column 7])^0,ROW($A$1:$A$7)^0)
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 | x |  | x |  |  |  |  | 2 | 2
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 | x | x | x |  |  |  |  | 3 | 3
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 | x | x |  |  |  |  |  | 2 | 2
 | x | x |  |  |  |  |  | 2 | 2
 |  |  |  |  |  |  |  | 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
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
Spreadsheet: 694892d1599857920-sumif-not-working-properly-productn-materials-planning-template
Sheet: Eco 9mm

 |  |  |  | Total for 75 batches
100000024101 | 40
100000025436 | 3.96
100000024032 | 15.69
100000023979 | 200
100000023980 | 17.87
100000025444 | 9.93
100000025391 | 0.5
200000009482 | 133
100000002979 | 94
100000025228 | 120
100000025380 | 0.5
100000025401 | 1.4
100000025424 | 2.8
100000025425 | 2.8
100000025873 | 109.55
100000025886 | 60
100000029113 | 100
100000032512 | 1000
100000034290 | 140
100000040473 | 181
100000045271 | 100
Spreadsheet: 57640d1257861334-plots-can-i-have-2-series-with-the-same-symbol-706331-r1
Sheet: Sheet1

 | aa | bb | cc | dd | ee | ff | gg |  |  |  |  |  |  |  |  |  | put | scc
a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0.136723 | 0.81153
b |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 0.1262783 | 0.8057270000000001
c |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 0.11896608 | 0.8056813999999999
d |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 0.11684402 | 0.8056241999999999
f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 0.11661072 | 0.8069504000000001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 0.11485784 | 0.8077186000000001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 0.11445406 | 0.8078566
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 0.11206514 | 0.8096023999999999
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 0.11172506 | 0.8089071999999999
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 0.11077284 | 0.80812