tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: daren_farmer__5744__HPLN0227
Sheet: Sheet1

HPLN0227.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - February 27, 2001
 |  |  |  |  |  | **Tuesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-02-27 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
Enron (S) |  | Oasis Sealy |  | Enron | 10 | 0
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 855636d1705146831-count-continuous-occurences-restart-counting-when-condition-met-exclude-conditions-met-excelforum_count_contious_and_skipped-copy
Sheet: Sheet1

Values | In Column A, count "A" from last "C" occurence downwards. Cells with B should be skipped in the counting) | In Column A, count "C" from last "A" occurence downwards. Cells with B should be skipped in the counting)
C
A
A
A
B
B
A
C
C
B
B
C
A
A
A
B
A
A |  |  |  | 2
B |  |  |  | 3
A
B
C
C
C
A
C
C
B
C
C
C
B
A
A
A
 | New rows will be added downwards every day.
Spreadsheet: 38281d1236375264-conditional-formula-for-unique-issues-issues-list
Sheet: data

 |  | Issue Topic | School | Start Date | End Date | Length
 |  | Fire | Boronia | 2009-01-01 00:00:00 | 2009-01-06 00:00:00 | 5
 |  | Fire | Boronia | 2009-01-01 00:00:00 | 2009-01-08 00:00:00 | 7
 |  | water | Boronia | 2009-02-02 00:00:00 | 2009-07-02 00:00:00 | 150
 |  | water | [NAME] | 2009-03-02 00:00:00 | 2009-03-05 00:00:00 | 3
Spreadsheet: 681318d1591474028-sorting-missing-data-example-2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Observed |  |  | Forecast
 |  |  |  |  | Time: | Temp Calculation |  |  |  |  | Time | Temp |  | Time | Temp
 | Should be False. Difference of greater than 2 |  |  |  | 07:56:00 |  |  |  |  |  | 10:56:00 | 22 |  | 07:56:00 | 17
 | Should be False. Difference of greater than 2 |  |  |  | 08:56:00 |  |  | Missing 9:56 Time Slot ---> |  |  | 2020-03-05 08:56:00 | 20.28 |  | 08:56:00 | 17
 | Should be blank as no data with 9:56 time stamp is available |  |  |  | 09:56:00 |  |  |  |  |  | 07:56:00 | 21 |  | 09:56:00 | 20
 | Should be True. Difference of less than or equal to  2 |  |  |  | 10:56:00 |  |  |  |  |  | 2020-03-05 11:56:00 | 21.72 |  | 10:56:00 | 20
 | Should be True. Difference of less than or equal to  3 |  |  |  | 11:56:00 |  |  |  |  |  |  |  |  | 11:56:00 | 20
Spreadsheet: 715991d1611949256-need-help-removing-weekends-in-gantt-chart-status-bars-3-weeks-master-rev-1
Sheet: GanttChart

JOB #
 | Project Start Date | 2021-02-01 00:00:00 |  |  | Display Week | 1
 | Project Lead
 | ACTIVITY | [NAME] | START | END | DAYS | % DONE | WORK DAYS
 | [Task Category]
 | SRTIP NEW WASTE AREA | SITE 4 | 2021-02-01 00:00:00 |  | 12 | 0
 |  |  | 2021-02-02 00:00:00 |  | 5 | 0
 |  |  | 2021-02-03 00:00:00 |  | 4 | 0
 |  |  | 2021-02-04 00:00:00 |  | 4 | 0
 |  |  | 2021-02-05 00:00:00 |  | 2 | 0
 |  |  | 2021-02-06 00:00:00 |  | 3 | 0
 |  |  | 2021-02-07 00:00:00 |  | 5 | 0
 |  |  | 2021-02-08 00:00:00 |  | 7 | 0
 |  |  | 2021-02-09 00:00:00 |  | 7 | 0
 | EMPLOYEE |  | 2021-02-10 00:00:00
 |  |  | 2021-02-11 00:00:00 |  | 4 | 0
 |  |  | 2021-02-12 00:00:00 |  | 3 | 0
 |  |  | 2021-02-13 00:00:00 |  | 3 | 0
 |  |  | 2018-02-17 00:00:00 |  | 6 | 0
 |  |  | 2018-02-23 00:00:00 |  | 3 | 0
 | EQUIPMENT
 |  |  | 2018-02-10 00:00:00 |  | 4 | 0
 |  |  | 2018-02-14 00:00:00 |  | 3 | 0
 |  |  | 2018-02-14 00:00:00 |  | 3 | 0
 |  |  | 2018-02-17 00:00:00 |  | 6 | 0
 |  |  | 2018-02-23 00:00:00 |  | 3 | 0
