tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 296696d1392161108-printing-from-a-list-equipment_list
Sheet: Equipment_List46

Tank | [NAME] | ISO# | OIL | [NAME]
A1-NE-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
A1-NW-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
AA2-N-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
AA4-S-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
AA4-SW-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
BB1-SW-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
BB1-W-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
BB2-SE-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
BB3-SE-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
BB3-W-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
C1-E-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
C1-SW-H1 | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
C1-SW-H2 | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
CC1-SW-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
CC1-W-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
CC3-SE-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
CC3-W-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
[NAME] | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
G1-SW-H1 | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
G1-SW-H2 | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
R1-SW-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
R1-W-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
SK-SE-H1 | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
SK-SE-H2 | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
SK-SW-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
SK-W-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
SM-NE-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
SM-SW-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
SO-E-H1 | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
SO-E-H2 | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
SO-SW-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
SO-W-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
SP-E-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
SP-NE-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
SP-SE-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
SP-SW-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
SP-W-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
SR-E-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
SR-NE-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
SR-SE-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
SR-SW-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
SR-W-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
ST-SE-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
ST-SW-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
SV-E-H1 | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
SV-E-H2 | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
SV-N-H1 | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
SV-N-H2 | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
SV-SW-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
SV-W-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
Y1-S-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
Y1-SW-H | ISO 46 | 46 | AW HYDRAULIC OIL | LH-04-1
Spreadsheet: 68865d1269396234-formula-to-sort-through-data-and-display-specific-values-voltorbflipsolver
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | This color is for inputs.
Level | 5
Points | 25
Number of Voltorbs
 |  |  |  |  |  |  |  |  | Total Points should always equal 25.
 |  |  |  |  |  |  |  |  | Number of Voltorbs and Total Voltorbs should Match in Every Case
 |  |  |  |  |  |  |  |  |  | Column Points | Column Voltorbs |  | Row Points | Row Voltorbs
 |  |  |  |  |  |  |  |  | Column 1 | 4 | 2 | Row 1 | 2 | 4
 |  |  |  |  |  |  |  |  | Column 2 | 4 | 2 | Row 2 | 6 | 1
 |  |  |  |  |  |  |  |  | Column 3 | 5 | 2 | Row 3 | 5 | 2
 | Final Results Should Be |  |  |  |  |  |  |  | Column 4 | 6 | 2 | Row 4 | 4 | 2
 | 0 | 0 | 0 | 2 | 0 |  |  |  | Column 5 | 6 | 2 | Row 5 | 8 | 1
 | 1 | 2 | 2 | 1 | 0
 | 2 | 1 | 0 | 0 | 2
 | 1 | 0 | 1 | 0 | 2 |  |  |  | Total Points |  |  | Total Points
 | 0 | 1 | 2 | 3 | 2 |  |  |  | Total Voltorbs |  |  | Total Voltorbs
Spreadsheet: 477001d1472100921-how-to-populate-rows-in-a-table-based-on-another-cells-value-lists2
Sheet: Sheet2

 | Years: | 30 |  |  | Cash Flow: | 1000000
 | Earnings Rate: | 0.1
 | Present Value: | 1000000
 | [NAME]. Fees: | 0.02
 |  |  | [NAME] | BOY Acct Value | Earnings Rate | Annual Cash Flow |  | Interest Earnings |  | Misc Fees | EOY Acct Value |  | [NAME] | BOY Acct Value | Earnings Rate | Annual Cash Flow |  | Interest Earnings |  | Misc Fees | EOY Acct Value
 |  |  | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 |  | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9
 |  |  | 1
Spreadsheet: lynn_blair__24409__Administrative Functions
Sheet: Sheet1

FUNCTION | PRIMARY | [NAME]
SAP | [NAME] | [NAME]
IBUYIT | [NAME] | [NAME]
Scheduling Meetings | [NAME] | [NAME]
Mail Distribution | [NAME] | [NAME]
Expense Reports | [NAME] | [NAME]
Call Center Admin. | [NAME] | [NAME]
Supplies for ETS | [NAME] | [NAME]
Spreadsheet: 733210d1621439527-average-calculation-merge-example
Sheet: Sheet1

