tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 868409d1715159891-dynamic-formula-or-something-else-yoy-growth-v2-ans
Sheet: Source Data This Year

Owner | Company | R P1 | GP P1 | R P2 | GP P2 | R P3 | GP P3 | R P4 | GP P4 | R P5 | GP P5 | R P6 | GP P6 | R P7 | GP P7 | R P8 | GP P8 | R P9 | GP P9 | R P10 | GP P10 | R P11 | GP P11 | R P12 | GP P12 | R P13 | GP P13
Seller 1 | Customer 1 | 196.35 | 67.72 | 49.88 | 21.75
Seller 2 | Customer 2
Seller 3 | Customer 3 | 24.11 | 24.11 | 123.27 | 72.38999999999999
Seller 4 | Customer 4 | 337.41 | 264.5700000000001 | 233.92 | 181.1
Seller 5 | Customer 5 | 28.09 | 28.09
Seller 6 | Customer 6
Seller 7 | Customer 7 | 134.52 | 94.26000000000002 | 73.86 | 49.92
[NAME] 8 | Customer 8 | 151.76 | 44.83403722 | 22.82 | 6.275500000000002
Seller 9 | Customer 9 | 10.84 | 2.981
Seller 10 | Customer 10 | 184.08 | 171.06 | 59.4 | 45.08
Seller 11 | Customer 11 | 1282.32 | 1014.65 | 568.63 | 366.72
Seller 12 | Customer 12 | 513.46 | 302.48 | 35.61 | 17.56
Seller 13 | Customer 13 | 792.15 | 671.91
[NAME] 14 | Customer 14 | 13698.6 | 7897.879999999996 | 2711.279999999999 | 1560.71
Seller 15 | Customer 15 | 266.5 | 136.4914322 | 23.41 | 6.43775
Seller 16 | Customer 16
Seller 17 | Customer 17 | 1805.65 | 863.2699999999999 | 381.46 | 224.59
Seller 18 | Customer 18 | 57.21 | 45.04
Seller 19 | Customer 19
[NAME] 20 | Customer 20 | 440.9899999999999 | 351.05 | 19.97 | 14.83
Seller 21 | Customer 21
Seller 22 | Customer 22 | 110.47 | 70.4 | 35.54 | 22.52
Seller 23 | Customer 23 | 62.59 | 51.29000000000001
Seller 24 | Customer 24 | 42.64 | 30.34
Seller 25 | Customer 25
Seller 26 | Customer 26
Seller 27 | Customer 27
Seller 28 | Customer 28 | 208.14 | 169.29
Seller 29 | Customer 29 | 44.1 | 44.1 | 80.2 | 80.2
Seller 30 | Customer 30 | 50 | 10 | 50 | 10
Spreadsheet: 09eeeffb-ce0a-40f8-8b7b-ab9f4b674f9a
Sheet: Sheet1

Category 2 Centre Focal Point list
Name | Country | Institute | [NAME]
(Ms) [NAME] | China | World Heritage Institute for Training and Research in Asia and the Pacific (WHITR-AP) | [EMAIL]
[NAME] | Norway | Nordic World Heritage Foundation (NWHF) | [EMAIL]
(Mr) [NAME] | South Africa | African World Heritage Fund (AWHF) | [EMAIL]
(Mr) [NAME] | Bahrain | Arab Regional Centre for World Heritage (ARC-WH) | [EMAIL]
(Mr) [NAME] | Mexico | Regional World Heritage Institute in Zacatecas | [EMAIL]
(Ms) [NAME] | Mexico | Regional World Heritage Institute in Zacatecas | [EMAIL]
(Mr) [NAME] | Italy | International Research Centre on the Economics of Culture and World Heritage Studies | [EMAIL]
[NAME] | Brazil | Regional Heritage Management Training Centre "Lucio Costa" (IPHAN) | [EMAIL]
(Ms) [NAME] | Spain | International Centre for Rock Art and the World Heritage Convention | [EMAIL]
(Ms) [NAME] | Spain | International Centre for Rock Art and the World Heritage Convention | [EMAIL]
[NAME] | N/A | ICCROM | [EMAIL]
[NAME] | N/A | ICCROM | [EMAIL]
Regina Durighello | N/A | ICOMOS | [EMAIL]
[NAME] | N/A | IUCN | [EMAIL]
[NAME] | N/A | IUCN | [EMAIL]
Spreadsheet: diana_scholtes__8610__STNW PMA PRELIM
Sheet: STNW

