tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 188766d1350988605-find-the-last-price-of-a-product-sold-last-price-sheets
Sheet: Sheet3

Item title | Sale price
ultrasonic distance sensor module for arduino flat postage £1.20 UK | 2.79
Breadboard Power supply 5v 3.3v 700mA MB102 arduino [NAME] flat postage | 3.49
Breadboard Power supply 5v 3.3v 700mA MB102 arduino [NAME] flat postage | 3.49
Breadboard Power supply 5v 3.3v 700mA MB102 arduino [NAME] flat postage | 3.49
Breadboard Power supply 5v 3.3v 700mA MB102 arduino [NAME] flat postage | 3.49
[NAME] shield RF mesh zigbee arduino flat postage | 9.15
Breadboard Power supply 5v 3.3v 700mA MB102 arduino [NAME] flat postage | 3.49
Breadboard Power supply 5v 3.3v 700mA MB102 arduino [NAME] flat postage | 3.49
Dual 2A H-Bridge motor driver [NAME] module arduino [NAME] postage | 6.99
Sensor shield V4  for Arduino uno duemilanove leonardo flat postage | 6.49
[NAME] points dual power rail  MB102 arduino [NAME] flat postage | 3.88
Dual 2A H-Bridge motor driver [NAME] module arduino [NAME] postage | 6.99
SD Card module for arduino [NAME] flat postage £1.20 first class UK | 3.4
[NAME] points dual power rail  MB102 arduino [NAME] flat postage | 3.88
4 phase stepper motor driver 5v ULN2003 arduino flat postage | 4.85
Dual 2A H-Bridge motor driver [NAME] module arduino [NAME] postage | 6.99
[NAME] points dual power rail  MB102 arduino [NAME] flat postage | 3.88
Dual 2A H-Bridge motor driver [NAME] module arduino [NAME] postage | 6.99
[NAME] points dual power rail  MB102 arduino [NAME] flat postage | 3.88
[NAME] points dual power rail  MB102 arduino [NAME] flat postage | 3.88
Dual 2A H-Bridge motor driver [NAME] module arduino [NAME] postage | 6.99
[NAME] points dual power rail  MB102 arduino [NAME] flat postage | 3.88
SD card reader module for arduino [NAME] flat postage | 3.35
Motor driver Dual 2A H-Bridge L298N module arduino [NAME] postage | 6.88
relay module 2 channel 5v to 240v/120v 10a arduino flat postage | 3.89
SD card reader module for arduino [NAME] flat postage | 3.35
ultrasonic distance sensor module for arduino flat postage UK | 2.69
Breadboard Power supply 5v 3.3v 700mA MB102 arduino [NAME] flat postage | 3.59
Spreadsheet: 844501d1696274115-concatenate-multiple-text-cell-with-empty-cells-book1
Sheet: Sheet1

Title | [NAME] | [NAME]
22 Jump Street | Comedy | Comedy Crime Action
 | Crime
 | Action
28 Days Later | Horror | Horror Thriller Science Fiction Drama
 | Thriller
 | Science Fiction
 | Drama
28 Weeks Later | Horror | Horror Thriller Science Fiction Action Adventure
 | Thriller
 | Science Fiction
 | Action
 | Adventure
The 33 | History
 | Drama
 | Biography
The 36th Chamber of Shaolin | Action
 | Adventure
 | Drama
The 40-Year-Old Virgin | Comedy
 | Romance
42 | Drama
 | Biography
 | Sport
Spreadsheet: 826696d1682172440-i-can-not-paste-text-with-the-formula-cue-file-generator-example-aligw
Sheet: Main

