tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 216800d1361892391-filter-through-multiple-tabs-to-show-in-new-tab-wawf-gfebs-invoices-fy13-plan-b
Sheet: W912LP-09-P-0055

CONTRACT # | PO # | CAGE CODE | PAYMENT NUMBER | LINE ITEM # | LINE ITEM QUANTITY | WAWF INV # | DATE INV SUBMITTED | DATE INV RECEIVED | DOC DATE | AMOUNT | OUR STATUS | GFEBS # | 103 | 103 DATE | 105 | 105 DATE | DOV  # (Disbursing #) | DOV DATE | INTEREST  ? | TRACE #
W912LP-09-P-0055 |  |  | 1P
W912LP-09-P-0055 |  |  |  |  |  |  |  |  | TOTAL
RETURN
Spreadsheet: 664847d1582805713-cost-based-on-day-of-week-cost-based-on-day-of-week
Sheet: Sheet1

Date | DoW | PH? | Apples | Oranges | Lemons | Cost
2020-07-01 00:00:00 |  | NO | 1
2020-07-02 00:00:00 |  | NO | 1
2020-07-03 00:00:00 |  | YES | 1
2020-07-04 00:00:00 |  | NO | 1
2020-07-05 00:00:00 |  | NO | 1
2020-07-06 00:00:00 |  | NO
Spreadsheet: kate_symes__18514__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-01-26 00:00:00 |  | 225.83 | 13200 | 141.75 | 2800
 | 2001-01-25 00:00:00 |  | 231.78 | 13440 | 144.28 | 3040 | 153.9 | 2315 | 108.66 | 1079
 | 2001-01-24 00:00:00 |  | 222.84 | 13360 | 131.11 | 2880 | 136.45 | 2624 | 93.82 | 933
 | 2001-01-23 00:00:00 |  | 254.26 | 9200 | 143.99 | 4256 | 148.73 | 2079 | 105.08 | 1209
 | 2001-01-22 00:00:00 |  | 324.8 | 9200 | 164 | 2000 | 172.56 | 2925 | 139.79 | 2097
 | 2001-01-21 00:00:00 |  | 177.5 | 2400 | 124.55 | 2200 | 152.69 | 3900 | 141.53 | 2132 |  | 168.33 | 1800
 | 2001-01-20 00:00:00 |  | 452.36 | 4400 | 226.5 | 2000 | 232.31 | 2573 | 148.33 | 1359
 | 2001-01-19 00:00:00 |  | 452.36 | 4400 | 226.5 | 2000 | 273.28 | 6682 | 128.74 | 2093
 | 2001-01-18 00:00:00 |  | 379.51 | 8960 | 214.86 | 2800 | 279.1 | 6115 | 157.96 | 2108
 | 2001-01-17 00:00:00 |  | 220.81 | 12080 | 122 | 3800 | 232.88 | 4018 | 186.65 | 824
 | 2001-01-16 00:00:00 |  | 173.04 | 18112 | 105.14 | 4120 | 231.33 | 632 | 127.03 | 579
 | 2001-01-15 00:00:00 |  | 173.04 | 18112 | 104.82 | 3960 | 169.46 | 718 | 107.24 | 593
 | 2001-01-14 00:00:00 |  | 152.5 | 0 | 103 | 0 | 130.52 | 713 | 116.11 | 446 |  | 107.23 | 13560
 | 2001-01-13 00:00:00 |  | 152.77 | 14160 | 107.23 | 4520 | 138.98 | 1547 | 120.82 | 1165
 | 2001-01-12 00:00:00 |  | 159.03 | 18032 | 90.92 | 3800 | 160.71 | 727 | 98 | 450
 | 2001-01-11 00:00:00 |  | 160.31 | 19472 | 90.92 | 3800 | 153.64 | 1669 | 94.86 | 1106
 | 2001-01-10 00:00:00 |  | 143.16 | 18208 | 84.37 | 3352 | 129.46 | 2981 | 93.14 | 1118
 | 2001-01-09 00:00:00 |  | 132.19 | 14400 | 75.61 | 4552 | 145.14 | 850 | 87.82 | 1753
 | 2001-01-08 00:00:00 |  | 127.4 | 15728 | 68.15 | 5768 | 140.11 | 1652 | 87.68 | 460
 | 2001-01-07 00:00:00 |  | 121.67 | 2400 | 65 | 800 | 84.12 | 1047 | 58.43 | 682 |  | 69.34 | 16944
 | 2001-01-06 00:00:00 |  | 121.11 | 22672 | 71.97 | 5784 | 90.26 | 442 | 59.63 | 622
 | 2001-01-05 00:00:00 |  | 121.35 | 23072 | 72.24 | 5984 | 105.21 | 932 | 98.02 | 734
 | 2001-01-04 00:00:00 |  | 131.61 | 14064 | 79.75 | 6272 | 120.52 | 512 | 71.21 | 514
 | 2001-01-03 00:00:00 |  | 143.06 | 13168 | 85.45 | 3584 | 129.29 | 613 | 75.14 | 791
 | 2001-01-02 00:00:00 |  | 149.82 | 10992 | 93.38 | 2840 | 124.91 | 1327 | 56.75 | 526
 | 2001-01-01 00:00:00 |  | 145 | 0 | 100 | 0 | 70.68 | 2284 | 50.55 | 1025 |  | 93.52 | 7320
 | 2000-12-31 00:00:00 |  | 94.03 | 2480 | 88.53 | 680 | 55.11 | 1961 | 56.69 | 816 |  | 89.07 | 1992
 | 2000-12-30 00:00:00 |  | 121.88 | 6160 | 88.79 | 1344 | 90.2 | 1203 | 69.44 | 897
 | 2000-12-29 00:00:00 |  | 169.36 | 5600 | 86.08 | 1088 | 146.94 | 2282 | 91.56 | 880
 | 2000-12-28 00:00:00 |  | 169.36 | 5600 | 86.08 | 1088 | 138.35 | 2041 | 123.17 | 293
 | 2000-12-27 00:00:00 |  | 232 | 10048 | 123.85 | 728 | 128.78 | 2370 | 96.27 | 690