EPMI ST NW prior month adjustments to be entered at the end of Nov 01':
Initial | Type | Del. Period | Desk | Counterparty | Reg | Vol | $ | Explanation
EL | S | 2001-10-01 00:00:00 | EPMI-ST-NW | MIRANTAMEENE | R9 | 0 | 544 | 808867.1,808688.1 DJ-MC index update
GW | S | 2001-03-01 00:00:00 | EPMI-ST-NW | PACIFICOR | R9 | 0 | -600 | 533853.1 120mw price chg fr 265 to 260=($600)
GW | S | 2001-02-01 00:00:00 | EPMI-ST-NW | Portland General Electric Company | R8 | 32400 | -10760 | DPR 510940.1 DJ index settling ($10,760.) 400mw price change from 195.9 to 222.8
GW | S | 2001-01-01 00:00:00 | EPMI-ST-NW | Portland General Electric Company | R9 | 113669 | -9238.26 | 495129.1,495129.2 DJ index settling
GW | S | 2001-09-01 00:00:00 | EPMI-ST-NW | PORTLANDGENELE | R9 | 0 | -580 | 519874.2,519874.3 DJ price settling ($580.)
GW | P | 2001-09-01 00:00:00 | EPMI-ST-NW | PORTLANDGENELE | R9 | 0 | -282.1 | multiple deals DJ price settling ($282.10)
GW | P | 2001-07-01 00:00:00 | EPMI-ST-NW | PORTLANDGENELE | R9 | 0 | 730.08 | 695822.1 DJ price settled 72mw price [NAME] 49.94 tp 39.80= 730.08
GW | P | 2001-02-01 00:00:00 | EPMI-ST-NW | PORTLANDGENELE | R9 | 104640 | -162309.44 | Multiple deals ($162,309.44) DJ index settling
GW | S | 2001-02-01 00:00:00 | EPMI-ST-NW | PORTLANDGENELE | R9 | -73840 | 181028.96 | 529171.1 DJ price settling 4,256mw price chg fr 152.04 to 194.575 $181,028.96
DQ | S | 2001-08-01 00:00:00 | EPMI-ST-NW | POWEREXCOR | R9 | 15 | -150 | 744668.1 added HE 1  15 mws @ $10
Spreadsheet: marie_heard__24510__Peoples Gas Light & Coke Company
Sheet: ANEWSWP2

ISDA SWAP AGREEMENT INFORMATION SHEET
 |  | ATTORNEY:
DATE: | 2001-08-13 00:00:00 | DEAL MAKER:
COUNTERPARTY: | The Peoples Gas Light & Coke Company | CONTACT: | [NAME]
ADDRESS: | 205 N Michigan | TITLE: | Credit Manager
 | Ste 4216 | PHONE: | [PHONE]
 | Chicago IL, 60601 | FAX: | [PHONE]
Incorporation State |  | S&P Rating | AA-
STRUCTURE | COUNTERPARTY | ENA
GUARANTOR (RATING) |  | Enron Corp. (BBB+)
LIMIT $ MILLIONS |  | $10MM
Incorporation State |  | Oregon
ELEGIBLE SWAP PARTICIPANT
Counterparty | YES | YES
Guarantor
COLLATERAL  THRESHOLD MATRIX in $ MILLIONS
based on S & P and
Moody's ratings | $3MM | $10MM
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | X | X
Cash | X | X
Treasuries/Maturity limit
MINIMUM TRANSFER $ | 0 | 0
COLLATERAL ROUNDING
Delivery Amount | 250000 | 250000
Return Amount | 250000 | 250000
HOLDING and USE OF COLLATERAL
Permitted | X | X
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty
-Guarantor | X | X
Debt Ratings Change | X | X
-Below = S&P/Moody's | BBB- | BBB- | S&P
Financial Covenants
-Funded Debt to Worth
-Minimum Net Worth
-EBITDA/Interest Expense
-Funded Debt / EBITDA
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty ($[NAME])
-Guarantor ($[NAME]) | $30MM | 100
Change in ownership
SPECIFIED ENTITY
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: | NO:
OTHER COMMENTS:
GLOBAL CREDIT:  Please complete the attached form below if the following conditions exist:
A)  No previous guidance limit exists or .....
B)  The proposed contractual limits exceed the existing guidance limits.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x5-3596
Spreadsheet: 36724d1234588680-pivot-gain-loss-over-time-date-range-covers-a-certain-month
Sheet: Sheet1

 |  | Month> | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  | Year> | 2008 | 2008 | 2008 | 2008 | 2008 | 2008 | 2008 | 2008 | 2008 | 2008 | 2008 | 2008
 | Result | svc1 | 2 | 3 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1
 |  | svc2 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0
 |  | svc3 | 0 | 1 | 1 | 2 | 3 | 2 | 1 | 2 | 2 | 1 | 2 | 2
