tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 100301d1298669021-pivot-table-average-question-test
Sheet: Sales By List

 | Average Sale by List
 | Row Labels | Capture Date | Sum of Sales
 | esp2 | 2011-02-18 00:00:00 | 33
 |  | 2011-02-19 00:00:00 | 36
 | esp2 Total |  | 69
 | Nov10 | 2011-02-18 00:00:00 | 21
 |  | 2011-02-19 00:00:00 | 12
 | Nov10 Total |  | 33
 | ESP1 | 2011-02-18 00:00:00 | 20
 |  | 2011-02-19 00:00:00 | 12
 | ESP1 Total |  | 32
 | sep10 | 2011-02-18 00:00:00 | 12
 |  | 2011-02-19 00:00:00 | 9
 | sep10 Total |  | 21
 | oct10 | 2011-02-18 00:00:00 | 9
 |  | 2011-02-19 00:00:00 | 10
 | oct10 Total |  | 19
 | [NAME] | 2011-02-18 00:00:00 | 9
 |  | 2011-02-19 00:00:00 | 6
 | jan09 Total |  | 15
 | oct08 | 2011-02-18 00:00:00 | 5
 |  | 2011-02-19 00:00:00 | 10
 | oct08 Total |  | 15
 | mar10hld | 2011-02-18 00:00:00 | 5
 |  | 2011-02-19 00:00:00 | 9
 | mar10hld Total |  | 14
 | [NAME] | 2011-02-18 00:00:00 | 8
 |  | 2011-02-19 00:00:00 | 4
 | nov08 Total |  | 12
 | apr09 | 2011-02-19 00:00:00 | 12
 | apr09 Total |  | 12
 | [NAME] | 2011-02-18 00:00:00 | 6
 |  | 2011-02-19 00:00:00 | 5
 | [NAME] |  | 11
 | [NAME] | 2011-02-18 00:00:00 | 5
 |  | 2011-02-19 00:00:00 | 6
 | jul10 Total |  | 11
 | aug10 | 2011-02-18 00:00:00 | 3
 |  | 2011-02-19 00:00:00 | 6
 | aug10 Total |  | 9
 | feb09 | 2011-02-18 00:00:00 | 6
 |  | 2011-02-19 00:00:00 | 3
 | feb09 Total |  | 9
 | mar09 | 2011-02-18 00:00:00 | 4
 |  | 2011-02-19 00:00:00 | 5
 | mar09 Total |  | 9
 | apr10 | 2011-02-18 00:00:00 | 1
 |  | 2011-02-19 00:00:00 | 7
 | apr10 Total |  | 8
 | may10hld | 2011-02-18 00:00:00 | 6
 |  | 2011-02-19 00:00:00 | 1
 | may10hld Total |  | 7
 | nov09 | 2011-02-18 00:00:00 | 4
 |  | 2011-02-19 00:00:00 | 3
 | nov09 Total |  | 7
 | feb10 | 2011-02-18 00:00:00 | 3
 |  | 2011-02-19 00:00:00 | 3
 | feb10 Total |  | 6
 | jun09 | 2011-02-18 00:00:00 | 1
 |  | 2011-02-19 00:00:00 | 5
 | jun09 Total |  | 6
 | sep09 | 2011-02-18 00:00:00 | 1
 |  | 2011-02-19 00:00:00 | 5
 | sep09 Total |  | 6
 | may10 | 2011-02-18 00:00:00 | 3
 |  | 2011-02-19 00:00:00 | 3
 | may10 Total |  | 6
 | [NAME] | 2011-02-18 00:00:00 | 3
 |  | 2011-02-19 00:00:00 | 3
 | jan10hld Total |  | 6
 | [NAME] | 2011-02-18 00:00:00 | 1
 |  | 2011-02-19 00:00:00 | 4
 | may09 Total |  | 5
 | apr09hld | 2011-02-18 00:00:00 | 2
 |  | 2011-02-19 00:00:00 | 3
 | apr09hld Total |  | 5
 | apr10hld | 2011-02-18 00:00:00 | 3
 |  | 2011-02-19 00:00:00 | 2
 | apr10hld Total |  | 5
 | dec09 | 2011-02-18 00:00:00 | 5
 | dec09 Total |  | 5
 | jul09 | 2011-02-18 00:00:00 | 1
 |  | 2011-02-19 00:00:00 | 3
 | jul09 Total |  | 4
 | [NAME] | 2011-02-18 00:00:00 | 1
 |  | 2011-02-19 00:00:00 | 3
 | feb10hld Total |  | 4
 | oct09hld | 2011-02-18 00:00:00 | 2
 |  | 2011-02-19 00:00:00 | 2
 | oct09hld Total |  | 4
 | jan10 | 2011-02-18 00:00:00 | 1
 |  | 2011-02-19 00:00:00 | 2
 | jan10 Total |  | 3
 | nov09hld | 2011-02-18 00:00:00 | 1
 |  | 2011-02-19 00:00:00 | 1
 | nov09hld Total |  | 2
 | oct09 | 2011-02-18 00:00:00 | 1
 |  | 2011-02-19 00:00:00 | 1
 | oct09 Total |  | 2
 | mar10 | 2011-02-18 00:00:00 | 2
 | mar10 Total |  | 2
 | SF | 2011-02-18 00:00:00 | 1
 | SF Total |  | 1
 | Grand Total |  | 385
