tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 192672d1352486359-coding-macros-for-a-class-shapes-area-etc-macrohelp
Sheet: Problem1

Make a macro to plot "X Y Scatter with Smooth Lines" of the dataset below both with and without the "Use Relative References" option toggled.
Submit the two codes with comments showing the difference between the two varieties.
x | y
1 | 4
2 | 5
3 | 2
4 | 5
5 | 1
6 | 7
7 | 0
8 | 3
9 | 5
10 | 7
11 | 3
12 | 7
13 | 9
14 | 4
15 | 1
16 | 4
17 | 6
18 | 8
19 | 9
20 | 1
Spreadsheet: 760890d1640513721-ms-excel-365-if-sumif-conditional-etc-formula-needed-excel-formula
Sheet: FINAL ATTEN'E

Sr No. | Name | PH | ATTEN'E | AL | Total
1 | Britney Smith | 2 | 18.5
2 | [NAME] | 2 | 20.25
3 | [NAME] | 2 | 18
4 | Tanya West | 2 | 20
5 | [NAME] | 2 | 21.5
Spreadsheet: stacey_white__38880__20001 01 flash report
Sheet: reconciliation

 |  |  |  |  | RECONCILIATION
 | ****  All in "Flash" signs, where negative=expense  and positive=revenue
 | UNIFY versus GL (SAP)
 |  |  |  | 209708432.4 | total Inter. Manuals in Unify don't need to be taken from GL manuals
 |  |  |  | ALL Data |  |  | see [NAME] |  | see intercompany analysis - needs to be plugged | (Unify vs GL - difference)
 |  |  |  | SYSTEM | MANUALS | Reconciled by Others accounts- manual | HARBORCOG - reversal is not picked up in [NAME]'s file | PJM plugged reversal - all offsets 2000 12 Acct | to tie Intercompany(what's in Unify vs. what booked) | TOTALS
 |  |  | [NAME]'s file |  | -9119683.51 |  | 2325458.8 | -8584.44 | 366271.33
 |  |  |  |  |  |  | Added in to Summary Region Table | Added in to Summary Region Table
 |  |  |  |  |  |  | [NAME]'s file does not pick up Unify gas - so we have to plug it in
 | -16397600.15 |  | SAP | -107273898.3 | 90876298.11 |  | in order for [NAME]'s entry to offset
 |  |  |  |  |  |  |  |  | Difference
Spreadsheet: 807652d1669987166-sumifs-with-variable-number-of-dynamic-criteria-sumifs-example
Sheet: Sheet1

Letter | Colour | Region | Date | Value |  | [NAME] | CriteriaRange1 | Operator1 | Criteria1 | CriteriaRange2 | Operator2 | Criteria2 | CriteriaRange3 | Operator3 | Criteria3 | [NAME]
A | Red | Europe | 2022-01-01 00:00:00 | 100 |  | Value | Letter | = | A | Colour | = | Red | Date | >= | 2022-04-01 00:00:00
B | Blue | Americas | 2022-01-01 00:00:00 | 115 |  | Value | Letter | = | A | Colour | = | Red
C | Green | Asia | 2022-01-01 00:00:00 | 130
D | Yellow | Americas | 2022-01-01 00:00:00 | 145
E | Red | Europe | 2022-01-01 00:00:00 | 160
A | Blue | Americas | 2022-01-01 00:00:00 | 175
G | Green | Asia | 2022-01-01 00:00:00 | 190
H | Yellow | Europe | 2022-01-01 00:00:00 | 205
I | Red | Americas | 2022-01-01 00:00:00 | 220
A | Blue | Europe | 2022-01-01 00:00:00 | 235
A | Green | Americas | 2022-07-01 00:00:00 | 250
B | Yellow | Asia | 2022-07-01 00:00:00 | 265
A | Blue | Europe | 2022-07-01 00:00:00 | 280
R | Green | Americas | 2022-07-01 00:00:00 | 295
U | Yellow | Europe | 2022-07-01 00:00:00 | 310
H | Red | Americas | 2022-07-01 00:00:00 | 325
Q | Blue | Asia | 2022-07-01 00:00:00 | 340
W | Green | Europe | 2022-07-01 00:00:00 | 355
D | Yellow | Americas | 2022-07-01 00:00:00 | 370
A | Red | Europe | 2022-07-01 00:00:00 | 385
A | Red | Europe | 2022-07-01 00:00:00 | 400
Spreadsheet: 674222d1587725186-n-a-error-when-using-format-control-with-index-match-client-list
Sheet: Client Data

 |  |  | Products |  |  |  |  | Display
