tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 540083d1506526334-contract-expiry-date-graph-timeline-to_r
Sheet: l

ID | Country Product Type | Столбец1 | Contract Type Contract Status | Столбец2 | Date Negotiations Started | to renew | Current Extension
Party 1 | UK | LCD TV | Renewal | Signed | 2016-09-30 00:00:00
Party 2 | UK | LCD TV | Renewal | Signed | 2016-09-30 00:00:00 |  | 2017-08-31 00:00:00
Party 3 | UK | LCD TV | Renewal | Signed | 2016-09-30 00:00:00 |  | 2017-08-31 00:00:00
Party 4 | UK | LCD TV | Renewal | Signed | 2016-09-30 00:00:00 |  | 2017-08-31 00:00:00
Party 5 | Spain | HDTV | Renewal | Still Negotiating | 2013-09-30 00:00:00 |  | 2017-09-30 00:00:00
Party 6 | Spain | HDTV | Renewal | Still Negotiating | 2017-05-30 00:00:00 |  | 2018-02-28 00:00:00
Party 7 | Spain | HDTV | Renewal | Still Negotiating | 2015-01-15 00:00:00 |  | 2017-09-30 00:00:00
Party 8 | Spain | HDTV | Renewal | Still Negotiating | 2016-01-31 00:00:00 |  | Autorenew
Spreadsheet: 721001d1614424868-combining-data-2-tabs-ktype-werkfile-01032021
Sheet: resultaat

KTYPE | MOD_ID | SKU
8683 | 10164 | 102606
8684 | 10164 | 102606
8685 | 10164 | 102606
8686 | 10164 | 102606
21101 | 10164 | 102606
21141 | 10164 | 102606
21142 | 10164 | 102606
30516 | 10164 | 102606
33804 | 10164 | 102606
33807 | 10164 | 102606
33823 | 10164 | 102606
33929 | 10164 | 102606
58650 | 10164 | 102606
107418 | 10164 | 102606
107419 | 10164 | 102606
108642 | 10164 | 102606
109333 | 10164 | 102606
111924 | 10164 | 102606
112328 | 10164 | 102606
117336 | 10164 | 102606
117338 | 10164 | 102606
122065 | 10164 | 102606
122133 | 10164 | 102606
122134 | 10164 | 102606
126303 | 10164 | 102606
126304 | 10164 | 102606
126685 | 10164 | 102606
130989 | 10164 | 102606
131564 | 10164 | 102606
137034 | 10164 | 102606
138228 | 10164 | 102606
8683 | 10164 | 104962
8684 | 10164 | 104962
8685 | 10164 | 104962
8686 | 10164 | 104962
21101 | 10164 | 104962
21141 | 10164 | 104962
21142 | 10164 | 104962
30516 | 10164 | 104962
33804 | 10164 | 104962
33807 | 10164 | 104962
33823 | 10164 | 104962
33929 | 10164 | 104962
58650 | 10164 | 104962
107418 | 10164 | 104962
107419 | 10164 | 104962
108642 | 10164 | 104962
109333 | 10164 | 104962
111924 | 10164 | 104962
112328 | 10164 | 104962
117336 | 10164 | 104962
117338 | 10164 | 104962
122065 | 10164 | 104962
122133 | 10164 | 104962
122134 | 10164 | 104962
126303 | 10164 | 104962
126304 | 10164 | 104962
126685 | 10164 | 104962
130989 | 10164 | 104962
131564 | 10164 | 104962
137034 | 10164 | 104962
138228 | 10164 | 104962
Spreadsheet: c702cb1f-dda5-45ed-9b99-75e89c4177a7
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259305 | 13030 | Karin | Schulz | GER | 1075 | 00:52:41 | 00:04:51 | 03:51:04 | 00:08:18 | 02:07:37 | 1 | [NAME]
259305 | 13028 | Montserrat | Clavero | ESP | 1078 | 00:55:34 | 00:06:26 | 04:02:19 | 00:07:24 | [NAME] | 2 | 07:22:18
259305 | 70912 | Lyndsay | Gough | NZL | 1077 | 00:55:59 | 00:05:29 | 04:15:41 | 00:08:10 | 02:22:08 | 3 | 07:47:30
Spreadsheet: stacey_white__38805__Flex Schedule Calendar
Sheet: Jul-01

