tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 725091d1616523539-formula-needed-for-several-scenerios-summary-report
Sheet: July-20

 | Month: | 2020-07-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | New Credits
 | SC # | SC Name | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | Total |  |  | Pre-Invoice Amounts | CR Applied | Invoice Amts
Prior/Current | 1234 | Example Name | 0 | 0 | 12430.46 | 2015.04 | 11294.35 | 2364.01 | 1271.04 | 340.55 | 173.86 | 1001.09 | 1265.51 |  |  |  |  |  | 2537.41
Prior/Current | 2345 | Example Name | 0 | 0 | 0 |  | 4139.48 | 2002.86 | 65.53 | 62.55 | 124.65 | 77.4 | 34.86 |  |  |  |  |  | 1181.25
Prior/Current | 3456 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 87983.13 | 15395.92 | 639.64 |  |  |  |  |  | 8030.23
Prior/Current | 4567 | Example Name | 0 | 0 | 0 | 0 | 2458.07 | 868.01 | 325.14 | 221.6 | 305.99 | 30.8 | 482.43 |  |  |  |  |  | 838.49
Prior/Current | 5678 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 845.2 | 1448.59 |  |  |  |  |  | 16282.43
Prior/Current | 6789 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1040.88 |  |  |  |  |  | 8103.95
Prior/Current | 7890 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18708.56 | 463.06 | 373.47 |  |  |  |  |  | 2383.56
Prior/Current | 8901 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 265.16 |  |  |  |  |  | 4300.14
Prior/Current | 9012 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 84057.14 | 76.31 | 67.07 |  |  |  |  |  | 1438.62
Prior/Current | 9013 | Example Name | 0 | 0 | 0 | 0 | 1652.36 | 1279.49 | 2214.81 | 245.23 | 262.39 | 563.85 | 2676.81 |  |  |  |  |  | 2669.68
Used | 1234 | Example Name
Used | 2345 | Example Name
Used | 3456 | Example Name
Used | 4567 | Example Name
Used | 5678 | Example Name
Used | 6789 | Example Name
Used | 7890 | Example Name
Used | 8901 | Example Name
Used | 9012 | Example Name
Used | 9013 | Example Name
Remaining/Carried Forward | 1234 | Example Name | 0 | 0
Remaining/Carried Forward | 2345 | Example Name | 0 | 0
Remaining/Carried Forward | 3456 | Example Name | 0 | 0
Remaining/Carried Forward | 4567 | Example Name | 0 | 0
Remaining/Carried Forward | 5678 | Example Name | 0 | 0
Remaining/Carried Forward | 6789 | Example Name | 0 | 0
Remaining/Carried Forward | 7890 | Example Name | 0 | 0
Remaining/Carried Forward | 8901 | Example Name | 0 | 0
Remaining/Carried Forward | 9012 | Example Name | 0 | 0
Remaining/Carried Forward | 9013 | Example Name | 0 | 0
Spreadsheet: 770438d1646066225-copying-a-shape-to-a-cell-and-have-it-automatically-align-tracker
Sheet: TRACKER

Daily
Tracker
MARCH 2022
ACTIVITY | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
xxxxxxxxxxxxx |  |  |  |  | 1 |  |  |  |  | 1 |  |  |  |  |  | 1 |  |  |  |  | 1
xxxxxxxxxxxxx |  |  | 1
xxxxxxxxxxxxx | 1 |  |  |  | 1 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
xxxxxxxxxxxxx | 1
xxxxxxxxxxxxx |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
xxxxxxxxxxxxx |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
xxxxxxxxxxxxx |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
xxxxxxxxxxxxx |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
xxxxxxxxxxxxx |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
xxxxxxxxxxxxx |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
xxxxxxxxxxxxx |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
xxxxxxxxxxxxx |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
xxxxxxxxxxxxx |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
xxxxxxxxxxxxx |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
xxxxxxxxxxxxx |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
xxxxxxxxxxxxx |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
xxxxxxxxxxxxx |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
xxxxxxxxxxxxx |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: e5533742-5f43-481e-8b32-68ceab193052
Sheet: M2.  Med Loss Ratio SG