Client | ACV | Renwal Date | Product Reviews | Brand Reviews | Dealership Reviews | AAO | Experiences | URL | Product Reviews | Brand Reviews | Dealership Reviews | AAO | Experiences | Stakeholders | Project?
Company 1 | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Company 2 | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Company 3 | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Company 4 | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Company 5 | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Company 6 | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Company 7 | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Company 8 | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Company 9 | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Company 10 | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Company 11 | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Company 12 | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Spreadsheet: 126463d1319707750-excel-2007-need-some-help-on-conditional-formatting-sample-2-_leon86
Sheet: Sheet1

 | Holland | France | Germany | Italy
Holland | 28 | 30 | 45 | 34 |  |  |  | I just did an example of holland vs other countries -
France | 30 |  | 72 | 120 |  |  |  | So basically I would like to compare the second table to the first table
Germany | 45 | 72 |  | 200 |  |  |  | Hence, if value of 2nd table is above first table it will be highlighted
Italy | 34 | 120 | 200
 |  |  |  |  |  |  |  | The problem I'm facing is that for example, Holland & France there are two different type of sources,
 | Source |  | Destination |  |  | The C/F Formula |  | Holland CC & Holland TP.
 | Holland | Holland CC | France | 30 |  |  |  | How do I make my conditional formating formula compare to both values (24 & 30) instead of one only.
 | Holland | Holland TP | France | 50 |  |  |  | Like in this case it only recognises value 30 and not 50 in table 2
 | Germany | Holland LD | France | 100
 | Holland | Holland WC | Germany | 120 |  |  |  | So is that anyway I could detect the 2nd data as well and highlight it with a different color as such
 | Holland | Holland SC | Germany | 88
 |  |  |  |  |  | Use the Drop-Downs - in B8:B12 and D8:D12 to test
Spreadsheet: 701164d1603574355-how-to-count-the-quantity-per-piece-and-box-quantity
Sheet: Purchase

 | Product Name | Qty | Price | Total Price
 | Product 1 | 10
 | Product 2 | 5
 | Product 3 | 20
 | Product 4 | 2
 | Product 2 | 10
 | Product 1 | 3
Spreadsheet: 843158d1695104707-calculating-prices-for-duplicate-products-based-on-smallest-quantity-excel-forum-19-september
Sheet: Sheet2

Product Name | Quantity | Price (Formula Downwards) | Total
A | 5 |  | 30
A | 5 |  | 30
A | 5 |  | 30
B | 5 |  | 56.1
B | 4 |  | 56.1
B | 4 |  | 56.1
B | 4 |  | 56.1
B | 4 |  | 56.1
C | 5 |  | 34
C | 5 |  | 34
C | 5 |  | 34
F | 5 |  | 68.85
F | 5 |  | 68.85
F | 5 |  | 68.85
F | 5 |  | 68.85
F | 6 |  | 70
H | 4 | D18/B18 shall be 28.05 | 56.1
H | 2 |  | 56.1
H | 2 |  | 56.1
H | 2 |  | 56.1
H | 2 |  | 56.1
K | 4 | D23/B23   shall be 17 | 51
K | 3 |  | 51
K | 3 |  | 51
K | 3 |  | 51
K | 3 |  | 51
Spreadsheet: 865060d1712148030-how-to-merge-2-columns-example-for-merging-data
Sheet: Sheet1

A | B | C (desired outcome)
Microsoft | microsoft.com | microsoft.com
Apple |  | Apple
Dell |  | Dell
 | lenovo.com | lenovo.com
Nvidia |  | Nvidia
 | openai.com | openai.com
