tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 6e9b82c6-4431-4e0e-8f5b-afe6f3afabe6
Sheet: Sheet1

Unnamed: 0 | 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
 |  |  |  |  | [NAME]
CLASSIFICA GENERALE [NAME]2011 |  |  |  |  | ACCESSO AL MASTER FINALE
Class. | [NAME] | Punti | Lecce 29-05-11 | Lecce 05-06-11 | Manfredonia 19-06-2011 | Brindisi 26-06-2011 | Barletta 03-07-11 | Lecce 10-07-11 | mete | Lecce 29-05-11 | Lecce 05-06-11 | Manfredonia 19-06-2011 | Brindisi 26-06-2011 | Barletta 03-07-11 | Lecce 10-07-11
1 | Bar Belleville Team | 78.8 | 19.4 | 19.4 | 20 | 20 |  |  | 145 | 37 | 48 | 35 | 25
2 | [NAME] | 62.92 | 18 | 16.92 | 18 | 10 |  |  | 103 | 29 | 40 | 17 | 17
3 | [NAME] | 57.97000000000001 | 7.76 | 14.55 |  | 17.46 | 18.2 |  | 51 | 13 | 34 |  | 28
4 | Bari Beach Rugby Team | 43.65 | 14.1 |  | 14.55 |  | 15 |  | 49 | 31 |  | 18
5 | I Villani | 28 | 10 | 10 |  | 8 |  |  | 51 | 10 | 24 |  | 17
6 | [NAME] del Greco | 24.7 |  |  | 0 | 15 | 9.7 |  | 16 |  |  |  | 30
7 | Draghi di Mare | 24.64 | 6 |  | 10 | 3 | 5.64 |  | 23 | 8 |  | 12 | 3
8 | Diesse Foggia | 14.48 |  |  | 6.72 |  | 7.76 |  | 9 |  |  | 16
9 | [NAME] | 14 | 4 | 6 |  | 4 |  |  | 16 | 5 | 6 |  | 5
10 | Lions Bitritto | 11.64 |  | 3 | 5.64 |  | 3 |  | 17 |  | 9 | 8
11 | [NAME] | 7.28 |  | 7.28 |  |  |  |  | 16 |  | 16
12 | [NAME] | 6.88 | 3 | 3.88 |  |  |  |  | 11 | 4 | 7
13 | Cozzari Neri Brindisi | 6 |  |  |  | 6 |  |  | 0 |  |  |  | 9
14 | [NAME] | 4 |  |  |  |  | 4 |  | 0
15 | Gli Arrefolati | 0 |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 137 | 184 | 106 | 134 | 0 | 0 | 561
Spreadsheet: 746285d1630604991-let-function-with-nested-filter-function-sample-workbook-loan-sheet
Sheet: Sample Sheet

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Goal: Return PMT in month given loan ID, If PMT is ACH return 0 value
 |  |  | Loan ID |  |  | NPER Remng |  |  | Loan Amount | Principal Balance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Category | 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
 |  |  | 1 |  |  |  |  |  | 100000 | 97045 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DH Principal
 |  |  | 1 |  |  |  |  |  | 100000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DH Interest
 |  |  | 1 |  |  |  |  |  | 100000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DH Fee's
 |  |  | 1 |  |  |  |  |  | 100000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QB PMT
 |  |  | 1 |  |  |  |  |  | 100000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other
 |  |  | 1 |  |  |  |  |  | 100000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QB End Principal
 |  |  | 1 |  |  |  |  |  | 100000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | End Principal Balance
 |  |  | 1 |  |  |  |  |  | 100000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | End Interest Balance
Spreadsheet: 139739d1328429608-fetch-value-of-a-cell-if-its-row-contain-a-value-0-sales_record_my_doubt-pending-cash
Sheet: Reports

 | Customer ID | Customer Name | Net [NAME] | Cash Recived | Cash Pending | No of Candy Pack Sold | Returned Candy Packs | no of sales visit made | no of times the candy packs returned
