tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 128534d1321030331-max-occurence-of-value-combinations-between-columns-max-occurence-of-value-combinations-between-columns
Sheet: Example

 |  |  |  | The data to be analysed is the checkmarks in the Columns table on the left. There are 9 columns with random amount of checkmarks in each column.
 |  |  |  | The table on the right represents which columns have the maximum combination of 2 checkmarks, 3 checkmarks...up to 8 checkmarks
 |  |  |  | For example, in the case of 2 checkmarks,
 |  |  |  |  | Columns |  |  |  |  |  |  |  |  |  |  |  |  | Maximum combination of checkmarks between columns
 |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  |  |  |  | 2 Checkmarks | Amount | 3 Checkmarks | Amount | 4 Check. | Amount | 5 Check. | Amount | 6  Check. | Amount | 7 Check. | Amount | 8 Check. | Amount
 |  |  |  |  |  | ü | ü | ü | ü | ü | ü | ü | ü
 |  |  |  |  |  |  | ü |  |  |  |  |  |  |  |  |  |  | 2,4 | 5 | 2,4,5 | 3 | 6,7,8,9 | 2
 |  |  |  |  | ü | ü |  | ü
 |  |  |  |  |  | ü |  | ü | ü
 |  |  |  |  |  | ü |  | ü |  |  |  |  |  |  |  |  |  | 2,4 means |  |  |  | Columns
 |  |  |  |  |  | ü |  | ü | ü |  |  |  |  |  |  |  |  | that columns |  |  |  | 6,7,8,9
 |  |  |  |  |  |  |  |  |  | ü | ü | ü | ü |  |  |  |  | 2&4 in the left |  |  |  | have the
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | table have the |  |  |  | maximum
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | maximum |  |  |  | combination
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | combination |  |  |  | of 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | of 2 |  |  |  | checkmarks
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | checkmarks |  |  |  | which is 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | which is 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maximum combination of checkmarks between columns
 |  |  |  |  | Column |  |  |  |  |  |  |  |  |  |  |  | 2 Checkmarks | Amount | 3 Checkmarks | Amount | 4 Check. | Amount | 5 Check. | Amount | 6  Check. | Amount | 7 Check. | Amount | 8 Check. | Amount
 |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  |  |  | 2,4 | 5
 |  |  |  |  |  | ü | ü | ü | ü | ü | ü | ü | ü |  |  |  | 5,7 | 5
 |  |  |  |  |  |  | ü |  | ü |  | ü
 |  |  |  |  | ü | ü |  | ü
 |  |  |  |  |  | ü |  | ü | ü |  | ü |  |  |  |  |  | In the event there is more than one [NAME] combination of  i.e. 2 checkmarks, they can be listed under each other.
 |  |  |  |  |  | ü |  | ü
 |  |  |  |  |  | ü |  | ü | ü |  | ü
 |  |  |  |  |  |  |  |  | ü |  | ü | ü | ü
Spreadsheet: 131737ca-272a-4a5f-8e05-2cccc836b440
Sheet: IND_BMT New Tech Trains

