tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 43901d1242555572-average-column-depending-on-values-in-another-column-forex-journal-template
Sheet: AUGJOURNAL

Monday, 3rd August 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSS |  | PIPS
 |  |  |  | TOTALS
Tuesday, 4th August 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSS |  | PIPS
 |  |  |  | TOTALS
Wednesday, 5th August 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSS |  | PIPS
 |  |  |  | TOTALS
Thursday, 6th August 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSS |  | PIPS
 |  |  |  | TOTALS
Friday, 7th August 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSS |  | PIPS
 |  |  |  | TOTALS
Monday, 10th August 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSS |  | PIPS
 |  |  |  | TOTALS
Tuesday, 11th August 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSS |  | PIPS
 |  |  |  | TOTALS
Wednesday, 12th August 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSS |  | PIPS
 |  |  |  | TOTALS
Thursday, 13th August 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSS |  | PIPS
 |  |  |  | TOTALS
Friday, 14th August 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSS |  | PIPS
 |  |  |  | TOTALS
Monday, 17th August 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSS |  | PIPS
 |  |  |  | TOTALS
Tuesday, 18th August 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSS |  | PIPS
 |  |  |  | TOTALS
Wednesday, 19th August 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSS |  | PIPS
 |  |  |  | TOTALS
Thursday, 20th August 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSS |  | PIPS
 |  |  |  | TOTALS
Friday, 21st August 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSS |  | PIPS
 |  |  |  | TOTALS
Monday, 24th August 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSS |  | PIPS
 |  |  |  | TOTALS
Tuesday, 25th August 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSS |  | PIPS
 |  |  |  | TOTALS
Wednesday, 26th August 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSS |  | PIPS
 |  |  |  | TOTALS
Thursday, 27th August 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSS |  | PIPS
 |  |  |  | TOTALS
Friday, 28th August 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSS |  | PIPS
 |  |  |  | TOTALS
DATE | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSS |  | PIPS
 |  |  |  | TOTALS
DATE | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSS |  | PIPS
 |  |  |  | TOTALS
DATE | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSS |  | PIPS
 |  |  |  | TOTALS
DATE | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSS |  | PIPS
 |  |  |  | TOTALS
DATE | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSS |  | PIPS
 |  |  |  | TOTALS
Spreadsheet: 714673d1611325907-calculating-number-totals-by-week-with-split-of-days-example-help
Sheet: Sheet1

 |  | Week 1 |  |  |  |  |  |  | Week 2 |  |  |  |  |  |  | Week 3
 | Column1 | 18-Jan | 19-Jan | 20-Jan | 21-Jan | 22-Jan | 23-Jan | 24-Jan | 25-Jan | 26-Jan | 27-Jan | 28-Jan | 29-Jan | 30-Jan | 31-Jan | 1-Feb | 2-Feb | 3-Feb | 4-Feb | 5-Feb | 6-Feb | 7-Feb
 | 1 | 8 | 8 |  |  |  |  |  |  |  | 8 |  | 8 |  |  | 8
 | 2 |  | 8 | 8 | 8 |  |  |  | 8 | 8 | 8 |  |  |  |  | 8 | 8
 | 3 |  |  |  | 8 |  |  |  | 8 |  |  |  |  |  |  |  | 8
 | 4 |  |  |  |  |  |  |  | 8
 | 5 |  | 8 | 8 | 8 | 8 |  |  | 8 |  |  |  | 8
 |  | Week1 | Week2 | Week3
 | 1
 | 2
 | 3
 | 4
 | 5
Spreadsheet: 88712d1288572706-creating-monthly-cost-schedule-dummy-workbook
Sheet: Monthly

 | Development |  |  |  |  |  |  |  |  |  |  |  |  |  | Fiscal |  |  |  |  |  |  |  |  |  |  |  |  |  | Fiscal |  |  |  |  |  |  |  |  |  |  |  |  |  | Fiscal |  |  |  |  |  |  |  |  |  |  |  |  |  | Fiscal |  |  |  |  |  |  |  |  |  |  |  |  |  | Fiscal
 |  |  | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2010 |  | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2011 |  | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2012 |  | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2013 |  | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2014
 | Development Costs
 | Analysis
 | Development
 | Total Development Costs