JULY 2001
 | 2 | [NAME] | 3 |  | 4 | [NAME] | 5 | [NAME] | 6
 |  | [NAME] |  |  |  | J.P. |  | J.P.
 |  | [NAME] |  |  |  | [NAME] |  | [NAME]
 |  | [NAME] |  |  |  | [NAME] |  | [NAME] out by 6:30 (plane)
 |  | [NAME] |  |  |  | [NAME]-Vacation------ |  | -----------------------
 |  |  |  |  |  | Donnie-Vacation------ |  | -----------------------
 |  | J.P. out at 2:30 |  |  |  | [NAME]-Vacation--------- |  | -----------------------
[NAME] | 9 | [NAME] | 10 | [NAME] | 11 | [NAME] | 12 | [NAME] | 13
J.P. |  | [NAME] |  | [NAME] |  | [NAME] |  | J.P.
[NAME] |  | [NAME] |  | [NAME] |  | J.P. |  | [NAME]
[NAME] | 16 | [NAME] | 17 | [NAME] | 18 | [NAME] | 19 | [NAME] | 20
[NAME] |  | J.P. |  | [NAME] |  | [NAME] |  | [NAME]
[NAME] |  | [NAME] |  | J.P. |  | [NAME] |  | [NAME]
------------Tickets from Lavo-------------
[NAME]-Portland------ |  | ------------------------ |  | ------------------------ |  | ------------------------ |  | Casey-Vac (Comp)---
[NAME] | 23 | [NAME] | 24 | [NAME] | 25 | [NAME] | 26 | [NAME] | 27
[NAME] |  | J.P. |  | [NAME] |  | [NAME] |  | [NAME]
J.P. |  | [NAME] |  | [NAME] |  | J.P. |  | [NAME]
 |  |  |  |  |  |  |  | Hai-Vac (Dis Hol)--
Marilyn-Vacation------ |  | ------------------------ |  | ------------------------ |  | ------------------------ |  | ------------------------
[NAME] | 30 |  | 31 |  | 1 |  | 2 |  | 3
[NAME]
[NAME]
* If your name is listed that means you are working late that day (whatever 'late' means!)
[NAME] |  |  |  | 16 applicable days through 6/29/01
[NAME] |  |  |  | 32 available early slots (excluding Donnie/Casey)
[NAME]
J.P.
[NAME]
[NAME]
Hai
Spreadsheet: 548640d1511248411-extract-data-in-excel-test-for-excel-forum
Sheet: Sheet1

DATA FILE LIKE THIS
No. | NAME | Sanc Amount | Sanc Date | Exp Date |  | WANT CHANGES LIKE THIS
 |  | Disb Amount | Disb Date | Overdue Date |  | No. | NAME | Sanc Amount | Sanc Date | Exp Date | Disb Amount | Disb Date | Overdue Date | Instalment Amount | Inst Date | Date
 |  | Instalment Amount | Inst Date | Date |  | 10-810-7 | THE FRAGILE INTERNATIONAL | 310000 | 05-12-2002 | 05-03-2013 | 310000 | 05-12-2002 | 30-06-1999 | 2585 | 27-09-2008
10-810-7 | THE FRAGILE INTERNATIONAL | 310000 | 05-12-2002 | 05-03-2013 |  | 10-810-17 | IMPEX TRADING CO | 900000 | 09-11-2009 | 09-12-2016 | 900000 | 09-11-2009 | 24-04-2014 | 16619 | 09-01-2010
 |  | 310000 | 05-12-2002 | 30-06-1999 |  | 11-805-4 | PAGNASARE DESIGNERS | 200000 | 27-06-2013 | 27-06-2018 | 200000 | 27-06-2013 | 05-11-2015 | 4758 | 27-07-2013
 |  | 2585 | 27-09-2008
