tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kate_symes__19036__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-04-05 00:00:00 |  | 210.49 | 40272 | 95.67 | 12736
 | 2001-04-04 00:00:00 |  | 235.75 | 35568 | 96.01 | 11864 | 134.48 | 2153 | 65.34 | 1391
 | 2001-04-03 00:00:00 |  | 232.48 | 34768 | 101.7 | 8424 | 124.35 | 2275 | 80.72 | 166
 | 2001-04-02 00:00:00 |  | 234.1 | 20032 | 134.92 | 8456 | 151.72 | 5836 | 152.21 | 1055
 | 2001-04-01 00:00:00 |  | 150 | 800 | 130 | 0 | 169.97 | 4993 | 179.55 | 3133 |  | 136.89 | 20112
 | 2001-03-31 00:00:00 |  | 155.24 | 26800 | 79.32 | 5000 | 203.27 | 4434 | 161.69 | 2164
 | 2001-03-30 00:00:00 |  | 155.24 | 26800 | 78.68 | 5600 | 166.55 | 6883 | 125.76 | 3604
 | 2001-03-29 00:00:00 |  | 149.29 | 27472 | 74.97 | 7680 | 151.01 | 3119 | 106.73 | 2737
 | 2001-03-28 00:00:00 |  | 117.91 | 28384 | 64.05 | 8795 | 135.59 | 5365 | 79.21 | 2138
 | 2001-03-27 00:00:00 |  | 107.14 | 26352 | 54.09 | 6800 | 138.05 | 5768 | 73.14 | 3889
 | 2001-03-26 00:00:00 |  | 280.53 | 20768 | 160.99 | 5520 | 115.17 | 3547 | 66.57 | 2059
 | 2001-03-25 00:00:00 |  | 200 | 0 | 135 | 200 | 80.99 | 1643 | 75.59 | 545 |  | 162.46 | 16560
 | 2001-03-24 00:00:00 |  | 233.04 | 14608 | 130.51 | 4880 | 130 | 6097 | 179.92 | 3350
 | 2001-03-23 00:00:00 |  | 233.24 | 14448 | 130.51 | 4880 | 324.97 | 6129 | 242.2 | 3200
 | 2001-03-22 00:00:00 |  | 281.29 | 18448 | 160.38 | 5360 | 385.71 | 8040 | 282.16 | 2915
 | 2001-03-21 00:00:00 |  | 460.02 | 24848 | 198.73 | 8120 | 350.98 | 4786 | 253.67 | 1853
 | 2001-03-20 00:00:00 |  | 377.03 | 18384 | 176.12 | 5120 | 390.83 | 2452 | 357.57 | 1668
 | 2001-03-19 00:00:00 |  | 297.33 | 24848 | 176.6 | 9000 | 258.33 | 3388 | 199.67 | 2448
 | 2001-03-18 00:00:00 |  | 220 | 0 | 185 | 0 | 170.47 | 4949 | 156.95 | 2582 |  | 178.66 | 28200
 | 2001-03-17 00:00:00 |  | 195.41 | 17152 | 121.88 | 8832 | 191.77 | 10872 | 180.55 | 1883
 | 2001-03-16 00:00:00 |  | 195.98 | 16352 | 121.88 | 8832 | 219.02 | 5921 | 173.76 | 3142
 | 2001-03-15 00:00:00 |  | 180.19 | 17472 | 98.04 | 5160 | 188.69 | 6005 | 136.45 | 3320
 | 2001-03-14 00:00:00 |  | 162.56 | 17184 | 81.84 | 6960 | 194.59 | 4065 | 117.41 | 1400
 | 2001-03-13 00:00:00 |  | 157.46 | 17840 | 69.39 | 7288 | 171.29 | 4137 | 134.75 | 1330
 | 2001-03-12 00:00:00 |  | 166.55 | 12544 | 91.58 | 6920 | 186.95 | 2928 | 114.77 | 1215
 | 2001-03-11 00:00:00 |  | 163 | 3200 | 90 | 1600 | 104.25 | 1435 | 110.05 | 945 |  | 93.34 | 17760
 | 2001-03-10 00:00:00 |  | 148.73 | 18400 | 66.56 | 5864 | 109.79 | 3007 | 124.99 | 2735
 | 2001-03-09 00:00:00 |  | 148.73 | 18400 | 66.56 | 5864 | 175.73 | 6415 | 122.41 | 1756
 | 2001-03-08 00:00:00 |  | 185.11 | 22848 | 92.66 | 8640 | 191.53 | 4219 | 145.14 | 1004
 | 2001-03-07 00:00:00 |  | 300.27 | 25616 | 169.6 | 6824 | 225.26 | 4337 | 151.01 | 1201
 | 2001-03-06 00:00:00 |  | 309.17 | 20320 | 175.44 | 6728 | 215.32 | 7762 | 192.69 | 3047
