tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0a38a2e4-70f0-4e14-bc08-310725280fb7
Sheet: H

Course color corresponds with term of offering.  BLUE  for Spring semester, PURPLE for J-term, GREEN for both Spring and J-term.
 | AOK Designation | CAR Designation | Comment
History
HIST 100 | Civilizations-History | See CAR list at bottom of this page
HIST 101 | Civilizations-History | See CAR list at bottom of this page
HIST 111 | Civilizations-History
HIST 112 | Civilizations-History
HIST 221 |  | Non-Western; Experiential-Travel | cross-listed with JAPN 221
HIST 230 |  | Experiential-Research
HIST 251 |  | Non-Western
HIST 252 |  | Non-Western
HIST 281 |  | Non-Western
HIST 282 |  | Non-Western
HIST 290 |  | Non-Western | cross-listed with ASTU 290
HIST 320 |  | Non-Western; Experiential-Research
HIST 328 |  | Experiential-Research
HIST 332 |  | Non-Western
HIST 347 |  | Non-Western; Experiential-Research
HIST 348 |  | Non-Western; Experiential-Research
HIST 352 |  | Experiential-Research
HIST 354 |  | Experiential-Research
HIST 355 |  | Experiential-Research
HIST 361 |  | Non-Western; Experiential-Research
HIST 365 |  | Non-Western; Experiential-Research
HIST 367 |  | Non-Western
HIST 371 |  | Experiential-Research
HIST 372 |  | Experiential-Research
HIST 375 |  | Experiential-Research
HIST 376 |  | Experiential-Research
HIST 381 |  | Experiential-Travel | Summer 08; J-term 2010 cross-listed with BLST 381
HIST 381 |  | Experiential-Travel | J-term 09; 10  cross-listed with BLST 381
HIST 386 |  | Experiential-Research
HIST 391 |  | Non-Western; Experiential-Research
HIST 392 |  | Non-Western; Experiential-Research
HIST 393 |  | Non-Western | Spring 2013 (Modern Indonesian Hist)
HIST 394 |  | Non-Western
HIST 395 |  | Non-Western
HIST 396 |  | Non-Western; Experiential-Research
HIST 397 |  | Non-Western; Experiential-Research
HIST 401 |  | Capstone
HIST 450-451 |  | Experiential-Internship
HIST 481-482 |  | Experiential-Research
HIST 487-488 |  | Experiential-Research
HIST 491-492 |  | Experiential-Research
HIST 496-498 |  | Experiential-Research
HIST 100-101 CAR designations
HIST 100 | Modern Iraq |  | Non-Western
 | History of Ancient Egypt |  | Non-Western
 | Intro to Southeast Asian History & Civilization |  | Non-Western
Spreadsheet: 754216d1636032068-working-out-days-of-rest-with-ifs-function-two-criteria-hours-worked
Sheet: Sheet1

# of consecutive  days worked | # of days off  before working again | comfirm
7 | 4 | no
9 | 3 | no
7 | 3 | no
7 | 1 | yes
7 | 1 | yes
10 | 3 | no
13 | 1 | yes
6 | 1 | no
Spreadsheet: 120079d1314966429-excel-2007-dependent-validation-on-seperate-worksheets-pchc_dash_blank
Sheet: Lookups

DRC | Establish | Manage | Identify | Market | Experience | Prepare | Model | Relationship | Partnership | All1 | All2
Establish | EstablishA | ManageA | IdentifyA | MarketA | ExperienceA | [NAME] | [NAME] | RelationshipA | PartnershipA | ImpactA | NoimpactA
Manage | EstablishB | [NAME] | IdentifyB | MarketB | ExperienceB | PrepareB | ModelB | RelationshipB | PartnershipB | ImpactB | [NAME]
Identify |  |  |  | MarketC | ExperienceC | PrepareC | ModelC | RelationshipC | PartnershipC
Market |  |  |  | MarketD |  |  | ModelD | RelationshipD | PartnershipD
Experience
Prepare
Model
Relationship
Partnership
All1
All2
Spreadsheet: 28077d1221920178-inserting-the-same-formula-multiplier-across-multiple-cells-94chisox
Sheet: 94ChisoxHitters

