tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 192444d1352407721-combining-data-series-with-different-data-learning-correct
Sheet: learning.csv

Pick ? | Points | Position | Player | Salary
 |  | PF | [NAME] (FC, LAC) | 14250
 |  | C | [NAME] (PF) | 14250
 |  | PF | [NAME] (C) | 11550
 |  | C | [NAME] (PF) | 11550
 |  | SF | [NAME] | 7650
 |  | SG | [NAME] (PG) | 7150
 |  | PG | [NAME] (SG) | 7150
 |  | PG | [NAME] | 15500
 |  | PG | Damian Lillard | 11750
 |  | PF | [NAME] (C) | 3000
 |  | C | [NAME] (PF) | 3000
 |  | C | [NAME] | 9150
 |  | SG | [NAME] (SF) | 3000
 |  | SF | [NAME] (SG) | 3000
 |  | PG | [NAME] | 3000
 |  | SG | [NAME] | 3000
 |  | SG | [NAME] (PG) | 7800
 |  | PG | [NAME] (SG) | 7800
 |  | PG | [NAME] | 3000
 |  | SF | [NAME] (PF) | 3000
 |  | PF | [NAME] (SF) | 3000
 |  | C | [NAME] | 4250
 |  | PF | [NAME] (C) | 8850
 |  | C | [NAME] (PF) | 8850
 |  | SG | Jamal Crawford (PG) | 11100
 |  | PG | Jamal Crawford (SG) | 11100
 |  | PF | Jared Jeffries (C) | 4350
 |  | C | Jared Jeffries (PF) | 4350
 |  | SG | [NAME] (SF) | 5550
 |  | SF | [NAME] (SG) | 5550
 |  | SG | [NAME] (SF) | 5000
 |  | SF | [NAME] (SG) | 5000
 |  | PF | [NAME] (C) | 13850
 |  | C | [NAME] (PF) | 13850
 |  | SF | [NAME] (PF) | 3400
 |  | PF | [NAME] (SF) | 3400
 |  | C | [NAME] | 6650
 |  | SF | [NAME] | 17750
 |  | SG | [NAME] | 10600
 |  | SG | [NAME] (PG) | 7550
 |  | PG | [NAME] (SG) | 7550
 |  | SF | [NAME] (PF) | 6900
 |  | PF | [NAME] (SF) | 6900
 |  | PF | LaMarcus Aldridge (C) | 15450
 |  | C | LaMarcus Aldridge (PF) | 15450
 |  | SF | [NAME] | 4050
 |  | SF | [NAME] | 11250
 |  | SG | [NAME] | 6400
 |  | PG | [NAME] | 3000
 |  | SF | [NAME] | 4100
 |  | C | Meyers Leonard | 6650
 | 3.58 | SG | Nate Robinson (PG) | 7950
 | 3.58 | PG | Nate Robinson (SG) | 7950
 | 6.05 | C | Nazr Mohammed | 3550
 | 13.98 | PF | [NAME] (C) | 4850
 | 13.98 | C | [NAME] (PF) | 4850
 | 23.3 | SG | [NAME] (SF) | 12000
 | 23.3 | SF | [NAME] (SG) | 12000
 | 1.9 | PG | [NAME] | 3000
 | 10.38 | SF | [NAME] (PF) | 3500
 | 10.38 | PF | [NAME] (SF) | 3500
 | 2.23 | PG | [NAME] | 3100
 | 22.55 | SG | [NAME] | 6750
 | 11.85 | SG | [NAME] (PG) | 3400
 | 11.85 | PG | [NAME] (SG) | 3400
 | 11.43 | PF | Ronny Turiaf (C) | 4550
 | 11.43 | C | Ronny Turiaf (PF) | 4550
 | 35.08 | PG | [NAME] | 14550
 | 5.28 | C | [NAME] | 3000
 | 5.53 | SG | [NAME] (SF) | 3950
 | 5.53 | SF | [NAME] (SG) | 3950
 | 20.85 | PF | [NAME] (C) | 10750
 | 20.85 | C | [NAME] (PF) | 10750
 | 20.13 | PF | [NAME] | 7900
 | 13.45 | SG | Thabo Sefolosha (SF) | 6650
 | 13.45 | SF | Thabo Sefolosha (SG) | 6650
 | 0.43 | PF | [NAME] | 3050
 | 7.53 | SF | [NAME] (PF) | 3100
 | 7.53 | PF | [NAME] (SF) | 3100
 | 1 | SF | [NAME] (PF) | 3450
 | 1 | PF | [NAME] (SF) | 3450
 | 21.63 | SG | [NAME] (SF) | 11150
 | 21.63 | SF | [NAME] (SG) | 11150
 | 1.1 | SG | [NAME] | 3450
 | 17.33 | SG | [NAME] | 5500