Spreadsheet: e1b5fca7-1470-47c5-aaff-104fb82e0a38
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-04-25 09:23:59.580000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.625 | 102.514 | 102.389 | 102.264 | 101.889
4.5 | 101.588 | 101.463 | 101.338 | 100.963 |  | Note: | Refer To Price [NAME]
4.375 | 100.868 | 100.743 | 100.618 | 100.243 |  |  | For all Price Adjs
4.25 | 100.28 | 100.155 | 100.03 | 99.405
4.125 | 99.419 | 99.294 | 99.169 | 98.544
4 | 98.398 | 98.273 | 98.148 | 97.523
3.875 | 97.327 | 97.202 | 97.077 | 96.452
3.75 | 96.452 | 96.327 | 96.202 | 95.577
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 102.572 | 102.447 | 102.322 | 101.947
3.75 | 102.107 | 101.982 | 101.857 | 101.482
3.625 | 101.708 | 101.583 | 101.458 | 101.083
3.5 | 101.151 | 101.026 | 100.901 | 100.526
3.375 | 100.425 | 100.3 | 100.175 | 99.55
3.25 | 99.673 | 99.548 | 99.423 | 98.798
3.125 | 99.133 | 99.008 | 98.883 | 98.258 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-05-09 09:23:59.580000
30 DAY | 2014-05-24 09:23:59.580000
45 DAY | 2014-06-08 09:23:59.580000
60 DAY | 2014-06-23 09:23:59.580000
90 DAY | 2014-07-23 09:23:59.580000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 148138d1333148175-help-with-overage-calculation-weekly-expense-report-ap-weekly-expenses-1-
Sheet: Data