Player | G | AB | H | 2B | 3B | HR | R | RBI | BB | IBB | SO | HBP | SH | SF | SB | CS | GDP | BA
[NAME] | 77 | 207 | 44 | 9 | 1 | 11 | 33 | 29 | 36 | 2 | 68 | 0 | 2 | 3 | 0 | 3 | 0 | 0.213
[NAME] | 113 | 399 | 141 | 34 | 1 | 38 | 106 | 101 | 109 | 12 | 61 | 2 | 0 | 7 | 2 | 3 | 15 | 0.353
#[NAME] | 90 | 312 | 86 | 13 | 4 | 2 | 55 | 30 | 38 | 0 | 32 | 2 | 11 | 5 | 8 | 4 | 8 | 0.276
*[NAME] | 109 | 401 | 113 | 15 | 1 | 18 | 57 | 78 | 61 | 15 | 69 | 2 | 2 | 8 | 3 | 1 | 8 | 0.282
*[NAME] | 100 | 365 | 105 | 9 | 5 | 1 | 46 | 39 | 14 | 2 | 35 | 0 | 7 | 4 | 5 | 4 | 5 | 0.288
#[NAME] | 101 | 384 | 102 | 15 | 5 | 10 | 80 | 52 | 61 | 3 | 43 | 1 | 4 | 3 | 13 | 0 | 10 | 0.266
*[NAME] | 106 | 412 | 114 | 11 | 14 | 3 | 56 | 54 | 26 | 5 | 23 | 2 | 0 | 3 | 26 | 6 | 8 | 0.277
[NAME] | 104 | 369 | 115 | 17 | 3 | 10 | 43 | 51 | 27 | 3 | 56 | 3 | 2 | 2 | 7 | 1 | 5 | 0.312
[NAME] | 112 | 433 | 138 | 19 | 2 | 20 | 72 | 98 | 62 | 4 | 75 | 5 | 0 | 5 | 8 | 1 | 14 | 0.319
*[NAME] | 59 | 139 | 39 | 4 | 0 | 1 | 6 | 24 | 20 | 0 | 15 | 1 | 9 | 3 | 0 | 2 | 4 | 0.281
[NAME] | 45 | 131 | 36 | 7 | 1 | 1 | 19 | 16 | 9 | 0 | 16 | 0 | 3 | 2 | 4 | 2 | 2 | 0.275
*[NAME] | 63 | 102 | 26 | 5 | 0 | 2 | 16 | 7 | 14 | 1 | 23 | 0 | 2 | 0 | 1 | 0 | 3 | 0.255
[NAME] | 35 | 97 | 30 | 5 | 0 | 0 | 17 | 5 | 12 | 0 | 5 | 1 | 3 | 0 | 0 | 0 | 1 | 0.309
[NAME] | 32 | 88 | 18 | 4 | 1 | 1 | 10 | 8 | 4 | 0 | 16 | 0 | 4 | 1 | 0 | 0 | 2 | 0.205
[NAME] | 17 | 28 | 11 | 3 | 0 | 1 | 6 | 5 | 2 | 0 | 4 | 1 | 0 | 0 | 0 | 0 | 2 | 0.393
*[NAME] | 11 | 23 | 5 | 2 | 0 | 2 | 2 | 4 | 0 | 0 | 9 | 0 | 0 | 0 | 0 | 0 | 1 | 0.217
[NAME] | 11 | 19 | 3 | 0 | 0 | 0 | 3 | 1 | 1 | 0 | 4 | 0 | 1 | 0 | 0 | 0 | 1 | 0.158
*Dann Howitt | 10 | 14 | 5 | 3 | 0 | 0 | 4 | 0 | 1 | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 1 | 0.357
[NAME] | 5 | 14 | 2 | 0 | 1 | 0 | 2 | 0 | 0 | 0 | 5 | 0 | 1 | 0 | 0 | 0 | 1 | 0.143
[NAME] | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1.434 | [NAME]
113 | [NAME]
162.042 | Formula x Games Played
Spreadsheet: eric_saibi__9675__121701R
Sheet: Navajo 03