Exhibit M2:  Medical Loss Ratio Exhibit Small Group Market
[NAME]:
Plan Type(s):
Market Segment:
Rate Effective Date:
 | A | B | C | D | E | F | G | H
Time Period | Member Months | Incurred Claims2, 3, 4 | Earned Premium2, 3, 4 | Quality Improvement Expenses2, 3, 4 | Adjustments to Earned Premium2, 3, 4 | Medical [NAME] | Incurred Claims plus Quality Improvement Expenses PMPM | Earned Premium minus Adjustments to Earned Premium PMPM
CY 2009
CY 2010
CY 2011
Most Recent 12 Months
Future Year 11
1.  The future year should represent the 12 months immediately following the rate effective date.
2.  The experience in this exhibit should be based on the total membership in the New Hampshire Small Group Market and plan type being filed, regardless of renewal date.
3.  These items should be provided in total dollar amounts for the given time period.
4.  These terms are defined in NHCAR Part INS Chapter 4103.
Spreadsheet: phillip_allen__28859__pivot_1210
Sheet: Pro Forma

 |  |  |  | Stagecoach Apartments
 |  |  |  | 2001 Pro Forma Operating Statement
Gross Possible Rents |  |  |  |  | 262340
Less vacancies (10%)
Laundry Income |  |  |  |  | 3600
 | Total Income
Utilities($4,500/month)
Materials($1,800/month)
Manager ($260/week)
Maintenance ($280/week)
Services($100/month) |  |  |  |  | 1200
Property tax |  |  |  |  | 12000
Insurance |  |  |  |  | 4000
 | Total Expenses
 | Net Operating Income
Spreadsheet: 710200d1608765995-opportunity-cost-calculation-opportunity-cost
Sheet: Sheet1

Item# | Quantity | Cost | Opportunity
12345 | 5 | 200 | 0
12346 | 10 | 200 | 0
12347 | 150 | 100
12347 | 20 | 50
12347 | 400 | 75
12348 | 10 | 200 | 0
12349 | 15 | 300 | 0
Opportunity = Zero for same Item #
Opportunity= If there are different Qty and Cost data
Equals to the Sum of difference in the price*Quantity
Example: For Item 12347, lowest price is $50, so opportunity is sum of 400x ($75-$50) and 150 x ($100-$50)
Spreadsheet: 867824d1714626319-how-to-get-multiple-vlookup-values-in-to-dropdown-list-bank-interest-3_2-reimbursmnt-sample
Sheet: Reimbursment

Bank Loan 3/2 Reimbursment
PF No. | Name | Designation | Loan Number | Bank | Branch | Period |  | Amount
Month of January 2024
36224 |  |  |  |  |  | 2022-02-01 00:00:00 | 2023-02-01 00:00:00 | 5000
 |  |  |  |  |  | 2022-02-01 00:00:00 | 2023-02-01 00:00:00 | 5000
Spreadsheet: 764687d1642882600-automate-data-validation-logic-cross-validation
Sheet: Associations

Unit | Division | Composite |  | Root Cause - Who | Remediation Group | Composite
Sales | Account Management |  |  | Internal | Team Member
Sales | Executive |  |  | Contractor | Third Party
IT | Corporate |  |  | Vendor | Third Party
IT | Development
Marketing | Internal
Marketing | External
Marketing | PR
Spreadsheet: 65619d1266335995-help-with-if-formula-for-dates-pivot1
Sheet: Sheet1

date ----------- c2 -- c3 - Sum
1 | 2 | 2003 | 2 | -
1 | 2 | 2003 | - | 1
1 | 2 | 2003 | - | 2 | -1
1 | 3 | 2003 | 2 | -
1 | 3 | 2003 | 2 | -
1 | 3 | 2003 | 2 | -
1 | 3 | 2003 | 1 | - | 7
1 | 4 | 2003 | 3 | -
1 | 4 | 2003 | - | 5
1 | 4 | 2003 | - | 2 | -4
Spreadsheet: 755985d1637219532-derive-closed-form-expression-for-interest-series-interest_calc
Sheet: Sheet1