10-810-17 | IMPEX TRADING CO | 900000 | 09-11-2009 | 09-12-2016
 |  | 900000 | 09-11-2009 | 24-04-2014
 |  | 16619 | 09-01-2010
11-805-4 | PAGNASARE DESIGNERS | 200000 | 27-06-2013 | 27-06-2018
 |  | 200000 | 27-06-2013 | 05-11-2015
 |  | 4758 | 27-07-2013
Spreadsheet: 681925d1591816810-combine-data-from-multiple-sheets-into-one-book1
Sheet: Consolidated

Control # | Validation Number | Procedure Name | Objective | Preparation | Procedure Script | Expected Results
Pulled in from CO A2 | Pulled in from CO B2 | Pulled in from CO C2 | etc. | etc. | etc. | etc.
Pulled in from CO A3 | Pulled in from CO B3 | Pulled in from CO C3 | etc. | etc. | etc. | etc.
Pulled in from CO A4 | Pulled in from CO B4 | Pulled in from CO C4 | etc. | etc. | etc. | etc.
Pulled in from CO A5 | Pulled in from CO B5 | Pulled in from CO C5 | etc. | etc. | etc. | etc.
Pulled in from DC A2 | Pulled in from DC B2 | Pulled in from DC C2 | etc. | etc. | etc. | etc.
Pulled in from DC A3 | Pulled in from DC B3 | Pulled in from DC C3 | etc. | etc. | etc. | etc.
Pulled in from DC A4 | Pulled in from DC B4 | Pulled in from DC C4 | etc. | etc. | etc. | etc.
Pulled in from DC A5 | Pulled in from DC B5 | Pulled in from DC C5 | etc. | etc. | etc. | etc.
Pulled in from EC A2 | Pulled in from DC B2 | Pulled in from EC B2 | etc. | etc. | etc. | etc.
Pulled in from EC A3 | Pulled in from DC B3 | Pulled in from EC B3 | etc. | etc. | etc. | etc.
Pulled in from EC A4 | Pulled in from DC B4 | Pulled in from EC B4 | etc. | etc. | etc. | etc.
Pulled in from EC A5 | Pulled in from DC B5 | Pulled in from EC B5 | etc. | etc. | etc. | etc.
Pulled in from EC A6 | Pulled in from DC B6 | Pulled in from EC B6 | etc. | etc. | etc. | etc.
Spreadsheet: 792074d1660729454-get-dates-from-a-row-and-put-it-into-a-column-forum-upload
Sheet: Calculator

 |  | Check in | Check out
 |  | 2022-08-09 00:00:00 | 2022-09-29 00:00:00
 | 1 | 2 | 3 | 4 | 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 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14 | Column15 | Column16 | Column17 | Column18 | Column19 | Column20 | Column21 | Column22 | Column23 | Column24 | Column25 | Column26 | Column27 | Column28 | Column29 | Column30 | Column31 | Column32 | Column33 | Column34 | Column35 | Column36 | Column37 | Column38 | [NAME] | Column40 | Column41 | Column42 | Column43 | Column44 | Column45 | Column46 | Column47 | Column48 | Column49 | Column50 | Column51
CHECK IN
CHECK OUT
 |  | Check in |  | Check out
 |  | 2022-08-09 00:00:00 |  | 2022-08-16 00:00:00
 |  | 2022-08-24 00:00:00 |  | 2022-08-31 00:00:00
 |  | 2022-09-06 00:00:00 |  | 2022-09-13 00:00:00
 |  | CHECK IN | CHECK OUT
 |  | 2022-08-09 00:00:00 | 2022-08-16 00:00:00
 |  | 2022-08-24 00:00:00 | 2022-08-31 00:00:00
 |  | 2022-09-06 00:00:00 | 2022-09-13 00:00:00
 |  | 2022-09-21 00:00:00 | 2022-09-28 00:00:00
