tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 814849d1674635699-rank-and-vlookup-book1-52-
Sheet: Data

 |  | TABLE A |  |  |  |  |  |  |  |  |  |  |  |  |  | TABLE B
 |  |  | SCORE |  |  |  |  |  |  |  |  |  |  | STYLE |  | AUDITORI | AUDITORI | KINESTATIK | VISUAL | AUDITORI | VISUAL | AUDITORI | KINESTATIK | KINESTATIK | AUDITORI
 | NO | NAME | VLBM | VLBI | LM | VR | MU | NAT | INTRA | INTER | KINES | EKSIS |  | SCORE |  | VLBM | VLBI | LM | VR | MU | NAT | INTRA | INTER | KINES | EKSIS | RANK | VLOOKUP
 | 1 | STUDENT 1 | 75 | 45 | 55 | 20 | 85 | 45 | 70 | 95 | 65 | 95
 | 2 | STUDENT 2 | 55 | 30 | 25 | 40 | 30 | 25 | 30 | 45 | 0 | 50
 | 3 | STUDENT 3 | 90 | 45 | 50 | 45 | 25 | 35 | 15 | 65 | 15 | 65
 | 4 | STUDENT 4 | 75 | 85 | 90 | 80 | 25 | 35 | 15 | 65 | 15 | 65
 | 5 | STUDENT 5 | 75 | 55 | 60 | 75 | 40 | 40 | 80 | 75 | 55 | 65
 | 6 | STUDENT 6 | 75 | 30 | 40 | 40 | 15 | 25 | 50 | 50 | 10 | 70 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]? |  | [NAME]?
 | 7 | STUDENT 7 | 55 | 25 | 35 | 40 | 45 | 75 | 75 | 85 | 65 | 70
 | 8 | STUDENT 8 | 80 | 75 | 40 | 70 | 45 | 75 | 75 | 85 | 65 | 70
 | 9 | STUDENT 9 | 80 | 70 | 40 | 40 | 40 | 65 | 65 | 90 | 50 | 85
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank and vlookup Hi,  How to choose the highest ranking on table B. The choice of the highest score is from left to right.  Table A is the score obtained by students. While table B is the calculation of the highest ranking score obtained by students.  Then the highest rank needs to match the style
Spreadsheet: 801987d1666539570-manual-entered-text-to-stay-with-corresponding-row-main-sample-workbook
Sheet: MAIN

ID# | PART # | TASK# | [NAME] | IN STOCK | FROM STOCK | STOCK LEFT | RESOURCE | MANUAL COMMENTS | DATE IN
12345 |  |  |  | 134 | 7 |  |  | PARTIAL COMPLETE STILL ONGOING | 2022-04-03 00:00:00
23456 |  |  |  | 23 | 4 |  |  | COMPLETED CAN NOW BE CLOSED | 2022-01-07 00:00:00
34567 |  |  |  | 56 | 3 |  |  | WILL BE FINISH ON TUESDAY | 2022-07-24 00:00:00
45678 |  |  |  | 10 | 9 |  |  | PHONED SUPPLIER SYILL WAITING FOR REPLY | 2022-02-19 00:00:00
56789 |  |  |  | 34 | 2 |  |  | STILL ONGOING | 2022-06-25 00:00:00
SAMPLE FORMULA FOR "ITEMS"     =VLOOKUP($A1,ITEMS!$A$1:$D$6,COLUMN(A1)+1,0)
SAMPLE FORMULA FOR RESOURCES     =VLOOKUP($A1,ITEMS!$A$1:$D$6,COLUMN(A1)+1,0)
Spreadsheet: 1e3ab17e-ce88-4114-bdb4-b457d0976fb5
Sheet: Input Data

[NAME]
Date
Project Name |  |  |  |  |  |  |  | PIN
Estimate Date |  |  |  |  |  |  |  | Submit for Ad Date:
Last Review Date
Project Manager |  |  |  |  |  |  |  | Phone #
Current Cost Est. ($M) |  |  |  |  | Cost Input Comments |  |  | Current Schedule Duration (Mo.) |  |  |  |  | [NAME]
Proj Phase: | Design | RW | Const |  |  |  |  | Proj Phase: | Design | R/W | Const | Other
Cost Impact |  |  |  |  | Likelihood |  |  | Schedule Impact
Proj Phase: | Design | R/W | Const | Other | Probability |  |  | Proj Phase: | Design | R/W | Const | Other
 | 0 | 0 |  |  |  | 0 |  |  | 0 | 0 | 0
 | 10 | 10 |  |  |  | 0.1 |  |  | 7 | 7 | 10
 | 30 | 25 |  |  |  | 0.35 |  |  | 14 | 14 | 30
 | 50 | 50 |  |  |  | 0.65 |  |  | 21 | 21 | 60
 | 90 | 100 |  |  |  | 0.9 |  |  | 30 | 30 | 90