x
 |  | 0.0065 | Int. Rate p.a. |  | Int. Convention: 30/360
 |  |  | 2021-12-31 00:00:00 | 2022-01-31 00:00:00 | 2022-02-28 00:00:00 | 2022-03-31 00:00:00 | 2022-04-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-30 00:00:00 | 2022-07-31 00:00:00 | 2022-08-31 00:00:00 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00 | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 |  | Total
 | Cash BoP | 0
 | Priv. Placement | 125000000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Overfunding |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Interest Funding |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Cash EoP
 | Interest Charge | 0
 | Initial Interest |  | how would these formulas need to change if the interest should become part of the above schedule
 | Interest on Int. F. |  | that is, without triggering a circular reference, upfront interest funding shall be sized in such a way that the final balance = 127,500,000.00
 | Total |  | that is, Intererst Funding = Interest Charge
 | Check
 | Cash BoP | 0
 | Priv. Placement | 125000000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Overfunding |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Interest Funding |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Interest Charge | 0
 | Cash EoP
 | Check
 |  |  |  |  | Int. Convention: ACT/360
 | Cash BoP | 0
 | Priv. Placement | 125000000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Overfunding |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Interest Funding |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Cash EoP
 | Interest Charge | 0
 | Initial Interest |  | can such same compact formula be derived with an ACT/360 interest convention?
 | Interest on Int. F.
 | Total
 | Check
 | Interest Fraction Factor
Spreadsheet: 770736d1646237717-index-list-values-that-meet-criteria-list-with-array
Sheet: Company 1

 |  | Company 1
Date | Hours | Contract
Spreadsheet: 714410d1611220945-creating-rows-in-another-sheet-based-on-data-one-sheet-problem-2-ans-2
Sheet: Sheet1-Data

STD | 10 | 20 | 30 | 30 | 20 | 10
STATION | P1 | P2 | P3 | P4 | P5 | P6 | TOTAL
NOIDA | 330 | 650 | 790 | 650 | 530 | 200
DELHI | 230 | 300 | 390 | 300 | 210 | 130
aaaa | 300 | 100 | 20 | 100 | 250 | 350
Spreadsheet: 68330d1268851472-matching-help-test-matching-1
Sheet: main

Asset | Location | Description | Parent | Classification | Serial Number
6164 | 14AL1801A | ANALYZER: VAPOR DESTRUCTOR O2 (O2) |  | ANALYZER \ ANAENV | 151464
6165 | 14AL1801B | ANALYZER: VAPOR DESTRUCTOR O2 (O2) |  | ANALYZER \ ANAENV | 151464
6166 | 14AL3801 | ANALYZER: VAPOR PRESSURE ([NAME]) |  | ANALYZER \ ANAPROC | 980600246
3025 | 14C047 | COMP: TRK. [NAME]. COMP. |  | COMP | DW41062
Spreadsheet: 73273d1273889762-or-functions-that-can-be-one-set-of-data-or-another-book1
Sheet: Sheet3

 | Volts | Amps | Ohms | Watts
 | 5 |  | 2 |  |  |  |  |  | Volts | 0
 |  |  |  |  |  |  |  |  | Volts | #N/A
Volts | 5 |  |  |  |  |  |  |  | Volts | 0
Amps | 2.5 |  |  |  |  |  |  |  | Amps | 0
Ohms | 2 |  |  |  |  |  |  |  | Amps | 0
Watts | 12.5 |  |  |  |  |  |  |  | Amps | 2.5
 |  |  |  |  |  |  |  |  | Ohms | #N/A
 |  |  |  |  |  |  |  |  | Ohms | #N/A
 |  |  |  |  |  |  |  |  | Ohms | #N/A
 |  |  |  |  |  |  |  |  | Watts | 12.5
 |  |  |  |  |  |  |  |  | Watts | 0
 |  |  |  |  |  |  |  |  | Watts | 0