Track No’s | Replace Your Time Here | Replace Your Track Names Here | Copy The Formula Below | Copy The MS Word Data Here | TRACK XX AUDIO | INDEX XX MS Word Data | TRACK & INDEX
01 | 00:00:00 | 3 Sarabandes (1887): No. 1 |  | 00:00:00
02 | 00:05:33 | 3 Sarabandes (1887): No. 2 |  | 05:33:00
03 | 00:10:33 | 3 Sarabandes (1887): No. 3 |  | 10:33:00
04 | 00:14:47 | 3 Gymnopédies (1889): No. 1: Lent et douloureux |  | 14:47:00
05 | 00:18:27 | 3 Gymnopédies (1889): No. 2: Lent et triste |  | 18:27:00
06 | 00:21:45 | 3 Gymnopédies (1889): No. 3: Lent et grave |  | 21:45:00
07 | 00:24:38 | Gnossiennes 1-3 (1890): No. 1 |  | 1 day, 0:38:00
08 | 00:28:45 | Gnossiennes 1-3 (1890): No. 2 |  | 1 day, 4:45:00
09 | 00:30:45 | Gnossiennes 1-3 (1890): No. 3 |  | 1 day, 6:45:00
10 | 00:34:11 | Gnossiennes 4-6 (1889-1897): No. 4 |  | 1 day, 10:11:00
11 | 00:37:02 | Gnossiennes 4-6 (1889-1897): No. 5 |  | 1 day, 13:02:00
12 | 00:39:53 | Gnossiennes 4-6 (1889-1897): No. 6 |  | 1 day, 15:53:00
13 | 00:41:27 | 2 Préludes du nazaréen (1892): No. 1, assez lent |  | 1 day, 17:27:00
14 | 00:46:09 | 2 Préludes du nazaréen (1892): No. 2, assez lent |  | 1 day, 22:09:00
15 | 00:49:15 | 2 Prélude de la porte [NAME] ciel (1894) |  | 2 days, 1:15:00
16 | 00:53:00 | 2 Pièces froides (1897), No. 1: Airs a faire fuir: D’une manière très particulaire |  | 2 days, 5:00:00
17 | 00:55:59 | 2 Pièces froides (1897), No. 1: Airs a faire fuir: [NAME] |  | 2 days, 7:59:00
18 | 00:57:42 | 2 Pièces froides (1897), No. 1: Airs a faire fuir: S’inviter |  | 2 days, 9:42:00
19 | 01:00:45 | No 2: Danses de travers: En y regardent à deux fois |  | 2 days, 12:45:00
20 | [NAME] | No 2: Danses de travers: Passer |  | 2 days, 13:39:00
21 | 01:02:25 | No 2: Danses de travers: Encore |  | 2 days, 14:25:00
22 | 01:03:47 | Petite ouverture à danser (1900) |  | 2 days, 15:47:00
Spreadsheet: 0308101a-9ee1-4874-b696-2b3b4193895a
Sheet: 12-13 Request K-Day 

 | K-Day 2010 (9-10-2010) |  |  | K-Day 2011 (9-9-2011) |  |  | Proposed K-Day
 | Sources of Income | Amounts |  | Sources of Income | Amounts |  | Sources of Income | Amounts
1.) | USG | 14000 | 1.) | USG | 14000 | 1.) | USG
2.) | Carryforward | 2868.77 | 2.) | Carryforward | 1633.79 | 2.) | Carryforward
3.) |  |  | 3.) | Student Activities | 692.21 | 3.)
4.) |  |  | 4.) |  |  | 4.)
5.) |  |  | 5.) |  |  | 5.)
6.) |  |  | 6.) |  |  | 6.)
7.) |  |  | 7.) |  |  | 7.)
8.) |  |  | 8.) |  |  | 8.)
9.) |  |  | 9.) |  |  | 9.)
10.) |  |  | 10.) |  |  | 10.)
 | Total |  |  | Total |  |  | Total
 | Costs of Events |  |  | Costs of Events |  |  | Costs of Events
1.) | Entertainment | 3975 | 1.) | Entertainment |  | 1.) | Entertainment | 2500
2.) | Food | 4818.2 | 2.) | Food | 7433.53 | 2.) | Food | 7500
3.) | Equipment | 1801 | 3.) | Equipment |  | 3.) | Equipment | 3500
4.) | General Supplies | 72.64 | 4.) | General Supplies | 49.85 | 4.) | General Supplies | 100
5.) | Publicity | 868.05 | 5.) | Publicity |  | 5.) | Publicity | 1000
6.) | Other | 1950.09 | 6.) | Travel | 1326 | 6.) | Travel | 1500
7.) |  |  | 7.) | Safety | 466.76 | 7.) | Safety | 500
8.) |  |  | 8.) | Other | 50.44 | 8.) | Other | 100
9.) |  |  | 9.) |  |  | 9.)
10.) |  |  | 10.) |  |  | 10.)
 | Total |  |  | Total |  |  | Total
 | Carryforward |  |  | End Balance | 0.7 |  | Request | 16000
 |  | **Not Charged for Facilities Labor Fee or SLS (anticipated)
 | Costs 2011
