tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 598737d1542689972-extract-until-next-criteria-june-jackson-excel
Sheet: examples

example where there is only one person listed
From these two lines of data
1QBZ69 | 7324
THURMON | STEVE
to this one line of data
1QBZ69 | 7324 | THURMON | STEVE
example where two people are listed
From these five lines of data
1TDD50 | 1024
MARTIN
MARTIN
[NAME] | MRS
[NAME] | MR
to these two lines of data
1TDD50 | 1024 | MARTIN | [NAME] | MRS
1TDD50 | 1024 | MARTIN | [NAME] | MR
example where three people are listed
From these seven lines of data
4TPS87 | 7231
BUCKLEY
SHIN
SHIN | JR
SHERRI | MS
IRENE | MS
VINCENT | MR
to these three lines of data
4TPS87 | 7231 | BUCKLEY | SHERRI | MS
4TPS87 | 7231 | SHIN | IRENE | MS
4TPS87 | 7231 | SHIN | VINCENT | MR
example where four people are listed
From the nine lines of data
1FPX88 | 7282
WIMBERLY
WIMBERLY
DEATCHER
DEATCHER
KAYLA | MRS
STEVEN | MR
ADAM | MR
HOPE | MRS
to these four lines of data
1FPX88 | 7282 | WIMBERLY | KAYLA | MRS
1FPX88 | 7282 | WIMBERLY | STEVEN | MR
1FPX88 | 7282 | DEATCHER | ADAM | MR
1FPX88 | 7282 | DEATCHER | HOPE | MRS
Spreadsheet: 844497d1696270757-index-match-with-multiple-columns-business-book-bvj-
Sheet: Sheet1

 |  |  |  | Information |  |  | Company | Company D | [NAME]'s Solution
Company A |  |  |  | Employee Population | 100 |  | Employee Population | 1000
Company A |  |  |  | Headquarters | AZ |  | Headquarters | TX
Company A |  |  |  | Revenue | $100M |  | Revenue | $300M
Company A |  |  |  | Specialty | Manufacturing |  | Specialty | Aviation
 | Company B |  |  | Employee Population | 10
 | Company B |  |  | Headquarters | WI
 | Company B |  |  | Revenue | $5M
 | Company B |  |  | Specialty | Fabrication
 |  | Company C |  | Employee Population | 10000
 |  | Company C |  | Headquarters | FL
 |  | Company C |  | Revenue | $200M
 |  | Company C |  | Specialty | Welding
 |  |  | Company D | Employee Population | 1000
 |  |  | Company D | Headquarters | TX
 |  |  | Company D | Revenue | $300M
 |  |  | Company D | Specialty | Aviation
Spreadsheet: 673201d1587248566-univocal-and-ordered-list-a-z-with-management-of-empty-cells-univ
Sheet: Foglio2

 |  |  |  |  |  |  |  |  |  |  | SCHNEIDER
 |  |  |  |  |  |  |  |  |  |  | SCHNEIDER
 |  |  |  |  |  |  |  |  |  |  | ICAV
 |  |  |  |  |  |  |  |  |  |  | APC
 |  |  |  |  |  |  |  |  |  |  | SATI
 |  |  |  |  |  |  |  |  |  |  | CAVI
 |  |  |  |  |  |  |  |  |  |  | DISANO
 |  |  |  |  |  |  |  |  |  |  | BEGHELLI
 |  |  |  |  |  |  |  |  |  |  | NOTIFIER
 |  |  |  |  |  |  |  |  |  |  | PASO
 |  |  |  |  |  |  |  |  |  |  | SIEMSN
 |  |  |  |  |  |  |  |  |  |  | BTICINO
 |  |  |  |  |  |  |  |  |  |  | BTICINO
 |  |  |  |  |  |  |  |  |  |  | CDVI
 |  |  |  |  |  |  |  |  |  |  | TELEVES
 |  |  |  |  |  |  |  |  |  |  | FTV
 |  |  |  |  |  |  |  |  |  |  | DIVERSE
 |  |  |  |  |  |  |  |  |  |  | DIVERSE
 |  |  |  |  |  |  |  |  |  |  | DIVERSE
 |  |  |  |  |  |  |  |  |  |  | GEWISS
 |  |  |  |  |  |  |  |  |  |  | BTICINO
 |  |  |  |  |  |  |  |  |  |  | ZUCCHINI
 |  |  |  |  |  |  |  |  |  |  | DIVERSE
 |  |  |  |  |  |  |  |  |  |  | SIEMENS
 |  |  |  |  |  |  |  |  |  |  | ICRI
 |  |  |  |  |  |  |  |  |  |  | EDILE
 |  |  |  |  |  |  |  |  |  |  | SMAL
 |  |  |  |  |  |  |  |  |  |  | NOLO
 |  |  |  |  |  |  |  |  |  |  | ONERI
 |  |  |  |  |  |  |  |  |  |  | CETI
 |  |  |  |  |  |  |  |  |  |  | CETI
 |  |  |  |  |  |  |  |  |  |  | EDILE
 |  |  |  |  |  |  |  |  |  |  | MEK
