tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 328581d1403953186-multiple-variables-to-calculate-a-value-pricing_calculator_solution
Sheet: Therm BiPass

Product price | PRICE PER SQUARE METER
90mm & 114 Blades | TRADITIONAL TILTBAR | CLEARVIEW TILT BAR | ULTRA TILTBAR
Panels under 700[NAME] wide | 154 | 159 | 179 |  | Panels under 700[NAME] wide
Panels 700mm – 900mm wide | 177 | 182 | 202 |  | Panels 700mm – 900mm wide
 |  |  |  |  | Panels under 500mm wide
 | PRICE PER SQUARE METER |  |  |  | Panels 500mm – 750[NAME] wide
64mm Blades | TRADITIONAL TILTBAR | CLEARVIEW TILT BAR | ULTRA TILTBAR
Panels under 500mm wide | 154 | 159 | 179
Panels 500mm – 750[NAME] wide | 177 | 182 | 202
Option 1 |  |  |  |  | Option 2
 | [NAME] | [NAME] | [NAME] |  |  | [NAME] | [NAME] | [NAME] |  |  |  |  | Set 1 |  | Dependancy set 2 |  |  |  |  |  | Dependancy set 3
For square [NAME] calculation enter [NAME] and [NAME] | 1500 | 2000 |  |  | For square [NAME] calculation enter [NAME] and [NAME] | 1500 | 2000 |  |  |  |  |  | [NAME] |  | _90mm |  | _90mm |  | _64mm |  | panels under 700mm |  | Panels 700 - 900mm |  | Panels under 700mm |  | Panels 700 - 900mm
Blade size | _114mm |  |  |  | Blade size | 114 |  |  |  |  |  |  | _64mm |  | panels under 700mm |  | Panels under 700mm |  | Panels under 500mm wide |  | Traditional SP |  | Traditional LP |  | Traditional SP |  | Traditional LP
Panel Size | panels_under_700mm |  |  |  | Panel Size | 200 |  |  |  |  |  |  | _90 mm |  | Panels 700 - 900mm |  | Panels 700 - 900mm |  | Panels 500mm – 750[NAME] wide |  | Clear View SP |  | Clear View LP |  | Clear View SP |  | Clear View LP
Tilt bar options | =INDIRECT |  |  |  | Tilt bar options | Clear View |  |  |  |  |  |  | _114mm |  |  |  |  |  |  |  | Ultra Clear SP |  | Ultra Clear LP |  | Ultra Clear SP |  | Ultra Clear LP
 | Trying to use a third dependant list but can't get it together |  | ? |  | The Price per square metre used in this calculation is $222 per Sq Mtr
 |  |  | Anuy ideas |  |  |  |  | This formula does not take into account the tilt bar options
[NAME]
64
90
114
Tilt Bar
Traditional
Clear View
Ultra Clear
Panels
90 mm and 114 mm blades Panels under 700mm
90 mm and 114 mm Panels 700 - 900mm
64 mm blades Panels under 500mm
64 mm Panels 500 - 750mm
Spreadsheet: 877989d1724941866-pull-names-from-several-sheets-into-total-sheet-only-if-criteria-is-met-referralexcel-2-
Sheet: Sheet1

REF? | ID | PATIENT | DATE | PROVIDER
 | a1234 | Smith, W | 2024-06-25 00:00:00 | BARNEY, A
y | b1234 | Smith, X |  | FRED, B
 | c1234 | Smith, Y | 2024-05-13 00:00:00 | WILMA, C
 | d1234 | Smith, Z | 2024-04-19 00:00:00 | BETTY, D
 | E1234 | Jones, A |  | PEBBLES, E
X | f1234 | Jones, B | 2023-08-01 00:00:00 | BAMBAM, F
Spreadsheet: joe_parks__14578__EES Nymex & Basis Mar 21
Sheet: Price

