tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 667772d1584480124-reverse-calculation-1-1-bay-reverse-calculation-6sj_test-bench_4
Sheet: Sheet1

 | Purchasing a Property |  | Values entered in yellow cells only
 | Enter Asking Price | 2899999
 | Purchase Price Offer |  |  |  |  | Notes:
 | Property Purchase Tax |  |  | Enter Negotiated Discount Required |  | - The Purchasing a Property table. Works OK
 | Total Purchase Price |  |  | 0 |  | - The Property Purchase Tax calculator places a value in C4 depending on the value in C3. Works OK
 | Legal Fees | 1200 |  |  |  | Problem:
 | Commission | 500 |  |  |  | - The Reverse Calculation table works up to $2,999,999 and gives the correct value in E15
 | Other Expenses | 1000 |  |  |  | At $3,000,000 or more, it returns an erronous value in E15
 | Total Purchase Cost |  |  |  |  | - Does the Reverse Table need an addition to make the Reverse Calculation Table work?
 | Difference |  |  |  |  | Or is it the formula in E15 that needs tweaking?
 | Reverse Calculation table: To find wanted Total Purchase Price
 |  |  | Enter Total Purchase Price required | 2964998.97
 |  |  |  |  |  | .
 |  |  | Negotiated Discount Required
 |  |  | Total Purchase Cost
 | Property Purchase Tax calculator (Calculation only. No entry needed)
 | Up to $2M | $2 to $3M | Over $3M
 | Price | Price | Price
 |  |  |  | Purchase price notes |  |  |  |  | <--Simplified example (Display only)
 |  |  |  | <-1% on first  $200,000
 |  |  |  | <-2% on value from $200,000 to $2,000,000
 | N/A |  |  | <-3% on value over $2,000,000
 | N/A | N/A |  | <-2% on value over $3,000,000
 |  |  |  | <-Total Property Purchase Tax
 | Reverse table. (Calculation only. No entry needed)
 | Price | TaxRate | Price+Tax
 | 0 | 0.01
 | 200000 | 0.02
 | 2000000 | 0.03
 | 3000000 | 0.02
Spreadsheet: 272173d1382252667-need-help-with-formula-left-right-subtitute-extract-number-tuongtu3-201013
Sheet: Sheet1

1 - 4 Hours apr
3 Hours apr
2 - 10 Hours apr
2hrs
6-8 Hours apr
3-7hrs
3-7 hrs
7-11 hrs
4-6 hrs APR
2
2 hrs
ada
xdr
10 hours
6 hour
Spreadsheet: 143698d1330528618-excel-2007-help-with-if-statement-book3
Sheet: Sheet2

 | Date1 | Date2 | Date…
Part One | Qty1 | Qty2 | Date..
 | Date1 | Date2 | Date…
Part Two | Qty1 | Qty2 | Date..
 | Date1 | Date2 | Date…
Part Three | Qty1 | Qty2 | Date..
 | Date1 | Date2 | Date…
Part Four | Qty1 | Qty2 | Date..
 | Date1 | Date2 | Date…
Part Five | Qty1 | Qty2 | Date..
 | Date1 | Date2 | Date…
Part Six | Qty1 | Qty2 | Date..
Spreadsheet: 830848d1685171818-excel-help-for-roulette-hide_selected_rows_lln02
Sheet: Foglio1

Picks | Viable Rows
Spreadsheet: 170719d1343379881-excel-2007-lookup-retunring-multiple-values-new-example-270712-amended
Sheet: WORKSHEET

