tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0076ea3c-3dab-40e6-9445-1d1b2bfebc7a
Sheet: Sheet1

New York State Energy Research and Development Authority | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Solicitation/Contract No. | Unnamed: 6 | Page
Contract Pricing Proposal Form
Contractor: |  |  |  |  | Name of Proposed Project:
Address:
Location (where work is to be performed): |  |  |  |  | NYSERDA funding:
 |  |  |  |  | Total Project Cost:
 |  |  |  |  | Total | Funding & | Cost-sharing
 |  |  |  |  | Project | Co-funding | & Other
Cost Element |  |  |  |  | Cost | via NYSERDA | Co-funding
1.   Direct Materials
a. Purchased Parts |  |  |  |  |  | WORK
b. Other
Total Direct Materials
2.   Materials Overhead |  |  | Rate:
3.   Direct Labor (specify names/titles) |  |  | Hours | Rate/hr
Total Direct Labor
4.   Labor Overhead |  |  | Rate % | $ [NAME]
Total Labor Overhead
5.   Outside Special Testing
6.   Equipment
7.   Travel
8.   Other Direct Costs
9.   Subcontractors/Consultants
Total Subcontractors/Consultants
10. General & Administrative Expense |  |  | Rate % | Element(s)
11. Fee or Profit  (if allowable)      Rate:
12. Total Estimated Project Cost
This proposal reflects our best estimates as of this date, in accordance with the instructions to proposers.
Typed Name and Title: |  |  |  | Signature: |  |  | Date:
Has any executive agency of the U.S. government performed any review of your records in connection with any prime
contract or subcontract within the past twelve months? |  |  |  | ____ Yes | ____ No
If yes, identify:
Supporting Schedule - Contract Pricing Proposal Form
Element No. | Item Description |  |  |  |  |  | Amount
Spreadsheet: 181483d1348056832-trying-to-allocate-values-in-a-cell-up-to-a-specified-ceiling-then-move-to-next-ceiling-allocate-values
Sheet: Sheet1

50000 |  | 20000 | 50000
30000 |  | 0
5000 |  | 0
5000000 |  | 20000
25000 |  | 50000
2000 |  | 50000
2000 |  | 5000000
Spreadsheet: 739540d1625760870-need-formula-that-gives-the-lowest-selling-location-in-total-sales-multiple-locations-location
Sheet: Tabelle1

Sales | Location
100 | Berlin
150 | London |  | Need: formula for location with the lowest sales total
230 | London
50 | Chicago
70 | Berlin
120 | Berlin
90 | London
130 | London
10 | Chicago
70 | Chicago
200 | Chicago
300 | London
140 | Berlin
95 | Berlin
75 | Chicago
Spreadsheet: lisa_gang__22314__ENA_PGE_JUNE_10_2002
Sheet: JD-MAL OR CPTJK TRANS

From: | EPMI
To: | PGE System Transactions
Date: | 2002-06-10 00:00:00
Total Transmission
HE
ENDING | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | TOTAL
Pacific Prevailing
Time | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | [NAME] USED
(PPT) |  |  |  |  |  |  | Total In To PGE Trans
0100 | 0 | 0 | 0 | 0 | 0 | 0
0200 | 0 | 0 | 0 | 0 | 0 | 0
0300 | 0 | 0 | 0 | 0 | 0 | 0
0400 | 0 | 0 | 0 | 0 | 0 | 0
0500 | 0 | 0 | 0 | 0 | 0 | 0
0600 | 0 | 0 | 0 | 0 | 0 | 0
0700 | 25 | 25 | 25 | 25 | 25 | 25
0800 | 25 | 25 | 25 | 25 | 25 | 25
0900 | 25 | 25 | 25 | 25 | 25 | 25
1000 | 25 | 25 | 25 | 25 | 25 | 25
1100 | 25 | 25 | 25 | 25 | 25 | 25
1200 | 25 | 25 | 25 | 25 | 25 | 25
1300 | 25 | 25 | 25 | 25 | 25 | 25
1400 | 25 | 25 | 25 | 25 | 25 | 25
1500 | 25 | 25 | 25 | 25 | 25 | 25
1600 | 25 | 25 | 25 | 25 | 25 | 25
1700 | 25 | 25 | 25 | 25 | 25 | 25
1800 | 25 | 25 | 25 | 25 | 25 | 25
1900 | 25 | 25 | 25 | 25 | 25 | 25
2000 | 25 | 25 | 25 | 25 | 25 | 25
2100 | 25 | 25 | 25 | 25 | 25 | 25
2200 | 25 | 25 | 25 | 25 | 25 | 25
2300 | 0 | 0 | 0 | 0 | 0 | 0
2400 | 0 | 0 | 0 | 0 | 0 | 0
 | BPA(G)24966 | BPA(G)24966 | BPA(G)24966 | BPA(G)24966 | BPA(G)24661 | BPA(G)24718
 | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD
 | AEP | AEP | AEP | AEP | AEP | AEP
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | AEP | AEP | AEP | AEP | AEP | AEP
 | MID | MIRANT | EPME | SNCL | MORGAN | SDGE
 | MID(T)CPJK/TRACEY/WESLEY | ISO(T)MALIN/NP15 | MORGAN | ISO(T)CPJK/NP15 | PAC | ISO(T)MALIN/NP15
 | MID(L)WESLEY | MIRANT(L)NP15 | SPP | SNCL(L)NP15 | PAC(T)COBHUB/JD | SDGE(L)NP15
 |  |  | PAC |  | [NAME]/PACW
 |  |  | CDWR |  | PAC(L)SYS
 |  |  | SEMP
 |  |  | MIRANT
 |  |  | ISO(T)MALIN/NP15
 |  |  | MIRANT(L)NP15
