tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: michael_maggi__26471__NYMEXWEEKLYSTATS
Sheet: cl

Week Ending: | 2001-01-14 00:00:00
 | Futures Settlement Prices
 | CRUDE OIL |  |  |  |  | Contract Symbol:  CL
 | Contract | Monday | Tuesday | Wednesday | Thursday | Friday | Open
 | Month | 2001-01-14 00:00:00 | 2001-01-15 00:00:00 | 2001-01-16 00:00:00 | 2001-01-17 00:00:00 | 2001-01-18 00:00:00 | Interest
 | 2002-02-01 00:00:00 | 18.89 | 18.9 | 18.86 | 17.97 | 18 | 45585
 | 2002-03-01 00:00:00 | 19.41 | 19.44 | 19.48 | 18.63 | 18.66 | 127293
 | 2002-04-01 00:00:00 | 19.74 | 19.74 | 19.84 | 19.03 | 19.06 | 51313
 | 2002-05-01 00:00:00 | 19.91 | 19.91 | 20.05 | 19.27 | 19.3 | 30135
 | 2002-06-01 00:00:00 | 20.03 | 20.03 | 20.2 | 19.45 | 19.48 | 29510
 | 2002-07-01 00:00:00 | 20.06 | 20.05 | 20.24 | 19.52 | 19.56 | 16777
 | 2002-08-01 00:00:00 | 20.09 | 20.07 | 20.27 | 19.59 | 19.63 | 15096
 | 2002-09-01 00:00:00 | 20.12 | 20.1 | 20.31 | 19.64 | 19.69 | 14519
 | 2002-10-01 00:00:00 | 20.15 | 20.13 | 20.35 | 19.69 | 19.75 | 10856
 | 2002-11-01 00:00:00 | 20.18 | 20.15 | 20.39 | 19.74 | 19.8 | 8525
 | 2002-12-01 00:00:00 | 20.21 | 20.17 | 20.42 | 19.79 | 19.85 | 27429
 | 2003-01-01 00:00:00 | 20.24 | 20.19 | 20.45 | 19.84 | 19.9 | 12965
 | Total Weekly Volume
 |  |  |  |  | Total Open Interest |  | 460607
 |  |  |  | *Weekly volume and open interest reflects all traded months.
 | Historical Volatility-Spot Month Futures
 |  |  |  | Crude Oil
 | 5 Day Hist. Vol. |  |  | 0.3907
 | 20 Day Hist. Vol. |  |  | 0.5971
 | Implied Volatility-Options
 |  |  |  | Crude Oil
 | At the Money Call & Put
 |  |  |  | 0.5192
Volume | MON | TUE | WED | THUR | FRI | Total
 | 210758 | 190640 | 209950 | 235720 | 140610
Spreadsheet: 127428d1320343324-multiple-3-sumproduct-conditions-testsheet
Sheet: source