Example 1
No. | Description | Average Sales | Stock | Weeks Stock
Product 1 | Product 1 | 10 | 48
Product 1 - 1 | Product 1 - Box 1 | 2 | 48
Product 1 - 2 | Product 1 - Box 2 | 2 | 48
Product 1 - 3 | Product 1 - Box 3 | 2 | 50
Example 2
No. | Description | Average Sales | Stock | Weeks Stock
Product 1 | Product 1 | 12 | 48
Product 1 - 1 | Product 1 - Box 1 | 0 | 48
Product 1 - 2 | Product 1 - Box 2 | 0 | 48
Product 1 - 3 | Product 1 - Box 3 | 0 | 50
Spreadsheet: 0170c774-de7a-426a-b931-27f6dd134a97
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
GSHH FAMILY GIVING CAMPAIGN
2013-2014  Service Unit Bookkeeping Form
Community _________________ # of Troops ________ Report Date __________________
Service Unit Campaign Chair ___________________________________________________
Phone _____________________________   [NAME] _________________________________
Troop # | Troop Chair: Name/Phone | # [NAME] in Troop | # of Gifts | AMOUNT RECEIVED |  |  | Troop | Date of Deposit
 |  |  | Received | Cash | Checks | Charges | Total
 |  | 0 | Community Totals | 0 | 0 | 0 | 0 | 0
Spreadsheet: 86513d1286474336-efficient-formula-for-more-than-2-inputs-ifs-taxtable
Sheet: Sheet1

Tax | A |  |  |  |  |  |  |  | If Tax = A = 0 to 100 = 1;
Value | Result |  |  | Tax
143 | 2 |  | Value | A | B | C
 |  |  | 0 | 1 | 4 | 3
 |  |  | 101 | 2 | 6 | 4 |  |  | If Tax = B = 0 to 100 = 4;
 |  |  | 201 | 3 | 3 | 6
Formula in B3
 |  |  |  |  |  |  |  |  | If Tax = C = 0 to 100 = 3;
Spreadsheet: 0631d5a1-58ec-4666-8441-fa5f5eacc824
Sheet: Sheet1

TABLE 1 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18
HEADCOUNT ENROLLMENT OF CREDIT STUDENTS BY CAMPUS
UNIVERSITY OF HAWAI‘I
FALL 2001 TO FALL 2014
 |  |  | HISTORICAL |  |  |  |  |  |  |  | PROJECTED
CAMPUS |  |  | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 |  | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014
 | UH SYSTEM TOTAL  1/ ............................................................................ |  | 45994 | 48173 | 50317 | 50569 | 50157 | 49990 | 50454 |  | 50750 | 51133 | 51649 | 51973 | 52222 | 52475 | 52639
 | UH AT MANOA  2/ ........................................................... |  | 17532 | 18706 | 19863 | 20549 | 20644 | 20357 | 20051 |  | 19855 | 19762 | 19731 | 19751 | 19798 | 19854 | 19895
 | UH AT HILO  2/ ................................................................ |  | 2913 | 3040 | 3300 | 3288 | 3422 | 3507 | 3573 |  | 3660 | 3755 | 3841 | 3880 | 3908 | 3950 | 4008
 | UH - WEST O‘AHU ................................................ |  | 740 | 834 | 810 | 834 | 858 | 866 | 940 |  | 990 | 1092 | 1453 | 1588 | 1651 | 1760 | 1865
 | UH COMMUNITY COLLEGES ................................................ |  | 24809 | 25593 | 26344 | 25898 | 25233 | 25260 | 25890 |  | 26245 | 26524 | 26624 | 26754 | 26865 | 26911 | 26871
 | Hawai‘i Community College ................................................ |  | 2075 | 2182 | 2346 | 2440 | 2377 | 2358 | 2603 |  | 2681 | 2732 | 2760 | 2776 | 2782 | 2792 | 2800
 | Honolulu Community College  2/ ................................................ |  | 4653 | 4478 | 4238 | 4336 | 4183 | 4143 | 4027 |  | 4002 | 3990 | 3975 | 3966 | 3964 | 3953 | 3926
 | Kapi‘olani Community College ................................................ |  | 7081 | 7041 | 7491 | 7174 | 7289 | 7272 | 7517 |  | 7650 | 7762 | 7821 | 7879 | 7935 | 7961 | 7970
 | Kaua‘i Community College ................................................ |  | 1185 | 1224 | 1210 | 1117 | 1059 | 1119 | 1051 |  | 1073 | 1104 | 1090 | 1100 | 1100 | 1096 | 1102
 | Leeward Community College ................................................ |  | 5562 | 5918 | 6201 | 6060 | 5709 | 5746 | 5887 |  | 5971 | 5997 | 6017 | 6017 | 6018 | 6017 | 5974
 | Maui Community College ................................................ |  | 2699 | 2989 | 2985 | 2996 | 2903 | 2841 | 2981 |  | 3012 | 3077 | 3102 | 3152 | 3179 | 3217 | 3234
 | Windward Community College ................................................ |  | 1554 | 1761 | 1873 | 1775 | 1713 | 1781 | 1824 |  | 1856 | 1862 | 1859 | 1864 | 1887 | 1875 | 1865
 | 1/  Headcounts include specials (early admits and concurrent students) for all years.
 | 2/  Headcounts include continuing education credit enrollments, beginning Fall 1999.