368786 |  | ABC | <- Enter Engineers Code
373333
373951 | UNIQUE | Down | Day | Calls Attended | Total Work time  (Mins) | Total Work time  (Hrs) | Average work time per Job (Mins) | 1ST SITE VISITED | 2ND SITE VISITED | 3RD site visit | 4th site visit | should be | 5th site visit | should be | 6th site visit | should be
374023 |  | 2011-11-03 00:00:00
374333
374088
374213
374541
374727 |  |  |  |  |  |  |  |  |  |  |  | man |  | not |  | opt
374726
374693
369286
368786
374892
374861
374862
375022
374843
374874
Spreadsheet: 705436d1606128195-vlookup-with-data-validation-vlookup-with-data-validation
Sheet: File 2

 | FILE 2
 | Student | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00
 | A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0
 | B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0
 | C | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0
 | Teacher |  |  | 2020-11-01 00:00:00 |  | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00
 | D | 1 | 0 | 0 | 0 | 0 | 0 |  | 0 | 5 | 5 | 5 | 5 | 5 | 5
 | Gardener |  |  |  |  | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00
 | A | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0
Spreadsheet: 126032d1319483710-add-multiple-columns-with-same-criteria-sum-if-multiple-columns
Sheet: Sheet1

Test A |  |  | Test B |  |  |  | Sum of Test A & B
Day | Impressions |  | Day | Impressions |  |  | Day | Impressions
2009-01-01 00:00:00 | 147 |  | 2009-07-01 00:00:00 | 25 |  |  | 2009-01-01 00:00:00 | 147
2009-01-02 00:00:00 | 279 |  | 2009-07-02 00:00:00 | 15 |  |  | 2009-01-02 00:00:00 | 279
2009-01-05 00:00:00 | 355 |  |  |  |  |  | 2009-01-05 00:00:00 | 355
2009-07-02 00:00:00 | 125 |  |  |  |  |  | 2009-07-01 00:00:00 | 25
 |  |  |  |  |  |  | 2009-07-02 00:00:00
Spreadsheet: 88834d1288663421-formula-to-find-three-different-criteria-and-then-sum-any-matches-sample-spreadsheet
Sheet: Report

JACK | 27 |  | 28 |  | 29 |  | 30 |  | 31 |  | 32 |  | 33 |  | 34 |  | 36 |  | 38 |  | 40 |  | 42 |  | 44 |  | TOTAL
 | $ | OH | $ | OH | $ | OH | $ | OH | $ | OH | $ | OH | $ | OH | $ | OH | $ | OH | $ | OH | $ | OH | $ | OH | $ | OH | $ | OH
LOCATION 1
LOCATION 2
LOCATION 3
TOTAL
Spreadsheet: 797710d1664088799-dynamic-sheet-references-and-aggregation-coop
Sheet: Maps-Coms

Commanders | Own | % | Part | % | Maps | # | % |  | Total games
Raynor |  |  |  |  | Chain of Ascension
Kerrigan |  |  |  |  | Cradle of Death
Artanis |  |  |  |  | Dead of Night
Swann |  |  |  |  | Lock & Load
Zagara |  |  |  |  | Malwarfare
Vorazun |  |  |  |  | Miner Evacuation
Karax |  |  |  |  | Mist Opportunities
[NAME] |  |  |  |  | Oblivion Express
Alarak |  |  |  |  | Part and Parcel
Nova |  |  |  |  | Rifts to Korhal
Stukov |  |  |  |  | Scythe of Amon
Fenix |  |  |  |  | Temple of the Past
Dehaka |  |  |  |  | The Vermillion Problem
Horner |  |  |  |  | Void Launch
Tychus |  |  |  |  | [NAME]
Zeratul
Stetmann
Mengsk
Spreadsheet: 695719d1600361029-sum-function-based-on-2-criteria-sample-file
Sheet: Sheet1

 | Fruits name | Category | Price R1 | Price R2 | Price R3 | Price R4 | Price R5
 | Orange | R1 | 45 | 34 | 34 | 57 | 56
 | Orange | R2 | 6 | 55 | 66 | 89 | 34
 | Orange | R3 | 44 | 66 | 77 | 87 | 34
 | Orange | R4 | 23 | 23 | 45 | 34 | 35
 | Orange | R5 | 45 | 33 | 35 | 33 | 45
 | Apple | R3 | 4 | 5 | 6 | 6 | 55
 | Apple | R5 | 23 | 33 | 44 | 55 | 5 |  |  |  |  | Price
 |  |  |  |  |  |  |  |  |  | My Result should be | Orange | 256
 |  |  |  |  |  |  |  |  |  |  | Apple | 11