Trans Date | Project | Project Name | Spare | Cust Name | Cust Number | Cost Id | Cost Description | Details | Cost Type | Category ID | line Property ID | Qty | Cost Price | Spend | Category | Month
 | Project1 |  |  |  |  |  |  |  |  |  |  |  |  | 3496 | Travel | January
 | Project1 |  |  |  |  |  |  |  |  |  |  |  |  | 3496 | Associates | January
 | Project1 |  |  |  |  |  |  |  |  |  |  |  |  | 875 | Associates | January
 | Project1 |  |  |  |  |  |  |  |  |  |  |  |  | 2600 | Travel | January
 | Project2 |  |  |  |  |  |  |  |  |  |  |  |  | 36.5 | Associates | January
 | Project2 |  |  |  |  |  |  |  |  |  |  |  |  | 4015 | Subsistence | January
 | Project2 |  |  |  |  |  |  |  |  |  |  |  |  | 5475 | Subsistence | January
 | Project2 |  |  |  |  |  |  |  |  |  |  |  |  | 51 | Travel | January
 | Project3 |  |  |  |  |  |  |  |  |  |  |  |  | 289 | Subsistence | January
 | Project3 |  |  |  |  |  |  |  |  |  |  |  |  | 74.5 | Associates | January
 | Project3 |  |  |  |  |  |  |  |  |  |  |  |  | -10 | Travel | January
 | Project3 |  |  |  |  |  |  |  |  |  |  |  |  | 250 | Subsistence | Feb
 | Project1 |  |  |  |  |  |  |  |  |  |  |  |  | 350 | Associates | Feb
 | Project1 |  |  |  |  |  |  |  |  |  |  |  |  | 5.6 | Subsistence | Feb
 | Project1 |  |  |  |  |  |  |  |  |  |  |  |  | 6.3 | Travel | Feb
 | Project1 |  |  |  |  |  |  |  |  |  |  |  |  | 25.5 | Travel | Feb
 | Project2 |  |  |  |  |  |  |  |  |  |  |  |  | 25 | Associates | Feb
 | Project2 |  |  |  |  |  |  |  |  |  |  |  |  | 25 | Subsistence | Feb
 | Project2 |  |  |  |  |  |  |  |  |  |  |  |  | 249.42 | Subsistence | Feb
 | Project2 |  |  |  |  |  |  |  |  |  |  |  |  | 68.22 | Associates | Feb
 | Project3 |  |  |  |  |  |  |  |  |  |  |  |  | 15 | Travel | Feb
 | Project3 |  |  |  |  |  |  |  |  |  |  |  |  | 2600 | Associates | Feb
 | Project3 |  |  |  |  |  |  |  |  |  |  |  |  | 36.5 | Subsistence | Feb
 | Project3 |  |  |  |  |  |  |  |  |  |  |  |  | 4015 | Travel | Feb
 | Project1 |  |  |  |  |  |  |  |  |  |  |  |  | 5475 | Associates | Mar
 | Project1 |  |  |  |  |  |  |  |  |  |  |  |  | 51 | Subsistence | Mar
 | Project1 |  |  |  |  |  |  |  |  |  |  |  |  | 289 | Travel | Mar
 | Project1 |  |  |  |  |  |  |  |  |  |  |  |  | 74.5 | Associates | Mar
 | Project2 |  |  |  |  |  |  |  |  |  |  |  |  | -10 | Subsistence | Mar
 | Project2 |  |  |  |  |  |  |  |  |  |  |  |  | 250 | Subsistence | Mar
 | Project2 |  |  |  |  |  |  |  |  |  |  |  |  | 350 | Associates | Mar
 | Project2 |  |  |  |  |  |  |  |  |  |  |  |  | 5.6 | Travel | Mar
 | Project3 |  |  |  |  |  |  |  |  |  |  |  |  | 6.3 | Subsistence | Mar
 | Project3 |  |  |  |  |  |  |  |  |  |  |  |  | 25.5 | Associates | Mar
 | Project3 |  |  |  |  |  |  |  |  |  |  |  |  | 25 | Subsistence | Mar
 | Project3 |  |  |  |  |  |  |  |  |  |  |  |  | 25 | Associates | Mar
Spreadsheet: joe_parks__15061__BridgeDPR0620
Sheet: Bridgeline DPR2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BRIDGELINE GAS MARKETING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY POSITION REPORT
 |  | Position |  |  | Maturity / Gap Risk |  |  | Value-at-Risk |  |  |  | P&L ($000)
Business Unit - Commodity Group |  | Net Open | Limit |  | Sensitivity | Limit |  | 1-Day |  | Limit |  | Today | 5 Day Rolling | MTD | QTD | YTD |  | Yesterday's MTD | Yesterday's QTD | Yesterday's YTD
BRIDGELINE GAS MARKETING
GAS TRADING |  |  | 15 Bcf |  |  |  |  |  |  | 2000
1 Month |  |  |  |  |  | 9 Bcf 1 Month
2-12 Months |  |  |  |  |  | 25 Bcf 2-12 Months
13-18 Months |  |  |  |  |  | 5 Bcf 13-18 Months
TOTAL TRADING
Notes to File
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MTD | QTD | YTD
 |  |  |  |  |  |  |  |  |  |  |  |  | ENRON NORTH AMERICA | 1740.9860877 | 6895.9860877 | 12186.9860877
 |  |  |  |  |  |  |  |  |  |  |  |  | GAS TRADING | 1740.9860877 | 6895.9860877 | 12186.9860877
 | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | -2243.48
 |  |  |  |  |  |  |  |  |  | 998027.0603850778
Spreadsheet: 115288d1310927849-transferring-results-and-drop-down-lists-example-worksheet1
Sheet: Output Tab 2010