Spreadsheet: 756970d1637914443-text-formula-for-2022-sample-book
Sheet: Sheet1

 |  | Start Time | Month | Week |  |  |  |  |  | Start finishing | End finishing
 |  |  |  |  |  |  |  |  |  | 21.11.21 14:28 | 23.11.21 22:04
 |  |  |  |  |  |  |  |  |  | 22.11.21 06:00 | 22.11.21 17:59
 |  |  |  |  |  |  |  |  |  | 23.11.21 06:00 | 23.11.21 17:59
 |  |  |  |  |  |  |  |  |  | 23.11.21 22:04 | 26.11.21 10:13
 |  |  |  |  |  |  |  |  |  | 24.11.21 18:00 | 25.11.21 05:59
 |  |  |  |  |  |  |  |  |  | 25.11.21 18:00 | 26.11.21 05:59
 |  |  |  |  |  |  |  |  |  | 26.11.21 10:13 | 29.11.21 19:18
 |  |  |  |  |  |  |  |  |  | 29.11.21 19:18 | 30.11.21 05:04
 |  |  |  |  |  |  |  |  |  | 30.11.21 05:04 | 01.12.21 00:02
 |  |  |  |  |  |  |  |  |  | 30.11.21 06:00 | 30.11.21 17:59
 |  |  |  |  |  |  |  |  |  | 01.12.21 00:02 | 02.12.21 01:43
 |  |  |  |  |  |  |  |  |  | 01.12.21 06:00 | 01.12.21 17:59
 |  |  |  |  |  |  |  |  |  | 02.12.21 01:43 | 04.12.21 11:43
 |  |  |  |  |  |  |  |  |  | 02.12.21 18:00 | 03.12.21 05:59
 |  |  |  |  |  |  |  |  |  | 03.12.21 18:00 | 04.12.21 05:59
 |  |  |  |  |  |  |  |  |  | 04.12.21 11:43 | 08.12.21 00:54
 |  |  |  |  |  |  |  |  |  | 08.12.21 00:54 | 10.12.21 13:54
 |  |  |  |  |  |  |  |  |  | 08.12.21 06:00 | 08.12.21 17:59
 |  |  |  |  |  |  |  |  |  | 09.12.21 06:00 | 09.12.21 17:59
 |  |  |  |  |  |  |  |  |  | 10.12.21 13:54 | 16.12.21 04:47
 |  |  |  |  |  |  |  |  |  | 10.12.21 18:00 | 11.12.21 05:59
 |  |  |  |  |  |  |  |  |  | 11.12.21 18:00 | 12.12.21 05:59
 |  |  |  |  |  |  |  |  |  | 14.12.21 06:00 | 14.12.21 17:59
 |  |  |  |  |  |  |  |  |  | 15.12.21 06:00 | 15.12.21 17:59
 |  |  |  |  |  |  |  |  |  | 16.12.21 04:47 | 20.12.21 07:07
 |  |  |  |  |  |  |  |  |  | 16.12.21 06:00 | 18.12.21 05:59
 |  |  |  |  |  |  |  |  |  | 18.12.21 18:00 | 19.12.21 05:59
 |  |  |  |  |  |  |  |  |  | 19.12.21 18:00 | 20.12.21 05:59
 |  |  |  |  |  |  |  |  |  | 20.12.21 07:07 | 20.12.21 18:46
 |  |  |  |  |  |  |  |  |  | 20.12.21 18:46 | 01.01.22 18:32
 |  |  |  |  |  |  |  |  |  | 22.12.21 06:00 | 22.12.21 17:59
 |  |  |  |  |  |  |  |  |  | 23.12.21 06:00 | 23.12.21 17:59
 |  |  |  |  |  |  |  |  |  | 24.12.21 06:00 | 31.12.21 17:59
 |  |  |  |  |  |  |  |  |  | 01.01.22 18:32 | 01.01.22 21:52
 |  |  |  |  |  |  |  |  |  | 01.01.22 21:52 | 03.01.22 10:42
 |  |  |  |  |  |  |  |  |  | 03.01.22 10:42 | 11.01.22 17:25
 |  |  |  |  |  |  |  |  |  | 11.01.22 17:25 | 13.01.22 01:33
 |  |  |  |  |  |  |  |  |  | 13.01.22 01:33 | 13.01.22 17:11
 |  |  |  |  |  |  |  |  |  | 13.01.22 17:11 | 14.01.22 05:07
 |  |  |  |  |  |  |  |  |  | 14.01.22 05:07 | 14.01.22 20:45
 |  |  |  |  |  |  |  |  |  | 14.01.22 20:45 | 14.01.22 23:53
 |  |  |  |  |  |  |  |  |  | 14.01.22 23:53 | 15.01.22 06:08
 |  |  |  |  |  |  |  |  |  | 15.01.22 06:08 | 15.01.22 11:33
 |  |  |  |  |  |  |  |  |  | 15.01.22 11:33 | 15.01.22 18:13
 |  |  |  |  |  |  |  |  |  | 15.01.22 18:13 | 16.01.22 00:53
 |  |  |  |  |  |  |  |  |  | 16.01.22 00:53 | 16.01.22 07:33