Car Numbers | #Cars | Contract | Builder | Year Built | Coupling Arrangement | Propolsion Package
8101-8200 | 100 | R-143 | Kawasaki | 2001-2002 | 4 car sets (ABBA) | [NAME] *
8201-8312 | 112 | R-143 Option | Kawasaki | 2001-2002 | 4 car sets (ABBA) | [NAME] *
8313-8376 | 64 | R-160A-1 | Alstom | 2005-2008 | 4 car sets (ABBA) | Alstom Onix CBTC *
8377-8652 | 276 | R-160A-1 | Alstom | 2005-2008 | 4 car sets (ABBA) | Alstom Onix
8653-8712 | 60 | R-160A-2 | Alstom | 2005-2008 | 5 car sets (ABBBA) | Alstom Onix
8713-8842 | 130 | R-160B | Kawasaki | 2005-2008 | 5 car sets (ABBBA) | Alstom Onix
8843-8972 | 130 | R-160B | Kawasaki | 2005-2008 | 5 car sets (ABBBA) | Siemens
8973-9102 | 130 | R-160B Option #1 | Kawasaki | 2008-2009 | 5 car sets (ABBBA) | Siemens
9103-9232 | 130 | R-160B Option #1 | Kawasaki | 2008-2009 | 5 car sets (ABBBA) | Alstom Onix
9233-9592 | 360 | R-160A Option #1 | Alstom | 2008-2010 | 5 car sets (ABBBA) | Alstom Onix
9593-9802 | 210 | R-160A Option #2 | Alstom | 2008-2010 | 5 car sets (ABBBA) | Alstom Onix
9803-9942 | 140 | R-160B Option #2 | Kawasaki | 2009-2010 | 5 car sets (ABBBA) | Alstom Onix
9943-9974 | 32 | R-160A Option #2 | Alstom | 2010 | 4 car sets (ABBA) | Alstom Onix
? | 290 | R-179 | ? | ?
? | 50 | R-179 Option #1 | ? | ?
? | 80 | R-179 Option #2 | ? | ?
Total
* = CBTC cars assigned to the "L" line
Spreadsheet: 197806d1354565176-data-extraction-help-practice-file-bb-
Sheet: Sheet1

 |  |  | Task    # | Task Description | Participant | Unit | Unit Cost | Number of Units | Total Cost | CIPS Units | CIPS | Revised Units | Revised
 |  |  |  |  |  |  |  |  |  |  | Cost (USD) |  | Cost (USD)
Study | Cars |  | 3
Spreadsheet: 1bf2e540-c155-48c0-95d4-9f2f0c34bcf9
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-03-18 09:32:46.520000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.625 | 102.377 | 102.252 | 102.127 | 101.752
4.5 | 101.439 | 101.314 | 101.189 | 100.814 |  | Note: | Refer To Price [NAME]
4.375 | 100.488 | 100.363 | 100.238 | 99.863 |  |  | For all Price Adjs
4.25 | 99.91 | 99.785 | 99.66 | 99.035
4.125 | 99.079 | 98.954 | 98.829 | 98.204
4 | 98.061 | 97.936 | 97.811 | 97.186
3.875 | 97.013 | 96.888 | 96.763 | 96.138
3.75 | 96.138 | 96.013 | 95.888 | 95.263
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.875 | 102.75 | 102.625 | 102.25
3.875 | 102.649 | 102.524 | 102.399 | 102.024
3.75 | 102.418 | 102.293 | 102.168 | 101.793
3.625 | 102.013 | 101.888 | 101.763 | 101.388
3.5 | 101.438 | 101.313 | 101.188 | 100.563
3.375 | 100.683 | 100.558 | 100.433 | 99.808
3.25 | 99.88 | 99.755 | 99.63 | 99.005 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-04-01 09:32:46.520000
30 DAY | 2014-04-16 09:32:46.520000
45 DAY | 2014-05-01 09:32:46.520000
60 DAY | 2014-05-16 09:32:46.520000
90 DAY | 2014-06-15 09:32:46.520000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 74198d1274779033-how-do-i-use-data-validation-and-index-match-new-cost-calculator
Sheet: Sheet1

Expected Numbers |  | 80
 |  |  |  |  |  | Total price for full weekend |  | #N/A | per person
Hotel Full Weekend Price |  | 130 |  |  |  | Total price for Saturday - Sunday |  | #N/A | per person
 |  |  |  |  |  | Total price for Banquet Only |  | #N/A | per person