Edmund Grant Pharmaceutical Company
Expense Summary Report
May 1 - 7, 2011
 |  |  |  |  | Position | Actual Mileage
 |  |  |  |  | MN | >700
 |  |  |  |  | SU | >600
 |  |  |  |  | S2 | >550
 |  |  |  |  | S1 | >500
Last Name | First Name | Division | Position | Beginning Mileage | Ending Mileage | Actual Mileage | Meals | Gas | Hotel | Miscellaneous | Airfare | Total Expenses | Overage | Overage Charge
[NAME] | Alfredo | 5 | MN | 25987 | 26480 |  | 159.78 |  | 0 | 5.98 | 0
Aikers | [NAME] | 4 | MN | 19089 | 19480 |  | 149 |  | 0 | 0 | 0
Barnes | Art | 3 | S1 | 4598 | 5590 |  | 154.98 |  | 0 | 45.69 | 0
[NAME] | Renae | 2 | S1 | 48035 | 48886 |  | 47.89 |  | 0 | 450.88 | 0
Brown S | [NAME] | 1 | S1 | 54021 | 54780 |  | 101.58 |  | 0 | 25.05 | 0
Brown C | Clyde | 1 | MN | 62087 | 62678 |  | 145.36 |  | 119.25 | 65.48 | 450.25
Caldwell | Chad | 5 | S1 | 39878 | 40800 |  | 258.78 |  | 302.98 | 54.69 | 0
Chidester | Stuart | 2 | S2 | 78369 | 79000 |  | 158.36 |  | 450.98 | 1520.32 | 259.89
Cruce | [NAME] | 5 | S2 | 58010 | 58450 |  | 160.8 |  | 0 | 0 | 0
Dancer | [NAME] | 2 | S2 | 47056 | 48014 |  | 133.6 |  | 0 | 0 | 0
[NAME] | Gwen | 4 | S2 | 11078 | 11450 |  | 125 |  | 0 | 0 | 0
Friot | Teresa | 5 | S1 | 70000 | 71089 |  | 159 |  | 199.99 | 45.69 | 129.98
Gatchell | Erma | 4 | S1 | 0 | 0 |  | 0 |  | 0 | 0 | 0
[NAME] | Todd | 3 | S1 | 12580 | 12580 |  | 56.12 |  | 0 | 0 | 0
Hanks | [NAME] | 1 | SU | 52999 | 54230 |  | 123.7 |  | 359.75 | 159.87 | 508.72
Henderson | [NAME] | 2 | S1 | 0 | 0 |  | 0 |  | 0 | 0 | 0
Henricks | [NAME] | 3 | SU | 34082 | 35256 |  | 235 |  | 210.52 | 0 | 0
Hopkins | [NAME] | 4 | S1 | 74098 | 75098 |  | 789.95 |  | 0 | 1500.48 | 0
[NAME] | [NAME] | 3 | S2 | 5102 | 6020 |  | 157.4 |  | 0 | 0 | 0
Kinyon | [NAME] | 4 | SU | 52890 | 53479 |  | 145.25 |  | 99.99 | 26.48 | 99.99
Knauf | [NAME] | 2 | S2 | 58789 | 59897 |  | 56.36 |  | 258.32 | 69.23 | 0
[NAME] | Cathy | 4 | S1 | 6980 | 7200 |  | 45.87 |  | 0 | 0 | 0
Leminsky | Marsha | 1 | S1 | 52082 | 52608 |  | 147.25 |  | 0 | 0 | 0
Marvin | [NAME] | 4 | S2 | 27900 | 28504 |  | 99.01 |  | 369.85 | 0 | 236.05
Murphy | Agnes | 1 | S1 | 17089 | 18478 |  | 125 |  | 75 | 25 | 250
Nussbaum | Oleg | 3 | S2 | 58015 | 59500 |  | 65.7 |  | 0 | 0 | 0
[NAME] | [NAME] | 2 | MN | 59052 | 61000 |  | 64.75 |  | 250.74 | 0 | 801.99
Pixley | [NAME] | 3 | S1 | 59802 | 60856 |  | 189.98 |  | 250.98 | 56.99 | 125.98
Pizana | [NAME] | 5 | S2 | 10 | 569 |  | 32.98 |  | 0 | 0 | 0
Repetto | Eduardo | 5 | S2 | 35011 | 35600 |  | 74.6 |  | 650.23 | 0 | 102.48
Ruokangas | [NAME] | 1 | MN | 101 | 372 |  | 376.89 | 0 | 478.78 | 2987.42 | 894.87
Saghafi | [NAME] | 3 | S1 | 904 | 1150 |  | 102.78 | 0 | 0 | 0 | 0
Spomer | Lashanta | 2 | SU | 12056 | 12500 |  | 29.75 |  | 0 | 0 | 0
Vorse | [NAME] | 3 | MN | 25002 | 25305 |  | 139.75 |  | 0 | 0 | 99.99
Vrska | [NAME] | 5 | S2 | 18302 | 18975 |  | 84.35 |  | 69.99 | 256.02 | 0
Zorio | Sherol | 1 | S2 | 32058 | 32540 |  | 67.23 |  | 150.48 | 0 | 250.12
Zumwalt | Clint | 1 | S1 | 49014 | 50048 |  | 125 |  | 0 | 0 | 0
Spreadsheet: 744283d1629126930-how-to-auto-populate-from-a-list-in-alphabetical-order-moveuniquevalues
Sheet: Sheet7

