tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 709378d1608277547-if-formula-for-dates-sample-formula-book
Sheet: Prepaid Working

 |  |  |  |  | 2020-10-24 00:00:00
 |  |  |  |  | 2020-11-21 00:00:00
 | Category | Period From | Period To |  | Nov Days | Expected Results
 | Apple | 2019-04-01 00:00:00 | 2021-03-31 00:00:00 |  |  | 28
 | Orange | 2020-10-27 00:00:00 | 2021-03-31 00:00:00
 | Fruits | 2020-10-24 00:00:00 | 2020-11-20 00:00:00
 | Column F2 vs F3 is 28 Days. This is Primary Date
 | Column C and D dates we can call as secondary date
 | I need to check whether the secondary dates are with in primary date, if so then it would be 28 Days
 | If the secondary dates are not with in primary date period, then how many days are meet to the primary date that number to be updated.
Spreadsheet: joe_parks__14584__ITM positions by month
Sheet: Main

 |  |  |  | Username: | spathak_pc
 |  |  |  | Password: | spathak_pc
 |  | Official PostIDs Only (Y/N/B) *
 |  | B
 |  | * B will include books beginning with "BANKRUPT" whether official or not
 |  | Include (Y/N) | PostID List | Official | Risk Type | Comment | In Report?
 |  | Y | 1500297 | yes | P | Performance | Yes
 |  | Y |  | yes | D | Performance | Yes
 |  | Y |  | yes | I | Performance | Yes
 |  | Y |  | yes | M | Performance | Yes
 |  | Y |  | yes | Y | Performance | Yes
 |  | Y | 1500208 | yes | P | WC-SOCAL, PRICE | Yes
 |  | Y |  | yes | D | WC-SOCAL, BASIS | Yes
 |  | Y |  | yes | I | WC-SOCAL Index | Yes
 |  | Y |  | yes | M | WC-SOCAL GDM, Positions | Yes
 |  | Y |  | yes | Y | WC-SOCAL GDY | Yes
Spreadsheet: 855050d1704773034-need-help-with-formulas-to-return-name-from-roster-on-calendar-resource-tracker
Sheet: Jul

 |  |  |  |  |  | CALENDAR MONTH | JULY
 |  |  |  |  |  | CALENDAR YEAR
 |  |  |  |  |  | 1ST DAY OF WEEK | MONDAY
daily notes
daily notes
daily notes
daily notes
daily notes
 |  |  | Notes
daily notes
Spreadsheet: 714374d1611200613-matching-value-in-a-column-array-with-result-in-another-column-array-matching-value-in-a-range
Sheet: Sample

 | Result | 7
 |  | Month | %
 |  | 1 | 0
 |  | 2 | 0
 |  | 3 | 0
 |  | 4 | 0
 |  | 5 | 0
 |  | 6 | 0
 |  | 7 | 0.1
 |  | 8 | 0.05
 |  | 9 | 0.2
 |  | 10 | 0.5
 |  | 11 | 0.65
 |  | 12 | 0.8
 |  | Example
 |  | IF ( % value in array  D5:[NAME] is >0%, then return the smallest matching value in C5:C16)
 |  | In the proposed example, matching values are 7, 8, 9, 10, 11, 12; the smallest matching value is 7
 |  | So result is 7
Spreadsheet: cfbbbab8-0d58-4879-8de2-6e27539d6e30
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Word Records | 80688742423 | Cadia | Trust In Me Now | 2008-04-29 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Spreadsheet: 107164d1304384310-shading-a-section-under-a-scatter-graph-copy-of-book3-non-discrete-x
Sheet: Sheet1

 |  |  | [NAME] | Area2 | Area3
 |  | 0 | 0
 | y |  | 0