Spreadsheet: 854928d1704691923-extract-total-of-a-column-from-specified-period-data
Sheet: Pivot Table

[NAME] | Sum of Number |  |  |  | [NAME] | Count of Coluna2
Rental Income | 900716 |  |  |  | Rental Income | 94
Equity | 484005 |  |  |  | Capital Mall | 30
Selfi | 198000 |  |  |  | Global GF | 16
Capital Mall | 194223 |  |  |  | Major | 14
Interest Received | 188050 |  |  |  | Global 3 | 13
Global GF | 176000 |  |  |  | Selfi | 12
Major | 96864 |  |  |  | Global 2 | 11
Global1 | 78408 |  |  |  | Global1 | 10
Global 3 | 76900 |  |  |  | Thanal | 8
Global 2 | 59400 |  |  |  | Cash In Hand | 5
Thanal | 14400 |  |  |  | Equity | 3
[NAME] | 8000 |  |  |  | Interest Received | 3
Cash In Hand | 7757 |  |  |  | [NAME] | 1
Maintenanace | 6000 |  |  |  | Maintenanace | 1
Tax | 4248 |  |  |  | Tax | 1
Total Geral | 2492971 |  |  |  | Total Geral | 222
Spreadsheet: 731839d1620638172-count-in-a-range-along-a-row-instances-that-occur-only-on-before-today-of-a-value-anonymised-blue-green-mauve-red
Sheet: RED

RED ENTITIES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTALS PER ENTITY |  |  |  | 255153153
 |  |  | 2021-03-02 00:00:00 | 2021-03-09 00:00:00 | 2021-03-16 00:00:00 | 2021-03-23 00:00:00 | 2021-03-30 00:00:00 | 2021-04-06 00:00:00 | 2021-04-13 00:00:00 | 2021-04-20 00:00:00 | 2021-04-27 00:00:00 | 2021-05-04 00:00:00 | 2021-05-11 00:00:00 | 2021-05-18 00:00:00 | 2021-05-25 00:00:00 | @ | % | ! | _ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MEDIANS
 | Dorla | [NAME] | F | F | % | F | F | F | F | F | % | % | @ | @ | @ |  |  |  |  |  | 255,204,204
 | Le | Kiley | F | F | % | F | F | F | F | F | % | % | @ | @ | @ |  |  |  |  |  | @
 | [NAME] | [NAME] | @ | @ | @ | @ | @ | @ | @ | % | @ | @ | @ | @ | @ |  |  |  |  |  | %
 | [NAME] | Aundrea | @ | @ | @ | ! | @ | @ | @ | _ | @ | @ | @ | @ | @ |  |  |  |  |  | !
 | Ranee | [NAME] | % | @ | % | @ | % | % | ! | % | % | % | @ | @ | @ |  |  |  |  |  | F | FLOATING
 | Leonida | Kermit | @ | @ | _ | @ | _ | % | @ | ! | _ | _ | @ | @ | @ |  |  |  |  |  | _ | [NAME]
 | Nichelle | [NAME] | @ | @ | % | @ | @ | @ | @ | @ | % | % | @ | @ | @ |  |  |  |  |  | N/A
 | Adriane | Amelia | @ | @ | @ | _ | @ | _ | _ | _ | @ | @ | @ | @ | @ |  |  |  |  |  |  | follow up
 | Byron | Genevie | @ | @ | _ | @ | @ | _ | @ | _ | _ | _ | @ | @ | @
 | [NAME] | Loan | @ | @ | @ | @ | @ | @ | @ | @ | @ | @ | @ | @ | @
 | [NAME] | Lucie | % | % | % | % | % | % | % | % | % | % | @ | @ | @
 | [NAME] | [NAME] | @ | @ | @ | @ | @ | @ | ! | ! | @ | @ | @ | @ | @
 | Royce | [NAME] | @ | ! | @ | @ | @ | ! | ! | % | @ | @ | @ | @ | @
 | [NAME] | Edra | @ | @ | @ | @ | @ | @ | @ | @ | @ | @ | @ | @ | @ |  |  |  |  |  | 2021 red entities
 | Shaun | Corina | @ | ! | ! | @ | @ | @ | @ | ! | ! | ! | @ | @ | @ |  |  |  |  |  | 2020 red entities |  |  | 40
 | [NAME] | Nedra | @ | @ | @ | @ | ! | ! | @ | @ | @ | @ | @ | @ | @ |  |  |  |  |  | Increase/decrease
 | Sharell | Bianca | @ | ! | @ | @ | % | @ | @ | ! | @ | @ | @ | @ | @
 | [NAME] | May | @ | @ | @ | @ | @ | @ | @ | ! | @ | @ | @ | @ | @
 | [NAME] | [NAME] | _ | % | ! | ! | ! | ! | ! | ! | ! | ! | @ | @ | @
 | Ardath | [NAME] | @ | @ | @ | @ | @ | @ | @ | @ | @ | @ | @ | @ | @
 | [NAME] | Sharron | _ | _ | @ | @ | @ | % | @ | @ | @ | @ | @ | @ | @
 | Alena | Lucas | @ | ! | @ | @ | @ | ! | ! | ! | @ | @ | @ | @ | @
 | Maxima | Britta | @ | @ | @ | @ | @ | @ | @ | @ | @ | @ | @ | @ | @
 | [NAME] | Cyrstal | _ | _ | _ | _ | _ | _ | @ | ! | _ | _ | @ | @ | @
 | [NAME] | Duane | @ | @ | @ | @ | @ | @ | @ | @ | @ | @ | @ | @ | @
 | Sunday | [NAME] | @ | @ | @ | @ | @ | @ | @ | @ | @ | @ | @ | @ | @
 | Vania | Mac | @ | @ | @ | ! | @ | ! | @ | @ | @ | @ | @ | @ | @
