tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 109777d1306532849-split-data-range-into-four-distributions-creating-pop-ranges
Sheet: Sheet1

Name | Count | Category |  |  | Descriptive Stats
ZZZ | 9705 |  |  |  | Mean | 3874.848101265823 |  | 0 | Small
I | 9551 |  |  |  | Standard Error | 228.4589562117346 |  |  | Medium
Q | 9273 |  |  |  | Median | 3516 |  |  | Large
F | 8043 |  |  |  | Mode | #N/A
RR | 7299 |  |  |  | Standard Deviation | 2030.587619186886
OOO | 6881 |  |  |  | Sample Variance | 4123286.079195065
B | 6584 |  |  |  | Kurtosis | 0.6040836936961984
JJJ | 6391 |  |  |  | Skewness | 0.7735292610507364
Y | 6300 |  |  |  | Range | 9080
L | 5996 |  |  |  | Minimum | 625
CC | 5777 |  |  |  | Maximum | 9705
MMM | 5661 |  |  |  | Sum | 306113
OO | 5592 |  |  |  | Count | 79
PP | 5588
J | 5554
NNN | 5528
FF | 5494
JJ | 5493
III | 5410
RRR | 5268
C | 5237
CCC | 5222
BB | 5017
GGG | 4871
AAAA | 4657
G | 4655
[NAME] | 4617
K | 4425
UUU | 4359
VV | 4147
A | 4145
QQ | 4069
YYY | 4060
DDD | 3904
E | 3900
NN | 3821
GG | 3753
LL | 3733
YY | 3564
D | 3516
AA | 3508
EEE | 3469
S | 3452
H | 3433
MM | 3429
ZZ | 3353
HH | 3185
EE | 3153
FFF | 3041
SSS | 3029
QQQ | 3023
DD | 2998
P | 2863
II | 2806
HHH | 2784
AAA | 2692
T | 2638
U | 2617
PPP | 2407
XX | 2398
W | 2331
KKK | 2068
V | 2051
Z | 1991
LLL | 1977
UU | 1891
TTT | 1789
KK | 1650
TT | 1605
WW | 1590
BBB | 1546
VVV | 1403
M | 1344
SS | 1253
O | 1176
N | 982
R | 846
X | 657
WWW | 625
Spreadsheet: 02e36d03-14a0-4c29-9e83-502963ef59c7
Sheet: 4-3T

 | Section 4: Utilization
 | Table 4-3Trend: [NAME], Domestic and Foreign by Year
 | Vehicles Based | 2009 | 2010 | 2011 | 2012 | 2013
 | Domestic | 4683262760 | 4850679207.9 | 4933831370 | 4819618209 | 4508100975
 | Foreign | 356825637 | 346683138 | 314424024.9 | 351237885 | 311427938.9
 | Grand Total | 5040088397 | 5197362345.9 | 5248255395 | 5170856094 | 4819528914
Spreadsheet: 109214d1306153735-indirect-help-777051-indirect-help
Sheet: Summary

March | Validation here |  | March |  |  | February
Account Number | Account Name | Country | Total Market Value | Cash  Value | % Cash | Total Market Value | Cash  Value | % Cash
111 | Murphy | UK | 3110 | 70 | 0.022508038585209 | 110 | 70 | 0.6363636363636364
222 | Jones | US | 3300 | 200 | 0.06060606060606061 | 300 | 200 | 0.6666666666666666
333 | Smith | SCO | 3500 | 150 | 0.04285714285714286 | 500 | 150 | 0.3
 |  |  |  |  |  |  |  |  |  |  | January
 |  |  |  |  |  |  |  |  |  |  | February
 |  |  |  |  |  |  |  |  |  |  | March
 |  |  |  |  |  |  |  |  |  |  | April
 |  |  |  |  |  |  |  |  |  |  | May
 |  |  |  |  |  |  |  |  |  |  | June
 |  |  |  |  |  |  |  |  |  |  | July
 |  |  |  |  |  |  |  |  |  |  | August
 |  |  |  |  |  |  |  |  |  |  | September
 |  |  |  |  |  |  |  |  |  |  | October
 |  |  |  |  |  |  |  |  |  |  | November
 |  |  |  |  |  |  |  |  |  |  | December