Spreadsheet: 771828d1646863548-10-asset-replacement-help-please-example
Sheet: Sheet1

 |  |  | Below is what figures should be shown but using a formula to find the value.
Asset | Life | Purchase Date | 2021/22 | 2022/23 | 2023/24 | 2024/25 | 2025/26 | 2026/27 | 2027/28 | 2028/29 | 2029/30 | 2030/31 | 2031/32 |  |  |  | Asset Number | 1st Replacement FY | 1st Replacement Date | 1st Replacement Cost | 2nd Replacement FY | 2nd Replacement Date | 2nd Replacement Cost | 3rd Replacement FY | 3rd Replacement Date | 3rd Replacement Cost | 4th Replacement FY | 4th Replacement Date | 4th Replacement Cost | 5th Replacement FY | 5th Replacement Date | 5th Replacement Cost | 6th Replacement FY | 6th Replacement Date | 6th Replacement Cost | 7th Replacement FY | 7th Replacement Date | 7th Replacement Cost | 8th Replacement FY | 8th Replacement Date | 8th Replacement Cost | 9th Replacement FY | 9th Replacement Date | 9th Replacement Cost | 10th Replacement FY | 10th Replacement Date | 10th Replacement Cost | 11th Replacement FY | 11th Replacement Date | 11th Replacement Cost
1111 | 3 | 2019-03-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5000
1112 | 4 | 2018-03-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6000
1113 | 5 | 2017-03-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7000
1114 | 6 | 2016-03-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8000
Spreadsheet: 243057d1371196350-linear-interpolation-with-unevenly-spaced-data-interpolation-spreadsheet-example
Sheet: Sheet1