Spreadsheet: 3de0ae58-01cc-44ae-9984-8e695d44b088
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
BCGRV | Test | BCGRV | [NAME], Varies | [NAME], V | Genomic DNA Extracted Followed by Polymerase Chain Reaction (PCR) (PCR is used pursuant to a license agreement with Roche Molecular Systems, Inc. and InvivoScribe Technologies) | Varies: Var |  |  |  |  | Forms: Hematopathology Patient Information Sheet (Supply T676) in Special Instructions  Body fluid or spinal fluid must arrive within 96 hours of collection.  Submit only 1 of the following specimens:  Specimen Type: Body fluid Container/Tube: Sterile container [NAME]: At least 5 mL Collection Instructions: 1. If the volume is large, pellet cells prior to sending. 2. Send less volume at ambient temperature or as a frozen cell pellet. Specimen Stability Information: Body Fluid: Ambient/Refrigerated/Frozen Cell Pellet: [NAME]-embedded bone marrow aspirate clot Container/Tube: Paraffin block Specimen Stability Information: Ambient/Refrigerated  Specimen Type: [NAME] tissue Container/Tube: Plastic container [NAME]: 100 mg Collection Instructions: Freeze tissue within 1 hour of collection. Specimen Stability Information: Frozen  Specimen Type: Paraffin-embedded tissue Container/Tube: Paraffin block Specimen Stability Information: Ambient/Refrigerated  Specimen Type: Spinal fluid Container/Tube: Sterile vial [NAME]: 5-10 mL Specimen Stability Information: Ambient/Refrigerated/Frozen  Specimen Type: Extracted DNA from blood or bone marrow Container/Tube: 1.5- to 2-mL tube with indication of volume and concentration of DNA [NAME] Volume: Entire specimen Collection Instructions: Label specimen as extracted DNA from blood or bone marrow Specimen Stability Information: Refrigerated/Ambient | Body Fluid or Spinal Fluid: 1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK-place on ice-note to lab Lipemia	NA Icterus	NA Other	Bone marrow biopsies, slides, or paraffin shavings | An interpretive report will be provided. | Monday through Friday | 7 days | 14 days |  | Profile |  |  |  |  | Rochester
BCGRV | [NAME] | VARIES | Varies |  |  |  | See instructions
BCGRV | Order Question | MP017 | Specimen: |  | Plain Text
BCGRV | Result | MP017 | Specimen: | Specimen: | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
BCGRV | Result | 19915 | Final Diagnosis: | Final Diagnosis: | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34574-4 | Path report.final diagnosis:Imp:Pt:[NAME]:Nom:
BCGRV | Billing Component | BCGRV |  | IGH GENE REARRANGE AMP METH |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 81261
BCGRV | Billing Component | BCGRV |  | IGK REARRANGEABN CLONAL POP |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 81264
Spreadsheet: 78136d1278554245-average-percentage-average97-03
Sheet: Grade

A | B | C | Total | Failed | Grade
4 | 2 | 1 | 7 | 4 | 0.4285714285714285
13 | 2 | 2 | 17 | 0 | 1
6 | 0 | 0 | 6 | 1 | 0.8333333333333334
31 | 6 | 4 | 41 | 17 | 0.5853658536585366
54 | 10 | 7 | 71 | 22 | 0.6901408450704225
 |  |  | 71 |  | 0.7118176538908246
Spreadsheet: 226406d1365404709-copy-and-paste-multiple-selection-book1
Sheet: Sheet1

case number | favorite color | age | gender
1 | red | 1 | 2
2 | green
3 | blue
4 | blue
5 | blue
6 | blue
7 | blue
8 | blue
9 | blue
10 | blue
11 | red | 1 | 2
12 | blue
13 | blue
14 | blue
15 | blue
16 | blue
17 | red | 1 | 2
18 | blue
19 | blue
20 | blue
21 | blue
22 | blue
23 | blue
24 | blue
25 | blue
26 | red | 1 | 2
27 | blue
28 | blue
29 | blue
30 | blue
31 | blue
32 | blue
33 | blue
34 | blue
35 | blue
36 | blue
37 | blue
38 | green
39 | blue
40 | blue
41 | blue
42 | blue
43 | blue
44 | blue
45 | blue
46 | blue
47 | blue
48 | blue
49 | green
50 | blue
Spreadsheet: 171402d1343719551-look-up-using-2-variables-look-up-using-multiple-variable
Sheet: Sheet1

