tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: matthew_lenhart__26362__West Prices0531-01
Sheet: Power West Price Peak

 |  |  | 2001 |  | 2001 |  |  |  |  |  | 2002 |  |  |  |  | 2003 | 2004 |  |  | 2005-2014
Peak | 2000-08-01 00:00:00 | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | Q4-01 | Cal-01 | Q1-02 | Q2-02 | Q3-02 | Q4-02 | Cal-02 | Cal-03 | [NAME] | Q1 | Q2 | Q3 | Q4 | Cal 05-14
MID-COLUMBIA | 0
COB | 0
NP15 | 0
ZP26 | 0
SP15 | 0
Palo Verde | 0
ROCKIES | 0
Price change |  |  | 2001 |  | 2001 |  |  |  |  |  | 2002 |  |  |  |  | 2003 | 2004 |  |  | 2005-2014
Peak | 2000-08-01 00:00:00 | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | Q4-01 | Cal-01 | Q1-02 | Q2-02 | Q3-02 | Q4-02 | Cal-02 | Cal-03 | [NAME] | Q1 | Q2 | Q3 | Q4 | Cal 05-14
MID-COLUMBIA | 0
COB | 0
NP15 | 0
ZP26 | 0
SP15 | 0
Palo Verde | 0
ROCKIES | 0
 |  |  | 2001 |  | 2001 |  |  |  |  |  | 2002 |  |  |  |  | 2003 | 2004 |  |  | 2005-2014
Peak | 2000-08-01 00:00:00 | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | Q4-01 | Cal-01 | Q1-02 | Q2-02 | Q3-02 | Q4-02 | Cal-02 | Cal-03 | [NAME] | Q1 | Q2 | Q3 | Q4 | Cal 05-14
MID-COLUMBIA | 0 | 0 | 0 | 0 | 220 | 285 | 330 | 210 | 183.3333333333333 | 221.375 | 143.3333333333333 | 66.66666666666667 | 160 | 60.33333333333334 | 107.5833333333333 | 56.08333333333334 | 46.32666666666668 | 38.95820000000001 | 26.04793333333333 | 70.24666666666664 | 34.38126666666666 | 42.40851666666666
COB | 0 | 0 | 0 | 0 | 220 | 305 | 340 | 230 | 188.3333333333333 | 227.625 | 147 | 68.33333333333333 | 168.3333333333333 | 58 | 110.4166666666667 | 59.16666666666666 | 48.07666666666668 | 36.35700000000001 | 30.471 | 70.3 | 37.80433333333334 | 43.73308333333334
NP15 | 0 | 0 | 0 | 0 | 230 | 277 | 310 | 196 | 128 | 194.75 | 100 | 61 | 115 | 45 | 80.25 | 41.75 | 40 | 32.79333333333334 | 33.71333333333332 | 67.59 | 32.38 | 41.61916666666674
ZP26 | 0 | 0 | 0 | 0 | 220 | 275 | 310 | 191 | 115 | 187.25 | 98.33333333333333 | 84 | 130.3333333333333 | 57 | 92.41666666666667 | 41.5 | 39.16666666666666 | 32.055 | 33.6936967983744 | 64.18265122390014 | 31.84958501400305 | 40.44523325906946
SP15 | 0 | 0 | 0 | 0 | 220 | 275 | 310 | 191 | 115 | 187.25 | 81 | 65 | 124 | 43 | 78.25 | 46.16666666666666 | 42.08333333333334 | 33.59217116379136 | 35.49109582551636 | 69.03696911446697 | 33.12011845633126 | 42.81008864002654
Palo Verde | 0 | 0 | 0 | 0 | 250 | 320 | 355 | 200 | 113.3333333333333 | 204.5 | 70 | 67 | 165 | 40 | 85.5 | 41.47235872405657 | 38.0019386369918 | 36.48614870436457 | 36.17410667412828 | 58.77331347073811 | 30.58123209167531 | 40.50370023522657
ROCKIES | 0 | 0 | 0 | 0 | 250 | 325 | 360 | 205 | 118.3333333333333 | 208.25 | 75 | 72 | 170 | 45 | 90.5 | 46.47235872405657 | 43.0019386369918 | 41.48614870436457 | 41.17410667412828 | 63.77331347073811 | 35.58123209167532 | 45.50370023522658
Spreadsheet: 84049d1284049246-sum-last-12-non-zero-amounts-sum-q-example
Sheet: Sheet1