Comments
Documentation instructions so this valuable information will be easily accessible to all team members at every stage of the project:
1. Name this file PIN_Risk_Worksheet.xlsx
2. File in ProjectWise in the project’s Project Management folder.
3. Assign the following ProjectWise attributes to the file:
 | a. PreConstruction (document type filter)     b. Reviews+ (document type)     c. Risk (document subtype)
Please contact the Deputy Preconstruction Engineer ([PHONE]) if you have questions or suggestions regarding this form.  More information and instructions are available at:
http://www.udot.utah.gov/main/f?p=100:pg:0:::1:T,V:3164, |  |  | (or search the internet for "UDOT Risk Management Tools")
Cost impact thresholds based on construction amount
Small projects | 1 |  | 5 |  | 5000
 |  |  | 10 |  | 10000
 |  |  | 20 |  | 20000
 |  |  | 50 |  | 50000
 |  |  | 75 |  | 75000
Medium | 1 |  | 25 |  | 25000
Projects | 5 |  | 50 |  | 50000
 |  |  | 75 |  | 75000
 |  |  | 100 |  | 100000
 |  |  | 150 |  | 150000
Large Projects | 5 |  |  |  | 0
 | LOOKUPS, DO NOT TOUCH!!!!!!
 |  |  |  |  | activity impacted |  | Type | Functional Area
 | Active |  | Threat |  |  |  | Avoid | Construction
 | Inactive |  | Opportunity |  | DESIGN |  | Transfer | Contracting & Procurement
 | Retired |  |  |  | R/W |  | Mitigate | Design / PS&E
 |  |  |  |  | CONST |  | Accept | Environmental & Hydraulics
 |  |  |  |  |  |  |  | Maintenance
 |  |  |  |  |  |  |  | Management / Funding
 |  |  |  |  |  |  |  | Project Management
 |  |  |  |  |  |  |  | Right of Way
 |  |  |  |  |  |  |  | Structures
 |  |  |  |  |  |  |  | Geotech
 |  |  |  |  |  |  |  | Traffic Management
 |  |  |  |  |  |  |  | Utilities and Railroads
 |  |  | Active |  |  |  |  | Threat |  |  |  |  |  |  |  |  | PE
 |  |  | Inactive |  |  |  |  | Opportunity |  |  |  |  |  |  |  |  | R/W
 |  |  | Retired |  |  |  |  |  |  |  |  |  |  |  |  |  | CN
Spreadsheet: 133253d1324308622-matching-data-and-extrapolating-another-cell-example-2
Sheet: Sheet1

Number | Name | Dept | [NAME] |  | Name 2 | [NAME] | [NAME] show
12345678 | [NAME] | 1 | [EMAIL] |  | [NAME] | #N/A | [EMAIL]
12345679 | [NAME] | 2 | [EMAIL] |  | [NAME] | #N/A | [EMAIL]
12345680 | [NAME] | 4 | [EMAIL] |  | Not In List | #N/A
12345681 | Blank Name | 5 | [EMAIL] |  | N/A | #N/A
12345682 | B A Barr | 6 | [EMAIL] |  | N/A | #N/A
12345683 | G U Test | 2 | [EMAIL] |  | [NAME] | #N/A | [EMAIL]
12345684 | G U Tted | 2 | [EMAIL] |  | Please Help | #N/A
12345685 | Testing 123 | 1 | [EMAIL] |  | Ran Out | #N/A
12345686 | Still Testing | 3 | [EMAIL] |  | [NAME] | #N/A
12345687 | 123 456 | 4 | [EMAIL] |  | Blank Name | #N/A | [EMAIL]
12345688 | 456 789 | 6 | [EMAIL] |  | Hi There | #N/A
Spreadsheet: 773455d1647871905-lookup-and-provide-max-latest-value-with-condition-test9v2
Sheet: Sheet1

