tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 863056d1710613899-need-help-with-formula-or-function-pulling-data-to-another-tab-copy-of-2023-budget-031024
Sheet: Expenses-Year

 |  | Expenses | 2023-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Total | Average
Payments |  | Monthly totals:
 |  | CCard
 |  | Fees
 |  | Tickets
 |  | Subs
 |  | Misc
Bank |  | Monthly totals:
 |  | Withdrawl
 |  | ATM
 |  | Overdraft
Loans |  | Monthly totals:
 |  | Equity
 |  | SLoans
Save |  | Monthly totals:
 |  | 401k
 |  | HYield
 |  | Acorns
 |  | Stash
 |  | Rhood
 |  | Auto
 |  | Funds
Home |  | Monthly totals:
 |  | Appliances
 |  | Insurance
 |  | Power
 |  | Trash/Recy
 |  | Water
 |  | Phone
 |  | Cable
 |  | Taxes
 |  | Misc
Food |  | Monthly totals:
 |  | Grocery
 |  | Dine
 |  | Coffee
 |  | Vending
 |  | Store
 |  | Misc
Travel |  | Monthly totals:
 |  | Fuel
 |  | Auto
 |  | Insurance
 |  | Plane
 |  | Cab
 |  | Misc
Shop |  | Monthly totals:
 |  | Costco
 |  | Target
 |  | Clothes
 |  | Olivia
 |  | Gifts
 |  | Fun
 |  | Store
 |  | Misc
Medical |  | Monthly totals:
 |  | Doc
 |  | Dental
 |  | Drugs
 |  | Therapy
 |  | Insurance
 |  | Membership
Pets |  | Monthly totals:
 |  | Food
 |  | Vet
 |  | Nails
 |  | Treats
Spending Misc |  | Monthly totals:
 |  | Misc
TOTAL |  | Monthly totals:
Spreadsheet: 677136d1589208670-need-some-help-count-specific-range-based-on-specific-cell-reference-sample-range
Sheet: Sheet1

 | Days In Month | Day of Month
 | 19 | 4
 | MPA | Dollars | Units
 |  | 5000 | 20
 |  | Daily Value | Units
Week 1 | 1 | 216 | 12
 | 2 | 216 | 12
 | 3 | 216 | 0
 | 4 | 198293.6339431157 | 11
 | 5 | 198293.6339431157
Week 2 | 6 | 216 | 12
 | 7 | 216
 | 8 | 216
 | 9 | 216 | 12
 | 10 | 216 | 12
Week 3 | 11 | 216 | 12
 | 12 | 216
 | 13 | 216 | 12
 | 14 | 216 | 11
 | 15 | 216 | 12
Week 4 | 0 | 0 | 0
 | 16 | 216 | 11
 | 17 | 216
 | 18 | 216 | 11
 | 19 | 216 | 11
