tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 849025d1699590454-stuck-on-index-match-is-there-a-better-way-without-vba-sampleindex-aligw
Sheet: Sheet1

 | CASE REPLIES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Inbound Calls |  | Case Replies | Case Replies | Customers Helped / Cases Solved |  | ABC |  | Claims |  | XYZ
Week | Team Total | Goal # | Goal % | Actual (#) | Goal (%) Actual | % of Quota (#) | % of Quota (%) | Higher % of Quota |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date | Goal # | Goal % | Goal # | Goal % | Goal # | Goal % | Goal # | Goal % | Goal # | Goal % | Goal # | Goal % | Goal # | Goal %
2023-10-16 00:00:00 | 167 |  |  | 12 | 0.0718562874251497 | 0.0718562874251497 | 1.026518391787853 | 1.026518391787853 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-10-16 00:00:00 | 5 | 7 | 6 | 8 | 7 | 9 | 8 | 10 | 9 | 11 | 10 | 12
2023-10-23 00:00:00 | 169 |  |  | 13 | 0.07692307692307693 | 0.07692307692307693 | 0.9615384615384616 | 0.9615384615384616 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-10-23 00:00:00 | 6 | 8 | 7 | 9 | 8 | 10 | 9 | 11 | 10 | 12 | 11 | 13
2023-10-30 00:00:00 | 171 |  |  | 14 | 0.08187134502923976 | 0.08187134502923976 | 0.9096816114359974 | 0.9096816114359974 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-10-30 00:00:00 | 7 | 9 | 8 | 10 | 9 | 11 | 10 | 12 | 11 | 13 | 12 | 14
2023-11-06 00:00:00 | 173 |  |  | 15 | 0.08670520231213873 | 0.08670520231213873 | 0.8670520231213872 | 0.8670520231213872 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-11-06 00:00:00 | 8 | 10 | 9 | 11 | 10 | 12 | 11 | 13 | 12 | 14 | 13 | 15
2023-11-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-11-13 00:00:00 | 9 | 11 | 10 | 12 | 11 | 13 | 12 | 14 | 13 | 15 | 14 | 16
2023-11-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-11-13 00:00:00 | 9 | 11 | 10 | 12 | 11 | 13 | 12 | 14 | 13 | 15
2023-11-27 00:00:00
2023-12-04 00:00:00
2023-12-11 00:00:00
2023-12-18 00:00:00
2023-12-25 00:00:00
Spreadsheet: phillip_m_love__30152__9905_OA
Sheet: TX-EGM-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 50782978 | 118286936.96
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 71127 | 159944.9
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 50854105 | 118446881.86
 | Purchases:
6 |  | 3rd Party / Inter Enron | -56565409 | -129583943.57
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -2052275 | -4472679.11
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 0 | 0
 | Total Purchases: |  | -58617684 | -134056622.68
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | 32997274 | 74244674.74
12 |  | Purchases | -33022074 | -74302955
 | Total Intra CTS Sales / Purchases |  | -24800 | -58280.26000000536
 | Imbalances:
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 1027777 | 1867759.461530931
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | 1027777 | 1867759.461530931
 | Storage:
17 |  | Injection (Sales to Stg) | 7337145 | 16945465.6
18 |  | W/D (Purchase from Stg) | -576543 | -1293656.32
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -576543 | -1293656.32
 | Total Storage: |  | 6760602 | 15651809.28
20 | Linepack: |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
22 | UA4: |  | 0 | 0
23 | Fuel: |  | 0 | -25000
 | Transport Expense:
24 |  | Commodity | 0 | -992568.27
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | -992568.27
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | 250999.06
31 |  | Prior Month Book Balance | 0 | -1054678
 |  | Total MTM Income | 0 | -803678.94
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 1019748.41
34 |  | Originations | 0 | 81200
35 |  | Broker Fees | 0 | -4060
36 |  | Asset Group Demand Charges | 0 | -108300
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 0
 |  | TOTAL INTRA-MTH
FT-South Texas
 |  | Current Month MTM | 0 | 114066
 |  | Financial Liquidations | 0 | 0
 |  | Originations | 0 | -113464
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 6fd0ed35-117a-4e7e-8ae1-0d6b7a556a0a
Sheet: Sheet1