Spreadsheet: 85844d1285868186-just-two-places-like-an-adding-machine-point-added
Sheet: Sheet1

 | 0.01 |  |  |  |  |  |  |  |  | 1234 |  |  |  | 12.34
 |  |  |  |  |  |  |  |  |  | 1235 |  |  |  | 12.35
 |  |  | Step One |  |  |  |  |  | StepTwo | 1236 |  | Results are without formulas |  | 12.36
 |  |  |  |  |  |  |  |  |  | 1237 |  |  |  | 12.37
 |  |  |  |  |  |  |  |  |  | 1238 |  |  |  | 12.38
 |  |  |  | Copy |  |  | Highlight and right click , Paste Special & Choose Multiply |  |  | 1239 |  |  |  | 12.39
 |  |  |  |  |  |  |  |  |  | 1240 |  |  |  | 12.4
 |  |  |  |  |  |  |  |  |  | 1241 |  |  |  | 12.41
 |  |  |  |  |  |  |  |  |  | 1242 |  |  |  | 12.42
 |  |  |  |  |  |  |  |  |  | 1243 |  |  |  | 12.43
 |  |  |  |  |  |  |  |  |  | 1244 |  |  |  | 12.44
 |  |  |  |  |  |  |  |  |  | 1245 |  |  |  | 12.45
 |  |  |  |  |  |  |  |  |  | 1246 |  |  |  | 12.46
 |  |  |  |  |  |  |  |  |  | 1247 |  |  |  | 12.47
 |  |  |  |  |  |  |  |  |  | 1248 |  |  |  | 12.48
 |  |  |  |  |  |  |  |  |  | 1249 |  |  |  | 12.49
 |  |  |  |  |  |  |  |  |  | 1250 |  |  |  | 12.5
 |  |  |  |  |  |  |  |  |  | 1251 |  |  |  | 12.51
 |  |  |  |  |  |  |  |  |  | 1252 |  |  |  | 12.52
 |  |  |  |  |  |  |  |  |  | 1253 |  |  |  | 12.53
 |  |  |  |  |  |  |  |  |  | 1254 |  |  |  | 12.54
 |  |  |  |  |  |  |  |  |  | 1255 |  |  |  | 12.55
Spreadsheet: 866250d1713207774-help-with-formulas-to-populate-a-calendar-kansas-scheduler-calendar-test-v1-2-
Sheet: ALL JOBS

 |  |  | DO NOT EDIT THIS SHEET- IT IS A REFERENCE SHEET!  DATA IS PULLED HERE FROM DIGITAL AND FABRIC TABS.
Press | SchedTime | Due Date | Job# | Line# | Master [NAME] | QTY | H | W | Material | Sides | PrintMode | Kitting | #OfKits | Notes | DateRecieved | SqFt | LinearFT
Spreadsheet: 192681d1352490001-match-function-help-matching-fix
Sheet: Sheet1

 |  | art | artist
 |  | lista | socialista
 |  | localizada | socialist
 |  | optimismo | optimism
 |  | coche | Color
 |  | [NAME] | pink