Tabulated Data |  |  | Interpolated Data
Time (s) | Value |  | Time (s) | Value
1 | 985 |  | 1
3 | 1104 |  | 2
5 | 989 |  | 3
6 | 925 |  | 4
8 | 740 |  | 5
9 | 1144 |  | 6
11 | 902 |  | 7
12 | 998 |  | 8
14 | 859 |  | 9
15 | 776 |  | 10
17 | 838 |  | 11
18 | 812 |  | 12
20 | 708 |  | 13
23 | 965 |  | 14
25 | 1025 |  | 15
26 | 874 |  | 16
28 | 1252 |  | 17
29 | 1283 |  | 18
31 | 1222 |  | 19
32 | 1247 |  | 20
34 | 1220 |  | 21
35 | 1298 |  | 22
41 | 1443 |  | 23
42 | 1341 |  | 24
44 | 1415 |  | 25
45 | 1535 |  | 26
46 | 1554 |  | 27
48 | 1657 |  | 28
50 | 1449 |  | 29
51 | 1677 |  | 30
53 | 1544 |  | 31
54 | 1532 |  | 32
56 | 1338 |  | 33
57 | 1568 |  | 34
59 | 1819 |  | 35
60 | 1566 |  | 36
62 | 1665 |  | 37
63 | 1846 |  | 38
65 | 1736 |  | 39
66 | 1550 |  | 40
68 | 1557 |  | 41
69 | 1763 |  | 42
71 | 1866 |  | 43
73 | 1806 |  | 44
74 | 1589 |  | 45
76 | 1411 |  | 46
77 | 1626 |  | 47
79 | 1580 |  | 48
81 | 1725 |  | 49
82 | 1685 |  | 50
84 | 1630 |  | 51
85 | 1766 |  | 52
87 | 1475 |  | 53
88 | 1624 |  | 54
90 | 1977 |  | 55
91 | 1602 |  | 56
93 | 1635 |  | 57
94 | 1811 |  | 58
96 | 1636 |  | 59
97 | 1883 |  | 60
99 | 1843 |  | 61
100 | 1608 |  | 62
102 | 1571 |  | 63
103 | 1703 |  | 64
105 | 1623 |  | 65
106 | 1805 |  | 66
108 | 1804 |  | 67
109 | 1585 |  | 68
111 | 1605 |  | 69
112 | 1776 |  | 70
116 | 1825 |  | 71
118 | 2097 |  | 72
119 | 1876 |  | 73
121 | 1651 |  | 74
122 | 1797 |  | 75
124 | 1704 |  | 76
125 | 1603 |  | 77
127 | 1793 |  | 78
129 | 1843 |  | 79
130 | 1722 |  | 80
131 | 1555 |  | 81
133 | 1806 |  | 82
135 | 1813 |  | 83
136 | 1411 |  | 84
137 | 1992 |  | 85
139 | 1748 |  | 86
140 | 1790 |  | 87
142 | 1716 |  | 88
143 | 1541 |  | 89
145 | 1528 |  | 90
146 | 1514 |  | 91
147 | 1979 |  | 92
149 | 1845 |  | 93
150 | 1790 |  | 94
152 | 1745 |  | 95
153 | 1829 |  | 96
154 | 1643 |  | 97
156 | 1548 |  | 98
157 | 1882 |  | 99
159 | 1681 |  | 100
160 | 1612 |  | 101
161 | 1757 |  | 102
163 | 1453 |  | 103
164 | 1751 |  | 104
166 | 1543 |  | 105
167 | 1759 |  | 106
168 | 1695 |  | 107
170 | 1907 |  | 108
172 | 1671 |  | 109
173 | 1619 |  | 110
175 | 1538 |  | 111
176 | 1909 |  | 112
177 | 1700 |  | 113
 |  |  | 114
 |  |  | 115
 |  |  | 116
 |  |  | 117
 |  |  | 118
 |  |  | 119
 |  |  | 120
 |  |  | 121
 |  |  | 122
 |  |  | 123
 |  |  | 124
 |  |  | 125
 |  |  | 126
 |  |  | 127
 |  |  | 128
 |  |  | 129
 |  |  | 130
 |  |  | 131
 |  |  | 132
 |  |  | 133
 |  |  | 134
 |  |  | 135
 |  |  | 136
 |  |  | 137
 |  |  | 138
 |  |  | 139
 |  |  | 140
 |  |  | 141
 |  |  | 142
 |  |  | 143
 |  |  | 144
 |  |  | 145
 |  |  | 146
 |  |  | 147
 |  |  | 148
 |  |  | 149
 |  |  | 150
 |  |  | 151
 |  |  | 152
 |  |  | 153
 |  |  | 154
 |  |  | 155
 |  |  | 156
 |  |  | 157
 |  |  | 158
 |  |  | 159
 |  |  | 160
 |  |  | 161
 |  |  | 162
 |  |  | 163
 |  |  | 164
 |  |  | 165
 |  |  | 166
 |  |  | 167
 |  |  | 168
 |  |  | 169
 |  |  | 170
 |  |  | 171
 |  |  | 172
 |  |  | 173
 |  |  | 174
 |  |  | 175
 |  |  | 176
 |  |  | 177
Spreadsheet: 287405d1388778900-show-table-data-in-printable-form-forum-sample2-ndmv1
Sheet: OUTPUT HERE!

Client2
 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013
cash
current assets
total assets
total liabilities
Spreadsheet: danny_mccarty__4660__IdleAire 10-2001 Valuation
Sheet: Overview

IDLEAIRE TECHNOLOGIES VALUATION OVERVIEW
($ millions except per share data) |  |  |  | 2000A |  | 2001E |  | 2002E |  | 2003E |  | 2004E |  | 2005E
INCOME PROFORMA
Revenues
 | Revenue Growth
 | Gross Margin
EBITDA
 | % of Revenues |  |  | nm
Earnings
 | Earnings per Share (EPS)
 | EPS Growth
 | Shares Outstanding (M)
 | Fully Diluted Shares (M)