Spreadsheet: 674158d1587679513-automate-my-hobby-lemoncello-recipe-and-production-sheet-lemmonchello-recipe-for-disaster
Sheet: Sales

BUYER | DATE | 4 safran | 8 babicello | 9 chilli | 10 anice | 11 cannella | 13 arancia | 14 lime | 15 menta | 16 zenzero | 17 arancia | QTY 200 | QTY 60 | BOTTLE ML | VOLUME ML | ITEM PRICE | TOTAL REVENUE
[NAME] | 2020-04-20 00:00:00 |  |  | 1 |  |  |  | 1 | 1 |  |  | 3 |  | 200 |  | 10
 |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 60 |  | 0
[NAME] | 2020-04-20 00:00:00 |  |  | 1 |  |  |  | 1 | 1 |  |  |  |  | 200 |  | 10
 |  | 1 |  |  |  |  | 1 |  |  |  |  |  |  | 60 |  | 0
Evelin | 2020-04-20 00:00:00 |  |  | 1 |  |  |  | 1 |  |  | 1 |  |  | 200 |  | 10
 |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 60 |  | 0
Enel | 2020-04-21 00:00:00 |  |  | 1 |  | 1 |  |  |  |  | 1 |  |  | 200 |  | 10
 |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 60 |  | 0
[NAME] | 2020-04-21 00:00:00 |  |  | 1 |  |  |  | 1 |  |  | 1 |  |  | 200 |  | 10
 |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 60 |  | 0
[NAME] | 2020-04-21 00:00:00 |  |  | 1 | 1 |  |  |  |  |  | 1 |  |  | 200 |  | 10
 |  |  |  |  |  |  |  |  | 1 |  |  |  |  | 60 |  | 0
Jodi | 2020-04-22 00:00:00 |  |  | 1 |  |  |  | 1 |  |  | 1 |  |  | 200 |  | 10
 |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 60 |  | 0
[NAME] | 2020-04-23 00:00:00 |  |  | 1 |  | 1 |  |  |  | 1 | 1 |  |  | 200 |  | 7.5
 |  |  |  |  |  |  |  |  | 1 |  |  |  |  | 60 |  | 0
[NAME] | 2020-04-23 00:00:00 |  |  | 1 | 1 |  |  |  |  |  | 1 |  |  | 200 |  | 10
 |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 60 |  | 0
Spreadsheet: 70693d1271409775-if-formula-not-reporting-desired-solution-wj-fire-door-schedule
Sheet: Info&Calcs

 | FIRE | FINISH |  | FRAME |  |  | 30 min
NO | NON FR | PRIMED |  | TULIP WOOD - kg/m3 |  |  | jamb |  | head
YES | FD60 | PAINTED |  | SAPELE - 640 kg/m3 |  | 'NON FR | NO SEALS |  | 'NON FR | NO SEALS
 | FD30 | POLISHED |  | HARDWOOD |  | FD30 |  |  | FD30
 |  | VENEERED |  |  |  | FD60 | 2X15x4mm Seal |  | FD60 | 111
Spreadsheet: 01153571-a5aa-4c2d-a373-b56c600a69a0
Sheet: Sheet1

TABLE 1 | 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 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21
MULTIPLE REGISTRANTS
UNIVERSITY OF HAWAI‘I
(Unduplicated Headcount Across the UH System)
 |  |  |  |  |  |  |  |  |  |  | Number of Campuses at Which Students Are Enrolled