_  s N/A
 | confirm
_  s N/A
 | confirm
Spreadsheet: sally_beck__33923__CashSchedule
Sheet: February

PG&E CASH SCHEDULE THROUGH FEBRUARY 28,2001
 |  | (US DOLLARS)
Counterparty | Enron Entity | Total Receivable | Total Payable | Net Amount | Native Currency |  | Due Date
PG&E Energy Trading - Gas Corp. | ENA | 10000000 | 10000000 | 10000000 |  |  | 2001-02-20 00:00:00
Pacific Gas & Electric Company | ENA | 1200 | 1000 |  |  |  | 2001-02-20 00:00:00
PG&E Core | ENA | 1500 | 1200 |  |  |  | 2001-02-20 00:00:00
PG&E Energy Tading, Canada | ENA | 1000 | 1200 |  |  |  | 2001-02-20 00:00:00
CEG Energy Options Inc. | ENA | 1500 | 1500 |  |  |  | 2001-02-20 00:00:00
Subtotal ENA Net Physical Gas
Pacific Gas & Electric Company | ENA | 1000 | 2000 |  |  |  | 2001-02-20 00:00:00
PG&E Gas Transmission Teco, Inc. | ENA | 1000 | 2000 |  |  |  | 2001-02-20 00:00:00
PG&E Texas Pipeline, L.P. | ENA | 1000 | 2000 |  |  |  | 2001-02-20 00:00:00
Subtotal ENA Transport
PG&E Energy Trading Power LP | ENA | 1000 | 100 |  |  |  | 2001-02-20 00:00:00
Subtotal ENA SWAPS
Subtotal ENA
PG&E Energy Trading -Gas Corp. | HPL | 2000 | 1000 |  |  |  | 2001-02-20 00:00:00
Subtotal HPL Transport
No scheduled payments |  | 0 | 0 | 0
Subtotal EPMI Physical Power | EPMI
No scheduled payments | EGLI | 0 | 0 | 0
No scheduled payments | ERAC | 0 | 0
No scheduled payments | ELFI | 0 | 0 | 0
No scheduled payments | ENA | 0 | 0
Subtotal EGM
PG&E Energy Tading - Gas Corp. | ECC | 1500 | 1000 |  | 300 | CDN$ | 2001-02-20 00:00:00
PG&E Energy Trading, Canada | ECC | 1000 | 1000 |  | 300 | CDN$ | 2001-02-20 00:00:00
Pacific Gas & Electric Company | ECC | 1500 | 1000 |  | 300 | CDN$ | 2001-02-20 00:00:00
Subtotal ECC Net Physical Gas
PG&E Energy Trading - Gas Corp. | EES | 100 | 1000 |  |  |  | 2001-02-20 00:00:00
Subtotal EES Physical Gas
No scheduled payments | EES | 0 | 0 | 0
Subtotal EES Physical Power
Subtotal EES
Nine Energy Service LLC (WIMBE)* | ENA | 0 | 0 | 0 |  |  | 2001-02-20 00:00:00
Grand Total Enron
* Not direct exposure; WIMBE buys from Enron, WIMBE sells to PG&E, and PG&E pays Enron
Spreadsheet: 732956d1621338366-calculate-recovery-time-mappe1
Sheet: MDD