Owner Name |  | Salt River project Agricultural
Station Name |  | Navajo Power Station
Unit Name |  | Navajo 03
NERC Region |  | WSCC
State |  | AZ
Fuel Type |  | Coal
Capacity |  | 803 MW
Start Date |  | 2001-11-30 00:00:00
End Date |  | 2001-12-16 00:00:00
Prv. Start Date |  | 2001-11-30 00:00:00
Prv. End Date |  | 2002-02-27 00:00:00
Comments |  | Some generator work, not overhaul. They will be taking the unit back down in late Jan. early Feb. for a month. Have not set a firm date yet to do [NAME] rehab.
SIC |  | 4911
Plant ID |  | 1015877
Unit ID |  | 1007206
Outage ID |  | 19052
Spreadsheet: 770275d1645975079-excel-formula-to-produce-balance-sheet-balannce-sheet-2021
Sheet: Trial Balance

 | Trial Balance
 |  | DR | CR | Balance Sheet
 | School development funds |  | 846341.62 | School development funds
 | Accumulated funds |  | 491809.59 | Accumulated funds
 | Buildings @ Cost | 331833 |  | Buildings
 | Equipment @ Cost | 206430.88 |  | Equipment - Net Value
 | Equipment - Accum Depreciation |  | 56922.58666666667 | Equipment - Net Value
 | Motor Vehicles | 124400 |  | Motor Vehicles - Net Value
 | Motor Vehicles - Accum Depreciation |  | 119298.0293389605 | Motor Vehicles - Net Value
 | Furniture @ Cost | 777068.89 |  | Furniture - Net Value
 | Furniture - Accum Depreciation |  | 171647.2673333333 | Furniture - Net Value
 | Receivables | 2868092.2 |  | Debtors and other receivables
 | STANBIC USD ACCOUNT | 165135.46 |  | Cash and equivalents
 | NOSTRO US$ | 49071.96 |  | Cash and equivalents
 | CBZ - COLLEGIATE:  [PHONE] | 9775.96 |  | Cash and equivalents
 | Sundry Suppliers |  | 309000 | Sundry Suppliers
 | Other obligations |  | 172.1 | Other obligations
 | Net Surplus / (defict) for the year |  | 2536617.16 | Net Surplus for the year
Spreadsheet: 705346d1606044381-calculate-the-total-number-of-people-on-a-training-course-at-a-certain-time-in-the-day-formula
Sheet: Sheet1

Daily Totals (People) | 09:00:00 |  |  |  |  |  |  |  |  | 50
 | 10:00:00 |  |  |  |  |  |  |  |  |  | 15
 | 11:00:00 |  |  |  |  |  |  |  |  | 15
 | 12:00:00
 | 13:00:00
 | 14:00:00
 | 15:00:00
 |  | 2021-01-01 00:00:00 | 2021-01-02 00:00:00 | 2021-01-03 00:00:00 | 2021-01-04 00:00:00 | 2021-01-05 00:00:00 | 2021-01-06 00:00:00 | 2021-01-07 00:00:00 | 2021-01-08 00:00:00 | 2021-01-09 00:00:00 | 2021-01-10 00:00:00 | 2021-01-11 00:00:00 | 2021-01-12 00:00:00
Trainer 1 | 09:00:00 | CCC01 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 10:00:00 |  | CCC02 |  |  |  |  |  |  |  |  |  |  |  | Course Title | People
 | 11:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | CCC01 | 15
 | 12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | CCC02 | 15
 | 13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | CCC03 | 50
 | 14:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | CCC04 | 15
 | 15:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | CCC05 | 20