ID | Most recent 'Last Login Date&Time' | Most Recent 'Last Login Date&Time' is within 6 months of now? | Expected Results Column B | Expected Results Column C
133435833032 |  |  | 2021-03-12 20:35:39
228056127019 |  |  | 2022-03-15 08:35:12 | Yes
228056127019 |  |  | 2022-03-15 08:35:12 | Yes
228056127019 |  |  | 2022-03-15 08:35:12 | Yes
555877949108 |  |  | 2022-02-17 14:16:33 | Yes
568845263108 |  |  | 2015-04-17 09:18:45
611766667046
642188514565
Spreadsheet: 49857d1249297294-allocating-info-ex1
Sheet: Sheet1

 | Worksheet 1 |  |  |  |  |  | Worksheet 2
Name | Skill 1 | Skill 2 | Skill 3 |  |  | Name | Skill 1 | Skill 2 | Skill 3
[NAME] | aa | bb | cc |  |  | [NAME] | aa | bb | cc
Sue | aa | cc |  |  |  | Sue | aa |  | cc
[NAME] | bb | cc |  |  |  | [NAME] |  | bb | cc
[NAME] | aa | cc |  |  |  | [NAME] | aa |  | cc
[NAME] | aa | bb |  |  |  | [NAME] | aa | bb
[NAME] | aa | bb | cc |  |  | [NAME] | aa | bb | cc
Spreadsheet: 149886d1334173325-double-matching-ex-excel
Sheet: 2

 | Match 1 | Match 2 | Add in correct space
 | Customer | Product | Quantity Purchased
 | 123 | 1
 | 123 | 2
 | 124 | 1
 | 124 | 3
 | 124 | 5
 | 125 | 1
 | 126 | 2
 | 126 | 3
Spreadsheet: 725136d1616556152-formulae-for-dates-and-period-calculations-that-can-auto-calculate-with-drop-down-example-13-
Sheet: SUMMARY

S.NO. | TOWER/SHOP/FLAT | PROJECT | PARTY NAME | MONTHLY RENT | TOTAL RENT RECEIVABLE | TOTAL AMOUNT PAID | LAST MONTH |  | TOTAL DUES | START DATE | END DATE | CONTRACT PERIOD | MONTHS PAID | MONTHS UNPAID
1 | Customer 1 | 1 | A
2 | Customer 2 | 2 | B
3 | Customer 3 | 3 | C
4 | Customer 4 | 4 | D
5 | Customer 5 | 5 | E
6 | Customer 6 | 6 | F
 | Customer 1 | 1 | A | 40000 | 960000 | 400000 | 2020-07-15 00:00:00 | 80000 | -560000
 | Customer 2 | 2 | B | 35000 | 1045000 | 455500 | 2021-02-15 00:00:00 | 60000 | -589500
 | Customer 3 | 3 | C | 20000 | 240000 | 140000 | 2021-03-08 00:00:00 | 20000 | -100000
 | Customer 4 | 4 | D | 16500 | 198000 | 49500 | 2021-03-11 00:00:00 | 16500 | -148500
 | Customer 5 | 5 | E | 15000 | 180000 | 105000 | 2021-03-13 00:00:00 | 15000 | -75000
 | Customer 6 | 6 | F | 15000 | 180000 | 90000 | 2021-03-03 00:00:00 | 15000 | -90000
 |  |  |  |  |  |  |  |  | Formulae for Dates and Period calculations that can auto calculate with drop down
 |  |  |  |  |  |  |  |  | Hi,
 |  |  |  |  |  |  |  |  | I am unable to figure out the formulae for auto select start and end date with respect to transactions in the Data sheet at fixed intervals and further drop down in the Summary sheet performs the calculations automatically. I also need to extract the number of months for the specific period/s which gives results in segregating data and identify the number of months paid and unpaid. Thanks!
Spreadsheet: 681717d1591710900-how-to-base-a-formula-on-data-selected-from-a-drop-down-box-and-linking-to-another-sheet-feeds-test-1-
Sheet: P1

 |  | Based on |  | Feed |  |  | Energy