Spreadsheet: 09d74b13-05b9-457e-944f-e989f593af0b
Sheet: Sheet1

Whitman College Time Reporting Form | 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 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25
VOLUNTEER HOURS ONLY
Name (Last, First, M.I.) |  |  |  |  |  |  |  |  |  |  |  |  |  | Job Title |  | [NAME]
Employing Department |  |  |  |  |  |  |  |  |  |  |  |  |  | Account Number
Month/Year |  |  |  |  |  |  |  |  |  |  |  |  |  | Account Name
This form is used by college volunteers only.  Please include the GL account number and account name and send to the
Payroll Office, Mem 107.
 |  |  |  |  |  |  |  | Use these dates only if failed to report previously | CURRENT MONTH
HOURS REPORTED |  | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17
Regular
Overtime
[NAME]
Vacation
Holiday
Other*
LOA
Comp Earned
 |  |  | CURRENT MONTH |  |  |  |  |  |  |  |  |  |  |  | TOTAL HOURS ** | 0
HOURS REPORTED |  | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | pay | non |  |  | COMMENTS
Regular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Overtime |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Vacation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Holiday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Other* |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
LOA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Comp Earned |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
CERTIFIED AS ACCURATE |  |  |  |  |  |  |  |  |  |  |  | VERIFIED AS ACCURATE
Employees Signature |  |  |  |  |  |  | Date |  |  |  |  | [NAME]'s Signature |  |  |  |  |  |  |  |  |  |  | Date
LOA = Leave of Absence/Approved-Nonpaid
* Include Comp Time (C), Jury Duty (J), [NAME] (BL), and code accordingly.  [NAME] to staff handbook for leave information.
** Report in 1/4 hour increments
Spreadsheet: 05e9653a-5aaa-4020-b96c-b00ed2eaeaae
Sheet: Tables 1-5

SP-13-0125 AWIN OC12 SELF-HEALING RING, LTRK-TXRK DS3, OC3s P-P T1's
OFFICIAL PRICE SHEET
E-Rate Spin #
Table 1: AWIN 4 [NAME] OC12 Ring |  | Sec. 2.2 Bid Table 1
Description | Cost/UNIt/Mo. | 36 Month Cost | Installation Cost | Special Construction
4 [NAME] OC-12 Ring With 12 DS3 drops [NAME]. 2.2 Bid Table Table 1 | 0 |  | 0 | 0
 | Total 36 Mo. Cost
Delivery _________ days after receipt of order.
Table 2: AWIN 5 [NAME] OC12 Ring |  | Sec. 2.2 Bid Table 2
Description | Cost/UNIt/Mo. | 36 Month Cost | Installation Cost | Special Construction |  |  |  |  | T
5 [NAME] OC-12 Ring With 16 DS3 drops [NAME]. 2.2 Bid Table 2 | 0 |  | 0 | 0
 | Total 36 Mo. Cost
Delivery _________ days after receipt of order.
Table 3: AWIN Ring Additional DS3 Drops |  |  | Sec. 2.2.7
Description | Cost/Unit/Mo | Quantity | Extended Cost | 36 Month Cost | Installation Cost
Additional DS3 Drops Sec. 2.2.7 |  | 8
 |  |  |  | Total 36 Mo Cost
Total of Tables 1, 2 & 3 | Total 36 Month Cost
Delivery _________ days after receipt of order.
Table 4: Little Rock-Texarkana DS3 Transport |  |  | Sec. 2.3
Description |  | Cost/Month | 12 Month Cost | Installation Cost
LTRKARFR-TXRKTXXADS0 DS3 Sec. 2.3 |  | 0 |  | 0
 |  |  | Total 12 Month Cost
Delivery _________ days after receipt of order.
 |  |  |  |  | SP-13-0125
