tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: jeff_dasovich__14057__OAT Valuation 0416
Sheet: OAT DCF

 |  |  |  |  |  | QUAKER OATS
 |  |  |  |  | DISCOUNTED CASH FLOW ANALYSIS
 | Actual | Actual | Assumptions | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast
FISCAL YEAR ENDING | 1999
Sales
Operating expenses:
Cost of sales
Selling and administrative
Depreciation and amortization |  |  | calc as % of beginning PPE
Goodwill amortization |  |  | flat
Operating income
Interest expense
Income before tax
Provision for income taxes
Net income
Add: Int Exp (1-t)
EBI (NOPLAT)
Add: Depreciation
(Inc) Dec in other assets |  |  | from B/S
Inc. (Dec.) in other liabilities |  |  | from B/S
Inc. in deferred taxes | 0 | 0 | from B/S | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
WCFO (excl. int.)
(Inc.) Dec. in A/R |  |  | from B/S
(Inc.) Dec. in Other C. Assets |  |  | from B/S
Inc. (Dec.) in A/P |  |  | from B/S
Inc. (Dec.) in Other Accruals |  |  | from B/S
CFO (excl. int.)
Less: Capital Expenditures, net
FCF (free cash flow)
Terminal value (mult of EBITDA)
Total free cash flow
PV of total free cash flows
Less: PV (debt)
Plus: idle assets (liabs) |  |  |  | 0
PV of shareholders' equity (in millions)
Shares outstanding
Price per share
Appendix 6
Discounted Cash Flow Analysis
FISCAL YEAR ENDING |  |  | Notes
Cash and cash equivalents
Receivables
Inventories
Deferred taxes | 0 | 0
Other current assets
Total current assets
Net PPE
Goodwill |  |  | reduce by amort.
Other assets
TOTAL ASSETS
Accounts payable
Accrued liabilities
Total [NAME] (excl L/T Debt)
Deferred income taxes | 0 | 0
Other noncurrent liabilities
Capital lease obligations |  |  | reduce bal by amort of 3 per pd.
Debt (including S/T debt) |  |  | % of total assets
Total liabilities
Shareholders' equity |  |  | PLUG
TOT LIAB & NET WORTH
Tax Rate |  |  | Unreconciled Difference
Free Cash Flow
Deduct: Int. expense (net of tax) |  |  | Debt*cost of debt*(1-t)
Add: Increase in L/T debt |  |  | from B/S
Subtotal (net cash to Shrholdrs)
(Dividend) or New Equity |  |  | from B/S
¯Cash per SCF
¯Cash per B/S |  |  | from B/S
 |  |  | Unreconciled Difference
Net Income |  |  | (EBI- Int. after tax)
EBI
Return on Beg. Equity |  |  | (NI / Beg Sh. [NAME])
Profit Margin |  |  | (EBI / Sales)
Asset Turnover |  |  | (Sales / Avg. TA)
Leverage |  |  | ([NAME]. TA / Avg. SE) x (NI / EBI)
Return on Average Equity
Return on Assets |  |  | (EBI / Avg TA)
Spreadsheet: 124582d1318484000-excel-2007-common-finder-ex3
Sheet: Sheet1

Common A | Common B |  | Ideal |  | Answer |  | OPTIMUM
12 | 24 |  | 9 |  | 3 |  | 60
79 | 85 |  | 63
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 63 | 22
 |  |  |  |  |  |  | 22 | 63 |  |  |  |  | 3 | 9 | 15
 |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  | 37