Spreadsheet: 863100d1710669563-extracting-unique-data-from-repeating-parameters-in-excel-dynamic-approach-needed-nilaakash_1
Sheet: Sheet1

Parameter-a | Parameter-b | Data |  | My code | [NAME] set |  | Data output ([NAME]) |  |  |  |  | Average | Median | Standard Deviation
a1 | b1 | 75 |  | (not fully dynamic) |  | b1 |  | 92 |  |  |  |  | ? | ?
a1 | b1 | 92 |  |  | a1 | b2 |  | 31 | 75 |  |  | 55.66666666666666
a1 | b2 | 61 |  |  | a2 | b1 |  | 1931 | 1808 |  |  | 1273.666666666667
a1 | b2 | 31 |  |  | a2 | b2 |  | 1350 | 1268 | 1105 |  | 1574.5
a1 | b2 | 75
a2 | b1 | 82
a2 | b1 | 1931
a2 | b1 | 1808
a2 | b2 | 2575 |  | Your code |  | b1 | 75 | 92
a2 | b2 | 1350 |  | (dynamic) | a1 | b2 | 61 | 31 | 75
a2 | b2 | 1268 |  |  | a2 | b1 | 82 | 1931 | 1808
a2 | b2 | 1105 |  |  | a2 | b2 | 2575 | 1350 | 1268 | 1105
Spreadsheet: b0e03d41-569e-4798-be49-28eda9f04af2
Sheet: Sheet1

Release: ADP National Employment Report | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=194
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-10-31 10:11 AM [NAME]
 | Real-Time | Period
Name: | Start | End
ADP National Employment Report | 2011-02-02 00:00:00 | Current
Link:
http://www.adpemploymentreport.com/ | 2011-02-02 00:00:00 | Current
Source:
Automatic Data Processing, Inc. | 2011-02-02 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2011-02-02 00:00:00
2011-03-02 00:00:00
2011-03-30 00:00:00
2011-05-04 00:00:00
2011-06-01 00:00:00
2011-07-07 00:00:00
2011-08-03 00:00:00
2011-08-31 00:00:00
2011-10-05 00:00:00
2011-11-02 00:00:00
2011-11-30 00:00:00
2012-01-05 00:00:00
2012-02-01 00:00:00
2012-03-07 00:00:00
2012-04-04 00:00:00
2012-05-02 00:00:00
2012-05-31 00:00:00
2012-07-05 00:00:00
2012-08-01 00:00:00
2012-09-06 00:00:00
2012-10-03 00:00:00
2012-10-24 00:00:00
2012-11-01 00:00:00
2012-12-05 00:00:00
2013-01-03 00:00:00
2013-01-30 00:00:00
2013-03-06 00:00:00
2013-04-03 00:00:00
2013-05-01 00:00:00
2013-06-05 00:00:00
2013-07-03 00:00:00
2013-07-31 00:00:00
2013-09-05 00:00:00
2013-10-02 00:00:00
2013-10-30 00:00:00
2013-12-04 00:00:00
2014-01-08 00:00:00
2014-02-05 00:00:00
2014-03-05 00:00:00
2014-04-02 00:00:00
2014-04-30 00:00:00
2014-06-04 00:00:00
2014-07-02 00:00:00
2014-07-30 00:00:00
2014-09-04 00:00:00
2014-10-01 00:00:00
Spreadsheet: 85831d1285861648-unique-drop-down-per-cell-that-references-one-table-mimi-excel-dropdowns
Sheet: Sheet1

Here's the table of data:
Agreement ID | Commodity
A1 | Piping
A1 | Flange
A1 | Labor
A1 | Engineering
A1 | Crude
A2 | Piping
A2 | Crude
A2 | Engineering
A5 | Labor
A5 | Crude
A8 | Piping
A8 | Flange
Here is the flat file where every agreement only appears once per row and would like to have a custom drop down for user to designate commodity.  Then they would enter in the spend per that commodity/agreement
Agreement ID | Designate commodity type | Spend
A1
A2
A5
A8
Spreadsheet: 864832d1711975422-formula-to-work-out-the-invoice-due-date-sample-data-etaf
Sheet: Data