Client | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00
A | 0 | 312.45 | 873.68 | 1267.01 | 436.63 | 1181.38 | 667.9 | 1157.38 | 1293.67 | 1128.81 | 1049.25 | 934.02 | 972.43 | 950.65 | 1687.55 | 1193.93 | 1026.93 | 1132.88 | 0 | 0 | 0 | 0 | 0 | 0
B | -1464.29 | 135.24 | 164.22 | 181.98 | 200.58 | 199.5 | 221.34 | 208.92 | 211.86 | 195.48 | 177.24 | 182.52 | 184.5 | 182.28 | 200.34 | 191.52 | 211.92 | 211.02 | 207.36 | 0 | 0 | 0 | 0 | 0
C | 0 | 0 | 0 | 630.61 | 566.88 | 681.85 | 873.41 | 965.72 | 700.21 | 905.89 | 719.06 | 587.64 | 616.4 | 386.05 | 727.05 | 860.2 | 672.91 | 0 | 2208.9 | 0 | 0 | 0 | 0 | 0
D | 0 | 0 | 0 | 0 | 186.65 | 195.92 | 209.8 | 212.56 | 192.23 | 164.19 | 199.75 | 183.86 | 191.32 | 180.84 | 187.51 | 176.08 | 182.96 | 170.79 | 152.33 | 0 | 0 | 0 | 0 | 0
E | 572.8 | 818.31 | 1087.3 | 908.28 | 1028.85 | 874.94 | 845.47 | 1178.3 | 1086.3 | 1115.2 | 851.15 | 871.79 | 1121.68 | 1565.9 | 1507.94 | 1839.99 | 1340.59 | 0 | 0 | 0 | 0 | 0 | 0 | 0
F | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5.58 | 55.56 | 34.08 | 35.32 | 81.72 | 85 | 87.9 | 64.3 | 60.5 | 56.38 | 53.33 | 0 | 0 | 0 | 0 | 0
Spreadsheet: michelle_lokay__26774__CREL_MARKET_2001
Sheet: Releases by Releaser

MARKET Synopsis for Summer 2001
 |  | MDQ under contract |  |  | MDQ released to date [NAME] |  | MDQ Released 00 Apr -Oct
[NAME] | id_vol_type | Apr 00 & Oct 00 | Apr 01 - Oct 01 |  |  |  | Apr. | May | June | July | August | Sept. | Oct.
AGRA RESOURCES | AA | 1600 | 1600 |  |  |  | 1600 | 1600 | 1600 | 1600 | 1600 | 1600 | 1600
CITY OF DULUTH, MN | AA | 10782 | 10782 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
CITY OF TWO HARBORS | AA | 1718 | 1718 |  |  |  | 0 | 190 | 190 | 190 | 190 | 190 | 190
IES INDUSTRIES INC. |  | 98600 | 98600 |  |  |  | 2000 | 2500 | 2500 | 2500 | 2500 | 2500 | 1000
INTERLINK |  | 0 | 0 |  |  |  | 7000 | 6000 | 12000 | 5000 | 5000 | 5000 | 5000
INTERSTATE POWER | AA | 36338 | 36338 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
KN ENERGY |  | 115 | 115 |  |  |  | 10 | 10 | 9 | 9 | 9 | 9 | 9
MADISON GAS & ELECTRIC COMPANY | AA | 11100 | 11100 |  |  |  | 157 | 157 | 2293 | 2139 | 2139 | 139 | 139
METROPOLITAN UTILITIES DISTRICT | AA | 153650 | 153650 |  |  |  | 10000 | 34500 | 14500 | 14500 | 14500 | 14500 | 10000
MIDAMERICAN ENERGY COMPANY | AA | 166941 | 166941 |  |  |  | 700 | 10250 | 5150 | 150 | 150 | 125 | 4685
MIDWEST NATURAL GAS, INC. | AA | 5785 | 5785 |  |  |  | 0 | 200 | 233 | 320 | 465 | 750 | 0
NICOR GAS COMPANY | AA | 186058 | 186058 |  | 31800 |  | 81800 | 31800 | 31800 | 31800 | 31800 | 31800 | 31800
NORTHERN STATES POWER CO. OF WISCONSIN | AA | 42200 | 42200 |  | 16489 |  | 950 | 950 | 950 | 950 | 950 | 950 | 950
NORTHERN STATES POWER COMPANY-MINNESOTA | AA | 217915 | 217915 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
NORTHWEST NATURAL GAS COMPANY | AA | 118 | 118 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 125
NORTHWESTERN PUBLIC SERVICE COMPANY | AA | 18000 | 16200 |  |  |  | 77 | 5000 | 0 | 0 | 0 | 0 | 0
RELIANT ENERGY MINNEGASCO | AA | 136715 | 306715 |  | 5000 |  | 1800 | 1800 | 1800 | 1800 | 1800 | 1800 | 1800
RELIANT ENERGY RETAIL |  | 25000 | 25000 |  |  |  | 7000 | 6000 | 12000 | 5000 | 5000 | 5000 | 5000
ST CROIX VALLEY | AA | 150 | 150 |  |  |  | 0 | 2000 | 2000 | 2000 | 2000 | 2000 | 0
TOWN OF BROOKLIN | AA | 299 | 299 |  |  |  | 0 | 0 | 0 | 0 | 100 | 0 | 0
TOWN OF SABULA | AA | 160 | 160 |  |  |  | 0 | 0 | 0 | 0 | 100 | 0 | 0
US ENRGY | AA | 1020 | 1020 |  |  |  | 250 | 250 | 250 | 250 | 250 | 250 | 250
WESTERN GAS UTILITIES INC. |  | 0 | 0 |  |  |  | 1330 | 0 | 0 | 0 | 0 | 0 | 0
WISCONSIN GAS |  | 76259 | 76259 |  |  |  | 0 | 0 | 2000 | 2000 | 2000 | 5800 | 0
Total excluding pending deals
Spreadsheet: 46739d1245681423-count-function-to-count-from-a-set-point-on-recurring-basis-concentrations-test-page-2009-06-22
Sheet: test page