1 | 1
1.2 | 4
2.6 | 9
4.2 | 16
5.6 | 25
6.8 | 36
7.5 | 49
8.5 | 64
9.2 | 81
9.8 | 100
11.1 | 81
12.4 | 64
13.1 | 49
14.1 | 36
15.3 | 25
16.7 | 16
17.1 | 9
18.3 | 4
19.4 | 1
 |  |  | 0
 |  | 1000 | 0
Spreadsheet: 106285d1303469304-excel-2007-count-conditioned-colour-cells-sample
Sheet: Sheet1

 | DATA INPUT: |  | 3
 |  |  | 4
 | 7500 |  | 5
 | 15000 |  | 6
 | 30000 |  | 7
 | 90000 |  | 8
 | 120000 |  | 9
 | 180000 |  | 10
 |  |  | 11
 |  |  | 12
 |  |  |  | Manual Count, needs to be automatic | 5 | 3 | 2 | 0 | 0 | 0
 |  |  |  | [NAME] count??
 |  |  |  |  | =[NAME]:G$12=SUBTOTAL(5,OFFSET($G$3:$L$3,ROW(G$3:G$12)-ROW(G$3),0)))+0)
Spreadsheet: 290081d1389791448-data-parsing-issue-with-unformatted-data-final-desired-output
Sheet: final sheet

12345678 | 123456 | UMG2-MWP: 255.255.25.2 | UMG | 255.255.25.2 | Minor | Wire | 2006-09-17 00:13:06 | Board Position=back, Board Type=S1L, Board No.=6, Port No.=0, Office No.=NULL, Office Name=NULL, High [NAME] No.=0, Low [NAME] No.=57, TDM Port Name=027RAND361006630450, [NAME] reason=11 | Alarm | Root cause (without correlative alarms) | Manually accepted by user | 2006-10-27 03:28:21 | Mezul Oz | TE | Automatically  cleared | 2007-01-06 16:32 12:00:00 AM | TEH/MTS-1 path fault | -- | -- | 2006-09-16 18:26:48 | --
87654321 | 654321 | UMG2-MWP: 255.255.25.3 | UMG | 255.255.25.3 | Minor | Wire | 2006-09-17 00:13:06 | Shelf Number=1, Frame Number=3, Slot Number=1, [NAME], PRA [NAME], Link Name=027GERM361004050606 | Alarm | Root cause (without correlative alarms) | Manually accepted by user | 2006-10-27 03:28:21 | Mezul Oz | TE | Automatically cleared | 2007-01-06 16:32 12:00:00 AM | TEH/MTS-1 path fault | -- | -- | 2006-09-16 18:26:48 | --
Spreadsheet: eric_saibi__9940__103101R
Sheet: Salem 01

Owner Name |  | PSEG Power LLC
Station Name |  | Salem Nuclear Power Station
Unit Name |  | Salem 01
NERC Region |  | MAAC
State |  | NJ
Fuel Type |  | Nuclear
Capacity |  | 1,170 MW
Start Date |  | 2001-09-24 00:00:00
End Date |  | 2001-11-04 00:00:00
Prv. Start Date |  | 2001-09-24 00:00:00
Prv. End Date |  | 2001-10-30 00:00:00
Comments |  | [NAME]
SIC |  | 4931
Plant ID |  | 1018459
Unit ID |  | 1004455
Outage ID |  | 18526
Spreadsheet: 743697d1628681072-using-the-optimal-number-of-bills-starting-with-the-smallest-forumhelpme
Sheet: Sheet1

 |  | Input | Output
 |  | Kasse 1
 |  | Cash Value | Number of Bills | SUM | Removed | Left
 |  | 500 | 0
 |  | 200 | 7
 |  | 100 | 14
 |  | 50 | 54
 |  | 20 | 49
 |  | 10 | 22
 |  | 5 | 12
 |  |  | [NAME] | 45.66
 |  |  | Coins in Safebag |  | Coins in Register
 |  |  | Base Amount in Register | 300 | Add to Register in Bills |  | Left to add
 |  |  | Should be Amount in Register
 |  |  | Actual Amount in Register
 |  |  | Difference