Date | Price | Return | Running Return |  | [NAME]. Drawdown
2020-01-01 00:00:00 | 7193.7546679601 | - | - |  | Date of Low
2020-01-02 00:00:00 | 6963.853353983485 |  |  |  | Recovery Time | Here I want to get 27.01.2020
2020-01-03 00:00:00 | 7300.34693530511 |  |  |  |  | First date where the Price >= Price at Peak
2020-01-04 00:00:00 | 7351.377053166627
2020-01-05 00:00:00 | 7349.972248050628
2020-01-06 00:00:00 | 7734.675515785289
2020-01-07 00:00:00 | 8147.415237636371
2020-01-08 00:00:00 | 8045.789124592971
2020-01-09 00:00:00 | 7832.795643840387
2020-01-10 00:00:00 | 8180.513169803805
2020-01-11 00:00:00 | 8012.085781814529
2020-01-12 00:00:00 | 8171.401185320944
2020-01-13 00:00:00 | 8110.647964503772
2020-01-14 00:00:00 | 8801.871213137745
2020-01-15 00:00:00 | 8820.85010599613
2020-01-16 00:00:00 | 8720.91950137424
2020-01-17 00:00:00 | 8902.568995225329
2020-01-18 00:00:00 | 8906.90267515107 |  |  |  | Peak
2020-01-19 00:00:00 | 8690.380569544623
2020-01-20 00:00:00 | 8631.253954333763
2020-01-21 00:00:00 | 8724.818622931474 |  |  |  | Falling Period
2020-01-22 00:00:00 | 8665.436914096897
2020-01-23 00:00:00 | 8415.956027335538
2020-01-24 00:00:00 | 8432.096675789418
2020-01-25 00:00:00 | 8348.665665079325 |  |  |  | [NAME]. Drawdown
2020-01-26 00:00:00 | 8595.728298493115
2020-01-27 00:00:00 | 9000.90267515107 |  |  |  | Recovery Time because Price >= Peak
Spreadsheet: sally_beck__33933__HPL Summary of Cost Savings
Sheet: Summary

HPLC Cost Savings
2001 Budget
 |  | Headcount Change (1) |  |  |  | 2001 Budget Dollar Change
Group / Cost Center Name | Cost Center | From | To | Reduction |  | From | To | Savings
Logistics
Texas Logistics ([NAME]) | 105630 |  |  |  |  | 1056694 | 549813
Volume Management (Kelly) | 103822 |  | 0 |  |  | 1329576 | 570642
Regulatory Compliance (Eiben) | 103835 |  | 0 |  |  | 577332 | 237042
Texas Trading Support (Farmer) | 103832 |  | 1 |  |  | 304671 | 193726
Total Logistics
Risk Management
Texas Risk Management (Baumbach) | 103833 |  |  |  |  | 904622 | 701931
Total Risk Management
Settlements & Confirmations
Gas Assets Settlements (Ratnala) | 103830 |  |  |  |  | 1262239 | 646024
Transport and Rate Mgmt (Smith) | 106292 |  | 0 |  |  | 364604 | 152262
Global Facilities Texas Ops (Eiben) | 103842 | 1 | 0 |  |  | 77454 | 32763
Global Contracts Texas Ops (Eiben) | 103840 |  | 0 |  |  | 318538 | 135254
Total Settlements & Confirmations
Total Savings from HPL Sale
(1)  All headcount reductions are as of June 1.
Spreadsheet: 163376d1340287668-how-to-prevent-excel-from-copying-conditional-formatting-rules-ezell-usa-unit-1-and-1a
Sheet: MARCH 2012

<HOME> | Field:  [NAME]: G.A. Carter #1          Lease No:  9024368 |  |  |  |  |  |  |  |  |  | SALES
 |  | ttotal sales: |  |  |  |  |  | Avg. Prod: |  |  | ALL INFORMATION FOR THIS TABLE MUST BE ENTERED FROM TICKETS