Day of the week | Day | Dosage | Blood Concentration (mg) | Expected outcome | Drug half life | 2 |  | *Only alter amounts in yellow blocks*
Monday | 1 |  |  | 25 | Desired dosage | 100
Tuesday | 2 |  |  | 25 | Number of total dosages | 4
Wednesday | 3 |  |  | 25 | Dosage interval | 3
Thursday | 4 |  |  | 50
Friday | 5 |  |  | 25
Saturday | 6 |  |  | 25
Sunday | 7 |  |  | 50
Monday | 8 |  |  | 25
Tuesday | 9 |  |  | 25
Wednesday | 10 |  |  | 50
Thursday | 11 |  |  | 25
Friday | 12 |  |  | 25
Saturday | 13 |  |  | 25
Sunday | 14 |  |  | 0
Monday | 15 |  |  | 0
Tuesday | 16 |  |  | 0
Wednesday | 17
Thursday | 18
Friday | 19
Saturday | 20
Sunday | 21
Monday | 22
Tuesday | 23
Wednesday | 24
Thursday | 25
Friday | 26 |  |  |  |  |  |  | if(and($c22="0"(rows($c$2:$c22))<=$G$1*2),$F$1,$F$2)
Saturday | 27
Sunday | 28
Monday | 29
Tuesday | 30
Wednesday | 31
Thursday | 32
Friday | 33
Saturday | 34
Sunday | 35
Monday | 36
Tuesday | 37
Wednesday | 38
Thursday | 39
Friday | 40
Saturday | 41
Sunday | 42
Monday | 43
Tuesday | 44
Wednesday | 45
Thursday | 46
Friday | 47
Saturday | 48
Sunday | 49
Monday | 50
Tuesday | 51
Wednesday | 52
Thursday | 53
Friday | 54
Saturday | 55
Sunday | 56
Monday | 57
Tuesday | 58
Wednesday | 59
Thursday | 60
Friday | 61
Saturday | 62
Sunday | 63
Monday | 64
Tuesday | 65
Wednesday | 66
Thursday | 67
Friday | 68
Saturday | 69
Sunday | 70
Monday | 71
Tuesday | 72
Wednesday | 73
Thursday | 74
Friday | 75
Saturday | 76
Sunday | 77
Monday | 78
Tuesday | 79
Wednesday | 80
Thursday | 81
Friday | 82
Saturday | 83
Sunday | 84
Monday | 85
Tuesday | 86
Wednesday | 87
Thursday | 88
Friday | 89
Saturday | 90
Sunday | 91
Monday | 92
Tuesday | 93
Wednesday | 94
Thursday | 95
Friday | 96
Saturday | 97
Sunday | 98
Monday | 99
Tuesday | 100
Wednesday | 101
Thursday | 102
Friday | 103
Saturday | 104
Sunday | 105
Monday | 106
Tuesday | 107
Wednesday | 108
Thursday | 109
Friday | 110
Saturday | 111
Sunday | 112
Monday | 113
Tuesday | 114
Wednesday | 115
Thursday | 116
Friday | 117
Saturday | 118
Sunday | 119
Monday | 120
Tuesday | 121
Wednesday | 122
Thursday | 123
Friday | 124
Saturday | 125
Sunday | 126
Monday | 127
Tuesday | 128
Wednesday | 129
Thursday | 130
Friday | 131
Saturday | 132
Sunday | 133
Monday | 134
Tuesday | 135
Wednesday | 136
Thursday | 137
Friday | 138
Saturday | 139
Sunday | 140
Spreadsheet: 833674d1687190336-overtime-for-sunday-only-after-a-certain-number-of-hours-worked-query-on-formula-updated
Sheet: Hours 

