tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kate_symes__18816__MidC
Sheet: DJ Mid-C Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-03-08 00:00:00 |  | 262.5 | 14400 | 203.46 | 4624
 | 2001-03-07 00:00:00 |  | 332.94 | 26544 | 285.65 | 15720 | 330.51 | 717 | 232.25 | 507
 | 2001-03-06 00:00:00 |  | 342.28 | 17200 | 304.1 | 7232 | 336.81 | 452 | 233.81 | 624
 | 2001-03-05 00:00:00 |  | 322.23 | 12560 | 296.39 | 4712 | 305.57 | 470 | 252.06 | 1447
 | 2001-03-04 00:00:00 |  | 310 | 0 | 270 | 0 | 289.47 | 475 | 246.67 | 375 |  | 296.48 | 15336
 | 2001-03-03 00:00:00 |  | 305.25 | 20560 | 267.01 | 8232 | 250.36 | 685 | 281.25 | 160
 | 2001-03-02 00:00:00 |  | 305.25 | 20560 | 267.01 | 8232 | 377.23 | 90 | 300 | 100
 | 2001-03-01 00:00:00 |  | 298.9 | 27200 | 269.54 | 7872 | 372.61 | 244 | 255 | 160
 | 2001-02-28 00:00:00 |  | 200.96 | 25024 | 183.83 | 13864 | 316.43 | 2298 | 258.89 | 1480
 | 2001-02-27 00:00:00 |  | 201.92 | 15424 | 178.85 | 6464 | 244.23 | 455 | 204.11 | 1255
 | 2001-02-26 00:00:00 |  | 245.45 | 11424 | 227.06 | 6928 | 198.18 | 550 | 160 | 50
 | 2001-02-25 00:00:00 |  | 240 | 800 | 210 | 0 | 173.83 | 962 | 159.04 | 584 |  | 227.06 | 20784
 | 2001-02-24 00:00:00 |  | 194.5 | 20624 | 152.04 | 7328 | 186.82 | 2727 | 184.22 | 870
 | 2001-02-23 00:00:00 |  | 194.65 | 20624 | 152.04 | 7328 | 278.92 | 300 | 186.49 | 208
 | 2001-02-22 00:00:00 |  | 253.75 | 17824 | 217.96 | 5880 | 190.34 | 576 | 143.24 | 795
 | 2001-02-21 00:00:00 |  | 291.88 | 11824 | 261.34 | 6928 | 295 | 50 | 220.57 | 485
 | 2001-02-20 00:00:00 |  | 326.7 | 22224 | 310.97 | 5328 | 275 | 78 | 222.94 | 375
 | 2001-02-19 00:00:00 |  | 326.67 | 22624 | 310.97 | 5328 | 335.35 | 174 | 259.78 | 115
 | 2001-02-18 00:00:00 |  | 325 | 800 | 310 | 0 | 275.26 | 476 | 266.22 | 555 |  | 336.69 | 11784
 | 2001-02-17 00:00:00 |  | 349.98 | 15824 | 336.58 | 3800 | 347.69 | 281 | 332.5 | 0
 | 2001-02-16 00:00:00 |  | 460.66 | 15248 | 410.94 | 5160 | 397.28 | 230 | 350 | 40
 | 2001-02-15 00:00:00 |  | 460.66 | 15248 | 410.94 | 5160 | 348.8 | 1693 | 398.23 | 784
 | 2001-02-14 00:00:00 |  | 327.05 | 15664 | 314.82 | 3928 | 479.05 | 452 | 472.12 | 165
 | 2001-02-13 00:00:00 |  | 335.68 | 13424 | 322.6 | 4728 | 386.38 | 1053 | 330 | 0
 | 2001-02-12 00:00:00 |  | 302.64 | 12624 | 279.2 | 4528 | 271.84 | 1346 | 324.32 | 544
 | 2001-02-11 00:00:00 |  | 285 | 0 | 270 | 0 | 312.37 | 316 | 326.04 | 96 |  | 278.81 | 12600
 | 2001-02-10 00:00:00 |  | 276.16 | 15824 | 238.78 | 3328 | 322.06 | 790 | 309.3 | 328
 | 2001-02-09 00:00:00 |  | 276.16 | 15824 | 238.78 | 3328 | 341.87 | 3340 | 307.19 | 1050
 | 2001-02-08 00:00:00 |  | 381.43 | 15120 | 316.79 | 3376 | 341.12 | 2521 | 320.97 | 373
 | 2001-02-07 00:00:00 |  | 274.49 | 8688 | 253.14 | 4024 | 294.97 | 2143 | 251.02 | 216
 | 2001-02-06 00:00:00 |  | 213.71 | 10784 | 195.79 | 4096 | 259.92 | 63 | 196.16 | 307
 |  |  |  |  |  | ..