EES Retail Gas Price positions ( Includes OXY positions )
 | MONTH
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | TOTAL
2002 |  |  |  | -4097051 | -3366671 | -2763602 | -2485180 | -2390023 | -2240529 | -2561659 | -2766201 | -3082374 | -25753291
2003 | -2966621 | -2752489 | -2514574 | -1884465 | -1552524 | -1258443 | -1145826 | -1109431 | -1103062 | -1320379 | -1608401 | -1840182 | -21056398
2004 | -1955987 | -1786165 | -1615597 | -1218824 | -996845 | -611411 | -521634 | -510980 | -535579 | -720977 | -914954 | -1070973 | -12459926
2005 | -1193182 | -1095092 | -955954 | -690903 | -529342 | -377510 | -357385 | -327786 | -316670 | -354319 | -347364 | -398726 | -6944234
2006 | -394237 | -372523 | -368430 | -315121 | -207841 | -131247 | -126910 | -85756 | -83661 | -100401 | -108574 | -120579 | -2415280
2007 | -123848 | -111604 | -113449 | -93094 | -80548 | -74895 | -2211 | -2168 | -2679 | -4023 | -3064 | -5949 | -617532
2008 | -4566 | -4537 | -2384 | -1563 | -1374 | -771 | -769 | -759 | -649 | -654 | -654 | -635 | -19316
2009 | -644 | -634 | -654 | -654 | -649 | -644 | -644 | -644 | -649 | -654 | -654 | -634 | -7762
2010 | -644 | -634 | -654 | -654 | -649 | -644 | -644 | -644 | -649 | -654 | -654 | -634 | -7761
2011 | -644 | -634 | -654 | -654 | -649 | -644 | -644 | -644 | -649 | -654 | -654 | -634 | -7759
2012 | -644 | -634 | -654 | -654 | -649 |  |  |  |  |  |  |  | -3235
TOTAL | -6641018 | -6124947 | -5573005 | -8303638 | -6737741 | -5219812 | -4641848 | -4428836 | -4284777 | -5064376 | -5751175 | -6521320 | -69292494
Spreadsheet: 767549d1644514711-index-match-errors-index-match
Sheet: Campaign report (6)