Spreadsheet: 004d3906-09fe-4f6d-9060-46cc79667e70
Sheet: Sheet1

Crystal Screen Lite (HR2-128) - Scoring Sheet | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Sample: |  | 1 [NAME] |  | 6 Needles 1D
Buffer: |  | 2 Phase Separation |  | 7 Plates 2D
Reservoir Volume: |  | 3 Regular Granular Precipitate |  | 8 Xtal <0.2 mm
[NAME]: |  | 4 Birefringent Precipitate |  | 9 Xtal >0.2 mm
Temperature: |  | 5 Spherulites
[NAME]:
Temperature: |  | Date | Date | Date
1.   15% MPD, 0.1 M Na Acetate pH 4.6, 0.02 M Calcium Chloride
2.   0.2 M K, Na Tartrate
3.   0.2 M Ammonium Phosphate
4.   1.0 M Ammonium Sulfate, 0.1 M Tris HCl pH 8.5
5.   15% MPD, 0.1 M Sodium Hepes pH 7.5, 0.2 M Sodium Citrate
6.   15% PEG 4000, 0.1 M Tris HCl pH 8.5, 0.2 M Magnesium Chloride
7.   0.7 M Sodium Acetate, 0.1 M Na Cacodylate pH 6.5
8.   15% iso-Propanol, 0.1 M Na Cacodylate pH 6.5, 0.2 M Sodium Citrate
9.   15% PEG 4000, 0.1 M Na Citrate pH 5.6, 0.2 M Ammonium Acetate
10. 15%  PEG 4000, 0.1 M Na Acetate pH 4.6, 0.2 M Ammonium Acetate
11. 0.5 M Ammonium Phosphate, 0.1 M Na Citrate pH 5.6
12. 15% iso-Propanol, 0.1 M Na Hepes pH 7.5, 0.2 M Magnesium Chloride
13. 15% PEG 400, 0.1 M Tris HCl pH 8.5, 0.2 M Sodium Citrate
14. 14% PEG 400, 0.1 M Na Hepes pH 7.5, 0.2 M Calcium Chloride
15. 15% PEG 8000, 0.1 M Na Cacodylate pH 6.5, 0.2 M Ammonium Sulfate
16. 0.75 M Lithium Sulfate, 0.1 M Na Hepes pH 7.5
17. 15% PEG 4000, 0.1 M Tris HCl pH 8.5, 0.2 M Lithium Sulfate
18. 10% PEG 8000, 0.1 M Na Cacodylate pH 6.5, 0.2 M Magnesium Acetate
19. 15% iso-Propanol, 0.1 M Tris HCl pH 8.5, 0.2 M Ammonium Acetate
20. 12.5% PEG 4000, 0.1 M Na Acetate pH 4.6, 0.2 M Ammonium Sulfate
21. 15% MPD, 0.1 M Na Cacodylate pH 6.5, 0.2 M Magnesium Acetate
22. 15% PEG 4000, 0.1 M Tris HCl pH 8.5, 0.2 M Sodium Acetate
23. 15% PEG 400, 0.1 M Na Hepes pH 7.5, 0.2 M Magnesium Chloride
24. 10% iso-Propanol, 0.1 M Na Acetate  pH 4.6, 0.2 M Calcium Chloride
25. 0.5 M Sodium Acetate, 0.1 M Imidazole pH 6.5
26. 15% MPD, 0.1 M Na Citrate pH 5.6, 0.2 M Ammonium Acetate
27. 10% iso-Propanol, 0.1 M Na Hepes pH 7.5, 0.2 M Sodium Citrate
28. 15% PEG 8000, 0.1 M Na Cacodylate pH 6.5, 0.2 M Sodium Acetate
29. 0.4 M K, Na Tartrate, 0.1 M Na Hepes pH 7.5
30. 15% PEG 8000, 0.2 M Ammonium Sulfate
31. 15% PEG 4000, 0.2 M Ammonium Sulfate
32. 1.0 M Ammonium Sulfate
33. 2.0 M Sodium Formate
34. 1.0 M Sodium Formate, 0.1 M Na Acetate pH 4.6
35. 0.8 M Na, K Phosphate, 0.1 M Na Hepes pH 7.5
36. 4% PEG 8000, 0.1 M Tris HCl pH 8.5
37. 4% PEG 4000, 0.1 M Na Acetate pH 4.6
38. 0.7 M Sodium Citrate, 0.1 M Na Hepes pH 7.5
39. 2% PEG 400, 0.1 M Na Hepes pH 7.5, 1.0 M Ammonium Sulfate
40. 10% iso-Propanol, 0.1 M Na Citrate pH 5.6, 10% PEG 4000
41. 5% iso-Propanol, 0.1 M Na Hepes pH 7.5, 10% PEG 4000
42. 10% PEG 8000, 0.05 M Potassium Phosphate
43. 15% PEG 1500
44. 0.1 M Magnesium Formate
45. 9% PEG 8000, 0.1 M Na Cacodylate pH 6.5, 0.2 M Zinc Acetate
46. 9% PEG 8000, 0.1 M Na Cacodylate pH 6.5, 0.2 M Calcium Acetate
47. 1.0 M Ammonium Sulfate, 0.1 M Na Acetate pH 4.6
48. 1.0 M Ammonium Phosphate, 0.1 M Tris HCl pH 8.5
49. 2% PEG 8000, 0.5 M Lithium Sulfate
50. 7.5% PEG 8000, 0.5 M Lithium Sulfate
Spreadsheet: beebc7dd-737a-4a95-b4de-3faf7ce0246f
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: |  |  | 2014-03-28 09:25:06.110000
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.875 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.75 | 102.875 | 102.75 | 102.625 | 102.25
4.625 | 102.259 | 102.134 | 102.009 | 101.634 |  | Note: | Refer To Price [NAME]
4.5 | 101.32 | 101.195 | 101.07 | 100.695 |  |  | For all Price Adjs
4.375 | 100.463 | 100.338 | 100.213 | 99.588
4.25 | 99.885 | 99.76 | 99.635 | 99.01
4.125 | 99.054 | 98.929 | 98.804 | 98.179
4 | 98.036 | 97.911 | 97.786 | 97.161
3.875 | 96.988 | 96.863 | 96.738 | 96.113
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.875 | 102.75 | 102.625 | 102.25
3.875 | 102.386 | 102.261 | 102.136 | 101.761
3.75 | 102.031 | 101.906 | 101.781 | 101.406
3.625 | 101.626 | 101.501 | 101.376 | 101.001
3.5 | 101.051 | 100.926 | 100.801 | 100.176
3.375 | 100.296 | 100.171 | 100.046 | 99.421
3.25 | 99.492 | 99.367 | 99.242 | 98.617 |  | 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 | 2014-04-11 09:25:06.110000
30 DAY | 2014-04-26 09:25:06.110000
45 DAY | 2014-05-11 09:25:06.110000
60 DAY | 2014-05-26 09:25:06.110000
90 DAY | 2014-06-25 09:25:06.110000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 763859d1642434662-concatenate-if-mimic-textjoin-have-to-use-excel-2013-concatenate-if
Sheet: Sheet1