Spreadsheet: 852679d1702633043-copy-quantity-for-product-from-one-table-to-another-based-on-unique-id-example
Sheet: Hárok1

ID | Product | Quantity |  | ID | Product | Quantity
1 | AX |  |  | 1 | AX | 11
2 | BX | 0 |  | 3 | CX | 22
3 | CX |  |  | 6 | FX | 33
4 | DX |  |  | 9 | IX | 44
5 | EX | 0 |  | 10 | JX | 55
6 | FX
7 | GX
8 | HX
9 | IX
10 | JX
I need to copy quantity from right table to the left table based on unique ID, if there is no data for ID give 0.
Spreadsheet: 542997d1508191816-bring-premium-when-price-is-above-700-and-ssd-y-also-when-brand-is-apple-and-example-6
Sheet: Sheet1

Units | USD | Brand Cluster | Gaming Y/N | SSD Y/N | New formula
125 | 53144.21806167401 | ASUS | Non Gaming | N
4668 | 1735660.572687225 | Acer | Non Gaming | N
72 | 92106.71806167401 | Dell | Non Gaming | N
348 | 429095.4845814978 | Apple | Non Gaming | N
1 | 1228.799559471366 | Apple | Non Gaming | N
9 | 14700.22026431718 | Apple | Non Gaming | N
3 | 3469.052863436124 | Apple | Gaming | N
1 | 3038.105726872247 | Apple | Non Gaming | Y
55 | 47852.75330396476 | Apple | Non Gaming | N
9 | 16753.19383259912 | Apple | Non Gaming | N
1 | 2286.013215859031 | Apple | Gaming | Y
50 | 26135.84801762115 | Apple | Non Gaming | N
50 | 37402.14757709251 | Apple | Non Gaming | N
753 | 909342.5660792951 | Apple | Non Gaming | N
413 | 581982.7643171806 | Apple | Non Gaming | N
Units | USD | Brand Cluster | Gaming Y/N | SSD Y/N | Pure Premium
1 | 3038.105726872247 | Apple | Non Gaming | Y | Premium
1 | 2286.013215859031 | Apple | Gaming | Y | Not Premium
4 | 6723.348017621145 | ASUS | Gaming | Y | Not Premium |  | What I want to bring in column G:
32 | 58763.05066079295 | ASUS | Gaming | Y | Not Premium |  | Output "Pure Premium" in column F when:
42 | 24244.43832599119 | ASUS | Non Gaming | Y | Premium |  |  | -SSD "Y" and USD/Units =>700
1801 | 1212859.170653908 | Dell | Non Gaming | Y | Premium |  |  | Brand [NAME] is "Apple"
230 | 201450.5506607929 | Acer | Non Gaming | Y | Premium
27 | 21816.62995594714 | Apple | Non Gaming | Y | Premium |  | But if column "Gaming Y/N" is equal to "Gaming" output "Non Premium"
154 | 144003.3039647577 | Apple | Non Gaming | Y | Premium
8 | 4366.079295154185 | Apple | Non Gaming | Y | Premium
Spreadsheet: 842947d1694939325-keyword-search-for-faqs-spreadsheet-faqs
Sheet: How Do I