Age | Date | Weight (kg) | Feed | Volume [NAME] (ml) | Volume del (ml) | Volume del (%) | Energy Req (kcal/kg/d) | Energy Px (kcal/kg) | Vitamin A (µg RE) | Vitamin D (µg) | Vitamin E (mg α-TE) | [NAME] (µg) | [NAME] (mg) | [NAME] (mg) | [NAME] (mg) | [NAME] (mg) | Pantothenic Acid | [NAME] (mg) | Folate (µg) | [NAME] (µg) | [NAME] (µg) | Calcium (mg) | Phosphorus (mg) | Magnesium (mg) | Iron (mg) | Zinc (mg) | Copper (mg) | Manganese (mg) | Selenium (µg) | Iodine (µg) | Molybdenum | Chromium
 | 2020-06-09 00:00:00 |  | [NAME] 75% | 200 | 196 |  | 95 | 48 |  | 0.0075 | 0.009750000000000002 | 0.03 | 0.075 | 0.001125 | 0.0012 | 0.003 | 0.002475 | 0.0009 | 0.1125 | 0.001275 | 0.03 | 0.4425 | 0.3825 | 0.0825 | 0.0075 | 0.0075 | 0.000675 | 0.001125 | 0.0225 | 0.075 | 0.05025 | 0.02625000000000001
 |  |  | Pepti Junior 16% | 250 | 198 |  | 95 |  |  | 0.02029850746268657 | 0.01432835820895522 | 0.05253731343283582 | 0.111044776119403 | 0.0008358208955223882 | 0.001671641791044776 | 0.005134328358208955 | 0.006447761194029851 | 0.00417910447761194 | 0.1671641791044776 | 0.00191044776119403 | 0.02029850746268657 | 0.9074626865671641 | 0.5611940298507462 | 0.0608955223880597 | 0.008597014925373134 | 0.008 | 0.0006328358208955223 | 3.582089552238806e-05 | 0.03462686567164179 | 0.1552238805970149 | 0.07044776119402986 | 0.07044776119402986
 |  |  | [NAME] 50% | 326 | 302 |  | 95 |  |  | 0.005 | 0.006500000000000001 | 0.02 | 0.05 | 0.00075 | 0.0008 | 0.002 | 0.00165 | 0.0006 | 0.075 | 0.0008500000000000001 | 0.02 | 0.295 | 0.255 | 0.055 | 0.005 | 0.005 | 0.00045 | 0.00075 | 0.015 | 0.05 | 0.0335 | 0.0175
Spreadsheet: 876746d1723478402-pivot-table-second-column-sum-and-values-not-matching-work-progress-dated-12-aug-2024
Sheet: Sheet1

ASSEMBLY MARK NUMBER | SL.NO | BUILDING REF. | PRIORITY | LEVEL | ASSEMBLY NAME | QTY | GROSS WEIGHT | DELIVERY | ERECTION | REMARKS | Delivery Weight | Erection Weight
 |  |  |  |  |  |  |  |  |  |  |  |  | Row Labels | Sum of QTY | Sum of GROSS WEIGHT | Count of Delivery Weight | Count of Erection Weight