VALUATION
 | Annualized Revenues
 | Annualized EBITDA
 | Comparable Transaction Analysis - Revenues (ltm)
 | Comparable Transaction Analysis - EBITDA (ltm)
 | Comparable Public Company Analysis - Revenues (ltm)
 | Comparable Public Company Analysis - EBITDA (ltm)
 | Comparable Public Company Analysis - Earnings (ltm)
 | DCF Analysis @ 20% Discount Factor
 | DCF Analysis @ 30% Discount Factor
 | Mean Valuation
 | Median Valuation
Assumed Value
 | Price per Share (Fully Diluted)
 | Price / Revenues (ltm) |  |  | nm
 | Price / Revenues (annualized) |  |  | nm
 | Price / EBITDA (ltm) |  |  | nm |  | nm
 | Price / EBITDA (annualized) |  |  | nm |  | nm
 | Price / Earnings (ltm) |  |  | nm |  | nm |  | nm
Spreadsheet: 749081d1632494643-sort-by-column-in-one-sheet-and-maintain-row-formula-references-in-another-sheet-test-metrics-tms
Sheet: Jan

ISP | Hours Worked | Avg. ACD Talk Time | Auto-In Calls | Top Line Calls | Outbound Calls | Total Calls | Avg. Calls/Hour | ISP Emails | Clearslide Email Campaigns | Avg. Emails/Hour | Webinars Conducted | SF Leads Created | Avg. Work Volume/Hour | SF Tasks w/out Clearslide | SF Opp. | Total SF | Avg. SF/Hour | Clearslide Emails Sent | Total Contacts | Avg. Contacts/Hour
a | 144.5 | 02:33:00 | 95 | 46 | 75 |  |  | 100 | 0 |  | 0 | 14 |  | 305 | 50 |  |  | 0
b | 153.5 | 04:24:00 | 91 | 100 | 142 |  |  | 125 | 0 |  | 6 | 4 |  | 387 | 31 |  |  | 0
c | 156 | 05:39:00 | 59 | 135 | 74 |  |  | 150 | 0 |  | 0 | 0 |  | 52 | 29 |  |  | 0
Spreadsheet: 0f96e517-2c0c-4a5b-ba70-c0168e102737
Sheet: Sheet1

Year | Agriculture, forestry, fishing | Industry | Households | Other | Unclassified | Total
2000 | 265700 | 2020621 | 11594197 | 3946409 | 172661 | 17999588
2001 | 279426 | 1535754 | 11435000 | 2968026 | 159779 | 16377985
2002 | 238197 | 1539423 | 12305600 | 3046245 | 160619 | 17290084
2003 | 183465 | 1638744 | 10416675 | 2731117 | 150948 | 15120949
2004 | 302902 | 1585631 | 12296888 | 3162334 | 157388 | 17505143
2005 | 258305 | 1345893 | 8330760 | 2501840 | 167834 | 12604632
2006 | 205172 | 1156691 | 10790860 | 2507227 | 106678 | 14766628
2007 | 255793 | 1315530 | 11184268 | 2698120 | 111351 | 15565062
Source: NSO
Notes
Figures are in m3 and refer to actual consumption only; estimated consumption is not included.
Figures were revised in April 2009.
The Unclassified sector refers to economic units which have not been identified by NACE code (statistical classification of economic activities in the EC).
Spreadsheet: 755933d1637186136-non-vba-textjoin-alternative-for-ms-2016-sample-data
Sheet: Sub