Campaign report
November 1, 2021 - January 31, 2022
Campaign status | Campaign | Budget name | Currency code | Budget | Budget type | Status | Status reasons | Optimization score | Campaign type | Clicks | Impr. | CTR | Avg. CPC | Cost | Search impr. share | Search lost IS (budget) | Search lost IS (rank) | Bid strategy type | Conv. rate | Conversions | Cost / conv. | Assisted
Enabled | PPC_BR_Brand | -- | USD | 5 | Daily | Eligible (Limited) | bidding strategy limited; limited by budget; unknown | 86.63 | Search | 112 | 925 | 0.1211 | 2.17 | 242.71 | 0.3926 | 0.1531 | 0.4544 | Target Impression Share | 0.3036 | 34 | 7.14
Enabled | PPC_NB_Invisalign | -- | USD | 10 | Daily | Eligible | unknown | 79.21 | Search | 79 | 3095 | 0.0255 | 5.83 | 460.4 | 0.1341 | 0.4433 | 0.4226 | Maximize Conversions | 0.1139 | 9 | 51.16
Enabled | PPC_NB_Orthodontist | -- | USD | 20 | Daily | Eligible (Limited) | limited by budget; unknown | 63.03 | Search | 235 | 4880 | 0.0482 | 4.24 | 997.03 | < 10% | 0.8744 | 0.0511 | Target CPA | 0.3021 | 71 | 14.04
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I'm trying to pull assisted values from another workbook. The amount of rows won't be the same as this sheet. Is that the issue?
Spreadsheet: 685449d1594021390-cant-figure-out-mid-function-shift-leave-with-datedif-aligw
Sheet: Leave Roster

 |  |  | Year: | 2023-01-01 00:00:00
 |  | Annual Leave Groups
 |  | Group 1 |  |  | Group 2 |  |  | Group 3 |  |  | Group 4
 |  |  |  |  |  | J |  |  | P |  |  | M
 |  |  |  |  |  | G |  |  | J |  |  | M
 |  |  |  |  |  | A |  |  |  |  |  | D
 | 2010-01-01 00:00:00
 | 3241
 | 4132 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024
 | 1423 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 3 | 2 | 4 | 1 | 3 | 2 | 4
 | 2314 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 4 | 1 | 3 | 2 | 4 | 1 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 2 | 4 | 1 | 3 | 2 | 4 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 1 | 3 | 2 | 4 | 1 | 3 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 3 | 2 | 4 | 1 | 3 | 2 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 4 | 1 | 3 | 2 | 4 | 1 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 1 | 4 | 2 | 3 | 1 | 4 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 2 | 3 | 1 | 4 | 2 | 3 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Group | Person
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Jordan
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | Jules
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Mitch
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | [NAME]
Spreadsheet: 2b08da71-f1ac-4b52-9cd5-5801ca9ccc9d
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40844280 | 2014-04-04 23:58:47 | AXIS | 1 | 6 | 3 | 29441 | w a r r i o r | 12503 | eastern | 1941-07-22 | 1941-07-22 | Lipovec | Lipovec
40844623 | 2014-04-05 00:21:28 | ALLIES | 0 | 5 | 6 | 29441 | w a r r i o r | 12503 | eastern | 1941-07-22 | 1941-07-22 | Lipovec | Lipovec
40855526 | 2014-04-05 18:01:08 | ALLIES | 1 | 6 | 4 | 1479663 | [NAME] Pede | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
40855792 | 2014-04-05 18:20:50 | AXIS | 0 | 3 | 6 | 1479663 | [NAME] Pede | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
40856128 | 2014-04-05 18:38:59 | AXIS | 1 | 6 | 2 | 205567 | lenaianel | 8044 | eastern | 1942-01-26 | 1942-02-07 | Rzhev | Rzhev
40856341 | 2014-04-05 18:56:55 | ALLIES | 1 | 6 | 3 | 205567 | lenaianel | 8044 | eastern | 1942-01-26 | 1942-02-07 | Rzhev | Rzhev
40952343 | 2014-04-12 09:11:04 | AXIS | 0 | 4 | 6 | 1026292 | Fabdel FR | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
40952529 | 2014-04-12 09:34:35 | ALLIES | 1 | 6 | 3 | 1026292 | Fabdel FR | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
40960787 | 2014-04-12 21:49:41 | ALLIES | 1 | 6 | 4 | 1009110 | HO-SA-KAI | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
40961245 | 2014-04-12 22:17:13 | AXIS | 0 | 4 | 6 | 1009110 | HO-SA-KAI | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
40969527 | 2014-04-13 13:14:23 | ALLIES | 1 | 6 | 3 | 29441 | w a r r i o r | 7663 | pacific | 1944-07-21 | 1944-07-21 | Guam Landings | Débarquement à Guam
40969723 | 2014-04-13 13:34:24 | AXIS | 0 | 5 | 6 | 29441 | w a r r i o r | 7663 | pacific | 1944-07-21 | 1944-07-21 | Guam Landings | Débarquement à Guam
40992349 | 2014-04-14 22:07:53 | AXIS | 1 | 6 | 0 | 1467243 | [NAME] | 7596 | eastern | 1941-12-07 | 1941-12-08 | Breakout at Klin | Évasion à Klin
40992607 | 2014-04-14 22:30:59 | ALLIES | 0 | 5 | 6 | 1467243 | [NAME] | 7596 | eastern | 1941-12-07 | 1941-12-08 | Breakout at Klin | Évasion à Klin
41006718 | 2014-04-15 22:19:07 | ALLIES | 0 | 1 | 4 | 615831 | cedroxx | 6161 | western | 1944-06-10 | 1944-06-10 | Mont Mouchet | Mont Mouchet
41007195 | 2014-04-15 22:41:28 | AXIS | 1 | 4 | 0 | 615831 | cedroxx | 6161 | western | 1944-06-10 | 1944-06-10 | Mont Mouchet | Mont Mouchet
Spreadsheet: 67398d1268047849-hyperlink-not-working-09-sep-accrual-sheet-version-1-
Sheet: 301405 - greenway to station

 | Work Description:
 | WBS: |  |  |  |  |  | UPDATED: | 2009-08-27 00:00:00
 | Contractor:
 | Contract No:
 | Order Nos:
 | ALL FIGURES TO EXCLUDE VAT
 |  |  |  |  | A | B | C
 | OVERALL POSITION FOR THIS CONTRACT
 | P Code  NOT APPLICABLE | Description | Monthly Assessment Date | Most Current Application Date (by [NAME]): | Gross (cumulative) Application (from Contractor) | Contract Administrator's (cumulative) assessment (build up in file) | Accrual  C=B-A | Comment | Latest Gross Payment to Contractor
 | -
 |  |  |  |  | TOTAL | 0
 |  |  |  |  | A | B | C
 | POSITION FOR EACH P CODE (INCLUDE LOGISTICS & OTHER PROJECTS [obtain from other Project])
 | P Code & OTHER PROJECT | Description | Monthly Assessment Date | Most Current Application Date (by [NAME]): | Gross (cumulative) Application (from Contractor) | Contract Administrator's (cumulative) assessment (build up in file) | Accrual  C=B-A | Comment | Latest Gross Payment to Contractor
 |  |  |  |  | CHECK | 0