Result |  | Cl Seen | # of Self Pay
Spreadsheet: 735022d1622647234-merging-multiple-sheets-with-same-header-format-into-single-sheet-aggrigated-code-sheet
Sheet: FATE

Discipline | FATE
Disciplinecode | Discipline - Region - gemeente - gebruiker
402060 | FATE - Groningen - Regionaal - Command Genees Fate
402066 | FATE - Groningen - Regionaal - Command Genees Fate
402067 | FATE - Groningen - Regionaal - Command Genees Fate
602060 | FATE - Drenthe - Regionaal - Command Genees Fate
602066 | FATE - Drenthe - Regionaal - Command Genees Fate
602067 | FATE - Drenthe - Regionaal - Command Genees Fate
1102010 | FATE - Noord-Holland - Regionaal - Command Genees Fate
1102011 | FATE - Noord-Holland - Regionaal - Command Genees Fate
1102017 | FATE - Noord-Holland - Regionaal - Command Genees Fate
1302060 | FATE - Amsterdam - Regionaal - Command Genees Fate
1302066 | FATE - Amsterdam - Regionaal - Command Genees Fate
1302067 | FATE - Amsterdam - Regionaal - Command Genees Fate
Spreadsheet: 262425d1378143541-choosing-one-of-the-duplicate-customer-info-mktgagentreport_9-2
Sheet: MktgReport

