tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 878796d1726068250-add-price-ranges-to-a-working-index-match-formula-add-price-ranges-to-a-working-index-match-formula
Sheet: Sheet1

Item | Maj | Cat | Price | Code | IF using price too |  |  |  |  | Maj | Cat | Price | Code
0243 | ACC | 110 | 81 |  |  |  | A |  |  | ACC | 110 | 0 | A |  | <100
0097 | ACC | 110 | 150 | Should return B |  |  | A |  |  | ACC | 110 | 100 | B |  | 100-199.99
3318 | ACC | 110 | 84 |  |  |  | A |  |  | ACC | 110 | 200 | C |  | 200+
4481 | ACC | 110 | 225 | Should return C |  |  | A |  |  | ARMS | 110 | 0 | A
3149 | ACC | 110 | 230 | Should return C |  |  | A |  |  | ARMS | 110 | 60 | E |  | 60-99.99
4477 | ACC | 110 | 235 | Should return C |  |  | A |  |  | ARMS | 110 | 100 | H |  | 100+
9387 | ACC | 110 | 99 |  |  |  | A |  |  | ARMS | 130 | 0 | A
5816 | ACC | 110 | 115 | Should return B |  |  | A |  |  | ARRO | 110 | 0 | D
6702 | ARMS | 110 | 42 |  |  |  | A |  |  | ARRO | 140 | 0 | J
6669 | ARMS | 130 | 127 |  |  |  | A |  |  | ATLA | 110 | 0 | E
6668 | ARMS | 110 | 65 | Should return E |  |  | A |  |  | ATLA | 130 | 0 | F
6662 | ARMS | 110 | 115 | Should return H |  |  | A
6716 | ARMS | 110 | 131 | Should return H |  |  | A
S261 | ARRO | 110 | 66 |  |  |  | D
S244 | ARRO | 110 | 75 |  |  |  | D
S257 | ARRO | 140 | 83 |  |  |  | J
0090 | ATLA | 110 | 49 |  |  |  | E
0070 | ATLA | 130 | 44 |  |  |  | F
Spreadsheet: 674345d1587768897-matrix-of-ifs-to-generate-a-set-of-characters-and-finally-join-these-characters-multiple-ifs-bittubadri-
Sheet: Sheet1

 |  | 33 |  | i | i h h |  | i
 |  | 55 |  |  |  |  | i
 |  |  |  |  |  |  | i
 |  |  |  |  |  |  | i
 |  |  |  |  |  |  | i
 |  |  |  |  |  |  | i
 |  |  |  |  |  |  | i
 |  |  |  |  |  |  | i
 |  |  |  |  |  |  | i
 |  |  |  |  |  |  | i
 |  |  |  |  |  |  | i
 |  |  |  |  |  |  | i
 |  |  |  |  |  |  | i
 |  | 11 |  | h |  |  | i h
 |  | 55 |  |  |  |  | i h
 |  | 22 |  | h |  |  | i h h
Spreadsheet: benjamin_rogers__1327__site_visit_schedule_112100
Sheet: Schedule

E2 Site Visit Schedule
 |  |  | Brownsville                ([NAME]) | [NAME](Mitch) | New Albany
Week 1 | 2000-11-27 00:00:00 | Mon
 | 2000-11-28 00:00:00 | [NAME]. | Cinergy
 |  |  | Morning
 | 2000-11-29 00:00:00 | Wed. |  | Cinergy
 |  |  |  | 10:00:00
 | 2000-11-30 00:00:00 | Thurs.
 | 2000-12-01 00:00:00 | Fri.
Week 2 | 2000-12-04 00:00:00 | Mon
 | 2000-12-05 00:00:00 | Tue
 | 2000-12-06 00:00:00 | Wed
 | 2000-12-07 00:00:00 | Thur
 | 2000-12-08 00:00:00 | Fri
Spreadsheet: 884437d1733574921-budget-adjustment-as-per-target-values-budgetadjustment-jt-
Sheet: Sheet1