1.) | Entertainment (TBA by Committee) |  |  |  | Student Affairs Guiding Principles
2.) | Food |  |  |  | Providing a diverse and inclusive community that encourages involvement and a free exchange of ideas.
3.) | Equipment (Power Generator, SLS & Tables/Chairs) |  |  |  | Valuing creativity, leadership, and excellence.
4.) | General Supplies (Tape, Cleaning Supplies & Trash Bags/Containers) |  |  |  | Including students in decisions that enhance their educational experience.
5.) | Publicity (Posters, Signs and T-Shirts for Workers to Identify Staff) |  |  |  | Being innovative and supportive in our programs, policies, and procedures.
6.) | Travel (Buses to transport students to and from McLain State Park) |  |  |  | Leading and supporting exemplary collegial relationships within the University community.
7.) | Safety (Mercy Ambulance & PSPS) |  |  |  | Student Affairs Learning Outcomes
8.) | Other (Mclain State Park Fee & Inflation Costs) |  |  |  | Learn the skills necessary to work effectively and respectfully in groups.
 |  |  |  |  | Demonstrate a sense of pride, spirit and affinity for Michigan Tech.
Spreadsheet: 874862d1721374021-translating-table-for-importin-erp-paulkloos-excel-forum-question-aligw
Sheet: Blad1

 | Input
 | Customer | Pricelist 1 | Pricelist 2 | Pricelist 3 | Pricelist 4 | Pricelist 5
 | L10000 | 41 | 42 | 43 | 44 | 45
 | [NAME] | 61 | 62
 | [NAME] | 71 | 72 | 73
 | [NAME] | 81 | 82 | 83 | 84 | 85
 | L50000 | 91 | 93 | 95
 | Output |  |  |  | Customer |  |  | Customer |  |  | Customer |  |  | Pricelist | Customer
 |  | L10000 |  | 41 | L10000 |  | 41 | L10000 |  | 41 | L10000 |  | 41 | Pricelist 1 | L10000
 | 42 | L10000 |  | 42 | L10000 |  | 42 | L10000 |  | 42 | L10000 |  | 42 | Pricelist 2 | L10000
 | 43 | L10000 |  | 43 | L10000 |  | 43 | L10000 |  | 43 | L10000 |  | 43 | Pricelist 3 | L10000
 | 44 | L10000 |  | 44 | L10000 |  | 44 | L10000 |  | 44 | L10000 |  | 44 | Pricelist 4 | L10000
 | 45 | L10000 |  | 45 | L10000 |  | 45 | L10000 |  | 45 | L10000 |  | 45 | Pricelist 5 | L10000
 | 61 | [NAME] |  | 61 | [NAME] |  | 61 | [NAME] |  | 61 | [NAME] |  | 61 | Pricelist 1 | [NAME]
 | 62 | [NAME] |  | 62 | [NAME] |  | 62 | [NAME] |  | 62 | [NAME] |  | 62 | Pricelist 2 | [NAME]
 | 71 | [NAME] |  | 71 | [NAME] |  | 71 | [NAME] |  | 71 | [NAME] |  | 71 | Pricelist 1 | [NAME]
 | 72 | [NAME] |  | 72 | [NAME] |  | 72 | [NAME] |  | 72 | [NAME] |  | 72 | Pricelist 2 | [NAME]
 | 73 | [NAME] |  | 73 | [NAME] |  | 73 | [NAME] |  | 73 | [NAME] |  | 73 | Pricelist 3 | [NAME]
 | 81 | [NAME] |  | 81 | [NAME] |  | 81 | [NAME] |  | 81 | [NAME] |  | 81 | Pricelist 1 | [NAME]
 | 82 | [NAME] |  | 82 | [NAME] |  | 82 | [NAME] |  | 82 | [NAME] |  | 82 | Pricelist 2 | [NAME]
 | 83 | [NAME] |  | 83 | [NAME] |  | 83 | [NAME] |  | 83 | [NAME] |  | 83 | Pricelist 3 | [NAME]
 | 84 | [NAME] |  | 84 | [NAME] |  | 84 | [NAME] |  | 84 | [NAME] |  | 84 | Pricelist 4 | [NAME]
 | 85 | [NAME] |  | 85 | [NAME] |  | 85 | [NAME] |  | 85 | [NAME] |  | 85 | Pricelist 5 | [NAME]
 | 91 | L50000 |  | 91 | L50000 |  | 91 | L50000 |  | 91 | L50000 |  | 91 | Pricelist 1 | L50000
 | 93 | L50000 |  | 93 | L50000 |  | 93 | L50000 |  | 93 | L50000 |  | 93 | Pricelist 2 | L50000
 | 95 | L50000 |  | 95 | L50000 |  | 95 | L50000 |  | 95 | L50000 |  | 95 | Pricelist 3 | L50000