Spreadsheet: 126609d1319773949-spreadsheet-with-multi-formulae-help-stock-control
Sheet: MONTHLY COST

MONTHLY EXPENSES SHEET PER VEHICLE OCTOBER 2011 |  |  |  |  |  |  |  |  |  |  |  |  |  | COST TABLE - named range
 | SD06 | AD06 | MT03 | AD54 | EJ53 | MA59 | BD55 | Y691 | TOTALS |  |  |  |  | Item | Cost
ADHESIVE | 1 |  |  |  |  |  |  |  |  |  |  |  |  | ADHESIVE | 5.25
DEGREASER | 2 |  |  |  |  |  |  |  |  |  |  |  |  | DEGREASER | 6.85
SINGLE EDGED BLADES |  |  |  |  |  |  | 3 |  |  |  |  |  |  | SINGLE EDGED BLADES | 1.2
STANLEY BLADES |  | 3 |  |  |  |  |  | 3 |  |  |  |  |  | STANLEY BLADES | 0.75
LONG BLADES |  |  | 4 |  |  |  |  |  |  |  |  |  |  | LONG BLADES | 1
TISSUE ROLL |  |  |  | 5 |  |  |  |  |  |  |  |  |  | TISSUE ROLL | 2.5
CUTTING GLOVES |  |  |  |  | 6 |  |  |  |  |  |  |  |  | CUTTING GLOVES | 15
RUBBER GLOVES |  |  |  |  |  | 7 |  |  |  |  |  |  |  | RUBBER GLOVES | 8
TOTALS PER VEHICLE
MONTHLY EXPENSES SHEET PER VEHICLE NOVEMBER 2011
 | SD06 | AD06 | MT03 | AD54 | EJ53 | MA59 | BD55 | Y691 | TOTALS
ADHESIVE
DEGREASER
SINGLE EDGED BLADES
STANLEY BLADES
LONG BLADES
TISSUE ROLL
CUTTING GLOVES
RUBBER GLOVES
MONTHLY EXPENSES SHEET PER VEHICLE DECEMBER 2011
 | SD06 | AD06 | MT03 | AD54 | EJ53 | MA59 | BD55 | Y691 | TOTALS
ADHESIVE
DEGREASER
SINGLE EDGED BLADES
STANLEY BLADES
LONG BLADES
TISSUE ROLL
CUTTING GLOVES
RUBBER GLOVES
MONTHLY EXPENSES SHEET PER VEHICLE JANUARY 2012
 | SD06 | AD06 | MT03 | AD54 | EJ53 | MA59 | BD55 | Y691 | TOTALS
ADHESIVE
DEGREASER
SINGLE EDGED BLADES
STANLEY BLADES
LONG BLADES
TISSUE ROLL
CUTTING GLOVES
RUBBER GLOVES
MONTHLY EXPENSES SHEET PER VEHICLE FEBRUARY 2012
 | SD06 | AD06 | MT03 | AD54 | EJ53 | MA59 | BD55 | Y691 | TOTALS
