tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 31450d1227283016-multiple-sort-a-group-of-cells-on-same-worksheet-racing-team-fixed-
Sheet: Rankings

 | 2008 MCRT Points Standings
 | STREET MOD
 | Handle | Points | Visits
 |  | 109 | 3
 |  | 150 | 3
 |  | 108 | 3
 | TRACK MOD
 | Handle | Points | Visits
 | JimC | 181 | 5
 | Brumby | 63 | 5
 | [NAME] | 0
 | [NAME] | 0
 | bscottie | 0
 | jaybo | 0
 | 70Camaro | 0
 | Ranebowcyxx | 0
 | Joeymustang | 0
 | PRO MOD
 | Handle | Points | Visits
 |  | 157 | 2
 |  | 3 | 1
 |  | 80 | 2
Spreadsheet: 226723d1365496672-searching-a-column-for-text-any-text-and-if-its-there-place-it-in-a-specific-cell-example-for-forum2
Sheet: Sheet1

 |  |  | BUYS |  |  | SELLS
 |  | 1 | any text in O column |  | 1 | any text in R column
 |  |  |  |  |  |  |  |  |  |  | .3 - 2 | .2 - 1 |  | MAX | 2nd Big | 3rd Big | 4th Big | 5th Big | 6th Big
 |  | 2 | any text in P column |  | 2 | any text in S column |  |  |  |  | -1.497005988023952 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0.8957133717210494
 |  | 3 | any text in Q column |  | 3 | any text in T column |  |  |  |  | 0.4975124378109453 | 0.9950248756218906 |  |  |  |  |  | AGO
 |  |  |  |  |  |  |  |  |  |  | -2.259887005649718 | 3.389830508474576 |  | AIO
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | -0.09775171065493646
 |  |  |  |  |  |  |  |  |  |  | 0 | -0.2139037433155082
 |  |  |  |  |  |  |  |  |  |  | -0.196078431372549 | 0.5882352941176471
 |  |  |  |  |  |  |  |  |  |  | 0.3853564547206163 | -1.027617212588311
 |  |  |  |  |  |  |  |  |  |  | 0 | 0.4684684684684685
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0.0277623542476402 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0.3225806451612903
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0.7672634271099744
 |  |  |  |  |  |  |  |  |  |  | 0.2979145978152929 | -0.397219463753724
 |  |  |  |  |  |  |  |  |  |  | -0.4342431761786602 | 0.8064516129032259
 |  |  |  |  |  |  |  |  |  |  | 0 | 1.02880658436214 |  |  |  | BLD
 |  |  |  |  |  |  |  |  |  |  | 0 | -0.2114164904862579
 |  |  |  |  |  |  |  |  |  |  | 0 | 1.45985401459854 |  |  | BPT
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CSL
Spreadsheet: 808267d1670374608-solved-how-to-create-a-formula-if-cells-contain-anything-do-this-otherwise-do-nothing-example-workbook
Sheet: Sheet1