Spreadsheet: 762513d1641586676-how-do-i-extract-unique-values-with-multiple-criteria-excel-help
Sheet: Data

Date | Section | Activity | Qty | Unit | Work-Order |  | Section | Work-Order
2020-11-01 00:00:00 | Perth | Painting | 100 | Mtr | AT-45 |  | Perth | AT-45
2020-11-02 00:00:00 | Perth | Cleaning | 20 | Tiles | BD-31 |  | Brisbane | BD-31
2020-11-03 00:00:00 | Brisbane | Shuttering | 45 | Nos | KE-79 |  | Sydney | KE-79
2020-11-04 00:00:00 | Sydney | Flooring | 60 | Each | AT-45 |  | Nowra | GD-08
2020-11-05 00:00:00 | Sydney | Flooring | 70 | Each | AT-45
2020-11-06 00:00:00 | Nowra | Painting | 40 | Mtr | AT-45
2020-11-07 00:00:00 | Perth | Painting | 100 | Mtr | AT-45
2020-11-08 00:00:00 | Perth | Cleaning | 40 | Tiles | BD-31
2020-11-09 00:00:00 | Brisbane | Painting | 200 | Mtr | BD-31
2020-11-10 00:00:00 | Brisbane | Flooring | 20 | Each | KE-79
2020-11-11 00:00:00 | Brisbane | Flooring | 20 | Each | GD-08
2020-11-12 00:00:00 | Nowra | Flooring | 30 | Each | GD-08
2020-11-13 00:00:00 | Nowra | Shifting | 15 | Each | AT-45
2020-11-14 00:00:00 | Sydney | Shifting | 20 | Each | AT-45
2020-11-15 00:00:00 | Sydney | Flooring | 50 | Each | AT-45
2020-11-16 00:00:00 | Perth | Cleaning | 30 | Tiles | AT-45
2020-11-17 00:00:00 | Brisbane | Cleaning | 30 | Tiles | BD-31
2020-11-18 00:00:00 | Nowra | Painting | 120 | Mtr | KE-79
2020-11-19 00:00:00 | Brisbane | Shuttering | 20 | Nos | AT-45
2020-11-20 00:00:00 | Perth | Shuttering | 35 | Nos | AT-45
2020-11-21 00:00:00 | Perth | Shifting | 20 | Each | GD-08
Spreadsheet: 477914d1472568688-tough-problem-how-can-i-average-different-columns-based-on-student-names-monthly-mastery-tracker_example
Sheet: Pivot_Report

 | Average of Score
 |  | 2016 |  |  |  | 2016 Total | 2017 |  |  |  |  |  | 2017 Total | Grand Total
 | Row Labels | September | October | November | December |  | January | February | March | April | May | June
 | NHM | 5 | 4.333333333333333 | 6.666666666666667 | 0.3333333333333333 | 4.083333333333333 | 19.33333333333333 | 5 | 31.33333333333333 | 44 | 2 | 6.666666666666667 | 18.05555555555556 | 12.46666666666667
 | Student x | 4 | 7 | 3 | 0 | 3.5 | 11 | 4 | 2 | 33 | 1 | 8 | 9.833333333333334 | 7.3
 | Student y | 5 | 4 | 8 | 0 | 4.25 | 2 | 5 | 87 | 35 | 3 | 9 | 23.5 | 15.8
 | Student z | 6 | 2 | 9 | 1 | 4.5 | 45 | 6 | 5 | 64 | 2 | 3 | 20.83333333333333 | 14.3
 | NS | 11 | 11 | 12.66666666666667 | 4.333333333333333 | 9.75 | 29.66666666666667 | 3.666666666666667 | 12 | 23.33333333333333 | 23 | 49 | 23.44444444444444 | 17.96666666666667
 | Student x | 10 | 10 | 14 | 11 | 11.25 | 54 | 2 | 12 | 15 | 22 | 109 | 35.66666666666666 | 25.9
 | Student y | 11 | 12 | 12 | 1 | 9 | 23 | 5 | 12 | 12 | 23 | 19 | 15.66666666666667 | 13
 | Student z | 12 | 11 | 12 | 1 | 9 | 12 | 4 | 12 | 43 | 24 | 19 | 19 | 15
 | Spelling | 8 | 1 | 2 | 3 | 3.5 | 4 | 5 | 6 | 7 | 8 | 9 | 6.5 | 5.3
 | Student x | 7 | 1 | 2 | 3 | 3.25 | 4 | 5 | 6 | 7 | 8 | 9 | 6.5 | 5.2
 | Student y | 8 | 1 | 2 | 3 | 3.5 | 4 | 5 | 6 | 7 | 8 | 9 | 6.5 | 5.3
 | Student z | 9 | 1 | 2 | 3 | 3.75 | 4 | 5 | 6 | 7 | 8 | 9 | 6.5 | 5.4
 | Grand Total | 8 | 5.444444444444445 | 7.111111111111111 | 2.555555555555555 | 5.777777777777778 | 17.66666666666667 | 4.555555555555555 | 16.44444444444444 | 24.77777777777778 | 11 | 21.55555555555556 | 16 | 11.91111111111111