Hotel Saturday-Sunday Price |  | 80
Hotel Banquet Only Price |  | 40
Toastmaster |  | Please Select |  | 300 |  | #N/A
Photographer |  | Yes |  | 0
Table Flowers |  | 4 |  | 15 |  | 60
Presentation Flowers |  | Please Select |  | 25 |  | #N/A
Friday Entertainment |  | Disco
[NAME] |  | Three Table Casino
Additional Entertainment |  | Please Select
Bespoke Menu Cards |  | Please Select |  | 4
Bespoke Place Cards |  | Please Select |  | 0.5
Ladies Presents |  | Select a value |  |  |  | #N/A
Guest Management Services |  | Yes |  | 2.88
Buffer / Charity List |  |  |  |  |  | 0
 |  |  | Total Cost |  |  | #N/A
 |  | Per Person Cost |  |  |  | #N/A
 |  |  |  |  |  |  |  | Please Select |  | Please Select |  |  | Please Select
 |  |  |  |  |  |  |  | Yes | 300 | None |  |  | 1
 |  |  |  |  |  |  |  | No |  | Pianist | 150 |  | 2
 |  |  |  |  |  |  |  |  |  | Disco | 275 |  | 3
 |  |  |  |  |  |  |  |  |  | [NAME] | 550 |  | 4
 |  |  |  |  |  |  |  |  |  | Two Table Casino | 450 |  | 5
 |  |  |  |  |  |  |  |  |  | Three Table Casino | 600
 |  |  |  |  |  |  |  |  |  | Three Piece Band | 600
 |  |  |  |  |  |  |  |  |  | Four Piece Band | 750
 |  |  |  |  |  |  |  |  |  | Five Piece Band | 950
Spreadsheet: 224725d1364732956-using-dropdown-list-or-radio-buttons-timesheet
Sheet: Data

Project
Name |  |  |  |  | To enter dates use format "4/2" for April 2nd
Address |  |  |  |  | and the spreadsheet will automatically
City |  |  |  |  | return Apr/2/13
Prov
Postal Code
PH1
PH2
Cell
email
Material [NAME] | 0.15
Labor | Cost | To Client
Employee 1
Employee 2 | 27.06 | 50
Employee 3 | 25.53 | 50
Employee 4 | 23.37 | 40
Employee 5 | 25.59 | 40
Employee 6 | 22.14 | 35
Labour 1 | 18.45 | 35
Labour 2 | 18.45 | 35
Labour 3 | 18.45 | 35
Labour 4 | 18.45 | 35
Spreadsheet: 59391d1259874462-date-hotel
Sheet: Data

High | 2009-04-01 00:00:00 | 2009-10-31 00:00:00 | 38 | Wanted > | 36 olacak |  | False >> | 63
Low | 2009-11-01 00:00:00 | 2010-03-31 00:00:00 | 25 | Wanted > | 24 olacak |  | True >> | 60
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010
Input | Exit | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 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 | reality
2009-10-15 00:00:00 | 2009-10-24 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9
2009-10-15 00:00:00 | 2009-10-25 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10
2009-10-15 00:00:00 | 2009-11-25 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 41
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60
 |  | Yüksek |  |  | Düşük
 |  | 2009-10-15 00:00:00 | 1 |  | 2009-11-01 00:00:00 | 1
 |  | 2009-10-16 00:00:00 | 2 |  | 2009-11-02 00:00:00 | 2
 |  | 2009-10-17 00:00:00 | 3 |  | 2009-11-03 00:00:00 | 3
 |  | 2009-10-18 00:00:00 | 4 |  | 2009-11-04 00:00:00 | 4
 |  | 2009-10-19 00:00:00 | 5 |  | 2009-11-05 00:00:00 | 5
 |  | 2009-10-20 00:00:00 | 6 |  | 2009-11-06 00:00:00 | 6 |  |  | 10
 |  | 2009-10-21 00:00:00 | 7 |  | 2009-11-07 00:00:00 | 7
 |  | 2009-10-22 00:00:00 | 8 |  | 2009-11-08 00:00:00 | 8
 |  | 2009-10-23 00:00:00 | 9 |  | 2009-11-09 00:00:00 | 9 |  |  |  |  |  |  |  |  |  |  | 9
 |  | 2009-10-24 00:00:00 | 10 |  | 2009-11-10 00:00:00 | 10
 |  | 2009-10-25 00:00:00 | 11 |  | 2009-11-11 00:00:00 | 11
 |  | 2009-10-26 00:00:00 | 12 |  | 2009-11-12 00:00:00 | 12 |  |  |  |  |  | 24
 |  | 2009-10-27 00:00:00 | 13 |  | 2009-11-13 00:00:00 | 13
 |  | 2009-10-28 00:00:00 | 14 |  | 2009-11-14 00:00:00 | 14
 |  | 2009-10-29 00:00:00 | 15 |  | 2009-11-15 00:00:00 | 15
 |  | 2009-10-30 00:00:00 | 16 |  | 2009-11-16 00:00:00 | 16
 |  | 2009-10-31 00:00:00 | 17 |  | 2009-11-17 00:00:00 | 17
 |  |  |  |  | 2009-11-18 00:00:00 | 18
 |  |  |  |  | 2009-11-19 00:00:00 | 19
 |  |  |  |  | 2009-11-20 00:00:00 | 20
 |  |  |  |  | 2009-11-21 00:00:00 | 21
 |  |  |  |  | 2009-11-22 00:00:00 | 22
 |  |  |  |  | 2009-11-23 00:00:00 | 23
 |  |  |  |  | 2009-11-24 00:00:00 | 24
 |  |  |  |  | 2009-11-25 00:00:00 | 25 | Exit | 24 night