Spreadsheet: 749120d1632512765-trying-to-match-next-highest-number-position-in-a-column-match-questions
Sheet: Sheet1

 | 7th Inning
 | Points | Items |  | XP | Next Step | Next Item | To Next | To Finish | Daily XP Gain |  | Earned | New Total
1 | 5000 | [NAME] 1,500 Stubs |  | 3550 |  |  |  |  | Games:
 | 10000 | The Show Pack (5) |  |  |  |  |  |  | Moments:
 | 17500 | Nameplate & 3,000 Stubs |  |  |  |  |  |  | Other:
 | 25000 | Headliners Pack (2) |  |  |  |  |  |  | End:
 | 32500 | Unlockables Pack & 3,000 Stubs |  |  |  |  |  |  | Total Earned:
 | 40000 | Diamond Batting Glove
 | 45000 | Diamond Cleats
 | 55000 | [NAME]' is a Habit Pack (2)
 | 70000 | Diamond Unlockable
 | 85000 | The Show Pack (10)
 | 100000 | 6th Inning Diamond Card
 | 115000 | Royals Uniform & 5,000 Stubs
 | 130000 | Headliners Pack (2)
 | 145000 | Gold Ballplayer Pack
 | 160000 | [NAME]' is a Habit Pack (2)
 | 175000 | 6th Inning Diamond Classics Card
 | 190000 | Unlockable & 5,000 Stubs
 | 205000 | Unlockable
 | 220000 | [NAME] 32 (2)
 | 235000 | Gold Ballplayer Pack
 | 250000 | Equipment Item & 5,000 Stubs
 | 270000 | The Show Pack (5)
 | 290000 | Legends Icons Pack
 | 310000 | [NAME] 33
 | 330000 | Red Sox Uniform & 5,000 Stubs
 | 350000 | 6th Inning Bosses Pack
 | 380000 | Gold Ballplayer Pack
 | 410000 | Classic Stadium Pack
 | 440000 | The Show Pack (10)
 | 470000 | Angels Uniform & 5,000 Stubs
 | 500000 | [NAME]' is a Habit Pack (5)
 | 530000 | Diamond Ballplayer Pack
 | 560000 | ASG Pack
 | 590000 | HRD Pack
 | 620000 | The Show Pack (20)
 | 650000 | 90+ Live Series Pack
Spreadsheet: matthew_lenhart__26071__socalfcst
Sheet: Spark Spread

 | $/Mmbtu | 55
 | $/MWh | 550
 | Heat Rate | 10
 | [NAME] | 18
 | Plant [NAME] | 800
 | Term (Days) | 1
 | MWh/d |  |  |  |  | *if [NAME] HR is above actual HR then buy the Spark Spread, vice versa
 | Mmbtu/d
 | Implied HR
 |  |  | Buy Spark Spread: |  | Price | Term | Units/d
 |  |  |  | Sell Power
 |  |  |  | Buy Gas
 |  |  | Sell Spark Spread: |  | Price | Term | Units/d
 |  |  |  | Buy Power
 |  |  |  | Sell Gas
Spreadsheet: 0b5b6e6b-9197-403d-a69a-f295ce2b43e4
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  |  |  | Meat Goat Enterprise Budgets
University of Kentucky
Department of Agricultural Economics |  |  |  | Working Revision: April 29, 2003
400 [NAME].
Lexington, KY  40546-0276
 |  |  |  |  | [NAME], Extension Professor, Livestock and Meat Marketing
Phone:  [PHONE] |  |  |  |  | Department of Agricultural Economics
Fax: [PHONE]
URL: | www.uky.edu/Ag/AgEcon/ |  |  |  | [NAME],  Extension Associate for Goat Management
 |  |  |  |  | Department of Animal Sciences
Goat Budget Questions: [NAME]
 | [EMAIL]
Website Questions:
 | [EMAIL]
Spreadsheet: 266447d1379616169-conditional-formating-and-formula-help-sample
Sheet: Initial