Spreadsheet: 268665d1380729341-need-an-if-function-that-sums-the-results-from-another-column-excel-forum-fte-capacity-report
Sheet: Coordinators - Active

Docket number | Line of business | Project | % of time being spent
[NAME]
Project Work: | Insurance | Project A | 0.4
 | Insurance | Project B | 0.2
 | SFC | Project C | 0.15
 | SFC | Project D | 0.06
 | Insurance | Project E | 0.05
 | Exec | Project F | 0.03
 | Life | Project G | 0.02
 | Exec | Project H | 0.15
TOTAL:
Trevor
Project Work: | Exec | Project A | 0.05
 | B2R | Project B | 0.02
 | Exec | Project C | 0
 | Insurance | Project D | 0.05
 | Insurance | Project E | 0.03
 | Insurance | Project F | 0.03
 | Life | Project A | 0.1
 | SFC | Project B | 0.08
 | Life | Project C | 0.1
 | National | Project D | 0
 | Insurance | Project E | 0.05
 | National | Project F | 0.07
 | Insurance | Project G | 0
 | Insurance | Project H | 0
 | Insurance | Project I
TOTAL:
Cathy
Project Work: | Insurance | Project D | 0.1
 | Insurance | Project E | 0.05
 | Life | Project F | 0.07
 | SFC | Project A | 0.03
 | Life | Project B | 0.1
 | National | Project C | 0.3
 | Insurance | Project D | 0.05
 | National | Project E | 0.1
 | Life | Project I | 0.18
TOTAL:
Spreadsheet: 235527d1368530579-conditional-formatting-using-a-formula-copy-of-example-resourcing-spreadsheet
Sheet: Sheet1

 |  |  |  | Days in month | 22 | 22 | 24 | 22 | 22 | 22 | 21 | 23 | 22 | 22 | 21 | 19
Department | Initiative Name | Resources | Program | Project | J | F | M | A | M | J | J | A | S | O | N | D | Comment
 |  |  |  |  | Q1 |  |  | Q2 |  |  | Q3 |  |  | Q4