Spreadsheet: 869678d1716285684-combine-multiple-vlookups-pc-test
Sheet: Sheet1

Postcode | SupplierPostcode |  | Lat_1 | Long_1 | Lat_2 | Long_2 | Distance (miles) |  | Lat1 Lookup | Long1 Lookup
AL1 1AG | LS20 9PD |  | 51.1951342 | 0.0779767 | 53.8744534 | -1.7157506
PR26 7PD | LS20 9PD |  | 50.8167744 | 0.3261108 | 53.8744534 | -1.7157506
AB10 1AG | LS20 9PD |  | 50.8167744 | 0.3261108 | 53.8744534 | -1.7157506
CF10 1AE | LS20 9PD |  | 51.4307971 | -0.1648874 | 53.8744534 | -1.7157506
Spreadsheet: 789152d1658930962-split-dollar-amount-into-different-amounts-based-on-percentage-copy-of-invoice-approval-splits-bg-sfy-2022
Sheet: Postage

 |  |  |  | USPIRITUS INVOICE APPROVAL FORM
 |  | Person  Requesting |  |  |  | Date
 |  | Supervisor Approval
 | General [NAME]
 | GL | Fund | Department | Event | Location | Grant | Restriction | Amount
 | 8140 | 01 | 546 | N000 | 31 | 99 | 1
 | 8140 | 01 | 481 | N000 | 31 | 35 | 1
 | 8140 | 01 | 482 | N000 | 31 | 35 | 1
 | 8140 | 01 | 483 | N000 | 31 | 35 | 1
 |  | 01
 |  | 01
 |  | 01
 |  | 01
 |  | 01
 |  | 01
 |  |  |  |  |  |  | TOTAL | 11
 | NOTES:
Spreadsheet: susan_pereira__39462__Patten
Sheet: Patten

 | VARIBUS CORPORATION |  |  |  |  |  |  |  | NOVEMBER 30, 1999 |  |  |  |  |  |  | {SERVICES}PSNU~QAGQ
 | P.O. BOX 61000
 | NEW ORLEANS, LA 70161 |  |  |  |  |  | INVOICE NUMBER |  |  |  |  | 99-11-11
 | PH# (504)576-4152
 | IN ACCOUNT WITH
 | PATTEN ENERGY, INC. |  |  |  |  |  |  |  | AMOUNT
 | 5701 WEST SLAUSON AVE.
 | CULVER CITY, CA 90230-6582
 |  |  |  |  |  | PER
MMBTU'S |  |  | [NAME] |  |  | MMBTU |  |  |  |  |  | AMOUNT
155000 |  |  | Natural Gas Transported to |  |  | 0.03 |  |  |  |  |  | 4650
 |  |  | GSU at [NAME] in
 |  |  | Oct 1999 (Via TETCO)
 |  |  |  | TOTAL AMOUNT DUE
 | Contact Person
 | Acctg. Questions     [NAME]# (504)576-4152
 | Operational Questions    Gary Sobczak PH# (281)297-3553
PLEASE REMIT TO:   P.O. BOX 61000, NEW  ORLEANS, LA. 70161
 |  |  | Attn: [NAME]
Spreadsheet: 272248d1382304324-help-please-help-to-make-a-formula-to-get-me-the-next-event-date-sample-attached-f1
Sheet: Sheet1