Week 5 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
Spreadsheet: 20663df1-99a7-4e95-ba90-be085c7bf10e
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
FMGA | Test | FMGA | [NAME]. [NAME] (MAG) Antibody w/Reflex to MAG-SGPG & MAG, EIA | MAG w/Reflex MAG-SGPG and MAG, EIA | Western Blot (WB) Enzyme Immunoassay (EIA) (if appropriate) | Plain, Red-Top Tube: Red |  |  | 2 | mL | Draw blood in a plain, red-top tube(s). Spin down and send 2 mL of serum refrigerated. Note: 1. Avoid hemolysis          2. Overnight fasting is preferred.          3. Serum gel tube is acceptable, but must pour off into a plastic vial. | 0.6 mL | Specimens other than	Serum Anticoagulants other than	NA Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icteric	NA | MAG Ab (IgM), Western Blot  Reference Range: Negative  MAG-SGPG Ab (IgM), EIA  Reference Range:       < or = 1:1600  MAG Ab (IgM), EIA       <1:1600 Reference ranges for MAG IgM Antibody:    Normal:   <1:1600    Moderately Elevated:  1:1600-1:3200    Highly Elevated:  >1:6400  Test Performed by: Quest Diagnostics/Nichols Institute                               33608 [NAME]                               San Juan Capistrano, CA 92690 | Monday and Wednesday | 5 days | 7-14 days | 1 | 84181 |  |  |  |  | Quest Diagnostics/Nichols Institute
FMGA | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
FMGA | Result | Z2522 | MAG Ab (IgM), Western Blot | MAG Ab (IgM), Western Blot | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FMGA | [NAME] | FMGS | MAG EIA Reflex | MAG EIA Reflex | Only orderable as a reflex from FMGA |  |  |  |  |  | Only orderable as a reflex from FMGA See FMGA MAG w/[NAME] and MAG, EIA |  |  | Only orderable as a reflex from FMGA See FMGA MAG w/[NAME] and MAG, EIA |  |  |  |  | Profile |  |  | No | No
FMGS | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
FMGS | Result | Z2523 | MAG-SGPG Ab (IgM), EIA | MAG-SGPG Ab (IgM), EIA | Numeric |  |  |  |  | titer |  |  |  |  |  |  |  |  |  | In Process
FMGS | Result | [NAME] | MAG Ab (IgM), EIA | MAG Ab (IgM), EIA | Numeric |  |  |  |  | titer |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 605903d1547379932-fill-text-and-count-of-days-based-date-holidays
Sheet: Folha1

Your data | Date | Solution |  |  |  |  | Holidays List
1-Jan Vacation day 1 Holiday 1 | 2019-01-01 00:00:00 |  |  |  |  |  | 2019-01-01 00:00:00
2-Jan Vacation day 2 Vacation day 1 |  |  |  |  |  |  | 2019-01-13 00:00:00
3-Jan Vacation day 3 Vacation day 2 |  |  |  |  |  |  | 2019-01-14 00:00:00
4-Jan Weekend Weekend
5-Jan Weekend Weekend
6-Jan Vacation day 4 Vacation day 3
7-Jan Vacation day 5 Vacation day 4
8-Jan Vacation day 6 Vacation day 5
9-Jan Vacation day 7 Vacation day 6
10-Jan Vacation day 8 Vacation day 7
11-Jan Weekend Weekend
12-Jan Weekend Weekend
13-Jan Vacation day 9 Holiday 2
14-Jan Vacation day 10 Holiday 2
15-Jan Vacation day 11 Vacation day 8
16-Jan Vacation day 12 Vacation day 9
17-Jan Vacation day 13 Vacation day 10
Spreadsheet: 719125d1613512247-weighted-lottery-with-unique-output-weighted-lottery-with-no-duplicates
Sheet: Sheet1