Trans |  | [NAME] | 1-Mars | Mars CVS |  | 1 | 1.5 | 0.5 | 1
Trans |  | [NAME] | 1-Mars | Mars CVS | 5 | 1 | 1 | 1 | 0.5
Trans |  | [NAME] | 1-Mars | Mars Server |  | 2 | 2 | 3 | 1
Trans |  | [NAME] | 1-Mars | Mars Server | 2 | 0.5 | 1 | 1 | 0
Trans |  | [NAME] | 1-Mars | Mars Client | 5 | 0.5 | 1 | 2 | 4 | 2 | 2 | 1 | 1 | 0.5
Trans |  | [NAME] | 1-Mars | Mars Client |  |  |  | 1 | 1 | 1 | 1 | 1
Trans |  | [NAME] | 1-Mars | Mars Client | 1 | 1 | 1 | 1 | 2 | 2 | 1 | 1 | 0.5
Trans |  | [NAME] | 1-Mars | Mars Client | 10 | 1 | 1 | 1 | 1 | 2 | 3 | 1 | 1
Trans |  | Frances Tracey | 3-None | Pluto |  | 1 | 1 | 1
Trans |  | [NAME] | 3-None | Pluto |  | 0.5 | 0.5 | 0.5
Trans |  | [NAME] | 3-None | Pluto | 5 |  | 2
Trans |  | [NAME] | 3-None | Pluto |  | 1 | 1 | 1 | 3 | 4 | 3 | 2 | 2 | 1 | 5 | 3
Trans |  | [NAME] | 3-None | Pluto | 3 | 1 | 3 | 3 | 3 | 2 | 1 | 0.5 | 1 | 1 | 1 | 1
Trans |  | [NAME] | 3-None | Pluto | 2 |  |  | 1 | 2 | 3 | 2 | 2 | 1 | 1
BI |  | [NAME] | 3-None | Pluto
BI |  | [NAME] | 3-None | Mercury | 4 | 0.5 | 1
BI |  | [NAME] | 3-None | Mercury | 3 | 3 | 3
BI |  | [NAME] | 3-None | Saturn |  |  | 1 | 1 | 0.5 | 0.5 | 1 | 1 | 1 | 0.5 | 0 | 0
BI |  | [NAME] | 3-None | Saturn | 2 |  | 0.25 | 1 |  |  | 1 |  |  | 1
BI |  | [NAME] | 3-None | Saturn | 2 |  |  |  | 1 | 1 | 1 | 1
BI |  | [NAME] | 2-Sustain | Luna |  |  | 1.5 | 1.5 | 1 | 1 | 1 | 1
BI |  | [NAME] | 2-Sustain | Luna | 22 |  |  |  | 1 | 1 | 1 | 1 | 1
BI |  | [NAME] | 2-Sustain | Europa | 3 |  |  |  |  | 2 | 2 | 3 | 1
BI |  | [NAME] | 1-Mars | Mars CVS
BI |  | [NAME] | 2-Sustain | Perelandra | 3 |  |  | 2
BI |  | [NAME] | 1-Mars | Mars CVS |  |  | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 0.5
BI |  | [NAME] | 3-None | Jupiter | 0.5 | 0.5 | 0.5
BI |  | [NAME] | 3-None | Jupiter
Experts |  | [NAME] | 2-Sustain | Ganymede
Experts |  | [NAME] | 2-Sustain | Ganymede | 1 | 2 | 2 | 1 | 0
Experts |  | [NAME] | 2-Sustain | Ganymede |  |  | 1
Experts |  | [NAME] | 3-None | Neptune | 0.5 |  |  | 0.5 |  |  | 0.5 |  |  | 0.5
Experts |  | [NAME] | 3-None | Neptune | 1 |  |  | 1 |  |  | 1 |  |  | 1
Experts |  | [NAME] | 1-Mars | Mars CVS |  | 1
Experts |  | [NAME] | 1-Mars | Mars CVS |  | 1
Experts |  | [NAME] | 1-Mars | Mars CVS |  | 1
Experts |  | [NAME] | 3-None | Pluto |  | 22 | 2
Trans |  | [NAME] | 3-None | Pluto |  | 1 | 1.5
 |  |  |  |  | J | F | M | A | M | J | J | A | S | O | N | D | INSERT NEW ROWS ABOVE THIS LINE ONLY
Spreadsheet: 03b30517-c61e-4cf9-8680-c8b204fdd5a4
Sheet: Sheet1