Date From | 2013-01-01 00:00:00 |  | Enter 10th date to exclude previous month cancels |  |  |  |  | 2013-07-10 00:00:00
Date To | 2013-08-30 00:00:00
PROGRAM | ALL
Agent | Office | Team | Pen Vol | [NAME] | Net Vol | CXL Vol | Total
ALBINO, LIZETTE
ALVARADO, DOLORES
BALOGH, ILDIKO
BLUE, LASHENA
FERNANDEZ, JESSICA
TABER, KRISTA
VASQUEZ, BENJAMIN
[NAME], KATHERINE
REYNOLDS, BRENDA
SYLVESTER, RUPERT
CIFUENTES, XOCHITLY
RIVERA, LAURA
CONTRERAS, [NAME]
[NAME], RUDY
CORTEZ, VIOLETTA
GRAHAM, [NAME]
OPENDO, [NAME]
DEASON, SHAWNA
TELLEZ, MARIA
TATE, BRENDA
DUNN, DESHUN
GUSTIN, DEBORAH
RODRIGUEZ, REBECCA
GONZALEZ, RUBEN
SANDOVAL, CHRISTINA
GRANILLO, [NAME]
MEJIA, PEGGY
GARRETT, [NAME]
CARRILLO, [NAME]
HERNANDEZ, ALICIA
HOLBRON, [NAME]
QUIROGA, KRISTINE
INTHASOROTH, CHANTHALY
JANETSKI, [NAME]
JAUREGUI, JULIE
JENKINS, LORNA
SHETTERLY, ADELE
KHAT, CHRISTINA
STURGEON, CAROL
CODE, [NAME]
MALLORY, LA VERN
LIPSHIN, [NAME]
POPKIN, BRIDGET
REEDER, JENNIFER
SUTTON, BELINDA
BONDS, SASHA
STETSON, STEPHEN
DREES, KERRI
PRIEST, [NAME]
MARTINEZ, KRISTINA
CROWDER, CAROL
HAINES, CHERYL
HWANG, SUSAN
VARNER, DESIREE
ZAYAS, LYDIA
OCHOA, REGINA
SIGNOR, PAUL
SIMMS, RONNIE
STAVRICOS, WILLIAM
DEGRAVE, CASSONDRA
BEAVER, REX
DE READT, DEBORA
HARRIS, BREJETTE
CANNONE, [NAME]
QUINTANA, EFREN
BERNARD, KEIONDRA
THOMPSON, MARILYN
KELLY-COWENS, QIANA
KIMBROUGH, TONISHA
[NAME], SANDRA
PARKS, SHEENA
Total
Spreadsheet: 775786d1649321087-speed-controls-how-to-calculate-average-speed-hejhallo-bsb-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | km/h | antal
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 43
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 43
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 | 77
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 | 153
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 45 | 199
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 144
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 55 | 81
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 60 | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 65 | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 70 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 75 | 1
Spreadsheet: 10f96ab4-3158-4e6f-b180-9beb3b5248b2
Sheet: Sheet1

Sales Goal Worksheet
 | / | 0.3 | =
Budget Goal |  | Unit Commission |  | Unit [NAME]
 | / |  | =
Sales Goal |  | Number of Scouts |  | Scout Goal
 | / | 16.11 | =
Scout Goal |  | Avg. Price per Container |  | Container Goal
*Enter data
Spreadsheet: 265592d1379338776-relating-text-to-values-and-selecting-specific-rows-panel-example-1-
Sheet: Sheet1

Cord A | [NAME] |  |  |  | A Phase | B Phase | C Phase |  |  | 6.1
9.20, 9.22 | 10.20, 10.22 |  |  |  | 1 | 3 | 5 |  |  | 6.3
6.1, 6.3 | 5.119, 5.121 |  |  |  |  |  |  |  |  | 6.5
6.93, 6.95, 6.97 | 5.7, 5.9, 5.11 |  |  |  |  |  |  |  |  | 6.7
6.37, 6.39, 6.41 | 5.61, 5.63, 5.65 |  |  |  |  |  |  |  |  | 6.9
6.61, 6.63, 6.65 |  |  |  |  |  |  |  |  |  | 6.11
 |  |  |  |  |  |  |  |  |  | 6.13
6.48, 6.50 | 5.13, 5.15 |  |  |  |  |  |  |  |  | 6.15
 |  |  |  |  |  |  |  |  |  | 6.17
 |  |  |  |  |  |  |  |  |  | 6.19