[NAME] | Tank | 5664 | Tank | 5665 | 5664 | 5665 | Total | Downtime | Downtime Description |  | Tank | 5664 | Tank | 5665 | Plains | Ticket | BS&W | OBS | OBS | Durango | Corrected
2012 | Ft. | In. | Ft. | In. | Prod. | Prod. | (BPD) | Hours | or Comments |  | Ft. | In. | Ft. | In. | Bought | No. | % | Grav. | Temp. | Sold | Sales
Prev. Gauge: | 5 | 4.75 | 1 | 5 |  |  |  |  | spm 7.45 field gas 23 psi
1 | 5 | 7 | 1 | 5 |  |  |  |  | spm 7.50 field gas 23 psi
2 | 5 | 9 | 1 | 5 |  |  |  |  | spm 8.81 field gas 23 psi
3 | 5 | 9.25 | 1 | 5 |  |  |  |  | down, pre-igniting & overheating
4 | 5 | 9.75 | 1 | 5 |  |  |  |  | down
5 | 5 | 10 | 1 | 5 |  |  |  |  | down
6 | 5 | 10.25 | 1 | 5 |  |  |  |  | down
7 | 6 | 0.5 | 1 | 5 |  |  |  |  | down
8 | 6 | 0.5 | 1 | 5 |  |  |  |  | down
9 | 6 | 0.5 | 1 | 5.75 |  |  |  |  | spm 9.65
10 | 6 | 0.5 | 1 | 8
11 | 6 | 0.5 | 1 | 10.75
12 | 6 | 0.5 | 2 | 1.75 |  |  |  |  | spm 8.86 field gas 23 psi
13 | 6 | 0.5 | 2 | 3.75 |  |  |  |  | spm 8.80 field gas 21 psi
14 | 6 | 0.5 | 2 | 5.75 |  |  |  |  | spm 8.36 field gas 25 psi |  | 6 | 2.25
15 | 1 | 5.5 | 2 | 8.5 |  |  |  |  | spm 9.00  field gas 23 psi, sold 64 |  | 1 | 5.5 |  |  |  | 9260162 | 0.1 | 27.8 | 68
16 | 1 | 5.5 | 2 | 11 |  |  |  |  | spm 9.13 field gas 25 psi
17 | 1 | 5.5 | 3 | 1.5
18 | 1 | 5.5 | 3 | 3.75
19 | 1 | 5.5 | 3 | 6 |  |  |  |  | spm 9.01, field gas 22 psi
20 | 1 | 5.5 | 3 | 8 |  |  |  |  | spm 8.52, field gas 23 psi
21 | 1 | 5.5 | 3 | 10 |  |  |  |  | spm 8.31, field gas 23 psi
22 | 1 | 5.5 | 4 | 0.25 |  |  |  |  | spm 7.79, field gas 13 psi
23 | 1 | 5.5 | 4 | 2.75 |  |  |  |  | spm 8.18, field gas 17 psi
24 | 1 | 5.5 | 4 | 5.5
25 | 1 | 5.5 | 4 | 7.75
26 | 1 | 5.5 | 4 | 9.25 |  |  |  |  | spm 8.31, field gas 17 psi
27 | 1 | 5.5 | 4 | 11.75 |  |  |  |  | spm 8.88, field gas 18 psi
28 | 1 | 5.5 | 5 | 2.25 |  |  |  |  | spm 8.88, field gas 17 psi
29 | 1 | 5.5 | 5 | 4.25 |  |  |  |  | spm 8.91, field gas 18 psi
30 | 1 | 5.5 | 5 | 6.75 |  |  |  |  | spm 8.58, field gas 20 psi
31 | 1 | 5.5 | 5 | 9.25
1 | 1 | 5.5 | 5 | 11 |  |  |  |  | END OF MONTH TANK READING
 | Tank 59 |  | 33.11
 | Tank 60 |  | 33.11
 | Load ready |  | 6
Spreadsheet: 0c1e23e4-e871-41f6-ac5a-a4cd0c192e98
Sheet: ST2