BS/MS - CE | Unnamed: 1 | Name | Unnamed: 3 | Unnamed: 4 | [NAME] | Unnamed: 6 | Unnamed: 7 | BS Crdts | MS Crdts | Total
FRESHMAN -Fall | MATH 121 | UNIV 101 | ENGR 121 | ENGR 101 | CHEM 101 | ENGL 101
2010 | Calc I |  | Comp Lab I | [NAME] | Chem/Bio
Credits | 4 | 2 | 2 | 2 | 3.5 | 3 |  | 16.5 |  | 16.5
FRESHMAN-Winter | MATH 122 | PHYS 101 | ENGR 122 | ENGR 102 | CHEM 102 | ENGL 102
2011 | [NAME] | Physics I | Comp Lab II | Freshman Des II | Chem II
Credits | 4 | 4 | 1 | 2 | 4.5 | 3 |  | 18.5 |  | 18.5
FRESHMAN-Spring | MATH 200 | PHYS 102 |  | ENGR 103 | BIO 141 | ENGL 103
2011 | [NAME] | Physics II |  | [NAME] | [NAME]
Credits | 4 | 4 |  | 2 | 4.5 | 3 |  | 17.5 |  | 17.5
SOPHOMORE-Fall | [NAME] 231 | PHYS 201 | ENGR 201 | ECE 200 | [NAME] 220
2011 | [NAME] | Physics III | [NAME] | Logic | Materials
Credits | 3 | 4 | 3 | 3 | 4 |  |  | 17 |  | 17
SOPHOMORE-Winter | [NAME] 232 | MATH 221 | ENGR 202 | ECE 201 | ECE 203 | [NAME]
2012 | [NAME] | Discrete Math | [NAME] | Circuits | Prog Eng
Credits | 3 | 3 | 3 | 3 | 3 | 3 |  | 18 |  | 18
CO-OP Spring | SOPHOMORE CO-OP
2012
CO-OP Summer
2012
PRE-JUNIOR-Fall | ECEC 301 | ECES 301 | ECEC 302 | [NAME] | ECEL 301 | ECE 361
2012 | Adv Prog Eng | Trans Meth | [NAME] |  | ECE Lab I | Probability
Credits | 3 | 4 | 4 | 3 | 2 | 3 |  | 19 |  | 19
PRE-JUNIOR-Winter | ECEC 304 | ECEC 355 | FREE ELECT | PHIL 315 | ECEL 302
2013 | DesIgn Micro | [NAME] |  | Eng Ethics | ECE Lab II
Credits | 4 | 4 | 3 | 3 | 2 |  |  | 16 |  | 16
CO-OP Spring | PRE-JUNOR CO-OP
2013
CO-OP Summer
2013
JUNIOR-Fall |  | ECEC 357 | ECEC 356 | CS 265 | ECEL 303 | ECEX 5XX+ | ECEC 631
2013 |  | Intro Com Net | Embed Sys | Adv Prog | ECE Lab III | 6 CR ECE NON-CE | 18 CR CE
Credits |  | 4 | 4 | 3 | 2 | 3 | 3 | 13 | 6 | 19
JUNIOR-Winter | ECE 391 | ECEC 353 | ECE 391 | CS 260 | ECEL 304 | ECEX 5XX+ | ECEX 5XX+
2014 |  | Sys Program | Intro to Design | Data Struct | ECE LAB IV | 6 CR ECE NON-CE | 18 CR CE
Credits | 1 | 4 | 1 | 3 | 2 | 3 | 3 | 11 | 6 | 17
JUNIOR-Spring | Free Elective | [NAME] |  | [NAME] | GRAD COURSE | GRAD COURSE | ECEC 5XX+
2014 |  |  |  |  | ELECTIVE | ELECTIVE | 18 CR CE
Credits | 3 | 3 |  | 3 | 3 | 3 | 3 | 9 | 9 | 18
JUNIOR-Summer
2014
Credits |  |  |  |  |  |  |  | 0 | 0 | 0
SENIOR-Fall | ECE 491 | CE ELECTIVE | Free Elective |  | GRAD COURSE | ECEX 5XX+ | ECEC 621
2014 | SR DESIGN I | ECEC 4XX |  |  | ELECTIVE | 6 CR ECE | 18 CR CE
Credits | 2 | 3 | 3 |  | 3 | 3 | 3 | 8 | 9 | 17
SENIOR-Winter | ECE 492 | CE ELECTIVE | [NAME] |  | GRAD COURSE | ECEX 5XX+ | ECEC 5XX+
2015 | SR DESIGN II | ECEC 4XX |  |  | ELECTIVE | 6 CR ECE | 18 CR CE
Credits | 2 | 3 | 3 |  | 3 | 3 | 3 | 8 | 9 | 17
SENIOR-Spring | ECE 493 | CE ELECTIVE | Free Elective |  | GRAD COURSE |  | ECEC 5XX+
2015 | SR DESIGN III | ECEC 4XX |  |  | ELECTIVE |  | 18 CR CE
Credits | 4 | 3 | 3 |  | 3 |  | 3 | 10 | 6 | 16
Undergraduate Advisor Signature__________________________ |  |  |  |  | Graduate Advisor Signature__________________________ |  |  | 181.5 | 45 | 226.5
Spreadsheet: 132330d1323703424-how-to-access-information-from-a-table-copy-of-updated-pipe-pricing-1
Sheet: Pipe Pricing