How Do I - 1 | Answer Question 1
How Do I - 2 | Answer Question 2
How Do I - 3 | Answer Question 3
How Do I - 4 | Answer Question 4
How Do I - 5 | Answer Question 5
How Do I - 6 | Answer Question 6
How Do I - 7 | Answer Question 7
How Do I - 8 | Answer Question 8
How Do I - 9 | Answer Question 9
How Do I - 10 | Answer Question 10
Spreadsheet: 700327d1603133730-filter-with-named-range-criteria-test-with-named-range-criteria
Sheet: Sheet1

 | Employee | Code |  | Output |  | West Coast | East Coast
 | [NAME] | 09.01.01 |  |  |  | 09.01.01 | 09.01.03
 | [NAME] | 09.01.02 |  | [NAME] |  | 09.01.02 | 09.01.04
 | Morgan Freeman | 09.01.03 |  | [NAME]
 | [NAME] | 09.01.02 |  | [NAME] |  | Named Ranges
 | [NAME] | 09.01.01 |  | [NAME] |  | Employee = b3:b10
 | [NAME] | 09.01.04 |  | [NAME] |  | Code = c3:c10
 | [NAME] | 09.01.02 |  |  |  | WestCoast = h3:h4
 | [NAME] | 09.01.01 |  |  |  | EastCoast = i3:i4
Spreadsheet: 285789d1387838953-reference-changing-column-on-specified-cell-report1
Sheet: Report

Measure |  |  | This week | Change | Longer term trend | Trend direction is good when
Rasied |  |  |  |  |  | Falling
% Resolved |  |  |  |  |  | Rising
Outstanding |  |  |  |  |  | Falling
Spreadsheet: 152269d1335320468-appropriate-formula-if-match-yolanda-botha_doc-nr_24apr12_02
Sheet: Sheet2

[NAME] | Cumulative Counts |  |  |  |  | [NAME] | Item | Qty
113
115
Spreadsheet: 0e770e8d-6bcd-4514-a0e1-8554cea9d563
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
GGT | Test | GGT | Gamma-Glutamyltransferase (GGT), Serum | [NAME] (GGT), S | [NAME] | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Serum gel Acceptable: Red top [NAME]: 0.5 mL Additional Information: Patient's age and sex are required. | 0.25 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; Gross reject Other	NA | Males 1-6 years: 7-19 U/L 7-9 years: 9-22 U/L 10-13 years: 9-24 U/L 14-15 years: 9-26 U/L 16-17 years: 9-27 U/L 18-35 years: 9-31 U/L 36-40 years: 8-35 U/L 41-45 years: 9-37 U/L 46-50 years: 10-39 U/L 51-54 years: 10-42 U/L 55 years: 11-45 U/L > or =56 years: 12-48 U/L Reference values have not been established for patients <12 months of age.  Females >1 year: 6-29 U/L Reference values have not been established for patients <12 months of age. | Monday through Sunday Continuously | Same day/1 day | 2 days | 1 | 82977 |  |  |  |  | Rochester
GGT | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
GGT | Result | GGT | [NAME] (GGT), S | [NAME] (GGT), S | Numeric |  |  |  |  | U/L |  |  |  |  |  |  |  |  |  | 2324-2 | Gamma glutamyl transferase:CCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 265986d1379456659-comparing-the-balance-of-a-paypal-account-with-other-numbers-from-the-spreadsheet-model-kits-for-forum
Sheet: All Expenses

DATE | [NAME] | AMOUNT | MEMO
2011-08-10 00:00:00 | The Box Zone | 24.54 | bubble wrap, box
2011-08-13 00:00:00 | The Box Zone | 10.45 | box
2011-08-17 00:00:00 | The Box Zone | 7.65 | box, tape
2011-08-15 00:00:00 | The Box Zone | 10.35 | boxes
2011-07-31 00:00:00 | ebay fees | 8.4
2011-07-17 00:00:00 | ebay fees | 1.48
2011-08-31 00:00:00 | ebay fees | 113.39
 | Staples | 5.51 | Tape and [NAME]