Spreadsheet: 836953d1689757481-filter-birthdays-onto-dynamic-calendar-calendar-birthdays-aligw-updated-aligw
Sheet: Calendar

 |  | JULY |  | MONDAY
 | CALENDAR YEAR | CALENDAR MONTH |  | FIRST DAY OF WEEK |  |  |  |  | Birthdays This Month
 |  |  |  |  |  |  |  |  | To-Do This Month
Spreadsheet: 680885d1591236890-retrieve-data-from-column-while-skipping-blanks-retrieve-data-from-column-while-skipping-blanks
Sheet: Sheet1

 | NAME | [NAME] | ADDRESS | CITY | PHONE |  |  |  |  |  | [NAME]
 | [NAME] | [EMAIL] | 14510 124th ave, #A6 | Kirkland, WA 98034 |  |  |  |  |  |  | [NAME]
 | [NAME] | [EMAIL] | 14517 124th ave, #A6 | Kirkland, WA 98041 | 4259886346 |  |  |  |  |  | [NAME]
 | [NAME] |  | 14524 124th ave, #A6 | Kirkland, WA 98048 |  |  |  |  | lookup |  | [NAME]
 | [NAME] |  | 14531 124th ave, #A6 | Kirkland, WA 98055 | 3066598794 |  |  | Person: | [NAME] | lookup value | Brooklyn Odonnell
 | [NAME] |  | 14511 124th ave, #A6 | Kirkland, WA 98035 | 3543265976 |  |  |  |  |  | [NAME]
 | [NAME] | [EMAIL] |  |  |  |  |  |  |  |  | [NAME]
 | [NAME] |  | 14525 124th ave, #A6 | Kirkland, WA 98049 | 3531546467
 | [NAME] | [EMAIL] | 14532 124th ave, #A6 | Kirkland, WA 98056 | 6431113313
 | [NAME] | [EMAIL]
 | [NAME] |  | 14514 124th ave, #A6 | Kirkland, WA 98038
 | [NAME] | [EMAIL] | 14521 124th ave, #A6 | Kirkland, WA 98045 | 4679135648 |  |  |  | retrieve
 | [NAME] |  |  |  |  |  |  | email | [EMAIL]
 | [NAME] | [EMAIL] | 14513 124th ave, #A6 | Kirkland, WA 98037 |  |  |  | address | 14513 124th ave, #A6
 | [NAME] |  |  |  | 8979874636 |  |  | city | Kirkland, WA 98037
 | [NAME] | [EMAIL] | 14527 124th ave, #A6 | Kirkland, WA 98051 | 6565465413 |  |  | phone | 8979874636
 | Brooklyn Odonnell |  | 14514 124th ave, #A6 | Kirkland, WA 98038
 | Brooklyn Odonnell | [EMAIL] | 14521 124th ave, #A6 | Kirkland, WA 98045 | 5646546544
 | Brooklyn Odonnell | [EMAIL] | 14528 124th ave, #A6 | Kirkland, WA 98052
 | [NAME] | [EMAIL]
 | [NAME] |  | 14523 124th ave, #A6 | Kirkland, WA 98047 | 5647891445
 | [NAME] | [EMAIL]
 | [NAME] |  | 14516 124th ave, #A6 | Kirkland, WA 98040
 | [NAME] | [EMAIL] | 14523 124th ave, #A6 | Kirkland, WA 98047 | 6548931464
 | [NAME] | [NAME] | 14530 124th ave, #A6 | Kirkland, WA 98054