[NAME] | 6 |  |  | [NAME] | 6, 6, 8, 5
Fred | 10 |  |  | Fred
Gert | 1 |  |  | Gert
[NAME] | 7 |  |  | [NAME]
[NAME] | 4 |  |  | [NAME]
[NAME] | 7 |  |  | [NAME]
[NAME] | 6
Fred | 10
Gert | 4
[NAME] | 1
[NAME] | 8
[NAME] | 9
[NAME] | 5
[NAME] | 5
Gert | 9
[NAME] | 3
[NAME] | 3
[NAME] | 10
[NAME] | 5
[NAME] | 1
[NAME] | 8
Fred | 10
Gert | 3
[NAME] | 5
[NAME] | 5
Fred | 1
Gert | 2
Spreadsheet: 04a6a873-1091-430a-a6ee-6c59773331dc
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Purchasing Card Cycle Transaction Log | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
PURCHASING SERVICES |  | File Name: PC (Excel) Purchasing Card Cycle Transaction Log 16 |  |  |  |  |  |  | Rev: 6 | Form Date: June 13, 2002
[1] Cardholder: | [NAME] | [2] Agency/Orgn:  ACC 9999 | [3] Card Number: 9999 |  |  |  |  | [4] Purchasing Cycle Date: 1/1/08 - 1/31/08
[5] | [6] | [7] | [8] | [9] | [10] | [11] | [12] | [13] | [14] | [15]
Trans Date | Supplier/Vendor | Description Goods/Services Ordered | Sub-Total | Cost of Goods  (Use Tax applicable) | Use/ | Sales Tax | Use Tax | Shipping Costs | Total Cost | Travel TE/TP Document Number
 |  | /Public Purpose : |  |  | Sales Tax
 |  |  |  |  | Exempt
