tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: louise_kitchen__24136__North America Plan 01-08 adj
Sheet: Canada Support

 | 2002 Plan
 |  |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 | 2002 |  |  |  |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  |  | Compensation | 0
 | Special Pays | 0
 | Analysts & Associates | 0
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  |  | Total
ENAOUTSV | Outside Services |  |  |  | 0
ENASUPP | Supplies Expense |  |  |  |  |  |  |  | EOPs/Risk
ENAMKTEX | Marketing |  |  |  |  |  |  |  | [NAME] | 36000 | 1
ENACONTR | Charitable Contributions |  |  |  |  |  |  |  | Staff | 54000 | 2
ENARENT | Rent |  |  |  |  |  |  |  | Specialist | 62400 |  |  | includes 1 Analyst
ENATECH | Technology |  |  |  |  |  |  |  | Sr. Specialist | 79200 | 2
ENATRANS | Transportation |  |  |  |  |  |  |  | Manager | 96000 | 2
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  | VP | 216000 | 1
ENATAXES | Taxes Other than Income
ENATOTDR | Total Direct Expenses
 |  |  |  |  |  |  |  |  | IT
 | Headcount |  |  | 82 | 32 |  |  |  | Staff | 60000 | 2
 |  |  |  |  |  |  |  |  | Specialist | 78000 | 1
 | Analysts & Associate Headcount |  |  | 5 | 1 |  |  |  | Sr. Specialist | 102000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | Accounting
ENAOUTLG | Outside Legal |  |  |  |  |  |  |  | Staff | 49200 | 0
ENAOUTTX | Outside Tax |  |  |  |  |  |  |  | Specialist | 62400 | 2
ENAINSUR | Insurance |  |  |  |  |  |  |  | Sr. Specialist | 74400 |  |  | Includes 1 HR
ENASYSDV | System Development |  |  |  |  |  |  |  | Manager | 90000 | 1
ENACORIT | Controllable Infrastructure |  |  |  |  |  |  |  | Director | 120000 | 1
ENACORRN | Corporate Rent |  |  |  |  |  |  |  | VP | 216000 | 1
ENAOTHAL | Other Allocated Direct  Expenses
ENADEPR | Depreciation & Amortization
 | Outside Services | 5703580 |  |  |  |  |  |  | Legal
 |  |  |  |  |  |  |  |  | [NAME] | 52800 | 1
 |  |  |  |  |  |  |  |  | Sr. Counsel | 195600 |  |  | Includes 1 from Reg Affairs
 |  |  |  |  |  |  |  |  | VP | 217200 | 1
Other Expense Calculation
 |  |  |  |  |  |  |  |  | [NAME]
Total Exp | Old HC | Exp/Old HC |  | New HC |  | Exp/New HC |  |  | [NAME] | 52800 | 3
 |  |  |  |  |  |  |  |  | Toronto
 |  |  |  |  |  |  |  |  | Manager | 90000 | 1
 |  |  |  |  |  |  |  |  | Director | 168000 | 1
Spreadsheet: 7c998db7-9dd3-49f2-9f4f-3021395d3ab3
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: |  |  | 2011-10-27 14:09:12.470000
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.5 | 101.137 | 101.012 | 100.887 | 100.512 |  | and are added to price quote
4.375 | 100.654 | 100.529 | 100.404 | 100.029
4.25 | 99.927 | 99.802 | 99.677 | 99.302 |  | Note: | Refer To Price [NAME]
4.125 | 99.303 | 99.178 | 99.053 | 98.678 |  |  | For all Price Adjs
4 | 98.836 | 98.711 | 98.586 | 97.961
3.875 | 98.285 | 98.16 | 98.035 | 97.41
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 100.935 | 100.81 | 100.685 | 100.31
3.75 | 100.44 | 100.315 | 100.19 | 99.815
3.625 | 99.844 | 99.719 | 99.594 | 99.219
3.5 | 99.509 | 99.384 | 99.259 | 98.884
3.375 | 99.06 | 98.935 | 98.81 | 98.185
3.25 | 98.556 | 98.431 | 98.306 | 97.681
 |  |  |  |  |  | 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 | 2011-11-10 14:09:12.470000