Spreadsheet: richard_ring__31528__Timeline
Sheet: Sheet1

BGE Market Entry | Week of
 | 2001-08-03 00:00:00 | 2001-08-06 00:00:00 | 2001-08-07 00:00:00 | 2001-08-08 00:00:00 | 2001-08-09 00:00:00 | 2001-08-10 00:00:00 | 2001-08-13 00:00:00 | 2001-08-14 00:00:00 | 2001-08-15 00:00:00 | 2001-08-16 00:00:00 | 2001-08-17 00:00:00 | 2001-08-20 00:00:00 | 2001-08-21 00:00:00 | 2001-08-22 00:00:00 | 2001-08-23 00:00:00 | 2001-08-24 00:00:00 | 2001-08-27 00:00:00 | 2001-08-28 00:00:00 | 2001-08-29 00:00:00 | 2001-08-30 00:00:00 | 2001-08-31 00:00:00 | 2001-09-03 00:00:00 | 2001-09-04 00:00:00 | 2001-09-05 00:00:00 | 2001-09-06 00:00:00 | 2001-09-07 00:00:00 | 2001-09-10 00:00:00 | 2001-09-11 00:00:00 | 2001-09-12 00:00:00 | 2001-09-13 00:00:00 | 2001-09-14 00:00:00 | 2001-09-17 00:00:00 | 2001-09-18 00:00:00 | 2001-09-19 00:00:00 | 2001-09-20 00:00:00 | 2001-09-21 00:00:00 | 2001-09-24 00:00:00 | 2001-09-25 00:00:00 | 2001-09-26 00:00:00 | 2001-09-27 00:00:00 | 2001-09-28 00:00:00 | 2001-10-01 00:00:00 | 2001-10-02 00:00:00 | 2001-10-03 00:00:00 | 2001-10-04 00:00:00 | 2001-10-05 00:00:00 | 2001-10-08 00:00:00
Negotiate remaining agreements with BGE
Verify load shape with site profile desk |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
Produce batch to analyze various cash flows |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O
Determine best product alternative and prepare Product Approval Template |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L
Prepare draft Transaction Confirmation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I
Prepare marketing materials |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D
Get approval from Deal Management and Power Desk |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A
Finalize contract |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
 |  |  |  |  |  |  |  |  |  |  | .
Spreadsheet: 817816d1676459720-filter-from-column-b-and-return-unique-values-eh_filter-columns
Sheet: I WANT THIS