ADHESIVE
DEGREASER
SINGLE EDGED BLADES
STANLEY BLADES
LONG BLADES
TISSUE ROLL
CUTTING GLOVES
RUBBER GLOVES
MONTHLY EXPENSES SHEET PER VEHICLE MARCH 2012
 | SD06 | AD06 | MT03 | AD54 | EJ53 | MA59 | BD55 | Y691 | TOTALS
ADHESIVE
DEGREASER
SINGLE EDGED BLADES
STANLEY BLADES
LONG BLADES
TISSUE ROLL
CUTTING GLOVES
RUBBER GLOVES
Spreadsheet: 145902d1331808981-summing-multiple-sheets-indirect-formula-example
Sheet: Summary

 |  |  |  |  | Total M2 by Product |  |  |  |  |  |  |  |  |  |  |  | Total M2 by Product
 |  | Product 1 | Extra 1 |  | 18 | 17 | 14 | 20 | 25 | 17 | 22 | 14 | 14 | 18 | 179 |  | 138 | 163 | 259 | 165 | 135 | 132 | 182 | 193 | 108 | 223 | 1698
 |  | Product 2 | Extra 2 |  | 19 | 21 | 9 | 24 | 15 | 8 | 17 | 23 | 11 | 20 | 167 |  | 249 | 146 | 186 | 179 | 128 | 245 | 217 | 246 | 130 | 133 | 1859
 |  | Product 3 | Extra 3 |  | 19 | 18 | 18 | 18 | 17 | 16 | 13 | 18 | 11 | 20 | 168 |  | 97 | 195 | 154 | 276 | 152 | 224 | 178 | 76 | 195 | 149 | 1696
 |  | Product 4 | Extra 4 |  | 15 | 14 | 25 | 14 | 21 | 16 | 20 | 19 | 12 | 12 | 168 |  | 97 | 126 | 181 | 192 | 180 | 144 | 213 | 113 | 221 | 80 | 1547
 |  | Product 5 | Extra 5 |  | 13 | 11 | 11 | 16 | 18 | 23 | 12 | 17 | 13 | 17 | 151 |  | 58 | 120 | 125 | 172 | 170 | 190 | 165 | 131 | 164 | 141 | 1436
 |  | Product 6 | Extra 6 |  | 27 | 16 | 12 | 14 | 16 | 21 | 22 | 19 | 17 | 11 | 175 |  | 212 | 73 | 207 | 157 | 118 | 155 | 160 | 129 | 144 | 132 | 1487
 |  | Product 7 | Extra 7 |  | 20 | 22 | 18 | 21 | 15 | 17 | 17 | 15 | 20 | 18 | 183 |  | 201 | 244 | 226 | 180 | 131 | 227 | 165 | 174 | 172 | 231 | 1951
 |  | Product 8 | Extra 8 |  | 19 | 14 | 11 | 10 | 7 | 4 | 24 | 15 | 22 | 12 | 138 |  | 174 | 64 | 176 | 142 | 252 | 115 | 256 | 177 | 221 | 216 | 1793
 |  | Product 9 | Extra 9 |  | 7 | 22 | 5 | 12 | 10 | 10 | 15 | 12 | 16 | 13 | 122 |  | 85 | 122 | 102 | 125 | 128 | 164 | 140 | 157 | 94 | 98 | 1215
 |  | Product 10 | Extra 10 |  | 17 | 19 | 13 | 7 | 17 | 28 | 20 | 21 | 15 | 15 | 172 |  | 127 | 234 | 141 | 146 | 235 | 197 | 138 | 187 | 202 | 183 | 1790
 |  | Product 11 | Extra 11 |  | 14 | 22 | 18 | 14 | 12 | 18 | 16 | 22 | 10 | 20 | 166 |  | 184 | 267 | 157 | 204 | 132 | 160 | 107 | 169 | 200 | 82 | 1662
 |  | Product 12 | Extra 12 |  | 20 | 18 | 15 | 8 | 14 | 25 | 15 | 18 | 10 | 13 | 156 |  | 138 | 230 | 231 | 179 | 186 | 167 | 117 | 145 | 151 | 96 | 1640
 |  | Product 13 | Extra 13 |  | 15 | 19 | 26 | 20 | 26 | 21 | 20 | 26 | 19 | 14 | 206 |  | 161 | 89 | 239 | 203 | 150 | 97 | 142 | 179 | 117 | 225 | 1602
 |  | Product 14 | Extra 14 |  | 17 | 21 | 20 | 29 | 14 | 7 | 17 | 15 | 11 | 13 | 164 |  | 106 | 140 | 151 | 225 | 189 | 188 | 209 | 182 | 147 | 134 | 1671
 |  | Product 15 | Extra 15 |  | 13 | 28 | 16 | 19 | 22 | 13 | 21 | 22 | 20 | 13 | 187 |  | 128 | 117 | 210 | 76 | 169 | 131 | 174 | 175 | 197 | 182 | 1559
 |  | Product 16 | Extra 16 |  | 20 | 12 | 24 | 16 | 20 | 12 | 19 | 9 | 21 | 13 | 166 |  | 215 | 185 | 128 | 211 | 74 | 198 | 225 | 177 | 104 | 262 | 1779
 |  |  |  |  | 273 | 294 | 255 | 262 | 269 | 256 | 290 | 285 | 242 | 242 | 2668 |  | 2370 | 2515 | 2873 | 2832 | 2529 | 2734 | 2788 | 2610 | 2567 | 2567 | 26385