2011-08-29 00:00:00 | [NAME] | 53.29 | Tape, 25 boxes, box cutter
2011-08-31 00:00:00 | [NAME] | 13.3 | boxes
2011-09-06 00:00:00 | [NAME] | 13.77 | boxes
2011-10-03 00:00:00 | [NAME] | 5.18 | boxes
2011-10-03 00:00:00 | ebay fees | 39.11
2011-10-11 00:00:00 | [NAME] | 2.02 | box
Oct. 18 | [NAME] | 26.02 | box, bubble wrap
Oct. 26 | [NAME] | 103.04
Nov. 1 | ebay fees | 140.84
Oct. 19 | Staples | 10.43 | 6 rolls of tape
Nov. 2 | [NAME] | 14.19 | boxes
Nov. 10 | [NAME] | 8.82 | boxes
Nov. 14 | [NAME] | 21.27
Nov. 16 | [NAME] | 20.64
Nov. 23 | [NAME] | 5.36
Dec. 1 | ebay fees | 235.54
Dec. 6 | [NAME] | 70.24 | total of 77 boxes.
Dec. 12 | [NAME] | 10.26
Dec. 30 | ebay fees | 111.27
2012-01-02 00:00:00 | [NAME] | 19.88 | 20 boxes
2012-01-10 00:00:00 | [NAME] | 73.34 | 50 boxes, tape, bubble wrap
Jan. 30 | ebay fees | 237.77
Jan. 18 | [NAME] | 2.34 | 1 box
Feb. 3 | [NAME] | 54.56 | several boxes, bubble wrap
Feb. 29 | ebay fees | 91.92
Mar. 31 | ebay fees | 16.8
Apr. 30 | ebay fees | 38.98
2012-05-31 00:00:00 | ebay fees | 16.8
 | [NAME] | 87.72
 | [NAME] | 3.11
2012-06-30 00:00:00 | ebay fees | 178
2012-06-13 00:00:00 | [NAME] | 2.5
[NAME] 26 | [NAME] | 24.31
Aug. 13 | [NAME] | 60.61 |  | materials
2012-07-31 00:00:00 | ebay fees | 71.55
2012-08-31 00:00:00 | ebay fees | 71.91 |  | ebay fees
2012-09-30 00:00:00 | ebay fees | 5.82
2012-10-31 00:00:00 | ebay fees | 29.38
2012-11-30 00:00:00 | ebay fees | 5.9
2013-07-17 00:00:00 | [NAME] | 54.91 | 16x12x6, tape
 | [NAME] | 55.15 | 21*15*6, bubble wrap
Aug.1, 13 | ebay fees | 117.713 | July fees
2013-08-20 00:00:00 | [NAME] | 46.5 | 12.9.3, 12.9.6, 24.12.6, 29.17.5
2013-08-31 00:00:00 | ebay fees | 184.5
 | TOTAL
Spreadsheet: 670017d1585707748-transfer-values-to-other-cells-transfer-value-to-another-cell
Sheet: Sheet1

99 |  |  | 3 | <--Enter an amount |  | 99 | 89 | 79 | 69 | Display results in columns G to J
89 |  |  | 1 | in colured cells |  | 3 | 1 | 3 | 9
79 |  |  | 3 | only |  | 3 | 2 | 3
69 |  |  | 9
Wanted: Each time a value is added in column D
have the value added to the appropriate column G to J.
A new added value would go to the next cell
and not replace a previous entry.
Example. If I added 3 D1, 1 D2, 3 D3, 9 D4 and 3 D1
2 D2, 3 D3 it woud look like this.
Spreadsheet: 773604d1647953495-how-to-lookup-a-value-with-two-criteria-cars-aligw
Sheet: Sheet1

 |  |  | Price |  |  |  |  | I need a way to select the price for a combination of Year and Item
 |  |  | Item | B21* | F21*
 |  |  | Cars | 1 | 4
 |  |  | Bikes | 2 | 5
 |  |  | Scooters | 3 | 6
 |  |  | Transactios |  |  |  |  | Desired Result
 |  |  | Item | Qty | Year | Price |  | Price
 |  |  | Cars | 10 | B21* |  |  | 1
 |  |  | Bikes | 20 | F21* |  |  | 5
 |  |  | Bikes | 30 | F21* |  |  | 5
 |  |  | Scooters | 40 | F21* |  |  | 6
 |  |  | Bikes | 50 | B21* |  |  | 2