Spreadsheet: 3e101825-6027-4c9e-a7aa-0b74295f2f0d
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
OXU | Test | OXU | Oxalate, [NAME] | Oxalate, U | Enzymatic Using Oxalate Oxidase | [NAME], 24-hour graduated: 24Urine |  |  | 5 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) or a clean, plastic aliquot container with no metal cap or glued insert [NAME]: 5 mL Collection Instructions: 1. Collect urine for 24 hours. 2. Add 30 mL of toluene as preservative at start of collection or refrigerate specimen during and after collection. 3. Specimen pH should be between 4.5 and 8 and will stay in this range if kept refrigerated. Specimens with pH >8 indicate bacterial contamination, and testing will be cancelled. Do not attempt to adjust pH as it will adversely affect results. Additional Information: 1. 24-Hour volume is required. 2. Avoid taking large doses (>2 g orally/24 hours) of vitamin C during specimen collection. 3. See [NAME] in Special Instructions for multiple collections.    Urine Preservative Collection Options Ambient	No Refrigerated	Yes Frozen	Yes 6N HCl	No 50% Acetic Acid	No Na2CO3	No Toluene	Preferred 6N HNO3	No Boric Acid	No Thymol	Yes | 5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	[NAME] collected or sent in container with metal cap | 0.11-0.46 mmol/specimen 9.7-40.5 mg/specimen The reference value is for a 24-hour collection. Specimens collected for other than a 24-hour time period are reported in unit of mmol/L for which reference values are not established. | Sunday through Friday | 3 days | 5 days | 1 | 83945 |  |  |  |  | Rochester
OXU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
OXU | Order Question | TM17 | Collection Duration |  | Plain Text
OXU | Order Question | VL15 | [NAME] |  | Plain Text
OXU | Result | OCATE | Oxalate, U | Oxalate, U | Numeric |  |  |  |  | mmol/spec |  |  |  |  |  |  |  |  |  | 14862-7 | Oxalate:SRat:24H:[NAME]:Qn:
OXU | Result | OXU1 | Oxalate, U | Oxalate, U | Numeric |  |  |  |  | mg/spec |  |  |  |  |  |  |  |  |  | 2701-1 | Oxalate:MRat:24H:Urine:Qn:
OXU | Result | TM17 | Collection Duration | Collection Duration | Numeric |  |  |  |  | h |  |  |  |  |  |  |  |  |  | 13362-9 | Collection duration:Time:*:Urine:Qn:
OXU | Result | VL15 | [NAME] | [NAME] | Numeric |  |  |  |  | mL |  |  |  |  |  |  |  |  |  | 28009-9 | [NAME] volume:Vol:Pt:[NAME]:Qn:
OXU | Result | OX_A | Ox Conc (mmol/L) | Ox Conc (mmol/L) | Numeric |  |  |  |  | mmol/L |  |  |  |  |  |  |  |  |  | 34349-1 | Oxalate:SCnc:24H:[NAME]:Qn:
OXU | Result | OXCN2 | Oxalate Concentration | Oxalate Concentration | Numeric |  |  |  |  | mg/L |  |  |  |  |  |  |  |  |  | 27222-9 | Oxalate:MCnc:24H:[NAME]:Qn:
Spreadsheet: 858543d1707193546-addition-of-points-that-meet-certain-conditions-x-country-results-v1
Sheet: BOYS

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PARTICIPATION POINTS
 | 1ST PLACE | TIME | HOUSE | POINTS |  | 2ND PLACE | TIME | HOUSE | POINTS |  | 3RD PLACE | TIME | HOUSE | POINTS |  | 4TH PLACE | TIME | HOUSE | POINTS |  | Tibro | Coochin | Coonowrin