Spreadsheet: 98403d1297311738-setting-expiry-date-with-conditional-formatting-records-for-data-input
Sheet: MASTER LIST

COURSE / AUTHORIZATION | [NAME] | G&B | [NAME] | [NAME] | SWITCHING | CABLE JOINTER | POLE INSPECTOR | CRANE OPERATOR | TRAFFIC CONTROLLER
Tower Rescue | ??
OPERATE & MAINTAIN MOBILE PLANT NSD002A | ??
HV Limited Live Line | ??
Drivers Licence | 1-5 Years
Crane Operator Supplementary | ??
Underground Service Connections | 1 Year
Resuscitation | 1 Year
Pole Top Rescue | 1 Year
Overhead Service Connections | 1 Year
METREL Overhead Service Connections | 1 Year
HV Transmission Live Line Stick | 1 Year
HV Live Line Glove & Barrier | 1 Year
HV Distrubution Live Line Stick | 1 Year
EWP Emergency Descent | 1 Year
Switching Level 3 & 4 | 2 Years
Switching Level 2 - LV Overhead | 2 Years
Switching Level 1 - LV Overhead | 2 Years
Substation Entry Level 1 or 2 | 2 Years
Recipient in Charge | 2 Years
[NAME] | 2 Years
Termidor | 2 Years
Traffic Management | 3 Years |  |  |  |  |  |  |  | NEEDS FULL COURSE
Essential First Aid | 3 Years
Perform High Risk Work | 5 Years
Fork Lift | 5 Years
Ewp | 5 Years
Earth Borer | 5 Years
Dogging | 5 Years
CV Crane Operation | 5 Years
C6 Crane Operation | 5 Years
Wood Pole Maintenance | No [NAME]
Tree Pruning Near Live LV Lines | No [NAME]
Tree Pruning Near Live HV Lines | No [NAME]
Substation Maintanance | No [NAME]
Street Light System Maintenance | No [NAME]
Security Lighting (Powerwatch) | No [NAME]
Safer Excavation near W/P Assets | No [NAME]
Pole to Pillar | No [NAME]
Pole Assessment TMX Scan | No [NAME]
Pesticide Safety & Risk Management / Termidor | No [NAME]
Overhead Line Washing | No [NAME]
Overhead line Const & Maint | No [NAME]
Operational Safety Induction | No [NAME]
MCB Replacement | No [NAME] | ALL TWISTIE STAFF ([NAME])
[NAME] | No [NAME]
LV Underground Paper Lead Cables | No [NAME]
LV ABC Construction & Maint. | No [NAME]
Live LV Underground Cable Jointing | No [NAME]
Live LV O/H Construction & Maint | No [NAME]
Installation of LV Spreaders | No [NAME]
Inductions for OHSC Project | No [NAME] | ALL TWISTIE STAFF ([NAME])
HV Underground [NAME] | No [NAME]
HV Underground Paper Lead Cables | No [NAME]
HV ABC Construction & Maint. | No [NAME]
Front line Management | No [NAME]
[NAME] Use | No [NAME]
Electrical Substation Insulator Washing | No [NAME]
[NAME] | No [NAME]
CERTIFICATE 3 | No [NAME]
Cable Layer | No [NAME]
Blue Card | No [NAME]
Basic Chainsaw Operator | No [NAME]
Spreadsheet: 022c9824-5c58-4008-b13d-2a181cc2d77f
Sheet: Combined District Planner