Spreadsheet: darrell_schoolcraft__7762__imbalsumm0106
Sheet: PGETX

 |  |  |  |  | 12283
 | [NAME] |  | Pecos Del |  | Gunpoint #2
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 122911 | 120605 | 50961 | 53638
2 | 145284 | 108474 | 50999 | 88318
3 | 146493 | 108474 | 50983 | 88239
4 | 151669 | 118425 | 44619 | 78318
5 | 117062 | 79555 | 1308 | 38315
6 | 148786 | 84605 | 9713 | 73318
7 | 122811 | 114605 | 30005 | 38318
8 | 133311 | 105004 | 12000 | 40816
9 | 142548 | 132998 | 38291 | 48318
10 | 141287 | 132998 | 40004 | 48318
11 | 129455 | 118196 | 37928 | 48177
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 |  |  |  | 2001-05-31 00:00:00 |  |  | 237513.04
 |  |  |  | 2001-06-11 00:00:00
Spreadsheet: 841612d1693803797-displays-months-in-chronological-order-pivot-table
Sheet: Pivot Table

Row Labels | Sum of Sales
April 2013 | 192920 |  |  | 171668
April 2014 | 231504 |  | February 2013 | 165964.75
December 2013 | 103775 |  | March 2013 | 125317.5
December 2014 | 124530 |  | April 2013 | 192920
February 2013 | 165964.75 |  | May 2013 | 129070
February 2014 | 177690 |  | November 2013 | 119947.5
January 2013 | 171668 |  | December 2013 | 103775
January 2014 | 170834 |  | January 2014 | 170834
March 2013 | 125317.5 |  | February 2014 | 177690
March 2014 | 150381 |  | March 2014 | 150381
May 2013 | 129070 |  | April 2014 | 231504
May 2014 | 154884 |  | May 2014 | 154884
November 2013 | 119947.5 |  | November 2014 | 128863
November 2014 | 128863 |  | December 2014 | 124530
Grand Total | 2147348.75 |  | Grand Total | 2147348.75
Spreadsheet: 834080d1687436163-conditional-format-row-based-on-multiple-criteria-example
Sheet: Sheet1

45 | 28.8 | 0.5 | 2 | 5 | 1.2 | 13.1 | 14
46 | 28.8 | 0.5 | 2 | 5 | 1.2 | 13.2 | 14.1
45 | 29 | 0.6 | 2 | 5 | 1.2 | 13.3 | 14.2
45 | 29 | 0.6 | 2 | 5 | 1.2 | 13.4 | 14.2
51 | 29 | 0.6 | 2 | 5 | 1.1 | 13.3 | 14.1
51 | 28.9 | 0.6 | 2 | 5 | 1.1 | 13.3 | 14.1
51 | 28.9 | 0.6 | 3 | 4 | 1.2 | 13.2 | 14.1
51 | 28.8 | 0.6 | 3 | 4 | 1.2 | 13.2 | 14
51 | 28.8 | 0.6 | 2 | 4 | 1.1 | 13.1 | 14
Spreadsheet: 115847d1311333955-pull-data-from-one-sheet-to-another-using-multiple-criteria-book1
Sheet: b

 |  | Mr A |  |  | Mr B |  |  | Mr C |  |  | Mr D
 |  | Product | Cost |  | Product | Cost |  | Product | Cost |  | Product | Cost
 |  | Chicken | 57 |  | Paint | 23 |  | Smokes | 36 |  | Meat | 44
 |  | Meat | 65 |  | Paint | 53 |  | Smokes | 23 |  | Bread | 43
 |  | Meat | 42 |  | Meat | 22 |  |  |  |  | Bread | 23
 |  | Cake | 21 |  | Bread | 21 |  |  |  |  | Meat | 35
 |  | Meat | 52
 |  |  | NOTE: Products that have a cost value >20 then list