8 BOYS |  |  | Coonowrin | 5 |  |  |  | Tibro | 4 |  |  |  | Coochin | 3 |  |  |  | Tibro | 2 |  | 6 | 3 | 5 | I want these to populate automatically. Maybe an IF THEN rule?
9 BOYS |  |  | Tibro | 5 |  |  |  |  | 4 |  |  |  |  | 3 |  |  |  |  | 2 |  |  |  |  | Each age group will be the same.
10 BOYS |  |  | Coochin | 5 |  |  |  |  | 4 |  |  |  |  | 3 |  |  |  |  | 2
11 BOYS |  |  | Tibro | 5 |  |  |  |  | 4 |  |  |  |  | 3 |  |  |  |  | 2
12 BOYS |  |  | Tibro | 5 |  |  |  |  | 4 |  |  |  |  | 3 |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OVERALL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tibro
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Coochin
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Coonowrin
Spreadsheet: 197378d1354312598-how-to-determine-the-number-of-hours-and-minutes-between-a-start-time-and-an-end-time-time-calculator
Sheet: week starting 112612

Time Sheet Calculator
For Week Starting: | 2012-11-26 00:00:00
 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday
Time In (am) | 09:00:00
Time Out (pm) | 05:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | Weekly Hours
Daily Hours
Spreadsheet: 686069d1594346755-having-problem-with-a-formula-to-find-average-every-10-rows-1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Spreadsheet: 132207d1323598690-creating-individual-rosters-from-raw-data-roster-example_jpr73
Sheet: PT

Manager | (Tous)
Emp ID | Emp Name
1111 | Employee 1
1112 | Employee 2
1113 | Employee 3
1114 | Employee 4
1115 | Employee 5
1116 | Employee 6
1117 | Employee 7
1118 | Employee 8
1119 | Employee 9
1120 | Employee 10
1121 | Employee 11
1122 | Employee 12
1123 | Employee 13
1124 | Employee 14
1125 | Employee 15
Spreadsheet: 27e1dbf7-f1c1-411a-b889-7c91ea7ccb53
Sheet: 9a

Product1 | Cleared2 | Uncleared | TOTAL
Fixed-Float | 723387 | 415575 | 1138962
FRA | 17061 | 53783 | 70844
OIS | 22032 | 66542 | 88574
OTHER* | 4498 | 204391 | 208889
TOTAL | 766978 | 740291 | 1507269
*OTHER variable includes the following products: Basis, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, Inflation, and Swaption.
Spreadsheet: 849719d1700133846-help-with-data-validation-on-a-cell-containing-a-formula-2023-tracking-1-aligw
Sheet: Tracker