Enter the combined total amounts of revenue, expenditures and fund balance for all reporting districts in the yellow-shaded cells.
Districts Submitting Combined Report: |  |  | Column  A | Column  B | Column  C | Column  D
1000-Cityville, 2000-Countryland, 3001-Waterplace |  |  | FY 2012 (School Year 2011-2012) | FY 2013 (School Year 2012-2013) | FY 2014 (School Year 2013-2014) | FY 2015 (School Year 2014-2015)
 |  |  |  |  | 0 | 0
 | fy 2010 home visiting levy limit, hidden row
Line No.
 | Revenue
1 | School Readiness State Aid Entitlement |  | 0 | 0 | 0 | 0
2 | Other Government Grants, Fees, Other Local Revenue |  | 0 | 0 | 0 | 0
3 | Total Revenue = 1 + 2
4 | Expenditures |  | 0 | 0 | 0 | 0
5 | Difference, Revenue - Expenditures = 3 - 4
6 | Beginning Fund Balance |  | 0 | 0 | 0 | 0
7 | Closing Fund Balance = 5 + 6
Spreadsheet: 328343d1403876063-multiple-true-statements-but-need-one-to-override-the-other-example-workbook-for-forum-jacc3
Sheet: LookupValues

Wood |  |  | Surface |  | Board
Type | Column1 |  | Type |  | Type
s/wood | 1 |  | solid surface |  | balance
softwood | 2 |  | corian |  | veneer
poplar | 3 |  |  |  | laminate
oak | 4
sapele | 5
walnut | 6
ash | 7
beech | 8
birch | 9
cherry | 10
maple | 11
iroko | 12
cedar | 13
balsa | 14
olive | 15
Spreadsheet: 476106d1471617617-fil-an-excel-sheet-automatically-test-for-pete
Sheet: Test 2