Spreadsheet: 709920d1608627323-counting-instances-of-not-blank-and-adjacent-cells-sample-of-absence-sheet
Sheet: Sheet1

 |  | Hidden |  |  | 2020-12-14 00:00:00 | 2020-12-15 00:00:00 | 2020-12-16 00:00:00 | 2020-12-17 00:00:00 | 2020-12-18 00:00:00 | 2020-12-19 00:00:00 | 2020-12-20 00:00:00 | 2020-12-21 00:00:00 | 2020-12-22 00:00:00 | 2020-12-23 00:00:00 | 2020-12-24 00:00:00 | 2020-12-25 00:00:00 | 2020-12-26 00:00:00 | 2020-12-27 00:00:00 | 2020-12-28 00:00:00 | 2020-12-29 00:00:00 | 2020-12-30 00:00:00 | 2020-12-31 00:00:00
Person | Taken |  | Bradford | Spells
Quality Manager |  |  |  | 3 | 1 |  | 1 | 1 |  | 1
Maintenance
Maintenance
Operator
[NAME]
Operator
Operator
Sales Director
Team Leader
Front End Engineer
Operator
Operator
Accounts
Accounts
Operator
Goods-in
Production Manager
Operator
Engineering & Sales  Manager
Spreadsheet: 781615d1653445472-how-to-input-the-vacation-list-into-the-employee-calendar-a
Sheet: expected result

 | Date of the month
 | 1 | 2 | 3 | 4 | 5 | 6 | 7
Aby
Nani
[NAME]
Hogie
Spreadsheet: 195572d1353560499-how-to-lookup-a-table-in-sheet1-if-the-cell-is-color-then-color-the-matchin-cell-in-sheet2-query3-vlookup-colors
Sheet: Sheet2

code | description | Date of price | Purchase QTY | final price
1224 | Crunchie | 2012-10-21 00:00:00 | 10 | 1.74
1225 | Skittles | 2012-10-21 00:00:00 | 20 | 1.9
1228 | Bounty | 2012-10-21 00:00:00 | 70 | 1.9
1229 | [NAME] | 2012-10-21 00:00:00 | 50 | 1.98
1227 | M&Ms | 2012-10-21 00:00:00 | 80 | 1.98
1223 | Timeout | 2012-10-21 00:00:00 | 40 | 2.06
1274 | Malteses | 2012-10-21 00:00:00 | 60 | 2.06
1275 | Flake | 2012-10-21 00:00:00 | 50 | 2.15
1276 | Milky Bar | 2012-10-21 00:00:00 | 20 | 2.15
1278 | Aero | 2012-10-21 00:00:00 | 30 | 2.28
1279 | [NAME] | 2012-10-21 00:00:00 | 50 | 2.28
Spreadsheet: 27251d1220381869-attendance-database-employee-attendance-test
Sheet: 2008

employee attendance
 | Total of | Since | Conseq. Of | Date of |  | 2008-09-08 00:00:00 |  |  |  | 2008-08-08 00:00:00 |  |  |  | 2008-07-08 00:00:00 |  |  |  | 2008-06-08 00:00:00 |  |  |  | 2008-05-08 00:00:00 |  |  |  | 2008-04-08 00:00:00 |  |  |  | 2008-03-08 00:00:00 |  |  |  | 2008-02-08 00:00:00 |  |  |  | 2008-01-08 00:00:00