Column1 | Consol Acct # | Consol Account Description | Column2 | Sub Acct # | Sub Account Description
 | 7400-0000 | Repairs & Maintenance |  | 755000-730 | Service Contract - Building Maintenance
 | 7400-0000 | Repairs & Maintenance |  | 712000-730 | Building Maintenance
 | 7400-0000 | Repairs & Maintenance |  | 731000-730 | Equipment Repair
 | 7400-0100 | Equipment under $2,500 |  | 732000-730 | Equipment Under $2500
 | 7400-0200 | Freight & Postage |  | 706000-730 | Postage
 | 7400-0350 | Auto Lease Expense |  | 723000-730 | Auto Lease
 | 7400-0400 | Dues & Subscriptions |  | 703000-730 | Dues and Subscriptions
 | 7400-0400 | Dues & Subscriptions |  | 705000-730 | Licences
 | 7400-0500 | Office Supplies |  | 700000-730 | Office Supplies
 | 7400-0700 | Computer Supplies |  | 702000-730 | Computer Supplies
 | 7400-0900 | Janitorial Services/Supplies |  | 701700-730 | Janitorial Services
 | 7400-1100 | Outside Services |  | 713000-730 | Document Storage
 | 7400-1100 | Outside Services |  | 750000-730 | Service Contract - ERP
 | 7400-1100 | Outside Services |  | 751000-730 | Service Contract - Printers
 | 7400-1100 | Outside Services |  | 752000-730 | Service Contract - Copiers
 | 7400-1100 | Outside Services |  | 753000-730 | Service Contract - Shredding
 | 7400-1100 | Outside Services |  | 754000-730 | Service Contract - Data Backup
 | 7400-1100 | Outside Services |  | 762000-730 | Professional Fees - Payroll
 | 7400-1100 | Outside Services |  | 765000-730 | Outside Services - Engineering
 | 7400-1100 | Outside Services |  | 766000-730 | Outside Services - Sales
 | 7400-1100 | Outside Services |  | 767000-730 | Outside Services - Employment
 | 7400-1100 | Outside Services |  | 768000-730 | Outside Services - ERP
 | 7400-1100 | Outside Services |  | 768100-730 | Outside Services - Website
 | 7400-1100 | Outside Services |  | 769000-730 | Outside Services - Other
 | 7400-1120 | Contract Labor/Temporary Help |  | 609000-730 | Payroll - Temporary Employees
 | 7400-1200 | Rent Expense - Building |  | 710000-730 | Rent - Building
 | 7400-1250 | Rent Expense - Out-of-Scope Leases |  | 710600-730 | Rent Expense - Out of Scope Leases
 | 7400-1320 | Variable Lease Expense |  | 711500-730 | Re
 | 7400-1320 | Variable Lease Expense |  | 711000-730 | Rent -  Storage
 | 7400-1320 | Variable Lease Expense |  | 730000-730 | Equipment Rental
 | 7400-1350 | Property Tax Expense |  | 782000-730 | Taxes - Property
 | 7400-1360 | Other Taxes & Licenses |  | 780000-730 | Taxes - Federal
 | 7400-1360 | Other Taxes & Licenses |  | 781000-730 | Taxes - State
 | 7400-1360 | Other Taxes & Licenses |  | 783000-730 | Taxes - Tangible
 | 7400-1360 | Other Taxes & Licenses |  | 784000-730 | Taxes - Other
 | 7400-1370 | Security Expense |  | 701600-730 | Alarm
 | 7400-1500 | Legal Fees |  | 760000-730 | Professional Fees - Legal
 | 7400-3000 | OEM Part Purchases |  | 800000 | Engineering Projects
 | 7400-3000 | OEM Part Purchases |  | 880000 | Engineering Material
Spreadsheet: 17de9773-95c6-435f-8996-eb83a041be85
Sheet: Sheet1