Spreadsheet: 778847d1651390283-forumla-help-request-for-index-of-multipal-sheet-summary-with-indirect-aligw
Sheet: Sheet2

 |  |  |  |  |  | Claim
 |  |  | "Hospital Bill"
 | Patient Name :- Mr ASD
 |  |  |  |  |  | Sex:- Male         Age :- 38
 |  |  |  |  |  | [NAME]
 | Admit Date:- 02.04.2022; 12.25pm |  |  |  |  | [NAME] 03.04.2022
 | [NAME] 03.04.2022; 02.00pm |  |  |  |  | IPD Number :- IPD/03
 | Doctor Incharge : Dr [NAME]
 | Particulars |  | Qty | Rate |  | Amount
 | Bed Charges - GW |  | 1 | 400
 | Dr Visit Charges |  | 2 | 200
 | Nursing Visit Charges |  | 2 | 100
 |  |  |  |  | Total [NAME]
Spreadsheet: 829216d1684046416-generate-concat-sentences-from-three-columns-each-column-has-multiple-words-in-one-cel-sentence-generator-3-bory
Sheet: arrays

 | people | verbs | place
People 1 + verbs 1 + places 1 | My dangerous daughter,My sunny son,My mum,My dad,My dangerous daughter,My brother [NAME],My sister Sissy,My crazy cousin [NAME],The little boy,The little girl,My friend [NAME],My ugly uncle | is writing a letter,is reading a book,is singing a song,is eating a hamburger,is drinking a coca-cola,is playing football,is speaking Spanish,is listening to music,is driving a car,is looking at the blackboard,is flying in the sky,is dancing in the disco,is cutting the paper,is crying like a baby,is swimming in the river,is going to the toilet | in the river,in the mountain,in the sky,in the tree,in the garden,in the house,in the class
Spreadsheet: 3e36f90e-1d15-4de7-b23a-f964921a7711
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
42266584 | 2014-07-12 11:13:24 | AXIS | 0 | 1 | 7 | 249959 | NAPOLEON71 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42266731 | 2014-07-12 11:27:24 | ALLIES | 0 | 4 | 7 | 249959 | NAPOLEON71 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42267699 | 2014-07-12 13:11:10 | AXIS | 1 | 7 | 3 | 446704 | oggy990 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42267921 | 2014-07-12 13:27:18 | ALLIES | 1 | 7 | 1 | 446704 | oggy990 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42272568 | 2014-07-12 19:55:49 | AXIS | 0 | 6 | 7 | 973858 | Sadoprest | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42272929 | 2014-07-12 20:17:32 | ALLIES | 1 | 7 | 2 | 973858 | Sadoprest | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42282011 | 2014-07-13 12:36:02 | AXIS | 0 | 4 | 7 | 1600049 | player1600049 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42282162 | 2014-07-13 12:54:56 | ALLIES | 1 | 7 | 4 | 1600049 | player1600049 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42367840 | 2014-07-19 18:27:50 | AXIS | 0 | 6 | 7 | 706396 | Intello | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42368049 | 2014-07-19 18:50:09 | ALLIES | 1 | 7 | 3 | 706396 | Intello | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42369205 | 2014-07-19 20:25:34 | AXIS | 0 | 4 | 7 | 372962 | socafred | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42369401 | 2014-07-19 20:44:26 | ALLIES | 1 | 7 | 4 | 372962 | socafred | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42378625 | 2014-07-20 14:11:59 | AXIS | 1 | 7 | 1 | 458667 | black sheep | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42378849 | 2014-07-20 14:38:25 | ALLIES | 1 | 7 | 4 | 458667 | black sheep | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42385548 | 2014-07-20 22:32:41 | AXIS | 1 | 7 | 4 | 255230 | [NAME] | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
Spreadsheet: 726431d1617227628-formula-for-negative-balance-on-receivables-on-outstanding-days-negative-balance
Sheet: Age Analysis

I'm kindly asking for a formula to show "Prepaid" if the the debtors outstanding balance is negative instead of showing days as  in cell F9
Invoice Date | Invoice | Invoice Amount | Amount Received | Outstanding Balance | Days Outstanding | Not yet Due | 1- 30 days | 31 - 60 Days | 61-90 Days | >90 Days
Opening Balance | C002 | 1750 | 1000
2021-02-01 00:00:00 | C006 | 1200 | 1100
2021-02-20 00:00:00 | C007 | 4000 | 5000
Opening Balance | C003 | 1500 | 400
2021-02-01 00:00:00 | C005 | 2000 | 0
2021-02-15 00:00:00 | C008 | 500 | 0
Spreadsheet: 62274d1263247046-pull-every-instance-index-match-criteria-into-consecutive-rows-directors-intervention-report-template
Sheet: DIR