Table 5: Little Rock to Glenwood & Harrison OC3s |  |  | Sec. 2.4
Description |  | Cost/Month | 12 Month Cost | Installation Cost
DIS, One Capitol Mall, Little Rock-Windstream Harrison Central Office,(HRSNARXABB1) [NAME], AR |  | 0
DIS, One Capitol Mall, Little Rock-Windstream [NAME]) Glenwood, AR  Sec. 2.4 |  | 0
 |  | Total
 |  |  | total 12 Mo Cost
Delivery _________ days after receipt of order.
Spreadsheet: 876152d1722846252-need-formula-for-tier-incentive-calculation-calculation-doing-formula
Sheet: Dr. Zeina

Contract Terms (*)
 |  | 1- Revenue on Dental Procedure After Deducting Dental Lab then 5% Admin | 0.5
Doctor Calculation
 |  | Doctors Gross Revenue
 |  | Doctors Clinic Procedures | 61621.94000000001
 |  | Dental Lab | 2700
 |  | Net Revenue
 |  | Amount to be Paid
 |  | Clinic Fees 5%
 |  | Amount to be Paid
 |  | Doctors One day Surgery | 0
 |  | OR Fee | 0
 |  | ODS Net Revenue
 |  | Amount to be Paid
 |  | Clinic Fees 5%
 |  | Amount to be Paid
 |  | Net Amount to be Paid
 |  | Less Monthly Salary | 10000
 |  | Net Amount to be Paid
Prepared By …................. |  |  | CFO | CFO: | .......................
Spreadsheet: f267bfb5-3252-4f2d-ac92-f591bc798946
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
43009452 | 2014-09-04 00:21:19 | AXIS | 1 | 4 | 2 | 1591724 | Gladiatore | 6151 | western | 1944-07-21 | 1944-07-21 | [NAME] | [NAME]
43009724 | 2014-09-04 00:32:19 | ALLIES | 0 | 3 | 4 | 1591724 | Gladiatore | 6151 | western | 1944-07-21 | 1944-07-21 | [NAME] | [NAME]
43009896 | 2014-09-04 01:00:18 | ALLIES | 1 | 6 | 2 | 1217623 | player1217623 | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
43010118 | 2014-09-04 01:31:22 | AXIS | 0 | 5 | 6 | 1217623 | player1217623 | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
43016495 | 2014-09-04 15:23:06 | AXIS | 0 | 2 | 6 | 1602314 | JL67 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
43016613 | 2014-09-04 15:39:57 | ALLIES | 1 | 6 | 1 | 1602314 | JL67 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
43018670 | 2014-09-04 19:23:19 | ALLIES | 1 | 10 | 5 | 1088314 | bino_zoet | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
43019029 | 2014-09-04 19:52:10 | AXIS | 1 | 10 | 7 | 1088314 | bino_zoet | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
43019396 | 2014-09-04 20:34:50 | AXIS | 1 | 10 | 8 | 1330700 | Lugal 1er | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
43019908 | 2014-09-04 21:17:48 | ALLIES | 0 | 8 | 10 | 1330700 | Lugal 1er | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
43078074 | 2014-09-08 21:42:40 | AXIS | 0 | 2 | 4 | 954955 | [NAME] | 6161 | western | 1944-06-10 | 1944-06-10 | Mont Mouchet | Mont Mouchet
43078347 | 2014-09-08 21:51:51 | ALLIES | 1 | 4 | 2 | 954955 | [NAME] | 6161 | western | 1944-06-10 | 1944-06-10 | Mont Mouchet | Mont Mouchet
43078583 | 2014-09-08 22:20:40 | ALLIES | 1 | 5 | 2 | 331242 | AdairC | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
43078922 | 2014-09-08 22:36:53 | AXIS | 1 | 5 | 2 | 331242 | AdairC | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
43093391 | 2014-09-10 00:06:44 | ALLIES | 1 | 4 | 1 | 1631673 | [NAME] | 6161 | western | 1944-06-10 | 1944-06-10 | Mont Mouchet | Mont Mouchet
43093511 | 2014-09-10 00:21:34 | AXIS | 1 | 4 | 0 | 1631673 | [NAME] | 6161 | western | 1944-06-10 | 1944-06-10 | Mont Mouchet | Mont Mouchet
Spreadsheet: 540b8116-0c2e-40ba-9693-ddfba7708078
Sheet: NON-RESIDENTIAL 

 |  |  |  |  |  |  |  |  | CITY OF RIO RANCHO, NEW MEXICO
 |  |  |  |  |  |  |  |  | JULY 2014 NON-RESIDENTIAL DATA