Child | Assigned % | Cumulative % |  | Random Child
1 | 0.05
2 | 0.05
3 | 0.05
4 | 0.1
5 | 0.1
6 | 0.15
7 | 0.2
8 | 0.2
Spreadsheet: 834592d1687934867-i-need-som-help-with-my-excel-sheet-for-risk-management-example
Sheet: Konfigs

 | Hotkategori |  |  |  | [NAME] |  |  |  | Intention |  |  |  |  |  |  |  |  |  |  |  |  |  | PERT Beta Distribution
 | Personalbrist |  |  |  | Medarb (allm) |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E = (O + 4*M + P) / 6
 | Användarfel |  |  |  | Handläggare |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E = Expected amount of time or cost,
 | Handhavandefel |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O = Optimistic estimate,
 | Förvaltningsfel |  |  |  | Extern angripare |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M = Most likely estimate,
 | Leverantörsfel |  |  |  | Intern angripare |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P = Pessimistic estimate.
 | Angrepp
 | Yttre omständigheter |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Standard Deviation = (P – O) / 6
 | Försumlighet
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Exempel skadeuppskattning
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O= | 3000000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M= | 5000000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P= | 8000000
 | Sannoliksnivå | Kolumn1 | Kolumn2 |  | Konsekvensnivå | Kolumn1 | Kolumn2 |  | Exponeringsnivå | Kolumn1 |  | Risknivå |  | Riskbeslut |  |  |  |  |  |  |  |  |  | E=
 |  | 0 | 0.099 |  |  | 0 | 99 |  | Låg (Rv -1) | -1 |  | 1 |  | [NAME] accepteras
 |  | 0.1 | 0.99 |  |  | 100 | 999 |  | Måttlig (Rv +0) | 0 |  | 2 |  | [NAME] accepteras inte |  |  |  |  |  |  |  |  |  | Standardavvikelse |  | Låg | Hög
 |  | 1 | 9.99 |  |  | 1000 | 4999 |  | Hög ([NAME]) | 1 |  | 3 |  |  |  |  |  |  |  |  |  |  |  | 1σ (68.3%)=
 |  | 10 | 100 |  |  | 5000 |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  | 2σ (95.5%)=
 |  | 100 |  |  | Anpassat, se motivering |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  | 3σ (99.7%)=
 | Anpassat, se motivering |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  | 9
 |  | Mycket låg | Låg | Måttlig | Hög | Mycket hög |  |  |  |  |  |  |  |  | Mycket låg | Låg | Måttlig | Hög | Mycket hög
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Mycket allvarlig | 4 | 5 | 6 | 7 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Allvarlig | 3 | 4 | 5 | 6 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Måttlig | 2 | 3 | 4 | 5 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Ringa | 1 | 2 | 3 | 4 | 5
Spreadsheet: 710050d1608688174-bring-scattered-data-to-correct-columns-samplebook1
Sheet: Sheet1

ID | Q8_1 | [NAME] | Q8_3 | Q8_4 | Q8_5 | Q8_6 | [NAME] | Q8_8 | Q8_9 | Q8_10 | Q8_11 | [NAME] |  | 1 | 3
1 | 1 | 2 |  |  |  |  |  |  |  |  |  |  | 1 | 0.5 | 2
2 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  | 11 |  | 3 | less 50% | 1
3 | 1 |  |  | 4 | 5 |  | 7 | 8 |  |  |  |  | 2
4 | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  |  |  | 2
5 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  | 3
6 | 1 |  |  | 4 | 5 | 6 | 7 | 8 |  |  |  |  | 2
7 | 1 | 2 | 4 | 5 | 6 | 8 | 9 | 10 | 11 |  |  |  | 2
8 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  | 3
9 | 1 | 4 | 5 | 9 | 10 |  |  |  |  |  |  |  | 2
10 | 1 | 2 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  |  |  | 2
Spreadsheet: 845148d1696668906-formula-difficulties-for-aussie-timesheet-test-test-test
Sheet: Sheet1

Friday |  |  | Saturday |  |  | Sunday
Time In | Time Out | HRS | Time In | Time Out | HRS | Time In | Time Out | HRS | Total | [NAME] | Toil/OT
07:30:00 | 14:00:00
10:00:00 | 17:30:00
Friday |  |  | Saturday |  |  | Sunday
Time In | Time Out | HRS | Time In | Time Out | HRS | Time In | Time Out | HRS | Total | [NAME] | Toil/OT
07:30:00 | 14:00:00
 |  |  |  |  |  | 07:00:00 | 14:00:00
10:00:00 | 17:30:00 |  |  |  |  | 07:30:00 | 19:29:00
Spreadsheet: michelle_lokay__26797__sharris0700wk1
Sheet: Actuals V. Plan

Transwestern Pipeline Company
($[NAME])
 |  | July, 2000
 |  | Plan | Estmate | [NAME] |  | Comments