Wave-Maker: |  |  | AA, Test |  |  |  |  |  |  |  |  |  |  |  |  | Date:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wave: |  |  |  |  | AAASFM, Test Student | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AA, Test | 2
DIRECTOR'S INTERVENTION REPORT
[NAME] |  |  |  |  |  |  | OUTREACH/ACADEMICS
 |  |  |  | Probation (Y/N)?
 | AP1 | Regular Session
 |  | Make-Up Session
 |  | Support Session
 |  | Supplemental Session
 | AP2 | Regular Session
 |  | Make-Up Session
 |  | Support Session
 |  | Supplemental Session
 | AP3 | Regular Session
 |  |  |  |  |  |  | SUPPORT
 |  | Make-Up Session
 |  | Support Session
 |  | Supplemental Session
 | AP4 | Regular Session
 |  | Make-Up Session
 |  | Support Session
 |  | Supplemental Session
FAMILY INVOLVEMENT |  |  |  |  |  |  |  |  |  |  |  |  | INTERVENTION
DETENTION/MAKE-UP SESSION SUMMARY
 |  |  |  | Count per attendance period
 |  |  |  | AP 1 | AP2 |  |  | AP3 |  | AP4
 | Detention (Assignment Log)
 | Detention (Behavior)
 | Detention (Organization)
 | Make-Up (Absence)
 | Make-Up (Supplemental)
 | Make-Up (Consequence)
Spreadsheet: 128173d1320838266-excel-2007-looking-up-a-min-value-based-on-input-looking-best-trucker
Sheet: Sheet1

 | Sales | A | B | C | D | E | F | G | H | I
KM |  | Rate in €, ex fuel | Rate in €, ex fuel | Rate in €, ex fuel | Rate in €, ex fuel | Rate in €, ex fuel | Rate in €, ex fuel | Rate in €, incl fuel | Rate in €, ex fuel | Rate in €, ex fuel
0-19 |  | 1100 | 1050 | 1075 | 900 | 980 | 940 | 932 | 1098 | 1100
20-39 |  | 2300 | 2100 | 1928 | 2938 | 2029 | 2080 | 2100 | 2300 | 2200
40-59 |  | 3000 | 3100 | 3090 | 3000 | 3400 | 3900 | 3840 | 3100 | 2100
60-79
80-99
100-119
120-139
140-159
160-179
180-199
200-219
220-239
240-259
260-279
280-299
300-319
320-339
340-359
360-379
380-399
400-419
420-439
440-459
460-479
480-499
500-519
520-539
540-559
560-579
580-599
600-619
620-639
640-659
660-679
680-699
700-719
720-739
740-759
760-779
780-799
800-819
820-839
840-859
860-879
880-899
900-919
920-939
940-959
960-979
980-999
>1000
Spreadsheet: 129885d1321961019-return-row-of-max-value-of-a-category-return-row-of-max-value-of-a-category
Sheet: Sheet2

 | Customer | Item | amount
 | AAA | A | 20
 | AAA | B | 31
 | BBB | C | 10
 | CCC | D | 22
 | DDD | E | 66
 | DDD | F | 44
 | DDD | G | 97
 | BBB | H | 16
Spreadsheet: 57522d1257751242-sorting-values-book1
Sheet: Sheet2

A | B | C
16
 |  | 81
3
2
 | 37
 | 32
 |  | 90
 | 53
 | 51
 |  | 80
 | 34
 |  | 88
 | 57
 |  | 67
16
 | 59
 |  | 84
 |  | 75
 | 28
 | 44
 |  | 100
 |  | 78