Description | Mat. Price
L Hard
1/2" | 1
3/4" | 2
1" | 3
1 1/4" | 4
1 1/2" | 5
2" | 6
2 1/2" | 7
3" | 8
4" | 9
[NAME]
1/2" | 1.5
3/4" | 2.5
1" | 3.5
1 1/4" | 4.5
1 1/2" | 5.5
2" | 6.5
M Hard
1/2" | 2
3/4" | 3
1" | 4
1 1/4" | 5
1 1/2" | 6
2" | 7
2 1/2" | 8
3" | 9
4" | 10
Spreadsheet: 59175d1259654899-summing-across-multiple-sheets-summary-report
Sheet: Sep-09

 | Trip details
Name | From | To | Number Of Days | Destination | Total ammount | reason of trip
[NAME] | 2009-09-13 00:00:00 | 2009-09-17 00:00:00 | 5 | Amman | 0
Tarek Tubeileh | 2009-09-08 00:00:00 | 2009-09-10 00:00:00 | 3 | Dubai | 178.921
Tarek Tubeileh | 2009-09-24 00:00:00 | 2009-09-25 00:00:00 | 2 | Lebanon | 45.708
 | Total Days |  | 10 |  | 224.629
 |  | Saving |  | #N/A
Spreadsheet: 213593d1360588437-premium-calculations-premium-calculations
Sheet: Calculations

GHI
 |  |  | Addition Details: |  |  |  |  |  |  |  | 2013-12-23 00:00:00
Sl | EMP.NUM | EMPLOYEE NAME | [NAME] | Relationship | Date of birth ( dd/ mm/yyyy) | Completed Age | Gender | Category | DOJ | [NAME] | Prorata days | Prorata pre
1 | 1111 | Sagar | [NAME] | Father | 1953-06-26 00:00:00 | 60 | M | 1 | 2013-01-24 00:00:00 | 200000 | 333 | 7187.32602739726
 |  |  |  |  | 60 | need formulae to calculate the age
 |  |  |  |  | 1 | Calumn "B" premium
 |  |  |  |  | 2 | Calumn "C" premium
 |  |  |  |  | 3 | Calumn "D" premium
 |  |  |  |  | 7187 | if "I4" cell is "1", formulae has to check the "G4" (Age) and pick the value(premium) from Database sheet according to the age bracket and calculate the Prorata Premium
Spreadsheet: 686606d1594713272-condtional-formatting-from-last-non-blank-cell-client-hub_engagement-overview_eh
Sheet: Argyll Holidays

ID | TASKS | RESPONSIBILITY | COMMENTS/DESCRIPTION | START DATE | DEADLINE | PRIORITY |  | STATUS |  | Next meeting & actions | 1 WEEK FROM START DATE | 2 WEEKS FROM START DATE | 3 WEEKS FROM START DATE | 4 WEEKS FROM START DATE | 5 WEEKS FROM START DATE | 6 WEEKS FROM START DATE | 7 WEEKS FROM START DATE | 8 WEEKS FROM START DATE | 9 WEEKS FROM START DATE | 10 WEEKS FROM START DATE
ID | Argyll Holidays |  |  |  |  |  |  |  |  | TBC
1 | Task 1 | Ray |  | 2020-05-01 00:00:00 |  | High |  | On hold |  | Not required
2 | Task 2 | Ray |  | 2020-05-02 00:00:00 |  | Medium |  | On hold |  | Not required
3 | Task 3 | Client |  | 2020-05-03 00:00:00 |  | Low |  | In progress |  | Not required
4 | Branding | Ray |  | 2020-05-04 00:00:00 |  | Low |  | In progress |  | Not required
5 | Adhoc: Any product/purchaser feed issues? | Ray | Any product/purchaser feed issues? | 2020-04-30 00:00:00 |  | High |  | In progress |  | Not required
6 | Adhoc: Social media scan | Ray | [NAME]: @ArgyllHolidays https://www.instagram.com/argyllholidays/ https://www.linkedin.com/company/argyll-holidays/ | 2020-05-04 00:00:00 |  | Low |  | In progress |  | Not required
Spreadsheet: jay_reitmeyer__13543__dailyrox2fcst
Sheet: Monthly

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45792 | 33938
 |  | Supply |  |  | Demand |  |  |  |  |  |  |  |  | Storage |  |  |  |  |  | EIA Demand |  |  |  | Denver | Denver | [NAME] | [NAME]
 | Date | Rockies Receipts | SJ Receipts | Total Supply | Colorado Demand | Utah Demand | Kemmerer | San Juan Triangle | TW Triangle | East Outlet | Kern River | [NAME] | Total Demand | Clay Basin | Denver Storage | Total Storage | Clay Basin Balance | Denver Storage Balance | [NAME] | CO EIA | CO Diff | Utah EIA | Utah Diff | Mo. Temp | Dept. from Norm | Mo. Temp | Dept. from Norm