QLGF-C2001 | 1 | A | PRIORITY-1A | GF | COLUMN | 1 | 200.1 |  |  |  |  |  | A
QLGF-C2002 | 2 | A | PRIORITY-1A | GF | COLUMN | 2 | 512.6 |  |  |  |  |  | PRIORITY-1A
QLGF-C2002 | 3 | A | PRIORITY-1B | GF | COLUMN |  |  |  |  | Part assembly |  |  | GF
QLGF-C2003 | 4 | A | PRIORITY-1B | GF | COLUMN | 1 | 205.6 |  |  |  |  |  | COLUMN | 3 | 712.7 | 2 | 2
QLGF-BM2003 | 5 | A | PRIORITY-1B | GF | FLOOR_BEAM | 1 | 181 | 2024-06-15 00:00:00 | 2024-06-24 00:00:00 |  |  |  | PRIORITY-1B
QLGF-BM2004 | 6 | A | PRIORITY-2A | GF | FLOOR_BEAM |  |  | 2024-06-15 00:00:00 | 2024-06-24 00:00:00 | Part assembly |  |  | GF
QLGF-BM2004 | 7 | A | PRIORITY-2A | GF | FLOOR_BEAM |  |  | 2024-06-15 00:00:00 | 2024-06-24 00:00:00 | Part assembly |  |  | COLUMN | 1 | 205.6 | 2 | 2
QLGF-BM2004 | 8 | A | PRIORITY-2A | GF | FLOOR_BEAM | 1 | 205.7 | 2024-06-15 00:00:00 | 2024-06-24 00:00:00 |  |  |  | FLOOR_BEAM | 1 | 181 | 1 | 1
QLGF-HB2005 | 9 | A | PRIORITY-2A | GF | HORIZONTAL BRACING | 1 | 203.6 |  |  |  |  |  | PRIORITY-2A
QLGF-HB2009 | 10 | A | PRIORITY-2A | GF | HORIZONTAL BRACING | 1 | 200.1 |  |  |  |  |  | GF
QL-1-VB2001 | 11 | A | PRIORITY-2B | LEVEL-1 | VERTICAL BRACING | 1 | 906.1 | 2024-06-17 00:00:00 |  |  |  |  | FLOOR_BEAM | 1 | 205.7 | 3 | 3
QL-1-VB2002 | 12 | A | PRIORITY-2B | LEVEL-1 | VERTICAL BRACING | 1 | 1137.6 | 2024-06-17 00:00:00 |  |  |  |  | HORIZONTAL BRACING | 2 | 403.7 | 2 | 2
QL-1-BM2002 | 13 | A | PRIORITY-2C | LEVEL-1 | FLOOR_BEAM |  |  | 2024-06-17 00:00:00 | 2024-06-25 00:00:00 | Part assembly |  |  | PRIORITY-2B
QL-1-BM2002 | 14 | A | PRIORITY-2C | LEVEL-1 | FLOOR_BEAM | 1 | 673.6 | 2024-06-17 00:00:00 | 2024-06-25 00:00:00 |  |  |  | LEVEL-1
QL-1-BM2003 | 15 | A | PRIORITY-2C | LEVEL-1 | FLOOR_BEAM | 1 | 525 | 2024-06-17 00:00:00 | 2024-06-25 00:00:00 |  |  |  | VERTICAL BRACING | 2 | 2043.7 | 2 | 2
QL-1-BM2004 | 16 | A | PRIORITY-2C | LEVEL-1 | FLOOR_BEAM | 1 | 483.6 | 2024-06-17 00:00:00 | 2024-06-25 00:00:00 |  |  |  | PRIORITY-2C
 |  |  |  |  |  |  |  |  |  |  |  |  | LEVEL-1
 |  |  |  |  |  |  |  |  |  |  |  |  | FLOOR_BEAM | 3 | 1682.2 | 4 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 13 | 5434.6 | 16 | 16
Spreadsheet: 64458d1265303251-crosschecking-data-datacomparison
Sheet: Sheet1

Product | Price | Check
Prod1 | 1 | Product Missing
Prod2 | 2 | Good
Prod3 | 4 | Price Different
Prod4 | 4 | Good
Prod5 | 5 | Price Different
Prod6 | 6 | Good
Prod7 | 7 | Good
Prod8.1 | 8 | Product Missing
Prod9 | 9 | Good
Prod10 | 10 | Good
Prod11 | 11 | Good
Prod12 | 12 | Good
Prod13 | 13 | Good
Prod14 | 14 | Good
Prod15 | 15 | Good
Prod16 | 16 | Good
Spreadsheet: 477523d1472341623-find-a-text-average-last-20-if-20-average-all-available-help3
Sheet: Sheet1

