tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 696909d1601035459-a-lookup-function-to-return-a-persons-function-which-will-vary-depending-on-dates-trade-cross-reference
Sheet: DPR's Tabled

Date | Name | Function - (Lookup) | Function - (Sumproduct) |  | Function Should Be (Hardtyped)
2020-01-01 00:00:00 | [NAME] |  |  |  | RA MDO
2020-01-01 00:00:00 | [NAME] |  |  |  | RA MDO
2020-01-01 00:00:00 | [NAME] |  |  |  | RA L3
2020-01-01 00:00:00 | [NAME] |  |  |  | RA L3
2020-01-02 00:00:00 | [NAME] |  |  |  | RA MDO
2020-01-02 00:00:00 | [NAME] |  |  |  | RA MDO
2020-01-02 00:00:00 | [NAME] |  |  |  | RA L3
2020-01-02 00:00:00 | [NAME] |  |  |  | RA L3
2020-01-03 00:00:00 | [NAME] |  |  |  | RA L3
2020-01-03 00:00:00 | [NAME] |  |  |  | RA MDO
2020-01-03 00:00:00 | [NAME] |  |  |  | RA L3
2020-01-03 00:00:00 | [NAME] |  |  |  | RA L3
2020-01-04 00:00:00 | [NAME] |  |  |  | RA L3
2020-01-04 00:00:00 | [NAME] |  |  |  | RA L3
2020-01-04 00:00:00 | [NAME] |  |  |  | RA L3
2020-01-04 00:00:00 | [NAME] |  |  |  | RA L3
2020-01-05 00:00:00 | [NAME] |  |  |  | RA L3
2020-01-05 00:00:00 | [NAME] |  |  |  | RA L3
2020-01-05 00:00:00 | [NAME] |  |  |  | L3 Coating Supervisor
2020-01-05 00:00:00 | [NAME] |  |  |  | RA L3
 | [NAME] |  |  |  | RA L3
 | [NAME] |  |  |  | RA MDO
 | [NAME] |  |  |  | L3 Coating Supervisor
 | [NAME] |  |  |  | L3 Coating Supervisor
 | [NAME] |  |  |  | RA L3
 | [NAME] |  |  |  | RA MDO
 | [NAME] |  |  |  | L3 Coating Supervisor
 | [NAME] |  |  |  | L3 Coating Supervisor
 | [NAME] |  |  |  | RA MDO
 | [NAME] |  |  |  | RA MDO
 | [NAME] |  |  |  | L3 Coating Supervisor
 | [NAME] |  |  |  | RA MDO
 | [NAME] |  |  |  | RA MDO
 | [NAME] |  |  |  | RA MDO
 | [NAME] |  |  |  | RA MDO
 | [NAME] |  |  |  | RA MDO
 | [NAME] |  |  |  | RA MDO
 | [NAME] |  |  |  | RA MDO
 | [NAME] |  |  |  | RA MDO
 | [NAME] |  |  |  | RA MDO
Spreadsheet: 68679d1d-6391-4c9b-a111-ebd085c0ddbd
Sheet: 9b

Product | EUR** | GBP | [NAME] | USD | TOTAL
Basis* | 210054 | 1244110 | 799713 | 4793470 | 7047347
FRA | 20492165 | 7129890 | 6764 | 15276408 | 42905227
IRS- [NAME] | 58218863 | 9809109 | 12918614 | 39504709 | 120451295
OIS | 15854393 | 5118388 |  | 4469948 | 25442729
VNS | 8598 | 1889 |  | 11151 | 21638
Zero Coupon | 211804 | 49998 | 49034 | 67995 | 378831
TOTAL | 94995877 | 23353384 | 13774125 | 64123682 | 196247069
Estimated gross notional amount outstanding, August 16 weekly snapshot, by product type and supermajor currency (millions of USD), cleared swaps only, all participant types and tenors. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for currency descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 44837d1243566154-calculate-date-automatically-seroleh-5
Sheet: Sheet1

 |  |  | 2009-05-01 00:00:00 |  |  |  | 2010-05-01 00:00:00
 |  |  | 1ST Batch |  |  |  | 2ND Batch
 |  | No | Name | Pass |  | No | Name | Pass
 |  | 631 | Valdes | yes |  | 631 | Van der [NAME] | yes
 |  | 632 | [NAME] | No |  | 632 | Vidic | No
 |  | 633 | Eto'o | yes |  | 633 | Ferdinand | yes
 |  | 634 | Xavi | No |  | 634 | [NAME] | No
 |  | 635 | Abidal | yes |  | 635 | [NAME] | No
 |  | 636 | Puyol | yes |  | 636 | Carrick | yes
 |  | 637 | [NAME] | No |  | 637 | [NAME] | yes
 |  |  | List Pass |  |  |  | Waiting List
 |  | No | Name |  |  | No | Name
 |  | 1 |  |  |  | 1