svc1 | 2008-01-03 00:00:00 | 2008-02-18 00:00:00 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
svc1 | 2008-01-15 00:00:00 | 2008-12-16 00:00:00 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
svc1 | 2008-02-15 00:00:00 | 2008-06-27 00:00:00 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0
svc1 | 2008-07-01 00:00:00 | 2008-07-10 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
svc2 | 2008-05-29 00:00:00 | 2008-08-05 00:00:00 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0
svc2 | 2008-09-03 00:00:00 | 2008-10-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0
svc3 | 2008-04-13 00:00:00 | 2008-12-31 00:00:00 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
svc3 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0
svc3 | 2008-11-05 00:00:00 | 2008-12-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1
svc3 | 2008-02-18 00:00:00 | 2008-03-01 00:00:00 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
svc3 | 2008-04-01 00:00:00 | 2008-05-26 00:00:00 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
svc3 | 2008-08-16 00:00:00 | 2008-09-05 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0
Spreadsheet: 268790d1380826905-sumproduct-formula-working-on-all-but-one-worksheet-2012-inpt-mb
Sheet: Feb

February |  |  |  |  |  |  | 2
Expenses | Total Expenses HTG | Total Expenses USD | Inpatient Total HTG | Inpatient Total USD | Outpatient Total HTG | Outpatient Total USD
bongu/juice
formula
patient food
medical supplies
medical services
medication
x-ray
office supplies
photocopy
other transportation
outpatient nurse for injections
employee compensation
school
other expenses
phone list
physical phone
telephone minutes
oxygen
volunteer expenses
patient transportation
Spreadsheet: 130011d1322005543-what-to-replace-indirect-with-making-it-less-volatile-indirect_vlookup
Sheet: Sheet1

ID
1 | 1 |  |  | Sheet1
2 | 1 |  |  | A
3 | 1 |  |  | 1
4 | 1 |  |  | A
5 | 1 |  |  | 32
6 | 1
7 | 1
8 | 1
9 | 1
10 | 1
11 | 1
12 | 1
13 | 1
14 | 1
15 | 1
16 | 1
17 | 1
18 | 1
19 | 1
20 | 1
21 | 1
22 | 1
23 | 1
24 | 1
25 | 1
26 | 1
27 | 1
28 | 1
29 | 1
30 | 1
31 | 1
Spreadsheet: 493890d1481930642-using-sumproduct-when-array-contains-some-cells-with-text-sumproduct-with-some-text-cells-in-array
Sheet: Sheet1

 | Type 1 | Type 2 | Type 3 | Type 4
2016-12-01 00:00:00
2017-01-01 00:00:00
2017-02-01 00:00:00
2017-03-01 00:00:00
Spreadsheet: 847103d1698181938-multiple-conditional-formatting-rules-applied-to-same-cell-anonymous-2-geotech-major-project-schedule-2
Sheet: 2023 Schedule & Crews

 | Sunday
 | 2023-07-30 00:00:00
 | UnavailableStaff |  |  | Support Equipment
 |  | DAY SHIFT | NIGHT SHIFT