Supplier Code | [NAME] | Blanket Agreement | Type | Doc. No. | Instal. No. | Invoice Date | Balance Due | Payment Terms | Invoice Due Date |  | Days payment terms |  | Due date using Lookup
S100134 | AA |  | PU | 57639 | 1 | 2023-12-08 00:00:00 | -401.34 | 90 days EOM
S100134 | AA |  | PU | 58589 | 1 | 2024-01-22 00:00:00 | -776.1 | 90 days EOM
S101445 | CC |  | PU | 58233 | 1 | 2023-12-19 00:00:00 | -7158.26 | 75 Days
S102866 | DD |  | PU | 59151 | 1 | 2024-02-07 00:00:00 | -8479.37 | 28 Days
S104867 | EE |  | PU | 57466 | 1 | 2023-11-30 00:00:00 | -11609.63 | 120 Days EOM
S104867 | EE |  | PU | 57544 | 1 | 2023-12-06 00:00:00 | -176.4 | 120 Days EOM
S105099 | MM |  | PU | 59001 | 1 | 2024-01-25 00:00:00 | -778.8 | 30 Days
S105655 | FF |  | PU | 59023 | 1 | 2024-01-23 00:00:00 | -2540 | 30 Days
S106244 | GG |  | PU | 57555 | 1 | 2023-12-05 00:00:00 | -340.08 | 60 Days EOM
S106244 | GG |  | PU | 59075 | 1 | 2024-02-02 00:00:00 | -121.74 | 60 Days EOM
S106623 | HH |  | PU | 58821 | 1 | 2024-01-26 00:00:00 | -453.8 | 30 days EOM
S106623 | HH |  | PU | 59404 | 1 | 2024-02-23 00:00:00 | -778.57 | 30 days EOM
S106655 | TT |  | PU | 59407 | 1 | 2024-02-27 00:00:00 | -4679.76 | 60 Days
S107877 | JJ |  | PU | 59218 | 1 | 2024-01-31 00:00:00 | -4930.1 | 60 Days
Spreadsheet: bb11615d-cb07-48d6-ac3d-7babc7b27e16
Sheet: 7.3 Page

7.3 Overseas arrivals—visitors and settlers
Month | 2010–11 | 2011–12 | 2012–13 | 2013–14 | 2014–15
Visitors (a) (b) – '000
July | 485.9 | 483.8 | 502.2 | 529.5 | 576.6
August | 489.2 | 487.5 | 506.2 | 534.7 | 577.7
September | 491.4 | 489.1 | 510 | 540.1 | 578.7
October | 491.7 | 488.9 | 512.8 | 545.4
November | 489.9 | 488.4 | 514 | 550
December | 486.6 | 488.3 | 513.7 | 554.7
January | 482.4 | 489.3 | 512.8 | 559.8
February | 478.2 | 491.2 | 512.1 | 564.7
March | 474.9 | 493.4 | 512.6 | 568.9
April | 473.7 | 495.3 | 514.8 | 571.8
May | 475.1 | 497.1 | 519.1 | 573.5
June | 479.1 | 499.2 | 524.3 | 575.2
Annual | 5798.1 | 5891.500000000001 | 6154.6 | 6668.3
Settlers (c) – '000
July | 9.71 | 11.45 | 11.74 | 11.77 | 9.62
August | 11.57 | 12.88 | 13.22 | 13.49 | 11.79
September | 10.83 | 12.72 | 12.48 | 12.19 | 10.45
October | 9.37 | 12.35 | 11.94 | 12.05
November | 9.43 | 12.89 | 11.56 | 11.38
December | 10.02 | 13.9 | 12.94 | 11.93
January | 10.51 | 14.21 | 12.39 | 11.61
February | 10.52 | 14.44 | 12.68 | 11.71
March | 11.61 | 14.67 | 14.09 | 11.72
April | 11.21 | 13.33 | 12.64 | 10.81
May | 10.99 | 12.65 | 13.15 | 11.59
June | 11.7 | 13.46 | 13.58 | 10.38
Annual | 127.47 | 158.95 | 152.41 | 140.63
(a) Monthly figures are trend figures.
(b) Visitors are overseas visitors whose intended stay in Australia is less than 12 months.
(c) Settlers are travellers who hold migrant visas, New Zealand citizens who indicate an intention to settle, and those who are otherwise eligible to settle. |  |  |  |  |  |  |  | Update
Source: ABS, Overseas arrivals and departures, Cat. no. 3401.0 | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=3401.0&viewtitle=Overseas%20Arrivals%20and%20Departures,%20Australia~Jan%202008~Latest~6/03/2008&&tabname=Past%20Future%20Issues&prodno=3401.0&issue=Jan%202008&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=3401.0&viewtitle=Overseas%20Arrivals%20and%20Departures,%20Australia~Jan%202008~Latest~6/03/2008&&tabname=Past%20Future%20Issues&prodno=3401.0&issue=Jan%202008&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=3401.0&viewtitle=Overseas%20Arrivals%20and%20Departures,%20Australia~Jan%202008~Latest~6/03/2008&&tabname=Past%20Future%20Issues&prodno=3401.0&issue=Jan%202008&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=3401.0&viewtitle=Overseas%20Arrivals%20and%20Departures,%20Australia~Jan%202008~Latest~6/03/2008&&tabname=Past%20Future%20Issues&prodno=3401.0&issue=Jan%202008&num=&view=& |  |  |  | 2014-12-05 00:00:00
Spreadsheet: 136734d1326810855-conditional-formatting-between-columns-in-diferent-worksheets-cfs170112
Sheet: Column1