Spreadsheet: 744ab14f-9f43-4a27-b440-2df76678c576
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
8947 | 49246 | [NAME] | Solano | CRC | 25 | 00:16:12 | 00:01:38 | 00:44:24 | 00:00:34 | 00:21:39 | 1 | 01:24:26
8947 | 47864 | Selena | Vergara | GUA | 22 | 00:13:49 | 00:01:21 | 00:47:35 | [NAME] | 00:23:15 | 2 | 01:26:37
8947 | 57908 | [NAME] | [NAME] | GUA | 24 | 00:13:54 | 00:01:16 | 00:49:09 | 00:00:33 | 00:25:27 | 3 | 01:30:18
8947 | 68297 | Catalina | Barahona | CRC | 21 | 00:13:50 | 00:01:30 | 00:50:25 | 00:00:33 | 00:26:00 | 4 | 01:32:17
8947 | 69063 | Nicolle | Rodriguez | GUA | 27 | 00:13:50 | 00:01:22 | 00:53:11 | [NAME] | 00:28:24 | 5 | 01:37:23
Spreadsheet: 818672d1676993223-issue-with-date-extraction-from-other-column-date-test
Sheet: Sheet1

Confirmed  delivery date and time | confirmed delivery date
4/5/2022 3:00pm
21/4/2022 11:00am
21/4/2022 9:30am
19/4/2022 7:00pm
19/4/2022 3:00pm
7/4/2022 3:00pm
6/4/2022 1:00pm
6/4/2022 11:00am
6/4/2022 11:00am
6/4/2022 11:00am
5/4/2022 11:00am
4/4/2022 12:02pm
4/10/2022 11:00am
30/10/2022 3:00pm
Spreadsheet: c42d6e79-cb6d-4aa4-9e84-074db70dac1c
Sheet: Sheet1

Release: Construction Spending | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=229
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-03-16 9:55 PM [NAME]
 | Real-Time | Period
Name: | Start | End
Construction Spending | 2011-07-01 00:00:00 | Current
Link:
http://www.census.gov/construction/c30/c30index.html | 2011-07-01 00:00:00 | Current
Source:
U.S. Department of Commerce: Census Bureau | 2011-07-01 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-07-01 00:00:00
2011-08-01 00:00:00
2011-09-01 00:00:00
2011-10-03 00:00:00
2011-11-01 00:00:00
2011-12-01 00:00:00
2012-01-03 00:00:00
2012-02-01 00:00:00
2012-03-01 00:00:00
2012-04-02 00:00:00
2012-05-01 00:00:00
2012-06-01 00:00:00
2012-07-02 00:00:00
2012-08-01 00:00:00
2012-09-04 00:00:00
2012-10-01 00:00:00
2012-11-01 00:00:00
2012-12-03 00:00:00
2013-01-02 00:00:00
2013-02-01 00:00:00
2013-03-01 00:00:00
2013-04-01 00:00:00
2013-05-01 00:00:00
2013-06-03 00:00:00
2013-07-01 00:00:00
2013-08-01 00:00:00
2013-09-03 00:00:00
2013-10-22 00:00:00
2013-12-02 00:00:00
2014-01-02 00:00:00
2014-02-03 00:00:00
2014-03-03 00:00:00
Spreadsheet: 157013d1337597321-summarize-data-with-count-ifs-sumifs-or-similar-excelforum-example
Sheet: Sheet1