Auger (Truck)
R-38
R-42
R-44
R-48
R-78
Dual Rotary
R-54
R-68
Mud Rotary
R-75
Sonic (Truck)
R-41
R-43
R-46
R-53
[NAME]
R-45
R-49
[NAME]
R-63
R-70
Spreadsheet: darrell_schoolcraft__7802__imbalsumm0108
Sheet: DEFS

 | 23995 |  | 22051 |  | 22051
 | 59687 |  | 10703 |  | 78169
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 |  |  | 17879 | 24612
2 |  |  | 15280 | 24612
3 |  |  | 22363 | 24612
4 |  |  | 22522 | 24612
5 |  |  | 25194 | 24612
6 |  |  | 25342 | 24612
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30 |  |  |  |  |  |  |  |  | CBS Volume | 23995 | 22051
31 |  |  |  |  |  |  |  |  |  | -178485 | -74599
 |  |  |  |  |  |  |  |  |  |  | 22864 | -24566
2001-07-31 00:00:00 | Balance | -1023166 |  |  |  | -473640 |  |  |  |  | 20379 | 2979
2001-08-06 00:00:00 | Balance |  |  |  |  |  |  |  |  |  | 21459 | 6776
 |  |  |  |  |  |  |  |  |  |  | 26357 | 26521
 |  |  |  |  |  |  |  |  |  |  | 21544 | 36108
 |  |  |  | Contract # |  |  |  |  |  |  | 24532 | 48590
 |  |  |  | 22864 |  |  | -58339.66 | Zia
 |  |  |  | 20379 |  |  | -51695.87 | Grayco/Artesia
 |  |  |  | 21459 |  |  | 10570.56
 |  |  |  | 26357 |  |  | 44144.84 | [NAME]
 |  |  |  | 21544 |  |  | 61340.16 | [NAME], [NAME]
 |  |  |  | 24532 |  |  | -671608.5 | 500211,500212,500219,500230 - Coburn points
 |  |  |  | Duke
Spreadsheet: 75918d1276528385-how-to-use-a-lookup-hlookup-book2_june14
Sheet: Sheet2

heading1 | heading2 | heading3 | heading4 | heading5
0 | 0 | 0 | 5 | 0
0 | 3 | 4 | 6 | 0
4 | 2 | 2 | 0 | 0
heading4 | heading5
heading2 | heading5
heading1 | heading4
Spreadsheet: 153473d1335929200-consolidating-data-in-different-columns-consolidate
Sheet: Sheet2

 |  |  |  |  |  | Input |  |  |  |  | Result
 |  |  |  | 1 | 2 | 3 | 4 | 5 |  | 1 | 2 | 3
 |  |  |  |  | s |  | ab | d |  | s | ab | d
 |  |  |  | wg |  | s |  |  |  | wg | s
 |  |  |  |  |  | qer |  | w |  | qer | w
Spreadsheet: larry_campbell__20964__Kingman3
Sheet: Example

[NAME]
RED ROCK EXPANSION PROJECT
KINGMAN COMPRESSOR STATION
Table 6
EXAMPLE EMISSION CALCULATIONS
GE LM2500 TURBINE
[NAME]
Maximum Hourly (lb/hr)
 | lb/hr = | maximum hourly emission rate at 64% load at 00F x 1.15
Annual (ton per year)
 | tpy = | (80% x annual avg emission rate) + (20% x annual emission rate based on maximum hourly) x 1.15
 |  | ((0.8 x 109.06) + (0.2 x 121.76)) x 1.15
CO Emissions
Maximum Hourly (lb/hr)
 | lb/hr = | maximum hourly emission rate at 64% load at 00F x 1.15
Annual (ton per year)
 | tpy = | (80% x annual avg emission rate) + (20% x annual emission rate based on maximum hourly) x 1.15
 |  | ((0.8 x 66.58) + (0.2 x 74.02)) x 1.15
VOC Emissions
Maximum Hourly (lb/hr)
 | lb/hr = | maximum hourly emission rate at 64% load at 0oF x 10% NMHC x 1.15
Annual (ton per year)
 | tpy = | ((80% x annual avg emission rate) + (20% x annual emission rate based on maximum hourly)) x 10% NMHC x 1.15
 |  | ((0.8 x 22.34) + (0.2 x 25.84)) x 0.1 x 1.15