Google | google.com | google.com
Facebook | facebook.com | facebook.com
Spreadsheet: 792448d1660911856-sum-and-count-with-identifiers-research-output
Sheet: Sheet1

 | Output |  |  |  |  |  |  |  |  |  |  |  |  | Input (on different tab)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sex | Country | Q19_11R1 | Q19_11R2 | Q19_11R3 | Q19_1R1 | Q19_1R2 | Q19_1R3
 | Filters |  |  |  |  |  |  |  |  |  |  |  |  | Survey 1 | Male | Germany | 4 | 2 | 1 | 4 | 4 | 4
 | Country | Germany |  |  |  |  |  |  |  |  |  |  |  | Survey 2 | Female | Poland | 3 | 5 | 2 | 4 | 4 | 4
 | Sex | Male |  |  |  |  |  |  |  |  |  |  |  | Survey 3 | Male | Germany | 1 | 5 | 3 | 4 | 3 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Survey 4 | Male | Poland |  |  |  | 3 | 2 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Survey 5 | Male | Poland | 1 | 5 | 3 | 4 | 3 | 4
 | Company1 | Company2 | >> Sum | Company 1 | Company 2 |  |  | >> Count | Company 1 | Company 2
 | Q19_11R1 | Q19_1R1 | Fastest |  |  |  |  | Fastest
 | Q19_11R2 | Q19_1R2 | Cheapest |  |  |  |  | Cheapest
 | Q19_11R3 | Q19_1R3 | Slowest |  |  |  |  | Slowest
Spreadsheet: 726189d1617103101-combine-values-in-multiple-cells-by-commas-sample-excel-sheet
Sheet: Output

ctextid | vbillid | claimid | Proccodes | completed | codedby
 | 456 | 123 |  |  | bs12
2567 | 896 | 567 |  |  | adm12
1412 | 456 | 123 | 3074F,3725F,96127,3008F,99214,3078F,99443 | 2021-03-25 03:18:15 | bs12
2567 | 896 | 567 | 99214,3008F,96127,3725F,89023 | 2021-03-27 03:18:15 | adm12
 | 456 | 123 | 44280.13767361111 | bs12
2567 | 896 | 567 | 44282.13767361111 | adm12
Spreadsheet: 153779d1336052248-display-sum-conditionally-111111
Sheet: The Balanced Portfolio

 | Only enter values in the box's below - the rest will automatically update
 | Returns
Products | Initial Amount | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10
Tuscany (Non SIPP)
[NAME]
Green Oil
Projected Bamboo
Standing Teak
Store Pods
[NAME]
[NAME]
Venture Oil
Farmland
Agarwood
US Bond
 |  |  |  |  |  |  |  |  |  |  |  | Totals
Additional Funds to re invest
Total value of fund
Possible Commissions on Re Investment
Spreadsheet: 735533d1623062881-using-formulas-is-it-possible-to-distribute-a-figure-between-specific-columns-monthly-revenue-pipeline
Sheet: CMAP data

Current month | AUD | GBP | EUR | NZD | SGD | USD |  | Sector | Status | Probability | Company | Project | Start month | End month | Revenue remaining | Currency | Likelihood | GBP revenue remaining | Project duration | Months to end | 2021-06-01 00:00:00
 | 0.54 | 1 | 0.86 | 0.51 | 0.53 | 0.71 |  | Energy | Live | 100 | Example | Test | 2020-11-01 00:00:00 | 2021-10-01 00:00:00 | 10 | GBP
Exchange rates |  |  |  |  |  |  |  | Water | Potential | 50 | Example | Test 2 | 2022-02-01 00:00:00 | 2022-04-01 00:00:00 | 20 | USD
Spreadsheet: 273326d1382673448-vlookup-or-if-statement-test-quote-program-excelforum
Sheet: Title Page

 | [NAME] | [NAME]
 | Quotation Reference | R115-0800
 | Customer | ABC Industrial |  |  | Designation | Qty | Flow | Head | Speed | Pricing Factor
 | Contact | [NAME] |  |  | SAMPLE 1 | 2 | 1.5 | 4 | 4 | 1.8
 | [NAME] | [EMAIL] |  |  | SAMPLE 2 | 4 | 2.5 | 6 | 4 | 1.8
 | Project | UNSW - Science Testing Facility, Kensington |  |  | SAMPLE 3 | 2 | 5 | 5 | 4 | 1.8
 | Date | 2011-02-12 00:00:00
 | Pricing Factor
 | Product | YES/NO |  | 1
 | [NAME] | 1 |  | 0
 | Drip Tray | 0
 | Spring Base | 0
 | Seismic Springs | 0
 | High Efficiency Motors | 0
 | Cyclone Separators | 0
 | HDG Bases | 0
 | 50mm Springs | 0
 | IP56 | 0
 | Tropic Proof | 0
 | Standard Base | 0