Today | 2013-10-21 00:00:00
Name/ Date | 2013-10-17 00:00:00 | 2013-10-18 00:00:00 | 2013-10-19 00:00:00 | 2013-10-20 00:00:00 | 2013-10-21 00:00:00 | 2013-10-22 00:00:00 | 2013-10-23 00:00:00 | 2013-10-24 00:00:00 | 2013-10-25 00:00:00 | 2013-10-26 00:00:00 | 2013-10-27 00:00:00 | 2013-10-28 00:00:00 | 2013-10-29 00:00:00 | 2013-10-30 00:00:00 | 2013-10-31 00:00:00
Mido | Day | RDO | Day | Day | Day | Day | Day | Day | Day | RDO | Day | Day | Day | Day | RDO | 2013-10-26 00:00:00
Jamy | Night | Night | Night | Night | Night | Night | Night | Off | Off | Off | Off | Off | Off | Off | Off | #N/A
Micheal | Day | Day | Day | Day | Day | Day | RDO | Night | Night | Night | Night | Night | Night | Night | Night | 2013-10-23 00:00:00
[NAME] | Off | Off | Off | Off | Off | Off | Off | Off | Off | Off | TRF | Day | Day | Day | Day | #N/A
 |  |  | Name | Micheal
 |  |  | Next RDO | 2013-10-23 00:00:00
 |  |  | Next Day
 |  |  | Next Off
Spreadsheet: 484403d1476263955-fill-the-form-in-sheet3-using-data-from-sheet1-school-reports
Sheet: Awael

 | Monthly Report for The Buses In the Schools |  |  |  |  |  |  | Month:
 |  | School Name: | [NAME]
 |  | School Type: | KG
 | Serial No | Bus Number | Bus Type | Trip Type |  |  |  | Shared School Name |  | Driver Name
 |  |  |  | Large Bus |  | Small Bus
 |  |  |  | Double | Single | Double | Single
 | 1 | B0026858
 | 2 | [NAME]
 | 3 | B0006901
 | 4 | B0008210
 | 5 | B0027345
 | 6 | B0026078
 | 7 | B0007080
 | 8 | B0032023
 | 9 | B0009429
 | 10 | B0009810
 | 11 | B0024688
 | 12 | B0021162
 | 13 | B0009409
 | 14 | [NAME]
 | 15
 | 16 | B0009450
 | 17 | B0006405
 | 18 | B0005008
 | 19 | B0032020
 | 20 | B0015482
 | 21 | B0009449
 | 22 | B0026462
 | 23 | B0009319
 | 24 | B0013146
 | 25 | B0005001
 | 26 | B0004269
 | 27 | B0026271
 | Total
Spreadsheet: 884665d1733907380-need-help-to-have-both-holidays-of-japan-and-french-to-be-reflected-on-calendar-excel-moseslimla-upgrade-needed_2025_retro-planning-cf-365-aligw
Sheet: Holidays

 | New Year's |  | F
 | Bank OFF Day | 2025-01-02 00:00:00 | J
 | Bank OFF Day | 2025-01-03 00:00:00 | J
 | Coming of Age Day (second Monday in January) |  | F | DATE(year,monthnumber,1+7*nth_occurrence)-WEEKDAY(DATE(year,monthnumber,8-dayofweek))
 | National Foundation Day | February 11 (Observed on February 12) | F | where year is in B2 and month (as a number 1 to 12) is in A2, and where xday is a number representing the day of the week (1 = Sun through to 7 = Sat), so for 1st Saturday that becomes
 | Emperor’s Birthday | February 23 (Observed on February 24) | F
 | Vernal Equinox Day | 2025-03-20 00:00:00 | F | For holidays that are the nearest Friday or Monday if they fall on a weekend
 | Shōwa Day | 2025-04-29 00:00:00 | F | DATE(year,monthnumber,daynumber)+IF(WEEKDAY(DATE(year,monthnumber,daynumber))=1,1,IF(WEEKDAY(DATE(year,monthnumber,daynumber))=7,-1,0))
 | Constitution Memorial Day | 2025-05-03 00:00:00 | F
 | Greenery Day | May 4 (Observed on May 6) | F
 | Children’s Day | 2024-05-05 00:00:00 | F
 | Marine Day | July 15 (Third Monday in July) | F
 | Mountain Day | August 11 (Observed on August 12) | F
 | Obon Festival |  | J
 | Obon Festival |  | J
 | Obon Festival |  | J
 | Respect for the Aged Day | September 16 (Third Monday in September) | F
 | Autumnal Equinox Day | 2025-09-23 00:00:00 | F
 | Sports Day | October 14 (Second Monday in October) | F
 | Culture Day | November 3 (Observed on November 4) | F
 | Labor Thanksgiving Day | November 23 (Observed on November 24) | F