I want this
Chilled- Ml Cntr Chicken | [NAME] Ckn- Bites -Brd/Btd | Chilled | Pieces - Chunks
Chilled- Ml Cntr Chicken | [NAME] Ckn- Bites -Unctd | Chilled | Pieces - Chunks
Chilled- Ml Cntr Chicken | [NAME] Ckn- Finger -Brd/Btd | Chilled | Not Applicable
Chilled- Ml Cntr Chicken | [NAME] Ckn- Pops | Chilled | Pieces - Chunks
Chilled- Ml Cntr Chicken | [NAME] Ckn- Shapes | Chilled | Not Applicable
Chilled- Ml Cntr Chicken | [NAME] Ckn- Shapes | Chilled | Pieces - Goujons
Chilled- Ml Cntr Chicken | [NAME] Ckn- Shapes | Chilled | Not Applicable
Chilled- Ml Cntr Chicken | [NAME] Ckn- Shapes | Chilled | Pieces - Strips
Spreadsheet: b3637163-a2b3-4366-88a5-ecc184346e30
Sheet: Sheet1

CORRECTIVE ACTION PLAN: BASIC FORMAT & CONTENT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
JOB & PROJECT INFORMATION
IDENTITY OF PARTIES:
 | PROJECT | PCNA PROVIDER FIRM | LENDER
Name:
Address
E-mail
Phone:
Onsite Contact Name:
Site Assessor Name:
Reviewer Name:
[NAME]:
PCNA DATES:
Inspection Date(s);
Report Date:
LENDER PROVIDED INFO:
Currently Insured? | Yes/No & SOA
Proposed SOA?
Is Project Federally Assisted?* | Yes/No | If yes, 24 CFR 8 Subpart C and  UFAS requirements apply
* Federally assisted projects include those constructed/sub rehabilitated with 221(d)(3) BMIR or 236 Mortgages, or with Section 202 or 811 loans or grants,  and also projects with Project Based Vouchers or Section 8 Housing Assistance Payments Contracts, Tax Credit Assistance Program (TCAP) grants, HOME, HOPWA, CDBG, Neighborhood Stabilization Program loans or grants.  These are the most common but not the only possible forms of Federal assistance.  See 24 CFR 8.3.  It is the Lender's job to determine conclusively whether a project is Federally assisted.
Spreadsheet: 808408d1670441490-two-running-balance-columns-with-conditions-running-balance
Sheet: Sheet1

SSIS workgroup# | Name | Date | Amount | Description | Cash | [NAME]
 |  | 2022-12-01 00:00:00 | 0 |  | 30000 | 5000
10000567 | Spock | 2022-12-02 00:00:00 | 105.75 | Books
 | Chewbacca | 2022-12-17 00:00:00 | 175 | Transportation
 | Iron Man | 2022-12-21 00:00:00 | 25 | Books
 | [NAME] | 2022-12-22 00:00:00 | 60 | Phone
 | Thumbalina | 2022-12-23 00:00:00 | 500 | Transportation
 | [NAME] | 2022-12-05 00:00:00 | 10 | [NAME]
 | Merlin | 2022-12-05 00:00:00 | 100 | Clothing
 | Tinkerbell | 2022-12-05 00:00:00 | 50 | [NAME]
Spreadsheet: 723426d1615675534-how-to-countif-a-date-is-within-a-date-range-and-is-a-monday-spreadsheet-sample-help
Sheet: Normalized Data

Name | Room | Date |  |  |  |  |  |  |  |  |  |  |  | Name | Room | 1 | 2 | 3
[NAME] | Baby Room | 2021-05-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Baby Room | 2021-05-13 00:00:00 | 2021-05-14 00:00:00 | 2021-06-10 00:00:00
[NAME] | Baby Room | 2021-05-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Baby Room | 2021-03-15 00:00:00 | 2021-06-07 00:00:00 | 2021-06-08 00:00:00
[NAME] | Baby Room | 2021-06-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Aruba | 2-3s | 2021-02-15 00:00:00 | 2021-02-16 00:00:00 | 2021-02-17 00:00:00
[NAME] | Baby Room | 2021-03-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Bradley |  | 2021-02-15 00:00:00 | 2021-02-24 00:00:00
[NAME] | Baby Room | 2021-06-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Chloe |  | 2021-02-22 00:00:00 | 2021-06-21 00:00:00 | 2021-06-22 00:00:00
[NAME] | Baby Room | 2021-06-08 00:00:00
Aruba | 2-3s | 2021-02-15 00:00:00
Aruba | 2-3s | 2021-02-16 00:00:00
Spreadsheet: 109372d1306252981-excel-2007-column-chart-excel
Sheet: Sheet1

 | A1 | A2 | A1 | A2