2008-01-02 00:00:00 | Amazon.com | Textbook for ACCT 999 sessional instructor | 100 | 100 |  |  | 5.600000000000001 | 5 | 105
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0
 |  | TOTALS |  | 100 |  |  | 5.600000000000001 |  | 105
I acknowledge that as a public entity the University shall conduct itself in such a manner as to foster public confidence in the integrity of the University procurement operation and withstand the scrutiny of the public.  I certify that the above purchases serve the public purpose and further the goals of the University and the purchases were conducted in accordance with the policies and procedures set forth by the University and the Board of Regents.
[16] Cardholder Signature: |  |  |  |  |  |  |  |  |  | Date:
[17] AGENCY/ORGN Fiscal Liaison Signature: |  |  |  |  |  |  |  |  |  | Date:
Spreadsheet: 755836d1637136571-sum-non-zero-monthly-revenue-data-
Sheet: Sheet1

 | [NAME] | M1 | M2 | M3 | M4 | M5 | M6 | M7 | M8 | M9 | M10 | M11 | M12 | Q1 | Q2 | Q3 | Q4
Customer 1 | Large | 100 | 0 | 200 | 500 | 600 | 0 | 0 | 600 | 700 | 100 | 150 | 200
Customer 2 | Small | 100 | 250 | 100 | 0 | 0 | 600 | 500 | 400 | 450 | 450 | 450 | 450
Customer 3 | Medium | 100 | 0 | 200 | 500 | 600 | 0 | 0 | 600 | 700 | 100 | 0 | 0
Customer 4 | Small | 100 | 150 | 150 | 50 | 50 | 50 | 50 | 25 | 25 | 25 | 25 | 25
etc…
Spreadsheet: ccf66e46-22ed-48cc-a421-212689924465
Sheet: Sheet1

Index Investment Data | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
In U.S. Dollars and Futures Equivalent Contracts
 | 2010-12-31 00:00:00 | 2010-12-31 00:00:00 | 2010-12-31 00:00:00 | 2010-12-31 00:00:00 | 2010-12-31 00:00:00 | 2010-12-31 00:00:00