Spreadsheet: 86782d1286757057-two-sheet-calculation-summary-poinsettia-sale-forum-help
Sheet: Detail

Poinsettia Detail
 |  |  | Small |  |  |  |  | Med |  | Large
STUDENT | CUSTOMER NAME | CUSTOMER ADDRESS | R | W | P | J | M | R | W | R | Total
[NAME] | Customer 1 | Address 1 |  |  |  |  |  |  |  | 1
[NAME] | Customer 2 | Address 2 |  |  |  | 1
[NAME] | Customer 3 | Address 3 |  |  |  |  |  |  |  | 2
[NAME] | Customer 4 | Address 4 |  |  |  |  |  | 1
[NAME] | Customer 5 | Address 5 |  |  |  | 4
[NAME] | Customer 6 | Address 6 |  |  |  |  |  | 2
[NAME] | Customer 7 | Address 7 |  |  |  |  | 3
[NAME] | Customer 8 | Address 8 |  |  |  |  |  |  |  | 6
[NAME] | Customer 9 | Address 9 |  |  |  | 3 | 2
[NAME] | Customer 10 | Address 10 |  |  |  | 2
[NAME] | Customer 11 | Address 11 | 4 | 2
[NAME] | Customer 12 | Address 12 |  |  |  | 4 |  | 2 |  | 4
Spreadsheet: 05626337-8313-4800-81bf-3a99bc542983
Sheet: Sheet1

Master Products List (Form MPL-01) Use this form for all organic finished products to be sold by your company.  An accompanying Product Formulation Sheet should be completed for each processed product which you either manufacture or own the formulation for.  If you are distributing product, please use this form to identify each product you are seeking certification for (finished products and by products of processing). | 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
Name of Product as it will be sold (Include varieties) | Brand Name | Name of Copacker/ Supplier of Product or Brand Owner (if you are the copacker) if other than yourself | Certifier of Copacker or supplier | Item is certified and sold under which label category? (mark with X) |  |  |  |  | Item is certified and sold under which certification services? (mark with X)
 |  |  |  | 100% Organic (NOP Only) | Organic | Made With Organic  (NOP Only) | Contains X% Organic (COR &NSF Only) | Less than 70% | NOP | EU | Canada Equivalency | Japan Equivalency | COR | NSF/ANSI 305
Name of Product as it will be sold (Include varieties) | Brand Name | Name of Copacker/ Supplier of Product or Brand Owner (if you are the copacker) if other than yourself | Certifier of Copacker or supplier | Item is certified and sold under which label category? (mark with X) |  |  |  |  | Item is certified and sold under which label certification services? (mark with X)
 |  |  |  | 100% Organic (NOP Only) | Organic | Made With Organic  (NOP Only) | Contains X% Organic (COR &NSF Only) | Less than 70% | NOP | EU | Canada Equivalency | Japan Equivalency | COR | NSF/ANSI 305
Spreadsheet: 489516d1479307323-custom-list-based-on-value-fifa-17
Sheet: Lineup

Position | #1 | Age | Overall | Potential
GK | Sels
CB | Yedlin
CB | Mbemba
RB | Lascelles
LB | Lazaar
CM | Shelvey
CM | Tiote
CM | [NAME]
W | Aarons
W | Gayle
ST | Mitrovic
Spreadsheet: 90170d1289931183-cannot-get-formulas-to-populate-a-protected-worksheet-when-inserting-rows-bcs-scope-list-template
Sheet: Building12