[NAME]
 |  | Day | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun
2023-05-01 00:00:00 | Employee Code | Date (May 23) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hours worked | Required Hours | Overtime 1.5/ Short Time | Sunday
 | 1 | EMPLOYEE 1 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 5 | 0 | 0 | 0 | 0 | 9 |  | 117 | 14
 | 2 | EMPLOYEE 2 | 9 | 9 | 0 | 0 | 0 | 0 | 0 | 9 | 9 | 5 | 5 | 5 | 5 | 8 | 8 | 8 | 8 | 8 | 0 | 8 | 8 |  | 100
 | 3 | EMPLOYEE 3 | 9 | 9 | 9 | 9 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 | 9 |  |  |  | 9 | 9 | 9 | 5 |  | 117
Spreadsheet: 874747d1721278603-averaging-while-ignoring-blanks-amberlynn77-data-collection-template-aligw
Sheet: ma.mo.adaptive

Date/Time |  |  |  |  |  |  |  |  |  | Date |  |  |  |  |  |  |  |  |  |  |  |  |  | Independent | 100
2024-07-16 00:00:00 | Independent |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gestural | 60
2024-07-16 00:00:00 | Gestural |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Positional | 60
2024-07-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Partial Physical | 40
2024-07-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Full Physical | 20
2024-07-16 00:00:00 | Full Physical |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Response | 0
Spreadsheet: 788363d1658419357-index-match-from-dropdown-test_data
Sheet: bill_calculation

 |  |  |  |  | `
 |  | distribution
 |  | Vegetables/Fruits |  |  |  | Order
 |  | Items | Rate | Per | Weight | shrikant | Poushali | Pravina | Sharad | Wajpe | Dinesh | Vijay | Ban |  |  |  |  | Total Order | Total [NAME]
 |  | [NAME] | 60 | Kg | 1000 | 250 |  | 250 | 250 | 250 | 250 | 250 |  |  |  |  |  |  | 90
 |  | Curlyflower | 56 | Kg | 1000 | 500 | 500 | 500 | 250 |  | 750 | 750 | 250
 |  | Brinjal | 44 | Kg | 1000 | 500 | 250 | 500 | 500 |  | 750 | 750
 |  | Beans | 15 | Bunch | 1 | 1 |  | 1 | 2 | 1
 |  | Greens | 15 | Bunch | 1 | 1 |  | 1 | 3
 |  | Veg.Leavs | 15 | Bunch | 1 | 1 |  | 2 | 1 |  | 2
 |  | Red beans | 20 | Bunch | 1 | 1 | 1 | 1 | 1
 |  | [NAME] | 20 | Bunch | 1 | 1 | 1 | 1 | 2 |  | 2
 |  | [NAME] | 10 | Bunch | 1 | 5 |  | 5 | 10 |  | 10
 |  | Mint | 20 | Bunch | 1 | 1 | 1 | 1 | 1 |  | 2 |  | 2
 |  | [NAME] | 60 | Dozen | 12 | 6 | 12 | 12 | 12 |  | 12
 |  | Sapling | 30 | Piece | 1 | 1 |  | 1 | 1 | 1 | 2 |  |  |  |  |  |  |  |  |  |  |  | `
 |  | Total