Player | yards |  | Average last 20. If less then 20 average all avaible
Palmer | 235
Palmer | 349
Palmer | 213
Palmer | 269
Palmer | 274
Palmer | 310
Palmer | 362
Palmer | 271
Palmer | 317
Palmer | 363
Palmer | 374
Palmer | 275
Palmer | 421
Palmer | 171
Palmer | 352
Palmer | 311
Palmer | 185
Palmer | 307
Lindley | 82
Lindley | 316
Lindley | 216
Stanton | 139
Stanton | 239
Stanton | 294
Stanton | 149
Stanton | 306
Palmer | 326
Palmer | 249
Palmer | 329
Palmer | 253
Palmer | 250
Stanton | 199
Stanton | 254
Stanton | 167
Palmer | 304
Palmer | 407
Palmer | 178
Palmer | 231
Palmer | 269
Palmer | 302
Palmer | 314
Palmer | 419
Palmer | 241
Palmer | 172
Palmer | 258
Palmer | 298
Palmer | 175
Palmer | 248
Palmer | 187
Palmer | 265
Palmer | 327
Hoyer | 225
Lindley | 246
Lindley | 104
Skelton | 133
Lindley | 72
Lindley | 312
Lindley | 70
Skelton | 306
Skelton | 290
Skelton | 262
[NAME] | 173
[NAME] | 289
[NAME] | 324
[NAME] | 222
[NAME] | 140
Skelton | 215
Skelton | 271
Skelton | 297
Skelton | 313
Skelton | 284
[NAME] | 247
Skelton | 114
Skelton | 163
Skelton | 315
Skelton | 222
[NAME] | 153
[NAME] | 272
[NAME] | 254
[NAME] | 237
[NAME] | 252
[NAME] | 251
[NAME] | 309
Bartel | 242
Skelton | 196
Skelton | 146
[NAME] | 148
[NAME] | 196
[NAME] | 295
[NAME] | 322
[NAME] | 196
[NAME] | 305
[NAME] | 132
Hall | 174
Hall | 146
[NAME] | 122
[NAME] | 164
[NAME] | 297
Warner | 266
Warner | 379
Leinart | 139
Warner | 313
Warner | 228
Warner | 178
Warner | 285
Leinart | 220
Warner | 277
Warner | 340
Warner | 261
Warner | 242
Warner | 231
Warner | 292
Warner | 302
Warner | 339
Warner | 265
Warner | 288
Warner | 377
Warner | 279
Warner | 220
Warner | 271
Warner | 346
Leinart | 168
Warner | 298
Warner | 279
Warner | 235
Warner | 351
Warner | 395
Warner | 328
Warner | 343
Warner | 391
Warner | 236
Warner | 250
Warner | 472
Warner | 210
Warner | 376
Warner | 197
Warner | 300
Warner | 369
Warner | 233
Warner | 337
Warner | 169
Warner | 486
Warner | 211
Warner | 261
Warner | 172
Warner | 283
Rattay | 180
Warner | 290
Warner | 225
Warner | 311
Leinart | 299
Leinart | 102
Warner | 356
Leinart | 267
Leinart | 214
Leinart | 232
Leinart | 186
Leinart | 405
Leinart | 233
Leinart | 216
Leinart | 157
Leinart | 203
Leinart | 232
Leinart | 253
Warner | 182
Warner | 256
Warner | 231
Warner | 301
Spreadsheet: 537300d1504936302-combining-2-rows-into-1-final-invoice-1-
Sheet: page 29

Description of Goods |  |  |  |  | Quantity | Cost | Total
Item # | Color | UPC Code | Country Origin | HS Code
Wood Craft: Natural Pen/Pencil Tubs |  |  |  |  | 48 | 1.1 | 52.8
WS300A | A) Round | 775749189315 | CHINA | 4420.90.0020
Wood Craft: Natural Pen/Pencil Tubs |  |  |  |  | 48 | 1.1 | 52.8
WS300B | B) Hexagon | 775749189322 | CHINA | 4420.90.0020
Wood Craft: Natural Pen/Pencil Tubs |  |  |  |  | 48 | 1.1 | 52.8
WS300C | C) Square | 775749189339 | CHINA | 4420.90.0020
[NAME]: 3.9"x3.15"x3.5" Natural Stationary Caddy |  |  |  |  | 24 | 0.88 | 21.12
WS302 | - | 775749214130 | CHINA | 4420.90.0020
Wood Craft: Natural Pen/Pencil Box w/Sliding Cover |  |  |  |  | 24 | 1.08 | 25.92
WS310 | - | 775749189360 | CHINA | 4420.90.0020
Wood Craft: Natural: 2.36"x2.36"x4.72" [NAME] w/Sliding Cover |  |  |  |  | 24 | 0.88 | 21.12
[NAME] | - | 775749214093 | CHINA | 4420.90.0020
Wood Craft: 8.3"x1.3"x1.5" Natural Pen/Pencil Box w/Ruler Cover |  |  |  |  | 24 | 0.92 | 22.08
WS314 | - | 775749214253 | CHINA | 4420.90.0020
Wood Craft: 5.3"x5.3"x2.5" Natural Trinket Caddy |  |  |  |  | 24 | 0.92 | 22.08
WS318A | A) [NAME] | 775749214147 | CHINA | 4420.90.0020
Wood Craft: 5.3"x5.3"x2.5" Natural Trinket Caddy |  |  |  |  | 24 | 0.92 | 22.08
WS318B | B) Wave | 775749214185 | CHINA | 4420.90.0020
Wood Craft: 5.3"x5.3"x2.5" Natural Trinket Caddy |  |  |  |  | 24 | 0.92 | 22.08
WS318C | C) Butterfly | 775749214192 | CHINA | 4420.90.0020
Wood Craft: 5.3"x5.3"x2.5" Natural Trinket Caddy |  |  |  |  | 24 | 0.92 | 22.08
WS318D | D) Square | 775749214208 | CHINA | 4420.90.0020
Wood Craft: 6.31"x4.25"x3.2" Desk Caddy 'Chalk-It-Up' |  |  |  |  | 24 | 1.98 | 47.52
[NAME] | - | 775749195903 | CHINA | 4420.90.0020
Wood Craft: 3.13"x8.88"x3.37" 3-Slot Desk Caddy 'Chalk-It-Up' |  |  |  |  | 24 | 2.28 | 54.72
WS329 | - | 775749206678 | CHINA | 4420.90.0020
Wood Craft: 6" x 1/2" DIY Standing Animals |  |  |  |  | 12 | 0.82 | 9.84
WS346A | A) Giraffe | 775749223057 | CHINA | 4420.10.0000
Wood Craft: 6" x 1/2" DIY Standing Animals |  |  |  |  | 12 | 0.82 | 9.84
WS346B | B) Cow | 775749223064 | CHINA | 4420.10.0000
Wood Craft: 6" x 1/2" DIY Standing Animals |  |  |  |  | 12 | 0.82 | 9.84
WS346C | C) Elephant | 775749223071 | CHINA | 4420.10.0000
Wood Craft: 6" x 1/2" DIY Standing Animals |  |  |  |  | 12 | 0.82 | 9.84
WS346D | D) Stegosaurus | 775749223088 | CHINA | 4420.10.0000
Wood Craft: 6" x 1/2" DIY Standing Animals |  |  |  |  | 12 | 0.82 | 9.84
WS346E | E) Hippo | 775749223095 | CHINA | 4420.10.0000
Wood Craft: 6" x 1/2" DIY Standing Animals |  |  |  |  | 12 | 0.82 | 9.84
WS346F | F) Lion | 775749223101 | CHINA | 4420.10.0000
Wood Craft: 8 1/8"x4 5/8"x2 1/8" Paintable Tray w/Handles |  |  |  |  | 48 | 1.05 | 50.4
WS400 | - | 775749139198 | CHINA | 4419.00.0090
Wood Craft: 6.75"x5.5" Natural Chalkboard Frame w/Jute Hanger |  |  |  |  | 0 | 0.88 | 0
WS500A | A) Rectangle | 775749214215 | CHINA | 9610.00.0000
Spreadsheet: 749148d1632530895-display-list-of-new-or-updated-rows-in-a-list-display-list-of-new-or-updated-rows-in-a-list
Sheet: Main