Particulate Emissions
Maximum Hourly (lb/hr)
 | lb/hr = | maximum heat rate at 50% load at 95oF x AP42 factor lb/[NAME] x 1.15
 |  | 385.80 [NAME]/hr x 6.6E-3 lb/MMBtu x 1.15
Annual (ton per year)
 | tpy = | avg heat rate at base load at 60oF x AP42 factor lb/MMBtu x 8760 hrs/yr x 1 ton/2000 lbs x 1.15
 |  | 211.15 MMBtu/hr x 6.6E-3 lb/MMBtu x 8760 / 2000 x 1.15
SO2 Emissions
Maximum Hourly (lb/hr)
 | lb/hr = | maximum heat rate at 50% load at 95oF x AP42 factor lb/[NAME] x 1.15
 |  | 385.80 [NAME]/hr x 3.4E-3 lb/[NAME] x 1.15
Annual (ton per year)
 | tpy = | avg heat rate at base load at 60oF x AP42 factor lb/MMBtu x 8760 hrs/yr x 1 ton/2000 lbs x 1.15
 |  | 211.15 MMBtu/hr x 3.4E-3 lb/MMBtu x 8760 / 2000 x 1.15
Formaldehyde Emissions
Maximum Hourly (lb/hr)
 | lb/hr = | maximum heat rate at 50% load at 95oF x AP42 factor lb/[NAME] x 1.15
 |  | 385.80 [NAME]/hr x 7.1E-4 lb/MMBtu
Annual (ton per year)
 | tpy = | avg heat rate at base load at 60oF x AP42 factor lb/MMBtu x 8760 hrs/yr x 1 ton/2000 lbs x 1.15
 |  | 211.15 MMBtu/hr x 7.1E-4 lb/MMBtu x 8760 / 2000 x 1.15
Spreadsheet: 709622d1608455704-next-due-date-of-my-air-ticket-after-my-leave-days-next-due-days-with-formula
Sheet: Sheet1

 | AIR TICKET |  |  |  |  |  |  |  |  | Days off
 | LEAVE DAYS FROM LAST DUE DATE |  |  |  |  |  |  |  |  | 2019-08-01 00:00:00
 | LEAVE FROM | LEAVE TO | DAYS |  |  |  |  |  |  | 2019-09-01 00:00:00
 | 2019-08-01 00:00:00 | 2019-08-01 00:00:00 |  |  |  |  |  |  |  | 2019-09-02 00:00:00
 | 2019-09-01 00:00:00 | 2019-09-15 00:00:00 |  |  |  |  |  |  |  | 2019-09-03 00:00:00
 | 2019-12-20 00:00:00 | 2019-12-30 00:00:00 |  |  |  |  |  |  |  | 2019-09-04 00:00:00
 | 2020-03-18 00:00:00 | 2020-03-19 00:00:00 |  |  |  |  |  |  |  | 2019-09-05 00:00:00
 | 2020-03-30 00:00:00 | 2020-03-30 00:00:00 |  |  |  |  |  |  |  | 2019-09-06 00:00:00
 | 2020-09-01 00:00:00 | 2020-09-18 00:00:00 |  |  |  |  |  |  |  | 2019-09-07 00:00:00
 | 2020-12-01 00:00:00 | 2020-12-03 00:00:00 |  |  |  |  |  |  |  | 2019-09-08 00:00:00
 |  |  |  |  |  |  |  |  |  | 2019-09-09 00:00:00
 | LAST DUE DATE | 2019-02-28 00:00:00 |  |  |  |  |  |  |  | 2019-09-10 00:00:00
 |  |  |  |  |  |  |  |  |  | 2019-09-11 00:00:00
 | DUE DURATION | AFTER LEAVE DAYS 365 WORKED DAYS |  |  |  |  |  |  |  | 2019-09-12 00:00:00
 |  |  |  |  |  |  |  |  |  | 2019-09-13 00:00:00
 | NEXT DUE DATE | ANSWER ??? | <======= | FORMULA NEED |  |  |  |  |  | 2019-09-14 00:00:00
 |  |  | LEAVE DAYS | DUE DURATION | TOTAL DAYS FOR DUE |  |  |  |  | 2019-09-15 00:00:00
 | CORRECT ANSWER |  | 29 | 365 |  |  |  |  |  | 2019-12-20 00:00:00
 |  |  |  |  |  |  |  |  |  | 2019-12-21 00:00:00
 |  |  |  |  |  |  |  |  |  | 2019-12-22 00:00:00
 |  |  |  |  |  |  |  |  |  | 2019-12-23 00:00:00
 |  |  |  |  |  |  |  |  |  | 2019-12-24 00:00:00
 |  |  |  |  |  |  |  |  |  | 2019-12-25 00:00:00
 |  |  |  |  |  |  |  |  |  | 2019-12-26 00:00:00
 |  |  |  |  |  |  |  |  |  | 2019-12-27 00:00:00
 |  |  |  |  |  |  |  |  |  | 2019-12-28 00:00:00
 |  |  |  |  |  |  |  |  |  | 2019-12-29 00:00:00
 |  |  |  |  |  |  |  |  |  | 2019-12-30 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-03-18 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-03-19 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-03-30 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-09-02 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-09-03 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-09-04 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-09-05 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-09-06 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-09-07 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-09-08 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-09-09 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-09-10 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-09-11 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-09-12 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-09-13 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-09-14 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-09-15 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-09-16 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-09-17 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-12-02 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-12-03 00:00:00