Select Students | DATE | Helper | PERIOD | SUBJECT | TEACHER | REASON
Adams, J | 2023-11-14 00:00:00
[NAME], A | 2023-11-15 00:00:00
Bertin, G | 2023-11-14 00:00:00
Adams, J | 2023-11-14 00:00:00
Spreadsheet: 142517d1329882731-excel-2007-consolidating-different-values-under-different-names-indifferent-tabs-to-master-sheet-varification-doc
Sheet: NEW ASHOK N AGAR

NEW ASHOK NAGAR |  |  |  |  |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE |  |  |  | NEHRU PLACE
SNO | Part Code | Description | Qty | Qty (As on Date 16th Jan-2012)
Section-V,  Part A, SNO-3, 5 | PE-SV Router, PE-SDN Router |  | 1
Existing Material Redeployment
A | Power System
 | 10 KVA PP (3+1)x100-10 |  | 1
 | 100 A modules |  | 3
 | 1000 AH Battery |  | 2
Spreadsheet: darrell_schoolcraft__7783__imbalsumm0107
Sheet: EPFS

 | El Paso/TW Eddy Rec
 | 78093
Day | Measured | Scheduled
1 | 41397 | 40000
2 | 45176 | 42000
3 | 44413 | 42000
4 | 42918 | 40464
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-06-30 00:00:00 |  |  | -72391
2001-07-04 00:00:00
Spreadsheet: 3006f388-28ea-4855-9048-2656f3e8448c
Sheet: Sheet1

Unnamed: 0 | SVG Coater and [NAME] Use Only | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | Week of Feb. 8 - Feb. 14
 |  | 1um | 1.6um | 7um | 1um | 1.6um | 3um | 1um | 1.6um | 3um
SVG                         Coater | Date (Coat) | 2009-02-10 00:00:00 | 2009-02-10 00:00:00 | 2009-02-10 00:00:00 | 2009-02-10 00:00:00 | 2009-02-10 00:00:00 | 2009-02-10 00:00:00
 | Track | 1 | 1 | 1 | 2 | 2 | 2
 | Prime Program | Yes Oven | Yes Oven | Yes Oven | Yes Oven | Yes Oven | Yes Oven
 | Coat Program | 7 | 8 | 4 | 7 | 8 | 4
 | Oven Program | 1 | 2 | 3 | 1 | 2 | 3
 | Problems
Thickness Measurements                                (NanoSpec) | Date (Measurement) | 2009-02-10 00:00:00 | 2009-02-10 00:00:00 | 2009-02-10 00:00:00 | 2009-02-10 00:00:00 | 2009-02-10 00:00:00 | 2009-02-10 00:00:00 | - | - | -
 | Top (A) | 10315 | 17087 | 72633 | 10260 | 17053 | 30265 | - | - | -
 | Center (A) | 10280 | 17085 | 72582 | 10198 | 17056 | 30232 | - | - | -
 | Flat (A) | 10298 | 17092 | 72593 | 10222 | 17062 | 30206 | - | - | -
 | Left  (A) | 10345 | 17081 | 72627 | 10232 | 17057 | 30289 | - | - | -
 | Right (A) | 10309 | 17089 | 72640 | 10212 | 17044 | 30230 | - | - | -
 | Average (A) | 10309 | 17087 | 72615 | 10225 | 17054 | 30244 | - | - | -
 | [NAME]  (A) | 24 | 4 | 26 | 23 | 7 | 33 | - | - | -
 | Comments
Exposure | Date (Exposure) | 2009-02-10 00:00:00 | 2009-02-10 00:00:00 | 2009-02-10 00:00:00 | 2009-02-10 00:00:00 | 2009-02-10 00:00:00 | 2009-02-10 00:00:00
 | Tool | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | EValign | EValign | EValign
 | Contact Type | Vac. | Vac. | Vac. | Vac. | Vac. | Vac.
 | Exposure Time | 1.0s | 1.4s | 3.0s x2 | 1.0s | 1.4s | 3.0s
 | Problems
