tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 163956d1340571197-how-to-use-conditional-formatting-on-a-series-of-3-cells-based-on-3-different-criteria-weekly-and-daily-rosters-example-bvj-
Sheet: Monday

 | DAILY ROSTERS
 |  |  | WEEK 1 |  |  | DATE :
 | Morning Shift |  |  |  |  |  |  |  |  |  |  | The "FOOD PREP" String can begin with either two people starting at the same time or two people starting at different times.
 |  |  |  |  |  |  |  |  |  |  |  | The second row for "FOOD PREP" is where the PM (ie. The shift not starting at 6:30/7:30)
 | TEAM LEADER
 |  |  |  |  |  |  |  |  |  |  |  | Basically, Top row = Both the morning starters in time order (if they start at different times) or in any order (if both start at the same time).
 | BUFFET |  |  | - |  |  |  | -
 | LG1 |  |  | - |  |  |  | -
 | LG2 |  |  | - |  |  |  | -
 | LG3 |  |  | - |  |  |  | -
 | LG4 |  |  | - |  |  |  | -
 | BARRISTA |  |  | - |  |  |  | -
 | DISHES |  |  | - |  |  |  | -
 | DISHES 2 |  |  | - |  |  |  | -
 | FOOD PREP |  |  | - |  |  |  | -
 | FOOD PREP |  |  | - |  |  |  | -
 | CHAIRMANS |  |  | - |  |  |  | -
 | [NAME]
 | TEAM LEADER
 | BUFFET |  |  | - |  |  |  | -
 | LG1 |  |  | - |  |  |  | -
 | LG2 |  |  | - |  |  |  | -
 | LG3 |  |  | - |  |  |  | -
 | LG4 |  |  | - |  |  |  | -
 | LG5 |  |  | - |  |  |  | -
 | DISHES |  |  | - |  |  |  | -
 | BAR |  |  | - |  |  |  | -
 | BAR 2 |  |  | - |  |  |  | -
 | BAR 3 |  |  | - |  |  |  | -
 | GLASSY |  |  | - |  |  |  | -
 | CHAIRMANS |  |  | - |  |  |  | -
 | DAILY COMMENTS
 | RDO
 | LRDO
 | TRDO
Spreadsheet: 148418d1333393010-lookup-function-conditional-formatting-error-example
Sheet: Trial

 |  |  |  |  | 54-59-70-1-A |  |  |  | 54-59-70-1-B |  |  | 54-59-71-2-C |  |  | 54-59-71-2-D |  |  | 54-59-71-2-E |  |  | 54-59-71-2-F
 |  |  |  |  | 54-59-70-2-A |  |  |  | 54-59-70-2-B |  |  | 54-59-71-2-C |  |  | 54-59-71-2-D |  |  | 54-59-71-2-E |  |  | 54-59-71-2-F
 |  |  |  |  | 54-59-72-2-A |  |  |  | 54-59-72-2-B |  |  | 54-59-72-2-C |  |  | 54-59-72-2-D |  |  | 54-59-72-2-E |  |  | 54-59-72-2-F
 |  |  |  |  | 54-59-73-2-A |  |  |  | 54-59-73-2-B |  |  | 54-59-73-2-C |  |  | 54-59-73-2-D |  |  | 54-59-73-2-E |  |  | 54-59-73-2-F
 |  |  |  |  | 54-59-74-2-A |  |  |  | 54-59-74-2-B |  |  | 54-59-74-3-C |  |  | 54-59-74-3-D |  |  | 54-59-74-3-E |  |  | 54-59-74-4-F
Spreadsheet: 724790d1616388196-extract-data-using-formulas-test
Sheet: Sheet1

Table 1
Project | Target Date | Status
Project1 | 2020 1st Q | Completed
Project2 | 2021 2nd Q | Completed
Project3 | 2022 1st Q | Not Planned
Project4 | 2020 1st Q | Completed
Project5 | 2020 2nd Q | Testing
Project6 | 2021 1st Q | Not Planned
Project7 | 2022 1st Q | Testing
Project8 | 2020 1st Q | Testing
Project9 | 2020 1st Q | Completed
Project10 | 2020 1st Q | Not Planned
Project11 | 2021 2nd Q | Not Planned
Project12 | 2022 1st Q | Stopped
Project13 | 2020 2nd Q | Completed
Outcome (in another sheet)
 | No. of Projects