Spreadsheet: phillip_allen__28878__noi
Sheet: 1999 i.s.

 |  |  | Stagecoach Apartments
 |  |  | 1999 Operating Statement
 | Month
Category | August* | September | October | November | December |  | Grand Total
Income | 12809.74 | 16853 | 17285.1 | 17391.24 | 20694.23
Labor | -2560 | -2160 | -2925.2 | -3123.6 | -2574.9
Materials | -1211.06 | -1830.88 | -1527.01 | -3022.82 | -1416.08
Services | -165.95 | -112.07 | -149.77 | -398.25 | -109.74
Utilities | -4023.84 | -5312.01 | -3896.16 | -3609.75 | -3695.64
Taxes/Insurance**
Grand Total
*August represents a partial month
**Monthly prorata amount of $11,000/year property taxes and $4000/year insurance
Spreadsheet: 285aa49f-0f53-4ab7-ad6c-aa7b09400b7e
Sheet: Sheet1

2015-2016 Class Schedule | 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 | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected. | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22
Legal Studies
Winter 2016
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 140618d1328820341-help-with-multiple-conditions-statementsolvertrial
Sheet: Sheet2 Data

 |  |  | Statement Activity
 | Date |  | Previous Balance | Deposits/Credits | Charges/Debits | Checks Processed | Ending Balance |  | # of Checks