Spreadsheet: cara_semperger__1437__PGE_NOVEMBER_MIDC_PATHS
Sheet: NOV (11)

 |  |  | To Portland General Electric : [NAME], [NAME], and [NAME]
 |  |  | Phone 464-7067
 |  |  | From Enron: Cara, [NAME], and [NAME] |  |  |  |  |  | DAILY COLSTRIP = 0
 |  |  | Phone 464-3814, 3902, 3831 |  |  |  |  |  | MONTH LONG COLSTRIP = 47 ATC
 |  |  |  |  |  |  |  |  | 3 MW DAILY FLAT
 |  |  |  |  | Mid Columbia Paths
2001-11-11 00:00:00
 | FLAT
 | DAY | 3 | DAILY | X | PGE | ENRON | SNO | X | BPA(T)PGE/SNPD #96092HNF-SNPD SINKS
 | DAY | 19 | AVISTA(G)CHELAN | X | AVISTA | ENRON | PGE | X | COLSTRIP B/R
 | DAY | 3 | BPA C#10440-CLATSKANPE-BPA(T)BPAP/PGE #10649NF | X | CLATSKANPE | ENRON | PGE | X | COLSTRIP B/R
 | MONTH | 25 | WWP(G)MIDC | X | WWP | ENRON | PGE | X | COLSTRIP B/R
 | MONTH COLSTRIP PATHS
 | ALL HOURS
 | MONTH | 6 |  | X | PGE | ENRON | ASHGROVE | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 6 |  | X | PGE | ENRON | EXPRESS PIPE | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 7 |  | X | PGE | ENRON | HOLNAM | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 8 |  | X | PGE | ENRON | LOUISIANA P | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 5 |  | X | PGE | ENRON | LUZENAC | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 15 |  | X | PGE | ENRON | SMURFIT | X | MPCO NETWORK TRANSMISSION TO LOAD
Spreadsheet: 480551d1473958679-converting-worksheet-with-multiple-columns-of-months-to-single-rows-and-more-columns-to-rows-sample
Sheet: Sheet1

Original Document:
Account # | Description | Start Balance | Period 1 - 2016 | Period 2 - 2016 | Period 3 - 2016 | Period 4 - 2016 | Period 5 - 2016 | Period 6 - 2016 | Period 7 - 2016 | Period 8 - 2016 | Period 9 - 2016 | Period 10 - 2016 | Period 11 - 2016 | Period 12 - 2016 | Total | Center | Account Short
105-5000 | text | 0 | 2 | 10 | 2 | 6 | 5 | 2 | 2 | 2 | 2 | -5 | -5 | -4
105-5100 | text | 0 |  | 456 | 45 | 2 | 45 | 46 | 456 | 45 | 64 | 45 | 456 | 45
106-5000 | text | 0 | -1000 |  |  | 2 | 2 | 2 | 2 | 2
106-5100 | text | 0 |  | 456 | 45 | 2 | 45 | 46 | 456 | 45 | 64 | 45 | 456 | 45
*blanks cells exist
Needed Document:
Account # | Center | Account Short | Date | Amount
Spreadsheet: 675207d1588193567-matching-up-to-two-sets-of-data-move-sample
Sheet: Sample

Sample
Client # | DDA Account | Primary Name | RDS | RDS Limit | Setup Date | Review | Visit | Officer | DDA ACCT | NAME | RISK
4541231 | 668 | ABC CO | Y | 20000 | 06/02/2010 | 01092021 | 05072020 | ALP - PRIETO (60) | 7499 | BBB | H
 | 802 | ABC CO | Y |  |  |  |  | ALP - PRIETO (60) | 9505 | BBB | M
4543453 | 9505 | BBB | Y | 125000 | 06/22/2011 | 12102020 | 11262020 | NSK - KAIL (52) | 1380 | BBB | L
 | 7499 | BBB | Y |  |  |  |  | NSK - KAIL (52) | 668 | ABC CO | M
 | 1380 | BBB | Y |  |  |  |  | NSK - KAIL (52) | 7624 | CORP INC | M