SVG                            Developer | Date (Develop) | 2008-10-07 00:00:00 | 2008-10-07 00:00:00 | 2008-10-07 00:00:00 | 2008-10-07 00:00:00 | 2008-10-07 00:00:00 | 2008-10-07 00:00:00
 | Track | 1 | 1 | 1 | 2 | 2 | 2
 | Pre-bake Program | 1 | 2 | none | 1 | 2 | none
 | Develop Program | 3 | 4 | 6 | 3 | 4 | 7
 | Post-base Program | 1 | 2 | none | 1 | 2 | none
 | Problems
Resolution                         Measurements | Date (Measurement) | 2009-02-12 00:00:00 | 2009-02-12 00:00:00 | 2009-02-12 00:00:00 | 2009-02-12 00:00:00 | 2009-02-12 00:00:00 | 2009-02-12 00:00:00
 | Top (H/V) (um) | 2.5/3 | 2/2.5 | 3/4 | 2/2.5 | 5/10 | 2/3.5
 | Center (H/V) (um) | 2.5/3 | 1.5/1.5 | 3/3 | 1.5/2.5 | 4.5/4.5 | 2/2
 | Flat (H/V) (um) | 2.5/3 | 2/1.5 | 3/3 | 1.5/2.5 | 4.5/4.5 | 1.5/2.5
 | Left (H/V) (um) | 2.5/3 | 1.5/1.5 | 3/3.5 | 1.5/2 | 4.5/5 | 1.5/2
 | Right (H/V) (um) | 2.5/3 | 1.5/1.5 | 3/3 | 2/2 | 4.5/5 | 2/2.5
 | Comments | underexposed | overexposed | dark edges overexposed | overexposed | very overexposed | overexposed
Spreadsheet: 769438d1645539746-search-for-numerical-value-and-in-column-in-a-table-then-return-text-from-another-column-excel-help-etaf2
Sheet: Week 1

 |  |  |  |  |  |  |  |  |  |  | Total Cost / Meal | Main Meal | Over-order
 |  |  |  |  |  |  |  |  |  |  |  |  | Required: | 13 | 15 | 8 | 12 | 10 | 19 | 12 | 12 | 15 | 19
 |  |  |  |  |  |  |  |  |  |  |  |  | Type
 |  |  |  |  |  |  |  |  |  |  |  |  | Meal
 |  |  |  |  |  |  |  |  |  |  |  |  | MWM
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Side 1
 |  |  |  |  |  |  |  |  |  |  |  |  | Side 2
 |  |  |  |  |  |  |  |  |  |  |  |  | Price
 |  |  |  |  |  |  |  |  |  |  | Total Cost / Pudding | Pudding | Over-order
 |  |  |  |  |  |  |  |  |  |  |  |  | Required: | 13 | 15 | 8 | 12 | 10 | 19 | 12 | 12 | 15 | 19
 |  |  |  |  |  |  |  |  |  |  |  |  | Type
 |  |  |  |  |  |  |  |  |  |  |  |  | MWM
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Price
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday
 |  |  |  |  |  |  |  |  |  |  |  |  | 10 | Lunch | Tea | Lunch | Tea | Lunch | Tea | Lunch | Tea | Lunch | Tea