Table KS06 Ethnic group | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Key Statistics for Birmingham 2006 Districts and 2004 Wards.*
Key Statistics provide headline results about the main Census topics and facilitate comparisons between different areas.
The dataset contains around 380 statistics for each area.  The districts are those in place at 23rd May 2006.
* Best Fit Approximations issued by the Office for National Statistics in December 2004
Results for new wards are based on allocation of whole Census Output Areas.
Data for any Census Output Area that is split by a new ward boundary are allocated to the ward that contains the greatest
share of its population.
For reasons of confidentiality, National Statistics have altered the published results where very small numbers of people in an area fall into any of the categories in a table  (e.g. persons in a Birmingham ward working in the fishing industry). This means that:
- Population and household totals may vary among tables
- Published figures for a larger area may not match the sum of results for its smaller constituent parts.
For more census results please visit our website: |  |  | www.birmingham.gov.uk/community |  |  |  | or visit
www.statistics.gov.uk/neighbourhood
Copyright and Conditions of Use
The material presented is derived from the 2001 Census Area Statistics.  All census material is Crown Copyright.  Birmingham Council has a 'click user licence' issued by Her [NAME]'s Stationary Office.  This allows the re-use and publication of Census data.
 | Persons and organisations outside the City Council should check whether they need to obtain a licence to use and publish the data.  More information can be obtained from the national census website or from her [NAME]'s Stationary Office (HMSO):
http:/www.hmso.gov.uk/click-use-home.htm                                                                                                                                     HMSO,The Licensing Division, St Clements House,                                                                                                                                        2 to 16 Colegate, [NAME], NRS 1BQ(tel 01603 621000)
2001 Census Statistics incorporate measures to protect against the inadvertent disclosure of information relating specifically to an identified person or household.  The material should not be used to attempt to derive information relating specifically to an identified person or household nor should a claim be made that such information has been obtained or derived.
 |  |  |  |  | Development Directorate Demographic Information Service
Source: 2001 Census, [Key Statistics for Local Authorities].  Crown
copyright 2005. Crown copyright material is reproduced with the
permission of the [NAME] of HMSO .
Spreadsheet: 209998d1359343609-tracking-athletic-records-sirtifiable_890412_27jan13_01
Sheet: Sheet1

Week | Athlete | 100m | 200m | Discus | Shot Put |  | Athlete | 100m | 200m | Discus | Shot Put
1 | a | 00:00:19.920000 | 00:00:43.180000 | 5.76 m | 5.59 m |  | a
 | b | 00:00:22.810000 | 00:00:51.810000 | 12.80 m | 4.74 m |  | b
 | c | 00:00:18.690000 | 00:00:41.470000 | 7.66 m | 4.55 m |  | c
 | d | 00:00:19.620000 | 00:00:41.060000 | 4.42 m | 3.82 m |  | d
 | e | 00:00:24.080000 | 00:00:52.130000 | 12.93 m | 7.95 m |  | e
 | f | 00:00:16.120000 | 00:00:34.010000 | 19.50 m | 4.52 m |  | f
 | g | 00:00:16.740000 | 00:00:36.480000 | 11.66 m | 5.80 m |  | g
2 | a | 00:00:18.890000 | 00:00:37.820000 | 10.92 m | 4.74 m
 | b | 00:00:17.030000 | 00:00:34.300000 | 21.08 m | 4.55 m
 | c | 00:00:19.570000 | 00:00:36.480000 | 14.89 m | 3.82 m
 | d | 00:00:16.040000 | 00:00:32.380000 | 5.76 m | 7.95 m
 | e | 00:00:14.490000 | 00:00:48.090000 | 12.80 m | 4.52 m
 | f | 00:00:15 | 00:00:32.350000 | 7.66 m | 5.80 m
 | g | 00:00:15.220000 | 00:00:33.750000 | 4.42 m | 3.82 m
3 | a | 00:00:15.530000 | 00:00:38.910000 | 12.93 m | 7.95 m
 | b | 00:00:16.120000 | 00:00:38.780000 | 19.50 m | 4.52 m
 | c | 00:00:16.740000 | 00:00:34.090000 | 11.66 m | 5.80 m
 | d | 00:00:18.890000 | 00:00:40.890000 | 10.92 m | 4.74 m
 | e | 00:00:17.030000 | 00:00:31.960000 | 21.08 m | 4.55 m
 | f | 00:00:19.570000 | 00:00:40.910000 | 14.89 m | 3.82 m
 | g | 00:00:22.810000 | 00:00:41.470000 | 12.80 m | 7.95 m
Spreadsheet: 136368d1326578745-only-copy-cell-contents-with-a-date-format-dummy-file
Sheet: Formula Sheet