30 DAY | 2011-11-25 14:09:12.470000
45 DAY | 2011-12-10 14:09:12.470000
60 DAY | 2011-12-25 14:09:12.470000
90 DAY | 2012-01-24 14:09:12.470000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 851130d1701361978-formula-that-returns-a-range-of-non-empty-cells-based-on-conditions-part-2-excel-formula-range-v3
Sheet: Summary

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weight units | gr (Gram)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Volume units | ml (Mililiter)
 | Product A |  |  |  |  |  |  | Box |  |  |  | Product B | Product C |  | Orders |  |  |  | Ingredients
 |  | Flavor 1 |  |  |  |  |  | Name | # of products |  | Flavor 1 | Flavor 1 | Flavor 1 |  | Products | Flavors | Box |  | Ingredients | Quantity | Units | Products | # of products
 |  |  | Ingredients | Quantity | Units |  |  | [NAME] | 1 |  |  | Flavor 2 |  |  | Product A | Flavor 1 | [NAME] |  | Ingredient A1
 |  |  | Ingredient A1 | 10 | gr |  |  | Box Y | 6 |  |  | Flavor 3 |  |  | Product B | Flavor 2 | Box Y |  | [NAME]
 |  |  | [NAME] | 100 | ml |  |  | Box Z | 9 |  |  | Flavor 4 |  |  |  |  |  |  | [NAME]
 |  |  | [NAME] | 20 | gr |  |  | [NAME] | 12 |  |  |  |  |  |  |  |  |  | Ingredient A4
 |  |  | Ingredient A4 | 3 | gr |  |  |  |  |  |  |  |  |  |  |  |  |  | Ingredient B5
 |  |  | Total |  | gr |  |  |  |  |  |  |  |  |  |  |  |  |  | Ingredient B6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Product B
 |  | Flavor 1
 |  |  | Ingredients | Quantity | Units
 |  |  | Ingredient B1 | 100 | gr
 |  |  | Ingredient B2 | 100 | gr
 |  |  | [NAME] | 50 | gr
 |  |  | Ingredient B4 | 50 | gr
 |  |  | Total |  | gr
 |  | Flavor 2
 |  |  | Ingredients | Quantity | Units
 |  |  | Ingredient B5 | 2 | mg
 |  |  | Ingredient B6 | 5 | gr
 |  |  | [NAME] | 10 | gr
 |  |  | [NAME] | 15 | gr
 |  |  | Total |  | gr
 |  | Flavor 3
 |  |  | Ingredients | Quantity | Units
 |  |  | Ingredient B9 | 1 | gr
 |  |  | Ingredient B10 | 2 | gr
 |  |  | Ingredient B11 | 3 | gr
 |  |  | Ingredient B12 | 4 | gr
 |  |  | Total |  | gr
 |  | Flavor 4
 |  |  | Ingredients | Quantity | Units
 |  |  | Ingredient B13 | 93 | gr
 |  |  | Ingredient B14 | 65 | gr
 |  |  | Ingredient B15 | 87 | gr
 |  |  | Ingredient B16 | 20 | gr
 |  |  | Total |  | gr
 | Product C
 |  | Flavor 1
 |  |  | Ingredients | Quantity | Units
 |  |  | Ingredient C1 | 100 | mg
 |  |  | Ingredient C2 | 100 | gr
 |  |  | [NAME] | 50 | mg
 |  |  | Ingredient C4 | 50 | gr
 |  |  | Total |  | gr
Spreadsheet: 143114d1330207331-sumifs-new-master-budget
Sheet: Notes

Action
• | Renamed Table1 to tbl_Accounts
• | Renamed Table3 to tbl_Details
• | Created a named range:
 |  | Name: | lu_Accounts
 |  | Refers to: | =Lists!A2:A18
