Median in Pivot Table in Excel 2010?
Astonishing that this functionality is not present in such an ancient application
Is there a known workaround?
I'm on about the part where you can change the aggregation type for a value field:
It has sum, min, max, avg etc but not median
microsoft-excel microsoft-excel-2010 pivot-table aggregation
add a comment |
Astonishing that this functionality is not present in such an ancient application
Is there a known workaround?
I'm on about the part where you can change the aggregation type for a value field:
It has sum, min, max, avg etc but not median
microsoft-excel microsoft-excel-2010 pivot-table aggregation
1
IF memory serves, Excel's aggregate functions are closely related to SQL's aggregate functions-and you won't find a Median function there either. A SQL work-around may give some insight into creating an Excel Pivot table version.
– dav
Aug 24 '12 at 17:10
You may be able to leverage Powerpivot to do what you need, see this article: javierguillen.wordpress.com/2011/09/13/….
– dav
Aug 24 '12 at 17:14
add a comment |
Astonishing that this functionality is not present in such an ancient application
Is there a known workaround?
I'm on about the part where you can change the aggregation type for a value field:
It has sum, min, max, avg etc but not median
microsoft-excel microsoft-excel-2010 pivot-table aggregation
Astonishing that this functionality is not present in such an ancient application
Is there a known workaround?
I'm on about the part where you can change the aggregation type for a value field:
It has sum, min, max, avg etc but not median
microsoft-excel microsoft-excel-2010 pivot-table aggregation
microsoft-excel microsoft-excel-2010 pivot-table aggregation
asked Mar 7 '12 at 10:03
adolf garlicadolf garlic
85082541
85082541
1
IF memory serves, Excel's aggregate functions are closely related to SQL's aggregate functions-and you won't find a Median function there either. A SQL work-around may give some insight into creating an Excel Pivot table version.
– dav
Aug 24 '12 at 17:10
You may be able to leverage Powerpivot to do what you need, see this article: javierguillen.wordpress.com/2011/09/13/….
– dav
Aug 24 '12 at 17:14
add a comment |
1
IF memory serves, Excel's aggregate functions are closely related to SQL's aggregate functions-and you won't find a Median function there either. A SQL work-around may give some insight into creating an Excel Pivot table version.
– dav
Aug 24 '12 at 17:10
You may be able to leverage Powerpivot to do what you need, see this article: javierguillen.wordpress.com/2011/09/13/….
– dav
Aug 24 '12 at 17:14
1
1
IF memory serves, Excel's aggregate functions are closely related to SQL's aggregate functions-and you won't find a Median function there either. A SQL work-around may give some insight into creating an Excel Pivot table version.
– dav
Aug 24 '12 at 17:10
IF memory serves, Excel's aggregate functions are closely related to SQL's aggregate functions-and you won't find a Median function there either. A SQL work-around may give some insight into creating an Excel Pivot table version.
– dav
Aug 24 '12 at 17:10
You may be able to leverage Powerpivot to do what you need, see this article: javierguillen.wordpress.com/2011/09/13/….
– dav
Aug 24 '12 at 17:14
You may be able to leverage Powerpivot to do what you need, see this article: javierguillen.wordpress.com/2011/09/13/….
– dav
Aug 24 '12 at 17:14
add a comment |
7 Answers
7
active
oldest
votes
For simple examples you can use array formulas instead of a PivotTable.
If you have the source data in rows 10:1000, category designations of the source data in column A, the source data values in column C, and the category being considered in G3, the following array formula will find the median:
{=MEDIAN(IF($A$10:$A$1000=G3,$C$10:$C$1000))}
Commit the entry with Ctrl
+Shift
+Enter
, and copy down for the categories in G4, G5 etc
1
Looks like there is typo for value where instead of $C$10, $C$100 is there.
– jhamu
Jun 9 '16 at 23:23
Thanks @jhamu, it was indeed a typo.
– Levi
Sep 4 '18 at 18:36
add a comment |
Unfortunately, there is nothing built in to excel's pivot table function that will do this. You could try this add-on though. It claims to be able to do it, but I've never used it.
You could do the median work with the data and then include it in pivot table data, but at that point.. you know.. what's the point of the table..
add a comment |
You can actually use the iserror
function to exclude the total rows from medians. For example, if the Total row
labels are in row A
and the data you want the median of is in row I
:
=MEDIAN(IF(ISERROR(FIND("Total",$A$5:$A$65535)),I5:I35535))
add a comment |
The quickest and simplest way to get a median in your pivot tables is to import your Excel file into Google Sheets. There you can create a pivot table and use a median.
I had to vote this up because it's by far the easiest way to get the results. Doesn't help in excel, but the same data can be processed there in a pinch.
– Dan
Mar 9 '18 at 2:39
No good if you have sensitive data
– adolf garlic
Apr 4 '18 at 11:31
add a comment |
there's a way to do median (or any formula) if your pivot table is simple (does not have sub totals in the table). other than that, there's no other way to gracefully include median calcs in your pivot table.
too bad can't include attachments... i'll do a snapshot of my example:
i used the offset function described here:
http://www.myonlinetraininghub.com/excel-offset-function-explained
also, download the workbook and go to the pivot table tab - that's where i did my example
this is the end result - see image here:
NOTE: you cannot put the median/offset formula cell in the same column that you are grabbing median value from. ALSO, the offset allows you to grab median value from the value of the column less the grand total row.
unfortunately, there's no graceful way to do median (or any other) calc when you're working with a more complex pivot table (i.e., that has subtotals in the pivot table).
add a comment |
I have found a turnaround if you want to quickly obtain some specific median values in your pivot table:
Not perfect, but it could help in some situations..
- Double click in your pivot table on the aggregated value you want the median calculated
- Excel open a new sheets with all the rows behind this aggregated value
- Select the desired range of values and click on "Data Analysis" in the Excel's Data tab (you may need to activate it first)
- Choose "Descriptive Statistics"
- Adjust carefully your parameters (See Help of this function)
- Excel will calculate a whole bunch of Descriptive Statistics in a new sheet by default
add a comment |
As Dav commented above, you can use the free PowerPivot addon (may require a newer version of excel). Worked for me in excel 2016. See this article: https://www.masterdataanalysis.com/ms-excel/calculating-median-excel-pivottables/
External links can break or be unavailable, in which case your answer would not add anything useful useful. Please include the essential information within your answer and use the link for attribution and further reading. Thanks.
– fixer1234
Jan 17 at 1:00
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f397852%2fmedian-in-pivot-table-in-excel-2010%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
7 Answers
7
active
oldest
votes
7 Answers
7
active
oldest
votes
active
oldest
votes
active
oldest
votes
For simple examples you can use array formulas instead of a PivotTable.
If you have the source data in rows 10:1000, category designations of the source data in column A, the source data values in column C, and the category being considered in G3, the following array formula will find the median:
{=MEDIAN(IF($A$10:$A$1000=G3,$C$10:$C$1000))}
Commit the entry with Ctrl
+Shift
+Enter
, and copy down for the categories in G4, G5 etc
1
Looks like there is typo for value where instead of $C$10, $C$100 is there.
– jhamu
Jun 9 '16 at 23:23
Thanks @jhamu, it was indeed a typo.
– Levi
Sep 4 '18 at 18:36
add a comment |
For simple examples you can use array formulas instead of a PivotTable.
If you have the source data in rows 10:1000, category designations of the source data in column A, the source data values in column C, and the category being considered in G3, the following array formula will find the median:
{=MEDIAN(IF($A$10:$A$1000=G3,$C$10:$C$1000))}
Commit the entry with Ctrl
+Shift
+Enter
, and copy down for the categories in G4, G5 etc
1
Looks like there is typo for value where instead of $C$10, $C$100 is there.
– jhamu
Jun 9 '16 at 23:23
Thanks @jhamu, it was indeed a typo.
– Levi
Sep 4 '18 at 18:36
add a comment |
For simple examples you can use array formulas instead of a PivotTable.
If you have the source data in rows 10:1000, category designations of the source data in column A, the source data values in column C, and the category being considered in G3, the following array formula will find the median:
{=MEDIAN(IF($A$10:$A$1000=G3,$C$10:$C$1000))}
Commit the entry with Ctrl
+Shift
+Enter
, and copy down for the categories in G4, G5 etc
For simple examples you can use array formulas instead of a PivotTable.
If you have the source data in rows 10:1000, category designations of the source data in column A, the source data values in column C, and the category being considered in G3, the following array formula will find the median:
{=MEDIAN(IF($A$10:$A$1000=G3,$C$10:$C$1000))}
Commit the entry with Ctrl
+Shift
+Enter
, and copy down for the categories in G4, G5 etc
edited Sep 4 '18 at 18:35
answered Mar 15 '13 at 23:43
LeviLevi
4461514
4461514
1
Looks like there is typo for value where instead of $C$10, $C$100 is there.
– jhamu
Jun 9 '16 at 23:23
Thanks @jhamu, it was indeed a typo.
– Levi
Sep 4 '18 at 18:36
add a comment |
1
Looks like there is typo for value where instead of $C$10, $C$100 is there.
– jhamu
Jun 9 '16 at 23:23
Thanks @jhamu, it was indeed a typo.
– Levi
Sep 4 '18 at 18:36
1
1
Looks like there is typo for value where instead of $C$10, $C$100 is there.
– jhamu
Jun 9 '16 at 23:23
Looks like there is typo for value where instead of $C$10, $C$100 is there.
– jhamu
Jun 9 '16 at 23:23
Thanks @jhamu, it was indeed a typo.
– Levi
Sep 4 '18 at 18:36
Thanks @jhamu, it was indeed a typo.
– Levi
Sep 4 '18 at 18:36
add a comment |
Unfortunately, there is nothing built in to excel's pivot table function that will do this. You could try this add-on though. It claims to be able to do it, but I've never used it.
You could do the median work with the data and then include it in pivot table data, but at that point.. you know.. what's the point of the table..
add a comment |
Unfortunately, there is nothing built in to excel's pivot table function that will do this. You could try this add-on though. It claims to be able to do it, but I've never used it.
You could do the median work with the data and then include it in pivot table data, but at that point.. you know.. what's the point of the table..
add a comment |
Unfortunately, there is nothing built in to excel's pivot table function that will do this. You could try this add-on though. It claims to be able to do it, but I've never used it.
You could do the median work with the data and then include it in pivot table data, but at that point.. you know.. what's the point of the table..
Unfortunately, there is nothing built in to excel's pivot table function that will do this. You could try this add-on though. It claims to be able to do it, but I've never used it.
You could do the median work with the data and then include it in pivot table data, but at that point.. you know.. what's the point of the table..
answered Mar 7 '12 at 11:22
RaystafarianRaystafarian
19.4k105089
19.4k105089
add a comment |
add a comment |
You can actually use the iserror
function to exclude the total rows from medians. For example, if the Total row
labels are in row A
and the data you want the median of is in row I
:
=MEDIAN(IF(ISERROR(FIND("Total",$A$5:$A$65535)),I5:I35535))
add a comment |
You can actually use the iserror
function to exclude the total rows from medians. For example, if the Total row
labels are in row A
and the data you want the median of is in row I
:
=MEDIAN(IF(ISERROR(FIND("Total",$A$5:$A$65535)),I5:I35535))
add a comment |
You can actually use the iserror
function to exclude the total rows from medians. For example, if the Total row
labels are in row A
and the data you want the median of is in row I
:
=MEDIAN(IF(ISERROR(FIND("Total",$A$5:$A$65535)),I5:I35535))
You can actually use the iserror
function to exclude the total rows from medians. For example, if the Total row
labels are in row A
and the data you want the median of is in row I
:
=MEDIAN(IF(ISERROR(FIND("Total",$A$5:$A$65535)),I5:I35535))
edited Mar 15 '13 at 14:54
slm
6,33563846
6,33563846
answered Mar 15 '13 at 14:23
Thomas ClebergThomas Cleberg
111
111
add a comment |
add a comment |
The quickest and simplest way to get a median in your pivot tables is to import your Excel file into Google Sheets. There you can create a pivot table and use a median.
I had to vote this up because it's by far the easiest way to get the results. Doesn't help in excel, but the same data can be processed there in a pinch.
– Dan
Mar 9 '18 at 2:39
No good if you have sensitive data
– adolf garlic
Apr 4 '18 at 11:31
add a comment |
The quickest and simplest way to get a median in your pivot tables is to import your Excel file into Google Sheets. There you can create a pivot table and use a median.
I had to vote this up because it's by far the easiest way to get the results. Doesn't help in excel, but the same data can be processed there in a pinch.
– Dan
Mar 9 '18 at 2:39
No good if you have sensitive data
– adolf garlic
Apr 4 '18 at 11:31
add a comment |
The quickest and simplest way to get a median in your pivot tables is to import your Excel file into Google Sheets. There you can create a pivot table and use a median.
The quickest and simplest way to get a median in your pivot tables is to import your Excel file into Google Sheets. There you can create a pivot table and use a median.
answered Feb 26 '18 at 18:16
Jeff GebhartJeff Gebhart
211
211
I had to vote this up because it's by far the easiest way to get the results. Doesn't help in excel, but the same data can be processed there in a pinch.
– Dan
Mar 9 '18 at 2:39
No good if you have sensitive data
– adolf garlic
Apr 4 '18 at 11:31
add a comment |
I had to vote this up because it's by far the easiest way to get the results. Doesn't help in excel, but the same data can be processed there in a pinch.
– Dan
Mar 9 '18 at 2:39
No good if you have sensitive data
– adolf garlic
Apr 4 '18 at 11:31
I had to vote this up because it's by far the easiest way to get the results. Doesn't help in excel, but the same data can be processed there in a pinch.
– Dan
Mar 9 '18 at 2:39
I had to vote this up because it's by far the easiest way to get the results. Doesn't help in excel, but the same data can be processed there in a pinch.
– Dan
Mar 9 '18 at 2:39
No good if you have sensitive data
– adolf garlic
Apr 4 '18 at 11:31
No good if you have sensitive data
– adolf garlic
Apr 4 '18 at 11:31
add a comment |
there's a way to do median (or any formula) if your pivot table is simple (does not have sub totals in the table). other than that, there's no other way to gracefully include median calcs in your pivot table.
too bad can't include attachments... i'll do a snapshot of my example:
i used the offset function described here:
http://www.myonlinetraininghub.com/excel-offset-function-explained
also, download the workbook and go to the pivot table tab - that's where i did my example
this is the end result - see image here:
NOTE: you cannot put the median/offset formula cell in the same column that you are grabbing median value from. ALSO, the offset allows you to grab median value from the value of the column less the grand total row.
unfortunately, there's no graceful way to do median (or any other) calc when you're working with a more complex pivot table (i.e., that has subtotals in the pivot table).
add a comment |
there's a way to do median (or any formula) if your pivot table is simple (does not have sub totals in the table). other than that, there's no other way to gracefully include median calcs in your pivot table.
too bad can't include attachments... i'll do a snapshot of my example:
i used the offset function described here:
http://www.myonlinetraininghub.com/excel-offset-function-explained
also, download the workbook and go to the pivot table tab - that's where i did my example
this is the end result - see image here:
NOTE: you cannot put the median/offset formula cell in the same column that you are grabbing median value from. ALSO, the offset allows you to grab median value from the value of the column less the grand total row.
unfortunately, there's no graceful way to do median (or any other) calc when you're working with a more complex pivot table (i.e., that has subtotals in the pivot table).
add a comment |
there's a way to do median (or any formula) if your pivot table is simple (does not have sub totals in the table). other than that, there's no other way to gracefully include median calcs in your pivot table.
too bad can't include attachments... i'll do a snapshot of my example:
i used the offset function described here:
http://www.myonlinetraininghub.com/excel-offset-function-explained
also, download the workbook and go to the pivot table tab - that's where i did my example
this is the end result - see image here:
NOTE: you cannot put the median/offset formula cell in the same column that you are grabbing median value from. ALSO, the offset allows you to grab median value from the value of the column less the grand total row.
unfortunately, there's no graceful way to do median (or any other) calc when you're working with a more complex pivot table (i.e., that has subtotals in the pivot table).
there's a way to do median (or any formula) if your pivot table is simple (does not have sub totals in the table). other than that, there's no other way to gracefully include median calcs in your pivot table.
too bad can't include attachments... i'll do a snapshot of my example:
i used the offset function described here:
http://www.myonlinetraininghub.com/excel-offset-function-explained
also, download the workbook and go to the pivot table tab - that's where i did my example
this is the end result - see image here:
NOTE: you cannot put the median/offset formula cell in the same column that you are grabbing median value from. ALSO, the offset allows you to grab median value from the value of the column less the grand total row.
unfortunately, there's no graceful way to do median (or any other) calc when you're working with a more complex pivot table (i.e., that has subtotals in the pivot table).
edited Feb 22 '13 at 7:33
Peter Albert
2,63211323
2,63211323
answered Feb 22 '13 at 4:14
ProspertuteProspertute
11
11
add a comment |
add a comment |
I have found a turnaround if you want to quickly obtain some specific median values in your pivot table:
Not perfect, but it could help in some situations..
- Double click in your pivot table on the aggregated value you want the median calculated
- Excel open a new sheets with all the rows behind this aggregated value
- Select the desired range of values and click on "Data Analysis" in the Excel's Data tab (you may need to activate it first)
- Choose "Descriptive Statistics"
- Adjust carefully your parameters (See Help of this function)
- Excel will calculate a whole bunch of Descriptive Statistics in a new sheet by default
add a comment |
I have found a turnaround if you want to quickly obtain some specific median values in your pivot table:
Not perfect, but it could help in some situations..
- Double click in your pivot table on the aggregated value you want the median calculated
- Excel open a new sheets with all the rows behind this aggregated value
- Select the desired range of values and click on "Data Analysis" in the Excel's Data tab (you may need to activate it first)
- Choose "Descriptive Statistics"
- Adjust carefully your parameters (See Help of this function)
- Excel will calculate a whole bunch of Descriptive Statistics in a new sheet by default
add a comment |
I have found a turnaround if you want to quickly obtain some specific median values in your pivot table:
Not perfect, but it could help in some situations..
- Double click in your pivot table on the aggregated value you want the median calculated
- Excel open a new sheets with all the rows behind this aggregated value
- Select the desired range of values and click on "Data Analysis" in the Excel's Data tab (you may need to activate it first)
- Choose "Descriptive Statistics"
- Adjust carefully your parameters (See Help of this function)
- Excel will calculate a whole bunch of Descriptive Statistics in a new sheet by default
I have found a turnaround if you want to quickly obtain some specific median values in your pivot table:
Not perfect, but it could help in some situations..
- Double click in your pivot table on the aggregated value you want the median calculated
- Excel open a new sheets with all the rows behind this aggregated value
- Select the desired range of values and click on "Data Analysis" in the Excel's Data tab (you may need to activate it first)
- Choose "Descriptive Statistics"
- Adjust carefully your parameters (See Help of this function)
- Excel will calculate a whole bunch of Descriptive Statistics in a new sheet by default
edited Mar 20 '17 at 10:17
Community♦
1
1
answered Mar 17 '16 at 12:43
FabienFabien
31228
31228
add a comment |
add a comment |
As Dav commented above, you can use the free PowerPivot addon (may require a newer version of excel). Worked for me in excel 2016. See this article: https://www.masterdataanalysis.com/ms-excel/calculating-median-excel-pivottables/
External links can break or be unavailable, in which case your answer would not add anything useful useful. Please include the essential information within your answer and use the link for attribution and further reading. Thanks.
– fixer1234
Jan 17 at 1:00
add a comment |
As Dav commented above, you can use the free PowerPivot addon (may require a newer version of excel). Worked for me in excel 2016. See this article: https://www.masterdataanalysis.com/ms-excel/calculating-median-excel-pivottables/
External links can break or be unavailable, in which case your answer would not add anything useful useful. Please include the essential information within your answer and use the link for attribution and further reading. Thanks.
– fixer1234
Jan 17 at 1:00
add a comment |
As Dav commented above, you can use the free PowerPivot addon (may require a newer version of excel). Worked for me in excel 2016. See this article: https://www.masterdataanalysis.com/ms-excel/calculating-median-excel-pivottables/
As Dav commented above, you can use the free PowerPivot addon (may require a newer version of excel). Worked for me in excel 2016. See this article: https://www.masterdataanalysis.com/ms-excel/calculating-median-excel-pivottables/
answered Jan 17 at 0:34
DecioDecio
413
413
External links can break or be unavailable, in which case your answer would not add anything useful useful. Please include the essential information within your answer and use the link for attribution and further reading. Thanks.
– fixer1234
Jan 17 at 1:00
add a comment |
External links can break or be unavailable, in which case your answer would not add anything useful useful. Please include the essential information within your answer and use the link for attribution and further reading. Thanks.
– fixer1234
Jan 17 at 1:00
External links can break or be unavailable, in which case your answer would not add anything useful useful. Please include the essential information within your answer and use the link for attribution and further reading. Thanks.
– fixer1234
Jan 17 at 1:00
External links can break or be unavailable, in which case your answer would not add anything useful useful. Please include the essential information within your answer and use the link for attribution and further reading. Thanks.
– fixer1234
Jan 17 at 1:00
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f397852%2fmedian-in-pivot-table-in-excel-2010%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
IF memory serves, Excel's aggregate functions are closely related to SQL's aggregate functions-and you won't find a Median function there either. A SQL work-around may give some insight into creating an Excel Pivot table version.
– dav
Aug 24 '12 at 17:10
You may be able to leverage Powerpivot to do what you need, see this article: javierguillen.wordpress.com/2011/09/13/….
– dav
Aug 24 '12 at 17:14