Spreadsheet: 149792d1334143788-do-not-display-calculated-cell-value-time-format-in-timesheet-timesheet_ex
Sheet: holidays

2012-01-01 00:00:00
2012-01-06 00:00:00
2012-04-06 00:00:00
2012-04-09 00:00:00
2012-05-01 00:00:00
2012-05-08 00:00:00
2012-07-05 00:00:00
2012-08-29 00:00:00
2012-09-01 00:00:00
2012-09-15 00:00:00
2012-11-01 00:00:00
2012-11-17 00:00:00
2012-12-24 00:00:00
2012-12-25 00:00:00
2012-12-26 00:00:00
2013-01-01 00:00:00
2013-01-06 00:00:00
2013-03-29 00:00:00
2013-04-01 00:00:00
2013-05-01 00:00:00
2013-05-08 00:00:00
2013-07-05 00:00:00
2013-08-29 00:00:00
2013-09-01 00:00:00
2013-09-15 00:00:00
2013-11-01 00:00:00
2013-11-17 00:00:00
2013-12-24 00:00:00
2013-12-25 00:00:00
2013-12-26 00:00:00
2014-01-01 00:00:00
2014-01-06 00:00:00
2014-04-18 00:00:00
2014-04-21 00:00:00
2014-05-01 00:00:00
2014-05-08 00:00:00
2014-07-05 00:00:00
2014-08-29 00:00:00
2014-09-01 00:00:00
2014-09-15 00:00:00
2014-11-01 00:00:00
2014-11-17 00:00:00
2014-12-24 00:00:00
2014-12-25 00:00:00
2014-12-26 00:00:00
2015-01-01 00:00:00
Spreadsheet: 827494d1682739225-conditionally-skip-or-continue-auto-numbering-numbering-sheet
Sheet: Test