Spreadsheet: 864279d1711497901-find-the-most-recent-buy-value-find_buy_price_example
Sheet: Sheet1

Date | Signal | Price | #[NAME] | Value | Profit
2014-03-27 00:00:00 | Buy | 184.58
2014-03-28 00:00:00 | Ignore | 185.49
2014-03-31 00:00:00 | Sell | 187.01
2014-08-28 00:00:00 | Buy | 200.14
2014-08-29 00:00:00 | Sell | 200.71
2014-09-30 00:00:00 | Buy | 197.02
2014-10-01 00:00:00 | Ignore | 194.35
2014-10-02 00:00:00 | Ignore | 194.38
2014-10-03 00:00:00 | Sell | 196.52
2014-12-31 00:00:00 | Buy | 205.54
2015-01-02 00:00:00 | Ignore | 205.43
2015-01-05 00:00:00 | Ignore | 201.72
2015-01-06 00:00:00 | Ignore | 199.82
2015-01-07 00:00:00 | Ignore | 202.31
2015-01-08 00:00:00 | Sell | 205.9
Calculate the Profit = Current "Sell" Value - Previous "Buy" Value
Note that distance between the Buy and Sell Rows are not constant
Only F4 is correct, the other are wrong.
The problem is to find the most recent buy value
Spreadsheet: 203701d1357227366-link-data-in-worksheets-add-deduct-formulas-as-criteria-are-arent-met-attendance-template-excel
Sheet: May

Employee Absence Schedule
May | Dates of Absence
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Employee Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | CI | T | NCNS | Total Points
Employee 1
Employee 2
Employee 3
Employee 4
Employee 5
Spreadsheet: louise_kitchen__24097__NEWCO HEADCOUNT NAMES1
Sheet: Gas Risk