Account | Amount | Cost Center |  | Result in Amount Column |  |  | Look Up table
5000001 |  | 1706100001 |  | 15771.14
5000001 |  | 1706100002 |  | 20254.73 |  |  | Account | Cost Center | Amount
5000001 |  | 1506100650 |  | 8221.82 |  |  | 2200001 |  | -40605.03
5020001 |  | 1706100001 |  | 243.15 |  |  | 2206003 |  | -1078.7
5020001 |  | 1506100650 |  | 154.45 |  |  | 2219013 |  | -17803.96
5020001 |  | 1706100002 |  | 835.55 |  |  | 2219999 |  | -1233.15
2219999 |  |  |  | -1233.15 |  |  | 5000001 | 1506100650 | 499.4
2219999 |  |  |  | BLANK, not #N/A value |  |  | 5000001 | 1506100650 | 7722.42
2206003 |  |  |  | -1078.7 |  |  | 5000001 | 1706100001 | 15771.14
2200001 |  |  |  | -40605.03 |  |  | 5000001 | 1706100002 | 20254.73
2219013 |  |  |  | -17803.96 |  |  | 5010001 | 1706100001 | 8520
5010001 |  | 1706100001 |  | 8520 |  |  | 5010001 | 1706100002 | 6720
5010001 |  | 1706100002 |  | 6720 |  |  | 5020001 | 1506100650 | 154.45
 |  |  |  |  |  |  | 5020001 | 1706100001 | 243.15
 |  |  |  |  |  |  | 5020001 | 1706100002 | 835.55
2 lookup variables- Account and Cost center
Spreadsheet: 870302d1716841036-can-anyone-tell-what-mistake-i-am-doing-in-my-formulas-given-in-the-sample-file-sample-file
Sheet: Table 11

कार्यक्रम PROGRAM |  |  | पदोन्नति पूर्य प्रतिक्षण – र्ेिनमान –I से र्ेिनमान –II (अ.तप.र्/सामान्य पीडब्ल्यूडी) PRE-PROMOTION TRAINING Scale-I to II (OBC & Gen PWD) | PROG CODE
 |  |  |  | AIT 0114
तर्षर् समूह/ SUBJECT GROUP |  |  | HR, MARKETING, CUSTOMER SERVICE & COMPLIANCE
उद्देश्य/OBJECTIVE |  |  | TO REINFORCE KNOWLEDGE AND EMPOWER THE CANDIDATES TO   COME   OUT   WITH   BETTER   PERFORMANCE   IN   THE PROMOTION PROCESS
लतक्षि समूह/TARGET GROUP |  |  | Scale-I from OBC and Gen-PWD Category
अर्तध/DURATION |  |  | 5 DAYS
DAY | SESSION | CONTENTS
Day 1 | I | All Deposit products - CASA, Term Deposits
 | II | General Banking – Safe Deposit Locker, Taxes
 | III | Death Claim, Staff Matter, OSC, ISC, OBC, Bills, SL, SA, BAA
 | IV | Legal Aspects - NI Act, BR Act, Contract Act
Day 2 | I | Priority Sector - Classifications, Guidelines
 | II | Govt. Sponsored Schemes
 | III | Agriculture Lending
 | IV | Advances & Credit Policy
Day 3 | I | Advances - Balance Sheet and Case studies
 | II | Advances - Delegation of powers
 | III | Foreign Exchange - Deposits, FEMA - Exports, Imports, [NAME] and Outward Remittances
 | IV | Advances & Consortium/MBF/SYD/BP & Inspection Policy
Day 4 | I | Advances - Working Capital, Bank Guarantees & Inland LC
 | II | Advances & Term Loan/LHV and other schemes
 | III | Basel Norms, Risk Management
 | IV | Retail Lending Products, MSME Products
Day 5 | I | NPA & Recovery, IRAC Norms & Provisioning
 | II | Digital Products - Alternate Delivery channels
 | III | Official Language
 | IV | Tips for Interview, Valediction
Spreadsheet: 0de2f7f6-799c-420a-a0b2-c33356dd0364
Sheet: Sheet1