CURRENT SITUATION |  |  |  | Max of Column B&C + Column D |  | REQUIRED VALUES
GROUP | PO_VALUE | ACTUALS | ETC | EAC |  | PO_VALUE | ACTUALS | ETC | EAC |  | CHECK
A | 100 | 0 | 200 |  |  | 100 | 0 | 200
B | 200 | 0 | 200 |  |  | 200 | 0 | 100
C | 0 | 100 | 0 |  |  | 0 | 100 | 0
D | 100 | 200 | 0 |  |  | 100 | 200 | 0
A | 500 | 200 | 0 |  |  | 500 | 200 | 0
B | 0 | 400 | 100 |  |  | 0 | 400 | 0
C | 200 | 0 | 100 |  |  | 200 | 0 | 0
D | 0 | 100 | 0 |  |  | 0 | 100 | 0
A | 0 | 0 | 1000 |  |  | 0 | 0 | 800
B | 500 | 200 | 0 |  |  | 500 | 200 | 0
C | 100 | 200 | 0 |  |  | 100 | 200 | 0
D | 500 | 200 | 1000 |  |  | 500 | 200 | 200
 |  |  |  | Current Total |  |  | Target |  | Current Total | DELTA |  | Required Adjustment
A |  |  |  |  |  |  | 1600
B |  |  |  |  |  |  | 1200
C |  |  |  |  |  |  | 500
D |  |  |  |  |  |  | 1000
Total
 |  |  |  |  |  | I need a formula in Column I (ETC) as highlighted to meet the target value by Group
 |  |  |  |  |  | PO_Value and Actuals should not be changed
 |  |  |  |  |  | EAC value should be greater than or equal to maximum of PO_Value or Actuals
Spreadsheet: 880434d1728164557-index-match-needs-one-more-qualifier-test-sheet
Sheet: Inv Batch

Invoice Number | [NAME] | Provider Address | Provider Phone Number | Patient Name | Patient Address | City | State | Zip | Patient Account Number | Service Date(s) | Description of Services | Insurance Company | Insurance Billed Amount | Insurance Paid Amount | Patient Paid Amount | Total Paid Amount | Total Amount Due | Due Date
Spreadsheet: sara_shackleton__36425__bondsettchsbony
Sheet: Sheet1

 | BONY | Chase
Cost: | $5,000 @ month?? | $5,000 @ month??
Advantages: | Good software, Enron internally controls directly via interface to BONY system | Financial Trading has an existing relationship with Chase
 | No counter party trading activity with BONY
 | Active participant in this business (translate to better service?)
Disadvantages: | No daylight overdraft: we need to prefund until other side settles | We do a lot of our  trading activity is with Chase so they may see our deals/margin
RE:  Fixed Income Clearance Account
Profile:
Three principal currencies: USD, CAD and GBP (would anticipate [NAME], as well)
Products: Bonds (governments and agencies)
Normal Activity:
Repo Settlement clearance account between counterparties
Estimate 5-10 transactions a month
Average size 10-25 Million, could go to $100 million
DVP delivery
May have fails or small delivery differences
May have a custodial position for 2-3 days
Hold cash in account of residual P&L or wire back if significant
Questions:
Advance notice for settlement instructions required? Domestic? Foreign?
Intraday draft facility or we cover
Systems and daily information access
Spreadsheet: 872023d1718376359-issue-with-finding-distinct-values-book1
Sheet: Sheet1

1600000183427254
1600000183427254
1600000183427254
1600000183427254
1600000183427251
1600000183427251
1600000183427251
1600000183427251
1600000183427251
Spreadsheet: 98319d1297271960-possible-concatenate-cell-combine-error-test
Sheet: Sheet1

 |  |  |  | Sequence | Line No. | Text | Combined text
 |  |  |  | 9876543 | 1 | The cat | *The cat sat on the mat*
 |  |  |  | 9876543 | 2 | sat on
 |  |  |  | 9876543 | 3 | the mat
 |  |  |  | 1254567 | 1 | Romeo Romeo | *Romeo Romeo where for art thou Romeo*
 |  |  |  | 1254567 | 2 | where for
 |  |  |  | 1254567 | 3 | art
 |  |  |  | 1254567 | 4 | thou Romeo
 |  |  |  | *What I'm trying to achieve*