Column 1 |  | Column 2
A |  | A
B |  | B
C |  | C
A |  | A
B |  | B
C | -> This cell might be highlighted | D
A |  | A
B |  | B
C |  | C
A |  | A
B |  | B
C | -> This cell might be highlighted | D
Spreadsheet: 686009d1594311349-countifs-with-date-range-formula-broke-mdf-to-fix
Sheet: Analyst

Analyst | Market
[NAME] | Dade
[NAME] | Dade
[NAME] | Dade
Troy Goings | Dade
[NAME] | Dade
[NAME] | Broward
[NAME] | Broward
[NAME] | Broward
[NAME] | Broward
Marcus Evans | Broward
[NAME] | Palm West
[NAME] | Palm West
[NAME] | Palm West
[NAME] | Palm West
[NAME] | Palm West
[NAME] | Treasure Cost
[NAME] | Treasure Cost
[NAME] | Treasure Cost
[NAME] | Treasure Cost
[NAME] | Treasure Cost
[NAME] | Treasure Cost
Spreadsheet: 845770d1697122538-subtract-formula-based-on-row-colour-subtract-formula-based-on-row-colour
Sheet: Sheet1

EXMP - 1 | STRIKE | PRICE |  | PRICE |  | TOTAL
 | 17500 | 8264 |  | 83845
 | 17550 | 10959 |  | 72979
 | 17600 | 98133 |  | 138793 |  |  |  |  | DEAR SIR / MAM
 | 17650 | 103658 |  | 78675 |  |  |  |  | In this 2 Example I want Auto Subtract the amount in G Column based on the Row Color
 | 17700 | 106643 |  | 28250 |  |  |  |  | The Colored Row Automatically move up and down in regular interval
 | 17750 | 80848 |  | 4296 |  |  |  |  | so I want Conditional formula / Function in G Column based on Row Color
EXMP - 2 | STRIKE | PRICE |  | PRICE
 | 17500 | 8264 |  | 83845
 | 17550 | 10959 |  | 72979
 | 17600 | 98133 |  | 138793
 | 17650 | 103658 |  | 78675
 | 17700 | 106643 |  | 28250
 | 17750 | 80848 |  | 4296