Supplementary Table 2 ([NAME] et al.) Raw tag count Pearson sample-to-sample correlations of H3K4me3 ChIP-seq from NeuN+ prefrontal neurons
Sample | H1 | H2 | H3 | H4 | H5 | H6 | H7 | H8 | H9 | H10 | H11 | P1 | P2 | P3 | P4 | R1 | R2 | R3
H1 | 1 | 0.9697 | 0.9719 | 0.9698 | 0.9669 | 0.9672 | 0.9598 | 0.9583 | 0.9514 | 0.9449 | 0.942 | 0.9168 | 0.9323 | 0.8697 | 0.8866 | 0.8522 | 0.8534 | 0.8527
H2 | 0.9697 | 1 | 0.9668 | 0.9647 | 0.9614 | 0.9644 | 0.964 | 0.9639 | 0.9469 | 0.947 | 0.9481 | 0.9178 | 0.9278 | 0.87 | 0.8862 | 0.859 | 0.8626 | 0.8604
H3 | 0.9719 | 0.9668 | 1 | 0.9687 | 0.9715 | 0.9457 | 0.9411 | 0.9559 | 0.9396 | 0.9348 | 0.9233 | 0.9174 | 0.9294 | 0.8568 | 0.8654 | 0.8578 | 0.8696 | 0.8648
H4 | 0.9698 | 0.9647 | 0.9687 | 1 | 0.9845 | 0.9726 | 0.9681 | 0.9777 | 0.9563 | 0.9622 | 0.9404 | 0.9348 | 0.9402 | 0.8694 | 0.8807 | 0.8524 | 0.8648 | 0.8587
H5 | 0.9669 | 0.9614 | 0.9715 | 0.9845 | 1 | 0.9695 | 0.9591 | 0.9791 | 0.9555 | 0.959 | 0.9304 | 0.9312 | 0.9375 | 0.8653 | 0.8749 | 0.8547 | 0.8665 | 0.8629
H6 | 0.9672 | 0.9644 | 0.9457 | 0.9726 | 0.9695 | 1 | 0.98 | 0.9766 | 0.9641 | 0.97 | 0.9622 | 0.9296 | 0.9374 | 0.8832 | 0.901 | 0.8527 | 0.8523 | 0.8525
H7 | 0.9598 | 0.964 | 0.9411 | 0.9681 | 0.9591 | 0.98 | 1 | 0.9701 | 0.9655 | 0.9709 | 0.9648 | 0.933 | 0.9385 | 0.8815 | 0.9021 | 0.8454 | 0.8495 | 0.8438
H8 | 0.9583 | 0.9639 | 0.9559 | 0.9777 | 0.9791 | 0.9766 | 0.9701 | 1 | 0.963 | 0.9694 | 0.9486 | 0.9376 | 0.9397 | 0.8772 | 0.8914 | 0.8577 | 0.8651 | 0.8625
H9 | 0.9514 | 0.9469 | 0.9396 | 0.9563 | 0.9555 | 0.9641 | 0.9655 | 0.963 | 1 | 0.9826 | 0.9584 | 0.9355 | 0.9419 | 0.8836 | 0.9049 | 0.8514 | 0.855 | 0.8483
H10 | 0.9449 | 0.947 | 0.9348 | 0.9622 | 0.959 | 0.97 | 0.9709 | 0.9694 | 0.9826 | 1 | 0.9597 | 0.9416 | 0.9427 | 0.8843 | 0.9036 | 0.8518 | 0.8584 | 0.8514
H11 | 0.942 | 0.9481 | 0.9233 | 0.9404 | 0.9304 | 0.9622 | 0.9648 | 0.9486 | 0.9584 | 0.9597 | 1 | 0.9171 | 0.9288 | 0.8855 | 0.9065 | 0.8471 | 0.8447 | 0.8414
P1 | 0.9168 | 0.9178 | 0.9174 | 0.9348 | 0.9312 | 0.9296 | 0.933 | 0.9376 | 0.9355 | 0.9416 | 0.9171 | 1 | 0.9782 | 0.9459 | 0.955 | 0.856 | 0.8648 | 0.857
P2 | 0.9323 | 0.9278 | 0.9294 | 0.9402 | 0.9375 | 0.9374 | 0.9385 | 0.9397 | 0.9419 | 0.9427 | 0.9288 | 0.9782 | 1 | 0.9332 | 0.9516 | 0.8572 | 0.8628 | 0.8561
P3 | 0.8697 | 0.87 | 0.8568 | 0.8694 | 0.8653 | 0.8832 | 0.8815 | 0.8772 | 0.8836 | 0.8843 | 0.8855 | 0.9459 | 0.9332 | 1 | 0.9684 | 0.8133 | 0.8079 | 0.8101
P4 | 0.8866 | 0.8862 | 0.8654 | 0.8807 | 0.8749 | 0.901 | 0.9021 | 0.8914 | 0.9049 | 0.9036 | 0.9065 | 0.955 | 0.9516 | 0.9684 | 1 | 0.828 | 0.8184 | 0.8183
R1 | 0.8522 | 0.859 | 0.8578 | 0.8524 | 0.8547 | 0.8527 | 0.8454 | 0.8577 | 0.8514 | 0.8518 | 0.8471 | 0.856 | 0.8572 | 0.8133 | 0.828 | 1 | 0.9786 | 0.9795
R2 | 0.8534 | 0.8626 | 0.8696 | 0.8648 | 0.8665 | 0.8523 | 0.8495 | 0.8651 | 0.855 | 0.8584 | 0.8447 | 0.8648 | 0.8628 | 0.8079 | 0.8184 | 0.9786 | 1 | 0.9839
R3 | 0.8527 | 0.8604 | 0.8648 | 0.8587 | 0.8629 | 0.8525 | 0.8438 | 0.8625 | 0.8483 | 0.8514 | 0.8414 | 0.857 | 0.8561 | 0.8101 | 0.8183 | 0.9795 | 0.9839 | 1
Spreadsheet: 821550d1678791005-excel-formula-to-calculate-inflation-conversion-factor-conversion-factor
Sheet: Sheet1

 | Kindly asking for excel formula to calculate conversion factor - column E
 | Monrh | Indices | Inflation rate | Conversion factors
 | 2021-12-01 00:00:00 | 2474.51 | 4.22 | 1.61
 | 2022-01-01 00:00:00 | 2608.79 | 5.43 | 1.52
 | 2022-02-01 00:00:00 | 2698.89 | 3.45 | 1.47
 | 2022-03-01 00:00:00 | 2759.83 | 2.26 | 1.44
 | 2022-04-01 00:00:00 | 2803.57 | 1.58 | 1.42
 | 2022-05-01 00:00:00 | 2874.85 | 2.54 | 1.38
 | 2022-06-01 00:00:00 | 2986.44 | 3.88 | 1.33
 | 2022-07-01 00:00:00 | 3062.93 | 2.56 | 1.3
 | 2022-08-01 00:00:00 | 3191.19 | 4.19 | 1.25
 | 2022-09-01 00:00:00 | 3342.02 | 4.73 | 1.19
 | 2022-10-01 00:00:00 | 3555.9 | 6.4 | 1.12
 | 2022-11-01 00:00:00 | 3760.86 | 5.76 | 1.06
 | 2022-12-01 00:00:00 | 3977.46 | 5.76 | 1