West Demand Revenues |  |  |  |  |  | Rates for 63/day in excess of $0.12/mmbtu in plan
West Commodity Revenues |  |  |  |  |  | Assumes 860/day west through the 8th, then flows similar to June for the remainder of the month.
East Demand Revenues |  |  |  |  |  | Burlington 24216--($53k), [NAME])
East Commodity Revenues
[NAME]
[NAME] Revenues |  |  |  |  |  | assumes IT volumes and rates similar to June.
 |  | ------------- | ------------- | -------------
Revenue Variance
[NAME] due to Price |  |  |  |  |  | Current index price of $4.11
[NAME] due to transport volumes |  |  |  |  |  | Assumes fuel use similar to June
Hedging Adjustment
Unaccounted for Variance
 |  |  |  | -------------
Fuel Variance
 |  |  |  | -------------
TOTAL MONTH-TO-DATE VARIANCE
 |  |  |  | ========
[NAME]
 |  | Year-to-Date | Year-to-Date | Year-to-Date
 |  | Margin | Fuel & UAF | Total
Plan (throughJune)
Actuals through May, June and July est.
 |  | ------------- | ------------- | -------------
Variance from Plan
 |  | ------------- | ------------- | -------------
Spreadsheet: 734099d1621972401-some-help-needed-with-coding-vllookup-book2
Sheet: Sheet1

Name 1
2021-05-20 00:00:00 |  | 93.04
2021-05-21 00:00:00 |  | 73.94
2021-05-24 00:00:00 |  | 88.86
2021-05-25 00:00:00 |  | 91.79
Totals: |  | 87.19
Name 2
2021-05-24 00:00:00 |  | 97.19
2021-05-25 00:00:00 |  | 97.99
Totals: |  | 97.59
Requried result
Name 1 | 87.19
Name 2 | 97.59
Spreadsheet: darron_c_giron__7978__AGAVE
Sheet: June

Note: Insert the #'s in red to calculate the customer price
 | Crude Merc | IF-Elpaso Perm | IF-HH | IF-Elpaso/SJ | IF-TW-Permian
 | 19.218 | 2.07 | 2.31 | 2.02 | 2.05
 |  |  | Spot price |  | Index Price
CPR# | TAGG # | PanEnergy | Facility | Term | Calculated Price
72678 | E21728 | 2,500/day | 813780 | 7/95-12/2001
CPR# | TAGG # | Union Pacific | Facility | Term | Calculated Price
48853 | E11400 | 2,500/day | 813367 | 1/92-12/2003
CPR# | TAGG # | Union Pacific | Facility | Term | Calculated Price
3217 | E22656 | 7,000/day | 813367 | 1/95-12/2001
CPR# | TAGG # | Vastar | Facility | Term | Calculated Price
3231 | E21977 | 10,000/day | 501079 | 6/96-4/2002
CPR# | TAGG # | Agave/Yates | Facility | Term | Calculated Price
93788 | E20337 | 10,000/day | 58649 | 1/93-12/2002
Spreadsheet: tracy_geaccone__40255__C0366-111727
Sheet: Dept_100196

ENRON PROPERTY & SERVICES CORP
1400 Smith Street
Houston, Texas   77251 - 1188
MONTHLY INVOICE DETAIL
PARKING - Dept. 100196
May, 2001
0366  EOC - Executive
Date | Ticket Number | Work Order | Service Name | Service Description | # [NAME] | Unit Cost | UOM | Service | Ticket
 |  |  |  |  |  |  |  | Total | Total
 |  |  | R/C 111727
2001-05-18 00:00:00 | PAR05/01-05212 |  | Enron GEACCONE,[NAME] | Yellow | 1 | 55.76 | /EACH | 55.76
 |  |  |  |  |  |  | Ticket Total |  | 55.76
 |  |  |  |  |  |  | Total for R/C: 111727 |  | 55.76
 |  |  |  |  |  |  | Total for Dept_100196 |  | 55.76