Test 2 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | total 2016/2019 | VAR 2016/2019 | VAR 2015/2019 | CAGR 2016/2019
Total Sales projection
PAM | 1
Market Share
Sales projection %
Organic sales W/o:      - Delta P      - Growth initiatives      - New offers | 1
Growth assumptions |  | 0.01 | 0.01 | 0.01 | 0.01 | 0.01 | 0.01 | 0.01 | 0.01 | 0.01 | 0.01
Organic Value
Organic sales including:      - Delta P
Delta P % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Delta P Value
Organic sales including:      - Delta P      - Growth initiatives
Growth initiatives %
Growth initiatives Value
Organic sales including:      - Delta P      - Growth initiatives      - New offers
New Offers %
New Offers Value
BBB |  | 3 | 5 | 10
BB |  |  | 3 | 8 | 4
B
Total initiatives
222 | 0 | 1 | 2 | 3 | 4 | 0 | 0 | 0 | 0 | 0 | 0
22 | 0 | 0 | 0 | 3 | 5 | 0 | 0 | 0 | 0 | 0 | 0
2 | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0
Total New Products
Spreadsheet: 496695a2-b66a-409e-b423-c0b400cae39b
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
38735769 | 2013-11-27 22:24:50 | AXIS | 0 | 5 | 9 | 692398 | Morgiliath | 10891 | pacific | 1943-11-20 | 1943-11-23 | [NAME] Island
38736078 | 2013-11-27 22:47:56 | ALLIES | 1 | 9 | 6 | 692398 | Morgiliath | 10891 | pacific | 1943-11-20 | 1943-11-23 | [NAME] Island
38736458 | 2013-11-27 23:11:39 | ALLIES | 0 | 7 | 8 | 692398 | Morgiliath | 10891 | pacific | 1943-11-20 | 1943-11-23 | [NAME] Island
38736775 | 2013-11-27 23:25:55 | AXIS | 1 | 8 | 5 | 692398 | Morgiliath | 10891 | pacific | 1943-11-20 | 1943-11-23 | [NAME] Island
38784928 | 2013-12-01 12:11:18 | ALLIES | 1 | 9 | 4 | 622736 | [NAME] | 10891 | pacific | 1943-11-20 | 1943-11-23 | [NAME] Island
38785033 | 2013-12-01 12:25:11 | ALLIES | 1 | 9 | 5 | 622736 | [NAME] | 10891 | pacific | 1943-11-20 | 1943-11-23 | [NAME] Island
38785155 | 2013-12-01 12:39:08 | ALLIES | 0 | 7 | 8 | 622736 | [NAME] | 10891 | pacific | 1943-11-20 | 1943-11-23 | [NAME] Island
38847256 | 2013-12-05 20:54:26 | ALLIES | 1 | 9 | 6 | 622736 | [NAME] | 10891 | pacific | 1943-11-20 | 1943-11-23 | [NAME] Island
38847435 | 2013-12-05 21:06:20 | ALLIES | 1 | 9 | 6 | 622736 | [NAME] | 10891 | pacific | 1943-11-20 | 1943-11-23 | [NAME] Island
38847607 | 2013-12-05 21:19:11 | ALLIES | 1 | 9 | 6 | 622736 | [NAME] | 10891 | pacific | 1943-11-20 | 1943-11-23 | [NAME] Island
Spreadsheet: 323241d1401981412-match-and-index-function-with-repeated-values-sample
Sheet: Calculations

1 |  |  |  |  |  | Question # | Visual |  |  |  |  | Question # | Auditory |  |  |  |  | Question # | Tactile
2 |  |  |  |  |  | 2 |  |  |  |  |  | 1 |  |  |  |  |  | 4
3 |  |  |  |  |  | 3 |  |  |  |  |  | 5 |  |  |  |  |  | 6
4 |  |  |  |  |  | 7 |  |  |  |  |  | 8 |  |  |  |  |  | 9
5 |  |  |  |  |  | 10 |  |  |  |  |  | 11 |  |  |  |  |  | 12
6 |  |  |  |  |  | 14 |  |  |  |  |  | 13 |  |  |  |  |  | 15
7 |  |  |  |  |  | 16 |  |  |  |  |  | 18 |  |  |  |  |  | 17
8 |  |  |  |  |  | 19 |  |  |  |  |  | 21 |  |  |  |  |  | 20
9 |  |  |  |  |  | 22 |  |  |  |  |  | 24 |  |  |  |  |  | 23
10 |  |  |  |  |  |  |  |  | VPS= |  |  |  |  |  | APS= |  |  |  |  |  | TPS=
11
12
13
14
15
16
17
18
19 |  |  |  |  |  |  |  |  |  |  | Visual [NAME].
20 |  |  |  |  |  |  |  |  |  |  | [NAME].
21 |  |  |  |  |  |  |  |  |  |  | [NAME].
22
23
24
Spreadsheet: 78346d1278698897-vlookup-dummy_vlook
Sheet: Sheet1