Example 1 | Hrs | Name | Hrs | Name | Hrs | Name
Training Supervisor | 8 | Smith | 12 | [NAME] | 12 | [NAME]
Officer Training | 8 | Jones | 12 | Jones | 12 | Jones
Example 1 | Hrs | Name | Hrs | Name | Hrs | Name
Formula 1 | B6 | C6 | D6 | E6 | F6 | G6
Formula 2 | B7 | C7 | D7 | E7 | F7 | G7
Spreadsheet: 742900d1628101009-need-help-with-formula-skipping-blanks-sa1
Sheet: EDECS

 | Daily Progress of Deep Foundation No.: |  |  |  |  |  |  | 1 | Date : |  |  |  |  | 2020-09-28 00:00:00
 | Company  Name | Working Piling Rigs | Idle Piling Rigs | Working Hydro fraise | [NAME] fraise | Working Cranes | Idle Cranes | Type | Type No. | Daily Production | Executed Primary Panels & Piles Type 1 |  |  |  | Executed Secondary Panels & Piles Type 2. | Total Executed To date | Setting Out | Current Drilling | Current RFT | Current Casting | Design No. | Executed % | Remain No. | Remaining  %
 |  |  |  |  |  |  |  |  |  |  | P1 /Type 1 | P7 / Corner | P8 | P9
 | EDECS |  |  | 1 |  | 2 |  | [NAME]Start Date : 28/9/2020 | P1-11
 |  |  |  |  |  |  |  | Barrettes -  Start Date : 21/11/2020
 |  |  | 1 |  |  |  |  | Piles -  Start Date :  28/10/2020
 | Daily Progress of Deep Foundation No.: |  |  |  |  |  |  | 2 | Date : |  |  |  |  | 2020-09-29 00:00:00
 | Company  Name | Working Piling Rigs | Idle Piling Rigs | Working Hydro fraise | [NAME] fraise | Working Cranes | Idle Cranes | Type | Type No. | Daily Production | Executed Primary Panels & Piles Type 1 |  |  |  | Executed Secondary Panels & Piles Type 2. | Total Executed To date | Setting Out | Current Drilling | Current RFT | Current Casting | Design No. | Executed % | Remain No. | Remaining  %
 |  |  |  |  |  |  |  |  |  |  | P1 /Type 1. | P7 / Corner | P8 | P9
 | EDECS |  |  | 1 |  | 2 |  |  | P1-17
 |  |  |  |  |  |  |  | Barrettes | NA-11
 |  |  | 1 |  |  |  |  | Piles | NB-26
 | Daily Progress of Deep Foundation No.: |  |  |  |  |  |  | 3 | Date : |  |  |  |  | 2020-09-30 00:00:00
 | Company  Name | Working Piling Rigs | Idle Piling Rigs | Working Hydro fraise | [NAME] fraise | Working Cranes | Idle Cranes | Type | Type No. | Daily Production | Executed Primary Panels & Piles Type 1 |  |  |  | Executed Secondary Panels & Piles Type 2. | Total Executed To date | Setting Out | Current Drilling | Current RFT | Current Casting | Design No. | Executed % | Remain No. | Remaining  %
 |  |  |  |  |  |  |  |  |  |  | P1 /Type 1. | P7 / Corner | P8 | P9
 | EDECS |  |  | 1 |  | 2 |  |  | s1-13
 |  |  |  |  |  |  |  | Barrettes
 |  |  | 1 |  |  |  |  | Piles
Spreadsheet: 164355d1340732547-using-sumifs-how-to-create-criteria-to-include-if-cell-doesnt-match-specific-data-12-13-budget-test
Sheet: Reference List

Departments |  | Account |  | Program Code |  | Account Code
AG |  | 11000 - 301010 |  | 000000 |  | 231000
ESA |  | 11000 - 301020 |  | 010200 |  | 241000
BIOL |  | 11000 - 301030 |  | 010210 |  | 431000
CHEM |  | 17800 - 301010 |  | 010900 |  | 433000
MCS |  | NO FUNDS GRANTED |  | 040100 |  | 441000
PENG |  | POD FUNDS |  | 220200 |  | 451000
GRANTS |  | SPECIAL FUND |  | 083700 |  | 471000
 |  | Animal |  | 043000 |  | 521000
Months |  | Anthropology |  | 190500 |  | 522000
Jan |  | Biology |  | 191100 |  | 525000
Feb |  | Chemistry |  | 191400 |  | 531000
Mar |  | Earth Sciences |  | 191900 |  | 554500
April |  | Horticulture |  | 170100 |  | 564000
May |  | Math |  | 070600 |  | 564500
Jun |  | NSD |  | 190100 |  | 580000
July |  | Physics Engineering |  | 090100 |  | 581000
Aug |  | RVT |  | 601000 |  | 589000
Sep |  | Wildlife |  |  |  | 589010
Oct |  | Student-Budget Holding |  |  |  | 641200
Nov |  |  |  |  |  | 641300
Dec |  | Student Accounts |  |  |  | 641400
 |  | Animal |  |  |  | 641500