Fall |  |  | Total |  | Students Enrolled |  |  | Multiple
Semester |  |  | Unduplicated |  | at Only 1 Campus |  |  | Registrants |  |  | Two |  |  | Three |  |  | Four |  |  | Five
 |  |  | Headcount |  | No. | H% |  | Subt | H% |  | No. | H% |  | No. | H% |  | No. | H% |  | No. | H%
 | Fall 2008 |  | 50090 |  | 46962 | 93.76 |  | 3128 | 6.24 |  | 2841 | 5.67 |  | 268 | 0.54 |  | 17 | <0.1 |  | 2 | <0.1
 | Fall 2007 |  | 47621 |  | 45018 | 94.53 |  | 2603 | 5.47 |  | 2389 | 5.02 |  | 199 | 0.42 |  | 14 | <0.1 |  | 1 | <0.1
 | Fall 2006 |  | 47391 |  | 45036 | 95.03 |  | 2355 | 4.97 |  | 2136 | 4.51 |  | 197 | 0.42 |  | 19 | <0.1 |  | 3 | <0.1
 | Fall 2005 |  | 47763 |  | 45577 | 95.42 |  | 2186 | 4.58 |  | 1994 | 4.17 |  | 177 | 0.37 |  | 14 | <0.1 |  | 1 | <0.1
 | Fall 2004 |  | 48246 |  | 46125 | 95.6 |  | 2121 | 4.4 |  | 1940 | 4.02 |  | 162 | 0.34 |  | 17 | <0.1 |  | 2 | <0.1
 | Fall 2003 |  | 48347 |  | 46527 | 96.24 |  | 1820 | 3.76 |  | 1683 | 3.48 |  | 124 | 0.26 |  | 13 | <0.1 |  | 0 | 0
 | Note:  System unduplicated headcount = Students Enrolled at Only 1 Campus + subtotal Multiple Registrants.
 | This table counts each student only once for the University of Hawai‘i system.
 | Source:  [NAME];  Census data.
Spreadsheet: 75802d1276371099-consolidate-4-worksheets-into-1-copypastetest
Sheet: stand assembly

 | [NAME] of Materials | MTTS | stand assembly
MECHANICAL
Author: |  | Date initial: | 2010-05-19 00:00:00
 |  | Updated: | 2010-05-19 00:00:00
version:
Sequence | Designator | Type no. | Value | Footprint | Description | Nr. Required |  | price 1pc (US$) | Order code: | Note | Inspect 1 | Reference:
1 | bolt,nut,lock washer  M6 | inox |  | mount the wheel and box | M6x10 | 20
2 | plastic cover out side (bottom) | Pa |  | cover out side | plastic PA | 4
3 | stand for airpump | CT3 |  | to put on airpump | white paint | 1
4 | Star lock [NAME] | CT3 |  | to lock up and down | white paint | 2
5 | the part to hang the box | CT3 |  | keep the box hang on the stand | white paint | 1
6 | plastic cover out side (top) | plastic PA |  | cover out side | plastic PA | 1
7 | the arm hang silicone pipe | inox |  |  | Inox | 1
8 | wheel (have lock) | D 50mm |  |  | D50 mm | 4
9 | body stand | CT3 |  |  | white paint | 1
10 | bottom stand with wheel | CT3 |  |  | white paint | 1
Spreadsheet: 65912d1266527673-summary-list-list
Sheet: Page1

 | CONDITION1 | CONDITION2 | CONDITION3 | CONDITION4 | CONDITION5 |  | CONDITION1 | CONDITION2 | CONDITION3 | CONDITION4 | CONDITION5
PATIENT1
PATIENT2
PATIENT3
PATIENT4
PATIENT5
[NAME]
PATIENT7 |  |  |  |  |  |  | The idea is to set a formula here so I don't have to sort the patients by condition
PATIENT8 |  |  |  |  |  |  | Here is a simplification of the model but I have several conditions and hundreds of patients
[NAME]
PATIENT10
PATIENT11
PATIENT12
PATIENT13
PATIENT14
PATIENT15
PATIENT16
PATIENT17
Spreadsheet: 839878d1692277121-formula-to-count-entries-excluding-blank-cells-with-a-formula-excel4
Sheet: Sheet 1 input data

CHI | Outcome
[PHONE] | 4
[PHONE] | 0
[PHONE] | 5
[PHONE] | 0
[PHONE] | 3
[PHONE] | 0
[PHONE] | 4
[PHONE] | 0
[PHONE] | 0
[PHONE] | 0
[PHONE] | 0
[PHONE] | 0
[PHONE] | 5
[PHONE] | 0
[PHONE] | 0
[PHONE] | 0
[PHONE] | 1
[PHONE] | 1
[PHONE] | 0
[PHONE] | 0
[PHONE] | 0
[PHONE] | 6
[PHONE] | 0
[PHONE] | 6
Spreadsheet: 858053d1706830349-help-with-ifs-function-kansas-scheduler-v2-test-01302024-1-
Sheet: Digital