APPLICATION TYPE |  | ADDRESS |  |  |  | LEGAL DESCRIPTION |  |  |  | PERMIT NUMBER |  |  | SQUARE FOOTAGE | VALUATION | CONTRACTOR | NOTES | STAFF USE ONLY
 | Street Number | Street Name | Suffix | [NAME] | Unit | Block | Lot | Tr | Permit Year | Permit number | STATUS | YMMDD
[NAME] | 4330 | MEADOWLARK | LN | SE | CS | H |  |  | 14 | 5204 | PC | 140730 | 968 | 29175 | ALBUQUERQUE ASPHALT INC | [NAME]
NCOM | 3575 | NM HIGHWAY 528; Bldg C | BLVD | NE | PEH |  |  | J | 14 | 4965 | PC | 140721 | 23647 | 2045938 | OUT TO BID | retail
NCOM | 3575 | NM HIGHWAY 528; Bldg E |  | NE | PEH |  |  | J | 14 | 4966 | PC | 140721 | 17370 | 1502852 | OUT TO BID | retail
NCOM | 3575 | NM HIGHWAY 528; [NAME] | BLVD | NE | PEH |  |  | J | 14 | 4967 | PC | 140721 | 24500 | 2119740 | OUT TO BID | retail
NCOM | 2421 | NM HIGHWAY 528 |  | SE | GS |  |  |  | 14 | 4946 | PC | 140718 | 8365 | 2000000 | OUT TO BID | carwash
RCOM | 1908 | WELLSPRING | AVE | SE |  |  |  |  | 14 | 4730 | AP | 140709 | 1380 | 135944 | TANGLEWOOD CONSTRUCTION | ti - retail
INDAD | 2441 | WESTSIDE | BLVD | SE |  |  |  |  | 14 | 5150 | PC | 140728 | 800 | 26576 | BCL ENTERPRISES INC | park above restroom
OFRE | 4504 | ACE | WY | SE | AR |  |  |  | 14 | 4735 | PC | 140710 | 7500 | 160000 | OUT TO BID
RCOM | 2712 | SOUTHERN | BLVD | SE | U16 | P | 7A |  | 14 | 4902 | AP | 140716 | 296 | 7500 | EMPHASIS CONSTRUCTION
RCOM | 545 | VORTEX | RD | NE | VH4 | C | 3A |  | 14 | 4604 | AP | 140703 | 21155 | 300000 | SDV CONSTRUCTION INC
RCOM | 6080 | ZENITH | CT | NE | BTC | A | 7 |  | 14 | 4546 | AP | 140701 | 7136 | 100000 | CONSTRUCT SOUTHWEST LLC
TCOM | 916 | 2ND | ST | NE | U11 | 3 | 36 |  | 14 | 4721 | AP | 140709 | 144 | 21500 | DATA CELL SYSTEM INC | upgrade
Spreadsheet: 172632d1344277429-looking-up-values-lookup
Sheet: Sheet1