Gas Risk |  | ok |  | Bonus
AC Romero | Admin, Sr. | 1 |  | 5000
[NAME] | Analyst |  |  | 5000
Stephanie Hopkins | Analyst |  |  | 5000
[NAME] | Analyst |  |  | 5000
[NAME] | Analyst |  |  | 3000
[NAME] | Analyst |  |  | 5000
[NAME] | Analyst |  |  | 5000
[NAME] | Analyst |  |  | 5000
[NAME] | Analyst |  |  | 5000
Stephan Perich | Analyst |  |  | 5000
[NAME] | Analyst |  |  | 5000
[NAME] | Analyst |  |  |  | ????
Rodrique, [NAME] | Analyst | 12 |  | 20000
Kelly Little | Associate | 1 |  | 20000
[NAME] | Clerk, Sr. | 1 |  | 3000
[NAME] | Director | 1 |  |  | R
[NAME] | Manager |  |  |  | R
[NAME] | Manager |  |  |  | R
[NAME] | Manager |  |  |  | R
[NAME] | Manager |  |  |  | R
Greg Couch | Manager |  |  | 15000 | Is this Charles
[NAME] | Manager |  |  | 25000
Darron Giron | Manager | 7 |  | 20000
[NAME] | Spec |  |  | 5000
[NAME] | Spec |  |  | 5000
[NAME] | Spec |  |  | 5000
[NAME] | Spec |  |  | 5000
[NAME] | Spec |  |  | 5000
[NAME] | Spec |  |  |  | R
[NAME] | Spec |  |  | 10000
[NAME] | Spec |  |  | 5000
[NAME] | Spec |  |  | 5000 | Is this [NAME]?
[NAME] | Spec | 10 |  | 20000
[NAME] | Sr. Spec |  |  | 15000 | Is this [NAME]????
[NAME] | Sr. Spec |  |  |  | R
O'neil Winfree | Sr. Spec |  |  |  | R
[NAME] | Sr. Spec |  |  | 8000
[NAME] | Sr. Spec |  |  | 5000
[NAME] | Sr. Spec | 6 |  | 5000
[NAME] | Staff |  |  | 5000
[NAME] | Staff | 2 |  | 5000
Spreadsheet: 762040d1641375613-extract-line-items-that-are-not-contra-values-repeating
Sheet: Sheet1

 |  | X | Y | Z | Required Result
 |  | A | 1000
 |  | A | 1000
 |  | A | 1000
 |  | B | 2000
 |  | B | 2000
 |  | C | 3000
 |  | C | 3000
 |  | C | 3000
 |  | C | 3000
 |  | C | 3000
Spreadsheet: 792431d1660900856-multiple-key-word-match-book5
Sheet: Sheet1

MAKT_Material_Description | CODE |  | KEY1 | KEY2 | KEY3 | [NAME] | KEY5 | KEY6 | CODE
BOLT & NUT, HEX HEAD, [NAME], BLACK, | 3116162110 |  | BOLT | NUT | HEX | M16 | 65MM | BLACK | 3116162110
BOLT & NUT, HEX HEAD, [NAME], BLACK, | 3116162111 |  | BOLT | NUT | HEX | M16 | 65MM | GALV | 3116162120
BOLT & NUT, HEX HEAD, [NAME], BLACK, |  |  | BOLT | NUT | HEX | M16 | 65MM | ZNC | 3116162130
BOLT & NUT, HEX HEAD, M20 X 65MM, BLACK, |  |  | BOLT | NUT | HEX | M16 | 65MM | PVC | 3116162140
BOLT & NUT, HEX HEAD, [NAME], ZNC, | 3116162130 |  | BOLT | NUT | HEX | M16 | 75MM | BLACK | 3116162111
BOLT & NUT, HEX HEAD, [NAME], ZNC, | 3116162131 |  | BOLT | NUT | HEX | M16 | 75MM | GALV | 3116162121
BOLT & NUT, HEX HEAD, [NAME], |  |  | BOLT | NUT | HEX | M16 | 75MM | ZNC | 3116162131
BOLT & NUT, HEX HEAD, M20 X 65MM, ZNC, |  |  | BOLT | NUT | HEX | M16 | 75MM | PVC | 3116162141
BOLT & NUT, HEX HEAD, [NAME], PVC, | 3116162140
BOLT & NUT, HEX HEAD, [NAME], PVC, | 3116162141
BOLT & NUT, HEX HEAD, [NAME], PVC,
BOLT & NUT, HEX HEAD, M20 X 65MM, PVC,
Spreadsheet: 849477d1699950265-help-with-formulas-please-classes-example-hd
Sheet: MASTER