Building Trust -- One [NAME] at a Time | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
[NAME], [NAME], and [NAME]
Experimental Data
Baseline |  |  | Endownment Control |  |  | [NAME]
Amount Sent | [NAME] |  | Amount Sent | [NAME] |  | [NAME] | Amount Sent | [NAME]
0 | 0 |  | 0 | 0 |  | 1 | 0 | 0
0 | 0 |  | 0 | 0 |  | 1 | 0 | 0
0 | 0 |  | 0 | 0 |  | 1 | 0 | 0
0 | 0 |  | 0 | 0 |  | 1 | 0 | 0
0 | 0 |  | 0 | 0 |  | 1 | 3 | 0
0 | 0 |  | 0 | 0 |  | 1 | 5 | 0
0 | 0 |  | 0 | 0 |  | 1 | 5 | 0
0 | 0 |  | 0 | 0 |  | 1 | 5 | 0
2 | 2 |  | 0 | 0 |  | 1 | 5 | 0
3 | 4 |  | 0 | 0 |  | 1 | 8 | 0
4 | 0 |  | 0 | 0 |  | 1 | 9 | 5
4 | 2 |  | 5 | 0 |  | 1 | 10 | 0
4 | 2 |  | 5 | 0 |  | 1 | 10 | 0
4 | 6 |  | 5 | 5 |  | 1 | 10 | 10
4 | 8 |  | 5 | 0 |  | 1 | 10 | 8
5 | 0 |  | 6 | 2 |  | 1 | 10 | 10
5 | 6 |  | 7 | 0 |  | 1 | 10 | 10
6 | 9 |  | 10 | 5 |  | 1 | 10 | 10
6 | 12 |  | 10 | 10 |  | 1 | 10 | 5
7 | 8 |  | 10 | 0 |  | 1 | 10 | 10
9 | 7 |  | 10 | 10 |  | 1 | 10 | 5
10 | 0 |  | 10 | 0 |  | 1 | 10 | 0
10 | 0 |  | 10 | 15 |  | 1 | 10 | 0
10 | 0 |  | 10 | 5 |  | 1 | 10 | 10
10 | 0 |  | 10 | 0 |  | 1 | 10 | 10
10 | 0 |  | 10 | 10 |  | 1 | 10 | 0
10 | 5 |  |  |  |  | 0 | 0 | 0
10 | 5 |  |  |  |  | 0 | 0 | 0
10 | 10 |  |  |  |  | 0 | 0 | 0
10 | 15 |  |  |  |  | 0 | 2 | 0
10 | 20 |  |  |  |  | 0 | 2 | 2
10 | 20 |  |  |  |  | 0 | 6 | 0
10 | 20 |  |  |  |  | 0 | 10 | 20
 |  |  |  |  |  | 0 | 10 | 0
 |  |  |  |  |  | 1=gift given, 0=no gift
Spreadsheet: 772442d1647275682-not-sure-if-formula-or-code-required-drawing-data-across-sheets-with-cell-value-dependency-test-draft
Sheet: .

1 |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
TOTAL HRS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SPARE |  | SPARE |  | TOTAL HRS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL HRS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL HRS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL HRS
 |  |  |  |  | DG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAN
Spreadsheet: 105823d1303123957-dynamic-vlookup-again-dyn_v_lookup
Sheet: Register

 |  | September |  |  |  |  |  | October
 | 2011-09-05 00:00:00 | 2011-09-06 00:00:00 | 2011-09-07 00:00:00 | 2011-09-08 00:00:00 | 2011-09-09 00:00:00 | Totals | 2011-10-03 00:00:00 | 2011-10-04 00:00:00 | 2011-10-05 00:00:00 | 2011-10-06 00:00:00 | 2011-10-07 00:00:00 | Totals