1 | Line Number of Current Hospital
Hospital: | Hospital A
Hospital Number: | 000001
FYE: | 2011-12-31 00:00:00
1) Data 1 |  |  |  |  |  | 12378
2) Multiply by 1.4 |  |  |  |  |  | 17329.2
3)     Data 2 - 2009 |  |  | 338942.17
Data 3 - 2009 |  |  | 89225.87
4)  Data 2 |  |  |  |  |  | 338942.17
Multiply by factor (Data 4) |  |  |  |  |  | 1.0121
Result 1 - 2010 |  |  |  |  |  | 343043.370257
Data 3 |  |  |  |  |  | 89225.87
Multiply by factor (Data 4) |  |  |  |  |  | 1.0121
Result 2 - 2010 |  |  |  |  |  | 90305.503027
Spreadsheet: 170044d1343145831-looking-to-get-rows-in-order-top-8-then-alphabetical-copycopy
Sheet: Data Analysis

 | Average | % of | Average number
Spreadsheet: 266458d1379617782-formula-for-each-month-and-number-count-for-exceptions-setup-exception-tracking-by-ae-example
Sheet: Alice

Date | Company | Broker | Processor | [NAME]. Last | Loan # (Last 5) | Exception reason | Exceptions | Submissions | Exception %
2013-03-31 00:00:00 |  |  |  |  |  |  | 0 | 27
2013-04-30 00:00:00 |  |  |  |  |  |  | 0 | 52
2013-05-13 00:00:00 | Synergy | [NAME] | [NAME] | Cuny | 37653 | asset >45
2013-05-13 00:00:00 | Seacliff Mortgage | [NAME] | [NAME] | Gates | 37484 | paystub >30
2013-05-23 00:00:00 | Meridian | [NAME] | [NAME] | [NAME] | 39114 | paystub >30 & asset >45
2013-05-31 00:00:00 | Elite One | [NAME] | [NAME] | Swisher | 39282 | paystubs >30 | 4 | 39
2013-06-17 00:00:00 | Back Bay Funding | [NAME] | Lily Doerr | McCann | 39461 | paystub >30
2013-06-17 00:00:00 | Back Bay Funding | [NAME] | Lily Doerr | [NAME] | 39504 | asset >45
2013-06-24 00:00:00 | Meridian | [NAME] | [NAME] | Pyle | 39557 | asset >45 | 3 | 29
2013-07-15 00:00:00 | Meridian Real Estate Group | [NAME] | [NAME] | LaVenture | 40180 | missing prelim
2013-07-15 00:00:00 | Stratis Financial Corporation | [NAME] | [NAME] | Stichka | 39888 | missing prelim & assets >45
2013-07-17 00:00:00 | Stratis Financial Corporation | [NAME] | [NAME] | Najm | 40204 | missing 2011 W2(s), assets >45
2013-07-19 00:00:00 | Elite One Mortgage | [NAME] | Rosana Rincon | Fomusoh | 40151 | assets missing pages
2013-07-24 00:00:00 | Back Bay Funding | [NAME] | Lily Doerr | Calata | 40208 | paystub >30 & asset >45 | 5 | 28
2013-08-06 00:00:00 | Stratis Financial Corporation | [NAME], Jr. | [NAME] | Ballout | 40640 | prelim >45; CB pay stub>30
2013-08-13 00:00:00 | Trans United Real Estate & Loans | [NAME] | [NAME] | Yassa | 40805 | missing prelim
2013-08-15 00:00:00 | Service One Mortgage | [NAME] | [NAME] | Nguyen | 40817 | asset >45
2013-08-27 00:00:00 | Trans United Real Estate & Loans | [NAME] | [NAME] | [NAME] | 40995 | Credit >45 | 4 | 29
Spreadsheet: 731605d1620451474-multi-criteria-vlookup-daily-in-out-audit
Sheet: EElist

 | Daily Time Card Totals
 | 2021-05-03 00:00:00