1st Shift | Last 90 Days | Counseling | Counseling | Counseling | Absences | Lates | Incomp. | Total | Absences | Lates | Incomp. | Total | Absences | Lates | Incomp. | Total | Absences | Lates | Incomp. | Total | Absences | Lates | Incomp. | Total | Absences | Lates | Incomp. | Total | Absences | Lates | Incomp. | Total | Absences | Lates | Incomp. | Total | Absences | Lates | Incomp. | Total |  |  |  | Yearly Total and June/June total
[NAME] | 9 |  |  |  | 1 | 1 | 0 | 2 | 2 | 1 | 0 | 3 | 2 | 1 | 0 | 3 | 2 | 1 | 0 | 3 | 2 | 1 | 0 | 3 | 2 | 1 | 0 | 3 | 2 | 1 | 0 | 3 | 2 | 1 | 0 | 3 | 2 | 1 | 0 | 3 |  |  |  | add sum
[NAME] |  |  |  |  | 2 | 5 | 1 | 2 | 2 | 0 | 1 | 2 | 3 | 5
[NAME] |  |  |  |  | 2 | 5 | 1 | 2 | 2 | 0 | 1 | 2 | 3 | 5
[NAME] |  |  |  |  | 2 | 5 | 1 | 2 | 2 | 0 | 1 | 2 | 3 | 5
[NAME] |  |  |  |  | 2 | 5 | 1 | 2 | 2 | 0 | 1 | 2 | 3 | 5
[NAME] Monday |  |  |  |  | 2 | 5 | 1 | 2 | 2 | 0 | 1 | 2 | 3 | 5
[NAME] |  |  |  |  | 2 | 5 | 1 | 2 | 2 | 0 | 1 | 2 | 3 | 5
[NAME] |  |  |  |  | 2 | 5 | 1 | 2 | 2 | 0 | 1 | 2 | 3 | 5
[NAME] |  |  |  |  | 2 | 5 | 1 | 2 | 2 | 0 | 1 | 2 | 3 | 5
2nd Shift
3rd Shift
Spreadsheet: 804029d1667850430-formula-help-if-value-falls-within-range-two-columns-then-return-third-value-variable-payout-calculator-
Sheet: Sheet1

Name | Name
Title | Title
Annual Variable | 12000
Quarterly Variable
NRR Goal | 1.09
% of Variable | 0.5
Starting Book of Business | [NAME] | Churn | Current NRR | % to Goal |  | % to Goal |  | Payout %
100000 | 5100 | 10954 |  |  |  | Min | [NAME]
 |  |  |  |  |  | 1.51 |  | 3
 |  |  |  |  |  | 1.26 | 1.5 | 2
Payout % | Payout Amount |  |  |  |  | 1.15 | 1.25 | 1.75
 |  |  |  |  |  | 1.06 | 1.15 | 1.5
 |  |  |  |  |  | 1.01 | 1.05 | 1.2
 |  |  |  |  |  | 1 | 1 | 1
 |  |  |  |  |  | 0.9 | 0.99 | 0.85
 |  |  |  |  |  | 0.75 | 0.89 | 0.5
 |  |  |  |  |  | 0.5 | 0.74 | 0.25
 |  |  |  |  |  |  | 0.5 | 0
Spreadsheet: 842951d1694943950-automatically-updates-score-sheet-live-check
Sheet: RESULTS

MELBOURNE RESULTS
 |  | 1st | 2nd | 3rd
RACE | 1 | 5 | 1 | 10 |  |  |  | Winner Results here
RACE |  | 9 | 1 | 6 |  |  |  | Rank | Name | Pnts
RACE |  | 7 | 5 | 2 |  |  |  | 1
RACE |  | 5 | 4 | 7 |  |  |  | 2
RACE |  | 1 | 9 | 3 |  |  |  | 3
RACE |  | 5 | 8 | 4 |  |  |  | 4
RACE |  | 1 | 3 | 4 |  |  |  | 5
RACE |  | 2 | 3 | 1
RACE |  | 5 | 6 | 7
RACE |  | 1 | 2 | 3
SYDNEY  RESULTS
 |  | 1st | 2nd | 3rd