Notes |  |  |  |  |  |  |  |  | RAMPINGS ->
 |  |  |  | Aircraft | RAMP |  |  | Com. [NAME]. |  | FD | T1 | T3
 | Customer | Airline | Flight # | Reg/Tail | Ramp | ETA | Time |  | Contact |  | RAMP
1
 |  |  |  |  | ETD
2
 |  |  |  |  | ETD
3
 |  |  |  |  | ETD
Spreadsheet: 842612d1694631748-excel-update-drop-down-list-need-help-excel-forum-example-sheet2
Sheet: Quote Part 3

WORK CENTRE | Set-Up Hrs | Hours / Unit | Minutes / Unit | Units / Hour | Hours / Yield | Rate Type | nCT / [Total hr] | Base Rate for Price Model | [NAME]. | Override  Base Rate | Surcharge | Effective Rate | Labour Yield Factor: |  |  | Price [NAME] per Part |  |  |  |  | Base Effective Rate | [NAME]?  [Inputs!] |  | net Cycle Time per Part (hr) | Total WC Time / Operation (hr) |  | Is Error | Labour Total =
 |  |  |  |  |  |  |  |  |  |  |  |  | (Effective) |  |  | Hrs/Unit | Min /Unit | Units / Hour | Hours / yield | Set-up |  | f/[NAME]? | f/all blank?
 |  |  |  |  |  | RT
 |  |  |  |  |  | RT
 |  |  |  |  |  | RT
 |  |  |  |  |  | RT
 |  |  |  |  |  | RT
 |  |  |  |  |  | RT
 |  |  |  |  |  | RT
 |  |  |  |  |  | RT
 |  |  |  |  |  | RT
 |  |  |  |  |  | RT
MARK | 0.2 |  |  |  |  | RT
PHOS |  |  |  |  |  | RT |  |  |  |  |  |  | [NAME]:
QCMAN |  |  |  |  |  | RT |  |  |  |  |  |  | Inspection Sampling Frequency:
Spreadsheet: 75370d1275942392-automate-information-importing-template
Sheet: A

Rationale: panel age and classification are important in terms of ongoing research program consistency, particularly when blending sample sources for studies.
Please complete the following descriptive information… | Choose From [NAME] |  | Click For More Info
question
question
question
question
question |  | ð | Sample Sources
question
question
question |  | ð | Panel
question |  | ð | River Sample
question
question |  | ð | Database
question
question
question
question
question
 |  |  | 1 | Only panel management: supplier of interviews ONLY | 1 | Not Applicable | 1 | Not Applicable | 1 | Not Applicable | 1 | Yes
 |  |  | 2 | Only panel management: supplier of interviews AND programming of online surveys | 2 | < 1999 | 2 | Panel | 2 | < 10% | 2 | No
 |  |  | 3 | Only panel management: supplier of interviews AND programming of online surveys AND reporting results in tables | 3 | 1999 | 3 | River or aggregation | 3 | 10%-19% | 3 | Not Sure
 |  |  | 4 | Research company that offers a complete research packet, including an online panel under its own INTERNAL management | 4 | 2000 | 4 | Hybrid panel/river | 4 | 20%-29%
 |  |  | 5 | Research company that offers a complete research packet, including an online panel under EXTERNAL management | 5 | 2001 | 5 | Database or list | 5 | 30%-39%
 |  |  | 6 | Database or list management only | 6 | 2002 | 6 | Other | 6 | 40%-49%
 |  |  | 7 | Other | 7 | 2003 | 7 | Not Applicable | 7 | 50%-59%
 |  |  | 8 | Not Applicable | 8 | 2004 | 8 |  | 8 | 60%-69%
 |  |  |  |  | 9 | 2005 | 9 |  | 9 | 70%-79%
 |  |  |  |  | 10 | 2006 | 10 |  | 10 | 80%-89%
 |  |  |  |  | 11 | 2007 | 11 |  | 11 | 90%-99%
 |  |  |  |  | 12 | 2008 | 12 |  | 12 | 1
 |  |  |  |  | 13 | 2009 |  |  | 13 | Don't Know
 |  |  |  |  | 14 | 2010