Building12
 | Reference No. | Year | Priority | BCS Reference | Items | Existing Conditions | Recommendations | New Const. | Additions | Alteration | Major Systems | Major Repair | Energy | Bond | Capital | Estimated Cost with Incidental
 |  | SITE ISSUES
 |  | ARCHITECTURAL ISSUES
 |  | MECHANICAL ISSUES
 |  | PLUMBING ISSUES
 |  | ELECTRICAL ISSUES
Spreadsheet: 544607d1508955957-match-error-with-dates-match-error-with-dates
Sheet: Sheet1

Month/Year | Score |  | reference month/year | match function |  | formula | match type
2017-01-01 00:00:00 | 0 |  | 2017-01-01 00:00:00 |  |  | =MATCH(D2,A2:B13,0) | 0
2017-02-01 00:00:00 | 39.5 |  | 2017-02-01 00:00:00 |  |  | =MATCH(D3,$A$2:$B$13,1) | 1
2017-03-01 00:00:00 | 61.4 |  | 2017-03-01 00:00:00 |  |  | =MATCH(D4,$A$2:$B$13) | [NAME]
2017-04-01 00:00:00 | 77.5 |  | 2017-04-01 00:00:00
2017-05-01 00:00:00 | 50.25 |  | 2017-05-01 00:00:00
2017-06-01 00:00:00 | 54.2 |  | 2017-06-01 00:00:00
2017-07-01 00:00:00 | 38 |  | 2017-07-01 00:00:00
2017-08-01 00:00:00 | 27 |  | 2017-08-01 00:00:00
2017-09-01 00:00:00 | 69 |  | 2017-09-01 00:00:00
2017-10-01 00:00:00 | 50 |  | 2017-10-01 00:00:00
2017-11-01 00:00:00 | 40 |  | 2017-11-01 00:00:00
2017-12-01 00:00:00 | 68 |  | 2017-12-01 00:00:00
Spreadsheet: 737289d1624339940-cumulative-present-value-in-a-single-function-question_a
Sheet: Sheet1

 | 201901
Amt | 310000
Interest rate | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05
PV(Amt)
Spreadsheet: 76491d1277048776-index-match-all-rows-from-sheet1-to-sheet2-columns-lookingfor
Sheet: Sheet1

Code | Value | Type 1 Order | Type 2 Order | Type 3 Order | Type 4 Order
AM | 221 | 7 |  |  | 2
AX | 227 |  |  | 2
AM | 123 | 999 | 2
AM | 229 | 5 | 1
AM | 231 | 1
ax | 134 |  |  | 1
am | 2345 | 3 |  |  | 1
ax | 247
ay | 247
zz | 247
AM | 247 |  | 3
AM | 247 | 4
Spreadsheet: 746456d1630718892-add-two-more-criteria-to-index-match-min-formula-used-for-finding-nearest-points-example2
Sheet: Utility Connectors

Available Services
[NAME] | Utility Name | Utility Connector # | Connector location
 |  |  | X | Y
2 | GAS1 | 1-2-A-GAS1-01 | 4506 | 5235
2 | GAS1 | 1-2-A-GAS1-08 | 4506 | 5808
3 | GAS1 | 1-3-A-GAS1-01 | 4506 | 5903
2 | GAS2 | 1-2-A-GAS2-08 | 4535 | 4758
3 | GAS2 | 1-3-A-GAS2-01 | 4535 | 4662
2 | GAS3 | 1-2-A-GAS3-08 | 4535 | 3605
3 | GAS3 | 1-3-A-GAS3-01 | 4535 | 3536
3 | GAS3 | 1-3-A-GAS3-02 | 4535 | 3518
3 | GAS3 | 1-3-A-GAS3-03 | 4535 | 3499
3 | GAS3 | 1-3-A-GAS3-04 | 3798 | 5135
2 | GAS4 | 1-2-A-GAS4-08 | 3798 | 5518
3 | GAS4 | 1-3-A-GAS4-01 | 3798 | 5539
3 | GAS4 | 1-3-A-GAS4-02 | 3798 | 5615
3 | GAS4 | 1-3-A-GAS4-03 | 3798 | 5636
3 | GAS4 | 1-3-A-GAS4-04 | 3798 | 5711
2 | [NAME] | 1-2-A-GAS5-08 | 3798 | 6094
3 | [NAME] | 1-3-A-GAS5-01 | 3798 | 6114
2 | GAS7 | 1-2-A-GAS7-02 | 3798 | 4768
3 | GAS7 | 1-3-A-GAS7-04 | 3798 | 4216
Spreadsheet: 709301d1608239036-text-on-value-field-but-including-blank-spaces-conditional-formatting-on-pivot-table-showing-text-in-values-area-alaztor-
Sheet: What i need