Trainer 2 | 09:00:00 | CCC01 |  |  |  |  |  |  |  |  |  |  |  |  | CCC06 | 15
 | 10:00:00
 | 11:00:00 | CCC01
 | 12:00:00
 | 13:00:00
 | 14:00:00
 | 15:00:00
Trainer 3 | 09:00:00 | CCC05
 | 10:00:00
 | 11:00:00
 | 12:00:00
 | 13:00:00
 | 14:00:00
 | 15:00:00
Spreadsheet: 46426d1245298632-lookup-match-list-names-matchteamlistnames
Sheet: W1

 | Need Formula that will look up the team # look under [NAME] that matchs the team number then list the names under the correct team
Team #: | 1 |  |  | Week 1
Team Name:
Player's Name | Hcp. | Average | Game 1 | Game 2
[NAME]
[NAME]
[NAME]
[NAME]
Team #: | 8
Team Name:
Player's Name | Hcp. | Average | Game 1 | Game 2
Bazil
[NAME]
[NAME]
Ian
Team #: | 2 |  |  | Week 1
Team Name:
Player's Name | Hcp. | Average | Game 1 | Game 2
Doug | 0 | 0
Victor | 0 | 0
[NAME] | 0 | 0
[NAME] | 0 | 0
Opposing Captain's Signature
Team #: | 9
Team Name:
Player's Name | Hcp. | Average | Game 1 | Game 2
Corinne | 0 | 0
Connie | 0 | 0
Sandra | 0 | 0
[NAME] | 0 | 0
Spreadsheet: 183823-how-to-connect-the-data-in-two-sheets-in-one-book-show
Sheet: Sheet1

CSN | Counrty | Partner Name | Partner Type | Tier
1 | X | A | IVAR | [NAME]
2 | Y | B | IVAR | Silver
3 | Y | C | IVAR | Silver
4 | Z | D | VAD | VAD
Spreadsheet: e18daf7c-ebe9-4c29-a610-78e3cdf07b15
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | U.S. Census Bureau
 |  | Source: Quarterly Services Survey
 |  | 51: Information: U.S. Total
 |  | Not Seasonally Adjusted Total Revenue [Millions of Dollars]
 |  | Period: 2003 to 2014
 |  | Data Extracted on: August 23, 2014 (2:50 pm)
Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter
2003 | X | X | X | 237399
2004 | 223675 | 233241 | 232983 | 246201
2005 | 236033 | 244136 | 244711 | 255856
2006 | 245182 | 254735 | 255745 | 271401
2007 | 257973 | 265739 | 267325 | 281304
2008 | 270223 | 277650 | 277603 | 282873
2009 | 261921 | 266862 | 265511 | 280665
2010 | 267597 | 274785 | 276049 | 291794
2011 | 277416 | 289110 | 288779 | 305253
2012 | 291952 | 300081 | 298950 | 322308
2013 | 306040 | 313234 | 314646 | 340055
2014 | 323715 | X | X | X
Spreadsheet: richard_ring__31568__Product Offering
Sheet: Sheet1

 | Enron Renewable Power Desk
 | Green Power Product Offering
 | All prices in $/MWh, 3-year Terms
 | NERC REGION |  |  |  | PRODUCT |  |  |  | PRICE
 | WSCC |  |  |  | 100% Wind |  |  |  | $XX.00
 | WSCC |  |  |  | 75% Wind |  |  |  | $XX.00
 | WSCC |  |  |  | 60% Wind |  |  |  | $XX.00
 | WSCC |  |  |  | 100% Biomass |  |  |  | $XX.00
 | WSCC |  |  |  | 80% Wind/20% Biomass |  |  |  | $XX.00
 | WSCC |  |  |  | 60% Wind/40% Biomass |  |  |  | $XX.00
 | ERCOT |  |  |  | 100% Wind |  |  |  | $XX.00
 | ERCOT |  |  |  | 75% Wind |  |  |  | $XX.00
 | ERCOT |  |  |  | 60% Wind |  |  |  | $XX.00
 | ERCOT |  |  |  | 100% Biomass |  |  |  | $XX.00
 | ERCOT |  |  |  | 80% Wind/20% Biomass |  |  |  | $XX.00
 | ERCOT |  |  |  | 60% Wind/40% Biomass |  |  |  | $XX.00
 | MAPP |  |  |  | 100% Wind |  |  |  | $XX.00
 | MAPP |  |  |  | 75% Wind |  |  |  | $XX.00
 | MAPP |  |  |  | 60% Wind |  |  |  | $XX.00
 | MAPP |  |  |  | 100% Biomass |  |  |  | $XX.00
 | MAPP |  |  |  | 80% Wind/20% Biomass |  |  |  | $XX.00
 | MAPP |  |  |  | 60% Wind/40% Biomass |  |  |  | $XX.00
 | For firm pricing or further inquiries, please contact:
 | [NAME]
 | Enron Renewable Power Desk
 | Enron Wholesale Services
 | (713) 853-3561
 | [EMAIL]