U.S. Futures Market1 | Notional Value (Billions US$) |  |  | Futures Equivalent Contracts3 (Thousands)
(Notional Value > 0.5 billion US$)2 | Long | Short | Net L (S) | Long | Short | Net L (S)
Cocoa | 1.4 | -0.6 | 0.9 | 48 | -19 | 29
Coffee | 6.8 | -1.8 | 5 | 76 | -20 | 56
Copper | 10.1 | -2.1 | 8 | 92 | -19 | 72
Corn | 19.6 | -5.8 | 13.8 | 631 | -185 | 446
Cotton | 7.7 | -2.5 | 5.2 | 110 | -35 | 75
[NAME] | 0.8 | -0.3 | 0.6 | 14 | -5 | 9
Gold | 19.3 | -4.4 | 14.9 | 135 | -31 | 105
Heating Oil | 9.5 | -1.7 | 7.8 | 89 | -16 | 73
[NAME] | 4.3 | -1.1 | 3.1 | 130 | -36 | 95
Live Cattle | 8.2 | -2.2 | 6 | 189 | -50 | 138
Natural Gas | 17.5 | -2.8 | 14.6 | 393 | -64 | 329
RBOB Unleaded Gas | 9.6 | -1.4 | 8.2 | 94 | -14 | 81
Silver | 7.3 | -1.2 | 6.1 | 47 | -8 | 40
Soybean Oil | 4.9 | -1.3 | 3.6 | 140 | -37 | 103
Soybeans | 18.7 | -5.2 | 13.5 | 269 | -74 | 195
Sugar | 10.5 | -3.6 | 6.8 | 307 | -103 | 204
Wheat (CBOT) | 14.6 | -5.7 | 8.9 | 362 | -142 | 219
Wheat (KCBT) | 1.9 | -0.6 | 1.3 | 44 | -14 | 30
WTI Crude Oil | 57.4 | -15.7 | 41.7 | 622 | -171 | 451
Subtotal (>0.5 billion US$) | 230.2 | -60 | 170.2
Subtotal (<0.5 billion US$) | 2.2 | -0.4 | 1.7
Total Notional US Mkts | 232.4 | -60.5 | 171.9
Total Not'l Non-US Mkts | 51.3 | -12.1 | 39.2
Total All Markets | 283.7 | -72.5 | 211.1
1 Each listed U.S. futures market includes index investment for all futures and OTC markets related to or referenced to that U.S. futures market.  For example, the U.S. market listed as “WTI Crude Oil” includes (with the NYMEX’s Light “Sweet” crude oil futures market) investments held in the NYMEX “Crude Oil Financial” market and the ICE Futures-Europe WTI Light Sweet crude oil market, because both of those contracts’ settlement prices are determined by reference to the NYMEX Light “Sweet” crude oil futures contract.
2 US Futures Markets with greater than 0.5 billion US dollars in reported net index investment notional value at the end of at least one of the past four quarters.
3Futures Equivalent Contracts: Futures plus delta-adjusted options, estimating what [NAME] would have been established absent offsets.
(See the Explanatory Notes for more details about this data)
Spreadsheet: 57355d1257452310-pivot-table-calculated-fields-help-test-pivot
Sheet: Pivot tables

 |  | Data
 | Brand_ID_(IBSRP2)_(UDC) | Sum of SumOfQuantity | Sum of SumOfSales_12_month | Sum of SumOfSales_3_month | dsi brand
 | S-ROM (Hips) | 660 | 91 | 14 | 2647.252747252747
 | ASR | 1223 | 1471 | 176 | 303.4636301835486
 | Pinnacle | 10831 | 13266 | 3511 | 298.0035428916026
 | PFC Knees (inc Sigma) | 31054 | 48577 | 12028 | 233.3349115836713
 | Corail | 3711 | 6044 | 1567 | 224.1090337524818
 | LCS | 1947 | 3757 | 806 | 189.1549108331115
 | Charnley | 2 | 4 | 2 | 182.5
 | C-Stem | 1770 | 3876 | 989 | 166.6795665634675
 | Elite | 337 | 831 | 212 | 148.0204572803851
 | Duraloc | 334 | 918 | 230 | 132.7995642701525
 | Grand Total | 51869 | 78835 | 19535 | 240.1494894399696
 |  | Field_Sales_Manager
 | Brand_ID_(IBSRP2)_(UDC) | bob | [NAME] | leanne | [NAME] | Grand Total
 | ASR
 | Charnley
 | Corail
 | C-Stem
 | Duraloc
 | Elite
 | LCS
 | PFC Knees (inc Sigma)
 | Pinnacle
 | S-ROM (Hips)
 | Grand Total
Spreadsheet: 797538d1663945398-vlookup-help-with-multiple-lookup-items-and-grouping-example
Sheet: calculated