Spreadsheet: 726735d1617390874-convert-text-days-hours-minutes-to-total-hours-019-get-day-hour-minute-second-from-text
Sheet: PQ

 |  | DataO | Duration
 |  | 2 Days 2 Hours 3 Minutes 40 Seconds | 1900-01-02 02:03:40
 |  | 1 Day 20 Hours 5 Minutes | 1900-01-01 20:05:00
 |  | 1 Hour 5 Minutes | 01:05:00
 |  | 10 hours 1 seconds | 10:00:01
 |  | 25 Minutes 50 seconds | 00:25:50
 |  | 2 Days 5 seconds | 1900-01-02 00:00:05
 |  | 10 Days | 1900-01-10 00:00:00
 |  | DataO | Final Duration | day | hour | minute | second
 |  | 2 Days 2 Hours 3 Minutes 40 Seconds | 1900-01-02 02:03:40 | 2 | 2 | 3 | 40
 |  | 1 Day 20 Hours 5 Minutes | 1900-01-01 20:05:00 | 1 | 20 | 5 | 0
 |  | 1 Hour 5 Minutes | 01:05:00 | 0 | 1 | 5 | 0
 |  | 10 hours 1 seconds | 10:00:01 | 0 | 10 | 0 | 1
 |  | 25 Minutes 50 seconds | 00:25:50 | 0 | 0 | 25 | 50
 |  | 2 Days 5 seconds | 1900-01-02 00:00:05 | 2 | 0 | 0 | 5
 |  | 10 Days | 1900-01-10 00:00:00 | 10 | 0 | 0 | 0
 |  | let     Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],     #"Duplicated Column" = Table.DuplicateColumn(Source, "Data", "DataO"),     #"Added Suffix" = Table.TransformColumns(#"Duplicated Column", {{"Data", each _ & " ", type text}}),     #"Replaced Value" = Table.ReplaceValue(#"Added Suffix","s "," ",[NAME].ReplaceText,{"Data"}),     #"Capitalized Each Word" = Table.TransformColumns(#"Replaced Value",{{"Data", Text.Proper, type text}}),     #"Split Column by Delimiter" = Table.ExpandListColumn(Table.TransformColumns(#"Capitalized Each Word", {{"Data", [NAME].[NAME](" ", [NAME].Csv), let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "Data"),     #"Filtered Rows" = Table.SelectRows(#"Split Column by Delimiter", each ([Data] <> "")),     #"Added Conditional Column" = Table.AddColumn(#"Filtered Rows", "Cal", each if [Data] = "Day" then 1 else  if [Data] = "Hour" then 1/24 else if [Data] = "Minute" then 1/24/60 else  if [Data] = "Second" then 1/24/60/60 else null  ,type number),     #"Filled Up" = Table.FillUp(#"Added Conditional Column",{"Cal"}),     #"Changed Type" = Table.TransformColumnTypes(#"Filled Up",{{"Data", Int64.Type}}),     #"Removed Errors" = Table.RemoveRowsWithErrors(#"Changed Type", {"Data"}),     #"Inserted Multiplication" = Table.AddColumn(#"Removed Errors", "Multiplication", each [Data] * [Cal], type number),     #"Grouped Rows" = Table.Group(#"Inserted Multiplication", {"DataO"}, {{"Number", each List.Sum([Multiplication]), type number}}),     #"Duplicated Column1" = Table.DuplicateColumn(#"Grouped Rows", "Number", "Duration"),     #"Changed Type1" = Table.TransformColumnTypes(#"Duplicated Column1",{{"Duration", type duration}}) in     #"Changed Type1"
Spreadsheet: 549019d1511421215-idea-needed-for-car-tracking-table-car-tracking
Sheet: Sheet1

 | R = Being Rent
 | I=Idle
 | W=Workshop