Spreadsheet: darrell_schoolcraft__7804__imbalsumm0108
Sheet: Oasis

POI  8516
 | Measured | Scheduled | Imbal
1 | -55850 | -55438
2 | -43999 | -43938
3 | -29392 | -29570
4 | -59280 | -59683
5 | -59827 | -59683
6 | -58120 | -57497
7 | -52462 | -52789
8 | -94542 | -93200
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2001-07-31 00:00:00 |  | 34979
 | 2001-08-08 00:00:00
CBS Dollars
 |  |  | -287550.35
Spreadsheet: 734528d1622215945-generate-a-range-of-values-between-specific-dates-test
Sheet: Sheet1

Holiday | Date |  |  |  |  | Date | Holiday | Holiday Value | Column1
New Year's Day | 2021-01-01 00:00:00 |  |  |  |  | 2021-01-31 00:00:00 |  |  | 0.125
Super Bowl | 2021-02-07 00:00:00 |  |  |  |  | 2021-02-01 00:00:00
President's Day | 2021-02-15 00:00:00 |  |  |  |  | 2021-02-02 00:00:00
Good Friday | 2021-04-02 00:00:00 |  |  |  |  | 2021-02-03 00:00:00
Easter | 2021-04-04 00:00:00 |  |  |  |  | 2021-02-04 00:00:00
Cinco de Mayo | 2021-05-05 00:00:00 |  |  |  |  | 2021-02-05 00:00:00
Memorial Day | 2021-05-31 00:00:00 |  |  |  |  | 2021-02-06 00:00:00
Independence Day | 2021-07-04 00:00:00 |  |  |  |  | 2021-02-07 00:00:00 |  | 1
Labor Day | 2021-09-06 00:00:00 |  |  |  |  | 2021-02-08 00:00:00
Veterans Day | 2021-11-11 00:00:00 |  |  |  |  | 2021-02-09 00:00:00
Thanksgiving | 2021-11-26 00:00:00 |  |  |  |  | 2021-02-10 00:00:00
Christmas | 2021-12-25 00:00:00 |  |  |  |  | 2021-02-11 00:00:00
 |  |  |  |  |  | 2021-02-12 00:00:00
 |  |  |  |  |  | 2021-02-13 00:00:00
 |  |  |  |  |  | 2021-02-14 00:00:00
 |  |  |  |  |  | 2021-02-15 00:00:00 |  | 1
 |  |  |  |  |  | 2021-02-16 00:00:00
 |  |  |  |  |  | 2021-02-17 00:00:00
 |  |  |  |  |  | 2021-02-18 00:00:00
 |  |  |  |  |  | 2021-02-19 00:00:00
 |  |  |  |  |  | 2021-02-20 00:00:00
 |  |  |  |  |  | 2021-02-21 00:00:00
 |  |  |  |  |  | 2021-02-22 00:00:00
 |  |  |  |  |  | 2021-02-23 00:00:00
Spreadsheet: 0c7cfd4d-5606-4a0b-8830-a92f0eb6bbc0
Sheet: Sheet1

AGCO CORP /DE | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
SC 13D
04/09/2013
AGCO CORPORATION
1 |  | NAMES OF REPORTING PERSONS
 |  | Tractors and Farm Equipment Limited
2 |  | CHECK THE APPROPRIATE BOX IF A MEMBER OF
 |  | A GROUP
 |  | (a) x
 |  | (b) o
3 |  | SEC USE ONLY
4 |  | SOURCE OF FUNDS
 |  | WC
5 |  | CHECK IF DISCLOSURES OF LEGAL PROCEEDINGS
 |  | IS REQUIRED PURSUANT TO ITEMS 2(d) OR 2(e)
6 |  | CITIZENSHIP OR PLACE OF ORGANIZATION
 |  | Republic of India