Spreadsheet: benjamin_rogers__1033__scheduler contacts
Sheet: Sheet1

Scheduler | Phone | [NAME] | Region | Directory to Spreadsheet
[NAME] | 3-0421 | [EMAIL] |  | [NAME]"
[NAME] | 3-1636 | [EMAIL] | PJM | [NAME]"
[NAME] | 36284 | [EMAIL] | COMED/NYISO | M:\Electric\Schedule\NYISO\"TSC Calculator [NAME]"
[NAME] | 33932 | [EMAIL] | NEPOOL | M:\Electric\Schedule\NEPOOL\"Month"\"XXXX NEPOOL"
[NAME] | 36261 | [EMAIL] | TVA | [NAME]"
[NAME] | 39803 | [EMAIL] | ERCOT | M:\Electric\Schedule\ERCOT\"Year"\"ERCOT XXXX"
[NAME] | 36350 | [EMAIL] | CIN/ECAR | [NAME]"
Spreadsheet: 753865d1635791647-automatic-cell-population-from-another-tab-resource-overview
Sheet: Pipeline

 |  | Project Type | Start Date | Skill Type | 2021-11-01 00:00:00 | 2021-11-08 00:00:00 | 2021-11-15 00:00:00 | 2021-11-22 00:00:00 | 2021-11-29 00:00:00 | 2021-12-06 00:00:00 | 2021-12-13 00:00:00 | 2021-12-20 00:00:00 | 2021-12-27 00:00:00 | 2022-01-03 00:00:00 | 2022-01-10 00:00:00 | 2022-01-17 00:00:00 | 2022-01-24 00:00:00 | 2022-01-31 00:00:00 | 2022-02-07 00:00:00 | 2022-02-14 00:00:00 | 2022-02-21 00:00:00 | 2022-02-28 00:00:00 | 2022-03-07 00:00:00 | 2022-03-14 00:00:00 | 2022-03-21 00:00:00
 |  | Project X | 2021-11-15 00:00:00 | Skill 1 |  |  | 15 | 15 | 15 | 15 | 7.5 | 7.5 | 15 | 15
 |  | Project X |  | Skill 2 |  |  |  |  | 15 | 15 | 15 | 15
 |  | Project X |  | Skill 3 |  |  |  |  | 15 | 30 | 30
 |  | Project X |  | Skill 4 |  |  |  |  |  | 7.5 | 7.5
 |  | Project Y | 2021-12-06 00:00:00 | Skill 1 |  |  |  |  |  | 7.5 | 7.5 | 15 | 15 | 15 | 15 | 7.5 | 7.5 | 15 | 15
 |  | Project Y |  | Skill 2 |  |  |  |  |  |  | 7.5 | 15 | 15 | 15 | 15 | 7.5 | 7.5
 |  | Project Y |  | Skill 3 |  |  |  |  |  |  |  |  | 7.5 | 15 | 15 | 15 | 15
 |  | Project Y |  | Skill 4 |  |  |  |  |  |  |  |  | 7.5 | 15 | 15
 |  | Project Z | 2022-01-03 00:00:00 | Skill 1 |  |  |  |  |  |  |  |  |  | 7.5 | 7.5 | 15 | 15 | 15 | 15 | 7.5 | 7.5 | 15 | 15 | 7.5 | 7.5
 |  | Project Z |  | Skill 2 |  |  |  |  |  |  |  |  |  |  | 7.5 | 15 | 15 | 15 | 15 | 7.5 | 7.5 | 15 | 15
 |  | Project Z |  | Skill 3 |  |  |  |  |  |  |  |  |  |  |  | 7.5 | 15 | 15 | 15 | 15 | 7.5 | 7.5 | 15 | 15
 |  | Project Z |  | Skill 4 |  |  |  |  |  |  |  |  |  |  |  | 7.5 | 15 | 15 | 15 | 15 | 7.5 | 7.5 | 15 | 15