Target Date | Completed | Not Planned | Testing | Stopped
2020 1st Q | 3 | 1 | 1 | 0
2021 2nd Q | 1 | 0 | 1 | 0
2022 1st Q | 0 | 1 | 0 | 0
2020 2nd Q | 1 | 1 | 0 | 0
2021 1st Q | 0 | 1 | 1 | 1
Spreadsheet: 746210d1630576456-how-to-extract-date-from-middle-of-text-string-and-add-one-month-to-the-date-how-to-extract-month-from-middle-of-text-string-and-add-one-month-to-the-date
Sheet: Sheet1

Data | My attempts | Successful attempts | Year extraction | Desired Result | Extra Desired Result
Monthly ISEA Progress Report - Oct 21 |  |  |  | Oct | 2021-11-01 00:00:00
Monthly ISEA Progress Report - Nov 21 |  |  |  | Nov | 2021-12-01 00:00:00
Monthly ISEA Progress Report - Dec 21 |  |  |  | Dec | 2022-01-01 00:00:00
Monthly ISEA Progress Report Jan 22 |  |  |  | Jan | 2022-02-01 00:00:00
Monthly ISEA Progress Report - Feb 22 |  |  |  | Feb | 2022-03-01 00:00:00
 | = | Attempt I want to work but doesn't
Context:
I would like to take the month and year that is listed in the last 6 characters of these strings in column A and add one month to them.  I have tried a combination of RIGHT and [NAME] and subtraction methods but have not found a way to do it. For extra context, there is not always a " - " before the Date so using the function: =RIGHT(B5,LEN(B5)-FIND("_",B5)) will not work for all cases.
Spreadsheet: 780484d1652469072-plot-shift-in-interval-with-multiple-activities-as-per-given-duration-interval_level_shift-plotter
Sheet: Sheet1

 |  | Can be changed > | Activity Duration | 15 | 45 | 15 | 30 | 30 | 30 | 30
 |  | Can be changed > | Activity Code | B | L | B | M | M | M | M
 |  | Can be changed > | Activity Name | Break | Lunch | Break | Meeting | Meeting | Meeting | Meeting
 |  | Staff | Shift | Short Break | Lunch | Short Break | Meeting1 | Meeting2 | Meeting3 | Meeting4 | 00:00:00
 |  | A1 | 08:30 AM - 05:30 PM | 10:30:00 | 13:00:00 | 16:15:00 | 09:15:00 | 11:30:00 | 14:15:00 | 16:45:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P | M15 | M15 | P | B15 | P | M30 | P | P | L30 | L15 | M15 | P | P | P | B15 | M15 | P
 |  | A2
 |  | A3
 |  | A4
 |  |  | There can be any shift
 |  |  | Please formulate so that I only need to Put shift, luch break time and meetings
 |  |  | OR, please create a file enabled with VBA to do this task.
Spreadsheet: f7d1410f-d2ea-4c63-bab2-2a35220dd3b7
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
7550 | 7720 | Iskandar | Shakhov | RUS | 143 | 00:16:51 | 00:00:29 | 00:23:54 | 00:00:58 | 00:18:25 | 1 | 01:00:40
7550 | 46691 | Pertti | Tuomainen | FIN | 141 | 00:17:55 | 00:00:36 | 00:22:27 | 00:01:08 | 00:18:48 | 2 | [NAME]
7550 | 15682 | [NAME] | [NAME] | RUS | 142 | 00:17:52 | 00:00:46 | [NAME] | 00:01:20 | 00:17:40 | 3 | 01:02:47
7550 | 47074 | Matti | Makinen | FIN | 140 | 00:19:48 | 00:01:06 | 00:26:04 | 00:01:18 | 00:18:11 | 4 | [NAME]
7550 | 7910 | Antti | Mustonen | FIN | 0 | 00:19:13 | [NAME] | 00:29:30 | 00:02:37 | 00:20:01 | 5 | 01:12:15
Spreadsheet: 846608d1697749309-add-remove-text-from-table-after-the-cell-is-filled-with-that-text-example
Sheet: Sheet1

 |  |  | SHIFT SCHEDULE EMPLOYEE (by week)
 |  |  |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
 |  |  | Department 1 |  |  |  |  |  |  |  |  |  | List of Employee
 |  |  | Department 2 |  |  |  |  |  |  |  |  |  | Employee 1
 |  |  | Department 3 |  |  |  |  |  |  |  |  |  | Employee 2
 |  |  | Department 4 |  |  |  |  |  |  |  |  |  | Employee 3
 |  |  | Department 5 |  |  |  |  |  |  |  |  |  | Employee 4
 |  |  | Department 6 |  |  |  |  |  |  |  |  |  | Employee 5
 |  |  | Department 7 |  |  |  |  |  |  |  |  |  | Employee 6
 |  |  | Department 8 |  |  |  |  |  |  |  |  |  | Employee 7
 |  |  |  |  |  |  |  |  |  |  |  |  | Employee 8
Spreadsheet: 855940d1705385413-how-to-reference-a-list-and-add-value-help01
Sheet: Sheet1

Employee No. | Employee Name | Supervisor Employee no. | [NAME]
0001 | Kimberly | 2011 | Wing
0003 | Artichoke | 2011 | Wing
0006 | [NAME] | 2011 | Wing
0008 | [NAME] | 2011 | Wing
Spreadsheet: michelle_lokay__26703__imball0112
Sheet: NGPL

 | 52862 |  | 6828
 | Measured | Scheduled | Measured | Scheduled | Imbalance
1 | 19565 | 19737
2 | 19701 | 19737
3 | 19719 | 19737
4 | 19712 | 19737 |  | -10000 |  |  |  | Winkler/Eddy OBA |  |  |  |  |  |  | Gray  OBA
5 | 19700 | 19737 |  | -50
6 | 19696 | 19737 |  |  |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount |  | Month | Measured | Scheduled | Imbalance | Index | Amount
7 | 22849 | 22895
8 | 19738 | 19737 |  |  |  |  |  | 2001-05-01 00:00:00 | 1103057 | 1120793 |  | 4.01 |  |  | 2001-05-01 00:00:00 | -202726 | -185000 |  | 4.01 |  |  | 2001-05-01 00:00:00 | 4.01
9 | 19291 | 19737 | -10996 | -25000 |  |  |  | 2001-06-01 00:00:00 |  | 1681871 |  | 3.51 |  |  | 2001-06-01 00:00:00 | -153623 | -88473 |  | 3.51 |  |  | 2001-06-01 00:00:00 | 3.51
10 | 19791 | 19737 | -1092 | -9593 |  |  |  | 2001-07-01 00:00:00 |  | 1270571 |  | 2.94 |  |  | 2001-08-01 00:00:00 | -34269 | -27046 |  | 2.85 |  |  | 2001-07-01 00:00:00 | 2.94
11 | 39582 | 39737 | -16072 | -25000 |  |  |  | 2001-08-01 00:00:00 |  | 1418897 |  | 2.85 |  |  | 2001-09-01 00:00:00 | -1191628 | -1210937 |  | 1.96 |  |  | 2001-08-01 00:00:00 | 2.85
12 | 27328 | 27256 | -473 |  |  |  |  | 2001-09-01 00:00:00 | 1109912 | 1111335 |  | 1.96 |  |  |  |  |  |  |  |  |  | 2001-09-01 00:00:00 | 1.96
13 | 11955 | 27895 |  | -4731
14 | 22276 | 22895 |  |  |  |  |  | 5/01 - 9/01  balance |  |  |  |  |  |  | 5/01 - 9/01  balance
15 | 22817 | 22895
16 | 22888 | 22895 |  |  |  |  |  | Volume balance @ 4/30/01 |  |  | 19880 |  |  |  | Volume balance @ 4/30/01 |  |  | 37185
17 | 22877 | 22895
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  |  |  | 187363
2001-12-17 00:00:00
CBS Dollars
 |  |  | 456695.3
Spreadsheet: 105417d1302780325-any-formular-for-range-choose-example
Sheet: Sheet1

invoice No. | age | branch | NAME | name | age
1 | 30 | syd |  | A | 0-15
2 | 14 | [NAME] |  | B | 16-30
3 | 12 | adl |  | C | 31-50
4 | 15 | syd
5 | 17 | syd
6 | 38 | adl
7 | 200 | [NAME]
Spreadsheet: 268933d1380894530-fri-last-week-2-weeks-ago-6-months-ago-1-year-ago-but-if-it-falls-on-holiday-dates-formulas
Sheet: Sheet1

Date Range
Begin
End
This Weeks report (last weeks data)
Friday
Monday
1 week before
Friday
Monday
2 weeks before
Friday
Monday
6 months before
Friday
Monday
1 year ago
Friday
Monday
Spreadsheet: 549577d1511801361-why-is-there-a-variance-here-for-total-year-variance
Sheet: Sheet1

 | JAN 2017 | FEB 2017 | MAR 2017 | APR 2017 | MAY 2017 | JUN 2017 | JUL 2017 | AUG 2017 | SEP 2017 | OCT 2017 | NOV 2017 | DEC 2017 | TOTAL 2017
Employee A | 742666.1233410082 | 813949.0005859714 | 953371.2315528995 | 799387.5319462308 | 822508.4119924988 | 955488.5257095351 | 785237.7277418305 | 746465.5188081894 | 982699.0170330144 | 807691.8904049682 | 733537.5393582032 | 1007731.421170712 | 10150733.93964505
Employee B | 306911.0468597781 | 318286.7646447081 | 397916.7891392176 | 318286.7646447081 | 314331.5713007081 | 389998.1223481076 | 311951.8312118194 | 311951.8312118194 | 389998.1223481076 | 311951.8312118194 | 318286.7646447081 | 420668.2247090803 | 4110539.664274597
% Employee A
Total Benefits | 242877.8828025221 | 236799.8103224953 | 288707.8149107003 | 246898.6837987141 | 230567.4859968615 | 282583.1754817075 | 227069.7419900518 | 205134.7433238657 | 273871.938356843 | 218551.2100150433 | 211511.4025813499 | 296022.3640098977 | 2960596.253590052
Employee A Allocated Benefits
Spreadsheet: stacey_white__38805__Flex Schedule Calendar
Sheet: Nov-01

NOVEMBER 2001
 | 29 |  | 30 |  | 31 |  | 1 | [NAME] | 2
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Israel
 |  |  |  |  |  | NO ONE OFF
 |  |  |  |  |  | OR EARLY
 |  |  |  |  |  |  |  | Warrick 1/2 day------
 |  |  |  |  |  |  |  | JP-Vacation----------
[NAME] | 5 | [NAME] | 6 | [NAME] | 7 | [NAME] | 8 | J.P. | 9
[NAME] |  | Israel |  | Warrick |  | [NAME] |  | [NAME]
Warrick |  | [NAME] |  | [NAME] |  | Warrick |  | Israel
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Casey-Vacation-------
 |  |  |  |  |  |  |  | [NAME]
J.P. | 12 | [NAME] | 13 | J.P. | 14 | [NAME] | 15 | J.P. | 16
[NAME] |  | Israel |  | [NAME] |  | Warrick |  | [NAME]
Warrick |  | [NAME] |  | Israel |  | [NAME] |  | [NAME]
[NAME]
 |  |  |  |  |  |  |  | Warrick 1/2 day------
 |  |  |  |  |  |  |  | Israel-Vacation------
Casey-Vacation------- |  |  |  |  |  |  |  | [NAME]
[NAME] |  | -------------------------- |  | -------------------------- |  | -------------------------- |  | ------------------------
[NAME] | 19 | [NAME] | 20 | Everyone stays | 21 |  | 22 |  | 23
J.P. |  | J.P. |  | until we're done
[NAME] |  | [NAME] |  | (which should hopefully
Warrick |  | Israel |  | be early anyway!) |  | HOLIDAY |  | HOLIDAY
[NAME] |  | -------------------------- |  | ------------------------
Casey-Vacation------- |  | -------------------------- |  | ------------------------
[NAME]-Vacation------- |  | -------------------------- |  | ------------------------
[NAME] | 26 | [NAME] | 27 | [NAME] | 28 | J.P. | 29 |  | 30
Warrick |  | J.P. |  | [NAME] |  | [NAME]
[NAME] |  | Israel |  | Israel |  | Warrick |  | NO ONE OFF
 |  |  |  |  |  |  |  | OR EARLY
Israel-Vacation------
* If your name is listed that means you are working late that day (whatever 'late' means!)
[NAME]
[NAME]
J.P.
[NAME]
Warrick
[NAME]
Israel
[NAME]
Spreadsheet: 767894d1644700852-incorporating-cash-receipts-in-a-sales-spreadsheet-sales-receipts-spreadsheet
Sheet: Sheet1

Sales
Date | Invoice # | Project | Customer | Amt Inv | Source of check | Ch # | Amt Rec | Balance
2022-01-24 00:00:00 | 12345 | xxxx | xxxx | 1500 | xxxxx | xxxxx
2022-01-25 00:00:00 | 12346 | xxxx | xxxx | 250 |  |  | 250
2022-01-26 00:00:00 | 12347 | xxxx | xxxx | 550 |  |  | 450
2022-01-28 00:00:00 | 12348 | xxxx | xxxx | 263
This is what I have now.
From the receipts listing below, the amount received is added for the invoice being paid to F2 etc (above) as received by different payors for same customer.
What I would like to do is input the receipts below into the above table so the amt received would allocate to the same invoice number and give the updated balance.
Receipts
Date | Invoice # | Project | Payor | Amt Rec
2022-01-30 00:00:00 | 12345 | xxxx | ABC | 250
2022-02-02 00:00:00 | 12346 | xxxx | DEF | 250
2022-02-03 00:00:00 | 12345 | xxxx | GHI | 500
2022-02-04 00:00:00 | 12348 | xxxx | QRS | 263
Spreadsheet: andy_zipper__192__DYNEGY-ICE VOL May22
Sheet: Enron Activity - Dynegy Direct

DYNEGY DIRECT
Transactions and Notional Volume
By Enron Entity, Commodity, and [NAME]
Note: Total Activity for Dynegy Direct is not available, therefore Enron's percentage can not be calculated
Enron North America - Dynegy Direct |  |  |  |  | Enron Power Marketing - Dynegy Direct |  |  |  |  | Enron Global Liquids - Dynegy Direct
 |  | Data |  |  |  |  | Data |  |  |  |  | Data
Major Commodity | Enron Trader | Transactions | Notional Volume |  | Major Commodity | Enron Trader | Transactions | Notional Volume |  | Major Commodity | Enron Trader | Transactions | Notional Volume
US Natural Gas | [NAME] | 2 | 10000 |  | Power | [NAME] | 1 | 800 |  | No Activity | No Activity | 1 | 0
US Natural Gas Total |  | 2 | 10000 |  | Power Total |  | 1 | 800 |  | No Activity Total |  | 1 | 0
Grand Total |  | 2 | 10000 |  | Grand Total |  | 1 | 800 |  | Grand Total |  | 1 | 0
Spreadsheet: 820740d1678277075-counting-available-beds-in-a-facility-new-sample
Sheet: Tabelle1

 | Room | Sex | Name | Infos | Planning |  | Available Beds
 | 1
 | 2 |  |  |  | 2023/03/10 New Patient |  | Female
 | 2 | f | Mrs. [NAME]
 | 3
 | 3 |  |  |  |  |  | Male
 | 4
 | 4 | m | Mr XY
 | 5 |  |  |  |  |  | Unisex
 | 6
 | 7 |  |  |  | 2023/03/10 New Patient
 | 7
Spreadsheet: ca1463a6-c7a8-409d-96ed-ef640443c41c
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
[NAME]
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 20 | 7954 | 7906 | 7448 | 6720
20 - 25 | 2992 | 1623 | 1736 | 1772
25 - 35 | 6010 | 5766 | 4359 | 3421
35 - 55 | 17127 | 15379 | 12987 | 11498
55 - 67 | 10382 | 11444 | 11379 | 10768
67 und mehr | 13676 | 13656 | 14834 | 15489
Insgesamt | 58141 | 55774 | 52743 | 49668
%
unter 20 | 13.68053525051169 | 14.17506364972926 | 14.12130519689817 | 13.529838125151
20 - 25 | 5.146110318019986 | 2.909958044967189 | 3.291432038374761 | 3.567689458001127
25 - 35 | 10.33693950912437 | 10.33815039265608 | 8.26460383368409 | 6.887734557461545
35 - 55 | 29.45769766601882 | 27.57377989744325 | 24.62317274330243 | 23.14971410163486
55 - 67 | 17.85659001393165 | 20.51852117474092 | 21.57442693817189 | 21.67995490053958
67 und mehr | 23.52212724239349 | 24.4845268404633 | 28.12505924956866 | 31.18506885721189
Insgesamt | 100 | 100 | 100 | 100
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: dutch_quigley__9378__modeldutch
Sheet: Opt

Options
 | skew | Delivey | Volume | Toggle |  | Int | DF | Expiration | Days to | Mid | Price | Mid | Vol | new Call 1 | new Put 1 | new Call 2 | New Put 2 | Call 1 | Put 1 | Call 2 | Put 2 | Call 1 | Put 1 | Call 2 | Put 2 | Call 1 | Put 1 | Call 2 | Put 2 | Call 1 | Put 1 | Call 2 | Put 2 | Int Rate | Disc
 | # | Month |  |  |  | Rate |  | Date | [NAME] | Price | Used | Vol | Used |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Factor
 | 1
Spreadsheet: 851721d1701879000-need-help-converting-a-google-sheets-formula-to-excel-scheduling-test1
Sheet: Calculations

HS | Boards | SQFT | [NAME] = sign when pasting
No Smoothing | 90 | 2880 | (((F4*G4)/144)*E4)/(IF(J4=Calculations!$A2,Calculations!$C$2,IF(J4=Calculations!$A$3,Calculations!$C$3,IF(J4=Calculations!$A$4,Calculations!$C$4,IF(J4=Calculations!$A$5,Calculations!$C$5,IF(J4=Calculations!$A$6,Calculations!$C$6,IF(J4=Calculations!$A$7,Calculations!$C$7)))))))*I4+0.2
Light Smoothing | 60 | 1920
Heavy Smoothing | 40 | 1280
[NAME] | 30 | 960
[NAME] | 20 | 640
[NAME] | 15 | 480
[NAME] |  |  | [NAME] = sign when pasting
2 Pass |  | 2880 | (((F7*G7)/144)*E7)/(IF(J7=Calculations!$A$11,Calculations!$C$11,IF(J7=Calculations!$A$12,Calculations!$C$12,IF(J7=Calculations!$A$13,Calculations!$C$13,IF(J7=Calculations!$A$14,Calculations!$C$14,IF(J7=Calculations!$A$15,Calculations!$C$15,IF(J7=Calculations!$A$16,Calculations!$C$16,IF(J7=Calculations!$A$17,Calculations!$C$17,IF(J7=Calculations!$A$18,Calculations!$C$18,IF(J7=Calculations!$A$19,Calculations!$C$19,IF(J7=Calculations!$A$20,Calculations!$C$20,IF(J7=Calculations!$A$21,Calculations!$C$21)))))))))))))*I4+0.2
3 Pass |  | 1920
4 Pass |  | 1280
Backlit |  | 960
DS |  | 960
FU or [NAME] |  | 640
DS White |  | 480
8 Pass |  | 640
8 Pass + White |  | 480
5 Layer |  | 240
 |  | 640
3Rs | SQFT |  | [NAME] = sign when pasting
2 Pass | 1784 |  | (((F4*G4)/144)*E4)/(IF(J4=Calculations!$A$24,Calculations!$B$24,IF(J4=Calculations!$A$25,Calculations!$B$25,IF(J4=Calculations!$A$26,Calculations!$B$26,IF(J4=Calculations!$A$27,Calculations!$B$27,IF(J4=Calculations!$A$28,Calculations!$B$28))))))*I4+0.2
3 Pass | 1254
5-Pass | 704
Backlit | 241
2-Sided | 330
GS | Boards | SQFT | [NAME] = sign when pasting
Light Smoothing | 25 | 800 | (((F5*G5)/144)*E5)/(IF(J5=Calculations!$A$11,Calculations!$C$11,IF(J5=Calculations!$A$12,Calculations!$C$12,IF(J5=Calculations!$A$13,Calculations!$C$13,IF(J5=Calculations!$A$14,Calculations!$C$14,IF(J5=Calculations!$A$15,Calculations!$C$15,IF(J5=Calculations!$A$16,Calculations!$C$16,IF(J5=Calculations!$A$17,Calculations!$C$17))))))))*I5+0.2
Heavy Smoothing | 15 | 480
[NAME] | 10 | 320
[NAME] | 10 | 320
[NAME] | 6 | 192
#REF! | gs
#REF! | hs
#REF! | 3r
#REF! | tauro
Spreadsheet: 860785d1708780377-countifs-sumifs-help-book3_2
Sheet: RawData

Project | Contact | Task | Confidence
Applesauce | Logistics | Task_51 | Missed
Applesauce | Logistics | Task_52 | Missed
Applesauce | Logistics | Task_53 | Complete
Applesauce | Logistics | Task_54 | Low
Applesauce | Logistics | Task_55 | Medium
Applesauce | Logistics | Task_56 | Low
Applesauce | Logistics | Task_57 | High
Applesauce | Tech Support | Task_58 | High
Applesauce | Tech Support | Task_59 | High
Applesauce | Tech Support | Task_60 | High
Applesauce | Tech Support | Task_61 | Low
Applesauce | Tech Support | Task_62 | Medium
Applesauce | Tech Support | Task_63 | Missed
Applesauce | Tech Support | Task_64 | Complete
Applesauce | Corporate | Task_65 | Complete
Applesauce | Corporate | Task_66 | Missed
Applesauce | Corporate | Task_67 | Missed
Applesauce | Corporate | Task_68 | Medium
Applesauce | Corporate | Task_69 | Low
Applesauce | Corporate | Task_70 | Low
Applesauce | Corporate | Task_71 | High
Applesauce | Sales | Task_72 | Medium
Applesauce | Sales | Task_73 | Medium
Applesauce | Sales | Task_74 | Low
Applesauce | Sales | Task_75 | High
Applesauce | Sales | [NAME] | Complete
Applesauce | Sales | Task_77 | Missed
Applesauce | Sales | Task_78 | Missed
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Count of Confidence | Column Labels
 | Complete | High | Medium | Low | Missed |  |  | Complete | High | Medium | Low | Missed |  | Row Labels | Complete | High | Low | Medium | Missed
Logistics |  |  |  |  |  |  | Logistics |  |  |  |  |  |  | Corporate | 1 | 1 | 2 | 1 | 2
Tech Support |  |  |  |  |  |  | Tech Support |  |  |  |  |  |  | Logistics | 1 | 1 | 2 | 1 | 2
Corporate |  |  |  |  |  |  | Corporate |  |  |  |  |  |  | Sales | 1 | 1 | 1 | 2 | 2
Sales |  |  |  |  |  |  | Sales |  |  |  |  |  |  | Tech Support | 1 | 3 | 1 | 1 | 1
 | countif |  |  |  |  |  | sumproduct |  |  |  |  |  |  | pivot table
Spreadsheet: jeff_dasovich__14133__LoadResource3
Sheet: _udcgen1999