PO # | PV # | [NAME] | Prod # | Product Description | [NAME] | Rec | Adj Rec | Var | Damaged?
288994 | 059090 | JOHN MORRELL & CO.    STATUS - CLOSED | 8320707 | BACON, PORK CKD SLCD REF GAS | 20 | 20 | 20 |  | VLOOKUP FUNCITON HERE (DISPLAY "YES" OR "NO")
265845 | 000417 | TYSON FOODS INC.      STATUS - CLOSED | 5875208 | CHICKEN, BRST SNGL LOBE 4Z M | 100 | 11 | 11 | -89 | VLOOKUP FUNCITON HERE (DISPLAY "YES" OR "NO")
288995 | 059884 | JOHN MORRELL & CO.    STATUS - CLOSED | 3043502 | SAUSAGE, PORK 1 Z LNK COLGN | 20 | 20 | 20 |  | VLOOKUP FUNCITON HERE (DISPLAY "YES" OR "NO")
288995 | 059884 | JOHN MORRELL & CO.    STATUS - CLOSED | 4178398 | SAUSAGE, PORK PTY MILD RAW 2 | 56 | 56 | 56 |  | VLOOKUP FUNCITON HERE (DISPLAY "YES" OR "NO")
288995 | 059884 | JOHN MORRELL & CO.    STATUS - CLOSED | 4248944 | SAUSAGE, PORK PTY WHL HOG RA | 28 | 28 | 28 |  | VLOOKUP FUNCITON HERE (DISPLAY "YES" OR "NO")
288995 | 059884 | JOHN MORRELL & CO.    STATUS - CLOSED | 5026125 | HAM, PIT W/A REF SMKD PORK | 32 | 32 | 32 |  | VLOOKUP FUNCITON HERE (DISPLAY "YES" OR "NO")
317028 | 004485 | KOCH POULTRY/BCR FOOD STATUS - CLOSED | 437822 | CHICKEN, TENDR FRITR RAW FZN | 70 | 70 | 70 |  | VLOOKUP FUNCITON HERE (DISPLAY "YES" OR "NO")
288994 | 059090 | JOHN MORRELL & CO.    STATUS - CLOSED | 8312704 | SAUSAGE, PORK PTY CKD BRWND | 40 | 40 | 40 |  | VLOOKUP FUNCITON HERE (DISPLAY "YES" OR "NO")
288993 | 002520 | JOHN MORRELL & CO     STATUS - CLOSED | 7401029 | SAUSAGE, PORK LNK SKNLS  CKD | 10 | 0 | 0 | -10 | VLOOKUP FUNCITON HERE (DISPLAY "YES" OR "NO")
288993 | 002520 | JOHN MORRELL & CO     STATUS - CLOSED | 8328569 | SAUSAGE, PORK PTY CKD FZN | 30 | 30 | 30 |  | VLOOKUP FUNCITON HERE (DISPLAY "YES" OR "NO")
303042 | 079581 | WOLVERING PACKING - F STATUS - CLOSED | 1484096 | BEEF, PTY GRND 80/20 10 Z RN | 8 | 7 | 7 | -1 | VLOOKUP FUNCITON HERE (DISPLAY "YES" OR "NO")
 |  |  |  |  |  |  |  |  | FIND OUT WHAT CATEGORY THIS VARIANCE BELONGS TO
 |  |  |  |  |  |  |  |  | VIA SHEET 2, IF IT IS DEAMAGED, MARK "YES"
Spreadsheet: 839958d1692323061-vlookup-values-from-a-dataset-after-matching-a-date-for-these-values-vlookup-by-selected-date
Sheet: Sheet1

Date | Site | Value |  |  |  | Date | Site | Lookup
2023-08-16 00:00:00 | 1 | 6.16 |  |  |  |  | 1
2023-08-16 00:00:00 | 2 | 5.7 |  |  |  |  | 2
2023-08-16 00:00:00 | 3 | 2.99 |  |  |  |  | 3
2023-08-16 00:00:00 | 4 | 2.99 |  |  |  |  | 4
2023-08-17 00:00:00 | 1 | 6.5
2023-08-17 00:00:00 | 2 | 9.66
2023-08-17 00:00:00 | 3 | 4.54
2023-08-17 00:00:00 | 4 | 5.55
2023-08-18 00:00:00 | 1 | 7.11
2023-08-18 00:00:00 | 2 | 6.22
2023-08-18 00:00:00 | 3 | 5.33
2023-08-18 00:00:00 | 4 | 4.44