31 | 2000-10-01 00:00:00 | 3843 | 3180 |  | 820.3870967741935 | 353 | 471 | 2727 | 834 | 1058 | 796 | -26 |  |  | 34 |  | 44416 |  |  | 600 |  | 325 |  | 50.5 | 0.03 | 52.3 | -0.9
 | 2000-11-01 00:00:00 | 3840 | 3029 |  | 1448.6 | 627 | 225 | 2562 | 808 | 852 | 805 | 20 |  |  | -148 |  | 34498 |  |  | 900 |  | 575 |  | 28.9 | -8.7 | 31.4 | -9.4
 | 2000-12-01 00:00:00 | 3885 | 3173 |  | 1492.967741935484 | 657 | 116 | 2612 | 872 | 928 | 843 | 28 |  |  | -121 |  | 23029 |  |  | 1420 |  | 610 |  | 28.3 | -1.3 | 30.7 | 1
 | 2001-01-01 00:00:00 | 4042 | 3150 |  | 1207 | 698 | 428 | 2658 | 843 | 1001 | 849 | 60 |  |  | -130 |  | 9947 |  |  | 1575 |  | 650 |  | 30 | 1.8 | 27.3 | -0.6
 | 2001-02-01 00:00:00 | 3894 | 3065 |  | 1115 | 601 | 465 | 2602 | 812 | 836 | 846 | 7 |  |  | -176 |  | 5775 |  |  | 1375 |  | 600 |  | 28.3 | -4 | 34.4 | 0.3
 | 2001-03-01 00:00:00 | 4128 | 2905 |  | 1066.516129032258 | 433 | 467 | 2525 | 701 | 1030 | 790 | -8 |  |  | -68 |  | 8766 |  |  |  |  |  |  | 39.8 | 1.8 | 45.4 | 3.6
 | 2001-04-01 00:00:00 | 4009 | 3062 |  | 764.6666666666666 | 395 | 477 | 2564 | 846 | 1156 | 790 | -68 |  |  | -24 |  | 13876 |  |  |  |  |  |  | 49.6 | 2.8 | 50.1 | 0.4
 | 2001-05-01 00:00:00 | 4044 | 3051 |  | 586 | 280 | 489 | 2670 | 819 | 1144 | 767 | 47 |  |  | 47 |  | 21506 |  |  |  |  |  |  | 57.1 | 1.2 | 63.6 | 4.8
 | 2001-06-01 00:00:00 | 4002 | 2902 |  | 458.1333333333333 | 239 | 468 | 2492 | 856 | 1146 | 783 | 107 |  |  | 134 |  | 28132 |  |  |  |  |  |  | 69.4 | 3.8 | 70.9 | 1.8
 | 2001-07-01 00:00:00 | 4003 | 2947 |  | 347 | 227 | 397 | 2594 | 837 | 1140 | 899 | 97 |  | 249 | 163 |  | 35606 | 25377 |  |  |  |  |  | 76.7 | 4.6 | 80.8 | 2.9
 | 2001-08-01 00:00:00
 | 1900-01-03 00:00:00
 |  |  | This Fcst |  |  |  |  |  |  |  |  |  | Plant Name | Region | Online | Capacity
 |  | 2001 | 4.27 BCF/d |  |  |  |  |  |  |  |  |  | [NAME] | Rox | 2001-06-01 00:00:00 | 235
 |  | 2002 | 4.7 BCF/d |  |  |  |  |  |  |  |  |  | Midway | Rox | 2001-06-01 00:00:00 | 148
 |  |  |  |  |  |  |  |  |  |  |  |  | Brush | Rox | 2002-05-01 00:00:00 | 55
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] (Phase 2) | Rox | 2003-05-01 00:00:00 | 460
Spreadsheet: 768614d1645045259-counting-cells-based-on-part_work_order-and-route_step_num-excel-question
Sheet: Sheet1