1 | 2.14 | 65.5 | -10 | -15.2
2 | 237.39 | 422.27 | -44.7 | -118.82
3 | 304.56 | 341.37 | -313.8 | -447.9
4 | 114.6 | 47.92 | -39.1 | -142.4
5 | 808.71 | 250.57 | -52.3 | -62.07
6 | 45.35 | 11.12 | -34.4 | -37.92
7 | 0 | 125.87 | -0.3 | 0
8 | 123.71 | 4.37 | -25.3 | -0.11
9 | 22.8 | 0 | -3.31 | 0
10 | 11.13 | 72.47 | -0.11 | -98.22
Spreadsheet: 677264d1589273765-inserting-a-new-line-but-vlook-up-dont-change-rates-sheet
Sheet: main

 | Civils
Code | Category | Description | Unit | Rate(£) | Quantity | Total
1002
1345
Total
 | Cable
Code | Category | Description | Unit | Rate(£) | Quantity | Total
1600a
1764
Total
Spreadsheet: 805148d1668547834-if-statements-to-show-expiry-date-values-if-statements-expiry-dates
Sheet: Sheet1

 |  |  | 2022-10-31 00:00:00
Lot | Lot [NAME] | Value | [NAME] 100% | Inventory Expiring within 1 year @ 25% | Inventory Expiring between 6 to 9 months @ 50% | Inventory expiring within 6 months @ 75%
[NAME] | 2023-01-31 00:00:00 | 5000
ZLNTA2102A | 2021-12-31 00:00:00 | 1200
ZLNTA2103A | 2023-01-31 00:00:00 | 1300
P321016 | 2020-07-31 00:00:00 | 60000
P321045 | 2023-10-31 00:00:00 | 75000
P321046 | 2023-10-31 00:00:00 | 5000
P321047 | 2023-10-31 00:00:00 | 1200
P321048 | 2023-10-31 00:00:00 | 1300
P321049 | 2023-10-31 00:00:00 | 60000
P321054 | 2023-11-30 00:00:00 | 75000
P321055 | 2023-11-30 00:00:00 | 5000
[NAME] | 2023-11-30 00:00:00 | 1200
P321057 | 2023-11-30 00:00:00 | 1300
P321058 | 2023-11-30 00:00:00 | 60000
P322008 | 2024-04-30 00:00:00 | 75000
Spreadsheet: stacey_white__38880__20001 01 flash report
Sheet:  inter rec

 |  |  |  |  |  |  | 2001 01 Accounting Period - Intercompany EES
 |  | EES |  |  |  |  |  |  | EEMC |  |  |  |  |  |  | ECC
 |  | GL - Manual | Unify - Russ |  |  |  |  |  | GL - Manual | Unify - Russ |  |  |  |  |  | GL - Manual | Unify - Russ
 | DP
 | P |  |  |  |  |  |  | P |  |  |  |  |  |  | P
2000 11 | DR |  |  |  |  |  |  | DR |  |  |  |  |  |  | DR
 | S |  |  |  |  |  |  | S |  | -137861.67 |  |  |  |  | S
 | OPP |  |  |  |  |  |  | OPP |  |  |  |  |  |  | OPP
 | OPR |  |  |  |  |  |  | OPR |  |  |  |  |  |  | OPR
 | DP
 | P |  |  |  |  |  |  | P |  |  |  |  |  |  | P |  | 230816