POS | Type A | Type B | Type C | Type D
Point 1 | Need Upgrade
Point 10 |  | Needs Renovation
Point 11
Point 2
Point 3
Point 4 |  |  |  | Need Upgrade
Point 5 | Needs Renovation
Point 6 | Buy new one
Point 7 |  |  |  | Buy new one
Point 8 |  | Needs Renovation
Point 9 |  |  | Buy new one
Spreadsheet: 160281d1339024358-how-to-combine-if-statement-in-offset-function-please-help-timesheet-upload-1
Sheet: Task

Name: | Short List: | Full List:
A.K | Process Month End | Emails (Inquiries/Questions)
A.K | Monitor Bank Accounts | Monitor Bank Accounts
A.K | Process Recovery | Process Month End
A.K | Emails (Inquiries/Questions) | Process Recovery
A.K | Complete OOS | Complete OOS
A.K | Full List | Reconcilliation
A.K |  | Revenue
A.K |  | Task for A.K 08
A.K |  | Task for A.K 09
A.K |  | Task for A.K 10
A.K |  | Task for A.K 11
A.K |  | Task for A.K 12
A.K |  | Task for A.K 13
A.K |  | Task for A.K 14
A.K |  | Task for A.K 15
A.K |  | Task for A.K 16
A.K |  | Task for A.K 17
A.K |  | Task for A.K 18
A.K |  | Task for A.K 19
A.K |  | Task for A.K 20
A.K |  | Task for A.K 21
M.C | Task for M.C 01 | Task for M.C 01
M.C | Task for M.C 08 | Task for M.C 02
M.C | Task for M.C 12 | Task for M.C 03
M.C | Task for M.C 14 | Task for M.C 04
M.C | Task for M.C 16 | Task for M.C 05
M.C | Full List | Task for M.C 06
M.C |  | Task for M.C 07
M.C |  | Task for M.C 08
M.C |  | Task for M.C 09
M.C |  | Task for M.C 10
M.C |  | Task for M.C 11
M.C |  | Task for M.C 12
M.C |  | Task for M.C 13
M.C |  | Task for M.C 14
M.C |  | Task for M.C 15
M.C |  | Task for M.C 16
M.C |  | Task for M.C 17
M.C |  | Task for M.C 18
M.C |  | Task for M.C 19
M.C |  | Task for M.C 20
M.C |  | Task for M.C 21
T.G | Task for T.G 4 | Task for T.G 01
T.G | Task for T.G 6 | Task for T.G 02
T.G | Task for T.G 12 | Task for T.G 03
T.G | Task for T.G 15 | Task for T.G 04
T.G | Task for T.G 19 | Task for T.G 05
T.G | Full List | Task for T.G 06
T.G |  | Task for T.G 07
T.G |  | Task for T.G 08
T.G |  | Task for T.G 09
T.G |  | Task for T.G 10
T.G |  | Task for T.G 11
T.G |  | Task for T.G 12
T.G |  | Task for T.G 13
T.G |  | Task for T.G 14
T.G |  | Task for T.G 15
T.G |  | Task for T.G 16
T.G |  | Task for T.G 17
T.G |  | Task for T.G 18
T.G |  | Task for T.G 19
T.G |  | Task for T.G 20