Rates |  | Anthropology |  |  |  | 641600
8 |  | Biology |  |  |  | 641700
8.75 |  | Chemistry |  |  |  | 642200
10 |  | Earth Sciences |  |  |  | 642300
11.25 |  | Horticulture |  |  |  | 642400
12.5 |  | Math |  |  |  | 642500
 |  | NSD |  |  |  | 642600
 |  | Physics Engineering |  |  |  | 642700
 |  | RVT |  |  |  | 643200
 |  | Wildlife |  |  |  | 643300
 |  | Student-Budget Holding |  |  |  | 643400
 |  |  |  |  |  | 643500
 |  |  |  |  |  | 643600
 |  |  |  |  |  | 643700
 |  |  |  |  |  | 644200
 |  |  |  |  |  | 644300
 |  |  |  |  |  | 644400
 |  |  |  |  |  | 645200
 |  |  |  |  |  | 645300
 |  |  |  |  |  | 645300
 |  |  |  |  |  | 645400
Spreadsheet: mark_whitt__25164__Mini-Book
Sheet: Summary

Counterparty | Buy or [NAME]? | Start Date | End Date | Volume (MMBtu/d) | Delivery Point | Pricing | Contract Value | [NAME] | Comments
Kennedy Oil | Buy | 2001-12-01 00:00:00 | 2003-10-31 00:00:00 | 10000 | Glenrock | IF NGPL Midcontinent - $0.47 | 570482
 | Buy | 2001-12-01 00:00:00 | 2003-10-31 00:00:00 | 5000 | Glenrock | NYMEX - $0.62 | 265183
 | Buy | 2001-12-01 00:00:00 | 2003-10-31 00:00:00 | 80% of Nom. less 15,000 | Glenrock | IF CIG - $0.03 | 346100
 | Buy | 2001-12-01 00:00:00 | 2003-10-31 00:00:00 | remaining production |  | CIG GD - $0.03 | 162870
[NAME] | Buy | 2002-06-01 00:00:00 | 2013-05-31 00:00:00 | 42000 | Gage | IF NGPL MidContinent - $0.01 | 6500000
POGO | Buy | current | 2005-08-01 00:00:00 | 15000 | Lost Creek | IF CIG | 875609
 | Buy | current | 2002-08-01 00:00:00 | 7500 | Lost Creek | IF CIG + $0.03 | 151948