2000 12 | DR |  | 1500013.86 |  |  |  |  | DR |  |  |  |  |  |  | DR
 | S | -1484269.56 | -992927.36 |  |  |  |  | S |  | -244209.97 |  |  |  |  | S
 | OPP |  |  |  |  |  |  | OPP |  |  |  |  |  |  | OPP
 | OPR |  |  |  |  |  |  | OPR |  |  |  |  |  |  | OPR
 | DP |  | -93310
 | P | 161000385.41 | -160820025.33 |  |  |  |  | P |  |  |  |  |  |  | P
2001 01 | DR |  | 1542500 |  |  |  |  | DR |  |  |  |  |  |  | DR
 | S | -369351665.27 | 368485420.4400001 |  |  |  |  | S | -239154.33 | 238016.45 |  |  |  |  | S
 | OPP |  |  |  |  |  |  | OPP |  |  |  |  |  |  | OPP
 | OPR |  |  |  |  |  |  | OPR |  |  |  |  |  |  | OPR
TOTALS
Spreadsheet: 120744d1315494824-projected-component-change-outs-budget
Sheet: 5314

5314 |  |  |  | Current Hours |  | Year
 |  |  |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014 |  |  |  | 2015 |  |  |  | 2016
 |  |  |  |  |  | 744 | 696 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 744 | 672 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 2160 | 2184 | 2208 | 2208 | 2160 | 2184 | 2208 | 2208 | 2184 | 2184 | 2208 | 2208
 |  |  |  |  | Projected 2011 End | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th
Projected Future Hours
Spreadsheet: 539911d1506428028-move-row-values-to-columns-book1
Sheet: Sheet1

Parameter 1 | Parameter 2 |  |  | [NAME]. 1
A | 231
A | 869
B | 698
B | 737
B | 307
A | 634
D | 409
D | 986
C | 239
C | 105
E | 610
E | 942
E | 695
A | 408
Spreadsheet: 593216d1539040602-combine-append-two-excel-tables-into-one-apended-list
Sheet: Items B

Item | Quantity | Cost | Total
Scarf | 5 | 19
Jacket | 2 | 150
Tie | 2 | 20
Gloves | 10 | 2
Spreadsheet: 856689d1705904641-getting-number-out-of-a-row-excel-forum-help-2-1-
Sheet: Sheet3

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
25 | 17 | 34 | 27 |  | 19 | 13 | 21 | 7.999999999999999 | 11 | 10 |  | 9.999999999999998 | 13 | 9 | 14 |  | 6 |  | 20 | 4 | 17 |  | 5 | 15 | 11 | 12 | 3 | 13 | 5 |  |  | 6 | 14 | 8.999999999999998
 | 17 | 34 | 27 | 45 | 19 | 13 | 21 | 7.999999999999999 | 11 | 10 | 41 | 9.999999999999998 | 13 | 9 | 14 | 31 | 6 | 43 | 20 | 4 | 17 | 31 | 5 | 15 | 11 | 12 | 3 | 13 | 5 | 30 | 36 | 6 | 14 | 8.999999999999998
I had to exclude the S (which is the N in english) from the formulas:
 | 17 | 34 | 27 | 45 | 19 | 13 | 21 | 8 | 11 | 10 | 41 | 10 | 13 | 9 | 14 | 31 | 6 | 43 | 20 | 4 | 17 | 31 | 5 | 15 | 11 | 12 | 3 | 13 | 5 | 30 | 36 | 6 | 14 | 9
Spreadsheet: 174317d1345019869-vlookup-with-drop-down-functionality-vlookup-with-a-drop-down-menu
Sheet: Plan

 |  | 2012
Product |  | Jan | Feb | Mar | April
Product A | Units | 10 | 20 | 30 | 40
Product B | Units | 30 | 20 | 40 | 10
Product C | Units | 20 | 25 | 35 | 25
Product D | Units | 26 | 24 | 26 | 26
Product A | Values | 400 | 500 | 600 | 700
Product B | Values | 123 | 654 | 50 | 800
Product C | Values | 1254 | 256 | 235 | 567
Product D | Values | 235 | 569 | 5674 | 465