Subject_Number | Visit 1 _doc | Visit 2_doc | Visit 3_doc | Visit 4_doc | Visit 5_doc |  |  |  |  |  |  |  | Vlookup
001-0001 |  |  | False | False | False
001-0002 |  |  | False | False | False
001-0003 | 1 | missing | missing | missing | missing
001-0003 | 1 | 1 | missing | missing | missing
001-0003 | 1 | missing | 1 | missing | missing
001-0003 | 1 | missing | missing | missing | missing
001-0003 | 1 | missing | missing | missing | missing
001-0003 | 1 | missing | missing | missing | missing
001-0003 | 1 | missing | missing | missing | missing
001-0003 | 1 | missing | missing | missing | missing
001-0003 | 1 | missing | missing | missing | missing
001-0003 | 1 | missing | missing | missing | missing
001-0003 | 1 | missing | missing | missing | missing
001-0003 | 1 | missing | missing | missing | missing
001-0004 |  |  | False | False | False
001-0005 |  |  | False | False | False
001-0006 |  |  | False | False | False
001-0007 |  |  | False | False | False
001-0008 |  |  | False | False | False
001-0009 |  |  | False | False | False
001-0010 |  |  | False | False | False
001-0011 |  |  | False | False | False
001-0012 | 1 | missing | missing | missing | missing
001-0012 | 1 | 1 | missing | missing | missing
001-0012 | 1 | missing | 1 | missing | missing
001-0012 | 1 | missing | missing | 1 | missing
001-0012 | 1 | missing | missing | missing | missing
001-0012 | 1 | missing | missing | missing | missing
001-0012 | 1 | missing | missing | missing | missing
001-0012 | 1 | missing | missing | missing | missing
001-0012 | 1 | missing | missing | missing | missing
001-0012 | 1 | missing | missing | missing | missing
001-0012 | 1 | missing | missing | missing | missing
001-0013 |  |  | False | False | False
001-0014 |  |  | False | False | False
001-0015 |  |  | False | False | False
001-0016 | 1 | missing | missing | missing | missing
001-0016 | 1 | 1 | missing | missing | missing
001-0016 | 1 | missing | 1 | missing | missing
001-0016 | 1 | missing | missing | missing | 1
001-0016 | 1 | missing | missing | missing | missing
001-0016 | 1 | missing | missing | missing | missing
001-0016 | 1 | missing | missing | missing | missing
001-0016 | 1 | missing | missing | missing | missing
001-0016 | 1 | missing | missing | missing | missing
001-0017 | 1 | missing | missing | missing | missing
001-0017 | 1 | missing | 1 | missing | missing
001-0017 | 1 | missing | missing | missing | missing
001-0018 |  |  | False | False | False
001-0019 |  |  | False | False | False
001-0020 |  |  | False | False | False
001-0021 |  |  | False | False | False
Spreadsheet: 115419d1311037930-excel-2007-combine-data-into-single-row-with-total-sample-data
Sheet: Sheet1

PATRON | MA_NBR | FARM_NAME | ADDRESS | TOWN | ST | ZIP | PDS
51 | 4 | [NAME], WESLEY P | PO BOX 113 | BROOKFIELD | VT | 5036 | 3848017
51 | 4 | [NAME], WESLEY P | PO BOX 113 | BROOKFIELD | VT | 5036 | 682378
Spreadsheet: 6314aa3a-748c-4eae-b591-7d72acab39c4
Sheet: Smartphone

 | Project Scope: | Enter scope here.
 | AALL Mobile Task Force |  | Weight Total |  | Device 1 Name |  | Total Score |  | Device 2 Name |  | Total Score |  | Device 3 Name |  | Total Score
 | Device Evaluation Worksheet
 | Smartphone Criteria |  | Assigned Weight |  | Criterion Score | Subtotal | [NAME] |  | Criterion Score | Subtotal | [NAME] |  | Criterion Score | Subtotal | [NAME]
 | Hardware
 | Processor |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 | 1 | 2 | 3 | 4 | 5
 | Memory |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Storage |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Operating System |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Battery Life & Charging Time |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Upgradeability |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Other |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Display
 | Screen Size |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Screen Resolution |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Color Quality |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Touch Screen |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Ambient Light Sensor |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Other |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Usability
 | Ease-of-use |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Customizability |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Other |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Multimedia
 | Camera Quality |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Front/Rear Cameras |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Video Quality |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Video/Presentation Output |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Audio Output |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Ambient Noise Reduction |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Other |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Connectivity
 | [NAME] |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | [NAME] |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Carrier/Service Coverage |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Bluetooth |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | GPS |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Other |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Software
 | Availability of Apps |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Security |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Java/Flash Capability |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Other |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Design
 | Durability |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Look & Feel |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Weight & Portability |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Peripherals/Accessories |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Other |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Price & Support
 | Purchase Cost |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Maintenance & Service Cost |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Warranty |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Brand/Place of Purchase |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Other |  |  |  | 0 |  |  |  | 0 |  |  |  | 0