Product Name | Category | Product Code | Pack Size | Recommended Portions | [NAME] | Made Without Milk | Vegetarian | Vegan | Price | Price per Meal | Type | Cat | Cost per Meal | Order | Order | Order | Order | Order | Order | Order | Order | Order | Order
MAINS
Pork Meatballs in Tomato & Herb Sauce | Pork | 328617 | Small | 4 |  |  |  |  | 5.56 |  | Main Meal
Sausage & Ham Frittata | Pork | 328624 | Small | 4 |  |  |  |  | 5.56 |  | Main Meal |  |  | 1 |  |  | 1
[NAME] in Creamy Mushroom Sauce | Poultry | 328443 | Small | 4 | • |  |  |  | 5.56 |  | Main Meal |  |  |  | 1
[NAME] in Tomato & Basil Sauce | Poultry | 328447 | Small | 4 | • |  |  |  | 5.56 |  | Main Meal |  |  |  |  | 1
[NAME] | Poultry | 328448 | Small | 4 |  |  |  |  | 5.56 |  | Main Meal |  |  |  |  |  |  |  | 1
Fish in Cheese Sauce | Fish | 328523 | Small | 4 | • |  |  |  | 5.56 |  | Main Meal |  |  |  |  |  |  |  |  |  |  | 1
Cod in Parsley Sauce | Fish | 328527 | Small | 4 | • |  |  |  | 5.56 |  | Main Meal |  |  |  |  |  |  | 1
[NAME] | Beef | 328101 | Small | 2 |  |  |  |  | 5.56 |  | Main Meal |  |  |  |  |  |  |  |  |  | 1
Cottage Pie | Beef | 328114 | Small | 2 | • |  |  |  | 5.56 |  | Main Meal
DESSERTS
Spotted Dick | Hot Desserts | 328816 | Small | 6 |  |  | • |  | 1.51 |  | Pudding | Cold Desserts |  |  |  |  |  | 1 |  |  |  | 1
Chef's Rice Pudding | Hot Desserts | 324824 | Large | 16 | • |  | • |  | 2.87 |  | Pudding |  |  |  | 1 |  |  |  |  |  |  |  | 1
Chef's Rice Pudding | Hot Desserts | 328824 | Small | 5 | • |  | • |  | 1.39 |  | Pudding |  |  |  |  | 1
Spreadsheet: 793049d1661274623-formula-that-subtract-from-available-stock-and-leaving-the-balance-formula-left-stock
Sheet: Sheet1

Item | On Order | On Hand Inv
123 | 10 | 50
123 | 5
123 | 10
123 | 10
126 | 10 | 100
126 | 5
126 | 5
 |  |  |  | We have a vlookup formula on C that brings the On Hand for the 123 Item. The [NAME] repeasts it self couple of times due the orders Open. Need to have the balance left on the same column taking into consideration that the Item could change
 |  |  |  | As you can see on my example.
 |  |  |  | Need a forumula, that sumifs the other sheet, bring the On Hand, then stracts from the first order to see what is left On hand.
 |  |  |  | But if the [NAME] change, it brings the next Oh Hand.
Spreadsheet: 489612d1479355214-long-if-string-example5
Sheet: Sheet1

 | Amount | Appropriate column G # from the table |  |  | Table array
 | 19000 |  |  |  | >0 | 0.1
 | 75000 |  |  |  | >18551 | 0.15
 | 250000 |  |  |  | >73301 | 0.25
 | 300000 |  |  |  | >151901 | 0.28
 | 420000 |  |  |  | >231451 | 0.33
 |  |  |  |  | >413351 | 0.35
 |  |  |  |  | >466951 | 0.396
 | Column C should populate with the appropriate number from column G
 | As an example, cell C2 would have .15
 | Cell [NAME] would have .25
 | Cell C4 would have .33
 | Cell C4 would have
 | Etc
Spreadsheet: 843487d1695301030-extract-field-into-columns-with-matching-title-sample
Sheet: Sheet1

Composition | CO | PES | bci-CO | r-PES | EOL | CP | MA | VI FR | AR
100% CO | 100
60% CO 40% PES | 60 | 40
65% PES 35% CO | 35 | 65
40% MA 24% VI FR 20% PES 10% CO 4% AR 2% CP | 10 | 20 |  |  |  | 2 | 40 | 24 | 4
34% PES 33% bci-CO 30% r-PES 3% EOL |  | 34 | 33 | 30 | 3