RACE | 1
RACE
RACE
RACE
RACE
RACE
RACE
RACE
RACE
RACE
Spreadsheet: 778508d1651131486-how-to-find-cell-address-of-numeric-value-in-range-w-multiple-rows-and-columns-book1
Sheet: Sheet1

 | Jan | Feb | Mar | Apr
1 | 1.6 | 1.8 | 2.6 | 0.8
2 | 0.5 | 1.1 | 2.8 | 2.6
3 | 0.2 | 2.6 | 2.1 | 1.1
4 | 1.8 | 3.3 | 2.7 | 1.7
5 | 1.3 | 0.3 | 3.3 | 1.1
6 | 2.5 | 0 | 4 | 2.7
7 | 1.7 | 1.6 | 1.2 | 1.8
8 | 2.8 | 2.8 | 2.2 | 1.6
Spreadsheet: 134dcf53-8804-44a2-a109-ae0c0d10eea5
Sheet: Sheet1

Table 8--U.S. cotton textile imports, by origin | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 |  | 2011 |  |  | 2010
Region/country | May | June | July |  | July
 | 1,000 pounds 1/
North America | 158950.801 | 171389.012 | 166966.222 |  | 172211.244
Canada | 3648.712 | 3553.386 | 3194.423 |  | 3138.185
Costa Rica | 806.958 | 882.679 | 777.706 |  | 1032.508
Dominican Republic | 6478.658 | 7048.558 | 6642.281 |  | 7299.463
El Salvador | 22791.941 | 24358.775 | 25121.599 |  | 27541.662
Guatemala | 9802.291 | 10230.955 | 8642.464 |  | 9386.745
Haiti | 12677.971 | 14663.311 | 14082.48 |  | 11805.655
Honduras | 37997.98 | 39334.909 | 37812.432 |  | 38787.12
Mexico | 48434.518 | 53797.57 | 51720.179 |  | 58094.432
Nicaragua | 16279.461 | 17492.167 | 18969.797 |  | 15117.062
South America | 5341.602 | 5633.155 | 5089.393 |  | 10727.003
Brazil | 356.008 | 246.192 | 276.741 |  | 3843.956
Colombia | 1788.138 | 2229.208 | 2060.448 |  | 2969.214
Peru | 3012.721 | 2995.296 | 2636.912 |  | 3643.215
Europe | 10526.086 | 11581.27 | 13617.659 |  | 14162.866
Germany | 1033.906 | 1030.112 | 915.262 |  | 918.094
Italy | 1857.298 | 1603.81 | 1842.353 |  | 1766.955
Portugal | 897.157 | 1394.369 | 2186.348 |  | 1925.652
Turkey | 4012.667 | 4212.453 | 4633.771 |  | 4425.107
Asia | 530394.911 | 572165.299 | 600376.058 |  | 717997.391
Bahrain | 1654.092 | 1544.671 | 1544.172 |  | 2328.879
Bangladesh | 50129.996 | 46774.605 | 44194.544 |  | 48907.255
Cambodia | 18936.514 | 19120.984 | 22214.304 |  | 25636.571
China | 222996.58 | 263020.962 | 287335.306 |  | 352155.686
Hong Kong | 902.562 | 794.462 | 1250.322 |  | 1525.285
India | 60097.813 | 57945.407 | 57792.411 |  | 64250.56
Indonesia | 27338.45 | 28184.579 | 31107.676 |  | 34466.618
Israel | 1238.394 | 1340.734 | 1338.525 |  | 1734.567
Japan | 1209.872 | 1214.615 | 1199.417 |  | 1161.193
Jordan | 3190.084 | 4490.465 | 4596.611 |  | 6381.542
Malaysia | 2419.606 | 2676.23 | 2989.22 |  | 3393
Pakistan | 68178.897 | 73062.489 | 71424.965 |  | 83795.792
Philippines | 6145.838 | 6622.136 | 6431.729 |  | 6909.424
South Korea | 5985.92 | 7164.938 | 5205.051 |  | 8097.741
Sri Lanka | 6927.824 | 5447.049 | 6702.538 |  | 8496.073
Taiwan | 2632.186 | 3037.765 | 2396.376 |  | 3297.958
Thailand | 8080.559 | 8309.487 | 9342.517 |  | 11989.189
Vietnam | 40605.859 | 39802.555 | 41731.238 |  | 51333.402
Oceania | 50.213 | 51.832 | 81.069 |  | 71.597
Africa | 17576.08 | 19097.877 | 18124.64 |  | 24910.582
Egypt | 9946.855 | 11061.213 | 9270.427 |  | 11446.547
Kenya | 2635.57 | 2318.28 | 2282.252 |  | 3354.154
[NAME] | 2984.967 | 2793.999 | 3973.007 |  | 6350.229
[NAME] | 863.683 | 778.288 | 1063.427 |  | 1165.11
World 2/ | 726141.357 | 779919.519 | 804256.219 |  | 940081.352
 |  |  |  |  |  |  |  | 95