Data | Data |  |  |  |  |  | Working time |  | Temporary |  | Permanent |  | Certain time
Name | Country | Field | Worked hours | Hiring form |  | Field | Europé | S. America | Europé | S. America | Europé | S. America | Europé | S. America
[NAME] | Sweden | Sales | 100 | Temporary |  | Sales | ? | ? | ? | ? | ? | ? | ? | ?
[NAME] | Germany | Tech support | 100 | Permanent |  | Tech support | ? | ? | ? | ? | ? | ? | ? | ?
Anders | England | Marketing | 25 | Certain time |  | Marketing | ? | ? | ? | ? | ? | ? | ? | ?
Marcus | Brazil | HR | 100 | Certain time |  | HR | ? | ? | ? | ? | ? | ? | ? | ?
[NAME] | Argentina | Focus areas | 80 | [NAME] |  | Focus areas | ? | ? | ? | ? | ? | ? | ? | ?
Isac | Peru | Production | 100 | Certain time |  | Production | ? | ? | ? | ? | ? | ? | ? | ?
[NAME] | Kanada | Supply chain | 100 | Temporary |  | Supply chain | ? | ? | ? | ? | ? | ? | ? | ?
[NAME] | Sweden | Sales | 100 | Temporary
[NAME] | Germany | Sales | 100 | Permanent
Lewis | England | Marketing | 25 | Vikariat
[NAME] | Brazil | HR | 100 | Certain time
Fredric | Argentina | Focus areas | 80 | [NAME]
Billy | Peru | Focus areas | 100 | Certain time
[NAME] | Kanada | Supply chain | 100 | Permanent
Spreadsheet: 809314d1671025901-need-correct-formula-to-pull-specific-data-from-a-list-payees-mortage-amount-exp
Sheet: Sheet1

 | (Mortgage) , (Property) , (Equip. Maint.)      YEAR - |  | 2022
 | Choose Month Below | YEAR TO DATE  ----> |  |  | MORTGAGE PAYMENTS FOR THE YEAR
 |  | MONTHLY AVERAGE  ----> |  |  | CURRENT MORTAGE PAYMENT
 |  | CURRENT MONTH  ---->
 | 2022-02-01 00:00:00 | <--------Amount Spent During Selected Month-------->
 | DATE | Decription | AMOUNT
 | 2022-01-01 00:00:00 | Wells Fargo Mortage | 790.06
 | 2022-01-22 00:00:00 | Home Depot (New Freedom, PA) | 207.78
 | 2022-02-01 00:00:00 | Wells Fargo Mortage | 790.06
 | 2022-02-04 00:00:00 | Home Depot (Bel Air, MD) | 16.81
 | 2022-02-11 00:00:00 | Home Depot (New Freedom, PA) | 81.67
 | 2022-02-25 00:00:00 | Home Depot (New Freedom, PA) | 15.88
 | 2022-03-01 00:00:00 | Wells Fargo Mortage | 790.06
 | 2022-03-03 00:00:00 | Home Depot (Bel Air, MD) | 76.26
 | 2022-03-07 00:00:00 | Home Depot (Internet Purchase, GAUS) | 9.52
 | 2022-03-09 00:00:00 | Home Depot (Internet Purchase, GAUS) | 7.15
 | 2022-03-09 00:00:00 | Home Depot (Internet Purchase, GAUS) | 25.41
 | 2022-03-10 00:00:00 | Home Depot (Internet Purchase, GAUS) | 8.4
 | 2022-03-21 00:00:00 | Home Depot (New Freedom, PA) | 51.77
 | 2022-03-22 00:00:00 | Home Depot (Bel Air, MD) | 39.99
 | 2022-03-23 00:00:00 | Home Depot (Bel Air, MD) | 90.01
 | 2022-03-24 00:00:00 | Home Depot (Internet Purchase, GAUS) | 75.43
 | 2022-03-27 00:00:00 | Home Depot (New Freedom, PA) | 12.47
 | 2022-03-27 00:00:00 | Home Depot (Internet Purchase, GAUS) | 31.74
 | 2022-04-01 00:00:00 | Wells Fargo Mortage | 790.06
 | 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
 | 2022-07-01 00:00:00
 | 2022-08-01 00:00:00
 | 2022-09-01 00:00:00
 | 2022-10-01 00:00:00
 | 2022-11-01 00:00:00
 | 2022-12-01 00:00:00
Spreadsheet: 761212d1640723251-need-formula-to-output-multiple-data-in-one-cell-from-workbook-copy-of-2022-reston-team-vacation-calendar
Sheet: July

 |  | 2022-06-27 00:00:00 | 2022-06-28 00:00:00 | 2022-06-29 00:00:00 | 2022-06-30 00:00:00 | 2022-07-01 00:00:00 | 2022-07-02 00:00:00
 |  | 2022-07-04 00:00:00 | 2022-07-05 00:00:00 | 2022-07-06 00:00:00 | 2022-07-07 00:00:00 | 2022-07-08 00:00:00 | 2022-07-09 00:00:00
 |  | Independence Day  Office Closed
 |  | 2022-07-11 00:00:00 | 2022-07-12 00:00:00 | 2022-07-13 00:00:00 | 2022-07-14 00:00:00 | 2022-07-15 00:00:00 | 2022-07-16 00:00:00
 |  | 2022-07-18 00:00:00 | 2022-07-19 00:00:00 | 2022-07-20 00:00:00 | 2022-07-21 00:00:00 | 2022-07-22 00:00:00 | 2022-07-23 00:00:00
 |  | 2022-07-25 00:00:00 | 2022-07-26 00:00:00 | 2022-07-27 00:00:00 | 2022-07-28 00:00:00 | 2022-07-29 00:00:00 | 2022-07-30 00:00:00
 |  | 2022-08-01 00:00:00 | Notes