NUMBER OF |  |  | 7 | SOLE VOTING POWER
SHARES
BENEFICIALLY |  |  |  | 0
OWNED BY
EACH
REPORTING |  |  | 8 | SHARED VOTING POWER
PERSON
WITH |  |  |  | 5305858
 |  |  | 9 | SOLE DISPOSITIVE POWER
 |  |  |  | 0
 |  |  | 10 | SHARED DISPOSITIVE POWER
 |  |  |  | 5305858
11 | AGGREGATE AMOUNT BENEFICIALLY OWNED BY
 | EACH REPORTING PERSON
 | 5305858
12 | CHECK IF THE AGGREGATE AMOUNT IN ROW (11)
 | EXCLUDES CERTAIN SHARES
 | x
13 | PERCENT OF CLASS REPRESENTED BY AMOUNT
 | IN ROW (11)
 | 5.5%
14 | TYPE OF REPORTING PERSON
 | CO
____________________________
Created by Morningstar Document Research.
http://documentresearch.morningstar.com/
Spreadsheet: 56015d1256146590-conditional-format-using-data-from-another-grid-condform-4-
Sheet: Sheet1

card# | bin#
1111111111 | 11111111 |  |  | 2nd document = Sheet2
2222222222 | 22222222
3333333333 | 33333333
4444444444 | 44444444
5555555555 | 55555555
6666666666 | 66666666
7777777777 | 77777777
8888888888 | 88888888
9999999999 | 99999999
Spreadsheet: 734614d1622285735-how-to-sort-using-formula-test
Sheet: Sheet1