EE# © | in | Out | in | Out | in | Out | in | Out | in | Out | in | Out | in | Out
1894 |  | 2021-05-03 23:31:00 | 2021-05-04 14:53:00 | 2021-05-04 23:31:00 | 2021-05-05 14:58:00 | 2021-05-05 23:37:00 | 2021-05-06 15:05:00 | 2021-05-06 23:34:00 | 2021-05-07 14:57:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
1865 | 00:00:00 | 00:00:00 | 2021-05-04 06:24:00 | 2021-05-04 14:27:00 | 2021-05-05 06:24:00 | 2021-05-05 14:57:00 | 2021-05-06 06:25:00 | 2021-05-06 14:59:00 | 2021-05-07 05:20:00 | 2021-05-07 14:36:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
1792 | 2021-05-03 05:27:00 | 2021-05-03 14:02:00 | 2021-05-04 05:28:00 | 2021-05-04 14:23:00 | 2021-05-05 10:41:00 | 2021-05-05 20:01:00 | 2021-05-06 10:53:00 | 2021-05-06 21:37:00 | 2021-05-07 10:44:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
1910 | 2021-05-03 05:24:00 | 2021-05-03 14:00:00 | 2021-05-04 05:25:00 | 2021-05-04 14:00:00 | 2021-05-05 05:25:00 | 2021-05-05 14:00:00 | 00:00:00 | 2021-05-06 14:02:00 | 2021-05-07 05:25:00 | 2021-05-07 14:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
1804 | 2021-05-03 05:35:00 | 2021-05-03 15:30:00 | 2021-05-04 05:33:00 | 2021-05-04 14:17:00 | 2021-05-05 05:35:00 | 2021-05-05 14:21:00 | 2021-05-06 05:39:00 | 2021-05-06 14:21:00 | 2021-05-07 05:37:00 | 2021-05-07 14:51:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
1815 | 2021-05-03 05:44:00 | 2021-05-03 15:30:00 | 2021-05-04 05:34:00 | 2021-05-04 15:36:00 | 2021-05-05 05:34:00 | 2021-05-05 15:43:00 | 2021-05-06 05:35:00 | 2021-05-06 15:39:00 | 2021-05-07 05:34:00 | 2021-05-07 15:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
Spreadsheet: 133567d1324482129-pivot-table-not-suming-properly-invoice
Sheet: Sheet1

Row Labels
10
1
9
10
14
15
2
8
10
14
15
4
10
14
15
17
5
8
10
13
14
15
16
17
11
0
10
1
9
11
14
15
2
10
11
13
14
15
4
8
9
11
13
14
15
5
8
11
13
14
15
16
12
0
10
14
15
1
14
2
14
4
10
14
15
5
14
15
(blank)
(blank)
(blank)
Grand Total
Spreadsheet: 594413d1539759066-best-way-to-input-data-profitcalc2017
Sheet: Fixed

Fixed Costs |  |  | Term
 |  | Annual | Qtr | Mth | Week |  | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Per Annum
Rent |  | 120000 |  |  |  |  | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000
Rates |  | 7110
Insurances |  | 3180
Motor |  | 195000 |  |  |  |  | 10833 | 10833 | 10833 | 10833 | 10833 | 21000 | 21000 | 21000 | 21000 | 21000 | 21000 | 21000
[NAME] |  | 13547.33
Direct |  | 1262
Eng Insp |  | 314.51
Freight L |  | 2340
Congestion |  |  |  |  |  |  | 783 | 461.5 | 357 | 503 | 524.5 | 598.5 | 800 | 800 | 800 | 800 | 800 | 800
Total |  | 960 |  |  |  |  | 4
Wages |  | 356044
Licenses |  | 300
Tax |  | 27600
[NAME] |  | 6200 |  |  |  |  | 400 | 400 | 200 | 400 | 400 | 400 | 600 | 600 | 600 | 600 | 600 | 600
NIC TAX |  | 146400
SEZurichISA |  | 40000
Telecons |  | 4000
Membersp |  | 895
Building |  | 30000
Each [NAME] | 24
EU07 EZL
Spreadsheet: 871220d1717606536-trouble-creating-dependent-drop-down-lists-best-way-to-go-about-this-health-tracking
Sheet: Dropdown Data

 |  | [NAME] | Edgewood | Homewood | Homewood-Ravensview
 |  | [NAME] Program | Core Addiction & Mental Health Program | Addiction Medicine Program Mood Anxiety & Concurrent Program | [NAME] and Addiction Program
 |  | [NAME] | Edge1 | Home1 | Homeraven1
 |  | Bell2 | Edge2 | Home2
 |  | Bell3 | Edge3
 |  | [NAME] | Edge4
 |  | Program Name | Length
 |  | [NAME] Program | 63 Days
 |  | [NAME] | 7 Weeks
 |  | Bell2 | 60 Days
 |  | Bell3 | 40 Days
 |  | [NAME] | 8 Weeks
 |  | Core Addiction & Mental Health Program | 70 Days
 |  | Edge1 | 4 weeks
 |  | Edge2 | 7 days
 |  | Edge3 | 30 Days
 |  | Edge4 | 40 days
 |  | Addiction Medicine Program Mood Anxiety & Concurrent Program | 70 Days
 |  | Home1 | 20 days
 |  | Home2 | 9 days
 |  | [NAME] and Addiction Program | 11 Days
 |  | Homeraven1 | 45 Days
 |  | Facility | Location
 |  | [NAME] | Toronto, ON
 |  | Edgewood | Nanaimo,BC
 |  | Homewood | [NAME], ON
 |  | Homewood-Ravensview | Saanich,BC