Client | Study Type | Doc # | Rev. | Lot # | Record # | Description | Comments | Date Initiated | Status | Date Closed/ Voided
Client 7 | Study C | 1558 | 0 | lot 2 |  |  |  | 2021-08-29 00:00:00 |  | 2021-08-31 00:00:00
Client 7 | Study C | 1558 | 1 | lot 3 |  |  |  | 2021-04-30 00:00:00 |  | 2021-12-16 00:00:00
Client 7 | Study C | 1558 | 1 | lot 3 |  |  |  | 2021-04-30 00:00:00 |  | 2021-12-16 00:00:00
Client 2 | Study C | 13032 | 2 | lot 4 |  | expected outcome: 01 |  | 2021-12-10 00:00:00 |  | 2021-12-17 00:00:00
Client 2 | Study C | 13032 | 2 | lot 4 |  | expected outcome: 02 |  | 2021-05-04 00:00:00 |  | 2021-11-22 00:00:00
Client 2 | Study C | 13032 | 2 | lot 4 |  | expected outcome: 03 |  | 2022-02-18 00:00:00 |  | 2022-02-20 00:00:00
Client 2 | Study C | 13032 | 2 | lot 5 |  | expected outcome: blank | void skip number | 2022-02-18 00:00:00 |  | 2022-02-20 00:00:00
Client 2 | Study C | 13032 | 2 | lot 5 |  | expected outcome: 04 | void continue number | 2022-02-19 00:00:00 |  | 2022-02-20 00:00:00
Client 2 | Study C | 13032 | 2 | lot 5 |  | expected outcome: 05 |  | 2022-02-20 00:00:00 |  | 2022-03-05 00:00:00
Client 3 | Study A1 | 5080 | 3 | lot 100 |  |  |  | 2022-02-25 00:00:00 |  | 2022-03-02 00:00:00
Client 3 | Study A1 | 5080 | 3 | lot 100 |  |  |  | 2021-08-19 00:00:00 |  | 2022-03-08 00:00:00
Client 3 | Study A1 | 5080 | 3 | lot 100 |  |  |  | 2021-08-18 00:00:00 |  | 2022-03-03 00:00:00
Client 3 | Study A1 | 5080 | 3 | lot 100 |  |  |  | 2021-08-18 00:00:00 |  | 2022-04-01 00:00:00
Client 3 | Study A1 | 5080 | 3 | lot 100 |  |  |  | 2021-11-10 00:00:00 |  | 2022-03-02 00:00:00
 |  |  |  |  |  |  | /
Spreadsheet: joe_parks__14807__bridgeline 6-19
Sheet: Sheet1

b/s | contract | price | volume | time | cm | account | cti | order # | trader | reference | trade #
B | NGN2 | 3303 | 39 | 16:41:36 | 905 | 97563 | 4C | 1741 | ebc | EO-1741 | 471 | AT | Y
B | NGN2 | 3284 | 20 | 07:17:04 | 905 | 97563 | 4C | 2582 | amk | EO-2582 | 2059 | 0 | N
B | NGN2 | 3285 | 1 | 17:05:31 | 905 | 97563 | 4C | 2169 | ebc | EO-2169 | 707 | 0 | Y
B | NGN2 | 3285 | 5 | 17:05:39 | 905 | 97563 | 4C | 2169 | ebc | EO-2169 | 709 | 0 | Y
B | NGN2 | 3285 | 5 | 17:05:41 | 905 | 97563 | 4C | 2169 | ebc | EO-2169 | 710 | 0 | Y
B | NGN2 | 3285 | 4 | 17:05:45 | 905 | 97563 | 4C | 2169 | ebc | EO-2169 | 711 | 0 | Y
B | NGN2 | 3285 | 13 | 17:06:51 | 905 | 97563 | 4C | 2265 | ebc | EO-2265 | 715 | 0 | Y
B | NGN2 | 3285 | 2 | 17:07:01 | 905 | 97563 | 4C | 2265 | ebc | EO-2265 | 729 | 0 | Y
B | NGN2 | 3285 | 15 | 07:53:58 | 905 | 97563 | 4C | 4562 | [NAME] | EO-4562 | 2159 | 0 | N
B | NGN2 | 3290 | 5 | 17:15:54 | 905 | 97563 | 4C | 2367 | ebc | EO-2367 | 775 | 0 | Y
B | NGN2 | 3290 | 3 | 17:15:54 | 905 | 97563 | 4C | 2367 | ebc | EO-2367 | 776 | 0 | Y
B | NGN2 | 3298 | 1 | 08:08:41 | 905 | 97563 | 4C | 4623 | amk | EO-4623 | 2224 | 0 | N
B | NGN2 | 3298 | 7 | 08:08:41 | 905 | 97563 | 4C | 4623 | amk | EO-4623 | 2225 | 0 | N
B | NGN2 | 3299 | 15 | 08:08:57 | 905 | 97563 | 4C | 4624 | amk | EO-4624 | 2226 | 0 | N
Spreadsheet: 546453d1510060724-divide-a-value-over-several-cells-zeszyt2
Sheet: Orders