Title | PartID | Location | Price | Image [image] | Image2 [image2] | Image3 [image3] | Description | Quantity | Category
SamplePart1 | 1 | [NAME] | 0.04 |  |  |  | SampleDes1 | 2033 | 0
SamplePart2 | 2 | LOC2 | 0.01 |  |  |  | SampleDes2 | 1280 | 0
SamplePart3 | 3 | [NAME] | 0.08 |  |  |  | SampleDes3 | 1260 | 0
SamplePart4 | 4 | LOC4 | 0.11 |  |  |  | SampleDes4 | 1021 | 0
SamplePart5 | 5 | LOC5 | 0.08 |  |  |  | SampleDes5 | 1000 | 0
SamplePart6 | 6 | LOC6 | 0.28 |  |  |  | SampleDes6 | 900 | 0
SamplePart7 | 7 | [NAME] | 0.14 |  |  |  | SampleDes7 | 733 | 0
SamplePart8 | 8 | LOC8 | 0.43 |  |  |  | SampleDes8 | 688 | 0
SamplePart9 | 9 | [NAME] | 3.83 |  |  |  | SampleDes9 | 540 | 0
SamplePart10 | 10 | LOC10 | 0.09 |  |  |  | SampleDes10 | 500 | 0
SamplePart11 | 11 | LOC11 | 0.08 |  |  |  | SampleDes11 | 500 | 0
[NAME] | 12 | LOC12 | 0.14 |  |  |  | SampleDes12 | 497 | 0
SamplePart13 | 13 | [NAME] | 3.34 |  |  |  | SampleDes13 | 410 | 0
SamplePart14 | 14 | LOC14 | 0.09 |  |  |  | SampleDes14 | 400 | 0
SamplePart15 | 15 | LOC15 | 0.06 |  |  |  | SampleDes15 | 396 | 0
SamplePart16 | 16 | LOC16 | 5.63 |  |  |  | SampleDes16 | 370 | 0
SamplePart17 | 17 | LOC17 | 1.59 |  |  |  | SampleDes17 | 350 | 0
SamplePart18 | 18 | LOC18 | 2.91 |  |  |  | SampleDes18 | 325 | 0
SamplePart19 | 19 | LOC19 | 0.44 |  |  |  | SampleDes19 | 314 | 0
Spreadsheet: 767049d1644254418-formula-to-duplicate-values-on-similar-cells-attendance-example
Sheet: Sheet1