MATERIAL NUMBER | January | February | March | April | May | June | July | August | September | October | November | December
300000
300001
300002
300003
300004
300005
300006
300007
300008
300009
300010
300011
300012
300013
300014
300015
300016
300017
300018
300019
300020
300021
300022
300023
300024
300025
300026
300027
300028
300029
300030
300031
300032
300033
300034
300035
300036
300037
300038
300039
300040
300041
300042
300043
300044
300045
300046
300047
300048
300049
300050
300051
300052
300053
300054
300055
300056
300057
300058
300059
300060
300061
300062
300063
300064
300065
300066
300067
300068
300069
300070
300071
300072
300073
300074
300075
300076
300077
300078
300079
300080
300081
300082
300083
300084
300085
300086
300087
300088
300089
300090
300091
300092
300093
300094
300095
300096
300097
300098
300099
300100
300101
300102
300103
300104
300105
300106
300107
300108
300109
300110
300111
300112
300113
300114
300115
300116
300117
300118
300119
300120
300121
300122
300123
300124
300125
300126
300127
300128
300129
300130
300131
300132
300133
300134
300135
300136
300137
300138
300139
300140
300141
300142
300143
300144
300145
300146
300147
300148
300149
300150
300151
300152
300153
300154
300155
300156
300157
300158
300159
300160
300161
300162
300163
300164
300165
300166
300167
300168
300169
300170
300171
300172
300173
300174
300175
300176
300177
300178
300179
300180
300181
300182
300183
300184
300185
300186
300187
300188
300189
300190
300191
300192
300193
300194
300195
300196
300197
300198
300199
300200
300201
300202
300203
300204
300205
300206
300207
300208
300209
300210
300211
300212
300213
300214
300215
300216
300217
300218
300219
300220
300221
300222
300223
300224
300225
300226
300227
300228
300229
300230
300231
300232
300233
300234
300235
300236
300237
300238
300239
300240
300241
300242
300243
300244
300245
300246
300247
300248
300249
300250
300251
300252
300253
300254
300255
300256
300257
300258
300259
300260
300261
300262
300263
300264
300265
300266
300267
300268
300269
300270
300271
300272
300273
300274
300275
300276
300277
300278
300279
300280
300281
300282
300283
300284
300285
300286
300287
300288
Spreadsheet: 818910d1677121466-how-can-some-number-of-data-be-repeated-again-and-again-keeping-their-order-how-can-some-number-of-data-be-repeated-again-and-again-keeping-their-order
Sheet: Sheet1

Variable Group of Set | Id No. |  | Desired output |  |  | Sets | =Sheet1!$A$2:INDEX(Sheet1!$A:$A,MATCH("zzzzz",Sheet1!$A:$A))
Set-1 | 123456 |  | Set-1
Set-3 | 123457 |  | Set-3
Set-5 | 123458 |  | Set-5
Set-7 | 123459 |  | Set-7
Set-9 | 123460 |  | Set-9
Set-11 | 123461 |  | Set-11
Set-13 | 123462 |  | Set-13
 | 123463 |  | Set-1
 | 123464 |  | Set-3
 | 123465 |  | Set-5
 | 123466 |  | Set-7
 | 123467 |  | Set-9
 | 123468 |  | Set-11
 | 123469 |  | Set-13
 | 123470 |  | Set-1
 | 123471 |  | Set-3
 | 123472 |  | Set-5
 | 123473 |  | Set-7
 | 123474 |  | Set-9
 | 123475 |  | Set-11
 | 123476 |  | Set-13
 | 123477 |  | Set-1
 | 123478 |  | Set-3
 | 123479 |  | Set-5
 | 123480 |  | Set-7
 | 123481 |  | Set-9
 | 123482 |  | Set-11
 | 123483 |  | Set-13
 | 123484 |  | Set-1
 | 123485 |  | Set-3
 | 123486 |  | Set-5
 | 123487 |  | Set-7
 | 123488 |  | Set-9
 | 123489 |  | Set-11
 | 123490 |  | Set-13
 | 123491 |  | Set-1
 | 123492 |  | Set-3
 | 123493 |  | Set-5
 | 123494 |  | Set-7
 | 123495 |  | Set-9
 | 123496 |  | Set-11
 | 123497 |  | Set-13
 | 123498 |  | Set-1
 | 123499 |  | Set-3
 | 123500 |  | Set-5
 | 123501 |  | Set-7
 | 123502 |  | Set-9
 | 123503 |  | Set-11
 | 123504 |  | Set-13
 | 123505 |  | Set-1
 | 123506 |  | Set-3
 | 123507 |  | Set-5