Press List | Print Time Calculations |  |  |  |  |  |  |  | Material |  | [NAME] |  |  | Links
 |  | [NAME] |  |  |  |  |  |  |  |  | 4 Pass | [NAME] |  | Large Job Gant Chart for KS.xlsx
 |  | HP/ 3R Formula |  |  |  |  |  |  |  |  | 5-Pass | 3R/HP |  | PACE JOBS FOR MS.xlsx
 |  | GS Formula |  |  |  |  |  |  |  |  | Heavy Smoothing | GS |  | Timeline Requests.xlsx
 |  | HS Formula |  |  |  |  |  |  |  |  | No Smoothing | HS |  | https://www.weprint.com/number-out-calculator.asp
Press | SchedTime | Due Date | Job# | Line# | Master [NAME] | QTY | H | W | Material | Sides | PrintMode | Kitting | #OfKits | Notes | DateRecieved | SqFt | LinearFT
[NAME]
3R |  | 2024-02-02 00:00:00 | 14574 | 2 | BBB | 250 | 20 | 20 |  | 1 | Backlit
[NAME] |  | 2024-02-06 00:00:00 | 444444 | 1 |  | 3000 | 25 | 48 |  | 1 | 4-Pass
[NAME] |  | 2024-01-31 00:00:00 | 123456 |  |  | 100 | 20 | 20 |  | 2 | 4-Pass
3R |  | 2024-02-05 00:00:00 | 789456
Canon |  | 2024-02-10 00:00:00 | 159357
Spreadsheet: 474013d1470575935-combine-data-multiple-data-linking
Sheet: Sheet1

Current Data
Material | Shipped at | Channel |  | Count of shipping areas: |  | Material | [NAME] | Channel
100 | London | Wholesale |  | Count of channels
101 | Russia | Retail
102 | India | Other
103 | China
Spreadsheet: 274801d1383224830-vlookup-index-match-excel-help-2
Sheet: Sheet2

 | CAT ID | 49 | 56 | 85 | 100 | 115
 | TOP PERFORMING ITEMS (NS$) |  |  |  |  |  | Lowest PERFORMING ITEMS (NS$)
Top | [NAME] | [NAME] | NS$ |  |  | Top | [NAME] | [NAME] | NS$
1 |  |  |  |  |  | 5
2 |  |  |  |  |  | 4
3 |  |  |  |  |  | 3
4 |  |  |  |  |  | 2
5 |  |  |  |  |  | 1
 | TOTAL |  | 0 |  |  |  | TOTAL |  | 0
Spreadsheet: 757041d1637954141-how-to-count-the-number-of-occurrences-of-a-number-within-a-string-of-text-stock-short-term-comparison-16
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | 1 | 2 | 3
1 ext 3c 1 ext 3c 5pt(alm a6pt w/ 1 ext) 3c patt |  |  |  |  |  |  |  |  |  | 2 | 0 | 0
1 ext 3c t2s(a3s) 3c 1 ext 3c 1 ext(a2/[NAME]) 4c 1 ext cl t3s/3pt cl t2s 4c t5-barely 6pt(s8pt???) 4c patt |  |  |  |  |  |  |  |  |  | 4 | 3 | 2
1 ext 4c 1 ext cl patt |  |  |  |  |  |  |  |  |  | 2 | 0 | 0
Spreadsheet: 206392d1358177412-tracking-construction-employee-hours-across-sheets-hours-per-installer-per-job-tracker
Sheet: Sheet3

 | Name | Part | Sept | Oct | Nov | Dec | Joined
 | Fred | a | 1 | 1 | 1 | 1
 | Fred | a | 1 | 1 | 1 | 1 |  |  | [NAME]
 | Barney | a | 1 | 1 | 1 | 1 |  |  | Part | a
 | Barney | a | 1 | 1 | 1 | 1 |  |  | Month
 | Wilma | a | 1 | 1 | 1 | 1
 | Wilma | b | 1 | 1 | 1 | 1 |  |  | Total Sales
 | [NAME] | a | 1 | 1 | 1 | 100
 | [NAME] | b | 1 | 1 | 1 | 1
 | [NAME] | a | 1 | 1 | 1 | 1
 | Heather | b | 1 | 1 | 1 | 1
 | [NAME] | a | 1 | 1 | 1 | 1
 |  |  |  | sumif | sumproduct
 | Name | Product | Month | Total | Total
 | [NAME] |  | Dec