6. 9, 6.11, 6.13 | 5.20, 5.22, 5.24 |  |  |  |  |  |  |  |  | 6.21
 |  |  |  |  |  |  |  |  |  | 6.23
 |  |  |  |  |  |  |  |  |  | 6.25
 |  |  |  |  |  |  |  |  |  | 6.27
 |  |  |  |  |  |  |  |  |  | 6.29
 |  |  |  |  |  |  |  |  |  | 6.31
 |  |  |  |  |  |  |  |  |  | 6.33
 |  |  |  |  |  |  |  |  |  | 6.35
 |  |  |  |  |  |  |  |  |  | 6.36999999999999
 |  |  |  |  |  |  |  |  |  | 6.38999999999999
 |  |  |  |  |  |  |  |  |  | 6.40999999999999
 | Panel |  |  |  | A Phase | B Phase | C Phase |  |  | 6.48 |  |  |  | 2.5
 | 5 |  |  |  |  |  |  |  |  | 6.5 |  | 0 | 0 | 0 | 3
Spreadsheet: 103338d1301071030-finding-duplicate-accounts-using-formula-instead-of-filtering-example
Sheet: Sheet1

 | Customer ID | [NAME] | Start Date | End Date | Outcome
 | 0001 | A | 2011-01-01 00:00:00 | 2011-01-31 00:00:00 | Allowed - unique charge band
 | 0001 | B | 2011-01-01 00:00:00 | 2011-01-31 00:00:00 | Allowed - unique charge band
 | 0056 | C | 2011-02-10 00:00:00 | 2011-02-13 00:00:00 | Allowed - charge band not unique but dates not concurrent
 | 0056 | C | 2011-02-14 00:00:00 | 2011-02-28 00:00:00 | allowed - charge band not unique but dates not concurrent
 | 0106 | D | 2011-03-01 00:00:00 | 2011-03-31 00:00:00 | Not allowed - charge band not unique & running concurrently
 | 0106 | D | 2011-03-01 00:00:00 | 2011-03-31 00:00:00 | Not allowed - charge band not unique & running concurrently
Spreadsheet: 464992d1465398262-12-month-and-quarterly-updated-mean-excel-help-12-month-and-quarterly-rolling-data
Sheet: Sheet1

Month/Year | DLQOR 1Q16 #1 | DLQOR 1Q16 #2 | Quarterly Averages | Yearly Average
2015-04-01 00:00:00 | 0.22 | 0.81
2015-05-01 00:00:00 | 1.22 | 0.61
2015-06-01 00:00:00 | 0.38 | 1.49
2015-07-01 00:00:00 | 1.4 | 0.26
2015-08-01 00:00:00 | 0.45 | 0.64
2015-09-01 00:00:00 | 1.49 | 0.45
2015-10-01 00:00:00 | 0.94 | 1.01
2015-11-01 00:00:00 | 0.4 | 0.52
2015-12-01 00:00:00 | 0.79 | 0.95
2016-01-01 00:00:00 | 0.57 | 0.44
2016-02-01 00:00:00 | 0.56 | 0.92
2016-03-01 00:00:00 | 0.64 | 0.81
2016-04-01 00:00:00 | 0.68 | 1.23
2016-05-01 00:00:00 | 0.46 | 1.05
2016-06-01 00:00:00
Spreadsheet: 39759d1238038485-how-to-look-up-value-in-pivot-table-using-row-and-columns-josh-budget
Sheet: Summary

 | MONTHLY | ANNUAL |  | This Month: | This Year:
Gross Income |  | 50000
Taxes
401k/IRA Contributions | 0 | 0
Net Income
Rent | -1000 |  |  | This is where I want to lookup and put down this month's expenses in each category.  Then I plan to use conditional formatting to make it look pretty and tell me if I am going over budget.
Utilities (Elec, Gas, H2O, Cable/Internet) | -200
Groceries | -200
Restaurants | -400
Gas | -120
Fun (incl. nightlife, weekends, purchases, etc.) | -400
Car insurance | -200
Renters insurance | -20
Cell Phone [NAME] | -100
Invested | -1000
Remainder/Deficit
TO ADD: | Future Value of investments (10 yrs, 9%):
Clothing |  | Annuity
Emergency Fund (3-6 months living expenses) |  | 20 yrs later
Car/House Saving up
Disability Insurance
Spreadsheet: 863444d1710936625-calculating-time-based-on-event-formula-help-tracking-time-on-events
Sheet: Sheet1