Name |  | Company | Purpose | Start Date | End Date
Date | Payee | Type of Expense | Purpose | Individuals/Companies | Amount
I CERTIFY THAT THE ABOVE EXPENSES HAVE BEEN INCURRED BY ME ONLY ON BEHALF OF THE COMPANY AND HAVE NOT BEEN PREVIOUSLY PAID OR REIMBURSED BY THE COMPANY. |  |  |  | Balance Due Employee:
 |  |  |  | Balance Due Company:
Signature of Employee |  |  |  | Date
Approval by Immediate Supervisor |  |  |  | Date
Spreadsheet: 884551d1733788098-roi-formula-2024-tos-trades-test
Sheet: Sheet1

DATE | [NAME] | ACTION | SIZE | EQ | SERIES | INSTRUMENT | Near | Mid | Far | STOP | SPREAD | POINTS | COST/CREDIT | NET P/L | ROI | Notes
2024.12.04 | ~12:15 | STO | 3 | ROKU | 2024.12.06 | PUT Vertical | 81 |  | 78 | 79 | .46/.13 | 0.33 | 0.99 | 95.03 |  | $10 gap up, 1D5M above 8 & 21, 81 is SD less than [NAME], Prob ITM <18%
2024.12.06 | 11:45:00 | STO | 2 | COST | 2024.12.06 | PUT Vertical | 990 |  | 985 | 991 | 1.01/.31 | 0.69 | 1.38 | 137.34 |  | 1D5M above 8 & 21, good 5M support @991, Prob ITM <26%
2024.12.06 | 11:45:00 | STC | 2 | COST | 2024.12.06 | PUT Vertical | 990 |  | 985 |  | 1.05/.295 | -0.75 | -1.5 | -153.65 |  | wrong conditional entry
2024.12.06 | 12:32:00 | STO | 2 | COST | 2024.12.06 | PUT Vertical | 990 |  | 985 | 991 | 1.20/.32 | 0.88 | 1.76 | 173.34 |  | 1D5M above 8 & 21, good 5M support @991, Prob ITM <25%
2024.12.06 | 15:51:00 | STC | 2 | COST | 2024.12.06 | PUT | 990 |  |  |  | 0.17 | 0.17 | -3.5 | -35.32
Spreadsheet: 594233d1539643582-sumifs-jtakwformula-excel-forum-formula1
Sheet: Sheet2

 |  | Term | 10
 |  | Discount | 0.06
 |  |  | Months | Amount |  | Amort Schedule
 |  |  | 1 | 100
 |  |  | 1
 |  |  | 1
 |  |  | 1
 |  |  | 1
 |  |  | 1 | 100 |  |  | ($10 + ($100/5 months remaining)
 |  |  | 1
 |  |  | 1
 |  |  | 1
 |  |  | 1
 |  |  |  |  | HIDE THIS COLUMN
Spreadsheet: 876501d1723207572-sort-data-by-2-criteria-excel760-sample-v2-2-365-tms-aligw
Sheet: Sheet2

Answer:
City | Sales | Classification | Grade
NY | 5 | VS | A+ |  |  | 5 | VS | A+
London | 1.5 | VS | A+ |  | London | 1.5 | VS | A+
Berlin | 4.5 | VS | A |  | Berlin | 4.5 | VS | A
Hong Kong | 0.5 | VS | C |  | Hong Kong | 0.5 | VS | C
Seattle | 0.3 | VB | A |  | Seattle | 0.3 | VB | A
LA | 3 | VB | A- |  | LA | 3 | VB | A-
Paris | 1.2 | VB | B |  | Paris | 1.2 | VB | B
Milan | 1 | VB | B |  | Milan | 1 | VB | B
Toronto | 0.7 | VB | B- |  | Toronto | 0.7 | VB | B-
Madrid | 2 | VB | C |  | Madrid | 2 | VB | C
Spreadsheet: 779090d1651583817-sum-datas-by-date-across-different-sheets-sample
Sheet: October

Date | Sales
2022-10-01 00:00:00 | 1
2022-10-02 00:00:00 | 1
2022-10-03 00:00:00 | 1
2022-10-04 00:00:00 | 1
2022-10-05 00:00:00 | 1
2022-10-06 00:00:00 | 1
2022-10-07 00:00:00 | 1
2022-10-08 00:00:00 | 1
2022-10-09 00:00:00 | 1
2022-10-10 00:00:00 | 1
2022-10-11 00:00:00 | 1
2022-10-12 00:00:00 | 1
2022-10-13 00:00:00 | 1
2022-10-14 00:00:00 | 1
2022-10-15 00:00:00 | 1
2022-10-16 00:00:00 | 1
2022-10-17 00:00:00 | 1
2022-10-18 00:00:00 | 1
2022-10-19 00:00:00 | 1
2022-10-20 00:00:00 | 1
2022-10-21 00:00:00 | 1
2022-10-22 00:00:00 | 1
2022-10-23 00:00:00 | 1
2022-10-24 00:00:00 | 1
2022-10-25 00:00:00 | 1
2022-10-26 00:00:00 | 1
2022-10-27 00:00:00 | 1
2022-10-28 00:00:00 | 1
2022-10-29 00:00:00 | 1
2022-10-30 00:00:00 | 1
2022-10-31 00:00:00 | 1
Spreadsheet: 81d09999-3736-4e6d-abaf-f7bfccbfb6f3
Sheet: Sheet1

1 | Flawed/insufficient design, implementation and/or capacity of devices and systems. Includes software bugs and design flaws. | 2 | 2
2 | Inadequate policy framework | 1 | 2
3 | Inadequate privacy/security interfaces (poor interface design) | 2 | 2
4 | Increase in centralization of data storage and processing and over-reliance on these centralised facilities | 2 | 3
5 | Inherent features of smart devices (size, material etc.) They may be easy to lose or to be stolen, oversensitivity of sensors (for example, leading to inaccuracies) | 3 | 3
6 | Lack of appropriate, common or harmonized legislation in EU Member States | 2 | 2
7 | Lack of interoperability between devices/ services/ technologies and/or systems | 3 | 3
8 | Lack of or inadequate user identification, authentication and access controls; e.g. use of new devices as authentication tools | 3 | 3
9 | Lack of third party system reviews and software integrity certification | 2 | 2
10 | Over reliance and excessive dependency on electronic devices and systems | 3 | 3
11 | PC vulnerabilities | 3 | 3
12 | Smart phone vulnerabilities | 3 | 3
13 | Erroneous sensor calibration | 1 | 1
14 | Lack of revocation/correction/deletion mechanisms | 3 | 2
15 | Lack of (usable) privacy controls, e.g., overly permissive defaults, too coarse granularity, ... | 2 | 1
16 | Lack of (usable) logging controls/policies/ reminders. E.g. capturing some embarrassing scene of someone else or yourself | 3 | 2
17 | Lack of secure transmission and storage of data; also includes lack of (usable) transmission control (who gets the data) | 3 | 3
18 | Lack of mechanisms to validate reputation or trustworthiness of service provider | 3 | 3
19 | Lack of noticeable (and usable) notification systems So that you don’t know when you’re logged on someone else’s system | 2 | 2
21 | Increased complexity of controls (making it difficult for users to follow) | 2 | 2
22 | Increase of (unprotected) data storage capacity in smart-devices | 3 | 3
23 | Reliance on legacy, un-patched systems or integration mistakes | 2 | 2
24 | Lack of appropriate assurance procedures (e.g. third party audits) or enforcement of such, regarding the implementation of security controls, especially from the state, other regulatory and public authority | 3 | 2
25 | Lack of “social translucency”, i.e., audit logs (who accessed my profile/data) | 3 | 3
26 | Social reliance/over-confidence and trust on individual’s digital identity | 2 | 2
27 | Inadequate user education, lack of awareness and training particularly in security and privacy; lack of context awareness, i.e. in which context the data should be used | 3 | 3
28 | Psychological vulnerability (low self esteem and confidence to self, high influence potential by others, naïve and suggestible, etc ; weak perception of self) | 2 | 4
29 | Cognitive biases – Some people accept what they should not… | 2 | 3
30 | Data linkability / lifelogging data can be aggregated with other data | 2 | 2
Spreadsheet: 797718d1664096237-dynamic-sheet-references-and-aggregation-coop-1-
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: 814477d1674431395-need-to-sum-in-a-different-sheet-using-titles-in-current-sheet-to-choose-other-sheets-test2
Sheet: Production

 |  |  |  |  |  | Expected results:
 |  | APR | MAY | JUN |  | APR | MAY | JUN
 | 2022FY Production Claims |  |  |  | <----------
 | Production Sheets 2019FY
 | KPI (N.º Claims/10.000 PS)
 |  | APR | MAY | JUN |  | APR | MAY | JUN
 | 2023FY Production Claims
 | Production Sheets 2019FY
 | KPI (N.º Claims/10.000 PS)
 | Complaints | 5
 | Production Sheets NOT TFM | 109447
 | KPI fy2021
 | Number of complaints per FY | FY2019 | FY2020 | FY2021
 | Gapping defect | 1
 | Marking failure | 1
 | Slider enamelling | 1
 | Wrong length | 1 | 1
 | Wrong reference/color/finish | 1 | 1
 | Manual work |  | 1 | 1
 | Slider mix | 3 | 1
 | Oxidation/MF Chain | 4
 | Wrong slider | 3 | 1 | 1
 | Dyeing | 1 |  | 5
 | Defects / Lack of terminals/open parts | 5 | 5 | 4
 | By Location | FY2019 | FY2020 | FY2021
 | Chain / Item | 7 | 2 | 5
 | Slider | 4 | 3 | 1
 | Tape | 3
 | Open parts | 3 | 1 | 1
 | Top stop | 2 | 4 | 3
 | Bottom stop | 2
 | By Section
 | CF Assembly TFM | 4 | 2 | 3
 | CF Assembly Apparel | 6 | 4 | 3
 | MF Assembly | 5 | 3 | 1
 | Dyeing TFM | 1 |  | 3
 | [NAME] | 1 | 1 | 2
 | Oxidation/MF Chain | 3
 | Enamelling | 1
 | By [NAME]
 | Wrong component / color | 2 |  | 1
 | Wrong quantity |  | 1
 | Wrong item | 2
 | Stains/Spots - Dirtiness | 1 | 2 | 1
 | Missing component | 3 | 2 | 2
 | Unleveling |  |  | 3
 | Different color/tone | 4 | 2 | 2
 | Slider Mix | 3 | 1
 | Wrong Slider | 3
 | Deficient Operation | 1 | 1 | 1
 | Wrong length | 1 | 1 | 1
 | Marking failure | 1
 |  | 2019 | 2020 | 2021
 |  | 3 CF FR-13 chain | 5 CIFOR | 5 CIFC
 |  | 3 Y | 5 CIFC | 5 CF roll
 |  | 3 CFO | 3 CHC | 5 MF
 |  | 2 CHC | 5 CIFC | 3 CF
 |  | 5 CIFC | 5 CIFC | 5 MF
 |  | 3 Y | 5 VS
 |  | 5 RC | 5 CIFOR
 |  | 3 CF | 5 CIFOR
 |  | 5 CIFC
 |  | 2 CHC
 |  | 5 MFC
 |  | 5 MFC
 |  | 5 MFC
Spreadsheet: 858415d1707125353-excel-formula-check-multiple-condition-and-if-match-return-hyperlink-masterlist-pw1-aligw
Sheet: folderPath

 | State | Year | Code | Location Path | File Name | File Extension
 | M | 2023 | M1 | d:/path1/path2/path3/ | IN/M1/23/ | .pdf
 | M | 2023 | M2 | d:/path1/path2/path3/ | IN/M2/23/ | .pdf
 | J | 2023 | J1 | d:/path1/path2/path3/ | IN/J1/23/ | .pdf
 | N | 2024 | N2 | d:/path1/path2/path3/ | IN/N2/24/ | .pdf
 | M | 2024 | M3 | d:/path1/path2/path3/ | IN/M3/24/ | .pdf
Spreadsheet: 190988d1351870096-move-cell-data-to-imbedded-comment-imbed-comment
Sheet: Sheet1

Please imbed me | Existing Data
Please imbed me | Existing Data
Please imbed me | Existing Data
Please imbed me | Existing Data
Please imbed me | Existing Data
Please imbed me | Existing Data
Please imbed me | Existing Data
Please imbed me | Existing Data
Please imbed me | Existing Data
Please imbed me | Existing Data
Please imbed me | Existing Data
Please imbed me | Existing Data
Spreadsheet: 249854d1373642327-need-help-sorting-data-into-another-excel-sheet-merging-and-sorting-files
Sheet: Sheet1

Item Code | Our Cost | File1
724 | 631
1512 | 523
6941 | 423
75190 | 642
189056 | 462
908165 | 54
16894-2 | 452
17820-4 | 234
Item Code | Competitor's Price | File 2
724 | 564
1512 | 530
6941 | 500
12345 | 523
53132 | 532
75190 | 700
189056 | 558
672543 | 432
726351 | 345
908165 | 60
1280630 | 642
1284260 | 356
6801414 | 321
196184801 | 235
860124642 | 42
16894-2 | 550
17820-4 | 270
Item Code | Our Cost | Competitor's Price | Combined Files
724 | 631 | 564
1512 | 523 | 530
6941 | 423 | 500
75190 | 642 | 700
189056 | 462 | 558
908165 | 54 | 60
16894-2 | 452 | 550
17820-4 | 234 | 270
Spreadsheet: b92f447a-af0b-47c5-932b-e2f466fc7873
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
FORMACIÓN CONTINUA 2011
 | CURSO | FORMATO | F.INICIO | F.FIN | LUGAR | DURACIÓN
 | Inglés básico
 | Gestor [NAME] el ámbito local | Teleformación |  |  |  | 120
 | Gestión económica de la Administración Local | Teleformación |  |  |  | 200
 | Igualdad entre mujeres y hombres en el medio rural | Teleformación |  |  |  | 100
 | [NAME]: tratamiento postural en tercera edad y discapacitados | Presencial | 2011-09-19 00:00:00 | 2011-09-28 00:00:00 | Villaviciosa | 21
 | Manejo del desfibrilador y primeros auxilios | Presencial | 2011-09-26 00:00:00 | 2011-09-30 00:00:00 | Pola de Lena | 15
 | Operario de maquinaria ligera (Homologado por el Instituto de Prevención de Riesgos Laborales) | Presencial | 2011-06-06 00:00:00 | 2011-06-16 00:00:00 | Llanera | 30
 | [NAME] | Presencial | 2011-06-07 00:00:00 | 2011-06-16 00:00:00 | Luarca | 20
 | Defensa personal ante arma blanca | Presencial |  |  | Avilés | 15
 | [NAME] con los distintos tipos de máquina de obra | Presencial |  |  | Llanes | 90
 | [NAME] en condiciones adversas | Presencial |  |  |  | 10
 | [NAME] en condiciones adversas | Presencial |  |  |  | 10
Spreadsheet: 151771d1335113397-copy-just-numbers-coursework
Sheet: Sheet1

 | Input Data |  |  |  |  |  | Locations Visited
 |  |  |  |  |  |  | Vehicle 1 | Vehicle 2 | Vehicle 3 | Vehicle 4 | Vehicle 5
 | Customer ID | X Coordinate | Y Coordinate | Demand (m3) | Time | Start: | 33 | 33 | 33 | 33 | 33
 | 1 | 77 | 97 | 5 | 1
 | 2 | 28 | 64 | 23 | 2
 | 3 | 77 | 39 | 14 | 2
 | 4 | 32 | 33 | 13 | 4
 | 5 | 32 | 8 | 8 | 3
 | 6 | 42 | 92 | 18 | 3
 | 7 | 8 | 3 | 19 | 3
 | 8 | 7 | 14 | 10 | 1
 | 9 | 82 | 17 | 18 | 2
 | 10 | 48 | 13 | 20 | 3
 | 11 | 53 | 82 | 5 | 1
 | 12 | 39 | 27 | 9 | 4
 | 13 | 7 | 24 | 23 | 5
 | 14 | 67 | 98 | 9 | 5
 | 15 | 54 | 52 | 18 | 3
 | 16 | 72 | 43 | 10 | 1
 | 17 | 73 | 3 | 24 | 4
 | 18 | 59 | 77 | 13 | 4
 | 19 | 58 | 97 | 14 | 1
 | 20 | 23 | 43 | 8 | 5
 | 21 | 68 | 98 | 10 | 1
 | 22 | 47 | 62 | 19 | 2
 | 23 | 52 | 72 | 14 | 2
 | 24 | 32 | 88 | 13 | 1
 | 25 | 39 | 7 | 14 | 5
 | 26 | 17 | 8 | 2 | 1
 | 27 | 38 | 7 | 23 | 4
 | 28 | 58 | 74 | 15 | 4
 | 29 | 82 | 67 | 8 | 1
 | 30 | 42 | 7 | 20 | 1
 | 31 | 68 | 82 | 24 | 5
 | 32 | 7 | 48 | 3 | 1
 |  |  |  |  |  | Return: | 33 | 33 | 33 | 33 | 33
Warehouse Location: | 33 | 42 | 68 | 0 |  | Lookup: | 1 | 2 | 3 | 4 | 5
 | Penalty Calculation
 | Criteria: | Time | Time | Time | Time | Time
 |  | 1 | 2 | 3 | 4 | 5
 | Stops:
 | Delivered:
 | Over:
 | Amount over Capacity: |  |  |  | Available: | 100
 | Stops without Deliverys: |  |  | Average Demand:
 | Penalties: