tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 739665d1625847251-extracting-overlapping-date-ranges-sample-46-ans
Sheet: page 1

Pers.no. | Name Last Name | Start | End | Company
310 | [NAME] | 2015-07-01 00:00:00 | 2015-10-31 00:00:00 | Johnson &Johnson
310 | [NAME] | 2015-11-01 00:00:00 | 2015-12-31 00:00:00 | Johnson &Johnson
310 | [NAME] | 2016-01-01 00:00:00 | 2020-05-01 00:00:00 | A Tech
310 | [NAME] | 2016-02-01 00:00:00 | 2017-07-31 00:00:00 | A Tech
310 | [NAME] | 2017-08-01 00:00:00 | 2017-10-31 00:00:00 | A Tech
310 | [NAME] | 2017-11-01 00:00:00 | 2018-12-31 00:00:00 | A Tech
310 | [NAME] | 2019-01-01 00:00:00 | 2020-11-30 00:00:00 | A Tech
310 | [NAME] | 2020-12-01 00:00:00 | 2020-12-31 00:00:00 | A Tech | ?
310 | [NAME] | 2021-01-01 00:00:00 | 9999-12-31 00:00:00 | A Tech | ?
313 | [NAME] | 2015-07-01 00:00:00 | 2016-12-31 00:00:00 | B Tech
313 | [NAME] | 2016-01-01 00:00:00 | 2016-01-31 00:00:00 | B Tech
313 | [NAME] | 2016-02-01 00:00:00 | 2016-03-31 00:00:00 | B Tech
313 | [NAME] | 2016-04-01 00:00:00 | 2016-09-30 00:00:00 | B Tech
313 | [NAME] | 2016-10-01 00:00:00 | 2017-01-31 00:00:00 | C Tech
313 | [NAME] | 2017-02-01 00:00:00 | 2017-08-01 00:00:00 | C Tech
313 | [NAME] | 2017-07-01 00:00:00 | 2020-12-31 00:00:00 | C Tech
313 | [NAME] | 2021-01-01 00:00:00 | 9999-12-31 00:00:00 | C Tech
318 | PETE PACKETT | 2015-07-01 00:00:00 | 2015-12-31 00:00:00 | D Tech
318 | PETE PACKETT | 2016-01-01 00:00:00 | 2016-01-31 00:00:00 | D Tech
318 | PETE PACKETT | 2017-02-01 00:00:00 | 2017-01-31 00:00:00 | D Tech | ? | start<end
318 | PETE PACKETT | 2017-02-01 00:00:00 | 2017-04-30 00:00:00 | D Tech | ?
318 | PETE PACKETT | 2017-05-01 00:00:00 | 2017-06-30 00:00:00 | D Tech
318 | PETE PACKETT | 2017-07-01 00:00:00 | 2017-09-30 00:00:00 | D Tech
318 | PETE PACKETT | 2017-10-01 00:00:00 | 2020-06-30 00:00:00 | D Tech
318 | PETE PACKETT | 2020-07-01 00:00:00 | 9999-12-31 00:00:00 | D Tech
Spreadsheet: 116759d1312122715-transfering-data-from-one-sheet-to-another-change-format-of-ebay-sales
Sheet: Sheet1

# | desc | price | shipping | total | sold | shipping | total | profit
Spreadsheet: 842974d1694957588-blood-pressure-chart-help-please-test-2-
Sheet: Sheet1

Date | Morning |  | Afternoon |  | Night |  | Show values for UP TO XX days | 6 |  |  |  |  |  |  |  |  |  |  |  | Morning |  | Afternoon |  | Night
 | Sys | [NAME] | Sys | [NAME] | Sys | [NAME] | going BACKWARD from | 2023-09-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Sys | [NAME] | Sys | [NAME] | Sys | [NAME]
2023-09-07 00:00:00 | 170 | 92 | 148 | 84 | 180 | 71 |  |  |  |  |  |  |  |  |  |  |  |  |  | 179 | 85 | 136 | 73 | 147 | 73
2023-09-08 00:00:00 | 152 | 73 | 132 | 72 | 158 | 70 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-09-09 00:00:00 | 127 | 84 | 182 | 100 | 161 | 92
2023-09-09 00:00:00 | 127 | 84 | 182 | 100 | 161 | 92 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-09-08 00:00:00 | 152 | 73 | 132 | 72 | 158 | 70
2023-09-10 00:00:00 | 179 | 85 | 136 | 73 | 147 | 73 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-09-07 00:00:00 | 170 | 92 | 148 | 84 | 180 | 71
2023-09-11 00:00:00 | 162 | 86 | 161 | 87 | 183 | 73
2023-09-12 00:00:00 | 161 | 76 | 134 | 83 | 120 | 96
2023-09-13 00:00:00 | 135 | 83 | 172 | 79 | 188 | 79
2023-09-14 00:00:00 | 186 | 75 | 186 | 93 | 156 | 90
2023-09-15 00:00:00 | 137 | 97 | 182 | 100 | 170 | 77
Spreadsheet: 132742d1323899242-pulling-top-10-to-a-new-sheet-top-10
Sheet: Pivot

Top 10 by Sales |  |  | Top 10 by Cost |  |  | Top 10 by # of Units |  |  | Top 10 by Margin |  |  | Top 10 by Margin
Supplier | Sum of Sales |  | Supplier | Sum of Cost |  | Supplier | Sum of # of Units |  | Supplier | Sum of Margin |  | Supplier | Sum of % Margin
UNI010 | 5457543 |  | BAC028 | 5747317.680000002 |  | BAC028 | 96753 |  | BAC028 | 1990981.32 |  | GIO073 | 0.3023474651646892
JIM019 | 6489411 |  | DFC003 | 17259269.54 |  | DFC003 | 105266 |  | GIO073 | 2432558.299999999 |  | MOE053 | 0.4366376240885789
BAC028 | 7738299 |  | GIO073 | 5613013.7 |  | EST001 | 199910 |  | GIO076 | 1159319.43 |  | MOE072 | 0.2956661525113276
GIO073 | 8045572 |  | GIO076 | 9116727.620000001 |  | GIO073 | 314571 |  | JIM019 | 1461112.48 |  | PAR020 | 0.4185089516680611
REM016 | 8359482 |  | JIM019 | 5028298.52 |  | GIO074 | 116548 |  | PAR020 | 7049831.750000003 |  | PAR370 | 0.3467070058207427
GIO076 | 10276047.05 |  | PAR020 | 9795284.04 |  | GIO076 | 155483 |  | PAR370 | 1172937.090000001 |  | PAR380 | 0.3651506342575625
UNI015 | 10927095 |  | PER014 | 4541641.070000002 |  | LAN094 | 203087 |  | REM016 | 1708530.82 |  | UNI010 | 0.3233811680457671
PAR020 | 16845115.79 |  | REM016 | 6650951.179999999 |  | PAR020 | 539095 |  | Total | 34178300.83000003 |  | UNI015 | 0.3420642604461663
DFC003 | 18245311 |  | Total | 118567945.14 |  | Total | 3499094 |  | UNI010 | 1764866.63 |  | UNI018 | 0.5809445623053159
Total | 152746245.97 |  | UNI015 | 7189326.329999998 |  | VSB101 | 539741 |  | UNI015 | 3737768.670000001 |  | UNI036 | 0.4812632516719693
Grand Total | 245130121.81 |  | Grand Total | 189509774.82 |  | Grand Total | 5769548 |  | Grand Total | 56656207.32000003 |  | Grand Total | 3.89267107598018
Spreadsheet: 104123d1301764793-multiple-if-test-table
Sheet: Sheet2

 | 0 | 6 | 12 | 15
820 | 536.78 | 74.3 | 64.78 | 56
830 | 485.73 | 66.47 | 53.14 | 48.78
840 | 485.73 | 66.47 | 53.14 | 48.78
860 | 999 | 100 | 90 | 80
870 | 999 | 100 | 90 | 80
880 | 999 | 100 | 90 | 80
890 | 536.78 | 74.3 | 64.78 | 56
Spreadsheet: 63345d1264252259-random-number-unique-rand-and-solver
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | your 10 numbers
5 | 7 | 1 | 10 | 6 | 3 | 8 | 9 | 4 | 2 | unique random sort from macro
5 | 0 |  |  |  |  |  | click to sort randomly
7 | 1 |  |  |  |  |  |  |  |  |  | macro is called rand sort use F11 to open the vba editor
1 | 1 |  |  |  |  |  |  |  |  |  | and then look at module 1
10 | 1
 | 18 | formula in b9 is [NAME]:A8,B5:B8)
a5 to a8 are simply the first 4 rand sorted numbers
 | select solver from
 | tools solver and set it up like this
 | type in the target value eg 18
 | the constraints are set by clicking add
 | wken solver is run
 | [NAME]:b8 will change if it finds a result
 | those numbers with ones against
 | them will be your answer
Spreadsheet: 697243d1601282966-count-all-occurences-of-text-in-column-d-based-on-the-text-in-column-a-example-1
Sheet: Sheet1

Column A | Column B | Column C | Column D |  | Dog
Dog | 23 | A | Completed
Cat | 34 | B | Completed
Rat | 23 | C | Completed
Dog | 12 | D | Not Completed
Dog | 54 | E | Completed
Cat | 23 | F | Not Completed
Dog | 45 | G | Not Completed
Spreadsheet: 197842d1354572216-drop-down-menu-depending-on-another-drop-down-copy-of-material
Sheet: Products

PRODUCTS | Formula 1 | Formula 2
 |  |  |  |  |  | HYFOL 14 | 110359P
 |  |  |  |  |  | HYFOL 14 | 165679-U
 |  |  |  |  |  | HYFOL 14 | 155011-U
 |  |  |  |  |  | HYFOL 14 | 131653-U
 |  |  |  |  |  | HYFOL 14 | PLA0050133
 |  |  |  |  |  | HYFOL 14US | PEA0050915
 |  |  |  |  |  | HYFOL 14US | [NAME]
 |  |  |  |  |  | HYFOL 14US | NA 960-000
 |  |  |  |  |  | HYFOL 14US | 10919
 |  |  |  |  |  | HYFOL 14US | 100691-U
Spreadsheet: sara_shackleton__36834__Enron_Final_Version
Sheet: Power Swap Final

Transact | Counterparty | TradeDate | B/S | Beg Time | End Time | Volume Rate | Block | Location | Price
107394 | ENRO | Aug 28 2000 12:00AM | BUY | 2003-12-01 00:00:00 | 2004-01-01 00:00:00 | 50 | 5x16 | NYIS/ZONE J | 43.31401
107831 | ENRO | Sep  6 2000 12:00AM | BUY | 2005-12-01 00:00:00 | 2006-01-01 00:00:00 | 100 | 5x16 | NYIS/ZONE J | 38.19508
113089 | ENRO | Dec  4 2000 12:00AM | SELL | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 50 | 5x16 | NYIS/ZONE A | 81
114324 | ENRO | Jan  5 2001 12:00AM | SELL | 2001-12-01 00:00:00 | 2002-01-01 00:00:00 | 50 | 5x16 | NYIS/ZONE J | 57.5
115036 | ENRO | Jan 22 2001  4:20PM | SELL | 2001-12-01 00:00:00 | 2002-01-01 00:00:00 | 50 | 5x16 | NYIS/ZONE J | 57.5
116032 | ENRO | Feb  5 2001  3:57PM | BUY | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 50 | 5x16 | NYIS/ZONE J | 126
116207 | ENRO | Feb  6 2001  4:53PM | BUY | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 50 | 5x16 | NYIS/ZONE J | 126
116429 | ENRO | Feb  8 2001  5:11PM | BUY | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 50 | 5x16 | NYIS/ZONE A | 80
116431 | ENRO | Feb  8 2001 12:00AM | BUY | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 50 | 5x16 | NYIS/ZONE J | 126
117292 | ENRO | Feb 26 2001  6:10PM | BUY | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 50 | 5x16 | NYIS/ZONE A | 73
117293 | ENRO | Feb 26 2001 12:00AM | BUY | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 50 | 5x16 | NYIS/ZONE A | 73
117296 | ENRO | Feb 27 2001 12:00AM | BUY | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 50 | 5x16 | NYIS/ZONE J | 126
117795 | ENRO | Mar  6 2001  6:21PM | SELL | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 50 | 5x16 | NYIS/ZONE J | 84.75
Spreadsheet: 706963d1606982903-textjoin-product-names-which-falls-in-the-same-category-textjoin-on-category
Sheet: Sheet1

name 1 | category1 |  | category1
name 2 | category1 |  | category 2
name 3 | category 2
name 4 | category 2
name 5 | category 2
ID | Type | Attribute | Attribute value | Parent
H3515112V | variable | Color | Red, Black
H3515112 | variation | Color | Red | H3515112V
H3515111 | variation | Color | Black | H3515112V
H3525224V | variable | Color | White, Blue
H3525224 | variation | Color | White | H3525224V
H3525225 | variation | Color | Blue | H3525224V
I2500197V | variable | Color | Green, Blue, Pink, Red
I2500197 | variation | Color | Green | I2500197V
I2500198 | variation | Color | Blue | I2500197V
[NAME] | variation | Color | Pink | I2500197V
I2500199 | variation | Color | Red | I2500197V
H3515175V | variable | Color | Red, Blue, Black
H3515175 | variation | Color | Red | H3515175V
H3515174 | variation | Color | Blue | H3515175V
H3515173 | variation | Color | Black | H3515175V
Spreadsheet: 218422d1362453801-scoring-varying-percentages-if_naja_ver1
Sheet: Sheet1

Number | Score | Score Base on Database |  |  |  | Data Base
7 |  |  |  |  |  | 9 | 0
12 |  |  |  |  |  | 10 | 1
30 |  |  |  |  |  | 25 | 2
55 |  |  |  |  |  | 50 | 3
80 |  |  |  |  |  | 70 | 4
93 |  |  |  |  |  | 90 | 5
100
Spreadsheet: 5cf7d403-bf27-41a0-add6-3626d876a4ed
Sheet: Parkers

NAME | CONTACT | Car Details | Notes
[NAME] | [PHONE] | Black Toyota Corolla | Paid till July 30th, Not Renewing
[NAME] | [PHONE] [EMAIL] [PHONE] | [NAME] Toyota Corolla | monthly parker, pays at beginning of the month
[NAME] | [PHONE] [EMAIL] | Khaki Jeep Liberty (year 2003) Black Range Rover (year 2006) Licence plate no. BKBT 223 Licence plate no: BLLB 107 | Pays on the 15th of each month $75)
[NAME] | [PHONE] | Black Alero | Prepaid checks for Summer
Rachel | [EMAIL] | wants spot starting August 1st | pays on the 1st of each month $75
 | June | July | August | September | October | November | December
[NAME] | 75 | 75 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 70 | 75 | 0 | 0 | 0 | 0
[NAME] | 0 | 75 | 75 | 75 | 75 | 75 | 75
[NAME] | 75 | 75 | 75 | 0 | 0 | 0 | 0
Uncashed checks | 0 | 0 | 0 | 150
Spreadsheet: 267299d1380037643-if-formula-to-sort-data-issue_management_template
Sheet: Issues_Tracking_Log

UNIT MANAGEMENT LOG |  |  |  |  |  |  |  | ISSUE MANAGEMENT LOG
Project Name: |  |  | <optional> |  |  |  |  | Project Name: | <optional>
National Center: |  |  | <required> |  |  |  |  | National Center: | <required>
Project Manager Name: |  |  | <required> |  |  |  |  | Project Manager Name: | <required>
Project Description: |  |  | <required> |  |  |  |  | Project Description: | <required>
ID | Current Status | Priority | Issue Description | Assigned To Owner | Expected Resolution Date | Escalation Required (Y/N)? | Impact Summary | Action Steps | Issue Type | Date Identified | Assoc ID | Entered By | Actual Resolution Date | Final Resolution & Rationale
 | Open | Critical | EXAMPLE: Issues raised by board members about the financial viability of the project are preventing the project from moving forward as planned. |  |  | Yes | EXAMPLE: Potential project stoppage | EXAMPLE: Meet with board members to clarify the project finances | Informational | 2006-01-01 00:00:00 |  | [NAME] |  | EXAMPLE: The project team met with board members to clarify the project finances, allowing the project to move forward as planned.
 | Work In Progress | High | EXAMPLE: The project is short on a specific skill set. |  |  | No | EXAMPLE: Possibility of project work not completed on time | EXAMPLE: Add staff to fill the skills gap. | Procedural | 2006-01-01 00:00:00 |  | [NAME] |  | EXAMPLE: Staff was added to the project to fill the skills gap.
 | Closed | Medium | EXAMPLE: Negotiations with functional managers in an organization competing for scarce human resources are forecasted to delay project completion. |  |  | Yes | EXAMPLE: Possability of project work not completed on time | EXAMPLE: Additional negotiation | System | 2006-01-01 00:00:00 |  | [NAME] |  | EXAMPLE: Negotiations ended satisfactorily before they caused project delays.
 |  | Low |  |  |  |  |  |  | Other
Spreadsheet: 551672d1513087154-modify-search-results-based-on-text-in-another-cell-eod
Sheet: Sheet9

 | AREA | JOB |  | SPV | TYPE |  | NEED
 | OTTAWA HAMILTON EOD SPV | LETTER CARRIER PART TIME |  |  |  |  |  |  | WANT EOD IN COL F ONLY IF SPV IN COL E
 | OTTAWA HAMILTON EOD SPV | LETTER CARRIER PART TIME
 | OTTAWA HAMILTON EOD SPV | LETTER CARRIER PART TIME
 | OTTAWA HAMILTON EOD SPV | LETTER CARRIER PART TIME
 | OTTAWA HAMILTON EOD SPV | SPV LETTER CARRIER |  |  |  |  | SPV | EOD
 | OTTAWA HAMILTON EOD SPV | LETTER CARRIER
 | OTTAWA HAMILTON EOD SPV | LETTER CARRIER
 | OTTAWA HAMILTON EOD SPV | LETTER CARRIER
 | OTTAWA HAMILTON EOD SPV | LETTER CARRIER
Spreadsheet: 01227b17-1e9e-4efd-9c66-28acf78e1618
Sheet: FALL TEAM TENNIS RESULTS

 | SAISD FALL TEAM TENNIS RESULTS
 | SCHOOL |  |  | SCHOOL |  | DATE:
 |  | VS. |  |  |  | VAR:
 |  |  |  |  |  | J.V.
 | BOYS SINGLES: |  |  |  | SET SCORES |  |  | WINNER | WINNER
1 |  | VS. | 1
2 |  | VS. | 2
3 |  | VS. | 3
4 |  | VS. | 4
5 |  | VS. | 5
6 |  | VS. | 6
 | GIRLS SINGLES:
1 |  | VS. | 1
2 |  | VS. | 2
3 |  | VS. | 3
4 |  | VS. | 4
5 |  | VS. | 5
6 |  | VS. | 6
 | BOYS DOUBLES:
1 |  | VS. | 1
& |  |  | &
2 |  | VS. | 2
& |  |  | &
3 |  | VS. | 3
& |  |  | &
 | GIRLS DOUBLES:
1 |  | VS. | 1
& |  |  | &
2 |  | VS. | 2
& |  |  | &
3 |  | VS. | 3
& |  |  | &
 | MIXED DOUBLES:
1 |  | VS. | 1
& |  |  | &
 | WINNER: |  |  |  |  | SCORE:
Spreadsheet: 864223d1711473603-finding-the-difference-between-two-dates-with-time-and-showing-negative-numbers-video-time-master-with-password
Sheet: Master Video Page

 | EXAMPLE
 | Video Time | Actual Time |  |  |  |  | OUTPUT TO COPY EXAMPLE
 | Date and time [NAME] dd/mm/yy hh:[NAME]:ss AM/PM | Date and time [NAME] dd/mm/yy hh:[NAME]:ss AM/PM |  |  |  |  |  |  |  |  |  | signed difference in days | new date/time (using NOW() as placeholder) | new date/time+difference
 | 2022-10-20 22:03:00 | 2022-10-21 00:15:12 | Video is
 | 2022-10-21 00:15:15 | 2022-10-20 22:03:02 | Video is
 | 2022-10-21 00:15:00 | 2022-10-17 17:03:15 | Video is
 | PUT YOUR DATA BELOW (FOLLOW THE FORMAT IN BLUE )
 | Video Time | Actual Time | Total |  |  |  | COPY BELOW WITH CTRL + C  AND PASTE IN YOUR REPORT | I want to data from Column H to read as a plain text so I can convert it all into seconds. Currently I have to paste special to get the info here and I want it to automatically be a text format | Here is the converted infor off of Column I into seconds, This formula is off by a little | This column makes it negative or positive based on column I being negative or positive
 | Date and time [NAME] dd/mm/yy hh:[NAME]:ss AM/PM | Date and time [NAME] dd/mm/yy hh:[NAME]:ss AM/PM |  |  |  |  |  |  |  |  |  | signed difference in days | new date/time (using NOW() as placeholder) | new date/time+difference
Video 1 | 2022-10-21 00:15:15 | 2022-10-20 22:03:02 | Video is |  |  |  |  | <---------------Paste Special of Column H Below is what hap[pens when I manually paste Special
Video 2 | 2022-10-20 22:03:00 | 2022-10-21 00:15:12 | Video is |  |  |  |  | Video is + 0 days 2 hours 12 minutes 12 seconds Slower than Actual Time
Video 3 |  |  | Video is
Video 4 |  |  | Video is
Video 5 |  |  | Video is
Video 6 |  |  | Video is
Video 7 |  |  | Video is
Video 8 |  |  | Video is
Video 9 |  |  | Video is
Video 10 |  |  | Video is
Video 11 |  |  | Video is
Video 12 |  |  | Video is
Video 13 |  |  | Video is
Video 14 |  |  | Video is
Video 15 |  |  | Video is
Video 16 |  |  | Video is
Video 17 |  |  | Video is
Video 18 |  |  | Video is
Video 19 |  |  | Video is
Video 20 |  |  | Video is
Video 21 |  |  | Video is
Video 22 |  |  | Video is
Video 23 |  |  | Video is
Video 24 |  |  | Video is
Video 25 |  |  | Video is
Video 26 |  |  | Video is
Spreadsheet: 857644d1706615944-xlookup-accross-and-down-test-file-targets
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00
 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | Aug | Sep | Oct | Nov | Dec |  |  |  | Location 1
Location 1 | 817991 | 57259.37 | 63273.99955474333 | 85080.60313920406 | 64621.289 | 67776.41002197408 | 84253.07299999999 | 73619.19 | 69536.2447044206 | 86052.6532 | 52024.22760000001 | 58895.352 |  |  |  | Location 2
Location 2 | 344747 | 24132.29 | 26667.19013350892 | 35857.70832494634 | 27235.013 | 28564.75685654915 | 35508.941 | 31027.23 | 29306.44928014476 | 36267.3844 | 21925.9092 | 24821.784 |  |  |  | Location 3
Location 3 | 465000 | 32550 | 35969.11187648232 | 48365.4226754694 | 36735 | 38528.57874991038 | 47895 | 41850 | 39528.98477801783 | 48918 | 29574 | 33480
Spreadsheet: chris_germany__1781__October Set-up
Sheet: TCO

VNG October Nomination
TCO Requirements
Zone | Entitlement | [NAME] | Applicable Index | Available for Spot Purchase | ENA Spot Daily Purchase | Applicable Index | Available for Release | Released to End Users | Available for Release
Lebanon | 5000 | 0 |  |  | 0 |  |  | 0
Cobb/TGP Zone 0 | 1315.5 | 0 |  |  | 0 |  |  | 0
Cobb/TGP Zone 0 | 1315.5 | 0 |  |  | 0 |  |  | 0
Cobb | 0 | 0 |  |  | 0 |  |  | 0
Col Gulf | 50339 | 29652 |  |  | 12554 |  |  | 3100
Total:
Spreadsheet: 137489d1327156669-tranpose-transpose-to-right
Sheet: OUTPUT

SOURCE NAME | TARGET 1 | TARGET 2 | TARGET 3 | TARGET 4 | TARGET 5 | TARGET 6 | TARGET 7 | TARGET 8 | TARGET 9 | TARGET 10 | TARGET 11 | TARGET 12 | TARGET 13 | TARGET 14 | TARGET 15 | TARGET 16 | TARGET 17 | TARGET 18 | TARGET 19 | TARGET 20 | TARGET 21 | TARGET 22 | TARGET 23 | TARGET 24 | TARGET 25 | TARGET 26 | TARGET 27 | TARGET 28 | TARGET 29 | TARGET 30 | TARGET 31
ENNDANANDNGR1
ENNDANANDNGR2
ENNDANANDNGR3
ENNDBAPANA1
ENNDBAPANA2
Spreadsheet: 31775d1227722568-excel-2007-adding-function-serenity-character-sheet
Sheet: Template

Serenity Character Sheet
Name: |  |  |  |  | Age: |  | Height: |  | Weight: |  | Eye Colour: |  | Hair Colour:
Level: | Greenhorn
 |  |  |  |  |  | Skills |  | Total Points Spent:
Attributes |  | Life Points
Agility |  | [NAME] |  | 0
Strength |  | [NAME] |  | 0
Vitality |  | Initiative
Alertness |  | Plot Points |  | 6
Intelligence |  | Advancement Points |  | 0
Willpower
Points Spent:
This includes points from Assets/Complications
Assets |  |  |  |  | Type |  | Effects |  |  | Details
Complications |  |  |  |  | Type |  | Effects |  |  | Details
Gear: |  |  |  |  | Price | Put Price of One unit. |  |  |  |  | Price |  |  |  |  |  | Price
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Input money obtained:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Credits:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dollars:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Platinum:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gold:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Silver:
Total Made | Credits | 750 | Dollars | 0 | Platinum | 0 | Gold | 0 | Silver | 0 |  | On-Hand | Credits |  | Dollars |  | Platinum |  | Gold |  | Silver
Total Spent | Credits |  | Dollars | 0 | Platinum | 0 | Gold | 0 | Silver | 0
Spreadsheet: 748938d1632419845-peaks-and-troughs-peaks-and-troughs
Sheet: Sheet1

 |  |  | Post WW2 Peak | Post WW2 Peak | Perf Since Peak | Trough Since Peak
08/31/1945 | 15.51
[NAME] | 15.51
09/04/1945 | 15.51
09/05/1945 | 15.53
09/06/1945 | 15.74
09/07/1945 | 15.73
09/10/1945 | 15.78
09/11/1945 | 15.88
09/12/1945 | 15.95
09/13/1945 | 15.95
09/14/1945 | 15.86
09/17/1945 | 15.51
09/18/1945 | 15.82
09/19/1945 | 15.97
09/20/1945 | 16.03
09/21/1945 | 15.95
09/24/1945 | 15.91
[NAME] | 15.93
09/26/1945 | 15.92
09/27/1945 | 15.86
09/28/1945 | 16.05
10/01/1945 | 16.33
10/02/1945 | 16.33
10/03/1945 | 16.3
10/04/1945 | 16.3
10/05/1945 | 16.38
10/08/1945 | 16.5
10/09/1945 | 16.54
10/10/1945 | 16.6
10/11/1945 | 16.58
10/12/1945 | 16.58
10/15/1945 | 16.59
10/16/1945 | 16.59
10/17/1945 | 16.66
10/18/1945 | 16.72
10/19/1945 | 16.59
10/22/1945 | 16.71
10/23/1945 | 16.58
[NAME] | 16.33
10/25/1945 | 16.41
10/26/1945 | 16.49
10/29/1945 | 16.36
10/30/1945 | 16.38
10/31/1945 | 16.65
11/01/1945 | 16.87
Spreadsheet: 83910d1283949380-selecting-two-colums-of-info-on-one-sheet-from-another-sheet1
Sheet: per day (should look like)

Date | Total per Day | A | B | C | D
2010-09-01 00:00:00 | 20 | 16 | 4 | 0 | 0
2010-09-02 00:00:00 | 16 | 3 | 3 | 10 | 0
2010-09-03 00:00:00 | 6 | 5 | 1 | 0 | 0
2010-09-04 00:00:00 | 1 | 0 | 0 | 0 | 1
2010-09-05 00:00:00 | 0 | 0 | 0 | 0 | 0
2010-09-06 00:00:00 | 0 | 0 | 0 | 0 | 0
2010-09-07 00:00:00 | 3 | 0 | 0 | 3 | 0
2010-09-08 00:00:00 | 0 | 0 | 0 | 0 | 0
2010-09-09 00:00:00 | 0 | 0 | 0 | 0 | 0
2010-09-10 00:00:00 | 0 | 0 | 0 | 0 | 0
2010-09-11 00:00:00 | 0 | 0 | 0 | 0 | 0
2010-09-12 00:00:00 | 0 | 0 | 0 | 0 | 0
2010-09-13 00:00:00 | 0 | 0 | 0 | 0 | 0
2010-09-14 00:00:00 | 0 | 0 | 0 | 0 | 0
2010-09-15 00:00:00 | 0 | 0 | 0 | 0 | 0
2010-09-16 00:00:00 | 0 | 0 | 0 | 0 | 0
2010-09-17 00:00:00 | 0 | 0 | 0 | 0 | 0
2010-09-18 00:00:00 | 0 | 0 | 0 | 0 | 0
2010-09-19 00:00:00 | 0 | 0 | 0 | 0 | 0
2010-09-20 00:00:00 | 0 | 0 | 0 | 0 | 0
2010-09-21 00:00:00 | 0 | 0 | 0 | 0 | 0
2010-09-22 00:00:00 | 0 | 0 | 0 | 0 | 0
2010-09-23 00:00:00 | 0 | 0 | 0 | 0 | 0
2010-09-24 00:00:00 | 0 | 0 | 0 | 0 | 0
2010-09-25 00:00:00 | 0 | 0 | 0 | 0 | 0
2010-09-26 00:00:00 | 0 | 0 | 0 | 0 | 0
2010-09-27 00:00:00 | 0 | 0 | 0 | 0 | 0
2010-09-28 00:00:00 | 0 | 0 | 0 | 0 | 0
2010-09-29 00:00:00 | 0 | 0 | 0 | 0 | 0
2010-09-30 00:00:00 | 0 | 0 | 0 | 0 | 0
 | 46 | 24 | 8 | 13 | 1
Spreadsheet: 757824d1638465322-remove-cells-with-same-words-but-different-order-test-file
Sheet: Sheet1

Query
carpet green red |  | carpet green red
red carpet |  | red carpet |  |  |  | green
green carpet best red |  | green carpet best red |  |  |  | red
red carpet green |  | yellow black carpet pink |  |  |  | best
yellow black carpet pink |  | black green carpet |  |  |  | yellow
black green carpet |  | best blue floor |  |  |  | black
best green red carpet |  | Green free carpet |  |  |  | pink
best blue floor |  |  |  |  |  | blue
Green free carpet |  |  |  |  |  | floor
best green carpet red |  |  |  |  |  | free
I want this column to look like… |  | …this
In my original file the colors doesn't exist, they are just placed here to present my case more easily
Spreadsheet: 879238d1726680863-create-a-separate-workbook-that-holds-a-live-copy-of-one-sheet-shooting-team-record-dummy
Sheet: Scores

 | Pupil | Date | Practice Type | [NAME] | Score | % | Comment | Team | Date Enrolled | Prejoining Experience |  | Do NOT filter this table. This is for scores entry ONLY. Use the analysis tab instead.
 | Doe, [NAME] | 2024-09-18 00:00:00 | Competition Shoot | 25 | 10 |  | Bit rusty
 | Doe, [NAME] | 2024-09-18 00:00:00 | Competition Shoot | 25 | 10
 | [NAME], [NAME] | 2024-09-18 00:00:00 | Trial | 50 | 10 |  | Not of required standard
 | [NAME], [NAME] | 2024-09-18 00:00:00 | Competition Shoot | 20 | 0
 | Total
Spreadsheet: 790791d1659994217-drawing-correct-number-from-drop-down-box-excel-example
Sheet: Sheet2

 |  | [NAME] |  | Drop down box
 |  |  | 1 | 2 | 3 | 4 | 5 | 6
 |  | Growth |  |  |  |  |  |  | equals number from list below corrosponding to heading selected
 |  |  | 1 | 2 | 3 | 4 | 5 | 6
 |  |  | Canterbury/Westcoast
 |  |  | 0.2 | 1 | 2 | 5 | 15 | 31
 |  |  | Southland
 |  |  | 0.2 | 1 | 3 | 14 | 35 | 65
 |  |  | Otago
 |  |  | 0.3 | 2 | 5 | 9 | 26 | 49
 |  |  | [NAME]
 |  |  | 0.2 | 1 | 3 | 12 | 28 | 48