Spreadsheet: 1170b235-3dfc-442d-aa57-9179d9c3c69f
Sheet: Information & Traceability

REQUIREMENTS TRACEABILITY MATRIX |  |  |  |  |  |  |  |  |  | REQUIREMENTS TRACEABILITY MATRIX
Project Name: |  |  | <required>
Project Manager Name: |  |  | <required>
Project Description: |  |  | <required>
Requirement Information |  |  |  |  |  | Project Lifecycle Requirement Traceability
ID | Assoc ID | Technical Assumption(s) and/or Customer Need(s) | Functional Requirement | Priority | Status | Architectural/Design Document | Design Constraints | Technical Specification | System Component(s) | Software Module(s) | Test Case Number | Tested In | Implemented  In | Validation | Verification | Relates to Objectives in Charter | Manifests in WBS Deliverable | Risks Associated | Change | Implemention Date | Additional Comments
001 | 1.1.1
002 | 2.2.2
003 | 3.3.3
004 | 4.4.4
005 | 5.5.5
006
007
008
009
010
011
012
013
014
015
016
017
018
019
020
021
022
023
024
025
026
Spreadsheet: 45697d1244530814-nesting-vlookup-in-if-vice-versa-and-pivot-table-modelcategoryytd
Sheet: dMonCat

 |  | Month | Feb
 |  | Sum of Amount | Category
 |  | Model | C1 | C2 | Grand Total
 |  | 750 | -205.6622 | 355.63107624 | 149.96887624
 |  | 900 | -2669.357555600005 | 4615.853085143529 | 1946.495529543524
 |  | AB | -781.1330488 | 1350.73526798496 | 569.6022191849601
 |  | AG | -63.58996399999999 | 109.9597657488 | 46.3698017488
 |  | AN | -1797.5294 | 3108.28783848 | 1310.75843848
 |  | BX | -4786.3809 | 8276.60985228 | 3490.22895228
 |  | BZ | -3810.1728 | 6588.55080576 | 2778.37800576
 |  | CA | -2172.7989 | 3757.20385788 | 1584.40495788
 |  | CB | -474.72875 | 820.9009545000001 | 346.1722045000001
 |  | DE | -1471.4364 | 0 | -1471.4364
 |  | DV | -4460.2879 | 0 | -4460.2879
 |  | DX | -3484.0798 | 0 | -3484.0798
 |  | MF | -891.2694208362112 | 1541.183082509977 | 649.9136616737654
 |  | MR | -10948.26850350159 | 18931.74589625495 | 7983.477392753362
 |  | OA | -387.3093814209659 | 669.7353823531344 | 282.4260009321684
 |  | OB | -145.4543661579462 | 251.5196899603205 | 106.0653238023744
 |  | OR | -182.7213715871364 | 315.9617957484763 | 133.2404241613399
 |  | RA | -565.1764208362113 | 977.3030669099766 | 412.1266460737653
 |  | RF | -10622.17550350159 | 18367.86588065495 | 7745.69037715336
 |  | TM | -61.21638142096588 | 105.8553667531342 | 44.63898533216832
 |  | ZP | -320.4162152328041 | 554.0637193805649 | 233.6475041477608
 |  | Grand Total | -50301.16518289542 | 70698.96638454277 | 20397.80120164735