[NAME] | 1 | 1 | 0 | 1 | 0 |  | 1 | 1 | 0 | 0 | 1
[NAME] | 1 | 0 | 1 | 1 | 1 |  | 1 | 0 | 1 | 1 | 1
[NAME] | 1 | 1 | 0 | 0 | 0 |  | 1 | 1 | 0 | 0 | 1
Spreadsheet: 65542d1266268036-cell-reference-example1
Sheet: Sheet1

 |  |  |  |  |  |  |  | Item # | Target |  | Oct 07 | Nov 07 | Dec 07 | Jan 08 | Feb 08 | [NAME] 08 | Apr 08 | May 08 | Jun 08 | Jul 08 | Aug 08 | Sep 08 | Oct 08 P1Y09 | Nov 08 P2Y09 | Dec 08 P3Y09 | Jan 09 P4Y09 | Feb 09 P5Y09 | Mar 09 P6Y09 | Apr 09 P7Y09 | May 09 P8Y09 | Jun 09 P9Y09 | Jul 09 P10Y09 | Aug 09 P11Y09 | Sep 09 P12Y09 | Oct 09 P01Y10 | Nov 09 P02Y10 | Dec 09 P03Y10 | Jan 09 P04Y10 |  |  |  |  |  | NOTES |  |  | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1
 |  |  |  |  |  |  |  | 4.3 | >94% | 0.94 |  |  |  | 0.07043650793650794 | 0.3898809523809524 | 0.8928571428571428 | 0.9952380952380953 | 0.9938271604938271 | 0.5059523809523809 | 0.5726190476190476 | 0.8705357142857143 | 0.3708 | 0.4607 | 0.5086 | 0.5225 | 0.5854 | 0.7961 | 0.9464 | 0.9828 | 0.9136 | 0.9762 | 0.9559 | 0.9252 | 0.9383 | 0.9642 | 0.8475 | 0.8965 | 0.927 | Y | I | n | n |  |  | Y |  | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 4.4 | 0.98 | 0.98 |  |  |  | 0.5060881691223841 | 0.6616 | 0.627 | 0.7204 | 0.7168 | 0.7277 | 0.6265 | 0.6117 | 0.5566 | 0.6016 | 0.5195 | 0.5055 | 0.5197 | 0.8077 | 0.8922 | 0.9407 | 0.9687 | 0.9654 | 0.9522 | 0.9848 | 0.9726 | 0.9972 | 0.9839 | 0.9744 | 0.984 | Y |  | n | n |  |  | Y |  | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0
 |  |  |  |  |  |  |  |  | 0.02 | 0.02 |  |  |  |  | 0.057 | 0.048 | 0.072 | 0.092 | 0.072 | 0.076 | 0.071 | 0.053 | 0.051 | 0.064 | 0.057 | 0.047 | 0.05 | 0.032 | 0.024 | 0.022 | 0.017 | 0.019 | 0.012 | 0.017 | 0.01 | 0.016 | 0.019 | 0.014 | N |  | y |  |  |  | N |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  | 4.4 | 0.95 | 0.95 |  |  |  | 0.814046007369374 | 0.8814989714850582 | 0.850837462969952 | 0.9013490540928736 | 0.8905012783082142 | 0.9093605357775864 | 0.9026937950937951 | 0.8737451537433156 | 0.8686 | 0.874 | 0.8536 | 0.8499 | 0.86 | 0.8895 | 0.9068 | 0.9155 | 0.9496 | 0.9271 | 0.9612 | 0.9632 | 0.9677 | 0.9742 | 0.9816 | 0.9776 | 0.9693 | Y |  | y |  |  |  | Y |  | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | These are the formulas that I would like to reference the latest 6 months
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | When I insert a new month I will insert it between AM and AN |  |  |  |  |  |  |  |  | when I insert the new month.
Spreadsheet: 0e5d9d1b-1955-4fe3-bdea-d30855e343d7
Sheet: Sheet1

Primer/Mother Culture Dosage | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Milk Volume |  | Culture Dose (ounces) |  |  | Culture Dose (ml)
(enter value) |  | 0.01 | 0.015 | 0.02 | 0.01 | 0.015 | 0.02
Gallons (U.S.) |  | 0 | 0 | 0 | 0 | 0 | 0
Ounces |  | 0 | 0 | 0 | 0 | 0 | 0
Liters |  | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 788955d1658822730-index-function-with-variable-columns-excel-forum
Sheet: Tabelle1