Week |  |  | Projected  Sales | Projected Sales (Cumulative) | % of Total | Actual  Sales | Actual Sales (Cumulative) | % of Total | % Deficit (Daily) | % Deficit (Cumulative)
Week 38 |  |  |  |  |  | 23
Week 39 |  |  |  |  |  | 120
Week 40 |  |  |  |  |  | 112
Week 41
Week 42
Week 43
Week 44
Week 45
Week 46
Week 47
Week 48
Week 49
Week 50
Week 51
Week 52
Week 1
Week 2
Week 3
Week 4
Week 5
Week 6
Week 7
Week 8
Week 9
Week 10
Week 11
Week 12
Week 13
Week 14
Week 15
Week 16
Week 17
Week 18
Week 19
Week 20
Week 21
Week 22
Week 23
Week 24
Week 25
Week 26
Week 27
Week 28
Week 29
Week 30
Week 31
Week 32
Week 33
Week 34
Week 35
Week 36
Week 37
Totals
parameters of distribution
mean | 26 |  | std dev
Total yearly sales projected
 | 67000
Spreadsheet: 90a98a12-16ae-4edf-a429-f9d29e92b69e
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42203039 | 2014-07-07 19:51:08 | AXIS | 1 | 6 | 4 | 222901 | [NAME] | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42203408 | 2014-07-07 20:28:14 | ALLIES | 0 | 5 | 6 | 222901 | [NAME] | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
Spreadsheet: 124589d1318486942-count-group-of-number-in-column-countgroup
Sheet: Sheet1

2 |  |  |  |  | I would like to count how many time group of criteria appear?
2
2 |  |  |  |  | Criteria: | 3
3 |  |  |  |  | Result: | 5
3
2 |  |  |  |  | Which formula to use in G5?
2
2 |  |  |  |  | We have 3 group of number 3, in which there are maximum 6 number 3. How to count?
2 |  |  |  |  | Maximum: | 6
2
1
1
1
3
3
3
3
3
3
1
1
3
3
2
2
1
3
1
1
1
1
1
3
3
3
3
Spreadsheet: 77055d1277487046-retrieving-dates-example
Sheet: Sheet1

Name | Date | Previous Date
[NAME] | 2010-06-10 00:00:00 | NA
[NAME] | 2010-06-15 00:00:00 | NA
[NAME] | 2010-06-18 00:00:00 | NA
[NAME] | 2010-06-25 00:00:00 | NA
[NAME] | 2010-06-25 00:00:00 | 2010-06-15 00:00:00
[NAME] | 2010-06-25 00:00:00 | 2010-06-10 00:00:00
[NAME] | 2010-06-25 00:00:00 | 2010-06-15 00:00:00
[NAME] | 2010-06-25 00:00:00 | 2010-06-18 00:00:00
Spreadsheet: 71171d1271873232-need-to-build-a-sliding-scale-formula-sliding-scale
Sheet: Sheet1

 | $0-$10M | $10M-$20M | $20M-$40M | $40M-$60M | >$60M
0-3 | 0.175 | 0.185 | 0.2 | 0.2 | 0.2
3-5 | 0.175 | 0.19 | 0.21 | 0.22 | 0.23
>5 | 0.175 | 0.195 | 0.22 | 0.23 | 0.24
Spreadsheet: 771853d1646880091-flagging-a-cell-based-on-a-flagged-cell-mod
Sheet: Sheet1

 | INPUTS: | Row 6 first flag | Row 6 following flags | Row 7 flag that follows row 6
 |  | 1 | 2 | 1
 | 1
FILTER YEAR?
2ND FILTER YEAR?
2ND FILTER YEAR? | No | FLAG | No | FLAG | No | FLAG
Spreadsheet: 558178d1516958878-keeping-certain-rows-max-if
Sheet: Desired Result

Student | Program | End Date | [NAME]
38723.78738117187 | ENGL | 2017-04-28 00:00:00
57259.36172788506 | ENGL | 2018-04-27 00:00:00
21639.51088136631 | ENGL | 2018-04-13 00:00:00
29445.18754844943 | ENGL | 2018-04-27 00:00:00
59025.70526420221 | ENGL | 2017-12-22 00:00:00
23709.4832420479 | ENGL | 2017-04-28 00:00:00
48612.38862284134 | ENGL | 2017-12-22 00:00:00
70960.040603415 | ENGL | 2017-12-22 00:00:00
58342.21411323348 | ENGL | 2018-04-13 00:00:00