Spreadsheet: 160170d1338996591-finding-rows-that-contain-a-data-string-across-mutiple-columns-example
Sheet: Sheet1

Column reference | email 1 | email 2 | email 3 | etc | email 256
1 | a@b | [NAME] | d@e |  | 6@f
2 | g@f | h@t | b@s |  | [NAME]
3 | a@c | c@w | r@h |  | s@k
etc
6500
Spreadsheet: 828441d1683491053-problem-with-countif-formula-sample
Sheet: Final_Results

Given the option, which language would you feel most comfortable being trained in? | Column1 | Are you familiar with what Information Management is? | Column2 | In your opinion who is responsible for Information Management? | Column3
English |  | Yes |  | HoM/ HoD
French |  | Somewhat |  | ICT Department
Arabic |  | No |  | Information Management team
Spanish |  |  |  | All staff members
Other |  |  |  | Other
Spreadsheet: scott_neal__37948__STOR9822
Sheet: STOR951

ENRON CAPITAL & TRADE RESOURCES |  |  |  |  |  |  |  |  |  |  |  |  |  | Confidential - For Internal Use Only
STORAGE UPDATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | File: STOR9822
Below is a summary of the estimated storage working gas levels
for the week ending: |  |  | 2001-03-09 00:00:00
 |  | Gas In Stg | Gas in | Quantity | Percent | Percent |  |  |  |  | Last Year | Three | Five | Quantity | Quantity | Quantity
 |  | Prev Week | Storage | Change | Change | of Full |  |  |  |  | Same | Year | Year | Change From | Change From | Change From
U.S. Region |  | (Bcf) | (Bcf) | from last week | from last week | Capacity |  |  |  |  | Week | Average | Average | last year | 3 year avg. | 5 year avg.
Production Area |  | 236 | 225
(TX, LA, OK, KS, MS)
Market Area - East |  | 402 | 341
Market Area - West |  | 148 | 145
TOTAL U.S.
MONTH TO DATE
Enron Gas Services |  |  | 36.2 | 0 | 0 | 0.924 |  |  |  |  | ECTR is refilling [NAME] as third parties
(as of 1/20/95) |  |  |  |  |  |  |  |  |  |  |  |  |  | are withdrawing, this keeping our
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total position flat for the week.
AGA FULL CAPACITY |  |  | 3294 |  |  |  |  |  |  |  |  |  |  | 3294 | 3294 | 3294
Maximum Gas In Stg Level (Bcf) |  |  | 3127 |  |  |  |  |  |  |  |  |  |  | 3127 | 2832 | 2915
Minimum Gas In Stg Level (Bcf) |  |  | 831 |  |  |  |  |  |  |  |  |  |  | 1006 | 794 | 871
Spreadsheet: 787412d1657789975-formula-to-create-dates-series-with-x-number-of-days-gaps-including-working-days-only-day-series-with-intervals
Sheet: Sheet1

 |  |  |  | Expected Results
 |  |  |  | June 1 Day Gap | June 2 Day Gap | June 3 Day Gap | June 4 Day Gap | June 5 Day Gap | June 6 Day Gap
 |  |  | 2022-06-01 00:00:00
Spreadsheet: 99611d1298229408-solved-true-false-conditions-and-numbers-to-grab-stuck-20-20copy-1-
Sheet: Sheet1