.
.
Top
.
.
Top
.
.
Top
.
.
Top
Spreadsheet: 218765d1362572634-conditional-formatting-color-3-numbers-in-another-list-test-3-numbers-in-a-range-and-change-colour
Sheet: Foglio1

 |  |  |  |  | 11 | 25 | 32 | 44 | 55 | 58 | 74 | 80
1 | 12 | 50
4 | 11 | 32
7 | 55 | 58
32 | 44 | 74
20 | 70 | 90
25 | 60 | 75
11 | 58 | 80
 |  |  | color only if all three numbers are listed above
Spreadsheet: eric_saibi__9708__010402R
Sheet: Rex Brown 04

Owner Name |  | Entergy Mississippi Incorporated
Station Name |  | Rex Brown Power Station
Unit Name |  | Unit 04
NERC Region |  | SERC
State |  | MS
Fuel Type |  | Natural Gas / Fuel Oil
Capacity |  | 239 MW
Start Date |  | 2002-01-04 00:00:00
End Date |  | 2002-01-31 00:00:00
Prv. Start Date |  | 2002-01-05 00:00:00
Prv. End Date |  | 2002-02-01 00:00:00
Comments |  | Boiler / Turbine Work
SIC |  | 4911
Plant ID |  | 1006293
Unit ID |  | 1007622
Outage ID |  | 17559
Spreadsheet: 720139d1614027618-xlookup-array-formula-will-not-fill-down-sample-file
Sheet: Receiving data

Plant | Receipt  Date | [NAME] | Vendor [NAME] | Quantity Received | [NAME] | Vendor [NAME] | State /  Prov | Country | Commodity | Related?
ST | 2020-01-07 00:00:00 | 42192 | ABC CO | 41740 |  |  | ON | Canada | Widgets | yes
ST | 2020-01-03 00:00:00 | 16411 | EFG CO | 20210
ST | 2020-01-28 00:00:00 | 28869 | ABC CO | 48080
LO | 2020-12-02 00:00:00 | 12585 | ABC CO | 20210
LO | 2020-12-02 00:00:00 | 58306 | ABC CO | 20210
ST | 2020-09-17 00:00:00 | 26012 | ABC CO | 48080
LO | 2020-08-04 00:00:00 | 35360 | ABC CO | 48080
ST | 2020-11-02 00:00:00 | 84524 | ABC CO | 20210
LO | 2020-11-04 00:00:00 | 82889 | ABC CO | 48080
ST | 2020-11-03 00:00:00 | 19967 | ABC CO | 48080
Spreadsheet: 221986d1363722212-names-of-failure-students-to-be-automatically-shown-in-the-list-of-failures-marks-and-list-of-failures
Sheet: List of Failures

List of Failures
SN | Student's Name | Student No. | Mark | Grade
Spreadsheet: 151383d1334876970-index-and-match-formulas-exceltest
Sheet: INVTURN

Accelerators
4 | 2012
4 | POSTDATE | POSTDATE | POSTDATE | POSTDATE | POSTDATE | POSTDATE | POSTDATE | POSTDATE | POSTDATE | POSTDATE | POSTDATE | POSTDATE | 2012 |  | Last 4 months |  | Inventory |  | Incoming Pos |  |  |  |  |  |  |  |  |  |  |  |  |  | total lbs on way | total months
 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00