Code | Name | Gender | ENGLISH | SCIENCE
11 | [NAME] | F
22 | [NAME] | M
33 | Mark | M
44 | Tania | F
55 | [NAME] | F
66 | [NAME] | M
77 | [NAME] | M
88 | Bec | F
99 | [NAME] | M
0 | [NAME] | M
Spreadsheet: 848512d1699256635-check-grade-base-on-condition-sample
Sheet: Sheet1

 |  | S/No | Marks | Results Formula | Grade
 |  | 1 | 01 |  | A
 |  | 2 | 05 |  | A
 |  | 3 | 25 |  | A
 |  | 4 | 01 AR |  | B
 |  | 5 | 05 AR |  | B
 |  | 6 | 25 AR |  | B
 |  | 7 | 26 |  | C
 |  | 8 | 43 |  | C
 |  | 9 | 44 |  | D
 |  | 10 | 45 |  | D
Spreadsheet: 880124d1727753172-cell-value-not-recognised-tommungo-sample
Sheet: Sheet1

 | Track/Trail Details |  |  |  |  |  |  |  |  |  | Trail Grading |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Signage |  |  |  | Images
 | Track/Trail Name | TrackTrail Ngunnawal name/ proposal | District | Reserve/ Management Area | Type (Walking Track, shared-use) | Total length (return) in meters, or km to nearest 100m | Time in mins if under 1 hour or hours and closest 15 mins. | Surface | Detailed trail description (e.g. give some details about the trail experience) |  | Distance | Gradient ([NAME]) | Quality of path | Quality of markings | Experience required | Steps | Distance | Gradient ([NAME]) | Quality of path | Quality of markings | Experience required | Steps | AWTGS Grade | AWTG Description (Public) |  | Trailhead signage in place | Wayfinding Signage | Interpretive signage |  | Images link
 | Birrigai Time Trail |  | Tidbinbilla | TNR | Walking Track | 3km, | 1 hour, |  |  |  | Total distance of track must not exceed five km | The gradient is generally no steeper than 1:10 (or 10% or 5.7 degrees). (AS 2165.1) | Formed earthen track, few obstacles. Generally a modified surface, sections may be hardened. [NAME]: variable and less than 1200mm. Kept mostly clear of intrusions and obstacles. (AS 2165.1) | 1. Track head signage and route markers at intersections. | 2. Users need no previous experience and are expected to exercise normal care regarding their personal safety. Suitable for most ages and fitness levels. | Minimal use of steps.
 | [NAME] |  | Tidbinbilla | TNR | Walking Track | 1km, | 30 mins, |  |  |  | Total distance of track must not exceed ten km | The gradient is generally no steeper than 1:10 (or 10% or 5.7 degrees). (AS 2165.1)
 | [NAME] |  | Tidbinbilla | TNR | Walking Track | 3.1km, | 1
 | [NAME] |  | Tidbinbilla | TNR | Walking Track | 600 meters, | 25 mins, |  |  |  | Total distance of track must not exceed five km | Grades in accordance with the AS 1428 series. (AS2165.1) A ramp at 1:14 (7.14% slope or 4.1degrees) is the maximum slope suitable for a person in a wheelchair | Broad, hard surfaced track suitable for wheelchair use. [NAME]: 1200mm or more. [NAME] with minimal intrusions. (AS 2165.1) | 1. Track head signage and route markers at intersections. | 1. Users need no previous experience and are expected to exercise normal care regarding their personal safety. | Steps allowed only with alternate ramp access. (AS 2165.1)
 | Turkey Hill Trail |  | Tidbinbilla | TNR | Walking Track | 0.5 | 0.25