4
 |  | 65
17
 |  | 85
 | 46
 |  | 92
7
 | 24
 | 58
 | 33
7
 | 21
20
 |  | 94
 | 53
 |  | 62
14
 | 54
 |  | 72
8
5
20
 | 35
 | 54
16
 | 28
 | 41
 | 44
 | 56
9
 | 25
 | 41
 |  | 93
 | 42
 |  | 87
 |  | 79
1
8
 | 37
 |  | 84
 |  | 91
6
3
19
 |  | 68
 |  | 71
 |  | 99
 |  | 78
15
12
19
0
 |  | 62
 |  | 70
13
 | 27
 |  | 61
14
 | 59
 | 41
 |  | 70
 | 57
 | 36
 |  | 80
12
 |  | 69
12
 | 52
 | 47
18
 | 59
 | 45
 |  | 86
 |  | 92
 |  | 96
 | 25
 | 42
 |  | 71
 |  | 94
 |  | 100
 |  | 68
 | 45
 | 57
 | 55
 | 57
 | 46
 | 34
 |  | 67
 |  | 75
 |  | 83
19
 |  | 64
17
 |  | 93
 | 24
 |  | 63
 |  | 85
 | 37
16
 |  | 79
13
 | 25
 | 39
 | 33
 |  | 99
17
15
 |  | 88
9
 | 46
 |  | 68
 |  | 93
 | 26
12
 |  | 66
 |  | 71
9
20
 |  | 64
6
15
17
17
 | 58
 |  | 96
 | 47
17
 |  | 67
 | 53
0
 |  | 65
 | 48
 |  | 90
 |  | 70
 | 32
 |  | 88
 |  | 84
 |  | 92
 | 56
 |  | 82
 |  | 85
 | 43
 | 38
 |  | 72
 | 25
 | 58
 |  | 95
12
 | 56
 | 48
8
 | 22
10
19
1
 | 49
 |  | 85
3
 | 23
 | 49
18
 | 35
 |  | 74
13
15
 |  | 74
 |  | 63
 | 33
4
 |  | 74
 | 25
 | 39
1
13
 | 48
 |  | 85
 |  | 96
 | 54
 | 40
3
 |  | 75
 |  | 71
 | 32
1
 |  | 100
 |  | 100
12
 | 57
 | 47
4
 |  | 68
 | 55
 |  | 90
 | 43
 |  | 99
 |  | 71
 |  | 99
 | 39
 |  | 89
 | 55
 |  | 70
 | 58
 |  | 67
 |  | 70
 | 35
 | 26
 |  | 100
 |  | 78
 | 52
12
 | 23
 | 35
 |  | 78
 |  | 75
 | 51
 | 29
 | 43
11
 |  | 90
 |  | 87
 | 57
 | 21
 |  | 66
 |  | 96
 |  | 89
 |  | 94
11
 | 27
9
 |  | 86
 | 29
13
1
4
 |  | 89
 |  | 73
 | 38
 |  | 63
3
 | 27
 |  | 67
 | 48
 | 48
 |  | 74
 | 29
 |  | 94
 |  | 60
 |  | 83
 | 59
4
 | 42
 | 31
 |  | 92
 | 24
 |  | 98
 |  | 98
5
 | 59
20
 |  | 93
 | 54
16
 |  | 91
 |  | 75
6
 |  | 98
 |  | 92
 |  | 75
7
 |  | 82
5
 |  | 93
 |  | 90
 | 27
 | 32
 |  | 63
 | 52
11
 |  | 89
 |  | 90
 |  | 91
 | 27
 |  | 61
17
 | 21
 |  | 77
Spreadsheet: 119561d1314568023-running-total-kcthatsme-ammar-2011-08-28
Sheet: Sheet1

Item | Add | Total
Widget | 10
Broom | 15
Widget | 5
Broom | 25
Spreadsheet: 226116d1365249745-dependant-lists-20130406-demo-v2
Sheet: Input