Spreadsheet: 14b279d4-53c0-43b1-98b6-4914c827decb
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
 | Time Series Workbook
 | 5302.0 Balance of Payments and International Investment Position, Australia
 | TABLE 83. EXCHANGE RATES - FINANCIAL YEAR
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
United States Dollar ;  Period average ; |  |  | Original | A3604466X | 1960-06-01 00:00:00 | 2011-06-01 00:00:00 | 52 | $ | INDEX | Annual | 6
United Kingdom Pound ;  Period average ; |  |  | Original | A3604465W | 1960-06-01 00:00:00 | 2011-06-01 00:00:00 | 52 | $ | INDEX | Annual | 6
Euro ;  Period average ; |  |  | Original | A3604467A | 1960-06-01 00:00:00 | 2011-06-01 00:00:00 | 52 | $ | INDEX | Annual | 6
[NAME] ;  Period average ; |  |  | Original | A3604463T | 1960-06-01 00:00:00 | 2011-06-01 00:00:00 | 52 | $ | INDEX | Annual | 6
Special Drawing Rights ;  Period average ; |  |  | Original | A3604468C | 1960-06-01 00:00:00 | 2011-06-01 00:00:00 | 52 | $ | INDEX | Annual | 6
United States Dollar ;  End of period ; |  |  | Original | A3605367K | 1960-06-01 00:00:00 | 2011-06-01 00:00:00 | 52 | $ | INDEX | Annual | 6
United Kingdom Pound ;  End of period ; |  |  | Original | A3605364C | 1960-06-01 00:00:00 | 2011-06-01 00:00:00 | 52 | $ | INDEX | Annual | 6
Euro ;  End of period ; |  |  | Original | A3605363A | 1960-06-01 00:00:00 | 2011-06-01 00:00:00 | 52 | $ | INDEX | Annual | 6
[NAME] ;  End of period ; |  |  | Original | A3605365F | 1960-06-01 00:00:00 | 2011-06-01 00:00:00 | 52 | $ | INDEX | Annual | 6
Special Drawing Rights ;  End of period ; |  |  | Original | A3605368L | 1960-06-01 00:00:00 | 2011-06-01 00:00:00 | 52 | $ | INDEX | Annual | 6
Trade Weighted Index ;  Period average ; |  |  | Original | A3604464V | 1960-06-01 00:00:00 | 2011-06-01 00:00:00 | 52 | Index Numbers | INDEX | Annual | 6
Trade Weighted Index ;  End of period ; |  |  | Original | A3605366J | 1960-06-01 00:00:00 | 2011-06-01 00:00:00 | 52 | Index Numbers | INDEX | Annual | 6
© Commonwealth of Australia  2012
Spreadsheet: 847439d1698362595-retrieve-multiple-results-sample-copy-multi
Sheet: Sheet1

Item | PO | Quantity
1 | A | 5
2 | A | 7
3 | A | 9
4 | A | 3
5 | A | 5
2 | B | 8
5 | B | 2
4 | C | 4
2 | C | 5
3 | D | 2
1 | D | 1
Spreadsheet: darrell_schoolcraft__7873__011018Da
Sheet: LetterSizeRegionLoc 

ETS Planned And Unplanned Outages - May 1, 2001 Through May 31, 2002
Dakota Region Only - Sorted By Region/Location
The information provided is tentative and may be changed without further notice.  Northern Natural Gas, [NAME] and Florida Gas Transmission are not responsible for any reliance on this information.
Data Extracted October 18, 2001 |  |  |  |  |  |  |  |  |  |  | Est. Flow | Est. Vol. |  |  | Act. | Act. | Act. | Act.
No. | ID# | Location | Units | Title | EstStart | EstComp | Duration | Line | Proj. Mgr | W.O. # | Affected | Affected | DescOfWork | DescOfWork2 | Start | Compl. | [NAME]. | Throughput | P/U | Pub | Ver
 |  |  |  |  |  |  |  |  |  |  | (Mmcfd) |  |  |  |  |  | mmcf/d | Affect