Spreadsheet: 672515d1586895214-calculating-total-of-repeating-columns-due-to-day-date-gl-tap-ex
Sheet: Clock

 | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Total Clock Hours:
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
TECHNICIAN | CH | CH | CH | CH | CH | CH | CH | CH | CH | CH | CH | CH | CH | CH | CH | CH | CH | CH | CH | CH | CH | CH | CH | CH | CH | CH | CH | CH | CH | CH
A | 2 | 2 | 2 |  |  | 13
B | 0 | 0 | 8 | 0 |  | 2.5
C | 1.7 | 2.1 | 0 | 0 |  | 0
D | 2.5 | 0.3 | 3.2 | 0 |  | 0.4
E | 0 | 0.5 | 2.5 | 0 |  | 5.3
F | 0 | 2 | 0 | 0 |  | 3.5
G | 0 | 0 | 1.8 | 3 |  | 1.8
H
I
J
K
L
M
N
O
Total Day %
Spreadsheet: 810477d1671798836-auto-formulas-from-one-sheet-to-another-formula-help
Sheet: Stammdaten

Abrechnungs Monat |  | 44866 |  |  |  | KZ
[NAME] |  | 22:00:00 | 05:00:00 |  |  | A
Tarifstundenlohn |  | 11.55 |  |  |  | F
Preis pro MiniBar |  | 0.1 |  |  |  | K
Preis pro [NAME] |  | 0.9 |  |  |  | U
 |  |  |  |  |  | PT
 |  |  |  |  |  | Q
 |  |  |  |  |  | FT
Extra Stunden Preis
Checker Stunden Preis
Objektleiter Paushal |  | 3093
Spreadsheet: 706304d1606605581-need-help-please-in-distributing-a-number-across-a-date-in-multiple-cells-match-value-by-date-therese0711-
Sheet: Actual Data 1

DATE | Order_date |  | [NAME]
 | 20200901 | 587
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200902 | 869
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200903 | 741
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200904 | 536
 | 20200904
 | 20200904
 | 20200904
 | 20200904
 | 20200904
 | 20200904
 | 20200904
 | 20200904
 | 20200904
 | 20200904
 | 20200904
Spreadsheet: 843086d1695050355-use-drop-down-list-value-to-change-row-values-else-where-on-sheet-welchs101-jr_sr_excel_forum_question
Sheet: JR SR

Info
Name | Hauser Inc
Group | SR
Date | 2023-08-10 00:00:00
Time | 16:00 PM
 | [NAME], [NAME]
 | [NAME], [NAME], [NAME]
Comment
Project Timelines
Timelines | Date | Comments
ABCD | 2018-01-01 00:00:00
GRE | 2024-04-15 00:00:00
FPU | 2024-07-15 00:00:00
GHY | 2024-09-15 00:00:00
ID | Number
ID123456 | 123456
Spreadsheet: e273e060-ae23-485e-9f03-993cd04f3c6e
Sheet: Sheet1

Unnamed: 0 | Checkout Application Setup Form | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | AGENCY INFORMATION - To Be completed By Agency
 |  | Agency Name:
 |  | Address: |  | Suite:
 |  | City, State, Zip:
 |  | Project Contact Name: |  | Project Contact Phone:
 |  | Project Contact Email:
 |  | Financial Contact: |  | Financial contact phone:
 |  | Technical Contact: |  | Technical Contact Phone:
 |  | Technical Contact Email:
 |  | Back to Home/Agency Home URL: | https://test.colorado.gov/apps/payport
 |  | Back to Start/Application Start Page: | https://test.colorado.gov/apps/payport
 |  | Support Email Address: | [EMAIL]
 |  | Checkout Template:
 |  | Custom Template URL:
 |  | Redirect on Cancel URL:
 |  | Application Redirect?:
 |  | Order Timeout | 20 | (In Minutes)
 |  | Disbursement Accnt#: |  | Disbursement Routing #:
 | APPLICATION INFORMATION - To Be Completed By Project Manager and Agency
 |  | Application Name:
 |  | Application Description: | Over-the-counter payment processing application
 |  | [NAME]? | No
 |  | [NAME]?
 |  | Payment Types Accepted:
 |  | NOTES - To Be Completed By Project Manager and Agency
 |  | Your Transaction is Complete' Text:
 |  | Special Languange - This Language is standard language that does not change
 |  | This online service includes a portal administration fee that allows Colorado.gov to deliver this and other important services. This fee is paid to a third party that provides these services for Colorado.gov and thus is not considered revenue for the State of Colorado. If you do not wish to pay this transaction fee, you have the choice to pay by traditional means. Online payment is an alternative to traditional types of payments and is considered voluntary. We appreciate your support of Colorado.gov. So that you can receive an email confirmation of this transaction, please add mailto:[EMAIL] to your list of approved senders.
 |  | Enter Text in this box that accompanies the Language above:
 | ITEM SKU AND FEE CALCULATIONS - To Be Completed By Project Manager
 |  | SKU | Description | Calculation | Calculated by Checkout?
 | PAYMENT PROCESSING INFORMATION - To Be Completed by CI Administration
 |  | CMBS Code Abbreviation: |  | (Subscription Only)
 |  | TPE Code Abbreviation: |  | (Subscription Only)
 |  | TPE Merchant ID:
 |  | TPE Merchant Key: |  | Merchant Name: | Colo Online Service
 |  | TPE CC Code:
 |  | TPE  eCheck Code:
Spreadsheet: 844729d1696427390-reporting-data-from-a-table-query-helpme
Sheet: rawnum

ShopOrder | Emp | Sample | SampleSize | 1.1 | 1.2 | 2.1 | 2.2 | 3 | 4 | 5.1 | 5.2 | 5.3 | 5.4
1 | 321 | 1 | 13 | 0.1189 | 0.1178 | 0.04726 | 0.04877 | 0.19464 | 0.09422 | 0.12358 | 0.12362 | 0.12209 | 0.12177
1 | 321 | 2 | 13 | 0.1191 | 0.1176 | 0.0471 | 0.04913 | 0.19465 | 0.0948 | 0.12377 | 0.12381 | 0.12192 | 0.12159 |  | This sheet is converted to numbers
1 | 321 | 3 | 13 | 0.11863 | 0.11799 | 0.0461 | 0.04919 | 0.19463 | 0.09477 | 0.12336 | 0.12337 | 0.12227 | 0.12195
1 | 321 | 4 | 13 | 0.11921 | 0.11742 | 0.04678 | 0.05063 | 0.19457 | 0.0946 | 0.12389 | 0.1239 | 0.12173 | 0.12141
2 | 123 | 1 | 4 | 0.11889 | 0.1177 | 0.05544 | 0.05064 | 0.19461 | 0.09605 | 0.12358 | 0.12361 | 0.12199 | 0.12167
2 | 123 | 2 | 4 | 0.11856 | 0.11797 | 0.04673 | 0.05064 | 0.19458 | 0.0946 | 0.12327 | 0.1233 | 0.12225 | 0.12192
2 | 123 | 3 | 4 | 0.11875 | 0.11782 | 0.04776 | 0.04961 | 0.19455 | 0.09498 | 0.12345 | 0.12347 | 0.1221 | 0.12178
2 | 123 | 4 | 4 | 0.11901 | 0.11762 | 0.0476 | 0.05041 | 0.19457 | 0.09526 | 0.12372 | 0.12373 | 0.12191 | 0.12158
Spreadsheet: 144889d1331192865-about-column-chart-change
Sheet: Sheet1

data | [NAME] | frquency | %
0.4747765192177438 | 0.1
0.2368296949413358 | 0.2 | 3
0.8029807100895727 | 0.3 | 1
0.4586084257227299 | 0.4 | 0
0.5260953931122121 | 0.5 | 7
0.122167220516036 | 0.6 | 2
0.4701451170543325 | 0.7 | 1
0.940842112000909 | 0.8 | 2
0.4702137045887462 | 0.9 | 3
0.4752698020103026 | 1 | 1
0.1661522285227299
0.728783673306717
0.4087543367812358
0.8115954071871174
0.8594223761163091
0.6519699014015607
0.4002621682814311
0.7215366767367675
0.5939157954989271
0.1741168973511673