20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
Spreadsheet: 185852d1349863155-finding-earliest-date-time-test-for-salary
Sheet: Sheet1

 |  |  | Weekday | Hours on site |  | Month Day | Earliest Start Time
 |  |  |  |  |  | 01
 |  |  |  |  |  | 02
 |  |  |  |  |  | 03
 |  |  |  |  |  | 04
 |  |  |  |  |  | 05
 |  |  |  |  |  | 06
 |  |  |  |  |  | 07
 |  |  |  |  |  | 08
 |  |  |  |  |  | 09
 |  |  |  |  |  | 10
 |  |  |  |  |  | 11
 |  |  |  |  |  | 12
 |  |  |  |  |  | 13
 |  |  |  |  |  | 14
 |  |  |  |  |  | 15
 |  |  |  |  |  | 16
 |  |  |  |  |  | 17
 |  |  |  |  |  | 18
 |  |  |  |  |  | 19
 |  |  |  |  |  | 20
 |  |  |  |  |  | 21
 |  |  |  |  |  | 22
 |  |  |  |  |  | 23
 |  |  |  |  |  | 24
 |  |  |  |  |  | 25
 |  |  |  |  |  | 26
 |  |  |  |  |  | 27
 |  |  |  |  |  | 28
 |  |  |  |  |  | 29
 |  |  |  |  |  | 30
 |  |  |  |  |  | 31
Spreadsheet: 107279d1304473660-excel-2007-need-help-excel-07-tallying-the-number-of-a-specific-value-example
Sheet: PromoCodes

Promo Code | COUNT
Rental - 39 Month 12 PPU 2 Free | 0
Rental - 39 Month Opt Out 12 PPU 2 Free | 3
Rental - 52 Month 12 PPU 4 Free | 9
Rental - 39 Month 3 Free 900/1490 MMP | 3
Rental - Right to Buy | 1
Rental - Fixed MMP | 1
Rental - Device upgrade | 14
Rental - Purchase Option - Non Validation | 3
Rental - Purchase Option - Validation | 2
Rental - Standard Cube - Non Validation | 0
Rental - Standard Cube - Validation | 0
Rental - Corp Acct Negotiated | 19
Rental - Non Standard | 9
[NAME] | 96
[NAME] Price | 1
[NAME] | 19
[NAME] Adopter 200Tx | 0
[NAME] P200MA | 8
[NAME] Upgrade | 7
[NAME] | 13
[NAME] | 5
Renewal - Current Pricing | 0
Renewal - Standard Cube | 0
Renewal - DI Save $900 MMP Promo | 1
Renewal - Corp Acct Negotiated | 1
Renewal - Non Standard | 1
Rental - VSP 2 Free Months | 1
Rental - VSP 3 Free Months | 0
Rental - VSP 4 Free Months | 0
Rental - VSP Non Validation | 0
Rental - VSP Right to Buy | 1
Rental - VSP Validation | 0
Renewal - VSP | 0
Rental - Canada Group | 0
School Agreement | 1
DEA or Trial Site | 1
Rental - 2 Free Months | 1
Rental - 3 Free Months | 0
Rental - 4 Free Months | 0
FMP15SMART | 0
[NAME] | 0
FMP22SMART | 0
FMPBSCAN | 0
2YRPAC | 0
4YR22SMART | 0
3YR19SMART | 0
CAP19SMART | 6
CAP22SMART | 2
SERVICE15SMART | 0
Spreadsheet: 5ee3c2bb-d657-4e93-9a59-97c51ef596ec
Sheet: WithPerformance