Spreadsheet: 806094d1669106910-suming-dynamic-array-off-column-numbers-based-of-criteria-sum-for-dynamic-number-of-columns
Sheet: Sheet1

 | 2022-04-01 00:00:00
Month Days
Stock | 2439 | 4698 | 5085 | 9629 | 9561 | 5983 | 1935 | 6451 | 2050 | 2693 | 9668 | 2349
Average Days Holding | 58 | 52 | 58 | 100 | 31 | 26 | 40 | 36 | 21 | 78 | 6 | 127
Average Stock value |  |  |  |  |  |  |  |  |  |  |  |  |  | Automate this row so consistent formula in all columns
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Logic:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1) Sum stock columns that cover columns where the month days are equal to average holding days or 1 month greater if an array
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2) Multiply 1 * 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3) Divide average days for that month by sum of month days for the columns that are equal to average days or closest number of months days greater than average holding days
Spreadsheet: 120602d1315403554-converting-time-format-inserting-leading-zero-and-adding-3-hours-example-16-
Sheet: Sheet1

RAW DATA |  |  |  |  | How it should convert
time 1 | time 2 |  |  |  | time 1 | time 2
5:55AM | 3:09PM |  |  |  | 08:55:00 | 06:09:00
9:08AM | [NAME] |  |  |  | 11:08:00 | 21:16:00
12:57PM | 10:03PM |  |  |  | 15:57:00 | 01:03:00
7:09AM | 5:30PM |  |  |  | 10:09:00 | 20:30:00
[NAME] | 2:30PM |  |  |  | 10:23:00 | 17:30:00
7:27AM | 4:28PM |  |  |  | 10:27:00 | 19:28:00
8:06AM | 2:32PM |  |  |  | 11:06:00 | 05:32:00
 |  | CONVERTING RULES
 |  | am/pm to 24 hours
 |  | plus 3 hours
 |  | add leading zeros when time is 1 to 9
Spreadsheet: 722061d1615026431-truncating-an-array-in-a-countifs-truncating-an-array-in-a-countifs
Sheet: Sheet1

NUM | ALFA |  | 2 | q |  | [NAME] | 1
1.487 | w |  |  |  |  | [NAME] | w
1.83 | q |  |  |  |  | Count results
2.269 | w
1.715 | q
2.155 | w
2.313 | q
3.586 | w
1.82 | w
3.185 | w
3.849 | q
3.105 | w
3.392 | q
2.251 | w
3.543 | q
2.611 | w
2.493 | q
3.673 | w
Spreadsheet: 849718d1700132492-allocation-of-hours-between-dates-formula-issues-example-data
Sheet: Worksheet

Start | End | Wk Start | Wk End | Hrs required
2023-11-01 00:00:00 | 2023-12-01 00:00:00 |  |  | 25
2023-11-01 00:00:00 | 2023-12-01 00:00:00 |  |  | 25
2023-11-01 00:00:00 | 2023-12-01 00:00:00 |  |  | 25
Spreadsheet: 220677d1363224614-find-unique-names-and-count-their-status-example
Sheet: Sheet1

[NAME] | New | 1 |  | 4
[NAME]
[NAME] | New | 2 |  | Array formula
[NAME] | New | 3 |  | press ctrl+shift+enter not just enter
[NAME] | New
[NAME]
Greg
[NAME] | New | 4
[NAME]
[NAME]
[NAME]
Spreadsheet: 141955d1329536125-help-with-changing-format-into-time-and-averaging-book2
Sheet: Sheet1

Before 9am |  |  | Processed |  | In store
 | Number | Weight | DATE | TIME | DATE | TIME
 | 1 | 194 | 2011-10-13 00:00:00 | 5.23am | 2011-10-13 00:00:00 | 8.18am
 | 1 | 194 | 2011-10-13 00:00:00 | 5.18am | 2011-10-13 00:00:00 | 8.18am
 | 1 | 626.5 | 2011-10-13 00:00:00 | 5.19am | 2011-10-13 00:00:00 | 8.19am
 | 2 | 1602 | 2011-10-27 00:00:00 | 5.35am | 2011-10-27 00:00:00 | 8.59am
Before 11am
 | 2 | 7393 | 2011-10-25 00:00:00 | 5.34am | 2011-10-25 00:00:00 | 10.10am
 | 2 | 1090 | 2011-10-14 00:00:00 | 5.12am | 2011-10-14 00:00:00 | 10.50am
 | 2 | 7143 | 2011-10-18 00:00:00 | 5.25am | 2011-10-18 00:00:00 | 9.28am
 | 1 | 1692 | 2011-10-31 00:00:00 | 6.05am | 2011-10-31 00:00:00 | 9.39am
 | 1 | 1412 | 2011-10-21 00:00:00 | 5.20am | 2011-10-21 00:00:00 | 9.41am