RDI PowerDat |  |  |  |  |  |  |  |  |  |  | Based on most recent data available (RDI, Kristian's PG&E Hydro, or UMFOR)
Company Name |  | Year | Steam | Nuclear | Hydro | Pumped Sto | Other | less MWh for PS | Net [NAME] MWh |  | Hydro | Therm
Pacific Gas & Electric Co. |  | 1999 | 3289574 | 16640744 | 12640817 | 874038 | 1642848 | -1253390 | 33834631
San Diego Gas & Electric Co. |  | 1999 | 1702273 | 3331248 | 0 | 0 | 31584 | 0 | 5065105 |  | 0
Southern California Edison Co. |  | 1999 | 10670686 | 17300552 | 4177638 | 329000 | 28765 | -123505 | 32383136
 |  |  |  |  | AVERAGE GENERATION BY MONTH (MW)
 |  |  |  |  | PG&E |  | SCE |  | SDGE |  | TOTAL
 |  |  | [NAME] |  | Therm + QF | Hydro | Therm | Hydro | Therm | Hydro | UDCs
 |  | 1 |  |  |  |  |  |  |  | 0
 |  | 2 |  |  |  |  |  |  |  | 0
 |  | 3 |  |  |  |  |  |  |  | 0
 |  | 4 |  |  |  |  |  |  |  | 0
 |  | 5 |  |  |  |  |  |  |  | 0
 |  | 6 |  |  |  |  |  |  |  | 0
 |  | 7 |  |  |  |  |  |  |  | 0
 |  | 8 |  |  |  |  |  |  |  | 0
 |  | 9 |  |  |  |  |  |  |  | 0
 |  | 10 |  |  |  |  |  |  |  | 0
 |  | 11 |  |  |  |  |  |  |  | 0
 |  | 12 |  |  |  |  |  |  |  | 0
PG&E Hydro Gen (data from Kristian) |  |  |  |  |  |  |  | total MWh generated (close to RDI)
 | HOURS |  |  |  |  |  | Hydro Shape | 13391819 |  |  | Average Generation (MW) |  |  | QF Purchases 7/98-6/99
 | 744 | 1 | 1999 | 78043 | 9682
 | 672 | 2 | 1999 | 77960 | 33304
 | 744 | 3 | 1999 | 97587 | 56813
 | 720 | 4 | 1999 | 86417 | 60630
 | 744 | 5 | 1999 | 97111 | 102675
 | 720 | 6 | 1999 | 94500 | 149595
 | 744 | 7 | 1999 | 89852 | 135417
 | 744 | 8 | 1999 | 91255 | 145973
 | 720 | 9 | 1999 | 54780 | 153365
 | 744 | 10 | 1999 | 54522 | 78604
 | 720 | 11 | 1998 | 55921 | 76366
 | 744 | 12 | 1998 | 82569 | 98937
SCE Monthly [NAME] from UMFOR |  |  |  |  |  |  |  |  |  | Average Generation (MW)
 |  |  |  | Coal | Nuclear | Hydro | Other | Total |  | Hydro | Therm |  | [NAME] (Apply to PG&E and SDGE therms)
 | 744 | 1 | 2000 | 954054 | 1626323 | 106282 | 2357
 | 696 | 2 | 2000 | 929842 | 1574266 | 164258 | 2679
 | 744 | 3 | 2000 | 936421 | 1684376 | 461761 | 1921
 | 720 | 4 | 2000
 | 744 | 5 | 2000 | 761578 | 1656194 | 706923 | 2459
 | 720 | 6 | 2000 | 1006842 | 1621536 | 689069 | 2539
 | 744 | 7 | 2000 | 1010592 | 1672852 | 486242 | 2855
 | 744 | 8 | 2000 | 1013320 | 1656193 | 359623 | 2920
 | 720 | 9 | 1999 |  | 1629816 | 390674 | 2462
 | 744 | 10 | 1999 | 913278 | 1539553 | 274789 | 2439
 | 720 | 11 | 1999 | 914420 | 1584834 | 173744 | 2246
 | 744 | 12 | 1999 | 860968 | 1678771 | 178456 | 2209
Spreadsheet: 751175d1633953027-assigning-stock-to-a-location-depending-on-input-criteria-new-excel-forum
Sheet: Stock List

Date | Time (UTC) | Action | Product | Amount | Shop |  | Action | Product | Amount | Shop
2021-10-10 00:00:00 | 10:10:00 | Buy | Oranges | 15 | Shop3 |  | Sell | Oranges | 5 | Shop 2
2021-10-11 00:00:00 | 11:10:00 | Buy | Apple | 1 | Shop2 |  | Sell | Apple | 1 | Shop1
2021-10-12 00:00:00 | 12:10:00 | Buy | Oranges | 5 | Shop1 |  | Sell | Pear | 5 | Shop 3
2021-10-13 00:00:00 | 13:10:00