Spreadsheet: 706152d1606496429-index-match-result-irregularity-forum-xxx
Sheet: Sheet1

Sort Times | % Equivalent
07:09:00 | 0.975
07:09:00 | 0.95
07:09:00 | 0.925
07:09:00 | 0.9
07:09:00 | 0.875
07:09:00 | 0.85
07:09:00 | 0.825
07:10:00 | 0.8
07:10:00 | 0.775
07:10:00 | 0.75
07:10:00 | 0.725
07:10:00 | 0.7
07:10:00 | 0.675
07:10:00 | 0.65
07:10:00 | 0.625
07:11:00 | 0.6
07:11:00 | 0.575
07:11:00 | 0.55
07:11:00 | 0.525
07:12:00 | 0.5
07:12:00 | 0.475
07:12:00 | 0.45
07:12:00 | 0.425
07:13:00 | 0.4
07:13:00 | 0.375
07:13:00 | 0.35
07:13:00 | 0.325
07:13:00 | 0.3
07:13:00 | 0.275
07:13:00 | 0.25 |  |  |  | 07:14:00 |  |  | 07:13:00 | OK | 0.4
07:14:00 | 0.225 |  | 07:14:00 |  | *=D32=A32 |  |  | 07:14:00 | #N/A
07:16:00 | 0.21 |  |  |  | True |  |  | 07:16:00 | #N/A
07:17:00 | 0.2 |  |  |  |  |  |  | 07:17:00 | OK | 0.2
07:19:00 | 0.175 |  | [D33]=INDEX($B$2:B42,MATCH($D$32,$A$2:A42,0))
07:21:00 | 0.15
07:21:00 | 0.125
07:24:00 | 0.1
10:38:00 | 0.075
14:21:00 | 0.05
14:41:00 | 0.025
Spreadsheet: 795450d1662705498-index-match-multiple-sheet-names-sample-book-v2
Sheet: Sheet1

 |  |  | Results |  |  |  |  | What I want it to be
 |  |  | Sheet Name | Find on tabs |  |  |  | Sheet Name | Find on tabs |  |  |  | Sheet name | Find on tabs
 |  |  |  | 015467 |  |  |  | sheet 1 | 015467 |  |  |  | sheet 1 | 039681
 |  |  |  | 037317 |  |  |  | sheet 2 | 037317 |  |  |  | sheet 2 | 037317
 |  |  |  | 009963 |  |  |  | sheet 3 | 009963 |  |  |  | sheet 3 | 029735
 |  |  |  | 027911 |  |  |  | sheet 4 | 027911 |  |  |  | sheet 2 | 029734
 |  |  |  | 039681 |  |  |  | sheet 1 | 039681 |  |  |  | sheet 4 | 027911
 |  |  |  | 029734 |  |  |  | sheet 2 | 029734 |  |  |  | sheet 1 | 015467
 |  |  |  | 029735 |  |  |  | sheet 3 | 029735 |  |  |  | sheet 3 | 009963
 |  |  |  | 009167 | Is on multiple tabs |  |  | sheet 1 & sheet 4 | 009167 | sheet 1 and sheet 4 |  |  | sheet 1&sheet 4 | 009167
Spreadsheet: 600253d1543570021-sumifs-with-max-sample
Sheet: Result

ComplexName | RoomType | No Of Beds | [NAME]
134 New Walk | [NAME] | 9
134 New Walk | Deluxe Studio | 2
134 New Walk | Premier [NAME] | 3
134 New Walk | Ultra Studio | 1
Centro Court | [NAME] | 80
Centro Court | [NAME] Dual Occ | 4
Centro Court | Ground [NAME] | 16
Centro Court | Ground [NAME] Dual Occ | 2
Centro Court | Ultra Studio | 6
Spreadsheet: 162447d1339887256-search-multiple-spreadsheets-d-report-log-2012-3
Sheet: April 2012