Part_Work_Order | Route_Step_Num | Cell |  | Cell: | Count:
1RRR | 3 | Saw1 |  | Saw1 | 2
1RRR | 5 | Inspection |  | Inspection | 1
1RRR | 1 | Saw1 |  | Saw2 | 1
[NAME] | 2 | Saw1 |  | Ground | 1
[NAME] | 4 | Inspection |  | Ship | 1
[NAME] | 5 | Saw1
[NAME] | 6 | Saw1 |  | Only counts as 1 because in sequence.
[NAME] | 8 | Saw1
[NAME] | 11 | Saw2
[NAME] | 12 | Saw2
[NAME] | 13 | Ground
[NAME] | 15 | Ground
[NAME] | 16 | Ship
3FFF | 2 | Ship
3FFF | 3 | Saw1
3FFF | 1 | Ship
3FFF | 5 | Saw1
3FFF | 8 | Inspection
3FFF | 9 | Ship
4GGG | 3 | Saw1
4GGG | 4 | Saw1
4GGG | 5 | Saw1
4GGG | 6 | Saw1
4GGG | 8 | Inspection
4GGG | 10 | Inspection
4GGG | 11 | Inspection
4GGG | 12 | Inspection
4GGG | 13 | Saw1
4GGG | 14 | Saw1
4GGG | 15 | Saw1
4GGG | 16 | Saw2
4GGG | 17 | Saw2
4GGG | 18 | Saw2
4GGG | 19 | Saw2
4GGG | 21 | Ground
4GGG | 22 | Ground
4GGG | 23 | Ship
Spreadsheet: 852181d1702287090-any-idea-for-data-arrangement-dataarrange-1-
Sheet: input

Name | BIT_Count | Address | MAX_BIT | MIN_BIT
XYZ | 10 | 0x00 | 7 | 6
PQ | 6 | 0x00 | 5 | 4
ABC | 4 | 0x00 | 3 | 0
XYZ | 10 | 0x01 | 7 | 0
PQ | 6 | 0x02 | 7 | 4
 |  |  |  |  |  |  |  | 10 | 0x00 | 7 | 6 | 0x01 | 7 | 0
 |  |  |  |  |  |  | PQ | 6 | 0x00 | 5 | 4 | 0x02 | 7 | 4
 |  |  |  |  |  |  | ABC | 4 | 0x00 | 3 | 0
Spreadsheet: 168734d1342552700-copy-across-multiple-rows-and-columns-the-data-to-one-column-removing-dupilicates-blank-15640
Sheet: Feb24-Mar2m

Main Arena
 | 2013-02-24 00:00:00 |  |  | Thru | 2013-03-02 00:00:00
 | SUN | MON | TUE | WED | THURS | FRI | SAT
 | 2013-02-24 00:00:00 | 2013-02-25 00:00:00 | 2013-02-26 00:00:00 | 2013-02-27 00:00:00 | 2013-02-28 00:00:00 | 2013-03-01 00:00:00 | 2013-03-02 00:00:00 |  |  |  | Blocks | Team | Hours
7:00AM |  |  |  |  |  |  |  | 7:00AM |  |  | 0 | 05 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 04 Flags | 0
[NAME] |  |  |  |  |  |  |  | [NAME] |  |  | 0 | 03 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 02 Flags | 0
[NAME] |  |  |  |  |  |  |  | [NAME] |  |  | 0 | 01 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 00 Flags | 0
10:00AM |  |  |  |  |  |  |  | 10:00AM |  |  | 0 | 99 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 98 Flags | 0
11:00AM |  |  |  |  |  |  |  | 11:00AM |  |  | 0 | Midget A | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | Midget AA | 0
12:00PM |  |  |  |  |  |  |  | 12:00PM
1:00PM |  |  |  |  |  |  |  | 1:00PM
2:00PM |  |  |  |  |  |  |  | 2:00PM
3:00PM |  |  |  |  |  |  |  | 3:00PM
4:00PM |  |  |  |  |  |  |  | 4:00PM
5:00PM |  |  |  |  |  |  |  | 5:00PM
6:00PM |  |  |  |  |  |  |  | 6:00PM
7:00PM |  |  |  |  |  |  |  | 7:00PM
8:00PM |  |  |  |  |  |  |  | 8:00PM
9:00PM |  |  |  |  |  |  |  | 9:00PM
10:00PM |  |  |  |  |  |  |  | 10:00PM
11:00PM |  |  |  |  |  |  |  | 11:00PM
 | Cancellations or Corrections
 | Date | Time | Customer | Operations Personal | Comments