34213453 | 7608 | CORP INC | Y | 750000 | 2019-08-27 00:00:00 |  |  | CWM - MILAM (59) | 7616 | CORP INC | M
 |  |  |  |  |  |  |  |  | 1234 | PARTNER LP | M
Spreadsheet: 149297d1333817562-how-to-populate-cells-next-to-a-list-selection-meal-chart-example
Sheet: Meal 3

Measurement | Meal | Protein (grams) | Carbs (grams) | Fat (grams) | Calories
31 | Zero Carb Isopure | 0 | 0 | 0 | 0
56 | [NAME] | 0 | 0 | 0 | 0
32 | Optimum Casein | 0 | 0 | 0 | 0
12 | NanoGreens | 0 | 0 | 0 | 0
12 | NanoRed | 0 | 0 | 0 | 0
3 | NOW Omega 3 | 0 | 0 | 0 | 0
 | Goal | 283 | 283 | 63 | 2825
 | Difference
Spreadsheet: 848861d1699479844-formula-to-calculate-an-agreements-remaining-value-with-an-escalator-lease-id
Sheet: All Locations

 |  |  |  |  |  | Date Used In Duration Calculation |  |  | 2023-11-08 00:00:00
Lease ID | Current Term Start Date | Current Term End Date | Commencement Date | Final Lease End Date | Total Lease Length (Months) | Days from lease start to today | Duration Into Lease |  | Days Remaining In lease | Duration Remaining of Lease |  | Current Rent Amount (Annual) | Current Rent Amount (Monthly) | Increase Type | Increase Percent | Increase Interval | Next Increase Date
1 | 2021-01-24 00:00:00 | 2026-01-23 00:00:00 | 2011-01-24 00:00:00 | 2036-01-23 00:00:00 | 300 |  |  |  |  |  |  | 750
2 | 2022-01-01 00:00:00 | 2026-12-31 00:00:00 | 2000-02-28 00:00:00 | 2041-12-31 00:00:00 | 503 |  |  |  |  |  |  | 1025 |  | Fixed % | 0.04 | 1 Year | 2024-02-28 00:00:00
3 | 2019-11-22 00:00:00 | 2024-11-21 00:00:00 | 2004-11-22 00:00:00 | 2029-11-21 00:00:00 | 300 |  |  |  |  |  |  | 750 |  | Fixed % | 0.15 | 5 Years | 2024-11-22 00:00:00
4 | 2020-08-01 00:00:00 | 2025-07-31 00:00:00 | 2000-07-01 00:00:00 | 2040-07-31 00:00:00 | 481 |  |  |  |  |  |  | 480
5 | 2013-07-01 00:00:00 | 2025-07-31 00:00:00 | 2008-07-01 00:00:00 | 2030-07-31 00:00:00 | 265 |  |  |  |  |  |  | 1150 |  | Fixed % | 0.03 | 1 Year | 2024-07-01 00:00:00
6 | 2022-07-16 00:00:00 | 2027-07-15 00:00:00 | 2007-07-16 00:00:00 | 2037-07-15 00:00:00 | 360 |  |  |  |  |  |  | 830 |  | Fixed % | 0.12 | 5 Years | 2027-07-16 00:00:00
12 | 2020-09-01 00:00:00 | 2025-08-31 00:00:00 | 2005-09-01 00:00:00 | 2035-08-31 00:00:00 | 360 |  |  |  |  |  |  | 1350 |  | Fixed % | 0.05 | 5 Years | 2025-09-01 00:00:00
13 | 2022-01-01 00:00:00 | 2026-12-31 00:00:00 | 2022-01-01 00:00:00 | 2041-12-31 00:00:00 | 240 |  |  |  |  |  |  | 1000 |  | Fixed % | 0.03 | 1 Year | 2024-01-01 00:00:00
14 | 2019-12-04 00:00:00 | 2029-12-03 00:00:00 | 2019-12-04 00:00:00 | 2049-12-03 00:00:00 | 360 |  |  |  |  |  |  | 900 |  | Fixed % | 0.0225 | 1 Year | 2023-12-04 00:00:00
15 | 2021-02-03 00:00:00 | 2031-02-02 00:00:00 | 2021-02-03 00:00:00 | 2041-02-02 00:00:00 | 240 |  |  |  |  |  |  | 1200 |  | Fixed % | 0.04 | 1 Year | 2024-02-03 00:00:00
Spreadsheet: 218435d1362459645-data-validation-formula-based-on-adjacent-cell-manifest
Sheet: Sheet3