Student ID | Student Name | Subject | [NAME]
50042971 | Student A |  | 100
50043199 | Student B |  | 80
50043230 | Student C |  | 90
50046832 | Student D |  | 50
50042971 | Student A | Math
50043199 | Student B | Math
50043230 | Student C | Math
50046832 | Student D | Math
50042971 | Student A | Language
50043199 | Student B | Language
50043230 | Student C | Language
50046832 | Student D | Language
50042971 | Student A | Science
50043199 | Student B | Science
50043230 | Student C | Science
50046832 | Student D | Science
Spreadsheet: 118596d1313777329-client-price-listing-us-sj-pl
Sheet: Sheet1

 | list a | list b | list c | [NAME] | client a | client b | client c | client a | client b | client c
product a | 1 | 10 | 21 | 31 | a | b | c | 1 | 10 | 21
product b | 2 | 11 | 22 | 32 | a | b | c | 2 | 11 | 22
product c | 3 | 12 | 23 | 33 | a | b | d | 3 | 12 | 33
product d | 4 | 13 | 24 | 34 | a | b | d | 4 | 13 | 34
Spreadsheet: 728191d1618354774-how-to-automatically-show-value-from-a-table-row-every-time-a-new-entry-is-made-using-index
Sheet: Sales

Date | SalesTeam | Q1 | Q2 | Q3 | Q4
2021-04-01 00:00:00 | A | 100 | 200 | 200 | 400
2021-04-02 00:00:00 | B | 50 | 60 | 60 | 70
2021-04-03 00:00:00 | A | 100 | 100 | 200 | 450
2021-04-04 00:00:00 | B | 250 | 350 | 150 | 100
2021-04-05 00:00:00 | A | 58 | 90 | 100 | 100
2021-04-06 00:00:00 | B | 100 | 200 | 250 | 300
Spreadsheet: 233030d1367594741-new-sheet-creation-based-on-selection-in-a-different-sheet-sales-price-sheet-example
Sheet: Partner Report

Parts Report - Partner pricing - [NAME] 2400 replacement
Customer Name
Contact Name
Quote Reference Number
Quote Created | -
Procurement Type | Purchase with Warranty
MCD on 3300, ISS, [NAME] part of Quote
Part | Description | Qty
MCD - Core Hardware and Software
50003560 | DUAL T1/E1 TRUNK MMC | 1
50004451 | Quad CIM | 2
50005105 | ASU II | 10
50005731 | 24 port ONSp card | 19
50005751 | DSP  II MMC | 1
50006268 | 3300 MXe III Controller SATA SSD | 1
50006271 | PWR CRD C13 10A 125V - NA PLUG | 12
51300183 | 3300 AMB/AOB Connection Unit-America's | 1
52002541 | 3300 User Controller 1400 | 1
 | 1 : [PHONE] - 128 CH. ECHO  CANCELLOR ROHS5
 | 1 : 50005084 MXe AC POWER SUPPLY
 | 1 : [PHONE] MXe III Controller
 | 1 : 50006431 MXe III Raid Sub-System
 | 1 : 50006432 Processor - MXe III Controller
 | 1 : [PHONE] 160G SATA HDD 2 pack(Cntr-Server)
 | 1 : 54004963 MCD Enterprise [NAME]
54002701 | MCD ONS license | 450
MCD - Solution Licenses
54000297 | MCD Mailbox license | 500
54000303 | MCD Digital [NAME] | 2
Consoles
50006490 | 5550 Console (Global) | 2
Desktop Devices - IP Phones and Accessories
50006191 | 5320 IP Phone | 75
51005172 | PWR CRD C7 2.5A 125V-NA PLUG | 2
51016170 | LIVE CONTENT SUITE (5320/30/40/60) | 1
Unified Communications
54005521 | UCC Std User Lic for Enterprise(50 User) | 2
54005813 | AMC UCC License MGR for Enterprise | 1
Sub Total
Solution Pricing
Program Type | Details | Price
From summary sheet |  | from summary sheet
From summary sheet |  | from summary sheet