tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0e3b9e20-5e70-4c5e-a6f4-df96b3a0ca17
Sheet: Personnel Opportunity Costs

Option 1: |  |  | Solution Type:
 |  |  | Annual Cost Growth Rate: |  | 0.03
 |  |  | Implementation |  | Opportunity Cost for Existing Personnel To Work on the Project
Category | Sub Category | Description | [NAME] | Hours Rdq | Implementation | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Total 5 Year Costs
Department Personnel
 | Time for line personnel to implement system |  | 1 | 1 |  | 1 | 1 | 1 | 1 | 1
 | Time for technical personnel to implement system |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
 | Time for management to coordinate system implemenation |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
Department Personnel Subtotal
ITS Personnel
 | Network setup and facilitation |  | 1 | 1 |  | 1 | 1 | 1 | 1 | 1
 | Server exploration and maintenance |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
 | Security |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
 | Developer/DBA time |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
 | Customer support and help desk added load |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
ITS Personnel Subtotal
Project Personnel Opportunity Costs
Spreadsheet: 870530d1717036185-vlookup-conditioned-to-a-date-test-1-
Sheet: Report 2023

 |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Simar, [NAME] | 74412.62999999999
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 13603.48
 |  |  |  |  |  |  |  |  |  |  | M.E.R. Construções, unipessoal Lda | 59999.16
 |  |  |  |  |  |  |  |  |  |  | Total | 148015.27
 |  |  |  |  |  |  |  |  |  |  | 2023-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Simar, [NAME] | 110894.76
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 10344
 |  |  |  |  |  |  |  |  |  |  | M.E.R. Construções, unipessoal Lda | 76907.92000000001
 |  |  |  |  |  |  |  |  |  |  | Total | 198146.68
 |  |  |  |  |  |  |  |  |  |  | 2023-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Simar, [NAME] | 130549.82
 |  |  |  |  |  |  |  |  |  |  | Pfeiffer Baugesellschaft mbH | 137720.77
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 7704
 |  |  |  |  |  |  |  |  |  |  | M.E.R. Construções, unipessoal Lda | 57922.84
 |  |  |  |  |  |  |  |  |  |  | Total | 333897.4299999999
 |  |  |  |  |  |  |  |  |  |  | 2023-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Simar, [NAME] | 116486.17
 |  |  |  |  |  |  |  |  |  |  | Pfeiffer Baugesellschaft mbH | 70079.17
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 5832
 |  |  |  |  |  |  |  |  |  |  | M.E.R. Construções, unipessoal Lda | 62697.56
 |  |  |  |  |  |  |  |  |  |  | Total | 255094.9
 |  |  |  |  |  |  |  |  |  |  | 2023-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Simar, [NAME] | 171572.35
 |  |  |  |  |  |  |  |  |  |  | Pfeiffer Baugesellschaft mbH | 0
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 4596
 |  |  |  |  |  |  |  |  |  |  | M.E.R. Construções, unipessoal Lda | 43301.16
 |  |  |  |  |  |  |  |  |  |  | Total | 219469.51
Spreadsheet: 0ac7e7b9-3cd1-41d3-a0e1-5c24617f72c5
Sheet: Sheet1

Degree Level, Top 10 Places of Origin for | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
the United States, 2011-2012
Places of Origin | Top 10 Places of Origin | Total Number of International Students | Undergraduate  International Students | Graduate  International Students | Non-degree-seeking International Students | Optional Practical Training
#1 | China | 194029 | 74516 | 88429 | 12690 | 18394
#2 | India | 100270 | 13059 | 59014 | 1455 | 26742
#3 | South Korea | 72295 | 38232 | 21260 | 6996 | 5807
#4 | Saudi Arabia | 34139 | 14344 | 6133 | 13214 | 448
#5 | Canada | 26821 | 12866 | 11190 | 625 | 2140
#6 | Taiwan | 23250 | 6000 | 12007 | 1866 | 3377
#7 | Japan | 19966 | 9359 | 4403 | 4611 | 1593
#8 | Vietnam | 15572 | 11244 | 2649 | 864 | 815
#9 | Mexico | 13893 | 7564 | 4188 | 1096 | 1045
#10 | Turkey | 11973 | 3495 | 6198 | 989 | 1291
Total of All Places of Origin | Total | 764495 | 309342 | 300430 | 69566 | 85157
Source:  Institute of International Education. (2012). Open Doors Report on International Educational Exchange.
Spreadsheet: 474639d1470840904-sorting-issue-in-excel-need-help-asap-sample-34-
Sheet: draft