1/ Raw-fiber equivalent.  2/ Totals may not add due to rounding.
Last update:  10/13/11.
Sources: USDA, Economic Research Service; and USDC,
U.S. Census Bureau.
Spreadsheet: 887585d1737825155-generating-1-column-of-data-into-a-calendar-reviews-calendar-test_3
Sheet: Feb

 |  |  | 2025-01-27 00:00:00 | 2025-01-28 00:00:00 | 2025-01-29 00:00:00 | 2025-01-30 00:00:00 | 2025-01-31 00:00:00 | 2025-02-01 00:00:00
 |  |  | 2025-02-03 00:00:00 | 2025-02-04 00:00:00 | 2025-02-05 00:00:00 | 2025-02-06 00:00:00 | 2025-02-07 00:00:00 | 2025-02-08 00:00:00
 |  |  | 2025-02-10 00:00:00 | 2025-02-11 00:00:00 | 2025-02-12 00:00:00 | 2025-02-13 00:00:00 | 2025-02-14 00:00:00 | 2025-02-15 00:00:00
 |  |  |  |  |  |  |  |  |  | ``
 |  |  | 2025-02-17 00:00:00 | 2025-02-18 00:00:00 | 2025-02-19 00:00:00 | 2025-02-20 00:00:00 | 2025-02-21 00:00:00 | 2025-02-22 00:00:00
 |  |  | 2025-02-24 00:00:00 | 2025-02-25 00:00:00 | 2025-02-26 00:00:00 | 2025-02-27 00:00:00 | 2025-02-28 00:00:00 | 2025-03-01 00:00:00
 |  |  | 2025-03-03 00:00:00 | Notes
Spreadsheet: 156287d1337254533-building-multiple-charts-in-one-file-new-wt-and-cg-chart
Sheet: 2X HF - NO SAR

WEIGHT AND [NAME]BLOCK 1 AIRCRAFT
70116 2X HF - NO SAR
DATE | CG | ACFT WT | NOSE WT | TEETER ANGLE (INCHES) | SAR System | Small KU ANT. | Large KU ANT. | EO/IR System | WING PYLONS | HEA | OTHER | BALLAST STATION & AMOUNT |  |  |  |  |  |  | COMMENTS | Completed By | AMR Reference number | Employee #
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
Spreadsheet: 61313d1262131205-excel-2007-conditional-formatting-where-a-value-of-b-is-entered-conditional-formatting
Sheet: Sheet2

 |  |  |  |  | 25569
Spreadsheet: 72584d1273261724-printing-a-specific-area-in-a-form-while-keeping-its-position-sample
Sheet: Sheet1

SAMPLE
DATE | ITEMS BOUGHT | AMOUNT
2010-02-02 00:00:00 | Oranges | 25 | Printed first entries on 2 Feb. No problem here
2010-02-02 00:00:00 | Apples | 12
2010-02-02 00:00:00 | Bananas | 8
2010-02-03 00:00:00 | Watermelon | 3 | Want to print just these 2 additional lines on the same paper on its correct position
2010-02-03 00:00:00 | Oranges | 6
Spreadsheet: 104652d1302177527-sumproduct-formula-help-copy-of-sample_nw
Sheet: Comparison