Midday onwards
 | 2 | 1586.5 | 2011-10-31 00:00:00 | 6.01am | 2011-10-31 00:00:00 | 11.48am
 | 1 | 3716 | 2011-10-26 00:00:00 | 5.24am | 2011-10-26 00:00:00 | 1.46pm
 | 1 | 3716 | 2011-10-26 00:00:00 | 5.11am | 2011-10-26 00:00:00 | 1.46pm
 | 2 | 7230 | 2011-10-26 00:00:00 | 5.11am | 2011-10-26 00:00:00 | 1.46pm
 | 2 | 2384.7 | 2011-10-17 00:00:00 | 9.26am | 2011-10-17 00:00:00 | 2.02pm
 | 50 | 914 | 2011-10-17 00:00:00 | 5.51am | 2011-10-17 00:00:00 | 2.08pm
 | 50 | 914 | 2011-10-17 00:00:00 | 9.45am | 2011-10-17 00:00:00 | 2.08pm
 | 1 | 1778 | 2011-10-17 00:00:00 | 5.52am | 2011-10-17 00:00:00 | 2.09pm
 | 165 | 3465 | 2011-10-19 00:00:00 | 5.35am | 2011-10-19 00:00:00 | 2.58pm
Overnight
 | 1 | 3918 | 2011-10-25 00:00:00 | 5.32am | 2011-10-26 00:00:00 | 1.46pm
 | 1 | 582 | 2011-10-19 00:00:00 | 5.34am | 2011-10-20 00:00:00 | 10.00am
 | 3 | 3638.5 | 2011-10-29 00:00:00 | 6.59am | 2011-10-31 00:00:00 | 8.17am
 | 1 | 1798 | 2011-10-24 00:00:00 | 5.12am | 2011-10-25 00:00:00 | 8.48am
 | 1 | 2071 | 2011-10-24 00:00:00 | 5.03am | 2011-10-25 00:00:00 | 8.52am
 | 1 | 3700 | 2011-10-15 00:00:00 | 7.10am | 2011-10-17 00:00:00 | 9.02am
 | 2 | 5550 | 2011-10-14 00:00:00 | 5.14am | 2011-10-17 00:00:00 | 9.02am
Spreadsheet: 49135d1248384783-copy-row-from-multiple-worksheets-based-on-column-value-in-to-summary-tab-sales-unpaid-solver
Sheet: Debtors

Date | Company | Details | Invoice No. | Net Amount | VAT | Total | Paper Reference | Date Invoice Sent | Date Papment Received
2009-01-01 00:00:00 | KPMG | Accounting Work | 2 | 50 | 10.75 | 60.75 | J2 | A | Unpaid
2009-01-01 00:00:00 | KPMG | Accounting Work | 4 | 50 | 10.75 | 60.75 | J2 | B | Unpaid
2009-01-01 00:00:00 | Xpike | [NAME] | 7 | 100 | 21.5 | 121.5 | J2 | C | Unpaid
2009-01-01 00:00:00 | KPMG | Accounting Work | 9 | 50 | 10.75 | 60.75 | J2 | D | Unpaid
2009-01-01 00:00:00 | SOI | Accounting Work | 11 | 50 | 10.75 | 60.75 | J2 | E | Unpaid
2009-01-01 00:00:00 | KPMG | Accounting Work | 24 | 50 | 10.75 | 60.75 | J2 | F | Unpaid
2009-01-01 00:00:00 | KPMG | Accounting Work | 26 | 50 | 10.75 | 60.75 | J2 | G | Unpaid
2009-01-01 00:00:00 | pike | Accounting Work | 44 | 50 | 10.75 | 60.75 | J2 | A | Unpaid
2009-01-01 00:00:00 | fred | Accounting Work | 66 | 50 | 10.75 | 60.75 | J2 | B | Unpaid
Spreadsheet: 838789d1691410867-calculate-price-based-on-date-committed-with-customer-assign
Sheet: DataEntry

Date | CustomerName | Litre | Price | Due Amount | Received Amount | Remining Balance
2023-08-03 00:00:00 | abc | 2
2023-08-04 00:00:00 | abc | 2
2023-08-05 00:00:00 | abc | 2
2023-08-06 00:00:00 | abc | 2
2023-08-07 00:00:00 | abc | 2
2023-08-08 00:00:00 | abc | 2
2023-08-09 00:00:00 | abc | 2
2023-08-10 00:00:00 | abc | 2
2023-08-11 00:00:00 | abc | 2
2023-08-12 00:00:00 | abc | 2
2023-08-13 00:00:00 | abc | 2
2023-08-14 00:00:00 | abc | 2
2023-08-15 00:00:00 | abc | 2
2023-08-16 00:00:00 | abc | 2
2023-08-17 00:00:00 | abc | 2
2023-08-18 00:00:00 | abc | 2
2023-08-19 00:00:00 | abc | 2