City | London | Birmingham | [NAME] | Cambridge | 10 | 11 | 20 | 21 | 22 | 30 | 31 | 40 | 41
London | 10 | 20 | 30 | 40 | 1000 | 6542 | 1254 | 4785 | 1548 | 3574 | 2363 | 1112 | 1110
Birmingham | 11 | 21 | 31 | 41 | 2521 | 5478 | 1124 | 5365 | 1632 | 3594 | 2022 | 1255
[NAME] |  | 22 |  |  | 1259 |  | 1254 | 1247
Cambridge
City | Dep. numbers | Employer ID
London | 10 | 1000
Birmingham | 11 | 2521
[NAME] | 20 | 1259
Cambridge | 21 | 6542
 | 22 | 5478
 | 30 | 1254
 | 31 | 1124
 | 40 | 1254
 | 41 | 4785
 |  | 5365
 |  | 1247
 |  | 1548
 |  | 1632
 |  | 3574
 |  | 3594
 |  | 2363
 |  | 2022
 |  | 1112
 |  | 1255
 |  | 1110
Spreadsheet: 739964d1626103886-needs-formula-to-count-a-filtered-list-katies-help
Sheet: Q8 - 1

AGE GROUP | Q8 - 1 MICROSOFT WORD
 |  |  |  |  |  | Age Group | Amount
 |  |  |  |  |  | 1,1 |  | 2,1
1 | 7 |  |  |  |  | 1,2 |  | 2,2
1 | 7 |  |  |  |  | 1,3 |  | 2,3
2 | 4 |  |  |  |  | 1,4 |  | 2,4
2 | 4 |  |  |  |  | 1,5 |  | 2,5
2 | 4 |  |  |  |  | 1,6 |  | 2,6
2 | 4 |  |  |  |  | 1,7 |  | 2,7
2 | 4
2 | 4
2 | 5
2 | 5
2 | 5
2 | 5
2 | 6
2 | 6
2 | 6
2 | 6
2 | 6
2 | 6
2 | 6
2 | 6
2 | 6
2 | 6
2 | 6
2 | 6
2 | 6
2 | 6
2 | 6
2 | 6
2 | 6
2 | 6
2 | 6
2 | 6
2 | 6
2 | 6
2 | 6
2 | 7
2 | 7
2 | 7
2 | 7
2 | 7
2 | 7
2 | 7
2 | 7
2 | 7
3 | 3
3 | 4
3 | 4
3 | 4
3 | 4
3 | 4
3 | 5
3 | 5
3 | 5
3 | 6
3 | 6
3 | 6
3 | 6
3 | 6
3 | 7
3 | 7
3 | 7
3 | 7
3 | 7
4 | 3
4 | 3
4 | 3
4 | 4
4 | 4
4 | 4
4 | 4
4 | 5
4 | 5
4 | 5
4 | 5
4 | 5
4 | 5
4 | 5
4 | 6
4 | 6
4 | 7
5 | 4
5 | 4
5 | 4
5 | 5
5 | 6
 | Total group |  |  |  | filter group 2 - 25 to 34 |  |  | filter group 3 - 35 to 44 |  |  | filter group 4 - 45 to 54 |  |  | filter group 5 - 55 to 64 |  |  | excluding Group 2 and 1 |  |  | Only Group 2 and 1
 | 1= |  |  |  | 1= | 0 |  | 1= | 0 |  | 1= | 0 |  | 1= | 0 |  | 1= | 0 |  | 1= | 0
 | 2= |  |  |  | 2= | 0 |  | 2= | 0 |  | 2= | 0 |  | 2= | 0 |  | 2= | 0 |  | 2= | 0
 | 3= |  |  |  | 3= | 0 |  | 3= | 1 |  | 3= | 2 |  | 3= | 0 |  | 3= | 3 |  | 3= | 0
 | 4= |  |  |  | 4= | 5 |  | 4= | 5 |  | 4= | 4 |  | 4= | 3 |  | 4= | 12 |  | 4= | 5
 | 5= |  |  |  | 5= | 4 |  | 5= | 3 |  | 5= | 7 |  | 5= | 1 |  | 5= | 11 |  | 5= | 4
 | 6= |  |  |  | 6= | 23 |  | 6= | 6 |  | 6= | 7 |  | 6= | 1 |  | 6= | 8 |  | 6= | 23
 | 7= |  |  |  | 7= | 8 |  | 7= | 5 |  | 7= | 1 |  | 7= | 0 |  | 7= | 6 |  | 7= | 10