Spreadsheet: 803819d1667725548-how-to-do-fast-replacing-of-row-number-accross-different-columns-copy-of-baza-nova-verzija-racuni-1-
Sheet: R52

Ime artikla
Spreadsheet: 810349d1671712043-find-and-return-a-value-based-each-date-date-by-rev-listing-all-etaf
Sheet: POData

PONUM | Order Date | PartNum | RevisionNum
55564 | 2022-07-25 00:00:00 | 100-101-039 | PJ01SB
55650 | 2022-09-15 00:00:00 | 100-101-041 | ZF01JA
55653 | 2022-09-16 00:00:00 | 100-101-058 | EU02SE
55671 | 2022-09-26 00:00:00 | 100-101-039 | PJ02SB
55715 | 2022-10-07 00:00:00 | 100-101-058 | EU03SE
55726 | 2022-10-12 00:00:00 | 100-101-058 | EU04SE
55779 | 2022-11-11 00:00:00 | 100-101-058 | EU05SE
55801 | 2022-11-15 00:00:00 | 100-101-058 | EU06SE
55845 | 2022-12-21 00:00:00 | 100-101-041 | ZF0JA
Spreadsheet: 675151d1588177384-percentage-discount-increase-percentage-discount-increase
Sheet: Sheet1

No. Days Hire | Base day Rate | Gross total | Discount | [NAME] total | difference | mean daily %
15 | 100 |  | 0.25
10 | 100 |  | 0.15
7 | 100 |  | 0.1
5 | 100 |  | 0.05
4 | 100 |  | 0.03
3 | 100 |  | 0.02
2 | 100 |  | 0.01
1 | 100 |  | 0
Spreadsheet: 888882d1739503417-add-a-measure-in-pivot-based-on-dates-not-a-number-add-a-measure-in-pivot-based-on-dates-not-a-number-
Sheet: Sheet1

NO | Cage's | Uji Antibiotik | NOTE
1 | GA01 | 00:00:00 | BELUM |  |  |  |  |  |  | I WANT TO ADD THIS ON A PIVOT
2 | GA02 | 00:00:00 | BELUM |  |  |  | Row Labels | Count of Uji Antibiotik | Count of NOTE | NOTE
3 | GA03 | 00:00:00 | BELUM |  |  |  | GA01 | 1 | 1 | BELUM
4 | GA04 | 00:00:00 | BELUM |  |  |  | GA02 | 1 | 1 | BELUM
5 | GA05 | 00:00:00 | BELUM |  |  |  | GA03 | 1 | 1 | BELUM
6 | GA06 | 00:00:00 | BELUM |  |  |  | GA04 | 1 | 1 | BELUM
7 | GA07 | 00:00:00 | BELUM |  |  |  | GA05 | 1 | 1 | BELUM
8 | GA08 | 2024-11-20 00:00:00 | SUDAH |  |  |  | GA06 | 1 | 1 | BELUM
9 | GA09 | 2025-02-09 00:00:00 | SUDAH |  |  |  | GA07 | 1 | 1 | BELUM
10 | GA10 | 2024-11-20 00:00:00 | SUDAH |  |  |  | GA08 | 1 | 1 | SUDAH
 |  |  |  |  |  |  | GA09 | 1 | 1 | SUDAH
 |  |  |  |  |  |  | GA10 | 1 | 1 | SUDAH
 |  |  |  |  |  |  | Grand Total | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  | HOW TO ADD A MEASURE, SO I CAN ADD THIS TO THE PIVOT
Spreadsheet: 721079d1614457684-how-to-fix-calculation-when-handling-costs-costsef
Sheet: Costs

[NAME] | 550000 |  |  |  |  | Item 1 | Quantity | Gallons | Annual | Total Costs
Hours | 1220000 |  |  |  |  | 1 | 4 | 80000 | 7500
Peak Vehicles | 330000 |  |  |  |  |  |  |  |  |  |  |  | 109875
 |  | Expenses
