tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 98368d1297287766-i-have-a-drop-down-list-that-i-want-to-use-to-lookup-text-values-in-another-sheet-copy-of-copy-of-example-2
Sheet: Sheet 1

Group leader | RHA - [NAME] | M.O057C.01.A.0008 |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WBS |  | Oppdragsledere
Oppdatert |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M.O057C.0I.A.0025 |  | AJO - Are Johan Olsen
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M.O057C.0I.A.0025.A |  | AK - Anders Kjøling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M.O057C.0I.A.0025.B |  | FD - Faisal Dahman
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M.O057C.0I.A.0027 |  | GD - Geir Dahle
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M.O057C.0I.A.0027.A |  | GSL - Grethe Sem Larsen
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M.O057C.0I.A.0029 |  | HB - Hallstein Bringsvor
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M.O057C.0I.A.0029.A |  | JA - Jone Alsvik
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M.O057C.0I.A.0029.B |  | JL - Jørgen Lea
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOT 41351004 |  | JS - Jadhav Suryabhan
 | jan | feb | [NAME] | apr | mai | jun | jul | aug | sep | okt | Nov | Des |  |  |  |  |  |  |  |  |  |  |  | NOT 41445380 |  | JSV - Jan Sverre Vea
Estiminert cost, periodic | 0 | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KN - Kjetil Nådland
Accumulated, actual cost | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KR - [NAME]
Accumulated, actual profit | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KRF - Kjell Rune Framvik
[NAME] omsetning, akkum | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MA - Morten Andreassen
EBITDA mål | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MH - Mike Hooker
EBITDA faktisk | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MM - Mansi Mantri
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NB - Neelima Bhaduri
EBITDA margin mål % | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | RHA - [NAME]
EBITDA margin faktisk % | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | SH - Stein Haugland
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TAK - [NAME] Kleveland
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WS - [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AA - Anita Albriktsen
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ÅS - Åge Sjøveian
Spreadsheet: 116782d1312161072-formula-for-conditional-formatting-sample-sheet
Sheet: Sheet1

 |  |  |  |  |  | For example, if WEEKNUM(TODAY()) is any where from row 12 to row15, cell B12 has to be shaded RED and cell B15 BLUE, untill the week number passes row 15 to coincide with row16, then the shading will move to cells B16 & B19, and so on. The week starts MONDAY |  |  |  |  |  |  | Column N can be used instead of column A, if that makes it easier
2011-01-01 00:00:00 | abc |  |  |  |  | A formula is needed to achieve this conditional formatting
 | xyz |  |  |  |  |  |  |  |  |  |  |  | 2011-01-01 00:00:00
2011-02-01 00:00:00 | abc
 | xyz |  |  |  |  |  |  |  |  |  |  |  | 2011-02-01 00:00:00
2011-03-01 00:00:00 | abc
 | xyz |  |  |  |  |  |  |  |  |  |  |  | 2011-03-01 00:00:00
2011-04-01 00:00:00 | abc
 | xyz |  |  |  |  |  |  |  |  |  |  |  | 2011-04-01 00:00:00
2011-05-01 00:00:00 | abc
 | xyz |  |  |  |  |  |  |  |  |  |  |  | 2011-05-01 00:00:00
 | abc
Spreadsheet: 170249d1343218911-production-planning-resource-profile-sumoverlappingarrays5
Sheet: LoadOnProductionCenters

16 | 22 | 62 | 208 | 323 | 243 | 267 | 445 | 356 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ProdCenter1
24 | 24 | 78 | 278 | 264 | 376 | 356 | 356 | 712 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ProdCenter2
22 | 22 | 82 | 227 | 109 | 77 | 267 | 89 | 89 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ProdCenter3
28 | 36 | 100 | 241 | 243 | 94 | 89 | 267 | 178 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ProdCenter4
Period1 | Period2 | Period3 | Period4 | Period5 | Period6 | Period7 | Period8 | Period9 | Period10 | Period11 | Period12 | Period13 | Period14 | Period15 | Period16 | Period17 | Period18 | Period19 | Period20 | Period21 | Period22 | Period23 | Period24 | Period25 | Period26 | Period27 | Period28 | Period29 | Period30 | Period31 | Period32 | Period33 | Period34 | Period35 | Period36 | Period37 | Period38 | Period39 | Period40 | Period41 | Period42 | Period43 | Period44 | Period45 | Period46 | Period47 | Period48 | Period49 | Period50 | Period51 | Period52 | Period53 | Period54
The "Product" sheets contain the production load on every production center at every period (there are 30 of them)
The "PlanningTable" sheet contains the planned order releases
The "LoadOnProductionCenters" sheet contains the solution: the load on every production center caused by all the planned products. Every "Product" sheet has to be added to the "LoadOnProductionCenters" table at the location and with the factor given by the "PlanningTable".
The yellow parts of the "LoadOnProductionCenters" table give wrong (too small) numbers, because they depend on periods smaller than 1 or bigger than 52 of the "PlanningTable"
Spreadsheet: 880022d1727638897-byrow-lambda-to-retrieve-all-negative-amounts-from-a-3-column-list-lambda
Sheet: Forecast 260924

 |  |  |  | 1 | 1 | 5 | 15
Bank's region | Bank | Statement accounts | Currency |  |  |  |  | Conversion | I/C + Deposits
IN | JPM | 50078 | USD
IN | JPM | 50078 | USD
IN | JPM | 50078 | EUR |  | 511740
IN | JPM | 50078 | GBP |  | 73709
IN | JPM | 50078 | AUD
GB | HSBC | 200987 | USD | 7120363
GB | HSBC | 200987 | USD
GB | HSBC | 200987 | GBP
GB | HSBC | 200987 | EUR
GB | HSBC | 200987 | AUD
US | CITIBANK | 7433 | USD
US | CITIBANK | 90807 | NIS
US | CITIBANK | 801.7683883749727 | USD |  | 7003766
US | CITIBANK | 278.3189847924104 | EUR
US | CITIBANK | 175.7076287609073 | GBP |  | 558
US | CITIBANK | 673.7614867316984 | AUD
UK | CITIBANK | 744.6707467759913 | USD
UK | CITIBANK | 726.3982087969856 | GBP
UK | CITIBANK | 675.4697063208389 | AUD
UK | CITIBANK | 829.4605501364579 | EUR
Spreadsheet: 82809d1282828518-indexing-a-row-from-another-worksheet-within-workbook-dummybook
Sheet: Acq. Cycle

 | Year = | 2009 |  |  |  | Production | 400 | 200 | 50 | 120 | 0 | 0 | 0
 | Life Cycle | 7
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | Total
Units: | 0 | 400 | 200 | 50 | 120 | 0 | 0 | 0 | 400 | 200 | 50 | 120 | 0 | 0 | 0 | 400 | 200 | 50 | 120 | 0 | 0 | 0 | 400 | 200
Spreadsheet: 106248d1303412554-logical-test-for-day-calculations-self_populating_headcount_forum
Sheet: Sheet1

Name of employee | HIRE DATE (Current) | TERM DATE (Current) | 2006-01-31 00:00:00 | 2006-02-28 00:00:00 | 2006-03-31 00:00:00 | 2006-04-30 00:00:00 | 2006-05-31 00:00:00 | 2006-06-30 00:00:00 | 2006-07-31 00:00:00 | 2006-08-31 00:00:00 | 2006-09-30 00:00:00 | 2006-10-31 00:00:00 | 2006-11-30 00:00:00 | 2006-12-31 00:00:00 | 2007-01-31 00:00:00 | 2007-02-28 00:00:00 | 2007-03-31 00:00:00 | 2007-04-30 00:00:00 | 2007-05-31 00:00:00 | 2007-06-30 00:00:00 | 2007-07-31 00:00:00 | 2007-08-31 00:00:00 | 2007-09-30 00:00:00 | 2007-10-31 00:00:00 | 2007-11-30 00:00:00 | 2007-12-31 00:00:00 | 2008-01-31 00:00:00 | 2008-02-29 00:00:00 | 2008-03-31 00:00:00 | 2008-04-30 00:00:00 | 2008-05-31 00:00:00 | 2008-06-30 00:00:00 | 2008-07-31 00:00:00 | 2008-08-31 00:00:00 | 2008-09-30 00:00:00 | 2008-10-31 00:00:00 | 2008-11-30 00:00:00 | 2008-12-31 00:00:00 | 2009-01-31 00:00:00 | 2009-02-28 00:00:00 | 2009-03-31 00:00:00 | 2009-04-30 00:00:00 | 2009-05-31 00:00:00 | 2009-06-30 00:00:00 | 2009-07-31 00:00:00 | 2009-08-31 00:00:00 | 2009-09-30 00:00:00
 | 2006-03-22 00:00:00 | 2006-05-31 00:00:00 |  |  | 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 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 2006-07-17 00:00:00 | 2006-10-25 00:00:00 |  |  |  |  |  |  | 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 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Total |  |  | 0 | 0 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
Spreadsheet: 118365d1313624560-need-a-spreadsheet-for-computing-commissions-with-multiple-variables-commissionsplits
Sheet: Report

Anniversary | 2011-01-06 00:00:00 |  |  | Agent Procured |  | Team Procured
 |  |  |  | Count | Rate | Count | Rate
<Anniversary | TRUE |  |  | 10 | 0.7 | 10 | 0.55
Procured | Agent |  |  | 11 | 0.8 | 20 | 0.6
 |  |  |  |  |  | 21 | 0.65
Values
Num Sales | Sales Total | Commision %
12 | 12056943
<Anniversary | TRUE
Procured | Team
Values
Num Sales | Sales Total | Commision %
20 | 19669228
Spreadsheet: 329864d1404434851-searching-if-a-cell-contains-a-range-of-values-example
Sheet: Lookup vlaues

2nd Level | 1st Level
zurich | accountants
z | accountants
y | accountants
xyz | accountants
xxx | accountants
x | accountants
wtf | accountants
worldwide | accountants
world | accountants
website | accountants
want | accountants
w | accountants
Spreadsheet: 147670d1332922710-lookup-values-across-range-of-worksheets-tracker
Sheet: 2011 Jan

ID | Surname | Name | 2011-01-01 00:00:00 | 2011-01-02 00:00:00
1 | Surname1 | Name1 | B | C
2 | Surname2 | [NAME] | E | F
3 | Surname3 | Name3 | G | A
4 | Surname4 | Name4 | D | D
5 | Surname5 | Name5 | A | G
6 | Surname6 | Name6 | F | E
7 | Surname7 | Name7 | C | B
Spreadsheet: 822061d1679071287-separate-string-of-text-and-numbers-and-find-fartherst-right-values-horse-form-2-
Sheet: Sheet1

Horse | Form String | Latest1 | Latest2 | Latest3
Let's Have Another | 342/91517-P |  | 7 | 1
Us And Them | 2583/UFPPP-4 | 4 | P | P
Weebill | 63/871/1231-3 | 3 | 1 | 3
Tonyx | 544/2341F5-5 | 5 | 5 | F
[NAME] | 11-P | P | 1 | 1
Henry's Friend | 132-4 | 4 | 2 | 3
[NAME] | 000/00080- | 0 | 8 | 0
Fromposttopillar | 9 | 9
Hey Mister Dj | 0-6P | P | 6 | 0
Idealdes Villerets | 3/424-3 | 3 | 4 | 2
Import Export | 0 | 0
Bear A Hand | 076- | 6 | 7 | 0
Spreadsheet: 7b8df18f-e54a-445f-a504-59e41e923e0f
Sheet: Sheet1

参 考 表 　　主 要 国 の 消 費 者 物 価 指 数 変 化 率 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Reference Table 　 Rates of Change in Consumer Price Index of Principal Countries
 |  |  |  |  |  |  | 前年(同月)比 (％)
 |  |  |  |  |  |  | Change over the year in ％
 | 日　本 | アメリカ | イギリス | ド イ ツ | フランス | イタリア※ | カ ナ ダ | 韓 　国 | Year
年　月 |  |  |  |  |  |  |  |  | and
 | Japan | United 　 States | United 　 Kingdom | Fed. Rep. 　of Germany | France | Italy | Canada | Rep. of 　 Korea | month
平成 8年平均 | 0.1 | 3 | 2.4 | 1.5 | 2 | 4 | 1.6 | 4.9 | 1996
9 | 1.8 | 2.3 | 3.1 | 1.9 | 1.2 | 2 | 1.6 | 4.4 | 1997
10 | 0.6 | 1.6 | 3.4 | 0.9 | 0.6 | 1.9 | 0.9 | 7.5 | 1998
11 | -0.3 | 2.2 | 1.5 | 0.6 | 0.5 | 1.7 | 1.7 | 0.8 | 1999
12 | -0.7 | 3.4 | 3 | 1.4 | 1.7 | 2.5 | 2.7 | 2.3 | 2000
13 | -0.7 | 2.8 | 1.8 | 2 | 1.7 | 2.8 | 2.6 | 4.1 | 2001
14 | -0.9 | 1.6 | 1.7 | 1.4 | 1.9 | 2.5 | 2.2 | 2.7 | 2002
[NAME] | -1 | 1.9 | 0.9 | 1.5 | 1.2 | 2.4 | 0.7 | 3.4 | Nov. 2001
12 | -1.2 | 1.6 | 0.7 | 1.6 | 1.4 | 2.4 | 0.7 | 3.2 | Dec.
平成14年 1月 | -1.4 | 1.1 | 1.3 | 2.1 | 2.2 | 2.4 | 1.3 | 2.6 | Jan. 2002
2 | -1.6 | 1.1 | 1 | 1.8 | 2 | 2.5 | 1.5 | 2.6 | Feb.
3 | -1.2 | 1.5 | 1.3 | 2 | 2.1 | 2.4 | 1.8 | 2.3 | Mar.
4 | -1.1 | 1.6 | 1.5 | 1.5 | 2 | 2.4 | 1.7 | 2.5 | Apr.
5 | -0.9 | 1.2 | 1.1 | 1.2 | 1.4 | 2.4 | 1 | 3 | May
6 | -0.7 | 1.1 | 1 | 1 | 1.4 | 2.2 | 1.3 | 2.6 | June
7 | -0.8 | 1.5 | 1.5 | 1.2 | 1.6 | 2.3 | 2.1 | 2.1 | July
8 | -0.9 | 1.8 | 1.4 | 1.2 | 1.8 | 2.5 | 2.6 | 2.4 | Aug.
9 | -0.7 | 1.5 | 1.7 | 1.1 | 1.8 | 2.6 | 2.3 | 3.1 | Sep.
10 | -0.9 | 2 | 2.1 | 1.3 | 1.9 | 2.7 | 3.2 | 2.8 | Oct.
11 | -0.4 | 2.2 | 2.6 | 1.2 | 2.2 | 2.8 | 4.3 | 3.5 | Nov.
12 | -0.3 | 2.4 | 2.9 | 1.2 | 2.3 | 2.8 | 3.9 | 3.7 | Dec.
平成15年 1月 | -0.4 | 2.6 | 2.9 | 1.1 | 2 | 2.8 | 4.5 | 3.8 | Jan. 2003
2 | -0.2 | 3 | 3.2 | 1.3 | 2.6 | 2.5 | 4.6 | 3.9 | Feb.
3 | -0.1 | 3 | 3.1 | 1.2 | 2.6 | 2.7 | 4.3 | 4.5 | Mar.
4 | -0.1 | 2.2 | 3.1 | 1 | 2 | 2.5 | 3 | 3.7 | Apr.
5 | -0.2 | 2.1 | 3 | 0.7 | 1.8 | 2.5 | 2.9 | 3.2 | May
6 | -0.4 | 2.1 | 2.9 | 1 | 2 | 2.6 | 2.6 | 3 | June
7 | -0.2 | 2.1 | 3.1 | 0.9 | 1.9 | 2.6 | 2.2 | 3.2 | July
8 | -0.3 | 2.2 | 2.9 | 1.1 | 1.9 | 2.7 | 2 | 3 | Aug.
9 | -0.2 | 2.3 | 2.8 | 1.1 | 2.1 | 2.7 | 2.2 | 3.3 | Sep.
10 | 0 | 2 | 2.6 | 1.2 | 2.2 | 2.5 | 1.6 | 3.7 | Oct.
※　たばこを除く総合
Excluding Tobacco
Spreadsheet: michelle_lokay__26548__RedRockAllocSumm
Sheet: Oneok at 2500

RED ROCK EXPANSION PROJECT
 |  | REQUESTED | REQUESTED
 |  | RECEIPT | DELIVERY |  |  | Allocation
COMPANY |  | POINT | POINT | MMBtu/d | Term/Yrs | Share | Volume
PPL | 27641 | EOT | Griffith | 8000 | 30
 |  | EOT | Socal Needles | 12000 | 30
Western | 27608 | EOT | Socal Needles | 10000 | 15
[NAME] | 27604 | EOT | Socal Needles | 6000 | 15
 | 27605 | EOT | PG&E Topock | 2000 | 15
US Gypsum | 27622 | PH Pool | Socal Needles | 4500 | 12.25
 |  | Central Pool | Socal Needles
 |  | WT Pool | Socal Needles
BP Energy |  | Central Pool | Socal Needles | 15000 | 5
Oneok | 27607 | EOT | Socal Needles | 2500 | 1.8
Calpine | 27642 | EOT | PG&E Topock | 40000 | 15
 |  |  |  |  |  |  |  | West Texas Pool Total Volume
 |  |  | Exclude BP | 15000
 |  |  | Total Req'd
Spreadsheet: 60259d1260826722-multiple-columns-transfered-to-one-column-709494_branco
Sheet: Sheet2

Page1 | (All)
Sum of Value | Column
Row | Jan | Feb | Mar | Apr | May | Jun | Grand Total
Asia:D:bb | 32 | 61 | 52 | 47 | 93 | 64 | 349
Asia:E:cc | 2060 | 312 | 912 | 362 | 3868 | 5454 | 12968
Europe:A:aa | 30 | 41 | 52 | 63 | 64 | 25 | 275
Europe:B:bb | 52 | 42 | 37 | 74 | 63 | 55 | 323
Europe:C:aa | 30 | 41 | 52 | 63 | 64 | 25 | 275
North America:F:aa | 55 | 54 | 107 | 625 | 102 | 107 | 1050
Grand Total | 2259 | 551 | 1212 | 1234 | 4254 | 5730 | 15240
Spreadsheet: 844605d1696369650-how-to-use-the-sum-formula-to-subtract-and-calculate-time-elapsed-from-mm-dd-yy-hh-mm-cell-book-1-
Sheet: Sheet1

Origin OpCo | Work Order # | Sent to OpCo | Acknowledged | Time to Acknowledge | Acknowledged SLA Met | Tech Scheduled | Tech Scheduled SLA Met
Company Name | 1234 | 2023-09-22 12:05:17 | 2023-09-22 12:10:00 |  |  | 2023-09-22 12:56:00
Company Name | 1234 | 2023-09-22 19:20:02 | 2023-09-22 19:22:00 |  |  | 2023-09-23 10:11:00
Company Name | 1234 | 2023-09-23 09:24:52 | 2023-09-23 09:33:00 |  |  | 2023-09-23 10:34:00
Company Name | 1234 | 2023-09-23 10:42:09 | 2023-09-23 10:55:00 |  |  | 2023-09-23 12:29:00
Company Name | 1234 | 2023-09-26 20:20:01 | 2023-09-26 20:42:00 |  |  | 2023-09-27 07:13:00
Company Name | 1234 | 2023-09-27 16:15:48 | 2023-09-27 16:27:00 |  |  | 2023-09-27 16:29:00
Spreadsheet: 25476d1216803714-conditional-formatting-with-more-than-3-rules-book2
Sheet: Sheet1

GREEN | new subs
BLUE | increase
YELLOW | switch
PURPLE | reduce
RED | full red
 | Fund Name | Amount | Size
increase | Fund A | 20 | 0.25
reduce | Fund B | 50 | 0.625
new subs | Fund C | 10 | 0.125
 | Total | 80 | 1
Spreadsheet: 6fed3f7e-072b-45a5-849b-4f639a1bc5f7
Sheet: Sheet1

Table S5: loadings onto the first princpal component of effector expression for Sm-induced and Ef-induced samples | Unnamed: 1 | Unnamed: 2
 | Loadings
Gene | Sm-induced | Ef-induced
AttA | -6.60700617302119 | -4.837598939
AttB | -4.68898985417523 | -1.14187553
AttC | -12.3076869377484 | -11.48123976
AttD | 1.15832304710548 | 2.755364342
Bc | 3.08851803429387 | 3.334425189
Catsup | 3.18916926695108 | 3.145314806
CecA1 | -3.74532838367792 | -0.078943608
CecA2 | -9.64615199797013 | -4.352393301
CecB | 1.51630347462762 | 3.18826624
CecC | -0.833583007564956 | 2.826776169
CG1102 | 2.79924817774568 | 1.522426904
CG15293 | 1.83593302652283 | -1.263650567
CG15825 | -0.129414682796283 | -2.691651832
CG3066 | 2.45254809249635 | 2.150177872
CG6426 | 2.98527595906626 | 0.437948988
CG8913 | -1.18513990303738 | -3.122582946
Ddc | 4.07658058515479 | 4.150303208
Def | -7.28850043796227 | -3.682750791
DoxA2 | 4.28485599683833 | 4.211069697
DoxA3 | 3.45358684377866 | 3.424579515
Dpt | 3.17528709159375 | 3.492430213
DptB | -14.9803815618828 | -14.49074262
Dro | 2.21658537838416 | 2.951229846
dro2 | 3.239617944293 | 3.358648751
[NAME] | 2.40664803244451 | 2.406438974
dro4 | 3.51600737669769 | 4.779426523
dro5 | 2.31362233141059 | 3.153791925
dro6 | 3.40966823661446 | 3.460635518
Drs | -5.88819743655983 | -8.01969228
Drsl | 3.24042987241633 | 3.421562741
Hml | 2.72359120288414 | 3.213045465
IM1 | -2.29232351706091 | -4.977794908
IM10 | -1.11645770176416 | -7.366236
IM2 | -1.82315143974321 | -6.923841627
IM23 | -3.22520007618127 | -11.74157975
IM3 | 0.610536648109664 | -2.221251919
IM4 | -2.05280863693139 | -6.28824814
LysB | 5.18743416623134 | 4.461373875
[NAME] | 3.76661640233761 | 3.004899946
LysD | 4.61923349555413 | 3.342844109
LysE | 5.77761670202795 | 4.775327731
LysP | 4.46085920609116 | 4.353936626
LysS | 3.24111849817353 | 3.070006059
LysX | 3.61540903628608 | 3.618786404
Mtk | -13.5563615912909 | -14.81324341
ple | 3.4393097692979 | 3.775741744
Pu | 0.657644700369011 | 1.957921255
Spn27A | 2.62476715771543 | 2.616810673
Tig | 3.1836873803654 | 3.001802577
TotA | -5.88036187547637 | -3.389773511
TotB | 1.99809605989543 | 2.92417112
TotC | -10.1468419245539 | -4.284441181
TotF | 3.26064076478369 | 3.284077815
TotM | -11.8907143787138 | -6.939454407
TotX | -2.39320217330214 | 0.725499045
TotZ | 3.29759708490679 | 3.432806357
Tsf1 | 3.09851104607851 | 3.013806988
Tsf2 | 3.26660499944668 | 3.341187809
Tsf3 | 3.39274524990503 | 3.741611779
yellowf | 1.86179957674545 | 1.281981791
yellowf2 | 3.23577577577404 | 3.000530442
Spreadsheet: eric_saibi__9835__100301R
Sheet: Calderwood 03

Owner Name |  | Tapoco Inc
Station Name |  | Calderwood Hydro
Unit Name |  | Hydro 03
NERC Region |  | SERC
State |  | TN
Fuel Type |  | Hydro
Capacity |  | 41 MW
Start Date |  | 2001-10-26 00:00:00
End Date |  | 2004-11-26 00:00:00
Prv. Start Date |  | 2001-10-03 00:00:00
Prv. End Date |  | 2001-12-31 00:00:00
Comments |  | Rebuild
SIC |  | 4931
Plant ID |  | 1032627
Unit ID |  | 1012077
Outage ID |  | 14162
Spreadsheet: 57587d1257796767-summing-total-with-pushbutton-testtt6
Sheet: Year 5B

 | Surname | Forename | Gender | Read | Write | FSM | Math | Science
 | One | [NAME] | M | 1 | 1 | Y | 1 | 1
 | Two | [NAME] | F | 2 | 2 | N | 2 | 2
 | Three | [NAME] | M | 3 | 3 | N | 3 | 3
 | Four | Devine | F | 4 | 4 | N | 4 | 4
Spreadsheet: 034af40e-e6d4-464e-bff2-7b09b12e5c9d
Sheet: Budget Summary

Budget Summary
Operating Budget |  |  |  |  | Capital Budget
Revenue |  |  |  |  | Revenue
 |  |  |  |  |  | Transfer from operating budget
 |  |  |  |  |  | Carryover
 | Total Revenue
Expenditures |  |  |  |  | Expenditures
 | Salaries, Fringes, TH |  |  |  |  | Capital Outlay > $5,000
 | Travel
 | Operating Expenses
 | Capital Outlay <$5,000
 | Transfer to capital budget
 | Total Expenditures |  |  |  | Total Expenditures
Net |  |  |  |  | Net
Spreadsheet: 84137d1284128213-calculating-xirr-quarterly-or-any-time-period-xirr
Sheet: Sheet1

 | Cash Flows | Exit Values | Total |  |  | XIRR
2011-01-01 00:00:00 | -125000000 |  | -125000000 | -125000000 | -125000000
2011-03-31 00:00:00 | 0 | 126584822.6170695 | 126584822.6170695 | 0 | 0 | 0.05302772819995881
2011-06-30 00:00:00 | 179750.1134444263 | 129979286.3220145 |  | 130159036.4354589 | 179750.1134444263 | 0.08546673953533172
2011-09-30 00:00:00 | 148245.3543846125 | 133430242.3254989 |  |  | 133578487.6798835 | 0.09517742693424223
2011-12-31 00:00:00 | 149264.5998908377 | 136905030.5987923
2012-03-31 00:00:00 | 150271.6918238655 | 143453163.8261918
2012-06-30 00:00:00 | 190893.8135890684 | 150111905.0570636
2012-09-30 00:00:00 | 158524.0873801282 | 156850844.9197137
2012-12-31 00:00:00 | 159551.5892228128 | 163635267.924807
2013-03-31 00:00:00 | 160550.8717074196 | 168337695.1745655
2013-06-30 00:00:00 | 208619.3894162322 | 173238404.0992607
2013-09-30 00:00:00 | 175471.5406454564 | 178206045.5812361
2013-12-31 00:00:00 | 176590.5369628062 | 183151633.0461133
Spreadsheet: 735961d1623279180-help-on-calculating-deposit-amounts-based-on-percentages-and-adding-totals-for-each-month-example-summary-sheet-calculation
Sheet: Conversations

Conversation Analysis | Q1 | Q2 | Q3 | Q4
Qualified as Opportunity
[NAME]
- Type Of Work
- Budget
- Out of area
- No land
- Own Plan - Want Free QUOTE
- Built before with another builder who is quoting
- Rude (High D)
Add yours
Add yours
Total
Spreadsheet: dana_davis__4484__Church Anniversay Expenditures
Sheet: Sheet1

 | Church Anniversary Expenditures
 | Current Amount of Funds Available | 2311.5
 | Lighting/Sound Equipment | -1150
 | Mailing/Postage | -150
 | Global Radio | -450
 | Musician | -200
 | [NAME] | -100
 | [NAME] | -437.5
 | Staging/Chairs | -600
 | Meeting Room | -50
 | Fundraiser Mail Out | -100
 | Special Guest (times 3) | -900
 | Ticket Fee (House of Robes) | -250
 | DJ/MC | -250
 | [NAME] | -500
 | Printing & Production (Ad Booklet)
 | Hospitality (Refreshments/Water)
 |  | 2311.5
Spreadsheet: chris_stokley__3876__CDWR 7day settlements
Sheet: Invoice6

 | INVOICE DETAIL
 |  |  |  |  |  | ENRON POWER MARKETING, INC.
CUSTOMER INFORMATION |  |  | INVOICE INFORMATION |  |  |  |  | CONTRACT INFORMATION |  | PAYMENT INFORMATION
California Energy Resources Scheduling |  |  | INVOICE NUMBER: |  | NTP010409 |  |  | CONTRACT NO: | 95001154 | WIRE TRANSFER:
PO Box 942836 |  |  | INVOICE DATE: | 2001-04-04 00:00:00 |  |  |  | CONTRACT DATE: |  | Enron Power Marketing Inc.
Sacremento, California |  |  | DUE DATE: | 2001-04-06 00:00:00 |  |  |  |  |  | Bank Of America - Dallas, TX
94236-0001 |  |  |  |  |  |  |  | TERMS: rolling seven day cycle per confirmation |  | Account Number:  [PHONE]
Attn: Cecilia Vasquez |  |  | CONTACT: | [NAME] |  |  |  |  |  | ABA Number:  111000012
Phone: [PHONE] |  |  | Phone:  (713)  853-9741
Fax:        [PHONE] |  |  | Fax:      (713)  646-4061
TO INVOICE FOR SALES FOR THE MONTH OF March 2001
 |  |  | DATES |  | HOUR |  |  | ENERGY | PRICE | PRICE | TOTAL
[NAME] |  |  | START | END | START | END |  | [NAME] | CODE | $[NAME] | DOLLARS
SALES |  |  | 2001-03-29 00:00:00 | 2001-03-31 00:00:00 |  |  |  | 9600 |  |  | 2544000
SALES |  |  | 2001-03-29 00:00:00 | 2001-03-31 00:00:00 |  |  |  | 7200 |  |  | 500400
TOTAL NET DUE ENRON POWER MARKETING, INC.