(1) [NAME] |  | (2) Values | Pos |  | (3) Sorted Values | Pos
 |  | _A_DT-3124-0001A | 1 |  | _A_5601P | 3
 |  | _A_P-SAMP-KT | 2 |  | _[NAME] | 4
 |  | _A_5601P | 3 |  | _A_DT-3124-0001A | 1
 |  | _[NAME] | 4 |  | _A_P-SAMP-KT | 2
Spreadsheet: louise_kitchen__22704__Re-start Integration Plan
Sheet: Sheet1

Power Risk Management
Re-start/Integration Plan for NETCO
Plan Descriptions |  | Responsible Individual(s) | Due Date
Applications Needed |  |  | Testing to begin 1/14/2002
Terminal server for Portland |  | IT Infrastructure Team | Migration must be complete
 |  | [NAME] (user) | first day of trading
New instance of EnPower – this includes: |  | [NAME] (IT)
 |  | [NAME] (user)
PortCalc (valuation engine)
Deal Entry
Deal Blotter
EOL interfaces
Curve Manager
Consolidated Position Manager
Pub Posting (external rates interface)
Report Tools
Scheduling Tools
Including VMS and FSP
New instances of Global Data to feed EnPower |  | [NAME] (Power IT); [NAME] (Global IT)
 |  | [NAME] (user)
Counterparty information
This includes all new desks
Curve (region) information
Delivery Point information
New instance of TAGG/ERMS for power futures trading |  | [NAME] (Power IT); [NAME] (Gas IT)
 |  | [NAME] (user)
 | Ensure all contracts are still valid
 | Set up clearing brokers
Executive Reports Viewer |  | [NAME] (IT)
 |  | [NAME] (user)
To post management reports to website
RAC Website |  | [NAME] (IT)
 |  | [NAME] (user)
Interfaces to the following downstream systems: |  | [NAME] (IT) | Testing to begin 1/14/2002
 |  |  | Migration must be complete
CAS (Credit Aggregation System) |  | [NAME], [NAME] (users) | first day of trading
RisktRAC (for VAR reporting) |  | [NAME], [NAME] (users)
Infinity or its equivalent for cash flow hedging |  | Unknown
Interfaces from the following downstream systems: |  |  | Testing to begin 1/14/2002
 |  |  | Migration must be complete
ERMS Curves Application |  | [NAME] (Power IT); [NAME] (Gas IT) | first day of trading
Interest rate curve |  | [NAME], [NAME] [NAME] (users)
Gas curves needed in heat rate swaps and spread-options |  | [NAME], [NAME] (users)
Futures Curves |  | [NAME] (user)
Management Report Set-up |  | [NAME] (user) | 2002-01-14 00:00:00
 |  | Min [NAME] (IT)
 | P&L reports by trader
 | Position reports by trader
 | Position reports by curve/region
 | Price reports by curve/region
 | VaR reports by trader
Directories To Be Transferrred |  | IT Infrastracture Team | 2002-01-14 00:00:00
 |  | [NAME] (user)
m:\common\power\   and all subdirectories
m:\riskmgt\  and all subdirectories
m:\power2\new_sys\region\
m:\power_devel\
o:\erms\controls\rmsdata\
Commercial Information Needed |  |  | 2002-01-14 00:00:00
List of tradeable commodities, other than power |  | [NAME]
Trader desk assignments and hierarchy for VaR reporting |  | Kevin Presto & [NAME]
Process for entering into interest rate hedges |  | [NAME]
Spreadsheet: darrell_schoolcraft__7807__imbalsumm0108
Sheet: Amoco Abo

 | [NAME] |  | Amoco Abo fuel del