Name | Today | Yesterday |  |  | Name | Today |  | Name | Yesterday
Banglamotor | 15 | 27 |  |  | [NAME] | 44 |  | Mohakhali | 101
Mohakhali | 26 | 101 |  |  | Comilla | 33 |  | Barisal | 101
Barisal | 26 | 101 |  |  | Khulna | 31 |  | Muradpur | 96
[NAME] | 20 | 58 |  |  | Rangpur | 27 |  | [NAME] | 94
Khulna | 31 | 0 |  |  | Sylhet | 27 |  | Comilla | 88
[NAME] | 44 | 94 |  |  | Mohakhali | 26 |  | [NAME] | 58
Muradpur | 23 | 96 |  |  | Barisal | 26 |  | Tangail | 43
Comilla | 33 | 88 |  |  | [NAME] | 24 |  | Mymensingh | 30
Rangpur | 27 | 28 |  |  | Agrabad | 24 |  | Rangpur | 28
[NAME] | 24 | 10 |  |  | Muradpur | 23 |  | Jessore | 28
[NAME] | 13 | 25 |  |  | [NAME] | 20 |  | Banglamotor | 27
Jessore | 16 | 28 |  |  | Mymensingh | 17 |  | [NAME] | 25
Mymensingh | 17 | 30 |  |  | Jessore | 16 |  | Sylhet | 22
Sylhet | 27 | 22 |  |  | Banglamotor | 15 |  | Agrabad | 21
Faridpur | 13 | 7 |  |  | [NAME] | 13 |  | [NAME] | 10
Tangail | 7 | 43 |  |  | Faridpur | 13 |  | Faridpur | 7
Agrabad | 24 | 21 |  |  | Tangail | 7 |  | Khulna | 0
Spreadsheet: 842667d1694688826-using-filter-and-xlookup-with-tables-test
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | Fund | Fund 1
 |  |  |  |  |  |  |  |  |  |  |  |  | From | 2007-08-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | To | 2008-01-31 00:00:00
 |  | Date | Benchmark | Fund 1 | Fund 2 |  | Date
 |  | 2007-07-31 00:00:00 | 0.00475384615384609 |  |  |  |  | 0.00610329670329669 | 0 | 0
 |  | 2007-08-31 00:00:00 | 0.00610329670329669 |  |  |  | 39355 | 0.00745274725274719 | 0 | 0
 |  | 2007-09-30 00:00:00 | 0.00745274725274719 |  |  |  | 39386 | 0.0088021978021978 | 0 | 0
 |  | 2007-10-31 00:00:00 | 0.0088021978021978 |  |  |  | 39416 | 0.0101516483516483 | 0 | 0
 |  | 2007-11-30 00:00:00 | 0.0101516483516483 |  |  |  | 39447 | 0.0115010989010989 | 0 | 0
 |  | 2007-12-31 00:00:00 | 0.0115010989010989 |  |  |  | 39478 | 0.0128505494505494 | 0.091 | 0
 |  | 2008-01-31 00:00:00 | 0.0128505494505494 | 0.091
 |  | 2008-02-29 00:00:00 | 0.0142 | -0.0123
 |  | 2008-03-31 00:00:00 | 0.0155494505494505 | -0.004 | 0.0034
 |  | 2008-04-30 00:00:00 | 0.0168989010989011 | -0.0076 | 0.0025
 |  | 2008-05-31 00:00:00 | 0.0182483516483516 | 0.064 | -0.346
 |  | 2008-06-30 00:00:00 | 0.0195978021978022 | -0.05 | 0.02352
 |  | 2008-07-31 00:00:00 | 0.0209472527472527 | -0.023 | 0.00234
 |  | 2008-08-31 00:00:00 | 0.0222967032967033 | 0.018 | 0.00623
 |  | 2008-09-30 00:00:00 | 0.0236461538461538 | 0.0087 | -0.0232
 |  | 2008-10-31 00:00:00 | 0.0123 | -0.00434615384615387 | -0.00234
 |  | 2008-11-30 00:00:00 | 0.024 | -0.00672197802197807 | 0.04
 |  | 2008-12-31 00:00:00 | 0.0076 | -0.00909780219780217 | 0.34
 |  | 2009-01-31 00:00:00 | 0.024 | -0.0114736263736264 | 0.045
 |  | 2009-02-28 00:00:00 | 0.054 | -0.0138494505494506 | 0.023
 |  | 2009-03-31 00:00:00 | 0.027 | -0.0162252747252748 | 0.043
 |  | 2009-04-30 00:00:00 | -0.012 | -0.0186010989010989 | 0.034
 |  | 2009-05-31 00:00:00 | 0.0834 | -0.0209769230769231 | 0.114638681318681
 |  | 2009-06-30 00:00:00 | 0.0926 | -0.0233527472527473 | 0.128100505494506
 |  | 2009-07-31 00:00:00 | 0.1023 | -0.0257285714285715 | 0.14156232967033
 |  | 2009-08-31 00:00:00 | -0.024 | -0.0281043956043956 | 0.155024153846154
 |  | 2009-09-30 00:00:00 | 0.0367 | -0.0304802197802198 | 0.168485978021978
 |  | 2009-10-31 00:00:00 | 0.0023 | -0.032856043956044 | 0.181947802197802
 |  | 2009-11-30 00:00:00 | 0.0425384615384616 | -0.0352318681318682 | 0.195409626373626
 |  | 2009-12-31 00:00:00 | 0.0438879120879121 | -0.0376076923076923 | 0.208871450549451
 |  | 2010-01-31 00:00:00 | 0.0452373626373627 | -0.0399835164835165 | 0.222333274725275
 |  | 2010-02-28 00:00:00 | 0.0465868131868132 | -0.0423593406593407 | 0.235795098901099
Spreadsheet: 764890d1643055119-need-help-excluding-some-data-report632
Sheet: P2

 | PROGRAM Info (changes infrequently) |  |  |  |  |  |  | OVERALL STATUS |  |  |  |  |  |  | MILESTONES |  |  |  | RECENT ACCOMPLISHMENTS |  | KEY ISSUES / RISKS |  |  |  |  | NEXT STEPS
 | Project ID | Project Name | Department | Executive Sponsor | [NAME] | Project Manager | Parent Program | Target Completion Date | Status | Percent Complete | Overall Status | Scope | Schedule | Resources | Name | Due Date | Status | Health | Name | Due Date2 | [NAME] | Due Date3 | Priority (Impact & Probability) | Status | Mitigation | Name3 | Due [NAME] | Status 2
 | Numeric | Text | Text | Text | Text | Text | Text | Date | Status Dropdown | Numeric - Percentage | Health (current)  [NAME] | Scope RAG Status | Schedule  [NAME] | Resources [NAME] | Text | Date | Status | [NAME] | Text | Date | Text | Date | Low /  Normal / High | Status Dropdown | Text | Text | Date | Status Dropdown
 | 209
