tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 791719d1660563533-vlookup-error-from-pivot-table-row-test
Sheet: Sheet2

Material | Material Group | [NAME]. | Material No. | Material Descrip. | Material Type | MRP | Plant Material Status | Current Stock
 | 99999 | Non-stock Materials | 000000000000000337 | LOST OR DAMAGED PACKAGING | NLAG | 010 |  | 0
 | 99999 | Non-stock Materials | 000000000000000547 | Cut-Off Sales | NLAG | 010 |  | 0
 | 99999 | Non-stock Materials | 000000000000090001 | Packaging Recovery Note (PRN's) | ZPRN | 030 |  | 621
 | 25023 | PF 16,5 gr PCO 1881 | 000000000000101612 | PF 16,5G PCO 1881 CLEAR | HALB | 030 |  | 0
 | 25031 | [NAME] gr PCO | 000000000000103423 | PF 16,0G PCO CLEAR RH | HALB | 030 |  | 0
 | 25020 | PF 15,0 gr 30/25 | 000000000000104533 | PF 15,0G 30/25 CLEAR | HALB | 030 |  | 0
 | 24990 | PF 9,75 gr HEXALITE | 000000000000105588 | PF 9,75G HEXALITE CLEAR | HALB | 030 |  | 0
 | 20840 | PF 22g 28m PCO1810 | 000000000000106096 | PF 22g 28mm 1810 G127 C25 PSD 15068 | HALB | 030 |  | 0
 | 21064 | PF 43g28mPCO1810 | 000000000000106098 | PF 43g 28mm 1810 G1B6 G00 PSD 08544 | HALB | 030 |  | 0
Spreadsheet: 868096d1714812491-adding-an-extra-if-to-a-formular-stock-calculator-formular-creating-vlookup-0912
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | No Further Action
 |  |  |  |  |  |  |  |  |  |  |  | Under Review
 |  |  |  |  |  |  |  |  |  |  |  | Complete
Code & Description |  | Unit | Barcode | Balance | Unposted | On Hand | Orders | Available | Orders |  | Supplier | Actual Status | [NAME] | Min Order Calc | Min Qty | Difference | Comments | Expected Del Date
ds14c |  | 1500 | T0802001 | 13 | 0 | 13 | 0 | 13 | 0
ds14c |  |  | T0802001
104f |  | 1000 | B0202001 | 2 | 0 | 2 | 0 | 2 | 16
Spreadsheet: 215921d1361541678-sum-of-sum-tableau-entrep-ts
Sheet: B7

Local 7
Nom: | [NAME] | [NAME]
Numéro de téléphone: | [PHONE]
[NAME]: | 40
Paiement dû le: | 2013-03-15 00:00:00
[NAME]: | 84
Réservé:
Prix: | 175
Payé: | OUI
Mois réservés
Novembre 2011
Décembre 2011
Janvier 2012
Février 2012
Mars 2012
Avril 2012
Mai 2012
[NAME] 2012
Juillet 2012
Août 2012
Septembre 2012
Octobre 2012
Novembre 2012
Décembre 2012
Spreadsheet: 787171d1657652402-how-to-subtract-two-cells-but-add-them-if-one-of-the-values-is-negative-new-microsoft-excel-worksheet
Sheet: Sheet1

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14 | Column15 | Column16 | Column17 | Column18 | Column19 | Column20
 |  |  |  |  |  |  |  |  | 105 |  |  | 105 |  |  | 0
 |  |  |  |  |  |  |  |  | 525 |  |  | 525 |  |  | 0
 |  |  |  |  |  |  |  |  | 945 |  |  | 945 |  |  | 0
 |  |  |  |  |  |  |  |  | 735 |  |  | 735 |  |  | 0
 |  |  |  |  |  |  |  |  | -105 |  |  | 735 |  |  | 840 | <--------- | 630
 |  |  |  |  |  |  |  |  | 2496.34 |  |  | 2496.34 |  |  | 0
 |  |  |  |  |  |  |  |  | 5231.55 |  |  | 5231.55 |  |  | 0
Spreadsheet: 858180d1706909876-distribute-orders-with-avearge-for-designers-assigning_mod-
Sheet: Solver_setup

 |  |  | SO number | Order Type | Count# | Customer # |  | Designer1 | Designer2 | Designer3 | Designer4 | Designer5 | Designer6 | Sum |  |  |  | Designer1 | Designer2 | Designer3 | Designer4 | Designer5 | Designer6
 |  |  | SO-2241284 | JXP | 1 | AR-003033 |  | 0 | 0 | 0 | 0 | 0 | 1 |  | = | 1
 |  |  | SO-2242825 | JXP | 1 | AR-000970 |  | 0 | 0 | 0 | 0 | 0 | 1
 |  |  | SO-2240850 | JX | 32 | AR-005720 |  | 1 | 0 | 0 | 0 | 0 | 0
 |  |  | [NAME] | JX | 1 | AR-000941 |  | 0 | 0 | 0 | 0 | 0 | 1
 |  |  | SO-2240484 | JX | 1 | AR-004628 |  | 0 | 0 | 0 | 0 | 0 | 1
 |  |  | SO-2242882 | JX | 1 | AR-000883 |  | 0 | 0 | 0 | 0 | 0 | 1
 |  |  | SO-2242007 | JTS | 16 | AR-000175 |  | 0 | 1 | 0 | 0 | 0 | 0
 |  |  | SO-2242917 | JTS | 4 | AR-004165 |  | 0 | 0 | 0 | 0 | 1 | 0
 |  |  | SO-2242742 | JX | 1 | AR-006882 |  | 0 | 0 | 0 | 0 | 1 | 0
 |  |  | SO-2242938 | JX | 6 | AR-000744 |  | 0 | 0 | 0 | 1 | 0 | 0
 |  |  | SO-2242630 | JXP | 1 | AR-001426 |  | 0 | 0 | 0 | 0 | 1 | 0
 |  |  | SO-2242927 | JX | 1 | AR-001075 |  | 0 | 0 | 0 | 0 | 0 | 1
 |  |  | SO-2242869 | JTS | 12 | AR-000175 |  | 0 | 0 | 1 | 0 | 0 | 0
 |  |  | SO-2241285 | JX | 1 | AR-004394 |  | 0 | 0 | 0 | 0 | 0 | 1
 |  |  |  |  |  |  | sum count |  |  |  |  |  |  |  |  |  | sum count
 |  |  |  |  |  |  | [NAME] sum | 32 | 16 | 12 | 6 | 6 | 7 |  |  |  | Average
 |  |  |  |  |  |  | Min sum | 1 | 1 | 1 | 5 | 5 | 5
Spreadsheet: 027c20dc-5f9b-4337-afdc-61d3ae1dc9bc
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | COUNTY ATHLETIC ASSOCIATION (CAA) | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
 |  |  |  | 2012 OFFICIAL BASEBALL / SOFTBALL ROSTER
 | ASSOCIATION: | Ellisville Athletic Association |  |  |  |  |  | MANAGER: |  |  |  |  | DATE:
 | RANKING: |  |  |  |  |  |  | AGE DIVISION:
 | Boys (National, American, Continental) |  |  |  |  |  |  |  |  | Boys (8U, 9U, 10U, 11U, 12U, 13U, 15U, HS)
 | Girls (1, 2, 3, 4, 5) |  |  |  |  |  |  |  |  | Girls (8U, 9U, 10U, 11U, 12U, 13U, 15U, HS)
Line |  |  |  |  |  |  |  |  |  |  |  |  |  | Birth Date
No | Name |  | Signature |  |  | Address |  |  | City, State, Zip |  |  | Phone |  | MM | DD | YY
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
 |  |  | ASSOCIATION/COMMISSIONER APPROVALS
 |  |  | Signatures
Home Association Approval
County Athletic Association Approval
County Athletic Association Approval
Spreadsheet: sally_beck__35349__Piper Q's
Sheet: Sheet1

[NAME]
1.  EGM is showing increases of $5.5mm and $16.2mm in operations expense and IT Development expense.
 | EGM has experienced significant growth.  As a result, headcount for Operations is expected to grow.
 | This resulted in increased costs, especially in the Risk Management and Financial Commodities areas.
 | The growth also results in larger bonus and indirect dollars.  [NAME] has indicated that much
 | of the IT Development work for EGM got under way mid-year 2001.  2002 will reflect a full year of
 | maintenance on those projects as well a full year of upgrades.  EGM is still evaluating their project
 | list and this could still come down.
2.  EIM Infrastructure is up $2.3mm.
 | This increase is driven primarily by headcount increase and increased server usage. (Server
 | infrastructure is up $0.7mm, desktop support is up $0.8mm)
3.  Energy Operations for EES is down $9.1MM.
 | This is changing as we approach the EES meeting.  They have added an additional $5.7mm.
4.  EES infrastructure capital is down $19.7.
 | 2001 Infrastructure costs are shown as going to EES because they were spent by EES prior to
 | [NAME] getting it.  In 2002, all capital is shown in Net Works.  This is a reporting variance and
 | can be reclassified if desired.
5.  Corp infrastructure is up 13.9.
 | Primary driver here is that they receive the depreciation on the new building.  In 2002, they will get
 | a full year versus a small amount in 2001.
6.  Depreciation in 2001 plan is $62mm, in 2001 Forecast is $30.1mm and in 2002 Plan is $57.8mm.
 | The 2001 Plan was built at a high level and assumed a 3 year life on all assets while a great portion
 | have 5 year lives.  In addition, EA's expected transfer of assets was lower than expected.  Also,
 | the 2001 Plan double counted the new building depreciation while the new building is going in service
 | much later than anticipated in the 2001 Plan.  The 2002 Plan depreciation is down slightly for pre-
 | 2001 assets, but it includes a full year of depreciation for 2001 capital expenditures and a partial year
 | for 2002 capital expenditures.  In addition, 2002 includes "catch up" amortization for the Lucent
 | assets on ETS' books which is billed to us.
Spreadsheet: 882008d1730258615-using-a-word-in-a-formula-where-the-word-has-a-set-numerical-value-test-kits
Sheet: Formula

 | Category |  | Crestron UC |  |  |  |  |  | Crestron Transmitters |  |  |  | Crestron Recievers |  | Displays |  |  |  | Mounts |  |  |  | SpeakerBar Mount |  | 2x1
 | Kit # | Total Cost | UC_B30_T | UC_BX30_T | UC_C100_T | UC_CX100_T | UC_M50_T | X | HD_TXC_4KZ_101_1G_W | HD_TXC_4KZ_101 | HD_TX_301_C_E | HD_TX_4KZ_401 | HD_RXC_4KZ_101 | HD_RX_4K_210_C_E | 4P_B55EJ2U | 4P_B65EJ2U | 4P_B75EJ2U | 4P_B86EJ2U | ST650 | ST660 | ST670 | SA771PU | MD5428 | X | HD-MD4X1-4KZ-E | X
Room Size | S2000 part # | Cost | 50 | 60 | 70 | 80 | 90 | 0 | 10 | 20 | 30 | 40 | 10 | 20 | 10 | 20 | 30 | 40 | 10 | 20 | 30 | 40 | 10 | 0 | 10 | 0
X-Small | XSM-SGL-VC-1WP
 | XSM-SGL-UTVC-1
Small | SM-SGL-VC-1WP
 | SM-SGL-VC-2WP
 | SM-SGL-VC-1TBL
 | SM-SGL-VC-2TBL
 | SM-SGL-UTVC-1WP
 | SM-SGL-UTVC-1TBL
 | SM-SGL-UTVC-2WP
 | SM-SGL-UTVC-2TBL
 | SM-SGL-UXTVC-1WP
 | SM-SGL-UXTVC-1TBL
 | SM-SGL-UXTVC-2WP
 | SM-SGL-UXTVC-2TBL
 | SM-DUAL-UTVC-1WP
 | SM-DUAL-UTVC-1TBL
 | SM-DUAL-UTVC-2WP
 | SM-DUAL-UTVC-2TBL
 | SM-DUAL-UXTVC-1WP
 | SM-DUAL-UXTVC-1TBL
 | SM-DUAL-UXTVC-2WP
 | SM-DUAL-UXTVC-2TBL
Medium | MED-SGL-VC-1WP
 | MED-SGL-VC-2WP
 | MED-SGL-VC-1TBL
 | MED-SGL-VC-2TBL
 | MED-SGL-UTVC-1WP
 | MED-SGL-UTVC-1TBL
 | MED-SGL-UTVC-2WP
 | MED-SGL-UTVC-2TBL
 | MED-SGL-UXTVC-1WP
 | MED-SGL-UXTVC-1TBL
 | MED-SGL-UXTVC-2WP
 | MED-SGL-UXTVC-2TBL
 | MED-DUAL-UTVC-1WP
 | MED-DUAL-UTVC-1TBL
 | MED-DUAL-UTVC-2WP
 | MED-DUAL-UTVC-2TBL
 | MED-DUAL-UXTVC-1WP
 | MED-DUAL-UXTVC-1TBL
 | MED-DUAL-UXTVC-2WP
 | MED-DUAL-UXTVC-2TBL
Large | LRG-SGL-VC-1WP
 | LRG-SGL-VC-2WP
 | LRG-SGL-VC-1TBL
 | LRG-SGL-VC-2TBL
 | LRG-SGL-UTVC-1WP
 | LRG-SGL-UTVC-1TBL
 | LRG-SGL-UTVC-2WP
 | LRG-SGL-UTVC-2TBL
 | LRG-SGL-UXTVC-1WP
 | LRG-SGL-UXTVC-1TBL
 | LRG-SGL-UXTVC-2WP
 | LRG-SGL-UXTVC-2TBL
 | LRG-DUAL-UTVC-1WP
 | LRG-DUAL-UTVC-1TBL
 | LRG-DUAL-UTVC-2WP
 | LRG-DUAL-UTVC-2TBL
 | LRG-DUAL-UXTVC-1WP
 | LRG-DUAL-UXTVC-1TBL
 | LRG-DUAL-UXTVC-2WP
 | LRG-DUAL-UXTVC-2TBL
Spreadsheet: 66398d1267053762-looping-a-named-range-excel_namedrangequeryoperation
Sheet: MergedData

Below is the final Result of making a query into the other 3 tabs
The Query brought in all data from other tabs that are between Dates : Jan-2006 to Jun-2006
Imported | Imported | Imported
Read Date | Days | kWh | Comment
2006-01-18 00:00:00 | 35 | 280800 | CityHall_Elec
2006-02-14 00:00:00 | 27 | 223200 | CityHall_Elec
2006-03-14 00:00:00 | 28 | 234000 | CityHall_Elec
2006-04-13 00:00:00 | 30 | 238800 | CityHall_Elec
2006-05-15 00:00:00 | 32 | 231600 | CityHall_Elec
2006-06-15 00:00:00 | 31 | 266400 | CityHall_Elec
2006-01-18 00:00:00 | 35 | 46942.81 | CityHall_Gas
2006-02-14 00:00:00 | 27 | 40837.695 | CityHall_Gas
2006-03-14 00:00:00 | 28 | 48376.308 | CityHall_Gas
2006-04-13 00:00:00 | 30 | 30069.462 | CityHall_Gas
2006-05-15 00:00:00 | 32 | 10810.728 | CityHall_Gas
2006-06-15 00:00:00 | 31 | 1492.991 | CityHall_Gas
2006-01-26 00:00:00 | 28 | 57900 | OperationsOffice
2006-02-27 00:00:00 | 32 | 77700 | OperationsOffice
2006-03-27 00:00:00 | 28 | 58200 | OperationsOffice
2006-04-26 00:00:00 | 30 | 52200 | OperationsOffice
2006-05-25 00:00:00 | 29 | 47400 | OperationsOffice
2006-06-23 00:00:00 | 29 | 44400 | OperationsOffice
Spreadsheet: c6b1c15f-6528-4a1b-b908-5332931a9702
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Paramount | 667068645224 | Various | [NAME]: King Of Dreams (D-Se-Ws) | 2008-12-02 | DVD | Children | 7.99 | Y | Available
Paramount | 97368748347 | Peanuts | Cbs: Boy Named [NAME] (D-Se) | 2008-12-02 | DVD | Children | 14.99 | Y | Available
Paramount | 667068485325 | Various | Prince Of Egypt | 1999-09-01 | DVD | Children | 7.99 | Y | Available
Spreadsheet: 04dde212-d892-47dc-b9b7-a26720332b28
Sheet: Sheet1

RFP #13-010 INTERIOR PAINTING OF FIVE (5) CARROLLTON FACILITIES | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 | Artistic Painting Company | Allbrite Construction of Texas | Smith's Painting | Myelyn Contractors | Jonsco Commercial Painting | Concord Commercial Services | J.N.A. Painting Company | Peters Contracting Services | C Tanner Painting | JC & RJ Contracting | Tarrant Paint and Stain | KC Construction Services
Central Services Center | 37020 | 32013 | 23000 | 40240.8 | 22756 | 20230.4 | 13410 | 22900 | 23846 | 218452.4 | 21000 | 15376.87
H&J Library | 30941 | 39432 | 27800 | 49566.6 | 24868 | 21918.4 | 16531 | 19300 | 29373 | 151514.4 | 19000 | 23834.2
[NAME] | 30517 | 45645 | 22200 | 56700 | 31072 | 20300.8 | 19125 | 26000 | 34000 | 153914.4 | 20500 | 24625.24
Senior Center | 16642 | 18258 | 12000 | 21250 | 15616 | 11526.4 | 7650 | 9900 | 16600 | 137414.4 | 13000 | 16348.16
[NAME]. Ctr. (old section only) | 25557 | 24652 | 18500 | 31050 | 28615 | 23546.2 | 10350 | 16500 | 23000 | 120514.4 | 22000 | 33077.42
TOTAL | 140677 | 160000 | 103500 | 198807.4 | 122927 | 97522.2 | 67066 | 94600 | 126819 | 781810 | 95500 | 113261.89
Bond or Check? | C | B | B | B | B | B | B | C | No bond/check | C | B | B
Days to complete if an exception to 60 days is noted | 75 |  |  |  |  | 58 | 45 | 50-55
 |  |  |  |  |  |  |  |  |  |  | Bid total is $500 less than total of all sites
Spreadsheet: 845164d1696684478-calculating-minutes-and-rewards-over-time-rewards-and-sanctions-aligw
Sheet: Week 3

Name | Reward | 5 Min | 10 Min | No. Time outs | Total Min in time out this week | Orange | Red | Reward Total | Average Reward For Week | Total no. Time outs
Test | 20 | 1 | 2 |  |  | Yes | Yes
Kelly | 25 | 2 | 0
[NAME] | 15 | 1 | 1
Arya | 30 | 3 | 1 |  |  | Yes
[NAME] | 10 | 0 | 2 |  |  |  | Yes
Spreadsheet: 79757d1279938200-sorting-a-football-soccer-league-table-footy-prediction-game-nealry-complete
Sheet: Sheet2

PREMIER LEAGUE
TEAM | PLAYED | WON | LOST | DRAWN | F | A | [NAME] | PTS | RANK
CHAMPIONSHIP
TEAM | PLAYED | WON | LOST | DRAWN | F | A | [NAME] | PTS | RANK
LEAGUE ONE
TEAM | PLAYED | WON | LOST | DRAWN | F | A | [NAME] | PTS | RANK
LEAGUE TWO
TEAM | PLAYED | WON | LOST | DRAWN | F | A | [NAME] | PTS | RANK
PLAYERS PREDICTION TABLE
PLAYER | PLAYED | EXACT | WON | LOST | F | A | [NAME] | PTS
Spreadsheet: 39866d1238130176-pulling-information-from-master-sheet-onto-subsheets-automatically-test
Sheet: Master

Contact ID | Name | Phone | Category
1 | [NAME] | 45235 | Hot
2 | [NAME] | 13241 | Cold
3 | [NAME] | 25425 | Warm
4 | [NAME] | 546456 | Warm
5 | Mariano | 45235 | Hot
6 | Ita | 13241 | Hot
7 | Cat | 25425 | Cold
8 | [NAME] | 546456 | Warm
9 | Cassidy | 45235 | Warm
10 | [NAME] | 13241 | Cold
11 | Geno | 25425 | Cold
12 | Babs | 546456 | Cold
13 | [NAME] | 45235 | Cold
14 | [NAME] | 13241 | Warm
15 | Kochie | 25425 | Hot
16 | [NAME] | 546456 | Cold
17 | [NAME] | 2465336 | Warm
18 | [NAME] | 8797 | Warm
Spreadsheet: 78528d1278933683-automatic-summing-using-excel-functions-sample
Sheet: Sheet1

 | Cycle 1 |  |  | Cycle 2
 | Table1 |  |  | Table1
ID1 | 1 |  | ID2 | 3
ID2 | 2 |  | ID3 | 5
ID3 | 3 |  | ID4 | 9
 | After Cycle 1 |  |  | After Cycle 2
 | Summary |  |  | Summary
ID1 | 1 |  | ID1 | 1
ID2 | 2 |  | ID2 | 5
ID3 | 3 |  | ID3 | 8
 |  |  | ID4 | 9
Spreadsheet: 63854d1264708598-employees-project-report-summary-try
Sheet: Susan

Sue
Description |  |  |  |  |  |  |  | Total prod for week
 |  | Hours | Hours | Hours | Hours | Hours
 |  | 0 | 135 | 0 | 0 | 0 |  | 135
 |  | Monday | Tuesday | Wednesday | Thursday | Friday
[NAME] |  |  |  |  |  |  |  | 0
Service Request |  |  |  |  |  |  |  | 0
Business Report |  |  |  |  |  |  |  | 0
Homelink Support |  |  |  |  |  |  |  | 0
Data Fixes |  |  |  |  |  |  |  | 0
Support |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
[NAME] |  | 2 | 5 | 2 |  | 1 |  | 10 | CCR1
CCR00004 |  |  |  | 2 |  | 8 |  | 10 | [NAME]
CCR00006 |  | 5 |  | 5 | 5 | 5 |  | 20 | CCR6
CCR00005 |  | 5 | 5 | 5 | 5 | 5 |  | 25 | CCR5
CCR00002 |  | 5 | 10 | 10 | 5 |  |  | 30 | [NAME]
CCR00003 |  | 10 | 10 | 10 | 10 |  |  | 40 | CCR3
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Meeting |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Training, Company Conference, etc |  |  |  |  |  |  |  | 0
Flexi, sickness,leave |  |  |  |  |  |  |  | 0
Spreadsheet: 113387d1309301735-copy-pasting-formating-to-numbers-ss
Sheet: HELP

 | $20,484.54
 | $361.88
 | $8,687.50
 | $6,126.21
 | $12,432.65
 | $5,882.09
 | $184.03
 | $472.75
 | $164.47
 | $2,757.23
 | $8,113.06
 | $22,976.57
 | $1,311.36
 | $102,079.15
 | $808.78
 | $361.88
 | $48,899.35
 | $3,232.63
 | $19,247.83
 | $97.85
 | $21,435.78
 | $1,144.64
 | $484.89
 | $2,115.50
 | $1,459.81
 | $509.04
 | $1,503.51
Spreadsheet: 873660d1720171252-if-function-with-sumifs-if-statement-and-sumif
Sheet: Result

 | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12
 | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar
Financial Year |  |  |  |  |  |  |  |  |  |  |  |  | Total
Cost 1
Cost 2
Cost 3
Cost 4
Cost 5
Cost 6
Cost 7
Cost 8
Cost 9
Total
Exepected Results
 | ACTUAL | ACTUAL | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | Total
Cost 1 | 10000 |  | 0 |  | 18000 |  | 25000 |  | 25000
Cost 2
Cost 3
Cost 4
Cost 5 |  | 28000 |  |  | 12000 |  |  | 63000
Cost 6
Cost 7
Cost 8
Cost 9
Total
HI team
Could someone please assist to help me pull through the actual or forecast for specific  month on my expected result-so at any time when the actual or forecast changes by moving the cell from the source data my result tab will update
On the if statement formular my value if criteria should only pick the sum of forecast for specific month if it is not actual.
Spreadsheet: 163218d1340224843-changing-three-columns-of-data-in-to-a-table-in-excel-2007-sample-book1-xman304-oeldere-
Sheet: Sheet1

Well Number | Formation | Code
1 | x | A1
1 | y | A2 |  |  | Aantal van Code | Kolomlabels
1 | z | A3 |  |  | Rijlabels | x | y | z | Eindtotaal
2 | x | A4 |  |  | 1 | 1 | 1 | 1 | 3
2 | z | A5 |  |  | A1 | 1 |  |  | 1
 |  |  |  |  | A2 |  | 1 |  | 1
 |  |  |  |  | A3 |  |  | 1 | 1
 |  |  |  |  | 2 | 1 |  | 1 | 2
I want This |  |  |  |  | A4 | 1 |  |  | 1
Formation Code | X | Y | Z |  | A5 |  |  | 1 | 1
Well Number |  |  |  |  | Eindtotaal | 2 | 1 | 2 | 5
1 | A1
1 |  | A2
1 |  |  | A3
2 | A4
2 |  |  | A5
Spreadsheet: 36934d1234891167-help-with-index-match-vlookup-example-index-and-match-just-use-vlookup
Sheet: Pricer

Qty | Description | Part# | Retail | Extended
2 | HayS44SandFilter
 | HayS44SandFilter
 | Tristar1.5hp2sp
 | HayS44SandFilter
 | HayS44SandFilter
 | Tristar1.5hp2sp
 | Tristar1.5hp2sp
 | HayS44SandFilter
 | HayBooster
 | HayS44SandFilter
 | HayS44SandFilter
 | HayS44SandFilter
 | HayS44SandFilter
 | Tristar1.5hp2sp
 | HayS44SandFilter
 | HayS44SandFilter
 | Tristar1.5hp2sp
Spreadsheet: 708137d1607623613-work-delay-we-have-given-a-task-and-want-to-count-how-much-is-work-delay-or-work-on-time-test-work-delay
Sheet: Sheet1

S.No. | Date | Day | Office Timing | Work Given to | Work Name | Work Deadline | Work Finish Time |  | Delay / Comp
 |  |  |  |  |  |  | Work Done | Date and Time (MM:DD:YY)
1 | 2020-12-03 00:00:00 | Thursday | 9:00 am to 6:00 pm | Rohit | Work 1 | 2020-04-12 16:00:00 | Rohit Work 1 Done | 2020-07-12 05:00:00 | - 19:00:00 | Work Late by 19 Hour
2 | 2020-12-04 00:00:00 | Friday | 9:00 am to 6:00 pm | [NAME] | work 2 | 2020-07-12 11:00:00 | [NAME] Work 2 Done | 2020-07-12 10:30:00 | 00:30:00 | Work done before time
3 | 2020-12-05 00:00:00 | Saturday | 9:00 am to 6:00 pm | Rohit | Work 3 | 2020-05-12 14:00:00 | Rohit Work 3 Done | 2020-05-12 17:00:00 | - 03:00:00 | Work Late by 3 Hour
4 | 2020-12-06 00:00:00 | Sunday | 9:00 am to 6:00 pm | Off
5 | 2020-12-07 00:00:00 | Monday | 9:00 am to 6:00 pm | [NAME] | Work4 | 2020-09-12 17:00:00 | [NAME] Work4 Done | 2020-10-12 17:00:00 | - 08:00:00 | Work Late by 8 Hour
6 | 2020-12-08 00:00:00 | Tuesday | 9:00 am to 6:00 pm | Holiday
7 | 2020-12-09 00:00:00 | Wednesday | 9:00 am to 6:00 pm
7 | 2020-12-10 00:00:00 | Thursday | 9:00 am to 6:00 pm
 |  |  | 9:00 am to 6:00 pm | Working Hour is 9 Hour
Spreadsheet: 747961d1631805260-copy-information-from-multiple-tables-to-a-sheet-bwp-invoices
Sheet: NEEDED INFO

Invoice Number | [NAME] | Item Number | Invoice Date | Total Qty | Unit Price | Extended Price
78080 | [NAME] | UR52005 | 2021-09-10 00:00:00 | 2 | 630
78089 | P413752 | UR52006 | 2021-09-13 00:00:00 | 2 | 630
78088 | PN32324 | 300763 | 2021-09-10 00:00:00 | 1 | 395
78070 | PN30128 | 260086 | 2021-09-09 00:00:00 | 8 | 64
78071 | PN30784 | 451729 | 2021-09-09 00:00:00 | 1 | 303
78072 | PN31022 | 451729 | 2021-09-09 00:00:00 | 1 | 303
Spreadsheet: tracy_geaccone__40417__Expense Analysis1
Sheet: Sheet1

 |  | OCTOBER
 | PLAN | CE | ACTUALS |  | NOV | NOV |  | DEC | DEC |  | 2001 | 2001
 | YTD | YTD | YTD |  | PLAN | CE |  | PLAN | CE |  | PLAN | CE
Regulatory |  |  |  |  | -0.704 | -0.704 |  | -0.732 | -0.732
O&M Expenses |  |  |  |  | -0.156 | -0.163 |  | -0.358 | -0.164
Aviation | -0.3 | 0 | 0 |  | 0 | 0 |  | -0.1 | -0.1
Other/Revenue Mangement |  |  | 0.048 |  | 0 | 0 |  | -0.1 | -0.06
UAF | -1.749 |  |  |  | 0.081 | 0.081 |  | -0.103 | -0.103
Spreadsheet: 152778d1335523719-calculating-number-of-unique-numericla-instances-in-a-pivott-forum
Sheet: Arkusz1

 | customer_name | line_id
 | [NAME] | 5556677
 | [NAME] | 5556677
 | [NAME] | 5556677
 | [NAME] | 5556677
 | [NAME] | 5556677
 | [NAME] | 5568874
 | [NAME] | 5568874
 | [NAME] | 5568874 |  |  | [NAME] z [NAME] | Etykiety kolumn
 | [NAME] | 5568874 |  |  | Etykiety wierszy | 5556677 | 5566332 | 5568874 | 7788554 | 9944887 | 9945783 | Suma końcowa
 | [NAME] | 5568874 |  |  | [NAME] | 6 |  | 5 | 1 | 1 | 3 | 16
 | [NAME] | 7788554 |  |  | [NAME] |  |  |  | 2 |  |  | 2
 | [NAME] | 7788554 |  |  | [NAME] |  | 1 |  |  |  |  | 1
 | [NAME] | 9945783 |  |  | Suma końcowa | 6 | 1 | 5 | 3 | 1 | 3 | 19
 | [NAME] | 9945783
 | [NAME] | 9945783
 | [NAME] | 7788554
 | [NAME] | 5556677
 | [NAME] | 5566332
 | [NAME] | 9944887
Spreadsheet: 677803d1589531783-return-results-based-on-selections-sample
Sheet: Sheet1

 | Requirements |  |  | Inventory
Content 1 | Box 1
Content 2 | Box 1
Content 3 | Box 1
Content 4 | [NAME]
Content 5 | [NAME]
Content 6 | [NAME]
Content 7 | Box 1 | [NAME]
Content 8 | Box 1 | [NAME]
Content 9 | Box 1 | [NAME]
Content 10 | Box 1 | [NAME]
Spreadsheet: 725721d1616817761-auto-populate-values-from-raw-data-using-multiple-criteria-sheetscreenshot
Sheet: Sheet1

Date | Symbol | Type | Sector | MANUAL | CLOSE | H1 | H2 | H3 | H4 | H5 | DAY
2021-02-17 00:00:00 | TEMP | BEST | FMCG
 | 2021-02-17 00:00:00 | 2021-02-17 00:00:00 | 2021-02-18 00:00:00 | 2021-02-18 00:00:00 | 2021-02-19 00:00:00 | 2021-02-19 00:00:00 | 2021-02-22 00:00:00 | 2021-02-22 00:00:00 | 2021-02-23 00:00:00 | 2021-02-23 00:00:00 | 2021-02-24 00:00:00 | 2021-02-24 00:00:00
Symbol | CLOSE | HIGH | CLOSE | HIGH | CLOSE | HIGH | CLOSE | HIGH | CLOSE | HIGH | CLOSE | HIGH
TEMP | 100 | 200 | 101 | 104 | 95 | 99 | 102 | 109 | 101 | 106 | 98 | 102