price | bid
95 | False
99 | False
99.97 | False
99.98 | False
99.99 | False |  |  |  | Min sell
100 | False
100 | False
103.77 | False |  |  |  | [NAME] buy
103.78 | False
103.79 | False
104.66 | False
106.97 | False
106.98 | False
106.99 | False
107 | False
107 | False
109.99 | False
110 | False
110.99 | False
111.96 | False
111.97 | False
113 | False
113.99 | False
114.98 | False
115 | False
118.99 | False
119 | False
119 | False
119 | False
119.79 | False
119.99 | False
120 | False
120 | False
120 | False
120 | False
120 | False
120.97 | False
122.87 | False
128.93 | False
129.99 | False
130 | False
130 | False
130.77 | False
130.78 | False
130.79 | False
132.93 | False
132.99 | False
135 | False
140 | False
145.33 | False
148.79 | False
149 | False
150 | False
165 | False
190 | False
199.93 | False
199.99 | False
200 | False
200 | False
895 | False
8500 | False
88000 | False
90.06 | True
90.05 | True
90.03 | True
90.01 | True
82.77 | True
82.55 | True
81.88 | True
81.76 | True
81.73 | True
77.18 | True
76.99 | True
76.93 | True
70 | True
63.03 | True
63.02 | True
63.01 | True
62.99 | True
59.75 | True
59.74 | True
59.73 | True
59.67 | True
55.55 | True
9.59 | True
Spreadsheet: 125853d1319288503-compute-weekly-values-from-the-monthly-data-sales-monitoring_sample
Sheet: JulySales

 | Daily Total | Day | Date | Sale_Emp1 | Sale_Emp2 |  |  | Week number | Emp1 | Emp2