NHSP-W DISCIPLINARY REPORT LOG
D-Report Number | Date | Inmate | Reporting Staff | Violation(s) |  |  |  |  | Date of Disposition | Date of Hearings | Outcome | Sanctions (in days) |  |  |  |  |  |  |  |  |  |  |  | Notes
 |  |  |  |  |  |  |  |  |  |  | PG, FWOP, BS, Inc, FG, FNG | P/S | [NAME] | XD | Lost Cant | Lost Rec | Lost Radio | Lost TV | Lost Phone | Lost Radio | Good Time | Lost Visit | Restitution
04-01 | 2012-04-04 00:00:00 | Smith | 333 | 1 |  |  |  |  | 2012-04-06 00:00:00 |  | BS
04-02 | 2012-04-05 00:00:00 | [NAME] | 222 | 2 |  |  |  |  | 2012-04-06 00:00:00 |  | BS
04-03 | 2012-04-05 00:00:00 | Cooper | 444 | 3 | 6 |  |  |  | 2012-04-07 00:00:00 |  | Inc
04-04 | 2012-04-10 00:00:00 | Smith | 111 | 4 | 8 |  |  |  | 2012-04-20 00:00:00 |  | PG |  |  |  |  |  |  |  |  | 10 |  |  | 10
04-05 | 2012-04-13 00:00:00 | Duffy | 111 | 5 | 1 |  |  |  | 2012-04-20 00:00:00 |  | PG | 10 |  |  |  |  |  |  | 5
04-06 | 2012-04-20 00:00:00 | [NAME] | 111 | 6 |  |  |  |  | 2012-05-01 00:00:00 |  | FG | 5 |  |  | 5 |  |  |  |  |  |  | 50
04-07
04-08
04-09
04-10
04-11
04-12
04-13
04-14
04-15
04-16
04-17
04-18
04-19
04-20
04-21
04-22
04-23
04-24
04-25
04-26
04-27
04-28
04-29
04-30
04-31
04-32
04-33
04-34
04-35
04-36
04-37
04-38
04-39
04-40
04-41
04-42
04-43
04-44
04-45
04-46
04-47
04-48
04-49
04-50
04-51
04-52
04-53
04-54
04-55
04-56
04-57
04-58
04-59
04-60
04-61
04-62
04-63
04-64
04-65
04-66
04-67
04-68
04-69
04-70
04-71
04-72
04-73
04-74
04-75
04-76
04-77
04-78
04-79
04-80
04-81
04-82
04-83
04-84
04-85
04-86
04-87
04-88
04-89
04-90
04-91
04-92
04-93
04-94
04-95
04-96
04-97
04-98
04-99
Spreadsheet: 676900d1589044251-pick-up-values-and-list-in-overview-sample
Sheet: Blad1

From a list from where to pick up |  |  |  |  |  |  | item
[PHONE] |  |  |  |  |  |  | E125 | E123 | E126 | E127 | E128
20-0403-000 |  |  |  |  |  | ALFA
[PHONE] |  |  |  |  |  | QTY |  | 4 | 4 | 1
27233 |  |  |  |  |  | VALUE |  | 4 | 23 | 4
43523
701034
4893242
E123 | 4 | 13
er43767 |  |  |  |  |  | Example:
7453434 |  |  |  |  |  | find qty of item E123 (C2) in document "kundstat ALFA" place it in "G4"
450t+0450 |  |  |  |  |  | find value of item E123 (C2) in document "kundstat ALFA" place it in G5
E126 | 4 | 23
6434hddhh |  |  |  |  |  | problem I have is that the file where to pick up values can have date in different locations
63546j56
E03425562
E127 | 1 | 4
Spreadsheet: 4cd0b0f8-be22-4126-874b-533d11413fb9
Sheet: Report