PNAME1 | January | February | March | April | May | June | July | August | September | October | November | December | avg. # month | volume | avg. # month | volume | current | Months. | Jan | Feb | Mar | Apr | May | June | Jul | Aug | Sep | Oct | Nov | Dec | SUM | bag size
Prod1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 55.115
Prod2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 55.115
Prod3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 55.115
Prod4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 55.115
Prod5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44.092
Prod6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 55.115
Prod7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44.092
Prod8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44.092
Spreadsheet: 9d00180d-dc30-47c2-8f0c-cd382bfed5bb
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
3595 | 7713 | [NAME] | [NAME] | AUT | 141 | 00:18:59 | 00:00:00 | 00:30:40 | 00:00:00 | 00:23:32 | 1 | 01:13:11
3595 | 21752 | Kaarel | [NAME] | EST | 142 | 00:20:36 | 00:00:00 | 00:32:49 | 00:00:00 | 00:25:15 | 2 | 01:18:40
3595 | 21941 | Ferdinand | [NAME] | GER | 136 | 00:20:57 | 00:00:00 | 00:34:23 | 00:00:00 | 00:25:47 | 3 | 01:21:07
3595 | 10294 | Reinhardt | [NAME] | GER | 135 | 00:20:30 | 00:00:00 | 00:36:12 | 00:00:00 | 00:26:36 | 4 | 01:23:18
3595 | 21942 | Otto | Lingk | GER | 138 | 00:22:19 | 00:00:00 | 00:33:22 | 00:00:00 | 00:27:54 | 5 | 01:23:35
3595 | 15555 | Dr. [NAME] | [NAME] | GER | 139 | 00:23:41 | 00:00:00 | 00:37:24 | 00:00:00 | 00:28:59 | 6 | 01:30:04
3595 | 20729 | [NAME] | Bernt | GER | 134 | 00:23:26 | 00:00:00 | 00:37:14 | 00:00:00 | 00:32:28 | 7 | [NAME]
Spreadsheet: b02751ec-712b-4114-b07f-1bb41fb11dbc
Sheet: Summary

protein number | protein name | Accession | Molecular Weight | Protein Identification Probability (number of peptides) | % coverage
1 | Isoform 1 of Polymerase I and transcript release factor = cavin 1 | IPI00176903 | 43 [NAME] | 100% (84) | 0.44
2 | [NAME] of Caveolin-1 | IPI00009236 | 20 [NAME] | 100% (27) | 0.65
3 | [NAME] of Caveolin-2 | IPI00019870 (+1) | 18 kDa | 100% (16) | 0.37
4 | Protein kinase C delta-binding protein = cavin 3 | IPI00056334 | 28 kDa | 100% (13) | 0.31
5 | Histone H1.2 | IPI00217465 | 21 [NAME] | 100% (3) | 0.34
6 | Histone H1x | [NAME] | 22 [NAME] | 100% (2) | 0.1
7 | Serum deprivation-response protein =cavin 2 | IPI00005809 | 47 kDa | 99% (2) | 0.12
 | These are the 7 proteins specifically identified in caveolin-1-GFP immunoprecipitates from the HMW fractions of sucrose velocity gradients as shown in Figure 1. All other proteins in the sample were also identified in the negative control.
 | Tabs 1 to 7 contain the peptides identified for each protein
Spreadsheet: 79284d1279563834-writing-a-recursive-function-somethingalong
Sheet: Equipment List