Spreadsheet: 3fdfe860-45f0-47e6-a0f8-0c641dcf4625
Sheet: HLSC

Old course number | New course number
HLSC-305 | HLSC-3100
HLSC-330 | HLSC-3150
HLSC-340 | HLSC-3200
HLSC-344 | [NAME]
HLSC-400 | [NAME]
HLSC-420 | HLSC-4200
HLSC-421 | HLSC-3300
HLSC-455 | HLSC-4300
HLSC-470 | HLSC-4470
HLSC-480 | HLSC-4890
HLSC-500 | HLSC-5100
HLSC-501 | HLSC-5101
HLSC-502 | HLSC-5001
HLSC-505 | HLSC-4100
HLSC-750 | HLSC-7500
HLSC-830 | HLSC-8300
HLSC-840 | HLSC-8350
HLSC-841 | HLSC-8400
HLSC-850 | HLSC-8050
HLSC-864 | HLSC-8640
HLSC-870 | HLSC-8700
HLSC-875 | HLSC-8750
HLSC-880 | HLSC-8800
HLSC-890 | [NAME]
HLSC-891 | HLSC-9200
Spreadsheet: 291621d1390348417-auto-populating-a-table-based-on-ranked-values-excel_test-3
Sheet: 7 - Scoring 

ID # | Name | Regulatory Requirement? | Function? | Budget Capacity? |  |  |  |  | Weighted Overall Score | Rank
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
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
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
Spreadsheet: 79593d1279816085-v-lookup-combined-lookup-values-2-2columnmatch
Sheet: Current

Invoice Number | Customer | [NAME] |  | V-Lookup
1124 | Wal Mart | 111.58
81456 | Shoppers | 841.88
CD2233 | Zellers | 565.41
FD3356 | McDonalds | 111.11
1111 | Canadian Tire | 881.98
8125 | Rogers | 141.47
Spreadsheet: 293428d1390988946-need-help-to-create-parts-cross-reference-table-cross-reference
Sheet: Before

Part number | USED TO BE | USED TO BE | USED TO BE | USED TO BE | USED TO BE | USED TO BE
DBP | HGJ | ABC
DFE | GHI | KMJ | SAT
VCF
All items in this column are the newest replacement | these items are newest to oldest | these items are newest to oldest | these items are newest to oldest | these items are newest to oldest | these items are newest to oldest | these items are newest to oldest
separate sheet or table below
Current part numbers | items in this row are needed with newest replacement
DBP | ALSO | NEEDS | ONE | OF | THESE
DFE
VCF
Spreadsheet: 875479d1722038660-multiple-if-or-statements-avi101-data-1-tms
Sheet: Sheet1

Data 1 | Data 2 | Data 3 | Data 4 | Return | TMS | protonLeah
A | A1 | 01 | A
H | A2 | 01 | A
A | A3 | 01 | W
G | 3 | - | -
A | B1 | 03 | C
A | C1 | 08 | Z
D | A2 | 05 | Y
D | D3 | 01 | W
K | D9 | 11 | H
 |  |  |  |  |  |  | Logic is:
 |  |  |  |  |  |  | If [NAME], is "A";"B";"C";"D";"E";"F", and column D2 is "A";"B";"C";"D", return "RED"
 |  |  |  |  |  |  | If [NAME], is "H";"J";"K";"L", and column D2 is "A";"B";"C";"D";"E";"F";"G";"H";"I";"J";"K";"L";"M", return "BLUE"
 |  |  |  |  |  |  | If [NAME], is "A";"B";"C";"D";"E";"F", and column D2 is "T";"U";"V";"W";"X";"Y";"Z", return "GREEN"
 |  |  |  |  |  |  | If [NAME], is "G";"Q";"V";"Z", return "WHITE"