Day | Measured | Scheduled | Measured | Scheduled | Imbal
1 | 12222 | 11345
2 | 12888 | 11487
3 | 11891 | 11488
4 | 11899 | 11090
5 | 11842 | 11492
6 | 11356 | 11494
7 | 11348 | 11494
8 | 10845 | 11494
9 | 10042 | 11484
10 | 11541 | 11494
11 | 12142 | 11444 | -1
12 | 12792 | 11444
13 | 12272 | 11444
14 | 11797 | 11830
15 | 11785 | 11837
16 | 11842 | 11772 | -183
17 | 12746 | 11494 | -7
18 | 11034 | 11467 | -66
19 | 11828 | 11467 | -113
20 | 12542 | 11467 | -62
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  |  |  | 442176.52
2001-08-20 00:00:00
CBS Volume
 |  |  | -235778
Spreadsheet: 3b55cf2e-fd8f-4a28-b394-9aaa2410b63d
Sheet: Sheet1

Table 6--Wholesale corn milling product and byproduct prices, 7/15/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Mkt year and month 1/ | Corn meal, yellow,  Chicago, IL (dollars per cwt) |  | Corn meal, yellow,  New York, NY (dollars per cwt) |  | Corn starch,  Midwest 3/ (dollars per cwt) |  | Dextrose,  Midwest (cents per pound) |  | High-fructose corn syrup (42%),  Midwest (cents per pound)
 | 2011/12 | 2012/13 | 2011/12 | 2012/13 | 2011/12 | 2012/13 | 2011/12 | 2012/13 | 2011/12 | 2012/13
Sep | 27.9925 | 29.205 | 30.2975 | 31.03 | 23.25999999999998 | 24.21999999999998 | 30.85 | 34.85 | 21.375 | 23.375
Oct | 26.7825 | 28.555 | 29.0875 | 30.385 | 22.62999999999998 | 23.04999999999998 | 30.85 | 34.85 | 21.375 | 23.3765
Nov | 26.8975 | 28.34 | 29.2025 | 30.17 | 20.04999999999998 | 22.23999999999998 | 30.85 | 35.35 | 21.375 | 23.375
Dec | 25.74 | 28.01 | 28.045 | 29.84 | 20.88999999999998 | 22.26999999999998 | 30.85 | 35.1 | 21.375 | 23.375
Jan | 24.855 | 27.93166666666667 | 26.555 | 29.76166666666667 | 19.89999999999998 | 22.77999999999998 | 34.85 | 35.35 | 23.375 | 25.875
Feb | 26.39833333333333 | 27.6325 | 30.37 | 29.4625 | 21.39999999999998 | 22.26999999999998 | 33.85 | 35.35 | 23.375 | 25.875
Mar | 26.1675 | 27.79 | 27.92 | 29.61375 | 21.78999999999998 | 22.80999999999998 | 35.85 | 35.35 | 23.375 | 25.875
Apr | 25.5175 | 27.1875 | 27.545 | 29.0675 | 22.08999999999998 | 23.07999999999998 | 34.85 | 35.35 | 23.375 | 25.875
May | 24.485 | 27.935 | 26.7675 | 29.765 | 21.33999999999998 | 21.96999999999998 | 34.85 | 35.35 | 23.375 | 25.875
Jun | 24.295 | 28.345 | 25.995 | 30.175 | 21.24999999999998 | 21.96999999999998 | 34.85 | 35.35 | 23.375 | 25.875
Jul | 28.345 |  | 30.045 |  | 20.64999999999998 |  | 35.35 |  | 23.375
Aug | 29.86166666666666 |  | 31.56166666666667 |  | 24.09999999999998 |  | 34.85 |  | 23.375
Mkt year 2/ | 26.44479166666666 |  | 28.61597222222223 |  | 21.61249999999998 |  | 33.55833333333334 |  | 22.70833333333333
1/ September-August. Latest month is preliminary. 2/ Simple average of monthly prices for the marketing year. 3/ Bulk-industrial, unmodified. Source: Milling and Baking News, except for corn starch which is from private industry.
Date run: 7/12/2013
Spreadsheet: 60350d1260906320-auto-copy-part-of-row-in-a-worksheet-to-another-worksheet-based-on-criteria-case-assignments2010-temp
Sheet: May2010

 | Week 1 |  |  |  | Week 2 |  |  |  | Week 3 |  |  |  | Week 4 |  |  |  | Week 5
 | Eval | Defendant | Offense | Code | Eval | Defendant | Offense | Code | Eval | Defendant | Offense | Code | Eval | Defendant | Offense | Code | Eval | Defendant | Offense | Code
 | Monday |  |  |  | 2009-05-04 00:00:00 |  |  |  | 2009-05-11 00:00:00 |  |  |  | 2009-05-18 00:00:00 |  |  |  | 2009-05-25 00:00:00
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday
2
3
4
5
6
7
8
9
 | Tuesday |  |  |  | 2009-05-05 00:00:00 |  |  |  | 2009-05-12 00:00:00 |  |  |  | 2009-05-19 00:00:00 |  |  |  | 2009-05-26 00:00:00