• | Built a data validation for the Account entry cells on the Details sheet. The source list is: lu_Accounts.
• | Entered sample data in the Details sheet
• | Changed the dates in 2012 to reference the 1st of each month, instead of the 12th
• | Put this formula in C22 on the Master sheet and copied that formula across and down for each expense row
 |  | =SUMIFS(tbl_Details[[#All],[Amount]],tbl_Details[[#All],[Account]],Master!$A22,tbl_Details[[#All],[Date]],">="&Master!C$1,tbl_Details[[#All],[Date]],"<="&EOMONTH(Master!C$1,0))
Spreadsheet: benjamin_rogers__1044__Peaker Valuation 060500
Sheet: Depreciation

GENCO BOOK DEPRECIATION
 |  |  | Current
('000 $) | Initial Book Value | 1999-12-31 00:00:00 |  | 2000-12-31 00:00:00 | 2001-12-31 00:00:00 | 2002-12-31 00:00:00 | Check
(30-yr SL, 10% Residual)
Brownsville
No. of Months in Operation |  |  |  |  | 12 | 12
% Depreciated
Beginning Book Value | 128000.722
Depreciation | 0
Ending Book Value
Caledonia
No. of Months in Operation |  |  |  |  | 12 | 12
% Depreciated
Beginning Book Value | 154763.971
Depreciation | 0
Ending Book Value
New Albany
No. of Months in Operation |  |  |  |  | 12 | 12
% Depreciated
Beginning Book Value | 148835.468
Depreciation | 0
Ending Book Value
[NAME]
No. of Months in Operation |  | 0 |  |  | 12 | 12
% Depreciated
Beginning Book Value
Depreciation | 0
Ending Book Value
Wheatland
No. of Months in Operation |  | 0 |  |  | 12 | 12
% Depreciated
Beginning Book Value
Depreciation | 0
Ending Book Value
[NAME]
No. of Months in Operation |  | 0 |  |  | 12 | 12
% Depreciated
Beginning Book Value
Depreciation | 0
Ending Book Value
1999 Assets
2000 Assets
Total GenCo
Asset Breakdown
Brownsville
Caledonia
New Albany
[NAME]
Wheatland
[NAME]
Total
Spreadsheet: 764983d1643108022-highlight-entire-row-in-a-certain-color-when-a-specific-data-is-entered-outstanding-sample-filtered-by-colour-aligw
Sheet: Sheet3

Invoice No | PO NUMBER | Dept/Name | Customer | Delivery DATE | Value in AED | PAYMENT DUE | REMARKS | sales Person | Status
FZE 4100 | PO-00345 | Sales | Future  LLC | 2021-10-05 00:00:00 | 19313.1 | 2022-01-06 00:00:00 |  | [NAME] | Closed
FZE 4101 | 4400165998 | Spares | DUBAL | 2021-11-06 00:00:00 |  | 2022-01-06 00:00:00 | Swift copy of Eur 2,616.60 | [NAME] | Closed
FZE 4102 | IPO21D03520 | Service | DC Oil | 2021-10-06 00:00:00 | 6522 | 2022-01-06 00:00:00 |  | Service | Open
FZE 4103 | 4500013007 | Service | [NAME] | 2021-10-07 00:00:00 |  | 2021-11-07 00:00:00 |  | Service | Open
FZE 4104 | 94/2021/A82 | Freight Charges | Telecontrol (A.T.E.C) | 2021-10-16 00:00:00 |  | 2022-02-16 00:00:00 |  | Africa - Satish | Open
FZE 4105 | 4400162013 | Spares | EMAL | 2021-10-27 00:00:00 |  | 2021-12-27 00:00:00 | Swift copy of Eur 2,921.85 | [NAME] | Closed
FZE 4106 | 4500012109 | Sales | [NAME] | 2021-10-07 00:00:00 |  | 2021-11-07 00:00:00 |  | Oman-Shamanth | Open
FZE 4107 | 3012103012 | Sales | DEWA | 2021-11-28 00:00:00 | 8114.4 | 2021-12-28 00:00:00 | Swift Copy of AED 34,384.40 | [NAME] | Closed
FZE 4108 | 3012103633 | Sales | DEWA | 2021-11-28 00:00:00 | 26270 | 2021-12-28 00:00:00 |  | [NAME] | Closed
FZE 4109 | PO 37394 | S+Spare | Shuweihat O&M Limited Partnership | 2021-10-08 00:00:00 | 18276.98 | 2021-11-08 00:00:00 |  | [NAME] | Closed
Spreadsheet: 269909d1381324241-need-to-search-2-columns-at-once-and-report-the-results-where-matches-are-found-test
Sheet: Sheet1

 | apples |  |  | bananas | 77 | 2 |  | pears | oranges
 | drdrrdeyhb |  |  | hbyrhy | 77 | 2
 | rdhgeg |  |  | ftrdj | 77 | 3
 | rdhgeg |  |  | trfd | 77 | 3
 | hgrehgre |  |  | [NAME] | 77 | 5
 | jhmuhgbty |  |  | v | 77 | 6
 | hygymty |  |  | gfvgfv | 77 | 6
 | [NAME] |  |  | bg | 77 | 6
 | yb |  |  | gfbv | 77 | 6
 | dytdyt |  |  | gfbvhg | 78 | 1
 | ydt |  |  | gyii | 78 | 1
 | oranges |  |  | pears | 78 | 1
 | dy |  |  | hgbhgb | 79 | 2
 | bdy |  |  | g | 81 | 1
 | bdy |  |  | gbh | 81 | 1
 | bdy |  |  | hgbghb | 81 | 1
 | bdy |  |  | hgb | 81 | 3
 | pears |  |  | iytki | 81 | 3
 | pears |  |  | hgb | 81 | 4
 | pears |  |  | oranges | 82 | 1
 | oranges |  |  | poranges | 82 | 1
 | bananas |  |  | gyikyi | 82 | 3
 | pears |  |  | hgbn | 82 | 3
 | bdy |  |  | h | 82 | 3
 | bdy |  |  | n | 82 | 4
 | bdy |  |  | h | 82 | 4
 | bdy |  |  | yu | 82 | 4
 | hre |  |  | bnh,myh | 83 | 5
 | dbfdb |  |  | my | 83 | 5
 | dbfdb |  |  | i | 83 | 1
 | bd |  |  | ytimktyi | 83 | 1
 | bd |  |  | ytjkyt | 83 | 2
 | bd |  |  | mi | 83 | 2
 | rdy |  |  | mi | 83 | 4
 | dryhydr |  |  | [NAME] | 84 | 6
 | pears |  |  | oranges | 85 | 1
[NAME] | Reload | into | Calvin & Florence | Spectrum | 179 | 6 | ***tt
Ellie Goulding | Burn | into | [NAME] | La La La | 180 | 1 | **tt dly
[NAME] | La La La | into | [NAME] | Applause | 180 | 1 | ***
Macklemore | Can't Hold us | into | [NAME] | Give it 2 u | 180 | 2 | ***tt
[NAME] | Give it 2 u | into | [NAME] | Summertime Sadness | 180 | 2 | ***
Dj Fresh | Hot right now | into | Drake | hold on we're going home | 180 | 2 | ***t
[NAME] | I Need your Love | into | [NAME] | Super bass | 180 | 3 | ***acca
[NAME] | Super bass | into | [NAME] | Its My party | 180 | 3 | ****
[NAME] | Its My party | into | Rizzle Kicks | Lost generation | 180 | 3 | ***
Klang | Sonnentanz | into | [NAME] | Reload | 180 | 4 | ****
Avicii | Wake Me Up | into | [NAME] | International Love | 180 | 4 | ****
[NAME] | International Love | into | [NAME] derulo | Talk Dirty | 180 | 4 | ***
MK | Look Right Through | into | Sweedish House Mafia | Miami 2 Ibiza | 180 | 6 | ***
Spreadsheet: 126344d1319644384-adding-associated-cells-example
Sheet: Sheet1

Name | ID | Date
XX Pension Long Duration | 1
XXF Balanced  A | 2 | 1992-10-05 00:00:00
XXF Balanced  I | 5 | 2002-03-01 00:00:00
XXF Balanced A IDX1 | 6
XXF Balanced A IDX2 | 7
XXF Balanced I IDX1 | 9
[NAME] I [NAME] | 10
XXF Balanced I IDX3 | 11
XXF Balanced R1 | 45 | 1992-10-05 00:00:00
XXF Balanced R1 IDX1 | 65
XXF Balanced R1 [NAME] | 32
XXF Balanced R1 IDX3 | 667
Spreadsheet: 670141d1585760537-updating-a-formula-for-text-split-textfunctions
Sheet: Address

Full Address | Street No. and Name | City | State | Zip
18794 [NAME], Michigan 48168
627 Slayton - Grand Haven, Michigan 12345
 |  | MID(A11,FIND(" ",A11)+1,FIND(" ",A11,FIND(" ",A11)+1)-1-FIND(" ",[NAME]))
 |  |  | RIGHT(A12 | LEN(A12)-FIND(" | ,[NAME]( | ,A12)+1))
Full Name | First | Middle | Last
[NAME]
[NAME]
Spreadsheet: 1a99ef78-d816-4ce3-93fa-7532813044c9
Sheet: Sheet1

Grid Screen PEG 6000 (HR2-213) - Scoring Sheet | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Sample: |  | 1 [NAME] |  | 6 Needles 1D
Buffer: |  | 2 Phase Separation |  | 7 Plates 2D
Reservoir Volume: |  | 3 Regular Granular Precipitate |  | 8 Xtal <0.2 mm
[NAME]: |  | 4 Birefringent Precipitate |  | 9 Xtal >0.2 mm
Temperature: |  | 5 Spherulites
[NAME]:
Temperature: |  | Date | Date | Date
A1.  0.1 M Citric Acid pH 4.0, 5% PEG 6000
A2.  0.1 M Citric Acid pH 5.0, 5% PEG 6000
A3.  0.1 M MES pH 6.0, 5% PEG 6000
A4.  0.1 M HEPES pH 7.0, 5% PEG 6000
A5.  0.1 M Tris pH 8.0, 5% PEG 6000
A6.  0.1 M Bicine pH 9.0, 5% PEG 6000
B1.  0.1 M Citric Acid pH 4.0, 10% PEG 6000
B2.  0.1 M Citric Acid pH 5.0, 10% PEG 6000
B3.  0.1 M MES pH 6.0, 10% PEG 6000
B4.  0.1 M HEPES pH 7.0, 10% PEG 6000
B5.  0.1 M Tris pH 8.0, 10% PEG 6000
B6.  0.1 M Bicine pH 9.0, 10% PEG 6000
C1.  0.1 M Citric Acid pH 4.0, 20% PEG 6000
C2.  0.1 M Citric Acid pH 5.0, 20% PEG 6000
[NAME]0.1 M MES pH 6.0, 20% PEG 6000
C4.  0.1 M HEPES pH 7.0, 20% PEG 6000
C5.  0.1 M Tris pH 8.0, 20% PEG 6000
C6.  0.1 M Bicine pH 9.0, 20% PEG 6000
D1.  0.1 M Citric Acid pH 4.0, 30% PEG 6000
D2.  0.1 M Citric Acid pH 5.0, 30% PEG 6000
D3.  0.1 M MES pH 6.0, 30% PEG 6000
D4.  0.1 M HEPES pH 7.0, 30% PEG 6000
D5.  0.1 M Tris pH 8.0, 30% PEG 6000
D6.  0.1 M Bicine pH 9.0, 30% PEG 6000
Spreadsheet: 806639d1669446439-conditional-days-counting-formula-between-two-dates-conditional-days-counting-formula
Sheet: Sheet1

DATE 1 | DATE 2 |  |  | STATUS
2022-11-23 00:00:00 | 2022-04-16 00:00:00
2022-06-19 00:00:00 | 2022-05-09 00:00:00
2022-11-23 00:00:00 | 2022-05-09 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00 | 2022-05-09 00:00:00
2022-11-23 00:00:00
2022-05-28 00:00:00 | 2022-05-09 00:00:00
2022-11-23 00:00:00
2022-10-19 00:00:00
2022-10-19 00:00:00
2022-04-06 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00 | 2022-05-09 00:00:00
2022-08-16 00:00:00 | 2022-03-16 00:00:00
2022-11-23 00:00:00 | 2022-08-02 00:00:00
2022-10-19 00:00:00
2022-11-23 00:00:00 | 2022-07-22 00:00:00
2022-11-23 00:00:00
2022-04-06 00:00:00
2022-05-28 00:00:00 | 2022-05-09 00:00:00
2022-11-23 00:00:00 | 2022-11-03 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00 | 2022-05-09 00:00:00
2022-11-23 00:00:00
2022-04-06 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00 | 2022-04-08 00:00:00
2022-08-16 00:00:00 | 2022-05-09 00:00:00
2022-05-28 00:00:00 | 2022-03-17 00:00:00
2022-11-23 00:00:00 | 2022-05-09 00:00:00
2022-06-19 00:00:00 | 2022-01-05 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00 | 2022-01-23 00:00:00
2022-11-23 00:00:00 | 2022-05-09 00:00:00
2022-11-23 00:00:00 | 2022-05-09 00:00:00
2022-10-19 00:00:00 | 2022-05-09 00:00:00
2022-11-23 00:00:00 | 2022-09-14 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00 | 2022-09-21 00:00:00
2022-10-19 00:00:00 | 2022-06-19 00:00:00
2022-11-23 00:00:00
2022-04-06 00:00:00
2022-11-23 00:00:00
2022-05-28 00:00:00 | 2021-10-25 00:00:00
2022-08-16 00:00:00
2022-08-16 00:00:00 | 2022-05-09 00:00:00
2022-11-03 00:00:00 | 2022-05-09 00:00:00
2022-11-23 00:00:00 | 2022-05-09 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00
2022-02-01 00:00:00
2022-11-23 00:00:00 | 2022-08-27 00:00:00
2022-10-19 00:00:00 | 2022-05-09 00:00:00
2022-11-23 00:00:00
2022-11-23 00:00:00
Spreadsheet: 861579d1709467131-conditional-format-month-in-date-cell-conditional-format-month-in-date-cell
Sheet: Sheet1

no | date | name
1 | 2024-09-15 00:00:00 | [NAME] |  | if date cell belong to month september I want a conditional format rule to color only date cell with a given color like yellow.
2 | 2024-09-03 00:00:00 | Engl |  | I want to have 12 conditional format rules for 12 months.
3 | 2024-08-05 00:00:00 | Fork
4 | 2024-04-01 00:00:00 | [NAME]
5 | 2024-09-05 00:00:00 | Heolt
6 | 2024-12-02 00:00:00 | Molew
Spreadsheet: 40472d1238776622-variables-higgins2
Sheet: Sheet1

 | Budget |  |  | Premium
 | Quantity Rooms | [NAME] | Total [NAME] | Quantity Rooms | [NAME] | Total [NAME]
[NAME] | 40 | 18 |  | 100 | 22
Double Bedroom | 40 | 20 |  | 60 | 25
Club Bedroom | 10 | n/a | 0 | 20 | 35
Reception | 1 | 20 |  | 1 | 40
Restaurant Back of House | 1 | 90 |  | 1 | 95
0.2 per bedroom over
Restaurant Front of House | 1 | 110 |  | 2 | 120
0.3 per bedroom over
Bar | 1 | 70 |  | 1 | 130
Plant Room/Fire Escapes | 5 | 18 |  | 10 | 18
Subtotal Floor Space
Circulation Space 15%
Total [NAME]
Rounded |  |  | 2200 |  |  | 5900
Spreadsheet: 101942d1300011017-subtraction-from-2-cells-weekly_blanket_wash_consumption_master_2
Sheet: wk 1

Blanket Wash / Materials. |  |  |  |  |  |  |  |  |  | BLANKET WASH / BLANKETS
 |  | Week | 8250102    514915-153-716
Date | 2011-02-04 00:00:00 | 1
Clean |  |  | Litres | Dirty |  |  |  | Litres
Stainless Tank |  |  | 600 | Renzmann wash / mach |  |  |  | 300
1,000 Blue Tank |  | 11 | 100 | Holding Stainless/Tank |  |  |  | 1100
Total Litres |  |  | 700 | 2nd holding tank(plastic) |  |  |  | 450
Spare  Tanks |  | 18 | 700
Total |  |  | 1400 | Total |  |  |  | 1850 |  | Filtered Blanket wash
 |  |  |  |  |  |  |  |  |  |  | .
 |  |  |  |  | Tank Changed |  |  | 2011-01-28 00:00:00
Blankets- 595011. 153716 |  |  |  |  | Foils- 514915. 153716
Blue  Graffity |  |  |  | 23 | 0 | Foils
8251506 |  |  |  |  | 23 |  |  |  |  | DATE | 2011-02-04 00:00:00 |  |  | week | 1
Blue Vulcan Editor 20s |  |  |  | 16 | 16 | .18 RB Foils | 26 | 26 |  | WEEKLY BLANKET WASH USAGE
8251507 |  |  |  | used | 0 | 8252002 |  | 0 |  | DATE | CLEAN | DIRTY | TANK | DATE ON | TOTAL
28 up week 25 |  |  |  |  |  |  |  |  |  |  | 2400 | 1600 | 0 |  | 4000
Green Vulcan202Tower Blankets |  |  |  | 25 | 25 | .16 RB Foils | 29 | 29 |  | 2011-02-04 00:00:00 | 1400 | 1850 | 0 |  | 3250
8251500 |  |  |  | used | 0 | 8252001 |  | 0 |  | TOTALS | -1000 | 250 | 0
20 up week 25
Green Vulcan 202 Newsman 40 |  |  |  | 47 | 44 | .18 RB Tower | 49 | 49 |  | TOTAL USED |  | DATE | 2011-02-04 00:00:00 |  | -750 | WEEK 1
8251508 |  |  |  | used | 3 | 8251511 |  | 0 |  |  |  |  |  |  |  | WEEK 2
30 up week 25 |  |  |  |  |  |  |  |  |  | SPARE TANK 1000 |  |  |  |  |  | WEEK 3
Brown Day International |  |  |  | 55 | 0 |  |  |  |  |  |  |  |  |  |  | WEEK 4
 |  |  |  |  | 55 |  |  |  |  |  |  |  |  |  |  | WEEK 5
[NAME] |  |  |  |  |  | Aim Pre Packs |  |  |  |  |  |  |  |  | MONTH | TOTAL | 0
8251502   514940   153-716 |  |  |  |  |  | 8250101 | 96 | 78
 |  |  |  |  |  |  |  | 18 |  | CHEMPORT FOUNT SOL |  |  |  | AIM pre packs
Position A |  | 1000 | 800 |  | Blanketwash Additives
 |  |  |  |  | 514915-153716 |  |  |  |  | DATE | TOTAL | wk33 | Used |  | TOTAL | wk 33 | Used
Position B |  | 700 | 1000 | -300
 |  |  |  |  | 8251501 | Parabar |  | 3 litres wk
Position C |  |  |  | 0 | 8250805 | Isowash |  | 50 litres wk
Spare |  |  |  |  | 8251825 | Surfactant |  | 8 litres wk
Total |  | 1700 |  |  | xl  Pressroom/reports/originals/blanket wash totals
 |  |  |  |  |  |  |  |  |  | Total |  |  | 0 | Total |  |  | 0
Spreadsheet: 766628d1643973494-calculate-up-to-this-day-sum-sheets-v2
Sheet: Month_to_date Sales

EMPLOYEE | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2022-01-03 00:00:00 | 2022-01-04 00:00:00 | 2022-01-05 00:00:00 | 2022-01-06 00:00:00 | 2022-01-07 00:00:00 | 2022-01-08 00:00:00 | 2022-01-09 00:00:00 | 2022-01-10 00:00:00 | 2022-01-11 00:00:00 | 2022-01-12 00:00:00 | 2022-01-13 00:00:00 | 2022-01-14 00:00:00 | 2022-01-15 00:00:00 | 2022-01-16 00:00:00 | 2022-01-17 00:00:00 | 2022-01-18 00:00:00 | 2022-01-19 00:00:00 | 2022-01-20 00:00:00 | 2022-01-21 00:00:00 | 2022-01-22 00:00:00 | 2022-01-23 00:00:00 | 2022-01-24 00:00:00 | 2022-01-25 00:00:00 | 2022-01-26 00:00:00 | 2022-01-27 00:00:00 | 2022-01-28 00:00:00 | 2022-01-29 00:00:00 | 2022-01-30 00:00:00 | 2022-01-31 00:00:00 | Monthly Total
Yoan
Yola
Smith
[NAME]
Spreadsheet: c3e23a25-2f72-49c7-9b3b-a97f7e23c9e2
Sheet: 3.Condition Sum

ID | Condition Name | Condition Description | Repeats Number | Growth Level |  | Internal Correation (Splicing Efficiency) |  | External Correation  (Avergae Splicing Efficiency)
 |  |  |  | [NAME] | YiFP | min | [NAME] | SD | Pval | [NAME] | Pval | Rapa | Pval | Satur | Pval | KCl | Pval
1 | SD complete | SD complete | 4 |  |  | 0.9331 | 0.9617 | 1 | N/A | 0.968 | 5.66671939325649e-145 | 0.9347 | 6.88542204848472e-109 | 0.9767 | 4.05155113239766e-161 | 0.8782 | 7.0917950360112e-78
2 | [NAME] | YNB wo wo + 2% Glucose + HIS + MET | 3 |  |  | 0.9215 | 0.9802 | 0.968 | 5.66671939325649e-145 | 1 | N/A | 0.9441 | 1.18907653627254e-116 | 0.9556 | 2.79641266329942e-128 | 0.8892 | 1.95976640130793e-82
3 | Rapamycin | SD complete + 200ng/ml Rapamycin | 3 |  |  | 0.8754 | 0.9159 | 0.9347 | 6.88542204848472e-109 | 0.9441 | 1.18907653627254e-116 | 1 | N/A | 0.9315 | 1.58761525200273e-106 | 0.8591 | 6.96658858257741e-71
4 | Staurosporine | SD complete + 2µM Staurosporine | 3 |  |  | 0.9066 | 0.9508 | 0.9767 | 4.05155113239766e-161 | 0.9556 | 2.79641266329942e-128 | 0.9315 | 1.58761525200273e-106 | 1 | N/A | 0.878 | 8.82969306574395e-78
5 | KCl |  | 3 |  |  | 0.9825 | 0.9869 | 0.8782 | 7.0917950360112e-78 | 0.8892 | 1.95976640130793e-82 | 0.8591 | 6.96658858257741e-71 | 0.878 | 8.82969306574395e-78 | 1 | N/A
 | This table summarizes the various experimental conditions. For each condition the cherry and YFP average growth level and internal splicing effeminacy correlation are presented. The condition current correlations (Pearson) and p-value with the other condition are presented afterwards.