serialnum | manufacturer | model | clli | asset tag | purchase year | pid |  | status | mic | cost | notes |  | DO NOT EDIT | DS0 | DS1 | DS3 / E3 | T1 / E1 | IMA | Service Type 6 | Service Type 7 | OC1 / STS-1 | [NAME] | OC12 | Ethernet Electrical 10/100 | Ethernet Optical 1000 | Interface Type 6 | Interface Type 7
1 | Electrodata | model a | NYC | To be assigned | 2012 | N/A |  | Available | N/A | 1 | can be left at customer |  | 0 | 1 | 1 | 1 |  |  |  |  | 1 | 1 | 1
2 | Electrodata | model b | NYC | To be assigned | 2012 | N/A |  | Decommissioned | N/A | 1 | remote security |  | 0 | 1 | 1 |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1
3 | Electrodata | model c | NYC | To be assigned | 2012 | N/A |  | On Loan | N/A | 1 | remote dial in |  | 0 | 1 |  |  |  |  |  |  |  |  |  | 1 | 1
4 | Electrodata | model d | NYC | To be assigned | 2012 | N/A |  | Lost/Stolen | N/A | 1 | 56k dial in | 1 | 1 |  |  |  | 1 |  |  |  |  |  |  | 1 | 1
5 | Electrodata | model e | NYC | To be assigned | 2012 | N/A |  | Out for Repair | N/A | 1 | remote security |  | 0 |  |  |  | 1 | 1 |  |  | 1 | 1 | 1
6 | Electrodata | model f | NYC | To be assigned | 2012 | N/A |  | Out for Upgrade | N/A | 1 | can be left at customer |  | 0 |  |  |  |  |  | 1 |  |  |  |  | 1 | 1 | 1 | 1
7 | Electrodata | model g | NYC | To be assigned | 2012 | N/A |  | In Use | N/A | 1 | remote dial in |  | 0 |  |  |  |  |  |  | 1 | 1 | 1 | 1
8 | Electrodata | model h | NYC | To be assigned | 2012 | N/A |  | Decommissioned | N/A | 1 | can be left at customer | 2 | 1 |  |  |  | 1 | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1
9 | Electrodata | model i | NYC | To be assigned | 2012 | N/A |  | Out for Upgrade | N/A | 1 | can be left at customer | 3 | 1 |  |  |  | 1 | 1 |  |  |  |  |  | 1 | 1 | 1 | 1
10 | Electrodata | model j | NYC | To be assigned | 2012 | N/A |  | In Use | N/A | 1 | can be left at customer | 4 | 1 |  |  |  | 1 | 1 |  |  |  |  |  | 1 | 1 | 1 | 1
Spreadsheet: 766345d1643854071-choose-from-several-drop-down-lists-depending-on-a-single-input-example1-edit
Sheet: Sheet1

 |  | Data Table
 |  | AL | Anniston | Auburn | Bessemer | Birmingham | Dothan
Enter State Abbreviation here: | AK | AK | Anchorage | Fairbanks | Juneau | Kenai Peninsula | Ketchikan
Show the drop down options here: | Anchorage | AZ | Apache County | Bullhead City | Casa Grande | Cochise County | Coconino County
Spreadsheet: 295554d1391722773-moving-data-from-one-row-to-another-for-only-a-few-columns-sample-ar-aging
Sheet: Sheet1

Account Number | Account Name Invoice Date / Number | Last Payment Date Balance Total | Not Due | Total  Due | 0-30 Days Past Due | 31-60 Days Past Due | 61-90 Days Past Due |  | >90 Days Past Due
 | COMMERCIAL
A&M123 | A&M Ice Cream Shop | 41621
 | 2014-01-01 00:00:00 |  | 8424.58
 | Account Total | 4212.29 | 8424.58 | -4212.29 | -4212.29
A&R123 | A&R HVAC Company
 | 2014-01-01 00:00:00 |  | 1480.15
 | Account Total | 1480.15 | 1480.15
ABB123 | AB Basketball Supplies
 | 2013-12-01 00:00:00 |  |  | 4003.85 | 4003.85
 | 2014-01-01 00:00:00 |  | 4003.85
 | Account Total | 8007.7 | 4003.85 | 4003.85 | 4003.85
AJR123 | AJ Reading Center | 41218
 | 2012-09-01 00:00:00 |  |  | 0.02 |  |  |  |  | 0.02
 | 2012-11-01 00:00:00 |  |  | -0.02 |  |  |  |  | -0.02
 | 2014-01-01 00:00:00 |  | 5816.9
 | Account Total | 5816.9 | 5816.9 | 0 |  |  |  |  | 0