1
2
3
4
5
6
7
8
9
 | Wednesday |  |  |  | 2009-05-06 00:00:00 |  |  |  | 2009-05-13 00:00:00 |  |  |  | 2009-05-20 00:00:00 |  |  |  | 2009-05-27 00:00:00
1
2
3
4
5
6
7
8
9
 | Thursday |  |  |  | 2009-05-07 00:00:00 |  |  |  | 2009-05-14 00:00:00 |  |  |  | 2009-05-21 00:00:00 |  |  |  | 2009-05-28 00:00:00
1
2
3
4
5
6
7
8
9
 | 2009-05-01 00:00:00 |  |  |  | 2009-05-08 00:00:00 |  |  |  | 2009-05-15 00:00:00 |  |  |  | 2009-05-22 00:00:00 |  |  |  | 2009-05-29 00:00:00
1
2
3
4
5
6
7
8
9
Spreadsheet: 683032d1592452422-creating-dropdown-list-drom-dynamic-row-entries-dropdown-example
Sheet: Example

Sub Category | Problem |  |  |  | Please Select | Additional Clean | Till Out of Action | Cannot Secure or Cannot Open | Cannot Set or Unset Alarm | Come off runners | Communication Failure | Control panel fault | [NAME]
Automatic Controls |  |  |  |  | Y |  |  |  | Y |  | Y | Y | Y
BMS |  |  |  |  | Y | Y | Y |  |  |  | Y | Y | Y
Control Panels |  |  |  |  | Y |  |  |  | Y |  |  | Y | Y
Inverter |  |  |  |  | Y |  | Y |  |  |  | Y |  | Y
Fire Alarm System |  |  |  |  | Y |  |  |  | Y |  | Y | Y | Y
 |  |  |  |  | Creating dropdown list drom dynamic row entries
 |  |  |  |  | Hi all,
 |  |  |  |  | I am trying to create data validation in the form of a list which will come from a dynamic row that contains a lot of blanks.
 |  |  |  |  | Basically I want to populate column B with a dropdown list for each entry in column A. I have created a mapping table in columns F-N that denotes what each dropdown should contain by populating "Y" in each problem type that
 |  |  |  |  | So for entry A2..Automatic controls, the dropdown in column B should contain "Please select;Cannot set or unset alarms;communication failure;control panel fault; controller offline".
 |  |  |  |  | I have tried using data validation and just telling it to ignore blanks, but it seems as though that won't work because the cells contain formulae, I dont know? So if you see cell B2 the dropdown contains the correct entries but also the uneeded blanks?
 |  |  |  |  | I have also created the table in columns P-X as I figured that might be a good way to simplify the next step... but it doesnt necessarily need to be used if its not any help?
 |  |  |  |  | Obviously I also want the dropdowns to be dynamically edited by changing where I put the "Y" entries in columns F-N if I so wish.
 |  |  |  |  | The last note is that this is a small subset of something thats going to be done for like hundreds of rows and hundreds of different "problem types" (columns F-N) so I need something easily replicatable.
 |  |  |  |  | Let me know if any further information is needed by me to explain what it is im trying to do.
Spreadsheet: 273641d1382810394-need-help-formula-to-transfering-value-book1
Sheet: Sheet2

#1 mainline pump |  |  |  |  |  |  |  | pump hour |  | today
 | Valve | Seat | Piston | Liner | Bolts |  |  | data valve | data seat | data piston | data liner
[NAME]
Center Piston
[NAME]
[NAME]
[NAME]
Center Discharge
Center Suction
Inboard Discharge
Inboard Suction
Spreadsheet: 03f9dcc2-c0ea-4567-9f5f-ffafbce489d2
Sheet: Sheet1

Providence Season Schedule | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Date | Game Number | Visiting Team | Visiting Score | Home Team | Home Score | Game Time/Status | Venue
2009-04-15 | 1 | Portland | 3 | Providence | 0 | Final | Dunkin' Donuts Center Providence, RI
2009-04-17 | 2 | Portland | 1 | Providence | 2 | Final | Dunkin' Donuts Center Providence, RI
2009-04-19 | 3 | Providence | 5 | Portland | 1 | Final | Cumberland County Civic Center Portland, ME
2009-04-23 | 4 | Providence | 2 | Portland | 1 | Final | Cumberland County Civic Center Portland, ME
2009-04-24 | 5 | Portland | 1 | Providence | 2 | Final | Dunkin' Donuts Center Providence, RI
2009-04-28 | 1 | Worcester | 2 | Providence | 3 | Final OT | Dunkin' Donuts Center Providence, RI
2009-05-06 | 2 | Providence | 4 | Worcester | 2 | Final | DCU Center Worcester, [NAME]
2009-05-08 | 3 | Worcester | 5 | Providence | 3 | Final | Dunkin' Donuts Center Providence, RI
2009-05-09 | 4 | Providence | 0 | Worcester | 1 | Final | DCU Center Worcester, [NAME]
2009-05-11 | 5 | Worcester | 3 | Providence | 4 | Final | Dunkin' Donuts Center Providence, RI
2009-05-13 | 6 | Providence | 5 | Worcester | 1 | Final | DCU Center Worcester, [NAME]
2009-05-16 | 1 | Providence | 3 | Hershey | 2 | Final | Giant Center Hershey, PA
2009-05-17 | 2 | Providence | 1 | Hershey | 2 | Final | Giant Center Hershey, PA
2009-05-22 | 3 | Hershey | 6 | Providence | 4 | Final | Dunkin' Donuts Center Providence, RI
2009-05-24 | 4 | Hershey | 3 | Providence | 2 | Final OT | Dunkin' Donuts Center Providence, RI
2009-05-25 | 5 | Hershey | 5 | Providence | 2 | Final | Dunkin' Donuts Center Providence, RI
Spreadsheet: 753652d1635608149-finding-and-matching-values-then-returning-sum-inventory
Sheet: Tab 2

Date Shipped | Product Name | Variation Name | Original Price | Quantity
2021-10-05 00:00:00 | Mini Handbag Paris | Black | 830 | 1
2021-10-05 00:00:00 | [NAME] | [NAME] | 250 | 1
2021-10-06 00:00:00 | Smooth [NAME] | [NAME] | 299 | 2
2021-10-06 00:00:00 | [NAME] | Blush | 250 | 1
2021-10-06 00:00:00 | Smooth [NAME] | Burnt Red | 299 | 1
2021-10-10 00:00:00 | Leg Cream |  | 150 | 1
2021-10-11 00:00:00 | Mini Handbag Paris | [NAME] | 830 | 2
2021-10-11 00:00:00 | Mini Handbag Paris | Black | 830 | 1
Spreadsheet: b1144f92-2b85-47d1-9a44-3e3cb6dad986
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
8091 | 29757 | [NAME] | Holland | GBR | 0 | 00:15:32 | 00:01:07 | 00:32:03 | 00:01:21 | 00:09:17 | 1 | 00:59:17
8091 | 44477 | Nick | Shasha | GBR | 0 | 00:16:00 | 00:01:07 | 00:33:44 | 00:01:13 | 00:09:23 | 2 | 01:01:25
8091 | 57366 | [NAME] | Aitken | GBR | 0 | 00:16:44 | 00:01:12 | 00:34:08 | 00:01:10 | 00:10:06 | 3 | 01:03:19
8091 | 26960 | [NAME] | [NAME] | BEL | 0 | 00:17:45 | [NAME] | 00:33:06 | 00:01:30 | 00:10:36 | 4 | 01:04:37
8091 | 57371 | [NAME] | Gould | GBR | 0 | 00:18:05 | 00:01:17 | 00:33:47 | 00:01:15 | 00:10:40 | 5 | 01:05:02
8091 | 55905 | [NAME] | [NAME] | IRL | 0 | 00:18:20 | 00:01:14 | 00:35:14 | 00:01:23 | [NAME] | 6 | 01:07:27
Spreadsheet: hunter_shively__12753__EnovateDPR0201
Sheet: 5 Day Roll

ENRON CAPITAL AND TRADE RESOURCES
 |  | DO NOT TOUCH!! | ONLY RUN BEFORE YOU LINK ANY NEW ROLLS!!
Commodity | 5 Day Rolling Total | Current Day | Current Day-1 | Current Day-2 | Current Day-3 | Current Day-4
ENA Gas Trading
Short Term Gas |  |  | 4178.602162709999 | -8.732504219997674 | -436.9593313999998 | 487.6676804500008
 |  | 13 | 12 | 11 | 10 | 7 | 6
 |  | 17 | 84 | 12 | -54 | 19 | -53
Spreadsheet: 882369d1730738632-strange-problem-microsoft-surface-7
Sheet: Lenses

Brand | Lens | [NAME] | Mount | Price | Per Paychek | Comment
Nikon | 24-70 | 2.8 | F | 1596
Nikon | 24-70 | 2.8 | Z | 1970 |  | Go with this one. More, but it's a Z mount
Nikon | 70-200 | 2.8 | F | 2097
Sigma | 70-200 | 2.8 | F | 1499
Nikon | 70-200 | 2.8 | Z | 2296 |  | Go with this one. Not much more than Nikon F
Spreadsheet: 728329d1618410594-sumif-across-multiple-columns-example
Sheet: Sum

 | 2021-04-12 00:00:00
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Derek
[NAME]
Sean
[NAME]
Trent
[NAME]
[NAME]
Hank
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: d9db817a-4104-4f66-80e3-33fee302a966
Sheet: Sheet1

Table S2. [NAME] DNA primers. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Primer Name | [NAME] (bp) | Tm (ºC) | Sequence
cDNA
1F | 698 | 60 | CTGTCGTCTCCGGTGCTC
1R |  |  | AAAGTGGATTCGCTTCAACAA
2F | 684 | 60 | AGGAGCTGGCAAAACAGAAA
2R |  |  | CCAGCAGCTCAGCACAGTAT
3F | 707 | 60 | ATGTGCACAGCCATGAAAAA
3R |  |  | TGGTCTTTGTGCTTCTGGTG
4F | 689 | 60 | ACGTGGACAATCAGGACTGC
4R |  |  | CAAAATAACCTCGGATCCAATC
5F | 675 | 60 | GACCTAATGCAAGGGGGTTT
5R |  |  | GCCTCCTCCTCTTGCTGTTT
6F | 671 | 60 | GCCAAATTTACGTCCACCAT
6R |  |  | GCTGCTCGGTCTCAGTGTTT
6(new)F | 500 | 60 | TGCACTGCAGAAAAAGAAACA
6(new)R |  |  | [NAME]
7F | 693 | 60 | CGCAGAACTACGCGATACAA
7R |  |  | TACCAGGAGCAAGGAAGTGG
7F(2) | 986 | 60 | GAGATGGAACCGAAGAGAAAAC
7R(2) |  |  | GCAAGGAAGTGGTGAGCC
8F | 650 | 60 | CAAGTAGACCGGAGGGTTC
8R |  |  | [NAME]
8F(2) | 624 | 47 | AACCTGCTCAAGTAGACCG
8R(2) |  |  | CACCTCTGCCATCAATCAC
Genomic DNA
Mmyo6D179YDNA-F | 600 | 59 | AAGAAAACGGCTTGCAAATG
Mmyo6D179YDNA-R |  |  | ATTTGGAAAATGCTGGAATAAA
TlcGen-F | 118 | 45 | CAATATTATTGTTATTCAAGGATTTTTTTTG
TlcGen-R |  |  | AAATTAACAATACCTTCAACAATTCTATG
Exon28-F | 402 | 60 | CATCTAACCTCTTTCTTTGTCACG
Exon28-R |  |  | TCTTCATTTTCAAGGGAACAAA
Exon29-F | 442 | 59 | CATGAAGCGCTCATCTTACCT
Exon29-R |  |  | TGTGTGTGTGTGTGTGTGTGA
Exon30-F | 354 | 58 | GACAATTCTTTGAGCTCTTTGG
Exon30-R |  |  | AATTGATCCGAGAAAATGTATCA
Exon31-F | 445 | 60 | CCCCCTCCCCTCTTTAAAAT
Exon31-R |  |  | CTGCAAAGCTCTGTCATTCAA
Exon32-F | 383 | 60 | AGCAGATTTCGGTCTTGCAG
Exon32-R |  |  | CTTCGGGTCACCTCTCCAC
Spreadsheet: 139784d1328464696-sum-if-array-calc-for-between-2-dates-monthly-term-fee-calc
Sheet: Term Fee Summary

 | Sent | Verified | Estimate