Unit | Unit Priority | Objective Name | Strategic Direction | Impact Type | Resource Id | Resource Name | Resource Type | Year 1 Cost | Year 1 Savings | Year 2 Cost | Year 2 Savings | Year 3 Cost | Year 3 Savings | Year 4 Cost | Year 4 Savings
Payroll | 1 | Conduct at least one workshop. | None | -- Pick One -- | 1.1.r1 | Training Costs | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Payroll | 2 | Explore payroll systems | None | -- Pick One -- | 2.1.r1 | Information Cost | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Payroll | 2 | Determine appropriate system. | None | -- Pick One -- | 2.2.r1 | Information Cost | OneTime | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Payroll | 2 | Purchase system if appropriate. | None | -- Pick One -- | 2.3.r1 | System Cost | OneTime | 700000 | 0 | 200000 | 0 | 200000 | 0 | 0 | 0
Payroll | 1 | Disseminate payroll information. | None | -- Pick One -- | 3.1.r1 | Dissemination costs | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Payroll | 1 | Enhance website information. | None | -- Pick One -- | 3.2.r1 | Updating costs | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Payroll | 1 | Explore payroll services. | None | -- Pick One -- | 4.1.r1 | Information costs | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Payroll | 1 | Determine services for alignment. | None | -- Pick One -- | 4.2.r1 | Information costs | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Payroll | 1 | Align services. | None | -- Pick One -- | 4.3.r1 | Aligning costs | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 145856d1331776874-need-excel-if-condition-test
Sheet: Sheet1

COUNTRY | DEST | TONE
SINGAPORE | O | 1245
INDIA | O | 655
INDIA | C | 6445
INDIA | C | 65465
SINGAPORE | O | 651
INDIA | C | 546
INDIA | O | 654
SINGAPORE | C | 651
SINGAPORE | O | 651
AUSTRLIA | C | 231
AUSTRLIA | C | 566
INDIA | C | 214
AUSTRLIA | O | 254
INDIA | C | 26541
SINGAPORE | C | 212
SING 'O' | SING 'C'
OTHER 'O' | OTHER 'C'
Spreadsheet: 695869d1600435351-autofill-budget-add-salaries-auto-add-budget-info
Sheet: Sheet2

 | Account no | 4221
 |  | Salery no | Verification no | Supplier | Sum
1 | Auto ->
2 | Auto ->
3 | Auto ->
4 | Auto ->
5 | Auto ->
6 | Auto ->
7
 | Account no | 4225
 |  | Salery no | Verification no | Supplier | Sum
 | Added -> | F 123 |  |  |  | (Sum of Salary + tax)
 | Added -> | F 321 |  |  |  | (Sum of Salary + tax)
1 | Auto ->
2 | Auto ->
3
4
5
6
7
8
9
Spreadsheet: 819520d1677562348-vlookup-specific-description-from-multiple-tabs-under-specific-header-name-in-one-column-s666-pq-prices-samples
Sheet: Price matched 2

Price File Name: Price_eff123123123
Price [NAME]
No_in_loader | No Price | No in sys | Difference
12 | 0 | 4
Matched_Prices
Code | Date | Part Code | Name | Price 1 | Price 2 | Price 3
PQR | 2023-01-26 00:00:00 |  |  | 1.232
STU | 2023-01-26 00:00:00 |  |  | 2.43
VWX | 2023-01-26 00:00:00 |  |  | 1.876
YZA | 2023-01-26 00:00:00 |  |  | 0.08997
Unmatched_Prices
Code | Date | Part Code | Name | Price 1 | Price 2 | Price 3
ABC | 2023-01-26 00:00:00 |  |  | 69.876 | 68.34 | 67.879
DEF | 2023-01-26 00:00:00 |  |  | 1.989
GHI | 2023-01-26 00:00:00 |  |  | 87.212
JKL | 2023-01-26 00:00:00 |  |  | 3.4234
MNO | 2023-01-26 00:00:00 |  |  | 1.044
AAA | 2023-01-26 00:00:00 |  |  | 0.1231
BBB | 2023-01-26 00:00:00 |  |  | 1.312
CCC | 2023-01-26 00:00:00 |  |  | 4.2342