AGV Route (Number): | AGV Number: | Battery #1 in | Battery #2 in | Battery #1 out | Battery #2 out | Time stamp | Name
 | 13 | 229 | 227 | 536 | 528 | 09:45:00 | MonDAGV |  | Explanation:
 | 12 | 25 | AX28 | 451 | 425 | 10:05:00 | MonDAGV |  | AGV 13 had flat batteries. Battery #536 and #528 were removed to put in 229 and 227
 | 9 | 425 | 451 | 230 | 442 | 10:15:00 | MonDAGV |  | Some time later
 | 3 | 238 | 377 | 96 | 106 | 08:30:00 | MonDAGV |  | AGV 13 had flat batteries. Battery # 229 and #227 were removed
 | 1 | 73 | 444 | 427 | 174 | 07:22:00 | MonDAGV
 | 5 | 1055 | 551 | 45 | 107 | 10:20:00 | MonDAGV |  | I need a sum to tell me the different between the time battery 227 went in and when it was removed
 | 87 | 1060 | 354 | 1015 | 1012 | 09:45:00 | MonDAGV
 | 13 | 418 | 94 | 310 | 227 | 12:10:00 | MonDAGV |  | Some time later, 227 will go back in again, and be removed again - I'll need another time on this occasion and the next etc.
 | 30 | 83 | 657 | 520 | 523 | 12:22:00 | MonDAGV
 | 21 | 70 | 528 | 10 | 18 | 12:44:00 | MonDAGV
 | 1 | 427 | 174 | 73 | 444 | 13:44:00 | MonDAGV |  | I run a power query to gather all the relevant data for AGV and flat batteries. The 'Name' is the sheet it's pulled from
 | 5 | 227 | 154 | 258 | 296 | 14:55:00 | MonDAGV |  | but I think these will be sheet numbers from 1-31 for dates vs week day numbers
 | 5 | 124 | 142 | 227 | 136 | 16:32:00 | MonDAGV
 | 9 | 591 | 227 | 227 | 897 | 19:55:00 | MonDAGV
Spreadsheet: 682788d1592331517-sum-a-row-of-numbers-based-on-conditions-06-15-20-sum-date-conditional
Sheet: Sheet2

 |  | 2020-06-15 00:00:00
Item |  | Count @Date
DRI042
DRI044 |  |  |  |  |  |  |  | Looking a [NAME] Sheet2, you can see the formula I"m trying to do comes back as #value, I'm not sure why.
DRI043
BOX001
BOX002 |  |  |  |  |  |  |  | I'm trying to sum across rows, with the conditions of of that particular row has the same Item Number, and if its in the columns that are before the date which is stated in 1 particular cell.
BOX005
BOX006
BOX013 |  |  |  |  |  |  |  | the logic I tried to use in the formula might better explain the goal, please help.
BOX033
CHI035
CHI039 |  |  |  |  |  |  |  | I'd love to know why it didn't work, to better learn what my error was.
CHI040
CON010
CON022 |  |  |  |  |  |  |  | I've attached the document.
CON011
FLM003
FLM058
FLM061
FLM002
PBJ006
PBJ007
SNK018
SNK036
SNK037
SNK039
SNK067
SNK081
SNK117
SNK137
SNK109
SNK113
SNK152
SNK151
SNK150
CER030
CER031
CER032
CER033
LAB003
LAB004
LAB022
LAB001
Spreadsheet: 800983d1666021001-dynamic-formula-that-subtracts-last-column-from-second-last-column-in-the-grand-total-line-pivothelp-1-1-
Sheet: Raw Data