Vehicle No | 2017-01-01 00:00:00 | 2017-01-02 00:00:00 | 2017-01-03 00:00:00 | 2017-01-04 00:00:00 | 2017-01-05 00:00:00 | 2017-01-06 00:00:00 | 2017-01-07 00:00:00 | 2017-01-08 00:00:00 | 2017-01-09 00:00:00 | 2017-01-10 00:00:00 | 2017-01-11 00:00:00 | 2017-01-12 00:00:00 | 2017-01-13 00:00:00 | 2017-01-14 00:00:00 | 2017-01-15 00:00:00 | 2017-01-16 00:00:00 | 2017-01-17 00:00:00 | 2017-01-18 00:00:00 | 2017-01-19 00:00:00 | 2017-01-20 00:00:00 | 2017-01-21 00:00:00 | 2017-01-22 00:00:00 | 2017-01-23 00:00:00 | 2017-01-24 00:00:00 | 2017-01-25 00:00:00 | 2017-01-26 00:00:00 | 2017-01-27 00:00:00 | 2017-01-28 00:00:00 | 2017-01-29 00:00:00 | 2017-01-30 00:00:00 | 2017-01-31 00:00:00
SCP1234G | R | R | R | R | R | R | R | R | R | R | R | R | R | I | R | R | R | R | R | R | R | R | R | R | R | R | R | R | W | I | I
ABC56H | I | I | I | I | I | I | R | R | R | R | R | R | R | R | R | R | R | R | W | R | R | R | R | R | R | R | R | R | R | R | R
SSR9811J | R | R | R | R | R | R | R | R | R | R | I | I | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R
Spreadsheet: 186058d1349911391-i-need-help-with-auto-summing-unique-groups-and-formatting-automatically-sumeachgroup-area-excelnewbb-ef867320-sdg15
Sheet: Sheet1

test 1 | 10
test 1 | 10
test 1 | 10
test 2 | 20
test 2 | 20
test 2 | 20
test 3 | 30
test 3 | 30
test 3 | 30
 |  |  |  |  |  |  |  |  |  | SumEachGroup Area - excelnewbb - EF867320 - SDG15.xls
 |  |  |  |  |  |  |  |  |  | Today, 06:18 PM#1
 |  |  |  |  |  |  |  |  |  | Join Date: 10-10-2012Location: arizona MS-Off Ver: Excel 2003Posts: 1
 |  |  |  |  |  |  |  |  |  | I need help with auto summing unique groups and formatting automatically.
 |  |  |  |  |  |  |  |  |  | http://www.excelforum.com/excel-general/867320-i-need-help-with-auto-summing-unique-groups-and-formatting-automatically.html
 |  |  |  |  |  |  |  |  |  | I am trying to auto sum each unique group, bold the subtotal, and then add a break before the next group.
 |  |  |  |  |  |  |  |  |  | example:
 |  |  |  |  |  |  |  |  |  | test 1 | 10
 |  |  |  |  |  |  |  |  |  | test 1 | 10
 |  |  |  |  |  |  |  |  |  | test 1 | 10
 |  |  |  |  |  |  |  |  |  | test 2 | 20
 |  |  |  |  |  |  |  |  |  | test 2 | 20
 |  |  |  |  |  |  |  |  |  | test 2 | 20
 |  |  |  |  |  |  |  |  |  | test 3 | 30
 |  |  |  |  |  |  |  |  |  | test 3 | 30
 |  |  |  |  |  |  |  |  |  | test 3 | 30
 |  |  |  |  |  |  |  |  |  | Right now I can use the subtotal tool and get each total but I need to make the actual sub total bold and then add a break before the next group.
 |  |  |  |  |  |  |  |  |  | If anyone knows and will show me how to do this it would be greatly appreciated!
 |  |  |  |  |  |  |  |  |  | Thanks
Spreadsheet: 805521d1668736703-formula-help-look-for-a-total-value-from-a-list-of-possible-sums-invoice-matching-with-solver
Sheet: Sheet1

 | Invoice number | Invoice amount
 | 1 | 10.5 | 0
 | 2 | 11.75 | 0
 | 3 | 15.26 | 1
 | 4 | 13.47 | 1
 | 5 | 52.69 | 0
 | 6 | 47.85 | 0
 | 7 | 13 | 0
 | 8 | 24.56 | 1
 | 9 | 47.26 | 1
 | 10 | 21.65 | 0
 | 11 | 24.39 | 0
 | Payment Received | 100.55
 | I want a formula that would show what possible invoices this payment ties to
Spreadsheet: 525475d1498743677-count-if-help-count-if-help-workbook2
Sheet: Sheet2