[NAME] = | 1000000 | U1=
Vehicle Hours = | 83300 | U2=
Peak Vehicles = | 44 | U3=
Spreadsheet: fce4662e-cbc4-4bd4-b031-800d103a0cf8
Sheet: Flexible Budget

 | Budget |  |  |  |  |  |  |  | Fringe Calculator
 |  |  |  |  |  |  |  |  | Please Enter [NAME] Here |  |  |  | 0
 |  |  |  |  |  |  |  |  | Your Fringe Rate Is
 | Senior Salaries |  | [NAME] | Year 1 | Year 2 | Year 3 | Total
 | Senior 1 |  | 0 | 0 | 0 | 0 | 0
 | Senior 2 |  | 0 | 0 | 0 | 0 |  |  | For Students Please Use |  |  | 0.01 | Academic Year
 | Senior 3 |  | 0 | 0 | 0 | 0 |  |  |  |  |  | 0.09 | Summer
 | Senior 4 |  | 0 | 0 | 0 | 0 |  |  |  |  |  | 0.03 | Full Year
 | Senior 5 |  | 0 | 0 | 0 | 0 | 0
 | Total Salaries
 | Student/IH Salaries
 | Student/IH 1
 | Student/IH 2
 | Student/IH 3 |  |  | 0 | 0 | 0
 | Student/IH 4 |  |  | 0 | 0 | 0
 | Student/IH 5 |  |  | 0 | 0 | 0
 | Total Student/IH Salaries
 | Fringe |  | Rate
 | Senior 1 |  | 0
 | Senior 2 |  | 0
 | Senior 3 |  | 0
 | Senior 4 |  | 0
 | Senior 5 |  | 0
 | Student/IH 1 |  | 0
 | Student/IH 2 |  | 0
 | Student/IH 3 |  | 0
 | Student/IH 4 |  | 0
 | Student/IH 5 |  | 0
 | Total  Fringe
 | Total Salaries and [NAME]
 | Travel |  |  | Year 1 | Year 2 | Year 3 | Total
 |  |  |  | 0 | 0 | 0 |  |  | UI mileage rate = .555 mi
 |  |  |  | 0 | 0 | 0 |  |  | In State Per Diem = $30 per day
 |  |  |  | 0 | 0 | 0 |  |  | Out of State Per Diem = $46 per day
 |  |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 |  |  | *Please note - this information is current as of 12/1/2013) always check the OSP website for most current information
 | Total Travel
 | Other Direct Costs (include 1st $25,000 of Subawards here)
 |  |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0
 | Total Direct Costs
 | Total Direct Costs
 | Total
 | Indirect Costs |  | Rate
 |  |  | 0
 | Total Costs
 | Equipment >$5,000
 |  |  |  | 0 | 0 | 0
 | Total Equipment >$5,000
 | Subaward >$25,000
 |  |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0
 | Total Subaward >$25,000
 | Tuition
 |  |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0
 | Total Tuition
 | Total Budget
Spreadsheet: 784408d1655724199-data-extracting-sorting-and-organizing-drgkt-v1
Sheet: Sheet3

LastName | FirstName | MiddleName | Prefix | EMAIL;WORK: | NICKNAME: | ORG: | TEL;ANOTHERCUSTOM: | [NAME]: | TEL;CELL-2: | TEL;CUSTOM: | TEL;HOME: | TEL;HOME;FAX: | TEL;PAGER: | TEL;PREF: | TEL;VOICE: | TEL;WORK: | TEL;WORK;FAX: | TITLE:
Smoe | [NAME] | [NAME] | Mr. |  |  |  |  | +[PHONE] |  |  |  | 555 3333 | [PHONE] |  |  |  | (201) 555-2222
Doe | [NAME] | [NAME] |  | [EMAIL] | MAYJO | MICROSOFT | [PHONE] | +[PHONE] | 16664444 | 666 1111 | (201) 555 6666 | [PHONE] | +[PHONE] | 6662222 | 5558888 | [PHONE] | 555-9999 | CEO
Spreadsheet: 137134d1326973518-count-the-number-between-specific-range-of-numbers-range
Sheet: Sheet1

 | AMOUNT
 | 2018
 | 850
 | 1563
 | 913
 | 0
 | 2397
 | 1435
 | 0
 | 1999
 | 956
 | 2644
 | 0
 | 1244
 | 3795
 | 0
 | 1081
 | 4340
 | 1567
 | 0
 | 1142
 | 1364
 | 4667
 | 3160
 | 0
 | 0
 | 0
 | 2223
 | 1491
 | 2427
RANGES | How Many?
1-500
501-1000
1001-1350
1351-1600
1601-2000
2001-2450