Name | Numer of Accounts | Age
Jery | 5 | 5
Jery | 4 | 5
Jery | 1 | 5
Jery | 5 | 5
Jery | 6 | 10
Jery | 54 | 10
Jery | 1 | 10
Jery | 1 | 10
Jery | 1 | 10
Jery | 1 | 15
Jery | 1 | 15
Jery | 1 | 15
Jery | 1 | 15
Jery | 1 | 20
Jery | 1 | 20
Jery | 1 | 20
[NAME] | 1 | 5
[NAME] | 1 | 5
[NAME] | 1 | 5
[NAME] | 5 | 1
[NAME] | 6 | 1
[NAME] | 5 | 1
[NAME] | 5 | 2
[NAME] | 50 | 15
Spreadsheet: phillip_m_love__30146__200002_OA
Sheet: ARUBA-VAR

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - VARIANCE
COMPANY:   ECTR (EGM)
REGION: ARUBA
 |  |  | Reported |  | Actuals |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: e2b4eca4-7c30-4739-9ba1-00445316ed9b
Sheet: Sheet1

Windstream Corporation | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
Windstream Financial Guidance for 2010
(Dollars in millions) |  |  |  |  |  | 2009 |  | 2010 |  |  |  | Percent
 |  |  |  |  |  | Results |  | Guidance Range |  |  |  | Change
Pro forma revenues and sales |  |  |  |  |  | 3956.7 |  | 3820 | - | 3900 |  | -0.03454899284757496 | -0.0143301235878383
Pro forma OIBDA  (1) |  |  |  |  |  | 1830.7 |  | 1839 | - | 1879 |  | 0.004533784891025266 | 0.02638335063090618
Pro forma adjustments:
Pension expense |  |  |  |  |  | 92.5 |  | 63 |  | 63
Restructuring expense |  |  |  |  |  | 9.1 |  | 0 |  | 0
Stock-based compensation |  |  |  |  |  | 25.5 |  | 18 |  | 18
 | Pro forma adjusted OIBDA |  |  |  |  | 1957.8 |  | 1920 | - | 1960 |  | -0.01930738584125036 | 0.001123710287056924
Pro forma capital expenditures (3) |  |  |  |  |  | 411.8 |  | 390 | - | 410
Expected Dividend [NAME] |  |  |  |  |  |  |  | 2010
(Dollars in millions) |  |  |  |  |  |  |  | Guidance Range
Pro forma adjusted OIBDA |  |  |  |  |  |  |  | 1920 | - | 1960
Adjustments to remove pro forma effects:
NuVox pre-acquisition adjusted OIBDA |  |  |  |  |  |  |  | -12.2 |  | -12.2
Iowa Telecom pre-acquisition adjusted OIBDA |  |  |  |  |  |  |  | -54 |  | -54
 | Adjusted OIBDA excluding M&I |  |  |  |  |  |  | 1853.8 | - | 1893.8
Subtract:
Expected capital expenditures  (2) (3) |  |  |  |  |  |  |  | 400 | - | 380
Expected cash paid for interest expense  (2) |  |  |  |  |  |  |  | 494 | - | 494
Expected cash taxes  (2) |  |  |  |  |  |  |  | 105 | - | 120
Pension contribution (4) |  |  |  |  |  |  |  | 41 |  | 41
Expected free cash flow  (5) |  |  |  |  |  |  |  | 813.8 | - | 858.8
Expected dividends paid on common shares |  |  |  |  |  |  |  | 465 | - | 465
Expected dividend payout ratio |  |  |  |  |  |  |  | 0.5713934627672648 | - | 0.5414531904983698
Notes:
(1)   OIBDA is operating income before depreciation and amortization.
(2)   Expected cash payments of Windstream include expenditures related to NuVox and Iowa Telecom subsequent to the acquisitions.
(3)   Guidance range excludes any capital expenditures required for broadband stimulus applications.
(4)   During the three months ended September 30, 2010, the Company made a voluntary contribution of $41.0 million to its qualified pension
plan to preserve an accumulated credit balance, which may be used to offset required future contributions.
(5)   Expected free cash flow of Windstream include amounts generated from NuVox and Iowa Telecom subsequent to the acquisitions.