Spreadsheet: 789021d1658847538-separate-and-remove-text-from-a-cell-based-on-data-from-another-sheet-sample
Sheet: Locations

Original Data |  | Desired Results |  |  |  | [NAME]
Name |  | Bldg | Room | [NAME] |  | Bldg | Room | [NAME]
3420-01 |  | --- | 3420 | 01
3A0100-01 |  | 3A | 100 | 01
3A2106-A1-1 |  | 3A | 2106 | A1-1
3A2108LABTRK-01 |  | 3A | 2108 | 01
3B111-02 |  | 3B | 111 | 02
3E5122-DECOM |  | 3E | 5122
3E5123-CONF |  | 3E | 5123
3H1060-01 |  | 3H | 1060 | 01
3H1060-02 |  | 3H | 1060 | 02
5C210D-01 |  | 5C | 210D | 01
DS-3A1175-01 |  | 3A | 1175 | 01
[NAME] |  | CH | 244A | 01
[NAME] |  | --- | 124A | 01
Spreadsheet: d868f992-0e84-4a6b-9b8b-e60ff8a498a8
Sheet: Sheet1

OPERATING/PROGRAMMATIC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | 120397 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Approving and authorizing settlement of a claim entitled 200 Grand Condominium
 | Association, Claim File No. T1112-0309A
 | \
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  | X | No |  |  | Yes
 | If yes, please identify in  which Fund these revenues will be deposited (e.g. General, Sales Tax)
 | and provide the following revenue information:
 | Revenue Detail |  |  |  | FY 2011-12 |  |  | FY 2012-13
 | General Fund
 | Special Revenue
 | Enterprise
 |  |  | Total: | $ | 0 |  | $ | 0
 | (Please detail type of revenue (fees, grants, tax) and change that will occur as a result of this legislation.  Provide multi-year
 | estimates if known, or if grant revenue please identify source of funds (federal or state) and duration of grant support)
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  | X | No |  |  | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY 2011-12 |  |  | FY 2012-13
 | General Fund
 | Special Revenue
 | Enterprise/Other
 |  |  | Total: | $ | 0 |  | $ | 0
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  | X | No |  |  | Yes
 | (Please detail estimate number of people to be served, who is delivering services currently to that population, service
 | performance expectations, and if grant supported, provisions for support if grant support ends.
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  | X | No |  |  | Yes
 | (If yes, please detail the purpose and source for that mandate).
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date
Spreadsheet: 157958d1337938153-removing-space-from-a-range-of-values-char-0160
Sheet: Sheet1

 | length before | length after
FACTORY NAME | 12 | 12 |  | select column a
CP Designs | 10 | 10
CP Designs | 10 | 10 |  | use find replace
CP Designs | 11 | 10 |  | the space you have at the end is char 160
CP Designs | 11 | 10
CP Designs | 11 | 10 |  | so in find hold down the alt key and on the numeric keypad type 0160 |  |  |  |  |  |  | (alt+0160)
CP Designs | 11 | 10
CP Designs | 11 | 10 |  | leave replace blank
CP Designs | 11 | 10
CP Designs | 11 | 10 |  | click finish
CP Designs | 10 | 10
CP Designs | 11 | 10
CP Designs | 11 | 10
CP Designs | 11 | 10
CP Designs | 11 | 10
CP Designs | 11 | 10
CP Designs | 11 | 10
CP Designs | 11 | 10
CP Designs | 11 | 10
CP Designs | 11 | 10
CP Designs | 11 | 10
Best Corporation Private limited | 32 | 32
Best Corporation Private limited | 33 | 32
Best Corporation Private limited | 33 | 32
Best Corporation Private limited | 33 | 32
Best Corporation Private limited | 33 | 32
Best Corporation Private limited | 33 | 32
Best Corporation Private limited | 33 | 32
Best Corporation Private limited | 33 | 32
Best Corporation Private limited | 33 | 32
Best Corporation Private limited | 33 | 32
Best Corporation Private limited | 33 | 32
Best Corporation Private limited | 32 | 32
Best Corporation Private limited | 33 | 32
Best Corporation Private limited | 33 | 32
Shanghai Jing Qingrong Garment Co., Ltd | 40 | 39
Shanghai Jing Qingrong Garment Co., Ltd | 40 | 39
Shanghai Jing Qingrong Garment Co., Ltd | 40 | 39
Shanghai Jing Qingrong Garment Co., Ltd | 40 | 39
Shanghai Jing Qingrong Garment Co., Ltd | 40 | 39
Shanghai Jing Qingrong Garment Co., Ltd | 40 | 39
Shanghai Jing Qingrong Garment Co., Ltd | 40 | 39
Shanghai Jing Qingrong Garment Co., Ltd | 40 | 39
Spreadsheet: 1b09c658-948a-4184-a432-a3c62bd9d0a4
Sheet: 16

Product* | February 28 | March 7 | March 14 | March 21 | March 28
Total Equity**
Equity Swaps | N/A | N/A | N/A | N/A | N/A
Portfolio Swaps | N/A | N/A | N/A | N/A | N/A
Forwards | N/A | N/A | N/A | N/A | N/A
Swaptions | N/A | N/A | N/A | N/A | N/A
[NAME] | N/A | N/A | N/A | N/A | N/A
TOTAL
Gross notional amount outstanding March 28 weekly snapshot, by product type, all tenors and currencies.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**These numbers are estimates.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: mike_grigsby__27934__HS_WESTall1025
Sheet: Run Query

Daily Hedge Strip
User ID:
Password:
Included Deals | ALL
Today
Days in Month | 30
Day of Month |  | 2001-10-25 00:00:00 | Update this cell daily
PromptMonth | 2001-11-01 00:00:00 | 2001-11-30 00:00:00
StartRange | D4
Enter EASTMEX Date:
[NAME] | NXB2 | NX1
2001-10-25 00:00:00 | 2001-10-26 00:00:00 | 2001-10-29 00:00:00
Please Note:  Once the 'RUN ' button has been pressed, please do not disturb Excel.  Doing so will make you a bad person.
Book Type | Book
Type
D | ENA-FT-WC-CAL-BAS
D | ENA-FT-WT-CAL-BAS
D | ENA-FT-WC-ROX-BAS
D | MGMT-WEST-BAS
D | FT-PGE-BAS
D | ENA-FT-WT-SJ-BAS
D | ENA-FT-WC-SJ-BAS
D | ENA-FT-WT-ROX-BAS
D | FT-DENVER-BAS
D | FT-REGS-BAS
D | ENA-FT-WT-SOCAL-BAS
D | FT-WEST-OPT-BAS
DO | FT-NW-XL-OPT-BAS
DO | FT-WE-XL-OPT-BAS
DO | MGMT-WE-XL-OPT-BAS
DO | GD-NEW-XL-OPT-BAS
D | TRANS-WEST-BAS
D | LT-TRANS-WE-BAS
M | ENA-FT-WC-CAL-GDL
M | ENA-FT-WT-CAL-GDL
M | ENA-FT-WC-ROX-GDL
M | MGMT-WEST-GDL
M | FT-PGE-GDL
M | ENA-FT-WT-SJ-GDL
M | ENA-FT-WC-SJ-GDL
M | ENA-FT-WT-ROX-GDL
M | FT-DENVER-GDL
M | FT-REGS-GDL
M | ENA-FT-WT-SOCAL-GDL
M | ENA-FT-WT-SCAN-GDL
PHY | ENA-IM-WC-CAL-PHY
PHY | ENA-IM-WT-CAL-PHY
PHY | ENA-IM-WC-ROX-PHY
PHY | MGMT-WEST-PHY
PHY | ENA-IM-WT-SJ-PHY
PHY | ENA-IM-WC-SJ-PHY
PHY | ENA-IM-WT-ROX-PHY
PHY | INTRA-DENVER-PHY
PHY | ENA-FT-WT-SOCAL-PHY
Spreadsheet: e1e02c8a-cee7-4690-998c-9ab9b2f75025
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
PHD2 | Test | PHD2 | [NAME] Domain-2 (PHD2/EGLN1) [NAME] | PHD2 Gene, Mutation Analysis, B | Polymerase Chain Reaction (PCR) Amplification/Sanger Sequence Analysis |  |  |  |  |  | Only orderable as part of a profile. For further information see HEMP/61337 Hereditary Erythrocytosis Mutations. | 0.5 mL |  | Only orderable as part of a profile. For further information see HEMP/61337 Hereditary Erythrocytosis Mutations. |  |  |  |  |  |  |  |  |  | Rochester
PHD2 | [NAME] | BLOOD | Whole blood |  |  |  | Refrigerated | 30 days
PHD2 | Result | 34646 | PHD2 Gene Sequencing Result | PHD2 Gene Sequencing Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 201522d1356019197-need-to-expand-subsample-of-species-lengths-subsample-solution
Sheet: Sheet1

 | Actual |  |  |  |  | Prediction
 | 14 |  | MEAN
 | 9 |  | STDEV
 | 10
 | 8
 | 8
 | 7
 | 8
 | 6
 | 9
 | 8
 | 8
 | 10
 | 8
 | 9
 | 8
 | 8
 | 9
 | 7
 | 12
 | 10
 | 6
 | 6
 | 7
 | 8
 | 5
 | 8
 | 9
 | 9
 | 9
 | 6
 | 7
Spreadsheet: 150310d1334419139-song-competition-ranking-order-and-breaking-ties-tony-song-list-test-formulae
Sheet: Sheet1

 | artist | song | [NAME] | [NAME] | [NAME] | pete | total | place | rank
1 | artist 1 | song 1 | 3 | 3 | 1 | 4 | 11 | 11
2 | artist 2 | song 2 | 5 | 5 | 3 | 5 | 18 | 6
3 | artist 3 | song 3 | 6 | 8 | 6 | 7 | 27 | 2
4 | artist 4 | song 4 | 5 | 3 | 5 | 4 | 17 | 8
5 | artist 5 | song 5 | 1 | 1 | 0 | 3 | 5 | 12
6 | artist 6 | song 6 | 3 | 4 | 4 | 6 | 17 | 8
7 | artist 7 | song 7 | 5 | 4 | 4 | 5 | 18 | 6
8 | artist 8 | song 8 | 7 | 6 | 5 | 4 | 22 | 4
9 | artist 9 | song 9 | 5 | 7 | 6 | 9 | 27 | 2
10 | artist 10 | song 10 | 7 | 5 | 8 | 8 | 28 | 1
11 | artist 11 | song 11 | 6 | 2 | 2 | 6 | 16 | 10
12 | artist 12 | song 12 | 6 | 3 | 6 | 7 | 22 | 4
Spreadsheet: a56bbd15-4c3c-4f95-9e7f-fdefbc6b6456
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
MNCRU | Test | MNCRU | Manganese/Creatinine Ratio, Random, [NAME] | Manganese/Creat Ratio, Random, U | MNCR/32487: Dynamic Reaction Cell-Inductively Coupled Plasma-Mass Spectrometry (DRC-ICP-MS) CDCR/7243: Enzymatic Colorimetric Assay | Plastic urine container with no metal cap or glued insert |  |  | 3 | mL | Collection Container/Tube: Clean, plastic urine collection container Submission Container/Tube: Plastic, 10-mL urine tube (Supply T068) or clean, plastic aliquot container with no metal cap or glued insert [NAME]: 3 mL Collection Instructions:  1. Collect a random urine specimen. 2. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. Additional Information: High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours. | 0.8 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | > or =16 years: 0.1-1.3 mcg/g creatinine Reference values have not been established for patients that are <16 years of age. | Tuesday, Thursday; 3 p.m. | 1 day | 5 days |  | Profile |  |  |  |  | Rochester
MNCRU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
MNCRU | Component | [NAME] | Manganese/Creatinine Ratio, [NAME] | Manganese/Creat Ratio, U | Only orderable as part of a profile. For further information see #60027 Manganese/Creatinine Ratio, Random, [NAME] |  |  |  |  |  | Only orderable as part of a profile. For further information see #60027 Manganese/Creatinine Ratio, Random, [NAME] |  |  | Only orderable as part of a profile. For further information see #60027 Manganese/Creatinine Ratio, Random, [NAME] |  |  |  | 1 | 83785 |  |  | Yes | No
[NAME] | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
[NAME] | Result | 32867 | Manganese/Creat Ratio, U | Manganese/Creat Ratio, U | Numeric |  |  |  |  | mcg/g |  |  |  |  |  |  |  |  |  | In Process
[NAME] | Result | 32882 | Mn Concentration | Mn Concentration | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | In Process
MNCRU | Component | CDCR | [NAME] | [NAME] | Only orderable as part of a profile. For further information see CTU / Creatinine, [NAME]. |  |  |  | 5 | mL | Only orderable as part of a profile. For further information see CTU / Creatinine, [NAME]. |  |  |  |  |  |  |  |  |  |  | Yes | No
CDCR | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 30 days
CDCR | Result | CDCR | [NAME] | [NAME] | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 35674-1 | Creatinine:MCnc:XXX:[NAME]:Qn:
Spreadsheet: 10fafd97-41b2-44bb-8414-0339270ddb87
Sheet: Sheet1

Unnamed: 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
A | A1 | A2 | A3 | A4 | A5 | A6 | A7 | A8 | A9 | A10 | A11 | A12
B | a | 111124 |  |  | d |  |  |  |  |  |  | B12
C | C1 | test |  |  |  |  |  |  |  |  |  | C12
D | D1 |  | dd |  |  |  |  |  |  |  |  | D12
E | aaa |  |  |  |  |  |  |  |  |  |  | E12
F | F1 |  |  |  |  |  |  |  |  |  |  | F12
G | [NAME] |  |  |  |  |  |  |  |  |  |  | G12
H | H1 | H2 | H3 | H4 | H5 | H6 | H7 | H8 | H9 | H10 | H11 | H12
Column | Row | Location | ID
A | 1 | A1 | A1
B | 1 | B1 | a
C | 1 | C1 | C1
D | 1 | D1 | D1
E | 1 | E1 | aaa
F | 1 | F1 | F1
G | 1 | [NAME] | [NAME]
H | 1 | H1 | H1
A | 2 | A2 | A2
B | 2 | B2 | 111124
C | 2 | C2 | test
D | 2 | D2 | 0
E | 2 | E2 | 0
F | 2 | F2 | 0
G | 2 | G2 | 0
H | 2 | H2 | H2
A | 3 | A3 | A3
B | 3 | B3 | 0
C | 3 | [NAME] | 0
D | 3 | D3 | dd
E | 3 | E3 | 0
F | 3 | F3 | 0
G | 3 | G3 | 0
H | 3 | H3 | H3
A | 4 | A4 | A4
B | 4 | B4 | 0
C | 4 | C4 | 0
D | 4 | D4 | 0
E | 4 | E4 | 0
F | 4 | F4 | 0
G | 4 | G4 | 0
H | 4 | H4 | H4
A | 5 | A5 | A5
B | 5 | B5 | d
C | 5 | C5 | 0
D | 5 | D5 | 0
E | 5 | E5 | 0
F | 5 | F5 | 0
G | 5 | G5 | 0
H | 5 | H5 | H5
A | 6 | A6 | A6
B | 6 | B6 | 0
C | 6 | C6 | 0
D | 6 | D6 | 0
E | 6 | E6 | 0
F | 6 | F6 | 0
G | 6 | G6 | 0
H | 6 | H6 | H6
A | 7 | A7 | A7
B | 7 | B7 | 0
C | 7 | C7 | 0
D | 7 | D7 | 0
E | 7 | E7 | 0
F | 7 | F7 | 0
G | 7 | G7 | 0
H | 7 | H7 | H7
A | 8 | A8 | A8
B | 8 | B8 | 0
C | 8 | C8 | 0
D | 8 | D8 | 0
E | 8 | E8 | 0
F | 8 | F8 | 0
G | 8 | G8 | 0
H | 8 | H8 | H8
A | 9 | A9 | A9
B | 9 | B9 | 0
C | 9 | C9 | 0
D | 9 | D9 | 0
E | 9 | E9 | 0
F | 9 | F9 | 0
G | 9 | G9 | 0
H | 9 | H9 | H9
A | 10 | A10 | A10
B | 10 | B10 | 0
C | 10 | C10 | 0
D | 10 | D10 | 0
E | 10 | E10 | 0
F | 10 | [NAME] | 0
G | 10 | G10 | 0
H | 10 | H10 | H10
A | 11 | A11 | A11
B | 11 | B11 | 0
C | 11 | C11 | 0
D | 11 | D11 | 0
E | 11 | E11 | 0
F | 11 | F11 | 0
G | 11 | G11 | 0
H | 11 | H11 | H11
A | 12 | A12 | A12
B | 12 | B12 | B12
C | 12 | C12 | C12
D | 12 | D12 | D12
E | 12 | E12 | E12
F | 12 | F12 | F12
G | 12 | G12 | G12
H | 12 | H12 | H12
Spreadsheet: 687542d1595267431-lookup-formula-to-output-all-values-tied-to-one-value-lookup-formula-to-output-matching-projects-2-
Sheet: Results

Project:
PR556000
Project Num | WO Num | Location | Submit Date
PR556000 | WO 3444 | Palm Springs | 2020-03-01 00:00:00
PR556000 | WO 3444 | Palm Springs | 2020-03-02 00:00:00
PR556000 | WO 3444 | Palm Springs | 2020-03-03 00:00:00
PR556000 | WO 3444 | Palm Springs | 2020-03-04 00:00:00
PR556000 | WO 3444 | Palm Springs | 2020-03-05 00:00:00
PR556000 | WO 3444 | Palm Springs | 2020-03-06 00:00:00
PR556000 | WO 3444 | Palm Springs | 2020-03-02 00:00:00
PR556000 | WO 3444 | Palm Springs | 2020-03-03 00:00:00
PR556000 | WO 3444 | Palm Springs | 2020-03-04 00:00:00
PR556000 | WO 3444 | Palm Springs | 2020-03-05 00:00:00
PR556000 | WO 3444 | Palm Springs | 2020-03-06 00:00:00
Spreadsheet: 148635d1333488297-pivot-table-editting-options-example-2
Sheet: Sheet1

Store # | Street | City | State | Zip | qty
7 | 1 abc road | generic town | ny | 55555
9 | 2 abc road | generic town | ny | 55555
11 | 3 abc road | generic town | ny | 55555
14 | 4 abc road | generic town | ny | 55555
23 | 5 abc road | generic town | ny | 55555
24 | 6 abc road | generic town | ny | 55555
25 | 7 abc road | generic town | ny | 55555
26 | 8 abc road | generic town | ny | 55555
32 | 9 abc road | generic town | ny | 55555
34 | 10 abc road | generic town | ny | 55555
35 | 11 abc road | generic town | ny | 55555
36 | 12 abc road | generic town | ny | 55555
38 | 13 abc road | generic town | ny | 55555
41 | 14 abc road | generic town | ny | 55555
44 | 15 abc road | generic town | ny | 55555
45 | 16 abc road | generic town | ny | 55555
47 | 17 abc road | generic town | ny | 55555
48 | 18 abc road | generic town | ny | 55555
49 | 19 abc road | generic town | ny | 55555
51 | 20 abc road | generic town | ny | 55555
55 | 21 abc road | generic town | ny | 55555
59 | 22 abc road | generic town | ny | 55555
60 | 23 abc road | generic town | ny | 55555
62 | 24 abc road | generic town | ny | 55555
63 | 25 abc road | generic town | ny | 55555
64 | 26 abc road | generic town | ny | 55555
65 | 27 abc road | generic town | ny | 55555
66 | 28 abc road | generic town | ny | 55555
67 | 29 abc road | generic town | ny | 55555
68 | 30 abc road | generic town | ny | 55555
71 | 31 abc road | generic town | ny | 55555
72 | 32 abc road | generic town | ny | 55555
75 | 33 abc road | generic town | ny | 55555
76 | 34 abc road | generic town | ny | 55555
80 | 35 abc road | generic town | ny | 55555
83 | 36 abc road | generic town | ny | 55555
84 | 37 abc road | generic town | ny | 55555
85 | 38 abc road | generic town | ny | 55555
86 | 39 abc road | generic town | ny | 55555
87 | 40 abc road | generic town | ny | 55555
88 | 41 abc road | generic town | ny | 55555
91 | 42 abc road | generic town | ny | 55555
101 | 43 abc road | generic town | ny | 55555
102 | 44 abc road | generic town | ny | 55555
103 | 45 abc road | generic town | ny | 55555
106 | 46 abc road | generic town | ny | 55555
107 | 47 abc road | generic town | ny | 55555
108 | 48 abc road | generic town | ny | 55555
111 | 49 abc road | generic town | ny | 55555
113 | 50 abc road | generic town | ny | 55555
117 | 51 abc road | generic town | ny | 55555
120 | 52 abc road | generic town | ny | 55555