Month 1 | 2011-11-30 00:00:00 |  |  | 2030.39 | 1655.08 | 136.95 |  |  | #N/A
Month 2 | 2011-12-30 00:00:00 |  |  | 2371.67 | 3233.17 | 746 |  |  | 6
Month 3 | 2012-01-31 00:00:00 |  |  | 1649.64 | 1298.07 | 702
 |  |  |  |  |  | * CHECKS PROCESSED IS THE SECTION I NEED THE FORMULA TO WORK WITH, PLEASE USE THIS AREA.  THANKS
 |  |  | For Review Period | 11/01/11-01/31/12
 |  |  |  |  |  | COUNTIFS('Tracking [NAME]:B,">=" & DATEVALUE($A3 & "-" & $A$1),'Tracking [NAME]:B,"<=" & DATE($A$1,MONTH(DATEVALUE($A3 & "-" & $A$1))+1,0))
 |  |  |  |  |  | COUNTIF('Tracking [NAME]:B,">=" & DATEVALUE($A3 & "-" & $A$1))
 |  |  |  |  |  | -COUNTIF('Tracking [NAME]:B,">" & DATE($A$1,MONTH(DATEVALUE($A3 & "-" & $A$1))+1,0))
Spreadsheet: 269316d1381119237-identified-largest-and-smallest-values-but-need-to-identify-location-wilbur
Sheet: Sheet1

 | 2013-09-09 00:00:00 | 2013-09-10 00:00:00 | 2013-09-11 00:00:00 | 2013-09-12 00:00:00 | 2013-09-13 00:00:00 | 2013-09-14 00:00:00 | 2013-09-15 00:00:00 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Midnight - 2:00 | 12.20689655172414 |  | 7.741935483870968 | 16.60869565217391 | 10.17241379310345 | 7.708333333333333 | 11.45454545454546
02:00:00 | 10.3448275862069 |  | 8.6 | 16.03333333333333 | 8.68 | 5.826086956521739 | 11
04:00:00 | 11 |  | 8.92 | 13.95833333333333 | 8.766666666666667 | 7.3
06:00:00 | 10.03571428571429 |  | 9.344827586206897 | 15.14814814814815 | 8.068965517241379 | 7.033333333333333 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
08:00:00 | 15.18181818181818 | 11 | 16.57142857142857 | 19.44 | 13.15384615384615 | 12.4 | 10.73333333333333
10:00:00 | 20.53846153846154 | 18.69230769230769 | 23.38461538461538 | 23.48387096774194 | 20.2 | 13.78571428571429 | 12.14705882352941
12:00:00 | 19.46428571428572 | 15.54838709677419 | 28.8 | 25.14285714285714 | 19.26923076923077 | 12.28571428571429 | 8.703703703703704
14:00:00 | 15.38888888888889 | 15.55555555555556 | 30.8 | 24.53846153846154 | 20.55555555555556 | 11.33333333333333 | 6.285714285714286
16:00:00 | 13.8 | 16.92 | 26.76923076923077 | 8.666666666666666 | 14.46428571428571 | 9.724137931034482 | 7.714285714285714
18:00:00 | 12 | 13.5 | 19.18518518518519 | 12.86111111111111 | 11.06896551724138 | 8.08 | 15.17857142857143
20:00:00 | 11.46153846153846 | 12.09090909090909 | 20.34615384615385 | 13.93333333333333 | 15.28 | 10.11538461538461 | 9.9375
22:00:00 | 12 | 8.75 | 20.80769230769231 | 11.69444444444444 | 14.5 | 12.18181818181818 | 8.923076923076923
Spreadsheet: 58e189c3-ba25-459d-af31-acb211f1a363
Sheet: Sheet1

Name | Add1 | CSZ | phone | fax | e-mail | [NAME]
A.Vanaria Landscaping | 45 Felton Street | Waltham, MA  02454 | [PHONE] |  | [EMAIL] | Beverly
Cedar Lawn Tree Service Inc. | 32 Nickerson Road | Ashland, MA 01721 | [PHONE] | [PHONE] | [EMAIL] | Georgia
D & B Tree | 35 Federal Ave | Quincy, Ma 02169 | [PHONE] | [PHONE]
Dillon Tree Services | 484 Lake St | Shrewsbury, MA 01545 | 508- 799-7929 | 1-508- 799-7929
Ieraci Landscaping Inc. | 38 Brookdale Road | Newton, MA 02460 |  |  | [EMAIL]
[NAME] | [NAME] | Newton, MA  02165 | [PHONE] | [PHONE] | [EMAIL] | Cliff [NAME]
Lewis Tree Service | 300 Lucius [NAME] | [NAME], NY 14586 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Maltby & Co., Inc. | 30 Old Page St., POB 364 | Stoughton, MA 02072-0364 | [PHONE] | 1-781- 344-4444 | [EMAIL] | [NAME]
Marini Corp. | 14 Aspen Avenue | Auburndale, MA  02166 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Mayer Tree Service, Inc. | [NAME] 517 | Essex, MA 01929 | [PHONE] | [PHONE]
North Eastern Tree Service, Inc | 1000 Pontiac Ave | [NAME], RI 02920 | [PHONE] | [PHONE] | [EMAIL]
Northern Tree Service | 1290 Park St | Palmer, Ma 01069 | [PHONE] | [PHONE] | [EMAIL]
Phil Mastroianni Corp | 17 Fountain Street | Waltham, MA  02453 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Prime Vendor, Inc. | 4622 Cedar Avenue, Suite 123 | Wilmington, NC 28403 | [PHONE] | [PHONE]
Royer Tree Service, Inc. | 57 McDonald Street | Dedham, MA 02026 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
RWC Landscape Services Mgmt | PO Box 418 | Meredith, NH 03253 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Stumpy's Tree Service | 30 Main Street, POB 104 | Ashland, MA 01721 | 508- 879-1211 | 1-508- 231-8877
Tree Tech Inc. | 6 Springbrook Road | [NAME], MA  02035 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Spreadsheet: 888373d1738857129-liquidity-risk-exposure-using-monte-carlo-simulation-monte-carlo-simulation
Sheet: Sheet 1

Details for Sum of 1
Counterparty Balances | Daily
81.81499999999998 | 1
223.912 | 1
225.128 | 1
225.792 | 1
225.849 | 1
225.991 | 1
226.595 | 1
228.398 | 1
228.452 | 1
230.904 | 1
232.522 | 1
233.199 | 1
235.377 | 1
236.003 | 1
237.046 | 1
237.999 | 1
238.7866 | 1
240.077 | 1
240.364 | 1
241.239 | 1
241.2732 | 1
241.511 | 1
241.549 | 1
241.71 | 1
242.176 | 1
243.111 | 1
243.197 | 1
243.34 | 1
244.274 | 1
246.092 | 1
246.436 | 1
246.633 | 1
247.086 | 1
247.207 | 1
247.273 | 1
247.275 | 1
247.617 | 1
248.645 | 1
248.936 | 1
249.273 | 1
249.583 | 1
249.601 | 1
249.777 | 1
249.864 | 1
250.334 | 1
250.404 | 1
250.806 | 1
252.331 | 1
253.426 | 1
254.066 | 1
254.333 | 1
254.444 | 1
255.281 | 1
255.729 | 1
258.143 | 1
259.395 | 1
259.532 | 1
260.022 | 1
261.228 | 1
264.024 | 1
264.151 | 1
265.02 | 1
266.0359999999999 | 1
270.142 | 1
272.144 | 1
272.255 | 1
Spreadsheet: 02881dc7-aaf9-49d1-9171-349e1ff5d238
Sheet: Sheet1

Characterization of near isogenic (F5 generation) recombinant inbred line Col/Ler-FRI-Sf2#1: | Unnamed: 1 | Unnamed: 2
Chromosome | Marker | Genotype (C = Columbia; L = Ler)
I | [NAME] | C
I | ciw12 | C
I | nga248 | C
I | UFO | C
I | FRL2 | C
I | nga280 | C
I | nga111 | C
II | ciw2 | L
II | ciw3 | L
II | ER | C
II | nga163 | C
III | [NAME] | C
III | nga162 | L
III | nga6 | C
IV | nga8 | C
IV | nga1107 | L
V | CTR1 | L
V | [NAME] | L
V | FRL1 | L
V | ciw9 | C
V | ciw10 | C
Spreadsheet: 773584d1647947292-perform-double-if-if-true-plug-y-double-if
Sheet: Sheet1

DLNRTS |  |  | SHAHADAS |  |  | 41402 | AAADHHSS
DLNRTS |  |  | SADHANAS |  |  | 36682 | AAADHNSS
DLNRTS | HAS DRS AND S AT END | Y | MADRASAS |  |  | 36683 | AAADMRSS
DLNRTS |  |  | MADRASSA |  | HS | 36684 | AAADMRSS
DLNRTS | HAS RDN AND S AT END | Y | SARDANAS |  |  | 29783 | AAADNRSS
DLNRTS |  |  | BADASSED |  |  | 34625 | AABDDESS
DLNRTS |  |  | BADASSES |  |  | 37928 | AABDESSS
DLNRTS | HAS SDR AND S AT END | Y | SUBADARS |  |  | 32835 | AABDRSSU
DLNRTS |  |  | CASCADES |  |  | 38122 | AACCDESS
DLNRTS |  |  | SACCADES |  |  | 38123 | AACCDESS
DLNRTS |  |  | SCALADES | E |  | 26390 | AACDELSS
DLNRTS | HAS SND AND S AT END | Y | SCANDIAS |  |  | 25393 | [NAME]
DLNRTS | HAS SRD AND S AT END | Y | ASCARIDS |  |  | 25394 | AACDIRSS
DLNRTS |  |  | SCALADOS |  |  | 30417 | AACDLOSS
DLNRTS |  |  | DADAISMS |  |  | 36226 | [NAME]
DLNRTS |  |  | DADAISTS |  |  | 29023 | AADDISST
DLNRTS |  |  | MASSAGED |  |  | 29072 | AADEGMSS
DLNRTS |  |  | PASSAGED |  |  | 29073 | AADEGPSS
DLNRTS |  |  | ASSWAGED |  |  | 29074 | AADEGSSW
DLNRTS |  |  | SAPHEADS |  |  | 32133 | AADEHPSS
Spreadsheet: 777462d1650392824-counting-distinct-values-within-a-date-range-feeod-sample
Sheet: issues and responsible

Issue | Issue type | Responsible
No Data | No Data
Power | CX not completed | Amdocs
GPS | CX not completed | Amdocs
No issue/pending | Good | N/A
GPS, Power, Transport | CX and TMO | Amdocs and TMO
Access, Other | TMO (access) | TMO
Red RIOT | RF team | TMO
EGIS/Certificate, SGW/Switch | TMO (Transport) | TMO
EGIS/Certificate | TMO (Transport) | TMO
EGIS/Certificate, Transport | TMO (Transport) | TMO
SGW/Switch | TMO (Transport) | TMO
[NAME] | TMO (replacement) | TMO
Access | TMO (access) | TMO
Other | other | TMO
Time Constraint, Other | TMO (access) | TMO
SGW/Switch, Construction | CX and TMO | Amdocs and TMO
SGW/Switch, Transport | TMO (Transport) | TMO
[NAME] | Good
Power, Transport, Other | CX and TMO | Amdocs and TMO
DOT/Antenna | TMO (replacement) | Amdocs
Transport | TMO (Transport) | TMO
OSS/Tier-3 Task | Tier-3 | Amdocs
Construction | CX not completed | Amdocs
DOT/Antenna, Transport | TMO (replacement) | Amdocs and TMO
null,null | Good
Construction, Other | CX not completed | Amdocs
DOT/Antenna, GPS | TMO (replacement) | TMO
[NAME], GPS | TMO (replacement) | TMO
Transport, Other | TMO (Transport) | TMO
[NAME], Other | TMO (replacement) | TMO
OSS/Tier-3 Task, Transport | Tier-3 | Amdocs
Time Constraint, Transport | TMO (Transport) | TMO
Spreadsheet: 852203d1702306614-need-help-converting-a-google-sheets-formula-to-excel-ks-schedule-12112023
Sheet: Indigo

Indigo |  | Total hours
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 | 4 Pass | 2024-01-15 00:00:00 |  | INDIGO | For production quote- [NAME]
Spreadsheet: 109187d1306131157-computing-the-hours-worked-time
Sheet: Sheet1

Regular Work Hours: 8AM-5PM |  |  |  | However, we can give an allowance of 30 mins. Meaning we can allow the employee to be late up to 30 mins
[NAME]: 12NN-1PM |  |  |  | provided that the employee will extend corresponding to his/her late minutes not greater than 30 mins
 |  |  |  | anything greater than 30 mins will be disregarded.. 12-1PM Lunch Break is not included in the 8hr workday
IN | OUT | IN | OUT | HOURS | MINS
08:00:00 | 12:00:00 | 13:00:00 | 17:00:00 | 8 | 0 |  | complete time
07:45:00 | 12:00:00 | 12:45:00 | 17:00:00 | 8 | 0 |  | complete time disregarded the 15 mins early arrival since workday is 8-5pm and employee had lunch in/out between 12NN-1PM
08:30:00 | 12:00:00 | 12:00:00 | 17:30:00 | 8 | 0 |  | complete time under flexitime rules can be late not exceeding 30 mins
08:23:00 | 12:00:00 | 12:01:00 | 17:22:00 | 7 | 59 |  | lacks 1 minute under flexitime
09:23:00 | 12:00:00 | 12:01:00 | 17:30:00 | 6 | 30 |  | undertime but had flexitime of 30 mins
Spreadsheet: c7b008fd-210a-4761-a4a3-e9e870f1a6b5
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
3918 | 13466 | Henk | Knol | NED | 0 | 00:43:07 | 00:00:00 | 01:26:32 | 00:00:00 | 00:56:32 | 1 | 03:06:12
3918 | 13476 | Hans | [NAME] | NED | 0 | 00:45:23 | 00:00:00 | 01:34:55 | 00:00:00 | 00:56:35 | 2 | 03:16:54
3918 | 15967 | Leo | Meewisse | NED | 0 | 00:49:40 | 00:00:00 | 01:31:12 | 00:00:00 | 01:02:39 | 3 | 03:23:32
3918 | 13474 | Jan | [NAME] | NED | 0 | 00:49:44 | 00:00:00 | 01:55:16 | 00:00:00 | 01:06:48 | 4 | 03:51:49
Spreadsheet: c5e6f7c8-4391-4b81-82b5-f838a84298ee
Sheet: Footnotes

Footnote # | Footnote
1 | “HTR” is as defined in the EE Policy Manual
2 | Data sources for reporting will come from (a) program tracking databases and (b) process evaluation to refine estimates.  – An audit completed in one portfolio may have measures implemented over several years and portfolios.
3 | “ETP measure” defined as ET measures first introduced into the EE portfolio since January 1, 2006
4 | “ETP measure” defined as ET measures first introduced into the EE portfolio since January 1, 2006
 | “Integration Bonus” is an incentive mechanism to promote greater integration of DSM resources, available to customers who (a) sign up or are already signed up for a DSM program,  and (b) purchase, install, and/are eligible to receive a rebate for an energy saving device.
6 | ”First time” means customer has not participated in energy efficiency programs since December 31, 2005.
7 | As is indicated within this PPM, the availability of item (c) in this PPM is not yet confirmed, since it is closely-held, proprietary third-party information.  The IOU team is in discussions with AHRI about obtaining this data and to ascertain the statistical validity of what data would be provided; the IOU team will communicate with the ED about any issues regarding this data element before the first reporting period in Q1 2011 for 2010 information.
8 | ”Target market” defined as C20 licensed HVAC contracting companies in CA.
9 | The IOUs use the existing HERS Rater infrastructure to verify HERS measures and other building characteristics as required by CA Title 24 and the CEC.  The IOUs do not perform the verification inspections and do not certify HERS raters.  Note: HERS inspection protocol for production builders does not require inspection of 100% of homes; there is a sampling protocol.  For more information on HERS inspection please see http://www.energy.ca.gov/HERS/index.html
10 | Distribution channels” are as defined in 06-08 Upstream Lighting Study
11 | Data sources for reporting will come from (a) program tracking databases and (b) process evaluation to refine estimates.
12 | “Adoption” means measure is available to end-use customers through IOU programs.  Adoption of a measure may be attributed to one or more ET sub-programs
 | Potential energy impacts to be reported based on ET project findings and estimated market potential (reported through quarterly ET database updates)
14 | “Use Cases” describe the need for a technology or application.
 | “Possible action” means that the manufacturer/private industry considered TDS results in their product development efforts.
16 | Educational “collaboration” is defined as seminars, outreach events and consultations as needed.  These collaborations include exchanges of monetary or in-kind support and services (i.e., sharing meeting facilities, marketing/promotional services, etc.).
17 | “Substantial” is defined as approximately 50% or more of class content must address IDSM subject matter
18 | The data for this metric applies to rebates made through the point of sale (POS) mode.
Spreadsheet: 275703d1383611688-distribute-the-production-per-minute-to-time-table-distribution-of-prodpermin
Sheet: Sheet1

Trying to find  the distribution of Production per Minute Value in Time Table
I can find in 1.Condition what I want, but if I delete emty column I get problem.
1. Condition ( There is a empty column between table and formulas) |  |  |  |  |  |  |  | Time TABLE
Dep. | Unit | Starting | End | Time | Prod.Per Minute | Production |  | 02:00:00 | 02:01:00 | 02:02:00 | 02:03:00 | 02:04:00 | 02:05:00 | TOTAL
A | U1 | 02:00:00 | 02:05:29 |  |  | 68
 |  |  |  |  |  |  |  |  |  |  |  |  | Last column find remaining of G5 - Sum(I5:M5)
2. Condition ( There is a NOT empty column between table and formulas) |  |  |  |  |  |  | Time TABLE
Dep. | Unit | Starting | End | Time | Prod.Per Minute | Production | 02:00:00 | 02:01:00 | 02:02:00 | 02:03:00 | 02:04:00 | 02:05:00 | TOTAL
A | U1 | 02:00:00 | 02:05:29 |  |  | 3
in second condition circular References appear
I want to implement same formula logic to second condition
Is there any solution for 2.condition, or any other suggestion by formula.
Spreadsheet: 91f00ec0-1a2f-4c2c-bfba-de37ee401413
Sheet: Sheet1

Bib | Firstname | Lastname | City | State | TeamName | Age | Gender | AgeGroup | Finish | AG Place | OverAll | Order | Masters | Penalty
173 | [NAME] | Kuhl |  |  |  | 18 | F | F19 Under | 00:51:53.260000 | -- | 1 | 12
147 | [NAME] | Gray |  |  |  | 26 | F | F20-29 | 00:56:12.780000 | 1 | 2 | 16
160 | Lonni | [NAME] |  |  |  | 42 | F | F40-49 | 00:57:15.760000 | 1 | 3 | 17
163 | Jan | Atchison |  |  |  | 50 | F | F50-59 | 00:57:15.810000 | 1 | 4 | 18
142 | Sara | Bucknam |  |  |  | 34 | F | F30-39 | 00:57:49.150000 | 1 | 5 | 19
153 | [NAME] | Proescholdt |  |  |  | 49 | F | F40-49 | 00:58:19.890000 | 2 | 6 | 20
148 | [NAME] | [NAME] |  |  |  | 36 | F | F30-39 | 01:00:21.080000 | 2 | 7 | 22
177 | Stacy | [NAME] |  |  |  | 27 | F | F20-29 | 01:01:39.080000 | 2 | 8 | 24
172 | [NAME] | Kuhl |  |  |  | 43 | F | F40-49 | 01:02:56.780000 | 3 | 9 | 27
140 | [NAME] | Andreasen |  |  |  | 52 | F | F50-59 | 01:05:26.930000 | 2 | 10 | 29
156 | [NAME] | Slingluff |  |  |  | 38 | F | F30-39 | 01:07:18.780000 | 3 | 11 | 30
158 | Carrie | Sodders |  |  |  | 38 | F | F30-39 | 01:07:18.970000 | 4 | 12 | 31
150 | [NAME] | Nusbaum |  |  |  | 23 | F | F20-29 | 01:08:16.430000 | 3 | 13 | 32
159 | Rachelle | Tipton |  |  |  | 20 | F | F20-29 | 01:10:14.210000 | 4 | 14 | 34
152 | [NAME] | Proescholdt |  |  |  | 53 | F | F50-59 | 01:10:51.110000 | 3 | 15 | 35
145 | Sara | [NAME] |  |  |  | 19 | F | F19 Under | 01:11:35.440000 | 1 | 16 | 36
154 | Eve | Reinhold |  |  |  | 20 | F | F20-29 | 01:11:35.830000 | 5 | 17 | 37
178 | Emily | Minear |  |  |  | 28 | F | F20-29 | 01:13:02.650000 | 6 | 18 | 38
143 | [NAME] | [NAME] |  |  |  | 65 | F | F60 Over | 01:25:04.960000 | 1 | 19 | 40
167 | [NAME] | Nordyke |  |  |  | 20 | F | F20-29 | 07:47:47.500000 | 7 | 20 | 43
Spreadsheet: 217101d1361985480-sum-function-based-on-multiple-variables-forum-help-file-2
Sheet: Sheet1

 | Date
 |  |  |  |  |  |  | Total Lates
 | Unit | 1
Dates |  |  |  | Unit |  |  | Lates
2013-02-25 00:00:00 |  |  |  | 1 |  |  | 1
2013-02-26 00:00:00 |  |  |  | 2
2013-02-26 00:00:00 |  |  |  | 2 |  |  | 1
2013-02-26 00:00:00 |  |  |  | 1
2013-02-27 00:00:00 |  |  |  | 1
2013-02-27 00:00:00 |  |  |  | 2
2013-02-27 00:00:00 |  |  |  | 1 |  |  | 1
 | * I need a formula that evaluates the dates in A10:A16 to the date in C1 then evaluates the unit numbers in E:10:E16 and compares to C3 - and returns the total in H10:H16.
 | Example:
 |  | 2-27-13 Unit 1 = 1 late