Spreadsheet: 63381d1264294114-help-with-bar-graph-715235-help-with-bar-graph
Sheet: Sheet1

1 Real GDP (FC) | target | actual
FY00 | 5 | 4.8
FY01 | 5 | 2.6
FY02 | 4 | 3.6
FY03 | 4.5 | 5.1
FY04 | 5.3 | 6.4
FY05 | 6.6 | 8.4
FY06 | 7 | 6.6
FY07 | 7 | 7
FY08 | 7 | 5.8
FY09 | 5.5 | 2
Spreadsheet: 186649d1350135883-search-ef216c_beers
Sheet: Search

 | Brewery |  | Beer
Select Brewery:
Initial Letter | A
Full Name | Archers
Overall Totals:
Displayed Totals:
Spreadsheet: 46579d1245423937-sumif-multiple-worksheets-add-all-cells-adjacent-to-cell-w-value-matching-query-kor-cart-quotas
Sheet: UOFA - 2B5 T.B. LAB

K-BRO LINEN SYSTEMS - EDMONTON  PLANT
2B5 T.B. LAB
FACILITY: | UNIVERSITY OF ALBERTA HOSPITAL
Date:
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | STATS
DELIVERY DAYS: |  | X
** If more/less linen required please fax in this order by 9:30 a.m. (FAX # (780) 451-5125)
[NAME] |  |  |  | PACK # |  | QUOTA | SHELF | REC | +/-/HOLD
5-GOWN STD XL |  |  |  | BP0021 |  | 20
UPDATED:
June 17th 2009
Spreadsheet: 193a4aae-c412-46b2-942b-70c0e5cd7b31
Sheet: Sheet1

Release: Chicago Fed National Activity Index | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=219
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-03-15 7:41 AM [NAME]
 | Real-Time | Period
Name: | Start | End
Chicago Fed National Activity Index | 2011-05-23 00:00:00 | Current
Link:
http://www.chicagofed.org/webpages/publications/cfnai/index.cfm | 2011-05-23 00:00:00 | Current
Source:
Federal Reserve Bank of Chicago | 2011-05-23 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-05-23 00:00:00
2011-06-23 00:00:00
2011-07-25 00:00:00
2011-08-22 00:00:00
2011-09-26 00:00:00
2011-10-24 00:00:00
2011-11-21 00:00:00
2011-12-22 00:00:00
2012-01-26 00:00:00
2012-02-21 00:00:00
2012-03-26 00:00:00
2012-04-26 00:00:00
2012-05-21 00:00:00
2012-06-25 00:00:00
2012-07-23 00:00:00
2012-08-20 00:00:00
2012-09-24 00:00:00
2012-10-25 00:00:00
2012-11-26 00:00:00
2012-12-21 00:00:00
2013-01-22 00:00:00
2013-02-25 00:00:00
2013-03-25 00:00:00
2013-04-22 00:00:00
2013-05-20 00:00:00
2013-06-24 00:00:00
2013-07-22 00:00:00
2013-08-20 00:00:00
2013-09-23 00:00:00
2013-11-12 00:00:00
2013-11-27 00:00:00
2013-12-23 00:00:00
2014-01-23 00:00:00
2014-02-24 00:00:00
Spreadsheet: 64329d1265197475-relative-difference-differential-values
Sheet: Sheet1

Product | Cat | Price |  | Diff
product A | [NAME] | 100 |  | 0
product A | [NAME] | 110 |  | 10
product A | [NAME] | 130 |  | 30
product B | Type 1 | 500 |  | 0
product B | Type 2 | 540 |  | 40
product B | Type 3 | 560 |  | 60
product B | Type 4 | 565 |  | 65
Spreadsheet: 75aace1e-c1a6-4720-a122-3bc0a3167048
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
CLFT | Test | CLFT | Chloride, 24 Hour, Feces | Chloride, 24 Hr, F | Coulometric |  |  |  | 20 | g | Container/Tube: Stool container (Supply T291) [NAME]: Entire collection Collection Instructions: 1. Collect a very liquid stool specimen. 2. See Stool Collection Information Sheet in Special Instructions. Additional Information: Do not send formed stool. In the event a formed stool is submitted, the test will not be performed. The report will indicate "A formed stool specimen was submitted for analysis. This test was not performed because it only has clinical value if performed on a watery stool specimen." | 3 g | Hemolysis	 NA Thawing	 Cold OK; Warm OK Lipemia	 NA Icterus	 NA Other	 Formed stool | 0-15 years: not established > or =16 years: 0-29 mEq/24 hour | Monday through Friday; evening | 2 days | 5 days | 1 | 82438 |  |  |  |  | Rochester
CLFT | [NAME] | FECAL | Fecal |  |  |  | Frozen | 14 days
CLFT | Order Question | TM106 | Collection Duration |  | Plain Text
CLFT | Result | 60028 | Chloride, 24 Hr, F | Chloride, 24 Hr, F | Numeric |  |  |  |  | mEq/24 h |  |  |  |  |  |  |  |  |  | 9742-8
CLFT | Result | 482 | Total Weight | Total Weight | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30078-0
CLFT | Result | TM106 | Collection Duration | Collection Duration | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13363-7
CLFT | Result | 444 | Chloride Concentration | Chloride Concentration | Numeric |  |  |  |  | mEq/kg |  |  |  |  |  |  |  |  |  | 2076-8
Spreadsheet: 845137d1696664414-generate-a-receipt-from-repeat-customer-file-hotel
Sheet: Receipt

 |  |  |  |  |  |  |  |  |  |  | Enter clients name | 1 [NAME]
Receipt
Dates |  | Description |  | No. Nights | Price | Total Price
 |  | Room number
 |  |  |  |  | Total price of stay
 |  |  |  |  | Tax
 |  |  |  |  | Deposits received
 |  |  |  |  | Total to Pay
Spreadsheet: 153581d1335966781-values-showing-up-as-letter-how-eks2-2-
Sheet: Ark1

 | [NAME] | [NAME]
2001-08-01 00:00:00 | 7.25 | 0 |  |  | 7.25 | D
2 | 0 | 14 |  |  | 14 | V
3 | 7.25 | 0 |  |  | 0 | F
4 | 14 | 0
5 | 0 | 7.25
6 | 0 | 7.25
7 | 7.25 | 7.25
total
norm | 37 | 37
balance
 | [NAME] | [NAME]
2001-08-01 00:00:00 | D | 0
2 | 0 | V
3 | D | 0
4 | V | 0
5 | 0 | D
6 | 0 | D
7 | D | D
total
norm | 37 | 37
balance
Spreadsheet: 138130d1327521372-creating-multiple-rows-of-data-from-a-single-row-source-example
Sheet: Order Report

Carton # | Quantity | Item # | Description | Notes
1 | 1 | 2 | [NAME] | Ship 1/25/2012
2 | 1 | 6 | Lime
5 | 1 | 8 | Grape
6 | 1 | 9 | Watermelon
3, 4 | 2 | 7 | Lemon
Spreadsheet: 802676d1666967203-copy-information-from-multiple-tables-to-a-sheet-bwp-invoices
Sheet: Table 11

 |  |  |  |  |  |  |  |  |  |  |  |  | Date |  |  |  | Invoice #
 |  |  |  |  |  |  |  |  |  |  |  |  | 2022-10-20 00:00:00 |  |  |  | 80025
 | [NAME] |  |  |  |  |  |  |  |  | Ship To
 | BW Papersystems Company P.O. Box 4717 [EMAIL] Timonium, MD 21094-4717 |  |  |  |  |  |  |  |  | BW Papersystems Co. 10615 Beaver Dam Road Hunt Valley, MD 21030-2204
P.O. Number |  |  | Terms |  | Rep |  | Ship |  | Via |  | F.O.B. |  |  | Project
PN43552 |  |  | 2%10NET45 |  | HOUSE |  | 2022-10-20 00:00:00 |  | UPS |  | Richmond, VA
Quantity |  | Item Code |  | Description |  |  |  |  |  |  |  | Price Each |  |  |  | Amount
1 1 |  | 443202 45MATERIAL |  | RETAINER, BRNG INNER COUPLING Material Surcharge |  |  |  |  |  |  |  | 185.00 45.00 |  |  |  | 185.00 45.00
 |  |  |  |  |  |  |  |  |  |  |  | Total                              $230.00
Payments/Credits                 $0.00 |  |  |  |  |  |  |  | Balance Due |  |  |  |  |  |  | 230
Spreadsheet: 775731d1649279614-sumifs-formula-with-variable-column-linefcsts22plan-example
Sheet: Data-a

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S/B 1309
CTL | DEPT | Current State Detail | Future State Detail | [NAME] | CM LINE | CM SUBTOTAL ROW | LOC | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | Blank | HG:HG | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | Total
62 | F103 | 622 | 622 | HOURLY OVERTIME PREMIUM | OVERTIME | Wages and Benefits | F1 | 2.06 | 1143.84 | 2723.94 | 1357.76 | 340.96 | 943.61 | 485.02 | 243.87 | 2184.18 | 1083.42 |  |  |  |  |  | 1371.1104 | 1308.7872 | 1308.7872 | 1246.464 | 1184.1408 | 1661.952 | 1661.952 | 1911.2448 | 1745.0496 | 1745.0496 | 1828.1472 | 18281.472
Spreadsheet: 740977d1626742744-formula-to-consolidate-values-if-adjacent-cell-meets-criteria-project-cost-tracking
Sheet: List

Expense - Trade Contractors
Name | Ex GST | GST | Inc. GST
Contractor #1 |  |  | 1000
Contractor #2 |  |  | 3500
Contractor #2 |  |  | 29500
Contractor #2 |  |  | 4752
Contractor #3 |  |  | 1200
Total Contractors
Expense - Materials / Hire / Preliminaries
Name | Ex GST | GST | Inc. GST
Central Supply Store |  |  | 134.13
Random Trade Supplies |  |  | 47.46
Random Trade Supplies |  |  | 77.8
Random Trade Supplies |  |  | 141.55
Temporary Materials Centre |  |  | 200.75
Temporary Materials Centre |  |  | 681.34
Unreal Trade Materials |  |  | 3744.4
Unreal Trade Materials |  |  | 458
Total M / H / P
Spreadsheet: 698331d1601926604-formula-rule-to-highlight-mistake-entry-conditional
Sheet: Sheet1

 | IS NOT 8 NUMBERS | IS NOT TWO CHAR | IS NOT NUMBERS |  |  |  | 00:01:50
1
2 |  | C5
3 | 12345678 |  | 5646465
4 |  | CC | 65415613146
5 | 154897 |  | 645312
6 | FB12345678 | 55 | 6541JJ54F1
7 | 165564498 | PS | GK54512H
8 | DFBF | FSDF | DVFD
9 | 546GFF5D5 | 6551
10
 |  |  |  | 10
 | I want use conditonal formatting for 3 separate columns , I explain the rule in headers, if not like headers then fill red and white