1 | 16073 | SO SIOUX | WAYNE CREEK | [NAME] | 2001-10-08 08:00:00 | 2001-10-25 16:00:00 | 17.3 | NEB57001 | 453 | C.014559 | 0 | 0 | Replace and lower approximately 900 feet of the 4" [NAME] at the Logan Creek crossing. |  |  |  | 0 |  | P | N | N
2 | 16074 | SO SIOUX | AKRON BL | AKRON BL | 2001-10-29 08:00:00 | 2001-11-08 16:00:00 | 10.3 | IAB72901 | 453 | C.014588 | 0 | 0 | Replace and lower approximately 60 ft of the 3" and 600' of the 6" Akron BL at the Big Sioux River Crossing MP 6.99. Affects IAB72901 & SDB94401 |  |  |  | 0 |  | P | N | N
Spreadsheet: 880998d1728901518-need-help-to-make-fifo-calculation-more-efficient-fifo_model_for_many_products_no_vba_v5
Sheet: multiple products

 |  |  | INVENTORY MODEL. FIFO CALCULATION. MULTIPLE  SKUs!!!!!!!
 |  |  |  | Purchase |  |  | Usage |  |  |  | Closing balance
 |  |  | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | Quantity | Value | Unit price
 |  |  | A
 |  |  | B
 | INSERT ROWS |  | X
 |  |  | C
 |  |  | Total |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INVENTORY SPLIT BY FIFO
 |  |  | Purchase |  |  |  | Usage |  |  |  |  |  |  |  | ONLY FOR EXCEL GEEKS & NERDS!!! |  |  |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total
 | SKU/ID | ID | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price |  |  |  |  | Technical column 1 | Technical column 2 | Technical column 3 | Value | Value with validation |  | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price
 |  |  |  | 0 | 0 | 0 | do not amend this row, ANYWHERE!!! |  |  |  |  |  |  |  | do not amend this row, ANYWHERE!!!
 |  |  |  | 0 | 0 |  | do not amend this row, ANYWHERE!!! |  |  |  |  |  |  |  | do not amend this row, ANYWHERE!!!
 |  | 1 | A | 3 | 100 |  | A | 1
 |  |  | A | 6 | 100 |  | A | 4
 |  |  | B | 12 | 20 |  | A | 1
 |  |  | A | 7 | 7 |  | A | 8
 |  |  | A | 8 | 64 |  | B | 10
 |  |  | A | 6 | 1 |  | B | 1
 |  |  | B | 2 | 1 |  | A | 12
 |  |  | A | 2 | 4 |  |  | 12
 |  |  | A | 1 | 10 |  |  | 12
 |  |  | A | 12 | 0 |  |  | 12
 |  |  | A | 0 | 0 |  | B | 1
 |  |  | A | 0 | 0
 |  |  | A | 0 | 0
 |  |  | A | 0 | 0
 |  |  | C | 10 | 150
 |  |  | C | 12 | 123
 |  |  | X | 9 | 100
 |  |  | X | 8 | 90
 |  |  | X | 12 | 80
 |  |  | X | 15 | 70 |  | X | 36
 |  |  |  |  |  |  |  |  |  |  |  | AND THEN COPY FORMULA
 |  |  |  |  |  |  |  |  |  |  |  | FROM ROW 34
 |  | 1000 | C | 1 | 9 |  | C | 21
Spreadsheet: 111300d1307698205-league-table-lookup-football
Sheet: Sheet2

jan | feb | [NAME] | apr | may | jun | jul | aug | sep | oct | nov
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 4
1 | 1 | 1 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 4
1 | 1 | 1 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 4
1 | 1 | 1 | 1 | 1 | 6 | 1 | 1 | 1 | 1 | 4
 |  |  |  |  |  | #N/A
Jun
Spreadsheet: 800814d1665901004-facing-date-error-in-formula-when-new-data-is-pasted-formula-mistake-from-n-to-r-to-correct
Sheet: 2B