Machine# | Q | C | D | HasRateOf3 |  |  | FindRateOf
M1 | 1 | 4 | 3 |  |  |  | 3 | -->  change this to find Rating
M2 | 4 | 3 | 3
M3 | 3 | 2 | 2
M4 | 3 | 3 | 4
M5 | 4 | 3 | 3
M6 | 3 | 4 | 3
M7 | 4 | 3 | 3
M8 | 3 | 3 | 4
M9 | 3 | 4 | 3
M10 | 4 | 3 | 3
M11 | 4 | 3 | 3
M12 | 4 | 1 | 1 |  | changed to verify if there are NO 3s
m13 | 5 | 3 | 1
 | 1. Converted Format into streamlined version
 | 2. Made data a "TABLE"
 | 3. added formula to determine if any Machine has 3 in it (Column E)
Spreadsheet: tracy_geaccone__40401__GPM 101021  101073 Recalculation
Sheet: Dec 2000

KN Processing |  | GPM Agency Agreement |  |  | Prepared by [NAME]
Bushton Plant |  | TFDV Volume & Dollar Calculation
 |  | For
 |  | 2000-12-01 00:00:00
Contract #101021 |  |  | NNG Numbers |  |  | Oneok Numbers |  |  | Difference
 | Total Deliveries |  |  | 4386235 |  |  | 4386233
 |  | Deliveries to Inlet | 4196989 |  |  | 4196989
 |  | Deliveries to PVR
 |  | Non-Fuel Deliveries
 |  | Fuel Retention
 | Total Receipts |  | 4385614 |  |  | 4386238
 |  | [NAME] | 0.0445 |  |  | 0.0445
 |  | Less Fuel Retained
Transport Revenue [NAME]
Contract #101073
 | Total Deliveries |  |  | 1014006 |  |  | 965076
 |  | Deliveries to Inlet | 0
 |  | Deliveries to PVR | 969129 |  |  | 928428
 |  | Non-Fuel Deliveries
 |  | Fuel Retention
 | Total Receipts |  | 971574 |  |  | 971574
 |  | [NAME] | 0.0445 |  |  | 0.0445
 |  | Less Fuel Retained
Transport Revenue [NAME]
 |  | Total Both Contracts
 |  | Index |  | 9.043 |  |  | 9.2005
 |  | Total Revenue Due
Total Revenue Billed |  | 101021 |  | 45930.02
 |  | 101073
 |  |  |  |  |  |  | 115291.13
 |  | Amount Due NNG (GPM)
Charge given by NNG on prior reconciliation
 |  | Amount Due NNG (GPM)
Spreadsheet: 219779d1362943861-sumifs-data
Sheet: Folha1

E1 | E2 | R1 | Result
l | m | 1
l | n | 1
l | o | 1
l | p | 0
l | q | 1
l | r | 1
l | s | 1
l | m | 1
l | p | 1
l | t | 0
l | n | 1
l | o | 0
l | q | 1
l | r | 0
l | p | 0
l | o | 0
l | s | 1
l | r | 1
l | n | 0
l | m | 0
l | q | 1
l | t | 0
l | o | 1
l | n | 0
l | p | 0
l | m | 0
l | t | 1
l | r | 1
l | p | 0
l | r | 0
l | n | 0
l | o | 1
l | m | 1
l | t | 1
l | r | 0
l | u | 1
l | m | 1
l | s | 1
l | o | 1
l | p | 0
l | n | 0
l | u | 1
l | t | 1
l | r | 0
l | s | 0
l | n | 1
l | o | 0
l | p | 0
l | m | 1
l | t | 0
l | q | 1
l | p | 0
l | s | 1
l | r | 0
l | m | 1
l | o | 1
l | u | 1
l | n | 0
l | r | 0
l | s | 0
l | o | 0
l | n | 0
l | u | 1
l | t | 0
l | p | 1
l | q | 1
l | m | 1
l | o | 1
l | t | 1
l | n | 1
l | r | 0
Spreadsheet: 836920d1689722893-display-corresponding-text-field-based-on-max-value-fabric
Sheet: Sheet1