a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s | t | u | v | w | x | y | z
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z
a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s | t | u | v | w | x | y | z
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z
a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s | t | u | v | w | x | y | z
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z
a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s | t | u | v | w | x | y | z
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z
a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s | t | u | v | w | x | y | z
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z
a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s | t | u | v | w | x | y | z
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z
a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s | t | u | v | w | x | y | z
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z
a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s | t | u | v | w | x | y | z
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z
Spreadsheet: 735258d1622799072-repeat-for-annually-quarterly-between-2-dates-differing-due-date-frequencies-camp2-2-ans
Sheet: Sheet1 (2)

Start Date |  |  | End Date | 2025-05-01 00:00:00
 |  |  |  |  |  | Show like this:   (its repeating between the Start Date and End Date
Description | Frequency | Days | Due Date |  |  | Description | Frequency | Days | Due Date
Financials Annual | Annually | 90 |  |  |  | Financials Annual | Annually | 90 | 2022-03-31 00:00:00 | First "hit" after the start date
Financials Qtr | Quarterly | 60 |  |  |  | Financials Annual | Annually | 90 | 2023-03-31 00:00:00 | next hit
 |  |  |  |  |  | Financials Annual | Annually | 90 | 2024-04-01 00:00:00 | next hit
 |  |  |  |  |  | Financials Annual | Annually | 90 | 2025-03-31 00:00:00 | End Date
 |  |  |  |  |  | Financials Qtr | Quarterly | 60 | 2021-09-30 00:00:00 | First "hit" after the start date
Note:  my data set is much larger than this.  It’s a simplified example |  |  |  |  |  | Financials Qtr | Quarterly | 60 | 2021-12-31 00:00:00 | next hit
Description | Frequency | Days | Due Date |  |  | Financials Qtr | Quarterly | 60 | 2022-03-31 00:00:00 | next hit
 |  |  |  |  |  | Financials Qtr | Quarterly | 60 | 2022-06-30 00:00:00 | next hit
 |  |  |  |  |  | Financials Qtr | Quarterly | 60 | 2022-09-30 00:00:00 | "
 |  |  |  |  |  | Financials Qtr | Quarterly | 60 | 2022-12-31 00:00:00 | "
 |  |  |  |  |  | Financials Qtr | Quarterly | 60 | 2023-03-31 00:00:00 | "
 |  |  |  |  |  | Financials Qtr | Quarterly | 60 | 2023-06-30 00:00:00
 |  |  |  |  |  | Financials Qtr | Quarterly | 60 | 2023-09-30 00:00:00
 |  |  |  |  |  | Financials Qtr | Quarterly | 60 | 2023-12-31 00:00:00
 |  |  |  |  |  | Financials Qtr | Quarterly | 60 | 2024-03-31 00:00:00
 |  |  |  |  |  | Financials Qtr | Quarterly | 60 | 2024-06-30 00:00:00
 |  |  |  |  |  | Financials Qtr | Quarterly | 60 | 2024-09-30 00:00:00
 |  |  |  |  |  | Financials Qtr | Quarterly | 60 | 2024-12-31 00:00:00
 |  |  |  |  |  | Financials Qtr | Quarterly | 60 | 2025-03-31 00:00:00 | End Date
Spreadsheet: 162386d1339841356-excel-2007-offset-function-help-needed-order-quiz
Sheet: DATA

CATEGORIES | CATEGORY | [NAME]
FITTINGS | FITTINGS | OTVOD
PIPE | FITTINGS | [NAME]
VENT | FITTINGS | PEREXOD
 | PIPE | PVC
 | PIPE | PPR
 | PIPE | GAL
 | PIPE | STAL
 | VENT | RADIAL
 | VENT | KANAL
 | VENT | KRISH
Spreadsheet: f1a36db4-de52-48f3-a1aa-0c60708d9439
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
[NAME] | Test | [NAME] | Parasite Identification | Parasite Identification |  |  |  |  |  |  | This test is for Billing Purposes Only.  This is not an orderable test. |  |  |  |  |  |  | 1 | 87169 |  |  |  |  | Rochester
[NAME] | [NAME] | VARIES | Varies |  |  |  | See instructions