Spreadsheet: 836239d1689195307-need-a-functio-to-do-matching-process-and-return-the-corresponding-reason-book5
Sheet: Sheet1

 |  |  |  | List A |  | List B |  | List C
 |  |  |  | Name | Reason | Name |  | Name | Reason
 |  |  |  | Name 1 | A1 | Name 3 |  | Name 5
 |  |  |  | Name 2 | A3 | Name 2 |  | Name 3 | A3
 |  |  |  | Name 3 | A3 | Name 6 |  | Name 6 | A2
 |  |  |  | Name 4 | A4 | Name 12 |  | Name 20
 |  |  |  | Name 5 | A5 | Name 25 |  | Name 25 | A1
 |  |  |  | Name 6 | A2 |  |  | Name 30
 |  |  |  | Name 7 | A2
 |  |  |  | Name 8 | A6
 |  |  |  | Name 9 | A6
 |  |  |  | Name 10 | A8
 |  |  |  | Name 25 | A1
 |  |  |  | I have three lists; List A (name and [NAME]), List B (Name) and [NAME] (Name). I need a function to match each name in List C with names of the list A and B and return the corresponding rason in List A if it is matched and blank if it is not matched.
Spreadsheet: 754099d1635942302-threshold-formulas-i-need-a-formula-to-use-across-4-thresholds-excel-help
Sheet: Sheet1

 | Levels | 3 | 4 | 6 | 8 |  |  |  |  |  |  |  | Fee | Levels
Example 1 | 1 | 1 | 0 | 0 | 0 |  |  |  |  |  |  |  | $0 - $100m | 3
Example 2 | 120000000 | 100000000 | 20000000 | 0 | 0 |  |  |  |  |  |  |  | 100m+ to 1bn | 4
Example 3 | 1000000000 | 100000000 | 900000000 | 0 | 0 |  |  |  |  |  |  |  | 1bn+ to 10bn | 6
Example 4 | 1120000000 | 100000000 | 900000000 |  | 0 |  |  |  |  |  |  |  | 10bn + | 8
Example 5 | 10000000000 | 100000000 | 900000000 | 9000000000 | 0
Example 6 | 15000000000 | 100000000 | 900000000 | 9000000000
Spreadsheet: 173e5fe5-b532-4c5f-a25e-fb5873a13899
Sheet: F.02.002

DIKLAT ONLINE PPPPTK IPA BANDUNG
[NAME] | : F.02.002
[NAME] | : “Aplikasi Konsep  [NAME] (EKG)  [NAME] Pendengaran
Pengampu :
1
2
No. | Nama | NIP | Unit [NAME] | [NAME] | Alamat Instansi | [NAME] | [NAME] | Provinsi | teLP
1 | SUGENG PAMUDJI | 196309061997031001 | SMP NEGERI 4 WARU | GURU | JL. GAJAH MADA-DUKUH NGINGAS-WARU | [EMAIL] | SIDOARJO | [NAME] | 031-79440269/ [PHONE]
2
Spreadsheet: 133291d1324318487-need-help-with-data-referencing-temp
Sheet: Sheet1

Shop Production Control System
Work Order Number | Customer | Unit Number | Date/Time in | Date/Time out | Sarted | total time | Finished | Tech | Issue/Complaint | Status | P.O.O
123456 | [NAME] doe | 123 |  |  |  |  |  | 123 | not starting | done
Spreadsheet: 703802d1605182542-counting-multiple-criteria-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | exs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | gds |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 90
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 110
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 90 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 130
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | exs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 150
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 110 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 170
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 120 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | gds |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 190
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 130 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 210
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 140 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 230
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 150 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 250