Year | Silk | Cotton | Wool
2019 | 1 | 2 | 1
2020 | 0 | 0 | 1
2021 | 1 | 2 | 1
2022 | 1 | 1 | 1
2023 | 1 | 1 | 1
Totals
The prefered fabric is
The second preferered fabric is
Spreadsheet: 0f70e536-1589-4c7b-bfb1-513ed8106b2b
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Atlantic-Elektra | 75678696060 | Needtobreathe | Natural Splice Large Unisex | 2014-04-15 | T-Shirt | Na | 18.99 | Y | Available
Atlantic-Elektra | 75678696053 | Needtobreathe | Natural Splice Medium Unisex | 2014-04-15 | T-Shirt | Na | 18.99 | Y | Available
Atlantic-Elektra | 75678696046 | Needtobreathe | Natural Splice Xlarge Unisex | 2014-04-15 | T-Shirt | Na | 18.99 | Y | Available
Atlantic-Elektra | 75678695971 | Needtobreathe | Black Scribble Stack Medium Unisex | 2014-04-15 | T-Shirt | Na | 18.99 | Y | Available
Merch | 679143015822 | Needtobreathe | Unisex Band [NAME] Xlarge | 2009-01-06 | T-Shirt | Na | 18.99 | N | Available
Merch | 679143015815 | Needtobreathe | Unisex Band [NAME] Large | 2009-01-06 | T-Shirt | Na | 18.99 | N | Available
Merch | 679143015808 | Needtobreathe | Unisex Band Logo Size Medium | 2009-01-06 | T-Shirt | Na | 18.99 | N | Available
Merch | 679143015792 | Needtobreathe | Unisex Band [NAME] | 2009-01-06 | T-Shirt | Na | 18.99 | N | Available
Atlantic-Elektra | 75678695964 | Needtobreathe | Black Scribble Stack Large Unisex | 2014-04-15 | T-Shirt | Na | 18.99 | Y | Available
Atlantic-Elektra | 75678695957 | Needtobreathe | Black Scribble Stack Xlarge Unisex | 2014-04-15 | T-Shirt | Na | 18.99 | Y | Available
Atlantic-Elektra | 75678720819 | Needtobreathe | Charcoal Worn Large Unisex | 2014-04-04 | T-Shirt | Rock | 9.5 | Y | To Be Retired
Atlantic-Elektra | 75678720802 | Needtobreathe | Charcoal Worn Xlarge Unisex | 2014-04-04 | T-Shirt | Rock | 9.5 | Y | To Be Retired
Atlantic-Elektra | 75678720826 | Needtobreathe | Charcoal Worn Medium Unisex | 2014-04-04 | T-Shirt | Rock | 9.5 | Y | To Be Retired
Spreadsheet: 0b106858-f810-4a98-959f-8ed217704ea5
Sheet: PCPD

[NAME]
ASSET & DEBT CHART
 |  |  | LAST 4 DIGITS OF ACCOUNT NUMBER | WHOSE NAME IS ON  ACCOUNT | ENTER "S" FOR ANY SEPARATE PROPERTY (explain why if separate) | GROSS | Amount you owe on this asset | Amount you owe on this asset | NET
ITEM |  |  | VALUE |  | VALUE | VALUE | NO. 1 | NO. 2 | VALUE
 | ASSETS:
 | BANK ACCOUNTS
1
7 | Total From Accounts on Page 7(a)
8 | Subtotal
 | INVESTMENTS / SECURITIES
 | Subtotal
 | RETIREMENT ACCOUNTS
 | Subtotal
 | LIFE INSURANCE POLICIES |  |  |  |  | WHOLE CASE VALUE
 | Subtotal
 | BUSINESS INTERESTS
 | Subtotal
 | RECEIVABLES / DEPOSITS
 | Subtotal
 | REAL PROPERTY
 | Subtotal
 | AUTOMOBILES
 | Subtotal
 | PERSONAL PROPERTY
 | Subtotal
 | LIABILITIES:
 | LONG TERM DEBT NOT LISTED ABOVE
 | Subtotal
 | OTHER LIABILITIES NOT LISTED ABOVE
 | Subtotal
 | TOTAL UNSECURED LIABILITIES
 | NET VALUE OF ASSETS (NET EQUITY)
USE THE SPACE BELOW FOR ANY NOTES/COMMENTS/EXPLANATION YOU WISH TO PROVIDE REGARDING YOUR ASSET AND DEBT CHART