Totals | 390563.5125 | 2673357.801809884 | 3292149.273372334
2012-02-29 00:00:00 | 18103.965 | 0 | 0 |  | OK, based on the Early term date in Column F of the All Locations sheet, I need to know the total for each of the Columns to the left.  As you can see I can do it in total using the Sum(if() [NAME], but it is beyond me haow to tell it to do the same thing between 2 dates.  Can someone help me with this?
2012-03-31 00:00:00 | 2283.6675 | 0 | 3750
2012-04-30 00:00:00 | 6737.775 | 0 | 0
2012-05-31 00:00:00 | 12686.16 | 8949 | 93780
2012-06-30 00:00:00 | 111860.6325 | 114922.9725 | 0
2012-07-31 00:00:00 | 32972.49000000001 | 0 | 16078.5
2012-08-31 00:00:00 | 0 | 0 | 0
2012-09-30 00:00:00 | 0 | 61120.7025 | 60390
2012-10-31 00:00:00 | 32282.2575 | 152802.9675 | 0
2012-11-30 00:00:00 | 0 | 21888.5625 | 157650
2012-12-31 00:00:00 | 0 | 0 | 73161
2013-01-31 00:00:00 | 0 | 37218.105 | 0
2013-02-28 00:00:00 | 0 | 7120.14 | 82821.12
2013-03-31 00:00:00 | 0 | 46326.345 | 0
2013-04-30 00:00:00 | 0 | 0 | 32314.5
2013-05-31 00:00:00 | 0 | 0 | 441939.8325
2013-06-30 00:00:00 | 0 | 0 | 0
2013-07-31 00:00:00 | 0 | 78481.3875 | 120851.25
2013-08-31 00:00:00 | 0 | 0 | 268753.4925
2013-09-30 00:00:00 | 0 | 0 | 101118.75
2013-10-31 00:00:00 | 0 | 10359.33 | 0
2013-11-30 00:00:00 | 0 | 545120.7508255355 | 431625.75
2013-12-31 00:00:00 | 0 | 29538.6 | 85927.5
2014-01-31 00:00:00 | 0 | 0 | 33579
2014-02-28 00:00:00 | 0 | 0 | 30713.31
2014-03-31 00:00:00 | 0 | 15824.235 | 16961.25
2014-04-30 00:00:00 | 0 | 110309.355 | 197066.25
2014-05-31 00:00:00 | 0 | 53595 | 49237.5
2014-06-30 00:00:00 | 0 | 77651.7075 | 94342.03278775778
2014-07-31 00:00:00 | 0 | 0 | 35525.25
2014-08-31 00:00:00 | 0 | 244202.1675 | 103141.5
2014-09-30 00:00:00 | 0 | 231843.9933984375 | 0
2014-10-31 00:00:00 | 0 | 244972.5 | 210844.05
2014-11-30 00:00:00 | 0 | 0 | 60537
2014-12-31 00:00:00 | 0 | 0 | 0
2015-01-31 00:00:00 | 0 | 0 | 4500
2015-02-28 00:00:00 | 0 | 0 | 76263.82291666666
2015-03-31 00:00:00 | 0 | 0 | 0
2015-04-30 00:00:00 | 0 | 0 | 50068.53016791044
2015-05-31 00:00:00 | 0 | 0 | 0
2015-06-30 00:00:00 | 0 | 0 | 90459.75
2015-07-31 00:00:00 | 0 | 252949.7137463677 | 236922.3
2015-08-31 00:00:00 | 0 | 328160.2663395434 | 0
2015-09-30 00:00:00 | 0 | 0 | 0
2015-10-31 00:00:00 | 0 | 0 | 0
2015-11-30 00:00:00 | 0 | 0 | 0
2015-12-31 00:00:00 | 0 | 0 | 0
2016-01-31 00:00:00 | 0 | 0 | 0
2016-02-29 00:00:00 | 0 | 0 | 0
2016-03-31 00:00:00 | 0 | 0 | 0
2016-04-30 00:00:00 | 0 | 0 | 0