Spreadsheet: 723943d1615969365-diet-plan-formula-kopia-pliku-weekly-macro-tracker
Sheet: Ex Reference

ID | Type | Description | Combination Field | C | P | F | Cals | Size Notes
Required and must be unique | Optional | Reqd |  | Reqd | Reqd | Reqd | Calculated | Optional
1 | Breakfast | [NAME] |  | 35 | 23 | 10 |  | 2 scoop
 | Lunch | [NAME] and Roasted Veg |  | 10.2 | 44 | 9 |  | 170g chicken
 | Snack | [NAME] |  | 13 | 20 | 0.4 |  | 1 pot
 | Dinner | Belly Pork |  | 4 | 130 | 137 |  | 735g
 | Dinner | M&S Chicken Pie |  | 45.2 | 24.2 | 27.6 |  | 1 pie
 | Dinner | Seabass Fillets |  | 0.6 | 32 | 20 |  | 2 fillets
 | Snack | [NAME] cheese |  | 0 | 5 | 6 |  | 1 bel
 | Snack | Cream cracker with butter |  | 5 | 1 | 4 |  | 1 cracker
 | Snack | Nature Valley Protein Bar |  | 9.6 | 10.2 | 12 |  | 1 bar
 | Snack | Quark Jelly Mousse |  | 100.5 | 36.5 | 0 |  | 3 bowls
 | Snack | McCoys Crisps |  | 25.5 | 3.3 | 14.7 |  | 1 bag
 | Lunch | [NAME] with Mayo |  | 27 | 40 | 14 |  | 1 can of each
 | Veg | Can of Sweetcorn |  | 19.5 | 4 | 2.8 |  | 1 sml can
 | Veg | Avocado |  | 11.8 | 2.7 | 21 |  | 1 medium
 | Veg | Cauliflower |  | 7 | 3 | 0 |  | 1.5 cup
 | Dinner | [NAME] |  | 66 | 14 | 4 |  | 1 pack
 | Lunch | POD Slow Burner Chicken Salad |  | 38.8 | 32.7 | 16.2 |  | 1 pack
 | Lunch | POD Thai Red Chicken Curry |  | 72.9 | 39.3 | 25.1 |  | 1 large pack
 | Snack | POD Berry Boost Yoghurt |  | 32.2 | 16.1 | 10.5 |  | 1 pot
 | Lunch | EAT Spicy [NAME] |  | 57.8 | 28.6 | 9.4 |  | 1 pot
 | Breakfast | EAT Porridge with [NAME] |  | 35.2 | 8.3 | 2.1 |  | 1 small pot
 | Lunch | Pilpel Felafel Container (no pitta extra fel) |  |  |  |  |  | 1 container
 | Lunch | PRET Macaroni Cheese - Kale & Cauli |  | 43.8 | 23.2 | 23.5 |  | 1 container
 | Dinner | Beef Fillet Steak |  | 0 | 43.4 | 5 |  | 100g steak
 | Dinner | [NAME] |  | 0 | 48.7 | 24 |  | 250g steak
 | Veg | Sauerkraut |  | 6.1 | 1.3 | 0.2 |  | 1 cup
 | Veg | New Potato |  | 15.4 | 1.4 | 0.3 |  | 100g
 | Alcohol | Gin & Slimline |  |  |  |  |  | 1 dble
 | Veg | Carrots |  | 12.3 | 1.2 | 0.3 |  | 1 cup
Spreadsheet: 655682d1577647473-count-data-sort-issue4
Sheet: Sheet3