NOVINKY HUDEBNÍHO ODDĚLENÍ  2014 (1) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
číslo | interpret / skupina | [NAME] CD / skladby | rok
2723 | Adler-Olsen Jussi [čte Igor Bareš] | Žena v kleci [mp3] | 2013
2737 | [NAME] | Milí [NAME] (1976-1995) [2CD] | 2004
2710 | Avicii | True | 2013
2722 | [NAME] | Šíleně smutné povídky [mp3] | 2013
2708 | [NAME] | Where I belong | 2013
2732 | [NAME] [čte [NAME]] | Krakatit [mp3] | 2010
2743 | [NAME] | 15 | 2013
2733 | Eco Umberto | [NAME] růže [mp3] | 2011
2734 | [NAME] | Hrozba [mp3] | 2011
2736 | [NAME] [čte [NAME]] | [NAME] [mp3] | 2013
2717 | [NAME] | 18 months [2CD] | 2012
2735 | Havlíček Jaroslav [čte Rudolf Pellar] | [NAME] lampy [mp3] | 2006
2744 | [NAME] [čte Miroslav Táborský] | Siddhártha [4CD] | 2010
2711 | [NAME] [čtou [NAME] a Magdalena Sidonová] | Pábitelé | 2006
2713 | Jirásek / Petiška / Cibula / Košnář | O zlaté kolébce [2CD] | 2009
2719 | Kepler Lars [čte [NAME]] | Hypnotizér [2CD mp3] | 2013
2716 | [NAME] a jeho cílová skupina | Proměnamě | 2014
2724 | Malka Victor [čte [NAME] | Nejkrásnější židovské legendy | 2011
2714 | Marek Jiří | Panoptikum hříšných lidí města pražského [2CD] | 2013
2709 | Maroon 5 | Overexposed | 2012
2720 | [NAME] [účinkují [NAME], [NAME] a Jana Stryková] | Norské dřevo [mp3] | 2013
2721 | [NAME] [čte [NAME]] | Lovci hlav [mp3] | 2013
2715 | Nohavica Jaromír & přátelé | Noc plná hvězd, 29.6.2012, [NAME] [2CD + DVD] | 2014
2741 | Obermannová Irena [čte [NAME]] | Divnolásky [3CD] | 2009
2738 | Radůza | Gaia | 2014
2730 | [NAME] | 5x [NAME] [5CD] | 2011
2740 | Šimek / Sobota / Nárožný / Krampol | [NAME] scénky | 2006
2726 | [NAME] [čte Lukáš Hlavica] | [NAME] [2CD] | 2010
2718 | [NAME] [účinkují [NAME] a Miroslav Táborský] | Žítkovské bohyně | 2012
2729 | Twain Mark | Princ a chuďas [2CD] | 2011
2725 | V.A. - různí autoři & interpreti | [NAME] | 2009
2728 | V.A. - různí interpreti | Pohádky tisíce a jedné noci | 2010
2712 | [NAME] [čte [NAME]] | [NAME] léto [3CD] | 2006
2727 | [NAME] | Večer s [NAME] | 2010
2742 | [NAME] [čtou [NAME] a autor] | Nápady laskavého čtenáře | 2010
2707 | [NAME] (čte [NAME]) | [NAME] masopustních maškar | 2013
2731 | Werich Jan & Horníček Miroslav | Werich a Horníček na Kampě [2CD] | 2011
2739 | [NAME] | Trocha z [NAME] a ještě něco | 2004
ZDE V POZNÁMCE K NAHLÉDNUTÍ SEZNAM TITULŮ NOVĚ K ABSENČNÍM VÝPŮJČKÁM
Spreadsheet: 878139d1725134367-need-to-show-the-number-of-occurances-within-a-date-range-cad-data-test
Sheet: CAD DAILY TEST

 | CAD NO | C6 | 331C | 333C | 338C | 339C | 340C | 344C | 346C | 345C
DATE
2024-01-01 00:00:00 |  |  |  |  |  |  | 1
2024-01-02 00:00:00 |  |  |  |  |  |  | 1
2024-01-03 00:00:00 |  |  |  |  |  |  | 4
2024-01-04 00:00:00
2024-01-05 00:00:00
2024-01-06 00:00:00
2024-01-07 00:00:00
2024-01-08 00:00:00
 |  | SHOW THE TABLE HERE AS TO HOW MANY TIME THE CAD WAS COUNTED ON THAT DATE
Spreadsheet: 692227d1598198700-conditional-formatting-between-report-due-conditional-formatting
Sheet: Sheet1

This is a snapshot of the data I am working with and the Conditional Formatting I am trying to create.  I think the first formula you sent
to me is working (see row 18 Condition 1) but I don't think my attempt at Condition 2 is working.
Visit Date | Due Date (+ 6 weeks) | Report Issued
2020-07-06 00:00:00 |  | 2020-08-14 00:00:00
2020-07-06 00:00:00
2020-07-27 00:00:00
2020-09-14 00:00:00
 | Due Date is 6 weeks after Visit Date
 | Conditional Formatting req'd on Column B
Row 2 | Report due in two weeks - between 03/08/20 and 16/08/20 if Report Issued is blank |  |  |  |  |  | Report Late - 18/08/20 onwards
Row 3 | Report due in two weeks - between 03/08/20 and 16/08/20 if Report Issued is blank |  |  |  |  |  | Report Late - 18/08/20 onwards
Row 4 | Report due in two weeks - between 24/08/20 and 06/09/20 if Report Issued is blank |  |  |  |  |  | Report Late - 08/09/20 onwards
Row 5 | Report due in two weeks - between 12/10/20 and 25/10/20 if Report Issued is blank |  |  |  |  |  | Report Late - 27/10/20 onwards
 | Condition 1 |  |  |  | Condition 2