Spreadsheet: 738734d1625221706-formula-to-calculate-total-amount-of-previous-invoice-book1
Sheet: Numbering (2)

Project Name | Sequence |  | ddd | IFA |  | Project | ddd | IFA | Invoice Total Amount |  |  |  |  | Current IAF | PO No. | Total amount of Previous Invoice | Total amount of Previous Invoice
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000 |  |  |  |  |  | correct value according to O2
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123457 |  |  |  |  |  |  |  |  | 1000
Lab-45123458 |  |  |  |  |  |  |  |  | 1000
Lab-45123459 |  |  |  |  |  |  |  |  | 1000
Spreadsheet: sally_beck__33835__Log as of 9 Nov 00
Sheet: Sum Nov 1 to 8

 | Week summary (Nov 1-8)
Cat. | Description | Total |  | Breakdown of Cat 1
1 | Human Errors | 10 |  | Book not officialized | 7
2 | IT Hardware problems |  |  | Other | 3
3 | IT Software Problems | 19 |  | Total
4 | Miscellaneous | 4
5 | Uncontrollable
 | Total |  |  | Breakdown of Cat 3
 |  |  |  | System problems | 19
 |  |  |  | Other | 0
 |  |  |  | Total
 |  |  |  | Breakdown of Cat 4
 |  |  |  | Credit interface | 1
 |  |  |  | Other | 3
 |  |  |  | Total
Spreadsheet: 703882d1605206233-if-isnumber-search-and-or-with-extra-criteria-erf-log-projects
Sheet: VLV Parity

ERF | Site [NAME] | Bay(s) | Date (Estimate Complete) | SORT ALL FROM HERE 2 Date  (Outage Start) | SORT ALL FROM HERE 1 Probability | Rate | Hours  (Base) | Cost (Base) | Date  (Estimate  Void  365 Days) | Status
Spreadsheet: 216830d1361902938-newbie-solver-issue-solver-vendors
Sheet: Solver

 | 15 | 14 | 13 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1
Changing Cells | 5 | 2 | 1 | 3 | 1 | 1 | 4 | 1 | 1 | 2 | 1 | 1 | 2 | 1
 | Lot1 | Lot2 | Lot3 | Lot4 | Lot5 | Lot6 | Lot7 | Lot8 | Lot9 | [NAME] | Lot11 | Lot12 | Lot13 | Lot14
Vendor1 | 20 | 123 | 20 | 300 | 20 | 20 | 123 | 2 | 20 | 21 | 21 | 432 | 231 | 20 | Vendor1
Vendor2 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | Vendor2
Vendor3 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | Vendor3
Vendor4 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 2312 | 80 | 80 | 80 | 80 | 80 | 80 | Vendor4
Vendor5 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | Vendor5
Vendor6 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | Vendor6
Minimun following restrictions
 |  | Restriction
Vendor1 |  | 6 |  |  |  |  | Min
Vendor2 |  | 4
Vendor3 |  | 3
Vendor4 |  | 2
Vendor5 |  | 1
Vendor6 |  | 1
Spreadsheet: 878259d1725324992-cell-referencing-and-colloborating-data-sept-9-3-eba
Sheet: Daily Summary

WorkCenter | Bag Type (choose one) | Product Type (choose one) | Length | [NAME] | Target BPM | Actual BPM | Scrap (LBS) | ZAHN INK (seconds) | Hourly Total Uptime | [NAME] | Downtime/HR (mins) | Reason for Unplanned downtime/Scrap |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Helper1 | Helper2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BM 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BM 33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BM 37
Spreadsheet: 52364d1252060251-hiding-duplicates-example-list-2-
Sheet: Sheet1

ID | Name | Job Type | Job Description
23 | Jones | A | Cut
23 | Jones | A | Paste
23 | Jones | A | Laminate
24 | Smith | B | Draw
24 | Smith | B | Cut
24 | Smith | B | Paste
24 | Smith | B | Laminate
25 | [NAME] | C | Cut
25 | [NAME] | C | Paste
26 | [NAME] | D | Draw
26 | [NAME] | D | Cut
26 | [NAME] | D | Paste
26 | [NAME] | D | Laminate