[NAME] of supplier | TALLY DATE | INVOICE DATE | Invoice number | VOUCHER NO. | Trade/Legal name | Invoice Value | 0 | 3 | 5 | 12 | 18 | 28 | 3 | 5 | 12 | 18 | 28 | 1.5 | 1.5 | 2.5 | 2.5 | 6 | 6 | 9 | 9 | 14 | 14 | 3 | 5 | 12 | 18 | 28 | Round Off | Filing Date
Spreadsheet: ae085039-004d-401f-a395-e3b98d66f583
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | PolyPhen-2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | SIFT | Unnamed: 7
 |  | probably damaging | possibly damaging | benign | unknown | damaging | tolerated
DM | all | 71.79839184153755 | 11.78662482839773 | 14.56494737530235 | 1.850035954762372 | 72.18574426318284 | 27.81425573681717
 | OR | 74.8663101604278 | 11.03776737967915 | 12.94284759358289 | 1.15307486631016 | 74.39003287766049 | 25.6099671223395
 | O→O | 74.74081883675979 | 11.12282551396943 | 13.00298717272887 | 1.133368476541908 | 74.29039301310044 | 25.70960698689956
 | O→D | 77.3037542662116 | 9.385665529010238 | 11.77474402730375 | 1.535836177474403 | 76.32508833922262 | 23.67491166077738
 | IDR | 60.76899969960949 | 14.47882246920997 | 20.39651547011115 | 4.35566236106939 | 64.26127527216174 | 35.73872472783825
 | D→D | 57.24990633195953 | 15.21168977144998 | 22.70513300861746 | 4.833270887973024 | 61.83087664856478 | 38.16912335143522
 | D→O | 75 | 11.51515151515152 | 11.06060606060606 | 2.424242424242424 | 74.09733124018838 | 25.90266875981161
Poly | all | 24.82353941661706 | 15.63908495620376 | 54.4689174249511 | 5.068458202228081 | 24.43901355254388 | 75.56098644745613
 | OR | 27.50463160894969 | 15.35556505629186 | 53.74091492090637 | 3.398888413852073 | 26.46511281554844 | 73.53488718445156
 | O→O | 27.58077816927806 | 15.33098433165904 | 53.74465852012894 | 3.343578978933953 | 26.7350775497415 | 73.2649224502585
 | O→D | 26.19392185238784 | 15.34008683068017 | 53.97973950795948 | 4.486251808972503 | 21.26696832579185 | 78.73303167420815
 | IDR | 20.85617882749894 | 16.05862505272037 | 55.54618304512864 | 7.539013074652045 | 21.34708205353225 | 78.65291794646775
 | D→D | 19.36636493568366 | 15.87660790852787 | 56.7770366841353 | 7.979990471653169 | 19.80555901782376 | 80.19444098217625
 | D->O | 32.35294117647059 | 17.46323529411764 | 46.04779411764706 | 4.136029411764706 | 33.90313390313391 | 66.0968660968661
NES | all | 8.278623549259132 | 8.359926014756397 | 78.13166934287283 | 5.229781093111648 | 10.47543035426001 | 89.52456964573999
 | OR | 9.110923568047555 | 8.25230249880747 | 80.1966755953473 | 2.440098337797674 | 12.12758269552935 | 87.87241730447064
 | O→O | 9.062003179650238 | 8.201171041917096 | 80.40249718872387 | 2.33432858970879 | 12.18808646694933 | 87.81191353305067
 | O→D | 9.972677595628415 | 9.153005464480875 | 76.57103825136612 | 4.30327868852459 | 11.08448172558418 | 88.91551827441582
 | IDR | 7.245056046659984 | 8.493575138977489 | 75.56730155837054 | 8.69406725599198 | 8.43798104188609 | 91.56201895811391
 | D→D | 6.803121778824915 | 8.37382810582634 | 75.75222107691553 | 9.07082903843322 | 7.855552159294355 | 92.14444784070565
 | D->O | 12.94416243654822 | 10.0253807106599 | 73.03299492385787 | 3.997461928934011 | 15.91036414565826 | 84.08963585434174