SUMIF({"Freda";"Freda";"Barneya";"Barney a";"Wilmaa";"Wilmab";"Toma";"Joeb";" Chrisa";"Heatherb";"Chrisa"},"Toma",INDEX({1,1,1,1;1,1,1,1;1,1,1,1;1,1,1,1;1,1,1,1;1,1,1,1;1,1,1,100;1,1,1,1;1,1,1,1;1,1,1,1;1,1,1,1},,MATCH("Dec",{"Sept","Oct","Nov","Dec"},0)))
SUMPRODUCT(--({"Fred";"Fred";"Barney";"Barney ";"Wilma";"Wilma";"Tom";"Joe";" Chris";"Heather";"Chris"}&{"a";"a";"a";"a";"a";"b";"a";"b";"a";"b";"a"}="Tom"&"a"),INDEX({1,1,1,1;1,1,1,1;1,1,1,1;1,1,1,1;1,1,1,1;1,1,1,1;1,1,1,100;1,1,1,1;1,1,1,1;1,1,1,1;1,1,1,1},,MATCH("Dec",{"Sept","Oct","Nov","Dec"},0)))
Spreadsheet: phillip_m_love__30153__9904_OA
Sheet: TX-CON-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM) / HPL
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL INTRA-MTH
FT-Texas
 |  | Current Month MTM
 |  | Financial Liquidations
 |  | Originations
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 851189d1701409642-sum-using-multiple-criteria-if-cell-is-blank-use-date-from-another-cell-funding-quarterly-status-aligw
Sheet: Funding

Funding Source | Location | ID Code | Description | Original Planned Month of Funding | Altered Planned Month of Funding | FY24 Approved Budget
AJP | WH | 18902 | Products | 2023-11-01 00:00:00 |  | 2080000
Base | Store | 12890 | Products | 2023-12-01 00:00:00 |  | 900000 |  |  | 45261
AJP | WH | 18902 | Products | 2023-12-01 00:00:00 | 2024-02-01 00:00:00 | 1650000 |  |  | 45323
FMS | Corporate | 34781 | Products | 2023-12-01 00:00:00 | 2024-03-01 00:00:00 | 350000 |  |  | 45352
Base | Store | 12890 | Products | 2023-12-01 00:00:00 | 2024-02-01 00:00:00 | 600000 |  |  | 45323
Base | Store | 12890 | Products | 2024-01-01 00:00:00 |  | 2100000 |  |  | 45292
Base | Store | 12890 | Products | 2024-02-01 00:00:00 |  | 625000 |  |  | 45323
Base | Store | 12890 | Products | 2024-02-01 00:00:00 | 2024-05-01 00:00:00 | 15871883 |  |  | 45413
Base | Store | 12890 | Products | 2024-06-01 00:00:00 |  | 1500000 |  |  | 45444
FY Quarter 1
2023-10-01 00:00:00
2023-11-01 00:00:00
2023-12-01 00:00:00
FY Quarter 2
2024-01-01 00:00:00
2024-02-01 00:00:00
2024-03-01 00:00:00
FY Quarter 3
2024-04-01 00:00:00
2024-05-01 00:00:00
2024-06-01 00:00:00
FY Quarter 4
2024-07-01 00:00:00
2024-08-01 00:00:00
2024-09-01 00:00:00
Spreadsheet: 1270cdf3-1494-4ee7-87a5-ef299f4e7d39
Sheet: October 2013