Emp No | Department | Qualification | Grade | Basic
198
 | Maximum:
 | Minimum:
 |  |  |  |  |  | Graduate | Master | Secondary | PhD
 |  |  |  |  |  | BBA | MBA | Diploma
 |  |  |  |  |  | Graduate | MA | IBS Diploma
 |  |  |  |  |  | BS Economics | Chartered Accountant | University Student
 |  |  |  |  |  | BS Accounting | High Education | S.S.C.
 |  |  |  |  |  | B.Com | Master | Secondary
 |  |  |  |  |  | University Degree |  | Commercial Institute
Spreadsheet: 56559d1256740662-copy-cell-reference-from-seperate-sheet-to-increment-correctly-copy-of-book3-2-
Sheet: Sheet2

org | jan | feb | [NAME] | apr | may | jun
a | 4 | 6 | 2 | 9 | 8 | 6
b | 5 | 8 | 1 | 1 | 7 | 2
c | 5 | 8 | 2 | 6 | 1 | 9
d | 3 | 9 | 2 | 6 | 3 | 2
Spreadsheet: 27274d1220430142-extracting-non-duplicate-alphanumeric-data-from-two-columns-kbath
Sheet: Sheet1

A | D | A
B | E | B
C | G | C
D | H
E | K
F |  | F
G
H
I |  | I
J |  | J
K
L |  | L
Spreadsheet: 783195d1654653188-special-transposing-phonebook-to-sim-format-book2
Sheet: Sheet2 (2)

[NAME] (LMF) | NUMBER | [NAME] (FML) |  | 3 | 1 | 1 | 1
SMITHJ/P | +[PHONE] | JSMITH/P |  |  | 2 | 3 | 1
SMITHJ | [PHONE] | JSMITH |  |  | 2 | 3 | 2
SMITHJ/A | 28 | JSMITH/A |  |  | 2 | 3 | 3
MacGilleFhJP/W | 6284567890 | JPMacGilleFh/W |  |  | 3 | 3 | 1
MacGilleFhaoJP | 12 | JPMacGilleFhao |  |  | 3 | 3 | 2
MacGilleFJP/Xz | +[PHONE] | JPMacGilleF/Xz |  |  | 3 | 3 | 3
[NAME] length 14 characters (Truncate last name)
 | Retain only "+", remove all other than numbers
Spreadsheet: 715049d1611519957-google-sheets-drop-down-menu-price-totals-menu-test
Sheet: PLATES AND PRICE

Plate | Price
Ceviche de Corvina - 8 oz | 4
Ceviche de Corvina - 16 oz | 8
Ceviche de Corvina - 24 oz | 11
Ceviche de Camaron - 8 oz | 6
Ceviche de Camaron - 16 oz | 11
Ceviche de Camaron - 24 oz | 16
Ceviche de Pulpo - 8 oz | 6
Ceviche de Pulpo - 16 oz | 11
Ceviche de Pulpo - 24 oz | 16
Ceviche de Combinacion - 8 oz | 6.5
Ceviche de Combinacion - 16 oz | 12
Ceviche de Combinacion - 24 oz | 17
El Yeye Ceviche de Corvina Gourmet - 8 oz | 7
El Yeye Ceviche de Corvina Gourmet - 16 oz | 13
El Yeye Ceviche de Corvina Gourmet - 24 oz | 20
El Salsoso Ceviche de Corvina Gourmet - 8 oz | 7
El Salsoso Ceviche de Corvina Gourmet - 16 oz | 13
El Salsoso Ceviche de Corvina Gourmet - 24 oz | 20
Almejas - 1 Orden | 6
Camarones a la Chava's | 7
Cambombia | 7
Langostinos a la Chava's | 9
Filete de Pescado Apanado | 7
Filete de Pescado al Escabeche | 7
Spreadsheet: 786294d1657100721-link-cells-across-worksheets-stock-take-excel-query
Sheet: Sheet2