Account Number | Account Name Invoice Date / Number | Last Payment Date Balance Total | Not Due | Total  Due | 0-30 Days Past Due | 31-60 Days Past Due | 61-90 Days Past Due |  | >90 Days Past Due
A&M123 | A&M Ice Cream Shop | 4212.29 | 8424.58 | -4212.29 | -4212.29
A&R123 | A&R HVAC Company | 1480.15 | 1480.15
ABB123 | AB Basketball Supplies | 8007.7 | 4003.85 | 4003.85 | 4003.85
AJR123 | AJ Reading Center | 5816.9 | 5816.9 | 0
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 22 March 2012

Daily Morning Staff |  |  |  |  | Thursday
 | 07:30-14:30 |  | 2012-03-22 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Relation Supervisor | 07:30:00 | 14:30:00 | EFS
Sheikha [NAME] | 2120 | Reservation Officer | 07:30:00 | 14:30:00 | TOPS
Syed Sultan | 2888 | Supervisor | 07:30:00 | 14:30:00 | EFS | Reported one day
[NAME] | 4143 | Aircraft Team Leader | 07:30:00 | 14:30:00 | EFS
Jalil Nushadi | 1889 | Driver | 05:45:00 | 14:30:00 | EFS
[NAME] | 624 | Driver | 07:30:00 | 14:30:00 | EFS
Soud Sharar | 2097 | [NAME] Officer | 07:30:00 | 14:30:00 | [NAME]
[NAME] | 1897 | Manager | 07:30:00 | 14:30:00 | EFS | Sick leave
[NAME] | 4440 | Attendant | 07:30:00 | 14:30:00 | EFS
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS
Spreadsheet: 106308d1303482424-excel-2007-can-you-use-a-tick-box-as-a-value-invoice-example
Sheet: Sheet1

[NAME]
 |  |  |  |  |  | Please invoice:
Month: | 2011-03-01 00:00:00
UID | Customer Name | Course Booked | Net Sale | Fee | Tutor Assist | Project | Total | Comments
WGT030 |  | IOSH | 245.83
WGT047 |  | NEBOSH | 395
WGT049 |  | IOSH | 275
WGT050 |  | IOSH | 200
WGT051 |  | IOSH | 200
WGT052 |  | IOSH | 200
WGT053 |  | IOSH | 200
WGT054 |  | IOSH | 200
WGT055 |  | NEBOSH | 395
WGT056 |  | IOSH | 220
WGT057 |  | IOSH | 220
WGT058 |  | NEBOSH | 395
WGT059 |  | NEBOSH | 395
WGT060 |  | NEBOSH | 395
WGT061 |  | IOSH | 275
WGT035 |  | IOSH | 275 |  |  | 8
WGT028 |  | IOSH |  |  | 12 | 8
WGT011 |  | IOSH |  |  |  | 8
WGT020 |  | IOSH |  |  |  | 8
WGT046 |  | IOSH | 220 |  | 12
WGT026 |  | IOSH |  |  | 12
WGT041 |  | IOSH | 275
WGT048 |  | IOSH | 275
WGT040 |  | IOSH | 275
WGT042 |  | IOSH | 275
WGT043 |  | IOSH | 275
WGT044 |  | IOSH | 175
WGT045 |  | IOSH | 220
Totals:
 |  | Invoice this amount:
Spreadsheet: 693544d1599027689-formula-to-replace-numbers-with-specific-letters-workbook1
Sheet: Sheet1

Origianal Code | Replacement Code |  | Original Format | Replacement Format
1123 | AABC |  | 1 | A
1124 | AABD |  | 2 | B
1525 | AEBE |  | 3 | C
2135 | BACE |  | 4 | D
2465 | BDFE |  | 5 | E
2960 | BIFJ |  | 6 | F
21-1234 | BA-1234 |  | 7 | G
25-2245 | BE-2245 |  | 8 | H
32-5565 | CB-5565 |  | 9 | I
101-2245 | AJA-2245 |  | 0 | J
165-5698 | AFE-5698
801-9007 | HJA-9007