Spreadsheet: mary_fischer__25606__31Z
Sheet: E8.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  031Z
COMPANY NAME    LINC
ANALYSIS OF OTHER DEFERRED CHARGES
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | 12-31-2000 Balance |  |  |  | Charged to |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash Pd / (Rec'd) |  | Income Statement |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Work in Progress:
 |  | 0
Total  (Hyperion Line 0343)
Asset/Expense Accts:  DR/(CR)
Other Deferred Charges:
 |  | 0
Total (Hyperion line 360)
Asset/Expense Accts:  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 756405d1637518719-index-match-all-associations-formula-help-test-3_3
Sheet: Sheet1

 |  |  |  |  |  |  |  | Results | Wanted End Results |  | Account | Member#
 |  |  | ACCOUNT |  | MEMBER |  |  |  | 2021004440 |  | 2021004444 | 74498756
 |  |  | 1999002222 |  | 45678901 |  |  |  | 2020003333
 |  |  | 2021004440 |  | 74498756 |  |  |  | 2017006978
 |  |  | 2003003212 |  | 23441166 |  |  |  | 2021009999
 |  |  | 2020003333 |  | 74498756
 |  |  | 1899002345 |  | 33679999
 |  |  | 2017006978 |  | 74498756
 |  |  | 2021004444 |  | 74498756
 |  |  | 1975003434 |  | 21212121
 |  |  | 2021009999 |  | 74498756
Spreadsheet: 1cbc590b-9668-48ff-b6cd-bc96662464a2
Sheet: Sheet1

Table 2--Feed and residual use of wheat and coarse grains, 4/11/2014 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Market year and quarter 1/ |  | Corn  (million metric tons) | Sorghum  (million metric tons) | Barley  (million metric tons) | Oats  (million metric tons) | Feed grains  (million metric tons) | Wheat  (million metric tons) | Energy feeds  (million metric tons) | Grain consuming animal units  (millions) | Energy feeds per grain consuming animal unit  (tons)
2011/12 | Q1 Sep-Nov | 46.3887777587269 | 1.125526280695738 | -0.04739860166504735 | 0.3396545983846662 | 47.80656003614225 | -0.459970008464036 | 47.34659002767822
 | [NAME] | 39.20255535869642 | 0.1432626545503038 | 0.2699564823357473 | 0.2214356928307892 | 39.83721018841326 | 1.183849204081244 | 41.0210593924945
 | [NAME] | 21.80958005499356 | 0.3902129253903844 | 0.02769454355440525 | 0.2170485461906848 | 22.44453607012903 | -1.919213361746368 | 20.52532270838266
 | [NAME] | 8.343220742603496 | 0.1344738463101611 | 0.9843320079360544 | 0.7427577153815939 | 10.2047843122313 | 11.60236993008325 | 21.80715424231456
 | MY Sep-Aug | 115.7441339150204 | 1.793475706946588 | 1.23458443216116 | 1.520896552787734 | 120.2930906069159 | 10.40703576395409 | 130.7001263708699 | 92.80323220002037 | 1.408357481441699
2012/13 | Q1 Sep-Nov | 52.88868567944982 | 2.003289452795082 | 0.06856141324907399 | 0.372022959037876 | 55.33255950453185 | -0.8694007408072677 | 54.46315876372459
 | [NAME] | 27.41521403669201 | 0.1169470321896452 | 0.2062503231846548 | 0.3402923494367742 | 28.07870374150308 | 0.2600990101704511 | 28.33880275167353
 | [NAME] | 23.42514589802697 | 0.4197036952366438 | 0.032244983493769 | 0.222580560295597 | 24.09967513705298 | -0.4221403941355933 | 23.67753474291738
 | [NAME] | 6.32913578835737 | -0.1759031707022791 | 1.28289747630206 | 0.605769152262837 | 8.041899246219987 | 11.22404657124895 | 19.26594581746894
 | MY Sep-Aug | 110.0581814025262 | 2.364037009519092 | 1.589954196229558 | 1.540665021033084 | 115.5528376293079 | 10.19260444647654 | 125.7454420757844 | 91.77923220666668 | 1.3700860102276
2013/14 | Q1 Sep-Nov | 61.1 | 2.6 | -0.2 | 0.4 | 63.9 | -4.8 | 59.1
 | [NAME] | 36.9 | 0.1 | 0.2 | 0.3 | 37.5 | 0.1 | 37.6
 | MY Sep-Aug | 134.6 | 2.8 | 0.9 | 1.7 | 140 | 1 | 141.1 | 90.8 | 1.6
1/ Corn and sorghum, September 1-August 31 marketing year; Barley and oats, June 1-May 31 marketing year. Source: USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates and supporting materials.
Data run: 4/10/2014
Spreadsheet: 472635d1469690743-count-of-employees-absent-on-a-particular-date-employee-attendance-tracker1
Sheet: Calendar View

 | EMPLOYEE ATTENDANCE RECORD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Select an Employee: |  |  |  |  |  |  |  |  | Employee 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Select a Year: |  |  |  |  |  |  |  |  | 2012
 |  |  |  |  |  |  | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S
 |  | KEY STATISTICS
 |  |  | Days on Leave |  |  |  |  |  |  |  | Working Days |  |  |  |  |  |  |  | # of Days Sick |  |  |  |  |  |  | on Vacation |  |  |  |  |  |  |  | on Bereavement |  |  |  |  |  |  |  |  | on Other
Spreadsheet: 489315d1479209270-excel-report-from-multiple-excel-files-qrn-275-and-276
Sheet: Connector Elements

Identifiers | Wavelength (nm) | Element 1 |  |  |  |  |  | Element 5
 |  | Connector (A) |  |  |  |  |  | Connector (B)
 |  | -0.0023 (km) |  |  |  |  |  | 2.9675 (km)
 |  | Loss (dB) |  |  | Refl (dB) |  |  | Loss (dB) |  |  | Refl (dB)
 |  | A->B | B->A | [NAME]. | A->B | B->A | Worst | A->B | B->A | [NAME]. | A->B | B->A | Worst
QRN FC 12; 275 | 1310 | 0.238 | 0.092 | 0.165 | -69.2 | --- | -69.2 | -0.13 | 0.162 | 0.016 | --- | --- | ---
 |  | Pass | Pass | Pass | Pass |  | Pass | Pass | Pass | Pass
QRN FC 12; 276 | 1310 | 0.218 | 0.267 | 0.242 | -70.8 | --- | -70.8 | 0.162 | -0.13 | 0.016 | --- | --- | ---
 |  | Pass | Pass | Pass | Pass |  | Pass | Pass | Pass | Pass
QRN FC 12; 275 | 1490 | 0.167 | 0.123 | 0.145 | -68.4 | --- | -68.4 | -0.124 | 0.152 | 0.014 | --- | --- | ---
 |  | Pass | Pass | Pass | Pass |  | Pass | Pass | Pass | Pass
QRN FC 12; 275 | 1550 | 0.126 | 0.106 | 0.116 | -68.1 | --- | -68.1 | -0.117 | 0.148 | 0.015 | --- | --- | ---
 |  | Pass | Pass | Pass | Pass |  | Pass | Pass | Pass | Pass
QRN FC 12; 276 | 1490 | 0.167 | 0.311 | 0.239 | -69.7 | --- | -69.7 | 0.152 | -0.124 | 0.014 | --- | --- | ---
 |  | Pass | Pass | Pass | Pass |  | Pass | Pass | Pass | Pass
QRN FC 12; 276 | 1550 | 0.09 | 0.271 | 0.18 | -69.5 | --- | -69.5 | 0.148 | -0.117 | 0.015 | --- | --- | ---
 |  | Pass | Pass | Pass | Pass |  | Pass | Pass | Pass | Pass
Spreadsheet: 272067d1382188618-help-with-draging-cell-change-book2
Sheet: CA

 | gm
Spreadsheet: 164615d1340819166-excel-2007-date-comparison-and-data-transfer-summary_prac
Sheet: Actual

 | 2012-05-23 00:00:00 | 2012-05-24 00:00:00 | 2012-05-25 00:00:00 | 2012-05-28 00:00:00 | 2012-05-29 00:00:00 | 2012-05-30 00:00:00 | 2012-05-31 00:00:00 | 2012-06-01 00:00:00 | 2012-06-04 00:00:00 | 2012-06-05 00:00:00 | 2012-06-06 00:00:00 | 2012-06-07 00:00:00 | 2012-06-08 00:00:00
Org1 | 15 | 141514 | 123 | 15 | 2131 | 123 | 5412 | 124 | 3 | 646 | 46 | 436 | 436
Org2 | 124 | 124515 | 123 | 124 | 123 | 123124 | 124 | 124 | 16546 | 436 | 436 | 436 | 436
Org3 | 213 | 12314 | 12214 | 213 | 124 | 2415 | 2134 | 12412 | 3256 | 74 | 346 | 436 | 346
Org4 | 15 | 214 | 4 | 15 | 151 | 12414 | 12 | 51 | 1526 | 643 | 463 | 46 | 324
Org5 | 124 | 123 | 141514 | 124 | 3 | 141514 | 2131 | 3 | 141514 | 2131 | 124 | 141514 | 2131
Org6 | 124 | 123 | 124515 | 124 | 16546 | 124515 | 123 | 16546 | 124515 | 123 | 124 | 124515 | 123
Org7 | 12412 | 12214 | 12314 | 12412 | 3256 | 12314 | 124 | 3256 | 12314 | 124 | 12412 | 12314 | 124
Org8 | 51 | 4 | 214 | 51 | 1526 | 214 | 151 | 1526 | 214 | 151 | 51 | 214 | 151
Spreadsheet: 103736d1301458614-excel-2007-sum-if-within-a-range-add-a-column-of-numbers-sumif-example
Sheet: Sheet1

 | #of Encounters |  |  |  | From | To
078 | 4.5 |  |  |  | 060 | 066
078 | 300.433333333333 |  |  |  | 070 | 079
078 | 1662.83529411764 |  |  |  | 080 | 088
078 | 270.661818181818 |  |  |  | 090 | 099
078 | 200.505714285714 |  |  |  | 110 | 118 |  | If column A falls between Column F and Column G, add column B
078 | 37.08 |  |  |  | 120 | 129
080 | 179.522926136364 |  |  |  | 130 | 136
089 | 51.83 |  |  |  | 139 | 139
093 | 2 |  |  |  | 140 | 149
098 | 405 |  |  |  | 150 | 159
098 | 2 |  |  |  | 160 | 165
110 | 27 |  |  |  | 170 | 176
110 | 328.601538461538 |  |  |  | 179 | 189
110 | 35.08 |  |  |  | 190 | 199
 |  |  |  |  | 200 | 208
 |  |  |  |  | 209 | 209
Spreadsheet: 719876d1613863941-auto-populate-date-ranges-to-linear-calendar-calendar-auto-populate-schedule
Sheet: Project_tracker

SN | Inspection | Project Name | START | End Projected | Duration |  | 0
556 | 84 DSI |  | 2021-03-01 00:00:00 | 2021-03-21 00:00:00
243 | 28 DSI |  | 2021-03-04 00:00:00 | 2021-03-15 00:00:00
197 | 728 DSI
698 | 28 DSI |  | 2021-03-12 00:00:00 | 2021-03-17 00:00:00
Spreadsheet: 736788d1623861053-match-the-names-to-the-header-although-the-header-has-some-merged-cells-control-number-reference-excel-help
Sheet: What I have now

Control Number | N/A | n/a | Name
[NAME] | Control A | Text A
 |  | Text B
CC1.1.2 | Control B | Text C
 |  | Text D
CC1.1.4 | Control C | Text A
 |  | Text B
 |  | Text C
 |  | Text D
 |  | Text A
 |  | Text B
 |  | Text C
CC1.1.5 | Control D | Text D
 |  | Text A
[NAME] | Control E | Text B
 |  | Text C
Spreadsheet: f3c324f5-9a28-4739-9131-6e7e88232d96
Sheet: Sheet1

[NAME] | 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
Quelle: http://ergebnisse.vimentis.ch/
Frage:
Ich bin bereit, länger zu arbeiten, damit meine [NAME] ist.
 | [NAME] hat für [NAME] den höchsten politischen [NAME]?
Antwort | [NAME] | Armee | Armut, [NAME], ungleiche Einkommensverteilung | [NAME] | Ausländer- / Migrationspolitik | Beziehung zur EU | Bildung / Forschung | Energiepolitik | Familienpolitik | [NAME] | Kosten / Finanzierung Sozialwerke | Kriminalität | Umweltschutz | Wettbewerbsfähigkeit der [NAME] | Anderes
Ja | 0.3 | 0.47 | 0.27 | 0.52 | 0.33 | 0.44 | 0.47 | 0.43 | 0.34 | 0.32 | 0.43 | 0.32 | 0.35 | 0.59 | 0.35
Neutral / Weiss nicht | 0.19 | 0.19 | 0.24 | 0.23 | 0.21 | 0.22 | 0.24 | 0.24 | 0.25 | 0.29 | 0.21 | 0.19 | 0.24 | 0.17 | 0.25
[NAME] | 0.51 | 0.34 | 0.49 | 0.25 | 0.46 | 0.34 | 0.29 | 0.34 | 0.41 | 0.39 | 0.36 | 0.48 | 0.41 | 0.24 | 0.4
Angaben zu den [NAME]
Erhebungsjahr | 2011
Stichprobengrösse | 30565
Erhebungszeitraum | 05.11.2011 bis: 30.12.2011
[NAME] | [NAME]
Methodik / Repräsentativität
Um soziodemographische Verzerrungen [NAME], wurden sämtliche [NAME] nach [NAME], Alter, Bildung und Region gemäss der wahren [NAME] älter als 15 Jahre gewichtet. Es bleibt eine psychographische Verzerrung wegen
der [NAME] über das Internet, welche nicht korrigiert [NAME]. Diese Verzerrung wird anhand einzelner [NAME] für jede [NAME] abgeschätzt. Demnach sind [NAME] auf dieser Seite angegebenen [NAME] mit einer
Präzision von &plusmn;2% [NAME].
[NAME] und [NAME] auf dieser Seite dürfen unter Angabe der Quelle weiterverwendet werden.
Spreadsheet: 724729d1616341846-change-total-column-to-top-6-column-so-i-can-still-have-top-10-column-working-testing-1-
Sheet: Sheet2

 | Names | Week One | Week Two | Week Three | Week Four | Week Five | Week Six | Week Seven | Week Eight |  | Total |  | Top 6 Scores |  | Top 10 Players score
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank Helper
 | D Frith | 15 | 14 |  |  | 0 | 0 | 0 | 0
 | P Carter | 15 | 12 |  |  | 0 | 0 | 0 | 0
 | T Seymore | 15 | 15 |  |  | 0 | 0 | 0 | 0
 | A Terry | 14 | 15 |  |  | 0 | 0 | 0 | 0
 | J Vince | 14 | 10 |  |  | 0 | 0 | 0 | 0
 | M Frith | 14 | 8 |  |  | 0 | 0 | 0 | 0
 | [NAME] | 12 | 8 |  |  | 0 | 0 | 0 | 0
 | M Micklefield | 12 | 10 |  |  | 0 | 0 | 0 | 0
 | K Ellis | 12 | 16 |  |  | 0 | 0 | 0 | 0
 | K Lester | 12 | 11 |  |  | 0 | 0 | 0 | 0
 | C Medlin | 12 | 0 |  |  | 0 | 0 | 0 | 0
 | K De Veen | 12 | 12 |  |  | 0 | 0 | 0 | 0
 | J Thompson | 12 | 12 |  |  | 0 | 0 | 0 | 0
 | K  Thompson | 12 | 14 |  |  | 0 | 0 | 0 | 0
 | G Godhard | 12 | 7 |  |  | 0 | 0 | 0 | 0
 | L Lester | 12 | 11 |  |  | 0 | 0 | 0 | 0
 | L Harvey | 10 | 0 |  |  | 0 | 0 | 0 | 0
 | S Kinson | 10 | 15 |  |  | 0 | 0 | 0 | 0
 | C Micklefield | 10 | 15 |  |  | 0 | 0 | 0 | 0
 | D Bridges | 10 | 0 |  |  | 0 | 0 | 0 | 0
 | H De Veen | 10 | 15 |  |  | 0 | 0 | 0 | 0
 | L Bray | 10 | 7 |  |  | 0 | 0 | 0 | 0
 | W Seymore | 10 | 11 |  |  | 0 | 0 | 0 | 0
 | M Bray | 10 | 7 |  |  | 0 | 0 | 0 | 0
 | G Atkinson | 10 | 11 |  |  | 0 | 0 | 0 | 0
 | [NAME] | 10 | 8 |  |  | 0 | 0 | 0 | 0
 | D Ebdon | 8 | 15 |  |  | 0 | 0 | 0 | 0
 | J Sunderland | 8 | 11 |  |  | 0 | 0 | 0 | 0
 | A Levelle | 8 | 7 |  |  | 0 | 0 | 0 | 0
 | B Green | 7 | 11 |  |  | 0 | 0 | 0 | 0
 | C Laverty | 7 | 0 |  |  | 0 | 0 | 0 | 0
 | D Colquhoun | 7 | 8 |  |  | 0 | 0 | 0 | 0
 | M Holmes |  | 15 |  |  | 0 | 0 | 0 | 0
 | K Burnam | 0 | 7 |  |  | 0 | 0 | 0 | 0
 | [NAME] | 0 | 8 |  |  | 0 | 0 | 0 | 0
Spreadsheet: 70722d1271424375-excel-2007-pivots-with-lookups-or-indexes-fix
Sheet: STORE ISSUES

Ingredients | TOTAL
[NAME] | 8
[NAME]. | 9
Fruit Cocktail | 8 |  |  | Sum of TOTAL
[NAME]. | 7 |  |  | Ingredients | Total
[NAME]. | 7 |  |  | All Bran | 0
Fruit Cocktail |  |  |  | [NAME] | 8
[NAME]. |  |  |  | Apple | 0
[NAME]. | 8 |  |  | [NAME]. | 24
Ice Cream |  |  |  | [NAME] | 4
Maas |  |  |  | [NAME] | 0
Maas |  |  |  | Bread | 0
FC Milk |  |  |  | [NAME] | 0
LF Milk |  |  |  | [NAME] | 0
FR.Yoghurt | 19 |  |  | [NAME] | 0
FR.Yoghurt |  |  |  | Chips | 0
FR.Yoghurt |  |  |  | [NAME] | 0
PL.Yoghurt |  |  |  | [NAME] | 0
All Bran | 5 |  |  | [NAME] | 0
Weetbix | 7 |  |  | Egg | 0
Apple |  |  |  | FC Milk | 0
[NAME] | 4 |  |  | FR.Yoghurt | 19
Orange |  |  |  | Fruit Cocktail | 8
Pear |  |  |  | [NAME]. | 7
Egg |  |  |  | Hake Portion | 9
Egg | 1 |  |  | HotDog Roll | 0
[NAME] | 1 |  |  | Ice Cream | 0
Snacktime |  |  |  | J&C Scone | 0
[NAME] |  |  |  | Jam | 0
[NAME] |  |  |  | Jelly | 0
Hake Portion | 9 |  |  | LF Milk | 0
Chips |  |  |  | Maas | 0
Chips |  |  |  | Margarine | 0
[NAME] |  |  |  | Milk | 0
Jelly |  |  |  | [NAME] | 9
Prunes |  |  |  | Oil | 9
[NAME] |  |  |  | Orange | 0
Bread |  |  |  | P.nut Butter | 0
Bread |  |  |  | Paprika | 0
Bread |  |  |  | Pear | 0
Bread |  |  |  | PL. Scone | 0
Bread |  |  |  | PL.Yoghurt | 0
Bread |  |  |  | Prunes | 0
Bread |  |  |  | [NAME] | 0
Bread |  |  |  | Snacktime | 0
J&C Scone |  |  |  | Weetbix | 0
PL. Scone |  |  |  | (blank)
PL. Scone
[NAME] | 1
Egg | 1
[NAME]
Paprika
Milk
Oil | 9
[NAME]
Margarine | 0
0
Margarine | 0
Margarine | 0
Margarine | 0
Margarine | 0
Margarine
Margarine
Margarine
Margarine
Oil | 1
Oil
[NAME] | 9
HotDog Roll
0 | 0
[NAME]
[NAME]
[NAME]
Egg
Egg
Jam
P.nut Butter
Milk | 1
0 | 0
Apple | 1
0 | 0
[NAME] | 1
Spreadsheet: 109821d1306591302-excel-2007-fill-gap-between-dates-book1_checkformissingdataandupdatesheet
Sheet: Sheet1

Date | Weight |  |  | Check date (Not required, for test purposes only)
2011-05-01 00:00:00 | 1 |  |  | 0
2011-05-02 00:00:00 |  |  |  | 0
2011-05-03 00:00:00 | 2 |  |  | 0
2011-05-04 00:00:00 | 2 |  |  | 0
2011-05-05 00:00:00 | 2 |  |  | 0
2011-05-06 00:00:00 | 2 |  |  | 0
2011-05-09 00:00:00 | 7 |  |  | 0
2011-05-10 00:00:00 | 9 |  |  | 0
2011-05-11 00:00:00 | 9 |  |  | 0
2011-05-12 00:00:00 | 9 |  |  | 0
2011-05-13 00:00:00 | 13 |  |  | 0
2011-05-14 00:00:00 | 14 |  |  | 0
2011-05-15 00:00:00 | 14 |  |  | 0
2011-05-16 00:00:00 |  |  |  | 0
2011-05-17 00:00:00 | 16 |  |  | 0
2011-05-18 00:00:00 | 16 |  |  | 0
2011-05-19 00:00:00 | 18 |  |  | 0
2011-05-20 00:00:00 | 18 |  |  | 0
2011-05-21 00:00:00 | 18 |  |  | 0
2011-05-24 00:00:00 | 18 |  |  | 0
2011-05-25 00:00:00 | 18 |  |  | 0
2011-05-26 00:00:00 |  |  |  | 0
2011-05-27 00:00:00 |  |  |  | 0
2011-05-28 00:00:00 |  |  |  | 1
2011-05-29 00:00:00 |  |  |  | 0
2011-05-30 00:00:00 |  |  |  | 0
2011-06-01 00:00:00 |  |  |  | 0
2011-06-02 00:00:00 |  |  |  | 0
2011-06-03 00:00:00 |  |  |  | 0
2011-06-06 00:00:00 |  |  |  | 0
Spreadsheet: 0d1418f5-4525-4c9c-a7e9-df82490b0e81
Sheet: Sheet1

Table 5--U.S. and world fiber prices | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Apr. | May | June | June
Item | 2012 | 2012 | 2012 | 2011
 | Cents per pound
Domestic cotton prices:
Adjusted world price | 78.34 | 68.75 | 61.41 | 128.79
Upland spot 41-34 | 83.37 | 72.51 | 67.35 | 144.77
Pima spot 03-46 | 127 | 123.55 | 114.43 | 247
Average price received by
upland producers | 90.9 | 84.6 | 83.1 | 83.3
Far Eastern cotton quotes:
A Index | 99.33 | 87.95 | 82.1 | 164.35
Memphis/Eastern | 102.13 | 90.85 | 84.63 | 180
Memphis/Orleans/Texas | 102.13 | 90.85 | 84.63 | 175.5
California/Arizona | 103.5 | 91.35 | 85.44 | NQ
 | Dollars per pound
Wool prices (clean):
U.S. 56s | NQ | NQ | NQ | NQ
Australian 56s 1/ | 4.11 | 4.24 | 4.27 | 4.4
U.S. 60s | NQ | NQ | NQ | NQ
Australian 60s 1/ | 6.03 | 6.29 | 5.95 | 8.59
U.S. 64s | NQ | NQ | NQ | NQ
Australian 64s 1/ | 6.35 | 6.07 | 5.76 | 7.42
NQ = No quote.
1/  In bond, Charleston, SC.
Last update:  7/12/12.
Sources: USDA, Cotton Price Statistics; Cotlook Ltd., [NAME];
and trade reports.
Spreadsheet: 852593d1702572917-need-help-getting-this-formula-to-pull-date-from-c2-and-everything-before-scheduling-12132023
Sheet: HP's

HP |  | Total hours |  |  |  |  | 2023-11-30 00:00:00 |  | 11:59:19
Time to Print | Job # | Line # | Customer | QTY | H | W | Material | Sides to Print | [NAME] | Due_Date | Est. usage | PRESS | Notes
 | 242111 | 1 | Caleres | 4050 | 28 | 47 | PAP-SO-1374 - FOAMCORE 3/16IN WHITE 48X96 | 2 | 5-Pass | 2024-01-15 00:00:00 |  | HP | For production quote- [NAME]
 | 242695 | 1 | SupplyLogic | 47 | 42 | 42 | ART-4399 - WHT 70/30 PERF VINYL 54X300 | 1 | 5-Pass | 2023-12-01 00:00:00 |  | HP
 | 242683 | 1 | Ad Trends Advertising | 5 | 16 | 94 | ART-4399 - WHT 70/30 PERF VINYL 54X300 | 1 | 5-Pass | 2023-12-01 00:00:00 |  | HP