Factory Location | Shelf Location | Substance | Price
Middle | M01 | [NAME]
Middle | M06 | Alumon AC70
Middle | End | Ammonia 910
LAB | LAB | Ammonium Hydrosulphide
Back | B08 | Anodal EE Liquid
Back | B06 | [NAME]
Back | B07 | [NAME]
Middle | B16A | Aqualor BL
Middle | M14 | AT Chrom A
Middle | M14 | AT Chrom B
Back | M01 | Black Magic Steel
Lab and Store | Lab | Black Spray Paint
Middle | B02 | Canphos 401
Back | B02 | Caustic Soda Pearl
Middle | [NAME] | Decon 90
YARD | YARD | [NAME]
Back | Middle | Deoxidine 125
Middle | T09 | [NAME]
Back | M03 | Dye Black Sanodal
LAB | LAB | Dye Blue Sanodal
Middle | T02 | [NAME]
Middle | [NAME] | [NAME] PLW
Middle | B15 | Ebonol C
Middle | End | [NAME]
Middle | B05 | Envirozin 120 Rack Brightener
Middle | B06 | Envirozin Base Additive
Middle | B07 | Envirozin Conditioner
Middle | End | Envirozin Purifier
YARD | YARD | Hydrochloric Acid
Spreadsheet: 248d2e4d-27d9-41d6-962d-8437c0e046cf
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2013-10-02 09:36:15.100000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.625 | 101.995 | 101.87 | 101.745 | 101.37
4.5 | 101.655 | 101.53 | 101.405 | 101.03 |  | Note: | Refer To Price [NAME]
4.375 | 100.825 | 100.7 | 100.575 | 100.2 |  |  | For all Price Adjs
4.25 | 100.315 | 100.19 | 100.065 | 99.44
4.125 | 99.573 | 99.448 | 99.323 | 98.698
4 | 98.654 | 98.529 | 98.404 | 97.779
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 102.125 | 102 | 101.875 | 101.5
3.75 | 102.02 | 101.895 | 101.77 | 101.395
3.625 | 101.66 | 101.535 | 101.41 | 101.035
3.5 | 101.123 | 100.998 | 100.873 | 100.498
3.375 | 100.421 | 100.296 | 100.171 | 99.546
3.25 | 99.678 | 99.553 | 99.428 | 98.803
3.125 | 98.919 | 98.794 | 98.669 | 98.044 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2013-10-16 09:36:15.100000
30 DAY | 2013-10-31 09:36:15.100000
45 DAY | 2013-11-15 09:36:15.100000
60 DAY | 2013-11-30 09:36:15.100000
90 DAY | 2013-12-30 09:36:15.100000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 759160d1639385847-nested-if-statements-and-their-sums-sumproduct-example-2-aligw
Sheet: Sheet1

Products | Cost | fees | Revenue
A | 7.9424 | 5.928 | 15.2
B | 3.13 | 3.8682 | 6.89
C | 3.84 | 4.239599999999999 | 8.82
D | 5.27 | 3.6702 | 9.99
E | 7.8 | 6.282 | 15.5
F | 6.2 | 7.458 | 13.7
G | 4.62 | 4.461 | 9.25
H | 3.47 | 4.7766 | 9.87
I | 6.720000000000001 | 2.94 | 11
J | 8.86 | 5.970000000000001 | 16.5
K | 20.54 | 9.0042 | 34.49
L | 9.540000000000001 | 5.5044 | 15.98
M | 7.56 | 5.091 | 13.55
N | 14.61 | 7.114199999999999 | 23.99
O | 4.62 | 4.9542 | 11.99
P | 12.47 | 6.8502 | 21.39
Q | 5.75 | 4.686 | 10.5
R | 7.069999999999999 | 5.046 | 12.5
G | 5.7 | 4.686 | 10.5
H | 4.05 | 4.326000000000001 | 8.5
I | 5.7 | 4.686 | 10.5
J | 5.7 | 4.686 | 10.5
K | 5.58 | 5.1342 | 12.99
L | 6.600000000000001 | 6.192 | 15