September |  |  |  |  |  |  |  | Week 1 = first Monday up to Saturday of the month, then week 2 = 2nd Monday up to 2nd Saturday, then so on.  Can I dynamically get the dates of the first week based on the given Day/Date values in column C and D? Since days are not constant (e.g  this year Sep1 is Thursday but next year it's Saturday). | Once I've already determined the dates of the first week, I would like to get the total number of sale for each week (from Monday to Saturday) | Once I've already determined the dates of the first week, I would like to get the total number of sale for each week (from Monday to Saturday)
 |  |  | 2011-09-01 00:00:00 | 215 | 216 |  | Week1 =
 |  |  | 2011-09-02 00:00:00 | 181 | 187 |  | Week2 =
 |  |  | 2011-09-03 00:00:00 | 171 | 127 |  | Week3 =
 |  |  | 2011-09-05 00:00:00 | 124 | 145 |  | Week4 =
 |  |  | 2011-09-06 00:00:00 | 190 | 220 |  | Week5 =
 |  |  | 2011-09-07 00:00:00 | 201 | 237 |  | Week6 =
 |  |  | 2011-09-08 00:00:00 | 200 | 165 |  | Weekn =
 |  |  | 2011-09-09 00:00:00 | 206 | 160
 |  |  | 2011-09-10 00:00:00 | 196 | 227
 |  |  | 2011-09-12 00:00:00 | 191 | 220
 |  |  | 2011-09-13 00:00:00 | 191 | 173
 |  |  | 2011-09-14 00:00:00 | 190 | 272
 |  |  | 2011-09-15 00:00:00 | 201 | 222
 |  |  | 2011-09-16 00:00:00 | 215 | 167
 |  |  | 2011-09-17 00:00:00 | 190 | 188
 |  |  | 2011-09-19 00:00:00 | 176 | 155
 |  |  | 2011-09-20 00:00:00 | 193 | 258
 |  |  | 2011-09-21 00:00:00 | 201 | 217
 |  |  | 2011-09-22 00:00:00 | 202 | 222
 |  |  | 2011-09-23 00:00:00 | 210 | 193
 |  |  | 2011-09-24 00:00:00 | 192 | 236
 |  |  | 2011-09-26 00:00:00 | 168 | 184
 |  |  | 2011-09-27 00:00:00 | 178 | 215
 |  |  | 2011-09-28 00:00:00 | 170 | 157
 |  |  | 2011-09-29 00:00:00 | 193 | 223
 |  |  | 2011-09-30 00:00:00 | 209 | 219
October |  |  | 2011-10-01 00:00:00 | 222 | 184
 |  |  | 2011-10-03 00:00:00 | 196 | 161
 |  |  | 2011-10-04 00:00:00 | 174 | 219
 |  |  | 2011-10-05 00:00:00 | 221 | 249
 |  |  | 2011-10-06 00:00:00 | 210 | 227
 |  |  | 2011-10-07 00:00:00 | 195 | 197
 |  |  | 2011-10-08 00:00:00 | 178 | 237
 |  |  | 2011-10-10 00:00:00 | 201 | 180
 |  |  | 2011-10-11 00:00:00 | 218 | 227
 |  |  | 2011-10-12 00:00:00 | 213 | 291
 |  |  | 2011-10-13 00:00:00 | 211 | 218
 |  |  | 2011-10-14 00:00:00 | 203 | 163
 |  |  | 2011-10-15 00:00:00 | 178 | 197
 |  |  | 2011-10-17 00:00:00 | 222 | 238
 |  |  | 2011-10-18 00:00:00 | 233 | 228
 |  |  | 2011-10-19 00:00:00 | 224 | 222
 |  |  | 2011-10-20 00:00:00 | 221 | 241
 |  |  | 2011-10-21 00:00:00 | 217 | 221
 |  |  | 2011-10-22 00:00:00 | 193 | 156
 |  |  | 2011-10-24 00:00:00 | 208 | 217
 |  |  | 2011-10-25 00:00:00 | 201 | 202
 |  |  | 2011-10-26 00:00:00 | 230 | 200
 |  |  | 2011-10-27 00:00:00 | 79 | 82
 |  |  | 2011-10-28 00:00:00 | 238 | 189
 |  |  | 2011-10-29 00:00:00 | 227 | 214
 |  |  | 2011-10-31 00:00:00 | 202 | 179
Spreadsheet: 59481d1259968635-count-the-number-of-values-between-two-numbers-how-to-let-excel-count-the-number-of-values-with-aavaluesetween-two-numbers
Sheet: Sheet1

2,26 | 1,50 | 1,75 | 4 | 0
1,88 | 1,75 | 2,00 | 13
1,97 | 2,00 | 2,25 | 4
1,80 | 2,25 | 2,50 | 1
2,04 | 2,50 | 2,75 | 0
1,85 | 2,75 | 3,00 | 0
1,95 | 3,00 | 3,25 | 0
1,75 | 3,25 | 3,50 | 0
1,84 | 3,50 | 3,75 | 0
2,03 | 3,75 | 4,00 | 0
1,73 | 4,00 | 4,25 | 0
2,22
1,75
1,87
2,01
1,88
1,73
1,86
1,77
1,89
Spreadsheet: 707326d1607181055-some-sort-of-if-roundup-formula-required-book1
Sheet: Sheet1

0.14 | 0.48 | 0 | 0
0.03 | 0.14 | 0.24 | 0.35
0.08 | 0.29 | 0.37 | 0.55
0.04 | 0.19 | 0.4 | 0.51
0.02 | 0.13 | 0.36 | 0.45
0.06 | 0.22 | 0.23 | 0.4
0.04 | 0.17 | 0.27 | 0.4
0.05 | 0.22 | 0.42 | 0.55
0.08 | 0.31 | 0.38 | 0.58
0.08 | 0.29 | 0.37 | 0.55
0.13 | 0.47 | 0 | 0
0.07 | 0.28 | 0 | 0
0.03 | 0.12 | 0.21 | 0.31
0.02 | 0.14 | 0.37 | 0.46
0.04 | 0.18 | 0.32 | 0.44
0.05 | 0.19 | 0.29 | 0.42
0.05 | 0.19 | 0.3 | 0.44
0.01 | 0.06 | 0.25 | 0.3
0.03 | 0.12 | 0.2 | 0.29
0.09 | 0.32 | 0 | 0
0.07 | 0.26 | 0.33 | 0.51
0.02 | 0.09 | 0.18 | 0.25
0.04 | 0.21 | 0.46 | 0.58
0.03 | 0.13 | 0.23 | 0.33
0.01 | 0.04 | 0.19 | 0.22
0.07 | 0.27 | 0 | 0
Spreadsheet: 880972d1728874382-extract-a-string-starts-with-amb-from-a-cell-rawdataexcel01
Sheet: Sheet1

Raw Data | Expected Results to extract Asset name/tag AMB99999999xx or AMB99999999 | Formula from JohnToply
all macro disable Application Name:  Asset Name: AMB00299999BR  [NAME]'s LAN ID: 10099999A | AMB00299999BR
APEX TABLET TURN TO OLD VERSION. Dashvision eSignature : V1.2.0 Kindly assist. Last week already updatedto the latest version, but this week don't know why, go back to the old version. IP Address : 12.384.3.43 Application Name: AmBanCS Asset Name:  [NAME]'s LAN ID: 10018557A | NIL
no internet/urgent Application Name:  Asset Name: AMB00122323HR  Requester's LAN ID: Abbdfdfd | AMB00122323HR
PC cannot on. Application Name: Desktop - Applications-parent Asset Name: AMB00232323HW  Requester's LAN ID: 10040594B | AMB00232323HW
Unable to login Citrix Application Name:  Asset Name: AMB00434234HS  [NAME]'s LAN ID: dfdsfdfsdf | AMB00434234HS
1. [NAME]2. Please use MST chat to arrange time Thanks. Application Name:  Asset Name: AMB08329230HW  [NAME]'s LAN ID: 1dsffsfsf | AMB08329230HW
AmBancs unable to log in msg : YOU MAY LOGIN TO AMBANCS FROM MICROSOFT INTERNET EXPLORER OR FIREFOX Application Name: AmBanCS Asset Name: AMB00384930HS  Requester's LAN ID: sdfsfsfd | [NAME]
system inaccessible ambancs  Application Name: AmBanCS Asset Name: Others [NAME]'s LAN ID: ddfdfsdfA | NIL
Hardware faulty AMB00275837 [NAME] 10041567 Application Name:  Asset Name: AMB00382039HS  [NAME]'s LAN ID: dfsdfdsY | AMB00275837 AMB00275837HS
UNABLE TO ACCESS USING VPN VIA LAPTOP. LAPTOP IP ADDRESS:  USER NAME: GRPUSR\ 93939403A LAPTOP TAG: AMB00820238  request for [NAME].  Application Name:  Asset Name: AMB00268778BR  Requester's LAN ID: 93939403A | AMB00820238 AMB00268778BR
Submitting this request for my colleague as she is unable to connect to the internet and she is currently at Menara AmBank Application Name:  Asset Name: AMB00239943HS  Requester's LAN ID: 393949394 | AMB00239943HS
Unable to connect to LAN network after back from annual leave. LAN ID:10033366A ([NAME]). Asset no: AmB00394304. SN:ldeorpeo. IP:11.788.55.43 Application Name:  Asset Name:  [NAME]'s LAN ID: 109393039 | AmB00394304
Spreadsheet: 275471d1383530304-nested-if-statements-are-returning-false-values-cannot-find-error-in-code-fairbank-roster-summary-page
Sheet: Packaging

Fairbank |  |  | ROSTER | Packaging |  |  |  |  |  |  |  | WEEK ENDING:
 |  |  | MONDAY |  | 2013-11-04 00:00:00 | TUESDAY |  | 2013-11-05 00:00:00 | WEDNESDAY |  | 2013-11-06 00:00:00 | THURSDAY |  | 2013-11-07 00:00:00 | FRIDAY |  | 2013-11-08 00:00:00 | SATURDAY |  | 2013-11-09 00:00:00 | SUNDAY |  | 2013-11-10 00:00:00
 |  | ROLE | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS
SUPERVISORS |  | Packaging - Afternoon
 |  | Packaging - Day
 |  |  | MONDAY |  |  | TUESDAY |  |  | WEDNESDAY |  |  | THURSDAY |  |  | FRIDAY |  |  | SATURDAY |  |  | SUNDAY
 |  | ROLE | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME |  | NAME | TIME |  | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS
MORNING SHIFT | Non-Skilled |  | [NAME] | 9am | 8 | [NAME] | 6am | 8 | [NAME] | 6am | 8 | [NAME] | 6am | 8 | [NAME] | 6am | 8 | [NAME] | 6am | 8 | [NAME] | 6am | 8
 | Skilled |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  | MONDAY |  |  | TUESDAY |  |  | WEDNESDAY |  |  | THURSDAY |  |  | FRIDAY |  |  | SATURDAY |  |  | SUNDAY
 |  |  | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME |  | NAME | TIME |  | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS
AFTERNOON SHIFT | Non-Skilled
 | Skilled