Spreadsheet: 174458d1345062020-pivot-table-setup-pt-example-blank-yes
Sheet: Sheet1

Sum of Amount | Column Labels
Row Labels | Yes | (blank) | Grand Total
1931-06-01 00:00:00 | 1988.09 |  | 1988.09
2012-06-07 00:00:00 | 1996.74 |  | 1996.74
2012-06-08 00:00:00 | 3503.17 |  | 3503.17
2012-06-12 00:00:00 | 1794.05 |  | 1794.05
2012-06-14 00:00:00 | 3611.38 |  | 3611.38
2012-06-18 00:00:00 | 1929.51 |  | 1929.51
2012-06-19 00:00:00 | 4360.99 |  | 4360.99
2012-06-20 00:00:00 | 10166.87 |  | 10166.87
2012-06-28 00:00:00 | 22921.02 |  | 22921.02
2012-06-29 00:00:00 | 1559.6 |  | 1559.6
2012-06-30 00:00:00 | 1080.8 |  | 1080.8
2012-07-01 00:00:00 | 1341.55 |  | 1341.55
2012-07-02 00:00:00 | 856.3299999999999 |  | 856.3299999999999
2012-07-03 00:00:00 | 2569.65 |  | 2569.65
2012-07-04 00:00:00 | 692.89 |  | 692.89
2012-07-09 00:00:00 | 981 |  | 981
2012-07-14 00:00:00 | 10939.96 |  | 10939.96
2012-07-26 00:00:00 | 721.2 |  | 721.2
2012-08-04 00:00:00 | 704.28 |  | 704.28
2012-08-05 00:00:00 | 1322 |  | 1322
(blank) |  | 487926.4 | 487926.4
Grand Total | 75041.08 | 487926.4 | 562967.48
Spreadsheet: 737755d1624572941-conditionally-format-multiple-values-book2
Sheet: Conditional_FOrmat

 | Item | Price | Sydney |  |  | Regional
 |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Dairy | 1 to 10 | 100 | 120 | 150 | 80 | 100 | 120
 | Dairy | 10 to 20 | 70 | 100 | 120 | 75 | 90 | 110
 | Dairy | 20 to 30 | 50 | 60 | 70 | 70 | 85 | 105
 | Meat | 1 to 10 | 120 | 144 | 180 | 84 | 105 | 126
 | Meat | 10 to 20 | 84 | 120 | 144 | 78 | 94 | 115
 | Meat | 20 to 30 | 60 | 72 | 84 | 73 | 89 | 110
 | Project Type | Price | Location | Location
 | Dairy | 25 | [NAME] | Regional
Spreadsheet: 801693d1666303067-vlookup-seek-two-values-return-a-third-zone-open-order-report-with-priorities-test
Sheet: Available

ITEM_NUMBER |  | Warehouse | ONHAND | ALLOCATED | Available
3826C002 |  | C01 | 2 |  | 2
4032C001 |  |  | 3 | 3 | 0
5358C001 |  |  | 6 |  | 6
2368V120 |  |  | 61 | 34 | 27
3763C003 |  |  | 16 | 8 | 8
3767C003 |  |  | 2 | 1 | 1
3768C003 |  |  | 2 |  | 2
3769C003 |  |  | 2 |  | 2
3631C001 |  |  | 94 |  | 94
3526C001 |  |  | 1 |  | 1
3631C001 |  |  | 19 | 1 | 18
3526C001 |  |  | 48 | 48 | 0
5160C002 |  |  | 1 | 1 | 0
3242C001 |  |  | 3 | 2 | 1
5226C001 |  |  | 2 | 2 | 0
8929B001 |  |  | 2 | 2 | 0
5261C001 |  |  | 1 |  | 1
1135C002 |  |  | 1 | 1 | 0
3057V762 |  |  | 1 |  | 1