PO |  | CLG |  | IBTA |  | CD |  | PL |  | OTHERS |  | SB |  | MTDR |  | SCHEME |  | LOAN
C | D | CR | DR | CR | DR | CR | DR | CR | DR | CR | DR | CR | DR | CR | DR | CR | DR | CR | DR
Spreadsheet: 786813d1657464282-sum-values-with-multiple-columns-book1_pivot
Sheet: Sheet1

 |  |  |  | TABLE 1 |  |  |  |  |  |  |  |  |  |  |  | TABLE 2
 |  |  | Column1 | PO1 | PO12 | PO2 | PO3 | PO4 | PO43 | PO5 | PO6 | PO7 | PO8 |  |  | PO1 | PO2 | PO3 | PO4 | PO5 | PO6 | PO7 | PO8
 |  |  | Name A | 7 | 12 | 2 | 0 | 1 | 2 | 0 | 5 | 3 | 0 |  | Name A
 |  |  | Name B | 12 | 19 | 4 | 4 | 4 | 2 | 1 | 4 | 3 | 7 |  | Name B
 |  |  | Name C | 11 | 22 | 4 | 3 | 3 | 4 | 0 | 3 | 0 | 2 |  | Name C
 |  |  | Name D | 7 | 21 | 0 | 5 | 3 | 1 | 1 | 4 | 1 | 6 |  | Name D
 |  |  | Name E | 0 | 3 | 6 | 7 | 2 | 2 | 2 | 1 | 4 | 5 |  | Name E
 |  |  | Name F | 13 | 4 | 0 | 7 | 3 | 0 | 3 | 1 | 2 | 7 |  | Name F
 |  |  | Name G | 3 | 3 | 2 | 0 | 4 | 2 | 1 | 1 | 2 | 1 |  | Name G
 |  |  | Name H | 9 | 28 | 6 | 2 | 2 | 0 | 2 | 3 | 2 | 3 |  | Name H
 |  |  | Name I | 11 | 30 | 9 | 5 | 2 | 5 | 3 | 5 | 3 | 6 |  | Name I
 |  |  | Name J | 11 | 12 | 10 | 4 | 1 | 2 | 1 | 1 | 2 | 10 |  | Name J
 |  |  | Name K | 2 | 12 | 0 | 3 | 1 | 3 | 3 | 2 | 5 | 9 |  | Name K
 |  |  | Name L | 4 | 3 | 9 | 0 | 0 | 4 | 1 | 1 | 4 | 6 |  | Name L
 |  |  | Name M | 0 | 3 | 2 | 0 | 2 | 5 | 0 | 5 | 3 | 8 |  | Name M
 |  |  | Name N | 2 | 3 | 6 | 3 | 4 | 4 | 0 | 5 | 0 | 2 |  | Name N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1. I have a data namely Table 1. In the Table 1 consists of Names (A-N) & POs (1 to 8).
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2. My problem is I want to sum the values according to each PO as you can see in the Table 2.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3. I tried to use filter and sum functions. However, it adds up all the values in column PO1.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4. Example: Other POs are no issue, and the problem is Name A supposedly get values of 19 (7+12) for PO1 and 3 (1+2) for [NAME].
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5. I hope anyone experts here can help me to solve this problem. I appreciate any help you can provide. Thank you!
Spreadsheet: 854c0ebb-321f-41a7-98e7-61ca0759e203
Sheet: Sheet1

GENERAL | 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
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
Brief Title |  |  | Approval Deadline |  | Reason
 | EDI Activities-Grant Funded |  |  |  | Appropriating $1,807,661 for EDI Activities
Details |  |  |  |  | Positions/Recommendations
 | Reason for Legislation |  |  |  | Sponsor |  | [NAME], Budget Officer
 |  |  |  |  | Programs,
 |  |  |  |  | Departments, | City Planning and Development
 |  |  |  |  | or Groups
 |  |  |  |  | Affected
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  | X |  | For
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or
 |  |  |  |  | Commission |  | By
 |  |  |  |  | Recommendation
 |  |  |  |  |  |  |  |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 |  |  |  |  | Committee Actions |  |  |  | Do pass
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on reverse side)
Details |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  | X |  | No |  |  |  | Yes
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections --
 |  |  |  |  | Including Indirect
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact
 |  |  |  |  | Fund Source (s)
 |  |  |  |  | and Appropriation
 |  |  |  |  | Account Codes
Applicable Dates:
Reviewed by:
Reference Numbers
Spreadsheet: 0585a2f1-ae70-457c-a0cf-98155c404af7
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 6. COMMERCIAL FINANCE COMMITMENTS, By Purpose (Fixed Loans): Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Construction finance ; |  |  | Original | A2413488R | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Purchase of real property ; |  |  | Original | A2413489T | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Wholesale finance ; |  |  | Original | A2413490A | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Purchase of plant and equipment ; |  |  | Original | A2413491C | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Refinancing ; |  |  | Original | A2413492F | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Other ; |  |  | Original | A2413493J | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Original | A2413494K | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Commitments not drawn at end of month ; |  |  | Original | A2413495L | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012