Spend over £25,000 - Publication template
Department family | Entity | Date | Expense type | Expense area | Supplier | Transaction number | Amount
DCMS | SMG | 2013-10-04 00:00:00 | Build Construction | ScM Major projects | [NAME] | 182983 | 35043.05
DCMS | SMG | 2013-10-10 00:00:00 | Build Construction | ScM Major projects | The Hub Consulting Limited | 183270 | 231950
DCMS | SMG | 2013-10-24 00:00:00 | Exhibitions | ScM Major projects | Universal Everything Limited | 183431 | 30000
DCMS | SMG | 2013-10-24 00:00:00 | Hospitality - Nonstaff | ScM Events | Benugo Limited | 183436 | 35000.32
DCMS | SMG | 2013-10-24 00:00:00 | Maintenance | NMeM Estates | Honeywell Controls Ltd | 183540 | 82858
DCMS | SMG | 2013-10-24 00:00:00 | Maintenance | NRM Estates | Honeywell Controls Ltd | 183544 | 89942
DCMS | SMG | 2013-10-24 00:00:00 | Maintenance | Science Museum Estates | Cofely Limited | 183740 | 29409.47
DCMS | SMG | 2013-10-24 00:00:00 | Maintenance | Science Museum Estates | Cofely Limited | 183750 | 29409.47
DCMS | SMG | 2013-10-24 00:00:00 | Security | NRM Security | [NAME] | 183828 | 38235
DCMS | SMG | 2013-10-24 00:00:00 | Security | NMeM Security | [NAME] | 183829 | 36538
DCMS | SMG | 2013-10-18 00:00:00 | Build Construction | National MPG | Elmwood (Glasgow) Ltd | 183882 | 168926.51
DCMS | SMG | 2013-10-24 00:00:00 | Build Construction | ScM Major projects | Benchworks Ltd | 183937 | 36080
DCMS | SMG | 2013-10-24 00:00:00 | Security | ScM Security | [NAME] | 184054 | 166425
DCMS | SMG | 2013-10-22 00:00:00 | Legal | SMG Legal | Farrer & Co | 184116 | 27099.35
DCMS | SMG | 2013-10-24 00:00:00 | Legal | SMG Legal | Farrer & Co | 184118 | 25704.81
Spreadsheet: 674055d1587647307-index-match-to-return-data-from-another-row-eh_clientsnapshot
Sheet: Client Info

 |  | Prominent on website? | Product | Car sales | Contract type | Customer benefit | Budgeting time known
Client | Date | Score | Score | Score | Score | Score | Score | Overall Score | Recommended Areas to address
Lemon box |  | 0 | 1 | 2 | 2 | 0 | 2
The Mad Men |  | 0 | 2 | 3 | 2 | 2 | 3
[NAME] |  | 1 | 3 | 2 | 2 | 2 | 3
Spreadsheet: 758380d1638837116-pull-data-from-other-tabs-into-a-summary-tab-only-if-certain-data-selected-in-column-ssu-template-7-12-2021
Sheet: SMALL EQUIP.

 | SMALL EQUIPMENT
 | BRAND | ITEM CODE | [NAME] | AVG QTY PER CHAIR | CHAIR COUNT | AUTOMATED TOTAL | ADJUSTED TOTAL | ACTUAL TOTAL | UOM | POST SSU TRAINING
 | LAB
 |  | Small Equip | Test 1 |  |  |  |  |  |  | 3-4 weeks
 | STERILISING
 |  | Small Equip | Test 2 |  |  |  |  |  |  | 1-2 Weeks
 | OILING UNITS
 |  | Small Equip | Test 3
 |  | Small Equip | Test 4 |  |  |  |  |  |  | 7-8 weeks
 | AIR ABRASION UNITS
 | CLINIC / TREATMENT ROOM
 | [NAME]