Combined Bidder Activity Summary Report - April 2013  (Projects bid opened from July 2011 to April 2013, as of [NAME])
Bid Month-YR | Engineer's Estimate | [NAME] | Low Bid vs. EE | Avg. Number of Bidders | Number of Projects Bid Opened | No. of  Projects Under 10% of EE | No. of Projects in ±10% of EE | No. of Projects Over 10% of EE | No. of Projects Within 110% of EE | Percent of  Projects Within ±10% of EE
2011-07-15 00:00:00 | 20365047.05 | 21732970.35 |  | 4.538461538461538 | 13 | 4 | 4 | 5
2011-08-11 00:00:00 | 50010372.81 | 43611191.31 |  | 5 | 21 | 12 | 6 | 3
2011-09-11 00:00:00 | 166458271.63 | 138598077.46 |  | 6.047619047619047 | 21 | 10 | 8 | 3
2011-10-11 00:00:00 | 219152331.31 | 179743459.68 |  | 6.842105263157895 | 38 | 23 | 10 | 5
2011-11-11 00:00:00 | 507700888.35 | 412641487.18 |  | 6.617647058823529 | 34 | 17 | 14 | 3
2011-12-11 00:00:00 | 628320975.9200001 | 552787816.56 |  | 6.461538461538462 | 26 | 14 | 4 | 8
2012-01-12 00:00:00 | 221129881.74 | 184092542.87 |  | 6.90625 | 32 | 13 | 14 | 5
2012-02-12 00:00:00 | 331587021.28 | 245894057.94 |  | 7.319148936170213 | 47 | 22 | 20 | 5
Mar-12 | 276250184.97 | 237008591.52 |  | 6.863636363636363 | 66 | 35 | 24 | 7
2012-04-12 00:00:00 | 264959292.74 | 218489949.23 |  | 5.392857142857143 | 84 | 41 | 33 | 10
*May-12 | 219373727.52 | 211766315.17 |  | 5.223404255319149 | 94 | 46 | 34 | 14
2012-06-12 00:00:00 | 106973675.14 | 97462593.67 |  | 6.133333333333334 | 15 | 6 | 5 | 4
Jul 11 to Jun 12
*Jul-12 | 324344704.51 | 282565669.1 |  | 5.571428571428571 | 28 | 15 | 9 | 4
*Aug-12 | 376864727.33 | 330869927.37 |  | 5.8 | 25 | 14 | 7 | 4
Sep-12 | 510608479.65 | 462439555.66 |  | 5.882352941176471 | 34 | 17 | 16 | 1
*Oct-12 | 785008092.5600001 | 706904634.4399998 |  | 5.659090909090909 | 44 | 15 | 21 | 8
*Nov-12 | 205996003.5 | 183958134.77 |  | 6.1 | 31 | 14 | 14 | 3
2012-12-12 00:00:00 | 94032650.61 | 87269637.62 |  | 7.5 | 20 | 7 | 10 | 3
*Jan-13 | 115138540.42 | 105448137.6 |  | 8.1875 | 32 | 15 | 12 | 5
*Feb-13 | 65311825.09 | 62882211.9 |  | 7.513513514 | 37 | 9 | 24 | 4
*Mar-13 | 87355042.32 | 81149458.74 |  | 6.431818182 | 44 | 18 | 21 | 5
2013-04-01 00:00:00 | 125885500.15 | 121188659.05 |  | 5.40789 | 76 | 26 | 37 | 13
Jul 12 to April 13
Total
Note: 1) "*", numbers may be different from that in the previous report due to bid rank change(s); 2) Rejected projects are not included in calculations.
Spreadsheet: 122818d1317173120-help-with-conditional-statements-with-check-boxes-and-if-statments
Sheet: 2 Operators

 | Step | Operator 1 |  |  |  |  |  | Step | Operator 2
 | 1 |  |  |  |  |  |  | 1
 | 2 |  |  |  |  |  |  | 2
 | 3 |  |  |  |  |  |  | 3
Spreadsheet: 470238d1468407140-split-into-columns-with-balanced-sums-split_column
Sheet: Solver_setup

 |  |  |  |  | binary | grid | solver
12 |  |  |  |  | 0 | 1 | 0 |  |  | 1
11 |  |  |  |  | 0 | 1 | 0
38 |  |  |  |  | 0 | 0 | 1
17 |  |  |  |  | 1 | 0 | 0
5 |  |  |  |  | 1 | 0 | 0
32 |  |  |  |  | 0 | 1 | 0
6 |  |  |  |  | 1 | 0 | 0
19 |  |  |  |  | 0 | 1 | 0
45 |  |  |  |  | 0 | 0 | 1
10 |  |  |  |  | 0 | 1 | 0
16 |  |  |  |  | 1 | 0 | 0
23 |  |  |  |  | 1 | 0 | 0
17 |  |  |  |  | 1 | 0 | 0
Object function
 | To test clear range F2:H4
 | Click data tab and select solver, click button "Solve"
 | After 10 - 15 seconds press "Esc" button
 | In the new window that pops up click "Stop", then click "Ok" button.