[NAME] | Buy | 2002-01-01 00:00:00 | 2002-12-31 00:00:00 | 1.8 Bcf over the year | Lost Creek | IF CIG or CIG GD ([NAME]'s option) | 50000
[NAME] | Buy | current | 2005-10-31 00:00:00 | 10000 | Opal | NYMEX - $0.33 | -748824
 | Sell | current | 2005-10-31 00:00:00 | 10000 | WIC | NYMEX - $0.33 | 747334
Burlington Resources | Buy | current | 2005-10-31 00:00:00 | 10000 | WIC | IF CIG + $0.035 | 144144
MPC Storage Blowdown | Sell | 2001-12-01 00:00:00 | 2003-03-31 00:00:00 | 200,000 / month | CIG | IF CIG | 2000000
Cascade | Sell | current | 2003-10-31 00:00:00 | 5800 | Sumas | 3.67 | 3771740
 | Sell | current | 2003-10-31 00:00:00 | 4200 | Opal | 3.075 | 1737540
 |  |  |  |  |  | Total Contract Value =
Spreadsheet: 195118d1353425417-text-help-maintenance-report-x4l
Sheet: X4L - Castleford

[NAME]
Product | Issue | Part Req | Part Price | Status | Del Date | Fitting Date
Life Fitness 95Xi | Slipping in use | [NAME] | 17.29 | Part Arrived |  | 21st & 22nd Nov
Life Fitness 95Xi | Slipping in use | [NAME] | 17.29 | Part Arrived |  | 21st & 22nd Nov
Life Fitness 95Xi | Slipping in use | [NAME] | 17.29 | Part Arrived |  | 21st & 22nd Nov
Life Fitness 95Xi | Slipping in use | [NAME] | 17.29 | Part Arrived |  | 21st & 22nd Nov
Life Fitness 95Xi | Left pedal snapped | Left Pedal | 95.22 | Part Arrived |  | 21st & 22nd Nov
Life Fitness 95Xi | Right pedal snapped | Right Pedal | 95.22 | Part Arrived |  | 21st & 22nd Nov
Life Fitness 95Xi | Pedal lever & crank snapped | pedal lever & crank set | 187.91 | Part Arrived |  | 21st & 22nd Nov
Life Fitness 95Xi | Various snapped plastics | Various plastics | 85.76 | Part Arrived |  | 21st & 22nd Nov
Life Fitness 95Xi | Arm ext snapped | Arm Ext | 67.92 | Part Arrived |  | 21st & 22nd Nov
 |  | Total |  | Fix Rate
Spreadsheet: 83091d1283158776-complicated-scoring-and-summing-of-unique-cell-values-serious-help-needed-scoring-table-ty1-9
Sheet: Sheet1

 | ty1 | ty2 | ty3 | ty4 | ty5 | ty6 | ty7 | ty8 | ty9 | ty_score
person1 | 2 | 3 | 3 | 1 | 1 |  |  |  | 3 | 6
person2
person3 | 2 | 3 |  | 1 | 1 | 5 | 1 | 2 | 3 | 7
person4
person5 | 2 | 5 | 5 | 5 | 1 | 3 | 5 | 5 | 3 | 4
person6
person7
person8 | 2 |  | 3 | 1 | 1 | 3 |  | 2 | 3 | 7
person9 | 3 |  | 3 | 1 | 1 | 3 |  |  | 3 | 5
Scoring | 1,2=1 | 3=1 | 3=1 | 1=1 | 1=1 | 3=1 | 1,2=1 | 2=1 | 3=1 | 0-9
Spreadsheet: 59ace59d-4526-484d-9d5d-fcf06a6e18a1
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
SPO Form17 (Rev 7/09 Excel) |  |  |  |  | ANNUAL DETAIL INVENTORY OF PROPERTY |  |  |  |  |  |  |  |  |  | As required by
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chapter 103D, HRS
Page |  |  |  | of |  |  |  |  |  |  |  |  |  | June 30,
Department
 |  |  |  |  |  |  |  |  |  | (Class of Property-Land, Building, Infrastructure, Equipment)
Property Custodian
 |  |  |  | (Name and Title) |  |  |  |  |  | (Inventory Taken By)
Prepared By
 |  |  | (Name and Phone) |  |  |  |  |  |  | (Inventory Checked By)
(1) |  |  | (2) |  |  |  |  |  |  | (3) | (4) |  | (5) |  |  | (6)
Quantity |  |  | [NAME] |  |  |  |  |  |  | FY | Carrying Value of |  | Carrying Value of |  |  | Item Tag
Units or |  |  | OR |  |  |  |  |  |  | Ac- | Property on Hand |  | Property Removed |  |  | or Decal
Area |  |  | USE OF PROPERTY |  |  |  |  |  |  | quired | at Fiscal Year-End |  | During Fiscal Year |  |  | Number
0 |  |  | TOTAL |  |  |  |  |  |  |  | 0 |  | 0
SUMMARY OF INVENTORIES
Line |  |  | CLASSIFICATION |  |  |  |  |  | Carrying Value of |  |  |  |  | Carrying Value of
 |  |  |  |  |  |  |  |  | Property on Hand |  |  |  |  | Property Removed
 |  |  |  |  |  |  |  |  | at Fiscal Year-End |  |  |  |  | During the Fiscal Year
1 |  |  | Personal Property (State-Owned Equipment)
2 |  |  | Structures and Improvements to Structures
3 |  |  | Infrastructures
4 |  |  | Land, Interest in Land and Land Improvements
 |  |  | Totals |  |  |  |  |  | 0 |  |  |  |  | 0
CERTIFICATE OF CUSTODIAN
 | State of Hawaii |  |  |  |  | County of
I, |  |  |  |  |  |  | , being first duly sworn, state upon my oath that I am the custodian responsible
for making the inventory attached hereto, that I know the contents thereof, that the same is full, true and complete, and that
the items enumerated therein are at present under my control and that the value set opposite the various items is true and
correct to the best of my knowledge and belief.
 |  |  |  |  |  |  |  |  | [NAME]
___________________________________________________________________
Notary Signature
Sworn to before me this |  |  |  |  |  | day of |  |  | ,
Doc. Date: |  |  |  |  |  | #Pages |  | Document:  Annual Detail Inventory of Property
[NAME]: |  |  |  |  |  |  |  |  |  |  |  | Circuit, State of Hawaii
 | Notary Signature |  |  |  |  |  |  | Date
 | Notary Public State of Hawaii
 | My Commission Expires:
Spreadsheet: 193231d1352760761-ingredient-and-price-book1
Sheet: Sheet2

 | Cost per gram | Cost of ingredient | Weight to make 1 kg | Percentage | TOTALS
 |  |  | 1058
 |  |  | 13.44
 |  |  | 4.97
 |  |  | 2.96
 |  |  | 2.96
 |  |  | 2.75
 |  |  | 1.69
 |  |  | 0.63
 |  |  | 0.42
 |  |  | 52.9
Spreadsheet: 1e159a54-9875-4e33-a175-c588ed6edfbf
Sheet: Sheet1

From the March 31, 2011 CropWatch, a crop production/pest management Website of University of Nebraska-Lincoln Extension.
 |  | Year to Year Fuel Cost Comparison
 |  |  |  |  |  |  | REVISED 3/29/2011
 |  | Fuel use estimates taken from Machinery Cost Estimates  University of MN |  |  |  |  |  |  | Link
 |  |  | Annual average price for No 2 Diesel Fuel |  |  |  |  | Source eia |  | Link to eia
 |  |  | Values in blue font can be changed by the user.
 | Table 1. Diesel fuel cost per hour for various power units
 |  |  |  | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012
 |  |  | Estimated | 1.886 | 2.165 | 2.348 | 3.23 | 1.918 | 2.415 | 0 | 0
 |  |  | Fuel use
 |  |  | Gal/hour | Cost/hr | Cost/hr | Cost/hr | Cost/hr | Cost/hr | Cost/hr | Cost/hr | Cost/hr
 | Tractors
 |  | 40 HP | 1.8
 |  | 60 HP | 2.6
 |  | 75 HP | 3.3
 |  | 105 HP | 4.6
 |  | 130 HP | 5.7
 |  | 160 HP | 7
 |  | 200 HP | 8.8
 |  | 225 HP | 9.9
 |  | 260 HP | 11.4
 |  | 310 HP | 13.6
 |  | 360 HP | 15.8
 |  | 425 HP | 18.7
 | Combines
 |  | 190 HP | 8.4
 |  | 220 HP | 9.7
 |  | 275 HP | 12.1
 | Table 2. Diesel fuel cost per acre for field operations
 |  |  | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013
 |  | Price per gal | 1.886 | 2.165 | 2.348 | 3.23 | 1.918 | 2.415 | 0 | 0
 | Tillage | Estimated Fuel
 |  | Use Gal/acre
 | Field Cultivator | 0.33
 | [NAME] | 0.47
 | [NAME] (HD) | 0.76
 | Planting
 | Row Crop Planter | 0.34
 | Minimum Till Planter | 0.53
 | [NAME] | 0.49
 | [NAME] | 0.63
 | No-Till Drill | 0.81
 | [NAME]
 | Cultivator | 0.46
 | Rotary Hoe | 0.18
 | Boom Sprayer | 0.11
 | Anhydrous Applicator | 0.55
 | Stalk Shreader | 0.74
 | Harvesting
 | [NAME] | 0.4
 | [NAME] | 0.35
 | Hay Baler PTO (twine) | 0.4
 | Round Baler (1500 lb) | 0.77
 | Combine (various heads) | 2
Spreadsheet: 32030d1228150165-how-do-i-write-formula-to-show-a-profit-margin-product-costings
Sheet: Sheet1

 | Net cost | Pack size | Net cost | vat | gross
[NAME] 15  % | 14.94 | 6 | 2.49 | 0.3734999999999999 | 2.8635
Qty 1 | Qty 2 | Qty 3 | Qty4 pack | Qty6 pack | Qty8 pack
2.8635 | 5.726999999999999 | 8.590499999999999 | 11.454 | 17.181 | 22.908
Row A4 and row a5 is to show me prices for various prices per pack
Spreadsheet: darrell_schoolcraft__7324__imball0202
Sheet: Amoco

 | Florida Plant
Day | Measured | Scheduled | Imbal
1 | 147304 | 158363
2 | 162193 | 159898
3 | 156474 | 159849
4 | 156008 | 154229
5 | 152552 | 152972
6 | 156411 | 154640
7 | 159223 | 157936
8 | 154279 | 153799
9 | 154445 | 152757
10 | 155369 | 152757
11 | 156066 | 154251
12 | 157916 | 154251
13 | 152043 | 149527
14 | 159460 | 159170
15 | 151954 | 156660
16 | 161371 | 161663
17 | 163543 | 162791
18 | 160795 | 162790
19 | 152695 | 152757
20 | 153119 | 152756
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | -5048
2002-02-20 00:00:00
CBS Dollars
 |  |  | 324667
Spreadsheet: 744041d1628875857-running-balance-with-multiple-bank-account-transactions-in-one-table-accountingtemplatebackup
Sheet: Chart of Accounts

 |  |  | Chart of Accounts 2021
 |  |  | Yes
Assets and Liabilities | Balance |  | Income, Expenses, Transfers, and Equity |  | Invoicing Platforms |  | Date/Months Accounted
Asset - Cash On Hand |  |  | Income - JMP Sales |  | Tave |  | January 2021
Asset - Fidelity 1 |  |  | Income - Contract Photography |  | Pixieset |  | February 2021
Asset - Fidelity 2 |  |  | Expense - Advertising |  |  |  | March 2021
Asset - Fidelity 3 |  |  | Expense - Car and Truck Expenses |  |  |  | April 2021
Asset - Moxey |  |  | Expense - Commissions and Fees |  |  |  | May 2021
Asset - PayPal |  |  | Expense - Contract Labor |  |  |  | June 2021
Asset - Square |  |  | Expense - Depletion |  |  |  | July 2021
Asset - Venmo |  |  | Expense - Depreciation |  |  |  | August 2021
Credit Card - B&H Photo Credit Card |  |  | Expense - Employee Benefit Program |  |  |  | September 2021
 |  |  | Expense - Insurnace |  |  |  | October 2021
 |  |  | Expense - Interest (Mortgage) |  |  |  | November 2021
 |  |  | Expense - Interest (Other) |  |  |  | December 2021
 |  |  | Expense - Mortgage
 |  |  | Expense - Other
 |  |  | Expense - Legal and Professional Services
 |  |  | Expense - Office Expense
 |  |  | Expense - Pension and Profit-sharing Plans
 |  |  | Expense - Rent or Lease (Vehicles, Machinery, and Equipment)
 |  |  | Expense - Rent or Lease (Other Business Property)
 |  |  | Expense - Repairs and Maintenance
 |  |  | Expense - Supplies
 |  |  | Expense - Taxes and Licenses
 |  |  | Expense - Travel
 |  |  | Expense - Meals
 |  |  | Expense - Utilities
 |  |  | Expense - Wages
 |  |  | Expense - Other Expenses
 |  |  | Transfer to Cash On Hand
 |  |  | Transfer to Fidelity 1
 |  |  | Transfer to Fidelity 2
 |  |  | Transfer to Fidelity 3
 |  |  | Transfer to Moxey
 |  |  | Transfer to PayPal
 |  |  | Transfer to Square
 |  |  | Transfer to [NAME]
 |  |  | Transfer to B&H Photo Credit Card
 |  |  | Transfer from Cash On Hand
 |  |  | Transfer from Fidelity 1
 |  |  | Transfer from Fidelity 2
 |  |  | Transfer from Fidelity 3
 |  |  | Transfer from Moxey
 |  |  | Transfer from PayPal
 |  |  | Transfer from Square
 |  |  | Transfer from [NAME]
 |  |  | Transfer from B&H Photo Credit Card
 |  |  | Owners Drawings/Investment
 |  |  | Opening Balance
Spreadsheet: 110226d1306952129-if-function-rec-push
Sheet: Sheet1

Title | Document No | Submittal No. | Doc Due Date From Reviewer | Doc Due Date To Contractor | [NAME] | [NAME] | Doc Submitted Date | Submittal Status | Submittal Package No. | submittal package number
U220-REC-02555 - SUB 015713-066.001 1.04D TESC Inspection WE 04-02-11 | 015713-066.001 1.04D |  | 2011-04-21 00:00:00
 | I want to extrac this |  |  |  |  |  |  |  | And place it here with the appropriate title | 015713 - Cast in Place Concrete
 |  |  |  |  |  |  |  |  | Basically I want this column to read the first 6 digits from column B and based on what ever those digits are (there 86 possibilities) return the corresponding submittal package number from column k, which will be a hidden column
Spreadsheet: 7df6570c-26f9-4e8f-a5cf-615e07de416b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | U.S. Census Bureau
 |  | Source: Quarterly Summary of State & Local Taxes
 |  | Table 1 - Latest National Totals of State and Local Tax Revenue: U.S. Total
 |  | Not Seasonally Adjusted Total Taxes [Millions of Dollars]
 |  | Period: 1992 to 2012
 |  | Data Extracted on: June 19, 2013 (10:33 am)
Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter
1992 | 135822 | 144154 | 130322 | 158733
1993 | 144699 | 150412 | 139186 | 159318
1994 | 154049 | 151821 | 142333 | 167533
1995 | 157896 | 161701 | 149534 | 178442
1996 | 170544 | 175449 | 161924 | 188453
1997 | 180444 | 186031 | 170327 | 197603
1998 | 190315 | 202369 | 174161 | 207206
1999 | 196889 | 208627 | 183337 | 223852
2000 | 215048 | 230440 | 192487 | 237412
2001 | 222853 | 235918 | 195374 | 240101
2002 | 221818 | 230568 | 200908 | 250397
2003 | 227915 | 229583 | 218266 | 268473
2004 | 245894 | 253143 | 230688 | 295676
2005 | 268565 | 289080 | 251878 | 320314
2006 | 289134 | 316468 | 263937 | 340479
2007 | 305855 | 336925 | 273650 | 358394
2008 | 311635 | 351774 | 285686 | 370456
2009 | 305960 | 314608 | 271984 | 372468
2010 | 306065 | 321866 | 283595 | 377885
2011 | 321058 | 344052 | 286831 | 389052
2012 | 331868 | 357891 | 302800 | 399728
Spreadsheet: 738621d1625154860-if-function-for-multiple-results-cost-analysis-copy-copy
Sheet: Sheet3

[NAME] | Flat sq in | # flats / box | Cost/box | Cost/flat | Cost/100 sqin | Ext Price
2640 .003 10 x 12 Satin |  | 100 | 422
2650 .003 10 x 12 Matte |  | 100 | 451
2690 .003 12 x 20 Matte |  | 100 | 835
2740 .005 10 x 12 Satin |  | 100 | 410
2750 .005 10 x 12 Matte |  | 100 | 436
2753 .005 12 x 20 Satin |  | 25 | 186.5
2790 .005 10 x 12 Matte |  | 100 | 771
2820 .005 10 x 12 Satin |  | 100 | 630
2840 .005 12 x 20 Satin |  | 100 | 972
2870 .008 10 x 12 Satin |  | 100 | 372
2880 .008 10 x 12 Matte |  | 100 | 369
2884 .008 12 x 20 Satin |  | 100 | 743
2920 .008 12 x 20 Matte |  | 100 | 659
3030 .012 12 x 20 Satin |  | 100 | 689
3040 .012 12 x 20 Matte |  | 100 | 771
3060 .012 10 x 12 Satin |  | 100 | 461
3100 .020 10 x 12 Satin |  | 100 | 625
3134 .020 12 x 20 Satin |  | 75 | 712.5
3139 .020 12 x 20 Matte |  | 75 | 780
3373 .032 12 x 20 Satin |  | 48 | 664.8
3375 .032 12 x 20 Satin |  | 48 | 573.12
3378 .032 12 x 20 Matte |  | 48 | 623.04
3663 .063 12 x 20 Satin |  | 12 | 242.64
3666 .063 12 x20 Matte |  | 12 | 247.08
3723 .063 20 x 24 Satin |  | 12 | 421.08
3965 .125 12 x 20 Satin |  | 12 | 438.12
Spreadsheet: 287583d1388871505-help-with-setting-up-book1
Sheet: Purchased Parts

Labels from [NAME] |  |  |  |  | These parts are purchased from listed companies
AA-7 | AA2000
AA-78 | [NAME]
AA-00 | AA5501 |  |  |  |  |  |  | = Enter the finished part the label is going to
C6-54 | CC6650
BB1010 | BB500
A0000 Plus | AA1002
AZ-55B | CC6689
G5-77HK | AA1001
Lables from [NAME]
A7-99ZZ | AA5500
[NAME]
G5-77HC | AA1000
G5-77CH | BB001
G5-55Z | EL900
A7-22HZ | EL999
Spreadsheet: 687418d1595186311-randomly-picked-names-from-overall-list-need-to-pick-those-chosen-and-group-names
Sheet: Sheet1

 |  |  |  |  |  |  | General Playes |  |  |  |  |  |  | 28th July Maxies
 |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | [NAME] | 5
 |  |  | [NAME] |  |  |  | [NAME] | 5
 |  |  | [NAME] |  |  |  | [NAME] | 5
 |  |  | [NAME] |  |  |  | [NAME] | 5
 |  |  | [NAME] |  |  |  | [NAME] | 5
 |  |  | [NAME] |  |  |  | [NAME] | 5
 |  |  | [NAME] |  |  |  | [NAME] | 5
 |  |  | [NAME] |  |  |  | [NAME] | 5
 |  |  | [NAME] |  |  |  | [NAME] | 5
 |  |  |  |  |  |  | [NAME]
 |  |  | [NAME] |  |  |  | [NAME] | 5
 |  |  |  |  |  |  | [NAME]
 |  |  | [NAME] |  |  |  | [NAME] | 5
 |  |  | [NAME] |  |  |  | [NAME] | 5
 |  |  | [NAME] |  |  |  | [NAME] | 5
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  | [NAME] |  |  |  | [NAME] | 5
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Dr [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  | [NAME] |  |  |  | [NAME] | 5
 |  |  | [NAME] |  |  |  | [NAME] | 5
Spreadsheet: 744018d1628867631-how-to-repeat-a-cell-value-based-on-cell-value-in-another-cell-excel-repetion-query
Sheet: Sheet2

 | Raw data |  |  | Desired data
 | Item | Repeat times |  | Repeated
 | A | 1 |  | A
 | A | 1 |  | A
 | A | 4 |  | A
 | B | 2 |  | A
 | A | 1 |  | A
 | A | 1 |  | A
 | C | 2 |  | B
 | B | 1 |  | B
 | B | 4 |  | A
 |  |  |  | A
 |  |  |  | C
 |  |  |  | C
 |  |  |  | B
 |  |  |  | B
 |  |  |  | B
 |  |  |  | B
 |  |  |  | B
Spreadsheet: 285646d1387784890-multiple-string-recognition-0a1_a32
Sheet: גיליון2

Code | Table A |  |  |  |  | Mapping |  | Code | Table B
1 | String1 | String11 |  |  |  |  |  | 18 | String5
2 | String2 | String12 |  |  |  |  |  | 1020 | String2 | String12 | String11
3 | String2 | String12 | String11 |  |  |  |  | 103 | String4 | String14 | String12 | String20
4 | String4 | String14 | String12 | String20 | String23 |  |  | 104 | String5 | String15 | String17 | String21
5 | String5 |  |  |  |  |  |  | 105 | String6 | String16 | String18
 |  |  |  |  |  |  |  | 16 | String7 | String17 | String19
 |  |  |  |  |  |  |  | 100 | String1 | String11